| Priority | Type | Description |
|---|---|---|
| 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 |
| 10 | text | Any text entered in the filter will match text found within the column |
| Capacity | Ticket Price | Attendance | Attendance PCT | Income | Expenses | Estimate | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses |
| 1 | Aces (Veg) | 2000 | 1000 | 200 | 100 | 31601 | 14975 | 71.82% | 68.07% | 17 | 2117 - 70.57% | 497,490$ | 10,944,780$ | 3000 | 100 | 1,685,000$ | 1,685,000$ | 1,109,920$ | 9,520$ | 971,544$ | 0 | 0 | 8,457,330$ | 94 | 10,932$ | 863,628$ |
| 2 |  Admirals (Nsh) | 2000 | 1000 | 200 | 100 | 31148 | 15441 | 70.79% | 70.19% | 17 | 2118 - 70.59% | 494,690$ | 10,883,180$ | 3000 | 100 | 2,070,000$ | 2,070,000$ | 1,284,486$ | 11,695$ | 1,146,110$ | 0 | 0 | 8,409,730$ | 94 | 13,107$ | 1,035,453$ |
| 3 | Americans (Buf) | 2000 | 1000 | 200 | 100 | 29579 | 14678 | 70.43% | 69.90% | 18 | 2107 - 70.25% | 492,240$ | 10,337,040$ | 3000 | 100 | 2,255,000$ | 2,255,000$ | 1,387,698$ | 12,740$ | 1,249,224$ | 0 | 0 | 8,860,320$ | 94 | 14,153$ | 1,118,087$ |
| 4 |  Barracuda (SJS) | 2000 | 1000 | 200 | 100 | 31500 | 15433 | 71.59% | 70.15% | 17 | 2133 - 71.11% | 499,119$ | 10,980,620$ | 3000 | 100 | 1,955,000$ | 1,955,000$ | 1,277,052$ | 11,045$ | 1,138,644$ | 0 | 0 | 8,485,025$ | 94 | 12,458$ | 984,182$ |
| 5 |  Bears (Wsh) | 2000 | 1000 | 200 | 100 | 30227 | 15251 | 68.70% | 69.32% | 17 | 2067 - 68.91% | 481,759$ | 10,598,700$ | 3000 | 100 | 2,360,000$ | 2,360,000$ | 1,113,488$ | 13,333$ | 975,105$ | 0 | 0 | 8,189,905$ | 94 | 14,746$ | 1,164,934$ |
| 6 |  Bruins (Bos) | 2000 | 1000 | 200 | 100 | 31644 | 15289 | 71.92% | 69.50% | 17 | 2133 - 71.11% | 500,035$ | 11,000,780$ | 3000 | 100 | 2,047,500$ | 2,047,500$ | 1,272,040$ | 11,568$ | 1,133,664$ | 0 | 0 | 8,500,603$ | 94 | 12,980$ | 1,025,420$ |
| 7 |  Crunch (TBL) | 2000 | 1000 | 175 | 88 | 36174 | 18599 | 82.21% | 84.54% | 17 | 2490 - 82.99% | 511,442$ | 11,251,714$ | 3000 | 100 | 2,080,000$ | 2,080,000$ | 1,297,303$ | 11,751$ | 1,158,839$ | 0 | 0 | 8,694,506$ | 94 | 13,164$ | 1,039,956$ |
| 8 |  Devils (NJD) | 2000 | 1000 | 199 | 99 | 30622 | 15277 | 69.60% | 69.44% | 17 | 2086 - 69.54% | 484,031$ | 10,648,681$ | 3000 | 100 | 1,625,000$ | 1,625,000$ | 1,034,498$ | 9,181$ | 896,122$ | 0 | 0 | 8,228,526$ | 94 | 10,593$ | 836,847$ |
| 9 | Falcons (Ari) | 2000 | 1000 | 200 | 100 | 30329 | 15560 | 68.93% | 70.73% | 17 | 2086 - 69.53% | 485,024$ | 10,670,520$ | 3000 | 100 | 2,166,352$ | 2,166,352$ | 1,420,844$ | 12,239$ | 1,282,370$ | 0 | 0 | 8,245,402$ | 94 | 13,652$ | 1,078,508$ |
| 10 | Firebirds (Sea) | 2000 | 1000 | 50 | 18 | 43999 | 22000 | 100.00% | 100.00% | 17 | 3000 - 100.00% | 140,761$ | 3,096,747$ | 3000 | 100 | 3,907,500$ | 3,907,500$ | 1,965,034$ | 22,076$ | 1,826,656$ | 0 | 0 | 2,392,941$ | 94 | 23,489$ | 1,855,631$ |
| 11 |  Griffins (Det) | 2000 | 1000 | 60 | 30 | 43988 | 22000 | 99.97% | 100.00% | 17 | 2999 - 99.98% | 197,736$ | 4,350,192$ | 3000 | 100 | 1,970,000$ | 1,970,000$ | 1,170,385$ | 11,130$ | 1,032,008$ | 0 | 0 | 3,361,512$ | 94 | 12,542$ | 990,818$ |
| 12 |  Gulls (Anh) | 2000 | 1000 | 200 | 100 | 31603 | 15222 | 71.83% | 69.19% | 17 | 2128 - 70.95% | 499,087$ | 10,979,920$ | 3000 | 100 | 2,295,000$ | 2,295,000$ | 1,351,811$ | 12,966$ | 1,213,337$ | 0 | 0 | 8,484,484$ | 94 | 14,379$ | 1,135,941$ |
| 13 | Heat (Cal) | 2000 | 1000 | 125 | 59 | 43278 | 21529 | 98.36% | 97.86% | 17 | 2946 - 98.19% | 425,088$ | 9,351,945$ | 3000 | 100 | 2,000,500$ | 2,738,500$ | 1,225,060$ | 11,302$ | 1,086,657$ | 0 | 0 | 7,226,503$ | 94 | 12,715$ | 1,004,485$ |
| 14 |  Ice Hogs (Chi) | 2000 | 1000 | 200 | 100 | 31166 | 15312 | 70.83% | 69.60% | 17 | 2113 - 70.42% | 494,098$ | 10,870,160$ | 3000 | 100 | 2,745,000$ | 2,745,000$ | 1,236,634$ | 15,508$ | 1,098,245$ | 0 | 0 | 8,399,669$ | 94 | 16,921$ | 1,336,759$ |
| 15 |  Marlies (Tor) | 2000 | 1000 | 200 | 100 | 30912 | 15416 | 70.25% | 70.07% | 17 | 2106 - 70.19% | 491,527$ | 10,813,600$ | 3000 | 100 | 2,310,500$ | 2,310,500$ | 1,448,748$ | 13,054$ | 1,310,358$ | 0 | 0 | 8,355,964$ | 94 | 14,466$ | 1,142,814$ |
| 16 |  Monsters (Clb) | 2000 | 1000 | 200 | 100 | 30539 | 15572 | 69.41% | 70.78% | 17 | 2096 - 69.87% | 487,773$ | 10,731,000$ | 3000 | 100 | 1,987,500$ | 1,987,500$ | 1,241,503$ | 11,229$ | 1,103,127$ | 0 | 0 | 8,292,136$ | 94 | 12,641$ | 998,639$ |
| 17 |  Moose (Fla) | 2000 | 1000 | 150 | 75 | 42672 | 21186 | 96.98% | 96.30% | 17 | 2903 - 96.75% | 508,439$ | 11,185,650$ | 3000 | 100 | 4,535,000$ | 4,535,000$ | 1,831,019$ | 25,621$ | 1,692,586$ | 0 | 0 | 8,643,457$ | 94 | 27,034$ | 2,135,686$ |
| 18 | Oil Kings (Edm) | 2000 | 1000 | 200 | 100 | 29486 | 14565 | 70.20% | 69.36% | 18 | 2098 - 69.92% | 490,247$ | 10,295,180$ | 3000 | 100 | 2,252,500$ | 2,252,500$ | 1,359,082$ | 12,726$ | 1,220,706$ | 0 | 0 | 8,824,440$ | 94 | 14,138$ | 1,116,902$ |
| 19 |  Penguins (Pit) | 2000 | 1000 | 200 | 100 | 31125 | 15109 | 70.74% | 68.68% | 17 | 2102 - 70.05% | 492,285$ | 10,830,260$ | 3000 | 100 | 2,205,000$ | 2,205,000$ | 1,334,244$ | 12,458$ | 1,195,868$ | 0 | 0 | 8,368,837$ | 94 | 13,870$ | 1,095,730$ |
| 20 |  Phantoms (Phi) | 2000 | 1000 | 200 | 100 | 29119 | 14407 | 69.33% | 68.60% | 18 | 2073 - 69.09% | 484,300$ | 10,170,300$ | 3000 | 100 | 1,640,000$ | 1,640,000$ | 1,046,444$ | 9,266$ | 908,068$ | 0 | 0 | 8,717,400$ | 94 | 10,678$ | 843,562$ |
| 21 |  Rampage (Col) | 2000 | 1000 | 150 | 60 | 42875 | 21520 | 97.44% | 97.82% | 17 | 2927 - 97.57% | 491,429$ | 10,811,430$ | 3000 | 100 | 1,825,000$ | 1,825,000$ | 1,148,854$ | 10,311$ | 1,010,478$ | 0 | 0 | 8,354,287$ | 94 | 11,723$ | 926,117$ |
| 22 |  Reign (LA ) | 2000 | 1000 | 200 | 100 | 29366 | 14214 | 69.92% | 67.69% | 18 | 2075 - 69.17% | 486,307$ | 10,212,440$ | 3000 | 100 | 2,250,000$ | 2,250,000$ | 1,384,152$ | 12,712$ | 1,245,776$ | 0 | 0 | 8,753,520$ | 94 | 14,124$ | 1,115,796$ |
| 23 |  Rocket (Mon) | 2000 | 1000 | 200 | 100 | 30638 | 15129 | 69.63% | 68.77% | 17 | 2080 - 69.34% | 486,214$ | 10,696,700$ | 3000 | 100 | 2,345,000$ | 2,345,000$ | 1,436,778$ | 13,249$ | 1,298,402$ | 0 | 0 | 8,265,632$ | 94 | 14,661$ | 1,158,219$ |
| 24 |  Senators (Ott) | 2000 | 1000 | 200 | 100 | 31077 | 15140 | 70.63% | 68.82% | 17 | 2101 - 70.03% | 491,871$ | 10,821,160$ | 3000 | 100 | 2,335,000$ | 2,335,000$ | 1,625,061$ | 13,192$ | 1,486,610$ | 0 | 0 | 8,361,805$ | 94 | 14,605$ | 1,153,795$ |
| 25 |  Sound Tigers (NYI) | 2000 | 1000 | 200 | 100 | 31138 | 15458 | 70.77% | 70.26% | 17 | 2118 - 70.60% | 494,671$ | 10,882,760$ | 3000 | 100 | 2,000,000$ | 2,100,000$ | 1,344,762$ | 11,299$ | 1,206,291$ | 0 | 0 | 8,409,405$ | 94 | 12,712$ | 1,004,248$ |
| 26 |  Stars (Dal) | 2000 | 1000 | 200 | 100 | 30963 | 15417 | 70.37% | 70.08% | 17 | 2108 - 70.27% | 492,183$ | 10,828,020$ | 3000 | 100 | 2,050,000$ | 2,050,000$ | 1,278,832$ | 11,582$ | 1,140,384$ | 0 | 0 | 8,367,106$ | 94 | 12,994$ | 1,026,526$ |
| 27 | Swamp Rabbits (Car) | 2000 | 1000 | 200 | 100 | 29517 | 14694 | 70.28% | 69.97% | 18 | 2105 - 70.18% | 491,520$ | 10,321,920$ | 3000 | 100 | 1,876,500$ | 1,876,500$ | 1,125,552$ | 10,602$ | 987,082$ | 0 | 0 | 8,847,360$ | 94 | 12,014$ | 949,106$ |
| 28 | Thunderbirds (STL) | 2000 | 1000 | 35 | 15 | 44000 | 22000 | 100.00% | 100.00% | 17 | 3000 - 100.00% | 119,000$ | 2,618,000$ | 3000 | 100 | 2,310,000$ | 2,310,000$ | 1,417,374$ | 13,051$ | 1,278,998$ | 0 | 0 | 2,023,000$ | 94 | 14,463$ | 1,142,577$ |
| 29 | Wheat Kings (Jet) | 2000 | 1000 | 175 | 88 | 39961 | 19141 | 90.82% | 87.00% | 17 | 2686 - 89.55% | 560,646$ | 12,334,206$ | 3000 | 100 | 2,285,000$ | 2,285,000$ | 1,400,871$ | 12,910$ | 1,262,495$ | 0 | 0 | 9,530,977$ | 94 | 14,322$ | 1,131,438$ |
| 30 |  Wild (Min) | 2000 | 1000 | 200 | 100 | 30470 | 15076 | 69.25% | 68.53% | 17 | 2070 - 69.01% | 483,738$ | 10,642,240$ | 3000 | 100 | 1,660,000$ | 1,660,000$ | 1,057,322$ | 9,379$ | 918,939$ | 0 | 0 | 8,223,549$ | 94 | 10,791$ | 852,489$ |
| 31 | Wolfpack (NYR) | 2000 | 1000 | 200 | 100 | 30729 | 15135 | 69.84% | 68.80% | 17 | 2085 - 69.49% | 487,410$ | 10,723,020$ | 3000 | 100 | 2,070,000$ | 2,070,000$ | 1,451,168$ | 11,695$ | 1,312,719$ | 0 | 0 | 8,285,970$ | 94 | 13,107$ | 1,035,453$ |
| 32 |  Wolves (Van) | 2000 | 1000 | 200 | 100 | 33908 | 16753 | 77.06% | 76.15% | 17 | 2303 - 76.76% | 482,411$ | 10,613,047$ | 3000 | 100 | 2,270,000$ | 2,270,000$ | 1,444,802$ | 12,825$ | 1,306,426$ | 0 | 0 | 8,200,991$ | 94 | 14,237$ | 1,124,723$ |
