{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Thema","Aufruf"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Thema","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,1,23,1],[6,0,8,0]]}
["Anwendung:","Excel 2000"]
[]
["Thema:","In welchem Land ist ein Produkt am preiswertesten oder am teuersten?"]
[]
["Kategorie:","Bedingte Formatierung"]
[]
["Problem/\nAufgabenstellung/\nFrage:","Ich habe in drei Spalten jeweils die drei Preise für ein Produkt aus drei verschiedenen Ländern. \nEin Preisvergleich also. Was muß jetzt genau machen, damit ich sofort sehen kann (farbig markiert wie eine Ampel) welches Produkt in welchem Land am günstigsten (grün) oder am teuersten (rot) ist?"]
{"$rows_empty":18}
["Autor:","Jörg Lorenz"]
[null,"lorenz@joerglorenz.de"]

{"sheet":"Aufruf","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":4},"Land 1","Land 2","Land 3"]
[null,null,null,"Produkt 1",66,2,3]
[null,null,null,"Produkt 2",2,3,4]
[null,null,null,"Produkt 3",5,2,3]
[null,null,null,"Produkt 4",4,3,2]
[null,null,null,"Produkt 5",6.5,10,7]
[null,null,null,"Produkt 6",6,7,8]
[null,null,null,"Produkt 7",7,8,6]
[null,null,null,"Produkt 8",11,9,10]
[null,null,null,"Produkt 9",9,55,11]
[null,null,null,"Produkt 10",11.5,10,12]
[null,null,null,"Produkt 11",11,12,13]
[null,null,null,"Produkt 12",22,13,14]
[null,null,null,"Produkt 13",13,14,15]
[null,null,null,"Produkt 14",22,15,16]
[null,null,null,"Produkt 15",15,22,17]
[null,null,null,"Produkt 16",16,17,18]
[null,null,null,"Produkt 17",25,23,19]
[null,null,null,"Produkt 18",18,19,20]
[]
[]
[]
[]
[null,null,null,"Anzahl grün:",{"$f":"SUM(IF(E2:E19<F2:F19,IF(E2:E19<G2:G19,1,0),0))","v":9},{"$f":"SUM(IF(F2:F19<G2:G19,IF(F2:F19<E2:E19,1,0)))","v":6},{"$f":"SUM(IF(G2:G19<E2:E19,IF(G2:G19<F2:F19,1,0)))","v":3}]
[null,null,null,"Anzahl gelb:",{"$f":"COUNT(E2:E19)-E24-E26","v":2},{"$f":"COUNT(F2:F19)-F24-F26","v":8},{"$f":"COUNT(G2:G19)-G24-G26","v":8}]
[null,null,null,"Anzahl rot:",{"$f":"SUM(IF(E2:E19>F2:F19,IF(E2:E19>G2:G19,1,0)))","v":7},{"$f":"SUM(IF(F2:F19>G2:G19,IF(F2:F19>E2:E19,1,0)))","v":4},{"$f":"SUM(IF(G2:G19>E2:E19,IF(G2:G19>F2:F19,1,0)))","v":7}]
[]
[null,null,null,"Gesamt:",{"$f":"E24+E25+E26","v":18},{"$f":"F24+F25+F26","v":18},{"$f":"G24+G25+G26","v":18}]