Closed

Check for new data in Microsoft Excel Sheets and send email if specific data changes are found

Scope of the programme

The scope of the programme is to check a Microsoft excel sheet every hour. The excel sheet is constantly updated with new data. If the excel sheet contains specific data changes an email is then sent to me to inform me of these changes.

More information

The excel sheet data is updated automatically on a constant basis. The programme needs to compare the latest set of data (displayed in the last row) with the data collected previously. If specific changes between the new data and the old data happened, an email is sent to me. Note: The new data in the excel sheet is not inputted by a user but is collected automatically as the excel sheet scrapes data from a website.

The specific changes (see attached screenshot for reference)

1. Trigger1: If the new value in column E (last row) has increased by 70% (when compared to the value in the previous row) AND if the new value in column E is bigger than 3.2

OR

2. Trigger2: If the new value in column J (last row) has increased by 80% (when compared to the value in the previous row) AND if the new value in column J is bigger than 1.2

THEN

An email is sent to a specific address with the following information:

In the case of Trigger1

(i) the last two values in column E

(ii) The percentage increase between the two values

(iii) The last four values of column R

(iv) The value in cell C1 (name of the football game)

(v) The value in cell F1 (starting time of football game)

In the case of Trigger2

(i) the last two values in column J

(ii) The percentage increase between the two values

(iii) The last four values of column R

(iv) The value in cell C1 (name of the football game)

(v) The value in cell F1 (starting time of football game)

---

Details

• The programme needs to check multiple excel sheets

• The user needs to be able to identify which excel sheets to check

• The user needs to determine how many times an hour the excel sheets are checked

---

User settings

The user needs to be able to:

• Select the excel sheets that will be checked

• Select how often the excel sheets are checked

• Chose the specific email address to send email to

The user also needs to be able to adjust:

• For Trigger 1: (i) the percentage increase to activate the trigger (example 70%)

(ii)the value that activates the trigger (example 3.2)

• For Trigger 2: (i) the percentage increase to activate the trigger (example 80%)

(ii)the value that activates the trigger (example 1.2)

Note1:

These settings need to be ‘saved’ permanently and only changed when the user needs to change them. They do not need to be adjusted every time the programme runs.

---

Note2:

Please explain the software you plan to use and the methods to accomplish this project.

---

Note3:

Attached please find a screenshot that helps to better understand the explanation above.

---

Budget

There are budget limitations and given I am not a business I am not in a position to pay a lot of money.

---

Skills: Excel

See more: excel macro send email attachment, excel macro send email, microsoft access 2013 send email, excel macro send email outlook, send email specific time, trigger excel spreadsheet send email, excel vba send email registration, excel macro send email automatically, excel vba send email questionnaire, using access send email specific email address, send email webpage changes, excel vba send email automatic, send email specific time php, php script send email specific email address, php code send email specific address

About the Employer:
( 2 reviews ) Malta

Project ID: #16033352

16 freelancers are bidding on average €32 for this job

schoudhary1553

Greeting, I have understood your Check for new data in Microsoft Excel Sheets and send email if specific data changes are found task and can do it with your 100% satisfaction. Please ping me for more discussion. More

€50 EUR in 1 day
(206 Reviews)
7.2
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

€50 EUR in 2 days
(237 Reviews)
7.0
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsI nc VBA/EXC More

€23 EUR in 1 day
(45 Reviews)
5.3
magentapowa

Hello What method are using to scrape the data? It is very likely that what you need can been implemented inside those running macros that you have. Otherwise I believe it is harder for an external program to catch Ex More

€30 EUR in 2 days
(20 Reviews)
3.9
ismailsajid324

i am specialist in ms office 2013 professional plus .you will be happy by assigning project to me. thanks

€23 EUR in 1 day
(0 Reviews)
0.0
itman9999

Have a lot of experience of such data scrapping projects. And also have experience of Word, Excel VBA macros. I'm sure you can get best results, if you hire me.

€111 EUR in 1 day
(0 Reviews)
0.0
€23 EUR in 1 day
(0 Reviews)
0.0
ElioRemolina

tengo el tiempo necesario para realizar lo pedido..............................................................................

€24 EUR in 10 days
(0 Reviews)
0.0
HaiderAliedu

I Will Do the Perfect and Expert in this [url removed, login to view] Give me this Job My Professional Skills Experience with Microsoft Suite (Word, Excel, Powerpoint etc.) Excellent grammar and a high attention to detail Data entry More

€24 EUR in 1 day
(0 Reviews)
0.0
€23 EUR in 1 day
(0 Reviews)
0.0
Albertojoselodi

Según las instrucciones mencionadas por el empleador debo mantenerlo informado si se realizan algún tipo de cambio dentro de los parámetros establecidos. Me desenvuelvo bien con las hojas de excel y con las fórmulas de More

€19 EUR in 2 days
(0 Reviews)
0.0
vipingfreelancer

Hello,I am Computer Science Graduate(Techie guy).I am currently doing Virtual Assistant Job for US Based Fashion designing company as well a Cyprus based IT Company in that i have done various job like Data Entry,Typin More

€10 EUR in 1 day
(0 Reviews)
1.1
arunytech

HI SIr I am very interesting excel i can complete your project i am sure please feel free to contact with me any time thank you

€24 EUR in 4 days
(0 Reviews)
0.0
Mahm0udMetwally

I will use matlab, and i will make a standalone .exe application for it, or .app (mac) application, or both if you want. will make it send mail to the mail you want, and attach with it the changed excel file. i will ma More

€19 EUR in 1 day
(0 Reviews)
0.0
€23 EUR in 1 day
(0 Reviews)
0.0
balaji2656

Dear Employer We will give you the best result by using my Past experience and excellent academic skills on your project. you can chat with me and let's get started.

€30 EUR in 2 days
(1 Review)
0.2