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 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Arena 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 | Bangor Mohawks (Oro) | 2000 | 1000 | 35 | 15 | 79324 | 39729 | 99.16% | 99.32% | 0 | 2976 - 99.21% | 84,307$ | 3,372,275$ | 3000 | 110 | 532,750$ | 532,750$ | 567,797$ | 0$ | 517,793$ | 0 | 0 | 0$ | 0 | 3,597$ | 0$ |
2 | Boston Jr. Eagles (Bos) | 2000 | 1000 | 35 | 15 | 79259 | 39535 | 99.07% | 98.84% | 0 | 2970 - 99.00% | 84,177$ | 3,367,090$ | 3000 | 110 | 621,000$ | 621,000$ | 700,434$ | 0$ | 655,438$ | 0 | 0 | 0$ | 0 | 4,111$ | 0$ |
3 | Bridgeport Hawks (Nhv) | 2000 | 1000 | 35 | 15 | 79800 | 39925 | 99.75% | 99.81% | 0 | 2993 - 99.77% | 84,797$ | 3,391,875$ | 3000 | 110 | 573,750$ | 573,750$ | 841,983$ | 0$ | 591,995$ | 0 | 0 | 0$ | 0 | 5,085$ | 0$ |
4 | Buffalo Jr. Wings (Buf) | 2000 | 1000 | 35 | 15 | 79599 | 39775 | 99.50% | 99.44% | 0 | 2984 - 99.48% | 84,565$ | 3,382,590$ | 3000 | 110 | 587,500$ | 587,500$ | 644,698$ | 0$ | 602,192$ | 0 | 0 | 0$ | 0 | 3,889$ | 0$ |
5 | Canadaigua Lakers (Roc) | 2000 | 1000 | 35 | 15 | 79378 | 39557 | 99.22% | 98.89% | 0 | 2973 - 99.11% | 84,290$ | 3,371,585$ | 3000 | 110 | 627,750$ | 627,750$ | 677,115$ | 0$ | 637,119$ | 0 | 0 | 0$ | 0 | 4,122$ | 0$ |
6 | Hamilton Roadrunners (Bin) | 2000 | 1000 | 35 | 15 | 79510 | 39793 | 99.39% | 99.48% | 0 | 2983 - 99.42% | 84,494$ | 3,379,745$ | 3000 | 110 | 551,750$ | 551,750$ | 623,566$ | 0$ | 578,558$ | 0 | 0 | 0$ | 0 | 3,684$ | 0$ |
7 | Holyoke Plainsmen (Wor) | 2000 | 1000 | 35 | 15 | 79050 | 39746 | 98.81% | 99.37% | 0 | 2970 - 99.00% | 84,074$ | 3,362,940$ | 3000 | 110 | 618,250$ | 618,250$ | 650,399$ | 0$ | 597,898$ | 0 | 0 | 0$ | 0 | 4,140$ | 0$ |
8 | Lake Placid Mountaineers (Adr) | 2000 | 1000 | 35 | 15 | 79118 | 39755 | 98.90% | 99.39% | 0 | 2972 - 99.06% | 84,136$ | 3,365,455$ | 3000 | 110 | 546,250$ | 546,250$ | 609,283$ | 0$ | 564,268$ | 0 | 0 | 0$ | 0 | 3,650$ | 0$ |
9 | Montpelier Cougars (Bur) | 2000 | 1000 | 35 | 15 | 79125 | 39541 | 98.91% | 98.85% | 0 | 2967 - 98.89% | 84,062$ | 3,362,490$ | 3000 | 110 | 533,500$ | 533,500$ | 588,368$ | 0$ | 543,398$ | 0 | 0 | 0$ | 0 | 3,571$ | 0$ |
10 | Newburgh Kings (Kng) | 2000 | 1000 | 35 | 15 | 79170 | 39710 | 98.96% | 99.28% | 0 | 2972 - 99.07% | 84,165$ | 3,366,600$ | 3000 | 110 | 543,500$ | 543,500$ | 601,961$ | 0$ | 556,951$ | 0 | 0 | 0$ | 0 | 3,633$ | 0$ |
11 | Newport Reds (Pro) | 2000 | 1000 | 35 | 15 | 78944 | 39616 | 98.68% | 99.04% | 0 | 2964 - 98.80% | 83,932$ | 3,357,280$ | 3000 | 110 | 532,500$ | 532,500$ | 591,176$ | 0$ | 541,181$ | 0 | 0 | 0$ | 0 | 3,596$ | 0$ |
12 | Portsmouth Panthers (Dur) | 2000 | 1000 | 35 | 15 | 78762 | 39552 | 98.45% | 98.88% | 0 | 2958 - 98.60% | 83,749$ | 3,349,950$ | 3000 | 110 | 453,250$ | 453,250$ | 494,150$ | 0$ | 450,645$ | 0 | 0 | 0$ | 0 | 3,066$ | 0$ |
13 | Skaneatles Bulls (Syr) | 2000 | 1000 | 35 | 15 | 79446 | 39724 | 99.31% | 99.31% | 0 | 2979 - 99.31% | 84,412$ | 3,376,470$ | 3000 | 110 | 547,500$ | 547,500$ | 635,021$ | 0$ | 575,014$ | 0 | 0 | 0$ | 0 | 3,750$ | 0$ |
14 | Troy Indians (Alb) | 2000 | 1000 | 35 | 15 | 79660 | 39713 | 99.58% | 99.28% | 0 | 2984 - 99.48% | 84,595$ | 3,383,795$ | 3000 | 110 | 572,500$ | 572,500$ | 630,949$ | 0$ | 570,965$ | 0 | 0 | 0$ | 0 | 3,904$ | 0$ |
15 | Ulster Bearcats (Cat) | 2000 | 1000 | 35 | 15 | 78715 | 39124 | 98.39% | 97.81% | 0 | 2946 - 98.20% | 83,547$ | 3,341,885$ | 3000 | 110 | 586,750$ | 586,750$ | 661,889$ | 0$ | 614,383$ | 0 | 0 | 0$ | 0 | 3,915$ | 0$ |
16 | Waterbury Red Devils (Har) | 2000 | 1000 | 35 | 15 | 79425 | 39825 | 99.28% | 99.56% | 0 | 2981 - 99.38% | 84,431$ | 3,377,250$ | 3000 | 110 | 621,250$ | 621,250$ | 685,950$ | 0$ | 635,943$ | 0 | 0 | 0$ | 0 | 4,144$ | 0$ |