Create Interface to run extract of data held in .CSV file.
File format is described in Table A.
Interface will allow entry of search criteria described in Table B.
Interface will include a 'Run Query' button that will execute extract of data based on the selection criteria entered.
Two new files will be created as result of 'Run Query' action. In .CSV format.
1) Data File – in same format as Table A but with addition of fields added in Table C. NB Data will be ordered by Date and Time, (columns BG and B).
2) Summary of Data File in format Table D.
Please provide overview of your proposed solution. Can run on Windows 8 or Mac - (NB Mac preferred)
Specification document attached
Dear,
I am Excel/VBA automation Expert since 10years.
Could you provide me you csv file?
You have choice for solution, Access form & queries, or excel.
According to me Access is more user-friendly.
I will be available after development, as support.
Regards,
Fabrice
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can provide only Windows version, sorry. Regards!
I have gone through the tables structures. I am assuming there will be only 1 form to enter the criteria and upon click of Run Query button, we will create 2 CSV files based on the user specified criteria.
I am available to start on this project.
Just one question, will you be able to provide sample data to work with?
Regards,
Sanjeev.
Hi,
I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you'll come to us again and again to avail our services.
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project.
Thanks,
Murtaza
I have 8 years experience in Microsoft technologies
Desktop (WPF), Web (ASP.Net, MVC, WCF), Silverlight, Databases, Reporting, Integration.
Expert in creation software.
Consider my bid please.
Good evening- I have worked with many tools that interact with CSV files and extract relevant data, including a CRM rollup tool. I would build a front-end Excel file that would have the inputs available, then it would call up the .csv file and extract information.
Hello prospective client!,
My name is Emmanuel, a speed typist (87+wpm) with accuracy of 98%and expert of Data Entry. I have 5 years experience working in a busy Book publishing store as their typist and English Editor as well as a web researcher and creative writer.
My English skills are beyond measurable and I do not only speak and write it as my language but also went extra-mile to get Certified in administrative support. I worked as a assistant Editor of a Daily English Newspaper in my country and now I am an Independent Contributor and data entry clerk.
My skills in English and typing are also furnished by my expertise and 6 years experience using Microsoft Office application and transcriptions and data entry and willing to start immediately.
I enter all your work in a shortest time and make sure I proofread it before submitting it to you with the time I have during the day of 10 hours a day and even at the affordable price you are willing. With time as we work together you'll get to find out that my Finish Work is free from English spellings and Grammar errors.
Ready to start immediately.
Thank you...
Waiting to be hired.
Semugoma Emmanuel.