{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["DATA","MÍRY","HMOTNOST A INDEX BMI","HMOTNOST A TĚLESNÝ TUK"],"not_rendered":{"charts":6,"defined_names":17},"unopened":[{"sheet":"MÍRY","index":1,"reason":"not_a_worksheet"},{"sheet":"HMOTNOST A INDEX BMI","index":2,"reason":"not_a_worksheet"},{"sheet":"HMOTNOST A TĚLESNÝ TUK","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"DATA","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[1,1,4,9]]}
[null,"KONDIČNÍ GRAF pro ŽENY"]
[null,"Pokyny: Údaje o výšce zaktualizujte v buňkách L2 a L3 napravo. V tabulce Data níže nahraďte ukázkové údaje v prvních sedmi sloupcích. Poslední čtyři sloupce (šedé) se vypočítají automaticky. Vývoj v průběhu času můžete v tomto sešitu sledovat v grafech na listech MÍRY, HMOTNOST A INDEX BMI a HMOTNOST A TĚLESNÝ TUK.",{"$nulls":8},"Výška (m)",{"v":1,"d":"1 "}]
[{"$nulls":10},"Výška (cm)",{"v":68,"d":"68 "}]
[{"$nulls":10},"Celkem (cm)",{"$f":"VýškaMetry*100+VýškaCentimetry","v":{"v":168,"d":"168 "}}]
[]
[null,"Datum","Hmotnost (kg)","Hrudník (cm)","Pas (cm)","Boky (cm)","Zápěstí (cm)","Předloktí (cm)","Odhad hmotnosti bez tuku","Odhad hmotnosti tělesného tuku","Odhad procent tělesného tuku","Odhad indexu BMI"]
[null,{"$f":"TODAY()-25","v":"2018-05-07"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},15.24,24.13,{"$f":"((((Data[[#This Row],[Hmotnost (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Zápěstí (cm)]]/2.54)/3.14)-((Data[[#This Row],[Pas (cm)]]/2.54)*0.157)-((Data[[#This Row],[Boky (cm)]]/2.54)*0.249)+((Data[[#This Row],[Předloktí (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Hmotnost (kg)]]-Data[[#This Row],[Odhad hmotnosti bez tuku]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Odhad hmotnosti tělesného tuku]]*100)/Data[[#This Row],[Hmotnost (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"$f":"C7/(VýškaCelkem/100)^2","v":{"v":20.727040816326532,"d":"20.73"}}]
[null,{"$f":"TODAY()-20","v":"2018-05-12"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},15.24,24.13,{"$f":"((((Data[[#This Row],[Hmotnost (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Zápěstí (cm)]]/2.54)/3.14)-((Data[[#This Row],[Pas (cm)]]/2.54)*0.157)-((Data[[#This Row],[Boky (cm)]]/2.54)*0.249)+((Data[[#This Row],[Předloktí (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Hmotnost (kg)]]-Data[[#This Row],[Odhad hmotnosti bez tuku]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Odhad hmotnosti tělesného tuku]]*100)/Data[[#This Row],[Hmotnost (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-15","v":"2018-05-17"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},15.24,24.13,{"$f":"((((Data[[#This Row],[Hmotnost (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Zápěstí (cm)]]/2.54)/3.14)-((Data[[#This Row],[Pas (cm)]]/2.54)*0.157)-((Data[[#This Row],[Boky (cm)]]/2.54)*0.249)+((Data[[#This Row],[Předloktí (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Hmotnost (kg)]]-Data[[#This Row],[Odhad hmotnosti bez tuku]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Odhad hmotnosti tělesného tuku]]*100)/Data[[#This Row],[Hmotnost (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-10","v":"2018-05-22"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},15.24,24.13,{"$f":"((((Data[[#This Row],[Hmotnost (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Zápěstí (cm)]]/2.54)/3.14)-((Data[[#This Row],[Pas (cm)]]/2.54)*0.157)-((Data[[#This Row],[Boky (cm)]]/2.54)*0.249)+((Data[[#This Row],[Předloktí (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Hmotnost (kg)]]-Data[[#This Row],[Odhad hmotnosti bez tuku]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Odhad hmotnosti tělesného tuku]]*100)/Data[[#This Row],[Hmotnost (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-5","v":"2018-05-27"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},15.24,24.13,{"$f":"((((Data[[#This Row],[Hmotnost (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Zápěstí (cm)]]/2.54)/3.14)-((Data[[#This Row],[Pas (cm)]]/2.54)*0.157)-((Data[[#This Row],[Boky (cm)]]/2.54)*0.249)+((Data[[#This Row],[Předloktí (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Hmotnost (kg)]]-Data[[#This Row],[Odhad hmotnosti bez tuku]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Odhad hmotnosti tělesného tuku]]*100)/Data[[#This Row],[Hmotnost (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()","v":"2018-06-01"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},15.24,24.13,{"$f":"((((Data[[#This Row],[Hmotnost (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Zápěstí (cm)]]/2.54)/3.14)-((Data[[#This Row],[Pas (cm)]]/2.54)*0.157)-((Data[[#This Row],[Boky (cm)]]/2.54)*0.249)+((Data[[#This Row],[Předloktí (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Hmotnost (kg)]]-Data[[#This Row],[Odhad hmotnosti bez tuku]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Odhad hmotnosti tělesného tuku]]*100)/Data[[#This Row],[Hmotnost (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]