You will not be able to do that in Planning. You could have the users do it the same way as in excel you are doing above. Convert the result file into an input file for loading to Essbase and do an FR on it to show it to them.
Thank you for your response,
As I understand from above statement that user have the same format in the excel .xls extension user will enter the data in that format & then convert it to input file & then load it to the Essbase.
Please correct me if I'm getting wrong & will you please guide the steps here.