{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["HH Income","OIE Population","OIE Carbon Calcs","OIE GHG Calcs","OIE Plastics","OIE Poverty"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HH Income","index":0,"n_rows":95,"n_cols":14,"rows_kept":95,"cut":false,"hidden":false,"merged":[[70,0,70,10],[66,0,66,10],[67,0,67,10],[14,0,14,10],[1,0,1,13],[2,0,2,10],[80,0,80,10],[49,11,49,13],[18,11,18,13],[24,11,24,13],[14,11,14,13],[75,0,75,10],[72,0,72,10],[93,0,93,10],[94,0,94,10],[84,0,84,10],[83,0,83,10],[90,0,90,10],[91,0,91,10],[87,0,87,10],[88,0,88,10],[81,0,81,10],[92,0,92,10],[85,0,85,10],[82,0,82,10],[74,0,74,10],[73,0,73,10],[77,0,77,10],[76,0,76,10],[78,0,78,10],[79,0,79,10],[68,0,68,10],[69,0,69,10]]}
[]
["Own It Economics"]
["US Household (HH) Income by Class"]
[]
["US Population in 2014",{"$nulls":6},"The Lower Class*"]
[3.186E8,{"$nulls":6},"% HH Pop.",{"$f":"L20","v":0.2191746755}]
["US Median Income in 2014",null,null,"...in 2017 $",null,"...in 2018 $",null,"% HH Inc.",{"$f":"M20","v":0.0598430373}]
[{"$f":"ROUNDUP(53657,-3)","v":54000},null,null,{"$f":"ROUNDUP(A8*1.04,-3)","v":57000},null,{"$f":"ROUNDUP(A8*1.0645,-3)","v":58000},null,"The Middle Class*"]
["67% of Median Income in 2014",null,null,"...in 2017 $",null,"...in 2018 $",null,"% HH Pop.",{"$f":"L26","v":0.6521013533}]
[{"$f":"ROUNDDOWN(A8*0.67,-3)","v":36000},null,null,{"$f":"ROUNDUP(A10*1.04,-3)","v":38000},null,{"$f":"ROUNDDOWN(A10*1.0645,-3)","v":38000},null,"% HH Inc.",{"$f":"M26","v":0.5945290515}]
["200% of Median Income in 2014",null,null,"...in 2017 $",null,"...in 2018 $",null,"The Upper Class*"]
[{"$f":"ROUNDUP(A8*2,-3)","v":108000},null,null,{"$f":"ROUNDUP(A12*1.04,-3)","v":113000},null,{"$f":"ROUNDUP(A12*1.0645,-3)","v":115000},null,"% HH Pop.",{"$f":"L51","v":0.1287239712}]
[{"$nulls":7},"% HH Inc.",{"$f":"M51","v":0.3456128732}]
[]
["Census Data Distribution of Household Income, 2014",{"$nulls":10},"Own It Classification"]
[]
["HH Income","Number of HH (1000)","Percent","Percentile","Mean Income","Mean number of earners","Mean size of HH","Population (est.)","Aggregate mean income (AMI) \n(billions)","Percent of agg. income","Mean income per day","% HH Pop.","% HH Inc.","Group AMI (billions)"]
["Total",124587.0,1.0,"—",75738.0,1.28,2.54,{"$f":"A6","v":318600000},{"$f":"B18*1000*E18/1000000000","v":9435.970206},1.0,{"$f":"E18/365","v":207.5013699}]
["Under $5,000",4571.0,0.0367,0.0,1080.0,0.2,1.91,{"$f":"B19*G19 * 1000*$H$62","v":8833501.723},4.93668,{"$f":"I19/$I$18","v":0.0005231767261},2.95890411,"The Lower Class"]
["$5,000 to $9,999",4320.0,0.0347,"3.67th",7936.0,0.34,1.78,7780223.243,34.28352,0.003633279806,21.74246575,{"$f":"SUM(H19:H24)/$H$61","v":0.2191746755},{"$f":"SUM(J19:J24)","v":0.0598430373},{"$f":"SUM(I19:I24)","v":564.677117}]
["$10,000 to $14,999",6766.0,0.0543,"7.14th",12317.0,0.39,1.71,11706212.77,83.336822,0.008831823351,33.74520548]
["$15,000 to $19,999",6779.0,0.0544,"12.57th",17338.0,0.54,1.9,13031894.17,117.534302,0.01245598486,47.50136986]
["$20,000 to $24,999",6865.0,0.0551,"18.01th",22162.0,0.73,2.07,14378023.75,152.14213,0.016123634,60.71780822]
["$25,000 to $29,999",6363.0,0.0511,"23.52th",27101.0,0.82,2.19,14099195.99,172.443663,0.01827513856,74.24931507]
["$30,000 to $34,999",6232.0,0.05,"28.63th",32058.0,0.94,2.27,14313360.56,199.785456,0.02117275189,87.83013699,"The Middle Class"]
["$35,000 to $39,999",5857.0,0.047,"33.63th",37061.0,1.04,2.31,13689119.46,217.066277,0.02300412912,101.5369863,{"$f":"SUM(H25:H49)/$H$61","v":0.6521013533},{"$f":"SUM(J25:J49)","v":0.5945290515},{"$f":"SUM(I25:I49)","v":5609.958417}]
["$40,000 to $44,999",5430.0,0.0436,"38.33th",41979.0,1.15,2.4,13185584.34,227.94597,0.02415713117,115.0109589]
["$45,000 to $49,999",5060.0,0.0406,"42.69th",47207.0,1.24,2.52,12901475.06,238.86742,0.02531455852,129.3342466]
["$50,000 to $54,999",5084.0,0.0408,"46.75th",51986.0,1.32,2.54,13065546.14,264.296824,0.02800950175,142.4273973]
["$55,000 to $59,999",4220.0,0.0339,"50.83th",57065.0,1.41,2.56,10930517.55,240.8143,0.02552088389,156.3424658]
["$60,000 to $64,999",4477.0,0.0359,"54.22th",62016.0,1.46,2.64,11958572.22,277.645632,0.0294241743,169.9068493]
["$65,000 to $69,999",3709.0,0.0298,"57.81th",67081.0,1.51,2.67,10019738.89,248.803429,0.02636755136,183.7835616]
["$70,000 to $74,999",3737.0,0.03,"60.79th",72050.0,1.57,2.73,10322242.42,269.25085,0.02853451676,197.3972603]
["$75,000 to $79,999",3484.0,0.028,"63.79th",77023.0,1.6,2.79,9834916.095,268.348132,0.02843884902,211.0219178]
["$80,000 to $84,999",3142.0,0.0252,"66.58th",81966.0,1.63,2.79,8869490.922,257.537172,0.02729313111,224.5643836]
["$85,000 to $89,999",2750.0,0.0221,"69.11th",87101.0,1.77,2.9,8068986.731,239.52775,0.02538453861,238.6328767]
["$90,000 to $94,999",2665.0,0.0214,"71.31th",92033.0,1.82,2.96,7981366.135,245.267945,0.0259928698,252.1452055]
["$95,000 to $99,999",2339.0,0.0188,"73.45th",97161.0,1.81,2.97,7028699.573,227.259579,0.02408438921,266.1945205]
["$100,000 to $104,999",2679.0,0.0215,"75.33th",101921.0,1.79,3.01,8158823.136,273.046359,0.0289367551,279.2356164]
["$105,000 to $109,999",2070.0,0.0166,"77.48th",107187.0,1.88,3.01,6304129.859,221.87709,0.02351396678,293.6630137]
["$110,000 to $114,999",1922.0,0.0154,"79.14th",112069.0,1.93,3.12,6067311.422,215.396618,0.02282718293,307.0383562]
["$115,000 to $119,999",1623.0,0.013,"80.68th",117133.0,1.98,3.14,5156279.819,190.106859,0.02014703892,320.9123288]
["$120,000 to $124,999",1863.0,0.015,"81.99th",122127.0,1.93,3.09,5824513.335,227.522601,0.02411226361,334.5945205]
["$125,000 to $129,999",1452.0,0.0117,"83.48th",127166.0,1.99,3.12,4583629.649,184.645032,0.01956820846,348.4]
["$130,000 to $134,999",1512.0,0.0121,"84.65th",131863.0,2.0,3.18,4864824.983,199.376856,0.02112944951,361.2684932]
["$135,000 to $139,999",1219.0,0.0098,"85.86th",137284.0,1.98,3.11,3835768.64,167.349196,0.01773523997,376.1205479]
["$140,000 to $144,999",1290.0,0.0104,"86.84th",142199.0,1.97,3.03,3954764.694,183.43671,0.01944015358,389.5863014]
["$145,000 to $149,999",1024.0,0.0082,"87.87th",147130.0,2.01,3.11,3222171.524,150.66112,0.01596668034,403.0958904]
["$150,000 to $154,999",1146.0,0.0092,"88.70th",151940.0,1.85,3.12,3617658.111,174.12324,0.01845313584,416.2739726]
["$155,000 to $159,999",848.0,0.0068,"89.62th",157177.0,2.08,3.15,2702680.546,133.286096,0.01412531972,430.6219178,"The Upper Class"]
["$160,000 to $164,999",875.0,0.007,"90.30th",162019.0,2.02,3.13,2771026.634,141.766625,0.0150240645,443.8876712,{"$f":"SUM(H50:H60)/$H$61","v":0.1287239712},{"$f":"SUM(J50:J60)","v":0.3456128732},{"$f":"SUM(I50:I60)","v":3261.192774}]
["$165,000 to $169,999",786.0,0.0063,"91.00th",167101.0,2.1,3.16,2513031.534,131.341386,0.01391922432,457.8109589]
["$170,000 to $174,999",717.0,0.0058,"91.63th",172169.0,2.17,3.21,2328694.394,123.445173,0.01308240386,471.6958904]
["$175,000 to $179,999",607.0,0.0049,"92.21th",177187.0,2.19,3.28,2014423.802,107.552509,0.01139813995,485.4438356]
["$180,000 to $184,999",619.0,0.005,"92.69th",182055.0,2.03,3.19,1997881.115,112.692045,0.01194281484,498.7808219]
["$185,000 to $189,999",556.0,0.0045,"93.19th",187299.0,2.03,3.2,1800168.174,104.138244,0.01103630488,513.1479452]
["$190,000 to $194,999",485.0,0.0039,"93.64th",192241.0,2.19,3.29,1614455.007,93.236885,0.009881006718,526.6876712]
["$195,000 to $199,999",436.0,0.0035,"94.03th",197211.0,2.23,3.27,1442522.353,85.983996,0.009112364084,540.3041096]
["$200,000 to $249,999",3249.0,0.0261,"94.38th",220267.0,2.08,3.24,10650819.66,715.647483,0.07584249074,603.4712329]
["$250,000 and over",3757.0,0.0302,"96.98th",402476.0,null,2.94,11175754.04,1512.102332,0.1602487396,1102.673973]
["Own It Economics Calculations: ",{"$nulls":4},"Check Totals:",null,{"$f":"SUM(H19:H60)","v":318600000.2},9435.828308,0.999984962,null,{"$f":"SUM(L19:L58)","v":1},0.999984962,9435.828308]
[{"$nulls":5},"Adjustment Factors:",null,1.01178517,0.8817]
[]
[]
["References"]
[]
["US Census Bureau. (n.d.). Income Distribution to $250,000 or More for Households   Retrieved from"]
["https://www.census.gov/data/tables/time-series/demo/income-poverty/cps-hinc/hinc-06.2014.html"]
[]
["US Census Bureau. (n.d.). Selected Characteristics of Households, by Total Money Income in 2014. Retrieved from"]
["https://www.census.gov/data/tables/time-series/demo/income-poverty/cps-hinc/hinc-01.2014.html"]
[]
["According to the Bureau of Labor Statistics consumer price index, prices in 2018 are 6.45% higher than prices in 2014."]
["Official Data Foundation/Alioth LLC. (2018). CPI Inflation Calculator. Retrieved from"]
["http://www.in2013dollars.com/2014-dollars-in-2018"]
[]
["Renwick, T. (2014, September 30).  Examining the Middle Class in the United States Using the Lens of the Supplemental Poverty Measure. Retrieved from"]
["https://www.census.gov/content/dam/Census/library/working-papers/2014/demo/SEHSD-WP2014-30.pdf"]
[]
["Distribution of Household Income. (2014).  Retrieved from "]
["https://www.census.gov/library/visualizations/2015/demo/distribution-of-household-income--2014.html"]
[]
["Credit Suisse Research Institute. (2015, October). Thought Leadership from Credit Suisse Research and the world’s foremost experts.  Retrieved from"]
["http://publications.credit-suisse.com/tasks/render/file/index.cfm?fileid=C26E3824-E868-56E0-CCA04D4BB9B9ADD5"]
[]
["* Based on 2017 surveys, from Gallup and others, finding that 62-70% of Americans self-identify as being in the middle class.  50% of those persons in one survey were found to have incomes between $50K and $125K in 2017.  Our classification begins with the Pew Research Institute standard of middle class being from 67% to 200% of median income.  This gives $36K to $108K in 2014. Then, we extend the range to $30K to $155K in 2014 dollars to capture 65% of the 2014 population.  In 2018 dollars (using a 106.4% net change in the CPI as the basis for the change in buying power), this is a range of $32K to $165K."]
[]
["Newport, F. (2017, June 21).  Middle-Class Identification in U.S. at Pre-Recession Levels.  Retrieved from"]
["https://news.gallup.com/poll/212660/middle-class-identification-pre-recession-levels.aspx"]
[]
["Martin, E.  (2017, June 30). 70% of Americans consider themselves middle class—but only 50% are Retrieved from"]
["https://www.cnbc.com/2017/06/30/70-percent-of-americans-consider-themselves-middle-class-but-only-50-percent-are.html"]
[]
["Northwestern Mutual (2017, June 21)  70% of Americans Identify as Middle Class Despite a Prolonged Decline in Middle-Income Households in the US.  Retrieved from"]
["https://news.northwesternmutual.com/2017-06-21-70-of-Americans-Identify-as-Middle-Class-Despite-a-Prolonged-Decline-in-Middle-Income-Households-in-the-US"]

{"sheet":"OIE Population","index":1,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,0,13,3],[21,0,21,3],[1,0,1,3],[2,0,2,3],[17,0,17,3],[22,0,22,3],[18,0,18,3]]}
[]
["Own It Economics"]
["Own It Participants Global Population"]
[]
[null,"Amount","Units","Notes"]
["Global Population, 2018",{"$f":"'OIE GHG Calcs'!D7","v":7633},"million persons"]
["Low income or dependants",{"$f":"B6*0.9","v":6869.7},"million persons","90% [1]"]
["OIE population (middle/high income adults) ",{"$f":"B6-B7","v":763.3},"million persons","10% [1]"]
["Low income adults",{"$f":"(B6*0.74)-B8","v":4885.12},"million persons","64% (74% minus 10%) [2]"]
["OIE percentage of adults in the world population",{"$f":"B8/(B8+B9)","v":0.1351351351}]
[]
["Assumptions"]
[]
["Approximately 10% of all persons globally are adults in middle/high income (\"middle income\" is defined as PPP equivalent of $50K or more USD 2015) in 2018."]
[]
["References"]
[]
["1  Credit Suisse Research Institute. (2015, October). Thought Leadership from Credit Suisse Research and the world’s foremost experts, p. 115. Retrieved from"]
["http://publications.credit-suisse.com/tasks/render/file/index.cfm?fileid=C26E3824-E868-56E0-CCA04D4BB9B9ADD5"]
[]
["2  \"Globally, about 26 percent of the world is under 15 years of age,\" so about 74% are adults."]
["As of 2017, in Africa, it is 41%, while in the rest of the world it ranges from 16% in Europe and 19% in North America, to 23 to 25% in Latin America, the Caribbean, Asia, and Oceania.  Retrieved from"]
["Statista. (n.d.). Proportion of selected age groups of world population in 2017, by region. Retrieved from"]
["https://www.statista.com/statistics/265759/world-population-by-age-and-region/"]

{"sheet":"OIE Carbon Calcs","index":2,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[[58,0,58,3],[57,0,57,3],[61,0,61,3],[60,0,60,3],[62,0,62,3],[50,0,50,3],[2,0,2,3],[1,0,1,3],[54,0,54,3],[55,0,55,3],[51,0,51,3],[52,0,52,3],[53,0,53,3]]}
[]
["Own It Economics"]
["Carbon Calculations"]
[]
[null,"Number","Units","Notes"]
["Global Population, 2018",{"$f":"'OIE GHG Calcs'!D7","v":7633},"million persons"]
["OIE Population (middle/high income adults), 2018",{"$f":"'OIE Population'!B8","v":763.3},"million persons","See Appendix Table \"Own It Participants Global Population\""]
[]
["Total Need, Atmospheric CO2e Reduction",{"$f":"'OIE GHG Calcs'!B14","v":2580},"Gt CO2e","See OIE GHG Table"]
["Legacy (1850 to 2020)",{"$f":"'OIE GHG Calcs'!B8-'OIE GHG Calcs'!B6","v":1135},"Gt CO2e",{"$f":"B10/(B10+B11)","v":0.4399224806}]
["Future (2020 to 2050)",{"$f":"B9-B10","v":1445},"Gt CO2e",{"$f":"B11/(B10+B11)","v":0.5600775194}]
[]
["OIE Responsibility"]
["OIE per capita",{"$f":"B9*1000000000/(B7*1000000)","v":3380.060265},"t CO2e/person"]
["OIE per capita annually, 2020-2050",{"$f":"B14/30","v":112.6686755},"t CO2e/person/year"]
["OIE per capita annually, 2020-2050, Legacy part",{"$f":"$B$15*$D10","v":49.56548321},"t CO2e/person/year",{"$f":"B10/(B10+B11)","v":0.4399224806}]
["OIE per capita annually, 2020-2050, Future part",63.10319228,"t CO2e/person/year",{"$f":"B11/(B10+B11)","v":0.5600775194}]
[]
["Unit Cost to Repair"]
["Best deals (2018)",5.0,"$/t CO2e","e.g. Mammoth Steppe strategy in Drawdown, planting trees, etc. This is for low hanging fruit, but long term cost will average much higher"]
["Typical",12.0,"$/t CO2e"]
["Drawdown estimate",30.0,"$/t CO2e","Drawdown Plausible Scenario is at about $29.6/Gt, however this may include govenment spending."]
[]
["Total Cost to Repair",{"$f":"B9*$B$21/1000","v":30.96},"$ trillion","Assuming $12/t"]
["For legacy (OIE L3)",13.62,"$ trillion"]
["For future (OIE L4)",17.34,"$ trillion"]
[]
["Total Annual (2020-2050) Cost ",{"$f":"B24/30","v":1.032},"$ trillion/year"]
["Per capita OIE population total cost",{"$f":"1000000*B24/B7","v":40560.72318},"$/person"]
["For legacy (OIE L3)",{"$f":"B29*B25/B24","v":17843.57396},"$/person"]
["For future (OIE L4)",{"$f":"B29*B26/B24","v":22717.14922},"$/person"]
["Per capita OIE population total annual cost, 2020-2050",{"$f":"B29/30","v":1352.024106},"$/person/year"]
["For legacy (OIE L3), annual, 2020-2050",{"$f":"B32*B25/B24","v":594.7857985},"$/person/year"]
["For future (OIE L4), annual, 2020-2050",{"$f":"B32*B26/B24","v":757.2383073},"$/person/year"]
[]
["OIE Adoption Rate (average, 2020-2050), estimate",0.33,null,"Assumption (comparables: global smart phone usage, 2018: 36%; Facebook 2017: 2.2 billion)"]
["Per capita OIE population gross income (GDP)",62000.0,"$/person/year","Assuming $31,000/person, $62,000/household (PPP)"]
["Share of gross income, annual, est. OIE adoption rate",{"$f":"B32/(B37*$B$36)","v":0.0660813346}]
["For legacy (OIE L3), annual, est. OIE adoption rate",{"$f":"B33/(B37*$B$36)","v":0.02907066464}]
["For future (OIE L4), annual, est. OIE adoption rate",{"$f":"B34/(B37*$B$36)","v":0.03701066996}]
[]
["Abbreviations Defined"]
[]
["$ = 2018 US dollars"]
["t = metric ton or tonne"]
["Gt CO2e = Greehhouse gass equivalent to a gigaton (billion metric tons) of CO2, based on 100-year GWP estimates"]
["PPP = purchasing power parity"]
[]
["References"]
[]
["Credit Suisse Research Institute. (2015, October). Thought Leadership from Credit Suisse Research and the world’s foremost experts, p. 115. Retrieved from"]
["http://publications.credit-suisse.com/tasks/render/file/index.cfm?fileid=C26E3824-E868-56E0-CCA04D4BB9B9ADD5"]
[]
["Hawken, Paul. Drawdown. Penguin Putnam Inc. (2017) "]
[]
["The following stats were reviewed to assess viralability of a movement.  When something makes people feel better and brings a higher quality to their lives, billions of people spending hundreds of dollars is not an issue."]
[]
["Statista.  (n.d.). Number of smartphone users worldwide from 2014 to 2020 (in billions).  Retrieved from"]
["https://www.statista.com/statistics/330695/number-of-smartphone-users-worldwide/"]
[]
["Statista (n.d.). Number of monthly active Facebook users worldwide as of 2nd quarter 2018 (in millions) Retrieved from"]
["https://www.statista.com/statistics/264810/number-of-monthly-active-facebook-users-worldwide/"]

{"sheet":"OIE GHG Calcs","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[27,0,27,4],[19,0,19,4],[20,0,20,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[36,0,36,4],[35,0,35,4],[28,0,28,4],[33,0,33,4],[32,0,32,4],[1,0,1,4],[2,0,2,4],[30,0,30,4],[29,0,29,4]]}
[]
["Own It Economics"]
["Greenhouse Gasses Calculations"]
[]
["Year (CE)","CO2e Gt \nEmissions \nOIE","CO2e Gt Emissions Business as Usual","Global Population (millions)","Notes"]
[1850.0,{"$f":"$C6","v":2230},{"$f":"2190+40","v":2230},1200.0,"Just beginning of industrialization, meaning moving from agrarian to factories.  GDP rises, large family networks are no longer concentrated."]
[2018.0,3290,{"$f":"3190+100","v":3290},7633.0,"Today"]
[2020.0,{"$f":"B7+75","v":3365},{"$f":"C7+75+5","v":3370},null,"Start of Drawdown scenarios"]
[2030.0,{"$f":"$C9-(B$14/3)","v":2990},{"$f":"C8+(48*10)","v":3850},8500.0]
[2040.0,{"$f":"$C10-(2*B$14/3)","v":2610},4330]
[2050.0,{"$f":"$C11-(3*B$14/3)","v":2230},4810,9700.0,"End of Drawdown scenarios"]
["Add'l CO2e Gt 2020-2050",{"$f":"B11-B8","v":-1135},1440]
["CO2e Increase Since 1850",{"$f":"B11-B6","v":0},2580]
["CO2e Gt Sequestered with OIE Plan",{"$f":"C13","v":2580},0.0]
["Average Annual Rate of CO2e Sequestration Gt per year by OIE population",{"$f":"B14/30","v":86},0.0]
[]
["Assumptions"]
[]
["Legacy anthropogenic methane estimated to be 40 Gt CO2e up to 1850."]
["Anthropogenic methane added 1850 to 2018 estimated to be 60 Gt CO2e based on 2016 atmospheric readings and 1850 estimate."]
["While earlier and later dates defining the \"pre-industrial\" era are sometimes advocated by climate scientists, 1850 is used here."]
[]
["References"]
[]
["Hawken, Paul. Drawdown:  the most coprehensive plan ever proposed to reverse global warming. New York:  Penguin Books 2017"]
[]
["Global CH4 Levels (n.d.)"]
["http://www.methanelevels.org/"]
[]
["UN Department of Economic and Social Affairs. (2015, July 29). World population projected to reach 9.7 billion by 2050. Retrieved from"]
["http://www.un.org/en/development/desa/news/population/2015-report.html"]
[]
["Hawkins, Ed. (2017, January 25). Defining ‘pre-industrial’.  Retrieved from"]
["https://www.climate-lab-book.ac.uk/2017/defining-pre-industrial/"]
[]
["Climate Lab Book. (n.d.). Solar variations, volcanic eruptions & atmospheric greenhouse gas concentration. Retrieved from"]
["http://blogs.reading.ac.uk/climate-lab-book/files/2017/01/forcing_fig_simpler.png"]

{"sheet":"OIE Plastics","index":4,"n_rows":86,"n_cols":6,"rows_kept":86,"cut":false,"hidden":false,"merged":[[30,0,30,5],[22,0,22,5],[23,0,23,5],[28,0,28,5],[27,0,27,5],[17,0,17,5],[16,0,16,5],[19,0,19,5],[20,0,20,5],[61,0,61,5],[13,0,13,5],[14,0,14,5],[12,0,12,5],[10,0,10,5],[7,3,7,5],[8,3,8,5],[79,0,79,5],[78,0,78,5],[71,2,71,5],[72,2,72,5],[74,2,74,5],[73,2,73,5],[85,0,85,5],[84,0,84,5],[80,0,80,5],[77,0,77,5],[64,2,64,5],[63,2,63,5],[70,2,70,5],[67,2,67,5],[66,2,66,5],[68,2,68,5],[65,2,65,5],[69,2,69,5],[62,2,62,5],[53,0,53,5],[54,0,54,5],[58,0,58,5],[59,0,59,5],[2,0,2,5],[4,0,4,5],[1,0,1,5],[6,3,6,5]]}
[]
["Own It Economics"]
["Plastics in Oceans Calculations"]
[]
["Plastics in Oceans"]
["Period","Total","Units","Rationale"]
[2020.0,{"$f":"B8-5*8","v":210},"Mt","2025 estimate minus estimated annual leakage of 8Mt per year [1]"]
[2025.0,250.0,"Mt","Ocean Conservancy Estimate [2]"]
[2050.0,937.0,"Mt","Study by McArthur Foundation as cited by Business Insider Article [3]"]
[]
["Assumptions"]
[]
["8Mt plastic leaked to Oceans per year, 2006 to 2050."]
[]
["References"]
[]
["1  Jambeck, J. (2015, February 12). Plastic waste inputs from land into the ocean.  Retrieved from"]
["https://www.iswa.org/fileadmin/user_upload/Calendar_2011_03_AMERICANA/Science-2015-Jambeck-768-71__2_.pdf (footnote 12)"]
[]
["2 Ocean Conservancy. (2015, September). Stemming the Tide: Land-based strategies for a plastic-free ocean.  Retrieved from"]
["https://oceanconservancy.org/wp-content/uploads/2017/04/full-report-stemming-the.pdf"]
[]
["3 Harrington, R. (2016, January 26). By 2050, the oceans could have more plastic than fish.  Retrieved from"]
["https://www.businessinsider.com/plastic-in-ocean-outweighs-fish-evidence-report-2017-1"]
[]
["Additional Information"]
[]
["Ellen MacArthur Foundation. (2016, January 19). The New Plastics Economy: Rethinking the future of plastics - download the infographics.  Retrieved from"]
["https://www.ellenmacarthurfoundation.org/news/the-new-plastics-economy-rethinking-the-future-of-plastics-infographics"]
[]
["Proportions of Plastics in Oceans, by Size, Estimate"]
["Geographic Segment","Total Plastic","Units","% of Seg.","% of Total"]
["GPGP Gyre",{"$f":"SUM(B34:B37)","v":78.4},"Kt",{"$f":"B33/SUM($B$34:$B$37)","v":1},{"$f":"B33/($B$47)","v":0.000392},"Great Pacific Garbage Patch"]
["Megaplastics (>50 cm).",42.0,"Kt",0.5357142857,null,"e.g. fishing nets"]
["Macroplastics (5–50 cm)",20.0,"Kt",0.2551020408,null,"e.g. crates"]
["Mesoplastics (0.5–5 cm)",10.0,"Kt",0.1275510204,null,"e.g. bottle caps"]
["Microplastics (0.05–0.5 cm)",6.4,"Kt",0.08163265306,null,"e.g. pea-sized bits or smaller"]
["All 5 Gyres",{"$f":"B33*5","v":392},"Kt",{"$f":"B38/SUM($B$39:$B$42)","v":1},{"$f":"B38/($B$47)","v":0.00196},"Estimated at 5x GPGP"]
["Megaplastics (>50 cm).",210,"Kt",0.5357142857,null,"e.g. fishing nets"]
["Macroplastics (5–50 cm)",100,"Kt",0.2551020408,null,"e.g. crates"]
["Mesoplastics (0.5–5 cm)",50,"Kt",0.1275510204,null,"e.g. bottle caps"]
["Microplastics (0.05–0.5 cm)",32,"Kt",0.08163265306,null,"e.g. pea-sized bits or smaller"]
["Outside Gyres",{"$f":"B47*E43","v":199608},"Kt",{"$f":"SUM(D44:D46)","v":1},{"$f":"1-E38","v":0.99804},"Including beaches"]
["Macroplastics (5–50 cm)",{"$f":"$B$43*D44","v":109674.7253},"Kt",{"$f":"D35/SUM($D$35:$D$37)","v":0.5494505495}]
["Mesoplastics (0.5–5 cm)",54837.36264,"Kt",0.2747252747]
["Microplastics (0.05–0.5 cm)",35095.91209,"Kt",0.1758241758]
["Total",200000.0,"Kt",{"$f":"B47/SUM($B$48:$B$51)","v":1},1.0,"Average of estimate methods 1 and 2"]
["Megaplastics (>50 cm).",{"$f":"B39","v":210},"Kt",0.00105]
["Macroplastics (5–50 cm)",{"$f":"B40+B44","v":109774.7253},"Kt",0.5488736264]
["Mesoplastics (0.5–5 cm)",54887.36264,"Kt",0.2744368132]
["Microplastics (0.05–0.5 cm)",35127.91209,"Kt",0.1756395604]
[]
["Assumptions:"]
["Amount of plastic by weight in all 5 gyres is roughly 5 times (5x) that of the GPGP."]
["Size composition of ocean plastic resembles GPGP, except that only gyres contain significant amounts of megaplastic."]
[]
["References"]
[]
["Lebreton, L. (2018, March 22). Evidence that the Great Pacific Garbage Patch is rapidly accumulating plastic. Retrieved from"]
["https://www.nature.com/articles/s41598-018-22939-w"]
[]
["Ocean Plastic Clean-Up Costs"]
["Geographic Segment","Number","Measurement"]
["GPGP cost, big plastics",370.0,"M $"]
["All 5 gyres, big plastics",{"$f":"B64*5","v":1850},"M $"]
["All 5 gyres, all plastics",{"$f":"B65/SUM($D$39:$D$41)","v":2014.444444},"M $"]
["All ocean areas",{"$f":"B68*B9/B8","v":3775068.889},"M $"]
["All ocean areas, legacy",{"$f":"B66/0.002","v":1007222.222},"M $"]
["All ocean areas, future",{"$f":"B67-B68","v":2767846.667},"M $"]
["OIE population",763.0,"million persons"]
["OIE responsibility per person",{"$f":"B67/763","v":4947.665647},"/person for lifetime"]
["OIE total responsibility per year",{"$f":"B71/30","v":164.9221882},"/person/yr for 30 years"]
["OIE responsibility per year, 2020–2050 (OIE Level 3)",{"$f":"B72*(B67-B68)/B67","v":120.9194699},"/person/yr for 30 years"]
["OIE responsibility per year, legacy (OIE Level 4)",{"$f":"B72*B68/B67","v":44.00271831},"/person/yr for 30 year"]
["OIE total responsibility per month",13.75,"/person/month for 30 years"]
[]
["Assumptions:"]
["Costs for cleaning all areas of the ocean (and beaches) of all sizes of plastic particles will be equivalent to costs per pound of cleaning GPGP per OceanCleanup.org estimates.  See Reference below at pg. 21."]
["Scaled-down OceanCleanup.org approaches and other technological advances will allow near 100% cleanup of all parts of ocean and all particle sizes."]
["Size composition of ocean plastic resembles GPGP, except that only gyres contain significant amounts of megaplastic."]
["Amount of plastic by weight in all 5 gyres is roughly 5 times (5x) that of the GPGP."]
[]
["References"]
[]
["Slat, B. (2014). How the Oceans Can Clean Themselves—A Feasability Study.  Retrieved from"]
["https://www.theoceancleanup.com/fileadmin/media-archive/Documents/TOC_Feasibility_study_executive_summary_V2_0.pdf"]

{"sheet":"OIE Poverty","index":5,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[27,0,27,6],[29,0,29,6],[30,0,30,6],[21,0,21,6],[23,0,23,6],[24,0,24,6],[25,0,25,6],[2,0,2,6],[1,0,1,6],[3,0,3,6],[11,0,11,6],[13,0,13,6],[19,0,19,6],[18,0,18,6],[17,0,17,6],[15,0,15,6],[26,0,26,6],[20,0,20,6]]}
[]
["Own It Economics"]
["Poverty Calculations"]
["Poverty"]
[null,"Period Cost","Units","Years","Total Cost","Units","Notes"]
["Extreme Poverty, Cost to End [1] \n(Cost x Years = Total)",{"$f":"66*1.09","v":71.94},"Billion Dollars per Year",10.0,{"$f":"B6*D6","v":719.4},"Billion Dollars","Cost for ending extreme poverty (those living on less than $1.25 US per day) in 2013."]
["Poverty, Cost to End [2]\n(Cost x Years = Total)",{"$f":"B6*1.07*(3/1.3)","v":177.6364615},"Billion Dollars per Year",10.0,1776.364615,"Billion Dollars","In 2015, the poverty threshold was estimated to be those living on less than $2.50 US per day."]
["Extreme Poverty, Cost per OIE Person \n(Cost / Years = Total Cost per Person Per Year)",{"$f":"(B7*1000000000)/('OIE Population'!B8*1000000)","v":232.7216842},"Dollars per Year",10.0,2327.216842,"Dollars"]
["Poverty, Cost per OIE Person \n(Cost / Years = Total per Person Per Year)",{"$f":"B8*2","v":465.4433684},"Dollars per Year",10.0,4654.433684,"Dollars"]
["Poverty, Cost per OIE Person, Per Month",{"$f":"B9/12","v":38.78694736},"Dollars per Month",10.0,{"$f":"B10*D10*12","v":4654.433684},"Dollars"]
[]
["Assumptions"]
[]
["The global poverty threshold often used is two times the threshold used for extreme poverty, thus the cost per person to eradicate poverty is estimated to be about twice the amount per person to eradicate extreme poverty. The UN estimates that 3 billion people lived in poverty (living on less than $2.50 US per day) and 1.3 billion in extreme poverty (living on less than $1.25 US per day) in 2014 [2]. Since there are a few more people in poverty, but not extreme poverty, than are in extreme poverty, in the table above, ending poverty is assumed to cost 2.3 (3.0/1.3) times the amount needed to end extreme poverty. We acknowledge that this does not address possible differences in the efficiency of dollars spent on eradication of extreme poverty versus poverty that is not as extreme. As always, we encourage feedback on these assumptions."]
[]
["Figures shown in other sources (e.g. Drezner[3]) often show much larger costs for the elimination of extreme poverty, these typically include the current amount of foreign aid. The current analysis addresses the amount needed in addition to the current levels of foreign aid."]
[]
["All figures adjusted to 2019 dollars. 2013 dollars are estimated as 1.09 2019 dollars.  2015 dollars are estimated as 1.07 2019 dollars. Based on https://www.usinflationcalculator.com."]
[]
["References"]
["1  OXFAM. (2013, January 18). OXFAM Media Briefing. Retrieved from"]
["https://www.oxfam.org/en/pressroom/pressreleases/2013-01-19/annual-income-richest-100-people-enough-end-global-poverty-four"]
[]
["2  United Nations Development Programme. (2014). \"Sustaining Human Progress: Reducing Vulnerabilities and Building Resilience.\" Human Development Report. Retrieved from"]
["https://www.dosomething.org/us/facts/11-facts-about-global-poverty"]
[]
["3  Drezner, Daniel W.  (2005, April 24). The End of Poverty': Brother, Can You Spare $195 Billion?.  Retrieved from"]
["https://www.nytimes.com/2005/04/24/books/review/the-end-of-poverty-brother-can-you-spare-195-billion.html"]
[]
["4  Brooking Institute. (2016, January 20). The global poverty gap is falling. Billionaires could help close it. Retrieved from"]
["https://www.brookings.edu/blog/up-front/2016/01/20/the-global-poverty-gap-is-falling-billionaires-could-help-close-it"]