Find Jobs
Hire Freelancers

I need an Excel expert to help me set up a

$250-750 USD

Closed
Posted over 5 years ago

$250-750 USD

Paid on delivery
I want to build a rather big spread sheet and probably several. I have 5 boats, that i charter out to my customers. And i want to build a excel sheet where i can monitor work and earnings per hour, day, ,month etc. Also want to sort earnings per Client etc. I guess this will be a rather significant job, and i'm confident that the tasks i need help with will grow I'm from Norway, so we have to communicate in English.
Project ID: 17602631

About the project

33 proposals
Remote project
Active 5 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
33 freelancers are bidding on average $341 USD for this job
User Avatar
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to automate your processes of monitoring work and earnings. What you describe can be accomplished by smart pivot tables and a unified dashboard with meaningful charts (bar charts, donut charts and more). I'm going to spend less than 7-10 days to complete your project including required revisions for a total payment of $500. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Excel developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$500 USD in 10 days
4.9 (250 reviews)
7.6
7.6
User Avatar
Hi, I am a financial expert and a guru in Excel and VBA. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.). I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and cost acquisition. I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.
$750 USD in 10 days
4.9 (90 reviews)
7.2
7.2
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Let us see how we bring it out. Have delivered similar projects. Willing to take up your project. Thank you, Regards.
$250 USD in 4 days
5.0 (126 reviews)
6.5
6.5
User Avatar
Dear Sir/Madam, I have read you requirements. I can fulfill your requirement, just you will give me proper info and what you want. I am new in freelance but i working in sales sector by excel from 2012. I can give you a better quality and perfect format to make your business management easy & smooth. Would appreciate if you give me a chance to show my skill and experience. Thanks.
$333 USD in 2 days
5.0 (210 reviews)
6.4
6.4
User Avatar
Hello, I am an experienced Data Analyst with advanced excel skills. I can build for you an automated excel to monitor your business. Please check my portfolio to see my work. Just give me the opportunity to show you what i can do. Thanks!
$350 USD in 3 days
4.9 (49 reviews)
6.6
6.6
User Avatar
Hi there, Your project sounds very interesting and I would love to explore your specific requirements further with you. I think I would make a great fit to build out the perfect tracker tool for your boat charter business. I have over 17 years of corporate experience working in Excel creating advanced automated dashboards, reports, tools and calculators which included beautiful graphical displays of data/information. I enjoy creating complex algorithms using Excel formulas, and creating charts and graphical representations of data in Excel is one of my favorite things to do. How are you currently tracking your current works and earnings? Are you using an existing Excel model today for your business? I envision an all in one tool which would have a section to enter all charters including all of the associated metrics and data that would come from a charter (destination, client, cost, earnings, etc.) and then a separate dashboard page which would show all aggregate data by week/month for each client and boat as well as an overall view. I now operate my own Excel based home business 100% full time using the skills I've obtained throughout my corporate career. I have a few portfolio items on my Freelancer home profile if you want to take a look, and I have a more detailed file with numerous screen shots of my work as well – I can send it over for your review if you’d like. Hopefully I can hear more and we can work together! Thank you, Shaun
$300 USD in 5 days
5.0 (93 reviews)
6.6
6.6
User Avatar
I have a lot of experience on this kind of job, please check my portfolio, we can make a very useful dashboard so you can see all your Data in the best way possible
$250 USD in 10 days
5.0 (56 reviews)
6.2
6.2
User Avatar
- Based on the 5 boats and the chartered hours of the boats to the clients, The total durations the boat was charted for the day (meaning from begin date / time to end date / time if the ), Over a period of time The earnings by the boat for the day The earning by the boat for a period Earnings made from a customer over a period and other metrics can be calculated. - Also if a boat is already chartered to a client, and planning it for another client during the same period then the system will not allow. - Similar logics can be built out. - Have done similar Rental / Charter calculations and maintenance. - Also have done high complex automations listed below at the end. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables Sample HighComplex Projects using Macros: (via Freelancer) - Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations+..
$250 USD in 5 days
4.6 (49 reviews)
6.0
6.0
User Avatar
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$300 USD in 5 days
5.0 (22 reviews)
5.3
5.3
User Avatar
Hi, Equipped with my rich experience and with my expertise in Excel formulas, Power Pivot / Pivot tables, Charts with Slicers (filters) etc. and having delivered similar Projects across various freelancing platforms, I will be delivering the Business Tracker developed in Excel to meet all the requirements listed in this job post and over & above that, provide lots of value-add. The Excel workbook which would be delivered to you, would be designed to be very user-friendly, easy-to-maintain and scale-able to take care of future business growth. The workbook would contain the following tabs: 1) Rate master: to maintain Booking rates for each unique combination of boat and booking slots. 2) Customer Bookings spreadsheet: to capture incoming bookings and facilitate scheduling. 3) Dashboard using graphs to monitor trends in Booking frequency / count & trends in Earnings / Revenue, Peak & Lean Booking periods, Top 10 Customers by Revenue / Count etc. Slicers (filters) would be made available for tracking the above metrics on hourly, daily, monthly, quarterly, yearly, Client basis, Boat Id basis etc. as desired. Please do take a minute off to scan through my profile, especially the "Excel based services" portfolio and revert with any queries which you may have. BR, Devashish
$250 USD in 2 days
5.0 (14 reviews)
5.4
5.4
User Avatar
Hi, I am a Chartered Accountant / CPA having more than 10 years experience in advanced excel, accounting and finance. Please discuss in detail over chat right now as I did similar work on past. Thank you!
$250 USD in 3 days
4.9 (37 reviews)
5.3
5.3
User Avatar
Hello, You need a complete software to track your boat business. If I were you i would have prefered something better than Excel to grow my business with professionally and decency. The reason is, using Excel, you can fulfil what you need but that will be a little extra steps to manage all this. Time is money and putting extra time on a software is kind of wasting to me. I would like to build your software on MS Access so that, you can query out all the details you need in just one click. If you agree, we can discuss about that. However, your primary choice is Excel which is not bad. I can add 4-5 sheets with some cool functionality to track all your business. I am open for both technology which ever you like. Please ping me to discuss.
$300 USD in 5 days
5.0 (17 reviews)
4.8
4.8
User Avatar
Dear client? I highly value professionalism and hold myself strictly accountable to represent my client’s work. I aim to form a long-term working relationship. For 3 years I’ve worked in marketing and so I am accustomed to working with different tasks related to Excel. I have a deep passion for research and this guarantees you that all of my work is 100% original. I also ensure that I complete the work within the agreed time and a standardized rate. Please, consider my bid feel free to share more details about your project. Thank you.
$250 USD in 4 days
5.0 (19 reviews)
4.5
4.5
User Avatar
hi! let me help you with your project. I am very confident that I can help with all you need in excel spreadsheet earnings/customer monitoring. I would be happy discuss more about the project and to help you grow your business through my work. thanks
$360 USD in 7 days
4.9 (32 reviews)
4.8
4.8
User Avatar
I would suggest to have an executable instead of Excel. i can work on excel as well,but modern software that are very user friendly rely less on Excel. Here is my proposed solution 1-Boat definition Form where you can define boats. 2-Define Customers Form where you can define customers 3-Rent a boat Form where user will select a customer for a particular boat and assign rent per hour etc. 4-Reports. 1-Total earnings between dates. (can be weekly/monthly/daily or yearly) 2-Customer ledger total earnings/rent per customer Looking forward to have a chat with you to discuss further.
$400 USD in 10 days
5.0 (20 reviews)
4.4
4.4
User Avatar
Dear Client, Greetings. My name is Ajit Tomar and I would absolutely love the opportunity to do build the large spreadsheets for you. I am an experienced excel and office automation expert freelancer on this platform. I will help you with building the spreadsheet features and functions as per the requirements. If that suits your business, I can also build the spreadsheet in Google sheets. Unlike excel, it's free to use Google sheets and it also allows for real time online data sharing. All your data remains fully backed up and you can recover past versions if needed. It also keeps all audit history of changes. Price listed is negotiable. I can start working on this project immediately and can dedicate to it full time. Thank you for your consideration.
$250 USD in 3 days
5.0 (3 reviews)
3.8
3.8
User Avatar
Hi, I can show templates to choose for this work. Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: I want to build a rather big spread sheet and probably several. I have 5 boats, that i charter out to my customers. And i want to build a excel sheet where i can monitor work and earnings per hour, day, ,month etc. Also want to sort earnings per Client etc. Thanks.
$700 USD in 10 days
5.0 (17 reviews)
3.9
3.9
User Avatar
Hi, I have over 5 years of experience in MS Excel, macros, and VBA programming. I have worked on several project similar to this one, let me mention what my final output would look like: 1- data entry sheet. 2- dynamic interactive dashboard. 3- client reports. * all input/output criteria would be in drop-down lists for convenience of use. ** could make a single combined sheet for all 5 boats, or a separate sheet for each one. Would love to discuss further details and start working on the project. Regards.
$300 USD in 2 days
5.0 (9 reviews)
3.8
3.8
User Avatar
Hi I would like to work for you. I will provide highly credible excel spreadsheet with my senior level experience. You may validate my profile which is also certified as “Preferred Freelancer” and the highest trust score - 100%. You may look at my sample work and latest reviews of 43/50 Five Stars. I am a qualified professional having long industry experience in Business, Strategy and Finance with extensive research and writing exposure in this platform. With this background, I will be able to deliver better service for you. Look forward to hearing from you. Best Regards / Sanjib
$300 USD in 8 days
3.8 (7 reviews)
4.0
4.0
User Avatar
I am a mechanical engineer who deals with Excel to manage lubrication of about 2500 equipment with drive GBs and several bearings, all these schedule are managed through excel files, I can help you with my experience to manage your boats and control its data.
$250 USD in 5 days
5.0 (4 reviews)
2.3
2.3

About the client

Flag of NORWAY
Kristiansund N, Norway
5.0
2
Payment method verified
Member since Aug 19, 2018

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.