{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INSTRUCTIONS","Requestor","Packing List","Invoice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"INSTRUCTIONS","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["1.       Start by filling out the Requestor tab. The address where the robot will be picked up from as well as your contact information. The destination address will be provided to you by FIRST in an email and you will have to fill that out as well."]
["Some of the information on this tab (for example the addresses) will automatically transfer over to the Invoice and Packing list."]
["·         Some countries will require an additional document called Certificate of Origin in order to ship internationally. Please work with your Customs Broker for more information or to obtain this document which will accompany your shipment. "]
["·         Robot value - this is the total cost of any items from the Kit of Parts used and any additional parts that your team has purchased. Use the BOM worksheet to calculate the total value of your robot."]
[]
["2.       Next, you need to fill out the Packing List tab. You are only allowed  to ship your Robot and related spare parts. For your convenience, we have filled out the information about your robot but you are responsible for proper classification of any additional items.  If you are shipping only the robot inside the crate, you do not need to fill out anything in the Packing list tab. A robot is considered one completely assembled unit. Any spare mechanisms or items must be listed separately."]
["·         Country of Origin for Robot or other assembled items- this will be your home country"]
["·         Country of Origin for any additional individual items - the country name will be marked on the item, but if it is not, consult the manufacturer of that item"]
["·         Remember that every item inside the crate has to be noted on the Packing List. The robot transportation exemption is only intended for transporting your robot. However, if you must include spare parts relating to the robot, they must also be declared on your Customs paperwork to include the following details: Description, Value, Country of Origin, Harmonized Tariff Schedule (HTS) number (the HTS number 8479.90.0000 can be used for spare parts), etc.  Anything you pack in the crate on Export must also be included upon Import back into your home country because the entire shipment is declared a Temporary Export. FIRST is not responsible for any items that are not declared or confiscated by Customs."]
[]
["3.       Move onto the Invoice tab. Most fields will be filled out already, but it is your respsonsibility to make sure it is correct."]
["·         If any additional items were noted on the Packing list, they will automatically transfer onto the Invoice table. You will only need to fill out the Quantity and Unit Price per item."]
["·         If you are a Canadian team, shipping internationally and your shipment total is over $1600 (CAD), you need to fill out a special Canadian Customs Invoice, which is not included here. You need to work with your Customs Broker to obtain and complete it. If the shipment total value is below $1600 (CAD), you can use the generic Invoice included here"]
[]
["4.       Go back to the Requestor tab. Click on the macro button in the upper right-hand corner of the sheet that says “From Home to Regional”. Then go to the Packing list- print 4 copies and sign and date (today’s date). Then to the Invoice tab-print 4 copies, and sign and date (todays’ date)."]
[]
["6.       Go back to the Requestor tab and click on the macro button that says “ From Regional to Home”- this will populate the necessary fields with the correct return information for the return shipment (so you don’t have to do it manually). Go to the Packing list print 4 copies and sign and date (last day of your Regional). Then to the Invoice tab-print 4 copies, and sign and date (last day of your Regional)."]
[]
["7.       When finished, you should have the following documents in your hand:"]
["Ø  Invoice to Regional"]
["Ø  Packing List to Regional"]
["Ø  Invoice to Home"]
["Ø  Packing List to Home"]
[]
["8.       Scan a copy of both sets of paperwork with your signatures on it- To Regional and To Home. You are required to send a copy of both sets of paperwork to frclogistics@firstinsipres.org a week before your scheduled ship date."]
["·         Keep one (1) copy for your records."]
["·         The other (3) copies of your To Regional paperwork have to be attached to the crate. Affix sheets of clear plastic or a sturdy sheet protector securely to the outside of your crate for a place to put the shipping documents. Put the Invoice and Packing list inside the protective sleeve, with the Invoice showing and the Packing List directly behind the Invoice. "]
["·         Bring the (3) copies of your To Home paperwork with you to the competition. At the end of your event, place the To Home shipping paperwork in an envelope and attach it to the outside of the crate. Failure to do this may result in lost or delayed robots, due to missing or ripped shipping documents."]

{"sheet":"Requestor","index":1,"n_rows":66,"n_cols":28,"rows_kept":66,"cut":false,"hidden":false,"merged":[[33,0,34,0],[0,25,0,28],[8,25,8,28],[17,25,17,26]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","Packing List"]
["What is your home school/team address?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"IF(Requestor!B2=0,\" \",Requestor!B2)","v":" "},null,{"$f":"IF(Requestor!B18=0,\" \",Requestor!B18)","v":"FIRST"}]
[null,"School / Team Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B4=0,\" \",Requestor!B4)","v":" "},null,{"$f":"IF(Requestor!B20=0,\" \",Requestor!B20)","v":"200 Bedford St"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B6=0,IF(Requestor!B8=0, \" \",Requestor!B8),Requestor!B6)","v":" "},null,{"$f":"IF(Requestor!B22=0,IF(Requestor!B24=0, \" \",Requestor!B24),Requestor!B22)","v":"Manchester, NH  03101"}]
[null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z4=Requestor!B8,Requestor!B10,IF(Requestor!B8=0,\" \",Requestor!B8))","v":" "},null,{"$f":"IF(AB4=Requestor!B24,Requestor!B26,IF(Requestor!B24=0,\" \",Requestor!B24))","v":"United States"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z5=Requestor!B10, \" \",Requestor!B10)","v":0},null,{"$f":"IF(AB5=Requestor!B26, \" \",IF(Requestor!B26=0, \" \",Requestor!B26))","v":" "}]
[null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B12=0, \" \",Requestor!B12)","v":" "},null,{"$f":"IF(Requestor!B28=0, \" \",Requestor!B28)","v":"603-666-3906"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B14=0, \" \",Requestor!B14)","v":" "},null,{"$f":"IF(Requestor!B30=0, \" \",Requestor!B30)","v":"frclogistics@firstinspires.org"}]
[null,"City, State/Province, Zip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B16=0,\" \",Requestor!B16)","v":" "},null,{"$f":"IF(Requestor!B32=0, \" \",Requestor!B32)","v":"22-2990908"}]
[null,"Country",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B2=0, \" \",Requestor!B2)","v":" "},null,{"$f":"IF(Requestor!B18=0, \" \",Requestor!B18)","v":"FIRST"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B4=0, \" \",Requestor!B4)","v":" "},null,{"$f":"IF(Requestor!B20=0, \" \",Requestor!B20)","v":"200 Bedford St"}]
[null,"Contact Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B6=0,IF(Requestor!B8=0, \" \",Requestor!B8),Requestor!B6)","v":" "},null,{"$f":"IF(Requestor!B22=0, IF(Requestor!B24=0, \" \",Requestor!B24), Requestor!B22)","v":"Manchester, NH  03101"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z13=Requestor!B8,Requestor!B10,IF(Requestor!B8=0,\" \",Requestor!B8))","v":" "},null,{"$f":"IF(AB13=Requestor!B24,IF(Requestor!B26=0,\" \",Requestor!B26),IF(Requestor!B24=0,\" \",Requestor!B24))","v":"United States"}]
[null,"Contact E-mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z14=Requestor!B10, \" \",Requestor!B10)","v":0},null,{"$f":"IF(AB14=Requestor!B26,\" \",Requestor!B26)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B12=0, \" \",Requestor!B12)","v":" "},null,{"$f":"IF(Requestor!B28=0, \" \",Requestor!B28)","v":"603-666-3906"}]
[null,"Tax ID (If applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B14=0, \" \",Requestor!B14)","v":" "},null,{"$f":"IF(Requestor!B30=0, \" \",Requestor!B30)","v":"frclogistics@firstinspires.org"}]
[null,"FIRST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate Consignee",null,"End Destination"]
[null,"Consignee/Site Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B48=0, \" \",Requestor!B48)","v":" "},null,{"$f":"IF(Requestor!B26=0, \" \",Requestor!B26)","v":"United States"}]
[null,"200 Bedford St",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B34=0, \"SAME\", Requestor!B34)","v":"SAME"}]
[null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B36=0, \" \",Requestor!B36)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B38=0, \" \",Requestor!B38)","v":" "}]
[null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B40=0, \" \",Requestor!B40)","v":" "}]
[null,"Manchester, NH  03101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B42=0, \" \", Requestor!B42)","v":" "}]
[null,"City, State/Province, Zip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B44=0, \" \",Requestor!B44)","v":" "}]
[null,"United States",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Requestor!B46=0, \" \",Requestor!B46)","v":" "}]
[null,"Country"]
[null,"603-666-3906",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Contact Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"frclogistics@firstinspires.org"]
[null,"Contact E-mail"]
[null,"22-2990908"]
[null,"Tax ID (If applicable)"]
["If applicable, what is the address for the forwarding agent who will deliver your robot to the Consignee?"]
[null,"Intermediate Consignee"]
["*This should be the drayage address information given by FIRST."]
[null,"Address"]
[]
[null,"Address"]
[]
[null,"City, State/Province, Zip"]
[]
[null,"Country"]
[]
[null,"Contact Phone"]
[]
[null,"Contact E-mail"]
[]
[null,"Tax ID (If applicable)"]
["What is your Team Number and Home country?"]
[null,"Export Reference"]
["Which Carrier are you using to ship your robot (if known)?"]
[null,"Carrier"]
["What ship method are you using to ship your robot?"]
[null,"Ship Method"]
["Have you been granted a Robot Transportation Exemption by FIRST?",null,{"$f":"IF(B56=\"No\", \"Contact frclogistics@firstinspires.org for more information\", \" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B56=\"Yes\", \"EXW - \"&B10,\"DAP - \"&B26)","v":"DAP - United States"}]
[null,"INCOTerms",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B56=\"Yes\", \"DAP - \"&B10,\"EXW - \"&B26)","v":"EXW - United States"}]
["What is the estimated value of your robot?*"]
[null,"Value"]
["What is the total weight of your crate (in pounds), including robot and all other contents?"]
[null,"Weight"]
["What are the shipping dimensions of your crate?"]
[null,"Length (inches)","Width (inches)","Height (Inches)"]
[]
["*The estimated value is the total cost of any items from the Kit of Parts used and any additional parts that your team has purchased. Use the BOM worksheet to calculate the total value of your robot."]
["**For the Certificate of Origin, please work with your Carrier or Customs Broker to obtain this document to accompany your shipment. "]

{"sheet":"Packing List","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Requestor!Y29","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL BOXES / ITEMS:",{"$f":"COUNTA(A15:A40)","v":1},null,null,"DATE:",{"$f":"TODAY()","v":"2016-10-11"}]
[null,"TOTAL WEIGHT (LB):",{"$f":"SUM(A15:A40)","v":0},null,null,"TEAM INFORMATION:",{"$f":"IF(Requestor!B50=0, \" \",Requestor!B50)","v":" "}]
[null,"TOTAL WEIGHT (KG):",{"$f":"SUM(B15:B40)","v":0},null,null,"CARRIER:",{"$f":"IF(Requestor!B52=0, \" \",Requestor!B52)","v":" "}]
[null,"TOTAL CUBIC FEET:",{"$f":"SUM(F15:F40)","v":0},null,null,"SHIP METHOD:",{"$f":"IF(Requestor!B54=0, \" \",Requestor!B54)","v":" "}]
[]
["WEIGHT (LB)","WEIGHT (KG)","LENGTH (IN)","WIDTH (IN)","HEIGHT (IN)","CUBIC FEET","DESCRIPTION","QTY","HTS NUMBER","COUNTRY OF ORIGIN"]
[{"$f":"Requestor!B60","v":0},{"$f":"IF(A15=0,\" \",A15/2.2046)","v":" "},{"$f":"Requestor!B62","v":0},{"$f":"Requestor!C62","v":0},{"$f":"Requestor!D62","v":0},{"$f":"IF(C15*D15*E15=0,\" \",(C15*D15*E15)/1728)","v":" "},"Educational Robot",1,"9023.00.0000",{"$f":"IF(Requestor!B10=0, \" \", Requestor!B10)","v":" "}]
[null,{"$f":"IF(A16=0,\" \",A16/2.2046)","v":" "},null,null,null,{"$f":"IF(C16*D16*E16=0,\" \",(C16*D16*E16)/1728)","v":" "}]
[null," ",null,null,null," "]
[null," ",null,null,null," "]
[null," "]

{"sheet":"Invoice","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,42,7],[24,2,24,3],[1,6,1,7],[9,6,9,7],[10,4,10,5],[19,0,19,1],[19,2,19,3],[19,4,20,5],[19,6,20,7],[20,0,20,1],[20,2,20,3],[22,2,22,3],[23,2,23,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,0,30,0],[29,1,29,7],[30,1,30,7],[32,0,34,3],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[31,6,31,7]]}
[]
["EXPORTER:",null,null,null,null,"DATE:",{"$f":"TODAY()","v":"2016-10-11"}]
["TAX ID:",{"$f":"Requestor!AB10","v":"22-2990908"},null,null,null,"INVOICE NO:","N/A"]
["CONTACT:",null,null,null,null,"PO NO:","N/A"]
[null,null,null,null,null,"EXPORT REF:",{"$f":"IF(Requestor!B50=0, \" \",Requestor!B50)","v":" "}]
[null,null,null,null,null,"LICENSE REQUIRED:","NLR"]
[null,null,null,null,null,"TERMS OF SALE (INCOTerms):"]
[null,null,null,null,null,"PORT OF EMBARKATION:"]
["PHONE:",null,null,null,null,"SHIP METHOD:",{"$f":"Requestor!B54","v":0}]
["EMAIL:",null,null,null,null,"REASON FOR EXPORT:","Educational Use Only - Not for Resale"]
["CONSIGNEE:",null,null,null,"INTERMEDIATE CONSIGNEE:                                                   (if different from Consignee)"]
["TAX ID:",null,null,null,"TAX ID:"]
["CONTACT:",null,null,null,"CONTACT:"]
[]
[]
[]
[]
["PHONE:",null,null,null,"PHONE:"]
["EMAIL:",null,null,null,"EMAIL:"]
["FORWARDING AGENT:",null,{"$f":"IF(Requestor!B52=0, \" \",Requestor!B52)","v":" "},null,"ULTIMATE DESTINATION:",null,{"$f":"Requestor!$AB$19","v":"United States"}]
["BILL OF LADING/HOUSEBILL NO:"]
[]
["Quantity","Unit of Measure","Description",null,"Country of Origin","HTS Number","Unit Price","Total Price"]
[{"$f":"'Packing List'!H15","v":1},"EA",{"$f":"'Packing List'!G15","v":"Educational Robot"},null,{"$f":"'Packing List'!J15","v":" "},{"$f":"'Packing List'!I15","v":"9023.00.0000"},{"$f":"Requestor!B58","v":0},{"$f":"IF(G24=0,\" \",G24*A24)","v":" "}]
[null,{"$f":"IF('Packing List'!G16=0,\"\",\"EA\")","v":""},{"$f":"IF('Packing List'!G16=0,\"\",'Packing List'!G16)","v":""},null,{"$f":"IF('Packing List'!J16=0,\"\",'Packing List'!J16)","v":""},{"$f":"IF('Packing List'!I16=0,\"\",'Packing List'!I16)","v":""},null,{"$f":"IF(G25=0,\" \",G25*A25)","v":" "}]
[null,{"$f":"IF('Packing List'!G17=0,\"\",\"EA\")","v":""},{"$f":"IF('Packing List'!G17=0,\"\",'Packing List'!G17)","v":""},null,{"$f":"IF('Packing List'!J17=0,\"\",'Packing List'!J17)","v":""},{"$f":"IF('Packing List'!I17=0,\"\",'Packing List'!I17)","v":""},null,{"$f":"IF(G26=0,\" \",G26*A26)","v":" "}]
[null,{"$f":"IF('Packing List'!G18=0,\"\",\"EA\")","v":""},{"$f":"IF('Packing List'!G18=0,\"\",'Packing List'!G18)","v":""},null,{"$f":"IF('Packing List'!J18=0,\"\",'Packing List'!J18)","v":""},{"$f":"IF('Packing List'!I18=0,\"\",'Packing List'!I18)","v":""},null,{"$f":"IF(G27=0,\" \",G27*A27)","v":" "}]
[null,{"$f":"IF('Packing List'!G19=0,\"\",\"EA\")","v":""},{"$f":"IF('Packing List'!G19=0,\"\",'Packing List'!G19)","v":""},null,{"$f":"IF('Packing List'!J19=0,\"\",'Packing List'!J19)","v":""},{"$f":"IF('Packing List'!I19=0,\"\",'Packing List'!I19)","v":""},null," "]
[]
["Additional Comments","\"VALUES ARE FOR CBP PURPOSES ONLY. THIS TRANSACTION IS NOT A SALE. FOR EDUCATIONAL USE ONLY / NOT FOR RESALE\""]
[null,"Codes on Packing List are reference only for original classification - tariff codes on invoice are for customs "]
["Declaration Statement:",null,null,null,null,"Invoice Subtotal:",{"$f":"SUM(H24:H28)","v":0}]
["I hereby certify that the information on this invoice is true and correct and the contents and value of this shipment is as stated above.",null,null,null,null,"Freight:"]
[null,null,null,null,null,"Insurance:"]
[null,null,null,null,null,"Other:"]
[null,null,null,null,null,"Total Invoice Amount:",{"$f":"SUM(G32:H35)","v":0}]
[null,null,null,null,null,"Total Number of Packages:",{"$f":"'Packing List'!C9","v":1}]
[null,null,null,null,null,"Total Weight (KG):",{"$f":"'Packing List'!C11","v":0}]
[null,null,null,null,null,"Currency:","USD"]
["Shipper",null,"Date",null,null,"Special Programs:","N/A"]
[]
["These items are controlled by the U.S. Government and authorized for export only to the country of ultimate destination for use by the ultimate consignee or end-user(s) herein identified. They may not be resold, transferred, or otherwise disposed of, to any other country or to person other than the authorized ultimate consignee or end-user(s), either in their original form or after being incorporated into other items, without first obtaining approval from teh U.S. government or as otherwise authorized by U.S. law and regulation."]