ZSF School Solar Pilot Budget - materials & logistics
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
BUDGET: May 2018 School Solar Project Pilot Trip:
Total 5 solar systems w 34 toughlight lanterns, 10 hybrid, & 4 cell booster setups (depending time may provide only 2-3 of 5 system setup/villiage training,
July/Oct trips install additional systems)
2
Click Here for Auditable Receipts per AJs Purchases - also individual ones are directly inline on spreadsheet
3
Click here to see the spreadsheet for detaile Bill of Materials - suppliers/vendors - URL's we order from: https://docs.google.com/spreadsheets/d/1BI1bsDtajjht4nnW3kYCaSx0q-v4AfxrpYbTOu6EAV4/edit?usp=sharing
4
statusItemItem nameSubsystemQty.Price (Dollars)Total
purchaser-status
Link to ReceiptPurchase Notes
5
bought from RadianSolar PanelT-BOLT SOLAR PANNEL MONO-SR156M-150W
A) Core Charging
5$118.50$592.50kelvin-zsf paidhttps://photos.app.goo.gl/9ma9ShCx2313Smnx15925 = 1185 x 5
6
bought from RadianconnectorTBolt battery connector 9k x 4
A) Core Charging
4$0.90$3.60kelvin-zsf paidhttps://photos.app.goo.gl/9ma9ShCx2313Smnx136 = 9 x 4 connects batteries cleanly, they only had 4
7
bought from RadianCable4mm Ripcord 10 m long
A) Core Charging
4$13.00$52.00kelvin-zsf paidhttps://photos.app.goo.gl/9ma9ShCx2313Smnx1130 x 4 10meter cables black and red, 4 covers 2 setups
8
bought from RadianCable4mm Ripcord 5 m long
A) Core Charging
6$6.50$39.00kelvin-zsf paidhttps://photos.app.goo.gl/9ma9ShCx2313Smnx165 x 5 5meter cables black and red, 6 covers 3 setups
9
Radian discountitems above in green5% discount on items shown
A) Core Charging
1-$34.36-$34.36nahttps://photos.app.goo.gl/9ma9ShCx2313Smnx1discount on everything but batteries
10
bought from RadianBattery
LEOCH SOLAR LPG SERIES BATTERY-12V-150S
A) Core Charging
5$263.50$1,317.50kelvin-zsf paidhttps://photos.app.goo.gl/H9KSd1dqw7rrZGFm2in zambia
11
bought from RadianPanel & connectors
extra 1 150Watt Panel + connectors after 1 broke
A) Core Charging
1$131.90$131.90kelvin-zsf paidhttps://photos.app.goo.gl/LmrqD699KswHhF9ZAaccident broke 1 of 5 panels, this replaced it, we still used the broken one in paralell
12
bought in Lusaka by Abraham
lag bolts (coach screws)
lag bolts (coach screws)
A) Core Charging
1$16.00$16.00
AJ - budget permitting reimbursable
https://photos.app.goo.gl/I9i8fi4fvNotm74T2
13
bought in Lusaka by Abrahamdrill bits adapterdrill bits adapter
A) Core Charging
1$17.40$17.40
AJ - budget permitting reimbursable
https://photos.app.goo.gl/EUrXMaolwvCj8ouE2
14
bought in Kasama from metalshop
materials for panel mounts
brush,red oxide 1ltr,2kg welding rods,angle brackets
A) Core Charging
1$55.20$55.20kelvin-zsf paidhttps://photos.app.goo.gl/deiIqyZMHdSau1nJ2
15
bought in Kasama Luckson Siame
Measuring TapeMeasuring Tape
Y) HW/Tools install
1$1.50$1.50kelvin-zsf paid
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
16
Pain Welder in Kasama
labor welding solar mounts
labor welding solar mounts
A) Core Charging
1$30.00$30.00kelvin-zsf paidhttps://photos.app.goo.gl/mXxqSxAFvPucaPlb2
17
purchasedCharge Controller
ALLPOWERS Dual USB 20A Solar Charge Controller
A) Core Charging
2$28.99$57.98
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1QfSUJibth3SMVKxOeR1LGTawZfRFLjYs
1 left over from prototype
18
purchasedCharge Controller
ALLPOWERS Dual USB 20A Solar Charge Controller
A) Core Charging
1$28.99$28.99
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1QldESE-B85qRxfz_nA2czDUIrTYONofy
1 left over from prototype
19
purchased12V to 5V USB hub
modified Car Charger Jellly Combo 6 ports 65W/13A Car Charger
A) Core Charging
2$15.88$31.76
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1QfSUJibth3SMVKxOeR1LGTawZfRFLjYs
20180420 amazon AJ - they changed their price again!
20
purchased12V to 5V USB hub
modified Car Charger Jellly Combo 6 ports 65W/13A Car Charger
A) Core Charging
2$11.99$23.98
AJ - budget permitting reimbursable
https://drive.google.com/open?id=18njuKcUQsJppNefJ2uizpmnuJMQsOGvL
20180319 amazon AJ
21
purchased12V to 5V USB hub
modified Car Charger Jellly Combo 6 ports 65W/13A Car Charger
A) Core Charging
1$14.99$14.99
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1RFcHE4TilI_2jSEk2FCn30NXlPa6429l
20180106 amazon AJ
22
purchasedinverterinverter
A) Core Charging
1$29.99$29.99
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1fOL9tnB0uDk1yrGwM0W3N0tSPawyKpxt
Intverter for charging tools at worksite US only adapter
23
purchasedLantern$20 wire fee for the 22 lantern purchaseC) Lanterns1$20.00$20.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1eHYemlZ8LHX80U8utrRcSHt5wB481s5q
24
purchasedLantern
Tough Light 200 hrs usb rechargeable 6000 mAh Li-ion battery ( 53 * 22 + 20 wire fee)
C) Lanterns22$53.00$1,166.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1cG-H28By2kc-DYcX8XYCrGtG8nD0iR-3
10 bush school, 6 elem, 6 elem
25
purchasedLantern
https://hybridlight.com/product/the-puc/ 4000 mAh 75 lumens 40 hrs
C) Lanterns10$12.00$120.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=0B7BiBCglAf_7RkEtSFZiMGlGU2ZFQ2xfRndyckpLWjFxaUs0
26
purchasedLantern
Tough Light 200 hrs usb rechargeable 6000 mAh Li-ion battery ( 55 * 12 + 20 wire fee)
C) Lanterns12$56.66$679.92
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1jHiz5UpvdMMpnHgSMxNzxKXLv9THZ5vu
2 more elem schools, 6 at each
27
purchasedAmplifier
Dual band signal amplifier 900/2100mhz Model: KW23A-GW
B) Cell Booster3$88.00$264.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1zjX2W406vvgrU0QYVXNKWWrzlzBiBMHP
lintratek
28
purchasedpanel antennaoutdoor panel antennaB) Cell Booster2$7.00$14.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1zjX2W406vvgrU0QYVXNKWWrzlzBiBMHP
lintratek
29
purchasedpanel antennaindoor panel antenna 2 meter cableB) Cell Booster1$6.00$6.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1zjX2W406vvgrU0QYVXNKWWrzlzBiBMHP
lintratek
30
purchased
shipping for lintratek stuff
B) Cell Booster1$70.00$70.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1zjX2W406vvgrU0QYVXNKWWrzlzBiBMHP
lintratek shipping and commision
31
purchasedPower CablesUSB to 5V cables for amplifier- 3 packB) Cell Booster1$7.99$7.99
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1fOL9tnB0uDk1yrGwM0W3N0tSPawyKpxt
32
have enough already
Coax Male N-type connectors
N Male Clamp/Solder Connector - Micro 8/U (RG8X) & LMR-240
B) Cell Booster0$10.00$0.00nanawe actually did need these for the panel antennas, oops, we jimmy rigged last one at Chilombwa!
33
purchased
N type male to male barrel
N type male to male barrelB) Cell Booster1$12.00$12.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1ctyaG39kBdfHle5pcNWYMZFx1bU5tiTe
found we have enough for the initial systems
34
buy asapantenna mount tripod
Tripo'd Roof Mount For Antennas: 2FT Legs. Heavy Duty. Adjustable Feet
B) Cell Booster1$34.25$34.25
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1QJABv7EJFzIWye60HtmKLZBdZiU-qAWL
Baught 1 in US, then others have mounting straps for pole or tree, tbd
35
AJ bought Shoprite KasamatoolsBow Saw 41K, 141PCEtool set 359K
Y) HW/Tools install
1$40.19$40.19
AJ - budget permitting reimbursable
https://photos.app.goo.gl/rllycnRHgQXIiNxa2tools to left with "Solar Maintenance Team" (Tobias/Kelvin and tbd)
36
AJ bought Lowes Bountifultools
phillips/screwdriver/adjustable wrench/wire cutter/strippers/hanger tape/caulk/screws
Y) HW/Tools install
1$92.02$92.02
AJ - budget permitting reimbursable
https://photos.app.goo.gl/GHdcK3TwDdDyCbrs1tools to left with "Solar Maintenance Team" (Tobias/Kelvin and tbd)
37
AJ bought metal shop Kasamaroofing screws
metal roofing screws w. rubber water seal washers
Y) HW/Tools install
1$15.00$15.00
AJ - budget permitting reimbursable
https://photos.app.goo.gl/ONtL67P1EABGHvWv1
38
AJ bought @ Mblashi Auto Spares, Kasama
bolts & washersbolts and washers for mounting solar panel
Y) HW/Tools install
1$12.00$12.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
39
AJ bought tool shop "Nkolelela General Dealers" Kasama
caulksilicon roofing caulk
Y) HW/Tools install
1$3.50$3.50
AJ - budget permitting reimbursable
https://photos.app.goo.gl/n9Oujb5i6LfUnWVB3
40
AJ bought "Clemal General Dealer" electronic shop Kasama
power adapter
For 220V to 20V adapter for charging impact driver
Y) HW/Tools install
1$15.00$15.00
AJ - budget permitting reimbursable
https://photos.app.goo.gl/Ak2Asgl1kCEX8yUV2
41
Kelvin Paid via ZSF budgetGas
#1 fillup 85.41 Liters @ 12.01K/L landcruiser Monday May 7, 2018
Z) Logistics1$102.58$102.58kelvin-zsf paidhttps://photos.app.goo.gl/DPE7HDXQ6HpDsOpc220180507 gas 1st 1 tank fillup
42
AJ paid cash via Jim/AndrewGas#2 fillup - Friday 11 May 2018 before MbusaZ) Logistics1$60.00$60.00
AJ - on house no receipt
trying to find, I'll cover this
43
Kelvin Paid via ZSF budget?Gasfillup - 13 May 2018Z) Logistics1$25.00$25.00kelvin-zsf paid?
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
44
Kelvin Paid via ZSF budget?Gasfillup - 14 May 2018Z) Logistics1$48.50$48.50kelvin-zsf paid?
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
45
Kelvin Paid via ZSF budget?Gas#3 fillup - 17 May 2018 end of tripZ) Logistics1$48.40$48.40kelvin-zsf paid?
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
46
Kelvin Paid via ZSF budget?Road TollsHW/Tools install road tollsZ) Logistics3$2.00$6.00kelvin-zsf paid?
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
47
AJ Paid Dominick CashDriver for Bush4 nights in Bush at $55 per nightZ) Logistics4$55.00$220.00
AJ - budget permitting reimbursable
Kelvin getting copy of from Dominick todo
45 a night was standard, Tobias said we over paid but Dominick asked for it.. we won't have Dominick drive again probably...
48
paidAbraham - gas/time
Abraham fee to pick up, store, coordinate buying solar materials & rental truck
Z) Logistics1na$50.00
AJ - budget permitting reimbursable
na
$50 + AJ gave 2 pairs jeans (AJs gift) - we ended up between Richard being picked up and taking to Indian food paying a bit more, no biggy
49
pay in Zambia
Tobias 2 nights Lusaka to pick up gear/volunteers
Z) Logistics2$35.00$70.00tbdnaapproximate nightly rate - tbd
50
volunteer paid
lodging/food/ some transport / airfare
lodging/food/ some transport / airfare 4 volunteers
Z) Logistics4$0.000nanaAJ Bradford, AJ Roth, Jim P, and Richard Tanner are covering their own expenses while in country and airfare to/from
51
-byu prototype materials see full bill of materialsna$1,500.00nana
included in budget then subtracted out in funds provided to show entire cost (materials in taking include 1 amplifier, coax, 1 charge controller, weatherproof box, connectors, small mast, 2 directional antennas + 2 mobilemark free directional antennas, 1 panel antenna, wires
52
PROJECT TOTAL:$7,112.29
This includes BYU prototype, etc of overall project but not self paid fee's from volunteers for their travel/lodging
53
TOTALS BELOW BY PAYER / ACCOUNT PURCHASES MADE BY
54
$3,062.96
AJ - budget permitting reimbursable
AJ paid via US credit on Amazon or Zambian Kwacha Cash (did 1USD:10KWacha rate which is about right, flucturates around that) I have all reciepts for these (minus drivers fee) and copies / scanned in for auditting
55
$60.00
AJ - on house no receipt
I'll cover these expenses for now as receipts can't be located and exact amount or if I paid vs. Kelvin can't be recalled
56
$2,453.68kelvin-zsf paid
Kelvin ZSF paid cash from checks made to our Zambia Cavmont bank account, he has all reciepts, I have copies/links scanned in too
57
$5,576.64
TOTAL ZAMBIAN PROJECT RELATED CASH FLOW (EXCLUDES BYU $1500, AND INDIVIDUAL VOLUNTEER EXPENSES)
It's likely there are many other misc. rlated expenses that were picked up by volunteers
It may be we'll increase this number as Kelvin submits project/trip related expenses he pulled out of the account
Possibily for things like more gas (their POV use for us), more minuts/data use on phones/internet, etc
But this total should cover the majority of large items and be pretty close
58
$1,535.65
expenses covered by BYU proj etc before
59
60
61
62
63
64
65
Funding in place/Donations (some names shortened annonymized for privacy)
66
BYU sponsors (Shipp family foundation, Vertex42.com)
$1,500.00
67
Mike$100.00
68
John$100.00
69
David B5/1$100.00
70
Corbette Photography$88.90
71
Renae$25.00
72
Michael M$58.38
73
Alfonso S.$110.00
74
ZSF Budgeted new Bush HS $$2,700.00
75
anonymous donor #1$1,500.00covers amplifier cell cost
76
anonymous donor #2$4,500.00
pilot project trip enable to 5 solar systems (4 of those cell amplifier systems) - (also helps us not cut corners as we were going to have to before on system (ie- funds now for mechanical mounts, etc available)
77
Total Funding per date$10,782.28
78
79
Extra being used for maintenance-future
$3,670.00
If this is negative then we are short, need more funding, some of this is going towards other Tobias/Kelvin expenditures related to trip/project
80
81
PHASE 2 - OBSERVATION, MAINTENANCE, FEEDBACK PLANNING BUDGET
82
Currently July 2018 Val S. Volunteer trip, then Oct 2018 Randy Volunteer trip will visit school's where systems deployed and provide feedback/maintenance - those trips are volunteer self funded
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
ZSF Budget Tracking May Trip
system cost summary
Itemized Single Solar System
Trip Breakdown Graph
volunteer hours
 
 
Main menu