This project needs to be done today.
You will need to be ready to start work upon being hired on 1/12/2020 @ 8am PST (California time).
Please ignore the budget of $999 and bid what you believe is fair.
Excel VBA expert needed to add calculations script/macros to the attached file.
This is a pricing tool.
The user inputs data into the green column headers of the first tab (“input” tab).
The user is interested in 4 items (marked with an “x” in “Check” column A.
Of these 4 items, the user knows the quantity he needs for 3 of them (cells B2, B5, B6)
The user had ordered 1 of the 4 items before at the price and quantity specified (cells I5 and I6).
The user inputs quantity discounts in the “discounts” tab.
There are only four rows here, but the user can add as may as he wants with different quantity ranges.
The “output” tab takes the 4 items the user wants and attempts to calculate pricing based on the quantity requested.
When your script is run it will take the 4 items requested in the “input” tab and create a table in the “output” tab.
It will then attempt to calculate the quantity pricing for the items that had not been purchased in the past (rows 2, 3, and 5 of the “Output” tab). Look inside the calculations to see how the quantity pricing was calculated (F2:I2, F3:I3, F5:I5).
The “Total” (column J of “output” tab) is calculated based on the quantity desired.
Next, your script will calculate the quantity pricing for items that had been ordered in the past (row 4).
Look at rows F4:I4 of the “output” tab to see how it was calculated. Please note, these cell formulas refer to the “discount” tab’s text that is grayed out. The reason it is grayed out is that, the actual workbook will not show any of this gray text. I am only showing it to show you how it was calculated.
After all the rows are calculated in the “Output” tab, the “Total” (row 6) of the “Output” tab is calculated.
Finally, the columns K and L of the “input” tab are populated from the resulting data from the “Output” tab. Feel free to look inside the formulas to see where it comes from.
So, in summary, your script will use the data from the “Input” and the “Discount” tabs to generate the table from scratch in the “Output” tab. Once the “Output” tab is populated, the “Input” tab’s columns K and L will be populated referencing the data in the “Output” tab.