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

{"sheet":"Business Trip Budget","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[0,0,2,3],[3,0,4,0],[3,1,4,1]]}
["Business Trip Budget"]
[]
[]
["Target trip budget",{"v":1900,"d":"$1,900.00"}]
[{"$nulls":6},"      Total  "]
["Airfare","Total cost of tickets",{"v":200,"d":"$200.00"},"for",1,"ticket(s)",{"$f":"(C6*E6)","v":{"v":200,"d":"$200.00"}}]
[null,"\"",{"v":275,"d":"$275.00"},"for",1,"ticket(s)",{"$f":"(C7*E7)","v":{"v":275,"d":"$275.00"}}]
[null,"\"",0,"for",0,"ticket(s)",0]
["Hotel","Cost per night",{"v":75,"d":"$75.00"},"for",3,"night(s)",{"v":225,"d":"$225.00"}]
[null,"\"",{"v":82,"d":"$82.00"},"for",3,"night(s)",{"v":246,"d":"$246.00"}]
[null,"\"",0,"for",0,"night(s)",0]
["Food","Cost per day",{"v":48,"d":"$48.00"},"for",6,"day(s)",{"v":288,"d":"$288.00"}]
["Car rental","Cost per day",{"v":52,"d":"$52.00"},"for",6,"day(s)",{"v":312,"d":"$312.00"}]
["Gas","Cost per gallon",{"v":1.74,"d":"$1.74"},"for",14,"gallons",{"v":24.36,"d":"$24.36"}]
["Entertainment","Amount",{"v":130,"d":"$130.00"},{"$nulls":3},{"$f":"(C15)","v":{"v":130,"d":"$130.00"}}]
["Gifts","Amount",{"v":85,"d":"$85.00"},{"$nulls":3},{"$f":"(C16)","v":{"v":85,"d":"$85.00"}}]
["Miscellaneous","Amount",{"v":55,"d":"$55.00"},{"$nulls":3},{"$f":"(C17)","v":{"v":55,"d":"$55.00"}}]
[{"$nulls":3},"Total cost of the trip",null,null,{"$f":"SUM(G6:G17)","v":{"v":1840.36,"d":"$1,840.36"}}]
[{"$nulls":3},{"$f":"IF(B4>G18,\"You're under budget by\",\"You're over budget by\")","v":"You're under budget by"},null,null,{"$f":"(B4-G18)","v":{"v":59.6400000000001,"d":"$59.64"}}]