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 | ![]() | 3000 | 2000 | 5 | 2 | 54020 | 36488 | 94.77% | 96.02% | 18 | 4764 - 95.27% | 15,348$ | 291,615$ | 5000 | 100 | 95,900$ | 95,900$ | 71,172$ | 0$ | 50,436$ | 0 | 0 | 276,267$ | 62 | 978$ | 65,526$ |
2 | ![]() | 2000 | 1000 | 3 | 1 | 37886 | 19000 | 99.70% | 100.00% | 18 | 2994 - 99.80% | 5,935$ | 112,759$ | 3000 | 100 | 82,900$ | 82,900$ | 64,032$ | 0$ | 43,308$ | 0 | 0 | 106,824$ | 62 | 884$ | 59,228$ |
3 | ![]() | 3000 | 2000 | 5 | 2 | 58862 | 38901 | 98.10% | 97.25% | 17 | 4888 - 97.76% | 15,815$ | 316,296$ | 5000 | 100 | 165,400$ | 165,400$ | 110,573$ | 0$ | 89,845$ | 0 | 0 | 268,852$ | 62 | 1,478$ | 99,026$ |
4 | ![]() | 2000 | 1000 | 2 | 1 | 40000 | 20000 | 100.00% | 100.00% | 17 | 3000 - 100.00% | 4,250$ | 85,000$ | 3000 | 100 | 136,600$ | 136,600$ | 91,428$ | 0$ | 70,692$ | 0 | 0 | 72,250$ | 62 | 1,271$ | 85,157$ |
5 | ![]() | 3000 | 2000 | 5 | 2 | 54710 | 36550 | 95.98% | 96.18% | 18 | 4803 - 96.06% | 15,508$ | 294,654$ | 5000 | 100 | 123,800$ | 123,800$ | 85,014$ | 0$ | 64,344$ | 0 | 0 | 279,146$ | 62 | 1,178$ | 78,926$ |
6 | ![]() | 2000 | 1000 | 3 | 1 | 37939 | 19000 | 99.84% | 100.00% | 18 | 2997 - 99.89% | 5,942$ | 112,894$ | 3000 | 100 | 76,600$ | 76,600$ | 66,579$ | 0$ | 45,863$ | 0 | 0 | 106,952$ | 62 | 839$ | 56,213$ |
7 | ![]() | 2000 | 1000 | 3 | 1 | 38000 | 19000 | 100.00% | 100.00% | 18 | 3000 - 100.00% | 5,950$ | 113,050$ | 3000 | 100 | 129,200$ | 129,200$ | 86,178$ | 0$ | 65,442$ | 0 | 0 | 107,100$ | 62 | 1,217$ | 81,539$ |
8 | ![]() | 3000 | 2000 | 5 | 2 | 58193 | 39096 | 96.99% | 97.74% | 17 | 4864 - 97.29% | 15,689$ | 313,784$ | 5000 | 100 | 170,500$ | 170,500$ | 105,113$ | 0$ | 84,395$ | 0 | 0 | 266,716$ | 62 | 1,514$ | 101,438$ |
9 | ![]() | 3000 | 2000 | 5 | 2 | 55843 | 36914 | 97.97% | 97.14% | 18 | 4882 - 97.64% | 15,794$ | 300,087$ | 5000 | 100 | 78,700$ | 78,700$ | 63,852$ | 0$ | 43,122$ | 0 | 0 | 284,293$ | 62 | 854$ | 57,218$ |
10 | ![]() | 3000 | 2000 | 5 | 2 | 59007 | 39344 | 98.35% | 98.36% | 17 | 4918 - 98.35% | 15,883$ | 317,662$ | 5000 | 100 | 155,400$ | 155,400$ | 102,456$ | 0$ | 81,735$ | 0 | 0 | 270,013$ | 62 | 1,406$ | 94,202$ |
11 | ![]() | 3000 | 2000 | 5 | 2 | 57479 | 39269 | 95.80% | 98.17% | 17 | 4837 - 96.75% | 15,552$ | 311,044$ | 5000 | 100 | 160,600$ | 160,600$ | 106,569$ | 0$ | 85,881$ | 0 | 0 | 264,387$ | 62 | 1,443$ | 96,681$ |
12 | ![]() | 3000 | 2000 | 5 | 2 | 58537 | 39061 | 97.56% | 97.65% | 17 | 4880 - 97.60% | 15,759$ | 315,184$ | 5000 | 100 | 53,250$ | 53,050$ | 53,729$ | 0$ | 33,023$ | 0 | 0 | 267,906$ | 62 | 671$ | 44,957$ |
13 | ![]() | 2000 | 1000 | 4 | 2 | 39257 | 19009 | 98.14% | 95.05% | 17 | 2913 - 97.11% | 8,289$ | 165,789$ | 3000 | 100 | 76,750$ | 76,750$ | 62,748$ | 0$ | 42,012$ | 0 | 0 | 140,921$ | 62 | 840$ | 56,280$ |
14 | ![]() | 3000 | 2000 | 5 | 2 | 55773 | 37416 | 97.85% | 98.46% | 18 | 4905 - 98.09% | 15,823$ | 300,642$ | 5000 | 100 | 146,600$ | 146,600$ | 97,350$ | 0$ | 76,683$ | 0 | 0 | 284,819$ | 62 | 1,342$ | 89,914$ |
15 | ![]() | 2000 | 1000 | 5 | 3 | 38945 | 11756 | 97.36% | 58.78% | 17 | 2535 - 84.50% | 9,775$ | 195,495$ | 3000 | 100 | 99,250$ | 99,250$ | 66,965$ | 0$ | 46,278$ | 0 | 0 | 166,171$ | 62 | 1,002$ | 67,134$ |
16 | ![]() | 2000 | 1000 | 5 | 1 | 39230 | 20000 | 98.08% | 100.00% | 17 | 2962 - 98.72% | 9,187$ | 183,730$ | 3000 | 100 | 143,600$ | 143,600$ | 95,058$ | 0$ | 74,322$ | 0 | 0 | 156,170$ | 62 | 1,321$ | 88,507$ |
17 | ![]() | 2000 | 1000 | 5 | 2 | 37031 | 18525 | 97.45% | 97.50% | 18 | 2924 - 97.47% | 9,941$ | 188,874$ | 3000 | 100 | 134,550$ | 134,550$ | 90,933$ | 0$ | 70,197$ | 0 | 0 | 178,933$ | 62 | 1,256$ | 84,152$ |
18 | ![]() | 3000 | 2000 | 5 | 2 | 58836 | 39179 | 98.06% | 97.95% | 17 | 4901 - 98.02% | 15,833$ | 316,658$ | 5000 | 100 | 133,200$ | 133,200$ | 88,836$ | 0$ | 68,109$ | 0 | 0 | 269,159$ | 62 | 1,246$ | 83,482$ |
19 | ![]() | 3000 | 2000 | 5 | 2 | 55434 | 36802 | 97.25% | 96.85% | 18 | 4855 - 97.09% | 15,692$ | 298,155$ | 5000 | 100 | 101,350$ | 101,350$ | 70,544$ | 0$ | 49,835$ | 0 | 0 | 282,463$ | 62 | 1,017$ | 68,139$ |
20 | ![]() | 2000 | 1000 | 5 | 2 | 37004 | 18190 | 97.38% | 95.74% | 18 | 2905 - 96.83% | 9,905$ | 188,190$ | 3000 | 100 | 61,150$ | 61,150$ | 53,724$ | 0$ | 32,988$ | 0 | 0 | 178,285$ | 62 | 728$ | 48,776$ |
21 | ![]() | 2000 | 1000 | 5 | 2 | 38796 | 19537 | 96.99% | 97.69% | 17 | 2917 - 97.22% | 9,905$ | 198,094$ | 3000 | 100 | 157,740$ | 157,740$ | 103,743$ | 0$ | 83,007$ | 0 | 0 | 168,380$ | 62 | 1,423$ | 95,341$ |
22 | ![]() | 2000 | 1000 | 8 | 5 | 21991 | 7593 | 54.98% | 37.97% | 17 | 1479 - 49.31% | 9,090$ | 181,809$ | 3000 | 100 | 177,550$ | 177,550$ | 107,144$ | 0$ | 86,423$ | 0 | 0 | 154,538$ | 62 | 1,565$ | 104,855$ |
23 | ![]() | 2000 | 1000 | 4 | 2 | 39573 | 19304 | 98.93% | 96.52% | 17 | 2944 - 98.13% | 8,368$ | 167,366$ | 3000 | 100 | 118,650$ | 118,650$ | 83,130$ | 0$ | 62,437$ | 0 | 0 | 142,261$ | 62 | 1,141$ | 76,447$ |
24 | ![]() | 2000 | 1000 | 15 | 5 | 11788 | 7302 | 31.02% | 38.43% | 18 | 1005 - 33.49% | 9,544$ | 181,330$ | 3000 | 100 | 151,650$ | 151,650$ | 97,857$ | 0$ | 77,126$ | 0 | 0 | 171,786$ | 62 | 1,379$ | 92,393$ |