{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data Input","Variable definitions","ED_UDG_Parameters"],"not_rendered":{"charts":0,"images":1,"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":"Data Input","index":0,"n_rows":101,"n_cols":5,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["RecordID","Pat_Indigenous_Flag","UDG v1.3 Code",null,"NWAU"]
["Record01",0,"UDG04"]
["Record02",0,"UDG03"]
["Record03",0,"UDG10"]
["Record04",0,"UDG09"]
["Record05",0,"UDG04"]
["Record06",1,"UDG10"]
["Record07",0,"UDG09"]
["Record08",0,"UDG09"]
["Record09",0,"UDG10"]
["Record10",0,"UDG03"]
["Record11",0,"UDG09"]
["Record12",0,"UDG09"]
["Record13",0,"UDG08"]
["Record14",0,"UDG09"]
["Record15",0,"UDG09"]
["Record16",0,"UDG11"]
["Record17",0,"UDG10"]
["Record18",0,"UDG08"]
["Record19",0,"UDG08"]
["Record20",1,"UDG09"]
["Record21",0,"UDG10"]
["Record22",0,"UDG08"]
["Record23",0,"UDG09"]
["Record24",0,"UDG10"]
["Record25",0,"UDG09"]
["Record26",0,"UDG08"]
["Record27",0,"UDG10"]
["Record28",0,"UDG10"]
["Record29",0,"UDG08"]
["Record30",0,"UDG09"]
["Record31",0,"UDG09"]
["Record32",0,"UDG10"]
["Record33",0,"UDG07"]
["Record34",0,"UDG09"]
["Record35",0,"UDG10"]
["Record36",0,"UDG10"]
["Record37",1,"UDG10"]
["Record38",0,"UDG09"]
["Record39",0,"UDG04"]
["Record40",0,"UDG10"]
["Record41",0,"UDG08"]
["Record42",0,"UDG09"]
["Record43",1,"UDG08"]
["Record44",0,"UDG09"]
["Record45",0,"UDG10"]
["Record46",0,"UDG03"]
["Record47",0,"UDG09"]
["Record48",0,"UDG09"]
["Record49",0,"UDG09"]
["Record50",0,"UDG09"]
["Record51",0,"UDG11"]
["Record52",0,"UDG08"]
["Record53",1,"UDG09"]
["Record54",0,"UDG02"]
["Record55",0,"UDG08"]
["Record56",0,"UDG10"]
["Record57",0,"UDG04"]
["Record58",0,"UDG09"]
["Record59",0,"UDG10"]
["Record60",0,"UDG10"]
["Record61",0,"UDG03"]
["Record62",0,"UDG04"]
["Record63",0,"UDG04"]
["Record64",1,"UDG10"]
["Record65",0,"UDG08"]
["Record66",0,"UDG07"]
["Record67",0,"UDG09"]
["Record68",0,"UDG07"]
["Record69",0,"UDG09"]
["Record70",1,"UDG03"]
["Record71",0,"UDG10"]
["Record72",0,"UDG09"]
["Record73",0,"UDG10"]
["Record74",1,"UDG09"]
["Record75",0,"UDG04"]
["Record76",0,"UDG08"]
["Record77",0,"UDG10"]
["Record78",0,"UDG10"]
["Record79",0,"UDG09"]
["Record80",0,"UDG08"]
["Record81",0,"UDG10"]
["Record82",0,"UDG09"]
["Record83",0,"UDG03"]
["Record84",0,"UDG10"]
["Record85",0,"UDG09"]
["Record86",0,"UDG02"]
["Record87",0,"UDG10"]
["Record88",0,"UDG08"]
["Record89",0,"UDG04"]
["Record90",0,"UDG09"]
["Record91",0,"UDG10"]
["Record92",0,"UDG09"]
["Record93",0,"UDG09"]
["Record94",0,"UDG03"]
["Record95",0,"UDG09"]
["Record96",0,"UDG09"]
["Record97",0,"UDG09"]
["Record98",0,"UDG09"]
["Record99",1,"UDG10"]
["Record100",0,"UDG08"]

{"sheet":"Variable definitions","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,3,15,3]]}
[]
[null,"Variable definitions reference sheet for Emergency Department Urgency Disposition Groups"]
[]
[null,"Name","Type","Description","Allowed values (where relevant)","Missing values","Comment"]
[null,"RecordID","Character or Numeric","Record Identifier",null,"Allowed","May be used to link NWAU values back to original data."]
[null,"Pat_Indigenous_Flag","Numeric","Used to flag patients as being of Aboriginal and/or Torres Strait Islander origin","0 - Patient not of Aboriginal or Torres Strait Islander origin\n1 - Patient of Aboriginal and/or Torres Strait Islander origin","Not allowed"]
[null,"UDG v1.3 Code","Character","5 character UDG: prefix of \"UDG\" followed by the standard UDG Code with a zero as a place holder prior to single digit UDG code.","UDG01 - Admitted Triage 1","Not allowed","Activity out of scope are assigned an NWAU of 0."]
[null,null,null,null,"UDG02 - Admitted Triage 2"]
[null,null,null,null,"UDG03 - Admitted Triage 3"]
[null,null,null,null,"UDG04 - Admitted Triage 4"]
[null,null,null,null,"UDG05 - Admitted Triage 5"]
[null,null,null,null,"UDG06 - Non-Admitted Triage 1"]
[null,null,null,null,"UDG07 - Non-Admitted Triage 2"]
[null,null,null,null,"UDG08 - Non-Admitted Triage 3"]
[null,null,null,null,"UDG09 - Non-Admitted Triage 4"]
[null,null,null,null,"UDG10 - Non-Admitted Triage 5"]
[null,null,null,null,"UDG11 - Did Not Wait "]
[null,null,null,null,"UDG12 - Dead on Arrival w any Triage w any MDB"]
[null,null,null,null,"UDG13 - Transfer Presentation"]
[null,null,null,null,"UDG14 - Died in ED"]
[null,null,null,null,"UDG15 - Admitted Return Visit, Planned - Any Triage"]
[null,null,null,null,"UDG16 - Non-Admitted Return Visit, Planned - Triage 1, 2, 3"]
[null,null,null,null,"UDG17 - Non-Admitted Return Visit, Planned - Triage 4, 5"]

{"sheet":"ED_UDG_Parameters","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["UDG v1.3 Code","UDG v1.3","Description","Price Weights"]
["UDG01",1,"Admitted Triage 1",0.35110000000000002]
["UDG02",2,"Admitted Triage 2",0.24929999999999999]
["UDG03",3,"Admitted Triage 3",0.21560000000000001]
["UDG04",4,"Admitted Triage 4",0.17749999999999999]
["UDG05",5,"Admitted Triage 5",0.1381]
["UDG06",6,"Non-Admitted Triage 1",0.30840000000000001]
["UDG07",7,"Non-Admitted Triage 2",0.18190000000000001]
["UDG08",8,"Non-Admitted Triage 3",0.1285]
["UDG09",9,"Non-Admitted Triage 4",8.14E-2]
["UDG10",10,"Non-Admitted Triage 5",5.1900000000000002E-2]
["UDG11",11,"Did Not Wait ",3.1899999999999998E-2]
["UDG12",12,"Dead on Arrival w any Triage w any MDB",5.2499999999999998E-2]
["UDG13",13,"Transfer Presentation",0.18290000000000001]
["UDG14",14,"Died in ED",0.2218]
["UDG15",15,"Admitted Return Visit, Planned - Any Triage",0.12509999999999999]
["UDG16",16,"Non-Admitted Return Visit, Planned - Triage 1, 2, 3",0.1081]
["UDG17",17,"Non-Admitted Return Visit, Planned - Triage 4, 5",5.6000000000000001E-2]