{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Local Miles Exp Rpt","Mileage Chart","Pay Periods","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Local Miles Exp Rpt","index":0,"n_rows":81,"n_cols":16,"rows_kept":81,"cut":false,"hidden":false,"merged":[[46,0,49,0],[46,1,49,1],[46,2,47,2],[42,0,45,0],[42,1,45,1],[42,2,43,2],[44,2,44,10],[45,2,45,10],[46,15,49,15],[47,14,49,14],[48,2,48,10],[49,2,49,10],[42,15,45,15],[43,14,45,14],[38,0,41,0],[38,1,41,1],[38,15,41,15],[34,15,37,15],[34,0,37,0],[36,2,36,10],[35,14,37,14],[39,14,41,14],[6,0,6,1],[19,14,21,14],[20,2,20,10],[30,15,33,15],[27,14,29,14],[26,1,29,1],[30,0,33,0],[30,1,33,1],[26,0,29,0],[10,15,13,15],[22,0,25,0],[7,0,7,1],[10,0,13,0],[18,0,21,0],[18,1,21,1],[14,0,17,0],[5,5,5,8],[31,14,33,14],[8,11,8,13],[5,9,6,10],[11,14,13,14],[23,14,25,14],[28,2,28,10],[29,2,29,10],[32,2,32,10],[15,14,17,14],[21,2,21,10],[8,3,8,10],[6,5,6,8],[6,3,6,4],[5,11,6,15],[10,2,11,2],[50,1,50,12],[14,2,15,2],[38,2,39,2],[12,2,12,10],[14,1,17,1],[16,2,16,10],[17,2,17,10],[18,2,19,2],[33,2,33,10],[37,2,37,10],[13,2,13,10],[34,1,37,1],[40,2,40,10],[41,2,41,10],[34,2,35,2],[26,2,27,2],[5,3,5,4],[1,0,1,2],[3,0,3,1],[5,0,5,1],[4,0,4,1],[3,5,3,8],[4,5,4,8],[2,3,2,8],[2,11,2,12],[3,9,4,10],[3,11,4,15],[2,13,2,15],[3,3,3,4],[4,3,4,4],[22,1,25,1],[10,1,13,1],[14,15,17,15],[18,15,21,15],[22,15,25,15],[26,15,29,15],[30,2,31,2],[24,2,24,10],[25,2,25,10],[22,2,23,2]]}
["<<End","AL","AR","BO","ES","MB","MC","NS","RC","WS"]
["Travel Expense Report",null,null,null,null,null,{"$f":"C3","v":"Your Name Here"},null,null,{"$f":"C5","v":"00:00:00"},"to",{"$f":"C6","v":"1900-01-13"},null,null,"CY 2013"]
["Rev 02/18/2013","Name","Your Name Here","\"Bill To\" Codes",null,null,null,null,null,null,null,"Date Submitted"]
["Department",null,"Guinn Healthcare Technologies, LLC","WFD-FA",null,"Guinn Healthcare Tech, LLC",null,null,null,"Staff Signature:"]
["Period Begin",null,null,"WFD-NS",null,"N/A"]
["Period End",null,{"$f":"C5+13","v":"1900-01-13"},"WFD-MH",null,"Workforce - MH Countract",null,null,null,"Authorized by:",null,"Tony Guinn, Director, GHT, LLC"]
["Per Mile Reimb.",null,0.5,"WFD-YO",null,"N/A"]
["Total Reimb. Due",null,{"$f":"P51","v":0},{"$f":"D4","v":"WFD-FA"},{"$f":"SUMIF($A$11:$A$50,$D$4,$P$11:$P$50)","v":0},{"$f":"D5","v":"WFD-NS"},{"$f":"SUMIF($A$11:$A$50,$D$5,$P$11:$P$50)","v":0},{"$f":"D6","v":"WFD-MH"},{"$f":"SUMIF($A$11:$A$50,$D$6,$P$11:$P$50)","v":0},{"$f":"D7","v":"WFD-YO"},{"$f":"SUMIF($A$11:$A$50,$D$7,$P$11:$P$50)","v":0}]
[null,null,null,"Miles from Chart",null,null,null,null,null,null,null,"Miles from Odometer"]
["Bill To:","Date","Description/purpose","From","To","To","To","To","To","To","Miles from Chart","Miles Begin","Miles End","Miles Traveled",null,"Mileage Reimbursement"]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E12:K12)+N13+N14)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D11),E11=\"<<End\",D11=\"<<End\",ISBLANK(E11)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D11,'Mileage Chart'!$B$2:$B$15,), MATCH(E11,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E11),F11=\"<<End\",E11=\"<<End\",ISBLANK(F11)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E11,'Mileage Chart'!$B$2:$B$15,), MATCH(F11,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F11),G11=\"<<End\",F11=\"<<End\",ISBLANK(G11)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F11,'Mileage Chart'!$B$2:$B$15,), MATCH(G11,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G11),H11=\"<<End\",G11=\"<<End\",ISBLANK(H11)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G11,'Mileage Chart'!$B$2:$B$15,), MATCH(H11,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H11),I11=\"<<End\",H11=\"<<End\",ISBLANK(I11)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H11,'Mileage Chart'!$B$2:$B$15,), MATCH(I11,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I11),J11=\"<<End\",I11=\"<<End\",ISBLANK(J11)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I11,'Mileage Chart'!$B$2:$B$15,), MATCH(J11,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J11),K11=\"<<End\",J11=\"<<End\",ISBLANK(K11)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J11,'Mileage Chart'!$B$2:$B$15,), MATCH(K11,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E12:K12)","v":0},{"$f":"N12+N13+N14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M13-L13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M14-L14","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E16:K16)+N17+N18)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D15),E15=\"<<End\",D15=\"<<End\",ISBLANK(E15)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D15,'Mileage Chart'!$B$2:$B$15,), MATCH(E15,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E15),F15=\"<<End\",E15=\"<<End\",ISBLANK(F15)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E15,'Mileage Chart'!$B$2:$B$15,), MATCH(F15,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F15),G15=\"<<End\",F15=\"<<End\",ISBLANK(G15)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F15,'Mileage Chart'!$B$2:$B$15,), MATCH(G15,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G15),H15=\"<<End\",G15=\"<<End\",ISBLANK(H15)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G15,'Mileage Chart'!$B$2:$B$15,), MATCH(H15,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H15),I15=\"<<End\",H15=\"<<End\",ISBLANK(I15)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H15,'Mileage Chart'!$B$2:$B$15,), MATCH(I15,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I15),J15=\"<<End\",I15=\"<<End\",ISBLANK(J15)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I15,'Mileage Chart'!$B$2:$B$15,), MATCH(J15,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J15),K15=\"<<End\",J15=\"<<End\",ISBLANK(K15)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J15,'Mileage Chart'!$B$2:$B$15,), MATCH(K15,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E16:K16)","v":0},{"$f":"N16+N17+N18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M17-L17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M18-L18","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E20:K20)+N21+N22)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D19),E19=\"<<End\",D19=\"<<End\",ISBLANK(E19)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D19,'Mileage Chart'!$B$2:$B$15,), MATCH(E19,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E19),F19=\"<<End\",E19=\"<<End\",ISBLANK(F19)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E19,'Mileage Chart'!$B$2:$B$15,), MATCH(F19,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F19),G19=\"<<End\",F19=\"<<End\",ISBLANK(G19)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F19,'Mileage Chart'!$B$2:$B$15,), MATCH(G19,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G19),H19=\"<<End\",G19=\"<<End\",ISBLANK(H19)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G19,'Mileage Chart'!$B$2:$B$15,), MATCH(H19,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H19),I19=\"<<End\",H19=\"<<End\",ISBLANK(I19)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H19,'Mileage Chart'!$B$2:$B$15,), MATCH(I19,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I19),J19=\"<<End\",I19=\"<<End\",ISBLANK(J19)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I19,'Mileage Chart'!$B$2:$B$15,), MATCH(J19,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J19),K19=\"<<End\",J19=\"<<End\",ISBLANK(K19)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J19,'Mileage Chart'!$B$2:$B$15,), MATCH(K19,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E20:K20)","v":0},{"$f":"N20+N21+N22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M21-L21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M22-L22","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E24:K24)+N25+N26)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D23),E23=\"<<End\",D23=\"<<End\",ISBLANK(E23)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D23,'Mileage Chart'!$B$2:$B$15,), MATCH(E23,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E23),F23=\"<<End\",E23=\"<<End\",ISBLANK(F23)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E23,'Mileage Chart'!$B$2:$B$15,), MATCH(F23,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F23),G23=\"<<End\",F23=\"<<End\",ISBLANK(G23)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F23,'Mileage Chart'!$B$2:$B$15,), MATCH(G23,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G23),H23=\"<<End\",G23=\"<<End\",ISBLANK(H23)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G23,'Mileage Chart'!$B$2:$B$15,), MATCH(H23,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H23),I23=\"<<End\",H23=\"<<End\",ISBLANK(I23)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H23,'Mileage Chart'!$B$2:$B$15,), MATCH(I23,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I23),J23=\"<<End\",I23=\"<<End\",ISBLANK(J23)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I23,'Mileage Chart'!$B$2:$B$15,), MATCH(J23,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J23),K23=\"<<End\",J23=\"<<End\",ISBLANK(K23)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J23,'Mileage Chart'!$B$2:$B$15,), MATCH(K23,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E24:K24)","v":0},{"$f":"N24+N25+N26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M25-L25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M26-L26","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E28:K28)+N29+N30)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D27),E27=\"<<End\",D27=\"<<End\",ISBLANK(E27)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D27,'Mileage Chart'!$B$2:$B$15,), MATCH(E27,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E27),F27=\"<<End\",E27=\"<<End\",ISBLANK(F27)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E27,'Mileage Chart'!$B$2:$B$15,), MATCH(F27,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F27),G27=\"<<End\",F27=\"<<End\",ISBLANK(G27)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F27,'Mileage Chart'!$B$2:$B$15,), MATCH(G27,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G27),H27=\"<<End\",G27=\"<<End\",ISBLANK(H27)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G27,'Mileage Chart'!$B$2:$B$15,), MATCH(H27,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H27),I27=\"<<End\",H27=\"<<End\",ISBLANK(I27)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H27,'Mileage Chart'!$B$2:$B$15,), MATCH(I27,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I27),J27=\"<<End\",I27=\"<<End\",ISBLANK(J27)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I27,'Mileage Chart'!$B$2:$B$15,), MATCH(J27,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J27),K27=\"<<End\",J27=\"<<End\",ISBLANK(K27)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J27,'Mileage Chart'!$B$2:$B$15,), MATCH(K27,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E28:K28)","v":0},{"$f":"N28+N29+N30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M29-L29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M30-L30","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E32:K32)+N33+N34)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D31),E31=\"<<End\",D31=\"<<End\",ISBLANK(E31)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D31,'Mileage Chart'!$B$2:$B$15,), MATCH(E31,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E31),F31=\"<<End\",E31=\"<<End\",ISBLANK(F31)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E31,'Mileage Chart'!$B$2:$B$15,), MATCH(F31,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F31),G31=\"<<End\",F31=\"<<End\",ISBLANK(G31)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F31,'Mileage Chart'!$B$2:$B$15,), MATCH(G31,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G31),H31=\"<<End\",G31=\"<<End\",ISBLANK(H31)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G31,'Mileage Chart'!$B$2:$B$15,), MATCH(H31,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H31),I31=\"<<End\",H31=\"<<End\",ISBLANK(I31)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H31,'Mileage Chart'!$B$2:$B$15,), MATCH(I31,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I31),J31=\"<<End\",I31=\"<<End\",ISBLANK(J31)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I31,'Mileage Chart'!$B$2:$B$15,), MATCH(J31,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J31),K31=\"<<End\",J31=\"<<End\",ISBLANK(K31)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J31,'Mileage Chart'!$B$2:$B$15,), MATCH(K31,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E32:K32)","v":0},{"$f":"N32+N33+N34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M33-L33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M34-L34","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E36:K36)+N37+N38)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D35),E35=\"<<End\",D35=\"<<End\",ISBLANK(E35)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D35,'Mileage Chart'!$B$2:$B$15,), MATCH(E35,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E35),F35=\"<<End\",E35=\"<<End\",ISBLANK(F35)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E35,'Mileage Chart'!$B$2:$B$15,), MATCH(F35,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F35),G35=\"<<End\",F35=\"<<End\",ISBLANK(G35)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F35,'Mileage Chart'!$B$2:$B$15,), MATCH(G35,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G35),H35=\"<<End\",G35=\"<<End\",ISBLANK(H35)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G35,'Mileage Chart'!$B$2:$B$15,), MATCH(H35,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H35),I35=\"<<End\",H35=\"<<End\",ISBLANK(I35)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H35,'Mileage Chart'!$B$2:$B$15,), MATCH(I35,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I35),J35=\"<<End\",I35=\"<<End\",ISBLANK(J35)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I35,'Mileage Chart'!$B$2:$B$15,), MATCH(J35,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J35),K35=\"<<End\",J35=\"<<End\",ISBLANK(K35)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J35,'Mileage Chart'!$B$2:$B$15,), MATCH(K35,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E36:K36)","v":0},{"$f":"N36+N37+N38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M37-L37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M38-L38","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E40:K40)+N41+N42)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D39),E39=\"<<End\",D39=\"<<End\",ISBLANK(E39)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D39,'Mileage Chart'!$B$2:$B$15,), MATCH(E39,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E39),F39=\"<<End\",E39=\"<<End\",ISBLANK(F39)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E39,'Mileage Chart'!$B$2:$B$15,), MATCH(F39,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F39),G39=\"<<End\",F39=\"<<End\",ISBLANK(G39)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F39,'Mileage Chart'!$B$2:$B$15,), MATCH(G39,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G39),H39=\"<<End\",G39=\"<<End\",ISBLANK(H39)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G39,'Mileage Chart'!$B$2:$B$15,), MATCH(H39,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H39),I39=\"<<End\",H39=\"<<End\",ISBLANK(I39)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H39,'Mileage Chart'!$B$2:$B$15,), MATCH(I39,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I39),J39=\"<<End\",I39=\"<<End\",ISBLANK(J39)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I39,'Mileage Chart'!$B$2:$B$15,), MATCH(J39,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J39),K39=\"<<End\",J39=\"<<End\",ISBLANK(K39)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J39,'Mileage Chart'!$B$2:$B$15,), MATCH(K39,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E40:K40)","v":0},{"$f":"N40+N41+N42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M41-L41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M42-L42","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E44:K44)+N45+N46)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D43),E43=\"<<End\",D43=\"<<End\",ISBLANK(E43)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D43,'Mileage Chart'!$B$2:$B$15,), MATCH(E43,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E43),F43=\"<<End\",E43=\"<<End\",ISBLANK(F43)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E43,'Mileage Chart'!$B$2:$B$15,), MATCH(F43,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F43),G43=\"<<End\",F43=\"<<End\",ISBLANK(G43)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F43,'Mileage Chart'!$B$2:$B$15,), MATCH(G43,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G43),H43=\"<<End\",G43=\"<<End\",ISBLANK(H43)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G43,'Mileage Chart'!$B$2:$B$15,), MATCH(H43,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H43),I43=\"<<End\",H43=\"<<End\",ISBLANK(I43)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H43,'Mileage Chart'!$B$2:$B$15,), MATCH(I43,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I43),J43=\"<<End\",I43=\"<<End\",ISBLANK(J43)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I43,'Mileage Chart'!$B$2:$B$15,), MATCH(J43,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J43),K43=\"<<End\",J43=\"<<End\",ISBLANK(K43)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J43,'Mileage Chart'!$B$2:$B$15,), MATCH(K43,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E44:K44)","v":0},{"$f":"N44+N45+N46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M45-L45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M46-L46","v":0}]
[null,null,null,null,null,null,null,null,null,null,"<<End",null,null,null,"Tot Miles",{"$f":"(SUM(E48:K48)+N49+N50)*$C$7","v":0}]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(D47),E47=\"<<End\",D47=\"<<End\",ISBLANK(E47)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(D47,'Mileage Chart'!$B$2:$B$15,), MATCH(E47,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(E47),F47=\"<<End\",E47=\"<<End\",ISBLANK(F47)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(E47,'Mileage Chart'!$B$2:$B$15,), MATCH(F47,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(F47),G47=\"<<End\",F47=\"<<End\",ISBLANK(G47)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(F47,'Mileage Chart'!$B$2:$B$15,), MATCH(G47,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(G47),H47=\"<<End\",G47=\"<<End\",ISBLANK(H47)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(G47,'Mileage Chart'!$B$2:$B$15,), MATCH(H47,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(H47),I47=\"<<End\",H47=\"<<End\",ISBLANK(I47)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(H47,'Mileage Chart'!$B$2:$B$15,), MATCH(I47,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(I47),J47=\"<<End\",I47=\"<<End\",ISBLANK(J47)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(I47,'Mileage Chart'!$B$2:$B$15,), MATCH(J47,'Mileage Chart'!$B$2:$O$2,)))","v":0},{"$f":"IF(OR(ISBLANK(J47),K47=\"<<End\",J47=\"<<End\",ISBLANK(K47)),0,INDEX('Mileage Chart'!$B$2:$O$15, MATCH(J47,'Mileage Chart'!$B$2:$B$15,), MATCH(K47,'Mileage Chart'!$B$2:$O$2,)))","v":0},null,null,{"$f":"SUM(E48:K48)","v":0},{"$f":"N48+N49+N50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M49-L49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M50-L50","v":0}]
[null,"Totals",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N11:N50)","v":0},null,{"$f":"SUM(P11:P50)","v":0}]
[]
[]
["Begin"]
[{"$f":"'Pay Periods'!A4","v":"2013-02-07"}]
[{"$f":"'Pay Periods'!A5","v":"2013-02-21"}]
[{"$f":"'Pay Periods'!A6","v":"2013-03-07"}]
[{"$f":"'Pay Periods'!A7","v":"2013-03-21"}]
[{"$f":"'Pay Periods'!A8","v":"2013-04-04"}]
[{"$f":"'Pay Periods'!A9","v":"2013-04-18"}]
[{"$f":"'Pay Periods'!A10","v":"2013-05-02"}]
[{"$f":"'Pay Periods'!A11","v":"2013-05-16"}]
[{"$f":"'Pay Periods'!A12","v":"2013-05-30"}]
[{"$f":"'Pay Periods'!A13","v":"2013-06-13"}]
[{"$f":"'Pay Periods'!A14","v":"2013-06-27"}]
[{"$f":"'Pay Periods'!A15","v":"2013-07-11"}]
[{"$f":"'Pay Periods'!A16","v":"2013-07-25"}]
[{"$f":"'Pay Periods'!A17","v":"2013-08-08"}]
[{"$f":"'Pay Periods'!A18","v":"2013-08-22"}]
[{"$f":"'Pay Periods'!A19","v":"2013-09-05"}]
[{"$f":"'Pay Periods'!A20","v":"2013-09-19"}]
[{"$f":"'Pay Periods'!A21","v":"2013-10-03"}]
[{"$f":"'Pay Periods'!A22","v":"2013-10-17"}]
[{"$f":"'Pay Periods'!A23","v":"2013-10-31"}]
[{"$f":"'Pay Periods'!A24","v":"2013-11-14"}]
[{"$f":"'Pay Periods'!A25","v":"2013-11-28"}]
[{"$f":"'Pay Periods'!A26","v":"2013-12-12"}]
[{"$f":"'Pay Periods'!A27","v":"2013-12-26"}]
[{"$f":"'Pay Periods'!A28","v":"2014-01-09"}]
[{"$f":"'Pay Periods'!A29","v":"2014-01-23"}]
[{"$f":"'Pay Periods'!A30","v":"2014-02-06"}]

{"sheet":"Mileage Chart","index":1,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,13,23,15],[24,13,25,15],[26,13,27,15],[16,13,17,15],[18,13,19,15],[20,13,21,15]]}
["Mileage Chart",null,null,null,null,null,"Board Office","Alliance Opp.Center","Arlington WC","East Side WC","Mid Cities WC","Northside WC","Resource Connection WC/GHT Office","Westside WC","Mid Cities BC"]
[null,null,null,null,null,null,"BO","AL","AR","ES","MC","NS","RC","WS","MB"]
[]
[]
[]
[]
["Board Office","BO",2.2999999999999998,16.399999999999999,null,null,null,20.5,14.7,6.9,11,4,9.6999999999999993,3.5,13.5]
["Alliance Opp.Center","AL",22,13.2,null,null,20.5,null,30.4,21.3,18,16.3,24.1,22.7,17.7]
["Arl.WC","AR",19.3,18.3,null,null,14.7,30.4,null,12,14.3,18,15.1,20.6,14]
["East Side WC","ES",8.9,13.5,null,null,6.9,21.3,12,null,9.5,7.3,11.2,9.8000000000000007,9.1999999999999993]
["Mid Cities WC","MC",18.399999999999999,8.9,null,null,11,18,14.3,9.5,null,8.3000000000000007,17.2,13.8,2.4]
["Northside WC","NS",5.3,13.4,null,null,4,16.3,18,7.3,8.3000000000000007,null,11.8,6.9,12.4]
["Resource Connection WC","RC",12.9,21.4,null,null,9.6999999999999993,24.1,15.1,11.2,17.2,11.8,null,13.1,17.399999999999999]
["Westside WC","WS",2,19.2,null,null,3.5,22.7,20.6,9.8000000000000007,13.8,6.9,13.1,null,16.399999999999999]
["Mid Cities BC","MB",null,null,null,null,13.5,17.7,14,9.1999999999999993,2.4,12.4,17.399999999999999,16.399999999999999]
["Alliance Opp.Center",null,null,null,"AL","13825 Aviator Way",null,null,"Ft Worth 76117",null,"(817)515-2100",null,null,"Updates"]
["Arlington WC/YOC",null,null,null,"AR","140 W Mitchell",null,null,"Arlington 76010",null,"(817)804-4200",null,1,"Chart Update 8/13/06; Board offices moved"]
["Board Office",null,null,null,"BO","1320 S. University Dr., Suite 600",null,null,"Forth Worth 76107"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Effective Dt. 10/01/06 - Delete Dan; insert new contract ref"]
[]
["East SideWC",null,null,null,"ES","4701 E Lancaster",null,null,"Ft Worth 76103",null,"(817)531-7800",null,3,"Deleted old addresses; changed rate; made RC and GHT office same"]
["Mid Cities BC",null,null,null,"MB","8701 Bedford Euless Rd., Hurst 76053"]
["Mid Cities WC",null,null,null,"MC","7001 Boulevard 26",null,null,"Nort Richland Hills 76180",null,"817 548-5200",null,4,"Chart updated 11/23/08 - Mid cities moved"]
["NorthsideWC",null,null,null,"NS","2100 N Main",null,null,"Ft Worth 76106",null,"(817)626-5262"]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Change rate to .55"]
["Resource Connection  WC",null,null,null,"RC","1400 Circle Dr/2300 Cir Dr.",null,null,"Ft Worth 76119",null,"(817)531-5670"]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Changed rate to .50 in Oct 09"]
["Westside WC",null,null,null,"WS","6000 Western Pl,Ste.700",null,null,"Ft Worth 76107",null,"(817)737-0311"]

{"sheet":"Pay Periods","index":2,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Pay Periods - Guinn Healthcare Technologies - 2009"]
["Period Begin","Begin Wk 2","Period End","Payday"]
["Thursday","Thursday","Wednesday","Tuesday"]
["2013-02-07","2013-02-14","2013-02-20","2013-02-26"]
[{"$f":"A4+14","v":"2013-02-21"},{"$f":"B4+14","v":"2013-02-28"},{"$f":"C4+14","v":"2013-03-06"},{"$f":"D4+14","v":"2013-03-12"}]
[{"$f":"A5+14","v":"2013-03-07"},"2013-03-14","2013-03-20","2013-03-26"]
["2013-03-21","2013-03-28","2013-04-03","2013-04-09"]
["2013-04-04","2013-04-11","2013-04-17","2013-04-23"]
["2013-04-18","2013-04-25","2013-05-01","2013-05-07"]
["2013-05-02","2013-05-09","2013-05-15","2013-05-21"]
["2013-05-16","2013-05-23","2013-05-29","2013-06-04"]
["2013-05-30","2013-06-06","2013-06-12","2013-06-18"]
["2013-06-13","2013-06-20","2013-06-26","2013-07-02"]
["2013-06-27","2013-07-04","2013-07-10","2013-07-16"]
["2013-07-11","2013-07-18","2013-07-24","2013-07-30"]
["2013-07-25","2013-08-01","2013-08-07","2013-08-13"]
["2013-08-08","2013-08-15","2013-08-21","2013-08-27"]
["2013-08-22","2013-08-29","2013-09-04","2013-09-10"]
["2013-09-05","2013-09-12","2013-09-18","2013-09-24"]
["2013-09-19","2013-09-26","2013-10-02","2013-10-08"]
["2013-10-03","2013-10-10","2013-10-16","2013-10-22"]
["2013-10-17","2013-10-24","2013-10-30","2013-11-05"]
["2013-10-31","2013-11-07","2013-11-13","2013-11-19"]
["2013-11-14","2013-11-21","2013-11-27","2013-12-03"]
["2013-11-28","2013-12-05","2013-12-11","2013-12-17"]
["2013-12-12","2013-12-19","2013-12-25","2013-12-31"]
["2013-12-26","2014-01-02","2014-01-08","2014-01-14"]
["2014-01-09","2014-01-16","2014-01-22","2014-01-28"]
["2014-01-23","2014-01-30","2014-02-05","2014-02-11"]
["2014-02-06","2014-02-13","2014-02-19","2014-02-25"]

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