{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Deal Builder","Internal Calc ","PDF Generator","New PDF","Resign Rules","Aggregated Data Rules","Bespoke SIM Only Rules","Conversion for PDF","Drop Downs","Lookups","Pricing"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":68,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Instructions "]
[]
["Please fill out the Mandatory boxes F3-F15."]
["Network Code will auto populate after a quantity is entered."]
[" "]

{"sheet":"Deal Builder","index":1,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,3,0,12],[16,3,16,5],[30,3,30,5],[14,3,14,4],[2,3,2,4],[4,3,4,4],[4,5,4,6],[6,3,6,4],[6,5,6,6],[2,5,2,6],[8,5,8,6],[10,5,10,6]]}
[null,null,null,"Zest4 Deal Calculator v4.2.3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(G21:G28,\"Sim Only Aggregated\")+COUNTIF(G21:G28,\"Mobile Broadband Aggregated\")","v":0}]
[]
[null,null,null,"CBM Name: ",null,"Choose.."]
[]
[null,null,null,"Customer Name:"]
[]
[null,null,null,"Partner Name:"]
[]
[null,null,null,null,"Partner Code:"]
[]
[null,null,null,null,"Deal Reference:"]
[]
[null,null,null,null,"Contract Length:","Choose.."]
[]
[null,null,null,"Date:"]
[" "]
[null,null,null,"Choose Your Tariff"]
[]
[]
[null,null,null,"Quantity ","Network ","CTN Type","Tariff Type","Tariff Decription ","Customer Buy Price Per Line Per Month","Total Customer Buy Price Per Month","Rev Share %","Rev Share Per Month","Rev Share Over Term"]
[null,null,null,0,{"$f":"IF(D21<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H21,Pricing!A:H,5,0),0)","v":0},{"$f":"I21*D21","v":0},{"$f":"IFERROR(VLOOKUP(H21,Pricing!A:G,7,0),0)","v":0},{"$f":"K21*J21","v":0},{"$f":"IFERROR(L21*$F$13,0)","v":0}]
[null,null,null,0,{"$f":"IF(D22<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H22,Pricing!A:H,5,0),0)","v":0},{"$f":"I22*D22","v":0},{"$f":"IFERROR(VLOOKUP(H22,Pricing!A:G,7,0),0)","v":0},{"$f":"K22*J22","v":0},0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H23,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H23,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H24,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H24,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H25,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H25,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H26,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H26,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H27,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H27,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H28,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H28,Pricing!A:G,7,0),0)","v":0},0,0]
[]
[]
[null,null,null,"Choose Your Bolt Ons "]
[]
[]
[null,null,null,"Quantity ","Network","CTN Type","Bolt On Type","Bolt On Description ","Customer Buy Price Per Line Per Month","Total Customer Buy Price Per Month","Rev Share %","Rev Share Per Month","Rev Share Over Term"]
[null,null,null,0,{"$f":"IF(D35<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H35,Pricing!A:H,5,0),0)","v":0},{"$f":"I35*D35","v":0},{"$f":"IFERROR(VLOOKUP(H35,Pricing!A:G,7,0),0)","v":0},{"$f":"K35*J35","v":0},{"$f":"IFERROR(L35*$F$13,0)","v":0}]
[null,null,null,0,{"$f":"IF(D36<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H36,Pricing!A:H,5,0),0)","v":0},{"$f":"I36*D36","v":0},{"$f":"IFERROR(VLOOKUP(H36,Pricing!A:G,7,0),0)","v":0},{"$f":"K36*J36","v":0},0]
[null,null,null,0,{"$f":"IF(D37<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H37,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H37,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H38,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H38,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H39,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H39,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H40,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H40,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H41,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H41,Pricing!A:G,7,0),0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H42,Pricing!A:H,5,0),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(H42,Pricing!A:G,7,0),0)","v":0},0,0]

{"sheet":"Internal Calc ","index":2,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,0,6,1],[7,0,7,1],[27,3,27,4],[28,3,28,4],[20,0,20,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[0,0,0,6],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[28,5,28,7],[8,0,8,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[10,0,10,1],[11,0,11,1],[12,0,12,1]]}
["Zest4 Deal Sheet"]
[]
["Partner name ",null,{"$f":"IF('Deal Builder'!F7=\"\",\"\",'Deal Builder'!F7)","v":""}]
["Partner Code",null,{"$f":"IF('Deal Builder'!F9=\"\",\"\",'Deal Builder'!F9)","v":""}]
["Customer name ",null,{"$f":"IF('Deal Builder'!F5=\"\",\"\",'Deal Builder'!F5)","v":""}]
["Total Connections",null,{"$f":"IF(SUM('Deal Builder'!D21:D28)=0,\"\",SUM('Deal Builder'!D21:D28))","v":""}]
["Your Deal Reference",null,{"$f":"IF('Deal Builder'!F11=\"\",\"\",'Deal Builder'!F11)","v":""}]
["Estimated Customer Monthly Billing",null,{"$f":"F28","v":0}]
["Estimated Revenue Share over term",null,{"$f":"IFERROR(I28,0)","v":0}]
[]
["Zygo billed rentals",null,"Tariff","Quantity","Customer Buy Price Per Line Per Month","Total Customer Buy Price Per Month","Monthly Rev Share Per Line","Total Monthly Rev Share","Estimated Revenue Share Over Term"]
["Tariff",null,{"$f":"IF('Deal Builder'!H21 =\"Choose..\",\"\",'Deal Builder'!H21)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D21)","v":0},{"$f":"'Deal Builder'!I21","v":0},{"$f":"'Deal Builder'!J21","v":0},{"$f":"'Deal Builder'!L21","v":0},{"$f":"G12*D12","v":0},{"$f":"IFERROR(H12*'Deal Builder'!$F$13,0)","v":0},{"$f":"IFERROR(IF(FIND(\"AGG\",C12)>0,\"£1 per unit operation charge added to buy price\",\"\"),\"\")","v":""}]
["Tariff",null,{"$f":"IF('Deal Builder'!H22 =\"Choose..\",\"\",'Deal Builder'!H22)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D22)","v":0},{"$f":"'Deal Builder'!I22","v":0},{"$f":"'Deal Builder'!J22","v":0},{"$f":"'Deal Builder'!L22","v":0},{"$f":"G13*D13","v":0},{"$f":"IFERROR(H13*'Deal Builder'!$F$13,0)","v":0},""]
["Tariff",null,{"$f":"IF('Deal Builder'!H23 =\"Choose..\",\"\",'Deal Builder'!H23)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D23)","v":0},{"$f":"'Deal Builder'!I23","v":0},{"$f":"'Deal Builder'!J23","v":0},{"$f":"'Deal Builder'!L23","v":0},0,{"$f":"IFERROR(H14*'Deal Builder'!$F$13,0)","v":0},""]
["Tariff",null,{"$f":"IF('Deal Builder'!H24 =\"Choose..\",\"\",'Deal Builder'!H24)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D24)","v":0},{"$f":"'Deal Builder'!I24","v":0},{"$f":"'Deal Builder'!J24","v":0},{"$f":"'Deal Builder'!L24","v":0},0,{"$f":"IFERROR(H15*'Deal Builder'!$F$13,0)","v":0},""]
["Tariff",null,{"$f":"IF('Deal Builder'!H25 =\"Choose..\",\"\",'Deal Builder'!H25)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D25)","v":0},{"$f":"'Deal Builder'!I25","v":0},{"$f":"'Deal Builder'!J25","v":0},{"$f":"'Deal Builder'!L25","v":0},0,{"$f":"IFERROR(H16*'Deal Builder'!$F$13,0)","v":0},""]
["Tariff",null,{"$f":"IF('Deal Builder'!H26 =\"Choose..\",\"\",'Deal Builder'!H26)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D26)","v":0},{"$f":"'Deal Builder'!I26","v":0},{"$f":"'Deal Builder'!J26","v":0},{"$f":"'Deal Builder'!L26","v":0},0,{"$f":"IFERROR(H17*'Deal Builder'!$F$13,0)","v":0},""]
["Tariff",null,{"$f":"IF('Deal Builder'!H27 =\"Choose..\",\"\",'Deal Builder'!H27)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D27)","v":0},{"$f":"'Deal Builder'!I27","v":0},{"$f":"'Deal Builder'!J27","v":0},{"$f":"'Deal Builder'!L27","v":0},0,{"$f":"IFERROR(H18*'Deal Builder'!$F$13,0)","v":0},""]
["Tariff",null,{"$f":"IF('Deal Builder'!H28 =\"Choose..\",\"\",'Deal Builder'!H28)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D28)","v":0},{"$f":"'Deal Builder'!I28","v":0},{"$f":"'Deal Builder'!J28","v":0},{"$f":"'Deal Builder'!L28","v":0},0,{"$f":"IFERROR(H19*'Deal Builder'!$F$13,0)","v":0},""]
["Bolt On",null,{"$f":"IF('Deal Builder'!H35=\"Choose..\",\"\",'Deal Builder'!H35)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D35)","v":0},{"$f":"'Deal Builder'!I35","v":0},{"$f":"'Deal Builder'!J35","v":0},{"$f":"'Deal Builder'!L35","v":0},0,{"$f":"IFERROR(H20*'Deal Builder'!$F$13,0)","v":0}]
["Bolt On",null,{"$f":"IF('Deal Builder'!H36=\"Choose..\",\"\",'Deal Builder'!H36)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D36)","v":0},{"$f":"'Deal Builder'!I36","v":0},{"$f":"'Deal Builder'!J36","v":0},{"$f":"'Deal Builder'!L36","v":0},0,{"$f":"IFERROR(H21*'Deal Builder'!$F$13,0)","v":0}]
["Bolt On",null,{"$f":"IF('Deal Builder'!H37=\"Choose..\",\"\",'Deal Builder'!H37)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D37)","v":0},{"$f":"'Deal Builder'!I37","v":0},{"$f":"'Deal Builder'!J37","v":0},{"$f":"'Deal Builder'!L37","v":0},0,{"$f":"IFERROR(H22*'Deal Builder'!$F$13,0)","v":0}]
["Bolt On",null,{"$f":"IF('Deal Builder'!H38=\"Choose..\",\"\",'Deal Builder'!H38)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D38)","v":0},{"$f":"'Deal Builder'!I38","v":0},{"$f":"'Deal Builder'!J38","v":0},{"$f":"'Deal Builder'!L38","v":0},0,{"$f":"IFERROR(H23*'Deal Builder'!$F$13,0)","v":0}]
["Bolt On",null,{"$f":"IF('Deal Builder'!H39=\"Choose..\",\"\",'Deal Builder'!H39)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D39)","v":0},{"$f":"'Deal Builder'!I39","v":0},{"$f":"'Deal Builder'!J39","v":0},{"$f":"'Deal Builder'!L39","v":0},0,{"$f":"IFERROR(H24*'Deal Builder'!$F$13,0)","v":0}]
["Bolt On",null,{"$f":"IF('Deal Builder'!H40=\"Choose..\",\"\",'Deal Builder'!H40)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D40)","v":0},{"$f":"'Deal Builder'!I40","v":0},{"$f":"'Deal Builder'!J40","v":0},{"$f":"'Deal Builder'!L40","v":0},0,{"$f":"IFERROR(H25*'Deal Builder'!$F$13,0)","v":0}]
["Bolt On",null,{"$f":"IF('Deal Builder'!H41=\"Choose..\",\"\",'Deal Builder'!H41)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D41)","v":0},{"$f":"'Deal Builder'!I41","v":0},{"$f":"'Deal Builder'!J41","v":0},{"$f":"'Deal Builder'!L41","v":0},0,{"$f":"IFERROR(H26*'Deal Builder'!$F$13,0)","v":0}]
["Bolt On",null,{"$f":"IF('Deal Builder'!H42=\"Choose..\",\"\",'Deal Builder'!H42)","v":""},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D42)","v":0},{"$f":"'Deal Builder'!I42","v":0},{"$f":"'Deal Builder'!J42","v":0},{"$f":"'Deal Builder'!L42","v":0},0,{"$f":"IFERROR(H27*'Deal Builder'!$F$13,0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F12:F27)","v":0},{"$f":"SUM(G12:G27)","v":0},{"$f":"SUM(H12:H27)","v":0},{"$f":"SUM(I12:I27)","v":0}]
[null,null,null,null,null,"Estimated Revenue Share Per Connection",null,null,{"$f":"IFERROR(I28/C6,0)","v":0}]

{"sheet":"PDF Generator","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
["Partner name ",{"$f":"'Internal Calc '!C3","v":""}]
["Partner Code",{"$f":"'Internal Calc '!C4","v":""}]
["Customer name ",{"$f":"'Internal Calc '!C5","v":""}]
["Total Voice Connections",{"$f":"'Internal Calc '!C6","v":""}]
["Your Deal Reference",{"$f":"'Internal Calc '!C7","v":""}]
["Estimated Customer Monthly Billing (Excluding Usage)",{"$f":"SUM(C12:C27)","v":0}]
["Bonuses on Month One",{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}}]
["Estimated Revenue Share over term",{"$f":"'Internal Calc '!C9","v":0}]
[]
[{"$f":"'Internal Calc '!C11","v":"Tariff"},{"$f":"'Internal Calc '!D11","v":"Quantity"},{"$f":"'Internal Calc '!F11","v":"Total Customer Buy Price Per Month"},"Monthly Rev Share Per Line ","Standard Funding ","Discretionary Funding","Monthly Margin"]
[{"$f":"'Internal Calc '!C12","v":""},{"$f":"IF('Internal Calc '!D12=0,\"\",'Internal Calc '!D12)","v":""},{"$f":"IF('Internal Calc '!F12=0,\"\",'Internal Calc '!F12)","v":""},{"$f":"IF('Internal Calc '!D12=0,\"\",'Internal Calc '!G12*B12)","v":""},{"$f":"IF('Internal Calc '!D12=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D12=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D12=0,\"\",IFERROR(C12-('Internal Calc '!E12*'Internal Calc '!D12)+D12,0))","v":""}]
[{"$f":"'Internal Calc '!C13","v":""},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!D13)","v":""},{"$f":"IF('Internal Calc '!F13=0,\"\",'Internal Calc '!F13)","v":""},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!G13*B13)","v":""},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D13=0,\"\",IFERROR(C13-('Internal Calc '!E13*'Internal Calc '!D13)+D13,0))","v":""}]
[{"$f":"'Internal Calc '!C14","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!D14)","v":""},{"$f":"IF('Internal Calc '!F14=0,\"\",'Internal Calc '!F14)","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!G14*B14)","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",IFERROR(C14-('Internal Calc '!E14*'Internal Calc '!D14)+D14,0))","v":""}]
[{"$f":"'Internal Calc '!C15","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!D15)","v":""},{"$f":"IF('Internal Calc '!F15=0,\"\",'Internal Calc '!F15)","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!G15*B15)","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",IFERROR(C15-('Internal Calc '!E15*'Internal Calc '!D15)+D15,0))","v":""}]
[{"$f":"'Internal Calc '!C16","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!D16)","v":""},{"$f":"IF('Internal Calc '!F16=0,\"\",'Internal Calc '!F16)","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!G16*B16)","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",IFERROR(C16-('Internal Calc '!E16*'Internal Calc '!D16)+D16,0))","v":""}]
[{"$f":"'Internal Calc '!C17","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!D17)","v":""},{"$f":"IF('Internal Calc '!F17=0,\"\",'Internal Calc '!F17)","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!G17*B17)","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",IFERROR(C17-('Internal Calc '!E17*'Internal Calc '!D17)+D17,0))","v":""}]
[{"$f":"'Internal Calc '!C18","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!D18)","v":""},{"$f":"IF('Internal Calc '!F18=0,\"\",'Internal Calc '!F18)","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!G18*B18)","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",IFERROR(C18-('Internal Calc '!E18*'Internal Calc '!D18)+D18,0))","v":""}]
[{"$f":"'Internal Calc '!C19","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!D19)","v":""},{"$f":"IF('Internal Calc '!F19=0,\"\",'Internal Calc '!F19)","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!G19*B19)","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",IFERROR(C19-('Internal Calc '!E19*'Internal Calc '!D19)+D19,0))","v":""}]
[{"$f":"'Internal Calc '!C20","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!D20)","v":""},{"$f":"IF('Internal Calc '!F20=0,\"\",'Internal Calc '!F20)","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!G20*B20)","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",IFERROR(C20-('Internal Calc '!E20*'Internal Calc '!D20)+D20,0))","v":""}]
[{"$f":"'Internal Calc '!C21","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!D21)","v":""},{"$f":"IF('Internal Calc '!F21=0,\"\",'Internal Calc '!F21)","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!G21*B21)","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",IFERROR(C21-('Internal Calc '!E21*'Internal Calc '!D21)+D21,0))","v":""}]
[{"$f":"'Internal Calc '!C22","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!D22)","v":""},{"$f":"IF('Internal Calc '!F22=0,\"\",'Internal Calc '!F22)","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!G22*B22)","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",IFERROR(C22-('Internal Calc '!E22*'Internal Calc '!D22)+D22,0))","v":""}]
[{"$f":"'Internal Calc '!C23","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!D23)","v":""},{"$f":"IF('Internal Calc '!F23=0,\"\",'Internal Calc '!F23)","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!G23*B23)","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",IFERROR(C23-('Internal Calc '!E23*'Internal Calc '!D23)+D23,0))","v":""}]
[{"$f":"'Internal Calc '!C24","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!D24)","v":""},{"$f":"IF('Internal Calc '!F24=0,\"\",'Internal Calc '!F24)","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!G24*B24)","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",IFERROR(C24-('Internal Calc '!E24*'Internal Calc '!D24)+D24,0))","v":""}]
[{"$f":"'Internal Calc '!C25","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!D25)","v":""},{"$f":"IF('Internal Calc '!F25=0,\"\",'Internal Calc '!F25)","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!G25*B25)","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",IFERROR(C25-('Internal Calc '!E25*'Internal Calc '!D25)+D25,0))","v":""}]
[{"$f":"'Internal Calc '!C26","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!D26)","v":""},{"$f":"IF('Internal Calc '!F26=0,\"\",'Internal Calc '!F26)","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!G26*B26)","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",IFERROR(C26-('Internal Calc '!E26*'Internal Calc '!D26)+D26,0))","v":""}]
[{"$f":"'Internal Calc '!C27","v":""},{"$f":"IF('Internal Calc '!D27=0,\"\",'Internal Calc '!D27)","v":""},{"$f":"IF('Internal Calc '!F27=0,\"\",'Internal Calc '!F27)","v":""},{"$f":"IF('Internal Calc '!D27=0,\"\",'Internal Calc '!G27*B27)","v":""},{"$f":"IF('Internal Calc '!D27=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D27=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D27=0,\"\",IFERROR(C27-('Internal Calc '!E27*'Internal Calc '!D27)+D27,0))","v":""}]

{"sheet":"New PDF","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,0,5,7],[31,0,31,7],[29,0,30,7]]}
[]
[]
[]
[]
[]
[{"$f":"\"Deal Summary For: \"&'Deal Builder'!F5","v":"Deal Summary For: "}]
[]
[{"$f":"\"Contract Term: \"&'Deal Builder'!F13&IF('Deal Builder'!F13=1,\" Month\",\" Months\")","v":"Contract Term: Choose.. Months"},null,null,null,null,null,"Zest4 Reference","ZES4064"]
[]
[{"$f":"'Conversion for PDF'!N1","v":"Tariff"},{"$f":"'Conversion for PDF'!P1","v":"Rental Per User"},{"$f":"'Conversion for PDF'!Q1","v":"Qty"},{"$f":"'Conversion for PDF'!R1","v":"Total Cost per Month"}]
[{"$f":"'Conversion for PDF'!N2","v":"Grand Total"},{"$f":"IF(OR($A11=\"Tariff Sub Total\",$A11=\"Bolt On Sub Total\",$A11=\"Grand Total\",$A11=\"Bolt Ons\"),\"\",'Conversion for PDF'!P2)","v":""},{"$f":"IF($A11=\"Bolt Ons\",\"\",'Conversion for PDF'!Q2)","v":0},{"$f":"IF($A11=\"Bolt Ons\",\"\",'Conversion for PDF'!R2)","v":0}]
[{"$f":"'Conversion for PDF'!N3","v":""},{"$f":"IF(OR($A12=\"Tariff Sub Total\",$A12=\"Bolt On Sub Total\",$A12=\"Grand Total\",$A12=\"Bolt Ons\"),\"\",'Conversion for PDF'!P3)","v":""},{"$f":"IF($A12=\"Bolt Ons\",\"\",'Conversion for PDF'!Q3)","v":""},{"$f":"IF($A12=\"Bolt Ons\",\"\",'Conversion for PDF'!R3)","v":""}]
[{"$f":"'Conversion for PDF'!N4","v":""},{"$f":"IF(OR($A13=\"Tariff Sub Total\",$A13=\"Bolt On Sub Total\",$A13=\"Grand Total\",$A13=\"Bolt Ons\"),\"\",'Conversion for PDF'!P4)","v":""},{"$f":"IF($A13=\"Bolt Ons\",\"\",'Conversion for PDF'!Q4)","v":""},{"$f":"IF($A13=\"Bolt Ons\",\"\",'Conversion for PDF'!R4)","v":""}]
[{"$f":"'Conversion for PDF'!N5","v":""},{"$f":"IF(OR($A14=\"Tariff Sub Total\",$A14=\"Bolt On Sub Total\",$A14=\"Grand Total\",$A14=\"Bolt Ons\"),\"\",'Conversion for PDF'!P5)","v":""},{"$f":"IF($A14=\"Bolt Ons\",\"\",'Conversion for PDF'!Q5)","v":""},{"$f":"IF($A14=\"Bolt Ons\",\"\",'Conversion for PDF'!R5)","v":""}]
[{"$f":"'Conversion for PDF'!N6","v":""},{"$f":"IF(OR($A15=\"Tariff Sub Total\",$A15=\"Bolt On Sub Total\",$A15=\"Grand Total\",$A15=\"Bolt Ons\"),\"\",'Conversion for PDF'!P6)","v":""},{"$f":"IF($A15=\"Bolt Ons\",\"\",'Conversion for PDF'!Q6)","v":""},{"$f":"IF($A15=\"Bolt Ons\",\"\",'Conversion for PDF'!R6)","v":""}]
[{"$f":"'Conversion for PDF'!N7","v":""},{"$f":"IF(OR($A16=\"Tariff Sub Total\",$A16=\"Bolt On Sub Total\",$A16=\"Grand Total\",$A16=\"Bolt Ons\"),\"\",'Conversion for PDF'!P7)","v":""},{"$f":"IF($A16=\"Bolt Ons\",\"\",'Conversion for PDF'!Q7)","v":""},{"$f":"IF($A16=\"Bolt Ons\",\"\",'Conversion for PDF'!R7)","v":""}]
[{"$f":"'Conversion for PDF'!N8","v":""},{"$f":"IF(OR($A17=\"Tariff Sub Total\",$A17=\"Bolt On Sub Total\",$A17=\"Grand Total\",$A17=\"Bolt Ons\"),\"\",'Conversion for PDF'!P8)","v":""},{"$f":"IF($A17=\"Bolt Ons\",\"\",'Conversion for PDF'!Q8)","v":""},{"$f":"IF($A17=\"Bolt Ons\",\"\",'Conversion for PDF'!R8)","v":""}]
[{"$f":"'Conversion for PDF'!N9","v":""},{"$f":"IF(OR($A18=\"Tariff Sub Total\",$A18=\"Bolt On Sub Total\",$A18=\"Grand Total\",$A18=\"Bolt Ons\"),\"\",'Conversion for PDF'!P9)","v":""},{"$f":"IF($A18=\"Bolt Ons\",\"\",'Conversion for PDF'!Q9)","v":""},{"$f":"IF($A18=\"Bolt Ons\",\"\",'Conversion for PDF'!R9)","v":""}]
[{"$f":"'Conversion for PDF'!N10","v":""},{"$f":"IF(OR($A19=\"Tariff Sub Total\",$A19=\"Bolt On Sub Total\",$A19=\"Grand Total\",$A19=\"Bolt Ons\"),\"\",'Conversion for PDF'!P10)","v":""},{"$f":"IF($A19=\"Bolt Ons\",\"\",'Conversion for PDF'!Q10)","v":""},{"$f":"IF($A19=\"Bolt Ons\",\"\",'Conversion for PDF'!R10)","v":""}]
[{"$f":"'Conversion for PDF'!N11","v":""},{"$f":"IF(OR($A20=\"Tariff Sub Total\",$A20=\"Bolt On Sub Total\",$A20=\"Grand Total\",$A20=\"Bolt Ons\"),\"\",'Conversion for PDF'!P11)","v":""},{"$f":"IF($A20=\"Bolt Ons\",\"\",'Conversion for PDF'!Q11)","v":""},{"$f":"IF($A20=\"Bolt Ons\",\"\",'Conversion for PDF'!R11)","v":""}]
[{"$f":"'Conversion for PDF'!N12","v":""},{"$f":"IF(OR($A21=\"Tariff Sub Total\",$A21=\"Bolt On Sub Total\",$A21=\"Grand Total\",$A21=\"Bolt Ons\"),\"\",'Conversion for PDF'!P12)","v":""},{"$f":"IF($A21=\"Bolt Ons\",\"\",'Conversion for PDF'!Q12)","v":""},{"$f":"IF($A21=\"Bolt Ons\",\"\",'Conversion for PDF'!R12)","v":""}]
[{"$f":"'Conversion for PDF'!N13","v":""},{"$f":"IF(OR($A22=\"Tariff Sub Total\",$A22=\"Bolt On Sub Total\",$A22=\"Grand Total\",$A22=\"Bolt Ons\"),\"\",'Conversion for PDF'!P13)","v":""},{"$f":"IF($A22=\"Bolt Ons\",\"\",'Conversion for PDF'!Q13)","v":""},{"$f":"IF($A22=\"Bolt Ons\",\"\",'Conversion for PDF'!R13)","v":""}]
[{"$f":"'Conversion for PDF'!N14","v":""},{"$f":"IF(OR($A23=\"Tariff Sub Total\",$A23=\"Bolt On Sub Total\",$A23=\"Grand Total\",$A23=\"Bolt Ons\"),\"\",'Conversion for PDF'!P14)","v":""},{"$f":"IF($A23=\"Bolt Ons\",\"\",'Conversion for PDF'!Q14)","v":""},{"$f":"IF($A23=\"Bolt Ons\",\"\",'Conversion for PDF'!R14)","v":""}]
[{"$f":"'Conversion for PDF'!N15","v":""},{"$f":"IF(OR($A24=\"Tariff Sub Total\",$A24=\"Bolt On Sub Total\",$A24=\"Grand Total\",$A24=\"Bolt Ons\"),\"\",'Conversion for PDF'!P15)","v":""},{"$f":"IF($A24=\"Bolt Ons\",\"\",'Conversion for PDF'!Q15)","v":""},{"$f":"IF($A24=\"Bolt Ons\",\"\",'Conversion for PDF'!R15)","v":""}]
[{"$f":"'Conversion for PDF'!N16","v":""},{"$f":"IF(OR($A25=\"Tariff Sub Total\",$A25=\"Bolt On Sub Total\",$A25=\"Grand Total\",$A25=\"Bolt Ons\"),\"\",'Conversion for PDF'!P16)","v":""},{"$f":"IF($A25=\"Bolt Ons\",\"\",'Conversion for PDF'!Q16)","v":""},{"$f":"IF($A25=\"Bolt Ons\",\"\",'Conversion for PDF'!R16)","v":""}]
[{"$f":"'Conversion for PDF'!N17","v":""},{"$f":"IF(OR($A26=\"Tariff Sub Total\",$A26=\"Bolt On Sub Total\",$A26=\"Grand Total\",$A26=\"Bolt Ons\"),\"\",'Conversion for PDF'!P17)","v":""},{"$f":"IF($A26=\"Bolt Ons\",\"\",'Conversion for PDF'!Q17)","v":""},{"$f":"IF($A26=\"Bolt Ons\",\"\",'Conversion for PDF'!R17)","v":""}]
[{"$f":"'Conversion for PDF'!N18","v":""},{"$f":"IF(OR($A27=\"Tariff Sub Total\",$A27=\"Bolt On Sub Total\",$A27=\"Grand Total\",$A27=\"Bolt Ons\"),\"\",'Conversion for PDF'!P18)","v":""},{"$f":"IF($A27=\"Bolt Ons\",\"\",'Conversion for PDF'!Q18)","v":""},{"$f":"IF($A27=\"Bolt Ons\",\"\",'Conversion for PDF'!R18)","v":""}]
[{"$f":"'Conversion for PDF'!N19","v":""},{"$f":"IF(OR($A28=\"Tariff Sub Total\",$A28=\"Bolt On Sub Total\",$A28=\"Grand Total\",$A28=\"Bolt Ons\"),\"\",'Conversion for PDF'!P19)","v":""},{"$f":"IF($A28=\"Bolt Ons\",\"\",'Conversion for PDF'!Q19)","v":""},{"$f":"IF($A28=\"Bolt Ons\",\"\",'Conversion for PDF'!R19)","v":""}]
[{"$f":"'Conversion for PDF'!N20","v":""},{"$f":"IF(OR($A29=\"Tariff Sub Total\",$A29=\"Bolt On Sub Total\",$A29=\"Grand Total\",$A29=\"Bolt Ons\"),\"\",'Conversion for PDF'!P20)","v":""},{"$f":"IF($A29=\"Bolt Ons\",\"\",'Conversion for PDF'!Q20)","v":""},{"$f":"IF($A29=\"Bolt Ons\",\"\",'Conversion for PDF'!R20)","v":""}]

{"sheet":"Resign Rules","index":5,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Update MF 10/01/18"]
["I think there has been some confusion on rules around migrating to the new SIM only O2 plans – please see below the rules that need to be applied:"]
["1)      They must have served their initial contract term on either standard 24 month plans or current Sim only 30 day plans and pay a £30 migration fee. (No resign required)"]
["2)      If they wish to resign then they can move to one of the new plans ( standard early resign rules apply) and no migration fee is chargeable if they resign for a new term of 24 months (last 3 months of contract, 24 month extension)"]
["3)      If they wish to move from a current SIM only 24 month plan – they can migrate to a new SIM only 24 Month tariff if they pay the £30 migration fee.  If this is a large increase in revenue (Needs to be linked to O2 RRP not price we charge) the mig fee may be waived."]
["4)      If they want to move from a current bespoke tariff commercial approval is required."]
[]
["Resign Rules – ABS – February 2018"]
[]
["As we have now moved to ABS and are now allowing partners to access Wholesale rates, we need to put some rules around moving their existing base from RRP to Wholesale to protect our initial investment and expected revenue.  The various resign scenario’s and associated rules are outlined below:"]
[]
["Resigns moving from a RRP 24 Month Agreement to a 30 Day SIM Only Plan"]
["Partners can resign to a SIMO 30 Day plan 3 months before the end of the existing contract"]
["The number when resigned has the remainder of the existing contract still to serve and then has to give 30 days’ notice from that point."]
["If the number is out of contract, it is free to move to a 30 day SIM Only plan."]
[]
["Resigns moving from a RRP 24 Month Agreement to a 24 Month SIM Only Plan"]
["Partners can resign to a SIMO 24 Month plan 3 months before the end of the existing contract"]
["The number when resigned has the remainder of the existing contract still to serve and then has to give 30 days’ notice from that point."]
["If the number is out of contract, it is free to move to a 24 Month SIM Only plan."]
[]
["Resigns moving from an RRP 24 Month Agreement to a 24 Month Wholesale Tariff (not SIMO)"]
["Partners can resign numbers on RRP tariffs to the 24 Month Wholesale (not SIMO) tariffs 6 months early."]
["This gives partners an additional 10% in rentals as on existing base they get a 10% discount and on the new tariffs they get 50% discount."]
["We are comfortable with this as they are locking the customer back in for an additional 24 months."]
[]
["Resigns where a bespoke tariff is being created"]
["Commercial will review the proposed tariff and the timing left on the existing contract before proposing a resign plan."]
[]
["Update on moving to new June 2018 Tariffs – Mandy email Tuesday 10th"]
[]
["I think there has been some confusion on rules around migrating to the new SIM only O2 plans – please see below the rules that need to be applied:"]
[]
["5)      They must have served their initial contract term on either standard 24 month plans or current Sim only 30 day plans and pay a £30 migration fee. (No resign required)"]
["6)      If they wish to resign then they can move to one of the new plans ( standard early resign rules apply) and no migration fee is chargeable if they resign for a new term of 24 months (last 3 months of contract, 24 month extension)"]
["7)      If they wish to move from a current SIM only 24 month plan – they can migrate to a new SIM only 24 Month tariff if they pay the £30 migration fee.  If this is a large increase in revenue (Needs to be linked to O2 RRP not price we charge) the mig fee may be waived."]
["8)      If they want to move from a current bespoke tariff commercial approval is required."]

{"sheet":"Aggregated Data Rules","index":6,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Aggregating Small Biz Sim Only Tariffs to avoid bill shock."]
["To give you the ability to compete with other offerings in the market we want to make available the option to build bespoke deals around using small biz tariffs and stacking them to create shared data bundles."]
["This is not a simple offering in the background and it presents some operational and commercial challenges.  We therefore need to have rules in place as to where and how this is offered and a clear process to ensure it is delivered to the customer/reseller correctly and declared to O2 correctly."]
["The rules are outlined below:"]
["1)      You need to get commercial sign off for each stackable shared biz opportunity"]
["2)      We will only offer this tariff for 50 users or over (amended to 20)"]
["3)      All users must be on the same small biz tariff – there are no mix and match options available e.g. all users on Small Biz 2GB"]
["4)      These tariffs are available for new / mig only"]
["5)      It is expected that these will be sold on a 24 month term"]
["6)      Each user is charged £2 RRP, £1 Reseller rate extra on top of the tariff base price per month for sharing the data.  This extra £2/1 rental is not counted towards GP as it is to cover the additional data declarations we may need to declare to O2 if an individual user goes over their data allowance"]
["7)      No top ups are available on these tariffs.  Once the shared bundle has been utilised, the group is charged overage. They can tariff migrate up a tariff but the whole group would need to tariff migrate up."]
["8)      A new tariff needs to be built each time for each individual group so we need a key identifier from the reseller to identify the group – e.g. company name to tag the group users together"]
["9)      We will allow up to 25% organic growth to a group and this will be part of the quotation terms.  This is to prevent resellers creating a big group of multiple customers all maxing out the data – this sill not be commercially viable for us."]
["10)   A quotation will be issued from the commercial team upon approval of the deal, this must be issued to the reseller as the basis of the bespoke tariff so that they understand the terms when they place an order."]
[]
["The Process – 4-5 working days"]
["1)      Submit a bespoke tariff request to the commercial team (this carries a 1-2 day SLA)"]
["2)      The commercial team on approval will issue you with a quote which you should send to your partner."]
["3)      As this is a bespoke tariff the partner needs to give you notice of when they wish to connect the deal."]
["4)      Once you get notice from the partner, submit the bespoke tariff request into the billing team and they will build the tariff within 2 days, make the tariff available on the portal and let you know the code for the tariff for this group."]
["5)      You let the partner know that the tariff is available and the group tariff code they need to select on the portal"]
["6)      Partner places the order and everyone knows what’s happening,"]
["Happy days!"]

{"sheet":"Bespoke SIM Only Rules","index":7,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["O2 Bespoke SIM Only Deals – Dealer / In house model only"]
["To enable you to offer different increments of data and benefit from the lower buy rates of SIM Only plans to stack non- SIM Only deals for dealer / in house customers only the below rules will apply unless a standard tariff is selected."]
["All the below individually incur a £10 GP reduction. These GP reductions are stacked, SAQ funding will not be offered to negate these deductions and bring a deal back to standard margins."]
["·         If a tariff build is required for less than an initial 20 ctns contract."]
["·         If you offer more than £20 funding / hardware / credit on account on a SIMO plan."]
["·         If you bespoke a migration above 20 ctns that hasn’t been approved by O2."]
["·         If you offer up front Revenue Share, with less than £120 per connection GP."]
["·         If you offer more than 40% Revenue Share on rental or usage on a funded SIMO tariff."]
["·         If you offer less than a 24-month term."]
["These rules reflect that Zest4 wants to offer flexibility and target resource including capital in growing and securing its base, while hitting its obligations under its contract with O2 Telefonica."]
["Additional criteria"]
["All deals sold must be stacked on the same tariff (Mins / Texts / Data) allowance or better being purchased from the network regardless of customer usage profile."]
["All deals should still meet minimum GP requirement of £100 per connection over 24 months."]
["All deals require commercial approval in principle in advance of tariff build being submitted."]
["All Bespoke Tariffs where funding is paid not to be named as SIM Only on customer sold tariff version. Tariff builds may be required even if a price point already exists to ensure correct usage charges are associated and revenue share % (Profit %)."]
["No standard bonuses available."]

{"sheet":"Conversion for PDF","index":8,"n_rows":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Tariff","Ctn. Type","Rental Per User","Qty","Total Cost per Month","Monthly Revenue Share","Standard Funding","Discretionary Funding","Revenue Share Over Term","Total Commission Over Term","Rev. Share on Tariff","Rev. Share on Std. Usage",null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A1))),\"\")","v":"Tariff"},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B1))),\"\")","v":"Ctn. Type"},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C1))),\"\")","v":"Rental Per User"},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D1))),\"\")","v":"Qty"},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E1))),\"\")","v":"Total Cost per Month"},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F1))),\"\")","v":"Monthly Revenue Share"},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G1))),\"\")","v":"Standard Funding"},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H1))),\"\")","v":"Discretionary Funding"},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I1))),\"\")","v":"Revenue Share Over Term"},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J1))),\"\")","v":"Total Commission Over Term"},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K1))),\"\")","v":"Rev. Share on Tariff"},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L1))),\"\")","v":"Rev. Share on Std. Usage"}]
[{"$f":"'Internal Calc '!C12","v":""},{"$f":"'Deal Builder'!F21","v":"Choose.."},{"$f":"'Internal Calc '!E12","v":0},{"$f":"'Internal Calc '!D12","v":0},{"$f":"'Internal Calc '!F12","v":0},{"$f":"'Internal Calc '!G12","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F2*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G12*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K21:K21)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A2))),\"\")","v":"Grand Total"},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B2))),\"\")","v":0},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C2))),\"\")","v":0},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D2))),\"\")","v":0},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E2))),\"\")","v":0},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F2))),\"\")","v":0},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G2))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H2))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I2))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J2))),\"\")","v":0},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K2))),\"\")","v":0},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L2))),\"\")","v":0}]
[{"$f":"'Internal Calc '!C13","v":""},{"$f":"'Deal Builder'!F22","v":"Choose.."},{"$f":"'Internal Calc '!E13","v":0},{"$f":"'Internal Calc '!D13","v":0},{"$f":"'Internal Calc '!F13","v":0},{"$f":"'Internal Calc '!G13","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F3*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G13*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K22:K22)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A3))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B3))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C3))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D3))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E3))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F3))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G3))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H3))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I3))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J3))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K3))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L3))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C14","v":""},{"$f":"'Deal Builder'!F23","v":"Choose.."},{"$f":"'Internal Calc '!E14","v":0},{"$f":"'Internal Calc '!D14","v":0},{"$f":"'Internal Calc '!F14","v":0},{"$f":"'Internal Calc '!G14","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F4*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G14*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K23:K23)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A4))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B4))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C4))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D4))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E4))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F4))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G4))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H4))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I4))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J4))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K4))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L4))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C15","v":""},{"$f":"'Deal Builder'!F24","v":"Choose.."},{"$f":"'Internal Calc '!E15","v":0},{"$f":"'Internal Calc '!D15","v":0},{"$f":"'Internal Calc '!F15","v":0},{"$f":"'Internal Calc '!G15","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F5*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G15*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K24:K24)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B5))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C5))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D5))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E5))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F5))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G5))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H5))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I5))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J5))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K5))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L5))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C16","v":""},{"$f":"'Deal Builder'!F25","v":"Choose.."},{"$f":"'Internal Calc '!E16","v":0},{"$f":"'Internal Calc '!D16","v":0},{"$f":"'Internal Calc '!F16","v":0},{"$f":"'Internal Calc '!G16","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F6*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G16*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K25:K25)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B6))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C6))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D6))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E6))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F6))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G6))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H6))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I6))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J6))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K6))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L6))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C17","v":""},{"$f":"'Deal Builder'!F26","v":"Choose.."},{"$f":"'Internal Calc '!E17","v":0},{"$f":"'Internal Calc '!D17","v":0},{"$f":"'Internal Calc '!F17","v":0},{"$f":"'Internal Calc '!G17","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F7*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G17*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K26:K26)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B7))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C7))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D7))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E7))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F7))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G7))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H7))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I7))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J7))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K7))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L7))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C18","v":""},{"$f":"'Deal Builder'!F27","v":"Choose.."},{"$f":"'Internal Calc '!E18","v":0},{"$f":"'Internal Calc '!D18","v":0},{"$f":"'Internal Calc '!F18","v":0},{"$f":"'Internal Calc '!G18","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F8*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G18*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K27:K27)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B8))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C8))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D8))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E8))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F8))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G8))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H8))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I8))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J8))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K8))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L8))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C19","v":""},{"$f":"'Deal Builder'!F28","v":"Choose.."},{"$f":"'Internal Calc '!E19","v":0},{"$f":"'Internal Calc '!D19","v":0},{"$f":"'Internal Calc '!F19","v":0},{"$f":"'Internal Calc '!G19","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F9*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G19*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K28:K28)","v":0},{"$f":"SUM('Deal Builder'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B9))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C9))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D9))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E9))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F9))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G9))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H9))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I9))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J9))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K9))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L9))),\"\")","v":""}]
[{"$f":"IF(D10=0,\"\",\"Tariff Sub Total\")","v":""},null,null,{"$f":"SUM(D2:D9)","v":0},{"$f":"SUM(E2:E9)","v":0},{"$f":"SUM(F2:F9)","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,null,null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B10))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C10))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D10))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E10))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F10))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G10))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H10))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I10))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J10))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K10))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L10))),\"\")","v":""}]
[{"$f":"IF(SUM(D12:D19)=0,\"\",\"Bolt Ons\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B11))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C11))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D11))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E11))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F11))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G11))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H11))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I11))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J11))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K11))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L11))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C20","v":""},{"$f":"'Deal Builder'!F35","v":"Choose.."},{"$f":"'Internal Calc '!E20","v":0},{"$f":"'Internal Calc '!D20","v":0},{"$f":"'Internal Calc '!F20","v":0},{"$f":"'Internal Calc '!G20","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F12*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G20*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K35:K35)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B12))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C12))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D12))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E12))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F12))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G12))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H12))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I12))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J12))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K12))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L12))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C21","v":""},{"$f":"'Deal Builder'!F36","v":"Choose.."},{"$f":"'Internal Calc '!E21","v":0},{"$f":"'Internal Calc '!D21","v":0},{"$f":"'Internal Calc '!F21","v":0},{"$f":"'Internal Calc '!G21","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F13*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G21*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K36:K36)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B13))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C13))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D13))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E13))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F13))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G13))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H13))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I13))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J13))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K13))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L13))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C22","v":""},{"$f":"'Deal Builder'!F37","v":"Choose.."},{"$f":"'Internal Calc '!E22","v":0},{"$f":"'Internal Calc '!D22","v":0},{"$f":"'Internal Calc '!F22","v":0},{"$f":"'Internal Calc '!G22","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F14*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G22*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K37:K37)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B14))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C14))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D14))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E14))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F14))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G14))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H14))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I14))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J14))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K14))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L14))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C23","v":""},{"$f":"'Deal Builder'!F38","v":"Choose.."},{"$f":"'Internal Calc '!E23","v":0},{"$f":"'Internal Calc '!D23","v":0},{"$f":"'Internal Calc '!F23","v":0},{"$f":"'Internal Calc '!G23","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F15*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G23*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K38:K38)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B15))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C15))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D15))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E15))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F15))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G15))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H15))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I15))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J15))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K15))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L15))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C24","v":""},{"$f":"'Deal Builder'!F39","v":"Choose.."},{"$f":"'Internal Calc '!E24","v":0},{"$f":"'Internal Calc '!D24","v":0},{"$f":"'Internal Calc '!F24","v":0},{"$f":"'Internal Calc '!G24","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F16*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G24*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K39:K39)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B16))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C16))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D16))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E16))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F16))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G16))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H16))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I16))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J16))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K16))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L16))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C25","v":""},{"$f":"'Deal Builder'!F40","v":"Choose.."},{"$f":"'Internal Calc '!E25","v":0},{"$f":"'Internal Calc '!D25","v":0},{"$f":"'Internal Calc '!F25","v":0},{"$f":"'Internal Calc '!G25","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F17*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G25*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K40:K40)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A17))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B17))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C17))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D17))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E17))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F17))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G17))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H17))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I17))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J17))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K17))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L17))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C26","v":""},{"$f":"'Deal Builder'!F41","v":"Choose.."},{"$f":"'Internal Calc '!E26","v":0},{"$f":"'Internal Calc '!D26","v":0},{"$f":"'Internal Calc '!F26","v":0},{"$f":"'Internal Calc '!G26","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F18*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G26*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K41:K41)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A18))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B18))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C18))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D18))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E18))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F18))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G18))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H18))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I18))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J18))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K18))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L18))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C27","v":""},{"$f":"'Deal Builder'!F42","v":"Choose.."},{"$f":"'Internal Calc '!E27","v":0},{"$f":"'Internal Calc '!D27","v":0},{"$f":"'Internal Calc '!F27","v":0},{"$f":"'Internal Calc '!G27","v":0},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}},{"$f":"F19*'Deal Builder'!$F$13","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(('Internal Calc '!G27*'Deal Builder'!$F$13)+'Internal Calc '!#REF!+'Internal Calc '!#REF!,0)","v":0},{"$f":"SUM('Deal Builder'!K42:K42)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A19))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B19))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C19))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D19))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E19))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F19))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G19))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H19))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I19))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J19))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K19))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L19))),\"\")","v":""}]
[{"$f":"IF(D20=0,\"\",\"Bolt On Sub Total\")","v":""},null,null,{"$f":"SUM(D12:D19)","v":0},0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,null,null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A20))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B20))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C20))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D20))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E20))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F20))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G20))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H20))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I20))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J20))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K20))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L20))),\"\")","v":""}]
["Grand Total",null,null,{"$f":"D10","v":0},{"$f":"E20+E10","v":0},{"$f":"F20+F10","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,null,null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A21))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B21))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C21))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D21))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E21))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F21))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G21))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H21))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I21))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J21))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K21))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L21))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(A$1:A$21,SMALL(IF($A$1:$A$21<>\"\",ROW(A$1:A$21)-ROW(A$1)+1),ROWS(A$1:A22))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$21,SMALL(IF($A$1:$A$21<>\"\",ROW(B$1:B$21)-ROW(B$1)+1),ROWS(B$1:B22))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$21,SMALL(IF($A$1:$A$21<>\"\",ROW(C$1:C$21)-ROW(C$1)+1),ROWS(C$1:C22))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$21,SMALL(IF($A$1:$A$21<>\"\",ROW(D$1:D$21)-ROW(D$1)+1),ROWS(D$1:D22))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$21,SMALL(IF($A$1:$A$21<>\"\",ROW(E$1:E$21)-ROW(E$1)+1),ROWS(E$1:E22))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$21,SMALL(IF($A$1:$A$21<>\"\",ROW(F$1:F$21)-ROW(F$1)+1),ROWS(F$1:F22))),\"\")","v":""},{"$f":"IFERROR(INDEX(G$1:G$21,SMALL(IF($A$1:$A$21<>\"\",ROW(G$1:G$21)-ROW(G$1)+1),ROWS(G$1:G22))),\"\")","v":""},{"$f":"IFERROR(INDEX(H$1:H$21,SMALL(IF($A$1:$A$21<>\"\",ROW(H$1:H$21)-ROW(H$1)+1),ROWS(H$1:H22))),\"\")","v":""},{"$f":"IFERROR(INDEX(I$1:I$21,SMALL(IF($A$1:$A$21<>\"\",ROW(I$1:I$21)-ROW(I$1)+1),ROWS(I$1:I22))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$1:J$21,SMALL(IF($A$1:$A$21<>\"\",ROW(J$1:J$21)-ROW(J$1)+1),ROWS(J$1:J22))),\"\")","v":""},{"$f":"IFERROR(INDEX(K$1:K$21,SMALL(IF($A$1:$A$21<>\"\",ROW(K$1:K$21)-ROW(K$1)+1),ROWS(K$1:K22))),\"\")","v":""},{"$f":"IFERROR(INDEX(L$1:L$21,SMALL(IF($A$1:$A$21<>\"\",ROW(L$1:L$21)-ROW(L$1)+1),ROWS(L$1:L22))),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Bolt On Rental Per User","Qty","Total Cost per Month","Monthly Revenue Share","Standard Funding","Discretionary Funding","Revenue Share Over Term","Total Commission Over Term"]

{"sheet":"Drop Downs","index":9,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Cell Reference"]
["Name Ref","TermLength","yesno","twelvetariffNetwork","twentyfourtariffNetwork","thirtytariffNetwork","O2twelvetariff","O2twentyfourtariff/O2thirtytariff","tsosu","tmbb","tfsosu","tfmbb","Twentyotwobo","Twelveotwobo/Oneotwobo","rd","rowm","ic","CBMName"]
[]
[null,"Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose.."]
[null,12,"Yes","O2","O2","O2","Sim Only Single User","Sim Only Single User","Small Biz SO 300MB 12M RRP","Mobile Broadband 1GB 12M RRP","Small Biz SO 300MB 24M RRP","Mobile Broadband 1GB 24M RRP","Roaming Data","Roaming Data","ROW Data 500MB","ROW 250 mins","Int. Caller 120 Mins","Ian Davis "]
[null,24,"No",null,null,null,"Mobile Broadband","Mobile Broadband","Small Biz SO 500MB 12M RRP","Mobile Broadband 2GB 12M RRP","Small Biz SO 500MB 24M RRP","Mobile Broadband 2GB 24M RRP","ROW Minutes","ROW Minutes","ROW Data 1GB","ROW 500 mins","Int. Caller 500 Mins","Rob Foster"]
[null,36,null,null,null,null,null,null,"Small Biz SO 2GB 12M RRP","Mobile Broadband 4GB 12M RRP","Small Biz SO 2GB 24M RRP","Mobile Broadband 4GB 24M RRP","International Caller","International Caller",null,null,null,"Anton Le Saux"]
[null,null,null,null,null,null,null,null,"Small Biz SO 3GB 12M RRP","Mobile Broadband 8GB 12M RRP","Small Biz SO 3GB 24M RRP","Mobile Broadband 8GB 24M RRP",null,null,null,null,null,"Ben Ofosu"]
[null,null,null,null,null,null,null,null,"Small Biz SO 5GB 12M RRP","Mobile Broadband 20GB 12M RRP","Small Biz SO 5GB 24M RRP","Mobile Broadband 20GB 24M RRP",null,null,null,null,null,"Jon Reynolds"]
[null,null,null,null,null,null,null,null,"Small Biz SO 8GB 12M RRP","Mobile Broadband 30GB 12M RRP","Small Biz SO 8GB 24M RRP","Mobile Broadband 30GB 24M RRP",null,null,null,null,null,"Gemma Stopford"]
[null,null,null,null,null,null,null,null,"Small Biz SO 16GB 12M RRP",null,"Small Biz SO 16GB 24M RRP",null,null,null,null,null,null,"Adam Williams"]
[null,null,null,null,null,null,null,null,"Small Biz SO 24GB 12M RRP",null,"Small Biz SO 24GB 24M RRP"]
[null,null,null,null,null,null,null,null,"Small Biz SO 32GB 12M RRP",null,"Small Biz SO 32GB 24M RRP"]
[null,null,null,null,null,null,null,null,"Small Biz SO 50GB 12M RRP",null,"Small Biz SO 50GB 24M RRP"]
[null,null,null,null,null,null,null,null,"Small Biz SO 100GB 12M RRP Promo",null,"Small Biz SO 100GB 24M RRP Promo"]

{"sheet":"Lookups","index":10,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Cell Reference"]
[]
[null,1,"onetariff",null,null,"12Sim Only Single User","tsosu",null,1,"One",null,"O2","otwo",null,"Small Biz Shared Data","sbsd"]
[null,12,"twelvetariff",null,null,"12Sim Only Adjusted Rev Share","tsoad",null,12,"Twelve",null,"Vodafone","vodafone",null,"Shared Minutes","sm"]
[null,24,"twentyfourtariff",null,null,"12Mobile Broadband","tmbb",null,24,"Twenty",null,null,null,null,"Shared Texts","st"]
[null,36,"thirtytariff",null,null,"24Sim Only Single User","tfsosu",null,null,null,null,null,null,null,"Individual Data","id"]
[null,null,null,null,null,"24Sim Only Adjusted Rev Share","tfsoad",null,null,null,null,null,null,null,"Shared Data","sd"]
[null,null,null,null,null,"24Single User","tfsu",null,null,null,null,null,null,null,"Individual Topup","it"]
[null,null,null,null,null,"24Business Single Shared Data","tfbssd",null,null,null,null,null,null,null,"UK Data Bolt On","ukdbo"]
[null,null,null,null,null,"24Parent","tfp",null,null,null,null,null,null,null,"Roaming Data Bolt-ons","rdbo"]
[null,null,null,null,null,"24Child","tfc",null,null,null,null,null,null,null,"Roam & International Min Bolt ons","rimbo"]
[null,null,null,null,null,"24Mobile Broadband","tfmbb",null,null,null,null,null,null,null,"UK to Abroad Text Bolt-ons","uatbo"]
[null,null,null,null,null,"1Single","os",null,null,null,null,null,null,null,"NGN Min Bolt ons","nmbo"]
[null,null,null,null,null,"1MBB","osmbb",null,null,null,null,null,null,null,"Roaming Data","rd"]
[null,null,null,null,null,"12Single","os",null,null,null,null,null,null,null,"ROW Minutes","rowm"]
[null,null,null,null,null,"12MBB","osmbb",null,null,null,null,null,null,null,"International Caller","ic"]
[null,null,null,null,null,"24Single","os",null,null,null,null,null,null,null,"Forever Connected Shared Data Bolt On","fcsd"]
[null,null,null,null,null,"24MBB","osmbb",null,null,null,null,null,null,null,"Shared International Caller","sic"]
[null,null,null,null,null,"36Sim Only Single User","tfsosu"]
[null,null,null,null,null,"36Sim Only Adjusted Rev Share","tfsoad"]
[null,null,null,null,null,"36Single User","tfsu"]
[null,null,null,null,null,"36Business Single Shared Data","tfbssd"]
[null,null,null,null,null,"36Parent","tfp"]
[null,null,null,null,null,"36Child","tfc"]
[null,null,null,null,null,"36Mobile Broadband","tfmbb"]

{"sheet":"Pricing","index":11,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Tariff","Type","Data","Term","Standard Sell","Overage Revenue","Commission %","Usage Commission %"]
["Small Biz SO 300MB 12M RRP","RRP","300MB","12M",11.4,4.5,0.4,0.5]
["Small Biz SO 500MB 12M RRP","RRP","500MB","12M",13.8,4.5,0.4,0.5]
["Small Biz SO 2GB 12M RRP","RRP","2GB","12M",17,4.5,0.4,0.5]
["Small Biz SO 3GB 12M RRP","RRP","3GB","12M",17,4.5,0.4,0.5]
["Small Biz SO 5GB 12M RRP","RRP","5GB","12M",19,4.5,0.4,0.5]
["Small Biz SO 8GB 12M RRP","RRP","8GB","12M",22,4.5,0.45,0.5]
["Small Biz SO 16GB 12M RRP","RRP","16GB","12M",24,4.5,0.45,0.5]
["Small Biz SO 24GB 12M RRP","RRP","24GB","12M",25,4.5,0.45,0.5]
["Small Biz SO 32GB 12M RRP","RRP","32GB","12M",26,4.5,0.45,0.5]
["Small Biz SO 50GB 12M RRP","RRP","50GB","12M",32,4.5,0.45,0.5]
["Small Biz SO 100GB 12M RRP Promo","RRP","100GB","12M",46,4.5,0.45,0.5]
["Small Biz SO 300MB 24M RRP","RRP","300MB","24M",10,4.5,0.5,0.5]
["Small Biz SO 500MB 24M RRP","RRP","500MB","24M",12,4.5,0.5,0.5]
["Small Biz SO 2GB 24M RRP","RRP","2GB","24M",13.5,4.5,0.5,0.5]
["Small Biz SO 3GB 24M RRP","RRP","3GB","24M",13.5,4.5,0.5,0.5]
["Small Biz SO 5GB 24M RRP","RRP","5GB","24M",15,4.5,0.5,0.5]
["Small Biz SO 8GB 24M RRP","RRP","8GB","24M",17,4.5,0.5,0.5]
["Small Biz SO 16GB 24M RRP","RRP","16GB","24M",19,4.5,0.5,0.5]
["Small Biz SO 24GB 24M RRP","RRP","24GB","24M",21,4.5,0.5,0.5]
["Small Biz SO 32GB 24M RRP","RRP","32GB","24M",26,4.5,0.5,0.5]
["Small Biz SO 50GB 24M RRP","RRP","50GB","24M",29.5,4.5,0.5,0.5]
["Small Biz SO 100GB 24M RRP Promo","RRP","100GB","24M",46,4.5,0.5,0.5]
["Mobile Broadband 1GB 12M RRP","RRP","1GB","12M",9.5,2,0.4,0.5]
["Mobile Broadband 2GB 12M RRP","RRP","2GB","12M",11,2,0.4,0.5]
["Mobile Broadband 4GB 12M RRP","RRP","4GB","12M",14,2,0.4,0.5]
["Mobile Broadband 8GB 12M RRP","RRP","8GB","12M",17,2,0.4,0.5]
["Mobile Broadband 20GB 12M RRP","RRP","20GB","12M",22,2,0.45,0.5]
["Mobile Broadband 30GB 12M RRP","RRP","30GB","12M",27,2,0.45,0.5]
["Mobile Broadband 1GB 24M RRP","RRP","1GB","24M",9.5,2,0.5,0.5]
["Mobile Broadband 2GB 24M RRP","RRP","2GB","24M",11,2,0.5,0.5]
["Mobile Broadband 4GB 24M RRP","RRP","4GB","24M",14,2,0.5,0.5]
["Mobile Broadband 8GB 24M RRP","RRP","8GB","24M",17,2,0.5,0.5]
["Mobile Broadband 20GB 24M RRP","RRP","20GB","24M",22,2,0.5,0.5]
["Mobile Broadband 30GB 24M RRP","RRP","30GB","24M",27,2,0.5,0.5]
["Bolt Ons","Type","Data","Term","Standard Sell","Overage Revenue","Commission %","Usage Commission %"]
["250MB World Data","RRP",null,null,120,null,0.4]
["ROW Data 500MB","RRP",null,null,50,null,0.1]
["ROW Data 1GB","RRP",null,null,90,null,0.1]
["ROW 250 mins","RRP",null,null,100,null,0.1]
["ROW 500 mins","RRP",null,null,190,null,0.1]
["Int. Caller 120 Mins","RRP",null,null,5,null,0.1]
["Int. Caller 500 Mins","RRP",null,null,15,null,0.1]