{"text_format":"3","workbook":"xlsx","n_sheets":19,"sheets":["Front Sheet","DatabaseStatic","DatabaseMoving","DatabaseInfo","Schedule","List of Restrictions","Road 1","Road 2","Road 3","Road 4","Road 5","Road 6","Road 7","Road 8","Road 9","Road 10","TTRO Summary","Cost Summary","Restriction Costs"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Front Sheet","index":0,"n_rows":64,"n_cols":49,"rows_kept":64,"merged":[[0,1,2,26],[5,1,5,7],[5,18,5,24],[7,1,7,7],[7,8,7,17],[8,1,8,7],[8,8,8,17],[8,18,8,24],[8,25,8,34],[9,1,9,7],[9,8,9,17],[9,18,9,24],[9,25,9,34],[10,1,10,7],[10,8,10,17],[10,18,10,24],[10,25,10,34],[11,1,11,7],[11,8,11,17],[11,18,11,24],[11,25,11,34],[12,1,12,7],[12,8,12,13],[12,18,12,24],[12,25,12,30],[13,1,13,7],[13,8,13,13],[13,18,13,24],[13,25,13,30],[14,1,14,7],[14,8,14,17],[14,18,14,24],[14,25,14,34],[16,8,16,34],[20,1,20,8],[22,1,22,15],[22,16,22,34],[24,1,24,15],[24,16,24,34],[25,1,25,15],[27,1,27,15],[27,16,30,34],[28,1,28,15],[32,1,34,9],[32,10,34,34],[39,1,42,34],[44,1,44,11],[44,12,44,34],[45,1,45,11],[45,12,45,34],[47,1,47,11],[47,12,47,34],[48,1,48,11],[48,12,48,34],[52,1,52,6],[54,1,54,9],[54,10,54,14],[54,16,54,19],[54,20,54,21],[55,1,55,9],[55,10,55,14],[55,20,57,34],[57,1,60,18],[59,20,60,34]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Applicants Details:",{"$nulls":16},"Invoice Details:",{"$nulls":29},"Application to be emailed to:  highway.management@nottinghamcity.gov.uk "]
[]
[null,"Applicant Name:",{"$nulls":23},"Leave blank if same as applicant details"]
[null,"Organisation:",{"$nulls":16},"Organisation:"]
[null,"Address (line 1):",{"$nulls":16},"Invoice Address (1):"]
[null,"(line 2):",{"$nulls":16},"Invoice Address (2):"]
[null,"(line 3):",{"$nulls":16},"Invoice Address (3):"]
[null,"Postcode:",{"$nulls":16},"Postcode:"]
[null,"Telephone No:",{"$nulls":16},"Telephone No:"]
[null,"Email:",{"$nulls":16},"Email:"]
[]
[{"$nulls":7},"Payment Ref / Cost Code:"]
[]
[]
[]
[null,"Activity / Works Details:"]
[]
[null,"Project Reference:"]
[]
[null,"NRSWA Notice / Permit Reference No:"]
[null,"(if known)"]
[]
[null,"Reason for TTRO Request:"]
[null,"(e.g. mains renewal, crane operation etc)"]
[]
[]
[]
[null,"If application involves a road closure, please give diversion route details:"]
[]
[]
[]
[null,"Are these emergency works (as defined in S52 of NRSWA 1991):",{"$nulls":38},2,"1 = yes, 2 = no"]
[]
[null,"If Yes, please state the reason why these are Emergency / Urgent works:"]
[]
[]
[]
[]
[]
[null,"In hours site contact name:"]
[null,"In hours site contact number:"]
[]
[null,"Out of hours site contact name:"]
[null,"Out of hours site contact number:"]
[]
[]
[]
[null,"Activity Duration:"]
[]
[null,"Date of implementation:",{"$nulls":14},"Duration:",{"$nulls":3},{"$f":"IF(AND(K55<>\"\",K56<>\"\"),(K56 -K55)+1,\"\")","v":""},null,"days (inclusive)"]
[null,"Date restrictions to end:",{"$nulls":18},{"$f":"IF(U55=\"\",\"\",IF(U55>5,\"Duration greater than 5 days, therefore full TTRO order required.  The cost of advertising a TTRO is £\" & Schedule!N4 &\".\",\"\"))","v":""}]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""}]
[]
[{"$nulls":20},{"$f":"IF(AND(K55<>\"\",K56<>\"\"),IF(AND(AO37=1,U55>21),\"WARNING:  An Emergency Closure can only last for 21 days!!\",\"\"),\"\")","v":""}]
[]
[]
[]
["Application to be emailed to:  highway.management@nottinghamcity.gov.uk "]

{"sheet":"DatabaseStatic","index":1,"n_rows":2,"n_cols":152,"rows_kept":2,"hidden":true}
["TTRORef","Road1Name","Road1USRN","Road1Ward","Road1S1","Road1S1Loc","Road1S1Ext","Road1S2","Road1S2Loc","Road1S2Ext","Road1S3","Road1S3Loc","Road1S3Ext","Road1S4","Road1S4Loc","Road1S4Ext","Road2Name","Road2USRN","Road2Ward","Road2S1","Road2S1Loc","Road2S1Ext","Road2S2","Road2S2Loc","Road2S2Ext","Road2S3","Road2S3Loc","Road2S3Ext","Road2S4","Road2S4Loc","Road2S4Ext","Road3Name","Road3USRN","Road3Ward","Road3S1","Road3S1Loc","Road3S1Ext","Road3S2","Road3S2Loc","Road3S2Ext","Road3S3","Road3S3Loc","Road3S3Ext","Road3S4","Road3S4Loc","Road3S4Ext","Road4Name","Road4USRN","Road4Ward","Road4S1","Road4S1Loc","Road4S1Ext","Road4S2","Road4S2Loc","Road4S2Ext","Road4S3","Road4S3Loc","Road4S3Ext","Road4S4","Road4S4Loc","Road4S4Ext","Road5Name","Road5USRN","Road5Ward","Road5S1","Road5S1Loc","Road5S1Ext","Road5S2","Road5S2Loc","Road5S2Ext","Road5S3","Road5S3Loc","Road5S3Ext","Road5S4","Road5S4Loc","Road5S4Ext","Road6Name","Road6USRN","Road6Ward","Road6S1","Road6S1Loc","Road6S1Ext","Road6S2","Road6S2Loc","Road6S2Ext","Road6S3","Road6S3Loc","Road6S3Ext","Road6S4","Road6S4Loc","Road6S4Ext","Road7Name","Road7USRN","Road7Ward","Road7S1","Road7S1Loc","Road7S1Ext","Road7S2","Road7S2Loc","Road7S2Ext","Road7S3","Road7S3Loc","Road7S3Ext","Road7S4","Road7S4Loc","Road7S4Ext","Road8Name","Road8USRN","Road8Ward","Road8S1","Road8S1Loc","Road8S1Ext","Road8S2","Road8S2Loc","Road8S2Ext","Road8S3","Road8S3Loc","Road8S3Ext","Road8S4","Road8S4Loc","Road8S4Ext","Road9Name","Road9USRN","Road9Ward","Road9S1","Road9S1Loc","Road9S1Ext","Road9S2","Road9S2Loc","Road9S2Ext","Road9S3","Road9S3Loc","Road9S3Ext","Road9S4","Road9S4Loc","Road9S4Ext","Road10Name","Road10USRN","Road10Ward","Road10S1","Road10S1Loc","Road10S1Ext","Road10S2","Road10S2Loc","Road10S2Ext","Road10S3","Road10S3Loc","Road10S3Ext","Road10S4","Road10S4Loc","Road10S4Ext","SourceFile"]
[null,{"$f":"IF('Road 1'!$Q$6=0,\"\",'Road 1'!$Q$6)","v":""},{"$f":"IF('Road 1'!$Q$7=0,\"\",'Road 1'!$Q$7)","v":""},{"$f":"IF('Road 1'!$Q$8=0,\"\",'Road 1'!$Q$8)","v":""},{"$f":"IF('Road 1'!$H$38=0,\"\",'Road 1'!$H$38)","v":""},{"$f":"IF('Road 1'!$H$39=0,\"\",'Road 1'!$H$39)","v":""},{"$f":"IF('Road 1'!$H$40=0,\"\",'Road 1'!$H$40)","v":""},{"$f":"IF('Road 1'!$H$44=0,\"\",'Road 1'!$H$44)","v":""},{"$f":"IF('Road 1'!$H$45=0,\"\",'Road 1'!$H$45)","v":""},{"$f":"IF('Road 1'!$H$46=0,\"\",'Road 1'!$H$46)","v":""},{"$f":"IF('Road 1'!$H$50=0,\"\",'Road 1'!$H$50)","v":""},{"$f":"IF('Road 1'!$H$51=0,\"\",'Road 1'!$H$51)","v":""},{"$f":"IF('Road 1'!$H$52=0,\"\",'Road 1'!$H$52)","v":""},{"$f":"IF('Road 1'!$H$56=0,\"\",'Road 1'!$H$56)","v":""},{"$f":"IF('Road 1'!$H$57=0,\"\",'Road 1'!$H$57)","v":""},{"$f":"IF('Road 1'!$H$58=0,\"\",'Road 1'!$H$58)","v":""},{"$f":"IF('Road 2'!$Q$6=0,\"\",'Road 2'!$Q$6)","v":""},{"$f":"IF('Road 2'!$Q$7=0,\"\",'Road 2'!$Q$7)","v":""},{"$f":"IF('Road 2'!$Q$8=0,\"\",'Road 2'!$Q$8)","v":""},{"$f":"IF('Road 2'!$H$38=0,\"\",'Road 2'!$H$38)","v":""},{"$f":"IF('Road 2'!$H$39=0,\"\",'Road 2'!$H$39)","v":""},{"$f":"IF('Road 2'!$H$40=0,\"\",'Road 2'!$H$40)","v":""},{"$f":"IF('Road 2'!$H$44=0,\"\",'Road 2'!$H$44)","v":""},{"$f":"IF('Road 2'!$H$45=0,\"\",'Road 2'!$H$45)","v":""},{"$f":"IF('Road 2'!$H$46=0,\"\",'Road 2'!$H$46)","v":""},{"$f":"IF('Road 2'!$H$50=0,\"\",'Road 2'!$H$50)","v":""},{"$f":"IF('Road 2'!$H$51=0,\"\",'Road 2'!$H$51)","v":""},{"$f":"IF('Road 2'!$H$52=0,\"\",'Road 2'!$H$52)","v":""},{"$f":"IF('Road 2'!$H$56=0,\"\",'Road 2'!$H$56)","v":""},{"$f":"IF('Road 2'!$H$57=0,\"\",'Road 2'!$H$57)","v":""},{"$f":"IF('Road 2'!$H$58=0,\"\",'Road 2'!$H$58)","v":""},{"$f":"IF('Road 3'!$Q$6=0,\"\",'Road 3'!$Q$6)","v":""},{"$f":"IF('Road 3'!$Q$7=0,\"\",'Road 3'!$Q$7)","v":""},{"$f":"IF('Road 3'!$Q$8=0,\"\",'Road 3'!$Q$8)","v":""},{"$f":"IF('Road 3'!$H$38=0,\"\",'Road 3'!$H$38)","v":""},{"$f":"IF('Road 3'!$H$39=0,\"\",'Road 3'!$H$39)","v":""},{"$f":"IF('Road 3'!$H$40=0,\"\",'Road 3'!$H$40)","v":""},{"$f":"IF('Road 3'!$H$44=0,\"\",'Road 3'!$H$44)","v":""},{"$f":"IF('Road 3'!$H$45=0,\"\",'Road 3'!$H$45)","v":""},{"$f":"IF('Road 3'!$H$46=0,\"\",'Road 3'!$H$46)","v":""},{"$f":"IF('Road 3'!$H$50=0,\"\",'Road 3'!$H$50)","v":""},{"$f":"IF('Road 3'!$H$51=0,\"\",'Road 3'!$H$51)","v":""},{"$f":"IF('Road 3'!$H$52=0,\"\",'Road 3'!$H$52)","v":""},{"$f":"IF('Road 3'!$H$56=0,\"\",'Road 3'!$H$56)","v":""},{"$f":"IF('Road 3'!$H$57=0,\"\",'Road 3'!$H$57)","v":""},{"$f":"IF('Road 3'!$H$58=0,\"\",'Road 3'!$H$58)","v":""},{"$f":"IF('Road 4'!$Q$6=0,\"\",'Road 4'!$Q$6)","v":""},{"$f":"IF('Road 4'!$Q$7=0,\"\",'Road 4'!$Q$7)","v":""},{"$f":"IF('Road 4'!$Q$8=0,\"\",'Road 4'!$Q$8)","v":""},{"$f":"IF('Road 4'!$H$38=0,\"\",'Road 4'!$H$38)","v":""},{"$f":"IF('Road 4'!$H$39=0,\"\",'Road 4'!$H$39)","v":""},{"$f":"IF('Road 4'!$H$40=0,\"\",'Road 4'!$H$40)","v":""},{"$f":"IF('Road 4'!$H$44=0,\"\",'Road 4'!$H$44)","v":""},{"$f":"IF('Road 4'!$H$45=0,\"\",'Road 4'!$H$45)","v":""},{"$f":"IF('Road 4'!$H$46=0,\"\",'Road 4'!$H$46)","v":""},{"$f":"IF('Road 4'!$H$50=0,\"\",'Road 4'!$H$50)","v":""},{"$f":"IF('Road 4'!$H$51=0,\"\",'Road 4'!$H$51)","v":""},{"$f":"IF('Road 4'!$H$52=0,\"\",'Road 4'!$H$52)","v":""},{"$f":"IF('Road 4'!$H$56=0,\"\",'Road 4'!$H$56)","v":""},{"$f":"IF('Road 4'!$H$57=0,\"\",'Road 4'!$H$57)","v":""},{"$f":"IF('Road 4'!$H$58=0,\"\",'Road 4'!$H$58)","v":""},{"$f":"IF('Road 5'!$Q$6=0,\"\",'Road 5'!$Q$6)","v":""},{"$f":"IF('Road 5'!$Q$7=0,\"\",'Road 5'!$Q$7)","v":""},{"$f":"IF('Road 5'!$Q$8=0,\"\",'Road 5'!$Q$8)","v":""},{"$f":"IF('Road 5'!$H$38=0,\"\",'Road 5'!$H$38)","v":""},{"$f":"IF('Road 5'!$H$39=0,\"\",'Road 5'!$H$39)","v":""},{"$f":"IF('Road 5'!$H$40=0,\"\",'Road 5'!$H$40)","v":""},{"$f":"IF('Road 5'!$H$44=0,\"\",'Road 5'!$H$44)","v":""},{"$f":"IF('Road 5'!$H$45=0,\"\",'Road 5'!$H$45)","v":""},{"$f":"IF('Road 5'!$H$46=0,\"\",'Road 5'!$H$46)","v":""},{"$f":"IF('Road 5'!$H$50=0,\"\",'Road 5'!$H$50)","v":""},{"$f":"IF('Road 5'!$H$51=0,\"\",'Road 5'!$H$51)","v":""},{"$f":"IF('Road 5'!$H$52=0,\"\",'Road 5'!$H$52)","v":""},{"$f":"IF('Road 5'!$H$56=0,\"\",'Road 5'!$H$56)","v":""},{"$f":"IF('Road 5'!$H$57=0,\"\",'Road 5'!$H$57)","v":""},{"$f":"IF('Road 5'!$H$58=0,\"\",'Road 5'!$H$58)","v":""},{"$f":"IF('Road 6'!$Q$6=0,\"\",'Road 6'!$Q$6)","v":""},{"$f":"IF('Road 6'!$Q$7=0,\"\",'Road 6'!$Q$7)","v":""},{"$f":"IF('Road 6'!$Q$8=0,\"\",'Road 6'!$Q$8)","v":""},{"$f":"IF('Road 6'!$H$38=0,\"\",'Road 6'!$H$38)","v":""},{"$f":"IF('Road 6'!$H$39=0,\"\",'Road 6'!$H$39)","v":""},{"$f":"IF('Road 6'!$H$40=0,\"\",'Road 6'!$H$40)","v":""},{"$f":"IF('Road 6'!$H$44=0,\"\",'Road 6'!$H$44)","v":""},{"$f":"IF('Road 6'!$H$45=0,\"\",'Road 6'!$H$45)","v":""},{"$f":"IF('Road 6'!$H$46=0,\"\",'Road 6'!$H$46)","v":""},{"$f":"IF('Road 6'!$H$50=0,\"\",'Road 6'!$H$50)","v":""},{"$f":"IF('Road 6'!$H$51=0,\"\",'Road 6'!$H$51)","v":""},{"$f":"IF('Road 6'!$H$52=0,\"\",'Road 6'!$H$52)","v":""},{"$f":"IF('Road 6'!$H$56=0,\"\",'Road 6'!$H$56)","v":""},{"$f":"IF('Road 6'!$H$57=0,\"\",'Road 6'!$H$57)","v":""},{"$f":"IF('Road 6'!$H$58=0,\"\",'Road 6'!$H$58)","v":""},{"$f":"IF('Road 7'!$Q$6=0,\"\",'Road 7'!$Q$6)","v":""},{"$f":"IF('Road 7'!$Q$7=0,\"\",'Road 7'!$Q$7)","v":""},{"$f":"IF('Road 7'!$Q$8=0,\"\",'Road 7'!$Q$8)","v":""},{"$f":"IF('Road 7'!$H$38=0,\"\",'Road 7'!$H$38)","v":""},{"$f":"IF('Road 7'!$H$39=0,\"\",'Road 7'!$H$39)","v":""},{"$f":"IF('Road 7'!$H$40=0,\"\",'Road 7'!$H$40)","v":""},{"$f":"IF('Road 7'!$H$44=0,\"\",'Road 7'!$H$44)","v":""},{"$f":"IF('Road 7'!$H$45=0,\"\",'Road 7'!$H$45)","v":""},{"$f":"IF('Road 7'!$H$46=0,\"\",'Road 7'!$H$46)","v":""},{"$f":"IF('Road 7'!$H$50=0,\"\",'Road 7'!$H$50)","v":""},{"$f":"IF('Road 7'!$H$51=0,\"\",'Road 7'!$H$51)","v":""},{"$f":"IF('Road 7'!$H$52=0,\"\",'Road 7'!$H$52)","v":""},{"$f":"IF('Road 7'!$H$56=0,\"\",'Road 7'!$H$56)","v":""},{"$f":"IF('Road 7'!$H$57=0,\"\",'Road 7'!$H$57)","v":""},{"$f":"IF('Road 7'!$H$58=0,\"\",'Road 7'!$H$58)","v":""},{"$f":"IF('Road 8'!$Q$6=0,\"\",'Road 8'!$Q$6)","v":""},{"$f":"IF('Road 8'!$Q$7=0,\"\",'Road 8'!$Q$7)","v":""},{"$f":"IF('Road 8'!$Q$8=0,\"\",'Road 8'!$Q$8)","v":""},{"$f":"IF('Road 8'!$H$38=0,\"\",'Road 8'!$H$38)","v":""},{"$f":"IF('Road 8'!$H$39=0,\"\",'Road 8'!$H$39)","v":""},{"$f":"IF('Road 8'!$H$40=0,\"\",'Road 8'!$H$40)","v":""},{"$f":"IF('Road 8'!$H$44=0,\"\",'Road 8'!$H$44)","v":""},{"$f":"IF('Road 8'!$H$45=0,\"\",'Road 8'!$H$45)","v":""},{"$f":"IF('Road 8'!$H$46=0,\"\",'Road 8'!$H$46)","v":""},{"$f":"IF('Road 8'!$H$50=0,\"\",'Road 8'!$H$50)","v":""},{"$f":"IF('Road 8'!$H$51=0,\"\",'Road 8'!$H$51)","v":""},{"$f":"IF('Road 8'!$H$52=0,\"\",'Road 8'!$H$52)","v":""},{"$f":"IF('Road 8'!$H$56=0,\"\",'Road 8'!$H$56)","v":""},{"$f":"IF('Road 8'!$H$57=0,\"\",'Road 8'!$H$57)","v":""},{"$f":"IF('Road 8'!$H$58=0,\"\",'Road 8'!$H$58)","v":""},{"$f":"IF('Road 9'!$Q$6=0,\"\",'Road 9'!$Q$6)","v":""},{"$f":"IF('Road 9'!$Q$7=0,\"\",'Road 9'!$Q$7)","v":""},{"$f":"IF('Road 9'!$Q$8=0,\"\",'Road 9'!$Q$8)","v":""},{"$f":"IF('Road 9'!$H$38=0,\"\",'Road 9'!$H$38)","v":""},{"$f":"IF('Road 9'!$H$39=0,\"\",'Road 9'!$H$39)","v":""},{"$f":"IF('Road 9'!$H$40=0,\"\",'Road 9'!$H$40)","v":""},{"$f":"IF('Road 9'!$H$44=0,\"\",'Road 9'!$H$44)","v":""},{"$f":"IF('Road 9'!$H$45=0,\"\",'Road 9'!$H$45)","v":""},{"$f":"IF('Road 9'!$H$46=0,\"\",'Road 9'!$H$46)","v":""},{"$f":"IF('Road 9'!$H$50=0,\"\",'Road 9'!$H$50)","v":""},{"$f":"IF('Road 9'!$H$51=0,\"\",'Road 9'!$H$51)","v":""},{"$f":"IF('Road 9'!$H$52=0,\"\",'Road 9'!$H$52)","v":""},{"$f":"IF('Road 9'!$H$56=0,\"\",'Road 9'!$H$56)","v":""},{"$f":"IF('Road 9'!$H$57=0,\"\",'Road 9'!$H$57)","v":""},{"$f":"IF('Road 9'!$H$58=0,\"\",'Road 9'!$H$58)","v":""},{"$f":"IF('Road 10'!$Q$6=0,\"\",'Road 10'!$Q$6)","v":""},{"$f":"IF('Road 10'!$Q$7=0,\"\",'Road 10'!$Q$7)","v":""},{"$f":"IF('Road 10'!$Q$8=0,\"\",'Road 10'!$Q$8)","v":""},{"$f":"IF('Road 10'!$H$38=0,\"\",'Road 10'!$H$38)","v":""},{"$f":"IF('Road 10'!$H$39=0,\"\",'Road 10'!$H$39)","v":""},{"$f":"IF('Road 10'!$H$40=0,\"\",'Road 10'!$H$40)","v":""},{"$f":"IF('Road 10'!$H$44=0,\"\",'Road 10'!$H$44)","v":""},{"$f":"IF('Road 10'!$H$45=0,\"\",'Road 10'!$H$45)","v":""},{"$f":"IF('Road 10'!$H$46=0,\"\",'Road 10'!$H$46)","v":""},{"$f":"IF('Road 10'!$H$50=0,\"\",'Road 10'!$H$50)","v":""},{"$f":"IF('Road 10'!$H$51=0,\"\",'Road 10'!$H$51)","v":""},{"$f":"IF('Road 10'!$H$52=0,\"\",'Road 10'!$H$52)","v":""},{"$f":"IF('Road 10'!$H$56=0,\"\",'Road 10'!$H$56)","v":""},{"$f":"IF('Road 10'!$H$57=0,\"\",'Road 10'!$H$57)","v":""},{"$f":"IF('Road 10'!$H$58=0,\"\",'Road 10'!$H$58)","v":""},{"$f":"CELL(\"filename\")","v":"U:\\Personal Documents\\[Passwords.xls]Document Password"}]

{"sheet":"DatabaseMoving","index":2,"n_rows":2,"n_cols":122,"rows_kept":2,"hidden":true}
["TTRORef","Road1Name","Road1USRN","Road1Ward","Road1M1","Road1M1Ext","Road1M2","Road1M2Ext","Road1M3","Road1M3Ext","Road1M4","Road1M4Ext","R1BaggedSigns","Road2Name","Road2USRN","Road2Ward","Road2M1","Road2M1Ext","Road2M2","Road2M2Ext","Road2M3","Road2M3Ext","Road2M4","Road2M4Ext","R2BaggedSigns","Road3Name","Road3USRN","Road3Ward","Road3M1","Road3M1Ext","Road3M2","Road3M2Ext","Road3M3","Road3M3Ext","Road3M4","Road3M4Ext","R3BaggedSigns","Road4Name","Road4USRN","Road4Ward","Road4M1","Road4M1Ext","Road4M2","Road4M2Ext","Road4M3","Road4M3Ext","Road4M4","Road4M4Ext","R4BaggedSigns","Road5Name","Road5USRN","Road5Ward","Road5M1","Road5M1Ext","Road5M2","Road5M2Ext","Road5M3","Road5M3Ext","Road5M4","Road5M4Ext","R5BaggedSigns","Road6Name","Road6USRN","Road6Ward","Road6M1","Road6M1Ext","Road6M2","Road6M2Ext","Road6M3","Road6M3Ext","Road6M4","Road6M4Ext","R6BaggedSigns","Road7Name","Road7USRN","Road7Ward","Road7M1","Road7M1Ext","Road7M2","Road7M2Ext","Road7M3","Road7M3Ext","Road7M4","Road7M4Ext","R7BaggedSigns","Road8Name","Road8USRN","Road8Ward","Road8M1","Road8M1Ext","Road8M2","Road8M2Ext","Road8M3","Road8M3Ext","Road8M4","Road8M4Ext","R8BaggedSigns","Road9Name","Road9USRN","Road9Ward","Road9M1","Road9M1Ext","Road9M2","Road9M2Ext","Road9M3","Road9M3Ext","Road9M4","Road9M4Ext","R9BaggedSigns","Road10Name","Road10USRN","Road10Ward","Road10M1","Road10M1Ext","Road10M2","Road10M2Ext","Road10M3","Road10M3Ext","Road10M4","Road10M4Ext","R10BaggedSigns","SourceFile"]
[null,{"$f":"IF('Road 1'!$Q$6=0,\"\",'Road 1'!$Q$6)","v":""},{"$f":"IF('Road 1'!$Q$7=0,\"\",'Road 1'!$Q$7)","v":""},{"$f":"IF('Road 1'!$Q$8=0,\"\",'Road 1'!$Q$8)","v":""},{"$f":"IF('Road 1'!$H$15=0,\"\",'Road 1'!$H$15)","v":""},{"$f":"IF('Road 1'!$H$16=0,\"\",'Road 1'!$H$16)","v":""},{"$f":"IF('Road 1'!$H$20=0,\"\",'Road 1'!$H$20)","v":""},{"$f":"IF('Road 1'!$H$21=0,\"\",'Road 1'!$H$21)","v":""},{"$f":"IF('Road 1'!$H$25=0,\"\",'Road 1'!$H$25)","v":""},{"$f":"IF('Road 1'!$H$26=0,\"\",'Road 1'!$H$26)","v":""},{"$f":"IF('Road 1'!$H$30=0,\"\",'Road 1'!$H$30)","v":""},{"$f":"IF('Road 1'!$H$31=0,\"\",'Road 1'!$H$31)","v":""},{"$f":"IF('Road 1'!$R$72=0,\"\",'Road 1'!$R$72)","v":""},{"$f":"IF('Road 2'!$Q$6=0,\"\",'Road 2'!$Q$6)","v":""},{"$f":"IF('Road 2'!$Q$7=0,\"\",'Road 2'!$Q$7)","v":""},{"$f":"IF('Road 2'!$Q$8=0,\"\",'Road 2'!$Q$8)","v":""},{"$f":"IF('Road 2'!$H$15=0,\"\",'Road 2'!$H$15)","v":""},{"$f":"IF('Road 2'!$H$16=0,\"\",'Road 2'!$H$16)","v":""},{"$f":"IF('Road 2'!$H$20=0,\"\",'Road 2'!$H$20)","v":""},{"$f":"IF('Road 2'!$H$21=0,\"\",'Road 2'!$H$21)","v":""},{"$f":"IF('Road 2'!$H$25=0,\"\",'Road 2'!$H$25)","v":""},{"$f":"IF('Road 2'!$H$26=0,\"\",'Road 2'!$H$26)","v":""},{"$f":"IF('Road 2'!$H$30=0,\"\",'Road 2'!$H$30)","v":""},{"$f":"IF('Road 2'!$H$31=0,\"\",'Road 2'!$H$31)","v":""},{"$f":"IF('Road 2'!$R$72=0,\"\",'Road 2'!$R$72)","v":""},{"$f":"IF('Road 3'!$Q$6=0,\"\",'Road 3'!$Q$6)","v":""},{"$f":"IF('Road 3'!$Q$7=0,\"\",'Road 3'!$Q$7)","v":""},{"$f":"IF('Road 3'!$Q$8=0,\"\",'Road 3'!$Q$8)","v":""},{"$f":"IF('Road 3'!$H$15=0,\"\",'Road 3'!$H$15)","v":""},{"$f":"IF('Road 3'!$H$16=0,\"\",'Road 3'!$H$16)","v":""},{"$f":"IF('Road 3'!$H$20=0,\"\",'Road 3'!$H$20)","v":""},{"$f":"IF('Road 3'!$H$21=0,\"\",'Road 3'!$H$21)","v":""},{"$f":"IF('Road 3'!$H$25=0,\"\",'Road 3'!$H$25)","v":""},{"$f":"IF('Road 3'!$H$26=0,\"\",'Road 3'!$H$26)","v":""},{"$f":"IF('Road 3'!$H$30=0,\"\",'Road 3'!$H$30)","v":""},{"$f":"IF('Road 3'!$H$31=0,\"\",'Road 3'!$H$31)","v":""},{"$f":"IF('Road 3'!$R$72=0,\"\",'Road 3'!$R$72)","v":""},{"$f":"IF('Road 4'!$Q$6=0,\"\",'Road 4'!$Q$6)","v":""},{"$f":"IF('Road 4'!$Q$7=0,\"\",'Road 4'!$Q$7)","v":""},{"$f":"IF('Road 4'!$Q$8=0,\"\",'Road 4'!$Q$8)","v":""},{"$f":"IF('Road 4'!$H$15=0,\"\",'Road 4'!$H$15)","v":""},{"$f":"IF('Road 4'!$H$16=0,\"\",'Road 4'!$H$16)","v":""},{"$f":"IF('Road 4'!$H$20=0,\"\",'Road 4'!$H$20)","v":""},{"$f":"IF('Road 4'!$H$21=0,\"\",'Road 4'!$H$21)","v":""},{"$f":"IF('Road 4'!$H$25=0,\"\",'Road 4'!$H$25)","v":""},{"$f":"IF('Road 4'!$H$26=0,\"\",'Road 4'!$H$26)","v":""},{"$f":"IF('Road 4'!$H$30=0,\"\",'Road 4'!$H$30)","v":""},{"$f":"IF('Road 4'!$H$31=0,\"\",'Road 4'!$H$31)","v":""},{"$f":"IF('Road 4'!$R$72=0,\"\",'Road 4'!$R$72)","v":""},{"$f":"IF('Road 5'!$Q$6=0,\"\",'Road 5'!$Q$6)","v":""},{"$f":"IF('Road 5'!$Q$7=0,\"\",'Road 5'!$Q$7)","v":""},{"$f":"IF('Road 5'!$Q$8=0,\"\",'Road 5'!$Q$8)","v":""},{"$f":"IF('Road 5'!$H$15=0,\"\",'Road 5'!$H$15)","v":""},{"$f":"IF('Road 5'!$H$16=0,\"\",'Road 5'!$H$16)","v":""},{"$f":"IF('Road 5'!$H$20=0,\"\",'Road 5'!$H$20)","v":""},{"$f":"IF('Road 5'!$H$21=0,\"\",'Road 5'!$H$21)","v":""},{"$f":"IF('Road 5'!$H$25=0,\"\",'Road 5'!$H$25)","v":""},{"$f":"IF('Road 5'!$H$26=0,\"\",'Road 5'!$H$26)","v":""},{"$f":"IF('Road 5'!$H$30=0,\"\",'Road 5'!$H$30)","v":""},{"$f":"IF('Road 5'!$H$31=0,\"\",'Road 5'!$H$31)","v":""},{"$f":"IF('Road 5'!$R$72=0,\"\",'Road 5'!$R$72)","v":""},{"$f":"IF('Road 6'!$Q$6=0,\"\",'Road 6'!$Q$6)","v":""},{"$f":"IF('Road 6'!$Q$7=0,\"\",'Road 6'!$Q$7)","v":""},{"$f":"IF('Road 6'!$Q$8=0,\"\",'Road 6'!$Q$8)","v":""},{"$f":"IF('Road 6'!$H$15=0,\"\",'Road 6'!$H$15)","v":""},{"$f":"IF('Road 6'!$H$16=0,\"\",'Road 6'!$H$16)","v":""},{"$f":"IF('Road 6'!$H$20=0,\"\",'Road 6'!$H$20)","v":""},{"$f":"IF('Road 6'!$H$21=0,\"\",'Road 6'!$H$21)","v":""},{"$f":"IF('Road 6'!$H$25=0,\"\",'Road 6'!$H$25)","v":""},{"$f":"IF('Road 6'!$H$26=0,\"\",'Road 6'!$H$26)","v":""},{"$f":"IF('Road 6'!$H$30=0,\"\",'Road 6'!$H$30)","v":""},{"$f":"IF('Road 6'!$H$31=0,\"\",'Road 6'!$H$31)","v":""},{"$f":"IF('Road 6'!$R$72=0,\"\",'Road 6'!$R$72)","v":""},{"$f":"IF('Road 7'!$Q$6=0,\"\",'Road 7'!$Q$6)","v":""},{"$f":"IF('Road 7'!$Q$7=0,\"\",'Road 7'!$Q$7)","v":""},{"$f":"IF('Road 7'!$Q$8=0,\"\",'Road 7'!$Q$8)","v":""},{"$f":"IF('Road 7'!$H$15=0,\"\",'Road 7'!$H$15)","v":""},{"$f":"IF('Road 7'!$H$16=0,\"\",'Road 7'!$H$16)","v":""},{"$f":"IF('Road 7'!$H$20=0,\"\",'Road 7'!$H$20)","v":""},{"$f":"IF('Road 7'!$H$21=0,\"\",'Road 7'!$H$21)","v":""},{"$f":"IF('Road 7'!$H$25=0,\"\",'Road 7'!$H$25)","v":""},{"$f":"IF('Road 7'!$H$26=0,\"\",'Road 7'!$H$26)","v":""},{"$f":"IF('Road 7'!$H$30=0,\"\",'Road 7'!$H$30)","v":""},{"$f":"IF('Road 7'!$H$31=0,\"\",'Road 7'!$H$31)","v":""},{"$f":"IF('Road 7'!$R$72=0,\"\",'Road 7'!$R$72)","v":""},{"$f":"IF('Road 8'!$Q$6=0,\"\",'Road 8'!$Q$6)","v":""},{"$f":"IF('Road 8'!$Q$7=0,\"\",'Road 8'!$Q$7)","v":""},{"$f":"IF('Road 8'!$Q$8=0,\"\",'Road 8'!$Q$8)","v":""},{"$f":"IF('Road 8'!$H$15=0,\"\",'Road 8'!$H$15)","v":""},{"$f":"IF('Road 8'!$H$16=0,\"\",'Road 8'!$H$16)","v":""},{"$f":"IF('Road 8'!$H$20=0,\"\",'Road 8'!$H$20)","v":""},{"$f":"IF('Road 8'!$H$21=0,\"\",'Road 8'!$H$21)","v":""},{"$f":"IF('Road 8'!$H$25=0,\"\",'Road 8'!$H$25)","v":""},{"$f":"IF('Road 8'!$H$26=0,\"\",'Road 8'!$H$26)","v":""},{"$f":"IF('Road 8'!$H$30=0,\"\",'Road 8'!$H$30)","v":""},{"$f":"IF('Road 8'!$H$31=0,\"\",'Road 8'!$H$31)","v":""},{"$f":"IF('Road 8'!$R$72=0,\"\",'Road 8'!$R$72)","v":""},{"$f":"IF('Road 9'!$Q$6=0,\"\",'Road 9'!$Q$6)","v":""},{"$f":"IF('Road 9'!$Q$7=0,\"\",'Road 9'!$Q$7)","v":""},{"$f":"IF('Road 9'!$Q$8=0,\"\",'Road 9'!$Q$8)","v":""},{"$f":"IF('Road 9'!$H$15=0,\"\",'Road 9'!$H$15)","v":""},{"$f":"IF('Road 9'!$H$16=0,\"\",'Road 9'!$H$16)","v":""},{"$f":"IF('Road 9'!$H$20=0,\"\",'Road 9'!$H$20)","v":""},{"$f":"IF('Road 9'!$H$21=0,\"\",'Road 9'!$H$21)","v":""},{"$f":"IF('Road 9'!$H$25=0,\"\",'Road 9'!$H$25)","v":""},{"$f":"IF('Road 9'!$H$26=0,\"\",'Road 9'!$H$26)","v":""},{"$f":"IF('Road 9'!$H$30=0,\"\",'Road 9'!$H$30)","v":""},{"$f":"IF('Road 9'!$H$31=0,\"\",'Road 9'!$H$31)","v":""},{"$f":"IF('Road 9'!$R$72=0,\"\",'Road 9'!$R$72)","v":""},{"$f":"IF('Road 10'!$Q$6=0,\"\",'Road 10'!$Q$6)","v":""},{"$f":"IF('Road 10'!$Q$7=0,\"\",'Road 10'!$Q$7)","v":""},{"$f":"IF('Road 10'!$Q$8=0,\"\",'Road 10'!$Q$8)","v":""},{"$f":"IF('Road 10'!$H$15=0,\"\",'Road 10'!$H$15)","v":""},{"$f":"IF('Road 10'!$H$16=0,\"\",'Road 10'!$H$16)","v":""},{"$f":"IF('Road 10'!$H$20=0,\"\",'Road 10'!$H$20)","v":""},{"$f":"IF('Road 10'!$H$21=0,\"\",'Road 10'!$H$21)","v":""},{"$f":"IF('Road 10'!$H$25=0,\"\",'Road 10'!$H$25)","v":""},{"$f":"IF('Road 10'!$H$26=0,\"\",'Road 10'!$H$26)","v":""},{"$f":"IF('Road 10'!$H$30=0,\"\",'Road 10'!$H$30)","v":""},{"$f":"IF('Road 10'!$H$31=0,\"\",'Road 10'!$H$31)","v":""},{"$f":"IF('Road 10'!$R$72=0,\"\",'Road 10'!$R$72)","v":""},{"$f":"CELL(\"filename\")","v":"U:\\Personal Documents\\[Passwords.xls]Document Password"}]

{"sheet":"DatabaseInfo","index":3,"n_rows":2,"n_cols":31,"rows_kept":2,"hidden":true}
["TTRORef","ApplicantName","Organisation","Address1","Address2","Address3","Postcode","TelNo","Email","PaymentRef","ProjRef","PermitRef","ReasonforTTRO","Diversion","Emergency","IfEmergencyInfo","InHoursContactName","InHoursContactNo","OutofHoursContactName","OutofHoursContactNo","StartDate","EndDate","SourceFile","InvOrganisation","InvAddress1","InvAddress2","InvAddress3","InvPostcode","InvTelNo","InvEmail","Cost"]
[null,{"$f":"+IF('Front Sheet'!I8=0,\"\",'Front Sheet'!I8)","v":""},{"$f":"+IF('Front Sheet'!I9=0,\"\",'Front Sheet'!I9)","v":""},{"$f":"+IF('Front Sheet'!I10=0,\"\",'Front Sheet'!I10)","v":""},{"$f":"+IF('Front Sheet'!I11=0,\"\",'Front Sheet'!I11)","v":""},{"$f":"+IF('Front Sheet'!I12=0,\"\",'Front Sheet'!I12)","v":""},{"$f":"+IF('Front Sheet'!I13=0,\"\",'Front Sheet'!I13)","v":""},{"$f":"+IF('Front Sheet'!I14=0,\"\",'Front Sheet'!I14)","v":""},{"$f":"+IF('Front Sheet'!I15=0,\"\",'Front Sheet'!I15)","v":""},{"$f":"+IF('Front Sheet'!I17=0,\"\",'Front Sheet'!I17)","v":""},{"$f":"IF('Front Sheet'!Q23=0,\"\",'Front Sheet'!Q23)","v":""},{"$f":"IF('Front Sheet'!Q25=0,\"\",'Front Sheet'!Q25)","v":""},{"$f":"IF('Front Sheet'!Q28=0,\"\",'Front Sheet'!Q28)","v":""},{"$f":"IF('Front Sheet'!K33=0,\"\",'Front Sheet'!K33)","v":""},null,{"$f":"IF('Front Sheet'!B40=0,\"\",'Front Sheet'!B40)","v":""},{"$f":"IF('Front Sheet'!M45=0,\"\",'Front Sheet'!M45)","v":""},{"$f":"IF('Front Sheet'!M46=0,\"\",'Front Sheet'!M46)","v":""},{"$f":"IF('Front Sheet'!M48=0,\"\",'Front Sheet'!M48)","v":""},{"$f":"IF('Front Sheet'!M49=0,\"\",'Front Sheet'!M49)","v":""},{"$f":"+'Front Sheet'!K55","v":"00:00:00"},{"$f":"+'Front Sheet'!K56","v":"00:00:00"},{"$f":"CELL(\"filename\")","v":"U:\\Personal Documents\\[Passwords.xls]Document Password"},{"$f":"IF('Front Sheet'!Z9=0,\"\",'Front Sheet'!Z9)","v":""},{"$f":"IF('Front Sheet'!Z10=0,\"\",'Front Sheet'!Z10)","v":""},{"$f":"IF('Front Sheet'!Z11=0,\"\",'Front Sheet'!Z11)","v":""},{"$f":"IF('Front Sheet'!Z12=0,\"\",'Front Sheet'!Z12)","v":""},{"$f":"IF('Front Sheet'!Z13=0,\"\",'Front Sheet'!Z13)","v":""},{"$f":"IF('Front Sheet'!Z14=0,\"\",'Front Sheet'!Z14)","v":""},{"$f":"IF('Front Sheet'!Z15=0,\"\",'Front Sheet'!Z15)","v":""},{"$f":"+'Cost Summary'!AG79","v":{"v":0,"d":"£0.00"}}]

{"sheet":"Schedule","index":4,"n_rows":15,"n_cols":18,"rows_kept":15,"hidden":true}
["Moving:",1,"- Please Select -",null,null,"Static:",1,"- Please Select -",{"$nulls":3},"Costs:","1st Prohibition on First Street",1344,null,"Board every:",40,"m"]
[null,2,"Road Closure","Road Closure",null,null,2,"No Stopping at Any Time","No Stopping at Any Time",{"$nulls":3},"For the First Prohibition or Other Item on Each Additional Street",174,null,"todays date:",{"$f":"+TODAY()","v":"2016-10-17"}]
[null,3,"Suspension of bus lane (used where traffic will use a bus lane during its period of operation)","Suspension of bus lane",null,null,3,"No Stopping -  8am to 5pm","No Stopping -  8am to 5pm",{"$nulls":3},"For Each Additional Prohibition",129,null,"prices valid to:","2017-01-10"]
[null,4,"No left turn","No left turn",null,null,4,"No Stopping -  Mon to Fri - 8am to 5pm","No Stopping -  Mon to Fri - 8am to 5pm",{"$nulls":3},"Advertising of Orders Where Required",1120]
[null,5,"Suspend existing no left turn","Suspend existing no left turn",null,null,5,"No Stopping -  Mon to Sat - 8am to 5pm","No Stopping -  Mon to Sat - 8am to 5pm",{"$nulls":3},"Cost Per Waiting Board",0,"need to revise!!"]
[null,6,"No right turn","No right turn",null,null,6,"No Stopping -  Mon to Fri - 7am to 4pm","No Stopping -  Mon to Fri - 7am to 4pm",{"$nulls":3},"Bagged Over Sign - Bond",0]
[null,7,"Suspend existing no right turn","Suspend existing no right turn"]
[null,8,"Mandatory left turn","Mandatory left turn"]
[null,9,"Suspend mandatory left turn","Suspend mandatory left turn"]
[null,10,"Mandatory right turn","Mandatory right turn"]
[null,11,"Suspend mandatory right turn","Suspend mandatory right turn"]
[null,12,"Implement one way provision","Implement one way provision"]
[null,13,"Suspend one way provision","Suspend one way provision"]
[null,14,"No Entry","No Entry"]
[null,15,"Other (Use \"Extent / Location\" box below to describe required restriction)","Other"]

{"sheet":"List of Restrictions","index":5,"n_rows":49,"n_cols":5,"rows_kept":49,"merged":[[0,1,2,26],[8,2,8,32],[9,2,9,32],[10,2,10,32],[11,2,11,32],[12,2,12,32],[13,2,13,32],[14,2,14,32],[15,2,15,32],[16,2,16,32],[17,2,17,32],[18,2,18,32],[19,2,19,32],[20,2,20,32],[21,2,21,32],[29,2,29,15],[30,2,30,15],[31,2,31,15],[32,2,32,15],[33,2,33,15],[41,1,41,3],[41,4,41,24],[42,1,42,3],[42,4,42,24],[43,1,43,3],[43,4,43,24],[44,1,44,3],[44,4,44,24],[45,1,45,3],[45,4,45,24],[46,1,46,3],[46,4,46,24],[48,1,48,24]]}
[null,"Temporary Traffic Regulation Order\nList of Standard Restrictions"]
[]
[]
[]
[]
[]
[null,"Moving Restrictions:"]
[]
[null,null,{"$f":"+Schedule!C2","v":"Road Closure"}]
[null,null,{"$f":"+Schedule!C3","v":"Suspension of bus lane (used where traffic will use a bus lane during its period of operation)"}]
[null,null,{"$f":"+Schedule!C4","v":"No left turn"}]
[null,null,{"$f":"+Schedule!C5","v":"Suspend existing no left turn"}]
[null,null,{"$f":"+Schedule!C6","v":"No right turn"}]
[null,null,{"$f":"+Schedule!C7","v":"Suspend existing no right turn"}]
[null,null,{"$f":"+Schedule!C8","v":"Mandatory left turn"}]
[null,null,{"$f":"+Schedule!C9","v":"Suspend mandatory left turn"}]
[null,null,{"$f":"+Schedule!C10","v":"Mandatory right turn"}]
[null,null,{"$f":"+Schedule!C11","v":"Suspend mandatory right turn"}]
[null,null,{"$f":"+Schedule!C12","v":"Implement one way provision"}]
[null,null,{"$f":"+Schedule!C13","v":"Suspend one way provision"}]
[null,null,{"$f":"+Schedule!C14","v":"No Entry"}]
[null,null,{"$f":"+Schedule!C15","v":"Other (Use \"Extent / Location\" box below to describe required restriction)"}]
[]
[]
[]
[]
[]
[null,"Static Restrictions:"]
[]
[null,null,{"$f":"+Schedule!I2","v":"No Stopping at Any Time"}]
[null,null,{"$f":"+Schedule!I3","v":"No Stopping -  8am to 5pm"}]
[null,null,{"$f":"+Schedule!I4","v":"No Stopping -  Mon to Fri - 8am to 5pm"}]
[null,null,{"$f":"+Schedule!I5","v":"No Stopping -  Mon to Sat - 8am to 5pm"}]
[null,null,{"$f":"+Schedule!I6","v":"No Stopping -  Mon to Fri - 7am to 4pm"}]
[]
[]
[]
[]
[]
[null,"Costs:"]
[]
[null,{"$f":"+Schedule!N1","v":{"v":1344,"d":"£1,344"}},null,null,{"$f":"\": \" &Schedule!M1","v":": 1st Prohibition on First Street"}]
[null,{"$f":"+Schedule!N2","v":{"v":174,"d":"£174"}},null,null,{"$f":"\": \" &Schedule!M2","v":": For the First Prohibition or Other Item on Each Additional Street"}]
[null,{"$f":"+Schedule!N3","v":{"v":129,"d":"£129"}},null,null,{"$f":"\": \" &Schedule!M3","v":": For Each Additional Prohibition"}]
[null,{"$f":"+Schedule!N4","v":{"v":1120,"d":"£1,120"}},null,null,{"$f":"\": \" &Schedule!M4","v":": Advertising of Orders Where Required"}]
[null,{"$f":"+Schedule!N5","v":{"v":0,"d":"£0"}},null,null,{"$f":"\": \" &Schedule!M5","v":": Cost Per Waiting Board"}]
[null,{"$f":"+Schedule!N6","v":{"v":0,"d":"£0"}},null,null,{"$f":"\": \" &Schedule!M6","v":": Bagged Over Sign - Bond"}]
[]
[null,{"$f":"+\"Costs valid until \" & TEXT(Schedule!Q3,\"dd mmmm yyyy\")","v":"Costs valid until 10 January 2017"}]

{"sheet":"Road 1","index":6,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I8:T8","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U8:W8","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU8","v":0},{"$f":"+'Restriction Costs'!AW8","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I9:T9","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U9:W9","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU9","v":0},{"$f":"+'Restriction Costs'!AW9","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I10:T10","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U10:W10","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU10","v":0},{"$f":"+'Restriction Costs'!AW10","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I11:T11","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U11:W11","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU11","v":0},{"$f":"+'Restriction Costs'!AW11","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I12:T12","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U12:W12","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y12","v":0},"no","x",{"$f":"+'Restriction Costs'!AB12:AC12","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU12","v":0},{"$f":"+'Restriction Costs'!AW12","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I13:T13","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U13:W13","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y13","v":0},"no","x",{"$f":"+'Restriction Costs'!AB13:AC13","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU13","v":0},{"$f":"+'Restriction Costs'!AW13","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I14:T14","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U14:W14","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y14","v":0},"no","x",{"$f":"+'Restriction Costs'!AB14:AC14","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU14","v":0},{"$f":"+'Restriction Costs'!AW14","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I15:T15","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U15:W15","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y15","v":0},"no","x",{"$f":"+'Restriction Costs'!AB15:AC15","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU15","v":0},{"$f":"+'Restriction Costs'!AW15","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 2","index":7,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I18:T18","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U18:W18","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU18","v":0},{"$f":"+'Restriction Costs'!AW18","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I19:T19","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U19:W19","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU19","v":0},{"$f":"+'Restriction Costs'!AW19","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I20:T20","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U20:W20","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU20","v":0},{"$f":"+'Restriction Costs'!AW20","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I21:T21","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U21:W21","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU21","v":0},{"$f":"+'Restriction Costs'!AW21","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I22:T22","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U22:W22","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y22","v":0},"no","x",{"$f":"+'Restriction Costs'!AB22:AC22","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU22","v":0},{"$f":"+'Restriction Costs'!AW22","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I23:T23","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U23:W23","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y23","v":0},"no","x",{"$f":"+'Restriction Costs'!AB23:AC23","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU23","v":0},{"$f":"+'Restriction Costs'!AW23","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I24:T24","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U24:W24","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y24","v":0},"no","x",{"$f":"+'Restriction Costs'!AB24:AC24","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU24","v":0},{"$f":"+'Restriction Costs'!AW24","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I25:T25","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U25:W25","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y25","v":0},"no","x",{"$f":"+'Restriction Costs'!AB25:AC25","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU25","v":0},{"$f":"+'Restriction Costs'!AW25","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 3","index":8,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I28:T28","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U28:W28","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU28","v":0},{"$f":"+'Restriction Costs'!AW28","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I29:T29","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U29:W29","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU29","v":0},{"$f":"+'Restriction Costs'!AW29","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I30:T30","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U30:W30","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU30","v":0},{"$f":"+'Restriction Costs'!AW30","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I31:T31","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U31:W31","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU31","v":0},{"$f":"+'Restriction Costs'!AW31","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I32:T32","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U32:W32","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y32","v":0},"no","x",{"$f":"+'Restriction Costs'!AB32:AC32","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU32","v":0},{"$f":"+'Restriction Costs'!AW32","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I33:T33","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U33:W33","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y33","v":0},"no","x",{"$f":"+'Restriction Costs'!AB33:AC33","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU33","v":0},{"$f":"+'Restriction Costs'!AW33","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I34:T34","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U34:W34","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y34","v":0},"no","x",{"$f":"+'Restriction Costs'!AB34:AC34","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU34","v":0},{"$f":"+'Restriction Costs'!AW34","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I35:T35","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U35:W35","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y35","v":0},"no","x",{"$f":"+'Restriction Costs'!AB35:AC35","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU35","v":0},{"$f":"+'Restriction Costs'!AW35","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 4","index":9,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I38:T38","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U38:W38","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU38","v":0},{"$f":"+'Restriction Costs'!AW38","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I39:T39","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U39:W39","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU39","v":0},{"$f":"+'Restriction Costs'!AW39","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I40:T40","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U40:W40","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU40","v":0},{"$f":"+'Restriction Costs'!AW40","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I41:T41","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U41:W41","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU41","v":0},{"$f":"+'Restriction Costs'!AW41","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I42:T42","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U42:W42","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y42","v":0},"no","x",{"$f":"+'Restriction Costs'!AB42:AC42","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU42","v":0},{"$f":"+'Restriction Costs'!AW42","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I43:T43","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U43:W43","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y43","v":0},"no","x",{"$f":"+'Restriction Costs'!AB43:AC43","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU43","v":0},{"$f":"+'Restriction Costs'!AW43","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I44:T44","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U44:W44","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y44","v":0},"no","x",{"$f":"+'Restriction Costs'!AB44:AC44","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU44","v":0},{"$f":"+'Restriction Costs'!AW44","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I45:T45","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U45:W45","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y45","v":0},"no","x",{"$f":"+'Restriction Costs'!AB45:AC45","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU45","v":0},{"$f":"+'Restriction Costs'!AW45","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 5","index":10,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I48:T48","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U48:W48","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU48","v":0},{"$f":"+'Restriction Costs'!AW48","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I49:T49","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U49:W49","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU49","v":0},{"$f":"+'Restriction Costs'!AW49","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I50:T50","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U50:W50","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU50","v":0},{"$f":"+'Restriction Costs'!AW50","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I51:T51","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U51:W51","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU51","v":0},{"$f":"+'Restriction Costs'!AW51","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I52:T52","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U52:W52","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y52","v":0},"no","x",{"$f":"+'Restriction Costs'!AB52:AC52","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU52","v":0},{"$f":"+'Restriction Costs'!AW52","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I53:T53","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U53:W53","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y53","v":0},"no","x",{"$f":"+'Restriction Costs'!AB53:AC53","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU53","v":0},{"$f":"+'Restriction Costs'!AW53","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I54:T54","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U54:W54","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y54","v":0},"no","x",{"$f":"+'Restriction Costs'!AB54:AC54","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU54","v":0},{"$f":"+'Restriction Costs'!AW54","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I55:T55","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U55:W55","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y55","v":0},"no","x",{"$f":"+'Restriction Costs'!AB55:AC55","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU55","v":0},{"$f":"+'Restriction Costs'!AW55","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 6","index":11,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I58:T58","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U58:W58","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU58","v":0},{"$f":"+'Restriction Costs'!AW58","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I59:T59","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U59:W59","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU59","v":0},{"$f":"+'Restriction Costs'!AW59","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I60:T60","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U60:W60","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU60","v":0},{"$f":"+'Restriction Costs'!AW60","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I61:T61","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U61:W61","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU61","v":0},{"$f":"+'Restriction Costs'!AW61","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I62:T62","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U62:W62","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y62","v":0},"no","x",{"$f":"+'Restriction Costs'!AB62:AC62","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU62","v":0},{"$f":"+'Restriction Costs'!AW62","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I63:T63","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U63:W63","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y63","v":0},"no","x",{"$f":"+'Restriction Costs'!AB63:AC63","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU63","v":0},{"$f":"+'Restriction Costs'!AW63","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I64:T64","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U64:W64","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y64","v":0},"no","x",{"$f":"+'Restriction Costs'!AB64:AC64","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU64","v":0},{"$f":"+'Restriction Costs'!AW64","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I65:T65","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U65:W65","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y65","v":0},"no","x",{"$f":"+'Restriction Costs'!AB65:AC65","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU65","v":0},{"$f":"+'Restriction Costs'!AW65","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 7","index":12,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I68:T68","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U68:W68","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU68","v":0},{"$f":"+'Restriction Costs'!AW68","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I69:T69","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U69:W69","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU69","v":0},{"$f":"+'Restriction Costs'!AW69","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I70:T70","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U70:W70","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU70","v":0},{"$f":"+'Restriction Costs'!AW70","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I71:T71","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U71:W71","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU71","v":0},{"$f":"+'Restriction Costs'!AW71","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I72:T72","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U72:W72","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y72","v":0},"no","x",{"$f":"+'Restriction Costs'!AB72:AC72","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU72","v":0},{"$f":"+'Restriction Costs'!AW72","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I73:T73","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U73:W73","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y73","v":0},"no","x",{"$f":"+'Restriction Costs'!AB73:AC73","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU73","v":0},{"$f":"+'Restriction Costs'!AW73","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I74:T74","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U74:W74","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y74","v":0},"no","x",{"$f":"+'Restriction Costs'!AB74:AC74","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU74","v":0},{"$f":"+'Restriction Costs'!AW74","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I75:T75","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U75:W75","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y75","v":0},"no","x",{"$f":"+'Restriction Costs'!AB75:AC75","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU75","v":0},{"$f":"+'Restriction Costs'!AW75","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 8","index":13,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I78:T78","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U78:W78","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU78","v":0},{"$f":"+'Restriction Costs'!AW78","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I79:T79","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U79:W79","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU79","v":0},{"$f":"+'Restriction Costs'!AW79","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I80:T80","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U80:W80","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU80","v":0},{"$f":"+'Restriction Costs'!AW80","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I81:T81","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U81:W81","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU81","v":0},{"$f":"+'Restriction Costs'!AW81","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I82:T82","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U82:W82","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y82","v":0},"no","x",{"$f":"+'Restriction Costs'!AB82:AC82","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU82","v":0},{"$f":"+'Restriction Costs'!AW82","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I83:T83","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U83:W83","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y83","v":0},"no","x",{"$f":"+'Restriction Costs'!AB83:AC83","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU83","v":0},{"$f":"+'Restriction Costs'!AW83","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I84:T84","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U84:W84","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y84","v":0},"no","x",{"$f":"+'Restriction Costs'!AB84:AC84","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU84","v":0},{"$f":"+'Restriction Costs'!AW84","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I85:T85","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U85:W85","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y85","v":0},"no","x",{"$f":"+'Restriction Costs'!AB85:AC85","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU85","v":0},{"$f":"+'Restriction Costs'!AW85","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 9","index":14,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I88:T88","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U88:W88","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU88","v":0},{"$f":"+'Restriction Costs'!AW88","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I89:T89","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U89:W89","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU89","v":0},{"$f":"+'Restriction Costs'!AW89","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I90:T90","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U90:W90","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU90","v":0},{"$f":"+'Restriction Costs'!AW90","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I91:T91","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U91:W91","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU91","v":0},{"$f":"+'Restriction Costs'!AW91","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I92:T92","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U92:W92","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y92","v":0},"no","x",{"$f":"+'Restriction Costs'!AB92:AC92","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU92","v":0},{"$f":"+'Restriction Costs'!AW92","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I93:T93","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U93:W93","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y93","v":0},"no","x",{"$f":"+'Restriction Costs'!AB93:AC93","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU93","v":0},{"$f":"+'Restriction Costs'!AW93","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I94:T94","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U94:W94","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y94","v":0},"no","x",{"$f":"+'Restriction Costs'!AB94:AC94","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU94","v":0},{"$f":"+'Restriction Costs'!AW94","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I95:T95","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U95:W95","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y95","v":0},"no","x",{"$f":"+'Restriction Costs'!AB95:AC95","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU95","v":0},{"$f":"+'Restriction Costs'!AW95","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"Road 10","index":15,"n_rows":77,"n_cols":48,"rows_kept":77,"merged":[[0,1,2,26],[5,1,5,15],[5,16,5,34],[6,1,6,15],[6,16,6,34],[7,1,7,15],[7,16,7,34],[14,1,14,6],[14,7,14,34],[15,1,15,6],[15,7,15,34],[19,1,19,6],[19,7,19,34],[20,1,20,6],[20,7,20,34],[24,1,24,6],[24,7,24,34],[25,1,25,6],[25,7,25,34],[29,1,29,6],[29,7,29,34],[30,1,30,6],[30,7,30,34],[37,1,37,6],[37,7,37,34],[38,1,38,6],[38,7,38,34],[39,7,39,10],[43,1,43,6],[43,7,43,34],[44,1,44,6],[44,7,44,34],[45,7,45,10],[49,1,49,6],[49,7,49,34],[50,1,50,6],[50,7,50,34],[51,7,51,10],[55,1,55,6],[55,7,55,34],[56,1,56,6],[56,7,56,34],[57,7,57,10],[57,44,60,47],[61,1,61,7],[61,8,61,19],[61,20,61,22],[62,1,62,7],[62,8,62,19],[62,20,62,22],[63,1,63,7],[63,8,63,19],[63,20,63,22],[64,1,64,7],[64,8,64,19],[64,20,64,22],[65,1,65,7],[65,8,65,19],[65,20,65,22],[65,27,65,28],[65,29,65,30],[66,1,66,7],[66,8,66,19],[66,20,66,22],[66,27,66,28],[66,29,66,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[67,27,67,28],[67,29,67,30],[68,1,68,7],[68,8,68,19],[68,20,68,22],[68,27,68,28],[68,29,68,30],[69,16,69,19],[69,20,69,22],[69,25,69,28],[69,29,69,30],[71,3,71,16],[71,17,71,18],[71,19,71,24],[71,26,71,27],[71,28,71,30],[71,31,71,34],[73,1,76,21],[73,24,73,27],[73,28,73,30],[74,24,74,27],[74,28,74,30],[75,24,75,27],[75,28,75,30],[76,23,76,27],[76,28,76,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[]
[]
[]
[]
[null,"Road Name (one road only):"]
[null,"Unique Street Reference Number (if nown):"]
[null,"Ward / District:"]
[]
[]
[null,"Moving Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS15,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS20,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS25,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS30,Schedule!B:D,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null,"Extent / Location:"]
[]
[]
[null,"Static Traffic Restrictions:"]
[]
[null,"Proposed Restriction 1:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS38,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 2:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS44,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 3:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS50,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)"]
[]
[null,"Proposed Restriction 4:"]
[]
[null,"Select restriction:",{"$nulls":5},{"$f":"+VLOOKUP(AS56,Schedule!G:I,3)","v":0},{"$nulls":35},"Selected Restriction:",1]
[null," Location:"]
[{"$nulls":6},"Extent:",{"$nulls":4},"total lineal meterage (for both sides of the road, use road length is x2)",{"$nulls":32},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I98:T98","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U98:W98","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU98","v":0},{"$f":"+'Restriction Costs'!AW98","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I99:T99","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U99:W99","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU99","v":0},{"$f":"+'Restriction Costs'!AW99","v":0}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I100:T100","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U100:W100","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"+'Restriction Costs'!AU100","v":0},{"$f":"+'Restriction Costs'!AW100","v":0}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I101:T101","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U101:W101","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},{"$f":"+'Restriction Costs'!AU101","v":0},{"$f":"+'Restriction Costs'!AW101","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"+'Restriction Costs'!I102:T102","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U102:W102","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y102","v":0},"no","x",{"$f":"+'Restriction Costs'!AB102:AC102","v":{"v":0,"d":"£0"}},null,{"$f":"+Y66*AB66","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU102","v":0},{"$f":"+'Restriction Costs'!AW102","v":0}]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"+'Restriction Costs'!I103:T103","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U103:W103","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y103","v":0},"no","x",{"$f":"+'Restriction Costs'!AB103:AC103","v":{"v":0,"d":"£0"}},null,{"$f":"+Y67*AB67","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"+'Restriction Costs'!AU103","v":0},{"$f":"+'Restriction Costs'!AW103","v":0}]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"+'Restriction Costs'!I104:T104","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U104:W104","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y104","v":0},"no","x",{"$f":"+'Restriction Costs'!AB104:AC104","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU104","v":0},{"$f":"+'Restriction Costs'!AW104","v":0}]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"+'Restriction Costs'!I105:T105","v":""},{"$nulls":11},{"$f":"+'Restriction Costs'!U105:W105","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+'Restriction Costs'!Y105","v":0},"no","x",{"$f":"+'Restriction Costs'!AB105:AC105","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},{"$f":"+'Restriction Costs'!AU105","v":0},{"$f":"+'Restriction Costs'!AW105","v":0}]
[{"$nulls":16},"Sub Total 1:",{"$nulls":3},{"$f":"+SUM(U62:W69)","v":{"v":0,"d":"£0"}},{"$nulls":4},"Sub Total 2:",{"$nulls":3},{"$f":"SUM(AD66:AD69)","v":{"v":0,"d":"£0"}},{"$nulls":15},{"$f":"SUM(AT62:AT69)","v":0},null,{"$f":"+IF(AT70>0,1,0)","v":0}]
[]
["Bond:",null,null,"No of signs that require bagging over / masking:",{"$nulls":15},"(leave blank if zero)",{"$nulls":5},"x",{"$f":"+Schedule!$N$6","v":{"v":0,"d":"£0"}},null,{"$f":"+R72*AA72","v":{"v":0,"d":"£0"}},null,null,"Sub Total 3:"]
[]
[null,{"$f":"+IF(Schedule!Q2>Schedule!Q3,\"Note:  The prices quoted on this application may not be the most up-to-date prices due to the age of the application form.  Please contact highway.management@nottinghamcity.gov.uk for a new application form\",\"\")","v":""},{"$nulls":22},"Sub Total 1:",{"$nulls":3},{"$f":"+U70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 2:",{"$nulls":3},{"$f":"+AD70","v":{"v":0,"d":"£0"}}]
[{"$nulls":24},"Sub Total 3:",{"$nulls":3},{"$f":"+AC72","v":{"v":0,"d":"£0"}}]
[{"$nulls":23},"TOTAL for Road 1:",{"$nulls":4},{"$f":"+SUM(AC74:AE76)","v":{"v":0,"d":"£0"}}]

{"sheet":"TTRO Summary","index":16,"n_rows":88,"n_cols":23,"rows_kept":88,"merged":[[0,1,2,26],[5,1,5,7],[7,1,7,7],[7,8,7,34],[8,1,8,7],[8,8,8,34],[9,1,9,7],[9,8,9,34],[10,1,10,7],[10,8,10,34],[11,1,11,7],[11,8,11,34],[12,1,12,7],[12,8,12,13],[13,1,13,7],[13,8,13,13],[14,1,14,7],[14,8,14,34],[18,1,18,34],[20,1,20,3],[20,4,20,34],[21,4,21,19],[21,22,21,34],[22,4,22,19],[22,22,22,34],[23,4,23,19],[23,22,23,34],[24,4,24,19],[24,22,24,34],[27,1,27,3],[28,4,28,19],[29,4,29,19],[29,22,29,34],[30,4,30,19],[30,22,30,34],[31,4,31,19],[31,22,31,34],[34,1,34,3],[35,4,35,19],[35,22,35,34],[36,4,36,19],[37,4,37,19],[38,4,38,19],[41,1,41,3],[42,4,42,19],[42,22,42,34],[43,4,43,19],[44,4,44,19],[45,4,45,19],[48,1,48,3],[49,4,49,19],[49,22,49,34],[50,4,50,19],[51,4,51,19],[52,4,52,19],[55,1,55,3],[56,4,56,19],[56,22,56,34],[57,4,57,19],[58,4,58,19],[59,4,59,19],[62,1,62,3],[63,4,63,19],[63,22,63,34],[64,4,64,19],[65,4,65,19],[66,4,66,19],[69,1,69,3],[70,4,70,19],[70,22,70,34],[71,4,71,19],[71,22,71,34],[72,4,72,19],[72,22,72,34],[73,4,73,19],[73,22,73,34],[76,1,76,3],[77,4,77,19],[77,22,77,34],[78,4,78,19],[78,22,78,34],[79,4,79,19],[79,22,79,34],[80,4,80,19],[80,22,80,34],[83,1,83,3],[84,4,84,19],[84,22,84,34],[85,4,85,19],[85,22,85,34],[86,4,86,19],[86,22,86,34],[87,4,87,19],[87,22,87,34]]}
[null,"Temporary Traffic Regulation Order\nApplication Form - Summary Sheet"]
[]
[]
[]
[]
[null,"Applicants Details:"]
[]
[null,"Applicant Name:",{"$nulls":6},{"$f":"IF('Front Sheet'!$I$8=\"\",\"\",+'Front Sheet'!$I$8)","v":""}]
[null,"Organisation:",{"$nulls":6},{"$f":"IF('Front Sheet'!$I$9=\"\",\"\",+'Front Sheet'!$I$9)","v":""}]
[null,"Address (line 1):",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$10=\"\",\"\",+'Front Sheet'!$I$10)","v":""}]
[null,"(line 2):",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$11=\"\",\"\",+'Front Sheet'!$I$11)","v":""}]
[null,"(line 3):",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$12=\"\",\"\",+'Front Sheet'!$I$12)","v":""}]
[null,"Postcode:",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$13=\"\",\"\",+'Front Sheet'!$I$13)","v":""}]
[null,"Telephone No:",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$14=\"\",\"\",+'Front Sheet'!$I$14)","v":""}]
[null,"Email:",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$15=\"\",\"\",+'Front Sheet'!$I$15)","v":""}]
[]
[]
[]
[null,"TTRO Summary:  Moving and Static Restrictions"]
[]
[null,"Road 1:",null,null,{"$f":"+'Road 1'!$Q$6","v":0}]
[{"$nulls":3},"M1:",{"$f":"+'Road 1'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 1'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 1'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 1'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 1'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 1'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 1'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 1'!$H$56","v":0}]
[]
[]
[null,"Road 2:",null,null,{"$f":"+'Road 2'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 2'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 2'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 2'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 2'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 2'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 2'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 2'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 2'!$H$56","v":0}]
[]
[]
[null,"Road 3:",null,null,{"$f":"+'Road 3'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 3'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 3'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 3'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 3'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 3'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 3'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 3'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 3'!$H$56","v":0}]
[]
[]
[null,"Road 4:",null,null,{"$f":"+'Road 4'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 4'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 4'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 4'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 4'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 4'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 4'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 4'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 4'!$H$56","v":0}]
[]
[]
[null,"Road 5:",null,null,{"$f":"+'Road 5'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 5'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 5'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 5'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 5'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 5'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 5'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 5'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 5'!$H$56","v":0}]
[]
[]
[null,"Road 6:",null,null,{"$f":"+'Road 6'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 6'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 6'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 6'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 6'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 6'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 6'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 6'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 6'!$H$56","v":0}]
[]
[]
[null,"Road 7:",null,null,{"$f":"+'Road 7'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 7'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 7'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 7'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 7'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 7'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 7'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 7'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 7'!$H$56","v":0}]
[]
[]
[null,"Road 8:",null,null,{"$f":"+'Road 8'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 8'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 8'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 8'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 8'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 8'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 8'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 8'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 8'!$H$56","v":0}]
[]
[]
[null,"Road 9:",null,null,{"$f":"+'Road 9'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 9'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 9'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 9'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 9'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 9'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 9'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 9'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 9'!$H$56","v":0}]
[]
[]
[null,"Road 10:",null,null,{"$f":"+'Road 10'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":3},"M1:",{"$f":"+'Road 10'!$H$15","v":0},{"$nulls":16},"S1:",{"$f":"+'Road 10'!$H$38","v":0}]
[{"$nulls":3},"M2:",{"$f":"+'Road 10'!$H$20","v":0},{"$nulls":16},"S2:",{"$f":"+'Road 10'!$H$44","v":0}]
[{"$nulls":3},"M3:",{"$f":"+'Road 10'!$H$25","v":0},{"$nulls":16},"S3:",{"$f":"+'Road 10'!$H$50","v":0}]
[{"$nulls":3},"M4:",{"$f":"+'Road 10'!$H$30","v":0},{"$nulls":16},"S4:",{"$f":"+'Road 10'!$H$56","v":0}]

{"sheet":"Cost Summary","index":17,"n_rows":90,"n_cols":46,"rows_kept":90,"merged":[[0,1,2,26],[5,1,5,7],[7,1,7,7],[7,8,7,34],[8,1,8,7],[8,8,8,34],[9,1,9,7],[9,8,9,34],[10,1,10,7],[10,8,10,34],[11,1,11,7],[11,8,11,34],[12,1,12,7],[12,8,12,13],[13,1,13,7],[13,8,13,13],[14,1,14,7],[14,8,14,34],[19,12,19,21],[19,25,19,34],[21,12,21,21],[21,25,21,34],[23,12,23,21],[23,25,23,34],[25,12,25,21],[25,25,25,34],[27,12,27,21],[27,25,27,34],[29,1,29,34],[33,1,33,8],[34,1,34,3],[34,4,34,34],[35,4,35,9],[35,10,35,12],[35,14,35,21],[35,22,35,24],[36,4,36,9],[36,10,36,12],[36,14,36,21],[36,22,36,24],[36,26,36,31],[36,32,36,34],[38,1,38,3],[38,4,38,34],[39,4,39,9],[39,10,39,12],[39,14,39,21],[39,22,39,24],[40,4,40,9],[40,10,40,12],[40,14,40,21],[40,22,40,24],[40,26,40,31],[40,32,40,34],[42,1,42,3],[42,4,42,34],[43,4,43,9],[43,10,43,12],[43,14,43,21],[43,22,43,24],[44,4,44,9],[44,10,44,12],[44,14,44,21],[44,22,44,24],[44,26,44,31],[44,32,44,34],[46,1,46,3],[46,4,46,34],[47,4,47,9],[47,10,47,12],[47,14,47,21],[47,22,47,24],[48,4,48,9],[48,10,48,12],[48,14,48,21],[48,22,48,24],[48,26,48,31],[48,32,48,34],[50,1,50,3],[50,4,50,34],[51,4,51,9],[51,10,51,12],[51,14,51,21],[51,22,51,24],[52,4,52,9],[52,10,52,12],[52,14,52,21],[52,22,52,24],[52,26,52,31],[52,32,52,34],[54,1,54,3],[54,4,54,34],[55,4,55,9],[55,10,55,12],[55,14,55,21],[55,22,55,24],[56,4,56,9],[56,10,56,12],[56,14,56,21],[56,22,56,24],[56,26,56,31],[56,32,56,34],[58,1,58,3],[58,4,58,34],[59,4,59,9],[59,10,59,12],[59,14,59,21],[59,22,59,24],[60,4,60,9],[60,10,60,12],[60,14,60,21],[60,22,60,24],[60,26,60,31],[60,32,60,34],[62,1,62,3],[62,4,62,34],[63,4,63,9],[63,10,63,12],[63,14,63,21],[63,22,63,24],[64,4,64,9],[64,10,64,12],[64,14,64,21],[64,22,64,24],[64,26,64,31],[64,32,64,34],[66,1,66,3],[66,4,66,34],[67,4,67,9],[67,10,67,12],[67,14,67,21],[67,22,67,24],[68,4,68,9],[68,10,68,12],[68,14,68,21],[68,22,68,24],[68,26,68,31],[68,32,68,34],[70,1,70,3],[70,4,70,34],[71,4,71,9],[71,10,71,12],[71,14,71,21],[71,22,71,24],[72,4,72,9],[72,10,72,12],[72,14,72,21],[72,22,72,24],[72,26,72,31],[72,32,72,34],[73,10,73,12],[73,22,73,24],[73,32,73,34],[75,32,75,34],[78,32,78,34],[84,1,85,6],[84,7,85,14],[84,18,84,20],[87,2,87,6],[87,7,87,20],[89,7,89,8],[89,17,89,20]]}
[null,"Temporary Traffic Regulation Order\nApplication Form - Summary Sheet"]
[]
[]
[]
[]
[null,"Applicants Details:"]
[]
[null,"Applicant Name:",{"$nulls":6},{"$f":"IF('Front Sheet'!$I$8=\"\",\"\",+'Front Sheet'!$I$8)","v":""}]
[null,"Organisation:",{"$nulls":6},{"$f":"IF('Front Sheet'!$I$9=\"\",\"\",+'Front Sheet'!$I$9)","v":""}]
[null,"Address (line 1):",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$10=\"\",\"\",+'Front Sheet'!$I$10)","v":""}]
[null,"(line 2):",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$11=\"\",\"\",+'Front Sheet'!$I$11)","v":""}]
[null,"(line 3):",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$12=\"\",\"\",+'Front Sheet'!$I$12)","v":""}]
[null,"Postcode:",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$13=\"\",\"\",+'Front Sheet'!$I$13)","v":""}]
[null,"Telephone No:",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$14=\"\",\"\",+'Front Sheet'!$I$14)","v":""}]
[null,"Email:",{"$nulls":6},{"$f":"IF(+'Front Sheet'!$I$15=\"\",\"\",+'Front Sheet'!$I$15)","v":""}]
[]
[]
[{"$nulls":44},"P&D Road 1:",false]
[null,"Pay & Display Bays",{"$nulls":42},"P&D Road 2:",false]
[null,"Are any Pay & Displays affected?",{"$nulls":10},{"$f":"+IF('Road 1'!$Q$6=\"\",\"Road 1\",'Road 1'!$Q$6)","v":"Road 1"},{"$nulls":12},{"$f":"+IF('Road 2'!$Q$6=\"\",\"Road 2\",'Road 2'!$Q$6)","v":"Road 2"},{"$nulls":18},"P&D Road 3:",false]
[{"$nulls":44},"P&D Road 4:",false]
[{"$nulls":12},{"$f":"+IF('Road 3'!$Q$6=\"\",\"Road 3\",'Road 3'!$Q$6)","v":"Road 3"},{"$nulls":12},{"$f":"+IF('Road 4'!$Q$6=\"\",\"Road 4\",'Road 4'!$Q$6)","v":"Road 4"},{"$nulls":18},"P&D Road 5:",false]
[{"$nulls":44},"P&D Road 6:",false]
[{"$nulls":12},{"$f":"+IF('Road 5'!$Q$6=\"\",\"Road 5\",'Road 5'!$Q$6)","v":"Road 5"},{"$nulls":12},{"$f":"+IF('Road 6'!$Q$6=\"\",\"Road 6\",'Road 6'!$Q$6)","v":"Road 6"},{"$nulls":18},"P&D Road 7:",false]
[{"$nulls":44},"P&D Road 8:",false]
[{"$nulls":12},{"$f":"+IF('Road 7'!$Q$6=\"\",\"Road 7\",'Road 7'!$Q$6)","v":"Road 7"},{"$nulls":12},{"$f":"+IF('Road 8'!$Q$6=\"\",\"Road 8\",'Road 8'!$Q$6)","v":"Road 8"},{"$nulls":18},"P&D Road 9:",false]
[{"$nulls":44},"P&D Road 10:",false]
[{"$nulls":12},{"$f":"+IF('Road 9'!$Q$6=\"\",\"Road 9\",'Road 9'!$Q$6)","v":"Road 9"},{"$nulls":12},{"$f":"+IF('Road 10'!$Q$6=\"\",\"Road 10\",'Road 10'!$Q$6)","v":"Road 10"},{"$nulls":19},{"$f":"+COUNTIF(AT18:AT27,TRUE)","v":0}]
[]
[null,{"$f":"+IF(AT28>0,\"Contact Parking Services to Notify of temporary loss of parking bay - email: parking@nottinghamcity.gov.uk\",\"\")","v":""}]
[]
[]
[]
[null,"Cost Summary"]
[null,"Road 1:",null,null,{"$f":"+'Road 1'!$Q$6","v":0}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"+'Restriction Costs'!BG8","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG10","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"+'Restriction Costs'!BG9","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG11","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 1 Sub-total:",{"$nulls":5},{"$f":"+K36+K37+W36+W37","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 2:",null,null,{"$f":"+'Road 2'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"+'Restriction Costs'!BG18","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG20","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"+'Restriction Costs'!BG19","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG21","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 2 Sub-total:",{"$nulls":5},{"$f":"+K40+K41+W40+W41","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 3:",null,null,{"$f":"+'Road 3'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"+'Restriction Costs'!BG28","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG30","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"+'Restriction Costs'!BG29","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG31","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 3 Sub-total:",{"$nulls":5},{"$f":"+K44+K45+W44+W45","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 4:",null,null,{"$f":"+'Road 4'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG38","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG40","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG39","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG41","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 4 Sub-total:",{"$nulls":5},{"$f":"+K48+K49+W48+W49","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 5:",null,null,{"$f":"+'Road 5'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG48","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG50","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG49","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG51","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 5 Sub-total:",{"$nulls":5},{"$f":"+K52+K53+W52+W53","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 6:",null,null,{"$f":"+'Road 6'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG58","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG60","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG59","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG61","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 6 Sub-total:",{"$nulls":5},{"$f":"+K56+K57+W56+W57","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 7:",null,null,{"$f":"+'Road 7'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG68","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG70","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG69","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG71","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 7 Sub-total:",{"$nulls":5},{"$f":"+K60+K61+W60+W61","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 8:",null,null,{"$f":"+'Road 8'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG78","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG80","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG79","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG81","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 8 Sub-total:",{"$nulls":5},{"$f":"+K64+K65+W64+W65","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 9:",null,null,{"$f":"+'Road 9'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG88","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG90","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG89","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG91","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 9 Sub-total:",{"$nulls":5},{"$f":"+K68+K69+W68+W69","v":{"v":0,"d":"£0"}}]
[]
[null,"Road 10:",null,null,{"$f":"+'Road 10'!$Q$6","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Moving Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG98","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting board costs:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG100","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},"Static Restriction:",{"$nulls":5},{"$f":"'Restriction Costs'!BG99","v":{"v":0,"d":"£0"}},{"$nulls":3},"Bagging / masking bond:",{"$nulls":7},{"$f":"+'Restriction Costs'!BG101","v":{"v":0,"d":"£0"}},{"$nulls":3},"Road 10 Sub-total:",{"$nulls":5},{"$f":"+K72+K73+W72+W73","v":{"v":0,"d":"£0"}}]
[{"$nulls":9},"Order Cost:",{"$f":"+SUM(K36:M73)","v":{"v":0,"d":"£0"}},{"$nulls":10},"Implementation Cost:",{"$f":"+SUM(W36:Y73)","v":{"v":0,"d":"£0"}},{"$nulls":8},"Total:",{"$f":"+SUM(AG36:AI73)","v":{"v":0,"d":"£0"}}]
[]
[{"$nulls":31},"Advertising Costs:",{"$f":"IF(AND('Front Sheet'!K55<>\"\",'Front Sheet'!K56<>\"\"),IF('Front Sheet'!U55>5,Schedule!N4,0),0)","v":{"v":0,"d":"£0"}}]
[]
[]
[{"$nulls":31},"Grand Total:",{"$f":"+AG74+AG76","v":{"v":0,"d":"£0"}}]
[]
[]
[]
[null,"For NCC Use Only:"]
[]
[null,"Officer deailing with application:",{"$nulls":15},"Tel ext:"]
[]
[]
[null,null,"Payment Ref:"]
[]
[{"$nulls":6},"Application Approved:",{"$nulls":9},"Date:"]

{"sheet":"Restriction Costs","index":18,"n_rows":107,"n_cols":64,"rows_kept":107,"hidden":true,"merged":[[0,1,2,26],[1,44,4,49],[7,1,7,7],[7,8,7,19],[7,20,7,22],[8,1,8,7],[8,8,8,19],[8,20,8,22],[9,1,9,7],[9,8,9,19],[9,20,9,22],[10,1,10,7],[10,8,10,19],[10,20,10,22],[11,1,11,7],[11,8,11,19],[11,20,11,22],[11,27,11,28],[11,29,11,30],[12,1,12,7],[12,8,12,19],[12,20,12,22],[12,27,12,28],[12,29,12,30],[13,1,13,7],[13,8,13,19],[13,20,13,22],[13,27,13,28],[13,29,13,30],[14,1,14,7],[14,8,14,19],[14,20,14,22],[14,27,14,28],[14,29,14,30],[17,1,17,7],[17,8,17,19],[17,20,17,22],[18,1,18,7],[18,8,18,19],[18,20,18,22],[19,1,19,7],[19,8,19,19],[19,20,19,22],[20,1,20,7],[20,8,20,19],[20,20,20,22],[21,1,21,7],[21,8,21,19],[21,20,21,22],[21,27,21,28],[21,29,21,30],[22,1,22,7],[22,8,22,19],[22,20,22,22],[22,27,22,28],[22,29,22,30],[23,1,23,7],[23,8,23,19],[23,20,23,22],[23,27,23,28],[23,29,23,30],[24,1,24,7],[24,8,24,19],[24,20,24,22],[24,27,24,28],[24,29,24,30],[27,1,27,7],[27,8,27,19],[27,20,27,22],[28,1,28,7],[28,8,28,19],[28,20,28,22],[29,1,29,7],[29,8,29,19],[29,20,29,22],[30,1,30,7],[30,8,30,19],[30,20,30,22],[31,1,31,7],[31,8,31,19],[31,20,31,22],[31,27,31,28],[31,29,31,30],[32,1,32,7],[32,8,32,19],[32,20,32,22],[32,27,32,28],[32,29,32,30],[33,1,33,7],[33,8,33,19],[33,20,33,22],[33,27,33,28],[33,29,33,30],[34,1,34,7],[34,8,34,19],[34,20,34,22],[34,27,34,28],[34,29,34,30],[37,1,37,7],[37,8,37,19],[37,20,37,22],[38,1,38,7],[38,8,38,19],[38,20,38,22],[39,1,39,7],[39,8,39,19],[39,20,39,22],[40,1,40,7],[40,8,40,19],[40,20,40,22],[41,1,41,7],[41,8,41,19],[41,20,41,22],[41,27,41,28],[41,29,41,30],[42,1,42,7],[42,8,42,19],[42,20,42,22],[42,27,42,28],[42,29,42,30],[43,1,43,7],[43,8,43,19],[43,20,43,22],[43,27,43,28],[43,29,43,30],[44,1,44,7],[44,8,44,19],[44,20,44,22],[44,27,44,28],[44,29,44,30],[47,1,47,7],[47,8,47,19],[47,20,47,22],[48,1,48,7],[48,8,48,19],[48,20,48,22],[49,1,49,7],[49,8,49,19],[49,20,49,22],[50,1,50,7],[50,8,50,19],[50,20,50,22],[51,1,51,7],[51,8,51,19],[51,20,51,22],[51,27,51,28],[51,29,51,30],[52,1,52,7],[52,8,52,19],[52,20,52,22],[52,27,52,28],[52,29,52,30],[53,1,53,7],[53,8,53,19],[53,20,53,22],[53,27,53,28],[53,29,53,30],[54,1,54,7],[54,8,54,19],[54,20,54,22],[54,27,54,28],[54,29,54,30],[57,1,57,7],[57,8,57,19],[57,20,57,22],[58,1,58,7],[58,8,58,19],[58,20,58,22],[59,1,59,7],[59,8,59,19],[59,20,59,22],[60,1,60,7],[60,8,60,19],[60,20,60,22],[61,1,61,7],[61,8,61,19],[61,20,61,22],[61,27,61,28],[61,29,61,30],[62,1,62,7],[62,8,62,19],[62,20,62,22],[62,27,62,28],[62,29,62,30],[63,1,63,7],[63,8,63,19],[63,20,63,22],[63,27,63,28],[63,29,63,30],[64,1,64,7],[64,8,64,19],[64,20,64,22],[64,27,64,28],[64,29,64,30],[67,1,67,7],[67,8,67,19],[67,20,67,22],[68,1,68,7],[68,8,68,19],[68,20,68,22],[69,1,69,7],[69,8,69,19],[69,20,69,22],[70,1,70,7],[70,8,70,19],[70,20,70,22],[71,1,71,7],[71,8,71,19],[71,20,71,22],[71,27,71,28],[71,29,71,30],[72,1,72,7],[72,8,72,19],[72,20,72,22],[72,27,72,28],[72,29,72,30],[73,1,73,7],[73,8,73,19],[73,20,73,22],[73,27,73,28],[73,29,73,30],[74,1,74,7],[74,8,74,19],[74,20,74,22],[74,27,74,28],[74,29,74,30],[77,1,77,7],[77,8,77,19],[77,20,77,22],[78,1,78,7],[78,8,78,19],[78,20,78,22],[79,1,79,7],[79,8,79,19],[79,20,79,22],[80,1,80,7],[80,8,80,19],[80,20,80,22],[81,1,81,7],[81,8,81,19],[81,20,81,22],[81,27,81,28],[81,29,81,30],[82,1,82,7],[82,8,82,19],[82,20,82,22],[82,27,82,28],[82,29,82,30],[83,1,83,7],[83,8,83,19],[83,20,83,22],[83,27,83,28],[83,29,83,30],[84,1,84,7],[84,8,84,19],[84,20,84,22],[84,27,84,28],[84,29,84,30],[87,1,87,7],[87,8,87,19],[87,20,87,22],[88,1,88,7],[88,8,88,19],[88,20,88,22],[89,1,89,7],[89,8,89,19],[89,20,89,22],[90,1,90,7],[90,8,90,19],[90,20,90,22],[91,1,91,7],[91,8,91,19],[91,20,91,22],[91,27,91,28],[91,29,91,30],[92,1,92,7],[92,8,92,19],[92,20,92,22],[92,27,92,28],[92,29,92,30],[93,1,93,7],[93,8,93,19],[93,20,93,22],[93,27,93,28],[93,29,93,30],[94,1,94,7],[94,8,94,19],[94,20,94,22],[94,27,94,28],[94,29,94,30],[97,1,97,7],[97,8,97,19],[97,20,97,22],[98,1,98,7],[98,8,98,19],[98,20,98,22],[99,1,99,7],[99,8,99,19],[99,20,99,22],[100,1,100,7],[100,8,100,19],[100,20,100,22],[101,1,101,7],[101,8,101,19],[101,20,101,22],[101,27,101,28],[101,29,101,30],[102,1,102,7],[102,8,102,19],[102,20,102,22],[102,27,102,28],[102,29,102,30],[103,1,103,7],[103,8,103,19],[103,20,103,22],[103,27,103,28],[103,29,103,30],[104,1,104,7],[104,8,104,19],[104,20,104,22],[104,27,104,28],[104,29,104,30]]}
[null,"Temporary Traffic Regulation Order\nApplication Form"]
[{"$nulls":44},"Used to determine 1st & second restriction"]
[]
[]
[null,"Costs:"]
[{"$nulls":45},"street","restriction no","restriction this street","restriction no total",{"$nulls":14},"street no"]
[null,null,"Road 1",{"$nulls":54},{"$f":"+C7","v":"Road 1"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$15=1,\"\",+VLOOKUP('Road 1'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT8=1,AV8=1),Schedule!$N$1,IF(AND(AT8=1,AV8>1),Schedule!$N$3,IF(AND(AT8>1,AV8=1),Schedule!$N$2,IF(AND(AT8>1,AV8>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU8=0,0,$BL$8)","v":0},{"$f":"+IF(I8=\"\",0,1)","v":0},{"$f":"+AU8","v":0},{"$f":"+AU8","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U8:W11)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU8:AU15)>0,1,0)","v":0},{"$f":"IF(BK8=0,0,BK8)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$20=1,\"\",+VLOOKUP('Road 1'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT9=1,AV9=1),Schedule!$N$1,IF(AND(AT9=1,AV9>1),Schedule!$N$3,IF(AND(AT9>1,AV9=1),Schedule!$N$2,IF(AND(AT9>1,AV9>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU8+AU9","v":0},{"$f":"+AW8+AU9","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U12:W15)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$25=1,\"\",+VLOOKUP('Road 1'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT10=1,AV10=1),Schedule!$N$1,IF(AND(AT10=1,AV10>1),Schedule!$N$3,IF(AND(AT10>1,AV10=1),Schedule!$N$2,IF(AND(AT10>1,AV10>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU10+AU8+AU9","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD12:AE15)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$30=1,\"\",+VLOOKUP('Road 1'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT11=1,AV11=1),Schedule!$N$1,IF(AND(AT11=1,AV11>1),Schedule!$N$3,IF(AND(AT11>1,AV11=1),Schedule!$N$2,IF(AND(AT11>1,AV11>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU8+AU9+AU10+AU11","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 1'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$38=1,\"\",+VLOOKUP('Road 1'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT12=1,AV12=1),Schedule!$N$1,IF(AND(AT12=1,AV12>1),Schedule!$N$3,IF(AND(AT12>1,AV12=1),Schedule!$N$2,IF(AND(AT12>1,AV12>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 1'!$H$40=0,0,ROUND('Road 1'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y12*AB12","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU8+AU9+AU10+AU11+AU12","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$44=1,\"\",+VLOOKUP('Road 1'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT13=1,AV13=1),Schedule!$N$1,IF(AND(AT13=1,AV13>1),Schedule!$N$3,IF(AND(AT13>1,AV13=1),Schedule!$N$2,IF(AND(AT13>1,AV13>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 1'!$H$46=0,0,ROUND('Road 1'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y13*AB13","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU8+AU9+AU10+AU11+AU12+AU13","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$50=1,\"\",+VLOOKUP('Road 1'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT14=1,AV14=1),Schedule!$N$1,IF(AND(AT14=1,AV14>1),Schedule!$N$3,IF(AND(AT14>1,AV14=1),Schedule!$N$2,IF(AND(AT14>1,AV14>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 1'!$H$52=0,0,ROUND('Road 1'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU8+AU9+AU10+AU11+AU12+AU13+AU14","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 1'!$AS$56=1,\"\",+VLOOKUP('Road 1'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT15=1,AV15=1),Schedule!$N$1,IF(AND(AT15=1,AV15>1),Schedule!$N$3,IF(AND(AT15>1,AV15=1),Schedule!$N$2,IF(AND(AT15>1,AV15>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 1'!$H$58=0,0,ROUND('Road 1'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU8+AU9+AU10+AU11+AU12+AU13+AU14+AU15","v":0},0]
[]
[null,null,"Road 2",{"$nulls":54},{"$f":"+C17","v":"Road 2"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$15=1,\"\",+VLOOKUP('Road 2'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT18=1,AV18=1),Schedule!$N$1,IF(AND(AT18=1,AV18>1),Schedule!$N$3,IF(AND(AT18>1,AV18=1),Schedule!$N$2,IF(AND(AT18>1,AV18>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU18=0,0,$BL$18)","v":0},{"$f":"+IF(I18=\"\",0,1)","v":0},{"$f":"+AU18","v":0},{"$f":"+AW15+AU18","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U18:W21)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU18:AU25)>0,1,0)","v":0},{"$f":"IF(BK18=0,0,BK8+BK18)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$20=1,\"\",+VLOOKUP('Road 2'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT19=1,AV19=1),Schedule!$N$1,IF(AND(AT19=1,AV19>1),Schedule!$N$3,IF(AND(AT19>1,AV19=1),Schedule!$N$2,IF(AND(AT19>1,AV19>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU18+AU19","v":0},{"$f":"+AW18+AU19","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U22:W25)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$25=1,\"\",+VLOOKUP('Road 2'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT20=1,AV20=1),Schedule!$N$1,IF(AND(AT20=1,AV20>1),Schedule!$N$3,IF(AND(AT20>1,AV20=1),Schedule!$N$2,IF(AND(AT20>1,AV20>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU20+AU18+AU19","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD22:AE25)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$30=1,\"\",+VLOOKUP('Road 2'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT21=1,AV21=1),Schedule!$N$1,IF(AND(AT21=1,AV21>1),Schedule!$N$3,IF(AND(AT21>1,AV21=1),Schedule!$N$2,IF(AND(AT21>1,AV21>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU18+AU19+AU20+AU21","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 2'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$38=1,\"\",+VLOOKUP('Road 2'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT22=1,AV22=1),Schedule!$N$1,IF(AND(AT22=1,AV22>1),Schedule!$N$3,IF(AND(AT22>1,AV22=1),Schedule!$N$2,IF(AND(AT22>1,AV22>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 2'!$H$40=0,0,ROUND('Road 2'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y22*AB22","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU18+AU19+AU20+AU21+AU22","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$44=1,\"\",+VLOOKUP('Road 2'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT23=1,AV23=1),Schedule!$N$1,IF(AND(AT23=1,AV23>1),Schedule!$N$3,IF(AND(AT23>1,AV23=1),Schedule!$N$2,IF(AND(AT23>1,AV23>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 2'!$H$46=0,0,ROUND('Road 2'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y23*AB23","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU18+AU19+AU20+AU21+AU22+AU23","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$50=1,\"\",+VLOOKUP('Road 2'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT24=1,AV24=1),Schedule!$N$1,IF(AND(AT24=1,AV24>1),Schedule!$N$3,IF(AND(AT24>1,AV24=1),Schedule!$N$2,IF(AND(AT24>1,AV24>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 2'!$H$52=0,0,ROUND('Road 2'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU18+AU19+AU20+AU21+AU22+AU23+AU24","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 2'!$AS$56=1,\"\",+VLOOKUP('Road 2'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT25=1,AV25=1),Schedule!$N$1,IF(AND(AT25=1,AV25>1),Schedule!$N$3,IF(AND(AT25>1,AV25=1),Schedule!$N$2,IF(AND(AT25>1,AV25>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 2'!$H$58=0,0,ROUND('Road 2'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU18+AU19+AU20+AU21+AU22+AU23+AU24+AU25","v":0},0]
[]
[null,null,"Road 3",{"$nulls":54},{"$f":"+C27","v":"Road 3"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$15=1,\"\",+VLOOKUP('Road 3'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT28=1,AV28=1),Schedule!$N$1,IF(AND(AT28=1,AV28>1),Schedule!$N$3,IF(AND(AT28>1,AV28=1),Schedule!$N$2,IF(AND(AT28>1,AV28>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU28=0,0,$BL$28)","v":0},{"$f":"+IF(I28=\"\",0,1)","v":0},{"$f":"+AU28","v":0},{"$f":"+AW25+AU28","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U28:W31)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU28:AU35)>0,1,0)","v":0},{"$f":"IF(BK28=0,0,BK8+BK18+BK28)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$20=1,\"\",+VLOOKUP('Road 3'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT29=1,AV29=1),Schedule!$N$1,IF(AND(AT29=1,AV29>1),Schedule!$N$3,IF(AND(AT29>1,AV29=1),Schedule!$N$2,IF(AND(AT29>1,AV29>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU28+AU29","v":0},{"$f":"+AW28+AU29","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U32:W35)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$25=1,\"\",+VLOOKUP('Road 3'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT30=1,AV30=1),Schedule!$N$1,IF(AND(AT30=1,AV30>1),Schedule!$N$3,IF(AND(AT30>1,AV30=1),Schedule!$N$2,IF(AND(AT30>1,AV30>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU30+AU28+AU29","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD32:AE35)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$30=1,\"\",+VLOOKUP('Road 3'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT31=1,AV31=1),Schedule!$N$1,IF(AND(AT31=1,AV31>1),Schedule!$N$3,IF(AND(AT31>1,AV31=1),Schedule!$N$2,IF(AND(AT31>1,AV31>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU28+AU29+AU30+AU31","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 3'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$38=1,\"\",+VLOOKUP('Road 3'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT32=1,AV32=1),Schedule!$N$1,IF(AND(AT32=1,AV32>1),Schedule!$N$3,IF(AND(AT32>1,AV32=1),Schedule!$N$2,IF(AND(AT32>1,AV32>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 3'!$H$40=0,0,ROUND('Road 3'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y32*AB32","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU28+AU29+AU30+AU31+AU32","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$44=1,\"\",+VLOOKUP('Road 3'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT33=1,AV33=1),Schedule!$N$1,IF(AND(AT33=1,AV33>1),Schedule!$N$3,IF(AND(AT33>1,AV33=1),Schedule!$N$2,IF(AND(AT33>1,AV33>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 3'!$H$46=0,0,ROUND('Road 3'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y33*AB33","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU28+AU29+AU30+AU31+AU32+AU33","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$50=1,\"\",+VLOOKUP('Road 3'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT34=1,AV34=1),Schedule!$N$1,IF(AND(AT34=1,AV34>1),Schedule!$N$3,IF(AND(AT34>1,AV34=1),Schedule!$N$2,IF(AND(AT34>1,AV34>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 3'!$H$52=0,0,ROUND('Road 3'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU28+AU29+AU30+AU31+AU32+AU33+AU34","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 3'!$AS$56=1,\"\",+VLOOKUP('Road 3'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT35=1,AV35=1),Schedule!$N$1,IF(AND(AT35=1,AV35>1),Schedule!$N$3,IF(AND(AT35>1,AV35=1),Schedule!$N$2,IF(AND(AT35>1,AV35>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 3'!$H$58=0,0,ROUND('Road 3'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU28+AU29+AU30+AU31+AU32+AU33+AU34+AU35","v":0},0]
[]
[null,null,"Road 4",{"$nulls":54},{"$f":"+C37","v":"Road 4"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$15=1,\"\",+VLOOKUP('Road 4'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT38=1,AV38=1),Schedule!$N$1,IF(AND(AT38=1,AV38>1),Schedule!$N$3,IF(AND(AT38>1,AV38=1),Schedule!$N$2,IF(AND(AT38>1,AV38>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU38=0,0,$BL$38)","v":0},{"$f":"+IF(I38=\"\",0,1)","v":0},{"$f":"+AU38","v":0},{"$f":"+AW35+AU38","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U38:W41)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU38:AU45)>0,1,0)","v":0},{"$f":"IF(BK38=0,0,BK8+BK18+BK28+BK38)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$20=1,\"\",+VLOOKUP('Road 4'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT39=1,AV39=1),Schedule!$N$1,IF(AND(AT39=1,AV39>1),Schedule!$N$3,IF(AND(AT39>1,AV39=1),Schedule!$N$2,IF(AND(AT39>1,AV39>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU38+AU39","v":0},{"$f":"+AW38+AU39","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U42:W45)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$25=1,\"\",+VLOOKUP('Road 4'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT40=1,AV40=1),Schedule!$N$1,IF(AND(AT40=1,AV40>1),Schedule!$N$3,IF(AND(AT40>1,AV40=1),Schedule!$N$2,IF(AND(AT40>1,AV40>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU40+AU38+AU39","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD42:AE45)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$30=1,\"\",+VLOOKUP('Road 4'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT41=1,AV41=1),Schedule!$N$1,IF(AND(AT41=1,AV41>1),Schedule!$N$3,IF(AND(AT41>1,AV41=1),Schedule!$N$2,IF(AND(AT41>1,AV41>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU38+AU39+AU40+AU41","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 4'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$38=1,\"\",+VLOOKUP('Road 4'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT42=1,AV42=1),Schedule!$N$1,IF(AND(AT42=1,AV42>1),Schedule!$N$3,IF(AND(AT42>1,AV42=1),Schedule!$N$2,IF(AND(AT42>1,AV42>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 4'!$H$40=0,0,ROUND('Road 4'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y42*AB42","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU38+AU39+AU40+AU41+AU42","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$44=1,\"\",+VLOOKUP('Road 4'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT43=1,AV43=1),Schedule!$N$1,IF(AND(AT43=1,AV43>1),Schedule!$N$3,IF(AND(AT43>1,AV43=1),Schedule!$N$2,IF(AND(AT43>1,AV43>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 4'!$H$46=0,0,ROUND('Road 4'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y43*AB43","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU38+AU39+AU40+AU41+AU42+AU43","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$50=1,\"\",+VLOOKUP('Road 4'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT44=1,AV44=1),Schedule!$N$1,IF(AND(AT44=1,AV44>1),Schedule!$N$3,IF(AND(AT44>1,AV44=1),Schedule!$N$2,IF(AND(AT44>1,AV44>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 4'!$H$52=0,0,ROUND('Road 4'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU38+AU39+AU40+AU41+AU42+AU43+AU44","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 4'!$AS$56=1,\"\",+VLOOKUP('Road 4'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT45=1,AV45=1),Schedule!$N$1,IF(AND(AT45=1,AV45>1),Schedule!$N$3,IF(AND(AT45>1,AV45=1),Schedule!$N$2,IF(AND(AT45>1,AV45>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 4'!$H$58=0,0,ROUND('Road 4'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU38+AU39+AU40+AU41+AU42+AU43+AU44+AU45","v":0},0]
[]
[null,null,"Road 5",{"$nulls":54},{"$f":"+C47","v":"Road 5"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$15=1,\"\",+VLOOKUP('Road 5'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT48=1,AV48=1),Schedule!$N$1,IF(AND(AT48=1,AV48>1),Schedule!$N$3,IF(AND(AT48>1,AV48=1),Schedule!$N$2,IF(AND(AT48>1,AV48>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU48=0,0,$BL$48)","v":0},{"$f":"+IF(I48=\"\",0,1)","v":0},{"$f":"+AU48","v":0},{"$f":"+AW45+AU48","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U48:W51)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU48:AU55)>0,1,0)","v":0},{"$f":"IF(BK48=0,0,BK8+BK18+BK28+BK38+BK48)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$20=1,\"\",+VLOOKUP('Road 5'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT49=1,AV49=1),Schedule!$N$1,IF(AND(AT49=1,AV49>1),Schedule!$N$3,IF(AND(AT49>1,AV49=1),Schedule!$N$2,IF(AND(AT49>1,AV49>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU48+AU49","v":0},{"$f":"+AW48+AU49","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U52:W55)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$25=1,\"\",+VLOOKUP('Road 5'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT50=1,AV50=1),Schedule!$N$1,IF(AND(AT50=1,AV50>1),Schedule!$N$3,IF(AND(AT50>1,AV50=1),Schedule!$N$2,IF(AND(AT50>1,AV50>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU50+AU48+AU49","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD52:AE55)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$30=1,\"\",+VLOOKUP('Road 5'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT51=1,AV51=1),Schedule!$N$1,IF(AND(AT51=1,AV51>1),Schedule!$N$3,IF(AND(AT51>1,AV51=1),Schedule!$N$2,IF(AND(AT51>1,AV51>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU48+AU49+AU50+AU51","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 5'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$38=1,\"\",+VLOOKUP('Road 5'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT52=1,AV52=1),Schedule!$N$1,IF(AND(AT52=1,AV52>1),Schedule!$N$3,IF(AND(AT52>1,AV52=1),Schedule!$N$2,IF(AND(AT52>1,AV52>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 5'!$H$40=0,0,ROUND('Road 5'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y52*AB52","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU48+AU49+AU50+AU51+AU52","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$44=1,\"\",+VLOOKUP('Road 5'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT53=1,AV53=1),Schedule!$N$1,IF(AND(AT53=1,AV53>1),Schedule!$N$3,IF(AND(AT53>1,AV53=1),Schedule!$N$2,IF(AND(AT53>1,AV53>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 5'!$H$46=0,0,ROUND('Road 5'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y53*AB53","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU48+AU49+AU50+AU51+AU52+AU53","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$50=1,\"\",+VLOOKUP('Road 5'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT54=1,AV54=1),Schedule!$N$1,IF(AND(AT54=1,AV54>1),Schedule!$N$3,IF(AND(AT54>1,AV54=1),Schedule!$N$2,IF(AND(AT54>1,AV54>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 5'!$H$52=0,0,ROUND('Road 5'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU48+AU49+AU50+AU51+AU52+AU53+AU54","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 5'!$AS$56=1,\"\",+VLOOKUP('Road 5'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT55=1,AV55=1),Schedule!$N$1,IF(AND(AT55=1,AV55>1),Schedule!$N$3,IF(AND(AT55>1,AV55=1),Schedule!$N$2,IF(AND(AT55>1,AV55>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 5'!$H$58=0,0,ROUND('Road 5'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU48+AU49+AU50+AU51+AU52+AU53+AU54+AU55","v":0},0]
[]
[null,null,"Road 6",{"$nulls":54},{"$f":"+C57","v":"Road 6"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$15=1,\"\",+VLOOKUP('Road 6'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT58=1,AV58=1),Schedule!$N$1,IF(AND(AT58=1,AV58>1),Schedule!$N$3,IF(AND(AT58>1,AV58=1),Schedule!$N$2,IF(AND(AT58>1,AV58>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU58=0,0,$BL$58)","v":0},{"$f":"+IF(I58=\"\",0,1)","v":0},{"$f":"+AU58","v":0},{"$f":"+AW55+AU58","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U58:W61)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU58:AU65)>0,1,0)","v":0},{"$f":"IF(BK58=0,0,BK8+BK18+BK28+BK38+BK48+BK58)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$20=1,\"\",+VLOOKUP('Road 6'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT59=1,AV59=1),Schedule!$N$1,IF(AND(AT59=1,AV59>1),Schedule!$N$3,IF(AND(AT59>1,AV59=1),Schedule!$N$2,IF(AND(AT59>1,AV59>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU58+AU59","v":0},{"$f":"+AW58+AU59","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U62:W65)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$25=1,\"\",+VLOOKUP('Road 6'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT60=1,AV60=1),Schedule!$N$1,IF(AND(AT60=1,AV60>1),Schedule!$N$3,IF(AND(AT60>1,AV60=1),Schedule!$N$2,IF(AND(AT60>1,AV60>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU60+AU58+AU59","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD62:AE65)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$30=1,\"\",+VLOOKUP('Road 6'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT61=1,AV61=1),Schedule!$N$1,IF(AND(AT61=1,AV61>1),Schedule!$N$3,IF(AND(AT61>1,AV61=1),Schedule!$N$2,IF(AND(AT61>1,AV61>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU58+AU59+AU60+AU61","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 6'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$38=1,\"\",+VLOOKUP('Road 6'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT62=1,AV62=1),Schedule!$N$1,IF(AND(AT62=1,AV62>1),Schedule!$N$3,IF(AND(AT62>1,AV62=1),Schedule!$N$2,IF(AND(AT62>1,AV62>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 6'!$H$40=0,0,ROUND('Road 6'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y62*AB62","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU58+AU59+AU60+AU61+AU62","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$44=1,\"\",+VLOOKUP('Road 6'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT63=1,AV63=1),Schedule!$N$1,IF(AND(AT63=1,AV63>1),Schedule!$N$3,IF(AND(AT63>1,AV63=1),Schedule!$N$2,IF(AND(AT63>1,AV63>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 6'!$H$46=0,0,ROUND('Road 6'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y63*AB63","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU58+AU59+AU60+AU61+AU62+AU63","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$50=1,\"\",+VLOOKUP('Road 6'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT64=1,AV64=1),Schedule!$N$1,IF(AND(AT64=1,AV64>1),Schedule!$N$3,IF(AND(AT64>1,AV64=1),Schedule!$N$2,IF(AND(AT64>1,AV64>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 6'!$H$52=0,0,ROUND('Road 6'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU58+AU59+AU60+AU61+AU62+AU63+AU64","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 6'!$AS$56=1,\"\",+VLOOKUP('Road 6'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT65=1,AV65=1),Schedule!$N$1,IF(AND(AT65=1,AV65>1),Schedule!$N$3,IF(AND(AT65>1,AV65=1),Schedule!$N$2,IF(AND(AT65>1,AV65>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 6'!$H$58=0,0,ROUND('Road 6'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU58+AU59+AU60+AU61+AU62+AU63+AU64+AU65","v":0},0]
[]
[null,null,"Road 7",{"$nulls":54},{"$f":"+C67","v":"Road 7"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$15=1,\"\",+VLOOKUP('Road 7'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT68=1,AV68=1),Schedule!$N$1,IF(AND(AT68=1,AV68>1),Schedule!$N$3,IF(AND(AT68>1,AV68=1),Schedule!$N$2,IF(AND(AT68>1,AV68>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU68=0,0,$BL$68)","v":0},{"$f":"+IF(I68=\"\",0,1)","v":0},{"$f":"+AU68","v":0},{"$f":"+AW65+AU68","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U68:W71)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU68:AU75)>0,1,0)","v":0},{"$f":"IF(BK68=0,0,BK8+BK18+BK28+BK38+BK48+BK58+BK68)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$20=1,\"\",+VLOOKUP('Road 7'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT69=1,AV69=1),Schedule!$N$1,IF(AND(AT69=1,AV69>1),Schedule!$N$3,IF(AND(AT69>1,AV69=1),Schedule!$N$2,IF(AND(AT69>1,AV69>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU68+AU69","v":0},{"$f":"+AW68+AU69","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U72:W75)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$25=1,\"\",+VLOOKUP('Road 7'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT70=1,AV70=1),Schedule!$N$1,IF(AND(AT70=1,AV70>1),Schedule!$N$3,IF(AND(AT70>1,AV70=1),Schedule!$N$2,IF(AND(AT70>1,AV70>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU70+AU68+AU69","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD72:AE75)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$30=1,\"\",+VLOOKUP('Road 7'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT71=1,AV71=1),Schedule!$N$1,IF(AND(AT71=1,AV71>1),Schedule!$N$3,IF(AND(AT71>1,AV71=1),Schedule!$N$2,IF(AND(AT71>1,AV71>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU68+AU69+AU70+AU71","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 7'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$38=1,\"\",+VLOOKUP('Road 7'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT72=1,AV72=1),Schedule!$N$1,IF(AND(AT72=1,AV72>1),Schedule!$N$3,IF(AND(AT72>1,AV72=1),Schedule!$N$2,IF(AND(AT72>1,AV72>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 7'!$H$40=0,0,ROUND('Road 7'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y72*AB72","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU68+AU69+AU70+AU71+AU72","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$44=1,\"\",+VLOOKUP('Road 7'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT73=1,AV73=1),Schedule!$N$1,IF(AND(AT73=1,AV73>1),Schedule!$N$3,IF(AND(AT73>1,AV73=1),Schedule!$N$2,IF(AND(AT73>1,AV73>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 7'!$H$46=0,0,ROUND('Road 7'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y73*AB73","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU68+AU69+AU70+AU71+AU72+AU73","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$50=1,\"\",+VLOOKUP('Road 7'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT74=1,AV74=1),Schedule!$N$1,IF(AND(AT74=1,AV74>1),Schedule!$N$3,IF(AND(AT74>1,AV74=1),Schedule!$N$2,IF(AND(AT74>1,AV74>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 7'!$H$52=0,0,ROUND('Road 7'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU68+AU69+AU70+AU71+AU72+AU73+AU74","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 7'!$AS$56=1,\"\",+VLOOKUP('Road 7'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT75=1,AV75=1),Schedule!$N$1,IF(AND(AT75=1,AV75>1),Schedule!$N$3,IF(AND(AT75>1,AV75=1),Schedule!$N$2,IF(AND(AT75>1,AV75>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 7'!$H$58=0,0,ROUND('Road 7'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU68+AU69+AU70+AU71+AU72+AU73+AU74+AU75","v":0},0]
[]
[null,null,"Road 8",{"$nulls":54},{"$f":"+C77","v":"Road 8"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$15=1,\"\",+VLOOKUP('Road 8'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT78=1,AV78=1),Schedule!$N$1,IF(AND(AT78=1,AV78>1),Schedule!$N$3,IF(AND(AT78>1,AV78=1),Schedule!$N$2,IF(AND(AT78>1,AV78>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU78=0,0,$BL$78)","v":0},{"$f":"+IF(I78=\"\",0,1)","v":0},{"$f":"+AU78","v":0},{"$f":"+AW75+AU78","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U78:W81)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU78:AU85)>0,1,0)","v":0},{"$f":"IF(BK78=0,0,BK8+BK18+BK28+BK38+BK48+BK58+BK68+BK78)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$20=1,\"\",+VLOOKUP('Road 8'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT79=1,AV79=1),Schedule!$N$1,IF(AND(AT79=1,AV79>1),Schedule!$N$3,IF(AND(AT79>1,AV79=1),Schedule!$N$2,IF(AND(AT79>1,AV79>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU78+AU79","v":0},{"$f":"+AW78+AU79","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U82:W85)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$25=1,\"\",+VLOOKUP('Road 8'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT80=1,AV80=1),Schedule!$N$1,IF(AND(AT80=1,AV80>1),Schedule!$N$3,IF(AND(AT80>1,AV80=1),Schedule!$N$2,IF(AND(AT80>1,AV80>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU80+AU78+AU79","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD82:AE85)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$30=1,\"\",+VLOOKUP('Road 8'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT81=1,AV81=1),Schedule!$N$1,IF(AND(AT81=1,AV81>1),Schedule!$N$3,IF(AND(AT81>1,AV81=1),Schedule!$N$2,IF(AND(AT81>1,AV81>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU78+AU79+AU80+AU81","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 8'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$38=1,\"\",+VLOOKUP('Road 8'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT82=1,AV82=1),Schedule!$N$1,IF(AND(AT82=1,AV82>1),Schedule!$N$3,IF(AND(AT82>1,AV82=1),Schedule!$N$2,IF(AND(AT82>1,AV82>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 8'!$H$40=0,0,ROUND('Road 8'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y82*AB82","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU78+AU79+AU80+AU81+AU82","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$44=1,\"\",+VLOOKUP('Road 8'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT83=1,AV83=1),Schedule!$N$1,IF(AND(AT83=1,AV83>1),Schedule!$N$3,IF(AND(AT83>1,AV83=1),Schedule!$N$2,IF(AND(AT83>1,AV83>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 8'!$H$46=0,0,ROUND('Road 8'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y83*AB83","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU78+AU79+AU80+AU81+AU82+AU83","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$50=1,\"\",+VLOOKUP('Road 8'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT84=1,AV84=1),Schedule!$N$1,IF(AND(AT84=1,AV84>1),Schedule!$N$3,IF(AND(AT84>1,AV84=1),Schedule!$N$2,IF(AND(AT84>1,AV84>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 8'!$H$52=0,0,ROUND('Road 8'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU78+AU79+AU80+AU81+AU82+AU83+AU84","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 8'!$AS$56=1,\"\",+VLOOKUP('Road 8'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT85=1,AV85=1),Schedule!$N$1,IF(AND(AT85=1,AV85>1),Schedule!$N$3,IF(AND(AT85>1,AV85=1),Schedule!$N$2,IF(AND(AT85>1,AV85>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 8'!$H$58=0,0,ROUND('Road 8'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU78+AU79+AU80+AU81+AU82+AU83+AU84+AU85","v":0},0]
[]
[null,null,"Road 9",{"$nulls":54},{"$f":"+C87","v":"Road 9"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$15=1,\"\",+VLOOKUP('Road 9'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT88=1,AV88=1),Schedule!$N$1,IF(AND(AT88=1,AV88>1),Schedule!$N$3,IF(AND(AT88>1,AV88=1),Schedule!$N$2,IF(AND(AT88>1,AV88>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU88=0,0,$BL$88)","v":0},{"$f":"+IF(I88=\"\",0,1)","v":0},{"$f":"+AU88","v":0},{"$f":"+AW85+AU88","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U88:W91)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU88:AU95)>0,1,0)","v":0},{"$f":"IF(BK88=0,0,BK8+BK18+BK28+BK38+BK48+BK58+BK68+BK78+BK88)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$20=1,\"\",+VLOOKUP('Road 9'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT89=1,AV89=1),Schedule!$N$1,IF(AND(AT89=1,AV89>1),Schedule!$N$3,IF(AND(AT89>1,AV89=1),Schedule!$N$2,IF(AND(AT89>1,AV89>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU88+AU89","v":0},{"$f":"+AW88+AU89","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U92:W95)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$25=1,\"\",+VLOOKUP('Road 9'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT90=1,AV90=1),Schedule!$N$1,IF(AND(AT90=1,AV90>1),Schedule!$N$3,IF(AND(AT90>1,AV90=1),Schedule!$N$2,IF(AND(AT90>1,AV90>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU90+AU88+AU89","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD92:AE95)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$30=1,\"\",+VLOOKUP('Road 9'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT91=1,AV91=1),Schedule!$N$1,IF(AND(AT91=1,AV91>1),Schedule!$N$3,IF(AND(AT91>1,AV91=1),Schedule!$N$2,IF(AND(AT91>1,AV91>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU88+AU89+AU90+AU91","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 9'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$38=1,\"\",+VLOOKUP('Road 9'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT92=1,AV92=1),Schedule!$N$1,IF(AND(AT92=1,AV92>1),Schedule!$N$3,IF(AND(AT92>1,AV92=1),Schedule!$N$2,IF(AND(AT92>1,AV92>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 9'!$H$40=0,0,ROUND('Road 9'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y92*AB92","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU88+AU89+AU90+AU91+AU92","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$44=1,\"\",+VLOOKUP('Road 9'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT93=1,AV93=1),Schedule!$N$1,IF(AND(AT93=1,AV93>1),Schedule!$N$3,IF(AND(AT93>1,AV93=1),Schedule!$N$2,IF(AND(AT93>1,AV93>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 9'!$H$46=0,0,ROUND('Road 9'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y93*AB93","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU88+AU89+AU90+AU91+AU92+AU93","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$50=1,\"\",+VLOOKUP('Road 9'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT94=1,AV94=1),Schedule!$N$1,IF(AND(AT94=1,AV94>1),Schedule!$N$3,IF(AND(AT94>1,AV94=1),Schedule!$N$2,IF(AND(AT94>1,AV94>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 9'!$H$52=0,0,ROUND('Road 9'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU88+AU89+AU90+AU91+AU92+AU93+AU94","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 9'!$AS$56=1,\"\",+VLOOKUP('Road 9'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT95=1,AV95=1),Schedule!$N$1,IF(AND(AT95=1,AV95>1),Schedule!$N$3,IF(AND(AT95>1,AV95=1),Schedule!$N$2,IF(AND(AT95>1,AV95>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 9'!$H$58=0,0,ROUND('Road 9'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU88+AU89+AU90+AU91+AU92+AU93+AU94+AU95","v":0},0]
[]
[null,null,"Road 10",{"$nulls":54},{"$f":"+C97","v":"Road 10"}]
[null,"Moving Restriction 1:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$15=1,\"\",+VLOOKUP('Road 10'!$AS$15,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT98=1,AV98=1),Schedule!$N$1,IF(AND(AT98=1,AV98>1),Schedule!$N$3,IF(AND(AT98>1,AV98=1),Schedule!$N$2,IF(AND(AT98>1,AV98>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},{"$f":"IF(AU98=0,0,$BL$98)","v":0},{"$f":"+IF(I98=\"\",0,1)","v":0},{"$f":"+AU98","v":0},{"$f":"+AW95+AU98","v":0},{"$nulls":8},"Moving Sub-total:",{"$f":"+SUM(U98:W101)","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"+IF(SUM(AU98:AU105)>0,1,0)","v":0},{"$f":"IF(BK98=0,0,BK8+BK18+BK28+BK38+BK48+BK58+BK68+BK78+BK88+BK98)","v":0}]
[null,"Moving Restriction 2:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$20=1,\"\",+VLOOKUP('Road 10'!$AS$20,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT99=1,AV99=1),Schedule!$N$1,IF(AND(AT99=1,AV99>1),Schedule!$N$3,IF(AND(AT99>1,AV99=1),Schedule!$N$2,IF(AND(AT99>1,AV99>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"+AU98+AU99","v":0},{"$f":"+AW98+AU99","v":0},{"$nulls":8},"Static Sub-total:",{"$f":"+SUM(U102:W105)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 3:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$25=1,\"\",+VLOOKUP('Road 10'!$AS$25,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT100=1,AV100=1),Schedule!$N$1,IF(AND(AT100=1,AV100>1),Schedule!$N$3,IF(AND(AT100>1,AV100=1),Schedule!$N$2,IF(AND(AT100>1,AV100>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":24},0,0,{"$f":"AU100+AU98+AU99","v":0},0,{"$nulls":8},"Waiting Boards Sub-total:",{"$f":"+SUM(AD102:AE105)","v":{"v":0,"d":"£0"}}]
[null,"Moving Restriction 4:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$30=1,\"\",+VLOOKUP('Road 10'!$AS$30,Schedule!$B:$D,3))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT101=1,AV101=1),Schedule!$N$1,IF(AND(AT101=1,AV101>1),Schedule!$N$3,IF(AND(AT101>1,AV101=1),Schedule!$N$2,IF(AND(AT101>1,AV101>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},"Waiting Boards",{"$nulls":20},0,0,{"$f":"+AU98+AU99+AU100+AU101","v":0},0,{"$nulls":8},"Bagging / masking bond:",{"$f":"+'Road 10'!$AC$72","v":0}]
[null,"Static Restriction 1:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$38=1,\"\",+VLOOKUP('Road 10'!$AS$38,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT102=1,AV102=1),Schedule!$N$1,IF(AND(AT102=1,AV102>1),Schedule!$N$3,IF(AND(AT102>1,AV102=1),Schedule!$N$2,IF(AND(AT102>1,AV102>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 10'!$H$40=0,0,ROUND('Road 10'!$H$40/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y102*AB102","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU98+AU99+AU100+AU101+AU102","v":0},0]
[null,"Static Restriction 2:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$44=1,\"\",+VLOOKUP('Road 10'!$AS$44,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT103=1,AV103=1),Schedule!$N$1,IF(AND(AT103=1,AV103>1),Schedule!$N$3,IF(AND(AT103>1,AV103=1),Schedule!$N$2,IF(AND(AT103>1,AV103>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 10'!$H$46=0,0,ROUND('Road 10'!$H$46/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"$f":"+Y103*AB103","v":{"v":0,"d":"£0"}},{"$nulls":15},0,0,{"$f":"+AU98+AU99+AU100+AU101+AU102+AU103","v":0},0]
[null,"Static Restriction 3:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$50=1,\"\",+VLOOKUP('Road 10'!$AS$50,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT104=1,AV104=1),Schedule!$N$1,IF(AND(AT104=1,AV104>1),Schedule!$N$3,IF(AND(AT104>1,AV104=1),Schedule!$N$2,IF(AND(AT104>1,AV104>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 10'!$H$52=0,0,ROUND('Road 10'!$H$52/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU98+AU99+AU100+AU101+AU102+AU103+AU104","v":0},0]
[null,"Static Restriction 4:",{"$nulls":6},{"$f":"IF('Road 10'!$AS$56=1,\"\",+VLOOKUP('Road 10'!$AS$56,Schedule!$G:$H,2))","v":""},{"$nulls":11},{"$f":"+IF(AND(AT105=1,AV105=1),Schedule!$N$1,IF(AND(AT105=1,AV105>1),Schedule!$N$3,IF(AND(AT105>1,AV105=1),Schedule!$N$2,IF(AND(AT105>1,AV105>1),Schedule!$N$3,0))))","v":{"v":0,"d":"£0"}},{"$nulls":3},{"$f":"IF('Road 10'!$H$58=0,0,ROUND('Road 10'!$H$58/Schedule!$Q$1,0)+1)","v":0},"no","x",{"$f":"+Schedule!$N$5","v":{"v":0,"d":"£0"}},null,{"v":0,"d":"£0"},{"$nulls":15},0,0,{"$f":"+AU98+AU99+AU100+AU101+AU102+AU103+AU104+AU105","v":0},0]
[]
[{"$nulls":46},{"$f":"SUM(AU8:AU105)","v":0},null,null,{"$f":"+IF(AU107>0,1,0)","v":0}]