{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Import","Detail","Export","EarnieIQ"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Import","index":0,"n_rows":2,"n_cols":21,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,2,0,16],[0,17,0,20]]}
["Import",null,"Please enter / paste payroll data here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Only use these columns for pay periods not fully covered by claim period"]
["Emp Code","Emp Name","NINo","NI Letter","Period No","Pay Freq","Employee's Furlough Start Date","Employee's Furlough End Date","Pay Period Start Date","Pay Period End Date","Furlough Payments  (£)","Furlough Hours in Pay Period","Pay for Furlough Hours in Pay Period (£)","Part Time Furlough Hours in Pay Period","Pay for Part Time Furlough Hours in Pay Period (£)","ER's NI","ER Pension","Furlough Hours in Claim Period","Pay for Furlough Hours in Claim Period (£)","Part Time Furlough Hours in Claim Period","Pay for Part Time Furlough Hours in Claim Period (£)"]

{"sheet":"Detail","index":1,"n_rows":10,"n_cols":46,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,39,8,43],[1,8,1,11],[2,8,2,11],[8,0,8,6],[8,8,8,20],[8,32,8,37],[8,22,8,30]]}
[null,"Furlough Calculator (Phase 2 Version 1.29)"]
["","Company :",null,null,null,null,null,null,"Columns headed in blue are calculated for you"]
[null,"Claim Start :",null,null,null,null,null,null,"Columns headed in red are calculated claim results"]
[null,"Claim End :"]
[null,"Days in Claim Period:"]
[null,"Output File Path:"]
[null,"Export File Name:"]
[]
["Employee Details",null,null,null,null,null,null,null,"Pay Period Values",null,null,null,null,null,null,null,null,null,null,null,null,null,"Claim Period Values",null,null,null,null,null,null,null,null,null,"NI Claim",null,null,null,null,null,null,"Pension Claim"]
["Employee Code","Employee Name","National Insurance No","Period No","Pay Freq","Employee's Furlough Start Date","Employee's Furlough End Date",null,"Pay Period Start Date","Pay Period End Date","Days in pay period","Employee Furloughed For Full Pay Period (Y/N)","Furlough Days in Pay Period",null,"Furlough Payments","Furlough Hours in Pay Period","Pay for Furlough Hours in Pay Period (£)","Part Time Furlough Hours in Pay Period","Pay for Part Time Furlough Hours in Pay Period (£)","Total Furlough (up to Limit)","Full Time Furlough Limit"," ","First Claimable Date In Pay Period","Last Claimable Date In Pay Period","Furlough Days in Claim Period","Furlough Hours in Claim Period","Pay for Furlough Hours in Claim Period (£)","Part Time Furlough Hours in Claim Period","Pay for Part Time Furlough Hours in Claim Period (£)","Furlough Reclaim","Claim Limit at 70%",null,"NI Letter","ER's NI","Secondary Threshold ","Apportioned Threshold","Claimable NiAble Pay","NI Reclaim",null,"ER's Pension","Qualifying Earnings Lower Threshold","Apportioned Threshold","Claimable Pensionable Pay","Pension Reclaim",null,"Total Reclaim"]

{"sheet":"Export","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,9]]}
["Export"]
["Employee Name","NINO","Payroll Reference Number","Furlough Start Date","Furlough End Date","Employee Claim Amount","Normal Hours (furlough added together)","Actual Hours (PartTime Worked)","Furlough Hours (Non Worked)","Statutory Leave Returner"]

{"sheet":"EarnieIQ","index":3,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,10]]}
["Remember to copy the macro and make this sheet hidden"]
["Database :"]
["Server Name :"]