Find Jobs
Hire Freelancers

Airport Terminal Control Spreadsheet

$10-150 USD

Completed
Posted about 6 years ago

$10-150 USD

Paid on delivery
Hello, I work as a ground controller at a major US Airport. We control aircraft pushing back from the gate and arrivals to the terminal area. We are looking for a computer based solution to what is currently done by hand. Currently, we hand write all aircraft call signs, gate assignments, and status updates. I have made an excel spreadsheet that is pretty decent and doing that, but I have some more features I would like to try and implement. I would like a stopwatch to start when I tell an aircraft to hold. I have a basic version in the attached spreadsheet, but would like a better looking timer that doesn't require cell updates to refresh. Something like this perhaps, but with individual timers in each row that can be triggered by selecting "HOLD"? [login to view URL] I'm not sure if this is something that is worth doing in excel, or if a standalone program would be better. I would appreciate your thoughts/opinions!
Project ID: 16653525

About the project

19 proposals
Remote project
Active 6 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 Lynne, you have done a very decent job with your current sheet, but what you need are self executing macros. which will get the automatic timers in your sheet. Also unlike the link you have attached, you don't really want a start and stop timer. You just want it to automatically start once you have the hold sign selected. Another function that can be included is the timer cell changing color based on your SLA. e.g if the target time for hold is less than 5 minutes, then the cell turns amber from 4:30 to say 5:50 and post 5:30 turns red. This becomes an easy visual management, to help prioritize. Your project needs someone who can not only understand your requirement, but also preempt your needs, and I believe I am the right person. I have over 10 years of experience working with companies like Pratt and Whitney, Accenture, Volvo.. So I can be a great asset, not only for this requirement, but also future requirements. As with any good service, there is a cost associated. So has mine. Ofcourse you can try the $20 bidders, and hopefully not waste your time, or you can chat up with me, and I will be happy to address any concerns or queries you might have. Regards Amin
$150 USD in 8 days
4.9 (6 reviews)
4.3
4.3
19 freelancers are bidding on average $56 USD for this job
User Avatar
I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity.
$50 USD in 1 day
4.9 (269 reviews)
7.1
7.1
User Avatar
Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel, working with multiple files with transferring data with / without changing data format. I have checked project description and sample file, I think it worth to be done in excel. Let's discuss further details on chat. Regards.
$30 USD in 2 days
5.0 (189 reviews)
7.0
7.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. I can make it in vba itself, to your requirement. However, I need more clarity on your requirement. Willing to take up your project. Thank you, Regards.
$50 USD in 2 days
5.0 (192 reviews)
7.0
7.0
User Avatar
I looked at what you have already created. You almost have it, just that a background process has to be created to continuously update automatically. Having a button in every row is not going to lead to problems when you delete any row, so please do not venture into that if you need it in excel. What you have is the best method.
$77 USD in 1 day
4.9 (27 reviews)
4.8
4.8
User Avatar
A proposal has not yet been provided
$25 USD in 7 days
5.0 (16 reviews)
3.8
3.8
User Avatar
Hi My name is Ravi and I'd like to be considered for your work. I'm a VC++, Python programer with strong background in Window and Web Application. Please send me a message to discuss it further. Ravikumar
$244 USD in 10 days
5.0 (4 reviews)
2.7
2.7
User Avatar
Hello sir we have complete team for that we are interested in your project we would like to work on it.
$25 USD in 1 day
5.0 (1 review)
0.7
0.7
User Avatar
HI, here is some thoughts: 1. create an array to store time of each row 2. create an array as a mask to store running/pause status of each row 3. accumulate the time of each row with the status = running I'm good at VBA in excel. Hope I can help you this project
$25 USD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
I see your excel file I can automate your timer. When you select hold it will show you how much time you hold in real time just like a stop watch.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I make webapps with Google sheets as database. I am able to create what you asked for and also can develop you an app with your Google spreadsheet as data base and make it more interesting if you wish. Because if you have a user interface that is not interacting with database directly will be more effective and sure. Waiting for your response. Thanks, Ajay
$35 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi dear, I am available to deliver your problem solution about computerized workflow. I have experience in custom application for we b & window platforms. please share your requirements if you interested with us
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello my name is Sarah, great that you're looking for an Excel specialist. This is my unique talent where I stand out, based on my previous client I've delivered a good result and a substantial job order, exactly like this. Just throw me an inbox so that we can discuss for more details.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$19 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Happy to work with you closely till you get exactly what you want. Your idea, my skills, your success.
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Highland Park, United States
5.0
1
Payment method verified
Member since Apr 8, 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.