Write a macro
£10-20 GBP
货到付款
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.
项目ID: #18041720
关于项目
有27名威客正在参与此工作的竞标,均价£22/小时
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 更多
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
Dear client I understand the requirements you mentioned. I can do it for you. Please contact me. Roy
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.
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 更多
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
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 更多
"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 更多
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
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 更多
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. 更多
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) 更多
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 更多
"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 更多
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 更多
I have much experience regarding drafting and letters. Also done successfully projects and thesis in MBA.