Đã hoàn thành

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 nhiều hơn: 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, free data entry excel formula urdu, download sports data excel, excel formula capture data time day, check excel formula aspnet, microsoft excel formula sheet

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

ID dự án: #15577442

Được trao cho:


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á)

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


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)

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)

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)

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)

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)
$77 USD trong 2 ngày
(2 Nhận xét)

A proposal has not yet been provided

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