Existing Solution-

    Few software/website exists that are used for inputing the data or arranging the data,google sheets,microsoft excel and tableau like application are used now a days

The features they provide-

 

1.Can input the data or edit the data -

 

The owner has all the access to the the sheet , they can let the organization people to enter of edit the data by seting it public or private as per the need but when the data is public someone can edit anybodies data that is entered . It can organize the data in any order according to the field provided . It can remove the null or zero entries but you have to run the query for it manually.

 

2.Can you formulas for the calculations that is time consuming -

 

In excel sheet if you want to calculate some data then there are diffrent query or formulas for every field like it can run the query for multiplication, addition and average calculation and so on .

 

3.They can present the data into visual format like pie charts and graph-

 

The data you have entered can be visualized in chart or graphical method like if you have a companies data base and you want to see graphically the salary amount or attendance of the employee and anything like this can be visualized it present the data as pie chart or histogram and all

 

4.It provide a feature of highlighting the data that needed to be seprated-