{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Formulas","Search Timeline","Response Urgency","Area","Mattson Form","Overall Cumulative POS","Coverage-Effort-Area Swept-POD","Total Effort (L) in KM","AMDR","Effort, Z, C","Planning Sweep Search","POD Graph","POD Table"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"POD Graph","index":11,"reason":"not_a_worksheet"}],"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":"Formulas","index":0,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["A","Area",null,"km2","POA","Probability of Area","%"]
["C","Coverage",null,"ratio","Pden","Probability Density","% / km2"]
["S","Track Spacing",null,"m","POD","Probability of Detection","%"]
["T","Time Spent Searching",null,"hours","PSR","Probable Success Rate","POS / Searcher Hour"]
["V","Velocity (Speed of Search)",null,"km / h","POS","Probability of Success","%"]
["W","Effective Sweep Width (AMDR)",null,"m","POScum","Cumulative POS","%"]
["Z","Area Effectively Swept",null,"km2","OPOScum","Overall Cumulative POS","%"]
["L","Effort",null,"km","AMDR","Average Maximum Detection Range","m"]
[]
["Theoretical Search Area"]
["r = Subject Travel Speed x Elapsed Time"]
["Theoretical Search Area = πr2"]
[]
["Segment POA"]
["Segment POA = (Segment Area / Region Area) x Region POA"]
[]
["Probability Density"]
["Pden = POA / A"]
[]
["Effort (L)"]
["L = V x T"]
["L = V x T x # of Searchers",null,"If all team members moved at about the same speed for the same amount of time."]
["L = (A x 1000) x S",null,"For a rectangular segment with straight, parallel, evenly spaced tracks."]
["L = (Z x 1000) / W"]
[]
["Area Effectively Swept (Z)"]
["Z = (W x L) / 1000"]
["Z = C x A"]
[]
["Coverage (C) "]
["C = Z / A"]
["C = W / S",null,"For a rectangular segment with straight, parallel, evenly spaced tracks."]
[]
["Track Spacing (S)"]
["S = W / C"]
[]
["Probable Success Rate (PSR)"]
["PSR = (Pden x V x W) x 1000"]
[]
["Searcher Hours"]
["Searcher Hours = L / V"]
[]
["Number of Searchers Required"]
["Searchers = Searcher Hours / T"]
["Searchers = L / (T x V)"]
[]
["Hours"]
["Hours = Searcher Hours / Searchers"]
["Hours = L / (Searchers x V)"]
[]
["Adjusting POA"]
["POAnew = POAold x (1 - POD)"]
[]
["Probability of Success (POS)"]
["POS = POA x POD"]
[]
["Cumulative Probability of Success (POScum)"]
["POScum = Sum of all POS for all searches of one segments"]
[]
["Overall Cumulative Probability of Success (OPOScum)"]
["OPOScum = Sum of all POS for all searches of all segments"]

{"sheet":"Search Timeline","index":1,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Receive Initial Notification  ","Gather and Evaluate Initial Information","Proceed with Initial Actions","Dispatch Initial Response Teams","Compile Incident Action Plan","Plan a SEARCH  OR  Plan a RESCUE","Execute Plan","Plan for Next Operational Period","SEARCH or RESCUE Ends or is Suspended","Manage Demobilization","Submit Task Paperwork","   Conduct/Participate in a Review"]
[]
[null,null," Continue Risk Assessment"]
[null,null," Continue Investigation "]

{"sheet":"Response Urgency","index":2,"n_rows":33,"n_cols":29,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,0,27,1],[29,0,29,1],[30,0,30,1]]}
["Response Urgency"]
["Subject Age"]
[null,{"$f":"IF(A3=\"\",0,(VLOOKUP(A3,AB3:AC5,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Very Young",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Very Old Other",1]
["Subject Medical Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",2]
[null,{"$f":"IF(A6=\"\",0,(VLOOKUP(A6,AB7:AC9,2,FALSE)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Known or supsected injury, ill or mental illness",1]
["Number of Subjects",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Healthy",3]
[null,{"$f":"IF(A9=\"\",0,(VLOOKUP(A9,AB11:AC13,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Known Fatatily",3]
[]
["Subject Experience Profile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One alone",1]
[null,{"$f":"IF(A12=\"\",0,(VLOOKUP(A12,AB15:AC18,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"More than one (very young, very old)",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"More than one (unless separation suspected)",2]
["Weather Profile"]
[null,{"$f":"IF(A15=\"\",0,(VLOOKUP(A15,AB20:AC23,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Experienced, does not know area",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Experienced, knows area",1]
["Equipment Profile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experienced, not familiar with area",2]
[null,{"$f":"IF(A18=\"\",0,(VLOOKUP(A18,AB25:AC27,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experienced, knows area",3]
[]
["Terrain/Hazards Profile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Past and/or existing hazardsous weather",1]
[null,{"$f":"IF(A21=\"\",0,(VLOOKUP(A21,AB29:AC30,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predicted hazardous weather (8hrs or less)",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predicted hazardous weather (more than 8 hrs)",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No hazardous weather predicted",3]
["Consider Elapsed Time in Response Determination"]
["Factor Total",{"$f":"SUM(B2:B20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inadequate for environment and weather",1]
["Response Decision",{"$f":"#VALUE!","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questionable for environment and weather",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adequate for environment and weather",3]
["If any of the factors rate as a 1 regardless of totals, the search requires the highest urgency. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Known hazardous terrain or other hazard",1]
["Response Decision",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Few or no hazards",2]
["8 10 12 14 16 20"]
["Hightest","Lowest"]
["Urgency","Urgency"]

{"sheet":"Area","index":3,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["THEORETICAL SEARCH AREA - Circular"]
["Determine from Travel Time and Speed",null,null,null,null,"Determine from Radius"]
["Elapsed time:",null,"hrs",null,null,"Radius:",null,"km"]
["Travel Speed:",null,"km/h",null,null,"Theoretical Search Area:",{"$f":"3.14*G3*G3","v":0},"km2"]
[]
["Range:",{"$f":"B3*B4","v":0},"km"]
["Theoretical Search Area:",{"$f":"3.14*B6*B6","v":0},"km2"]
[]
["AREA ESTIMATOR","Use with Area Estimator overlay"]
["Number of Dots:"]
["Area for Map Scale:"]
["1:20,000",{"$f":"B10*0.018","v":0},"km2",null,null,"1:24,000",{"$f":"B10*0.0259","v":0},"km2"]
["1:50,000",{"$f":"B10*0.1124","v":0},"km2",null,null,"1:25,000",{"$f":"B10*0.0281","v":0},"km2"]
["1:100,000",{"$f":"B10*0.4497","v":0},"km2",null,null,"1:62,500",{"$f":"B10*0.1756","v":0},"km2"]
[]
["AREA OF A TRIANGLE"]
["Length Side 1"]
["Length Side 2"]
["Length Side 3"]
["Area:",{"$f":"SQRT(((B17+B18+B19)/2)*(((B17+B18+B19)/2)-B17)*(((B17+B18+B19)/2)-B18)*(((B17+B18+B19)/2)-B19))","v":0}]

{"sheet":"Mattson Form","index":4,"n_rows":14,"n_cols":28,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["SIMPLIFIED, MODIFIED "]
["MATTSON CONSENSUS FORM",null,null,"Used to Determine POA Through Consensus"]
["LIKELIHOOD:","Very Unlikely 1","In Between 2","Unlikely          3","In Between   4","Even Chance 5","In Between 6","Likely            7","In Between 8","Very Likely   9"]
[]
["               REGION           NAME","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL"]
["SUBTOTALS",{"$f":"SUM(B6:B10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B11:M11)","v":0}]
["Consensus POA %",{"$f":"IF($AB$11=0,0,(B11/$AB$11*100))","v":0},{"$f":"IF($AB$11=0,0,(C11/$AB$11*100))","v":0},{"$f":"IF($AB$11=0,0,(D11/$AB$11*100))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["AREA"]
["Pden",{"$f":"IF(B13=0,0,(B12/B13/100))","v":0},{"$f":"IF(C13=0,0,(C12/C13/100))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Overall Cumulative POS","index":5,"n_rows":19,"n_cols":29,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Overall Cumulative POS "]
["Enter values for Coverage for each Region/Segment"]
["REGION OR SEGMENT","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","POScum"]
["INITIAL POA (Decimal value)",{"$f":"('Mattson Form'!B12/100)","v":0},{"$f":"('Mattson Form'!C12/100)","v":0},{"$f":"('Mattson Form'!D12/100)","v":0},{"$f":"('Mattson Form'!E12/100)","v":0},{"$f":"('Mattson Form'!F12/100)","v":0},{"$f":"('Mattson Form'!G12/100)","v":0},{"$f":"('Mattson Form'!H12/100)","v":0},{"$f":"('Mattson Form'!I12/100)","v":0},{"$f":"('Mattson Form'!J12/100)","v":0},{"$f":"('Mattson Form'!K12/100)","v":0},{"$f":"('Mattson Form'!L12/100)","v":0},{"$f":"('Mattson Form'!M12/100)","v":0},{"$f":"('Mattson Form'!N12/100)","v":0},{"$f":"('Mattson Form'!O12/100)","v":0},{"$f":"('Mattson Form'!P12/100)","v":0},{"$f":"('Mattson Form'!Q12/100)","v":0},{"$f":"('Mattson Form'!R12/100)","v":0},{"$f":"('Mattson Form'!S12/100)","v":0},{"$f":"('Mattson Form'!T12/100)","v":0},{"$f":"('Mattson Form'!U12/100)","v":0},{"$f":"('Mattson Form'!V12/100)","v":0},{"$f":"('Mattson Form'!W12/100)","v":0},{"$f":"('Mattson Form'!X12/100)","v":0},{"$f":"('Mattson Form'!Y12/100)","v":0},{"$f":"('Mattson Form'!Z12/100)","v":0},{"$f":"('Mattson Form'!AA12/100)","v":0},{"$f":"SUM(B4:AA4)","v":0}]
["COVERAGE FOR 1st SEARCH"]
["1st SEARCH POD",{"$f":"(1-EXP((-1)*B5))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["ADJUSTED POA AFTER 1st SEARCH ",{"$f":"B4*(1-B6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B7:AA7)","v":0}]
["POS AFTER 1st SEARCH ",{"$f":"B4-B7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B8:AA8)","v":0}]
["COVERAGE FOR 2nd SEARCH"]
["2nd SEARCH POD",{"$f":"(1-EXP((-1)*B9))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["ADJUSTED POA AFTER 2nd SEARCH ",{"$f":"B7*(1-B10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B11:AA11)","v":0}]
["POS AFTER 2nd SEARCH ",{"$f":"B7-B11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B12:AA12)","v":0}]
["COVERAGE FOR 3rd SEARCH"]
["3rd SEARCH POD",{"$f":"(1-EXP((-1)*B13))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["ADJUSTED POA AFTER 3rd SEARCH ",{"$f":"B11*(1-B14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B15:AA15)","v":0}]
["POS AFTER 3rd SEARCH ",{"$f":"B11-B15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B16:AA16)","v":0}]
["OVERALL CUMULATIVE POS  -->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB8+AB12+AB16","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHECK:",{"$f":"AB17+AB15","v":0},"Should =1 with data entered."]

{"sheet":"Coverage-Effort-Area Swept-POD","index":6,"n_rows":62,"n_cols":35,"rows_kept":62,"cut":false,"hidden":false,"merged":[[60,6,60,7],[61,6,61,7],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[4,2,4,3],[4,4,4,5],[4,6,4,7],[35,4,35,5],[35,2,35,3],[53,6,53,7],[54,6,54,7],[49,6,49,7],[50,6,50,7],[21,9,21,10],[22,9,22,10],[23,9,23,10],[42,6,42,7],[51,6,51,7],[38,6,38,7],[52,6,52,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[47,6,47,7],[48,6,48,7],[24,9,24,10],[35,6,35,7],[36,6,36,7],[37,6,37,7],[35,9,35,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[20,9,20,10],[35,11,35,12],[35,13,35,14],[11,9,11,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[4,11,4,12],[9,9,9,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[19,9,19,10],[4,21,4,22],[4,25,4,26],[4,28,4,29],[10,25,10,26],[4,23,4,24],[9,21,9,22],[9,23,9,24],[4,13,4,14],[10,9,10,10],[15,9,15,10],[4,30,4,31],[4,32,4,33],[5,28,5,29],[9,25,9,26],[9,28,9,29],[9,30,9,31],[9,32,9,33]]}
[null,"Assuming straight, parallel, evenly spaced tracks (any shaped segment).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assuming straight, parallel, evenly spaced tracks (any shaped segment)."]
[]
[null,"For a desired Track Spacing, what Coverage will I get?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For a given area and a desired Track Spacing, what Coverage will I get?"]
[]
[null,"Segment","Segment Area [A]",null,"AMDR\n[W]",null,"Desired Track Spacing\n[S]",null,null,"Coverage\n[C]",null,"Effort\n[L]",null,"Area Effectively Swept\n[Z]",null,"POD","POS",null,null,null,"Segment","Segment Area [A]",null,"AMDR\n[W]",null,"Desired Track Spacing\n[S]",null,null,"Coverage\n[C]",null,"Effort\n[L]",null,"Area Effectively Swept\n[Z]",null,"POD"]
[null,"A",{"$f":"'Mattson Form'!B13","v":0},"km2",null,"m",null,"m",null,{"$f":"IF(E6=0,0,(E6/G6))","v":0},null,{"$f":"IF(G6=0,0,((C6*1000)/G6))","v":0},"km",{"$f":"IF($C$6=0,0,(C6*J6))","v":0},"km2",{"$f":"VLOOKUP(J6,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!B$12*'Coverage-Effort-Area Swept-POD'!P6/100","v":0},null,null,null,"A",null,"m",null,"m",null,"m",null,{"$f":"IF($X$6=0,0,(X6/Z6))","v":0},null,{"$f":"IF($V$6=0,0,((V6*1000)/Z6))","v":0},"km",{"$f":"V6*AC6","v":0},"km2",{"$f":"VLOOKUP(AC6,'POD Table'!A2:B42,2,TRUE)","v":0}]
[null,"B",{"$f":"'Mattson Form'!C13","v":0},"km2",null,"m",null,"m",null,{"$f":"IF(E7=0,0,(E7/G7))","v":0},null,{"$f":"IF(G7=0,0,((C7*1000)/G7))","v":0},"km",{"$f":"C7*J7","v":0},"km2",{"$f":"VLOOKUP(J7,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!C$12*'Coverage-Effort-Area Swept-POD'!P7/100","v":0}]
[null,"C",{"$f":"'Mattson Form'!D13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J8,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!D$12*'Coverage-Effort-Area Swept-POD'!P8/100","v":0},null,null,null,"For a given area  and a desired Coverage, what Track Spacing do I need?"]
[null,"D",{"$f":"'Mattson Form'!E13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J9,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!E$12*'Coverage-Effort-Area Swept-POD'!P9/100","v":0}]
[null,"E",{"$f":"'Mattson Form'!F13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J10,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!F$12*'Coverage-Effort-Area Swept-POD'!P10/100","v":0},null,null,null,"Segment","Segment Area [A]",null,"AMDR\n[W]",null,"Desired Coverage\n[C]",null,null,"Track Spacing\n[S]",null,"Effort\n[L]",null,"Area Effectively Swept\n[Z]",null,"POD"]
[null,"F",{"$f":"'Mattson Form'!G13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J11,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!G$12*'Coverage-Effort-Area Swept-POD'!P11/100","v":0},null,null,null,"A",null,21,null,"m",null,null,null,{"$f":"IF($X$11=0,0,(X11/Z11))","v":0},"m",{"$f":"IF($G$11=0,0,((AG11*1000)/X11))","v":0},"km",{"$f":"V11*Z11","v":0},"km2",{"$f":"VLOOKUP(Z11,'POD Table'!A2:B42,2,TRUE)","v":0}]
[null,"G",{"$f":"'Mattson Form'!H13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J12,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!H$12*'Coverage-Effort-Area Swept-POD'!P12/100","v":0}]
[null,"H",{"$f":"'Mattson Form'!I13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J13,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!I$12*'Coverage-Effort-Area Swept-POD'!P13/100","v":0}]
[null,"I",{"$f":"'Mattson Form'!J13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J14,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!J$12*'Coverage-Effort-Area Swept-POD'!P14/100","v":0}]
[null,"J",{"$f":"'Mattson Form'!K13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J15,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!K$12*'Coverage-Effort-Area Swept-POD'!P15/100","v":0}]
[null,"K",{"$f":"'Mattson Form'!L13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J16,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!L$12*'Coverage-Effort-Area Swept-POD'!P16/100","v":0}]
[null,"L",{"$f":"'Mattson Form'!M13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J17,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!M$12*'Coverage-Effort-Area Swept-POD'!P17/100","v":0}]
[null,"M",{"$f":"'Mattson Form'!N13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J18,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!N$12*'Coverage-Effort-Area Swept-POD'!P18/100","v":0}]
[null,"N",{"$f":"'Mattson Form'!O13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J19,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!O$12*'Coverage-Effort-Area Swept-POD'!P19/100","v":0}]
[null,"O",{"$f":"'Mattson Form'!P13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J20,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!P$12*'Coverage-Effort-Area Swept-POD'!P20/100","v":0}]
[null,"P",{"$f":"'Mattson Form'!Q13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J21,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!Q$12*'Coverage-Effort-Area Swept-POD'!P21/100","v":0}]
[null,"Q",{"$f":"'Mattson Form'!R13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J22,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!R$12*'Coverage-Effort-Area Swept-POD'!P22/100","v":0}]
[null,"R",{"$f":"'Mattson Form'!S13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J23,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!S$12*'Coverage-Effort-Area Swept-POD'!P23/100","v":0}]
[null,"S",{"$f":"'Mattson Form'!T13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J24,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!T$12*'Coverage-Effort-Area Swept-POD'!P24/100","v":0}]
[null,"T",{"$f":"'Mattson Form'!U13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",{"$f":"C25*J25","v":0},"km2",{"$f":"VLOOKUP(J25,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!U$12*'Coverage-Effort-Area Swept-POD'!P25/100","v":0}]
[null,"U",{"$f":"'Mattson Form'!V13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J26,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!V$12*'Coverage-Effort-Area Swept-POD'!P26/100","v":0}]
[null,"V",{"$f":"'Mattson Form'!W13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J27,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!W$12*'Coverage-Effort-Area Swept-POD'!P27/100","v":0}]
[null,"W",{"$f":"'Mattson Form'!X13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J28,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!X$12*'Coverage-Effort-Area Swept-POD'!P28/100","v":0}]
[null,"X",{"$f":"'Mattson Form'!Y13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J29,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!Y$12*'Coverage-Effort-Area Swept-POD'!P29/100","v":0}]
[null,"Y",{"$f":"'Mattson Form'!Z13","v":0},"km2",null,"m",null,"m",null,{"$f":"IF(E30=0,0,(E30/G30))","v":0},null,0,"km",0,"km2",{"$f":"VLOOKUP(J30,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!Z$12*'Coverage-Effort-Area Swept-POD'!P30/100","v":0}]
[null,"Z",{"$f":"'Mattson Form'!AA13","v":0},"km2",null,"m",null,"m",null,0,null,0,"km",0,"km2",{"$f":"VLOOKUP(J31,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!AA$12*'Coverage-Effort-Area Swept-POD'!P31/100","v":0}]
[]
[]
[null,"For a desired Coverage, what Track Spacing do I need?"]
[]
[null,"Segment","Segment Area [A]",null,"AMDR\n[W]",null,"Desired Coverage\n[C]",null,null,"Track Spacing\n[S]",null,"Effort\n[L]",null,"Area Effectively Swept\n[Z]",null,"POD","POS"]
[null,"A",{"$f":"'Mattson Form'!B13","v":0},"km2",null,"m",null,null,null,{"$f":"IF(E37=0,0,(E37/G37))","v":0},"m",{"$f":"IF(E37=0,0,((N37*1000)/E37))","v":0},"km",{"$f":"C37*G37","v":0},"km2",{"$f":"VLOOKUP(J37,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!B$12*'Coverage-Effort-Area Swept-POD'!P37/100","v":0}]
[null,"B",{"$f":"'Mattson Form'!C13","v":0},"km2",null,"m",null,null,null,{"$f":"IF(E38=0,0,(E38/G38))","v":0},"m",{"$f":"IF(E38=0,0,((N38*1000)/E38))","v":0},"km",{"$f":"C38*G38","v":0},"km2",{"$f":"VLOOKUP(J38,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!C$12*'Coverage-Effort-Area Swept-POD'!P38/100","v":0}]
[null,"C",{"$f":"'Mattson Form'!D13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J39,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!D$12*'Coverage-Effort-Area Swept-POD'!P39/100","v":0}]
[null,"D",{"$f":"'Mattson Form'!E13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J40,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!E$12*'Coverage-Effort-Area Swept-POD'!P40/100","v":0}]
[null,"E",{"$f":"'Mattson Form'!F13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J41,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!F$12*'Coverage-Effort-Area Swept-POD'!P41/100","v":0}]
[null,"F",{"$f":"'Mattson Form'!G13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J42,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!G$12*'Coverage-Effort-Area Swept-POD'!P42/100","v":0}]
[null,"G",{"$f":"'Mattson Form'!H13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J43,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!H$12*'Coverage-Effort-Area Swept-POD'!P43/100","v":0}]
[null,"H",{"$f":"'Mattson Form'!I13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J44,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!I$12*'Coverage-Effort-Area Swept-POD'!P44/100","v":0}]
[null,"I",{"$f":"'Mattson Form'!J13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J45,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!J$12*'Coverage-Effort-Area Swept-POD'!P45/100","v":0}]
[null,"J",{"$f":"'Mattson Form'!K13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J46,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!K$12*'Coverage-Effort-Area Swept-POD'!P46/100","v":0}]
[null,"K",{"$f":"'Mattson Form'!L13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J47,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!L$12*'Coverage-Effort-Area Swept-POD'!P47/100","v":0}]
[null,"L",{"$f":"'Mattson Form'!M13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J48,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!M$12*'Coverage-Effort-Area Swept-POD'!P48/100","v":0}]
[null,"M",{"$f":"'Mattson Form'!N13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J49,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!N$12*'Coverage-Effort-Area Swept-POD'!P49/100","v":0}]
[null,"N",{"$f":"'Mattson Form'!O13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J50,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!O$12*'Coverage-Effort-Area Swept-POD'!P50/100","v":0}]
[null,"O",{"$f":"'Mattson Form'!P13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J51,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!P$12*'Coverage-Effort-Area Swept-POD'!P51/100","v":0}]
[null,"P",{"$f":"'Mattson Form'!Q13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J52,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!Q$12*'Coverage-Effort-Area Swept-POD'!P52/100","v":0}]
[null,"Q",{"$f":"'Mattson Form'!R13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J53,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!R$12*'Coverage-Effort-Area Swept-POD'!P53/100","v":0}]
[null,"R",{"$f":"'Mattson Form'!S13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J54,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!S$12*'Coverage-Effort-Area Swept-POD'!P54/100","v":0}]
[null,"S",{"$f":"'Mattson Form'!T13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J55,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!T$12*'Coverage-Effort-Area Swept-POD'!P55/100","v":0}]
[null,"T",{"$f":"'Mattson Form'!U13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J56,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!U$12*'Coverage-Effort-Area Swept-POD'!P56/100","v":0}]
[null,"U",{"$f":"'Mattson Form'!V13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J57,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!V$12*'Coverage-Effort-Area Swept-POD'!P57/100","v":0}]
[null,"V",{"$f":"'Mattson Form'!W13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J58,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!W$12*'Coverage-Effort-Area Swept-POD'!P58/100","v":0}]
[null,"W",{"$f":"'Mattson Form'!X13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J59,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!X$12*'Coverage-Effort-Area Swept-POD'!P59/100","v":0}]
[null,"X",{"$f":"'Mattson Form'!Y13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J60,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!Y$12*'Coverage-Effort-Area Swept-POD'!P60/100","v":0}]
[null,"Y",{"$f":"'Mattson Form'!Z13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J61,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!Z$12*'Coverage-Effort-Area Swept-POD'!P61/100","v":0}]
[null,"Z",{"$f":"'Mattson Form'!AA13","v":0},"km2",null,"m",null,null,null,0,"m",0,"km",0,"km2",{"$f":"VLOOKUP(J62,'POD Table'!A$1:B$42,2)","v":0},{"$f":"'Mattson Form'!AA$12*'Coverage-Effort-Area Swept-POD'!P62/100","v":0}]

{"sheet":"Total Effort (L) in KM","index":7,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,3],[1,4,1,7],[8,4,8,7],[8,0,8,3]]}
["Total Effort is the sum of the distance tavelled in a segment by all searchers while searching."]
["Only useful if you have a perfectly rectangular area to be swept",null,null,null,"Useful if all the teams moved at the same speed for the same length of time."]
["# of Tracks:",null,"#",null,null,"Velocity of searchers:",null,"Km/h"]
["Length of each track:",null,"km",null,null,"Time searchers searched:",null,"Hrs"]
[null,null,null,null,null,"# of Searchers:",null,"#"]
["L: ",{"$f":"B3*B4","v":0},"km"]
[null,null,null,null,null,"L: ",{"$f":"G3*G4*G5","v":0},"km"]
[]
["For rectangular segment, straight, parallel, evenly spaced tracks (Area = W x L)",null,null,null,"Useful if you know Effort and want to estimate length of each track and time it will take to search"]
["Area: ",null,"Ha",null,null,"L:",null,"km"]
["Track Spacing: ",null,"M",null,null,"# of Searchers:",null,"#"]
[null,null,null,null,null,"Velocity of searchers:",null,"Km/h"]
[null,null,null,null,null,"Length of each track:",{"$f":"IF($G$10=0,0,(G10/G11))","v":0},"km"]
["L: ",{"$f":"IF(B10=0,0,B10*1000/B11)","v":0},"km",null,null,"Time searchers searched:",{"$f":"IF($G$13=0,0,(G13/G12))","v":0},"Hrs"]
[]
[]
["Area Effectively Swept (Z)",null,"km2",null,null,"V: ",null,"km/h"]
["Effective Sweep Width (W)",null,"m",null,null,"T: ",null,"hrs"]
[]
["L:",{"$f":"IF(B17=0,0,B17/(B18/1000))","v":0},null,null,null,"L: ",{"$f":"G17*G18","v":0},"km"]

{"sheet":"AMDR","index":8,"n_rows":30,"n_cols":29,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,28,27,28],[26,29,27,29],[28,28,29,28],[28,29,29,29],[19,27,19,28],[20,27,20,28],[22,28,23,28],[22,29,23,29],[24,28,25,28],[24,29,25,29]]}
["AMDR CALCULATOR"]
[]
[null,null,null,"Paces per 100m:",100,"paces (If data is in metres, enter 100 here)"]
[]
["TEST 1",null,null,null,"Paces",null,"TEST 2",null,null,null,"Paces",null,"TEST 3",null,null,null,"Paces",null,"TEST 4",null,null,null,"Paces"]
["Leg 1",{"$f":"(100/E3)*E6","v":0},"m","<=",null,null,"Leg 1",{"$f":"(100/E3)*K6","v":0},"m","<=",null,null,"Leg 1",{"$f":"(100/E3)*Q6","v":0},"m","<=",null,null,"Leg 1",{"$f":"(100/$E3)*W6","v":0},"m","<="]
["Leg 2",{"$f":"(100/E3)*E7","v":0},"m","<=",null,null,"Leg 2",{"$f":"(100/E3)*K7","v":0},"m","<=",null,null,"Leg 2",{"$f":"(100/E3)*Q7","v":0},"m","<=",null,null,"Leg 2",{"$f":"(100/$E3)*W7","v":0},"m","<="]
["Leg 3",{"$f":"(100/E3)*E8","v":0},"m","<=",null,null,"Leg 3",{"$f":"(100/E3)*K8","v":0},"m","<=",null,null,"Leg 3",{"$f":"(100/E3)*Q8","v":0},"m","<=",null,null,"Leg 3",{"$f":"(100/$E3)*W8","v":0},"m","<="]
["Leg 4",{"$f":"(100/E3)*E9","v":0},"m","<=",null,null,"Leg 4",{"$f":"(100/E3)*K9","v":0},"m","<=",null,null,"Leg 4",{"$f":"(100/E3)*Q9","v":0},"m","<=",null,null,"Leg 4",{"$f":"(100/$E3)*W9","v":0},"m","<="]
["Leg 5",{"$f":"(100/E3)*E10","v":0},"m","<=",null,null,"Leg 5",{"$f":"(100/E3)*K10","v":0},"m","<=",null,null,"Leg 5",{"$f":"(100/E3)*Q10","v":0},"m","<=",null,null,"Leg 5",{"$f":"(100/$E3)*W10","v":0},"m","<="]
["Leg 6",{"$f":"(100/E3)*E11","v":0},"m","<=",null,null,"Leg 6",{"$f":"(100/E3)*K11","v":0},"m","<=",null,null,"Leg 6",{"$f":"(100/E3)*Q11","v":0},"m","<=",null,null,"Leg 6",{"$f":"(100/$E3)*W11","v":0},"m","<="]
["Leg 7",{"$f":"(100/E3)*E12","v":0},"m","<=",null,null,"Leg 7",{"$f":"(100/E3)*K12","v":0},"m","<=",null,null,"Leg 7",{"$f":"(100/E3)*Q12","v":0},"m","<=",null,null,"Leg 7",{"$f":"(100/$E3)*W12","v":0},"m","<="]
["Leg 8",{"$f":"(100/E3)*E13","v":0},"m","<=",null,null,"Leg 8",{"$f":"(100/E3)*K13","v":0},"m","<=",null,null,"Leg 8",{"$f":"(100/E3)*Q13","v":0},"m","<=",null,null,"Leg 8",{"$f":"(100/$E3)*W13","v":0},"m","<="]
[]
["AMDR",{"$f":"(SUM(B6:B13)/8)*(100/E3)","v":0},"m",null,null,null,"AMDR",{"$f":"(SUM(H6:H13)/8)*(100/E3)","v":0},"m",null,null,null,"AMDR",{"$f":"(SUM(N6:N13)/8)*(100/E3)","v":0},"m",null,null,null,"AMDR",{"$f":"(SUM(T6:T13)/8)*(100/$E3)","v":0},"m"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effective Sweep Width Data for Ecoregion Province"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M242 Marine Mountains, mixed forest, summer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Object Visibility","Effective Sweep Width (m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person-sized, White/Orange","36m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(High Visibility)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person-sized, Blue","32m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Medium visibility)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person-sized, Green","17m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Low visibility)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glove-sized Clue","8m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(High visibility)"]

{"sheet":"Effort, Z, C","index":9,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["EFFORT, AREA EFFECTIVELY SWEPT, COVERAGE"]
[]
["Effective Sweep Width (or AMDR) for Object of:"]
["Hi Visibility",null,"m"]
["Med Visibility",null,"m"]
["Low Visibility",null,"m","Z= AREA EFFECTIVELY SWEPT"]
["Clue (Hi Vis)",null,"m","C= COVERAGE"]
[]
[]
[null,"SEGMENT:",null," Area:",null,"km2"]
[]
["EFFORT","km",null,"V (km/h)","T (hrs)"]
["Searcher 1",{"$f":"D13*E13","v":0},"ç"]
["Searcher 2",0,"ç"]
["Searcher 3",0,"ç"]
["Searcher 4",0,"ç"]
["Searcher 5",0,"ç"]
["Searcher 6",0,"ç"]
["Searcher 7",0,"ç"]
["Searcher 8",0,"ç"]
["Searcher 9",0,"ç"]
["Searcher 10",0,"ç"]
[null,"ê"]
["EFFORT = ",{"$f":"SUM(B13:B22)","v":0},"km"]
["Object Visibility:","Hi ","Med","Low","Clue (Hi)"]
["Z =",{"$f":"(B24*$B$4)/1000","v":0},{"$f":"(B24*$B$5)/1000","v":0},{"$f":"(B24*$B$6)/1000","v":0},{"$f":"(B24*$B$7)/1000","v":0},"km2"]
["C =",{"$f":"IF($B$26=0,0,(B26/E10))","v":0},{"$f":"IF($C$26=0,0,(C26/E10))","v":0},{"$f":"IF($D$26=0,0,(D26/E10))","v":0},{"$f":"IF($E$26=0,0,(E26/E10))","v":0}]
[]
[]
[null,null,null,"Area Effectively Swept (Z)",null,null,"             Coverage (C)"]
["Segment","Area","Effort","High","Med","Low","High","Med","Low","Date"]

{"sheet":"Planning Sweep Search","index":10,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Planning the Sweep Search of a Segment ",null,"Simple calculations For a Rectangular Segment"]
[]
["Dimensions of Segment:"]
["Baseline Length:",null,"km",null,"Number of Parallel Tracks:",null,null,"Track Spacing:",{"$f":"IF($B$4=0,0,((B4*1000)/F4))","v":0},"m"]
["Length of Track:",null,"km",null,"Tracks are evenly divided along the baseline.",null,null,"Effort:",{"$f":"B5*F4","v":0},"km"]
["Area:",{"$f":"B4*B5","v":0},"km2",null,null,null,null,"Area Effectively Swept:",{"$f":"(I5*B9)/1000","v":0},"km2"]
["POA:",null,"%",null,null,null,null,"Coverage:",{"$f":"IF($I$6=0,0,(I6/B6))","v":0}]
["Pden:",12.25,"%/km2",null,null,null,null,"POD:",{"$f":"(1-EXP((-1)*I7))*100","v":0},"%"]
["Effective Sweep Width:",null,"m",null,null,null,"After this search:","POAnew:",{"$f":"((B7/100)*(1-(I8/100)))*100","v":0},"%"]
["Searcher Speed:",null,"km/h",null,null,null,null,"POS:",{"$f":"((B7/100)-(I9/100))*100","v":0},"%"]
[]
["PSR:",{"$f":"(0.1225*B10*0.036)*100","v":0},"POS/Searcher-Hour",null,"Number of Searchers:",null,"Based on Effort"]
[null,null,null,null,"Time Spent Searching:",{"$f":"IF($I$5=0,0,(I5/B10/F12))","v":0},"Hours"]

{"sheet":"POD Table","index":12,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Coverage","POD"]
[0,0]
[0.05,4.8771000000000002E-2]
[0.1,9.5162999999999998E-2]
[0.15,0.139292]
[0.2,0.18126900000000001]
[0.25,0.22119900000000001]
[0.3,0.25918200000000002]
[0.35,0.29531200000000002]
[0.4,0.32967999999999997]
[0.45,0.36237200000000003]
[0.5,0.39346900000000001]
[0.55000000000000004,0.42304999999999998]
[0.6,0.45118799999999998]
[0.65,0.47795399999999999]
[0.7,0.50341499999999995]
[0.75,0.52763300000000002]
[0.8,0.55067100000000002]
[0.85,0.57258500000000001]
[0.9,0.59343000000000001]
[0.95,0.613259]
[1,0.63212100000000004]
[1.05,0.65006200000000003]
[1.1000000000000001,0.66712899999999997]
[1.1499999999999999,0.68336300000000005]
[1.2,0.69880600000000004]
[1.25,0.71349499999999999]
[1.3,0.727468]
[1.35,0.74075999999999997]
[1.4,0.75340300000000004]
[1.45,0.76543000000000005]
[1.5,0.77686999999999995]
[1.55,0.78775200000000001]
[1.6,0.79810300000000001]
[1.65,0.80794999999999995]
[1.7,0.81731600000000004]
[1.75,0.82622600000000002]
[1.8,0.83470100000000003]
[1.85,0.84276300000000004]
[1.9,0.85043100000000005]
[1.95,0.85772599999999999]
[2,0.86466500000000002]