spreadsheet with details.

[aratrika]

i want to create a spreadsheet which shall contain sales related data such as name of the products sold, name of the dealers, number of quantity, amount, days of credit allowed, payment received,outstanding details.goods returned,sales tax form receivable/received etc. is it possible to incorporate all the details as above in one spreadsheet and if yes how to start.

 

[email2vimalraj]

Hi aratrika,


Could you please give more details about your requirement?

 

[NARAYANK991]

Hi aratrika ,


What you have outlined is certainly possible. You need to consider a few points :


1. Who will be using the worksheet ? Will it be only you , or will it be other users ? If it is only you , you can do with minimal automation , but if it is going to be used by others , whose job will be only data entry and report generation , then you need to use some amount of automation.


2. How will the data get into the worksheet ? Will it be entered by one or more users , or will it be imported from text files generated by other software ? If it is going to be entered by users , then you will need to validate the entered data.


3. You also need to define the data items , which will be just numbers ( either to be entered or to be imported ) , and the calculated fields , which will be entered only once , and protected from modification thereafter.


4. You need to define the various reports that you will be generating from the worksheet.


5. You need to define how much of the data needs to be stored , either for statutory purposes , or for long-term MIS analysis.


There are many more points , which others who are experienced in this area can help out with , but these will do to start with.


Narayan