{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["Action plan","ToDos","Baden-Württemberg2011","EMAIL_dist_list","Manual","Tabelle1"],"not_rendered":{"images":1,"external_links":2,"defined_names":5,"comments":7},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Action plan","index":0,"n_rows":88,"n_cols":96,"rows_kept":88,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7]],"flags":["formulas_cached_only"]}
[null,"Last updated","Today",null,"Total Days:",205,"X =  Progress at Review",null,"","","","2010-12-03","","","","","2011-01-07","","","","2011-02-04","","","","2011-03-04","","","","2011-04-01","","","","","2011-05-06","","","","2011-06-03","","","","2011-07-01","","","","","2011-08-05","","","","2011-09-02","","","","","2011-10-07","","","","2011-11-04","","","","2011-12-02","","","","","2012-01-06","","","","2012-02-03","","","","2012-03-02","","","","","2012-04-06","","","","2012-05-04","","","","2012-06-01","","","",""]
[null,"2011-03-01","2011-07-07",null,"Total Workdays:",{"$nulls":3},"","","","2010-12-03","","","","","2011-01-07","","","","2011-02-04","","","","2011-03-04","","","","2011-04-01","","","","","2011-05-06","","","","2011-06-03","","","","2011-07-01","","","","","2011-08-05","","","","2011-09-02","","","","","2011-10-07","","","","2011-11-04","","","","2011-12-02","","","","","2012-01-06","","","","2012-02-03","","","","2012-03-02","","","","","2012-04-06","","","","2012-05-04","","","","2012-06-01","","","","","Partner","Budget"]
[null,"PV - Anlage ","Owner","Due Date","Start","Days","Status","Comment",{"v":45,"d":"w45"},{"v":46,"d":"w46"},{"v":47,"d":"w47"},{"v":48,"d":"w48"},{"v":49,"d":"w49"},{"v":50,"d":"w50"},{"v":51,"d":"w51"},{"v":52,"d":"w52"},{"v":1,"d":"w1"},{"v":2,"d":"w2"},{"v":3,"d":"w3"},{"v":4,"d":"w4"},{"v":5,"d":"w5"},{"v":6,"d":"w6"},{"v":7,"d":"w7"},{"v":8,"d":"w8"},{"v":9,"d":"w9"},{"v":10,"d":"w10"},{"v":11,"d":"w11"},{"v":12,"d":"w12"},{"v":13,"d":"w13"},{"v":14,"d":"w14"},{"v":15,"d":"w15"},{"v":16,"d":"w16"},{"v":17,"d":"w17"},{"v":18,"d":"w18"},{"v":19,"d":"w19"},{"v":20,"d":"w20"},{"v":21,"d":"w21"},{"v":22,"d":"w22"},{"v":23,"d":"w23"},{"v":24,"d":"w24"},{"v":25,"d":"w25"},{"v":26,"d":"w26"},{"v":27,"d":"w27"},{"v":28,"d":"w28"},{"v":29,"d":"w29"},{"v":30,"d":"w30"},{"v":31,"d":"w31"},{"v":32,"d":"w32"},{"v":33,"d":"w33"},{"v":34,"d":"w34"},{"v":35,"d":"w35"},{"v":36,"d":"w36"},{"v":37,"d":"w37"},{"v":38,"d":"w38"},{"v":39,"d":"w39"},{"v":40,"d":"w40"},{"v":41,"d":"w41"},{"v":42,"d":"w42"},{"v":43,"d":"w43"},{"v":44,"d":"w44"},{"v":45,"d":"w45"},{"v":46,"d":"w46"},{"v":47,"d":"w47"},{"v":48,"d":"w48"},{"v":49,"d":"w49"},{"v":50,"d":"w50"},{"v":51,"d":"w51"},{"v":52,"d":"w52"},{"v":1,"d":"w1"},{"v":2,"d":"w2"},{"v":3,"d":"w3"},{"v":4,"d":"w4"},{"v":5,"d":"w5"},{"v":6,"d":"w6"},{"v":7,"d":"w7"},{"v":8,"d":"w8"},{"v":9,"d":"w9"},{"v":10,"d":"w10"},{"v":11,"d":"w11"},{"v":12,"d":"w12"},{"v":13,"d":"w13"},{"v":14,"d":"w14"},{"v":15,"d":"w15"},{"v":16,"d":"w16"},{"v":17,"d":"w17"},{"v":18,"d":"w18"},{"v":19,"d":"w19"},{"v":20,"d":"w20"},{"v":21,"d":"w21"},{"v":22,"d":"w22"},{"v":23,"d":"w23"},{"v":24,"d":"w24"},{"v":25,"d":"w25"},{"v":26,"d":"w26"}]
[null,"Mgmt. Owner:",{"$nulls":6},"2010-11-12","2010-11-19","2010-11-26","2010-12-03","2010-12-10","2010-12-17","2010-12-24","2010-12-31","2011-01-07","2011-01-14","2011-01-21","2011-01-28","2011-02-04","2011-02-11","2011-02-18","2011-02-25","2011-03-04","2011-03-11","2011-03-18","2011-03-25","2011-04-01","2011-04-08","2011-04-15","2011-04-22","2011-04-29","2011-05-06","2011-05-13","2011-05-20","2011-05-27","2011-06-03","2011-06-10","2011-06-17","2011-06-24","2011-07-01","2011-07-08","2011-07-15","2011-07-22","2011-07-29","2011-08-05","2011-08-12","2011-08-19","2011-08-26","2011-09-02","2011-09-09","2011-09-16","2011-09-23","2011-09-30","2011-10-07","2011-10-14","2011-10-21","2011-10-28","2011-11-04","2011-11-11","2011-11-18","2011-11-25","2011-12-02","2011-12-09","2011-12-16","2011-12-23","2011-12-30","2012-01-06","2012-01-13","2012-01-20","2012-01-27","2012-02-03","2012-02-10","2012-02-17","2012-02-24","2012-03-02","2012-03-09","2012-03-16","2012-03-23","2012-03-30","2012-04-06","2012-04-13","2012-04-20","2012-04-27","2012-05-04","2012-05-11","2012-05-18","2012-05-25","2012-06-01","2012-06-08","2012-06-15","2012-06-22","2012-06-29",null,{"v":0,"d":"€ 0.0 K"}]
["Planung"]
["1.1.","Angebotsphase",null,"2011-02-16","2010-12-02",76,"Done"]
["1.1.1.","Angebote einholen",null,"2010-12-04","2010-12-02",2,"Done"]
["1.1.2.","Angebot Kleiner",null,"2010-12-10","2010-12-03",5,"Done"]
["1.1.3.","Nachtragsangebot kombiniert",null,"2010-12-16","2010-12-10",4,"Done"]
["1.1.4.","Auftragsvergabe",null,"2010-12-28","2010-12-16",8,"Done"]
["1.1.4.","Anmeldung EnBW",null,"2011-01-19","2010-12-28",15,"Done"]
["1.1.4.","Preise 2011 für Zellen definieren",null,"2011-02-16","2011-01-19",20,"Done"]
["1.2.","Vorarbeiten & Installation",null,"2011-03-25","2011-02-16",37]
["1.2.1.","Wand verputzen",null,"2011-02-20","2011-02-16",3,"Done"]
["1.2.2.","Umrichter aufhängen",null,"2011-02-22","2011-02-18",2,"Done"]
["1.2.3.","AC-seitige Installation",null,"2011-03-01","2011-02-25",2,"Done",{"$nulls":18},"x",{"$nulls":3},"x"]
["1.2.4.",null,null,"2011-03-01","2011-03-01",0,"Done"]
["1.2.5.","Gerüst",null,"2011-03-25","2011-03-11",10,"Done"]
[null,"Dach Gartenschuppen umdecken",null,"2011-04-05","2011-04-01",2,"Done",{"$nulls":22},"x"]
[]
[]
[]
["1.3.","Lieferung Solarmdule",null,"2011-03-17","2011-02-24",21,"Done"]
["1.3.1.","Bestellung - Zellen",null,"2011-02-28","2011-02-24",2,"Done"]
["1.3.2.","Lieferung Zellen",null,"2011-03-17","2011-02-28",12,"Done"]
["1.3.3.",null,null,"2011-03-17","2011-03-17",0]
["1.3.4.",null,null,"2011-03-17","2011-03-17",0]
["1.3.5.",null,null,"2011-03-17","2011-03-17",0]
[{"$nulls":3},"2011-03-17","2011-03-17",0]
["Realisierung"]
["2.1.","Dachmontage",null,"2011-04-07","2011-03-17",21]
["2.1.1.","Hauptdach",null,"2011-03-21","2011-03-17",2,"Done",{"$nulls":19},"x"]
["2.1.2.","Vordach",null,"2011-03-23","2011-03-21",2,"Done",{"$nulls":19},"x"]
["2.1.3.","offener Schuppen",null,"2011-03-25","2011-03-23",2,"Done",{"$nulls":19},"x"]
["2.1.1.","Gartenschuppen",null,"2011-04-07","2011-04-05",2]
["2.1.2.",null,null,"2011-04-07","2011-04-07",0]
["2.1.3.",null,null,"2011-04-07","2011-04-07",0]
["2.2.","Überwachung installieren",null,"2011-06-25","2011-03-29",88]
["2.2.1.",null,null,"2011-04-01","2011-03-29",3]
["2.2.2.",null,null,"2011-04-01","2011-04-01",0]
["2.2.3.","Pfingstferien",null,"2011-06-25","2011-06-14",8]
["2.2.4.",null,null,"2011-06-25","2011-06-25",0]
["2.2.5.",null,null,"2011-06-25","2011-06-25",0]
["2.2.6.",null,null,"2011-06-25","2011-06-25",0]
["2.2.7.",null,null,"2011-06-25","2011-06-25",0]
["2.2.8.",null,null,"2011-06-25","2011-06-25",0]
["2.3.","Inbetriebnahme",null,"2011-04-08","2011-04-06",2]
["2.3.1.","Inbetriebnahme",null,"2011-04-08","2011-04-06",2]
["2.3.2.",null,null,"2011-04-08","2011-04-08",0]
["2.3.3.",null,null,"2011-04-08","2011-04-08",0]
[{"$nulls":3},"2011-04-08","2011-04-08",0]
[{"$nulls":3},"2011-04-08","2011-04-08",0]
[{"$nulls":3},"2011-04-08","2011-04-08",0]
[{"$nulls":3},"2011-04-08","2011-04-08",0]
[{"$nulls":3},"2011-04-08","2011-04-08",0]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
[{"$nulls":4},"00:00:00"]
{"$rows_empty":12}
[{"$nulls":94},"x"]
[]
[]
[]
[null,"Done items",{"$nulls":4},19]
[null,"Open items",{"$nulls":4},44]

{"sheet":"ToDos","index":1,"n_rows":35,"n_cols":10,"rows_kept":35,"merged":[[0,0,0,2]],"flags":["formulas_cached_only"]}
["Global BU Meeting",{"$nulls":5},"Last Meeting","2006-10-24"]
["Editor","xyc",{"$nulls":4},"Status","2006-10-24"]
[]
["Item","Mtg. Date","Subject","ToDo","Responsible","Partner","target dte","done","Remark","Open/Closed"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Baden-Württemberg2011","index":2,"n_rows":17,"n_cols":2,"rows_kept":17,"flags":["formulas_cached_only"]}
["Tag"," Feiertage"]
["2011-01-01"," Neujahr"]
["2011-01-06"," Heilige Drei Könige"]
["2011-03-08","Rosenmontag"]
["2011-04-22"," Karfreitag"]
["2011-04-25"," Ostermontag"]
["2011-05-01"," Maifeiertag"]
["2011-06-02"," Christi Himmelfahrt"]
["2011-06-13"," Pfingstmontag"]
["2011-06-23"," Fronleichnam"]
["2011-10-03"," Tag der Deutschen Einheit"]
["2011-11-01"," Allerheiligen"]
["2011-12-25"," 1. Weihnachtstag"]
["2011-12-26"," 2. Weihnachtstag"]
[]
[]
[null,"http://www.feiertage.net/frei-tage.php"]

{"sheet":"EMAIL_dist_list","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["Familyname, Firstname"]

{"sheet":"Manual","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Tabelle1","index":5,"n_rows":10,"n_cols":1,"rows_kept":10,"flags":["formulas_cached_only"]}
["=WENN(I$4<=HEUTE();WAHR)"]
["=WENN(TAG(I$4)<8;I$4;\"\")"]
[]
[]
[true]
[]
["=WENN(UND(I$4>$E5-1;I$4<$D5+2;$F5<>0);WAHR)"]
["LÄNGE($A6)=<4"]
[]
[false]