ppm of CO2 with altitude and mass of CO2 in atmosphere to 8520 metres beyond which there is practically no CO2

Excel spreadsheet extension of CRC 85th edition 2004-2005 handbook on physics and chemistry......
Equations worked out in Maple 12 by Maplesoft.

The mass of CO2 in the atmosphere is approximately 1.06186E+14 x 10^14 kg

the ppm is as listed in the attached spreadsheet.....
altitude
metres ppm at altitude
10 387.00000000000000000000
20 386.76185159877100000000
30 385.82817078570700000000
40 384.20383974867100000000
50 381.89744923045400000000
60 378.92122285673500000000
70 375.29090921052500000000
80 371.02564298657700000000
90 366.14777693898100000000
100 360.68268668780400000000
110 354.65855077049000000000
120 348.10610860632300000000
130 341.05839928301200000000
140 333.55048427047500000000
150 325.61915731533400000000
160 317.30264486918400000000
170 308.64030045348600000000
180 299.67229636420100000000
190 290.43931607115600000000
200 280.98225057251200000000
210 271.34190182616800000000
220 261.55869620114700000000
230 251.67241067665700000000
240 241.72191426947000000000
250 231.74492689624000000000
260 221.77779758182900000000
270 211.85530361301600000000
280 202.01047191470200000000
290 192.27442359850200000000
300 182.67624230670000000000
310 173.24286665324200000000
320 163.99900675246900000000
330 154.96708453023400000000
340 146.16719723472000000000
350 137.61710330923600000000
360 129.33222955940500000000
370 121.32569834461500000000
380 113.60837335032300000000
390 106.18892235458400000000
400 99.07389528975620000000
410 92.26781581845380000000
420 85.77328459101490000000
430 79.59109232884300000000
440 73.72034088246330000000
450 68.15857044316120000000
460 62.90189114032850000000
470 57.94511733074750000000
480 53.28190297830050000000
490 48.90487663021410000000
500 44.80577461612830000000
510 40.97557122615290000000
520 37.40460476085430000000
530 34.08269848712660000000
540 30.99927567659320000000
550 28.14346804519190000000
560 25.50421705178460000000
570 23.07036764806470000000
580 20.83075420005920000000
590 18.77427842172850000000
600 16.88997927240330000000
610 15.16709487118830000000
620 13.59511657237360000000
630 12.16383542593470000000
640 10.86338131620020000000
650 9.68425512977765000000
660 8.61735435105480000000
670 7.65399252044431000000
680 6.78591301752004000000
690 6.00529764895134000000
700 5.30477053039889000000
710 4.67739775308498000000
720 4.11668332042875000000
730 3.61656182880314000000
740 3.17138834998738000000
750 2.77592595211094000000
760 2.42533127163378000000
770 2.11513852197425000000
780 1.84124229551235000000
790 1.59987948554703000000
800 1.38761062398650000000
810 1.20130089965321000000
820 1.03810109157334000000
830 0.89542862190846200000
840 0.77094890462256300000
850 0.66255713884266100000
860 0.56836067038644500000
870 0.48666202125885400000
880 0.41594266517162400000
890 0.35484760737780000000
900 0.30217080935812000000
910 0.25684148313147400000
920 0.21791126614026400000
930 0.18454227571020500000
940 0.15599603190939900000
950 0.13162322912324600000
960 0.11085432969886700000
970 0.09319094746621230000
980 0.07819798467976060000
990 0.06549648281078310000
1000 0.05475714552293770000
1010 0.04569449095496990000
1020 0.03806158999023150000
1030 0.03164534739751640000
1040 0.02626228347300290000
1050 0.02175477499930330000
1060 0.01798771587414780000
1070 0.01484555956670100000
1080 0.01222970756170910000
1090 0.01005621008733240000
1100 0.00825374763691017000
1110 0.00676186404146286000
1120 0.00552942408938573000
1130 0.00451327089045774000
1140 0.00367706031717187000
1150 0.00299025190737870000
1160 0.00242723756320068000
1170 0.00196659122140027000
1180 0.00159042439292143000
1190 0.00128383407044140000
1200 0.00103443098142643000
1210 0.00083193752154388100
1220 0.00066784594228105200
1230 0.00053512849157438400
1240 0.00042799222252310900
1250 0.00034167209895248800
1260 0.00027225684429881000
1270 0.00021654270888260600
1280 0.00017191097708793300
1290 0.00013622560719719400
1300 0.00010774789940495600
1310 0.00008506552836279810
1320 0.00006703366168599740
1330 0.00005272622101543860
1340 0.00004139563291548440
1350 0.00003243966813331930
1360 0.00002537418416700790
1370 0.00001981077189887980
1380 0.00001543846606099760
1390 0.00001200881494273920
1400 0.00000932372009890216
1410 0.00000722555460497542
1420 0.00000558915105647746
1430 0.00000431532015639464
1440 0.00000332561925173202
1450 0.00000255813920283047
1460 0.00000196411892001488
1470 0.00000150523101335458
1480 0.00000115141033555938
1490 0.00000087912066839833
1500 0.00000066997419108885
1510 0.00000050963434138191
1520 0.00000038694580292827
1530 0.00000029324610551257
1540 0.00000022182211254974
1550 0.00000016748183316407
1560 0.00000012621781946281
1570 0.00000009494313158596
1580 0.00000007128467223037
1590 0.00000005342177337065
1600 0.00000003996039719113
1610 0.00000002983530330852
1620 0.00000002223412775114
1630 0.00000001653859177149
1640 0.00000001227907247221
1650 0.00000000909957303225
1660 0.00000000673076917652
1670 0.00000000496931379812
1680 0.00000000366198028721
1690 0.00000000269353888659
1700 0.00000000197750676374
1710 0.00000000144910547654
1720 0.00000000105991032431
1730 0.00000000077379365462
1740 0.00000000056385564711
1750 0.00000000041010705966
1760 0.00000000029772335823
1770 0.00000000021573208317
1780 0.00000000015602799989
1790 0.00000000011263571838
1800 0.00000000008115874533
1810 0.00000000005836868731
1820 0.00000000004189958776
1830 0.00000000003002096217
1840 0.00000000002146961758
1850 0.00000000001532528874
1860 0.00000000001091886482
1870 0.00000000000776480566
1880 0.00000000000551147421
1890 0.00000000000390471075
1900 0.00000000000276117330
1910 0.00000000000194886602
1920 0.00000000000137294655
1930 0.00000000000096540250
1940 0.00000000000067755751
1950 0.00000000000047464254
1960 0.00000000000033187133
1970 0.00000000000023160887
1980 0.00000000000016133286
1990 0.00000000000011216891
2000 0.00000000000007784020
2010 0.00000000000005391592
2020 0.00000000000003727447
2030 0.00000000000002572097
2040 0.00000000000001771512
2050 0.00000000000001217816
2060 0.00000000000000835603
2070 0.00000000000000572267
2080 0.00000000000000391181
2090 0.00000000000000266893
2100 0.00000000000000181751
2110 0.00000000000000123536
2120 0.00000000000000083810
2130 0.00000000000000056751
2140 0.00000000000000038356
2150 0.00000000000000025874
2160 0.00000000000000017421
2170 0.00000000000000011708
2180 0.00000000000000007853
2190 0.00000000000000005258
2200 0.00000000000000003513
2210 0.00000000000000002343
2220 0.00000000000000001560
2230 0.00000000000000001036
2240 0.00000000000000000687
2250 0.00000000000000000455
2260 0.00000000000000000301
2270 0.00000000000000000198
2280 0.00000000000000000130
2290 0.00000000000000000086
2300 0.00000000000000000056
2310 0.00000000000000000037
2320 0.00000000000000000024
2330 0.00000000000000000016
2340 0.00000000000000000010
2350 0.00000000000000000007
2360 0.00000000000000000004
2370 0.00000000000000000003
2380 0.00000000000000000002
2390 0.00000000000000000001
2400 0.00000000000000000001
2410 0.00000000000000000000
There is a research group in the States that has done high altitude analytical chemistry of the atmosphere and has detected significant amounts of CO2 up there, mostly due to high altitude currents, airplane exhaust, and stochastic brownian motion..... eventually it should sink to the earth and take its place in the mass of CO2 that exists under self partial pressure according to the formulas in the spreadsheet. This may take quite some time to settle.

I've been diagnosed with a schizoid disorder and have a heart condition.
if this post and software has been beneficial to you in the interests of the green party
1) Please make a donation to the green party of canada.
2) if you have any unanswered questions about the software, please email chondrally atyahoodotca
3) if you feel inclined, please make a donation to chondrally atyahoodotca via PayPal in an amount you can reasonably afford to support the continuation of this type of work.

thankyou,
Sincerely,
Richard