{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sample Portfolio and Netting","Tiers","Intra Charge","Sample Portfolio and Netting_tm","Risk Arrays and Scan Risk","Risk Arrays and Scan Risk_tmp","Risk Arrays Options","Spreads","Intracommodity Credits"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sample Portfolio and Netting","index":0,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Product","Combined Commodity","Period Code","Tier","Call/Put","Strike Price","Contract Volume","Net Position","Scanning Range","Single Margin Parameter (SMP) Tier","Composite Delta","Original Delta","Original Delta (Gross) Scaled","Original Delta (Net) Scaled"]
[null,"P5TC","P5TC",202305,"Tier 2",null,null,1,-50,{"$f":"Tiers!G6","v":4220.5941585656583},{"$f":"+J3/H3","v":4220.5941585656583},1,{"$f":"H3*ABS(I3)*L3","v":50},{"$f":"(H3*ABS(I3)*L3)/100","v":0.5},{"$f":"(H3*I3*L3)/100","v":-0.5}]
[null,"P5TC","P5TC",202307,"Tier 3",null,null,1,100,{"$f":"+Tiers!G8","v":1527.9534659249662},{"$f":"J4/H4","v":1527.9534659249662},1,{"$f":"H4*ABS(I4)*L4","v":100},{"$f":"(H4*ABS(I4)*L4)/100","v":1},{"$f":"(H4*I4*L4)/100","v":1}]
[null,"P5TC","P5TC",202310,"Tier 3",null,null,1,-75,{"$f":"+Tiers!G11","v":1527.9534659249662},{"$f":"J5/H5","v":1527.9534659249662},1,{"$f":"H5*ABS(I5)*L5","v":75},{"$f":"(H5*ABS(I5)*L5)/100","v":0.75},{"$f":"(H5*I5*L5)/100","v":-0.75}]

{"sheet":"Tiers","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,7,6,7],[7,7,24,7],[1,1,1,3],[4,1,6,1],[4,2,6,2],[4,3,6,3],[7,1,24,1],[7,2,24,2],[7,3,24,3]]}
[]
[null,"Combined Commodity P5TC"]
[null,"Tier","Start Period","End Period","Period Code","SMP","SMP [TIER]","IntraCharge"]
[null,1,202303,202303,202303,5071.41,5071.41,0]
[null,2,202304,202306,202304,5071.4122424097268,{"$f":"+SUM($F$5:$F$7)/3","v":4220.5941585656583},{"$f":"+SUMIF('Intra Charge'!D:D,IFERROR(VLOOKUP(E5,'Intra Charge'!B:D,3,FALSE),VLOOKUP(E5,'Intra Charge'!C:D,2,FALSE)),'Intra Charge'!N:N)","v":3368.4436950234608}]
[null,null,null,null,202305,4075.2005747814633,{"$f":"+SUM($F$5:$F$7)/3","v":4220.5941585656583}]
[null,null,null,null,202306,3515.1696585057862,4220.5941585656583]
[null,3,202307,202412,202307,2827.9356854377802,{"$f":"+SUM($F$8:$F$25)/18","v":1527.9534659249662},{"$f":"+SUMIF('Intra Charge'!D:D,IFERROR(VLOOKUP(E8,'Intra Charge'!B:D,3,FALSE),VLOOKUP(E8,'Intra Charge'!C:D,2,FALSE)),'Intra Charge'!N:N)","v":1263.2403712460732}]
[null,null,null,null,202308,2407.3872481248841,{"$f":"+SUM($F$8:$F$25)/18","v":1527.9534659249662}]
[null,null,null,null,202309,2556.3296720044414,1527.9534659249662]
[null,null,null,null,202310,2191.13660857165,1527.9534659249662]
[null,null,null,null,202311,1975.811280086217,1527.9534659249662]
[null,null,null,null,202312,1827.6199910734695,1527.9534659249662]
[null,null,null,null,202401,1424.4238577851318,1527.9534659249662]
[null,null,null,null,202402,1290.7545095307039,1527.9534659249662]
[null,null,null,null,202403,1203.6010929556614,1527.9534659249662]
[null,null,null,null,202404,1255.6797770544626,1527.9534659249662]
[null,null,null,null,202405,1180.8275546749981,1527.9534659249662]
[null,null,null,null,202406,1097.6475326852526,1527.9534659249662]
[null,null,null,null,202407,982.59326591262879,1527.9534659249662]
[null,null,null,null,202408,968.25638736787107,1527.9534659249662]
[null,null,null,null,202409,930.52546782638979,1527.9534659249662]
[null,null,null,null,202410,891.32493658897681,1527.9534659249662]
[null,null,null,null,202411,1153.0899946658537,1527.9534659249662]
[null,null,null,null,202412,1338.2175243030229,1527.9534659249662]

{"sheet":"Intra Charge","index":2,"n_rows":157,"n_cols":14,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["Product","PeriodA","PeriodB","TierA","TierB","SMPB","SMPA","Credit","SMP_Tier","NumberTier","Gross Margin","Net Margin","NM/GM","IntraCharge"]
["P5TC",202304,202305,2,2,4075.2005747814633,5071.4122424097268,0.6,{"$f":"+VLOOKUP(B2,Tiers!E:G,3,FALSE)","v":4220.5941585656583},{"$f":"+COUNTIF(D:D,D2)","v":3},{"$f":"+G2+F2","v":9146.6128171911896},{"$f":"+K2-2*H2*MIN(F2,G2)","v":4256.3721274534337},{"$f":"+L2/K2","v":0.46534954660522215},{"$f":"2*I2*M2/J2","v":1309.3677187287856}]
["P5TC",202304,202306,2,2,3515.1696585057862,5071.4122424097268,0.61,{"$f":"+VLOOKUP(B3,Tiers!E:G,3,FALSE)","v":4220.5941585656583},3,8586.581900915513,4298.0749175384535,{"$f":"+L3/K3","v":0.50055714452338562},{"$f":"2*I3*M3/J3","v":1408.4323734691382}]
["P5TC",202305,202306,2,2,3515.1696585057862,4075.2005747814633,0.83,{"$f":"+VLOOKUP(B4,Tiers!E:G,3,FALSE)","v":4220.5941585656583},3,7590.370233287249,1755.1886001676439,0.23123886532837862,650.64360282553719]
["P5TC",202307,202308,3,3,2407.3872481248841,2827.9356854377806,0.77,{"$f":"+VLOOKUP(B5,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,5235.3229335626647,1527.9465714503431,0.29185335667738216,5.8292594493730912]
["P5TC",202307,202309,3,3,2556.3296720044414,2827.9356854377806,0.75,{"$f":"+VLOOKUP(B6,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,5384.265357442222,1549.7708494355602,0.28783329694058279,5.7489657995944237]
["P5TC",202307,202310,3,3,2191.1366085716463,2827.9356854377806,0.75,{"$f":"+VLOOKUP(B7,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,5019.0722940094274,1732.3673811519579,0.34515688949522511,6.8939041253870554]
["P5TC",202307,202311,3,3,1975.811280086217,2827.9356854377806,0.77,{"$f":"+VLOOKUP(B8,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4803.7469655239975,1760.997594191223,0.36658833340509467,7.3219596678950509]
["P5TC",202307,202312,3,3,1827.6199910734695,2827.9356854377806,0.78,{"$f":"+VLOOKUP(B9,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4655.5556765112506,1804.4684904366381,0.38759465374686675,7.7415241119805511]
["P5TC",202307,202401,3,3,1424.4238577851318,2827.9356854377806,0.76,{"$f":"+VLOOKUP(B10,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4252.3595432229122,2087.235279389512,0.49084167464531292,9.8037024574473257]
["P5TC",202307,202402,3,3,1290.7545095307039,2827.9356854377806,0.75,{"$f":"+VLOOKUP(B11,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4118.6901949684843,2182.5584306724286,0.52991565943432883,10.584136842883618]
["P5TC",202307,202403,3,3,1203.6010929556614,2827.9356854377806,0.73,{"$f":"+VLOOKUP(B12,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4031.5367783934421,2274.2791826781768,0.56412214688624807,11.267351497253276]
["P5TC",202307,202404,3,3,1255.6797770544626,2827.9356854377806,0.73,{"$f":"+VLOOKUP(B13,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4083.6154624922433,2250.3229879927276,0.55106143285571463,11.006486617901533]
["P5TC",202307,202405,3,3,1180.8275546749981,2827.9356854377806,0.71,{"$f":"+VLOOKUP(B14,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4008.7632401127785,2331.9881124742815,0.5817225844469367,11.618889400163736]
["P5TC",202307,202406,3,3,1097.6475326852526,2827.9356854377806,0.71,{"$f":"+VLOOKUP(B15,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3925.5832181230335,2366.9237217099749,0.60294829842931941,12.042835847825351]
["P5TC",202307,202407,3,3,982.59326591262879,2827.9356854377806,0.71,{"$f":"+VLOOKUP(B16,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3810.5289513504094,2415.2465137544768,0.63383497267447353,12.65974304996625]
["P5TC",202307,202408,3,3,968.25638736787107,2827.9356854377806,0.69,{"$f":"+VLOOKUP(B17,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3796.1920728056516,2459.9982582379898,0.64801733185746813,12.943010826027026]
["P5TC",202307,202409,3,3,930.52546782638979,2827.9356854377806,0.66,{"$f":"+VLOOKUP(B18,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3758.4611532641702,2530.1675357333356,0.67319241374516292,13.445838977991054]
["P5TC",202307,202410,3,3,891.32493658897681,2827.9356854377806,0.57999999999999996,{"$f":"+VLOOKUP(B19,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3719.2606220267576,2685.3236955835446,0.7220047123560317,14.420779119719697]
["P5TC",202307,202411,3,3,1153.0899946658537,2827.9356854377806,0.57999999999999996,{"$f":"+VLOOKUP(B20,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3981.0256801036344,2643.4412862912441,0.66401010661715443,13.262438481240357]
["P5TC",202307,202412,3,3,1338.2175243030229,2827.9356854377806,0.59,{"$f":"+VLOOKUP(B21,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4166.1532097408035,2587.0565310632364,0.62097008938953302,12.402789546646705]
["P5TC",202308,202309,3,3,2556.3296720044414,2407.3872481248841,0.7,{"$f":"+VLOOKUP(B22,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4963.7169201293254,1593.3747727544878,0.32100435991683701,6.4114996642085798]
["P5TC",202308,202310,3,3,2191.1366085716463,2407.3872481248841,0.69,{"$f":"+VLOOKUP(B23,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4598.5238566965309,1574.755336867659,0.3424480085222229,6.8397989741259186]
["P5TC",202308,202311,3,3,1975.811280086217,2407.3872481248841,0.74,{"$f":"+VLOOKUP(B24,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4383.1985282111009,1458.9978336834997,0.33286145363781988,6.6483243367154161]
["P5TC",202308,202312,3,3,1827.6199910734695,2407.3872481248841,0.75,{"$f":"+VLOOKUP(B25,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4235.007239198354,1493.5772525881498,0.35267407308396231,7.0440466968694784]
["P5TC",202308,202401,3,3,1424.4238577851318,2407.3872481248841,0.73,{"$f":"+VLOOKUP(B26,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3831.8111059100156,1752.1522735437234,0.45726478292243616,9.1330628746635778]
["P5TC",202308,202402,3,3,1290.7545095307039,2407.3872481248841,0.73,{"$f":"+VLOOKUP(B27,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3698.1417576555878,1813.64017374076,0.49041932207880129,9.7952667049264939]
["P5TC",202308,202403,3,3,1203.6010929556614,2407.3872481248841,0.71,{"$f":"+VLOOKUP(B28,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3610.9883410805455,1901.8747890835064,0.52669092487692515,10.519728420090507]
["P5TC",202308,202404,3,3,1255.6797770544626,2407.3872481248841,0.71,{"$f":"+VLOOKUP(B29,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3663.0670251793467,1880.0017417620099,0.51323159768553883,10.250901941252639]
["P5TC",202308,202405,3,3,1180.8275546749981,2407.3872481248841,0.71,{"$f":"+VLOOKUP(B30,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3588.2148027998819,1911.4396751613847,0.5326993449973757,10.639736084767314]
["P5TC",202308,202406,3,3,1097.6475326852526,2407.3872481248841,0.71,{"$f":"+VLOOKUP(B31,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3505.0347808101369,1946.3752843970783,0.5553084080801054,11.091312506970883]
["P5TC",202308,202407,3,3,982.59326591262879,2407.3872481248841,0.7,{"$f":"+VLOOKUP(B32,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3389.9805140375129,2014.3499417598327,0.59420693818700288,11.868242492542395]
["P5TC",202308,202408,3,3,968.25638736787107,2407.3872481248841,0.68,{"$f":"+VLOOKUP(B33,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3375.643635492755,2058.8149486724506,0.60990293140701091,12.18174245648548]
["P5TC",202308,202409,3,3,930.52546782638979,2407.3872481248841,0.67,{"$f":"+VLOOKUP(B34,Tiers!E:G,3,FALSE)","v":1527.9534659249662},{"$f":"+COUNTIF(D:D,D34)","v":153},{"$f":"+G34+F34","v":3337.9127159512736},{"$f":"+K34-2*H34*MIN(F34,G34)","v":2091.0085890639111},0.62644196149029419,12.512080604704956]
["P5TC",202308,202410,3,3,891.32493658897681,2407.3872481248841,0.57999999999999996,{"$f":"+VLOOKUP(B35,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3298.712184713861,2264.775258270648,0.68656346217943853,13.712902243327026]
["P5TC",202308,202411,3,3,1153.0899946658537,2407.3872481248841,0.57999999999999996,{"$f":"+VLOOKUP(B36,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3560.4772427907378,2222.8928489783475,0.624324408611027,12.469786196062399]
["P5TC",202308,202412,3,3,1338.2175243030229,2407.3872481248841,0.57999999999999996,{"$f":"+VLOOKUP(B37,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3745.6047724279069,2193.2724442364006,0.58555896243551553,11.695514328846707]
["P5TC",202309,202310,3,3,2191.1366085716463,2556.3296720044414,0.83,{"$f":"+VLOOKUP(B38,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4747.4662805760872,1110.1795103471545,0.23384673944697051,4.6706789023954389]
["P5TC",202309,202311,3,3,1975.811280086217,2556.3296720044414,0.79,{"$f":"+VLOOKUP(B39,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4532.1409520906582,1410.3591295544352,0.31119048248131875,6.2154846571267113]
["P5TC",202309,202312,3,3,1827.6199910734695,2556.3296720044414,0.79,{"$f":"+VLOOKUP(B40,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4383.9496630779104,1496.3100771818285,0.34131552416851657,6.8171795833631563]
["P5TC",202309,202401,3,3,1424.4238577851318,2556.3296720044414,0.75,{"$f":"+VLOOKUP(B41,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3980.7535297895729,1844.1177431118754,0.46325845830735407,9.2527760390820664]
["P5TC",202309,202402,3,3,1290.7545095307039,2556.3296720044414,0.72,{"$f":"+VLOOKUP(B42,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3847.084181535145,1988.3976878109315,0.51685837740558072,10.323340511754395]
["P5TC",202309,202403,3,3,1203.6010929556614,2556.3296720044414,0.72,{"$f":"+VLOOKUP(B43,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3759.9307649601028,2026.7451911039504,0.53903790197196799,10.766337654679615]
["P5TC",202309,202404,3,3,1255.6797770544626,2556.3296720044414,0.72,{"$f":"+VLOOKUP(B44,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3812.009449058904,2003.8305701004779,0.52566254015849223,10.499188237151502]
["P5TC",202309,202405,3,3,1180.8275546749981,2556.3296720044414,0.71,{"$f":"+VLOOKUP(B45,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3737.1572266794392,2060.3820990409422,0.55132336534624338,11.011718260473319]
["P5TC",202309,202406,3,3,1097.6475326852526,2556.3296720044414,0.71,{"$f":"+VLOOKUP(B46,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3653.9772046896942,2095.3177082766356,0.57343480566529037,11.453355539846926]
["P5TC",202309,202407,3,3,982.59326591262879,2556.3296720044414,0.7,{"$f":"+VLOOKUP(B47,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3538.9229379170702,2163.29236563939,0.61128552488703103,12.209357338835311]
["P5TC",202309,202408,3,3,968.25638736787107,2556.3296720044414,0.69,{"$f":"+VLOOKUP(B48,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3524.5860593723123,2188.3922448046505,0.62089340647122049,12.401257939707977]
["P5TC",202309,202409,3,3,930.52546782638979,2556.3296720044414,0.68,{"$f":"+VLOOKUP(B49,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3486.8551398308309,2221.3405035869409,0.63706131012219569,12.724183487685082]
["P5TC",202309,202410,3,3,891.32493658897681,2556.3296720044414,0.62,{"$f":"+VLOOKUP(B50,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3447.6546085934183,2342.411687223087,0.6794217963088679,13.570259980328117]
["P5TC",202309,202411,3,3,1153.0899946658537,2556.3296720044414,0.61,{"$f":"+VLOOKUP(B51,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3709.4196666702951,2302.6498731779539,0.62075744458563598,12.398542339259446]
["P5TC",202309,202412,3,3,1338.2175243030229,2556.3296720044414,0.61,{"$f":"+VLOOKUP(B52,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3894.5471963074642,2261.9218166577766,0.58079199009383475,11.600302408435732]
["P5TC",202310,202311,3,3,1975.811280086217,2191.1366085716463,0.85,{"$f":"+VLOOKUP(B53,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4166.9478886578636,808.06871251129451,0.19392340247661849,3.8732801952694298]
["P5TC",202310,202312,3,3,1827.6199910734695,2191.1366085716463,0.83,{"$f":"+VLOOKUP(B54,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,4018.7565996451158,984.90741446315678,0.24507764778541974,4.8949966190126828]
["P5TC",202310,202401,3,3,1424.4238577851318,2191.1366085716463,0.82,{"$f":"+VLOOKUP(B55,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3615.5604663567783,1279.5053395891623,0.35388851921994174,7.0683031306295945]
["P5TC",202310,202402,3,3,1290.7545095307039,2191.1366085716463,0.78,{"$f":"+VLOOKUP(B56,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3481.8911181023504,1468.3140832344523,0.42170017195560422,8.4227220826237872]
["P5TC",202310,202403,3,3,1203.6010929556614,2191.1366085716463,0.77,{"$f":"+VLOOKUP(B57,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3394.7377015273078,1541.192018375589,0.45399443311399279,9.0677433671524899]
["P5TC",202310,202404,3,3,1255.6797770544626,2191.1366085716463,0.76,{"$f":"+VLOOKUP(B58,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3446.816385626109,1538.1831245033256,0.44626198567404018,8.913301277401402]
["P5TC",202310,202405,3,3,1180.8275546749981,2191.1366085716463,0.74,{"$f":"+VLOOKUP(B59,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3371.9641632466446,1624.3393823276474,0.48171905266148407,9.6214940668785083]
["P5TC",202310,202406,3,3,1097.6475326852526,2191.1366085716463,0.74,{"$f":"+VLOOKUP(B60,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3288.7841412568987,1664.2657928827248,0.50604287827983752,10.107319866331027]
["P5TC",202310,202407,3,3,982.59326591262879,2191.1366085716463,0.74,{"$f":"+VLOOKUP(B61,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3173.7298744842751,1719.4918409335846,0.54178897037133589,10.821285425866686]
["P5TC",202310,202408,3,3,968.25638736787107,2191.1366085716463,0.71,{"$f":"+VLOOKUP(B62,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3159.3929959395173,1784.4689258771405,0.56481385132225004,11.281167081441312]
["P5TC",202310,202409,3,3,930.52546782638979,2191.1366085716463,0.69,{"$f":"+VLOOKUP(B63,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3121.6620763980363,1837.5369307976184,0.58864056577125745,11.757063956264389]
["P5TC",202310,202410,3,3,891.32493658897681,2191.1366085716463,0.62,{"$f":"+VLOOKUP(B64,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3082.4615451606232,1977.218623790292,0.64144145671321318,12.81166924147599]
["P5TC",202310,202411,3,3,1153.0899946658537,2191.1366085716463,0.62,{"$f":"+VLOOKUP(B65,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3344.2266032375001,1914.3950098518415,0.57244775458652886,11.433640923940539]
["P5TC",202310,202412,3,3,1338.2175243030229,2191.1366085716463,0.63,{"$f":"+VLOOKUP(B66,Tiers!E:G,3,FALSE)","v":1527.9534659249662},{"$f":"+COUNTIF(D:D,D66)","v":153},{"$f":"+G66+F66","v":3529.3541328746692},{"$f":"+K66-2*H66*MIN(F66,G66)","v":1843.2000522528604},0.52224854261127052,10.430999617740564]
["P5TC",202311,202312,3,3,1827.6199910734695,1975.811280086217,0.9,{"$f":"+VLOOKUP(B67,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3803.4312711596867,513.71528722744142,{"$f":"+L67/K67","v":0.13506627321566056},{"$f":"2*I67*M67/J67","v":2.6977121606462351}]
["P5TC",202311,202401,3,3,1424.4238577851318,1975.811280086217,0.86,{"$f":"+VLOOKUP(B68,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3400.2351378713488,950.22610248092224,0.2794589385591118,5.5817026634654514]
["P5TC",202311,202402,3,3,1290.7545095307039,1975.811280086217,0.83,{"$f":"+VLOOKUP(B69,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3266.5657896169209,1123.9133037959527,0.3440657179991336,6.8721098865717405]
["P5TC",202311,202403,3,3,1203.6010929556614,1975.811280086217,0.81,{"$f":"+VLOOKUP(B70,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3179.4123730418787,1229.5786024537069,0.3867314013366932,7.7242821575741099]
["P5TC",202311,202404,3,3,1255.6797770544626,1975.811280086217,0.8,{"$f":"+VLOOKUP(B71,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3231.4910571406799,1222.4034138535396,0.37827844553441492,7.5554491756734352]
["P5TC",202311,202405,3,3,1180.8275546749981,1975.811280086217,0.78,{"$f":"+VLOOKUP(B72,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3156.6388347612151,1314.5478494682181,0.41643910446525872,8.3176414773121721]
["P5TC",202311,202406,3,3,1097.6475326852526,1975.811280086217,0.77,{"$f":"+VLOOKUP(B73,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3073.4588127714696,1383.0816124361806,0.45000818188580072,8.9881249830980625]
["P5TC",202311,202407,3,3,982.59326591262879,1975.811280086217,0.77,{"$f":"+VLOOKUP(B74,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2958.4045459988456,1445.2109164933972,0.4885102405781529,9.7571361468134352]
["P5TC",202311,202408,3,3,968.25638736787107,1975.811280086217,0.75,{"$f":"+VLOOKUP(B75,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2944.0676674540882,1491.6830864022816,0.5066741851393074,10.119929114749187]
["P5TC",202311,202409,3,3,930.52546782638979,1975.811280086217,0.72,{"$f":"+VLOOKUP(B76,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2906.3367479126068,1566.3800742426056,0.53895340082927867,10.76464989240711]
["P5TC",202311,202410,3,3,891.32493658897681,1975.811280086217,0.65,{"$f":"+VLOOKUP(B77,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2867.1362166751937,1708.4137991095238,0.59586070210875619,11.901273529353698]
["P5TC",202311,202411,3,3,1153.0899946658537,1975.811280086217,0.63,{"$f":"+VLOOKUP(B78,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3128.901274752071,1676.0078814730953,0.53565380761523052,10.698746299105837]
["P5TC",202311,202412,3,3,1338.2175243030229,1975.811280086217,0.65,{"$f":"+VLOOKUP(B79,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3314.0288043892397,1574.3460227953099,0.47505502085865381,9.4883917075298978]
["P5TC",202312,202401,3,3,1424.4238577851318,1827.6199910734695,0.9,{"$f":"+VLOOKUP(B80,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3252.0438488586015,688.08090484536433,0.21158414118151148,4.2260225078829787]
["P5TC",202312,202402,3,3,1290.7545095307039,1827.6199910734695,0.85,{"$f":"+VLOOKUP(B81,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3118.3745006041736,924.09183440197694,0.29633767022624691,5.9188257556382169]
["P5TC",202312,202403,3,3,1203.6010929556614,1827.6199910734695,0.83,{"$f":"+VLOOKUP(B82,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3031.2210840291309,1033.243269722733,0.34086701071283626,6.8082213129171327]
["P5TC",202312,202404,3,3,1255.6797770544626,1827.6199910734695,0.81,{"$f":"+VLOOKUP(B83,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3083.2997681279321,1049.0985292997025,0.34025187565096116,6.7959350678216559]
["P5TC",202312,202405,3,3,1180.8275546749981,1827.6199910734695,0.79,{"$f":"+VLOOKUP(B84,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3008.4475457484677,1142.7400093619708,0.37984375395771441,7.5867134688841809]
["P5TC",202312,202406,3,3,1097.6475326852526,1827.6199910734695,0.78,{"$f":"+VLOOKUP(B85,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2925.2675237587218,1212.9373727697277,0.41464152010658006,8.2817378792581113]
["P5TC",202312,202407,3,3,982.59326591262879,1827.6199910734695,0.77,{"$f":"+VLOOKUP(B86,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2810.2132569860983,1297.0196274806499,0.46153779406466805,9.2184087855748071]
["P5TC",202312,202408,3,3,968.25638736787107,1827.6199910734695,0.75,{"$f":"+VLOOKUP(B87,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2795.8763784413404,1343.4917973895338,0.48052618053825058,9.5976685362236083]
["P5TC",202312,202409,3,3,930.52546782638979,1827.6199910734695,0.73,{"$f":"+VLOOKUP(B88,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2758.1454588998595,1399.5782758733303,0.5074345413354594,10.135115897562885]
["P5TC",202312,202410,3,3,891.32493658897681,1827.6199910734695,0.66,{"$f":"+VLOOKUP(B89,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2718.9449276624464,1542.3960113649969,0.56727740075671129,11.330372165060432]
["P5TC",202312,202411,3,3,1153.0899946658537,1827.6199910734695,0.64,{"$f":"+VLOOKUP(B90,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2980.7099857393232,1504.7547925670303,0.50483099656332286,10.083114652356651]
["P5TC",202312,202412,3,3,1338.2175243030229,1827.6199910734695,0.65,{"$f":"+VLOOKUP(B91,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,3165.8375153764923,1426.1547337825625,0.45048260589993017,8.9976007715517508]
["P5TC",202401,202402,3,3,1290.7545095307039,1424.4238577851318,0.88,{"$f":"+VLOOKUP(B92,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2715.1783673158357,443.45043054179678,0.16332276209911833,3.2620860184808702]
["P5TC",202401,202403,3,3,1203.6010929556614,1424.4238577851318,0.85,{"$f":"+VLOOKUP(B93,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2628.0249507407934,581.90309271616911,0.22142221007153717,4.4225206968832831]
["P5TC",202401,202404,3,3,1255.6797770544626,1424.4238577851318,0.82,{"$f":"+VLOOKUP(B94,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2680.1036348395946,620.78880047027587,0.23162865510140257,4.6263765538526354]
["P5TC",202401,202405,3,3,1180.8275546749981,1424.4238577851318,0.79,{"$f":"+VLOOKUP(B95,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2605.2514124601298,739.54387607363287,0.28386660593930324,5.6697380968015034]
["P5TC",202401,202406,3,3,1097.6475326852526,1424.4238577851318,0.77,{"$f":"+VLOOKUP(B96,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2522.0713904703844,831.69419013509537,0.32976631560773484,6.5865043774920879]
["P5TC",202401,202407,3,3,982.59326591262879,1424.4238577851318,0.78,{"$f":"+VLOOKUP(B97,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2407.0171236977603,874.17162887405925,0.36317632320418236,7.2538107422446556]
["P5TC",202401,202408,3,3,968.25638736787107,1424.4238577851318,0.74,{"$f":"+VLOOKUP(B98,Tiers!E:G,3,FALSE)","v":1527.9534659249662},{"$f":"+COUNTIF(D:D,D98)","v":153},{"$f":"+G98+F98","v":2392.6802451530029},{"$f":"+K98-2*H98*MIN(F98,G98)","v":959.6607918485538},0.40108192216348032,8.0109086678370893]
["P5TC",202401,202409,3,3,930.52546782638979,1424.4238577851318,0.73,{"$f":"+VLOOKUP(B99,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2354.9493256115215,996.38214258499238,0.42310130912318328,8.4507073426425947]
["P5TC",202401,202410,3,3,891.32493658897681,1424.4238577851318,0.62,{"$f":"+VLOOKUP(B100,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2315.7487943741085,1210.5058730037772,0.52272762742858214,10.440568497571718]
["P5TC",202401,202411,3,3,1153.0899946658537,1424.4238577851318,0.62,{"$f":"+VLOOKUP(B101,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2577.5138524509857,1147.6822590653271,0.44526715461644706,8.8934312700489944]
["P5TC",202401,202412,3,3,1338.2175243030229,1424.4238577851318,0.62,{"$f":"+VLOOKUP(B102,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2762.6413820881544,1103.2516519524061,0.39934667565086157,7.9762501590372192]
["P5TC",202402,202403,3,3,1203.6010929556614,1290.7545095307039,0.89,{"$f":"+VLOOKUP(B103,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2494.3556024863656,351.94565702528826,0.14109682543838978,2.8181618752888573]
["P5TC",202402,202404,3,3,1255.6797770544626,1290.7545095307039,0.85,{"$f":"+VLOOKUP(B104,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2546.4342865851668,411.77866559258018,0.16170794893937196,3.2298329548958278]
["P5TC",202402,202405,3,3,1180.8275546749981,1290.7545095307039,0.82,{"$f":"+VLOOKUP(B105,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2471.582064205702,535.02487453870526,0.21647060896221848,4.323621140323004]
["P5TC",202402,202406,3,3,1097.6475326852526,1290.7545095307039,0.79,{"$f":"+VLOOKUP(B106,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2388.4020422159565,654.11894057325731,0.27387304524591954,5.4701342314631098]
["P5TC",202402,202407,3,3,982.59326591262879,1290.7545095307039,0.8,{"$f":"+VLOOKUP(B107,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2273.3477754433325,701.19854998312621,0.30844315047502285,6.1606115138447981]
["P5TC",202402,202408,3,3,968.25638736787107,1290.7545095307039,0.78,{"$f":"+VLOOKUP(B108,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2259.0108968985751,748.53093260469609,0.331353396140038,6.6182035304337177]
["P5TC",202402,202409,3,3,930.52546782638979,1290.7545095307039,0.75,{"$f":"+VLOOKUP(B109,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2221.2799773570937,825.49177561750912,0.37162887345686579,7.4226356240027291]
["P5TC",202402,202410,3,3,891.32493658897681,1290.7545095307039,0.64,{"$f":"+VLOOKUP(B110,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2182.0794461196806,1041.1835272857902,0.4771519795657726,9.5302747836664157]
["P5TC",202402,202411,3,3,1153.0899946658537,1290.7545095307039,0.62,{"$f":"+VLOOKUP(B111,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2443.8445041965579,1014.0129108108993,0.41492529867167949,8.2874058588933917]
["P5TC",202402,202412,3,3,1338.2175243030229,1290.7545095307039,0.62,{"$f":"+VLOOKUP(B112,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2628.9720338337265,1028.4364420156537,0.39119337474120075,7.8134022585974092]
["P5TC",202403,202404,3,3,1255.6797770544626,1203.6010929556614,0.89,{"$f":"+VLOOKUP(B113,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2459.2808700101241,316.87092454904678,0.12884698466659578,2.5734927685660915]
["P5TC",202403,202405,3,3,1180.8275546749981,1203.6010929556614,0.84,{"$f":"+VLOOKUP(B114,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2384.4286476306597,400.63835577666305,0.1680227907741195,3.3559608564405399]
["P5TC",202403,202406,3,3,1097.6475326852526,1203.6010929556614,0.81,{"$f":"+VLOOKUP(B115,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2301.2486256409138,523.05962269080442,0.22729383381820756,4.5397960936719413]
["P5TC",202403,202407,3,3,982.59326591262879,1203.6010929556614,0.8,{"$f":"+VLOOKUP(B116,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2186.1943588682902,614.04513340808398,0.28087399041956718,5.6099658450948153]
["P5TC",202403,202408,3,3,968.25638736787107,1203.6010929556614,0.79,{"$f":"+VLOOKUP(B117,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2171.8574803235324,642.01238828229611,0.29560521079249558,5.9041961617761283]
["P5TC",202403,202409,3,3,930.52546782638979,1203.6010929556614,0.77,{"$f":"+VLOOKUP(B118,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2134.1265607820515,701.11734032941126,0.3285265987563955,6.5617432054689573]
["P5TC",202403,202410,3,3,891.32493658897681,1203.6010929556614,0.67,{"$f":"+VLOOKUP(B119,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2094.9260295446384,900.55061451540928,0.42987227320439403,8.5859454868980105]
["P5TC",202403,202411,3,3,1153.0899946658537,1203.6010929556614,0.65,{"$f":"+VLOOKUP(B120,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2356.6910876215152,857.67409455590519,0.36393148811943388,7.2688938383179034]
["P5TC",202403,202412,3,3,1338.2175243030229,1203.6010929556614,0.65,{"$f":"+VLOOKUP(B121,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2541.8186172586843,977.13719641632429,0.38442443917188435,7.6782046303129672]
["P5TC",202404,202405,3,3,1180.8275546749981,1255.6797770544626,0.88,{"$f":"+VLOOKUP(B122,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2436.5073317294609,358.25083550146428,0.14703458136002148,2.9367581464035459]
["P5TC",202404,202406,3,3,1097.6475326852526,1255.6797770544626,0.84,{"$f":"+VLOOKUP(B123,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2353.327309739715,509.27945482849077,0.21640825427076635,4.3223757146116188]
["P5TC",202404,202407,3,3,982.59326591262879,1255.6797770544626,0.82,{"$f":"+VLOOKUP(B124,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2238.2730429670914,626.82008687038024,0.28004630124993923,5.5934342041086511]
["P5TC",202404,202408,3,3,968.25638736787107,1255.6797770544626,0.79,{"$f":"+VLOOKUP(B125,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2223.9361644223336,694.09107238109732,0.31210026775268845,6.2336560239062777]
["P5TC",202404,202409,3,3,930.52546782638979,1255.6797770544626,0.77,{"$f":"+VLOOKUP(B126,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2186.2052448808527,753.19602442821247,0.3445221011119024,6.8812253396298422]
["P5TC",202404,202410,3,3,891.32493658897681,1255.6797770544626,0.65,{"$f":"+VLOOKUP(B127,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2147.0047136434396,988.28229607776962,0.4603074645330737,9.1938351088162538]
["P5TC",202404,202411,3,3,1153.0899946658537,1255.6797770544626,0.64,{"$f":"+VLOOKUP(B128,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2408.7697717203164,932.81457854802352,0.38725767381322534,7.7347935282216689]
["P5TC",202404,202412,3,3,1338.2175243030229,1255.6797770544626,0.64,{"$f":"+VLOOKUP(B129,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2593.8973013574855,986.62718672777328,0.38036478399180784,7.5971201309292011]
["P5TC",202405,202406,3,3,1097.6475326852526,1180.8275546749981,0.88,{"$f":"+VLOOKUP(B130,Tiers!E:G,3,FALSE)","v":1527.9534659249662},{"$f":"+COUNTIF(D:D,D130)","v":153},{"$f":"+G130+F130","v":2278.4750873602507},{"$f":"+K130-2*H130*MIN(F130,G130)","v":346.615429834206},0.15212605648270688,3.0384514413104462]
["P5TC",202405,202407,3,3,982.59326591262879,1180.8275546749981,0.85,{"$f":"+VLOOKUP(B131,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2163.4208205876266,493.01226853615776,{"$f":"+L131/K131","v":0.22788551531192447},{"$f":"2*I131*M131/J131","v":4.551613894835973}]
["P5TC",202405,202408,3,3,968.25638736787107,1180.8275546749981,0.81,{"$f":"+VLOOKUP(B132,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2149.0839420428692,580.50859450691792,0.27011908802180151,5.3951555131425186]
["P5TC",202405,202409,3,3,930.52546782638979,1180.8275546749981,0.78,{"$f":"+VLOOKUP(B133,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2111.3530225013878,659.73329269221972,0.3124694381570603,6.2410295559177404]
["P5TC",202405,202410,3,3,891.32493658897681,1180.8275546749981,0.65,{"$f":"+VLOOKUP(B134,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2072.1524912639748,913.4300736983048,0.44081218807459932,8.8044511188307464]
["P5TC",202405,202411,3,3,1153.0899946658537,1180.8275546749981,0.63,{"$f":"+VLOOKUP(B135,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2333.917549340852,881.02415606187628,0.37748726655348053,7.539646761737675]
["P5TC",202405,202412,3,3,1338.2175243030229,1180.8275546749981,0.64,{"$f":"+VLOOKUP(B136,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2519.0450789780207,1007.5858089940232,0.39998720840787882,7.9890436785943821]
["P5TC",202406,202407,3,3,982.59326591262879,1097.6475326852526,0.88,{"$f":"+VLOOKUP(B137,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2080.2407985978816,350.87665059165488,0.16867117058186332,3.3689111070873103]
["P5TC",202406,202408,3,3,968.25638736787107,1097.6475326852526,0.86,{"$f":"+VLOOKUP(B138,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2065.9039200531238,400.50293378038555,0.19386329145940476,3.8720795830198615]
["P5TC",202406,202409,3,3,930.52546782638979,1097.6475326852526,0.81,{"$f":"+VLOOKUP(B139,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2028.1730005116424,520.72174263289094,0.25674424346519242,5.1280164269140407]
["P5TC",202406,202410,3,3,891.32493658897681,1097.6475326852526,0.65,{"$f":"+VLOOKUP(B140,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,1988.9724692742293,830.25005170855934,0.4174266182837188,8.3373653356332813]
["P5TC",202406,202411,3,3,1153.0899946658537,1097.6475326852526,0.64,{"$f":"+VLOOKUP(B141,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2250.7375273511061,845.74868551398276,0.37576513264491784,7.5052501542295014]
["P5TC",202406,202412,3,3,1338.2175243030229,1097.6475326852526,0.63,{"$f":"+VLOOKUP(B142,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2435.8650569882757,1052.8291658048574,0.43221982382988999,8.6328336975471718]
["P5TC",202407,202408,3,3,968.25638736787107,982.59326591262879,0.9,{"$f":"+VLOOKUP(B143,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,1950.8496532804998,207.98815601833189,0.10661413895662551,2.1294306292206784]
["P5TC",202407,202409,3,3,930.52546782638979,982.59326591262879,0.83,{"$f":"+VLOOKUP(B144,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,1913.1187337390186,368.4464571472115,0.19258943558987374,3.8466365439226218]
["P5TC",202407,202410,3,3,891.32493658897681,982.59326591262879,0.67,{"$f":"+VLOOKUP(B145,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,1873.9182025016057,679.54278747237663,0.36263204368537233,7.242939712477364]
["P5TC",202407,202411,3,3,1153.0899946658537,982.59326591262879,0.64,{"$f":"+VLOOKUP(B146,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2135.6832605784825,877.96388021031771,0.41109273852364592,8.2108571848861516]
["P5TC",202407,202412,3,3,1338.2175243030229,982.59326591262879,0.63,{"$f":"+VLOOKUP(B147,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2320.8107902156517,1082.7432751657393,0.46653664302600467,9.3182520351971583]
["P5TC",202408,202409,3,3,930.52546782638979,968.25638736787107,0.88,{"$f":"+VLOOKUP(B148,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,1898.781855194261,261.05703181981494,0.13748658441498887,2.7460536362753944]
["P5TC",202408,202410,3,3,891.32493658897681,968.25638736787107,0.69,{"$f":"+VLOOKUP(B149,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,1859.5813239568479,629.55291146405989,0.33854551202121497,6.7618534440020621]
["P5TC",202408,202411,3,3,1153.0899946658537,968.25638736787107,0.61,{"$f":"+VLOOKUP(B150,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2121.3463820337247,940.07358944492194,0.44314950043362455,8.8511348380454109]
["P5TC",202408,202412,3,3,1338.2175243030229,968.25638736787107,0.62,{"$f":"+VLOOKUP(B151,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2306.4739116708938,1105.8359913347338,0.47944873156342177,9.5761483807275685]
["P5TC",202409,202410,3,3,891.32493658897681,930.52546782638979,0.7,{"$f":"+VLOOKUP(B152,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,1821.8504044153665,573.99549319079892,0.31506181396655047,6.2928077206640225]
["P5TC",202409,202411,3,3,1153.0899946658537,930.52546782638979,0.62,{"$f":"+VLOOKUP(B153,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2083.6154624922438,929.76388238752043,0.44622623469851574,8.9125872143038496]
["P5TC",202409,202412,3,3,1338.2175243030229,930.52546782638979,0.61,{"$f":"+VLOOKUP(B154,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2268.7429921294124,1133.5019213812168,0.499616715209036,9.9789685181397818]
["P5TC",202410,202411,3,3,1153.0899946658537,891.32493658897681,0.74,{"$f":"+VLOOKUP(B155,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2044.4149312548307,725.25402510314507,0.35474893771099353,7.0854884824668298]
["P5TC",202410,202412,3,3,1338.2175243030229,891.32493658897681,0.71,{"$f":"+VLOOKUP(B156,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2229.5424608919998,963.86105093565288,0.4323133861958518,8.6347024418785647]
["P5TC",202411,202412,3,3,1338.2175243030229,1153.0899946658537,0.77,{"$f":"+VLOOKUP(B157,Tiers!E:G,3,FALSE)","v":1527.9534659249662},153,2491.3075189688766,715.54892718346173,0.28721822646752948,5.7366808445474975]

{"sheet":"Sample Portfolio and Netting_tm","index":3,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,14,5,14],[2,15,5,15]]}
[]
[null,"Product","Combined Commodity","Period Code","Call/Put","Strike Price","Contract Volume","Net Position","Tier","Single Margin Parameter (SMP)","Scanning Range","Scanning Range Tier","Composite Delta","Original Delta","Original Delta (Gross) Scaled","Original Delta (Net) Scaled"]
[null,"OP5M","P5TC",202304,"P",10000,1,1,2,5071.4122424097268,{"$f":"+J3*G3","v":5071.4122424097268},4220.59,-1.771E-3,{"$f":"G3*ABS(H3)*M3","v":-1.771E-3},{"$f":"((G3*(H3)*M3)+(G4*(H4)*M4)+(G5*ABS(H5)*M5)+(G6*ABS(H6)*M6))/100","v":9.7673799999999991E-3},{"$f":"((G3*H3*M3)+(G4*H4*M4)+(G5*H5*M5)+(G6*(H6)*M6))/100","v":-1.023262E-2}]
[null,"OP5M","P5TC",202305,"P",10000,1,1,2,4075.2005747814633,{"$f":"+J4*G4","v":4075.2005747814633},4220.59,-7.3889999999999997E-3,{"$f":"G4*ABS(H4)*M4","v":-7.3889999999999997E-3}]
[null,"OP5M","P5TC",202306,"P",10000,1,1,2,3515.1696585057862,3515.1696585057862,4220.59,-1.4102E-2,-1.4102E-2,null,{"$f":"(G5*H5*M5)/100","v":-1.4102E-4}]
[null,"P5TC","P5TC",202305,null,null,1,-1,2,4075.2005747814633,4075.2005747814633,4220.59,1,1,null,{"$f":"(G6*H6*M6)/100","v":-0.01}]
[null,"OP5M","P5TC",202307,"P",10000,1,1,3,2827.9356854377806,2827.9356854377806,1527.95,-1.3018999999999999E-2,-1.3018999999999999E-2,{"$f":"(G7*ABS(H7)*M7)/100","v":-1.3019E-4},-1.3019E-4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Risk Arrays and Scan Risk","index":4,"n_rows":9,"n_cols":30,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,28,8,28],[7,29,8,29],[1,12,1,27],[2,10,2,11],[3,10,3,11],[4,10,4,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Risk Arrays"]
[null,null,null,null,null,null,null,null,null,null,"Price Scan Change",null,0,0,0.33333333333333331,0.33333333333333331,-0.33333333333333331,-0.33333333333333331,0.66666666666666663,0.66666666666666663,-0.66666666666666663,-0.66666666666666663,1,1,-1,-1,3,-3]
[null,null,null,null,null,null,null,null,null,null,"Vola Scan Change",null,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1]
[null,null,null,null,null,null,null,null,null,null,"Weight",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.33,0.33]
[null,"Product","Combined Commodity","Period Code","Call/Put","Strike Price","Contract Volume","Net Position","Tier","Scanning Range","SMP","Composite Delta","Scenario 1","Scenario 2","Scenario3","Scenario 4","Scenario 5","Scenario 6","Scenario 7","Scenario 8","Scenario 9","Scenario 10","Scenario 11","Scenario 12","Scenario 13","Scenario 14","Scenario 15","Scenario 16","Active Scenario","Scan Risk"]
[null,"P5TC","P5TC",202305,null,null,1,{"$f":"+'Sample Portfolio and Netting'!I3","v":-50},2,{"$f":"+Tiers!G6","v":4220.5941585656583},{"$f":"+J7/G7","v":4220.5941585656583},1,{"$f":"-1*$H7*$J7*M$3*M$5","v":0},0,70343.235976094293,70343.235976094293,-70343.235976094293,-70343.235976094293,140686.47195218859,140686.47195218859,-140686.47195218859,-140686.47195218859,211029.70792828291,211029.70792828291,-211029.70792828291,-211029.70792828291,208919.41084900009,-208919.41084900009,{"$f":"MATCH(MAX(M7:AB7),M7:AB7,0)","v":11},{"$f":"MAX(M7:AB7)","v":211029.70792828291}]
[null,{"$f":"+'Sample Portfolio and Netting'!B4","v":"P5TC"},{"$f":"+'Sample Portfolio and Netting'!C4","v":"P5TC"},{"$f":"+'Sample Portfolio and Netting'!D4","v":202307},null,null,{"$f":"+'Sample Portfolio and Netting'!H4","v":1},{"$f":"+'Sample Portfolio and Netting'!I4","v":100},3,{"$f":"Tiers!G8","v":1527.9534659249662},{"$f":"J8/G8","v":1527.9534659249662},1,0,0,-50931.782197498869,-50931.782197498869,50931.782197498869,50931.782197498869,-101863.56439499774,-101863.56439499774,101863.56439499774,101863.56439499774,-152795.34659249661,-152795.34659249661,152795.34659249661,152795.34659249661,-151267.39312657167,151267.39312657167,{"$f":"MATCH(MAX((M8:AB8)+(M9:AB9)),(M8:AB8)+(M9:AB9),0)","v":13},{"$f":"MAX((M8:AB8)+(M9:AB9))","v":38198.836648124154}]
[null,{"$f":"+'Sample Portfolio and Netting'!B5","v":"P5TC"},{"$f":"+'Sample Portfolio and Netting'!C5","v":"P5TC"},{"$f":"+'Sample Portfolio and Netting'!D5","v":202310},null,null,{"$f":"+'Sample Portfolio and Netting'!H5","v":1},{"$f":"+'Sample Portfolio and Netting'!I5","v":-75},3,{"$f":"+Tiers!G11","v":1527.9534659249662},{"$f":"J9/G9","v":1527.9534659249662},1,0,0,38198.836648124154,38198.836648124154,-38198.836648124154,-38198.836648124154,76397.673296248307,76397.673296248307,-76397.673296248307,-76397.673296248307,114596.50994437246,114596.50994437246,-114596.50994437246,-114596.50994437246,113450.54484492874,-113450.54484492874]

{"sheet":"Risk Arrays and Scan Risk_tmp","index":5,"n_rows":18,"n_cols":30,"rows_kept":18,"cut":false,"hidden":true,"merged":[[17,11,17,12],[6,28,9,28],[6,29,9,29],[1,12,1,27],[2,10,2,11],[3,10,3,11],[4,10,4,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Risk Arrays (By default for 1 Long Position)"]
[null,null,null,null,null,null,null,null,null,null,"Price Scan Change",null,0,0,0.33333333333333331,0.33333333333333331,-0.33333333333333331,-0.33333333333333331,0.66666666666666663,0.66666666666666663,-0.66666666666666663,-0.66666666666666663,1,1,-1,-1,3,-3]
[null,null,null,null,null,null,null,null,null,null,"Vola Scan Change",null,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1]
[null,null,null,null,null,null,null,null,null,null,"Weight",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.33,0.33]
[null,"Product","Combined Commodity","Period Code","Call/Put","Strike Price","Contract Value Factor","Net Position","Scanning Range [Tier]","Tier","SMP","Composite Delta","Scenario 1","Scenario 2","Scenario3","Scenario 4","Scenario 5","Scenario 6","Scenario 7","Scenario 8","Scenario 9","Scenario 10","Scenario 11","Scenario 12","Scenario 13","Scenario 14","Scenario 15","Scenario 16","Active Scenario","Scan Risk"]
[null,"P5TC","P5TC",202305,null,null,1,-1,4220.59,2,{"$f":"I7/G7","v":4220.59},1,{"$f":"$K7*$G7*M$3*M$5","v":0},0,1406.8633333333332,1406.8633333333332,-1406.8633333333332,-1406.8633333333332,2813.7266666666665,2813.7266666666665,-2813.7266666666665,-2813.7266666666665,4220.59,4220.59,-4220.59,-4220.59,4178.3841000000002,-4178.3841000000002,{"$f":"-1*MIN((SIGN($H$7)*M7:AB7)+(SIGN($H$9)*M9:AB9)+(SIGN($H$8)*M8:AB8) +(SIGN($H$10)*M10:AB10))","v":4242.09},{"$f":"-1*(H7*AC7)+(H8*AC8)+(H9*AC9)+(H10*AC10)","v":4242.09}]
[null,"OP5M","P5TC",202304,"P",10000,1,1,4220.59,2,{"$f":"I8/G8","v":4220.59},-1.771E-3,{"$f":"+'Risk Arrays Options'!C34","v":29.00622971336437},{"$f":"+'Risk Arrays Options'!D34","v":-0.03},{"$f":"+'Risk Arrays Options'!E34","v":12.64126873867173},{"$f":"+'Risk Arrays Options'!F34","v":-0.03},{"$f":"+'Risk Arrays Options'!G34","v":65.397161971222715},{"$f":"+'Risk Arrays Options'!H34","v":-0.03},{"$f":"+'Risk Arrays Options'!I34","v":5.4429394208987212},{"$f":"+'Risk Arrays Options'!J34","v":-0.03},{"$f":"+'Risk Arrays Options'!K34","v":143.7125345796928},{"$f":"+'Risk Arrays Options'!L34","v":-0.03},{"$f":"+'Risk Arrays Options'!M34","v":2.3212149828506607},{"$f":"+'Risk Arrays Options'!N34","v":-0.03},{"$f":"+'Risk Arrays Options'!O34","v":304.51807479146976},{"$f":"+'Risk Arrays Options'!P34","v":-0.03},{"$f":"+'Risk Arrays Options'!Q34","v":-9.8999999999980944E-3},{"$f":"+'Risk Arrays Options'!R34","v":1940.5670265197721}]
[null,"OP5M","P5TC",202305,"P",10000,1,1,4220.59,2,{"$f":"I9/G9","v":4220.59},-7.3889999999999997E-3,{"$f":"+'Risk Arrays Options'!C44","v":199.28828704647128},{"$f":"+'Risk Arrays Options'!D44","v":-4.83},{"$f":"+'Risk Arrays Options'!E44","v":137.22777749165365},{"$f":"+'Risk Arrays Options'!F44","v":-4.83},{"$f":"+'Risk Arrays Options'!G44","v":289.2637104034896},{"$f":"+'Risk Arrays Options'!H44","v":-4.83},{"$f":"+'Risk Arrays Options'!I44","v":94.383942347162801},{"$f":"+'Risk Arrays Options'!J44","v":-4.83},{"$f":"+'Risk Arrays Options'!K44","v":419.5936302347011},{"$f":"+'Risk Arrays Options'!L44","v":-4.83},{"$f":"+'Risk Arrays Options'!M44","v":64.742938238214919},{"$f":"+'Risk Arrays Options'!N44","v":-4.83},{"$f":"+'Risk Arrays Options'!O44","v":607.7411590622728},{"$f":"+'Risk Arrays Options'!P44","v":-4.83},{"$f":"+'Risk Arrays Options'!Q44","v":-1.5938269051018108},{"$f":"+'Risk Arrays Options'!R44","v":1478.2195281112647}]
[null,"OP5M","P5TC",202306,"P",10000,1,1,4220.59,2,{"$f":"I10/G10","v":4220.59},-1.4102E-2,{"$f":"+'Risk Arrays Options'!C54","v":376.46027940029171},{"$f":"+'Risk Arrays Options'!D54","v":-16.64},{"$f":"+'Risk Arrays Options'!E54","v":285.32964382914815},{"$f":"+'Risk Arrays Options'!F54","v":-16.64},{"$f":"+'Risk Arrays Options'!G54","v":497.13001355918277},{"$f":"+'Risk Arrays Options'!H54","v":-16.64},{"$f":"+'Risk Arrays Options'!I54","v":216.29568717317414},{"$f":"+'Risk Arrays Options'!J54","v":-16.64},{"$f":"+'Risk Arrays Options'!K54","v":657.284943341239},{"$f":"+'Risk Arrays Options'!L54","v":-16.64},{"$f":"+'Risk Arrays Options'!M54","v":163.81395512465076},{"$f":"+'Risk Arrays Options'!N54","v":-16.64},{"$f":"+'Risk Arrays Options'!O54","v":870.10301289460369},{"$f":"+'Risk Arrays Options'!P54","v":-16.64},{"$f":"+'Risk Arrays Options'!Q54","v":-5.4869263384577485},{"$f":"+'Risk Arrays Options'!R54","v":1399.7065607794232}]
[null,"OP5M","P5TC",202307,"P",10000,1,1,1527.95,3,{"$f":"I11/G11","v":1527.95},-1.3018999999999999E-2,{"$f":"+'Risk Arrays Options'!C64","v":532.43353419750326},{"$f":"+'Risk Arrays Options'!D64","v":-26.39},{"$f":"+'Risk Arrays Options'!E64","v":488.89639059501417},{"$f":"+'Risk Arrays Options'!F64","v":-26.39},{"$f":"+'Risk Arrays Options'!G64","v":579.97971126159109},{"$f":"+'Risk Arrays Options'!H64","v":-26.39},{"$f":"+'Risk Arrays Options'!I64","v":449.01152350996023},{"$f":"+'Risk Arrays Options'!J64","v":-26.39},{"$f":"+'Risk Arrays Options'!K64","v":631.92746092092239},{"$f":"+'Risk Arrays Options'!L64","v":-26.39},{"$f":"+'Risk Arrays Options'!M64","v":412.45479992198108},{"$f":"+'Risk Arrays Options'!N64","v":-26.39},{"$f":"+'Risk Arrays Options'!O64","v":688.70849435799653},{"$f":"+'Risk Arrays Options'!P64","v":-26.39},{"$f":"+'Risk Arrays Options'!Q64","v":-7.918999143620514},{"$f":"+'Risk Arrays Options'!R64","v":67.16729413855856},{"$f":"IF(H11<0,MAX(M11:AB11),-1*MIN(M11:AB11))","v":26.39},{"$f":"H11*AC11","v":26.39}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K12*$G12*M$3*M$5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(H12>0,MAX(M12:AB12),MIN(M12:AB12))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(H13>0,MAX(M13:AB13),MIN(M13:AB13))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(H14>0,MAX(M14:AB14),MIN(M14:AB14))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(H15>0,MAX(M15:AB15),MIN(M15:AB15))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(H16>0,MAX(M16:AB16),MIN(M16:AB16))","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"See 'Risk Arrays Options'."]

{"sheet":"Risk Arrays Options","index":6,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":true,"merged":[[1,1,1,5],[19,1,19,2]]}
[]
[null,"Option OP5M Characteristics"]
[null,null,202304,202305,202306,202307]
[null,"Contractvolume",1,1,1,1]
[null,"Underlying Price [S]",16761,18143,18365,18222]
[null,"Strike [K]",10000,10000,10000,10000]
[null,"Interest Rate [r]",4.999E-2,5.0880000000000002E-2,5.042E-2,5.042E-2]
[null,"Vola [Sigma]",0.49023600000000001,0.56535100000000005,0.54777500000000001,0.50017199999999995]
[null,"Time to Maturity [T]",{"$f":"19.177999/250","v":7.6711996000000005E-2},{"$f":"41.780751/250","v":0.16712300400000002},{"$f":"62.328748/250","v":0.24931499199999999},{"$f":"83.561748/250","v":0.33424699199999997}]
[null,"Scan Range",4220.59,4220.59,4220.59,1527.95]
[null,"Volatility Scan Range",0.5,0.5,0.5,0.5]
[null,"Look Ahead Time",3,3,3,3]
[null,"Composite Delta",-1.771E-3,-7.3889999999999997E-3,-1.4102E-2,-1.3018999999999999E-2]
[null,"Current Option Price (Calculation)",{"$f":"bsPut(C5,C6,C8,C7,C9)","v":2.9283904993578472E-2},{"$f":"bsPut(D5,D6,D8,D7,D9)","v":4.8267545981316289},16.652015991396311,26.370785826032087]
[null,"Current Option Price (SPAN)",0.03,4.83,16.64,26.39]
[null,"Current Option Value (Calculation)",{"$f":"C14*C4","v":2.9283904993578472E-2},{"$f":"D14*D4","v":4.8267545981316289},16.652015991396311,26.370785826032087]
[null,"Current Option Value (SPAN)",{"$f":"+C15*C4","v":0.03},{"$f":"+D15*D4","v":4.83},16.64,26.39]
[]
[]
[null,"Option OP5M Risk Array"]
[null,"Scenario",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,"Price Change Scenario",0,0,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},{"$f":"-1/3","v":-0.33333333333333331},{"$f":"-1/3","v":-0.33333333333333331},{"$f":"2/3","v":0.66666666666666663},{"$f":"2/3","v":0.66666666666666663},{"$f":"-2/3","v":-0.66666666666666663},{"$f":"-2/3","v":-0.66666666666666663},1,1,-1,-1,3,-3]
[null,"Volatility Change Scenario ",1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,0,0]
[null,"Weight",1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.33,0.33]
[null,202304]
[null,"Underlying Price",{"$f":"($C$5+(C$22*($C$10/$C$4)))","v":16761},{"$f":"($C$5+(D$22*($C$10/$C$4)))","v":16761},18167.863333333335,18167.863333333335,15354.136666666667,15354.136666666667,19574.726666666666,19574.726666666666,13947.273333333334,13947.273333333334,20981.59,20981.59,12540.41,12540.41,29422.77,4099.2299999999996]
[null,"Strike Price",{"$f":"$C$6","v":10000},10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,"Interest Rate",{"$f":"$C$7","v":4.999E-2},4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2,4.999E-2]
[null,"Volatility Scenario",{"$f":"IF($C$8+(C$23*$C$11)>0,$C$8+(C$23*$C$11),0.001)","v":0.99023600000000001},{"$f":"IF($C$8+(D23*$C$11)>0,$C$8+(D23*$C$11),0.001)","v":1E-3},0.99023600000000001,1E-3,0.99023600000000001,1E-3,0.99023600000000001,1E-3,0.99023600000000001,1E-3,0.99023600000000001,1E-3,0.99023600000000001,1E-3,0.49023600000000001,0.49023600000000001]
[null,"Time",{"$f":"$C$9-(2/250)","v":6.8711995999999997E-2},{"$f":"$C$9-(2/250)","v":6.8711995999999997E-2},6.8711995999999997E-2,{"$f":"$C$9-(2/250)","v":6.8711995999999997E-2},6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2,6.8711995999999997E-2]
[null,"Scenario Option Price",{"$f":"bsPut(C26,C27,C29,C28,C30)","v":29.036229713364371},0,12.67126873867173,0,65.427161971222716,0,5.4729394208987214,0,143.7425345796928,0,2.3512149828506606,0,304.54807479146973,0,5.7723252854933778E-15,5880.5361409690058]
[null,"Scenario Option Value",{"$f":"C31*$C$4","v":29.036229713364371},{"$f":"D31*$C$4","v":0},12.67126873867173,0,65.427161971222716,0,5.4729394208987214,0,143.7425345796928,0,2.3512149828506606,0,304.54807479146973,0,5.7723252854933778E-15,{"$f":"R31*$C$4","v":5880.5361409690058}]
[null,"Current Option Value",{"$f":"$C$17","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"$C$17","v":0.03},0.03,0.03]
[null,"Risk Arrays",{"$f":"C$24*(C32-C33)","v":29.00622971336437},{"$f":"D24*(D32-D33)","v":-0.03},12.64126873867173,-0.03,65.397161971222715,-0.03,5.4429394208987212,-0.03,143.7125345796928,-0.03,2.3212149828506607,-0.03,304.51807479146976,-0.03,-9.8999999999980944E-3,1940.5670265197721]
[null,202305]
[null,"Underlying Price",{"$f":"($D$5+(C$22*($D$10/$D$4)))","v":18143},{"$f":"($D$5+(D$22*($D$10/$D$4)))","v":18143},19549.863333333335,19549.863333333335,16736.136666666665,16736.136666666665,20956.726666666666,20956.726666666666,15329.273333333334,15329.273333333334,22363.59,22363.59,13922.41,13922.41,30804.77,5481.23]
[null,"Strike Price",{"$f":"$D$6","v":10000},{"$f":"$D$6","v":10000},10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,"Interest Rate",{"$f":"$D$7","v":5.0880000000000002E-2},{"$f":"$D$7","v":5.0880000000000002E-2},5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2,5.0880000000000002E-2]
[null,"Volatility Scenario",{"$f":"IF($D$8+(C$23*$D$11)>0,$D$8+(C$23*$D$11),0.001)","v":1.0653510000000002},{"$f":"IF($D$8+(D$23*$D$11)>0,$D$8+(D$23*$D$11),0.001)","v":6.5351000000000048E-2},1.0653510000000002,6.5351000000000048E-2,1.0653510000000002,6.5351000000000048E-2,1.0653510000000002,6.5351000000000048E-2,1.0653510000000002,6.5351000000000048E-2,1.0653510000000002,6.5351000000000048E-2,1.0653510000000002,6.5351000000000048E-2,0.56535100000000005,0.56535100000000005]
[null,"Time",{"$f":"$D$9-(2/250)","v":0.15912300400000001},{"$f":"$D$9-(2/250)","v":0.15912300400000001},0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001,0.15912300400000001]
[null,"Scenario Option Price",{"$f":"bsPut(C36,C37,C39,C38,C40)","v":204.11828704647129},{"$f":"bsPut(D36,D37,D39,D38,D40)","v":1.0797976543125408E-114},142.05777749165367,5.4176275914080435E-145,294.09371040348958,6.1257749605959489E-86,99.213942347162799,2.2336643114731101E-176,424.42363023470108,2.3081637756273906E-59,69.572938238214917,1.6572771524750183E-208,612.57115906227284,7.5826270518604631E-36,2.2149969148278916E-4,4484.2831154886808]
[null,"Scenario Option Value",{"$f":"C41*$D$4","v":204.11828704647129},{"$f":"D41*$D$4","v":1.0797976543125408E-114},142.05777749165367,5.4176275914080435E-145,294.09371040348958,6.1257749605959489E-86,99.213942347162799,2.2336643114731101E-176,424.42363023470108,2.3081637756273906E-59,69.572938238214917,1.6572771524750183E-208,612.57115906227284,7.5826270518604631E-36,2.2149969148278916E-4,4484.2831154886808]
[null,"Current Option Value",{"$f":"$D$17","v":4.83},{"$f":"$D$17","v":4.83},4.83,4.83,4.83,4.83,4.83,4.83,4.83,4.83,4.83,4.83,4.83,4.83,4.83,4.83]
[null,"Risk Arrays",{"$f":"C$24*(C42-C43)","v":199.28828704647128},{"$f":"D$24*(D42-D43)","v":-4.83},137.22777749165365,-4.83,289.2637104034896,-4.83,94.383942347162801,-4.83,419.5936302347011,-4.83,64.742938238214919,-4.83,607.7411590622728,-4.83,-1.5938269051018108,1478.2195281112647]
[null,202306]
[null,"Underlying Price",{"$f":"($E$5+(C$22*($E$10/$E$4)))","v":18365},{"$f":"($E$5+(D$22*($E$10/$E$4)))","v":18365},19771.863333333335,19771.863333333335,16958.136666666665,16958.136666666665,21178.726666666666,21178.726666666666,15551.273333333334,15551.273333333334,22585.59,22585.59,14144.41,14144.41,31026.77,5703.23]
[null,"Strike Price",{"$f":"$E$6","v":10000},{"$f":"$E$6","v":10000},10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,"Interest Rate",{"$f":"$E$7","v":5.042E-2},{"$f":"$E$7","v":5.042E-2},5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2]
[null,"Volatility Scenario",{"$f":"IF($E$8+(C$23*$E$11)>0,$E$8+(C$23*$E$11),0.001)","v":1.0477750000000001},{"$f":"IF($E$8+(D$23*$E$11)>0,$E$8+(D$23*$E$11),0.001)","v":4.7775000000000012E-2},1.0477750000000001,4.7775000000000012E-2,1.0477750000000001,4.7775000000000012E-2,1.0477750000000001,4.7775000000000012E-2,1.0477750000000001,4.7775000000000012E-2,1.0477750000000001,4.7775000000000012E-2,1.0477750000000001,4.7775000000000012E-2,0.54777500000000001,0.54777500000000001]
[null,"Time",{"$f":"$E$9-(2/250)","v":0.24131499199999998},{"$f":"$E$9-(2/250)","v":0.24131499199999998},0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998,0.24131499199999998]
[null,"Scenario Option Price",{"$f":"bsPut(C46,C47,C49,C48,C50)","v":393.1002794002917},{"$f":"bsPut(D46,D47,D49,D48,D50)","v":3.9525685122356473E-147},301.96964382914814,9.7142905819990544E-185,513.77001355918276,2.4895989838050623E-111,232.93568717317413,1.2891912958242212E-223,673.92494334123899,4.3832208332323794E-78,180.45395512465075,2.3304898917434616E-263,886.74301289460368,1.9871395471291094E-48,1.2950489521976031E-2,4258.1750326649189]
[null,"Scenario Option Value",{"$f":"C51*$E$4","v":393.1002794002917},{"$f":"D51*$E$4","v":3.9525685122356473E-147},301.96964382914814,9.7142905819990544E-185,513.77001355918276,2.4895989838050623E-111,232.93568717317413,1.2891912958242212E-223,673.92494334123899,4.3832208332323794E-78,180.45395512465075,2.3304898917434616E-263,886.74301289460368,1.9871395471291094E-48,1.2950489521976031E-2,4258.1750326649189]
[null,"Current Option Value",{"$f":"$E$17","v":16.64},{"$f":"$E$17","v":16.64},16.64,16.64,16.64,16.64,16.64,16.64,16.64,16.64,16.64,16.64,16.64,16.64,16.64,16.64]
[null,"Risk Arrays",{"$f":"C$24*(C52-C53)","v":376.46027940029171},{"$f":"D$24*(D52-D53)","v":-16.64},{"$f":"E$24*(E52-E53)","v":285.32964382914815},{"$f":"F$24*(F52-F53)","v":-16.64},{"$f":"G$24*(G52-G53)","v":497.13001355918277},{"$f":"H$24*(H52-H53)","v":-16.64},{"$f":"I$24*(I52-I53)","v":216.29568717317414},{"$f":"J$24*(J52-J53)","v":-16.64},{"$f":"K$24*(K52-K53)","v":657.284943341239},{"$f":"L$24*(L52-L53)","v":-16.64},{"$f":"M$24*(M52-M53)","v":163.81395512465076},{"$f":"N$24*(N52-N53)","v":-16.64},{"$f":"O$24*(O52-O53)","v":870.10301289460369},{"$f":"P$24*(P52-P53)","v":-16.64},{"$f":"Q$24*(Q52-Q53)","v":-5.4869263384577485},{"$f":"R$24*(R52-R53)","v":1399.7065607794232}]
[null,202307]
[null,"Underlying Price",{"$f":"($F$5+(C$22*($F$10/$F$4)))","v":18222},{"$f":"($F$5+(D$22*($F$10/$F$4)))","v":18222},18731.316666666666,18731.316666666666,17712.683333333334,17712.683333333334,19240.633333333335,19240.633333333335,17203.366666666665,17203.366666666665,19749.95,19749.95,16694.05,16694.05,22805.85,13638.15]
[null,"Strike Price",{"$f":"$F$6","v":10000},{"$f":"$F$6","v":10000},10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,"Interest Rate",{"$f":"$F$7","v":5.042E-2},{"$f":"$F$7","v":5.042E-2},5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2,5.042E-2]
[null,"Volatility Scenario",{"$f":"IF($F$8+(C$23*$F$11)>0,$F$8+(C$23*$F$11),0.001)","v":1.0001720000000001},{"$f":"IF($F$8+(D$23*$F$11)>0,$F$8+(D$23*$F$11),0.001)","v":1.7199999999994997E-4},1.0001720000000001,1.7199999999994997E-4,1.0001720000000001,1.7199999999994997E-4,1.0001720000000001,1.7199999999994997E-4,1.0001720000000001,1.7199999999994997E-4,1.0001720000000001,1.7199999999994997E-4,1.0001720000000001,1.7199999999994997E-4,0.50017199999999995,0.50017199999999995]
[null,"Time",{"$f":"$F$9-(2/250)","v":0.32624699199999996},{"$f":"$F$9-(2/250)","v":0.32624699199999996},0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996,0.32624699199999996]
[null,"Scenario Option Price",{"$f":"bsPut(C56,C57,C59,C58,C60)","v":558.82353419750325},{"$f":"bsPut(D56,D57,D59,D58,D60)","v":0},515.28639059501415,0,606.36971126159108,0,475.40152350996021,0,658.31746092092237,0,438.84479992198106,0,715.09849435799651,0,2.3930328981196571,229.92725496532893]
[null,"Scenario Option Value",{"$f":"C61*$F$4","v":558.82353419750325},{"$f":"D61*$F$4","v":0},515.28639059501415,0,606.36971126159108,0,475.40152350996021,0,658.31746092092237,0,438.84479992198106,0,715.09849435799651,0,2.3930328981196571,229.92725496532893]
[null,"Current Option Value",{"$f":"$F$17","v":26.39},{"$f":"$F$17","v":26.39},26.39,26.39,26.39,26.39,26.39,26.39,26.39,26.39,26.39,26.39,26.39,26.39,26.39,26.39]
[null,"Risk Arrays",{"$f":"C$24*(C62-C63)","v":532.43353419750326},{"$f":"D$24*(D62-D63)","v":-26.39},{"$f":"E$24*(E62-E63)","v":488.89639059501417},{"$f":"F$24*(F62-F63)","v":-26.39},{"$f":"G$24*(G62-G63)","v":579.97971126159109},{"$f":"H$24*(H62-H63)","v":-26.39},{"$f":"I$24*(I62-I63)","v":449.01152350996023},{"$f":"J$24*(J62-J63)","v":-26.39},{"$f":"K$24*(K62-K63)","v":631.92746092092239},{"$f":"L$24*(L62-L63)","v":-26.39},{"$f":"M$24*(M62-M63)","v":412.45479992198108},{"$f":"N$24*(N62-N63)","v":-26.39},{"$f":"O$24*(O62-O63)","v":688.70849435799653},{"$f":"P$24*(P62-P63)","v":-26.39},{"$f":"Q$24*(Q62-Q63)","v":-7.918999143620514},{"$f":"R$24*(R62-R63)","v":67.16729413855856}]

{"sheet":"Spreads","index":7,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,2,8,9],[1,2,1,4],[2,2,3,3]]}
[]
[null,null,"Portfolio Spread Matrix"]
[null,null,null,null,"Long"]
[null,null,null,null,"P5TC Tier3"]
[null,null,"Short","P5TC Tier2","Credit = 0.63 (Spread ID: 55369)"]
[]
[]
[]
[null,null,"Extract from Intercommodity Spread File"]
[null,null,"Spread_ID","Combined_Commodity_A","Tier_A","Combined_Commodity_B","Tier_B","RatioA","RatioB","Spread Credit"]
[null,null,55369,"P5TC",2,"P5TC",3,1527.9534659249662,4220.59,0.62590000000000001]

{"sheet":"Intracommodity Credits","index":8,"n_rows":17,"n_cols":23,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,18,11,20],[4,1,5,1],[4,3,5,3],[4,4,5,4],[1,2,1,3],[4,20,5,20],[9,1,10,1],[9,14,10,14],[9,16,10,16],[4,22,5,22],[9,3,10,3],[4,15,5,15],[4,16,5,16],[4,18,5,18],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,21,5,21],[4,19,5,19],[4,17,5,17]]}
[]
[null,null,"ECC Technical Scaling Factor",null,100]
[]
[null,null,"Product","Combined Commodity","Tier","Call/Put","Strike Price","Contract Volume","Net Position","Scanning Range","SMP","Composite Delta","Original Delta (Net)","Scan Risk","Short Option Minimum","Ratio","Spread Credit","Intracommodity Charge","Number of Spreads","Intracommodity Credit","Intercommodity Credit","SPAN Requirement","Remaining Delta"]
[null,"Intra Tiers ","P5TC","P5TC","Tier 3",null,null,1,100,{"$f":"+Tiers!G8","v":1527.9534659249662},{"$f":"+J5/H5","v":1527.9534659249662},1,{"$f":"((L5*I5*H5)+(L6*I6*H6))/$E$2","v":0.25},{"$f":"+'Risk Arrays and Scan Risk'!AD8","v":38198.836648124154},null,null,null,{"$f":"+Tiers!H8","v":1263.2403712460732},{"$f":"+MIN(ABS(I5),ABS(I6))","v":75},{"$f":"+S5*R5","v":94743.027843455493},null,{"$f":"+ROUND((T5+N5)/100,2)*100","v":132942},{"$f":"+M5","v":0.25}]
[null,null,"P5TC",null,null,null,null,1,-75,{"$f":"+Tiers!G11","v":1527.9534659249662},{"$f":"+J6/H6","v":1527.9534659249662},1]
[]
[]
[]
[null,"Consolidation Combined Commodity","P5TC","P5TC","Tier 2",null,null,1,-50,{"$f":"+'Risk Arrays and Scan Risk'!J7","v":4220.5941585656583},{"$f":"+J10/H10","v":4220.5941585656583},1,{"$f":"(L10*I10*H10)/$E$2","v":-0.5},{"$f":"+'Risk Arrays and Scan Risk'!AD7","v":211029.70792828291},null,{"$f":"+J11","v":1527.9534659249662},{"$f":"+Spreads!J11","v":0.62590000000000001},null,{"$f":"IF(M10*M11<0,ABS(M10/P10),0)","v":3.2723509658543078E-4},null,{"$f":"K10*P10*$E$2*Q10*MIN($S$10:$S$11)","v":23908.651858060908},{"$f":"N10-U10","v":187121.056070222},{"$f":"M10-SIGN(M10)*P10*MIN(S10:S11)","v":-0.40949417259036869}]
[null,null,"P5TC",null,"Tier 3",null,null,1,25,{"$f":"+'Risk Arrays and Scan Risk'!J8","v":1527.9534659249662},{"$f":"+J11/H11","v":1527.9534659249662},1,{"$f":"(L11*I11*H11)/$E$2","v":0.25},{"$f":"+'Risk Arrays and Scan Risk'!AD8","v":38198.836648124154},null,{"$f":"+K10","v":4220.5941585656583},null,null,{"$f":"IF(M10*M11<0,ABS(M11/P11),0)","v":5.9233366347870056E-5},null,{"$f":"K11*P11*$E$2*Q10*MIN($S$10:$S$11)","v":23908.651858060908},{"$f":"+N11-U11","v":14290.184790063246},{"$f":"M11-SIGN(M11)*P11*MIN(S10:S11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPAN Margin",null,null,{"$f":"T5+V10+V11","v":296154.26870374073}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]