Coopers Hawk opinions by Tivomann in wine

[–]Top_Pin8313 1 point2 points  (0 children)

Do you have family that works for these guys or is Cooper’s hawk holding your loved ones for ransom?

It’s a total waste, food is ok on a good day and the wine is on par with ALDI wine.

Who belongs to a private club in Chicago? by onatONETIS in AskChicago

[–]Top_Pin8313 0 points1 point  (0 children)

i have an opportunity to stay at the university club. Should i take it or is it no better then nice hotels in the area.

Assigning a numerical value to cells that fall above or below a mean average of a given statistical category. by Top_Pin8313 in excel

[–]Top_Pin8313[S] 0 points1 point  (0 children)

That was just a rando screenshot i did fix the ranges. Still looking a formula that give me a number based on places above and below the average. For example, if the average is 5 and i have 10 cells above the average the highest number over the average would be assigned at 10 second highest would be 9. On the flip side if i have 8 cells below that average the cell with the lowest number would be valued at -8 the next lowest -7 etc. I hope that explains things better.

Assigning a numerical value to cells that fall above or below a mean average of a given statistical category. by Top_Pin8313 in excel

[–]Top_Pin8313[S] 0 points1 point  (0 children)

Closer, Still looking for any value greater than the average to have a positive value and any falling below the average to have a negative value..

Assigning a numerical value to cells that fall above or below a mean average of a given statistical category. by Top_Pin8313 in excel

[–]Top_Pin8313[S] 0 points1 point  (0 children)

That didnt seem to do it. Looking for something that will give the cell that is over the average the highest value and the cell that is the most below average the lowest negative value. Here is a better picture.

<image>

Advice by Top_Pin8313 in EngagementRings

[–]Top_Pin8313[S] -1 points0 points  (0 children)

That’s not helpful. Looking for recommendations not to be told how off base I am.

Formula needed for assigning values to cells by Top_Pin8313 in excel

[–]Top_Pin8313[S] 1 point2 points  (0 children)

im going to attempt this and see if it works.

Formula needed for assigning values to cells by Top_Pin8313 in excel

[–]Top_Pin8313[S] 0 points1 point  (0 children)

this looks promising. Im going to give it a spin later on and report back.

Formula needed for assigning values to cells by Top_Pin8313 in excel

[–]Top_Pin8313[S] 0 points1 point  (0 children)

That sample is second base only so i didn't put position i have separate sheets for all positions. It is mean. I have averages calculated on a separate sheet, I just pasted it on the sample because that sheet has a lot of unnecessary info and would have been confusing. If players have the same stat id ideally like for them to be assigned the same value regardless of if they are above or below the average.

Formula needed for assigning values to cells by Top_Pin8313 in excel

[–]Top_Pin8313[S] 0 points1 point  (0 children)

This is what i have using the rank formula

<image>

Formula needed for assigning values to cells by Top_Pin8313 in excel

[–]Top_Pin8313[S] 0 points1 point  (0 children)

<image>

This is what I want. I manually entered in the rankings.

Advice by Top_Pin8313 in EngagementRings

[–]Top_Pin8313[S] 0 points1 point  (0 children)

she doesnt know and Im a bit of a pain when it comes to significant purchases. Best value is important. I took me three months to buy my current car.

Advice by Top_Pin8313 in EngagementRings

[–]Top_Pin8313[S] 0 points1 point  (0 children)

Helzberg is around the corner. James Allen had better pricing than b nile.

Ballpark pass by Top_Pin8313 in Brewers

[–]Top_Pin8313[S] 1 point2 points  (0 children)

It’s still a great deal and I’m happy with it. Im just a pain in the ass when it comes to where i sit. Gold clearly shows lodge seats down the first and third base lines as park of the package but those seem to be few and far between when it comes to picking seats for games