PBEM CPT Data Catalog: Difference between revisions
From Portland NET Wiki
| Line 4: | Line 4: | ||
=== Count of Basic NET Classes === | === Count of Basic NET Classes === | ||
'''Type:''' Output, Measurement | '''Type:''' Output, Measurement | ||
'''Dashboard Locations:''' TBA | |||
'''Available date range:''' Q2 1994 - present | '''Available date range:''' Q2 1994 - present | ||
| Line 14: | Line 16: | ||
<pre> | <pre> | ||
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | =COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | ||
</pre> | </pre><hr> | ||
<hr> | |||
=== Count of Basic NET Graduates per Class === | === Count of Basic NET Graduates per Class === | ||
'''Type:''' Output, Measurement | '''Type:''' Output, Measurement | ||
'''Dashboard Locations:''' TBA | |||
'''Available date range:''' Q2 1994 - present | '''Available date range:''' Q2 1994 - present | ||
| Line 32: | Line 33: | ||
=SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | =SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | ||
</pre> | </pre> | ||
<hr> | <hr> | ||
=== Sum of Volunteer Hours Logged as Basic NET Training === | === Sum of Volunteer Hours Logged as Basic NET Training === | ||
'''Type:''' Output, Measurement | '''Type:''' Output, Measurement | ||
'''Dashboard Locations:''' TBA | |||
'''Available date range:''' Q1 2013 - present | '''Available date range:''' Q1 2013 - present | ||
| Line 55: | Line 58: | ||
'''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. | '''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''. | '''Update procedure:''' Added to datasheets manually from quarterly data pulls out of MIP: ''Hours by Activity''. <hr> | ||
<hr> | |||
== Hours Categories == | == Hours Categories == | ||
