PBEM CPT Data Catalog - Revision history

Net@portlandoregon.gov: /* Sum of Volunteer Hours Logged as Basic NET Training */

2025-12-04T00:49:52Z

Sum of Volunteer Hours Logged as Basic NET Training

@@ Line 58: / 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.
-'''Update procedure:''' Added to datasheets manually from quarterly data pulls out of MIP: ''Hours by Activity''. <hr>
+'''Update procedure:''' Added to datasheets manually from quarterly data pulls out of MIP: ''Hours by Activity''. <hr>Inputs: Spent, broken out by grant/general fund + equity spend
 == Hours Categories ==

Net@portlandoregon.gov: /* WHAT do PBEM Volunteers Do? */

2025-12-04T00:06:58Z

WHAT do PBEM Volunteers Do?

← Older revision		Revision as of 17:06, 3 December 2025
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>

	~~'''Dashboard Locations:''' TBA~~
	<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>
	~~'''Dashboard Locations:''' TBA~~
	<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>

	~~'''Dashboard Locations:''' TBA~~
	<hr>

	== Hours Categories ==		== Hours Categories ==

Net@portlandoregon.gov: /* WHAT do PBEM Volunteers Do? */

2025-12-03T23:56:50Z

WHAT do PBEM Volunteers Do?

← Older revision		Revision as of 16:56, 3 December 2025
Line 17:		Line 17:

	'''Dashboard Locations:''' TBA		'''Dashboard Locations:''' TBA
			<hr>

	=== Count of Basic NET Graduates per Class ===		=== Count of Basic NET Graduates per Class ===
Line 32:		Line 33:
	</pre>		</pre>
	'''Dashboard Locations:''' TBA		'''Dashboard Locations:''' TBA
			<hr>

	=== Sum of Volunteer Hours Logged as Basic NET Training ===		=== Sum of Volunteer Hours Logged as Basic NET Training ===
Line 56:		Line 58:

	'''Dashboard Locations:''' TBA		'''Dashboard Locations:''' TBA
			<hr>

	== Hours Categories ==		== Hours Categories ==

Net@portlandoregon.gov: /* WHAT do PBEM Volunteers Do? */

2025-12-03T07:12:42Z

WHAT do PBEM Volunteers Do?

@@ 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.
-'''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>
 =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.
-'''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>
 =SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
 </pre>
 '''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).
 === Advanced NET Training/Exercises ===

Net@portlandoregon.gov: /* Count of Basic NET Graduates per Class */

2025-12-03T06:58:42Z

Count of Basic NET Graduates per Class

← Older revision		Revision as of 23:58, 2 December 2025
Line 28:		Line 28:

	'''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>
			=SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
			</pre>
	'''Dashboard Locations:''' TBA		'''Dashboard Locations:''' TBA

Net@portlandoregon.gov: /* WHAT do PBEM Volunteers Do? */

2025-12-03T06:58:08Z

WHAT do PBEM Volunteers Do?

← Older revision		Revision as of 23:58, 2 December 2025
Line 2:		Line 2:
	== WHAT do PBEM Volunteers Do? ==		== WHAT do PBEM Volunteers Do? ==

	=== ~~Number~~ of Basic NET Classes ===		=== 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

Net@portlandoregon.gov: /* Number of Basic NET Classes */

2025-12-03T06:54:01Z

Number of Basic NET Classes

← Older revision		Revision as of 23:54, 2 December 2025
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.		'''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>
			=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
			</pre>

	'''Dashboard Locations:''' TBA		'''Dashboard Locations:''' TBA

Net@portlandoregon.gov: /* Number of Basic NET Classes */

2025-12-03T06:53:12Z

Number of Basic NET Classes

← Older revision		Revision as of 23:53, 2 December 2025
Line 10:		Line 10:

	'''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.

			'''Dashboard Locations:''' TBA

	== Hours Categories ==		== Hours Categories ==

Net@portlandoregon.gov: /* Hours Categories */

2025-12-03T06:48:08Z

Hours Categories

← Older revision		Revision as of 23:48, 2 December 2025
Line 1:		Line 1:

			== WHAT do PBEM Volunteers Do? ==

			=== Number 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 [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER] and viewable as a filter.

	== Hours Categories ==		== Hours Categories ==

Net@portlandoregon.gov: Created page with " == 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 === *..."

2025-11-27T19:26:26Z

Created page with " == 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 === *..."

New page

== 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.