How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask R.R. Jha Your Own Question
R.R. Jha
R.R. Jha, Tutor
Category: Homework
Satisfied Customers: 5471
Experience:  B.Tech
Type Your Homework Question Here...
R.R. Jha is online now
A new question is answered every 9 seconds

RRJha, I have a question. I have a file with 5 columns of data.

This answer was rated:

RRJha, I have a question. I have a file with 5 columns of data. I want to be able to
Forecast the data in column AIR1 to AIR6262, but forecast progressively. I attached the file
so I want to use the forecast function to forecast the next value for AIR3 using the AIR1 and AIR2 used in the formula to forecast the value for the AIR3 to be placed in the AIX3. Then forecast the value for AIR4 using the AIR1 to AIR3 and place this forecasted value in the AIX4 and so on. I would like these to be done for the AIS column and the AIT column AIU column and the AIV column as well. I would like this to be done in macro so I can run this every time I get new data. This is a large file but want you to focus on the range of data described above without any other data being altered. I want to be able to run this macro at least 60,000 past the row 6262 to be able to process new data as I receive it. Thanks
Hi, I am a Moderator for this topic. I sent your requested Professional a message to follow up with you here, when he is back online. If I can help further, please let me know. Thank you for your continued patience.

Thanks for asking. I'll work over this and let you know.

You need to spend $3 to view this post. Add Funds to your account and buy credits.
R.R. Jha, Tutor
Category: Homework
Satisfied Customers: 5471
Experience: B.Tech
R.R. Jha and other Homework Specialists are ready to help you
Customer: replied 4 years ago.

Thanks again!