We have an Excel file with data that needs to be automatically converted, by some type of script or programming, and a new Excel file needs to be generated from this. We have attached 2 files for you to review: [url removed, login to view] and sample-converted-database.xls.
Your assignment is to create a VB script, or other program, that can take the data from the [url removed, login to view] file and create an Excel file that looks like the [url removed, login to view] file.
These are engagement rings. Each ring comes in a size 3.5 to 9.5 in 18K white gold, 18K yellow gold and platinum. Your script must create all of the combinations for each size and different type of metal.
1.) Please provide us with information that will clearly demonstrate to us that you are capable of doing this work.
2.) Please tell us whether you will use VB Script or another language.
3.) Please either quote a flat fee to create this script or provide a time range, with a maximum number of hours, and your hourly rate.
4.) You must be available to start this work Friday, August 12th, and complete this before Monday, August 15th. We will be available Saturday and Sunday to answer your questions and assist you.