{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Karte","Daten"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"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":"Karte","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Daten","index":1,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,4,33,8]]}
["Bezirk","Wert",null,null,null,"Referenz","Bereich","min.","Bezeichnung"]
["Bucheggberg",123,null,null,null,null,"0-2",0,"cls_0",null,"active Reg","Wasseramt","actReg"]
["Dorneck",12,null,null,null,null,"3-10",3,"cls_1",null,"Value",{"$f":"VLOOKUP(actReg,A2:B110,2,FALSE)","v":15},"actRegValue"]
["Gäu",1,null,null,null,null,"11-15",11,"cls_2",null,"Code",{"$f":"VLOOKUP(actRegValue,clsvalues,2,TRUE)","v":"cls_2"},"actRegCode"]
["Gösgen",4,null,null,null,null,"16-20",16,"cls_3"]
["Lebern",5,null,null,null,null,"20-30",20,"cls_4"]
["Olten",6,null,null,null,null,"31",31,"cls_5"]
["Solothurn",7,null,null,null,null,"32-35",32,"cls_6"]
["Thal",8,null,null,null,null,"36-40",36,"cls_7"]
["Thierstein",9,null,null,null,null,"41-50",41,"cls_8"]
["Wasseramt",15,null,null,null,null,"51-55",51,"cls_9"]
[null,null,null,null,null,null,"56-60",56,"cls_10"]
[null,null,null,null,null,null,"61-65",61,"cls_11"]
[null,null,null,null,null,null,"66-70",66,"cls_12"]
[null,null,null,null,null,null,"70-75",70,"cls_13"]
[null,null,null,null,null,null,"76-80",76,"cls_14"]
[null,null,null,null,null,null,"81-85",81,"cls_15"]
[null,null,null,null,null,null,"86-90",86,"cls_16"]
[null,null,null,null,null,null,"91-95",91,"cls_17"]
[null,null,null,null,null,null,"96-100",96,"cls_18"]
[null,null,null,null,null,null,"101-105",101,"cls_19"]
[null,null,null,null,null,null,"106-110",106,"cls_20"]
[null,null,null,null,null,null,"111-200",111,"cls_21"]
[]
[]
[]
[]
[]
[null,null,null,null,"Vorgehen:"]
[null,null,null,null,"1. statistische Werte pro Gemeinde in der Spalte B eintragen"]
[null,null,null,null,"2. Wertebereiche für die Einfärbung definieren (Spalte G)"]
[null,null,null,null,"3. kleinster Wert der jeweiligen Bereiche in der Spalte H eintragen"]
[null,null,null,null,"4. Farben für die Bereiche festlegen (Spalte F)"]
[null,null,null,null,"5. Makro ausführen (Entwicklertools > Code > Makros > Makro 2 > ausführen oder Tastenkombination: Ctrl +m)"]