Trying to get a formula for W-L-OT Streak also last 10 games record

[hockeyfan1985]

To all those who have helped me in the past with the excel sheet I'm making, thank you. I just made a few tweaks to make my other tables work better so some of the stuff you showed me dose not work.

This is my standings sheet
[TABLE="width: 907"]
<colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="174" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6363;"> <col width="64" style="width: 48pt;" span="9"> <col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;"> <col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;"> <col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;"> <col width="32" style="width: 24pt; mso-width-source: userset; mso-width-alt: 1170;" span="2"> <col width="64" style="width: 48pt;" span="3"> <tbody>[TR]
[TD="class: xl65, width: 70, bgcolor: transparent"]RANK[/TD]
[TD="class: xl66, width: 174, bgcolor: #A6A6A6"]METROPONLITAN DIVISION[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]GP[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]W[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]L[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]OTL[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]ROW[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]GF[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]GA[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]GD[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]PTS[/TD]
[TD="class: xl73, width: 35, bgcolor: transparent"]W[/TD]
[TD="class: xl67, width: 26, bgcolor: transparent"]L[/TD]
[TD="class: xl67, width: 31, bgcolor: transparent"]OT[/TD]
[TD="class: xl73, width: 40, bgcolor: transparent"]W[/TD]
[TD="class: xl67, width: 32, bgcolor: transparent"]L[/TD]
[TD="class: xl67, width: 32, bgcolor: transparent"]OT[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]L10[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]STREAK[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]#N/A[/TD]
[TD="class: xl69, bgcolor: #EA0000"]Carolina Hurricanes[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl74, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]#N/A[/TD]
[TD="class: xl72, bgcolor: #002060"]Columbus Blue Jackets[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl70, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl74, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]



this is my schedule sheet for the entire season and league I have the correct formulas for pts being 2=for a win and 1=for a ot loss or s/o loss. Results being either a F,S/O, OT
[TABLE="width: 488"]
<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="150" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5485;"> <col width="43" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;"> <col width="150" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5485;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;"> <col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <col width="59" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2157;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <tbody>[TR]
[TD="class: xl81, width: 75"]DATE[/TD]
[TD="class: xl79, width: 150"]VISTOR[/TD]
[TD="class: xl79, width: 43"]VG[/TD]
[TD="class: xl79, width: 150"]HOME[/TD]
[TD="class: xl79, width: 40"]HG[/TD]
[TD="class: xl79, width: 78"]RESULT[/TD]
[TD="class: xl79, width: 59"]VPTS[/TD]
[TD="class: xl80, width: 55"]HPTS[/TD]
[/TR]
[TR]
[TD="class: xl78"]10/4/2017[/TD]
[TD="class: xl75, bgcolor: #EA0000"]Calgary Flames[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl76, bgcolor: #FF9900"]Edmonton Oilers[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"]10/4/2017[/TD]
[TD="class: xl66, bgcolor: #FF9900"]Philadelphia Flyers[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: #43AD91"]San Jose Sharks[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl78"]10/4/2017[/TD]
[TD="class: xl71, bgcolor: #002060"]St. Louis Blues[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67, bgcolor: black"]Pittsburgh Penguins[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"]10/4/2017[/TD]
[TD="class: xl68, bgcolor: #002060"]Toronto Maple Leafs[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: #002060"]Winnipeg Jets[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl78"]10/5/2017[/TD]
[TD="class: xl74, bgcolor: #C00000"]Arizona Coyotes[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl73, bgcolor: black"]Anaheim Ducks[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"]10/5/2017[/TD]
[TD="class: xl69, bgcolor: #C00000"]Colorado Avalanche[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: #305496"]New York Rangers[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl78"]10/5/2017[/TD]
[TD="class: xl70, bgcolor: #C00000"]Minnesota Wild[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl63, bgcolor: #EA0000"]Detroit Red Wings[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[hockeyfan1985]

I seen people all over the internet through different forms. Looking for the same thing. How has no one found a formula for this yet. Without making it rocket science.