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.