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 | Amherst Winterhawks (Sai) | 2000 | 1000 | 35 | 15 | 69652 | 34818 | 99.50% | 99.48% | 5 | 2985 - 99.50% | 84,574$ | 2,960,090$ | 3000 | 110 | 3,461,848$ | 3,461,848$ | 3,226,006$ | 18,414$ | 2,994,822$ | 0 | 0 | 422,870$ | 24 | 19,824$ | 475,776$ |
2 | Arlington Americans (Was) | 2000 | 1000 | 35 | 15 | 71894 | 35915 | 99.85% | 99.76% | 4 | 2995 - 99.82% | 84,862$ | 3,055,015$ | 3000 | 110 | 3,073,236$ | 3,073,236$ | 3,639,588$ | 16,347$ | 3,386,618$ | 0 | 0 | 339,446$ | 24 | 17,890$ | 429,360$ |
3 | Beverly Eagles (Bos) | 2000 | 1000 | 35 | 15 | 71347 | 35534 | 99.09% | 98.71% | 4 | 2969 - 98.96% | 84,171$ | 3,030,155$ | 3000 | 110 | 3,207,839$ | 3,207,839$ | 3,416,069$ | 17,063$ | 3,167,446$ | 0 | 0 | 336,684$ | 24 | 18,579$ | 445,896$ |
4 | Bowling Green Red Devils (Lou) | 2000 | 1000 | 35 | 15 | 69639 | 34759 | 99.48% | 99.31% | 5 | 2983 - 99.43% | 84,536$ | 2,958,750$ | 3000 | 110 | 2,777,949$ | 2,777,949$ | 3,044,732$ | 14,776$ | 2,783,030$ | 0 | 0 | 422,679$ | 24 | 16,372$ | 392,928$ |
5 | Canadaigua Lakers (Roc) | 2000 | 1000 | 35 | 15 | 69626 | 34608 | 99.47% | 98.88% | 5 | 2978 - 99.27% | 84,458$ | 2,956,030$ | 3000 | 110 | 2,250,288$ | 2,250,288$ | 2,499,298$ | 11,970$ | 2,289,923$ | 0 | 0 | 422,290$ | 24 | 13,246$ | 317,904$ |
6 | Cape Breton Kings (Hal) | 2000 | 1000 | 35 | 15 | 72611 | 36360 | 98.12% | 98.27% | 3 | 2945 - 98.17% | 83,427$ | 3,086,785$ | 3000 | 110 | 3,402,776$ | 3,402,776$ | 3,490,533$ | 18,100$ | 3,289,909$ | 0 | 0 | 250,280$ | 24 | 19,323$ | 463,752$ |
7 | Charlesbourg Cavaliers (Que) | 2000 | 1000 | 35 | 15 | 69598 | 34803 | 99.43% | 99.44% | 5 | 2983 - 99.43% | 84,514$ | 2,957,975$ | 3000 | 110 | 2,759,977$ | 2,759,977$ | 2,869,901$ | 14,681$ | 2,643,089$ | 0 | 0 | 422,568$ | 24 | 16,064$ | 385,536$ |
8 | Charlottesville Robins (Ric) | 2000 | 1000 | 35 | 15 | 67484 | 33789 | 99.24% | 99.38% | 6 | 2979 - 99.29% | 84,376$ | 2,868,775$ | 3000 | 110 | 3,458,416$ | 3,458,416$ | 3,389,429$ | 18,396$ | 3,114,643$ | 0 | 0 | 506,254$ | 24 | 20,071$ | 481,704$ |
9 | Columbia Tigers (Bal) | 2000 | 1000 | 35 | 15 | 65568 | 32889 | 99.35% | 99.66% | 7 | 2984 - 99.45% | 84,491$ | 2,788,215$ | 3000 | 110 | 2,723,738$ | 2,723,738$ | 3,148,308$ | 14,488$ | 2,908,431$ | 0 | 0 | 591,440$ | 24 | 15,951$ | 382,824$ |
10 | Concord Goldminers (Cha) | 2000 | 1000 | 35 | 15 | 71107 | 35535 | 98.76% | 98.71% | 4 | 2962 - 98.74% | 83,938$ | 3,021,770$ | 3000 | 110 | 2,391,300$ | 2,391,300$ | 2,649,468$ | 12,720$ | 2,344,179$ | 0 | 0 | 335,752$ | 24 | 14,581$ | 349,944$ |
11 | Dayton Clippers (Cin) | 2000 | 1000 | 35 | 15 | 68138 | 33426 | 94.64% | 92.85% | 4 | 2821 - 94.04% | 80,173$ | 2,886,220$ | 3000 | 100 | 3,091,401$ | 3,091,401$ | 3,205,280$ | 16,444$ | 2,982,829$ | 0 | 0 | 320,691$ | 24 | 17,800$ | 427,200$ |
12 | Elmira Roadrunners (Bin) | 2000 | 1000 | 35 | 15 | 67485 | 33738 | 99.24% | 99.23% | 6 | 2977 - 99.24% | 84,354$ | 2,868,045$ | 3000 | 110 | 2,874,864$ | 2,874,864$ | 2,913,889$ | 15,292$ | 2,704,521$ | 0 | 0 | 506,126$ | 24 | 16,568$ | 397,632$ |
13 | Evanston Thunderbirds (Cht) | 2000 | 1000 | 35 | 15 | 65670 | 33398 | 93.81% | 95.42% | 5 | 2831 - 94.35% | 79,983$ | 2,799,420$ | 3000 | 100 | 3,294,068$ | 3,294,068$ | 3,316,368$ | 17,522$ | 3,076,473$ | 0 | 0 | 399,917$ | 24 | 18,984$ | 455,616$ |
14 | Harrisburg Rockets (Lhv) | 2000 | 1000 | 35 | 15 | 65568 | 32865 | 99.35% | 99.59% | 7 | 2983 - 99.43% | 84,480$ | 2,787,855$ | 3000 | 110 | 3,513,765$ | 3,513,765$ | 3,387,100$ | 18,690$ | 3,081,776$ | 0 | 0 | 591,363$ | 24 | 20,552$ | 493,248$ |
15 | Johnstown Yellow Jackets (Pit) | 2000 | 1000 | 35 | 15 | 58500 | 30015 | 91.41% | 93.80% | 8 | 2766 - 92.20% | 78,054$ | 2,497,725$ | 3000 | 100 | 2,314,268$ | 2,314,268$ | 2,725,437$ | 12,310$ | 2,463,749$ | 0 | 0 | 624,431$ | 24 | 13,906$ | 333,744$ |
16 | Lafayette Racers (Ind) | 2000 | 1000 | 35 | 15 | 69200 | 34238 | 98.86% | 97.82% | 5 | 2955 - 98.51% | 83,873$ | 2,935,570$ | 3000 | 110 | 3,339,469$ | 3,339,469$ | 3,440,794$ | 17,763$ | 3,200,895$ | 0 | 0 | 419,367$ | 24 | 19,226$ | 461,424$ |
17 | Longueuil Voyageurs (Mtl) | 2000 | 1000 | 35 | 15 | 69517 | 34601 | 99.31% | 98.86% | 5 | 2975 - 99.16% | 84,346$ | 2,952,110$ | 3000 | 110 | 2,506,046$ | 2,506,046$ | 2,771,137$ | 13,330$ | 2,522,521$ | 0 | 0 | 421,730$ | 24 | 14,846$ | 356,304$ |
18 | Lowell Plainsmen (Wor) | 2000 | 1000 | 35 | 15 | 71562 | 35825 | 99.39% | 99.51% | 4 | 2983 - 99.43% | 84,501$ | 3,042,045$ | 3000 | 110 | 2,528,476$ | 2,528,476$ | 2,722,634$ | 13,449$ | 2,482,750$ | 0 | 0 | 338,005$ | 24 | 14,912$ | 357,888$ |
19 | Montpelier Cougars (Bur) | 2000 | 1000 | 35 | 15 | 70996 | 35597 | 98.61% | 98.88% | 4 | 2961 - 98.70% | 83,856$ | 3,018,815$ | 3000 | 110 | 2,307,484$ | 2,307,484$ | 2,826,598$ | 12,274$ | 2,586,691$ | 0 | 0 | 335,424$ | 24 | 13,737$ | 329,688$ |
20 | Napean Spartans (Ott) | 2000 | 1000 | 35 | 15 | 64683 | 31798 | 95.12% | 93.52% | 6 | 2838 - 94.59% | 80,614$ | 2,740,875$ | 3000 | 100 | 2,703,404$ | 2,703,404$ | 2,979,256$ | 14,380$ | 2,717,529$ | 0 | 0 | 483,684$ | 24 | 15,976$ | 383,424$ |
21 | Niagara Falls Wings (Buf) | 2000 | 1000 | 35 | 15 | 67800 | 33749 | 99.71% | 99.26% | 6 | 2987 - 99.56% | 84,683$ | 2,879,235$ | 3000 | 110 | 3,009,664$ | 3,009,664$ | 3,348,724$ | 16,009$ | 3,113,193$ | 0 | 0 | 508,100$ | 24 | 17,445$ | 418,680$ |
22 | Pawtucket Reds (Pro) | 2000 | 1000 | 35 | 15 | 73139 | 36198 | 98.84% | 97.83% | 3 | 2955 - 98.50% | 83,860$ | 3,102,835$ | 3000 | 110 | 2,454,319$ | 2,454,319$ | 2,791,770$ | 13,055$ | 2,508,266$ | 0 | 0 | 251,581$ | 24 | 14,784$ | 354,816$ |
23 | Reading Patriots (Phi) | 2000 | 1000 | 35 | 15 | 64924 | 32710 | 98.37% | 99.12% | 7 | 2959 - 98.62% | 83,727$ | 2,762,990$ | 3000 | 110 | 2,997,696$ | 2,997,696$ | 2,804,090$ | 15,945$ | 2,594,725$ | 0 | 0 | 586,089$ | 24 | 17,222$ | 413,328$ |
24 | Scarborough Royals (Tor) | 2000 | 1000 | 35 | 15 | 69481 | 34488 | 99.26% | 98.54% | 5 | 2971 - 99.02% | 84,262$ | 2,949,155$ | 3000 | 110 | 2,943,954$ | 2,943,954$ | 2,828,890$ | 15,659$ | 2,619,526$ | 0 | 0 | 421,308$ | 24 | 16,936$ | 406,464$ |
25 | Troy Indians (Alb) | 2000 | 1000 | 35 | 15 | 67267 | 33741 | 98.92% | 99.24% | 6 | 2971 - 99.03% | 84,131$ | 2,860,460$ | 3000 | 110 | 2,816,824$ | 2,816,824$ | 3,049,478$ | 14,983$ | 2,787,791$ | 0 | 0 | 504,787$ | 24 | 16,579$ | 397,896$ |
26 | Virginia Beach Mariners (Vir) | 2000 | 1000 | 35 | 15 | 71529 | 35692 | 99.35% | 99.14% | 4 | 2978 - 99.28% | 84,414$ | 3,038,895$ | 3000 | 110 | 3,353,514$ | 3,353,514$ | 3,327,219$ | 17,838$ | 3,087,879$ | 0 | 0 | 337,655$ | 24 | 19,301$ | 463,224$ |
27 | Watertown Bulls (Syr) | 2000 | 1000 | 35 | 15 | 65248 | 32696 | 98.86% | 99.08% | 7 | 2968 - 98.93% | 84,064$ | 2,774,120$ | 3000 | 110 | 3,128,632$ | 3,128,632$ | 3,158,090$ | 16,642$ | 2,905,090$ | 0 | 0 | 588,450$ | 24 | 18,184$ | 436,416$ |
28 | Williamsburg Dragons (Brk) | 2000 | 1000 | 35 | 15 | 67538 | 33823 | 99.32% | 99.48% | 6 | 2981 - 99.37% | 84,446$ | 2,871,175$ | 3000 | 110 | 2,166,366$ | 2,166,366$ | 2,479,283$ | 11,523$ | 2,261,192$ | 0 | 0 | 506,678$ | 24 | 12,853$ | 308,472$ |