{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Deal Builder","Internal Calc ","PDF Generator","New PDF","Drop Downs","Pricing","Conversion for PDF"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":75,"comments":1,"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":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,2,7]]}
["Vodafone WS Calculator Instructions"]
[]
[]
["1)","Fill in the deal details at the top of the Deal Builder WorkSheet"]
["2)","Pick a contract term from the dropdown"]
["3)","Choose a quantity, CTN type, tariff type and tariff description for each connection type"]
["4)","Mark up or mark down tariffs as required"]
["5)","Choose a quantity, CTN type, network, bolt on type and bolt on description for each bolt on"]
["6)","Mark up or mark down bolt ons as required"]

{"sheet":"Deal Builder","index":1,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,15],[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],[30,11,30,14]]}
["Zest4 Deal Calculator v1.1.3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(#REF!,\"Yes\")+COUNTIF(#REF!,\"Yes\")","v":{"$error":"#REF!"}}]
[]
[null,null,null,"CBM Name: "]
[]
[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 Type (Months):",24]
[]
[null,null,null,"Date:"]
[]
[null,null,null,"Choose Your Tariff"]
[]
[]
[null,null,null,"Quantity ","Network ","CTN Type","Tariff Type","Tariff Decription ","Buy Price Per Line Per Month","Mark Up/ Down","Sell Price Per Line Per Month","Total Sell Price Per Month","Funding Paid to Customer Per Line","Total Customer Funding"]
[null,null,null,2,{"$f":"IF(D21<>0,\"Vodafone\",\"Choose..\")","v":"Vodafone"},"New","Single User","VF Business Simplicity (Data Sharer) Std",{"$f":"IFERROR(VLOOKUP(H21,tariffs,4,0),0)","v":6.5},5,{"$f":"I21+J21","v":11.5},{"$f":"K21*D21","v":23},100,{"$f":"M21*D21","v":200}]
[null,null,null,0,{"$f":"IF(D22<>0,\"Vodafone\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",0,0,{"$f":"IFERROR(I22+J22,0)","v":0},{"$f":"IFERROR(K22*D22,0)","v":0},0,{"$f":"M22*D22","v":0}]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,{"$f":"IFERROR(I23+J23,0)","v":0},{"$f":"IFERROR(K23*D23,0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Choose Your Bolt Ons "]
[]
[]
[null,null,null,"Quantity ","Network","CTN Type","Bolt On Type","Bolt On Description ","Buy Price Per Line Per Month","Mark Up/ Down","Sell Price Per Line Per Month","Total Sell Price Per Month","Funding Paid to Customer Per Line","Total Customer Funding"]
[null,null,null,0,{"$f":"IF(D35<>0,\"Vodafone\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",{"$f":"IFERROR(VLOOKUP(H35,boltons,4,0),0)","v":0},0,{"$f":"I35+J35","v":0},{"$f":"K35*D35","v":0},0,{"$f":"M35*D35","v":0}]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,{"$f":"IFERROR(I36+J36,0)","v":0},{"$f":"IFERROR(K36*D36,0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,{"$f":"IFERROR(I37+J37,0)","v":0},{"$f":"IFERROR(K37*D37,0)","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,0,0,0,0,0]

{"sheet":"Internal Calc ","index":2,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[21,0,21,1],[22,0,22,1],[23,0,23,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[20,0,20,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[11,0,11,1],[12,0,12,1],[0,0,0,14],[2,0,2,1],[3,0,3,1],[4,0,4,1],[7,0,7,1],[5,0,5,1],[6,0,6,1],[8,0,8,1],[10,0,10,1],[46,0,54,1],[27,0,27,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[31,0,33,14],[28,8,29,8],[28,9,29,9],[28,10,29,10],[28,2,29,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,7,29,7],[28,6,29,6]]}
["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 Voice Connections",null,{"$f":"IF(SUM('Deal Builder'!D21:D28)=0,\"\",SUM('Deal Builder'!D21:D28))","v":2}]
["Your Deal Reference",null,{"$f":"IF('Deal Builder'!F11=\"\",\"\",'Deal Builder'!F11)","v":""}]
["Estimated Customer Monthly Billing",null,{"$f":"F30","v":0}]
["Deal Profit",null,{"$f":"K29","v":40}]
[]
["Zygo billed rentals",null,"Tariff"]
[null,null,null,"Quantity","Buy Price Per Line Per Month","Mark Up/ Down","Sell Price Per Line Per Month","Total Sell Price Per Month","Funding Paid to Customer Per Line","Total Customer Funding","Total Gross Margin Over Term"]
["Tariff",null,{"$f":"IF('Deal Builder'!H21 =\"Choose..\",\"\",'Deal Builder'!H21)","v":"VF Business Simplicity (Data Sharer) Std"},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D21)","v":2},{"$f":"'Deal Builder'!I21","v":6.5},{"$f":"'Deal Builder'!J21","v":5},{"$f":"'Deal Builder'!K21","v":11.5},{"$f":"'Deal Builder'!L21","v":23},{"$f":"'Deal Builder'!M21","v":100},{"$f":"'Deal Builder'!N21","v":200},{"$f":"F13*'Deal Builder'!$F$13*'Internal Calc '!D13-'Internal Calc '!J13","v":40}]
["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'!K22","v":0},{"$f":"'Deal Builder'!L22","v":0},{"$f":"'Deal Builder'!M22","v":0},{"$f":"'Deal Builder'!N22","v":0},{"$f":"F14*'Deal Builder'!$F$13*'Internal Calc '!D14-'Internal Calc '!J14","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'!K23","v":0},{"$f":"'Deal Builder'!L23","v":0},{"$f":"'Deal Builder'!M23","v":0},{"$f":"'Deal Builder'!N23","v":0},{"$f":"F15*'Deal Builder'!$F$13*'Internal Calc '!D15-'Internal Calc '!J15","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'!K24","v":0},{"$f":"'Deal Builder'!L24","v":0},{"$f":"'Deal Builder'!M24","v":0},{"$f":"'Deal Builder'!N24","v":0},{"$f":"F16*'Deal Builder'!$F$13*'Internal Calc '!D16-'Internal Calc '!J16","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'!K25","v":0},{"$f":"'Deal Builder'!L25","v":0},{"$f":"'Deal Builder'!M25","v":0},{"$f":"'Deal Builder'!N25","v":0},{"$f":"F17*'Deal Builder'!$F$13*'Internal Calc '!D17-'Internal Calc '!J17","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'!K26","v":0},{"$f":"'Deal Builder'!L26","v":0},{"$f":"'Deal Builder'!M26","v":0},{"$f":"'Deal Builder'!N26","v":0},{"$f":"F18*'Deal Builder'!$F$13*'Internal Calc '!D18-'Internal Calc '!J18","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'!K27","v":0},{"$f":"'Deal Builder'!L27","v":0},{"$f":"'Deal Builder'!M27","v":0},{"$f":"'Deal Builder'!N27","v":0},{"$f":"F19*'Deal Builder'!$F$13*'Internal Calc '!D19-'Internal Calc '!J19","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'!K28","v":0},{"$f":"'Deal Builder'!L28","v":0},{"$f":"'Deal Builder'!M28","v":0},{"$f":"'Deal Builder'!N28","v":0},{"$f":"F20*'Deal Builder'!$F$13*'Internal Calc '!D20-'Internal Calc '!J20","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'!K35","v":0},{"$f":"'Deal Builder'!L35","v":0},{"$f":"'Deal Builder'!M35","v":0},{"$f":"'Deal Builder'!N35","v":0},{"$f":"F21*'Deal Builder'!$F$13*'Internal Calc '!D21-'Internal Calc '!J21","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'!K36","v":0},{"$f":"'Deal Builder'!L36","v":0},{"$f":"'Deal Builder'!M36","v":0},{"$f":"'Deal Builder'!N36","v":0},{"$f":"F22*'Deal Builder'!$F$13*'Internal Calc '!D22-'Internal Calc '!J22","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'!K37","v":0},{"$f":"'Deal Builder'!L37","v":0},{"$f":"'Deal Builder'!M37","v":0},{"$f":"'Deal Builder'!N37","v":0},{"$f":"F23*'Deal Builder'!$F$13*'Internal Calc '!D23-'Internal Calc '!J23","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'!K38","v":0},{"$f":"'Deal Builder'!L38","v":0},{"$f":"'Deal Builder'!M38","v":0},{"$f":"'Deal Builder'!N38","v":0},{"$f":"F24*'Deal Builder'!$F$13*'Internal Calc '!D24-'Internal Calc '!J24","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'!K39","v":0},{"$f":"'Deal Builder'!L39","v":0},{"$f":"'Deal Builder'!M39","v":0},{"$f":"'Deal Builder'!N39","v":0},{"$f":"F25*'Deal Builder'!$F$13*'Internal Calc '!D25-'Internal Calc '!J25","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'!K40","v":0},{"$f":"'Deal Builder'!L40","v":0},{"$f":"'Deal Builder'!M40","v":0},{"$f":"'Deal Builder'!N40","v":0},{"$f":"F26*'Deal Builder'!$F$13*'Internal Calc '!D26-'Internal Calc '!J26","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'!K41","v":0},{"$f":"'Deal Builder'!L41","v":0},{"$f":"'Deal Builder'!M41","v":0},{"$f":"'Deal Builder'!N41","v":0},{"$f":"F27*'Deal Builder'!$F$13*'Internal Calc '!D27-'Internal Calc '!J27","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'!K42","v":0},{"$f":"'Deal Builder'!L42","v":0},{"$f":"'Deal Builder'!M42","v":0},{"$f":"'Deal Builder'!N42","v":0},{"$f":"F28*'Deal Builder'!$F$13*'Internal Calc '!D28-'Internal Calc '!J28","v":0}]
[null,null,"Total",{"$f":"SUM(D13:D28)","v":2},{"$f":"SUM(E13:E28)","v":6.5},{"$f":"SUM(F13:F28)","v":5},11.5,23,100,200,{"$f":"SUM(K13:K28)","v":40}]

{"sheet":"PDF Generator","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"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":2}]
["Your Deal Reference",{"$f":"'Internal Calc '!C7","v":""}]
["Estimated Customer Monthly Billing",{"$f":"'Internal Calc '!C8","v":0}]
["Bonuses on Month One",{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}}]
[]
["Tariff","Quanitity","Total monthly cost","Funding ","Margin"]
[{"$f":"'Internal Calc '!C12","v":0},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!D13)","v":2},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!F13)","v":5},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('Internal Calc '!D13=0,\"\",'Internal Calc '!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"'Internal Calc '!C13","v":"VF Business Simplicity (Data Sharer) Std"},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!D14)","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!F14)","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D14=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C14","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!D15)","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!F15)","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D15=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C15","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!D16)","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!F16)","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D16=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C16","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!D17)","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!F17)","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D17=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C17","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!D18)","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!F18)","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D18=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C18","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!D19)","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!F19)","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D19=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C19","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!D20)","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!F20)","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D20=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C20","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!D21)","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!F21)","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D21=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C21","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!D22)","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!F22)","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D22=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C22","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!D23)","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!F23)","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D23=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C23","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!D24)","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!F24)","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D24=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C24","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!D25)","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!F25)","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D25=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C25","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!D26)","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!F26)","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D26=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C26","v":""},{"$f":"IF('Internal Calc '!D28=0,\"\",'Internal Calc '!D28)","v":""},{"$f":"IF('Internal Calc '!D28=0,\"\",'Internal Calc '!F28)","v":""},{"$f":"IF('Internal Calc '!D28=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!D28=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C28","v":""},{"$f":"IF('Internal Calc '!#REF!=0,\"\",'Internal Calc '!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('Internal Calc '!#REF!=0,\"\",'Internal Calc '!F29)","v":{"$error":"#REF!"}},{"$f":"IF('Internal Calc '!#REF!=0,\"\",'Internal Calc '!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('Internal Calc '!#REF!=0,\"\",'Internal Calc '!#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"New PDF","index":4,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,5,10,5],[5,0,5,4],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4]]}
[]
[]
[]
[]
[]
[{"$f":"\"Deal Summary For: \"&'Deal Builder'!F5","v":"Deal Summary For: "}]
[{"$f":"\"Partner Name: \"&'Deal Builder'!F7","v":"Partner Name: "},null,null,null,"ZES"]
[{"$f":"\"Contract Term: \"&'Deal Builder'!F13&IF('Deal Builder'!F13=1,\" Month\",\" Months\")","v":"Contract Term: 24 Months"},null,null,"Deal Reference:","ZES3370"]
[]
[{"$f":"'Conversion for PDF'!H1","v":"Tariff"},{"$f":"'Conversion for PDF'!I1","v":"Quantity"},{"$f":"'Conversion for PDF'!J1","v":"Price Per Line Per Month"},{"$f":"'Conversion for PDF'!K1","v":"Total Price Per Month"},{"$f":"'Conversion for PDF'!L1","v":"Funding Per Line"},{"$f":"'Conversion for PDF'!M1","v":"Total Funding"}]
[]
[{"$f":"'Conversion for PDF'!H2","v":"VF Business Simplicity (Data Sharer) Std"},{"$f":"'Conversion for PDF'!I2","v":2},{"$f":"'Conversion for PDF'!J2","v":11.5},{"$f":"'Conversion for PDF'!K2","v":23},{"$f":"'Conversion for PDF'!L2","v":100},{"$f":"'Conversion for PDF'!M2","v":200}]
[{"$f":"'Conversion for PDF'!H3","v":"Total"},{"$f":"'Conversion for PDF'!I3","v":2},{"$f":"'Conversion for PDF'!J3","v":11.5},{"$f":"'Conversion for PDF'!K3","v":23},{"$f":"'Conversion for PDF'!L3","v":100},{"$f":"'Conversion for PDF'!M3","v":200}]
[{"$f":"'Conversion for PDF'!H4","v":""},{"$f":"'Conversion for PDF'!I4","v":""},{"$f":"'Conversion for PDF'!J4","v":""},{"$f":"'Conversion for PDF'!K4","v":""},{"$f":"'Conversion for PDF'!L4","v":""},{"$f":"'Conversion for PDF'!M4","v":""}]
[{"$f":"'Conversion for PDF'!H5","v":""},{"$f":"'Conversion for PDF'!I5","v":""},{"$f":"'Conversion for PDF'!J5","v":""},{"$f":"'Conversion for PDF'!K5","v":""},{"$f":"'Conversion for PDF'!L5","v":""},{"$f":"'Conversion for PDF'!M5","v":""}]
[{"$f":"'Conversion for PDF'!H6","v":""},{"$f":"'Conversion for PDF'!I6","v":""},{"$f":"'Conversion for PDF'!J6","v":""},{"$f":"'Conversion for PDF'!K6","v":""},{"$f":"'Conversion for PDF'!L6","v":""},{"$f":"'Conversion for PDF'!M6","v":""}]
[{"$f":"'Conversion for PDF'!H7","v":""},{"$f":"'Conversion for PDF'!I7","v":""},{"$f":"'Conversion for PDF'!J7","v":""},{"$f":"'Conversion for PDF'!K7","v":""},{"$f":"'Conversion for PDF'!L7","v":""},{"$f":"'Conversion for PDF'!M7","v":""}]
[{"$f":"'Conversion for PDF'!H8","v":""},{"$f":"'Conversion for PDF'!I8","v":""},{"$f":"'Conversion for PDF'!J8","v":""},{"$f":"'Conversion for PDF'!K8","v":""},{"$f":"'Conversion for PDF'!L8","v":""},{"$f":"'Conversion for PDF'!M8","v":""}]
[{"$f":"'Conversion for PDF'!H9","v":""},{"$f":"'Conversion for PDF'!I9","v":""},{"$f":"'Conversion for PDF'!J9","v":""},{"$f":"'Conversion for PDF'!K9","v":""},{"$f":"'Conversion for PDF'!L9","v":""},{"$f":"'Conversion for PDF'!M9","v":""}]
[{"$f":"'Conversion for PDF'!H10","v":""},{"$f":"'Conversion for PDF'!I10","v":""},{"$f":"'Conversion for PDF'!J10","v":""},{"$f":"'Conversion for PDF'!K10","v":""},{"$f":"'Conversion for PDF'!L10","v":""},{"$f":"'Conversion for PDF'!M10","v":""}]
[{"$f":"'Conversion for PDF'!H11","v":""},{"$f":"'Conversion for PDF'!I11","v":""},{"$f":"'Conversion for PDF'!J11","v":""},{"$f":"'Conversion for PDF'!K11","v":""},{"$f":"'Conversion for PDF'!L11","v":""},{"$f":"'Conversion for PDF'!M11","v":""}]
[{"$f":"'Conversion for PDF'!H12","v":""},{"$f":"'Conversion for PDF'!I12","v":""},{"$f":"'Conversion for PDF'!J12","v":""},{"$f":"'Conversion for PDF'!K12","v":""},{"$f":"'Conversion for PDF'!L12","v":""},{"$f":"'Conversion for PDF'!M12","v":""}]
[{"$f":"'Conversion for PDF'!H13","v":""},{"$f":"'Conversion for PDF'!I13","v":""},{"$f":"'Conversion for PDF'!J13","v":""},{"$f":"'Conversion for PDF'!K13","v":""},{"$f":"'Conversion for PDF'!L13","v":""},{"$f":"'Conversion for PDF'!M13","v":""}]
[{"$f":"'Conversion for PDF'!H14","v":""},{"$f":"'Conversion for PDF'!I14","v":""},{"$f":"'Conversion for PDF'!J14","v":""},{"$f":"'Conversion for PDF'!K14","v":""},{"$f":"'Conversion for PDF'!L14","v":""},{"$f":"'Conversion for PDF'!M14","v":""}]
[{"$f":"'Conversion for PDF'!H15","v":""},{"$f":"'Conversion for PDF'!I15","v":""},{"$f":"'Conversion for PDF'!J15","v":""},{"$f":"'Conversion for PDF'!K15","v":""},{"$f":"'Conversion for PDF'!L15","v":""},{"$f":"'Conversion for PDF'!M15","v":""}]
[{"$f":"'Conversion for PDF'!H16","v":""},{"$f":"'Conversion for PDF'!I16","v":""},{"$f":"'Conversion for PDF'!J16","v":""},{"$f":"'Conversion for PDF'!K16","v":""},{"$f":"'Conversion for PDF'!L16","v":""},{"$f":"'Conversion for PDF'!M16","v":""}]
[{"$f":"'Conversion for PDF'!H17","v":""},{"$f":"'Conversion for PDF'!I17","v":""},{"$f":"'Conversion for PDF'!J17","v":""},{"$f":"'Conversion for PDF'!K17","v":""},{"$f":"'Conversion for PDF'!L17","v":""},{"$f":"'Conversion for PDF'!M17","v":""}]
[{"$f":"'Conversion for PDF'!H18","v":""},{"$f":"'Conversion for PDF'!I18","v":""},{"$f":"'Conversion for PDF'!J18","v":""},{"$f":"'Conversion for PDF'!K18","v":""},{"$f":"'Conversion for PDF'!L18","v":""},{"$f":"'Conversion for PDF'!M18","v":""}]
[{"$f":"'Conversion for PDF'!H19","v":""},{"$f":"'Conversion for PDF'!I19","v":""},{"$f":"'Conversion for PDF'!J19","v":""},{"$f":"'Conversion for PDF'!K19","v":""},{"$f":"'Conversion for PDF'!L19","v":""},{"$f":"'Conversion for PDF'!M19","v":""}]
[{"$f":"'Conversion for PDF'!H20","v":""},{"$f":"'Conversion for PDF'!I20","v":""},{"$f":"'Conversion for PDF'!J20","v":""},{"$f":"'Conversion for PDF'!K20","v":""},{"$f":"'Conversion for PDF'!L20","v":""},{"$f":"'Conversion for PDF'!M20","v":""}]
[{"$f":"'Conversion for PDF'!H21","v":""},{"$f":"'Conversion for PDF'!I21","v":""}]

{"sheet":"Drop Downs","index":5,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["wscontract","network","tarifftype","VodafoneSingleUser","boltontypes","WorldData","WorldTraveller","InternationalMinutes","RoamingMinutes","InternationalSMS","NonGeoMinutes","SharedData","InternationalCaller"]
["Choose..","Choose..","Choose..","Choose..","Choose..","250MB World Data ","World Traveller ","International Caller**","100 mins Roam World ","100 International SMS ","100 Non Geo Mins ","Shared Data 25GB ","International Caller"]
[1,"Vodafone","Single User","VF Business Simplicity (Data Sharer) Std","World Data","500MB World Data ",null,"100 mins UK - EU ","250 mins Roam World ","250 International SMS ","300 Non Geo Mins ","Shared Data 50GB "]
[12,null,"Mobile Broadband","VF Business Simplicity 3GB Std","International Minutes","1GB World Data ",null,"500 mins UK - EU ","500 mins Roam World ","500 International SMS ",null,"Shared Data 75GB "]
[24,null,"Mobile Broadband with WTS","VF Business Simplicity 5GB Std","Roaming Minutes",null,null,"1000 mins UK - EU ",null,"1000 International SMS ",null,"Shared Data 100GB "]
[36,null,null,"VF Business Simplicity 10GB Std","International SMS",null,null,"100 mins UK - USA/Canada",null,null,null,"Shared Data 250GB "]
[null,null,null,"VF Business Simplicity 20GB Std","Non Geo Minutes",null,null,"500 mins UK - USA/Canada",null,null,null,"Shared Data 500GB "]
[null,null,null,"VF NOV-18 Business Simplicity 50GB Std PROMO","Shared Data",null,null,"1000 mins UK - USA/Canada",null,null,null,"Shared Data 1000GB "]
["cbmname",null,null,"Business Simplicity 100GB PROMO",null,null,null,"100 mins UK - World "]
["Ian Davis",null,null,null,null,null,null,"500 mins UK - World "]
["Rob Foster",null,null,null,null,null,null,"1000 mins UK - World "]
["Anton Le Saux",null,null,"VodafoneMobileBroadband"]
["Ben Ofosu",null,null,"Choose.."]
["Jon Reynolds",null,null,"VF MBB (Data Only Sharer) Std"]
["Gemma Stopford",null,null,"VF MBB 2GB Std"]
["Adam Williams",null,null,"VF MBB 5GB Std"]
[null,null,null,"VF MBB 10GB Std"]
[null,null,null,"VF MBB 20GB Std"]
[null,null,null,"VF MBB 50GB Std"]
[null,null,null,"VF MBB100GB Std"]
[null,null,null,"MBB Data Max 60GB"]
[null,null,null,"MBB Data Max 100GB"]
[null,null,null,"MBB Data Max 200GB"]
[null,null,null,"MBB Data Max 300GB"]
[]
[]
[null,null,null,"VodafoneMobileBroadbandwithWTS"]
[null,null,null,"Choose.."]
[null,null,null,"Business Simplicity MBB Data Only Sharer with WTS"]
[null,null,null,"Business Simplicity MBB 2GB with WTS"]
[null,null,null,"Business Simplicity MBB 5GB with WTS"]
[null,null,null,"Business Simplicity MBB 10GB with WTS"]
[null,null,null,"Business Simplicity MBB 20GB with WTS"]
[null,null,null,"Business Simplicity MBB 50GB with WTS"]
[null,null,null,"Business Simplicity MBB 100GB with WTS"]

{"sheet":"Pricing","index":6,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Tariff Name","RRP (12M) Agreed Price","RRP Commission %","WS (1M) Agreed Price",null,null,null,null,null,null,null,null,"Bolt On Name","RRP (12M) Agreed Price","RRP Commission %","WS (1M) Agreed Price"]
["VF Business Simplicity (Data Sharer) Std",12,0.4,6.5,null,null,null,null,null,null,null,null,"Data Top Up 2GB",7,0.4,3.5]
["VF Business Simplicity 3GB Std",19,0.4,9.5,null,null,null,null,null,null,null,null,"Data Top Up 4GB",14,0.4,7]
["VF Business Simplicity 5GB Std",20,0.4,10,null,null,null,null,null,null,null,null,"Data Top Up 8GB",24,0.4,12]
["VF Business Simplicity 10GB Std",23,0.4,11.5,null,null,null,null,null,null,null,null,"Data Top Up 16GB",48,0.4,24]
["VF Business Simplicity 20GB Std",33,0.4,16.5,null,null,null,null,null,null,null,null,"Data Top Up 32GB",96,0.4,48]
["VF NOV-18 Business Simplicity 50GB Std PROMO",43,0.4,21.5,null,null,null,null,null,null,null,null,"250MB World Data ",120,0.4,60]
["VF MBB (Data Only Sharer) Std",5,0.4,2.5,null,null,null,null,null,null,null,null,"500MB World Data ",220,0.4,110]
["VF MBB 2GB Std",10,0.4,5,null,null,null,null,null,null,null,null,"1GB World Data ",400,0.4,200]
["VF MBB 5GB Std",15,0.4,7.5,null,null,null,null,null,null,null,null,"World Traveller ",5.25,0.25,3.25]
["VF MBB 10GB Std",20,0.4,10,null,null,null,null,null,null,null,null,"International Caller** ",5,0.4,2.5]
["VF MBB 20GB Std",30,0.4,15,null,null,null,null,null,null,null,null,"100 mins UK - EU ",5,0.4,2.5]
["VF MBB 50GB Std",41,0.4,20.5,null,null,null,null,null,null,null,null,"500 mins UK - EU ",12,0.4,6]
["VF MBB100GB Std",78,0.4,39,null,null,null,null,null,null,null,null,"1000 mins UK - EU ",16,0.4,8]
["MBB Data Max 60GB",40,0.4,20,null,null,null,null,null,null,null,null,"100 mins UK - USA/Canada",16,0.4,8]
["MBB Data Max 100GB",47,0.4,23.5,null,null,null,null,null,null,null,null,"500 mins UK - USA/Canada",50,0.4,25]
["MBB Data Max 200GB",60,0.4,30,null,null,null,null,null,null,null,null,"1000 mins UK - USA/Canada",80,0.4,40]
["MBB Data Max 300GB",75,0.4,37.5,null,null,null,null,null,null,null,null,"100 mins UK - World ",40,0.4,20]
["Business Simplicity 100GB PROMO","n/a","n/a",25,null,null,null,null,null,null,null,null,"500 mins UK - World ",160,0.4,80]
["Business Simplicity MBB Data Only Sharer with WTS",6,0.4,3,null,null,null,null,null,null,null,null,"1000 mins UK - World ",312,0.4,156]
["Business Simplicity MBB 2GB with WTS",11,0.4,5.5,null,null,null,null,null,null,null,null,"100 mins Roam World ",60,0.4,30]
["Business Simplicity MBB 5GB with WTS",16,0.4,8,null,null,null,null,null,null,null,null,"250 mins Roam World ",160,0.4,80]
["Business Simplicity MBB 10GB with WTS",21,0.4,10.5,null,null,null,null,null,null,null,null,"500 mins Roam World ",310,0.4,155]
["Business Simplicity MBB 20GB with WTS",31,0.4,15.5,null,null,null,null,null,null,null,null,"100 International SMS ",4,0.4,2]
["Business Simplicity MBB 50GB with WTS",42,0.4,21,null,null,null,null,null,null,null,null,"250 International SMS ",10,0.4,5]
["Business Simplicity MBB 100GB with WTS",79,0.4,39.5,null,null,null,null,null,null,null,null,"500 International SMS ",20,0.4,10]
[null,null,null,null,null,null,null,null,null,null,null,null,"1000 International SMS ",40,0.4,20]
[null,null,null,null,null,null,null,null,null,null,null,null,"100 Non Geo Mins ",6,0.4,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"300 Non Geo Mins ",10,0.4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shared Data 25GB ",100,0.4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shared Data 50GB ",200,0.4,100]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shared Data 75GB ",285,0.4,142.5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shared Data 100GB ",380,0.4,190]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shared Data 250GB ",900,0.4,450]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shared Data 500GB ",1800,0.4,900]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shared Data 1000GB ",3400,0.4,1700]

{"sheet":"Conversion for PDF","index":7,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Tariff","Quantity","Price Per Line Per Month","Total Price Per Month","Funding Per Line","Total Funding",null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A1))),\"\")","v":"Tariff"},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B1))),\"\")","v":"Quantity"},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C1))),\"\")","v":"Price Per Line Per Month"},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D1))),\"\")","v":"Total Price Per Month"},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E1))),\"\")","v":"Funding Per Line"},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F1))),\"\")","v":"Total Funding"}]
[{"$f":"'Internal Calc '!C13","v":"VF Business Simplicity (Data Sharer) Std"},{"$f":"'Internal Calc '!D13","v":2},{"$f":"'Internal Calc '!G13","v":11.5},{"$f":"C2*B2","v":23},{"$f":"'Internal Calc '!I13","v":100},{"$f":"'Internal Calc '!J13","v":200},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A2))),\"\")","v":"VF Business Simplicity (Data Sharer) Std"},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B2))),\"\")","v":2},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C2))),\"\")","v":11.5},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D2))),\"\")","v":23},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E2))),\"\")","v":100},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F2))),\"\")","v":200}]
[{"$f":"'Internal Calc '!C14","v":""},{"$f":"'Internal Calc '!D14","v":0},{"$f":"'Internal Calc '!G14","v":0},{"$f":"C3*B3","v":0},{"$f":"'Internal Calc '!I14","v":0},{"$f":"'Internal Calc '!J14","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A3))),\"\")","v":"Total"},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B3))),\"\")","v":2},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C3))),\"\")","v":11.5},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D3))),\"\")","v":23},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E3))),\"\")","v":100},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F3))),\"\")","v":200}]
[{"$f":"'Internal Calc '!C15","v":""},{"$f":"'Internal Calc '!D15","v":0},{"$f":"'Internal Calc '!G15","v":0},0,{"$f":"'Internal Calc '!I15","v":0},{"$f":"'Internal Calc '!J15","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A4))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B4))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C4))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D4))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E4))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F4))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C16","v":""},{"$f":"'Internal Calc '!D16","v":0},{"$f":"'Internal Calc '!G16","v":0},0,{"$f":"'Internal Calc '!I16","v":0},{"$f":"'Internal Calc '!J16","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B5))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C5))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D5))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E5))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F5))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C17","v":""},{"$f":"'Internal Calc '!D17","v":0},{"$f":"'Internal Calc '!G17","v":0},0,{"$f":"'Internal Calc '!I17","v":0},{"$f":"'Internal Calc '!J17","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B6))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C6))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D6))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E6))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F6))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C18","v":""},{"$f":"'Internal Calc '!D18","v":0},{"$f":"'Internal Calc '!G18","v":0},0,{"$f":"'Internal Calc '!I18","v":0},{"$f":"'Internal Calc '!J18","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B7))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C7))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D7))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E7))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F7))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C19","v":""},{"$f":"'Internal Calc '!D19","v":0},{"$f":"'Internal Calc '!G19","v":0},0,{"$f":"'Internal Calc '!I19","v":0},{"$f":"'Internal Calc '!J19","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B8))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C8))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D8))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E8))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F8))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C20","v":""},{"$f":"'Internal Calc '!D20","v":0},{"$f":"'Internal Calc '!G20","v":0},0,{"$f":"'Internal Calc '!I20","v":0},{"$f":"'Internal Calc '!J20","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B9))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C9))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D9))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E9))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F9))),\"\")","v":""}]
[{"$f":"IF(B10=0,\"\",\"Total\")","v":"Total"},{"$f":"SUM(B2:B8)","v":2},{"$f":"SUM(C2:C8)","v":11.5},{"$f":"SUM(D2:D8)","v":23},{"$f":"SUM(E2:E8)","v":100},{"$f":"SUM(F2:F8)","v":200},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B8))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C8))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D8))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E8))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F8))),\"\")","v":""}]
[{"$f":"IF(SUM(B12:B19)=0,\"\",\"Bolt Ons\")","v":""}," "," "," "," "," ",null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B10))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C10))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D10))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E10))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F10))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C21","v":""},{"$f":"'Internal Calc '!D21","v":0},{"$f":"'Internal Calc '!G21","v":0},{"$f":"C12*B12","v":0},{"$f":"'Internal Calc '!I21","v":0},{"$f":"'Internal Calc '!J21","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B11))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C11))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D11))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E11))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F11))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C22","v":""},{"$f":"'Internal Calc '!D22","v":0},{"$f":"'Internal Calc '!G22","v":0},{"$f":"C13*B13","v":0},{"$f":"'Internal Calc '!I22","v":0},{"$f":"'Internal Calc '!J22","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B12))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C12))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D12))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E12))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F12))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C23","v":""},{"$f":"'Internal Calc '!D23","v":0},{"$f":"'Internal Calc '!G23","v":0},0,{"$f":"'Internal Calc '!I23","v":0},{"$f":"'Internal Calc '!J23","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B13))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C13))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D13))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E13))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F13))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C24","v":""},{"$f":"'Internal Calc '!D24","v":0},{"$f":"'Internal Calc '!G24","v":0},0,{"$f":"'Internal Calc '!I24","v":0},{"$f":"'Internal Calc '!J24","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B14))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C14))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D14))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E14))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F14))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C25","v":""},{"$f":"'Internal Calc '!D25","v":0},{"$f":"'Internal Calc '!G25","v":0},0,{"$f":"'Internal Calc '!I25","v":0},{"$f":"'Internal Calc '!J25","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B15))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C15))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D15))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E15))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F15))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C26","v":""},{"$f":"'Internal Calc '!D26","v":0},{"$f":"'Internal Calc '!G26","v":0},0,{"$f":"'Internal Calc '!I26","v":0},{"$f":"'Internal Calc '!J26","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B16))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C16))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D16))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E16))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F16))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C27","v":""},{"$f":"'Internal Calc '!D27","v":0},{"$f":"'Internal Calc '!G27","v":0},0,{"$f":"'Internal Calc '!I27","v":0},{"$f":"'Internal Calc '!J27","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A17))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B17))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C17))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D17))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E17))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F17))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C28","v":""},{"$f":"'Internal Calc '!D28","v":0},{"$f":"'Internal Calc '!G28","v":0},0,{"$f":"'Internal Calc '!I28","v":0},{"$f":"'Internal Calc '!J28","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A18))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B18))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C18))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D18))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E18))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F18))),\"\")","v":""}]
[{"$f":"IF(B20=0,\"\",\"Total\")","v":""},{"$f":"SUM(B12:B18)","v":0},{"$f":"SUM(C12:C18)","v":0},{"$f":"SUM(D12:D18)","v":0},{"$f":"SUM(E12:E18)","v":0},{"$f":"SUM(F12:F18)","v":0},null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A19))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B19))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C19))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D19))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E19))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F19))),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A20))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B20))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C20))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$1:D$20,SMALL(IF($A$1:$A$20<>\"\",ROW(D$1:D$20)-ROW(D$1)+1),ROWS(D$1:D20))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E20))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F20))),\"\")","v":""}]