PBEM CPT Data Catalog: Difference between revisions
From Portland NET Wiki
| 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 | ||
