Excel Data Analysis

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

技能: 数据输入, 数据处理, Excel, Visual Basic

查看更多: excel, data analysis,vlookup,pivot, advanced excel, data analysis,, outsource excel data analysis to india, excel data analysis tutorial, data analysis excel 2013, data analysis excel 2016, analysis toolpak download, excel data analysis regression, data analysis in excel 2007, data analysis excel mac, data analysis using excel pdf, data processing, excel, visual basic, visual basic for apps, microsoft excel, microsoft excel data analysis and business modeling templates, looking for excel data analysis and forecast of china paid a commission, freelance exchange spss excel data analysis, freelance excel data analysis

( 2个评论 ) Sydney, Australia

项目ID: #15408285



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 更多

$250 AUD 在3天内

42 威客就此工作平均出价 $395


Hello ASON Group, I have checked the attached PDF and understood your requirement. I can prepare a tool to generate all reports you asked ans also you can make costume reports by using the developed tool. I have 5 ye 更多

$250 AUD 在6天内
$555 AUD 在10天内

"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 更多

$300AUD 在1天里

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 P 更多

$250 AUD 在3天内

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 analy 更多

$444 AUD 在5天内

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 更多

$555 AUD 在10天内

Hi, I am expert in Excel, VBA and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dynamic dashboards and Reports. Relevant Skills a 更多

$500 AUD 在5天内

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 pe 更多

$250 AUD 在4天内

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 更多

$250 AUD 在10天内
$300 AUD 在10天内

Will be done Relevant Skills and Experience Excel Proposed Milestones $277 AUD - Excel Let me know when you want

$277 AUD 在15天内

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 更多

$277 AUD 在10天内

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 更多

$270 AUD 在2天内

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 在10天内
$250 AUD 在3天内
$555 AUD 在10天内

A proposal has not yet been provided

$388 AUD 在10天内
$277AUD 在1天里

Thank you for providing opportunity to help with your car parking analytics. I thoroughly understand your requirement and can also provide additional views to help you take informed decisions. Relevant Skills and Exp 更多

$300 AUD 在10天内

Hi, please consider me for your parking data analysis, as I have significant experience in excel, and am comfortable transferring data from PDF's and generating relevant statistics. Relevant Skills and Experience I ha 更多

$260 AUD 在3天内