{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["read_me","drg_logic","dg_feat","proc_feat","compl_excl","compl_name","drg_name","mdc_name","dgcat_name","dgprop_name","pdgprop_name","procprop_name","rtc","dg","proc"],"not_rendered":{"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"read_me","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"merged":[[7,0,7,1],[8,0,8,1]]}
["Case title"]
["NCC ID"]
["NCC Comment"]
["National ID"]
["National Comment","Can be a very short summary of the proposed changes"]
["Name of Combined version to change"]
["Name of National version to change"]
["Instructions"]
["This file should be used for the description of any proposal 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 definition 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.\nUnnecessary (empty) tabs are deleted before publishing on NordDRG Forum but they must be retained in the TC for the Swedish NordDRG Admin and then tabs containing change instructions shall be colored. \nAll table format descriptions of all accepted and confirmed changes will later be combined to a one summary table. For this reason each line must have at least the national ID of the case included, but also the NCC ID (= the Forum ticket/case number) if it is known. \nNote!! With the exception of table drg_logic (see below), only changes are reported in these tables. Unchanged properties or codes are not included!\nAny change of a rule/property/code etc. must appear twice - the old rule/property/code is marked OUT and the modified rule/property/code is marked IN.\nA short summary of the changes in each table can be written on the rows below. The existing text shall then be deleted."]
["drg_logic","Logical decision rules\nNew rules are marked IN, deleted rules are marked OUT.\nAlso, any change of a rule must appear twice - the original rule is marked OUT and the modified rule is marked IN.\nFor easier understanding of the suggested position of a new rule, the rule above and the rule below can be inserted, but the field 'in/out' must then have a dashed line. Note!! All such rows must be deleted in the TC for the Swedish NordDRG Admin. \nIf the change is just a minor error correction of the content of the rule, the ORD and ID of the rule can be reused. Otherwise new values must be entered. The ORD value can be preliminary but must be written so that the rule comes on the right place in the hierarcy. A definite value will later be constructed in NDMS according to a special algorithm.\nNote!! All new properties must appear in the following tables! Defintions that have properties that do not exist for any diagnosis or intervention, will not be included in the defintion tables"]
["dg_feat","Properties of diagnoses\nNew properties are marked IN, deleted properties are marked OUT.\nThe variable vartype indicates which property is defined. They can be:\nMDC (major diagnosis category), DGCAT (diagnosis category), DGPROP (diagnosis property), PDGPRO (principal diagnosis property), SDGPRO (second diagnosis property), COMPL (complication category). "]
["proc_feat","Properties of interventions\nNew properties are marked IN, deleted properties are marked OUT.\nThe variable vartype indicates which property is defined. They can be:\nPROCPR (procedure property), DGPROP (diagnosis property), OR (operation room property), CC (complication or comorbidity property)"]
["compl_excl","Exclusions to complication categories\nExclusions are defined by diagnosis, i.e. for each diagnosis the compl_excl 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 several complication categories\nNew exclusions are marked IN, old exclusions are marked OUT."]
["compl_name","Names of the complication categories\nNew categories are marked IN, old categories are marked OUT.\nAlso, any change of the name of the category must appear twice - the row with the original name is marked OUT and the row with the new name is marked IN."]
["drg_name","Names of the DRGs\nNational language version are the responsibility of the national organizations, english versions are the responsibility of the Nordic Casemix Centre. \nNew DRGs are marked IN, old DRGs are marked OUT.\nAlso, any change of the name of a DRG must appear twice - the row with the original name is marked OUT and the row with the new name is marked IN."]
["mdc_name","Names of the MDCs\nNational language version are the responsibility of the national organizations, english versions are the responsibility of the Nordic Casemix Centre. \nNew MDCs are marked IN, old MDCs are marked OUT.\nAlso, any change of the name of a MDC must appear twice - the row with the original name is marked OUT and the row with the new name is marked IN."]
["dgcat_name","Names of diagnosis categories (vartype DGCAT in dg_feat table and dgcat in drg_logic table)\nNew categories are marked IN and old categories that shall not be used any more are marked OUT.\nAlso, any change of the name of the category must appear twice - the row with the original name is marked OUT and the row with the new name is marked 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 (MDC) are included in this table. Their coding has only two characters (numbers). "]
["dgprop_name","Names & types of  diagnosis properties (vartype DGPROP and SDGPRO in dg_feat table, DGPROP in proc_feat table and dgprop1-4 in drg_logic table)\nNew properties are marked IN and old properties that shall not be used any more are marked OUT.\nAlso, any change of the name of the property must appear twice - the row with the original name is marked OUT and the row with the new name is marked IN.\nNote! Diagnosis properties are not deleted. Properties not in use will disappear from defintion tables but remain in the NDMS system tables"]
["pdgprop_name","Names of principal diagnosis properties (vartype PDGPRO in dg_feat table and variable pdgprop in drg_logic table)\nNew properties are marked IN and old properties that shall not be used any more are marked OUT.\nAlso, any change of the name of the property must appear twice - the row with the original name is marked OUT and the row with the new name is marked IN.\nNote! Principal diagnosis properties are not deleted. Properties not in use will disappear from defintion tables but remain in the NDMS system tables"]
["procprop_name","Names of procedure properties (vartype PROCPR in proc_feat table and variable procpro & secpro in drg_logic table)\nNew properties are marked IN and old properties that shall not be used any more are marked OUT.\nAlso, any change of the name of the property must appear twice - the row with the original name is marked OUT and the row with the new name is marked IN.\nNote! Procedure properties are not deleted. Properties not in use will disappear from defintion tables but remain in the NDMS system tables"]
["rtc","Names of the return codes\nNational language version are the responsibility of the national organizations, english versions are the responsibility of the Nordic Casemix Centre. \nNew codes are marked IN, old codes are marked OUT.\nAlso, any change of the name of a return code must appear twice - the row with the original name is marked OUT and the row with the new name is marked IN."]
["dg","All valid diagnoses with national codes and ICD+ codes (including national and english code texts)\nNew codes are marked IN and codes not valid any more are marked OUT.\nAlso, any change of the code text must appear twice - the row with the original text is marked OUT and the row with the new text is marked IN.\nNote! Codes that are removed from the primary classifications are retained in NordDRG for five years but the code text must be changed. \"Inactivated at dd.mm.yyyy - \" must be added in the beginning of the code text. "]
["proc","All valid surgical and medical procedures with national codes and ICD+ codes (including national and english code texts)\nNew codes are marked IN and codes not valid any more are marked OUT.\nAlso, any change of the code text must appear twice - the row with the original text is marked OUT and the row with the new text is marked IN.\nNote! Codes that are removed from the primary classifications are retained in NordDRG for five years but the code text must be changed. \"Inactivated at dd.mm.yyyy - \" must be added in the beginning of the code text. "]

{"sheet":"drg_logic","index":1,"n_rows":2,"n_cols":28,"rows_kept":2}
[]
["version to change","in/out","ord","id","drg_nat","drg_text_nat","drg_comb","rtc","icd","mdc","dgcat","pdgprop","compl","or_proc","procpro","secpro","dgprop1","dgprop2","dgprop3","dgprop4","agelim","sex","dur","disch","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"dg_feat","index":2,"n_rows":2,"n_cols":19,"rows_kept":2}
[]
["version to change","in/out","code_nat","d_code_nat","text_nat","d_text_nat","code_plus","d_code_plus","text_plus","d_text_plus","vartype","varval","prop_0","varval_text_nat","varval_text_comb","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"proc_feat","index":3,"n_rows":2,"n_cols":16,"rows_kept":2}
[]
["version to change","in/out","code_nat","text_nat","code_plus","text_plus","vartype","varval","or_val","prop_0","varval_text_nat","varval_text_comb","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"compl_excl","index":4,"n_rows":2,"n_cols":18,"rows_kept":2}
[]
["version to change","in/out","vartype","varval","varval_text_nat","varval_text_comb","code_nat","d_code_nat","text_nat","d_text_nat","code_plus","d_code_plus","text_plus","d_text_plus","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"compl_name","index":5,"n_rows":2,"n_cols":10,"rows_kept":2}
[]
["version to change","in/out","compl","inclprop","varval_text_nat","varval_text_comb","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"drg_name","index":6,"n_rows":2,"n_cols":13,"rows_kept":2}
[]
["version to change","in/out","drg_nat","drg_text_nat","drg_text_short_nat","drg_comb","drg_text_comb","drg_text_short_comb","mdc","country","ncc_id","nat_id","comments"]

{"sheet":"mdc_name","index":7,"n_rows":2,"n_cols":9,"rows_kept":2}
[]
["version to change","in/out","mdc","mdc_text_nat","mdc_text_comb","country","ncc_id","nat_id","comments"]

{"sheet":"dgcat_name","index":8,"n_rows":2,"n_cols":9,"rows_kept":2}
[]
["version to change","in/out","dgcat","varval_text_nat","varval_text_comb","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"dgprop_name","index":9,"n_rows":2,"n_cols":9,"rows_kept":2}
[]
["version to change","in/out","dgprop","varval_text_nat","varval_text_comb","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"pdgprop_name","index":10,"n_rows":2,"n_cols":9,"rows_kept":2}
[]
["version to change","in/out","pdgprop","varval_text_nat","varval_text_comb","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"procprop_name","index":11,"n_rows":2,"n_cols":10,"rows_kept":2}
[]
["version to change","in/out","procprop","varval_text_nat","varval_text_comb","extens","nat_ver","ncc_id","nat_id","comments"]

{"sheet":"rtc","index":12,"n_rows":2,"n_cols":9,"rows_kept":2}
[]
["version to change","in/out","rtc_code","rtc_text_nat","rtc_text_comb","country","ncc_id","nat_id","comments"]

{"sheet":"dg","index":13,"n_rows":2,"n_cols":16,"rows_kept":2}
[]
["version to change","in/out","code_nat","d_code_nat","text_nat","d_text_nat","code_plus","d_code_plus","text_plus","d_text_plus","ast","country","code_type","ncc_id","nat_id","comments"]

{"sheet":"proc","index":14,"n_rows":2,"n_cols":11,"rows_kept":2}
[]
["version to change","in/out","code_nat","text_nat","code_plus","text_plus","country","code_type","ncc_id","nat_id","comments"]