Data Entry

Enter the Job Name, then enter the height (left) and width (right) in inches for each opening. When finished click "Calculate costs and prices" to complete the spreadsheet and save the heights and widths.

Print this page and any spreadsheet page to have a copy for your records. Each job is saved until you replace it with the next job. Only one job will be saved at a time. Your print outs are your records.


Job Name:
  1.   
  2.   
  3.   
  4.   
  5.   
  6.   
  7.   
  8.   
  9.   
  10.   
  1.   
  2.   
  3.   
  4.   
  5.   
  6.   
  7.   
  8.   
  9.   
  10.   
  1.   
  2.   
  3.   
  4.   
  5.   
  6.   
  7.   
  8.   
  9.   
  10.   
  

Default costs and prices

The values below for costs, prices, offsets and percent up-price for self installs are used to calculate selling prices and profit for your jobs that appear in the spreadsheets.

Save. You can change and save the default values. The changes you save will be available the next time you use the spreadsheet program. In effect they will become the assumptions for calculating profit. Profit = price - cost. Percent profit = 100 * (price - cost)/price.

Reset. If you reset to standard default values then the values below will revert to the original values that were programmed. Hugh can change the standard reset values but you cannot change or save them. All spreadsheets have the job name you entered and the date that the calculations were made. .