{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Seller Quote to Freddie Mac","Sizing Roll-up","Pricing Roll-up","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":37,"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":"Seller Quote to Freddie Mac","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,8,44,10],[41,7,41,10],[16,3,16,5],[21,3,21,5],[40,1,44,5],[37,7,40,10],[26,1,28,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[29,1,29,5],[27,7,27,10],[39,1,39,5],[32,1,32,5],[30,1,30,5],[31,1,31,5],[42,8,42,10],[43,8,43,10],[25,7,25,8],[24,7,24,8],[23,9,23,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[13,9,13,10],[13,1,13,2],[14,1,14,2],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[14,3,14,5],[13,3,13,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[24,1,24,5],[25,1,25,5],[36,1,37,5],[2,4,3,10],[12,7,12,10],[10,7,10,8],[9,7,9,8],[8,7,8,8],[7,7,7,8],[6,7,6,8],[12,1,12,5],[23,7,23,8],[24,9,24,10],[25,9,25,10],[20,1,20,2],[14,9,14,10],[22,7,22,10],[21,1,21,2],[22,1,22,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[22,3,22,5],[15,3,15,5],[16,9,16,10],[15,9,15,10],[20,3,20,5],[19,3,19,5],[18,3,18,5],[17,3,17,5]]}
[]
[]
[null,null,null,null,"SBL Portfolio Quote Sheet"]
[]
[]
[]
[null,"Optigo Lender:",null,null,null,null,null,"Quote Expiration Date:"]
[null,"Originator:",null,null,null,null,null,"Quote Acceptance Date:"]
[null,"Key Borrower Pricinpal(s):",null,null,null,null,null,"Good Faith Deposit Cost:"]
[null,"Broker:",null,null,null,null,null,"Good Faith Deposit Due Date:"]
[null,"Outside Fee:",null,null,null,null,null,"Expected UW Delivery Date:"]
[]
[null,"Profolio Summary",null,null,null,null,null,"Terms"]
[null,"Portfolio Name:",null,null,null,null,null,"Loan Term:"]
[null,"Portfolio Purpose:",null,null,null,null,null,"Amortization Term:"]
[null,"UPB:",null,{"$f":"'Sizing Roll-up'!E14","v":0},null,null,null,"Interest Only Period:"]
[null,"Cash Out:",null,{"$f":"'Sizing Roll-up'!E15","v":0},null,null,null,"Prepayment Option:"]
[null,"# of Properties:",null,{"$f":"'Sizing Roll-up'!E12","v":0},null,null,null,"Weighted Avg Buy-up:",null,{"$f":"'Pricing Roll-up'!K24","v":""}]
[null,"# of Units:",null,{"$f":"'Sizing Roll-up'!E13","v":0},null,null,null,"Lender Servicing:",null,{"$f":"'Pricing Roll-up'!C6","v":0}]
[null,"# Mission Driven Units:",null,{"$f":"'Sizing Roll-up'!G12","v":0},null,null,null,"Maximum LTV:",null,{"$f":"'Sizing Roll-up'!N33","v":""}]
[null,"% Mission Driven:",null,{"$f":"'Sizing Roll-up'!G13","v":""},null,null,null,"Minimum DSCR:",null,{"$f":"'Sizing Roll-up'!O33","v":""}]
[null,"# of LI Units:",null,{"$f":"'Sizing Roll-up'!AE33","v":0}]
[null,"# of < 60% AMI Units:",null,{"$f":"'Sizing Roll-up'!AC33","v":0},null,null,null,"Interest Rate"]
[null,null,null,null,null,null,null,"Weighted Average Grid Rate:",null,{"$f":"'Pricing Roll-up'!W24","v":""}]
[null,"Standard Stipulations:",null,null,null,null,null,"Weighted Average Discount:",null,{"$f":"'Pricing Roll-up'!X24","v":""}]
[null,"Quote Subject to (Unless Noted Otherwise):\n",null,null,null,null,null,"Weighted Average Discounted Rate:",null,{"$f":"'Pricing Roll-up'!Y24","v":""}]
[null,"- Lender submits a complete underwriting package for Freddie Mac approval within 35 business days from acceptance of the terms outlined herein by the borrower, lender and Freddie Mac and the receipt of good faith Deposit. "]
[null,null,null,null,null,null,null,"Portfolio Exceptions/Assumptions"]
[]
[null,"-Full due-diligence on Borrower, Key Principal(s), and/or Guarantor(s)"]
[null,"-Review of final organizational chart and borrowing structure"]
[null,"-Quote assumes no preferred equity"]
[null,"-Assumes no tenancy concentration(s)"]
[null,"-Satisfactory FM site inspection prior to package submission"]
[null,"-Quote assumes all standard documents will be used.   "]
[null,"-Material changes from assumptions noted herein may impact pricing."]
[null,"-Should the Borrower elect an alternate interest rate type and/or loan term after this Quote is accepted, revised terms will be subject to the corresponding rates and timeframes determined on the date of this Quote outlined herein."]
[null,null,null,null,null,null,null,"Pursuant to the Freddie Mac Multifamily Seller/Servicer Guide (the \"Guide\"), issuance of this Quote does not obligate the Seller to submit a full underwriting package nor does it obligate Freddie Mac to purchase the proposed Mortgage loan. Accordingly, this Quote is not a contract or commitment, nor an offer to enter into a contract or commitment, for the purchase of the proposed Mortgage loan, and terms and conditions can change at anytime."]
[]
[null,"Additional Portfolio-Specific Stipulations:"]
[]
[null,null,null,null,null,null,null,"Approvals"]
[null,null,null,null,null,null,null,"Production Approver"]
[null,null,null,null,null,null,null,"Credit Approver"]
[null,null,null,null,null,null,null,"Cap Markets Approver"]

{"sheet":"Sizing Roll-up","index":1,"n_rows":33,"n_cols":34,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,3],[10,1,10,2],[10,3,10,6],[10,7,10,8]]}
[]
[null,"INSTRUCTIONS"]
[null,"1. Ensure \"Total Rows\" shows more rows than deals in portfolio. "]
[null,"2. Fill out \"Sizing Roll-up\" and \"Pricing  Roll-up\" sheets using Color Key"]
[null,"3. Fill out Input Section in \"Pricing Roll-up\""]
[null,"4. Fill out Market Dependent Pricing Inputs Section in \"Pricing Roll-up\""]
[null,"5. Fill out additional information in \"Seller Quote to Freddie Mac\""]
[null,"6. Save and send with the Portfolio Brief Word file"]
[null,"NOTE: If asking for multiple quotes, send in separate spreadsheets."]
[]
[null,"Loan Terms",null,"Portfolio Summary",null,null,null,"Sizing Summary",null,null,"Total Rows:"]
[null,"Loan Term",{"$f":"'Pricing Roll-up'!C4","v":0},"# of Properties",{"$f":"COUNT('Pricing Roll-up'!I13:I23)","v":0},"# Mission Driven",{"$f":"Z33","v":0},"Min DSCR",{"$f":"MIN(O22:O32)","v":0},null,{"$f":"COUNT(A22:A33)","v":11}]
[null,"Base Rate",{"$f":"'Pricing Roll-up'!C5","v":0},"# of Units",{"$f":"G33","v":0},"% Mission Driven",{"$f":"AA33","v":""},"Max DSCR",{"$f":"MAX(O22:O32)","v":0}]
[null,"Servicing Fee",{"$f":"'Pricing Roll-up'!C6","v":0},"UPB",{"$f":"K33","v":0},"# Units <60% AMI",{"$f":"AC33","v":0},"Min LTV",{"$f":"MIN(N22:N32)","v":0}]
[null,"I/O",{"$f":"'Pricing Roll-up'!C7","v":0},"Cash Out",{"$f":"L33","v":0},"% Units <60% AMI",{"$f":"AD33","v":""},"Max LTV",{"$f":"MAX(N22:N32)","v":0}]
[null,"I/O Adder (total cost of I/O)",{"$f":"'Pricing Roll-up'!C8","v":0},"% Cash Out",{"$f":"IFERROR(E15/J33,\"\")","v":""},null,null,"# Sized @ Min DSCR",{"$f":"COUNTIF(O22:O32,I12)","v":0}]
[null,"Prepayment",{"$f":"'Pricing Roll-up'!C9","v":0},"WA LTV",{"$f":"N33","v":""},"WA Discount",{"$f":"'Pricing Roll-up'!X24","v":""},"# Sized @ Max LTV",{"$f":"COUNTIF(N22:N32,I15)","v":0}]
[null,"Prepayment Cost",{"$f":"'Pricing Roll-up'!C10","v":0},"WA DSCR",{"$f":"O33","v":""},"WA Rate",{"$f":"AH33","v":""}]
[]
[]
[null,"Property Name","Address","City","State","Market Tier","Units","Purchase Month","Length of Ownership","Existing Debt / Purchase Price","Loan","Cash Out / Cash Equity","Assumed Value","LTV","DCR","Occupancy","GPR","UW Vacancy","NRI","Expenses","Exp/Unit","NOI","Assumed Cap Rate","Expense Ratio","Mission Qualified (Y/N)","# Mission Driven Units","% Mission Driven Units","<60% AMI Qualified (Y/N)","# of Units <60% AMI","% of Units <60% AMI","# of Units LI","% of Units LI","Note Rate at Grid","Note Rate at Request"]
[1,null,null,null,null,null,null,null,{"$f":"IF(H22=\"\",\"\",(TODAY()-H22)/365)","v":""},null,null,{"$f":"IF(K22=\"\",\"\",K22-J22)","v":""},null,{"$f":"IFERROR(K22/M22,\"\")","v":""},null,null,null,null,{"$f":"IF(Q22=\"\",\"\",Q22*(1-R22))","v":""},null,{"$f":"IFERROR(T22/G22,\"\")","v":""},{"$f":"IFERROR(S22-T22,\"\")","v":""},{"$f":"IFERROR(V22/M22,\"\")","v":""},{"$f":"IFERROR(T22/S22,\"\")","v":""},null,null,{"$f":"IFERROR(Z22/G22,\"\")","v":""},null,null,{"$f":"IFERROR(AC22/G22,\"\")","v":""},null,{"$f":"IFERROR(AE22/G22,\"\")","v":""},{"$f":"IF('Pricing Roll-up'!W13=\"\",\"\",'Pricing Roll-up'!W13)","v":""},{"$f":"IF('Pricing Roll-up'!Y13=\"\",\"\",'Pricing Roll-up'!Y13)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(H23=\"\",\"\",(TODAY()-H23)/365)","v":""},null,null,"",null,"",null,null,null,null,{"$f":"IF(Q23=\"\",\"\",Q23*(1-R23))","v":""},null,{"$f":"IFERROR(T23/G23,\"\")","v":""},"","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W14=\"\",\"\",'Pricing Roll-up'!W14)","v":""},{"$f":"IF('Pricing Roll-up'!Y14=\"\",\"\",'Pricing Roll-up'!Y14)","v":""}]
[3,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,null,"",null,{"$f":"IFERROR(T24/G24,\"\")","v":""},"","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W15=\"\",\"\",'Pricing Roll-up'!W15)","v":""},{"$f":"IF('Pricing Roll-up'!Y15=\"\",\"\",'Pricing Roll-up'!Y15)","v":""}]
[4,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(K25=\"\",\"\",K25-J25)","v":""},null,{"$f":"IFERROR(K25/M25,\"\")","v":""},null,null,null,null,"",null,{"$f":"IFERROR(T25/G25,\"\")","v":""},"","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W16=\"\",\"\",'Pricing Roll-up'!W16)","v":""},{"$f":"IF('Pricing Roll-up'!Y16=\"\",\"\",'Pricing Roll-up'!Y16)","v":""}]
[5,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(K26=\"\",\"\",K26-J26)","v":""},null,{"$f":"IFERROR(K26/M26,\"\")","v":""},null,null,null,null,"",null,"","","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W17=\"\",\"\",'Pricing Roll-up'!W17)","v":""},{"$f":"IF('Pricing Roll-up'!Y17=\"\",\"\",'Pricing Roll-up'!Y17)","v":""}]
[6,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,null,"",null,"","","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W18=\"\",\"\",'Pricing Roll-up'!W18)","v":""},{"$f":"IF('Pricing Roll-up'!Y18=\"\",\"\",'Pricing Roll-up'!Y18)","v":""}]
[7,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,null,"",null,"","","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W19=\"\",\"\",'Pricing Roll-up'!W19)","v":""},{"$f":"IF('Pricing Roll-up'!Y19=\"\",\"\",'Pricing Roll-up'!Y19)","v":""}]
[8,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,null,"",null,"","","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W20=\"\",\"\",'Pricing Roll-up'!W20)","v":""},{"$f":"IF('Pricing Roll-up'!Y20=\"\",\"\",'Pricing Roll-up'!Y20)","v":""}]
[9,null,null,null,null,null,null,null,{"$f":"IF(H30=\"\",\"\",(TODAY()-H30)/365)","v":""},null,null,{"$f":"IF(K30=\"\",\"\",K30-J30)","v":""},null,{"$f":"IFERROR(K30/M30,\"\")","v":""},null,null,null,null,{"$f":"IF(Q30=\"\",\"\",Q30*(1-R30))","v":""},null,{"$f":"IFERROR(T30/G30,\"\")","v":""},"","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W21=\"\",\"\",'Pricing Roll-up'!W21)","v":""},{"$f":"IF('Pricing Roll-up'!Y21=\"\",\"\",'Pricing Roll-up'!Y21)","v":""}]
[10,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,null,"",null,"","","","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W22=\"\",\"\",'Pricing Roll-up'!W22)","v":""},{"$f":"IF('Pricing Roll-up'!Y22=\"\",\"\",'Pricing Roll-up'!Y22)","v":""}]
[11,null,null,null,null,null,null,null,{"$f":"IF(H32=\"\",\"\",(TODAY()-H32)/365)","v":""},null,null,"",null,"",null,null,null,null,{"$f":"IF(Q32=\"\",\"\",Q32*(1-R32))","v":""},null,{"$f":"IFERROR(T32/G32,\"\")","v":""},{"$f":"IFERROR(S32-T32,\"\")","v":""},"","",null,null,"",null,null,"",null,"",{"$f":"IF('Pricing Roll-up'!W23=\"\",\"\",'Pricing Roll-up'!W23)","v":""},{"$f":"IF('Pricing Roll-up'!Y23=\"\",\"\",'Pricing Roll-up'!Y23)","v":""}]
[null,"Total",{"$f":"COUNT(K22:K32)","v":0},null,null,null,{"$f":"SUM(G22:G32)","v":0},null,{"$f":"IFERROR(AVERAGE(I22:I32),\"\")","v":""},{"$f":"SUM(J22:J32)","v":0},{"$f":"SUM(K22:K32)","v":0},{"$f":"SUM(L22:L32)","v":0},{"$f":"SUM(M22:M32)","v":0},{"$f":"IFERROR(SUMPRODUCT(N22:N32,K22:K32)/SUM(K22:K32),\"\")","v":""},{"$f":"IFERROR(SUMPRODUCT(O22:O32,K22:K32)/SUM(K22:K32),\"\")","v":""},{"$f":"IFERROR(SUMPRODUCT(P22:P32,K22:K32)/SUM(K22:K32),\"\")","v":""},{"$f":"SUM(Q22:Q32)","v":0},{"$f":"IFERROR(SUMPRODUCT(R22:R32,K22:K32)/SUM(K22:K32),\"\")","v":""},{"$f":"SUM(S22:S32)","v":0},{"$f":"SUM(T22:T32)","v":0},{"$f":"SUM(U22:U32)","v":0},{"$f":"SUM(V22:V32)","v":0},{"$f":"IFERROR(AVERAGE(W22:W32),\"\")","v":""},{"$f":"IFERROR(SUMPRODUCT(X22:X32,K22:K32)/SUM(K22:K32),\"\")","v":""},null,{"$f":"SUM(Z22:Z32)","v":0},"",null,{"$f":"SUM(AC22:AC32)","v":0},"",{"$f":"SUM(AE22:AE32)","v":0},"",{"$f":"IFERROR(SUMPRODUCT(AG22:AG32,K22:K32)/SUM(K22:K32),\"\")","v":""},{"$f":"IFERROR(SUMPRODUCT(AH22:AH32,K22:K32)/SUM(K22:K32),\"\")","v":""}]

{"sheet":"Pricing Roll-up","index":2,"n_rows":24,"n_cols":28,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,8,9,8],[1,9,1,12],[1,1,1,6],[2,9,2,12],[2,1,2,2],[2,3,2,6]]}
[]
[null,"SBL Portfolio Summary",null,null,null,null,null,null,null,"Market Dependent Pricing Inputs"]
[null,"Loan Terms",null,"Portfolio Summary",null,null,null,null,null,"Parameter Adjustments"]
[null,"Loan Term",null,"# of Properties",{"$f":"'Sizing Roll-up'!E12","v":0},"# Mission Driven",{"$f":"'Sizing Roll-up'!Z33","v":0},null,null,"LTV","%","DSCR","%"]
[null,"Base Rate",null,"# of Units",{"$f":"'Sizing Roll-up'!E13","v":0},"% Mission Driven",{"$f":"'Sizing Roll-up'!AA33","v":""},null,null,0.7,-4.0000000000000002E-4,1.3,-5.9999999999999995E-4]
[null,"Servicing Fee",null,"UPB",{"$f":"'Sizing Roll-up'!E14","v":0},"# Units <60% AMI",{"$f":"'Sizing Roll-up'!AC33","v":0},null,null,0.65,-8.0000000000000004E-4,1.4,-1.1999999999999999E-3]
[null,"I/O",null,"Cash Out",{"$f":"'Sizing Roll-up'!E15","v":0},"% Units <60% AMI",{"$f":"'Sizing Roll-up'!AD33","v":""},null,null,0.55000000000000004,-1.1999999999999999E-3,1.5,-1.6000000000000001E-3]
[null,"I/O Adder (total cost of I/O)",null,"% Cash Out",{"$f":"'Sizing Roll-up'!E16","v":""},null,null,null,"*Note - Adjust mission driven threshold for market","Affordability","Mission Driven","Ultra Mission","< 60% AMI"]
[null,"Prepayment",null,"WA LTV",{"$f":"'Sizing Roll-up'!E17","v":""},"WA Discount",{"$f":"X24","v":""},null,null,"Threshold",0.5,0.8,0.3]
[null,"Prepayment Cost",null,"WA DSCR",{"$f":"'Sizing Roll-up'!E18","v":""},"WA Rate",{"$f":"Y24","v":""},null,null,"Discount",-1.5E-3,-3.0000000000000001E-3,-1E-3]
[]
[null,"Property Name","Address","City","State","Market Tier","Units","Purchase Month","Loan","Loan Term","Premium","Prepay","Base Rate","Servicing\nFee","LTV \nADJ","DSCR \nADJ","Prepay \nADJ","IO \nADJ","Prem Adj","Uncapped Disc","< 60% AMI Discount","Total ADJ","Note Rate at Grid","Pricing Discount Requested","Note Rate at Request","Mission Qualified (Y/N)","# Mission Driven Units","% Mission Driven Units"]
[1,{"$f":"IF('Sizing Roll-up'!B22=\"\",\"\",'Sizing Roll-up'!B22)","v":""},{"$f":"IF('Sizing Roll-up'!C22=\"\",\"\",'Sizing Roll-up'!C22)","v":""},{"$f":"IF('Sizing Roll-up'!D22=\"\",\"\",'Sizing Roll-up'!D22)","v":""},{"$f":"IF('Sizing Roll-up'!E22=\"\",\"\",'Sizing Roll-up'!E22)","v":""},{"$f":"IF('Sizing Roll-up'!F22=\"\",\"\",'Sizing Roll-up'!F22)","v":""},{"$f":"IF('Sizing Roll-up'!G22=\"\",\"\",'Sizing Roll-up'!G22)","v":""},{"$f":"IF('Sizing Roll-up'!H22=\"\",\"\",'Sizing Roll-up'!H22)","v":""},{"$f":"IF('Sizing Roll-up'!K22=\"\",\"\",'Sizing Roll-up'!K22)","v":""},{"$f":"IF('Sizing Roll-up'!B22=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I13=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I13=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I13=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N22=\"\",\"\",IF('Sizing Roll-up'!N22<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N22<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N22<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O22=\"\",\"\",IF('Sizing Roll-up'!O22>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O22>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O22>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I13=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I13=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I13=\"\",\"\",ROUNDUP((K13/0.01)*(INDEX(Premium[Adder],MATCH(J13,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA22=\"\",\"\",IF('Sizing Roll-up'!AA22>=$L$9,$L$10,IF('Sizing Roll-up'!AA22>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD22=\"\",\"\",IF('Sizing Roll-up'!AD22>=$M$9,$M$10,0))","v":""},{"$f":"IF(I13=\"\",\"\",(SUM(O13:U13)))","v":""},{"$f":"IF(I13=\"\",\"\",(SUM(M13:U13)))","v":""},null,{"$f":"IF(I13=\"\",\"\",(W13+X13))","v":""},{"$f":"IF('Sizing Roll-up'!Y22=\"\",\"\",'Sizing Roll-up'!Y22)","v":""},{"$f":"IF('Sizing Roll-up'!Z22=\"\",\"\",'Sizing Roll-up'!Z22)","v":""},{"$f":"IF('Sizing Roll-up'!AA22=\"\",\"\",'Sizing Roll-up'!AA22)","v":""}]
[2,{"$f":"IF('Sizing Roll-up'!B23=\"\",\"\",'Sizing Roll-up'!B23)","v":""},{"$f":"IF('Sizing Roll-up'!C23=\"\",\"\",'Sizing Roll-up'!C23)","v":""},{"$f":"IF('Sizing Roll-up'!D23=\"\",\"\",'Sizing Roll-up'!D23)","v":""},{"$f":"IF('Sizing Roll-up'!E23=\"\",\"\",'Sizing Roll-up'!E23)","v":""},{"$f":"IF('Sizing Roll-up'!F23=\"\",\"\",'Sizing Roll-up'!F23)","v":""},{"$f":"IF('Sizing Roll-up'!G23=\"\",\"\",'Sizing Roll-up'!G23)","v":""},{"$f":"IF('Sizing Roll-up'!H23=\"\",\"\",'Sizing Roll-up'!H23)","v":""},{"$f":"IF('Sizing Roll-up'!K23=\"\",\"\",'Sizing Roll-up'!K23)","v":""},{"$f":"IF('Sizing Roll-up'!B23=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I14=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I14=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I14=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N23=\"\",\"\",IF('Sizing Roll-up'!N23<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N23<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N23<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O23=\"\",\"\",IF('Sizing Roll-up'!O23>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O23>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O23>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I14=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I14=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I14=\"\",\"\",ROUNDUP((K14/0.01)*(INDEX(Premium[Adder],MATCH(J14,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA23=\"\",\"\",IF('Sizing Roll-up'!AA23>=$L$9,$L$10,IF('Sizing Roll-up'!AA23>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD23=\"\",\"\",IF('Sizing Roll-up'!AD23>=$M$9,$M$10,0))","v":""},"","",null,{"$f":"IF(I14=\"\",\"\",(W14+X14))","v":""},{"$f":"IF('Sizing Roll-up'!Y23=\"\",\"\",'Sizing Roll-up'!Y23)","v":""},{"$f":"IF('Sizing Roll-up'!Z23=\"\",\"\",'Sizing Roll-up'!Z23)","v":""},{"$f":"IF('Sizing Roll-up'!AA23=\"\",\"\",'Sizing Roll-up'!AA23)","v":""}]
[3,{"$f":"IF('Sizing Roll-up'!B24=\"\",\"\",'Sizing Roll-up'!B24)","v":""},{"$f":"IF('Sizing Roll-up'!C24=\"\",\"\",'Sizing Roll-up'!C24)","v":""},{"$f":"IF('Sizing Roll-up'!D24=\"\",\"\",'Sizing Roll-up'!D24)","v":""},{"$f":"IF('Sizing Roll-up'!E24=\"\",\"\",'Sizing Roll-up'!E24)","v":""},{"$f":"IF('Sizing Roll-up'!F24=\"\",\"\",'Sizing Roll-up'!F24)","v":""},{"$f":"IF('Sizing Roll-up'!G24=\"\",\"\",'Sizing Roll-up'!G24)","v":""},{"$f":"IF('Sizing Roll-up'!H24=\"\",\"\",'Sizing Roll-up'!H24)","v":""},{"$f":"IF('Sizing Roll-up'!K24=\"\",\"\",'Sizing Roll-up'!K24)","v":""},{"$f":"IF('Sizing Roll-up'!B24=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I15=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I15=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I15=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N24=\"\",\"\",IF('Sizing Roll-up'!N24<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N24<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N24<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O24=\"\",\"\",IF('Sizing Roll-up'!O24>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O24>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O24>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I15=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I15=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I15=\"\",\"\",ROUNDUP((K15/0.01)*(INDEX(Premium[Adder],MATCH(J15,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA24=\"\",\"\",IF('Sizing Roll-up'!AA24>=$L$9,$L$10,IF('Sizing Roll-up'!AA24>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD24=\"\",\"\",IF('Sizing Roll-up'!AD24>=$M$9,$M$10,0))","v":""},"","",null,"",{"$f":"IF('Sizing Roll-up'!Y24=\"\",\"\",'Sizing Roll-up'!Y24)","v":""},{"$f":"IF('Sizing Roll-up'!Z24=\"\",\"\",'Sizing Roll-up'!Z24)","v":""},{"$f":"IF('Sizing Roll-up'!AA24=\"\",\"\",'Sizing Roll-up'!AA24)","v":""}]
[4,{"$f":"IF('Sizing Roll-up'!B25=\"\",\"\",'Sizing Roll-up'!B25)","v":""},{"$f":"IF('Sizing Roll-up'!C25=\"\",\"\",'Sizing Roll-up'!C25)","v":""},{"$f":"IF('Sizing Roll-up'!D25=\"\",\"\",'Sizing Roll-up'!D25)","v":""},{"$f":"IF('Sizing Roll-up'!E25=\"\",\"\",'Sizing Roll-up'!E25)","v":""},{"$f":"IF('Sizing Roll-up'!F25=\"\",\"\",'Sizing Roll-up'!F25)","v":""},{"$f":"IF('Sizing Roll-up'!G25=\"\",\"\",'Sizing Roll-up'!G25)","v":""},{"$f":"IF('Sizing Roll-up'!H25=\"\",\"\",'Sizing Roll-up'!H25)","v":""},{"$f":"IF('Sizing Roll-up'!K25=\"\",\"\",'Sizing Roll-up'!K25)","v":""},{"$f":"IF('Sizing Roll-up'!B25=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I16=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I16=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I16=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N25=\"\",\"\",IF('Sizing Roll-up'!N25<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N25<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N25<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O25=\"\",\"\",IF('Sizing Roll-up'!O25>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O25>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O25>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I16=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I16=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I16=\"\",\"\",ROUNDUP((K16/0.01)*(INDEX(Premium[Adder],MATCH(J16,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA25=\"\",\"\",IF('Sizing Roll-up'!AA25>=$L$9,$L$10,IF('Sizing Roll-up'!AA25>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD25=\"\",\"\",IF('Sizing Roll-up'!AD25>=$M$9,$M$10,0))","v":""},{"$f":"IF(I16=\"\",\"\",(SUM(O16:U16)))","v":""},{"$f":"IF(I16=\"\",\"\",(SUM(M16:U16)))","v":""},null,"",{"$f":"IF('Sizing Roll-up'!Y25=\"\",\"\",'Sizing Roll-up'!Y25)","v":""},{"$f":"IF('Sizing Roll-up'!Z25=\"\",\"\",'Sizing Roll-up'!Z25)","v":""},{"$f":"IF('Sizing Roll-up'!AA25=\"\",\"\",'Sizing Roll-up'!AA25)","v":""}]
[5,{"$f":"IF('Sizing Roll-up'!B26=\"\",\"\",'Sizing Roll-up'!B26)","v":""},{"$f":"IF('Sizing Roll-up'!C26=\"\",\"\",'Sizing Roll-up'!C26)","v":""},{"$f":"IF('Sizing Roll-up'!D26=\"\",\"\",'Sizing Roll-up'!D26)","v":""},{"$f":"IF('Sizing Roll-up'!E26=\"\",\"\",'Sizing Roll-up'!E26)","v":""},{"$f":"IF('Sizing Roll-up'!F26=\"\",\"\",'Sizing Roll-up'!F26)","v":""},{"$f":"IF('Sizing Roll-up'!G26=\"\",\"\",'Sizing Roll-up'!G26)","v":""},{"$f":"IF('Sizing Roll-up'!H26=\"\",\"\",'Sizing Roll-up'!H26)","v":""},{"$f":"IF('Sizing Roll-up'!K26=\"\",\"\",'Sizing Roll-up'!K26)","v":""},{"$f":"IF('Sizing Roll-up'!B26=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I17=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I17=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I17=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N26=\"\",\"\",IF('Sizing Roll-up'!N26<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N26<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N26<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O26=\"\",\"\",IF('Sizing Roll-up'!O26>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O26>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O26>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I17=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I17=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I17=\"\",\"\",ROUNDUP((K17/0.01)*(INDEX(Premium[Adder],MATCH(J17,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA26=\"\",\"\",IF('Sizing Roll-up'!AA26>=$L$9,$L$10,IF('Sizing Roll-up'!AA26>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD26=\"\",\"\",IF('Sizing Roll-up'!AD26>=$M$9,$M$10,0))","v":""},"","",null,"",{"$f":"IF('Sizing Roll-up'!Y26=\"\",\"\",'Sizing Roll-up'!Y26)","v":""},{"$f":"IF('Sizing Roll-up'!Z26=\"\",\"\",'Sizing Roll-up'!Z26)","v":""},{"$f":"IF('Sizing Roll-up'!AA26=\"\",\"\",'Sizing Roll-up'!AA26)","v":""}]
[6,{"$f":"IF('Sizing Roll-up'!B27=\"\",\"\",'Sizing Roll-up'!B27)","v":""},{"$f":"IF('Sizing Roll-up'!C27=\"\",\"\",'Sizing Roll-up'!C27)","v":""},{"$f":"IF('Sizing Roll-up'!D27=\"\",\"\",'Sizing Roll-up'!D27)","v":""},{"$f":"IF('Sizing Roll-up'!E27=\"\",\"\",'Sizing Roll-up'!E27)","v":""},{"$f":"IF('Sizing Roll-up'!F27=\"\",\"\",'Sizing Roll-up'!F27)","v":""},{"$f":"IF('Sizing Roll-up'!G27=\"\",\"\",'Sizing Roll-up'!G27)","v":""},{"$f":"IF('Sizing Roll-up'!H27=\"\",\"\",'Sizing Roll-up'!H27)","v":""},{"$f":"IF('Sizing Roll-up'!K27=\"\",\"\",'Sizing Roll-up'!K27)","v":""},{"$f":"IF('Sizing Roll-up'!B27=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I18=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I18=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I18=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N27=\"\",\"\",IF('Sizing Roll-up'!N27<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N27<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N27<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O27=\"\",\"\",IF('Sizing Roll-up'!O27>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O27>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O27>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I18=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I18=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I18=\"\",\"\",ROUNDUP((K18/0.01)*(INDEX(Premium[Adder],MATCH(J18,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA27=\"\",\"\",IF('Sizing Roll-up'!AA27>=$L$9,$L$10,IF('Sizing Roll-up'!AA27>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD27=\"\",\"\",IF('Sizing Roll-up'!AD27>=$M$9,$M$10,0))","v":""},"","",null,"",{"$f":"IF('Sizing Roll-up'!Y27=\"\",\"\",'Sizing Roll-up'!Y27)","v":""},{"$f":"IF('Sizing Roll-up'!Z27=\"\",\"\",'Sizing Roll-up'!Z27)","v":""},{"$f":"IF('Sizing Roll-up'!AA27=\"\",\"\",'Sizing Roll-up'!AA27)","v":""}]
[7,{"$f":"IF('Sizing Roll-up'!B28=\"\",\"\",'Sizing Roll-up'!B28)","v":""},{"$f":"IF('Sizing Roll-up'!C28=\"\",\"\",'Sizing Roll-up'!C28)","v":""},{"$f":"IF('Sizing Roll-up'!D28=\"\",\"\",'Sizing Roll-up'!D28)","v":""},{"$f":"IF('Sizing Roll-up'!E28=\"\",\"\",'Sizing Roll-up'!E28)","v":""},{"$f":"IF('Sizing Roll-up'!F28=\"\",\"\",'Sizing Roll-up'!F28)","v":""},{"$f":"IF('Sizing Roll-up'!G28=\"\",\"\",'Sizing Roll-up'!G28)","v":""},{"$f":"IF('Sizing Roll-up'!H28=\"\",\"\",'Sizing Roll-up'!H28)","v":""},{"$f":"IF('Sizing Roll-up'!K28=\"\",\"\",'Sizing Roll-up'!K28)","v":""},{"$f":"IF('Sizing Roll-up'!B28=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I19=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I19=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I19=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N28=\"\",\"\",IF('Sizing Roll-up'!N28<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N28<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N28<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O28=\"\",\"\",IF('Sizing Roll-up'!O28>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O28>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O28>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I19=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I19=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I19=\"\",\"\",ROUNDUP((K19/0.01)*(INDEX(Premium[Adder],MATCH(J19,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA28=\"\",\"\",IF('Sizing Roll-up'!AA28>=$L$9,$L$10,IF('Sizing Roll-up'!AA28>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD28=\"\",\"\",IF('Sizing Roll-up'!AD28>=$M$9,$M$10,0))","v":""},"","",null,"",{"$f":"IF('Sizing Roll-up'!Y28=\"\",\"\",'Sizing Roll-up'!Y28)","v":""},{"$f":"IF('Sizing Roll-up'!Z28=\"\",\"\",'Sizing Roll-up'!Z28)","v":""},{"$f":"IF('Sizing Roll-up'!AA28=\"\",\"\",'Sizing Roll-up'!AA28)","v":""}]
[8,{"$f":"IF('Sizing Roll-up'!B29=\"\",\"\",'Sizing Roll-up'!B29)","v":""},{"$f":"IF('Sizing Roll-up'!C29=\"\",\"\",'Sizing Roll-up'!C29)","v":""},{"$f":"IF('Sizing Roll-up'!D29=\"\",\"\",'Sizing Roll-up'!D29)","v":""},{"$f":"IF('Sizing Roll-up'!E29=\"\",\"\",'Sizing Roll-up'!E29)","v":""},{"$f":"IF('Sizing Roll-up'!F29=\"\",\"\",'Sizing Roll-up'!F29)","v":""},{"$f":"IF('Sizing Roll-up'!G29=\"\",\"\",'Sizing Roll-up'!G29)","v":""},{"$f":"IF('Sizing Roll-up'!H29=\"\",\"\",'Sizing Roll-up'!H29)","v":""},{"$f":"IF('Sizing Roll-up'!K29=\"\",\"\",'Sizing Roll-up'!K29)","v":""},{"$f":"IF('Sizing Roll-up'!B29=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I20=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I20=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I20=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N29=\"\",\"\",IF('Sizing Roll-up'!N29<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N29<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N29<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O29=\"\",\"\",IF('Sizing Roll-up'!O29>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O29>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O29>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I20=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I20=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I20=\"\",\"\",ROUNDUP((K20/0.01)*(INDEX(Premium[Adder],MATCH(J20,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA29=\"\",\"\",IF('Sizing Roll-up'!AA29>=$L$9,$L$10,IF('Sizing Roll-up'!AA29>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD29=\"\",\"\",IF('Sizing Roll-up'!AD29>=$M$9,$M$10,0))","v":""},"","",null,"",{"$f":"IF('Sizing Roll-up'!Y29=\"\",\"\",'Sizing Roll-up'!Y29)","v":""},{"$f":"IF('Sizing Roll-up'!Z29=\"\",\"\",'Sizing Roll-up'!Z29)","v":""},{"$f":"IF('Sizing Roll-up'!AA29=\"\",\"\",'Sizing Roll-up'!AA29)","v":""}]
[9,{"$f":"IF('Sizing Roll-up'!B30=\"\",\"\",'Sizing Roll-up'!B30)","v":""},{"$f":"IF('Sizing Roll-up'!C30=\"\",\"\",'Sizing Roll-up'!C30)","v":""},{"$f":"IF('Sizing Roll-up'!D30=\"\",\"\",'Sizing Roll-up'!D30)","v":""},{"$f":"IF('Sizing Roll-up'!E30=\"\",\"\",'Sizing Roll-up'!E30)","v":""},{"$f":"IF('Sizing Roll-up'!F30=\"\",\"\",'Sizing Roll-up'!F30)","v":""},{"$f":"IF('Sizing Roll-up'!G30=\"\",\"\",'Sizing Roll-up'!G30)","v":""},{"$f":"IF('Sizing Roll-up'!H30=\"\",\"\",'Sizing Roll-up'!H30)","v":""},{"$f":"IF('Sizing Roll-up'!K30=\"\",\"\",'Sizing Roll-up'!K30)","v":""},{"$f":"IF('Sizing Roll-up'!B30=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I21=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I21=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I21=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N30=\"\",\"\",IF('Sizing Roll-up'!N30<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N30<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N30<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O30=\"\",\"\",IF('Sizing Roll-up'!O30>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O30>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O30>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I21=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I21=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I21=\"\",\"\",ROUNDUP((K21/0.01)*(INDEX(Premium[Adder],MATCH(J21,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA30=\"\",\"\",IF('Sizing Roll-up'!AA30>=$L$9,$L$10,IF('Sizing Roll-up'!AA30>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD30=\"\",\"\",IF('Sizing Roll-up'!AD30>=$M$9,$M$10,0))","v":""},{"$f":"IF(I21=\"\",\"\",(SUM(O21:U21)))","v":""},{"$f":"IF(I21=\"\",\"\",(SUM(M21:U21)))","v":""},null,{"$f":"IF(I21=\"\",\"\",(W21+X21))","v":""},{"$f":"IF('Sizing Roll-up'!Y30=\"\",\"\",'Sizing Roll-up'!Y30)","v":""},{"$f":"IF('Sizing Roll-up'!Z30=\"\",\"\",'Sizing Roll-up'!Z30)","v":""},{"$f":"IF('Sizing Roll-up'!AA30=\"\",\"\",'Sizing Roll-up'!AA30)","v":""}]
[10,{"$f":"IF('Sizing Roll-up'!B31=\"\",\"\",'Sizing Roll-up'!B31)","v":""},{"$f":"IF('Sizing Roll-up'!C31=\"\",\"\",'Sizing Roll-up'!C31)","v":""},{"$f":"IF('Sizing Roll-up'!D31=\"\",\"\",'Sizing Roll-up'!D31)","v":""},{"$f":"IF('Sizing Roll-up'!E31=\"\",\"\",'Sizing Roll-up'!E31)","v":""},{"$f":"IF('Sizing Roll-up'!F31=\"\",\"\",'Sizing Roll-up'!F31)","v":""},{"$f":"IF('Sizing Roll-up'!G31=\"\",\"\",'Sizing Roll-up'!G31)","v":""},{"$f":"IF('Sizing Roll-up'!H31=\"\",\"\",'Sizing Roll-up'!H31)","v":""},{"$f":"IF('Sizing Roll-up'!K31=\"\",\"\",'Sizing Roll-up'!K31)","v":""},{"$f":"IF('Sizing Roll-up'!B31=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I22=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I22=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I22=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N31=\"\",\"\",IF('Sizing Roll-up'!N31<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N31<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N31<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O31=\"\",\"\",IF('Sizing Roll-up'!O31>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O31>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O31>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I22=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I22=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I22=\"\",\"\",ROUNDUP((K22/0.01)*(INDEX(Premium[Adder],MATCH(J22,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA31=\"\",\"\",IF('Sizing Roll-up'!AA31>=$L$9,$L$10,IF('Sizing Roll-up'!AA31>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD31=\"\",\"\",IF('Sizing Roll-up'!AD31>=$M$9,$M$10,0))","v":""},"","",null,"",{"$f":"IF('Sizing Roll-up'!Y31=\"\",\"\",'Sizing Roll-up'!Y31)","v":""},{"$f":"IF('Sizing Roll-up'!Z31=\"\",\"\",'Sizing Roll-up'!Z31)","v":""},{"$f":"IF('Sizing Roll-up'!AA31=\"\",\"\",'Sizing Roll-up'!AA31)","v":""}]
[11,{"$f":"IF('Sizing Roll-up'!B32=\"\",\"\",'Sizing Roll-up'!B32)","v":""},{"$f":"IF('Sizing Roll-up'!C32=\"\",\"\",'Sizing Roll-up'!C32)","v":""},{"$f":"IF('Sizing Roll-up'!D32=\"\",\"\",'Sizing Roll-up'!D32)","v":""},{"$f":"IF('Sizing Roll-up'!E32=\"\",\"\",'Sizing Roll-up'!E32)","v":""},{"$f":"IF('Sizing Roll-up'!F32=\"\",\"\",'Sizing Roll-up'!F32)","v":""},{"$f":"IF('Sizing Roll-up'!G32=\"\",\"\",'Sizing Roll-up'!G32)","v":""},{"$f":"IF('Sizing Roll-up'!H32=\"\",\"\",'Sizing Roll-up'!H32)","v":""},{"$f":"IF('Sizing Roll-up'!K32=\"\",\"\",'Sizing Roll-up'!K32)","v":""},{"$f":"IF('Sizing Roll-up'!B32=\"\",\"\",'Pricing Roll-up'!$C$4)","v":""},null,{"$f":"IF(I23=\"\",\"\",'Sizing Roll-up'!$C$17)","v":""},{"$f":"IF(I23=\"\",\"\",'Sizing Roll-up'!$C$13)","v":""},{"$f":"IF(I23=\"\",\"\",'Sizing Roll-up'!$C$14)","v":""},{"$f":"IF('Sizing Roll-up'!N32=\"\",\"\",IF('Sizing Roll-up'!N32<='Pricing Roll-up'!$J$7,'Pricing Roll-up'!$K$7,IF('Sizing Roll-up'!N32<='Pricing Roll-up'!$J$6,'Pricing Roll-up'!$K$6,IF('Sizing Roll-up'!N32<='Pricing Roll-up'!$J$5,'Pricing Roll-up'!$K$5,0))))","v":""},{"$f":"IF('Sizing Roll-up'!O32=\"\",\"\",IF('Sizing Roll-up'!O32>='Pricing Roll-up'!$L$7,'Pricing Roll-up'!$M$7,IF('Sizing Roll-up'!O32>='Pricing Roll-up'!$L$6,'Pricing Roll-up'!$M$6,IF('Sizing Roll-up'!O32>='Pricing Roll-up'!$L$5,'Pricing Roll-up'!$M$5,0))))","v":""},{"$f":"IF(I23=\"\",\"\",'Sizing Roll-up'!$C$18)","v":""},{"$f":"IF(I23=\"\",\"\",'Sizing Roll-up'!$C$16)","v":""},{"$f":"IF(I23=\"\",\"\",ROUNDUP((K23/0.01)*(INDEX(Premium[Adder],MATCH(J23,Premium[[ ]],0))),4))","v":""},{"$f":"IF('Sizing Roll-up'!AA32=\"\",\"\",IF('Sizing Roll-up'!AA32>=$L$9,$L$10,IF('Sizing Roll-up'!AA32>=$K$9,$K$10,0)))","v":""},{"$f":"IF('Sizing Roll-up'!AD32=\"\",\"\",IF('Sizing Roll-up'!AD32>=$M$9,$M$10,0))","v":""},"","",null,{"$f":"IF(I23=\"\",\"\",(W23+X23))","v":""},{"$f":"IF('Sizing Roll-up'!Y32=\"\",\"\",'Sizing Roll-up'!Y32)","v":""},{"$f":"IF('Sizing Roll-up'!Z32=\"\",\"\",'Sizing Roll-up'!Z32)","v":""},{"$f":"IF('Sizing Roll-up'!AA32=\"\",\"\",'Sizing Roll-up'!AA32)","v":""}]
[null,"Total",{"$f":"COUNT(I13:I23)","v":0},null,null,null,{"$f":"SUM(G13:G23)","v":0},null,{"$f":"SUM(I13:I23)","v":0},null,{"$f":"IFERROR(AVERAGE(K13:K23),\"\")","v":""},null,{"$f":"IFERROR(SUMPRODUCT(M13:M23,$I$13:$I$23)/SUM($I$13:$I$23),\"\")","v":""},"","","","","","","","","","",{"$f":"IFERROR(SUMPRODUCT(X13:X23,I13:I23)/SUM(I13:I23),\"\")","v":""},{"$f":"IFERROR(SUMPRODUCT(Y13:Y23,$I$13:$I$23)/SUM($I$13:$I$23),\"\")","v":""},{"$f":"IFERROR(IF(AB24>=50%,\"Y\",\"N\"),\"\")","v":"N"},{"$f":"SUM(AA13:AA23)","v":0},{"$f":"IFERROR(AA24/G24,0)","v":0}]

{"sheet":"Sheet2","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Premium"]
[]
[" ","Adder"]
["5-Hybrid",2.5000000000000001E-3]
["7-Hybrid",2E-3]
["10-Hybrid",1.5E-3]
["5-Fixed",2.5000000000000001E-3,null,null,null,null,null,null,43983,44043,{"$f":"NETWORKDAYS(I7,J7)","v":45}]
["7-Fixed",2E-3]
["10-Fixed",1.5E-3]