tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14208__PS _5
Sheet: PS#5

(e)
 | Summary of EST, EFT, LST, LFT, slack and critical activities for Problem 15.9 (Creations store move)
 | Activity | Description | Time | EST | EFT | LST | LFT | Slack | Critical Activity?
 | A | install new plumbing | 10 | 0 | 10 | 4 | 14
 | B | order and receive furniture | 20 | 0 | 20 | 0 | 20
 | C | order and receive flooring | 15 | 0 | 15 | 4 | 19
 | D | construct partitions | 5 | 0 | 5 | 9 | 14
 | E | paint and wallpaper | 5 | 10 | 15 | 14 | 19
 | F | install furniture | 3 | 20 | 23 | 20 | 23
 | G | install flooring | 4 | 15 | 19 | 19 | 23
 | H | move inventory and records | 2 | 23 | 25 | 23 | 25
 | I | clean old shop | 2 | 25 | 27 | 25 | 27
Spreadsheet: 795255d1662578081-index-match-multiple-sheet-names-sample-book-v2-hd
Sheet: Sheet1

 |  |  | Results |  |  |  |  |  | What I want it to be
 |  |  | Sheet Name | Find on tabs |  |  |  |  | Sheet Name | Find on tabs
 |  |  |  | 015467 |  |  |  |  |  | 015467
 |  |  |  | 037317 |  |  |  |  |  | 037317
 |  |  |  | 009963 |  |  |  |  |  | 009963
 |  |  |  | 027911 |  |  |  |  |  | 027911
 |  |  |  | 039681 |  |  |  |  |  | 039681
 |  |  |  | 029734 |  |  |  |  |  | 029734
 |  |  |  | 029735 |  |  |  |  |  | 029735
 |  |  |  | 009167 |  |  |  |  |  | 009167 | sheet 1 and sheet 4
Spreadsheet: 233144d1367633903-lookup-across-multiple-sheets-multiple-sheet-lookup
Sheet: Small List

UNID |  | EXISTS? |  |  | Result
B000004 |  |  |  |  |  |  | copy formulas down in columns C & F down to last row used in column A or further
K65444444444 |  |  |  |  |  |  | you can hide column F, it is a helper column
A123466
A123502
Spreadsheet: 709941d1608637546-populate-calendar-with-output-values-from-table-test-1
Sheet: Sheet1

Test Task 1 | Start Date |  | End Date
Week 1 | 2021-01-04 00:00:00 |  | 2021-01-07 00:00:00
Week 2 | 2021-01-11 00:00:00 |  | 2021-01-14 00:00:00
Week 3 | 2021-01-18 00:00:00 |  | 2021-01-21 00:00:00
Test Task 2
Week 1 | 2021-01-07 00:00:00 |  | 2021-01-12 00:00:00
Week 2 | 2021-01-14 00:00:00 |  | 2021-01-19 00:00:00
Week 3 | 2021-01-21 00:00:00 |  | 2021-01-26 00:00:00
Spreadsheet: 200433d1355538738-help-for-sorting-winner-race
Sheet: Sheet1

BIB number | Name | Time | Race bib number winner
502 | ally | 0:00:25.382000
515 | [NAME] | 0:00:40.436000
420 | kate | 0:01:02.120000
403 | hazel | 0:01:22.150000
500 | esteban | 0:01:27.954000
423 | haily | 0:01:38.952000
408 | netnet | 0:01:49.326000
499 | [NAME] | 0:01:55.285000
566 | joel | 0:02:03.210000
528 | bugoy | 0:02:14.005000
455 | nena | 0:02:25.534000
Spreadsheet: 135771d1326224081-lookup-unsorted-data-unsorted-lookup-table
Sheet: Sheet1

x | y | z | xz load
10 | 8 | 5 |  |  | Max XZ Load
5 | 5 | 3
6 | 6 | 8 |  |  |  | x | y | z
7 | 2 | 4
3 | 1 | 6
6 | 3 | 4
Spreadsheet: 218743d1362566337-ctrl-shift-enter-search
Sheet: Sheet1

 | Order: | A001-2004 | <- This one is filled in by me!
 | Order: | File: | Sum:
 |  | 010 | 130 |  | <- These rows are supposed to be filled in automatically.
 |  | 020 | 45
 |  | 030 | 318
 |  | 040 | 254
 |  | 050 | 658
 |  | 060 | 4
 |  | 070 | 548
 |  | 080 | 25
 |  | 090 | 54
 |  | 100 | 87
 |  | 110 | 835
 |  | 120 | 224
 |  | 130 | 654
 |  | 140 | 543
 |  | 150 | 2533
 |  | 160 | 1
 |  | 170 | 564
 |  | 171 | 359
 |  | 180 | 349
Spreadsheet: 683952d1593069082-extract-unique-text-from-different-sheet-for-notes
Sheet: Notes

 |  |  |  |  | For Notes
 |  |  |  | FSLI | NLI
 |  |  | Cash and cash equivalents
 |  |  | Trade and other receivables
 |  |  | Inventories
 |  |  | Property, Plant and Equipment
 |  |  | Investments
 |  |  | Intangible Assets
 |  |  | Trade and other payables
 |  |  | Current borrowings
 |  |  | Tax Liability, net
 |  |  | Charter Capital
 |  |  | Retained earnings
 |  |  | Revenue
 |  |  | Cost of sales
 |  |  | General and administrative expense
 |  |  | Non operating expense
 |  |  | Non operating income
Spreadsheet: sara_shackleton__36470__ISDA Master Swap Agreement Sheet
Sheet: Sheet1

ISDA Master Swap Agreement Worksheet
 |  | ATTORNEY:
DATE: | 2000-04-28 00:00:00 | DEAL MAKER:
COUNTERPARTY: | Western Resources, Inc. | CONTACT: | Shane Mathis
ADDRESS: | 818 South Kansas Ave. | TITLE:
 | Topeka, KS 66601 | PHONE: | 785/575-8076
 |  | FAX:
Incorporation State |  | Moody's | Ba2
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp. (Baa1)
LIMIT $ MILLIONS |  | 15000000
Incorporation State |  | OR
COLLATERAL  THRESHOLD | Based on rating (Sr. Unsec) |  | See attached
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | Senior, Unsecured | Senior, Unsecured
-Below = S&P/Moody's | BB-/Ba3 | BB-/Ba3
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($) | 25000000
-Guarantor ($) |  | 100000000
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO: x
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
Net worth as of 12/31/99 of $270MM.  Revenues of $804MM.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-7712
Spreadsheet: 7c869609-4269-41dd-9a63-9ad87bf23350
Sheet: Sheet1

Table S3: dominant negative constructs, overexpression constructs, and mutant alleles tested | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Table legend: Blooming stock ID numbers prefaced by "b."  Bold highlights all confirmed stocks that yielded reproducible genetic interactions and clear phenotypic alterations.  Key to genetic interactions: N: no interaction/no difference, WS: weak suppressor, S: moderate suppressor, SS: strong suppressor, WE: weak enhancer, E: moderate enhancer, SE: strong enhancer. "?" denotes interactions that were milder than the "weak" designation but subtly different from controls.
allele/stock ID number | CG number | gene name | dEGFRλ; dp110CAAX interaction | comments
b5364 | CG10079 | dEGFR | WS | dominant negative
b24624 | CG17520 | CK2alpha | sick? | dominant negative
b8263 | CG18402 | InR | E | activated version, grossly misshapen brain
b30101 | CG34412 | tlk | SS | dominant negative
b8288 | CG4141 | dp110 | S | dominant negative
b8289 | CG4141 | dp110 | WS | dominant negative
b7013 | CG5092 | Tor | SS | dominant negative
Tor-2L7 | CG5092 | Tor | SS | mutant allele
Tor-l(2)k17004 | CG5092 | Tor | SS | mutant allele
b20854 | CG6297 | JIL-1 | WS? | mutant allele
b5366 | CG7223 | htl | WS? | dominant negative
b5367 | CG7223 | htl | SE | activated version, grossly misshapen brain
b8382 | CG7838 | BubR1 | N | dominant negative
UAS-PvrDN | CG8222 | [NAME] | WS | dominant negative
Spreadsheet: 144733d1331120356-count-formula-needed-urgent-count-formula
Sheet: Sheet1

 |  |  | Month: | 2012-02-01 00:00:00
 |  |  | DOJ | NAME | HQ | PRI SALES
 | BE | 1 | 2011-10-01 00:00:00 | [NAME] | Sonarpur | 30000
 | BE | 2 | 2012-01-04 00:00:00 | [NAME] | D Harbor | 40000
 | BE | 3 | 2012-02-16 00:00:00 | [NAME] | Behala | 30000
 | BE | 4 |  | VACCANT | [NAME] | 25000
 | BE | 5 | 2011-10-01 00:00:00 | S.S.Roy | Midnapur | 25000
 | BE | 6 | 2011-10-01 00:00:00 | Sumit Mahapatra | Contai | 25000
 | EMPLOYEE STRENGTH |  |  |  | TOTAL SALE :
 | VACCANT HQ |  |  |  | PCPM :
Spreadsheet: 484282d1476201856-want-data-from-one-spreadsheet-to-auto-populate-to-another-elmer-fudd-realty-rents-2016
Sheet: Bldg 141

Building 141
Date | Building | Apt. # | Check # | Amount
 | 141
Spreadsheet: 39817d1238085976-help-with-auto-sort-table
Sheet: Sheet1

SUNDERLAND INSTORE SIS LEAGUE
Name |  |  | Score |  |  | Rank
[NAME] |  |  | 0.17 |  |  | 1
[NAME] |  |  | 0.16 |  |  | 2
[NAME] |  |  | 0.15 |  |  | 3
[NAME] |  |  | 0.14 |  |  | 4
[NAME] |  |  | 0.13 |  |  | 5
[NAME] |  |  | 0.12 |  |  | 6
[NAME] |  |  | 0.11 |  |  | 7
[NAME] |  |  | 0.1 |  |  | 8
[NAME] |  |  | 0.09 |  |  | 9
[NAME] |  |  | 0.08 |  |  | 10
[NAME] |  |  | 0.07 |  |  | 11
[NAME] |  |  | 0.06 |  |  | 12
Store
Spreadsheet: 156160d1337194653-formula-to-lookup-formatting-and-return-true-false-cb
Sheet: CB

Item | Ship Type | Lot Number | Pick Plan | Order # | LocCat | Container | Incorrect | User
OY03133Q | PL | WWYDAY | 91973 | 592625 | ZNG | CS |  | AKERSE
MG42325G | CS | WW21749 | 92100 | 594513 | KNP | Pail |  | HORNEC
MG061008 | CS | WW21709 | 92100 | 594645 | CUQ | CS |  | THARPT
[NAME] | CS | WW21678 | 91889 | 591624 | KCQ | CS |  | HORNEC
FA06DXPL | CS | WW21531 | 91983 | 593589 | CNQ | CS |  | THARPT
WM550MPL | CS | [NAME] | 92156 | 595977 | WMQ | CS |  | RICEJ
PW06DXPL | PL | WW21171 | 91831 | 592660 | ZNQ | CS |  | AKERSE
WM06104P | CS | WRW21557 | 91778 | 592853 | WMG | CS |  | KLOCKNR
MG04523Q | CS | WRW20669 | 92100 | 594642 | CNG | CS |  | PREMEAP
[NAME] | CS | WD1488 | 92326 | 598071 | CNP | Pail |  | LARRYV
SI31PS16 | CS | W93006 | 92228 | 595797 | CNQ | CS |  | JENSENJ
SI31PS16 | CS | W93006 | 91885 | 592750 | CNQ | CS |  | JENSENJ
SI31PS16 | CS | W93006 | 91833 | 592249 | CNQ | CS |  | MICEKJ
MG44HT22 | CS | W82202 | 92326 | 598545 | CNG | CS |  | MARTINM
MG44HT22 | CS | W82202 | 92228 | 596090 | CNG | CS |  | BUTLERJ
MG44HT22 | CS | W82202 | 92275 | 597878 | CNG | CS |  | THARPT
MG44HT22 | CS | W81091 | 92324 | 596910 | CNG | CS |  | HIGGINM
MG44HT22 | CS | W81091 | 92326 | 598383 | CNG | CS |  | MARTINM
FE0453PL | PL | W31672 | 91927 | 593762 | CNQ | CS |  | RAYMERA
MA25UN5G | CS | W31525 | 91889 | 591144 | CNP | Pail |  | BIXLERJ
MG101022 | CS | W2C355 | 91839 | 593757 | CNG | CS |  | BIXLERJ
WM25UN5P | CS | W27793 | 92285 | 597855 | WMP | Pail |  | JOER
ACC130PL | CS | W27000 | 92326 | 598561 | ZNQ | CS |  | LARRYV
PE03132Q | PL | W2686 | 92137 | 589314 | ZNG | CS |  | DURHAMJ
Spreadsheet: 796820d1663579861-amending-a-formula-to-change-the-result-from-highest-to-lowest-ramsey-marvo-aligw
Sheet: Results

CAMBRIDGESHIRE |  |  |  |  |  |  |  |  |  | MASTERS |  |  |  |  |  |  |  |  | LAST CHANCE
No | PLAYER | PAR 3 | TOTAL | S/I 1 | S/I 2 | S/I 3 | No |  |  | No | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | No |  |  | No | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | No
1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18
19
20
21
22
23
24
25
26
Spreadsheet: 681029d1591304346-convert-columns-to-multi-level-drop-down-lists-or-something-better-sorting-and-drop-down-list-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Office | Department | Owner | Secondary |  |  | Office | Department | Owner | Secondary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAB | Lab | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAB | Lab | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAB | Lab | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | Pathology | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAB | Lab | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAB | Lab | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | SysMan | [NAME] | Tuesday Albrecht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | SAN Team | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-SysMan | DBA Team | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | SysMan | [NAME] | Mason Doughlin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radiology | Radiology | Terrence Byron
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radiology | Radiology | Terrence Byron
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radiology | Radiology | Terrence Byron
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radiology | Radiology | Terrence Byron
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-SysMan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | SAN Team | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | SAN Team | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | SAN Team | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-ESM | SAN Team | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-DataCenter | DataCenter Team | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BI-DataCenter | DataCenter Team | [NAME] | [NAME]
Spreadsheet: 6fa425cf-e3b8-4798-9f17-a8d92da6dbea
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38737611 | 2013-11-28 00:25:21 | ALLIES | 1 | 4 | 2 | 1412777 | Royston Warke | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
38737684 | 2013-11-28 00:43:41 | AXIS | 1 | 4 | 3 | 1412777 | Royston Warke | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
38737883 | 2013-11-28 01:23:02 | AXIS | 1 | 10 | 5 | 558252 | Shamrok | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38738250 | 2013-11-28 02:06:03 | AXIS | 1 | 10 | 7 | 558252 | Shamrok | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 101295d1299457189-auto-sort-print-macro-example1
Sheet: Sheet1

Equipment | Quantity | Price | Total
Chair | 2 | 40 | 80
Clock | 5 | 30 | 150
Computer | 3 | 200 | 600
Desk | 4 | 30 | 120
Monitor | 4 | 150 | 600
Pencil | 9 | 3 | 27
Phone | 2 | 10 | 20
Table | 3 | 20 | 60
Spreadsheet: 869175d1715816936-team-comp-help-with-a-formula-to-show-each-teams-points-against-the-other-teams-points-pong-streaks-2
Sheet: Sheet1

Round | Home | Score | Score2 | Away
1 | [NAME] | 21 | 13 | Nathan
1 | [NAME] | 21 | 15 | Nathan
1 | [NAME] | 11 | 4 | Nathan
1 | Nathan | 21 | 17 | [NAME]
1 | Nathan | 21 | 14 | [NAME]
1 | Nathan | 11 | 5 | [NAME]
1 | [NAME] | 21 | 18 | Mark
1 | [NAME] | 21 | 13 | [NAME]
2 | [NAME] | 21 | 9 | Nathan
2 | [NAME] | 21 | 11 | [NAME]
2 | Nathan | 21 | 17 | [NAME]
2 | Nathan | 21 | 14 | [NAME]
2 | [NAME] | 21 | 12 | [NAME]
2 | [NAME] | 21 | 19 | Mark
2 | Mark | 11 | 8 | [NAME]
 |  | For | Against
 | [NAME] | 74 | 41 | Nathan
 |  | 42 | 25 | [NAME]
 |  | 50 | 45 | Mark
 |  | 42 | 11 | [NAME]
 | Nathan | 41 | 74 | [NAME]
 |  | 0 | 0 | Mark
 |  | 95 | 67 | [NAME]
 |  | 0 | 0 | [NAME]
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Tender

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-03-12 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-03-12 00:00:00
Spreadsheet: daren_farmer__5481__hpl0914
Sheet: Sheet1

HPLN0914.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 14, 2000
 |  |  |  |  |  | ** Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-14 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 887907d1738232981-combining-vlookups-on-multiple-sheets-book2
Sheet: Two A

 | DEF-one |  |  | 4
 | DEF-two |  |  | 2
 | DEF-three |  |  | 4
 | DEF-four |  |  | 3
 | DEF-five |  |  | 5
 | DEF-six |  |  | 4
 | DEF-seven |  |  | 4
 | DEF-eight |  |  | 4
 | DEF-nine |  |  | 4
 | DEF-ten |  |  | 4
Spreadsheet: 874059d1720625367-getting-data-from-one-workbook-to-another-athletics-spreadsheet-v14-tms
Sheet: Records

 | 100m |  |  |  |  | 200m |  |  |  |  | 800m |  |  |  |  | High |  |  |  |  | Long |  |  |  |  | Shot |  |  |  |  | Discus
 | Result | Name | House | Year |  | Result | Name | House | Year |  | Result | Name | House | Year |  | Result | Name | House | Year |  | Result | Name | House | Year |  | Result | Name | House | Year |  | Result | Name | House | Year
8 BOYS | 13.91 | [NAME] | Coochin | 2019 |  | 35.87 | [NAME] | Coochin | 2019 |  |  |  |  |  |  | 1.04 | [NAME] | Coochin | 2019 |  | 3.2 | [NAME] | Coonowrin | 2021 |  | 8.15 | [NAME] | Coochin | 2018 |  | 14.97 | [NAME] | Coonowrin | 2021
8 GIRLS | 13.93 | [NAME] | Tibro | 2021 |  | 38.84 | Imogen O'Day | Coochin | 2019 |  |  |  |  |  |  | 1 | [NAME] | Coonowrin | 2017 |  | 2.73 | [NAME] | Tibro | 2014 |  | 8 | [NAME] | Tibro | 2014 |  | 12.42 | [NAME] | Coochin | 2020
9 BOYS | 12.56 | [NAME] | Tibro | 2014 |  | 33.4 | [NAME] | Tibro | 2018 |  | 00:02:53.820000 | [NAME] | Coochin | 1997 |  | 1.2 | [NAME] | Tibro | 2018 |  | 3.72 | [NAME] | Coonowrin | 2012 |  | 6.52 | [NAME] | Coochin | 2010 |  | 21.6 | Connor Black | Coonowrin | 2012
9 GIRLS | 12.63 | [NAME] | Coonowrin | 2010 |  | 33.83 | [NAME] | Coonowrin | 1996 |  | 00:03:07.780000 | [NAME] | Coonowrin | 2010 |  | 2.1 | [NAME] | Coonowrin | 2010 |  | 3.54 | Ashlee Temple | Tibro | 2016 |  | 6.7 | [NAME] | Tibro | 2019 |  | 17.63 | [NAME] | Tibro | 2012
10 BOYS | 14.83 | [NAME] | Coochin | 14.83 |  | 30.94 | [NAME] | Tibro | 1993 |  | 00:02:43.430000 | [NAME] | Coochin | 1998 |  | 1.22 | [NAME] | Coonowrin | 1997 |  | 4.11 | [NAME] | Coochin | 2021 |  | 8.56 | [NAME] | Coochin | 2006 |  | 22.68 | [NAME] | Coochin | 2006
10 GIRLS | 15.06 | Felicity [NAME] | Coonowrin | 1994 |  | 32.12 | Felicity Wielnad | Coonowrin | 1994 |  | 00:02:58 | Felicity [NAME] | Coonowrin | 1994 |  | 1.18 | [NAME] | Tibro | 1997 |  | 3.9 | [NAME] | Coonowrin | 2011 |  | 7.05 | [NAME] | Coonowrin | 1993 |  | 19.67 | [NAME] | Tibro | 1997
11 BOYS | 14.03 | [NAME] | Coochin | 1998 |  | 28.94 | [NAME] | Coochin | 1994 |  | 2.37.43 | [NAME] | Coochin | 1998 |  | 1.32 | [NAME] | Coochin | 2013 |  | 4.48 | [NAME] | Coochin | 1994 |  | 9.41 | [NAME] | Tibro | 2001 |  | 23.4 | Milan [NAME] | Coonowrin | 2019
11 GIRLS | 14.55 | [NAME] | Coochin | 1996 |  | 30.89 | [NAME] | Coochin | 1996 |  | 2.54.54 | [NAME] | Coochin | 2005 |  | 1.25 | [NAME] | Tibro | 1998 |  | 3.96 | Felicity [NAME] | Coonowrin | 1995 |  | 10.26 | Tamara Taripo | Coochin | 2016 |  | 26.57 | Tamara Taripo | Coochin | 2016
12 BOYS | 13.39 | [NAME] | Coochin | 1991 |  | 28.19 | [NAME] | Coochin | 1995 |  | 2.31 | [NAME] | Tibro | 1995 |  | 1.44 | [NAME] | Coonowrin | 1999 |  | 4.7 | [NAME] | Coochin | 1995 |  | 10 | Taho Holliday | Coonowrin | 2007 |  | 27.72 | [NAME] | [NAME] | 1999
12 GIRLS | 14.11 | [NAME] | Coonowrin | 2009 |  | 30.19 | Felicity [NAME] | Coonowrin | 1996 |  | 2.48.85 | [NAME] | Coonowrin | 2009 |  | 1.28 | [NAME] | Tibro | 1999 |  | 4.52 | [NAME] | Coonowrin | 2009 |  | 9.17 | [NAME] | Coonowrin | 2007 |  | 24.34 | [NAME] | Tibro | 1998
Spreadsheet: 804222d1667942152-lookup-function-between-dates-example-1
Sheet: Sheet1

Voucher # | Sub Voucher # | Date | Amount | Paid | Paid Date
3002 | 5803284001 | 2022-10-11 00:00:00 | 100 | Paid | 2022-10-13 00:00:00
3003 | 5803285001 | 2022-10-12 00:00:00 | 100 | Paid | 2022-10-14 00:00:00
3004 | 5803287001 | 2022-10-14 00:00:00 | 100 | Paid | 2022-10-17 00:00:00
3005 | 5803290001 | 2022-10-17 00:00:00 | 100 | Paid | 2022-10-20 00:00:00 |  |  | Returned Results
3006 | 5803292001 | 2022-10-19 00:00:00 | 100 | Paid | 2022-10-25 00:00:00 |  | PENDING | 3013 | 5 | 2022-11-03 00:00:00 | 50
3007 | 5803293001 | 2022-10-20 00:00:00 | 100 | Paid | 2022-10-25 00:00:00 |  | 120 | 3014 | 5803308001 | 2022-11-04 00:00:00 | 70
3008 | 1 | 2022-10-16 00:00:00 | 50 | Paid | 2022-10-26 00:00:00
3008 | 2 | 2022-10-16 00:00:00 | 50 | Paid | 2022-10-26 00:00:00
3009 | 3 | 2022-10-25 00:00:00 | 50 | Paid | 2022-10-28 00:00:00
3010 | 4 | 2022-10-26 00:00:00 | 50 | Paid | 2022-10-31 00:00:00 |  | Data between Dates:
3011 | 5803301001 | 2022-10-28 00:00:00 | 35 | Paid | 2022-11-03 00:00:00 |  | start date | end date
3011 | 5803301002 | 2022-10-28 00:00:00 | 57 | Paid | 2022-11-03 00:00:00 |  | 2022-11-03 00:00:00 | 2022-11-07 00:00:00
3013 | 5 | 2022-11-03 00:00:00 | 50
3014 | 5803308001 | 2022-11-04 00:00:00 | 70 |  |  |  | Results
3015 | 6 | 2022-11-07 00:00:00 | 50 |  |  |  | Voucher # | Sub Voucher # | Date | Amount
3015 | 5803311001 | 2022-11-07 00:00:00 | 100 |  |  |  | 3013 | 5 | 2022-11-03 00:00:00 | 50
 |  |  |  |  |  |  | 3014 | 5803308001 | 2022-11-04 00:00:00 | 70
 |  |  |  |  |  |  | 3015 | 6 | 2022-11-07 00:00:00 | 50
 |  |  |  |  |  |  | 3015 | 5803311001 | 2022-11-07 00:00:00 | 100
Spreadsheet: 770315d1645988122-excel-formula-to-produce-balance-sheet-balance-sheet-2021b
Sheet: Balance Sheet

 | SUM(((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$C$4:$C$19))-((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$D$4:$D$19)))
 | Desired Outcome
 | Non-current Assets
 | Current Assets
 | Debtors and other receivables
 | Cash and equivalents
 | Total Assets
 | FINANCED BY:
 | EQUITY AND LIABILITIES
 | Accumulated funds
 | Net Surplus for the year
 | School development funds
 | Capital Per Grant
 | Total
 | Current Liabilities
 | Provisions
 | Other obligations
 | Total Equity and Liabilities
 | Fees
 | Sundry
 | Interest
 | Total Income
 | EXPENDITURE
 | Accounting Fees
 | Subs to association
 | Workshops & Conferences
 | Depreciation
 | Bank Charges
 | Electricity & Water
 | Teas & Cleaning
 | Funeral cover
 | Printing & Stationery
 | Salaries & Wages
 | Telephone & Internet
 | Medical Aid
 | Insurance & Licence
 | Repairs & Maintenance
 | Security
 | [NAME] expenses
 | NSSA
 | Sundry expenses
 | Fuel
 | Bad debts written off
 | Total Expenditure
 | Net Surplus for the year
Spreadsheet: 550703d1512498041-counting-multiple-ranges-that-meet-a-criteria-over-one-range-working-capital-question
Sheet: Sheet1

 | Threshhold | 1000
 |  | 2010-01-01 00:00:00
 | Widget 1 | 0 | 0 | 0 | 25 | 1025 | 1025 | 6000 | 6000 | 6000 | 106000 | 106000 | 106000 | 106000 | 56000 | 56000 | 6000 | 0 | 0 | 0 | 0 | 0 |  | Count 12 Months
 | Widget 2 | 0 | 25 | 25 | 1000 | 1000 | 50000 | 50000 | 50000 | 1000 | 25 | 0 | 25 | 25000 | 25000 | 30000 | 30000 | 5000 | 5000 | 5000 | 0 | 0 |  | Count 6 months and 7 months