{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Template","May"],"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":"May","index":1,"n_rows":38,"n_cols":57,"rows_kept":38,"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-05-01","Monday",6,null,58,21,4,6,11,null,null,8,{"$f":"C3+D3+E3+F3+G3+H3+I3+J3","v":106},{"$f":"E3*1+F3*0.5+G3*0.5","v":{"v":70.5,"d":"$70.50"}},null,{"v":19.76,"d":"$19.76"},null,{"v":47.43,"d":"$47.43"},{"$nulls":3},{"$f":"SUM(O3:U3)","v":{"v":67.19,"d":"$67.19"}},{"$f":"V3-N3","v":{"v":-3.3100000000000023,"d":"($3.31)"}},{"$f":"IF(W3>0, \"Overage\", IF(W3<0, \"Shortage\", \"\"))","v":"Shortage"},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-05-01"},{"$f":"B3","v":"Monday"},19,{"$nulls":3},{"$f":"AE3+AF3+AG3","v":19},{"$f":"AE3*2+AF3*2","v":{"v":38,"d":"$38.00"}},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":20,"d":"$20.00"},null,{"$f":"SUM(AK3:AQ3)","v":{"v":26,"d":"$26.00"}},4,2,null,{"$f":"(AS3+AT3)*2","v":{"v":12,"d":"$12.00"}},{"$f":"AU3*2","v":{"v":0,"d":"$0.00"}},{"$f":"AR3+AV3+AW3","v":{"v":38,"d":"$38.00"}},{"$f":"AX3-AJ3","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AY3>0, \"Overage\", IF(AY3<0, \"Shortage\", \"\"))","v":""},null,{"$f":"AE3","v":19},0,{"$f":"IF(BB3=0, 1, (BB3-BC3)/BB3)","v":{"v":1,"d":"100.00%"}},{"$f":"M3+AI3","v":125}]
["2017-05-02","Tuesday",4,null,45,12,4,6,13,null,null,6,84,{"v":53,"d":"$53.00"},null,{"v":34.5,"d":"$34.50"},null,{"v":17.51,"d":"$17.51"},{"$nulls":3},{"v":52.010000000000005,"d":"$52.01"},{"v":-0.9899999999999949,"d":"($0.99)"},{"$f":"IF(W4>0, \"Overage\", IF(W4<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-05-02","Tuesday",16,{"$nulls":3},16,{"v":32,"d":"$32.00"},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":22,"d":"$22.00"},null,{"v":24,"d":"$24.00"},null,4,null,{"v":8,"d":"$8.00"},{"v":0,"d":"$0.00"},{"v":32,"d":"$32.00"},{"v":0,"d":"$0.00"},"",null,16,0,{"v":1,"d":"100.00%"},{"$f":"BE3+M4+AI4","v":225}]
["2017-05-03","Wednesday",6,null,38,4,2,7,8,null,null,7,65,{"v":41,"d":"$41.00"},null,{"v":18.85,"d":"$18.85"},null,{"v":28.25,"d":"$28.25"},{"$nulls":3},{"v":47.1,"d":"$47.10"},{"v":6.100000000000001,"d":"$6.10"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-03","Wednesday",18,{"$nulls":3},18,{"v":36,"d":"$36.00"},{"$nulls":4},{"v":4,"d":"$4.00"},{"v":20,"d":"$20.00"},null,{"v":24,"d":"$24.00"},2,4,null,{"v":12,"d":"$12.00"},null,{"v":36,"d":"$36.00"},{"v":0,"d":"$0.00"},"",null,18,0,{"v":1,"d":"100.00%"},308]
["2017-05-04","Thursday",2,null,60,21,4,8,21,null,null,8,116,{"v":72.5,"d":"$72.50"},null,{"v":55.55,"d":"$55.55"},null,{"v":17.5,"d":"$17.50"},{"$nulls":3},{"v":73.05,"d":"$73.05"},{"v":0.5499999999999972,"d":"$0.55"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-04","Thursday",12,{"$nulls":3},12,{"v":24,"d":"$24.00"},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":14,"d":"$14.00"},null,{"v":16,"d":"$16.00"},2,2,null,{"v":8,"d":"$8.00"},{"$f":"AU6*2","v":{"v":0,"d":"$0.00"}},{"v":24,"d":"$24.00"},{"v":0,"d":"$0.00"},"",null,12,0,{"v":1,"d":"100.00%"},{"$f":"BE5+M6+AI6","v":436}]
["2017-05-05","Friday",6,null,49,18,null,7,7,null,null,8,{"$f":"C7+D7+E7+F7+G7+H7+I7+J7","v":87},{"$f":"E7*1+F7*0.5+G7*0.5","v":{"v":58,"d":"$58.00"}},null,{"v":21.55,"d":"$21.55"},null,{"v":40,"d":"$40.00"},{"$nulls":3},{"$f":"SUM(O7:U7)","v":{"v":61.55,"d":"$61.55"}},{"$f":"V7-N7","v":{"v":3.549999999999997,"d":"$3.55"}},{"$f":"IF(W7>0, \"Overage\", IF(W7<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-05-05","Friday",14,{"$nulls":3},{"$f":"AE7+AF7+AG7","v":14},{"$f":"AE7*2+AF7*2","v":{"v":28,"d":"$28.00"}},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":12,"d":"$12.00"},null,{"$f":"SUM(AK7:AQ7)","v":{"v":14,"d":"$14.00"}},4,3,null,{"$f":"(AS7+AT7)*2","v":{"v":14,"d":"$14.00"}},null,{"$f":"AR7+AV7+AW7","v":{"v":28,"d":"$28.00"}},{"v":0,"d":"$0.00"},"",null,14,0,{"v":1,"d":"100.00%"},{"$f":"BE6+M7+AI7","v":537}]
["2017-05-08","Monday",6,null,55,12,2,1,40,{"$nulls":3},{"$f":"C8+D8+E8+F8+G8+H8+I8+J8","v":116},{"$f":"E8*1+F8*0.5+G8*0.5","v":{"v":62,"d":"$62.00"}},null,{"v":49.76,"d":"$49.76"},null,{"v":18.77,"d":"$18.77"},{"$nulls":3},{"$f":"SUM(O8:U8)","v":{"v":68.53,"d":"$68.53"}},{"$f":"V8-N8","v":{"v":6.530000000000001,"d":"$6.53"}},null,null,120,0,{"$f":"IF(Z8=0, 1, (Z8-AA8)/Z8)","v":{"v":1,"d":"100.00%"}},"2017-05-08","Monday",11,{"$nulls":3},{"$f":"AE8+AF8+AG8","v":11},{"$f":"AE8*2+AF8*2","v":{"v":22,"d":"$22.00"}},{"$nulls":4},{"v":7,"d":"$7.00"},{"v":7,"d":"$7.00"},null,{"$f":"SUM(AK8:AQ8)","v":{"v":14,"d":"$14.00"}},2,2,null,{"$f":"(AS8+AT8)*2","v":{"v":8,"d":"$8.00"}},null,{"$f":"AR8+AV8+AW8","v":{"v":22,"d":"$22.00"}},{"v":0,"d":"$0.00"},"",null,11,0,{"$f":"IF(BB8=0, 1, (BB8-BC8)/BB8)","v":{"v":1,"d":"100.00%"}},{"$f":"M8+AI8","v":127}]
["2017-05-09","Tuesday",3,null,69,9,7,2,18,null,null,12,108,{"v":77,"d":"$77.00"},null,{"v":29.5,"d":"$29.50"},null,{"v":47.2,"d":"$47.20"},{"$nulls":3},{"$f":"SUM(O9:U9)","v":{"v":76.7,"d":"$76.70"}},{"v":-0.29999999999999716,"d":"($0.30)"},{"$f":"IF(W9>0, \"Overage\", IF(W9<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},{"$f":"A9","v":"2017-05-09"},{"$f":"B9","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(AK9:AQ9)","v":{"v":18,"d":"$18.00"}},2,3,null,{"v":10,"d":"$10.00"},{"$f":"AU9*2","v":{"v":0,"d":"$0.00"}},{"v":28,"d":"$28.00"},{"$f":"AX9-AJ9","v":{"v":0,"d":"$0.00"}},"",null,{"$f":"AE9","v":14},0,{"v":1,"d":"100.00%"},{"$f":"BE8+M9+AI9","v":249}]
["2017-05-10","Wednesday",7,null,51,14,2,8,20,null,null,23,102,{"v":59,"d":"$59.00"},null,{"v":42.55,"d":"$42.55"},null,{"v":16.5,"d":"$16.50"},{"$nulls":3},{"v":59.05,"d":"$59.05"},{"v":0.04999999999999716,"d":"$0.05"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-10","Wednesday",22,{"$nulls":3},22,{"v":44,"d":"$44.00"},{"$nulls":4},{"v":10,"d":"$10.00"},{"v":16,"d":"$16.00"},null,{"v":26,"d":"$26.00"},5,4,null,{"v":18,"d":"$18.00"},{"v":0,"d":"$0.00"},{"v":44,"d":"$44.00"},{"v":0,"d":"$0.00"},"",null,22,0,{"v":1,"d":"100.00%"},373]
["2017-05-11","Thursday",9,null,57,8,4,8,6,null,null,9,92,{"v":63,"d":"$63.00"},null,{"v":18.5,"d":"$18.50"},null,{"v":47,"d":"$47.00"},{"$nulls":3},{"v":65.5,"d":"$65.50"},{"v":2.5,"d":"$2.50"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-11","Thursday",9,{"$nulls":3},9,{"v":18,"d":"$18.00"},{"$nulls":4},{"v":4,"d":"$4.00"},{"v":12,"d":"$12.00"},null,{"v":16,"d":"$16.00"},null,1,null,{"v":2,"d":"$2.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":"BE10+M11+AI11","v":474}]
["2017-05-12","Friday",4,null,57,8,2,6,19,null,null,19,96,{"v":62,"d":"$62.00"},null,{"v":41.57,"d":"$41.57"},null,{"v":18.9,"d":"$18.90"},{"$nulls":3},{"v":60.47,"d":"$60.47"},{"v":-1.5300000000000011,"d":"($1.53)"},{"$f":"IF(W12>0, \"Overage\", IF(W12<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-05-12","Friday",19,{"$nulls":3},19,{"v":38,"d":"$38.00"},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":16,"d":"$16.00"},null,{"v":22,"d":"$22.00"},4,4,null,{"v":16,"d":"$16.00"},{"v":0,"d":"$0.00"},{"v":38,"d":"$38.00"},{"v":0,"d":"$0.00"},"",null,19,0,{"v":1,"d":"100.00%"},{"$f":"BE11+M12+AI12","v":589}]
["2017-05-15","Monday",6,null,40,9,2,6,11,{"$nulls":3},74,{"v":45.5,"d":"$45.50"},{"v":25.05,"d":"$25.05"},{"v":20.95,"d":"$20.95"},{"$nulls":5},{"v":46,"d":"$46.00"},{"v":0.5,"d":"$0.50"},{"$f":"IF(W13>0, \"Overage\", IF(W13<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-05-15","Monday",15,{"$nulls":3},15,{"v":30,"d":"$30.00"},{"$nulls":4},{"v":8,"d":"$8.00"},{"v":14,"d":"$14.00"},null,{"v":22,"d":"$22.00"},2,2,null,{"v":8,"d":"$8.00"},{"v":0,"d":"$0.00"},{"v":30,"d":"$30.00"},{"v":0,"d":"$0.00"},"",null,15,0,{"v":1,"d":"100.00%"},{"$f":"M13+AI13","v":89}]
["2017-05-16","Tuesday",6,null,52,18,6,9,25,null,null,22,116,{"v":64,"d":"$64.00"},{"v":19.75,"d":"$19.75"},{"v":42.4,"d":"$42.40"},{"$nulls":5},{"v":62.15,"d":"$62.15"},{"v":-1.8500000000000014,"d":"($1.85)"},"Shortage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-16","Tuesday",12,{"$nulls":3},12,{"v":24,"d":"$24.00"},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":10,"d":"$10.00"},null,{"v":12,"d":"$12.00"},2,4,null,{"v":12,"d":"$12.00"},null,{"v":24,"d":"$24.00"},{"v":0,"d":"$0.00"},"",null,12,0,{"v":1,"d":"100.00%"},{"$f":"BE13+M14+AI14","v":217}]
["2017-05-17","Wednesday",6,null,35,9,null,5,11,null,null,4,66,{"v":39.5,"d":"$39.50"},{"v":29.46,"d":"$29.46"},{"v":11.5,"d":"$11.50"},{"$nulls":5},{"v":40.96,"d":"$40.96"},{"v":1.4600000000000009,"d":"$1.46"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-17","Wednesday",17,{"$nulls":3},17,{"v":34,"d":"$34.00"},{"$nulls":4},{"v":8,"d":"$8.00"},{"v":22,"d":"$22.00"},null,{"v":30,"d":"$30.00"},null,2,null,{"v":4,"d":"$4.00"},null,{"v":34,"d":"$34.00"},{"v":0,"d":"$0.00"},"",null,17,0,{"v":1,"d":"100.00%"},300]
["2017-05-18","Thursday",{"$nulls":10},0,{"v":0,"d":"$0.00"},{"$nulls":7},{"$f":"SUM(O16:U16)","v":{"v":0,"d":"$0.00"}},{"$f":"V16-N16","v":{"v":0,"d":"$0.00"}},{"$f":"IF(W16>0, \"Overage\", IF(W16<0, \"Shortage\", \"\"))","v":""},null,120,0,{"$f":"IF(Z16=0, 1, (Z16-AA16)/Z16)","v":{"v":1,"d":"100.00%"}},{"$f":"A16","v":"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":"AU16*2","v":{"v":0,"d":"$0.00"}},{"$f":"AR16+AV16+AW16","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"",null,{"$f":"AE16","v":0},0,{"$f":"IF(BB16=0, 1, (BB16-BC16)/BB16)","v":{"v":1,"d":"100.00%"}},{"$f":"BE15+M16+AI16","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":"BE16+M17+AI17","v":300}]
["2017-05-18","Thursday",14,null,48,16,2,3,9,null,null,6,92,{"v":57,"d":"$57.00"},null,{"v":41.16,"d":"$41.16"},{"v":17.12,"d":"$17.12"},{"$nulls":4},{"v":58.28,"d":"$58.28"},{"v":1.2800000000000011,"d":"$1.28"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-18",{"$f":"B18","v":"Thursday"},10,{"$nulls":3},10,{"v":20,"d":"$20.00"},{"$nulls":5},{"v":10,"d":"$10.00"},null,{"v":10,"d":"$10.00"},3,2,null,{"v":10,"d":"$10.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":"BE17+M18+AI18","v":402}]
["2017-05-19","Friday",8,null,38,10,null,5,15,null,null,8,76,{"v":43,"d":"$43.00"},null,{"v":15.75,"d":"$15.75"},{"v":26,"d":"$26.00"},{"$nulls":4},{"v":41.75,"d":"$41.75"},{"v":-1.25,"d":"($1.25)"},"Shortage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-19",{"$f":"B19","v":"Friday"},21,{"$nulls":3},21,{"v":42,"d":"$42.00"},{"$nulls":4},{"v":14,"d":"$14.00"},{"v":16,"d":"$16.00"},null,{"v":30,"d":"$30.00"},4,2,null,{"v":12,"d":"$12.00"},{"v":0,"d":"$0.00"},{"v":42,"d":"$42.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY19>0, \"Overage\", IF(AY19<0, \"Shortage\", \"\"))","v":""},null,21,0,{"v":1,"d":"100.00%"},499]
["2017-05-22","Monday",2,null,55,11,1,null,18,null,null,12,87,{"v":61,"d":"$61.00"},null,{"v":36.5,"d":"$36.50"},{"v":24.99,"d":"$24.99"},{"$nulls":4},{"v":61.489999999999995,"d":"$61.49"},{"v":0.4899999999999949,"d":"$0.49"},{"$f":"IF(W20>0, \"Overage\", IF(W20<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-05-22","Monday",16,{"$nulls":3},16,{"v":32,"d":"$32.00"},{"$nulls":4},{"v":6,"d":"$6.00"},{"v":18,"d":"$18.00"},null,{"v":24,"d":"$24.00"},2,2,null,{"v":8,"d":"$8.00"},{"v":0,"d":"$0.00"},{"v":32,"d":"$32.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY20>0, \"Overage\", IF(AY20<0, \"Shortage\", \"\"))","v":""},null,16,0,{"v":1,"d":"100.00%"},{"$f":"M20+AI20","v":103}]
["5/23/20107","Tuesday",3,null,50,15,6,3,16,null,null,4,93,{"v":60.5,"d":"$60.50"},null,{"v":16.23,"d":"$16.23"},{"v":44.49,"d":"$44.49"},{"$nulls":4},{"v":60.72,"d":"$60.72"},{"v":0.21999999999999886,"d":"$0.22"},{"$f":"IF(W21>0, \"Overage\", IF(W21<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"5/23/20107","Tuesday",11,{"$nulls":3},11,{"v":22,"d":"$22.00"},{"$nulls":5},{"v":10,"d":"$10.00"},null,{"v":10,"d":"$10.00"},3,3,null,{"v":12,"d":"$12.00"},{"$f":"AU21*2","v":{"v":0,"d":"$0.00"}},{"v":22,"d":"$22.00"},{"v":0,"d":"$0.00"},{"$f":"IF(AY21>0, \"Overage\", IF(AY21<0, \"Shortage\", \"\"))","v":""},null,11,0,{"v":1,"d":"100.00%"},{"$f":"BE20+M21+AI21","v":207}]
["2017-05-24","Wednesday",10,null,35,12,2,2,15,null,null,9,76,{"v":42,"d":"$42.00"},null,{"v":24.5,"d":"$24.50"},{"v":18.35,"d":"$18.35"},{"$nulls":4},{"v":42.85,"d":"$42.85"},{"v":0.8500000000000014,"d":"$0.85"},"Overage",null,120,0,{"v":1,"d":"100.00%"},"2017-05-24","Wednesday",9,{"$nulls":3},9,{"v":18,"d":"$18.00"},{"$nulls":4},{"v":4,"d":"$4.00"},{"v":6,"d":"$6.00"},null,{"v":10,"d":"$10.00"},null,4,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%"},292]
["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},292]
["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},292]
["2017-05-25","Thursday",1,null,42,15,2,5,14,null,null,29,79,{"v":50.5,"d":"$50.50"},null,{"v":26.28,"d":"$26.28"},{"v":25.75,"d":"$25.75"},{"$nulls":4},{"$f":"SUM(O25:U25)","v":{"v":52.03,"d":"$52.03"}},{"$f":"V25-N25","v":{"v":1.5300000000000011,"d":"$1.53"}},{"$f":"IF(W25>0, \"Overage\", IF(W25<0, \"Shortage\", \"\"))","v":"Overage"},null,{"$f":"2*12*5","v":120},0,{"$f":"IF(Z25=0, 1, (Z25-AA25)/Z25)","v":{"v":1,"d":"100.00%"}},"2017-05-25","Thursday",14,{"$nulls":3},{"$f":"AE25+AF25+AG25","v":14},{"$f":"AE25*2+AF25*2","v":{"v":28,"d":"$28.00"}},{"$nulls":5},{"v":18,"d":"$18.00"},null,{"$f":"SUM(AK25:AQ25)","v":{"v":18,"d":"$18.00"}},3,2,null,{"v":10,"d":"$10.00"},null,{"$f":"AR25+AV25+AW25","v":{"v":28,"d":"$28.00"}},{"v":0,"d":"$0.00"},{"$f":"IF(AY25>0, \"Overage\", IF(AY25<0, \"Shortage\", \"\"))","v":""},null,{"$f":"AE25","v":14},0,{"$f":"IF(BB25=0, 1, (BB25-BC25)/BB25)","v":{"v":1,"d":"100.00%"}},385]
["526/2017","Friday",12,null,34,11,null,10,13,null,null,8,80,{"v":39.5,"d":"$39.50"},null,{"v":27.33,"d":"$27.33"},{"v":12.47,"d":"$12.47"},{"$nulls":4},{"$f":"SUM(O26:U26)","v":{"v":39.8,"d":"$39.80"}},{"$f":"V26-N26","v":{"v":0.29999999999999716,"d":"$0.30"}},{"$f":"IF(W26>0, \"Overage\", IF(W26<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"526/2017","Friday",13,{"$nulls":3},13,{"v":26,"d":"$26.00"},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":8,"d":"$8.00"},null,{"v":10,"d":"$10.00"},4,4,null,{"v":16,"d":"$16.00"},null,{"v":26,"d":"$26.00"},{"v":0,"d":"$0.00"},"",null,13,0,{"v":1,"d":"100.00%"},478]
["2017-05-29","Monday",1,null,21,4,null,null,6,{"$nulls":3},32,{"v":23,"d":"$23.00"},null,{"v":2,"d":"$2.00"},{"v":20.7,"d":"$20.70"},{"$nulls":4},{"$f":"SUM(O27:U27)","v":{"v":22.7,"d":"$22.70"}},{"$f":"V27-N27","v":{"v":-0.3000000000000007,"d":"($0.30)"}},{"$f":"IF(W27>0, \"Overage\", IF(W27<0, \"Shortage\", \"\"))","v":"Shortage"},null,120,0,{"v":1,"d":"100.00%"},"2017-05-29","Monday",7,{"$nulls":3},{"$f":"AE27+AF27+AG27","v":7},{"$f":"AE27*2+AF27*2","v":{"v":14,"d":"$14.00"}},{"$nulls":4},{"v":4,"d":"$4.00"},{"v":6,"d":"$6.00"},null,{"v":10,"d":"$10.00"},null,2,null,{"v":4,"d":"$4.00"},null,{"v":14,"d":"$14.00"},{"v":0,"d":"$0.00"},"",null,7,null,{"v":1,"d":"100.00%"},{"$f":"M27+AI27","v":39}]
["2017-05-30","Tuesday",1,null,56,15,null,5,20,null,null,7,{"$f":"C28+D28+E28+F28+G28+H28+I28+J28","v":97},{"$f":"E28*1+F28*0.5+G28*0.5","v":{"v":63.5,"d":"$63.50"}},{"v":30,"d":"$30.00"},null,{"v":33.5,"d":"$33.50"},{"$nulls":4},{"$f":"SUM(O28:U28)","v":{"v":63.5,"d":"$63.50"}},{"$f":"V28-N28","v":{"v":0,"d":"$0.00"}},{"$f":"IF(W28>0, \"Overage\", IF(W28<0, \"Shortage\", \"\"))","v":""},null,120,0,{"v":1,"d":"100.00%"},"2017-05-30","Tuesday",10,{"$nulls":3},10,{"v":20,"d":"$20.00"},{"$nulls":4},{"v":2,"d":"$2.00"},{"v":10,"d":"$10.00"},null,{"v":12,"d":"$12.00"},null,4,null,{"v":8,"d":"$8.00"},null,{"v":20,"d":"$20.00"},{"v":0,"d":"$0.00"},"",null,10,null,{"v":1,"d":"100.00%"},146]
["2017-05-31","Wednesday",11,null,48,14,null,3,15,null,null,4,{"$f":"C29+D29+E29+F29+G29+H29+I29+J29","v":91},{"v":55,"d":"$55.00"},{"v":17.5,"d":"$17.50"},null,{"v":38,"d":"$38.00"},{"$nulls":4},{"$f":"SUM(O29:U29)","v":{"v":55.5,"d":"$55.50"}},{"$f":"V29-N29","v":{"v":0.5,"d":"$0.50"}},{"$f":"IF(W29>0, \"Overage\", IF(W29<0, \"Shortage\", \"\"))","v":"Overage"},null,120,0,{"v":1,"d":"100.00%"},"2017-05-31","Wednesday",21,{"$nulls":3},21,{"v":42,"d":"$42.00"},{"$nulls":4},{"v":8,"d":"$8.00"},{"v":22,"d":"$22.00"},null,{"v":30,"d":"$30.00"},1,5,null,{"v":12,"d":"$12.00"},null,{"$f":"AR29+AV29+AW29","v":{"v":42,"d":"$42.00"}},{"$f":"AX29-AJ29","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AY29>0, \"Overage\", IF(AY29<0, \"Shortage\", \"\"))","v":""},null,21,null,{"v":1,"d":"100.00%"},258]
[{"$nulls":12},0,{"v":0,"d":"$0.00"},{"$nulls":37},""]
[{"$nulls":12},0,{"v":0,"d":"$0.00"},{"$nulls":37},""]
[{"$nulls":12},0,{"v":0,"d":"$0.00"},{"$nulls":39},299]
[null,null,{"$f":"SUM(C3:C29)","v":134},0,1093,286,52,115,351,0,0,213,2031,{"v":1262,"d":"$1,262.00"},{"$nulls":7},{"$f":"SUM(V3:V29)","v":{"v":1278.88,"d":"$1,278.88"}},{"$f":"V33-N33","v":{"v":16.88000000000011,"d":"$16.88"}},{"$f":"IF(W33>0, \"Overage\", IF(W33<0, \"Shortage\", \"\"))","v":"Overage"},null,2760,{"$f":"SUM(AA3:AA29)","v":0},{"$f":"IF(Z33=0, 1, (Z33-AA33)/Z33)","v":{"v":1,"d":"100.00%"}},null,"EOM Totals:",{"$f":"SUM(AE3:AE32)","v":330},{"$f":"SUM(AF3:AF29)","v":0},{"$f":"SUM(AG3:AG29)","v":0},{"$f":"SUM(AH3:AH29)","v":0},{"$f":"SUM(AI3:AI32)","v":330},{"$f":"SUM(AJ3:AJ29)","v":{"v":660,"d":"$660.00"}},{"$nulls":7},{"$f":"SUM(AR3:AR29)","v":{"v":428,"d":"$428.00"}},49,67,0,{"v":232,"d":"$232.00"},{"v":0,"d":"$0.00"},{"v":660,"d":"$660.00"},{"$f":"AX33-AJ33","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AY33>0, \"Overage\", IF(AY33<0, \"Shortage\", \"\"))","v":""},null,{"$f":"SUM(BB28:BB32)","v":330},{"$f":"SUM(BC3:BC29)","v":0},{"$f":"IF(BB33=0, 1, (BB33-BC33)/BB33)","v":{"v":1,"d":"100.00%"}},{"$f":"BE7+BE12+BE19+BE26+BE29","v":2361}]
["Manager Signature: ",{"$nulls":21},{"$f":"SUM(W3:W29)","v":{"v":16.879999999999992,"d":"$16.88"}},"Overage",{"$nulls":26},{"$f":"SUM(AY3:AY29)","v":{"v":0,"d":"$0.00"}},""]
["Date: ",null,"2017-06-08"]
[]
[]
[{"$nulls":12}," "]