Find Jobs
Hire Freelancers

Excel Data Analysis

$250-750 AUD

Completed
Posted over 6 years ago

$250-750 AUD

Paid on delivery
I require a review of car parking data for a one month period. The data currently shows the entry and exit times for all vehicles. I require the data to be analysed to provide: 1. Entry volumes by 1 hour time intervals for each day 2. Exit volumes by 1 hour time intervals for each day 3. Car park occupancy by 1 hour time intervals for each day The data for 1 and 2 can be shown as bar graph (or similar) with 3 being displayed via a bell curve (or similar) graph format. The data is currently provided in pdf format and will be required to be converted to excel and aggregated to a master sheet with each day provided as a new tab plus a summary page showing results for points above. The project will require a sample day period to be completed first (to ensure correct methodology) and then undertake for all days provided. A sample of a single day data is attached
Project ID: 15408285

About the project

40 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I can complete this project with Excel VBA macros. I will first use them to transfer data from PDF in a format allowing performing full analysis as pictured in description. I would allow user to load PDF data from a folder, which would update Excel file's database and analysis with charts within. Regards Relevant Skills and Experience I'm a full-time VBA developer. I have experience in processing and analysis of big data sets with time stamps, close to this being stock data analysis, weather measurements, employee in and out data. Proposed Milestones $250 AUD - Excel VBA macro to load PDF files and perform analysis of data Is OS Windows? Automation of data analysis for a sample is 90% of the work, so I suggest 1 milestone. I would need information about car park occupancy in any given point of delivered data set, to be able to calculate this statistic, based on following / preceeding entries and exists.
$250 AUD in 3 days
5.0 (64 reviews)
5.3
5.3
40 freelancers are bidding on average $394 AUD for this job
User Avatar
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a Multinational Telecommunication Company as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$300 AUD in 1 day
4.9 (275 reviews)
7.1
7.1
User Avatar
Will do in 100AUD Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Thanks & Regards, Team@The24CarrotsInc Relevant Skills and Experience VBA/EXCEL Proposed Milestones $250 AUD - 100% Satisfaction Of Deliverable
$250 AUD in 3 days
4.9 (71 reviews)
5.9
5.9
User Avatar
Hello! Being one of the most experienced Statistician/Mathematician on this website with around half thousand excellent reviews and proven track record, I would love to work on this project. I am experienced data analyst also familiar with almost all statistical softwares including SPSS, R, Stata, Eviews, Mathematica, SAS, Weka, Minitab, Python and Matlab etc. Please reply back to discuss further. Thank you! https://www.freelancer.com/u/sheak#/reviews
$444 AUD in 5 days
4.7 (22 reviews)
5.7
5.7
User Avatar
p.s. If you agree I can do it via Ms Access also(with Excel etc automation if need). Hi, based on your Project Description and your PDF , I can build Excel xlsm for it. Relevant Skills and Experience ms Access/Excel/VB programmer since Ms Office 97 released Proposed Milestones $555 AUD - default
$555 AUD in 10 days
4.7 (33 reviews)
5.8
5.8
User Avatar
HI, I want to work for you to calculate the entry and exit data form your PDF and show it in a different excel sheet or graph. If you want I will show it in a graph for every month exit and enter depending on time period Thanks. Relevant Skills and Experience Excel formula, graph, pdf Proposed Milestones $250 AUD - for whole work But You have to give little more time. Thanks. Shahidul.
$250 AUD in 4 days
5.0 (16 reviews)
5.2
5.2
User Avatar
Good day. What we can do is to port the data into MS Access and then show the resulting charts and report in excel. It will be more user friendly and more flexible than one built entirely in Excel. Relevant Skills and Experience I have built a similar project where my client asked me to analyse data and show charts based on them. You can view it in my portfolio. It's a simple import of data and one-click of a button. Proposed Milestones $250 AUD - Project Completion
$250 AUD in 10 days
5.0 (32 reviews)
5.1
5.1
User Avatar
I certainly do have a clear idea of what your requirements are. I am a professional Virtual Assistant with experience in Data Entry projects. Please do get back to me if you find my proposal suitable. Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones $277 AUD - Excel Data Analysis Kindly come over to chat so that we can discuss further.
$277 AUD in 10 days
5.0 (7 reviews)
3.5
3.5
User Avatar
Will be done Relevant Skills and Experience Excel Proposed Milestones $277 AUD - Excel Let me know when you want
$277 AUD in 15 days
5.0 (17 reviews)
3.7
3.7
User Avatar
Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) Habilidades y experiencia relevante I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget. Htos propuestos $270 AUD - Performing data analysis in Excel
$270 AUD in 2 days
4.8 (21 reviews)
3.4
3.4
User Avatar
I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivering the project well advance in time.
$250 AUD in 10 days
5.0 (2 reviews)
2.4
2.4
User Avatar
Experienced MS Excel expert Freelancer here to work for your project. Relevant Skill and Experience. I have done numerous job of this kinds.
$250 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i can do that please give me the project that would be a boost God bless u
$500 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do it a week. Stay tuned, I'm still working on this proposal.
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are a testing firm and have a sufficient number of resources who can perform this data analysis task. Please let me know the requirement and we are ready to provide our sample work Relevant Skills and Experience Data Analysis Data Entry Proposed Milestones $555 AUD - Complete solution
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I saw your project and read its details I want to do it because I am sure I can do it and I have skills that your project needs. Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones $555 AUD - Project milestones
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$333 AUD in 5 days
5.0 (1 review)
0.0
0.0
User Avatar
We are an independent software testing and data entry company. We have number of resources who have prior experience in data processing task and can perform the task efficiently. Relevant Skills and Experience Data Processing Data Entry Data analysis Proposed Milestones $555 AUD - COmplete data analysis solution
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$273 AUD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$444 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
2
Payment method verified
Member since Oct 13, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.