Budget < Sites < Eugene Maker Space Wiki

You are here: Eugene Maker Space Wiki>Sites Web>ReverbiaCamp?>Budget (24 Aug 2011, ClifCox) (raw view)EditAttach

---+ Reverbia Camp Budget

%TOC%
---++ Income:
| *Type of campers* | *Number* | *Fee* | *Extended* |
| Artists | 0 | %CALC{"$FORMAT(DOLLAR, 2, 25)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Participants | 90 | %CALC{"$FORMAT(DOLLAR, 2, 40)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| RVs | 8 | %CALC{"$FORMAT(DOLLAR, 2, 110)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Dustfish contrib. | 1 | %CALC{"$FORMAT(DOLLAR, 2, 800)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| *Total* | %CALC{"$SUM( R2:C$COLUMN()..R$ROW(-1):C$COLUMN())"}% | | %CALC{"$FORMAT(DOLLAR, 2, $SUM( R2:C$COLUMN()..R$ROW(-1):C$COLUMN() ))"}% |

<!--
   * Set INCOME = %CALC{"$T(R$ROW():C4)"}%
   * Set SELECT1 = %CALC{"$LISTITEM($T(R$ROW():C2), $LIST(R5:C$COLUMN()..R$ROW(-2):C$COLUMN()))"}%
   * Set COST1 = %CALC{"$PRODUCT($T(R1:C2), R$ROW():C$COLUMN(-4)..R$ROW():C$COLUMN(-3), $T(R$ROW():C$COLUMN(-1)))"}%
   * Set TOTAL1 = %CALC{"$SUM($T(R$ROW():C2), $T(R$ROW():C7), $T(R$ROW():C12), $T(R$ROW():C17))"}%
-->
---++ Generator Worksheet
| *Fuel Cost* | %CALC{"$FORMAT(DOLLAR, 2,4.00)"}% | Per Gallon ||||| ||||| ||||| |
| | | ||||| ||||| ||||| |
| *Generator* | | *Preevent Values* ||||| *Event Values* ||||| *Postevent Values* ||||| *Total* |
| *Type* | *Cost* | *Days* | *HPD* | *% Cap* | *GPH* | *Cost* | *Days* | *HPD* | *% Cap* | *GPH* | *Cost* | *Days* | *HPD* | *% Cap* | *GPH* | *Cost* | |
| 25KW | 750 | 4 | 4 | 15% | .35 | %COST1% | 7 | 24 | 30% | 0.87 | %COST1% | 2 | 8 | 20% | .5 | %COST1% | %TOTAL1% |
| 45KW | 1100 | 4 | 4 | 20% | .72 | %COST1% | 7 | 24 | 27% | 1 | %COST1% | 2 | 8 | 20% | .72 | %COST1% | %TOTAL1% |
| 60KW | 2280 | 4 | 4 | 20% | .80 | %COST1% | 7 | 24 | 50% | 2 | %COST1% | 2 | 8 | 20% | .80 | %COST1% | %TOTAL1% |
| | | | | | | | | | | | | | | | | | |
| *Selected Gen* | 3 | | | | | | | | | | | | | | | | %SELECT1% |

<!--
   * Set GENERATOR = %CALC{"$EVAL($T(R$ROW():C18))"}%

Gen = %GENERATOR%<br />-->

---++ Expenses:
| *Description* | *Qty* | *Cost* | *Extended* |
| Generator | 1 | 2280 |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Generator one time fee | 1 | %CALC{"$FORMAT(DOLLAR, 2, 250.00)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Fuel | 1 | %CALC{"$FORMAT(DOLLAR, 2, 1196.40)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Rented Cables | 0 | %CALC{"$FORMAT(DOLLAR, 2, 65)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Hubble Ends | 0 | %CALC{"$FORMAT(DOLLAR, 2, 42)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Bay Tarps | 2 | %CALC{"$FORMAT(DOLLAR, 2, 59.12)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Dome Tarps | 0 | %CALC{"$FORMAT(DOLLAR, 2, 84.58)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Rope light (18' White) | 0 | %CALC{"$FORMAT(DOLLAR, 2, 11.6475)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Rope light (18' Blue) | 0 | %CALC{"$FORMAT(DOLLAR, 2, 12.80)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Camp Water | 1100 | %CALC{"$FORMAT(DOLLAR, 2, 0.50)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Tickets | 1 | %CALC{"$FORMAT(DOLLAR, 2, 160)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Consumeables | 1 | %CALC{"$FORMAT(DOLLAR, 2, 375.92)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Gas for Sound Guy | 1 | %CALC{"$FORMAT(DOLLAR, 2, 200)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Stage Rental | 1 | %CALC{"$FORMAT(DOLLAR, 2, 200)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| Vehicle Fuel (Hauling) | 1 | %CALC{"$FORMAT(DOLLAR, 2,50)"}% |  %CALC{"$EVAL($T(R$ROW():C2) * $T(R$ROW():C3))"}% |
| *Total* | | | %CALC{"$FORMAT(DOLLAR, 2, $SUM( R2:C$COLUMN()..R$ROW(-1):C$COLUMN() ))"}%  |

Notes:

Some generator specs: http://www.multiquip.com/multiquip/pdfs/PS%20-%20product-brochures/MQ_Power_WhisperWatt25SS-180SSJ_Rev2.pdf

Doug paid the sound guy $200 out of his pocket.

-- Main.ClifCox - 2010-07-30

Topic revision: r21 - 24 Aug 2011 - 01:48:35 - ClifCox

Sites

Webs
Main
Sandbox
Sites
System

Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Eugene Maker Space Wiki? Send feedback