Where the current tool falls short
- A cell has no idea an item carries a calibre, a net explosive content and a hazard category: the inventory stays a list of names.
- Batches and their expiry dates sit in a column nobody re-reads before the show.
- No reliable version: “stock-v7-final-ok.xlsx” lives on three laptops and everyone edits their own.
What PyroDesk changes
- Every item carries its calibre, category, net explosive content and dated batches; stock is drawn down when the firing plan is confirmed.
- Quote, contract, authority declaration and invoice all come from the same dossier: no more retyping between tabs.
- One shared database on computer, tablet and phone, with a history of who changed what.
Nearly every fireworks company started with a workbook: one tab for stock, one for quotes, one for dates. It works as long as a single person fills it in and the season holds a handful of shows. Then come batches received on different dates, the same item under two supplier references, the candle taken out for a show and never removed from the total. A spreadsheet refuses nothing, and that is exactly the problem: it accepts a mistake without blinking.
The real cost does not show up in the file. It shows up the evening you discover on site that three 100 mm shells are missing, or when the authority asks for the product list and you have to rebuild it by hand from four tabs. Formulas break silently when a row is inserted in the wrong place, macros do not survive a change of laptop, and nobody knows anymore which copy is the truth between the office computer and the one in the van.
PyroDesk keeps what the spreadsheet did well — a readable grid, instant totals — and adds what it never knew: the pyrotechnic nature of each item. Your current catalogue can be imported from the workbook, columns are recognised, and every row becomes a proper item with calibre, category and batches. The quote is built by picking services, the firing plan reserves stock, the authority declaration is pre-filled, and the accounting export goes to your accountant without an intermediate file.