Write a macro

进行中 已发布的 5 年前 货到付款
进行中 货到付款

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.

数据处理 Excel Visual Basic

项目ID: #18041720

关于项目

27个方案 远程项目 活跃的5 年前

有27名威客正在参与此工作的竞标,均价£22/小时

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 更多

£39GBP 在1天里
(300条评论)
7.7
zebracaro

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

£21GBP 在1天里
(128条评论)
7.1
TonmoyRoy111

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

£40GBP 在1天里
(395条评论)
7.0
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 更多

£20GBP 在1天里
(109条评论)
6.3
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.

£20GBP 在1天里
(98条评论)
6.1
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 更多

£18GBP 在1天里
(50条评论)
6.2
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 在0天内
(83条评论)
5.8
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 更多

£100 GBP 在3天内
(70条评论)
5.7
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 更多

£18 GBP 在5天内
(20条评论)
4.7
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 在0天内
(38条评论)
4.5
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 更多

£20GBP 在1天里
(48条评论)
4.6
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. 更多

£15GBP 在1天里
(29条评论)
4.0
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 更多

£13 GBP 在2天内
(11条评论)
3.9
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) 更多

£13GBP 在1天里
(2条评论)
2.0
ekoomitsolution

Hi, We would like to Design and Build your online store / personal website / simple website / Management CRM application, We would like to provide you Website Design and then you select it and then if changes need we c 更多

£18GBP 在1天里
(1条评论)
1.7
San58

NO SATISFACTION NO PAYMENT Hello Sir, I can complete your job at the lowest cost . I am ready to start right now. The quality you will get is priceless! Do not hesitate to ask If you want, I can start immediatel 更多

£10GBP 在1天里
(3条评论)
0.7
webscraper24

"Hello, As per my assuming you need a data entry expert.I have carefully gone through with your requirements and I would like to help you with this job. I have about five years experience in the field of Data entry, D 更多

£20GBP 在1天里
(2条评论)
0.0
prashantdalwadi

I can able to do this task more perfectly.

£18GBP 在1天里
(0条评论)
0.0
ThinThinEi

I am a fast learner and also learning new technology. Currently, working as a system admin so familiar with most of the information technology, can apply effectively IT to improve in the business field. Moreover, inter 更多

£10 GBP 在5天内
(0条评论)
0.0
Kaminaj09

I have much experience regarding drafting and letters. Also done successfully projects and thesis in MBA.

£10GBP 在1天里
(0条评论)
0.0