0

I have to design a data table which is going to be 288 rows and 15 column big. I want to make it easy for users to input data easily. Data is for a day for every 5 minutes interval(i.e. 288 rows are 5 min intervals). As per research this is how they input data: 1) Most of the users put same data across columns 2) During some critical situations they put similar data upto some rows e.g. till 60 rows data will be same, next 40 rows data will be same and so on. 3) Users sometimes do copy-paste data directly from excel sheets.

I was planning to have a collapsible table where users can select time duration and enter bulk values which will populate for that entire time duration. But If I do this, copy and paste from excel will be an issue.

Updated: The table attached is the old design with 48 rows, now it has to be updated to 288 rows. And users will try to put repetitive data across number of some set of rows(depends upon the situation, can't predict it).

enter image description here

  • 2
    Please add a mockup of what you were thinking. Is input the problem? Could you be a little more specific about the problem you are facing? The question could pose being quite broad if the entire design is to be considered. – Ren Jul 2 at 8:26
  • Sounds bloody awful, what's the use case for this, ask yourself - who will use this application? Why would they use this application? This should help people give you the HOW are they going to use this application. – DarrylGodden Jul 3 at 8:10
  • @Ren Have updated the question with the mockup. Yes input is problem. The table attached is the old design with 48 rows, now it has to be updated to 288 rows. And users will try to put repetitive data across number of some set of rows(depends upon the situation, can't predict it). – Madhuri UX Jul 3 at 23:48
  • @DarrylGodden That is what I have mentioned in the question why and how they are doing it. Have updated the question with the mock up. Hope it helps. If you have any particular question please feel free to ask. – Madhuri UX Jul 3 at 23:49
  • What are they putting into the sheet and why? – DarrylGodden Jul 4 at 9:17
0

Is it possible to communicate with the system / app via API? Probably the end users are using Excel / Spreadsheets for their work on a daily basis and they shouldn't have to leave their favorite editor. With Microsoft Excel or Google Spreadsheet you have the ability to communicate with the database via an API.

Also they can fetch / update the data by a click and filter/sort them, creating additional pivot tables or updatable custom reports with diagrams without copy/pasting table data between two system.

Of course the main problem with this method if you push the data to the system it will overwrite the existing data but you can set limits on the editable cells to prevent any unwanted changes or implementing somekind of change management too.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.