{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Business Trip Budget"],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Business Trip Budget","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
[null,"Business Trip Budget"]
[null,"Target trip budget",null,{"v":2500,"d":"£2,500.00"},null,null,{"$f":"D3","v":{"v":2369.3599999999997,"d":"£2,369.36"}}]
[null,"Total cost of the trip",null,{"$f":"SUBTOTAL(9,Data[Amount])","v":{"v":2369.3599999999997,"d":"£2,369.36"}},null,null,{"$f":"D2","v":{"v":2500,"d":"£2,500.00"}}]
[null,{"$f":"IF(D2>D3,\"You're under budget by\",\"You're over budget by\")","v":"You're under budget by"},null,{"$f":"(D2-D3)","v":{"v":130.64000000000033,"d":"£130.64"}}]
[null,"Item","Description","Cost","Qty","Amount","Notes"]
[null,"Airfare","Tickets",{"v":300,"d":"£300.00"},1,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":300,"d":"£300.00"}}]
[null,"Airfare","Tickets",{"v":350,"d":"£350.00"},1,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":350,"d":"£350.00"}}]
[null,"Hotel","Room",{"v":125,"d":"£125.00"},3,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":375,"d":"£375.00"}}]
[null,"Hotel","Room",{"v":150,"d":"£150.00"},3,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":450,"d":"£450.00"}}]
[null,"Car rental","Cost per day",{"v":52,"d":"£52.00"},6,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":312,"d":"£312.00"}}]
[null,"Gas","Cost per gallon",{"v":1.74,"d":"£1.74"},14,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":24.36,"d":"£24.36"}}]
[null,"Entertainment","Amount",{"v":130,"d":"£130.00"},1,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":130,"d":"£130.00"}}]
[null,"Gifts","Amount",{"v":85,"d":"£85.00"},1,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":85,"d":"£85.00"}}]
[null,"Miscellaneous","Amount",{"v":55,"d":"£55.00"},1,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":55,"d":"£55.00"}}]
[null,"Food","Cost per day",{"v":48,"d":"£48.00"},6,{"$f":"Data[[#This Row],[Qty]]*Data[[#This Row],[Cost]]","v":{"v":288,"d":"£288.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Data[Amount])","v":{"v":2369.3599999999997,"d":"£2,369.36"}}]