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

{"sheet":"Expense Report","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,2,3,3],[3,5,3,6],[3,9,3,10],[4,2,4,3],[4,5,4,6],[4,9,4,10],[5,2,5,3],[5,5,5,6],[5,9,5,10],[6,2,6,3],[6,5,6,6],[6,9,6,10],[7,9,7,10]]}
[null,"EXPENSE REPORT"]
[null,"CONTOSO, LTD"]
[null,"123 South Main Street, North Buffalo, NY 12345"]
[null,"PHONE",4255550121,null,"NAME","Kim Abercrombie",null,null,"PURPOSE","Annual Sales Seminar",null,"MILEAGE RATE",{"v":0.5,"d":"$0.50/mile"}]
[null,"FAX",4255550122,null,"DEPARTMENT","Sales",null,null,"BEGINNING",{"$f":"IFERROR(MIN(Expenses[DATE]),\"\")","v":"2019-07-07"},null,"MEAL RATE",{"v":30,"d":"$30.00/day"}]
[null,"EMAIL","info@contoso.com",null,"POSITION","Managing Director",null,null,"ENDING",{"$f":"IFERROR(MAX(Expenses[DATE]),\"\")","v":"2019-08-06"},null,"HOTEL RATE",{"v":200,"d":"$200.00/night"}]
[null,"WEB","www.contoso.com",null,"MANAGER","Michael Tucker",null,null,"PREPARED BY","Kim Abercrombie",null,"PHONE RATE",{"v":10,"d":"$10.00/day"}]
[{"$nulls":8},"APPROVED BY","Michael Tucker",null,"MISC. RATE",{"v":50,"d":"$50.00/day"}]
[]
[null,"DATE","ACCOUNT","DESCRIPTION","HOTEL","TRANSPORT","MEALS","PHONE","MISC.","ODOMETER \nSTART","ODOMETER \nEND","MILEAGE \nTOTAL","TOTAL "]
[null,{"$f":"TODAY()","v":"2019-07-07"},"Sales","Mileage",{"$nulls":4},{"v":50,"d":"$50.00"},{"v":11378.5,"d":"11,378.5 mi."},{"v":11456.2,"d":"11,456.2 mi."},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":{"v":38.850000000000364,"d":"$38.85"}},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":{"v":88.85000000000036,"d":"$88.85"}}]
[null,{"$f":"TODAY()+30","v":"2019-08-06"},"Sales","Convention",{"v":445,"d":"$445.00"},{"v":225,"d":"$225.00"},{"v":20,"d":"$20.00"},null,{"v":5,"d":"$5.00"},{"v":11500,"d":"11,500.0 mi."},{"v":11560,"d":"11,560.0 mi."},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":{"v":30,"d":"$30.00"}},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":{"v":725,"d":"$725.00"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Expenses[[#This Row],[ODOMETER \nSTART]:[ODOMETER \nEND]])=2,(Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Expenses[[#This Row],[DATE]:[ODOMETER \nEND]])=0,\"\",SUM(Expenses[[#This Row],[HOTEL]:[TRANSPORT]],Expenses[[#This Row],[MEALS]:[MISC.]],((Expenses[[#This Row],[ODOMETER \nEND]]-Expenses[[#This Row],[ODOMETER \nSTART]])*(MileageRate))))","v":""}]
[null,"TOTALS",null,null,{"$f":"SUBTOTAL(109,Expenses[HOTEL])","v":{"v":445,"d":"$445.00"}},{"$f":"SUBTOTAL(109,Expenses[TRANSPORT])","v":{"v":225,"d":"$225.00"}},{"$f":"SUBTOTAL(109,Expenses[MEALS])","v":{"v":20,"d":"$20.00"}},{"$f":"SUBTOTAL(109,Expenses[PHONE])","v":0},{"$f":"SUBTOTAL(109,Expenses[MISC.])","v":{"v":55,"d":"$55.00"}},{"$nulls":3},{"$f":"SUBTOTAL(109,Expenses[[TOTAL ]])","v":{"v":813.8500000000004,"d":"$813.85"}}]
[{"$nulls":11},"ADVANCES",{"v":0,"d":"$0.00"}]
[{"$nulls":11},"TOTAL",{"$f":"Expenses[[#Totals],[TOTAL ]]-Advances","v":{"v":813.8500000000004,"d":"$813.85"}}]