{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INSTRUCTIONS","1) INDICATIVE DESCRIPTIONS","2) TRIGGER LIST","3) OUTPUT","4) PROJECTS","Dropdown values"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"INSTRUCTIONS","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,1,18,3],[20,1,20,3],[23,1,23,3],[19,1,19,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[15,1,15,3],[17,1,17,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[13,1,13,3],[16,1,16,3],[14,1,14,3]]}
[]
[null,"Last updated: 31-03-17"]
[]
[]
[]
[null,"BAT ROOST TRIGGER INDEX (TI) - SUMMER BAT ROOSTS"]
[null,"INTRODUCTION:\n"]
[null,"The bat roost trigger index is an excel-based tool which helps evaluate the suitability of structures and buildings to support summer bat roosts.  It can be used in preliminary roost assessments to augment professional judgement.  The tool allows numerical comparison of different buildings, and thus helps bat surveyors to maintain a consistent approach to their assessments across a range of structure or building types, characters and ages.  "]
[null,"The index is based on a list of 28 features which reflect: A) the location, habitat and environmental context of the structure or building (8 features); B) exterior features and characteristics of the structure or building (10 features); and C) interior features and characteristics of the structure or building, particularly those comprising, or within, the roof void (10 features).  "]
[null,"Each feature is sub-divided into three or four descriptive categories which summarise the feature ‘condition’, while indicative descriptions are provided which loosely define each category; these are used as a prompt to assign a numerical score (i.e. 1.0, 0.67, 0.33 or 0.2) to the feature.  The index uses indicative descriptions, rather than strict criteria, since the relationships are qualitative and rely on experience and generally accepted associations rather than on known numerical correlations.  "]
[null,"The tool is not an attempt to replace professional experience, but provides a systematic approach to PRAs, in order to introduce a higher level of objectivity into the decision-making process.  The index also provides a useful checklist of factors that influence roost selection, while ranking structures’ roost suitability along a numerical index, from 0 to 1."]
[null,"The index does not incorporate the specific habitat and roost requirements of all UK bat species, but does use features widely recognised to influence roost selection of multiple bat species more generally."]
[null,"The tool is a working prototype which requires extensive testing and critical appraisal.  You are very welcome to use the tool, and if you do so please consider providing feedback so as to help us improve the tool."]
[null,"INSTRUCTIONS:"]
[null,"YOU MAY NEED TO ENABLE EDITING AND ENABLE CONTENT IN YELLOW BAR ABOVE BEFORE COMMENCING"]
[null,"1)   The INDICATIVE DESCRIPTONS worksheet lists the 28 Trigger Index features and codes.\n\nEach feature has three or four descriptive categories, for example’ Good’, ‘Moderate’ or ‘Poor’, which reflect the ‘condition’ of the feature being assessed.  Each category has an associated indicative descriptive to help the surveyor choose the category which best reflects the feature.  The indicative descriptions are used as a guide and judgement is necessary to select the most appropriate score; as experience is gained, each person will develop his or her own idea of what constitutes each category, and thus use of the index will become more consistent.\n\nLastly, each category has a numerical value associated with it; this is what is chosen in the Trigger list on the next worksheet."]
[null,"2)   Work through the TRIGGER LIST Worksheet selecting the most appropriate TI value from the drop-down menu. Once all values have been populated the final geometric mean Trigger Index Score, between 0 and 1, can be read at the bottom (you will notice that this changes as you input or change values).  The associated ‘roost suitability’ class will also be shown at the bottom of the list, and is based upon the numerical ranges outlined in Table 1 below. \n\nOnce you are reasonably familiar with the indicative descriptions, you will be able to input all 28 values relatively quickly without referring back to the previous sheet.  As an aid to memory, the categories for each feature are provided to the left of the TI Value column.  As some features may not be applicable to the structure or building being assessed, it is not necessary to input all 28 values, one or more can be left blank (press delete); the metric will take this into account and only calculate a mean score from the number of values input. Note that if too many features are left out, this could skew the results.\n\nThe project name, code and survey date can be input below the trigger list, if desired, and will automatically populate the output worksheet (see below)."]
[null,"3)   The OUTPUT worksheet provides a summary of the assessment and will populate automatically as TI values are chosen.  This can be printed out, copied and pasted into a report and/or stored for future reference.\n\n4)   Once the Trigger List has been completed, press Ctrl & q to add the details to the PROJECTS tab.  Each row represents one project.  Once the row has been populated, a new project can be entered into the trigger list.  If details are entered incorrectly, the row can be deleted, revisions made and Ctrl & q pressed again.  As projects are entered into the Trigger List and finalised using Ctrl & q, they will accumulate in the Projects tab allowing comparison of TI scores across multiple structures."]
[null,"FEEDBACK:"]
[null,"As this tool is still under development, and needs comprehensive testing, it is important that we receive as much feedback as possible in order to revise and improve it.  Any comments or constructive criticism are welcome and will be treated anonymously. Please consider providing feedback by emailing:"]
[null,"nick.underhill-day@swiftecology.co.uk"]
[]
[]
[null,"TABLE 1: Bat roost trigger index scores, roost suitability class and BCT survey recommendations1"]
[null,"TI Score","Roost Suitability Class","BCT Survey Recommendations for presence/absence1"]
[null,"> 0.7","HIGH","Three separate survey visits. At least one dusk emergence and a separate dawn re-entry survey.  The third visit could be either dusk or dawn."]
[null,"0.6 - 0.7","MODERATE","Two separate survey visits. One dusk emergence and a separate dawn re-entry survey."]
[null,"0.5 - 0.6","LOW","One survey visit. One dusk emergence or dawn re-entry survey."]
[null," < 0.5","NEGLIGIBLE","No further surveys required.  Reasonable precautionary measures applicable."]
[null,"1 - Note that in practice the further survey requirement may sometimes vary from that stated here depending on specific circumstances"]

{"sheet":"1) INDICATIVE DESCRIPTIONS","index":1,"n_rows":99,"n_cols":6,"rows_kept":99,"cut":false,"hidden":false,"merged":[[4,1,4,5],[65,1,65,5],[47,2,49,2],[44,2,46,2],[47,1,49,1],[44,1,46,1],[38,2,40,2],[38,1,40,1],[41,1,43,1],[58,2,60,2],[61,2,64,2],[54,2,57,2],[54,1,57,1],[50,1,53,1],[50,2,53,2],[18,1,20,1],[96,1,98,1],[93,1,95,1],[96,2,98,2],[93,2,95,2],[90,2,92,2],[90,1,92,1],[87,2,89,2],[87,1,89,1],[15,2,17,2],[18,2,20,2],[21,2,24,2],[25,2,27,2],[28,2,30,2],[25,1,27,1],[28,1,30,1],[84,1,86,1],[84,2,86,2],[81,2,83,2],[77,2,80,2],[74,2,76,2],[58,1,60,1],[70,2,73,2],[31,1,31,5],[5,2,7,2],[8,2,11,2],[12,2,14,2],[12,1,14,1],[15,1,17,1],[5,1,7,1],[8,1,11,1],[21,1,24,1],[74,1,76,1],[77,1,80,1],[81,1,83,1],[35,1,37,1],[32,2,34,2],[35,2,37,2],[32,1,34,1],[70,1,73,1],[66,1,69,1],[66,2,69,2],[61,1,64,1],[41,2,43,2]]}
[]
[]
[null,"BAT ROOST TRIGGER INDEX (TI) - SUMMER BAT ROOSTS"]
[null,"CODE","FEATURE","CATEGORY","INDICATIVE DESCRIPTION","TI VALUE"]
[null,"A) LOCATION, HABITAT AND ENVIRONMENTAL CONTEXT OF STRUCTURE OR BUILDING"]
[null,"T1","General location","Rural","Countryside (including villages and edges of small towns) with wide variety of nearby semi-natural habitats",1]
[null,null,null,"Suburban or intensive farmland","Towns or edges/outskirts of cities, with plenty of gardens and/or parks and some semi-natural areas nearby, or locations within intensively managed farmland",0.67]
[null,null,null,"Dense urban","Highly urban environment (e.g. inner city or town centre environments) with low levels, poor quality or negligible green space nearby",0.33]
[null,"T2","Foraging opportunities in immediate vicinity (within 250 m)","Good","Immediate access to high quality, semi-natural habitat such as broadleaved or mixed woodland, wetland, rough grassland, large areas of scrub and tall ruderal, standing water (ponds, lakes) or river valley with abundant riparian vegetation",1]
[null,null,null,"Moderate","Immediate access to gardens, parks, areas of scrub/ruderal vegetation, running/standing water with some riparian vegetation, lines or stands of trees",0.67]
[null,null,null,"Poor","Limited semi-natural habitat available, such as  amenity grassland, improved/grazed grassland, suburban parks, species-poor hedgerows or young/coniferous trees, intensively managed farmland",0.33]
[null,null,null,"Very poor","No semi-natural habitat or features in immediate vicinity (e.g. densely built urban environment with no/little vegetation) - bats would have to fly elsewhere to get a meal",0.2]
[null,"T3","Foraging opportunities in wider landscape (within 5 km)","Good","Access to a diverse range of productive semi-natural habitats including broadleaved woodland, river corridors, ponds and lakes, wet/marshy grassland, wetlands, habitat mosaics)",1]
[null,null,null,"Moderate","Typically arable or pastoral farmland with small woodlands, watercourses and patches of semi-natural vegetation or networks of suburban gardens with wide variety of vegetation and clusters of ponds or with watercourses",0.67]
[null,null,null,"Poor","Poor opportunities for foraging within surrounding landscape (mostly urban or arable monoculture)",0.33]
[null,"T4","Commuting opportunities giving access to semi-natural habitat","Good","Connecting and continuous linear features, such as tall hedgerows, tree lines, woodland edges, vegetated watercourses, sunken lanes or tall walls, giving relatively unbroken access to potential foraging grounds",1]
[null,null,null,"Moderate","Connecting, linear features, perhaps lower quality or with discontinuities where short stretches of exposed ground may need to be traversed",0.67]
[null,null,null,"Poor","Few apparent connecting linear features nearby, very poor features (e.g. low walls or hedgerows) or linear features terminating within a short distance. Area between structure and nearest good foraging habitat generally open and exposed.",0.33]
[null,"T5","Cover in vicinity of structure/building","Good","Cover close (< 5m) to potential roost exits provided by trees, tall hedgerows or scrub, tall walls or other structures/buildings.",1]
[null,null,null,"Moderate","Suitable cover (as above) fairly close (5-20 m) to potential roost exit points (for horseshoe bats - unless cover is 'good', score as 'poor')",0.67]
[null,null,null,"Poor or none","Building exposed with little or no cover from trees, tall shrubs, walls, hedgerows or other buildings for 20 m or more",0.33]
[null,"T6","External lighting in vicinity of structure/building","None","No external lighting in vicinity of potential roost during hours of darkness, no artificial light in immediate surroundings. Good level of shading by trees nearby. Naturally dark, rural area.",1]
[null,null,null,"Low level","Artificial light in vicinity, with some light spill onto building, but potential roost exits remaining relatively dark.",0.67]
[null,null,null,"Moderate level","Artificial light in vicinity with some light spill onto potential roost areas/exit points.",0.33]
[null,null,null,"High level","Roof areas and/or potential roost exits lit up directly or with a high degree of light spill from near artificial lighting",0.2]
[null,"T7","Number and character of nearby structures/buildings","Good variety of older buildings or structures","Cluster of suitable buildings (e.g. old farm buildings, stately home and outbuildings) providing range of conditions for roosting, resting and flying bats.",1]
[null,null,null,"Mixture of old and new","Single older building (e.g. old barn), row/cluster of older residential dwellings (e.g. Victorian terrace, red brick buildings) or good mixture of old and new buildings.",0.67]
[null,null,null,"None or all modern","Single,  isolated modern building, no other buildings nearby, or row of modern residential dwellings (e.g. modern residential estate)",0.33]
[null,"T8","Structure/building exposure: altitude, elevation and orientation","Low","Building in lowland landscape (< 200m), well protected from prevailing weather (e.g. by  buildings, trees or in valley location) with little feeling of exposure to prevailing weather.",1]
[null,null,null,"Moderate","Building partially exposed (e.g. in flat rural landscape, on side of hill, facing prevailing winds). Or a building reasonably protected but at higher altitude (200-400 m).",0.67]
[null,null,null,"High","Building at higher altitude (>400 m), or on exposed hill, flat, treeless landscape, facing the prevailing weather facing with little protection from exposure.",0.33]
[null,"B) EXTERIOR FEATURES AND CHARACTERISTICS OF STRUCTURE OR BUILDING"]
[null,"T9","Structure/building age","Old","Older building - pre 1940.  Old brick, stone or timber construction.",1]
[null,null,null,"Intermediate","Intermediate - but no clear cut-off dates should be assumed.  Could depend upon type of construction. Could include old building with modern renovations. Judgement required. ",0.67]
[null,null,null,"Less than 50 years","Modern building - post 1960, typically brick, breezeblock, plastic, metal or modern timber construction.",0.33]
[null,"T10","Structure/building size and complexity","Large, complex structure","Large complex structure or building with multiple sections, heights and roofs. Likely to have multiple roof voids and/or spaces.",1]
[null,null,null,"Intermediate-sized structure","Intermediate structure, including typical residential dwellings or other buildings.  May have large roof void/space or several smaller roof voids/spaces.",0.67]
[null,null,null,"Small structure","Small structure, such as garage, shed, log store or other outbuilding, chicken coup or horse shelter.  Pitched or flat roof but generally small void or roof space.",0.33]
[null,"T11","Main wall construction material","Old","Mostly old stone (e.g. limestone, sandstone), hand-made brick or timber-framed.",1]
[null,null,null,"Mixture of materials","Mixture of old and new",0.67]
[null,null,null,"Modern","Modern brickwork/breezeblock/prefabricated steel/metal/plastic",0.33]
[null,"T12","Condition of wall and roof pointing/render or timbers (roost potential)","Noticeable crevices or cavities","Noticeable cracks, gaps or crevices in pointing providing access to unseen cavities (e.g. perhaps typical of poorly maintained old stone or brick farm buildings).  Good crevice opportunities in timber walled structure.",1]
[null,null,null,"Some gaps, cracks or crevices noted","Some evidence of cracks and crevices in pointing (note: gaps of 2.5 X 1.5 cm can accommodate crevice-dwelling bats).  Some potentially suitable crevices in timber walled structures.",0.67]
[null,null,null,"Tightly sealed","All pointing tightly sealed (usually modern buildings or those in good condition) or with shallow, open gaps only.  Timber cladding poorly overlapping with gaps too large or shallow.",0.33]
[null,"T13","Presence and condition of lintel and/or door frame features (roost potential)","Noticeable cracks or crevices","Numerous suitable cracks noted under lintels or around frames of windows and/or doorways",1]
[null,null,null,"Some gaps, cracks or crevices noted","Several potentially suitable gaps or cracks noted",0.67]
[null,null,null,"Tightly sealed","Tightly sealed lintels and doorways. No gaps, cracks or crevices noted.",0.33]
[null,"T14","Construction and condition of eaves/soffits/ bargeboards","Noticeable cracks or crevices","Open eaves or numerous gaps/cracks giving access to roof void or space behind boarding or within box eaves",1]
[null,null,null,"Some gaps, cracks or crevices noted","Several gaps or cracks noted but not extensive.",0.67]
[null,null,null,"Tightly sealed","Tightly sealed with no obvious gaps or cracks for access - eaves may appear completely sealed or only shallow or very small gaps noted",0.33]
[null,"T15","Presence and condition of weatherboarding, hanging tiles and/or cladding","Noticeable cracks or crevices","Noticeable gaps underneath boarding or cladding giving potential roosting opportunities",1]
[null,null,null,"Some gaps, cracks or crevices noted","Several small gaps or cracks noted",0.67]
[null,null,null,"Tightly sealed","Tightly sealed with no obvious gaps or cracks for access, or only shallow gaps.",0.33]
[null,null,null,"No boarding","No boarding/cladding",0.2]
[null,"T16","Presence and condition of lead flashing","Gaps or cavities clearly visible","Noticeable gaps , cracks or peeling lead flashing",1]
[null,null,null,"Some lifting of flashing","Several small gaps or cracks noted",0.67]
[null,null,null,"Flashing tightly sealed","Lead flashing appears tightly sealed with brickwork and/or tiling and in good condition",0.33]
[null,null,null,"No flashing","Lead or other flashing absent",0.2]
[null,"T17","Roofing material characteristics","Old style tiling","Pitched roof with pantile, clay, slate or other tiles",1]
[null,null,null,"Modern tiling or mixture","Tiles of more modern construction (e.g. interlocking concrete tiles, faux slate)",0.67]
[null,null,null,"Corrugated metal, asbestos or similar","Corrugated tin, asbestos, plastic, chipboard, 3-ply (may be felt covered) - roof often flat or with shallow pitch only",0.33]
[null,"T18","Bat access potential into structure/building","Numerous gaps or open-sided structure","Poorly maintained with old, warped, broken, slipped or missing tiles with various gaps giving potential access to spaces beneath.  Or open-sided structure, such as barn.",1]
[null,null,null,"Several small gaps","Tiles in reasonable condition, but with several gaps and cracks noted giving potential bat access into roof or spaces under tiling",0.67]
[null,null,null,"No gaps noted","Well-maintained/tightly sealed tiles with apparent limited access into roof (often modern concrete interlocking tiles, newer properties)",0.33]
[null,null,null,"Substantial holes or collapsed roof","Large section(s) of the roof have caved in leaving most of the building interior exposed to the weather. Typically derelict building with collapsed roof.",0.2]
[null,"C) INTERIOR FEATURES AND CHARACTERISTICS  OF STRUCTURE OR BUILDING"]
[null,"T19","Character of roof void/roof space","Large, multiple voids or intricate roof space","Large, multi-spaced or multi-sectioned roof void with variety of aspects and relatively uncluttered environment in which to fly about",1]
[null,null,null,"Typical single void or dark roof space","Reasonably-sized roof void, may be partially open but undisturbed, or relatively dark, open roof space in taller undisturbed building, such as a large timber-framed barn",0.67]
[null,null,null,"Small low void or open roof space","Small roof void with more modern 'cluttered' truss construction or partially open roof void with some disturbance",0.33]
[null,null,null,"No void or very limited roof space","Flat roof (e.g. typical garage), light, open void or no apparent roof void (e.g. loft already converted - but cannot rule out space between ceiling and lining/tiles)",0.2]
[null,"T20","Character and condition of roof timbers or supports","Noticeable crevices or gaps","Old, roughly-cut, roof timbers with suitable crevices/gaps where timber meets walling, chimney or at mortise joints (e.g. old farmhouse or barn). Usually older buildings.",1]
[null,null,null,"Some gaps or cracks noted","Timbers of any age with some crevices/gaps where timbers join or insert into walling, spaces behind rafters, or timbers with narrow angles (e.g. between rafters and ridge board)",0.67]
[null,null,null,"Tightly sealed modern timbers / supports","Modern, square-cut, treated timbers, tightly fitted, with no noticeable gaps where timbers join or meet walling.  No narrow angles at apex. Otherwise metal roof supports.",0.33]
[null,null,null,"No apparent supports or flat roof","Roof is flat or does not have any additional structural support likely to offer potential crevice roosting opportunities",0.2]
[null,"T21","Presence and extent of cobwebbing","Very few cobwebs","Timbers or sections of timbers noticeably free of cobwebs",1]
[null,null,null,"Some cobwebs","Some timbers or sections of timbers may be free of cobwebs",0.67]
[null,null,null,"Numerous cobwebs","Numerous cobwebs throughout roof void, particularly hanging in void.",0.33]
[null,"T22","Presence and condition of roof lining","Lined with various small gaps","Unlined roof or lined roof with tears/gaps providing access to bats",1]
[null,null,null,"Lined with few gaps or mixture of lined/unlined","Lined and very tightly sealed with no apparent access to roof void (BUT roost opportunities between tiles and lining).  May have lined and unlined areas of roof.",0.67]
[null,null,null,"Potential cavity, but access very limited","May be potential roosting opportunities between tightly sealed lining/boarding and roof exterior but access looks very limited to negligible.",0.33]
[null,null,null,"Unlined or cavity filled with insulation","No lining or cavity filled with insulation material",0.2]
[null,"T23","Light levels in roof void/roof space","Dark","Dark - requires torch to see features",1]
[null,null,null,"Intermediate","Intermediate or some areas light/others dark",0.67]
[null,null,null,"Light","Light ingress- can see features easily without torch",0.33]
[null,"T24","Protection from weather/wind","Well protected","Well protected from weather/wind",1]
[null,null,null,"Intermediate protection","Some areas may be exposed/draughty, other well protected",0.67]
[null,null,null,"Draughty and exposed","Exposed and draughty",0.33]
[null,"T25","Temperature regime","Variety of temperatures","Various aspects including south-facing, tiles may be slate or clay",1]
[null,null,null,"Intermediate","Intermediate - tiles clay or concrete",0.67]
[null,null,null,"Cold, north-facing or too hot","Cool/shaded/north-facing, or temperature too variable due to metal roofing",0.33]
[null,"T26","Level of (human, animal) disturbance of potential roost","Low","Negligible disturbance",1]
[null,null,null,"Moderate","May be some disturbance from noise, lighting but not frequent",0.67]
[null,null,null,"High","Frequent disturbance, including internal artificial lighting in roof space or frequent noise from machinery.",0.33]
[null,"T27","Flight Space (long-eared, Natterer's and horseshoe bats)","Good","Large open space with few cross struts etc. Suitable as flight space for long-eared, Natterer's and horseshoe bats.",1]
[null,null,null,"Moderate","Void is sub-optimal as flight space (e.g. void with many cross-struts, or very small space).",0.67]
[null,null,null,"Poor","Small and/or particularly cluttered roof void providing poor flight space",0.33]
[null,"T28","Flying Access (especially Horseshoe bats)","Good","Access for greater or lesser horseshoe bats",1]
[null,null,null,"Potential","Possible access for horseshoe bats",0.67]
[null,null,null,"None","No flying access for horseshoe bats",0.33]

{"sheet":"2) TRIGGER LIST","index":2,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"BAT ROOST TRIGGER INDEX (TI) - SUMMER BAT ROOSTS",null,null,"SELECT VALUES BELOW"]
[null,"CODE","FEATURE","CATEGORY","TI VALUE",null,"CATEGORY SELECTED"]
[null,"A) LOCATION, HABITAT AND ENVIRONMENTAL CONTEXT OF STRUCTURE"]
[null,"T1","General location","Rural / suburban or intensive farmland / dense urban",null,null,{"$f":"IF(E4=1,\"Rural\",IF((E4=0.67),\"Suburban or intensive farmland\",IF((E4=0.33),\"Dense urban\",)))","v":0}]
[null,"T2","Foraging opportunities in immediate vicinity (within 250 m)","Good / moderate / poor / very poor",null,null,{"$f":"IF(E5=1,\"Good\",IF((E5=0.67),\"Moderate\",IF((E5=0.33),\"Poor\",IF((E5=0.2),\"Very poor\"))))","v":false}]
[null,"T3","Foraging opportunities in wider landscape (within 5 km)","Good / moderate / poor",null,null,{"$f":"IF(E6=1,\"Good\",IF((E6=0.67),\"Moderate\",IF((E6=0.33),\"Poor\",)))","v":0}]
[null,"T4","Commuting opportunities giving access to semi-natural habitat","Good / moderate / poor",null,null,{"$f":"IF(E7=1,\"Good\",IF((E7=0.67),\"Moderate\",IF((E7=0.33),\"Poor\",)))","v":0}]
[null,"T5","Cover in vicinity of structure/building","Good / moderate / poor or none",null,null,{"$f":"IF(E8=1,\"Good\",IF((E8=0.67),\"Moderate\",IF((E8=0.33),\"Poor\",)))","v":0}]
[null,"T6","External lighting in vicinity of structure/building","None / low level / moderate level / high level",null,null,{"$f":"IF(E9=1,\"None\",IF((E9=0.67),\"Low level\",IF((E9=0.33),\"Moderate level\",IF((E9=0.2),\"High level\"))))","v":false}]
[null,"T7","Number and character of nearby structures/buildings","Good variety of older buildings or structures / mixture of old and new / none or all modern",null,null,{"$f":"IF(E10=1,\"Good variety of old buildings\",IF((E10=0.67),\"Mixture of old and new\",IF((E10=0.33),\"None or all modern\",)))","v":0}]
[null,"T8","Structure/building exposure: altitude, elevation and orientation","Low / moderate / high",null,null,{"$f":"IF(E11=1,\"Low\",IF((E11=0.67),\"Moderate\",IF((E11=0.33),\"High\",)))","v":0}]
[null,"B) EXTERIOR FEATURES AND CHARACTERISTICS OF STRUCTURE OR BUILDING"]
[null,"T9","Structure/building age","Old / intermediate / less than 50 years",null,null,{"$f":"IF(E13=1,\"Old\",IF((E13=0.67),\"Intermediate\",IF((E13=0.33),\"Less than 50 years\",)))","v":0}]
[null,"T10","Structure/building size and complexity","Large complex structure / intermediate size (e.g. typical house) / small size (e.g. garage, shed)",null,null,{"$f":"IF(E14=1,\"Large, complex structure\",IF((E14=0.67),\"Intermediate size\",IF((E14=0.33),\"Small size\",)))","v":0}]
[null,"T11","Main wall construction material","Old / mixture of materials / modern",null,null,{"$f":"IF(E15=1,\"Old\",IF((E15=0.67),\"Mixture of materials\",IF((E15=0.33),\"Modern\",)))","v":0}]
[null,"T12","Condition of wall and roof pointing/render or timbers","Noticeable crevices or cavities /some gaps, cracks or crevices noted /tightly sealed",null,null,{"$f":"IF(E16=1,\"Noticeable crevices or cavities\",IF((E16=0.67),\"Some gaps, cracks or crevices noted\",IF((E16=0.33),\"Tightly sealed\",)))","v":0}]
[null,"T13","Presence and condition of lintel and/or door frame features","Noticeable cracks or crevices / some gaps, cracks or crevices noted / tightly sealed",null,null,{"$f":"IF(E17=1,\"Noticeable cracks or crevices\",IF((E17=0.67),\"Some gaps,cracks or crevices noted\",IF((E17=0.33),\"Tightly sealed\",)))","v":0}]
[null,"T14","Construction and condition of eaves/soffits/bargeboards","Noticeable cracks or crevices / some gaps or cracks noted / tightly sealed",null,null,{"$f":"IF(E18=1,\"Noticeable cracks or crevices\",IF((E18=0.67),\"Some gaps or cracks noted\",IF((E18=0.33),\"Tightly sealed\",)))","v":0}]
[null,"T15","Presence and condition of weatherboarding/hanging tiles/cladding/etc.","Noticeable gaps and cavities / some gaps, cracks or crevices noted / tightly sealed / no boarding present",null,null,{"$f":"IF(E19=1,\"Noticeable gaps and cavities\",IF((E19=0.67),\"Some gaps, cracks or crevices noted\",IF((E19=0.33),\"Tightly sealed\",IF(E19=0.2,\"No boarding present\"))))","v":false}]
[null,"T16","Presence and condition of lead flashing","Gaps or cavities clearly visible / some lifting of flashing / flashing tightly sealed / no flashing",null,null,{"$f":"IF(E20=1,\"Gaps or cavities clearly visible\",IF((E20=0.67),\"Some lifting of flashing\",IF((E20=0.33),\"Flashing tightly sealed\",IF(E20=0.2,\"No flashing\"))))","v":false}]
[null,"T17","Roofing material characteristics","Old style tiling / modern tiling or mixture / corrugated metal, asbestos or similar",null,null,{"$f":"IF(E21=1,\"Older style tiling\",IF((E21=0.67),\"Modern tiling or mixture\",IF((E21=0.33),\"Corrugated metal/asbestos/similar\",)))","v":0}]
[null,"T18","Bat access potential into structure/building","Numerous gaps or open-sided structure / several small gaps / no gaps noted / substantial holes or collapsed roof",null,null,{"$f":"IF(E22=1,\"Numerous gaps or open-sided structure\",IF((E22=0.67),\"Several small gaps noted\",IF((E22=0.33),\"No gaps noted\",IF(E22=0.2,\"Substantial holes or collapsed roof\"))))","v":false}]
[null,"C) INTERIOR FEATURES AND CHARACTERISTICS OF STRUCTURE OR BUILDING"]
[null,"T19","Character of roof void/roof space","Large, multiple voids or intricate roof space / typical single void or dark roof space / small low void or open roof space / no void or very limited roof space",null,null,{"$f":"IF(E24=1,\"Large multiple voids or roof space\",IF((E24=0.67),\"Typical single void or dark roof space\",IF((E24=0.33),\"Small low void or open roof space\",IF(E24=0.2,\"No void or very limited roof space\"))))","v":false}]
[null,"T20","Character and condition of roof timbers or supports","Noticeable crevices or gaps / some gaps or cracks noted / tightly sealed modern timbers or metal supports / no apparent supports or flat roof",null,null,{"$f":"IF(E25=1,\"Noticeable crevices or gaps\",IF((E25=0.67),\"Some gaps or cracks noted\",IF((E25=0.33),\"Tightly sealed modern timbers/supports\",IF(E25=0.2,\"No apparent supports or flat roof\"))))","v":false}]
[null,"T21","Presence and extent of cobwebbing","Very few cobwebs / some cobwebs / numerous cobwebs",null,null,{"$f":"IF(E26=1,\"Very few cobwebs\",IF((E26=0.67),\"Some cobwebs\",IF((E26=0.33),\"Numerous cobwebs in roof space\",)))","v":0}]
[null,"T22","Presence and condition of roof lining","Lined with various small gaps / lined with few gaps or mixture of lined & unlined / potential cavity but very limited access / unlined or cavity filled with insulation",null,null,{"$f":"IF(E27=1,\"Lined with various small gaps\",IF((E27=0.67),\"Lined with few gaps or mixture\",IF((E27=0.33),\"Potential cavity but very limited access\",IF(E27=0.2,\"Unlined or cavity filled with insulation\"))))","v":false}]
[null,"T23","Light levels in roof void/roof space","Dark / intermediate / light",null,null,{"$f":"IF(E28=1,\"Dark\",IF((E28=0.67),\"Intermediate\",IF((E28=0.33),\"Light\",)))","v":0}]
[null,"T24","Protection from weather/wind","Well protected / intermediate protection / draughty and exposed",null,null,{"$f":"IF(E29=1,\"Well protected\",IF((E29=0.67),\"Intermediate protection\",IF((E29=0.33),\"Draughty and exposed\",)))","v":0}]
[null,"T25","Temperature regime","Variety of temperatures / intermediate / cold, north-facing or too hot (e.g. metal roof)",null,null,{"$f":"IF(E30=1,\"Variety of temperatures\",IF((E30=0.67),\"Intermediate\",IF((E30=0.33),\"Cold, north-facing or too hot\",)))","v":0}]
[null,"T26","Level of (human, animal) disturbance of potential roost","Low / moderate / high",null,null,{"$f":"IF(E31=1,\"Low\",IF((E31=0.67),\"Moderate\",IF((E31=0.33),\"High\",)))","v":0}]
[null,"T27","Flight Space (long-eared, Natterer's and horseshoe bats)","Good / moderate / poor",null,null,{"$f":"IF(E32=1,\"Good\",IF((E32=0.67),\"Moderate\",IF((E32=0.33),\"Poor\",)))","v":0}]
[null,"T28","Flying Access (Horseshoe bats)","Good / potential / none",null,null,{"$f":"IF(E33=1,\"Good\",IF((E33=0.67),\"Potential\",IF((E33=0.33),\"None\",)))","v":0}]
[]
[null,"PROJECT:",null,"TRIGGER INDEX SCORE =",{"$f":"GEOMEAN(E4:E11,E13:E22,E24:E33)","v":{"$error":"#NUM!"}}]
[null,"CODE:",null,"ROOST SUITABILITY =",{"$f":"IF(E35<0.5,\"NEGLIGIBLE\",IF((E35>0.5)*(E35<0.6),\"LOW\",IF((E35>0.6)*(E35<0.7),\"MODERATE\",IF(E35>0.7,\"HIGH\"))))","v":{"$error":"#NUM!"}}]
[null,"DATE:"]
[null,"EVIDENCE:",null,"ON COMPLETION OF THE SPREADSHEET, PRESS Ctrl & q TO POPULATE THE PROJECTS TAB"]
[null,"CONSTRAINTS:"]
[null,"SURVEYOR:"]

{"sheet":"3) OUTPUT","index":3,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,0,5,3],[0,0,0,3],[36,0,36,1],[37,0,37,1],[14,0,14,3],[25,0,25,3],[36,2,36,3],[37,2,37,3]]}
["BAT ROOST TRIGGER INDEX (TI): RESULTS"]
["Project:",{"$f":"'2) TRIGGER LIST'!C35","v":0},"Evidence:",{"$f":"'2) TRIGGER LIST'!C38","v":0}]
["Code:",{"$f":"'2) TRIGGER LIST'!C36","v":0},"Constraints:",{"$f":"'2) TRIGGER LIST'!C39","v":0}]
["Date:",{"$f":"'2) TRIGGER LIST'!C37","v":0},"Surveyor:",{"$f":"'2) TRIGGER LIST'!C40","v":0}]
["TRIGGER INDICES",null,"CATEGORY","TI VALUE"]
["A) Location, habitat and environmental context of structure"]
["T1:  General location",null,{"$f":"'2) TRIGGER LIST'!G4","v":0},{"$f":"'2) TRIGGER LIST'!E4","v":0}]
["T2:  Foraging opportunities within 250 m",null,{"$f":"'2) TRIGGER LIST'!G5","v":false},{"$f":"'2) TRIGGER LIST'!E5","v":0}]
["T3:  Foraging opportunities within 5 km",null,{"$f":"'2) TRIGGER LIST'!G6","v":0},{"$f":"'2) TRIGGER LIST'!E6","v":0}]
["T4:  Commuting opportunities",null,{"$f":"'2) TRIGGER LIST'!G7","v":0},{"$f":"'2) TRIGGER LIST'!E7","v":0}]
["T5:  Cover in vicinity of structure",null,{"$f":"'2) TRIGGER LIST'!G8","v":0},{"$f":"'2) TRIGGER LIST'!E8","v":0}]
["T6:  External lighting in vicinity of structure",null,{"$f":"'2) TRIGGER LIST'!G9","v":false},{"$f":"'2) TRIGGER LIST'!E9","v":0}]
["T7:  Number and character of nearby buildings",null,{"$f":"'2) TRIGGER LIST'!G10","v":0},{"$f":"'2) TRIGGER LIST'!E10","v":0}]
["T8:  Structure/building exposure",null,{"$f":"'2) TRIGGER LIST'!G11","v":0},{"$f":"'2) TRIGGER LIST'!E11","v":0}]
["B) Exterior features and characteristics of structure or building"]
["T9:  Structure/building age",null,{"$f":"'2) TRIGGER LIST'!G13","v":0},{"$f":"'2) TRIGGER LIST'!E13","v":0}]
["T10:  Size of Building",null,{"$f":"'2) TRIGGER LIST'!G14","v":0},{"$f":"'2) TRIGGER LIST'!E14","v":0}]
["T11:  Main wall construction material",null,{"$f":"'2) TRIGGER LIST'!G15","v":0},{"$f":"'2) TRIGGER LIST'!E15","v":0}]
["T12:  Condition of wall/roof pointing/render",null,{"$f":"'2) TRIGGER LIST'!G16","v":0},{"$f":"'2) TRIGGER LIST'!E16","v":0}]
["T13:  Condition of lintel/door frame features",null,{"$f":"'2) TRIGGER LIST'!G17","v":0},{"$f":"'2) TRIGGER LIST'!E17","v":0}]
["T14:  Condition of eaves/soffits/bargeboards",null,{"$f":"'2) TRIGGER LIST'!G18","v":0},{"$f":"'2) TRIGGER LIST'!E18","v":0}]
["T15:  Condition of weatherboarding/cladding",null,{"$f":"'2) TRIGGER LIST'!G19","v":false},{"$f":"'2) TRIGGER LIST'!E19","v":0}]
["T16:  Condition of lead flashing",null,{"$f":"'2) TRIGGER LIST'!G20","v":false},{"$f":"'2) TRIGGER LIST'!E20","v":0}]
["T17:  Roofing material",null,{"$f":"'2) TRIGGER LIST'!G21","v":0},{"$f":"'2) TRIGGER LIST'!E21","v":0}]
["T18:  Bat access potential",null,{"$f":"'2) TRIGGER LIST'!G22","v":false},{"$f":"'2) TRIGGER LIST'!E22","v":0}]
["C) Interior features and characteristics of structure or building"]
["T19:  Character of roof void/roof space",null,{"$f":"'2) TRIGGER LIST'!G24","v":false},{"$f":"'2) TRIGGER LIST'!E24","v":0}]
["T20:  Character and condition of roof supports",null,{"$f":"'2) TRIGGER LIST'!G25","v":false},{"$f":"'2) TRIGGER LIST'!E25","v":0}]
["T21:  Presence and extent of cobwebbing",null,{"$f":"'2) TRIGGER LIST'!G26","v":0},{"$f":"'2) TRIGGER LIST'!E26","v":0}]
["T22:  Presence and condition of roof lining",null,{"$f":"'2) TRIGGER LIST'!G27","v":false},{"$f":"'2) TRIGGER LIST'!E27","v":0}]
["T23:  Light levels in roof void/space",null,{"$f":"'2) TRIGGER LIST'!G28","v":0},{"$f":"'2) TRIGGER LIST'!E28","v":0}]
["T24:  Protection from weather/wind",null,{"$f":"'2) TRIGGER LIST'!G29","v":0},{"$f":"'2) TRIGGER LIST'!E29","v":0}]
["T25:  Temperature regime",null,{"$f":"'2) TRIGGER LIST'!G30","v":0},{"$f":"'2) TRIGGER LIST'!E30","v":0}]
["T26:  Level of (human, animal) disturbance",null,{"$f":"'2) TRIGGER LIST'!G31","v":0},{"$f":"'2) TRIGGER LIST'!E31","v":0}]
["T27:  Flight Space",null,{"$f":"'2) TRIGGER LIST'!G32","v":0},{"$f":"'2) TRIGGER LIST'!E32","v":0}]
["T28:  Flying Access (Horseshoe bats)",null,{"$f":"'2) TRIGGER LIST'!G33","v":0},{"$f":"'2) TRIGGER LIST'!E33","v":0}]
["TRIGGER INDEX SCORE =",null,{"$f":"'2) TRIGGER LIST'!E35","v":{"$error":"#NUM!"}}]
["BAT ROOST SUITABILITY =",null,{"$f":"'2) TRIGGER LIST'!E36","v":{"$error":"#NUM!"}}]

{"sheet":"4) PROJECTS","index":4,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["BAT ROOST TRIGGER INDEX (TI)"]
["PROJECT","CODE","DATE","TI SCORE","ROOST SUITABILITY","EVIDENCE FOUND DURING PRA","SURVEY LIMITATIONS","PRA RECOMMENDATIONS","EVIDENCE FOUND DURING ACTIVITY SURVEY OR SUPERVISED WORK"]

{"sheet":"Dropdown values","index":5,"n_rows":10,"n_cols":33,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["SI value","SI value 2","Evidence","Constraints",null,"T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","T13","T14","T15","T16","T17","T18","T19","T20","T21","T22","T23","T24","T25","T26","T27","T28"]
[1,1,"None","None",null,"Rural","Good","Good","Good","Good","None","Good variety of older buildings or structures","Low","Old","Large complex structure","Old","Noticeable crevices or cavities","Noticeable cracks or crevices","Noticeable cracks or crevices","Noticeable gaps and cavities","Gaps or cavities clearly visible","Old style tiling","Numerous gaps or open-sided structure ","Large, multiple voids or intricate roof space","Noticeable crevices or gaps","Very few cobwebs","Lined with various small gaps","Dark","Well protected","Variety of temperatures","Low","Good","Good"]
[0.67,0.67,"Droppings","Yes - not significant",null,"Suburban or intensive farmland","Moderate","Moderate","Moderate","Moderate","Low level","Mixture of old and new","Moderate","Intermediate","Intermediate structure","Mix of materials","Some gaps, cracks or crevices noted","Some gaps, cracks or crevices noted","Some gaps, cracks or crevices noted","Some gaps, cracks or crevices noted","Some lifting of flashing","Modern tiling or mixture","Several small gaps","Typical single void or dark roof space","Some gaps or cracks noted","Some cobwebs","Lined with few gaps or mixture of lined & unlined","Intermediate","Intermediate protection","Intermediate","Moderate","Moderate","Moderate"]
[0.33,0.33,"Live bat(s)","Yes - significant",null,"Dense urban","Poor","Poor","Poor","Poor or none","Moderate level","None or all modern","High","Less the 50 yrs","Small structure","Modern","Tightly sealed","Tightly sealed","Tightly sealed","Tightly sealed","Flashing tightly sealed","Corrugated metal, asbestos or similar","No gaps noted","Small low roof void or open roof space","Tightly sealed modern timbers or metal supports","Numerous cobwebs","Potential cavity but very limited access","Light","Draughty and exposed","Cold, north-facing or too hot","High","Poor","Poor"]
[0.2,0.2,"Dead bat(s)",null,null,null,"Very poor",null,null,null,"High level",null,null,null,null,null,null,null,null,"No boarding present","No flashing",null,"Substantial holes or collapsed roof","No void or very limited roof space","No apparent supports or flat roof",null,"Unlined or cavity filled with insulation"]
[null,null,"Urine spotting"]
[null,null,"Scratch marks"]
[null,null,"Staining"]
[null,null,"Prey remains"]
[null,null,"Multiple signs"]