{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Menu","CFR Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Menu","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,1,21,12],[1,1,18,12],[0,1,0,12]]}
[null,"Instructions:"]
[null,"\nTo use this XML generator, copy and paste your data into the worksheet entitled 'CFR Data'.\n\nDo not change the order of the columns within the 'CFR Data' worksheet, ensure the first line of school data is on line 7 and there are no blank lines between schools.\n\nWhen you have finished entering the school data, ensure you have entered your LA number at the top of the 'CFR Data' worksheet, before you press the Generate XML button. One XML file will be generated for each line of data within the 'CFR Data' worksheet.\n\nThis XML generator must be saved to a local file location as it is unable to generate and save XML files directly to cloud based locations such as OneDrive.\n\nThe individual XML files will be saved to the same location as this workbook with the filenames nnnssss_CFR_nnnLLLL_vvv.xml, where:\nnnn is your LA number (picked up from the top of worksheet 'CFR Data')\nssss is the School number (picked from the first column on each data line)\nvvv is the serial number (picked up from the top of worksheet 'CFR Data')\n\nIf desired, you can then zip all the individual XML files into one zip file, for uploading to COLLECT using the Upload Multiple Returns (zip file) button.\n\nPlease note that all monetary figures must be to no more than 2 decimal places, otherwise the file will not load into COLLECT.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For further assistance or help with completing this workbook, please contact the DfE Data Operations Service Desk by raising a service request."]
[null,"data collections service request form"]

{"sheet":"CFR Data","index":1,"n_rows":6,"n_cols":93,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,25,4,45],[4,0,4,21],[4,22,4,24],[4,92,5,92],[4,46,4,78],[4,79,4,81],[4,82,4,86],[4,87,4,91]]}
[null,"LA Number"]
[null,"Serial Number",1]
[]
[]
["School Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opening Balances",null,null,"Income Fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure Fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Income",null,null,"Capital Expenditure",null,null,null,null,"Closing Balances",null,null,null,null,"Notepad Details"]
["School Number","School Name","Contact Name","Contact Email","Contact Phone","xFederated\nFlag\n(Yes/No)","FederationEstab1","FederationEstab2","FederationEstab3","FederationEstab4","FederationEstab5","FederationEstab6","FederationEstab7","FederationEstab8","FederationEstab9","FederationEstab10","Data Preparation\n(Y/N)","Data Version\n(Final/\nPreliminary)","Complete\n(Y/N)","xCash or Accruals","Rates Exempt\n(Y/N)","Insurance\n(Y/N)","OB01","OB02","OB03","I01","I02","I03","I04","I05","I06","I07","I08a","I08b","I09","I10","I11","I12","I13","I15","I16","I17","I18a","I18b","I18c","I18d","E01","E02","E03","E04","E05","E06","E07","E08","E09","E10","E11","E12","E13","E14","E15","E16","E17","E18","E19","E20","E21","E22","E23","E24","E25","E26","E27","E28a","E28b","E29","E30","E31","E32","CI01","CI03","CI04","De Minimis","CE01","CE02","CE03","CE04","B01","B02","B03","B05","B06"]