This page lists the release date and version of each product. It has the changes made in that version. If you have specific questions or would like more details on a new function, please contact us and we’ll get back to you as soon as we can.

Note: Minor version releases may not be listed.

Select Product:

Bid List
Scope Sheet

Bid List

How to determine my version?

v7.32 r.2018-04-04
  1. Fixed issues that came up with duplicating or moving contacts within the bid list.
  2. Improved the move column functionality. The customized order will also be saved when the bid list is upgraded.
  3. Improved the custom column function on the contact sheet. Custom column data will be copied over during an upgrade.
  4. Improved error checking of email addresses in the contact edit form.
  5. Fixed a bug that would cause an “overflow” error on the contacts sheet.
v7.31 r.2018-03-24
  1. Contacts that are filtered out but have a status update will be shown after an update.
  2. When importing a previous bid list all contacts with a bid status on the old bid list will get a “Y” in the invite status column in the new bid list.
  3. Added a report button to the toolbar and created a new coverage report.blreportsbutton
  4. The electronic ITB (eITB) web page allows subs to update missing company address information and decide if they want a confirmation email sent to themselves.eitb-companyfillindata
  5. Fixed a bug that would cause an #N/A error after an update.
  6. Fixed a bug when quickly changing invite or bid status.
  7. Fixed a bug that might leave the company tab unprotected.
  8. Other performance improvements.
v7.3 r.2017-10-03
  1. Made changes to sync with Scope Sheet contact and correspondence log changes.
  2. Removed add-in check when opening the Bid List.
  3. Added a button the Bid List setup box to open/sign up for the online directory.
  4. Standardized time stamp formatting across Bid List and Scope Sheet.
  5. Bug Fix: Issue where the signature wasn’t being added to Outlook 2016 emails.
  6. Bug Fix: When using Personalized Mass Email, the spell checker would try to correct map links.
  7. Numerous formatting and performance improvements.
v7.25 r.2017-08-11
  1. Fixed a bug if the CSI description had a space at the end.
  2. Can re-assign a contact to an existing company.
  3. Fixed a bug with the Last Update stamp.
v7.2 r.2017-08-01
  1. Updated the CSI trade selection & Company drop down box in the contact form to be a text box that filters as your type. 
  2. Added ability to Move a contact from one CSI division to another. Click “Duplicate/Move”. Select the CSI code and click “Move Contact”
  3. “Bid taker” assignments on the CSI tab are synced across bid lists.
  4. Added a column on the CSI Trade sheet that allows the estimator to insert custom trade numbers and/or descriptions that are specific for that project. Useful if the estimator wants to use the same trade division codes as the project specifications.
  5. CSI code numbers can be any length and have decimal points.
  6. A third option was added to the ITB response screen subcontractors see. “Maybe” was added in addition to “Yes” and “No” which will send the subcontractor a reminder in 24 hours to submit their bid intentions after they have had time to review the contract documents.
  7. Added a text field in the Project details for an internal company job or project number.
  8. Improved how trade divisions are listed in customized mass emails. When you you double click “CSI Description” it offers the option to also include the CSI number.
  9. Improved filtering and freezing panes on each sheet.
  10. Fixed a bug where user might see an #N/A error on the contact page if the CSI tab was filtered.
  11. Fixed a bug when trying to create a new CSI trade the last edited CSI data would be in the form.
  12. A number of other performance improvements.
v7.1 r.2017-05-21
  1. Added an option to work in Parent or open Child bid list after creating a Child bid list.
  2. When creating a Child bid list the default save to folder is the same as the Parent bid list.
  3. Insert a hyperlink in customized mass email (so it looks like text.) Use Insert Hyperlink under Format menu.
  4. Fixed a bug when saving a custom email template the bid due date wouldn’t always work.
  5. Improved reply-to handling in custom mass email function (if there is a bid taker it will send responses to both the assigned bid taker and email addresses in the reply-to option field).
  6. Added syncing of included companies when a bid taker is assigned between Parent and Child bid lists.
  7. Bid takers are added to the company tab and each bid taker can add or remove included companies for the companies they are assigned to.
  8. Fixed a bug where a synced comment would have the same comment multiple times.
  9. Vastly improved the change data stored in comments. When recording a call or email it will track that for all instances of that contact if the other CSI trades are included for that project.
  10. When adding a business main phone number it will cycle through all contacts at that company and put the number in those that have a blank business phone number.
  11. Project specific note column headers are synced across Parent and Child bid lists.
  12. Added ability to copy and paste from the Bid List to another Excel document.
  13. Exported bid lists and correspondence logs will save to the parent bid list folder by default.
  14. Cosmetic fixes for forms when using Excel 2016.
  15. Numerous other stability and performance improvements.
v7.098 r.2017-04-23
  1. New: Added project description into personalized mass email form.
  2. Bug Fix: Fixed issue where long project descriptions weren’t syncing properly.
  3. Bug Fix: If formula on CSI tab was blank it would cause an error when trying to edit a contact.
  4. New: Added a message if a lot of updates need to sync to stay patient and look in the status bar for additional details.
  5. Bug Fix: If a hyperlink wasn’t formatted properly it would cause an error.
  6. Removed code that auto-sized company columns added to the contact sheet. Manually resizing columns will stick.
  7. Bug Fix: Fixed an issue that could cause non-14Fathoms Excel sheets to get password protected.
  8. New: In the project details form added buttons to test URLs to make sure the point to the correct page.
v7.093 r.2016-05-26
  1. New: Added bid taker column on CSI Codes Sheet. Assign a team member to a specific CSI section. Assignee shows on Contact tab and Personalized Mass Emails can be directed back to assigned estimator (Outlook only).
  2. New: Added common trades designati
v7.090 r.2016-04-03
  1. New: Added bid taker column on CSI Codes Sheet. Assign a team member to a specific CSI section. Assignee shows on Contact tab and Personalized Mass Emails can be directed back to assigned estimator (Outlook only).
  2. New: Added common trades designation on CSIs. Assign common CSI trades for your company and quickly select them.
  3. New: Added company history query data. Use the “History” tab in the Contact form to see current and historical jobs bid.
  4. Improved email send functionality (Fixed a copy/paste issue when trying to copy email addresses to your clipboard).
  5. Improved default calculation mode (set in About box) to minimize issues when working between workbooks.
  6. Bug Fix: Added code to add “Y/N” option dropdown on to all CSI Codes on the CSI sheet.
  7. Bug Fix: Company column data on contact sheet matches the format on the company tab.
  8. Request: Filter on a bid status of “Y” & “Bid Rec’d”
  9. Improved Master Bid List File Location when stored on a network drive.
  10. Multiple other performance and stability improvements.
v7.087 r.2015-10-08
  1. Added Refresh/reset button to toolbar.
  2. Removed tutorial userform.
  3. Disappearing CSI Code number bug fixed.
v7.086 r.2015-09-10
  1. Improved company column data on contact tab when there are changes.
  2. Upon contact deletion, check if it leaves any Primary contacts at that company. If not, warns user to make another contact primary.
  3. Improved sheet .protect method.
  4. Other performance and stability improvements.
v7.085 r.2015-09-01
  1. Minor email bugs fixed.
  2. Improved company columns data on contacts tab (was an issue when adding a new contact or using custom sorting).
v7.08 r.2015-08-17
  1. Added 7 more “Company System Info” columns (total of 12).
  2. Added 5 “Company Project Note” fields.
  3. Added Bid Packages that can be assigned to companies and used to filter/sort companies.
  4. Improved filter on company options. Double click the underlined headings.
  5. Added ability to sort on any Company or Contact column. Right click on desired column and select sort.
  6. Added ability to customize Bid Status options and formatting (go to Bid List Setup, then “Customize Bid Status…” button).
  7. Tweaked adding Company data on Contacts sheet (go to Bid List Setup, then “Show/Hide Company…” button).
  8. Add time zone details on Project details.
  9. Fixed #N/A bug on contacts tab when adding a new company when the company list is filtered.
  10. Improved eITB tracking of emails.
  11. Added first row & blank row limits to add/remove package right click function.
Older Versions
  1. Prior version change information may be added over time.

Scope Sheet

How to determine my version?

v8.50 r.2019-01-28


IMPORTANT: Disable Hardware Acceleration in Excel to improve performance (if you haven’t already):

A. Click the File tab, then “Options”.
B. In the Options dialog box, click “Advanced”.
C. Look in the “Display” area, click to select the “Disable hardware graphics acceleration” check box.
D. Click OK to save.

  1. Added additional “Advanced Setting” to About box to tweak application.
  2. Fixed a bug where not all trade sheets were visible when extracting for a coworker.
  3. Fixed a bug when reordering trade sheets.
  4. Added more status bar updates to identify bottlenecks.
  5. Turned off printer communications by default.
  6. Numerous other performance improvements.
v8.45 r.2018-12-12


IMPORTANT: Anti-virus software can cause the Scope Sheet to freeze or shutdown. Talk to your IT department about excluding/white-listing all .xlsm files or files in your project folders. A help file showing how to do this is in process.

  1. Fixed a bug when opening another file that is in [Protected View].
  2. Fixed a bug when double clicking a trade on the Top Sheet to jump to that sheet user may get “this data is linked to the template” warning.
  3. Fixed a bug when exporting/importing a scope sheet if any of the rows have an error (#n/a, #ref) in them.
  4. Fixed a bug when attempting to add rows in prohibited places.
  5. Added “Offline” mode when a slow network connection is present. Can manually enter that mode in the “About” box.
  6. On bidder report, identified subs with “Ignored” bidder type with an *.
  7. Your “Insert boilerplate scope” selection on the add trade sheet form is saved so you don’t have to uncheck each time.
  8. Top Sheet: if the low bidder differs it flags that row even if the row is collapsed an not using Live Updating.
  9. Added more status updates when upgrading file.
  10. Numerous other performance improvements.
v8.44 r.2018-09-06

IMPORTANT: Disable Hardware Acceleration in Excel to improve performance:
A. Click the File tab, then “Options”.
B. In the Options dialog box, click “Advanced”.
C. Look in the “Display” area, click to select the “Disable hardware graphics acceleration” check box.
D. Click OK to save.

  1. Fixed a bug where a file couldn’t be archived unless it had a trade sheet.
  2. Added a warning message when user attempts to use Excel’s built-in “Save As” function.
  3. Added “Offline” mode when a slow network connection is present. Can manually enter that mode in the “About” box.
  4.  Turned off a setting in Excel 2013+ which will cause the screen to flicker but should minimize macros locking up.
  5. When adding a trade sheet it will remember if you want to add boilerplate scope by default.
  6.  Improved the format functionality to make it quicker.
v8.43 r.2018-08-19
  1. Added ability to copy plug types and amounts across all bidders using right click menu “Copy plug to all bidders” option.CopyPlug01CopyPlug02CopyPlug03
  2. Store the link to a sub’s bid proposal directly in the file. Double click to open it and view the proposal.
  3. Changed the comment heading to say “Hide” instead of “Delete” column to avoid confusion.
  4. Remove the shrink to fit text on the Top Sheet for the trade and company names.
  5. Added option to auto size all rows on all trade sheets.
  6. The insert and delete keyboard keys will be reset when using the Refresh Macros button. (Helpful when copying from one 14Fathoms to another).
  7. On an upgrade the Plug options (typically cell C6) are copied over so they can be customized by your office.
  8. Extended the spell check tool to check sub column notes/exclusions.
  9. Fixed a bug where right click menus wouldn’t show while in page break preview mode.
  10. Removed Send to top sheet double click button. Now use the Top Sheet menu button in the ribbon menu.
  11. Added ability to ignore warning box when copying and pasting to and from 14Fathoms files.
  12. New bidder column background colors will match what is in the scope description column.
  13. Fixed a bug during upgrade where the sheets wouldn’t be in the right order.
  14. Fixed a bug when clicking “Duplicate Scope Sheet” button.
  15. Fixed a bug when trying to extract a trade sheet whose tab was just a number.
  16. Added option to include subcontractor comments on the exported file that is sent to subs.
  17. Split up the autosize scope rows and hide blank rows into 2 buttons and added separately in right click menu.
v8.42 r.2018-04-19
    1. Fixed an issue where forms wouldn’t display on a multi-monitor setup.
    2.  Improved functionality and error catching if using web storage such as Sharepoint or OneDrive (if you are, the backup files will be stored in a folder on your desktop.)
    3. Added comment columns that can be visible at all times for all bidders. See buttons beneath bidder column (please report any strange behavior). To use: scroll down below the bidder columns. Double click the “Show Comments” button or use the “Show ALL Comments” button:showcmomentbutton
      Columns are added next to the bidders. Add/modify your bidder notes in these columns.

      To hide, use the grouping “-” sign above the column or double click the “Delete Comment Column” button. This saves the data from the column into the amount cell:
      Please contact us with questions.
    4. Fixed a bug if you hit the insert or delete hotkey on the Setup tab.
    5.  Other minor fixes and improvements.”
v8.41 r.2018-01-23
    1. Created a function that will create an Outlook email message and attach the exported scope sheet for each subcontractor. Double click the “Export S.S. for Sub” buttons. ExportAndEmailYou will be asked if you want to create an email. Click “Yes”EmailExportsEmails will be created and the appropriate exported file will be attached for you to send:EmailExportResults
    2. Added Send data from this Trade Sheet and Send Data from ALL Trade Sheets to the Top Sheet button in the Scope Sheet toolbar. SendToTSButtons Clicking these buttons is the same as double clicking the “Send to Top Sheet Summary” button on the bottom of the top sheet button with drop down to send all sheets. SendToTSButtonsDblClick
    3. Save as a different project scope sheet function added. Access from the Scope Sheet Functions drop down menu. This will create a new project Scope Sheet file from an existing scope sheet. This is useful if you need to use the same scope sheet for another iteration of the same project bid or to bid a new project that was similar to a past project. SaveAsDifferentScopeSheetRibbonClick the button and add the new project and file name. Select the data you want carried over from the old project scope sheet file to the new file and click the Create button. SaveAsOptionsIn the example above, the due dates will NOT be carried over to the new file. The bidder names and contacts will be carried over, but the sub’s responses, amounts bid, and other bid specific data will not be copied.
    4. Added the ability to show or hide trade sheets and custom sheets. Right click on a sheet tab or click the “Show/Hide Trade Sheets” button in the Edit Trade Sheet drop down. ShowHideRightClick ShowHideDialog
    5. When formatting the scope sheet as one page, the instructions and Y/N column headers will repeat on each sheet.
    6. User can make Permanent Instances of multiple trade sheets at one time (select multiple trade sheets by holding the control key while selecting the sheets and then click “Create Permanent Instance of Sheet” in the Edit Trade Sheet drop down.)
    7. Checking for Top Sheet updates will check the database even if there aren’t any externally linked sheets. This allows for a user in a separate trade sheet to add a new trade, save their changes and when the Top Sheet updates it will ask if the new trade and data should be added to the Top Sheet.
    8. Added a link to the 14Fathoms online directory to the About screen.
    9. Fixed a bug when exporting a scope sheet and the stored network drive location doesn’t exist.
    10. Fixed a bug when exporting a trade sheet for a subcontractor and there was text to the right of the last bidder.
    11. Other improvements and bug fixes.
v8.404 r.2017-10-17
  1. Fixed bug in Excel 2013 when trying to sort bidders by amount or name.
v8.40 r.2017-10-01
  1. When adding a bidder you can select from your Bid List contacts (or a list of subcontractors used in the past for non-Bid List clients).
  2. Contacts edited in the Scope Sheet are updated in the Bid List (it’s now a two-way sync!)
  3. Correspondence (phone and email) is tracked and synced and can be summarized using the Correspondence Log.
  4. Bidders in the Scope Sheet can be identified as “Awarded” and show in the online project directory.
  5. Improved refresh macros to include conditional formatting and data validation.
  6. Improved “mailto” code (and removed references to Outlook) so it breaks up email addresses so if too many emails are selected it will automatically break up into manageable email size.
  7. Added leveled bid amount to the “Bidding companies by trade” report.
  8. Added code to check bid total formula and ask user if it is changed.
  9. Added a comment to the Top Sheet budget column explaining where the data is linked.
  10. Bug Fix: When trying to delete a system row.
  11. Bug Fix: When adding multiple rows on multiple sheets, the status bar was reaching a maximum length that caused an error.
  12. Bug Fix: Add back template links and alternates drop down validation which might have disappeared after last upgrade.
v8.30 r.2017-08-11
  1. Created report of bidding companies (accessible from the Report menu.)
  2. Rewrote upgrade module decreasing upgrade time by 40%.
  3. Fixed a bug if the trade sheet was just a number.
  4. Fixed a bug when checking for com add-ins if the user doesn’t have any installed at all.
  5. Fixed an issue with importing trades and subs from the latest bid list version.
  6. Numerous other performance improvements.
v8.26 r.2017-07-01
  1. Created report of subcontractor plugs, allowances, and holds (accessible from the new Report menu.) Add plugs in “Plug Type” column. Will also pull data from external scope sheet linked on Top Sheet.
  2. Created report of Assumptions and Qualifcations (accessible from Report menu.)
  3. Added a “Hide from sub” column. Allows estimator to include scope and costs that can be excluded when formatting into 1 page for sub. Show the column by double-clicking show/hide custom columns button.
  4. Allow merging of multiple scope sheet files into one file at once (mutlie select).
  5. TopSheet: Allow linking of multiple scope sheet files at once (multi select).
  6. When merging in scope sheet files it will ask if it should convert externally linked scope sheets on the top sheet to local links.
  7. Improved syncing of linked scope sheets on the TopSheet. Updates are automatically synced (no need to double click “U”). It will ask to add new trade lines on Top Sheet if an estimator sends updates for a non-included trade.
  8. Added a comment to the “L” with the last time the trade line was updated.
  9. Changed the AutoCheck function from the cell dropdown to the Top Sheet “Check for Updates” menu. Toggle it on/off and change the autocheck interval using the drop down menu.
  10. Reformatted the LiveUpdating and AutoCheck message.
  11. Added 3rd party add-in checker and instruction to disable. (Including a manual check in Advance About box).
  12. Fixed bug when extracting a sheet with the same name as a file that is already open.
  13. Fixed bug when a long list of Alternates would not sync.
  14. Updated Refresh Macros button to include all indirect formulas and all total row formulas on the TopSheet.
v8.25 r.2017-05-17
  1. Fixed a bug where the company logo wouldn’t be in proportion after an upgrade.
  2. Remove custom formatting styles during upgrade and after merge .
  3. Fixed a bug when merging custom scope sheet.
  4. Fixed an issue in the edit CSI box.
  5. Cleaned up input boxes and resize appropriated in Excel 2013 and newer.
  6. Fixed issue when adding new rows kept the “Double click to edit address” validation pop up.
  7. Fixed bug where added sheets might not go in the right order if there are custom sheets.
  8. Fixed an issue where files exported as macro-free files may not save the project name on the top sheet.
  9. Changed the “Create/Duplicate for Coworker” button to “Extract/Duplicate for Coworker” button.
  10. Fixed a bug where running the spellcheck from toolbar would error out if any cells had #REF or #N/A errors in them.
  11. Added more detail to the status bar when inserting boiler plate scope.
  12. Added validation when creating a permanent instance of a trade sheet. (It won’t allow creating a permanent instance of a permanent instance.)
  13. Added date of the permanent instance to the sheet name so you can have multiple permanent instances of a single trade.
  14. Added the ability to duplicate trades sheets and custom sheets.
  15. Added ability to delete all existing bidders on a trade sheet (click “How to delete bidder” button and read instructions).
  16. Fixed bug when adding custom columns to top sheet.
  17. Fixed bug when copying and pasting formulas in columns in the top sheet. Now it ignores them and allows formulas to be copied and pasted.
  18. Made the advanced calculation settings more difficult to change.
  19. Fixed bug that removes carriage return in boiler plate scope so when copy/pasting outside of Excel it won’t be exported with quotes.
  20. Made the default 5 minutes to auto-save files if nothing else is selected.
  21. Corrected bug where the company logo wouldn’t be the right size on the enable macro screen.
  22. Fixed issue with sorting the Top Sheet trades if both trade name fields are blank.
  23. When adding new trade sheets the “Show/Hide bid stats summary” information is dictated by if it’s visible on the template.
  24. Fixed issue where the bid taker initials were not initially correct when linking a new file and Live-Updating was on.
  25. Fixed bug with merging scope sheets into project parent file with scope items saying they were duplicated even if they weren’t.
  26. Fixed autosave issue (old workbooks shouldn’t pop open anymore).
  27. Fixed issue were the logo on the Top Sheet would break (changed the logo from a link to an embedded image).
  28. Fixed the order of inserted rows on the Template. Should now add in order on the trade sheets.
  29. When linking external trade sheets to the Top Sheet, the file picker defaults to current file location.
  30. Numerous other performance enhancements.
  31. Resolved issues that could arise when switching between files or when closing files.
v8.24 r.2017-04-17
  1. Removed syncing of template scope items across files of the same project. Function will be added back when a fix is found that prevents template items from potentially being overwritten.
  2. Fixed a bug when exporting scope sheet for subcontractors.
v8.23 r.2016-07-12
  1. Added ability to right click and hold control to sort trade section in order across all trade sheets.
  2. When extracting sheets for coworker, added the custom sheets in the file as an option (and a checkbox to leave custom sheets in the current file even if extracted).
  3. Created a global “Send Update to Top Sheet” button so all trades in an estimator’s file are sent to the Top Sheet.
  4. When sending an update to the Top Sheet, the low bidder, leveled bid, and alternates (in a comment) are listed under the button.
  5. Fixed a bug with the calculation mode changing when the file was saved.
  6. Added “Delete multiple scope rows” (select rows and then use the right click menu).
  7. Added ability to insert multiple alternates/unit prices at one time on the Setup tab (double click the “+” sign.)
  8. Fixed extract and merge file bugs involving custom sheets and links to other workbooks.
  9. When Archiving a file, the current folder path is used to store the file instead of the user’s desktop.
  10. Fixed a square foot sync issue.
  11. Top Sheet: Added ability for user to remove all trades (clear entire sheet).
  12. Top Sheet: Added ability to resort list by Trade/Package names. (Use “Data” menu in toolbar).
  13. Top Sheet: Added ability to force refresh all linked Trade Sheets.
  14. Top Sheet: Improved Check for Updates and Update All functions. Should be exponentially faster.
  15. Top Sheet: Sped up Top Sheet calculations when Live Updating is on.
  16. Multiple other improvements.
v8.224 r.2016-05-29
  1. Added more details to status bar when adding or importing multiple trade sheets.
  2. Added your company “super user” contact details to About box.
  3. Added conditional formatting options (button next to conditional format button in the “Home” menu) so user can turn of duplicate scope item and other conditional formatting.
  4. Renamed “Scope Sheet Tools” toolbar to “Scope Sheet” toolbar.
  5. Improved sort function so links to other sheets aren’t broken after a resort.
  6. Fixed “Use All Data for All Trades” bug.
  7. Fixed errors that might come up if the company name in a bidder column is left blank.
  8. Fixed bug if project name or file name has an apostrophe.
v8.22 r.2016-05-09
  1. Added a password to enter Master Scope Sheet mode (edit the super user & password on the Setup tab)
  2. Added “Live Updating” to the Top Sheet so values changed on individual trade sheets automatically update the commit (white) rows. Turn it on/off using the “Check For Updates” down arrow on the toolbar (click “Toggle Live Updating On/Off”).
  3. Added ability to insert a new trade sheet row anywhere on the Top Sheet (use right click menu).
  4. Added ability to choose the export folder location and set the default for the project when exporting a bidder trade sheet.
  5. Export all bidder trade sheets at one time (use the “Dbl Click to Export S.S. for ALL Subs” button).
  6. Updated the boilerplate edit box. Added ability to save Alternate boilerplate items (in addition to trade-specific and excluded items).
  7. Fixed freeze pane bug on exported and archived sheets.
  8. Fixed bug when viewing an Excel file in Window preview pane and having a 14Fathoms product open.
  9. Numerous other fixes and program improvements
v8.215 r.2016-04-24
  1. When creating a new Scope Sheet, the estimator name auto-fills.
  2. Upgraded copy/paste functionality (fixed bug with 64-bit systems).
  3. Improved default calculation mode (set in About box) to minimize issues when working between workbooks.
  4. When importing bidders, will bring in both “Y” and “Bid Rec’d” in the Bid Status column in the project Bid List.
  5. Vastly improved upgrade functionality.
  6. Refreshing macros button also updates all formatting.
  7. Bug fix when exporting scope sheets for subs.
  8. Other stability improvements.
v8.21 r.2016-02-17
  1. Re-sort trade items in a section by selecting them and using the right click menu.
  2. Create an archive/macro-free scope sheet file for architect/owner review. Accessible under “Scope Sheet Functions” button.
  3. Editing an existing alternate on the Setup tab will find/replace and make the change on existing sheets.
  4. Added bid taker details which auto-fills estimator information when creating new Scope Sheets.
  5. Created “Team” toolbar on the Setup Tab and moved extract & merge functions there.
  6. TopSheet: Improved linking of external scope sheets. Link existing local trade sheets to an external sheet if the trade names match.
  7. Renaming a trade sheet will update the name on the Top Sheet to maintain the link.
  8. Corrected right click bug for users using Scope Sheet files on a shared drive.
  9. Improved spell check function.
  10. Improved Gmail functionality.
  11. Improved upgrading functionality.
  12. Other stability improvements.
v8.203 r.2016-01-18
  1. Upgrade scope sheets function complete, including the ability to upgrade project scope sheets! Scope Sheet version 8.2 and newer will notify you of an upgrade.
  2. Added ability to delete multiple scope sheets at one time (under “Scope Sheet Functions” menu).
  3. Bug fixes and performance improvements.
v8.2 r.2015-12-21
  • Boilerplate Scope– Add common trade scope items and exclusions per trade division regardless of the project. Creates consistent scope items at your company across projects.
    1. Boilerplate scope can be edited in Project Scope Sheets and/or in Master Scope Sheet mode only (set in Master Scope Sheet).
    2. Automatically add boilerplate scope on trade sheet creation.
    3. Boilerplate scope have basic formatting (bold, italic, indented).
  • Select and add multiple trade sheets at once.
  • Add all trade sheets for CSI codes selected in a 14Fathoms’ Bid List at one time (use Add Trade Sheet menu drop down button).
  • Updates on a project template sheet are updated across all the project’s scope sheets (including those in other estimator files for that same project).
  • Add and edit CSI trade codes that sync across all company scope sheets and bid lists. (Click the down arrow in the Add Trade sheet dialog box). Trade names can added/edited in Project Scope Sheets and/or in Master Scope Sheet mode only (set in Master Scope Sheet).
  • Mark specific trades as “Common Trades” (those used on most projects) and add all these common trades at one time.
  • Simplified Setup tab now that all project information can be added and synced on the Template.
  • Identify bidder columns as “Active”, “Ignore”, “Budget”, or “Awarded”. Use the drop down just above “Notes/Exclusion” section under a bidder. Active are normal bidders. Ignored bidders are not part of bid statistics and will sort to the far right. Budget will sort to the left and not be part of bidding statistics. Awarded will be used for historical bid statistics.
  • Hide specific bidder column (double click “Hide Bidder” at bottom of specific bidder, Double click Unhide to show again.)
  • Improved Right click functionality: Navigate, insert, rename, move, or delete by right clicking on the trade sheet tab.
  • Add ability to re-sort sheets alphabetically. Helpful after merging sheets which may cause trade sheets to not be in order.
  • Right click: Move scope items up or down.
  • Right click: Copy formatting for scope items on Template to other trade sheets in the file.
  • Improved spell check function and moved button to “Review” ribbon tab where users are used to using it.
  • Create a “Permanent Instance” of a trade sheet that is not changed by updates on the Template. Creates a copy of a scope sheet at a specific moment in time. (Available under Edit Trade Sheet Menu.)
  • Top Sheet Summary:
    1. Added custom buttons to Scope Sheet toolbar.
    2. Add a trade row in the Top Sheet for every trade in the scope sheet button (use the drop-down menu option under Add Trade Row).
    3. Add more bidders to compare to the low bidder. The default is to show 2nd and 3rd place, now you can add as many as you like. (Click add Next Place Bidder button.)
    4. Add custom columns by right clicking on a column. These will be added upon a Scope Sheet upgrade.
    5. Take a “Snapshot” of your bid summary at a point in time (as new drawings are issued, budget set to owner, etc.).
    6. Add a company logo to the top of the Top Sheet.
    7. Added buyout goal, contract amount, and buyout saving columns.
    8. Added indirect cost formulas to Alternates section. You can customize the last alternates formulas which will be copied to subsequently added alternates.
  • Added Master Scope Sheet Mode Options to bottom of Setup tab. Allows setting of Master Scope Sheet location and controlling editing CSI Trade List and Boilerplate scope in Master Mode only or allowed at the project scope sheet level.
  • About box: Added connection status and link to version change log (this web page).
  • Format one page scope options (use drop-down menu). Customize showing wage rates, subcontractor instructions, and/or the trade name large in the header. These settings are reflected on exported Scope Sheets as well.
  • Exported scope sheet files for subcontractor’s are now .xlsx format. .xls file format is phased out.
  • Bug fix: total level bid total formula can be customized (ie for a phased project).
  • Bug fix: export scope sheet title is correct on exported file (and in file name).
  • Bug fix: exported scope sheets are now saved as .xlsx files. .xls are not longer supported.
  • Moved Refresh macros and About button to always be visible on Scope Sheet Tools toolbar (on the far right).
  • Set default excel printer to PDF or XPS printer to avoid issues caused by network printers.
  • Bug fix: fixed error that sometimes came up when adding a custom sheet.
  • Numerous other fixes and improvements.
v8.14 r.2015-08-03
  1. Indent/outdent fix on multiple rows (use right click menu).
  2. Improved backup folder & save function to match Bid List.
  3. Auto-size rows when adding multiple rows at once.
  4. Other performance and stability improvements.
v8.13 r.2015-07-28
  1. Refresh horizontal borders every time to minimize formatting issues.
  2. Changed CSI to use unique code number so trade sheet can be named whatever the user wants.
  3. Added ability to have blank, custom sheets (Choose blank sheet or import a sheet from another workbook).
  4. Moved Top Sheet buttons into Scope Sheet toolbar.
  5. Other minor bug fixes.
Older Versions
  1. Prior version change information may be added over time.

Click here to schedule time for your demonstration

Schedule a Demonstration