2021.07.14 BLAST -- Transport -- CO2e driving calculator -- Black Rock City -- v1 Frog .xlsx

	A	B	C	E	G	I	K	M
1	BLAST 2021 - Transport + Emissions
2	Prototype - CO2e Driving Calculator - BRC
3	2021.07.14 - Frog T1v1 - Version 1
4							Your camp's data
5
6	Variables					Calulations		Notes
7
8

9	CO2e Rough Estimate - for Driving ONLY - Black Rock City
10
11		Have you had enough? Ready to help our people and our planet?
12		Well then, just how much CO2 are you emitting?
13		If you fill in this BLAST calculation, your camp will meet the Baseline credit for Transport + Emissions:
14		"Transport - does your camp track the environmental footprint of personal travel and equipment transport to and from playa?"
15		Please download a copy onto your computer and add your data. Please don't try to edit this on-line version.
16		Yes, this is a very rough estimate, it simply assumes everyone drives to BRC and back. But, it's our alpha version, our start for 2021.
17		Please return in 2022 to be a beta participant, in a more advanced model with trains, planes, skateboards, and maybe methane.
18
19
20	1. In the Estimated Trips table below, fill in the blanks in orange highlight to figure your People driving distances!
21
22		Estimated Trips
23			Origins = "Home" or wherever your camp's Burners will start their trips	One-way trip to BRC in kilometers	Burners who make that trip	Trip distance calculation
24			Tralfamador	1,000	2	2,000	Burner-km
25			Tonopah	800	4	3,200	Burner-km
26			xxx	1		0	Burner-km
27			xxx	1		0	Burner-km
28			xxx	1		0	Burner-km
29			xxx	1		0	Burner-km
30			xxx	1		0	Burner-km
31			xxx	1		0	Burner-km
32			xxx	1		0	Burner-km
33			xxx	1		0	Burner-km
34
35				Total Burners in your camp	6
36				Subtotal Burner-distance		5,200	Burner-km
37				Round trip		2
38
39				Total Burner-distance		10,400	Burner-km
40
41
42	2. Next, Carpooling: how many People-vehicles will bring Burners (e.g. people-cars - but not, say, your trailers for your stuff, or your MV's)
43
44		Carpooling
45			People-vehicle types		People-vehicle quantities
46			Motorcycle		0
47			Car (sedan)		2
48			SUV		0
49			Bus		0
50			RV		8
51			Pickup		0
52			Skateboard		0
53			X-wing		0
54			x		0
55			x		0
56
57				Total People-vehicles	10
58				Total Burners in your camp		6
59
60				Average carpooling rate		2.0	Burners/auto
61				Total Auto-distance		10,400
62
63				Total Auto-distance		5,200	auto-km
64
65
66	3. So here is your rough estimate of your CO2e impact on our planet! And about how much it would cost to offset your impact.
67
68		CO2e emissions
69			2021 Average auto			0.17	kg CO2e/km	0.156 = UK average auto 2018 - smmt.co.uk 0.14 to 0.17 = German range @ 2021.07.06 - https://www.atmosfair.de/
70			2021 Total emissions			884	kg CO2e
71
72					Total Auto-person emissions	1	Tonne CO2e
73
74						6	Burners
75					Average CO2e auto-person	0.15	Tonne CO2e/ Burner
76
77
78		CO2e Offset
79			2021 unit price			$ 5.00	USD/Tonne CO2e	$3-5.00 = US @ 2021.06.14 (GreenBiz.com)
80						1	Tonne CO2e
81					Total Offset cost	$ 4	USD	Note: 2021.06.14 - the current market price is low since there is a surplus of credits available to purchase. "Carbon offset prices are expected to increase tenfold by 2030." (GreenBiz.com)
82						6	Person
83					Individual Offset cost of CO2e	$ 0.74	USD/ Burner
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100