Job Pricing Calculator
Job Pricing Calculator & Quote / Invoice Generator
Enter each room's dimensions to calculate the recommended unit size. Formula: Length × Width × 150W = required watts, rounded up to the nearest available unit.
| Item | Part No. | Unit £ | Qty | Total | |
|---|---|---|---|---|---|
| No materials added yet | |||||
| Cable Type | £/m | Length (m) | Total |
|---|
Brackets, pipe sizes, copper rules & more — open while you quote.
No saved jobs yet — fill in the details above and click Save Job.
No data yet — save some jobs on the Calculator tab.
No jobs yet.
Bin is empty — deleted jobs and customers appear here.
All users share one live job list via Google Sheets. Every save auto-syncs within 1 second. The sheet is fetched on load and refreshed every 30 seconds so everyone always sees the same data.
function doPost(e) {
try {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var body = JSON.parse(e.postData.contents);
// ── PULL REQUEST: return all jobs stored in _Sync sheet ──
if (body && body.action === 'get') {
var syncSheet = ss.getSheetByName('_Sync');
if (!syncSheet) return ContentService.createTextOutput('[]').setMimeType(ContentService.MimeType.TEXT);
var val = syncSheet.getRange('A1').getValue();
return ContentService.createTextOutput(val || '[]').setMimeType(ContentService.MimeType.TEXT);
}
// ── PUSH REQUEST: body is the full jobs array ──
var data = Array.isArray(body) ? body : null;
if (!data) return ContentService.createTextOutput('ERROR: expected array').setMimeType(ContentService.MimeType.TEXT);
// Write human-readable Jobs sheet (visible in Google Sheets)
var sheet = ss.getSheetByName('Jobs') || ss.insertSheet('Jobs');
sheet.clearContents();
var headers = ['ID','Job Ref','Customer','Address','Postcode','Install Date',
'Job Price','Labour','Materials','Profit/Unit','Total Profit',
'Units','Type','Saved At','Invoiced At','Engineer','Email','Phone'];
sheet.appendRow(headers);
data.forEach(function(j) {
sheet.appendRow([
j.id, j.jobRef||'', j.custName||'', j.custAddr||'', j.custPostcode||'',
j.instDate||'', j.jobPrice||0, j.labour||0, j.totalMaterials||0,
j.perUnit||0, (j.perUnit||0)*(j.numUnits||1),
j.numUnits||1, j.jobType||'quote', j.savedAt||'', j.invoicedAt||'',
j.engineer||'', j.custEmail||'', j.custPhone||''
]);
});
// Store full JSON in _Sync sheet (read by all users on load / every 30s)
var syncSheet = ss.getSheetByName('_Sync') || ss.insertSheet('_Sync');
syncSheet.getRange('A1').setValue(JSON.stringify(data));
syncSheet.getRange('B1').setValue(new Date().toISOString());
syncSheet.getRange('C1').setValue(data.length + ' jobs');
return ContentService.createTextOutput('OK').setMimeType(ContentService.MimeType.TEXT);
} catch(err) {
return ContentService.createTextOutput('ERROR: ' + err.toString()).setMimeType(ContentService.MimeType.TEXT);
}
}
function doGet(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sync = ss.getSheetByName('_Sync');
var ts = sync ? sync.getRange('B1').getValue() : 'never';
var cnt = sync ? sync.getRange('C1').getValue() : '0 jobs';
return ContentService.createTextOutput('Prestige Air sync OK — ' + cnt + ' — last push: ' + ts).setMimeType(ContentService.MimeType.TEXT);
}
Based on the current calculator job. Download the CSV and use Import cart from file on Beijer Ref.
| Part Code | Description | Qty |
|---|
| Part Code | Description | Qty |
|---|
| Part Code | Description | Qty |
|---|
| SKU | Cable Type | Length (m) |
|---|
Annual service tracking for all invoiced installations.
Accepted jobs where the install date has passed — invoice not yet sent.
Add a previous or existing customer who wasn't invoiced through this system.
Engineer: · Week: