{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Warning","Ridership Report","SalesReport","VehicleStatus","Vanpool Fares","ExampleRidership Report","ExampleSalesReport","ExampleVehicleStatus","Sheet1"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":6,"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":"Warning","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Ridership Report","index":1,"n_rows":73,"n_cols":45,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,38,2,44],[11,11,11,12],[16,11,16,12],[17,11,17,12],[5,33,5,36],[20,11,20,12],[18,11,18,12],[19,11,19,12],[6,22,6,28],[63,23,63,24],[62,23,62,24],[61,32,61,33],[12,11,12,12],[13,11,13,12],[8,11,9,15],[15,11,15,12],[62,32,62,33],[14,11,14,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[63,32,63,33],[27,11,27,12],[63,19,63,20],[63,14,63,18],[55,15,55,16],[24,11,24,12],[25,11,25,12],[42,5,43,14],[40,5,41,14],[36,25,37,34],[36,15,37,24],[56,10,56,11],[57,23,57,24],[56,15,56,16],[67,32,67,33],[70,23,70,24],[69,32,69,33],[68,23,68,24],[69,23,69,24],[58,23,58,24],[59,23,59,24],[60,23,60,24],[61,23,61,24],[60,32,60,33],[68,32,68,33],[64,23,64,24],[65,23,65,24],[70,32,70,33],[66,23,66,24],[67,23,67,24],[65,32,65,33],[66,32,66,33],[64,32,64,33],[58,26,59,29],[65,19,65,20],[68,16,68,17],[55,4,55,5],[59,2,59,3],[56,4,56,5],[40,15,41,24],[42,15,43,24],[61,19,61,20],[36,5,37,14],[38,5,39,14],[38,15,39,24],[57,10,57,11],[58,8,58,9],[55,6,55,7],[59,6,59,7],[60,6,60,7],[60,8,60,9],[60,10,60,11],[55,8,55,9],[55,10,55,11],[59,8,59,9],[55,23,55,24],[56,23,56,24],[58,10,58,11],[57,15,57,16],[58,15,58,16],[40,35,41,44],[42,35,43,44],[31,37,32,40],[36,35,37,44],[40,25,41,34],[42,25,43,34],[38,25,39,34],[38,35,39,44],[22,1,22,9],[23,1,23,9],[24,1,24,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[26,11,26,12],[28,1,28,12],[69,2,69,3],[55,2,55,3],[56,8,56,9],[57,8,57,9],[59,10,59,11],[70,2,70,3],[68,4,68,5],[56,6,56,7],[57,4,57,5],[57,6,57,7],[58,6,58,7],[58,4,58,5],[56,2,56,3],[57,2,57,3],[58,2,58,3],[68,2,68,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[67,4,67,5],[67,6,67,7],[60,2,60,3],[59,4,59,5],[65,2,65,3],[61,4,61,5],[61,6,61,7],[62,6,62,7],[66,2,66,3],[67,2,67,3],[66,4,66,5],[63,8,63,9],[63,10,63,11],[64,6,64,7],[64,8,64,9],[63,4,63,5],[61,8,61,9],[61,10,61,11],[66,6,66,7],[66,8,66,9],[66,10,66,11],[62,10,62,11],[63,6,63,7],[67,8,67,9],[67,10,67,11],[64,10,64,11],[65,4,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,11],[64,4,64,5],[62,4,62,5],[62,8,62,9],[61,13,61,18],[70,4,70,5],[70,6,70,7],[70,8,70,9],[70,10,70,11],[68,6,68,7],[68,8,68,9],[68,10,68,11],[69,4,69,5],[69,6,69,7],[69,8,69,9],[69,10,69,11],[60,4,60,5],[8,2,9,7],[20,1,20,9],[21,1,21,9],[4,34,4,37],[4,5,4,13],[4,26,4,29],[11,1,11,7],[11,8,11,10],[12,1,12,9],[8,19,9,23],[13,1,13,9],[14,1,14,9],[15,1,15,9],[16,1,16,9],[17,1,17,9],[18,1,18,9],[19,1,19,9],[31,32,32,35],[55,32,55,33],[56,32,56,33],[58,32,58,33],[57,32,57,33],[59,32,59,33]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SalesReport!P24","v":276},null,null,null,null,null,null,null,null,{"$f":"C9/COUNTA(B13:J28)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"IF(P61=1,C9/7,IF(P61=2,C9/8,IF(P61=3,C9/11,IF(P61=4,C9/14))))","v":39.428571428571431}]
[]
[]
[null,"Name",null,null,null,null,null,null,"Pass #'s",null,null,"Totals",null,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,"*"]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C56:L56)","v":0},null,null,null,null,null,null,null,null,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":"(COUNTIF(N13:AR13,\"DR\")*2) + COUNTIF(N13:AR13,\"D\") + COUNTIF(N13:AR13,\"HD\")","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,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":"(COUNTIF(N14:AR14,\"DR\")*2) + COUNTIF(N14:AR14,\"D\") + COUNTIF(N14:AR14,\"HD\")","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Daily Rider Counts >>",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(N13:N28,\"DR\")+COUNTIFS(N13:N28,\"D\")+COUNTIFS(N13:N28,\"HD\")+COUNTIFS(N13:N28,\"X\")+COUNTIFS(N13:N28,\"\\\")","v":0},{"$f":"COUNTIFS(O13:O28,\"DR\")+COUNTIFS(O13:O28,\"D\")+COUNTIFS(O13:O28,\"HD\")+COUNTIFS(O13:O28,\"X\")+COUNTIFS(O13:O28,\"\\\")","v":0},{"$f":"COUNTIFS(P13:P28,\"DR\")+COUNTIFS(P13:P28,\"D\")+COUNTIFS(P13:P28,\"HD\")+COUNTIFS(P13:P28,\"X\")+COUNTIFS(P13:P28,\"\\\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(N29:AR29,\">\"&0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,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":"SalesReport!H19","v":0},null,null,null,null,{"$f":"SUM((T58*2)+T56)+SUM(T62*2)+T60+SUM(T64*2)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,"1)",null,null,null,null,null,null,null,null,null,"2)",null,null,null,null,null,null,null,null,null,"3)",null,null,null,null,null,null,null,null,null,"4)"]
[]
[null,null,null,null,null,"5)",null,null,null,null,null,null,null,null,null,"6)",null,null,null,null,null,null,null,null,null,"7)",null,null,null,null,null,null,null,null,null,"8)"]
[]
[null,null,null,null,null,"9)",null,null,null,null,null,null,null,null,null,"10)",null,null,null,null,null,null,null,null,null,"11)",null,null,null,null,null,null,null,null,null,"12)"]
[]
[null,null,null,null,null,"13)",null,null,null,null,null,null,null,null,null,"14)",null,null,null,null,null,null,null,null,null,"15)",null,null,null,null,null,null,null,null,null,"16)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(N13:N28)","v":0},{"$f":"COUNTA(O13:O28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"d",null,"dr",null,"hd",null,"\\",null,"x"]
[null,null,{"$f":"COUNTIF(N13:AR13,\"d\")","v":0},null,{"$f":"COUNTIF(N13:AR13,\"dr\")*2","v":0},null,{"$f":"COUNTIF(N13:AR13,\"hd\")*2","v":0},null,{"$f":"COUNTIF(N13:AR13,\"\\\")","v":0},null,{"$f":"COUNTIF(N13:AR13,\"x\")*2","v":0},null,null,null,null,"7-psg",null,null,null,{"$f":"COUNTIF(N13:AR28,\"\\\")","v":0},null,null,null,{"$f":"COUNTA(N13:AR13)","v":0},null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR13,\"\\\")","v":0},null,null,null,false,null,false,false,null,null,"Aug'18"]
[null,null,{"$f":"COUNTIF(N14:AR14,\"d\")","v":0},null,{"$f":"COUNTIF(N14:AR14,\"dr\")*2","v":0},null,{"$f":"COUNTIF(N14:AR14,\"hd\")*2","v":0},null,{"$f":"COUNTIF(N14:AR14,\"\\\")","v":0},null,{"$f":"COUNTIF(N14:AR14,\"x\")*2","v":0},null,null,null,null,"8-psg",null,null,null,null,null,null,null,{"$f":"COUNTA(N14:AR14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Sept'18"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,"11-psg",null,null,null,{"$f":"COUNTIF(N13:AR28,\"X\")","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Oct'18"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,"14-psg",null,null,null,null,null,null,null,0,null,null,{"$f":"COUNTIF(N54:AR54,\"<>0\")","v":0},null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Nov'18"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"D\")","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Dec'18"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,1,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Jan'19"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"DR\")","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Feb'19"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Mar'19"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"HD\")","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Apr'19"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"May'19"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"HD\")","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Jun'19"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P61=1,B9/8,IF(P61=2,B9/11,IF(P61=3,B9/14)))","v":0}]

{"sheet":"SalesReport","index":2,"n_rows":129,"n_cols":16,"rows_kept":129,"cut":false,"hidden":false,"merged":[[53,3,53,5],[63,3,63,4],[63,5,63,6],[45,9,45,10],[33,0,33,7],[39,0,39,3],[43,3,43,6],[29,11,29,14],[24,8,24,10],[34,2,34,4],[31,1,31,6],[30,12,30,14],[32,12,32,14],[34,12,34,14],[33,12,33,14],[25,8,31,10],[0,0,0,2],[2,3,2,5],[3,2,3,5],[8,8,8,12],[25,11,25,14],[18,3,18,6],[20,12,20,14],[21,11,21,14],[20,9,20,10],[19,8,19,9],[9,9,9,12],[22,9,22,10],[1,14,1,15],[2,14,2,15],[3,14,3,15],[19,11,19,14],[23,12,23,14],[24,12,24,14],[28,11,28,15],[21,9,21,10],[11,9,11,12],[13,10,13,12],[14,10,14,12],[15,8,15,12],[22,11,22,14]]}
["8.22.18",null,null,null,null,null,null,null,null,null,null,null,null,null,"KT Coordinator"]
[null,null,null,null,null,null,null,null,null,null,"Narrows Bridge Transponders",null,null,null,"Tommy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lindsay"]
[]
[]
["ACTUAL MILEAGE (Commute mileage with primary or spare van)",null,null,null,null,null,null,null,null,"CALCULATION FOR ALLOWABLE MILEAGE",null,null,null,null,null,false]
["Van #","Start Date","End Date","End Miles"," -","Start Miles","=","Totals"]
[null,null,null,null," -",null,"=",{"$f":"SUM(D9-F9)","v":0},"Daily Round Trip Miles (RTM's) ",null,null,null,null,20]
[null,null,null,null," -",null,"=",0,null,"Working Days Last Month ="]
[null,null,null,null," -",null,"=",0,null,"Bonus Miles (unplanned deviations only)"]
[null,null,null,null," -",null,"=",0,null,"TOTAL ALLOWABLE MILES =",null,null,null,{"$f":"(N9*N10)+N11","v":0}]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0,null,null,"TOTAL ACTUAL MILES=",null,null,{"$f":"TRANSPOSE(F47)","v":0}]
[null,null,null,null," -",null,"=",0,null,null,"Miles Over Allowable=",null,null,{"$f":"IF(H47<0,\"\",H47)","v":0},null,"5day"]
[null,null,null,null," -",null,"=",0,"     CHARGES FOR MILES OVER ALLOWABLE=",null,null,null,null,{"$f":"IF(H47>0,N15*0.54,\"\")","v":""}]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0]
[null,null,null,"Total Actual Mileages All Vans",null,null,null,{"$f":"SUM(H9:H18)","v":0},null,null,null,null,null,"CHARGES"]
[null,"NON-COMMUTE MILEAGE (trade-outs, etc.)",null,null,null,null,null,null,"VAN WASH",null,null,"Transponder Surcharge =",null,null,null,{"$f":"IF(AND(P7,P15=\"5day\"),105, IF(AND(P7,P15=\"4day\"),80,IF(AND(P7,P15=\"6day\"),120,IF(AND(P7,P15=\"7day\"),150,0))))","v":0}]
["Van #","Start Date","End Date","End Miles"," -","Start Miles","=","Totals","Date","Location",null,null,"Monthly Fixed Fare=",null,null,{"$f":"D54","v":276}]
[null,null,null,null," -",null,"=",{"$f":"SUM(D22-F22)","v":0},null,null,null,"Miles Over Allowable Charge=",null,null,null,{"$f":"TRANSPOSE(N16)","v":""}]
[null,null,null,null," -",null,"=",0,null,null,null,"Late Fee (if postmarked after the 9th)="]
[null,null,null,null," -",null,"=",0,null,null,null,null,"TOTAL CHARGES=",null,null,{"$f":"SUM(P20,P21:P23)","v":276}]
[null,null,null,null," -",null,"=",0,"Comments",null,null,null,"TOTAL DEDUCTIONS=",null,null,{"$f":"TRANSPOSE(H44)","v":0}]
[null,null,null,null," -",null,"=",0,null,null,null,"TOTAL AMOUNT DUE=",null,null,null,{"$f":"(P24-H44)","v":276}]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0,null,null,null,"PAYMENT METHODS"]
[null,null,null,null," -",null,"=",0,null,null,null,"Commuter Checks (Vouchers)="]
[null,null,null,null," -",null,"=",0,null,null,null,null,"Cash="]
[null,"Total Non-Commute Mileages All Vans",null,null,null,null,null,{"$f":"SUM(H22:H31)","v":0},null,null,null,null,null,null,"Checks="]
[null,null,null,null,null,null,null,null,null,null,null,null,"Online Payment Site="]
["DEDUCTIONS",null,null,null,null,null,null,null,null,null,null,null,"TOTAL AMOUNT PAID=",null,null,{"$f":"SUM(P30:P33)","v":0}]
[null,null,"(Number of Credits)",null,null,null,null,null,null,null,null,null,"Difference=",null,null,{"$f":"(P34-P26)","v":-276}]
[null,null,null,null,null,"(Credit Value",null,"(Credit "]
[null,null,null,null,null,"per Rider)",null,"Deduction)"]
["*U-Pass Credit(up to $70)",null,null,null,null,0,"=",{"$f":"(E38*F38)","v":0}]
["*Orca Passport",null,null,null,null,0,"=",0,null,null,1,{"$f":"'Ridership Report'!K13","v":0},8,{"$f":"'Ridership Report'!K20","v":0},15,{"$f":"'Ridership Report'!K27","v":0}]
[null,null,null,null,null,0,"=",0,null,null,2,{"$f":"'Ridership Report'!K14","v":0},9,{"$f":"'Ridership Report'!K21","v":0},16,{"$f":"'Ridership Report'!K28","v":0}]
["**Approved KT Credits/Expenditures",null,null,null,null,null,"=",0,null,null,3,{"$f":"'Ridership Report'!K15","v":0},10,{"$f":"'Ridership Report'!K22","v":0},17,{"$f":"'Ridership Report'!K30","v":0}]
["Bank Account Credit",null,null,null,null,5,"=",0,null,null,4,{"$f":"'Ridership Report'!K16","v":0},11,{"$f":"'Ridership Report'!K23","v":0}]
["Van Wash Credit",null,null,null,null,10,"=",0,null,null,5,{"$f":"'Ridership Report'!K17","v":0},12,{"$f":"'Ridership Report'!K24","v":0}]
[null,null,null,"TOTAL DEDUCTION",null,null,null,{"$f":"SUM(H37:H43)","v":0},null,null,6,{"$f":"'Ridership Report'!K18","v":0},13,{"$f":"'Ridership Report'!K25","v":0}]
[null,null,null,null,null,null,null,null,null,null,7,{"$f":"'Ridership Report'!K19","v":0},14,{"$f":"'Ridership Report'!K26","v":0}]
[]
["Aug'18",null,"  7-psg",{"$f":"(H19-F32)","v":0},null,{"$f":"(H19-H32)","v":0},null,{"$f":"N14-N12","v":0}]
["Sept'18",null,"  8-psg"]
["Oct'18",null,"11-psg"]
["Nov'18",null,"14-psg"]
["Dec'18",null,null,null,null,{"$f":"I4","v":0}]
["Jan'19"]
["Feb'19"]
["Mar'19",null,"FARE",{"$f":"IF(P15=\"5day\",INDEX($D$66:$E$102,MATCH(I59,$C$66:$C$102,1),MATCH(G59,$D$65:$E$65,0)), IF(P15=\"4day\",INDEX($F$66:$G$102,MATCH(I59,$C$66:$C$102,1),MATCH(G59,$F$65:$G$65,0)), IF(P15=\"7day\",INDEX($H$66:$I$102,MATCH(I59,$C$66:$C$102,1),MATCH(G$59,$H$65:I65,0)), IF(P15=\"6day\",INDEX($J$66:$K$102,MATCH(I59,$C$66:$C$102,1),MATCH(G$59,$J$65:K65,0)),\"\"))))","v":276}]
["Apr'19"]
["May'19"]
["Jun'19",null,"RTM",35,null,null,2]
[null,null,null,null,null,null,null,null,"Ceiling"]
[null,null,null,null,null,null,{"$f":"IF(G57=1,\"Small\",IF(G57=2,\"Small\",IF(G57=3,\"Large\",IF(G57=4,\"Large\"))))","v":"Small"},null,{"$f":"CEILING(N9,5)","v":20}]
[null,null,"SIZE","SMALL"]
[]
[]
[]
[null,null,null,"5day",null,"4day",null,"7day",null,"6day"]
[null,null,"RTM","SMALL","LARGE","SMALL","LARGE","SMALL","LARGE","SMALL","LARGE"]
[null,null,20,276,396,{"$f":"(D66/21)*16","v":210.28571428571428},{"$f":"(E66/21)*16","v":301.71428571428572},{"$f":"(D66/21)*30","v":394.28571428571428},{"$f":"(E66/21)*30","v":565.71428571428578},{"$f":"(D66/21)*24","v":315.42857142857144},{"$f":"(E66/21)*24","v":452.57142857142856}]
[null,null,25,309,434,{"$f":"(D67/21)*16","v":235.42857142857142},330.66666666666669,{"$f":"(D67/21)*30","v":441.42857142857139},{"$f":"(E67/21)*30","v":620},{"$f":"(D67/21)*24","v":353.14285714285711},{"$f":"(E67/21)*24","v":496}]
[null,null,30,321,472,244.57142857142858,359.61904761904759,458.57142857142861,674.28571428571422,366.85714285714289,539.42857142857133]
[null,null,35,375,510,285.71428571428572,388.57142857142856,535.71428571428578,728.57142857142856,428.57142857142856,582.85714285714289]
[null,null,40,428,548,326.09523809523807,417.52380952380952,611.42857142857133,782.85714285714289,489.14285714285711,626.28571428571422]
[null,null,45,482,587,367.23809523809524,447.23809523809524,688.57142857142856,838.57142857142856,550.85714285714289,670.85714285714289]
[null,null,50,536,625,408.38095238095241,476.1904761904762,765.71428571428578,892.85714285714289,612.57142857142867,714.28571428571433]
[null,null,55,589,648,448.76190476190476,493.71428571428572,841.42857142857144,925.71428571428578,673.14285714285711,740.57142857142856]
[null,null,60,643,707,489.90476190476193,538.66666666666663,918.57142857142867,1009.9999999999999,734.85714285714289,808]
[null,null,65,696,766,530.28571428571433,583.61904761904759,994.28571428571433,1094.2857142857142,795.42857142857156,875.42857142857133]
[null,null,70,750,825,571.42857142857144,628.57142857142856,1071.4285714285716,1178.5714285714284,857.14285714285711,942.85714285714289]
[null,null,75,803,884,611.80952380952385,673.52380952380952,1147.1428571428573,1262.8571428571429,917.71428571428578,1010.2857142857142]
[null,null,80,857,942,652.95238095238096,717.71428571428567,1224.2857142857142,1345.7142857142856,979.42857142857144,1076.5714285714284]
[null,null,85,910,1001,693.33333333333337,762.66666666666663,1300,1430,1040,1144]
[null,null,90,964,1060,734.47619047619048,807.61904761904759,1377.1428571428571,1514.2857142857142,1101.7142857142858,1211.4285714285713]
[null,null,95,1017,1119,774.85714285714289,852.57142857142856,1452.8571428571429,1598.5714285714284,1162.2857142857142,1278.8571428571429]
[null,null,100,1071,1178,816,897.52380952380952,1530,1682.8571428571429,1224,1346.2857142857142]
[null,null,105,1125,1237,{"$f":"(D83/21)*16","v":857.14285714285711},942.47619047619048,{"$f":"(D83/21)*30","v":1607.1428571428571},1767.1428571428571,1285.7142857142858,1413.7142857142858]
[null,null,110,1178,1296,897.52380952380952,987.42857142857144,1682.8571428571429,1851.4285714285716,1346.2857142857142,1481.1428571428571]
[null,null,115,1232,1355,938.66666666666663,1032.3809523809523,1760,1935.7142857142856,1408,1548.5714285714284]
[null,null,120,1285,1414,979.04761904761904,1077.3333333333333,1835.7142857142858,2019.9999999999998,1468.5714285714284,1616]
[null,null,125,1339,1473,1020.1904761904761,1122.2857142857142,1912.8571428571427,2104.2857142857142,1530.2857142857142,1683.4285714285713]
[null,null,130,1392,1532,1060.5714285714287,1167.2380952380952,1988.5714285714287,2188.5714285714284,1590.8571428571431,1750.8571428571427]
[null,null,135,1446,1590,1101.7142857142858,1211.4285714285713,2065.7142857142858,2271.4285714285711,1652.5714285714287,1817.1428571428569]
[null,null,140,1499,1649,1142.0952380952381,1256.3809523809523,2141.4285714285716,2355.7142857142853,1713.1428571428571,1884.5714285714284]
[null,null,145,1553,1708,1183.2380952380952,1301.3333333333333,2218.5714285714284,2440,1774.8571428571427,1952]
[null,null,150,1607,1767,1224.3809523809523,1346.2857142857142,2295.7142857142853,2524.2857142857142,1836.5714285714284,2019.4285714285713]
[null,null,155,1660,1826,1264.7619047619048,1391.2380952380952,2371.4285714285716,2608.5714285714284,1897.1428571428573,2086.8571428571427]
[null,null,160,1714,1885,1305.9047619047619,1436.1904761904761,2448.5714285714284,2692.8571428571427,1958.8571428571429,2154.2857142857142]
[null,null,165,1767,1944,1346.2857142857142,1481.1428571428571,2524.2857142857142,2777.1428571428569,2019.4285714285713,2221.7142857142858]
[null,null,170,1821,2003,1387.4285714285713,1526.0952380952381,2601.4285714285711,2861.4285714285716,2081.1428571428569,2289.1428571428569]
[null,null,175,1874,2062,1427.8095238095239,1571.047619047619,2677.1428571428573,2945.7142857142858,2141.7142857142858,2356.5714285714284]
[null,null,180,1928,2121,1468.952380952381,1616,2754.2857142857142,3030,2203.4285714285716,2424]
[null,null,185,1981,2179,1509.3333333333333,1660.1904761904761,2830,3112.8571428571427,2264,2490.2857142857142]
[null,null,190,2035,2238,1550.4761904761904,1705.1428571428571,2907.1428571428569,3197.1428571428569,2325.7142857142853,2557.7142857142858]
[null,null,195,2088,2297,1590.8571428571429,1750.0952380952381,2982.8571428571431,3281.4285714285716,2386.2857142857142,2625.1428571428569]
[null,null,200,2142,2356,1632,1795.047619047619,3060,3365.7142857142858,2448,2692.5714285714284]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DROP DOWN OPTIONS"]
[null,null,"SMALL"]
[null,null,"LARGE"]
[]
[null,null,"5day"]
[null,null,"4day"]
[null,null,"7day"]
[null,null,"6day"]

{"sheet":"VehicleStatus","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[31,1,41,7],[5,2,5,4],[5,0,5,1],[1,0,1,8]]}
["Please call Kitsap Transit's Maintenance Department at 360-478-6221 with any immediate concerns."]
["KITSAP TRANSIT VEHICLE INSPECTION REPORT"]
[]
["Van #:",null,null,"Date:"]
[]
["Prepared by:"]
[]
[]
[]
[null,null,"Parking brake holds on incline"]
[null,null,"Headlights operate and are aimed properly"]
[null,null,"Stop, tail and signal lights are operational"]
[null,null,"Windshield/windows free of chips & cracks"]
[null,null,"Windshield wipers/washers are in good condition"]
[null,null,"Tires properly inflated, tread depth over 1/16\""]
[null,null,"Tires with no breaks, cuts or bulges/wearing evenly"]
[null,null,"Heater, defroster and air conditioner OK"]
[null,null,"All safety belts operation/in good condition"]
[null,null,"All belts and hoses free of cracks/bulges"]
[null,null,"Horn operational"]
[null,null,"Exhaust system & muffler OK"]
[null,null,"Free of vibration when steering"]
[null,null,"Gauges registering properly"]
[null,null,"Proper coolant/antifreeze level"]
[null,null,"Proper engine oil level"]
[null,null,"Free of unusual noises"]
[null,null,"All emergency equipment in van "]
[null,null,"Free of exterior body damage"]
[null,null,"Free of fluid leaks under van"]
[null,null,"Upon braking, van stops in straight line"]
[null,null,"Explain each \"No\" response:"]

{"sheet":"Vanpool Fares","index":4,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,3,2,4],[0,0,0,4]]}
["General Vanpool Fares"]
[]
["7 & 8-Passenger \"Small Vans\"",null,null,"11 & 14-passenger \"Large Vans\""]
["Trip","New",null,"Trip","New"]
["Miles","Rate",null,"Miles","Rate"]
[20,276,null,20,396]
[25,309,null,25,434]
[30,321,null,30,472]
[35,375,null,35,510]
[40,428,null,40,548]
[45,482,null,45,587]
[50,536,null,50,625]
[55,589,null,55,648]
[60,643,null,60,707]
[65,696,null,65,766]
[70,750,null,70,825]
[75,803,null,75,884]
[80,857,null,80,942]
[85,910,null,85,1001]
[90,964,null,90,1060]
[95,1017,null,95,1119]
[100,1071,null,100,1178]
[105,1125,null,105,1237]
[110,1178,null,110,1296]
[115,1232,null,115,1355]
[120,1285,null,120,1414]
[125,1339,null,125,1473]
[130,1392,null,130,1532]
[135,1446,null,135,1590]
[140,1499,null,140,1649]
[145,1553,null,145,1708]
[150,1607,null,150,1767]
[155,1660,null,155,1826]
[160,1714,null,160,1885]
[165,1767,null,165,1944]
[170,1821,null,170,2003]
[175,1874,null,175,2062]
[180,1928,null,180,2121]
[185,1981,null,185,2179]
[190,2035,null,190,2238]
[195,2088,null,195,2297]
[200,2142,null,200,2356]

{"sheet":"ExampleRidership Report","index":5,"n_rows":72,"n_cols":45,"rows_kept":72,"cut":false,"hidden":false,"merged":[[68,23,68,24],[68,32,68,33],[69,2,69,3],[69,4,69,5],[66,32,66,33],[67,2,67,3],[67,4,67,5],[67,6,67,7],[67,8,67,9],[67,10,67,11],[69,6,69,7],[69,8,69,9],[69,10,69,11],[69,23,69,24],[69,32,69,33],[68,2,68,3],[68,4,68,5],[68,6,68,7],[68,8,68,9],[68,10,68,11],[65,32,65,33],[64,2,64,3],[67,16,67,17],[67,23,67,24],[67,32,67,33],[66,2,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,10,66,11],[66,23,66,24],[65,2,65,3],[65,4,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,11],[65,23,65,24],[64,23,64,24],[64,32,64,33],[60,10,60,11],[63,32,63,33],[62,2,62,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[64,19,64,20],[62,19,62,20],[62,4,62,5],[62,6,62,7],[63,2,63,3],[63,4,63,5],[63,6,63,7],[63,8,63,9],[63,10,63,11],[63,23,63,24],[61,23,61,24],[62,23,62,24],[62,32,62,33],[59,2,59,3],[59,4,59,5],[59,6,59,7],[59,8,59,9],[59,10,59,11],[59,23,59,24],[59,32,59,33],[60,13,60,18],[62,14,62,18],[60,19,60,20],[60,23,60,24],[60,32,60,33],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[62,8,62,9],[62,10,62,11],[61,32,61,33],[60,2,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[56,15,56,16],[57,2,57,3],[57,4,57,5],[57,6,57,7],[57,8,57,9],[57,10,57,11],[56,23,56,24],[56,32,56,33],[57,26,58,29],[57,32,57,33],[58,32,58,33],[56,2,56,3],[56,4,56,5],[56,6,56,7],[56,8,56,9],[56,10,56,11],[58,2,58,3],[58,4,58,5],[57,23,57,24],[58,6,58,7],[58,8,58,9],[58,10,58,11],[58,23,58,24],[54,23,54,24],[54,32,54,33],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,9],[55,10,55,11],[55,15,55,16],[55,23,55,24],[55,32,55,33],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,10,54,11],[54,15,54,16],[25,1,25,9],[25,11,25,12],[26,1,26,9],[26,11,26,12],[27,1,27,9],[27,11,27,12],[37,5,38,14],[37,15,38,24],[37,25,38,34],[30,32,31,35],[30,37,31,40],[35,5,36,14],[35,15,36,24],[35,25,36,34],[35,35,36,44],[41,5,42,14],[41,15,42,24],[41,25,42,34],[41,35,42,44],[37,35,38,44],[39,5,40,14],[39,15,40,24],[39,25,40,34],[39,35,40,44],[23,1,23,9],[23,11,23,12],[24,1,24,9],[24,11,24,12],[15,1,15,9],[15,11,15,12],[16,1,16,9],[16,11,16,12],[17,1,17,9],[17,11,17,12],[20,1,20,9],[20,11,20,12],[21,1,21,9],[21,11,21,12],[22,1,22,9],[22,11,22,12],[18,1,18,9],[18,11,18,12],[19,1,19,9],[19,11,19,12],[14,1,14,9],[14,11,14,12],[1,38,2,44],[4,5,4,13],[4,26,4,29],[4,34,4,37],[5,33,5,36],[6,22,6,28],[8,2,9,7],[11,1,11,7],[11,8,11,10],[11,11,11,12],[12,1,12,9],[12,11,12,12],[13,1,13,9],[8,11,9,15],[8,19,9,23],[13,11,13,12]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CK222"]
[]
[]
[null,null,null,null,null,"Mickey Mouse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]
[]
[]
[]
[null,null,596,null,null,null,null,null,null,null,null,{"$f":"C9/COUNTA(B13:J28)","v":85.142857142857139},null,null,null,null,null,null,null,{"$f":"IF(P60=1,C9/8,IF(P60=2,C9/11,IF(P60=3,C9/14)))","v":74.5}]
[]
[]
[null,"Name",null,null,null,null,null,null,"Pass #'s",null,null,"Totals",null,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,"*"]
[1,"Mickey Mouse",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C55:L55)","v":43},null,"D","HD","HD","HD","HD",null,null,"X","X","X","X","X",null,null,"HD","HD","HD","HD","HD",null,null,"DR","DR","DR","DR","DR",null,"X","X",null,null,{"$f":"(COUNTIF(N13:AR13,\"DR\")*2) + COUNTIF(N13:AR13,\"D\") + COUNTIF(N13:AR13,\"HD\")","v":20}]
[2,"Donald Duck",null,null,null,null,null,null,null,null,null,34,null,"X","X","X","X","X",null,null,"\\","\\","\\","\\","\\",null,null,"\\","\\","\\","\\","\\",null,null,"X","X","X","X","X",null,"X","X",null,null,{"$f":"(COUNTIF(N14:AR14,\"DR\")*2) + COUNTIF(N14:AR14,\"D\") + COUNTIF(N14:AR14,\"HD\")","v":0}]
[3,"Minnie Mouse",null,null,null,null,null,null,null,null,"UPASS",41,null,"D","HD","HD","HD","HD",null,null,"DR","DR","DR","DR","DR",null,null,"HD","HD","HD","HD","HD",null,null,"X","X","X","X","X",null,"X","L",null,null,20]
[4,"Goofy Dog",null,null,null,null,null,null,null,null,null,38,null,"L","L","L","X","X",null,null,"X","X","X","X","X",null,null,"X","X","X","X","X",null,null,"X","X","X","X","X",null,"X","X",null,null,0]
[5,"Daisey Duck",null,null,null,null,null,null,null,null,null,33,null,"X","X","X","X","X",null,null,"X","X","X","X","X",null,null,"\\","\\","\\","\\","\\",null,null,"\\","\\","\\","\\","X",null,"\\","\\",null,null,0]
[6,"Porky Pig",null,null,null,null,null,null,null,null,null,36,null,"X","X","X","X","X",null,null,"X","X","X","X","X",null,null,"X","X","X","L","L",null,null,"L","L","X","X","X",null,"X","X",null,null,0]
[7,"Snow White",null,null,null,null,null,null,null,null,"S99857526",44,null,"X","X","X","X","X",null,null,"X","X","X","X","X",null,null,"X","X","X","X","X",null,null,"X","X","X","X","X",null,"X","X",null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,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":"SalesReport!H19","v":0},null,null,null,null,{"$f":"SUM((T57*2)+T55)+SUM(T61*2)+T59+SUM(T63*2)","v":269}]
[]
[]
[]
[]
[null,null,null,null,null,"1)",null,null,null,null,null,null,null,null,null,"2)",null,null,null,null,null,null,null,null,null,"3)",null,null,null,null,null,null,null,null,null,"4)"]
[]
[null,null,null,null,null,"5)",null,null,null,null,null,null,null,null,null,"6)",null,null,null,null,null,null,null,null,null,"7)",null,null,null,null,null,null,null,null,null,"8)"]
[]
[null,null,null,null,null,"9)",null,null,null,null,null,null,null,null,null,"10)",null,null,null,null,null,null,null,null,null,"11)",null,null,null,null,null,null,null,null,null,"12)"]
[]
[null,null,null,null,null,"12)",null,null,null,null,null,null,null,null,null,"14)",null,null,null,null,null,null,null,null,null,"15)",null,null,null,null,null,null,null,null,null,"16)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(N13:N28)","v":7},{"$f":"COUNTA(O13:O28)","v":7},7,7,7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,7,7,0,0]
[null,null,"d",null,"dr",null,"hd",null,"\\",null,"x"]
[null,null,{"$f":"COUNTIF(N13:AR13,\"d\")","v":1},null,{"$f":"COUNTIF(N13:AR13,\"dr\")*2","v":10},null,{"$f":"COUNTIF(N13:AR13,\"hd\")*2","v":18},null,{"$f":"COUNTIF(N13:AR13,\"\\\")","v":0},null,{"$f":"COUNTIF(N13:AR13,\"x\")*2","v":14},null,null,null,null,"8-psg",null,null,null,{"$f":"COUNTIF(N13:AR28,\"\\\")","v":21},null,null,null,{"$f":"COUNTA(N13:AR13)","v":22},null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR13,\"\\\")","v":0},null,null,null,false,null,false,false,null,null,"Dec'11"]
[null,null,{"$f":"COUNTIF(N14:AR14,\"d\")","v":0},null,{"$f":"COUNTIF(N14:AR14,\"dr\")*2","v":0},null,{"$f":"COUNTIF(N14:AR14,\"hd\")*2","v":0},null,{"$f":"COUNTIF(N14:AR14,\"\\\")","v":10},null,{"$f":"COUNTIF(N14:AR14,\"x\")*2","v":24},null,null,null,null,"11-psg",null,null,null,null,null,null,null,{"$f":"COUNTA(N14:AR14)","v":22},null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Jan'12"]
[null,null,1,null,10,null,18,null,0,null,12,null,null,null,null,"14-psg",null,null,null,{"$f":"COUNTIF(N13:AR28,\"X\")","v":95},null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Feb'12"]
[null,null,0,null,0,null,0,null,0,null,38,null,null,null,null,null,null,null,null,null,null,null,null,22,null,null,{"$f":"COUNTIF(N53:AR53,\"<>0\")","v":22},null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Mar'12"]
[null,null,0,null,0,null,0,null,11,null,22,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"D\")","v":2},null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Apr'12"]
[null,null,0,null,0,null,0,null,0,null,36,null,null,null,null,1,null,null,null,null,null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"May'12"]
[null,null,0,null,0,null,0,null,0,null,44,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"DR\")","v":10},null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Jun'12"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Jul'12"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"HD\")","v":18},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Aug'12"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Sep'12"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N13:AR28,\"HD\")","v":18},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Oct'12"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Nov'12"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,null,null,"Dec'12"]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P60=1,B9/8,IF(P60=2,B9/11,IF(P60=3,B9/14)))","v":0}]

{"sheet":"ExampleSalesReport","index":6,"n_rows":128,"n_cols":16,"rows_kept":128,"cut":false,"hidden":false,"merged":[[53,3,53,5],[63,3,63,4],[63,5,63,6],[34,2,34,4],[38,0,38,3],[43,3,43,6],[45,9,45,10],[31,1,31,6],[32,12,32,14],[33,12,33,14],[33,0,33,7],[34,12,34,14],[15,8,15,12],[24,8,24,10],[24,12,24,14],[25,8,31,10],[25,11,25,14],[28,11,28,15],[29,11,29,14],[30,12,30,14],[21,9,21,10],[21,11,21,14],[22,9,22,10],[22,11,22,14],[23,12,23,14],[8,8,8,12],[9,9,9,12],[11,9,11,12],[13,10,13,12],[14,10,14,12],[18,3,18,6],[19,8,19,9],[19,11,19,14],[20,9,20,10],[20,12,20,14],[0,0,0,2],[1,14,1,15],[2,3,2,5],[2,14,2,15],[3,2,3,5],[3,14,3,15]]}
["Revised: 11.5.13",null,null,null,null,null,null,null,null,null,null,null,null,null,"KT Coordinator"]
[null,null,null,null,null,null,null,null,123,null,"Narrows Bridge Transponders",null,null,null,"Tommy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dee"]
[null,null,"Mickey Mouse",null,null,null,null,null,null,null,null,"CK222",null,null,"Cyndi"]
[]
[]
["ACTUAL MILEAGE (Commute mileage with primary or spare van)",null,null,null,null,null,null,null,null,"CALCULATION FOR ALLOWABLE MILEAGE",null,null,null,null,null,true]
["Van #","Start Date","End Date","End Miles"," -","Start Miles","=","Totals"]
[123,"2012-03-01","2012-03-29",50000," -",49000,"=",{"$f":"SUM(D9-F9)","v":1000},"Daily Round Trip Miles (RTM's) ",null,null,null,null,50]
[null,null,null,null," -",null,"=",0,null,"Working Days Last Month =",null,null,null,22]
[null,null,null,null," -",null,"=",0,null,"Bonus Miles (unplanned deviations only)"]
[null,null,null,null," -",null,"=",0,null,"TOTAL ALLOWABLE MILES =",null,null,null,{"$f":"(N9*N10)+N11","v":1100}]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0,null,null,"TOTAL ACTUAL MILES=",null,null,{"$f":"TRANSPOSE(F47)","v":980}]
[null,null,null,null," -",null,"=",0,null,null,"Miles Over Allowable=",null,null,{"$f":"IF(H47<0,\"\",H47)","v":""},null,"5day"]
[null,null,null,null," -",null,"=",0,"     CHARGES FOR MILES OVER ALLOWABLE=",null,null,null,null,{"$f":"IF(H47>0,N15*0.555,\"\")","v":""}]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0]
[null,null,null,"Total Actual Mileages All Vans",null,null,null,{"$f":"SUM(H9:H18)","v":1000},null,null,null,null,null,"CHARGES"]
[null,"NON-COMMUTE MILEAGE (trade-outs, etc.)",null,null,null,null,null,null,"VAN WASH",null,null,"Transponder Surcharge ($60) =",null,null,null,{"$f":"IF(P7, 89, 0)","v":89}]
["Van #","Start Date","End Date","End Miles"," -","Start Miles","=","Totals","Date","Location",null,null,"Monthly Fixed Fare=",null,null,{"$f":"D54+P20","v":625}]
[123,"2012-03-15","2012-03-15",49600," -",49580,"=",{"$f":"SUM(D22-F22)","v":20},"2012-03-24","Mickey's House",null,"Miles Over Allowable Charge=",null,null,null,{"$f":"TRANSPOSE(N16)","v":""}]
[null,null,null,null," -",null,"=",0,null,null,null,"Late Fee (if postmarked after the 7th)="]
[null,null,null,null," -",null,"=",0,null,null,null,null,"TOTAL CHARGES=",null,null,{"$f":"SUM(P21:P23)","v":625}]
[null,null,null,null," -",null,"=",0,"Comments",null,null,null,"TOTAL DEDUCTIONS=",null,null,{"$f":"TRANSPOSE(H44)","v":170.14}]
[null,null,null,null," -",null,"=",0,null,null,null,"TOTAL AMOUNT DUE=",null,null,null,{"$f":"(P24-H44)","v":454.86}]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0]
[null,null,null,null," -",null,"=",0,null,null,null,"PAYMENT METHODS"]
[null,null,null,null," -",null,"=",0,null,null,null,"Commuter Checks (Vouchers)=",null,null,null,225]
[null,null,null,null," -",null,"=",0,null,null,null,null,"Cash="]
[null,"Total Non-Commute Mileages All Vans",null,null,null,null,null,{"$f":"SUM(H22:H31)","v":20},null,null,null,null,null,null,"Checks=",100.86]
[null,null,null,null,null,null,null,null,null,null,null,null,"Online Payment Site=",null,null,129]
["DEDUCTIONS",null,null,null,null,null,null,null,null,null,null,null,"TOTAL AMOUNT PAID=",null,null,{"$f":"SUM(P30:P33)","v":454.86}]
[null,null,"(Number of Credits)",null,null,"(Credit Value",null,null,null,null,null,null,"Difference=",null,null,{"$f":"(P34-P26)","v":0}]
[null,null,null,null,null,"per Rider)",null,"(Credit Deduction)"]
["*U-Pass Credit(up to $70)",null,null,null,1,70,"=",{"$f":"(E37*F37)","v":70}]
["*Orca Passport",null,null,null,1,85.14,"=",85.14]
[null,null,null,null,null,0,"=",0,null,null,1,{"$f":"'ExampleRidership Report'!K13","v":0}]
["*Federal Flex Pass",null,null,null,null,0,"=",0,null,null,2,{"$f":"'ExampleRidership Report'!K14","v":0},8,{"$f":"'ExampleRidership Report'!K20","v":0},15,{"$f":"'Ridership Report'!K27","v":0}]
["**Approved KT Credits/Expenditures",null,null,null,null,0,"=",0,null,null,3,{"$f":"'ExampleRidership Report'!K15","v":"UPASS"},9,{"$f":"'ExampleRidership Report'!K21","v":0},16,{"$f":"'Ridership Report'!K28","v":0}]
["Bank Account Fee ",null,null,null,1,5,"=",5,null,null,4,{"$f":"'ExampleRidership Report'!K16","v":0},10,{"$f":"'ExampleRidership Report'!K22","v":0},17,{"$f":"'Ridership Report'!K37","v":0}]
["Van Wash Expense",null,null,null,1,10,"=",10,null,null,5,{"$f":"'ExampleRidership Report'!K17","v":0},11,{"$f":"'ExampleRidership Report'!K23","v":0}]
[null,null,null,"TOTAL DEDUCTION",null,null,null,{"$f":"SUM(H37:H43)","v":170.14},null,null,6,{"$f":"'ExampleRidership Report'!K18","v":0},12,{"$f":"'ExampleRidership Report'!K24","v":0}]
[null,null,null,null,null,null,null,null,null,null,7,{"$f":"'ExampleRidership Report'!K19","v":"S99857526"},13,{"$f":"'ExampleRidership Report'!K25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"'ExampleRidership Report'!K26","v":0}]
["Dec'11",null,"8-psg",{"$f":"(H19-F32)","v":1000},null,{"$f":"(H19-H32)","v":980},null,{"$f":"N14-N12","v":-120}]
["Jan'12",null,"11-psg"]
["Feb'12",null,"14-psg"]
["Mar'12"]
["Apr'12",null,null,null,null,{"$f":"I4","v":0}]
["May'12"]
["Jun'12"]
["Jul'12",null,"FARE",{"$f":"IF(P15=\"5day\",INDEX($D$66:$E$102,MATCH(I59,$C$66:$C$102,1),MATCH(G59,$D$65:$E$65,0)),IF(P15=\"4day\",INDEX($F$66:$G$102,MATCH(I59,$C$66:$C$102,1),MATCH(G59,$F$65:$G$65,0)),IF(P15=\"7day\",INDEX($H$67:$I$103,MATCH(I59,$C$66:$C$102,1),MATCH($G$59,$H$66:I66,0)),\"\")))","v":536}]
["Aug'12"]
["Sep'12"]
["Oct'12",null,"RTM",35,null,null,1]
["Nov'12",null,null,null,null,null,null,null,"Ceiling"]
["Dec'12",null,null,null,null,null,{"$f":"IF(G57=1,\"Small\",IF(G57=2,\"LARGE\",IF(G57=3,\"Large\")))","v":"Small"},null,{"$f":"CEILING(N9,5)","v":50}]
[null,null,"SIZE","SMALL"]
[]
[null,null,"WORK WEEK","5day"]
[]
[null,null,null,"5day",null,"4day",null,"7day"]
[null,null,"RTM","SMALL","LARGE","SMALL","LARGE","SMALL"]
[null,null,20,276,396,{"$f":"(D66/21)*16","v":210.28571428571428},{"$f":"(E66/21)*16","v":301.71428571428572},{"$f":"(D66/21)*30","v":394.28571428571428},"LARGE"]
[null,null,25,309,434,{"$f":"(D67/21)*16","v":235.42857142857142},330.66666666666669,{"$f":"(D67/21)*30","v":441.42857142857139},{"$f":"(E66/21)*30","v":565.71428571428578}]
[null,null,30,321,472,244.57142857142858,359.61904761904759,458.57142857142861,620]
[null,null,35,375,510,285.71428571428572,388.57142857142856,535.71428571428578,674.28571428571422]
[null,null,40,428,548,326.09523809523807,417.52380952380952,611.42857142857133,728.57142857142856]
[null,null,45,482,587,367.23809523809524,447.23809523809524,688.57142857142856,782.85714285714289]
[null,null,50,536,625,408.38095238095241,476.1904761904762,765.71428571428578,838.57142857142856]
[null,null,55,589,648,448.76190476190476,493.71428571428572,841.42857142857144,892.85714285714289]
[null,null,60,643,707,489.90476190476193,538.66666666666663,918.57142857142867,925.71428571428578]
[null,null,65,696,766,530.28571428571433,583.61904761904759,994.28571428571433,1009.9999999999999]
[null,null,70,750,825,571.42857142857144,628.57142857142856,1071.4285714285716,1094.2857142857142]
[null,null,75,803,884,611.80952380952385,673.52380952380952,1147.1428571428573,1178.5714285714284]
[null,null,80,857,942,652.95238095238096,717.71428571428567,1224.2857142857142,1262.8571428571429]
[null,null,85,910,1001,693.33333333333337,762.66666666666663,1300,1345.7142857142856]
[null,null,90,964,1060,734.47619047619048,807.61904761904759,1377.1428571428571,1430]
[null,null,95,1017,1119,774.85714285714289,852.57142857142856,1452.8571428571429,1514.2857142857142]
[null,null,100,1071,1178,816,897.52380952380952,1530,1598.5714285714284]
[null,null,105,1125,1237,{"$f":"(D83/21)*16","v":857.14285714285711},942.47619047619048,{"$f":"(D83/21)*30","v":1607.1428571428571},1682.8571428571429]
[null,null,110,1178,1296,897.52380952380952,987.42857142857144,1682.8571428571429,1767.1428571428571]
[null,null,115,1285,1355,979.04761904761904,1032.3809523809523,1835.7142857142858,1851.4285714285716]
[null,null,120,1323,1414,1008,1077.3333333333333,1890,1935.7142857142856]
[null,null,125,1339,1473,1020.1904761904761,1122.2857142857142,1912.8571428571427,2019.9999999999998]
[null,null,130,1392,1532,1060.5714285714287,1167.2380952380952,1988.5714285714287,2104.2857142857142]
[null,null,135,1446,1590,1101.7142857142858,1211.4285714285713,2065.7142857142858,2188.5714285714284]
[null,null,140,1499,1649,1142.0952380952381,1256.3809523809523,2141.4285714285716,2271.4285714285711]
[null,null,145,1553,1708,1183.2380952380952,1301.3333333333333,2218.5714285714284,2355.7142857142853]
[null,null,150,1607,1767,1224.3809523809523,1346.2857142857142,2295.7142857142853,2440]
[null,null,155,1660,1826,1264.7619047619048,1391.2380952380952,2371.4285714285716,2524.2857142857142]
[null,null,160,1714,1885,1305.9047619047619,1436.1904761904761,2448.5714285714284,2608.5714285714284]
[null,null,165,1767,1944,1346.2857142857142,1481.1428571428571,2524.2857142857142,2692.8571428571427]
[null,null,170,1821,2003,1387.4285714285713,1526.0952380952381,2601.4285714285711,2777.1428571428569]
[null,null,175,1874,2062,1427.8095238095239,1571.047619047619,2677.1428571428573,2861.4285714285716]
[null,null,180,1928,2121,1468.952380952381,1616,2754.2857142857142,2945.7142857142858]
[null,null,185,1981,2179,1509.3333333333333,1660.1904761904761,2830,3030]
[null,null,190,2035,2238,1550.4761904761904,1705.1428571428571,2907.1428571428569,3112.8571428571427]
[null,null,195,2088,2297,1590.8571428571429,1750.0952380952381,2982.8571428571431,3197.1428571428569]
[null,null,200,2142,2356,1632,1795.047619047619,3060,3281.4285714285716]
[null,null,null,null,null,null,null,null,3365.7142857142858]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DROP DOWN OPTIONS"]
[null,null,"SMALL"]
[null,null,"LARGE"]
[]
[null,null,"5day"]
[null,null,"4day"]
[null,null,"7day"]

{"sheet":"ExampleVehicleStatus","index":7,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,8],[5,0,5,1],[5,2,5,4],[31,1,41,7]]}
["Please call Kitsap Transit's Maintenance Department at 360-478-6221 with any immediate concerns."]
["KITSAP TRANSIT VEHICLE INSPECTION REPORT"]
[]
["Van #:",123,null,"Date:","2012-03-29"]
[]
["Prepared by:",null,"Mickey Mouse",null,null,null,null,"CK222"]
[]
[]
[]
[null,null,"Parking brake holds on incline"]
[null,null,"Headlights operate and are aimed properly"]
[null,null,"Stop, tail and signal lights are operational"]
[null,null,"Windshield/windows free of chips & cracks"]
[null,null,"Windshield wipers/washers are in good condition"]
[null,null,"Tires properly inflated, tread depth over 1/16\""]
[null,null,"Tires with no breaks, cuts or bulges/wearing evenly"]
[null,null,"Heater, defroster and air conditioner OK"]
[null,null,"All safety belts operation/in good condition"]
[null,null,"All belts and hoses free of cracks/bulges"]
[null,null,"Horn operational"]
[null,null,"Exhaust system & muffler OK"]
[null,null,"No vibration when steering"]
[null,null,"Gauges registering properly"]
[null,null,"Proper coolant/antifreeze level"]
[null,null,"Proper engine oil level"]
[null,null,"Free of unusual noises"]
[null,null,"All emergency equipment in van "]
[null,null,"Free of exterior body damage"]
[null,null,"Free of fluid leaks under van"]
[null,null,"Upon braking, van stops in straight line"]
[null,null,"Explain each \"No\" response:"]
[null,"Slight dent on right-side, rear panel. Reported to Tommy on January 2012."]

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