Estimate proposal Microsoft Word template with item details summed by minor code

Default templates and upload category

Default Microsoft Word template: EstimateProposal-ItemsSummedMinor-Pricing-Scope.dot

Alternative Microsoft Word templates:

EstimateProposal-ItemsSummedMinor-Pricing.dot
EstimateProposal-ItemsSummedMinor-NoPricing.dot
EstimateProposal-ItemsSummedMinor-NoPricing-Scope.dot

Upload feature category: Estimate Proposal - Items Summed By Minor

About bookmarks and mail merge fields

All bookmarks and mail merge fields are optional.
There's no limit on the number of times that bookmarks can be repeated. For example:
- CompanyName, CompanyName2, CompanyName3, .., CompanyName10, .., CompanyName20, .., CompanyNameX
- ProjectNumber, ProjectNumber2, ProjectNumber3, .., ProjectNumber10, .., ProjectNumber20, .., ProjectNumberX

Bookmarks - General project information

ProjectNumber
ProjectTitle
ProjectDescription
ProjectAddress1
ProjectAddress2
ProjectCity
ProjectState
ProjectZipCode
ProjectCountry
ProjectPhone
ProjectFax

Bookmarks - Project bid date, plan room info, estimated dates, and stakeholders

ProjectOwnerBidDate
ProjectOwnerBidTime
ProjectPlanRoomInfo
ProjectStartDate
ProjectFinishDate
ProjectSalesPerson
ProjectSalesPersonMobilePhone
ProjectSalesPersonEmailAddress
ProjectBidContact
ProjectBidContactMobilePhone
ProjectBidContactEmailAddress
ProjectManager
ProjectManagerMobilePhone
ProjectManagerEmailAddress

Bookmarks and mail merge table options - Project classifications

Learn more about your options here.

Bookmarks - Estimate from company / contact

If a bid contact is not specified in the lead or project details form, then Sage Construction Management will check the reviewed by contact in the estimate properties. If a bid contact and a reviewed by contact are not specified, the logged in user will be used as from contact.

FromPrefix
FromFirstName
FromMiddleName
FromLastName
FromSuffix
FromContact
FromTitle
FromMobilePhone
FromEmail
FromCompanyCode
FromCompany
FromAddress1
FromAddress2
FromCity
FromState
FromZipCode
FromCountry
FromPhone
FromPhone2
FromFax
FromWebsite
FromGovTaxID

Special e-Sign bookmark (Contract Admin and Procurement templates only):

Bookmarks listed below must use a white font so the e-Sign tag is clearly visible and not obstructed.

FromE_Signature
FromE_SignatureDate
FromE_Initial

Bookmarks - Estimate to company / contact (client)

ToPrefix
ToFirstName
ToMiddleName
ToLastName
ToSuffix
ToContact
ToTitle
ToMobilePhone
ToEmail
ToCompanyCode
ToCompany
ToAddress1
ToAddress2
ToCity
ToState
ToZipCode
ToCountry
ToPhone
ToPhone2
ToFax
ToWebsite
ToGovTaxID

Special e-Sign bookmark (Contract Admin and Procurement templates only):

Bookmarks listed below must use a white font so the e-Sign tag is clearly visible and not obstructed.

ToE_Signature
ToE_SignatureDate
ToE_Initial

Bookmarks - General estimate information

EstimateNumber
EstimateDescription
EstimateSize
EstimateUnit
EstimateProposalDate
EstimateProposalDateSpelled
EstimateValidThruDate
EstimateValidThruDateSpelled

Bookmarks - Estimate reviewed by company / contact

ReviewedByPrefix
ReviewedByFirstName
ReviewedByMiddleName
ReviewedByLastName
ReviewedBySuffix
ReviewedByContact
ReviewedByTitle
ReviewedByMobilePhone
ReviewedByEmail
ReviewedByCompanyCode
ReviewedByCompany
ReviewedByAddress1
ReviewedByAddress2
ReviewedByCity
ReviewedByState
ReviewedByZipCode
ReviewedByCountry
ReviewedByPhone
ReviewedByPhone2
ReviewedByFax
ReviewedByWebsite
ReviewedByGovTaxID

Special e-Sign Bookmark: ReviewedBySignature

Bookmarks - Estimate sell or proposal totals

EstimateSellTotal (Proposal Amount) = EstimateMSellTotal + EstimateLSellTotal + EstimateESellTotal + EstimateSSellTotal + EstimateOSellTotal + EstimateGlobalShownMarkupTotal

Resource Rates and Totals (i.e. EstimateMSellRate, EstimateMSellTotal, EstimateLSellRate etc.) include Hidden Global Markups.

EstimateMSellRate
EstimateMSellTotal
EstimateLSellRate
EstimateLSellTotal
EstimateESellRate
EstimateESellTotal
EstimateSSellRate
EstimateSSellTotal
EstimateOSellRate
EstimateOSellTotal
EstimateGlobalShownMarkupTotal
EstimateAllowanceSellTotal
EstimateAllowanceSellTotalSpelled
EstimateNonAllowanceSellTotal
EstimateNonAllowanceSellTotalSpelled
EstimateSellRate
EstimateSellTotal
EstimateSellTotalSpelled

Bookmarks - Estimate cost totals

EstimateCostTotal = EstimateMCostTotal + EstimateLCostTotal + EstimateECostTotal + EstimateSCostTotal + EstimateOCostTotal

Resource Rates and Totals (i.e. EstimateMCostRate, EstimateMCostTotal, EstimateLCostRate etc.) include Hidden Global Markups if Include in Cost is checked.

EstimateMCostRate
EstimateMCostTotal
EstimateLCostRate
EstimateLCostTotal
EstimateECostRate
EstimateECostTotal
EstimateSCostRate
EstimateSCostTotal
EstimateOCostRate
EstimateOCostTotal
EstimateAllowanceCostTotal
EstimateAllowanceCostTotalSpelled
EstimateNonAllowanceCostTotal
EstimateNonAllowanceCostTotalSpelled
EstimateCostRate
EstimateCostTotal
EstimateCostTotalSpelled

Mail merge table - Minor codes

Merge table start and end tags: EstimateItemsSummary

Minor mail merge fields:

Minor
MinorDescription
MinorMCostTotal
MinorLBaseCostTotal
MinorLBurdenCostTotal
MinorLCostTotal
MinorEBaseCostTotal
MinorEBurdenCostTotal
MinorECostTotal
MinorSCostTotal
MinorOCostTotal
MinorCostTotal
MinorMSellTotal
MinorLSellTotal
MinorESellTotal
MinorSSellTotal
MinorOSellTotal
MinorSellTotal
MinorAllowanceCostTotal
MinorAllowanceSellTotal
MinorNonAllowanceCostTotal
MinorNonAllowanceSellTotal
MinorLHrs
MinorEHrs

Allowance field logic:

MinorCostTotal = MinorAllowanceCostTotal + MinorNonAllowanceCostTotal
MinorSellTotal = MinorAllowanceSellTotal + MinorNonAllowanceSellTotal

Mail merge table - Estimate scope of work inclusions, exclusions, and clarifications)

Merge table start and end tags: EstimateScope

Scope of work mail merge fields:

CostCodeOrderNumber
CostCode
CostCodeDescription
CostCodeInclusions
CostCodeExclusions
CostCodeClarifications

The estimate scope will be listed first, before the cost code scope is added to the mail merge table.