Downloads

MERL 2017.9
Component Updates
Import
  • Fixed bug importing txt/csv file which would ignore the Unit Price and Supplemental Description columns.
Export
  • Fixed bug exporting to TrnsPort XML which would indicate the file could not be exported with an empty Project Description even if the Project Description contained data.
MERL 2017.8
Component Updates
Average Unit Prices
  • Updated Average Unit Price data to include 2016 and 2017 (through 6/30/2017).
Import
  • Added better message for exception when trying to import a csv/txt file that is open in another application.
  • Modified column mapping names for importing csv/txt file for consistency and clarity.
Pay Item Codes
  • Updated 2012 Pay Item Codes List.
Vendors
  • Updated MDOT Approved Vendor List
MERL 2017.5
Component Updates
Bid Utility
  • Fixed 'object null reference' exception saving AUP from Bid Analysis
Export
  • Added support for exporting contracts to MERL Web format
Import
  • Added support for importing contracts from MERL Web format.
Local Job Manager
  • Balancing Contract Modification will now zero out items that have gone over the project quantity as well as items under quantity.
  • Fixed bug which failed to update Qty Paid after finalizing a Pay Estimate.
MERL 5.3.6
Component Updates
General
  • Added support for SQL Server and SQL Express 2016.
Average Unit Prices
  • Updated the Average Unit Prices for the 2012 Pay Items through 9/2016.
Estimator's Worksheet
  • Added validation for MDOT projects to check for a missing Supplemental Description when a value is required on a pay item.
  • Added right-click option to change worksheet column resizing from automatic to manual.
  • Fixed bug when after checking out a contract (while it is open), the Category toolbar was not enabled until the contract was reopened.
Export
  • Added validation to Export to Trns*Port to not allow export when a Supplemental Description is missing for pay items that require it.
Local Job Manager
  • Fixed bug in creating a Pay Estimate where the pay period was ignored when calculating available items to pay.
  • Fixed exception when changing the Pay Estimate Period for a Job Pay Estimate.
Pay Item List
  • Updated the 2012 Pay Item Codes list.
MERL 5.3.5
Component Updates
Project Estimator
  • Fixed exception saving an estimate when there were items that required validation.
Reports
  • Fixed bug which would display a Component One license screen when printing any report.
MERL 5.3.4
Component Updates
Average Unit Prices
  • Updated 2012 Pay Item average unit prices through 3/2016.
Pay Item List
  • Updated 2012 Pay Item Codes List.
Vendors
  • Updated MDOT Approved Vendor List.
MERL 5.3.3
Component Updates
General
  • MERL will no longer run on Windows XP.
  • MERL will no longer connect to a SQL 2005 server instance.
Average Unit Prices
  • Updated 2012 Pay Item average unit prices through 12/2015.
Bid Utility
  • Electronic Bid Submission now combines Description and Supplemental Description columns so there are no blank values.
  • Electronic Bid Submission export ID column changed to Item so Excel doesn't show a strange 'sylk' error when the file is opened.
Estimator's Worksheet
  • Fixed bug when adding a Pay Item which would not default the Quantity to 1 when the units is LSUM.
  • Fixed bug which would not update the list of Groups for the Contract Info drop-down until after a restart.
Export
  • Fixed bug when exporting contract to Field Manager when Project Description contains line feeds ('Not a valid csv line' error occurred in Field Manager import)
Local Job Manager Reports
  • Added option to mark whether a job requires certified payroll or DBE. If not, the Pay Estimate Report footer will exclude text related to payroll/DBE.
MERL Cloud Services
  • Added Tools Menu option for Cloud File Storage Cleanup to give Admin/Power Users tool to delete files from cloud storage including Local Job Manager Uploads, MERL Mobile Job Postings, and MERL Online Backups.
  • Fixed an exception connecting to the cloud that results in a 'Proxy Authentication Required' message.
Security
  • Added check to ensure that a user who is not Admin and is not a Power User cannot run scripts to update the MERL database.
  • Added check to ensure that a user who is not Admin and is not a Power User cannot update MERL via Check for Updates.
  • Added First Name and Last Name to User Info when adding or editing MERL Users.
User Defined Pay Items
  • Fixed bug which only displayed LSUM for the Units when adding a new User-Defined Pay Item code.
MERL 5.3.2
Component Updates
General:
  • For Contracts with multiple Projects, the drop-down list of Project Numbers will now load in Project Number order rather than the order the Projects were added.
  • Added a System Info Form which displays things like OS Version, RAM, # of Processors, SQL Version, etc. Accessed from Help menu or by clicking the 'Connected to [db] on [server] label.
Bid Reports:
  • Fixed an issue on the Bid Comparison Report and the Bid Sheet By Bidder Report where prices and totals would display with 2 digits of precision when the 3 digits option was selected.
Estimator's Worksheet:
  • Added validation check to ensure a Project Number cannot be used more than once for a Contract.
  • Fixed exception which would occur after swapping a pay item for another and then editing the Supplemental Description.
Vendors:
  • Updated MDOT Approved Vendor List.
MERL 5.3.1
Component Updates
Average Unit Prices:
  • Updated 2005 and 2012 Pay Item average unit prices through 2/2015.
Local Job Manager Local:
  • New Feature that brings MERL desktop functionality into the palm of your hand! Local Job Manager Mobile provides the ability to retrieve uploaded contracts from the cloud and add daily postings to them, all from an Android phone or tablet.
MDOT Bid Letting Analysis
  • New Feature that provides data from MDOT's bid letting system for Contract by Contract analysis of bids. Includes options for filtering by date, work type, region, and Pay Item.
Online Backups:
  • New Feature that provides free and secure off-site storage for your agency's MERL contract data. Data backups become convienant and easy for MERL administrators and power users with this new functionality.
Pay Item List:
  • Updated 2012 Pay Item Codes List.
Vendors:
  • Updated MDOT Approved Vendor List.
Local Job Manager Mobile:
  • Fixed the bug which resulted in an exception when attempting to download Postings from cloud storage back into MERL. The exception was caused if the database had no previous Postings for any Contract.
MERL 5.3.0
Component Updates
Average Unit Prices:
  • Updated 2005 and 2012 Pay Item average unit prices through 2/2015.
Local Job Manager Local:
  • New Feature that brings MERL desktop functionality into the palm of your hand! Local Job Manager Mobile provides the ability to retrieve uploaded contracts from the cloud and add daily postings to them, all from an Android phone or tablet.
MDOT Bid Letting Analysis
  • New Feature that provides data from MDOT's bid letting system for Contract by Contract analysis of bids. Includes options for filtering by date, work type, region, and Pay Item.
Online Backups:
  • New Feature that provides free and secure off-site storage for your agency's MERL contract data. Data backups become convienant and easy for MERL administrators and power users with this new functionality.
Pay Item List:
  • Updated 2012 Pay Item Codes List.
Vendors:
  • Updated MDOT Approved Vendor List.
MERL 5.2.8
Component Updates
Export:
  • Fixed Export to Trns*Port to export empty string for Estimator.
  • Fixed Export to Trns*Port to not export if Project Description is blank.
MERL 5.2.7
Component Updates
General:
  • MERL is now compatible with SQL 2014.
Average Unit Prices:
  • Fixed overflow exception when filtering out one or more regions from Average Unit Prices.
Estimator's Worksheet:
  • Fixed bug which prevented Estimate Total for non-Default Estimate from being updated when items or quantity or price changed.
  • Fixed bug which required quantity <1 to be entered with leading zero (0.5 rather than just .5).
Export:
  • Export to Trns*Port now only exports to xml format which is required by MDOT.
  • Fixed bug in Export to Field Manager which could result in an exception: 'A BidItem has an incorrect Estimate Price'.
Import:
  • Fixed 'Cannot find column -1' exception importing from textfile when Price column is not included.
Local Job Manager:
  • Added Item Summary tab which displays all items with info on Qty Placed and Paid.
  • Added Item Posting History which is available from the Item Summary Grid. This displays Posting History for a single pay item (report also added).
MERL 5.2.6
Component Updates
Bid Reports:
  • Additional Format changes to the Blank Bid Sheet report (added ability to show/hide Contract/Project Info as well as the Contractor Signature line).
Estimator's Worksheet:
  • Fixed Pay Item Window so quantity and price only allow up to 3 digits of precision (to match entry in the worksheet).
Supplemental Description Cleanup:
  • After merging descriptions, focus will be set back to the last edited Pay Item rather than the first Pay Item in the list (or the next item in the list if the previous item was removed).
MERL 5.2.5
Component Updates
Bid Reports:
  • Format changes to the Blank Bid Sheet report.
  • Added option on Blank Bid Sheet report to display Estimate Price for Lump Sum items (rather than a blank space).
  • Fixed issues with overlapping text in headers/footers where the Contract, Project, or Location is longer.
Estimate Reports:
  • Fixed bug which could result in duplicate line numbers on Estimate, Contract, and Breakdown reports.
  • Fixed issues with overlapping text in headers/footers where the Contract, Project, or Location is longer.
Import:
  • Fixed bug when selecting a User-Defined spec year from the drop-down when importing a CSV/TXT file.
  • Fixed bug which prevented importing a CSV/TXT file containing user-defined pay items.
Local Job Reports:
  • Added Contractor name to Posting and Pay Estimate reports.
  • Fixed issues with overlapping text in headers/footers where the Contract, Project, or Location is longer.
Project Estimator:
  • Added new Project Type: Special Assessment District.
MERL 5.2.4
Component Updates
Bid Reports:
  • Fixed bug which would show 'ProjectLocation' instead of the actual location in bid report header.
Bid Utility:
  • Fixed exception showing the Open Bid Project dialog if there is an estimate whose description length is too long.
Export:
  • Standardized export menus so the Export to TrnsPort CSV option is easier to find.
MERL 5.2.3
Component Updates
General:
  • The Main window location/size for the Project Estimator, Bid Utility, and Local Job Manager forms are now saved between sessions when the window is undocked (and can be reset as well).
Project Estimator:
  • Added option to copy estimate items to the clipboard to be pasted into another estimate.
  • Fixed a bug checking out a contract with an Estimate description longer than 100 characters.
  • Fixed a bug doing a check-in after changing Category in the worksheet but not moving off the cell first.
MERL 5.2.2
Component Updates
Estimate Reports:
  • Added Date Last Edited to report headers.
  • Fixed exception when the worksheet sort order is cleared and then a report is run.
  • Fixed bug which would not load the current Project/Estimate in the Reports window (first Project/Estimate would load instead).
Estimator's Worksheet:
  • Fixed bug which prevented Multi-Edit.
  • Fixed bug loading Sort Order dialog when BreakdownID was the first sort column.
  • Fixed exception when deleting a Supplemental Description from the worksheet and moving off the cell.
MERL 5.2.1
Component Updates
Average Unit Prices:
  • Updated 2005 and 2012 Pay Item average unit prices through 12/2013.
Estimate Info:
  • Bumped Estimate Description field from 100 to 255 characters.
  • Changing the Selected Alternative estimate (default) should update the Contract Total.
Export:
  • Fixed cross-thread exception bug in Bulk Export.
Reports:
  • Fixed bug in running Estimate Breakdown Report with categories and a page break on category included.
  • Added option to hide prices and totals on the Engineer's Opinion of Costs report.
MERL 5.2.0
Component Updates
Local Job Manager:
  • Completely rewritten/redesigned Local Job Manager. Please Note: This is a major update to MERL and requires all MERL Clients connecting to a shared database be updated as well.
MERL 5.1.8
Component Updates
Database Backup:
  • Backups for SQL 2008 and newer (full SQL Server) are now compressed.
Estimator's Worksheet:
  • Fixed issue where Estimate Window wasn't updated when a contract is loaded and the Contract/Project Info window is collapsed.
  • Fixed issue where deleting multiple lines in the worksheet didn't renumber the IDs.
  • Fixed issue doing a Check In from the Estimate Worksheet when only the Project or Estimate was checked out (not the whole Contract).
Import:
  • For Import from TrnsPort Xml File, fixed so Unit Price and Supplemental Description are no longer required.
Login:
  • Changed Login process so it won't error out on check for database version.
MERL 5.1.7
Component Updates
Pay Item List:
  • Fixed bug in loading the Average Unit Price List when a user-defined pay item code had Bid History.
Import:
  • For Import from TrnsPort Xml File, fixed so Project Location 1 and 2 are no longer required.
MERL 5.1.6
Component Updates
Avg Unit Price Window:
  • Fixed bug which prevented Avg Bid Price from showing for items without Supplemental Description.
  • Items listed now includes items with no State AUP but have Local Bid History.
Bid Reports:
  • Added divider line between Bid Price and Total columns on the Blank Bid Sheet report.
  • Added Bid Letting Date/Time to Blank Bid Sheet Report
Bid Utility:
  • Added time of Opening of Bids to Bid Letting Date
Estimator's Worksheet:
  • Added code to automatically resize columns after scrolling.
Reports:
  • Fixed code to save Agency Name to settings when changed.
Updates:
  • Added automatic check for updates with indicator if updates are available on the main form.
  • Simplified version check at startup so there's a minimum application version that can connect to a database--users connecting to the same database can have different versions if the database structure is unchanged between versions.
MERL 5.1.5
Component Updates
Bid Utility:
  • Fixed rounding issue when creating Bid Project items for estimate price with 3 digits (would round to 2 digits). This also fixes a related Export to Field Manager issue.
  • Fixed 'object reference' exception when selecting Avg Bid Price Report, Bid Sheet By Bidder report, or Contract Report with no Contract selected.
Estimator's Worksheet:
  • Fixed bug which would make the Supplemental Description non-editable after editing Quantity or Price.
  • Fixed unhandled exception when clicking the Category cell in the grid.
  • Fixed rounding issue for price with 3 digits (would round to 2 digits on save/reload). This also fixes a related Export to Field Manager issue.
Reports:
  • Fixed text overlap issue for Location on the Blank Bid Sheet report.
MERL 5.1.4
Component Updates
Estimator's Worksheet:
  • Changed how sorting of estimate items is applied to the worksheet.
  • Fixed bug which would make the Supplemental Description non-editable after editing Quantity or Price.
Local Job Manager:
  • ​Fixed bug in creating a new Local Job when the items were grouped by Project.
Pay Item List:
  • Updated 2012 Pay Item Codes List.
Reports:
  • Added option on Estimate Reports to display 3 digits of precision for dollar amounts.
MERL 5.1.3
Component Updates
Avg Unit Price Window:
  • Fixed bug so MDOT Misc Codes will only show Avg Bid Price for matching Supplemental Description.
Bid Utility:
  • Added option to show line numbers on Blank Bid Sheet report.
  • Fixed ugly error message if only a decimal is entered for Bid Price on the Bid Form.
Estimator's Worksheet:
  • Fixed bug which would not update the list of pay items in an estimate when switching between Projects.
Project Estimator:
  • Added prompt to save changes before running reports.
Reports:
  • Fixed bug in reports when Unit Price was included in Estimate Sort Order.
Supplemental Description Cleanup:
  • Added Supplemental Description Cleanup utility to Tools->Pay Items menu.