| 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 |  Admirals (NSH) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 17,680,334$ | 17,680,334$ | 5,529,890$ | 90,206$ | 5,529,890$ | 0 | 0 | 3,034,500$ | 134 | 90,206$ | 12,087,604$ |
| 2 |  Americans (BUF) | 3500 | 1500 | 50 | 25 | 49000 | 21000 | 100.00% | 100.00% | 27 | 5000 - 100.00% | 108,375$ | 1,517,250$ | 5000 | 100 | 21,380,266$ | 21,380,266$ | 6,765,746$ | 109,083$ | 6,765,746$ | 0 | 0 | 2,926,125$ | 134 | 109,083$ | 14,617,122$ |
| 3 |  Barracuda (SJS) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 19,541,500$ | 19,541,500$ | 6,327,003$ | 99,702$ | 6,327,003$ | 0 | 0 | 3,034,500$ | 134 | 99,702$ | 13,360,068$ |
| 4 |  Bears (WAS) | 3500 | 1500 | 50 | 25 | 49000 | 21000 | 100.00% | 100.00% | 27 | 5000 - 100.00% | 108,375$ | 1,517,250$ | 5000 | 100 | 16,727,976$ | 16,727,976$ | 5,112,705$ | 85,347$ | 5,112,705$ | 0 | 0 | 2,926,125$ | 134 | 85,347$ | 11,436,498$ |
| 5 |  Bruins (BOS) | 3500 | 1500 | 10 | 5 | 56000 | 24000 | 100.00% | 100.00% | 25 | 5000 - 100.00% | 21,675$ | 346,800$ | 5000 | 100 | 15,593,050$ | 15,593,050$ | 4,784,297$ | 79,556$ | 4,784,297$ | 0 | 0 | 541,875$ | 134 | 79,556$ | 10,660,504$ |
| 6 |  Canucks (VAN) | 3500 | 1500 | 50 | 25 | 38500 | 16500 | 100.00% | 100.00% | 30 | 5000 - 100.00% | 108,375$ | 1,192,125$ | 5000 | 100 | 21,429,084$ | 21,429,084$ | 6,859,776$ | 109,332$ | 6,859,776$ | 0 | 0 | 3,251,250$ | 134 | 109,332$ | 14,650,488$ |
| 7 |  Checkers (FLA) | 3500 | 1500 | 50 | 25 | 49000 | 21000 | 100.00% | 100.00% | 27 | 5000 - 100.00% | 108,375$ | 1,517,250$ | 5000 | 100 | 17,656,584$ | 17,656,584$ | 5,364,653$ | 90,085$ | 5,364,653$ | 0 | 0 | 2,926,125$ | 134 | 90,085$ | 12,071,390$ |
| 8 |  Comets (NJD) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 19,517,500$ | 19,517,500$ | 6,395,864$ | 99,579$ | 6,395,864$ | 0 | 0 | 3,034,500$ | 134 | 99,579$ | 13,343,586$ |
| 9 |  Condors (EDM) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 20,853,332$ | 20,853,332$ | 6,668,041$ | 106,395$ | 6,668,041$ | 0 | 0 | 3,142,875$ | 134 | 106,395$ | 14,256,930$ |
| 10 |  Crunch (TBL) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 15,329,834$ | 15,329,834$ | 4,664,891$ | 78,213$ | 4,664,891$ | 0 | 0 | 3,034,500$ | 134 | 78,213$ | 10,480,542$ |
| 11 |  Eagles (COL) | 3500 | 1500 | 50 | 25 | 49000 | 21000 | 100.00% | 100.00% | 27 | 5000 - 100.00% | 108,375$ | 1,517,250$ | 5000 | 100 | 18,933,580$ | 18,933,580$ | 5,873,319$ | 96,600$ | 5,873,319$ | 0 | 0 | 2,926,125$ | 134 | 96,600$ | 12,944,400$ |
| 12 |  Firebirds (SEA) | 3500 | 1500 | 10 | 5 | 49000 | 21000 | 100.00% | 100.00% | 27 | 5000 - 100.00% | 21,675$ | 303,450$ | 5000 | 100 | 19,901,668$ | 19,901,668$ | 6,295,418$ | 101,539$ | 6,295,418$ | 0 | 0 | 585,225$ | 134 | 101,539$ | 13,606,226$ |
| 13 |  Griffins (DET) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 22,083,114$ | 22,083,114$ | 6,961,370$ | 112,669$ | 6,961,370$ | 0 | 0 | 3,034,500$ | 134 | 112,669$ | 15,097,646$ |
| 14 |  Gulls (ANA) | 3500 | 1500 | 50 | 25 | 49000 | 21000 | 100.00% | 100.00% | 27 | 5000 - 100.00% | 108,375$ | 1,517,250$ | 5000 | 100 | 20,604,042$ | 20,604,042$ | 6,272,867$ | 105,123$ | 6,272,867$ | 0 | 0 | 2,926,125$ | 134 | 105,123$ | 14,086,482$ |
| 15 |  IceHogs (CHI) | 3500 | 1500 | 50 | 25 | 38500 | 16500 | 100.00% | 100.00% | 30 | 5000 - 100.00% | 108,375$ | 1,192,125$ | 5000 | 100 | 17,119,170$ | 17,119,170$ | 5,352,496$ | 87,343$ | 5,352,496$ | 0 | 0 | 3,251,250$ | 134 | 87,343$ | 11,703,962$ |
| 16 |  Islanders (NYI) | 3500 | 1500 | 50 | 25 | 38500 | 16500 | 100.00% | 100.00% | 30 | 5000 - 100.00% | 108,375$ | 1,192,125$ | 5000 | 100 | 24,799,008$ | 24,799,008$ | 7,681,863$ | 126,526$ | 7,681,863$ | 0 | 0 | 3,251,250$ | 134 | 126,526$ | 16,954,484$ |
| 17 |  Marlies (TOR) | 3500 | 1500 | 50 | 25 | 52500 | 22500 | 100.00% | 100.00% | 26 | 5000 - 100.00% | 108,375$ | 1,625,625$ | 5000 | 100 | 19,297,292$ | 19,297,292$ | 6,076,470$ | 98,456$ | 6,076,470$ | 0 | 0 | 2,817,750$ | 134 | 98,456$ | 13,193,104$ |
| 18 |  Monsters (CBJ) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 22,801,042$ | 22,801,042$ | 7,211,821$ | 116,332$ | 7,211,821$ | 0 | 0 | 3,142,875$ | 134 | 116,332$ | 15,588,488$ |
| 19 |  Moose (WIN) | 3500 | 1500 | 50 | 25 | 38500 | 16500 | 100.00% | 100.00% | 30 | 5000 - 100.00% | 108,375$ | 1,192,125$ | 5000 | 100 | 21,787,140$ | 21,787,140$ | 6,690,958$ | 111,159$ | 6,690,958$ | 0 | 0 | 3,251,250$ | 134 | 111,159$ | 14,895,306$ |
| 20 |  Penguins (PIT) | 3500 | 1500 | 50 | 25 | 52500 | 22500 | 100.00% | 100.00% | 26 | 5000 - 100.00% | 108,375$ | 1,625,625$ | 5000 | 100 | 15,377,750$ | 15,377,750$ | 4,738,215$ | 78,458$ | 4,738,215$ | 0 | 0 | 2,817,750$ | 134 | 78,458$ | 10,513,372$ |
| 21 |  Phantoms (PHI) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 21,227,838$ | 21,227,838$ | 7,054,926$ | 108,305$ | 7,054,926$ | 0 | 0 | 3,034,500$ | 134 | 108,305$ | 14,512,870$ |
| 22 |  Reign (LAK) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 16,204,850$ | 16,204,850$ | 5,126,036$ | 82,678$ | 5,126,036$ | 0 | 0 | 3,142,875$ | 134 | 82,678$ | 11,078,852$ |
| 23 |  Roadrunners (UHC) | 3500 | 1500 | 50 | 25 | 38500 | 16500 | 100.00% | 100.00% | 30 | 5000 - 100.00% | 108,375$ | 1,192,125$ | 5000 | 100 | 16,133,117$ | 16,133,117$ | 5,076,121$ | 82,312$ | 5,076,121$ | 0 | 0 | 3,251,250$ | 134 | 82,312$ | 11,029,808$ |
| 24 |  Rocket (MTL) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 17,922,084$ | 17,922,084$ | 5,636,646$ | 91,439$ | 5,636,646$ | 0 | 0 | 3,034,500$ | 134 | 91,439$ | 12,252,826$ |
| 25 |  Senators (OTT) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 15,685,000$ | 15,685,000$ | 4,809,396$ | 80,026$ | 4,809,396$ | 0 | 0 | 3,142,875$ | 134 | 80,026$ | 10,723,484$ |
| 26 |  Silver Knights (VGK) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 17,780,832$ | 17,780,832$ | 5,340,198$ | 90,719$ | 5,340,198$ | 0 | 0 | 3,034,500$ | 134 | 90,719$ | 12,156,346$ |
| 27 |  Stars (DAL) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 20,601,736$ | 20,601,736$ | 6,971,274$ | 105,111$ | 6,971,274$ | 0 | 0 | 3,142,875$ | 134 | 105,111$ | 14,084,874$ |
| 28 |  Thunderbirds (STL) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 15,944,000$ | 15,944,000$ | 4,886,499$ | 81,347$ | 4,886,499$ | 0 | 0 | 3,142,875$ | 134 | 81,347$ | 10,900,498$ |
| 29 |  Wild (MIN) | 3500 | 1500 | 50 | 25 | 38500 | 16500 | 100.00% | 100.00% | 30 | 5000 - 100.00% | 108,375$ | 1,192,125$ | 5000 | 100 | 16,128,444$ | 16,128,444$ | 5,135,241$ | 82,288$ | 5,135,241$ | 0 | 0 | 3,251,250$ | 134 | 82,288$ | 11,026,592$ |
| 30 |  Wolf Pack (NYR) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 25,092,334$ | 25,092,334$ | 7,851,198$ | 128,022$ | 7,851,198$ | 0 | 0 | 3,142,875$ | 134 | 128,022$ | 17,154,948$ |
| 31 |  Wolves (CAR) | 3500 | 1500 | 50 | 25 | 42000 | 18000 | 100.00% | 100.00% | 29 | 5000 - 100.00% | 108,375$ | 1,300,500$ | 5000 | 100 | 23,165,836$ | 23,165,836$ | 7,212,709$ | 118,193$ | 7,212,709$ | 0 | 0 | 3,142,875$ | 134 | 118,193$ | 15,837,862$ |
| 32 |  Wranglers (CGY) | 3500 | 1500 | 50 | 25 | 45500 | 19500 | 100.00% | 100.00% | 28 | 5000 - 100.00% | 108,375$ | 1,408,875$ | 5000 | 100 | 16,997,278$ | 16,997,278$ | 5,710,861$ | 86,721$ | 5,710,861$ | 0 | 0 | 3,034,500$ | 134 | 86,721$ | 11,620,614$ |