{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Travel expense calculator"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Travel expense calculator","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[0,1,0,8],[2,1,2,2],[2,7,2,8],[8,2,8,4],[8,5,8,6]]}
[null,"Travel expense calculator"]
[]
[null,"Enter estimated cost per mile",{"$nulls":5},"Total travel cost"]
[null,"$ per mile",{"v":0.5,"d":"£0.50"},{"$nulls":4},"Total travel period",{"$f":"(F31&\"-days\"&\"/\"&G31&\"-nights\")","v":"2-days/2-nights"}]
[{"$nulls":7},"Total costs per mile",{"$f":"C4*E31","v":{"v":71,"d":"£71.00"}}]
[{"$nulls":7},"Total lodging",{"$f":"H31","v":{"v":275,"d":"£275.00"}}]
[{"$nulls":7},"Total additional expenses",{"$f":"I31","v":{"v":125,"d":"£125.00"}}]
[]
[null,"Date","Location and distance",null,null,"Travel period",null,"Room and board"]
[null,"Travel Date","From","To","Distance (miles)","Day(s)","Night(s)","Lodging","Additional expenses"]
[null,"2021-12-01","Seattle, WA","Bellingham, WA",89,1,1,{"v":150,"d":"150.00"},{"v":75,"d":"75.00"}]
[null,"2021-12-02","Bellingham, WA","Vancouver, BC",53,1,1,{"v":125,"d":"125.00"},{"v":50,"d":"50.00"}]
{"$rows_empty":18}
[null,"Totals",null,null,{"$f":"SUBTOTAL(109,tblExpense[Distance (miles)])","v":142},{"$f":"SUBTOTAL(109,tblExpense[Day(s)])","v":2},{"$f":"SUBTOTAL(109,tblExpense[Night(s)])","v":2},{"$f":"SUBTOTAL(109,tblExpense[Lodging])","v":{"v":275,"d":"£275.00"}},{"$f":"SUBTOTAL(109,tblExpense[Additional expenses])","v":{"v":125,"d":"£125.00"}}]