Farm Finance

Filter Tips
PriorityTypeDescription
1| or  OR Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2 &&  or  AND Logical "and". Filter the column for content that matches text from either side of the operator.
3/\d/Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4< <= >= >Find alphabetical or numerical values less than or greater than or equal to the filtered query
5! or !=Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6" or =To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7 -  or  to Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8?Wildcard for a single, non-space character.
8*Wildcard for zero or more non-space characters.
9~Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10textAny text entered in the filter will match text found within the column
# Team Players Total Salaries Special Salary Cap Value Players In Salary Cap
1Abbotsford Canucks (VAN)28,207,768$0$0
2Bakersfield Condors (EDM)33,963,000$0$0
3Belleville Senators (OTT)31,477,500$0$0
4Bridgeport Islanders (NYI)22,872,066$0$0
5Calgary Wranglers (CGY)28,460,134$0$0
6Charlotte Checkers (FLA)30,040,000$0$0
7Chicago Wolves (CAR)30,288,332$0$0
8Cleveland Monsters (CBJ)22,767,334$0$0
9Coachella Valley Firebirds (SEA)32,037,932$0$0
10Colorado Eagles (COL)32,225,068$0$0
11Grand Rapids Griffins (DET)30,346,684$0$0
12Hartford Wolf Pack (NYR)26,360,552$0$0
13Henderson Silver Knights (VGK)31,788,200$0$0
14Hershey Bears (WSH)30,361,668$0$0
15Iowa Wild (MIN)23,291,668$0$0
16Laval Rocket (MTL)20,724,168$0$0
17Lehigh Valley Phantoms (PHI)21,245,000$0$0
18Manitoba Moose (WPG)29,494,168$0$0
19Milwaukee Admirals (NSH)31,481,736$0$0
20Ontario Reign (LAK)29,663,668$0$0
21Providence Bruins (BOS)30,960,000$0$0
22Rochester Americans (BUF)27,784,640$0$0
23Rockford IceHogs (CHI)27,403,888$0$0
24San Diego Gulls (ANA)30,706,664$0$0
25San Jose Barracuda (SJS)32,170,554$0$0
26Springfield Thunderbirds (STL)24,137,932$0$0
27Syracuse Crunch (TBL)26,049,168$0$0
28Texas Stars (DAL)28,300,000$0$0
29Toronto Marlies (TOR)32,382,496$0$0
30Tucson Roadrunners (UTA)23,825,000$0$0
31Utica Comets (NJD)31,976,664$0$0
32Wilkes-Barre/Scranton Penguins (PIT)25,172,332$0$0