Completed

Write a macro

I need a macro writing to perform the following function within the attached workbook.

The example file shows my value odds for every horse in each of the day's races. imported from another file.

When a horse becomes a non-runner I want to be able to delete the relevant full row of data, and have the ValueOdds_Probability (column G), and ValueOdds_BetfairFormat (column H) automatically update to the correct new values.

Columns B and C are the identifiers, i.e. if the data in those columns matches, that is 1 race. (e.g. rows 2 - 16, are 1 race).

The ValueOdds_Probability (column G) must always total 1.0 when summing the values for each horse in the race. (e.g. SUM(G2:G16)=1.0). If a horse becomes a non-runner and it's data is removed, the remaining values need to be scaled so that the race total value still equals 1.0

The ValueOdds_BetfairFormat (column H) are calculated from the values in column G using the simple formula: 1/ValueOdds_Probability

There is already a macro in this workbook, which has been run on imported data, producing the example file.

Please do not bid if you have not read and understood the requirements!

This is a quick and easy project for an Excel expert ... it DOES NOT require a web developer or 5 days to complete.

Skills: Data Processing, Excel, Visual Basic

See more: write macro export sql, write macro automatically forward email outlook, write macro cut paste excel, how to create a macro in excel 2016, how to create a macro in excel 2013, excel macro examples, use of macros in excel, macros in excel for beginners, macros in excel 2016, excel macros for dummies, macro excel tutorial, write macro search find, write macro outsource, vba macro guess sum function, write macro excel lotto, write macro outlook 2007, write javascript display sum number, excel macro column sum, write program will sum integers using pointers, write macro excel uses internet window

About the Employer:
( 11 reviews ) Dreghorn, United Kingdom

Project ID: #18041720

Awarded to:

ilkecokay

Hello excel expert here. I can prepare it for you immediately (using VBA) if you are interested. Thanks. Please message if you are interested.

£18 GBP in 0 days
(12 Reviews)
3.9

30 freelancers are bidding on average £22 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

£22 GBP in 0 days
(637 Reviews)
8.3
bouslimi1979

Hi, how you will mention that such hors is out ? First idea is a button once clicked will show the list of all the horses, you select the one to delete and click ok. The row will be deleted and the probabiltities updat More

£39 GBP in 1 day
(264 Reviews)
7.5
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

£21 GBP in 1 day
(115 Reviews)
6.6
TonmoyRoy111

Dear client I understand the requirements you mentioned. I can do it for you. Please contact me. Roy

£40 GBP in 1 day
(271 Reviews)
6.5
diorisaguilar

I have got a doubt in your requirement, what should happen if "Early Voice" horse is deleted (row 6), the ValueOdds_Probability value = 0.07365 should be distributed along the remaining horse to keep the total sum equa More

£18 GBP in 1 day
(39 Reviews)
6.0
macroPOL

Hi, I understand the project and I can do it today. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

£20 GBP in 1 day
(64 Reviews)
5.7
£18 GBP in 1 day
(67 Reviews)
5.8
supper5guy

Hello there, as an expert in excel and VBA, i can help you to accurately write such a vba code as you have specified. Please contact me and let us talk more about your project. Thanks

£20 GBP in 0 days
(70 Reviews)
5.3
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

£100 GBP in 3 days
(56 Reviews)
5.4
sloker18

I am proficient with excel macro/VBA development, I can write the macro to recalculate the probability as specified, I do need the formula to calculate the probability though, if you are interested feel free to message More

£20 GBP in 1 day
(47 Reviews)
4.9
£20 GBP in 1 day
(54 Reviews)
5.1
fcbarnard

Please find my proposal for this project. I will definitely be able to complete the project. The only question that I have is how do you calculate the ValueOdds_Probability or is that provided. The rest of the ask i More

£13 GBP in 2 days
(10 Reviews)
3.9
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

£15 GBP in 0 days
(18 Reviews)
4.1
prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA. I can make this vba macro for you. I have read all the instructions and found doable for me. I will complete this in one day. Please come on chat for more More

£20 GBP in 1 day
(34 Reviews)
4.1
dataexplorer

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m eff More

£18 GBP in 5 days
(14 Reviews)
3.4
Mokshith30

Hi i am vba develper...expertised in web scraping & vba macros i can do any vba automation tools i will finish this in a day thankyou

£18 GBP in 0 days
(8 Reviews)
2.7
RisksConsulting

Hi, My name is Héctor, I'm from chile but living in brazil. I need to get reputation in this site so I'm looking for new projects/customers. I'm sending a very low-price offer (I can deliver the job in 1 hour) More

£13 GBP in 1 day
(2 Reviews)
2.4
srijanagrawal21

I have read and understood your requirement. About me & what I can provide - • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • Macro coding for complex tasks possible. More

£15 GBP in 1 day
(2 Reviews)
1.4
GopalJp

Hi, I have gone through all your description and one [login to view URL] the same time,I knew your requirement. I am having good knowledge at excel process development using Macro,Formula and VBA module. Please consid More

£20 GBP in 1 day
(1 Review)
0.0
nascentit

Hi, I've done the Master degree in computer science, as a Certified SEO / Digital Marketing Specialist by ( Woorank, Google, SEM Institute) 7 + year of experienced, I'm excited to post my proposal for the Post of " More

£13 GBP in 1 day
(0 Reviews)
0.0