tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 789111d1658917937-help-with-staff-rota-formula-rota-test
Sheet: Formula

 | Centre 2 | Centre 3 | Centre 4 | Centre 5 | Centre 6 | Centre 7 | Centre 8 | Centre 9 | Centre 10 | Centre 11
Name 3 | Name 5 | Name 2 | Name 6 | Name 2 | Name 2 | Name 2 | Name 6 | Name 6 | Name 2 | Name 2
Spreadsheet: 120350d1315230451-macro-to-pull-data-into-multiple-spreadsheet-test-macro-for-dates
Sheet: Sheet1

 |  | Date :
Date | [NAME]
2011-08-12 00:00:00 | Apple
2011-08-13 00:00:00 | Orange
2011-08-14 00:00:00 | Pear
2011-08-15 00:00:00 | Orange
2011-08-16 00:00:00 | Pear
2011-08-12 00:00:00 | Orange
2011-08-12 00:00:00 | Melon
2011-08-12 00:00:00 | Melon
2011-08-12 00:00:00 | Orange
2011-08-12 00:00:00 | Durain
2011-08-12 00:00:00 | Apple
2011-08-13 00:00:00 | Melon
2011-08-13 00:00:00 | Orange
2011-08-13 00:00:00 | Orange
2011-08-14 00:00:00 | Melon
2011-08-14 00:00:00 | Apple
2011-08-14 00:00:00 | Orange
2011-08-15 00:00:00 | Pear
2011-08-15 00:00:00 | Pear
2011-08-15 00:00:00 | Orange
2011-08-15 00:00:00 | Melon
2011-08-15 00:00:00 | Pear
2011-08-16 00:00:00 | Orange
2011-08-16 00:00:00 | Apple
2011-08-16 00:00:00 | Pear
2011-08-16 00:00:00 | Melon
Spreadsheet: d35bbe47-14ee-4925-a9de-37eaa060250f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | TRADEWINDS HIBISCUS LINERS & QUICK STARTS 2009-2010 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  |  |  | 2009-06-22 00:00:00
 |  |  |  |  |  |  |  | Check Product Form
 |  |  |  |  |  |  |  | 2-CUTTING LINER
 |  |  |  |  |  |  |  | 4-1/2" QUICK STARTS
ORDER TYPE |  | REASON CODE |  | REF ORDER # | SALES ORG | ORDER #
DISTRIB  # & NAME |  |  |  |  | SHIP TO # / NAME
SOLD TO # / NAME |  |  |  |  | STREET, CITY, STATE & ZIP
STREET, CITY, STATE & ZIP
 |  |  |  |  | PHONE #
PHONE # |  |  |  |  | VISA / MC / DISC |  | CARDHOLDER NAME
SALES REP          NAME / # |  |  | P.O. #
 |  |  |  |  | CREDIT CARD NUMBER / CCV# |  |  |  | EXP DATE
ARE SUBS OK? | IF NO, PHONE |  | WEEK WANTED
 | CUST |  |  |  | SHIP VIA:
YES / NO | DIST |  | ORDER INFO.
 | SLSM
VARIETY NAME / COLOR |  |  |  | QUANTITY
RED |  |  |  |  | ALL LINER ORDERS ARE STUCK TO ORDER AND ARE SUBJECT TO CUTTING AVAILABILITY
BAJA BREEZE (USPP#17607)
BRILLIANT RED |  |  |  |  | ORDER REQUIREMENTS |  |  | 2-CUTTING LINERS | 4-1/2" QUICK STARTS
[NAME])
YELLOW |  |  |  |  | MINIMUM UNITS PER ORDER: |  |  | 96 | 150
SUNNY WIND (USPP#17623) |  |  |  |  | MINIMUM UNITS PER VARIETY: |  |  | 48 | 15
ORANGE |  |  |  |  | VARIETIES IN MULTIPLES OF: |  |  | 48 | 15
CAROLINA BREEZE (USPP#11779) |  |  |  |  | NUMBER OF UNITS PER BOX: |  |  | 96 | 15
MANDARIN WIND (USPPAF)
MONTEGO WIND (USPP#17952)
PINK
CANDY WIND (USPP#11759)
PINK VERSICOLOR
TYE-DYE WIND (USPP#18250)
WHITE
COOL WIND (USPP#12887)
SHIP DATE TOTAL |  |  |  | 0
PLACED VIA:                                      PHONE / FAX / EMAIL |  | CUSTOMER: |  | SALES PERSON | DISTRIBUTOR |  | TAKEN BY / DATE:
Spreadsheet: 473831d1470418546-too-much-repetitive-data-example
Sheet: Sheet1

Office number | office name | office address | office city | office state | office [NAME] | department | contact title | contact | contact phone | contact email
1 | corporate | 101 Main st | New York | NY | 11111 | Corp | CEO | [NAME] | [PHONE] | [EMAIL]
1 | corporate | 101 Main st | New York | NY | 11111 | Mangement | Corp Manager | [NAME] | [PHONE] | [EMAIL]
1 | corporate | 101 Main st | New York | NY | 11111 | Sales | Head of Sales | [NAME] | [PHONE] | [EMAIL]
1 | corporate | 101 Main st | New York | NY | 11111 | Service | Head of Service | [NAME] | [PHONE] | [EMAIL]
2 | north | 201 Broad st | Boston | MA | 22222 | Sales | Head of Sales | [NAME] | [PHONE] | [EMAIL]
2 | north | 202 Broad st | Boston | MA | 22222 | Service | Head of Service | [NAME] | [PHONE] | [EMAIL]
3 | south | 301 Bank st | Dallas | TX | 33333 | Mangement | Regional Manager | [NAME] | [PHONE] | [EMAIL]
4 | east | 404 Elm Ave | Richmond | VA | 44444 | Mangement | Regional Manager | [NAME] | [PHONE] | [EMAIL]
5 | west | 555 5th st | Oakland | CA | 55555 | Mangement | Regional Manager | [NAME] | [PHONE] | [EMAIL]
5 | west | 556 5th st | Oakland | CA | 55555 | Sales | Head of Sales | [NAME] | [PHONE] | [EMAIL]
5 | west | 557 5th st | Oakland | CA | 55555 | Service | Head of Service | [NAME] | [PHONE] | [EMAIL]
Office number | office name | office address | office city | office state | office [NAME] | Corp | contact title | contact | contact phone | contact email | Management | contact title | contact | contact phone | contact email | Sales | Management | contact title | contact | contact phone | Service | contact title | contact | contact phone | contact email
1 | corporate | 101 Main st | New York | NY | 11111 | Corp | CEO | [NAME] | [PHONE] | [EMAIL] | Mangement | Corp Manager | [NAME] | [PHONE] | [EMAIL] | Sales | Head of Sales | [NAME] | [PHONE] | [EMAIL] | Service | Head of Service | [NAME] | [PHONE] | [EMAIL]
2 | north | 201 Broad st | Boston | MA | 22222 |  |  |  |  |  |  |  |  |  |  | Sales | Head of Sales | [NAME] | [PHONE] | [EMAIL] | Service | Head of Service | [NAME] | [PHONE] | [EMAIL]
3 | south | 301 Bank st | Dallas | TX | 33333 |  |  |  |  |  | Mangement | Regional Manager | [NAME] | [PHONE] | [EMAIL]
4 | east | 404 Elm Ave | Richmond | VA | 44444 |  |  |  |  |  | Mangement | Regional Manager | [NAME] | [PHONE] | [EMAIL]
5 | west | 555 5th st | Oakland | CA | 55555 |  |  |  |  |  | Mangement | Regional Manager | [NAME] | [PHONE] | [EMAIL] | Sales | Head of Sales | [NAME] | [PHONE] | [EMAIL] | Service | Head of Service | [NAME] | [PHONE] | [EMAIL]
Spreadsheet: 36934d1234891167-help-with-index-match-vlookup-example-index-and-match-just-use-vlookup
Sheet: Data

ItemDescription | Item-ID | Cost | [NAME] | Retail
HayBooster | Hay6060 | 195.5 | 0.2
HayS44SandFilter | HayS244S | 359.76 | 0.2
Tristar1.5hp2sp | HaySP3215EE | 423.71 | 0.2
Spreadsheet: 61fd148c-8a14-4bb1-8696-d80031715c1d
Sheet: Sheet2

NAME
Bell, [NAME]
Brubaker, Harold
Burr, Justin
Carney, Becky
[NAME], [NAME]
Fisher, [NAME]
[NAME], [NAME]
Hager, [NAME]
Hall, [NAME]
Hastings, [NAME]
[NAME], Julia
[NAME], [NAME]
[NAME], [NAME]
Moore, [NAME]
Moore, [NAME]
[NAME], [NAME]
Queen, [NAME]
Rapp, Ray
Sager, Efton
Samuelson, [NAME]
Shepard, [NAME]
Starnes, Edgar
Tillis, Thom
Wainwright, [NAME]
Walend, Trudi
Wray, [NAME]
Spreadsheet: 731885d1620656382-start-counting-depends-on-the-value-for-asking
Sheet: Sheet1

 |  | EXPECTED RESULT | [NAME]
MATH |  | 9
MATH |  | 10
MATH |  | 11
MATH |  | 12
MATH |  | 13
MATH |  | 14
MATH |  | 15
SCIENCE |  | 11
SCIENCE |  | 12
SCIENCE |  | 13
SCIENCE |  | 14
SCIENCE |  | 15
SCIENCE |  | 16
SCIENCE |  | 17
ENGLISH |  | 5
ENGLISH |  | 6
ENGLISH |  | 7
ENGLISH |  | 8
ENGLISH |  | 9
ENGLISH |  | 10
ENGLISH |  | 11
ENGLISH |  | 12
ENGLISH |  | 13
ENGLISH |  | 14
ENGLISH |  | 15
Spreadsheet: 74891d1275431261-color-matching-scheduletest
Sheet: Dispatch

MISSION CALL SIGN | MISSION NUMBER | TYPE A/C | CONFIG | PAX SHOW | S/A CALL | BAG CALL | GATE | ETA | ETD | FROM | TO | REMARKS | ULN | ITARS | BOOK LOG PLANS | RR  EL | THRU
MON 31 MAY | 150
 |  |  |  |  |  |  |  |  |  |  |  | I want colors from this tab to change
 |  |  |  |  |  |  |  |  |  |  |  | colors on the counter schedule tab when
 |  |  |  |  |  |  |  |  |  |  |  | I change the color here
Do not delete any thing past 25 lines it will mess up the counter schedule. Delete a line add one to the bottom.
FLIGHT OPEN | LINE CHANGE | EARLY |  |  | PURPLE MISSION I CORE A (OR9) |  |  |  |  |  |  | GREEN MISSION I CORNERS (KEZ)
CANCELLED | LATE |  | ` |  | BLACK MISSION I CORE B (KEZ, 3OR, OR9) |  |  |  |  |  |  | RED MISSION I NORTH B (OR9)
DEP | OTHER |  |  |  | ORANGE MISSION I CORE B+ (KEZ) |  |  |  |  |  |  | BLUE MISSION I SOUTH (KEZ)
GATED | CLOSED
NOTES:
AP1 FOR C130J MODELS NEEDS TO BE PUT IN AS "ACP1" TO PREVENT ERROR
C2 FOR C17'S NEEDS TO BE PUT IN SIDES TO PREVENT ERROR
EMB MEANS EMBASSY                    ISL MEAN CHANNEL ISLAND
Spreadsheet: benjamin_rogers__1070__gencomodel
Sheet: Base Revenue

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual | Fuel | Annual | VOM | Annual | SO2 | Annual | NOx | Annual
 | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4 | Bucket 5 | Bucket 6 | Bucket 7 | Bucket 8 | Bucket 9 | Bucket 10 | Bucket 11 | Bucket 12 | Bucket 13 | Bucket 14 | Bucket 15 | Bucket 16 | Bucket 17 | Bucket 18 | Bucket 19 | Bucket 20 | Monthly Total | Second Call | First Call | Revenue | Cost | Fuel | Cost | VOM | Cost | SO2 | Cost | NOx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue | Revenue
2000-01-15 00:00:00
Spreadsheet: 858515d1707168337-autopopulate-cells-between-sheets-items-for-sale
Sheet: Invoice

 |  |  |  |  | INVOICE # | 104
 |  |  |  |  | Tomorrow's [NAME]
 |  |  |  |  | 647 Claire Avenue [NAME], CA 91910
 |  |  |  |  | (619)289-2967
 |  |  |  |  | DATE
 |  |  |  |  | BILL TO |  | FOR
 |  |  | Item # | Item Code | Description | Quantity | AMOUNT
 |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  | Tax
 |  |  |  |  |  | OTHER
 |  |  |  |  |  | TOTAL
 |  |  | If you have any questions concerning this invoice, use the following contact information:
 |  |  | (619) 289-2967, [EMAIL]
 |  |  | IG: Tomorrows_treasures
 |  |  | THANK YOU FOR YOUR BUSINESS!
Spreadsheet: 845722d1697106523-issue-with-doc-with-data-validation-lists-fine-on-one-computer-faulty-on-others-cost-sheet-23
Sheet: Flexface Pricing Sheet

 | Flexface Prices |  | IF Quoting NOVA choose Nova Here
 | Input Details Here Only |  |  |  |  |  |  | PRINTED BLEED AREA |  | CUT SIZE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROUNDUP
 | Frame Type | Illumination Type | Liquid Laminate? | Finishing | Qty | [NAME] | [NAME] | [NAME] | Height | [NAME] | Height | Price each | Total (excl VAT) |  |  | DO NOT TOUCH --> Reference only | m2 | TOTAL Finishing lm | £[NAME] | Liquid Laminate | Calc | Finishing |  |  |  |  |  |  |  |  |  |  | [NAME] | Height
 | N/A | N/A | N/A |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nova
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
 | N/A | N/A | N/A |  | 0 | 0 | 0
Spreadsheet: 860711d1708704021-need-formula-to-automatically-calculate-the-incentive-incentive-calculation-query
Sheet: Sheet1

Need to count how much excess achievement against target per slab
Examples
Green will always change |  | Blue should be formula
Target | Acheivement | 0-10 | 11-15 | 16-20 | 21+
5 | 12 |  |  |  |  | if target is 5, 6th-10th will be counted in 0-10 column and 11th-12th will be counted in 11-15 column
7 | 26
12 | 18
10 | 8
Spreadsheet: 94125d1293991572-excel-2007-populate-invoice-fields-based-on-invoice-number-client_db
Sheet: Database

Date | Inv No. | Invoice To | Address 1 | Suburb/City | Post Code | Treatment | Price | Client/Owner Name | Job Address 1 | Suburb/City | Postcode | [NAME]. | Mobile No. | E-Mail Address |  | Comments |  |  |  |  |  | AI
2010-10-04 00:00:00 | 5000 | Julie & Neale Hammond | CS Legal, Unit 1/234 Pier St | Perth | WA 6000 | Termite Inspection | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ants
2010-10-04 00:00:00 | 5001 | [NAME] | [NAME], 27 Hector St | Osborne Park | WA 6017 | Termite Inspection | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Barrier Treatment
2010-10-04 00:00:00 | 5002 | [NAME] | PO Box 215 | Marmion | WA 6020 | Cockroaches | 99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2010-10-04 00:00:00 | 5003 | Wing Hong Butchers | [NAME] | Northbridge | WA 6000 | Quarterly Pest Control | 132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bees/Wasps
2010-10-04 00:00:00 | 5004 | MCCH Repairers | 42 Sundercombe St | Osborne Park | WA 6017 | Barrier Treatment | 195 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cockroaches
2010-10-05 00:00:00 | 5005 | Chantavy Reth | Focus Settlements, Unit 4/167 Grand Blvd | Joondalup | WA 6027 | Termite Inspection | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fleas
2010-10-05 00:00:00 | 5006 | [NAME] | Currie & Reeves, [NAME] | Nedlands | WA 6009 | Termite Inspection | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GPS
2010-10-07 00:00:00 | 5007 | [NAME] | [NAME], Prime, 140 Grand Blvd | Joondalup | WA 6027 | Spider and spifire spray | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pet Bond Spray
2010-10-07 00:00:00 | 5008 | [NAME] | [NAME], PO Box 2297 | Clarkson | WA 6030 | PPTI | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PPTI
2010-10-07 00:00:00 | 5009 | [NAME] | [NAME], 46 Davallia Rd | Carine | WA 6020 | PPTI | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pre-Treatment
2010-10-05 00:00:00 | 5004A | [NAME] | [NAME] | [NAME] | WA 6027 | AI | 85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarterly Pest Control
2010-10-05 00:00:00 | 5010 | [NAME] | 6 Swatter Court | Edgewater | WA 6027 | Spider treatment | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rats/Mice
2010-10-05 00:00:00 | 5011 | [NAME] | 3 [NAME] | Duncraig | WA 6023 | Rats/Mice | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spider and spifire spray
2010-10-05 00:00:00 | 5012 | [NAME] | 24 Goshawk St | Tapping | WA 6065 | GPS | 140 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spider treatment
2010-10-05 00:00:00 | 5010A | [NAME] | 42 [NAME] | Pearsall | WA 6065 | Spider treatment | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spot Treatment
2010-10-06 00:00:00 | 5013 | [NAME] | 33 [NAME] | Sinagra | WA 6065 | Termite Spot Treatment | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Termite Inspection
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Termite Spot Treatment
Spreadsheet: 847699d1698550102-based-on-the-criteria-to-one-range-and-count-the-corresponding-values-in-a-different-range-example1
Sheet: Sheet1

Date | Brand | Product | Product Type | Season | Qty
2022-01-04 00:00:00 | abc | 22W23401 | DS | Fall'22 | 2
2022-01-04 00:00:00 | abc | 22W23401 | PT | Fall'22 | 2
2022-01-04 00:00:00 | abc | 22W23401 | DS | Fall'22 | 2
2022-01-04 00:00:00 | abc | 22W24180 | PT | Sum'22 | 1
2022-01-04 00:00:00 | def | 22W24180 | PT | Sum'22 | 3
2022-01-05 00:00:00 | def | 21W19097 | PT | Sum'22 | 4
2022-01-06 00:00:00 | def | 21W20407 | DS | Hol'22 | 2
2022-01-06 00:00:00 | ghi | 21W18191 | DS | Hol'22 | 1
2022-01-06 00:00:00 | ghi | 22W23802 | DS | Sum'22 | 3
2022-01-07 00:00:00 | ghi | 22W25563 | PT | Hol'22 | 3
2022-01-10 00:00:00 | ghi | 22W25563 | CA | Hol'22 | 1
2022-01-10 00:00:00 | abc | 22W24305 | CA | Hol'22 | 2
2022-01-10 00:00:00 | abc | 22W24180 | PT | Sum'22 | 4
2022-01-10 00:00:00 | abc | 21W18175 | CA | Sum'22 | 3
2022-01-11 00:00:00 | def | 22W22227 | DS | Sum'22 | 2
Spreadsheet: 494478d1482411998-convert-unique-individual-with-several-rows-of-data-to-one-row-several-columns-ef1012_sample
Sheet: Sheet2

ID | Code | value | uniq_ID | uniq_code
12341 | 100 | 26836.5
13532 | 100 | 22800
14497 | 100 | 16221
17057 | 100 | 16750
01705 | 100 | 16350
97937 | 100 | 10500
14869 | 100 | 30684
12806 | 100 | 17021.5
17158 | 100 | 17975
87489 | 100 | 23300
88603 | 100 | 15051.5
57178 | 100 | 32450
68902 | 100 | 32652.5
01239 | 100 | 38403.5
97433 | 100 | 23000
17422 | 100 | 26525
14869 | 134 | 1000
16420 | 100 | 14428.5
16197 | 100 | 14233.5
10612 | 100 | 13812
17205 | 100 | 20440
14253 | 100 | 29922.5
16911 | 100 | 16755
17014 | 125 | 360
15913 | 100 | 14123.5
16221 | 100 | 14385
16235 | 100 | 14271.5
16422 | 122 | 1956
16422 | 100 | 14428.5
17014 | 116 | 500
17014 | 115 | 245
17014 | 100 | 12305
Spreadsheet: louise_kitchen__22590__Capital Book Rollforward
Sheet: Sheet1

ENRON Americas
Capital Book
 |  |  |  |  |  |  |  |  | Total Notional |  |  | Value on Date
 |  |  |  |  |  |  |  |  | Quantities (Bcf) |  |  | Transaction Originated
Month |  | Originated |  | Customer |  | EGS Origination |  | (Sales) |  | Purchases |  | (In Thousands) | Monthly Deal Value | Book ID |  | B/S | TERM | PRICE | PUB CODE | Book ID List |  | YTD Book Value
April |  | 2001-04-24 00:00:00 |  | NUI Corp. |  | Capital Book |  | 40000/D |  |  |  |  | 289118 | FT-EAST |  | Capital Book For NUI Deal |  |  |  | NG-PRICE
 |  | 2001-04-23 00:00:00 |  | Michigan Consolidated |  | Capital Book |  | 4.5BCF |  | 4.5BCF |  |  | 169459 | FT-Ontario |  |  | Credit Reserve for Storage deal |  | MICH_CG-GD | GD-HUB
May |  | n/a |  | n/a |  | n/a |  |  |  |  |  |  | 0
June |  | n/a |  | n/a |  | n/a |  |  |  |  |  |  | 0
July |  | n/a |  | n/a |  | n/a |  |  |  |  |  |  | 0
August |  | n/a |  | n/a |  | n/a |  |  |  |  |  |  | 0
September |  | 2001-09-27 00:00:00 |  | BearPaw |  | Capital Book |  | 3000/d |  |  |  |  | 28200 | WT-CAL |  | S | 01/02-12/05 | v | aeco
 |  | 2001-09-27 00:00:00 |  | Azusa |  | Capital Book |  |  |  |  |  |  | -82098
October |  | 2001-10-01 00:00:00 |  | Michigan Consolidate Gas Company |  | Capital Book |  | 2018163 |  | 2000000 |  |  | 97803 | FT-ONTARIO |  | b/s | 12/01-08/02 | 0 | MICH_CG-GD | Ft-Ontario
 |  | 2001-10-04 00:00:00 |  | T Boone Pickens |  | Capital Book |  |  |  |  |  |  | 163000
Note:  All items have been booked to SAP, with the exception of Michigan Gas Company.  This will be booked for October business.
Spreadsheet: andy_zipper__188__DYNEGY-ICE VOL May21
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  May-21-01 thru May-21-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 693390d1598954698-count-office-and-non-office-hour-between-dates-excel-example_bo_ry
Sheet: Sheet1

 | Engineer Onsite Date | Engineer Onsite Time | Engineer Offsite Date | Engineer Offsite Time | No of Office Hours * | No of Non-Office Hours * |  | Office Hour Definition
Example 1 - Sep 5 is Weekend (SAT) | 2020-09-04 00:00:00 | 17:00:00 | 2020-09-05 00:00:00 | 01:30:00 |  |  |  | Monday to Friday, 09:00 - 18:00
Example 2 - Oct 1 is Public Holiday | 2020-10-01 00:00:00 | 16:00:00 | 2020-10-01 00:00:00 | 17:30:00
 |  |  |  |  |  |  |  | Non Office Hour Definition
 |  |  |  |  | * less than 1 hour will count as 1 hour |  |  | Monday to Friday, other than above working hours
 |  |  |  |  |  |  |  | Anytime in Saturday and Sunday
 |  |  |  |  |  |  |  | Public Holiday as below:
 |  |  |  |  |  |  |  | Jan 1, 2020 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  | Jan 25, 2020 | 2020-01-25 00:00:00
 |  |  |  |  |  |  |  | Jan 26, 2020 | 2020-01-26 00:00:00
 |  |  |  |  |  |  |  | Jan 27, 2020 | 2020-01-27 00:00:00
 |  |  |  |  |  |  |  | Jan 28, 2020 | 2020-01-28 00:00:00
 |  |  |  |  |  |  |  | Apr 4, 2020 | 2020-04-04 00:00:00
 |  |  |  |  |  |  |  | Apr 10, 2020 | 2020-04-10 00:00:00
 |  |  |  |  |  |  |  | Apr 11, 2020 | 2020-04-11 00:00:00
 |  |  |  |  |  |  |  | Apr 13, 2020 | 2020-04-13 00:00:00
 |  |  |  |  |  |  |  | Apr 30, 2020 | 2020-04-30 00:00:00
 |  |  |  |  |  |  |  | May 1, 2020 | 2020-05-01 00:00:00
 |  |  |  |  |  |  |  | Jun 25, 2020 | 2020-06-25 00:00:00
 |  |  |  |  |  |  |  | Jul 1, 2020 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  | Oct 1, 2020 | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  | Oct 2, 2020 | 2020-10-02 00:00:00
 |  |  |  |  |  |  |  | Oct 26, 2020 | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Dec 25, 2020 | 2020-12-25 00:00:00
 |  |  |  |  |  |  |  | Dec 26, 2020 | 2020-12-26 00:00:00
Spreadsheet: 210673d1359525660-reset-formula-buttons-my-japanese
Sheet: ナ　けいようし

 | I am, you are | desu | negative | past
active | かっぽつな | かっぽつじゃない | かっぽつです | かっぽつじゃありません | な
beautiful | きれいな | きれいじゃない | きれいです | きれいじゃありません | な
boring | たいくつな | たいくつじゃない | たいくつです | [NAME] | な
energetic | げんきな | げんきじゃない | げんきです | [NAME] | な
fantastic | すてきな | すてきじゃない | すてきです | [NAME] | な
favorable | すきな | すきじゃない | すきです | すきじゃありません | な
feeling good | だいじょうぶな | だいじょうぷじゃない | だいじょうぷです | だいじょうぽじゃありません | な
kind | しんせつな | しんせつじゃない | しんせつです | しんせつじゃありません | な
lively | にぎやかな | にぎやかじゃない | にぎやかです | [NAME] | な
quiet | しずかな | しずかじゃない | [NAME] | しずかじゃありません | な
regretful | ざんねんあ | ざんねんじゃない | ざんねんです | [NAME] | な
skillful | じょうずな | じょうずじゃない | [NAME] | [NAME] | な
ugly | ぷさいくな | ぷさいくじゃない | ぷさいくです | ぷさいくじゃありまん | な
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: East Power Consolidated

 | East Power
 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount
 | Analyst & Associate Headcount
 | Total Headcount
Spreadsheet: 57639d1257861266-summing-numbers-within-certain-dates-example-database-2
Sheet: Sheet1

 | Date | No. of Participants
 | 11.02.09 | 5
 | 01.01.08 | 1
 | 11.11.09 | 4
 | 12.12.09 | 8
 | 05.05.09 | 9
 | 06.06.09 | 12
 | 11.03.09 | 15
 | 01.01.09 | 14
 |  |  |  | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4
 |  |  | Begin | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00
 |  |  | End | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00