{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["2007MitsubishiGalant_Summary","Home","My Garage","2007 Mitsubishi Galant","2003 Toyota Corolla","1998 Honda Civic","Summary Maintenance"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2007MitsubishiGalant_Summary","index":0,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Date","Sale","Price/Gal","Gallons","Odometer","Miles Per Gallon","Price Per Mile"]
["2011-11-21",46.53,3.21,12.23,67587,{"$f":"IFERROR((E2-E1)/D1,\"\")","v":""},{"$f":"IFERROR(C1/(E2-E1),\"\")","v":""},null,null,null,null,null,"View the Blog"]
["2011-11-29",47.12,3.19,12.39,67871,{"$f":"IFERROR((E3-E2)/D2,\"\")","v":23.221586263286998},{"$f":"IFERROR(C2/(E3-E2),\"\")","v":1.130281690140845E-2}]
["2011-12-04",41.79,3.11,11.34,68059,15.173527037933816,1.696808510638298E-2]
["2011-12-13",46.38,3.16,12.38,68304,21.60493827160494,1.2693877551020407E-2]
["2011-12-14",48.99,3.08,12.66,68601,23.990306946688204,1.063973063973064E-2]
["2011-11-15",47.65,3.12,12.2,68867,21.011058451816744,1.1578947368421053E-2]
["2011-12-16",49.01,3.04,12.77,69031,13.442622950819674,1.9024390243902439E-2]
["2011-12-17",49.98,3.02,12.98,69291,20.360219263899765,1.1692307692307693E-2]
["2011-12-18",46.42,3.01,11.75,69526,18.104776579352851,1.2851063829787235E-2]
["2011-12-20",40.340000000000003,3.01,10.34,69800,23.319148936170212,1.0985401459854013E-2]
[]
[null,null,null,null,"Average",{"$f":"ROUND(AVERAGE(F2:F11),2)","v":20.03},{"$f":"ROUND(AVERAGE(G2:G11),2)","v":0.01}]

{"sheet":"Home","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"My Garage","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Year","Make","Model","Combined","Oil Change Basis","Frequency","Tire Replacement","Tire Rotation","Tag Renewal","Current Odometer"]
[2007,"Mitsubishi","Galant","2007 Mitsubishi Galant","Miles",2000,40000,12000,"2011-08-01",{"$f":"MAX(Table6[[#All],[Odometer]])","v":69800}]
[2003,"Toyota","Corolla","2003 Toyota Corolla","Miles",4500,50000,15000,"2011-04-01",{"$f":"MAX(Table5[[#All],[Odometer]])","v":81620}]
[1998,"Honda","Civic","1998 Honda Civic","Miles",3500,42000,12000,"2010-12-01",{"$f":"MAX(Table7[[#All],[Odometer]])","v":105776}]
[null,null,null,{"$f":"CONCATENATE(A5,\" \",B5,\" \",C5)","v":"  "}]
[]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]
[null,null,null,"  "]

{"sheet":"2007 Mitsubishi Galant","index":3,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,11,0,13],[0,17,0,18]]}
["Date","Sale","Price/Gal","Gallons","Odometer","Grade","Column1",null,null,null,null,"Maintenance",null,null,null,null,null,"Last Maintenance"]
["2011-11-21",46.53,3.21,12.23,67587,85,null,null,null,null,null,"Date","Type","Location","Amount","Odometer",null,"Oil Change",{"$f":"VLOOKUP(MAX(Table1[[#All],[Date]]),Table1[#All],5,FALSE)","v":65500},"2011-11-04",{"$f":"IF(MAX(Table6[[#All],[Odometer]])>(LastOilChange+GarageTable[[#This Row],[Frequency]]),\"yes\",\"no\")","v":"yes"}]
["2011-11-29",47.12,3.19,12.39,67871,85,null,null,null,null,null,"2011-11-02","Oil Change","Jiffy lube",31.25,63500,null,"Tire Rotation",{"$f":"P6","v":65200}]
["2011-12-04",41.79,3.11,11.34,68059,85,null,null,null,null,null,"2011-11-04","Tire Rotation","Discount",10,63750,null,"Tire Replacement",{"$f":"P8","v":35000}]
["2011-12-13",46.38,3.16,12.38,68304,85,null,null,null,null,null,"2011-11-06","Oil Change","Walmart",35,64700]
["2011-12-14",48.99,3.08,12.66,68601,85,85,null,null,null,null,"2011-11-15","Tire Rotation","Discount",10,65200]
["2011-11-15",47.65,3.12,12.2,68867,85,0,null,null,null,null,"2011-11-16","Oil Change","Jiffy",25,65500]
["2011-12-16",49.01,3.04,12.77,69031,85,0,null,null,null,null,"2010-10-04","Tire Replacement","Discount Tire",750,35000]
["2011-12-17",49.98,3.02,12.98,69291,85,0]
["2011-12-18",46.42,3.01,11.75,69526,85,0]
["2011-12-20",40.340000000000003,3.01,10.34,69800,87,2]

{"sheet":"2003 Toyota Corolla","index":4,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,11,0,15],[0,17,0,18]]}
["Date","Sale","Price/Gal","Gallons","Odometer","Grade","Column1",null,null,null,null,"Maintenance",null,null,null,null,null,"Last Maintenance"]
["2011-11-22",36.35,3.14,10.78,78987,87,null,null,null,null,null,"Date","Type","Location","Amount","Odometer",null,"Oil Change",{"$f":"P7","v":77200}]
["2011-11-28",38.71,3.1,11.23,79269,87,null,null,null,null,null,"2011-11-30","New Head Gasket","Clegg's Auto",1845.34,65789,null,"Tire Rotation",{"$f":"P5","v":52000}]
["2011-12-02",37.29,3.1,10.67,79550,87,0,null,null,null,null,"2011-11-07","Oil Change","Jiffy",25,72430,null,"Tire Replacement",{"$f":"P6","v":25000}]
["2011-12-05",36.31,3.02,10.8,79809,87,0,null,null,null,null,"2011-09-05","Tire Rotation","Discount",20,52000]
["2011-11-02",36.67,3.03,10.119999999999999,80047,87,0,null,null,null,null,"2011-09-05","Tire Replacement","Discount",800,25000]
["2011-12-07",35.47,2.98,9.98,80311,87,0,null,null,null,null,"2011-09-05","Oil Change","Walmart",30,77200]
["2011-12-09",36.659999999999997,3.01,10.56,80596,87,0]
["2011-12-12",34.33,2.99,9.67,80765,87,0]
["2011-12-13",38.9,3.1,10.89,81034,87,0]
["2011-12-16",40.340000000000003,3.01,10.1,81322,87,0]
["2011-11-02",33.11,2.96,8.1300000000000008,81620,87]
[null,null,null,null,null,null,0]

{"sheet":"1998 Honda Civic","index":5,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,11,0,15],[0,17,0,18]]}
["Date","Sale","Price/Gal","Gallons","Odometer","Grade","Column1",null,null,null,null,"Maintenance",null,null,null,null,null,"Last Maintenance"]
["2011-11-23",37.840000000000003,3.16,10.210000000000001,103124,85,null,null,null,null,null,"Date","Type","Location","Amount","Odometer",null,"Oil Change",{"$f":"P4","v":101100}]
["2011-11-25",41.22,3.19,11.21,103567,85,0,null,null,null,null,"2011-09-05","Oil Change","Walmart",30,98200,null,"Tire Rotation",{"$f":"P5","v":100000}]
["2011-11-30",40.78,3.12,10.98,104100,85,0,null,null,null,null,"2011-10-19","Oil Change","Walmart",30,101100,null,"Tire Replacement",{"$f":"P6","v":75000}]
["2011-12-02",37.11,3.06,9.8000000000000007,104420,85,0,null,null,null,null,"2011-07-12","Tire Rotation","Discount",30,100000]
["2011-12-05",38.54,3.24,10.199999999999999,104876,85,0,null,null,null,null,"2011-01-11","Tire Replacement","Discount",600,75000]
["2011-12-08",36.78,3.01,10.23,105032,87,2]
["2011-12-12",36.78,3.02,10.210000000000001,105303,87,0]
["2011-12-15",38.76,3.06,10.23,105583,87,0]
["2011-12-17",34.43,2.96,9.08,105776,87,0]

{"sheet":"Summary Maintenance","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Vehicle","Current Odometer","Oil Change Due","OIL CHANGE","Tire Rotation Due","TIRE ROTATION","Tire Replacement Due","TIRE REPLACEMENT","Tag Renewal Due","TAG RENEWAL"]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":"2007 Mitsubishi Galant"},{"$f":"MAX(Table6[[#All],[Odometer]])","v":69800},{"$f":"LastOilChange+GarageTable[[#This Row],[Frequency]]","v":67500},{"$f":"IF(B2>C2,\"yes\",\"no\")","v":"yes"},{"$f":"LastRotation+GarageTable[[#This Row],[Tire Replacement]]","v":105200},{"$f":"IF(B2>E2,\"yes\",\"no\")","v":"no"},{"$f":"LastReplacement+GarageTable[[#This Row],[Tire Replacement]]","v":75000},{"$f":"IF(B2>G2,\"yes\",\"no\")","v":"no"},{"$f":"GarageTable[[#This Row],[Tag Renewal]]+365","v":"2012-07-31"},{"$f":"IF(TODAY()>I2,\"yes\",\"no\")","v":"no"}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":"2003 Toyota Corolla"},{"$f":"MAX(Table5[[#All],[Odometer]])","v":81620},{"$f":"'2003 Toyota Corolla'!S2+GarageTable[[#This Row],[Frequency]]","v":81700},{"$f":"IF(B3>C3,\"yes\",\"no\")","v":"no"},{"$f":"'2003 Toyota Corolla'!S3+GarageTable[[#This Row],[Tire Rotation]]","v":67000},{"$f":"IF(B3>E3,\"yes\",\"no\")","v":"yes"},{"$f":"'2003 Toyota Corolla'!S4+GarageTable[[#This Row],[Tire Replacement]]","v":75000},{"$f":"IF(B3>G3,\"yes\",\"no\")","v":"yes"},{"$f":"GarageTable[[#This Row],[Tag Renewal]]+365","v":"2012-03-31"},{"$f":"IF(TODAY()>I3,\"yes\",\"no\")","v":"no"}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":"1998 Honda Civic"},{"$f":"MAX(Table7[[#All],[Odometer]])","v":105776},{"$f":"'1998 Honda Civic'!S2+GarageTable[[#This Row],[Frequency]]","v":104600},{"$f":"IF(B4>C4,\"yes\",\"no\")","v":"yes"},{"$f":"'1998 Honda Civic'!S3+GarageTable[[#This Row],[Tire Rotation]]","v":112000},{"$f":"IF(B4>E4,\"yes\",\"no\")","v":"no"},{"$f":"'1998 Honda Civic'!S4+GarageTable[[#This Row],[Tire Replacement]]","v":117000},{"$f":"IF(B4>G4,\"yes\",\"no\")","v":"no"},{"$f":"GarageTable[[#This Row],[Tag Renewal]]+365","v":"2011-12-01"},{"$f":"IF(TODAY()>I4,\"yes\",\"no\")","v":"yes"}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]
[{"$f":"IFERROR(GarageTable[[#This Row],[Combined]],\"\")","v":""}]