KYPSW 2021-22

[RoarLions1]

ARMY

125 Shunk DEC, Meredith MD
133 Bravo-Young MD
141 N. Lee MD
149 Bartlett DEC
157 Army DEC
165 PSU DEC
174 Starocci MD
184 Brooks MD
197 Dean MD or Beard DEC
285 Kerkvliet MD

 

[RoarLions1]

125 Any PSU Dec
133 RBY TF
141 Lee TF
149 Bartlett Dec
157 Barraclough Dec
165 Edsell Dec MD
174 Starocci MD
184 Brooks MD
197 Any PSU MD
285 Kerkvliet Fall

You may want to look at your 157 pick. If Lee goes, you're possibly up-the-crick.

 

[CholleyVandine]

Army

125 - Shunk Dec, Meredith Maj
133 – Bravo-Young TF
141 – NLee TF or Army MD
149 – Bartlett Dec
157 – Barraclough Dec, JLee Dec, Army Dec any other PSU
165 – Edsell Dec
174 – Starocci Fall
184 – Brooks Fall
197 – Dean Maj, Beard Dec
285 – Kerkvliet Fall

 

[NoVa Lion]

Army

125 PSU DEC
133 Bravo Young MD
141 Lee FALL
149 Bartlett DEC
157 PSU Dec
165 PSU DEC
174 Starocci MDl
184 Brooks MD
197 Dean MD or Beard DEC
285 Kerkvliet MD

 

[philflyboy]

ARMY

125 Shunk Md. any other PSU dec
133 PSU TF
141 PSU fall
149 PSU dec
157 Barraclough Dec. Lee dec. any other dec
165 PSU dec
174 PSU fall
184 PSU fall
197 PSU TF
285 PSU fall

 

[sneedram55]

ARMY

125 PSU DEC
133 Bravo-Young MD
141 N. Lee TF
149 Bartlett DEC
157 Barraclough or Lee Dec. Army DEC any other
165 PSU DEC
174 Starocci MD
184 Brooks MD
197 Dean MD or Beard MD
285 Kerkvliet MD

 

[HOCKEYGOD11]

No Nick Lee

 

[slushhead]

i’m

No Nick Lee

Army threw a wrench at us at 133, too. I think the guy they are sending out is a lot better than Montgomery. Could mess w/ our bonus picks.

Nevermind that last part — not who I was thinking of, lol.

 

[PD4thespawn]

Psu-army
125- any psu dec
133- any psu tech fall
141- lee- tech fall any other, major decision
149- any psu major decision
157- any psu tech fall
165- any psu tech fall
174- psu fall
184- psu fall
197- psu fall

285- psu fall

 

[slushhead]

Not sure why Army even bothered providing a lineup.

 

[pawrestlersintn]

Well, that was easy.

Neither team felt the need to take it easy on the KYPSW guy, so I've been up since the dual ended, trying to figure this out. Here's what I've got.

At 141, we sent Meredith, in place of Lee. Of course, Meredith wasn't on the Notes, so 141 goes out the window, despite us picking Lee unanimously.

At 165 Army sent Hunt, instead of Fielden. Slush picked Hunt, miraculously, so I'll give him 0.49 credit, which rounds down to no credit. And, I picked Harkins, because I paid no attention to Notes, and Wrestlestat had Harkins. So, nobody gets anything for 165.

Fielden bumped from 165 to 174, and we were unanimous on Starocci, so everybody gets 2 there. Same deal with 285, as Army sent Phillips, instead of Sullivan.

So, this dual was worth a maximum of 22. 30-3-3-1-1. Been working on that math for hours.

So, here are the results:

 

[98lberEating2Lunches]

If I correctly understand the proprietary algorithm, all should get 2 for 133, because RBY was a unanimous pick and Carone went for Army but wasn't on the match notes. So so there goes my sole possession of the #1 spot for this week's dual.

 

[pawrestlersintn]

If I correctly understand the proprietary algorithm, all should get 2 for 133, because RBY was a unanimous pick and Carone went for Army but wasn't on the match notes. So so there goes my sole possession of the #1 spot for this week's dual.

Oh, crap. I completely missed that.

Yep, you and Roar are now both at 19, sharing the podium.

 

[pawrestlersintn]

Oregon State - Corrected

 

[pawrestlersintn]

Army - Corrected

 

[johnstownsteel]

Army - Corrected

Look how dedicated our man tn is folks. 5:40 on a Saturday morning and he's working for us!

Just wanted ya to know Tn...we notice little things like that and appreciate you immensely.

 

[pawrestlersintn]

YTD After Army

 

[pawrestlersintn]

Look how dedicated our man tn is folks. 5:40 on a Saturday morning and he's working for us!

Just wanted ya to know Tn...we notice little things like that and appreciate you immensely.

Thanks, man. Dedicated or crazy, take your pick.

 

[pawrestlersintn]

Alright, Excel genii, I've got an assignment for you.

Below is a link to the spreadsheet. Well, a copy of it, anyway. You think I'm letting you animals get near the real thing, you got another think coming. <g>

Description of the Spreadsheet
Tabs across the bottom are for each individual match, B1G, NCAA and YTD

• Within each match tab, there is a data entry area (light green), followed by an initial tabulation area (pinkish), then a ranking area (yellow-goldish).
• In the YTD Tab there is an area for scoring from the match tabs (no color), followed by an unranked season totals section (light pink?), a section for "correcting" for tiebreakers (light blue), then a final section for finished YTD standings (no idea what that color is).

So, when you enter data in a match tab, everything cascades through the sheet, resulting in ranked match results and ranked YTD results.

I consider some of the stuff to be elegant, some of it to be brute force, and some of it to just be straightforward Excel. It has been an ongoing project since I took over several years ago, with small improvements occurring over time.

The Project
The next step is to automate an area in YTD for YTD change from the last YTD to the current YTD, without too much copy/paste, if any. Up until now, anytime I do YTD change, it has been through way too much copy/paste, subtraction, re-ranking. Way too time consuming, which explains why you don't see it that often.

That's where I need help with ideas on how to accomplish it. My only idea right now is to make a new YTD area for every match, with a new YTD change calculation, within each of those new areas.

What I'm not looking for
I know there are likely areas of the spreadsheet that some of you will say, "Why did he do it this way? There are easier ways." However, the spreadsheet works, and I'm not interested in making changes, just so it will continue to work, but with a different, cleaner method, unless that method gets me to a point where I can make this project work.

So, have at it, and get back to me with any questions.

KYPSW 2021-22 Copy.xlsm

1drv.ms

 

[nittinsc]

Thanks, man. Dedicated or crazy, take your pick.

I think you need a little of both to excel the way you do.

 

[pawrestlersintn]

I think you need a little of both to excel the way you do.

Fair enough.

 

[RoarLions1]

Thanks, man. Dedicated or crazy, take your pick.

Crazicated .

 

[RoarLions1]

Alright, Excel genii, I've got an assignment for you.

Below is a link to the spreadsheet. Well, a copy of it, anyway. You think I'm letting you animals get near the real thing, you got another think coming. <g>

Description of the Spreadsheet
Tabs across the bottom are for each individual match, B1G, NCAA and YTD

• Within each match tab, there is a data entry area (light green), followed by an initial tabulation area (pinkish), then a ranking area (yellow-goldish).
• In the YTD Tab there is an area for scoring from the match tabs (no color), followed by an unranked season totals section (light pink?), a section for "correcting" for tiebreakers (light blue), then a final section for finished YTD standings (no idea what that color is).

So, when you enter data in a match tab, everything cascades through the sheet, resulting in ranked match results and ranked YTD results.

I consider some of the stuff to be elegant, some of it to be brute force, and some of it to just be straightforward Excel. It has been an ongoing project since I took over several years ago, with small improvements occurring over time.

The Project
The next step is to automate an area in YTD for YTD change from the last YTD to the current YTD, without too much copy/paste, if any. Up until now, anytime I do YTD change, it has been through way too much copy/paste, subtraction, re-ranking. Way too time consuming, which explains why you don't see it that often.

That's where I need help with ideas on how to accomplish it. My only idea right now is to make a new YTD area for every match, with a new YTD change calculation, within each of those new areas.

What I'm not looking for
I know there are likely areas of the spreadsheet that some of you will say, "Why did he do it this way? There are easier ways." However, the spreadsheet works, and I'm not interested in making changes, just so it will continue to work, but with a different, cleaner method, unless that method gets me to a point where I can make this project work.

So, have at it, and get back to me with any questions.

KYPSW 2021-22 Copy.xlsm

1drv.ms

Give me time. There's nothing (or very little) in Excel that can't be done when it comes to data that fits into a spreadsheet, basically two dimensional (rows and columns). Your project fits into the "almost three-dimensional" realm. This one may take a macro or two.

 

[NoVa Lion]

Thanks, man. Dedicated or crazy, take your pick.

Definitely both.

 

[HOCKEYGOD11]

#2 PENN STATE NITTANY LIONS (3-0, 0-0 B1G)
125 Baylor Shunk So. Centre Hall, Pa./Penns Valley 2-1
Brandon Meredith Jr. Limerick, Pa./Spring-Ford 0-1
133 #1 Roman Bravo-Young Sr. Tucson, Ariz./Sunnyside 3-0
141 #1 Nick Lee Sr.+ Evansville, Ind./Homeschooled 2-0
149 #20 Beau Bartlett So. Tempe, Ariz./Wyoming Seminary (Pa.) 3-0
157 Terrell Barraclough So. Kaysville, Utah/Layton 0-1
Joe Lee So. Evansville, Ind./Mater Dei 0-0
165 #32 Creighton Edsell Jr. Wyalusing, Pa./Wyalusing 3-0
174 #1 Carter Starocci So. Erie, Pa./Cathedral Prep 3-0
184 #1 Aaron Brooks Jr. Hagerstown, Md./North Hagerstown 3-0
197 #4 Max Dean Jr. Lowell, Mich./Lowell 3-0
Michael Beard So. Pottstown, Pa./Malvern Prep 3-0
285 #4 Greg Kerkvliet So. Inver Grove Heights, Minn./Simley 3-0

PENN QUAKERS (0-0)
125 Ryan Miller Fr. Stroudsburg, Pa./Blair Academy 5-2
Blair Orr Sr. Aston, Pa./Episcopal Academy 2-3
133 #12 Michael Colaiocco So. Sparta, N.J./Blair Academy 7-0
141 #28 Carmen Ferrante Jr. Newtown, N.J./Bergen Catholic 5-2
C.J. Composto So. Westfield, N.J./Westfield 2-3
149 #23 Anthony Artalona Jr. Seffner, Fla./Tampa Prep 0-0
Kaya Sement Fr. Chester, N.J./Pope John XXIII 6-3
157 Doug Zapf Jr. Downingtown, Pa./Downingtown West 6-1
165 #33 Lucas Revano So. Belmar, N.J./Camden Catholic 6-2
174 #21 Nick Incontrera Fr. Flemington, N.J./Blair Academy 6-1
184 Neil Antrassian Sr. Temperance, Mich./Temperance Bedford 4-3
Maximus Hale So. West Chester, Pa./Downingtown West 3-3
197 Cole Urbas So. Port Matilda, Pa./State College 3-3
285 Ben Goldin Jr. Orlando, Fla./Lake Highland Prep 6-1

LEHIGH MOUNTAIN HAWKS (2-1*)
125 #14 Jaret Lane Jr. Catawissa, Pa./Southern Columbia 5-0
133 #22 Malyke Hines Fr. Kissimmee, Fla./Osceola 4-2
141 Dan Moran Jr. Bethlehem, Pa./Northampton 1-4
Connor McGonagle Fr. Danville, N.H./Timberlane 0-0
149 Manzona Bryant IV Fr. Columbus, Ohio/Western Reserve 2-3
Jimmy Hoffman Jr. Drums, Pa./Hazleton 0-3
157 #10 Josh Humphreys Jr. Parkersburg, W. Va./Parkersburg South 3-1
165 #27 Brian Meyer So. Phillipsburg, N.J./Phillipsburg 5-1
174 Jake Logan Fr. New Rochelle, N.Y./New Rochelle 3-3
184 A.J. Burkhart So. Athens, Pa./Athens 2-4
197 J.T. Davis Fr. Middletown, Del./Smyrna 2-4
285 #10 Jordan Wood Sr. Gilbertsville, Pa./Boyertown 5-0

 

[alton11]

Penn

125 – PSU DEC
133 – Bravo Young DEC Colaiocco
141 – Lee FALL
149 – Bartlett DEC
157 – PSU DEC
165 – Edsell DEC
174 – Starocci MD
184 – Brooks TF
197 – PSU FALL
285 – Kerkvliet FALL

 

[alton11]

Penn

125 – PSU DEC
133 – Bravo Young DEC Colaiocco
141 – Lee TF
149 – Bartlett DEC
157 – PSU DEC
165 – Edsell DEC
174 – Starocci MD
184 – Brooks TF
197 – PSU FALL
285 – Kerkvliet TF

 

[alton11]

Lehigh

125 – Lane DEC
133 – Bravo Young MD
141 – Lee TF
149 – Bartlett MD
157 – Humphries DEC
165 – Edsell DEC
174 – Starocci TF
184 – Brooks FALL
197 – PSU FALL
285 – Kerkvliet MD

 

[98lberEating2Lunches]

Vs Penn

125 Shunk MAJ Miller or TF Orr; Merideth DEC Miller or MAJ Orr
133 RBY MAJ
141 NLee TF Ferrante or FALL Composto
149 Bartlett DEC
157 Barraclough MAJ or JLee FALL
165 Edsell DEC
174 Starocci TF
184 Brooks TF
197 Beard FALL or Dean TF
285 Kerkvliet TF

 

[98lberEating2Lunches]

Vs Lehigh

125 Lane MAJ Shunk or DEC Merideth
133 RBY MAJ
141 NLee FALL
149 Bartlett MAJ
157 Humphreys MAJ
165 Meyer DEC
174 Starocci FALL
184 Brooks FALL
197 Beard FALL or Dean TF
285 Kerkvliet MAJ

 

[slushhead]

Penn

125 - PSU DEC Miller, or PSU MD Orr
133 - PSU DEC Penn
141 - PSU FALL Penn
149 - PSU DEC Artolona, or PSU MD Sement
157- PSU DEC Penn
165 - Penn DEC PSU
174 - PSU MD Penn
184 - PSU FALL Penn
197 - PSU FALL Penn
285 - PSU MD Penn

 

[HOCKEYGOD11]

• #107

Penn

125 – PSU DEC
133 – Bravo Young DEC
141 – Lee MD Ferrante or Lee TF Composto
149 – Bartlett DEC
157 – PSU DEC
165 – Edsell DEC
174 – Starocci MD
184 – Brooks TF
197 – PSU MD
285 – Kerkvliet MD

 

[PSUbluTX]

PSU vs Penn
125 – PSU DEC over Miller or MD over Orr
133 – Bravo Young DEC
141 – Lee MD over Ferrante or FALL over Composto
149 – Bartlett DEC over Artalona or MD over Sement
157 – PSU DEC over Zapf
165 – Edsell DEC over Revano
174 – Starocci MD over Incontrera
184 – Brooks FALL over any PENN
197 – Dean FALL over Urbas; Beard MD over Urbas
285 – Kerkvliet TF over Goldin

 

[Gray52]

Penn

125 – PSU DEC
133 – Bravo Young DEC
141 – Lee MD
149 – Bartlett DEC
157 – PSU DEC
165 – Edsell DEC
174 – Starocci TF
184 – Brooks TF
197 – Dean TF; Beard MD
285 – Kerkvliet TF

 

[Gray52]

Lehigh

125 Lehigh MAJ
133 RBY MAJ
141 NLee MAJ
149 Bartlett DEC
157 Humphreys DEC J.Lee, or MAJ any other PSU
165 Edsel DEC
174 Starocci MAJ
184 Brooks MAJ
197 Beard DEC or Dean MAJ
285 Kerkvliet MAJ

 

[impalanut]

Penn:
125 Miller dec
133 RBY TF
141 Lee win over Ferrante TF Composto fall
149 Artalona dec
157 Zapf dec
165 Revano dec
174 Starocci TF
184 Brooks fall
197 Dean TF Beard MD
285Kerk TF


Lehigh:
125 Lane MD
133 RBY TF
141 Lee fall
149 Bartlett win over Bryant MD HOffman fall
157 Humphries dec
165 Meyer dec
174 Starocci TF
184 Brooks fall
197 Dean TF Beard MD
285 Kerk MD

 

[BigFella235]

Penn:

125- Shunk Dec
133- RBY MD
141- N. Lee MD, any other PSU dec
149- Bartlett Dec Artalona, MD Sement
157- Zapf Dec
165- Edsell Dec
174- Starocci TF
184- Brooks TF Antraissin, Fall Hale
197- Dean TF, Beard MD
285- Kerk MD

Lehigh:

125- Lane MD
133- RBY TF
141- N. Lee Fall, any other PSU Dec
149- Bartlett Dec Bryant, MD Hoffman
157- Humphries MD
165- Edsell Dec
174- Starocci TF
184- Brooks Fall
197- Dean Fall, Beard MD
285- Kerk Dec

 

[RoarLions1]

PSU Vs Penn

125: Shunk Dec Miller or MD Orr; Merideth MD any
133: RBY Dec
141: NLee MD Ferrante or FALL Composto
149: Bartlett DEC
157: Zapf Dec any PSU
165: Edsell DEC
174: Starocci MD
184: Brooks TF
197: Beard MD or Dean TF
285: Kerkvliet MD

This dual is likely to contain names not listed above, more fun for pawrestler ...

 

[tomsc]

PENN:

125: Meredith Dec Mlller MD Orr; Miller Dec Shunk; Shunk Dec Orr
133: Bravo-Young Dec
141: Lee TF Ferrante Fall Composto
149: Bartlett Dec Artalona MD Sement
157: Zapf Dec
165: Edsell Dec
174: Starocci MD
184: Brooks TF
197: Dean TF Beard MD
285: Kerkvliet TF

 

[johnstownsteel]

PENN

125: Meredith Dec Mlller or MD Orr; Miller Dec Shunk or Shunk Dec Orr
133: Bravo-Young Dec
141: Lee MD Farrente or Fall Composoto
149: Bartlett Dec Artalona or MD Sement
157: Zapf Dec Barraclough or Lee Dec Zapf
165: Edsell Dec
174: Starocci MD
184: Brooks TF
197: Dean MD or Beard MD
285: Kerkvliet TF