Find Jobs
Hire Freelancers

custom excel report

$30-250 USD

クローズ
投稿日: 約9年前

$30-250 USD

完了時にお支払い
I need to have a report made using the file attached. I can not change the layout of the outputted file from our Pyramid TimeTrax attendance software, so I need the attached file queried or reorganized programmatically on a regular basis. I need to generate a report for each employee that shows their 1. average arrival time in the morning 2. average time they leave for lunch 3. the average duration of their lunch 4. the average departure at end of day The numbers of employees will change along with names, as people are hired on or leave, so it needs to be flexible. I can work with excel or ms access 2010 for this, but prefer it to all be excel based if possible. This needs to be something that I can do each week, very quickly and easily, so I will need its function detailed so I can reproduce consistent results.
プロジェクト ID: 7085300

プロジェクトについて

40個の提案
リモートプロジェクト
アクティブ 9年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に40人のフリーランサーが、平均$100 USDで入札しています
ユーザーアバター
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$44 USD 7日以内
5.0 (642 レビュー)
8.7
8.7
ユーザーアバター
Hi, I am good at excel and macros... I can create vba. Please see my experience list in the freelancer. I will create vba to meet your requirement with all the conditions satisfied. Looking forward for your reply to start the work on immediately.
$65 USD 2日以内
5.0 (1212 レビュー)
8.4
8.4
ユーザーアバター
Hello! I'm an Excel expert and I would like to help your report. Please check my profile and contact me to discuss further details. Regards.
$100 USD 1日以内
5.0 (491 レビュー)
8.0
8.0
ユーザーアバター
Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in a reputed Power Plant in India. Data Integration and Compilation is my prime job over there. Making reports in Excel and Powerpoint is my routine job, which gives me an edge to carry out the project. I am a new Freelancer so I have the earnest desire to carry out the project successfully. So please consider my proposal and give me a chance to boom in the market of Freelancer. Kindly contact me for further details. Thanks and Regards Tonmoy Roy Electrical Engineer
$30 USD 3日以内
5.0 (496 レビュー)
7.7
7.7
ユーザーアバター
A proposal has not yet been provided
$250 USD 2日以内
4.9 (330 レビュー)
7.7
7.7
ユーザーアバター
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$100 USD 3日以内
5.0 (326 レビュー)
7.4
7.4
ユーザーアバター
Dear, I am Access/Excel expert since 11 years. I checked your project description, and I confirm I can develop your Excel reports. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$121 USD 3日以内
4.7 (91 レビュー)
7.4
7.4
ユーザーアバター
Hey, I reviewed the spreadsheet you shared and kind of understand what you are looking for. This seems to be the output of an access control system from which you need to do some analytics and give person level metrics. I think the best way to do this is to write some macros that will take this file as an input, analyze the complete data and present the results on say a 'report' sheet. I can certainly write such a macro. I do have a few questions like for example, I noticed that all the time stamps show only "Out" while "In" is blank throughout the spreadsheet. So, how do we calculate the duration? If you could answer these questions based on your current manual process, I would be able to automate it for you. Once automated, this process could be as simple as clicking a button and getting the results. Does this sound exciting? Do let me know. I am an expert in Excel with more than 400 projects delivered successfully (as you would see in my work history here on freelancer) and can assure you of excellent and accurate work. Look forward to hear from you. Thanks and Regards, Shikha
$277 USD 5日以内
4.9 (101 レビュー)
6.6
6.6
ユーザーアバター
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD 5日以内
4.9 (120 レビュー)
6.3
6.3
ユーザーアバター
Hi there....I had a look at the attached excel sheet(6189 rows)...we can generate the reports that you have mentioned (number of employees does not matter)....Please reply...we can discuss further and get this started...thank you...
$64 USD 2日以内
4.8 (168 レビュー)
6.0
6.0
ユーザーアバター
Hi, Approach: I completed similar project for another client. Please have a look at project details and feedback: https://www.freelancer.com/projects/Excel/some-Excel-Work.6649364.html My background: I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on designing, implementing and analyzing ACBC (conjoint) surveys, pricing models, income statements, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$122 USD 3日以内
4.9 (38 レビュー)
5.6
5.6
ユーザーアバター
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$100 USD 2日以内
4.9 (22 レビュー)
5.8
5.8
ユーザーアバター
Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Feel free to message me and to start the project after your reward my bid. Thank you.
$60 USD 1日以内
4.9 (73 レビュー)
5.7
5.7
ユーザーアバター
I have downloaded the attached sheet, i have few questions. I guess we can use VBA programming to achieve the task. 1-average arrival time in the morning The time card are of different dates and of different employees, do you want average arrival time by employee or complete average time of all employees. 2- Will the format of excel sheet remain the same ? Looking forward to clarify more via chat
$130 USD 7日以内
4.8 (43 レビュー)
5.4
5.4
ユーザーアバター
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done projects related to VBA and VB in past. I am currently going through all the attachments to have a clear view. If you like my proposal,lets start. Thanks Abhinov
$100 USD 3日以内
4.9 (44 レビュー)
5.2
5.2
ユーザーアバター
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
$98 USD 5日以内
4.6 (45 レビュー)
5.6
5.6
ユーザーアバター
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can do this report for each employee and kind of create a template where you can feed the raw output from Time Trax software and the it will give the results automatically on another sheet (one row per employee). Please message me so that we can proceed further. Thanks ! Regards Dan
$111 USD 3日以内
4.9 (10 レビュー)
4.3
4.3
ユーザーアバター
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Acess and VBS tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
$105 USD 3日以内
5.0 (20 レビュー)
4.1
4.1
ユーザーアバター
I have the required expertise for your project. Check my portfolio and reviews, my works have quality and warranty.
$111 USD 5日以内
4.8 (11 レビュー)
3.7
3.7
ユーザーアバター
Dear Sir, I've done similar excel report before and can work on your project immediately. Regards,
$185 USD 7日以内
5.0 (1 レビュー)
1.2
1.2

クライアントについて

UNITED STATESのフラグ
Jackson, United States
5.0
16
お支払い方法確認済み
メンバー登録日:7月 21, 2012

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。