| 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 Average Salaries | 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 |  Admirals (Nas) | 2000 | 1000 | 70 | 40 | 20730 | 10293 | 94.23% | 93.57% | 29 | 2820 - 94.01% | 177,815$ | 1,955,961$ | 3000 | 100 | 2,287,000$ | 2,283,500$ | 857,335$ | 11,378$ | 624,754$ | 0 | 0 | 5,156,624$ | 143 | 15,607$ | 2,278,622$ |
| 2 |  Americans (Buf) | 2000 | 1000 | 70 | 40 | 20205 | 10276 | 91.84% | 93.42% | 29 | 2771 - 92.37% | 174,242$ | 1,916,659$ | 3000 | 100 | 1,829,000$ | 1,799,000$ | 686,828$ | 9,100$ | 481,602$ | 0 | 0 | 5,053,010$ | 143 | 12,831$ | 1,873,326$ |
| 3 |  Barracuda (S.J) | 2000 | 1000 | 70 | 40 | 19673 | 10027 | 89.42% | 91.15% | 29 | 2700 - 90.00% | 169,736$ | 1,867,098$ | 3000 | 100 | 2,004,500$ | 2,004,500$ | 719,981$ | 9,973$ | 534,839$ | 0 | 0 | 4,922,349$ | 143 | 13,206$ | 1,928,076$ |
| 4 |  Bears (Was) | 2000 | 1000 | 70 | 40 | 20557 | 10532 | 93.44% | 95.75% | 29 | 2826 - 94.21% | 177,571$ | 1,953,283$ | 3000 | 100 | 2,052,500$ | 1,912,500$ | 713,795$ | 10,211$ | 563,291$ | 0 | 0 | 5,149,564$ | 143 | 12,948$ | 1,890,408$ |
| 5 |  Comets (Van) | 2000 | 1000 | 70 | 40 | 20535 | 10369 | 93.34% | 94.26% | 29 | 2809 - 93.65% | 176,802$ | 1,944,820$ | 3000 | 100 | 2,274,500$ | 2,177,500$ | 729,968$ | 11,316$ | 641,033$ | 0 | 0 | 5,127,253$ | 143 | 12,933$ | 1,888,218$ |
| 6 |  Condors (Edm) | 2000 | 1000 | 70 | 40 | 20617 | 10411 | 93.71% | 94.65% | 29 | 2821 - 94.02% | 177,510$ | 1,952,612$ | 3000 | 100 | 2,237,500$ | 2,147,500$ | 758,255$ | 11,132$ | 614,153$ | 0 | 0 | 5,147,795$ | 143 | 13,619$ | 1,988,374$ |
| 7 |  Crunch (T.B) | 2000 | 1000 | 70 | 40 | 20350 | 10328 | 92.50% | 93.89% | 29 | 2789 - 92.96% | 175,409$ | 1,929,501$ | 3000 | 100 | 1,560,000$ | 1,475,000$ | 552,864$ | 7,512$ | 405,338$ | 0 | 0 | 5,086,866$ | 143 | 10,249$ | 1,496,354$ |
| 8 |  Devils (N.J) | 2000 | 1000 | 70 | 40 | 20381 | 10370 | 92.64% | 94.27% | 29 | 2796 - 93.18% | 175,777$ | 1,933,543$ | 3000 | 100 | 1,672,500$ | 1,632,500$ | 601,310$ | 8,321$ | 426,305$ | 0 | 0 | 5,097,522$ | 143 | 11,306$ | 1,650,676$ |
| 9 |  Eagles (Col) | 2000 | 1000 | 70 | 40 | 22474 | 10924 | 93.64% | 91.03% | 28 | 2783 - 92.77% | 175,888$ | 2,110,650$ | 3000 | 100 | 2,015,000$ | 1,809,000$ | 727,264$ | 10,025$ | 545,284$ | 0 | 0 | 4,924,850$ | 143 | 13,259$ | 1,935,814$ |
| 10 |  Griffins (Det) | 2000 | 1000 | 70 | 40 | 20499 | 10136 | 93.18% | 92.15% | 29 | 2785 - 92.83% | 175,672$ | 1,932,389$ | 3000 | 100 | 2,235,000$ | 2,067,500$ | 848,907$ | 11,119$ | 616,315$ | 0 | 0 | 5,094,480$ | 143 | 15,348$ | 2,240,808$ |
| 11 |  Heat (Cal) | 2000 | 1000 | 70 | 40 | 20215 | 10461 | 91.89% | 95.10% | 29 | 2789 - 92.96% | 175,015$ | 1,925,164$ | 3000 | 100 | 2,247,000$ | 2,074,500$ | 832,713$ | 11,179$ | 613,813$ | 0 | 0 | 5,075,432$ | 143 | 15,159$ | 2,213,214$ |
| 12 |  Icehogs (Chi) | 2000 | 1000 | 70 | 40 | 20448 | 10111 | 92.95% | 91.92% | 29 | 2778 - 92.60% | 175,236$ | 1,927,591$ | 3000 | 100 | 2,166,000$ | 1,857,500$ | 756,591$ | 10,776$ | 555,355$ | 0 | 0 | 5,081,831$ | 143 | 14,259$ | 2,081,814$ |
| 13 |  Little Stars (Dal) | 2000 | 1000 | 70 | 40 | 20118 | 10349 | 91.45% | 94.08% | 29 | 2770 - 92.32% | 173,939$ | 1,913,331$ | 3000 | 100 | 1,877,000$ | 1,742,000$ | 708,768$ | 9,338$ | 503,541$ | 0 | 0 | 5,044,236$ | 143 | 13,070$ | 1,908,220$ |
| 14 |  Marlies (TOR) | 2000 | 1000 | 70 | 40 | 20622 | 10124 | 93.74% | 92.04% | 29 | 2795 - 93.17% | 176,448$ | 1,940,925$ | 3000 | 100 | 2,289,500$ | 2,254,500$ | 801,748$ | 11,391$ | 619,533$ | 0 | 0 | 5,116,984$ | 143 | 14,704$ | 2,146,784$ |
| 15 |  Moose (Win) | 2000 | 1000 | 70 | 40 | 20286 | 10370 | 92.21% | 94.27% | 29 | 2787 - 92.90% | 175,142$ | 1,926,561$ | 3000 | 100 | 3,340,000$ | 3,300,000$ | 930,215$ | 16,617$ | 661,681$ | 0 | 0 | 5,079,115$ | 143 | 21,343$ | 3,116,078$ |
| 16 |  Penguins (Pit) | 2000 | 1000 | 70 | 40 | 20782 | 10334 | 94.46% | 93.95% | 29 | 2829 - 94.29% | 178,319$ | 1,961,504$ | 3000 | 100 | 1,677,500$ | 1,345,000$ | 620,807$ | 8,346$ | 483,987$ | 0 | 0 | 5,171,238$ | 143 | 10,833$ | 1,581,618$ |
| 17 |  Phantoms (Phi) | 2000 | 1000 | 70 | 40 | 20668 | 10199 | 93.95% | 92.72% | 29 | 2806 - 93.54% | 177,041$ | 1,947,456$ | 3000 | 100 | 1,820,000$ | 1,702,500$ | 626,264$ | 9,055$ | 489,455$ | 0 | 0 | 5,134,202$ | 143 | 11,542$ | 1,685,132$ |
| 18 |  Punishers (Bos) | 2000 | 1000 | 70 | 40 | 20219 | 10058 | 91.90% | 91.44% | 29 | 2752 - 91.75% | 173,503$ | 1,908,530$ | 3000 | 100 | 1,644,500$ | 1,544,500$ | 523,829$ | 8,182$ | 441,769$ | 0 | 0 | 5,031,579$ | 143 | 9,674$ | 1,412,404$ |
| 19 |  Rampage (Stl) | 2000 | 1000 | 70 | 40 | 20351 | 10139 | 92.50% | 92.17% | 29 | 2772 - 92.39% | 174,694$ | 1,921,635$ | 3000 | 100 | 1,857,500$ | 1,805,000$ | 673,687$ | 9,241$ | 489,132$ | 0 | 0 | 5,066,129$ | 143 | 12,475$ | 1,821,350$ |
| 20 |  Reign (L.A) | 2000 | 1000 | 70 | 40 | 19705 | 10100 | 89.57% | 91.82% | 29 | 2710 - 90.32% | 170,229$ | 1,872,515$ | 3000 | 100 | 1,865,000$ | 1,810,000$ | 706,606$ | 9,279$ | 501,389$ | 0 | 0 | 4,936,630$ | 143 | 13,010$ | 1,899,460$ |
| 21 |  Rocket (Mon) | 2000 | 1000 | 70 | 40 | 20642 | 10249 | 93.83% | 93.17% | 29 | 2808 - 93.61% | 177,059$ | 1,947,645$ | 3000 | 100 | 2,222,500$ | 2,052,500$ | 744,975$ | 11,057$ | 608,135$ | 0 | 0 | 5,134,700$ | 143 | 13,545$ | 1,977,570$ |
| 22 |  Senators (Ott) | 2000 | 1000 | 70 | 40 | 20626 | 9704 | 93.75% | 88.22% | 29 | 2757 - 91.91% | 174,871$ | 1,923,578$ | 3000 | 100 | 1,922,500$ | 1,922,500$ | 799,609$ | 9,565$ | 525,984$ | 0 | 0 | 5,071,251$ | 143 | 14,540$ | 2,122,840$ |
| 23 |  Sound Tigers (NyI) | 2000 | 1000 | 70 | 40 | 20215 | 10165 | 91.89% | 92.41% | 29 | 2762 - 92.06% | 173,885$ | 1,912,731$ | 3000 | 100 | 1,655,000$ | 1,490,000$ | 723,955$ | 8,234$ | 500,959$ | 0 | 0 | 5,042,654$ | 143 | 12,214$ | 1,783,244$ |
| 24 |  Thunderbirds (Flo) | 2000 | 1000 | 70 | 40 | 20436 | 10022 | 92.89% | 91.11% | 29 | 2769 - 92.30% | 174,816$ | 1,922,971$ | 3000 | 100 | 2,732,500$ | 2,377,500$ | 734,161$ | 13,595$ | 515,259$ | 0 | 0 | 5,069,651$ | 143 | 17,575$ | 2,565,950$ |
| 25 |  Wolfpack (NyR) | 2000 | 1000 | 70 | 40 | 20153 | 10257 | 91.60% | 93.25% | 29 | 2765 - 92.15% | 173,822$ | 1,912,040$ | 3000 | 100 | 2,060,000$ | 1,995,000$ | 675,225$ | 9,975$ | 575,449$ | 0 | 0 | 5,040,833$ | 143 | 11,990$ | 1,750,540$ |
| 26 |  Wolves (Veg) | 2000 | 1000 | 70 | 40 | 20429 | 10340 | 92.86% | 94.00% | 29 | 2797 - 93.24% | 175,983$ | 1,935,812$ | 3000 | 100 | 1,697,500$ | 1,640,000$ | 578,972$ | 8,445$ | 430,963$ | 0 | 0 | 5,103,504$ | 143 | 10,933$ | 1,596,218$ |