tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 876917d1723638360-copy-and-paste-data-if-today-is-within-x-days-of-y-date-gw_sample-file_v2
Sheet: Sheet1

 |  |  |  |  |  |  | Because today is within 30 days of cell G4, it would be relevant to put the values into G7:G11 | Values for columns J - O not available yet, but will populate in the future as quarters complete.  (But have created a hypothethical scenario for column J (using dummy data in cells A18:C27). However this date would overwrite A4:C14)  To exemplify further, data in H7:H11 is data that would previously been available by summing appropriate cells in C5:C14 (before they were replaced witht the data showing there now.
How this data looks now
Company | Investment | Amount repaid to date | Date last updated |  |  | Data check date | 2024-04-30 00:00:00 | 2024-07-31 00:00:00 | 2024-10-31 00:00:00 | 2025-01-31 00:00:00 | 2025-04-30 00:00:00 | 2025-07-31 00:00:00 | 2025-10-31 00:00:00 | 2026-01-31 00:00:00
AAA | A1 | 10 | 2024-08-07 00:00:00 |  |  | Quarter Start Date | 2024-01-01 00:00:00 | 2024-04-01 00:00:00 | 2024-07-01 00:00:00 | 2024-10-01 00:00:00 | 2025-01-01 00:00:00 | 2025-04-01 00:00:00 | 2025-07-01 00:00:00 | 2025-10-01 00:00:00
AAA | A2 | 20 | 2024-08-07 00:00:00 |  |  | Quarter End Date | 2024-03-31 00:00:00 | 2024-06-30 00:00:00 | 2024-09-30 00:00:00 | 2024-12-31 00:00:00 | 2025-03-31 00:00:00 | 2025-06-30 00:00:00 | 2025-09-30 00:00:00 | 2025-12-31 00:00:00
BBB | B1 | 5 | 2024-08-07 00:00:00 |  | Total repaid per company | AAA
BBB | B2 | 0 | 2024-08-07 00:00:00 |  |  | BBB
BBB | B3 | 0 | 2024-08-07 00:00:00 |  |  | CCC
CCC | C1 | 40 | 2024-08-07 00:00:00 |  |  | DDD
CCC | C2 | 40 | 2024-08-07 00:00:00
CCC | C | 40 | 2024-08-07 00:00:00
DDD | D1 | 12 | 2024-08-07 00:00:00
DDD | D2 | 15 | 2024-08-07 00:00:00
How this data might look on 31/10/2024
Company | Investment | Amount repaid to date
AAA | A1 | 40
AAA | A2 | 80
BBB | B1 | 20
BBB | B2
BBB | B3
CCC | C1 | 100
CCC | C2
CCC | C
DDD | D1 | 32
DDD | D2
How this data looked on 30/04/2024
Company | Investment | Amount repaid to date
AAA | A1 | 12
AAA | A2 | 30
BBB | B1 | 5
BBB | B2
BBB | B3 | 0
CCC | C1 | 0
CCC | C2 | 0
CCC | [NAME] | 5
DDD | D1 | 14
DDD | D2 | 16
Spreadsheet: 130184d1322115561-how-to-use-if-formula-for-change-price-copy-of-december
Sheet: 12

 |  |  |  | 2011-12-12 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 864855d1711989960-calculate-elapsed-time-in-days-hours-and-minutes-excluding-weekends-and-holidays-time-calculator-v3
Sheet: Time

DATE | TIME | DATE | TIME | Output | Day FIRST Date | Day LAST day date | Comments | Start on Weekend or Holiday | Hours FIRST Day | Hours LAST day | Hours SAME day (in/out) | Hours FISRT & LAST Day | NET hours |  | No of Work Days (incl Sat/  Sun/ Holidays START) |  |  | DEFAULTS | Values
2024-01-19 00:00:00 | 10:19:00 | 2024-02-02 00:00:00 | 13:14:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Time | 08:00:00
2024-01-25 00:00:00 | 09:30:00 | 2024-02-05 00:00:00 | 09:50:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End Time | 17:00:00
2024-01-24 00:00:00 | 11:00:00 | 2024-02-07 00:00:00 | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Work Day |  | hours per day
2024-01-29 00:00:00 | 15:15:00 | 2024-02-12 00:00:00 | 09:28:00
2024-01-29 00:00:00 | 09:00:00 | 2024-02-13 00:00:00 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12:00:00
2024-02-01 00:00:00 | 13:30:00 | 2024-02-16 00:00:00 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lunch End | 13:00:00
2024-02-12 00:00:00 | 13:30:00 | 2024-02-21 00:00:00 | 16:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2024-02-11 00:00:00 | 10:00:00 | 2024-02-22 00:00:00 | 16:45:00
2024-02-10 00:00:00 | 09:30:00 | 2024-02-10 00:00:00 | 15:00:00
2024-02-11 00:00:00 | 10:30:00 | 2024-02-11 00:00:00 | 16:00:00
2024-01-15 00:00:00 | 10:00:00 | 2024-01-29 00:00:00 | 10:01:00
2024-01-15 00:00:00 | 10:00:00 | 2024-01-29 00:00:00 | 10:01:00
2024-01-18 00:00:00 | 02:45:00 | 2024-01-29 00:00:00 | 15:00:00 |  |  |  | Start BEFORE work day start
2024-01-19 00:00:00 | 10:19:00 | 2024-02-02 00:00:00 | 13:14:00
2024-01-31 00:00:00 | 23:00:00 | 2024-02-02 00:00:00 | 13:40:00 |  |  |  | Start AFTER work day end
2024-01-26 00:00:00 | 10:00:00 | 2024-01-27 00:00:00 | 13:19:00
2024-01-27 00:00:00 | 07:00:00 | 2024-01-27 00:00:00 | 13:19:00
2024-01-28 00:00:00 | 17:40:00 | 2024-01-29 00:00:00 | 09:12:00 |  |  |  | Start AFTER work day end
2024-01-27 00:00:00 | 13:00:00 | 2024-01-29 00:00:00 | 09:12:00
2024-01-27 00:00:00 | 18:00:00 | 2024-01-29 00:00:00 | 09:12:00 |  |  |  | Start AFTER work day end
2024-01-28 00:00:00 | 10:36:00 | 2024-01-29 00:00:00 | 09:12:00
2024-01-23 00:00:00 | 15:00:00 | 2024-01-30 00:00:00 | 08:15:00
2024-02-01 00:00:00 | 11:30:00 | 2024-02-01 00:00:00 | 13:24:00
2024-02-09 00:00:00 | 10:00:00 | 2024-02-15 00:00:00 | 15:00:00
2024-02-03 00:00:00 | 10:00:00 | 2024-02-04 00:00:00 | 15:00:00
2024-02-05 00:00:00 | 10:00:00 | 2024-02-05 00:00:00 | 15:00:00
Spreadsheet: 874551d1721139595-matching-names-in-2-spreadsheets-sloopjohnb-test-2
Sheet: Clubs

Boat Nos | Club
 | Christchurch Model Yacht Club
 | Cromwell Radio Yacht Squadron
 | Gulf Harbour Radio Yacht Club
 | Kapiti Radio Yacht Club
 | Kerikeri Radio Yacht Squadron
 | Nelson Radio Sailing Club
 | New Plymouth Radio Control Yacht Club
 | New Zealand Radio Yachting Association
 | Northern Maritime Model Society
 | North Shore Radio Yacht Squadron
 | Otago Radio Yacht Club
 | Pegasus Radio Sailing Club
 | Tauranga Radio Sailing Club
 | Waiheke Island Radio Yacht Club
 | Waikato Radio Yacht Club
 | Westhaven Radio Sailing
Spreadsheet: 745032d1629705411-dynamically-fill-1-sheet-from-another-working-schedule-master-sample
Sheet: Pub-Page3

 | 2021-08-14 00:00:00 | 18:30:00 | MAN UTD | LEEDS UTD
MOTOGP | 2021-08-14 00:00:00 | 19:20:00 | QUALIFYING | SPIELBERG
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | BARNSLEY | COVENTRY CITY
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | BIRMINGHAM CITY | STOKE CITY
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | BLACKPOOL | CARDIFF CITY
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | HUDDERSFIELD | FULHAM
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | HULL CITY | QPR
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | MIDDLESBROUGH | BRISTOL CITY
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | MILLWALL | BLACKBURN
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | N FOREST | BOURNEMOUTH
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | READING | PRESTON N E
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 21:00:00 | WEST BROM | LUTON TOWN
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | BURNLEY | BRIGHTON
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | CHELSEA | C PALACE
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | EVERTON | SOUTHAMPTON
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | LEICESTER | WOLVES
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | WATFORD | A VILLA
RUGBY - INTERNATIONAL | 2021-08-14 00:00:00 | 22:00:00 | S AFRICA | ARGENTINA
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 23:30:00 | NORWICH | LIVERPOOL
GAA - SFC - SF | 2021-08-15 00:00:00 | 00:00:00 | MAYO | DUBLIN
CRICKET - 100 | 2021-08-15 00:00:00 | 01:00:00 | INVINCIBLES | SPIRIT
FOOTBALL - C'SHIP | 2021-08-15 00:00:00 | 02:00:00 | [NAME] | SHEFFIELD UNITED
FOOTBALL - LGE CUP | 2021-08-15 00:00:00 | 18:00:00 | RAITH ROVERS | ABERDEEN
MOTOGP | 2021-08-15 00:00:00 | 19:00:00 | SPIELBERG | 0
FOOTBALL - PREM LGE | 2021-08-15 00:00:00 | 20:00:00 | NEWCASTLE | WEST HAM
FOOTBALL - LGE CUP | 2021-08-15 00:00:00 | 21:00:00 | CELTIC | HEARTS
GAA - SFC - SF | 2021-08-15 00:00:00 | 21:30:00 | KERRY | TYRONE
FOOTBALL - PREM LGE | 2021-08-15 00:00:00 | 22:30:00 | TOTTENHAM | MAN CITY
NRL | 2021-08-15 11:00:00 | 11:00:00 | WARRIORS | BULLDOGS
NRL | 2021-08-15 13:05:00 | 13:05:00 | SHARKS | KNIGHTS
Spreadsheet: 112182d1308310683-dynamic-charts-in-excel-create-chart-with-the-last-12-entries-example_charting_4_using_offsets
Sheet: Summary_Indexing_Index

Month | Yld1 | Target | Yld2
2010-04-01 00:00:00 | 29897 | 0.95
2010-05-01 00:00:00 | 35192 | 0.95 | 0.9721546961325966 |  |  |  |  |  |  |  |  |  |  | chrtindex |  | INDEX(Summary_Indexing!$A:$A, MATCH(9E+307, Summary_Indexing!$A:$A)):INDEX(Summary_Indexing!$D:$D, [NAME], [NAME])
2010-06-01 00:00:00 | 35365 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  |  |  | INDEX(Summary_Indexing!$A:$A, MATCH(9E+307, Summary_Indexing!$A:$A)):INDEX(Summary_Indexing!$D:$D, [NAME], [NAME])
2010-07-01 00:00:00 | 28803 | 0.95 | 0.98
2010-08-01 00:00:00 | 28013 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | INDEX(Summary_Indexing!chrtindex,0,2)
2010-09-01 00:00:00 | 27343 | 0.95 | 0.97
2010-10-01 00:00:00 | 30088 | 0.95 | 0.97 |  |  |  |  |  |  |  |  |  |  | tblindex3 |  | INDEX(Summary_Indexing!chrtindex, 0, 3)
2010-11-01 00:00:00 | 28295 | 0.95 | 0.97
2010-12-01 00:00:00 | 32194 | 0.95 | 0.95 |  |  |  |  |  |  |  |  |  |  | tblindex4 |  | INDEX(Summary_Indexing!chrtindex,0,4)
2011-01-01 00:00:00 | 31690 | 0.95 | 0.98
2011-02-01 00:00:00 | 28039 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  | tblindexMonth |  | INDEX(Summary_Indexing!chrtindex,0,1)
2011-03-01 00:00:00 | 33277 | 0.95 | 0.92
2011-04-01 00:00:00 | 31114 | 0.95 | 0.9788198238734974
2011-04-01 00:00:00 | 30455 | 0.95 | 0.9788198238734974
2011-05-01 00:00:00 | 15 | 0.15 | 0.84
2011-06-01 00:00:00 | 30455 | 0.15 | 0.84
2011-07-01 00:00:00 | 30455 | 0.15 | 0.84
2011-05-01 00:00:00 | 30455 | 0.15 | 0.84
2011-09-01 00:00:00 | 30455 | 0.2 | 0.95
2011-09-01 00:00:00 | 30455 | 0.2 | 0.95 |  | 1 | SERIES(Summary_Indexing!$B$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex2,1)
 |  |  |  |  | 2 | SERIES(Summary_Indexing!$c$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex3,2)
 |  |  |  |  | 3 | SERIES(Summary_Indexing!$c$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex4,3)
Spreadsheet: 799334d1665050248-extract-information-from-different-sheets-in-a-workbook-sample-file
Sheet: Required Output

GroupName | UserID
ADGroup100 | test1
ADGroup100 | test2
ADGroup100 | test3
ADGroup100 | test4
ADGroup100 | test5
ADGroup200 | test4
ADGroup200 | test3
ADGroup200 | test5
ADGroup200 | test1
ADGroup200 | test2
ADGroup300 | test14
ADGroup300 | test13
ADGroup300 | test12
ADGroup300 | test11
ADGroup300 | test15
Spreadsheet: 6d5bc88e-1b93-49b1-ba88-c492acee0b84
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (5 [NAME]):
 | 8 Medizin/Gesundheitswesen 8.1 Diagnostika 8.1.3 Immunologische Diagnostika
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | BD BD Biosciences | Deutschland | Heidelberg | 69126 | A3.101/202
2 | Fraunhofer-Institut für Physikalische Messtechnik IPM | Deutschland | Freiburg | 79110 | A1.433/530
3 | Fraunhofer-Institut (ISIT) für [NAME] | Deutschland | Itzehoe | 25524 | A1.433/530
4 | Luminex B.V. | Niederlande | Oosterhout | 4906 CR | A3.311
5 | MicroCoat Biotechnologie GmbH | Deutschland | Bernried | 82347 | A3.262
Spreadsheet: 703146d1604782254-index-match-date-since-sale-ascending-sample_asc_desc
Sheet: Sheet1

ASCENDING (NOT WORKING) |  |  |  |  | DESCENDING (WORKING)
Date | Name | Days Since Sale |  |  | Date | Name | Days Since Sale
2008-08-29 00:00:00 | [NAME] |  |  |  | 2008-09-26 00:00:00 | [NAME]
2008-08-29 00:00:00 | [NAME] |  |  |  | 2008-09-26 00:00:00 | [NAME]
2008-08-30 00:00:00 | [NAME] |  |  |  | 2008-09-21 00:00:00 | [NAME]
2008-08-30 00:00:00 | [NAME] |  |  |  | 2008-09-21 00:00:00 | [NAME]
2008-08-31 00:00:00 | [NAME] |  |  |  | 2008-09-20 00:00:00 | [NAME]
2008-08-31 00:00:00 | [NAME] |  |  |  | 2008-09-20 00:00:00 | [NAME]
2008-08-31 00:00:00 | [NAME] |  |  |  | 2008-09-19 00:00:00 | [NAME]
2008-08-31 00:00:00 | [NAME] |  |  |  | 2008-09-19 00:00:00 | [NAME]
2008-09-12 00:00:00 | [NAME] |  |  |  | 2008-09-14 00:00:00 | [NAME]
2008-09-12 00:00:00 | [NAME] |  |  |  | 2008-09-14 00:00:00 | [NAME]
2008-09-13 00:00:00 | [NAME] |  |  |  | 2008-09-14 00:00:00 | [NAME]
2008-09-13 00:00:00 | [NAME] |  |  |  | 2008-09-14 00:00:00 | [NAME]
2008-09-14 00:00:00 | [NAME] |  |  |  | 2008-09-13 00:00:00 | [NAME]
2008-09-14 00:00:00 | [NAME] |  |  |  | 2008-09-13 00:00:00 | [NAME]
2008-09-14 00:00:00 | [NAME] |  |  |  | 2008-09-12 00:00:00 | [NAME]
2008-09-14 00:00:00 | [NAME] |  |  |  | 2008-09-12 00:00:00 | [NAME]
2008-09-19 00:00:00 | [NAME] |  |  |  | 2008-08-31 00:00:00 | [NAME]
2008-09-19 00:00:00 | [NAME] |  |  |  | 2008-08-31 00:00:00 | [NAME]
2008-09-20 00:00:00 | [NAME] |  |  |  | 2008-08-31 00:00:00 | [NAME]
2008-09-20 00:00:00 | [NAME] |  |  |  | 2008-08-31 00:00:00 | [NAME]
2008-09-21 00:00:00 | [NAME] |  |  |  | 2008-08-30 00:00:00 | [NAME]
2008-09-21 00:00:00 | [NAME] |  |  |  | 2008-08-30 00:00:00 | [NAME]
2008-09-26 00:00:00 | [NAME] |  |  |  | 2008-08-29 00:00:00 | [NAME]
2008-09-26 00:00:00 | [NAME] |  |  |  | 2008-08-29 00:00:00 | [NAME]
Spreadsheet: 701348d1603717756-sumif-formula-in-timesheet-excel-sumif
Sheet: DATABASE

DATE | START TIME | TOTAL TIME | TASK
2020-10-23 00:00:00 | 16:27:08 |  | TYPE 1
2020-10-23 00:00:00 | 13:53:56 |  | TYPE 1
2020-10-23 00:00:00 | 13:41:24 |  | TYPE 3
2020-10-23 00:00:00 | 13:03:40 |  | TYPE 1
2020-10-23 00:00:00 | 10:40:26 |  | TYPE 2
2020-10-23 00:00:00 | 10:40:13 |  | TYPE 2
2020-10-23 00:00:00 | 10:34:18 |  | TYPE 2
2020-10-23 00:00:00 | 09:43:37 |  | TYPE 2
2020-10-23 00:00:00 | 08:15:03 |  | TYPE 3
2020-10-22 00:00:00 | 16:14:49 |  | TYPE 3
2020-10-22 00:00:00 | 15:34:22 |  | TYPE 1
2020-10-22 00:00:00 | 15:18:25 |  | TYPE 4
2020-10-22 00:00:00 | 14:42:54 |  | TYPE 2
2020-10-22 00:00:00 | 14:00:48 |  | TYPE 5
2020-10-22 00:00:00 | 12:52:23 |  | TYPE 4
2020-10-22 00:00:00 | 11:49:18 |  | TYPE 5
2020-10-22 00:00:00 | 11:49:16 |  | TYPE 2
2020-10-22 00:00:00 | 11:49:14 |  | TYPE 4
2020-10-22 00:00:00 | 11:49:12 |  | TYPE 2
2020-10-22 00:00:00 | 11:49:10 |  | TYPE 3
2020-10-22 00:00:00 | 11:49:07 |  | TYPE 2
2020-10-22 00:00:00 | 11:49:05 |  | TYPE 1
2020-10-22 00:00:00 | 11:49:02 |  | TYPE 2
2020-10-22 00:00:00 | 11:31:53 |  | TYPE 1
2020-10-22 00:00:00 | 11:14:22 |  | TYPE 1
2020-10-22 00:00:00 | 11:14:14 |  | TYPE 1
2020-10-22 00:00:00 | 09:45:13 |  | TYPE 1
2020-10-22 00:00:00 | 09:06:34 |  | TYPE 1
2020-10-22 00:00:00 | 08:55:00 |  | TYPE 1
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2197 | -2135 |  | -25
2 | -2276 | -2135 | -4 | -25
3 | -2197 | -2135 |  | -25
4 | -2147 | -2135 |  | -25
5 | -2142 | -2135 |  | -25
6 | -2152 | -2135 |  | -25
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
index
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93989.4
2002-01-06 00:00:00
CBS Volume
 |  |  | 39070
Spreadsheet: 841654d1693835669-sort-to-group-like-entries-together-print-count-of-unique-entries-3-cols-for-excel-forum-group-print-col
Sheet: DJ Test--3 cols for Excel Forum

First Name | M.I. | Single Name | Married Name | Address | Address2 | City | State
 |  | Abrams |  |  |  | Beaverton | OR
 |  | [NAME] |  |  |  | Honolulu | HI
 |  | [NAME]
 |  | Adams |  |  |  | Pearl City | HI
 |  | Ah See |  |  |  | Honolulu | HI
 |  | [NAME] |  |  |  | Pearl City | HI
 |  | Ajimine
 |  | Akamine
 |  | Akase
 |  | Akiyama |  |  |  | Richmond | WA
 |  | [NAME]
 |  | [NAME] |  |  |  | Diamond Bar | CA
 |  | Anahori
 |  | [NAME]
 |  | Annas
 |  | Apau |  |  |  | Honolulu | HI
 |  | Arakaki |  |  |  | Honolulu | HI
 |  | Arciero |  |  |  | Shoreline | WA
 |  | Armitage
 |  | Asakura |  |  |  | Honolulu | HI
 |  | Asato |  |  |  | Honolulu | HI
 |  | Asato |  |  |  | Honolulu | HI
 |  | Auld |  |  |  | Los Angeles | CA
 |  | Barclay |  |  |  | Kapolei | HI
 |  | Barger
 |  | Barney |  |  |  | Honolulu | HI
 |  | Basker |  |  |  | Honolulu | HI
 |  | Beckman |  |  |  | [NAME] | HI
 |  | Bodine |  |  |  | Honolulu | HI
 |  | Boswell
 |  | [NAME]
 |  | Buffins |  |  |  | Honolulu | HI
 |  | Burdick, Jr.
 |  | Cambra |  |  |  | Cordova | TX
 |  | [NAME] |  |  |  | Kapaa
 |  | [NAME] |  |  |  | Aiea | HI
 |  | [NAME] |  |  |  | Honolulu | HI
 |  | [NAME] |  |  |  | Honolulu | HI
 |  | [NAME]
 |  | [NAME] |  |  |  | Honolulu | HI
 |  | Chatham |  |  |  | Randolph | MA
 |  | Chibana |  |  |  | Cypress | CA
 |  | Chibana |  |  |  | Honolulu | HI
 |  | [NAME] |  |  |  | Aiea | HI
 |  | Ching |  |  |  | Honolulu | HI
 |  | Ching |  |  |  | [NAME] | CA
 |  | Ching |  |  |  | Wailuku | HI
 |  | Chinn |  |  |  | Honolulu | HI
 |  | Cho |  |  |  | Atlantic Beach | FL
Spreadsheet: 709510d1608365071-help-me-to-use-another-cell-value-as-the-range-value-of-correl-or-similar-function-book2-excelforum
Sheet: Sheet2

2 | 200
2.5 | 245
2.8 | 146
3.5 | 185
3.8 | 158
4.3 | 131
4.76 | 104
5.22 | 77
5.68 | 50
6.14 | 366
6.6 | 290
7.06 | 80
7.52 | 50
7.98 | 165
7.6 | 125
7.2 | 85
6.8 | 45 |  | 16
6.4 | 5 |  | 15
6 | 25 |  | 8
5.6 | 166 |  | 4
5.2 | 185 |  | 5
Spreadsheet: michelle_lokay__26547__EOLTWdeals
Sheet: Report

Summary of Enron On Line (EOL) Deals for [NAME]
 | # of Deals |  | Total Volume |  | Reservation $ |  | Commodity $ |  | Total Revenue |  | [NAME] |  | [NAME]
[NAME]
Feb-01
Mar-01
Apr-01
May-01
[NAME]
Jul-01
Aug-01
Sep-01
Oct-01
[NAME]
Dec-01
2001 Totals
 | # of Deals |  | Total Volume |  | Reservation $ |  | Commodity $ |  | Total Revenue |  | [NAME] |  | [NAME]
Jan-02
Feb-02
Mar-02
Apr-02
May-02
Jun-02
Jul-02
Aug-02
Sep-02
Oct-02
Nov-02
Dec-02
2002 Totals
 | # of Deals |  | Total Volume |  | Reservation $ |  | Commodity $ |  | Total Revenue |  | [NAME] |  | [NAME]
NNG Totals |  |  |  |  |  |  |  |  |  |  | 11/00 thru 12/02
 | No. of Deals |  | Total MDQ |  | Total Demand |  | Total Comm |  | Total Revenue
Spreadsheet: 143701d1330529723-need-help-iif-formula-exceeded-nesting-limit-and-i-think-too-many-criteria-for-vlookup-excelforumhelp
Sheet: Data Sample

Invoice Date | CoCd | Doc.no. | PGR | [NAME] | Vendor Number | PO Creator | On last report | Report
2010-12-10 00:00:00 | 201 | 1030042293 | 273 | xxxx | 112066 | CPIERCE6 | YES
2011-03-24 00:00:00 | 201 | 1030051202 | 234 | xxxx | 148543 | NMASON2 | YES
2011-06-16 00:00:00 | 201 | 1030009862 | 222 | xxxx | 108977 | TSANTOE | YES | Client A
2011-06-23 00:00:00 | 201 | 1030011117 | [NAME] | xxxx | 120984 | RWEGNER | YES
2011-07-04 00:00:00 | 201 | 1030011699 | 234 | xxxx | 166290 | RBAINS2 | YES
2011-06-29 00:00:00 | 201 | 1030012672 | 233 | xxxx | 115466 | GQUINN | YES | Client B
2011-05-31 00:00:00 | 250 | 1030000548 | 233 | xxxx | 112066 | GQUINN | NO | Client B
2011-06-21 00:00:00 | 250 | 1030000735 | 20A | xxxx | 112066 | DTEMIRBULATO | NO
2011-07-15 00:00:00 | 201 | 1030014865 | 234 | xxxx | 112066 | GDAWES | YES
2011-07-15 00:00:00 | 201 | 1030014867 | 234 | Gxxx | 112066 | GDAWES | YES | Client K
2011-07-15 00:00:00 | 201 | 1030014869 | 234 | Gxxx | 112066 | GDAWES | YES | Client k
2011-03-29 00:00:00 | 201 | 1030016093 | 253 | xxxx | 112066 | ABURKE6 | YES
2011-07-28 00:00:00 | 201 | 1030016013 | 273 | xxxx | 112066 | DTEMIRBULATO | YES
2011-08-03 00:00:00 | 201 | 1030016266 | 233 | xxxx | 112066 | TTRUTESCU | YES
2011-08-19 00:00:00 | 201 | 1030018746 | 285 | Gxxx | 108977 | AJACKSON29 | YES | Client K
2011-08-20 00:00:00 | 201 | 1030019656 | 273 | xxxx | 120984 | GMARIS | YES
2011-08-20 00:00:00 | 201 | 1030019654 | 273 | xxxx | 120984 | GMARIS | YES
2011-08-30 00:00:00 | 201 | 1030019641 | [NAME] | xxxx | 120984 | MENEV | YES
2011-09-14 00:00:00 | 201 | 1030019959 | 233 | xxxx | 112066 | LPAVLENKO | YES
2011-08-31 00:00:00 | 201 | 1030020393 | 229 | xxxx | 108977 | DTEMIRBULATO | YES
2011-08-19 00:00:00 | 201 | 1030020392 | 254 | xxxx | 108977 | AKONASOVA | YES
2011-09-29 00:00:00 | 201 | 1030020629 | 254 | xxxx | 177635 | AJACKSON29 | YES
2011-09-27 00:00:00 | 201 | 1030020965 | 222 | xxxx | 115854 | LLEE56 | YES
2011-09-30 00:00:00 | 201 | 1030021335 | J06 | xxxx | 166770 | MENEV | YES
Spreadsheet: 678401d1589871319-formula-to-get-unique-data-excel-formula1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2500 | Expenses Airfare Jul-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 | Expenses Airfare Jun-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | Expenses Hotel Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Hotel Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700 | Expenses Hotel Jul-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | Expenses Hotel Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1250 | Expenses Hotel Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1100 | Expenses Hotel Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1300 | Expenses Hotel Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | Expenses Hotel Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 | Expenses Hotel Nov-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | Expenses Hotel Nov-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 600 | Expenses Hotel Dec-19
Spreadsheet: 94704d1294432495-update-several-cells-based-on-entry-form_upd
Sheet: Sheet1 (2)

Nb | Amt
1 | 10
2 | 10
3 | 10
4 | 10
5 | 10
6 | 10
7 | 10
8 | 10
9 | 10
10 | 10
11 | 10
12 | 10
13 | 10
 |  |  | http://www1.picturepush.com/photo/a/4793149/img/4793149.jpg
 |  |  | http://www3.picturepush.com/photo/a/4793201/img/4793201.jpg
Spreadsheet: 217698d1362154491-relative-calculations-copy-of-excel-relative-formula-calculations
Sheet: Sheet1

Group | Category | Value | Desired Calculation
1 | A | 1
1 | B | 2
1 | C | 8
1 | D | 7
1 | E | 16
1 | F | 1
1 | G | 30
2 | A | 2
2 | B | 28
2 | C | 14
2 | D | 8
2 | E | 28
2 | F | 6
2 | G | 7
3 | A | 0
3 | B | 5
3 | C | 20
3 | D | 13
3 | E | 10
3 | F | 1
3 | G | 11
Spreadsheet: 771739d1646827172-weekly-budget-variances-untitled-spreadsheet
Sheet: Sheet1

Date | Actual Sales | Budget Sales | Weekly Variance
2022-01-03 00:00:00 | 1 | 2
2022-01-04 00:00:00 | 2 | 2
2022-01-05 00:00:00 | 1 | 2
2022-01-06 00:00:00 | 2 | 2
2022-01-07 00:00:00 | 1 | 1
2022-01-08 00:00:00 | 2 | 2
2022-01-09 00:00:00 | 1 | 2
2022-01-10 00:00:00 | 1 | 2
2022-01-11 00:00:00 | 1 | 2
2022-01-12 00:00:00 | 1 | 2
2022-01-13 00:00:00 | 1 | 2
2022-01-14 00:00:00 | 1 | 2
2022-01-15 00:00:00 | 1 | 2
2022-01-16 00:00:00 | 1 | 2
Spreadsheet: 860288d1708442018-dynamic-dropdown-list-based-on-the-value-entered-in-the-adjacent-cell-andrews_sample-filtered-fixed-again
Sheet: Location

Employee ID | Location
EMP0023 | New York
EMP0023 | Berlin
EMP0023 | New Delhi
EMP0024 | New Delhi
EMP0025 | Berlin
EMP0025 | New York
EMP0025 | Beijing
EMP0025 | Mumbai
EMP0026 | Beijing
EMP0026 | Oslo
EMP0026 | Wengen
Spreadsheet: 93232d1292855356-in-a-pivot-table-copy-of-book2-2
Sheet: Sheet1

Month | Sold | Capacity
JAN | 807 | 1070
JAN | 2326 | 4188
JAN | 5035 | 7345
JAN | 1987 | 2915
FEB | 825 | 1362
FEB | 2022 | 3987
FEB | 2592 | 7416
FEB | 1614 | 2871
MAR | 612 | 1128
MAR | 1932 | 5202
MAR | 2259 | 8307
MAR | 1523 | 3156
APR | 508 | 1269
APR | 2997 | 8181
APR | 2532 | 9360