{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Pivots","FactorsList","DATA","RESULTS"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":7},"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[6,7,7,12]]}

{"sheet":"Pivots","index":1,"n_rows":4,"n_cols":44,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Sum of Counter","Column Labels",null,null,null,null,"Sum of base_ave","Column Labels",null,null,null,null,null,"Sum of rem_ave","Column Labels",null,null,null,null,null,"Sum of Counter","Column Labels",null,null,null,null,"Sum of base_ave","Column Labels",null,null,null,null,null,"Sum of rem_ave","Column Labels",null,null,null,null,null,"Sum of Counter","Column Labels"]
["Row Labels","Male","Female",null,null,null,"Row Labels","Male","Female","Pay Equity",null,null,null,"Row Labels","Male","Female","Pay Equity",null,null,null,"Row Labels","Male","Female",null,null,null,"Row Labels","Male","Female","Gap",null,null,null,"Row Labels","Male","Female","Gap",null,null,null,"Row Labels","F","M","Grand Total"]
["(blank)",1,0,null,null,null,"(blank)",1,"NA","NA",null,null,null,"(blank)",1,"NA","NA",null,null,null,"(blank)",1,1,null,null,null,"(blank)",1,1,1,null,null,null,"(blank)",1,1,1,null,null,null,"(blank)",1,1,2]
["Add data below",0,1,null,null,null,"Add data below","NA",1,"NA",null,null,null,"Add data below","NA",1,"NA"]

{"sheet":"FactorsList","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Manager/non manager categories",null,null,null,"Reporting level to CEO/head of business"]
["Graduate/apprentice\n\n",null,null,null,"Number of direct reports"]
["Full time/part time\n\n",null,null,null,"Overall tenure"]
["Permanent/contract/casual\n\n",null,null,null,"Role tenure"]
["Job title",null,null,null,"Number of years since last promotion"]
["Salary level",null,null,null,"Number of years since last parental leave"]
["Organisational unit",null,null,null,"Number of weeks taken last parental leave"]
["State",null,null,null,"Age"]
["Performance rating"]
["Gender of manager"]
["Highest qualification level"]
["Country of birth"]
["First language"]

{"sheet":"DATA","index":3,"n_rows":2,"n_cols":28,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee unique identifier","Manager/non manager categories","Reporting level to CEO/head of business","Gender\n\n","Graduate/apprentice\n\n","Full time/part time\n\n","Permanent/contract/casual\n\n","Base salary only\n","Total remuneration\n","Job title","Salary level","Organisational unit","State","Performance rating","Gender of manager","Number of direct reports","Overall tenure","Role tenure","Number of years since last promotion","Number of years since last parental leave","Number of weeks taken last parental leave","Highest qualification level","Age","Country of birth","First language","Counter",null,{"$f":"LOOKUP(2,1/(A:A<>\"\"),ROW(A:A))","v":1}]
[null,"Add data below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table2[[#This Row],[Employee unique identifier]]<>\"\",1,0)","v":0}]

{"sheet":"RESULTS","index":4,"n_rows":66,"n_cols":31,"rows_kept":66,"cut":false,"hidden":true,"merged":[[36,5,36,9],[36,10,36,20],[64,17,64,18],[64,2,64,4],[40,11,40,19],[40,0,40,7],[5,21,5,24],[4,5,4,7],[9,5,9,9],[9,10,9,20],[5,5,5,7],[4,21,4,24],[12,11,12,19],[12,0,12,6],[12,22,12,29],[65,28,65,29],[64,28,64,29],[64,23,64,26],[65,23,65,26],[38,12,38,14],[38,16,38,18],[64,5,64,6],[65,2,65,4],[64,12,64,15],[65,5,65,6],[65,12,65,15],[65,17,65,18],[40,22,40,31]]}
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(I5/I6,\"NA\")","v":"NA"},null,null,null,null,null,null,{"$f":"IFERROR(Z5/Z6,\"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Organisational gap of \"&IFERROR(ROUND((J3-1)*100,0),\"NA\")&\" %\"","v":"Organisational gap of NA %"},null,null,null,null,null,null,{"$f":"\"Organisational gap of \"& IFERROR(ROUND((Q3-1)*100,0),\"NA\")&\" %\"","v":"Organisational gap of NA %"}]
[null,null,null,null,null,"Average Female Base Salary",null,null,{"$f":"IFERROR(AVERAGEIF(DATA!D:D,\"F\",DATA!H:H),\"NA\")","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,"Average Female Remuneration",null,null,null,{"$f":"IFERROR(AVERAGEIF(DATA!D:D,\"F\",DATA!I:I),\"NA\")","v":"NA"}]
[null,null,null,null,null,"Average Male Base Salary",null,null,{"$f":"IFERROR(AVERAGEIF(DATA!D:D,\"M\",DATA!H:H),\"NA\")","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,"Average Male Remuneration",null,null,null,{"$f":"IFERROR(AVERAGEIF(DATA!D:D,\"M\",DATA!I:I),\"NA\")","v":"NA"}]
[]
[]
[]
[null,null,null,null,null,"Select a category:",null,null,null,null,"Manager/non manager categories"]
[]
[]
["Gender Composition by Manager/non manager categories",null,null,null,null,null,null,null,null,null,null,"Average Base Salary by Manager/non manager categories",null,null,null,null,null,null,null,null,null,null,"Average Total Remuneration by Manager/non manager categories"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Select a trend:",null,null,null,null,"Reporting level to CEO/head of business"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Female",null,null,null,"Male"]
[]
["Gender Composition by Reporting level to CEO/head of business",null,null,null,null,null,null,null,null,null,null,"Average Base Salary by Reporting level to CEO/head of business",null,null,null,null,null,null,null,null,null,null,"Average Total Remuneration by Reporting level to CEO/head of business"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"Female Average \"&K37","v":"Female Average Reporting level to CEO/head of business"},null,null,{"$f":"IFERROR(IF(gender_check=\"F\",SUM(IF(ISNUMBER(rem_factor_value)=TRUE, rem_factor_value*trend_female,0))/SUM(IF(ISNUMBER(rem_factor_value)=TRUE, trend_female,0))),\"NA\")","v":"NA"},null,null,null,null,null,null,"Maximum Pay Equity %",null,null,null,{"$f":"MAX(base_gap)","v":1},{"$f":"\"Average \"&K37&\" applicable\"","v":"Average Reporting level to CEO/head of business applicable"},null,{"$f":"IFERROR(SUM(IF(base_gap=Q65,rem_factor_count*rem_factor_value,0))/SUM(IF(base_gap=Q65,rem_factor_count,0)),\"NA\")","v":"NA"},null,null,null,"Maximum Pay Equity %",null,null,null,{"$f":"MAX(rem_gap)","v":1},{"$f":"\"Average \"&K37&\" applicable\"","v":"Average Reporting level to CEO/head of business applicable"},null,{"$f":"IFERROR(SUM(IF(rem_gap=AB65,rem_factor_count*rem_factor_value,0))/SUM(IF(rem_gap=AB65,rem_factor_count,0)),\"NA\")","v":"NA"}]
[null,null,{"$f":"\"Male Average \"&K37","v":"Male Average Reporting level to CEO/head of business"},null,null,{"$f":"IFERROR(IF(gender_check=\"F\",SUM(IF(ISNUMBER(rem_factor_value)=TRUE,rem_factor_value*trend_male,0))/SUM(IF(ISNUMBER(rem_factor_value)=TRUE,trend_male,0)),SUM(IF(ISNUMBER(rem_factor_value)=TRUE,rem_factor_value*trend_female,0))/SUM(IF(ISNUMBER(rem_factor_value)=TRUE,trend_female,0))),\"NA\")","v":"NA"},null,null,null,null,null,null,"Minimum Pay Equity %",null,null,null,{"$f":"MIN(base_gap)","v":1},{"$f":"\"Average \"&K37&\" applicable\"","v":"Average Reporting level to CEO/head of business applicable"},null,{"$f":"IFERROR(SUM(IF(base_gap=Q66,rem_factor_count*rem_factor_value,0))/SUM(IF(base_gap=Q66,rem_factor_count,0)),\"NA\")","v":"NA"},null,null,null,"Minimum Pay Equity %",null,null,null,{"$f":"MIN(rem_gap)","v":1},{"$f":"\"Average \"&K37&\" applicable\"","v":"Average Reporting level to CEO/head of business applicable"},null,{"$f":"IFERROR(SUM(IF(rem_gap=AB66,rem_factor_count*rem_factor_value,0))/SUM(IF(rem_gap=AB66,rem_factor_count,0)),\"NA\")","v":"NA"}]