tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 549607d1511820182-sumifs-multiple-include-and-exclude-dropdowns-all-if-blank-sumifs-dropdown
Sheet: MAIN

 |  |  |  |  |  | Aug 2017 |  |  |  |  |  |  |  | Sep 2017
 |  |  |  |  | Key if needed->
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | PC | Small | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 245652 | 0 |  |  |  |  | 2433
 | PC | Small | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 245 | 0 |  |  |  |  | 2452
 | PC | Small | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 2527455 | 49140 |  |  |  |  | 13451
 | PC | Small | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 2345645 | 0 |  |  |  |  | 245
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | PC | Small | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 13721610 | 52567 |  |  |  |  | 2433
 | PC | Small | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 2435526 | 0 |  |  |  |  | 1345
 | PC | Small | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 15470910 | 49140 |  |  |  |  | 24
 | PC | Small | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 2524 | 0 |  |  |  |  | 145
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | GN | Small | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 13721610 | 0 |  |  |  |  | 2742
 | GN | Small | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 4831505 | 74784 |  |  |  |  | 1345
 | GN | Small | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 243524 | 49140 |  |  |  |  | 13451
 | GN | Small | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 47525 | 0 |  |  |  |  | 27
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | PC | Med | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 13721610 | 2497478 |  |  |  |  | 2433
 | PC | Med | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 25626 | 0 |  |  |  |  | 5727
 | PC | Med | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 2565 | 25662127 |  |  |  |  | 13451
 | PC | Med | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 22656 | 0 |  |  |  |  | 145
Spreadsheet: 815238d1674830118-splitting-row-by-values-into-multiple-rows-splitting-rows-by-grouped-values
Sheet: Sheet1

SAMPLE DATA
GROUP-1 | 10 | 10 | 15 | 13 | 20
GROUP-2 | 5 | 5 | 7 | 7 | 3
GROUP-3 | 80 | 80 | 80 | 10 | 80
GROUP-4 | 1 | 2 | 3 | 3 | 1
RESULTS
GROUP-1 | 10 | 10
GROUP-1 | 15
GROUP-1 | 13
GROUP-1 | 20
GROUP-2 | 5 | 5
GROUP-2 | 7 | 7
GROUP-2 | 3
GROUP-3 | 80 | 80 | 80 | 80
GROUP-3 | 10
GROUP-4 | 1 | 1
GROUP-4 | 2
GROUP-4 | 3 | 3
Spreadsheet: 05a23259-18e9-4858-98f7-9a4c83b7bbe0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | PAYMENT REQUEST # | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  | (DEPTID PLUS 4 DIGIT UNIQUE #)
TYPE OF PAYMENT |  |  | BUDGET YEAR | DATE CHECK REQ'D | VENDOR NO. | VOUCHER NO. |  | CHECK NO./DATE
MAKE CHECK PAYABLE TO |  |  |  |  | TAX ID# / SOCIAL SECURITY # |  |  | 1099
MAILING ADDRESS (MUST BE FILLED OUT) |  |  |  |  | APT #. |  |  | SPEEDTYPE
CITY |  |  | STATE | ZIP CODE
TELEPHONE NO. |  |  | FAX NO.
 | INV. DATE | INVOICE NO. / DESCRIPTION OF CHARGE | ACCOUNT | FUND | DEPT. ID | PROGRAM | ACTIVITY | CLASS | PROJ/GRANT | AMOUNT
CHARGES
CREDITS
COMMENT (PRINTED ON CHECK - IF DESIRED) (25 CHARACTERS)
 |  |  |  |  |  |  |  | TOTAL PAYMENT |  | 0
 |  |  |  |  |  | SPECIAL INSTRUCTIONS
PREPARED BY |  |  | DEPT | EXT | DATE
APPROVAL SIGNATURE
PRINTED NAME |  |  | DEPT | EXT | DATE
ACCOUNTING USE ONLY |  |  | CASHIER'S USE ONLY |  |  | ACCOUNTS PAYABLE USE ONLY
ACCOUNTING APPROVAL BY |  |  | RECEIVED BY |  |  | DATE P/R RECEIVED
DATE |  |  | AMOUNT PAID OUT |  | DATE | DATE PAYMENT DUE |  | DATE ENTERED BY
ACCOUNTS PAYABLE COPY (PLEASE MAKE COPY FOR YOUR RECORDS)
Spreadsheet: 845682d1697095089-show-working-instructions-depending-on-ghs-hazard-pictograms-sample-book-glenn-and-hansd-1-
Sheet: Search

 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Room 2
 |  |  |  |  |  |  |  |  |  |  |  | Room 3, asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23
 | Unstabil; Explosiv |  | Unstabil; Explosiv |  | Akut-toxisch 7 |  |  |  |  |  |  | Room 4
 |  |  |  |  |  |  |  |  |  |  |  | Room 5 , asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23 , asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23
 |  |  |  |  |  |  |  |  |  |  |  | Room 6
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 | Possible Rooms: |  |  |  |  |  |  |  |  |  | Possible Rooms | #N/A
 | Room 1, depending, if possible in room 6 Room 2, [NAME] 10 g, if possible in room 6 Room 3, if possible in room 6 Room 4, if possible in room 6 |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | Hans
 | Chemical is a |  | Powder |  |  |  |  |  |  |  |  | Room 2, asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23
 |  |  |  |  |  |  |  |  |  |  |  | Room 3, asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23 , asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23
 | Special Requirements: |  |  |  |  |  |  |  |  |  | Special Requirements | Room 4, asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23 , asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23
 | B12: be aware of B15: if, then do [NAME]: Need xy B59: not allowed to |  |  |  |  |  |  |  |  |  |  | Room 5 , asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23 , asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23
 |  |  |  |  |  |  |  |  |  |  |  | Room 6, asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23 , asdf ölkjas [NAME] ölkas ölka ölkjasd ö2 ö9 d90 23
Spreadsheet: john_griffith__15748__10_16_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | 22 | 58 | 68 | 63.1 | 74 | 0.95 | 2001-10-16 14:40:00
 | CL Z1 | 22 | 265 | 273 | 53.7 | 55.4 | 0.75 | 2001-10-16 14:40:00
 | CL F2 | 22.5 | 353 | 365 | 49.3 | 51 | 0.71 | 2001-10-16 14:40:00
 | CL G2 | 22.5 | 410 | 425 | 46 | 47.7 | 0.66 | 2001-10-16 14:40:00
 | CL H2 | 22.5 | 453 | 463 | 44.5 | 45.5 | 0.64 | 2001-10-16 14:40:00
 | CL J2 | 22.5 | 465 | 480 | 41.2 | 42.5 | 0.59 | 2001-10-16 14:40:00
 | CL K2 | 22.5 | 485 | 505 | 39.1 | 40.7 | 0.56 | 2001-10-16 14:40:00
 | CL M2 | 22.5 | 500 | 520 | 37.6 | 39.1 | 0.54 | 2001-10-16 14:40:00
 | CL N2 | 22.5 | 510 | 530 | 35.8 | 37.3 | 0.52 | 2001-10-16 14:40:00
 | CL Q2 | 22.5 | 515 | 535 | 34.3 | 35.7 | 0.5 | 2001-10-16 14:40:00
 | CL U2 | 22.5 | 520 | 540 | 33.1 | 34.4 | 0.48 | 2001-10-16 14:40:00
 | [NAME] | 22.5 | 528 | 545 | 32 | 33.1 | 0.46 | 2001-10-16 14:40:00
 | [NAME] | 22 | 530 | 545 | 30.6 | 31.5 | 0.43 | 2001-10-16 14:40:00
 | CL M3 | 21.5 | 530 | 570 | 26.6 | 28.7 | 0.37 | 2001-10-16 14:40:00
 | CL Z3 | 21.5 | 530 | 570 | 23.8 | 25.6 | 0.33 | 2001-10-16 14:40:00
Spreadsheet: 748936d1632419459-display-unique-value-based-upon-latest-time-stamp-example_good
Sheet: Sheet1

Original Columns  -  Has Duplicates |  |  |  | Desired Result - No Duplicates
Data | Times |  |  | Data | Times
00T464154 | 2021-09-21 09:44:37 |  |  | 00T464154 | 2021-09-21 19:20:02 | Last Instance
00T464154 | 2021-09-21 12:08:51 |  |  | 02U572083 | 2021-09-21 03:19:49
00T464154 | 2021-09-21 19:20:02 | Display Last Instance |  | 07U632089 | 2021-09-21 13:52:25
02U572083 | 2021-09-21 03:19:49 |  |  | 07U632090 | 2021-09-21 15:36:16
07U632089 | 2021-09-21 13:52:25 |  |  | 08T720293 | 2021-09-21 09:44:30
07U632090 | 2021-09-21 15:36:16 |  |  | 08T720629 | 2021-09-21 20:36:43
08T720293 | 2021-09-21 09:44:30 |  |  | 08T720630 | 2021-09-21 12:31:53 | Last Instance
08T720629 | 2021-09-21 20:36:43 |  |  | 08T720631 | 2021-09-21 17:14:39
08T720630 | 2021-09-21 19:37:26 |  |  | 08T720633 | 2021-09-21 20:53:15 | Last Instance
08T720630 | 2021-09-21 15:26:14
08T720630 | 2021-09-21 12:31:53 | Display Last Instance
08T720631 | 2021-09-21 17:14:39 |  |  | Display each unique value for the latest time
08T720633 | 2021-09-21 13:42:19
08T720633 | 2021-09-21 20:53:15 | Display Last Instance |  | ↓ Array formula entered with CTRL + SHIFT + ENTER
Spreadsheet: 725483d1616691909-count-duplicates-in-table-cant-use-countif-example
Sheet: Sheet1

!!! Cannot use "COUNTIF" function !!!
Name | DOB | Concat | Count
Adella | 1955-12-18 00:00:00
[NAME] | 1963-08-26 00:00:00
Anne | 1947-10-29 00:00:00
Beverly | 1971-01-02 00:00:00
[NAME] | 1961-12-28 00:00:00
[NAME] | 1979-10-16 00:00:00
Carol | 1971-04-02 00:00:00
[NAME] | 1966-11-09 00:00:00
Coral | 1961-11-11 00:00:00
Daryl | 1937-08-28 00:00:00
[NAME] | 1956-10-28 00:00:00
[NAME] | 1962-05-18 00:00:00
[NAME] | 1962-08-02 00:00:00
[NAME] | 1956-07-02 00:00:00
Dolores | 1970-03-06 00:00:00
[NAME] | 1962-02-10 00:00:00
[NAME] | 1972-03-21 00:00:00
[NAME] | 1963-04-09 00:00:00
Eleanor | 1958-09-07 00:00:00
Eva | 1972-08-23 00:00:00
[NAME] | 1945-05-02 00:00:00
Fred | 1960-01-03 00:00:00
George | 1964-01-24 00:00:00
[NAME] | 1931-10-28 00:00:00
[NAME] | 1939-03-24 00:00:00
[NAME] | 1944-02-07 00:00:00
[NAME] | 1958-07-29 00:00:00
[NAME] | 1971-06-11 00:00:00
[NAME] | 1960-07-27 00:00:00
[NAME] | 1953-05-24 00:00:00
[NAME] | 1954-02-02 00:00:00
[NAME] | 1933-02-22 00:00:00
[NAME] | 1965-10-07 00:00:00
[NAME] | 1972-04-25 00:00:00
[NAME] | 1954-06-07 00:00:00
Julia | 1969-10-15 00:00:00
[NAME] | 1942-07-08 00:00:00
[NAME] | 1970-07-07 00:00:00
Kathy | 1935-12-31 00:00:00
Kiley | 1969-01-29 00:00:00
[NAME] | 1952-05-04 00:00:00
[NAME] | 1956-05-13 00:00:00
Lewis | 1966-05-26 00:00:00
[NAME] | 1964-09-15 00:00:00
[NAME] | 1960-10-11 00:00:00
[NAME] | 1947-06-11 00:00:00
[NAME] | 2004-08-16 00:00:00
[NAME] | 1954-07-30 00:00:00
[NAME] | 1945-10-24 00:00:00
[NAME] | 1963-12-29 00:00:00
[NAME] | 1949-06-25 00:00:00
Melvin | 1933-04-15 00:00:00
Nicole | 1962-12-17 00:00:00
[NAME] | 1956-10-30 00:00:00
[NAME] | 1978-10-30 00:00:00
[NAME] | 1958-02-18 00:00:00
[NAME] | 1956-09-06 00:00:00
[NAME] | 1960-10-19 00:00:00
[NAME] | 1950-04-23 00:00:00
[NAME] | 1944-03-21 00:00:00
[NAME] | 1955-07-09 00:00:00
[NAME] | 1961-08-12 00:00:00
[NAME] | 1965-08-23 00:00:00
[NAME] | 1951-02-27 00:00:00
[NAME] | 1962-10-24 00:00:00
[NAME] | 1944-12-01 00:00:00
Shawn | 1958-03-05 00:00:00
Sonja | 1951-10-06 00:00:00
[NAME] | 1948-12-13 00:00:00
[NAME] | 1954-03-28 00:00:00
Theodore | 1953-05-16 00:00:00
Theodore | 1974-09-16 00:00:00
[NAME] | 1959-12-15 00:00:00
[NAME] | 1960-09-12 00:00:00
[NAME] | 1960-09-16 00:00:00
Spreadsheet: eric_saibi__9978__112001
Sheet: Ravenswood 01

Owner Name |  | Keyspan Ravenswood Inc.
Station Name |  | Ravenswood Power Station
Unit Name |  | Ravenswood 01
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Coal
Capacity |  | 400 MW
Start Date |  | 2001-10-05 00:00:00
End Date |  | 2001-11-19 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2002-01-04 00:00:00
Comments |  | boiler/turb work
SIC |  | 4931
Plant ID |  | 1516826
Unit ID |  | 1004328
Outage ID |  | 18595
Spreadsheet: 851396d1701640314-formula-to-automatically-make-a-list-off-another-sheets-info-problem1-rev1-pyplynr-
Sheet: Sheet2

Sheet 2
Order ID | [NAME] | Ship Date | Express | Due Date | Days Over Due | Ship ID |  | Order ID | [NAME] | Ship Date | Express | Due date | Overdue | Ship ID
 |  |  |  |  |  |  |  | 22 | Air | 2023-10-25 00:00:00 | Yes | 2024-04-02 00:00:00 | 0 | 543
22 | Air | 2023-10-25 00:00:00 | Yes | 2024-04-02 00:00:00 |  | 543 |  | 25 | Air | 2023-07-08 00:00:00 | No | 2023-12-15 00:00:00 | 0 | 722
25 | Air | 2023-07-08 00:00:00 | No | 2023-12-15 00:00:00 |  | 722 |  | 26 | Land | 2023-01-20 00:00:00 | Yes | 2023-06-29 00:00:00 | 157 | 643
26 | Land | 2023-01-20 00:00:00 | Yes | 2023-06-29 00:00:00 |  | 643 |  | 68 | Air | 2023-11-15 00:00:00 | Yes | 2024-04-23 00:00:00 | 0 | 986
68 | Air | 2023-11-15 00:00:00 | Yes | 2024-04-23 00:00:00 |  | 986 |  | 72 | Land | 2023-08-19 00:00:00 | Yes | 2024-01-26 00:00:00 | 0 | 223
72 | Land | 2023-08-19 00:00:00 | Yes | 2024-01-26 00:00:00 |  | 223 |  | 98 | Land | 2023-08-31 00:00:00 | Yes | 2024-02-07 00:00:00 | 0 | 510
98 | Land | 2023-08-31 00:00:00 | Yes | 2024-02-07 00:00:00 |  | 510 |  | 47 | Land | 2023-06-13 00:00:00 | No | 2023-11-20 00:00:00 | 13 | 473
47 | Land | 2023-06-13 00:00:00 | No | 2023-11-20 00:00:00 |  | 473 |  | 35 | Land | 2023-04-01 00:00:00 | No | 2023-09-08 00:00:00 | 86 | 435
35 | Land | 2023-04-01 00:00:00 | No | 2023-09-08 00:00:00 |  | 435 |  | 19 | Air | 2023-02-05 00:00:00 | No | 2023-07-15 00:00:00 | 141 | 397
19 | Air | 2023-02-05 00:00:00 | No | 2023-07-15 00:00:00 |  | 397 |  | 66 | Air | 2023-05-23 00:00:00 | No | 2023-10-30 00:00:00 | 34 | 600
66 | Air | 2023-05-23 00:00:00 | No | 2023-10-30 00:00:00 |  | 600 |  | 74 | Land | 2023-12-28 00:00:00 | No | 2024-06-05 00:00:00 | 0 | 322
74 | Land | 2023-12-28 00:00:00 | No | 2024-06-05 00:00:00 |  | 322 |  | 11 | Land | 2023-09-10 00:00:00 | Yes | 2024-02-17 00:00:00 | 0 | 285
11 | Land | 2023-09-10 00:00:00 | Yes | 2024-02-17 00:00:00 |  | 285 |  | 17 | Air | 2023-10-20 00:00:00 | No | 2024-03-28 00:00:00 | 0 | 247
17 | Air | 2023-10-20 00:00:00 | No | 2024-03-28 00:00:00 |  | 247
Spreadsheet: 70119d1270781685-workbook-to-workbook-data-entry-needed-test2
Sheet: invoice 2

My Invoice # | 2
Date | 2010-04-09 00:00:00
Name | [NAME]
Address | Brooklyn, NY
Phone | [PHONE]
 | Item Description | Serial # | Size | Color | Price | Quantity | Total
1 | Candle | 23 | Large | Blue | 12 | 6 | 72
2 | Soap | na | na | white | 4 | 10 | 40
3 |  |  |  |  |  |  | 0
4 |  |  |  |  |  |  | 0
5 |  |  |  |  |  |  | 0
 |  |  |  |  |  | Sub Total | 112
 |  |  |  |  |  | Tax | 7.56
 |  |  |  |  |  | Total | 119.56
Spreadsheet: 807397d1669889701-sum-of-values-into-merged-cells-forum1dec
Sheet: Sheet1

 | Given | Preferrable display
 | 319.5000000000001 | 319.5000000000001
 | 319.5000000000001 | 319.5000000000001
 | 319.5000000000001 | 319.5000000000001
 | 319.5000000000001 | 319.5000000000001
 | 213.0000000000001 | 528
 | 157.5
 | 157.5
 | 121.5 | 364.5
 | 121.5
 | 121.5
 | 121.5 | 445.5
 | 81.00000000000001
 | 121.5
 | 121.5
 | 121.5 | 459
 | 121.5
 | 81.00000000000001
 | 135
 | 135 | 360
 | 135
 | 90.00000000000001
 | 144 | 288
 | 144
 | 144 | 384
 | 144
 | 96.00000000000001
Spreadsheet: john_zufferli__16701__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Hedgeable Volume | Current Gas Hedges |  | AECO Basis Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (contracts/day) | (contracts/day) | % Hedged | (contracts/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25 |  |  | 12 |  | 12
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03 |  |  | 10.5 |  | 6
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9 |  |  | 9 |  | 5
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06 |  |  | 9 |  | 5
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5 |  |  | 9 |  | 4
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02 |  |  | 9 |  | 4
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09 |  |  | 9 |  | 4
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1 |  |  | 9 |  | 4
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14 |  |  | 9 |  | 4
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11 |  |  | 1 |  | 0
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08 |  |  | 1 |  | 0
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04 |  |  | 1 |  | 0
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03 |  |  | 1 |  | 0
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7 |  |  | 1 |  | 0
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 104257d1301916667-freight-charges-based-on-zip-freight-per-zip_new
Sheet: Sheet1

Zip Code | STATE | Basic Charge | Min Charge | 0 - 250 KGS | 251 - 500 KGS | 501 - 1000 KGS | 1001 - 3000 KGS | 3001 + KGS
999 | CA | 20 | 65 | 3.0774 | 5.8757 | 5.5557 | 5.5557 | 5.0774
1569 | WY | 3 | 70 | 0.8252 | 2.0786 | 0.7577 | 0.8788 | 0.8252
999 | AZ | 50 | 78 | 0.9276 | 2.2558 | 2.2227 | 2.0075 | 0.7276
Spreadsheet: 120619d1315408656-excel-2007-if-and-statements-and-vlookup-testbook
Sheet: Risk Log

Test Project Risk
# | Risk | Severity | Prob-ability | Impact Rating | Overall Impact | Escalate? | Risk Type | Status | Date Logged | Target Date | Team | Reported By | Owner | Mitigation Plan/Status
1 | Sample Critical Impact Risk | Mod | AC |  | Low | No | Project Management | No longer relevant |  | 2011-08-09 00:00:00 |  |  |  |  |  | Open | 1
2 | Sample hgih Impact Risk | Min | U |  | Medium | No | Testing |  |  |  |  |  |  |  |  | Closed | 2
3 | Sample Medium Impact Risk | Min | L |  | High | Yes | Training |  |  |  |  |  |  |  |  | No longer relevant | 3
4 | Sample Low Impact Risk | Maj | AC |  | Critical | Yes | Project Management |  |  |  |  |  |  |  |  |  | 4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 | Code in E7 works - but get an error if I keep adding IF/AND statements Need to look at Columns C & D and show what the impact level is in Column E Can use Lookup Table for H or Vlookup Table shows matches for column C7 & D7 and the result in the last column.
Spreadsheet: 85345d1285353167-sum-calculations-for-university-datah2
Sheet: T2

 | i | x | y
 | 1 | 6.2 | 10.7
 | 2 | 6 | 9.1
 | 3 | 6.8 | 11.1
 | 4 | 4.6 | 8
 | 5 | 5.2 | 9.6
 | 6 | 4.8 | 8.3
 | 7 | 4 | 4.2
 | 8 | 4.9 | 7.5
 | 9 | 5 | 7.1
 | 10 | 2.9 | 5.4
Spreadsheet: 758928d1639156858-need-help-around-correct-formulae-nested-if-or-index-for-attached-query-excel-test
Sheet: Q4

 | Weightage |  |  |  |  |  |  |  |  | 1 | Calculate Score %
 | Cat | KPI 1 | KPI 2 | KPI 3 | [NAME] |  |  |  |  |  | Score%= | Sum total of Achievement % against each KPI x Weightage
 | 3 | 0.4 |  | 0.3 | 0.3
 | 2 | 0.4 | 0.3 | 0.15 | 0.15 |  |  |  |  | 2 | Calculate Discount %
 | 1 | 0.4 | 0.2 | 0.2 | 0.2 |  |  |  |  |  | Score | Dis%
 |  |  |  |  |  |  |  |  |  |  | <=70% | NIL
 |  |  |  |  |  |  |  |  |  |  | >70% to 120% | 2% of every 1% of achievement
 | Achievement % |  |  |  |  |  |  |  |  |  | >120% | [NAME] capped @ 5%
Category | KPI 1 | KPI 2 | KPI 3 | [NAME] | Score % | Discount% | SLAB
2 | 1.4 | 0 | 1.1 | 0.67 |  |  |  |  |  | 3 | SLAB
1 | 1.140420490548893 | 1.229323308270677 | 0.7578558225508318 | 0.6428571428571429 |  |  |  |  |  |  | SLAB
3 | 1.62734807287941 | 1.226666666666667 | 0.7321428571428571 | 0.7741935483870968 |  |  |  |  |  |  | <70% | A
2 | 0.04990543443252185 | 0.2545454545454545 | 0.2666666666666667 | 0.375 |  |  |  |  |  |  | 70%-79% | B
1 | 1.000305711152202 | 1 | 0.6875 | 0.1111111111111111 |  |  |  |  |  |  | 80%-99% | C
2 | 0.6550122626907635 | 1.333333333333333 | 0.375 | 0.625 |  |  |  |  |  |  | 100%-119% | D
2 | 1.146158635202241 | 1.027118644067797 | 0.3076923076923077 | 0.2352941176470588 |  |  |  |  |  |  | 120%-139% | E
 | 1.002935438641262 | 1 | 0.25 | 0.4285714285714285 |  |  |  |  |  |  | >140% | F
2 | 2.541090141592509 | 1.04 | 0.9 | 1
2 | 1.126546873099301 | 3.75 | 0.6190476190476191 | 0.4
Spreadsheet: 156363d1337269611-having-trouble-using-the-index-function-to-return-an-entire-column-of-values-in-excel-2010-dp_vicksburgms_integrationcomplete_rpt_5-9-12_jdunawayv-2-demo-
Sheet:  Summary

 |  |  | Interface Engine
From | To | Message Types | Vendor Engaged | PO's Completed | VPN Completed | Connection Information Gathered | Connection Validated | Engine Programming Complete | Unit Test Complete | Included in Integrated Test Round 1
CoPath | HCI | ORU | 1
HCI/HPP | HLAB | ORM | 1 | 1 | 1 | 1 | 1 | 1
 | HMM | ORU (Ht and Wt) | 1 | 1 | 1 | 1 | 1 | 1
 | HMS | DFT | 1 | 1 | 1 | 1 | 1 | 1
HLAB | CoPath | ORM | 1
 | HCI | ORM | 1 | 1 | 1 | 1 | 1 | 1
 |  | ORU | 1 | 1 | 1 | 1 | 1 | 1
 | HMM | ORU | 1 | 1 | 1 | 1 | 1 | 1
 | HMS | DFT | 1 | 1 | 1 | 1 | 1 | 1
HMM | HCI | Allergies (A60) | 1 | 1 | 1 | 1
 |  | RDE | 1 | 1 | 1 | 1
 | HMS | DFT | 1 | 1 | 1 | 1
 | PHS | Allergies (A60) | 1 | 1 | 1 | 1
 | Pyxis | A08^AL1 (allergies) | 1 | 1 | 1 | 1
 |  | ADT - A08 w AL1 seg for allergies | 1 | 1 | 1
 |  | RDE (med orders) | 1 | 1 | 1
HMS | AHIQA | ADT | 1 | 1
 | Centricity CPN | ADT | 1
 | CoPath | ADT | 1
 | GE PACS | ADT | 1 | 1 |  | 1
 | HCI | ADT | 1 | 1 | 1 | 1 | 1 | 1
 | HCI/HPP | MFN (staff) | 1 | 1 | 1 | 1 | 1 | 1
 | HLAB | ADT | 1 | 1 | 1 | 1 | 1 | 1
 |  | MFN (staff) | 1 | 1 | 1 | 1 | 1 | 1
 | HMM | ADT | 1 | 1 | 1 | 1
 |  | MFN (staff updates) | 1 | 1 | 1 | 1
 | HRM | ADT | 1 | 1 | 1 | 1
 | HSM | MFN (M01, M02) | 1 | 1 | 1 | 1
 | M*Modal | ADT | 1 | 1 | 1 | 1 | 1 | 1
 |  | ORM | 1 | 1 | 1 | 1 | 1 | 1
 | MacLab | ADT | 1
 | MRS | ADT | 1 | 1 | 1 | 1
 | PHS | ADT passed to HSM | 1 | 1 | 1 | 1
 | Powerscribe | ADT | 2 | 1 | 1 | 1 | 1
HRM | GE PACS | ORM | 1 | 1 |  | 1
 | HCI | ORM | 1 | 1 | 1 | 1
 |  | ORM (order status updates) | 1 | 1 | 1 | 1
 |  | ORU | 1 | 1 | 1 | 1
 | HMS | DFT Charges (P03) | 1 | 1 | 1 | 1
 | MRS | ORM | 1 | 1 | 1 | 1
 | Powerscribe | ORM | 1 | 1 | 1 | 1 | 1
HSM | HCI | ORU Surgical Report | 1 | 1 | 1 | 1
 | HMS | DFT | 1 | 1 | 1 | 1
M*Modal | HRM | ORU  (CARD) | 1 | 1 | 1 | 1 | 1 | 1
 |  | ORU  (HIM / TRANS) | 1 | 1 | 1 | 1 | 1 | 1
PHS | HCI | Allergies (A60) | 1 | 1 | 1 | 1
 | HMM | Allergies (A60) | 1 | 1 | 1 | 1
 | HMS | ADT | 1 | 1 | 1 | 1
PowerScribe | HRM | ORU | 1 | 1 | 1 | 1 | 1
Pyxis | HMM | DFT | 1 | 1 | 1
 |  | [NAME] (Load/Unload) | 1 | 1
(blank) | (blank) | (blank)
Grand Total |  |  | 52 | 46 | 42 | 41 | 18 | 15
 |  |  | Point to Point
From | To | Message Types | Vendor Engaged | Count of PO's Completed | Count of VPN Completed | Count of Connection Information Gathered | Count of Connection Validated | Count of Engine Programming Complete | Count of Unit Test Complete | Count of Included in Integrated Test Round 1
HBB | HLAB | DFT | 1
 |  | ORU | 1 | 1 |  | 1
HLAB | HBB | ADT | 1
 |  | ORM | 1
 | Quest | ORM | 1
HMS | ProMed | ADT | 1
(blank) | (blank) | (blank)
Grand Total |  |  | 6 | 1 |  | 1
Spreadsheet: 842976d1694957934-cell-value-is-between-or-equal-to-range-return-header-value-header-based-lookup-between-values
Sheet: Sheet1

Name | 5 | 4 | 3 | 2 | 1 | Achieved Score | Expected Result
Agent1 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.4 | 5
Agent2 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.35 | 5
Agent3 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.3475 | 4
Agent4 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.33 | 4
Agent5 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.3275 | 3
Agent6 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.3 | 3
Agent7 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.2875 | 2
Agent8 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.25 | 2
Agent9 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.17 | 1
Agent10 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.15 | 1
Spreadsheet: 193290d1352793832-counting-last-most-recent-consecutive-positive-or-negative-numbers-in-a-row-book1
Sheet: Sheet1

 | 2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00 | 2012-11-11 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WINS |  | Losses
 | 25.1 | 30.8 | 15.7 | 34.48 | 5 | -7.319999999999979 | -71.96 | 2.3 | 33.68 | 62.3