{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Read me","drglogic","dg","proc","compl. cat.","compl. excl","drgnames","dg categ","dg prop","princ. dg. prop","proc prop","NCSP+","ICD+","testdata"],"not_rendered":{"defined_names":23},"read":"whole","date_system":"1900"}

{"sheet":"Read me","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"merged":[[5,0,5,1],[6,0,6,1]]}
["Case"]
["NCC ID"]
["NCC Comment"]
["National ID"]
["National Comment"]
["Read me"]
["This file should be used for the description of any probosal for change in NordDRG.\nThe changes of all aspects of NordDRG defintion can be described on these tables. The structure follows the structure of the defintion tables. \nThe NordDRG Maintenance System (NDMS) will produce report of changes which can be easily compared with these tables. \nEach case should be described on its own Excel book so that this table format description can be attached to the textual NordDRG forum presentation of the case. The textual format of the NordDRG forum is described in Word format in a separate document.\nUnnecessary (empty) sheets will be deleted to ease tha handling of the tables on NordDRG Forum.\nAll table format descriptions of all accepted and confirmed changes will be combined to a one summary table. For this reason each line should have the ID of the case included.\nNote!! Only changes are reported in these tables, unchanged proberties are not included!\nContent of each sheet in this table (character 'x' refers to number in a code):"]
[]
["drglogic","Logical decission rules\nNew rules are marked IN\ndeleted rules are marked OUT\nAny change of a rule should appear twice - the old rule is marked OUT and the modified rule IN\nNote!! All new properties must appear in the following tables! Defintions that have properties that do not exist for any diagnosis or intervention, are not included in the defintion tables"]
[]
["dg","Properties of interventions\nNew properties are marked IN\nDeleted properties are marked OUT\nThe variable vartype indicates which property is defined. They can be:\nDGKAT (Diagnosis category), DGOMIN (diagnosis property), PDGOMIN (principal diagnosis property), KOMPKAT (Complication category). \nAutomatically generated properties are not necessary. This includes MDC and diagnosis properties ending ..X99. "]
[]
["proc","Properties of interventions\nNew properties are marked IN\nDeleted properties are marked OUT\nThe variable vartype indicates which property is defined. They can be:\nTPOMIN (procedure property), DGOMIN (diagnosis property), OR (Operation room property - 0/1/2), CC (CC-property - 0/1)"]
[]
["kompkat","Complications categories\nNew categories are marked IN\nOld categories are marked OUT"]
[]
["komplex","Exclusions to complications categories\nExclusions are defined by diagnosis i.e. for each diagnosis the komplex table defines the complication categories that cannot complicate that diagnosis when the diagnosis is used as principal diagnosis. \nNote!! Each diagnosis may be excluded for severel complication categories\nNew exclusions are marked IN\nOld exclusions are marked OUT"]
[]
["drgnames","Names of the DRG's\nNational language version are the responsibility of the national organizations, english versions are the responsibility of the Nordic Casemix Centre. \nNew exclusions are marked IN\nOld exclusions are marked OUT"]
[]
["dg categ","Types of diagnosis categories (vartype DGKAT in dg-table, variable dgkat and mdc in drglogic-table)\nNew categories are marked IN\nA category with changed name must appear twice in this table - the row with the old name is marked OUT and the row with the modified name with IN\nNote! Diagnosis categories are not deleted. Categories not in use will disappear from defintion tables but remain in the NDMS system tables\nNote! Changes in major diagnosis categories are included in this table. Their coding has only two characters (xx). "]
[]
["dg prop","Types of  diagnosis properties (vartype PDGPROP in dg-table, variable pdgprop in drglogic-table)\nNew properties are marked IN\nA property with changed name must appear twice in this table - the row with the old name is marked OUT and the row with the modified name with IN\nNote! Principal diagnosis properties are not deleted. Properties not in use will disappear from defintion tables but remain in the NDMS system tables"]
[]
["princ dg prop","Types of principal diagnosis properties (vartype PDGPROP in dg-table, variable pdgprop in drglogic-table)\nNew properties are marked IN\nA property with changed name must appear twice in this table - the row with the old name is marked OUT and the row with the modified name with IN\nNote! Principal diagnosis properties are not deleted. Properties not in use will disappear from defintion tables but remain in the NDMS system tables"]
[]
["NCSP+","The affected NCSP+ codes\nMay include new codes, inactivated codes or related codes in other national versions. "]
[]
["ICD+","The affected ICD+ codes\nMay include new codes, inactivated codes or related codes in other national versions. "]
[]
["testdata","Examples of cases using the changed logic\nThis table should include typical cases that are affected by the (proposed) change of the grouper. \nNDMS system reports changes in the testdata with this structure. The first 5 columns (id - oldord) are for this purpose and do not need to be filled. The other varialbes are:\nage - age in days\nsex - M for male/F for female\ndeath - F(alse)/T(ruth)\nlama - left against medical advice - old variable, not in use \nrem - remitted patient - F(alse)/T(ruth)\ndisch - not in use\ndur - duration of stay. 0-for outpatient, 1-x for inpatient\nman1-9 - manifestation codes for diagnosis. Note!! if the diagnosis is coded with only one ICD-10 code (as usual) these are to be used\neti1-9 - etiological codes for diagnosis (used only for code pairs)\nint1-9 - intervention codes - Note!! both NCSP+ and national CSP codes may be used"]

{"sheet":"drglogic","index":1,"n_rows":1,"n_cols":28,"rows_kept":1}
["IN/OUT","Id","ord","nat_ver","drg","english","rtc","icd","mdc","pdgprop","or","procpro1","dgcat1","agelim","compl","sex","dgprop1","dgprop2","dgprop3","dgprop4","secproc1","disch","dur","loc_drg","NCC ID","National ID","NCC comment","National comment"]

{"sheet":"dg","index":2,"n_rows":1,"n_cols":11,"rows_kept":1}
["IN/OUT","code","d_code","icd_text","vartype","varval","text","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"proc","index":3,"n_rows":1,"n_cols":10,"rows_kept":1}
["IN/OUT","code","csp_text","vartype","varval","text","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"compl. cat.","index":4,"n_rows":1,"n_cols":9,"rows_kept":1}
["IN/OUT","compl","english","inclprop","proptext","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"compl. excl","index":5,"n_rows":1,"n_cols":10,"rows_kept":1}
["IN/OUT","compl","english","code","d_code","text","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"drgnames","index":6,"n_rows":1,"n_cols":12,"rows_kept":1}
["IN/OUT","drg","mdc","text - english","short text - english","text - national language","short text - national language","NDMS_drg","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"dg categ","index":7,"n_rows":1,"n_cols":7,"rows_kept":1}
["IN/OUT","dgcat","text","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"dg prop","index":8,"n_rows":1,"n_cols":7,"rows_kept":1}
["IN/OUT","dgprop","text","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"princ. dg. prop","index":9,"n_rows":1,"n_cols":7,"rows_kept":1}
["IN/OUT","pdgprop","text","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"proc prop","index":10,"n_rows":1,"n_cols":8,"rows_kept":1}
["IN/OUT","procprop","text","extens","NCC ID","NCC comment","National ID","National comment"]

{"sheet":"NCSP+","index":11,"n_rows":1,"n_cols":12,"rows_kept":1}
["IN/OUT","ORD","NCSP","TEXT","CODE_DEN","CODE_EST","CODE_FIN","CODE_ICE","CODE_NOR","CODE_SWE","CODE_LAT","Properties"]

{"sheet":"ICD+","index":12,"n_rows":1,"n_cols":22,"rows_kept":1}
["IN/OUT","ORD","GROUP","DEC","CODE","AST","WHO","TEXT","USEDATE","RELEASED","RELDATE","PRIM","HEADLINE","CODE_WHO","CODE_FIN","CODE_SWE","CODE_NOR","CODE_DEN","CODE_EST","CODE_LAT","CODE_ICE","Properties"]

{"sheet":"testdata","index":13,"n_rows":1,"n_cols":43,"rows_kept":1}
["id","drg","ord","ika","sex","death","lama","rem","disch","dur","man1","eti1","man2","eti2","man3","eti3","man4","eti4","man5","eti5","man6","eti6","man7","eti7","man8","eti8","man9","eti9","int1","int2","int3","int4","int5","int6","int7","int8","int9","drg_ext","ord_ext","NCC ID","NCC comment","National ID","National comment"]