{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sales Order","Pricing Table","Promo Codes","Inputs","Calcs","LOA","TOLL FREE-Resporg","Sheet1","IP Justification Form"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":3,"defined_names":110,"comments":2,"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":"Sales Order","index":0,"n_rows":160,"n_cols":22,"rows_kept":160,"cut":false,"hidden":false,"merged":[[51,3,51,4],[52,3,52,4],[53,3,53,4],[39,3,39,4],[46,3,46,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[41,9,41,10],[51,9,51,10],[54,9,54,10],[54,1,54,4],[48,17,48,19],[53,6,53,7],[53,9,53,10],[69,1,69,10],[48,9,48,10],[49,9,49,10],[52,6,52,7],[50,9,50,10],[48,6,48,7],[49,6,49,7],[50,6,50,7],[42,9,42,10],[47,9,47,10],[41,6,41,7],[46,9,46,10],[51,6,51,7],[43,6,43,7],[42,6,42,7],[47,6,47,7],[43,9,43,10],[46,6,46,7],[62,6,62,8],[61,6,61,8],[95,7,95,10],[87,7,87,10],[93,7,93,10],[91,7,91,10],[89,7,89,10],[59,6,59,8],[44,9,44,10],[114,2,114,3],[115,9,115,10],[119,9,119,10],[119,2,119,3],[114,7,114,8],[110,9,110,10],[111,9,111,10],[118,9,118,10],[110,2,110,3],[112,7,112,8],[115,7,115,8],[112,9,112,10],[117,2,117,3],[113,7,113,8],[110,7,110,8],[113,9,113,10],[111,7,111,8],[55,6,55,10],[54,6,54,7],[44,6,44,7],[45,6,45,7],[109,2,109,3],[104,2,104,3],[157,9,157,10],[156,9,156,10],[120,2,120,3],[116,2,116,3],[107,2,107,3],[117,9,117,10],[114,9,114,10],[157,1,157,4],[156,1,156,4],[146,1,146,4],[126,2,126,4],[130,2,130,4],[125,2,125,4],[127,2,127,4],[154,1,154,4],[155,1,155,4],[151,1,151,4],[125,8,125,10],[111,2,111,3],[112,2,112,3],[115,2,115,3],[154,7,154,8],[147,9,147,10],[154,9,154,10],[57,15,58,15],[61,9,61,10],[90,2,90,3],[108,2,108,3],[66,3,66,4],[102,2,102,3],[97,2,97,3],[97,7,97,10],[93,2,93,3],[62,9,62,10],[85,7,85,10],[80,2,80,3],[81,2,81,3],[71,1,72,10],[59,9,59,10],[76,6,76,7],[65,6,65,8],[65,9,65,10],[85,2,85,3],[78,2,78,3],[87,2,87,3],[103,7,103,10],[107,9,107,10],[100,7,100,10],[7,8,7,10],[9,8,9,10],[8,8,8,10],[12,5,12,7],[11,2,11,4],[8,2,8,4],[12,8,12,10],[9,2,9,4],[12,2,12,4],[11,8,11,10],[7,2,7,4],[13,2,13,4],[13,8,13,10],[26,6,26,7],[28,6,28,7],[40,9,40,10],[17,2,17,4],[15,1,15,10],[25,6,25,7],[23,6,23,10],[16,6,16,7],[31,6,31,7],[30,6,30,7],[40,6,40,7],[32,3,32,4],[33,6,33,7],[32,6,32,7],[38,6,38,10],[40,3,40,4],[0,1,0,11],[5,8,5,10],[1,9,1,10],[1,2,1,5],[4,2,4,4],[4,8,4,10],[5,2,5,4],[3,1,3,10],[6,2,6,4],[6,8,6,10],[16,19,16,20],[16,2,16,4],[21,19,21,20],[20,2,20,4],[17,6,17,9],[29,15,34,15],[22,1,22,10],[17,19,17,20],[19,2,19,4],[17,16,17,18],[20,6,20,9],[29,6,29,7],[27,6,27,7],[18,2,18,4],[23,1,23,2],[16,8,16,9],[30,3,30,4],[31,3,31,4],[155,9,155,10],[151,7,151,10],[152,7,152,8],[130,8,130,10],[152,9,152,10],[153,9,153,10],[153,7,153,8],[148,9,148,10],[127,8,127,10],[128,8,128,10],[129,8,129,10],[121,9,121,10],[120,7,120,8],[121,7,121,8],[57,1,57,10],[126,8,126,10],[74,6,74,11],[66,1,66,2],[124,1,124,10],[120,9,120,10],[95,2,95,3],[105,2,105,3],[106,2,106,3],[70,1,70,10],[77,1,77,10],[91,2,91,3],[152,1,153,4],[121,2,121,3],[118,2,118,3],[103,2,103,3],[82,2,82,3],[65,1,65,2],[98,2,98,3],[65,3,65,4],[92,2,92,3],[79,2,79,3],[101,2,101,3],[88,2,88,3],[94,2,94,3],[89,2,89,3],[83,2,83,3],[99,2,99,3],[100,2,100,3],[86,2,86,3],[96,2,96,3],[129,2,129,4],[128,2,128,4],[113,2,113,3]]}
[null,"COMCAST BUSINESS CLASS HOSPITALITY SERVICE ORDER AGREEMENT  v.10.6.14"]
[null,"Account Name:","Americas Best Value Inn",null,null,null,null,null," ID#:"]
[]
[null,"CUSTOMER INFORMATION  (Service Location)"]
[null,"Address 1","1954 S church Street",null,null,null,null,"City","Murfreesboro",null,null,null,null,{"$f":"IF(I5=\"\",\"\",I5&\", \"&I6)","v":"Murfreesboro, Tennessee"}]
[null,"Address 2",null,null,null,null,null,"State","Tennessee"]
[null,"Primary Contact Name","Kenny Patel",null,null,null,null,"ZIP Code",37130]
[null,"Business Phone","615-896-6042",null,null,null,null,"County"]
[null,"Cell Phone",null,null,null,null,null,"Email Address","abvi654@gmail.com"]
[null,"Alt.Phone",null,null,null,null,null,"Primary Fax Number"]
[]
[null,"Technical Contact Name",null,null,null,null,null,"Technical Contact On-site?"]
[null,"Technical Contact Business Phone",null,null,null,"Technical Contact Email"]
[null,"Property Manager Contact Name",null,null,null," ",null,"Property Mgr Phone"]
[]
[null,"COMCAST BUSINESS CLASS HOSPITALITY SERVICES"]
[null," ","Selection (X)",null,null,null," ",null," ",null," "]
[null,"Hospitality Voice      ","X",null,null,null,"Service Term (Months)",null,null,null,36]
[null,"Hospitality Internet ","X",null,null,null,null,null," ",null," ",null,null,null,null,null," "]
[null,"Hospitality Video","X"]
[null,{"$f":"IF(P62=1,\"Business Class Public View TV\",\"Business Class Private View TV\")","v":"Business Class Public View TV"},null,null,null,null,"Total Number of Hotel Guest Rooms",null,null,null,115]
[]
[null,"COMCAST BUSINESS CLASS HOSPITALITY SERVICE DETAILS"]
[null,"Hospitality Voice*",null,null,null,null,"Hospitality Video*"]
[null,"VOICE SELECTIONS","Quantity","Unit Cost","Total Cost",null,"VIDEO SELECTIONS (In Room Only)",null,"#Rooms","Cost/Room","Total Cost"]
[null,"Full Featured Voice Lines",3,39.950000000000003,{"$f":"C26*D26","v":119.85000000000001},null,"Digital Standard",null,null,null,{"$f":"I26*J26","v":0}]
[null,"Basic Lines",3,24.95,{"$f":"C27*D27","v":74.849999999999994},null,"HD Standard",null,115,7,{"$f":"I27*J27","v":805}]
[null,"Toll Free Number",null,null,{"$f":"+C28*D28","v":0},null,"HBO",null,null,null,{"$f":"I28*J28","v":0}]
[null,"Voice - eMTA Equipment Fee",1,12.95,{"$f":"+C29*D29","v":12.95},null,"Showtime",null,null,null,{"$f":"I29*J29","v":0}]
[null,"Voicemail",null,null,{"$f":"+C30*D30","v":0},null,"VIDEO EQUIPMENT",null,"#Rooms / Select","Cost/Room","Total Cost"]
[null,"VOICE OPTIONS","Selection (X)","Total Cost",null,null,"DTA ",null,null,null,{"$f":"I31*J31","v":0}]
[null,"Directory Listing Suppression Fee",null,null,null,null,"DSTB ",null,null,null,{"$f":"I32*J32","v":0}]
[null,"Auto-Attendant",null,null,null,null,"HDSTB",null,null,null,{"$f":"I33*J33","v":0}]
[null,"*Voice offers & options not available in all markets.",null,null,null,null,"mini mDTA",null,"X",null,75]
[null,null,null,null,null,null,"mDTA"]
[null,null,null,null,null,null,"Q2Q","Select TV Type"]
[null,null,null,null,null,null,"   HD-DTA","Select Type",null,null,{"$f":"I37*J37","v":0}]
[null,null,null,null,null,null,"* In room only"]
[null,"Hospitality Internet*",null,null,null,null,"Business Class Public View TV",null,null,null,null,null,null,"Included Boxes","Type","SD Charge Count","HD Charge Count","Upgraded Outlet Discount","SD Tier 1","SD Tier 2","HD Tier 1","HD Tier 2"]
[null,"INTERNET SELECTIONS","Selection (X)","Total Cost",null,null,"TV SELECTIONS ",null,"Selection (X)","Total Cost",null,null,null,{"$f":"IF($G$39=\"Business Class Public View TV\",1,0)","v":1},"SD",{"$f":"IF(AND($O40=\"SD\",$I41=\"X\"),IF($I$54>=$N40,$I$54-$N40,0),IF(AND($O40=\"HD\",$I41=\"X\",$I$54>=($N40-$Q40)),$I$54-MAX(($N40-$Q40),0),0))","v":0},{"$f":"IF(AND($O40=\"HD\",$I41=\"X\"),IF($I$55>=$N40,$I$55-$N40,0),IF(AND($I41=\"X\",O40=\"SD\"),$I$55,0))","v":0},{"$f":"IF(AND(P40=0,Q40>0,O40=\"SD\"),MIN(Q40,(N40-$I$54))*'Pricing Table'!$K$37,0)","v":0},{"$f":"IF($I41=\"X\",IF($I$54=0,0,IF($I$54<9,P40,8-MAX($I$54-$P40,0))),0)","v":0},{"$f":"IF($I41=\"X\",P40-S40,0)","v":0},{"$f":"IF($I41=\"X\",IF($I$55=0,0,IF($I$55<9,Q40,8-MAX($I$55-$Q40,0))),0)","v":0},{"$f":"IF($I41=\"X\",Q40-U40,0)","v":0}]
[null,{"$f":"+'Pricing Table'!B45","v":"Starter - 1  Modem"},null,null,null,null,{"$f":"+'Pricing Table'!W22","v":"Basic"},null,null,null,null,null,null,{"$f":"IF($G$39=\"Business Class Public View TV\",1,0)","v":1},"SD",{"$f":"IF(AND($O41=\"SD\",$I42=\"X\"),IF($I$54>=$N41,$I$54-$N41,0),IF(AND($O41=\"HD\",$I42=\"X\",$I$54>=($N41-$Q41)),$I$54-MAX(($N41-$Q41),0),0))","v":0},{"$f":"IF(AND($O41=\"HD\",$I42=\"X\"),IF($I$55>=$N41,$I$55-$N41,0),IF(AND($I42=\"X\",O41=\"SD\"),$I$55,0))","v":0},{"$f":"IF(AND(P41=0,Q41>0,O41=\"SD\"),MIN(Q41,(N41-$I$54))*'Pricing Table'!$K$37,0)","v":0},{"$f":"IF($I42=\"X\",IF($I$54=0,0,IF($I$54<9,P41,8-MAX($I$54-$P41,0))),0)","v":0},{"$f":"IF($I42=\"X\",P41-S41,0)","v":0},{"$f":"IF($I42=\"X\",IF($I$55=0,0,IF($I$55<9,Q41,8-MAX($I$55-$Q41,0))),0)","v":0},{"$f":"IF($I42=\"X\",Q41-U41,0)","v":0}]
[null,{"$f":"+'Pricing Table'!B46","v":"Starter - 2  Modems"},"X",99.95,null,null,{"$f":"+'Pricing Table'!W23","v":"Digital Variety"},null,null,null,null,null,null,{"$f":"IF($G$39=\"Business Class Public View TV\",2,0)","v":2},"SD",{"$f":"IF(AND($O42=\"SD\",$I43=\"X\"),IF($I$54>=$N42,$I$54-$N42,0),IF(AND($O42=\"HD\",$I43=\"X\",$I$54>=($N42-$Q42)),$I$54-MAX(($N42-$Q42),0),0))","v":0},{"$f":"IF(AND($O42=\"HD\",$I43=\"X\"),IF($I$55>=$N42,$I$55-$N42,0),IF(AND($I43=\"X\",O42=\"SD\"),$I$55,0))","v":0},{"$f":"IF(AND(P42=0,Q42>0,O42=\"SD\"),MIN(Q42,(N42-$I$54))*'Pricing Table'!$K$37,0)","v":0},{"$f":"IF($I43=\"X\",IF($I$54=0,0,IF($I$54<9,P42,8-MAX($I$54-$P42,0))),0)","v":0},{"$f":"IF($I43=\"X\",P42-S42,0)","v":0},{"$f":"IF($I43=\"X\",IF($I$55=0,0,IF($I$55<9,Q42,8-MAX($I$55-$Q42,0))),0)","v":0},{"$f":"IF($I43=\"X\",Q42-U42,0)","v":0}]
[null,{"$f":"+'Pricing Table'!B47","v":"Deluxe 50"},null,null,null,null,{"$f":"+'Pricing Table'!W24","v":"Digital Standard"},null,null,null,null,null,null,{"$f":"IF($G$39=\"Business Class Public View TV\",2,0)","v":2},"SD",{"$f":"IF(AND($O43=\"SD\",$I44=\"X\"),IF($I$54>=$N43,$I$54-$N43,0),IF(AND($O43=\"HD\",$I44=\"X\",$I$54>=($N43-$Q43)),$I$54-MAX(($N43-$Q43),0),0))","v":0},{"$f":"IF(AND($O43=\"HD\",$I44=\"X\"),IF($I$55>=$N43,$I$55-$N43,0),IF(AND($I44=\"X\",O43=\"SD\"),$I$55,0))","v":0},{"$f":"IF(AND(P43=0,Q43>0,O43=\"SD\"),MIN(Q43,(N43-$I$54))*'Pricing Table'!$K$37,0)","v":0},{"$f":"IF($I44=\"X\",IF($I$54=0,0,IF($I$54<9,P43,8-MAX($I$54-$P43,0))),0)","v":0},{"$f":"IF($I44=\"X\",P43-S43,0)","v":0},{"$f":"IF($I44=\"X\",IF($I$55=0,0,IF($I$55<9,Q43,8-MAX($I$55-$Q43,0))),0)","v":0},{"$f":"IF($I44=\"X\",Q43-U43,0)","v":0}]
[null,{"$f":"+'Pricing Table'!B48","v":"Deluxe 75"},null,null,null,null,{"$f":"+'Pricing Table'!W25","v":"Digital Deluxe"},null,null,null,null,null,null,{"$f":"IF($G$39=\"Business Class Public View TV\",4,0)","v":4},"HD",{"$f":"IF(AND($O44=\"SD\",$I45=\"X\"),IF($I$54>=$N44,$I$54-$N44,0),IF(AND($O44=\"HD\",$I45=\"X\",$I$54>=($N44-$Q44)),$I$54-MAX(($N44-$Q44),0),0))","v":0},{"$f":"IF(AND($O44=\"HD\",$I45=\"X\"),IF($I$55>=$N44,$I$55-$N44,0),IF(AND($I45=\"X\",O44=\"SD\"),$I$55,0))","v":0},{"$f":"IF(AND(P44=0,Q44>0,O44=\"SD\"),MIN(Q44,(N44-$I$54))*'Pricing Table'!$K$37,0)","v":0},{"$f":"IF($I45=\"X\",IF($I$54=0,0,IF($I$54<9,P44,8-MAX($I$54-$P44,0))),0)","v":0},{"$f":"IF($I45=\"X\",P44-S44,0)","v":0},{"$f":"IF($I45=\"X\",IF($I$55=0,0,IF($I$55<9,Q44,8-MAX($I$55-$Q44,0))),0)","v":0},{"$f":"IF($I45=\"X\",Q44-U44,0)","v":0}]
[null,{"$f":"IF(+'Pricing Table'!B49=\"\",\"\",'Pricing Table'!B49)","v":"Deluxe 100 Plus"},null,null,null,null,{"$f":"+'Pricing Table'!W26","v":"Sports & Entertainment Deluxe"}]
[null,{"$f":"IF(+'Pricing Table'!B50=\"\",\"\",'Pricing Table'!B50)","v":"Equipment Fee: D3 Gateway(s)"},null,null,null,null,"TV OPTIONS  ",null," Selection (X)","Total Cost"]
[null,"INTERNET OPTIONS**","Selection (X)","Total Cost",null,null,{"$f":"+'Pricing Table'!W29","v":"Sports Pack**"}]
[null,"Static IP  - 1","X",14.95,null,null,{"$f":"+'Pricing Table'!W30","v":"Music Choice "}]
[null,"Static IP - 5",null,null,null,null,{"$f":"+'Pricing Table'!W31","v":"Canales Selecto***"}]
[null,"Static IP - 13",null,null,null,null,{"$f":"+'Pricing Table'!W32","v":"Other Equipment: mDTA"}]
[null,"Webhosting - Starter",null,null,null,null,{"$f":"+'Pricing Table'!W33","v":"Other Equipment: mini mDTA"}]
[null,"Webhosting - Business",null,null,null,null,{"$f":"+'Pricing Table'!W34","v":"Other Programming: "},null,null,null,null,null,null,"Qty Threshold","Price 1 Qty","Price 2 Qty"]
[null,"Webhosting - Commerce",null,null,null,null,"TV CONFIGURATION SUMMARY",null,"Quantity","Total Cost",null,null,null,1,1,{"$f":"IF(I54=\"\",0,+I54-O53)","v":0}]
[null,"Webhosting - Professional",null,null,null,null,{"$f":"+'Pricing Table'!W37","v":"Outlet plus equipment - SD"},null,null,{"$f":"IF($G$39=\"Business Class Public View TV\",SUMIF('Pricing Table'!$BD:$BD,\"SD\",'Pricing Table'!$BG:$BG),'Pricing Table'!X37*O53+'Pricing Table'!Y37*P53)","v":0},null,null,null,8,{"$f":"SUM(U40:U44)","v":0},{"$f":"SUM(V40:V44)","v":0}]
[null,"*Internet selections &  options not available in all markets.  ** If 5 or 13 static IPs are requested a static IP justification form is required.  Microsoft Outlook Office Email and Webhosting options are for back office use only.",null,null,null,null,{"$f":"+'Pricing Table'!W38","v":"Outlet plus equipment - HD "},null,null,{"$f":"IF($G$39=\"Business Class Public View TV\",SUMIF('Pricing Table'!$BD:$BD,\"HD\",'Pricing Table'!$BG:$BG),('Pricing Table'!X38*O54+'Pricing Table'!Y38*P54))","v":0}]
[null,null,null,null,null,null,{"$f":"IF('Pricing Table'!C18=\"Private View\",'Pricing Table'!B138,'Pricing Table'!B141)","v":"*Not available in room, home offices or private view establishments . Video selections & options not available in all markets.  **Available as add-on to Digital Standard & Digital Deluxe offers only.  ***Requires a Digital Set Top Box."}]
[]
[null,"COMCAST BUSINESS CLASS HOSPITALITY TOTAL SERVICE CHARGES"]
[null,"Installation ","Selection (X)","Unit Cost","Total Cost"]
[null,"Installation Fee ",null,null,0,null,"Total Monthly Service Charge",null,null,{"$f":"SUM(D41:E46,D48:E50,D51:E54,J41:K45,J47:K52,J54:K55,E26:E30,D32:E33,K26:K29,K31:K36)","v":1202.55}]
[null,"Voice Activation Fee*","X",null,{"$f":"SUM(C26+C27)*'Pricing Table'!D75","v":179.7}]
[null,"Auto-Attendant Setup Fee",null,null,{"$f":"+D62","v":0},null,"Promotion Code (if applicable)",null,null,null,null,null,null,null,"Private View (0) or Public View (1)",{"$f":"IF('Pricing Table'!C18=\"Public View\",1,0)","v":1},null,"Note"]
[null,"Voice Jack Fee",null,null,{"$f":"D63","v":0},null,"            Less Discount (if applicable)",null,null,null,null,null,null,null,null,null,null,"Macro Reference Row 63"]
[null,"Toll Free Activation Fee",null,null,{"$f":"C28*'Pricing Table'!D78","v":0}]
[null,"*per line activation fee, applies for any full featured or basic line",null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!D7=\"\",\"Custom Installation Charge May Apply… Enter OSP/ISP Capex on Inputs tab\",\"\")","v":"Custom Installation Charge May Apply… Enter OSP/ISP Capex on Inputs tab"},null,null,"On - Off Driver","Standard Cjharge","Const Charge Override","Construction Charge Trigger"]
[null,"Total Installation Charges:",null,{"$f":"+SUM(E60:E64)","v":179.7},null,null,"Total Recurring Monthly Bill:* ",null,null,{"$f":"IF(N66=0,O66,P66)","v":1202.55},null,null,null,{"$f":"IF(Calcs!F12=\"\",0,1*Q66)","v":0},{"$f":"IF(Calcs!D167<0,\"Requires Custom Installation Charge\",+J60-J63)","v":1202.55},{"$f":"'[3]Sales Order Form 3'!$Y$32=+J60-J63","v":false},1]
[null,"Total Custom Installation Charges:",null,{"$f":"IF(Inputs!D7=\"\",\"Charge May Apply\",ROUNDUP(Calcs!D147,0))","v":"Charge May Apply"},null,null,null,"*Applicable federal, state, and local taxes and fees may apply.",null,null,null,null,null,"Format Driver",{"$f":"IF(AND(0.25<P67,P67<0.35),1,IF(AND(0.15<P67,P67<0.25),2,IF(P67<0.15,3,0)))","v":0},{"$f":"+Calcs!B17","v":2.0301508726046844}]
[]
[null,"General Instructions"]
[null,{"$f":"IF(ISERROR(VLOOKUP($J$62,'Promo Codes'!$A:$B,2,FALSE)),\"\",VLOOKUP('Sales Order'!$J$62,'Promo Codes'!$A:$B,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"COMCAST BUSINESS CLASS HOSPITALITY VOICE CONFIGURATION DETAILS"]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[]
[null,"Phone # (List \"New\" if new #)","Type",null,"Voicemail",null,null,"Customer Equipment"]
[null,null,null,null,null," ",null,"Phone System Type (Key System, PBX, Other)"]
[null,null,null,null,null," "]
[null,null,null,null,null," ",null,"Phone System Manufacturer"]
[null,null,null,null,null," "]
[null,null,null,null,null," ",null,"Fax Machine Manufacturer"]
[null,null,null,null,null," "]
[null,null,null,null,null," ",null,"Alarm System Vendor"]
[]
[null,null,null,null,null,null," ","Point of Sale Device"]
[]
[null,null,null,null,null,null," ","Telco Closet Location"]
[]
[]
[]
[null,null,null,null,null,null,null,"Hunt Group Configuration Details"]
[]
[null,null,null,null,null,null,null,"Hunt Group Features Requested (Yes, No)"]
[]
[null,null,null,null,null,null,null,"Hunt Group Configuration Type"]
[]
[null,null,null,null,null,null,null,"Hunt Group 1 Pilot Number",null,"     Hunt Group 2 Pilot Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sequential"]
[null,null,null,null,null,null,null,"Directory Listing and Yellow Page Details"]
[null,null,null,null,null,null,null,"Directory Listing"]
[null,null,null,null,null,null,null,"Directory Listing Phone Number"]
[null,null,null,null,null,null,null,"Directory Listing Display Name"]
[null,null,null,null,null,null,null,"DA/DL Header Text Information"]
[null,null,null,null,null,null,null,"DA/DL Header Code Information"]
[null,null,null,null,null,null,null,"Standard Industry Code Information"]
[null,"Toll Free #","Calling Origination Area",null,"Associated TN",null,null,"Additional Voice Details"]
[null,null,null,null,null,null,null,"Caller ID"]
[null,null,null,null,null,null,null,"Caller ID Display Name (max 15 characters)"]
[null,null,null,null,null,null,null,"Call Blocking"]
[null,null,null,null,null,null,null,"Auto-Attendant"]
[null,null,null,null,null,null,null,"Standard Industry Code Information"]
[]
[]
[null,"CUSTOMER BILLING INFORMATION"]
[null,"Billing Account Name",null,null,null,null,null,"City"]
[null,"Billing Name (3rd Party Accounts)",null,null,null,null,null,"State"]
[null,"Address 1",null,null,null,null,null,"ZIP Code"]
[null,"Address 2",null,null,null,null,null,"Billing Contact Email"]
[null,"Billing Contact Name",null,null,null,null,null,"Billing Contact Bus. Phone"]
[null,"Tax Exempt?* ",null,null,null,null,null,"Billing Fax Number"]
[null,null,"*If yes, please provide and attach tax exemption certificate."]
[]
[]
[null,"\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NorthEast-SMB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central-SMB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West-SMB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NationalSales-NorthEast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NationalSales-Central"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NationalSales-West"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NorthEast-ENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central-ENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West-ENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NorthEast-TLK Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central-TLK Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West-TLK Group"]
[]
[]
[]
[]
[]
[null,"CUSTOMER SIGNATURE",null,null,null,null,null,"FOR COMCAST USE ONLY"]
[null,"By signing below, customer agrees and accepts the Terms and Conditions of this Agreement.  General Terms and Conditions can be found at: http://business.comcast.com/terms-conditions",null,null,null,null,null,"Sales Representative:"]
[null,null,null,null,null,null,null,"Sales Representative Code:"]
[null,"   Signature:",null,null,null,null,null,"Sales Manager/Director:"]
[null,"   Print:",null,null,null,null,null,null,"Sales Manager/Director Approval:"]
[null,"   Title:",null,null,null,null,null,null,"Division:"]
[null,"   Date:",null,null,null,null,null,null,"Opportunity ID:",{"$f":"IF(+J2=\"\",\"\",+J2)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"v8 1.23"]

{"sheet":"Pricing Table","index":1,"n_rows":141,"n_cols":70,"rows_kept":141,"cut":false,"hidden":true,"merged":[[33,1,33,2],[35,1,35,2],[31,1,31,2],[137,1,137,6],[140,1,140,6],[40,1,40,6],[36,1,36,2],[37,1,37,2],[25,8,25,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[29,1,29,2],[30,1,30,2],[21,1,21,2],[27,1,27,2],[28,1,28,2],[24,1,24,2],[24,8,24,9],[61,1,61,2],[3,1,3,5],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[22,1,22,2],[23,1,23,2],[19,1,19,5],[32,1,32,2],[30,15,30,16],[31,15,31,16],[32,15,32,16],[33,15,33,16],[33,8,33,9],[31,8,31,9],[32,8,32,9],[17,2,17,3],[19,15,19,19],[21,15,21,16],[22,15,22,16],[23,15,23,16],[19,8,19,12],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,15,24,16],[25,15,25,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[59,8,59,9],[35,15,35,16],[36,15,36,16],[37,15,37,16],[40,15,40,20],[56,8,56,9],[57,8,57,9],[55,8,55,9],[49,8,49,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[40,8,40,13]]}
[]
[]
[null,"Pricing Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public View Pricing Table"]
[null,"Hospitality Video",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUTLET CONFIGURATION",null,null,null,null,"SD Left","HD Left","Box Type","DTA Count",null,null,"OUTLET CALCS","1-8","9+"]
[null,"VIDEO SELECTIONS (In Room Only)",null,"Price #1","Price #2","Price #3","Price #4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+","Price #5+",null,null,"OUTLET","Outlet Type","Included","Incl Type","Price",{"$f":"BO8","v":0},{"$f":"BO9","v":0},null,0,null,null,"Outlet plus equipment - SD",9.9499999999999993,5.95]
[null,"Digital Standard",null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"+X6+1","v":10},{"$f":"+Y6+1","v":11},12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,{"$f":"+AW6+1","v":35},36,37,null,null,1,{"$f":"IF($BI5>0,IF(AND($BF6=\"SD\",$BH5>0),\"SD\",\"HD\"),IF(BH5>0,\"SD\",\"\"))","v":""},{"$f":"BC6<=SUM($BP$8:$BP$9)","v":false},{"$f":"IF(BE6,IF($BP$8>0,$BN$8,IF($BP$9>0,$BN$9)),\"\")","v":""},{"$f":"IF(BF6=BD6,0,INDEX($BO$5:$BP$6,MATCH($BD6,$BN$8:$BN$9,0),IF(BC6>8,2,1)))","v":0},{"$f":"IF($BD6=\"SD\",SUM(BH5,-1),BH5)","v":0},{"$f":"IF($BD6=\"HD\",SUM(BI5,-1),BI5)","v":0},"",0,null,null,"Outlet plus equipment - HD ",12.95,8.9499999999999993]
[null,"HD Standard",null,7,9,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"",{"$f":"BC7<=SUM($BP$8:$BP$9)","v":false},{"$f":"IF(BE7,IF($BP$8>0,$BN$8,IF($BP$9>0,$BN$9)),\"\")","v":""},{"$f":"IF(BF7=BD7,0,INDEX($BO$5:$BP$6,MATCH($BD7,$BN$8:$BN$9,0),IF(BC7>8,2,1)))","v":0},{"$f":"IF($BD7=\"SD\",SUM(BH6,-1),BH6)","v":0},{"$f":"IF($BD7=\"HD\",SUM(BI6,-1),BI6)","v":0},"",0,null,null,"Current Requests","Req","Incl","Charge"]
[null,"HBO",null,3.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"",false,"",0,0,0,"",0,null,null,"SD",{"$f":"'Sales Order'!I54","v":0},{"$f":"SUMIF($BO$12:$BO$16,$BN8,$BR$12:$BR$16)","v":0},0]
[null,"Showtime",null,3.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF($BI8>0,IF(AND($BF9=\"SD\",$BH8>0),\"SD\",\"HD\"),IF(BH8>0,\"SD\",\"\"))","v":""},false,"",0,0,0,"",0,null,null,"HD",{"$f":"'Sales Order'!I55","v":0},{"$f":"SUMIF($BO$12:$BO$16,$BN9,$BR$12:$BR$16)","v":0},0]
[null,"VIDEO EQUIPMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF($BI9>0,IF(AND($BF10=\"SD\",$BH9>0),\"SD\",\"HD\"),IF(BH9>0,\"SD\",\"\"))","v":""},false,"",0,0,0,"",0]
[null,"DTA ",null,0.55000000000000004,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"",false,"",0,0,0,"",0,null,null,"INCLUDED OUTLETS","Type","Incl Count"]
[null,"DSTB ",null,2.2000000000000002,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"",false,"",0,0,0,"",0,null,null,"Basic","SD",1,null,{"$f":"IFERROR(BN12=INDEX('Sales Order'!$G$41:$G$45,MATCH(\"X\",'Sales Order'!$I$41:$I$45,0)),FALSE)*BP12","v":0}]
[null,"HDSTB",null,2.2000000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"",false,"",0,0,0,"",0,null,null,"Digital Variety","SD",1,null,{"$f":"IFERROR(BN13=INDEX('Sales Order'!$G$41:$G$45,MATCH(\"X\",'Sales Order'!$I$41:$I$45,0)),FALSE)*BP13","v":0}]
[null,"mini mDTA",null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"",false,"",0,0,0,null,0,null,null,"Digital Standard","SD",2,null,{"$f":"IFERROR(BN14=INDEX('Sales Order'!$G$41:$G$45,MATCH(\"X\",'Sales Order'!$I$41:$I$45,0)),FALSE)*BP14","v":0}]
[null,"mDTA",null,200,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"",false,"",0,0,0,null,0,null,null,"Digital Deluxe","SD",2,null,{"$f":"IFERROR(BN15=INDEX('Sales Order'!$G$41:$G$45,MATCH(\"X\",'Sales Order'!$I$41:$I$45,0)),FALSE)*BP15","v":0}]
[null,"Q2Q",null,285,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"",false,"",0,0,0,null,0,null,null,"Sports & Entertainment Deluxe","HD",4,null,{"$f":"IFERROR(BN16=INDEX('Sales Order'!$G$41:$G$45,MATCH(\"X\",'Sales Order'!$I$41:$I$45,0)),FALSE)*BP16","v":0}]
[null,"HD-DTA",null,0.95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"",false,"",0,0,0,null,0]
[null,"Select Private View or Public View",{"$f":"IF('Sales Order'!G39=\"Business Class Private View TV\",\"Private View\",\"Public View\")","v":"Public View"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"",false,"",0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"",false,"",0,0,0,null,0]
[null,"Business Class Private View TV",null,null,null,null,null,null,"Business Class Public View TV",null,null,null,null,null,null,"Usable Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"",false,"",0,0,0,null,0]
[null,"TV SELECTIONS ",null,"Price #1","Price #2","Price #3","Price #4",null,"TV SELECTIONS ",null,"Price #1","Price #2","Price #3","Price #4",null,"TV SELECTIONS ",null,"Price #1","Price #2","Price #3","Price #4",null,null,"Price #1","Price #2","Price #3","Price #4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"",false,"",0,0,0,null,0]
[null,"Basic",null,4.95,24.95,null,null,null,"Basic",null,29.95,null,null,null,null,{"$f":"IF($C$18=\"Private View\",B22,I22)","v":"Basic"},null,{"$f":"IF($C$18=\"Private View\",D22,K22)","v":29.95},0,0,0,{"$f":"IF(P22=\"\",0,IF(P22=0,0,1))","v":1},{"$f":"IF(V22=1,+P22,\"\")","v":"Basic"},{"$f":"IF(R22>0,R22,\"\")","v":29.95},{"$f":"IF(S22>0,S22,\"\")","v":""},{"$f":"IF(T22>0,T22,\"\")","v":""},{"$f":"IF(U22>0,U22,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"",false,"",0,0,0,null,0]
[null,"Select",null,14.95,34.950000000000003,null,null,null,"Digital Variety",null,54.95,null,null,null,null,{"$f":"IF($C$18=\"Private View\",B23,I23)","v":"Digital Variety"},null,54.95,0,0,0,1,"Digital Variety",{"$f":"IF(R23>0,R23,\"\")","v":54.95},{"$f":"IF(S23>0,S23,\"\")","v":""},{"$f":"IF(T23>0,T23,\"\")","v":""},{"$f":"IF(U23>0,U23,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"",false,"",0,0,0,null,0]
[null,"Variety",null,29.95,44.95,null,null,null,"Digital Standard",null,84.95,null,null,null,null,{"$f":"IF($C$18=\"Private View\",B24,I24)","v":"Digital Standard"},null,84.95,0,0,0,1,"Digital Standard",84.95,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"",false,"",0,0,0,null,0]
[null,"Standard",null,59.95,74.95,null,null,null,"Digital Deluxe",null,109.95,null,null,null,null,{"$f":"IF($C$18=\"Private View\",B25,I25)","v":"Digital Deluxe"},null,109.95,0,0,0,1,"Digital Deluxe",109.95,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"",false,"",0,0,0,null,0]
[null,"Preferred",null,74.95,89.95,null,null,null,"Sports & Entertainment Deluxe",null,189.95,null,null,null,null,{"$f":"IF($C$18=\"Private View\",B26,I26)","v":"Sports & Entertainment Deluxe"},null,189.95,0,0,0,1,"Sports & Entertainment Deluxe",189.95,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"",false,"",0,0,0,null,0]
[null,"Music Choice Standalone",null,39.950000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,"",{"$f":"IF(R27>0,R27,\"\")","v":""},{"$f":"IF(S27>0,S27,\"\")","v":""},{"$f":"IF(T27>0,T27,\"\")","v":""},{"$f":"IF(U27>0,U27,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"",false,"",0,0,0,null,0]
[null,"TV OPTIONS  ",null,null,null,null,null,null,"TV OPTIONS  ",null,null,null,null,null,null,"TV OPTIONS  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"",false,"",0,0,0,null,0]
[null,"Sports Pack**",null,8.9499999999999993,null,null,null,null,"Sports Pack**",null,34.950000000000003,null,null,null,null,{"$f":"IF($C$18=\"Private View\",B29,I29)","v":"Sports Pack**"},null,{"$f":"IF($C$18=\"Private View\",D29,K29)","v":34.950000000000003},0,0,0,{"$f":"IF(P29=\"\",0,IF(P29=0,0,1))","v":1},{"$f":"IF(V29=1,+P29,\"\")","v":"Sports Pack**"},{"$f":"IF(R29>0,R29,\"\")","v":34.950000000000003},{"$f":"IF(S29>0,S29,\"\")","v":""},{"$f":"IF(T29>0,T29,\"\")","v":""},{"$f":"IF(U29>0,U29,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"",false,"",0,0,0,null,0]
[null,"Music Choice ",null,29.95,39.950000000000003,null,null,null,"Music Choice ",null,29.95,null,null,null,null,"Music Choice ",null,29.95,0,0,0,1,"Music Choice ",29.95,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"",false,"",0,0,0,null,0]
[null,"Canales Selecto***",null,15.95,null,null,null,null,"Canales Selecto***",null,15.95,null,null,null,null,"Canales Selecto***",null,15.95,0,0,0,1,"Canales Selecto***",15.95,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"",false,"",0,0,0,null,0]
[null,"Other Equipment: mDTA",null,450,null,null,null,null,"Other Equipment: mDTA",null,450,null,null,null,null,"Other Equipment: mDTA",null,450,0,0,0,1,"Other Equipment: mDTA",450,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"",false,"",0,0,0,null,0]
[null,"Other Equipment: mini mDTA",null,200,null,null,null,null,"Other Equipment: mini mDTA",null,200,null,null,null,null,"Other Equipment: mini mDTA",null,200,0,0,0,1,"Other Equipment: mini mDTA",200,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"",false,"",0,0,0,null,0]
[null,"Other Programming: ",null,null,null,null,null,null,"Other Programming: ",null,null,null,null,null,null,"Other Programming: ",null,0,0,0,0,1,"Other Programming: ","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"",false,"",0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(P35=\"\",0,IF(P35=0,0,1))","v":0},"","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"",false,"",0,0,0,null,0]
[null,"TV CONFIGURATION SUMMARY",null,null,null,null,null,null,"TV CONFIGURATION SUMMARY",null,null,null,null,null,null,"TV CONFIGURATION SUMMARY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"",false,"",0,0,0,null,0]
[null,"Outlet plus equipment  ",null,0,9.9499999999999993,null,null,null,"Outlet plus equipment - SD",null,9.9499999999999993,5.95,null,null,null,{"$f":"IF($C$18=\"Private View\",B37,I37)","v":"Outlet plus equipment - SD"},null,{"$f":"IF($C$18=\"Private View\",D37,K37)","v":9.9499999999999993},5.95,0,0,{"$f":"IF(P37=\"\",0,IF(P37=0,0,1))","v":1},{"$f":"IF(V37=1,+P37,\"\")","v":"Outlet plus equipment - SD"},{"$f":"IF(R37>0,R37,0)","v":9.9499999999999993},{"$f":"IF(S37>0,S37,\"\")","v":5.95},{"$f":"IF(T37>0,T37,\"\")","v":""},{"$f":"IF(U37>0,U37,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"",false,"",0,0,0,null,0]
[null,"HD Box Charges",null,5,5,null,null,null,"Outlet plus equipment - HD ",null,12.95,8.9499999999999993,null,null,null,{"$f":"IF($C$18=\"Private View\",B38,I38)","v":"Outlet plus equipment - HD "},null,12.95,8.9499999999999993,0,0,{"$f":"IF(P38=\"\",0,IF(P38=0,0,1))","v":1},{"$f":"IF(V38=1,+P38,\"\")","v":"Outlet plus equipment - HD "},{"$f":"IF(R38>0,R38,\"\")","v":12.95},{"$f":"IF(S38>0,S38,\"\")","v":8.9499999999999993},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"",false,"",0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P39=\"\",0,IF(P39=0,0,1))","v":0},{"$f":"IF(V39=1,+P39,\"\")","v":""},"",{"$f":"IF(S39>0,S39,\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"",false,"",0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"",false,"",0,0,0,null,0]
[null,"*Not available in room, home offices or public view establishments . Video selections & options not available in all markets.  **Available as add-on to Digital Standard & Digital Preferred offers only.  ***Requires a Digital Set Top Box, Not Available with Music Choice Standalone selection. ",null,null,null,null,null,null,"*Not available in room, home offices or private view establishments . Video selections & options not available in all markets.  **Available as add-on to Digital Standard & Digital Deluxe offers only.  ***Requires a Digital Set Top Box.",null,null,null,null,null,null,"*Not available in room, home offices or private view establishments . Video selections & options not available in all markets.  **Available as add-on to Digital Standard & Digital Deluxe offers only.  ***Requires a Digital Set Top Box.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"",false,"",0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"",false,"",0,0,0,null,0]
[null,"Hospitality Internet",null,null,null,null,null,null,"Alternate / Revised Hospitality Internet - NOT IN USE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"",false,"",0,0,0,null,0]
[null,"INTERNET SELECTIONS","Alt Name","Price #1","Price #2","Price #3","Price #4",null,"INTERNET SELECTIONS","Alt Name","Price #1","Price #2","Price #3","Price #4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"",false,"",0,0,0,null,0]
[null,"Starter - 1  Modem",null,69.95,null,null,null,null,"Starter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"",false,"",0,0,0,null,0]
[null,"Starter - 2  Modems",null,99.95,null,null,null,null,"Deluxe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"",false,"",0,0,0,null,0]
[null,"Deluxe 50",null,299.95,null,null,null,null,"Deluxe 75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"",false,"",0,0,0,null,0]
[null,"Deluxe 75",null,399.95,null,null,null,null,"Deluxe 100 Plus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"",false,"",0,0,0,null,0]
[null,"Deluxe 100 Plus",null,499.95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"",false,"",0,0,0,null,0]
[null,"Equipment Fee: D3 Gateway(s)",null,9.9499999999999993,12.95,0,null,null,"Equipment Fee: D3 Gateway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"",false,"",0,0,0,null,0]
[null,"INTERNET OPTIONS**",null,null,null,null,null,null,"INTERNET OPTIONS**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"",false,"",0,0,0,null,0]
[null,"Static IP  - 1",null,14.95,29.9,null,null,null,"Static IP  - 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"",false,"",0,0,0,null,0]
[null,"Static IP - 5",null,19.95,39.9,null,null,null,"Static IP - 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"",false,"",0,0,0,null,0]
[null,"Static IP - 13",null,34.950000000000003,69.900000000000006,null,null,null,"Static IP - 13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"",false,"",0,0,0,null,0]
[null,"Webhosting - Starter",null,"Included",null,null,null,null,"Webhosting - Starter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"",false,"",0,0,0,null,0]
[null,"Webhosting - Business",null,19.95,null,null,null,null,"Webhosting - Business"]
[null,"Webhosting - Commerce",null,39.950000000000003,null,null,null,null,"Webhosting - Commerce"]
[null,"Webhosting - Professional",null,79.95,null,null,null,null,"Webhosting - Professional"]
[]
[null,"Equipment Fee D3 Gateway Selection",null,"X",null,null,null,null,"Equipment Fee D3 Gateway Selection",null,{"$f":"IF('Sales Order'!K41<99,\"X - Qty-1\", \"X - Qty-2\")","v":"X - Qty-1"}]
[]
[null,"Hospitality Voice"]
[null,"VOICE SELECTIONS",null,"Price #1","Price #2","Price #3","Price #4"]
[null,"Full Featured Voice Lines",null,59.95,39.950000000000003]
[null,"Basic Lines",null,24.95]
[null,"Toll Free Number",null,5]
[null,"Voice - eMTA Equipment Fee",null,9.9499999999999993,12.95]
[null,"Voicemail",null,5]
[]
[null,"VOICE OPTIONS"]
[null,"Directory Listing Suppression Fee"]
[null,"Auto-Attendant"]
[]
[null,"Installation "]
[null,"Voice Activation Fee*","$29.95 / Line",29.95]
[null,"Auto-Attendant Setup Fee"]
[null,"Voice Jack Fee"]
[null,"Toll Free Activation Fee","$9.95 / Line",9.9499999999999993]
[]
[]
[]
[]
[]
[]
[]
[null,"State Listing","Voice Line Type"]
[null,"Alabama","Not Applicable"]
[null,"Arizona","Pilot"]
[null,"Arkansas","Fax"]
[null,"California","Voice"]
[null,"Colorado","Auto-Attendant"]
[null,"Connecticut","Full Featured Line"]
[null,"Delaware","Basic Line"]
[null,"District of Columbia"]
[null,"Georgia"]
[null,"Florida"]
[null,"Idaho"]
[null,"Illinois"]
[null,"Indiana"]
[null,"Iowa"]
[null,"Kansas"]
[null,"Kentucky"]
[null,"Louisiana"]
[null,"Maine"]
[null,"Maryland"]
[null,"Massachusetts"]
[null,"Michigan"]
[null,"Minnesota"]
[null,"Mississippi"]
[null,"Missouri"]
[null,"Montanta"]
[null,"Nebraska"]
[null,"Nevada"]
[null,"New Hampshire"]
[null,"New Jersey"]
[null,"New Mexico"]
[null,"New York"]
[null,"North Carolinia"]
[null,"North Dakota"]
[null,"Ohio"]
[null,"Oklahoma"]
[null,"Oregon"]
[null,"Pennsylvania"]
[null,"Rhode Island"]
[null,"South Carolina"]
[null,"South Dakota"]
[null,"Tennessee"]
[null,"Texas"]
[null,"Utah"]
[null,"Vermont"]
[null,"Virginia"]
[null,"Washington"]
[null,"West Virginia"]
[null,"Wisconsin"]
[null,"Wyoming"]
[]
[null,"Private View Language"]
[null,"*Not available in room, home offices or public view establishments . Video selections & options not available in all markets.  **Available as add-on to Digital Standard & Digital Preferred offers only.  ***Requires a Digital Set Top Box, Not Available with Music Choice Standalone selection. "]
[]
[null,"Public View Language"]
[null,"*Not available in room, home offices or private view establishments . Video selections & options not available in all markets.  **Available as add-on to Digital Standard & Digital Deluxe offers only.  ***Requires a Digital Set Top Box."]

{"sheet":"Promo Codes","index":2,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Promo Code","Promo Description"]
["HOSPITALITY","."]
["HOSP:HIStarter-$30","$30 MRC Discount off Hospitality Internet Starter (2 modem solution)($99.95) for discounted rate of $69.95. Purchase of Hospitality Free To Guest Video Required. MRC Discounts roll to rate card end of original term. Minimum 3 year term required, 5 year if HD FTG Video. 50 rooms or less locations. Taxes, Usage, Fees, Equip are Extra"]
["HOSP:HID75-$150","$150 MRC Discount off Hospitality Internet D75 ($399.95) for discounted rate of $249.95. Purchase of Hospitality Free To Guest Video Required. MRC Discounts roll to rate card end of original term. Minimum 3 year term required, 5 year if HD FTG Video. Taxes, Usage, Fees, Equip are Extra"]
["HOSP:HID100+-$150_3yr","$150 MRC Discount off Hospitality Internet D100+ ($499.95) for discounted rate of $349.95. Purchase of Hospitality Free To Guest Video Required. MRC Discounts roll to rate card end of original term. Minimum 3 year term required, 5 year if HD FTG Video. Taxes, Usage, Fees, Equip are Extra"]
["HOSP:HID50-$100_3yr","$100 MRC Discount off Hospitality Internet D50 ($299.95) for discounted rate of $199.95. Purchase of Hospitality Free To Guest Video Required. MRC Discounts roll to rate card end of original term. Minimum 3 year term required, 5 year if HD FTG Video. Taxes, Usage, Fees, Equip are Extra"]
["HOSP_$7FTGHD","$7 per room Hospitality FTG HD Video, a $4 MRC discount off rate card of $11 per room. Minimum Deluxe 50 Hospitality Internet or Ethernet Required. Minimum 65 room location required. 5 year term required. MRC Discount rolls to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["HOSP_$7FTGHD_HID75-$150","$7 per room Hospitality FTG HD Video, a $4 MRC discount off rate card of $11 per room. $150 MRC Discount off Hospitality Internet Deluxe 75 ($399.95) for discounted rate of $249.95. Minimum 65 room location required. 5 year term required. MRC Discounts roll to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["HOSP_$7FTGHD_HID100+-$150","$7 per room Hospitality FTG HD Video, a $4 MRC discount off rate card of $11 per room. $150 MRC Discount off Hospitality Internet Deluxe 100+ ($499.95) for discounted rate of $349.95. Minimum 65 room location required. 5 year term required. MRC Discounts roll to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["HOSP_$7FTGHD_HID50-$100"," $7 per room Hospitality FTG HD Video, a $4 MRC discount off rate card of $11 per room. $100 MRC Discount off Hospitality Internet Deluxe 50 ($299.95) for discounted rate of $199.95. Minimum 65 room location required. 5 year term required. MRC Discounts roll to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["HOSP_$9FTGHD","$9 per room Hospitality FTG HD Video, a $2 MRC discount off rate card of $11 per room. Minimum Deluxe 50 Hospitality Internet or Ethernet Required. Minimum 65 room location required. 5 year term required. MRC Discount rolls to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["HOSP_$9FTGHD_HID75-$150","$9 per room Hospitality FTG HD Video, a $2 MRC discount off rate card of $11 per room. $150 MRC Discount off Hospitality Internet Deluxe 75 ($399.95) for discounted rate of $249.95. Minimum 65 room location required. 5 year term required. MRC Discounts roll to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["HOSP_$9FTGHD_HID100+-$150","$9 per room Hospitality FTG HD Video, a $2 MRC discount off rate card of $11 per room. $150 MRC Discount off Hospitality Internet Deluxe 100+ ($499.95) for discounted rate of $349.95. Minimum 65 room location required. 5 year term required. MRC Discounts roll to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["HOSP_$9FTGHD_HID50-$100","$9 per room Hospitality FTG HD Video, a $2 MRC discount off rate card of $11 per room. $100 MRC Discount off Hospitality Internet Deluxe 50 ($299.95) for discounted rate of $199.95. Minimum 65 room location required. 5 year term required. MRC Discounts roll to rate card at end of original term. Taxes, Usage, Equipment, Fees are extra"]
["#BCTPRI1FullBPHosp","1 Full Business Class Trunk PRI for $389, a $100 PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullBPHosp","2 Full Business Class Trunk PRI for $738, a $240 total PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracBPHosp","1 Fractional Business Class Trunk PRI for $299, a $50 PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracBPHosp","2 Fractional Business Class Trunk PRI for $448, a $150 total PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5BPHosp","1 Full and 1 Fractional Business Class Trunk PRI for $638, a $200 total PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FullBPHospWVI","1 Full Business Class Trunk PRI for $389, a $100 PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullBPHospWVI","2 Full Business Class Trunk PRI for $738, a $240 total PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracBPHospWVI","1 Fractional Business Class Trunk PRI for $299, a $50 PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracBPHospWVI","2 Fractional Business Class Trunk PRI for $448, a $150 total PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5BPHospWVI","1 Full and 1 Fractional Business Class Trunk PRI for $638, a $200 total PRI MRC discount. Discount rolls to rate card at end of original term. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FullHosp1mfr","1 Full (1 x 23 channel) Business Class Trunk PRI for $489, plus 1 month waived of PRI MRC, value of $489, reflected on the bill in month 2 or 3. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullHosp1mfr","2 Full Business Class Trunk PRI for $838, a $140 total PRI MRC discount. 1 month waived of PRI MRC, value of $978, reflected on the bill in month 2 or 3.  For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracHosp1mfr","1 Fractional (1 x 6 channel) Business Class Trunks PRI  (PRI)for $349, plus 1 month waived of PRI MRC, value of $349, reflected on the bill in month 2 or 3. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracHosp1mfr","2 Fractional Business Class Trunk PRI for $598, a $100 total PRI MRC discount. 1 month waived of PRI MRC, value of $698, reflected on the bill in month 2 or 3.   For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5Hosp1mfr","1 Full and 1 Fractional Business Class Trunk PRI for $738, a $100 total PRI MRC discount. 1 month waived of PRI MRC, value of $838, reflected on the bill in month 2 or 3. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FullHosp2mfr","1 Full Business Class Trunk PRI for $489. 2 months waived of PRI MRC, value of $489 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullHosp2mfr","2 Full Business Class Trunk PRI for $838, a $140 total PRI MRC discount. 2 months waived of PRI MRC, value of $978 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracHosp2mfr","1 Fractional Business Class Trunk PRI for $349. 2 months waived of PRI MRC, value of $349 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracHosp2mfr","2 Fractional Business Class Trunk PRI for $598, a $100 total PRI MRC discount. 2 months waived of PRI MRC, value of $698 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5Hosp2mfr","1 Full and 1 Fractional Business Class Trunk PRI for $738, a $100 total PRI MRC discount. 2 months waived of PRI MRC, value of $838, reflected on the bill in month 2 or 3. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FullHospWVI","1 Full Business Class Trunk PRI for $489. Standard Installation Waived, expedited orders excluded. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullHospWVI","2 Full Business Class Trunk PRI for $838, a $140 total PRI MRC discount. Discount rolls to rate card at end of original term. Standard Installation Waived, expedited orders excluded. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracHospWVI","1 Fractional Business Class Trunk PRI for $349. Standard Installation Waived, expedited orders excluded. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracHospWVI","2 Fractional Business Class Trunk PRI for $598, a $100 total PRI MRC discount. Discount rolls to rate card at end of original term. Standard Installation Waived, expedited orders excluded. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5HospWVI","1 Full and 1 Fractional Business Class Trunk PRI for $738, a $100 total PRI MRC discount. Discount rolls to rate card at end of original term. Standard Installation Waived, expedited orders excluded. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FullHosp1mfrWVI","1 Full (1 x 23 channel) Business Class Trunk PRI for $489, plus 1 month waived of PRI MRC, value of $489, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullHosp1mfrWVI","2 Full Business Class Trunk PRI for $838, a $140 total PRI MRC discount. 1 month waived of PRI MRC, value of $978, reflected on the bill in month 2 or 3.  For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracHosp1mfrWVI","1 Fractional (1 x 6 channel) Business Class Trunks PRI  (PRI)for $349, plus 1 month waived of PRI MRC, value of $349, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracHosp1mfrWVI","2 Fractional Business Class Trunk PRI for $598, a $100 total PRI MRC discount. 1 month waived of PRI MRC, value of $698, reflected on the bill in month 2 or 3.  For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5Hosp1mfrWVI","1 Full and 1 Fractional Business Class Trunk PRI for $738, a $100 total PRI MRC discount. 1 month waived of PRI MRC, value of $838, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FullHosp2mfrWVI","1 Full Business Class Trunk PRI for $489. 2 months waived of PRI MRC, value of $489 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullHosp2mfrWVI","2 Full Business Class Trunk PRI for $838, a $140 total PRI MRC discount. 2 months waived of PRI MRC, value of $978 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracHosp2mfrWVI","1 Fractional Business Class Trunk PRI for $349. 2 months waived of PRI MRC, value of $349 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracHosp2mfrWVI","2 Fractional Business Class Trunk PRI for $598, a $100 total PRI MRC discount. 2 months waived of PRI MRC, value of $698 each month, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5Hosp2mfrWVI","1 Full and 1 Fractional Business Class Trunk PRI for $738, a $100 total PRI MRC discount. 2 months waived of PRI MRC, value of $838, reflected on the bill in month 2 or 3. For Hospitality locations only. Standard Installation Waived, expedited orders excluded. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FullHosp","1 Full Business Class Trunk PRI for $489. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FullHosp","2 Full Business Class Trunk PRI for $838, a $140 total PRI MRC discount. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1FracHosp","1 Fractional Business Class Trunk PRI for $349. For Hospitality locations only. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI2FracHosp","2 Fractional Business Class Trunk PRI for $598, a $100 total PRI MRC discount. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]
["#BCTPRI1.5Hosp","1 Full and 1 Fractional Business Class Trunk PRI for $738, a $100 total PRI MRC discount. For Hospitality locations only. Discount rolls to rate card at end of original term. Minimum 3 year term required. Taxes, Usage, Fees and equipment are extra."]

{"sheet":"Inputs","index":3,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[23,1,25,3],[26,1,28,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"Construction Charge Inputs and Generator"]
[]
[null,"Account Name ….….…………………….....................",{"$f":"IF(+'Sales Order'!C2=\"\",\"\",+'Sales Order'!C2)","v":"Americas Best Value Inn"}]
[null,"Lead / Opportunity ID ….….………………………",{"$f":"IF(+'Sales Order'!J2=\"\",\"\",+'Sales Order'!J2)","v":""}]
[]
[null,"Total OSP/ISP Construction Capex ….….…"]
[null,"Total Fiber Construction Capex ………………………….………..",null,0]
[null,"Sales Channel …………………….…….….…"]
[null,"Lead / Opportunity ID ………………………………...…",null,{"$f":"IF(+'Sales Order'!J2=\"\",\"\",+'Sales Order'!J2)","v":""}]
[null,"Service Term  (Months)……………………………………………..………………………………………………..……",null,{"$f":"IF(+'Sales Order'!K18=\"\",\"Select Term on Sales Order\",'Sales Order'!K18)","v":36}]
[null,"Total Hospitality Service MRC …………………………….",null,{"$f":"+'Sales Order'!J66","v":1202.55},null,null,{"$f":"IF(+Calcs!B17=\"NA\",0,+Calcs!B17)","v":2.0301508726046844},{"$f":"IF(AND(0.25<G12,G12<0.35),1,IF(AND(0.15<G12,G12<0.25),2,IF(G12<0.15,3,0)))","v":0}]
[null,"Total Hospitality Service NRC ……………………….",null,{"$f":"+'Sales Order'!D66","v":179.7}]
[null,"Custom Installation Charge ………………………",null,{"$f":"+'Sales Order'!D67","v":"Charge May Apply"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Optional Notes / Comments"]

{"sheet":"Calcs","index":4,"n_rows":245,"n_cols":69,"rows_kept":245,"cut":false,"hidden":true,"merged":[[45,0,45,1],[46,0,46,1],[47,0,47,1],[44,0,44,1],[33,3,33,5],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[33,6,33,8],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[52,0,52,1],[53,0,53,1],[60,0,60,1],[54,0,54,1],[56,0,56,1],[57,0,57,1],[55,0,55,1],[59,0,59,1]]}
["Hospitality Services Financial Model"]
[{"$f":"IF(+'Sales Order'!C2=\"\",\"\", 'Sales Order'!C2)","v":"Americas Best Value Inn"}]
[{"$f":"+'Sales Order'!N5","v":"Murfreesboro, Tennessee"}]
["Opportunity Summary",null,null,"Financial  Summary","1-Yr","2-Yr","3-Yr","4-Yr","5-Yr"]
["# Rooms",{"$f":"+'Sales Order'!K21","v":115},null,"   GCV",{"$f":"SUM(D148:P148)","v":16313.020190482206},{"$f":"SUM(D148:AB148)","v":30743.620190482197},{"$f":"SUM($D$148:AN148)","v":45174.220190482229},{"$f":"SUM($D$148:AZ148)","v":59604.820190482264},{"$f":"SUM($D$148:BL148)","v":74035.420190482298}]
["Construction Capex",{"$f":"+Inputs!D7+Inputs!D8","v":0},null,"   IRR",{"$f":"+P163","v":1.5585943371289028},{"$f":"+AB163","v":1.9847798521266569},{"$f":"+AN163","v":2.0301508726046844},{"$f":"+AZ163","v":2.0365263191046132},{"$f":"+BL163","v":2.0374803219295563}]
["Equip & Labor Capex",{"$f":"+J109","v":5074},null,"   Break Even Month",{"$f":"+BL166","v":7},{"$f":"+BL166","v":7},{"$f":"+F7","v":7},{"$f":"+G7","v":7},7]
["     Total Capex",{"$f":"+B7+B6","v":5074},null,"   OCF Margin (3-Yr Avg)",{"$f":"+AN157","v":0.56045070891023252},{"$f":"+AN157","v":0.56045070891023252},{"$f":"+F8","v":0.56045070891023252},{"$f":"+G8","v":0.56045070891023252},{"$f":"+H8","v":0.56045070891023252}]
["Term (months)",{"$f":"+'Sales Order'!K18","v":36},null,"   Net FCF",{"$f":"+P162","v":4016.0601904822106},{"$f":"+AB162","v":12103.700190482208},{"$f":"+AN162","v":20191.340190482209},{"$f":"+AZ162","v":28278.980190482223},{"$f":"+BL162","v":36366.620190482237}]
["Total MRC",{"$f":"+E109","v":1202.55},null,"   Equity Multiple (FCF to Capex)",{"$f":"1+(+E9/$C$245)","v":1.2251912184861617},{"$f":"1+(+F9/$C$245)","v":1.6786867887452175},{"$f":"1+(+G9/$C$245)","v":2.1321823590042732},{"$f":"1+(+H9/$C$245)","v":2.5856779292633298},{"$f":"1+(+I9/$C$245)","v":3.0391734995223865}]
["Total NRC",{"$f":"+F109","v":174}]
["Custom Install Charge (NRC)",{"$f":"+'Sales Order'!D67","v":"Charge May Apply"},null,null,"Construction Charge Override: "]
["GCV",{"$f":"IF($B$9=12,E5,IF($B$9=24,F5,IF($B$9=36,G5,IF($B$9=48,H5,IF($B$9=60,I5,NA)))))","v":45174.220190482229}]
["HD Service",{"$f":"IF('Sales Order'!I27>0,\"Yes\",\"No\")","v":"Yes"},null,"Additional Services - Revenue and Cost Driver Sensitivity"]
["Premium Channel Svc",{"$f":"IF(('Sales Order'!I28+'Sales Order'!I29)>0,\"Yes\",\"No\")","v":"No"},null,"Incremental OSP/ISP Capex"]
["Financial  Summary",null,null,"Metro-E Revenue (MRC)",null,null,null,"# Metro-E Sites"]
["   IRR",{"$f":"IF($B$9=12,E6,IF($B$9=24,F6,IF($B$9=36,G6,IF($B$9=48,H6,IF($B$9=60,I6,NA)))))","v":2.0301508726046844},null,"PRI Revenue (MRC)",null,null,null,"# PRI Sites"]
["   Break Even Month",{"$f":"IF($B$9=12,E7,IF($B$9=24,F7,IF($B$9=36,G7,IF($B$9=48,H7,IF($B$9=60,I7,NA)))))","v":7},null,"BVE Revenue (MRC)",null,null,null,"# BVE Sites"]
["   OCF Margin (3-Yr Avg)",{"$f":"IF($B$9=12,E8,IF($B$9=24,F8,IF($B$9=36,G8,IF($B$9=48,H8,IF($B$9=60,I8,NA)))))","v":0.56045070891023252},null,"One Time Charge(s) (NRC)"]
["   Net FCF",{"$f":"IF($B$9=12,E9,IF($B$9=24,F9,IF($B$9=36,G9,IF($B$9=48,H9,IF($B$9=60,I9,NA)))))","v":20191.340190482209},null,"Custom Installation Charge"]
["   Equity Multiple (FCF to Capex)",{"$f":"IF($B$9=12,E10,IF($B$9=24,F10,IF($B$9=36,G10,IF($B$9=48,H10,IF($B$9=60,I10,NA)))))","v":2.1321823590042732}]
[null,null,null,"Financial  Summary","1-Yr","2-Yr","3-Yr","4-Yr","5-Yr"]
["Financial  Summary w/ Addl Revenue",null,null,"   GCV",{"$f":"SUM(D186:P186)","v":14604.599999999997},{"$f":"SUM(D186:AB186)","v":29035.19999999999},{"$f":"SUM($D$186:AN186)","v":43465.80000000001},{"$f":"SUM($D$186:AZ186)","v":57896.400000000045},{"$f":"SUM($D$186:BL186)","v":72327.000000000073}]
["   IRR",{"$f":"IF($B$9=12,E24,IF($B$9=24,F24,IF($B$9=36,G24,IF($B$9=48,H24,IF($B$9=60,I24,NA)))))","v":1.3897909066119603},null,"   IRR",{"$f":"+P201","v":0.6850160926583797},{"$f":"+AB201","v":1.2950723516457998},{"$f":"+AN201","v":1.3897909066119603},{"$f":"+AZ201","v":1.4106235619917475},{"$f":"+BL201","v":1.4157574596858913}]
["   Break Even Month",{"$f":"IF($B$9=12,E25,IF($B$9=24,F25,IF($B$9=36,G25,IF($B$9=48,H25,IF($B$9=60,I25,NA)))))","v":9},null,"   Break Even Month",{"$f":"+BL204","v":9},{"$f":"+BL204","v":9},{"$f":"+F25","v":9},{"$f":"+G25","v":9},{"$f":"+H25","v":9}]
["   OCF Margin (3-Yr Avg)",{"$f":"IF($B$9=12,E26,IF($B$9=24,F26,IF($B$9=36,G26,IF($B$9=48,H26,IF($B$9=60,I26,NA)))))","v":0.56045070891023252},null,"   OCF Margin (3-Yr Avg)",{"$f":"+AN195","v":0.56045070891023252},{"$f":"+AN195","v":0.56045070891023252},{"$f":"+F26","v":0.56045070891023252},{"$f":"+G26","v":0.56045070891023252},{"$f":"+H26","v":0.56045070891023252}]
["   Net FCF",{"$f":"IF($B$9=12,E27,IF($B$9=24,F27,IF($B$9=36,G27,IF($B$9=48,H27,IF($B$9=60,I27,NA)))))","v":18482.919999999998},null,"   Net FCF",{"$f":"+P200","v":2307.6400000000012},{"$f":"+AB200","v":10395.280000000001},{"$f":"+AN200","v":18482.919999999998},{"$f":"+AZ200","v":26570.560000000012},{"$f":"+BL200","v":34658.200000000026}]
["   Equity Multiple (FCF to Capex)",{"$f":"IF($B$9=12,E28,IF($B$9=24,F28,IF($B$9=36,G28,IF($B$9=48,H28,IF($B$9=60,I28,NA)))))","v":2.036386677133565},null,"   Equity Multiple (FCF to Capex)",{"$f":"1+(+E27/$C$245)","v":1.1293955366154538},{"$f":"1+(+F27/$C$245)","v":1.5828911068745093},{"$f":"1+(+G27/$C$245)","v":2.036386677133565},{"$f":"1+(+H27/$C$245)","v":2.4898822473926217},{"$f":"1+(+I27/$C$245)","v":2.9433778176516778}]
[]
[]
[]
[]
[]
["Hospitality Video",null,null,"Revenue",null,null,"Opex",null,null,"Capex"]
["Hospitality (In Room Only)",null,"#Rooms / Quantity","Revenue / Room","Total Monthly Revenue","One Time Revenue","Opex % or $","Monthly Opex $","One-Time Opex $","One-Time (Equip + Labor)"]
["Digital Standard",null,{"$f":"+'Sales Order'!I26","v":0},{"$f":"+'Sales Order'!J26","v":0},{"$f":"C36*D36","v":0},0,0.4,{"$f":"+G36*E36","v":0},0,0]
["HD Standard",null,{"$f":"+'Sales Order'!I27","v":115},{"$f":"+'Sales Order'!J27","v":7},{"$f":"C37*D37","v":805},0,0.4,{"$f":"+G37*E37","v":322},null,0]
["HBO",null,{"$f":"+'Sales Order'!I28","v":0},{"$f":"+'Sales Order'!J28","v":0},{"$f":"C38*D38","v":0},0,3.21,{"$f":"+G38*C38","v":0},null,0]
["Showtime",null,{"$f":"+'Sales Order'!I29","v":0},{"$f":"+'Sales Order'!J29","v":0},{"$f":"C39*D39","v":0},0,3.21,{"$f":"+G39*C39","v":0}]
["Hospitality (Public View)"]
["Basic",null,{"$f":"IF('Sales Order'!I41=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J41","v":0},{"$f":"+D41*C41","v":0},0,0.4,{"$f":"+G41*E41","v":0}]
["Digital Basic Plus",null,{"$f":"IF('Sales Order'!I42=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J42","v":0},0,0,0.4,0]
["Digital Standard",null,{"$f":"IF('Sales Order'!I43=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J43","v":0},0,0,0.4,0]
["Digital Deluxe",null,{"$f":"IF('Sales Order'!I44=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J44","v":0},0,0,0.4,0]
["Sports & Entertainment Deluxe",null,{"$f":"IF('Sales Order'!I45=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J45","v":0},0,0,0.4,0]
["Sports Pack**",null,{"$f":"IF('Sales Order'!I47=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J47","v":0},0,0,0.4,0]
["Music Choice ",null,{"$f":"IF('Sales Order'!I48=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J48","v":0},0,0,0.4,0]
["Canales Selecto",null,{"$f":"IF('Sales Order'!I49=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J49","v":0},0,0,0.4,0]
["Other Equipment: mDTA",null,{"$f":"IF('Sales Order'!I50=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J50","v":0},0,0,0,0]
["Other Equipment: mini mDTA",null,{"$f":"IF('Sales Order'!I51=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J51","v":0},0,0,0,0]
["Other Programming: ",null,{"$f":"IF('Sales Order'!I52=\"\",0,1)","v":0},{"$f":"+'Sales Order'!J52","v":0},0,0,0,0]
[]
["VIDEO EQUIPMENT"]
["DTA ",null,{"$f":"+'Sales Order'!I31","v":0},{"$f":"+'Sales Order'!J31","v":0},{"$f":"C54*D54","v":0},0,0,{"$f":"+G54*E54","v":0},null,{"$f":"+C54*(B217+C217)","v":0}]
["DSTB ",null,{"$f":"+'Sales Order'!I32","v":0},{"$f":"+'Sales Order'!J32","v":0},0,0,0,0,null,{"$f":"+C55*(B223+C223)","v":0}]
["HDSTB ",null,{"$f":"+'Sales Order'!I33","v":0},{"$f":"+'Sales Order'!J33","v":0},{"$f":"C56*D56","v":0},0,0,0,null,{"$f":"+C56*(B219+C219)","v":0}]
["mini mDTA",null,{"$f":"IF('Sales Order'!I34=\"\",0,1)","v":1},{"$f":"+'Sales Order'!K34","v":75},{"$f":"+D57","v":75},0,0,0,null,{"$f":"+C57*(B221+C221)","v":4500}]
["mDTA",null,{"$f":"IF('Sales Order'!I35=\"\",0,1)","v":0},{"$f":"+'Sales Order'!K35","v":0},{"$f":"+D58","v":0},0,0,0,null,{"$f":"+C58*(B220+C220)","v":0}]
["Q2Q",null,{"$f":"IF('Sales Order'!I36=\"\",0,1)","v":0},{"$f":"+'Sales Order'!K36","v":0},{"$f":"+D59","v":0},0,0,0,null,{"$f":"+C59*(B222+C222)","v":0}]
["HD-DTA ",null,{"$f":"+'Sales Order'!I37","v":0},{"$f":"+'Sales Order'!K37","v":0},{"$f":"+D60","v":0},0,0,{"$f":"+G60*E60","v":0},null,{"$f":"+C60*(B218+C218)","v":0}]
["Outlet plus equipment  ",null,{"$f":"+'Sales Order'!I54","v":0},{"$f":"+'Sales Order'!J54","v":0},{"$f":"+D61","v":0},0,0,{"$f":"+G61*E61","v":0}]
[]
["Other Opex","Detail","Quantity","Cost per Unit","Monthly","Opex Driver (Yes = 1, No = 0)",null,"Monthly Opex $","One-Time Opex $","Capex"]
["Truck Rolls / Yr",94.5,4,{"$f":"+C64*B64","v":378},{"$f":"+D64/12","v":31.5},{"$f":"IF($E$73>0,1,0)","v":1},null,{"$f":"+E64*F64","v":31.5}]
["Commissions","Multiple of MRC",1,null,null,1,null,null,{"$f":"(+C65*E73)*F65","v":880}]
["Maintenance","450/Yr",null,450,{"$f":"+D66/12","v":37.5},1,null,{"$f":"+E66*F66","v":37.5}]
["Bad Debt","1% of MRC",null,null,null,1,null,{"$f":"+E67*F67","v":0}]
["Customer Service","$0.08 per Room / Mo",null,0.08,null,1,null,{"$f":"(+D68*$B$5)*F68","v":9.2000000000000011}]
["Billing","$0.01 per Room  /Mo",null,0.01,null,1,null,{"$f":"(+D69*$B$5)*F69","v":1.1500000000000001}]
["NETO","$0.01 per Room / Mo",null,0.01,null,1,null,{"$f":"(+D70*$B$5)*F70","v":1.1500000000000001}]
["Sales Overhead","$0.05 per Room / Mo",null,0.05,null,1,null,{"$f":"(+D71*$B$5)*F71","v":5.75}]
[]
["    Total Hospitality Video",null,null,null,{"$f":"SUM(E36:E61)","v":880},null,{"$f":"+H73/E73","v":0.4639204545454545},{"$f":"SUM(H36:H72)","v":408.24999999999994},{"$f":"SUM(I36:I72)","v":880},{"$f":"SUM(J36:J72)","v":4500}]
[]
["Hospitality Voice",null,null,"Revenue",null,null,"Opex",null,null,"Capex"]
[null,null,"Quantity","Unit Price","Total Monthly Revenue","One Time Revenue","Opex %","Monthly Opex $","One-Time Opex $","One-Time (Equip + Labor)"]
["   Full Featured Voice Lines",null,{"$f":"+'Sales Order'!C26","v":3},{"$f":"+'Sales Order'!D26","v":39.950000000000003},{"$f":"+D77*C77","v":119.85000000000001},{"$f":"+C77*29","v":87},0.5,{"$f":"+G77*E77","v":59.925000000000004},0]
["Basic Lines",null,{"$f":"+'Sales Order'!C27","v":3},{"$f":"+'Sales Order'!D27","v":24.95},{"$f":"+D78*C78","v":74.849999999999994},{"$f":"+C78*29","v":87},0.5,37.424999999999997]
["Toll Free Number",null,{"$f":"+'Sales Order'!C28","v":0},{"$f":"+'Sales Order'!D28","v":0},{"$f":"+D79*C79","v":0},{"$f":"+C79*9.9","v":0},0.5,0]
["    Voice - eMTA Equipment Fee",null,{"$f":"+'Sales Order'!C29","v":1},{"$f":"+'Sales Order'!D29","v":12.95},{"$f":"+D80*C80","v":12.95},null,0,0]
["    Voicemail",null,{"$f":"+'Sales Order'!C30","v":0},{"$f":"+'Sales Order'!D30","v":0},{"$f":"+D81*C81","v":0},null,0.5,{"$f":"+G81*E81","v":0}]
["    Directory Listing Suppression Fee",null,{"$f":"+'Sales Order'!C32","v":0},{"$f":"+'Sales Order'!D32","v":0},{"$f":"+D82","v":0},null,0.5,0]
["    Voice Jack Fee",null,null,null,null,{"$f":"+'Sales Order'!E63","v":0},0]
["    Auto-Attendant",null,{"$f":"+'Sales Order'!C33","v":0},{"$f":"+'Sales Order'!D33","v":0},{"$f":"+D84","v":0},{"$f":"+'Sales Order'!E63","v":0},0.5,{"$f":"+G84*E84","v":0}]
["    EMTA Equipment",null,{"$f":"+'Sales Order'!C34","v":0},null,null,null,null,null,null,{"$f":"IF(H221>0,F221+G221,0)","v":280}]
["    Total Hospitality Voice",null,null,null,{"$f":"SUM(E77:E84)","v":207.64999999999998},{"$f":"SUM(F77:F84)","v":174},null,{"$f":"SUM(H77:H84)","v":97.35},{"$f":"SUM(I77:I84)","v":0},{"$f":"SUM(J77:J85)","v":280}]
[]
["Hospitality Internet",null,null,"Revenue",null,null,"Opex",null,null,"Capex"]
[null,null,"Quantity","Unit Price","Total Monthly Revenue","One Time Revenue","Opex %","Monthly Opex $","One-Time Opex $","One-Time (Equip + Labor)"]
["  Starter",null,{"$f":"IF('Sales Order'!C41=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D41","v":0},{"$f":"+'Sales Order'!D41","v":0},0,0.2,{"$f":"+G90*E90","v":0},0]
["  Deluxe",null,{"$f":"IF('Sales Order'!C42=\"\",0,1)","v":1},{"$f":"+'Sales Order'!D42","v":99.95},{"$f":"+'Sales Order'!D42","v":99.95},0,0.2,{"$f":"+G91*E91","v":19.990000000000002},0]
["  Deluxe 75",null,{"$f":"IF('Sales Order'!C43=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D43","v":0},{"$f":"+'Sales Order'!D43","v":0},0,{"$f":"+G91","v":0.2},0]
["  Deluxe 100",null,{"$f":"IF('Sales Order'!C44=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D44","v":0},{"$f":"+'Sales Order'!D44","v":0},0,{"$f":"+G92","v":0.2},0]
["  Deluxe 100+",null,{"$f":"IF('Sales Order'!C45=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D45","v":0},{"$f":"+'Sales Order'!D45","v":0},0,0.2,0]
["  Equipment Fee: D3 Gateway, Qty (1)",null,{"$f":"IF('Sales Order'!C46=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D46","v":0},{"$f":"+'Sales Order'!D46","v":0},0,0.2,0]
["  Static IP  - 1",null,{"$f":"IF('Sales Order'!C48=\"\",0,1)","v":1},{"$f":"+'Sales Order'!D48","v":14.95},{"$f":"+'Sales Order'!D48","v":14.95},0,0.2,2.99]
["  Static IP - 5",null,{"$f":"IF('Sales Order'!C49=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D49","v":0},{"$f":"+'Sales Order'!D49","v":0},0,0.2,0]
["  Static IP - 13",null,{"$f":"IF('Sales Order'!C50=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D50","v":0},{"$f":"+'Sales Order'!D50","v":0},0,0.2,0]
["  Webhosting - Starter",null,{"$f":"IF('Sales Order'!C51=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D51","v":0},{"$f":"+'Sales Order'!D51","v":0},0,0.2,0]
["  Webhosting - Business",null,{"$f":"IF('Sales Order'!C52=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D52","v":0},{"$f":"+'Sales Order'!D52","v":0},0,0.2,0]
["  Webhosting - Commerce",null,{"$f":"IF('Sales Order'!C53=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D53","v":0},{"$f":"+'Sales Order'!D53","v":0},0,0.2,0]
["  Webhosting - Professional",null,{"$f":"IF('Sales Order'!C54=\"\",0,1)","v":0},{"$f":"+'Sales Order'!D54","v":0},{"$f":"+'Sales Order'!D54","v":0},0,0.2,0]
["  SMC Router - Equipment",null,{"$f":"IF('Sales Order'!C55=\"\",0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(H217>0,F217+G217,0)","v":294}]
["    Total Hospitality Internet",null,null,null,{"$f":"SUM(E90:E102)","v":114.9},{"$f":"SUM(F90:F102)","v":0},null,{"$f":"SUM(H90:H102)","v":22.980000000000004},{"$f":"SUM(I91:I102)","v":0},{"$f":"SUM(J90:J103)","v":294}]
[]
["    Discounts",null,null,null,{"$f":"-'Sales Order'!J63","v":0},0]
[]
[null,null,null,null,"Total Monthly Revenue","One Time Revenue","Opex %","Monthly    Opex $","One-Time Opex $","One-Time Capex $"]
["   Total Hospitality Services",null,null,null,{"$f":"+E104+E86+E73+E106","v":1202.55},{"$f":"+F104+F86+F73+F106","v":174},{"$f":"IF(E109=0,\"NA\",+H109/E109)","v":0.43954929108976754},{"$f":"+H104+H86+H73","v":528.57999999999993},{"$f":"+I104+I86+I73","v":880},{"$f":"+J104+J86+J73","v":5074}]
[]
[]
["Capex Summary",null,null,null,"IRR Target","Annual","Monthly"]
["   Coax Construction Capex",null,{"$f":"+Inputs!D7","v":0},null,null,0.3,{"$f":"+F113/12","v":2.4999999999999998E-2}]
["   Hospitality Video Equipment & Labor",null,{"$f":"+J73","v":4500}]
["   Hospitality Voice Equipment & Labor",null,{"$f":"+J86","v":280}]
["   Hospitaltiy Internet Equipment & Labor",null,{"$f":"+J104","v":294}]
["       Total",null,{"$f":"SUM(C113:C116)","v":5074}]
["       Adjustments"]
["       Total - Adjusted",null,{"$f":"+C118+C117","v":5074}]
["  Brief explaination of adjustment "]
[]
["For Metro-E Configurator Input Use"]
["Additional OSP/ISP Capex Input",null,null,{"$f":"+C226","v":0}]
["Additional Hopsitality CPE Input",null,null,{"$f":"+C245-D123","v":17834}]
[null,null,"MRC","NRC"]
["Hospitality Service Revenue",null,{"$f":"+E109","v":1202.55},{"$f":"+F109","v":174}]
["Hospitality Service Opex",null,{"$f":"+H109","v":528.57999999999993},{"$f":"+I109","v":880}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Month",0,1,{"$f":"+E142+1","v":2},{"$f":"+F142+1","v":3},4,5,{"$f":"+I142+1","v":6},7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,null,"Year 1","Year 2","Year 3"]
[null,null,"Date",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E143+31","v":{"$error":"#REF!"}},{"$f":"F143+31","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"I143+31","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,"Year 1","Year 2","Year 3","Total 3 Yrs"]
[]
[null,null,"MRC",null,{"$f":"+E109","v":1202.55},{"$f":"+E145","v":1202.55},{"$f":"+F145","v":1202.55},1202.55,1202.55,{"$f":"+I145","v":1202.55},1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,null,{"$f":"SUM(E145:P145)","v":14430.599999999997},{"$f":"IF($B$9>1,$P145*12,0)","v":14430.599999999999},{"$f":"IF($B$9>2,$P145*12,0)","v":14430.599999999999},{"$f":"SUM(BN145:BP145)","v":43291.799999999996}]
[null,null,"NRC",null,{"$f":"+F109","v":174},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E146:P146)","v":174},{"$f":"IF($B$9>1,$P146*12,0)","v":0},{"$f":"IF($B$9>2,$P146*12,0)","v":0},{"$f":"SUM(BN146:BP146)","v":174}]
[null,null,"Req Const Charge",1708.4201904822098]
[null,null,"Total Revenue",{"$f":"+D147+D146+D145","v":1708.4201904822098},{"$f":"SUM(E145:E146)","v":1376.55},{"$f":"SUM(F145:F146)","v":1202.55},1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,null,{"$f":"SUM(BN145:BN146)","v":14604.599999999997},{"$f":"SUM(BO145:BO146)","v":14430.599999999999},{"$f":"SUM(BP145:BP146)","v":14430.599999999999},{"$f":"SUM(BQ145:BQ146)","v":43465.799999999996}]
[]
[]
[null,null,"Recurring Opex",null,{"$f":"+H109","v":528.57999999999993},{"$f":"+E151","v":528.57999999999993},{"$f":"+F151","v":528.57999999999993},528.57999999999993,528.57999999999993,{"$f":"+I151","v":528.57999999999993},528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,null,{"$f":"SUM(E151:P151)","v":6342.9599999999991},{"$f":"IF($B$9>1,$P151*12,0)","v":6342.9599999999991},{"$f":"IF($B$9>2,$P151*12,0)","v":6342.9599999999991},{"$f":"SUM(BN151:BP151)","v":19028.879999999997}]
[null,null,"Non-recurring Opex",null,{"$f":"+I109","v":880},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E152:P152)","v":880},{"$f":"IF($B$9>1,$P152*12,0)","v":0},{"$f":"IF($B$9>2,$P152*12,0)","v":0},{"$f":"SUM(BN152:BP152)","v":880}]
[null,null,"    Total Opex",{"$f":"SUM(D151:D152)","v":0},{"$f":"SUM(E151:E152)","v":1408.58},{"$f":"SUM(F151:F152)","v":528.57999999999993},528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,null,{"$f":"SUM(BN151:BN152)","v":7222.9599999999991},{"$f":"SUM(BO151:BO152)","v":6342.9599999999991},{"$f":"SUM(BP151:BP152)","v":6342.9599999999991},{"$f":"SUM(BQ151:BQ152)","v":19908.879999999997}]
[]
[]
[null,null,"OCF",{"$f":"+D148","v":1708.4201904822098},{"$f":"E148-E153","v":-32.029999999999973},{"$f":"F148-F153","v":673.97},673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,null,{"$f":"SUM(E156:P156)","v":7381.6400000000021},{"$f":"BO148-BO153","v":8087.6399999999994},{"$f":"BP148-BP153","v":8087.6399999999994},{"$f":"BQ148-BQ153","v":23556.92}]
[null,null,"   OCF Margin",null,{"$f":"+E156/E148","v":-2.3268315716828282E-2},{"$f":"+F156/F148","v":0.56045070891023252},0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252]
[]
[null,null,"Capex",{"$f":"+C119","v":5074},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D159:P159)","v":5074},{"$f":"IF($B$9>1,$P159*12,0)","v":0},{"$f":"IF($B$9>2,$P159*12,0)","v":0},{"$f":"SUM(BN159:BP159)","v":5074}]
[]
[null,null,"FCF",{"$f":"+D156-D159","v":-3365.5798095177902},{"$f":"+E156-E159","v":-32.029999999999973},{"$f":"+F156-F159","v":673.97},{"$f":"+G156-G159","v":673.97},673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97]
[null,null,"Cumulative FCF",{"$f":"+D161","v":-3365.5798095177902},{"$f":"+E161+D162","v":-3397.6098095177904},{"$f":"+E162+F161","v":-2723.6398095177901},{"$f":"+F162+G161","v":-2049.6698095177899},-1375.6998095177898,-701.72980951778982,{"$f":"+I162+J161","v":-27.75980951778979},646.21019048221024,1320.1801904822103,1994.1501904822103,2668.1201904822101,3342.0901904822103,4016.0601904822106,4690.0301904822109,5364.0001904822111,6037.9701904822114,6711.9401904822116,7385.9101904822119,8059.8801904822121,8733.8501904822115,9407.8201904822108,10081.79019048221,10755.76019048221,11429.730190482209,12103.700190482208,12777.670190482208,13451.640190482207,14125.610190482206,14799.580190482206,15473.550190482205,16147.520190482204,16821.490190482204,17495.460190482205,18169.430190482206,18843.400190482207,19517.370190482208,20191.340190482209,20865.310190482211,21539.280190482212,22213.250190482213,22887.220190482214,23561.190190482215,24235.160190482216,24909.130190482218,25583.100190482219,26257.07019048222,26931.040190482221,27605.010190482222,28278.980190482223,28952.950190482225,29626.920190482226,30300.890190482227,30974.860190482228,31648.830190482229,32322.80019048223,32996.770190482232,33670.740190482233,34344.710190482234,35018.680190482235,35692.650190482236,36366.620190482237]
[null,null,"IRR",{"$f":"IF(D162<0,\"NA\",IRR(D$162:$E162,0.05)*12)","v":"NA"},{"$f":"IF(E162<0,\"NA\",IRR($D$161:E161,0.05)*12)","v":"NA"},{"$f":"IF(F162<0,\"NA\",IRR($D$161:F161,0.05)*12)","v":"NA"},{"$f":"IF(G162<0,\"NA\",IRR($D$161:G161,0.05)*12)","v":"NA"},{"$f":"IF(H162<0,\"NA\",IRR($D$161:H161,0.05)*12)","v":"NA"},{"$f":"IF(I162<0,\"NA\",IRR($D$161:I161,0.05)*12)","v":"NA"},{"$f":"IF(J162<0,\"NA\",IRR($D$161:J161,0.05)*12)","v":"NA"},{"$f":"IF(K162<0,\"NA\",IRR($D$161:K161,0.05)*12)","v":0.48065382982283289},{"$f":"IF(L162<0,\"NA\",IRR($D$161:L161,0.05)*12)","v":0.83926565264531572},{"$f":"IF(M162<0,\"NA\",IRR($D$161:M161,0.05)*12)","v":1.1008316815133821},{"$f":"IF(N162<0,\"NA\",IRR($D$161:N161,0.05)*12)","v":1.2959334601475732},{"$f":"IF(O162<0,\"NA\",IRR($D$161:O161,0.05)*12)","v":1.4441833915866535},{"$f":"IF(P162<0,\"NA\",IRR($D$161:P161,0.05)*12)","v":1.5585943371289028},{"$f":"IF(Q162<0,\"NA\",IRR($D$161:Q161,0.05)*12)","v":1.648055294747266},{"$f":"IF(R162<0,\"NA\",IRR($D$161:R161,0.05)*12)","v":1.7187923787928678},{"$f":"IF(S162<0,\"NA\",IRR($D$161:S161,0.05)*12)","v":1.7752623577701145},{"$f":"IF(T162<0,\"NA\",IRR($D$161:T161,0.05)*12)","v":1.8207165683357713},{"$f":"IF(U162<0,\"NA\",IRR($D$161:U161,0.05)*12)","v":1.8575667950081911},{"$f":"IF(V162<0,\"NA\",IRR($D$161:V161,0.05)*12)","v":1.8876285603786407},{"$f":"IF(W162<0,\"NA\",IRR($D$161:W161,0.05)*12)","v":1.9122864790476148},{"$f":"IF(X162<0,\"NA\",IRR($D$161:X161,0.05)*12)","v":1.9326088664269516},{"$f":"IF(Y162<0,\"NA\",IRR($D$161:Y161,0.05)*12)","v":1.9494285899246035},{"$f":"IF(Z162<0,\"NA\",IRR($D$161:Z161,0.05)*12)","v":1.963401023405356},{"$f":"IF(AA162<0,\"NA\",IRR($D$161:AA161,0.05)*12)","v":1.975046195764901},{"$f":"IF(AB162<0,\"NA\",IRR($D$161:AB161,0.05)*12)","v":1.9847798521266569},{"$f":"IF(AC162<0,\"NA\",IRR($D$161:AC161,0.05)*12)","v":1.9929366227297498},{"$f":"IF(AD162<0,\"NA\",IRR($D$161:AD161,0.05)*12)","v":1.9997874972595087},{"$f":"IF(AE162<0,\"NA\",IRR($D$161:AE161,0.05)*12)","v":2.0055531401608393},{"$f":"IF(AF162<0,\"NA\",IRR($D$161:AF161,0.05)*12)","v":2.0104141319706068},{"$f":"IF(AG162<0,\"NA\",IRR($D$161:AG161,0.05)*12)","v":2.0145189155884662},{"$f":"IF(AH162<0,\"NA\",IRR($D$161:AH161,0.05)*12)","v":2.0179900114367344},{"$f":"IF(AI162<0,\"NA\",IRR($D$161:AI161,0.05)*12)","v":2.0209289150081471},{"$f":"IF(AJ162<0,\"NA\",IRR($D$161:AJ161,0.05)*12)","v":2.0234199828731185},{"$f":"IF(AK162<0,\"NA\",IRR($D$161:AK161,0.05)*12)","v":2.0255335358695268},{"$f":"IF(AL162<0,\"NA\",IRR($D$161:AL161,0.05)*12)","v":2.0273283519163146},{"$f":"IF(AM162<0,\"NA\",IRR($D$161:AM161,0.05)*12)","v":2.0288536795461898},{"$f":"IF(AN162<0,\"NA\",IRR($D$161:AN161,0.05)*12)","v":2.0301508726046844},{"$f":"IF(AO162<0,\"NA\",IRR($D$161:AO161,0.05)*12)","v":2.0312547236518022},{"$f":"IF(AP162<0,\"NA\",IRR($D$161:AP161,0.05)*12)","v":2.0321945563375525},{"$f":"IF(AQ162<0,\"NA\",IRR($D$161:AQ161,0.05)*12)","v":2.0329951239135013},{"$f":"IF(AR162<0,\"NA\",IRR($D$161:AR161,0.05)*12)","v":2.0336773510173272},{"$f":"IF(AS162<0,\"NA\",IRR($D$161:AS161,0.05)*12)","v":2.0342589481475963},{"$f":"IF(AT162<0,\"NA\",IRR($D$161:AT161,0.05)*12)","v":2.0347549222630059},{"$f":"IF(AU162<0,\"NA\",IRR($D$161:AU161,0.05)*12)","v":2.035178002274348},{"$f":"IF(AV162<0,\"NA\",IRR($D$161:AV161,0.05)*12)","v":2.0355389945368199},{"$f":"IF(AW162<0,\"NA\",IRR($D$161:AW161,0.05)*12)","v":2.0358470805619486},{"$f":"IF(AX162<0,\"NA\",IRR($D$161:AX161,0.05)*12)","v":2.03611006687734},{"$f":"IF(AY162<0,\"NA\",IRR($D$161:AY161,0.05)*12)","v":2.0363345951349876},{"$f":"IF(AZ162<0,\"NA\",IRR($D$161:AZ161,0.05)*12)","v":2.0365263191046132},{"$f":"IF(BA162<0,\"NA\",IRR($D$161:BA161,0.05)*12)","v":2.0366900540092212},{"$f":"IF(BB162<0,\"NA\",IRR($D$161:BB161,0.05)*12)","v":2.0368299027059908},{"$f":"IF(BC162<0,\"NA\",IRR($D$161:BC161,0.05)*12)","v":2.0369493624406925},{"$f":"IF(BD162<0,\"NA\",IRR($D$161:BD161,0.05)*12)","v":2.0370514152713239},{"$f":"IF(BE162<0,\"NA\",IRR($D$161:BE161,0.05)*12)","v":2.0371386047390283},{"$f":"IF(BF162<0,\"NA\",IRR($D$161:BF161,0.05)*12)","v":2.0372131009384669},{"$f":"IF(BG162<0,\"NA\",IRR($D$161:BG161,0.05)*12)","v":2.0372767557888629},{"$f":"IF(BH162<0,\"NA\",IRR($D$161:BH161,0.05)*12)","v":2.0373311500738458},{"$f":"IF(BI162<0,\"NA\",IRR($D$161:BI161,0.05)*12)","v":2.0373776331832714},{"$f":"IF(BJ162<0,\"NA\",IRR($D$161:BJ161,0.05)*12)","v":2.0374173574440988},{"$f":"IF(BK162<0,\"NA\",IRR($D$161:BK161,0.05)*12)","v":2.0374513068789195},{"$f":"IF(BL162<0,\"NA\",IRR($D$161:BL161,0.05)*12)","v":2.0374803219295563}]
[null,null,"NPV",{"$f":"NPV($G$113,D161)","v":-3283.4924970905272},{"$f":"NPV($G$113,$D$161:E161)","v":-3313.9791122005804},{"$f":"NPV($G$113,$D$161:F161)","v":-2688.1309672229977},{"$f":"NPV($G$113,$D$161:G161)","v":-2077.5474111473068},{"$f":"NPV($G$113,$D$161:H161)","v":-1481.8561369271204},{"$f":"NPV($G$113,$D$161:I161)","v":-900.69391817571909},{"$f":"NPV($G$113,$D$161:J161)","v":-333.70638768654698},{"$f":"NPV($G$113,$D$161:K161)","v":219.45217864435264},{"$f":"NPV($G$113,$D$161:L161)","v":759.11907262571822},{"$f":"NPV($G$113,$D$161:M161)","v":1285.6233594368066},{"$f":"NPV($G$113,$D$161:N161)","v":1799.286078276893},{"$f":"NPV($G$113,$D$161:O161)","v":2300.4204381208797},{"$f":"NPV($G$113,$D$161:P161)","v":2789.332008700379},{"$f":"NPV($G$113,$D$161:Q161)","v":3266.3189068267197},{"$f":"NPV($G$113,$D$161:R161)","v":3731.6719781694915},{"$f":"NPV($G$113,$D$161:S161)","v":4185.674974601463},{"$f":"NPV($G$113,$D$161:T161)","v":4628.6047272180213},{"$f":"NPV($G$113,$D$161:U161)","v":5060.7313151366152},{"$f":"NPV($G$113,$D$161:V161)","v":5482.3182301791458},{"$f":"NPV($G$113,$D$161:W161)","v":5893.6225375377117},{"$f":"NPV($G$113,$D$161:X161)","v":6294.8950325216783},{"$f":"NPV($G$113,$D$161:Y161)","v":6686.3803934816469},{"$f":"NPV($G$113,$D$161:Z161)","v":7068.3173310035672},{"$f":"NPV($G$113,$D$161:AA161)","v":7440.9387334639769},{"$f":"NPV($G$113,$D$161:AB161)","v":7804.471809035108},{"$f":"NPV($G$113,$D$161:AC161)","v":8159.1382242264563},{"$f":"NPV($G$113,$D$161:AD161)","v":8505.1542390472841},{"$f":"NPV($G$113,$D$161:AE161)","v":8842.7308388724814},{"$f":"NPV($G$113,$D$161:AF161)","v":9172.073863092186},{"$f":"NPV($G$113,$D$161:AG161)","v":9493.3841306236045},{"$f":"NPV($G$113,$D$161:AH161)","v":9806.8575623615743},{"$f":"NPV($G$113,$D$161:AI161)","v":10112.685300642521},{"$f":"NPV($G$113,$D$161:AJ161)","v":10411.053825794663},{"$f":"NPV($G$113,$D$161:AK161)","v":10702.145069845536},{"$f":"NPV($G$113,$D$161:AL161)","v":10986.136527456141},{"$f":"NPV($G$113,$D$161:AM161)","v":11263.201364149416},{"$f":"NPV($G$113,$D$161:AN161)","v":11533.508521898952},{"$f":"NPV($G$113,$D$161:AO161)","v":11797.222822142401},{"$f":"NPV($G$113,$D$161:AP161)","v":12054.505066282352},{"$f":"NPV($G$113,$D$161:AQ161)","v":12305.512133735963},{"$f":"NPV($G$113,$D$161:AR161)","v":12550.397077593145},{"$f":"NPV($G$113,$D$161:AS161)","v":12789.309217941614},{"$f":"NPV($G$113,$D$161:AT161)","v":13022.394232915731},{"$f":"NPV($G$113,$D$161:AU161)","v":13249.794247524625},{"$f":"NPV($G$113,$D$161:AV161)","v":13471.64792031379},{"$f":"NPV($G$113,$D$161:AW161)","v":13688.090527912975},{"$f":"NPV($G$113,$D$161:AX161)","v":13899.254047521936},{"$f":"NPV($G$113,$D$161:AY161)","v":14105.267237384338},{"$f":"NPV($G$113,$D$161:AZ161)","v":14306.255715298876},{"$f":"NPV($G$113,$D$161:BA161)","v":14502.342035215497},{"$f":"NPV($G$113,$D$161:BB161)","v":14693.645761963422},{"$f":"NPV($G$113,$D$161:BC161)","v":14880.283544156518},{"$f":"NPV($G$113,$D$161:BD161)","v":15062.369185320515},{"$f":"NPV($G$113,$D$161:BE161)","v":15240.013713285389},{"$f":"NPV($G$113,$D$161:BF161)","v":15413.325447885267},{"$f":"NPV($G$113,$D$161:BG161)","v":15582.410067007098},{"$f":"NPV($G$113,$D$161:BH161)","v":15747.370671028399},{"$f":"NPV($G$113,$D$161:BI161)","v":15908.307845683325},{"$f":"NPV($G$113,$D$161:BJ161)","v":16065.319723395449},{"$f":"NPV($G$113,$D$161:BK161)","v":16218.502043114593},{"$f":"NPV($G$113,$D$161:BL161)","v":16367.948208694246}]
[null,null,"Breakeven Counter",{"$f":"IF(D162>0,1,0)","v":0},{"$f":"IF(E162>0,1,0)","v":0},{"$f":"IF(F162>0,1,0)","v":0},{"$f":"IF(G162>0,1,0)","v":0},0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Breakeven Month",{"$f":"+D165*D142-SUM(B$165:$E165)","v":0},{"$f":"+E165*E142-SUM(C$165:$E165)","v":0},{"$f":"+F165*F142-SUM($E$165:E165)","v":0},{"$f":"+G165*G142-SUM($E$165:F165)","v":0},{"$f":"+H165*H142-SUM($E$165:G165)","v":0},{"$f":"+I165*I142-SUM($E$165:H165)","v":0},{"$f":"+J165*J142-SUM($E$165:I165)","v":0},{"$f":"+K165*K142-SUM($E$165:J165)","v":7},{"$f":"+L165*L142-SUM($E$165:K165)","v":7},{"$f":"+M165*M142-SUM($E$165:L165)","v":7},{"$f":"+N165*N142-SUM($E$165:M165)","v":7},{"$f":"+O165*O142-SUM($E$165:N165)","v":7},{"$f":"+P165*P142-SUM($E$165:O165)","v":7},{"$f":"+Q165*Q142-SUM($E$165:P165)","v":7},{"$f":"+R165*R142-SUM($E$165:Q165)","v":7},{"$f":"+S165*S142-SUM($E$165:R165)","v":7},{"$f":"+T165*T142-SUM($E$165:S165)","v":7},{"$f":"+U165*U142-SUM($E$165:T165)","v":7},{"$f":"+V165*V142-SUM($E$165:U165)","v":7},{"$f":"+W165*W142-SUM($E$165:V165)","v":7},{"$f":"+X165*X142-SUM($E$165:W165)","v":7},{"$f":"+Y165*Y142-SUM($E$165:X165)","v":7},{"$f":"+Z165*Z142-SUM($E$165:Y165)","v":7},{"$f":"+AA165*AA142-SUM($E$165:Z165)","v":7},{"$f":"+AB165*AB142-SUM($E$165:AA165)","v":7},{"$f":"+AC165*AC142-SUM($E$165:AB165)","v":7},{"$f":"+AD165*AD142-SUM($E$165:AC165)","v":7},{"$f":"+AE165*AE142-SUM($E$165:AD165)","v":7},{"$f":"+AF165*AF142-SUM($E$165:AE165)","v":7},{"$f":"+AG165*AG142-SUM($E$165:AF165)","v":7},{"$f":"+AH165*AH142-SUM($E$165:AG165)","v":7},{"$f":"+AI165*AI142-SUM($E$165:AH165)","v":7},{"$f":"+AJ165*AJ142-SUM($E$165:AI165)","v":7},{"$f":"+AK165*AK142-SUM($E$165:AJ165)","v":7},{"$f":"+AL165*AL142-SUM($E$165:AK165)","v":7},{"$f":"+AM165*AM142-SUM($E$165:AL165)","v":7},{"$f":"+AN165*AN142-SUM($E$165:AM165)","v":7},{"$f":"+AO165*AO142-SUM($E$165:AN165)","v":7},{"$f":"+AP165*AP142-SUM($E$165:AO165)","v":7},{"$f":"+AQ165*AQ142-SUM($E$165:AP165)","v":7},{"$f":"+AR165*AR142-SUM($E$165:AQ165)","v":7},{"$f":"+AS165*AS142-SUM($E$165:AR165)","v":7},{"$f":"+AT165*AT142-SUM($E$165:AS165)","v":7},{"$f":"+AU165*AU142-SUM($E$165:AT165)","v":7},{"$f":"+AV165*AV142-SUM($E$165:AU165)","v":7},{"$f":"+AW165*AW142-SUM($E$165:AV165)","v":7},{"$f":"+AX165*AX142-SUM($E$165:AW165)","v":7},{"$f":"+AY165*AY142-SUM($E$165:AX165)","v":7},{"$f":"+AZ165*AZ142-SUM($E$165:AY165)","v":7},{"$f":"+BA165*BA142-SUM($E$165:AZ165)","v":7},{"$f":"+BB165*BB142-SUM($E$165:BA165)","v":7},{"$f":"+BC165*BC142-SUM($E$165:BB165)","v":7},{"$f":"+BD165*BD142-SUM($E$165:BC165)","v":7},{"$f":"+BE165*BE142-SUM($E$165:BD165)","v":7},{"$f":"+BF165*BF142-SUM($E$165:BE165)","v":7},{"$f":"+BG165*BG142-SUM($E$165:BF165)","v":7},{"$f":"+BH165*BH142-SUM($E$165:BG165)","v":7},{"$f":"+BI165*BI142-SUM($E$165:BH165)","v":7},{"$f":"+BJ165*BJ142-SUM($E$165:BI165)","v":7},{"$f":"+BK165*BK142-SUM($E$165:BJ165)","v":7},{"$f":"+BL165*BL142-SUM($E$165:BK165)","v":7}]
[null,null,"NPV",{"$f":"IF(B9=12,P164,IF(B9=24,AB164,IF(B9=36,AN164,IF(B9=48,AZ164,IF(B9=60,BL164)))))","v":11533.508521898952}]
[]
[]
[]
["Other Revenue Drivers"]
[null,null,"Revenue","Opex %","O;pex $","Capex / Site","Total Capex"]
["Metro-E Revenue (MRC)",null,{"$f":"+F16","v":0},0.2,{"$f":"+D173*C173","v":0},3402,{"$f":"+F173*I16","v":0}]
["PRI Revenue (MRC)",null,0,0.5,{"$f":"+D174*C174","v":0},1030,{"$f":"+F174*I17","v":0}]
["BVE Revenue (MRC)",null,{"$f":"+F18","v":0},0.5,{"$f":"+D175*C175","v":0},4200,{"$f":"+F175*I18","v":0}]
["NRC / Construction Charge",null,{"$f":"+F19","v":0},1,{"$f":"+D176*C176","v":0},{"$f":"+F15","v":0},{"$f":"+F176","v":0}]
["One Time Opex / Commissions",null,null,null,{"$f":"+C173+C174+C175","v":0}]
["  Total",null,{"$f":"SUM(C173:C177)","v":0},null,null,null,{"$f":"SUM(G173:G177)","v":0}]
[]
[null,null,"Month",0,1,{"$f":"+E180+1","v":2},{"$f":"+F180+1","v":3},{"$f":"+G180+1","v":4},{"$f":"+H180+1","v":5},{"$f":"+I180+1","v":6},{"$f":"+J180+1","v":7},{"$f":"+K180+1","v":8},{"$f":"+L180+1","v":9},{"$f":"+M180+1","v":10},{"$f":"+N180+1","v":11},{"$f":"+O180+1","v":12},{"$f":"+P180+1","v":13},{"$f":"+Q180+1","v":14},{"$f":"+R180+1","v":15},{"$f":"+S180+1","v":16},{"$f":"+T180+1","v":17},{"$f":"+U180+1","v":18},{"$f":"+V180+1","v":19},{"$f":"+W180+1","v":20},{"$f":"+X180+1","v":21},{"$f":"+Y180+1","v":22},{"$f":"+Z180+1","v":23},{"$f":"+AA180+1","v":24},{"$f":"+AB180+1","v":25},{"$f":"+AC180+1","v":26},{"$f":"+AD180+1","v":27},{"$f":"+AE180+1","v":28},{"$f":"+AF180+1","v":29},{"$f":"+AG180+1","v":30},{"$f":"+AH180+1","v":31},{"$f":"+AI180+1","v":32},{"$f":"+AJ180+1","v":33},{"$f":"+AK180+1","v":34},{"$f":"+AL180+1","v":35},{"$f":"+AM180+1","v":36},{"$f":"+AN180+1","v":37},{"$f":"+AO180+1","v":38},{"$f":"+AP180+1","v":39},{"$f":"+AQ180+1","v":40},{"$f":"+AR180+1","v":41},{"$f":"+AS180+1","v":42},{"$f":"+AT180+1","v":43},{"$f":"+AU180+1","v":44},{"$f":"+AV180+1","v":45},{"$f":"+AW180+1","v":46},{"$f":"+AX180+1","v":47},{"$f":"+AY180+1","v":48},{"$f":"+AZ180+1","v":49},{"$f":"+BA180+1","v":50},{"$f":"+BB180+1","v":51},{"$f":"+BC180+1","v":52},{"$f":"+BD180+1","v":53},{"$f":"+BE180+1","v":54},{"$f":"+BF180+1","v":55},{"$f":"+BG180+1","v":56},{"$f":"+BH180+1","v":57},{"$f":"+BI180+1","v":58},{"$f":"+BJ180+1","v":59},{"$f":"+BK180+1","v":60}]
[null,null,"Date",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E181+31","v":{"$error":"#REF!"}},{"$f":"F181+31","v":{"$error":"#REF!"}},{"$f":"G181+31","v":{"$error":"#REF!"}},{"$f":"H181+31","v":{"$error":"#REF!"}},{"$f":"I181+31","v":{"$error":"#REF!"}},{"$f":"J181+31","v":{"$error":"#REF!"}},{"$f":"K181+31","v":{"$error":"#REF!"}},{"$f":"L181+31","v":{"$error":"#REF!"}},{"$f":"M181+31","v":{"$error":"#REF!"}},{"$f":"N181+31","v":{"$error":"#REF!"}},{"$f":"O181+31","v":{"$error":"#REF!"}},{"$f":"P181+31","v":{"$error":"#REF!"}},{"$f":"Q181+31","v":{"$error":"#REF!"}},{"$f":"R181+31","v":{"$error":"#REF!"}},{"$f":"S181+31","v":{"$error":"#REF!"}},{"$f":"T181+31","v":{"$error":"#REF!"}},{"$f":"U181+31","v":{"$error":"#REF!"}},{"$f":"V181+31","v":{"$error":"#REF!"}},{"$f":"W181+31","v":{"$error":"#REF!"}},{"$f":"X181+31","v":{"$error":"#REF!"}},{"$f":"Y181+31","v":{"$error":"#REF!"}},{"$f":"Z181+31","v":{"$error":"#REF!"}},{"$f":"AA181+31","v":{"$error":"#REF!"}},{"$f":"AB181+31","v":{"$error":"#REF!"}},{"$f":"AC181+31","v":{"$error":"#REF!"}},{"$f":"AD181+31","v":{"$error":"#REF!"}},{"$f":"AE181+31","v":{"$error":"#REF!"}},{"$f":"AF181+31","v":{"$error":"#REF!"}},{"$f":"AG181+31","v":{"$error":"#REF!"}},{"$f":"AH181+31","v":{"$error":"#REF!"}},{"$f":"AI181+31","v":{"$error":"#REF!"}},{"$f":"AJ181+31","v":{"$error":"#REF!"}},{"$f":"AK181+31","v":{"$error":"#REF!"}},{"$f":"AL181+31","v":{"$error":"#REF!"}},{"$f":"AM181+31","v":{"$error":"#REF!"}},{"$f":"AN181+31","v":{"$error":"#REF!"}},{"$f":"AO181+31","v":{"$error":"#REF!"}},{"$f":"AP181+31","v":{"$error":"#REF!"}},{"$f":"AQ181+31","v":{"$error":"#REF!"}},{"$f":"AR181+31","v":{"$error":"#REF!"}},{"$f":"AS181+31","v":{"$error":"#REF!"}},{"$f":"AT181+31","v":{"$error":"#REF!"}},{"$f":"AU181+31","v":{"$error":"#REF!"}},{"$f":"AV181+31","v":{"$error":"#REF!"}},{"$f":"AW181+31","v":{"$error":"#REF!"}},{"$f":"AX181+31","v":{"$error":"#REF!"}},{"$f":"AY181+31","v":{"$error":"#REF!"}},{"$f":"AZ181+31","v":{"$error":"#REF!"}},{"$f":"BA181+31","v":{"$error":"#REF!"}},{"$f":"BB181+31","v":{"$error":"#REF!"}},{"$f":"BC181+31","v":{"$error":"#REF!"}},{"$f":"BD181+31","v":{"$error":"#REF!"}},{"$f":"BE181+31","v":{"$error":"#REF!"}},{"$f":"BF181+31","v":{"$error":"#REF!"}},{"$f":"BG181+31","v":{"$error":"#REF!"}},{"$f":"BH181+31","v":{"$error":"#REF!"}},{"$f":"BI181+31","v":{"$error":"#REF!"}},{"$f":"BJ181+31","v":{"$error":"#REF!"}},{"$f":"BK181+31","v":{"$error":"#REF!"}},null,"Year 1","Year 2","Year 3","Total 3 Yrs"]
[]
[null,null,"MRC",null,{"$f":"+E145+$C$173+$C$174+$C$175","v":1202.55},{"$f":"+F145+$C$173+$C$174+$C$175","v":1202.55},{"$f":"+G145+$C$173+$C$174+$C$175","v":1202.55},1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,null,{"$f":"SUM(E183:P183)","v":14430.599999999997},{"$f":"IF($B$9>1,$P183*12,0)","v":14430.599999999999},{"$f":"IF($B$9>2,$P183*12,0)","v":14430.599999999999},{"$f":"SUM(BN183:BP183)","v":43291.799999999996}]
[null,null,"NRC",null,{"$f":"+E146+C176","v":174},{"$f":"+F146","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+U146","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E184:P184)","v":174},{"$f":"IF($B$9>1,$P184*12,0)","v":0},{"$f":"IF($B$9>2,$P184*12,0)","v":0},{"$f":"SUM(BN184:BP184)","v":174}]
[null,null,"Req Const Charge",{"$f":"+F20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Revenue",{"$f":"+D185+D184+D183","v":0},{"$f":"SUM(E183:E184)","v":1376.55},{"$f":"SUM(F183:F184)","v":1202.55},1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,1202.55,null,{"$f":"SUM(BN183:BN184)","v":14604.599999999997},{"$f":"SUM(BO183:BO184)","v":14430.599999999999},{"$f":"SUM(BP183:BP184)","v":14430.599999999999},{"$f":"SUM(BQ183:BQ184)","v":43465.799999999996}]
[]
[]
[null,null,"Recurring Opex",null,{"$f":"+H109+$E$173+$E$174+$E$175","v":528.57999999999993},{"$f":"+E189","v":528.57999999999993},{"$f":"+F189","v":528.57999999999993},{"$f":"+G189","v":528.57999999999993},{"$f":"+H189","v":528.57999999999993},{"$f":"+I189","v":528.57999999999993},{"$f":"+J189","v":528.57999999999993},{"$f":"+K189","v":528.57999999999993},{"$f":"+L189","v":528.57999999999993},{"$f":"+M189","v":528.57999999999993},{"$f":"+N189","v":528.57999999999993},{"$f":"+O189","v":528.57999999999993},{"$f":"+P189","v":528.57999999999993},{"$f":"+Q189","v":528.57999999999993},{"$f":"+R189","v":528.57999999999993},{"$f":"+S189","v":528.57999999999993},{"$f":"+T189","v":528.57999999999993},{"$f":"+U189","v":528.57999999999993},{"$f":"+V189","v":528.57999999999993},{"$f":"+W189","v":528.57999999999993},{"$f":"+X189","v":528.57999999999993},{"$f":"+Y189","v":528.57999999999993},{"$f":"+Z189","v":528.57999999999993},{"$f":"+AA189","v":528.57999999999993},{"$f":"+AB189","v":528.57999999999993},{"$f":"+AC189","v":528.57999999999993},{"$f":"+AD189","v":528.57999999999993},{"$f":"+AE189","v":528.57999999999993},{"$f":"+AF189","v":528.57999999999993},{"$f":"+AG189","v":528.57999999999993},{"$f":"+AH189","v":528.57999999999993},{"$f":"+AI189","v":528.57999999999993},{"$f":"+AJ189","v":528.57999999999993},{"$f":"+AK189","v":528.57999999999993},{"$f":"+AL189","v":528.57999999999993},{"$f":"+AM189","v":528.57999999999993},{"$f":"+AN189","v":528.57999999999993},{"$f":"+AO189","v":528.57999999999993},{"$f":"+AP189","v":528.57999999999993},{"$f":"+AQ189","v":528.57999999999993},{"$f":"+AR189","v":528.57999999999993},{"$f":"+AS189","v":528.57999999999993},{"$f":"+AT189","v":528.57999999999993},{"$f":"+AU189","v":528.57999999999993},{"$f":"+AV189","v":528.57999999999993},{"$f":"+AW189","v":528.57999999999993},{"$f":"+AX189","v":528.57999999999993},{"$f":"+AY189","v":528.57999999999993},{"$f":"+AZ189","v":528.57999999999993},{"$f":"+BA189","v":528.57999999999993},{"$f":"+BB189","v":528.57999999999993},{"$f":"+BC189","v":528.57999999999993},{"$f":"+BD189","v":528.57999999999993},{"$f":"+BE189","v":528.57999999999993},{"$f":"+BF189","v":528.57999999999993},{"$f":"+BG189","v":528.57999999999993},{"$f":"+BH189","v":528.57999999999993},{"$f":"+BI189","v":528.57999999999993},{"$f":"+BJ189","v":528.57999999999993},{"$f":"+BK189","v":528.57999999999993},null,{"$f":"SUM(E189:P189)","v":6342.9599999999991},{"$f":"IF($B$9>1,$P189*12,0)","v":6342.9599999999991},{"$f":"IF($B$9>2,$P189*12,0)","v":6342.9599999999991},{"$f":"SUM(BN189:BP189)","v":19028.879999999997}]
[null,null,"Non-recurring Opex",null,{"$f":"+I109+E177","v":880},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E190:P190)","v":880},{"$f":"IF($B$9>1,$P190*12,0)","v":0},{"$f":"IF($B$9>2,$P190*12,0)","v":0},{"$f":"SUM(BN190:BP190)","v":880}]
[null,null,"    Total Opex",{"$f":"SUM(D189:D190)","v":0},{"$f":"SUM(E189:E190)","v":1408.58},{"$f":"SUM(F189:F190)","v":528.57999999999993},528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,528.57999999999993,null,{"$f":"SUM(BN189:BN190)","v":7222.9599999999991},{"$f":"SUM(BO189:BO190)","v":6342.9599999999991},{"$f":"SUM(BP189:BP190)","v":6342.9599999999991},{"$f":"SUM(BQ189:BQ190)","v":19908.879999999997}]
[]
[]
[null,null,"OCF",{"$f":"+D186","v":0},{"$f":"E186-E191","v":-32.029999999999973},{"$f":"F186-F191","v":673.97},{"$f":"G186-G191","v":673.97},673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,null,{"$f":"SUM(E194:P194)","v":7381.6400000000021},{"$f":"BO186-BO191","v":8087.6399999999994},{"$f":"BP186-BP191","v":8087.6399999999994},{"$f":"BQ186-BQ191","v":23556.92}]
[null,null,"   OCF Margin",null,{"$f":"+E194/E186","v":-2.3268315716828282E-2},{"$f":"+F194/F186","v":0.56045070891023252},0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252,0.56045070891023252]
[]
[null,null,"Capex",{"$f":"+G178+C119","v":5074},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D197:P197)","v":5074},{"$f":"IF($B$9>1,$P197*12,0)","v":0},{"$f":"IF($B$9>2,$P197*12,0)","v":0},{"$f":"SUM(BN197:BP197)","v":5074}]
[]
[null,null,"FCF",{"$f":"+D194-D197","v":-5074},{"$f":"+E194-E197","v":-32.029999999999973},{"$f":"+F194-F197","v":673.97},{"$f":"+G194-G197","v":673.97},673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97,673.97]
[null,null,"Cumulative FCF",{"$f":"+D199","v":-5074},{"$f":"+E199+D200","v":-5106.03},{"$f":"+E200+F199","v":-4432.0599999999995},{"$f":"+F200+G199","v":-3758.0899999999992},{"$f":"+G200+H199","v":-3084.119999999999},{"$f":"+H200+I199","v":-2410.1499999999987},{"$f":"+I200+J199","v":-1736.1799999999987},{"$f":"+J200+K199","v":-1062.2099999999987},{"$f":"+K200+L199","v":-388.23999999999864},{"$f":"+L200+M199","v":285.73000000000138},{"$f":"+M200+N199","v":959.70000000000141},{"$f":"+N200+O199","v":1633.6700000000014},{"$f":"+O200+P199","v":2307.6400000000012},{"$f":"+P200+Q199","v":2981.6100000000015},{"$f":"+Q200+R199","v":3655.5800000000017},{"$f":"+R200+S199","v":4329.550000000002},{"$f":"+S200+T199","v":5003.5200000000023},{"$f":"+T200+U199","v":5677.4900000000025},{"$f":"+U200+V199","v":6351.4600000000028},{"$f":"+V200+W199","v":7025.430000000003},{"$f":"+W200+X199","v":7699.4000000000033},{"$f":"+X200+Y199","v":8373.3700000000026},{"$f":"+Y200+Z199","v":9047.340000000002},{"$f":"+Z200+AA199","v":9721.3100000000013},{"$f":"+AA200+AB199","v":10395.280000000001},{"$f":"+AB200+AC199","v":11069.25},{"$f":"+AC200+AD199","v":11743.22},{"$f":"+AD200+AE199","v":12417.189999999999},{"$f":"+AE200+AF199","v":13091.159999999998},{"$f":"+AF200+AG199","v":13765.129999999997},{"$f":"+AG200+AH199","v":14439.099999999997},{"$f":"+AH200+AI199","v":15113.069999999996},{"$f":"+AI200+AJ199","v":15787.039999999995},{"$f":"+AJ200+AK199","v":16461.009999999995},{"$f":"+AK200+AL199","v":17134.979999999996},{"$f":"+AL200+AM199","v":17808.949999999997},{"$f":"+AM200+AN199","v":18482.919999999998},{"$f":"+AN200+AO199","v":19156.89},{"$f":"+AO200+AP199","v":19830.86},{"$f":"+AP200+AQ199","v":20504.830000000002},{"$f":"+AQ200+AR199","v":21178.800000000003},{"$f":"+AR200+AS199","v":21852.770000000004},{"$f":"+AS200+AT199","v":22526.740000000005},{"$f":"+AT200+AU199","v":23200.710000000006},{"$f":"+AU200+AV199","v":23874.680000000008},{"$f":"+AV200+AW199","v":24548.650000000009},{"$f":"+AW200+AX199","v":25222.62000000001},{"$f":"+AX200+AY199","v":25896.590000000011},{"$f":"+AY200+AZ199","v":26570.560000000012},{"$f":"+AZ200+BA199","v":27244.530000000013},{"$f":"+BA200+BB199","v":27918.500000000015},{"$f":"+BB200+BC199","v":28592.470000000016},{"$f":"+BC200+BD199","v":29266.440000000017},{"$f":"+BD200+BE199","v":29940.410000000018},{"$f":"+BE200+BF199","v":30614.380000000019},{"$f":"+BF200+BG199","v":31288.35000000002},{"$f":"+BG200+BH199","v":31962.320000000022},{"$f":"+BH200+BI199","v":32636.290000000023},{"$f":"+BI200+BJ199","v":33310.260000000024},{"$f":"+BJ200+BK199","v":33984.230000000025},{"$f":"+BK200+BL199","v":34658.200000000026}]
[null,null,"IRR",{"$f":"IF(D200<0,\"NA\",IRR(D$199:$E199,0.05)*12)","v":"NA"},{"$f":"IF(E200<0,\"NA\",IRR($D$199:E199,0.05)*12)","v":"NA"},{"$f":"IF(F200<0,\"NA\",IRR($D$199:F199,0.05)*12)","v":"NA"},{"$f":"IF(G200<0,\"NA\",IRR($D$199:G199,0.05)*12)","v":"NA"},{"$f":"IF(H200<0,\"NA\",IRR($D$199:H199,0.05)*12)","v":"NA"},{"$f":"IF(I200<0,\"NA\",IRR($D$199:I199,0.05)*12)","v":"NA"},{"$f":"IF(J200<0,\"NA\",IRR($D$199:J199,0.05)*12)","v":"NA"},{"$f":"IF(K200<0,\"NA\",IRR($D$199:K199,0.05)*12)","v":"NA"},{"$f":"IF(L200<0,\"NA\",IRR($D$199:L199,0.05)*12)","v":"NA"},{"$f":"IF(M200<0,\"NA\",IRR($D$199:M199,0.05)*12)","v":0.12009988161049723},{"$f":"IF(N200<0,\"NA\",IRR($D$199:N199,0.05)*12)","v":0.35568045294941797},{"$f":"IF(O200<0,\"NA\",IRR($D$199:O199,0.05)*12)","v":0.53945353541088892},{"$f":"IF(P200<0,\"NA\",IRR($D$199:P199,0.05)*12)","v":0.6850160926583797},{"$f":"IF(Q200<0,\"NA\",IRR($D$199:Q199,0.05)*12)","v":0.80182937950460076},{"$f":"IF(R200<0,\"NA\",IRR($D$199:R199,0.05)*12)","v":0.89663511860660794},{"$f":"IF(S200<0,\"NA\",IRR($D$199:S199,0.05)*12)","v":0.97433824573002159},{"$f":"IF(T200<0,\"NA\",IRR($D$199:T199,0.05)*12)","v":1.0385734071122963},{"$f":"IF(U200<0,\"NA\",IRR($D$199:U199,0.05)*12)","v":1.0920780762776854},{"$f":"IF(V200<0,\"NA\",IRR($D$199:V199,0.05)*12)","v":1.1369440807184654},{"$f":"IF(W200<0,\"NA\",IRR($D$199:W199,0.05)*12)","v":1.1747907346098021},{"$f":"IF(X200<0,\"NA\",IRR($D$199:X199,0.05)*12)","v":1.2068862705389209},{"$f":"IF(Y200<0,\"NA\",IRR($D$199:Y199,0.05)*12)","v":1.234234468443975},{"$f":"IF(Z200<0,\"NA\",IRR($D$199:Z199,0.05)*12)","v":1.2576374170089899},{"$f":"IF(AA200<0,\"NA\",IRR($D$199:AA199,0.05)*12)","v":1.2777416270893607},{"$f":"IF(AB200<0,\"NA\",IRR($D$199:AB199,0.05)*12)","v":1.2950723516457998},{"$f":"IF(AC200<0,\"NA\",IRR($D$199:AC199,0.05)*12)","v":1.3100594316428786},{"$f":"IF(AD200<0,\"NA\",IRR($D$199:AD199,0.05)*12)","v":1.3230569726321582},{"$f":"IF(AE200<0,\"NA\",IRR($D$199:AE199,0.05)*12)","v":1.3343584761762335},{"$f":"IF(AF200<0,\"NA\",IRR($D$199:AF199,0.05)*12)","v":1.3442085840895457},{"$f":"IF(AG200<0,\"NA\",IRR($D$199:AG199,0.05)*12)","v":1.3528122730239946},{"$f":"IF(AH200<0,\"NA\",IRR($D$199:AH199,0.05)*12)","v":1.3603421108370588},{"$f":"IF(AI200<0,\"NA\",IRR($D$199:AI199,0.05)*12)","v":1.3669440263798158},{"$f":"IF(AJ200<0,\"NA\",IRR($D$199:AJ199,0.05)*12)","v":1.3727419294796217},{"$f":"IF(AK200<0,\"NA\",IRR($D$199:AK199,0.05)*12)","v":1.3778414345810077},{"$f":"IF(AL200<0,\"NA\",IRR($D$199:AL199,0.05)*12)","v":1.3823328804626422},{"$f":"IF(AM200<0,\"NA\",IRR($D$199:AM199,0.05)*12)","v":1.3862937932952084},{"$f":"IF(AN200<0,\"NA\",IRR($D$199:AN199,0.05)*12)","v":1.3897909066119603},{"$f":"IF(AO200<0,\"NA\",IRR($D$199:AO199,0.05)*12)","v":1.3928818264123564},{"$f":"IF(AP200<0,\"NA\",IRR($D$199:AP199,0.05)*12)","v":1.3956164103940818},{"$f":"IF(AQ200<0,\"NA\",IRR($D$199:AQ199,0.05)*12)","v":1.3980379156213472},{"$f":"IF(AR200<0,\"NA\",IRR($D$199:AR199,0.05)*12)","v":1.4001839576377444},{"$f":"IF(AS200<0,\"NA\",IRR($D$199:AS199,0.05)*12)","v":1.4020873152806885},{"$f":"IF(AT200<0,\"NA\",IRR($D$199:AT199,0.05)*12)","v":1.4037766086342023},{"$f":"IF(AU200<0,\"NA\",IRR($D$199:AU199,0.05)*12)","v":1.4052768722094005},{"$f":"IF(AV200<0,\"NA\",IRR($D$199:AV199,0.05)*12)","v":1.4066100412255693},{"$f":"IF(AW200<0,\"NA\",IRR($D$199:AW199,0.05)*12)","v":1.4077953655219648},{"$f":"IF(AX200<0,\"NA\",IRR($D$199:AX199,0.05)*12)","v":1.4088497629665095},{"$f":"IF(AY200<0,\"NA\",IRR($D$199:AY199,0.05)*12)","v":1.4097881220942563},{"$f":"IF(AZ200<0,\"NA\",IRR($D$199:AZ199,0.05)*12)","v":1.4106235619917475},{"$f":"IF(BA200<0,\"NA\",IRR($D$199:BA199,0.05)*12)","v":1.4113676560836179},{"$f":"IF(BB200<0,\"NA\",IRR($D$199:BB199,0.05)*12)","v":1.412030625165352},{"$f":"IF(BC200<0,\"NA\",IRR($D$199:BC199,0.05)*12)","v":1.4126215046453767},{"$f":"IF(BD200<0,\"NA\",IRR($D$199:BD199,0.05)*12)","v":1.4131482893443588},{"$f":"IF(BE200<0,\"NA\",IRR($D$199:BE199,0.05)*12)","v":1.4136180594161241},{"$f":"IF(BF200<0,\"NA\",IRR($D$199:BF199,0.05)*12)","v":1.4140370899618286},{"$f":"IF(BG200<0,\"NA\",IRR($D$199:BG199,0.05)*12)","v":1.414410946643673},{"$f":"IF(BH200<0,\"NA\",IRR($D$199:BH199,0.05)*12)","v":1.4147445692329343},{"$f":"IF(BI200<0,\"NA\",IRR($D$199:BI199,0.05)*12)","v":1.4150423447355447},{"$f":"IF(BJ200<0,\"NA\",IRR($D$199:BJ199,0.05)*12)","v":1.4153081714946749},{"$f":"IF(BK200<0,\"NA\",IRR($D$199:BK199,0.05)*12)","v":1.4155455154655732},{"$f":"IF(BL200<0,\"NA\",IRR($D$199:BL199,0.05)*12)","v":1.4157574596858913}]
[null,null,"NPV",{"$f":"NPV($G$113,D199)","v":-4950.2439024390251},{"$f":"NPV($G$113,$D$199:E199)","v":-4980.7305175490783},{"$f":"NPV($G$113,$D$199:F199)","v":-4354.8823725714947},{"$f":"NPV($G$113,$D$199:G199)","v":-3744.2988164958037},{"$f":"NPV($G$113,$D$199:H199)","v":-3148.6075422756176},{"$f":"NPV($G$113,$D$199:I199)","v":-2567.4453235242163},{"$f":"NPV($G$113,$D$199:J199)","v":-2000.4577930350442},{"$f":"NPV($G$113,$D$199:K199)","v":-1447.2992267041448},{"$f":"NPV($G$113,$D$199:L199)","v":-907.6323327227791},{"$f":"NPV($G$113,$D$199:M199)","v":-381.12804591169055},{"$f":"NPV($G$113,$D$199:N199)","v":132.53467292839582},{"$f":"NPV($G$113,$D$199:O199)","v":633.66903277238248},{"$f":"NPV($G$113,$D$199:P199)","v":1122.5806033518818},{"$f":"NPV($G$113,$D$199:Q199)","v":1599.5675014782228},{"$f":"NPV($G$113,$D$199:R199)","v":2064.920572820994},{"$f":"NPV($G$113,$D$199:S199)","v":2518.9235692529664},{"$f":"NPV($G$113,$D$199:T199)","v":2961.8533218695252},{"$f":"NPV($G$113,$D$199:U199)","v":3393.9799097881187},{"$f":"NPV($G$113,$D$199:V199)","v":3815.5668248306488},{"$f":"NPV($G$113,$D$199:W199)","v":4226.8711321892151},{"$f":"NPV($G$113,$D$199:X199)","v":4628.1436271731818},{"$f":"NPV($G$113,$D$199:Y199)","v":5019.6289881331504},{"$f":"NPV($G$113,$D$199:Z199)","v":5401.5659256550698},{"$f":"NPV($G$113,$D$199:AA199)","v":5774.1873281154794},{"$f":"NPV($G$113,$D$199:AB199)","v":6137.7204036866115},{"$f":"NPV($G$113,$D$199:AC199)","v":6492.3868188779588},{"$f":"NPV($G$113,$D$199:AD199)","v":6838.4028336987858},{"$f":"NPV($G$113,$D$199:AE199)","v":7175.9794335239822},{"$f":"NPV($G$113,$D$199:AF199)","v":7505.3224577436868},{"$f":"NPV($G$113,$D$199:AG199)","v":7826.6327252751062},{"$f":"NPV($G$113,$D$199:AH199)","v":8140.106157013076},{"$f":"NPV($G$113,$D$199:AI199)","v":8445.9338952940216},{"$f":"NPV($G$113,$D$199:AJ199)","v":8744.3024204461653},{"$f":"NPV($G$113,$D$199:AK199)","v":9035.3936644970363},{"$f":"NPV($G$113,$D$199:AL199)","v":9319.385122107642},{"$f":"NPV($G$113,$D$199:AM199)","v":9596.4499588009166},{"$f":"NPV($G$113,$D$199:AN199)","v":9866.7571165504523},{"$f":"NPV($G$113,$D$199:AO199)","v":10130.471416793902},{"$f":"NPV($G$113,$D$199:AP199)","v":10387.753660933853},{"$f":"NPV($G$113,$D$199:AQ199)","v":10638.760728387464},{"$f":"NPV($G$113,$D$199:AR199)","v":10883.645672244646},{"$f":"NPV($G$113,$D$199:AS199)","v":11122.557812593115},{"$f":"NPV($G$113,$D$199:AT199)","v":11355.642827567232},{"$f":"NPV($G$113,$D$199:AU199)","v":11583.042842176126},{"$f":"NPV($G$113,$D$199:AV199)","v":11804.896514965292},{"$f":"NPV($G$113,$D$199:AW199)","v":12021.339122564475},{"$f":"NPV($G$113,$D$199:AX199)","v":12232.502642173436},{"$f":"NPV($G$113,$D$199:AY199)","v":12438.515832035839},{"$f":"NPV($G$113,$D$199:AZ199)","v":12639.504309950376},{"$f":"NPV($G$113,$D$199:BA199)","v":12835.590629867},{"$f":"NPV($G$113,$D$199:BB199)","v":13026.894356614923},{"$f":"NPV($G$113,$D$199:BC199)","v":13213.532138808019},{"$f":"NPV($G$113,$D$199:BD199)","v":13395.617779972017},{"$f":"NPV($G$113,$D$199:BE199)","v":13573.262307936891},{"$f":"NPV($G$113,$D$199:BF199)","v":13746.574042536768},{"$f":"NPV($G$113,$D$199:BG199)","v":13915.658661658601},{"$f":"NPV($G$113,$D$199:BH199)","v":14080.619265679899},{"$f":"NPV($G$113,$D$199:BI199)","v":14241.556440334827},{"$f":"NPV($G$113,$D$199:BJ199)","v":14398.56831804695},{"$f":"NPV($G$113,$D$199:BK199)","v":14551.750637766096},{"$f":"NPV($G$113,$D$199:BL199)","v":14701.196803345749}]
[null,null,"Breakeven Counter",{"$f":"IF(D200>0,1,0)","v":0},{"$f":"IF(E200>0,1,0)","v":0},{"$f":"IF(F200>0,1,0)","v":0},{"$f":"IF(G200>0,1,0)","v":0},0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Breakeven Month",{"$f":"+D203*D180-SUM(C$203:$E203)","v":0},{"$f":"+E203*E180-SUM(D$203:$E203)","v":0},{"$f":"+F203*F180-SUM($E$203:E203)","v":0},{"$f":"+G203*G180-SUM($E$203:F203)","v":0},{"$f":"+H203*H180-SUM($E$203:G203)","v":0},{"$f":"+I203*I180-SUM($E$203:H203)","v":0},{"$f":"+J203*J180-SUM($E$203:I203)","v":0},{"$f":"+K203*K180-SUM($E$203:J203)","v":0},{"$f":"+L203*L180-SUM($E$203:K203)","v":0},{"$f":"+M203*M180-SUM($E$203:L203)","v":9},{"$f":"+N203*N180-SUM($E$203:M203)","v":9},{"$f":"+O203*O180-SUM($E$203:N203)","v":9},{"$f":"+P203*P180-SUM($E$203:O203)","v":9},{"$f":"+Q203*Q180-SUM($E$203:P203)","v":9},{"$f":"+R203*R180-SUM($E$203:Q203)","v":9},{"$f":"+S203*S180-SUM($E$203:R203)","v":9},{"$f":"+T203*T180-SUM($E$203:S203)","v":9},{"$f":"+U203*U180-SUM($E$203:T203)","v":9},{"$f":"+V203*V180-SUM($E$203:U203)","v":9},{"$f":"+W203*W180-SUM($E$203:V203)","v":9},{"$f":"+X203*X180-SUM($E$203:W203)","v":9},{"$f":"+Y203*Y180-SUM($E$203:X203)","v":9},{"$f":"+Z203*Z180-SUM($E$203:Y203)","v":9},{"$f":"+AA203*AA180-SUM($E$203:Z203)","v":9},{"$f":"+AB203*AB180-SUM($E$203:AA203)","v":9},{"$f":"+AC203*AC180-SUM($E$203:AB203)","v":9},{"$f":"+AD203*AD180-SUM($E$203:AC203)","v":9},{"$f":"+AE203*AE180-SUM($E$203:AD203)","v":9},{"$f":"+AF203*AF180-SUM($E$203:AE203)","v":9},{"$f":"+AG203*AG180-SUM($E$203:AF203)","v":9},{"$f":"+AH203*AH180-SUM($E$203:AG203)","v":9},{"$f":"+AI203*AI180-SUM($E$203:AH203)","v":9},{"$f":"+AJ203*AJ180-SUM($E$203:AI203)","v":9},{"$f":"+AK203*AK180-SUM($E$203:AJ203)","v":9},{"$f":"+AL203*AL180-SUM($E$203:AK203)","v":9},{"$f":"+AM203*AM180-SUM($E$203:AL203)","v":9},{"$f":"+AN203*AN180-SUM($E$203:AM203)","v":9},{"$f":"+AO203*AO180-SUM($E$203:AN203)","v":9},{"$f":"+AP203*AP180-SUM($E$203:AO203)","v":9},{"$f":"+AQ203*AQ180-SUM($E$203:AP203)","v":9},{"$f":"+AR203*AR180-SUM($E$203:AQ203)","v":9},{"$f":"+AS203*AS180-SUM($E$203:AR203)","v":9},{"$f":"+AT203*AT180-SUM($E$203:AS203)","v":9},{"$f":"+AU203*AU180-SUM($E$203:AT203)","v":9},{"$f":"+AV203*AV180-SUM($E$203:AU203)","v":9},{"$f":"+AW203*AW180-SUM($E$203:AV203)","v":9},{"$f":"+AX203*AX180-SUM($E$203:AW203)","v":9},{"$f":"+AY203*AY180-SUM($E$203:AX203)","v":9},{"$f":"+AZ203*AZ180-SUM($E$203:AY203)","v":9},{"$f":"+BA203*BA180-SUM($E$203:AZ203)","v":9},{"$f":"+BB203*BB180-SUM($E$203:BA203)","v":9},{"$f":"+BC203*BC180-SUM($E$203:BB203)","v":9},{"$f":"+BD203*BD180-SUM($E$203:BC203)","v":9},{"$f":"+BE203*BE180-SUM($E$203:BD203)","v":9},{"$f":"+BF203*BF180-SUM($E$203:BE203)","v":9},{"$f":"+BG203*BG180-SUM($E$203:BF203)","v":9},{"$f":"+BH203*BH180-SUM($E$203:BG203)","v":9},{"$f":"+BI203*BI180-SUM($E$203:BH203)","v":9},{"$f":"+BJ203*BJ180-SUM($E$203:BI203)","v":9},{"$f":"+BK203*BK180-SUM($E$203:BJ203)","v":9},{"$f":"+BL203*BL180-SUM($E$203:BK203)","v":9}]
[null,null,"NPV",{"$f":"IF(B9=36,AN202,IF(B9=48,AZ202,IF(B9=60,BL202)))","v":9866.7571165504523}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hospitality Video Capex",null,null,null,"Hospitaltiy Internet Capex"]
["Equipment "," Capex","Labor",null,"Equipment "," Capex","Labor","MRC"]
["DTA",32.5,15,null,"SMC Router",{"$f":"72*2","v":144},150,{"$f":"+SUM('Sales Order'!D41:E46)+SUM('Sales Order'!D48:E54)","v":114.9}]
["HD DTA",55,18]
["HDSTB",120,18,null,"Hospitaltiy Voice Capex"]
["mDTA",9965,1750,null,"Equipment "," Capex","Labor","MRC"]
["Mini mDTA",3700,800,null,"EMTA",130,150,{"$f":"+SUM('Sales Order'!E26:E30)+SUM('Sales Order'!D32:E33)","v":207.64999999999998}]
["Q2Q",15510,1750]
["Set Top Box",130,15]
[]
["Capex Element",null,"Capex"]
["Construction Capex",null,{"$f":"+B6","v":0}]
["HD Video"]
["   Q2Q Equipment",null,{"$f":"IF($B$14=\"Yes\",B222,0)","v":15510},"Zeroed Out"]
["   HD DTA Equipment",null,{"$f":"IF(AND($B$5<=80,$B$14=\"Yes\"),(B218*B5),0)*0","v":0}]
["   Q2Q Labor",null,{"$f":"IF($B$14=\"Yes\",C222,0)","v":1750},"Zeroed Out"]
["   HD DTA Labor",null,{"$f":"IF(AND($B$5<=80,$B$14=\"Yes\"),C218,0)*0","v":0}]
["   HDSTB Equipment",null,{"$f":"IF(AND($B$5<=50,$B$14=\"No\",$B$15=\"Yes\"),(B218*B5),0)","v":0}]
["Standard Video"]
["   mDTA Equipment",null,{"$f":"IF(AND($B$5>=50,$B$14=\"No\"),B220,0)","v":0}]
["   DTA Equipment",null,{"$f":"IF(AND($B$5<=50,$B$14=\"No\",$C$35=\"No\"),(B217*B5),0)","v":0}]
["   Set Top Equipment",null,{"$f":"IF(AND($B$5<=50,$B$14=\"No\",$B$15=\"Yes\"),(B223*B5),0)","v":0}]
["   Mini mDTA"]
["   mDTA Labor",null,{"$f":"IF(AND($B$5>=50,$B$14=\"No\"),C220,0)","v":0}]
["   DTA Labor",null,{"$f":"IF(AND($B$5<=50,$B$14=\"No\",$B$15=\"No\"),(C217),0)","v":0}]
["   Set Top Labor",null,{"$f":"IF(AND($B$5<=50,$B$14=\"No\",$C$35=\"Yes\"),(C223),0)","v":0}]
["   Mini mDTA Labor"]
["Internet (Equipment + Labor)",null,{"$f":"IF(H217>0,F217+G217,0)","v":294},0]
["Voice (Equipment + Labor)",null,{"$f":"IF(H221>0,F221+G221,0)","v":280}]
["Capex Adjustment",null,{"$f":"+C118","v":0}]
["  Total Capex",null,{"$f":"SUM(C226:C244)","v":17834}]

{"sheet":"LOA","index":5,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[55,1,55,8],[56,1,56,8],[40,1,40,8],[41,1,44,8],[45,1,45,8],[46,1,48,8],[49,1,49,8],[51,4,51,6],[36,2,36,4],[36,5,36,7],[37,2,37,4],[37,5,37,7],[38,2,38,4],[38,5,38,7],[33,2,33,4],[33,5,33,7],[34,2,34,4],[34,5,34,7],[35,2,35,4],[35,5,35,7],[30,2,30,4],[30,5,30,7],[31,2,31,4],[31,5,31,7],[32,2,32,4],[32,5,32,7],[27,2,27,4],[27,5,27,7],[28,2,28,4],[28,5,28,7],[29,2,29,4],[29,5,29,7],[24,2,24,4],[24,5,24,7],[25,2,25,4],[25,5,25,7],[26,2,26,4],[26,5,26,7],[23,2,23,4],[23,5,23,7],[5,1,5,8],[7,1,7,8],[9,3,9,8],[11,2,11,8],[12,2,12,4],[14,1,15,8],[16,1,18,8],[21,2,21,4],[21,5,21,7],[22,2,22,4],[22,5,22,7]]}
[]
[]
[]
[]
[]
[null,"Letter of Agency"]
[]
[null,"Please print or type the following information.  All blank spaces must be completed."]
[]
[null,"Billing Name (\"Company\"):"]
[null,null,null,null,"(As it appears on customers bill copy)"]
[null,"Billing Address: "]
[null,"City:",null,null,null,"State:",null,"Zip:"]
[]
[null,"If the company is switching its current phone number(s) to Comcast, please print the telephone number(s) and the name(s) of Company's current local phone service providers in the spaces below."]
[]
[null,"Area code(s) and telephone number(s) Company wants switched to Comcast (you may also insert a number range, e.g., 215-555-0000 thru 215-555-9999):"]
[]
[]
[]
[null,null,"Billing Telephone Number",null,null,"Current Local Provider"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please read the following:"]
[null,"The undersigned is an authorized representative Company.  Company chooses Comcast for all its landline calling needs across town, across the country and worldwide for the telephone number(s) listed above (if applicable).  Company understands that Comcast will take the place of its current landline phone service provider(s) for local, local toll, and long distance services.  Company understands that, for each of these services, it may designate only one provider per service for any one telephone number.  Company also understands that the service provided by Comcast includes all distances, which means that Company may only designate one provider for all of its calling needs for any one telephone number."]
[]
[]
[]
[]
[null,"The undersigned’s signature on this form authorizes Comcast to act as Company’s agent in making the changes from Company’s current service provider(s), and to switch Company’s telephone number(s), listed above (if applicable), to Comcast.  Company understands that its current service provider(s) may charge a fee to switch its service to Comcast and that Company may consult that provider as to whether a fee will apply."]
[]
[]
[null,"Please sign here:"]
[]
[null,"Authorized Representative's Signature:",null,null,null,null,null,"Date:"]
[null,"Authorized Representative's Name (Print):"]
[null,"Authorized Representative's Title (Print): "]

{"sheet":"TOLL FREE-Resporg","index":6,"n_rows":44,"n_cols":36,"rows_kept":44,"cut":false,"hidden":false,"merged":[[38,2,38,12],[40,2,40,3],[40,4,40,7],[40,9,40,11],[43,2,43,3],[43,4,43,7],[43,9,43,11],[33,3,33,5],[35,4,35,6],[35,8,35,11],[37,2,37,3],[37,4,37,6],[37,9,37,11],[27,3,27,6],[29,2,29,3],[29,4,29,8],[30,4,30,8],[31,2,31,3],[31,4,31,8],[26,3,26,6],[15,3,15,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[19,3,19,6],[20,3,20,6],[21,3,21,6],[22,3,22,6],[23,3,23,6],[24,3,24,6],[25,3,25,6],[14,3,14,6],[4,2,4,12],[5,2,5,3],[5,4,5,5],[6,2,6,12],[7,4,7,6],[7,10,7,11],[9,3,9,6],[10,3,10,6],[11,3,11,6],[12,3,12,6],[13,3,13,6]]}
[]
[]
[]
[]
[null,null,"Responsible Organization Letter of Authorization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resp Org"]
[null,null,"Toll Free Portability ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 3 Communications, LLC (JSS01)  (“Level 3”)","JSS01"]
[null,null,"As the end-user subscriber, or the authorized representative of an end-user subscriber, of certain Toll Free service numbers (the “Customer”), I hereby authorize Comcast Phone, LLC to be the Responsible Organization(\"Resp Org\") for the following TollFree service numbers, including acting on my behalf, and at my direction, to transfer the Resp org function from"]
[null,null,"Current Carrier: ",null,null,null,null,"New Resp Org ID:",null,null,"JTN01"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Customer Name:"]
[null,null,null,null,"(As it appears on customers bill copy)"]
[null,null,"Address:"]
[]
[null,null,"City",null,null,null,"State ",null,"Zip ",null,"-"]
[]
[null,null,"Customer Contact",null,null,null,null,"Phone:"]
[]
[null,null,null,null,null,null,null,"Delivery Date: "]
[null,null,"I attest under penalty of law and as an authorized employee, or an authorized representative, of the Customer that the Customer is the exclusive end-user subscriber of the Toll Free service numbers listed above. The Customer assumes all liability for the use (including without limitation, authorized, fraudulent or misappropriated) of traffic of any other end-user subscriber with regards to the Toll Free service numbers listed. In addition, I understand that this request for a Resp Org change does not constitute an order for disconnect of service with my existing carrier(s). I, on behalf of the Customer, continue to accept responsibility for notifying my existing carrier(s) of any intention to disconnect and/or change my Toll Free service after designating the above as my Resp Org for the Toll Free numbers listed above."]
[]
[null,null,"Authorized Signature",null,null,null,null,null,"Date:"]
[]
[]
[null,null,"Print Name",null,null,null,null,null,"Title:  "]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"IP Justification Form","index":8,"n_rows":39,"n_cols":33,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,0,5,4],[5,5,5,13],[5,22,5,31],[0,0,0,32],[2,1,2,31],[4,0,4,4],[4,15,4,21],[4,22,4,31],[6,0,6,4],[6,5,6,13],[6,22,6,31],[7,0,7,4],[7,5,7,13],[7,22,7,31],[8,0,8,4],[8,5,8,13],[8,16,8,21],[8,22,8,31],[9,0,9,4],[9,5,9,13],[11,7,11,17],[14,13,14,32],[16,18,16,19],[16,21,18,32],[21,1,21,3],[21,4,21,10],[21,11,21,32],[22,1,22,3],[22,4,22,10],[22,11,22,32],[23,1,23,3],[23,4,23,10],[23,11,23,32],[24,1,24,3],[24,4,24,10],[24,11,24,32],[25,1,25,3],[25,4,25,10],[25,11,25,32],[26,1,26,3],[26,4,26,10],[26,11,26,32],[27,1,27,3],[27,4,27,10],[27,11,27,32],[28,1,28,3],[28,4,28,10],[28,11,28,32],[29,1,29,3],[29,4,29,10],[29,11,29,32],[30,1,30,3],[30,4,30,10],[30,11,30,32],[36,1,36,4],[36,5,36,16],[36,17,36,20],[36,21,36,32],[37,1,37,4],[37,5,37,16],[37,17,37,20],[37,21,37,32],[38,1,38,4],[38,5,38,16],[38,17,38,20],[38,21,38,32]]}
["                        IP Justification Form"]
[]
[]
[]
["Customer Site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technical Contact"]
["Location Name",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Name (Last, First)",null,null,null,null,null,null,null,null,null,null,"3a"]
["Street",null,null,null,null,null,null,null,null,null,null,null,null,null,"2a",null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,null,null,"3b"]
["Rm/Ste/Fl",null,null,null,null,null,null,null,null,null,null,null,null,null,"2b",null,null,null,null,null,null,"Phone #",null,null,null,null,null,null,null,null,null,null,"3c"]
["City/St/Zip",null,null,null,null,null,null,null,null,null,null,null,null,null,"2c",null,"E-mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3d"]
["Phone #",null,null,null,null,null,null,null,null,null,null,null,null,null,"2d"]
[]
[null,"4.","Domain Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: If more than one domain, use first domain registered."]
[]
[null,"5.","Do you have previously assigned addresses from Comcast?:"]
[null,null,"5d.","If yes, what addresses were assigned?:"]
[]
[null,"6.","Number of IP addresses requested/needed within 6 months: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: If your organization already has IP space assigned, you must utilize 80% before applying for more IP space."]
[]
[]
[null,"7. Use the following Network Table to describe your IP assignments within the next six months.   THIS IS REQUIRED."]
[]
[null,"IP Number",null,null,"IP Address (If known)",null,null,null,null,null,null,"Below, provide a description of use for each IP requested"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[]
[null,"I verify that I am authorized to represent the organization below and that the above information is true and correct.  I"]
[null,"understand that Internet Protocol Version 4 address space is limited and that users of the Internet are responsible for"]
[null,"conserving address space and ensuring that space is utilized efficiently."]
[]
[null,"Print Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title"]
[null,"Organization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone # (day)"]
[null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fax"]