| 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 Total Estimate | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Special Salary Cap Value | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Luxury Taxe Total | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses | Estimated Season Expenses | Estimated Season Salary Cap | Over Minimum Salary Cap of 76,900,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Beauce Jaros | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 77,920,834$ | 77,920,834$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 2 | Boston Assasins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 88,790,834$ | 88,790,834$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 3 | Buffalo Mafia | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 87,956,071$ | 87,956,071$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 4 | Charlotte Iron Crown | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 75,522,334$ | 75,522,334$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 5 | Chicago Warhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 61,380,000$ | 61,380,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 6 | Cincinnati Cyclones | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,381,666$ | 71,381,666$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 7 | Colorado Outlaws | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 102,550,000$ | 102,550,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 8 | Dallas Aliens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 86,532,416$ | 86,532,416$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 9 | Detroit Cardinals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 81,783,565$ | 81,783,565$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 10 | Florida Pelicans | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 90,407,500$ | 90,407,500$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 11 | Houston Havoc | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 81,630,000$ | 77,030,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 12 | Jacksonville Reptiles | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,305,000$ | 74,305,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 13 | Los Angeles Horizon | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 78,617,856$ | 78,617,856$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 14 | Memphis Titans | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 81,155,000$ | 81,155,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 15 | Minnesota North Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 86,800,000$ | 86,800,000$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 16 | Monterrey Xolos | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 57,071,667$ | 57,071,667$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 17 | Montreal Caribou | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 87,536,666$ | 87,536,666$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 18 | Nashville Bulldogs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 88,600,000$ | 88,600,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 19 | New York Highlanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 62,685,999$ | 59,685,999$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 20 | Philadelphia Phantoms | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 78,079,167$ | 78,079,167$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 21 | Quebec City Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 75,934,166$ | 75,934,166$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 22 | Riviere-du-loup Draveurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 94,798,542$ | 94,798,542$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 23 | Saguenay Orignaux | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 83,208,214$ | 83,208,214$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 24 | San Diego Vortex | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 81,665,706$ | 81,665,706$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 0$ | 0$ |
| 25 | San Francisco Blazers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 87,311,667$ | 87,311,667$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 26 | San Jose Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 69,237,500$ | 69,237,500$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 27 | Sherbrooke Castors | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 94,375,000$ | 94,375,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 28 | Toronto True North | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 84,166,667$ | 84,166,667$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 29 | Utah Yetis | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 89,280,357$ | 89,280,357$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 30 | Vancouver Grizzlies | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,249,167$ | 74,249,167$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |
| 31 | Vegas Honeybaked | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 103,978,333$ | 103,978,333$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 0$ | 0$ |
| 32 | Winnipeg Bisons | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 0 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,628,613$ | 70,628,613$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -76,900,000$ | 104,000,000$ | 104,000,000$ | 10,000,000$ | 10,000,000$ |