BidTroller/User guide

Scope letter and Google Drive

If your company has workflow turned on, every job with a finished takeoff (see Fence scope, fence pages and takeoff) has a Scope letter (.xlsx) download in its Takeoff section. It is your company’s scope letter, filled in with that job’s fence, gate and railing lines, ready for the estimator to price.

What is on the letter

The file is named after the job with .scope at the end, for example Ewert Splash Park.scope.xlsx. It opens in Excel with three tabs.

Scope, the letter itself, laid out like your own scope letter:

  • Your letterhead, offices and the OFFICE COPY label at the top, today’s date, and blank W.P., FAX, CELL, E-MAIL and O.C. lines and Name, Address and City/State/Zip lines to fill in.
  • Your INSTRUCTIONS box (for example Addenda Acknowledged, Prevailing Wage, Tax Exempt) and your numbered office checklist down the right side.
  • Estimator: the person the job is assigned to, blank if nobody is.
  • The job’s name and city, then one Furnish and install line for each fence type, gate type, railing and other item in the takeoff: Furnish and install approximately 1,250 LF of 8' chain link fence., Furnish and install (2) 12' double swing gates. Removal, remove and reset, and temporary fence get their own lines. A type whose quantity the documents don’t state says length not stated in the documents; measure from the plans.
  • Gate openings are never added to the fence footage; the letter says Gate openings are separate from fence LF. When the documents’ length includes the gate openings, a line says to confirm it.
  • For the sum of $____: always blank. BidTroller never prices a job.
  • Each bid alternate in its own block, with its lines and an Add to base bid or Deduct from base bid blank.
  • Your terms, with the working days blank (will need ______ working days), your EXCLUSIONS and your insurance note.
  • DRAWING DETAILS on the right: the spec details BidTroller found for each line, bid notes (gate operators, rock, coatings and the like), every quantity or conflict to check before pricing, and the scales named in the plans. It is outside the print area, so the printed letter is just your letter.

Site Takeoff: one row per letter line with its total, then every takeoff item with its file, page and quote, and a Gate openings table (width × count) kept separate from fence footage. Each quantity on the letter is a formula that reads this tab, so if you change a number here, the letter follows.

Drawing Specs: for each line, the pages it came from, the location, height, details and quoted words, then the warnings and scales.

The quantities are the ones the documents state in words. Once BidTroller turns measuring on for your company (see Measured from the drawings in Fence scope, fence pages and takeoff), the letter also uses what was measured on the plan sheets:

  • A fence type the documents name with no length takes the length measured from the drawing. The Site Takeoff tab lists it under Measured runs, one row per sheet, and says measured from the drawings beside the line. The letter says Quantities are measured from the drawings, with no waste allowance.
  • A length the documents state stays as stated. When the drawing measures more than 10% different, Drawing details says so under Conflicts / check before pricing, with both numbers and the sheet.
  • Fence drawn on the plans that the documents never name gets its own line, with its measured length.
  • When the documents list no gates, the gates BidTroller found on the drawing become the gate lines, each with the width scaled from the drawing to the nearest foot, one line per size: Furnish and install (2) 14' gates. A gate marked on the sheet only by the word GATE, with no size BidTroller could scale, is counted on its own line that says so: Furnish and install (3) gates, size not scaled; check the drawing. On the Site Takeoff tab these lines say found on the drawings (drawn fence: measured from the drawings) instead of stated in the documents. When the documents do list gates, those stay, and a check line gives the drawing’s count if it differs.

Until measuring is on, nothing on the letter is measured from the drawings. Either way, check every line against the plans before the letter goes out.

Work your company doesn’t do is left off. A company that doesn’t do erosion control, for example, lists erosion under Work you don’t do, and silt fence never appears on its letters; the letter says Not included: with what was left off.

Your letter text

Owners and admins edit the words on the letter on Admin › Fence scope (/app/admin/fence-scope), under Scope letter:

  • Company name, the line under it, slogan, and your offices, phones and website.
  • The top-right label, the short name your terms use (for example RFC), and the scope heading.
  • The instructions box (up to three lines; (__) in the first is where the estimator writes the number of addenda) and the office checklist (up to ten steps).
  • Work you don’t do: words like erosion; takeoff lines containing them are left off.
  • Terms (write {days} where the working days go), Exclusions and Insurance note.

Saving changes the next letter anyone downloads; letters already downloaded don’t change. Every save is recorded in the audit log.

Filing to Google Drive

BidTroller can put each job’s files straight into your company’s Google Drive, the way your estimators file them by hand:

  • the scope letter in <job>/Bid Documents,
  • the fence plan sheets PDF in <job>/Plans and Specs/Plans,
  • the fence spec sections PDF in <job>/Plans and Specs/Specs,

all inside one folder you pick, such as your current commercial projects folder. A job folder is made the first time a job is filed.

Google Drive filing is being set up for BidTroller. Until Admin › Fence scope shows Connect Google Drive, use the downloads in the job’s Takeoff section.

To set it up (owners and admins):

  1. On Admin › Fence scope, under Google Drive, click Connect Google Drive and sign in with the Google account that owns or can edit your job folders. Google asks you to let BidTroller see and change only the files it makes; it can’t see anything else in your Drive.
  2. Click Pick the folder and choose the folder jobs should go in. Shared drives work.
  3. Change the folder names if yours differ. {project} is the job’s name, and a slash makes a folder inside a folder.
  4. Tick File a job automatically when someone sets it to Bidding if you want that.

Then on any job with a finished takeoff, the Takeoff section shows File to Drive. Owners, admins and estimators can use it. It files the scope letter and whichever fence PDFs the takeoff has, then lists each file with a link to it in Drive. Filing a job again, by hand or when it is set to Bidding again, replaces those files with fresh ones; it never makes copies. If you deleted a file in Drive, filing makes it again. Every filing is recorded in the audit log.

Because BidTroller sees only what it made, it makes its own job folder even if you already made one with the same name by hand. Disconnect Google Drive on the same page stops filing; files already in Drive stay there.