| 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 Total Estimate | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Arena Capacity | Team Popularity | Players Total Salaries | Players Total Average Salaries | Special Salary Cap Value | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Luxury Taxe Total | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses | Estimated Season Expenses | Estimated Season Salary Cap | Over Minimum Salary Cap of 13,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | BANGOR BEAGLES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 26469 | 25000 | 10000 | 20000 | 5000 | 88.23% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 17294 - 96.08% | 1,199,380$ | 5,996,900$ | 18000 | 100 | 25,442,504$ | 1,040,000$ | 0$ | 3,155,404$ | 25,442,504$ | 3,024,640$ | 22 | 1 | 60,316$ | 44,377,060$ | 126 | 185,612$ | 23,387,112$ | 26,453,948$ | 27,760,738$ | 14,760,738$ | 38,000,000$ | 10,239,262$ | 288,827,386$ | 309,435,588$ |
| 2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 24796 | 24911 | 10000 | 19972 | 5000 | 82.65% | 99.64% | 100.00% | 99.86% | 100.00% | 37 | 16936 - 94.09% | 1,164,712$ | 5,823,560$ | 18000 | 100 | 29,770,086$ | 2,390,000$ | 0$ | 3,655,539$ | 29,770,086$ | 3,536,658$ | 24 | 0 | 70,562$ | 43,094,344$ | 126 | 215,175$ | 27,112,050$ | 29,584,502$ | 31,757,711$ | 18,757,711$ | 38,000,000$ | 6,242,289$ | 277,285,051$ | 293,554,464$ |
| 3 | CALGARY COWBOYS | 7000 | 6000 | 3000 | 4000 | 2000 | 90 | 65 | 33 | 25 | 225 | 33549 | 22438 | 13203 | 20000 | 4794 | 95.85% | 74.79% | 88.02% | 100.00% | 47.94% | 37 | 18797 - 85.44% | 1,298,446$ | 6,492,229$ | 22000 | 100 | 29,414,168$ | 720,000$ | 0$ | 3,682,370$ | 29,414,168$ | 3,496,781$ | 25 | 0 | 69,768$ | 48,042,495$ | 126 | 216,610$ | 27,292,860$ | 30,394,222$ | 31,528,668$ | 18,528,668$ | 38,000,000$ | 6,471,332$ | 276,411,591$ | 298,594,947$ |
| 4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 20506 | 20000 | 8000 | 16000 | 3974 | 85.44% | 100.00% | 100.00% | 100.00% | 99.35% | 38 | 17120 - 95.11% | 1,181,350$ | 4,725,400$ | 18000 | 100 | 28,258,423$ | 680,000$ | 0$ | 3,658,067$ | 28,258,423$ | 3,288,587$ | 24 | 0 | 65,604$ | 44,891,300$ | 126 | 219,346$ | 27,637,596$ | 30,243,272$ | 29,961,173$ | 16,961,173$ | 38,000,000$ | 8,038,827$ | 316,078,814$ | 333,423,772$ |
| 5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 26326 | 24934 | 10000 | 20000 | 4996 | 87.75% | 99.74% | 100.00% | 100.00% | 99.92% | 37 | 17251 - 95.84% | 1,195,568$ | 5,977,840$ | 18000 | 100 | 27,889,366$ | 1,504,000$ | 0$ | 3,410,625$ | 27,889,366$ | 3,315,527$ | 22 | 0 | 66,147$ | 44,236,016$ | 126 | 200,625$ | 25,278,750$ | 28,508,212$ | 30,268,866$ | 17,268,866$ | 38,000,000$ | 7,731,134$ | 314,285,616$ | 332,821,720$ |
| 6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 26437 | 21392 | 11990 | 22160 | 6535 | 75.53% | 71.31% | 79.93% | 88.64% | 65.35% | 37 | 17703 - 76.97% | 1,285,833$ | 6,429,165$ | 23000 | 100 | 23,905,200$ | 880,000$ | 0$ | 3,076,660$ | 23,905,200$ | 2,841,873$ | 26 | 0 | 56,661$ | 47,575,821$ | 126 | 180,980$ | 22,803,480$ | 25,607,772$ | 26,100,200$ | 13,100,200$ | 38,000,000$ | 11,899,800$ | 278,390,042$ | 304,682,206$ |
| 7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 50 | 30 | 250 | 24246 | 20475 | 8091 | 19850 | 4387 | 80.82% | 81.90% | 80.91% | 99.25% | 87.74% | 37 | 15410 - 85.61% | 1,190,930$ | 5,954,650$ | 18000 | 100 | 24,807,297$ | 680,000$ | 421,850$ | 3,171,883$ | 24,807,297$ | 3,037,311$ | 20 | 0 | 60,575$ | 44,064,410$ | 126 | 181,394$ | 22,855,644$ | 26,184,658$ | 27,426,971$ | 14,426,971$ | 38,000,000$ | 10,573,029$ | 338,418,875$ | 359,037,515$ |
| 8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 26198 | 22586 | 10000 | 20000 | 4873 | 87.33% | 90.34% | 100.00% | 100.00% | 97.46% | 37 | 16731 - 92.95% | 1,236,863$ | 6,184,315$ | 18000 | 100 | 28,025,672$ | 840,000$ | 0$ | 3,542,528$ | 28,025,672$ | 3,331,728$ | 22 | 0 | 66,470$ | 45,763,931$ | 126 | 208,384$ | 26,256,384$ | 29,119,846$ | 29,788,172$ | 16,788,172$ | 38,000,000$ | 8,211,828$ | 273,379,065$ | 292,647,190$ |
| 9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 21059 | 20000 | 8000 | 16000 | 3998 | 87.75% | 100.00% | 100.00% | 100.00% | 99.95% | 38 | 17264 - 95.91% | 1,196,375$ | 4,785,500$ | 18000 | 100 | 29,162,219$ | 760,000$ | 0$ | 3,649,167$ | 29,162,219$ | 3,464,394$ | 20 | 0 | 69,117$ | 45,462,250$ | 126 | 214,801$ | 27,064,926$ | 29,944,736$ | 31,442,354$ | 18,442,354$ | 38,000,000$ | 6,557,646$ | 110,105,127$ | 128,276,910$ |
| 10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 26086 | 24987 | 10000 | 19839 | 4969 | 86.95% | 99.95% | 100.00% | 99.20% | 99.38% | 37 | 17176 - 95.42% | 1,189,519$ | 5,947,595$ | 18000 | 100 | 26,105,772$ | 640,000$ | 0$ | 3,151,337$ | 26,105,772$ | 3,015,575$ | 23 | 0 | 60,141$ | 44,012,203$ | 126 | 190,544$ | 24,008,544$ | 26,938,496$ | 28,326,522$ | 15,326,522$ | 38,000,000$ | 9,673,478$ | 320,975,304$ | 340,839,440$ |
| 11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 88 | 62 | 37 | 20 | 193 | 30743 | 26000 | 11000 | 21000 | 6000 | 99.17% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18949 - 99.73% | 1,260,477$ | 6,302,384$ | 19000 | 100 | 26,753,187$ | 1,554,000$ | 0$ | 3,418,533$ | 26,753,187$ | 3,299,652$ | 20 | 1 | 65,824$ | 46,637,642$ | 126 | 194,078$ | 24,453,828$ | 27,517,736$ | 28,994,647$ | 15,994,647$ | 38,000,000$ | 9,005,353$ | 338,098,771$ | 359,360,252$ |
| 12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 21047 | 22640 | 9948 | 18061 | 4330 | 75.17% | 94.33% | 82.90% | 90.31% | 54.13% | 38 | 19007 - 82.64% | 1,282,201$ | 5,128,805$ | 23000 | 100 | 31,809,093$ | 840,000$ | 0$ | 3,921,434$ | 31,809,093$ | 3,720,035$ | 24 | 0 | 74,226$ | 48,723,648$ | 126 | 234,504$ | 29,547,504$ | 32,741,464$ | 34,348,127$ | 21,348,127$ | 38,000,000$ | 3,651,873$ | 320,958,141$ | 339,688,865$ |
| 13 | LAS CRUCES SPURS | 7000 | 6000 | 3000 | 4000 | 2000 | 102 | 63 | 35 | 27 | 240 | 25622 | 26610 | 11987 | 20000 | 4566 | 73.21% | 88.70% | 79.91% | 100.00% | 45.66% | 37 | 17757 - 80.71% | 1,269,052$ | 6,345,259$ | 22000 | 100 | 29,051,822$ | 800,000$ | 0$ | 3,454,408$ | 29,051,822$ | 3,394,976$ | 25 | 1 | 67,725$ | 46,954,917$ | 126 | 206,656$ | 26,038,656$ | 28,707,406$ | 30,992,422$ | 17,992,422$ | 38,000,000$ | 7,007,578$ | 316,904,731$ | 339,565,225$ |
| 14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 26442 | 25000 | 10000 | 20000 | 5000 | 88.14% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 17288 - 96.05% | 1,198,840$ | 5,994,200$ | 18000 | 100 | 29,402,075$ | 720,000$ | 0$ | 3,710,284$ | 29,402,075$ | 3,495,353$ | 25 | 0 | 69,734$ | 44,357,080$ | 126 | 218,252$ | 27,499,752$ | 30,833,036$ | 31,788,875$ | 18,788,875$ | 38,000,000$ | 6,211,125$ | 273,741,962$ | 289,938,109$ |
| 15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 29944 | 20170 | 8986 | 20000 | 5000 | 99.81% | 80.68% | 89.86% | 100.00% | 100.00% | 37 | 16820 - 93.44% | 1,172,246$ | 5,861,230$ | 18000 | 100 | 28,866,491$ | 720,000$ | 0$ | 3,625,870$ | 28,866,491$ | 3,453,504$ | 20 | 0 | 68,897$ | 43,373,102$ | 126 | 212,003$ | 26,712,378$ | 29,291,946$ | 30,955,491$ | 17,955,491$ | 38,000,000$ | 7,044,509$ | 188,260,098$ | 204,786,602$ |
| 16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 100 | 60 | 30 | 28 | 200 | 26553 | 26859 | 12966 | 22825 | 5604 | 70.81% | 82.64% | 47.15% | 91.30% | 74.72% | 37 | 18961 - 72.93% | 1,283,144$ | 6,415,720$ | 26000 | 100 | 25,153,551$ | 2,579,750$ | 0$ | 3,103,179$ | 25,153,551$ | 2,989,058$ | 20 | 0 | 59,608$ | 47,476,328$ | 126 | 182,612$ | 23,009,112$ | 26,617,750$ | 27,518,051$ | 14,518,051$ | 38,000,000$ | 10,481,949$ | 264,384,016$ | 290,170,934$ |
| 17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 100 | 75 | 70 | 150 | 29735 | 18471 | 5988 | 8414 | 5000 | 99.12% | 73.88% | 59.88% | 42.07% | 100.00% | 37 | 13522 - 75.12% | 1,158,647$ | 5,793,235$ | 18000 | 100 | 28,547,456$ | 520,000$ | 0$ | 3,370,836$ | 28,547,456$ | 3,264,128$ | 22 | 0 | 65,114$ | 42,869,939$ | 126 | 205,909$ | 25,944,534$ | 28,952,078$ | 30,724,131$ | 17,724,131$ | 38,000,000$ | 7,275,869$ | 252,233,633$ | 267,076,494$ |
| 18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 59 | 38 | 29 | 193 | 29930 | 24937 | 10000 | 20000 | 5000 | 99.77% | 99.75% | 100.00% | 100.00% | 100.00% | 37 | 17973 - 99.85% | 1,217,997$ | 6,089,983$ | 18000 | 100 | 26,862,313$ | 640,000$ | 0$ | 3,012,944$ | 26,862,313$ | 2,793,491$ | 26 | 0 | 55,700$ | 45,065,874$ | 126 | 200,757$ | 25,295,382$ | 27,608,746$ | 28,825,027$ | 15,825,027$ | 38,000,000$ | 9,174,973$ | 242,886,993$ | 263,046,638$ |
| 19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 26199 | 20306 | 12626 | 21845 | 6664 | 74.85% | 67.69% | 84.17% | 87.38% | 66.64% | 37 | 17528 - 76.21% | 1,273,582$ | 6,367,910$ | 23000 | 100 | 22,934,239$ | 800,000$ | 0$ | 2,858,332$ | 22,934,239$ | 2,739,451$ | 24 | 0 | 54,624$ | 47,122,534$ | 126 | 167,372$ | 21,088,872$ | 24,527,076$ | 25,091,589$ | 12,091,589$ | 38,000,000$ | 12,908,411$ | 232,306,636$ | 259,210,522$ |
| 20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 27129 | 26647 | 12147 | 22858 | 5344 | 77.51% | 88.82% | 80.98% | 91.43% | 53.44% | 37 | 18825 - 81.85% | 1,275,423$ | 6,377,115$ | 23000 | 100 | 30,984,680$ | 760,000$ | 0$ | 3,939,920$ | 30,984,680$ | 3,683,492$ | 24 | 0 | 73,508$ | 47,190,651$ | 126 | 231,760$ | 29,201,760$ | 31,986,166$ | 33,373,135$ | 20,373,135$ | 38,000,000$ | 4,626,865$ | 339,192,613$ | 357,146,636$ |
| 21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 90 | 85 | 80 | 165 | 29973 | 16588 | 5292 | 8026 | 5000 | 99.91% | 66.35% | 52.92% | 40.13% | 100.00% | 37 | 12976 - 72.09% | 1,251,451$ | 6,257,255$ | 18000 | 100 | 26,621,947$ | 1,650,000$ | 0$ | 3,370,439$ | 26,621,947$ | 3,227,780$ | 21 | 0 | 64,382$ | 46,303,687$ | 126 | 194,559$ | 24,514,434$ | 27,116,450$ | 28,716,541$ | 15,716,541$ | 38,000,000$ | 9,283,459$ | 241,117,519$ | 262,409,027$ |
| 22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 26709 | 24886 | 10000 | 20000 | 5000 | 89.03% | 99.54% | 100.00% | 100.00% | 100.00% | 37 | 17319 - 96.22% | 1,202,812$ | 6,014,060$ | 18000 | 100 | 27,254,182$ | 880,000$ | 0$ | 3,336,155$ | 27,254,182$ | 3,247,005$ | 23 | 0 | 64,774$ | 44,504,044$ | 126 | 195,833$ | 24,674,958$ | 26,988,566$ | 29,320,182$ | 16,320,182$ | 38,000,000$ | 8,679,818$ | 111,126,375$ | 131,334,898$ |