{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Logs","Front Page","Bond Issues","Bond Repayments","Outstanding bonds","Commercial Paper","Validation Summary","Bond Issues Validation","Bond repayments Validation","Commercial Paper Validation"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":0,"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":"Logs","index":0,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Transaction Id","Action","Start Time","End Time","Time Taken (ms)"]
["75b274eb-2582-4aab-8372-dcf94039585f","Getting Cube Information","15:31:19","15:31:20",1163.0236]
["41c10fad-0bbb-41d3-97f3-69d0cacc3e9c","Getting Cube Information","14:32:02","14:32:04",2167]

{"sheet":"Front Page","index":1,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[8,6,8,7],[12,6,12,11],[20,6,20,11],[24,14,32,18],[34,14,34,17],[10,6,10,11],[16,6,16,11],[18,6,18,11],[26,3,26,9]]}
["v1.12"]
[]
[null,null,null,"Issuing and Paying Agent's Reporting Form"]
[]
[null,null,null,"Debt Securities - Issues/Repayments of Bonds and Commercial Paper"]
[]
[null,null,null,"Reporting Information"]
[]
[null,null,null,null,"Reporting Period",null,"2017/08",null,"(YYYY/MM)"]
[]
[null,null,null,null,"Reporting institution",null,"XXXXX",null,null,null,null,null,"(This must be the Reporter code supplied to you by the Bank of England)"]
[]
[null,null,null,null,"Name of authorised official"]
[]
[null,null,null,"In the event of a query the Bank of England may contact:"]
[]
[null,null,null,null,"Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have any difficulties in completing or returning "]
[null,null,null,null,"Contact Number",null,null,null,null,null,null,null,null,null,"this form, please telephone the Securities Statistics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"team on 020 7601 4763/5949."]
[null,null,null,null,"Email"]
[]
[]
[null,null,null,"Notes on completion",null,null,null,null,null,null,null,null,null,null,"Initial Validation Results"]
[null,null,null,"1. Complete the reporting information section above as at end calendar month",null,null,null,null,null,null,null,null,null,null,"Data Successfully Validated"]
[null,null,null,"2. For definition of items, refer to the definitions supplied:"]
[null,null,null,"http://www.bankofengland.co.uk/statistics/Documents/reporters/defs/def_ipa.pdf"]
[null,null,null,"3. If required, press the 'Clear Data' button to clear all existing data"]
[null,null,null,"4. Input or paste data into worksheets as required"]
[null,null,null,"5. Press 'Initial Data Check' to complete basic format/completeness checks"]
[null,null,null,"6. Review results box and resolve errors where required until success"]
[null,null,null,"message is displayed",null,null,null,null,null,null,null,"Overwrite Existing Files?"]
[null,null,null,"7. Press 'Create File' and enter directory to save the form as a zipped .csv"]
[null,null,null,"8. Attach the file and send via secure email to the BoE at the following address:"]
[null,null,null," IPAform@bankofengland.co.uk within 7 working days of the reporting date",null,null,null,null,null,null,null,null,null,"Export Files To:  "]

{"sheet":"Bond Issues","index":2,"n_rows":8,"n_cols":20,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Record No","ISIN","Currency","Nominal Amount Issued","End Amount Outstanding ","Issue Price","Issue Date ","Final Maturity Date","Issuer Name","Issuer LEI","Issuer Residency","Listing","Bond Type","Coupon Type","Rate (if fixed)%","Deal Type","Feature(s)","IPA Location","Comment(s)","Validation"]
[1,"GB1111111111","USD",9.8000000000000007,9.8000000000000007,100,"2017-08-21","2020-11-23","Company A","A111111111111111111","UK",2,2,99,null,99,"99~99","UK"]
[2,"GB1111111111","USD",15,24.8,99.5,"2017-08-23","2020-11-23","Company A","A111111111111111111","UK",2,2,99,null,99,"99~99","UK"]
[3,"GB222222222","USD",3.6,3.6,100,"2017-08-24","2020-08-17","Company A","A111111111111111111","UK",2,2,99,null,99,99,"UK"]
[4,"US1111111111","USD",6.8,874.4,100,"2017-08-11","2018-05-15","Company A","A111111111111111111","UK",2,2,1,1.5,99,99,"UK"]
[5,"XS9999999999","GBP",7.3,15.4,100,"2017-08-19","2022-06-17","Company B","A2222222222222222222","UK",5,1,1,3.5,99,99,"UK"]
[6,"XS1222222222","USD",0.9,98.9,100,"2017-08-02","2019-08-08","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[7,"XS1333333333","USD",75,75,100,"2017-08-27","2019-08-03","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]

{"sheet":"Bond Repayments","index":3,"n_rows":7,"n_cols":21,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Record No","ISIN","Currency","Nominal Amount Repaid","End Amount Outstanding","Repayment Price","Issue Date ","Repayment Date ","Final Maturity Date ","Issuer Name","Issuer LEI","Issuer Residency","Listing","Bond Type","Coupon Type","Rate (if fixed) %","Deal Type","Feature(s)","IPA Location","Comments","Validation"]
[1,"XS9999999999","GBP",1.9,13.5,100,"2016-06-17","2017-08-29","2022-06-17","Company B","A2222222222222222222","UK",5,1,1,3.5,99,99,"UK"]
[2,"XS1222222222","USD",8,90.9,100,"2013-08-08","2017-08-27","2019-08-08","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[3,"XS1333333333","USD",10,65,100,"2015-02-01","2017-08-28","2019-08-03","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[4,"XS1333333333","USD",3,62,101,"2015-02-01","2017-08-28","2019-08-03","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[5,"XS1444444444","GBP",100,50,100,"2014-08-11","2017-08-11","2017-08-11","Company C","A3333333333333333","OTH",1,1,3,null,99,99,"UK"]
[6,"XS1444444444","GBP",50,0,100,"2014-08-11","2017-08-11","2017-08-11","Company C","A3333333333333333","OTH",1,1,3,null,99,99,"UK"]

{"sheet":"Outstanding bonds","index":4,"n_rows":21,"n_cols":25,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Record No","ISIN","Currency","Opening Amount Outstanding","Nominal Amount Issued ","Amount Raised ","Nominal Amount Repaid","End Amount Outstanding ","Issue Price","Repayment price","Issue Date ","Repayment date","Final Maturity Date","Issuer Name","Issuer LEI","Issuer Residency","Listing","Bond Type","Coupon Type","Rate (if fixed)%","Deal Type","Feature(s)","IPA Location","Comment(s)","Validation"]
[1,"GB1111111111","USD",0,9.8000000000000007,9.8000000000000007,0,9.8000000000000007,100,null,"2017-08-21",null,"2020-11-23","Company A","A111111111111111111","UK",2,2,99,null,99,"99~99","UK"]
[2,"GB1111111111","USD",9.8000000000000007,15,14.9,0,24.8,99.5,null,"2017-08-23",null,"2020-11-23","Company A","A111111111111111111","UK",2,2,99,null,99,"99~99","UK"]
[3,"GB222222222","USD",0,3.6,3.6,0,3.6,100,null,"2017-08-24",null,"2020-08-17","Company A","A111111111111111111","UK",2,2,99,null,99,99,"UK"]
[4,"US1111111111","USD",867.6,6.8,6.8,0,874.4,100,null,"2017-08-11",null,"2018-05-15","Company A","A111111111111111111","UK",2,2,1,1.5,99,99,"UK"]
[5,"XS9999999999","GBP",8.1,7.3,7.3,0,15.4,100,null,"2017-08-19",null,"2022-06-17","Company B","A2222222222222222222","UK",5,1,1,3.5,99,99,"UK"]
[6,"XS9999999999","GBP",15.4,0,0,1.9,13.5,null,100,"2016-06-17","2017-08-29","2022-06-17","Company B","A2222222222222222222","UK",5,1,1,3.5,99,99,"UK"]
[7,"XS1222222222","USD",98,0.9,0.9,0,98.9,100,null,"2017-08-02",null,"2019-08-08","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[8,"XS1222222222","USD",98.9,0,0,8,90.9,null,100,"2013-08-08","2017-08-27","2019-08-08","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[9,"XS1333333333","USD",0,75,75,0,75,100,null,"2017-08-03",null,"2019-08-03","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[10,"XS1333333333","USD",75,0,0,10,65,null,100,"2017-08-03","2017-08-28","2019-08-03","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[11,"XS1333333333","USD",65,0,0,3,62,null,101,"2017-08-03","2017-08-28","2019-08-03","Company A","A111111111111111111","UK",1,2,1,0.77,99,99,"UK"]
[12,"XS1444444444","GBP",150,0,0,100,50,null,100,"2014-08-11","2017-08-11","2017-08-11","Company C","A3333333333333333","OTH",1,1,3,null,99,99,"UK"]
[13,"XS1444444444","GBP",50,0,0,50,0,null,100,"2014-08-11","2017-08-11","2017-08-11","Company C","A3333333333333333","OTH",1,1,3,null,99,99,"UK"]
[14,"XS5555555555","USD","350.0",0,0,0,"350.0",null,null,"2012-01-01",null,"2022-01-01","Company D","A4444444444444444","UK",1,1,2,null,99,99,"UK"]
[15,"XS6666666666","GBP","215.0",0,0,0,"215.0",null,null,"2017-06-15",null,"2019-06-15","Company E","A55555555555555555","OTH",2,1,1,0.9,99,99,"UK"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Commercial Paper","index":5,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Record No","ISIN","Currency","Opening Amount Outstanding","Nominal Amount Issued ","Amount Raised ","Nominal Amount Repaid","End Amount Outstanding ","Final maturity date","Issuer Name","Issuer LEI","Issuer Residency","IPA Location","Comments","Validation"]
[1,"XS000011111","USD",200,0,0,20,180,"2017-09-01","Company G",null,"OTH","UK"]
[2,"XS000022222","USD",1059,0,0,200,8059,"2017-09-24","Company H","B11111111111111111","OTH","UK"]
[3,"XS000033333","USD",0,15,15,0,15,"2017-09-05","Company I","B22222222222222222","UK","UK"]
[4,"XS000044444","EUR",200,300,300,300,200,"2017-08-23","Company J","B33333333333333333","OTH","UK"]
[5,"XS000055555","EUR",866,208,208,375,699,"2017-09-11","Company K","B44444444444444444","UK","UK"]
[6,"XS000066666","USD",168,12,12,168,12,"2017-09-12","Company K","B44444444444444444","UK","UK"]
[7,"XS000077777","USD","322.0","0.0","0.0","0.0","322.0","21/12/2017","Company L","B55555555555555555","UK","UK"]

{"sheet":"Validation Summary","index":6,"n_rows":113,"n_cols":2,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["Sheet","Validation Rule"]
["Bond Issues","Record No requires a value."]
["Bond Issues","Record No should have a maximum of 0 decimal place(s)."]
["Bond Issues","Record No must be a valid number."]
["Bond Issues","Record No should not have a value of 0."]
["Bond Issues","ISIN must be a valid ISIN."]
["Bond Issues","Only one Issuer allowed per ISIN"]
["Bond Issues","Currency requires a value."]
["Bond Issues","Currency should be 3 character(s) in length."]
["Bond Issues","Currency should not contain numbers."]
["Bond Issues","Nominal Amount Issued requires a value."]
["Bond Issues","Nominal Amount Issued should have a maximum of 1 decimal place(s)."]
["Bond Issues","Nominal Amount Issued must be a valid number."]
["Bond Issues","End Amount Outstanding requires a value."]
["Bond Issues","End Amount Outstanding should have a maximum of 1 decimal place(s)."]
["Bond Issues","End Amount Outstanding must be a valid number."]
["Bond Issues","Issue Price requires a value."]
["Bond Issues","Issue Price should have a maximum of 2 decimal place(s)."]
["Bond Issues","Issue Price must be a valid number."]
["Bond Issues","Issue Date requires a value."]
["Bond Issues","Issue Date should be a valid date."]
["Bond Issues","Issue Date must be within the current reporting period."]
["Bond Issues","Final Maturity Date should be a valid date."]
["Bond Issues","Issuer Name requires a value."]
["Bond Issues","Issuer Residency requires a value."]
["Bond Issues","Issuer Residency must be one of the values: UK,OTH ."]
["Bond Issues","Listing requires a value."]
["Bond Issues","Bond Type requires a value."]
["Bond Issues","Bond Type should be 1 character(s) in length."]
["Bond Issues","Bond Type must be a valid number."]
["Bond Issues","Coupon Type requires a value."]
["Bond Issues","Coupon Type should be no more than 2 character(s) in length."]
["Bond Issues","Coupon Type must be a valid number."]
["Bond Issues","Rate should have a maximum of 2 decimal place(s)."]
["Bond Issues","Rate must be a valid number."]
["Bond Issues","Deal Type requires a value."]
["Bond Issues","Deal Type should be no more than 2 character(s) in length."]
["Bond Issues","Deal Type must be a valid number."]
["Bond Issues","Feature(s) requires a value."]
["Bond Issues","IPA Location requires a value."]
["Bond Issues","IPA Location should be 2 character(s) in length."]
["Bond Issues","IPA Location should not contain numbers."]
["Bond repayments","Record No requires a value."]
["Bond repayments","Record No should have a maximum of 0 decimal place(s)."]
["Bond repayments","Record No must be a valid number."]
["Bond repayments","Record No should not have a value of 0."]
["Bond repayments","ISIN must be a valid ISIN."]
["Bond repayments","Only one Issuer allowed per ISIN"]
["Bond repayments","Currency requires a value."]
["Bond repayments","Currency should be 3 character(s) in length."]
["Bond repayments","Currency should not contain numbers."]
["Bond repayments","Nominal Amount requires a value."]
["Bond repayments","Nominal Amount should have a maximum of 1 decimal place(s)."]
["Bond repayments","Nominal Amount must be a valid number."]
["Bond repayments","End Amount Outstanding requires a value."]
["Bond repayments","End Amount Outstanding should have a maximum of 1 decimal place(s)."]
["Bond repayments","End Amount Outstanding must be a valid number."]
["Bond repayments","Repayment Price requires a value."]
["Bond repayments","Repayment Price should have a maximum of 2 decimal place(s)."]
["Bond repayments","Repayment Price must be a valid number."]
["Bond repayments","Issue Date  requires a value."]
["Bond repayments","Issue Date  should be a valid date."]
["Bond repayments","Repayment Date requires a value."]
["Bond repayments","Repayment Date should be a valid date."]
["Bond repayments","Repayment Date must be within the current reporting period."]
["Bond repayments","Final Maturity Date should be a valid date."]
["Bond repayments","Issuer Name requires a value."]
["Bond repayments","Issuer Residency requires a value."]
["Bond repayments","Issuer Residency must be one of the values: UK,OTH ."]
["Bond repayments","Listing requires a value."]
["Bond repayments","Bond Type requires a value."]
["Bond repayments","Bond Type should be 1 character(s) in length."]
["Bond repayments","Bond Type must be a valid number."]
["Bond repayments","Coupon requires a value."]
["Bond repayments","Coupon should be no more than 2 character(s) in length."]
["Bond repayments","Coupon must be a valid number."]
["Bond repayments","Rate should have a maximum of 2 decimal place(s)."]
["Bond repayments","Rate must be a valid number."]
["Bond repayments","Deal Type requires a value."]
["Bond repayments","Deal Type should be no more than 2 character(s) in length."]
["Bond repayments","Deal Type must be a valid number."]
["Bond repayments","Feature(s) requires a value."]
["Bond repayments","IPA Location requires a value."]
["Bond repayments","IPA Location should be 2 character(s) in length."]
["Bond repayments","IPA Location should not contain numbers."]
["Commercial Paper","Record No requires a value."]
["Commercial Paper","Record No should have a maximum of 0 decimal place(s)."]
["Commercial Paper","Record No must be a valid number."]
["Commercial Paper","Record No should not have a value of 0."]
["Commercial Paper","Currency requires a value."]
["Commercial Paper","Currency should be 3 character(s) in length."]
["Commercial Paper","Currency should not contain numbers."]
["Commercial Paper","Opening Amount Outstanding requires a value."]
["Commercial Paper","Opening Amount Outstanding should have a maximum of 1 decimal place(s)."]
["Commercial Paper","Opening Amount Outstanding must be a valid number."]
["Commercial Paper","Nominal Amount Issued requires a value."]
["Commercial Paper","Nominal Amount Issued should have a maximum of 1 decimal place(s)."]
["Commercial Paper","Nominal Amount Issued must be a valid number."]
["Commercial Paper","Amount Raised requires a value."]
["Commercial Paper","Amount Raised should have a maximum of 1 decimal place(s)."]
["Commercial Paper","Amount Raised must be a valid number."]
["Commercial Paper","Nominal Amount Repaid requires a value."]
["Commercial Paper","Nominal Amount Repaid should have a maximum of 1 decimal place(s)."]
["Commercial Paper","Nominal Amount Repaid must be a valid number."]
["Commercial Paper","End Amount Outstanding requires a value."]
["Commercial Paper","End Amount Outstanding should have a maximum of 1 decimal place(s)."]
["Commercial Paper","End Amount Outstanding must be a valid number."]
["Commercial Paper","Issuer Name requires a value."]
["Commercial Paper","Issuer Residency requires a value."]
["Commercial Paper","Issuer Residency must be one of the values: UK,OTH ."]
["Commercial Paper","IPA Location requires a value."]
["Commercial Paper","IPA Location should be 2 character(s) in length."]
["Commercial Paper","IPA Location should not contain numbers."]

{"sheet":"Bond Issues Validation","index":7,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Column","Column Name","Required","IsISIN","Length","Decimal Places","Max Length","Is Date","Values","Is Numeric","Within Reporting Period","Value Not Permitted","Unique Issuer For ISIN"]
["A","Record No","Y",null,null,0,null,null,null,"Y",null,0]
["B","ISIN",null,"Y",null,null,null,null,null,null,null,null,"Y"]
["C","Currency","Y",null,3,null,null,null,null,"N"]
["D","Nominal Amount Issued","Y",null,null,1,null,null,null,"Y"]
["E","End Amount Outstanding","Y",null,null,1,null,null,null,"Y"]
["F","Issue Price","Y",null,null,2,null,null,null,"Y"]
["G","Issue Date","Y",null,null,null,null,"Y",null,null,"Y"]
["H","Final Maturity Date",null,null,null,null,null,"Y"]
["I","Issuer Name","Y"]
["J","Issuer Residency","Y",null,null,null,null,null,"UK,OTH"]
["K","Listing","Y"]
["L","Bond Type","Y",null,1,null,null,null,null,"Y"]
["M","Coupon Type","Y",null,null,null,2,null,null,"Y"]
["N","Rate",null,null,null,2,null,null,null,"Y"]
["O","Deal Type","Y",null,null,null,2,null,null,"Y"]
["P","Feature(s)","Y"]
["Q","IPA Location","Y",null,2,null,null,null,null,"N"]

{"sheet":"Bond repayments Validation","index":8,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Column","Column Name","Required","IsISIN","Length","Decimal Places","Max Length","Is Date","Values","Is Numeric","Within Reporting Period","Value Not Permitted","Unique Issuer For ISIN"]
["A","Record No","Y",null,null,0,null,null,null,"Y",null,0]
["B","ISIN",null,"Y",null,null,null,null,null,null,null,null,"Y"]
["C","Currency","Y",null,3,null,null,null,null,"N"]
["D","Nominal Amount","Y",null,null,1,null,null,null,"Y"]
["E","End Amount Outstanding","Y",null,null,1,null,null,null,"Y"]
["F","Repayment Price","Y",null,null,2,null,null,null,"Y"]
["G","Issue Date ","Y",null,null,null,null,"Y"]
["H","Repayment Date","Y",null,null,null,null,"Y",null,null,"Y"]
["I","Final Maturity Date",null,null,null,null,null,"Y"]
["J","Issuer Name","Y"]
["K","Issuer Residency","Y",null,null,null,null,null,"UK,OTH"]
["L","Listing","Y"]
["M","Bond Type","Y",null,1,null,null,null,null,"Y"]
["N","Coupon","Y",null,null,null,2,null,null,"Y"]
["O","Rate",null,null,null,2,null,null,null,"Y"]
["P","Deal Type","Y",null,null,null,2,null,null,"Y"]
["Q","Feature(s)","Y"]
["R","IPA Location","Y",null,2,null,null,null,null,"N"]

{"sheet":"Commercial Paper Validation","index":9,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Column","Column Name","Required","IsISIN","Length","Decimal Places","Max Length","Is Date","Values","Is Numeric","Value Not Permitted"]
["A","Record No","Y",null,null,0,null,null,null,"Y",0]
["B","Currency","Y",null,3,null,null,null,null,"N"]
["C","Opening Amount Outstanding","Y",null,null,1,null,null,null,"Y"]
["D","Nominal Amount Issued","Y",null,null,1,null,null,null,"Y"]
["E","Amount Raised","Y",null,null,1,null,null,null,"Y"]
["F","Nominal Amount Repaid","Y",null,null,1,null,null,null,"Y"]
["G","End Amount Outstanding","Y",null,null,1,null,null,null,"Y"]
["H","Issuer Name","Y"]
["I","Issuer Residency","Y",null,null,null,null,null,"UK,OTH"]
["J","IPA Location","Y",null,2,null,null,null,null,"N"]