90 likes | 248 Views
TDA Project Manager. Additional information for Dealers: How to set dealer margin. Step 1: Determine excel file status. Check that “Panasonic” appears in worksheet menu bar. If it does: Skip and Go to Step 5 If it does not: Go to Step 2. Step 2: Enable all macros.
E N D
TDA Project Manager Additional information for Dealers: How to set dealer margin
Step 1: Determine excel file status Check that “Panasonic” appears in worksheet menu bar If it does: Skip and Go to Step 5 If it does not: Go to Step 2
Step 2: Enable all macros (Adding the “Panasonic” option the worksheet menu bar) • Click: Tools. • Click: Options: • Click Security • Click “Macro Security”
Step 3: Enable all macros (Adding the “Panasonic” option the worksheet menu bar (cont’d)) • Select security level “Low” • Click “OK” twice
Step 4: Saving changes Save File under different filename Close file Re-open new filename
Step 5: Shows all tabs Click on “Panasonic” in worksheet menu bar Click on “Show”
Step 6: Shows all tabs (Cont’d) Step 6: Shows all tabs (Cont’d) Enter TDA1234 in password field Enter TDA1234 in password field
Step 7: Selecting Dealer data Select desired tab: 30PL_DLR: holds margin data for TDA15/30 100PL_DLR: holds margin data for TDA100/200.
Step 8: Entering Dealer margin Enter Dealer rebate percentage After quote completion, dealer rebate value will be seen at the bottom of the same screen