5,013
edits
BEECN Journaling System: Difference between revisions
Jump to navigation
Jump to search
m
→Back-end of the BEECN Journaling System
| Line 270: | Line 270: | ||
## '''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. | ## '''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> | # <big>'''Cache tickets and notes (color coded in light purple):'''</big> | ||
## '''Tickets: n=active''' - The number of currently active "trouble tickets" | ##'''Tickets: n=active''' ''(locked)'' - The number of currently active "trouble tickets". This cell will turn dark purple if number of tickets is more than zero. This data is pulled from "4.) BEECN Trouble Tickets". Formula is: ''=COUNTIFS({TicketsCloseDateX}, ISBLANK(@cell), {TicketsResourceNameX}, [Resource Name]@row)'' | ||
## '''Tickets: n=history''' ''(locked) -'' The number of tickets issued on this resource for all time, including currently active ones. This data is pulled from "4.) BEECN Trouble Tickets". Formula is: ''=COUNTIF({TicketsResourceNameX}, [Resource Name]@row)'' | |||
## '''Resource Notes''' - Any special notes about this particular resource. | |||
### | ### | ||