Tugas Komputasi Teknik KimiaMichael Alan SW/6213084/FMichael Dannish P/6213100/FExcel.00.10.20.3

050505050

0.010=D4+(0.01*0.01/0.1^2)*(E4-2*D4+C4)=E4+(0.01*0.01/0.1^2)*(F4-2*E4+D4)=F4+(0.01*0.01/0.1^2)*(G4-2*F4+E4)

0.020=D5+(0.01*0.01/0.1^2)*(E5-2*D5+C5)=E5+(0.01*0.01/0.1^2)*(F5-2*E5+D5)=F5+(0.01*0.01/0.1^2)*(G5-2*F5+E5)

0.030=D6+(0.01*0.01/0.1^2)*(E6-2*D6+C6)=E6+(0.01*0.01/0.1^2)*(F6-2*E6+D6)=F6+(0.01*0.01/0.1^2)*(G6-2*F6+E6)

0.040=D7+(0.01*0.01/0.1^2)*(E7-2*D7+C7)=E7+(0.01*0.01/0.1^2)*(F7-2*E7+D7)=F7+(0.01*0.01/0.1^2)*(G7-2*F7+E7)

0.050=D8+(0.01*0.01/0.1^2)*(E8-2*D8+C8)=E8+(0.01*0.01/0.1^2)*(F8-2*E8+D8)=F8+(0.01*0.01/0.1^2)*(G8-2*F8+E8)

0.060=D9+(0.01*0.01/0.1^2)*(E9-2*D9+C9)=E9+(0.01*0.01/0.1^2)*(F9-2*E9+D9)=F9+(0.01*0.01/0.1^2)*(G9-2*F9+E9)

0.070=D10+(0.01*0.01/0.1^2)*(E10-2*D10+C10)=E10+(0.01*0.01/0.1^2)*(F10-2*E10+D10)=F10+(0.01*0.01/0.1^2)*(G10-2*F10+E10)

0.080=D11+(0.01*0.01/0.1^2)*(E11-2*D11+C11)=E11+(0.01*0.01/0.1^2)*(F11-2*E11+D11)=F11+(0.01*0.01/0.1^2)*(G11-2*F11+E11)

0.090=D12+(0.01*0.01/0.1^2)*(E12-2*D12+C12)=E12+(0.01*0.01/0.1^2)*(F12-2*E12+D12)=F12+(0.01*0.01/0.1^2)*(G12-2*F12+E12)

0.10=D13+(0.01*0.01/0.1^2)*(E13-2*D13+C13)=E13+(0.01*0.01/0.1^2)*(F13-2*E13+D13)=F13+(0.01*0.01/0.1^2)*(G13-2*F13+E13)

0.110=D14+(0.01*0.01/0.1^2)*(E14-2*D14+C14)=E14+(0.01*0.01/0.1^2)*(F14-2*E14+D14)=F14+(0.01*0.01/0.1^2)*(G14-2*F14+E14)

0.120=D15+(0.01*0.01/0.1^2)*(E15-2*D15+C15)=E15+(0.01*0.01/0.1^2)*(F15-2*E15+D15)=F15+(0.01*0.01/0.1^2)*(G15-2*F15+E15)

0.130=D16+(0.01*0.01/0.1^2)*(E16-2*D16+C16)=E16+(0.01*0.01/0.1^2)*(F16-2*E16+D16)=F16+(0.01*0.01/0.1^2)*(G16-2*F16+E16)

0.140=D17+(0.01*0.01/0.1^2)*(E17-2*D17+C17)=E17+(0.01*0.01/0.1^2)*(F17-2*E17+D17)=F17+(0.01*0.01/0.1^2)*(G17-2*F17+E17)

0.150=D18+(0.01*0.01/0.1^2)*(E18-2*D18+C18)=E18+(0.01*0.01/0.1^2)*(F18-2*E18+D18)=F18+(0.01*0.01/0.1^2)*(G18-2*F18+E18)

0.160=D19+(0.01*0.01/0.1^2)*(E19-2*D19+C19)=E19+(0.01*0.01/0.1^2)*(F19-2*E19+D19)=F19+(0.01*0.01/0.1^2)*(G19-2*F19+E19)

0.170=D20+(0.01*0.01/0.1^2)*(E20-2*D20+C20)=E20+(0.01*0.01/0.1^2)*(F20-2*E20+D20)=F20+(0.01*0.01/0.1^2)*(G20-2*F20+E20)

0.180=D21+(0.01*0.01/0.1^2)*(E21-2*D21+C21)=E21+(0.01*0.01/0.1^2)*(F21-2*E21+D21)=F21+(0.01*0.01/0.1^2)*(G21-2*F21+E21)

0.190=D22+(0.01*0.01/0.1^2)*(E22-2*D22+C22)=E22+(0.01*0.01/0.1^2)*(F22-2*E22+D22)=F22+(0.01*0.01/0.1^2)*(G22-2*F22+E22)

0.20=D23+(0.01*0.01/0.1^2)*(E23-2*D23+C23)=E23+(0.01*0.01/0.1^2)*(F23-2*E23+D23)=F23+(0.01*0.01/0.1^2)*(G23-2*F23+E23)

0.210=D24+(0.01*0.01/0.1^2)*(E24-2*D24+C24)=E24+(0.01*0.01/0.1^2)*(F24-2*E24+D24)=F24+(0.01*0.01/0.1^2)*(G24-2*F24+E24)

0.220=D25+(0.01*0.01/0.1^2)*(E25-2*D25+C25)=E25+(0.01*0.01/0.1^2)*(F25-2*E25+D25)=F25+(0.01*0.01/0.1^2)*(G25-2*F25+E25)

0.230=D26+(0.01*0.01/0.1^2)*(E26-2*D26+C26)=E26+(0.01*0.01/0.1^2)*(F26-2*E26+D26)=F26+(0.01*0.01/0.1^2)*(G26-2*F26+E26)

0.240=D27+(0.01*0.01/0.1^2)*(E27-2*D27+C27)=E27+(0.01*0.01/0.1^2)*(F27-2*E27+D27)=F27+(0.01*0.01/0.1^2)*(G27-2*F27+E27)

0.250=D28+(0.01*0.01/0.1^2)*(E28-2*D28+C28)=E28+(0.01*0.01/0.1^2)*(F28-2*E28+D28)=F28+(0.01*0.01/0.1^2)*(G28-2*F28+E28)

0.260=D29+(0.01*0.01/0.1^2)*(E29-2*D29+C29)=E29+(0.01*0.01/0.1^2)*(F29-2*E29+D29)=F29+(0.01*0.01/0.1^2)*(G29-2*F29+E29)

0.270=D30+(0.01*0.01/0.1^2)*(E30-2*D30+C30)=E30+(0.01*0.01/0.1^2)*(F30-2*E30+D30)=F30+(0.01*0.01/0.1^2)*(G30-2*F30+E30)

0.280=D31+(0.01*0.01/0.1^2)*(E31-2*D31+C31)=E31+(0.01*0.01/0.1^2)*(F31-2*E31+D31)=F31+(0.01*0.01/0.1^2)*(G31-2*F31+E31)

0.290=D32+(0.01*0.01/0.1^2)*(E32-2*D32+C32)=E32+(0.01*0.01/0.1^2)*(F32-2*E32+D32)=F32+(0.01*0.01/0.1^2)*(G32-2*F32+E32)

0.30=D33+(0.01*0.01/0.1^2)*(E33-2*D33+C33)=E33+(0.01*0.01/0.1^2)*(F33-2*E33+D33)=F33+(0.01*0.01/0.1^2)*(G33-2*F33+E33)

0.310=D34+(0.01*0.01/0.1^2)*(E34-2*D34+C34)=E34+(0.01*0.01/0.1^2)*(F34-2*E34+D34)=F34+(0.01*0.01/0.1^2)*(G34-2*F34+E34)

0.320=D35+(0.01*0.01/0.1^2)*(E35-2*D35+C35)=E35+(0.01*0.01/0.1^2)*(F35-2*E35+D35)=F35+(0.01*0.01/0.1^2)*(G35-2*F35+E35)

0.330=D36+(0.01*0.01/0.1^2)*(E36-2*D36+C36)=E36+(0.01*0.01/0.1^2)*(F36-2*E36+D36)=F36+(0.01*0.01/0.1^2)*(G36-2*F36+E36)

0.340=D37+(0.01*0.01/0.1^2)*(E37-2*D37+C37)=E37+(0.01*0.01/0.1^2)*(F37-2*E37+D37)=F37+(0.01*0.01/0.1^2)*(G37-2*F37+E37)

0.350=D38+(0.01*0.01/0.1^2)*(E38-2*D38+C38)=E38+(0.01*0.01/0.1^2)*(F38-2*E38+D38)=F38+(0.01*0.01/0.1^2)*(G38-2*F38+E38)

0.360=D39+(0.01*0.01/0.1^2)*(E39-2*D39+C39)=E39+(0.01*0.01/0.1^2)*(F39-2*E39+D39)=F39+(0.01*0.01/0.1^2)*(G39-2*F39+E39)

0.370=D40+(0.01*0.01/0.1^2)*(E40-2*D40+C40)=E40+(0.01*0.01/0.1^2)*(F40-2*E40+D40)=F40+(0.01*0.01/0.1^2)*(G40-2*F40+E40)

0.380=D41+(0.01*0.01/0.1^2)*(E41-2*D41+C41)=E41+(0.01*0.01/0.1^2)*(F41-2*E41+D41)=F41+(0.01*0.01/0.1^2)*(G41-2*F41+E41)

0.390=D42+(0.01*0.01/0.1^2)*(E42-2*D42+C42)=E42+(0.01*0.01/0.1^2)*(F42-2*E42+D42)=F42+(0.01*0.01/0.1^2)*(G42-2*F42+E42)

0.40=D43+(0.01*0.01/0.1^2)*(E43-2*D43+C43)=E43+(0.01*0.01/0.1^2)*(F43-2*E43+D43)=F43+(0.01*0.01/0.1^2)*(G43-2*F43+E43)

0.410=D44+(0.01*0.01/0.1^2)*(E44-2*D44+C44)=E44+(0.01*0.01/0.1^2)*(F44-2*E44+D44)=F44+(0.01*0.01/0.1^2)*(G44-2*F44+E44)

0.420=D45+(0.01*0.01/0.1^2)*(E45-2*D45+C45)=E45+(0.01*0.01/0.1^2)*(F45-2*E45+D45)=F45+(0.01*0.01/0.1^2)*(G45-2*F45+E45)

0.430=D46+(0.01*0.01/0.1^2)*(E46-2*D46+C46)=E46+(0.01*0.01/0.1^2)*(F46-2*E46+D46)=F46+(0.01*0.01/0.1^2)*(G46-2*F46+E46)

0.440=D47+(0.01*0.01/0.1^2)*(E47-2*D47+C47)=E47+(0.01*0.01/0.1^2)*(F47-2*E47+D47)=F47+(0.01*0.01/0.1^2)*(G47-2*F47+E47)

0.450=D48+(0.01*0.01/0.1^2)*(E48-2*D48+C48)=E48+(0.01*0.01/0.1^2)*(F48-2*E48+D48)=F48+(0.01*0.01/0.1^2)*(G48-2*F48+E48)

0.460=D49+(0.01*0.01/0.1^2)*(E49-2*D49+C49)=E49+(0.01*0.01/0.1^2)*(F49-2*E49+D49)=F49+(0.01*0.01/0.1^2)*(G49-2*F49+E49)

0.470=D50+(0.01*0.01/0.1^2)*(E50-2*D50+C50)=E50+(0.01*0.01/0.1^2)*(F50-2*E50+D50)=F50+(0.01*0.01/0.1^2)*(G50-2*F50+E50)

0.480=D51+(0.01*0.01/0.1^2)*(E51-2*D51+C51)=E51+(0.01*0.01/0.1^2)*(F51-2*E51+D51)=F51+(0.01*0.01/0.1^2)*(G51-2*F51+E51)

0.490=D52+(0.01*0.01/0.1^2)*(E52-2*D52+C52)=E52+(0.01*0.01/0.1^2)*(F52-2*E52+D52)=F52+(0.01*0.01/0.1^2)*(G52-2*F52+E52)

0.50=D53+(0.01*0.01/0.1^2)*(E53-2*D53+C53)=E53+(0.01*0.01/0.1^2)*(F53-2*E53+D53)=F53+(0.01*0.01/0.1^2)*(G53-2*F53+E53)

Hasil Formula:00.10.20.30.40.50.60.70.80.91

05050505050505050505050

0.01050505050505050505050

0.02049.5505050505050505050

0.03049.0149.9955050505050505050

0.04048.5297549.985249.9999550505050505050

0.05048.05900749.97079349.99980349.9999995505050505050

0.06047.5975347949.9519652449.9995148749.99999754505050505050

0.07047.1451037549.9288964349.999044249.9999927449.999999975050505050

0.08046.7014906449.9017599849.998352249.9999833249.99999995050505050

0.09046.2664784249.8707232149.9974025949.9999671849.999999735050505050

0.1045.8398560949.8359475649.9961614449.9999418649.999999415050505050

0.11045.4214184449.7975887849.9945971149.9999046349.9999988449.9999999950505050

0.12045.0109659649.7557971649.992680149.999852549.9999979149.9999999850505050

0.13044.6083046149.7107176849.99038349.9997822349.9999964849.9999999650505050

0.14044.213245749.662490249.9876803449.9996903849.9999943749.9999999250505050

0.15043.8256056849.6112496649.9845485349.9995733249.9999913949.9999998750505050

0.16043.4452060749.5571262149.9809657949.9994272549.9999872949.9999997950505050

0.17043.0718732149.500245449.9769120149.9992482449.9999818149.9999996650505050

0.18042.705438249.4407283549.9723687149.9990322149.9999746649.9999994949.99999999505050

0.19042.3457367249.3786918549.9673189449.99877549.9999654849.9999992449.99999999505050

0.2041.992608949.3142485749.9617472349.9984723449.9999539149.9999989149.99999998505050

0.21041.6458992149.2475071649.9556394949.9981199149.9999395549.9999984749.99999997505050

0.22041.305456349.178572449.9489829749.997713349.9999219449.999997949.99999995505050

0.23040.9711328949.1075453549.9417661749.9972480849.9999006149.9999971649.99999993505050

0.24040.6427856949.0345234349.9339787849.9967197949.9998750549.9999962249.99999991505050

0.25040.3202752148.9596006149.9256116449.9961239349.9998447149.9999950549.99999987505050

0.26040.0034657148.8828674649.9166566549.9954560249.9998090149.9999935949.99999982505050

0.27039.6922250748.8044113449.9071067549.9947115549.9997673249.9999918149.9999997649.999999995050

0.28039.3864246848.7243164349.8969558549.9938860649.9997190149.9999896449.9999996949.999999995050

0.29039.0859393648.642663949.8861987649.9929750949.9996633949.9999870449.9999995949.999999995050

0.3038.7906472148.5595320149.8748311749.9919742149.9995997449.9999839349.9999994749.999999995050

0.31038.5004295848.4749961549.8628496149.9908790349.9995273349.9999802449.9999993249.999999985050

0.32038.2151709548.3891290249.8502513749.9896852249.9994453749.999975949.9999991349.999999975050

0.33037.9347588248.3020006649.8370344849.9883884949.9993530849.9999708349.9999989149.999999975050

0.34037.6590836548.2136785849.8231976949.9869845949.9992496149.9999649349.9999986449.999999965050

0.35037.3880387748.1242278249.8087403649.9854693749.9991341149.9999581249.9999983249.999999945050

0.36037.1215202748.0337110649.7936625349.9838387349.9990057149.9999502849.9999979349.999999935050

0.37036.8594269847.9421886749.7779647849.9820886449.9988634849.9999413149.9999974749.999999915050

0.38036.6016603247.8497188149.7616482549.9802151549.9987065149.9999310949.9999969449.999999885050

0.39036.348124347.7563575249.7447146349.9782143949.9985338449.9999195149.9999963149.999999865050

0.4036.0987253947.6621587649.7271660549.9760825949.9983445149.9999064249.9999955749.9999998249.9999999950

0.41035.8533724747.567174549.7090051549.9738160449.9981375149.9998916949.9999947349.9999997849.9999999950

0.42035.6119767747.4714547849.6902349549.9714111549.9979118349.9998751849.9999937549.9999997349.9999999950

0.43035.3744517847.3750478149.6708589149.9688643949.9976664649.9998567349.9999926249.9999996849.9999999950

0.44035.1407132247.2779999649.6508808549.9661723649.9974003449.9998361949.9999913349.9999996149.9999999850

0.45034.9106789647.180355949.6303049649.9633317249.9971124249.9998133849.9999898649.9999995349.9999999850

0.46034.6842689447.0821586249.6091357449.9603392649.9968016249.9997881349.9999881949.9999994449.9999999850

0.47034.4614051546.9834494949.58737849.9571918549.9964668649.9997602749.9999863149.9999993349.9999999750

0.48034.2420115446.8842683449.5650368549.9538864649.9961070549.999729649.9999841849.9999992149.9999999750

0.49034.0260139946.7846534549.5421176649.9504201749.9957210749.9996959249.9999817849.9999990649.9999999650

0.5033.8133402546.684641749.5186260549.9467901649.9953078149.9996590349.9999790949.999998949.9999999550