Đang Thực Hiện

Excel formula templet , plus for sports data

Calculation issues:

1) getting a correct "Bruline from my data in COL K and L to be correct in COL O. in COL O I want the Calculation to be proper row, depending on which team has the higher #. Look at cells in rows 5 thru 8 and Col K,L, N. Remember the teams values are along the rows.

Col A the team and the bet line. This number is acutally a negative for the team that it is posted under. So the 1st team set (Georgetown(A1) at Syracuse(A3) line is Syracuse - 7.5.

In Col A cell a5 (Northern Illinois) is -1. I post them as positive due to manual input. (maybe run a format to change to negative? )

COL P is the difference of COL A line and COL O "bruline" IF this number is greater than 5 I want to highlight it Green, unless is the favorite (has the game line in COL A under it, then dont hightlight. (conditional format fine).

General Info on what is already done: COL B thru COL I is from formula doesn't need adj. Col K is the Net of COL H and COL L is one half the net of COL I.

Sample "bruline" are calculated, but I am not using the right formulas is the numbers were to change, these are just check figures.

Finally if we get the above working, I want to compare the highlighted games to the results of game in COL M. So as example, Rows 21 - 24. Cleveland St vs Ohio. the game line is Ohio -12 the "bruline" is Ohio -6.5 the Diff in COL P is 5.42 so we would highlight Cells P21-P24. Than is COL Q do a comparision to the game result in COL M. Clev ST. 53 OHIO 71, or 18 point win by Ohio. So in Column R lets have a formula that returns "win" or in this case "loss". I want a cell at bottom of COL R that tells me how many wins vs losses. This case "0-1"

I am open to moving the data around except for team names and COL B thru I. (only to simplfy)

I prefer cell formulas over VBA macros. If you want to go VBA route, you will have to explain them to me and how to edit.

Kỹ năng: Xử lí dữ liệu, Excel, Toán học, Statistics

Xem thêm: nba stats excel spreadsheet, import yahoo fantasy football data to excel, download espn fantasy football data, nfl scores excel, importhtml function excel, yahoo fantasy football excel spreadsheet, football stats excel template, export espn fantasy stats to excel, data edit excel, excel data sports data, excel formula vlookup plus add, concatenate data excel formula, sports data excel, sports data download excel, download sports data excel format

Về Bên Thuê:
( 1 nhận xét ) Houston, United States

Mã Dự Án: #15577442

Đã trao cho:

nurnga1218

For ordinary formula, we don't need to use macro. But if we need custom formula, yes I'll make a macro VBA for for you. How to edit is by pressing Alt + F11. Relevant Skills and Experience And about code, I'll give a Thêm

$35 USD trong 1 ngày
(27 Đánh Giá)
4.2

9 freelancer đang chào giá trung bình $123 cho công việc này

TonmoyRoy111

Dear Client I can do this task. Kindly contact me for further details Roy

$150 USD trong 2 ngày
(210 Đánh Giá)
6.2
c4cuteconain

with excel can do anything you require Relevant Skills and Experience Data Processing, Excel, Mathematics, Statistics Proposed Milestones $45 USD - Data Processing, Excel, Mathematics, Statistics can discuss on chat

$45 USD trong 3 ngày
(17 Đánh Giá)
3.9
mikhailkozalski

I am good at this part. Relevant Skills and Experience Data Processing, Excel, Mathematics, Statistics Proposed Milestones $155 USD - discuss

$155 USD trong 3 ngày
(4 Đánh Giá)
2.8
jcrbahia

please see this example. only unzip. and press buttons. and you see [url removed, login to view] your needs onl work with VBA. Habilidades y experiencia relevante Thêm

$250 USD trong 1 ngày
(3 Đánh Giá)
2.7
ITfreelancerOK

I understand logic of sports data, analysis and formulas. Has experience in work like yours. Relevant Skills and Experience Expert in excel, statistics, sports data. Proposed Milestones $133 USD - when job is done

$133 USD trong 3 ngày
(1 Đánh Giá)
1.2
$77 USD trong 2 ngày
(1 Đánh Giá)
0.8
mtdevil369

hi i am Stat student ,i can perfectly do it,please give me this work ,i am very interest to do it Relevant Skills and Experience Data Processing, Excel, Mathematics, Statistics Proposed Milestones $111 USD - project

$111 USD trong 2 ngày
(0 Đánh Giá)
0.0
lakedude2013

A proposal has not yet been provided

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0