{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","CS_RS_PriceSheet","CS_RS_VehicleList","CS_FF_PriceSheet"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":33,"n_cols":1,"rows_kept":33}
[]
["INSTRUCTIONS"]
[]
[]
["CS_RS_PriceSheet"]
["1. For price sheet for reserved-space car-sharing, provide the main street and cross street for each location (i.e., intersection) (Column A)"]
["2. Provide the proposed number of vehicles at each intersection (Column B)"]
["3. Provide the annual price per vehicle (Column C)"]
["4. The subtotal will be calculated by mulitplying the number vehiceles by the annual price per vehicle (Column D)"]
["5. The total number of vehicles will be calculacted by summing Column B (Cell D22)"]
["6. The total annual price of vehicles will be calculacted by summing Column D (Cell D23)"]
["7. Total contract value is calcuated by multplying Cell D22 by 5 (Cell D24)"]
["8. Please add additional rows for other intersection Contractor are proposing and check formulas to ensure correct."]
["9. Grey cells are cells that require custom input"]
[]
["CS_RS_VehicleList:"]
["1. Provide license plate number for each vehicle (Column B) "]
["2. Provide make for each vehicle (Column C)"]
["3. Provide model for each vehicle (Column D) "]
["4. Provide the year vehicle was manufatured (Column E) "]
["5. Provide the engine size for each vehicle (Column F) "]
["6. Provide verification of the Certificate of Conformity (Y - Yes, N - No) (Column G) "]
[]
["CS_FF_PriceSheet"]
["1. Provide license plate number for each vehicle (Column B) "]
["2. Provide make for each vehicle (Column C)"]
["3. Provide model for each vehicle (Column D) "]
["4. Provide the year vehicle was manufatured (Column E) "]
["5. Provide the engine size for each vehicle (Column F) "]
["6. Provide verification of the Certificate of Conformity (Y - Yes, N - No) (Column G) "]
["7. Provide the annual price per vehicle (Cell G62)"]
["8. Provide the proposed total number of vehicles (Cell G63)"]
["9. Total contract value is calcuated by multplying Cell G63 by 5 (Cell G64)"]

{"sheet":"CS_RS_PriceSheet","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"merged":[[23,0,23,2],[24,0,24,2],[25,0,25,2]]}
["RESERVED-SPACE CAR-SHARING SERVICES"]
[]
["INTERSECTION","NUMBER OF VEHICLES","ANNUAL FEE PER VEHICLE","SUBTOTAL"]
["Main Street and Cross Street 1",null,null,{"$f":"B4*C4","v":0}]
["Main Street and Cross Street 2",null,null,{"$f":"B5*C5","v":0}]
["Main Street and Cross Street 3",null,null,0]
["Main Street and Cross Street 4",null,null,0]
["Main Street and Cross Street 5",null,null,0]
["Main Street and Cross Street 6",null,null,0]
["Main Street and Cross Street 7",null,null,0]
["Main Street and Cross Street 8",null,null,0]
["Main Street and Cross Street 9",null,null,0]
["Main Street and Cross Street 10",null,null,0]
["Main Street and Cross Street 11",null,null,0]
["Main Street and Cross Street 12",null,null,0]
["Main Street and Cross Street 13",null,null,0]
["Main Street and Cross Street 14",null,null,0]
["Main Street and Cross Street 15",null,null,0]
["Main Street and Cross Street 16",null,null,0]
["Main Street and Cross Street 17",null,null,0]
["Main Street and Cross Street 18",null,null,0]
["Main Street and Cross Street 19",null,null,0]
["Main Street and Cross Street 20",null,null,0]
["TOTAL NUMBER OF VEHICLES",null,null,{"$f":"SUM(B4:B23)","v":0}]
["TOTAL ANNUAL PRICE OF VEHICLES",null,null,{"$f":"SUM(D4:D23)","v":0}]
["TOTAL CONTRACT FEE (5 YEARS)",null,null,{"$f":"D25*5","v":0}]

{"sheet":"CS_RS_VehicleList","index":2,"n_rows":63,"n_cols":7,"rows_kept":63}
["RESERVED-SPACE CAR-SHARING SERVICES VEHICLE LIST"]
[]
["#","LICENSE PLATE #","MAKE","MODEL","YEAR","ENGINE SIZE","CERTIFICATE OF CONFORMITY (Y/N)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]

{"sheet":"CS_FF_PriceSheet","index":3,"n_rows":66,"n_cols":7,"rows_kept":66,"merged":[[63,0,63,5],[64,0,64,5],[65,0,65,5]]}
["FREE-FLOATING CAR-SHARING SERVICES"]
[]
["#","LICENSE PLATE #","MAKE","MODEL","YEAR","ENGINE SIZE","CERTIFICATE OF CONFORMITY (Y/N)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
["PROPOSED PRICE PER VEHICLE PER YEAR"]
["TOTAL NUMBER OF VEHICLES"]
["TOTAL CONTRACT FEE (5 YEARS)",{"$nulls":5},{"$f":"G64*G65*5","v":0}]