The display "Monthly estimate"
for submittal and pre-approval is done automatically from a call
procedure of the customized menu bar.
You will have simply to introduce the percentage of completion
for each item listed.
In the DevExcel program, a complementary worksheet completely programmed
can be inserted in the working file making it possible to draw up
the document of the Monthly progress
payment".
Dollar > Euro > Dollar
This double conversion can reveal a variation of
conversion of ± 3 cents between the origin amount and the final
amount.
Example:
-
2545,35 F ÷ 6,55957 = 388, 036106 round to
388,04
-
388,04 X 6,55957 = 2545,37554 F, rounded
-off with 2545,38 F
One observes a variation of + 3 cents (this variation
is authorized).
Euro > Dollar > Euro
This double conversion makes it possible to find
the origin amount rigorously. It did not have difference between
the origin amount and the final amount.
Example:
-
1562 X 6,55957 = 10246,04834 F, round -off
with 10246,05 F
-
10246,05 ÷ 6,55957 = 1562,000253, round
to 1562
Adding Text (Descriptions) |
Some of your estimates will require descriptions (text). It is
simple with Excel to incorporate text in the table of calculation,
allowing for example to give a summary description of the installation,
which will be realized
Last update:
|