Closed

Program the reads excel file,sorts and emails users

This project was awarded to dotnetsupercoder for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $250 USD
Total Bids
2
Project Description

Hello,

I need a program that emails an excel file with figures from an excel file

The program will allow me to input the sales rep number, email address, Week1 %, Week2 %, Week3 %, Week4 % (See Screenshot demos attached)

User selects the excel file - (See excel file attached)

The program will read the attached excel file, calculate the "Where I should be" column which is "Current Mth EUR TRG." divided by the number of days in the month multiplied by the week2 % (Because we are in week 2) e.g. F2/21*10.8

Then the program emails the "Sales Rep" the lines of the excel file that match their "Sales Rep Number" that is setup in the program. (See Email example attached)

Serious bids only please. More work guaranteed if project is successful - I will be available on Email and Gmail chat 9am to [url removed, login to view] GMT

Any questions please let me know.

Thanks, CWPS

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online