{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Home","input","batch","xxxbatch","xxx_process"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":16,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,15,16,16],[17,2,17,14],[17,15,17,16],[15,16,15,17],[10,2,10,17]]}
[null,"input"]
[]
[]
[null,null,"VAT number checker"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Enter your own VAT number to receive a consultation code for each check"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last updated:",null,"2023-01-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"} copyright"]
[null,null,"39-41 Bank Street § Ashford § Kent TN23 1DQ §",null,null,null,null,null,null,null,null,null,null,null,null,"} disclaimer"]

{"sheet":"input","index":1,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Home"]
["bhps","Input: VAT number checker",null,null,null,null,null,null,{"$f":"sanitise(I5)","v":""},null,null,null,null,null,null,"get a next button to check result - clear result as enter new i5"]
[]
[null,"VAT number",null,null,null,null,null,null,null,null,null,null,null,"country code hidden"]
[null,"Enter the UK VAT number here:",null,null,null,null,null,null,null,null,null,null,null,"GB"]
[]
[null,"Result",null,null,null,null,null,null,null,null,null,null,null,"check if valid - if so give button to check"]
[null,{"$f":"CONCATENATE(\"The number entered (\", TEXT(sanitise(I5),\"### #### ##\"),\") is:\")","v":"The number entered () is:"},null,null,null,null,null,null,{"$f":"+IF(check_VAT(sanitise(I5))=\"PASS\",\"VALID\",\"INVALID\")","v":"INVALID"},null,null,null,null,"if not remove details"]
[null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,"if change VAT number then clear details"]
[null,""]
[null,"Details"]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,"Name",null,null,null,{"$f":"xxx_process!B6","v":"INDICATOR - FL MEMO LIMITED"}]
[null,null,null,null,null,{"$f":"xxx_process!B6","v":"INDICATOR - FL MEMO LIMITED"}]
[null,"Address",null,null,null,{"$f":"xxx_process!B7","v":"CALGARTH HOUSE"},null,null,null,null,null,null,null,"autofit height"]
[null,null,null,null,null,{"$f":"xxx_process!B8","v":"39-41 BANK STREET"}]
[null,null,null,null,null,{"$f":"xxx_process!B9","v":"ASHFORD"}]
[null,null,null,null,null,{"$f":"xxx_process!B10","v":0}]
[null,null,null,null,null,{"$f":"xxx_process!B11","v":0}]
[null,null,null,null,null,{"$f":"xxx_process!B12","v":0}]
[null,"Postcode",null,null,null,{"$f":"xxx_process!B13","v":"TN23 1DQ"}]
[]
[null,"Date check performed",null,null,null,{"$f":"xxx_process!B20","v":"2023-01-16"}]
[null,"Consultation Number",null,null,null,{"$f":"xxx_process!B14","v":0}]
[null,"Your VAT number",null,null,null,{"$f":"IF(Home!N12<>\"\",Home!N12,\"0\")","v":"0"},null,null,null,null,null,null,null,null,{"$f":"+_xlfn.ENCODEURL(N5)","v":"GB"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+_xlfn.ENCODEURL(I5)","v":""}]

{"sheet":"batch","index":2,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Home","macro_BasicPOSTRequest_batch"]
["hnps","Input: VAT number checker",null,null,null,null,null,{"$f":"IF(Home!N12<>\"\",CONCATENATE(\"Your VAT number: \",Home!N12),\"\")","v":""}]
[]
[]
[null,null,"Enter the VAT numbers below then click the next button:"]
[]
[null,null,null,null,null,"Name","Address","Consultation code","Date"]
[]
[null,null,null,null,{"$f":"+check_VAT(C9)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C12)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C15)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C18)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C21)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C24)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C27)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C30)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C33)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C36)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C39)","v":"CHECK"}]
[]
[]
[null,null,null,null,{"$f":"+check_VAT(C42)","v":"CHECK"}]

{"sheet":"xxxbatch","index":3,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[726598394,{"$f":"+check_VAT(A3)","v":"PASS"},"INDICATOR - FL MEMO LIMITED ","CALGARTH HOUSE\r\n39-41 BANK STREET\r\nASHFORD\r\n\r\nTN23 1DQ ","2020-04-17"]
[123,{"$f":"+check_VAT(A4)","v":"CHECK"},"INDICATOR - FL MEMO LIMITED ","CALGARTH HOUSE\r\n39-41 BANK STREET\r\nASHFORD\r\n\r\nTN23 1DQ ","2020-04-16",null,null,null,null,null,null,"sub needs to clear this sheet"]
[726598394,"PASS","INDICATOR - FL MEMO LIMITED ","CALGARTH HOUSE\r\n39-41 BANK STREET\r\nASHFORD\r\n\r\nTN23 1DQ ","2020-04-17",null,null,null,null,null,null,"clear the row upon entering different in A"]
[null,"CHECK"]
[null,"CHECK"]
[null,"CHECK"]
[null,"CHECK",null,null,null,null,null,null,null,null,null,null,null,null,"use country code GB from input n5"]
[null,"CHECK"]
[null,"CHECK"]
[null,"CHECK"]
[null,"CHECK"]
[null,"CHECK"]
[null,"CHECK"]

{"sheet":"xxx_process","index":4,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Yes, valid VAT number ",null,null,null,null,null,null,null,null,null,"1,1"]
[]
["Member State","GB","countryCode",null,null,null,null,null,null,null,"3,1","3,2"]
["VAT Number",726598394,"vatNumber",null,null,null,null,null,null,null,"4,1","4,2"]
["Date when request received","2023-01-16T11:28:22+00:00","processingDate"]
["Name","INDICATOR - FL MEMO LIMITED","name",null,null,null,null,null,"name"]
["Address","CALGARTH HOUSE","line1",null,null,null,null,null,"line1"]
[null,"39-41 BANK STREET","line2",null,null,null,null,null,"line2"]
[null,"ASHFORD","line3",null,null,null,null,null,"line3"]
[null,null,"line4",null,null,null,null,null,"line4"]
[null,null,"line5",null,null,null,null,null,"line5"]
[null,null,"line6",null,null,null,null,null,"line6"]
[null,"TN23 1DQ","postcode",null,null,null,null,null,"postcode"]
["Consultation Number",null,"consultationNumber"]
[]
[]
[null,"char(10) is line break"]
[]
[]
["actual date",{"$f":"IFERROR(DATE(LEFT(B5,4),MID(B5,6,2),MID(B5,9,2)),\"\")","v":"2023-01-16"}]