{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Assignments","Incidents","LocalReports","Equipment Used","Other Info","Stats","Brief User Guide","FS Services","Loci","Parking","Weekend Type","Activities","Incident","Roles"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Assignments","index":0,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,10,6,10],[6,4,6,5],[0,0,3,1],[5,0,5,1],[1,4,2,4],[1,5,2,5],[1,2,2,2],[0,4,0,5]]}
["TERT Weekend Report",null,"picklist",null,"Enter all dates/times as: mm/dd/yyyy hh:mm\nUse 24 hour format: Enter 3:30pm as 15:30",null,"Version 6.6.6",null,null,null,"FS Service/Comment Memo Instructions"]
[null,null,"Weekend          Type",null,"Begin Date and Time","End Date and Time",null,null,null,null,"Multi-Select mode: The default mode is multi-select picklist (Edit Memo un-checked).  This mode allows seleting multiple items from the picklist, one at a time.  \nYou can remove an incorrect selection, by re-selecting the same phrase in the pick list. \n\nManual edit mode: You may manually free form enter text not related to FS Services. First check the Edit Memo box, then enter free form text.  Uncheck the Edit Memo, when done manually editing.  \nFS service phrases and ad-hoc free-form text can both be entered into the same memo. If mixed, the FS service phrases should be entered first, for clarity."]
[]
[null,null,null,null,null,null,null,{"$f":"(F4-E4)*24","v":0}]
[null,null,null,null,"mm/dd/yyyy",null,"nnn-nnn-nnnn"]
["Submitted by",null,null,"Date ",null,"Phone  "]
[null,null,"picklist","picklist","Include both dates and times"]
["Given Name","Surname","Activity/Site ","Role","Begin Date and Time","End Date and Time","Call Sign"," Hrs","Guest \n[n]","FS\nHrs","FS Service or Comments Memo",null,null,false]
[null,null,null,null,null,null,null,{"$f":"(F9-E9)*24","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FS Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hiker education"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Group size"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hiking Prep"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Trail directions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fire rings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Trash"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildflowers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Human waste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Trail cutting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dogs on leash"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Snow conditions"]

{"sheet":"Incidents","index":1,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,4,2,4],[1,5,2,5]]}
["Incidents ","Include time","picklist","memo"]
["Activity/Site ","Date and Time","Type"," Incident"]

{"sheet":"LocalReports","index":2,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Local Reports ","Include time","picklist",null,"Memo"]
["Activity/Site "," Date and Time","Type","Counts","Local Report"]

{"sheet":"Equipment Used","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,3,2,3],[1,4,2,4]]}
["Equipment  ","Picklist","memo"]
["Activity/Site ","Type","Equipment Used/Needed"]

{"sheet":"Other Info","index":4,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Other Info","Include time","Memo"]
["Activity/Site "," Date and Time","Other Information"]

{"sheet":"Stats","index":5,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[5,0,5,3],[5,6,7,7],[5,4,5,5]]}
["Incidents "]
["Medical Incidents","Team  Rescues","SAR Rescues","Helicopter Rescues","Other Imcidents","Total Incidents"]
[{"$f":"COUNTIF(Incidents!C3:C40,\"Medical\")","v":0},{"$f":"COUNTIF(Incidents!C3:C40,\"Rescue\")","v":0},{"$f":"COUNTIF(Incidents!C3:C40,\"SAR\")","v":0},{"$f":"COUNTIF(Incidents!C3:C40,\"Helicopter\")","v":0},{"$f":"COUNTIF(Incidents!C3:C40,\"Other\")","v":0},{"$f":"SUM(A3:E3)","v":0}]
[]
[]
["Volunteers",null,null,null,"Weekend",null,"Total hours from the time the first team member arrived on scene, until the last team member left at end of weekend."]
[" Hours","FS     Hours","Members","Guests","Hikers"," Hours on Mountain"]
[{"$f":"SUM(H9:H36,Assignments!H9:H23)","v":0},{"$f":"SUM(J9:J36,Assignments!J9:J23)","v":0},{"$f":"COUNTA(Assignments!A9:A23) - COUNTIF(Assignments!I9:I23,\">0\")","v":0},{"$f":"SUM(Assignments!I9:I23)","v":0},{"$f":"SUMIF(LocalReports!C3:C36,\"Hikers\",LocalReports!D3:D36)","v":0},{"$f":"Assignments!H4","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"Brief User Guide","index":6,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["TERT Weekend Report Excel User Guide"]
["Ver. 7/7/2017"]
["Overview"]
["This document is used to record group activities, rather than individual activities.  After each TERT weekend activity, or each TERT training or leadership meeting, the Excel Weekend Report document will be used to document participation.  "]
["Using the TERT Weekend Report Excel Document"]
["The Excel document consists of seven work sheets, Assignments, Incidents, Local Reports, Equipment Used, Other Info, Stats, and Brief User Guide.  Except for the Guide form, each sheet is formatted as a table.  Many of the columns in the tables use picklists to aid in standardizing the data.  The Assignments form, besides the table, also contain the header, which records general information about the weekend."]
["1)      Selecting Forms "]
["Each spreadsheet form is associated with a tab at the bottom of the Excel document.  Click on them to activate the desired form."]
["2)      Dates/Times"]
["Enter dates as “mm/dd/yyyy hh:mm”.  The single space between the date and time is important.  The colon between the hours and minutes is important.  Use 24H format, as in., 08:00 for 08:00am, 13:30 for 01:30pm, and 17:00 for 05:00pm, etc. Times are required on the Assignments form, except for the submitted date.  Use times in the other forms as you can, especially in the Incidents form."]
["3)      Adding Rows to Tables "]
["Each table defaults to one row when first opened.  To add a new row for the next table entry, press Tab in the last column.  This is the only way to add new rows to an Excel table.  Do not use the down arrow, as this will leave the table."]
["Pressing Tab will add a new row and bring the cursor to the first column in new row, ready for you to start the next entry.  When you are entering the last row to input, you do not need to press the Tab key when done."]
["1)      Drop Down Pick Lists"]
["Activity/Site, Role and Types are normal drop down pick lists.  FS Service or Comments memo column supports both a multiple selection picklist and free-form data entry.  The default mode for this memo column is as a pick list (Edit Mode un-checked)"]
["a)      This is a special pick list mode for selecting FS Services.  It allows you to select multiple phrases to place into the memo."]
["b)      Make your first selection, then follow that with any additional selections needed, one at a time.  The phrases will be inserted into the cell delimited by a comma and space."]
["c)      If you made an incorrect selection, you can remove it simply by re-selecting the same phrase in the pick list.  As you do, that phrase in the memo will be removed. This avoids the cumbersome task of removing it manually."]
["d)      If you need to enter text not related to FS Services, you may manually enter text into this field. To do so, first check the Edit Memo checkbox, located in the header.  Be sure to uncheck it, when done manually editing the memo."]
["Note: While the Edit Mode is checked, the FS picklist multiple selections feature is disabled."]
["e)      FS service phrases and ad-hoc free-form text can both be entered in the same memo.  If mixed, the FS service phrases should be entered first, for clarity."]
["2)      Memo Fields"]
["The last column in each table is a memo field, which can hold pages of text with word wrap.  You can form paragraphs by pressing Alt-Enter in a memo field twice, at the point where you want to start a new paragraph.. This will insert two line breaks into the text, which will insert a blank line to separate paragraphs."]
["3)      Shortcut for entering duplicate information"]
["If several people arrived at the same time, or left at the same time, you can copy the first date/time entered by highlighting the cell and pressing Ctrl-C.  Then drag the mouse from the first row to be copied to and highlight the column or columns and pressing Ctrl-V."]
["4)      Done"]
["When the document is completed, save it and rename it as:"]
["“TertReport yyyy mm dd-dd.xlsm”."]
["There is a single space between elements of the date, except between the day range. Then email it to wcstarks@gmail.com.  After it has been processed it will be emailed out to the team leaders."]

{"sheet":"FS Services","index":7,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Fires/rings"]
["FS info"]
["Group size"]
["Hiker ed"]
["Hiking prep"]
["Human waste"]
["Leave no trace"]
["Lost item"]
["Pets on leash"]
["Safety"]
["Snow Levels"]
["Trail conditions"]
["Trail cutting"]
["Trail routes"]
["Trash"]
["Water/Filter"]
["Weather"]
["Wilderness"]
["Wildflowers"]
["Wildlife"]

{"sheet":"Loci","index":8,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Communication"]
["Parking"]
["Hikers"]
["Snow Pack"]
["Trail Conditions"]
["Weather"]
["Other"]

{"sheet":"Parking","index":9,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Several"]
["1/4 Full"]
["1/3 Full"]
["1/2 Full"]
["2/3 Full"]
["3/4 Full"]
["Full"]
["Overflow"]

{"sheet":"Weekend Type","index":10,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Initial WkEnd"]
["Normal WkEnd"]
["Memorial Day"]
["Independence Day"]
["Pioneer Day"]
["Labor Day"]
["Final WkEnd"]
["Medical Training"]
["Mountain Training"]
["Pre-Season WkEnd"]
["Leader Meeting"]
["Year-end Debrief"]
["Maintenance "]
["Administrative"]
["Search & Rescue"]
["Incident Training"]
["Special Event"]

{"sheet":"Activities","index":11,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Administrative"]
["Aspen Grove TH"]
["Emerald Lake"]
["Forest Service"]
["High Camp"]
["Leaders Mtng"]
["Medical TR"]
["Mountain TR"]
["Pack Down"]
["Pack Up"]
["Recon"]
["Saddle"]
["SAR"]
["Service"]
["Special Event"]
["Stewart Falls"]
["Summit"]
["Switchbacks"]
["Timpooneke TH"]
["Yr-End Debrief"]
["10K Elevation"]

{"sheet":"Incident","index":12,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Medical"]
["Rescue"]
["SAR"]
["Helicopter"]
["Other"]

{"sheet":"Roles","index":13,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
["Administrator"]
["Climber"]
["Comm"]
["Database"]
["Instructor"]
["Leader"]
["Liaison FS"]
["Liaison SAR"]
["Liaison UCSO"]
["Medical"]
["Member"]
["Membership"]
["New Member"]
["Ranger"]
["Runner"]
["Service"]
["Support"]
["USCO"]
["Visitor"]