tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 48760d1248064656-search-and-highlight-only-containing-text-search-engine-new
Sheet: MY REQUIREMENT

 | SEARCH RESULT
 | ITEM# | VENDOR NAME | ERP PART NUMBER | ERP VENDOR CODE | NIMS PART #
 | 605776 | SADIQ ENGINEERING WORKS | 28409B79500P | 30251001 | 28409-79500
 | 606045 | SAEED METAL WORKS | 65205B79601P | 30258001 | 65205-79601
 | 606046 | SAEED METAL WORKS | 65206B79501P | 30258001 | 65206-79501
 | 606048 | SAEED METAL WORKS | 65215B79501P | 30258001 | 65215-79501
 | 622021 | SADIQ ENGINEERING WORKS | 61515B84001P | 30251001 | 61515-84001
 | 650372 | ZAIB ENGINEERING WORKS | 62300B76G13P | 30294001 | 62300-76G13
 | 650466 | BADAR-E-TAUSIF ENGINEERING WORKS | 63312B77G00P | 30062001 | 63312-77G00
 | 650467 | BADAR-E-TAUSIF ENGINEERING WORKS | 63712B77G00P | 30062001 | 63712-77G00
 | 650495 | ZAIB ENGINEERING WORKS | 61190B76G00P | 30294001 | 61190-76G00
 | 650496 | JAVED STEEL MANUFACTURING WORKS | 61530B76G01P | 30129001 | 61530-76G01
 | 650496 | SHAHEEN ENGINEERING WORKS | 61530B76G01P | 30233001 | 61530-76G01
 | 650497 | JAVED STEEL MANUFACTURING WORKS | 61536B76G01P | 30129001 | 61536-76G01
 | 650497 | SHAHEEN ENGINEERING WORKS | 61536B76G01P | 30233001 | 61536-76G01
Spreadsheet: 0633a02a-86e6-49e2-adf6-78ae2a7ea888
Sheet: Del Tax General Obligation Note

WASHTENAW  COUNTY  DELINQUENT  TAX  NOTES
Debt Service Schedule
2013-12-31 00:00:00
 | Del Tax 5320 |  | Del Tax 5310 |  | Del Tax 5330 |  | Total
 | Principal | Interest | Principal | Interest |  |  | Principal | Interest
2014 | 4000000 | 31500 | 1500000 | 12375 | 8000000 | 34125
2015 |  |  |  |  | 3500000 | 9625
Balance at 12-31-13
Del Tax 5330
Issuance Date | 2013-05-15 00:00:00
Issuance Amount | 16000000
Balance 12/31/13
Del Tax 5320
Issuance Date | 2012-05-30 00:00:00
Issuance Amount | 20000000
Balance 12/31/13
Del Tax 5310
Issuance Date | 2011-05-19 00:00:00
Issuance Amount | 27500000
Balance 12/31/13
Repayment Source:
delinquent tax revenues are pledged to repay the delinquent tax notes.
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 23

Uke: | 23 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 51818d1251414471-locking-cell-data-from-different-sheets-linking-test
Sheet: Sheet1

Date | Week |  |  | Overtime
2009-08-24 00:00:00 | 35 |  |  | 0
2009-08-31 00:00:00 | 36 |  |  | 0
2009-09-07 00:00:00 | 37 |  |  | 6
2009-09-14 00:00:00 | 38 |  |  | 0
2009-09-21 00:00:00 | 39 |  |  | 0
2009-09-28 00:00:00 | 40 |  |  | 0
2009-10-05 00:00:00 | 41 |  |  | 0
2009-10-12 00:00:00 | 42
Spreadsheet: 169413bc-73c1-4091-8b55-797513af29ab
Sheet: Sheet1

DR/CR | G/L Account | Amount | Cost Center | Internal Order | WBS Element | Fund | Business Area | Grant | Functional Area | Text | Assets | [NAME] | Earmarked funds | EF-Line Item | Value date | [NAME] | [NAME] | Material | Assignment
40 | 532000 | 554.04 | WAMC000001 |  |  |  |  | NOT-RELEVANT
50 | 141210 | 554.04 |  |  |  | 602000 | WA00 | NOT-RELEVANT
Spreadsheet: 148100d1333134432-if-names-in-one-column-match-another-insert-email-example-email-insert2
Sheet: Sheet1

COMPANY ROSTER
Full Name | Last Name | First Name | [NAME] | Training
 | [NAME] | [NAME] | [EMAIL] | Yes
 | [NAME] | [NAME] | [EMAIL] | Yes
 | Jones | Amanda | [EMAIL] | Yes
 | Saunders | [NAME] | [EMAIL]
 | Smith | Fred | [EMAIL]
 | Smith | Zach | [EMAIL]
Spreadsheet: 39867d1238132431-billing-in-excel-using-macro-tracking-bill
Sheet: Sheet1

 | Date: | 2009-03-27 00:00:00
 | [NAME] No: | 1
S.n | Item Code | Items | Qty | Price | Total
1 | 1 | [NAME] | 1 | 3 | 3
2 | 2 | [NAME] | 2 | 5 | 10
3 | 3 | Naan | 4 | 7 | 28
4 | 4 | [NAME] | 2 | 10 | 20
5 | 30 | Tandoori Chiken-Half | 3 | 45 | 135
6 | 27 | [NAME] | 2 | 44 | 88
 |  | SubTotal: |  |  | 284
 |  |  |  | vat-10% | 28.4
 |  |  |  | Total | 312.4
HAVE A NICE DAY -VISIT AGAIN
Spreadsheet: 747399d1631473621-conditional-formatting-max-value-with-second-condition-cond-format-test
Sheet: Sheet1

Member |  |  |  |  |  |  |  |  |  |  |  | Total
N |  |  |  |  |  |  | 7
Y |  | 5 |  |  |  |  |  |  |  | 5
N |  | 7
N | 9 | 1 |  | 9 | 9 |  | 9 |  | 9 | 7
Y |  | 3
Y |  |  | 9
N |  | 10
Y | 7 |  |  | 9 |  | 3 | 5 |  | 7 | 9
Spreadsheet: 748563d1632218266-check-if-time-range-is-within-another-time-range-example2-1-kvs
Sheet: Sheet1

Test | Name | 08:00-16:00
Different | Name | 08:00-16:00
Test | Name | HOL |  |  |  |  | {=IF(ISNUMBER(SEARCH("*Test*";$A$2));IF(IFERROR(VALUE(RIGHT(C$2;5))>VALUE(LEFT(C$2;5)););IF(IFERROR(AND(VALUE(LEFT(C$2;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$2;5))>=VALUE(RIGHT($B13;5))););1;0);IF(IFERROR(AND(VALUE(LEFT(C$2;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$2;5))+"24:00:00">=VALUE(RIGHT($B13;5))););1;0)))
Test | Name | 16:00-24:00 |  |  |  |  | {+IF(ISNUMBER(SEARCH("*Test*";$A$3));IF(IFERROR(VALUE(RIGHT(C$3;5))>VALUE(LEFT(C$3;5)););IF(IFERROR(AND(VALUE(LEFT(C$3;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$3;5))>=VALUE(RIGHT($B13;5))););1;0);IF(IFERROR(AND(VALUE(LEFT(C$3;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$3;5))+"24:00:00">=VALUE(RIGHT($B13;5))););1;0)))
Test | Name | HOL
Test | Name | 08:00-16:00 |  |  |  |  | As you can see the only thing that changed is, column A row number and columns C row number
Test | Name | 08:00-16:00
Test | Name | 08:00-16:00
Test | Name | 08:00-16:00 |  |  |  | Problem | I have to do + untill I reach this 10th row which makes my formula too long if more rows will be added in the future
 |  |  |  |  |  | Question | How to shorten the formula, so I can for example check 50+ rows in the future
 |  | [NAME] | C4 | C5 | C6 | c7 | C8 | C10
 | 08:00-09:00
 | 09:00-10:00
 | 10:00-11:00
 | 11:00-12:00
 | 12:00-13:00
 | 13:00-14:00
 | 14:00-15:00
 | 15:00-16:00
 | 16:00-17:00
 | 17:00-18:00
 | 18:00-19:00
 | 19:00-20:00
 | 20:00-21:00
 | 21:00-22:00
 | 22:00-23:00
 | 23:00-24:00
Spreadsheet: 0d4adfa8-118d-43ef-9d22-5e06aeb68fe5
Sheet: Sheet1

A.V. BRANDS, INC.
ADAMBA IMPORTS INT'L INC
ANSON IMPORTS
BACARDI MARTINI, USA
BACMAR INTERNATIONAL LLC
BANFI PRODUCTS CORP
BARTON BRANDS
BEAM WINE ESTATES
BMC IMPORTS
CALIFORNIA TEQUILLA LLC
[NAME]
CHRISTIANIA/MHW LTD
COGNAC FERRAND
[NAME], LTD
DIAGEO CHATEAU & ESTATE
[NAME] SPIRITS
DISTILLERIE STOCK
DORADO PIZZORNI& SONS
ENCORE BRANDS LLC
EVATON, INC
FOUR ROSES DISTILLERY LLC
FRANK PESCE INT'L GROUP
FREDERICK WILDMAN
FUTURE BRANDS LLC
HEAVEN HILL DISTILLERIES, INC.
IMPERIAL BRANDS, INC
LEBLON, LLC/MHW LTD
LIQUID INT'L PREMIUM SPIRITS
LUXCO
MAINE DISTILLERS LLC
MHW, LTD/VINOMEX
MHW/MONTECRISTO RUM
MHW LTD/VIRIDIAN SPIRITS
MOET HENNESSY
[NAME]
MONTEBELLO BRANDS INC
MYSTIQUE BRANDS LLC
NOLET SPIRITS USA
PALM BAY IMPORTS
PARAMOUNT DISTILLERS, INC.
[NAME]
PATRON SPIRITS COMPANY, THE
PERNOD-RICARD
PHILLIPS PRODUCT COMPANY
REMY COINTREAU USA INC
ROYAL WINE CORP
SAZERAC
SHAW ROSS INTERNATIONAL
SIDNEY FRANK
SKYY SPIRITS, LLC
SPEYSIDE IMPORTING COMPANY
USA WINE IMPORTS
VINEONE
WILSON DANIELS LTD
Spreadsheet: 673486d1587403532-counting-amount-of-days-between-two-dates-example12
Sheet: Date Contacted

Patient ID | Date Contacted | Days Before Buying Something
1234 | 2019-01-03 00:00:00 | 0
1234 | 2019-01-10 00:00:00 | 0
1234 | 2019-02-02 00:00:00 | 0
1234 | 2020-02-18 00:00:00 | 0
1234 | 2019-03-01 00:00:00 | 0
789 | 2020-01-02 00:00:00 | 13
789 | 2020-02-01 00:00:00 | 17
789 | 2020-03-01 00:00:00 | 0
456 | 2020-02-04 00:00:00 | 1
456 | 2020-02-07 00:00:00 | 0
456 | 2020-02-10 00:00:00 | 0
456 | 2020-02-13 00:00:00 | 0
1111 | 2019-05-08 00:00:00 | 0
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 11d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | <100 | <100 | <100 | 112 | 140 | 120 | <100 | 372
FRA | 4148 | 4084 | 2480 | 2604 | <100 |  |  | 13316
IRS- [NAME] | <100 | <100 | 170 | 1287 | 5569 | 6475 | 8495 | 21996
OIS | 234 | 158 | 104 | 560 | <100 |  |  | 1056
VNS |  |  |  |  |  |  | <100 | <100
Zero Coupon | <100 | <100 | <100 | <100 | <100 | <100 | <100 | <100
TOTAL | 4382 | 4242 | 2754 | 4563 | 5709 | 6595 | 8495 | 36740
Estimated swap transaction volumes, week ending November 16, by product type and tenor (in number of transactions), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for tenor bucket descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 209573d1359138738-multi-data-validation-data-validation
Sheet: Sheet1

tom | yellow
Person | Color | [NAME]
Rich | red | bike
Rich | blue | cars
Rich | orange | motorcycle
[NAME] | yellow | book
[NAME] | green | coat
[NAME] | pink | ipad
[NAME] | black | laptop
I want the yellow highlighted drop down list to give the options that correspond to the persons name.
Basically need col 2 and 3 to make drop down lists to correspond to the choice in col 1
Spreadsheet: 808528d1670507627-if-error-formular-does-not-work-grade-676-mpyaa
Sheet: WANAFUNZI 5 BORA NA 5 DUNI

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA MUHULA WA PILI  DARASA LA V  NOVEMBA,2022
E. WANAFUNZI 5 BORA
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
[NAME] DUNI
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 53723d1253639232-dynamic-questions-bank-temp
Sheet: inputQ

Question | Answer | JCODE / price
 | 5 | <-doesn’t need a jcode
 | 100 | <--doesn’t need a jcode
 | Yes | >echo correspodning 'num' row here<
 | Yes |  | <---this is what I have now to lookup a jcode in the jcode sheet(which is downloaded from a database)
Spreadsheet: 794234d1661952701-vlookup-with-multiple-conditions-template-mock
Sheet: Material

Material | Decimal | Bend Allowance
11 | 0.1233 | 0.1875
14 | 0.0785 | 0.125
16 | 0.0635 | 0.125
18 | 0.0516 | 0.0876
20 | 0.0396 | 0.0625
22 | 0.0336 | 0.0625
Spreadsheet: 269217d1381060561-typical-lookup-function-for-getting-desired-result-sample
Sheet: Sheet1

Date | Name of Product | Quantity(Pcs)
2013-07-17 00:00:00 | X | 3
 | N | 250
2013-07-19 00:00:00 | V | 100 |  |  |  |  |  | 50 | 1Chair
2013-08-15 00:00:00 | D | 0 |  |  |  |  |  | 100 | 5Chair
2013-07-17 00:00:00 | X | 20 |  |  |  |  |  | 150 | 2Hero Honda
 | C | 700 |  | X
 | X | 36
 | X | 75
 | ABD | 250
2013-07-17 00:00:00 | X | 5
 | G | 2500
 | A | 1500
 | B | 500
2013-07-17 00:00:00 | D | 500
Spreadsheet: 53645d1253578784-get-non-repeated-info-from-another-sheet-that-has-repetitions-lat-and-long-test
Sheet: Sheet1

Name | Code | Year | Latitude | Longitude
Big Farm | A-1 | 2008 | N 0º 1" 1" | W 90º 3" 3"
Big Farm | A-1 | 2009 | N 0º 1" 2" | W 90º 3" 4"
Little Farm | A-2 | 2008 | 80.32564 | 7.3215
Medium Farm | A-3 | 2009 | 3.2654 | 4.5464
Tiny Farm | B-4 | 2008 | 5.265654 | 1.1
Tiny Farm | B-4 | 2007 | 5.265654 | 1.1
Tiny Farm | B-4 | 2009 | 5.265654 | 1.1
Spreadsheet: 755680d1637025969-daily-totals-from-the-1st-tab-are-auto-populated-on-the-2nd-tab-based-on-today-totals-produced-using-offset-and-indirect-adamuksaint1-
Sheet: Daily

DATE: | 2021-11-11 00:00:00
SCOTLAND
S.EAST
COVENTRY
FITZ
MERSEY
NORMANTON
PLYMOUTH
SWANSEA
BRISTOL
I.O.W.
TUFFNELLS
BROWNS
[NAME]
KT ALB
TOTAL:
Spreadsheet: 491122d1480330730-in-pivot-lornalouw
Sheet: SSCC - GROUPED SUMMARY

FNB Sales and Service Contact Centre
Call Transfer Summary for the Period: 201610
Sales |  |  | * only displaying values > 3%
Skill Group | Calls Answered | Calls Transferred | % Trf | % Trf to Answer, per Area | % Trf to Total Answer
FNB DIRECT CARD – LIMITS AND UPGRADES | 13963 | 100 | 0.4291845493562232 | 0.007161784716751414 | 0.001694254782034122
DS FAST APP (CISS) | 24405 | 65 | 0.278969957081545 | 0.002663388649866831 | 0.001101265608322179
RETENTION PREMA | 6523 | 25 | 0.1072961373390558 | 0.003832592365476008 | 0.0004235636955085306
OD REFERRALS | 1699 | 15 | 0.06437768240343347 | 0.008828722778104767 | 0.0002541382173051183
DS FULFILMENT SUPPORT | 2495 | 12 | 0.05150214592274678 | 0.004809619238476954 | 0.0002033105738440947
DIRECT SALES BALANCE TRANS | 289 | 5 | 0.02145922746781116 | 0.01730103806228374 | 8.471273910170612e-05
FAST APP | 1679 | 3 | 0.0128755364806867 | 0.001786777843954735 | 5.082764346102367e-05
NEW BUSINESS | 1156 | 3 | 0.0128755364806867 | 0.00259515570934256 | 5.082764346102367e-05
FNB INSURANCE SALES | 5260 | 2 | 0.008583690987124463 | 0.0003802281368821293 | 3.388509564068244e-05
FNB LIFE RISK INBOUND | 197 | 1 | 0.004291845493562232 | 0.005076142131979695 | 1.694254782034122e-05
ISLAMIC DIRECT | 546 | 1 | 0.004291845493562232 | 0.001831501831501832 | 1.694254782034122e-05
KULULA CARD SALES | 115 | 1 | 0.004291845493562232 | 0.008695652173913044 | 1.694254782034122e-05
DISCOVERY CARD EXISTING | 1 | 0 | 0 | 0 | 0
DS VEHICLE FINANCE | 211 | 0 | 0 | 0 | 0
GENESIS | 54 | 0 | 0 | 0 | 0
JV [NAME] | 25 | 0 | 0 | 0 | 0
LOC SALES | 405 | 0 | 0 | 0 | 0
Service |  |  | * only displaying values > 3%
Area Group | Calls Answered | Calls Transferred | % Trf | % Trf to Answer, per Area | % Trf to Total Answer
TELEPHONE BANKING | 254069 | 64169 | 0.4121534825167639 | 0.2525652480231748 | 0.08205513137081646 | 64169
FNB CREDIT CARD | 164099 | 40882 | 0.2625825347480924 | 0.2491300982943223 | 0.05227723481278684 | 40882
FRAUD & CARD CANCELATIONS | 71209 | 15197 | 0.0976093826272384 | 0.2134140347427994 | 0.01943293227948539 | 15197
FNB HOME LOANS | 31954 | 8499 | 0.05458854661768106 | 0.265976090630281 | 0.01086796679893047 | 8499
TEMPLOANS | 25972 | 8469 | 0.05439585848983891 | 0.3260819343908825 | 0.01082960475587035 | 8469
BUSINESS BANKING | 51526 | 6648 | 0.04269968912982042 | 0.1290222411986182 | 0.008501028742121395 | 6648
CELLPHONE BANKING | 27014 | 6245 | 0.04011124527914087 | 0.2311764270378322 | 0.007985698630347189 | 6245
WALLET SERVICES | 46407 | 3328 | 0.02137553631528916 | 0.07171331911134096 | 0.00425562931013538 | 3328
SAVINGS AND INVESTMENTS | 32793 | 2193 | 0.01408550214526116 | 0.06687402799377916 | 0.002804265347694377 | 2193
MVNO | 76980 | 62 | 0.0003982221308737764 | 0.000805404001039231 | 7.928155565757017e-05 | 62
Spreadsheet: 87166d1287028431-automatic-dynamic-naming-of-validation-lists-rjdp-sample
Sheet: Sheet1

Company Name | Company Name (Unique) | Customer Name | Customer Selection
ABC Inc | ABC Inc | [NAME] |  | << This drop-down should DYNAMICALLY pick up ONLY customer names associated with ABC Inc (i.e., C2:C5)
ABC Inc |  | Jane A
ABC Inc |  | [NAME]
DEF Inc | DEF Inc | [NAME] |  | << This drop-down should DYNAMICALLY pick up ONLY customer names associated with DEF Inc (i.e., C6:C7)
DEF Inc |  | [NAME]
… | … | …
Spreadsheet: 2c5d27a0-854e-4548-93a6-909f53c726ff
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5584 | 39859 | Toni | [NAME] | ESP | 487 | 00:34:45 | [NAME] | [NAME] | 00:00:57 | [NAME] | 1 | 02:03:13
5584 | 39856 | Joaquin | Carrasco | ESP | 488 | 00:41:21 | 00:00:52 | 01:13:37 | [NAME] | 00:20:59 | 2 | 02:17:26
5584 | 39857 | [NAME] | Pellicer | ESP | 489 | 00:41:20 | 00:00:54 | [NAME] | 00:00:48 | [NAME] | 3 | 02:25:14
5584 | 11531 | [NAME] | Meunier | FRA | 486 | 00:44:57 | 00:00:25 | 01:24:32 | 00:00:46 | 00:28:49 | 4 | 02:39:25
Spreadsheet: 208519d1358855538-multiple-dependent-data-validation-drop-down-boxes-myexample
Sheet: Sheet1

Pepsi | [NAME]
Pepsi | [NAME]
Sony | [NAME]
Pepsi | Peggy
Ford | Fred
 |  |  |  |  |  |  |  |  |  |  |  | Ford | Fred | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Pepsi | [NAME] | [NAME] | Peggy
 |  |  |  |  |  |  |  |  |  |  |  | Sony | [NAME] | [NAME] | Sue
 |  |  |  |  |  |  |  |  |  |  |  | Ford | Fargo | Fairfax | Flint
 |  |  |  |  |  |  |  |  |  |  |  | Pepsi | Pasadena | Pensacola | Peoria
 |  |  |  |  |  |  |  |  |  |  |  | Sony | Sacramento | Salem | Saratoga
Spreadsheet: 874431d1721030526-cell-ride-on-another-cell-even-change-the-order-delivery-date
Sheet: Sheet6

Items | Column1 | delivery date
 | Apple | 2024-10-07 02:00:00
 | [NAME] (ride on Apple delivery)
 | Orange(ride on Apple delivery)
 | Mango (ride on Apple delivery)
 | Grapes (ride on Apple delivery)
 | [NAME] (ride on Apple delivery)
 | Pineapple | 2024-09-26 14:00:00
 | Watermelon | 2024-09-26 08:00:00
 | Pomegranate | 2024-09-26 08:00:00
 | Guava | 2024-08-07 08:00:00
 | Kiwi (Ride on [NAME] delivery)
 | Pear(Ride on [NAME] delivery)
 | [NAME] (Ride on [NAME] delivery)
 | [NAME] (Ride on [NAME] delivery)
 | Papaya | 2024-10-08 16:00:00
 | Lemon | 2024-10-09 01:00:00
 | Lychee | 2024-10-09 00:00:00
 | Avocado | 2024-10-08 04:00:00
 | [NAME] | 2024-10-08 08:00:00
 | Blackberry | 2024-10-10 08:00:00
 | [NAME] | 2024-10-09 04:00:00
 | Coconut | 2024-10-09 00:00:00
 | Fig | 2024-10-09 04:00:00
 | Plum | 2024-10-09 04:00:00
 | [NAME] | 2024-10-08 08:00:00
Spreadsheet: mary_fischer__25624__31X
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:
EXTENSION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 568107d1522369233-lookup-multiple-occurrences-of-the-same-value-in-two-different-columns-ef1136e_with-the-hyphen
Sheet: Match

Player 1 | def. | Player 2 |  | Old ELO for player 1 | Old ELO for player 2 | Odds of Winning for player 1 | Odds of Winning for player 2 | New ELO for player 1 | New ELO for player 2
Adam | def. | Amy-Alice
Amy-Alice | def. | Olivia
Grace | def. | Adam
Tyron | def. | [NAME]
Braxton | def. | Erin
Ellie | def. | Alicia
Amy-Alice | def. | Grace
Olivia | def. | [NAME]
Braxton | def. | Jessica
[NAME] | def. | [NAME]
[NAME] | def. | Tyron
Adam | def. | Braxton
Jessica | def. | Ellie
[NAME] | def. | [NAME]
Amy-Alice | def. | Grace
Spreadsheet: 850816d1701169417-extracting-average-demand-periods-from-start-and-duration-data-example-1-1-ng-
Sheet: Sheet1

Ticket | Location | Day of the week | Date | Start time | End time | Duration
SCTASK0218061 - RITM0498239 - AV Event Support: Farewell event for CIO | Great Hall | Tue | 2023-01-24 00:00:00 | 15:30:00 | 19:00:00 | 3.5 hours
SCTASK0219095 - RITM0488477 - AV Event Support: TSS Launch | D18-03-321 | Mon | 2023-01-30 00:00:00 | 09:00:00 | 12:00:00 | 3 hours
SCTASK0219155 - Event functionality check | ABS B2010 | Mon | 2023-01-30 00:00:00 | 09:00:00 | 10:00:00 | 1 hour
SCTASK0219185 - RITM0496023 EVENT SUPPORT - Peer Mentoring Symposium | ABS B2010 | Tue | 2023-01-31 00:00:00 | 07:30:00 | 17:30:00 | 10 hours
SCTASK0219187 - RITM0496023 EVENT SUPPORT - Peer Mentoring Symposium | ABS B2010 | Tue | 2023-01-31 00:00:00 | 07:30:00 | 17:30:00 | 10 hours
SCTASK0219186 - RITM0496023 EVENT SUPPORT - Peer Mentoring Symposium | ABS B2010 | Tue | 2023-01-31 00:00:00 | 07:30:00 | 17:30:00 | 10 hours
SCTASK0219476 - RITM0504354 - AV Event Support: Reconciliation, Opportunities, Wellbeing of First Nations People Workshop | CPC Mckenzie room 6102 | Thu | 2023-02-02 00:00:00 | 08:00:00 | 17:00:00 | 9 hours
SCTASK0219149 - RITM0498139 - AV Event Support: Sydney Ideas: War in Ukraine | A02-02-200 - SSB Lecture Theatre 200 | Thu | 2023-02-02 00:00:00 | 12:00:00 | 21:00:00 | 9 hours
SCTASK0219147 - RITM0498139 - AV Event Support: Sydney Ideas: War in Ukraine | A02-02-200 - SSB Lecture Theatre 200 | Thu | 2023-02-02 00:00:00 | 12:00:00 | 21:00:00 | 9 hours
SCTASK0219153 - RITM0498139 - AV Event Support: Sydney Ideas: War in Ukraine | A02-02-200 - SSB Lecture Theatre 200 | Thu | 2023-02-02 00:00:00 | 12:00:00 | 21:00:00 | 9 hours
 |  |  |  |  |  |  |  | NOTES:
 |  |  |  |  |  |  |  | Table top left is a sample of the data.
24 Hr Time | Tally |  |  |  |  |  |  | A14 to A39 shows the information I need to derive. 24hr time with a tally of how many support shifts included that hour.
0 |  |  |  |  |  |  |  | The rows hightlighted in Yellow I have manually processed, applying a 1 value next to the corresponding 24hr time and a .5 for shifts that begin or end on the half hour.
1
2
3
4
5
6
7 | 0.5
8 | 1
9 | 3
10 | 2
11 | 2
12 | 1
13 | 1
14 | 1
15 | 1.5
16 | 2
17 | 1.5
18 | 1
19
20
21
22
23
24