Find Jobs
Hire Freelancers

Create a custom Excel Spreadsheet

£20-250 GBP

Completed
Posted about 8 years ago

£20-250 GBP

Paid on delivery
I need a spreadsheet to monitor and log audience capacities and flow at a multi-venue event. The sheet should be set up to: Allow hourly data entry for at least 10 venues for: - Queue length (Long, Medium, Short) - Current Fill - Flag when 80% capacity (Flag Amber) and 100% capacity (Flag Red) - Poll data on entry to separate sheet to create flow charts (Fill/Time)
Project ID: 10399359

About the project

26 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
Hello, This is quite an interesting project. I believe the technical aspects are fairly simple (to me anyway). I think the bulk of the effort will need to be in making the sheets as user friendly as possible, robust and adaptable. I intend to send a first version that will have all the required features and will also be extremely usable, for review. After that I will incorporate any comments on usability and automation, and deliver the final version. Please note that I can think of a few automation features that could be added, but that greatly depends on who will use the sheets at the time of the event. Happy to discuss Regards R
£94 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
26 freelancers are bidding on average £125 GBP 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
£150 GBP in 3 days
5.0 (286 reviews)
7.3
7.3
User Avatar
Hello there, I am an expert in Excel and have created several excel templates like the one you are looking for. I am a highly rated freelancer here as you would see in my work history here and can assure you that I would be able to create a template that works like you would have envisioned. I would be able to create it and send it back in a couple of days. I am assuming that you need a sheet to enter the information and results should be displayed on the sheet such that the user may determine the fill very easily. If you could share some sample data that you have like venue name and capacity etc,, we could get started right away. Please drop a message to me with more details if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi
£150 GBP in 2 days
5.0 (252 reviews)
7.1
7.1
User Avatar
Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar dynamic excel templates for various clients and businesses. If you'd like to view my qualifications, experience and previous work, take a look at my Freelancer Portfolio, and if you are comfortable with those please contact me. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
£90 GBP in 1 day
5.0 (155 reviews)
6.5
6.5
User Avatar
Hi, I am good at Excel and vba. Looking forward to work on this project. I would like to discuss further on the requirements.
£150 GBP in 2 days
5.0 (168 reviews)
6.2
6.2
User Avatar
Hello Dear, I have read your project description and I’m an expert on these jobs and willing to start it right now! I Look forward to hearing from you. Regards Maariyaa
£250 GBP in 3 days
4.9 (190 reviews)
6.5
6.5
User Avatar
Hi: I have a question: Will you be using the Excel on Windows or Mac? Please note that I have 100% completion rate and 5-star feedback on projects. Over 90% of my completed projects are related to Excel and Macro. Please connect with me to discuss more.
£150 GBP in 3 days
4.9 (107 reviews)
6.5
6.5
User Avatar
I am Chartered Management Accountant from Chartered Institute Of Management Accountants UK, having 5 years of experience with excellent hands-on experience in financial modeling using MS Excel. We can help you to model the excel file for monitoring the requisites. Awaiting your kind response. Cheers, AHK
£250 GBP in 2 days
5.0 (77 reviews)
5.9
5.9
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
£166 GBP in 3 days
5.0 (100 reviews)
6.1
6.1
User Avatar
Dear Sir, I am expert in creating systems by Excel, Access and other programs, I can help you for that. Looking forward to have more details and ready to start now Regards Peter
£83 GBP in 2 days
5.0 (4 reviews)
5.7
5.7
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.
£100 GBP in 3 days
4.9 (68 reviews)
5.9
5.9
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
£78 GBP in 3 days
4.8 (69 reviews)
5.8
5.8
User Avatar
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start
£142 GBP in 0 day
4.9 (56 reviews)
4.9
4.9
User Avatar
Hi there, Your project sounds fun and interesting! I have over 13 years of corporate experience working in Excel creating advanced automated dashboards and reports - I'd love to create you the perfect automated audience tracker which would allow for tracking 10 or more venues with hourly data entry slots along with all of your listed requirements for alerts. We will also have the stats sheet with the fill/time chart. Hopefully you can give me the details of the capacities for each venue along with their names and I can get started on the tracker. Thanks either way and best of luck, Shaun
£83 GBP in 3 days
5.0 (15 reviews)
4.4
4.4
User Avatar
Hi, MS Excel expert here Kindly elaborate more the requirement i will design this for you in low cost Thanks
£80 GBP in 6 days
5.0 (15 reviews)
3.9
3.9
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
£111 GBP in 3 days
4.9 (26 reviews)
4.0
4.0
User Avatar
I am experienced in developing data import automation procedure. It can be conducting using the data tab from the excel functionality and VBA coding. More details should be provided to accomplish the blueprint of the solution.
£250 GBP in 3 days
5.0 (1 review)
3.3
3.3
User Avatar
Hello there - I am an Excel genius so this is nothing difficult. It will just take some organising to get the interface to be capable of handling N venues. I am a native English speaker so nothing will get lost in translation :) I kind of want to keep the data entry simple and on one page: one row per venue; ID number, Venue Name, Capacity flag, drop down for queue length, maximum capacity, current fill as recorded (absolute and %), new fill value to record (number not percentile) and button to commit the data to the data store. This could work better as a working table showing ID, Venue name, capacity flag, max cap, current recorded fill. Above this would be the data entry block where you would select venue from drop down, queue length from drop down and new fill value plus commit button. This would then store the data. As you add more venues it would add these to the working table on the page. The data would be behind the scenes for post-event reporting. I think I prefer this idea as it is more flexible. I'd wrapper it as an application so you can add new venues and their data etc... Anyways - hope that has given you some ideas. Would love to work on this for you. Hope to hear from you soon. /R.
£150 GBP in 3 days
5.0 (5 reviews)
3.0
3.0
User Avatar
Hello, I have ranking in top 6000 on freelancer.com and I hope it will give you an idea about my work quality and dedication to work. You will be safe while working with me. I am able to work on given tasks. I am having good command over database management, reports making, team handling, reports making and submission, add posting, make proper arrangements to finish various projects on time or before deadlines, play role as coordinator between team members and clients, calculate commission ect. I daily online from 10AM to 10PM IST and able to manage timing according to requirement. I am working as freelancer since 5.5+ years. I am also having 16+ years working experience as Sr. Accounts Executive Accounts & Finance. I made many MIS in excel based on various formulas to provide high results. I am able to handle work pressure and also able to work as team leader. Please go through my feedback comments; I hope it will give you an idea about my dedication to work. Let’s discuss with me about work planning. Thanks
£166 GBP in 7 days
5.0 (5 reviews)
2.7
2.7
User Avatar
Hello. I can develop a spreadsheet for monitoring audience capacities. I am an expert with excel and regularly develop spreadsheets for a variety of purposes, including design calculations, cost estimations, KPI dashboards, and more. I am an engineer so you can expect nothing less than detail oriented, meticulous, professional grade work, and an impeccable final product. Please send me a message to discuss additional details and I can confirm my commitment. I can provide a number of examples for you. I guarantee you will be very pleased with my work - if you can't tell already, I take ALL my work seriously.
£60 GBP in 1 day
5.0 (3 reviews)
2.8
2.8
User Avatar
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Financial analysis, Excel, VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presentations to board for a leading US bank. I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
£70 GBP in 1 day
4.9 (6 reviews)
2.4
2.4

About the client

Flag of UNITED KINGDOM
Brighton, United Kingdom
4.8
1
Payment method verified
Member since May 3, 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)
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.