1) 2 Order above with different customers name with the same time zone = 0.7 points for the trip number.
2) Having the same postal code with 2 customers and 1 of the customers ordered twice, however the time zone is different, therefore each is being awarded with 1 point each
3) Having the same postal code with different customer which means that each is rewarded with 1 point. If there is more than 2 orders at the same postal code, refer back to criteria 1.
4) Having the same postal code and same customer name, however the instructions is written as "Click and Collect". The points should be awarded with this login (1,0,0)(1,0,0)(1,0,0). If they have 5 orders the points should be (1,0,0,1,0). Means that the loops is repeating.
5) Having the same postal code and same customer name, however the instructions is written as "VWO". No matter how many orders they had under the same customer name and same postal code, only 1 points is rewarded.
6) Having same postal code but quantity is more than 35 quantity in a single order is rewarded with 2 points.
7) Having same postal code but quantity is more than 46 quantity in a single order is rewarded with 3 points.
Hello Sir. I have 5+ years experience in VBA. I can do this project very easily without any issue and in no time. Just message me so that we can start this project right now.
Relevant Skills and Experience
VBA
Proposed Milestones
$22 SGD - 1