Closed

Excel programming

This project received 26 bids from talented freelancers with an average bid price of £106 GBP.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
26
Project Description

using example on sheet, i am looking to automate an excel sheet used for tennis betting. All sheets will update automatically and must not be altered, except for Import sheet. Here, I will copy data as shown. The prices in "2" correspond to "away team" and "1" to "home team". Players may be imported in different orders etc.

THe prices in sheet Betangel (1) g9 and g11 are live prices for the player (or home/away team).

1) When price of player is lower on import sheet than live sheet, place "BACK" in the green shaded cell in column L on Bet Angel 1, corresponding to the same player. Place the amount as shown in the corresponding cell in g9 or g11 (using the example).

2) When price of player is higher on import sheet than live sheet, place "LAY" in the green shaded cell in column L on Bet Angel 1, corresponding to the same player. Place the amount as shown in the corresponding cell in g9 or g11 (using the example).

3) Repeat for 50 other matches, which will appear on bet angel (2), betangel (3) etc.

I don't want to have to write any information in, just import the data and it does its thing. I don't want VBA as i need to edit the info after.

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