tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 154549d1336483449-how-to-change-the-value-result-when-changing-dates-example
Sheet: Sheet1

 | 2012-01-10 00:00:00 | 2012-02-10 00:00:00 | 2012-03-10 00:00:00 | 2012-04-10 00:00:00 | 2012-05-10 00:00:00 | 2012-06-10 00:00:00 | 2012-07-10 00:00:00 | 2012-08-10 00:00:00 | 2012-09-10 00:00:00 | 2012-10-10 00:00:00 | 2012-11-10 00:00:00 | 2012-12-10 00:00:00
 | 0.1 | 0.2 | 0.3 | 0.45 | 0.5 | 0.66 | 0.7 | 0.85 | 0.99 | 0.1 | 0.12 | 0.13
 | 2012-05-08 00:00:00
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44014

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44014
Number of cores |  | 4
Spare cores |  | 2
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | CVT Transducer
Panel Number | T44 PP |  | Panel Number |  | T44 FIE
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | T44 FIE | INITIAL
1 | 20/ADY441100 |  | TBX6:11 |  | [NAME]
2 | 20/ADY441101 |  | TBX6:12 |  | X10:2
3 | Spare
4 | Spare
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes | 2011-08-02 00:00:00 | See drawing - 2A fuse required in this circuit, confusing |  |  |  | DJC
Edition Notes | 2011-08-02 00:00:00 | Cable has been added by business |  |  |  | DJC
Spreadsheet: 68828d1269369032-using-min-and-max-function-to-find-times-endora75-sample
Sheet: Sheet 1

ID | Start Date & Time | End Date & Time
1 | 2010-03-18 01:25:26 | 2010-03-18 01:26:20
2 | 2010-03-11 16:15:58 | 2010-03-11 16:16:26
3 | 2010-03-08 11:55:31 | 2010-03-08 11:55:31
 | MINIMUM START | 01:25:26
 | MINIMUM END | 01:26:20
 | MAXIMUM START | 16:16:26
 | MAXIMUM END | 16:16:26
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: Table of Contents

CFTC Swaps Report
2012-11-30 00:00:00
Table of Contents
All Swaps
1. Gross Notional Outstanding by Cleared Status
2. Gross Notional Outstanding by Participant Type
3. Net Notional Outstanding by Cleared Status
4. Net Notional Outstanding by Participant Type
5. Transaction Ticket Volume by Cleared Status
6. Transaction Ticket Volume by Participant Type
7. Transaction Dollar Volume by Cleared Status
8. Transaction Dollar Volume by Participant Type
Swaps by Asset Class
Interest Rate Swaps
9a. Gross Notional Outstanding -  Product Type and Cleared Status
9b. Gross Notional Outstanding - Cleared - Supermajor Currency
9c. Gross Notional Outstanding - Cleared - Major Currency
9d. Gross Notional Outstanding - Cleared - Tenor
10a. Net Notional Outstanding - Product Type and Cleared Status
10b. Net Notional Outstanding - Cleared - Supermajor Currency
10c. Net Notional Outstanding - Cleared - Major Currency
10d. Net Notional Outstanding - Cleared - Tenor
11a. Transaction Ticket Volume - Product Type and Cleared Status
11b. Transaction Ticket Volume - Cleared - Supermajor Currency
11c. Transaction Ticket Volume - Cleared - Major Currency
11d. Transaction Ticket Volume - Cleared - Tenor
12a. Transaction Dollar Volume - Product Type and Cleared Status
12b. Transaction Dollar Volume - Cleared - Supermajor Currency
12c. Transaction Dollar Volume - Cleared - Major Currency
12d. Transaction Dollar Volume - Cleared - Tenor
Credit Default Swaps
13a. Gross Notional Outstanding - Product and Participant Type
13b. Gross Notional Outstanding - Product Type and Grade
14a. Net Notional Outstanding - Product and Participant Type
14b. Net Notional Outstanding - Product Type and Grade
15a. Transaction Ticket Volume - Product and Participant Type
15b. Transaction Ticket Volume - Product Type and Grade
16a. Transaction Dollar Volume - Product and Participant Type
16b. Transaction Dollar Volume - Product Type and Grade
Equity Swaps
17. Gross Notional Outstanding
18. Net Notional Outstanding
19. Transaction Ticket Volume
20. Transaction Dollar Volume
Other Commodity Swaps
21. Gross Notional Outstanding
22. Net Notional Outstanding
23. Transaction Ticket Volume
24. Transaction Dollar Volume
Spreadsheet: 888559d1739102493-tenor-need-to-increase-base-on-balance-installment-tenure-test
Sheet: Loan_ID

Loan ID | Name | Loan Date | Interest  % | Loan Amount | Tenor |  | Helper
L001 | Nutan Vishal Bhagare | 2024-12-19 00:00:00 | 2 | 20000 | 4
L002 | Suvarna N Gaikwad | 2025-02-21 00:00:00 | 2 | 40000 | 6
L003 | Rajjaka A Waghmode | 2025-03-26 00:00:00 | 2 | 30000 | 2
L004 | Surkekha A Kirgat | 2025-04-27 00:00:00 | 2 | 50000 | 8
L005 | Kamble | 2024-12-31 00:00:00 | 2 | 10000 | 5
L006 | [NAME] | 2025-01-21 00:00:00 | 2 | 15000 | 8
L007 | [NAME] | 2025-01-26 00:00:00 | 2 | 25400 | 6
L008 | Sunita R Madne | 2025-01-27 00:00:00 | 2 | 36582 | 4
L009 | [NAME] | 2024-12-01 00:00:00 | 2 | 18000 | 7
L010 | [NAME] | 2025-01-21 00:00:00 | 2 | 365480 | 3
Spreadsheet: 850798d1701159848-time-difference-incorrect-values-timestamp_capture_wrong_002
Sheet: Sheet1

Alm. Time | Ack. Time | Res. Time | Ack Time (in Mins) | Res. Time (in Mins) | Intended Values in Alm Time - Field
2023-10-01 10:00:00 | 2023-10-01 10:05:00 | 2023-10-01 10:45:00 |  |  | No Changes
2023-10-01 00:54:00 | 2023-10-01 00:56:00 | Open |  |  | No Changes
2023-09-30 23:27:00 | 2023-09-30 23:29:00 | 2023-09-30 23:38:00 |  |  | No Changes
2023-10-01 12:54:00 | 2023-10-01 12:55:00 | 2023-10-01 13:30:00 |  |  | No Changes
2023-10-01 05:00:00 | 2023-10-01 05:06:00 | 2023-10-01 05:27:00 |  |  | 6
2023-10-01 07:31:00 | 2023-10-01 07:35:00 | 2023-10-01 07:50:00 |  |  | No Changes
2023-10-01 09:14:00 | 2023-10-01 09:15:00 | 2023-10-01 09:24:00 |  |  | No Changes
2023-10-01 12:45:00 | 2023-10-01 12:48:00 | 2023-10-01 13:40:00 |  |  | 3
2023-10-01 11:48:00 | 2023-10-01 11:48:00 | Open |  |  | No Changes
2023-10-01 12:12:00 | 2023-10-01 12:12:00 | Open |  |  | No Changes
2023-11-26 20:25:00 | 2023-11-26 20:30:00 | 2023-11-26 20:38:00 |  |  | 5
2023-11-26 18:25:00 | 2023-11-26 18:29:00 | 2023-11-26 18:35:00 |  |  | No Changes
2023-11-27 00:28:00 | 2023-11-27 00:32:00 | Open |  |  | No Changes
2023-11-26 22:03:00 | 2023-11-26 22:05:00 | Open |  |  | No Changes
2023-11-27 00:30:00 | 2023-11-27 00:35:00 | 2023-11-27 02:00:00 |  |  | 5
2023-11-27 02:53:00 | 2023-11-27 02:55:00 | Open |  |  | No Changes
2023-11-26 23:56:00 | 2023-11-27 00:00:00 | Open |  |  | No Changes
2023-11-27 19:51:00 | 2023-11-27 19:55:00 | Open |  |  | No Changes
2023-11-27 03:45:00 | 2023-11-27 03:48:00 | Open |  |  | 3
2023-11-27 04:25:00 | 2023-11-27 04:27:00 | 2023-11-27 04:40:00 |  |  | 2
NA | NA | NA |  |  | No Changes
2023-11-27 19:21:00 | 2023-11-27 19:23:00 | 2023-11-27 20:29:00 |  |  | 2
Spreadsheet: 717337d1612597241-formula-for-data-validation-formule-05_02_21
Sheet: Foglio1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | data validation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good morning | ita
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | benvenuto in | ing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | welcome to
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | buon lavoro
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | good job
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | oggi è
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | today is
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sign.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | se T2 = ing U2 = W6 se T2 = ita U2 = V6
Spreadsheet: joe_parks__14555__quotesheet
Sheet: 12-26 morning

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
2001-12-26 09:28:22.430000 | Jan '02 | Natsource | Permian | Jan '02 | 10,000/d | -.205 @ -.195
 | Jan '02 | Natsource | Permian | Jan - Mar '02 | 10,000/d
 | Jan '02 | Natsource | Permian | Ap - Oct '02 | 10,000/d
2001-12-26 09:28:22.430000 | Jan '02 | Natsource | HSC | Jan '02 | 10,000/d | -.02 @ -.0175
2001-12-26 09:28:22.430000 | Jan '02 | Natsource | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-26 09:28:22.430000 | Jan '02 | Natsource | HSC | Ap - Oct '02 | 10,000/d | .0275 @ .0325
 | Jan '02 | Natsource | HSC | Ap - Oct '03 | 10,000/d
2001-12-26 09:28:22.430000 | Jan '02 | Natsource | HSC | Cal '02 | 10,000/d | .005 @ .0075
2001-12-26 09:28:22.430000 | Jan '02 | Natsource | HSC | Cal '04 | 10,000/d | .0025 @ .0075
2001-12-26 09:28:22.430000 | Jan '02 | Natsource | Waha | Jan '02 | 10,000/d | -.16 @ -.15
 | Jan '02 | Natsource | Waha | Jan - Mar '02 | 10,000/d
 | Jan '02 | Natsource | Waha | Ap - Oct '02 | 10,000/d
2001-12-26 09:35:45.170000 | Jan '02 | APB | Permian | Jan '02 | 10,000/d | -.21 @ -.20
2001-12-26 09:35:45.170000 | Jan '02 | APB | Permian | Jan - Mar '02 | 10,000/d | -.22 @
 | Jan '02 | APB | Permian | Ap - Oct '02 | 10,000/d
 | Jan '02 | APB | Permian | Cal '04 | 10,000/d
 | Jan '02 | APB | Permian | Cal '05 | 10,000/d
2001-12-26 09:35:45.170000 | Jan '02 | APB | HSC | Jan '02 | 10,000/d | -.02 @ -.0175
2001-12-26 09:35:45.170000 | Jan '02 | APB | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.0175
 | Jan '02 | APB | HSC | Ap - Oct '02 | 10,000/d
 | Jan '02 | APB | HSC | Nov '02 - Mar '03 | 10,000/d
 | Jan '02 | APB | HSC | Cal '02 | 10,000/d
 | Jan '02 | APB | HSC | Cal '03 | 10,000/d
 | Jan '02 | APB | HSC | Cal '04 | 10,000/d
2001-12-26 09:35:45.170000 | Jan '02 | APB | Waha | Jan '02 | 10,000/d | -.155 @ -.15
2001-12-26 09:35:45.170000 | Jan '02 | APB | Waha | Jan - Mar '02 | 10,000/d | -.16 @ -.1525
 | Jan '02 | APB | Waha | Ap - Oct '02 | 10,000/d
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | Permian | Jan '02 | 10,000/d | -.20 @ -.195
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | Permian | Jan - Mar '02 | 10,000/d | -.205 @ -.195
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | Permian | Ap - Oct '02 | 10,000/d | -.175 @ -.17
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | Permian | Nov '02 - Mar '03 | 10,000/d | [NAME]
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | HSC | Jan '02 | 10,000/d | -.0225 @ -.0175
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | HSC | Ap - Oct '02 | 10,000/d | .0275 @ .0325
 | Jan '02 | Prebon | HSC | Nov '02 - Mar '03 | 10,000/d
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | Waha | Jan '02 | 10,000/d | -.155 @ -.145
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | Waha | Jan - Mar '02 | 10,000/d | -.155 @ -.145
2001-12-26 09:35:45.170000 | Jan '02 | Prebon | Waha | Ap - Oct '02 | 10,000/d | -.1175 @ -.1125
 | Jan '02 | Prebon | Waha | Nov '02 - Mar '03 | 10,000/d
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.29.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-29 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 4 | 1 | 1 | 0 | 0 | 1 | 0
 | 5TH FL | 34 | 20 | 22 | 0 | 4 | 1 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 18 | 0 | 4 | 1 | 1 | 0 | 0 | 2.5 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 0.5 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-29 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 4 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 0 | 4 | 1 | 2 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 17 | 0 | 5 | 0 | 0 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 883449d1732075436-calculating-percentage-returns-over-different-intervals-meditations-experimentation
Sheet: Monthly Returns

Date_T1 | 2024-01-02 00:00:00
Date_T2 | 2024-11-18 00:00:00
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | January | February | March | April | May | June | July | August | September | October | November | December
AMD
AVGO
NVDA
BRO
MMC
CMG
AAPL
MSFT
MA
V
MCO
BAC
JPM
COST
LULU
TSMC
TSLA
WKHS
SPY
VOO
 | =IF(AND(VALUE(LEFT('Monthly Returns'!$B$2,FIND("/",$B$2)-1))='Historical Data'!$W:$W,VALUE(RIGHT('Monthly Returns'!$B$2,4)),'Historical Data'!$V:$V),1,0)
 | =INDEX('Historical Data'!$B$1:AE1260,SMALL(IF((VALUE(LEFT($B$2,FIND("/",$B$2)='Historical Data'!$W:$W)*(VALUE(RIGHT('Monthly Returns'!$B$2,4))='Historical Data'!$V:$V),ROW(A:A),""),1))
 | =INDEX(E:E,SMALL(IF((A1>=C:[NAME]:D),ROW(A:A),""),1))
 | INDEX('Historical Data'!$B$1:U1260,MINIFS('Historical Data'!$B:$B,'Historical Data'!$X:$X,VALUE(LEFT('Monthly Returns'!$B$2,FIND("/",'Monthly Returns'!$B$2)-1)),'Historical Data'!$W:$W,VALUE(RIGHT('Monthly Returns'!$B$2,4))),MATCH('YTD Returns'!$A5,'Historical Data'!$B$1:$U$1,0))
 | =MINIFS('Historical Data'!$B:$B,'Historical Data'!$X:$X,VALUE(LEFT('Monthly Returns'!$B$2,FIND("/",'Monthly Returns'!$B$2)-1)),'Historical Data'!$W:$W,VALUE(RIGHT('Monthly Returns'!$B$2,4)))
Spreadsheet: 731570d1620414795-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: IOTA

S.N. | Particulars | Bought  Units | Unit or IOTA Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | IOTA @ Binance - Purchase | 250.749 | 0.00022559 |  | -0.05646998 | 11660 | 2017-12-04 00:00:00 | 2017-12-04 00:00:00
2 | IOTA @ Binance - Sale 1 | -150 | 0.0003689 |  | 0.055344 | 11711.2 | 2017-12-05 00:00:00
3 | IOTA @ Binance - Sale 2 | -4 | 0.00035903 |  | 0.0014414 | 13725.5 | 2017-12-06 00:00:00
4 | IOTA @ Binance - Purchase | 409.59 | 0.00023309 |  | -0.09556676 | 12745 | 2018-01-20 00:00:00 | 2018-01-20 00:00:00
5 | IOTA @ Binance - Sale | -506 | 0.00015434 |  |  | 10009.88 | 2018-03-07 00:00:00
6
7
8
9
10
11
 | Next Buy
 | IOTA in [NAME] | 0
 | IOTA in Binance | 0.339
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 220415da-8ef4-4baa-a4d2-76d1def79358
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2009-06-01 00:00:00 | 468 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2009-06-01 00:00:00 | 432 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2009-06-01 00:00:00 | 432 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2009-06-01 00:00:00 | 468 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2009-06-01 00:00:00 | 432 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 849885d1700248019-finding-unique-data-unique-list
Sheet: Sheet1

From the list below I want to be ablue to total value by client and by assignment, but then more specifically highlight the client where it only has one assignment associated to it, for example, PQR only has Education.
The idea is that I'm able to identify a client that is only engaged to complete one type of assignment and not a mixture of assignments.
Client | Assignment | Value
ABC | Crafting | 5 |  |  |  |  |  |  |  |  | Education
ABC | Projects | 10 |  | DEF | 60 |  | DEF | 4
ABC | [NAME] | 15 |  | GHI | 75 |  | GHI | 3
ABC | Education | 20 |  | JKL | 50 |  | JKL | 3
ABC | Education | 25 |  | MNO | 55 |  | MNO | 2
DEF | Crafting | 30 |  | PQR | 110 |  | PQR | 1
DEF | Projects | 5 |  | STU | 45 |  | STU | 3
DEF | [NAME] | 10 |  | VWX | 165 |  | VWX | 4
DEF | Education | 15
GHI | Education | 20
GHI | Crafting | 25
GHI | Projects | 30
JKL | [NAME] | 5
JKL | Education | 10
JKL | Education | 15
JKL | Crafting | 20
MNO | Projects | 25
MNO | [NAME] | 30
PQR | Education | 5
PQR | Education | 10
PQR | Education | 15
PQR | Education | 20
PQR | Education | 25
PQR | Education | 30
PQR | Education | 5
STU | Education | 10
STU | Crafting | 15
STU | Projects | 20
VWX | [NAME] | 25
VWX | Education | 30
VWX | Education | 5
VWX | Crafting | 10
VWX | Projects | 15
VWX | [NAME] | 20
VWX | Education | 25
VWX | Education | 30
VWX | Crafting | 5
Spreadsheet: 170235d1343216288-how-to-transpose-data-so-they-can-be-used-for-pivot-analysis-how_to_separate
Sheet: Sheet1

Vendor | Price | Source lg 1 | Source lg 2 | Source lg 3 | Source lg 4 | Traget lg 1 | Traget lg 2 | Traget lg 3 | Traget lg 4
Person A | 4 | en | de | fr | nl | lv | ru | en | de
Person B | 5 | en |  |  |  | lv
Person C | 7 | en | de |  |  | lv | ru
Person C | 8 | hu |  |  |  | lv | ru
Person D | 10 | de | sv |  |  | ru | sv | de
The outcome for pivot should look like this:
 | Person C | en | lv | 7
 | Person C | de | lv | 7
 | Person C | en | ru | 7
 | Person C | de | ru | 7
 | Person C | hu | lv | 8
 | Person C | hu | ru | 8
Spreadsheet: 57969d1258227583-if-and-or-formula-sd7000
Sheet: Sheet1

d4 | d5 | result
7 | x | h8 | 7 | h8
 | x | x | 3
7 | 2 | h8
7 | 3 | h8
 | 2 | v8
 | 3 | v8
7 | 1
7
H8
Spreadsheet: vladi_pimenov__41007__EOL_Product_Listen
Sheet: 1

 | Nymex promt |  |  |  | Cash-futures spread |  |  |  |  |  |  | NYMEX
 |  |  |  |  |  |  | BASIS |  |  |  |  | Bid | Offer
 |  | Cash | HH sprd | BOM | HH sprd | Promt | Oct | Nov-Mar |  |  | Promt
E    G | HeHub |  |  |  |  |  |  |  |  |  | Oct
A    U | [NAME] 65 |  |  |  |  |  |  |  |  |  | Nov-Mar 01-02
S    L | Col Onshore |  |  |  |  |  |  |  |  |  | Cal' 02
T      F | TETCO ELA
E    M |  | Cash | HH sprd | BOM | HH sprd | Promt | Oct | Nov-Mar |  |  |  | SPREADS
A    A | [NAME] |  |  |  |  |  |  |  |  |  |  | Bid | Offer
S    R | TETCO M3 |  |  |  |  |  |  |  |  |  | Oct--Sep
T    K | TCO |  |  |  |  |  |  |  |  |  | (Nov-Mar)-Promt
E | CNG
T
 |  |  |  |  |  |  | BASIS |  |  |  |  | POWER PRICES
C    M |  | Cash | HH sprd | BOM | HH sprd | Promt | Oct | Nov-Mar |  |  | Next week | [NAME] | Promt | Next day
E    A | [NAME] |  |  |  |  |  |  |  |  | NY Pool NYC
N    R | Consumers
T    K | MichCon |  |  |  |  |  |  |  |  | PJM West
R    E | Dawn
A    T | [NAME] |  |  |  |  |  |  |  |  | Cinergy
L
 |  |  |  |  |  |  | BASIS |  |  |  |  | ResidOil Platts No 6 NYH 1% (per MMBTU)
 |  | Cash | HH sprd | BOM | HH sprd | Promt | Oct | Nov-Mar |  |  |  | Bid | Offer
W | PG&E citygate |  |  |  |  |  |  |  |  |  | promt
E | Socal Topk |  |  |  |  |  |  |  |  |  | promt +1
S | CIG Rky Mtn
T | Waha
Spreadsheet: 115696d1311230138-if-identical-value-found-in-two-cells-different-spreadsheets-then-update-main-sheet-dailyreportdata
Sheet: Sheet1

IP Address | Last Date Referenced
192.168.45.10 | 2011-07-21 05:40:00
192.168.45.11 | 2011-07-21 05:40:00
192.168.45.16 | 2011-07-21 05:40:00
192.168.45.17 | 2011-07-21 05:40:00
192.168.45.18 | 2011-07-21 05:39:59.995000
192.168.45.19 | 2011-07-21 05:39:59.995000
192.168.45.20 | 2011-07-21 05:39:59.995000
192.168.45.21 | 2011-07-21 05:39:59.995000
192.168.45.22 | 2011-07-21 05:39:59.995000
192.168.45.26 | 2011-07-21 05:39:59.995000
192.168.45.27 | 2011-07-21 05:39:59.995000
192.168.45.28 | 2011-07-21 05:39:59.995000
192.168.45.29 | 2011-07-21 05:39:59.995000
192.168.45.30 | 2011-07-21 05:39:59.995000
192.168.45.32 | 2011-07-21 05:39:59.995000
192.168.45.33 | 2011-07-21 05:39:59.995000
192.168.45.34 | 2011-07-21 05:39:59.995000
192.168.70.100 | 2011-07-18 18:45:00
[NAME] | 2011-07-18 18:45:00
192.168.70.116 | 2011-07-18 18:45:00
192.168.70.118 | 2011-07-18 18:45:00
192.168.70.119 | 2011-07-18 18:45:00
192.168.70.120 | 2011-07-18 18:45:00
10.12.15.6 | 2011-06-10 13:20:00
10.12.15.7 | 2011-07-19 03:20:00
10.12.15.8 | 2011-07-19 03:20:00
10.60.20.1 | 2011-07-19 03:20:00
10.60.20.2 | 2011-07-19 03:20:00
10.60.20.3 | 2011-06-10 13:19:59.995000
10.60.20.10 | 2011-06-10 13:19:59.995000
10.60.20.12 | 2011-06-10 13:19:59.995000
10.60.20.254 | 2011-01-01 00:00:00
Spreadsheet: 586861d1534692183-how-to-get-specific-rows-in-a-worksheet-copied-from-another-coloured-backgrounds
Sheet: Outgoing No Gaps

Date | Title | Money