Help me in store data of yearly please provide me format for this

[Rahul Mishra]

sir i want to store data in excel sheet of yearly by branch wise and month wise target and achievement so please provide me any format for this.

 

[Asheesh]

Hi Rahul -

Can you share a sample data set in this case...one of the experts around can suggest the format..

Ideally - I would create a table with headers like branch, month, year(can be extracted out of month)..targets..if there are serveral metrics and then achievement..
or Targets can be managed separately as they likely to be fixed for all the metrics..

 

[Rahul Mishra]

i maintain like this data but i don't want like this so please provide me another format

 

[Asheesh]

Rahul - There are several ways of managing this data, however, I am little curious to know your end result...like what do you want to achieve...what should this data finally talk about...

Basis the required final output, It would be easly to suggest the format that is to be maintained..