{"product_id":"hvac-plumbing-excel-suite","title":"HVAC and Plumbing Contractor Suite – Excel \u0026 Google Sheets Templates","description":"\u003cp\u003eRun an HVAC and plumbing business with 8 Excel workbooks: calls, dispatch, price book, job costing, technician pay, van stock, agreements and cash. 29 dollars once, no macros, no subscription.\u003c\/p\u003e\u003cp\u003eSee which jobs lost money, what callbacks cost, who still owes you and when cash gets tight, before the busy season and not after. Field-service software is usually billed monthly, often per technician or per truck. This is 29 dollars once.\u003c\/p\u003e\u003cp\u003eWHAT YOU CAN DO\n- Price every task from cost and see which lines fell under your margin after a supplier price rise.\n- Build good-better-best estimates and rank open estimates by the money on the table.\n- Cost each job after hours, parts, permit, disposal, subcontract and vehicle, and see what callbacks cost.\n- Plan the week on a dispatch board and rank unbooked calls.\n- Compare pay models, test when to hire and track van stock.\n- Follow maintenance agreements, tune-up windows and renewals.\n- Chase overdue invoices by age and see a 12-month cash forecast with your slow season.\u003c\/p\u003e\u003cp\u003eWHAT IS INSIDE: 8 WORKBOOKS\n1 Calls, Dispatch and Jobs\n2 Price Book, Estimates and Options\n3 Job Costing, Margin and Callbacks\n4 Technicians: Hours, Pay and Capacity\n5 Parts, Van Stock and Vehicles\n6 Sites, Equipment and Agreements\n7 Invoices, Collections and Cash\n8 Leads, Reviews, Renewals, Scorecard\nEvery workbook has 20 tables, 18 tools, 12 forms, 12 documents, 12 checklists, 34 ready-to-send text messages, 30 dashboard numbers, 22 charts and 6 gauges. In all: 160 tables, 144 tools, 96 forms, 96 documents, 96 checklists, 272 messages, 240 dashboard numbers, 176 charts and 48 gauges, on 632 ready pages.\u003c\/p\u003e\u003cp\u003eWHO IT IS FOR\nOwner-operators with one van and no office, and shops of up to 15 technicians with a dispatcher and maintenance agreements.\nNOT FOR: a customer portal, an app, GPS tracking or automatic sync. You type or paste your data.\u003c\/p\u003e\u003cp\u003eHOW IT WORKS\n1 Open the workbook for the job. A sample-data copy shows every page.\n2 Replace the sample rows with yours in the coloured input cells.\n3 Read the dashboard and use the tools.\u003c\/p\u003e\u003cp\u003eFILE FORMAT\nStandard xlsx files for Microsoft Excel, Google Sheets and LibreOffice. Blank and sample-data copies of every part. No macros. Formula cells locked, no password. Dates follow your regional format; one cell sets the currency symbol.\u003c\/p\u003e\u003cp\u003eGUARANTEE\nIf a file does not work as described, we fix it, replace it or refund you within 14 days.\u003c\/p\u003e\u003cp\u003eSee the FAQ. Tax and pay figures are planning aids: confirm with your adviser.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat it does for you\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eKnow which jobs lost money, and whether parts, hours or a callback caused it\u003c\/li\u003e\n\u003cli\u003eRaise the right prices first when a supplier cost rises and a margin slips\u003c\/li\u003e\n\u003cli\u003eBuild good-better-best estimates with margin and a monthly payment for each option\u003c\/li\u003e\n\u003cli\u003eSee every unbooked call ranked by job value, with who to call back today\u003c\/li\u003e\n\u003cli\u003ePlan the week on a dispatch board with double-booking and no-parts flags\u003c\/li\u003e\n\u003cli\u003eSee what each callback cost and which technician's callback rate stands out\u003c\/li\u003e\n\u003cli\u003eKnow what a technician hour costs, billed against paid, and when to hire\u003c\/li\u003e\n\u003cli\u003eKeep vans stocked with a restock list, count gaps and parts never billed\u003c\/li\u003e\n\u003cli\u003eCatch maintenance-agreement renewals and overdue tune-up visits in time\u003c\/li\u003e\n\u003cli\u003eSee unpaid invoices by age and chase the biggest overdue amounts first\u003c\/li\u003e\n\u003cli\u003eSee your cash 12 months ahead and the slow-season dip before it arrives\u003c\/li\u003e\n\u003cli\u003eRank lead sources by cost per booked job and read one Monday scorecard\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eDoes it work in Google Sheets, or do I need Excel?\u003c\/strong\u003e\u003cbr\u003eBoth work. The files are standard .xlsx files for Microsoft Excel, Google Sheets and LibreOffice (free). They are built with the same engine as our other suites, which were tested in Google Sheets.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCan I use my own currency and date format?\u003c\/strong\u003e\u003cbr\u003eYes. Dates follow your computer's regional format, and the currency symbol changes in one cell. Targets such as margin, close rate and cash floor are yours to set.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCan an owner-operator with one van and no office use it?\u003c\/strong\u003e\u003cbr\u003eYes. The call log, price book, estimates, job costing, van stock, agreements, invoices and cash sheets work with one technician, one van and no dispatcher. Use the owner view of the board.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDoes it fit a shop with up to 15 technicians and a dispatcher?\u003c\/strong\u003e\u003cbr\u003eYes. The dispatcher uses the dispatcher columns and the dispatch board, and agreements, pay, van stock and capacity are built for several technicians and vans. There is no fee per technician or per seat.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow do I replace the sample data and where do I start?\u003c\/strong\u003e\u003cbr\u003eOpen the first sheet of any workbook for the instructions. Type or paste your own rows over the sample rows in the coloured cells, or start from the blank copy. Begin with the part that hurts most today.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat if a file does not work as described?\u003c\/strong\u003e\u003cbr\u003eWe fix it, replace it or refund you within 14 days. There are no macros and no subscription: you pay 29 dollars once and download at once.\u003c\/p\u003e","brand":"Dar Templates","offers":[{"title":"Default Title","offer_id":68451449962800,"sku":null,"price":29.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1007\/1887\/0832\/files\/image_77eff6ce-2521-48ae-ac8c-e97503b30293.jpg?v=1794810659","url":"https:\/\/darjob.myshopify.com\/ur\/products\/hvac-plumbing-excel-suite","provider":"Dar Templates","version":"1.0","type":"link"}