{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Equipment inventory list"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Equipment inventory list","index":0,"n_rows":10,"n_cols":20,"rows_kept":10,"merged":[[1,1,1,6],[2,1,2,6],[2,7,2,18]]}
[{"$nulls":19}," "]
[null,"EQUIPMENT INVENTORY LIST"]
[null,"Physical condition",{"$nulls":5},"Financial status"]
[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 \nin years","Loan rate","Monthly payment","Monthly operating \ncosts","Total monthly \ncost","Expected value at end \nof loan term","Annual straight line depreciation","Monthly straight line depreciation","Current value"]
[null,123,"AKJG876","HQ","Good","Local",5,{"v":30000,"d":"$30000"},{"v":5000,"d":"$5000"},{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2023-01-15"},4,{"v":0.1,"d":"10.00%"},{"$f":"IFERROR(IF(AND(H5>0,H5<>I5),-1*PMT(L5/12,K5*12,H5-I5),0), \"\")","v":{"v":634.0645858686797,"d":"$634"}},{"v":200,"d":"$200"},{"$f":"IFERROR(N5+M5, \"\")","v":{"v":834.0645858686797,"d":"$834"}},{"v":20000,"d":"$20000"},{"$f":"IFERROR(IF(H5>0,SLN(H5,P5,K5),0), \"\")","v":{"v":2500,"d":"$2500"}},{"$f":"IFERROR(Q5/12, \"\")","v":{"v":208.33333333333334,"d":"$208"}},{"$f":"IFERROR(H5-(Q5*((NOW()-J5)/365)), \"\")","v":{"v":28074.470111142808,"d":"$28074"}}]
[null,456,"LKH687","HQ","Good","Local",6,{"v":12560,"d":"$12560"},{"v":3000,"d":"$3000"},{"$f":"DATE(YEAR(TODAY()),5,3)","v":"2023-05-03"},5,{"v":0.06,"d":"6.00%"},{"$f":"IFERROR(IF(AND(H6>0,H6<>I6),-1*PMT(L6/12,K6*12,H6-I6),0), \"\")","v":{"v":184.82158262133086,"d":"$185"}},{"v":102,"d":"$102"},{"$f":"IFERROR(N6+M6, \"\")","v":{"v":286.8215826213309,"d":"$287"}},{"v":10000,"d":"$10000"},{"$f":"IFERROR(IF(H6>0,SLN(H6,P6,K6),0), \"\")","v":{"v":512,"d":"$512"}},{"$f":"IFERROR(Q6/12, \"\")","v":{"v":42.666666666666664,"d":"$43"}},{"$f":"IFERROR(H6-(Q6*((NOW()-J6)/365)), \"\")","v":{"v":12317.147369173006,"d":"$12317"}}]
[null,789,"GIN123760","Warehouse","New","Local",10,{"v":32555,"d":"$32555"},{"v":8000,"d":"$8000"},{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2023-08-01"},10,{"v":0.025,"d":"2.50%"},{"v":231.479743634085,"d":"$231"},null,{"v":231.479743634085,"d":"$231"},{"v":25000,"d":"$25000"},{"v":755.5,"d":"$756"},{"v":62.958333333333336,"d":"$63"},{"v":32382.937744299685,"d":"$32383"}]
[{"$nulls":12},0,null,0,null,0,0,0]
[{"$nulls":12},0,null,0,null,0,0,0]
[{"$nulls":12},0,null,0,null,0,0,0]