{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Tally of Survey Results","Survey Result Analysis","Simple Sales Growth","ROUND Function","MROUND Function","CONVERT Function","Compound Sales Growth","CEILING Function"],"not_rendered":{"charts":2,"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":"Tally of Survey Results","index":0,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Patient Satisfaction Survey"]
[]
[null,"User ID","1st Question","2nd Question","3rd Question","4th Question",null,"Parameter","1st Question","2nd Question","3rd Question","4th Question"]
[null,"PSS001","Great","Poor","Poor","Fair"]
[null,"PSS002","Great","Poor",null,"Fair",null,"No Response",{"$f":"COUNTBLANK(C$5:C$16)","v":1},{"$f":"COUNTBLANK(D$5:D$16)","v":2},{"$f":"COUNTBLANK(E$5:E$16)","v":1},{"$f":"COUNTBLANK(F$5:F$16)","v":1}]
[null,"PSS003","Fair","Poor","Poor",null,null,"Response",{"$f":"COUNTA(C$5:C$16)","v":11},{"$f":"COUNTA(D$5:D$16)","v":10},{"$f":"COUNTA(E$5:E$16)","v":11},{"$f":"COUNTA(F$5:F$16)","v":11}]
[null,"PSS004","Fair",null,"Great","Fair",null,"Total Response",{"$f":"SUM(I$6:I$7)","v":12},{"$f":"SUM(J$6:J$7)","v":12},12,12]
[null,"PSS005","Fair","Poor","Great","Fair"]
[null,"PSS006","Fair",null,"Great","Fair",null,"Great",{"$f":"COUNTIF(C$5:C$16,$H10)/I$7","v":0.36363636363636365},0.2,0.27272727272727271,9.0909090909090912E-2]
[null,"PSS007","Poor","Fair","Poor","Poor",null,"Fair",0.36363636363636365,0.4,0.27272727272727271,0.45454545454545453]
[null,"PSS008",null,"Fair","Poor","Poor",null,"Poor",0.27272727272727271,0.4,0.45454545454545453,0.45454545454545453]
[null,"PSS009","Poor","Fair","Poor","Poor"]
[null,"PSS010","Poor","Great","Fair","Great"]
[null,"PSS011","Great","Great","Fair","Poor"]
[null,"PSS012","Great","Fair","Fair","Poor"]

{"sheet":"Survey Result Analysis","index":1,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Survery Result Analysis"]
[]
[null,"Question","No Response","Response","Total Response","Great","Fair","Poor"]
[null,"1st Question",1,11,12,0.36363636363636365,0.36363636363636365,0.27272727272727271]
[null,"2nd Question",2,10,12,0.2,0.4,0.4]
[null,"3rd Question",1,11,12,0.27272727272727271,0.27272727272727271,0.45454545454545453]
[null,"4th Question",1,11,12,9.0909090909090912E-2,0.45454545454545453,0.45454545454545453]

{"sheet":"Simple Sales Growth","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Simple Sales Growth Rate"]
[]
[null,"Year","Net Sales"]
[null,2019,303483]
[null,2020,659351]
[null,2021,748994]
[]
[null,"Sales Growth",{"$f":"(C7-C5)/C5","v":1.4679932648616232}]

{"sheet":"ROUND Function","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using ROUND Function"]
[]
[null,"Employee Name","Height (Inches)","Height (Meters)"]
[null,"Jennifer Johnson",67.260000000000005,{"$f":"ROUND(C5/39.3701,2)","v":1.71}]
[null,"Natalie Robinson",67.260000000000005,{"$f":"ROUND(C6/39.3701,2)","v":1.71}]
[null,"John Ferguson",75.106999999999999,1.91]
[null,"Samuel Patterson",78.47,1.99]
[null,"Jasmine James",75.106999999999999,1.91]
[null,"Patricia Hamilton",70.623000000000005,1.79]
[null,"Michael Hensley",69.501999999999995,1.77]
[null,"Elijah Fisher",72.864999999999995,{"$f":"ROUND(C12/39.3701,2)","v":1.85}]

{"sheet":"MROUND Function","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using MROUND Function"]
[]
[null,"Product","Per Unit Price","Rounded Price"]
[null,"Orbital Keys",1.4555057973482679,{"$f":"MROUND(C5,0.5)","v":1.5}]
[null,"XPress Bottle",42.267598780007958,{"$f":"MROUND(C6,0.5)","v":42.5}]
[null,"InstaPress",3.5344428214073345,3.5]
[null,"Uno Wear",54.110349142912511,54]
[null,"Allure Kit",51.94066152308951,52]
[null,"Swish Wallet",80.682213303320779,80.5]
[null,"Onovo Supply",29.923148693340053,30]
[null,"Sharpy Knife",24.297116046104787,24.5]
[null,"Towlee",52.783659862387289,53]
[null,"Rhino Case",20.903402738881727,{"$f":"MROUND(C14,0.5)","v":21}]

{"sheet":"CONVERT Function","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using CONVERT Function"]
[]
[null,"Employee Name","Height (Inches)","Height (Meters)"]
[null,"Jennifer Johnson",67.260000000000005,{"$f":"CONVERT(C5,\"in\",\"m\")","v":1.7084040000000003}]
[null,"Natalie Robinson",67.260000000000005,{"$f":"CONVERT(C6,\"in\",\"m\")","v":1.7084040000000003}]
[null,"John Ferguson",75.106999999999999,1.9077177999999999]
[null,"Samuel Patterson",78.47,1.9931380000000001]
[null,"Jasmine James",75.106999999999999,1.9077177999999999]
[null,"Patricia Hamilton",70.623000000000005,1.7938242]
[null,"Michael Hensley",69.501999999999995,1.7653508]
[null,"Elijah Fisher",72.864999999999995,{"$f":"CONVERT(C12,\"in\",\"m\")","v":1.8507709999999999}]

{"sheet":"Compound Sales Growth","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Compound Sales Growth Rate"]
[]
[null,"Year","Net Sales"]
[null,2019,303483]
[null,2020,659351]
[null,2021,748994]
[]
[null,"Sales Growth",{"$f":"((C7/C5)^(1/2))-100%","v":0.5709848073299828}]

{"sheet":"CEILING Function","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using CEILING Function"]
[]
[null,"Product","Per Unit Price","Rounded Price"]
[null,"Orbital Keys",1.4555057973482679,{"$f":"CEILING(C5,0.5)","v":1.5}]
[null,"XPress Bottle",42.267598780007958,{"$f":"CEILING(C6,0.5)","v":42.5}]
[null,"InstaPress",3.5344428214073345,4]
[null,"Uno Wear",54.110349142912511,54.5]
[null,"Allure Kit",51.94066152308951,52]
[null,"Swish Wallet",80.682213303320779,81]
[null,"Onovo Supply",29.923148693340053,30]
[null,"Sharpy Knife",24.297116046104787,24.5]
[null,"Towlee",52.783659862387289,53]
[null,"Rhino Case",20.903402738881727,{"$f":"CEILING(C14,0.5)","v":21}]