{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Quick Review","Weight","Distance","Time","Pressure","Force","Energy","power conversion","magnteism conversion ","temperature conversion","liquid measure","volume conversion","Area conversion","Information Conversion","Formula","VBA","compound units","data validation","formulas main menu"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Quick Review","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5],[13,1,13,5]]}
[]
[null,"Use of CONVERT Function"]
[null,"=CONVERT(number,from_unit,to_unit)"]
[]
[null,"Number","from_unit","to_unit","Formula","Output"]
[null,132.4,"\"C\" (Degree \nCelsius)","\"F\" (Degree \nFahrenheit)",{"$f":"_xlfn.FORMULATEXT(F6)","v":"=CONVERT(B6,\"C\",\"F\")"},{"$f":"CONVERT(B6,\"C\",\"F\")","v":270.32000000000005}]
[null,1636,"\"psi\" (PSI)","\"Pa\" (Pascal)",{"$f":"_xlfn.FORMULATEXT(F7)","v":"=CONVERT(B7,\"psi\",\"Pa\")"},{"$f":"CONVERT(B7,\"psi\",\"Pa\")","v":11279822.93162344}]
[null,10,"\"l\" (Liter)","\"m^3\" (Cubic \nMeter)","=CONVERT(B8,\"l\",\"m^3\")",{"$f":"CONVERT(B8,\"l\",\"m^3\")","v":0.01}]
[null,132,"\"lbm\" (Pound\n mass)","\"g\" (Gram)","=CONVERT(B9,\"lbm\",\"g\")",{"$f":"CONVERT(B9,\"lbm\",\"g\")","v":59874.192840000003}]
[null,100,"\"m\" (Meter)","\"yd\" (Yard)","=CONVERT(B10,\"m\",\"yd\")",{"$f":"CONVERT(B10,\"m\",\"yd\")","v":109.36132983377078}]
[null,6,"\"mn\" (Minute)","\"sec\" (Second)","=CONVERT(B11,\"mn\",\"sec\")",{"$f":"CONVERT(B11,\"mn\",\"sec\")","v":360}]
[null,0.37,"\"m/s\" (Meter \nper Second)","\"mph\" (Mile \nPer Hour)","=CONVERT(B12,\"m/s\",\"mph\")",{"$f":"CONVERT(B12,\"m/s\",\"mph\")","v":0.8276664280601288}]
[]
[null,"The CONVERT Function changes a value from one unit to another"]

{"sheet":"Weight","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Converting Weight from Pound Mass to Gram"]
[]
[null,"Participant\n Name","Weight\n(lb)","Weight\n(gm)"]
[null,"Michael",132.27735731092653,{"$f":"CONVERT(C5,\"lbm\",\"g\")","v":59999.999999999993}]
[null,"Joe",154.32358352941429,{"$f":"CONVERT(C6,\"lbm\",\"g\")","v":70000}]
[null,"John",149.91433828571675,68000]
[null,"Richard",165.34669663865819,75000]
[null,"Christian",147.70971566386797,67000]
[null,"Jefferson",174.16518712605327,79000]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"i"]

{"sheet":"Distance","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Distance Conversion: Meter (m) to Yard (yd)"]
[]
[null,"House No","Distance (m)","Distance (yd)"]
[null,"House 1 to House 2",100,{"$f":"CONVERT(C5,\"m\",\"yd\")","v":109.36132983377078}]
[null,"House 2 to House 3",70,{"$f":"CONVERT(C6,\"m\",\"yd\")","v":76.552930883639547}]
[null,"House 3 to House 4",85,92.957130358705157]
[null,"House 4 to House 5",68,74.365704286964132]
[null,"House 5 to House 6",40,43.744531933508313]
[null,"House 6 to House 7",89,97.331583552055989]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"i"]

{"sheet":"Time","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Time Conversion: Minute (min) to Second (sec)"]
[]
[null,"House No","Travelling Time (min)","Travelling Time (sec)"]
[null,"House 1 to House 2",6,{"$f":"CONVERT(C5,\"mn\",\"sec\")","v":360}]
[null,"House 2 to House 3",10,{"$f":"CONVERT(C6,\"mn\",\"sec\")","v":600}]
[null,"House 3 to House 4",5,300]
[null,"House 4 to House 5",3,180]
[null,"House 5 to House 6",2,120]
[null,"House 6 to House 7",3,180]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"i"]

{"sheet":"Pressure","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Pressure Conversion: PSI (psi) to Pascal (p)"]
[]
[null,"Substance","Pressure \n(psi)","Pressure \n(Pa)"]
[null,"Ammonia",1636,{"$f":"CONVERT(C5,\"psi\",\"Pa\")","v":11279822.93162344}]
[null,"Butane",550.4,{"$f":"CONVERT(C6,\"psi\",\"Pa\")","v":3794874.414159866}]
[null,"Chlorine",1118.7,7713164.9838674469]
[null,"Ethane",708,4881488.1635632003]
[null,"Ethanol",914,6301808.1659558825]
[null,"Nitrogen",492.4,3394978.4911561012]
[null,"Propane",670.3,4621555.8136107521]

{"sheet":"Force","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Force Conversion: Newton (N) to Pound Force (lbf)"]
[]
[null,"Experiment No","Force \n(N)","Pound Force \n(lbf)"]
[null,"Exp-1",1636,{"$f":"CONVERT(C5,\"N\",\"lbf\")","v":367.78743091112636}]
[null,"Exp-2",550.4,{"$f":"CONVERT(C6,\"N\",\"lbf\")","v":123.73484228208065}]
[null,"Exp-3",1118.7,251.49376464564611]
[null,"Exp-4",708,159.16473171459501]
[null,"Exp-5",914,205.47537399313538]
[null,"Exp-6",492.4,110.69592358229744]
[null,"Exp-7",670.3,150.68943455973593]

{"sheet":"Energy","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Energy Conversion: Joule (J) to Erg (e)"]
[]
[null,"Reaction No","Energy \n(J)","Energy \n(e)"]
[null,"R-1",1636,{"$f":"CONVERT(C5,\"J\",\"e\")","v":16360000000}]
[null,"R-2",550.4,{"$f":"CONVERT(C6,\"J\",\"e\")","v":5504000000}]
[null,"R-3",1118.7,11187000000]
[null,"R-4",708,7080000000]
[null,"R-5",914,9140000000]
[null,"R-6",492.4,4924000000]
[null,"R-7",670.3,6703000000]

{"sheet":"power conversion","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Power Conversion: Horsepower (HP) to Watt (W)"]
[]
[null,"Engine No","Power \n(HP)","Power \n(W)"]
[null,"Engine-1",1636,{"$f":"CONVERT(C5,\"HPh\",\"Wh\")","v":1219964.9899085942}]
[null,"Engine-2",550.4,{"$f":"CONVERT(C6,\"J\",\"e\")","v":5504000000}]
[null,"Engine-3",1118.7,11187000000]
[null,"Engine-4",708,7080000000]
[null,"Engine-5",914,9140000000]
[null,"Engine-6",492.4,4924000000]
[null,"Engine-7",670.3,6703000000]

{"sheet":"magnteism conversion ","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Magentism Conversion: Tesla (T) to Gauss (ga)"]
[]
[null,"Magnetic Field No","Tesla (T)","Gauss (ga)"]
[null,"Magnetic Filed-1",5,{"$f":"CONVERT(C5,\"T\",\"ga\")","v":50000}]
[null,"Magnetic Filed-2",10,{"$f":"CONVERT(C6,\"T\",\"ga\")","v":100000}]
[null,"Magnetic Filed-3",2,20000]
[null,"Magnetic Filed-4",4,40000]
[null,"Magnetic Filed-5",7,70000]
[null,"Magnetic Filed-6",3,30000]
[null,"Magnetic Filed-7",5,50000]

{"sheet":"temperature conversion","index":9,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Temperature Conversion: Degree Celsius (C) to Degree Fahrenheit (F)"]
[]
[null,"City No","Temperature (T)","Temperature (F)"]
[null,"City-1",33,{"$f":"CONVERT(C5,\"C\",\"F\")","v":91.4}]
[null,"City-2",22,{"$f":"CONVERT(C6,\"C\",\"F\")","v":71.599999999999994}]
[null,"City-3",15,59]
[null,"City-4",41,105.8]
[null,"City-5",23,73.400000000000006]
[null,"City-6",27,80.599999999999994]
[null,"City-7",19,66.2]

{"sheet":"liquid measure","index":10,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Liquid Measure Conversion: Liter (L) to Gallon (ga)"]
[]
[null,"Water Bottle No","Liter (L)","Gallon (ga)"]
[null,"WB-1",10,{"$f":"CONVERT(C5,\"l\",\"gal\")","v":2.6417205235814842}]
[null,"WB-2",5,{"$f":"CONVERT(C6,\"l\",\"gal\")","v":1.3208602617907421}]
[null,"WB-3",12,3.1700646282977809]
[null,"WB-4",22,5.8117851518792651]
[null,"WB-5",17,4.4909248900885235]
[null,"WB-6",22,5.8117851518792651]
[null,"WB-7",11,2.9058925759396326]

{"sheet":"volume conversion","index":11,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Volume Conversion: Cubic Feet (ft3) to U.S. Oil Barrel (Barrel)"]
[]
[null,"Barrel of Crude Oil No","Cubic Feet (ft3)","U.S. Oil Barrel (Barrel)"]
[null,"No-1",10,{"$f":"CONVERT(C5,\"ft^3\",\"barrel\")","v":1.7810760667903525}]
[null,"No-2",5,{"$f":"CONVERT(C6,\"ft^3\",\"barrel\")","v":0.89053803339517623}]
[null,"No-3",12,2.137291280148423]
[null,"No-4",22,3.9183673469387754]
[null,"No-5",17,3.0278293135435992]
[null,"No-6",22,3.9183673469387754]
[null,"No-7",11,1.9591836734693877]

{"sheet":"Area conversion","index":12,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Area Conversion: Square Meters (m2) to Square Feet (ft2)"]
[]
[null,"Area No","Area (m2)","Area (ft2)"]
[null,"Area-1",10,{"$f":"CONVERT(C5,\"m^2\",\"ft^2\")","v":107.63910416709723}]
[null,"Area-2",5,{"$f":"CONVERT(C6,\"m^2\",\"ft^2\")","v":53.819552083548615}]
[null,"Area-3",12,129.16692500051667]
[null,"Area-4",22,236.8060291676139]
[null,"Area-5",17,182.98647708406529]
[null,"Area-6",22,236.8060291676139]
[null,"Area-7",11,118.40301458380695]

{"sheet":"Information Conversion","index":13,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Information Conversion: Bit (bit) to Byte (byte)"]
[]
[null,"Information System No","Bit (bit)","Byte (byte)"]
[null,"System-1",10,{"$f":"CONVERT(C5,\"bit\",\"byte\")","v":1.25}]
[null,"System-2",5,{"$f":"CONVERT(C6,\"bit\",\"byte\")","v":0.625}]
[null,"System-3",12,1.5]
[null,"System-4",22,2.75]
[null,"System-5",17,2.125]
[null,"System-6",22,2.75]
[null,"System-7",11,1.375]

{"sheet":"Formula","index":14,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"CONVERT Function in a Formula"]
[]
[null,"Participant\n Name","Distance\n(m)","Time\n(min)","Speed(m/s)"]
[null,"Michael",100,6,{"$f":"C5/CONVERT(D5,\"mn\",\"sec\")","v":0.27777777777777779}]
[null,"Joe",70,10,{"$f":"C6/CONVERT(D6,\"mn\",\"sec\")","v":0.11666666666666667}]
[null,"John",85,5,0.28333333333333333]
[null,"Richard",68,3,0.37777777777777777]
[null,"Christian",40,2,0.33333333333333331]
[null,"Jefferson",89,3,0.49444444444444446]

{"sheet":"VBA","index":15,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Participant\n Name","Distance \n(m)","Distance \n(yd)"]
[null,"Michael",100,109.36132983377078]
[null,"Joe",70,76.552930883639547]
[null,"John",85,92.957130358705157]
[null,"Richard",68,74.365704286964132]
[null,"Christian",40,43.744531933508313]
[null,"Jefferson",89,97.331583552055989]

{"sheet":"compound units","index":16,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Convert Function with Compound Units"]
[]
[null,"Engine No","Torque \n(lbf-ft)","Torque \n(N-m)"]
[null,"Engine-1",545,{"$f":"CONVERT(C5,\"lbf\",\"N\")*CONVERT(1,\"ft\",\"m\")","v":738.92078184061324}]
[null,"Engine-2",550.4,{"$f":"CONVERT(C6,\"lbf\",\"N\")*CONVERT(1,\"ft\",\"m\")","v":746.24219876160282}]
[null,"Engine-3",1118.7,1516.7535387983378]
[null,"Engine-4",708,959.9191074186316]
[null,"Engine-5",914,1239.2176047749001]
[null,"Engine-6",492.4,667.60475775838165]
[null,"Engine-7",670.3,908.80477076653779]

{"sheet":"data validation","index":17,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combine CONVERT Function with Data Validation"]
[]
[null,"Distance","Value","Units",null,null,"Units"]
[null,"User input distance",15,"m",null,null,"ft"]
[null,null,null,null,null,null,"yd"]
[null,"Converted Distance",{"$f":"CONVERT(C5,D5,D7)","v":49.212598425196852},"ft",null,null,"m"]
[null,null,null,null,null,null,"mi"]
[null,null,null,null,null,null,"Nmi"]
[null,null,null,null,null,null,"in"]
[null,null,null,null,null,null,"ell"]
[null,null,null,null,null,null,"ang"]

{"sheet":"formulas main menu","index":18,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using the Formulas Main Menu"]
[]
[null,"House No","Distance (m)","Distance (yd)"]
[null,"House 1 to House 2",100,{"$f":"CONVERT(C5,\"m\",\"yd\")","v":109.36132983377078}]
[null,"House 2 to House 3",70,{"$f":"CONVERT(C6,\"m\",\"yd\")","v":76.552930883639547}]
[null,"House 3 to House 4",85,92.957130358705157]
[null,"House 4 to House 5",68,74.365704286964132]
[null,"House 5 to House 6",40,43.744531933508313]
[null,"House 6 to House 7",89,97.331583552055989]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"i"]