5,013
edits
BEECN Journaling System: Difference between revisions
From WikiNET
m
→1.) BEECN Master Tracker
| Line 235: | Line 235: | ||
=== 1.) BEECN Master Tracker === | === 1.) BEECN Master Tracker === | ||
The Master Tracker is the universal almanac of all BEECN resources since 2013: caches, radios, the UHF repeater, and the radio room. There is infrequent reason to change anything on this sheet; the need would emerge only if a new resource is added or the location of a resource changes. Many columns are locked because formulas govern the values in the cells and/or the data displayed is pulled from a different sheet. Any column not locked contains data that can be changed on this sheet. | '''Only PBEM staff working on the BEECN program should have access to this sheet.''' The Master Tracker is the universal almanac of all BEECN resources since 2013: caches, radios, the UHF repeater, and the radio room. There is infrequent reason to change anything on this sheet; the need would emerge only if a new resource is added or the location of a resource changes. Many columns are locked because formulas govern the values in the cells and/or the data displayed is pulled from a different sheet. Any column not locked contains data that can be changed on this sheet. | ||
There are 29 unhidden columns, so different sections are color coded for easier scanning and review. Moving from left to right: | There are 29 unhidden columns, so different sections are color coded for easier scanning and review. Moving from left to right: | ||
| Line 244: | Line 244: | ||
## '''Site: Hexad''' - Indicates Northwest, Northeast, Southeast, Southwest, or North Portland. If a cache site is east of 82nd Avenue, a PBEM staffer can also indicate "East" in addition to Southeast or Northeast. | ## '''Site: Hexad''' - Indicates Northwest, Northeast, Southeast, Southwest, or North Portland. If a cache site is east of 82nd Avenue, a PBEM staffer can also indicate "East" in addition to Southeast or Northeast. | ||
## '''Site: Location -''' The exact address of the parcel the BEECN site (not necessarily the cache) is located on. | ## '''Site: Location -''' The exact address of the parcel the BEECN site (not necessarily the cache) is located on. | ||
## '''Site: Location Property''' - The type of | ## '''Site: Location Property''' - The type of property owner (school, park, private, etc) associated with the BEECN site. This should only be applied to BEECN caches and ''not'' orange kits or other resources. | ||
# '''<big>Volunteer information (color coded light orange)</big>''' | # '''<big>Volunteer information (color coded light orange)</big>''' | ||
##'''Vol: Coordinator''' ''(locked)'' - Provides the name of the Coordinator for that BEECN crew. Vacancies appear highlighted in bright orange. This column pulls data from sheet "3.) BEECN Volunteers" and the individual cells cannot be changed. When volunteer records need updating, that should '''''ALWAYS''''' be done in the BEECN Volunteers Sheet. Formula is: ''=IFERROR(INDEX({VolSscontactX}, MATCH([*Vol: CoordID]@row, {VolTypeID}, 0), 1), "Vacant")'' | ##'''Vol: Coordinator''' ''(locked)'' - Provides the name of the Coordinator for that BEECN crew. Vacancies appear highlighted in bright orange. This column pulls data from sheet "3.) BEECN Volunteers" and the individual cells cannot be changed. When volunteer records need updating, that should '''''ALWAYS''''' be done in the BEECN Volunteers Sheet. Formula is: ''=IFERROR(INDEX({VolSscontactX}, MATCH([*Vol: CoordID]@row, {VolTypeID}, 0), 1), "Vacant")'' | ||
| Line 259: | Line 259: | ||
## '''Radio: Test Avg History''' ''(locked)'' - Average of all radio test scores for this resource on a scale from 0.00 to 5.00 for all time since the resource was added to the system (in almost all cases, that will be early 2013). This data is pulled from "2.) BEECN Journal". Formula is: ''=AVERAGEIF({BEECNassetX}, [Resource Name]@row, {JournalBeecnScores})'' | ## '''Radio: Test Avg History''' ''(locked)'' - Average of all radio test scores for this resource on a scale from 0.00 to 5.00 for all time since the resource was added to the system (in almost all cases, that will be early 2013). This data is pulled from "2.) BEECN Journal". Formula is: ''=AVERAGEIF({BEECNassetX}, [Resource Name]@row, {JournalBeecnScores})'' | ||
# '''<big>Cache data (color coded light yellow):</big>''' | # '''<big>Cache data (color coded light yellow):</big>''' | ||
## '''Cache: Deployment Status''' - This is a drop down with three possible choices: deployed, missing/stolen, or stored. Any status other than "deployed" will highlight in a darker yellow. | ##'''Cache: Deployment Status''' - This is a drop down with three possible choices: deployed, missing/stolen, or stored. Any status other than "deployed" will highlight in a darker yellow. | ||
## '''Cache: Last | ## '''Cache: Last Visual Check''' ''(locked)'' - This pulls the report date of the last time anyone reported a Visual Check of the cache. This data is pulled from "2.) BEECN Journal". Formula is: ''=MAX(COLLECT({InspDateX}, {BEECNassetX}, [Resource Name]@row, {JournalTypeX}, "Reporting a visual check"))'' | ||
## '''Cache: Last Inventory''' ''(locked)'' - This pulls the report date of the last time anyone reported an Inventory of the cache. This data is pulled from "2.) BEECN Journal". Formula is: ''=MAX(COLLECT({InspDateX}, {BEECNassetX}, [Resource Name]@row, {JournalTypeX}, "Reporting an inventory"))'' | |||
## '''Cache: Location''' - This is the location of the cache (not the BEECN site). | |||
## '''Cache: Location Property''' - The type of property owner where the cache is stored (school, park, private, etc). | |||
## '''Cache: Contact''' - The name (and title, if applicable) of the person who oversees the property where the cache is stored. | |||
## '''Cache: Contact Email''' - The email of the person who oversees the property where the cache is stored. | |||
## '''Cache: Contact Phone''' - The phone number of the person who oversees the property where the cache is stored. | |||
## '''Cache: Combination''' - The lock combination to the cache if a combination lock is applied. | |||
## '''Cache: Radio Serial Number''' - The serial number of the handheld UHF radio in the cache. The cell will highlight dark yellow if this data is still needed. | |||
# <big>'''Cache tickets and notes (color coded in light purple):'''</big> | |||
## '''Tickets: n=active''' - The number of currently active "trouble tickets" | |||
### | ### | ||
