step2: I will configure rates for MM scheme and two agents
so i will pest that agents in apply agents box and i will update rates and other fields in form and i will hit enter
Step 3: After hitting enter out put will be like this for first two agents and for first schemes below image
Step4: nest i will configure rates for second condition in instruction
for scheme FS and 3rd and 4th agents... so i will paste these agents codes in apply agents
and i will update rates as per instruction for FS scheme and 3rd & 4th Agents and i will hi apply agents.. and output will get export next to "MM" scheme out put as highlighted in below pic
i will repeat same steps for remaining schemes "TR and W2" and agents as per instruction.
and output get export next to MM and FS schemes output as shown in below pic
after completing all schemes and agents i will hit finish button and output will be like this as shown in below pic
Note:
Broke Type(No Limit as there are more broke type id's I will use as per instructions)
Agents ( No limit)
Scheme ( No Limit)
From amount(No Limit)
To amount(No Limit)
From Month and ToMonth (No limit for days)
1) When you click on Upload what should happen?
2) on dates are you looking for auto date or user will select date?
3) which are the fields user is not supposed to enter which will automatically should populate.
1: once i hit upload output should get export into output sheet
2: dates i will update
3: except agent all fields will update user only....that all fields will should get applied to those agents which are mentioned in apply agents
create two tables as shown in pic total agents and apply agents
after updating all fields i will mentioned agent codes in apply agents table then i will hit upload button and all updated fields get applied to thos agents and result will get export into output file
i will do this for different different schemes repeatedly until unless i hit exit button all updated results should get export to output sheet one after other