# 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

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

ID dự án: #15577442

## Được 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
(31 Đánh Giá)
4.4

## 8 freelancer đang chào giá trung bình \$133 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
(233 Nhận xét)
6.3
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
(7 Nhận xét)
3.5
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
(9 Nhận xét)
3.0
jcrbahia

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

\$250 USD trong 1 ngày
(3 Nhận xét)
1.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ận xét)
1.3
\$77 USD trong 2 ngày
(2 Nhận xét)
1.5
lakedude2013

A proposal has not yet been provided

\$155 USD trong 3 ngày
(0 Nhận xét)
0.0