Do some Excel Work

I have three questions that I need to write a VBA code in Excel for. The questions are as follows: Task 1: A Monetary Calculation If you have $200 in your pocket, and you see a shelf with a long row of foobars priced at $1, $1.2, $1.44, $1.73 and so forth. Every foobar costs 20% more than the previous one. You buy one of each foobar, starting with the one that costs $1, until you can't afford the next foobar on the self (the foobars are ordered by price). How many foobars can you buy, and how much change will you get? Your task is to write a small routine to solve this problem, and report the results. Note: Since we are talking about money (dollars and cents), there are only two decimals used in each price. Task 2: Organizing Data Attached you find a file ‘[login to view URL]’. This file contains three vectors: ID, date and value. These represent unsorted data points for four different time series. ID gives the id of the time series to which the point belongs; date indicates the date for which the value is valid and value contains the data. Please create a generic function that sorts the data into a matrix with a number of rows equal to the unique number of dates and a number of columns equal to the number of curves, so that each column contains the data for one time series and each row contains the data for a given date. Please be aware that there is at least one data point missing. The matrix should contain a “nan” or a zero in place of the missing value. The function should be applicable to any list of data that has the given format. If possible, avoid using a loop to solve the problem. Task 3: Data Analysis In the residential sector, natural gas is almost exclusively for space heating, cooking and water boilers. Residential gas demand therefore shows a strong seasonality and a dependence on cold weather. Attached are two data files: Temperatures [login to view URL] with daily average temperatures in degree Fahrenheit for Indiana from 09/01/2010 to 04/30/2015 and Residential Demand [login to view URL] with monthly residential gas demand for Indiana from September 2010 to December 2014. Based on these data, create a residential natural gas demand forecast for January-April 2015. You get extra credit, if you can also provide us with an assessment of daily natural gas demand for each day during this period. Give an explanation of your methodology and a discussion of potential problems.