Find Jobs
Hire Freelancers

Aggregate, compile and display raw data into tables and graphs

$30-250 CAD

进行中
已发布将近 9 年前

$30-250 CAD

货到付款
Project scope: Create an excel template that will generate the desired graphs and tables from the raw data provided Tabs: Tab 1: Raw data source (a simple copy/paste of the raw data will be inputted here, see example provided) Tab 2: Weekly stats (will have one cumulative graph and aggregated table for each week of the year - Week 1 to 52) 52 graphs/tables are required Tab 3: Monthly stats (will have one cumulative graph and aggregated table for each month of the year – Jan to Dec) 12 graphs/tables are required Tab 4: Yearly stats (will have one cumulative graph and aggregated table for each year) one graphs/table is required Data rounding Time of the day will be rounded to closest lower 30min increment ex: 8h00-8h29 = 8h00, 8h30-8h59 = 8h30 Tables: Data should be aggregated into a table (weekly, monthly and yearly) before being displayed into a graph. Table must be displayed on same tab for each graph. Ex. Weekly: Week 1 Year 2015 Time # of Pick up # of Drop off Monday 7h30 6 2 Monday 8h00 5 9 Monday 8h30 7 3 … … … Tuesday 7h30 6 8 Tuesday 8h00 3 1 Tuesday 8h30 9 4 … … … Graphs Title: Weekly: Week X / Year Y Monthly: Month X / Year Y Yearly: Year X X: Fixed values Day of the week (Mon-Sun) + Time of the day (from 7ham to 12ham in 30mins increments) Example: Mon 7h00 7h30 8h00 8h30 9h00 9h30 … Tue 7h00 7h30 8h00 8h30 9h00 9h30 … Wed …. Y: Dynamic values from 0 to the max # of pick ups/drop offs present in the graph Number of Pick ups vs Drop offs made at that day and time (X) Two side by side vertical bars in different colors to clearly identify pick ups and drop offs Example: 0 to max # of reservations present in this graph Legend: Identify color used in graph for pick ups and drop offs
项目 ID: 7708612

关于此项目

14提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions
$190 CAD 在2天之内
4.9 (257条评论)
7.7
7.7
14 freelancers are bidding on average $149 CAD for this job
用户头像
Hi! So, you need 3 tabs (weekly, monthly and annual) for tables and 3 charts. Right? I am preparing sample sheet, will send you by chat. Thanks
$125 CAD 在3天之内
5.0 (410条评论)
7.7
7.7
用户头像
Good day! Im very interested to do this project. I worked as admin support for almost four years in one of the outsourcing company here in the Philippines. I did similar to this project and the client was very happy with my work and decided to give me a couple of projects after that. Please check the FEEDBACK/REVIEWS www.freelancer.com/u/weblazer.html of my previous client to prove that i did a very good job. I hope you will consider me for this job. Thank you and i hope to hear from you soon. NOTE: Why i have low completion rate? Because i have lots of previous projects and i don't want to delete hoping they will give me another project. I suggest to check my feedback/reviews. Sincerely yours, Sonny Aldave Freelancer
$166 CAD 在3天之内
4.9 (99条评论)
7.4
7.4
用户头像
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$188 CAD 在4天之内
5.0 (288条评论)
7.2
7.2
用户头像
Hello Dear, many many greeting of the day! I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
$250 CAD 在3天之内
4.9 (167条评论)
6.7
6.7
用户头像
More than 14 years of experience in Banking/finance, Copy Typing, Web Research, Scrapping, data compilation, social media and Data analysis. I am an expert in MS Excel, which includes Dash Board preparation, Mail merge, Formulae, Macros, Charts, Template creation, Pivot, etc., I am very quick in completing tasks using my keyboard, shortcuts and multitasking skills.
$111 CAD 在1天之内
4.9 (81条评论)
6.1
6.1
用户头像
Hello Sir/Madam,i am ready to start your job as per your requirement Thanks this great opportunity,if you like than we can discuss further, awaiting for your positive response.I have been working in the field of Data-Entry,Excel,Web Search,Web scraping,Leads,Data Processing etc job from the last 4 years. I am good fit for your projects as i always be sincere with my clients and with my work. I aim to bring a modern but experienced approach to your projects. Allow me to provide you good services based on my experience and bring you vision to life looking forward to hear from you. Thanks
$155 CAD 在1天之内
3.8 (45条评论)
5.0
5.0
用户头像
As a part-time post-graduate student, I deal with a lot of data. I am also required to analyze those data either in excel or SPSS format. Hence, I believe I can do this project to the best of my abilities, and do it well and accurately within the time frame of 5 days, or even less. Please feel free to contact me further should you have any inquiry. Regards, Sharifah
$144 CAD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Ihave more interert this project.........................................................................................................................................
$155 CAD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Dear Hiring Manager, I am applying today for job which I saw listed on freelancer. I am very familiar with Data Entry, Data Processing, Excel and Web Search. During my 3 years as marketing executive of GlaxoSmithKline Bangladesh Ltd. I did lots of job that seems pretty similar to this one. Now I’m going to give you a short summary about my skill, I hope it will help you determine about my key strength for your job. You can see some of my own writing in my portfolio (https://www.freelancer.com/u/AnopomSarker.html) 1. My hourly rate is low & negotiable but I can provide you best quality work. 2. I’m honest & trustworthy, dependable & fast learner. 3. I’ve over 3 years’ experience in data entry work. 4. I am available 20+ hours a week for your job. If you’re like my skill and want to discuss this job further please notify me. I’m looking forward to hearing from you soon. Thank you for considering my cover letter, Regards Anopom Sarker
$50 CAD 在3天之内
0.0 (2条评论)
0.0
0.0
用户头像
good typist............................................................................................................................................
$155 CAD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

CANADA的国旗
Mont-Royal, Canada
5.0
3
付款方式已验证
会员自5月 12, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。