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

{"sheet":"Equipment Inventory List","index":0,"n_rows":55,"n_cols":18,"rows_kept":55,"merged":[[0,0,0,4],[0,6,0,10],[0,11,0,15],[0,16,0,17],[1,1,1,5],[1,6,1,17]]}
["EQUIPMENT INVENTORY LIST"]
[null,"Physical Condition",{"$nulls":4},"Financial Status"]
["Asset or serial 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 \nend of loan term","Annual straight line depreciation","Monthly straight line depreciation","Current value"]
[123,"Make Model","Main branch","good","local",5,{"v":30000,"d":"$30,000.00"},{"v":5000,"d":"$5,000.00"},{"v":43115,"d":"4311500.00%"},4,{"v":0.1,"d":"10.00%"},{"$f":"IF(AND(G4>0,G4<>H4),-1*PMT(K4/12,J4*12,G4-H4),0)","v":{"v":634.0645858686821,"d":"$634.06"}},{"v":200,"d":"$200.00"},{"$f":"M4+L4","v":{"v":834.0645858686821,"d":"$834.06"}},{"v":20000,"d":"$20,000.00"},{"$f":"IF(G4>0,SLN(G4,O4,J4),0)","v":{"v":2500,"d":"$2,500.00"}},{"$f":"P4/12","v":{"v":208.33333333333334,"d":"$208.33"}},{"$f":"G4-(P4*((NOW()-I4)/365))","v":{"v":44639.8113497273,"d":"$44,639.81"}}]
[{"$nulls":11},{"$f":"IF(AND(G5>0,G5<>H5),-1*PMT(K5/12,J5*12,G5-H5),0)","v":0},null,{"$f":"M5+L5","v":0},null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},{"$f":"IF(AND(G7>0,G7<>H7),-1*PMT(K7/12,J7*12,G7-H7),0)","v":0},null,{"$f":"M7+L7","v":0},null,{"$f":"IF(G7>0,SLN(G7,O7,J7),0)","v":0},{"$f":"P7/12","v":0},{"$f":"G7-(P7*((NOW()-I7)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G8>0,G8<>H8),-1*PMT(K8/12,J8*12,G8-H8),0)","v":0},null,{"$f":"M8+L8","v":0},null,{"$f":"IF(G8>0,SLN(G8,O8,J8),0)","v":0},{"$f":"P8/12","v":0},{"$f":"G8-(P8*((NOW()-I8)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G9>0,G9<>H9),-1*PMT(K9/12,J9*12,G9-H9),0)","v":0},null,{"$f":"M9+L9","v":0},null,{"$f":"IF(G9>0,SLN(G9,O9,J9),0)","v":0},{"$f":"P9/12","v":0},{"$f":"G9-(P9*((NOW()-I9)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G10>0,G10<>H10),-1*PMT(K10/12,J10*12,G10-H10),0)","v":0},null,{"$f":"M10+L10","v":0},null,{"$f":"IF(G10>0,SLN(G10,O10,J10),0)","v":0},{"$f":"P10/12","v":0},{"$f":"G10-(P10*((NOW()-I10)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G11>0,G11<>H11),-1*PMT(K11/12,J11*12,G11-H11),0)","v":0},null,{"$f":"M11+L11","v":0},null,{"$f":"IF(G11>0,SLN(G11,O11,J11),0)","v":0},{"$f":"P11/12","v":0},{"$f":"G11-(P11*((NOW()-I11)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G12>0,G12<>H12),-1*PMT(K12/12,J12*12,G12-H12),0)","v":0},null,{"$f":"M12+L12","v":0},null,{"$f":"IF(G12>0,SLN(G12,O12,J12),0)","v":0},{"$f":"P12/12","v":0},{"$f":"G12-(P12*((NOW()-I12)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G13>0,G13<>H13),-1*PMT(K13/12,J13*12,G13-H13),0)","v":0},null,{"$f":"M13+L13","v":0},null,{"$f":"IF(G13>0,SLN(G13,O13,J13),0)","v":0},{"$f":"P13/12","v":0},{"$f":"G13-(P13*((NOW()-I13)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G14>0,G14<>H14),-1*PMT(K14/12,J14*12,G14-H14),0)","v":0},null,{"$f":"M14+L14","v":0},null,{"$f":"IF(G14>0,SLN(G14,O14,J14),0)","v":0},{"$f":"P14/12","v":0},{"$f":"G14-(P14*((NOW()-I14)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G15>0,G15<>H15),-1*PMT(K15/12,J15*12,G15-H15),0)","v":0},null,{"$f":"M15+L15","v":0},null,{"$f":"IF(G15>0,SLN(G15,O15,J15),0)","v":0},{"$f":"P15/12","v":0},{"$f":"G15-(P15*((NOW()-I15)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G16>0,G16<>H16),-1*PMT(K16/12,J16*12,G16-H16),0)","v":0},null,{"$f":"M16+L16","v":0},null,{"$f":"IF(G16>0,SLN(G16,O16,J16),0)","v":0},{"$f":"P16/12","v":0},{"$f":"G16-(P16*((NOW()-I16)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G17>0,G17<>H17),-1*PMT(K17/12,J17*12,G17-H17),0)","v":0},null,{"$f":"M17+L17","v":0},null,{"$f":"IF(G17>0,SLN(G17,O17,J17),0)","v":0},{"$f":"P17/12","v":0},{"$f":"G17-(P17*((NOW()-I17)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G18>0,G18<>H18),-1*PMT(K18/12,J18*12,G18-H18),0)","v":0},null,{"$f":"M18+L18","v":0},null,{"$f":"IF(G18>0,SLN(G18,O18,J18),0)","v":0},{"$f":"P18/12","v":0},{"$f":"G18-(P18*((NOW()-I18)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G19>0,G19<>H19),-1*PMT(K19/12,J19*12,G19-H19),0)","v":0},null,{"$f":"M19+L19","v":0},null,{"$f":"IF(G19>0,SLN(G19,O19,J19),0)","v":0},{"$f":"P19/12","v":0},{"$f":"G19-(P19*((NOW()-I19)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G20>0,G20<>H20),-1*PMT(K20/12,J20*12,G20-H20),0)","v":0},null,{"$f":"M20+L20","v":0},null,{"$f":"IF(G20>0,SLN(G20,O20,J20),0)","v":0},{"$f":"P20/12","v":0},{"$f":"G20-(P20*((NOW()-I20)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G21>0,G21<>H21),-1*PMT(K21/12,J21*12,G21-H21),0)","v":0},null,{"$f":"M21+L21","v":0},null,{"$f":"IF(G21>0,SLN(G21,O21,J21),0)","v":0},{"$f":"P21/12","v":0},{"$f":"G21-(P21*((NOW()-I21)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G22>0,G22<>H22),-1*PMT(K22/12,J22*12,G22-H22),0)","v":0},null,{"$f":"M22+L22","v":0},null,{"$f":"IF(G22>0,SLN(G22,O22,J22),0)","v":0},{"$f":"P22/12","v":0},{"$f":"G22-(P22*((NOW()-I22)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G23>0,G23<>H23),-1*PMT(K23/12,J23*12,G23-H23),0)","v":0},null,{"$f":"M23+L23","v":0},null,{"$f":"IF(G23>0,SLN(G23,O23,J23),0)","v":0},{"$f":"P23/12","v":0},{"$f":"G23-(P23*((NOW()-I23)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G24>0,G24<>H24),-1*PMT(K24/12,J24*12,G24-H24),0)","v":0},null,{"$f":"M24+L24","v":0},null,{"$f":"IF(G24>0,SLN(G24,O24,J24),0)","v":0},{"$f":"P24/12","v":0},{"$f":"G24-(P24*((NOW()-I24)/365))","v":0}]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},0,null,0,null,0,0,0]
[{"$nulls":11},{"$f":"IF(AND(G39>0,G39<>H39),-1*PMT(K39/12,J39*12,G39-H39),0)","v":0},null,{"$f":"M39+L39","v":0},null,{"$f":"IF(G39>0,SLN(G39,O39,J39),0)","v":0},{"$f":"P39/12","v":0},{"$f":"G39-(P39*((NOW()-I39)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G40>0,G40<>H40),-1*PMT(K40/12,J40*12,G40-H40),0)","v":0},null,{"$f":"M40+L40","v":0},null,{"$f":"IF(G40>0,SLN(G40,O40,J40),0)","v":0},{"$f":"P40/12","v":0},{"$f":"G40-(P40*((NOW()-I40)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G41>0,G41<>H41),-1*PMT(K41/12,J41*12,G41-H41),0)","v":0},null,{"$f":"M41+L41","v":0},null,{"$f":"IF(G41>0,SLN(G41,O41,J41),0)","v":0},{"$f":"P41/12","v":0},{"$f":"G41-(P41*((NOW()-I41)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G42>0,G42<>H42),-1*PMT(K42/12,J42*12,G42-H42),0)","v":0},null,{"$f":"M42+L42","v":0},null,{"$f":"IF(G42>0,SLN(G42,O42,J42),0)","v":0},{"$f":"P42/12","v":0},{"$f":"G42-(P42*((NOW()-I42)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G43>0,G43<>H43),-1*PMT(K43/12,J43*12,G43-H43),0)","v":0},null,{"$f":"M43+L43","v":0},null,{"$f":"IF(G43>0,SLN(G43,O43,J43),0)","v":0},{"$f":"P43/12","v":0},{"$f":"G43-(P43*((NOW()-I43)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G44>0,G44<>H44),-1*PMT(K44/12,J44*12,G44-H44),0)","v":0},null,{"$f":"M44+L44","v":0},null,{"$f":"IF(G44>0,SLN(G44,O44,J44),0)","v":0},{"$f":"P44/12","v":0},{"$f":"G44-(P44*((NOW()-I44)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G45>0,G45<>H45),-1*PMT(K45/12,J45*12,G45-H45),0)","v":0},null,{"$f":"M45+L45","v":0},null,{"$f":"IF(G45>0,SLN(G45,O45,J45),0)","v":0},{"$f":"P45/12","v":0},{"$f":"G45-(P45*((NOW()-I45)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G46>0,G46<>H46),-1*PMT(K46/12,J46*12,G46-H46),0)","v":0},null,{"$f":"M46+L46","v":0},null,{"$f":"IF(G46>0,SLN(G46,O46,J46),0)","v":0},{"$f":"P46/12","v":0},{"$f":"G46-(P46*((NOW()-I46)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G47>0,G47<>H47),-1*PMT(K47/12,J47*12,G47-H47),0)","v":0},null,{"$f":"M47+L47","v":0},null,{"$f":"IF(G47>0,SLN(G47,O47,J47),0)","v":0},{"$f":"P47/12","v":0},{"$f":"G47-(P47*((NOW()-I47)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G48>0,G48<>H48),-1*PMT(K48/12,J48*12,G48-H48),0)","v":0},null,{"$f":"M48+L48","v":0},null,{"$f":"IF(G48>0,SLN(G48,O48,J48),0)","v":0},{"$f":"P48/12","v":0},{"$f":"G48-(P48*((NOW()-I48)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G49>0,G49<>H49),-1*PMT(K49/12,J49*12,G49-H49),0)","v":0},null,{"$f":"M49+L49","v":0},null,{"$f":"IF(G49>0,SLN(G49,O49,J49),0)","v":0},{"$f":"P49/12","v":0},{"$f":"G49-(P49*((NOW()-I49)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G50>0,G50<>H50),-1*PMT(K50/12,J50*12,G50-H50),0)","v":0},null,{"$f":"M50+L50","v":0},null,{"$f":"IF(G50>0,SLN(G50,O50,J50),0)","v":0},{"$f":"P50/12","v":0},{"$f":"G50-(P50*((NOW()-I50)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G51>0,G51<>H51),-1*PMT(K51/12,J51*12,G51-H51),0)","v":0},null,{"$f":"M51+L51","v":0},null,{"$f":"IF(G51>0,SLN(G51,O51,J51),0)","v":0},{"$f":"P51/12","v":0},{"$f":"G51-(P51*((NOW()-I51)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G52>0,G52<>H52),-1*PMT(K52/12,J52*12,G52-H52),0)","v":0},null,{"$f":"M52+L52","v":0},null,{"$f":"IF(G52>0,SLN(G52,O52,J52),0)","v":0},{"$f":"P52/12","v":0},{"$f":"G52-(P52*((NOW()-I52)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G53>0,G53<>H53),-1*PMT(K53/12,J53*12,G53-H53),0)","v":0},null,{"$f":"M53+L53","v":0},null,{"$f":"IF(G53>0,SLN(G53,O53,J53),0)","v":0},{"$f":"P53/12","v":0},{"$f":"G53-(P53*((NOW()-I53)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G54>0,G54<>H54),-1*PMT(K54/12,J54*12,G54-H54),0)","v":0},null,{"$f":"M54+L54","v":0},null,{"$f":"IF(G54>0,SLN(G54,O54,J54),0)","v":0},{"$f":"P54/12","v":0},{"$f":"G54-(P54*((NOW()-I54)/365))","v":0}]
[{"$nulls":11},{"$f":"IF(AND(G55>0,G55<>H55),-1*PMT(K55/12,J55*12,G55-H55),0)","v":0},null,{"$f":"M55+L55","v":0},null,{"$f":"IF(G55>0,SLN(G55,O55,J55),0)","v":0},{"$f":"P55/12","v":0},{"$f":"G55-(P55*((NOW()-I55)/365))","v":0}]