Report this item to Etsy

Plumbing, heating, and air conditioning (SHK) offer Excel template: Sanitary/heating calculation, heat pump work values ​​(AW/Mk), copper/insulation quote, trade [DE/EN]

Item highlights

  • Digital download
  • Digital file type(s): 1 ZIP

Seller's description

Translated by Google
Sorry, we could not translate this listing to English.

Language: German and English (DE/EN).

No more forgotten C-items, copper price losses, and unpaid GEG pipe insulation! 🔧🔥

In the plumbing, heating, and air conditioning (PHVAC) industry, you're dealing with five-figure contract sums (bathroom renovations for €25,000, heat pumps for €30,000+). But when the quote is rushed through in the evening after work, forgotten press fittings, uncalculated mandatory insulation (as required by the German Energy Saving Ordinance - GEG), confusion between markup and actual margin, and fluctuating daily copper prices (MK price) can eat up thousands of euros in profit!

The **SHK Offer & Calculator PRO** from Schattenspiel is the precision business tool for SHK master craftsmen, plant mechanics, customer service technicians and building technology planners – **switchable directly in the file between German (DE) and English (EN) as well as 5 countries (DE, AT, CH, UK, US) with a single click!**

Why this system outperforms any simple standard template:
✅ **AW system (work units) vs. wage hours:** In the cockpit, you can flexibly switch between full project hourly rates and the customer service standard of work units (1 AW = 10 minutes = 6 AW/hr) for master craftsmen, customer service staff, journeymen and trainees – including a true full-cost break-even calculator (payroll tax factor + BGK/vehicle).
✅ **Markup vs. Actual Sales Margin + 3-Tier Matrix:** Prevents the most common calculation error in the trades (30% markup equals only 23.1% margin!). Calculate large appliances/heat pumps competitively (Tier 1: 18%), while securing your full margin for pipework (Tier 2: 28%) and C-parts/insulation (Tier 3: 35%).
✅ **Dynamic Copper Price Calculator:** Enter the daily copper price quote from your wholesaler (e.g., €1,490/100 kg over a €150 base = +€13.40/kg Cu). The calculator automatically applies the copper surcharge to the exact weight per meter for each pipe dimension!
✅ **Automatic 1:1 GEG mandatory insulation & fitting flat rate:** Simply enter the linear meters (lm) – Excel automatically adds +20% for press fittings/clamps and 100% of the legally required pipe insulation (GEG § 69 Annex 8 / DIN 1988-200 / ÖNORM H 5155 / SIA 384 / BS 5422 / IECC).
✅ **All forgotten heat pump cost drivers already on board:** Hydraulic balancing method B (VDZ), VDI 2035 demineralization, magnetite/sludge separator, core drilling, foundation and § 14a EnWG control line are already pre-calculated.
✅ **Two-stage dismantling & scrap copper module:** Offsets the dismantling of the old boiler against the current market value of scrap copper (e.g., 80 kg × €4.50/kg = €360 instant discount in the offer) – your strongest selling point against discussions about dismantling costs!
✅ **Subsidy Simulator & Tax Engine:** Calculates the effective customer contribution after subsidies (DE: KfW 458 up to 70% / max. €21,000 · AT: KPC Renovation Bonus · CH: Building Program · UK: £7,500 BUS + 0% VAT · US: IRA 25C + Material Sales Tax) and shows the labor costs separately according to **§ 35a para. 3 EStG** (incl. § 13b UStG Reverse Charge & 0% zero-tax mode).
✅ **Print-ready customer offer + wholesale order list (BOM):** On the left, on tab 5, you can print the sales-boosting customer offer using `Ctrl + P` (without the customer seeing your purchase prices or margins!), on the right you will find the sorted material order list for GC Group, Richter+Frenzel, Gienger & Co.

📦 **What you will receive immediately after purchase (complete zip package):**
1. **SHK_Kalkulation_Leer_Vorlage.xlsx** – Your clean master template (switchable DE / EN & DE/AT/CH/UK/US).
2. **SHK_Sample Project_Heat Pump.xlsx** – Fully calculated practical project “9 kW heat pump (R290) incl. gas boiler dismantling, 70 lfm pipe network/GEG insulation, €360 old copper credit & 55% KfW-458 funding”.
3. **SHK_Kalkulator_PRO_Handbuch_und_Rechtsleitfaden_DE.pdf** – German practical handbook including legal compass & print-ready **construction site measurement sheet (page 4)** for the clipboard in the basement.
4. **HVAC_Plumbing_Estimator_PRO_Guide_and_Legal_Reference_EN.pdf** – English manual including US/UK Building Codes & Printable Jobsite Take-Off Sheet.

🔒 **100% Macro-Free (.xlsx):** No virus warnings, runs instantly on Windows, Mac, and construction site tablets (Excel 2016 and later / Microsoft 365). Sheet protection password for customization: `schattenspiel.eu`

License: You may use the files privately and within your own company. You may not resell, distribute, publish, or use them for AI training. Questions? hallo [!at] schattenspiel.eu
You may use the files for personal purposes and within your own business. You may not resell, share, publish or use them for AI training. Questions? Email us at hallo [!at] shadowspiel.eu.

View more

NowPrice:$35.32

Original Price: $58.87

Loading

40% off

•

Sale ends in 2 days

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

Translated by Google
Sorry, we could not translate this listing to English.

Language: German and English (DE/EN).

No more forgotten C-items, copper price losses, and unpaid GEG pipe insulation! 🔧🔥

In the plumbing, heating, and air conditioning (PHVAC) industry, you're dealing with five-figure contract sums (bathroom renovations for €25,000, heat pumps for €30,000+). But when the quote is rushed through in the evening after work, forgotten press fittings, uncalculated mandatory insulation (as required by the German Energy Saving Ordinance - GEG), confusion between markup and actual margin, and fluctuating daily copper prices (MK price) can eat up thousands of euros in profit!

The **SHK Offer & Calculator PRO** from Schattenspiel is the precision business tool for SHK master craftsmen, plant mechanics, customer service technicians and building technology planners – **switchable directly in the file between German (DE) and English (EN) as well as 5 countries (DE, AT, CH, UK, US) with a single click!**

Why this system outperforms any simple standard template:
✅ **AW system (work units) vs. wage hours:** In the cockpit, you can flexibly switch between full project hourly rates and the customer service standard of work units (1 AW = 10 minutes = 6 AW/hr) for master craftsmen, customer service staff, journeymen and trainees – including a true full-cost break-even calculator (payroll tax factor + BGK/vehicle).
✅ **Markup vs. Actual Sales Margin + 3-Tier Matrix:** Prevents the most common calculation error in the trades (30% markup equals only 23.1% margin!). Calculate large appliances/heat pumps competitively (Tier 1: 18%), while securing your full margin for pipework (Tier 2: 28%) and C-parts/insulation (Tier 3: 35%).
✅ **Dynamic Copper Price Calculator:** Enter the daily copper price quote from your wholesaler (e.g., €1,490/100 kg over a €150 base = +€13.40/kg Cu). The calculator automatically applies the copper surcharge to the exact weight per meter for each pipe dimension!
✅ **Automatic 1:1 GEG mandatory insulation & fitting flat rate:** Simply enter the linear meters (lm) – Excel automatically adds +20% for press fittings/clamps and 100% of the legally required pipe insulation (GEG § 69 Annex 8 / DIN 1988-200 / ÖNORM H 5155 / SIA 384 / BS 5422 / IECC).
✅ **All forgotten heat pump cost drivers already on board:** Hydraulic balancing method B (VDZ), VDI 2035 demineralization, magnetite/sludge separator, core drilling, foundation and § 14a EnWG control line are already pre-calculated.
✅ **Two-stage dismantling & scrap copper module:** Offsets the dismantling of the old boiler against the current market value of scrap copper (e.g., 80 kg × €4.50/kg = €360 instant discount in the offer) – your strongest selling point against discussions about dismantling costs!
✅ **Subsidy Simulator & Tax Engine:** Calculates the effective customer contribution after subsidies (DE: KfW 458 up to 70% / max. €21,000 · AT: KPC Renovation Bonus · CH: Building Program · UK: £7,500 BUS + 0% VAT · US: IRA 25C + Material Sales Tax) and shows the labor costs separately according to **§ 35a para. 3 EStG** (incl. § 13b UStG Reverse Charge & 0% zero-tax mode).
✅ **Print-ready customer offer + wholesale order list (BOM):** On the left, on tab 5, you can print the sales-boosting customer offer using `Ctrl + P` (without the customer seeing your purchase prices or margins!), on the right you will find the sorted material order list for GC Group, Richter+Frenzel, Gienger & Co.

📦 **What you will receive immediately after purchase (complete zip package):**
1. **SHK_Kalkulation_Leer_Vorlage.xlsx** – Your clean master template (switchable DE / EN & DE/AT/CH/UK/US).
2. **SHK_Sample Project_Heat Pump.xlsx** – Fully calculated practical project “9 kW heat pump (R290) incl. gas boiler dismantling, 70 lfm pipe network/GEG insulation, €360 old copper credit & 55% KfW-458 funding”.
3. **SHK_Kalkulator_PRO_Handbuch_und_Rechtsleitfaden_DE.pdf** – German practical handbook including legal compass & print-ready **construction site measurement sheet (page 4)** for the clipboard in the basement.
4. **HVAC_Plumbing_Estimator_PRO_Guide_and_Legal_Reference_EN.pdf** – English manual including US/UK Building Codes & Printable Jobsite Take-Off Sheet.

🔒 **100% Macro-Free (.xlsx):** No virus warnings, runs instantly on Windows, Mac, and construction site tablets (Excel 2016 and later / Microsoft 365). Sheet protection password for customization: `schattenspiel.eu`

License: You may use the files privately and within your own company. You may not resell, distribute, publish, or use them for AI training. Questions? hallo [!at] schattenspiel.eu
You may use the files for personal purposes and within your own business. You may not resell, share, publish or use them for AI training. Questions? Email us at hallo [!at] shadowspiel.eu.

  • Item type
    Digital download
  • Digital file type(s)
    1 ZIP
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

SchattenspielStudio
SchattenspielStudio ·

Hanover, Germany

We calculate this number using a recency-weighted average of all ratings, with a rating's value decreasing by half each year to best reflect the current experience. 5.0
·
12 sales
·
3 months on Etsy

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 26, 2026