Excel sheet work

$30-250 AUD

Dokončeno

Zveřejněno

před více než 6 roky

$30-250 AUD

Zaplaceno při doručení

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.

IČ projektu: 15407655

O projektu

23 nabídky

Vzdálený projekt

Aktivní před 7 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@MimiFL

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 v 0 dni

5,0

(325 recenze)

6,6

23 freelanceři nabízejí v průměru $67 AUD za tuto práci

@SBITServices

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 v 2 dnech

4,9

(264 recenze)

7,1

@P0L

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 v 1 dni

4,9

(215 recenze)

6,8

@nurnga1218

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 v 1 dni

5,0

(34 recenze)

4,4

@gr8tech

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 v 0 dni

4,9

(30 recenze)

4,5

@aubrey03

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 v 1 dni

4,8

(15 recenze)

4,4

@saadrashad

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 v 0 dni

5,0

(14 recenze)

3,8

@ScareCrow01

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 v 1 dni

5,0

(14 recenze)

3,8

@vmadhavan15

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 v 1 dni

4,7

(6 recenze)

3,3

@shafeekmohamed

I can do the project perfectly, If you want perfect project please contact me..

$30 AUD v 1 dni

5,0

(4 recenze)

1,3

@paulceralde

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 v 3 dnech

0,0

(0 recenze)

0,0

@vijayratiya

A proposal has not yet been provided

$33 AUD v 5 dnech

0,0

(0 recenze)

0,0

@MiraFaith

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 v 4 dnech

0,0

(0 recenze)

0,0

@sabiaf

A proposal has not yet been provided

$133 AUD v 3 dnech

0,0

(0 recenze)

0,0

@rajdeep77

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 v 2 dnech

0,0

(0 recenze)

1,3

@An0naman

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 v 1 dni