| I've seen a number of problems that are caused by "units." Recently data on one spreadsheet, (called A) was stored in 1,000's and the same data on another spreadsheet (called B) was stored normally. So my code was to update an Excel sheet A with the values from B, but I forgot to multiply the data by 1,000. Fortunately, Excel crashed and I lost an hour of work but figured out that the data needed to be multiplied by a thousand. I've seen this happen with various currency conversions also. Most currencies are quoted in US Dollar but a few like GBP (Great Brittish Pound), EUR (Euro) and JPY (Japanese Yen) are quoted the opposite way. This also can cause calculation problems. |