PBEM CPT Data Catalog: Difference between revisions
| Line 2: | Line 2: | ||
== WHAT do PBEM Volunteers Do? == | == WHAT do PBEM Volunteers Do? == | ||
=== | === Count of Basic NET Classes === | ||
'''Type:''' Output, Measurement | '''Type:''' Output, Measurement | ||
| Line 15: | Line 15: | ||
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | =COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | ||
</pre> | </pre> | ||
'''Dashboard Locations:''' TBA | |||
=== Count of Basic NET Graduates per Class === | |||
'''Type:''' Output, Measurement | |||
'''Available date range:''' Q2 1994 - present | |||
'''Description:''' This is a count of the number of volunteers who graduate from each Basic NET class; it does not include the volunteers in the class who did not graduate. | |||
'''Source:''' The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER] and viewable as a filter. | |||
'''Update Procedure:''' Every time a Basic NET class is completed, it should be inputted to [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER]. That should prompt datasheets and dashboards to update automatically. The SmartSheet formula governing data retrieval on the datasheets is: | |||
'''Dashboard Locations:''' TBA | '''Dashboard Locations:''' TBA | ||
Revision as of 22:58, 2 December 2025
WHAT do PBEM Volunteers Do?
Count of Basic NET Classes
Type: Output, Measurement
Available date range: Q2 1994 - present
Description: This is a count of each Basic NET class completed.
Source: The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on PBEM CPT Activities/B.) Training TRACKER and viewable as a filter.
Update Procedure: Every time a Basic NET class is completed, it should be inputted to PBEM CPT Activities/B.) Training TRACKER. That should prompt datasheets and dashboards to update automatically. The SmartSheet formula governing data retrieval on the datasheets is:
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
Dashboard Locations: TBA
Count of Basic NET Graduates per Class
Type: Output, Measurement
Available date range: Q2 1994 - present
Description: This is a count of the number of volunteers who graduate from each Basic NET class; it does not include the volunteers in the class who did not graduate.
Source: The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on PBEM CPT Activities/B.) Training TRACKER and viewable as a filter.
Update Procedure: Every time a Basic NET class is completed, it should be inputted to PBEM CPT Activities/B.) Training TRACKER. That should prompt datasheets and dashboards to update automatically. The SmartSheet formula governing data retrieval on the datasheets is:
Dashboard Locations: TBA
Hours Categories
These are hours reports that come from MIP. The reports are taken quarterly and reflect when a volunteer reports, not necessarily when the activity took place (which is why, for example, you might see BNT hours logged in a quarter where there was no Basic NET class).
Basic NET Training
- Refresher training
- Mandatory Reporter for Child and Elder Abuse
- Independent Study
- Unit 9
- Unit 8
Advanced NET Training/Exercises
- Zoom trainings/lectures
- Conferences
- Basic BEECN training (basic training for a VSF is advanced training)
- Serving as a survivor actor
Deployment Hours/Program Service
Basic criteria: hours logged by NETs that are paraprofessional activities.
- NET Meetings
- Event planning meetings (e.g. CDE or NETcamp planning meetings)
- Moulage
- TSA K-9 Decoy
- Clearing storm drains
- Instruction
- BEECN or radio maintenance
- Friends of Portland NET activities
- Wiki work
- Team Leader responsibilities
- Anniversary parties
Community Engagement
Hours logged only for public facing events, including trainings for community groups.