{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","CONVERT, PERCENTRANK","CONVERT, POWER, PERCENTRANK","Arithmetic Formula","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,3,3],[3,4,4,4],[1,1,1,4]]}
[]
[null,"Height and Weight List"]
[]
[null,"Name","Height",null,"Weight (lbs)"]
[null,null,"Feet","Inches"]
[null,"Robin",5,8,140]
[null,"Mary",5,3,100]
[null,"Jones",6,3,200]
[null,"Susan",5,2,165]
[null,"James",5,11,170]
[null,"Frank",6,1,155]
[null,"Jennifer",4,11,115]
[null,"Thomas",5,9,230]
[null,"Mark",6,2,185]
[null,"Sandra",5,1,135]

{"sheet":"CONVERT, PERCENTRANK","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,7,4,7],[3,8,4,8],[1,1,1,8],[3,1,4,1],[3,2,3,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
[]
[null,"Using CONVERT and PERCENTRANK.INC Functions"]
[]
[null,"Name","Height",null,"Weight (lbs)","Height (m)","Weight (kg)","BMI","BMI Percentile"]
[null,null,"Feet","Inches"]
[null,"Robin",5,8,140,{"$f":"CONVERT(C6,\"ft\",\"m\")+CONVERT(D6,\"in\",\"m\")","v":1.7272000000000001},{"$f":"CONVERT(E6,\"lbm\",\"g\")/1000","v":63.502931800000006},{"$f":"G6/F6^2","v":21.286708726099114},{"$f":"_xlfn.PERCENTRANK.INC($H$6:$H$15,H6)","v":0.222}]
[null,"Mary",5,3,100,{"$f":"CONVERT(C7,\"ft\",\"m\")+CONVERT(D7,\"in\",\"m\")","v":1.6002000000000001},45.359237,17.71402317055075,0]
[null,"Jones",6,3,200,1.905,90.718474000000001,24.99802949828122,0.66600000000000004]
[null,"Susan",5,2,165,1.5748,74.842741050000001,30.178584974105434,0.88800000000000001]
[null,"James",5,11,170,1.8033999999999999,77.110702900000007,23.709944165573717,0.44400000000000001]
[null,"Frank",6,1,155,1.8542000000000001,70.306817350000003,20.44957493790011,0.111]
[null,"Jennifer",4,11,115,1.4986000000000002,52.163122549999997,23.226946756249152,0.33300000000000002]
[null,"Thomas",5,9,230,1.7525999999999999,104.32624509999999,33.964713992229917,1]
[null,"Mark",6,2,185,1.8795999999999999,83.914588450000011,23.752350663485114,0.55500000000000005]
[null,"Sandra",5,1,135,1.5494000000000001,61.23496995,25.507764915691077,0.77700000000000002]

{"sheet":"CONVERT, POWER, PERCENTRANK","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,4,1],[3,2,3,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8]]}
[]
[null,"Using CONVERT, POWER and PERCENTRANK.INC Functions"]
[]
[null,"Name","Height",null,"Weight (lbs)","Height (m)","Weight (kg)","BMI","BMI Percentile"]
[null,null,"Feet","Inches"]
[null,"Robin",5,8,140,{"$f":"CONVERT(C6,\"ft\",\"m\")+CONVERT(D6,\"in\",\"m\")","v":1.7272000000000001},{"$f":"CONVERT(E6,\"lbm\",\"g\")/1000","v":63.502931800000006},{"$f":"G6/POWER(F6,2)","v":21.286708726099114},{"$f":"_xlfn.PERCENTRANK.INC($H$6:$H$15,H6)","v":0.222}]
[null,"Mary",5,3,100,{"$f":"CONVERT(C7,\"ft\",\"m\")+CONVERT(D7,\"in\",\"m\")","v":1.6002000000000001},{"$f":"CONVERT(E7,\"lbm\",\"g\")/1000","v":45.359237},{"$f":"G7/POWER(F7,2)","v":17.71402317055075},0]
[null,"Jones",6,3,200,1.905,90.718474000000001,24.99802949828122,0.66600000000000004]
[null,"Susan",5,2,165,1.5748,74.842741050000001,30.178584974105434,0.88800000000000001]
[null,"James",5,11,170,1.8033999999999999,77.110702900000007,23.709944165573717,0.44400000000000001]
[null,"Frank",6,1,155,1.8542000000000001,70.306817350000003,20.44957493790011,0.111]
[null,"Jennifer",4,11,115,1.4986000000000002,52.163122549999997,23.226946756249152,0.33300000000000002]
[null,"Thomas",5,9,230,1.7525999999999999,104.32624509999999,33.964713992229917,1]
[null,"Mark",6,2,185,1.8795999999999999,83.914588450000011,23.752350663485114,0.55500000000000005]
[null,"Sandra",5,1,135,1.5494000000000001,61.23496995,25.507764915691077,0.77700000000000002]

{"sheet":"Arithmetic Formula","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,4,1],[3,2,3,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7]]}
[]
[null,"Applying Arithmetic Formula and PERCENTRANK.INC Function"]
[]
[null,"Name","Height",null,"Weight (lbs)","Height (inch)","BMI","BMI Percentile"]
[null,null,"Feet","Inches"]
[null,"Robin",5,8,140,{"$f":"C6*12+D6","v":68},{"$f":"E6/F6^2*703","v":21.284602076124568},{"$f":"_xlfn.PERCENTRANK.INC($G$6:$G$15,G6)","v":0.222}]
[null,"Mary",5,3,100,{"$f":"C7*12+D7","v":63},17.712270093222475,0]
[null,"Jones",6,3,200,75,24.995555555555555,0.66600000000000004]
[null,"Susan",5,2,165,62,30.17559833506764,0.88800000000000001]
[null,"James",5,11,170,71,23.707597698869272,0.44400000000000001]
[null,"Frank",6,1,155,73,20.447551135297427,0.111]
[null,"Jennifer",4,11,115,59,23.224648089629415,0.33300000000000002]
[null,"Thomas",5,9,230,69,33.961352657004831,1]
[null,"Mark",6,2,185,74,23.75,0.55500000000000005]
[null,"Sandra",5,1,135,61,25.505240526740124,0.77700000000000002]

{"sheet":"VBA","index":4,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,7,4,7],[1,1,1,6],[3,1,4,1],[3,2,3,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
[]
[null,"Employing VBA Code"]
[]
[null,"Name","Height",null,"Weight (lbs)","Height (inch)","BMI","BMI Percentile"]
[null,null,"Feet","Inches"]
[null,"Robin",5,8,140,{"$f":"C6*12+D6","v":68},{"$f":"bmi(E6,F6)","v":21.284602076124568},{"$f":"_xlfn.PERCENTRANK.INC($G$6:$G$15,G6)","v":0.222}]
[null,"Mary",5,3,100,{"$f":"C7*12+D7","v":63},{"$f":"bmi(E7,F7)","v":17.712270093222475},0]
[null,"Jones",6,3,200,75,{"$f":"bmi(E8,F8)","v":24.995555555555555},0.66600000000000004]
[null,"Susan",5,2,165,62,{"$f":"bmi(E9,F9)","v":30.17559833506764},0.88800000000000001]
[null,"James",5,11,170,71,{"$f":"bmi(E10,F10)","v":23.707597698869272},0.44400000000000001]
[null,"Frank",6,1,155,73,{"$f":"bmi(E11,F11)","v":20.447551135297427},0.111]
[null,"Jennifer",4,11,115,59,{"$f":"bmi(E12,F12)","v":23.224648089629415},0.33300000000000002]
[null,"Thomas",5,9,230,69,{"$f":"bmi(E13,F13)","v":33.961352657004831},1]
[null,"Mark",6,2,185,74,{"$f":"bmi(E14,F14)","v":23.75},0.55500000000000005]
[null,"Sandra",5,1,135,61,{"$f":"bmi(E15,F15)","v":25.505240526740124},0.77700000000000002]