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 ColumnaD1981`0 "Life-Yrs`A03`AP5`B10aD1985`A1 "Yr Acq'd1AD1984AD1983AD1982 500  aD1986`A 2 "$ ValueAD1000AD1000AD1000"*  aD1982o 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 "#arLOOKUP(F3,A1:A4)*F2E1!"#em-1"Year2LOOKUP(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)AA15+1`@E.45`Ap7`0`Ap7`0`Ap7 ?LOOKUP(J8+E16,A35:A64)AA16+1B17`@".22`A8`0`A8`0`A8 ?LOOKUP(J8+E17,A35:A64)!"A19 thru A33 is 5 yr tablesaA909`0aA9`0aA9 ?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 YearA@A21+1(F9+ERROR,ERROR:A66)A21+a@!.211APA22+1(F9+ERROR,ERROR:A66)a@!.211A`A23+1(F9+ERROR,ERROR:A66)a@.181"*LOOK "Year "Item-1 "Item-2 "Item-3ApA24+1(F9+ERROR,ERROR:A66)A24+a@3.331"*,A1:A4)*G2#" *** ARCS Depreciation Calculator ****=======AA25+1(F9+ERROR,ERROR:A66)a@%.251"*#"Use ';' key to jump back & forth and arrows to scrollAA26+1(F9+ERROR,ERROR:A66)a@.161"*DE52IF(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(ABIF(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"*DE27+1IF(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(ACIF(AND((H3<=E28),(H2+H3>E28)),LOOKUP(IF(E28-H3>=0,E28-H3+1,0),I9:I19)*H4,0)8,G2+G3BA28+1(F9+ERROR,ERROR:A66)a@ .201"*DE28+1C%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(ACIF(AND((H3<=E29),(H2+H3>E29)),LOOKUP(IF(E29-H3>=0,E29-H3+1,0),I9:I19)*H4,0)9,G2+G3BA29+1(F9+ERROR,ERROR:A66)a@2.321"*DE29+1C8IF(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(ACIF(AND((H3<=E30),(H2+H3>E30)),LOOKUP(IF(E30-H3>=0,E30-H3+1,0),I9:I19)*H4,0)0,G2+G3BA30+1(F9+ERROR,ERROR:A66)A30+a@$.241"*DE30+1C7IF(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(ACIF(AND((H3<=E31),(H2+H3>E31)),LOOKUP(IF(E31-H3>=0,E31-H3+1,0),I9:I19)*H4,0)1,G2+G3BA31+1(F9+ERROR,ERROR:A66)a@.161"*DE31+1IF(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(ACIF(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 "* DE32+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 BIF(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!"*!DE33+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!BIF(AND((H3<=E34),(H2+H3>E34)),LOOKUP(IF(E34-H3>=0,E34-H3+1,0),I9:I19)*H4,0)11,0)G3"`A18"`?.08""*"DE34+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"BIF(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#"*#DE35+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#BIF(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$"*$DE36+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%"*%DE37+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&"*&DE38+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'"*'DE39+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("*(DE40+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))AA41+1)`?.09)"*)DE41+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))*AA42+1*`?.09*DE42+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+DE43+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/`@.140BA48+10`@.121BA49+11`@.102BA50+12`?.083BA51+13`?`.064BA52+14`?@.045B A53+15`? .026B!A54+16`@.107B"A55+17`@.188B#A56+18`@.169B$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