Bicycle Energy Calc.xlsx

	A	B	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Rider Mass [kg]	60	Time [s]	Power Input [W]	Int Energy Expended [J]	Kinetic Energy [J]	Velocity [m/s]	Int Distance [m]	Total Distance [km]	Elevation [m]	Air Density [kg/m^3]	Drag Force [N]	Drag Energy [J]	Total Potential Energy [J]	Int Potential Energy [J]
2	Sphere Dia [m]	1	0	200	0	0	0	0	0	0	1.2284	0.0000	0	0	0
3	Sphere Cd	0.47	1	200	200	200	2.581988897	1.290994449	0.001290994449	0	1.2284	1.5115	1.951329756	0	0
4	Sphere Area [m^2]	0.7853981634	2	200	200	398.0486702	3.642566267	3.112277582	0.004403272031	0	1.2284	3.0082	9.36247775	0	0
5	Gravity	9.81	3	200	200	588.6861925	4.429771222	4.036168745	0.008439440776	0	1.2284	4.4490	17.95682132	0	0
6			4	200	200	770.7293712	5.068626938	4.74919908	0.01318863986	0	1.2284	5.8248	27.6629557	0	0
7			5	200	200	943.0664155	5.606741227	5.337684082	0.01852632394	0	1.2284	7.1272	38.04270956	0	0
8			6	200	200	1105.023706	6.069112252	5.837926739	0.02436425068	0	1.2284	8.3512	48.75358232	0	0
9			7	200	200	1256.270124	6.471141382	6.270126817	0.03063437749	0	1.2284	9.4942	59.52996854	0	0
10			8	200	200	1396.740155	6.823342668	6.647242025	0.03728161952	0	1.2284	10.5558	70.16708057	0	0
11			9	200	200	1526.573074	7.133426186	6.978384427	0.04426000395	0	1.2284	11.5370	80.50980691	0	0
12			10	200	200	1646.063268	7.407346055	7.270386121	0.05153039007	0	1.2284	12.4401	90.44411147	0	0
13			11	200	200	1755.619156	7.649878335	7.528612195	0.05905900226	0	1.2284	13.2680	99.88988991	0	0
14			12	200	200	1855.729266	7.86496295	7.757420642	0.06681642291	0	1.2284	14.0246	108.7948293	0	0
15			13	200	200	1946.934437	8.055917984	7.960440467	0.07477686337	0	1.2284	14.7139	117.1290774	0	0
16			14	200	200	2029.80536	8.225580749	8.140749366	0.08291761274	0	1.2284	15.3402	124.8806285	0	0
17			15	200	200	2104.924731	8.37640482	8.300992784	0.09121860552	0	1.2284	15.9079	132.0513677	0	0
18			16	200	200	2172.873363	8.510529485	8.443467152	0.09966207267	0	1.2284	16.4214	138.6537216	0	0
19			17	200	200	2234.219642	8.629831288	8.570180386	0.1082322531	0	1.2284	16.8850	144.7078614	0	0
20			18	200	200	2289.51178	8.735963561	8.682897425	0.1169151505	0	1.2284	17.3029	150.2394032	0	0
21			19	200	200	2339.272377	8.830387642	8.783175602	0.1256983261	0	1.2284	17.6790	155.2775446	0	0
22			20	200	200	2383.994833	8.914398152	8.872392897	0.134570719	0	1.2284	18.0170	159.8535818	0	0
23			21	200	200	2424.141251	8.989143917	8.951771035	0.14352249	0	1.2284	18.3204	163.9997492	0	0
24			22	200	200	2460.141502	9.055645572	9.022394744	0.1525448848	0	1.2284	18.5924	167.7483312	0	0
25			23	200	200	2492.39317	9.114810604	9.085228088	0.1616301129	0	1.2284	18.8362	171.1309984	0	0
26			24	200	200	2521.262172	9.16744634	9.141128472	0.1707712413	0	1.2284	19.0544	174.178328	0	0
27			25	200	200	2547.083844	9.214271257	9.190858799	0.1799621001	0	1.2284	19.2495	176.9194709	0	0
28			26	200	200	2570.164373	9.255924901	9.235098079	0.1891971982	0	1.2284	19.4239	179.3819365	0	0
29			27	200	200	2590.782437	9.292976625	9.274450763	0.198471649	0	1.2284	19.5798	181.5914686	0	0
30			28	200	200	2609.190968	9.325933319	9.309454972	0.2077811039	0	1.2284	19.7189	183.5719913	0	0
31			29	200	200	2625.618977	9.355246259	9.340589789	0.2171216937	0	1.2284	19.8430	185.3456078	0	0
32			30	200	200	2640.273369	9.381317194	9.368281726	0.2264899755	0	1.2284	19.9538	186.9326379	0	0
33			31	200	200	2653.340731	9.404503764	9.392910479	0.2358828859	0	1.2284	20.0525	188.3516824	0	0
34			32	200	200	2664.989049	9.425124312	9.414814038	0.2452977	0	1.2284	20.1406	189.6197072	0	0
35			33	200	200	2675.369342	9.443462186	9.434293249	0.2547319932	0	1.2284	20.2190	190.7521379	0	0
36			34	200	200	2684.617204	9.45976956	9.451615873	0.2641836091	0	1.2284	20.2889	191.7629617	0	0
37			35	200	200	2692.854242	9.474270846	9.467020203	0.2736506293	0	1.2284	20.3512	192.6648316	0	0
38			36	200	200	2700.18941	9.487165735	9.48071829	0.2831313476	0	1.2284	20.4066	193.46917	0	0
39			37	200	200	2706.72024	9.498631902	9.492898818	0.2926242464	0	1.2284	20.4560	194.1862697	0	0
40			38	200	200	2712.533971	9.508827426	9.503729664	0.3021279761	0	1.2284	20.4999	194.8253911	0	0
41			39	200	200	2717.70858	9.517892938	9.513360182	0.3116413362	0	1.2284	20.5390	195.394854	0	0
42			40	200	200	2722.313725	9.52595354	9.521923239	0.3211632595	0	1.2284	20.5738	195.9021244	0	0
43			41	200	200	2726.411601	9.533120512	9.529537026	0.3306927965	0	1.2284	20.6048	196.3538945	0	0
44			42	200	200	2730.057707	9.539492835	9.536306674	0.3402291032	0	1.2284	20.6323	196.7561575	0	0
45			43	200	200	2733.301549	9.545158544	9.54232569	0.3497714289	0	1.2284	20.6568	197.1142762	0	0
46			44	200	200	2736.187273	9.550195937	9.54767724	0.3593191061	0	1.2284	20.6786	197.4330453	0	0
47			45	200	200	2738.754228	9.554674646	9.552435291	0.3688715414	0	1.2284	20.6980	197.7167495	0	0
48			46	200	200	2741.037478	9.558656597	9.556665621	0.378428207	0	1.2284	20.7153	197.969215	0	0
49			47	200	200	2743.068263	9.562196859	9.560426728	0.3879886338	0	1.2284	20.7306	198.193857	0	0
50			48	200	200	2744.874406	9.565344402	9.56377063	0.3975524044	0	1.2284	20.7443	198.3937225	0	0
51			49	200	200	2746.480683	9.568142772	9.566743587	0.407119148	0	1.2284	20.7564	198.5715288	0	0
52			50	200	200	2747.909155	9.570630691	9.569386732	0.4166885347	0	1.2284	20.7672	198.7296986	0	0
53			51	200	200	2749.179456	9.572842587	9.571736639	0.4262602713	0	1.2284	20.7768	198.8703909	0	0
54			52	200	200	2750.309065	9.574809076	9.573825832	0.4358340972	0	1.2284	20.7854	198.9955293	0	0
55			53	200	200	2751.313536	9.576557377	9.575683226	0.4454097804	0	1.2284	20.7930	199.1068274	0	0
56			54	200	200	2752.206709	9.578111694	9.577334535	0.4549871149	0	1.2284	20.7997	199.2058112	0	0
57			55	200	200	2753.000897	9.579493545	9.578802619	0.4645659176	0	1.2284	20.8057	199.2938394	0	0
58			56	200	200	2753.707058	9.580722064	9.580107804	0.4741460254	0	1.2284	20.8111	199.3721217	0	0
59			57	200	200	2754.334936	9.581814262	9.581268163	0.4837272935	0	1.2284	20.8158	199.4417347	0	0
60			58	200	200	2754.893202	9.582785262	9.582299762	0.4933095933	0	1.2284	20.8200	199.5036367	0	0
61			59	200	200	2755.389565	9.583648513	9.583216888	0.5028928102	0	1.2284	20.8238	199.5586803	0	0
62			60	200	200	2755.830885	9.58441597	9.584032242	0.5124768424	0	1.2284	20.8271	199.6076243	0	0
63			61	200	200	2756.22326	9.585098261	9.584757116	0.5220615995	0	1.2284	20.8301	199.6511436	0	0
64			62	200	200	2756.572117	9.585704837	9.585401549	0.5316470011	0	1.2284	20.8327	199.6898388	0	0
65			63	200	200	2756.882278	9.586244099	9.585974468	0.5412329755	0	1.2284	20.8350	199.7242441	0	0
66			64	200	200	2757.158034	9.586723517	9.586483808	0.5508194594	0	1.2284	20.8371	199.7548346	0	0
67			65	200	200	2757.403199	9.587149731	9.586936624	0.560406396	0	1.2284	20.8390	199.782033	0	0
68			66	200	200	2757.621166	9.587528646	9.587339189	0.5699937352	0	1.2284	20.8406	199.806215	0	0
69			67	200	200	2757.814951	9.58786551	9.587697078	0.5795814322	0	1.2284	20.8421	199.8277151	0	0
70			68	200	200	2757.987236	9.588164989	9.58801525	0.5891694475	0	1.2284	20.8434	199.8468304	0	0
71			69	200	200	2758.140406	9.588431233	9.588298111	0.5987577456	0	1.2284	20.8446	199.8638254	0	0
72			70	200	200	2758.27658	9.58866793	9.588549582	0.6083462952	0	1.2284	20.8456	199.8789351	0	0
73			71	200	200	2758.397645	9.588878358	9.588773144	0.6179350683	0	1.2284	20.8465	199.8923686	0	0
74			72	200	200	2758.505276	9.589065433	9.588971896	0.6275240402	0	1.2284	20.8473	199.9043117	0	0
75			73	200	200	2758.600965	9.589231747	9.58914859	0.6371131888	0	1.2284	20.8480	199.9149298	0	0
76			74	200	200	2758.686035	9.589379603	9.589305675	0.6467024945	0	1.2284	20.8487	199.9243698	0	0
77			75	200	200	2758.761665	9.58951105	9.589445326	0.6562919398	0	1.2284	20.8493	199.9327624	0	0
78			76	200	200	2758.828903	9.589627908	9.589569479	0.6658815093	0	1.2284	20.8498	199.9402238	0	0
79			77	200	200	2758.888679	9.589731798	9.589679853	0.6754711892	0	1.2284	20.8502	199.9468573	0	0
80			78	200	200	2758.941822	9.589824158	9.589777978	0.6850609671	0	1.2284	20.8506	199.9527547	0	0
81			79	200	200	2758.989067	9.589906268	9.589865213	0.6946508323	0	1.2284	20.8510	199.9579977	0	0
82			80	200	200	2759.031069	9.589979265	9.589942766	0.7042407751	0	1.2284	20.8513	199.9626589	0	0
83			81	200	200	2759.06841	9.590044161	9.590011713	0.7138307868	0	1.2284	20.8516	199.9668029	0	0
84			82	200	200	2759.101607	9.590101854	9.590073008	0.7234208598	0	1.2284	20.8518	199.970487	0	0
85			83	200	200	2759.13112	9.590153145	9.5901275	0.7330109873	0	1.2284	20.8520	199.9737623	0	0
86			84	200	200	2759.157358	9.590198743	9.590175944	0.7426011633	0	1.2284	20.8522	199.9766741	0	0
87			85	200	200	2759.180684	9.590239281	9.590219012	0.7521913823	0	1.2284	20.8524	199.9792628	0	0
88			86	200	200	2759.201421	9.59027532	9.5902573	0.7617816396	0	1.2284	20.8526	199.9815642	0	0
89			87	200	200	2759.219857	9.590307359	9.590291339	0.7713719309	0	1.2284	20.8527	199.9836102	0	0
90			88	200	200	2759.236247	9.590335842	9.5903216	0.7809622525	0	1.2284	20.8528	199.9854291	0	0
91			89	200	200	2759.250818	9.590361164	9.590348503	0.790552601	0	1.2284	20.8529	199.9870462	0	0
92			90	200	200	2759.263772	9.590383676	9.59037242	0.8001429734	0	1.2284	20.8530	199.9884838	0	0
93			91	200	200	2759.275288	9.590403689	9.590393683	0.8097333671	0	1.2284	20.8531	199.9897619	0	0
94			92	200	200	2759.285526	9.590421482	9.590412586	0.8193237797	0	1.2284	20.8532	199.9908981	0	0
95			93	200	200	2759.294628	9.590437299	9.590429391	0.8289142091	0	1.2284	20.8533	199.9919082	0	0
96			94	200	200	2759.30272	9.590451362	9.59044433	0.8385046534	0	1.2284	20.8533	199.9928063	0	0
97			95	200	200	2759.309913	9.590463863	9.590457612	0.8480951111	0	1.2284	20.8534	199.9936046	0	0
98			96	200	200	2759.316309	9.590474977	9.59046942	0.8576855805	0	1.2284	20.8534	199.9943144	0	0
99			97	200	200	2759.321994	9.590484858	9.590479917	0.8672760604	0	1.2284	20.8535	199.9949454	0	0
100			98	200	200	2759.327049	9.590493642	9.59048925	0.8768665496	0	1.2284	20.8535	199.9955064	0	0