{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["README","Params","Attributes","Report","Header_Data","Reference_Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":"README","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Params","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,1,1,3],[1,5,1,8]]}
[]
[null,"tParam : Application Parameters",null,null,null,"tDocType : Supported Document Types"]
[null,"Param","Value","Note",null,"Code","Title","XMLHeader","XMLEntry","ShortCode"]
[null,"Release.Version","1.0","Manually maintained",null,"PIL","Physical Inventory Listing","PhysicalInventoryListing","Pil","P"]
[null,"Release.Number",9,"Auto-filled at release",null,"ICR","Inventory Change Report","InventoryChangeReport","Icr","I"]
[null,"Release.DateTime","2022-02-12T15:56:41","Auto-filled at release",null,"MBR","Material Balance Report","MaterialBalanceReport","Mbr","M"]
[null,"Workbench.Enabled",false,"Indicates whether this is the Dev platform"]
[null,"Workbench.Version","1.0","Manually maintained"]
[null,"Workbench.IsEditing",false,"Used to freeze UI behaviour for dev/test"]
[null,"Workbench.Password","X","Manually maintained"]
[null,"Support.Email","simrs.support@onr.gov.uk","Used in user messaging"]
[null,"Attribs.MBA.Fixed","Q???","Linked in Attributes table"]
[null,"Attribs.DocType.Current","PIL","Drives selection from tDocType, below"]
[null,"X Attribs.Decimal.RegEx","^\\d{0,%MXL}\\.{0,1}\\d{%MND,%MXD}$","MXL = MaxLen, MND = MinDecPl, MXD = MaxDecPl\n7/7/22 Deprecated - now moved into specific Attributes.RegEx"]
[null,"ReportView.Current","Auto","Maintained by application"]
[null,"Colour.Disabled",null,"Uses given fill colour"]
[null,"Colour.Warning",null,"Uses given fill colour"]
[null,"Colour.Error",null,"Uses given fill colour"]
[null,"Colour.Correction",null,"Uses given fill colour"]

{"sheet":"Attributes","index":2,"n_rows":98,"n_cols":32,"rows_kept":98,"cut":false,"hidden":true,"merged":[[1,0,1,3],[1,4,1,22],[1,23,1,29]]}
["tAttrib : Field type attributes"]
["Identification",null,null,null,"Validation Params",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard View Params",null,null,null,null,null,null,"XML Params","CRC Params"]
["ID","DocType","DocPart","Name","Caption","V-Mandatory","V-OptMinD","V-DataType","V-MinVal","V-MaxVal","V-MinDecPl","V-MaxDecPl","V-MaxLen","V-Literal","V-RegEx","V-List","V-ValidationNote","V-ForceUpper","V-Editable","V-Supported","V-UniqueGrp","V-InitialVal","V-IcDependency","SV-Caption","SV-Seq","SV-Width","SV-Orient","SV-Align","SV-Wrap","SV-Fill","XML-Seq","CRC-Seq"]
[1,"PIL","Header","MBA","Material Balance Area","Mandatory",null,"RegEx",null,null,null,null,4,null,"^Q[A-Z0-9]{3}$",null,"4 uppercase alphanumeric chars beginning with Q","Y",null,null,null,{"$f":"Params!$C$12","v":"Q???"},null,null,2,null,null,null,null,null,1,1]
[2,"PIL","Header","ReportType","Report Type","Mandatory",null,"Literal",null,null,null,null,1,"P",null,null,null,null,"N",null,null,"P",null,null,1,null,null,null,null,null,2,2]
[3,"PIL","Header","ReportNumber","Report Number","Mandatory",null,"Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,3,4]
[4,"PIL","Header","ReportDate","Report Date","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,4,3]
[5,"PIL","Header","PITDate","Physical Inventory Taking (PIT) Date","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,5,5]
[6,"PIL","Header","ReportingPerson","Reporter","Mandatory",null,"Text",null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,6,7]
[7,"PIL","Header","LineCount","Line Count","MandatoryAtSub",null,"Integer",0,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,"N",null,null,null,null,null,9,null,null,null,null,null,7,6]
[8,"PIL","Entry","LineNumber","Line Number","MandatoryAtSub","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,"N",null,null,null,null,"Line No",1,20,"Horiz","Left",null,"Disabled",9,16]
[9,"PIL","Entry","CRC","CRC","MandatoryAtSub","N","CRC",null,null,null,null,20,null,null,null,null,null,"N",null,null,null,null,"CRC",2,17.71,"Horiz","Left",null,"Disabled",20]
[10,"PIL","Entry","KMP","Key Measurement Point (KMP)","Mandatory","Y","Text",null,null,null,null,1,null,null,null,"a single character only","Y",null,null,null,null,null,"KMP Code",3,4.43,"Vert","Centre",null,"Enabled",3,10]
[11,"PIL","Entry","Obligation","Obligation","Mandatory","Y","List",null,null,null,null,2,null,null,"ObligationCodes",null,"Y",null,null,null,null,null,"Obligation",4,4.43,"Vert","Centre",null,"Enabled",14,21]
[12,"PIL","Entry","Measurement","Measurement Basis","Mandatory","Y","List",null,null,null,null,1,null,null,"MeasurementCodes",null,"Y",null,null,null,null,null,"Measurement Basis",5,4.43,"Vert","Centre",null,"Enabled",4,11]
[13,"PIL","Entry","ElementCategory","Element Category","Mandatory","Y","List",null,null,null,null,1,null,null,"ElementCodes",null,"Y",null,null,null,null,null,"Element Category",6,4.43,"Vert","Centre",null,"Enabled",5,12]
[14,"PIL","Entry","ElementWeight","Element Weight","Mandatory","Y","Decimal",0,null,0,3,12,null,"^[\\-]{0,1}\\d{0,%MXL}\\.{0,1}\\d{%MND,%MXD}$",null,null,null,null,null,null,null,null,"Weight Of\nElement",7,16.86,"Horiz","Centre",null,"Enabled",11,18]
[15,"PIL","Entry","Isotope","Isotope","Conditional","Y","List",null,null,null,null,1,null,null,"IsotopeCodes",null,"Y",null,null,null,null,null,"Isotope Code",8,4.43,"Vert","Centre",null,"Enabled",12,19]
[16,"PIL","Entry","FissileWeight","Fissile Weight","Conditional","Y","Decimal",0,null,0,3,12,null,"^[\\-]{0,1}\\d{0,%MXL}\\.{0,1}\\d{%MND,%MXD}$",null,null,null,null,null,null,null,null,"Weight Of\nFissile Isotope",9,21.43,"Horiz","Centre",null,"Enabled",13,20]
[17,"PIL","Entry","MaterialForm","Mateial Form","Mandatory","Y","List",null,null,null,null,2,null,null,"MaterialFormCodes",null,"Y",null,null,null,null,null,"Mateial Form",10,4.43,"Vert","Centre",null,"Enabled",6,13]
[18,"PIL","Entry","MaterialContainer","Material Container","Mandatory","Y","List",null,null,null,null,1,null,null,"MaterialContainerCodes",null,"Y",null,null,null,null,null,"Material Container",11,4.43,"Vert","Centre",null,"Enabled",7,14]
[19,"PIL","Entry","MaterialState","Material State","Mandatory","Y","List",null,null,null,null,1,null,null,"MaterialStateCodes",null,"Y",null,null,null,null,null,"Material State",12,4.43,"Vert","Centre",null,"Enabled",8,15]
[20,"PIL","Entry","Items","Num Items","Mandatory","Y","Integer",0,null,null,null,6,null,"^\\d{1,%MXL}$",null,null,null,null,null,null,null,null,"No of items in Batch",13,5.57,"Vert","Centre",null,"Enabled",10,17]
[21,"PIL","Entry","Batch","Batch ID","Mandatory","Y","Text",null,null,null,null,20,null,null,null,null,"Y",null,null,null,null,null,"Name or No \nof Batch",14,19.29,"Horiz","Centre",null,"Enabled",2,9]
[22,"PIL","Entry","Document","Document","Optional","Y","Text",null,null,null,null,70,null,null,null,null,null,null,"N",null,null,null,"Document",null,18.29,"Horiz","Centre","Y","Enabled",null,22]
[23,"PIL","Entry","ContainerID","Container ID","Optional","Y","Text",null,null,null,null,20,null,null,null,null,"Y",null,null,null,null,null,"Container ID",15,18.29,"Vert","Centre",null,"Enabled",15,23]
[24,"PIL","Entry","PIL_ITEM_ID","PIL Item ID","Mandatory","Y","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,"PIL Item ID",16,5.29,"Vert","Centre",null,"Enabled",1,8]
[25,"PIL","Entry","Correction","Correction Type","Optional","N","List",null,null,null,null,1,null,null,"CorrectionTypes",null,"Y",null,null,null,null,null,"Correction Type",17,4.43,"Vert","Centre",null,"Correction",16,24]
[26,"PIL","Entry","PreviousReport","Previous Report","Conditional","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,"Previous Report Number",18,5.29,"Vert","Centre",null,"Correction",17,25]
[27,"PIL","Entry","PreviousLine","Previous Line","Conditional","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,"Previous Line Number",19,5.29,"Vert","Centre",null,"Correction",18,26]
[28,"PIL","Entry","PreviousCRC","Previous CRC","Conditional","N","CRC",null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,"CRC of Previous Line",20,7,"Vert","Centre",null,"Correction",21,29]
[29,"PIL","Entry","Comment","Comment","Optional","Y","Text",null,null,null,null,256,null,null,null,null,null,null,null,null,null,null,"Comment",21,55.86,"Horiz","Left","Y","Enabled",19,27]
[30,"MBR","Header","MBA","Material Balance Area","Mandatory",null,"RegEx",null,null,null,null,4,null,"^Q[A-Z0-9]{3}$",null,"4 uppercase alphanumeric chars beginning with Q","Y",null,null,null,{"$f":"Params!$C$12","v":"Q???"},null,null,2,null,null,null,null,null,1,1]
[31,"MBR","Header","ReportType","Report Type","Mandatory",null,"Literal",null,null,null,null,1,"M",null,null,null,"Y","N",null,null,"M",null,null,1,null,null,null,null,null,2,2]
[32,"MBR","Header","ReportNumber","Report Number","Mandatory",null,"Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,3,6]
[33,"MBR","Header","ReportDate","Report Date","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,4,3]
[34,"MBR","Header","StartReport","Report Period Start ","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,5,4]
[35,"MBR","Header","EndReport","Report Period End","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,6,5]
[36,"MBR","Header","ReportingPerson","Reporter","Mandatory",null,"Text",null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,7,9]
[37,"MBR","Header","LineCount","Line Count","MandatoryAtSub",null,"Integer",0,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,"N",null,null,null,null,null,9,null,null,null,null,null,8,8]
[38,"MBR","Entry","LineNumber","Line Number","MandatoryAtSub","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,"N",null,null,null,null,"Line No",1,20,"Horiz","Left",null,"Disabled",1,11]
[39,"MBR","Entry","CRC","CRC","MandatoryAtSub","N","CRC",null,null,null,null,20,null,null,null,null,null,"N",null,null,null,null,"CRC",2,17.71,"Horiz","Left",null,"Disabled",2]
[40,"MBR","Entry","ICCode","Inventory Change (IC) Code","Mandatory","Y","List",null,null,null,null,2,null,null,"InventoryChangeCodesMBR",null,"Y",null,null,null,null,null,"Inventory Change Code",3,6.29,"Vert","Centre",null,"Enabled",3,10]
[41,"MBR","Entry","Obligation","Obligation","Mandatory","Y","List",null,null,null,null,2,null,null,"ObligationCodes",null,"Y",null,null,null,null,null,"Obligation",4,4.43,"Vert","Centre",null,"Enabled",4,15]
[42,"MBR","Entry","ElementCategory","Element Category","Mandatory","Y","List",null,null,null,null,1,null,null,"ElementCodes",null,"Y",null,null,null,null,null,"Element Category",5,4.43,"Vert","Centre",null,"Enabled",5,7]
[43,"MBR","Entry","ElementWeight","Element Weight","Mandatory","Y","Decimal",0,null,0,3,12,null,"^[\\-]{0,1}\\d{0,%MXL}\\.{0,1}\\d{%MND,%MXD}$",null,null,null,null,null,null,null,null,"Weight Of\nElement",6,16.86,"Horiz","Centre",null,"Enabled",6,12]
[44,"MBR","Entry","Isotope","Isotope","Conditional","Y","List",null,null,null,null,1,null,null,"IsotopeCodes",null,"Y",null,null,null,null,null,"Isotope Code",7,4.43,"Vert","Centre",null,"Enabled",7,13]
[45,"MBR","Entry","FissileWeight","Fissile Weight","Conditional","Y","Decimal",0,null,0,3,12,null,"^[\\-]{0,1}\\d{0,%MXL}\\.{0,1}\\d{%MND,%MXD}$",null,null,null,null,null,null,null,null,"Weight Of\nFissile Isotope",8,21.43,"Horiz","Centre",null,"Enabled",8,14]
[46,"MBR","Entry","Correction","Correction Type","Optional","N","List",null,null,null,null,1,null,null,"CorrectionTypes",null,"Y",null,null,null,null,null,"Correction Type",9,4.43,"Vert","Centre",null,"Correction",9,16]
[47,"MBR","Entry","PreviousReport","Previous Report","Conditional","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,"Previous Report Number",10,5.29,"Vert","Centre",null,"Correction",10,17]
[48,"MBR","Entry","PreviousLine","Previous Line","Conditional","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,"Previous Line Number",11,5.29,"Vert","Centre",null,"Correction",11,18]
[49,"MBR","Entry","PreviousCRC","Previous CRC","Conditional","N","CRC",null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,"CRC of Previous Line",12,7,"Vert","Centre",null,"Correction",12,21]
[50,"MBR","Entry","Comment","Comment","Optional","Y","Text",null,null,null,null,256,null,null,null,null,null,null,null,null,null,null,"Comment",13,55.86,"Horiz","Left","Y","Enabled",13,19]
[51,"ICR","Header","MBA","Material Balance Area","Mandatory",null,"RegEx",null,null,null,null,4,null,"^Q[A-Z0-9]{3}$",null,"Q' followed by three alphanumeric chars","Y",null,null,null,{"$f":"Params!$C$12","v":"Q???"},null,null,2,null,null,null,null,null,1,1]
[52,"ICR","Header","ReportType","Report Type","Mandatory",null,"Literal",null,null,null,null,1,"I",null,null,null,"Y",null,null,null,"I",null,null,1,null,null,null,null,null,2,2]
[53,"ICR","Header","ReportNumber","Report Number","Mandatory",null,"Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,3,4]
[54,"ICR","Header","ReportDate","Report Date","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,4,3]
[55,"ICR","Header","StartReport","Report Period Start ","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,5,6]
[56,"ICR","Header","EndReport","Report Period End","Mandatory",null,"Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,6,7]
[57,"ICR","Header","ReportingPerson","Reporter","Mandatory",null,"Text",null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,7,8]
[58,"ICR","Header","LineCount","Line Count","MandatoryAtSub",null,"Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,"N",null,null,null,null,null,9,null,null,null,null,null,8,5]
[59,"ICR","Entry","LineNumber","Line Number","MandatoryAtSub","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,"N",null,null,null,null,"Line No",1,20,"Horiz","Left",null,"Disabled",1,22]
[60,"ICR","Entry","CRC","CRC","MandatoryAtSub","N","CRC",null,null,null,null,20,null,null,null,null,null,"N",null,null,null,null,"CRC",2,17.71,"Horiz","Left",null,"Disabled",2]
[61,"ICR","Entry","ICCode","Inventory Change (IC) Code","Mandatory","Y","List",null,null,null,null,2,null,null,"InventoryChangeCodesICR",null,"Y",null,null,null,null,null,"Inventory Change (IC) Code",5,5,"Vert","Centre",null,"Enabled",3,10]
[62,"ICR","Entry","AccountingDate","Accounting Date","Mandatory","Y","Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,"Accounting Date",4,16.29,"Vert","Centre",null,"Enabled",4,23]
[63,"ICR","Entry","TransactionID","Transaction ID","Mandatory","Y","RegEx",null,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,"Y",null,null,"TXNID",null,null,"Transaction ID",3,8.43,"Vert","Centre",null,"Enabled",5,9]
[64,"ICR","Entry","KMP","Key Measurement Point (KMP)","Conditional","Y","Text",null,null,null,null,1,null,null,null,"a single character only","Y",null,null,null,null,"..,~BA,~BJ,~MF","KMP Code",6,4.43,"Vert","Centre",null,"Enabled",6,12]
[65,"ICR","Entry","Obligation","Obligation","Mandatory","Y","List",null,null,null,null,2,null,null,"ObligationCodes",null,"Y",null,null,null,null,null,"Obligation",7,4.43,"Vert","Centre",null,"Enabled",7,30]
[66,"ICR","Entry","PreviousObligation","Previous Obligation","Conditional","Y","List",null,null,null,null,2,null,null,"ObligationCodes",null,"Y",null,null,null,null,"BR,CR,PR,SR","Previous Obligation",8,5,"Vert","Centre",null,"Enabled",8,32]
[67,"ICR","Entry","Measurement","Measurement Basis","Conditional","Y","List",null,null,null,null,1,null,null,"MeasurementCodes",null,"Y",null,null,null,null,"..,~BA,~BJ,~MF","Measurement Basis",9,4.43,"Vert","Centre",null,"Enabled",9,13]
[68,"ICR","Entry","ElementCategory","Element Category","Mandatory","Y","List",null,null,null,null,1,null,null,"ElementCodes",null,"Y",null,null,null,null,null,"Element Category",10,4.43,"Vert","Centre",null,"Enabled",10,25]
[69,"ICR","Entry","PreviousCategory","Previous Category","Conditional","Y","List",null,null,null,null,1,null,null,"ElementCodes",null,"Y",null,null,null,null,"CB,CC,CE","Previous Category",11,5,"Vert","Centre",null,"Enabled",11,31]
[70,"ICR","Entry","ElementWeight","Element Weight","Mandatory","Y","Decimal",0,null,0,3,12,null,"^[\\-]{0,1}\\d{0,%MXL}\\.{0,1}\\d{%MND,%MXD}$",null,null,null,null,null,null,null,null,"Weight Of\nElement",12,16.86,"Horiz","Centre",null,"Enabled",12,26]
[71,"ICR","Entry","Isotope","Isotope","Conditional","Y","List",null,null,null,null,1,null,null,"IsotopeCodes",null,"Y",null,null,null,null,null,"Isotope Code",13,4.43,"Vert","Centre",null,"Enabled",13,27]
[72,"ICR","Entry","FissileWeight","Fissile Weight","Conditional","Y","Decimal",0,null,0,3,12,null,"^[\\-]{0,1}\\d{0,%MXL}\\.{0,1}\\d{%MND,%MXD}$",null,null,null,null,null,null,null,null,"Weight Of\nFissile Isotope",14,21.43,"Horiz","Centre",null,"Enabled",14,28]
[73,"ICR","Entry","MaterialForm","Mateial Form","Conditional","Y","List",null,null,null,null,2,null,null,"MaterialFormCodes",null,"Y",null,null,null,null,"..,~BA,~BJ,~MF","Mateial Form",15,4.43,"Vert","Centre",null,"Enabled",15,14]
[74,"ICR","Entry","MaterialContainer","Material Container","Conditional","Y","List",null,null,null,null,1,null,null,"MaterialContainerCodes",null,"Y",null,null,null,null,"..,~BA,~BJ,~MF","Material Container",16,4.43,"Vert","Centre",null,"Enabled",16,15]
[75,"ICR","Entry","MaterialState","Material State","Conditional","Y","List",null,null,null,null,1,null,null,"MaterialStateCodes",null,"Y",null,null,null,null,"..,~BA,~BJ,~MF","Material State",17,4.43,"Vert","Centre",null,"Enabled",17,16]
[76,"ICR","Entry","Batch","Batch ID","Conditional","Y","Text",null,null,null,null,20,null,null,null,null,"Y",null,null,null,null,"..,~BA,~BJ,~MF","Name or No \nof Batch",18,19.29,"Horiz","Centre",null,"Enabled",18,11]
[77,"ICR","Entry","Items","Num Items","Conditional","Y","Integer",0,null,null,null,6,null,"^\\d{1,%MXL}$",null,null,null,null,null,null,null,"..,~BA,~BJ,~MF","No of items in Batch",19,5.57,"Vert","Centre",null,"Enabled",19,24]
[78,"ICR","Entry","PreviousBatch","Previous Batch","Conditional","Y","Text",null,null,null,null,20,null,null,null,null,"Y",null,null,null,null,"RB","Previous Batch",20,15,"Horiz","Centre",null,"Enabled",20,19]
[79,"ICR","Entry","ContainerID","Container ID","Optional","Y","Text",null,null,null,null,20,null,null,null,null,"Y",null,null,null,null,null,"Container ID",21,18.29,"Vert","Centre",null,"Enabled",21,34]
[80,"ICR","Entry","IsotopicComposition","Isotopic Composition","Optional","Y","List",null,null,null,null,130,null,null,"IsotopicCompositionCodes",null,"Y",null,null,null,null,null,"Isotopic Composition",22,5,"Vert","Centre",null,"Enabled",22,29]
[81,"ICR","Entry","AdvanceNotification","Advance Notification","Optional","Y","Text",null,null,null,null,8,null,null,null,null,"Y",null,null,null,null,"RD,RF,SD,SN,SF,^PR,^RB","Advance Notification",23,5,"Vert","Centre",null,"Enabled",23,42]
[82,"ICR","Entry","MBAFrom","From MBA","Conditional","Y","RegEx",null,null,null,null,4,null,"^(Q|[A-Z][A-Z0-9]{3})$",null,"four alphanumeric chars, or just \"Q\" where applicable","Y",null,null,null,null,"RD,RF,~PR","From MBA",24,5,"Vert","Centre",null,"Enabled",24,17]
[83,"ICR","Entry","MBATo","To MBA","Conditional","Y","RegEx",null,null,null,null,4,null,"^(Q|[A-Z][A-Z0-9]{3})$",null,"four alphanumeric chars, or just \"Q\" where applicable","Y",null,null,null,null,"SD,SF,~PR","To MBA",25,5,"Vert","Centre",null,"Enabled",25,18]
[84,"ICR","Entry","Reactor","Reactor","Optional","Y","Text",null,null,null,null,12,null,null,null,null,"Y",null,null,null,null,null,"Reactor",26,5,"Vert","Centre",null,"Enabled",26,44]
[85,"ICR","Entry","Campaign","Campaign","Optional","Y","Text",null,null,null,null,12,null,null,null,null,"Y",null,null,null,null,null,"Campaign",27,5,"Vert","Centre",null,"Enabled",27,43]
[86,"ICR","Entry","Burnup","Burnup","Optional","Y","Integer",1,null,null,null,12,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,"^NL,^NP","Burnup",28,5,"Vert","Centre",null,"Enabled",28,39]
[86,"ICR","Entry","ErrorPath","Error Path","Optional","Y","Text",null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"Error Path",30,5,"Vert","Centre",null,"Enabled",30,45]
[87,"ICR","Entry","Document","Document","Optional","Y","Text",null,null,null,null,70,null,null,null,null,"Y",null,null,null,null,null,"Document",31,25,"Horiz","Left","Y","Enabled",31,33]
[88,"ICR","Entry","Correction","Correction Type","Optional","N","List",null,null,null,null,1,null,null,"CorrectionTypes",null,"Y",null,null,null,null,null,"Correction Type",32,4.43,"Vert","Centre",null,"Correction",32,35]
[89,"ICR","Entry","PreviousReport","Previous Report","Conditional","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,"Previous Report Number",33,5.29,"Vert","Centre",null,"Correction",33,36]
[90,"ICR","Entry","OriginalDate","Original Date","Conditional","N","Date",null,{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,null,"Date of Original Entry",34,7.57,"Vert","Centre",null,"Correction",34,20]
[91,"ICR","Entry","PreviousLine","Previous Line","Conditional","N","Integer",1,null,null,null,8,null,"^[1-9][0-9]{0,%MXLM1}$",null,null,null,null,null,null,null,null,"Previous Line Number",35,5.29,"Vert","Centre",null,"Correction",35,37]
[92,"ICR","Entry","PreviousCRC","Previous CRC","Conditional","N","CRC",null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,"CRC of Previous Line",36,7,"Vert","Centre",null,"Correction",36,41]
[93,"ICR","Entry","Comment","Comment","Optional","Y","Text",null,null,null,null,256,null,null,null,null,null,null,null,null,null,null,"Comment",37,55.86,"Horiz","Left","Y","Enabled",37,38]
[94,"ICR","Entry","PITDate","PIT Date","Conditional","Y","Date","2021-01-01",{"$f":"TEXT(NOW(),\"DD/MM/YYYY\")","v":"02/12/2022"},null,null,8,null,null,null,null,null,null,null,null,null,"^MF","PIT Date",29,7.57,"Vert","Centre",null,"Enabled",29,21]

{"sheet":"Report","index":3,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,"Report Type",{"$f":"IF(Header_Data!B5=\"\",\"\",Header_Data!B5)","v":"P"}]
[null,null,"Material Balance Area",{"$f":"IF(Header_Data!C5=\"\",\"\",Header_Data!C5)","v":"Q???"}]
[null,null,"ReportNumber",{"$f":"IF(Header_Data!D5=\"\",\"\",Header_Data!D5)","v":""}]
[null,null,"PIT Date",{"$f":"IF(Header_Data!E5=\"\",\"\",Header_Data!E5)","v":""}]
[null,null,"Period From",{"$f":"IF(Header_Data!F5=\"\",\"\",Header_Data!F5)","v":""}]
[null,null,"Period to",{"$f":"IF(Header_Data!G5=\"\",\"\",Header_Data!G5)","v":""}]
[null,null,"Report Date",{"$f":"IF(Header_Data!H5=\"\",\"\",Header_Data!H5)","v":""}]
[null,null,"Reporter",{"$f":"IF(Header_Data!I5=\"\",\"\",Header_Data!I5)","v":""}]
[null,null,"Number of Lines",{"$f":"Header_Data!J5","v":0}]
[]
[null,"Line No","CRC","KMP Code","Obligation","Measurement Basis","Element Category","Weight Of\nElement","Isotope Code","Weight Of\nFissile Isotope","Mateial Form","Material Container","Material State","No of items in Batch","Name or No \nof Batch","Container ID","PIL Item ID","Correction Type","Previous Report Number","Previous Line Number","CRC of Previous Line","Comment"]
[null,"LineNumber","CRC","KMP","Obligation","Measurement","ElementCategory","ElementWeight","Isotope","FissileWeight","MaterialForm","MaterialContainer","MaterialState","Items","Batch","ContainerID","PIL_ITEM_ID","Correction","PreviousReport","PreviousLine","PreviousCRC","Comment"]
[]
[]
[null,"Current View : Auto"]

{"sheet":"Header_Data","index":4,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"tHeader : Header Data (managed entirely by the application)"]
[null,"ReportType","MBA","ReportNumber","PITDate","StartReport","EndReport","ReportDate","ReportingPerson","LineCount"]
[null,"P","Q???",null,"","","",""]

{"sheet":"Reference_Data","index":5,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["ReportTypes","ElementCodes","IsotopeCodes","ObligationCodes","MeasurementCodes","MaterialFormCodes","MaterialContainerCodes","MaterialStateCodes","CorrectionTypes","InventoryChangeCodesMBR","InventoryChangeCodesICR","IsotopicCompositionCodes"]
["I","D","G","A","E","AC","B","F","A","BA","BA","Pu-238"]
["M","H","J","C","F","AH","C","I","D","BJ","BJ","Pu-239"]
["P","L","K","D","G","AM","D","N","L","BR","BR","Pu-240"]
[null,"N",null,"F","H","AO","F","W",null,"CB","CB","Pu-241"]
[null,"P",null,"N","L","CO","O",null,null,"CC","CC","Pu-242"]
[null,"T",null,"P","M","CP","P",null,null,"CE","CE","U-233"]
[null,null,null,"Q","N","CS","S",null,null,"CR","CR","U-234"]
[null,null,null,"S","T","EA","T",null,null,"DI","DI","U-235"]
[null,null,null,"T",null,"EB",null,null,null,"FC","FC","U-236"]
[null,null,null,"W",null,"EO",null,null,null,"FW","FW","U-238"]
[null,null,null,"Y",null,"EP",null,null,null,"GA","GA"]
[null,null,null,null,null,"ER",null,null,null,"LA","LA"]
[null,null,null,null,null,"LF",null,null,null,"MF","MF"]
[null,null,null,null,null,"LN",null,null,null,"MP","MP"]
[null,null,null,null,null,"LO",null,null,null,"NL","NL"]
[null,null,null,null,null,"MA",null,null,null,"NM","NM"]
[null,null,null,null,null,"MP",null,null,null,"NP","NP"]
[null,null,null,null,null,"NB",null,null,null,"PB","PR"]
[null,null,null,null,null,"NC",null,null,null,"PE","R5"]
[null,null,null,null,null,"NG",null,null,null,"PR","RA"]
[null,null,null,null,null,"NO",null,null,null,"R5","RB"]
[null,null,null,null,null,"OR",null,null,null,"RA","RD"]
[null,null,null,null,null,"PH",null,null,null,"RD","RF"]
[null,null,null,null,null,"PN",null,null,null,"RF","RN"]
[null,null,null,null,null,"QS",null,null,null,"RN","SD"]
[null,null,null,null,null,"SH",null,null,null,"SD","SF"]
[null,null,null,null,null,"SN",null,null,null,"SF","SN"]
[null,null,null,null,null,"SS",null,null,null,"SN","SR"]
[null,null,null,null,null,"T2",null,null,null,"SR","TC"]
[null,null,null,null,null,"U2",null,null,null,"TC","TE"]
[null,null,null,null,null,"U3",null,null,null,"TE","TU"]
[null,null,null,null,null,"U4",null,null,null,"TU","TW"]
[null,null,null,null,null,"U6",null,null,null,"TW"]
[null,null,null,null,null,"U8"]
[null,null,null,null,null,"WH"]
[null,null,null,null,null,"WL"]
[null,null,null,null,null,"WM"]
[null,null,null,null,null,"YC"]