tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 820151d1677881636-if-time-range-is-between-a-set-range-enter-number-or-word-if-time-range-is-between-a-set-time-range
Sheet: Sheet1

 | Shifts |  |  |  |  | Time range event occurred
 | Start | End |  |  |  | Start | End |  | Shift |  |  | Shift
1st | 07:00:00 | 14:59:59 |  |  |  | 15:10:53 | 4:11:37 PM
2nd | 15:00:00 | 22:59:59 |  |  |  | 07:21:46 | 07:26:57
3rd | 23:00:00 | 23:59:59 |  |  |  | 03:23:44 | 08:29:52
3rd | 00:00:00 | 06:59:59
Spreadsheet: 673990d1587625373-get-last-three-non-zero-values-of-a-row-test1
Sheet: Sheet1

 |  | Sales
Name | Last Date Sold | 27/03/2020 | 30/03/2020 | 31/03/2020 | 01/04/2020 | 02/04/2020 | 03/04/2020 | 04/06/2020 | 04/08/2020 | 04/09/2020 | 04/10/2020 | 04/15/2020 | 04/16/2020 | 04/17/2020
[NAME] |  | 0 | 0 | 0 | 0 | 31 | 0 | 0 | 0 | 0 | 12 | 0 | 35 | 0
Carlo |  | 0 | 0 | 24 | 0 | 29 | 40 | 0 | 0 | 0 | 0 | 34 | 0 | 38
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 39 | 0 | 24 | 0 | 110 | 150 | 0 | 102 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 39 | 99 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 48 | 57 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Taro |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sato |  | 0 | 0 | 0 | 0 | 19 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Piyal |  | 54 | 0 | 35 | 0 | 66 | 67 | 0 | 74 | 0 | 0 | 0 | 0 | 79
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 14 | 52 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Eg. Result to be as follows
 |  | Name | Last Date Sold | 2nd Last Date Sold | 3rd Last Date Sold
 |  | [NAME] | 04/16/2020 | 04/10/2020 | 02/04/2020
 |  | Carlo | 04/17/2020 | 04/15/2020 | 03/04/2020
 |  | [NAME] | 04/15/2020
 |  | [NAME]
 |  | [NAME] | 04/08/2020 | 03/04/2020 | 02/04/2020
Spreadsheet: darrell_schoolcraft__7246__saledoc02_1bTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-02-01 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/1/2002 |  |  | FAX Number:
Total Quantity |  |  | 10000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.06
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/1/2002 | 2002-02-01 00:00:00 | 10000 |  | 10000 |  | 10000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 10000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 855058d1704781852-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker-aligw
Sheet: Dec

 |  |  |  |  |  | CALENDAR MONTH | DECEMBER
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 888918d1739541685-count-for-every-use-with-a-30-second-gap-14-feb-30-gap-count
Sheet: Sheet1

2025-02-03T10:15:05.149Z
2025-02-03T10:15:17.141Z
2025-02-03T10:15:17.795Z
2025-02-03T10:15:19.953Z
2025-02-03T10:15:25.825Z
2025-02-03T10:15:49.041Z
2025-02-03T10:15:49.133Z
2025-02-03T12:15:20.908Z
2025-02-03T17:11:29.193Z
2025-02-03T17:11:30.601Z
2025-02-03T17:11:57.415Z
2025-02-03T17:12:05.721Z
2025-02-03T17:12:06.228Z
2025-02-03T17:12:09.421Z
2025-02-03T17:12:25.233Z
2025-02-03T17:12:28.844Z
2025-02-03T17:12:31.519Z
2025-02-03T17:12:32.688Z
2025-02-03T17:12:39.253Z
2025-02-03T17:12:46.060Z
2025-02-03T17:12:46.822Z
2025-02-03T21:46:52.712Z
2025-02-03T21:47:17.478Z
2025-02-03T21:47:17.500Z
2025-02-03T21:47:17.493Z
2025-02-03T21:47:17.494Z
2025-02-04T10:49:28.888Z
2025-02-04T12:40:51.270Z
2025-02-04T12:41:25.392Z
2025-02-04T12:41:26.022Z
2025-02-04T12:41:26.234Z
2025-02-04T12:41:28.958Z
2025-02-04T12:41:34.906Z
2025-02-04T12:41:39.565Z
2025-02-04T12:41:40.294Z
2025-02-04T12:41:40.668Z
2025-02-04T12:41:41.135Z
2025-02-04T12:41:46.508Z
2025-02-04T14:48:05.521Z
2025-02-04T14:48:07.463Z
2025-02-04T14:48:07.720Z
2025-02-04T14:48:07.841Z
2025-02-04T14:48:08.112Z
2025-02-04T14:48:11.884Z
2025-02-04T14:48:11.916Z
2025-02-04T14:48:11.928Z
Spreadsheet: 829091d1683904273-financial-modelling-staffing-inputs-how-to-toggle-both-starters-and-leavers-excel-staffing-workings-for-starters-and-leavers
Sheet: Sheet1

 | TEST |  |  |  |  |  |  |  |  |  |  |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-27 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00
 | STAFFING INPUT |  |  |  |  |  |  |  |  |  |  |  | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023
 |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | [NAME] | Start Date | Leave Date | Title | Status | Pay Type | [NAME] | Location | Salary | Medical |  |  | Headcount
1 | CFO | 2023-08-31 00:00:00 | 2023-10-31 00:00:00 |  | Permanent | Salary | Y |  | 100000
Spreadsheet: 679316d1590330812-combining-countif-with-lookup-and-counting-averages-where-data-might-not-exist-golf-2020_draft_version3
Sheet: Career

 |  | Average |  | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029
Number of golf rounds:
Number of complete 18 hole rounds:
Number of shots:
Number of points:
Number of GIR:
Number of fairway hits:
Number of putts:
Number of complete (explicit) 9 hole rounds:
Number of shots:
Number of points:
Number of GIR:
Number of fairway hits:
Number of putts:
Spreadsheet: 47699d1246879538-ranking-ties-book1
Sheet: Team Event Sat-Sun

TEAM EVENT Saturday
Bedford | Score | Pts | Crown |  |  | Misfits |  |  | South |  |  |  | B | C | M | S | B | C | M | S
CLARK. [NAME] | 0 |  | MURDIN. [NAME] | 0 |  | DAVEY. [NAME] | 0 |  | MANKTELOW. Trevor | 0
GAUGE. [NAME] | 0 |  | PYM. [NAME] | 0 |  | THORPE. [NAME] | 0 |  | SWEENEY. Eddie | 0
GREAVES. [NAME] | 0 |  | ANKERS. Neville | 0 |  | GOODALL. [NAME] | 0 |  | [NAME]. [NAME] | 0
Spreadsheet: 690820d1597310238-golf-scoring-system_automatically-highlighting-cells-20200813-excel-help-file
Sheet: Calculations

 | Dirab Golf Society (DGS) Gross Scores
 | Name
 |  |  | Rounds (20 [NAME]) | Counting  Rounds | Total of lowest Counting Rounds | Adj Gross | H'cap Diff | Index |  | Playing H'cap
 | 1 |  |  |  |  |  |  |  |  |  | Dirab (17)
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13 |  |  |  |  |  |  |  |  |  | [NAME] (3)
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24 |  |  |  |  |  |  |  |  |  | Dirab (15)
Spreadsheet: 29615d1224691974-updating-totals-by-month-off_days
Sheet: Sheet1

First | Last | ID | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total | Action | MAY
[NAME] | Doe | 123 |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 2 |  |  | 8 | Zero Days |  | 8
[NAME] | Smith | 456 |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
Spreadsheet: 787157d1657646350-cannot-return-header-based-on-specific-value-due-to-duplicate-value-copy
Sheet: Top3 E2

E3 | 2022-04-02 00:00:00 | 2022-04-03 00:00:00 | 2022-04-04 00:00:00 | 2022-04-05 00:00:00 | 2022-04-06 00:00:00 | 2022-04-07 00:00:00 | 2022-04-08 00:00:00 | 2022-04-09 00:00:00 | 2022-04-10 00:00:00 | 2022-04-11 00:00:00 | 2022-04-12 00:00:00 | 2022-04-13 00:00:00 | 2022-04-14 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00 | 2022-04-17 00:00:00 | 2022-04-18 00:00:00 | 2022-04-19 00:00:00 | 2022-04-20 00:00:00 | 2022-04-21 00:00:00 | 2022-04-22 00:00:00 | 2022-04-23 00:00:00 | 2022-04-24 00:00:00 | 2022-04-25 00:00:00 | 2022-04-26 00:00:00 | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | 2022-04-29 00:00:00 | 2022-04-30 00:00:00 | 2022-05-01 00:00:00 | 2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00 | 2022-05-09 00:00:00 | 2022-05-10 00:00:00 | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | 2022-05-13 00:00:00 | 2022-05-14 00:00:00 | 2022-05-15 00:00:00 | 2022-05-16 00:00:00 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00 | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00 | 2022-05-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00 | 2022-06-06 00:00:00 | 2022-06-07 00:00:00 | 2022-06-08 00:00:00 | 2022-06-09 00:00:00 | 2022-06-10 00:00:00 | 2022-06-11 00:00:00 | 2022-06-12 00:00:00 | 2022-06-13 00:00:00 | 2022-06-14 00:00:00 | 2022-06-15 00:00:00 | 2022-06-16 00:00:00 | 2022-06-17 00:00:00 | 2022-06-18 00:00:00 | 2022-06-19 00:00:00 | 2022-06-20 00:00:00 | 2022-06-21 00:00:00 | 2022-06-22 00:00:00 | 2022-06-23 00:00:00 | 2022-06-24 00:00:00 | 2022-06-25 00:00:00 | 2022-06-26 00:00:00 | 2022-06-27 00:00:00 | 2022-06-28 00:00:00 | 2022-06-29 00:00:00 | 2022-06-30 00:00:00 | 2022-07-01 00:00:00 | 2022-07-02 00:00:00 | 2022-07-03 00:00:00 | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 | 2022-07-06 00:00:00 | 2022-07-07 00:00:00 | 2022-07-08 00:00:00 | 2022-07-09 00:00:00 | 2022-07-10 00:00:00 | 2022-07-11 00:00:00
Contributor 1
Contributor 2
Contributor 3
Spreadsheet: 889527d1740384650-paste-values-where-is-blank-cells-paste-on-blank-cells-1-
Sheet: after

 |  |  |  |  | 1 |  |  | 7
 |  |  |  |  | 7 |  |  | 8
 |  |  |  |  | 3 |  |  | 9
 |  |  |  |  | 8 |  |  | 10
 |  |  |  |  | 9 |  |  | 11
 |  |  |  |  | 2 |  |  | 12
 |  |  |  |  | 10 |  |  | 13
 |  |  |  |  | 5 |  |  | 14
 |  |  |  |  | 11
 |  |  |  |  | 6
 |  |  |  |  | 12
 |  |  |  |  | 4
 |  |  |  |  | 13
 |  |  |  |  | 14
Spreadsheet: 770240d1645926981-replacing-offset-to-sum-up-to-max-value-from-specific-cell-calculating-the-number-of-rows-to-be-summed-up-to-a-condition-mfeengineer-
Sheet: Leads

Machine | 4103 | Machine | 4104 | Machine | 4105 | Machine | 4106
Engineering DWG | 2800026-A-05-0000 | Engineering DWG | 2800026-A-05-0000 | Engineering DWG | 2800026-A-10-0000 | Engineering DWG | 2800026-A-10-0000
Minutes | 50 | Minutes | 60 | Minutes | 20 | Minutes | 60
Starting N-Block | N1 | Starting N-Block | N11 | Starting N-Block | N11 | Starting N-Block | N11 |  |  | Replacing OFFSET to sum up to [NAME] value from specific cell (excelforum.com)
Helper Column (start) |  | Helper Column (start) |  | Helper Column (start) |  | Helper Column (start)
Table Row (start) |  | Table Row (start) |  | Table Row (start) |  | Table Row (start)
Rows |  | Rows |  | Rows |  | Rows
Ending N-Block |  | Ending N-Block |  | Ending N-Block |  | Ending N-Block
Total Time (min.) |  | Total Time (min.) |  | Total Time (min.) |  | Total Time (min.)
Time Balance (min.) |  | Time Balance (min.) |  | Time Balance (min.) |  | Time Balance (min.)
Machine | 4107 | Machine | 4108 | Machine | 4109 | Machine | 4110
Machine | 4111 | Machine | 4112 | Machine | 4113 | Machine | 4114
Machine | 4115 | Machine | 4116 | Machine | 4201 | Machine | 4202
Machine | 4203 | Machine | 4204 | Machine | 4205 | Machine | 4206
Machine | 4207 | Machine | 4208 | Machine | 4209 | Machine | 4301
Machine | 4303 | Machine | 4304 | Machine | 4305 | Machine | 4306
Machine | 4307 | Machine | 4308 | Machine | 4309 | Machine | 4310
Spreadsheet: 882560d1730955661-formula-for-marks-needed-for-each-grade-y2s2-courses-analysis-copy-updated-
Sheet: Current Marks

Last updated: | 2024-11-07 00:00:00
 | MEC200 | [NAME] | MEC202 | MTH203 | Total Average |  |  |  | Grade | Standard final mark parameters | Minimum | Maximum
A1 |  |  |  |  |  |  |  |  | High Distinction | 85%–100% | 0.85 | 1
A2 |  |  |  |  |  |  |  |  | Distinction | 75%–84% | 0.75 | 0.84
A3 |  |  |  |  |  |  |  |  | Credit | 65%–74% | 0.65 | 0.74
Current mark |  |  |  |  |  |  |  | Minimum -------> | Pass | 50%–64% | 0.5 | 0.64
 | Marks |  |  |  |  |  |  |  | Marginal Fail | 47%-49% | 0.47 | 0.49
 |  |  |  |  |  |  |  |  | Fail | 0%–46% | 0 | 0.46
Assignment No. | Part | Marks | Aim | Actual | Weight
MEC200 Thermodynamics
A1 | a |  | 15 | 0.8467 | 0.15 |  | Summary
 | b | 1e-06 | 15 | 0 | 0.15 |  | Course | Mark | Possible Max
A2 | Pre-lab tests | 5 | 5 | 5 | 0.1
 | Calcs and report | 0 | 25 |  | 0.2
A3 |  | 0 | 100 |  | 0.4
Total
ENG305 Engineering Management
A1 |  | 76 | 100 | 76 | 0.5
A2 |  | 0 | 100 |  | 0.5
Total |  |  |  |  |  |  | Minimum marks needed for each grade | Target | Great | Pushin' it | Study now!!! | Bruh…
MEC202 Mechanical Design |  |  |  |  |  |  | Course | HD | D | C | P | F
A1 | 1 | 5 | 5 | 5 | 0.05
 | 2 | 4.5 | 5 | 4.5 | 0.05
 | 3 | 6.7 | 10 | 6.7 | 0.1
 | 4 | 21 | 25 | 21 | 0.25
A2 |  | 0 | 25 |  | 0.25
A3 |  | 0 | 30 |  | 0.3
Total
MTH203 Numerical Analysis |  |  |  |  |  |  | Maximum marks needed for each grade | Target | Great | Pushin' it | Study now!!! | Bruh…
A1 |  |  | 100 | 0.9825 | 0.1 |  | Course | HD | D | C | P | F
A2 | 1 |  | 30 | 0.4833 | 0.1
 | 2 |  | 30 | 0.7917 | 0.1
 | 3 |  | 30 | 0.2571 | 0.1
 | 4 |  | 30 | 0.5893 | 0.1
 | 5 |  | 30 | 0.6167 | 0.1
A3 |  | 0 | 100 |  | 0.4
Total
Spreadsheet: 114475d1310169452-sorting-data-start-and-end-timings-list-file
Sheet: Sheet1

ID | Work Type | Status | Event Date hh:[NAME]
H | CTF | AIR | 2011-05-13-11.39
B | LML | VL2 | 2011-05-03-08.32
B | WNP | L2 | 2011-05-05-07.40
B | QTY | NED | 2011-05-19-12.52
B | QTY | END | 2011-05-19-12.53
C | YYS | SED | 2011-05-20-08.43
C | YYS | AIR | 2011-05-31-11.53
G | QTY | NED | 2011-05-11-11.17
G | QTY | NED | 2011-05-11-11.17
D | LML | LO | 2011-06-16-09.46
D | LML | LO | 2011-06-16-09.47
D | LML | LO | 2011-06-16-09.47
D | LML | LO | 2011-06-16-10.34
D | LML | LO | 2011-06-16-10.41
D | LML | LO | 2011-06-16-10.44
D | LML | LO | 2011-06-16-10.44
D | LML | LO | 2011-06-16-11.07
D | LML | AIR | 2011-06-16-11.10
F | ISS | NED | 2011-06-02-13.00
F | ISS | NED | 2011-06-02-13.00
F | ISS | NED | 2011-06-02-13.00
F | ISS | NED | 2011-06-02-13.40
F | ISS | END | 2011-06-02-13.40
Spreadsheet: 33475d1229905715-excel-2007-bar-graph-help-monthly-gas-reports-2009-test
Sheet: 8-10 thru 8-16

 |  |  |  |  |  | Corp:
 |  |  | 2009-08-10 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2008-08-10 00:00:00 |  |  |  |  |  |  | Total
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
 |  |  |  |  |  |  | Total:
Spreadsheet: 35589d1233181057-returning-multiple-results-for-one-lookup-value-multivalue-return
Sheet: PO

DATE: |  | 2009-01-28 17:15:11
 |  |  |  |  |  |  |  |  |  |  |  | Cutting | XS-XL
 | STYLE: | 2750 |  |  |  |  |  |  |  |  |  | CO: | USA
COLOR |  |  |  |  | QTY |  |  | Cost
RED PEPPER |  |  |  |  | 250 |  |  | 5.71
? |  |  |  |  | ? |  |  | ?
 |  |  |  | TOTAL UNITS | 250
 |  |  |  | TYPE OF PRE-PACK | 14 ppk
NEED FORMULA TO GET THE OTHER COLORS, please note that there is more data than just the 11 rows shown.  It's about 100 rows but sorted
Spreadsheet: 59802d1260358110-if-formula-in-sumproduct-test2
Sheet: Sheet1

Date | Item | Category | Country | Sales |  | List of items |  | Current category: | X
2009-01-01 00:00:00 | A | X | UK | 10 |  | ALL |  | Current country: | ALL
2009-01-01 00:00:00 | B | Y | US | 20 |  | A |  | Current item: | A
2009-01-01 00:00:00 | C | X | UK | 30 |  | B
2009-02-01 00:00:00 | A | X | US | 10 |  | C |  | Total sales:
2009-02-01 00:00:00 | B | Y | UK | 20
2009-02-01 00:00:00 | C | X | US | 30 |  | List of categories
2009-03-01 00:00:00 | A | X | UK | 10 |  | ALL
2009-03-01 00:00:00 | B | Y | US | 20 |  | X
2009-03-01 00:00:00 | C | X | UK | 30 |  | Y
 |  |  |  |  |  | List of countries
 |  |  |  |  |  | ALL
 |  |  |  |  |  | UK
 |  |  |  |  |  | US
Spreadsheet: 693548d1599031911-offset-with-criteria-query-book1
Sheet: Data

Purchase Order Number | Purchase Order Value | Invoice Number | Invoice Period | Invoice Date | Invoice Value | Currency | Spend to Date | Balance
PO12345 | 150000 | INV00001 |  | 2020-01-15 00:00:00 | 10000 | GBP
 |  | INV00002 |  | 2020-02-22 00:00:00 | 15000
 |  | INV00003 |  | 2020-03-30 00:00:00 | 25000
 |  | INV00004 |  | 2020-04-15 00:00:00 | 7500
 |  | INV00005 |  | 2020-04-19 00:00:00 | 30000
 |  | INV00006 |  | 2020-04-28 00:00:00 | 5000
 |  | INV00007 |  | 2020-05-28 00:00:00 | 9500
 |  | INV00008 |  | 2020-06-01 00:00:00 | 3500
 |  | INV00009 |  | 2020-06-19 00:00:00 | 7500
 |  | INV00010 |  | 2020-07-03 00:00:00 | 9250
 |  | INV00011 |  | 2020-07-17 00:00:00 | 27750
 |  | -
PO54321 | 450000 | INV10001 |  | 2020-01-10 00:00:00 | 25000 | GBP
 |  | INV10002 |  | 2020-02-17 00:00:00 | 35000
 |  | INV10003 |  | 2020-03-25 00:00:00 | 45000
 |  | INV10004 |  | 2020-04-01 00:00:00 | 10000
 |  | INV10005 |  | 2020-04-15 00:00:00 | 15000
 |  | INV10006 |  | 2020-04-19 00:00:00 | 27500
 |  | INV10007 |  | 2020-05-28 00:00:00 | 12500
 |  | INV10008 |  | 2020-05-29 00:00:00 | 17500
 |  | INV10009 |  | 2020-06-12 00:00:00 | 27500
 |  | INV10010 |  | 2020-06-17 00:00:00 | 37500
 |  | INV10011 |  | 2020-07-01 00:00:00 | 45000
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
PO99999 | 350000 | INV20001 |  | 2020-01-01 00:00:00 | 15000 | GBP
 |  | INV20002 |  | 2020-02-26 00:00:00 | 7500
 |  | INV20003 |  | 2020-03-07 00:00:00 | 9500
 |  | INV20004 |  | 2020-04-05 00:00:00 | 25000
 |  | [NAME] |  | 2020-04-12 00:00:00 | 27500
 |  | INV20006 |  | 2020-05-02 00:00:00 | 19500
 |  | INV20007 |  | 2020-05-10 00:00:00 | 14750
 |  | INV20008 |  | 2020-06-07 00:00:00 | 21000
 |  | INV20009 |  | 2020-06-09 00:00:00 | 32500
 |  | [NAME] |  | 2020-06-30 00:00:00 | 19750
 |  | INV20011 |  | 2020-07-19 00:00:00 | 22750
 |  | INV20012 |  | 2020-08-01 00:00:00 | 31000
 |  | INV20013 |  | 2020-08-19 00:00:00 | 12500
 |  | INV20014 |  | 2020-09-01 00:00:00 | 26750
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
Spreadsheet: 813546d1673850535-how-to-extract-a-list-without-duplicate-end-date-file-for-help
Sheet: Sheet5

employee_id | check_in_date | check_out_date | End Date | End Date | End Date | End Date | End Date | End Date | End Date | End Date | End Date | End Date | End Date
377490 | 2020-05-04 00:00:00 | 2020-06-01 00:00:00
377490 | 2020-06-01 00:00:00 | 2020-06-08 00:00:00
377490 | 2020-06-08 00:00:00 | 2020-06-15 00:00:00
377492 | 2020-08-11 00:00:00 | 2020-08-23 00:00:00
377499 | 2020-07-15 00:00:00 | 2020-09-10 00:00:00
377499 | 2020-09-10 00:00:00 | 2020-09-19 00:00:00
377503 | 2021-01-11 00:00:00 | 2021-01-26 00:00:00
377503 | 2021-05-03 00:00:00 | 2021-05-19 00:00:00
377505 | 2020-05-11 00:00:00 | 2021-03-06 00:00:00
377505 | 2021-03-06 00:00:00 | 2021-05-01 00:00:00
377505 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00
377505 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00
377505 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00
Spreadsheet: richard_sanders__32083__attachments
Sheet: Portfolio 3 - SP15 Longs

[NAME]: | [NAME] of Four Portfolio Bid that Was Ultimately Scheduled at Silver Peak
 | Initial Bid
 | Price | Quantity | Price | Quantity | Price | Quantity | Price | Quantity | Unconstrained | Accepted
Time | 0700 | 0700 | 0700 | 0700 |  |  |  |  | MCP | 0715
0100 | 0 | 0 | 2500 | 0 |  |  |  |  | 20.6554 | 0
0200 | 0 | 0 | 2500 | 0 |  |  |  |  | 18.3717 | 0
0300 | 0 | 0 | 2500 | 0 |  |  |  |  | 17.504 | 0
0400 | 0 | 0 | 2500 | 0 |  |  |  |  | 14.0569 | 0
0500 | 0 | 0 | 2500 | 0 |  |  |  |  | 18.9964 | 0
0600 | 0 | 0 | 2500 | 0 |  |  |  |  | 24.4967 | 0
0700 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 19.9428 | 725
0800 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 25.8947 | 725
0900 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 26.9196 | 725
1000 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 27.5973 | 725
1100 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 28.3814 | 725
1200 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 28.1807 | 725
1300 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 27.999 | 725
1400 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 28.7672 | 725
1500 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 28.9763 | 725
1600 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 28.1041 | 725
1700 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 28.1997 | 725
1800 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 27.0583 | 725
1900 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 26.5752 | 725
2000 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 25.6897 | 725
2100 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 29.2826 | 725
2200 | 0 | 0 | 19.34 | 0 | 19.35 | 725 | 2500 | 725 | 26.4872 | 725
2300 | 0 | 0 | 2500 | 0 |  |  |  |  | 25.9942 | 0
2400 | 0 | 0 | 2500 | 0 |  |  |  |  | 24.4942 | 0
Spreadsheet: 376924d1423749800-find-value-that-doesnt-match-and-bring-back-column-heading-find-value-that-doesnt-match-and-index-column-heading-150212-ndm-vxx
Sheet: Sheet1

Year 1 values |  | Year 2 Values |  | Values in Year 2 Not in Year 1 | Compacted List
Spreadsheet: 328459d1403901290-pivot-table-forecast-at-completion-based-on-actuals-to-date-ytd_calc_data
Sheet: Data

Month | Project ID | WorkStream ID | Task Name | Org | Resource | Planned Hours | Actual Hours | Planned Cost | Actual Cost
1 | P201 | WS268 | T1 | OA01 | Name 1 | 14 | 13 | 560
1 | P202 | WS298 | T2 | OA02 | Name 2 | 7 | 7 | 280
1 | P203 | WS299 | T3 | OA03 | Name 3 | 5 | 5 | 200
2 | P201 | WS268 | T1 | OA04 | Name 4 | 28 | 28
2 | P202 | WS269 | T2 | OA05 | Name 1 | 35 | 38
3 | P201 | WS269 | T3 | OA06 | Name 2 | 35 | 38
3 | P202 | WS268 | T1 | OA07 | Name 3 | 42 | 36
4 | P201 | WS299 | T4 | OA08 | Name 4 | 14 | 20
4 | P202 | WS268 | T1 | OA09 | Name 5 | 7 | 7
5 | P201 | WS298 | T3 | OA10 | Name 6 | 7 | 7
5 | P203 | WS268 | T2 | OA11 | Name 1 | 56 | 50
6 | P203 | [NAME] | T2 | OA12 | Name 2 | 49 | 60
6 | P204 | WS268 | T5 | OA01 | Name 4 | 49 | 56
6 | P205 | WS298 | T3 | OA03 | Name 4 | 50 | 50
7 | P202 | WS289 | T6 | OA02 | Name 5 | 14 | 0
7 | P203 | WS290 | T7 | OA05 | Name 6 | 48 | 0
7 | P204 | WS291 | T8 | OA04 | Name 7 | 48 | 0
7 | P205 | WS292 | T9 | OA12 | Name 3 | 56 | 0
8 | P201 | WS268 | T10 | OA14 | Name 5 | 112 | 0
8 | P204 | [NAME] | T11 | OA14 | Name 4 | 112 | 0
8 | P205 | WS298 | T12 | OA14 | Name 2 | 112 | 0
8 | P202 | WS299 | T13 | OA07 | Name 1 | 112 | 0
9 | P203 | WS290 | T1 | OA08 | Name 8 | 70 | 0
9 | P201 | WS291 | T2 | OA14 | Name 7 | 70 | 0
9 | P205 | WS292 | T3 | OA13 | Name 6 | 70 | 0
9 | P206 | WS298 | T4 | OA12 | Name 5 | 70 | 0
10 | P208 | [NAME] | T5 | OA11 | Name 10 | 126 | 0
10 | P207 | WS299 | T6 | OA01 | Name 11 | 126 | 0
10 | P204 | WS268 | T7 | OA05 | Name 12 | 140 | 0
10 | P201 | WS289 | T8 | OA06 | Name 9 | 140 | 0
10 | P202 | WS290 | T9 | OA06 | Name 8 | 98 | 0
11 | P202 | WS289 | T10 | OA09 | Name 10 | 98 | 0
11 | P203 | WS290 | T11 | OA09 | Name 6 | 98 | 0
11 | P204 | WS291 | T12 | OA03 | Name 11 | 98 | 0
11 | P205 | WS292 | T8 | OA02 | Name 12 | 98 | 0
12 | P202 | WS289 | T7 | OA01 | Name 1 | 140 | 0
12 | P208 | [NAME] | T5 | OA14 | Name 2 | 140 | 0
12 | P206 | WS268 | T4 | OA12 | Name 3 | 140 | 0
12 | P208 | WS292 | T1 | OA03 | Name 4 | 140 | 0