Deleting Custom Permutation Report redirect you to Dashboard
Issue: When deleting a custom permutation report, the application redirects you all the way back to the Home Dashboard page, instead of just the “Permutations” tab of the measure you were looking at. Steps to reproduce: Navigate to a measure Click on the Permutations tab Create and save a custom permutation report if there is none Click on the custom permutation report again and delete the report eTRM brings you all the way back to Home page Business impact: Users are likely to continue managing the custom permutation report of the measure they were viewing. By redirecting the user all the way back to the dashboard, it’s quite inconvenient and time-consuming to go back to the measure.
CA eTRM about 14 hours ago
Bug Report
Deleting Custom Permutation Report redirect you to Dashboard
Issue: When deleting a custom permutation report, the application redirects you all the way back to the Home Dashboard page, instead of just the “Permutations” tab of the measure you were looking at. Steps to reproduce: Navigate to a measure Click on the Permutations tab Create and save a custom permutation report if there is none Click on the custom permutation report again and delete the report eTRM brings you all the way back to Home page Business impact: Users are likely to continue managing the custom permutation report of the measure they were viewing. By redirecting the user all the way back to the dashboard, it’s quite inconvenient and time-consuming to go back to the measure.
CA eTRM about 14 hours ago
Bug Report
Completed
Invalid Calculation
Issue: Calculations using the “BasisValue” column of the shared Effective Useful Life and Remaining Useful Life value table result in validity error. However, the equation is still evaluated correctly in the permutation. Business Impact: Unknown or potentially false validity error, creating confusion and low confidence with the calculation. Reporter: Nicholas Fette (Solaris Technical)
CA eTRM 3 days ago
Bug Report
Completed
Invalid Calculation
Issue: Calculations using the “BasisValue” column of the shared Effective Useful Life and Remaining Useful Life value table result in validity error. However, the equation is still evaluated correctly in the permutation. Business Impact: Unknown or potentially false validity error, creating confusion and low confidence with the calculation. Reporter: Nicholas Fette (Solaris Technical)
CA eTRM 3 days ago
Bug Report
Completed
eTRM Public Postgres Database Isn't Syncing
Issue: The eTRM public Postgres database has not synced since 7/21/2026 ~9 am UTC (~2 AM PST). This is the day we ran the 2026 CET correction update. The database data showed the last updated date was 7/21/2026. Measure activities (e.g., new drafts and new permutations) beyond that date are not reflected in the database after the scheduled sync time. Business Impact: The public PostgreSQL database contains outdated data, preventing users and downstream systems (especially the CEDARS Load Shape Library) from accessing the latest production updates. This resulted in inaccurate reporting and data discrepancies between the public database and the production eTRM system.
CA eTRM 4 days ago
Bug Report
Completed
eTRM Public Postgres Database Isn't Syncing
Issue: The eTRM public Postgres database has not synced since 7/21/2026 ~9 am UTC (~2 AM PST). This is the day we ran the 2026 CET correction update. The database data showed the last updated date was 7/21/2026. Measure activities (e.g., new drafts and new permutations) beyond that date are not reflected in the database after the scheduled sync time. Business Impact: The public PostgreSQL database contains outdated data, preventing users and downstream systems (especially the CEDARS Load Shape Library) from accessing the latest production updates. This resulted in inaccurate reporting and data discrepancies between the public database and the production eTRM system.
CA eTRM 4 days ago
Bug Report
Allow Measure Developer to Edit Parameter Labels
Description: When measure developers need to update parameter labels, they would need to delete the label, add new labels, and set up all the value tables again (setting up value tables is a multi-step process of reselecting the parameter and permuting the rows). Allowing measure developers to edit labels would reduce setup time and costs for measure development. Business Requirement: Reduce measure development time and effort by simplifying the process to update parameter and parameter labels. By: Lake Casco
CA eTRM 11 days ago
Less Development Cost
Feature Request
Allow Measure Developer to Edit Parameter Labels
Description: When measure developers need to update parameter labels, they would need to delete the label, add new labels, and set up all the value tables again (setting up value tables is a multi-step process of reselecting the parameter and permuting the rows). Allowing measure developers to edit labels would reduce setup time and costs for measure development. Business Requirement: Reduce measure development time and effort by simplifying the process to update parameter and parameter labels. By: Lake Casco
CA eTRM 11 days ago
Less Development Cost
Feature Request
Integrate OpenBCA Tool within eTRM
Integrate the newly released, open-source OpenBCA tool into eTRM for what-if scenario analysis of cost-effectiveness beyond what is currently possible within the CET. Per the OpenBCA site: “OpenBCA can assess individual technologies—including energy efficiency, demand response, distributed generation, distributed storage, electric vehicles (e.g. managed charging), and building electrification—as well as integrated DER portfolios at the project, program, and portfolio levels. OpenBCA can also support non-wires solutions (NWS), non-pipes solutions (NPS), and location-specific analyses when avoided or deferred infrastructure costs can be represented through appropriate valuation inputs.” See OpenBCA Tool | NASEO for details on options for integrating the tool, licensing, and other IT considerations. Note that incorporating additional benefit-cost and cost-effectiveness calculation capabilities beyond CET alone is consistent with Cal TF’s mission “To support the growth and success of energy efficiency and IDSM” and the vision for the eTRM Roadmap topic of Data Analytics.
michael.daukoru@futee.biz 17 days ago
Feature Request
Integrate OpenBCA Tool within eTRM
Integrate the newly released, open-source OpenBCA tool into eTRM for what-if scenario analysis of cost-effectiveness beyond what is currently possible within the CET. Per the OpenBCA site: “OpenBCA can assess individual technologies—including energy efficiency, demand response, distributed generation, distributed storage, electric vehicles (e.g. managed charging), and building electrification—as well as integrated DER portfolios at the project, program, and portfolio levels. OpenBCA can also support non-wires solutions (NWS), non-pipes solutions (NPS), and location-specific analyses when avoided or deferred infrastructure costs can be represented through appropriate valuation inputs.” See OpenBCA Tool | NASEO for details on options for integrating the tool, licensing, and other IT considerations. Note that incorporating additional benefit-cost and cost-effectiveness calculation capabilities beyond CET alone is consistent with Cal TF’s mission “To support the growth and success of energy efficiency and IDSM” and the vision for the eTRM Roadmap topic of Data Analytics.
michael.daukoru@futee.biz 17 days ago
Feature Request
Completed
Strip Leading and Trailing Blank Space in eTRM Fields
Background eTRM currently accepts and stores leading and trailing whitespace entered into text fields (e.g., “Technology ID” value table). While editing a value, the whitespace is visible. However, after saving, the UI trims the whitespace for display in both the Value Table and the Permutation Table, making it appear as though the value has been cleaned. The whitespace is still present in the underlying data and is returned in downloads, the API, and the database. This inconsistent behavior makes the issue difficult to detect during quality control. In our case, the hidden whitespace caused a downstream validation error in the CEDARS Load Shape Tool (the Tool did not generate the avoided cost for the measure), but the root cause was not immediately apparent because the UI displayed the value without the whitespace. Solution: eTRM does the automatic stripping across the board (not just in the display) Steps to reproduce: Navigate to a measure Create or click on an existing value table Edit the value table column that is of text data type Save the edit Map the field to the per
CA eTRM about 1 month ago
High Priority
Bug Report
Completed
Strip Leading and Trailing Blank Space in eTRM Fields
Background eTRM currently accepts and stores leading and trailing whitespace entered into text fields (e.g., “Technology ID” value table). While editing a value, the whitespace is visible. However, after saving, the UI trims the whitespace for display in both the Value Table and the Permutation Table, making it appear as though the value has been cleaned. The whitespace is still present in the underlying data and is returned in downloads, the API, and the database. This inconsistent behavior makes the issue difficult to detect during quality control. In our case, the hidden whitespace caused a downstream validation error in the CEDARS Load Shape Tool (the Tool did not generate the avoided cost for the measure), but the root cause was not immediately apparent because the UI displayed the value without the whitespace. Solution: eTRM does the automatic stripping across the board (not just in the display) Steps to reproduce: Navigate to a measure Create or click on an existing value table Edit the value table column that is of text data type Save the edit Map the field to the per
CA eTRM about 1 month ago
High Priority
Bug Report
AI Bot to create initial set of Measure Property Data
Description Develop an AI-powered assistant to automate the initial creation of Measure Property Data during measure development, using data from the permutation table, Measure Characterization, existing measure MPDs, predefined set of common data collection requirements. The generated output should populate the values or suggestions for all the fields of the eTRM MPD templates (e.g., names, description, applicable eTRM permutations, data types, default values, validation rules) Measure developers would be able to review, edit, accept, or reject the AI-generated suggestions before they are saved. Business Rationale Reducing manual effort, improving consistency across measures, accelerating the measure development and management process, and simplifying future updates while maintaining human oversight over the final data.
CA eTRM about 1 month ago
AI Integration
Feature Request
AI Bot to create initial set of Measure Property Data
Description Develop an AI-powered assistant to automate the initial creation of Measure Property Data during measure development, using data from the permutation table, Measure Characterization, existing measure MPDs, predefined set of common data collection requirements. The generated output should populate the values or suggestions for all the fields of the eTRM MPD templates (e.g., names, description, applicable eTRM permutations, data types, default values, validation rules) Measure developers would be able to review, edit, accept, or reject the AI-generated suggestions before they are saved. Business Rationale Reducing manual effort, improving consistency across measures, accelerating the measure development and management process, and simplifying future updates while maintaining human oversight over the final data.
CA eTRM about 1 month ago
AI Integration
Feature Request
Software Business/Functional Requirements Management
Transition from SpecHub as a software requirements management tool to in-house alternative.
CA eTRM about 1 month ago
Feature Request
Software Business/Functional Requirements Management
Transition from SpecHub as a software requirements management tool to in-house alternative.
CA eTRM about 1 month ago
Feature Request
SSO for Featurebase
Implement single sign-on (SSO) for Featurebase users who already have eTRM login credentials to avoid eTRM users having to create a separate set of login credentials for Featurebase, unless they decide to do so for personal reasons.
CA eTRM about 1 month ago
External System Integration
Feature Request
SSO for Featurebase
Implement single sign-on (SSO) for Featurebase users who already have eTRM login credentials to avoid eTRM users having to create a separate set of login credentials for Featurebase, unless they decide to do so for personal reasons.
CA eTRM about 1 month ago
External System Integration
Feature Request
Allow measure developer to download unrounded data for QC
eTRM permutation data is rounded at the display and permutation download - some due to regulatory reasons (e.g., savings are reported at 3 sigfigs). However, one measure data QC rule is that the UES = UECBase - UECMeas. This rule is ambiguous to QC with the current data availability since the rounding introduces precision errors (can be huge for large savings that are rounded to 3 sigfigs) that require the measure developers to self-verify whether the difference is actual data inconsistency or rounding error. Allow measure developers and measure reviewers to download/access unrounded permutation values to perform their QC. Business rationale/requirement: Improve the accuracy and efficiency of measure quality control by providing measure contributors measure-by-measure access to unrounded permutation data through downloads and other approved data-access methods.
CA eTRM about 2 months ago
Permutations
Feature Request
Allow measure developer to download unrounded data for QC
eTRM permutation data is rounded at the display and permutation download - some due to regulatory reasons (e.g., savings are reported at 3 sigfigs). However, one measure data QC rule is that the UES = UECBase - UECMeas. This rule is ambiguous to QC with the current data availability since the rounding introduces precision errors (can be huge for large savings that are rounded to 3 sigfigs) that require the measure developers to self-verify whether the difference is actual data inconsistency or rounding error. Allow measure developers and measure reviewers to download/access unrounded permutation values to perform their QC. Business rationale/requirement: Improve the accuracy and efficiency of measure quality control by providing measure contributors measure-by-measure access to unrounded permutation data through downloads and other approved data-access methods.
CA eTRM about 2 months ago
Permutations
Feature Request
Automatically classify QA comments by type and severity
When a measure package is being reviewed, use AI to automatically classify comments into severity levels (High/Medium/Low) and comment category. This will enable quicker reviews by helping prioritize and respond to QA comments. Example categories: CriticalityBroad CategorySpecific Category High Criticality Savings Savings: methods, assumptions, base/measure, or data High Criticality Savings Savings: general/issue with results High Criticality Costs Costs: methods/assumptions/data High Criticality Costs Costs: general/issue with results High Criticality Permutation edit Permutation edit: add Tech ID High Criticality Permutation edit Permutation edit: MAT High Criticality NTG Update NTG Medium Criticality Methodology description Methodology description: incomplete/unclear/missing/erroneous Medium Criticality Clarification needed Clarification needed: technical/code/program Medium Criticality Analysis reference Analysis reference: incomplete/unclear/missing Medium Criticality Future comment Future comment: will be high criticality in the future Low Criticality Language update grammar, spelling, and suggested clarity Low Criticality Comment out of scope Comment out of scope: comment on wrong version Low Criticality Comment out of scope Comment out of scope: general comment to PA Low Criticality Comment out of scope Comment out of scope: reporting and EM&V processes outside the eTRM Low Criticality Code information Code information: date, cycle number, and/or reference Low Criticality Reference Edit Reference edit Low Criticality Delivery
GrantB 2 months ago
AI Integration
Feature Request
Automatically classify QA comments by type and severity
When a measure package is being reviewed, use AI to automatically classify comments into severity levels (High/Medium/Low) and comment category. This will enable quicker reviews by helping prioritize and respond to QA comments. Example categories: CriticalityBroad CategorySpecific Category High Criticality Savings Savings: methods, assumptions, base/measure, or data High Criticality Savings Savings: general/issue with results High Criticality Costs Costs: methods/assumptions/data High Criticality Costs Costs: general/issue with results High Criticality Permutation edit Permutation edit: add Tech ID High Criticality Permutation edit Permutation edit: MAT High Criticality NTG Update NTG Medium Criticality Methodology description Methodology description: incomplete/unclear/missing/erroneous Medium Criticality Clarification needed Clarification needed: technical/code/program Medium Criticality Analysis reference Analysis reference: incomplete/unclear/missing Medium Criticality Future comment Future comment: will be high criticality in the future Low Criticality Language update grammar, spelling, and suggested clarity Low Criticality Comment out of scope Comment out of scope: comment on wrong version Low Criticality Comment out of scope Comment out of scope: general comment to PA Low Criticality Comment out of scope Comment out of scope: reporting and EM&V processes outside the eTRM Low Criticality Code information Code information: date, cycle number, and/or reference Low Criticality Reference Edit Reference edit Low Criticality Delivery
GrantB 2 months ago
AI Integration
Feature Request
Ability to sort value tables and permutations
Allow a contributor to sort Value Tables based upon any column (parameter or value) and embed that sorted table to a characterization field. eTRM sorts by the parameters alphabetically. As a result, the offering ID table is typically out of order by the offering ID, which can be slightly confusing. Might be easier to let a base user sort when viewing the table rather than rely on the developer to sort. Allow for a stacking sort similar to how it currently works (alphabetically by row).
CA eTRM 3 months ago
Feature Request
Ability to sort value tables and permutations
Allow a contributor to sort Value Tables based upon any column (parameter or value) and embed that sorted table to a characterization field. eTRM sorts by the parameters alphabetically. As a result, the offering ID table is typically out of order by the offering ID, which can be slightly confusing. Might be easier to let a base user sort when viewing the table rather than rely on the developer to sort. Allow for a stacking sort similar to how it currently works (alphabetically by row).
CA eTRM 3 months ago
Feature Request
Ability to add and remove measure roles for multiple measures at once
Ability for admin users (PA Admin, CPUC Admin, and System Admin) to add and remove measure contributor roles to multiple measures at once. Admin users typically add (or remove) the same user(s) to multiple measures. Currently, admin users would have to do this one measure at a time, which can become quite time-consuming.
CA eTRM 3 months ago
User Experience (UX)
Feature Request
Ability to add and remove measure roles for multiple measures at once
Ability for admin users (PA Admin, CPUC Admin, and System Admin) to add and remove measure contributor roles to multiple measures at once. Admin users typically add (or remove) the same user(s) to multiple measures. Currently, admin users would have to do this one measure at a time, which can become quite time-consuming.
CA eTRM 3 months ago
User Experience (UX)
Feature Request
Show unrounded data for value tables in the MP download
The value table CSV files that are a part of the Measure Package download should show the full precision, unrounded values. eTRM displays rounded values but uses the full precision data for calculations. However, it’s hard for a user (without having an open draft of the measure version) to reproduce the numbers and/or trace the rounding error because the downloaded data is rounded. Measure developers with an active open draft can download the individual value tables and get the unrounded numbers. Users can also get the unrounded numbers from the JSON file, but this process is not user-friendly, well-known, or intuitive.
CA eTRM 3 months ago
Simplified UX
Feature Request
Show unrounded data for value tables in the MP download
The value table CSV files that are a part of the Measure Package download should show the full precision, unrounded values. eTRM displays rounded values but uses the full precision data for calculations. However, it’s hard for a user (without having an open draft of the measure version) to reproduce the numbers and/or trace the rounding error because the downloaded data is rounded. Measure developers with an active open draft can download the individual value tables and get the unrounded numbers. Users can also get the unrounded numbers from the JSON file, but this process is not user-friendly, well-known, or intuitive.
CA eTRM 3 months ago
Simplified UX
Feature Request
Enable measures to link to one another to ensure information consistency
Ability for measures to link to one another. For example, linking deemed measure to fuel sub, low income, and/or custom measure counterpart Business rationale/requirement: Help promote data consistency and synchronization during measure updates.
CA eTRM 3 months ago
MP Management
Feature Request
Enable measures to link to one another to ensure information consistency
Ability for measures to link to one another. For example, linking deemed measure to fuel sub, low income, and/or custom measure counterpart Business rationale/requirement: Help promote data consistency and synchronization during measure updates.
CA eTRM 3 months ago
MP Management
Feature Request
Embed parameters in Characterization
Ability to embed parameters or link to the parameter (shared or measure specific) in the characterization to dynamically list eligibility and measure scope, instead of recreating static tables. Example use cases: “Eligible Building Types” and “Eligible Building Location” subsections of “Program Requirement” “Modeled ” subsections of “Electric Savings” of modeled measures. It would be useful to just import or insert a link to the tables instead of recreating them.
CA eTRM 3 months ago
Characterization
Feature Request
Embed parameters in Characterization
Ability to embed parameters or link to the parameter (shared or measure specific) in the characterization to dynamically list eligibility and measure scope, instead of recreating static tables. Example use cases: “Eligible Building Types” and “Eligible Building Location” subsections of “Program Requirement” “Modeled ” subsections of “Electric Savings” of modeled measures. It would be useful to just import or insert a link to the tables instead of recreating them.
CA eTRM 3 months ago
Characterization
Feature Request
Improve calculation transparency and traceability
Add an "evaluate" function to show step-by-step calculation processes. Currently, evaluating calculations in the eTRM can be tedious. You need to rerun permutations every single time you make one change to the calculations. Having an evaluate/look in function, similar to the one in Excel that allows you to see every step along the way, would be helpful so that you do not need to check/run permutations every time. The user can have options on what CZ, BT, MAT, and other parameters they want to run the evaluate/look in function for.This can also be helpful in the MC, displaying how a calculation is evaluated for a set of parameters would be very helpful for base users. Solutions may include: Evaluate each calculation to a value table and the ability to export that result Above + even when the draft is committed or published (for users)
CA eTRM 3 months ago
Calculations
Feature Request
Improve calculation transparency and traceability
Add an "evaluate" function to show step-by-step calculation processes. Currently, evaluating calculations in the eTRM can be tedious. You need to rerun permutations every single time you make one change to the calculations. Having an evaluate/look in function, similar to the one in Excel that allows you to see every step along the way, would be helpful so that you do not need to check/run permutations every time. The user can have options on what CZ, BT, MAT, and other parameters they want to run the evaluate/look in function for.This can also be helpful in the MC, displaying how a calculation is evaluated for a set of parameters would be very helpful for base users. Solutions may include: Evaluate each calculation to a value table and the ability to export that result Above + even when the draft is committed or published (for users)
CA eTRM 3 months ago
Calculations
Feature Request
Expose relevant eTRM data in a mobile-optimized format
Exposing relevant eTRM data (such as current program eligible measure permutations/offerings/MPDs) to practitioners in the field such as program implementers and project developers in a format optimized for mobile use or use in third-party applications could facilitate uptake of deemed measures.
CA eTRM 3 months ago
User Interface (UI)
Feature Request
Expose relevant eTRM data in a mobile-optimized format
Exposing relevant eTRM data (such as current program eligible measure permutations/offerings/MPDs) to practitioners in the field such as program implementers and project developers in a format optimized for mobile use or use in third-party applications could facilitate uptake of deemed measures.
CA eTRM 3 months ago
User Interface (UI)
Feature Request
Allow MP submission without PA sponsor
Currently, measure must have a PA sponsor in order to be considered for the deemed measures library. This is an obstacle for new measures. Add a "Cal TF" option for the PA Lead field to allow Cal TF to develop and submit measures without a PA sponsor. An alternative is to make “PA Lead” field optional (i.e., new measure without PA lead). To ensure high quality standards are maintained, prevent measure developers from changing the status to "Submitted to CPUC" without going through "Cal TF Staff Review" and "Cal TF Affirmation" if measure does not have a PA Lead designation.
CA eTRM 3 months ago
Simplified UX
Feature Request
Allow MP submission without PA sponsor
Currently, measure must have a PA sponsor in order to be considered for the deemed measures library. This is an obstacle for new measures. Add a "Cal TF" option for the PA Lead field to allow Cal TF to develop and submit measures without a PA sponsor. An alternative is to make “PA Lead” field optional (i.e., new measure without PA lead). To ensure high quality standards are maintained, prevent measure developers from changing the status to "Submitted to CPUC" without going through "Cal TF Staff Review" and "Cal TF Affirmation" if measure does not have a PA Lead designation.
CA eTRM 3 months ago
Simplified UX
Feature Request
Completed
Unsync and remove "Load Shapes, Electric/Gas" CPUC Support Tables
Unsync and remove "Load Shapes, Electric/Gas" CPUC Support Tables
CA eTRM 3 months ago
Shared Data
Feature Request
Completed
Unsync and remove "Load Shapes, Electric/Gas" CPUC Support Tables
Unsync and remove "Load Shapes, Electric/Gas" CPUC Support Tables
CA eTRM 3 months ago
Shared Data
Feature Request