| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | EDITOR'S NOTE: This year's spreadsheet is still a work in progress (... cuz i'm lazy and tired of keeping up with the BOrg) | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | What | Quantity | Price Per Item | Item Total | Notes | Constants | ||||||||||||||||||||
4 | Ticket * | 0 | Ticket Aid (Low Income): est> | $225.00 | Max Qty=2 (except 'Ticket Aid'>>Max=1) See * Ticket Prices Table Below for details | * auto selects from table in Col A-B, Rows 15-19 | ||||||||||||||||||||
5 | Vehicle Pass | 1 | VP Price determined by Sale Type: $75 | $75.00 | Max Qty=1 VP prices same for all sales, except TAP | 150 | <<-- VP cost | VP TAP cost-->> | 75 | |||||||||||||||||
6 | Delivery ** | 1 | USA - UPS 2nd Day Air | $30.00 | See ** 2025 Delivery Prices Below | * auto selects from table in Col C-D, Rows 15-21 | ||||||||||||||||||||
7 | Service Fees (per item) | 1 | $4.50 | $4.50 | 4.5 | <<-- Service fee per Item | ||||||||||||||||||||
8 | 9% Nevada Live Entertainment Tax (Applies to Tickets only) | n/a | 0.09 * Ticket_Price * Ticket_Qty >> | $20.25 | 0.09 | <<-- NV Live Ent Tax in % | ||||||||||||||||||||
9 | Order Subtotal | $354.75 | ||||||||||||||||||||||||
10 | 4% Processing Fee (per order) | n/a | 0.04 * Subtotal >> | $14.19 | May appear as "Credit Card Processiing Fee" | 0.04 | <<-- Credit Card Fee in % | |||||||||||||||||||
11 | TOTAL | $368.94 | Ticket Aid Qty ERROR | |||||||||||||||||||||||
12 | ||||||||||||||||||||||||||
13 | Disclaimer: | This calculator is community-created by me (playa name: noPants) and may or may not reflect the realities the BM Org functions under. I try my best, based on the info I have at hand (see reference links). ENTER AT YOUR OWN RISK (i'm not yer mother). For question/requests, DM me on the FB TCO page... And/or right-click->"Comment" on any cell to ask question, make requests, or engage (but please keep snarkery to a minimum cuz as a crusty burner, i reserve the right to bite back, you've been warned.) also, yer welcome ~xoxo~ )'( <3 | ||||||||||||||||||||||||
14 | Reference: | https://help.burningman.org/hc/en-us/articles/34445304532500-How-much-will-2025-tickets-cost | ||||||||||||||||||||||||
15 | Reference: | https://tickets.burningman.org/ | ||||||||||||||||||||||||
16 | Note: | STEP' Sales are resold at the price/fee of the original sale for the item(s) | ||||||||||||||||||||||||
17 | Note: | Assumes "Make a Donation" to the BM Project is $0 since that cost should not be transferred in reselling | ||||||||||||||||||||||||
18 | NOTE: | this calculator does NOT handle the optional 'Ticket Insurance' since payment is handled through a 3rd-party site. See "Ticket Insurance" https://tickets.burningman.org/ | ||||||||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | * 2025 Ticket Prices | ** 2025 Delivery Prices | ** "Orders will begin shipping late June 2025" | |||||||||||||||||||||||
21 | Illuminating Tier - $3000 | $3,000 | Will-Call | $30 | Important Dates | Known Quantitites | ||||||||||||||||||||
22 | Embracing Tier - $1500 | $1,500 | USA - UPS 2nd Day Air | $30 | Today Sale | Registration: 02/03 - 02/11 >> Sale: 02/12 | Qty: ?? tix + ?? VP | |||||||||||||||||||
23 | Supportive Tier - $950 | $950 | USA - Mail Innovations (USA PO Boxes) | $20 | Stewards Sale (fka DGS) | Registration: 02/21 - 02/28 >> Sale: 03/05 - 03/08 | Qty: ?? tix + ?? VP | |||||||||||||||||||
24 | Covering Tier - $750 | $750 | Canada - Mail Innovations | $30 | Ticket Aid (Low Income) | Application: 02/19 - ??/?? >> Sale: late May++ | Qty: ?? tix + ?? VP | |||||||||||||||||||
25 | Communal Tier - $650 | $650 | Canada - UPS Worldwide | $65 | Resilience Program | Application: 02/19 - "TBD" >> Sale: "TBD" | Qty: ?? tix + ?? VP | |||||||||||||||||||
26 | Creative Tier - $550 | $550 | UPS Worldwide (Belgium, France, Germany, Greece, Italy, Luxembourg, The Netherlands, Portugal, Spain, UK) | $65 | Tomorrow Sale | Registration: "TBD" - "TBD" >> Sale: "TBD" | Qty: ?? tix + ?? VP | |||||||||||||||||||
27 | Resilience Program | $550 | OMG | Registration: 07/21 - 07/29 >> Sale: 07/30 | Qty: ?? tix + ?? VP | |||||||||||||||||||||
28 | STEP | Opens: 04/30 >> Sale: Date Varies | Qty: ?? tix + ?? VP | |||||||||||||||||||||||
29 | Ticket Aid (Low Income): est> | $225 | Other International == Will Call | $30 | ||||||||||||||||||||||
30 | ||||||||||||||||||||||||||
31 | ||||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | ||||||||||||||||||||||||||
34 | ||||||||||||||||||||||||||
35 | Resell Option 1 | |||||||||||||||||||||||||
36 | Reselling and splitting fees+taxes from purchase | Notes | ||||||||||||||||||||||||
37 | Sell 1x Ticket Only | n/a | = Tix_Price + (Delivery_Total / Item_Total) + 1x_Service_Fee + ( Ent_tax / Ticket_Qty) + ( Proc_fee / Item_Total ) | |||||||||||||||||||||||
38 | Sell VP Only | $123.69 | = VP_Total + (Delivery_Total / Item_Total) + 1x_Service_Fee + ( Proc_Fee / Item_Total ) | |||||||||||||||||||||||
39 | Sell 1x Ticket + VP | see VP only | = sell 1x ticket price (cell b26) + sell vp only price (cell b27) | |||||||||||||||||||||||
40 | Split All (partner split) | $184.47 | = TOTAL / 2 | |||||||||||||||||||||||
41 | #VALUE! | |||||||||||||||||||||||||
42 | ||||||||||||||||||||||||||
43 | Resell Option 2 ?? | |||||||||||||||||||||||||
44 | Reselling and charging orig fees+taxes | Notes | ||||||||||||||||||||||||
45 | Sell 1x Ticket Only | $290.94 | = [ Tix_Price + (Ent_Tax * Tix_Price) + Delivery + 1x_Service_Fee ] * Proc_fee | |||||||||||||||||||||||
46 | Sell VP Only | $113.88 | = ( VP_Total + Delivery + 1x_Service_Fee ) * Proc_Fee | |||||||||||||||||||||||
47 | Split All | $184.47 | = TOTAL / 2 | |||||||||||||||||||||||
48 | ... sanity_check : resell 2x tix + VP == $695.76 ...higher total to recoup resell efforts by recharging delivery fee? | |||||||||||||||||||||||||
49 | ||||||||||||||||||||||||||
50 | Resell Option 3 ?? | |||||||||||||||||||||||||
51 | Reselling and splitting delivery as weighted function item's face value | Notes | ||||||||||||||||||||||||
52 | Sell 1x Ticket Only | $283.14 | = [ Tix_Price + (Ent_Tax * Tix_Price) + ((Tix_Price / (Ttl_Tix + Ttl_VP)) * Delivery) + 1x_Service_Fee ] * Proc_fee | |||||||||||||||||||||||
53 | Sell VP Only | $89.96 | = [ VP_Price + 1x_Service_Fee + ((Tix_Price / (Ttl_Tix + Ttl_VP)) * Delivery) ] * Proc_Fee | |||||||||||||||||||||||
54 | Split All | $184.47 | = TOTAL / 2 | |||||||||||||||||||||||
55 | ... sanity_check : resell 2x tix + VP == $656.24 ...cuz some guy on fb thought this makes sense, lolz ¯\_(ツ)_/¯ | |||||||||||||||||||||||||
56 | ||||||||||||||||||||||||||
57 | ||||||||||||||||||||||||||
58 | To-do: | 2025.02.12 | separate out order options per ticket (and figure out what the resell breakdown for that feckery will look like) | |||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | Changelog: | 2025.07.10 | cleaned up share permissions; updated Editor's note and Disclaimer | |||||||||||||||||||||||
61 | 2025.02.12 | added Disclaimer text | ||||||||||||||||||||||||
62 | 2025.02.12 | typo fixed... "2024" -> "2025" (thx 8bitbunny) | ||||||||||||||||||||||||
63 | 2025.02.11 | Fixed Named Ranges for 2025 (fixed issue with pulldowns) | ||||||||||||||||||||||||
64 | 2025.02.11 | Updated Delivery prices for 2025 | ||||||||||||||||||||||||
65 | 2025.02.11 | Updated Sale/Application dates for 2025 | ||||||||||||||||||||||||
66 | 2025.02.11 | Copy New tab for 2025 | ||||||||||||||||||||||||
67 | 2024.03.14 | Fixed Named Ranges for 2024 (fixed issue with pulldowns) | ||||||||||||||||||||||||
68 | 2024.03.13 | Fixed dates (typo) for Main Sale | ||||||||||||||||||||||||
69 | 2024.03.13 | Modified calculation for Credit Card Processing to roundup no matter what because the site does (sadly) | ||||||||||||||||||||||||
70 | 2024.03.07 | Removed Ticket Value == 0 (zero) option since VPs can no longer be purchased separately | ||||||||||||||||||||||||
71 | 2024.02.08 | Added basic data: qty of tickets and vp available | ||||||||||||||||||||||||
72 | 2024.02.08 | Added validation / notification of TAP Qty violations | ||||||||||||||||||||||||
73 | 2024.02.08 | Updated VP calculations for Ticket Aid Program prices | ||||||||||||||||||||||||
74 | 2024.02.08 | Updated prices fo 2024 | ||||||||||||||||||||||||
75 | 2024.02.08 | Copy New tab for 2024 | ||||||||||||||||||||||||
76 | 2023.03.09 | Removed "STEP" from the "Main / OMG" since STEP sales use the original price of the item(s) being re-sold | ||||||||||||||||||||||||
77 | 2023.03.08 | Added Changelog | ||||||||||||||||||||||||
78 | 2023.03.08 | Fixed 'Div/0' error, in B28 and B30, if Ticket qty = 0 | ||||||||||||||||||||||||
79 | 2023.03.08 | Add note re: optional insurance | ||||||||||||||||||||||||
80 | 2023.02.22 | Added Resell Option 3 based on suggestion in FB TCO group | ||||||||||||||||||||||||
81 | 2023.02.21 | Modified calculator to use variables (held in col F) for constant values instead of being embedded in all calculations | ||||||||||||||||||||||||
82 | 2023.02.13 | Updated prices for 2023: Steward ticket, processing fee, UPS worldwide) | ||||||||||||||||||||||||
83 | 2023.02.12 | Copy New tab for 2023 | ||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||