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
Seller's description
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.
NowPrice:$35.32
Original Price: $58.87
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
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 typeDigital download
-
Digital file type(s)1 ZIP
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Liquidity Warning Tracker Excel | Weekly Actual Figures, Warning Levels and Action Plan | Undated [DE]
Sale Price $14.68
Original Price $24.47
-
Digital download
Business Bundle of 8 Excel Templates 2027 | Sales, Finance and Task Planning [DE]
Sale Price $88.39
Original Price $147.32
-
Digital download
E-Invoice Transition Planner Excel 2027/2028 | Tasks, Target Dates and Software Matrix [DE]
Sale Price $20.58
Original Price $34.30
-
Digital download
600 Digital Product Ideas 2027 | Compendium, Excel Calculator and Offline Tools [DE/EN]
Sale Price $11.73
Original Price $19.55
-
Digital download
Creative Project Planner and Price Calculator | Excel for material costs, product prices and projects with project book [DE/EN]
Sale Price $11.73
Original Price $19.55
-
Digital download
Small Business Owner EÜR Excel 2026 | Accounting calculator with journal, depreciation, mileage log and instructions [DE/EN]
Sale Price $11.73
Original Price $19.55
-
Digital download
ISO 27001 Documentation Kit – Editable Templates for Information Security Management System | Digital Download
$66.19
-
Digital download
Absence tool Absence manager Absence tracker with employee management for teams and SMEs GoogleSheet German HR employee
$31.88
-
Digital download
ISO 9001 14001 45001 Audit Toolkit Bundle | Editable ISO Templates, Checklists & Logs | PDF Word Excel | Business Compliance Pack
$25.73
-
Digital download
800+ n8n Workflow Templates | All-in-One, Organized & Ready-to-Use in Notion
$58.47
-
Digital download
ChatGPT Productivity Bundle: Ebook + 8 AI Automation PDFs
$29.23
-
Digital download
ZERO to HERO : Productivity, Discipline & Organization Notion Template | Dashboard Life Planner | Digital Second Brain | Project Manager
$78.36
-
Digital download
Custom made Make.com Automation Workflow | Scalable No-Code Integration | No technical experience needed
$68.66
-
Digital download
ISO 27001:2022 Information Security Guide - French eBook, PDF & Word
$29.00
-
Digital download
iRIS nx AI Life Optimization, Personal AI System in Notion for Self Growth, Wealth Tracking, Automation, Productivity and Total Wellness.
$99.00
-
Digital download
Optimize Team Velocity Tracking and Projecting with Our Powerful Spreadsheets - website access as well - project product management
$50.00
-
Digital download
Workflow Watcher AI | Automation Audit Assistant for Small Business | Custom GPT Digital Download | No-Code Workflow & Systems Strategy
$97.00
-
Digital download
ISO 27701 Documentation Kit – Editable Privacy Information Management System Templates | Digital Download
$88.26
Shoppers with similar taste loved these
-
Digital download
Editable HVAC Proposal Template: Excel, Word, PDF, Google Sheets
$6.99
-
Digital download
Editable Blank Invoice Template, Google Docs, Word, PDF, Printable Invoice Template, A4, Professional Business Invoice, Customizable Invoice
Sale Price $1.50
Original Price $3.00
-
Digital download
Invoice Template PDF/Google Docs/Word. Business Invoice. Invoice Word. Editable Invoice. Custom Invoice. Printable Invoice. Invoice Form.
$1.99
-
Digital download
HVAC Invoice Template, HVAC Invoice Template, Word Template Invoice, Word Template, Simple Invoice, Word Invoice
Sale Price $2.25
Original Price $3.00
-
Digital download
HVAC Service Order Form template / Business form template / Digital Download / Editable / Printable / Excel / HVAC Service Invoice
$4.50
-
Digital download
HVAC | Heating and Cooling | Service Order Form | Invoice | Editable & Printable
$3.73
-
Digital download
Painting Regional Flat Rate Price Book | All 141 Services + 60 Pricing Options | Excel + Google Sheets
$79.99
-
Digital download
Painting Estimate Calculator | Excel, Google Sheets Contractor Quote Template (Digital Download)
$29.00
-
Digital download
Painting Estimate Spreadsheet | Excel Paint Coverage, Labor Hours Calculator Customer Quote Template for Painters | Instant Download
Sale Price $19.43
Original Price $29.00
-
Digital download
Painting Estimate Template | Google Sheets Template (Digital Download)
$14.00
-
Digital download
Painting Estimate Template & Contractor Business Kit | Invoice, Welcome Packet, Yard Sign and Door Hanger
$34.00
-
Digital download
Job-Winning Painting Proposal Template | Professional Painters Bid & Estimate | Fully Customisable in Canva
$105.08