bolt efficiency.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	Y	AA	AB	AC	AD	AE
1					P(chg avg)	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	charge init (min)	5	39.09114463	pretend it's hidden
2					T(charge)	1.425	1.390243902	1.357142857	1.325581395	1.295454545	1.266666667	1.239130435	1.212765957	1.1875	1.163265306	1.14	1.117647059	1.096153846	1.075471698	1.055555556	1.036363636	^ (hr)	0.08333333333	1.458130749	pretend it's hidden
3	P(driving)	Efficiency	T(drive)	range	driving speed	average speed (including charging, and charging initilization time of (B1/B2)																soc start	10	same for^	pretend it's hidden
4	0.1339865135	6.699325675	7.637231269	381.8615635	50	41.75374403	41.91302707	42.06585916	42.21262442	42.35367707	42.48934427	42.61992868	42.74571067	42.8669504	42.98388954	43.09675293	43.20575	43.31107607	43.41291355	43.51143291	43.60679373	soc end	90	41.60303277
5	0.1270631366	6.480219969	7.242598789	369.3725382	51	42.20950786	42.37781995	42.53936988	42.69455714	42.84375037	42.98729026	43.12549217	43.25864842	43.38703039	43.51089032	43.630463	43.74596724	43.8576072	43.96557363	44.07004489	44.17118802	avg chg spd:	39.09114463	42.05030675
6	0.1206112732	6.271786206	6.874842572	357.4918138	52	42.6439595	42.8214946	42.99195545	43.15575659	43.31328085	43.46488223	43.61088862	43.75160413	43.88731124	44.01827267	44.14473308	44.26692058	44.38504814	44.49931481	44.60990682	44.71699863	soc used (%)	80	42.47609176
7	0.1145912238	6.073334859	6.531699754	346.180087	53	43.05704755	43.24398611	43.42353824	43.59613324	43.76216777	43.92200893	44.07599689	44.22444738	44.36765382	44.50588926	44.63940812	44.76844773	44.89322979	45.01396158	45.13083716	45.24403837	kwh this charge	48	42.88034951
8	0.1089672548	5.88423176	6.211133524	335.4012103	54	43.4487532	43.64526145	43.83407189	44.01562814	44.19034039	44.35858846	44.5207246	44.6770759	44.82794654	44.97361972	45.11435947	45.25041224	45.38200833	45.50936318	45.63267858	45.75214371	Charge time (Hour)	1.311232911	43.26307482
9	0.1037071419	5.703892802	5.911307086	325.1218897	55	43.81908979	44.02531923	44.22354108	44.41421284	44.59775782	44.77456825	44.94500811	45.10941561	45.26810543	45.42137075	45.56948502	45.71270365	45.85126539	45.98539377	46.1152982	46.24117511	Charge time (Min):	78.67397468	43.62429523
10	0.09878177199	5.531779231	5.630561003	315.3114162	56	44.16810241	44.38418927	44.5919612	44.79188908	44.98440889	45.16992489	45.34881243	45.52142054	45.68807415	45.84907615	46.00470925	46.15523759	46.30090826	46.44195269	46.5785878	46.71101719	best speed	73	43.96407046
11	0.09416479731	5.367393447	5.367393447	305.9414265	57	44.49586731	44.72193211	44.93937792	45.14868842	45.35031178	45.54466385	45.73213099	45.9130727	46.08782384	46.25669678	46.41998321	46.57795582	46.73086985	46.87896445	47.02246393	47.16157889	avg speed @ ^^^:	46.65406487	44.28249174
12	0.08983233196	5.210275253	5.120442921	296.9856894	58	44.80249114	45.0386384	45.26586662	45.48467175	45.6955136	45.89881915	46.09498535	46.28438178	46.46735294	46.64422033	46.81528439	46.98082611	47.14110866	47.29637875	47.44686788	47.59279353	efficiency @ ^^^:	3.495886183	44.57968106
13	0.08576268663	5.059998511	4.888473138	288.4199151	59	45.0881102	45.33442808	45.57153173	45.79992868	46.02008986	46.23245284	46.43742474	46.63538482	46.82668682	47.01166109	47.19061647	47.36384204	47.53160865	47.69417035	47.85176564	48.00461871	miles added:	167.8025368	44.85579023
14	0.08193613548	4.916168129	4.670359722	280.2215833	60	45.35288949	45.60944965	45.85650594	46.09457684	46.3241438	46.54565446	46.75952559	46.9661457	47.16587741	47.35905954	47.54600905	47.72702277	47.90237899	48.07233886	48.23714771	48.3970362			45.11099995
15	0.07833471094	4.778417368	4.465078524	272.36979	61	45.59702168	45.86387913	46.12094937	46.36876112	46.60780572	46.83854033	47.06139087	47.27675464	47.48500269	47.68648195	47.88151716	48.07041261	48.25345372	48.43090851	48.60302887	48.77005177			45.34551868
16	0.07494202285	4.646405417	4.271695302	264.8451087	62	45.82072606	46.09791911	46.36504858	46.62265273	46.87123212	47.11125283	47.34314942	47.56732748	47.78416606	47.99401981	48.19722085	48.39408062	48.58489138	48.76992772	48.94944786	49.12369484			45.5595815
17	0.07174309849	4.519815205	4.089356614	257.6294667	63	46.02424734	46.31179763	46.58901558	46.85644826	47.11460478	47.36395956	47.60495517	47.83800503	48.06349574	48.28178919	48.49322457	48.69812006	48.89677447	49.08946867	49.27646694	49.45801815			45.75344885
18	0.06872424112	4.398351432	3.917281744	250.7060316	64	46.20785442	46.505767	46.79308671	47.07036868	47.33812987	47.59685238	47.84698628	48.08895224	48.32314393	48.54993009	48.76965652	48.98264781	49.18920896	49.38962683	49.58417146	49.7730973			45.92740523
19	0.06587290436	4.281738783	3.754755548	244.0591106	65	46.37183907	46.68010257	46.97752149	47.26465819	47.54203682	47.81014651	48.0694442	48.32035733	48.56328609	48.79860563	49.02666795	49.24780367	49.46232362	49.67052032	49.87266929	50.06903026			46.08175787
20	0.06317758059	4.169720319	3.601122094	237.6740582	66	46.51651464	46.8351015	47.14260137	47.4395831	47.72657729	48.00407942	48.27255274	48.53243085	48.78412	49.02800125	49.26443239	49.49374964	49.71626933	49.93228928	50.14209019	50.3459368			46.21683528
21	0.06062770167	4.062056012	3.455778995	231.5371927	67	46.64221463	46.97108138	47.28862853	47.59543063	47.89202398	48.17890979	48.45655697	48.72540472	48.98586484	49.23832382	49.48314475	49.72066912	49.95121832	50.17509516	50.39258517	50.60395781			46.33298583
22	0.05821355025	3.958521417	3.318172364	225.6357208	68	46.74929129	47.0883789	47.41592454	47.73250764	48.0386695	48.33491636	48.62172218	48.8995312	49.16876022	49.42980066	49.68302052	49.92876606	50.1673634	50.39911995	50.62432575	50.84325468			46.43057629
23	0.05592618072	3.858906469	3.187792301	219.9576688	69	46.8381142	47.18734849	47.52482903	47.85113938	48.16682509	48.47239675	48.76833275	49.05508179	49.33306512	49.60267864	49.86429474	50.11826407	50.36491705	50.60456535	50.83750318	51.06400851			46.50999035
24	0.05375734831	3.763014382	3.064168854	214.4918198	70	46.90906882	47.26836088	47.61569839	47.9516682	48.2768194	48.59166626	48.89669098	49.19234612	49.47905687	49.75722307	50.02722107	50.28940546	50.54411057	50.79165195	51.03232763	51.26641934			46.57162712
25	0.05169944572	3.670660646	2.946868406	209.2276568	71	46.96255502	47.33180176	47.68890435	48.03445221	48.36899722	48.69305668	49.00711594	49.31163086	49.60703003	49.89371672	50.17207078	50.44245029	50.70519312	50.96061828	51.20902729	51.45070532			46.61589964
26	0.04974544608	3.581672118	2.835490427	204.1553107	72	46.99898569	47.37807032	47.74483269	48.099864	48.44371822	48.77691499	49.09994222	49.4132585	49.71729524	50.01245867	50.29913167	50.57767537	50.84843074	51.11171992	51.36784753	51.61710186			46.6432334
27	0.04788885183	3.495886183	2.729664554	199.2655124	73	47.01878522	47.40757787	47.7838818	48.14828926	48.50135561	48.84360217	49.17551879	49.49756621	49.81017815	50.11376329	50.40870704	50.6953732	50.97410539	51.24522851	51.50904993	51.76586071			46.65406487	73	46.65406487	3.495886183
28	0.04612364857	3.413149994	2.629047968	194.5495497	74	47.02238819	47.42074647	47.80646141	48.18012554	48.54229491	48.89349191	49.23420772	49.56490466	49.88601822	50.19795904	50.50111462	50.79585093	51.08251391	51.36143078	51.63291133	51.89724905			46.64884007
29	0.04444426357	3.333319768	2.533323024	189.9992268	75	47.01023788	47.41800756	47.81299118	48.19578085	48.56693267	48.92696941	49.27638302	49.61563682	49.94516759	50.26538741	50.57668541	50.87942934	51.17396699	51.46062757	51.7397229	52.01154856			46.62801316
30	0.04284552827	3.256260149	2.442195111	185.6068285	76	46.98278498	47.3998006	47.80389944	48.19567246	48.57567515	48.94443008	49.30242936	49.6501368	49.98798992	50.31640178	50.63576269	50.94644172	51.24878815	51.54313277	51.8297891	52.10905447			46.59204501
31	0.04132264435	3.181843615	2.355390728	181.365086	77	46.94048622	47.36657182	47.77962187	48.18022558	48.56893715	48.94627837	49.31274096	49.66878866	50.01485925	50.3513663	50.67870083	50.99723283	51.30731267	51.60927235	51.90342672	52.19007456			46.54140195
32	0.03987115308	3.109949941	2.272655726	177.2671466	78	46.88380311	47.31877287	47.74060028	48.14987213	48.54714075	48.93292657	49.30772035	49.67198527	50.02615887	50.37065475	50.70586424	51.03215783	51.34988657	51.65938332	51.96096391	52.25492822			46.47655437
33	0.03848690756	3.040465697	2.193753731	173.3065448	79	46.8132007	47.25685964	47.68728135	48.10504955	48.51071413	48.90479359	49.28777722	49.66012714	50.02228015	50.37464948	50.7176263	51.0515812	51.37686556	51.69381271	52.00273912	52.30394547			46.39797554
34	0.03716604744	2.973283795	2.118464704	169.4771763	80	46.72914637	47.18129108	47.62011546	48.04619961	48.4600904	48.86230387	49.25332732	49.63362133	50.00362153	50.3637403	50.71436826	51.05587573	51.388614	51.71291655	52.02910016	52.33746595			46.30614043
35	0.03590497606	2.908303061	2.046583635	165.7732745	81	46.63210869	47.09252802	47.5395556	47.97376731	48.3957065	48.80588623	49.20479133	49.59288037	49.97058737	50.33832343	50.69647824	51.04542145	51.38550391	51.7170589	52.04040317	52.35583801			46.20152448
36	0.03470033958	2.845427846	1.977919356	162.1893872	82	46.52255635	46.99103212	47.4460562	47.88819976	48.31800209	48.7359728	49.14259378	49.53832116	49.9235869	50.29880045	50.66435016	51.02060463	51.36791394	51.70661084	52.03701173	52.35941774			46.08460262
37	0.03354900807	2.78456767	1.91229346	158.7203572	83	46.40095712	46.8772648	47.34007216	47.78994515	48.22741854	48.652998	49.06716207	49.47036398	49.86303326	50.2455773	50.61838275	50.9818168	51.33622843	51.68194951	52.01929581	52.348568			45.95584815
38	0.03244805814	2.725636884	1.849539314	155.3613024	84	46.26777686	46.75168627	47.22205782	47.67945177	48.1243979	48.55739753	48.97892542	49.38943149	49.78934247	50.17906331	50.55897859	50.92945378	51.29083642	51.64345718	51.9876309	52.32365751			45.81573187
39	0.03139475724	2.668554366	1.789501163	152.1075988	85	46.12347861	46.61475462	47.09246605	47.55716705	48.00938199	48.44960742	48.87831393	49.29594778	49.70293249	50.09967022	50.48654317	50.86391474	51.23213071	51.59152029	51.94239707	52.28505998			45.66472108
40	0.03038654922	2.613243233	1.732033305	148.9548643	86	45.96852174	46.4669249	46.95174733	47.42353667	47.88281147	48.33006314	48.76575773	49.19033745	49.60422229	50.00781131	50.40148397	50.7856013	51.16050704	51.52652861	51.8839781	52.23315317			45.50327879
41	0.02942104112	2.559630577	1.676999344	145.8989429	87	45.80336112	46.30864835	46.80034897	47.27900372	47.745125	48.19919872	48.64168602	49.07302476	49.49363105	49.90390052	50.3042096	50.69491668	51.07636312	51.44887432	51.81276061	52.1683181			45.33186294
42	0.02849599117	2.507647223	1.624271497	142.9358917	88	45.62844644	46.14037161	46.63871427	47.12400792	47.59675845	48.05744595	48.50652633	48.94443278	49.37157723	49.78835159	50.19512897	50.59226481	50.98009787	51.35895124	51.72913322	52.09093816			45.15092563
43	0.02760929769	2.457227495	1.573729968	140.0619672	89	45.44422144	45.96253604	46.46728187	46.95898486	47.43814413	47.90523362	48.36070371	48.80498264	49.23847787	49.66157731	50.07465047	50.47804959	50.87211058	51.25715396	51.63348578	52.00139837			44.96091252
44	0.02675898899	2.408309009	1.525262373	137.2736135	90	45.25112337	45.77557704	46.28648501	46.78436536	47.26971011	47.74298681	48.20464004	48.65509279	49.09474781	49.52398873	49.94318125	50.35267413	50.75280017	51.14387713	51.52620856	51.90008456			44.76226216
45	0.02594321404	2.360832478	1.478763201	134.5674513	91	45.04958234	45.57992351	46.09675098	46.60057477	47.09187955	47.57112622	48.03875329	48.49517829	48.94079898	49.37599451	49.80112648	50.21653998	50.62256447	51.01951472	51.40769157	51.78738269			44.55540549
46	0.02516023394	2.314741522	1.434133335	131.9402668	92	44.84002086	45.37599723	45.89850052	46.40803245	46.90507013	47.39006755	47.86345696	48.32565019	48.77703979	49.21800018	49.64888869	50.07004648	50.48179951	50.88445931	51.27832382	51.66367811			44.34076533
47	source for range calculation:		http://www.roperld.com/science/ChevyBoltRange.htm
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100