Public Comment Raw Data
File NameNote Link
Original Google Spreadsheet

It is linked to the Google Forms, which is used to collect public comments for the RPM Phase 1 Initial Report.

  • All public comments submitted via the Google Forms are automatically displayed. 
  • Public comments submitted via Word/PDF are manually inserted into this Google Spreadsheet so that they can be displayed publicly.
  • Email addresses of comment contributors are redacted for privacy. 
Staff's Master Spreadsheet

It serves as the foundation for staff to develop the Public Comment Review Tool (PCRT) below. 

  • The naming convention and categorization of comment contributors are clarified. 
  • Duplicate submissions and incomplete submissions are identified.
  • Calculations of responses to multiple-choice questions are done via excel formula. 
  • Email addresses of comment contributors are redacted for privacy. 
Public Comment Review Tool (PCRT) 
File NameNote Link
Recommendations & Questions: TMCH, Sunrise, TM Claims, TM-PDDRPSub Group A uses this tool to conduct the initial review/deliberation on all public comments for non-URS recommendations and community questions.https://docs.google.com/spreadsheets/d/1xMehg9o44bdz85ry0LJvhzoOaKdmJ6SwIrLneMx0Ixc/edit?usp=sharing
Recommendations & Questions: URSSub Group B uses this tool to conduct the initial review/deliberation on all public comments for URS recommendations and community questions.https://docs.google.com/spreadsheets/d/16p196gjSt1CCXnowlWeXl_BcaggiXpoxiRSKFv1Mg18/edit?usp=sharing
Individual Proposals: URS & TMCHFull WG uses this tool to conduct the initial review/deliberation on all public comments for individual proposals that did not rise to the level of WG recommendations.https://docs.google.com/spreadsheets/d/1QTt_m5qdzoalRDcIUED01ur-yJgODCex8bj_-aKO7fI/edit?usp=sharing
Overarching Questions & General CommentsFull WG uses this tool to conduct the initial review/deliberation on all public comments for overarching questions and the general content of the Initial Report. https://docs.google.com/spreadsheets/d/1wke2krmhV2tNPNhvIOskAlLVraWp-88mqzScCtj01fw/edit?usp=sharing
Public Comment Analysis Summary
File NameNote Link
Recommendations & Questions: TMCH, Sunrise, TM Claims, TM-PDDRPSummary of Sub Group A's deliberation on all public comments for non-URS recommendations and community questions, including specific public comments in the PCRT flagged to the full WG for further review. This document continuously records full WG's deliberation and determination. https://docs.google.com/document/d/10mftuhNy7YMgtCIu2ZRwsCleDgbP8AAAFz_jMHBFL70/edit?usp=sharing
Recommendations & Questions: URSSummary of Sub Group B's deliberation on all public comments for URS recommendations and community questions, including specific public comments in the PCRT flagged to the full WG for further review. This document continuously records full WG's deliberation and determination.https://docs.google.com/document/d/110It4ZZMV6V4XY77J6DUq-H_ZGtdPNV8qCB_5Ukd29E/edit?usp=sharing
Individual Proposals: URS & TMCHSummary of full WG's initial and final deliberation on all public comments for individual proposals.https://docs.google.com/document/d/1Pnqor6rHjvowH66GPQG9XI23n8H2mgkbf39-jA4KlFc/edit?usp=sharing
Overarching Questions & General CommentsSummary of full WG's deliberation on all public comments for overarching questions and the general content of the Initial Report. https://docs.google.com/document/d/1B7f4i96jwZ_MmAV2GuMhkr6VJLPCT55aNH9_xqeeX3E/edit?usp=sharing
  • No labels