Hamilton County Facilities

[General Services] – DEG

General Services Davies Engineering Group

Archibus

11/30/19 – Worked with County to add IGS accounts for gas accounts.06/24/20 – Lots of work on Archibus this month. We’ve trained Sharon and Ryan to help with bill entry. Added the missing constellation bills to 264, 1033, 2611 accounts from the CCAO change. Fixed a myriad of IGS issues from missing accounts and bills. Reconciled the JC account from a missing gas bill in Nov 2019. Fixed 250 WHT from estimated electric bills that showed up in May 2020 for March and April 2020. Provided the regular monthly reports for Bert and Tim.
12/27/19 – Finalized bills and updated monthly reports.
01/31/20 – Finalized bills and updated monthly reports. CH gas has some issues.
02/28/20 – Finalized bills and updated monthly reports.
03/31/20 – TTC working more on Monthly reports and Archibus due to Covid. final reports sent to Bert late.
04/30/20 – TTC continues to work on Archibus with Bracken due to Covid. Final reports were missing data, ttc updated and re-sent reports to bw.
05/27/20 – TTC working on Archibus approval all month. TTC and BDS working on CH gas issues for Dec 2019 and Feb 2020, data and bills need to be updated.
06/24/20 – Archibus was updated this month. We spent time getting up to speed on the new updates, we spent a good deal of time manually creating header blocks for the Bert monthly reports due the Archibus update and we trained some additional people in Archibus usage. A&D and 250 WHT have Covid related billing issues and Comm Center was found to get missing IGS gas bills entered.
07/29/20 – The DOC addin is not online yet so we updated headers manually this month. The A&D was finally reconciled so we will need to input June bill and then unarchive April and May so we can fix these bills. The good news is that the County is getting money back. Courthouse IGS and Duke IT rate bills are goofy but we will figure them out.
08/26/20 – All estimated bills are corrected. Tim contacted TEI about adding the SPCA to the Archibus list of buildings.
09/18/20 – TTE owes county SOSS for SPCA, Courthouse EDI bill messed up again. AD building was estimated.
10/28/20 – Archibus is up to date. 222 Water estimated, 230 water is estimated, Courthouse Water is estimated, JC water is estimated, 800 gas estimated, 2611 Water missing, 2611, 2377, 264 IGS gas August missing. Bert monthly reports are ready for review.
12/10/20 – Archibus reports are being sent out on a monthly basis as usual. The Courthouse gas is being switched to the FT account and should start coming in on the regular IGS bills. several water and gas accounts are estimated presumably because of Covid. This month’s bills are caught up in the queue, several water bills are estimated.
12/28/20 – Monthly Reports sent to Bert.
01/26/21 – Monthly Reports are ready minus the IGS bills for November.
02/24/21 – CH gas bills not right end of 2020, working on EDI tax roll ups, approving regular bills.
03/25/21 – Most EDI bills missing this month. IGS and Duke gas bills are a mess, overbilled in November 2020, TTE to download Animal Shelter bills from Myduke and then enter them as part of last year SOSS.
04/29/21 – 2021 SOSS approved. ThermalTech entered all Animal Shelter bills through February. We are catching up on monthly bills.
05/26/21 – All bills for the last two months and Monthly Reports resolved except the Courthouse gas bill from October.
06/25/21 – This month has had a lot of Archibus activity. The EDI process has been in testing, TTE working on $15,000 utility credit from Duke and IGS finally resolved and the Crime Lab bills were added, checked, and approved in Archibus.
07/28/21 – Meeting with County went well. ThermalTech ready to start entering Water and IGS bills.
08/25/21 – Archibus Water and IGS bills entered and uploaded by ThermalTech this month. TEI uploaded all-electric and gas bills for all accounts this month too. Monthly reports already complete.
09/30/21 – Electric, gas, and water bills updated. Bills were downloaded and uploaded to Archibus by TEI for Duke elec & gas. Monthly report emails.
10/29/21 – Electric, gas, and water bills updated. Bills were downloaded and uploaded to Archibus by TEI for Duke elec & gas. Monthly report sent late by TTC.
11/30/21 – Electric, gas, and water bills updated. Bills were downloaded and uploaded to Archibus by TEI for Duke elec & gas. Monthly report sent by TTC.
01/22/22 – We have been working on the EDI integration with Duke this month and now have weekly meetings on the new EDI process. 29 bills are missing from December at this time and we are having a hard time getting them reimported from Duke. Duke sent a new text file to BRG for import, I don’t know if that is going to work. TEI stands ready to enter them manually if the import does not work.
02/25/22 – Lots of work on EDI bills in new format, fixing and entering new bills.
03/31/22 – meeting with Duke and County bi-weekly for new EDI process. Attended EDI training with County.
04/28/22 – New EDI bills are coming in and they are wrong; too many line items, usage is doubled and we can not access the Duke Portal. This was relayed to the Duke EDI team this morning during out bi-weekly meeting.
05/25/22 – Several Archibus and EDI meetings trying to resolve new billing issues. it’s better but not fixed. TEI manually updating all bills that come in at this time.
07/27/22 – We are still working with Duke trying to EDI billing resolved with BRG and Duke EDI and currently we are still entering most bills manually. After they are approved we are updating almost all lines, and we are entering water bills directly.
10/26/22 – Archibus bills updated as much as possible and Duke billing issues sent to Duke and IGS, big meeting next Monday.
02/22/23 – Archibus being updated monthly and TEI is fixing almost all EDI inputs from Duke.
03/30/23 – Working on final EDI resolution for double counting usages, fixing CH gas and electric bills, Record Center. Working with BRG to fix EDI input adn stop queueing issues. Dane and 111 will not work for EDI.
04/26/23 – BRG updated the macro for importing usage from EDI and the double usage has been eliminated. We have as a group decide not to import the EDI data from small accounts that have combined gas and electric. ThermalTech will enter these directly.
05/21/23 – Many problems still exist in Archibus from Duke bills or EDI entries from Duke but we are down to handling them on 3 or 4 projects. CH, 5035, 250 and Animal Shelter.
06/28/23 – Most problems have been worked out with the module. EDI billing is starting to smooth out. BRG requested to fix new billing lines last month. Combination electric and gas accounts will have to entered manually.
07/26/23 – Met with BRG and County this month to discuss Archibus updates and new version rollup.
10/25/23 – SPHQ and 5035 gas bills reconciled and records unarchived for approval. TTC approved modifying 18 months of SPHQ bills back to April 2022. 5035 corrected bill not as easy to approve, TTC sent question to Duke about rebill estimates. David Hiser is processing a billing records check for us.
01/31/24 – Archibus updates continue to be made on billing and modules. We are still waiting on final updated gas bills for IGS for 2023.
06/26/24 – Some bills still have issues but we are 99% back on track with Duke billings.
07/24/24- No major reported issues this month in billing.
09/24/24 – Duke EDI issues resolved, several bills have late charges and under billed, we continue to roll with the punches.
01/28/25 – Billing errors are begin reconciled with Duke and Dynegy and IGS. Monthly reports are being sent on schedule with specific data.
05/28/25 – Bill entry continues and errors are reducing, I dare say we are almost back to normal. Except JC reported no gas usage in April, Duke and IGS have been contacted.
06/25/25 – Bill entry continues and we are working out problems with EDI. The JC has an errant gas meter reading.
07/30/25 – Bill review going well. Dynegy and Duke have an issue on a bill and Hillcrest has an gas cost recovery issue.
08/26/25 – Dynegy cost misses being worked on with Duke and Dynegy. Duke received approval to recovery missing Gas Recovery cost for a large part of 2025. TTE tracking and predicting cost recovery for HamCo.
09/24/25 – JN asked to update the Siren procedures to start in March 2026.
10/29/25 – Siren PM was rescheduled to March.
12/12/25 – 111 Archibus entered in DEV and ready for review. DEG working on 1701.
01/25/26 – 111 submitted for review on Jan 26. 1701 will be started once 111 feedback is returned and worked on until complete. New access to past PM procedures will help greatly in crafting the new PM’s.
02/18/26 – 111 submitted. 1701 submitted for review and we met twice on conforming the 1701 PM’s into County standard format. Vogt working on updating the worksheet template for this and future project.
02/20/26 – Duke has agreed to separate and create new accounts for 111, 525, 1701 locations. This will eliminate the EDI issues with BRG. We are not sure when this will happen.
02/25/26 – Commodity usage getting double in 2026 again just like 2025, probably a BRG fix.
03/25/26 – DEG & BRG working on Archibus billing issues with Duke. 111, 525, and 1701 bills have been separated into electric and gas bills. We are working on organizing and getting into EDI the data and processed through BRG.
04/29/26 – We are working on March bills now for reports. Hillcrest access was granted this month and Duke fixed access to the newly separated bills for 111, 525, and 1701. Those should be entered soon. We will verify.
05/27/26 – Working on revised 1701 PM list with Robert and Tim. All other reports submitted on scheduled. Good month for billings.
06/25/26 – DEG to update1701 PM import, working with Tim on fixing bad data import. DEG to verify more equipment in field, need more time at building and with BMS to get additional data.
08/26/26 – 1701 Import template sent to County for final review. Working on Hillcrest export for Hillcrest start of work.
10/26/26 – 1701 has been finalized with edits and tweaks along the way. It should be final, final, final, final now.

Archibus Read More »

TEI – General Services

01/26/21 – Website updated, jquery issued addressed, 3 plugins updated, PHP security issued researched.
02/25/21 – Updated all proejcts for virtual partner meeting. Updated PW rates.
03/25/21 – TTC archived previous contract general service post to the TEI-General Services- Archive.
04/29/21 – Domain Name renewed with locking. Website updated. New scripts updated but TTC still to update more features this month after meeting.
05/26/21 – Updated the website this month, uploaded the PW rates for the month, udpated the legal wrap for Jill becoming the Interim Purchasing Director.
06/25/21 – Website updated, Partner meeting moved to Friday and it will be in person this month.
07/29/21 – Partner meeting. Website updated.
08/05/21 – Website down, TTC working repairs.
08/12/21 – Website restored through Doteasy, although WebFeat was also contacted.
08/16/21 – TTC backing up website locally in the hopes of moving to the WordPress.com servers, website down again. TTC working on restoring.
08/18/21 – TTC restored the website from my local backup and will start backing up monthly after the partner meeting. I need to address jquery degradation soon.
10/04/21 – Bert contacts TTC informs him the website is down again. TTC restores but the website keeps crashing again daily.
10/25/21 – TTC spends most of the day troubleshooting and restoring website backups, isolates issues to plugins on the website. I disabled all plugins and started enabling them one a time. Eventually got the website working, but the formatting was not quite right. I reached out to WebFeat to fix formatting by partner meeting.
10/28/21 – Website crashes again and TTC restores website. TTC and MCB attend Partner Meeting.
02/24/22 – Website updated. Scripts need to be updated soon. PW rates uploaded.
03/31/22 – Attended PM meeting.
04/28/22 – Attended PM meeting in person.
05/25/22 – Final Energy Report sent to Ralph for sharing with Holly and Jeff.
05/26/22 – Afternoon meeting. Website update last two days.
06/30/22 – Website updated for meeting.
07/28/22 – Website updated for meeting.
08/25/22 – Website updated for meeting.
09/29/22 – Website updated for meeting.
10/26/22 – Website plugin not working, TTC reached out to WebFeat for repairs, now we have a security issue in items, TTC reached out again with screenshots.
04/26/23 – Elementor plugin needs updated, TTC to do when after Partner Meeting.
12/15/23 – TTE to provide JC and CH CAD Background updates for Archibus. Start conversation with new partner for this work.
03/28/24 – Go Reds, Opening Day 2024. Barth wins Design Partner of the Month! Hahahaha.
04/12/24 – Webfeat finished updates on the HamCo website. Fixes Elementor, Jquery and other pending updates. Backs up website and gets rids of all update prompts.
04/20/24 – TTC creates access for Elevar on website.
07/17/24 – Website hacked. Support ticket submitted. Website repaired in two days and additional securities added.
07/24/24 – New website securities added and users edited with new system. Target Range not working, new support ticket submitted by TTC. I disabled GBBN access to website but left all their post intact.
08/01/24 – Updated Prevailing Wage Rates.
08/01/24 – Updated Prevailing Wage Rates.
09/01/24 – Updated Prevailing Wage Rates.
10/01/24 – Updated Prevailing Wage Rates.
11/01/24 – Updated Prevailing Wage Rates.
12/01/24 – Updated Prevailing Wage Rates.
01/01/25 – Updated Prevailing Wage Rates.
01/09/25 – Updated Prevailing Wage Front End document shared with everyone.
02/01/25 – Updated Prevailing Wage Rates.
03/01/25 – Updated Prevailing Wage Rates.
04/01/25 – Updated Prevailing Wage Rates.
05/01/25 – Updated Prevailing Wage Rates.
05/19/25 – Downloaded new MEP RFQ.
06/01/25 – Updated Prevailing Wage Rates.
07/31/25 – All Partners were instructed to reinforce the County requirements for construction including but not limited to no parking onsite, Badges displayed at all times, do not visit HC spaces outside of the project scope, no using county tools, no using county supplies.
12/11/15 – Website updated, PW rates updated and sent, mid-month updates being sent by Ted.
08/27/26 – New County Bid Advertisement & Front End Released
09/04/26 – Small Project Quotes packet updated by Kerry and Jill.
09/23/26 – DEG getting badges updated Q4 2026.
10/27/26 – Worked on creating a new category parent category to separate projects into Active, Closeout and Archived. Category is created, navigation is updated, but operation is not quite right yet.

TEI – General Services Read More »

Scroll to Top