{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Alternatives","Alt1","Alt2-1","Alt2-2","Alt2-3","Alt2-4","Alt3-1","Alt3-2a","Alt3-3a","Indices"],"not_rendered":{"charts":15,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"merged":[[19,1,19,10],[20,4,20,10]]}
["This workbook is provided for convenience and illustration, and is not to be used for final decision. The calculations are not guaranteed."]
["The values in highlighted cells (yellow) are to be changed"]
[]
[]
["Index","Choose trawl or setline"]
["Starting Point","The PSC when the standardized primary index is 1.0 and the secondary index has no effect"]
["Ceiling","The maximum PSC limit"]
["Floor","The minimum PSC limit"]
["Breakpoint","The value of the standardized primary index where the slope changes or is affected by the secondary index"]
["Slope Multiplier","The multiplier on the slope when above or below the breakpoints"]
["Constraint","The maximum annual percent change in the PSC limit"]
["Standardize","The year or the mean to standardize the index to"]
[]
[]
["Cells are colored orange when the PSC limit hits the ceiling, and are colored blue when it hits the floor"]
[]
["The \"what-if\" is completely adhoc and is not a projection of the index, but an illustration of what may happen if the indices were those values"]
[]
[]
["Table 2‑3.","Combination of alternatives included in analysis. Numbering for each alternative shows the Overarching Alternative (1,2,3) then secondary numbering to group sub-sets by similar elements and options (e.g., 201, 3-1).  See Figure 2‑8 for further explanation of selections of Elements and Options to formulate each alternative shown. Each index is standardized to the most recent year, unless “mean” is specified which implies it is standardized to the mean of the series from 1998 to the current year. “By gear” means that the trawl index is linked to the trawl fishery and likewise for non-trawl gear. Elements (1-3) apply 20:80 ratio between non-trawl and trawl PSC to calculate gear-specific starting points (S.P. Element 1), Ceilings (Element 2) and floors (Element 3). “Constraint” indicates how much a PSC limit can change from one year to the next (Element 6) while “type” indicates whether it is a continuous control rule with or without breakpoints or a ‘Look up Table” from Element 7 and shown as “discrete”."]
[{"$nulls":4},"Elements"]
[null,null,"Indices used",null,1,2,3,4,5,6,7]
["Alternative","Source","Primary ","Secondary ","Starting point","Ceiling","Floor","Break points","Responsiveness","Constraint","Type"]
[1,"Status quo","NA","NA",{"v":3515,"d":"3,515"}]
[2.1,"WG","By gear","NA",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"none","01:01:00","15% max","Continuous"]
["2-1.a","WG","By gear","NA",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"none","01:01:00","none","Continuous"]
["2-1.b","SSC","By gear","NA",{"v":1958,"d":"1,958"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"none","01:01:00","15% max","Continuous"]
["2019-02-02","Stakeholder","By gear ","NA",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":2354,"d":"2,354"},"specified ","Stairsteps ","2 yr avg ","Continuous"]
["2019-02-03","Stakeholder","By gear ","NA",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":2354,"d":"2,354"},"none","01:01:00","15% max","Continuous"]
["2019-02-04","Stakeholder","By gear","NA",{"v":2018,"d":"2,018"},{"v":3515,"d":"3,515"},{"v":1000,"d":"1,000"},"Start","1:1 (low) 0.5:1 (high)","15% max","Continuous"]
["2019-03-01","WG","By gear","Other (mean)",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"±25%","01:01:00","15% max","Continuous"]
["3-1.a","WG","By gear","Other (mean)",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"±25%","01:01:00","none","Continuous"]
["3-1.b","WG","By gear","Other (mean)",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"±25%","2nd Index 0.5:1 (low),1.5:1 (high)","15% max","Continuous"]
["3-1.c","WG","By gear","Other (mean)",{"v":3515,"d":"3,515"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"±25%","01:01:00","15% max","Discrete"]
["3-1.d","SSC","By gear","Other (mean)",{"v":1958,"d":"1,958"},{"v":4426,"d":"4,426"},{"v":1758,"d":"1,758"},"±25%","01:01:00","15% max","Continuous"]
["3-2.a","Stakeholder","Gear (mean)","Other (mean)",{"v":2941,"d":"2,941"},{"v":4124,"d":"4,124"},{"v":1758,"d":"1,758"},"none","Interpolated","15% max","Discrete"]
["3-2.b","WG","Gear (mean)","Other (mean)",{"v":2941,"d":"2,941"},{"v":4124,"d":"4,124"},{"v":1758,"d":"1,758"},"none","01:01:00","15% max","Discrete"]
["3-3a","Stakeholder","Setline ","Trawl (mean)",{"v":1958,"d":"1,958"},{"v":3515,"d":"3,515"},{"v":1000,"d":"1,000"},"S.P","Secondary 0.35:1","20% max","Continuous"]
["3-3b","WG","Trawl","Setline (mean)",{"v":1958,"d":"1,958"},{"v":3515,"d":"3,515"},{"v":1000,"d":"1,000"},"S.P","Secondary 0.35:1","20% max","Continuous"]

{"sheet":"Alternatives","index":1,"n_rows":23,"n_cols":23,"rows_kept":23,"merged":[[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,11,0,12],[0,13,0,14],[0,15,0,16],[0,17,0,18]]}
["Alternative",null,null,1,null,"2-1",null,"2-2",null,"2-3",null,"2-4",null,"3-1",null,"3-2a",null,"3-3a"]
["Year","Trawl index","Setline index","Trawl","Non-trawl","Trawl","Non-trawl","Trawl","Non-trawl","Trawl","Non-trawl","Trawl","Non-trawl","Trawl","Non-trawl","Trawl","Non-trawl","Trawl","Non-trawl",null,"Actual trawl PSC Limit","Actual non-trawl PSC Limit","Actual PSC Limit"]
[1998,{"$f":"Indices!B2","v":161256},{"$f":"Indices!C2","v":18502},{"$f":"'Alt1'!G15","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H15","v":710},{"$f":"'Alt2-1'!G32","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G58","v":894},{"$f":"'Alt2-2'!D32","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J32","v":894},{"$f":"'Alt2-3'!G32","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G58","v":894},{"$f":"'Alt2-4'!G32","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt2-4'!G58","v":710},{"$f":"'Alt3-1'!I32","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I58","v":894},{"$f":"'Alt3-2a'!I32","v":{"v":3241.2,"d":"3,241"}},{"$f":"'Alt3-2a'!I72","v":{"v":820.3999999999999,"d":"820"}},{"$f":"'Alt3-3a'!I32","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-3a'!I58","v":710},null,3734,842,{"$f":"SUM(U3:V3)","v":4576}]
[1999,{"$f":"Indices!B3","v":129116},{"$f":"Indices!C3","v":16201},{"$f":"'Alt1'!G16","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H16","v":710},{"$f":"'Alt2-1'!G33","v":{"v":3002.2,"d":"3,002"}},{"$f":"'Alt2-1'!G59","v":894},{"$f":"'Alt2-2'!D33","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J33","v":894},{"$f":"'Alt2-3'!G33","v":{"v":3002.2,"d":"3,002"}},{"$f":"'Alt2-3'!G59","v":894},{"$f":"'Alt2-4'!G33","v":{"v":2631.327545161742,"d":"2,631"}},{"$f":"'Alt2-4'!G59","v":710},{"$f":"'Alt3-1'!I33","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I59","v":894},{"$f":"'Alt3-2a'!I33","v":{"v":3095.7999999999997,"d":"3,096"}},{"$f":"'Alt3-2a'!I73","v":{"v":783.5999999999999,"d":"784"}},{"$f":"'Alt3-3a'!I33","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-3a'!I59","v":710},null,3734,842,{"$f":"SUM(U4:V4)","v":4576}]
[2000,{"$f":"Indices!B4","v":118677},{"$f":"Indices!C4","v":16203},{"$f":"'Alt1'!G17","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H17","v":710},{"$f":"'Alt2-1'!G34","v":{"v":2648.2393677109353,"d":"2,648"}},{"$f":"'Alt2-1'!G60","v":894},{"$f":"'Alt2-2'!D34","v":{"v":1745,"d":"1,745"}},{"$f":"'Alt2-2'!J34","v":894},{"$f":"'Alt2-3'!G34","v":{"v":2648.2393677109353,"d":"2,648"}},{"$f":"'Alt2-3'!G60","v":894},{"$f":"'Alt2-4'!G34","v":{"v":2631.553003780983,"d":"2,632"}},{"$f":"'Alt2-4'!G60","v":710},{"$f":"'Alt3-1'!I34","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I60","v":894},{"$f":"'Alt3-2a'!I34","v":{"v":3023.1,"d":"3,023"}},{"$f":"'Alt3-2a'!I74","v":{"v":765.1999999999999,"d":"765"}},{"$f":"'Alt3-3a'!I34","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-3a'!I60","v":710},null,3734,842,4576]
[2001,{"$f":"Indices!B5","v":141219},{"$f":"Indices!C5","v":13780},{"$f":"'Alt1'!G18","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H18","v":710},{"$f":"'Alt2-1'!G35","v":{"v":3045.4752728675753,"d":"3,045"}},{"$f":"'Alt2-1'!G61","v":894},{"$f":"'Alt2-2'!D35","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J35","v":894},{"$f":"'Alt2-3'!G35","v":{"v":3045.4752728675753,"d":"3,045"}},{"$f":"'Alt2-3'!G61","v":894},{"$f":"'Alt2-4'!G35","v":{"v":2358.409886570508,"d":"2,358"}},{"$f":"'Alt2-4'!G61","v":710},{"$f":"'Alt3-1'!I35","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I61","v":894},{"$f":"'Alt3-2a'!I35","v":{"v":2950.4,"d":"2,950"}},{"$f":"'Alt3-2a'!I75","v":{"v":746.8,"d":"747"}},{"$f":"'Alt3-3a'!I35","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-3a'!I61","v":710},null,3734,842,4576]
[2002,{"$f":"Indices!B6","v":101706},{"$f":"Indices!C6","v":12104},{"$f":"'Alt1'!G19","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H19","v":710},{"$f":"'Alt2-1'!G36","v":{"v":2588.653981937439,"d":"2,589"}},{"$f":"'Alt2-1'!G62","v":894},{"$f":"'Alt2-2'!D36","v":{"v":1745,"d":"1,745"}},{"$f":"'Alt2-2'!J36","v":894},{"$f":"'Alt2-3'!G36","v":{"v":2588.653981937439,"d":"2,589"}},{"$f":"'Alt2-3'!G62","v":894},{"$f":"'Alt2-4'!G36","v":{"v":2169.475563646548,"d":"2,169"}},{"$f":"'Alt2-4'!G62","v":{"v":691.5602856742753,"d":"692"}},{"$f":"'Alt3-1'!I36","v":{"v":3517.7638846642517,"d":"3,518"}},{"$f":"'Alt3-1'!I62","v":894},{"$f":"'Alt3-2a'!I36","v":{"v":2664.7999999999993,"d":"2,665"}},{"$f":"'Alt3-2a'!I76","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I36","v":{"v":2544.856476717359,"d":"2,545"}},{"$f":"'Alt3-3a'!I62","v":{"v":643.1339144615207,"d":"643"}},null,3734,842,4576]
[2003,{"$f":"Indices!B7","v":132151},{"$f":"Indices!C7","v":10866},{"$f":"'Alt1'!G20","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H20","v":710},{"$f":"'Alt2-1'!G37","v":{"v":2948.907376175399,"d":"2,949"}},{"$f":"'Alt2-1'!G63","v":894},{"$f":"'Alt2-2'!D37","v":{"v":1745,"d":"1,745"}},{"$f":"'Alt2-2'!J37","v":894},{"$f":"'Alt2-3'!G37","v":{"v":2948.907376175399,"d":"2,949"}},{"$f":"'Alt2-3'!G63","v":894},{"$f":"'Alt2-4'!G37","v":{"v":2029.9166783363673,"d":"2,030"}},{"$f":"'Alt2-4'!G63","v":{"v":620.8273351071279,"d":"621"}},{"$f":"'Alt3-1'!I37","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I63","v":894},{"$f":"'Alt3-2a'!I37","v":{"v":2664.7999999999993,"d":"2,665"}},{"$f":"'Alt3-2a'!I77","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I37","v":{"v":2406.3822684304037,"d":"2,406"}},{"$f":"'Alt3-3a'!I63","v":{"v":608.1388330326356,"d":"608"}},null,3734,842,4576]
[2004,{"$f":"Indices!B8","v":130075},{"$f":"Indices!C8","v":9987},{"$f":"'Alt1'!G21","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H21","v":710},{"$f":"'Alt2-1'!G38","v":{"v":2902.5820989323956,"d":"2,903"}},{"$f":"'Alt2-1'!G64","v":894},{"$f":"'Alt2-2'!D38","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J38","v":894},{"$f":"'Alt2-3'!G38","v":{"v":2902.5820989323956,"d":"2,903"}},{"$f":"'Alt2-3'!G64","v":894},{"$f":"'Alt2-4'!G38","v":{"v":1930.8276151799469,"d":"1,931"}},{"$f":"'Alt2-4'!G64","v":{"v":570.6057975073519,"d":"571"}},{"$f":"'Alt3-1'!I38","v":{"v":3319.24695679544,"d":"3,319"}},{"$f":"'Alt3-1'!I64","v":894},{"$f":"'Alt3-2a'!I38","v":{"v":2664.7999999999993,"d":"2,665"}},{"$f":"'Alt3-2a'!I78","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I38","v":{"v":2204.9547985956883,"d":"2,205"}},{"$f":"'Alt3-3a'!I64","v":{"v":557.2342581223908,"d":"557"}},null,3734,842,4576]
[2005,{"$f":"Indices!B9","v":132518},{"$f":"Indices!C9","v":9550},{"$f":"'Alt1'!G22","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H22","v":710},{"$f":"'Alt2-1'!G39","v":{"v":2957.0968640117103,"d":"2,957"}},{"$f":"'Alt2-1'!G65","v":894},{"$f":"'Alt2-2'!D39","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J39","v":710},{"$f":"'Alt2-3'!G39","v":{"v":2957.0968640117103,"d":"2,957"}},{"$f":"'Alt2-3'!G65","v":894},{"$f":"'Alt2-4'!G39","v":{"v":1881.5649068757875,"d":"1,882"}},{"$f":"'Alt2-4'!G65","v":{"v":545.6378658451197,"d":"546"}},{"$f":"'Alt3-1'!I39","v":{"v":3202.1071916969086,"d":"3,202"}},{"$f":"'Alt3-1'!I65","v":894},{"$f":"'Alt3-2a'!I39","v":{"v":2524.5999999999995,"d":"2,525"}},{"$f":"'Alt3-2a'!I79","v":639},{"$f":"'Alt3-3a'!I39","v":{"v":2119.9374266059076,"d":"2,120"}},{"$f":"'Alt3-3a'!I65","v":{"v":535.7487418485819,"d":"536"}},null,3734,842,4576]
[2006,{"$f":"Indices!B10","v":155964},{"$f":"Indices!C10","v":9802},{"$f":"'Alt1'!G23","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H23","v":710},{"$f":"'Alt2-1'!G40","v":{"v":3400.6613936134668,"d":"3,401"}},{"$f":"'Alt2-1'!G66","v":894},{"$f":"'Alt2-2'!D40","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J40","v":710},{"$f":"'Alt2-3'!G40","v":{"v":3400.6613936134668,"d":"3,401"}},{"$f":"'Alt2-3'!G66","v":894},{"$f":"'Alt2-4'!G40","v":{"v":1909.972692900154,"d":"1,910"}},{"$f":"'Alt2-4'!G66","v":{"v":560.0358493208234,"d":"560"}},{"$f":"'Alt3-1'!I40","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I66","v":894},{"$f":"'Alt3-2a'!I40","v":{"v":2664.7999999999993,"d":"2,665"}},{"$f":"'Alt3-2a'!I80","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I40","v":{"v":2277.130447420283,"d":"2,277"}},{"$f":"'Alt3-3a'!I66","v":{"v":575.4744252917542,"d":"575"}},null,3734,842,4576]
[2007,{"$f":"Indices!B11","v":143903},{"$f":"Indices!C11","v":9673},{"$f":"'Alt1'!G24","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H24","v":710},{"$f":"'Alt2-1'!G41","v":{"v":3211.149504383383,"d":"3,211"}},{"$f":"'Alt2-1'!G67","v":894},{"$f":"'Alt2-2'!D41","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J41","v":710},{"$f":"'Alt2-3'!G41","v":{"v":3211.149504383383,"d":"3,211"}},{"$f":"'Alt2-3'!G67","v":894},{"$f":"'Alt2-4'!G41","v":{"v":1895.4306119591095,"d":"1,895"}},{"$f":"'Alt2-4'!G67","v":{"v":552.6654530177847,"d":"553"}},{"$f":"'Alt3-1'!I41","v":{"v":3504.4744938806525,"d":"3,504"}},{"$f":"'Alt3-1'!I67","v":894},{"$f":"'Alt3-2a'!I41","v":{"v":2664.7999999999993,"d":"2,665"}},{"$f":"'Alt3-2a'!I81","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I41","v":{"v":2196.4063440132486,"d":"2,196"}},{"$f":"'Alt3-3a'!I67","v":{"v":555.0739001185113,"d":"555"}},null,3734,842,4576]
[2008,{"$f":"Indices!B12","v":140247},{"$f":"Indices!C12","v":10264},{"$f":"'Alt1'!G25","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H25","v":710},{"$f":"'Alt2-1'!G42","v":{"v":3129.567031550811,"d":"3,130"}},{"$f":"'Alt2-1'!G68","v":894},{"$f":"'Alt2-2'!D42","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J42","v":894},{"$f":"'Alt2-3'!G42","v":{"v":3129.567031550811,"d":"3,130"}},{"$f":"'Alt2-3'!G68","v":894},{"$f":"'Alt2-4'!G42","v":{"v":1962.0536339448256,"d":"1,962"}},{"$f":"'Alt2-4'!G68","v":{"v":586.4321523596135,"d":"586"}},{"$f":"'Alt3-1'!I42","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I68","v":894},{"$f":"'Alt3-2a'!I42","v":{"v":2664.7999999999993,"d":"2,665"}},{"$f":"'Alt3-2a'!I82","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I42","v":{"v":2309.8518330870384,"d":"2,310"}},{"$f":"'Alt3-3a'!I68","v":{"v":583.7437454058735,"d":"584"}},null,3734,842,4576]
[2009,{"$f":"Indices!B13","v":168102},{"$f":"Indices!C13","v":9834},{"$f":"'Alt1'!G26","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H26","v":710},{"$f":"'Alt2-1'!G43","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G69","v":894},{"$f":"'Alt2-2'!D43","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J43","v":894},{"$f":"'Alt2-3'!G43","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G69","v":894},{"$f":"'Alt2-4'!G43","v":{"v":1913.58003080801,"d":"1,914"}},{"$f":"'Alt2-4'!G69","v":{"v":561.8641646828175,"d":"562"}},{"$f":"'Alt3-1'!I43","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I69","v":894},{"$f":"'Alt3-2a'!I43","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-2a'!I83","v":710},{"$f":"'Alt3-3a'!I43","v":{"v":2336.9585916251926,"d":"2,337"}},{"$f":"'Alt3-3a'!I69","v":{"v":590.5941418374607,"d":"591"}},null,3693,833,4526]
[2010,{"$f":"Indices!B14","v":195535},{"$f":"Indices!C14","v":9146},{"$f":"'Alt1'!G27","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H27","v":710},{"$f":"'Alt2-1'!G44","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G70","v":894},{"$f":"'Alt2-2'!D44","v":{"v":2325,"d":"2,325"}},{"$f":"'Alt2-2'!J44","v":710},{"$f":"'Alt2-3'!G44","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G70","v":894},{"$f":"'Alt2-4'!G44","v":{"v":1836.0222657891052,"d":"1,836"}},{"$f":"'Alt2-4'!G70","v":{"v":522.555384399944,"d":"523"}},{"$f":"'Alt3-1'!I44","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I70","v":894},{"$f":"'Alt3-2a'!I44","v":{"v":2950.4,"d":"2,950"}},{"$f":"'Alt3-2a'!I84","v":{"v":746.8,"d":"747"}},{"$f":"'Alt3-3a'!I44","v":{"v":2305.758581035233,"d":"2,306"}},{"$f":"'Alt3-3a'!I70","v":{"v":582.7093023089681,"d":"583"}},null,3684,842,4526]
[2011,{"$f":"Indices!B15","v":186666},{"$f":"Indices!C15","v":8669},{"$f":"'Alt1'!G28","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H28","v":710},{"$f":"'Alt2-1'!G45","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G71","v":{"v":861.9226999019746,"d":"862"}},{"$f":"'Alt2-2'!D45","v":{"v":2325,"d":"2,325"}},{"$f":"'Alt2-2'!J45","v":710},{"$f":"'Alt2-3'!G45","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G71","v":{"v":861.9226999019746,"d":"862"}},{"$f":"'Alt2-4'!G45","v":{"v":1782.2503851001263,"d":"1,782"}},{"$f":"'Alt2-4'!G71","v":{"v":495.3020585352192,"d":"495"}},{"$f":"'Alt3-1'!I45","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I71","v":894},{"$f":"'Alt3-2a'!I45","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-2a'!I85","v":710},{"$f":"'Alt3-3a'!I45","v":{"v":2162.756768037697,"d":"2,163"}},{"$f":"'Alt3-3a'!I71","v":{"v":546.5700085571915,"d":"547"}},null,3634,842,4476]
[2012,{"$f":"Indices!B16","v":189000},{"$f":"Indices!C16","v":8403},{"$f":"'Alt1'!G29","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H29","v":710},{"$f":"'Alt2-1'!G46","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G72","v":{"v":835.4754236101386,"d":"835"}},{"$f":"'Alt2-2'!D46","v":{"v":2325,"d":"2,325"}},{"$f":"'Alt2-2'!J46","v":710},{"$f":"'Alt2-3'!G46","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G72","v":{"v":835.4754236101386,"d":"835"}},{"$f":"'Alt2-4'!G46","v":{"v":1752.264388741073,"d":"1,752"}},{"$f":"'Alt2-4'!G72","v":{"v":480.1041870886431,"d":"480"}},{"$f":"'Alt3-1'!I46","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I72","v":894},{"$f":"'Alt3-2a'!I46","v":{"v":2877.7000000000003,"d":"2,878"}},{"$f":"'Alt3-2a'!I86","v":{"v":728.4,"d":"728"}},{"$f":"'Alt3-3a'!I46","v":{"v":2114.692983741078,"d":"2,115"}},{"$f":"'Alt3-3a'!I72","v":{"v":534.423370811085,"d":"534"}},null,3593,833,4426]
[2013,{"$f":"Indices!B17","v":183989},{"$f":"Indices!C17","v":7989},{"$f":"'Alt1'!G30","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H30","v":710},{"$f":"'Alt2-1'!G47","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G73","v":{"v":794.3131214115671,"d":"794"}},{"$f":"'Alt2-2'!D47","v":{"v":2325,"d":"2,325"}},{"$f":"'Alt2-2'!J47","v":710},{"$f":"'Alt2-3'!G47","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G73","v":{"v":794.3131214115671,"d":"794"}},{"$f":"'Alt2-4'!G47","v":{"v":1705.5944545581851,"d":"1,706"}},{"$f":"'Alt2-4'!G73","v":{"v":456.4503570928442,"d":"456"}},{"$f":"'Alt3-1'!I47","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I73","v":894},{"$f":"'Alt3-2a'!I47","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-2a'!I87","v":710},{"$f":"'Alt3-3a'!I47","v":{"v":2002.2702752971857,"d":"2,002"}},{"$f":"'Alt3-3a'!I73","v":{"v":506.01200175456705,"d":"506"}},null,3593,833,4426]
[2014,{"$f":"Indices!B18","v":171427},{"$f":"Indices!C18","v":7995},{"$f":"'Alt1'!G31","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H31","v":710},{"$f":"'Alt2-1'!G48","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G74","v":{"v":794.909676515894,"d":"795"}},{"$f":"'Alt2-2'!D48","v":{"v":2325,"d":"2,325"}},{"$f":"'Alt2-2'!J48","v":710},{"$f":"'Alt2-3'!G48","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G74","v":{"v":794.909676515894,"d":"795"}},{"$f":"'Alt2-4'!G48","v":{"v":1706.270830415908,"d":"1,706"}},{"$f":"'Alt2-4'!G74","v":{"v":456.793166223218,"d":"457"}},{"$f":"'Alt3-1'!I48","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I74","v":{"v":875.6772458465333,"d":"876"}},{"$f":"'Alt3-2a'!I48","v":{"v":2664.7999999999997,"d":"2,665"}},{"$f":"'Alt3-2a'!I88","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I48","v":{"v":1948.9142228122091,"d":"1,949"}},{"$f":"'Alt3-3a'!I74","v":{"v":492.5279065968155,"d":"493"}},null,3593,833,4426]
[2015,{"$f":"Indices!B19","v":172237},{"$f":"Indices!C19","v":8130},{"$f":"'Alt1'!G32","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H32","v":710},{"$f":"'Alt2-1'!G49","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-1'!G75","v":{"v":808.3321663632544,"d":"808"}},{"$f":"'Alt2-2'!D49","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J49","v":710},{"$f":"'Alt2-3'!G49","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt2-3'!G75","v":{"v":808.3321663632544,"d":"808"}},{"$f":"'Alt2-4'!G49","v":{"v":1721.4892872146759,"d":"1,721"}},{"$f":"'Alt2-4'!G75","v":{"v":464.50637165663073,"d":"465"}},{"$f":"'Alt3-1'!I49","v":{"v":3532,"d":"3,532"}},{"$f":"'Alt3-1'!I75","v":{"v":893.6748418974544,"d":"894"}},{"$f":"'Alt3-2a'!I49","v":{"v":2664.7999999999997,"d":"2,665"}},{"$f":"'Alt3-2a'!I89","v":{"v":674.5,"d":"675"}},{"$f":"'Alt3-3a'!I49","v":{"v":1981.9876925024657,"d":"1,982"}},{"$f":"'Alt3-3a'!I75","v":{"v":500.88620507899805,"d":"501"}},null,3593,833,4426]
[2016,{"$f":"Indices!B20","v":153704},{"$f":"Indices!C20","v":7826},{"$f":"'Alt1'!G33","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H33","v":710},{"$f":"'Alt2-1'!G50","v":{"v":3429.855690442475,"d":"3,430"}},{"$f":"'Alt2-1'!G76","v":{"v":778.1067077440134,"d":"778"}},{"$f":"'Alt2-2'!D50","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J50","v":710},{"$f":"'Alt2-3'!G50","v":{"v":3429.855690442475,"d":"3,430"}},{"$f":"'Alt2-3'!G76","v":{"v":778.1067077440134,"d":"778"}},{"$f":"'Alt2-4'!G50","v":{"v":1687.2195770900435,"d":"1,687"}},{"$f":"'Alt2-4'!G76","v":{"v":447.1373757176866,"d":"447"}},{"$f":"'Alt3-1'!I50","v":{"v":3429.855690442475,"d":"3,430"}},{"$f":"'Alt3-1'!I76","v":{"v":778.1067077440134,"d":"778"}},{"$f":"'Alt3-2a'!I50","v":{"v":2384.399999999999,"d":"2,384"}},{"$f":"'Alt3-2a'!I90","v":{"v":603.5,"d":"604"}},{"$f":"'Alt3-3a'!I50","v":{"v":1834.7942489849988,"d":"1,835"}},{"$f":"'Alt3-3a'!I76","v":{"v":463.6876061094527,"d":"464"}},null,2805,710,3515]
[2017,{"$f":"Indices!B21","v":126684},{"$f":"Indices!C21","v":7250},{"$f":"'Alt1'!G34","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H34","v":710},{"$f":"'Alt2-1'!G51","v":{"v":2915.3773368761035,"d":"2,915"}},{"$f":"'Alt2-1'!G77","v":{"v":720.8374177286095,"d":"721"}},{"$f":"'Alt2-2'!D51","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J51","v":710},{"$f":"'Alt2-3'!G51","v":{"v":2915.3773368761035,"d":"2,915"}},{"$f":"'Alt2-3'!G77","v":{"v":720.8374177286095,"d":"721"}},{"$f":"'Alt2-4'!G51","v":{"v":1622.2874947486346,"d":"1,622"}},{"$f":"'Alt2-4'!G77","v":{"v":414.22769920179246,"d":"414"}},{"$f":"'Alt3-1'!I51","v":{"v":2915.3773368761035,"d":"2,915"}},{"$f":"'Alt3-1'!I77","v":{"v":720.8374177286095,"d":"721"}},{"$f":"'Alt3-2a'!I51","v":{"v":2103.9999999999995,"d":"2,104"}},{"$f":"'Alt3-2a'!I91","v":{"v":532.5,"d":"533"}},{"$f":"'Alt3-3a'!I51","v":{"v":1591.1312070984761,"d":"1,591"}},{"$f":"'Alt3-3a'!I77","v":{"v":402.10929418035704,"d":"402"}},null,2805,710,3515]
[2018,{"$f":"Indices!B22","v":125702},{"$f":"Indices!C22","v":7141},{"$f":"'Alt1'!G35","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt1'!H35","v":710},{"$f":"'Alt2-1'!G52","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt2-1'!G78","v":710},{"$f":"'Alt2-2'!D52","v":{"v":2025,"d":"2,025"}},{"$f":"'Alt2-2'!J52","v":710},{"$f":"'Alt2-3'!G52","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt2-3'!G78","v":710},{"$f":"'Alt2-4'!G52","v":{"v":1610,"d":"1,610"}},{"$f":"'Alt2-4'!G78","v":408},{"$f":"'Alt3-1'!I52","v":{"v":2805,"d":"2,805"}},{"$f":"'Alt3-1'!I78","v":710},{"$f":"'Alt3-2a'!I52","v":{"v":2103.9999999999995,"d":"2,104"}},{"$f":"'Alt3-2a'!I92","v":{"v":532.5,"d":"533"}},{"$f":"'Alt3-3a'!I52","v":{"v":1563,"d":"1,563"}},{"$f":"'Alt3-3a'!I78","v":395},null,2805,710,{"$f":"SUM(U23:V23)","v":3515}]

{"sheet":"Alt1","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"merged":[[5,0,5,1],[6,3,6,4],[6,6,6,7],[9,0,9,2]]}
["PSC Limit","Primary Index","Second Index",null,null,"Element 1","Element 2","Element 3"]
["Trawl","NA","NA",null,"Gear","Starting point","Ceiling","Floor"]
["Non-trawl","NA","NA",null,"Trawl",2805,"NA","NA"]
[{"$nulls":4},"Non-trawl",710,"NA","NA"]
[{"$nulls":4},"Total",{"$f":"SUM(F3:F4)","v":3515},"NA","NA"]
["Element 4: Breakpoint"]
["Low Threshold","NA",null,"Element 5: slope multiplier",null,null,"Element 6 Constraint"]
["High Threshold","NA",null,"Low Multiplier","NA",null,"Up","NA"]
[{"$nulls":3},"High Multiplier","NA",null,"Down","NA"]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl",2018,"NA",{"$f":"IF(B12=\"Mean\",AVERAGE(B15:B35),VLOOKUP(B12,A15:B35,2))","v":125702}]
["Non-trawl",2018,"NA",{"$f":"IF(B13=\"Mean\",AVERAGE(D15:D35),VLOOKUP(B13,A15:D35,4))","v":7141}]
["Year","Index for Trawl PSC Limit","Standardized","Index for Non-trawl PSC","Standardized",null,"Trawl\nPSC Limit","Non-trawl\nPSC Limit"]
[1998,{"$f":"Indices!B2","v":161256},{"$f":"B15/D$12","v":{"v":1.2828435506197196,"d":"1.2828"}},{"$f":"Indices!C2","v":18502},{"$f":"D15/D$13","v":{"v":2.5909536479484667,"d":"2.5910"}},null,{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"$f":"$F$4","v":710}]
[1999,{"$f":"Indices!B3","v":129116},{"v":1.0271594724029849,"d":"1.0272"},{"$f":"Indices!C3","v":16201},{"$f":"D16/D$13","v":{"v":2.268729869766139,"d":"2.2687"}},null,{"v":2805,"d":"2,805"},710]
[2000,{"$f":"Indices!B4","v":118677},{"v":0.9441138565814386,"d":"0.9441"},{"$f":"Indices!C4","v":16203},{"$f":"D17/D$13","v":{"v":2.2690099425850723,"d":"2.2690"}},null,{"v":2805,"d":"2,805"},710]
[2001,{"$f":"Indices!B5","v":141219},{"v":1.1234427455410416,"d":"1.1234"},{"$f":"Indices!C5","v":13780},{"v":1.9297017224478363,"d":"1.9297"},null,{"v":2805,"d":"2,805"},710]
[2002,{"$f":"Indices!B6","v":101706},{"v":0.8091040715342636,"d":"0.8091"},{"$f":"Indices!C6","v":12104},{"v":1.6950007001820473,"d":"1.6950"},null,{"v":2805,"d":"2,805"},710]
[2003,{"$f":"Indices!B7","v":132151},{"v":1.0513038774243846,"d":"1.0513"},{"$f":"Indices!C7","v":10866},{"v":1.5216356252625682,"d":"1.5216"},null,{"v":2805,"d":"2,805"},710]
[2004,{"$f":"Indices!B8","v":130075},{"v":1.0347886270703728,"d":"1.0348"},{"$f":"Indices!C8","v":9987},{"v":1.3985436213415487,"d":"1.3985"},null,{"v":2805,"d":"2,805"},710]
[2005,{"$f":"Indices!B9","v":132518},{"v":1.054223480931091,"d":"1.0542"},{"$f":"Indices!C9","v":9550},{"v":1.3373477104047051,"d":"1.3373"},null,{"v":2805,"d":"2,805"},710]
[2006,{"$f":"Indices!B10","v":155964},{"v":1.240743981798221,"d":"1.2407"},{"$f":"Indices!C10","v":9802},{"v":1.3726368855902535,"d":"1.3726"},null,{"v":2805,"d":"2,805"},710]
[2007,{"$f":"Indices!B11","v":143903},{"v":1.1447948322222399,"d":"1.1448"},{"$f":"Indices!C11","v":9673},{"v":1.35457218876908,"d":"1.3546"},null,{"v":2805,"d":"2,805"},710]
[2008,{"$f":"Indices!B12","v":140247},{"v":1.1157101716758684,"d":"1.1157"},{"$f":"Indices!C12","v":10264},{"v":1.4373337067637586,"d":"1.4373"},null,{"v":2805,"d":"2,805"},710]
[2009,{"$f":"Indices!B13","v":168102},{"v":1.3373056912380072,"d":"1.3373"},{"$f":"Indices!C13","v":9834},{"v":1.3771180506931802,"d":"1.3771"},null,{"v":2805,"d":"2,805"},710]
[2010,{"$f":"Indices!B14","v":195535},{"v":1.5555440645335794,"d":"1.5555"},{"$f":"Indices!C14","v":9146},{"v":1.280773000980255,"d":"1.2808"},null,{"v":2805,"d":"2,805"},710]
[2011,{"$f":"Indices!B15","v":186666},{"v":1.4849883056753275,"d":"1.4850"},{"$f":"Indices!C15","v":8669},{"v":1.213975633664753,"d":"1.2140"},null,{"v":2805,"d":"2,805"},710]
[2012,{"$f":"Indices!B16","v":189000},{"v":1.503556029339231,"d":"1.5036"},{"$f":"Indices!C16","v":8403},{"v":1.1767259487466741,"d":"1.1767"},null,{"v":2805,"d":"2,805"},710]
[2013,{"$f":"Indices!B17","v":183989},{"v":1.4636919062544749,"d":"1.4637"},{"$f":"Indices!C17","v":7989},{"v":1.1187508752275592,"d":"1.1188"},null,{"v":2805,"d":"2,805"},710]
[2014,{"$f":"Indices!B18","v":171427},{"v":1.3637571399023087,"d":"1.3638"},{"$f":"Indices!C18","v":7995},{"v":1.1195910936843578,"d":"1.1196"},null,{"v":2805,"d":"2,805"},710]
[2015,{"$f":"Indices!B19","v":172237},{"v":1.3702009514566196,"d":"1.3702"},{"$f":"Indices!C19","v":8130},{"v":1.1384960089623302,"d":"1.1385"},null,{"v":2805,"d":"2,805"},710]
[2016,{"$f":"Indices!B20","v":153704},{"v":1.2227649520294028,"d":"1.2228"},{"$f":"Indices!C20","v":7826},{"v":1.095924940484526,"d":"1.0959"},null,{"v":2805,"d":"2,805"},710]
[2017,{"$f":"Indices!B21","v":126684},{"v":1.0078121270942388,"d":"1.0078"},{"$f":"Indices!C21","v":7250},{"v":1.0152639686318443,"d":"1.0153"},null,{"v":2805,"d":"2,805"},710]
[2018,{"$f":"Indices!B22","v":125702},{"v":1,"d":"1.0000"},{"$f":"Indices!C22","v":7141},{"$f":"D35/D$13","v":{"v":1,"d":"1.0000"}},null,{"v":2805,"d":"2,805"},710]
[]
["what-if",100000,{"$f":"B37/$D$12","v":0.7955322906556778},9000,{"$f":"D37/$D$13","v":1.2603276851981515},null,{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"$f":"$F$4","v":710}]
[]
[]
[]
[]
["The \"what-if\" is compleetely adhoc and is not a projection of the index, but an illustration of what may happen if the indices were those values"]
[null,"change the what-if values on the \"Alternatives\" sheet"]

{"sheet":"Alt2-1","index":3,"n_rows":80,"n_cols":16,"rows_kept":80,"merged":[[5,0,5,1],[6,3,6,4],[6,6,6,7],[9,0,9,2]]}
["PSC Limit","Primary Index","Second Index",null,null,"Element 1","Element 2","Element 3"]
["Trawl","Trawl","NA",null,"Gear","Starting point","Ceiling","Floor"]
["Non-trawl","Setline","NA",null,"Trawl",2805,3532,1403]
[{"$nulls":4},"Non-trawl",710,894,355]
[{"$nulls":4},"Total",{"$f":"SUM(F3:F4)","v":3515},{"$f":"SUM(G3:G4)","v":4426},{"$f":"SUM(H3:H4)","v":1758}]
["Element 4: Breakpoint"]
["Low Threshold","NA",null,"Element 5: slope multiplier",null,null,"Element 6 Constraint"]
["High Threshold","NA",null,"Low Multiplier","NA",null,"Up",{"v":0.15,"d":"15%"}]
[{"$nulls":3},"High Multiplier","NA",null,"Down",{"v":0.15,"d":"15%"}]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl",2018,"NA",{"$f":"IF(B12=\"Mean\",AVERAGE(B32:B52),VLOOKUP(B12,A32:D52,2))","v":125702}]
["Non-trawl",2018,"NA",{"$f":"IF(B13=\"Mean\",AVERAGE(B58:B78),VLOOKUP(B13,A58:D78,2))","v":7141}]
{"$rows_empty":16}
["TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",{"$nulls":5},"Floor","Ceiling"]
[1998,{"$f":"IF($B$2=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"B32/D$12","v":{"v":1.2828435506197196,"d":"1.2828"}},null,{"$f":"MIN($G$3,MAX($H$3,(1-(1-C32)*1)*$F$3))","v":{"v":3532,"d":"3,532"}},null,{"$f":"E32","v":{"v":3532,"d":"3,532"}},{"$nulls":7},{"$f":"$H$3","v":1403},{"$f":"$G$3","v":3532}]
[1999,{"$f":"IF($B$2=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"v":1.0271594724029849,"d":"1.0272"},null,{"v":2881.1823200903727,"d":"2,881"},{"$f":"(E33-E32)/E32","v":{"v":-0.18426321628245393,"d":"-18%"}},{"$f":"IF(H33>0,IF(ABS(H33)>$H$8,G32*(1+SIGN(H33)*$H$8),E33),IF(ABS(H33)>$H$9,G32*(1+SIGN(H33)*$H$9),E33))","v":{"v":3002.2,"d":"3,002"}},{"$f":"(E33-G32)/G32","v":{"v":-0.18426321628245393,"d":"-18%"}},{"$f":"(G33-G32)/G32","v":{"v":-0.15000000000000005,"d":"-15%"}},{"$nulls":5},1403,3532]
[2000,{"$f":"IF($B$2=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.9441138565814386,"d":"0.9441"},null,{"v":2648.2393677109353,"d":"2,648"},{"$f":"(E34-E33)/E33","v":{"v":-0.08084977849375767,"d":"-8%"}},{"v":2648.2393677109353,"d":"2,648"},{"v":-0.1179004171237974,"d":"-12%"},{"$f":"(G34-G33)/G33","v":{"v":-0.1179004171237974,"d":"-12%"}},{"$nulls":5},1403,3532]
[2001,{"$f":"IF($B$2=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":1.1234427455410416,"d":"1.1234"},null,{"v":3151.2569012426216,"d":"3,151"},{"v":0.18994413407821237,"d":"19%"},{"v":3045.4752728675753,"d":"3,045"},{"v":0.18994413407821237,"d":"19%"},{"$f":"(G35-G34)/G34","v":{"v":0.14999999999999988,"d":"15%"}},{"$nulls":5},1403,3532]
[2002,{"$f":"IF($B$2=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.8091040715342636,"d":"0.8091"},null,{"v":2269.5369206536093,"d":"2,270"},{"v":-0.27979946041255077,"d":"-28%"},{"v":2588.653981937439,"d":"2,589"},{"v":-0.25478399352865333,"d":"-25%"},{"v":-0.15000000000000005,"d":"-15%"},{"$nulls":5},1403,3532]
[2003,{"$f":"IF($B$2=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":1.0513038774243846,"d":"1.0513"},null,{"v":2948.907376175399,"d":"2,949"},{"v":0.29934320492399663,"d":"30%"},{"v":2948.907376175399,"d":"2,949"},{"v":0.13916629906957817,"d":"14%"},{"v":0.13916629906957817,"d":"14%"},{"$nulls":5},1403,3532]
[2004,{"$f":"IF($B$2=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":1.0347886270703728,"d":"1.0348"},null,{"v":2902.5820989323956,"d":"2,903"},{"v":-0.015709302237591833,"d":"-2%"},{"v":2902.5820989323956,"d":"2,903"},{"v":-0.015709302237591833,"d":"-2%"},{"v":-0.015709302237591833,"d":"-2%"},{"$nulls":5},1403,3532]
[2005,{"$f":"IF($B$2=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":1.054223480931091,"d":"1.0542"},null,{"v":2957.0968640117103,"d":"2,957"},{"v":0.018781472227561054,"d":"2%"},{"v":2957.0968640117103,"d":"2,957"},{"v":0.018781472227561054,"d":"2%"},{"v":0.018781472227561054,"d":"2%"},{"$nulls":5},1403,3532]
[2006,{"$f":"IF($B$2=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.240743981798221,"d":"1.2407"},null,{"v":3480.28686894401,"d":"3,480"},{"v":0.17692690804268088,"d":"18%"},{"v":3400.6613936134668,"d":"3,401"},{"v":0.17692690804268088,"d":"18%"},{"v":0.14999999999999997,"d":"15%"},{"$nulls":5},1403,3532]
[2007,{"$f":"IF($B$2=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":1.1447948322222399,"d":"1.1448"},null,{"v":3211.149504383383,"d":"3,211"},{"v":-0.07733194839834827,"d":"-8%"},{"v":3211.149504383383,"d":"3,211"},{"v":-0.05572795032930719,"d":"-6%"},{"v":-0.05572795032930719,"d":"-6%"},{"$nulls":5},1403,3532]
[2008,{"$f":"IF($B$2=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":1.1157101716758684,"d":"1.1157"},null,{"v":3129.567031550811,"d":"3,130"},{"v":-0.025406002654565826,"d":"-3%"},{"v":3129.567031550811,"d":"3,130"},{"v":-0.025406002654565826,"d":"-3%"},{"v":-0.025406002654565826,"d":"-3%"},{"$nulls":5},1403,3532]
[2009,{"$f":"IF($B$2=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.3373056912380072,"d":"1.3373"},null,{"v":3532,"d":"3,532"},{"v":0.12859062112811473,"d":"13%"},{"v":3532,"d":"3,532"},{"v":0.12859062112811473,"d":"13%"},{"v":0.12859062112811473,"d":"13%"},{"$nulls":5},1403,3532]
[2010,{"$f":"IF($B$2=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.5555440645335794,"d":"1.5555"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1403,3532]
[2011,{"$f":"IF($B$2=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.4849883056753275,"d":"1.4850"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1403,3532]
[2012,{"$f":"IF($B$2=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.503556029339231,"d":"1.5036"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1403,3532]
[2013,{"$f":"IF($B$2=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.4636919062544749,"d":"1.4637"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1403,3532]
[2014,{"$f":"IF($B$2=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.3637571399023087,"d":"1.3638"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1403,3532]
[2015,{"$f":"IF($B$2=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.3702009514566196,"d":"1.3702"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1403,3532]
[2016,{"$f":"IF($B$2=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.2227649520294028,"d":"1.2228"},null,{"v":3429.855690442475,"d":"3,430"},{"v":-0.028919679942674137,"d":"-3%"},{"v":3429.855690442475,"d":"3,430"},{"v":-0.028919679942674137,"d":"-3%"},{"v":-0.028919679942674137,"d":"-3%"},{"$nulls":5},1403,3532]
[2017,{"$f":"IF($B$2=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":1.0078121270942388,"d":"1.0078"},null,{"v":2826.91301649934,"d":"2,827"},{"v":-0.17579243220735954,"d":"-18%"},{"v":2915.3773368761035,"d":"2,915"},{"v":-0.17579243220735954,"d":"-18%"},{"v":-0.15000000000000005,"d":"-15%"},{"$nulls":5},1403,3532]
[2018,{"$f":"IF($B$2=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":1,"d":"1.0000"},null,{"v":2805,"d":"2,805"},{"v":-0.007751570837674893,"d":"-1%"},{"v":2805,"d":"2,805"},{"v":-0.03786039476947278,"d":"-4%"},{"v":-0.03786039476947278,"d":"-4%"}]
[]
["what-if",100000,{"$f":"B54/$D$12","v":0.7955322906556778},null,{"$f":"MIN($G$3,MAX($H$3,(1-(1-C54)*1)*$F$3))","v":{"v":2231.4680752891763,"d":"2,231"}},{"$f":"(E54-E51)/E51","v":{"v":-0.2106343342489974,"d":"-21%"}},{"$f":"IF(ABS(H54)>$H$8,G51*(1+SIGN(H54)*$H$8),E54)","v":{"v":2478.070736344688,"d":"2,478"}},{"$f":"(E54-G51)/G51","v":{"v":-0.23458687592040908,"d":"-23%"}},{"$f":"(G54-G51)/G51","v":{"v":-0.14999999999999994,"d":"-15%"}}]
[]
["NON-TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",{"$nulls":5},"Floor","Ceiling"]
[1998,{"$f":"IF($B$3=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B58/D$13","v":{"v":2.5909536479484667,"d":"2.5910"}},null,{"$f":"MIN($G$4,MAX($H$4,(1-(1-C58)*1)*$F$4))","v":894},null,{"$f":"E58","v":894},{"$nulls":7},{"$f":"$H$4","v":355},{"$f":"$G$4","v":894}]
[1999,{"$f":"IF($B$3=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"B59/D$13","v":{"v":2.268729869766139,"d":"2.2687"}},null,894,{"$f":"(E59-E58)/E58","v":{"v":0,"d":"0%"}},{"$f":"IF(H59>0,IF(ABS(H59)>$H$8,G58*(1+SIGN(H59)*$H$8),E59),IF(ABS(H59)>$H$9,G58*(1+SIGN(H59)*$H$9),E59))","v":894},{"$f":"(E59-G58)/G58","v":{"v":0,"d":"0%"}},{"$f":"(G59-G58)/G58","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"$H$4","v":355},{"$f":"$G$4","v":894}]
[2000,{"$f":"IF($B$3=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},null,894,{"$f":"(E60-E59)/E59","v":{"v":0,"d":"0%"}},894,{"v":0,"d":"0%"},{"$f":"(G60-G59)/G59","v":{"v":0,"d":"0%"}},{"$nulls":5},355,894]
[2001,{"$f":"IF($B$3=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"$f":"(G61-G60)/G60","v":{"v":0,"d":"0%"}},{"$nulls":5},355,894]
[2002,{"$f":"IF($B$3=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2003,{"$f":"IF($B$3=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2004,{"$f":"IF($B$3=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2005,{"$f":"IF($B$3=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2006,{"$f":"IF($B$3=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2007,{"$f":"IF($B$3=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2008,{"$f":"IF($B$3=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2009,{"$f":"IF($B$3=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2010,{"$f":"IF($B$3=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},355,894]
[2011,{"$f":"IF($B$3=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},null,{"v":861.9226999019746,"d":"862"},{"v":-0.035880648879223015,"d":"-4%"},{"v":861.9226999019746,"d":"862"},{"v":-0.035880648879223015,"d":"-4%"},{"v":-0.035880648879223015,"d":"-4%"},{"$nulls":5},355,894]
[2012,{"$f":"IF($B$3=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},null,{"v":835.4754236101386,"d":"835"},{"v":-0.030684046602837873,"d":"-3%"},{"v":835.4754236101386,"d":"835"},{"v":-0.030684046602837873,"d":"-3%"},{"v":-0.030684046602837873,"d":"-3%"},{"$nulls":5},355,894]
[2013,{"$f":"IF($B$3=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},null,{"v":794.3131214115671,"d":"794"},{"v":-0.04926811852909663,"d":"-5%"},{"v":794.3131214115671,"d":"794"},{"v":-0.04926811852909663,"d":"-5%"},{"v":-0.04926811852909663,"d":"-5%"},{"$nulls":5},355,894]
[2014,{"$f":"IF($B$3=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},null,{"v":794.909676515894,"d":"795"},{"v":7.5103266992094251E-4,"d":"0%"},{"v":794.909676515894,"d":"795"},{"v":7.5103266992094251E-4,"d":"0%"},{"v":7.5103266992094251E-4,"d":"0%"},{"$nulls":5},355,894]
[2015,{"$f":"IF($B$3=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},null,{"v":808.3321663632544,"d":"808"},{"v":0.016885553470919357,"d":"2%"},{"v":808.3321663632544,"d":"808"},{"v":0.016885553470919357,"d":"2%"},{"v":0.016885553470919357,"d":"2%"},{"$nulls":5},355,894]
[2016,{"$f":"IF($B$3=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},null,{"v":778.1067077440134,"d":"778"},{"v":-0.03739237392373918,"d":"-4%"},{"v":778.1067077440134,"d":"778"},{"v":-0.03739237392373918,"d":"-4%"},{"v":-0.03739237392373918,"d":"-4%"},{"$nulls":5},355,894]
[2017,{"$f":"IF($B$3=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},null,{"v":720.8374177286095,"d":"721"},{"v":-0.07360081778686424,"d":"-7%"},{"v":720.8374177286095,"d":"721"},{"v":-0.07360081778686424,"d":"-7%"},{"v":-0.07360081778686424,"d":"-7%"},{"$nulls":5},355,894]
[2018,{"$f":"IF($B$3=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},null,710,{"v":-0.015034482758620727,"d":"-2%"},710,{"v":-0.015034482758620727,"d":"-2%"},{"v":-0.015034482758620727,"d":"-2%"},{"$nulls":5},355,894]
[]
["what-if",9000,{"v":1.2603276851981515,"d":"1.2603"},null,{"$f":"MIN($G$4,MAX($H$4,(1-(1-C80)*1)*$F$4))","v":894},{"$f":"(E80-E77)/E77","v":{"v":0.2402241864983001,"d":"24%"}},{"$f":"IF(ABS(H80)>$H$8,G77*(1+SIGN(H80)*$H$8),E80)","v":{"v":828.9630303879009,"d":"829"}},{"$f":"(E80-G77)/G77","v":{"v":0.2402241864983001,"d":"24%"}},{"$f":"(G80-G77)/G77","v":{"v":0.14999999999999997,"d":"15%"}}]

{"sheet":"Alt2-2","index":4,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,4,0,5],[10,0,10,2],[29,6,29,7]]}
["PSC Limit","Primary Index","Second Index",null,"Scenario"]
["Trawl","Trawl","NA",null,"Scenario","B"]
["Non-trawl","Setline","NA"]
[]
["Trawl Survey\nIndex Breakpoints",0,100000,124000,175000,200000]
["Non-Trawl Survey\nIndex Breakpoints",{"$f":"B7*$D$14","v":0},{"$f":"C7*$D$14","v":{"v":5680.896087572195,"d":"5681"}},{"v":7044.3111485895215,"d":"7044"},{"v":9941.56815325134,"d":"9942"},{"v":11361.79217514439,"d":"11362"},"Determined from trawl breakpoints"]
["Standardized",{"$f":"B5/$D$13","v":0},{"$f":"C5/$D$13","v":0.7955322906556778},{"$f":"D5/$D$13","v":0.9864600404130404},{"$f":"E5/$D$13","v":1.392181508647436},{"$f":"F5/$D$13","v":1.5910645813113555}]
["Trawl PSC Limit",1412,1745,2025,2325,2325]
["Non-trawl PSC Limit",475,525,710,894,894]
[]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl",2018,"NA",{"$f":"IF(B13=\"Mean\",AVERAGE(B32:B52),VLOOKUP(B13,A32:D52,2))","v":125702}]
["Non-trawl",2018,"NA",{"$f":"IF(B14=\"Mean\",AVERAGE(H32:H52),VLOOKUP(B14,G32:J52,2))","v":7141}]
{"$rows_empty":15}
["TRAWL PSC LIMIT",{"$nulls":5},"NON-TRAWL PSC LIMIT"]
["Year","Index","Two-year average","PSC Limit","floor","ceiling","Year","Index","Two-year average","PSC Limit","floor","ceiling"]
[1998,{"$f":"IF($B$2=\"Trawl\",Indices!B2,Indices!C2)","v":{"v":161256,"d":"161,256"}},{"$f":"B32","v":{"v":161256,"d":"161,256"}},{"$f":"HLOOKUP(C32,$B$5:$F$9,4,TRUE)","v":{"v":2025,"d":"2,025"}},{"$f":"$B$8","v":1412},{"$f":"$F$8","v":2325},1998,{"$f":"IF($C$2=\"Trawl\",Indices!B2,Indices!C2)","v":{"v":18502,"d":"18,502"}},{"$f":"H32","v":{"v":18502,"d":"18,502"}},{"$f":"HLOOKUP(I32/$D$14,$B$7:$F$9,3,TRUE)","v":894},{"$f":"$B$9","v":475},{"$f":"$F$9","v":894}]
[1999,{"$f":"IF($B$2=\"Trawl\",Indices!B3,Indices!C3)","v":{"v":129116,"d":"129,116"}},{"$f":"AVERAGE(B32,B33)","v":{"v":145186,"d":"145,186"}},{"$f":"HLOOKUP(C33,$B$5:$F$9,4,TRUE)","v":{"v":2025,"d":"2,025"}},{"$f":"$B$8","v":1412},{"$f":"$F$8","v":2325},1999,{"$f":"IF($C$2=\"Trawl\",Indices!B3,Indices!C3)","v":{"v":16201,"d":"16,201"}},{"$f":"AVERAGE(H32,H33)","v":{"v":17351.5,"d":"17,352"}},{"$f":"HLOOKUP(I33/$D$14,$B$7:$F$9,3,TRUE)","v":894},{"$f":"$B$9","v":475},{"$f":"$F$9","v":894}]
[2000,{"$f":"IF($B$2=\"Trawl\",Indices!B4,Indices!C4)","v":{"v":118677,"d":"118,677"}},{"$f":"AVERAGE(B33,B34)","v":{"v":123896.5,"d":"123,897"}},{"v":1745,"d":"1,745"},1412,2325,2000,{"$f":"IF($C$2=\"Trawl\",Indices!B4,Indices!C4)","v":{"v":16203,"d":"16,203"}},{"$f":"AVERAGE(H33,H34)","v":{"v":16202,"d":"16,202"}},894,475,894]
[2001,{"$f":"IF($B$2=\"Trawl\",Indices!B5,Indices!C5)","v":{"v":141219,"d":"141,219"}},{"v":129948,"d":"129,948"},{"v":2025,"d":"2,025"},1412,2325,2001,{"$f":"IF($C$2=\"Trawl\",Indices!B5,Indices!C5)","v":{"v":13780,"d":"13,780"}},{"v":14991.5,"d":"14,992"},894,475,894]
[2002,{"$f":"IF($B$2=\"Trawl\",Indices!B6,Indices!C6)","v":{"v":101706,"d":"101,706"}},{"v":121462.5,"d":"121,463"},{"v":1745,"d":"1,745"},1412,2325,2002,{"$f":"IF($C$2=\"Trawl\",Indices!B6,Indices!C6)","v":{"v":12104,"d":"12,104"}},{"v":12942,"d":"12,942"},894,475,894]
[2003,{"$f":"IF($B$2=\"Trawl\",Indices!B7,Indices!C7)","v":{"v":132151,"d":"132,151"}},{"v":116928.5,"d":"116,929"},{"v":1745,"d":"1,745"},1412,2325,2003,{"$f":"IF($C$2=\"Trawl\",Indices!B7,Indices!C7)","v":{"v":10866,"d":"10,866"}},{"v":11485,"d":"11,485"},894,475,894]
[2004,{"$f":"IF($B$2=\"Trawl\",Indices!B8,Indices!C8)","v":{"v":130075,"d":"130,075"}},{"v":131113,"d":"131,113"},{"v":2025,"d":"2,025"},1412,2325,2004,{"$f":"IF($C$2=\"Trawl\",Indices!B8,Indices!C8)","v":{"v":9987,"d":"9,987"}},{"v":10426.5,"d":"10,427"},894,475,894]
[2005,{"$f":"IF($B$2=\"Trawl\",Indices!B9,Indices!C9)","v":{"v":132518,"d":"132,518"}},{"v":131296.5,"d":"131,297"},{"v":2025,"d":"2,025"},1412,2325,2005,{"$f":"IF($C$2=\"Trawl\",Indices!B9,Indices!C9)","v":{"v":9550,"d":"9,550"}},{"v":9768.5,"d":"9,769"},710,475,894]
[2006,{"$f":"IF($B$2=\"Trawl\",Indices!B10,Indices!C10)","v":{"v":155964,"d":"155,964"}},{"v":144241,"d":"144,241"},{"v":2025,"d":"2,025"},1412,2325,2006,{"$f":"IF($C$2=\"Trawl\",Indices!B10,Indices!C10)","v":{"v":9802,"d":"9,802"}},{"v":9676,"d":"9,676"},710,475,894]
[2007,{"$f":"IF($B$2=\"Trawl\",Indices!B11,Indices!C11)","v":{"v":143903,"d":"143,903"}},{"v":149933.5,"d":"149,934"},{"v":2025,"d":"2,025"},1412,2325,2007,{"$f":"IF($C$2=\"Trawl\",Indices!B11,Indices!C11)","v":{"v":9673,"d":"9,673"}},{"v":9737.5,"d":"9,738"},710,475,894]
[2008,{"$f":"IF($B$2=\"Trawl\",Indices!B12,Indices!C12)","v":{"v":140247,"d":"140,247"}},{"v":142075,"d":"142,075"},{"v":2025,"d":"2,025"},1412,2325,2008,{"$f":"IF($C$2=\"Trawl\",Indices!B12,Indices!C12)","v":{"v":10264,"d":"10,264"}},{"v":9968.5,"d":"9,969"},894,475,894]
[2009,{"$f":"IF($B$2=\"Trawl\",Indices!B13,Indices!C13)","v":{"v":168102,"d":"168,102"}},{"v":154174.5,"d":"154,175"},{"v":2025,"d":"2,025"},1412,2325,2009,{"$f":"IF($C$2=\"Trawl\",Indices!B13,Indices!C13)","v":{"v":9834,"d":"9,834"}},{"v":10049,"d":"10,049"},894,475,894]
[2010,{"$f":"IF($B$2=\"Trawl\",Indices!B14,Indices!C14)","v":{"v":195535,"d":"195,535"}},{"v":181818.5,"d":"181,819"},{"v":2325,"d":"2,325"},1412,2325,2010,{"$f":"IF($C$2=\"Trawl\",Indices!B14,Indices!C14)","v":{"v":9146,"d":"9,146"}},{"v":9490,"d":"9,490"},710,475,894]
[2011,{"$f":"IF($B$2=\"Trawl\",Indices!B15,Indices!C15)","v":{"v":186666,"d":"186,666"}},{"v":191100.5,"d":"191,101"},{"v":2325,"d":"2,325"},1412,2325,2011,{"$f":"IF($C$2=\"Trawl\",Indices!B15,Indices!C15)","v":{"v":8669,"d":"8,669"}},{"v":8907.5,"d":"8,908"},710,475,894]
[2012,{"$f":"IF($B$2=\"Trawl\",Indices!B16,Indices!C16)","v":{"v":189000,"d":"189,000"}},{"v":187833,"d":"187,833"},{"v":2325,"d":"2,325"},1412,2325,2012,{"$f":"IF($C$2=\"Trawl\",Indices!B16,Indices!C16)","v":{"v":8403,"d":"8,403"}},{"v":8536,"d":"8,536"},710,475,894]
[2013,{"$f":"IF($B$2=\"Trawl\",Indices!B17,Indices!C17)","v":{"v":183989,"d":"183,989"}},{"v":186494.5,"d":"186,495"},{"v":2325,"d":"2,325"},1412,2325,2013,{"$f":"IF($C$2=\"Trawl\",Indices!B17,Indices!C17)","v":{"v":7989,"d":"7,989"}},{"v":8196,"d":"8,196"},710,475,894]
[2014,{"$f":"IF($B$2=\"Trawl\",Indices!B18,Indices!C18)","v":{"v":171427,"d":"171,427"}},{"v":177708,"d":"177,708"},{"v":2325,"d":"2,325"},1412,2325,2014,{"$f":"IF($C$2=\"Trawl\",Indices!B18,Indices!C18)","v":{"v":7995,"d":"7,995"}},{"v":7992,"d":"7,992"},710,475,894]
[2015,{"$f":"IF($B$2=\"Trawl\",Indices!B19,Indices!C19)","v":{"v":172237,"d":"172,237"}},{"v":171832,"d":"171,832"},{"v":2025,"d":"2,025"},1412,2325,2015,{"$f":"IF($C$2=\"Trawl\",Indices!B19,Indices!C19)","v":{"v":8130,"d":"8,130"}},{"v":8062.5,"d":"8,063"},710,475,894]
[2016,{"$f":"IF($B$2=\"Trawl\",Indices!B20,Indices!C20)","v":{"v":153704,"d":"153,704"}},{"v":162970.5,"d":"162,971"},{"v":2025,"d":"2,025"},1412,2325,2016,{"$f":"IF($C$2=\"Trawl\",Indices!B20,Indices!C20)","v":{"v":7826,"d":"7,826"}},{"v":7978,"d":"7,978"},710,475,894]
[2017,{"$f":"IF($B$2=\"Trawl\",Indices!B21,Indices!C21)","v":{"v":126684,"d":"126,684"}},{"v":140194,"d":"140,194"},{"v":2025,"d":"2,025"},1412,2325,2017,{"$f":"IF($C$2=\"Trawl\",Indices!B21,Indices!C21)","v":{"v":7250,"d":"7,250"}},{"v":7538,"d":"7,538"},710,475,894]
[2018,{"$f":"IF($B$2=\"Trawl\",Indices!B22,Indices!C22)","v":{"v":125702,"d":"125,702"}},{"v":126193,"d":"126,193"},{"v":2025,"d":"2,025"},1412,2325,2018,{"$f":"IF($C$2=\"Trawl\",Indices!B22,Indices!C22)","v":{"v":7141,"d":"7,141"}},{"v":7195.5,"d":"7,196"},710,475,894]
[]
["what-if",100000,{"$f":"B54","v":{"v":100000,"d":"100,000"}},{"$f":"HLOOKUP(C54,$B$5:$F$9,4,TRUE)","v":{"v":1745,"d":"1,745"}},null,null,"what-if",9000,{"$f":"H54","v":{"v":9000,"d":"9,000"}},{"$f":"HLOOKUP(I54,$B$5:$F$9,4,TRUE)","v":{"v":1412,"d":"1,412"}}]

{"sheet":"Alt2-3","index":5,"n_rows":80,"n_cols":16,"rows_kept":80,"merged":[[5,0,5,1],[6,3,6,4],[6,6,6,7],[9,0,9,2]]}
["PSC Limit","Primary Index","Second Index",null,null,"Element 1","Element 2","Element 3"]
["Trawl","Trawl","NA",null,"Gear","Starting point","Ceiling","Floor"]
["Non-trawl","Setline","NA",null,"Trawl",2805,3532,1879]
[{"$nulls":4},"Non-trawl",710,894,475]
[{"$nulls":4},"Total",{"$f":"SUM(F3:F4)","v":3515},{"$f":"SUM(G3:G4)","v":4426},{"$f":"SUM(H3:H4)","v":2354}]
["Element 4: Breakpoint"]
["Low Threshold","NA",null,"Element 5: slope multiplier",null,null,"Element 6 Constraint"]
["High Threshold","NA",null,"Low Multiplier","NA",null,"Up",{"v":0.15,"d":"15%"}]
[{"$nulls":3},"High Multiplier","NA",null,"Down",{"v":0.15,"d":"15%"}]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl",2018,null,{"$f":"VLOOKUP(B12,A32:D52,2)","v":125702},{"$f":"IF(C12=\"Mean\",AVERAGE(D32:D52),VLOOKUP(C12,A32:D52,4))","v":{"$error":"#N/A"}}]
["Non-trawl",2018,null,{"$f":"VLOOKUP(B13,A58:D78,2)","v":7141},{"$f":"IF(C13=\"Mean\",AVERAGE(D58:D78),VLOOKUP(C13,A58:D78,4))","v":{"$error":"#N/A"}}]
{"$rows_empty":16}
["TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",{"$nulls":5},"Floor","Ceiling"]
[1998,{"$f":"IF($B$2=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"B32/D$12","v":{"v":1.2828435506197196,"d":"1.2828"}},null,{"$f":"MIN($G$3,MAX($H$3,(1-(1-C32)*1)*$F$3))","v":{"v":3532,"d":"3,532"}},null,{"$f":"E32","v":{"v":3532,"d":"3,532"}},{"$nulls":7},{"$f":"$H$3","v":1879},{"$f":"$G$3","v":3532}]
[1999,{"$f":"IF($B$2=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"v":1.0271594724029849,"d":"1.0272"},null,{"v":2881.1823200903727,"d":"2,881"},{"$f":"(E33-E32)/E32","v":{"v":-0.18426321628245393,"d":"-18%"}},{"$f":"IF(H33>0,IF(ABS(H33)>$H$8,G32*(1+SIGN(H33)*$H$8),E33),IF(ABS(H33)>$H$9,G32*(1+SIGN(H33)*$H$9),E33))","v":{"v":3002.2,"d":"3,002"}},{"$f":"(E33-G32)/G32","v":{"v":-0.18426321628245393,"d":"-18%"}},{"$f":"(G33-G32)/G32","v":{"v":-0.15000000000000005,"d":"-15%"}},{"$nulls":5},1879,3532]
[2000,{"$f":"IF($B$2=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.9441138565814386,"d":"0.9441"},null,{"v":2648.2393677109353,"d":"2,648"},{"$f":"(E34-E33)/E33","v":{"v":-0.08084977849375767,"d":"-8%"}},{"v":2648.2393677109353,"d":"2,648"},{"v":-0.1179004171237974,"d":"-12%"},{"$f":"(G34-G33)/G33","v":{"v":-0.1179004171237974,"d":"-12%"}},{"$nulls":5},1879,3532]
[2001,{"$f":"IF($B$2=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":1.1234427455410416,"d":"1.1234"},null,{"v":3151.2569012426216,"d":"3,151"},{"v":0.18994413407821237,"d":"19%"},{"v":3045.4752728675753,"d":"3,045"},{"v":0.18994413407821237,"d":"19%"},{"$f":"(G35-G34)/G34","v":{"v":0.14999999999999988,"d":"15%"}},{"$nulls":5},1879,3532]
[2002,{"$f":"IF($B$2=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.8091040715342636,"d":"0.8091"},null,{"v":2269.5369206536093,"d":"2,270"},{"v":-0.27979946041255077,"d":"-28%"},{"v":2588.653981937439,"d":"2,589"},{"v":-0.25478399352865333,"d":"-25%"},{"v":-0.15000000000000005,"d":"-15%"},{"$nulls":5},1879,3532]
[2003,{"$f":"IF($B$2=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":1.0513038774243846,"d":"1.0513"},null,{"v":2948.907376175399,"d":"2,949"},{"v":0.29934320492399663,"d":"30%"},{"v":2948.907376175399,"d":"2,949"},{"v":0.13916629906957817,"d":"14%"},{"v":0.13916629906957817,"d":"14%"},{"$nulls":5},1879,3532]
[2004,{"$f":"IF($B$2=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":1.0347886270703728,"d":"1.0348"},null,{"v":2902.5820989323956,"d":"2,903"},{"v":-0.015709302237591833,"d":"-2%"},{"v":2902.5820989323956,"d":"2,903"},{"v":-0.015709302237591833,"d":"-2%"},{"v":-0.015709302237591833,"d":"-2%"},{"$nulls":5},1879,3532]
[2005,{"$f":"IF($B$2=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":1.054223480931091,"d":"1.0542"},null,{"v":2957.0968640117103,"d":"2,957"},{"v":0.018781472227561054,"d":"2%"},{"v":2957.0968640117103,"d":"2,957"},{"v":0.018781472227561054,"d":"2%"},{"v":0.018781472227561054,"d":"2%"},{"$nulls":5},1879,3532]
[2006,{"$f":"IF($B$2=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.240743981798221,"d":"1.2407"},null,{"v":3480.28686894401,"d":"3,480"},{"v":0.17692690804268088,"d":"18%"},{"v":3400.6613936134668,"d":"3,401"},{"v":0.17692690804268088,"d":"18%"},{"v":0.14999999999999997,"d":"15%"},{"$nulls":5},1879,3532]
[2007,{"$f":"IF($B$2=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":1.1447948322222399,"d":"1.1448"},null,{"v":3211.149504383383,"d":"3,211"},{"v":-0.07733194839834827,"d":"-8%"},{"v":3211.149504383383,"d":"3,211"},{"v":-0.05572795032930719,"d":"-6%"},{"v":-0.05572795032930719,"d":"-6%"},{"$nulls":5},1879,3532]
[2008,{"$f":"IF($B$2=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":1.1157101716758684,"d":"1.1157"},null,{"v":3129.567031550811,"d":"3,130"},{"v":-0.025406002654565826,"d":"-3%"},{"v":3129.567031550811,"d":"3,130"},{"v":-0.025406002654565826,"d":"-3%"},{"v":-0.025406002654565826,"d":"-3%"},{"$nulls":5},1879,3532]
[2009,{"$f":"IF($B$2=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.3373056912380072,"d":"1.3373"},null,{"v":3532,"d":"3,532"},{"v":0.12859062112811473,"d":"13%"},{"v":3532,"d":"3,532"},{"v":0.12859062112811473,"d":"13%"},{"v":0.12859062112811473,"d":"13%"},{"$nulls":5},1879,3532]
[2010,{"$f":"IF($B$2=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.5555440645335794,"d":"1.5555"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1879,3532]
[2011,{"$f":"IF($B$2=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.4849883056753275,"d":"1.4850"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1879,3532]
[2012,{"$f":"IF($B$2=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.503556029339231,"d":"1.5036"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1879,3532]
[2013,{"$f":"IF($B$2=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.4636919062544749,"d":"1.4637"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1879,3532]
[2014,{"$f":"IF($B$2=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.3637571399023087,"d":"1.3638"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1879,3532]
[2015,{"$f":"IF($B$2=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.3702009514566196,"d":"1.3702"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},1879,3532]
[2016,{"$f":"IF($B$2=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.2227649520294028,"d":"1.2228"},null,{"v":3429.855690442475,"d":"3,430"},{"v":-0.028919679942674137,"d":"-3%"},{"v":3429.855690442475,"d":"3,430"},{"v":-0.028919679942674137,"d":"-3%"},{"v":-0.028919679942674137,"d":"-3%"},{"$nulls":5},1879,3532]
[2017,{"$f":"IF($B$2=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":1.0078121270942388,"d":"1.0078"},null,{"v":2826.91301649934,"d":"2,827"},{"v":-0.17579243220735954,"d":"-18%"},{"v":2915.3773368761035,"d":"2,915"},{"v":-0.17579243220735954,"d":"-18%"},{"v":-0.15000000000000005,"d":"-15%"},{"$nulls":5},1879,3532]
[2018,{"$f":"IF($B$2=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":1,"d":"1.0000"},null,{"v":2805,"d":"2,805"},{"v":-0.007751570837674893,"d":"-1%"},{"v":2805,"d":"2,805"},{"v":-0.03786039476947278,"d":"-4%"},{"v":-0.03786039476947278,"d":"-4%"}]
[]
["what-if",100000,{"$f":"B54/$D$12","v":0.7955322906556778},null,{"$f":"MIN($G$3,MAX($H$3,(1-(1-C54)*1)*$F$3))","v":{"v":2231.4680752891763,"d":"2,231"}},{"$f":"(E54-E51)/E51","v":{"v":-0.2106343342489974,"d":"-21%"}},{"$f":"IF(ABS(H54)>$H$8,G51*(1+SIGN(H54)*$H$8),E54)","v":{"v":2478.070736344688,"d":"2,478"}},{"$f":"(E54-G51)/G51","v":{"v":-0.23458687592040908,"d":"-23%"}},{"$f":"(G54-G51)/G51","v":{"v":-0.14999999999999994,"d":"-15%"}}]
[]
["NON-TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",{"$nulls":5},"Floor","Ceiling"]
[1998,{"$f":"IF($B$3=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B58/D$13","v":{"v":2.5909536479484667,"d":"2.5910"}},null,{"$f":"MIN($G$4,MAX($H$4,(1-(1-C58)*1)*$F$4))","v":894},null,{"$f":"E58","v":894},{"$nulls":7},{"$f":"$H$4","v":475},{"$f":"$G$4","v":894}]
[1999,{"$f":"IF($B$3=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"B59/D$13","v":{"v":2.268729869766139,"d":"2.2687"}},null,894,{"$f":"(E59-E58)/E58","v":{"v":0,"d":"0%"}},{"$f":"IF(H59>0,IF(ABS(H59)>$H$8,G58*(1+SIGN(H59)*$H$8),E59),IF(ABS(H59)>$H$9,G58*(1+SIGN(H59)*$H$9),E59))","v":894},{"$f":"(E59-G58)/G58","v":{"v":0,"d":"0%"}},{"$f":"(G59-G58)/G58","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"$H$4","v":475},{"$f":"$G$4","v":894}]
[2000,{"$f":"IF($B$3=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},null,894,{"$f":"(E60-E59)/E59","v":{"v":0,"d":"0%"}},894,{"v":0,"d":"0%"},{"$f":"(G60-G59)/G59","v":{"v":0,"d":"0%"}},{"$nulls":5},475,894]
[2001,{"$f":"IF($B$3=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"$f":"(G61-G60)/G60","v":{"v":0,"d":"0%"}},{"$nulls":5},475,894]
[2002,{"$f":"IF($B$3=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2003,{"$f":"IF($B$3=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2004,{"$f":"IF($B$3=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2005,{"$f":"IF($B$3=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2006,{"$f":"IF($B$3=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2007,{"$f":"IF($B$3=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2008,{"$f":"IF($B$3=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2009,{"$f":"IF($B$3=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2010,{"$f":"IF($B$3=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$nulls":5},475,894]
[2011,{"$f":"IF($B$3=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},null,{"v":861.9226999019746,"d":"862"},{"v":-0.035880648879223015,"d":"-4%"},{"v":861.9226999019746,"d":"862"},{"v":-0.035880648879223015,"d":"-4%"},{"v":-0.035880648879223015,"d":"-4%"},{"$nulls":5},475,894]
[2012,{"$f":"IF($B$3=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},null,{"v":835.4754236101386,"d":"835"},{"v":-0.030684046602837873,"d":"-3%"},{"v":835.4754236101386,"d":"835"},{"v":-0.030684046602837873,"d":"-3%"},{"v":-0.030684046602837873,"d":"-3%"},{"$nulls":5},475,894]
[2013,{"$f":"IF($B$3=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},null,{"v":794.3131214115671,"d":"794"},{"v":-0.04926811852909663,"d":"-5%"},{"v":794.3131214115671,"d":"794"},{"v":-0.04926811852909663,"d":"-5%"},{"v":-0.04926811852909663,"d":"-5%"},{"$nulls":5},475,894]
[2014,{"$f":"IF($B$3=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},null,{"v":794.909676515894,"d":"795"},{"v":7.5103266992094251E-4,"d":"0%"},{"v":794.909676515894,"d":"795"},{"v":7.5103266992094251E-4,"d":"0%"},{"v":7.5103266992094251E-4,"d":"0%"},{"$nulls":5},475,894]
[2015,{"$f":"IF($B$3=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},null,{"v":808.3321663632544,"d":"808"},{"v":0.016885553470919357,"d":"2%"},{"v":808.3321663632544,"d":"808"},{"v":0.016885553470919357,"d":"2%"},{"v":0.016885553470919357,"d":"2%"},{"$nulls":5},475,894]
[2016,{"$f":"IF($B$3=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},null,{"v":778.1067077440134,"d":"778"},{"v":-0.03739237392373918,"d":"-4%"},{"v":778.1067077440134,"d":"778"},{"v":-0.03739237392373918,"d":"-4%"},{"v":-0.03739237392373918,"d":"-4%"},{"$nulls":5},475,894]
[2017,{"$f":"IF($B$3=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},null,{"v":720.8374177286095,"d":"721"},{"v":-0.07360081778686424,"d":"-7%"},{"v":720.8374177286095,"d":"721"},{"v":-0.07360081778686424,"d":"-7%"},{"v":-0.07360081778686424,"d":"-7%"},{"$nulls":5},475,894]
[2018,{"$f":"IF($B$3=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},null,710,{"v":-0.015034482758620727,"d":"-2%"},710,{"v":-0.015034482758620727,"d":"-2%"},{"v":-0.015034482758620727,"d":"-2%"},{"$nulls":5},475,894]
[]
["what-if",9000,{"v":1.2603276851981515,"d":"1.2603"},null,{"$f":"MIN($G$4,MAX($H$4,(1-(1-C80)*1)*$F$4))","v":894},{"$f":"(E80-E77)/E77","v":{"v":0.2402241864983001,"d":"24%"}},{"$f":"IF(ABS(H80)>$H$8,G77*(1+SIGN(H80)*$H$8),E80)","v":{"v":828.9630303879009,"d":"829"}},{"$f":"(E80-G77)/G77","v":{"v":0.2402241864983001,"d":"24%"}},{"$f":"(G80-G77)/G77","v":{"v":0.14999999999999997,"d":"15%"}}]

{"sheet":"Alt2-4","index":6,"n_rows":80,"n_cols":16,"rows_kept":80,"merged":[[5,0,5,1],[6,3,6,4],[6,6,6,7],[9,0,9,2]]}
["PSC Limit","Primary Index","Second Index",null,null,"Element 1","Element 2","Element 3"]
["Trawl","Setline","NA",null,"Gear","Starting point","Ceiling","Floor"]
["Non-trawl","Setline","NA",null,"Trawl",1610,2805,798]
[{"$nulls":4},"Non-trawl",408,710,202]
[{"$nulls":4},"Total",{"$f":"SUM(F3:F4)","v":2018},{"$f":"SUM(G3:G4)","v":3515},{"$f":"SUM(H3:H4)","v":1000}]
["Element 4: Breakpoint"]
["Low Threshold",1,null,"Element 5: slope multiplier",null,null,"Element 6 Constraint"]
["High Threshold",null,null,"Low Multiplier",1,null,"Up",{"v":0.15,"d":"15%"}]
[{"$nulls":3},"High Multiplier",0.5,null,"Down",{"v":0.15,"d":"15%"}]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl",2018,null,{"$f":"VLOOKUP(B12,A32:D52,2)","v":7141},{"$f":"IF(C12=\"Mean\",AVERAGE(D32:D52),VLOOKUP(C12,A32:D52,4))","v":{"$error":"#N/A"}}]
["Non-trawl",2018,null,{"$f":"VLOOKUP(B13,A58:D78,2)","v":7141},{"$f":"IF(C13=\"Mean\",AVERAGE(D58:D78),VLOOKUP(C13,A58:D78,4))","v":{"$error":"#N/A"}}]
{"$rows_empty":16}
["TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",{"$nulls":5},"Floor","Ceiling"]
[1998,{"$f":"IF($B$2=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B32/D$12","v":{"v":2.5909536479484667,"d":"2.5910"}},null,{"$f":"MIN($G$3,MAX($H$3,(1-(1-C32)*IF(C32>$B$7,$E$9,$E$8))*$F$3))","v":{"v":2805,"d":"2,805"}},null,{"$f":"E32","v":{"v":2805,"d":"2,805"}},{"$nulls":7},{"$f":"$H$3","v":798},{"$f":"$G$3","v":2805}]
[1999,{"$f":"IF($B$2=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"v":2.268729869766139,"d":"2.2687"},null,{"$f":"MIN($G$3,MAX($H$3,(1-(1-C33)*IF(C33>$B$7,$E$9,$E$8))*$F$3))","v":{"v":2631.327545161742,"d":"2,631"}},{"$f":"(E33-E32)/E32","v":{"v":-0.061915313667828195,"d":"-6%"}},{"$f":"IF(H33>0,IF(ABS(H33)>$H$8,G32*(1+SIGN(H33)*$H$8),E33),IF(ABS(H33)>$H$9,G32*(1+SIGN(H33)*$H$9),E33))","v":{"v":2631.327545161742,"d":"2,631"}},{"$f":"(E33-G32)/G32","v":{"v":-0.061915313667828195,"d":"-6%"}},{"$f":"(G33-G32)/G32","v":{"v":-0.061915313667828195,"d":"-6%"}},{"$nulls":5},798,2805]
[2000,{"$f":"IF($B$2=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},null,{"v":2631.553003780983,"d":"2,632"},{"$f":"(E34-E33)/E33","v":{"v":8.5682460800341851E-5,"d":"0%"}},{"v":2631.553003780983,"d":"2,632"},{"v":8.5682460800341851E-5,"d":"0%"},{"$f":"(G34-G33)/G33","v":{"v":8.5682460800341851E-5,"d":"0%"}},{"$nulls":5},798,2805]
[2001,{"$f":"IF($B$2=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},null,{"v":2358.409886570508,"d":"2,358"},{"v":-0.103795407813571,"d":"-10%"},{"v":2358.409886570508,"d":"2,358"},{"v":-0.103795407813571,"d":"-10%"},{"$f":"(G35-G34)/G34","v":{"v":-0.103795407813571,"d":"-10%"}},{"$nulls":5},798,2805]
[2002,{"$f":"IF($B$2=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},null,{"v":2169.475563646548,"d":"2,169"},{"v":-0.08011089336073804,"d":"-8%"},{"v":2169.475563646548,"d":"2,169"},{"v":-0.08011089336073804,"d":"-8%"},{"v":-0.08011089336073804,"d":"-8%"},{"$nulls":5},798,2805]
[2003,{"$f":"IF($B$2=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},null,{"v":2029.9166783363673,"d":"2,030"},{"v":-0.06432839698623016,"d":"-6%"},{"v":2029.9166783363673,"d":"2,030"},{"v":-0.06432839698623016,"d":"-6%"},{"v":-0.06432839698623016,"d":"-6%"},{"$nulls":5},798,2805]
[2004,{"$f":"IF($B$2=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},null,{"v":1930.8276151799469,"d":"1,931"},{"v":-0.04881434997500963,"d":"-5%"},{"v":1930.8276151799469,"d":"1,931"},{"v":-0.04881434997500963,"d":"-5%"},{"v":-0.04881434997500963,"d":"-5%"},{"$nulls":5},798,2805]
[2005,{"$f":"IF($B$2=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},null,{"v":1881.5649068757875,"d":"1,882"},{"v":-0.02551377860812717,"d":"-3%"},{"v":1881.5649068757875,"d":"1,882"},{"v":-0.02551377860812717,"d":"-3%"},{"v":-0.02551377860812717,"d":"-3%"},{"$nulls":5},798,2805]
[2006,{"$f":"IF($B$2=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},null,{"v":1909.972692900154,"d":"1,910"},{"v":0.015097956982805187,"d":"2%"},{"v":1909.972692900154,"d":"1,910"},{"v":0.015097956982805187,"d":"2%"},{"v":0.015097956982805187,"d":"2%"},{"$nulls":5},798,2805]
[2007,{"$f":"IF($B$2=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},null,{"v":1895.4306119591095,"d":"1,895"},{"v":-0.007613763796257983,"d":"-1%"},{"v":1895.4306119591095,"d":"1,895"},{"v":-0.007613763796257983,"d":"-1%"},{"v":-0.007613763796257983,"d":"-1%"},{"$nulls":5},798,2805]
[2008,{"$f":"IF($B$2=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},null,{"v":1962.0536339448256,"d":"1,962"},{"v":0.03514928036160335,"d":"4%"},{"v":1962.0536339448256,"d":"1,962"},{"v":0.03514928036160335,"d":"4%"},{"v":0.03514928036160335,"d":"4%"},{"$nulls":5},798,2805]
[2009,{"$f":"IF($B$2=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},null,{"v":1913.58003080801,"d":"1,914"},{"v":-0.024705544383797802,"d":"-2%"},{"v":1913.58003080801,"d":"1,914"},{"v":-0.024705544383797802,"d":"-2%"},{"v":-0.024705544383797802,"d":"-2%"},{"$nulls":5},798,2805]
[2010,{"$f":"IF($B$2=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},null,{"v":1836.0222657891052,"d":"1,836"},{"v":-0.040530191458026436,"d":"-4%"},{"v":1836.0222657891052,"d":"1,836"},{"v":-0.040530191458026436,"d":"-4%"},{"v":-0.040530191458026436,"d":"-4%"},{"$nulls":5},798,2805]
[2011,{"$f":"IF($B$2=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},null,{"v":1782.2503851001263,"d":"1,782"},{"v":-0.029287161539878277,"d":"-3%"},{"v":1782.2503851001263,"d":"1,782"},{"v":-0.029287161539878277,"d":"-3%"},{"v":-0.029287161539878277,"d":"-3%"},{"$nulls":5},798,2805]
[2012,{"$f":"IF($B$2=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},null,{"v":1752.264388741073,"d":"1,752"},{"v":-0.01682479443390261,"d":"-2%"},{"v":1752.264388741073,"d":"1,752"},{"v":-0.01682479443390261,"d":"-2%"},{"v":-0.01682479443390261,"d":"-2%"},{"$nulls":5},798,2805]
[2013,{"$f":"IF($B$2=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},null,{"v":1705.5944545581851,"d":"1,706"},{"v":-0.026634071024189538,"d":"-3%"},{"v":1705.5944545581851,"d":"1,706"},{"v":-0.026634071024189538,"d":"-3%"},{"v":-0.026634071024189538,"d":"-3%"},{"$nulls":5},798,2805]
[2014,{"$f":"IF($B$2=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},null,{"v":1706.270830415908,"d":"1,706"},{"v":3.9656311962978769E-4,"d":"0%"},{"v":1706.270830415908,"d":"1,706"},{"v":3.9656311962978769E-4,"d":"0%"},{"v":3.9656311962978769E-4,"d":"0%"},{"$nulls":5},798,2805]
[2015,{"$f":"IF($B$2=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},null,{"v":1721.4892872146759,"d":"1,721"},{"v":0.008919133192389121,"d":"1%"},{"v":1721.4892872146759,"d":"1,721"},{"v":0.008919133192389121,"d":"1%"},{"v":0.008919133192389121,"d":"1%"},{"$nulls":5},798,2805]
[2016,{"$f":"IF($B$2=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},null,{"v":1687.2195770900435,"d":"1,687"},{"v":-0.019907013293170066,"d":"-2%"},{"v":1687.2195770900435,"d":"1,687"},{"v":-0.019907013293170066,"d":"-2%"},{"v":-0.019907013293170066,"d":"-2%"},{"$nulls":5},798,2805]
[2017,{"$f":"IF($B$2=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},null,{"v":1622.2874947486346,"d":"1,622"},{"v":-0.0384846662657848,"d":"-4%"},{"v":1622.2874947486346,"d":"1,622"},{"v":-0.0384846662657848,"d":"-4%"},{"v":-0.0384846662657848,"d":"-4%"},{"$nulls":5},798,2805]
[2018,{"$f":"IF($B$2=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},null,{"v":1610,"d":"1,610"},{"v":-0.007574178305885578,"d":"-1%"},{"v":1610,"d":"1,610"},{"v":-0.007574178305885578,"d":"-1%"},{"v":-0.007574178305885578,"d":"-1%"}]
[]
["what-if",9000,{"$f":"B54/$D$12","v":1.2603276851981515},null,{"$f":"MIN($G$3,MAX($H$3,(1-(1-C54)*IF(B44>1,$E$9,$E$8))*$F$3))","v":{"v":1819.5637865845122,"d":"1,820"}},{"$f":"(E54-E51)/E51","v":{"v":0.12160378014036569,"d":"12%"}},{"$f":"IF(ABS(H54)>$H$8,G51*(1+SIGN(H54)*$H$8),E54)","v":{"v":1819.5637865845122,"d":"1,820"}},{"$f":"(E54-G51)/G51","v":{"v":0.12160378014036569,"d":"12%"}},{"$f":"(G54-G51)/G51","v":{"v":0.12160378014036569,"d":"12%"}}]
[]
["NON-TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",{"$nulls":5},"Floor","Ceiling"]
[1998,{"$f":"IF($B$3=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B58/D$13","v":{"v":2.5909536479484667,"d":"2.5910"}},null,{"$f":"MIN($G$4,MAX($H$4,(1-(1-C58)*IF(C58>$B$7,$E$9,$E$8))*$F$4))","v":710},null,{"$f":"E58","v":710},{"$nulls":7},{"$f":"$H$4","v":202},{"$f":"$G$4","v":710}]
[1999,{"$f":"IF($B$3=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"B59/D$13","v":{"v":2.268729869766139,"d":"2.2687"}},null,{"$f":"MIN($G$4,MAX($H$4,(1-(1-C59)*1)*$F$4))","v":710},{"$f":"(E59-E58)/E58","v":{"v":0,"d":"0%"}},{"$f":"IF(H59>0,IF(ABS(H59)>$H$8,G58*(1+SIGN(H59)*$H$8),E59),IF(ABS(H59)>$H$9,G58*(1+SIGN(H59)*$H$9),E59))","v":710},{"$f":"(E59-G58)/G58","v":{"v":0,"d":"0%"}},{"$f":"(G59-G58)/G58","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"$H$4","v":202},{"$f":"$G$4","v":710}]
[2000,{"$f":"IF($B$3=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},null,710,{"$f":"(E60-E59)/E59","v":{"v":0,"d":"0%"}},710,{"v":0,"d":"0%"},{"$f":"(G60-G59)/G59","v":{"v":0,"d":"0%"}},{"$nulls":5},202,710]
[2001,{"$f":"IF($B$3=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},null,710,{"v":0,"d":"0%"},710,{"v":0,"d":"0%"},{"$f":"(G61-G60)/G60","v":{"v":0,"d":"0%"}},{"$nulls":5},202,710]
[2002,{"$f":"IF($B$3=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},null,{"v":691.5602856742753,"d":"692"},{"v":-0.02597142862778128,"d":"-3%"},{"v":691.5602856742753,"d":"692"},{"v":-0.02597142862778128,"d":"-3%"},{"v":-0.02597142862778128,"d":"-3%"},{"$nulls":5},202,710]
[2003,{"$f":"IF($B$3=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},null,{"v":620.8273351071279,"d":"621"},{"v":-0.10228023793787175,"d":"-10%"},{"v":620.8273351071279,"d":"621"},{"v":-0.10228023793787175,"d":"-10%"},{"v":-0.10228023793787175,"d":"-10%"},{"$nulls":5},202,710]
[2004,{"$f":"IF($B$3=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},null,{"v":570.6057975073519,"d":"571"},{"v":-0.0808945334069575,"d":"-8%"},{"v":570.6057975073519,"d":"571"},{"v":-0.0808945334069575,"d":"-8%"},{"v":-0.0808945334069575,"d":"-8%"},{"$nulls":5},202,710]
[2005,{"$f":"IF($B$3=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},null,{"v":545.6378658451197,"d":"546"},{"v":-0.04375688394913394,"d":"-4%"},{"v":545.6378658451197,"d":"546"},{"v":-0.04375688394913394,"d":"-4%"},{"v":-0.04375688394913394,"d":"-4%"},{"$nulls":5},202,710]
[2006,{"$f":"IF($B$3=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},null,{"v":560.0358493208234,"d":"560"},{"v":0.02638743455497398,"d":"3%"},{"v":560.0358493208234,"d":"560"},{"v":0.02638743455497398,"d":"3%"},{"v":0.02638743455497398,"d":"3%"},{"$nulls":5},202,710]
[2007,{"$f":"IF($B$3=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},null,{"v":552.6654530177847,"d":"553"},{"v":-0.013160579473576791,"d":"-1%"},{"v":552.6654530177847,"d":"553"},{"v":-0.013160579473576791,"d":"-1%"},{"v":-0.013160579473576791,"d":"-1%"},{"$nulls":5},202,710]
[2008,{"$f":"IF($B$3=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},null,{"v":586.4321523596135,"d":"586"},{"v":0.061097901374961135,"d":"6%"},{"v":586.4321523596135,"d":"586"},{"v":0.061097901374961135,"d":"6%"},{"v":0.061097901374961135,"d":"6%"},{"$nulls":5},202,710]
[2009,{"$f":"IF($B$3=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},null,{"v":561.8641646828175,"d":"562"},{"v":-0.04189399844115352,"d":"-4%"},{"v":561.8641646828175,"d":"562"},{"v":-0.04189399844115352,"d":"-4%"},{"v":-0.04189399844115352,"d":"-4%"},{"$nulls":5},202,710]
[2010,{"$f":"IF($B$3=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},null,{"v":522.555384399944,"d":"523"},{"v":-0.06996135855196249,"d":"-7%"},{"v":522.555384399944,"d":"523"},{"v":-0.06996135855196249,"d":"-7%"},{"v":-0.06996135855196249,"d":"-7%"},{"$nulls":5},202,710]
[2011,{"$f":"IF($B$3=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},null,{"v":495.3020585352192,"d":"495"},{"v":-0.052153947080691036,"d":"-5%"},{"v":495.3020585352192,"d":"495"},{"v":-0.052153947080691036,"d":"-5%"},{"v":-0.052153947080691036,"d":"-5%"},{"$nulls":5},202,710]
[2012,{"$f":"IF($B$3=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},null,{"v":480.1041870886431,"d":"480"},{"v":-0.030684046602837734,"d":"-3%"},{"v":480.1041870886431,"d":"480"},{"v":-0.030684046602837734,"d":"-3%"},{"v":-0.030684046602837734,"d":"-3%"},{"$nulls":5},202,710]
[2013,{"$f":"IF($B$3=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},null,{"v":456.4503570928442,"d":"456"},{"v":-0.04926811852909673,"d":"-5%"},{"v":456.4503570928442,"d":"456"},{"v":-0.04926811852909673,"d":"-5%"},{"v":-0.04926811852909673,"d":"-5%"},{"$nulls":5},202,710]
[2014,{"$f":"IF($B$3=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},null,{"v":456.793166223218,"d":"457"},{"v":7.5103266992100951E-4,"d":"0%"},{"v":456.793166223218,"d":"457"},{"v":7.5103266992100951E-4,"d":"0%"},{"v":7.5103266992100951E-4,"d":"0%"},{"$nulls":5},202,710]
[2015,{"$f":"IF($B$3=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},null,{"v":464.50637165663073,"d":"465"},{"v":0.01688555347091941,"d":"2%"},{"v":464.50637165663073,"d":"465"},{"v":0.01688555347091941,"d":"2%"},{"v":0.01688555347091941,"d":"2%"},{"$nulls":5},202,710]
[2016,{"$f":"IF($B$3=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},null,{"v":447.1373757176866,"d":"447"},{"v":-0.03739237392373923,"d":"-4%"},{"v":447.1373757176866,"d":"447"},{"v":-0.03739237392373923,"d":"-4%"},{"v":-0.03739237392373923,"d":"-4%"},{"$nulls":5},202,710]
[2017,{"$f":"IF($B$3=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},null,{"v":414.22769920179246,"d":"414"},{"v":-0.07360081778686434,"d":"-7%"},{"v":414.22769920179246,"d":"414"},{"v":-0.07360081778686434,"d":"-7%"},{"v":-0.07360081778686434,"d":"-7%"},{"$nulls":5},202,710]
[2018,{"$f":"IF($B$3=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},null,408,{"v":-0.015034482758620678,"d":"-2%"},408,{"v":-0.015034482758620678,"d":"-2%"},{"v":-0.015034482758620678,"d":"-2%"},{"$nulls":5},202,710]
[]
["what-if",9000,{"v":1.2603276851981515,"d":"1.2603"},null,{"$f":"MIN($G$4,MAX($H$4,(1-(1-C80)*1)*$F$4))","v":{"v":514.2136955608458,"d":"514"}},{"$f":"(E80-E77)/E77","v":{"v":0.24137931034482768,"d":"24%"}},{"$f":"IF(ABS(H80)>$H$8,G77*(1+SIGN(H80)*$H$8),E80)","v":{"v":476.3618540820613,"d":"476"}},{"$f":"(E80-G77)/G77","v":{"v":0.24137931034482768,"d":"24%"}},{"$f":"(G80-G77)/G77","v":{"v":0.14999999999999997,"d":"15%"}}]

{"sheet":"Alt3-1","index":7,"n_rows":80,"n_cols":16,"rows_kept":80,"merged":[[5,0,5,1],[6,3,6,4],[6,6,6,7],[9,0,9,2],[29,0,29,10],[55,0,55,10]]}
["PSC Limit","Primary Index","Second Index",null,null,"Element 1","Element 2","Element 3"]
["Trawl","Trawl",{"$f":"IF(B2=\"Trawl\",\"Setline\",\"Trawl\")","v":"Setline"},null,"Gear","Starting point","Ceiling","Floor"]
["Non-trawl","Setline",{"$f":"IF(B3=\"Trawl\",\"Setline\",\"Trawl\")","v":"Trawl"},null,"Trawl",2805,3532,1403]
[{"$nulls":4},"Non-trawl",710,894,355]
[{"$nulls":4},"Total",{"$f":"SUM(F3:F4)","v":3515},{"$f":"SUM(G3:G4)","v":4426},{"$f":"SUM(H3:H4)","v":1758}]
["Element 4: Breakpoint"]
["Low Threshold",0.75,null,"Element 5: slope multiplier",null,null,"Element 6 Constraint"]
["High Threshold",1.25,null,"Low Multiplier on slope",1,null,"Up",{"v":0.15,"d":"15%"}]
[{"$nulls":3},"High Multiplier on slope",1,null,"Down",{"v":0.15,"d":"15%"}]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl",2018,2018,{"$f":"VLOOKUP(B12,A32:D52,2)","v":125702},{"$f":"IF(C12=\"Mean\",AVERAGE(D32:D52),VLOOKUP(C12,A32:D52,4))","v":7141}]
["Non-trawl",2018,2018,{"$f":"VLOOKUP(B13,A58:D78,2)","v":7141},{"$f":"IF(C13=\"Mean\",AVERAGE(D58:D78),VLOOKUP(C13,A58:D78,4))","v":125702}]
{"$rows_empty":16}
["TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary","Secondary index","Standardized Secondary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",null,null,"slope modifier for Alt 3","Floor","Ceiling"]
[1998,{"$f":"IF($B$2=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"B32/D$12","v":{"v":1.2828435506197196,"d":"1.2828"}},{"$f":"IF($C$2=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"D32/E$12","v":{"v":2.5909536479484667,"d":"2.5910"}},null,{"$f":"MIN($G$3,MAX($H$3,$F$3*(1-1*(1-(C32+N32)))))","v":{"v":3532,"d":"3,532"}},null,{"$f":"G32","v":{"v":3532,"d":"3,532"}},{"$nulls":4},{"$f":"IF(E32<$B$7,$E$8*(E32-$B$7),IF(E32>$B$8,$E$9*(E32-$B$8),0))","v":1.3409536479484667},{"$f":"$H$3","v":1403},{"$f":"$G$3","v":3532}]
[1999,{"$f":"IF($B$2=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"v":1.0271594724029849,"d":"1.0272"},{"$f":"IF($C$2=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"D33/E$12","v":{"v":2.268729869766139,"d":"2.2687"}},null,{"v":3532,"d":"3,532"},{"$f":"(G33-G32)/G32","v":{"v":0,"d":"0%"}},{"$f":"IF(J33>0,IF(ABS(J33)>$H$8,I32*(1+SIGN(J33)*$H$8),G33),IF(ABS(J33)>$H$9,I32*(1+SIGN(J33)*$H$9),G33))","v":{"v":3532,"d":"3,532"}},{"$f":"(G33-I32)/I32","v":{"v":0,"d":"0%"}},{"$f":"(I33-I32)/I32","v":{"v":0,"d":"0%"}},null,null,1.018729869766139,1403,3532]
[2000,{"$f":"IF($B$2=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.9441138565814386,"d":"0.9441"},{"$f":"IF($C$2=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},null,{"v":3532,"d":"3,532"},{"$f":"(G34-G33)/G33","v":{"v":0,"d":"0%"}},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"$f":"(I34-I33)/I33","v":{"v":0,"d":"0%"}},null,null,1.0190099425850723,1403,3532]
[2001,{"$f":"IF($B$2=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":1.1234427455410416,"d":"1.1234"},{"$f":"IF($C$2=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"$f":"(I35-I34)/I34","v":{"v":0,"d":"0%"}},null,null,0.6797017224478363,1403,3532]
[2002,{"$f":"IF($B$2=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.8091040715342636,"d":"0.8091"},{"$f":"IF($C$2=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},null,{"v":3517.7638846642517,"d":"3,518"},{"v":-0.004030610230959317,"d":"-0%"},{"v":3517.7638846642517,"d":"3,518"},{"v":-0.004030610230959317,"d":"-0%"},{"v":-0.004030610230959317,"d":"-0%"},null,null,0.4450007001820473,1403,3532]
[2003,{"$f":"IF($B$2=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":1.0513038774243846,"d":"1.0513"},{"$f":"IF($C$2=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},null,{"v":3532,"d":"3,532"},{"v":0.004046921795351554,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0.004046921795351554,"d":"0%"},{"v":0.004046921795351554,"d":"0%"},null,null,0.27163562526256824,1403,3532]
[2004,{"$f":"IF($B$2=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":1.0347886270703728,"d":"1.0348"},{"$f":"IF($C$2=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},null,{"v":3319.24695679544,"d":"3,319"},{"v":-0.060235855946930934,"d":"-6%"},{"v":3319.24695679544,"d":"3,319"},{"v":-0.060235855946930934,"d":"-6%"},{"v":-0.060235855946930934,"d":"-6%"},null,null,0.14854362134154875,1403,3532]
[2005,{"$f":"IF($B$2=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":1.054223480931091,"d":"1.0542"},{"$f":"IF($C$2=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},null,{"v":3202.1071916969086,"d":"3,202"},{"v":-0.035291066504923065,"d":"-4%"},{"v":3202.1071916969086,"d":"3,202"},{"v":-0.035291066504923065,"d":"-4%"},{"v":-0.035291066504923065,"d":"-4%"},null,null,0.08734771040470513,1403,3532]
[2006,{"$f":"IF($B$2=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.240743981798221,"d":"1.2407"},{"$f":"IF($C$2=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},null,{"v":3532,"d":"3,532"},{"v":0.1030236617807506,"d":"10%"},{"v":3532,"d":"3,532"},{"v":0.1030236617807506,"d":"10%"},{"v":0.1030236617807506,"d":"10%"},null,null,0.12263688559025354,1403,3532]
[2007,{"$f":"IF($B$2=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":1.1447948322222399,"d":"1.1448"},{"$f":"IF($C$2=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},null,{"v":3504.4744938806525,"d":"3,504"},{"v":-0.007793178402986264,"d":"-1%"},{"v":3504.4744938806525,"d":"3,504"},{"v":-0.007793178402986264,"d":"-1%"},{"v":-0.007793178402986264,"d":"-1%"},null,null,0.10457218876908003,1403,3532]
[2008,{"$f":"IF($B$2=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":1.1157101716758684,"d":"1.1157"},{"$f":"IF($C$2=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},null,{"v":3532,"d":"3,532"},{"v":0.007854389058162992,"d":"1%"},{"v":3532,"d":"3,532"},{"v":0.007854389058162992,"d":"1%"},{"v":0.007854389058162992,"d":"1%"},null,null,0.1873337067637586,1403,3532]
[2009,{"$f":"IF($B$2=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.3373056912380072,"d":"1.3373"},{"$f":"IF($C$2=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0.12711805069318016,1403,3532]
[2010,{"$f":"IF($B$2=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.5555440645335794,"d":"1.5555"},{"$f":"IF($C$2=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0.030773000980254928,1403,3532]
[2011,{"$f":"IF($B$2=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.4849883056753275,"d":"1.4850"},{"$f":"IF($C$2=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0,1403,3532]
[2012,{"$f":"IF($B$2=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.503556029339231,"d":"1.5036"},{"$f":"IF($C$2=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0,1403,3532]
[2013,{"$f":"IF($B$2=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.4636919062544749,"d":"1.4637"},{"$f":"IF($C$2=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0,1403,3532]
[2014,{"$f":"IF($B$2=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.3637571399023087,"d":"1.3638"},{"$f":"IF($C$2=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0,1403,3532]
[2015,{"$f":"IF($B$2=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.3702009514566196,"d":"1.3702"},{"$f":"IF($C$2=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},null,{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":3532,"d":"3,532"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0,1403,3532]
[2016,{"$f":"IF($B$2=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.2227649520294028,"d":"1.2228"},{"$f":"IF($C$2=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},null,{"v":3429.855690442475,"d":"3,430"},{"v":-0.028919679942674137,"d":"-3%"},{"v":3429.855690442475,"d":"3,430"},{"v":-0.028919679942674137,"d":"-3%"},{"v":-0.028919679942674137,"d":"-3%"},null,null,0,1403,3532]
[2017,{"$f":"IF($B$2=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":1.0078121270942388,"d":"1.0078"},{"$f":"IF($C$2=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},null,{"v":2826.91301649934,"d":"2,827"},{"v":-0.17579243220735954,"d":"-18%"},{"v":2915.3773368761035,"d":"2,915"},{"v":-0.17579243220735954,"d":"-18%"},{"v":-0.15000000000000005,"d":"-15%"},null,null,0,1403,3532]
[2018,{"$f":"IF($B$2=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":1,"d":"1.0000"},{"$f":"IF($C$2=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},null,{"v":2805,"d":"2,805"},{"$f":"(G52-G51)/G51","v":{"v":-0.007751570837674893,"d":"-1%"}},{"v":2805,"d":"2,805"},{"v":-0.03786039476947278,"d":"-4%"},{"$f":"(I52-I51)/I51","v":{"v":-0.03786039476947278,"d":"-4%"}}]
[]
["what-if",100000,{"$f":"B54/$D$12","v":0.7955322906556778},9000,{"$f":"D54/$E$12","v":1.2603276851981515},null,{"$f":"MIN($G$3,MAX($H$3,$F$3*(1-1*(1-(C54+N54)))))","v":{"v":2260.437232269991,"d":"2,260"}},{"$f":"(G54-G51)/G51","v":{"v":-0.2003867048342487,"d":"-20%"}},{"$f":"IF(ABS(J54)>$H$8,I51*(1+SIGN(J54)*$H$8),G54)","v":{"v":2478.070736344688,"d":"2,478"}},{"$f":"(G54-I51)/I51","v":{"v":-0.22465020096091454,"d":"-22%"}},{"$f":"(I54-I51)/I51","v":{"v":-0.14999999999999994,"d":"-15%"}},null,null,{"$f":"IF(E54<$B$7,$E$8*(E54-$B$7),IF(E54>$B$8,$E$9*(E54-$B$8),0))","v":0.010327685198151526}]
[]
["NON-TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary","Secondary index","Standardized Secondary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",null,null,"slope modifier for Alt 3"]
[1998,{"$f":"IF($B$3=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B58/D$13","v":{"v":2.5909536479484667,"d":"2.5910"}},{"$f":"IF($C$3=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"D58/E$13","v":{"v":1.2828435506197196,"d":"1.2828"}},null,{"$f":"MIN($G$4,MAX($H$4,$F$4*(1-1*(1-(C58+N58)))))","v":894},null,{"$f":"G58","v":894},{"$nulls":4},{"$f":"IF(E58<$B$7,$E$8*(E58-$B$7),IF(E58>$B$8,$E$9*(E58-$B$8),0))","v":0.03284355061971955}]
[1999,{"$f":"IF($B$3=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"B59/D$13","v":{"v":2.268729869766139,"d":"2.2687"}},{"$f":"IF($C$3=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"$f":"D59/E$13","v":{"v":1.0271594724029849,"d":"1.0272"}},null,{"$f":"MIN($G$4,MAX($H$4,$F$4*(1-1*(1-(C59+N59)))))","v":894},{"$f":"(G59-G58)/G58","v":{"v":0,"d":"0%"}},{"$f":"IF(J59>0,IF(ABS(J59)>$H$8,I58*(1+SIGN(J59)*$H$8),G59),IF(ABS(J59)>$H$9,I58*(1+SIGN(J59)*$H$9),G59))","v":894},{"$f":"(G59-I58)/I58","v":{"v":0,"d":"0%"}},{"$f":"(I59-I58)/I58","v":{"v":0,"d":"0%"}},null,null,0]
[2000,{"$f":"IF($B$3=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},{"$f":"IF($C$3=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.9441138565814386,"d":"0.9441"},null,894,{"$f":"(G60-G59)/G59","v":{"v":0,"d":"0%"}},894,{"v":0,"d":"0%"},{"$f":"(I60-I59)/I59","v":{"v":0,"d":"0%"}},null,null,0]
[2001,{"$f":"IF($B$3=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},{"$f":"IF($C$3=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":1.1234427455410416,"d":"1.1234"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"$f":"(I61-I60)/I60","v":{"v":0,"d":"0%"}},null,null,0]
[2002,{"$f":"IF($B$3=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},{"$f":"IF($C$3=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.8091040715342636,"d":"0.8091"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0]
[2003,{"$f":"IF($B$3=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},{"$f":"IF($C$3=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":1.0513038774243846,"d":"1.0513"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0]
[2004,{"$f":"IF($B$3=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},{"$f":"IF($C$3=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":1.0347886270703728,"d":"1.0348"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0]
[2005,{"$f":"IF($B$3=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},{"$f":"IF($C$3=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":1.054223480931091,"d":"1.0542"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0]
[2006,{"$f":"IF($B$3=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},{"$f":"IF($C$3=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.240743981798221,"d":"1.2407"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0]
[2007,{"$f":"IF($B$3=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},{"$f":"IF($C$3=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":1.1447948322222399,"d":"1.1448"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0]
[2008,{"$f":"IF($B$3=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},{"$f":"IF($C$3=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":1.1157101716758684,"d":"1.1157"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0]
[2009,{"$f":"IF($B$3=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},{"$f":"IF($C$3=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.3373056912380072,"d":"1.3373"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0.08730569123800724]
[2010,{"$f":"IF($B$3=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},{"$f":"IF($C$3=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.5555440645335794,"d":"1.5555"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0.3055440645335794]
[2011,{"$f":"IF($B$3=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},{"$f":"IF($C$3=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.4849883056753275,"d":"1.4850"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0.23498830567532747]
[2012,{"$f":"IF($B$3=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},{"$f":"IF($C$3=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.503556029339231,"d":"1.5036"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0.25355602933923094]
[2013,{"$f":"IF($B$3=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},{"$f":"IF($C$3=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.4636919062544749,"d":"1.4637"},null,894,{"v":0,"d":"0%"},894,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,0.21369190625447487]
[2014,{"$f":"IF($B$3=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},{"$f":"IF($C$3=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.3637571399023087,"d":"1.3638"},null,{"v":875.6772458465333,"d":"876"},{"v":-0.02049525073094708,"d":"-2%"},{"v":875.6772458465333,"d":"876"},{"v":-0.02049525073094708,"d":"-2%"},{"v":-0.02049525073094708,"d":"-2%"},null,null,0.11375713990230873]
[2015,{"$f":"IF($B$3=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},{"$f":"IF($C$3=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.3702009514566196,"d":"1.3702"},null,{"v":893.6748418974544,"d":"894"},{"v":0.02055277345196112,"d":"2%"},{"v":893.6748418974544,"d":"894"},{"v":0.02055277345196112,"d":"2%"},{"v":0.02055277345196112,"d":"2%"},null,null,0.12020095145661958]
[2016,{"$f":"IF($B$3=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},{"$f":"IF($C$3=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.2227649520294028,"d":"1.2228"},null,{"v":778.1067077440134,"d":"778"},{"v":-0.12931787797457314,"d":"-13%"},{"v":778.1067077440134,"d":"778"},{"v":-0.12931787797457314,"d":"-13%"},{"v":-0.12931787797457314,"d":"-13%"},null,null,0]
[2017,{"$f":"IF($B$3=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},{"$f":"IF($C$3=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":1.0078121270942388,"d":"1.0078"},null,{"v":720.8374177286095,"d":"721"},{"v":-0.07360081778686424,"d":"-7%"},{"v":720.8374177286095,"d":"721"},{"v":-0.07360081778686424,"d":"-7%"},{"v":-0.07360081778686424,"d":"-7%"},null,null,0]
[2018,{"$f":"IF($B$3=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},{"$f":"IF($C$3=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":1,"d":"1.0000"},null,710,{"v":-0.015034482758620727,"d":"-2%"},710,{"v":-0.015034482758620727,"d":"-2%"},{"v":-0.015034482758620727,"d":"-2%"}]
[]
["what-if",9000,{"v":1.2603276851981515,"d":"1.2603"},10000,{"v":0.07955322906556778,"d":"0.0796"},null,{"v":418.81544912724075,"d":"419"},{"$f":"(G80-G77)/G77","v":{"v":-0.41898764017141793,"d":"-42%"}},{"$f":"IF(ABS(J80)>$H$8,I77*(1+SIGN(J80)*$H$8),G80)","v":{"v":612.7118050693181,"d":"613"}},{"$f":"(G80-I77)/I77","v":{"v":-0.41898764017141793,"d":"-42%"}},{"$f":"(I80-I77)/I77","v":{"v":-0.14999999999999997,"d":"-15%"}},null,null,{"$f":"IF(E80<$B$7,$E$8*(E80-$B$7),IF(E80>$B$8,$E$9*(E80-$B$8),0))","v":-0.6704467709344322}]

{"sheet":"Alt3-2a","index":8,"n_rows":108,"n_cols":17,"rows_kept":108,"merged":[[5,0,5,1],[6,3,6,4],[6,6,6,7],[9,0,9,2],[55,2,55,12],[56,0,67,0],[95,2,95,12],[96,0,107,0]]}
["PSC Limit","Primary Index","Second Index",null,null,"Element 1","Element 2","Element 3"]
["Trawl","Trawl",{"$f":"IF(B2=\"Trawl\",\"Setline\",\"Trawl\")","v":"Setline"},null,"Gear","Starting point","Ceiling","Floor"]
["Non-trawl","Setline",{"$f":"IF(B3=\"Trawl\",\"Setline\",\"Trawl\")","v":"Trawl"},null,"Trawl",2805,3532,1403]
[{"$nulls":4},"Non-trawl",710,894,355]
[{"$nulls":4},"Total",{"$f":"SUM(F3:F4)","v":3515},{"$f":"SUM(G3:G4)","v":4426},{"$f":"SUM(H3:H4)","v":1758}]
["Element 4: Breakpoint"]
["Low Threshold","NA",null,"Element 5: slope multiplier",null,null,"Element 6 Constraint"]
["High Threshold","NA",null,"Low Multiplier on slope","NA",null,"Up",{"v":0.15,"d":"15%"}]
[{"$nulls":3},"High Multiplier on slope","NA",null,"Down",{"v":0.15,"d":"15%"}]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl","Mean","Mean",{"$f":"IF(B12=\"Mean\",AVERAGE(B32:B52),VLOOKUP(B12,A32:D52,2))","v":150470.38095238095},{"$f":"IF(C12=\"Mean\",AVERAGE(D32:D52),VLOOKUP(C12,A32:D52,4))","v":10443.57142857143}]
["Non-trawl","Mean","Mean",{"$f":"IF(B13=\"Mean\",AVERAGE(B72:B92),VLOOKUP(B13,A72:D92,2))","v":10443.57142857143},{"$f":"IF(C13=\"Mean\",AVERAGE(D72:D92),VLOOKUP(C13,A72:D92,4))","v":150470.38095238095}]
{"$rows_empty":16}
["TRAWL"]
["Year","Primary index","Standardized Primary","Secondary index","Standardized Secondary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",null,null,"row","column","floor","ceiling"]
[1998,{"$f":"IF($B$2=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"B32/D$12","v":{"v":1.0716793496457775,"d":"1.0717"}},{"$f":"IF($C$2=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"D32/E$12","v":{"v":1.7716161685247245,"d":"1.7716"}},null,{"$f":"INDEX($C$58:$M$68,N32,O32)","v":{"v":3241.2,"d":"3,241"}},null,{"$f":"IF(H32>0,IF(ABS(H32)>$H$8,G31*(1+SIGN(H32)*$H$8),G32),IF(ABS(H32)>$H$9,G31*(1+SIGN(H32)*$H$9),G32))","v":{"v":3241.2,"d":"3,241"}},{"$nulls":4},{"$f":"MATCH(MIN($B$58,MAX($B$68,ROUND(C32,1))),$B$58:$B$68,0)","v":5},{"$f":"MATCH(MIN($M$57,MAX($C$57,ROUND(E32,1))),$C$57:$M$57,0)","v":11},{"$f":"$H$3","v":1403},{"$f":"$G$3","v":3532}]
[1999,{"$f":"IF($B$2=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"v":0.8580824955900197,"d":"0.8581"},{"$f":"IF($C$2=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"D33/E$12","v":{"v":1.5512892415019492,"d":"1.5513"}},null,{"$f":"INDEX($C$58:$M$68,N33,O33)","v":{"v":3095.7999999999997,"d":"3,096"}},{"$f":"(G33-G32)/G32","v":{"v":-0.044859928421572284,"d":"-4%"}},{"v":3095.7999999999997,"d":"3,096"},{"$f":"(G33-I32)/I32","v":{"v":-0.044859928421572284,"d":"-4%"}},{"$f":"(I33-I32)/I32","v":{"v":-0.044859928421572284,"d":"-4%"}},null,null,{"$f":"MATCH(MIN($B$58,MAX($B$68,ROUND(C33,1))),$B$58:$B$68,0)","v":7},{"$f":"MATCH(MIN($M$57,MAX($C$57,ROUND(E33,1))),$C$57:$M$57,0)","v":11},{"$f":"$H$3","v":1403},{"$f":"$G$3","v":3532}]
[2000,{"$f":"IF($B$2=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.7887067158921959,"d":"0.7887"},{"$f":"IF($C$2=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":1.5514807468709388,"d":"1.5515"},null,{"v":3023.1,"d":"3,023"},{"$f":"(G34-G33)/G33","v":{"v":-0.023483429162090518,"d":"-2%"}},{"v":3023.1,"d":"3,023"},{"$f":"(G34-I33)/I33","v":{"v":-0.023483429162090518,"d":"-2%"}},{"$f":"(I34-I33)/I33","v":{"v":-0.023483429162090518,"d":"-2%"}},null,null,8,11,1403,3532]
[2001,{"$f":"IF($B$2=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":0.9385169300840096,"d":"0.9385"},{"$f":"IF($C$2=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.319471992339785,"d":"1.3195"},null,{"v":2950.4,"d":"2,950"},{"v":-0.02404816248222018,"d":"-2%"},{"v":2950.4,"d":"2,950"},{"$f":"(G35-I34)/I34","v":{"v":-0.02404816248222018,"d":"-2%"}},{"$f":"(I35-I34)/I34","v":{"v":-0.02404816248222018,"d":"-2%"}},null,null,7,9,1403,3532]
[2002,{"$f":"IF($B$2=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.6759203994584602,"d":"0.6759"},{"$f":"IF($C$2=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.158990493126325,"d":"1.1590"},null,{"v":2664.7999999999993,"d":"2,665"},{"v":-0.09680043383947967,"d":"-10%"},{"v":2664.7999999999993,"d":"2,665"},{"v":-0.09680043383947967,"d":"-10%"},{"v":-0.09680043383947967,"d":"-10%"},null,null,9,8,1403,3532]
[2003,{"$f":"IF($B$2=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":0.8782525781058637,"d":"0.8783"},{"$f":"IF($C$2=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.040448669721633,"d":"1.0404"},null,{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,7,6,1403,3532]
[2004,{"$f":"IF($B$2=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":0.8644558429154544,"d":"0.8645"},{"$f":"IF($C$2=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":0.9562820600506121,"d":"0.9563"},null,{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,7,6,1403,3532]
[2005,{"$f":"IF($B$2=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":0.8806915963211238,"d":"0.8807"},{"$f":"IF($C$2=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":0.9144381369263388,"d":"0.9144"},null,{"v":2524.5999999999995,"d":"2,525"},{"v":-0.052611828279795804,"d":"-5%"},{"v":2524.5999999999995,"d":"2,525"},{"v":-0.052611828279795804,"d":"-5%"},{"v":-0.052611828279795804,"d":"-5%"},null,null,7,5,1403,3532]
[2006,{"$f":"IF($B$2=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.0365096373973932,"d":"1.0365"},{"$f":"IF($C$2=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":0.9385678134190547,"d":"0.9386"},null,{"v":2664.7999999999993,"d":"2,665"},{"v":0.055533549869286165,"d":"6%"},{"v":2664.7999999999993,"d":"2,665"},{"v":0.055533549869286165,"d":"6%"},{"v":0.055533549869286165,"d":"6%"},null,null,6,5,1403,3532]
[2007,{"$f":"IF($B$2=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":0.9563543276037872,"d":"0.9564"},{"$f":"IF($C$2=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":0.926215717119212,"d":"0.9262"},null,{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,6,5,1403,3532]
[2008,{"$f":"IF($B$2=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":0.9320571870179798,"d":"0.9321"},{"$f":"IF($C$2=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":0.9828055536557007,"d":"0.9828"},null,{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":2664.7999999999993,"d":"2,665"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,7,6,1403,3532]
[2009,{"$f":"IF($B$2=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.1171766758083699,"d":"1.1172"},{"$f":"IF($C$2=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":0.9416318993228917,"d":"0.9416"},null,{"v":2805,"d":"2,805"},{"v":0.052611828279796144,"d":"5%"},{"v":2805,"d":"2,805"},{"v":0.052611828279796144,"d":"5%"},{"v":0.052611828279796144,"d":"5%"},null,null,5,5,1403,3532]
[2010,{"$f":"IF($B$2=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.2994916259425207,"d":"1.2995"},{"$f":"IF($C$2=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":0.8757540523903973,"d":"0.8758"},null,{"v":2950.4,"d":"2,950"},{"v":0.05183600713012481,"d":"5%"},{"v":2950.4,"d":"2,950"},{"v":0.05183600713012481,"d":"5%"},{"v":0.05183600713012481,"d":"5%"},null,null,3,5,1403,3532]
[2011,{"$f":"IF($B$2=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.240549793378099,"d":"1.2405"},{"$f":"IF($C$2=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":0.8300800218863278,"d":"0.8301"},null,{"v":2805,"d":"2,805"},{"v":-0.04928145336225599,"d":"-5%"},{"v":2805,"d":"2,805"},{"v":-0.04928145336225599,"d":"-5%"},{"v":-0.04928145336225599,"d":"-5%"},null,null,4,4,1403,3532]
[2012,{"$f":"IF($B$2=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.2560611517280098,"d":"1.2561"},{"$f":"IF($C$2=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":0.8046098078106833,"d":"0.8046"},null,{"v":2877.7000000000003,"d":"2,878"},{"v":0.025918003565062485,"d":"3%"},{"v":2877.7000000000003,"d":"2,878"},{"v":0.025918003565062485,"d":"3%"},{"v":0.025918003565062485,"d":"3%"},null,null,3,4,1403,3532]
[2013,{"$f":"IF($B$2=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.2227589166417185,"d":"1.2228"},{"$f":"IF($C$2=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":0.7649681964297927,"d":"0.7650"},null,{"v":2805,"d":"2,805"},{"v":-0.025263231052576805,"d":"-3%"},{"v":2805,"d":"2,805"},{"v":-0.025263231052576805,"d":"-3%"},{"v":-0.025263231052576805,"d":"-3%"},null,null,4,4,1403,3532]
[2014,{"$f":"IF($B$2=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.1392740479221033,"d":"1.1393"},{"$f":"IF($C$2=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":0.7655427125367621,"d":"0.7655"},null,{"v":2664.7999999999997,"d":"2,665"},{"v":-0.049982174688057136,"d":"-5%"},{"v":2664.7999999999997,"d":"2,665"},{"v":-0.049982174688057136,"d":"-5%"},{"v":-0.049982174688057136,"d":"-5%"},null,null,5,4,1403,3532]
[2015,{"$f":"IF($B$2=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.1446571671437948,"d":"1.1447"},{"$f":"IF($C$2=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":0.7784693249435742,"d":"0.7785"},null,{"v":2664.7999999999997,"d":"2,665"},{"v":0,"d":"0%"},{"v":2664.7999999999997,"d":"2,665"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,5,4,1403,3532]
[2016,{"$f":"IF($B$2=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.0214900701862542,"d":"1.0215"},{"$f":"IF($C$2=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":0.7493605088571232,"d":"0.7494"},null,{"v":2384.399999999999,"d":"2,384"},{"v":-0.10522365655959193,"d":"-11%"},{"v":2384.399999999999,"d":"2,384"},{"v":-0.10522365655959193,"d":"-11%"},{"v":-0.10522365655959193,"d":"-11%"},null,null,6,3,1403,3532]
[2017,{"$f":"IF($B$2=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":0.841919846272546,"d":"0.8419"},{"$f":"IF($C$2=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":0.6942069625880583,"d":"0.6942"},null,{"v":2103.9999999999995,"d":"2,104"},{"v":-0.11759771850360666,"d":"-12%"},{"v":2103.9999999999995,"d":"2,104"},{"v":-0.11759771850360666,"d":"-12%"},{"v":-0.11759771850360666,"d":"-12%"},null,null,8,3,1403,3532]
[2018,{"$f":"IF($B$2=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":0.8353936449445201,"d":"0.8354"},{"$f":"IF($C$2=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":0.6837699199781136,"d":"0.6838"},null,{"v":2103.9999999999995,"d":"2,104"},{"v":0,"d":"0%"},{"$f":"IF(H52>0,IF(ABS(H52)>$H$8,G51*(1+SIGN(H52)*$H$8),G52),IF(ABS(H52)>$H$9,G51*(1+SIGN(H52)*$H$9),G52))","v":{"v":2103.9999999999995,"d":"2,104"}},{"$f":"(G52-I51)/I51","v":{"v":0,"d":"0%"}},{"$f":"(I52-I51)/I51","v":{"v":0,"d":"0%"}},null,null,{"$f":"MATCH(MIN($B$58,MAX($B$68,ROUND(C52,1))),$B$58:$B$68,0)","v":8},{"$f":"MATCH(MIN($M$57,MAX($C$57,ROUND(E52,1))),$C$57:$M$57,0)","v":3},1403,3532]
[]
["what-if",100000,{"$f":"B54/$D$12","v":0.6645826199619099},9000,{"$f":"D54/$E$12","v":0.8617741604541412},null,{"v":2244.1999999999994,"d":"2,244"},{"$f":"(G54-G52)/G52","v":{"v":0.06663498098859308,"d":"7%"}},{"$f":"IF(H54>0,IF(ABS(H54)>$H$8,G52*(1+SIGN(H54)*$H$8),G54),IF(ABS(H54)>$H$9,G52*(1+SIGN(H54)*$H$9),G54))","v":{"v":2244.1999999999994,"d":"2,244"}},{"$f":"(G54-I52)/I52","v":{"v":0.06663498098859308,"d":"7%"}},{"$f":"(I54-I52)/I52","v":{"v":0.06663498098859308,"d":"7%"}},null,null,{"$f":"MATCH(MIN($B$58,MAX($B$68,ROUND(C54,1))),$B$58:$B$68,0)","v":9},{"$f":"MATCH(MIN($M$57,MAX($C$57,ROUND(E54,1))),$C$57:$M$57,0)","v":5}]
[]
[null,null,"Secondary Index Standardized to average"]
["Primary Index Standardzied to average",null,0.5,0.6,0.7,0.8,0.9,1,1.1,1.2,1.3,1.4,1.5,null,"slopeHi","slopeLow"]
[null,1.5,{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"$f":"C58+$O$58*(D$57-C$57)","v":{"v":2877.7,"d":"2,878"}},{"$f":"D58+$O$58*(E$57-D$57)","v":{"v":2950.3999999999996,"d":"2,950"}},{"v":3023.1,"d":"3,023"},{"v":3095.7999999999997,"d":"3,096"},{"v":3168.4999999999995,"d":"3,169"},{"v":3241.2,"d":"3,241"},{"v":3313.8999999999996,"d":"3,314"},{"v":3386.6,"d":"3,387"},{"v":3459.2999999999997,"d":"3,459"},{"$f":"G3","v":{"v":3532,"d":"3,532"}},null,{"$f":"(M58-C58)/(M57-C57)","v":727},{"$f":"(M68-C68)/(M57-C57)","v":1402}]
[null,1.4,{"$f":"C58+$P$58*(B59-B58)","v":{"v":2664.7999999999997,"d":"2,665"}},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7,"d":"2,878"},{"v":2950.4,"d":"2,950"},{"v":3023.1,"d":"3,023"},{"v":3095.7999999999997,"d":"3,096"},{"v":3168.5,"d":"3,169"},{"v":3241.2,"d":"3,241"},{"v":3313.9,"d":"3,314"},{"v":3386.6,"d":"3,387"},{"$f":"M58+$O$58*(B59-B58)","v":{"v":3459.2999999999997,"d":"3,459"}}]
[null,1.3,{"$f":"C59+$P$58*(B60-B59)","v":{"v":2524.6,"d":"2,525"}},{"$f":"C60+$P$58*(D$57-C$57)","v":{"v":2664.7999999999997,"d":"2,665"}},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7000000000003,"d":"2,878"},{"v":2950.4,"d":"2,950"},{"v":3023.1,"d":"3,023"},{"v":3095.8,"d":"3,096"},{"v":3168.5,"d":"3,169"},{"v":3241.2000000000003,"d":"3,241"},{"v":3313.9,"d":"3,314"},{"$f":"M59+$O$58*(B60-B59)","v":{"v":3386.6,"d":"3,387"}}]
[null,1.2,{"v":2384.3999999999996,"d":"2,384"},{"v":2524.5999999999995,"d":"2,525"},{"v":2664.7999999999993,"d":"2,665"},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7,"d":"2,878"},{"v":2950.3999999999996,"d":"2,950"},{"v":3023.1,"d":"3,023"},{"v":3095.7999999999997,"d":"3,096"},{"v":3168.5,"d":"3,169"},{"v":3241.2,"d":"3,241"},{"v":3313.8999999999996,"d":"3,314"}]
[null,1.1,{"v":2244.2,"d":"2,244"},{"v":2384.3999999999996,"d":"2,384"},{"v":2524.5999999999995,"d":"2,525"},{"v":2664.7999999999997,"d":"2,665"},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7,"d":"2,878"},{"v":2950.4,"d":"2,950"},{"v":3023.1,"d":"3,023"},{"v":3095.8,"d":"3,096"},{"v":3168.5,"d":"3,169"},{"v":3241.2,"d":"3,241"}]
[null,1,{"v":2103.9999999999995,"d":"2,104"},{"v":2244.1999999999994,"d":"2,244"},{"v":2384.399999999999,"d":"2,384"},{"v":2524.5999999999995,"d":"2,525"},{"v":2664.7999999999993,"d":"2,665"},{"$f":"F3","v":{"v":2805,"d":"2,805"}},{"v":2877.7000000000003,"d":"2,878"},{"v":2950.4,"d":"2,950"},{"v":3023.1000000000004,"d":"3,023"},{"v":3095.8,"d":"3,096"},{"v":3168.4999999999995,"d":"3,169"}]
[null,0.9,{"v":1963.7999999999995,"d":"1,964"},{"v":2103.9999999999995,"d":"2,104"},{"v":2244.1999999999994,"d":"2,244"},{"v":2384.3999999999996,"d":"2,384"},{"v":2524.5999999999995,"d":"2,525"},{"v":2664.7999999999993,"d":"2,665"},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7,"d":"2,878"},{"v":2950.4,"d":"2,950"},{"v":3023.1,"d":"3,023"},{"v":3095.7999999999997,"d":"3,096"}]
[null,0.8,{"v":1823.5999999999995,"d":"1,824"},{"v":1963.7999999999995,"d":"1,964"},{"v":2103.9999999999995,"d":"2,104"},{"v":2244.2,"d":"2,244"},{"v":2384.3999999999996,"d":"2,384"},{"v":2524.5999999999995,"d":"2,525"},{"v":2664.7999999999997,"d":"2,665"},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7000000000003,"d":"2,878"},{"v":2950.4,"d":"2,950"},{"v":3023.1,"d":"3,023"}]
[null,0.7,{"v":1683.3999999999994,"d":"1,683"},{"v":1823.5999999999995,"d":"1,824"},{"v":1963.7999999999995,"d":"1,964"},{"v":2103.9999999999995,"d":"2,104"},{"v":2244.1999999999994,"d":"2,244"},{"v":2384.399999999999,"d":"2,384"},{"v":2524.5999999999995,"d":"2,525"},{"v":2664.7999999999993,"d":"2,665"},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7,"d":"2,878"},{"v":2950.3999999999996,"d":"2,950"}]
[null,0.6,{"v":1543.1999999999994,"d":"1,543"},{"v":1683.3999999999994,"d":"1,683"},{"v":1823.5999999999995,"d":"1,824"},{"v":1963.7999999999995,"d":"1,964"},{"v":2103.9999999999995,"d":"2,104"},{"v":2244.1999999999994,"d":"2,244"},{"v":2384.3999999999996,"d":"2,384"},{"v":2524.5999999999995,"d":"2,525"},{"v":2664.7999999999997,"d":"2,665"},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}},{"v":2877.7,"d":"2,878"}]
[null,0.5,{"$f":"H3","v":{"v":1403,"d":"1,403"}},{"v":1543.2,"d":"1,543"},{"v":1683.4,"d":"1,683"},{"v":1823.6000000000001,"d":"1,824"},{"v":1963.8000000000002,"d":"1,964"},{"v":2104,"d":"2,104"},{"v":2244.2000000000003,"d":"2,244"},{"v":2384.4,"d":"2,384"},{"v":2524.6000000000004,"d":"2,525"},{"$f":"K68+$P$58*(L$57-K$57)","v":{"v":2664.8,"d":"2,665"}},{"$f":"$F$3","v":{"v":2805,"d":"2,805"}}]
[]
["NON-TRAWL"]
["Year","Primary index","Standardized Primary","Secondary index","Standardized Secondary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",null,null,"row","column","floor","ceiling"]
[1998,{"$f":"IF($B$3=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B72/D$13","v":{"v":1.7716161685247245,"d":"1.7716"}},{"$f":"IF($C$3=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"D72/E$13","v":{"v":1.0716793496457775,"d":"1.0717"}},null,{"$f":"INDEX($C$98:$M$108,N72,O72)","v":{"v":820.3999999999999,"d":"820"}},null,{"$f":"G72","v":{"v":820.3999999999999,"d":"820"}},{"$nulls":4},{"$f":"MATCH(MIN($B$98,MAX($B$108,ROUND(C72,1))),$B$98:$B$108,0)","v":1},{"$f":"MATCH(MIN($M$97,MAX($C$97,ROUND(E72,1))),$C$97:$M$97,0)","v":7},{"$f":"$H$4","v":355},{"$f":"$G$4","v":894}]
[1999,{"$f":"IF($B$3=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"B73/D$13","v":{"v":1.5512892415019492,"d":"1.5513"}},{"$f":"IF($C$3=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"$f":"D73/E$13","v":{"v":0.8580824955900197,"d":"0.8581"}},null,{"$f":"INDEX($C$98:$M$108,N73,O73)","v":{"v":783.5999999999999,"d":"784"}},{"$f":"(G73-G72)/G72","v":{"v":-0.04485616772306187,"d":"-4%"}},{"$f":"IF(H73>0,IF(ABS(H73)>$H$8,G72*(1+SIGN(H73)*$H$8),G73),IF(ABS(H73)>$H$9,G72*(1+SIGN(H73)*$H$9),G73))","v":{"v":783.5999999999999,"d":"784"}},{"$f":"(G73-I72)/I72","v":{"v":-0.04485616772306187,"d":"-4%"}},{"$f":"(I73-I72)/I72","v":{"v":-0.04485616772306187,"d":"-4%"}},null,null,{"$f":"MATCH(MIN($B$98,MAX($B$108,ROUND(C73,1))),$B$98:$B$108,0)","v":1},{"$f":"MATCH(MIN($M$97,MAX($C$97,ROUND(E73,1))),$C$97:$M$97,0)","v":5},{"$f":"$H$4","v":355},{"$f":"$G$4","v":894}]
[2000,{"$f":"IF($B$3=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":1.5514807468709388,"d":"1.5515"},{"$f":"IF($C$3=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.7887067158921959,"d":"0.7887"},null,{"v":765.1999999999999,"d":"765"},{"$f":"(G74-G73)/G73","v":{"v":-0.02348136804492085,"d":"-2%"}},{"v":765.1999999999999,"d":"765"},{"$f":"(G74-I73)/I73","v":{"v":-0.02348136804492085,"d":"-2%"}},{"$f":"(I74-I73)/I73","v":{"v":-0.02348136804492085,"d":"-2%"}},null,null,1,4,355,894]
[2001,{"$f":"IF($B$3=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.319471992339785,"d":"1.3195"},{"$f":"IF($C$3=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":0.9385169300840096,"d":"0.9385"},null,{"v":746.8,"d":"747"},{"v":-0.02404600104547828,"d":"-2%"},{"v":746.8,"d":"747"},{"$f":"(G75-I74)/I74","v":{"v":-0.02404600104547828,"d":"-2%"}},{"$f":"(I75-I74)/I74","v":{"v":-0.02404600104547828,"d":"-2%"}},null,null,3,5,355,894]
[2002,{"$f":"IF($B$3=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.158990493126325,"d":"1.1590"},{"$f":"IF($C$3=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.6759203994584602,"d":"0.6759"},null,{"v":674.5,"d":"675"},{"v":-0.09681306909480444,"d":"-10%"},{"v":674.5,"d":"675"},{"v":-0.09681306909480444,"d":"-10%"},{"v":-0.09681306909480444,"d":"-10%"},null,null,4,3,355,894]
[2003,{"$f":"IF($B$3=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.040448669721633,"d":"1.0404"},{"$f":"IF($C$3=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":0.8782525781058637,"d":"0.8783"},null,{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,6,5,355,894]
[2004,{"$f":"IF($B$3=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":0.9562820600506121,"d":"0.9563"},{"$f":"IF($C$3=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":0.8644558429154544,"d":"0.8645"},null,{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,6,5,355,894]
[2005,{"$f":"IF($B$3=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":0.9144381369263388,"d":"0.9144"},{"$f":"IF($C$3=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":0.8806915963211238,"d":"0.8807"},null,639,{"v":-0.05263157894736842,"d":"-5%"},639,{"v":-0.05263157894736842,"d":"-5%"},{"v":-0.05263157894736842,"d":"-5%"},null,null,7,5,355,894]
[2006,{"$f":"IF($B$3=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":0.9385678134190547,"d":"0.9386"},{"$f":"IF($C$3=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.0365096373973932,"d":"1.0365"},null,{"v":674.5,"d":"675"},{"v":0.05555555555555555,"d":"6%"},{"v":674.5,"d":"675"},{"v":0.05555555555555555,"d":"6%"},{"v":0.05555555555555555,"d":"6%"},null,null,7,6,355,894]
[2007,{"$f":"IF($B$3=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":0.926215717119212,"d":"0.9262"},{"$f":"IF($C$3=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":0.9563543276037872,"d":"0.9564"},null,{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,7,6,355,894]
[2008,{"$f":"IF($B$3=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":0.9828055536557007,"d":"0.9828"},{"$f":"IF($C$3=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":0.9320571870179798,"d":"0.9321"},null,{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,6,5,355,894]
[2009,{"$f":"IF($B$3=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":0.9416318993228917,"d":"0.9416"},{"$f":"IF($C$3=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.1171766758083699,"d":"1.1172"},null,710,{"v":0.05263157894736842,"d":"5%"},710,{"v":0.05263157894736842,"d":"5%"},{"v":0.05263157894736842,"d":"5%"},null,null,7,7,355,894]
[2010,{"$f":"IF($B$3=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":0.8757540523903973,"d":"0.8758"},{"$f":"IF($C$3=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.2994916259425207,"d":"1.2995"},null,{"v":746.8,"d":"747"},{"v":0.05183098591549289,"d":"5%"},{"v":746.8,"d":"747"},{"v":0.05183098591549289,"d":"5%"},{"v":0.05183098591549289,"d":"5%"},null,null,7,9,355,894]
[2011,{"$f":"IF($B$3=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":0.8300800218863278,"d":"0.8301"},{"$f":"IF($C$3=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.240549793378099,"d":"1.2405"},null,710,{"v":-0.04927691483663626,"d":"-5%"},710,{"v":-0.04927691483663626,"d":"-5%"},{"v":-0.04927691483663626,"d":"-5%"},null,null,8,8,355,894]
[2012,{"$f":"IF($B$3=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":0.8046098078106833,"d":"0.8046"},{"$f":"IF($C$3=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.2560611517280098,"d":"1.2561"},null,{"v":728.4,"d":"728"},{"v":0.025915492957746446,"d":"3%"},{"v":728.4,"d":"728"},{"v":0.025915492957746446,"d":"3%"},{"v":0.025915492957746446,"d":"3%"},null,null,8,9,355,894]
[2013,{"$f":"IF($B$3=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":0.7649681964297927,"d":"0.7650"},{"$f":"IF($C$3=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.2227589166417185,"d":"1.2228"},null,710,{"v":-0.025260845689181737,"d":"-3%"},710,{"v":-0.025260845689181737,"d":"-3%"},{"v":-0.025260845689181737,"d":"-3%"},null,null,8,8,355,894]
[2014,{"$f":"IF($B$3=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":0.7655427125367621,"d":"0.7655"},{"$f":"IF($C$3=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.1392740479221033,"d":"1.1393"},null,{"v":674.5,"d":"675"},{"v":-0.05,"d":"-5%"},{"v":674.5,"d":"675"},{"v":-0.05,"d":"-5%"},{"v":-0.05,"d":"-5%"},null,null,8,7,355,894]
[2015,{"$f":"IF($B$3=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":0.7784693249435742,"d":"0.7785"},{"$f":"IF($C$3=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.1446571671437948,"d":"1.1447"},null,{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":674.5,"d":"675"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,8,7,355,894]
[2016,{"$f":"IF($B$3=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":0.7493605088571232,"d":"0.7494"},{"$f":"IF($C$3=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.0214900701862542,"d":"1.0215"},null,{"v":603.5,"d":"604"},{"v":-0.10526315789473684,"d":"-11%"},{"v":603.5,"d":"604"},{"v":-0.10526315789473684,"d":"-11%"},{"v":-0.10526315789473684,"d":"-11%"},null,null,9,6,355,894]
[2017,{"$f":"IF($B$3=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":0.6942069625880583,"d":"0.6942"},{"$f":"IF($C$3=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":0.841919846272546,"d":"0.8419"},null,{"v":532.5,"d":"533"},{"v":-0.11764705882352941,"d":"-12%"},{"v":532.5,"d":"533"},{"v":-0.11764705882352941,"d":"-12%"},{"v":-0.11764705882352941,"d":"-12%"},null,null,9,4,355,894]
[2018,{"$f":"IF($B$3=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":0.6837699199781136,"d":"0.6838"},{"$f":"IF($C$3=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":0.8353936449445201,"d":"0.8354"},null,{"v":532.5,"d":"533"},{"v":0,"d":"0%"},{"$f":"IF(H92>0,IF(ABS(H92)>$H$8,G91*(1+SIGN(H92)*$H$8),G92),IF(ABS(H92)>$H$9,G91*(1+SIGN(H92)*$H$9),G92))","v":{"v":532.5,"d":"533"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,9,4,355,894]
[]
["what-if",100000,{"v":9.575268449490459,"d":"9.5753"},100000,{"v":0.6645826199619099,"d":"0.6646"},null,{"v":746.8,"d":"747"},{"$f":"(G94-G92)/G92","v":{"v":0.4024413145539905,"d":"40%"}},{"$f":"IF(H94>0,IF(ABS(H94)>$H$8,G92*(1+SIGN(H94)*$H$8),G94),IF(ABS(H94)>$H$9,G92*(1+SIGN(H94)*$H$9),G94))","v":{"v":612.375,"d":"612"}},{"$f":"(G94-I92)/I92","v":{"v":0.4024413145539905,"d":"40%"}},{"$f":"(I94-I92)/I92","v":{"v":0.15,"d":"15%"}},null,null,1,3]
[]
[null,null,"Secondary Index Standardized to average"]
["Primary Index Standardzied to average",null,0.5,0.6,0.7,0.8,0.9,1,1.1,1.2,1.3,1.4,1.5,null,"slopeHi","slopeLow"]
[null,1.5,{"$f":"$F$4","v":710},{"$f":"C98+$O$98*(D$97-C$97)","v":{"v":728.4,"d":"728"}},{"$f":"D98+$O$98*(E$97-D$97)","v":{"v":746.8,"d":"747"}},{"v":765.1999999999999,"d":"765"},{"v":783.5999999999999,"d":"784"},{"v":801.9999999999999,"d":"802"},{"v":820.3999999999999,"d":"820"},{"v":838.7999999999998,"d":"839"},{"v":857.1999999999998,"d":"857"},{"v":875.5999999999998,"d":"876"},{"$f":"G4","v":894},null,{"$f":"(M98-C98)/(M97-C97)","v":184},{"$f":"(M108-C108)/(M97-C97)","v":355}]
[null,1.4,{"$f":"C98+$P$98*(B99-B98)","v":{"v":674.5,"d":"675"}},{"$f":"$F$4","v":710},{"v":728.4,"d":"728"},{"v":746.8,"d":"747"},{"v":765.1999999999999,"d":"765"},{"v":783.5999999999999,"d":"784"},{"v":801.9999999999999,"d":"802"},{"v":820.3999999999999,"d":"820"},{"v":838.7999999999998,"d":"839"},{"v":857.1999999999998,"d":"857"},{"$f":"M98+$O$98*(B99-B98)","v":{"v":875.6,"d":"876"}}]
[null,1.3,{"$f":"C99+$P$98*(B100-B99)","v":639},{"$f":"C100+$P$98*(D$97-C$97)","v":{"v":674.5,"d":"675"}},{"$f":"$F$4","v":710},{"v":728.4,"d":"728"},{"v":746.8,"d":"747"},{"v":765.1999999999999,"d":"765"},{"v":783.5999999999999,"d":"784"},{"v":801.9999999999999,"d":"802"},{"v":820.3999999999999,"d":"820"},{"v":838.7999999999998,"d":"839"},{"$f":"M99+$O$98*(B100-B99)","v":{"v":857.2,"d":"857"}}]
[null,1.2,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"$F$4","v":710},{"v":728.4,"d":"728"},{"v":746.8,"d":"747"},{"v":765.1999999999999,"d":"765"},{"v":783.5999999999999,"d":"784"},{"v":801.9999999999999,"d":"802"},{"v":820.3999999999999,"d":"820"},{"v":838.8000000000001,"d":"839"}]
[null,1.1,568,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"$F$4","v":710},{"v":728.4,"d":"728"},{"v":746.8,"d":"747"},{"v":765.1999999999999,"d":"765"},{"v":783.5999999999999,"d":"784"},{"v":801.9999999999999,"d":"802"},{"v":820.4000000000001,"d":"820"}]
[null,1,{"v":532.5,"d":"533"},568,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"F4","v":710},{"v":728.4,"d":"728"},{"v":746.8,"d":"747"},{"v":765.1999999999999,"d":"765"},{"v":783.5999999999999,"d":"784"},{"v":802.0000000000001,"d":"802"}]
[null,0.9,497,{"v":532.5,"d":"533"},568,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"$F$4","v":710},{"v":728.4,"d":"728"},{"v":746.8,"d":"747"},{"v":765.1999999999999,"d":"765"},{"v":783.6000000000001,"d":"784"}]
[null,0.8,{"v":461.5,"d":"462"},497,{"v":532.5,"d":"533"},568,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"$F$4","v":710},{"v":728.4,"d":"728"},{"v":746.8,"d":"747"},{"v":765.2000000000002,"d":"765"}]
[null,0.7,426,{"v":461.5,"d":"462"},497,{"v":532.5,"d":"533"},568,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"$F$4","v":710},{"v":728.4,"d":"728"},{"v":746.8000000000002,"d":"747"}]
[null,0.6,{"v":390.5,"d":"391"},426,{"v":461.5,"d":"462"},497,{"v":532.5,"d":"533"},568,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"$F$4","v":710},{"v":728.4000000000002,"d":"728"}]
[null,0.5,{"$f":"H4","v":355},{"$f":"C108+$P$98*(D$97-C$97)","v":{"v":390.5,"d":"391"}},426,{"v":461.5,"d":"462"},497,{"v":532.5,"d":"533"},568,{"v":603.5,"d":"604"},639,{"v":674.5,"d":"675"},{"$f":"$F$4","v":710}]

{"sheet":"Alt3-3a","index":9,"n_rows":80,"n_cols":16,"rows_kept":80,"merged":[[5,0,5,1],[6,3,6,4],[6,6,6,7],[9,0,9,2],[29,0,29,10],[55,0,55,10]]}
["PSC Limit","Primary Index","Second Index",null,null,"Element 1","Element 2","Element 3"]
["Trawl","Setline",{"$f":"IF(B2=\"Trawl\",\"Setline\",\"Trawl\")","v":"Trawl"},null,"Gear","Starting point","Ceiling","Floor"]
["Non-trawl","Setline",{"$f":"IF(B3=\"Trawl\",\"Setline\",\"Trawl\")","v":"Trawl"},null,"Trawl",1563,2805,798]
[{"$nulls":4},"Non-trawl",395,710,202]
[{"$nulls":4},"Total",{"$f":"SUM(F3:F4)","v":1958},{"$f":"SUM(G3:G4)","v":3515},{"$f":"SUM(H3:H4)","v":1000}]
["Element 4: Breakpoint"]
["Low Threshold",1,null,"Element 5: slope multiplier",null,null,"Element 6 Constraint"]
["High Threshold",1,null,"Low Multiplier",0.35,null,"Up",{"v":0.2,"d":"20%"}]
[{"$nulls":3},"High Multiplier",0.35,null,"Down",{"v":0.2,"d":"20%"}]
["Standardized Year or Mean"]
[null,"Primary","Secondary"]
["Trawl",2018,2018,{"$f":"VLOOKUP(B12,A32:D52,2)","v":7141},{"$f":"IF(C12=\"Mean\",AVERAGE(D32:D52),VLOOKUP(C12,A32:D52,4))","v":125702}]
["Non-trawl",2018,2018,{"$f":"VLOOKUP(B13,A58:D78,2)","v":7141},{"$f":"IF(C13=\"Mean\",AVERAGE(D58:D78),VLOOKUP(C13,A58:D78,4))","v":125702}]
{"$rows_empty":16}
["TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary","Secondary index","Standardized Secondary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",null,null,"slope modifier for Alt 3","Floor","Ceiling"]
[1998,{"$f":"IF($B$2=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B32/D$12","v":{"v":2.5909536479484667,"d":"2.5910"}},{"$f":"IF($C$2=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"D32/E$12","v":{"v":1.2828435506197196,"d":"1.2828"}},null,{"$f":"MIN($G$3,MAX($H$3,$F$3*(1-1*(1-(C32+N32)))))","v":{"v":2805,"d":"2,805"}},null,{"$f":"G32","v":{"v":2805,"d":"2,805"}},{"$nulls":4},{"$f":"IF(E32<$B$7,$E$8*(E32-$B$7),IF(E32>$B$8,$E$9*(E32-$B$8),0))","v":0.09899524271690184},{"$f":"$H$3","v":798},{"$f":"$G$3","v":2805}]
[1999,{"$f":"IF($B$2=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"v":2.268729869766139,"d":"2.2687"},{"$f":"IF($C$2=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"$f":"D33/E$12","v":{"v":1.0271594724029849,"d":"1.0272"}},null,{"v":2805,"d":"2,805"},{"$f":"(G33-G32)/G32","v":{"v":0,"d":"0%"}},{"$f":"IF(J33>0,IF(ABS(J33)>$H$8,I32*(1+SIGN(J33)*$H$8),G33),IF(ABS(J33)>$H$9,I32*(1+SIGN(J33)*$H$9),G33))","v":{"v":2805,"d":"2,805"}},{"$f":"(G33-I32)/I32","v":{"v":0,"d":"0%"}},{"$f":"(I33-I32)/I32","v":{"v":0,"d":"0%"}},null,null,0.009505815341044709,798,2805]
[2000,{"$f":"IF($B$2=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},{"$f":"IF($C$2=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.9441138565814386,"d":"0.9441"},null,{"v":2805,"d":"2,805"},{"$f":"(G34-G33)/G33","v":{"v":0,"d":"0%"}},{"v":2805,"d":"2,805"},{"v":0,"d":"0%"},{"$f":"(I34-I33)/I33","v":{"v":0,"d":"0%"}},null,null,-0.01956015019649647,798,2805]
[2001,{"$f":"IF($B$2=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},{"$f":"IF($C$2=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":1.1234427455410416,"d":"1.1234"},null,{"v":2805,"d":"2,805"},{"v":0,"d":"0%"},{"v":2805,"d":"2,805"},{"v":0,"d":"0%"},{"$f":"(I35-I34)/I34","v":{"v":0,"d":"0%"}},null,null,0.043204960939364566,798,2805]
[2002,{"$f":"IF($B$2=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},{"$f":"IF($C$2=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.8091040715342636,"d":"0.8091"},null,{"v":2544.856476717359,"d":"2,545"},{"v":-0.09274278904906992,"d":"-9%"},{"v":2544.856476717359,"d":"2,545"},{"v":-0.09274278904906992,"d":"-9%"},{"v":-0.09274278904906992,"d":"-9%"},null,null,-0.06681357496300774,798,2805]
[2003,{"$f":"IF($B$2=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},{"$f":"IF($C$2=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":1.0513038774243846,"d":"1.0513"},null,{"v":2406.3822684304037,"d":"2,406"},{"v":-0.054413366550861354,"d":"-5%"},{"v":2406.3822684304037,"d":"2,406"},{"v":-0.054413366550861354,"d":"-5%"},{"v":-0.054413366550861354,"d":"-5%"},null,null,0.017956357098534603,798,2805]
[2004,{"$f":"IF($B$2=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},{"$f":"IF($C$2=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":1.0347886270703728,"d":"1.0348"},null,{"v":2204.9547985956883,"d":"2,205"},{"v":-0.08370551615064019,"d":"-8%"},{"v":2204.9547985956883,"d":"2,205"},{"v":-0.08370551615064019,"d":"-8%"},{"v":-0.08370551615064019,"d":"-8%"},null,null,0.012176019474630472,798,2805]
[2005,{"$f":"IF($B$2=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},{"$f":"IF($C$2=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":1.054223480931091,"d":"1.0542"},null,{"v":2119.9374266059076,"d":"2,120"},{"v":-0.03855742169586757,"d":"-4%"},{"v":2119.9374266059076,"d":"2,120"},{"v":-0.03855742169586757,"d":"-4%"},{"v":-0.03855742169586757,"d":"-4%"},null,null,0.01897821832588188,798,2805]
[2006,{"$f":"IF($B$2=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},{"$f":"IF($C$2=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.240743981798221,"d":"1.2407"},null,{"v":2277.130447420283,"d":"2,277"},{"v":0.07414983991581618,"d":"7%"},{"v":2277.130447420283,"d":"2,277"},{"v":0.07414983991581618,"d":"7%"},{"v":0.07414983991581618,"d":"7%"},null,null,0.08426039362937737,798,2805]
[2007,{"$f":"IF($B$2=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},{"$f":"IF($C$2=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":1.1447948322222399,"d":"1.1448"},null,{"v":2196.4063440132486,"d":"2,196"},{"v":-0.035449924925682295,"d":"-4%"},{"v":2196.4063440132486,"d":"2,196"},{"v":-0.035449924925682295,"d":"-4%"},{"v":-0.035449924925682295,"d":"-4%"},null,null,0.05067819127778395,798,2805]
[2008,{"$f":"IF($B$2=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},{"$f":"IF($C$2=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":1.1157101716758684,"d":"1.1157"},null,{"v":2309.8518330870384,"d":"2,310"},{"v":0.05165050145798771,"d":"5%"},{"v":2309.8518330870384,"d":"2,310"},{"v":0.05165050145798771,"d":"5%"},{"v":0.05165050145798771,"d":"5%"},null,null,0.040498560086553934,798,2805]
[2009,{"$f":"IF($B$2=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},{"$f":"IF($C$2=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.3373056912380072,"d":"1.3373"},null,{"v":2336.9585916251926,"d":"2,337"},{"v":0.011735280224414663,"d":"1%"},{"v":2336.9585916251926,"d":"2,337"},{"v":0.011735280224414663,"d":"1%"},{"v":0.011735280224414663,"d":"1%"},null,null,0.11805699193330253,798,2805]
[2010,{"$f":"IF($B$2=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},{"$f":"IF($C$2=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.5555440645335794,"d":"1.5555"},null,{"v":2305.758581035233,"d":"2,306"},{"v":-0.013350690380980277,"d":"-1%"},{"v":2305.758581035233,"d":"2,306"},{"v":-0.013350690380980277,"d":"-1%"},{"v":-0.013350690380980277,"d":"-1%"},null,null,0.1944404225867528,798,2805]
[2011,{"$f":"IF($B$2=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},{"$f":"IF($C$2=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.4849883056753275,"d":"1.4850"},null,{"v":2162.756768037697,"d":"2,163"},{"v":-0.062019421362548496,"d":"-6%"},{"v":2162.756768037697,"d":"2,163"},{"v":-0.062019421362548496,"d":"-6%"},{"v":-0.062019421362548496,"d":"-6%"},null,null,0.1697459069863646,798,2805]
[2012,{"$f":"IF($B$2=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},{"$f":"IF($C$2=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.503556029339231,"d":"1.5036"},null,{"v":2114.692983741078,"d":"2,115"},{"v":-0.02222338868934759,"d":"-2%"},{"v":2114.692983741078,"d":"2,115"},{"v":-0.02222338868934759,"d":"-2%"},{"v":-0.02222338868934759,"d":"-2%"},null,null,0.1762446102687308,798,2805]
[2013,{"$f":"IF($B$2=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},{"$f":"IF($C$2=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.4636919062544749,"d":"1.4637"},null,{"v":2002.2702752971857,"d":"2,002"},{"v":-0.05316266205461499,"d":"-5%"},{"v":2002.2702752971857,"d":"2,002"},{"v":-0.05316266205461499,"d":"-5%"},{"v":-0.05316266205461499,"d":"-5%"},null,null,0.1622921671890662,798,2805]
[2014,{"$f":"IF($B$2=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},{"$f":"IF($C$2=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.3637571399023087,"d":"1.3638"},null,{"v":1948.9142228122091,"d":"1,949"},{"v":-0.02664777734717018,"d":"-3%"},{"v":1948.9142228122091,"d":"1,949"},{"v":-0.02664777734717018,"d":"-3%"},{"v":-0.02664777734717018,"d":"-3%"},null,null,0.12731499896580806,798,2805]
[2015,{"$f":"IF($B$2=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},{"$f":"IF($C$2=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.3702009514566196,"d":"1.3702"},null,{"v":1981.9876925024657,"d":"1,982"},{"v":0.016970202845835287,"d":"2%"},{"v":1981.9876925024657,"d":"1,982"},{"v":0.016970202845835287,"d":"2%"},{"v":0.016970202845835287,"d":"2%"},null,null,0.12957033300981685,798,2805]
[2016,{"$f":"IF($B$2=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},{"$f":"IF($C$2=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.2227649520294028,"d":"1.2228"},null,{"v":1834.7942489849988,"d":"1,835"},{"v":-0.07426556889040005,"d":"-7%"},{"v":1834.7942489849988,"d":"1,835"},{"v":-0.07426556889040005,"d":"-7%"},{"v":-0.07426556889040005,"d":"-7%"},null,null,0.07796773321029099,798,2805]
[2017,{"$f":"IF($B$2=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},{"$f":"IF($C$2=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":1.0078121270942388,"d":"1.0078"},null,{"v":1591.1312070984761,"d":"1,591"},{"v":-0.1328012893114943,"d":"-13%"},{"v":1591.1312070984761,"d":"1,591"},{"v":-0.1328012893114943,"d":"-13%"},{"v":-0.1328012893114943,"d":"-13%"},null,null,2.7342444829835943E-3,798,2805]
[2018,{"$f":"IF($B$2=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},{"$f":"IF($C$2=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":1,"d":"1.0000"},null,{"v":1563,"d":"1,563"},{"v":-0.017680004623738782,"d":"-2%"},{"v":1563,"d":"1,563"},{"v":-0.017680004623738782,"d":"-2%"},{"v":-0.017680004623738782,"d":"-2%"}]
[]
["what-if",9000,{"$f":"B54/$D$12","v":1.2603276851981515},100000,{"$f":"D54/$E$12","v":0.7955322906556778},null,{"$f":"MIN($G$3,MAX($H$3,$F$3*(1-1*(1-(C54+N54)))))","v":{"v":1858.0381115678993,"d":"1,858"}},{"$f":"(G54-G51)/G51","v":{"v":0.16774663414222388,"d":"17%"}},{"$f":"IF(ABS(J54)>$H$8,I51*(1+SIGN(J54)*$H$8),G54)","v":{"v":1858.0381115678993,"d":"1,858"}},{"$f":"(G54-I51)/I51","v":{"v":0.16774663414222388,"d":"17%"}},{"$f":"(I54-I51)/I51","v":{"v":0.16774663414222388,"d":"17%"}},null,null,{"$f":"IF(E54<$B$7,$E$8*(E54-$B$7),IF(E54>$B$8,$E$9*(E54-$B$8),0))","v":-0.07156369827051277}]
[]
["NON-TRAWL PSC LIMIT"]
["Year","Primary index","Standardized Primary","Secondary index","Standardized Secondary",null,"PSC Limit without Element 6","% change without element 6","PSC Limit with Element 6","Potential Percent change","Actual Percent Change",null,null,"slope modifier for Alt 3"]
[1998,{"$f":"IF($B$3=\"Trawl\",Indices!B2,Indices!C2)","v":18502},{"$f":"B58/D$13","v":{"v":2.5909536479484667,"d":"2.5910"}},{"$f":"IF($C$3=\"Trawl\",Indices!B2,Indices!C2)","v":161256},{"$f":"D58/E$13","v":{"v":1.2828435506197196,"d":"1.2828"}},null,{"$f":"MIN($G$4,MAX($H$4,$F$4*(1-1*(1-(C58+N58)))))","v":710},null,{"$f":"G58","v":710},{"$nulls":4},{"$f":"IF(E58<$B$7,$E$8*(E58-$B$7),IF(E58>$B$8,$E$9*(E58-$B$8),0))","v":0.09899524271690184}]
[1999,{"$f":"IF($B$3=\"Trawl\",Indices!B3,Indices!C3)","v":16201},{"$f":"B59/D$13","v":{"v":2.268729869766139,"d":"2.2687"}},{"$f":"IF($C$3=\"Trawl\",Indices!B3,Indices!C3)","v":129116},{"$f":"D59/E$13","v":{"v":1.0271594724029849,"d":"1.0272"}},null,{"$f":"MIN($G$4,MAX($H$4,$F$4*(1-1*(1-(C59+N59)))))","v":710},{"$f":"(G59-G58)/G58","v":{"v":0,"d":"0%"}},{"$f":"IF(J59>0,IF(ABS(J59)>$H$8,I58*(1+SIGN(J59)*$H$8),G59),IF(ABS(J59)>$H$9,I58*(1+SIGN(J59)*$H$9),G59))","v":710},{"$f":"(G59-I58)/I58","v":{"v":0,"d":"0%"}},{"$f":"(I59-I58)/I58","v":{"v":0,"d":"0%"}},null,null,0.009505815341044709]
[2000,{"$f":"IF($B$3=\"Trawl\",Indices!B4,Indices!C4)","v":16203},{"v":2.2690099425850723,"d":"2.2690"},{"$f":"IF($C$3=\"Trawl\",Indices!B4,Indices!C4)","v":118677},{"v":0.9441138565814386,"d":"0.9441"},null,710,{"$f":"(G60-G59)/G59","v":{"v":0,"d":"0%"}},710,{"v":0,"d":"0%"},{"$f":"(I60-I59)/I59","v":{"v":0,"d":"0%"}},null,null,-0.01956015019649647]
[2001,{"$f":"IF($B$3=\"Trawl\",Indices!B5,Indices!C5)","v":13780},{"v":1.9297017224478363,"d":"1.9297"},{"$f":"IF($C$3=\"Trawl\",Indices!B5,Indices!C5)","v":141219},{"v":1.1234427455410416,"d":"1.1234"},null,710,{"v":0,"d":"0%"},710,{"v":0,"d":"0%"},{"$f":"(I61-I60)/I60","v":{"v":0,"d":"0%"}},null,null,0.043204960939364566]
[2002,{"$f":"IF($B$3=\"Trawl\",Indices!B6,Indices!C6)","v":12104},{"v":1.6950007001820473,"d":"1.6950"},{"$f":"IF($C$3=\"Trawl\",Indices!B6,Indices!C6)","v":101706},{"v":0.8091040715342636,"d":"0.8091"},null,{"v":643.1339144615207,"d":"643"},{"v":-0.0941775852654638,"d":"-9%"},{"v":643.1339144615207,"d":"643"},{"v":-0.0941775852654638,"d":"-9%"},{"v":-0.0941775852654638,"d":"-9%"},null,null,-0.06681357496300774]
[2003,{"$f":"IF($B$3=\"Trawl\",Indices!B7,Indices!C7)","v":10866},{"v":1.5216356252625682,"d":"1.5216"},{"$f":"IF($C$3=\"Trawl\",Indices!B7,Indices!C7)","v":132151},{"v":1.0513038774243846,"d":"1.0513"},null,{"v":608.1388330326356,"d":"608"},{"v":-0.05441336655086145,"d":"-5%"},{"v":608.1388330326356,"d":"608"},{"v":-0.05441336655086145,"d":"-5%"},{"v":-0.05441336655086145,"d":"-5%"},null,null,0.017956357098534603]
[2004,{"$f":"IF($B$3=\"Trawl\",Indices!B8,Indices!C8)","v":9987},{"v":1.3985436213415487,"d":"1.3985"},{"$f":"IF($C$3=\"Trawl\",Indices!B8,Indices!C8)","v":130075},{"v":1.0347886270703728,"d":"1.0348"},null,{"v":557.2342581223908,"d":"557"},{"v":-0.08370551615064031,"d":"-8%"},{"v":557.2342581223908,"d":"557"},{"v":-0.08370551615064031,"d":"-8%"},{"v":-0.08370551615064031,"d":"-8%"},null,null,0.012176019474630472]
[2005,{"$f":"IF($B$3=\"Trawl\",Indices!B9,Indices!C9)","v":9550},{"v":1.3373477104047051,"d":"1.3373"},{"$f":"IF($C$3=\"Trawl\",Indices!B9,Indices!C9)","v":132518},{"v":1.054223480931091,"d":"1.0542"},null,{"v":535.7487418485819,"d":"536"},{"v":-0.03855742169586752,"d":"-4%"},{"v":535.7487418485819,"d":"536"},{"v":-0.03855742169586752,"d":"-4%"},{"v":-0.03855742169586752,"d":"-4%"},null,null,0.01897821832588188]
[2006,{"$f":"IF($B$3=\"Trawl\",Indices!B10,Indices!C10)","v":9802},{"v":1.3726368855902535,"d":"1.3726"},{"$f":"IF($C$3=\"Trawl\",Indices!B10,Indices!C10)","v":155964},{"v":1.240743981798221,"d":"1.2407"},null,{"v":575.4744252917542,"d":"575"},{"v":0.07414983991581628,"d":"7%"},{"v":575.4744252917542,"d":"575"},{"v":0.07414983991581628,"d":"7%"},{"v":0.07414983991581628,"d":"7%"},null,null,0.08426039362937737]
[2007,{"$f":"IF($B$3=\"Trawl\",Indices!B11,Indices!C11)","v":9673},{"v":1.35457218876908,"d":"1.3546"},{"$f":"IF($C$3=\"Trawl\",Indices!B11,Indices!C11)","v":143903},{"v":1.1447948322222399,"d":"1.1448"},null,{"v":555.0739001185113,"d":"555"},{"v":-0.035449924925682275,"d":"-4%"},{"v":555.0739001185113,"d":"555"},{"v":-0.035449924925682275,"d":"-4%"},{"v":-0.035449924925682275,"d":"-4%"},null,null,0.05067819127778395]
[2008,{"$f":"IF($B$3=\"Trawl\",Indices!B12,Indices!C12)","v":10264},{"v":1.4373337067637586,"d":"1.4373"},{"$f":"IF($C$3=\"Trawl\",Indices!B12,Indices!C12)","v":140247},{"v":1.1157101716758684,"d":"1.1157"},null,{"v":583.7437454058735,"d":"584"},{"v":0.05165050145798779,"d":"5%"},{"v":583.7437454058735,"d":"584"},{"v":0.05165050145798779,"d":"5%"},{"v":0.05165050145798779,"d":"5%"},null,null,0.040498560086553934]
[2009,{"$f":"IF($B$3=\"Trawl\",Indices!B13,Indices!C13)","v":9834},{"v":1.3771180506931802,"d":"1.3771"},{"$f":"IF($C$3=\"Trawl\",Indices!B13,Indices!C13)","v":168102},{"v":1.3373056912380072,"d":"1.3373"},null,{"v":590.5941418374607,"d":"591"},{"v":0.011735280224414548,"d":"1%"},{"v":590.5941418374607,"d":"591"},{"v":0.011735280224414548,"d":"1%"},{"v":0.011735280224414548,"d":"1%"},null,null,0.11805699193330253]
[2010,{"$f":"IF($B$3=\"Trawl\",Indices!B14,Indices!C14)","v":9146},{"v":1.280773000980255,"d":"1.2808"},{"$f":"IF($C$3=\"Trawl\",Indices!B14,Indices!C14)","v":195535},{"v":1.5555440645335794,"d":"1.5555"},null,{"v":582.7093023089681,"d":"583"},{"v":-0.01335069038098021,"d":"-1%"},{"v":582.7093023089681,"d":"583"},{"v":-0.01335069038098021,"d":"-1%"},{"v":-0.01335069038098021,"d":"-1%"},null,null,0.1944404225867528]
[2011,{"$f":"IF($B$3=\"Trawl\",Indices!B15,Indices!C15)","v":8669},{"v":1.213975633664753,"d":"1.2140"},{"$f":"IF($C$3=\"Trawl\",Indices!B15,Indices!C15)","v":186666},{"v":1.4849883056753275,"d":"1.4850"},null,{"v":546.5700085571915,"d":"547"},{"v":-0.06201942136254853,"d":"-6%"},{"v":546.5700085571915,"d":"547"},{"v":-0.06201942136254853,"d":"-6%"},{"v":-0.06201942136254853,"d":"-6%"},null,null,0.1697459069863646]
[2012,{"$f":"IF($B$3=\"Trawl\",Indices!B16,Indices!C16)","v":8403},{"v":1.1767259487466741,"d":"1.1767"},{"$f":"IF($C$3=\"Trawl\",Indices!B16,Indices!C16)","v":189000},{"v":1.503556029339231,"d":"1.5036"},null,{"v":534.423370811085,"d":"534"},{"v":-0.022223388689347645,"d":"-2%"},{"v":534.423370811085,"d":"534"},{"v":-0.022223388689347645,"d":"-2%"},{"v":-0.022223388689347645,"d":"-2%"},null,null,0.1762446102687308]
[2013,{"$f":"IF($B$3=\"Trawl\",Indices!B17,Indices!C17)","v":7989},{"v":1.1187508752275592,"d":"1.1188"},{"$f":"IF($C$3=\"Trawl\",Indices!B17,Indices!C17)","v":183989},{"v":1.4636919062544749,"d":"1.4637"},null,{"v":506.01200175456705,"d":"506"},{"v":-0.053162662054615006,"d":"-5%"},{"v":506.01200175456705,"d":"506"},{"v":-0.053162662054615006,"d":"-5%"},{"v":-0.053162662054615006,"d":"-5%"},null,null,0.1622921671890662]
[2014,{"$f":"IF($B$3=\"Trawl\",Indices!B18,Indices!C18)","v":7995},{"v":1.1195910936843578,"d":"1.1196"},{"$f":"IF($C$3=\"Trawl\",Indices!B18,Indices!C18)","v":171427},{"v":1.3637571399023087,"d":"1.3638"},null,{"v":492.5279065968155,"d":"493"},{"v":-0.026647777347170082,"d":"-3%"},{"v":492.5279065968155,"d":"493"},{"v":-0.026647777347170082,"d":"-3%"},{"v":-0.026647777347170082,"d":"-3%"},null,null,0.12731499896580806]
[2015,{"$f":"IF($B$3=\"Trawl\",Indices!B19,Indices!C19)","v":8130},{"v":1.1384960089623302,"d":"1.1385"},{"$f":"IF($C$3=\"Trawl\",Indices!B19,Indices!C19)","v":172237},{"v":1.3702009514566196,"d":"1.3702"},null,{"v":500.88620507899805,"d":"501"},{"v":0.016970202845835204,"d":"2%"},{"v":500.88620507899805,"d":"501"},{"v":0.016970202845835204,"d":"2%"},{"v":0.016970202845835204,"d":"2%"},null,null,0.12957033300981685]
[2016,{"$f":"IF($B$3=\"Trawl\",Indices!B20,Indices!C20)","v":7826},{"v":1.095924940484526,"d":"1.0959"},{"$f":"IF($C$3=\"Trawl\",Indices!B20,Indices!C20)","v":153704},{"v":1.2227649520294028,"d":"1.2228"},null,{"v":463.6876061094527,"d":"464"},{"v":-0.07426556889039998,"d":"-7%"},{"v":463.6876061094527,"d":"464"},{"v":-0.07426556889039998,"d":"-7%"},{"v":-0.07426556889039998,"d":"-7%"},null,null,0.07796773321029099]
[2017,{"$f":"IF($B$3=\"Trawl\",Indices!B21,Indices!C21)","v":7250},{"v":1.0152639686318443,"d":"1.0153"},{"$f":"IF($C$3=\"Trawl\",Indices!B21,Indices!C21)","v":126684},{"v":1.0078121270942388,"d":"1.0078"},null,{"v":402.10929418035704,"d":"402"},{"v":-0.13280128931149435,"d":"-13%"},{"v":402.10929418035704,"d":"402"},{"v":-0.13280128931149435,"d":"-13%"},{"v":-0.13280128931149435,"d":"-13%"},null,null,2.7342444829835943E-3]
[2018,{"$f":"IF($B$3=\"Trawl\",Indices!B22,Indices!C22)","v":7141},{"v":1,"d":"1.0000"},{"$f":"IF($C$3=\"Trawl\",Indices!B22,Indices!C22)","v":125702},{"v":1,"d":"1.0000"},null,395,{"v":-0.017680004623738754,"d":"-2%"},395,{"v":-0.017680004623738754,"d":"-2%"},{"v":-0.017680004623738754,"d":"-2%"}]
[]
["what-if",9000,{"v":1.2603276851981515,"d":"1.2603"},100000,{"v":0.7955322906556778,"d":"0.7955"},null,{"v":469.5617748364173,"d":"470"},{"$f":"(G80-G77)/G77","v":{"v":0.16774663414222404,"d":"17%"}},{"$f":"IF(ABS(J80)>$H$8,I77*(1+SIGN(J80)*$H$8),G80)","v":{"v":469.5617748364173,"d":"470"}},{"$f":"(G80-I77)/I77","v":{"v":0.16774663414222404,"d":"17%"}},{"$f":"(I80-I77)/I77","v":{"v":0.16774663414222404,"d":"17%"}},null,null,{"$f":"IF(E80<$B$7,$E$8*(E80-$B$7),IF(E80>$B$8,$E$9*(E80-$B$8),0))","v":-0.07156369827051277}]

{"sheet":"Indices","index":10,"n_rows":25,"n_cols":3,"rows_kept":25}
["Year","Trawl","Setline"]
[1998,161256,18502]
[1999,129116,16201]
[2000,118677,16203]
[2001,141219,13780]
[2002,101706,12104]
[2003,132151,10866]
[2004,130075,9987]
[2005,132518,9550]
[2006,155964,9802]
[2007,143903,9673]
[2008,140247,10264]
[2009,168102,9834]
[2010,195535,9146]
[2011,186666,8669]
[2012,189000,8403]
[2013,183989,7989]
[2014,171427,7995]
[2015,172237,8130]
[2016,153704,7826]
[2017,126684,7250]
[2018,125702,7141]
["Mean",{"$f":"AVERAGE(B2:B22)","v":{"v":150470.38095238095,"d":"150470"}},{"$f":"AVERAGE(C2:C22)","v":{"v":10443.57142857143,"d":"10444"}}]
[]
["As calculated in early 2019"]