tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 689849d1596704935-multiple-lookups-ordered-by-timestamp-lookup-example
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <- Order
Phase1, 2, 3 | Code | Created On | Created At | Result |  | Phase1 | Phase2 | Phase3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <- Code
123456 | A | 2018-11-12 00:00:00 | 09:38:22 | 0.001
123456 | A | 2018-11-12 00:00:00 | 09:38:22 | 0.002
123456 | B | 2018-11-12 00:00:00 | 09:38:59 | 0.003
123456 | B | 2018-11-12 00:00:00 | 09:38:59 | 0.004
123457 | A | 2018-11-12 00:00:00 | 09:41:25 | 0.005
123457 | A | 2018-11-12 00:00:00 | 09:41:25 | 0.006
123457 | B | 2018-11-12 00:00:00 | 09:41:25 | 0.007
123457 | B | 2018-11-12 00:00:00 | 09:41:25 | 0.008
123458 | C | 2018-11-12 00:00:00 | 09:41:25 | 0.009
123458 | D | 2018-11-12 00:00:00 | 10:44:54 | 0.01
123458 | C | 2018-11-12 00:00:00 | 10:48:44 | 0.011 |  | Transfer results from Table 1 to Table 2 by:
123458 | D | 2018-11-12 00:00:00 | 10:48:44 | 0.012
123459 | C | 2018-11-12 00:00:00 | 10:48:44 | 0.013 |  | For each row in Table2, match either of Phase1, Phase2 and Phase3 with the column Phase1, 2, 3 in Table1.
123459 | D | 2018-11-12 00:00:00 | 10:47:01 | 0.014 |  | For each column in Table2, match the Codes with the Codes in Table1.
123459 | C | 2018-11-12 00:00:00 | 10:50:29 | 0.015 |  | For each coulmn in Table2, match the [NAME] number for the given Code with the timestamp in columns Created On and Created At in Table1.
123459 | D | 2018-11-12 00:00:00 | 10:52:22 | 0.016 |  | The oldest timestamp shall give the lowest order number for the given code.
123460 | E | 2018-11-12 00:00:00 | 10:50:52 | 0.017 |  | If there are duplicate timestamps for a given match, both shall be counted with and the first occurrence shall return the first occurring result value and the next one(s) shall return the succeeding result value(s).
123460 | F | 2018-11-12 00:00:00 | 10:51:36 | 0.018
123460 | F | 2018-11-12 00:00:00 | 10:51:36 | 0.019
123460 | E | 2018-11-12 00:00:00 | 10:51:36 | 0.02
123461 | G | 2018-11-12 00:00:00 | 10:51:47 | 0.021
123461 | H | 2018-11-13 00:00:00 | 07:26:18 | 0.022
123461 | I | 2018-11-12 00:00:00 | 09:15:13 | 0.023
123461 | J | 2018-11-12 00:00:00 | 09:15:13 | 0.024
Spreadsheet: 2012041f-4553-49d9-8e08-84a5b49cb5ff
Sheet: CWS Tracker

2014-2015 Work Study [NAME]
Total Work  Study Award:
PP # | Begin | End | Pay Rate | Hours | Gross Pay | Award remaining
11 | 2014-08-14 00:00:00 | 2014-08-27 00:00:00
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
1
2
3
4
Spreadsheet: richard_ring__31563__SMALLC&I2001
Sheet: RECAP2001

 |  |  |  | SMALL C&I
UPDATED AS OF:
Prepared By: |  | Annette Tafallo | [PHONE]
Month 2001 | Product | Customers | Consumption
2001-01-01 00:00:00 | C100 | 18 | 3472
 | C20 | 4 | 9343
 | C50 | 0 | 0
2001-02-01 00:00:00 | C100 | 7 | 8138
 | C20 | 1 | 1560
 | C50 | 0 | 0
2001-03-01 00:00:00 | C100 | 7 | 6873
 | C20 | 2 | 3654
 | C50 | 0 | 0
2001-04-01 00:00:00 | C100 | 5 | 5098
 | C20 | 2 | 3320
 | C50 | 0 | 0
2001-05-01 00:00:00 | C100 | 5 | 5902
 | C20 | 1 | 1977
 | C50 | 0 | 0
2001-06-01 00:00:00 | C100 | 5 | 3948
 | C20 | 2 | 3920
 | C50 | 0
2001-07-01 00:00:00 | C100 | 5 | 6595
 | C20 | 1 | 1617
 | C50 | 0 | 0
2001-08-01 00:00:00 | C100 | 0 | 0
 | C20 | 0 | 0
 | C50 | 0 | 0
2001-09-01 00:00:00 | C100
 | C20
 | C50
2001-10-01 00:00:00 | C100
 | C20
 | C50
2001-11-01 00:00:00 | C100
 | C20
 | C50
2001-12-01 00:00:00 | C100
 | C20
 | C50
Spreadsheet: joe_parks__14714__POSTION05_02
Sheet: scale

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 | 10 | 3.64 |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 | 15 | 3.65 |  |  |  |  |  |  |  |  | NEW DEALS
 | 20 | 3.66
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  | Position |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 31 | 3.15
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.115
 |  | 3.68 | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
the trend days are in relation to the PH, PL. 30 min above the PH or 30 min below the PL changes, confirms the short term trend. The daily av at 3717 is what i think the market needs to close below today to suggest a top is in and to look for a downmove next week. a close between 3720-3780 today is neutral/up bias.  a close above 3780 indicates up next week to make new highs. back to the trend day rules: I take a 5 min bar chart. and i look for 6 consecutive closes above the PH or below the PL(30 min) If that happens then i get a trend day status. If only get 4 bars outside the PH,PL and closes back within the predicted ranges then i start the counting over again
Spreadsheet: 440230d1452703184-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2015
Sheet: March

Employee Absence Schedule
March | Dates of Absence
Employee Name | 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 | Total Hours
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Spreadsheet: 768772d1645116104-how-to-count-total-number-of-colors-efproductsum
Sheet: Sheet1

 |  |  |  |  | Color | Type | Quantity |  | Color | SUMTotal
 |  |  |  |  | Red | Shirt | 3 |  | Blue |  | 6
 |  |  |  |  | Green | Pants | 9 |  | Green |  | 10
 |  |  |  |  | Red | Shorts | 14 |  | Red |  | 37
 |  |  |  |  | Red | Hoodies | 20
 |  |  |  |  | Blue | Pants | 6
 |  |  |  |  | Green | Shirts | 1
Spreadsheet: 7e9adf2a-71db-4ae2-acd1-67a83f5189af
Sheet: Snow Removal

New # | Old # | New Contract | Old Contract | Purpose | Notes
30187 | 4642 |  | Low V | Snow Plow | Scrapped | Maybe 4646 | 20187
30188 | 4785 |  | Low V | Snow Plow | Scrapped |  | 20188
30189 | 5470 |  | Low V | Snow Plow | Scrapped |  | 20189
30194 | 5504 |  | Low V | Snow Plow | Scrapped |  | 20194
30190 | 5606 |  | Low V | Snow Plow | Scrapped |  | 20190
ST101 |  | [NAME] |  | Snow removal cars
ST202 |  | [NAME] |  | Snow removal cars
[NAME] |  |  |  | [NAME] | 1981 RMC Portec | "RMC Hurricane"; NYD 9/81
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
JB004 |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
Spreadsheet: 05a736a3-7b5a-4238-a833-54cfdb7dca6c
Sheet: Exhibit XVII, Sheet 1

Owners Forms
USAA Group
Pennsylvania
Claims, Losses, & Expense Summary
 | Earned Exposures
Accident Year | USAA | USAA-CIC | USAA-GIC | [NAME]
2005-06-30 00:00:00 | 31689 | 17522 | 0 | 0
2006-06-30 00:00:00 | 32836 | 19079 | 0 | 0
2007-06-30 00:00:00 | 33994 | 20375 | 34 | 99
2008-06-30 00:00:00 | 35060 | 21323 | 200 | 505
2009-06-30 00:00:00 | 35856 | 21882 | 416 | 862
2010-06-30 00:00:00 | 36483 | 22475 | 685 | 1226
2011-06-30 00:00:00 | 36922 | 22767 | 1434 | 1648
2012-06-30 00:00:00 | 37394 | 23074 | 3685 | 2162
Spreadsheet: 869678d1716285684-combine-multiple-vlookups-pc-test
Sheet: Scotland

Postcode | District | Latitude | Longitude
AB10 1AB | Aberdeen City | 57.149606 | -2.096916
AB10 1AF | Aberdeen City | 57.14959 | -2.096923
AB10 1AG | Aberdeen City | 57.149051 | -2.097004
AB10 1AH | Aberdeen City | 57.14959 | -2.096923
Spreadsheet: 799664d1665184703-if-function-to-find-out-original-order-and-than-number-the-duplicates-per-repeat-sample
Sheet: Sheet1

Case | Name | Last Name | Received Date | Closed date | Output
224186782 | PAUL | PAUL | 2022-05-03 13:01:52 | 2022-05-06 12:57:28 | Unique | Oldest order
224186858 | PAUL | PAUL | 2022-05-03 13:02:25 | 2022-05-06 13:12:22 | Duplicate 1 | Second Oldest
224186978 | PAUL | PAUL | 2022-05-03 13:03:10 | 2022-05-17 17:20:27 | Duplicate 2 | Newest
224429548 | LEAH | LEAH | 2022-05-05 17:17:08 | 2022-05-12 16:20:38 | Unique | Oldest order
226153916 | LEAH | LEAH | 2022-05-26 08:51:10 | 2022-06-16 07:20:50 | Duplicate 1 | Second Oldest
226161644 | LEAH | LEAH | 2022-05-26 10:19:53 | 2022-06-13 17:20:31 | Duplicate 2 | Newest
Name | Custom.Case | Custom.Last Name | Custom.Received Date | Custom.Closed date | Custom
PAUL | 224186782 | PAUL | 2022-05-03 13:01:52 | 2022-05-06 12:57:28 | unique
PAUL | 224186858 | PAUL | 2022-05-03 13:02:25 | 2022-05-06 13:12:22 | Duplicate 1
PAUL | 224186978 | PAUL | 2022-05-03 13:03:10 | 2022-05-17 17:20:27 | Duplicate 2
LEAH | 224429548 | LEAH | 2022-05-05 17:17:08 | 2022-05-12 16:20:38 | unique
LEAH | 226153916 | LEAH | 2022-05-26 08:51:10 | 2022-06-16 07:20:50 | Duplicate 1
LEAH | 226161644 | LEAH | 2022-05-26 10:19:53 | 2022-06-13 17:20:31 | Duplicate 2
Spreadsheet: be61f8b8-ba4e-4ccf-9d91-bd6a9a9cbdca
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBBIA | Test | FBBIA | Lyme Disease Antibody (IgG), IBL (CSF) | Lyme Disease Ab (IgG), IBL, CSF | Immunoblot | [NAME], sterile container: SrwStlCont |  |  | 1 | mL | 1 mL of spinal fluid. Send specimen refrigerated. | 0.25 mL | Specimens other than	CSF Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | REFERENCE RANGE: No Bands Detected   No interpretive criteria for Lyme Disease (Borrelia burgdorferi) immunoblot have been established for CSF. The presence of reactive antibodies in CSF may represent either compartmental antibody production or transudation of plasma antibody. Immunoblot assays may be used to confirm the presence of B. burgdorferi-specific antibodies detected in screening assays (ELISA, IFA).   Test Performed by: Focus Diagnostics, Inc.                              5785 Corporate Ave.                              Cypress, CA 90630-4750 | Monday, Wednesday, Friday | 1 day | 3 - 7 days | 1 | 86617 |  |  |  |  | Focus Diagnositics, Inc.
FBBIA | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
FBBIA | Result | Z2017 | Lyme Disease Ab (IgG), IBL | Lyme Disease Ab (IgG), IBL | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBBIA | Result | Z2018 | Bands Present | Bands Present | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 14a

Product |  | TOTAL
Single - Name* | Corporate | 738833
 | Loans | 4845
 | Municipal | 1826
 | Recovery
 | Sovereign | 216895
Index Tranche | Asia | <1,000
 | Europe | 166979
 | North America | 158456
Index | Asia | 26607
 | Europe | 375004
 | North America | 538104
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 2227549
Estimated net notional amount outstanding, February 15 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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 Data Dictionary for product descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 823394d1679942273-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-sample-3-sumifs
Sheet: Resources - YYYY

 | RESOURCES |  | MONTHLY ALLOCATION
 | Name | Unit Amount | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC
 |  |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS
 |  | 500 | 1 | 1.2
 |  | 0 | 1 | 1.3
 |  | 0 | 2 | 2.4
 |  | 500 | 1 | 1.3
 |  | 0 | 1 | 1.2
 |  | 500 | 1 | 1.3
 |  |  | 1 | 1.2
 |  |  | 1 | 1.3
 |  |  | 0.5 | 0.7
 |  |  | 1 | 1.3
 | TOTAL HEADCOUNT
Spreadsheet: 548220d1510937131-calendar-creation-using-existing-data-academic-calendar-any-year-1
Sheet: Weekly

 |  |  |  | Date: | 2017-08-21 00:00:00
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
08:00:00
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: williams

 | La Maquina |  | Milagro |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 41033 | 47479 | 386304 | 382606 | 38081 | 48634 | 153724 | 143155
2 | 59989 | 71232 | 403458 | 384185 | 36007 | 36585 | 151696 | 152989
3 | 64884 | 73689 | 391197 | 397054 | 43616 | 48634 | 171875 | 151856
4 | 72845 | 72969 | 370233 | 375070 | 41520 | 48634 | 162638 | 146490
5 | 86850 | 87100 | 349554 | 354190 | 45007 | 48634 | 129789 | 115758
6 | 73245 | 63737 | 393698 | 399032 | 45036 | 47052 | 160393 | 159872
7 | 75161 | 67069 | 354762 | 357960 | 47482 | 49634 | 171241 | 170091
8 | 74164 | 64177 | 360958 | 364836 | 43337 | 49634 | 165147 | 160172
9 | 79821 | 70948 | 376404 | 367006 | 36696 | 49445 | 155105 | 159892
10 | 76661 | 78888 | 370941 | 370727 | 46256 | 49634 | 140105 | 141029
11 | 74009 | 63470 | 379203 | 384429 | 47147 | 49634 | 157262 | 167982
12 | 74887 | 63118 | 371023 | 380378 | 16894 | 49634 | 148358 | 144322
13 | 46233 | 57685 | 369488 | 352026 | 48965 | 46503 | 149509 | 152847
14 | 35761 | 48937 | 363620 | 357197 | 57692 | 49017 | 140228 | 141399
15 | 50850 | 50899 | 393572 | 393441 | 51801 | 49378 | 153273 | 153529
16 | 64953 | 63754 | 360765 | 355443 | 70118 | 72130 | 119699 | 120351
17 | 65022 | 58374 | 353354 | 355446 | 72391 | 72130 | 112811 | 123153
18 | 59652 | 63384 | 378732 | 366403 | 62349 | 66537 | 150054 | 150008
19 | 42249 | 57651 | 356474 | 355569 | 67835 | 66616 | 162327 | 157991
20 | 56722 | 55452 | 331339 | 339674 | 70002 | 68692 | 166018 | 154353
21 | 60745 | 55196 | 260235 | 260000 | 64031 | 73078 | 154464 | 146740
22 | 63980 | 46705 | 339359 | 347926 | 70269 | 72131 | 150905 | 150249
23 | 63726 | 43178 | 343232 | 355876 | 79743 | 75218 | 155918 | 158919
24 | 64206 | 47399 | 342521 | 368186 | 78786 | 75835 | 153264 | 160430
25 | 62358 | 39090 | 343976 | 359786 | 71632 | 75834 | 157193 | 161433
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | -34361
2000-12-25 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 90892d1290597707-calculate-totals-book1
Sheet: Finished

TINAME | CDATEC | STIME | PON | No of Ints | Int Rate | Pax [NAME] | AC 1 | YC 2 | AT 3 | YT 4 | OAP 5 | DIS 6 | AS 7 | YS 8 | 16/17 9 | LTA 10 | STA 11 | STY 12 | Check
PAUL | 14/10/2010 | 0551 | 7 |  |  | 0
PAUL | 14/10/2010 | 0621 | 15 |  |  | 0 | 6 |  | 1 |  | 3
PAUL | 14/10/2010 | 0651 | 12 |  |  | 0
PAUL | 14/10/2010 | 0706 | 25 |  |  | 0
PAUL | 14/10/2010 | 0721 | 19 |  |  | 0
PAUL | 14/10/2010 | 0736 | 19 |  |  | 0
PAUL | 14/10/2010 | 0751 | 36 |  |  | 0
PAUL | 14/10/2010 | 0806 | 54 |  |  | 0
PAUL | 14/10/2010 | 0821 | 61 |  |  | 0
PAUL | 14/10/2010 | 0836 | 45 |  |  | 0
PAUL | 14/10/2010 | 0851 | 40 |  |  | 0
PAUL | 14/10/2010 | 0906 | 12 |  |  | 0
PAUL | 14/10/2010 | 0921 | 15 |  |  | 0
PAUL | 14/10/2010 | 0936 | 22 |  |  | 0
PAUL | 14/10/2010 | 0951 | 10 |  |  | 0
DEAN | 14/10/2010 | 1006 | 14 |  |  | 0
DEAN | 14/10/2010 | 1021 | 12 |  |  | 0
PAUL | 14/10/2010 | 1036 | 19 |  |  | 0
PAUL | 14/10/2010 | 1051 | 16 |  |  | 0
PAUL | 14/10/2010 | 1106 | 15 |  |  | 0
PAUL | 14/10/2010 | 1121 | 13 |  |  | 0
PAUL | 14/10/2010 | 1136 | 5 |  |  | 0
PAUL | 14/10/2010 | 1151 | 11 |  |  | 0
Spreadsheet: 854450d1704317268-timer-that-keeps-increasing-exampleforum
Sheet: Sheet1

A | 0 |  |  | Second example --> |  |  | A |  |  | Breakdown of second example but in separate columns: | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 1 |  |  |  |  |  |  |  |  |  | 1
 | 1 |  |  |  |  |  |  |  |  |  | 1
 | 1 |  |  |  |  |  | A |  |  |  | 1 | 0
 | 2 |  |  |  |  |  |  |  |  |  | 2 | 0
 | 2 |  |  |  |  |  |  |  |  |  | 2 | 1
 | 2 |  |  |  |  |  |  |  |  |  | 2 | 1
 | 3 |  |  |  |  |  |  |  |  |  | 3 | 1
 | 3 |  |  |  |  |  |  |  |  |  | 3 | 2
 | 3 |  |  |  |  |  |  |  |  | 2 | 3 | 2
 | 4 |  |  |  |  |  |  |  |  | 3 | 4 | 2
 | 4 |  |  |  |  |  |  |  |  | 4 | 4 | 3
 | 4 |  |  |  |  |  |  |  |  | 5 | 4 | 3
 | 5 |  |  |  |  |  |  |  |  | 6 | 5 | 3
 | 5 |  |  |  |  |  |  |  |  | 7 | 5 | 4
 | 5 |  |  |  |  |  |  |  |  | 8 | 5 | 4
 | 6 |  |  |  |  |  |  |  |  | 9 | 6 | 4
 |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 0e10b43d-c1db-4238-977a-3472db71eb75
Sheet: Sheet1

2004-01-27 00:00:00 | VICE-PRESIDENT OF THE UNITED STATES- REPUBLICAN | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 |  | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Belknap County | Bleckner, r | [NAME], r | [NAME] | [NAME] | [NAME] | [NAME] | Edwards
Alton | 25 | 32 | 1 | 72 | 5 | 2 | 4
Barnstead | 24 | 25 | 1 | 37 | 4 | 2 | 1
Belmont | 53 | 31 | 0 | 60 | 4 | 4 | 3
Center Harbor | 8 | 3 | 0 | 29 | 0 | 0 | 0
Gilford | 43 | 34 | 0 | 95 | 4 | 3 | 4
Gilmanton | 29 | 28 | 0 | 36 | 4 | 3 | 1
[NAME] | 7 | 15 | 0 | 47 | 5 | 0 | 0
[NAME] | 12 | 16 | 0 | 29 | 1 | 1 | 1
[NAME] 3 | 11 | 15 | 1 | 31 | 1 | 3 | 0
[NAME] | 15 | 24 | 0 | 28 | 0 | 1 | 0
[NAME] | 10 | 8 | 0 | 15 | 0 | 1 | 0
[NAME] 6 | 18 | 12 | 0 | 31 | 1 | 1 | 6
Meredith | 34 | 30 | 0 | 77 | 3 | 0 | 7
New Hampton | 20 | 16 | 0 | 23 | 1 | 0 | 1
Sanbornton | 18 | 20 | 0 | 39 | 1 | 0 | 1
[NAME] | 28 | 25 | 0 | 29 | 0 | 1 | 3
TOTALS | 355 | 334 | 3 | 678 | 34 | 22 | 32
Belknap County | Kerry | [NAME] | [NAME] | [NAME] | [NAME]
Alton | 1 | 2 | 2 | 1 | 4
Barnstead | 0 | 0 | 0 | 1 | 4
Belmont | 2 | 5 | 0 | 2 | 6
Center Harbor | 0 | 0 | 0 | 1 | 2
Gilford | 5 | 3 | 0 | 6 | 7
Gilmanton | 1 | 2 | 1 | 1 | 4
[NAME] | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 1 | 0 | 2
[NAME] 3 | 0 | 2 | 0 | 2 | 4
[NAME] | 0 | 3 | 0 | 0 | 2
[NAME] | 1 | 1 | 0 | 1 | 0
[NAME] 6 | 3 | 0 | 0 | 2 | 16
Meredith | 4 | 6 | 0 | 3 | 2
New Hampton | 2 | 0 | 1 | 1 | 5
Sanbornton | 3 | 1 | 0 | 2 | 5
[NAME] | 1 | 1 | 0 | 0 | 7
TOTALS | 24 | 27 | 5 | 23 | 70
 | VICE-PRESIDENT OF THE UNITED STATES- REPUBLICAN |  |  |  |  |  | Page 2 of 2
Belknap County
Alton
Barnstead
Belmont
Center Harbor
Gilford
Gilmanton
[NAME]
[NAME]
[NAME] 3
[NAME]
[NAME]
[NAME] 6
Meredith
New Hampton
Sanbornton
[NAME]
TOTALS
Belknap County
Alton
Barnstead
Belmont
Center Harbor
Gilford
Gilmanton
[NAME]
[NAME]
[NAME] 3
[NAME]
[NAME]
[NAME] 6
Meredith
New Hampton
Sanbornton
[NAME]
TOTALS
Spreadsheet: 780290d1652373984-return-multiple-values-across-many-rows-and-columns-20210302-projects-1-
Sheet: Stg1 SIR Gowrie

 |  | 2020-03-10 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Stage 1 SIR Gowrie | 22500 |  |  | 0 | 22500
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
Spreadsheet: 767301d1644400875-problem-with-formula-refernces-customer-complaint-log-2022-cleaned
Sheet: Justified complaints

Justified Complaints Current Year
Period | Justified Complaints | MT | Batches | Complaints per 1000 MT | complaints per 1000 batches
1
2
3
4
5
6
7
8
9
10
11
12
13
Spreadsheet: 21823d1209825420-if-then-horserace
Sheet: Sheet2

Win | 1
Place | 0.25
Race | Name | Horse | Stake | Win (W) / Place (P) | Result | Odds | Winnings including Stake
1 | Fred | Last Chance | 2.5 | W | 2 | 10.1 | 27.50000000000009
1 | [NAME] | No Chance | 5 | P | 1 | 5.2 | 8.124999999999996
1 | [NAME] | Every Chance | 6 | W | UP | 3.7 | 8.571428571428571
1 | [NAME] | What! | 7 | P | 3 | 4.1 | 14.00000000000002
Spreadsheet: 673885d1587576544-count-with-multiple-criterias-2020-04-22-oeldere-pt-673884d1587576126-count-with-multiple-criterias-count-examples
Sheet: Sheet1

 |  |  |  | Keep in mind that the names change so I can't use a static name as an option.
Group | People | Country |  | How many people in each group for each country? |  |  |  | The results should be the following
AEBC | Neo | Brazil
AEBC | Meleesa | Brazil |  |  | Brazil | USA |  |  | Brazil | USA
AEBC | [NAME] | USA |  | AEBC |  |  |  | AEBC | 2 | 1
CVBG | Amanda | Brazil |  | CVBG |  |  |  | CVBG | 1 | 2
CVBG | [NAME] | USA
CVBG | [NAME] | USA
 |  |  |  | Aantal [NAME] | Kolomlabels
 |  |  |  | Rijlabels | Brazil | USA | Eindtotaal
 |  |  |  | AEBC | 2 | 1 | 3
 |  |  |  | CVBG | 1 | 2 | 3
 |  |  |  | Eindtotaal | 3 | 3 | 6
Spreadsheet: louise_kitchen__23934__AugQTD Orig w notes
Sheet: West Power

West Origination
For the Quater Ended August 31
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Power |  | West Orig |  | 11017547
[NAME] |  | Power |  | West Orig |  | 1280
Total
Spreadsheet: 267226d1380018370-formula-to-colour-in-cells-depending-upon-the-relationship-of-2-other-cells-test-colour-formula
Sheet: Sheet1

Aim | Result | Target | [NAME] | Should Be | Correct or not | Notes
Lower is better | 85 | 100 |  | Green |  | Original Formula
Lower is better | 102 | 100 |  | Amber |  | Original Formula
Lower is better | 111 | 100 |  | Red |  | Original Formula
Lower is better | 0.85 | 1 |  | Green |  | Original Formula
Lower is better | 1.02 | 1 |  | Amber |  | Original Formula
Lower is better | 1.12 | 1 |  | Red |  | Original Formula
Higher is Better | 85 | 100 |  | Red |  | I have reversed the formula as the aim is different
Higher is Better | 92 | 100 |  | Amber |  | I have reversed the formula as the aim is different
Higher is Better | 102 | 100 |  | Green |  | I have reversed the formula as the aim is different
Higher is Better | 0.85 | 1 |  | Red |  | I have reversed the formula as the aim is different
Higher is Better | 0.92 | 1 |  | Amber |  | I have reversed the formula as the aim is different
Higher is Better | 1.02 | 1 |  | Green |  | I have reversed the formula as the aim is different
Spreadsheet: 793455d1661494959-checking-data-left-to-right-with-outcome-based-on-cell-content-check-left-to-right-for-result-aligw
Sheet: Query

A | B | C | Result
Completed | #N/A | #N/A
#N/A | 2022-03-15 00:00:00 | #N/A
#N/A | #N/A | ENR
Completed | 2021-04-18 00:00:00 | #N/A
Completed | #N/A | ENR
#N/A | 2019-09-05 00:00:00 | ENR
#N/A | #N/A | #N/A
Spreadsheet: 4ddb9021-a99a-481d-bbaa-2c50f55e5c0f
Sheet: Sheet1

METRO BANCORP, INC. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
8-K
01/25/2013
Income Statement
 | Three months ended |  |  |  |  |  |  |  |  |  | Year ended
 | December 31, |  |  |  |  |  |  |  |  |  | December 31,
(dollars in thousands, except per share | 2012 |  |  |  | 2011 |  |  | % Change |  |  | 2012 |  |  |  | 2011 |  |  | % Change
data )
Total revenues | 29639 |  |  |  | 28452 |  |  | 4 | % |  | 117052 |  |  |  | 113451 |  |  | 3 | %
Total noninterest expenses | 22486 |  |  |  | 21731 |  |  | 3 |  |  | 91144 |  |  |  | 94014 |  |  | -3
Net income | 3456 |  |  |  | 2483 |  |  | 39 |  |  | 10894 |  |  |  | 289 |  |  | 3670
Diluted net income per share | 0.24 |  |  |  | 0.18 |  |  | 33 | % |  | 0.77 |  |  |  | 0.02 |  |  | 3750 | %
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/