BoostExcel main content

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
380 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

Service Proposal Template with Checkbox Column

Detail

The layout of this service proposal template is similar to the service proposal template (c4009). It demonstrates how to use checkboxes on the Excel sheet.

This template was created with consideration for a service company that installs lights for customers. The form contains four columns. The first column is "Room#", indicating the room where the rights should be installed. The other columns are "Description", "Quantity", and "Line Total". All the fields are editable. That is, it doesn't calculate "Line Total".

Between "Room" and "Description", there is a column of checkboxes. If you check a box, the "Line Total" on the current line is added to the "TOTAL OF ITEMS SELECTED" cell at the bottom of the proposal.

The formula for the "TOTAL OF ITEMS SELECTED:" cell is:

=SUMIF(oknSelected_1:oknSelected_16,TRUE,oknLineTotal_1:oknLineTotal_16)+SUMIF(oknSelected_1:oknSelected_16,-1,oknLineTotal_1:oknLineTotal_16)

The following chart details all the custom fields.

Table nameField nameField typeComment
InvHdrDaysDecimal(12,2)The number of days to complete the job.
InvHdrSelectedTotalDecimal(12,2)The sum of all the selected service items.
InvBdyRoomText(60)The place to do the job.
InvBdySelectedIntegerIs the current service item selected?

Format and Specification

Template#c4107
Belongs to
Format (XLS or XLSX).xlsx
Columns4
Lines16
Line Height (Points)24.00
Print Area$F$3:$O$41
Papaer Size / OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60
PriceFree (0.00USD)

Related

Construction Proposal Template
General Quote Template for Excel
Agency Quotation
Service Proposal and Quote
Image and Picture on Invoice, Quote, and Purchase Order
Excel Quotation Template
Job Estimate Template for Excel