{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Equipment List","Pivot Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":1},"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":"Dashboard","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Dashboard"]
[]
[]
[null,null,null,null,null,"Total Count"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Count\",'Pivot Data'!$B$11)","v":3}]
[]
[null,null,null,null,null,"Total Monthly Cost"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Total Monthly Cost\",'Pivot Data'!$B$11)","v":1765.5943035068672}]
[]
[null,null,null,null,null,"Operating Costs"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Operating Costs\",'Pivot Data'!$B$11)","v":605}]
[]
[null,null,null,null,null,"Monthly Depreciation"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Monthly Depreciation\",'Pivot Data'!$B$11)","v":659.72222222222217}]
[]
[null,null,null,null,null,"Payment Amount"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Payment Amount\",'Pivot Data'!$B$11)","v":1160.5943035068672}]
[]
[null,null,null,null,null,"Current Value"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Current Value \",'Pivot Data'!$B$11)","v":22284.931506849316}]

{"sheet":"Equipment List","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Equipment List"]
[]
[null,null,null,"Highlight when monthly payments left are less than: ",20]
[]
[null,"Asset or\nSerial Number","Item Description\n(Make and Model)","Location","Condition","Vendor","Years of\nService Left ","Initial Value","Down Payment","Date Purchased\nor Leased","Loan Term\n(Years)","Loan Rate","Monthly\nOperating Costs","Expected Value at End of Contract","Monthly\nPayments Left","Monthly Payment","Total\nMonthly Cost","Annual Depreciation\n(Straight Line)","Monthly Depreciation\n(Straight Line)","Current Value"]
[null,123,"Make Model 1","Main branch","Good","Local",5,30000,5000,"2011-01-15",4,0.1,200,20000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Date Purchased\nor Leased]])+Equipment[[#This Row],[Loan Term\n(Years)]],MONTH(Equipment[[#This Row],[Date Purchased\nor Leased]])-1,DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Date Purchased\nor Leased]])+Equipment[[#This Row],[Loan Term\n(Years)]],MONTH(Equipment[[#This Row],[Date Purchased\nor Leased]]),DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))-1)=DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))),0)","v":2},{"$f":"IFERROR(-(Equipment[Initial Value]>0)*(Equipment[Initial Value]<>Equipment[Down Payment])*PMT(Equipment[Loan Rate]/MonthsInYear,Equipment[Loan Term\n(Years)]*MonthsInYear,Equipment[Initial Value]-Equipment[Down Payment]),0)","v":634.06458586867973},{"$f":"Equipment[[#This Row],[Monthly Payment]]+Equipment[Monthly\nOperating Costs]","v":834.06458586867973},{"$f":"IFERROR((Equipment[Initial Value]>0)*SLN(Equipment[Initial Value],Equipment[Expected Value at End of Contract],Equipment[Loan Term\n(Years)]),0)","v":2500},{"$f":"IFERROR(Equipment[Annual Depreciation\n(Straight Line)]/MonthsInYear,0)","v":208.33333333333334},{"$f":"IFERROR(Equipment[Initial Value]-(Equipment[Annual Depreciation\n(Straight Line)]*((TODAY()-Equipment[Date Purchased\nor Leased])/DaysInYear)),0)","v":20547.945205479453}]
[null,234,"Make Model 2","Main branch","Good","Local",4,12500,1500,"2011-03-10",3,7.7499999999999999E-2,120,3000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Date Purchased\nor Leased]])+Equipment[[#This Row],[Loan Term\n(Years)]],MONTH(Equipment[[#This Row],[Date Purchased\nor Leased]])-1,DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Date Purchased\nor Leased]])+Equipment[[#This Row],[Loan Term\n(Years)]],MONTH(Equipment[[#This Row],[Date Purchased\nor Leased]]),DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))-1)=DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))),0)","v":0},{"$f":"IFERROR(-(Equipment[Initial Value]>0)*(Equipment[Initial Value]<>Equipment[Down Payment])*PMT(Equipment[Loan Rate]/MonthsInYear,Equipment[Loan Term\n(Years)]*MonthsInYear,Equipment[Initial Value]-Equipment[Down Payment]),0)","v":343.43280007691891},{"$f":"Equipment[[#This Row],[Monthly Payment]]+Equipment[Monthly\nOperating Costs]","v":463.43280007691891},{"$f":"IFERROR((Equipment[Initial Value]>0)*SLN(Equipment[Initial Value],Equipment[Expected Value at End of Contract],Equipment[Loan Term\n(Years)]),0)","v":3166.6666666666665},{"$f":"IFERROR(Equipment[Annual Depreciation\n(Straight Line)]/MonthsInYear,0)","v":263.88888888888886},{"$f":"IFERROR(Equipment[Initial Value]-(Equipment[Annual Depreciation\n(Straight Line)]*((TODAY()-Equipment[Date Purchased\nor Leased])/DaysInYear)),0)","v":995.8904109589057}]
[null,345,"Make Model 2","Branch 1","Fair","Other",1,10000,2500,"2010-09-15",4,0.08,285,1000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Date Purchased\nor Leased]])+Equipment[[#This Row],[Loan Term\n(Years)]],MONTH(Equipment[[#This Row],[Date Purchased\nor Leased]])-1,DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Date Purchased\nor Leased]])+Equipment[[#This Row],[Loan Term\n(Years)]],MONTH(Equipment[[#This Row],[Date Purchased\nor Leased]]),DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))-1)=DAY(Equipment[[#This Row],[Date Purchased\nor Leased]]))),0)","v":0},{"$f":"IFERROR(-(Equipment[Initial Value]>0)*(Equipment[Initial Value]<>Equipment[Down Payment])*PMT(Equipment[Loan Rate]/MonthsInYear,Equipment[Loan Term\n(Years)]*MonthsInYear,Equipment[Initial Value]-Equipment[Down Payment]),0)","v":183.09691756126861},{"$f":"Equipment[[#This Row],[Monthly Payment]]+Equipment[Monthly\nOperating Costs]","v":468.09691756126858},{"$f":"IFERROR((Equipment[Initial Value]>0)*SLN(Equipment[Initial Value],Equipment[Expected Value at End of Contract],Equipment[Loan Term\n(Years)]),0)","v":2250},{"$f":"IFERROR(Equipment[Annual Depreciation\n(Straight Line)]/MonthsInYear,0)","v":187.5},{"$f":"IFERROR(Equipment[Initial Value]-(Equipment[Annual Depreciation\n(Straight Line)]*((TODAY()-Equipment[Date Purchased\nor Leased])/DaysInYear)),0)","v":741.09589041095933}]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(101,Equipment[Years of\nService Left ])","v":3.3333333333333335},{"$f":"SUBTOTAL(109,Equipment[Initial Value])","v":52500},{"$f":"SUBTOTAL(109,Equipment[Down Payment])","v":9000},null,{"$f":"SUBTOTAL(101,Equipment[Loan Term\n(Years)])","v":3.6666666666666665},{"$f":"SUBTOTAL(101,Equipment[Loan Rate])","v":8.5833333333333331E-2},{"$f":"SUBTOTAL(109,Equipment[Monthly\nOperating Costs])","v":605},{"$f":"SUBTOTAL(109,Equipment[Expected Value at End of Contract])","v":24000},{"$f":"SUBTOTAL(101,Equipment[Monthly\nPayments Left])","v":0.66666666666666663},{"$f":"SUBTOTAL(109,Equipment[Monthly Payment])","v":1160.5943035068672},{"$f":"SUBTOTAL(109,Equipment[Total\nMonthly Cost])","v":1765.5943035068672},{"$f":"SUBTOTAL(101,Equipment[Annual Depreciation\n(Straight Line)])","v":2638.8888888888887},{"$f":"SUBTOTAL(101,Equipment[Monthly Depreciation\n(Straight Line)])","v":219.90740740740739},{"$f":"SUBTOTAL(109,Equipment[Current Value])","v":22284.931506849316}]

{"sheet":"Pivot Data","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Pivot Data"]
[null,"This sheet should remain hidden. Altering PivotTable structure on this sheet could result in errors in Dashboard Slicers."]
[]
[null,"Item Description\n(Make and Model)","(All)"]
[null,"Location","(All)"]
[null,"Condition","(All)"]
[null,"Vendor","(All)"]
[null,"Years of\nService Left ","(All)"]
[null,"Loan Term\n(Years)","(All)"]
[]
[null,"Row Labels","Count","Operating Costs","Payment Amount","Total Monthly Cost","Monthly Depreciation","Current Value "]
[null,123,1,200,634.06458586867973,834.06458586867973,208.33333333333334,20547.945205479453]
[null,234,1,120,343.43280007691891,463.43280007691891,263.88888888888886,995.8904109589057]
[null,345,1,285,183.09691756126861,468.09691756126858,187.5,741.09589041095933]
[null,"Grand Total",3,605,1160.5943035068672,1765.5943035068672,659.72222222222217,22284.931506849316]