SuperCalc Ver. 1.06 Calculate ACRS DEPRECIATION Model 9/12/82 by HMVTL»ÿ P9ÿÿ P8ÿÿ #"Calculate ACRS DEPRECIATION Model 9/12/82 by HMVT "Enter:#"Year Aquired and $ Value in Proper Life ColumnaD�1981`0 "Life-Yrs`A03`AP5`B10aD…1985`A1 "Yr Acq'd1AD„1984ADƒ1983AD‚1982 500  aD†1986`A 2 "$ ValueAD1000AD1000AD1000"*  aD‚1982o Start Table !" = First year to start table`A03`AP5`B10 "Year "Item-1 "Year "Item-2 "Year  "Item-3!"A9 thru A17 is 3 yr table "#ar¢LOOKUP(F3,A1:A4)*F2E1!"#em-1"Year2¢LOOKUP(G3,A1:A4)*G2F1 "#ar ¢LOOKUP(H3,A1:A4)*H2`A1`@%.25`0a0OKUP(E3,A1:A4)*E2a0OKUP(F3,A1:A4)*F2a0OKUP(F3,A1:A4)*F2`0 a0OKUP(G3,A1:A4)*G2 ¡A A9+1 `@8.38 `A1 ¢@%LOOKUP(F8+E10,A9:A17) bA1OKUP(F9+D10,A19:A33) ¢@LOOKUP(H8+E10,A19:A33) `A1 ¢?€LOOKUP(J8+E10,A35:A64) ¡A0A10+1B11 `@7.37 `A 2 ¢@8LOOKUP(F8+E11,A9:A17) bA 2OKUP(F9+D11,A19:A33) ¢@"LOOKUP(H8+E11,A19:A33) `A 2 ¢@LOOKUP(J8+E11,A35:A64) ¡A@A11+1 `@).29 `A03 ¢@7LOOKUP(F8+E12,A9:A17) bA03OKUP(F9+D12,A19:A33) ¢@!LOOKUP(H8+E12,A19:A33) `A03 ¢@LOOKUP(J8+E12,A35:A64) ¡APA12+1B13 `@G.47 `A@4 `0<= bA@4OKUP(F9+D13,A19:A33) ¢@!LOOKUP(H8+E13,A19:A33) `A@4 ¢@LOOKUP(J8+E13,A35:A64) ¡A`A13+1 `@$.24 `AP5 `0 bAP5OKUP(F9+D14,A19:A33) ¢@!LOOKUP(H8+E14,A19:A33) `AP5 ¢@LOOKUP(J8+E14,A35:A64)¡ApA14+1B15`@3.33`A`6`0`A`6`0`A`6 ¢@LOOKUP(J8+E15,A35:A64)¡A€A15+1`@E.45`Ap7`0`Ap7`0`Ap7 ¢?�LOOKUP(J8+E16,A35:A64)¡A�A16+1B17`@".22`A€8`0`A€8`0`A€8 ¢?�LOOKUP(J8+E17,A35:A64)!"A19 thru A33 is 5 yr tablesaA�909`0aA�9`0aA�9 ¢?�LOOKUP(J8+E18,A35:A64)bA1OKUP(F9+ERROR,ERROR:A66)a@.151`B10`0`B10`0`B10 ¢?�LOOKUP(J8+E19,A35:A64)¢A A19+1(F9+ERROR,ERROR:A66)a@".221 "---------00 "--------- "--------- "--------- "---------¢A0A20+1(F9+ERROR,ERROR:A66)a@!.211!"Depreciation by Year¢A@A21+1(F9+ERROR,ERROR:A66)A21+a@!.211¢APA22+1(F9+ERROR,ERROR:A66)a@!.211¢A`A23+1(F9+ERROR,ERROR:A66)a@.181"*LOOK "Year "Item-1 "Item-2 "Item-3¢ApA24+1(F9+ERROR,ERROR:A66)A24+a@3.331"*,A1:A4)*G2#" *** ARCS Depreciation Calculator ****=======¢A€A25+1(F9+ERROR,ERROR:A66)a@%.251"*#"Use ';' key to jump back & forth and arrows to scroll¢A�A26+1(F9+ERROR,ERROR:A66)a@.161"*¡D‚E52¥IF(AND((F3<=E27),(F2+F3>E27)),LOOKUP(IF(E27-F3>=0,E27-F3+1,0),E9:E19)*F4,0)¥IF(AND((G3<=E27),(G2+G3>E27)),LOOKUP(IF(E27-G3>=0,E27-G3+1,0),G9:G19)*G4,0)IF(A¥B€IF(AND((H3<=E27),(H2+H3>E27)),LOOKUP(IF(E27-H3>=0,E27-H3+1,0),I9:I19)*H4,0)27,G2+G3 ¢ÁE27-F3+17-F3+1,E10:E19)¢BA27+1(F9+ERROR,ERROR:A66)A27+a?€.081"*¡DƒE27+1¥IF(AND((F3<=E28),(F2+F3>E28)),LOOKUP(IF(E28-F3>=0,E28-F3+1,0),E9:E19)*F4,0)AND(¥CIF(AND((G3<=E28),(G2+G3>E28)),LOOKUP(IF(E28-G3>=0,E28-G3+1,0),G9:G19)*G4,0)IF(A¥CIF(AND((H3<=E28),(H2+H3>E28)),LOOKUP(IF(E28-H3>=0,E28-H3+1,0),I9:I19)*H4,0)8,G2+G3¢BA28+1(F9+ERROR,ERROR:A66)a@ .201"*¡D„E28+1¥C%IF(AND((F3<=E29),(F2+F3>E29)),LOOKUP(IF(E29-F3>=0,E29-F3+1,0),E9:E19)*F4,0)¥C"IF(AND((G3<=E29),(G2+G3>E29)),LOOKUP(IF(E29-G3>=0,E29-G3+1,0),G9:G19)*G4,0)IF(A¥CIF(AND((H3<=E29),(H2+H3>E29)),LOOKUP(IF(E29-H3>=0,E29-H3+1,0),I9:I19)*H4,0)9,G2+G3¢BA29+1(F9+ERROR,ERROR:A66)a@2.321"*¡D…E29+1¥C8IF(AND((F3<=E30),(F2+F3>E30)),LOOKUP(IF(E30-F3>=0,E30-F3+1,0),E9:E19)*F4,0)¥C!IF(AND((G3<=E30),(G2+G3>E30)),LOOKUP(IF(E30-G3>=0,E30-G3+1,0),G9:G19)*G4,0)IF(A¥CIF(AND((H3<=E30),(H2+H3>E30)),LOOKUP(IF(E30-H3>=0,E30-H3+1,0),I9:I19)*H4,0)0,G2+G3¢BA30+1(F9+ERROR,ERROR:A66)A30+a@$.241"*¡D†E30+1¥C7IF(AND((F3<=E31),(F2+F3>E31)),LOOKUP(IF(E31-F3>=0,E31-F3+1,0),E9:E19)*F4,0)¥C!IF(AND((G3<=E31),(G2+G3>E31)),LOOKUP(IF(E31-G3>=0,E31-G3+1,0),G9:G19)*G4,0)IF(A¥CIF(AND((H3<=E31),(H2+H3>E31)),LOOKUP(IF(E31-H3>=0,E31-H3+1,0),I9:I19)*H4,0)1,G2+G3¢BA31+1(F9+ERROR,ERROR:A66)a@.161"*¡D‡E31+1¥IF(AND((F3<=E32),(F2+F3>E32)),LOOKUP(IF(E32-F3>=0,E32-F3+1,0),E9:E19)*F4,0)¥C!IF(AND((G3<=E32),(G2+G3>E32)),LOOKUP(IF(E32-G3>=0,E32-G3+1,0),G9:G19)*G4,0)IF(A¥CIF(AND((H3<=E32),(H2+H3>E32)),LOOKUP(IF(E32-H3>=0,E32-H3+1,0),I9:I19)*H4,0)2,G2+G3 ¢BA32+1(F9+ERROR,ERROR:A66) a?€.081 "* ¡DˆE32+1 ¥IF(AND((F3<=E33),(F2+F3>E33)),LOOKUP(IF(E33-F3>=0,E33-F3+1,0),E9:E19)*F4,0)) ¥IF(AND((G3<=E33),(G2+G3>E33)),LOOKUP(IF(E33-G3>=0,E33-G3+1,0),G9:G19)*G4,0))IF(A ¥B�IF(AND((H3<=E33),(H2+H3>E33)),LOOKUP(IF(E33-H3>=0,E33-H3+1,0),I9:I19)*H4,0)),G2+G3!!"A35 thru A64 is 10 yr table!"*!¡D‰E33+1!¥IF(AND((F3<=E34),(F2+F3>E34)),LOOKUP(IF(E34-F3>=0,E34-F3+1,0),E9:E19)*F4,0)11,0)!¥IF(AND((G3<=E34),(G2+G3>E34)),LOOKUP(IF(E34-G3>=0,E34-G3+1,0),G9:G19)*G4,0)11,0)(A!¥B�IF(AND((H3<=E34),(H2+H3>E34)),LOOKUP(IF(E34-H3>=0,E34-H3+1,0),I9:I19)*H4,0)11,0)G3"`A18"`?€.08""*"¡D�E34+1"¥IF(AND((F3<=E35),(F2+F3>E35)),LOOKUP(IF(E35-F3>=0,E35-F3+1,0),E9:E19)*F4,0)E12,0)"¥IF(AND((G3<=E35),(G2+G3>E35)),LOOKUP(IF(E35-G3>=0,E35-G3+1,0),G9:G19)*G4,0)F12,0)A"¥B�IF(AND((H3<=E35),(H2+H3>E35)),LOOKUP(IF(E35-H3>=0,E35-H3+1,0),I9:I19)*H4,0)G12,0)3#¡A A35+1#`@.14#"*#¡D‘E35+1#¥IF(AND((F3<=E36),(F2+F3>E36)),LOOKUP(IF(E36-F3>=0,E36-F3+1,0),E9:E19)*F4,0)E13,0)#¥IF(AND((G3<=E36),(G2+G3>E36)),LOOKUP(IF(E36-G3>=0,E36-G3+1,0),G9:G19)*G4,0)F13,0)A#¥B�IF(AND((H3<=E36),(H2+H3>E36)),LOOKUP(IF(E36-H3>=0,E36-H3+1,0),I9:I19)*H4,0)G13,0)3$¡A0A36+1$`@.12$"*$¡D’E36+1$¥IF(AND((F3<=E37),(F2+F3>E37)),LOOKUP(IF(E37-F3>=0,E37-F3+1,0),E9:E19)*F4,0)$¥IF(AND((G3<=E37),(G2+G3>E37)),LOOKUP(IF(E37-G3>=0,E37-G3+1,0),G9:G19)*G4,0)$¥IF(AND((H3<=E37),(H2+H3>E37)),LOOKUP(IF(E37-H3>=0,E37-H3+1,0),I9:I19)*H4,0)%¡A@A37+1%`@.10%"*%¡D“E37+1%¥IF(AND((F3<=E38),(F2+F3>E38)),LOOKUP(IF(E38-F3>=0,E38-F3+1,0),E9:E19)*F4,0)%¥IF(AND((G3<=E38),(G2+G3>E38)),LOOKUP(IF(E38-G3>=0,E38-G3+1,0),G9:G19)*G4,0)%¥IF(AND((H3<=E38),(H2+H3>E38)),LOOKUP(IF(E38-H3>=0,E38-H3+1,0),I9:I19)*H4,0)&¡APA38+1&`@.10&"*&¡D”E38+1&¥IF(AND((F3<=E39),(F2+F3>E39)),LOOKUP(IF(E39-F3>=0,E39-F3+1,0),E9:E19)*F4,0)&¥IF(AND((G3<=E39),(G2+G3>E39)),LOOKUP(IF(E39-G3>=0,E39-G3+1,0),G9:G19)*G4,0)&¥IF(AND((H3<=E39),(H2+H3>E39)),LOOKUP(IF(E39-H3>=0,E39-H3+1,0),I9:I19)*H4,0)'¡A`A39+1'`@.10'"*'¡D•E39+1'¥IF(AND((F3<=E40),(F2+F3>E40)),LOOKUP(IF(E40-F3>=0,E40-F3+1,0),E9:E19)*F4,0)'¥IF(AND((G3<=E40),(G2+G3>E40)),LOOKUP(IF(E40-G3>=0,E40-G3+1,0),G9:G19)*G4,0)'¥IF(AND((H3<=E40),(H2+H3>E40)),LOOKUP(IF(E40-H3>=0,E40-H3+1,0),I9:I19)*H4,0)(¡ApA40+1(`?�.09("*(¡D–E40+1(¥IF(AND((F3<=E41),(F2+F3>E41)),LOOKUP(IF(E41-F3>=0,E41-F3+1,0),E9:E19)*F4,0)(¥IF(AND((G3<=E41),(G2+G3>E41)),LOOKUP(IF(E41-G3>=0,E41-G3+1,0),G9:G19)*G4,0)(¥IF(AND((H3<=E41),(H2+H3>E41)),LOOKUP(IF(E41-H3>=0,E41-H3+1,0),I9:I19)*H4,0))¡A€A41+1)`?�.09)"*)¡D—E41+1)¥IF(AND((F3<=E42),(F2+F3>E42)),LOOKUP(IF(E42-F3>=0,E42-F3+1,0),E9:E19)*F4,0)))¥IF(AND((G3<=E42),(G2+G3>E42)),LOOKUP(IF(E42-G3>=0,E42-G3+1,0),G9:G19)*G4,0)))¥IF(AND((H3<=E42),(H2+H3>E42)),LOOKUP(IF(E42-H3>=0,E42-H3+1,0),I9:I19)*H4,0))*¡A�A42+1*`?�.09*¡D˜E42+1*¥IF(AND((F3<=E43),(F2+F3>E43)),LOOKUP(IF(E43-F3>=0,E43-F3+1,0),E9:E19)*F4,0)11,0)*¥IF(AND((G3<=E43),(G2+G3>E43)),LOOKUP(IF(E43-G3>=0,E43-G3+1,0),G9:G19)*G4,0)11,0)*¥IF(AND((H3<=E43),(H2+H3>E43)),LOOKUP(IF(E43-H3>=0,E43-H3+1,0),I9:I19)*H4,0)11,0)+¡BA43+1+`?�.09+¡D™E43+1+¥IF(AND((F3<=E44),(F2+F3>E44)),LOOKUP(IF(E44-F3>=0,E44-F3+1,0),E9:E19)*F4,0)E12,0)+¥IF(AND((G3<=E44),(G2+G3>E44)),LOOKUP(IF(E44-G3>=0,E44-G3+1,0),G9:G19)*G4,0)F12,0)+¥IF(AND((H3<=E44),(H2+H3>E44)),LOOKUP(IF(E44-H3>=0,E44-H3+1,0),I9:I19)*H4,0)G12,0),¡BA44+1,`?�.09,¡D E44+1,¥IF(AND((F3<=E45),(F2+F3>E45)),LOOKUP(IF(E45-F3>=0,E45-F3+1,0),E9:E19)*F4,0)E13,0),¥IF(AND((G3<=E45),(G2+G3>E45)),LOOKUP(IF(E45-G3>=0,E45-G3+1,0),G9:G19)*G4,0)F13,0),¥IF(AND((H3<=E45),(H2+H3>E45)),LOOKUP(IF(E45-H3>=0,E45-H3+1,0),I9:I19)*H4,0)G13,0)-¡BA45+1-`@.19-¡D E45+1-¥IF(AND((F3<=E46),(F2+F3>E46)),LOOKUP(IF(E46-F3>=0,E46-F3+1,0),E9:E19)*F4,0)E14,0)-¥IF(AND((G3<=E46),(G2+G3>E46)),LOOKUP(IF(E46-G3>=0,E46-G3+1,0),G9:G19)*G4,0)F14,0)-¥IF(AND((H3<=E46),(H2+H3>E46)),LOOKUP(IF(E46-H3>=0,E46-H3+1,0),I9:I19)*H4,0)G14,0).¡BA46+1.`@.6.#"STOP!! this is the end of Table go back other way/¡BA47+1/`@.140¡BA48+10`@.121¡BA49+11`@.102¡BA50+12`?€.083¡BA51+13`?`.064¡BA52+14`?@.045¡B A53+15`? .026¡B!A54+16`@.107¡B"A55+17`@.188¡B#A56+18`@.169¡B$A57+19`@.14:¡B%A58+1:`@.12;¡B&A59+1;`@.10<¡B'A60+1<`?€.08=¡B(A61+1=`?`.06>¡B)A62+1>`?@.04?¡B0A63+1?`? .02åååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååå