[Tutor] addition
Terje Johan Abrahamsen
terjeja@hotmail.com
Fri, 28 Jun 2002 14:25:54 +0000
Hello,
I have to make a program that compares policies for an accounting
department. It uses two different systems, AS/400 and Win Excel. I have
built all the surounding code moving numbers back and forth, formatting and
so forth, but the main calculations are missing. Here is the problem:
In Excel up to 7 accounts can have the same policynumber, while up to 3
policies in the AS/400 system can have the same policynumber. Any number of
policies in either system can match any number of policies in the other
system. So, therefore for example 5 Excel amounts can add up to the
approximate amount (+-$5) of 2 AS/400 accounts. If this is the case, these
amounts should be marked. If I haven't forgotten all my statistics skills,
that should equal up to (7!=5040 * 3!=6)=30240 calculations. How can I do
this? There is no way I can use my normal way of doing this (with less
numbers) by writing in the possibilities, as in if a+b=c:print yes, elif a+c
= d: print yes and so forth until I have used all the possibilities. I need
the computer to do this part this time. (I am a beginner, so please keep it
simple.)
Thanks,
Terje
_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com