I need someone to create a heat map spreadsheet nearly identical to the attached image. The only difference is going to be the data I give you to put into the spreadsheet to produce the heat map. I'm not sure what a fair price for this project is or how long it will take, so the lower the bid the greater chance you have at winning.

This is for a construction company.
I need to have designed, an excel spreadsheet, a program.... or a webpage, that can be taken with an estimator to a customers home when providing a quotation and allow the estimator to simply punch in the dimensions of the project and have this program/spreadsheet automatically calculate and present everything. I would like this 1 program/spreadsheet to streamline several processes:
1. A quoted price and graphically presentable quote to be generated, able to be printed, signed and used as a contract. The price and items included would autopopulate based on the measurements and add-ons selected
2. allowing the customer or estimator to adjust that price by simply selecting different available add-ons and upgrades (which would vary in price based on the measurements and dimensions input)
3. creating a material list based off of these input dimensions and measurements
4. creating a cost of materials and labour based on dimensions and measurements
5....

Duties include those described for executive assistant, but the position supports the most senior executives, particularly in large corporations. A premium is paid for specific industry expertise. Sensitivity to confidential matters is required.

I want an expert in using excel and developing scripts in VBA to enhance the overall functionaility and features of an existing sheet.
Please apply only if you:
1- Have previous examples for your work
2- Have a Strong internet connection as we are going to have a frequent Skype calls.

We have 2 different CSV files each of them have similar column structure.
CSV_1 (Suppliers data feed):
Column1:Product ID
Column2:Product title
Column3:Product price
Column4:Product shipping fee
Column5:Product Image URL
This file may have up to 500,000 items (Rows)
CSV_2 (our woocommerce store data feed):
Column1:Product ID
Column2:Product title
Column3:Product price
Column4:Product shipping fee
Column5:Product Image URL
This file may have up to 100,000 items (Rows)
You have to write a script to search an find same, similar, closest match titles between the both files and for those matched items you must compare the price and calculate the profit and profit margin and output in 3rd file (lets call it output data file) where we can see all matched items with potential profits.
You basically only need to look at
Column2:Product title
Column3:Product price
Column4:Product shipping fee
to make the calculation.
I hope its clear.
I will send you sample data if...

I have a spreadsheet with some file names in 1 column.
Some cells have more than 1 file name, separated by "/"
The job is to separate each file name into its own cell.
I'm looking for somebody who's able to code a small VBA script to take care of this job.
Note: I do not need the script. I only need the result.
This job is urgent and I do need this by today so please apply only if you have the time to do this.

The main goal is to develop an Selenium WebDriver macro built in the predefined excel file which would be supplied. The macro would scrape the data from the desired website with dynamic content and put it in the desired sheet in the workbook. The other part of the task would be to develop the simple VB macro which would sort out the source date scraped from the website to the desired sheets in the desired form and format.

The client is an international manufacturer of thermal oil heaters and steam generators, used in the process engineering industry.
There is a requirement for the construction of a forecasting model to accurately predict the net mass and value of imports for a list of specified commodities. Import data for the specified commodities has already been consolidated and represented in the form of charts and graphs, being further displayed by country of origin, during the period of 2010 - 2014. The candidate will build a forecasting model using a statistical forecasting model such as SAS, SPSS or similar.
Additionally, there is also a requirement to match trader files with the raw import data, in an effort to try and identify who the major importers of the mentioned commodities are, and if possible to identify where the importer is importing the goods from. This should provide useful information as to who the potential customers are in the region, and who the major competitors are.

We have recently done a survey with 85 people, and we have their data in an Excel sheet (85 rows). Each person took 5 photos of their childs lunchbox, and we would like to create a little application which reveals all of the photos relevant if certain filters are selected in Excel (max 5 filters). Ie if we only want to look at the photos from mums in a certain age range, at a certain income level, and whose child is a boy, we should be able to apply the necessary filters, and all photos will appear from any of the 85 respondents who match that criteria. The solution might be Excel based, or another interface. Each image is around 100kb in size and we are looking for a fairly attractive interface. Thanks, Chris