OCFIT 2024 proposed budget
Worksheets
These are here to help us understand what
might go into a project, like a bill of materials. Some are here for reference only, and do not contribute to the total. The rows with zero quantity are alternative sources or versions of a part. This makes life easy if the primary source is out of stock, or we need to adjust some aspect of a project.
The best way to read this proposal is to start at the "
Totals" section, and follow the links for each line item back up to the worksheets to see where their subtotals came from.
Consumables
This is in cost per foot, the other cables are by the spool. All cables must be gel filled, flooded, etc... Solid copper wire is preferred, not copper clad aluminum (CCA). Search terms: Direct Burial, CMX, CMXF -> Flooded, Floodant, Gel filled
Search terms: Direct Burial, CMX, CMXF -> Flooded, Floodant, gel filled, Or Submerged. Also, Carrier, Aerial, Or Messenger.
Coax Hardline
Fiber
Small Network Switches
The fair uses (and looses) a few switches each year.

Since fixing network outages quickly at our three day event is important, our switches must at a minimum be pingable so we get an alert if they are accidently unplugged. Also we use VLANs everywhere so they have to support those also. This means we need managed switches. Lastly, we use
OpenWRT to make device management as uniform as possible, so we have a preference for ones that support
OpenWRT.
List of
OpenWRT supported switches:
https://openwrt.org/toh/views/toh_extended_all?dataflt%5BDevice+Type*%7E%5D=Switch
D-Link DGS-1100-05PD. Netgear
GS105PE, Trendnet TPE-P521E, Ubiquiti Unifi US-8,
DGS-1100-08PD and the
GS108TV2 (power in only)
New NOC UPS Battery Bank
Our battery bank died after about 10 years of service, Since lead acid batteries are now more expensive per watt hour we are switching to Lithium Iron Phosphate.
NOC Backup Router
| Description |
URL |
Qty |
Cost |
Shipping |
Verified? |
Extended |
| IKuaios 8 port, 2 SFP, Core i7 3520 8G 128G SSD (2 10G SFP option) |
aliexpress.com |
0 |
$500.00 |
$75.48 |
* |
$0.00 |
| ebay 6 port + 4SFP, i5 6400 8G |
ebay:goipvoipcom |
0 |
$725.00 |
$0 |
* |
$0.00 |
| IKuaios 6 port, 2 SFP+ Core i5 4460 8GB |
aliexpress.com |
0 |
$555.00 |
$136.59 |
* |
$0.00 |
| Partaker 4 port + 4 SFP + 2 SFP+ Core i7 4770 2GB |
aliexpress.com |
0 |
$848.64 |
$85.85 |
* |
$0.00 |
| Yzlong 8 port + 4 SFP+ I5-6500 16G 120G |
aliexpress.com |
1 |
$762.60 |
$164.42 |
* |
$927.02 |
| Yzlong 8 port + 4 SFP+ I5-6500 8G 120G |
aliexpress.com |
2 |
$718.15 |
$164.42 |
* |
$1,765.14 |
| |
|
|
|
|
|
$0.00 |
| |
|
|
|
|
|
$0.00 |
| Bare Router WG XTM 5 |
sne_98226 |
0 |
$110.29 |
$15.95 |
|
$0.00 |
| DDR3 Ram 8G |
aliexpress.com |
0 |
$21.90 |
$0 |
|
$0.00 |
| DDR3 Ram 8G |
ebay:golucklyisland |
0 |
$31.88 |
$0 |
|
$0.00 |
| DDR3 Ram 8G |
Amazon |
0 |
$25.80 |
$0 |
|
$0.00 |
| DDR4 Ram 8G |
Amazon |
0 |
$33.99 |
$0 |
|
$0.00 |
| 120GB SSD |
Amazon |
0 |
$17.99 |
$0 |
|
$0.00 |
| 120GB MSATA |
Amazon |
0 |
$30.88 |
$0 |
|
$0.00 |
| 750GB SSD |
ebay:digitalzone10 |
0 |
$29.76 |
$0 |
|
$0.00 |
| New fans for older boxes |
pixietrickster |
0 |
$9.95 |
$3.95 |
|
$0.00 |
| CPU upgrade adapter |
|
0 |
$2.19 |
$0 |
|
$0.00 |
| Xeon L5430 CPU |
|
0 |
$17.99 |
$0 |
|
$0.00 |
| Xeon E5450 CPU |
|
0 |
$14.99 |
$0 |
|
$0.00 |
| I7-4770 3.4ghz |
ebay:lamdoi |
0 |
$135.00 |
$0 |
|
$0.00 |
| i5-6500 CPU |
Amazon |
0 |
$169.99 |
$15.99 |
|
$0.00 |
| SD to CF card adapter |
|
0 |
$8.19 |
$0.99 |
|
$0.00 |
| subtotal: |
$2,692.16 |
Small Routers
| Description |
URL |
Qty |
Cost |
Shipping |
Verified? |
Extended |
| BKHD 8 port I5 3217U 8GB |
aliexpress.com |
0 |
$400.00 |
$79.63 |
* |
$0.00 |
| 8 port I5 3320M, 8G |
MacMall |
0 |
$666.99 |
$0 |
|
$0.00 |
| IKuaios I7 3520M, 2G |
aliexpress.com |
1 |
$295.00 |
$61.25 |
* |
$356.25 |
| Partaker 8 port |
aliexpress.com |
0 |
$380.64 |
$82.89 |
|
$0.00 |
| |
aliexpress.com |
0 |
$277.54 |
$91.47 |
|
$0.00 |
| Bare Router WG XTM 5 |
sne_98226 |
0 |
$110.29 |
$15.95 |
|
$0.00 |
| DDR3 Ram 8G |
aliexpress.com |
0 |
$21.90 |
$0 |
|
$0.00 |
| DDR3 Ram 8G |
ebay:golucklyisland |
0 |
$31.88 |
$0 |
|
$0.00 |
| DDR3 Ram 8G |
Amazon |
0 |
$25.80 |
$0 |
|
$0.00 |
| DDR4 Ram 8G |
Amazon |
2 |
$33.99 |
$0 |
|
$67.98 |
| 120GB SSD |
Amazon |
0 |
$17.99 |
$0 |
|
$0.00 |
| 120GB MSATA |
Amazon |
1 |
$30.88 |
$0 |
|
$30.88 |
| 750GB SSD |
ebay:digitalzone10 |
0 |
$29.76 |
$0 |
|
$0.00 |
| New fans for older boxes |
pixietrickster |
0 |
$9.95 |
$3.95 |
|
$0.00 |
| CPU upgrade adapter |
|
0 |
$2.19 |
$0 |
|
$0.00 |
| Xeon L5430 CPU |
|
0 |
$17.99 |
$0 |
|
$0.00 |
| Xeon E5450 CPU |
|
0 |
$14.99 |
$0 |
|
$0.00 |
| I7-4770 3.4ghz |
ebay:lamdoi |
0 |
$135.00 |
$0 |
|
$0.00 |
| i5-6500 CPU |
Amazon |
0 |
$169.99 |
$15.99 |
|
$0.00 |
| SD to CF card adapter |
|
0 |
$8.19 |
$0.99 |
|
$0.00 |
| subtotal: |
$455.11 |
Cable CMTS Project
Head End Equipment
Per Node Equipment
This table shows just the cable equipment for each new node.
Alternative Non-CMTS Nodes
Ritz / Poo Corner
Sticker Booth:
This table shows just the equipment for the Sticker booth sans the RG11. The box may someday have to hold fiber so it may need to be bigger.
Sticker Booth Wireless Backup
This is the proposed wireless backup to the sticker booth link.
Doug's Green
This table shows just the equipment for Doug's Green.
Main Camp Upgrade
Traffic Camp Upgrade
This table shows just the equipment for non-CMTS nodes such as White Bird and the Ritz.
Wifi Radios for the CMTS. and Alternative Nodes
Notes: Please see:
Repeater Upgrade for background info. This table shows the costing for the Wifi portion of each CMTS node.
Notes: We can get warranties on the radios starting at $12.00.
Parts for VISA card and ATM machines.
The visa runs will need some cat6 and a few radios to fill in coverate in those areas.
Peach Power Network Upgrade
It turns out that the best place for our reference GPS station is out in miss Piggy's on the Tickets West pole.

The current data connection to Tickets West is an old nicked, spliced, waterlogged, corroded, indoor only cable that was buried in the ground with no protection. It's a miracle that it's lasted this long. So in order to avoid a last minute emergency, we should jump on this.
| Description |
URL |
Qty |
Cost |
Shipping |
Verified? |
Extended |
| RG11 500 FT Underground Cable |
abcconf.com |
1 |
$91.50 |
$58.10 |
|
$149.60 |
| Underground junction box |
zoro.com |
0 |
$70 |
$5.00 |
* |
$0.00 |
| F Connectors |
summitsource |
5 |
$1.89 |
$1.21 |
|
$15.50 |
| TRENDnet Modems |
amazon.com |
2 |
$39.99 |
$0.00 |
|
$79.98 |
| 3" PVC Conduit |
Jerrys |
0 |
$20.62 |
$0 |
* |
$0.00 |
| 3" PVC Conduit |
Ace Hardware |
40 |
$17.99 |
$0 |
* |
$719.60 |
| Underground junction box |
True Value |
0 |
$13.20 |
$0 |
|
$0.00 |
| Underground junction box |
Jerrys |
3 |
$20.07 |
$0 |
|
$60.21 |
| Underground junction box |
zoro.com |
0 |
$178 |
$0 |
* |
$0.00 |
| Underground junction box |
sprinklerwhs |
0 |
$184 |
$0 |
* |
$0.00 |
| Underground junction box |
sprinklerwhs |
0 |
$472 |
$0 |
* |
$0.00 |
| 2" Steel Pole |
Coyote Steel |
1 |
$170 |
$0 |
|
$170.00 |
| 3" Steel Pole |
Coyote Steel |
0 |
$224 |
$0 |
|
$0.00 |
| 3.5" Steel Pole |
Coyote Steel |
0 |
$259 |
$0 |
|
$0.00 |
| Ditch Witch rental |
|
1 |
$175 |
$0 |
|
$175.00 |
| Auger rental |
|
1 |
$55 |
$0 |
|
$55.00 |
| |
|
|
|
|
|
|
| Subtotal: |
|
|
|
|
|
$609.81 |
Totals
| Description |
Worksheet |
Qty |
Cost |
Extended |
| Network Upgrade |
| NOC Backup Router |
NOC_Backup_Router |
0 |
$2,692.16 |
$0.00 |
| New Routers |
Backup_Router |
0 |
$455.11 |
$0.00 |
| Cat 6 |
Ethernet_Cable |
5000 |
$0.24 |
$1,200.00 |
| RG11 Coax |
Coax_Cable |
3 |
$219.00 |
$657.00 |
| Small Switches |
Small Switches |
1 |
$5.00 |
$5.00 |
| CMTS distribution |
Head_End |
0 |
$2,383.75 |
$0.00 |
| CMTS Nodes |
Per_Node |
1 |
$264.60 |
$264.60 |
| Alt Nodes |
Alt_Node |
1 |
$264.60 |
$264.60 |
| CMTS hardline |
Coax_Hardline |
0 |
$921.40 |
$0.00 |
| CMTS Node Radios |
Wifi_Radios |
3 |
$394.47 |
$1,183.41 |
| Sticker Booth Wireless Backup. |
SB Backup |
1 |
$732.38 |
$732.38 |
| Subtotal: |
$4,306.99 |
| Batteries |
| New NOC UPS |
New NOC UPS |
0 |
$2,637.94 |
$0.00 |
| New Dual Pro Charger |
|
0 |
$342.52 |
$0.00 |
| Uniform DC Connectors with fuses |
|
0 |
$17.60 |
$0.00 |
| Replacement Batteries |
|
2 |
$132.99 |
$265.98 |
| Low Voltage Disc |
|
2 |
$10 |
$20.00 |
| Subtotal: |
$285.98 |
| Misc |
| PoEs, Drives, Cat 5, etc... |
|
1 |
$200.00 |
$200.00 |
| A few SIP phones. |
|
0 |
$35.00 |
$0.00 |
| Skype, or MJ accounts |
|
0 |
$40.00 |
$0.00 |
| New Climbing Rope |
|
0 |
$199.44 |
$0.00 |
| Rope Bag |
|
0 |
$25 |
$0.00 |
| Misc CMTS HW |
|
1 |
$500 |
$500.00 |
| Subtotal: |
|
|
|
$700.00 |
| |
|
| Total: |
|
|
|
$5,292.97 |
| Alocated: |
|
1 |
$5,292.97 |
$5,292.97 |
| Difference: |
|
|
|
$0.00 |
| Percent Over: |
|
|
|
0.0% |
--
ClifCox - 31 Oct 2022