{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":70,"n_cols":9,"rows_kept":70,"merged":[[1,1,1,8]]}
[]
[null,"<Vehicle> Lease Mileage Tracker"]
[]
[null,null,"Mileage Allowed Per Year:",{"v":15000,"d":"15,000"},null,null,"Lease Start Date:","2008-01-14"]
[]
[null,null,"Mileage Allowed Per Month:",{"$f":"D4/12","v":{"v":1250,"d":"1,250"}},null,null,"Number of Lease Periods:",36]
[]
[null,null,"Total Mileage Allowed:",{"$f":"D6*H6","v":{"v":45000,"d":"45,000"}},null,null,"Lease End Date:",{"$f":"DATE(YEAR(H4),MONTH(H4)+H6,DAY(H4))","v":"2011-01-14"}]
[]
[null,"Period","Odometer Reading Date","Odometer Reading","Monthly Allowance","Miles Used During Month","Monthly Difference","Total Allowance","Total Difference"]
[null,1,{"$f":"IF((DATE(YEAR($H$4),MONTH($H$4)+B11,DAY($H$4)))<=$H$8,(DATE(YEAR($H$4),MONTH($H$4)+B11,DAY($H$4))),\"\")","v":"2008-02-14"},{"v":1000,"d":"1,000"},{"$f":"IF(B11<=$H$6,$D$6,\"\")","v":{"v":1250,"d":"1,250"}},{"$f":"IF(ISBLANK(D11),\"\",D11)","v":{"v":1000,"d":"1,000"}},{"$f":"IF(ISBLANK(D11),\"\",(F11-E11))","v":{"v":-250,"d":"(250)"}},{"$f":"IF(B11<=$H$6,B11*$D$6,\"\")","v":{"v":1250,"d":"1,250"}},{"$f":"IF(ISBLANK(D11),\"\",(D11-H11))","v":{"v":-250,"d":"(250)"}}]
[null,2,{"$f":"IF((DATE(YEAR($H$4),MONTH($H$4)+B12,DAY($H$4)))<=$H$8,(DATE(YEAR($H$4),MONTH($H$4)+B12,DAY($H$4))),\"\")","v":"2008-03-14"},{"v":2200,"d":"2,200"},{"$f":"IF(B12<=$H$6,$D$6,\"\")","v":{"v":1250,"d":"1,250"}},{"$f":"IF(ISBLANK(D12),\"\",(D12-D11))","v":{"v":1200,"d":"1,200"}},{"$f":"IF(ISBLANK(D12),\"\",(F12-E12))","v":{"v":-50,"d":"(50)"}},{"$f":"IF(B12<=$H$6,B12*$D$6,\"\")","v":{"v":2500,"d":"2,500"}},{"$f":"IF(ISBLANK(D12),\"\",(D12-H12))","v":{"v":-300,"d":"(300)"}}]
[null,3,"2008-04-14",{"v":3100,"d":"3,100"},{"v":1250,"d":"1,250"},{"$f":"IF(ISBLANK(D13),\"\",(D13-D12))","v":900},{"v":-350,"d":"(350)"},{"v":3750,"d":"3,750"},{"v":-650,"d":"(650)"}]
[null,4,"2008-05-14",{"v":4300,"d":"4,300"},{"v":1250,"d":"1,250"},{"v":1200,"d":"1,200"},{"v":-50,"d":"(50)"},{"v":5000,"d":"5,000"},{"v":-700,"d":"(700)"}]
[null,5,"2008-06-14",{"v":5600,"d":"5,600"},{"v":1250,"d":"1,250"},{"v":1300,"d":"1,300"},50,{"v":6250,"d":"6,250"},{"v":-650,"d":"(650)"}]
[null,6,"2008-07-14",{"v":6600,"d":"6,600"},{"v":1250,"d":"1,250"},{"v":1000,"d":"1,000"},{"v":-250,"d":"(250)"},{"v":7500,"d":"7,500"},{"v":-900,"d":"(900)"}]
[null,7,"2008-08-14",{"v":7650,"d":"7,650"},{"v":1250,"d":"1,250"},{"v":1050,"d":"1,050"},{"v":-200,"d":"(200)"},{"v":8750,"d":"8,750"},{"v":-1100,"d":"(1,100)"}]
[null,8,"2008-09-14",{"v":8500,"d":"8,500"},{"v":1250,"d":"1,250"},850,{"v":-400,"d":"(400)"},{"v":10000,"d":"10,000"},{"v":-1500,"d":"(1,500)"}]
[null,9,"2008-10-14",{"v":10005,"d":"10,005"},{"v":1250,"d":"1,250"},{"v":1505,"d":"1,505"},255,{"v":11250,"d":"11,250"},{"v":-1245,"d":"(1,245)"}]
[null,10,"2008-11-14",{"v":11080,"d":"11,080"},{"v":1250,"d":"1,250"},{"v":1075,"d":"1,075"},{"v":-175,"d":"(175)"},{"v":12500,"d":"12,500"},{"v":-1420,"d":"(1,420)"}]
[null,11,"2008-12-14",{"v":12200,"d":"12,200"},{"v":1250,"d":"1,250"},{"v":1120,"d":"1,120"},{"v":-130,"d":"(130)"},{"v":13750,"d":"13,750"},{"v":-1550,"d":"(1,550)"}]
[null,12,"2009-01-14",{"v":13200,"d":"13,200"},{"v":1250,"d":"1,250"},{"v":1000,"d":"1,000"},{"v":-250,"d":"(250)"},{"v":15000,"d":"15,000"},{"v":-1800,"d":"(1,800)"}]
[null,13,"2009-02-14",{"v":14525,"d":"14,525"},{"v":1250,"d":"1,250"},{"v":1325,"d":"1,325"},75,{"v":16250,"d":"16,250"},{"v":-1725,"d":"(1,725)"}]
[null,14,"2009-03-14",{"v":16010,"d":"16,010"},{"v":1250,"d":"1,250"},{"v":1485,"d":"1,485"},235,{"v":17500,"d":"17,500"},{"v":-1490,"d":"(1,490)"}]
[null,15,"2009-04-14",{"v":17495,"d":"17,495"},{"v":1250,"d":"1,250"},{"v":1485,"d":"1,485"},235,{"v":18750,"d":"18,750"},{"v":-1255,"d":"(1,255)"}]
[null,16,"2009-05-14",{"v":18982,"d":"18,982"},{"v":1250,"d":"1,250"},{"v":1487,"d":"1,487"},237,{"v":20000,"d":"20,000"},{"v":-1018,"d":"(1,018)"}]
[null,17,"2009-06-14",{"v":20141,"d":"20,141"},{"v":1250,"d":"1,250"},{"v":1159,"d":"1,159"},{"v":-91,"d":"(91)"},{"v":21250,"d":"21,250"},{"v":-1109,"d":"(1,109)"}]
[null,18,"2009-07-14",{"v":21300,"d":"21,300"},{"v":1250,"d":"1,250"},{"v":1159,"d":"1,159"},{"v":-91,"d":"(91)"},{"v":22500,"d":"22,500"},{"v":-1200,"d":"(1,200)"}]
[null,19,"2009-08-14",{"v":22500,"d":"22,500"},{"v":1250,"d":"1,250"},{"v":1200,"d":"1,200"},{"v":-50,"d":"(50)"},{"v":23750,"d":"23,750"},{"v":-1250,"d":"(1,250)"}]
[null,20,"2009-09-14",{"v":23600,"d":"23,600"},{"v":1250,"d":"1,250"},{"v":1100,"d":"1,100"},{"v":-150,"d":"(150)"},{"v":25000,"d":"25,000"},{"v":-1400,"d":"(1,400)"}]
[null,21,"2009-10-14",null,{"v":1250,"d":"1,250"},"","",{"v":26250,"d":"26,250"},""]
[null,22,"2009-11-14",null,{"v":1250,"d":"1,250"},"","",{"v":27500,"d":"27,500"},""]
[null,23,"2009-12-14",null,{"v":1250,"d":"1,250"},"","",{"v":28750,"d":"28,750"},""]
[null,24,"2010-01-14",null,{"v":1250,"d":"1,250"},"","",{"v":30000,"d":"30,000"},""]
[null,25,"2010-02-14",null,{"v":1250,"d":"1,250"},"","",{"v":31250,"d":"31,250"},""]
[null,26,"2010-03-14",null,{"v":1250,"d":"1,250"},"","",{"v":32500,"d":"32,500"},""]
[null,27,"2010-04-14",null,{"v":1250,"d":"1,250"},"","",{"v":33750,"d":"33,750"},""]
[null,28,"2010-05-14",null,{"v":1250,"d":"1,250"},"","",{"v":35000,"d":"35,000"},""]
[null,29,"2010-06-14",null,{"v":1250,"d":"1,250"},"","",{"v":36250,"d":"36,250"},""]
[null,30,"2010-07-14",null,{"v":1250,"d":"1,250"},"","",{"v":37500,"d":"37,500"},""]
[null,31,"2010-08-14",null,{"v":1250,"d":"1,250"},"","",{"v":38750,"d":"38,750"},""]
[null,32,"2010-09-14",null,{"v":1250,"d":"1,250"},"","",{"v":40000,"d":"40,000"},""]
[null,33,"2010-10-14",null,{"v":1250,"d":"1,250"},"","",{"v":41250,"d":"41,250"},""]
[null,34,"2010-11-14",null,{"v":1250,"d":"1,250"},"","",{"v":42500,"d":"42,500"},""]
[null,35,"2010-12-14",null,{"v":1250,"d":"1,250"},"","",{"v":43750,"d":"43,750"},""]
[null,36,"2011-01-14",null,{"v":1250,"d":"1,250"},"","",{"v":45000,"d":"45,000"},""]
[null,37,"",null,"","","","",""]
[null,38,"",null,"","","","",""]
[null,39,"",null,"","","","",""]
[null,40,"",null,"","","","",""]
[null,41,"",null,"","","","",""]
[null,42,"",null,"","","","",""]
[null,43,"",null,"","","","",""]
[null,44,"",null,"","","","",""]
[null,45,"",null,"","","","",""]
[null,46,"",null,"","","","",""]
[null,47,"",null,"","","","",""]
[null,48,"",null,"","","","",""]
[null,49,"",null,"","","","",""]
[null,50,"",null,"","","","",""]
[null,51,"",null,"","","","",""]
[null,52,"",null,"","","","",""]
[null,53,"",null,"","","","",""]
[null,54,"",null,"","","","",""]
[null,55,"",null,"","","","",""]
[null,56,"",null,"","","","",""]
[null,57,"",null,"","","","",""]
[null,58,"",null,"","","","",""]
[null,59,"",null,"","","","",""]
[null,60,"",null,"","","","",""]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}