Find Jobs
Hire Freelancers

An Excel template that takes an imported set of time sheets and creates an output file

$750-1500 CAD

In Progress
Posted about 8 years ago

$750-1500 CAD

Paid on delivery
We need a template that can take an imported csv / excel file and process all the time entries into separate tabs by project, with descriptions of projects, people and costs in a summary form for review. At the end we need a button that gives us a csv import file for our accounting system so we can create invoices.
Project ID: 9490301

About the project

33 proposals
Remote project
Active 8 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
Hi, I am a scientist by profession with extensive experience in creating Excel templates to import, reformat and export data from complex datasets. I believe I will be able to create an attractive and easy-to-use template which will fulfill all your requirements. All template functions will be run from one initial 'Template Controls' page, with tabs generated after import for each project, and a summary page made available as soon as data is present. I will build in the capability to export each project as a separate .CSV, and possibly the ability to export the summary page as a .PDF or other file type if that suits your needs. To do all this I will require a copy of a file which is to be imported, and a template for the final .CSV for export so that I can create something which will be compatible with your systems. Please see my portfolio for some previous examples of my work, and don't hesitate to contact me over chat if you have any questions. Thanks for your consideration, Dan
$750 CAD in 5 days
5.0 (50 reviews)
5.2
5.2
33 freelancers are bidding on average $915 CAD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$1,000 CAD in 5 days
5.0 (882 reviews)
9.3
9.3
User Avatar
Hi! What's the frequency of getting new csv files? How many per day / week? Do you place all of them in the same folder? Please send me chat with replies and more details.
$750 CAD in 10 days
5.0 (404 reviews)
7.8
7.8
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$750 CAD in 1 day
5.0 (489 reviews)
8.0
8.0
User Avatar
Hi, I am an Excel macro expert and would be happy to take on your project. Let me know and we can discuss further. Regards, Arul
$1,000 CAD in 7 days
5.0 (173 reviews)
7.4
7.4
User Avatar
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
$1,000 CAD in 1 day
5.0 (326 reviews)
7.4
7.4
User Avatar
I can do it for you quickly and exactly
$833 CAD in 5 days
4.9 (122 reviews)
7.1
7.1
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$750 CAD in 1 day
5.0 (255 reviews)
6.6
6.6
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$800 CAD in 15 days
4.9 (118 reviews)
6.3
6.3
User Avatar
Hello This task can be achieved by implementing an Excel Macro. I can get it done in the next 3 to 5 days. Do share me the CSV file and the expected result format, if you are interested. Thanks
$750 CAD in 5 days
5.0 (113 reviews)
6.1
6.1
User Avatar
Hello, I am Excel and VBA expert. I can complete this project. I need examples: imported file and exported file for you system. Please note that I have 100% completion rate and 5-star feedback on projects.
$750 CAD in 7 days
5.0 (93 reviews)
6.1
6.1
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the project. Thank you so much.
$750 CAD in 20 days
4.9 (73 reviews)
5.7
5.7
User Avatar
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 3 years. 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.
$1,000 CAD in 10 days
4.9 (18 reviews)
5.7
5.7
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards
$750 CAD in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am an experienced MS Office, VBA, Graphic Designing, PDF and Data Entry expert. Your kind response is being awaited.
$872 CAD in 15 days
4.9 (28 reviews)
4.5
4.5
User Avatar
Over the last 20 years I have completed over 100 projects using Excel VBA code to manipulate and analysye data, including importing / aggregating data from csv files.
$750 CAD in 7 days
5.0 (3 reviews)
3.8
3.8
User Avatar
Understand you do not expect macro to do online download/ upload. I am proficient in Excel macro and formulas. Your budget seems high. Please elaborate your requirement and we can discuss the commercials. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight
$750 CAD in 10 days
3.9 (9 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$750 CAD in 7 days
5.0 (5 reviews)
1.9
1.9
User Avatar
Hello! Can do this task for you very quickly. Know Excel very well. I have wide experience in writing utilities on C++/C#/PHP (including client-servers scripts, working with CSV, databases, web scraping, monitoring and control systems, and so on). So I want to disquss with you details of this project and perform it. Almost always online, waiting for your answer Thank you.
$750 CAD in 5 days
5.0 (2 reviews)
0.8
0.8
User Avatar
Dear Employer. I'd like to get this job, because I work as an accountant for 5 years, so I know MS Excel very well (Pivot Tables, functions). I'm looking forward to show you my skills and I think that is a kind of job I can do. I'm ready to do your job even now.
$777 CAD in 5 days
5.0 (1 review)
0.9
0.9
User Avatar
Already Worked on similar projects. and have experience of around 4 years on excel macros and automatons. Thanks! Shanta
$1,250 CAD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Burnaby, Canada
0.0
0
Payment method verified
Member since Jan 28, 2016

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.