{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Auto Expense Report"],"not_rendered":{"defined_names":22,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Auto Expense Report","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"merged":[[39,1,39,12]]}
[]
[]
[null,"Your Company, Inc.",{"$nulls":10},"Auto Expense Report "]
[null,"Address"]
[null,"Address"]
[null,"City, State ZIP"]
[{"$nulls":10},"ENDING DATE:",null,"2010-08-18"]
[]
[{"$nulls":9},"EMPLOYEE  "]
[{"$nulls":9},"SALES OFFICE  "]
[{"$nulls":9},"ADDRESS  "]
[null,"Reimbursement Rate ",null,null,{"v":0.57,"d":"$0.57"},{"$nulls":4},"CITY  "]
[{"$nulls":9},"STATE  "]
[{"$nulls":12},"ZIP"]
[null,"TERRITORY NO.",null,"BRANCH/REGION OR ZONE",{"$nulls":3},"PRODUCT LINE/SALES GROUP",null,null,"COMPANY CHARGE CARD NO."]
[]
[]
[null,null,"ODOMETER",null,null,"REIMBURSED",{"$nulls":3},"PAYMENT METHOD"]
[null,null,"READING",null,null,{"$f":"\"@ \"&IF(MILEAGE_RATE,FIXED(MILEAGE_RATE*100,0,TRUE),\"___\")&\" CENTS\"","v":"@ 57 CENTS"},"GAS &","PARKING/","REPAIR","COMPANY ","EMPLOYEE",null,"DAILY"]
[null,"DATE","START","STOP","MILEAGE","PER MILE","OIL","TOLLS","MAINT","CHARGE","CHARGE","CASH","TOTALS"]
[null,{"$f":"IF(SUM(B22),B22-1,\"\")","v":"2010-08-12"},{"v":13775,"d":"13775.0"},{"v":13781,"d":"13781.0"},{"$f":"IF(D21,D21-C21,\"\")","v":{"v":6,"d":"6.0"}},{"$f":"IF(SUM(E21),ROUND(E21*E12,2),\"\")","v":{"v":3.42,"d":"$3.42"}},{"v":18,"d":"$18.00"},{"v":4.5,"d":"$4.50"},{"v":16,"d":"$16.00"},{"v":16,"d":"$16.00"},{"v":18,"d":"$18.00"},{"$f":"IF(SUM(F21:I21),M21-K21-J21,\"\")","v":{"v":7.920000000000002,"d":"$7.92"}},{"$f":"IF(SUM(F21:I21),SUM(F21:I21),\"\")","v":{"v":41.92,"d":"$41.92"}}]
[null,"2010-08-13",{"$f":"IF(SUM(D21),D21,IF(C21,C21,\"\"))","v":{"v":13781,"d":"13781.0"}},{"v":13804,"d":"13804.0"},{"v":23,"d":"23.0"},{"v":0,"d":"$0.00"},{"$nulls":5},"",""]
[null,"2010-08-14",{"$f":"IF(SUM(D22),D22,IF(SUM(C22),C22,\"\"))","v":{"v":13804,"d":"13804.0"}},null,"","",null,8.5,28,null,null,36.5,36.5]
[null,"2010-08-15",{"$f":"IF(SUM(D23),D23,IF(SUM(C23),C23,\"\"))","v":{"v":13804,"d":"13804.0"}},{"v":13877,"d":"13877.0"},{"v":73,"d":"73.0"},{"v":0,"d":"$0.00"},5,7,{"$nulls":3},12,12]
[null,"2010-08-16",{"$f":"IF(SUM(D24),D24,IF(SUM(C24),C24,\"\"))","v":{"v":13877,"d":"13877.0"}},null,"","",null,null,352,352,null,0,352]
[null,"2010-08-17",{"$f":"IF(SUM(D25),D25,IF(SUM(C25),C25,\"\"))","v":{"v":13877,"d":"13877.0"}},{"v":14210,"d":"14210.0"},{"v":333,"d":"333.0"},{"v":0,"d":"$0.00"},12,{"$nulls":4},12,12]
[null,{"$f":"IF(M7,M7,\"\")","v":"2010-08-18"},{"$f":"IF(SUM(D26),D26,IF(SUM(C26),C26,\"\"))","v":{"v":14210,"d":"14210.0"}},{"v":14310,"d":"14310.0"},{"v":100,"d":"100.0"},{"$f":"IF(SUM(E27),ROUND(E27*E12,2),\"\")","v":57},{"$nulls":5},57,57]
[{"$nulls":3},"TOTALS ",{"$f":"IF(SUM(E21:E27),SUM(E21:E27),\"\")","v":{"v":535,"d":"535.0"}},{"v":60.42,"d":"$60.42"},{"v":35,"d":"$35.00"},{"v":20,"d":"$20.00"},{"v":396,"d":"$396.00"},{"v":368,"d":"$368.00"},{"v":18,"d":"$18.00"},{"v":125.42,"d":"$125.42"},{"v":511.42,"d":"$511.42"}]
[]
[null,"SIGNATURES"]
[{"$nulls":9},"SUMMARY OF AUTO EXPENSES"]
[{"$nulls":9}," LESS CASH ADVANCE",null,null,{"v":200,"d":"$200.00"}]
[null,"PREPARER   /  TITLE",{"$nulls":4},"DATE",null,null," LESS CHARGES TO COMPANY",null,null,{"$f":"J28","v":{"v":368,"d":"$368.00"}}]
[{"$nulls":9}," BALANCE DUE COMPANY ",null,null,{"$f":"IF(SUM(M28),MAX(M32+M33-M28,0),\"\")","v":{"v":56.579999999999984,"d":"$56.58"}}]
[{"$nulls":9}," BALANCE DUE EMPLOYEE",null,null,{"$f":"IF(SUM(M28),MAX(-M32+L28+K28,0),\"\")","v":{"v":0,"d":"$0.00"}}]
[null,"APPROVED BY  /  TITLE",{"$nulls":4},"DATE"]