electrical_budget_worksheet_SHTP 2023.xlsx

	A	B	C	D	E	F	H
1	Electrical Budget Worksheet
2	Boat Name
3
4	1	Calculate your DC Loads:
5
6		Lighting		Amps	Hours	AH/Day
7			Running Lights			0.0
8			Masthead Tricolor Light			0.0
9			Anchor Light			0.0
10			Strobe Light			0.0
11			Spreader Lights			0.0
12			Cabin Light (small)			0.0
13			Cabing Light (big incandescent)			0.0
14			Cabing Light (flourescent)			0.0
15			Instrument Lights			0.0
16			Handheld Spot Light			0.0
17			Other			0.0
18				Lighting AH		0.0
19
20		Galley		Amps	Hours	AH/Day
21			Refrigeration			0.0
22			Prop Solenoid			0.0
23			Other			0.0
24				Galley AH		0.0
25
26		Electronics		Amps	Hours	AH/Day
27			Autopilot			0.0
28			VHF (receive)			0.0
29			VHF (transmit)			0.0
30			SSB (receive)			0.0
31			SSB (transmit)			0.0
32			SSB Digital controller			0.0
33			GPS			0.0
34			Instruments			0.0
35			Weather fax receiver			0.0
36			Radar (standby)			0.0
37			Radar (transmit)			0.0
38			AIS			0.0
39			Energy Monitors			0.0
40			Stereo			0.0
41			Computer (screen off)			0.0
42			Computer (screen on)			0.0
43			Computer (serial adapter)			0.0
44			Other			0.0
45				Electronics AH		0.0
46
47		Plumbing		Amps	Hours	AH/Day
48			Fresh Water Pump			0.0	Calculate using average water consumption.
49			Bilge Pump(s)			0.0	This should be zero unless the boat leaks.
50			Other			0.0
51				Plumbing AH		0.0
52
53		Inverter		Watts	Hrs/day	AH/Day	All values assume inverter efficiency = 85%.
54			Microwave			0.0	Power factor may mess up this estimate.
55			Chargers (nicad)			0.0
56			Other			0.0
57				Inverter AH		0.0
58
59			Gross Energy Consumption AH/Day			0.0
60
61	2	Alternative Energy Sources
62			Device	Amps	Hrs/day	AH/day
63			Solar, avg			0.0	Assumes one large panel.
64			Wind, avg			0.0	Assumes AIR Marine wind turbine in good location.
65			Water, avg.			0.0
66			Contribution of AES AH/Day			0.0
67
68	3	Net Energy Consumption, AH/Day				0.0
69
70	4	Desired Hours Between Charging
71
72	5	Range of Battery Use					For example, from 50-85% state of charge.
73
74	6	Recommended Battery Capacity				#DIV/0!
75
76	7	Alternator Output, Amps					Target would be 25% flooded, 40% gel, of capacity.
77
78	8	Charge Efficiency Factor				0.85	Gels = 95%, flooded cells = 85%,Li=97%
79
80	9	Minimum Minutes to Charge				#DIV/0!	Assumes alternator runs at full output.
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100