{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Data","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Main","index":0,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"P. Schmitt"]
[null,"Upload Program",null,null,null,null,null,null,null,null,"2019-11-07",null,null,null,"In row 10 and 11 is a sample sql insert statement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The macro takes the template and replaces the values with random entries"]
[null,"This program crates an insert statement to upload multiple records into a database"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See the program by clicking on developer / visual basic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Typically it is better to switch \"option explicit\" on, but for a small program it is not needed."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This program was writtin in 20  minutes!"]
[]
[null,{"$f":"\"insert into recommendation (SiteId,VIN,MakeId,ModelId,[Year],Mileage,FirstName, LastName,CustomerLocationId,AdvisorUserId,SalesUserId,TimeCreated,TimeReolved,ProductId,Comment,Interest,IsWaiting,StatusId,CustomerNumber, RepairOrder) values \"","v":"insert into recommendation (SiteId,VIN,MakeId,ModelId,[Year],Mileage,FirstName, LastName,CustomerLocationId,AdvisorUserId,SalesUserId,TimeCreated,TimeReolved,ProductId,Comment,Interest,IsWaiting,StatusId,CustomerNumber, RepairOrder) values "}]
[null,"(1,'xxVIN',xxMakeId,xxModelId,xxYear,xxMileage,'xxFirstName', 'xxLastName',1,1,xxSalesUserId,'xxTimeCreated','xxTimeResolved',xxProductId,'reason for decision','',1,xxStatusId,'abc','abc')"]
[]
[]
["insert into recommendation (SiteId,VIN,MakeId,ModelId,[Year],Mileage,FirstName, LastName,CustomerLocationId,AdvisorUserId,SalesUserId,TimeCreated,TimeReolved,ProductId,Comment,Interest,IsWaiting,StatusId,CustomerNumber, RepairOrder) values (1,'',10,43,2016,70000,'Cole', '',1,1,12,'11/7/2019 6:14:24 PM','10/2/2019 6:43:12 AM',85,'reason for decision','',1,2,'abc','abc')"]
["insert into recommendation (SiteId,VIN,MakeId,ModelId,[Year],Mileage,FirstName, LastName,CustomerLocationId,AdvisorUserId,SalesUserId,TimeCreated,TimeReolved,ProductId,Comment,Interest,IsWaiting,StatusId,CustomerNumber, RepairOrder) values (1,'',12,56,2018,90000,'Jonathan', 'Bolton',1,1,12,'10/31/2019 1:55:12 AM','10/19/2019 5:45:36 AM',84,'reason for decision','',1,3,'abc','abc')"]
["insert into recommendation (SiteId,VIN,MakeId,ModelId,[Year],Mileage,FirstName, LastName,CustomerLocationId,AdvisorUserId,SalesUserId,TimeCreated,TimeReolved,ProductId,Comment,Interest,IsWaiting,StatusId,CustomerNumber, RepairOrder) values (1,'',11,84,2018,40000,'Jonathan', 'Morris',1,1,1,'10/14/2019 6:14:24 PM','10/24/2019 8:38:24 AM',86,'reason for decision','',1,3,'abc','abc')"]

{"sheet":"Data","index":1,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Id","SiteId","VIN","MakeId","ModelId","Year","Mileage","FirstName","LastName","CustomerLocationId","AdvisorUserId","SalesUserId","TimeCreated","TimeReolved","ProductId","Comment","Interest","IsWaiting","StatusId","CustomerNumber","RepairOrder"]
[6,1,"dfgh",12,"NULL","NULL","NULL","bin","wu",1,1,1,"2019-10-23T11:43:33.940","NULL",86,null,0,1,1,123]
[7,1,"dfgh",10,10,"NULL","NULL","bin","wu",1,1,1,"2019-10-23T11:46:47.627","NULL",86,null,0,1,1,123]
[8,1,null,12,"NULL","NULL","NULL","asdf","asdf",1,1,1,"2019-10-24T11:22:58.560","NULL",89,null,0,1,1,"NULL","NULL"]
[9,1,null,10,"NULL","NULL","NULL","dfdf","asdf",1,1,12,"2019-10-24T11:24:08.373","NULL",84,null,0,1,1,"NULL","NULL"]
[10,1,null,10,11,"NULL","NULL","sdfgsdfg","sdfgsdf",2,1,12,"2019-10-25T14:28:42.393","NULL",88,null,0,1,1,"NULL"]
[11,1,null,10,11,"NULL","NULL","Bin","Wu",1,1,12,"2019-10-28T16:07:58.593","NULL",87,null,0,1,1,1234,12342134]
[12,1,null,13,"NULL","NULL","NULL",null,null,1,1,12,"2019-10-28T12:13:36.877","NULL",86,null,0,1,1,"NULL"]
[13,1,null,10,11,"NULL","NULL","Bin","Wu",1,1,12,"2019-10-28T12:21:21.607","NULL",86,null,0,1,2,2154,134]
[14,1,null,12,41,"NULL","NULL","Bin","Wu",1,1,10,"2019-10-28T19:20:23.177","NULL",104,null,0,1,3,43554,23542354]
[15,1,"adsfdas",10,11,"NULL","NULL","Bin","Qu",1,1,10,"2019-10-28T15:33:46.950","NULL",87,null,0,1,2,25435,435254]
[16,1,"dgfhgfdh",10,11,"NULL","NULL","Bin","Wu",1,1,11,"2019-10-28T15:39:55.793","NULL",86,null,0,1,2,345345,235454]
[17,1,null,11,20,"NULL","NULL","Bin","Wu",1,1,10,"2019-10-28T15:42:23.017","NULL",101,null,0,1,1,4352354,5463456546]
[25,1,"JH4DA3363HS017471",10,10,2015,67000,"Rubert","Merlow",1,1,9,"2019-11-04T12:53:52.890","NULL","NULL",null,1,1,1,"1123245fa",880006523]
[26,1,"JH4DA3363HS017471",10,16,2015,67000,"Rubert","Merlow2",1,1,11,"2019-11-04T12:55:31.213","NULL",89,null,1,1,1,"1123245fa",880006523]
[27,1,null,10,10,"NULL","NULL",null,null,1,1,9,"2019-11-04T20:26:18.273","NULL",92,null,1,1,1]

{"sheet":"Lookups","index":2,"n_rows":129,"n_cols":16,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
["Id","Name","CarMakeId",null,null,"First","Last",null,"Date",null,"Id","Name",null,"Alhabeth","UserId","ProductId"]
[10,"Enclave",10,null,null,"Maria","Jones",null,"2019-11-10",null,1,"Active",null,"A",1,80]
[12,"Encore",10,null,null,"Melissa","Morris",null,{"$f":"I2-0.32","v":"2019-11-09T16:19:12"},null,2,"Sold",null,"B",9,82]
[13,"LaCrosse",10,null,null,"Jonathan","Clinton",null,{"$f":"I3-0.32","v":"2019-11-09T08:38:24"},null,3,"Declined",null,"C",10,84]
[14,"Lucerne",10,null,null,"Cole","Jefferson",null,"2019-11-09T00:57:36",null,null,null,null,"D",11,88]
[15,"Park Avenue",10,null,null,"Correy","Merlow",null,"2019-11-08T17:16:48",null,null,null,null,"E",12,89]
[16,"Regal",10,null,null,"Juan","Konal",null,"2019-11-08T09:36:00",null,null,null,null,"F",null,92]
[17,"Verano",10,null,null,"Bert","Bolton",null,"2019-11-08T01:55:12",null,null,null,null,"G",null,97]
[18,"ATS",11,null,null,"Craig","Vari",null,"2019-11-07T18:14:24",null,null,null,null,"H",null,81]
[19,"ATS Coupe",11,null,null,"Math","Naboso",null,"2019-11-07T10:33:36",null,null,null,null,"I",null,83]
[20,"BLS",11,null,null,null,null,null,"2019-11-07T02:52:48",null,null,null,null,"J",null,85]
[21,"CTS",11,null,null,null,null,null,"2019-11-06T19:12:00",null,null,null,null,"K",null,86]
[22,"CTS Coupe",11,null,null,null,null,null,"2019-11-06T11:31:12",null,null,null,null,"L",null,87]
[23,"CTS Wagon",11,null,null,null,null,null,"2019-11-06T03:50:24",null,null,null,null,"M",null,90]
[24,"CTS-V",11,null,null,null,null,null,"2019-11-05T20:09:36",null,null,null,null,"N",null,91]
[25,"CTS-V Coupe",11,null,null,null,null,null,"2019-11-05T12:28:48",null,null,null,null,"O",null,93]
[26,"CTS-V Wagon",11,null,null,null,null,null,"2019-11-05T04:48:00",null,null,null,null,"P",null,94]
[27,"DTS",11,null,null,null,null,null,"2019-11-04T21:07:12",null,null,null,null,"Q",null,95]
[28,"ELR",11,null,null,null,null,null,"2019-11-04T13:26:24",null,null,null,null,"R",null,96]
[29,"Escalade",11,null,null,null,null,null,"2019-11-04T05:45:36",null,null,null,null,"S",null,98]
[30,"Escalade ESV",11,null,null,null,null,null,"2019-11-03T22:04:48",null,null,null,null,"T",null,99]
[31,"SRX",11,null,null,null,null,null,"2019-11-03T14:24:00",null,null,null,null,"U",null,100]
[32,"STS",11,null,null,null,null,null,"2019-11-03T06:43:12",null,null,null,null,"V",null,101]
[33,"STS-V",11,null,null,null,null,null,"2019-11-02T23:02:24",null,null,null,null,"W",null,102]
[34,"XLR",11,null,null,null,null,null,"2019-11-02T15:21:36",null,null,null,null,"X",null,103]
[35,"XTS",11,null,null,null,null,null,"2019-11-02T07:40:48",null,null,null,null,"Y",null,104]
[36,"XTS ",11,null,null,null,null,null,"2019-11-02",null,null,null,null,"Z",null,105]
[37,"Avalanche",12,null,null,null,null,null,"2019-11-01T16:19:12"]
[38,"Aveo",12,null,null,null,null,null,"2019-11-01T08:38:24"]
[39,"Camaro",12,null,null,null,null,null,"2019-11-01T00:57:36"]
[40,"Captiva",12,null,null,null,null,null,"2019-10-31T17:16:48"]
[41,"City Express",12,null,null,null,null,null,"2019-10-31T09:36:00"]
[42,"Cobalt",12,null,null,null,null,null,"2019-10-31T01:55:12"]
[43,"Colorado",12,null,null,null,null,null,"2019-10-30T18:14:24"]
[44,"Corvette",12,null,null,null,null,null,"2019-10-30T10:33:36"]
[45,"Corvette Stingray",12,null,null,null,null,null,"2019-10-30T02:52:48"]
[46,"Cruze",12,null,null,null,null,null,"2019-10-29T19:12:00"]
[47,"Epica",12,null,null,null,null,null,"2019-10-29T11:31:12"]
[48,"Equinox",12,null,null,null,null,null,"2019-10-29T03:50:24"]
[49,"Express",12,null,null,null,null,null,"2019-10-28T20:09:36"]
[50,"Express Cargo",12,null,null,null,null,null,"2019-10-28T12:28:48"]
[51,"HHR",12,null,null,null,null,null,"2019-10-28T04:48:00"]
[52,"Impala",12,null,null,null,null,null,"2019-10-27T21:07:12"]
[53,"Kalos",12,null,null,null,null,null,"2019-10-27T13:26:24"]
[54,"Lacetti",12,null,null,null,null,null,"2019-10-27T05:45:36"]
[55,"Lumina",12,null,null,null,null,null,"2019-10-26T22:04:48"]
[56,"Malibu",12,null,null,null,null,null,"2019-10-26T14:24:00"]
[57,"Matiz",12,null,null,null,null,null,"2019-10-26T06:43:12"]
[58,"Nubira",12,null,null,null,null,null,"2019-10-25T23:02:24"]
[59,"Optra",12,null,null,null,null,null,"2019-10-25T15:21:36"]
[60,"Orlando",12,null,null,null,null,null,"2019-10-25T07:40:48"]
[61,"Rezzo",12,null,null,null,null,null,"2019-10-25"]
[62,"Silverado",12,null,null,null,null,null,"2019-10-24T16:19:12"]
[63,"Silverado 1500",12,null,null,null,null,null,"2019-10-24T08:38:24"]
[64,"Silverado 2500HD",12,null,null,null,null,null,"2019-10-24T00:57:36"]
[65,"Silverado 3500HD",12,null,null,null,null,null,"2019-10-23T17:16:48"]
[66,"Sonic",12,null,null,null,null,null,"2019-10-23T09:36:00"]
[67,"Spark",12,null,null,null,null,null,"2019-10-23T01:55:12"]
[68,"Spark EV",12,null,null,null,null,null,"2019-10-22T18:14:24"]
[69,"SS",12,null,null,null,null,null,"2019-10-22T10:33:36"]
[70,"Suburban",12,null,null,null,null,null,"2019-10-22T02:52:48"]
[71,"Tahoe",12,null,null,null,null,null,"2019-10-21T19:12:00"]
[72,"TrailBlazer",12,null,null,null,null,null,"2019-10-21T11:31:12"]
[73,"Trans Sport",12,null,null,null,null,null,"2019-10-21T03:50:24"]
[74,"Traverse",12,null,null,null,null,null,"2019-10-20T20:09:36"]
[75,"Trax",12,null,null,null,null,null,"2019-10-20T12:28:48"]
[76,"Uplander",12,null,null,null,null,null,"2019-10-20T04:48:00"]
[77,"Volt",12,null,null,null,null,null,{"$f":"I67-0.32","v":"2019-10-19T21:07:12"}]
[78,"Acadia",13,null,null,null,null,null,"2019-10-19T13:26:24"]
[79,"Canyon",13,null,null,null,null,null,"2019-10-19T05:45:36"]
[80,"Envoy",13,null,null,null,null,null,"2019-10-18T22:04:48"]
[81,"Savana",13,null,null,null,null,null,"2019-10-18T14:24:00"]
[82,"Sierra",13,null,null,null,null,null,"2019-10-18T06:43:12"]
[83,"Sierra 1500",13,null,null,null,null,null,"2019-10-17T23:02:24"]
[84,"Sierra 2500HD",13,null,null,null,null,null,"2019-10-17T15:21:36"]
[85,"Sierra 3500HD",13,null,null,null,null,null,"2019-10-17T07:40:48"]
[86,"Terrain",13,null,null,null,null,null,"2019-10-17"]
[87,"Yukon",13,null,null,null,null,null,"2019-10-16T16:19:12"]
[88,"Yukon XL",13,null,null,null,null,null,"2019-10-16T08:38:24"]
[null,null,null,null,null,null,null,null,"2019-10-16T00:57:36"]
[null,null,null,null,null,null,null,null,"2019-10-15T17:16:48"]
[null,null,null,null,null,null,null,null,"2019-10-15T09:36:00"]
[null,null,null,null,null,null,null,null,"2019-10-15T01:55:12"]
[null,null,null,null,null,null,null,null,"2019-10-14T18:14:24"]
[null,null,null,null,null,null,null,null,"2019-10-14T10:33:36"]
[null,null,null,null,null,null,null,null,"2019-10-14T02:52:48"]
[null,null,null,null,null,null,null,null,"2019-10-13T19:12:00"]
[null,null,null,null,null,null,null,null,"2019-10-13T11:31:12"]
[null,null,null,null,null,null,null,null,"2019-10-13T03:50:24"]
[null,null,null,null,null,null,null,null,"2019-10-12T20:09:36"]
[null,null,null,null,null,null,null,null,"2019-10-12T12:28:48"]
[null,null,null,null,null,null,null,null,"2019-10-12T04:48:00"]
[null,null,null,null,null,null,null,null,"2019-10-11T21:07:12"]
[null,null,null,null,null,null,null,null,"2019-10-11T13:26:24"]
[null,null,null,null,null,null,null,null,"2019-10-11T05:45:36"]
[null,null,null,null,null,null,null,null,"2019-10-10T22:04:48"]
[null,null,null,null,null,null,null,null,"2019-10-10T14:24:00"]
[null,null,null,null,null,null,null,null,"2019-10-10T06:43:12"]
[null,null,null,null,null,null,null,null,"2019-10-09T23:02:24"]
[null,null,null,null,null,null,null,null,"2019-10-09T15:21:36"]
[null,null,null,null,null,null,null,null,"2019-10-09T07:40:48"]
[null,null,null,null,null,null,null,null,"2019-10-09"]
[null,null,null,null,null,null,null,null,"2019-10-08T16:19:12"]
[null,null,null,null,null,null,null,null,"2019-10-08T08:38:24"]
[null,null,null,null,null,null,null,null,"2019-10-08T00:57:36"]
[null,null,null,null,null,null,null,null,"2019-10-07T17:16:48"]
[null,null,null,null,null,null,null,null,"2019-10-07T09:36:00"]
[null,null,null,null,null,null,null,null,"2019-10-07T01:55:12"]
[null,null,null,null,null,null,null,null,"2019-10-06T18:14:24"]
[null,null,null,null,null,null,null,null,"2019-10-06T10:33:36"]
[null,null,null,null,null,null,null,null,"2019-10-06T02:52:48"]
[null,null,null,null,null,null,null,null,"2019-10-05T19:12:00"]
[null,null,null,null,null,null,null,null,"2019-10-05T11:31:12"]
[null,null,null,null,null,null,null,null,"2019-10-05T03:50:24"]
[null,null,null,null,null,null,null,null,"2019-10-04T20:09:36"]
[null,null,null,null,null,null,null,null,"2019-10-04T12:28:48"]
[null,null,null,null,null,null,null,null,"2019-10-04T04:48:00"]
[null,null,null,null,null,null,null,null,"2019-10-03T21:07:12"]
[null,null,null,null,null,null,null,null,"2019-10-03T13:26:24"]
[null,null,null,null,null,null,null,null,"2019-10-03T05:45:36"]
[null,null,null,null,null,null,null,null,"2019-10-02T22:04:48"]
[null,null,null,null,null,null,null,null,"2019-10-02T14:24:00"]
[null,null,null,null,null,null,null,null,"2019-10-02T06:43:12"]
[null,null,null,null,null,null,null,null,"2019-10-01T23:02:24"]
[null,null,null,null,null,null,null,null,"2019-10-01T15:21:36"]
[null,null,null,null,null,null,null,null,"2019-10-01T07:40:48"]
[null,null,null,null,null,null,null,null,"2019-10-01"]
[null,null,null,null,null,null,null,null,"2019-09-30T16:19:12"]
[null,null,null,null,null,null,null,null,"2019-09-30T08:38:24"]