Frequently asked questions
I am converting millimeters and meters to feet. None of the millimeters were converted. Some of the meters were converted.
I think some of the problem is from the formatting, such as 10 meter versus 10.0 meter, or 10m versus 10 m.
Also, I have meters that aren't whole numbers, 4.27, 15.5, 15.7, etc. Can I create formulas for these types of numbers?
Looking at the meters to feet formula, would the same formula work with these changes to convert from millimeters to feet?
DIG(N,200-5000) mm DIG(N,2000-5000) ft SRC*3937/1000
DIG(N,200-5000) Millimeter DIG(N,2000-5000) ft SRC*3937/1000
Thanks again for your help. It is truly appreciated.
First of all, the range 1-30 in the expression DIG(N,1-30) is the number of digits you’re likely to encounter in a document, so 200-5000 doesn’t make sense.
1-30 should be more than ample.
The conversion from meters to feet involves multiplying by 3281 and dividing by 1000.
Second, if you have expressions like 10m and 10 m, you just copy and paste the first formula and delete the space in front of the "m" in the copy. The "input side" would look like this:
DIG(N,1-30) m [one space]
DIG(N,1-30)m [no space]
Third, the formula document has a millimeters to inches formula. If you want to convert millimeters to feet, you either have to remove the millimeters to inches formula or make sure the millimeters to feet formula comes first. I’ve done this for you in the attached document (see yellow formulas).
CNV looks for the first instance of a formula containing mm and then ignores any other formula with mm.
Some more pointers for users who want to write custom formulas:
For conversions from liters to quarts, for instance, the master data document contains this formula:
DIG(N,1-30) l DIG(N,1-30) qts SRC*1057/1000
T4T-CNV will look for a number followed by a space and a lower-case "L". If your document contains a numeric expression followed by uppercase "L" for liters, you can simply copy the above formula and paste it in the next line and change the "l" to an "L". You can also change the "qts" on the output side to "quarts". Your new (additional) formula would be:
DIG(N,1-30) L DIG(N,1-30) quarts SRC*1057/1000
SCR*1057/1000means "take the source number that precedes the unit (liters, in our case), multiply it by 1057 and then divide the result by 1000 to create the target number".
1 liter is 1.057 quarts, but T4T-CNV works with whole numbers and that’s why we multiply with 1057 and divide by 1000.
1 liter is 0.264 gallons, so we would multiply the source number by 264 and divide by 1000.
That formula would be
DIG(N,1-30) liters DIG(N,1-30) gallons SRC*264/1000