Startup Idea: Data Validation & Reformatting Software
Industry Software
Submission 1 I work in the retail industry, and in the accounting department. A big issue for us is importing datasheets we receive from vendors into our systems, we sometimes have huge mistakes in the sheets and we always have to reformat them. If there was some software that could automatically reformat these sheets it would save countless hours, and I'd gladly pay for it. The software could check for errors based on past datasheets from that vendor/manufacturer, and we could script the formatting we like so it could go to work.
Submission 2 I do a lot of work with Excel. I need a piece of software that will let me upload multiple excel sheets to compare and contrast data. Example: I have 2 sheets of names and I need to know which names are duplicates and remove them from one list. I also need to be able to export those duplicates to a third list. There are scripts available, but I've not found one that is easy to use. Ideally this should not be just name based, but any data, be it phone numbers, address, numbers, emails, etc.. Ideally this could be either a webapp or a downloadable program. I don't see needs for many updates except when new file formats occur.
Submission 3 I am a technical consultant for a reliability engineering firm. Part of our tasks involve loading asset management data into a CMMS (IBM's Maximo). Since many of our customers are life sciences clients, the regulations require us to sample the data (making sure the source data exactly matches the target data. Currently, we extract the data into Excel and use formulas to match the two sets of data.I'd like to see a way to take two sets of data and compare each field for mismatches. it would need to be dynamic-- the number and type of columns would change for each data set.