Creating excel spreadsheets that need automation

will not except or look at any bids with milestones, so please dont waste our [login to view URL] read word doc before bidding so you understand. would be heplful if you understood acct recievable to do calculations. Need to create a few spread with certain field with underlying code for auto populate and also acct number generator by type of acct like credit card mortgage loan will all generate different acct numbers also acct codes I'll what number will start with and how many digits will be in number. There will be 7 different spread sheets with different types of codes for auto population. Then finally these will need to be to show a procession in payments with decline in balance and also if no payment is made or late payment to show correct balance. With this done for a whole year of payments for 1 year for each spread sheet with adding selected bidders I will provide to you a example of accts payable spreadsheet as a base example. No reserve will be paid max for this job will be 100 us so if you understand job you would submit a example of 30 accts in the credit card spread sheet with acct number generator and calculating payments also which i have provided formulas for.