A -----> P k1 = 0.05 sec-1 t0> 100 0 mol m-3 step t= 1 sec t At P(t) dA/dt =dP/dt v=dA/(-1*dt) v=dP/(1*dt) 0 100 0 100 1 95.12294245 4.87705755 100 -4.87705755 4.87705755 4.87705755 4.87705755 2 90.4837418 9.516258196 100 -4.639200646 4.639200646 4.639200646 4.639200646 3 86.07079764 13.92920236 100 -4.412944161 4.412944161 4.412944161 4.412944161 4 81.87307531 18.12692469 100 -4.197722335 4.197722335 4.197722335 4.197722335 5 77.88007831 22.11992169 100 -3.992997001 3.992997001 3.992997001 3.992997001 6 74.08182207 25.91817793 100 -3.798256239 3.798256239 3.798256239 3.798256239 7 70.46880897 29.53119103 100 -3.613013096 3.613013096 3.613013096 3.613013096 8 67.0320046 32.9679954 100 -3.436804368 3.436804368 3.436804368 3.436804368 9 63.76281516 36.23718484 100 -3.269189441 3.269189441 3.269189441 3.269189441 10 60.65306597 39.34693403 100 -3.109749191 3.109749191 3.109749191 3.109749191 11 57.69498104 42.30501896 100 -2.958084933 2.958084933 2.958084933 2.958084933 12 54.88116361 45.11883639 100 -2.813817429 2.813817429 2.813817429 2.813817429 13 52.20457768 47.79542232 100 -2.676585933 2.676585933 2.676585933 2.676585933 14 49.65853038 50.34146962 100 -2.546047297 2.546047297 2.546047297 2.546047297 15 47.23665527 52.76334473 100 -2.421875105 2.421875105 2.421875105 2.421875105 16 44.93289641 55.06710359 100 -2.303758862 2.303758862 2.303758862 2.303758862 17 42.74149319 57.25850681 100 -2.191403217 2.191403217 2.191403217 2.191403217 18 40.65696597 59.34303403 100 -2.084527221 2.084527221 2.084527221 2.084527221 19 38.67410235 61.32589765 100 -1.982863629 1.982863629 1.982863629 1.982863629 20 36.78794412 63.21205588 100 -1.886158228 1.886158228 1.886158228 1.886158228 21 34.99377491 65.00622509 100 -1.794169206 1.794169206 1.794169206 1.794169206 22 33.28710837 66.71289163 100 -1.706666541 1.706666541 1.706666541 1.706666541 23 31.66367694 68.33632306 100 -1.623431432 1.623431432 1.623431432 1.623431432 24 30.11942119 69.88057881 100 -1.544255747 1.544255747 1.544255747 1.544255747 25 28.65047969 71.34952031 100 -1.468941505 1.468941505 1.468941505 1.468941505 26 27.2531793 72.7468207 100 -1.397300383 1.397300383 1.397300383 1.397300383 27 25.92402606 74.07597394 100 -1.329153239 1.329153239 1.329153239 1.329153239 28 24.65969639 75.34030361 100 -1.26432967 1.26432967 1.26432967 1.26432967 29 23.45702881 76.54297119 100 -1.202667585 1.202667585 1.202667585 1.202667585 30 22.31301601 77.68698399 100 -1.144012795 1.144012795 1.144012795 1.144012795 31 21.22479738 78.77520262 100 -1.088218632 1.088218632 1.088218632 1.088218632 32 20.1896518 79.8103482 100 -1.035145583 1.035145583 1.035145583 1.035145583 33 19.20499086 80.79500914 100 -0.984660937 0.984660937 0.984660937 0.984660937 34 18.26835241 81.73164759 100 -0.936638457 0.936638457 0.936638457 0.936638457 35 17.37739435 82.62260565 100 -0.89095806 0.89095806 0.89095806 0.89095806 36 16.52988882 83.47011118 100 -0.847505523 0.847505523 0.847505523 0.847505523 37 15.72371663 84.27628337 100 -0.806172191 0.806172191 0.806172191 0.806172191 38 14.95686192 85.04313808 100 -0.766854709 0.766854709 0.766854709 0.766854709 39 14.22740716 85.77259284 100 -0.729454764 0.729454764 0.729454764 0.729454764 40 13.53352832 86.46647168 100 -0.693878835 0.693878835 0.693878835 0.693878835 41 12.87349036 87.12650964 100 -0.660037965 0.660037965 0.660037965 0.660037965 42 12.24564283 87.75435717 100 -0.627847533 0.627847533 0.627847533 0.627847533 43 11.64841578 88.35158422 100 -0.597227048 0.597227048 0.597227048 0.597227048 44 11.08031584 88.91968416 100 -0.568099941 0.568099941 0.568099941 0.568099941 45 10.53992246 89.46007754 100 -0.54039338 0.54039338 0.54039338 0.54039338 46 10.02588437 89.97411563 100 -0.514038084 0.514038084 0.514038084 0.514038084 47 9.536916222 90.46308378 100 -0.488968151 0.488968151 0.488968151 0.488968151 48 9.071795329 90.92820467 100 -0.465120893 0.465120893 0.465120893 0.465120893 49 8.62935865 91.37064135 100 -0.442436679 0.442436679 0.442436679 0.442436679 50 8.208499862 91.79150014 100 -0.420858788 0.420858788 0.420858788 0.420858788 51 7.8081666 92.1918334 100 -0.400333262 0.400333262 0.400333262 0.400333262 ##### Sheet/List 2 ##### A -----> P k1 = 0.05 sec-1 t0> 100 0 mol m-3 dt= 1 sec step t= 1 sec dopočty I=Io+vI*s Anal Num t At P(t) dA/dt =dP/dt v=dA/(-1*dt) v=dB/(1*dt) A(t+dt)=A(t)-dt*k*A(t) ds(t+dt)=s(t)+dt*k*A(t)=s(t)+dt*k*(A0-s) A B A+B 0 100 0 100 100 0 100 0 100 1 95.12294245 4.87705755 100 -4.87705755 4.87705755 4.87705755 4.87705755 95 5 95 5 100 2 90.4837418 9.516258196 100 -4.639200646 4.639200646 4.639200646 4.639200646 90.25 9.75 90.25 9.75 100 3 86.07079764 13.92920236 100 -4.412944161 4.412944161 4.412944161 4.412944161 85.7375 14.2625 85.7375 14.2625 100 4 81.87307531 18.12692469 100 -4.197722335 4.197722335 4.197722335 4.197722335 81.450625 18.549375 81.450625 18.549375 100 5 77.88007831 22.11992169 100 -3.992997001 3.992997001 3.992997001 3.992997001 77.37809375 22.62190625 77.37809375 22.62190625 100 6 74.08182207 25.91817793 100 -3.798256239 3.798256239 3.798256239 3.798256239 73.50918906 26.49081094 73.50918906 26.49081094 100 7 70.46880897 29.53119103 100 -3.613013096 3.613013096 3.613013096 3.613013096 69.83372961 30.16627039 69.83372961 30.16627039 100 8 67.0320046 32.9679954 100 -3.436804368 3.436804368 3.436804368 3.436804368 66.34204313 33.65795687 66.34204313 33.65795687 100 9 63.76281516 36.23718484 100 -3.269189441 3.269189441 3.269189441 3.269189441 63.02494097 36.97505903 63.02494097 36.97505903 100 10 60.65306597 39.34693403 100 -3.109749191 3.109749191 3.109749191 3.109749191 59.87369392 40.12630608 59.87369392 40.12630608 100 11 57.69498104 42.30501896 100 -2.958084933 2.958084933 2.958084933 2.958084933 56.88000923 43.11999077 56.88000923 43.11999077 100 12 54.88116361 45.11883639 100 -2.813817429 2.813817429 2.813817429 2.813817429 54.03600877 45.96399123 54.03600877 45.96399123 100 13 52.20457768 47.79542232 100 -2.676585933 2.676585933 2.676585933 2.676585933 51.33420833 48.66579167 51.33420833 48.66579167 100 14 49.65853038 50.34146962 100 -2.546047297 2.546047297 2.546047297 2.546047297 48.76749791 51.23250209 48.76749791 51.23250209 100 15 47.23665527 52.76334473 100 -2.421875105 2.421875105 2.421875105 2.421875105 46.32912302 53.67087698 46.32912302 53.67087698 100 16 44.93289641 55.06710359 100 -2.303758862 2.303758862 2.303758862 2.303758862 44.01266687 55.98733313 44.01266687 55.98733313 100 17 42.74149319 57.25850681 100 -2.191403217 2.191403217 2.191403217 2.191403217 41.81203352 58.18796648 41.81203352 58.18796648 100 18 40.65696597 59.34303403 100 -2.084527221 2.084527221 2.084527221 2.084527221 39.72143185 60.27856815 39.72143185 60.27856815 100 19 38.67410235 61.32589765 100 -1.982863629 1.982863629 1.982863629 1.982863629 37.73536025 62.26463975 37.73536025 62.26463975 100 20 36.78794412 63.21205588 100 -1.886158228 1.886158228 1.886158228 1.886158228 35.84859224 64.15140776 35.84859224 64.15140776 100 21 34.99377491 65.00622509 100 -1.794169206 1.794169206 1.794169206 1.794169206 34.05616263 65.94383737 34.05616263 65.94383737 100 22 33.28710837 66.71289163 100 -1.706666541 1.706666541 1.706666541 1.706666541 32.3533545 67.6466455 32.3533545 67.6466455 100 23 31.66367694 68.33632306 100 -1.623431432 1.623431432 1.623431432 1.623431432 30.73568677 69.26431323 30.73568677 69.26431323 100 24 30.11942119 69.88057881 100 -1.544255747 1.544255747 1.544255747 1.544255747 29.19890243 70.80109757 29.19890243 70.80109757 100 25 28.65047969 71.34952031 100 -1.468941505 1.468941505 1.468941505 1.468941505 27.73895731 72.26104269 27.73895731 72.26104269 100 26 27.2531793 72.7468207 100 -1.397300383 1.397300383 1.397300383 1.397300383 26.35200945 73.64799055 26.35200945 73.64799055 100 27 25.92402606 74.07597394 100 -1.329153239 1.329153239 1.329153239 1.329153239 25.03440897 74.96559103 25.03440897 74.96559103 100 28 24.65969639 75.34030361 100 -1.26432967 1.26432967 1.26432967 1.26432967 23.78268853 76.21731147 23.78268853 76.21731147 100 29 23.45702881 76.54297119 100 -1.202667585 1.202667585 1.202667585 1.202667585 22.5935541 77.4064459 22.5935541 77.4064459 100 30 22.31301601 77.68698399 100 -1.144012795 1.144012795 1.144012795 1.144012795 21.46387639 78.53612361 21.46387639 78.53612361 100 31 21.22479738 78.77520262 100 -1.088218632 1.088218632 1.088218632 1.088218632 20.39068257 79.60931743 20.39068257 79.60931743 100 32 20.1896518 79.8103482 100 -1.035145583 1.035145583 1.035145583 1.035145583 19.37114845 80.62885155 19.37114845 80.62885155 100 33 19.20499086 80.79500914 100 -0.984660937 0.984660937 0.984660937 0.984660937 18.40259102 81.59740898 18.40259102 81.59740898 100 34 18.26835241 81.73164759 100 -0.936638457 0.936638457 0.936638457 0.936638457 17.48246147 82.51753853 17.48246147 82.51753853 100 35 17.37739435 82.62260565 100 -0.89095806 0.89095806 0.89095806 0.89095806 16.6083384 83.3916616 16.6083384 83.3916616 100 36 16.52988882 83.47011118 100 -0.847505523 0.847505523 0.847505523 0.847505523 15.77792148 84.22207852 15.77792148 84.22207852 100 37 15.72371663 84.27628337 100 -0.806172191 0.806172191 0.806172191 0.806172191 14.9890254 85.0109746 14.9890254 85.0109746 100 38 14.95686192 85.04313808 100 -0.766854709 0.766854709 0.766854709 0.766854709 14.23957413 85.76042587 14.23957413 85.76042587 100 39 14.22740716 85.77259284 100 -0.729454764 0.729454764 0.729454764 0.729454764 13.52759543 86.47240457 13.52759543 86.47240457 100 40 13.53352832 86.46647168 100 -0.693878835 0.693878835 0.693878835 0.693878835 12.85121566 87.14878434 12.85121566 87.14878434 100 41 12.87349036 87.12650964 100 -0.660037965 0.660037965 0.660037965 0.660037965 12.20865487 87.79134513 12.20865487 87.79134513 100 42 12.24564283 87.75435717 100 -0.627847533 0.627847533 0.627847533 0.627847533 11.59822213 88.40177787 11.59822213 88.40177787 100 43 11.64841578 88.35158422 100 -0.597227048 0.597227048 0.597227048 0.597227048 11.01831102 88.98168898 11.01831102 88.98168898 100 44 11.08031584 88.91968416 100 -0.568099941 0.568099941 0.568099941 0.568099941 10.46739547 89.53260453 10.46739547 89.53260453 100 45 10.53992246 89.46007754 100 -0.54039338 0.54039338 0.54039338 0.54039338 9.944025699 90.0559743 9.944025699 90.0559743 100 46 10.02588437 89.97411563 100 -0.514038084 0.514038084 0.514038084 0.514038084 9.446824414 90.55317559 9.446824414 90.55317559 100 47 9.536916222 90.46308378 100 -0.488968151 0.488968151 0.488968151 0.488968151 8.974483193 91.02551681 8.974483193 91.02551681 100 48 9.071795329 90.92820467 100 -0.465120893 0.465120893 0.465120893 0.465120893 8.525759033 91.47424097 8.525759033 91.47424097 100 49 8.62935865 91.37064135 100 -0.442436679 0.442436679 0.442436679 0.442436679 8.099471082 91.90052892 8.099471082 91.90052892 100 50 8.208499862 91.79150014 100 -0.420858788 0.420858788 0.420858788 0.420858788 7.694497528 92.30550247 7.694497528 92.30550247 100 51 7.8081666 92.1918334 100 -0.400333262 0.400333262 0.400333262 0.400333262 7.309772651 92.69022735 7.309772651 92.69022735 100 ##### Sheet/List 3 ##### A -----> P k1 = 0.05 sec-1 t0> 100 0 mol m-3 dt= 1 sec-1 step t= 1 sec t At P(t) dA/dt =dP/dt v=dA/(-1*dt) v=dP/(1*dt) A(num) s B 0 100 0 100 100.000 0 0 1 95.12294245 4.87705755 100 -4.87705755 4.87705755 4.87705755 4.87705755 95.000 5 5 2 90.4837418 9.516258196 100 -4.639200646 4.639200646 4.639200646 4.639200646 90.250 9.75 9.75 3 86.07079764 13.92920236 100 -4.412944161 4.412944161 4.412944161 4.412944161 85.738 14.2625 14.2625 4 81.87307531 18.12692469 100 -4.197722335 4.197722335 4.197722335 4.197722335 81.451 18.549375 18.549375 5 77.88007831 22.11992169 100 -3.992997001 3.992997001 3.992997001 3.992997001 77.378 22.62190625 22.62190625 6 74.08182207 25.91817793 100 -3.798256239 3.798256239 3.798256239 3.798256239 73.509 26.49081094 26.49081094 7 70.46880897 29.53119103 100 -3.613013096 3.613013096 3.613013096 3.613013096 69.834 30.16627039 30.16627039 8 67.0320046 32.9679954 100 -3.436804368 3.436804368 3.436804368 3.436804368 66.342 33.65795687 33.65795687 9 63.76281516 36.23718484 100 -3.269189441 3.269189441 3.269189441 3.269189441 63.025 36.97505903 36.97505903 10 60.65306597 39.34693403 100 -3.109749191 3.109749191 3.109749191 3.109749191 59.874 40.12630608 40.12630608 11 57.69498104 42.30501896 100 -2.958084933 2.958084933 2.958084933 2.958084933 56.880 43.11999077 43.11999077 12 54.88116361 45.11883639 100 -2.813817429 2.813817429 2.813817429 2.813817429 54.036 45.96399123 45.96399123 13 52.20457768 47.79542232 100 -2.676585933 2.676585933 2.676585933 2.676585933 51.334 48.66579167 48.66579167 14 49.65853038 50.34146962 100 -2.546047297 2.546047297 2.546047297 2.546047297 48.767 51.23250209 51.23250209 15 47.23665527 52.76334473 100 -2.421875105 2.421875105 2.421875105 2.421875105 46.329 53.67087698 53.67087698 16 44.93289641 55.06710359 100 -2.303758862 2.303758862 2.303758862 2.303758862 44.013 55.98733313 55.98733313 17 42.74149319 57.25850681 100 -2.191403217 2.191403217 2.191403217 2.191403217 41.812 58.18796648 58.18796648 18 40.65696597 59.34303403 100 -2.084527221 2.084527221 2.084527221 2.084527221 39.721 60.27856815 60.27856815 19 38.67410235 61.32589765 100 -1.982863629 1.982863629 1.982863629 1.982863629 37.735 62.26463975 62.26463975 20 36.78794412 63.21205588 100 -1.886158228 1.886158228 1.886158228 1.886158228 35.849 64.15140776 64.15140776 21 34.99377491 65.00622509 100 -1.794169206 1.794169206 1.794169206 1.794169206 34.056 65.94383737 65.94383737 22 33.28710837 66.71289163 100 -1.706666541 1.706666541 1.706666541 1.706666541 32.353 67.6466455 67.6466455 23 31.66367694 68.33632306 100 -1.623431432 1.623431432 1.623431432 1.623431432 30.736 69.26431323 69.26431323 24 30.11942119 69.88057881 100 -1.544255747 1.544255747 1.544255747 1.544255747 29.199 70.80109757 70.80109757 25 28.65047969 71.34952031 100 -1.468941505 1.468941505 1.468941505 1.468941505 27.739 72.26104269 72.26104269 26 27.2531793 72.7468207 100 -1.397300383 1.397300383 1.397300383 1.397300383 26.352 73.64799055 73.64799055 27 25.92402606 74.07597394 100 -1.329153239 1.329153239 1.329153239 1.329153239 25.034 74.96559103 74.96559103 28 24.65969639 75.34030361 100 -1.26432967 1.26432967 1.26432967 1.26432967 23.783 76.21731147 76.21731147 29 23.45702881 76.54297119 100 -1.202667585 1.202667585 1.202667585 1.202667585 22.594 77.4064459 77.4064459 30 22.31301601 77.68698399 100 -1.144012795 1.144012795 1.144012795 1.144012795 21.464 78.53612361 78.53612361 31 21.22479738 78.77520262 100 -1.088218632 1.088218632 1.088218632 1.088218632 20.391 79.60931743 79.60931743 32 20.1896518 79.8103482 100 -1.035145583 1.035145583 1.035145583 1.035145583 19.371 80.62885155 80.62885155 33 19.20499086 80.79500914 100 -0.984660937 0.984660937 0.984660937 0.984660937 18.403 81.59740898 81.59740898 34 18.26835241 81.73164759 100 -0.936638457 0.936638457 0.936638457 0.936638457 17.482 82.51753853 82.51753853 35 17.37739435 82.62260565 100 -0.89095806 0.89095806 0.89095806 0.89095806 16.608 83.3916616 83.3916616 36 16.52988882 83.47011118 100 -0.847505523 0.847505523 0.847505523 0.847505523 15.778 84.22207852 84.22207852 37 15.72371663 84.27628337 100 -0.806172191 0.806172191 0.806172191 0.806172191 14.989 85.0109746 85.0109746 38 14.95686192 85.04313808 100 -0.766854709 0.766854709 0.766854709 0.766854709 14.240 85.76042587 85.76042587 39 14.22740716 85.77259284 100 -0.729454764 0.729454764 0.729454764 0.729454764 13.528 86.47240457 86.47240457 40 13.53352832 86.46647168 100 -0.693878835 0.693878835 0.693878835 0.693878835 12.851 87.14878434 87.14878434 41 12.87349036 87.12650964 100 -0.660037965 0.660037965 0.660037965 0.660037965 12.209 87.79134513 87.79134513 42 12.24564283 87.75435717 100 -0.627847533 0.627847533 0.627847533 0.627847533 11.598 88.40177787 88.40177787 43 11.64841578 88.35158422 100 -0.597227048 0.597227048 0.597227048 0.597227048 11.018 88.98168898 88.98168898 44 11.08031584 88.91968416 100 -0.568099941 0.568099941 0.568099941 0.568099941 10.467 89.53260453 89.53260453 45 10.53992246 89.46007754 100 -0.54039338 0.54039338 0.54039338 0.54039338 9.944 90.0559743 90.0559743 46 10.02588437 89.97411563 100 -0.514038084 0.514038084 0.514038084 0.514038084 9.447 90.55317559 90.55317559 47 9.536916222 90.46308378 100 -0.488968151 0.488968151 0.488968151 0.488968151 8.974 91.02551681 91.02551681 48 9.071795329 90.92820467 100 -0.465120893 0.465120893 0.465120893 0.465120893 8.526 91.47424097 91.47424097 49 8.62935865 91.37064135 100 -0.442436679 0.442436679 0.442436679 0.442436679 8.099 91.90052892 91.90052892 50 8.208499862 91.79150014 100 -0.420858788 0.420858788 0.420858788 0.420858788 7.694 92.30550247 92.30550247 51 7.8081666 92.1918334 100 -0.400333262 0.400333262 0.400333262 0.400333262 7.310 92.69022735 92.69022735