[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