Basically, i need to reference some data across two files; MRP-TPJ and Consolidated SF Rolling Forcast
I have attached both of them to ease you. In the attached MRP, you will realise that the even weeks are highlighted, with those weeks that are multiples of 4 to be in royal blue. This is what is going to form the basis of reference for you in the second part of this project.
for now, just bear in mind:
Royal Blue => Fairfield
All highlighted(inclusive of Royal Blue) => Kunshan and Taiwan
Looking at Consolidated SF rolling forecast, i have several sheets : SF Kunshan, SF Australia, SF Taiwan, SF Columbia among others. In this project, you may disregard SF Columbia.
Taking SF Taiwan as example, the "Paper Code" is found in column B with the words "Latest f/c" in coulum A preceding it. So what is needed is to use the paper code, the month that it is in, add up the similar values if any, then put it in the MRP file one month earlier.
Example: Looking at sheet "SF Taiwan" cell B7, we have 1621-730, so the value for the month of Sep is 60 (L7). Then we also have 1621-730 appearing a few cells down in cell B25 and B34 with the values 200. So adding them up, we have for paper code 1621-730 the total of 60+200+200=460.
Now this value must go to MRP under the month of August (one month preceding). The value must be split up according to the number of highlighted weeks (in this case, 2). So in sheet "Paper" cell AO58 and AQ58 of the MRP file, we will have 460/2=230. If its SF Australia though, its just the Royal Blue highlighted cell for that month. If there are 2 Royal Blue highlighted cells, then divide by 2 for Australia. If there are 3 highlighted cells in a month, then divide by 3.
I hope i am clear on this.
That is all you need to do.
**Please note that the highlights are just to help you visualise better. NO color detection is needed. You could just use mod 2 and mod 4 to distinguish the two**.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).