{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Automotive Repair Tracker"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Automotive Repair Tracker","index":0,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"AUTOMOTIVE REPAIR TRACKER"]
[null,"GRAND TOTAL",{"$f":"IFERROR(SUM(Repairs[AMOUNT]), \"\")","v":{"v":4751.509999999999,"d":"£4,751.51"}}]
[null,"VEHICLE 1 TOTAL",{"$f":"IFERROR(SUMIFS(Repairs[AMOUNT],Repairs[VEHICLE],Vehicle_1_Name), \"\")","v":{"v":4032.11,"d":"£4,032.11"}},{"$f":"Vehicle_1_Name& \" VALUE\"","v":"VEHICLE 1 VALUE"},{"v":14000,"d":"£14,000.00"},{"$f":"Vehicle_1_Name","v":"VEHICLE 1"}]
[null,"VEHICLE 2 TOTAL",{"$f":"IFERROR(SUMIFS(Repairs[AMOUNT],Repairs[VEHICLE],Vehicle_2_Name), \"\")","v":{"v":719.4,"d":"£719.40"}},{"$f":"Vehicle_2_Name& \" VALUE\"","v":"VEHICLE 2 VALUE"},{"v":7000,"d":"£7,000.00"},{"$f":"Vehicle_2_Name","v":"VEHICLE 2"}]
[null,"DATE","AMOUNT","VEHICLE","WHERE","DESCRIPTION"]
[null,{"$f":"TODAY()-800","v":"2016-04-20"},{"v":632.11,"d":"£632.11"},"VEHICLE 1","Dealership","Replaced radiator"]
[null,{"$f":"TODAY()-270","v":"2017-10-02"},{"v":389.87,"d":"£389.87"},"VEHICLE 2","Tyre Shop","4 new tyres"]
[null,{"$f":"TODAY()-400","v":"2017-05-25"},{"v":3400,"d":"£3,400.00"},"VEHICLE 1","Body Shop","Collision repair"]
[null,{"$f":"TODAY()-90","v":"2018-03-31"},{"v":89.99,"d":"£89.99"},"VEHICLE 2","Tyre Shop","Fixed Alignment"]
[null,{"$f":"TODAY()","v":"2018-06-29"},{"v":239.54,"d":"£239.54"},"VEHICLE 2","Dealership","100,000 mile inspection and tune-up"]