{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["User ReadMe","OrderForm","Polaris ReadMe","Scratch"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User ReadMe","index":0,"n_rows":71,"n_cols":18,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SAE Order Form How To",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polaris Industries"]
[]
[]
[null,"Placing an Order",null,null,null,null,null,null,null,null,null,null,"Order Form Features"]
[]
[null,"Step 1:","Fill out the appropriate information relating to Order and Shipping details.",null,null,null,null,null,null,null,null,null,"Adding Rows:",null,"Rows can be added to the order form via the add row button. The number of"]
[null,null,"If these sections are not filled out, your order form will no longer be processed.",null,null,null,null,null,null,null,null,null,null,null,"rows added will be based on the quantity input to the spreadsheet. All rows"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"will be added to the end of the document and will not affect any information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"already entered. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Removing Rows:",null,"Rows that are unused can be removed using the condense button. This"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"button removes all unused rows regardless of their location.  "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Clearing Order:",null,"If you would like to remove all information present in order form you can "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"press the clear contents button. This will remove all user input information "]
[null,null,"Note: Before placing a parts order you must have received confirmation that your ",null,null,null,null,null,null,null,null,null,null,null,"from the sheet including Order and Shipping details."]
[null,null,"sponsorship request has been received and processed. If you have not submitted "]
[null,null,"the necessary documentation, please visit the Polaris Sponsorship Website and  "]
[null,null,"follow the instructions."]
[]
[null,"Step 2:","Fill out the parts section.  The only information needed by polaris is the Part Number and the Qty.",null,null,null,null,null,null,null,null,null,null,null,"Note: This does not return an order that was already processed into an "]
[null,null,"If you would like to fill out a description this is strictly for your benefit. The prices are locked",null,null,null,null,null,null,null,null,null,null,null,"invoice into its orginal order form status. "]
[null,null,"from editing by default.  These values will be filled in by Polaris when your order is processed."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Get Started"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"To get started, please select the Order From Tab on this workbook."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Note: Do not place anything else in the PN column other than the 7 digit Polaris PN"]
[null,null,"plus the 3 digit size/color code if applicable."]
[]
[null,null,null,"Acceptable PN's",null,1204365,"or ","5367989-250"]
[]
[]
[null,"Step 3:","Save your order form in the following format.  Order forms not following this format will be returned "]
[null,null,"for correction.  SchoolName_Order_OrderNumber"]
[]
[null,null,null,"Example:",null,"Iowa_State_University_Order_1.xlsm"]
[]
[null,"Step 4:","Send your completed order form to Polaris via the sponsorship email address provided in this order form."]
[null,null,"We will return an invoice with the total charges. When you have received our invoice you may send a "]
[null,null,"check to complete your order. Checks are the only acceptable method of payment at this time."]
[]
[]
[]
[null,"Order Timing"]
[]
[null,"Orders will be processed on a first come first serve basis.  Generally orders are processed within 5-10 days "]
[null,"from the time they are received. "]

{"sheet":"OrderForm","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,47,6],[10,2,10,3],[12,2,12,3],[11,2,11,3],[0,0,0,4],[0,5,0,6],[14,2,14,3],[17,4,17,7],[33,3,33,4],[3,5,3,6],[15,2,15,3],[4,5,4,6],[3,2,3,3],[5,5,5,6],[11,5,11,6],[16,2,16,3],[4,2,4,3],[5,2,5,3],[9,2,9,3],[8,2,8,3]]}
["Parts Order Form"]
[]
[null,null,"Order Information"]
[null,"University:",null,null,null,"For Polaris Use"]
[null,"Ordered By:",null,null,null,"Account "]
[null,"Email:"]
[]
[null,null,"Shipping Information"]
[null,"Ship to:"]
[null,"Attention:"]
[null,"Street:"]
[]
[null,"City State Zip:"]
[]
[null,null,"Email Order Form to"]
[null,null,"polaris.support@polaris.com"]
[null,null,"for approval."]
[null,null,null,null,"Polaris Use Only"]
["Item","Part Number","Description","Qty.","Price Each","Total","Retail Price","Retail Total"]
[]
[1,7195399,"Decal-Hood Top",2,0,0,0,0]
[2,5269901,"Decal-Polaris Star",2,0,0,0,0]
[3,null,null,null,0,0,0,0]
[4,null,null,null,0,0,0,0]
[5,null,null,null,0,0,0,0]
[6,null,null,null,0,0,0,0]
[7,null,null,null,0,0,0,0]
[8,null,null,null,0,0,0,0]
[9,null,null,null,0,0,0,0]
[10,null,null,null,0,0,0,0]
[11,null,null,null,0,0,0,0]
[12,null,null,null,0,0,0,0]
[13,"-----------","Shipping and Handling",null,0,0]
[null,null,"Quantity of Rows to Add ","Total",null,0,null,0]
[null,null,10]
[]
[]
[]
[]
[]
["Order must be paid in full by check or money order before parts will ship. \nAt this time we do not accept credit cards or purchase orders, and checks are to be paid in USD.\nChecks must be made payable to Polaris Industries and mailed directly to:\n\nPolaris Industries\nAttn: SAE Support\n7290 East Viking Boulevard\nWyoming, MN 55092"]

{"sheet":"Polaris ReadMe","index":2,"n_rows":187,"n_cols":15,"rows_kept":187,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Polaris Users Guide"]
[]
[]
[null,"Processing Orders",null,null,null,null,null,null,null,null,"Generating Invoice"]
[]
[null,"Step 1:","Make sure that all the necessary information is filled out. If it is not send the ",null,null,null,null,null,null,null,"Step 8:","The final step is to generate the invoice and send this information back to the team."]
[null,null,"form back to the university to have them fix it. We will no longer be ",null,null,null,null,null,null,null,null,"Before generating the invoice save the order under an new name. Click Save As"]
[null,null,"processing incomplete order forms.  ",null,null,null,null,null,null,null,null,"and replace order in the name with invoice. "]
[]
[null,null,"This includes all the details under the Order Information and Shipping ",null,null,null,null,null,null,null,null,null,"Example:",null,"Iowa_State_University_Invoice_1.xlsm"]
[null,null,"Information sections.  As shown below."]
[null,null,null,null,null,null,null,null,null,null,null,"Then click the generate invoice button on the options menu as shown below. "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"This will add the shipping and the total as well as remove the unecessary information "]
[null,null,"Note: ","You must also check that the team is approved to place ",null,null,null,null,null,null,null,"from the Query. Resave this document and place on SharePoint. Send this"]
[null,null,null,"orders on the SAE Orders excel document. ",null,null,null,null,null,null,null,"information to the team and update the SAE orders excel with the current date."]
[null,null,null,null,null,null,null,null,null,null,null,"This completes the processing order portion."]
[null,"Step 2: ","Unlock the spreadsheet for Polaris use by pressing the Polaris Use Only "]
[null,null,"button and entering the correct password. The password will be given to you"]
[null,null,"by a previous volunteer. This will bring up the options menu shown below.",null,null,null,null,null,null,null,"Invoice Paid"]
[]
[null,null,null,null,null,null,null,null,null,null,"Step 9:","Once we have received a check for the teams each of the invoices need to be"]
[null,null,null,null,null,null,null,null,null,null,null,"updated to reflect that they have been paid.  In order to do this unlock the"]
[null,null,null,null,null,null,null,null,null,null,null,"workbook similarly to what was done in step 2, then under the options menu"]
[null,null,null,null,null,null,null,null,null,null,null,"press the Invoice Paid button. This should update the invoice to reflect that "]
[null,null,null,null,null,null,null,null,null,null,null,"we have received the teams check. "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 3:","Once you have the options menu displayed you will click the prepare"]
[null,null,"order button. This will rearrange the PN, check for duplicates, and remove "]
[null,null,"unused rows. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 4:","Next you will press the remove duplicates button if the program has highlighted "]
[null,null,"any duplicate PN's. This will remove the duplicates and update the qty to reflect"]
[null,null,"both entries. "]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 5: ","Next you will print a text file to your desktop for use by Showcase Query. Before"]
[null,null,"pressing the printing to query button you need to ensure that you have a text file"]
[null,null,"already on your desktop with the appropriate name. This will be your Name.txt"]
[]
[null,null,null,null,"Example: ","Welch.txt"]
[]
[null,null,"Once you have a named text file you will press the print to query button. This"]
[null,null,"will pull up the following menu of users who are currently setup to process orders."]
[null,null,"If your name is not shown please contact Austin Welch. Select the correct user"]
[null,null,"and the text file will be created.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Note: You will only need to set up a text file the first time you process orders."]
[null,null,"The text file is re-written with every processed order. "]
[]
[]
[null,"Step 6:","Open Showcase Query and select Run Query as shown below. If showcase is set "]
[null,null,"up correctly, it should automatically pull PN's from the generated text file."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Move all PN's over from entered values to selected values. You can not press ctrl+A"]
[null,null,"to select all you must select the first number scroll to the bottom, press shift, and "]
[null,null,"select the last number. Than you can move them all over to the selected values as "]
[null,null,"shown below. Finally click ok to run the query."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 7:","Once you have submitted the job to the Query, wait a few second and retrieve the results. "]
[null,null,"If results are not available right away, wait a few seconds and try again."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Once results are retrieved, copy and paste all the results over to the order form. This time"]
[null,null,"ctrl+a can be used to select all and then ctrl+c to copy.  Paste the results under the newly "]
[null,null,"created headers to the right of the price area on the order form as shown below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Likely, the amount of information you paste in is much greater than the number of parts in "]
[null,null,"the order form. In order to remove all the unnecessary information and check the status"]
[null,null,"of all the parts press the Analyze Query button. "]
[]
[]
[]
[]
[]
[]
[null,null,"This will fill in the prices, both retail and discount, as well as check if the parts are in stock,"]
[null,null,"if the qty the team has selected is valid, and if the part number we have in each row"]
[null,null,"matches what the team has supplied.  This is done to ensure the correct qty and price"]
[null,null,"is used to calculate the total."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The final order should look similar to the picture above. This is what you will save and"]
[null,null,"place on the SAE sharepoint as the teams order.  "]

{"sheet":"Scratch","index":3,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,5,0,6],[4,2,4,3],[5,2,5,3],[6,2,6,3],[0,0,0,4],[1,0,1,5],[8,2,8,3],[35,2,35,3],[15,2,15,3],[34,2,34,3],[40,5,40,6],[38,5,38,6],[10,2,10,3],[11,2,11,3],[9,2,9,3],[19,0,19,2],[39,5,39,6],[36,2,36,3],[21,0,28,6],[16,2,16,3],[14,2,14,3]]}
["Proforma Invoice #",null,null,null,null,{"$f":"INT(TODAY())","v":45223}]
["         Parts Order Form"]
[]
[]
[null,null,"Payment Information"]
[null,null,"Pre-payment by check is required on all orders."]
[null,null,"Please make checks payable to Polaris Industries."]
[]
[null,"Ship To:","Polaris Industries"]
[null,"Street:","7290 East Viking Boulevard"]
[null,"City, Zip:","Wyoming, MN 55092"]
[null,"Attention:","SAE Support"]
[]
[]
[null,null,"Email Order Form to"]
[null,null,"polaris.support@polaris.com"]
[null,null,"for approval."]
[]
[]
["Federal ID #41-1857431"]
[]
["Order must be paid in full by check or money order before parts will ship. \nAt this time we do not accept credit cards or purchase orders, and checks are to be paid in USD.\nChecks must be made payable to Polaris Industries and mailed directly to:\n\nPolaris Industries\nAttn: SAE Support\n7290 East Viking Boulevard\nWyoming, MN 55092"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Order Approved"]
[null,null,"Paid In Full"]
[null,null,{"$f":"TODAY()","v":"2023-10-24"}]
[]
[null,null,null,null,null,"For Polaris Use"]
[null,null,null,null,null,"Account #"]
[null,null,null,null,null,"723-6810"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"LEFT(B46,7)","v":""}]