{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Template","June"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":37,"n_cols":57,"rows_kept":37,"merged":[[0,2,0,27],[0,28,0,56]]}
[null,null,"FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES",{"$nulls":25},"PARATRANSIT ROUTE(S)                                              PARATRANSIT ROUTE(S)                                              PARATRANSIT ROUTE(S)                                              PARATRANSIT ROUTE(S)"]
["Date","Day","Conroe Connection Tickets","Senior Ride Tickets","$1.00 Adults","$.50 Riders","$.50 ADA Riders","Children Under 6","Transfer Slips","Employee/City Badge/EMS","Service Animals","Ramp Used","Total FR Riders","Expected Monies FR","1473 Amt.","1474 Amt. ","1475 Amt. ","1476 Amt. ","1603 Amt. ","1604 Amt. ","Spare Amt. ","Total Collected FR","Difference","Overage / Shortage","Justification","Total FR Trips","Late FR Trips","OTP","Date","Day","$2.00 Paratransit Clients","$2.00 Companions","Personal Care Attendants","Service Animals","Total Para Riders","Expected Monies Para","1473 Amt.","1474 Amt. ","1475 Amt. ","1476 Amt. ","1603 Amt.","1604 Amt.","Spare Amt. ","Currency Collected","ADA Green Tickets","ADA White Tickets","Senior Rides Tickets","Conroe Connection Ticket \"Fare\"","Senior Rides Ticket \"Fare\"","Total Fare Collected","Difference","Overage / Shortage","Justification","Total Para Trips","Late Para Trips","OTP","Total Weekly Riders"]
["2017-03-01","Wednesday",9,null,{"$f":"22+29","v":51},18,4,4,22,null,null,2,{"$f":"C3+D3+E3+F3+G3+H3+I3+J3","v":108},{"$f":"E3*1+F3*0.5+G3*0.5","v":{"v":62,"d":"$62.00"}},{"v":33.6,"d":"$33.60"},null,null,{"v":28.4,"d":"$28.40"},{"$nulls":3},{"$f":"SUM(O3:U3)","v":{"v":62,"d":"$62.00"}},{"$f":"V3-N3","v":{"v":0,"d":"$0.00"}},{"$f":"IF(W3>0, \"Overage\", IF(W3<0, \"Shortage\", \"\"))","v":""},null,{"$f":"2*12*5","v":120},0,{"$f":"IF(Z3=0, 1, (Z3-AA3)/Z3)","v":{"v":1,"d":"100.00%"}},{"$f":"A3","v":"2017-03-01"},{"$f":"B3","v":"Wednesday"},17,{"$nulls":3},{"$f":"AE3+AF3+AG3","v":17},{"$f":"AE3*2+AF3*2","v":{"v":34,"d":"$34.00"}},{"$nulls":5},{"v":22,"d":"$22.00"},null,{"$f":"SUM(AK3:AQ3)","v":{"v":22,"d":"$22.00"}},5,1,null,{"$f":"(AS3+AT3)*2","v":{"v":12,"d":"$12.00"}},{"$f":"AU3*2","v":{"v":0,"d":"$0.00"}},{"$f":"AR3+AV3","v":{"v":34,"d":"$34.00"}},{"$f":"AX3-AJ3","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AY3>0, \"Overage\", IF(AY3<0, \"Shortage\", \"\"))","v":""},null,{"$f":"AE3","v":17},0,{"$f":"IF(BB3=0, 1, (BB3-BC3)/BB3)","v":{"v":1,"d":"100.00%"}},{"$f":"M3+AI3","v":125}]
["2017-03-02","Thursday",7,null,65,14,2,4,30,null,null,14,122,{"v":73,"d":"$73.00"},{"v":23.39,"d":"$23.39"},null,null,{"v":50.6,"d":"$50.60"},{"$nulls":3},{"v":73.99000000000001,"d":"$73.99"},{"$f":"V4-N4","v":{"v":0.9900000000000091,"d":"$0.99"}},{"$f":"IF(W4>0, \"Overage\", IF(W4<0, \"Shortage\", \"\"))","v":"Overage"},null,{"$f":"2*12*5","v":120},0,{"v":1,"d":"100.00%"},{"$f":"A4","v":"2017-03-02"},{"$f":"B4","v":"Thursday"},11,{"$nulls":3},11,{"v":22,"d":"$22.00"},{"$nulls":5},{"v":18,"d":"$18.00"},null,{"v":18,"d":"$18.00"},null,2,null,{"$f":"(AS4+AT4)*2","v":{"v":4,"d":"$4.00"}},{"$f":"AU4*2","v":{"v":0,"d":"$0.00"}},{"$f":"AR4+AV4+AW4","v":{"v":22,"d":"$22.00"}},{"v":0,"d":"$0.00"},{"$f":"IF(AY4>0, \"Overage\", IF(AY4<0, \"Shortage\", \"\"))","v":""},null,11,0,{"v":1,"d":"100.00%"},{"$f":"BE3+M4+AI4","v":258}]
["2017-03-03","Friday",5,null,54,17,5,5,30,null,null,15,116,{"v":65,"d":"$65.00"},{"v":44.07,"d":"$44.07"},null,null,{"v":22,"d":"$22.00"},{"$nulls":3},{"v":66.07,"d":"$66.07"},{"$f":"V5-N5","v":{"v":1.0699999999999932,"d":"$1.07"}},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-03","Friday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE4+M5+AI5","v":374}]
["2017-03-04","Saturday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,120,0,{"v":1,"d":"100.00%"},"2017-03-04","Saturday",{"$nulls":4},{"$f":"AE6+AF6+AG6","v":0},{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},374]
["2017-03-05","Sunday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,120,0,{"v":1,"d":"100.00%"},"2017-03-05","Sunday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},374]
["2017-03-06","Monday",2,null,66,14,5,7,22,null,null,10,116,{"v":75.5,"d":"$75.50"},{"v":43.45,"d":"$43.45"},null,null,{"v":32,"d":"$32.00"},{"$nulls":3},{"v":75.45,"d":"$75.45"},{"v":-0.04999999999999716,"d":"($0.05)"},{"$f":"IF(W8>0, \"Overage\", IF(W8<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-06","Monday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY8>0, \"Overage\", IF(AY8<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},{"$f":"M8+AI8","v":116}]
["2017-03-07","Tuesday",null,null,62,12,5,6,30,null,null,4,115,{"v":70.5,"d":"$70.50"},{"v":26.4,"d":"$26.40"},null,null,{"v":44.27,"d":"$44.27"},{"$nulls":3},{"v":70.67,"d":"$70.67"},{"v":0.1700000000000017,"d":"$0.17"},{"$f":"IF(W9>0, \"Overage\", IF(W9<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-07","Tuesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY9>0, \"Overage\", IF(AY9<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},231]
["2017-03-08","Wednesday",3,null,41,9,4,3,18,null,null,18,{"$f":"C10+D10+E10+F10+G10+H10+I10+J10","v":78},{"$f":"E10*1+F10*0.5+G10*0.5","v":{"v":47.5,"d":"$47.50"}},{"v":23.25,"d":"$23.25"},{"v":24.41,"d":"$24.41"},{"$nulls":5},{"$f":"SUM(O10:U10)","v":{"v":47.66,"d":"$47.66"}},{"$f":"V10-N10","v":{"v":0.1599999999999966,"d":"$0.16"}},{"$f":"IF(W10>0, \"Overage\", IF(W10<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,null,"2017-03-08","Wednesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,null,0,0,{"v":1,"d":"100.00%"},309]
["2017-03-09","Thursday",7,null,48,16,8,null,15,null,null,8,94,{"v":60,"d":"$60.00"},{"v":22.45,"d":"$22.45"},{"v":38.49,"d":"$38.49"},{"$nulls":5},{"v":60.94,"d":"$60.94"},{"v":0.9399999999999977,"d":"$0.94"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-09","Thursday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},403]
["2017-03-10","Friday",3,null,46,9,1,5,12,null,null,4,76,{"v":51,"d":"$51.00"},{"v":15.95,"d":"$15.95"},{"v":36.5,"d":"$36.50"},{"$nulls":5},{"v":52.45,"d":"$52.45"},{"v":1.4500000000000028,"d":"$1.45"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-10","Friday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE11+M12+AI12","v":479}]
["2017-03-11","Saturday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,120,0,{"v":1,"d":"100.00%"},"2017-03-11","Saturday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE12+M13+AI13","v":479}]
["2017-03-12","Sunday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(W14>0, \"Overage\", IF(W14<0, \"Shortage\", \"\"))","v":""},null,120,0,{"v":1,"d":"100.00%"},"2017-03-12","Sunday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"$f":"SUM(AK14:AQ14)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY14>0, \"Overage\", IF(AY14<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE13+M14+AI14","v":479}]
["2017-03-13","Monday",6,null,51,20,6,8,30,2,null,12,{"$f":"C15+D15+E15+F15+G15+H15+I15+J15","v":123},{"v":64,"d":"$64.00"},{"v":26.8,"d":"$26.80"},{"v":43,"d":"$43.00"},{"$nulls":5},{"$f":"SUM(O15:U15)","v":{"v":69.8,"d":"$69.80"}},{"v":5.799999999999997,"d":"$5.80"},{"$f":"IF(W15>0, \"Overage\", IF(W15<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-13","Monday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY15>0, \"Overage\", IF(AY15<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},{"$f":"M15+AI15","v":123}]
["2017-03-14","Tuesday",1,null,42,26,7,11,13,null,null,16,100,{"v":58.5,"d":"$58.50"},{"v":27,"d":"$27.00"},{"v":36,"d":"$36.00"},{"$nulls":5},{"v":63,"d":"$63.00"},{"v":4.5,"d":"$4.50"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-14","Tuesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE15+M16+AI16","v":223}]
["2017-03-15","Wednesday",2,null,57,25,1,14,19,null,null,10,118,{"v":70,"d":"$70.00"},null,{"v":22.18,"d":"$22.18"},null,{"v":51.49,"d":"$51.49"},{"$nulls":3},{"v":73.67,"d":"$73.67"},{"v":3.6700000000000017,"d":"$3.67"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-15","Wednesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE16+M17+AI17","v":341}]
["2017-03-16","Thursday",15,null,50,7,2,6,9,null,null,4,89,{"v":54.5,"d":"$54.50"},{"v":21,"d":"$21.00"},null,null,{"v":33,"d":"$33.00"},{"$nulls":3},{"v":54,"d":"$54.00"},{"v":-0.5,"d":"($0.50)"},"Shortage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-16","Thursday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE17+M18+AI18","v":430}]
["2017-03-17","Friday",3,null,48,15,4,7,37,null,null,16,114,{"v":57.5,"d":"$57.50"},{"v":16.5,"d":"$16.50"},null,null,{"v":40.5,"d":"$40.50"},{"$nulls":3},{"v":57,"d":"$57.00"},{"v":-0.5,"d":"($0.50)"},{"$f":"IF(W19>0, \"Overage\", IF(W19<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-17","Friday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY19>0, \"Overage\", IF(AY19<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE18+M19+AI19","v":544}]
["2017-03-18","Saturday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(W20>0, \"Overage\", IF(W20<0, \"Shortage\", \"\"))","v":""},null,120,0,{"v":1,"d":"100.00%"},"2017-03-18","Saturday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY20>0, \"Overage\", IF(AY20<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE19+M20+AI20","v":544}]
["2017-03-19","Sunday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,120,0,{"v":1,"d":"100.00%"},"2017-03-19","Sunday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"M21+AI21","v":0}]
["2017-03-20","Monday",2,null,57,20,2,5,21,null,null,24,107,{"v":68,"d":"$68.00"},{"v":35,"d":"$35.00"},null,null,{"v":34.88,"d":"$34.88"},{"$nulls":3},{"v":69.88,"d":"$69.88"},{"v":1.8799999999999955,"d":"$1.88"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-20","Monday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE21+M22+AI22","v":107}]
["2017-03-21","Tuesday",5,null,57,22,1,5,29,3,null,24,122,{"v":68.5,"d":"$68.50"},null,{"v":40.81,"d":"$40.81"},null,{"v":30.25,"d":"$30.25"},{"$nulls":3},{"v":71.06,"d":"$71.06"},{"v":2.5600000000000023,"d":"$2.56"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-21","Tuesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},229]
["2017-03-22","Wednesday",9,null,34,19,3,5,14,5,null,13,89,{"v":45,"d":"$45.00"},null,{"v":13.76,"d":"$13.76"},null,{"v":31.5,"d":"$31.50"},{"$nulls":3},{"v":45.26,"d":"$45.26"},{"v":0.259999999999998,"d":"$0.26"},{"$f":"IF(W24>0, \"Overage\", IF(W24<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-22","Wednesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY24>0, \"Overage\", IF(AY24<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},318]
["2017-03-23","Thursday",8,null,29,6,3,null,9,null,null,8,55,{"v":33.5,"d":"$33.50"},null,{"v":10,"d":"$10.00"},null,{"v":23.6,"d":"$23.60"},{"$nulls":3},{"v":33.6,"d":"$33.60"},{"v":0.10000000000000142,"d":"$0.10"},{"$f":"IF(W25>0, \"Overage\", IF(W25<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-23","Thursday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY25>0, \"Overage\", IF(AY25<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},373]
["2017-03-24","Friday",3,null,42,19,3,4,14,null,null,6,85,{"v":53,"d":"$53.00"},null,{"v":21,"d":"$21.00"},null,{"v":32.54,"d":"$32.54"},{"$nulls":3},{"v":53.54,"d":"$53.54"},{"v":0.5399999999999991,"d":"$0.54"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-24","Friday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},458]
["2017-03-25","Saturday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,120,0,{"v":1,"d":"100.00%"},"2017-03-25","Saturday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},458]
["2017-03-26","Sunday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,120,0,{"v":1,"d":"100.00%"},"2017-03-26","Sunday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"}]
["2017-03-27","Monday",7,null,63,20,5,7,30,null,null,26,132,{"v":75.5,"d":"$75.50"},null,{"v":38.5,"d":"$38.50"},null,{"v":37.74,"d":"$37.74"},{"$nulls":3},{"v":76.24000000000001,"d":"$76.24"},{"v":0.7400000000000091,"d":"$0.74"},{"$f":"IF(W29>0, \"Overage\", IF(W29<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-27","Monday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY29>0, \"Overage\", IF(AY29<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},{"$f":"M29+AI29","v":132}]
["2017-03-28","Tuesday",2,null,55,14,10,7,29,null,null,31,117,{"v":67,"d":"$67.00"},null,{"v":28.4,"d":"$28.40"},null,{"v":41.25,"d":"$41.25"},{"$nulls":3},{"v":69.65,"d":"$69.65"},{"v":2.6500000000000057,"d":"$2.65"},{"$f":"IF(W30>0, \"Overage\", IF(W30<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-03-28","Tuesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY30>0, \"Overage\", IF(AY30<0, \"Shortage\", \"\"))","v":""},null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE29+M30+AI30","v":249}]
["2017-03-29","Wednesday",4,null,35,15,1,2,15,null,null,5,72,{"v":43,"d":"$43.00"},null,{"v":22.25,"d":"$22.25"},null,{"v":19.51,"d":"$19.51"},{"$nulls":3},{"v":41.760000000000005,"d":"$41.76"},{"v":-1.2399999999999949,"d":"($1.24)"},"Shortage",null,120,0,{"v":1,"d":"100.00%"},{"$f":"A31","v":"2017-03-29"},"Wednesday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"}]
["2017-03-30","Thursday",2,null,47,13,2,null,23,null,null,8,87,{"v":54.5,"d":"$54.50"},null,{"v":20.55,"d":"$20.55"},null,{"v":35.55,"d":"$35.55"},{"$nulls":3},{"v":56.099999999999994,"d":"$56.10"},{"v":1.5999999999999943,"d":"$1.60"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-30","Thursday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"}]
["2017-03-31","Friday",7,null,39,23,2,3,21,null,null,14,95,{"v":51.5,"d":"$51.50"},null,{"v":12.75,"d":"$12.75"},null,{"v":38,"d":"$38.00"},{"$nulls":3},{"v":50.75,"d":"$50.75"},{"v":-0.75,"d":"($0.75)"},"Shortage",null,120,0,{"v":1,"d":"100.00%"},"2017-03-31","Friday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"}]
[null,"EOM Totals:",{"$f":"SUM(C3:C33)","v":112},{"$f":"SUM(D3:D33)","v":0},1139,373,86,118,492,10,0,292,2330,{"v":1368.5,"d":"$1,368.50"},{"$nulls":7},{"$f":"SUM(V3:V33)","v":{"v":1394.5399999999997,"d":"$1,394.54"}},{"$f":"V34-N34","v":{"v":26.039999999999736,"d":"$26.04"}},"Overage",null,{"$f":"SUM(Z6:Z28)","v":2760},{"$f":"SUM(AA3:AA33)","v":0},{"v":1,"d":"100.00%"},null,"EOM Totals:",{"$f":"SUM(AE3:AE33)","v":28},0,0,0,28,{"v":56,"d":"$56.00"},{"$nulls":7},{"$f":"SUM(AR3:AR33)","v":{"v":40,"d":"$40.00"}},5,3,0,{"$f":"SUM(AV3:AV33)","v":{"v":16,"d":"$16.00"}},{"v":0,"d":"$0.00"},{"v":56,"d":"$56.00"},{"v":0,"d":"$0.00"},"",null,{"$f":"SUM(BB3:BB33)","v":28},{"$f":"SUM(BC3:BC33)","v":0},{"v":1,"d":"100.00%"},{"$f":"BE5+BE12+BE19+BE26+BE30","v":2104}]
["Manager Signature: ",{"$nulls":21},{"$f":"SUM(W3:W33)","v":{"v":26.040000000000013,"d":"$26.04"}},"Overage",{"$nulls":26},{"$f":"SUM(AY3:AY33)","v":{"v":0,"d":"$0.00"}},""]
["Date: ",null,"2016-02-16"]
[{"$nulls":39},11232]

{"sheet":"June","index":1,"n_rows":31,"n_cols":57,"rows_kept":31,"merged":[[0,2,0,27],[0,28,0,56]]}
[null,null,"FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES                          FIXED ROUTES",{"$nulls":25},"PARATRANSIT ROUTE(S)                                              PARATRANSIT ROUTE(S)                                              PARATRANSIT ROUTE(S)                                              PARATRANSIT ROUTE(S)"]
["Date","Day","Conroe Connection Tickets","Senior Ride Tickets","$1.00 Adults","$.50 Riders","$.50 ADA Riders","Children Under 6","Transfer Slips","Employee/City Badge/EMS","Service Animals","Ramp Used","Total FR Riders","Expected Monies FR","1473 Amt.","1474 Amt. ","1475 Amt. ","1476 Amt. ","1603 Amt. ","1604 Amt. ","Spare Amt. ","Total Collected FR","Difference","Overage / Shortage","Justification","Total FR Trips","Late FR Trips","OTP","Date","Day","$2.00 Paratransit Clients","$2.00 Companions","Personal Care Attendants","Service Animals","Total Para Riders","Expected Monies Para","1473 Amt.","1474 Amt. ","1475 Amt. ","1476 Amt. ","1603 Amt.","1604 Amt.","Spare Amt. ","Currency Collected","ADA Green Tickets","ADA White Tickets","Senior Rides Tickets","Conroe Connection Ticket \"Fare\"","Senior Rides Ticket \"Fare\"","Total Fare Collected","Difference","Overage / Shortage","Justification","Total Para Trips","Late Para Trips","OTP","Total Weekly Riders"]
["2017-06-01","Thursday",11,null,50,16,1,2,11,null,null,8,{"$f":"C3+D3+E3+F3+G3+H3+I3+J3","v":91},{"$f":"E3*1+F3*0.5+G3*0.5","v":{"v":58.5,"d":"$58.50"}},null,{"v":40,"d":"$40.00"},{"v":21.11,"d":"$21.11"},{"$nulls":4},{"$f":"SUM(O3:U3)","v":{"v":61.11,"d":"$61.11"}},{"$f":"V3-N3","v":{"v":2.6099999999999994,"d":"$2.61"}},{"$f":"IF(W3>0, \"Overage\", IF(W3<0, \"Shortage\", \"\"))","v":"Overage"},null,{"$f":"2*12*5","v":120},0,{"$f":"IF(Z3=0, 1, (Z3-AA3)/Z3)","v":{"v":1,"d":"100.00%"}},"2017-06-01",{"$f":"B3","v":"Thursday"},16,{"$nulls":3},{"$f":"AE3+AF3+AG3","v":16},{"$f":"AE3*2+AF3*2","v":{"v":32,"d":"$32.00"}},{"$nulls":5},{"v":26,"d":"$26.00"},null,{"$f":"SUM(AK3:AQ3)","v":{"v":26,"d":"$26.00"}},null,3,null,{"$f":"(AS3+AT3)*2","v":{"v":6,"d":"$6.00"}},{"$f":"AU3*2","v":{"v":0,"d":"$0.00"}},{"$f":"AR3+AV3+AW3","v":{"v":32,"d":"$32.00"}},{"$f":"AX3-AJ3","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AY3>0, \"Overage\", IF(AY3<0, \"Shortage\", \"\"))","v":""},null,{"$f":"AE3","v":16},0,{"$f":"IF(BB3=0, 1, (BB3-BC3)/BB3)","v":{"v":1,"d":"100.00%"}},107]
["2017-06-02","Friday",10,null,46,33,2,6,31,null,null,20,{"$f":"C4+D4+E4+F4+G4+H4+I4+J4","v":128},{"$f":"E4*1+F4*0.5+G4*0.5","v":{"v":63.5,"d":"$63.50"}},null,{"v":21.5,"d":"$21.50"},{"v":42.42,"d":"$42.42"},{"$nulls":4},{"$f":"SUM(O4:U4)","v":{"v":63.92,"d":"$63.92"}},{"$f":"V4-N4","v":{"v":0.4200000000000017,"d":"$0.42"}},{"$f":"IF(W4>0, \"Overage\", IF(W4<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-02","Friday",16,{"$nulls":3},{"$f":"AE4+AF4+AG4","v":16},{"$f":"AE4*2+AF4*2","v":{"v":32,"d":"$32.00"}},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":26,"d":"$26.00"},null,{"$f":"SUM(AK4:AQ4)","v":{"v":28,"d":"$28.00"}},null,2,null,{"$f":"(AS4+AT4)*2","v":{"v":4,"d":"$4.00"}},null,{"$f":"AR4+AV4+AW4","v":{"v":32,"d":"$32.00"}},{"v":0,"d":"$0.00"},"",null,16,0,{"v":1,"d":"100.00%"},{"$f":"BE3+M4+AI4","v":251}]
["2017-06-05","Monday",12,null,62,14,3,3,12,null,null,4,{"$f":"C5+D5+E5+F5+G5+H5+I5+J5","v":106},{"$f":"E5*1+F5*0.5+G5*0.5","v":{"v":70.5,"d":"$70.50"}},null,{"v":50.45,"d":"$50.45"},{"v":20.5,"d":"$20.50"},{"$nulls":4},{"$f":"SUM(O5:U5)","v":{"v":70.95,"d":"$70.95"}},{"$f":"V5-N5","v":{"v":0.45000000000000284,"d":"$0.45"}},"Overage",null,120,0,{"$f":"IF(Z5=0, 1, (Z5-AA5)/Z5)","v":{"v":1,"d":"100.00%"}},"2017-06-05","Monday",18,{"$nulls":3},{"$f":"AE5+AF5+AG5","v":18},{"$f":"AE5*2+AF5*2","v":{"v":36,"d":"$36.00"}},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":12,"d":"$12.00"},null,{"$f":"SUM(AK5:AQ5)","v":{"v":18,"d":"$18.00"}},5,4,null,{"$f":"(AS5+AT5)*2","v":{"v":18,"d":"$18.00"}},null,{"$f":"AR5+AV5+AW5","v":{"v":36,"d":"$36.00"}},{"v":0,"d":"$0.00"},"",null,18,0,{"$f":"IF(BB5=0, 1, (BB5-BC5)/BB5)","v":{"v":1,"d":"100.00%"}},{"$f":"M5+AI5","v":124}]
["2017-06-06","Tuesday",3,null,52,27,5,2,26,null,null,14,115,{"v":68,"d":"$68.00"},null,{"v":34.5,"d":"$34.50"},{"v":33.7,"d":"$33.70"},{"$nulls":4},{"$f":"SUM(O6:U6)","v":{"v":68.2,"d":"$68.20"}},{"v":0.20000000000000284,"d":"$0.20"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-06",{"$f":"B6","v":"Tuesday"},14,{"$nulls":3},14,{"v":28,"d":"$28.00"},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":16,"d":"$16.00"},null,{"$f":"SUM(AK6:AQ6)","v":{"v":18,"d":"$18.00"}},1,4,null,{"v":10,"d":"$10.00"},{"$f":"AU6*2","v":{"v":0,"d":"$0.00"}},{"v":28,"d":"$28.00"},{"$f":"AX6-AJ6","v":{"v":0,"d":"$0.00"}},"",null,{"$f":"AE6","v":14},0,{"v":1,"d":"100.00%"},{"$f":"BE5+M6+AI6","v":253}]
["2017-06-07","Wednesday",15,null,51,20,3,2,29,null,1,8,120,{"v":62.5,"d":"$62.50"},null,{"v":46.52,"d":"$46.52"},{"v":18.5,"d":"$18.50"},{"$nulls":4},{"v":65.02000000000001,"d":"$65.02"},{"v":2.5200000000000102,"d":"$2.52"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-07","Wednesday",18,{"$nulls":3},18,{"v":36,"d":"$36.00"},{"$nulls":4},{"v":12,"d":"$12.00"},{"v":16,"d":"$16.00"},null,{"v":28,"d":"$28.00"},2,2,null,{"v":8,"d":"$8.00"},{"v":0,"d":"$0.00"},{"v":36,"d":"$36.00"},{"v":0,"d":"$0.00"},"",null,18,0,{"v":1,"d":"100.00%"},391]
["2017-06-08","Thursday",6,null,26,9,2,null,8,null,null,4,51,{"v":31.5,"d":"$31.50"},null,{"v":9.5,"d":"$9.50"},{"v":23.5,"d":"$23.50"},{"$nulls":4},{"v":33,"d":"$33.00"},{"v":1.5,"d":"$1.50"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-08","Thursday",10,{"$nulls":3},10,{"v":20,"d":"$20.00"},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":10,"d":"$10.00"},null,{"v":16,"d":"$16.00"},2,null,null,{"v":4,"d":"$4.00"},{"v":0,"d":"$0.00"},{"v":20,"d":"$20.00"},{"v":0,"d":"$0.00"},"",null,10,0,{"v":1,"d":"100.00%"},{"$f":"BE7+M8+AI8","v":452}]
["2017-06-09","Friday",9,null,33,19,1,4,21,null,null,13,87,{"v":43,"d":"$43.00"},null,{"v":22.2,"d":"$22.20"},{"v":18.8,"d":"$18.80"},{"$nulls":4},{"v":41,"d":"$41.00"},{"v":-2,"d":"($2.00)"},"Shortage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-09","Friday",18,{"$nulls":3},18,{"v":36,"d":"$36.00"},{"$nulls":4},{"v":10,"d":"$10.00"},{"v":12,"d":"$12.00"},null,{"v":22,"d":"$22.00"},2,5,null,{"v":14,"d":"$14.00"},{"v":0,"d":"$0.00"},{"v":36,"d":"$36.00"},{"v":0,"d":"$0.00"},"",null,18,0,{"v":1,"d":"100.00%"},{"$f":"BE8+M9+AI9","v":557}]
["2017-06-12","Monday",6,null,49,12,2,7,21,null,null,14,97,{"v":56,"d":"$56.00"},null,{"v":15.43,"d":"$15.43"},{"v":20.75,"d":"$20.75"},{"v":22.05,"d":"$22.05"},{"$nulls":3},{"v":58.230000000000004,"d":"$58.23"},{"v":2.230000000000004,"d":"$2.23"},{"$f":"IF(W10>0, \"Overage\", IF(W10<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-12","Monday",9,{"$nulls":3},9,{"v":18,"d":"$18.00"},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":4,"d":"$4.00"},null,{"v":10,"d":"$10.00"},2,2,null,{"v":8,"d":"$8.00"},{"v":0,"d":"$0.00"},{"v":18,"d":"$18.00"},{"v":0,"d":"$0.00"},"",null,9,0,{"v":1,"d":"100.00%"},{"$f":"M10+AI10","v":106}]
["2017-06-13","Tuesday",14,null,37,11,2,2,21,null,null,8,87,{"v":43.5,"d":"$43.50"},null,{"v":29.06,"d":"$29.06"},null,{"v":16.6,"d":"$16.60"},{"$nulls":3},{"v":45.66,"d":"$45.66"},{"v":2.1599999999999966,"d":"$2.16"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-13","Tuesday",8,{"$nulls":3},8,{"v":16,"d":"$16.00"},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":10,"d":"$10.00"},null,{"v":12,"d":"$12.00"},null,2,null,{"v":4,"d":"$4.00"},null,{"v":16,"d":"$16.00"},{"v":0,"d":"$0.00"},"",null,8,0,{"v":1,"d":"100.00%"},{"$f":"BE10+M11+AI11","v":201}]
["2017-06-14","Wednesday",8,null,42,12,1,12,15,null,null,9,90,{"v":48.5,"d":"$48.50"},null,{"v":31,"d":"$31.00"},{"v":18.25,"d":"$18.25"},{"$nulls":4},{"v":49.25,"d":"$49.25"},{"v":0.75,"d":"$0.75"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-14","Wednesday",9,{"$nulls":3},9,{"v":18,"d":"$18.00"},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":8,"d":"$8.00"},null,{"v":14,"d":"$14.00"},null,2,null,{"v":4,"d":"$4.00"},null,{"v":18,"d":"$18.00"},{"v":0,"d":"$0.00"},"",null,9,0,{"v":1,"d":"100.00%"},300]
["2017-05-18","Thursday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"$f":"SUM(O13:U13)","v":{"v":0,"d":"$0.00"}},{"$f":"V13-N13","v":{"v":0,"d":"$0.00"}},{"$f":"IF(W13>0, \"Overage\", IF(W13<0, \"Shortage\", \"\"))","v":""},null,120,0,{"$f":"IF(Z13=0, 1, (Z13-AA13)/Z13)","v":{"v":1,"d":"100.00%"}},"2017-05-18","Thursday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$f":"AU13*2","v":{"v":0,"d":"$0.00"}},{"$f":"AR13+AV13+AW13","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"",null,{"$f":"AE13","v":0},0,{"$f":"IF(BB13=0, 1, (BB13-BC13)/BB13)","v":{"v":1,"d":"100.00%"}},{"$f":"BE12+M13+AI13","v":300}]
["2017-05-19","Friday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,120,0,{"v":1,"d":"100.00%"},"2017-05-19","Friday",{"$nulls":4},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"",null,0,0,{"v":1,"d":"100.00%"},{"$f":"BE13+M14+AI14","v":300}]
["2017-06-15","Thursday",6,null,54,12,2,5,22,null,null,4,101,{"v":61,"d":"$61.00"},{"v":3,"d":"$3.00"},{"v":40.5,"d":"$40.50"},null,{"v":19.01,"d":"$19.01"},{"$nulls":3},{"v":62.510000000000005,"d":"$62.51"},{"v":1.5100000000000051,"d":"$1.51"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-15",{"$f":"B15","v":"Thursday"},18,{"$nulls":3},18,{"v":36,"d":"$36.00"},{"$nulls":4},{"v":8,"d":"$8.00"},{"v":14,"d":"$14.00"},null,{"v":22,"d":"$22.00"},2,5,null,{"v":14,"d":"$14.00"},{"v":0,"d":"$0.00"},{"v":36,"d":"$36.00"},{"v":0,"d":"$0.00"},"",null,18,0,{"v":1,"d":"100.00%"},{"$f":"BE14+M15+AI15","v":419}]
["2017-06-16","Friday",4,null,48,18,3,17,29,null,null,14,119,{"v":58.5,"d":"$58.50"},null,{"v":24,"d":"$24.00"},null,{"v":36.51,"d":"$36.51"},{"$nulls":3},{"v":60.51,"d":"$60.51"},{"v":2.009999999999998,"d":"$2.01"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-16",{"$f":"B16","v":"Friday"},16,{"$nulls":3},16,{"v":32,"d":"$32.00"},{"$nulls":4},{"v":10,"d":"$10.00"},{"v":8,"d":"$8.00"},null,{"v":18,"d":"$18.00"},4,3,null,{"v":14,"d":"$14.00"},{"v":0,"d":"$0.00"},{"v":32,"d":"$32.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY16>0, \"Overage\", IF(AY16<0, \"Shortage\", \"\"))","v":""},null,16,0,{"v":1,"d":"100.00%"},554]
["2017-06-19","Monday",14,null,66,17,3,9,20,null,null,6,129,{"v":76,"d":"$76.00"},null,{"v":45.9,"d":"$45.90"},null,{"v":30.95,"d":"$30.95"},{"$nulls":3},{"v":76.85,"d":"$76.85"},{"v":0.8499999999999943,"d":"$0.85"},{"$f":"IF(W17>0, \"Overage\", IF(W17<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-19","Monday",13,{"$nulls":3},13,{"v":26,"d":"$26.00"},{"$nulls":4},{"v":8,"d":"$8.00"},{"v":10,"d":"$10.00"},null,{"v":18,"d":"$18.00"},2,2,null,{"v":8,"d":"$8.00"},{"v":0,"d":"$0.00"},{"v":26,"d":"$26.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY17>0, \"Overage\", IF(AY17<0, \"Shortage\", \"\"))","v":""},null,13,0,{"v":1,"d":"100.00%"},{"$f":"M17+AI17","v":142}]
["2017-06-20","Tuesday",5,null,40,6,6,null,11,null,null,2,68,{"v":46,"d":"$46.00"},{"v":10,"d":"$10.00"},{"v":22,"d":"$22.00"},null,{"v":15,"d":"$15.00"},{"$nulls":3},{"v":47,"d":"$47.00"},{"v":1,"d":"$1.00"},{"$f":"IF(W18>0, \"Overage\", IF(W18<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-20","Tuesday",18,{"$nulls":3},18,{"v":36,"d":"$36.00"},{"$nulls":4},{"v":22,"d":"$22.00"},null,null,{"v":22,"d":"$22.00"},4,3,null,{"v":14,"d":"$14.00"},{"$f":"AU18*2","v":{"v":0,"d":"$0.00"}},{"v":36,"d":"$36.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY18>0, \"Overage\", IF(AY18<0, \"Shortage\", \"\"))","v":""},null,18,0,{"v":1,"d":"100.00%"},{"$f":"BE17+M18+AI18","v":228}]
["2017-06-21","Wednesday",4,null,51,13,3,5,20,null,null,2,96,{"v":59,"d":"$59.00"},{"v":12.5,"d":"$12.50"},{"v":22.5,"d":"$22.50"},null,{"v":24.5,"d":"$24.50"},{"$nulls":3},{"v":59.5,"d":"$59.50"},{"v":0.5,"d":"$0.50"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-21","Wednesday",11,{"$nulls":3},11,{"v":22,"d":"$22.00"},{"$nulls":4},{"v":4,"d":"$4.00"},{"v":10,"d":"$10.00"},null,{"v":14,"d":"$14.00"},2,2,null,{"v":8,"d":"$8.00"},{"v":0,"d":"$0.00"},{"v":22,"d":"$22.00"},{"v":0,"d":"$0.00"},"",null,11,0,{"v":1,"d":"100.00%"},335]
["2017-05-25","Thursday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":14},"2017-05-25",{"$nulls":18},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"},{"$nulls":5},335]
["2017-05-26","Friday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":14},"2017-05-26",{"$nulls":18},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"},{"$nulls":5},335]
["2017-06-22","Thursday",9,null,28,9,2,5,14,null,null,3,67,{"v":33.5,"d":"$33.50"},{"v":7.12,"d":"$7.12"},{"v":4.85,"d":"$4.85"},null,{"v":19,"d":"$19.00"},{"$nulls":3},{"$f":"SUM(O22:U22)","v":{"v":30.97,"d":"$30.97"}},{"$f":"V22-N22","v":{"v":-2.530000000000001,"d":"($2.53)"}},{"$f":"IF(W22>0, \"Overage\", IF(W22<0, \"Shortage\", \"\"))","v":"Shortage"},null,{"$f":"2*12*5","v":120},0,{"$f":"IF(Z22=0, 1, (Z22-AA22)/Z22)","v":{"v":1,"d":"100.00%"}},"2017-06-22",{"$f":"B22","v":"Thursday"},9,{"$nulls":3},{"$f":"AE22+AF22+AG22","v":9},{"$f":"AE22*2+AF22*2","v":{"v":18,"d":"$18.00"}},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":10,"d":"$10.00"},null,{"$f":"SUM(AK22:AQ22)","v":{"v":12,"d":"$12.00"}},null,3,null,{"v":6,"d":"$6.00"},null,{"$f":"AR22+AV22+AW22","v":{"v":18,"d":"$18.00"}},{"v":0,"d":"$0.00"},{"$f":"IF(AY22>0, \"Overage\", IF(AY22<0, \"Shortage\", \"\"))","v":""},null,{"$f":"AE22","v":9},0,{"$f":"IF(BB22=0, 1, (BB22-BC22)/BB22)","v":{"v":1,"d":"100.00%"}},411]
["2017-06-23","Friday",4,null,44,12,2,5,13,null,null,10,80,{"v":51,"d":"$51.00"},{"v":33,"d":"$33.00"},{"v":2,"d":"$2.00"},null,{"v":15.05,"d":"$15.05"},{"$nulls":3},{"$f":"SUM(O23:U23)","v":{"v":50.05,"d":"$50.05"}},{"$f":"V23-N23","v":{"v":-0.9500000000000028,"d":"($0.95)"}},{"$f":"IF(W23>0, \"Overage\", IF(W23<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-23","Friday",14,{"$nulls":3},14,{"v":28,"d":"$28.00"},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":10,"d":"$10.00"},null,{"v":16,"d":"$16.00"},1,6,null,{"v":14,"d":"$14.00"},null,{"v":30,"d":"$30.00"},{"v":2,"d":"$2.00"},"Overage",null,14,0,{"v":1,"d":"100.00%"},505]
["2017-06-26","Monday",6,null,50,15,4,4,19,null,null,16,98,{"v":59.5,"d":"$59.50"},null,{"v":37.99,"d":"$37.99"},null,{"v":21.5,"d":"$21.50"},{"$nulls":3},{"$f":"SUM(O24:U24)","v":{"v":59.49,"d":"$59.49"}},{"$f":"V24-N24","v":{"v":-0.00999999999999801,"d":"($0.01)"}},{"$f":"IF(W24>0, \"Overage\", IF(W24<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-26","Monday",12,{"$nulls":3},{"$f":"AE24+AF24+AG24","v":12},{"$f":"AE24*2+AF24*2","v":{"v":24,"d":"$24.00"}},{"$nulls":4},{"v":12,"d":"$12.00"},{"v":4,"d":"$4.00"},null,{"v":16,"d":"$16.00"},2,2,null,{"v":8,"d":"$8.00"},null,{"v":24,"d":"$24.00"},{"v":0,"d":"$0.00"},"",null,12,null,{"v":1,"d":"100.00%"},{"$f":"M24+AI24","v":110}]
["2017-06-27","Tuesday",15,null,44,13,3,8,11,null,null,8,{"$f":"C25+D25+E25+F25+G25+H25+I25+J25","v":94},{"$f":"E25*1+F25*0.5+G25*0.5","v":{"v":52,"d":"$52.00"}},{"v":26.8,"d":"$26.80"},{"v":23.71,"d":"$23.71"},{"$nulls":5},{"$f":"SUM(O25:U25)","v":{"v":50.510000000000005,"d":"$50.51"}},{"v":-1.49,"d":"($1.49)"},{"$f":"IF(W25>0, \"Overage\", IF(W25<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-27","Tuesday",8,{"$nulls":3},8,{"v":16,"d":"$16.00"},{"$nulls":4},{"v":10,"d":"$10.00"},{"v":2,"d":"$2.00"},null,{"v":12,"d":"$12.00"},null,2,null,{"v":4,"d":"$4.00"},null,{"v":16,"d":"$16.00"},{"v":0,"d":"$0.00"},"",null,8,null,{"v":1,"d":"100.00%"},212]
["2017-06-28","Wednesday",20,null,51,18,null,null,12,null,null,4,101,{"v":60,"d":"$60.00"},{"v":38.5,"d":"$38.50"},null,null,{"v":21.56,"d":"$21.56"},{"$nulls":3},{"$f":"SUM(O26:U26)","v":{"v":60.06,"d":"$60.06"}},{"$f":"V26-N26","v":{"v":0.060000000000002274,"d":"$0.06"}},{"$f":"IF(W26>0, \"Overage\", IF(W26<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-06-28","Wednesday",13,{"$nulls":3},13,{"v":26,"d":"$26.00"},{"$nulls":4},{"v":12,"d":"$12.00"},{"v":2,"d":"$2.00"},null,{"v":14,"d":"$14.00"},null,6,null,{"v":12,"d":"$12.00"},null,{"v":26,"d":"$26.00"},{"v":0,"d":"$0.00"},"",null,13,null,{"v":1,"d":"100.00%"},326]
["2017-06-29","Thursday",17,null,50,13,3,null,2,null,null,2,85,{"v":58,"d":"$58.00"},{"v":11.5,"d":"$11.50"},{"v":46.77,"d":"$46.77"},{"$nulls":5},{"v":58.27,"d":"$58.27"},{"v":0.2700000000000031,"d":"$0.27"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-29","Thursday",15,{"$nulls":3},15,{"v":30,"d":"$30.00"},{"$nulls":4},{"v":18,"d":"$18.00"},{"v":2,"d":"$2.00"},null,{"v":20,"d":"$20.00"},2,3,null,{"v":10,"d":"$10.00"},null,{"v":30,"d":"$30.00"},{"v":0,"d":"$0.00"},"",null,15,null,{"v":1,"d":"100.00%"},426]
["2017-06-30","Friday",8,null,59,19,2,4,21,{"$nulls":3},113,{"v":69.5,"d":"$69.50"},{"v":47.28,"d":"$47.28"},{"v":21.5,"d":"$21.50"},{"$nulls":5},{"v":68.78,"d":"$68.78"},{"v":-0.7199999999999989,"d":"($0.72)"},"Shortage",null,120,0,{"v":1,"d":"100.00%"},"2017-06-30","Friday",27,{"$nulls":3},27,{"v":54,"d":"$54.00"},{"$nulls":4},{"v":22,"d":"$22.00"},{"v":18,"d":"$18.00"},null,{"v":40,"d":"$40.00"},2,5,null,{"v":14,"d":"$14.00"},null,{"v":54,"d":"$54.00"},{"v":0,"d":"$0.00"},"",null,27,null,{"v":1,"d":"100.00%"},566]
[null,null,{"$f":"SUM(C3:C28)","v":206},{"$f":"SUM(D3:D26)","v":0},{"$f":"SUM(E3:E28)","v":1033},{"$f":"SUM(F3:F28)","v":338},{"$f":"SUM(G3:G28)","v":55},{"$f":"SUM(H3:H28)","v":102},{"$f":"SUM(I3:I28)","v":389},{"$f":"SUM(J3:J26)","v":0},{"$f":"SUM(K3:K26)","v":1},{"$f":"SUM(L3:L27)","v":173},{"$f":"SUM(M3:M28)","v":2123},{"$f":"SUM(N3:N28)","v":{"v":1229.5,"d":"$1,229.50"}},{"$nulls":7},{"$f":"SUM(V3:V28)","v":{"v":1240.84,"d":"$1,240.84"}},{"$f":"V29-N29","v":{"v":11.339999999999918,"d":"$11.34"}},{"$f":"IF(W29>0, \"Overage\", IF(W29<0, \"Shortage\", \"\"))","v":"Overage"},null,2640,{"$f":"SUM(AA3:AA28)","v":0},{"$f":"IF(Z29=0, 1, (Z29-AA29)/Z29)","v":{"v":1,"d":"100.00%"}},null,{"$f":"B29","v":0},{"$f":"SUM(AE3:AE28)","v":310},{"$f":"SUM(AF3:AF26)","v":0},{"$f":"SUM(AG3:AG26)","v":0},{"$f":"SUM(AH3:AH26)","v":0},{"$f":"SUM(AI3:AI28)","v":310},{"$f":"SUM(AJ3:AJ28)","v":{"v":620,"d":"$620.00"}},{"$nulls":7},{"$f":"SUM(AR3:AR28)","v":{"v":416,"d":"$416.00"}},{"$f":"SUM(AS3:AS28)","v":35},{"$f":"SUM(AT3:AT28)","v":68},{"$f":"SUM(AU3:AU26)","v":0},{"$f":"SUM(AV3:AV28)","v":{"v":206,"d":"$206.00"}},{"$f":"SUM(AW3:AW26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(AX3:AX28)","v":{"v":622,"d":"$622.00"}},{"v":2,"d":"$2.00"},{"$f":"IF(AY29>0, \"Overage\", IF(AY29<0, \"Shortage\", \"\"))","v":"Overage"},null,{"$f":"SUM(BB3:BB28)","v":310},{"$f":"SUM(BC3:BC26)","v":0},{"$f":"IF(BB29=0, 1, (BB29-BC29)/BB29)","v":{"v":1,"d":"100.00%"}},{"$f":"SUM(BE4,BE9,BE16,BE23,BE28)","v":2433}]
["Manager Signature: ",{"$nulls":22},"",{"$nulls":26},{"$f":"SUM(AY3:AY26)","v":{"v":2,"d":"$2.00"}},"Overage"]
["Date: ",null,"2017-07-17"]