{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Application O","Application A","Application B","S73 Calc","Terms of Use","Change Log"],"not_rendered":{"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":50,"n_cols":3,"rows_kept":50,"merged":[[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[19,0,19,7],[33,0,35,11]]}
[{"$f":"CONCATENATE(\"Exacom S73 Calculator Version \",'Terms of Use'!C3)","v":"Exacom S73 Calculator Version 1.11"}]
["How many places to round indexation to?"]
[]
["Initial Steps"]
[]
["Answer the question above as to how many decimal places to round your indexation result to. If you leave this blank, then no rounding is done on the indexation. If you enter a number, then indexation will be rounded to that number of decimal places  "]
[]
[]
["Next Steps"]
[]
["IMPORTANT: At the top of the 'Application A' tab, set whether 'Application A' (the Previous application) is an Original application, or a Section 73 itself. This is needed for the calculations should the liability decrease between 'A' and 'B'. In this scenario we need certain values from the Original. The Original App details will then need to be filled out. An \"Application O\" button will appear to facilitate this."]
["To ensure the sheet always starts with zeros and doesn't have any stray values, ensure you open the XLTX (Template) file. This will open a brand new copy of that template, instead of the template itself. This will preserve the original."]
["Ensure you're always using the latest version of this spreadsheet. The version is at the top of this page and there is a Change Log sheet below with details of any changes. Please always check our  website for the latest."]
["Fill out the tabs for 'Application A' and 'Application B' to determine whether the notional amount has changed. Ensure you check every box that is coloured in these 2 tabs. The values in Application A must represent your PREVIOUS application. The values in Application B must represent your SUPERSEDING application. For the notional value calculation, the 'Application B' tab allows you to switch between using the Demolition and Retained use values from 'Application A' or 'Application B' to accommodate different circumstances (e.g. \"in use\" rule lapsing)"]
["If demolition changes from application to application you will be prompted to choose whether that demolition changed because of a change in the planning application, or because the demolition failed the \"In Use\" rule. This prompt appears to the right of the Demolition value. \nSimilar prompts appear for Retained use and appear below the social housing box for each use. These need to be answered for each \"use\" that changes."]
["Click on this button to proceed to Application A (the Preceding Application):",null,"Application A"]
[]
["Other advice"]
[]
["Click here to open up Schedule 1 from the September 2019 regulation amendments"]
["Be very very careful if you've got a set of applications where the \"In Use\" rule for \"Demolition\" or \"Retained Use\" results in a change to those values. The scenarios can get complicated in the real world."]
["Each Application tab will allow for up to 6 \"uses\". Leave the unused \"uses\" with 0 (zero) figures. Ensure the \"uses\" align with the area of the development used (i.e. the area in a development reflected under \"USE 1\" must remain that same area from A to B)"]
["Z is always the value of the previous Liability Notice. Ensure this is completed in the 'Application A' tab. It's not something that can necessarily be calculated on the fly, as the Previous application may have been a S73 and subject to its own (X-Y)+Z calculation"]
["London Boroughs - This workbook needs to be separately completed per charging authority. It is possible to have one CIL liability going up (Paragraph 4 applies), and one liability going down (Paragraph 5 applies)"]
["The S73 Calc results are colour coded to the Applications, Green for the Original (only in the case the Original is NOT the previous), blue for Application A (Previous), Orange for Application B (Superseding)"]
["Change the \"Use\" names in the 'Application A' tab and it will propagate throughout the workbook"]
["Any box with a red tag like this one has a note attached -->"]
[]
["How the workbook works"]
[]
["This workbook is intended to cover Paragraphs 3,4,5 of Schedule 1. It is not intended for Paragraph 7"]
["The site totals are worked out as per the Reg 40 and Reg 50 formulas in worksheets 'Application A', and 'Application B', as amended"]
["Application B is always the superseding application for which we are calculating the adjusted values under Schedule 1 of the regulations (Paragraph 3,  4 or 5)"]
["The results are displayed in the \"S73 Calculation\" tab. The results will adjust themselves depending on the circumstances (i.e. whether liability increases, decreases, or stays the same). It will display the appropriate formula used.\nThe tables titled \"Liability Workings\" and \"Relief Workings\" will highlight and bold the columns that are relevant to the final calculation. The columns that aren't used will be left in grey"]
[]
[]
["The calculations for the floor area SQM and social housing relief floor area SQM are not rounded. They may appear rounded to 2 decimal places for visual reasons. The area component items on the S73 Calcs sheet appear with 14 decimal places for ease of copying to the Exacom System"]
["The calculated results for each use can be imported to the Exacom system (v313+ only), allowing quick data transfer from the spreadsheet to your Exacom Calcuator tab."]
[]
["Navigation - Tabs"]
[null,"Application A"]
["Application A"]
[null,"Application B"]
["Application B"]
[null,"S73 Calculation"]
["S73 Calculation Tab"]
[null,"Terms Of Use"]
["To see the Terms of Use click here"]
[null,"Change Log"]
["To see the Change log, click here"]

{"sheet":"Application O","index":1,"n_rows":75,"n_cols":6,"rows_kept":75}
[null,"Site Calculator - Application O (Original Application)",null,null,"NOTE: YOU DON'T NEED TO FILL THIS IN! GO BACK!"]
[]
[null,"THIS APPLICATION",{"$nulls":3},"Application A"]
[]
[null,"IP as at effective decision date for this application",0,null,null,"Application B"]
[null,"IC from Charging Schedule for this application",0]
[{"$nulls":5},"S73 Calculation"]
[null,"Site Demolition",{"v":0,"d":"0.00"}]
[{"$nulls":5},"Instructions"]
[]
[]
[null,{"$f":"'Application A'!B12","v":"Use 1"},null,null,{"$f":"CONCATENATE(B12,\" Relief\")","v":"Use 1 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F14-F15-(F14*C$8/(IF($F$72=0,1,$F$72)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C15-C16-($C$8*C15/IF($F$72=0,1,$F$72))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C14*F16*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C14*F16*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C17*C14*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C17*C14*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B12, \" Notional Charge After Relief\")","v":"Use 1 Notional Charge After Relief"},{"$f":"C18-F17","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B23","v":"Use 2"},null,null,{"$f":"CONCATENATE(B21,\" Relief\")","v":"Use 2 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F23-F24-(F23*C$8/(IF($F$72=0,1,$F$72)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C24-C25-($C$8*C24/IF($F$72=0,1,$F$72))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C23*F25*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C23*F25*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C26*C23*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C26*C23*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B21, \" Notional Charge After Relief\")","v":"Use 2 Notional Charge After Relief"},{"$f":"C27-F26","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B34","v":"Use 3"},null,null,{"$f":"CONCATENATE(B30,\" Relief\")","v":"Use 3 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F32-F33-(F32*C$8/(IF($F$72=0,1,$F$72)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C33-C34-($C$8*C33/IF($F$72=0,1,$F$72))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C32*F34*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C32*F34*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C35*C32*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C35*C32*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B30, \" Notional Charge After Relief\")","v":"Use 3 Notional Charge After Relief"},{"$f":"C36-F35","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B45","v":"Use 4"},null,null,{"$f":"CONCATENATE(B39,\" Relief\")","v":"Use 4 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F41-F42-(F41*C$8/(IF($F$72=0,1,$F$72)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C42-C43-($C$8*C42/IF($F$72=0,1,$F$72))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C41*F43*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C41*F43*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C44*C41*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C44*C41*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B39, \" Notional Charge After Relief\")","v":"Use 4 Notional Charge After Relief"},{"$f":"C45-F44","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B56","v":"Use 5"},null,null,{"$f":"CONCATENATE(B48,\" Relief\")","v":"Use 5 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F50-F51-(F50*C$8/(IF($F$72=0,1,$F$72)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C51-C52-($C$8*C51/IF($F$72=0,1,$F$72))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C50*F52*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C50*F52*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C53*C50*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C53*C50*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B48, \" Notional Charge After Relief\")","v":"Use 5 Notional Charge After Relief"},{"$f":"C54-F53","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B67","v":"Use 6"},null,null,{"$f":"CONCATENATE(B57,\" Relief\")","v":"Use 6 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F59-F60-(F59*C$8/(IF($F$72=0,1,$F$72)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C60-C61-($C$8*C60/IF($F$72=0,1,$F$72))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C59*F61*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C59*F61*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C62*C59*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C62*C59*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B57, \" Notional Charge After Relief\")","v":"Use 6 Notional Charge After Relief"},{"$f":"C63-F62","v":{"v":0,"d":"£0.00"}}]
[]
[null,"Less: Any OTHER relief"]
[]
[null,"TOTAL NOTIONAL LIABILITY",{"$f":"C37+C28+C19+C46+C55+C64-C66","v":{"v":0,"d":"£0.00"}}]
[]
[null,"£ Totals",null,null,"Site SQM Totals"]
[]
[null,"Total Net Liability Pre Relief",{"$f":"C36+C27+C18+C45+C54+C63","v":{"v":0,"d":"£0.00"}},null,"Gross Internal Area",{"$f":"C15+C24+C33+C42+C51+C60","v":{"v":0,"d":"0.00"}}]
[null,"Total Social Housing Relief",{"$f":"F35+F26+F17+F44+F53+F62","v":{"v":0,"d":"£0.00"}},null,"Retained Use",{"$f":"C34+C25+C16+C43+C52+C61","v":{"v":0,"d":"0.00"}}]
[null,"Total Net Liability Post Relief",{"$f":"C37+C28+C19+C46+C55+C64","v":{"v":0,"d":"£0.00"}},null,"Site Demolition",{"$f":"C8","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"Net Area",{"$f":"C35+C26+C17+C44+C53+C62","v":{"v":0,"d":"0.00"}}]

{"sheet":"Application A","index":2,"n_rows":87,"n_cols":6,"rows_kept":87}
[null,"Site Calculator - Application A (Previous Application)",null,null,"Is this an ORIGINAL APPLICATION or a SECTION 73?","Original"]
[]
[null,"THIS APPLICATION",null,null,"As this tab is a S73, you must fill out the App O:    ----->","Application O"]
[]
[null,"IP as at effective decision date for this application",0,null,null,"Application B"]
[null,"IC from Charging Schedule for this application",0]
[{"$nulls":5},"S73 Calculation"]
[null,"Site Demolition",{"v":0,"d":"0.00"},null,"Why has demolition changed?","It just changed"]
[{"$nulls":5},"Instructions"]
[]
[]
[null,"Use 1",null,null,{"$f":"CONCATENATE(B12,\" Relief\")","v":"Use 1 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F14-F15-(F14*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C15-C16-($C$8*C15/IF($F$84=0,1,$F$84))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C14*F16*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C14*F16*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C17*C14*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C17*C14*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B12, \" Notional Charge After Relief\")","v":"Use 1 Notional Charge After Relief"},{"$f":"C18-F17","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B12, \" Liability Notice value Before Relief\")","v":"Use 1 Liability Notice value Before Relief"},{"v":0,"d":"£0.00"},null,{"$f":"CONCATENATE(B12, \" Liability Notice Relief Value\")","v":"Use 1 Liability Notice Relief Value"},{"v":0,"d":"£0.00"}]
[]
[null,"Use 2",null,null,{"$f":"CONCATENATE(B23,\" Relief\")","v":"Use 2 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F25-F26-(F25*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C26-C27-($C$8*C26/IF($F$84=0,1,$F$84))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C25*F27*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C25*F27*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C28*C25*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C28*C25*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B23, \" Notional Charge After Relief\")","v":"Use 2 Notional Charge After Relief"},{"$f":"C29-F28","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B23, \" Liability Notice value Before Relief\")","v":"Use 2 Liability Notice value Before Relief"},{"v":0,"d":"£0.00"},null,{"$f":"CONCATENATE(B23, \" Liability Notice Relief Value\")","v":"Use 2 Liability Notice Relief Value"},{"v":0,"d":"£0.00"}]
[]
[null,"Use 3",null,null,{"$f":"CONCATENATE(B34,\" Relief\")","v":"Use 3 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F36-F37-(F36*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C37-C38-($C$8*C37/IF($F$84=0,1,$F$84))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C36*F38*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C36*F38*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C39*C36*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C39*C36*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B34, \" Notional Charge After Relief\")","v":"Use 3 Notional Charge After Relief"},{"$f":"C40-F39","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B34, \" Liability Notice value Before Relief\")","v":"Use 3 Liability Notice value Before Relief"},{"v":0,"d":"£0.00"},null,{"$f":"CONCATENATE(B34, \" Liability Notice Relief Value\")","v":"Use 3 Liability Notice Relief Value"},{"v":0,"d":"£0.00"}]
[]
[null,"Use 4",null,null,{"$f":"CONCATENATE(B45,\" Relief\")","v":"Use 4 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F47-F48-(F47*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C48-C49-($C$8*C48/IF($F$84=0,1,$F$84))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C47*F49*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C47*F49*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C50*C47*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C50*C47*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B45, \" Notional Charge After Relief\")","v":"Use 4 Notional Charge After Relief"},{"$f":"C51-F50","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B45, \" Liability Notice value Before Relief\")","v":"Use 4 Liability Notice value Before Relief"},{"v":0,"d":"£0.00"},null,{"$f":"CONCATENATE(B45, \" Liability Notice Relief Value\")","v":"Use 4 Liability Notice Relief Value"},{"v":0,"d":"£0.00"}]
[]
[null,"Use 5",null,null,{"$f":"CONCATENATE(B56,\" Relief\")","v":"Use 5 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F58-F59-(F58*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C59-C60-($C$8*C59/IF($F$84=0,1,$F$84))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C58*F60*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C58*F60*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Charge Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C61*C58*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C61*C58*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B56, \" Notional Charge After Relief\")","v":"Use 5 Notional Charge After Relief"},{"$f":"C62-F61","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B56, \" Liability Notice value Before Relief\")","v":"Use 5 Liability Notice value Before Relief"},{"v":0,"d":"£0.00"},null,{"$f":"CONCATENATE(B56, \" Liability Notice Relief Value\")","v":"Use 5 Liability Notice Relief Value"},{"v":0,"d":"£0.00"}]
[]
[null,"Use 6",null,null,{"$f":"CONCATENATE(B67,\" Relief\")","v":"Use 6 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F69-F70-(F69*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C70-C71-($C$8*C70/IF($F$84=0,1,$F$84))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C69*F71*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C69*F71*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Notional Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C72*C69*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C72*C69*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B67, \" Notional Charge After Relief\")","v":"Use 6 Notional Charge After Relief"},{"$f":"C73-F72","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B67, \" Liability Notice value Before Relief\")","v":"Use 6 Liability Notice value Before Relief"},{"v":0,"d":"£0.00"},null,{"$f":"CONCATENATE(B67, \" Liability Notice Relief Value\")","v":"Use 6 Liability Notice Relief Value"},{"v":0,"d":"£0.00"}]
[]
[null,"Less: Any OTHER relief"]
[]
[null,"TOTAL NOTIONAL LIABILITY",{"$f":"C41+C30+C19+C52+C63+C74-C78","v":{"v":0,"d":"£0.00"}}]
[]
[null,"£ Totals",null,null,"Site SQM Totals"]
[]
[null,"Total Net Liability Pre Relief",{"$f":"C40+C29+C18+C51+C62+C73","v":{"v":0,"d":"£0.00"}},null,"Gross Internal Area",{"$f":"C15+C26+C37+C48+C59+C70","v":{"v":0,"d":"0.00"}}]
[null,"Total Social Housing Relief",{"$f":"F39+F28+F17+F50+F61+F72","v":{"v":0,"d":"£0.00"}},null,"Retained Use",{"$f":"C38+C27+C16+C49+C60+C71","v":{"v":0,"d":"0.00"}}]
[null,"Total Net Liability Post Social Housing Relief",{"$f":"C41+C30+C19+C52+C63+C74","v":{"v":0,"d":"£0.00"}},null,"Site Demolition",{"$f":"C8","v":{"v":0,"d":"0.00"}}]
[null,"Total Net Liability Post all Relief ",{"$f":"C84- (F39+F28+F17+C78+F50+F61+F72)","v":{"v":0,"d":"£0.00"}},null,"Net Area",{"$f":"C39+C28+C17+C50+C61+C72","v":{"v":0,"d":"0.00"}}]

{"sheet":"Application B","index":3,"n_rows":87,"n_cols":13,"rows_kept":87}
[null,"Site Calculator - Application B (Superseding Section 73 Application)",{"$nulls":6},"Notional Value Calculations"]
[{"$nulls":5},"Application O"]
[null,"THIS APPLICATION",{"$nulls":6},"NOTIONAL RATES",null,null,"Demolition and Retained from :","This App"]
[{"$nulls":5},"Application A"]
[null,"IP as at effective decision date for this application",0,{"$nulls":5},"IP used",{"$f":"'Application A'!C5","v":0}]
[null,"IC from Charging Schedule for this application",0,null,null,"S73 Calculation",null,null,"IC used",{"$f":"'Application A'!C6","v":0}]
[]
[null,"Site Demolition",{"v":0,"d":"0.00"},null,"Why has demolition changed?","It just changed",null,null,"Demolition used",{"$f":"IF($M$3=\"Previous App\",'Application A'!C8,C8)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":5},"Instructions"]
[]
[null,{"$f":"'Application A'!B12","v":"Use 1"},null,null,{"$f":"CONCATENATE(B12,\" Relief\")","v":"Use 1 Relief"},{"$nulls":3},{"$f":"'Application A'!B12","v":"Use 1"},null,null,{"$f":"CONCATENATE(I12,\" Relief\")","v":"Use 1 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"},null,null,"Rate used",{"$f":"'Application A'!C14","v":{"v":0,"d":"£0.00"}},null,"Gross Social Housing area used",{"$f":"F14","v":{"v":0,"d":"0.00"}}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"},null,null,"Gross Area used",{"$f":"C15","v":{"v":0,"d":"0.00"}},null,"Relief retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!F15,F15)","v":{"v":0,"d":"0.00"}}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F14-F15-(F14*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,null,"Retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!C16,C16)","v":{"v":0,"d":"0.00"}},null,"Net Social Housing Area",{"$f":"IF(M14-M15-(M14*$J$8/(IF($F$84=0,1,$F$84)))<=0,0,M14-M15-(M14*$J$8/(IF($F$84=0,1,$F$84))))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C15-C16-(C$8*C15/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Net Value Social Housing Net Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C14*F16*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C14*F16*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},null,null,"Net Area used",{"$f":"J15-J16-(J$8*J15/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",M16*J14*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),M16*J14*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C17*C14*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C17*C14*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},{"$nulls":5},"Notional Amount Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",J17*J14*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),J17*J14*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B12, \" Liability After Relief\")","v":"Use 1 Liability After Relief"},{"$f":"C18-F17","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B12,\" Notional Value\")","v":"Use 1 Notional Value"},{"$f":"J18-M17","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B23","v":"Use 2"},null,null,{"$f":"CONCATENATE(B23,\" Relief\")","v":"Use 2 Relief"},{"$nulls":3},{"$f":"'Application A'!B23","v":"Use 2"},null,null,{"$f":"CONCATENATE(I23,\" Relief\")","v":"Use 2 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"},null,null,"Rate used",{"$f":"'Application A'!C25","v":{"v":0,"d":"£0.00"}},null,"Gross Social Housing area used",{"$f":"F25","v":{"v":0,"d":"0.00"}}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"},null,null,"Gross Area used",{"$f":"C26","v":{"v":0,"d":"0.00"}},null,"Relief retained area used ",{"$f":"IF($M$3=\"Previous App\",'Application A'!F26,F26)","v":{"v":0,"d":"0.00"}}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F25-F26-(F25*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,null,"Retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!C27,C27)","v":{"v":0,"d":"0.00"}},null,"Net Social Housing Area",{"$f":"IF(M25-M26-(M25*$J$8/(IF($F$84=0,1,$F$84)))<=0,0,M25-M26-(M25*$J$8/(IF($F$84=0,1,$F$84))))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C26-C27-(C$8*C26/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Net Value Social Housing Net Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C25*F27*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C25*F27*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},null,null,"Net Area",{"$f":"J26-J27-(J$8*J26/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",M27*J25*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),M27*J25*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C28*C25*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C28*C25*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},{"$nulls":5},"Notional Amount Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",J28*J25*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),J28*J25*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B23, \" Liability After Relief\")","v":"Use 2 Liability After Relief"},{"$f":"C29-F28","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,"Notional Amount After Notional Relief",{"$f":"J29-M28","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B34","v":"Use 3"},null,null,{"$f":"CONCATENATE(B34,\" Relief\")","v":"Use 3 Relief"},{"$nulls":3},{"$f":"'Application A'!B34","v":"Use 3"},null,null,{"$f":"CONCATENATE(I34,\" Relief\")","v":"Use 3 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"},null,null,"Rate used",{"$f":"'Application A'!C36","v":{"v":0,"d":"£0.00"}},null,"Gross Social Housing area used",{"$f":"F36","v":{"v":0,"d":"0.00"}}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"},null,null,"Gross Area used",{"$f":"C37","v":{"v":0,"d":"0.00"}},null,"Relief retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!F37,F37)","v":{"v":0,"d":"0.00"}}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F36-F37-(F36*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,null,"Retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!C38,C38)","v":{"v":0,"d":"0.00"}},null,"Net Social Housing Area",{"$f":"IF(M36-M37-(M36*$J$8/(IF($F$84=0,1,$F$84)))<=0,0,M36-M37-(M36*$J$8/(IF($F$84=0,1,$F$84))))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C37-C38-(C$8*C37/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Net Value Social Housing Net Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C36*F38*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C36*F38*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},null,null,"Net Area",{"$f":"J37-J38-(J$8*J37/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",M38*J36*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),M38*J36*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C39*C36*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C39*C36*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},{"$nulls":5},"Notional Amount Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",J39*J36*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),J39*J36*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B34, \" Liability After Relief\")","v":"Use 3 Liability After Relief"},{"$f":"C40-F39","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,"Notional Amount After Notional Relief",{"$f":"J40-M39","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B45","v":"Use 4"},null,null,{"$f":"CONCATENATE(B45,\" Relief\")","v":"Use 4 Relief"},{"$nulls":3},{"$f":"'Application A'!B45","v":"Use 4"},null,null,{"$f":"CONCATENATE(I45,\" Relief\")","v":"Use 4 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"},null,null,"Rate used",{"$f":"'Application A'!C47","v":{"v":0,"d":"£0.00"}},null,"Gross Social Housing area used",{"$f":"F47","v":{"v":0,"d":"0.00"}}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"},null,null,"Gross Area used",{"$f":"C48","v":{"v":0,"d":"0.00"}},null,"Relief retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!F48,F48)","v":{"v":0,"d":"0.00"}}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F47-F48-(F47*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,null,"Retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!C49,C49)","v":{"v":0,"d":"0.00"}},null,"Net Social Housing Area",{"$f":"IF(M47-M48-(M47*$J$8/(IF($F$84=0,1,$F$84)))<=0,0,M47-M48-(M47*$J$8/(IF($F$84=0,1,$F$84))))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C48-C49-(C$8*C48/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Net Value Social Housing Net Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C47*F49*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C47*F49*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},null,null,"Net Area used",{"$f":"J48-J49-(J$8*J48/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",M49*J47*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),M49*J47*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C50*C47*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C50*C47*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},{"$nulls":5},"Notional Amount Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",J50*J47*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),J50*J47*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B45, \" Liability After Relief\")","v":"Use 4 Liability After Relief"},{"$f":"C51-F50","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,{"$f":"CONCATENATE(B45,\" Notional Value\")","v":"Use 4 Notional Value"},{"$f":"J51-M50","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B56","v":"Use 5"},null,null,{"$f":"CONCATENATE(B56,\" Relief\")","v":"Use 5 Relief"},{"$nulls":3},{"$f":"'Application A'!B56","v":"Use 5"},null,null,{"$f":"CONCATENATE(I56,\" Relief\")","v":"Use 5 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"},null,null,"Rate used",{"$f":"'Application A'!C58","v":{"v":0,"d":"£0.00"}},null,"Gross Social Housing area used",{"$f":"F58","v":{"v":0,"d":"0.00"}}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"},null,null,"Gross Area used",{"$f":"C59","v":{"v":0,"d":"0.00"}},null,"Relief retained area used ",{"$f":"IF($M$3=\"Previous App\",'Application A'!F59,F59)","v":{"v":0,"d":"0.00"}}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F58-F59-(F58*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,null,"Retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!C60,C60)","v":{"v":0,"d":"0.00"}},null,"Net Social Housing Area",{"$f":"IF(M58-M59-(M58*$J$8/(IF($F$84=0,1,$F$84)))<=0,0,M58-M59-(M58*$J$8/(IF($F$84=0,1,$F$84))))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C59-C60-(C$8*C59/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Net Value Social Housing Net Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C58*F60*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C58*F60*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},null,null,"Net Area",{"$f":"J59-J60-(J$8*J59/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",M60*J58*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),M60*J58*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C61*C58*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C61*C58*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},{"$nulls":5},"Notional Amount Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",J61*J58*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),J61*J58*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B56, \" Liability After Relief\")","v":"Use 5 Liability After Relief"},{"$f":"C62-F61","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,"Notional Amount After Notional Relief",{"$f":"J62-M61","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"'Application A'!B67","v":"Use 6"},null,null,{"$f":"CONCATENATE(B67,\" Relief\")","v":"Use 6 Relief"},{"$nulls":3},{"$f":"'Application A'!B67","v":"Use 6"},null,null,{"$f":"CONCATENATE(I67,\" Relief\")","v":"Use 6 Relief"}]
[]
[null,"Rate for this use",{"v":0,"d":"£0.00"},null,"Gross Social Housing area for this use",{"v":0,"d":"0.00"},null,null,"Rate used",{"$f":"'Application A'!C69","v":{"v":0,"d":"£0.00"}},null,"Gross Social Housing area used",{"$f":"F69","v":{"v":0,"d":"0.00"}}]
[null,"Gross Area for this Use",{"v":0,"d":"0.00"},null,"Amount of retained use within this relief area",{"v":0,"d":"0.00"},null,null,"Gross Area used",{"$f":"C70","v":{"v":0,"d":"0.00"}},null,"Relief retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!F70,F70)","v":{"v":0,"d":"0.00"}}]
[null,"Retained area for this use only",{"v":0,"d":"0.00"},null,"Net Social Housing Area",{"$f":"F69-F70-(F69*C$8/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,null,"Retained area used",{"$f":"IF($M$3=\"Previous App\",'Application A'!C71,C71)","v":{"v":0,"d":"0.00"}},null,"Net Social Housing Area",{"$f":"IF(M69-M70-(M69*$J$8/(IF($F$84=0,1,$F$84)))<=0,0,M69-M70-(M69*$J$8/(IF($F$84=0,1,$F$84))))","v":{"v":0,"d":"0.00"}}]
[null,"Net Area",{"$f":"C70-C71-(C$8*C70/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Net Value Social Housing Net Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C69*F71*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C69*F71*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},null,null,"Net Area",{"$f":"J70-J71-(J$8*J70/(IF($F$84=0,1,$F$84)))","v":{"v":0,"d":"0.00"}},null,"Notional Social Housing Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",M71*J69*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),M71*J69*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Liability Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",C72*C69*ROUND(C$5/IF($C$6=0,1,$C$6),Instructions!B$2),C72*C69*C$5/IF($C$6=0,1,$C$6)),2)","v":{"v":0,"d":"£0.00"}},{"$nulls":5},"Notional Amount Before Relief",{"$f":"ROUND(IF(Instructions!B$2<>\"\",J72*J69*ROUND(J$5/IF(J$6=0,1,J$6),Instructions!B$2),J72*J69*J$5/IF(J$6=0,1,J$6)),2)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"CONCATENATE(B67, \" Liability After Relief\")","v":"Use 6 Liability After Relief"},{"$f":"C73-F72","v":{"v":0,"d":"£0.00"}},null,"Why has the retained area changed?","It just changed"]
[]
[null,"Notional Amount After Notional Relief",{"$f":"J73-M72","v":{"v":0,"d":"£0.00"}}]
[]
[null,"Less: Notional value of any OTHER relief",{"v":0,"d":"£0.00"}]
[]
[null,"TOTAL NOTIONAL LIABILITY AFTER RELIEF",{"$f":"C21+C32+C43+C54+C65+C76-C78","v":{"v":0,"d":"£0.00"}}]
[]
[null,"£ Totals",null,null,"Site SQM Totals"]
[]
[null,"Total Net Notional Liability Pre Relief",{"$f":"J18+J29+J40+J51+J62+J73","v":{"v":0,"d":"£0.00"}},null,"Gross Internal Area",{"$f":"C15+C26+C37+C48+C59+C70","v":{"v":0,"d":"0.00"}}]
[null,"Total Notional Social Housing Relief",{"$f":"M17+M28+M39+M50+M61+M72","v":{"v":0,"d":"£0.00"}},null,"Retained Use",{"$f":"C38+C27+C16+C49+C60+C71","v":{"v":0,"d":"0.00"}}]
[null,"Total Net Notional Liability Post Social Housing Relief",{"$f":"C21+C32+C43+C54+C65+C76","v":{"v":0,"d":"£0.00"}},null,"Demolition",{"$f":"C8","v":{"v":0,"d":"0.00"}}]
[null,"Total Net Notional Liability Post all Relief ",{"$f":"C86-C78","v":{"v":0,"d":"£0.00"}},null,"Net Area",{"$f":"C39+C28+C17+C50+C61+C72","v":{"v":0,"d":"0.00"}}]

{"sheet":"S73 Calc","index":4,"n_rows":121,"n_cols":15,"rows_kept":121,"merged":[[7,1,7,4],[8,1,8,3],[11,7,11,8],[11,12,11,13],[28,6,28,7],[28,8,28,9],[46,6,46,7],[46,8,46,9],[64,6,64,7],[64,8,64,9],[82,6,82,7],[82,8,82,9],[100,6,100,7],[100,8,100,9],[118,6,118,7],[118,8,118,9]]}
[null,"Resulting S73 Calculation"]
[]
[null,"Which rule applies?",{"$nulls":10},"Application O"]
[{"$nulls":3},"Gross Liability","Relief Value"]
[null,"Liability - Application A",null,{"$f":"'Application A'!C84","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!C85+'Application A'!C78","v":{"v":0,"d":"£0.00"}},{"$nulls":7},"Application A"]
[null,"Liability - Application B (Notional)",null,{"$f":"'Application B'!C84","v":{"v":0,"d":"£0.00"}},{"$f":"'Application B'!C85+'Application B'!C78","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":6},"Which Schedule 1 paragraph applies?",null,null,{"$f":"IF((D6-E6)=(D5-E5),3,IF((D6-E6)>(D5-E5),4,5))","v":3},null,null,"Application B"]
[null,{"$f":"IF((D6-E6)=(D5-E5),\"Liability has stayed the same\",IF((D6-E6)>(D5-E5),\"Liability has increased\",\"Liability has descreased\"))","v":"Liability has stayed the same"},{"$nulls":4},"Are we using values from Application O?",null,null,{"$f":"IF(AND('Application A'!F1=\"Section 73\",J7=5),TRUE,FALSE)","v":false}]
[{"$nulls":12},"Instructions"]
[null,"Chargeable Amount Formula",null,{"$f":"IF((D6-E6)=(D5-E5),\"As per P 3(1)a\",\"(X-Y)+Z\")","v":"As per P 3(1)a"}]
[null,"Relief Formula",null,{"$f":"IF(D6=D5,\"As per P 3(1)a\",\"(Rx-Ry)+Rz\")","v":"As per P 3(1)a"}]
[{"$nulls":7},"Liability Workings",{"$nulls":4},"Relief Workings"]
[null,{"$f":"'Application A'!B12","v":"Use 1"},{"$nulls":4},"Which Rule?","Increase","Decrease","Decrease",null,"Which Rule?","Increase","Decrease","Decrease"]
[null,null,"App","Liability ","Relief ",{"$nulls":3},"2 Apps","> 2 Apps",{"$nulls":3},"2 Apps","> 2 Apps"]
[null,"Area for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"B\",\"B\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H15,IF($J$8=FALSE,I15,J15)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M15,IF($J$8=FALSE,N15,O15)))","v":""},null,"X Area",{"$f":"'Application B'!$C$17","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C15-IF(AND('Application B'!$F19='Terms of Use'!$C$14,'Application B'!$C16<>'Application A'!$C16),'Application A'!C16, 'Application B'!C16)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!C15/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C15-IF(AND('Application B'!$F19='Terms of Use'!$C$14,'Application B'!$C16<>'Application O'!$C16),'Application O'!C16, 'Application B'!C16)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!C15/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Rx Area",{"$f":"'Application B'!$F$16","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F14-IF(AND('Application B'!$F19='Terms of Use'!$C$14,'Application B'!$F15<>'Application A'!$F15),'Application A'!F15, 'Application B'!F15)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!F14/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F14-IF(AND('Application B'!$F19='Terms of Use'!$C$14,'Application B'!$F15<>'Application O'!$F15),'Application O'!F15, 'Application B'!F15)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!F14/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X Rate",{"$f":"'Application B'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C14","v":{"v":0,"d":"£0.00"}},null,"Rx Rate",{"$f":"'Application B'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$14","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H17,IF($J$8=FALSE,I17,J17)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M17,IF($J$8=FALSE,N17,O17)))","v":""},null,"X IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Rx IP",{"$f":"'Application B'!C5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Rx IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for X",null,"","",null,"X TOTAL",{"$f":"ROUND(IF(Instructions!B$2=\"\",H16*H15*H17/IF(H18=0,1,H18),H16*H15*ROUND(H17/IF(H18=0,1,H18),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!B$2=\"\",I16*I15*I17/IF(I18=0,1,I18),I16*I15*ROUND(I17/IF(I18=0,1,I18),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J16*J15*J17/IF(J18=0,1,J18),J16*J15*ROUND(J17/IF(J18=0,1,J18),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Rx TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M16*M15*M17/IF(M18=0,1,M18),M16*M15*ROUND(M17/IF(M18=0,1,M18),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N16*N15*N17/IF(N18=0,1,N18),N16*N15*ROUND(N17/IF(N18=0,1,N18),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O16*O15*O17/IF(O18=0,1,O18),O16*O15*ROUND(O17/IF(O18=0,1,O18),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Area for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"A\",IF($J$8=FALSE,\"A\",\"A\")))","v":"N/A"},"","",null,"Y Area",{"$f":"'Application A'!C15-IF(AND('Application B'!$F19='Terms of Use'!$C$14,'Application B'!$C16<>'Application A'!$C16),'Application B'!C16, 'Application A'!C16)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!C15/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$C$17","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!C15-IF(AND('Application A'!$F19='Terms of Use'!$C$14,'Application O'!$C16<>'Application A'!$C16),'Application O'!C16, 'Application A'!C16)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application O'!$C$8<>'Application A'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!C15/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Ry Area",{"$f":"'Application A'!F14-IF(AND('Application B'!$F19='Terms of Use'!$C$14,'Application B'!$F15<>'Application A'!$F15),'Application B'!F15, 'Application A'!F15)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!F14/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$F$16","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!F14-IF(AND('Application A'!$F19='Terms of Use'!$C$14,'Application A'!$F15<>'Application O'!$F15),'Application O'!F15, 'Application A'!F15)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application A'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!F14/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y Rate",{"$f":"'Application B'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$14","v":{"v":0,"d":"£0.00"}},null,"Ry Rate",{"$f":"'Application B'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$14","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$14","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H22,IF($J$8=FALSE,I22,J22)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M22,IF($J$8=FALSE,N22,O22)))","v":""},null,"Y IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Ry IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Ry IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for Y",null,"","",null,"Y TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",H21*H20*H22/IF(H23=0,1,H23),H21*H20*ROUND(H22/IF(H23=0,1,H23),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",I21*I20*I22/IF(I23=0,1,I23),I21*I20*ROUND(I22/IF(I23=0,1,I23),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J21*J20*J22/IF(J23=0,1,J23),J21*J20*ROUND(J22/IF(J23=0,1,J23),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Ry TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M21*M20*M22/IF(M23=0,1,M23),M21*M20*ROUND(M22/IF(M23=0,1,M23),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N21*N20*N22/IF(N23=0,1,N23),N21*N20*ROUND(N22/IF(N23=0,1,N23),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O21*O20*O22/IF(O23=0,1,O23),O21*O20*ROUND(O22/IF(O23=0,1,O23),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Total for Z",null,{"$f":"IF($J$7=3,H25,IF($J$7=4,H25,IF($J$8=FALSE,I25,J25)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M25,IF($J$7=4,M25,IF($J$8=FALSE,N25,O25)))","v":{"v":0,"d":"£0.00"}},null,"Z TOTAL",{"$f":"'Application A'!$C$21","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$21","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$21","v":{"v":0,"d":"£0.00"}},null,"Rz TOTAL",{"$f":"'Application A'!$F$21","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$21","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$21","v":{"v":0,"d":"£0.00"}}]
[null,"Add any other relief amount",null,null,{"v":0,"d":"£0.00"}]
[null,{"$f":"IF($D$10=\"As per P 1\",\"Chargeable Amount of A\",$D$10)","v":"As per P 3(1)a"},null,{"$f":"IF($J$7=3,H25,IF($J$7=4,H27,IF($J$8=FALSE,I27,J27)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M25, IF($J$7=4,M27,IF($J$8=FALSE,N27,O27)))+E26","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$10","v":"As per P 3(1)a"},{"$f":"(H19-H24)+H25","v":{"v":0,"d":"£0.00"}},{"$f":"(I19-I24)+I25","v":{"v":0,"d":"£0.00"}},{"$f":"(J19-J24)+J25","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$11","v":"As per P 3(1)a"},{"$f":"(M19-M24)+M25","v":{"v":0,"d":"£0.00"}},{"$f":"(N19-N24)+N25","v":{"v":0,"d":"£0.00"}},{"$f":"(O19-O24)+O25","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"CONCATENATE('Application A'!B12,\" Liability After Relief\")","v":"Use 1 Liability After Relief"},null,{"$f":"D27-E27","v":{"v":0,"d":"£0.00"}},null,null,"Use 1 S73 Data Import String:",null,{"$f":"CONCATENATE(\"START\",\":\",E26,\":\",D18,\":\",D17,\":\",D15,\":\",E15,\":\",D16,\":\",D23,\":\",D22,\":\",D20,\":\",E20,\":\",D21,\":\",D25,\":\",E25,\":\",\"END\")","v":"START:0:::::::::::0:0:END"}]
[]
[null,{"$f":"'Application A'!B23","v":"Use 2"},{"$nulls":4},"Which Rule?","Increase","Decrease","Decrease",null,"Which Rule?","Increase","Decrease","Decrease"]
[null,null,"App","Liability","Relief",{"$nulls":3},"2 Apps","> 2 Apps",{"$nulls":3},"2 Apps","> 2 Apps"]
[null,"Area for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"B\",\"B\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H33,IF($J$8=FALSE,I33,J33)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M33,IF($J$8=FALSE,N33,O33)))","v":""},null,"X Area",{"$f":"'Application B'!$C$28","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C26-IF(AND('Application B'!$F30='Terms of Use'!$C$14,'Application B'!$C27<>'Application A'!$C27),'Application A'!C27, 'Application B'!C27)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!C26/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C26-IF(AND('Application B'!$F30='Terms of Use'!$C$14,'Application B'!$C27<>'Application O'!$C25),'Application O'!C25, 'Application B'!C27)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!C26/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Rx Area",{"$f":"'Application B'!$F$27","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F25-IF(AND('Application B'!$F30='Terms of Use'!$C$14,'Application B'!$F26<>'Application A'!$F26),'Application A'!F26, 'Application B'!F26)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!F25/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F25-IF(AND('Application B'!$F30='Terms of Use'!$C$14,'Application B'!$F26<>'Application O'!$F24),'Application O'!F24, 'Application B'!F26)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!F25/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X Rate",{"$f":"'Application B'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$23","v":{"v":0,"d":"£0.00"}},null,"Rx Rate",{"$f":"'Application B'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$23","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H35,IF($J$8=FALSE,I35,J35)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M35,IF($J$8=FALSE,N35,O35)))","v":""},null,"X IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Rx IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Rx IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for X",null,"","",null,"X TOTAL",{"$f":"ROUND(IF(Instructions!B$2=\"\",H34*H33*H35/IF(H36=0,1,H36),H34*H33*ROUND(H35/IF(H36=0,1,H36),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!B$2=\"\",I34*I33*I35/IF(I36=0,1,I36),I34*I33*ROUND(I35/IF(I36=0,1,I36),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J34*J33*J35/IF(J36=0,1,J36),J34*J33*ROUND(J35/IF(J36=0,1,J36),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Rx TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M34*M33*M35/IF(M36=0,1,M36),M34*M33*ROUND(M35/IF(M36=0,1,M36),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N34*N33*N35/IF(N36=0,1,N36),N34*N33*ROUND(N35/IF(N36=0,1,N36),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O34*O33*O35/IF(O36=0,1,O36),O34*O33*ROUND(O35/IF(O36=0,1,O36),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Area for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"A\",IF($J$8=FALSE,\"A\",\"A\")))","v":"N/A"},"","",null,"Y Area",{"$f":"'Application A'!C26-IF(AND('Application B'!$F30='Terms of Use'!$C$14,'Application B'!$C27<>'Application A'!$C27),'Application B'!C27, 'Application A'!C27)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!C26/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$C$28","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!C26-IF(AND('Application A'!$F30='Terms of Use'!$C$14,'Application O'!$C25<>'Application A'!$C27),'Application O'!C25, 'Application A'!C27)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application O'!$C$8<>'Application A'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!C26/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Ry Area",{"$f":"'Application A'!F25-IF(AND('Application B'!$F30='Terms of Use'!$C$14,'Application B'!$F26<>'Application A'!$F26),'Application B'!F26, 'Application A'!F26)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!F25/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$F$27","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!F25-IF(AND('Application A'!$F30='Terms of Use'!$C$14,'Application A'!$F26<>'Application O'!$F24),'Application O'!F24, 'Application A'!F26)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application A'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!F25/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y Rate",{"$f":"'Application B'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$23","v":{"v":0,"d":"£0.00"}},null,"Ry Rate",{"$f":"'Application B'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$25","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$23","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H40,IF($J$8=FALSE,I40,J40)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M40,IF($J$8=FALSE,N40,O40)))","v":""},null,"Y IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Ry IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Ry IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for Y",null,"","",null,"Y TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",H39*H38*H40/IF(H41=0,1,H41),H39*H38*ROUND(H40/IF(H41=0,1,H41),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",I39*I38*I40/IF(I41=0,1,I41),I39*I38*ROUND(I40/IF(I41=0,1,I41),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J39*J38*J40/IF(J41=0,1,J41),J39*J38*ROUND(J40/IF(J41=0,1,J41),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Ry TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M39*M38*M40/IF(M41=0,1,M41),M39*M38*ROUND(M40/IF(M41=0,1,M41),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N39*N38*N40/IF(N41=0,1,N41),N39*N38*ROUND(N40/IF(N41=0,1,N41),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O39*O38*O40/IF(O41=0,1,O41),O39*O38*ROUND(O40/IF(O41=0,1,O41),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Total for Z",null,{"$f":"IF($J$7=3,H43,IF($J$7=4,H43,IF($J$8=FALSE,I43,J43)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M43,IF($J$7=4,M43,IF($J$8=FALSE,N43,O43)))","v":{"v":0,"d":"£0.00"}},null,"Z TOTAL",{"$f":"'Application A'!$C$32","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$32","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$32","v":{"v":0,"d":"£0.00"}},null,"Rz TOTAL",{"$f":"'Application A'!$F$32","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$32","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$32","v":{"v":0,"d":"£0.00"}}]
[null,"Add any other relief amount",null,null,{"v":0,"d":"£0.00"}]
[null,{"$f":"IF($D$10=\"As per P 1\",\"Chargeable Amount of A\",$D$10)","v":"As per P 3(1)a"},null,{"$f":"IF($J$7=3,H43,IF($J$7=4,H45,IF($J$8=FALSE,I45,J45)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M43, IF($J$7=4,M45,IF($J$8=FALSE,N45,O45)))+E44","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$10","v":"As per P 3(1)a"},{"$f":"(H37-H42)+H43","v":{"v":0,"d":"£0.00"}},{"$f":"(I37-I42)+I43","v":{"v":0,"d":"£0.00"}},{"$f":"(J37-J42)+J43","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$11","v":"As per P 3(1)a"},{"$f":"(M37-M42)+M43","v":{"v":0,"d":"£0.00"}},{"$f":"(N37-N42)+N43","v":{"v":0,"d":"£0.00"}},{"$f":"(O37-O42)+O43","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"CONCATENATE('Application A'!B23,\" Liability After Relief\")","v":"Use 2 Liability After Relief"},null,{"$f":"D45-E45","v":{"v":0,"d":"£0.00"}},null,null,"Use 2 S73 Data Import String:",null,{"$f":"CONCATENATE(\"START\",\":\",E44,\":\",D36,\":\",D35,\":\",D33,\":\",E33,\":\",D34,\":\",D41,\":\",D40,\":\",D38,\":\",E38,\":\",D39,\":\",D43,\":\",E43,\":\",\"END\")","v":"START:0:::::::::::0:0:END"},null,"Created by Ralph Taylor"]
[]
[null,{"$f":"'Application A'!B34","v":"Use 3"},{"$nulls":4},"Which Rule?","Increase","Decrease","Decrease",null,"Which Rule?","Increase","Decrease","Decrease"]
[null,null,"App","Liability","Relief",{"$nulls":3},"2 Apps","> 2 Apps",{"$nulls":3},"2 Apps","> 2 Apps"]
[null,"Area for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"B\",\"B\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H51,IF($J$8=FALSE,I51,J51)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M51,IF($J$8=FALSE,N51,O51)))","v":""},null,"X Area",{"$f":"'Application B'!$C$39","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C37-IF(AND('Application B'!$F41='Terms of Use'!$C$14,'Application B'!$C38<>'Application A'!$C38),'Application A'!C38, 'Application B'!C38)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!C37/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C37-IF(AND('Application B'!$F41='Terms of Use'!$C$14,'Application B'!$C38<>'Application O'!$C34),'Application O'!C34, 'Application B'!C38)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!C37/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Rx Area",{"$f":"'Application B'!$F$38","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F36-IF(AND('Application B'!$F41='Terms of Use'!$C$14,'Application B'!$F37<>'Application A'!$F37),'Application A'!F37, 'Application B'!F37)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!F36/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F36-IF(AND('Application B'!$F41='Terms of Use'!$C$14,'Application B'!$F37<>'Application O'!$F33),'Application O'!F33, 'Application B'!F37)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!F36/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X Rate",{"$f":"'Application B'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$32","v":{"v":0,"d":"£0.00"}},null,"Rx Rate",{"$f":"'Application B'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$32","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H53,IF($J$8=FALSE,I53,J53)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M53,IF($J$8=FALSE,N53,O53)))","v":""},null,"X IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Rx IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Rx IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for X",null,"","",null,"X TOTAL",{"$f":"ROUND(IF(Instructions!B$2=\"\",H52*H51*H53/IF(H54=0,1,H54),H52*H51*ROUND(H53/IF(H54=0,1,H54),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!B$2=\"\",I52*I51*I53/IF(I54=0,1,I54),I52*I51*ROUND(I53/IF(I54=0,1,I54),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J52*J51*J53/IF(J54=0,1,J54),J52*J51*ROUND(J53/IF(J54=0,1,J54),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Rx TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M52*M51*M53/IF(M54=0,1,M54),M52*M51*ROUND(M53/IF(M54=0,1,M54),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N52*N51*N53/IF(N54=0,1,N54),N52*N51*ROUND(N53/IF(N54=0,1,N54),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O52*O51*O53/IF(O54=0,1,O54),O52*O51*ROUND(O53/IF(O54=0,1,O54),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Area for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"A\",IF($J$8=FALSE,\"A\",\"A\")))","v":"N/A"},"","",null,"Y Area",{"$f":"'Application A'!C37-IF(AND('Application B'!$F41='Terms of Use'!$C$14,'Application B'!$C38<>'Application A'!$C38),'Application B'!C38, 'Application A'!C38)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!C37/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$C$39","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!C37-IF(AND('Application A'!$F41='Terms of Use'!$C$14,'Application O'!$C34<>'Application A'!$C38),'Application O'!C34, 'Application A'!C38)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application O'!$C$8<>'Application A'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!C37/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Ry Area",{"$f":"'Application A'!F36-IF(AND('Application B'!$F41='Terms of Use'!$C$14,'Application B'!$F37<>'Application A'!$F37),'Application B'!F37, 'Application A'!F37)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!F36/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$F$38","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!F36-IF(AND('Application A'!$F41='Terms of Use'!$C$14,'Application A'!$F37<>'Application O'!$F33),'Application O'!F33, 'Application A'!F37)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application A'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!F36/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y Rate",{"$f":"'Application B'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$32","v":{"v":0,"d":"£0.00"}},null,"Ry Rate",{"$f":"'Application B'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$36","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$32","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H58,IF($J$8=FALSE,I58,J58)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M58,IF($J$8=FALSE,N58,O58)))","v":""},null,"Y IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Ry IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Ry IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for Y",null,"","",null,"Y TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",H57*H56*H58/IF(H59=0,1,H59),H57*H56*ROUND(H58/IF(H59=0,1,H59),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",I57*I56*I58/IF(I59=0,1,I59),I57*I56*ROUND(I58/IF(I59=0,1,I59),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J57*J56*J58/IF(J59=0,1,J59),J57*J56*ROUND(J58/IF(J59=0,1,J59),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Ry TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M57*M56*M58/IF(M59=0,1,M59),M57*M56*ROUND(M58/IF(M59=0,1,M59),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N57*N56*N58/IF(N59=0,1,N59),N57*N56*ROUND(N58/IF(N59=0,1,N59),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O57*O56*O58/IF(O59=0,1,O59),O57*O56*ROUND(O58/IF(O59=0,1,O59),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Total for Z",null,{"$f":"IF($J$7=3,H61,IF($J$7=4,H61,IF($J$8=FALSE,I61,J61)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M61,IF($J$7=4,M61,IF($J$8=FALSE,N61,O61)))","v":{"v":0,"d":"£0.00"}},null,"Z TOTAL",{"$f":"'Application A'!$C$43","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$43","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$43","v":{"v":0,"d":"£0.00"}},null,"Rz TOTAL",{"$f":"'Application A'!$F$43","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$43","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$43","v":{"v":0,"d":"£0.00"}}]
[null,"Add any other relief amount",null,null,{"v":0,"d":"£0.00"}]
[null,{"$f":"IF($D$10=\"As per P 1\",\"Chargeable Amount of A\",$D$10)","v":"As per P 3(1)a"},null,{"$f":"IF($J$7=3,H61,IF($J$7=4,H63,IF($J$8=FALSE,I63,J63)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M61, IF($J$7=4,M63,IF($J$8=FALSE,N63,O63)))+E62","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$10","v":"As per P 3(1)a"},{"$f":"(H55-H60)+H61","v":{"v":0,"d":"£0.00"}},{"$f":"(I55-I60)+I61","v":{"v":0,"d":"£0.00"}},{"$f":"(J55-J60)+J61","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$11","v":"As per P 3(1)a"},{"$f":"(M55-M60)+M61","v":{"v":0,"d":"£0.00"}},{"$f":"(N55-N60)+N61","v":{"v":0,"d":"£0.00"}},{"$f":"(O55-O60)+O61","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"CONCATENATE('Application A'!B34,\" Liability After Relief\")","v":"Use 3 Liability After Relief"},null,{"$f":"D63-E63","v":{"v":0,"d":"£0.00"}},null,null,"Use 3 S73 Data Import String:",null,{"$f":"CONCATENATE(\"START\",\":\",E62,\":\",D54,\":\",D53,\":\",D51,\":\",E51,\":\",D52,\":\",D59,\":\",D58,\":\",D56,\":\",E56,\":\",D57,\":\",D61,\":\",E61,\":\",\"END\")","v":"START:0:::::::::::0:0:END"}]
[]
[null,{"$f":"'Application A'!B45","v":"Use 4"},{"$nulls":4},"Which Rule?","Increase","Decrease","Decrease",null,"Which Rule?","Increase","Decrease","Decrease"]
[null,null,"App","Liability ","Relief ",{"$nulls":3},"2 Apps","> 2 Apps",{"$nulls":3},"2 Apps","> 2 Apps"]
[null,"Area for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"B\",\"B\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H69,IF($J$8=FALSE,I69,J69)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M69,IF($J$8=FALSE,N69,O69)))","v":""},null,"X Area",{"$f":"'Application B'!$C$50","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C48-IF(AND('Application B'!$F52='Terms of Use'!$C$14,'Application B'!$C49<>'Application A'!$C49),'Application A'!C49, 'Application B'!C49)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!C48/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C48-IF(AND('Application B'!$F52='Terms of Use'!$C$14,'Application B'!$C49<>'Application O'!$C43),'Application O'!C43, 'Application B'!C49)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!C48/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Rx Area",{"$f":"'Application B'!$F$49","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F47-IF(AND('Application B'!$F52='Terms of Use'!$C$14,'Application B'!$F48<>'Application A'!$F48),'Application A'!F48, 'Application B'!F48)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!F47/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F47-IF(AND('Application B'!$F52='Terms of Use'!$C$14,'Application B'!$F48<>'Application O'!$F42),'Application O'!F42, 'Application B'!F48)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!F47/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X Rate",{"$f":"'Application B'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$41","v":{"v":0,"d":"£0.00"}},null,"Rx Rate",{"$f":"'Application B'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$41","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H71,IF($J$8=FALSE,I71,J71)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M71,IF($J$8=FALSE,N71,O71)))","v":""},null,"X IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Rx IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H72,IF($J$8=FALSE,I72,J72)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M72,IF($J$8=FALSE,N72,O72)))","v":""},null,"X IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Rx IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for X",null,"","",null,"X TOTAL",{"$f":"ROUND(IF(Instructions!B$2=\"\",H70*H69*H71/IF(H72=0,1,H72),H70*H69*ROUND(H71/IF(H72=0,1,H72),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!B$2=\"\",I70*I69*I71/IF(I72=0,1,I72),I70*I69*ROUND(I71/IF(I72=0,1,I72),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J70*J69*J71/IF(J72=0,1,J72),J70*J69*ROUND(J71/IF(J72=0,1,J72),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Rx TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M70*M69*M71/IF(M72=0,1,M72),M70*M69*ROUND(M71/IF(M72=0,1,M72),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N70*N69*N71/IF(N72=0,1,N72),N70*N69*ROUND(N71/IF(N72=0,1,N72),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O70*O69*O71/IF(O72=0,1,O72),O70*O69*ROUND(O71/IF(O72=0,1,O72),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Area for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"A\",IF($J$8=FALSE,\"A\",\"A\")))","v":"N/A"},"","",null,"Y Area",{"$f":"'Application A'!C48-IF(AND('Application B'!$F52='Terms of Use'!$C$14,'Application B'!$C49<>'Application A'!$C49),'Application B'!C49, 'Application A'!C49)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!C48/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$C$50","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!C48-IF(AND('Application A'!$F52='Terms of Use'!$C$14,'Application O'!$C43<>'Application A'!$C49),'Application O'!C43, 'Application A'!C49)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application O'!$C$8<>'Application A'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!C48/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Ry Area",{"$f":"'Application A'!F47-IF(AND('Application B'!$F52='Terms of Use'!$C$14,'Application B'!$F48<>'Application A'!$F48),'Application B'!F48, 'Application A'!F48)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!F47/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$F$49","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!F47-IF(AND('Application A'!$F52='Terms of Use'!$C$14,'Application A'!$F48<>'Application O'!$F42),'Application O'!F42, 'Application A'!F37)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application A'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!F36/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y Rate",{"$f":"'Application B'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$41","v":{"v":0,"d":"£0.00"}},null,"Ry Rate",{"$f":"'Application B'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$47","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$41","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H76,IF($J$8=FALSE,I76,J76)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M76,IF($J$8=FALSE,N76,O76)))","v":""},null,"Y IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Ry IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H77,IF($J$8=FALSE,I77,J77)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M77,IF($J$8=FALSE,N77,O77)))","v":""},null,"Y IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Ry IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for Y",null,"","",null,"Y TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",H75*H74*H76/IF(H77=0,1,H77),H75*H74*ROUND(H76/IF(H77=0,1,H77),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",I75*I74*I76/IF(I77=0,1,I77),I75*I74*ROUND(I76/IF(I77=0,1,I77),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J75*J74*J76/IF(J77=0,1,J77),J75*J74*ROUND(J76/IF(J77=0,1,J77),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Ry TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M75*M74*M76/IF(M77=0,1,M77),M75*M74*ROUND(M76/IF(M77=0,1,M77),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N75*N74*N76/IF(N77=0,1,N77),N75*N74*ROUND(N76/IF(N77=0,1,N77),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O75*O74*O76/IF(O77=0,1,O77),O75*O74*ROUND(O76/IF(O77=0,1,O77),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Total for Z",null,{"$f":"IF($J$7=3,H79,IF($J$7=4,H79,IF($J$8=FALSE,I79,J79)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M79,IF($J$7=4,M79,IF($J$8=FALSE,N79,O79)))","v":{"v":0,"d":"£0.00"}},null,"Z TOTAL",{"$f":"'Application A'!$C$54","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$54","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$54","v":{"v":0,"d":"£0.00"}},null,"Rz TOTAL",{"$f":"'Application A'!$F$54","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$54","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$54","v":{"v":0,"d":"£0.00"}}]
[null,"Add any other relief amount",null,null,{"v":0,"d":"£0.00"}]
[null,{"$f":"IF($D$10=\"As per P 1\",\"Chargeable Amount of A\",$D$10)","v":"As per P 3(1)a"},null,{"$f":"IF($J$7=3,H79,IF($J$7=4,H81,IF($J$8=FALSE,I81,J81)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M79, IF($J$7=4,M81,IF($J$8=FALSE,N81,O81)))+E80","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$10","v":"As per P 3(1)a"},{"$f":"(H73-H78)+H79","v":{"v":0,"d":"£0.00"}},{"$f":"(I73-I78)+I79","v":{"v":0,"d":"£0.00"}},{"$f":"(J73-J78)+J79","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$11","v":"As per P 3(1)a"},{"$f":"(M73-M78)+M79","v":{"v":0,"d":"£0.00"}},{"$f":"(N73-N78)+N79","v":{"v":0,"d":"£0.00"}},{"$f":"(O73-O78)+O79","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"CONCATENATE('Application A'!B66,\" Liability After Relief\")","v":" Liability After Relief"},null,{"$f":"D81-E81","v":{"v":0,"d":"£0.00"}},null,null,"Use 4 S73 Data Import String:",null,{"$f":"CONCATENATE(\"START\",\":\",E80,\":\",D72,\":\",D71,\":\",D69,\":\",E69,\":\",D70,\":\",D77,\":\",D76,\":\",D74,\":\",E74,\":\",D75,\":\",D79,\":\",E79,\":\",\"END\")","v":"START:0:::::::::::0:0:END"}]
[]
[null,{"$f":"'Application A'!B56","v":"Use 5"},{"$nulls":4},"Which Rule?","Increase","Decrease","Decrease",null,"Which Rule?","Increase","Decrease","Decrease"]
[null,null,"App","Liability","Relief",{"$nulls":3},"2 Apps","> 2 Apps",{"$nulls":3},"2 Apps","> 2 Apps"]
[null,"Area for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"B\",\"B\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H87,IF($J$8=FALSE,I87,J87)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M87,IF($J$8=FALSE,N87,O87)))","v":""},null,"X Area",{"$f":"'Application B'!$C$61","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C59-IF(AND('Application B'!$F63='Terms of Use'!$C$14,'Application B'!$C60<>'Application A'!$C60),'Application A'!C60, 'Application B'!C60)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!C59/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C59-IF(AND('Application B'!$F63='Terms of Use'!$C$14,'Application B'!$C60<>'Application O'!$C52),'Application O'!C52, 'Application B'!C60)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!C59/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Rx Area",{"$f":"'Application B'!$F$60","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F58-IF(AND('Application B'!$F63='Terms of Use'!$C$14,'Application B'!$F59<>'Application A'!$F59),'Application A'!F59, 'Application B'!F59)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!F58/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F58-IF(AND('Application B'!$F63='Terms of Use'!$C$14,'Application B'!$F59<>'Application O'!$F51),'Application O'!F51, 'Application B'!F59)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!F69/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X Rate",{"$f":"'Application B'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$50","v":{"v":0,"d":"£0.00"}},null,"Rx Rate",{"$f":"'Application B'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$50","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H89,IF($J$8=FALSE,I89,J89)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M89,IF($J$8=FALSE,N89,O89)))","v":""},null,"X IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Rx IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H90,IF($J$8=FALSE,I90,J90)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M90,IF($J$8=FALSE,N90,O90)))","v":""},null,"X IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Rx IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for X",null,"","",null,"X TOTAL",{"$f":"ROUND(IF(Instructions!B$2=\"\",H88*H87*H89/IF(H90=0,1,H90),H88*H87*ROUND(H89/IF(H90=0,1,H90),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!B$2=\"\",I88*I87*I89/IF(I90=0,1,I90),I88*I87*ROUND(I89/IF(I90=0,1,I90),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J88*J87*J89/IF(J90=0,1,J90),J88*J87*ROUND(J89/IF(J90=0,1,J90),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Rx TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M88*M87*M89/IF(M90=0,1,M90),M88*M87*ROUND(M89/IF(M90=0,1,M90),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N88*N87*N89/IF(N90=0,1,N90),N88*N87*ROUND(N89/IF(N90=0,1,N90),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O88*O87*O89/IF(O90=0,1,O90),O88*O87*ROUND(O89/IF(O90=0,1,O90),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Area for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"A\",IF($J$8=FALSE,\"A\",\"A\")))","v":"N/A"},"","",null,"Y Area",{"$f":"'Application A'!C59-IF(AND('Application B'!$F63='Terms of Use'!$C$14,'Application B'!$C60<>'Application A'!$C60),'Application B'!C60, 'Application A'!C60)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!C59/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$C$61","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!C59-IF(AND('Application A'!$F63='Terms of Use'!$C$14,'Application O'!$C52<>'Application A'!$C60),'Application O'!C52, 'Application A'!C60)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application O'!$C$8<>'Application A'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!C59/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Ry Area",{"$f":"'Application A'!F58-IF(AND('Application B'!$F63='Terms of Use'!$C$14,'Application B'!$F59<>'Application A'!$F59),'Application B'!F59, 'Application A'!F59)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!F58/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$F$60","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!F58-IF(AND('Application A'!$F63='Terms of Use'!$C$14,'Application A'!$F59<>'Application O'!$F51),'Application O'!F51, 'Application A'!F37)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application A'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!F36/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y Rate",{"$f":"'Application B'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$50","v":{"v":0,"d":"£0.00"}},null,"Ry Rate",{"$f":"'Application B'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$58","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$50","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H94,IF($J$8=FALSE,I94,J94)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M94,IF($J$8=FALSE,N94,O94)))","v":""},null,"Y IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Ry IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H95,IF($J$8=FALSE,I95,J95)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M95,IF($J$8=FALSE,N95,O95)))","v":""},null,"Y IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Ry IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for Y",null,"","",null,"Y TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",H93*H92*H94/IF(H95=0,1,H95),H93*H92*ROUND(H94/IF(H95=0,1,H95),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",I93*I92*I94/IF(I95=0,1,I95),I93*I92*ROUND(I94/IF(I95=0,1,I95),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J93*J92*J94/IF(J95=0,1,J95),J93*J92*ROUND(J94/IF(J95=0,1,J95),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Ry TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M93*M92*M94/IF(M95=0,1,M95),M93*M92*ROUND(M94/IF(M95=0,1,M95),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N93*N92*N94/IF(N95=0,1,N95),N93*N92*ROUND(N94/IF(N95=0,1,N95),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O93*O92*O94/IF(O95=0,1,O95),O93*O92*ROUND(O94/IF(O95=0,1,O95),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Total for Z",null,{"$f":"IF($J$7=3,H97,IF($J$7=4,H97,IF($J$8=FALSE,I97,J97)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M97,IF($J$7=4,M97,IF($J$8=FALSE,N97,O97)))","v":{"v":0,"d":"£0.00"}},null,"Z TOTAL",{"$f":"'Application A'!$C$65","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$65","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$65","v":{"v":0,"d":"£0.00"}},null,"Rz TOTAL",{"$f":"'Application A'!$F$65","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$65","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$65","v":{"v":0,"d":"£0.00"}}]
[null,"Add any other relief amount",null,null,{"v":0,"d":"£0.00"}]
[null,{"$f":"IF($D$10=\"As per P 1\",\"Chargeable Amount of A\",$D$10)","v":"As per P 3(1)a"},null,{"$f":"IF($J$7=3,H97,IF($J$7=4,H99,IF($J$8=FALSE,I99,J99)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M97, IF($J$7=4,M99,IF($J$8=FALSE,N99,O99)))+E98","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$10","v":"As per P 3(1)a"},{"$f":"(H91-H96)+H97","v":{"v":0,"d":"£0.00"}},{"$f":"(I91-I96)+I97","v":{"v":0,"d":"£0.00"}},{"$f":"(J91-J96)+J97","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$11","v":"As per P 3(1)a"},{"$f":"(M91-M96)+M97","v":{"v":0,"d":"£0.00"}},{"$f":"(N91-N96)+N97","v":{"v":0,"d":"£0.00"}},{"$f":"(O91-O96)+O97","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"CONCATENATE('Application A'!B77,\" Liability After Relief\")","v":" Liability After Relief"},null,{"$f":"D99-E99","v":{"v":0,"d":"£0.00"}},null,null,"Use 5 S73 Data Import String:",null,{"$f":"CONCATENATE(\"START\",\":\",E98,\":\",D90,\":\",D89,\":\",D87,\":\",E87,\":\",D88,\":\",D95,\":\",D94,\":\",D92,\":\",E92,\":\",D93,\":\",D97,\":\",E97,\":\",\"END\")","v":"START:0:::::::::::0:0:END"},null,"Created by Ralph Taylor"]
[]
[null,{"$f":"'Application A'!B67","v":"Use 6"},{"$nulls":4},"Which Rule?","Increase","Decrease","Decrease",null,"Which Rule?","Increase","Decrease","Decrease"]
[null,null,"App","Liability","Relief",{"$nulls":3},"2 Apps","> 2 Apps",{"$nulls":3},"2 Apps","> 2 Apps"]
[null,"Area for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"B\",\"B\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H105,IF($J$8=FALSE,I105,J105)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M105,IF($J$8=FALSE,N105,O105)))","v":""},null,"X Area",{"$f":"'Application B'!$C$72","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C70-IF(AND('Application B'!$F74='Terms of Use'!$C$14,'Application B'!$C71<>'Application A'!$C71),'Application A'!C71, 'Application B'!C71)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!C70/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!C70-IF(AND('Application B'!$F74='Terms of Use'!$C$14,'Application B'!$C71<>'Application O'!$C61),'Application O'!C61, 'Application B'!C71)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!C70/IF('Application B'!$F$84=0,1,'Application B'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Rx Area",{"$f":"'Application B'!$F$71","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F69-IF(AND('Application B'!$F74='Terms of Use'!$C$14,'Application B'!$F70<>'Application A'!$F70),'Application A'!F70, 'Application B'!F70)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application A'!$C$8,'Application B'!$C$8)*'Application B'!F69/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application B'!F69-IF(AND('Application B'!$F74='Terms of Use'!$C$14,'Application B'!$F70<>'Application O'!$F60),'Application O'!F60, 'Application B'!F70)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application B'!$C$8)*'Application B'!F69/(IF('Application B'!$F$84=0,1,'Application B'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"X Rate",{"$f":"'Application B'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$59","v":{"v":0,"d":"£0.00"}},null,"Rx Rate",{"$f":"'Application B'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$59","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H107,IF($J$8=FALSE,I107,J107)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M107,IF($J$8=FALSE,N107,O107)))","v":""},null,"X IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Rx IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for X",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H108,IF($J$8=FALSE,I108,J108)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M108,IF($J$8=FALSE,N108,O108)))","v":""},null,"X IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Rx IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for X",null,"","",null,"X TOTAL",{"$f":"ROUND(IF(Instructions!B$2=\"\",H106*H105*H107/IF(H108=0,1,H108),H106*H105*ROUND(H107/IF(H108=0,1,H108),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!B$2=\"\",I106*I105*I107/IF(I108=0,1,I108),I106*I105*ROUND(I107/IF(I108=0,1,I108),Instructions!B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J106*J105*J107/IF(J108=0,1,J108),J106*J105*ROUND(J107/IF(J108=0,1,J108),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Rx TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M106*M105*M107/IF(M108=0,1,M108),M106*M105*ROUND(M107/IF(M108=0,1,M108),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N106*N105*N107/IF(N108=0,1,N108),N106*N105*ROUND(N107/IF(N108=0,1,N108),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O106*O105*O107/IF(O108=0,1,O108),O106*O105*ROUND(O107/IF(O108=0,1,O108),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Area for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"A\",IF($J$8=FALSE,\"A\",\"A\")))","v":"N/A"},"","",null,"Y Area",{"$f":"'Application A'!C70-IF(AND('Application B'!$F74='Terms of Use'!$C$14,'Application B'!$C71<>'Application A'!$C71),'Application B'!C71, 'Application A'!C71)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!C70/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$C$72","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!C70-IF(AND('Application A'!$F74='Terms of Use'!$C$14,'Application O'!$C61<>'Application A'!$C71),'Application O'!C61, 'Application A'!C71)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application O'!$C$8<>'Application A'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!C70/IF('Application A'!$F$84=0,1,'Application A'!$F$84))","v":{"v":0,"d":"0.00"}},null,"Ry Area",{"$f":"'Application A'!F69-IF(AND('Application B'!$F74='Terms of Use'!$C$14,'Application B'!$F70<>'Application A'!$F70),'Application B'!F70, 'Application A'!F70)-(IF(AND('Application B'!$F$8='Terms of Use'!$C$14,'Application B'!$C$8<>'Application A'!$C$8), 'Application B'!$C$8,'Application A'!$C$8)*'Application A'!F69/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!$F$71","v":{"v":0,"d":"0.00"}},{"$f":"'Application A'!F69-IF(AND('Application A'!$F74='Terms of Use'!$C$14,'Application A'!$F70<>'Application O'!$F60),'Application O'!F60, 'Application A'!F37)-(IF(AND('Application A'!$F$8='Terms of Use'!$C$14,'Application A'!$C$8<>'Application O'!$C$8), 'Application O'!$C$8,'Application A'!$C$8)*'Application A'!F36/(IF('Application A'!$F$84=0,1,'Application A'!$F$84)))","v":{"v":0,"d":"0.00"}}]
[null,"Rate used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},"","",null,"Y Rate",{"$f":"'Application B'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$59","v":{"v":0,"d":"£0.00"}},null,"Ry Rate",{"$f":"'Application B'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$69","v":{"v":0,"d":"£0.00"}},{"$f":"'Application O'!$C$59","v":{"v":0,"d":"£0.00"}}]
[null,"IP used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H112,IF($J$8=FALSE,I112,J112)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M112,IF($J$8=FALSE,N112,O112)))","v":""},null,"Y IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0},null,"Ry IP",{"$f":"'Application B'!$C$5","v":0},{"$f":"'Application A'!$C$5","v":0},{"$f":"'Application O'!$C$5","v":0}]
[null,"IC used for Y",{"$f":"IF($J$7=3,\"N/A\",IF($J$7=4,\"B\",IF($J$8=FALSE,\"A\",\"O\")))","v":"N/A"},{"$f":"IF($J$7=3,\"\",IF($J$7=4,H113,IF($J$8=FALSE,I113,J113)))","v":""},{"$f":"IF($J$7=3,\"\",IF($J$7=4,M113,IF($J$8=FALSE,N113,O113)))","v":""},null,"Y IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0},null,"Ry IC",{"$f":"'Application B'!$C$6","v":0},{"$f":"'Application A'!$C$6","v":0},{"$f":"'Application O'!$C$6","v":0}]
[null,"Total for Y",null,"","",null,"Y TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",H111*H110*H112/IF(H113=0,1,H113),H111*H110*ROUND(H112/IF(H113=0,1,H113),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",I111*I110*I112/IF(I113=0,1,I113),I111*I110*ROUND(I112/IF(I113=0,1,I113),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",J111*J110*J112/IF(J113=0,1,J113),J111*J110*ROUND(J112/IF(J113=0,1,J113),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},null,"Ry TOTAL",{"$f":"ROUND(IF(Instructions!$B$2=\"\",M111*M110*M112/IF(M113=0,1,M113),M111*M110*ROUND(M112/IF(M113=0,1,M113),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",N111*N110*N112/IF(N113=0,1,N113),N111*N110*ROUND(N112/IF(N113=0,1,N113),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}},{"$f":"ROUND(IF(Instructions!$B$2=\"\",O111*O110*O112/IF(O113=0,1,O113),O111*O110*ROUND(O112/IF(O113=0,1,O113),Instructions!$B$2)),2)","v":{"v":0,"d":"£0.00"}}]
[null,"Total for Z",null,{"$f":"IF($J$7=3,H115,IF($J$7=4,H115,IF($J$8=FALSE,I115,J115)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M115,IF($J$7=4,M115,IF($J$8=FALSE,N115,O115)))","v":{"v":0,"d":"£0.00"}},null,"Z TOTAL",{"$f":"'Application A'!$C$76","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$76","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$C$76","v":{"v":0,"d":"£0.00"}},null,"Rz TOTAL",{"$f":"'Application A'!$F$76","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$76","v":{"v":0,"d":"£0.00"}},{"$f":"'Application A'!$F$76","v":{"v":0,"d":"£0.00"}}]
[null,"Add any other relief amount",null,null,{"v":0,"d":"£0.00"}]
[null,{"$f":"IF($D$10=\"As per P 1\",\"Chargeable Amount of A\",$D$10)","v":"As per P 3(1)a"},null,{"$f":"IF($J$7=3,H115,IF($J$7=4,H117,IF($J$8=FALSE,I117,J117)))","v":{"v":0,"d":"£0.00"}},{"$f":"IF($J$7=3,M115, IF($J$7=4,M117,IF($J$8=FALSE,N117,O117)))+E116","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$10","v":"As per P 3(1)a"},{"$f":"(H109-H114)+H115","v":{"v":0,"d":"£0.00"}},{"$f":"(I109-I114)+I115","v":{"v":0,"d":"£0.00"}},{"$f":"(J109-J114)+J115","v":{"v":0,"d":"£0.00"}},null,{"$f":"$D$11","v":"As per P 3(1)a"},{"$f":"(M109-M114)+M115","v":{"v":0,"d":"£0.00"}},{"$f":"(N109-N114)+N115","v":{"v":0,"d":"£0.00"}},{"$f":"(O109-O114)+O115","v":{"v":0,"d":"£0.00"}}]
[]
[null,{"$f":"CONCATENATE('Application A'!B88,\" Liability After Relief\")","v":" Liability After Relief"},null,{"$f":"D117-E117","v":{"v":0,"d":"£0.00"}},null,null,"Use 6 S73 Data Import String:",null,{"$f":"CONCATENATE(\"START\",\":\",E116,\":\",D108,\":\",D107,\":\",D105,\":\",E105,\":\",D106,\":\",D113,\":\",D112,\":\",D110,\":\",E110,\":\",D111,\":\",D115,\":\",E115,\":\",\"END\")","v":"START:0:::::::::::0:0:END"}]
[]
[null,"TOTAL LIABILITY",null,{"$f":"D29+D47+D65+D83+D101+D119","v":{"v":0,"d":"£0.00"}}]

{"sheet":"Terms of Use","index":5,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[3,0,3,4]]}
["These terms of use should accompany any copy of this workbook."]
[]
["Workbook Version",null,"1.11"]
["Workbook created following the September 2019 amendments"]
["The workbook is provided as is and includes no warranties. By using this you agree to using it at your own risk!"]
[]
["Return to",null,"Instructions"]
[]
[]
[null,null,"Original"]
[null,null,"Section 73"]
[null,null,"This App"]
[null,null,"Previous App"]
[null,null,"Fails \"In Use\" Rule"]
[null,null,"It just changed"]

{"sheet":"Change Log","index":6,"n_rows":15,"n_cols":6,"rows_kept":15}
["Change log"]
[{"$nulls":3},"Return to",null,"Instructions"]
[1.2,"First Live Version"]
[1.3,"Adjusted the handling of Demolition/Retained to add functionality to deal with those cases where the  six month in three year rule no longer applies because of the time lapse between the two permissions - P4 and Notional"]
[1.4,"Re-introduced \"Application O\" sheet (in place of a values box previously in \"Application A\") and better handling of Demolition in scenarios where it originally applied but no longer applied (particularly with Application O in Paragraph 5 scenarios). Formulas modified to accommodate and optimise various scenarios. Rounding removed from SQM area calculations. Buttons replace tabs and workbook locked down"]
[1.5,"Expanded the area components (X and Y Gross and Relief area) in the S73 Calculation sheet to include 14 decimal places to ease copying to the v312 Exacom system, which now accepts higher precision values"]
[1.6,"Visual changes to the totals at the bottom of Application A to remove ambiguity (no impact on any S73 calculation)"]
[1.7,"Modified workbook to extend from 3 to 6 uses. Changed \"Show cells with 0 in them\" to TRUE (previously hidden)"]
[1.7,"Added the ability to copy a string of data for each use from the summary page to import into the Exacom system (Exacom v313+ required to utilise this new feature)"]
[1.8,"Net Area's for Application O were being rounded. This affected the Net Area and therefore Notional Value within the O tab (but did not affect the resulting S73 calculation, as that is separate)"]
[1.9,"Improved compatibility with Office 2016"]
[{"v":1.1,"d":"1.10"},"The spreadsheet will now copy Z (Liability Notice) data for Paragraph 3 cases so that import strings can be generated for S73 applications where no increase in liability occurs."]
[null,"Improved Application B to report pre and post relief values in the same way as Application A (Totals at bottom of page)"]
[null,"Improved the Notional Totals box on the Calculations page to better mirror the data required for import into Exacom's authority totals area"]
[1.11,"Fixed a bug where Other Relief was not being accounted for correctly on the summary page"]