{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["DATEN","MASSE","GEWICHT & BMI","GEWICHT & KÖRPERFETT"],"not_rendered":{"charts":6,"defined_names":17},"unopened":[{"sheet":"MASSE","index":1,"reason":"not_a_worksheet"},{"sheet":"GEWICHT & BMI","index":2,"reason":"not_a_worksheet"},{"sheet":"GEWICHT & KÖRPERFETT","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"DATEN","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[1,1,4,9]]}
[null,"FITNESS-STATUSDIAGRAMM für FRAUEN"]
[null,"Anweisungen: Aktualisieren Sie die Daten für die Größe in den Zellen L2 und L3 auf der rechten Seite. Ersetzen Sie unten die Beispieldaten für die ersten sieben Spalten in der Tabelle \"Daten\". Die vier letzten (grauen) Spalten werden automatisch berechnet. Überprüfen Sie Ihre Fortschritte in MASSE, GEWICHT & BMI und GEWICHT & KÖRPERFETT auf den entsprechenden Arbeitsblättern und in den Diagrammen in dieser Arbeitsmappe.",{"$nulls":8},"Größe (m)",1]
[{"$nulls":10},"Größe (cm)",68]
[{"$nulls":10},"Summe (cm)",{"$f":"GrößeMeter*100+GrößeZentimeter","v":168}]
[]
[null,"Datum","Gewicht (kg)","Brust (cm)","Taille (cm)","Hüfte (cm)","Handgelenk (cm)","Unterarm (cm)","Geschätzte fettfreie Körpermasse","Geschätzter Körperfettanteil (kg)","Geschätzter Körperfettanteil (%)","Geschätzter BMI (Body Mass Index)"]
[null,{"$f":"TODAY()-25","v":"2018-05-06"},{"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":"((((Daten[[#This Row],[Gewicht (kg)]]/0.45359)*0.732)+ 8.987)+((Daten[[#This Row],[Handgelenk (cm)]]/2.54)/3.14)-((Daten[[#This Row],[Taille (cm)]]/2.54)*0.157)-((Daten[[#This Row],[Hüfte (cm)]]/2.54)*0.249)+((Daten[[#This Row],[Unterarm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Daten[[#This Row],[Gewicht (kg)]]-Daten[[#This Row],[Geschätzte fettfreie Körpermasse]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Daten[[#This Row],[Geschätzter Körperfettanteil (kg)]]*100)/Daten[[#This Row],[Gewicht (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"$f":"C7/(GesamtGröße/100)^2","v":{"v":20.727040816326532,"d":"20.73"}}]
[null,{"$f":"TODAY()-20","v":"2018-05-11"},{"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":"((((Daten[[#This Row],[Gewicht (kg)]]/0.45359)*0.732)+ 8.987)+((Daten[[#This Row],[Handgelenk (cm)]]/2.54)/3.14)-((Daten[[#This Row],[Taille (cm)]]/2.54)*0.157)-((Daten[[#This Row],[Hüfte (cm)]]/2.54)*0.249)+((Daten[[#This Row],[Unterarm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Daten[[#This Row],[Gewicht (kg)]]-Daten[[#This Row],[Geschätzte fettfreie Körpermasse]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Daten[[#This Row],[Geschätzter Körperfettanteil (kg)]]*100)/Daten[[#This Row],[Gewicht (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-15","v":"2018-05-16"},{"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":"((((Daten[[#This Row],[Gewicht (kg)]]/0.45359)*0.732)+ 8.987)+((Daten[[#This Row],[Handgelenk (cm)]]/2.54)/3.14)-((Daten[[#This Row],[Taille (cm)]]/2.54)*0.157)-((Daten[[#This Row],[Hüfte (cm)]]/2.54)*0.249)+((Daten[[#This Row],[Unterarm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Daten[[#This Row],[Gewicht (kg)]]-Daten[[#This Row],[Geschätzte fettfreie Körpermasse]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Daten[[#This Row],[Geschätzter Körperfettanteil (kg)]]*100)/Daten[[#This Row],[Gewicht (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-10","v":"2018-05-21"},{"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":"((((Daten[[#This Row],[Gewicht (kg)]]/0.45359)*0.732)+ 8.987)+((Daten[[#This Row],[Handgelenk (cm)]]/2.54)/3.14)-((Daten[[#This Row],[Taille (cm)]]/2.54)*0.157)-((Daten[[#This Row],[Hüfte (cm)]]/2.54)*0.249)+((Daten[[#This Row],[Unterarm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Daten[[#This Row],[Gewicht (kg)]]-Daten[[#This Row],[Geschätzte fettfreie Körpermasse]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Daten[[#This Row],[Geschätzter Körperfettanteil (kg)]]*100)/Daten[[#This Row],[Gewicht (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-5","v":"2018-05-26"},{"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":"((((Daten[[#This Row],[Gewicht (kg)]]/0.45359)*0.732)+ 8.987)+((Daten[[#This Row],[Handgelenk (cm)]]/2.54)/3.14)-((Daten[[#This Row],[Taille (cm)]]/2.54)*0.157)-((Daten[[#This Row],[Hüfte (cm)]]/2.54)*0.249)+((Daten[[#This Row],[Unterarm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Daten[[#This Row],[Gewicht (kg)]]-Daten[[#This Row],[Geschätzte fettfreie Körpermasse]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Daten[[#This Row],[Geschätzter Körperfettanteil (kg)]]*100)/Daten[[#This Row],[Gewicht (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()","v":"2018-05-31"},{"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":"((((Daten[[#This Row],[Gewicht (kg)]]/0.45359)*0.732)+ 8.987)+((Daten[[#This Row],[Handgelenk (cm)]]/2.54)/3.14)-((Daten[[#This Row],[Taille (cm)]]/2.54)*0.157)-((Daten[[#This Row],[Hüfte (cm)]]/2.54)*0.249)+((Daten[[#This Row],[Unterarm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"Daten[[#This Row],[Gewicht (kg)]]-Daten[[#This Row],[Geschätzte fettfreie Körpermasse]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Daten[[#This Row],[Geschätzter Körperfettanteil (kg)]]*100)/Daten[[#This Row],[Gewicht (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]