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 Salaries Cap | 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 | ![]() | 2000 | 1000 | 35 | 15 | 12435 | 6037 | 77.72% | 75.46% | 31 | 2309 - 76.97% | 65,723$ | 525,780$ | 3000 | 100 | 1,787,500$ | 0$ | 344,064$ | 0$ | 344,064$ | 0 | 0 | 2,037,398$ | 147 | 9,876$ | 1,451,772$ |
2 | ![]() | 2000 | 1000 | 35 | 15 | 10626 | 5282 | 75.90% | 75.46% | 32 | 2273 - 75.75% | 64,449$ | 451,140$ | 3000 | 100 | 1,979,000$ | 0$ | 384,574$ | 0$ | 384,574$ | 0 | 0 | 2,062,354$ | 147 | 10,934$ | 1,607,298$ |
3 | ![]() | 2000 | 1000 | 36 | 15 | 11968 | 5954 | 74.80% | 74.43% | 31 | 2240 - 74.68% | 65,303$ | 522,423$ | 3000 | 100 | 2,717,100$ | 0$ | 510,408$ | 0$ | 510,408$ | 0 | 0 | 2,024,389$ | 147 | 15,012$ | 2,206,764$ |
4 | ![]() | 2250 | 1250 | 35 | 16 | 13835 | 7075 | 76.86% | 70.75% | 31 | 2614 - 74.68% | 74,678$ | 597,425$ | 3500 | 100 | 1,685,500$ | 0$ | 316,608$ | 0$ | 316,608$ | 0 | 0 | 2,315,022$ | 147 | 9,312$ | 1,368,864$ |
5 | ![]() | 2000 | 1000 | 35 | 16 | 11894 | 5589 | 74.34% | 69.86% | 31 | 2185 - 72.85% | 63,517$ | 508,138$ | 3000 | 100 | 1,951,500$ | 0$ | 377,180$ | 0$ | 377,180$ | 0 | 0 | 1,969,035$ | 147 | 10,782$ | 1,584,954$ |
6 | ![]() | 2000 | 1000 | 31 | 11 | 15507 | 7822 | 96.92% | 97.78% | 31 | 2916 - 97.20% | 69,026$ | 552,206$ | 3000 | 100 | 2,464,000$ | 0$ | 465,170$ | 0$ | 465,170$ | 0 | 0 | 2,139,798$ | 147 | 13,613$ | 2,001,111$ |
7 | ![]() | 2000 | 1000 | 35 | 15 | 10523 | 5215 | 75.16% | 74.50% | 32 | 2248 - 74.94% | 63,790$ | 446,530$ | 3000 | 100 | 1,866,000$ | 0$ | 350,506$ | 0$ | 350,506$ | 0 | 0 | 2,041,280$ | 147 | 10,309$ | 1,515,423$ |
8 | ![]() | 2000 | 1000 | 35 | 15 | 12242 | 5910 | 76.51% | 73.88% | 31 | 2269 - 75.63% | 64,640$ | 517,120$ | 3000 | 100 | 3,375,900$ | 0$ | 632,976$ | 0$ | 632,976$ | 0 | 0 | 2,003,840$ | 147 | 18,651$ | 2,741,697$ |
9 | ![]() | 2000 | 1000 | 35 | 15 | 13690 | 6704 | 76.06% | 74.49% | 30 | 2266 - 75.53% | 64,412$ | 579,710$ | 3000 | 100 | 1,224,800$ | 0$ | 231,182$ | 0$ | 231,182$ | 0 | 0 | 1,932,367$ | 147 | 6,767$ | 994,749$ |
10 | ![]() | 2000 | 1000 | 35 | 15 | 12405 | 6081 | 77.53% | 76.01% | 31 | 2311 - 77.03% | 65,674$ | 525,390$ | 3000 | 100 | 1,717,505$ | 0$ | 302,974$ | 0$ | 302,974$ | 0 | 0 | 2,035,886$ | 147 | 9,489$ | 1,394,883$ |
11 | ![]() | 2000 | 1000 | 35 | 15 | 12368 | 5861 | 77.30% | 73.26% | 31 | 2279 - 75.95% | 65,099$ | 520,795$ | 3000 | 100 | 1,535,000$ | 0$ | 288,354$ | 0$ | 288,354$ | 0 | 0 | 2,018,081$ | 147 | 8,481$ | 1,246,707$ |
12 | ![]() | 2000 | 1000 | 35 | 15 | 12270 | 6010 | 76.69% | 75.13% | 31 | 2285 - 76.17% | 64,950$ | 519,600$ | 3000 | 100 | 1,361,556$ | 0$ | 251,884$ | 0$ | 251,884$ | 0 | 0 | 2,013,450$ | 147 | 7,522$ | 1,105,734$ |
13 | ![]() | 2000 | 1000 | 35 | 15 | 12596 | 6000 | 78.73% | 75.00% | 31 | 2325 - 77.48% | 66,358$ | 530,860$ | 3000 | 100 | 1,554,200$ | 0$ | 274,815$ | 0$ | 274,815$ | 0 | 0 | 2,057,082$ | 147 | 8,587$ | 1,262,289$ |
14 | ![]() | 2000 | 1000 | 35 | 15 | 12215 | 5761 | 76.34% | 72.01% | 31 | 2247 - 74.90% | 64,243$ | 513,940$ | 3000 | 100 | 1,507,096$ | 0$ | 288,109$ | 0$ | 288,109$ | 0 | 0 | 1,991,518$ | 147 | 8,326$ | 1,223,922$ |
15 | ![]() | 2000 | 1000 | 35 | 15 | 12378 | 5895 | 77.36% | 73.69% | 31 | 2284 - 76.14% | 65,207$ | 521,655$ | 3000 | 100 | 2,568,700$ | 0$ | 509,852$ | 0$ | 509,852$ | 0 | 0 | 2,021,413$ | 147 | 14,192$ | 2,086,224$ |
16 | ![]() | 2000 | 1000 | 31 | 10 | 13540 | 6591 | 96.71% | 94.16% | 32 | 2876 - 95.86% | 69,948$ | 489,636$ | 3000 | 100 | 3,402,217$ | 0$ | 635,079$ | 0$ | 635,079$ | 0 | 0 | 2,238,336$ | 147 | 18,797$ | 2,763,159$ |
17 | ![]() | 2000 | 1000 | 35 | 14 | 12021 | 6330 | 85.86% | 90.43% | 32 | 2622 - 87.39% | 71,954$ | 503,675$ | 3000 | 100 | 1,743,500$ | 0$ | 326,370$ | 0$ | 326,370$ | 0 | 0 | 2,302,514$ | 147 | 9,633$ | 1,416,051$ |
18 | ![]() | 2000 | 1000 | 34 | 14 | 13658 | 6716 | 75.88% | 74.62% | 30 | 2264 - 75.46% | 67,655$ | 608,896$ | 3000 | 100 | 3,541,143$ | 0$ | 651,978$ | 0$ | 651,978$ | 0 | 0 | 2,029,653$ | 147 | 19,564$ | 2,875,908$ |
19 | ![]() | 2000 | 1000 | 35 | 15 | 14036 | 6841 | 77.98% | 76.01% | 30 | 2320 - 77.32% | 65,986$ | 593,875$ | 3000 | 100 | 1,696,500$ | 0$ | 318,682$ | 0$ | 318,682$ | 0 | 0 | 1,979,583$ | 147 | 9,373$ | 1,377,831$ |
20 | ![]() | 2000 | 1000 | 35 | 15 | 12408 | 6030 | 77.55% | 75.38% | 31 | 2305 - 76.83% | 65,591$ | 524,730$ | 3000 | 100 | 2,621,000$ | 0$ | 492,354$ | 0$ | 492,354$ | 0 | 0 | 2,033,329$ | 147 | 14,481$ | 2,128,707$ |
21 | ![]() | 2000 | 1000 | 35 | 15 | 12278 | 6142 | 76.74% | 76.78% | 31 | 2303 - 76.75% | 65,233$ | 521,860$ | 3000 | 100 | 1,300,900$ | 0$ | 287,053$ | 0$ | 287,053$ | 0 | 0 | 2,022,208$ | 147 | 7,187$ | 1,056,489$ |
22 | ![]() | 2000 | 1000 | 32 | 13 | 15141 | 7269 | 94.63% | 90.86% | 31 | 2801 - 93.38% | 72,376$ | 579,009$ | 3000 | 100 | 1,995,900$ | 0$ | 368,950$ | 0$ | 368,950$ | 0 | 0 | 2,243,660$ | 147 | 11,027$ | 1,620,969$ |
23 | ![]() | 2000 | 1000 | 35 | 15 | 12588 | 6036 | 78.68% | 75.45% | 31 | 2328 - 77.60% | 66,390$ | 531,120$ | 3000 | 100 | 1,558,930$ | 0$ | 292,842$ | 0$ | 292,842$ | 0 | 0 | 2,058,090$ | 147 | 8,613$ | 1,266,111$ |
24 | ![]() | 2000 | 1000 | 35 | 15 | 13866 | 6648 | 77.03% | 73.87% | 30 | 2279 - 75.98% | 65,003$ | 585,030$ | 3000 | 100 | 2,179,900$ | 0$ | 409,496$ | 0$ | 409,496$ | 0 | 0 | 1,950,100$ | 147 | 12,044$ | 1,770,468$ |