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

RANK	METROPONLITAN DIVISION	GP	W	L	OTL	ROW	GF	GA	GD	PTS	W	L	OT	W	L	OT	L10	STREAK
#N/A	Carolina Hurricanes	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0			0
#N/A	Columbus Blue Jackets	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0			0

<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> </tbody>

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

DATE	VISTOR	VG	HOME	HG	RESULT	VPTS	HPTS
10/4/2017	Calgary Flames		Edmonton Oilers
10/4/2017	Philadelphia Flyers		San Jose Sharks
10/4/2017	St. Louis Blues		Pittsburgh Penguins
10/4/2017	Toronto Maple Leafs		Winnipeg Jets
10/5/2017	Arizona Coyotes		Anaheim Ducks
10/5/2017	Colorado Avalanche		New York Rangers
10/5/2017	Minnesota Wild		Detroit Red Wings

<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> </tbody>

 

[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.