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 to open this spreadsheet in google docs
3
Click Here for Auditable Receipts per AJs Purchases - also individual ones are directly inline on spreadsheet
4
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
5
statusItemItem nameSubsystemQty.Price (Dollars)Total
purchaser-status
Link to ReceiptPurchase Notes
6
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
7
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
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
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
18
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
19
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
20
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!
21
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
22
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
23
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
24
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
25
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
26
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
27
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
28
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
29
purchasedpanel antennaoutdoor panel antennaB) Cell Booster2$7.00$14.00
AJ - budget permitting reimbursable
https://drive.google.com/open?id=1zjX2W406vvgrU0QYVXNKWWrzlzBiBMHP
lintratek
30
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
31
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
32
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
33
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!
34
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
35
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
36
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)
37
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)
38
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
39
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
40
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
41
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
42
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
43
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
44
Kelvin Paid via ZSF budget?Gasfillup - 13 May 2018Z) Logistics1$25.00$25.00kelvin-zsf paid?
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
45
Kelvin Paid via ZSF budget?Gasfillup - 14 May 2018Z) Logistics1$48.50$48.50kelvin-zsf paid?
https://drive.google.com/open?id=0B7BiBCglAf_7WWMwZi1veWxsMF9yS2UxdXhZMjRabzNHZFJZ
46
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
47
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
48
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...
49
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
50
pay in Zambia
Tobias 2 nights Lusaka to pick up gear/volunteers
Z) Logistics2$35.00$70.00tbdnaapproximate nightly rate - tbd
51
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
52
-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
53
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
54
TOTALS BELOW BY PAYER / ACCOUNT PURCHASES MADE BY
55
$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
56
$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
57
$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
58
$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
59
$1,535.65
expenses covered by BYU proj etc before
60
61
62
63
64
65
66
Funding in place/Donations (some names shortened annonymized for privacy)
67
BYU sponsors (Shipp family foundation, Vertex42.com)
$1,500.00
68
Mike$100.00
69
John$100.00
70
David B5/1$100.00
71
Corbette Photography$88.90
72
Renae$25.00
73
Michael M$58.38
74
Alfonso S.$110.00
75
ZSF Budgeted new Bush HS $$2,700.00
76
anonymous donor #1$1,500.00covers amplifier cell cost
77
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)
78
Total Funding per date$10,782.28
79
80
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
81
82
PHASE 2 - OBSERVATION, MAINTENANCE, FEEDBACK PLANNING BUDGET
83
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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...