Completed

Build a tool to generate standard reports based on CSV files

We need a system to easily generate reports based on two csv files – one based on Usernames and one based on Data Volumes per Gb. The csv’s are in a consistent format and are generated twice each month - mid and end of month.

The current csv’s contain data which is excess to our requirements, but we are not able to adjust the base data provided to us when the csv’s are first generated.

We need to be able to generate a simplified report based on the two csv’s which only displays the data we require and runs some calculations based on set fields.

In addition, we need a 2nd report which identifies differences between the csv’s generated mid-month and the csv’s generated at the end of the month.

We envisage an Access database that we can add new csv’s/tables to each month and generate reports from but we are open to alternatives if a better way can be suggested.

We have provided a spreadsheet with samples of the two styles of base csv’s.

Base User Report proposed format

Total Number of Users Per Case Name.

List of Usernames Per case and their Last Login Date.

*The query should exclude Users where Is System column = 1.

Comparative User Report proposed format

*We need the ability to choose which base spreadsheets/tables to compare.

List cases where the Users are different between the two reports.

This will need to be based on Usernames as 2 users may be added and 2 deleted in a case so while the total number of users remains constant between 2 spreadsheets the users themselves have changed.

Case Report proposed format

Fields to display on the report include:

• Client Name (sort by this field)

• Case Name

• Client Status

• Total GB Value (calculated field based on by combining the following fields – Total Billable File Size, LDF Size, MDF Size & SQL FT Size)

• File Count

• Total Billable File Size

• Integration Points (If Integration Point Pushed Documents field is True display Yes or False display No)

Comparative Case Report proposed format

*We need the ability to choose which base spreadsheets/tables to compare.

List Cases which were not on the mid-month Case Report ie new Cases.

List cases where the Total Value calculated figure is higher in Spreadsheet 1 than it is in Spreadsheet 2.

Happy to answer any questions not addressed above.

Skills: Microsoft Access, Data Analysis, Report Development, Excel

See more: generate pdf reports online, vbscript parse csv files, plotting csv files excel, reporting - apps, generate reports, online report generator from excel, auto generated reports, analyze csv file online, visual reporting, create reports from csv, api based reporting tool, google base csv files, net csv files parse, scripting reading csv files, uploading csv files xcart, csv files can run unix, graph large csv files, graph csv files excel, load large csv files mysql, yahoo store csv files access

About the Employer:
( 2 reviews ) BRISBANE CITY, Australia

Project ID: #26387797

Awarded to:

mtdevil369

Hi, Greetings! ✅checked your project details :Build a tool to generate standard reports based on CSV files ✅Completed Time : 24 hours or your requirement deadline . I would like to work on your project and want to be More

$100 AUD in 1 day
(264 Reviews)
6.8

11 freelancers are bidding on average $106 for this job

schoudhary1553

Hello, I can help you with your project - Build a tool to generate standard reports based on CSV files I have gone through your job posting and become very much interested to work with you. I am an expert in this fi More

$180 AUD in 3 days
(355 Reviews)
8.0
finecodervw

Hi, As I understand you need a tool to be built to generate report form CSV files. It would help to get into a quick discussion on this. Keen to work on this project. I have recently completed MS Access based project More

$75 AUD in 3 days
(95 Reviews)
6.2
Linkmez

Hi, I have gone through your project of Programming. We are studying at Vietnam National University of Ho Chi Minh City, the University of Science as a major Information Technology. My team is familiar with Android & More

$99 AUD in 7 days
(9 Reviews)
5.5
AnowarRatul

Hello sir, I have read your project details and reviewed attachment carefully and understand it clearly. I can make Build a tool to generate standard reports based on CSV files by maintaining 100% accuracy of your data More

$179 AUD in 3 days
(144 Reviews)
5.7
akritisood94

Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project More

$140 AUD in 1 day
(52 Reviews)
5.0
nemanjadj20

Hello? I have been working for 5yrs+ in this field. I can provide great result that you are asking for. Please send me a message if you are interesting me. Thanks.

$155 AUD in 3 days
(4 Reviews)
3.9
muhammadumar84

Hi, I have gone through your project placement & it matches my expertise, I understand that you are looking for an expert in excel to extract only the required data and compare the reports. EXPERIENCE: 13 Years EXCEL: More

$60 AUD in 2 days
(10 Reviews)
2.6
MartinDavidd

Hello, As an expert of Data Analysis I am interested in your problem. I have full experience of 8+ years of Excel and Access. I will offer you high quality works. Please contact me anytime for discussion. Best rega More

$80 AUD in 1 day
(0 Reviews)
0.0
kanhaiyasingh05

I am expert in excel, microSoft acces,report deveplopment and data analysis. I will do your work in a minimum amount in best way. Give me one chance to so my talent on this plateform.

$30 AUD in 2 days
(0 Reviews)
0.0
basu4010

I have been working on DATA Analysis for the past 4 years as a part of my role as a Technology Analyst. Recent;y, i have worked on a project involving Macors, VBA and Excel. I feel , i would be able to help you with More

$65 AUD in 2 days
(0 Reviews)
0.0