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 | 49771 | 27880 | 88.88% | 99.57% | 14 | 2773 - 92.44% | 77,149$ | 2,160,185$ | 3000 | 100 | 2,686,950$ | 2,686,950$ | 2,523,792$ | 2,686,950$ | 1,755,129$ | 34 | 0 | 1,080,092$ | 54 | 25,248$ | 1,338,144$ |
2 | ![]() | 2000 | 1000 | 35 | 15 | 48582 | 27419 | 86.75% | 97.93% | 14 | 2714 - 90.48% | 75,416$ | 2,111,655$ | 3000 | 100 | 2,705,950$ | 2,705,950$ | 2,593,640$ | 2,705,950$ | 1,853,780$ | 32 | 0 | 1,055,828$ | 54 | 25,085$ | 1,329,505$ |
3 | ![]() | 3500 | 2500 | 32 | 15 | 95838 | 69041 | 97.79% | 98.63% | 14 | 5889 - 98.14% | 146,515$ | 4,102,431$ | 6000 | 100 | 2,564,900$ | 2,564,900$ | 2,669,835$ | 2,564,900$ | 1,649,535$ | 36 | 0 | 2,051,216$ | 54 | 26,967$ | 1,429,251$ |
4 | ![]() | 2000 | 1000 | 35 | 15 | 49434 | 27643 | 88.28% | 98.73% | 14 | 2753 - 91.76% | 76,601$ | 2,144,835$ | 3000 | 100 | 2,273,500$ | 2,273,500$ | 2,217,527$ | 2,273,500$ | 1,498,527$ | 34 | 0 | 1,072,418$ | 54 | 22,049$ | 1,168,597$ |
5 | ![]() | 2000 | 1000 | 35 | 15 | 49646 | 27646 | 88.65% | 98.74% | 14 | 2760 - 92.01% | 76,868$ | 2,152,300$ | 3000 | 100 | 2,647,800$ | 2,647,800$ | 2,618,093$ | 2,647,800$ | 1,768,418$ | 32 | 0 | 1,076,150$ | 54 | 25,803$ | 1,367,559$ |
6 | ![]() | 3000 | 2000 | 50 | 30 | 53955 | 31312 | 62.02% | 53.99% | 13 | 2940 - 58.80% | 125,418$ | 3,637,110$ | 5000 | 100 | 3,157,700$ | 3,157,700$ | 2,563,500$ | 3,157,700$ | 1,909,900$ | 37 | 0 | 1,630,429$ | 54 | 27,175$ | 1,440,275$ |
7 | ![]() | 2000 | 1000 | 35 | 25 | 50314 | 17958 | 89.85% | 64.14% | 14 | 2438 - 81.28% | 78,926$ | 2,209,940$ | 3000 | 100 | 3,286,664$ | 3,286,664$ | 3,029,982$ | 3,286,664$ | 1,891,172$ | 37 | 0 | 1,104,970$ | 54 | 32,870$ | 1,742,110$ |
8 | ![]() | 2000 | 1000 | 40 | 20 | 42016 | 21448 | 75.03% | 76.60% | 14 | 2267 - 75.55% | 75,343$ | 2,109,600$ | 3000 | 100 | 2,262,950$ | 2,262,950$ | 2,027,573$ | 2,262,950$ | 1,485,503$ | 32 | 0 | 1,054,800$ | 54 | 20,211$ | 1,071,183$ |
9 | ![]() | 2000 | 1000 | 35 | 15 | 49291 | 27621 | 88.02% | 98.65% | 14 | 2747 - 91.56% | 76,411$ | 2,139,500$ | 3000 | 100 | 2,465,500$ | 2,465,500$ | 2,326,226$ | 2,465,500$ | 1,671,996$ | 33 | 0 | 1,069,750$ | 54 | 22,657$ | 1,200,821$ |
10 | ![]() | 2000 | 1000 | 35 | 15 | 48501 | 27443 | 86.61% | 98.01% | 14 | 2712 - 90.41% | 75,328$ | 2,109,180$ | 3000 | 100 | 2,389,500$ | 2,389,500$ | 2,442,450$ | 2,389,500$ | 1,591,480$ | 32 | 0 | 1,054,590$ | 54 | 24,127$ | 1,278,731$ |
11 | ![]() | 2000 | 1000 | 45 | 22 | 41162 | 21162 | 76.23% | 78.38% | 15 | 2308 - 76.94% | 78,252$ | 2,112,802$ | 3000 | 100 | 2,972,925$ | 2,972,925$ | 2,446,253$ | 2,972,925$ | 1,923,385$ | 35 | 0 | 1,173,779$ | 54 | 24,660$ | 1,306,980$ |
12 | ![]() | 2000 | 1000 | 35 | 15 | 49438 | 27468 | 88.28% | 98.10% | 14 | 2747 - 91.55% | 76,513$ | 2,142,350$ | 3000 | 100 | 2,520,300$ | 2,520,300$ | 2,172,402$ | 2,520,300$ | 1,649,532$ | 35 | 0 | 1,071,175$ | 54 | 21,701$ | 1,150,153$ |
13 | ![]() | 3500 | 2500 | 37 | 16 | 78142 | 69138 | 79.74% | 98.77% | 14 | 5260 - 87.67% | 142,767$ | 3,997,462$ | 6000 | 100 | 2,297,850$ | 2,297,850$ | 2,534,896$ | 2,297,850$ | 1,492,455$ | 33 | 0 | 1,998,731$ | 54 | 25,443$ | 1,348,479$ |
14 | ![]() | 2000 | 1000 | 35 | 15 | 49464 | 27782 | 88.33% | 99.22% | 14 | 2759 - 91.96% | 76,713$ | 2,147,970$ | 3000 | 100 | 3,028,975$ | 3,028,975$ | 2,810,710$ | 3,028,975$ | 2,026,410$ | 44 | 0 | 1,073,985$ | 54 | 27,640$ | 1,464,920$ |
15 | ![]() | 2000 | 1000 | 25 | 15 | 56000 | 27868 | 100.00% | 99.53% | 14 | 2995 - 99.84% | 64,929$ | 1,818,020$ | 3000 | 100 | 3,100,250$ | 3,100,250$ | 2,797,056$ | 3,100,250$ | 2,045,440$ | 37 | 0 | 909,010$ | 54 | 27,779$ | 1,472,287$ |
16 | ![]() | 3500 | 2500 | 35 | 25 | 80801 | 41247 | 82.45% | 58.92% | 14 | 4359 - 72.65% | 143,611$ | 4,021,115$ | 6000 | 100 | 2,430,388$ | 2,430,388$ | 2,735,808$ | 2,430,388$ | 1,593,994$ | 35 | 0 | 2,010,558$ | 54 | 27,303$ | 1,447,059$ |
17 | ![]() | 2000 | 1000 | 15 | 10 | 56000 | 28000 | 100.00% | 100.00% | 14 | 3000 - 100.00% | 40,000$ | 1,120,000$ | 3000 | 100 | 3,314,920$ | 3,314,920$ | 2,557,472$ | 3,314,920$ | 1,969,250$ | 32 | 0 | 560,000$ | 54 | 27,548$ | 1,460,044$ |
18 | ![]() | 2000 | 1000 | 30 | 15 | 50356 | 23637 | 89.92% | 84.42% | 14 | 2643 - 88.09% | 74,453$ | 2,084,684$ | 3000 | 100 | 2,927,727$ | 2,927,727$ | 2,850,458$ | 2,927,727$ | 1,928,231$ | 32 | 0 | 1,042,342$ | 54 | 28,358$ | 1,502,974$ |
19 | ![]() | 3000 | 2000 | 50 | 30 | 51117 | 30280 | 60.85% | 54.07% | 14 | 2907 - 58.14% | 123,723$ | 3,464,250$ | 5000 | 100 | 2,245,400$ | 2,245,400$ | 2,050,751$ | 2,245,400$ | 1,397,151$ | 33 | 0 | 1,732,125$ | 54 | 21,212$ | 1,124,236$ |
20 | ![]() | 2000 | 1000 | 35 | 15 | 48164 | 27337 | 86.01% | 97.63% | 14 | 2696 - 89.88% | 74,850$ | 2,095,795$ | 3000 | 100 | 2,673,200$ | 2,673,200$ | 2,339,382$ | 2,673,200$ | 1,718,482$ | 40 | 0 | 1,047,898$ | 54 | 23,681$ | 1,255,093$ |
21 | ![]() | 2000 | 1000 | 25 | 20 | 55618 | 21304 | 99.32% | 76.09% | 14 | 2747 - 91.57% | 64,876$ | 1,816,530$ | 3000 | 100 | 2,318,930$ | 2,318,930$ | 2,428,547$ | 2,318,930$ | 1,644,230$ | 29 | 0 | 908,265$ | 54 | 23,000$ | 1,219,000$ |
22 | ![]() | 2000 | 1000 | 35 | 15 | 50089 | 27651 | 89.44% | 98.75% | 14 | 2776 - 92.55% | 77,424$ | 2,167,880$ | 3000 | 100 | 2,481,900$ | 2,481,900$ | 2,147,640$ | 2,481,900$ | 1,578,995$ | 33 | 0 | 1,083,940$ | 54 | 21,908$ | 1,161,124$ |