tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__906__BR New York Ticker 10_01
Sheet: ZONE J POSITIONS

Day | DATE | BID | OFFER | MID | SETTLE | CHG | H/R | POSITION | AVG PRICE | CRV SHT | DAILY SETTLE |  | D/A | R/T | DIFF
 |  |  |  |  |  |  |  |  |  |  |  | HE |  |  | DA-RT
 |  |  |  |  |  |  |  |  |  |  |  | 8
 | 2001-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  | As of |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 32 |  | 33 |  | 34 |  | 35 |  | 36 |  | 37 |  | 38 |  | 39 |  | 40 |  | Net | Average
 |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  | Prior Positions | [NAME] |  | Date | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Date
mon |  |  |  |  | 0 |  |  |  |  |  |  | 12
tues |  |  |  |  | 0 |  |  |  |  |  |  | 13
wed |  |  |  |  | 0 |  |  |  |  |  |  | 14
thurs |  |  |  |  | 0 |  |  |  |  |  |  | 15
fri |  |  |  |  | 0 |  |  |  |  |  |  | 16
mon |  |  |  |  | 0 |  |  |  |  |  |  | 17
tues |  |  |  |  | 0 |  |  |  |  |  |  | 18
wed |  |  |  |  | 0 |  |  |  |  |  |  | 19
thurs |  |  |  |  | 0 |  |  |  |  |  |  | 20 |  |  |  |  | 0
fri |  |  |  |  | 0 |  |  |  |  |  |  | 21 |  |  |  |  | 0
mon |  |  |  |  | 0 |  |  |  |  |  |  | 22 |  |  |  |  | 0
tues |  |  |  |  | 0 |  |  |  |  |  |  | 23
wed |  |  |  |  | 0 |  |  |  |  |  | DAILY SETTLE |  |  |  |  |  | 0
thurs |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
fri |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
mon |  |  |  |  | 0 |  |  |  |  |  |  |  | SETTLE | OFF-PK | ON PEAK |  | 0
tues |  |  |  |  | 0 |  |  |  |  |  |  | SAT |  | 0 | 200 |  | 0
wed |  |  |  |  | 37 |  |  |  |  |  |  | SUN |  | 0 | 200 |  | 0
thurs |  |  |  |  | 37 |  |  |  |  |  |  | MON |  | 0 | 200 |  | 0
fri |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 36.5
 |  |  |  |  |  |  |  |  |  |  |  | RTC CAL | Bid | OFFER |  |  |  |  |  |  | 50 | 36.5
TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  | 1X8 | 14 | 14.5 |  |  |  |  |  |  | 50 | 36.5
 |  |  |  |  |  |  |  |  |  |  |  | 1X16 | 23 | 22.75 |  |  |  |  |  | 2001-09-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-09-30 00:00:00
 |  |  |  |  |  | TOTAL | CURVE | SHIFT
Spreadsheet: 134765d1325622424-pivot-table-to-show-certain-column-in-descending-order-pivot-table-data
Sheet: Pivot Table

 | Sum of Cost | Month
 | Incident Location | 2011-04-01 00:00:00 | Grand Total
 | BOPEEP JN SB | 599.59 | 599.59
 | COTTAM POWER STN DSG PLT (GBRF) | 211.62 | 211.62
 | FELIXSTOWE NORTH DOCKS | 1058.1 | 1058.1
 | IMMINGHAM HIT COAL LOAD FAC | 811.21 | 811.21
 | PETERBOROUGH WEST YARD | 917.02 | 917.02
 | STOKE JN. | 317.43 | 317.43
 | WILLESDEN T.M.D | 1587.15 | 1587.15
 | WILLESDEN WEST LONDN JN | 105.81 | 105.81
 | Grand Total | 5607.93 | 5607.93
Spreadsheet: 685546d1594063976-sum-amounts-column-d-by-department-column-a-sample-3-
Sheet: Pivot

Sum of Amount | Column Labels
Row Labels | Jan | Feb | Grand Total
INS | 561.8 | 561.8 | 1123.6
LAB | 760 | 760 | 1520
PART | 4453.139999999999 | 4453.139999999999 | 8906.279999999997
RENT | 24.86 | 24.86 | 49.72
TOOL | 29.94 | 29.94 | 59.88
TRASH | 45 | 45 | 90
VEH | 524.3 | 524.3 | 1048.6
Grand Total | 6399.039999999998 | 6399.039999999998 | 12798.08
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0109

 | Date: | 2013-01-09 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 11 | 49.35
 | 11:00:00 | 69 | 349.03
 | 12:00:00 | 91 | 515.19
 | 13:00:00 | 70 | 358.31
 | 14:00:00 | 37 | 200.16
 | 15:00:00 | 41 | 194.96
 | 16:00:00 | 59 | 327.84
 | 17:00:00 | 69 | 504.87
 | 18:00:00 | 51 | 422.59
 | 19:00:00 | 33 | 218.41
 | 20:00:00 | 26 | 195.76
 | 21:00:00 | 34 | 225.25
 | 22:00:00 | 27 | 158.25
 | 23:00:00 | 22 | 165.94
 | 1900-01-01 00:00:00 | 8 | 34.95
 | 1900-01-01 01:00:00 | 1 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 9d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | 834261 | 1010064 | 775062 | 2203320 | 1483570 | 554153 | 223575 | 7084005
FRA | 15424336 | 8981165 | 5039965 | 4251468 | 63995 |  |  | 33760929
IRS- [NAME] | 6629053 | 5670896 | 5505723 | 20998922 | 34006552 | 27620102 | 13567985 | 113999233
OIS | 8950620 | 4139753 | 2544091 | 4888675 | 45893 |  |  | 20569032
VNS | 420 | <100 |  | 272 | 597 | 1047 | 1410 | 3746
Zero Coupon | 56244 | 23627 | 26275 | 44243 | 30657 | 7305 | 33938 | 222289
TOTAL | 31894933 | 19825504 | 13891116 | 32386900 | 35631263 | 28182606 | 13826907 | 175639229
Estimated gross notional amount outstanding, January 11 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 91483d1291214182-sort-filter-lookup-problem-kryt0n-ef755112-sdg12
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
1 | Fridge | 654 |  |  | 1 | Bed | 458 |  |  | Bed | 458 | 645 | 0 | 546 | 0 | 0
1 | Fridge | 235 |  |  | 1 | Fridge | 889 |  |  | Fridge | 889 | 779 | 0 | 1199 | 0 | 1198
1 | Bed | 458 |  |  | 1 | Shoes | 889 |  |  | Shoes | 889 | 465 | 156 | 0 | 1020 | 0
1 | Shoes | 654 |  |  | 1 | Skirt | 736 |  |  | Skirt | 736 | 0 | 1002 | 0 | 546 | 458
1 | Shoes | 235 |  |  | 2 | Bed | 645
1 | Skirt | 489 |  |  | 2 | Fridge | 779 |  |  |  |  |  |  |  |  |  | 10986
1 | Skirt | 247 |  |  | 2 | Shoes | 465
2 | Fridge | 521 |  |  | 3 | Shoes | 156
2 | Fridge | 258 |  |  | 3 | Skirt | 1002
2 | Bed | 645 |  |  | 4 | Bed | 546
2 | Shoes | 465 |  |  | 4 | Fridge | 1199
3 | Shoes | 156 |  |  | 5 | Shoes | 1020
3 | Skirt | 456 |  |  | 5 | Skirt | 546
3 | Skirt | 546 |  |  | 6 | Fridge | 1198
4 | Fridge | 554 |  |  | 6 | Skirt | 458
4 | Fridge | 645
4 | Bed | 546 |  |  |  |  | 10986
5 | Shoes | 123
5 | Shoes | 897
5 | Skirt | 546
6 | Skirt | 458
6 | Fridge | 984
6 | Fridge | 214
 |  |  |  |  |  |  |  |  |  |  |  |  | Today, 08:45 AM
 |  | 10986 |  |  |  |  |  |  |  |  |  |  | kryt0n - EF755112 - SDG12.xls
 |  |  |  |  |  |  |  |  |  |  |  |  | Forum Contributor   Join Date: 08 Apr 2009
 |  |  |  |  |  |  |  |  |  |  |  |  | Location: Bristol, UK
 |  |  |  |  |  |  |  |  |  |  |  |  | MS Office Version:Excel 2003
 |  |  |  |  |  |  |  |  |  |  |  |  | Posts: 131
 |  |  |  |  |  |  |  |  |  |  |  |  | sort/filter/lookup problem
 |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/755112-sort-filter-lookup-problem.html
 |  |  |  |  |  |  |  |  |  |  |  |  | Hi all,
 |  |  |  |  |  |  |  |  |  |  |  |  | Please see attached .xls
 |  |  |  |  |  |  |  |  |  |  |  |  | I have 3 columns, 2 text and 3rd a cost.
 |  |  |  |  |  |  |  |  |  |  |  |  | I would like to be able to filter the first, in this case 1,1,1,1,2,2,2,3,3,3,3,...etc
 |  |  |  |  |  |  |  |  |  |  |  |  | and then look at the second, check how many are a match to the first and second column and add the total cost.,
 |  |  |  |  |  |  |  |  |  |  |  |  | ie [1,Bed+1,Bed = (423+236)] [2,Shoes+2,Shoes+2,Shoes=(432+654+653)
 |  |  |  |  |  |  |  |  |  |  |  |  | (The .xls will make more sense)
Spreadsheet: 9021169d-48f4-4198-8aac-505a733c5c59
Sheet: Balance Sheet

AMERICAN CAPITAL, LTD.
CONSOLIDATED BALANCE SHEETS
As of March 31, 2012, December 31, 2011 and March 31, 2011
(in millions, except per share amounts)
 | Q1 |  | Q4 |  | Q1 2012 Versus Q4 2011 |  |  |  | Q1 |  | Q1 2012 Versus Q1 2011
 | 2012 |  | 2011 |  | $ |  | % |  | 2011 |  | $ |  | %
 | (unaudited) |  |  |  |  |  |  |  | (unaudited)
Assets
Investments at fair value (cost of $6,322, $6,739 and $7,535, respectively) | 5379 |  | 5130 |  | 249 |  | 0.04853801169590644 |  | 5652 |  | -273 |  | -0.04830148619957537
Cash and cash equivalents | 313 |  | 204 |  | 109 |  | 0.5343137254901961 |  | 98 |  | 215 |  | 2.193877551020408
Restricted cash and cash equivalents | 205 |  | 80 |  | 125 |  | 1.5625 |  | 98 |  | 107 |  | 1.091836734693878
Interest receivable | 22 |  | 24 |  | -2 |  | -0.08333333333333333 |  | 30 |  | -8 |  | -0.2666666666666667
Deferred tax asset, net | 396 |  | 428 |  | -32 |  | -0.07476635514018691 |  | 0 |  | 396 |  | 1
Derivative agreements at fair value | 10 |  | 10 |  | 0 |  | 0 |  | 5 |  | 5 |  | 1
Other | 96 |  | 85 |  | 11 |  | 0.1294117647058824 |  | 120 |  | -24 |  | -0.2
Total assets | 6421 |  | 5961 |  | 460 |  | 0.07716826035900017 |  | 6003 |  | 418 |  | 0.06963185074129602
Liabilities and Shareholders' Equity
Debt | 1132 |  | 1251 |  | -119 |  | -0.09512390087929656 |  | 1742 |  | -610 |  | -0.3501722158438577
Derivative agreements at fair value | 105 |  | 99 |  | 6 |  | 0.06060606060606061 |  | 95 |  | 10 |  | 0.1052631578947368
Other | 70 |  | 48 |  | 22 |  | 0.4583333333333333 |  | 50 |  | 20 |  | 0.4
Total liabilities | 1307 |  | 1398 |  | -91 |  | -0.06509298998569385 |  | 1887 |  | -580 |  | -0.3073661897191309
Shareholders' equity
Undesignated preferred stock, $0.01 par value, 5.0 shares authorized, 0 issued       and outstanding | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Common stock, $0.01 par value, 1,000.0 shares authorized, 332.5, 336.4 and 353.8       issued and 325.6, 329.1 and 343.9 outstanding, respectively | 3 |  | 3 |  | 0 |  | 0 |  | 3 |  | 0 |  | 0
Capital in excess of par value | 7024 |  | 7053 |  | -29 |  | 0 |  | 7145 |  | -121 |  | -0.01693491952414276
Distributions in excess of net realized earnings | -1058 |  | -999 |  | -59 |  | -0.05905905905905906 |  | -1056 |  | -2 |  | 0
Net unrealized depreciation of investments | -855 |  | -1494 |  | 639 |  | 0.427710843373494 |  | -1976 |  | 1121 |  | 0.5673076923076923
Total shareholders' equity | 5114 |  | 4563 |  | 551 |  | 0.1207538899846592 |  | 4116 |  | 998 |  | 0.2424684159378037
Total liabilities and shareholders' equity | 6421 |  | 5961 |  | 460 |  | 0.07716826035900017 |  | 6003 |  | 418 |  | 0.06963185074129602
NAV per common share outstanding | 15.71 |  | 13.87 |  | 1.840000000000002 |  | 0.1326604181687096 |  | 11.97 |  | 3.74 |  | 0.3124477861319966
Spreadsheet: 168471d1342465902-build-unique-list-from-data-worksheet-that-updates-based-on-data-selection-example-incl-excelproblem
Sheet: Menu

Make a selection on the CHOICE field to update data:
Item ID | Item | Description | Choice | Cost | Opt1 | Opt2 | Opt3
1 | Hamburger |  | with cheese and onions
2 | Pizza | A basic pizza has crust sauce and cheese | with pepperoni and olives
Spreadsheet: 0bd27fd0-f814-43b9-8fe3-eb331cc4c611
Sheet: Cal Settings

[NAME] | Equipment Used: | Color Sensor: | X-Rite (GretagMacbeth) "eye-one display" Model 36.88.32
2013-01-26 00:00:00 |  | Test Patterns | DVE "HD Basics" Blu-ray
v1.0 laugsbach & HMenke |  | Software: | HCFR Colorimeter (HT enthusiast freeware)
 | Screen Type: | Acoustically transparent | Matte white vinyl
 |  | laugsbach | [NAME]
PICTURE MEMORY (custom name): |  | 709CAL | 70924pECOirisoff
Intended Content: |  | 2D Blu-ray | 2D Blu-ray
Intended [NAME]: |  | 24p | 24p
Comment:
Menu: PICTURE | PICTURE MODE | REC709 | REC709
 | CONTRAST | -4 | -10
 | BRIGHTNESS | +5 | +4
 | COLOR | 0 | 0
 | TINT | 0 | 0
 | COLOR TEMPERATURE | 0 | 0
 | SHARPNESS | SIMPLE:0 | SIMPLE: 0
 | [NAME] | OFF | OFF
Menu: PICTURE > ADVANCED | GAMMA ADJUSTMENT | See Below | See Below
 | CONTRAST R | +14 | +1
 | CONTRAST G | 0 | 0
 | CONTRAST B | +13 | +4
 | BRIGHTNESS R | -1 | +6
 | BRIGHTNESS G | 0 | -1
 | BRIGHTNESS B | -1 | 0
 | NR | 0 | 0
 | FRAME CREATION | OFF | MODE1
 | COLOR MANAGEMENT | NORMAL | NORMAL
 | DETAIL CLARITY | +3 | +3
 | SUPER WHITE | OFF | OFF
 | RGB/YPbPr | AUTO | AUTO
Menu: 3D SETTINGS | 3D EYEWEAR BRIGHTNESS | N/A | N/A
 | 3D [NAME] REMASTER | N/A | N/A
Menu: OPTION | HDMI SIGNAL LEVEL | NORMAL | NORMAL
 | FRAME RESPONSE | NORMAL | NORMAL
 | LAMP POWER | ECO | ECO
GAMMA ADJUSTMENT (Custom name): |  | 709CAL | 709ECOirisoff
 | GAMMA PRESET | 0 | 0
 | REFERENCE POINTS | OFF | OFF
 | POINT | OUTPUT | OUTPUT
Y | 1 | 0 | -4
 | 2 | -1 | -5
 | 3 | +2 | -5
 | 4 | -1 | -6
 | 5 | 0 | -6
 | 6 | 0 | -8
 | 7 | 0 | -6
 | 8 | 0 | -6
 | 9 | 0 | -6
 | 10 | 0 | -9
 | 11 | 0 | -5
 | 12 | 0 | -8
 | 13 | 0 | -4
 | 14 | 0 | -9
 | 15 | +1 | -8
R | 1 | 0 | -6
 | 2 | -1 | -9
 | 3 | +2 | -9
 | 4 | -1 | -7
 | 5 | 0 | -8
 | 6 | 0 | -10
 | 7 | 0 | -5
 | 8 | 0 | -8
 | 9 | 0 | -7
 | 10 | 0 | -7
 | 11 | 0 | -4
 | 12 | 0 | -4
 | 13 | 0 | -2
 | 14 | 0 | -1
 | 15 | +1 | -1
G | 1 | 0 | -2
 | 2 | 0 | -3
 | 3 | +2 | -3
 | 4 | -1 | -5
 | 5 | 0 | -5
 | 6 | 0 | -7
 | 7 | 0 | -7
 | 8 | 0 | -5
 | 9 | 0 | -6
 | 10 | 0 | -10
 | 11 | 0 | -6
 | 12 | 0 | -11
 | 13 | 0 | -5
 | 14 | 0 | -13
 | 15 | +1 | -12
B | 1 | 0 | -2
 | 2 | -3 | -3
 | 3 | +2 | -1
 | 4 | -1 | 0
 | 5 | 0 | -2
 | 6 | 0 | 0
 | 7 | 0 | 0
 | 8 | +2 | +1
 | 9 | 0 | -1
 | 10 | +1 | -2
 | 11 | 0 | 0
 | 12 | 0 | -2
 | 13 | 0 | -3
 | 14 | +3 | -2
 | 15 | +5 | -2
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12222 | 11345
2 | 12888 | 11487
3 | 11891 | 11488
4 | 11899 | 11090
5 | 11842 | 11492
6 | 11356 | 11494
7 | 11348 | 11494
8 | 10845 | 11494
9 | 10042 | 11484
10 | 11541 | 11494
11 | 12142 | 11444 | -1
12 | 12792 | 11444
13 | 12272 | 11444
14 | 11797 | 11830
15 | 11785 | 11837
16 | 11842 | 11772 | -183
17 | 12746 | 11494 | -7
18 | 11034 | 11467 | -66
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 442176.52
2001-08-18 00:00:00
CBS Volume
 |  |  | -235778
Spreadsheet: 870216d1716771041-help-make-a-formula-adding-ingredient-unit-conversion_carton_box_pump_cup-choy96-3-1-
Sheet: Sheet1

1 carton | = | 16 box
1 box | = | 5 pump | 15
1 pump | = | 3 cup
office balance | worker 1 | worker 2 | worker 3 | worker 4 | worker 5 | total |  | ca | b | p | cu | Mod(Cu,3) | Sum(P,Mod(Cu,3)) | Mod(P,5) | Sum(B,[NAME])) | [NAME]) | Sum(Ca,[NAME]))
0 | 0 | 1ca | 4p | 4p | 3ca 10b 0p 1cu
0 | 0 | 0 | 0 | 0 | 3ca 0b 3p 1cu
 |  |  | 1ca 11b 1p | 3b | 3b
 |  |  | 99b
 |  |  | 100b
 |  |  |  | 100B
Spreadsheet: 713546d1610774226-how-can-i-make-this-dynamic-calendar-sort-data-from-the-future-and-the-past-pulling-dates-gk
Sheet: Predictor for future

Item | extra information | Last time Purchased | Date for next purchase | Cycle (days) | Estimated time | 2019-01-01 00:00:00
 |  |  |  | 30
 |  |  |  |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  | Items used
Spreadsheet: 167444d1342000647-generating-a-filtered-table-test2-1-
Sheet: Result

Name: | [NAME]
Class | Algebra | French | English | Physical Education
 | x | x | x | x
Category | Mathematics | Language | Language | Athletics
Type | Regular | Advanced | Regular | Regular
Year | 3 | 4 | 3 | 2
Spreadsheet: 738531d1625090478-i-need-help-understanding-a-formula-order-test-2-tms-experiments
Sheet: Sheet1

 |  |  |  |  | =SUMPRODUCT(--(COUNTIF($A4:$A9,">"&$A4:$A9)=0))=0
 |  |  |  |  |  | > |  |  |  |  | = |  |  |  |  | <
901-0000-1010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SUMPRODUCT(--(COUNTIF($A4:$A9,"<"&$A4:$A9)=0))
901-0000-1011 |  | False | False | False |  | 4 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  | =SUMPRODUCT(--(COUNTIF($A5:$A10,"<"&$A5:$A10)=0))
901-0000-1012 |  | False | False | False |  | 3 |  |  |  |  | 1 |  |  |  |  | 2 |  |  |  | :
901-0000-1016 |  | False | False | False |  | 2 |  |  |  |  | 1 |  |  |  |  | 3 |  |  |  | :
901-0000-1017 |  | False | False | False |  | 1 |  |  |  |  | 1 |  |  |  |  | 4 |  |  |  | :
901-0000-1018 |  | False | False | False |  | 0 |  |  |  |  | 1 |  |  |  |  | 5 |  |  |  | =SUMPRODUCT(--(COUNTIF($A9:$A14,"<"&$A9:$A14)=0))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note that the cell addresses auto-adjust as the formula is pulled down
 |  |  |  |  |  | =COUNTIF($A4:$A9,">"&$A4:$A9)
 |  |  |  |  |  |  | =SUM(COUNTIF($A4:$A9,">"&$A4:$A9))
 |  |  |  |  |  |  |  | =SUMPRODUCT(--(COUNTIF($A4:$A9,">"&$A4:$A9)))
 |  |  |  |  |  |  |  |  | =SUMPRODUCT(--(COUNTIF($A4:$A9,">"&$A4:$A9)=0))
Spreadsheet: 01910ee8-8d72-4444-b979-d7ddd96b40fa
Sheet: Sheet1

1991 - 35th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Lech am [NAME], Schmelzhofwiesen, Austria |  |  |  |  | 1991-09-21 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | GER | Kuinke | Volker | [NAME] | [NAME] | D-Euregio | [NAME]Poland | 1024.9 | 1900-01-01 20:18:00
2 | AUT | Starkbaum | [NAME] | Scholz | Gerd | OE-PZS Polarstern | Nabrad/Fehergyarmad/Hungaria | 927.2 | 1900-01-01 17:48:00
3 | POL | Makne | [NAME] | [NAME] | Grzegorz | SP-BZO Polonez | Dorog/Hungaria | 631.3 | 1900-01-01 12:58:00
4 | AUT | Wagner | [NAME] | Lewetz | [NAME] | D-Columbus | Brno/ Chechoslovakia | 520.8 | 1900-01-01 04:05:00
5 | SUI | Spenger | [NAME] | Stoll | Christian | HB-BFC Jura | Pölöske/Hungaria | 511.8 | 20:42:00
6 | AVI | Fraenckel | [NAME] | [NAME] | [NAME] | D-Caribbean | Oberwarth/ Austria | 465.1 | 20:51:00
7 | SUI | Sutter | Rolf | Nater | Alfred | HB-BJO  [NAME] | Siegersdorf/Graz /Austria | 426.9 | 20:51:00
8 | GER | Fink | [NAME] | [NAME] | Rainer | D-Augsburg | Eisenthal/Graz/ Austria | 408.9 | 20:52:00
9 | GER | Sjuts | Helma | Derks | Alfred | D-Continentale | [NAME]/Graz/ Austria | 407.5 | 21:57:00
10 | USA | [NAME] | [NAME] | Senez | [NAME] | N1636S Spirit of Sprinfield | [NAME]/Austria | 292.2 | 10:13:00
11 | USA | Boring | [NAME] | Noeske | Walter | HB-BJS Motor Columbus | Gschwand-Gmunden/Austria | 289.5 | 18:25:00
12 | POL | Szary | Piotr | Ozga | [NAME] | SP-BZR Polonia | Gmünd/Karinthia Austria | 260.3 | 10:48:00
13 | USA | Woods | [NAME] | Gorell | [NAME] | D-Aspen | Wörgl/Austria | 151.5 | 07:26:00
14 | SUI | Signer | Gerold | Osterwalder | Silvan | HB-BTE  [NAME] | Pollhov-Gradec/ Ljubliana/Yugoslavia | no res. | 10:22:00
Spreadsheet: 878473d1725552923-if-formula-to-calculate-banding-based-on-multiple-criteria-psa-calculation-template-2023-24
Sheet: Data

 | UK |  |  | Scottish |  |  | Wales |  |  | D0 | 0.4 |  | Country | Upper | Band
 | £0.01 - £37,700.99 | 0.2 |  | £0.01 - £2,306.99 | 0.19 |  | £0.01 - £37,700.99 | 0.2 |  | D1 | 0.45 |  | England | 37700.99 | 0.2
 | £37,701 - £125,140 | 0.4 |  | £2,307 - £13,991.99 | 0.2 |  | £37,701 - £125,140 | 0.4 |  | SD0 | 0.21 |  | England | 125140 | 0.4
 | Over £125,140 | 0.45 |  | £13,992 - £31,092.99 | 0.21 |  | Over £125,140 | 0.45 |  | SD1 | 0.41 |  | England | 125140.01 | 0.45
 |  |  |  | £31,093 - £62,430.99 | 0.42 |  |  |  |  | SD2 | 0.46 |  | Scotland | 2306.99 | 0.19
 |  |  |  | £62,431 - £125,140 | 0.45 |  |  |  |  |  |  |  | Scotland | 13991.99 | 0.2
 |  |  |  | Over £125,140 | 0.46 |  |  |  |  |  |  |  | Scotland | 31092.99 | 0.21
 |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | 62430.99 | 0.41
 |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | 125140 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | 125140.01 | 0.46
 |  |  |  |  |  |  |  |  |  |  |  |  | Wales | 37700.99 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | Wales | 125140 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  | Wales | 125140.01 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | Vouchers & Gifts
Payroll No. | Payroll Name | Practice | Site Code | Employee | Forename 1 | Surname | Nat Ins No | Leave Date | GrossPay T/d U/V | Tax Code | Country | Tax Code Breakdown | Tax Free Allowance | Taxable Pay | Tax Banding | PSA Tax Rate |  | [NAME] | Tax Due | Grossed Up Tax | Class 1B NIC |  | Vouchers & Gifts | Tax Due | Grossed Up Tax | Class 1B NIC
 |  |  |  |  |  |  |  |  | 17945.96 | 1257L | England | 1257 |  |  |  |  |  | 38.64
 |  |  |  |  |  |  |  |  | 43699.52 | S1257L | Scotland | 1257
 |  |  |  |  |  |  |  |  | 53142.73 | 1257L | England | 1257
 |  |  |  |  |  |  |  |  | 113002.25 | C1284L | Wales | 1284
 |  |  |  |  |  |  |  |  | 132061.44 | 350T | England | 350 |  |  |  |  | No Value Returned
 |  |  |  |  |  |  |  |  | 134969.32 | S250T | Scotland | 250 |  |  |  |  | No Value Returned
Spreadsheet: 0515d31c-3645-433e-840e-2f6469bac5b9
Sheet: SE

 |  | Special Ed Per-Pupil amount: | Category-1 | Category-2 | Category-3 | Category-4 | Category-5 | Category-6
 |  |  | 1517 | 3849 | 9248 | 12342 | 16715 | 24641
JVS IRN | County | JVS District Name | Special Ed Cat.1 | Special Ed Cat.2 | Special Ed Cat.3 | Special Ed Cat.4 | Special Ed Cat.5 | Special Ed Cat.6 | State Share Percentage | Special Ed Fundin  [NAME] | Special [NAME]Cat.2 | Special Ed Fundin  Cat.3 | Special [NAME] | Special [NAME]  Cat.5 | Special Ed Fundin  Cat.6 | Total Special Ed Funding
50773 | [NAME] | APOLLO JVSD
50799 | [NAME] | SOUTHERN HILLS JVSD
50815 | Ashtabula | A-TECH JVSD
50856 | Belmont | BELMONT-HARRISON JVSD
50880 | Butler | BUTLER TECH JVSD
50906 | [NAME] | [NAME] JVSD
50922 | Cuyahoga | CUYAHOGA VALLEY JVSD
50948 | Cuyahoga | POLARIS JVSD
50963 | [NAME] | FOUR COUNTY JVSD
50989 | Delaware | DELAWARE AREA CAREER CENTER JV
51003 | Franklin | EASTLAND-FAIRFIELD CAREER/TECH
51029 | Erie | EHOVE JVSD
51045 | Greene | GREENE COUNTY JT VOC SD JVSD
51060 | [NAME] | GREAT OAKS INST OF TECHNOLOGY
51128 | [NAME] | JEFFERSON COUNTY JVSD
51144 | Knox | KNOX COUNTY JVSD
51169 | Lake | AUBURN JVSD
51185 | [NAME] | [NAME] JVSD
51201 | Licking | C-TEC JVSD
51227 | Lorain | LORAIN COUNTY JVS JVSD
51243 | Mahoning | MAHONING CO CAREER & TECH CTR
51284 | Montgomery | MIAMI VALLEY CAREER TECH JVSD
51300 | Muskingum | MID-EAST CAREER & TECH CENTERS
51334 | Logan | OHIO HI-POINT JVSD
51359 | Wood | PENTA JVSD
51375 | Pike | PIKE COUNTY AREA JVSD
51391 | Portage | MAPLEWOOD CAREER CENTER JVSD
51417 | Richland | PIONEER CAREER & TECHNOLOGY JV
51433 | [NAME] | PICKAWAY-ROSS JVSD JVSD
51458 | Sandusky | VANGUARD-SENTINEL JVSD
51474 | [NAME] | WARREN COUNTY JVSD
51490 | Scioto | SCIOTO COUNTY CTC JVSD
51532 | [NAME] | SPRINGFIELD-CLARK COUNTY JVSD
51607 | Athens | TRI-COUNTY CAREER CENTER JVSD
51631 | Trumbull | TRUMBULL CAREER & TECH CTR JVS
51656 | Tuscarawas | [NAME] JVSD
51672 | Van Wert | VANTAGE JVSD
51698 | Washington | WASHINGTON COUNTY JVSD
51714 | Wayne | WAYNE COUNTY JVSD JVSD
62026 | [NAME] | STARK COUNTY AREA JVSD
62042 | Ashland | ASHLAND COUNTY-WEST HOLMES JVS
62067 | Gallia | GALLIA-JACKSON-VINTON JVSD
62109 | Medina | MEDINA COUNTY JVSD JVSD
62125 | Miami | UPPER VALLEY CAREER CENTER JVS
62802 | Clermont | U S GRANT JVSD
63495 | Summit | PORTAGE LAKES JVSD
63511 | [NAME] | TOLLES JVSD
65227 | Coshocton | COSHOCTON COUNTY JVSD
65268 | Marion | TRI-RIVERS JVSD
50765 | * * * | State of Ohio