Find Jobs
Hire Freelancers

Excel sheet work

$30-250 AUD

Completed
Posted over 6 years ago

$30-250 AUD

Paid on delivery
I need to trigger a warning on when services are needed on a simple sheet . I have highlighted the areas that are used . We put totals into column G each week to update and then in column L is where the service KM's are triggered from . It would be an advantage to get a warning if the target has been reached so I can make sure the vehicle gets it's service.
Project ID: 15407655

About the project

23 proposals
Remote project
Active 7 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
Executing a warning (triggering it) when value in column G (which is update each week) is higher then value in column L (basically finding out that goal has been reached). Relevant Skills and Experience Excel Formulas, Excel VBA, Algorithm, Formulas, Calculation. I suggest that we complete this with single formula or formula + different formatting. Proposed Milestones $40 AUD - Complete work If you are interested in working with me, let me know what kind of message would you like to have when trigger is executed.
$40 AUD in 0 day
5.0 (325 reviews)
6.6
6.6
23 freelancers are bidding on average $67 AUD for this job
User Avatar
Hello , I have read your project description and understood your requirement. I have 5 years experience and can complete task with 100% requirements within time. Relevant Skills and Experience Skills : Excel, Macros,VB.net, Visual Basic,Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $30 AUD - Project
$30 AUD in 2 days
4.9 (264 reviews)
7.1
7.1
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.
$50 AUD in 1 day
4.9 (215 reviews)
6.8
6.8
User Avatar
What Warning do you want? would that be a sound or just a color or something? I've downloaded your xls file and I think I understand what you need. Relevant Skills and Experience I am an excel expert and I usually make a kind of an alert with a color. But, If you need it I can also make a sound. Proposed Milestones $40 AUD - Excel allert Stay tuned, I'm still working on this proposal.
$40 AUD in 1 day
5.0 (34 reviews)
4.4
4.4
User Avatar
I will provide cell validation in your spreadsheet to check that the Current Odometer has not reached or exceeded The next service mileage. A popup will be displayed when service is due Relevant Skills and Experience I have experience working with Excel Formulas and Validation Proposed Milestones $35 AUD - task completed
$35 AUD in 0 day
4.9 (30 reviews)
4.5
4.5
User Avatar
I am an Excel VBA expert. I am confident that I could create a macro that will display a pop up message when certain criterias are met. Feel free to contact me for details.
$30 AUD in 1 day
4.8 (15 reviews)
4.4
4.4
User Avatar
We use to set cell color on due date reaching. I can try implementing that scenario on you requirement. i also need to know if u manually type things or drop downs? Relevant Skills and Experience 16 years of experience in relevant field 245 reviews on freelancer.com all with 100% +ive reviews Proposed Milestones $66 AUD - milestone Do you manually type things or select from list? do u want a popup or a color change will also work?
$66 AUD in 0 day
5.0 (14 reviews)
3.8
3.8
User Avatar
I am good at excel Relevant Skills and Experience excel Proposed Milestones $56 AUD - Full Lets talk in chat so that we can discuss further
$56 AUD in 1 day
5.0 (14 reviews)
3.8
3.8
User Avatar
it is very simple to add a conditional formula in the column L but could you please provide more details Relevant Skills and Experience Excel Proposed Milestones $35 AUD - final pyament
$35 AUD in 1 day
4.7 (6 reviews)
3.3
3.3
User Avatar
I can do the project perfectly, If you want perfect project please contact me..
$30 AUD in 1 day
5.0 (4 reviews)
1.3
1.3
User Avatar
Trigger could easily be programmed on excel. I could help you with that. But I need further details on the sheet's functionality. Thanks! Relevant Skills and Experience Undergraduate research made me adept with working on spreadsheets.
$133 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$33 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very good in excel which also i did in my past work experience. Relevant Skills and Experience Data entry of patient's different diseases with codes and using merging cells. In statistics, need to merged cells and sum-up the total patients per specialty and by age group.
$155 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$133 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I will provide the auto notification alert through excel VBA. The work will be done in 2 days. Have more than 5 years experience in Excel application build. Relevant Skills and Experience Macro, Excel with more than 5 years experience in both. Proposed Milestones $40 AUD - Auto Alert
$40 AUD in 2 days
0.0 (0 reviews)
1.3
1.3
User Avatar
The whole row yellow when the KMs in column G equal the number in column L and then red if they go over buy an additional no. of Kms. Message appear seeking confirmation that service has been arranged Relevant Skills and Experience designed and built tools / registers and applications using Excel Proposed Milestones $25 AUD - Build conditional formatting to trigger as requested $30 AUD - Confirm that spreadsheet is working as requested Stay tuned, I'm still working on this proposal.
$55 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$45 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
East Victoria Park, Australia
5.0
24
Payment method verified
Member since Jul 23, 2014

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.