"CONVCALC" Program

Doc"CONVCALC" --- CONVERSION CALCULATORProgram Description:"CONVCALC" is a spreadsheet program written in MS-Excel for the purpose of facilitating the adding andsubtracting of numbers (dimensions) represented in English "ft.-in. & fraction" format, as well as convertingthose numbers to Metric (millimeter) equivalents. Also included are some miscellaneous English/Metricconversions pertaining specifically to mass, force, and unit length or area.This program is a workbook consisting of five (5) worksheets, described as follows:Worksheet NameDescriptionDocThis documentation sheetft-in-frac Calculator (Ver. 1)Calculator to Add and Subtract feet, inches, and fractions (Version 1)ft-in-frac Calculator (Ver. 2)Calculator to Add and Subtract feet, inches, and fractions (Version 2)Metric Conversion CalculatorCalculator to Add/Subtract in Metric with English ConversionsMisc. ConversionsMiscellaneous English/Metric ConversionsProgram Assumptions and Limitations:1. The "ft-in-frac Calculator (Ver. 1)" and "ft-in-frac Calculator (Ver. 2)" worksheets are two different input formatversions of the same tool to add and/or subtract up to fifteen (15) entries. In each of these two (2) worksheets,the input is first displayed for confirmation. Then, it is converted into decimal feet, and finally converted into aMetric equivalent in terms of millimeters. Arithmetic results are totalled and displayed at the bottom.2. The "ft-in-frac Calculator (Ver.1)" worksheet has a required input format as follows:ft = whole feetin = whole inches (0 to 11 max.)N = numerator of fraction (if applicable)D = denominator of fraction (if applicable)Note: Do not input a numerator value (N) >= denominator value (D). However, 0/0 may be input for no fractionvalue, or clear cells with "Clear Contents" (do not use "Space Bar").3. The "ft-in-frac Calculator (Ver. 2)" worksheet has a required input format as follows:ft.inNNDDwhere:ft = whole feetin = whole inches (2 digits required, if applicable)NN = numerator of fraction (2 digits required, if applicable)DD = denominator of fraction (2 digits required, if applicable)Examples of input:4'-7 1/8" is input as 4.07010810'-11 13/16 is input as 10.1113162'-1" is input as 2.01 (trailing zeros not required)Note: This version is included due to the similarity of form and function to past programs developed for HPhandheld calculators.4. In the "Metric Conversion Calculator" worksheet, the input in millimeters is converted into decimal feet andthen displayed in feet, inch, and fraction format. Arithmetic results are totalled and displayed at the bottom.5. In the "Metric Conversion Calculator" worksheet, the user can input the degree of accuracy to be used inconversion from millimeters to feet, inch, and fraction format. Either 1/16" or 1/32" may be selected.6. All three (3) "Calculator" worksheets require the user to select the arithmetic operator to be used for eachentry, either addition (+) or subtraction (-). Note: if left blank, the program assumes addition (+).7. This program contains numerous comment boxes which contain a wide variety of information includingexplanations of input or output items, equations used, data tables, etc. (Note: presence of a comment boxis denoted by a red triangle in the upper right-hand corner of a cell. Merely move the mouse pointer to thedesired cell to view the contents of that particular "comment box".)

ft-in-frac Calculator (Ver. 1)Version 1.2ADD / SUBTRACT "ft.-in. & fraction" CALCULATORInput:Input ConfirmationConversion toConversion to++/-ft.in.NDft. - in. & fractionDecimal FeetMillimeters (mm)-+3011131630' -1113/16''30.9843759444.043011131630.9843759444.04+60146' -01/4''6.0208331835.1560146.0208331835.1500000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.00Results =37' -01/16''37.00520811279.19370.0052080.062501/16

Required input is as follows:

ft = whole feet in = whole inches (0 to 11 max.) N = numerator of fraction (if applicable) D = denominator of fraction (if applicable)

Note: Do not input a numerator value (N) >= denominator value (D). However, 0/0 may be input for no fraction value, or clear cells with "Clear Contents" (do not use "Space Bar").Note: conversion to millimeters (Metric units) is rounded to nearest whole millimeter."CONVCALC.xls"written by: Alex Tomanovich, P.E.Select arithmetic operator to be used for each entry below, either addition (+) or subtraction (-).Note: if left blank, program assumes addition (+).

ft-in-frac Calculator (Ver. 2)Version 1.2ADD / SUBTRACT "ft.-in. & fraction" CALCULATORInput:Input ConfirmationConversion toConversion to++/-ft.inNNDDft. - in. & fractionDecimal FeetMillimeters (mm)-+27.11131627' -1113/16''27.9843758529.642711.13161113.16131627.9843758529.64+6.0001046' -01/4''6.0208331835.1560.010401.04146.0208331835.1500000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.0000000.0000000.0000.000000000.0000000.00Results =34' -01/16''34.00520810364.79340.0052080.062501/16

Required input syntax is as follows: ft.inNNDDwhere: ft = whole feet in = whole inches (2 digits required, if applicable) NN = numerator of fraction (2 digits required, if applicable) DD = denominator of fraction (2 digits required, if applicable)

Examples of input: 4'-7 1/8" is input as 4.070108 10'-11 13/16 is input as 10.111316 2'-1" is input as 2.01 (trailing zeros not required)

Note: This version is included due to the similarity of form/function to past programs developed for HP handheld calculators.Note: conversion to millimeters (Metric units) is rounded to nearest whole millimeter."CONVCALC.xls"written by: Alex Tomanovich, P.E.Select arithmetic operator to be used for each entry below, either addition (+) or subtraction (-).Note: if left blank, program assumes addition (+).

Metric Conversion CalculatorVersion 1.2ADD / SUBTRACT "Metric" CALCULATORInput:Input ConfirmationConversion toDisplayed as+1/16+/-Millimeters (mm)Millimeters (mm)Decimal Feetft. - in. & fraction-1/32+1.001.000.0032810' -01/16''00.0032810.0393701/1610.003281+1835.201835.206.0209976' -01/4''60.0209970.25196901/41835.26.0209970.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.0000000.000.000000000000.00000000000.000000Results =1836.206.0242786' -05/16''60.0242780.29133905/16Accuracy =1/16in.

Select either 1/16" or 1/32" accuracy for conversion of Metric to English units.Note: conversion to ft.-in. & fraction (English units) is rounded to either nearest 1/16" or 1/32" as specified by desired accuracy below."CONVCALC.xls"written by: Alex Tomanovich, P.E.Select arithmetic operator to be used for each entry below, either addition (+) or subtraction (-).Note: if left blank, program assumes addition (+).

Misc. ConversionsVersion 1.2ENGLISH to METRIC CONVERSIONSMETRIC to ENGLISH CONVERSIONSCategoryEnglish UnitsMetric UnitsCategoryMetric UnitsEnglish UnitslbkgkglbMass1.0000=0.4536Mass1.0000=2.2046(or Weight)kipkg(or Weight)kgkip1.0000=453.59241.0000=0.0022lbNNlbForce1.0000=4.4482Force1.0000=0.2248(concentrated)kipKN(concentrated)KNkip1.0000=4.44821.0000=0.2248lb/inN/cmN/cmlb/in1.0000=1.75131.0000=0.5710lb/ftN/mN/mlb/ftForce/Length1.0000=14.5939Force/Length1000.0000=68.5218(distributed)kip/inKN/cm(distributed)KN/cmkip/in1.0000=1.75131.0000=0.5710kip/ftKN/mKN/mkip/ft1.0000=14.59391.0000=0.0685lb/in^2 = psiN/cm^2N/cm^2lb/in^2 = psi1.0000=0.68951.0000=1.4504lb/ft^2 = psfN/m^2N/m^2lb/ft^2 = psfForce/Area1.0000=47.8803Force/Area500.0000=10.4427(Pressure or)kip/in^2 = ksiKN/cm^2(Pressure or)KN/cm^2kip/in^2 = ksiStress)1.0000=0.6895Stress)1.0000=1.4504kip/ft^2 = ksfKN/m^2KN/m^2kip/ft^2 = ksf1.0000=47.88031.0000=0.0209lb-inN-cmN-cmlb-in1.0000=11.29851.0000=0.0885lb-ftN-mN-mlb-ftMoment1.0000=1.3558Moment1.0000=0.7376(or Torque)kip-inKN-cm(or Torque)KN-cmkip-in1.0000=11.29851.0000=0.0885kip-ftKN-mKN-mkip-ft1.0000=1.35581.0000=0.7376

"CONVCALC.xls"written by: Alex Tomanovich, P.E.