PBEM CPT Data Catalog: Difference between revisions

From Portland NET Wiki
← Older editNewer edit →
VisualWikitext
Line 11: Line 11:
'''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.
'''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:
'''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:
<pre>
<pre>
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
Line 27: Line 27:
'''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.
'''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:
'''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:
<pre>
<pre>
=SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
=SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
</pre>
</pre>
'''Dashboard Locations:''' TBA
=== Sum of Volunteer Hours Logged as Basic NET Training ===
'''Type:''' Output, Measurement
'''Available date range:''' Q1 2013 - present
'''Description:''' This is the sum of all hours logged by volunteers in Basic NET Training activities. In quarterly data pulls, Basic NET Training activities may be labeled as:
{| class="wikitable mw-collapsible mw-collapsed"
|+
|Refresher training
|-
|Mandatory reporter for child and elder abuse
|-
|Independent study (associated with Basic NET Training)
|-
|Unit 8
|-
|Unit 9
|}
'''Source:''' Volunteers initially logged BNT hours when the Volgistics system was available starting in 2013, and continued when PBEM switched over to MyImpact. BNT hours are often underreported (particularly in earlier years) because new recruits are getting acclimated to using software they haven't used before.
'''Update procedure:''' Added to datasheets manually from quarterly data pulls out of MIP: ''Hours by Activity''.
'''Dashboard Locations:''' TBA
'''Dashboard Locations:''' TBA


== Hours Categories ==
== 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).
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 ===
=== Advanced NET Training/Exercises ===
Retrieved from "https://volunteerpdx.net/index.php/PBEM_CPT_Data_Catalog"