{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Home","Job List","Client and Order Info","Client List","Vendor Data","OrderGraphs","Order Statistics","Sheet2","Location Info"],"not_rendered":{"charts":16,"images":24,"macros":1,"external_links":0,"defined_names":4,"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":"Home","index":0,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"`"]

{"sheet":"Job List","index":1,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["List","Type","Structural Steel","Handrails","Ladders","Graders","Chequer Plates","Steps ","Cladding/Roofing"]
["Rodolfo","Cost",4889.57,4889.57,28992.91,146657.65,103499.7,180134.79,4889.57]
["House","Facility","SteelTime","SteelTime","Metalcraft Services of Tampa, Inc.","Leatherwood Manufacturing Inc.","Preferred Metal Products, Inc.","WayKen","SteelTime"]

{"sheet":"Client and Order Info","index":2,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["Client Name","Phone","Email","Address","Order Name","SS","H","L","G","CHE","ST","CLA","DATE"]
["Rodolfo","(786) 468-9459","rodolforemien@gmail.com","3700 SW 27TH ST Gainesville Florida 32608","House",5,5,5,5,5,5,5,"2024-01-24"]
["Andres Espinosa","(786) 865-9985","andresespinosa@ufl.edu","Gainesville, FL","Office Building",5,10,5,10,5,5,0,"2023-12-20"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,""]
[]
[null,null,null,null,""]
[null,null,null,null,""]
["",null,null,null,""]

{"sheet":"Client List","index":3,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Client Name","Phone","Email","Address"]
["Rodolfo",7864689459,"rodolforemien@gmail.com","3700 SW 27TH ST Gainesville Florida 32608"]
["Andres Espinosa",7868659985,"andresespinosa@ufl.edu","Gainesville, FL"]
["Andy",1234040040,"test@gmail.com","Gainesville fl"]

{"sheet":"Vendor Data","index":4,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["VENDOR ID","VENDOR NAME","ADDRESS ","STATE","LATITUDE","LONGITUDE","CONTACT NAME","CONTACT PHONE","CONTACT EMAIL","Quality Rating","ADDITIONAL COMMENTS","STRUCTURAL STEEL PRODUCTION COST","STRUCTURAL STEEL LEAD TIME","HANDRAIL PRODUCTION COST","HANDRAIL LEAD TIME","LADDERS PRODUCTION COST","LADDERS LEAD TIME","GRATING PRODUCTION COST","GRATING LEAD TIME","CHEQUER PLATES PRODUCTION COST","CHEQUER PLATES LEAD TIME","STEPS PRODUCTION COST","STEPS LEAD TIME","CLADDING / ROOFING PRODUCTION COST","CLADDING / ROOFING LEAD TIME"]
[1,"SteelTime","10344 90th Trail, Live Oak, FL 32060","FL",30.287069299999999,-82.962688400000005,null,"386-364-7647",null,10,null,1.34,0.23,7,2,13,3,9.1002077658481078,2,12.513944537214796,5.4257457882394888E-2,4.4881903775388254,0.88789288577291936,16.617334656688413,0.52052164946614277]
[2,"Absolute Welding & Consulting, LLC","206 Adamson Ind. Blvd, Carrollton, GA 30117 ","GA",33.610473599999999,-85.104186999999996,null,null,null,9,null,10.357317548235983,0.6208177049710244,10.838163173975268,0.72430052778221476,6.5442523753585675,0.83935310678488462,1.3449595884407062,0.84856583484082904,9.0452456408895472,0.78936770152458269,1.7854483697996315,0.87064399287738803,7.4551689346685794,9.4006411108217613E-2]
[3,"Leatherwood Manufacturing Inc.","4355 Dorchester Rd., North Charleston, SC 29405-7430","SC",32.853056000000002,-80.007901000000004,null,null,null,7,null,8.9189581123655124,0.70105262500041177,9.7138315186782123,0.26261185539411525,13.544080317888605,0.14578140837552089,18.352008434881487,0.19060240357087066,11.606249705946849,0.9021036039242909,13.960299833010925,0.76081948060225979,10.350403059921696,2.296227180796484E-2]
[4,"Gateway Sales Corp. of GA","Tucker, GA 30085","GA",33.854404449999997,-84.211753849999994,null,null,null,5.5,null,6.725701627865444,0.52500928729387175,0.18177943034399568,0.9721533381516777,8.516671701466743,0.89595394812196527,9.9755596137710292,0.20063691992443111,8.386846565790405,0.87222954424569543,13.787692677313483,0.966458226022475,2.6137998609971502,0.12852027266393384]
[5,"Advanced Metal Components, Inc.","720 Empire Expressway, Swainsboro, GA 30401","GA",32.571367000000002,-82.330483000000001,null,null,null,4,null,17.972379320185404,0.41646629555230508,15.30855261455156,0.38830594038813959,11.947842752074616,0.88600192230805264,15.417903572572138,0.59719498609984012,6.0818150469197452,0.94392473390093568,3.916780308554364,0.16565845124924594,8.8900784098740555,0.16688837496659814]
[6,"W.P. Law Inc.","1330 Grove Rd., Greenville, SC 29605","SC",34.803179,-82.424181000000004,null,"800-660-7569",null,7.5,null,14.599522626371728,5.9684598411671952E-2,19.666569587609445,0.78621472524694935,5.8327413128672827,0.22115515841232036,7.0634718705582511,0.82187970952275424,1.6152602681901462,0.39545373548546647,0.31146877591267996,0.15599887605217766,17.505355843004466,0.69925471792507499]
[7,"Metalcraft Services of Tampa, Inc.","10706 N. 46th St., Tampa, FL 33617","FL",28.045418000000002,-82.411995000000005,null,null,null,8,null,4.2601704434584864,0.67948099428759379,17.754565684191356,0.24596050983295858,6.3090725397346237,0.41390212937417536,11.776973425915131,0.82769544680365148,4.4877176305152027,0.4407421457607329,9.6017065867748812,0.38739870048785097,7.0660694495811089,0.73778704897561409]
[8,"Birl's Light Fab","12151 62nd St N, Unit 9, Largo, FL 33773","FL",27.882210000000001,-82.719927999999996,null,null,null,8.5,null,8.8132851715673795,0.25761674326984674,13.451252128270747,0.32061882248044771,6.6438722231838661,0.88750117857469935,4.7266189541543779,3.6578034516663971E-2,4.7933464075909598,0.89091451063470639,12.871724559494183,4.0524021192083315E-2,0.37162242320962324,0.60715487057886053]
[9,"WayKen","1501 Belle Isle Avenue, Suite 110, Mount Pleasant, SC 29464","SC",32.838031000000001,-79.856603000000007,null,null,null,9,null,10.791899488482512,0.81373739148033564,0.6964358764740064,0.1108538863530526,8.6627862755668161,0.2881233044709699,3.1493237616300207,0.78164236511275109,8.4849855761323312,0.90500626675171059,2.1935405811144393,0.11363696792305666,13.547567207778952,0.97056915196580196]
[10,"Preferred Metal Products, Inc.","3614 Princeton Oaks St., Orlando, FL 32808","FL",28.567509999999999,-81.422687999999994,null,null,null,10,null,17.942726771482704,0.4399720433401777,18.269776450185461,4.5840914127104226E-2,12.193569128127301,0.56365704120752946,11.368589509854942,0.81407765889640626,19.048228053620313,0.78268431909172909,11.195677502000223,0.10050114956510281,4.3795741463066857,0.11312067547467575]
[]
[]
[]
[null,"Test Data for Form Graph",null,null,null,{"$f":"L2*5*10*1.25*Haversine(30.2870693,-82.926884,29.65216,-82.34008)","v":4706.4162572601444}]
[null,"Structural Steel",5,null,null,null,null,null,null,null," "]
[null,"Steps",3]
[null,"Ladders",8]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"`"]
[]
[null,{"$f":"LEN(B2)","v":9}]
[null,{"$f":"LEN(B3)","v":34}]
[null,30]
[null,25]
[null,31]
[null,13]
[null,34]
[null,16]
[null,{"$f":"LEN(B10)","v":6}]
[null,30]
[null,"\\"]

{"sheet":"OrderGraphs","index":5,"n_rows":187,"n_cols":30,"rows_kept":187,"cut":false,"hidden":true,"merged":[]}
["Customer Name","Order","Structural Steel","Handrails","Ladders","Graders","Chequer Plates","Steps","Cladding/roofing",null,"Actual Data Reference",null,null,null,null,null,"Actual Number Reference"]
["Rodolfo","House","SteelTime-4889.57","SteelTime-4889.57","Metalcraft Services of Tampa, Inc.-28992.91","Leatherwood Manufacturing Inc.-146657.65","Preferred Metal Products, Inc.-103499.70","WayKen-180134.79","SteelTime-4889.57",{"$f":"IF(AND(NOT(ISBLANK(C2)), NOT(ISNUMBER(C2))), C$1 & \" \" & LEFT(C2, FIND(\"-\", C2) - 1), \"\")","v":"Structural Steel SteelTime"},{"$f":"IF(AND(NOT(ISBLANK(D2)), NOT(ISNUMBER(D2))), D$1 & \" \" & LEFT(D2, FIND(\"-\", D2) - 1), \"\")","v":"Handrails SteelTime"},"Ladders Metalcraft Services of Tampa, Inc.","Graders Leatherwood Manufacturing Inc.","Chequer Plates Preferred Metal Products, Inc.","Steps WayKen","Cladding/roofing SteelTime",{"$f":"IF(OR(C2=0, C2=\"\"), \"\", C$1&\" \"&C2)","v":"Structural Steel SteelTime-4889.57"},{"$f":"IF(OR(D2=0, D2=\"\"), \"\", D$1&\" \"&D2)","v":"Handrails SteelTime-4889.57"},"Ladders Metalcraft Services of Tampa, Inc.-28992.91","Graders Leatherwood Manufacturing Inc.-146657.65","Chequer Plates Preferred Metal Products, Inc.-103499.70","Steps WayKen-180134.79","Cladding/roofing SteelTime-4889.57",{"$f":"IF(OR(C2=\"\",C2=0),\"\",LEFT(C2,FIND(\"-\",C2)-1))","v":"SteelTime"},{"$f":"IF(OR(D2=\"\",D2=0),\"\",LEFT(D2,FIND(\"-\",D2)-1))","v":"SteelTime"},"Metalcraft Services of Tampa, Inc.","Leatherwood Manufacturing Inc.","Preferred Metal Products, Inc.","WayKen","SteelTime"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOT(ISBLANK(C3)), NOT(ISNUMBER(C3))), C$1 & \" \" & LEFT(C3, FIND(\"-\", C3) - 1), \"\")","v":""},"","","","","","",{"$f":"IF(OR(C3=0, C3=\"\"), \"\", C$1&\" \"&C3)","v":""},"","","","","","",{"$f":"IF(OR(C3=\"\",C3=0),\"\",LEFT(C3,FIND(\"-\",C3)-1))","v":""},{"$f":"IF(OR(D3=\"\",D3=0),\"\",LEFT(D3,FIND(\"-\",D3)-1))","v":""},{"$f":"IF(OR(E3=\"\",E3=0),\"\",LEFT(E3,FIND(\"-\",E3)-1))","v":""},{"$f":"IF(OR(F3=\"\",F3=0),\"\",LEFT(F3,FIND(\"-\",F3)-1))","v":""},{"$f":"IF(OR(G3=\"\",G3=0),\"\",LEFT(G3,FIND(\"-\",G3)-1))","v":""},{"$f":"IF(OR(H3=\"\",H3=0),\"\",LEFT(H3,FIND(\"-\",H3)-1))","v":""},{"$f":"IF(OR(I3=\"\",I3=0),\"\",LEFT(I3,FIND(\"-\",I3)-1))","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,null,null,{"$f":"IF(AND(NOT(ISBLANK(C6)), NOT(ISNUMBER(C6))), C$1 & \" \" & LEFT(C6, FIND(\"-\", C6) - 1), \"\")","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOT(ISBLANK(C7)), NOT(ISNUMBER(C7))), C$1 & \" \" & LEFT(C7, FIND(\"-\", C7) - 1), \"\")","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,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,null,null,null,null,"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(D14=0, D14=\"\"), \"\", D$1&\" \"&D14)","v":""},{"$f":"IF(OR(E14=0, E14=\"\"), \"\", E$1&\" \"&E14)","v":""},{"$f":"IF(OR(F14=0, F14=\"\"), \"\", F$1&\" \"&F14)","v":""},{"$f":"IF(OR(G14=0, G14=\"\"), \"\", G$1&\" \"&G14)","v":""},{"$f":"IF(OR(H14=0, H14=\"\"), \"\", H$1&\" \"&H14)","v":""},{"$f":"IF(OR(I14=0, I14=\"\"), \"\", I$1&\" \"&I14)","v":""},"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR(C15=0, C15=\"\"), \"\", C$1&\" \"&C15)","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,null,null,"",{"$f":"IF(AND(NOT(ISBLANK(D18)), NOT(ISNUMBER(D18))), D$1 & \" \" & LEFT(D18, FIND(\"-\", D18) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(E18)), NOT(ISNUMBER(E18))), E$1 & \" \" & LEFT(E18, FIND(\"-\", E18) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(F18)), NOT(ISNUMBER(F18))), F$1 & \" \" & LEFT(F18, FIND(\"-\", F18) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(G18)), NOT(ISNUMBER(G18))), G$1 & \" \" & LEFT(G18, FIND(\"-\", G18) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(H18)), NOT(ISNUMBER(H18))), H$1 & \" \" & LEFT(H18, FIND(\"-\", H18) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(I18)), NOT(ISNUMBER(I18))), I$1 & \" \" & LEFT(I18, FIND(\"-\", I18) - 1), \"\")","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,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,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,null,null,null,null,null,null,{"$f":"IF(AND(NOT(ISBLANK(C27)), NOT(ISNUMBER(C27))), C$1 & \" \" & LEFT(C27, FIND(\"-\", C27) - 1), \"\")","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,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,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,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,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,null,"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(NOT(ISBLANK(D42)), NOT(ISNUMBER(D42))), D$1 & \" \" & LEFT(D42, FIND(\"-\", D42) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(E42)), NOT(ISNUMBER(E42))), E$1 & \" \" & LEFT(E42, FIND(\"-\", E42) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(F42)), NOT(ISNUMBER(F42))), F$1 & \" \" & LEFT(F42, FIND(\"-\", F42) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(G42)), NOT(ISNUMBER(G42))), G$1 & \" \" & LEFT(G42, FIND(\"-\", G42) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(H42)), NOT(ISNUMBER(H42))), H$1 & \" \" & LEFT(H42, FIND(\"-\", H42) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(I42)), NOT(ISNUMBER(I42))), I$1 & \" \" & LEFT(I42, FIND(\"-\", I42) - 1), \"\")","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,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,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,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,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,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,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,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,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(OR(C67=\"\",C67=0),\"\",LEFT(C67,FIND(\"-\",C67)-1))","v":""},{"$f":"IF(OR(D67=\"\",D67=0),\"\",LEFT(D67,FIND(\"-\",D67)-1))","v":""},{"$f":"IF(OR(E67=\"\",E67=0),\"\",LEFT(E67,FIND(\"-\",E67)-1))","v":""},{"$f":"IF(OR(F67=\"\",F67=0),\"\",LEFT(F67,FIND(\"-\",F67)-1))","v":""},{"$f":"IF(OR(G67=\"\",G67=0),\"\",LEFT(G67,FIND(\"-\",G67)-1))","v":""},{"$f":"IF(OR(H67=\"\",H67=0),\"\",LEFT(H67,FIND(\"-\",H67)-1))","v":""},{"$f":"IF(OR(I67=\"\",I67=0),\"\",LEFT(I67,FIND(\"-\",I67)-1))","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,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,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,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(OR(D78=0, D78=\"\"), \"\", D$1&\" \"&D78)","v":""},{"$f":"IF(OR(E78=0, E78=\"\"), \"\", E$1&\" \"&E78)","v":""},{"$f":"IF(OR(F78=0, F78=\"\"), \"\", F$1&\" \"&F78)","v":""},{"$f":"IF(OR(G78=0, G78=\"\"), \"\", G$1&\" \"&G78)","v":""},{"$f":"IF(OR(H78=0, H78=\"\"), \"\", H$1&\" \"&H78)","v":""},{"$f":"IF(OR(I78=0, I78=\"\"), \"\", I$1&\" \"&I78)","v":""},"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR(C79=0, C79=\"\"), \"\", C$1&\" \"&C79)","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,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,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,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,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOT(ISBLANK(C91)), NOT(ISNUMBER(C91))), C$1 & \" \" & LEFT(C91, FIND(\"-\", C91) - 1), \"\")","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,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,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,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,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,null,"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(NOT(ISBLANK(D106)), NOT(ISNUMBER(D106))), D$1 & \" \" & LEFT(D106, FIND(\"-\", D106) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(E106)), NOT(ISNUMBER(E106))), E$1 & \" \" & LEFT(E106, FIND(\"-\", E106) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(F106)), NOT(ISNUMBER(F106))), F$1 & \" \" & LEFT(F106, FIND(\"-\", F106) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(G106)), NOT(ISNUMBER(G106))), G$1 & \" \" & LEFT(G106, FIND(\"-\", G106) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(H106)), NOT(ISNUMBER(H106))), H$1 & \" \" & LEFT(H106, FIND(\"-\", H106) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(I106)), NOT(ISNUMBER(I106))), I$1 & \" \" & LEFT(I106, FIND(\"-\", I106) - 1), \"\")","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,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,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,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,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,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,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,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,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(OR(C131=\"\",C131=0),\"\",LEFT(C131,FIND(\"-\",C131)-1))","v":""},{"$f":"IF(OR(D131=\"\",D131=0),\"\",LEFT(D131,FIND(\"-\",D131)-1))","v":""},{"$f":"IF(OR(E131=\"\",E131=0),\"\",LEFT(E131,FIND(\"-\",E131)-1))","v":""},{"$f":"IF(OR(F131=\"\",F131=0),\"\",LEFT(F131,FIND(\"-\",F131)-1))","v":""},{"$f":"IF(OR(G131=\"\",G131=0),\"\",LEFT(G131,FIND(\"-\",G131)-1))","v":""},{"$f":"IF(OR(H131=\"\",H131=0),\"\",LEFT(H131,FIND(\"-\",H131)-1))","v":""},{"$f":"IF(OR(I131=\"\",I131=0),\"\",LEFT(I131,FIND(\"-\",I131)-1))","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,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,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,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(OR(D142=0, D142=\"\"), \"\", D$1&\" \"&D142)","v":""},{"$f":"IF(OR(E142=0, E142=\"\"), \"\", E$1&\" \"&E142)","v":""},{"$f":"IF(OR(F142=0, F142=\"\"), \"\", F$1&\" \"&F142)","v":""},{"$f":"IF(OR(G142=0, G142=\"\"), \"\", G$1&\" \"&G142)","v":""},{"$f":"IF(OR(H142=0, H142=\"\"), \"\", H$1&\" \"&H142)","v":""},{"$f":"IF(OR(I142=0, I142=\"\"), \"\", I$1&\" \"&I142)","v":""},"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR(C143=0, C143=\"\"), \"\", C$1&\" \"&C143)","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,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,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,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,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOT(ISBLANK(C155)), NOT(ISNUMBER(C155))), C$1 & \" \" & LEFT(C155, FIND(\"-\", C155) - 1), \"\")","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,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,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,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,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,null,"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(NOT(ISBLANK(D170)), NOT(ISNUMBER(D170))), D$1 & \" \" & LEFT(D170, FIND(\"-\", D170) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(E170)), NOT(ISNUMBER(E170))), E$1 & \" \" & LEFT(E170, FIND(\"-\", E170) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(F170)), NOT(ISNUMBER(F170))), F$1 & \" \" & LEFT(F170, FIND(\"-\", F170) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(G170)), NOT(ISNUMBER(G170))), G$1 & \" \" & LEFT(G170, FIND(\"-\", G170) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(H170)), NOT(ISNUMBER(H170))), H$1 & \" \" & LEFT(H170, FIND(\"-\", H170) - 1), \"\")","v":""},{"$f":"IF(AND(NOT(ISBLANK(I170)), NOT(ISNUMBER(I170))), I$1 & \" \" & LEFT(I170, FIND(\"-\", I170) - 1), \"\")","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,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,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,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,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,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,null,null,null,"","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Order Statistics","index":6,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":true,"merged":[[0,0,0,3],[1,0,3,5]]}
["Choose Facility"]
["SteelTime"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Structural Steel","Handrails","Ladders","Graders","Chequer Plates","Steps","Cladding Roofing"]
[1,1,0,0,0,0,1]

{"sheet":"Sheet2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Location Info","index":8,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["VENDOR ID","VENDOR NAME","LATITUDE","LONGITUDE",null,null,null,null,"Due to the curvature of the earth, the map's display may appear to be off by up to 20 miles."]
[1,"SteelTime",30.287069299999999,-82.962688400000005,{"$f":"NominatimReverseGeocode(C2,D2)","v":"1798, Howard Street, Live Oak, Suwannee County, Florida, 32060, United States"}]
[2,"Absolute Welding & Consulting, LLC",33.610473599999999,-85.104186999999996,{"$f":"NominatimReverseGeocode(C3,D3)","v":"271, Adamson Industrial Boulevard, Holly Heights, Carrollton, Carroll County, Georgia, 30117, United States"}]
[3,"Leatherwood Manufacturing Inc.",32.853056000000002,-80.007901000000004]
[4,"Gateway Sales Corp. of GA",33.854404449999997,-84.211753849999994]
[5,"Advanced Metal Components, Inc.",32.571367000000002,-82.330483000000001]
[6,"W.P. Law Inc.",34.803179,-82.424181000000004]
[7,"Metalcraft Services of Tampa, Inc.",28.045418000000002,-82.411995000000005]
[8,"Birl's Light Fab",27.882210000000001,-82.719927999999996]
[9,"WayKen",32.838031000000001,-79.856603000000007]
[10,"Preferred Metal Products, Inc.",28.567509999999999,-81.422687999999994]
[11,null,29.6429832,-82.333941899999999]
[null,"Write Here to Override Combo Box "]
[null,"Fix this later to be nicer"]
[null,"INPUT LAT long? Like maybe have number 2 here or what "]
[]
[]
[]
[null,"Memphis",35.149500000000003,-90.049000000000007,{"$f":"NominatimGeocode(B19)","v":"35.1460249,-90.0517638"}]
[null,"jacksonville NC",34.754100000000001,-77.430199999999999,{"$f":"NominatimGeocode(B20)","v":"34.7494749,-77.4208221"}]
[null,"3003 Clark Butler Blvd",25.092600000000001,-80.441999999999993,{"$f":"NominatimGeocode(B21)","v":"29.6261514,-82.3818718"}]
[null,"1050 Buford Dam Rd",null,null,{"$f":"NominatimGeocode(B22)","v":"34.1868595,-84.1207523"}]
[null,"Scale is from","(25,-90)","(35,-77.5)",null,null,null,null,"`"]
[null,null,null,null,{"$f":"NominatimGeocodeCustom(B20)","v":"34.7494749,-77.4208221"}]