Hi all.
Firstly im new here and English isnt my native tongue so I would like to apologize beforehand if my explanations aren't very clear.
Truly appreciate if anyone can help me with the following:
I generally have two sets of data:
1.First one is an inventory list of clothes with their value and each classified into winter clothes or summer clothes.
2.Second one is a DAILY average of the temperature in a certain location throughout one year (so 365 data sets of [day and average temp]).
What I want to do is create a method that raises or lowers the price of a certain product using an equation curve that is created from the temperature data at a certain date.
(Lets say i want the curve to raise the price by 30% at the lowest point and lower the price by 50% at the highest point (and viceversa for summer clothes))
So for ex: if I have a winter coat in my inventory that is valued at 100 USD, and I input the date of the lowest temperature in the year (lets say February 1st),
then excel should give me 130USD as a result.
Also if there are other ways to accomplish this in an automated manner without an equation curve it would also be awesome.
Hoping to hear from everyone soon. Thankyou in advance!
Firstly im new here and English isnt my native tongue so I would like to apologize beforehand if my explanations aren't very clear.
Truly appreciate if anyone can help me with the following:
I generally have two sets of data:
1.First one is an inventory list of clothes with their value and each classified into winter clothes or summer clothes.
2.Second one is a DAILY average of the temperature in a certain location throughout one year (so 365 data sets of [day and average temp]).
What I want to do is create a method that raises or lowers the price of a certain product using an equation curve that is created from the temperature data at a certain date.
(Lets say i want the curve to raise the price by 30% at the lowest point and lower the price by 50% at the highest point (and viceversa for summer clothes))
So for ex: if I have a winter coat in my inventory that is valued at 100 USD, and I input the date of the lowest temperature in the year (lets say February 1st),
then excel should give me 130USD as a result.
Also if there are other ways to accomplish this in an automated manner without an equation curve it would also be awesome.
Hoping to hear from everyone soon. Thankyou in advance!
