| 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 |
| Arena 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 | Arena Capacity | Team Popularity | Players Total Salaries | Players Total Average Salaries | 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 9,775,490$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Albany Indians | 3167 | 1775 | 1395 | 1475 | 700 | 78 | 64 | 50 | 38 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 8512 | 120 | 22,404,081$ | 22,404,081$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 530,472$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 29,187,004$ | 29,187,004$ |
| 2 | Baltimore Tigers | 4500 | 2500 | 1750 | 1500 | 750 | 102 | 80 | 55 | 43 | 211 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 11000 | 70 | 19,674,340$ | 19,674,340$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 41,059,913$ | 41,059,913$ |
| 3 | Binghamton Roadrunners | 1675 | 1100 | 850 | 660 | 570 | 143 | 106 | 70 | 53 | 308 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 4855 | 70 | 19,620,816$ | 19,620,816$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 49,954,959$ | 49,954,959$ |
| 4 | Boston Eagles | 2000 | 1250 | 750 | 2000 | 700 | 168 | 113 | 70 | 43 | 302 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 6700 | 125 | 21,758,810$ | 21,758,810$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 45,197$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 23,523,506$ | 23,523,506$ |
| 5 | Brooklyn Dragons | 3500 | 1950 | 1200 | 1200 | 1500 | 82 | 65 | 51 | 40 | 202 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 9350 | 115 | 23,862,168$ | 23,862,168$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 979,329$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 60,809,899$ | 60,809,899$ |
| 6 | Buffalo Wings | 2900 | 1374 | 771 | 1600 | 802 | 90 | 65 | 43 | 32 | 216 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 7447 | 150 | 17,899,268$ | 17,899,268$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 839$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 25,167,238$ | 25,167,238$ |
| 7 | Burlington Cougars | 2000 | 800 | 700 | 500 | 1000 | 122 | 90 | 58 | 43 | 252 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 5000 | 300 | 19,726,154$ | 19,726,154$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 68,301,030$ | 68,301,030$ |
| 8 | Cincinnati Clippers | 4800 | 3500 | 2600 | 1400 | 1500 | 90 | 68 | 54 | 36 | 173 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 13800 | 40 | 16,370,957$ | 16,370,957$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 95,395,509$ | 95,395,509$ |
| 9 | Halifax Kings | 3375 | 1875 | 1450 | 2427 | 825 | 75 | 59 | 44 | 29 | 147 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 9952 | 145 | 19,965,985$ | 20,215,985$ | 0$ | 0$ | 0$ | 0$ | 21 | 3 | 347,648$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 59,095,489$ | 59,095,489$ |
| 10 | Indianapolis Racers | 4500 | 2750 | 2275 | 1675 | 1100 | 80 | 70 | 55 | 29 | 176 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 12300 | 70 | 17,811,339$ | 17,811,339$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 51,557,831$ | 51,557,831$ |
| 11 | Lehigh Valley Rockets | 3600 | 2250 | 1350 | 906 | 940 | 99 | 77 | 55 | 31 | 237 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 9046 | 70 | 22,794,479$ | 22,794,479$ | 0$ | 0$ | 0$ | 0$ | 29 | 1 | 410,452$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 30,871,776$ | 30,871,776$ |
| 12 | Louisville Red Devils | 3300 | 1575 | 1350 | 1250 | 900 | 110 | 75 | 57 | 40 | 186 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 8375 | 110 | 22,602,932$ | 22,602,932$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 505,841$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 27,677,875$ | 27,677,875$ |
| 13 | Montreal Voyageurs | 2000 | 1500 | 1250 | 800 | 500 | 131 | 87 | 65 | 24 | 189 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 6050 | 240 | 23,474,620$ | 23,474,620$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 739,231$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 29,566,851$ | 29,566,851$ |
| 14 | Ottawa Spartans | 3500 | 2500 | 1750 | 1250 | 1500 | 115 | 68 | 54 | 36 | 184 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 10500 | 130 | 16,068,015$ | 16,068,015$ | 0$ | 0$ | 0$ | 0$ | 26 | 3 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 90,380,572$ | 90,380,572$ |
| 15 | Philadelphia Patriots | 3755 | 2500 | 1500 | 850 | 995 | 70 | 45 | 36 | 29 | 176 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 9600 | 175 | 17,853,077$ | 17,853,077$ | 0$ | 0$ | 0$ | 0$ | 25 | 2 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 50,792,068$ | 50,792,068$ |
| 16 | Pittsburgh Yellow Jackets | 4225 | 2500 | 1805 | 2200 | 1250 | 95 | 67 | 50 | 35 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 11980 | 80 | 19,009,262$ | 19,009,262$ | 0$ | 0$ | 0$ | 0$ | 27 | 3 | 11,450$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 57,642,409$ | 57,642,409$ |
| 17 | Portland Wolves | 2450 | 1475 | 975 | 933 | 900 | 130 | 109 | 80 | 60 | 315 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 6733 | 50 | 15,518,656$ | 15,518,656$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | -3,484,111$ | -3,484,111$ |
| 18 | Providence Englishmen | 4000 | 2500 | 2000 | 1500 | 1000 | 54 | 46 | 33 | 26 | 130 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 11000 | 160 | 18,755,828$ | 18,755,828$ | 0$ | 0$ | 0$ | 0$ | 23 | 4 | 202,866$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 69,791,634$ | 69,791,634$ |
| 19 | Quebec Cavaliers | 3170 | 2100 | 1500 | 1100 | 650 | 74 | 55 | 48 | 31 | 173 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 8520 | 155 | 17,250,538$ | 17,250,538$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 27,036,433$ | 27,036,433$ |
| 20 | Richmond Robins | 2635 | 1744 | 1257 | 775 | 705 | 95 | 74 | 58 | 42 | 211 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 7116 | 105 | 15,016,186$ | 15,016,186$ | 0$ | 0$ | 0$ | 0$ | 25 | 3 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 33,425,191$ | 33,425,191$ |
| 21 | Rochester Lakers | 2600 | 1800 | 1200 | 1000 | 800 | 95 | 77 | 61 | 42 | 243 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 7400 | 155 | 18,559,116$ | 18,559,116$ | 0$ | 0$ | 0$ | 0$ | 22 | 4 | 392,484$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 37,593,499$ | 37,593,499$ |
| 22 | Saint John Winterhawks | 2100 | 1250 | 1050 | 800 | 800 | 113 | 90 | 62 | 46 | 212 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 6000 | 90 | 16,024,020$ | 16,024,020$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 10,997,678$ | 10,997,678$ |
| 23 | Syracuse Bulls | 2350 | 1550 | 1200 | 900 | 1050 | 131 | 87 | 70 | 44 | 232 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 7050 | 90 | 21,607,522$ | 21,607,522$ | 0$ | 0$ | 0$ | 0$ | 23 | 2 | 842,589$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 11,165,238$ | 11,165,238$ |
| 24 | Toronto Royals | 3300 | 2000 | 1700 | 1000 | 1000 | 77 | 57 | 47 | 34 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 9000 | 130 | 18,672,025$ | 18,672,025$ | 0$ | 0$ | 0$ | 0$ | 25 | 4 | 365,546$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 49,127,282$ | 49,127,282$ |
| 25 | Virginia Mariners | 2500 | 1400 | 1100 | 850 | 800 | 86 | 70 | 52 | 41 | 208 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 6650 | 85 | 18,387,173$ | 18,387,173$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 3,391,976$ | 3,391,976$ |
| 26 | Washington Americans | 4200 | 2250 | 1500 | 800 | 1250 | 108 | 73 | 58 | 43 | 196 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 10000 | 40 | 19,070,770$ | 19,070,770$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 33,689,866$ | 33,689,866$ |
| 27 | Worcester Plainsmen | 3800 | 2410 | 1600 | 1010 | 800 | 106 | 74 | 53 | 37 | 185 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 9620 | 160 | 22,735,524$ | 24,635,524$ | 0$ | 0$ | 0$ | 0$ | 23 | 3 | 672,980$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -9,775,490$ | 21,723,311$ | 21,723,311$ | 34,534,099$ | 34,534,099$ |