Please open the attached files:
1) Excel spreadsheet - raw data
2) Word document with table to show the columns we want the program to create
The excel file contains data for product oil filter
We need a program which will:
a) select products by part number (e.g. Oil Filter part number OC310 - column)
b) Take all the rows for columns B through to H, BUT only taking rows for X number of UNIQUE values of Higher Level Model (column A)
c) X needs to be set by the user and is the number of unique values for column C (Model)
d) this table then need to be converted to html. we also want a way to be able to choose format of the table e.g font, size etc
In summary, the program needs to pick the correct data and put it into a number of relevant html tables (which are titled by part number- if there are many tables for each pert no. these should be given a letter code on the end eg. OC310A, OC310B These tables will then to be used by us for posting to a website.
We have previously had a bad experience with this site, therefore we will only pay the full amount on delivery of a fully working program. NO payment will be made before we know everything works.
We will take the company/individual who displays the most understanding of what we need in his/her initial post.