SOLAR ebike Trip Planner 2.1

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	SOLAR ebike Trip Planner 2.1										Instructions, help and discussion on the Endless Sphere forum
2	To use your own numbers, you must select File > Make a copy... from the menu above. (You may be asked to sign in with a Google account.)
3	Then, change the yellow highlighted cells to your own values.
4
5	EASY MODE
6	Where are you?		How big is your solar panel?				Your daily solar range in May
7	Oakland, CA			100	watts		38 miles (62 km)
8
9	ADVANCED
10												Percent of sun-hours travelling with...
11	Location	Start date		End date		PV array size		Wh/mile		PV losses	Shading losses	0° fixed tilt	1-axis tilt travelling North-South	1-axis tilt travelling East-West	Stationary charging
12	Oakland, CA	Jan 1		Dec 31		100		16.0		10%	30%	50%	0%	0%	50%
13	Enter a city name. If you get an error it's likely your location couldn't be found. Try selecting a different weather dataset below or a different location above.	Double-click the yellow cells above for a pop-up calendar or enter dates manually in the format shown. The year does not matter but both dates must be in the same year.				Enter the STC rating of your solar panel(s) in DC watts (Wp)		Click the arrow to enter either Wh usage or daily range. The other will be calculated below.		Wire/connection ohmic losses, diodes, charge controller efficiency, system availability, etc.	Enter your best estimate: trees, buildings, cars, terrain, self-shading, etc.	Set this to 0% if your array is tilted while moving.	Estimate the amount of travel in each direction. You will rarely travel in a straight line all day. Set both to 0% if your array does not tilt when moving.		Assumes 2-axis tracking by manually orienting the solar array.
14	Weather dataset		Battery	V ave	V min	V max	Ah
15	NSRDB (try me first!)		Battery	37.0	30.0	42.0	16.2
16
17	OUTPUTS
18	For your date range:	Trip length		Average daylight		Average Wh/day		Average miles/day				0° fixed tilt	1-axis tilt North-South	1-axis tilt East-West	Stationary charging
19		365	days	11.8 hrs		384		24.0			Sun-hours	2.5 / 5	0 / 6.8	0 / 6.1	4 / 7.9
20	Location	California				16	Min	1.0	Min		Peak watts	88	91	97	96
21	Latitude, longitude	37.81, -122.26				652	Max	40.8	Max		Peak current	2.9A (0.2C)	3A (0.2C)	3.2A (0.2C)	3.2A (0.2C)
22											Average watts	25	35	31	40
23	Highest ambient temp	43 to 95°F									Average current	0.7A (0C)	0.9A (0.1C)	0.8A (0.1C)	1.1A (0.1C)
24	Lowest ambient temp	34 to 63°F
25	Max cell temp	161°F
26
27	Average daily Wh by month:									Composite daily averages based on your inputs above:
28	Month	Fixed 0° tilt	1-axis NS travel	Gain vs. fixed 0° tilt	1-axis EW travel	Gain vs. fixed 0° tilt	2-axis tracking	Gain vs. fixed 0° tilt		Average miles/day	Combined daily Wh	50% each day w/ 0° fixed tilt	0% each day travelling NS w/ 1-axis tracking	0% each day travelling EW w/ 1-axis tracking	50% each day stationary charging
29	January	142	205	44%	250	76%	290	105%		13.5	216	71	0	0	145
30	February	196	272	39%	294	50%	346	77%		16.9	271	98	0	0	173
31	March	274	374	36%	340	24%	423	54%		21.8	349	137	0	0	212
32	April	377	508	35%	412	9%	536	42%		28.5	456	188	0	0	268
33	May	432	580	34%	457	6%	596	38%		32.1	514	216	0	0	298
34	June	457	616	35%	484	6%	632	38%		34.0	544	228	0	0	316
35	July	445	595	34%	473	6%	613	38%		33.1	529	223	0	0	306
36	August	400	550	37%	433	8%	578	44%		30.6	489	200	0	0	289
37	September	324	451	39%	388	20%	502	55%		25.8	413	162	0	0	251
38	October	246	365	49%	360	47%	450	83%		21.7	348	123	0	0	225
39	November	167	255	53%	303	82%	363	118%		16.6	265	83	0	0	182
40	December	127	196	54%	252	98%	298	134%		13.3	212	64	0	0	149
41	Annual	299	415	38%	371	24%	470	57%		24.0	384	150	0	0	235
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66