tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 158569d1338307368-count-text-and-apply-formulas-book1
Sheet: Sheet1

Text | Date1 | Date2 | Effective |  |  |  | Text Range
ABC | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | First Time |  |  |  | ABC
ABD | 2012-01-15 00:00:00 | 2012-01-17 00:00:00 | First Time |  |  |  | ABD
ABC | 2012-01-20 00:00:00 |  | Repeat |  |  |  | [NAME]
ABD | 2012-01-30 00:00:00 |  | Repeat |  |  |  | Aws
 |  |  |  |  |  |  | adf
 |  |  |  |  |  |  | adf
 |  |  |  |  |  |  | aft
 |  |  |  |  |  |  | ytb
 |  |  |  |  |  |  | dryt
 |  |  |  |  |  |  | wux
 |  |  |  |  |  |  | [NAME]
Spreadsheet: eric_saibi__9675__121701R
Sheet: Dresden 03

Owner Name |  | Exelon Nuclear
Station Name |  | Dresden Nuclear Power Station
Unit Name |  | Dresden 03
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nuclear
Capacity |  | 828 MW
Start Date |  | 2001-12-11 00:00:00
End Date |  | 2001-12-20 00:00:00
Prv. Start Date |  | 2001-12-11 00:00:00
Prv. End Date |  | 2001-12-16 00:00:00
Comments |  | Dry wall cracks
SIC |  | 4931
Plant ID |  | 1009265
Unit ID |  | 1007232
Outage ID |  | 19161
Spreadsheet: 204452d1357538974-assistance-with-linking-data-in-excel-between-spreadsheet-and-template-quote-register
Sheet: BD

Date | Depot | Depot Code | Number | Staff | Staff Code | Quote Reference # | Customer | Crane 1 | Crane 2 | Crane 3 | Crane 4 | Wet Hire or  [NAME]? | Win or Loss | Wet Hire | [NAME]
2013-01-07 00:00:00 | Bunbury |  | 13001 | [NAME] |  |  |  |  |  |  |  |  |  | TEST1.xltm
2013-01-07 00:00:00 | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  | TEST1.xltm
Spreadsheet: 47271d1246273800-prepare-list-of-scheduled-dates-dates-mod-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00 | 2009-06-02 00:00:00 | 2009-06-03 00:00:00 | 2009-06-04 00:00:00 | 2009-06-05 00:00:00 | 2009-06-06 00:00:00 | 2009-06-07 00:00:00 | 2009-06-08 00:00:00 | 2009-06-09 00:00:00 | 2009-06-10 00:00:00 | 2009-06-11 00:00:00 | 2009-06-12 00:00:00 | 2009-06-13 00:00:00 | 2009-06-14 00:00:00 | 2009-06-15 00:00:00 | 2009-06-16 00:00:00 | 2009-06-17 00:00:00 | 2009-06-18 00:00:00 | 2009-06-19 00:00:00 | 2009-06-20 00:00:00 | 2009-06-21 00:00:00 | 2009-06-22 00:00:00 | 2009-06-23 00:00:00 | 2009-06-24 00:00:00 | 2009-06-25 00:00:00 | 2009-06-26 00:00:00 | 2009-06-27 00:00:00 | 2009-06-28 00:00:00 | 2009-06-29 00:00:00 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust1 | 400 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 498.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust2 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 414.9 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust3 | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 441.6 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust4 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 314.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust1 | 2009-06-01 00:00:00 | 2009-06-02 00:00:00 | 2009-06-10 00:00:00 | 2009-06-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust2 | 2009-06-03 00:00:00 | 2009-06-14 00:00:00 | 2009-06-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust3 | 2009-06-06 00:00:00 | 2009-06-17 00:00:00 | 2009-06-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cust4 | 2009-06-02 00:00:00 | 2009-06-14 00:00:00 | 2009-06-24 00:00:00
Spreadsheet: 704067d1605342373-in-a-summary-sheet-different-ways-sum-up-all-values-as-per-criteria-from-multiple-sheets-sum-up-all-amounts-as-per-different-criterias
Sheet: Jan

Date | Name | Amount
2020-01-01 00:00:00 | ABC | 100
2020-01-02 00:00:00 | BCD | 20
2020-01-01 00:00:00 | ABV | 65
2020-01-01 00:00:00 | ASD | 25
2020-01-01 00:00:00 | ASD | 145
2020-01-02 00:00:00 | ABC | 100
2020-01-02 00:00:00 | BCD | 20
2020-01-02 00:00:00 | ABV | 65
2020-01-03 00:00:00 | ASD | 25
2020-01-03 00:00:00 | ASD | 145
Spreadsheet: 733759d1621781454-pull-data-based-on-cell-criteria-sample-workbook_may-20-ans
Sheet: Raw Data

Category | Activity Name | Covered in May'20 | Covered in Jun'20 | Covered in Jul'20
1 | ABC | Yes
2 | DEF | Yes
3 | GHI |  | Yes
4 | JHK |  | Yes
5 | LMN |  |  | Yes
Spreadsheet: 785433d1656413936-index-and-match-to-lookup-a-holiday-date-for-an-employee-holidays
Sheet: Block

BLOCK LEAVE 2023
PERIOD ONE
2023-01-02 00:00:00 | PERSON 1 | PERSON 3 | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | PERSON 2 | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
PERIOD TWO
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | PERSON 1 | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
PERIOD THREE
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | PERSON 1 | VACANT | VACANT | VACANT | VACANT | VACANT
 | PERSON 1 | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
PERIOD FOUR
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | PERSON 1 | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
 | VACANT | VACANT | VACANT | VACANT | VACANT | VACANT
MASTER [NAME]
GUARANTEED LEAVE: 6 BLOCK & 3 ADHOC
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.23.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-23 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 3 | 0 | 2 | 0 | 1 | 0 | 1 | 0 | 0
 | 4TH FL | 38 | 22 | 14 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 13 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 23 | 0 | 6 | 0 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 2 | 0 | 0 | 1 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-23 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 17 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 16 | 0 | 3 | 1 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 19 | 0 | 5 | 0 | 3 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0
 | Total MED
 | JKL | 26 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 856081d1705462184-arrange-data-from-multiple-columns-in-1-single-column-excelh3
Sheet: Sheet1

 |  |  |  |  | What I have
 |  |  |  |  | 2.338 | 2.36 | 0.4426 | 0.3788
 |  |  |  |  | 2.762 | 0.9588 | 3.757 | 0.7464
 |  |  |  |  | 1.209 | 3.763 | 1.048 | 0.7629
 |  |  |  |  | 3.759 | 1.056 | 0.7628 | 4.509 |  |  |  | What I want
 |  |  |  |  | 1.049 | 0.7628 | 4.509 | 3.523 |  |  |  | 2.338
 |  |  |  |  | 0.7631 | 4.509 | 3.523 | 0.7443 |  |  |  | 2.762
 |  |  |  |  |  |  |  |  |  |  |  | 1.209
 |  |  |  |  |  |  |  |  |  |  |  | 3.759
 |  |  |  |  |  |  |  |  |  |  |  | 1.049
 |  |  |  |  |  |  |  |  |  |  |  | 0.7631
 |  |  |  |  |  |  |  |  |  |  |  | 2.36
 |  |  |  |  |  |  |  |  |  |  |  | 0.9588
 |  |  |  |  |  |  |  |  |  |  |  | 3.763
 |  |  |  |  |  |  |  |  |  |  |  | 1.056
 |  |  |  |  |  |  |  |  |  |  |  | 0.7628
 |  |  |  |  |  |  |  |  |  |  |  | 4.509
 |  |  |  |  |  |  |  |  |  |  |  | 0.4426
 |  |  |  |  |  |  |  |  |  |  |  | 3.757
 |  |  |  |  |  |  |  |  |  |  |  | 1.048
 |  |  |  |  |  |  |  |  |  |  |  | 0.7628
 |  |  |  |  |  |  |  |  |  |  |  | 4.509
 |  |  |  |  |  |  |  |  |  |  |  | 3.523
 |  |  |  |  |  |  |  |  |  |  |  | 0.3788
 |  |  |  |  |  |  |  |  |  |  |  | 0.7464
 |  |  |  |  |  |  |  |  |  |  |  | 0.7629
 |  |  |  |  |  |  |  |  |  |  |  | 4.509
 |  |  |  |  |  |  |  |  |  |  |  | 3.523
 |  |  |  |  |  |  |  |  |  |  |  | 0.7443
Spreadsheet: john_griffith__15561__2 01 FOM
Sheet: Sheet1

 | 2001-02-01 00:00:00
 |  |  | First of the Month Nom
 |  |  | MMBtu/d
 | East Taylor Point | TGT meter #9502 | 2997
 | [NAME] ([NAME]) | TGT meter #9437 | 14219
 |  |  |  |  | Total Nom to TGT
 |  |  | -11480 |  | VPP - IF TGT + $.0025 [Brazos]
 |  |  |  |  | Excess [Preston]
 |  |  |  |  | Excess Gas Pricing:
 |  |  |  |  | 90% - Priced @ IF TGT + $.0025
 |  |  |  |  | 10% - Priced @ GDA
 |  |  |  | chk
Spreadsheet: 843517d1695310078-copying-over-date-in-separate-sheet-with-new-rows-test-book
Sheet: Sheet1

Date | 2023-09-20 00:00:00 | 2023-09-21 00:00:00 | 2023-09-22 00:00:00 | 2023-09-23 00:00:00
Start | 11:12:00 | 12:12:00
End | 11:30:00 | 12:30:00
Duration
Person 1 | Yes | Yes
Person 2 | Yes | Yes
Person 3 | Yes | Yes
Person 4 | No | Yes
Person 5 | Yes | Yes
Person 6 | Yes | Yes
Person 7 | Yes | Yes
Person 8 | Yes | Yes
Person 9 | No | Yes
Person 10 | Yes | No
Person 11 | Yes | Yes
Person 12 | Yes | Yes
Person 13 | Yes | Yes
Person 14 | Yes | Yes
Person 15 | Yes | Yes
Person 16 | No | Yes
Person 17 | Yes | No
Person 18 | Yes | Yes
Person 19 | Yes | Yes
Person 20 | Yes | Yes
Visitor
Percentage
Total value | 10 | 14
Total Loss | 5 | 3
Date of Last Theft | Sept 21st 2023 | Sept 21st 2023
Staff Affected | 4 | 1
Visitors Affected | 3 | 2
Priority | 2 | 4
Which Person | Person 4 | Person 10
Product | Shoes | Candles
Number of Product 1 | 10 | 16
Product 2 | Sandals
Number of Product 2 | 20
Staff [NAME] | [NAME] | [NAME]
Reorder? | Yes | No
Other Info
Which Person | Person 5
Product | Shirts
Number of Product 1 | 20
Product 2 | Sweaters
Number of Product 2 | 30
Staff [NAME] | [NAME]
Reorder? | No
Other Info
Which Person | Person 11
Product | Gloves
Number of Product 1 | 17
Product 2
Number of Product 2
Staff [NAME] | [NAME]
Reorder? | Yes
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Which Person
Product
Number of Product 1
Product 2
Number of Product 2
Staff [NAME]
Reorder?
Other Info
Spreadsheet: 489682d1479387888-generate-vacationplan-in-excel-ferieoversikt_ikt_2016_test
Sheet: 2015 og 2016 uger

 |  | 1. [NAME] 2015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. [NAME] 2015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. [NAME] 2016 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. [NAME] 2016
 |  | Ja |  |  |  |  | Februar |  |  |  | Marts |  |  |  | April |  |  |  |  | Maj |  |  |  | Juni |  |  |  | [NAME] |  |  |  |  | August |  |  |  | September |  |  |  | Oktober |  |  |  |  | November |  |  |  | December |  |  |  |  | Ja |  |  |  |  | Februar |  |  |  | Marts |  |  |  | April |  |  |  |  | Maj |  |  |  | Juni |  |  |  | [NAME] |  |  |  |  | August |  |  |  | September |  |  |  | Oktober |  |  |  |  | November |  |  |  | December
 |  | U1 | U2 | U3 | U4 | U5 | U6 | U7 | U8 | U9 | U10 | U11 | U12 | U13 | U14 | U15 | U16 | U17 | U18 | U19 | U20 | U21 | U22 | U23 | U24 | U25 | U26 | U27 | U28 | U29 | U30 | U31 | U32 | U33 | U34 | U35 | U36 | U37 | U38 | U39 | U40 | U41 | U42 | U43 | U44 | U45 | U46 | U47 | U48 | U49 | U50 | U51 | U52 | U53 | U1 | U2 | U3 | U4 | U5 | U6 | U7 | U8 | U9 | U10 | U11 | U12 | U13 | U14 | U15 | U16 | U17 | U18 | U19 | U20 | U21 | U22 | U23 | U24 | U25 | U26 | U27 | U28 | U29 | U30 | U31 | U32 | U33 | U34 | U35 | U36 | U37 | U38 | U39 | U40 | U41 | U42 | U43 | U44 | U45 | U46 | U47 | U48 | U49 | U50 | U51 | U52
 |  | 29 | 5 | 12 | 19 | 26 | 2 | 9 | 16 | 23 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29 | 6 | 13 | 20 | 27 | 3 | 10 | 17 | 24 | 31 | 7 | 14 | 21 | 28 | 5 | 12 | 19 | 26 | 2 | 9 | 16 | 23 | 30 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29 | 5 | 12 | 19 | 26 | 3 | 10 | 17 | 24 | 31 | 7 | 14 | 21 | 28 | 5 | 12 | 19 | 26
Opgave | Ansvar | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M
Spreadsheet: 0715113a-4ffd-4244-b468-5f4014540573
Sheet: Sheet1

Unnamed: 0 | Konzern-Kapitalflussrechnung. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | in Mio. € | Anmerkung | 2008 | 2007* | 2006*
 |  | 38
 | [NAME] |  | 2 024 | 1 080 | 3 582
 | Abschreibungen auf immaterielle Vermögenswerte und Sachanlagen |  | 10 975 | 11 611 | 11 034
 | Ertragsteueraufwand/-ertrag |  | 1 428 | 1 373 | (970)
 | Zinserträge und -aufwendungen |  | 2 487 | 2 514 | 2 540
 | [NAME] |  | 713 | 374 | 167
 | Ergebnis aus at equity bilanzierten Unternehmen |  | 388 | (55) | (32)
 | Ergebnis aus dem [NAME] voll [NAME] |  | (455) | (379) | –
 | Sonstige zahlungsunwirksame Vorgänge |  | (147) | 124 | 32
 | Ergebnis aus dem [NAME] immaterieller Vermögenswerte und Sachanlagen |  | 70 | (42) | (72)
 | Veränderung aktives Working Capital |  | 286 | (1 072) | (17)
 | Veränderung der Rückstellungen |  | 493 | 1 825 | 1 585
 | [NAME] übriges passives Working Capital |  | (130) | (1 391) | 353
 | Erhaltene/(Gezahlte) Ertragsteuern |  | (520) | 171 | (1 248)
 | [NAME] |  | 13 | 36 | 27
 | Operativer Cash-Flow |  | 17 625 | 16 169 | 16 981
 | [NAME] |  | (3 431) | (4 005) | (4 081)
 | [NAME] |  | 1 174 | 1 550 | 1 322
 | Cash-Flow aus Geschäftstätigkeit |  | 15 368 | 13 714 | 14 222
 | Auszahlungen für Investitionen in
 | – Immaterielle Vermögenswerte |  | (1 799) | (1 346) | (4 628)
 | – Sachanlagen |  | (6 908) | (6 669) | (7 178)
 | – Langfristige finanzielle Vermögenswerte |  | (3 261) | (264) | (624)
 | – Anteile voll [NAME] und Geschäftseinheiten |  | (1 030) | (1 547) | (2 265)
 | Einzahlungen aus Abgängen von
 | – [NAME] |  | 34 | 39 | 35
 | – Sachanlagen |  | 338 | 722 | 532
 | – [NAME] finanziellen [NAME] |  | 102 | 133 | 249
 | – [NAME] voll [NAME] und Geschäftseinheiten |  | 778 | 888 | (21)
 | [NAME] [NAME] (Laufzeit mehr als 3 Monate),
 | Wertpapiere und Forderungen des kurzfristigen finanziellen [NAME] |  | 611 | (60) | (348)
 | Sonstiges |  | (249) | 50 | (57)
 | Cash-Flow aus Investitionstätigkeit |  | (11 384) | (8 054) | (14 305)
 | Aufnahme kurzfristiger [NAME] |  | 39 281 | 32 514 | 3 817
 | [NAME] kurzfristiger [NAME] |  | (44 657) | (35 259) | (9 163)
 | Aufnahme mittel- und langfristiger [NAME] |  | 6 477 | 1 586 | 7 871
 | [NAME] mittel- und langfristiger [NAME] |  | (96) | (1 020) | (492)
 | Dividendenausschüttungen |  | (3 963) | (3 762) | (3 182)
 | Aktienrückkauf |  | – | – | (709)
 | Kapitalerhöhung aus Aktienoptionen |  | 3 | 24 | 16
 | [NAME] |  | (142) | (208) | (219)
 | Cash-Flow aus Finanzierungstätigkeit |  | (3 097) | (6 125) | (2 061)
 | [NAME] auf die Zahlungsmittel (Laufzeit bis 3 Monate) |  | (61) | (100) | (66)
 | Nettoveränderung der Zahlungsmittel (Laufzeit bis 3 Monate) |  | 826 | (565) | (2 210)
 | [NAME] am [NAME] |  | 2 200 | 2 765 | 4 975
 | [NAME] am Ende des Jahres |  | 3 026 | 2 200 | 2 765
 | *Vorjahreswerte angepasst. Bilanzierungsänderung im [NAME] mit IFRIC 12. Erläuterungen unter „Grundlagen und Methoden/Änderung der Bilanzierungs- und Bewertungsmethoden“.
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -5551 | -11697
9238 | -2910 | -3000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -343493 | -339544
58710 | -424 | -3522
60921 | -218213 | -249246
78026 | 9528 | 8542
500084 | -5990 | -8980
500085 | -29892 | -15000
500097 | -7176
INDEX
2001-01-31 00:00:00 |  |  | 1123225.45
2001-02-03 00:00:00
Spreadsheet: 855245d1704890251-removing-a-number-from-a-list-in-a-cell-if-it-appears-elsewhere-unallocated-duties
Sheet: Duty Allocation

 | 2023-12-01 00:00:00 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 |  |  |  | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty
 | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME] | OFF | OFF | 7 |  |  |  |  |  |  | 2023-12-01 00:00:00 | [NAME] | Stuart | NA | [NAME] | [NAME] | NA | NA | NA | NA | NA
[NAME] | 1 | 3 |  | OFF | OFF |  |  |  |  | 2023-12-02 00:00:00 |  |  | [NAME]
Stuart | 2 |  | 10 |  |  | OFF | OFF |  |  | 2023-12-03 00:00:00 |  |  |  |  |  |  | [NAME] |  |  | Stuart
[NAME] | 5 | OFF | OFF |  |  |  |  |  |  | 2023-12-04 00:00:00
[NAME] | 4 |  | OFF | OFF |  |  |  |  |  | 2023-12-05 00:00:00
[NAME] | OFF |  |  |  |  |  | OFF |  |  | 2023-12-06 00:00:00
Duties to Cover | 3 | 1 2 4 5 | 6 8 9 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 1 2 3 4 5 |  |  | 2023-12-07 00:00:00
Alternatively Maybe Like This
Duties to Cover | 1 2 3 4 5 | 1 2 3 4 5 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 1 2 3 4 5
Unallocated | 3 | 1 2 4 5 | 6 8 9 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 1 2 3 4 5
Spreadsheet: c4aa1d8a-9b9a-4ca5-9ef7-b65cc91847b8
Sheet: Horizon

 |  |  | HORIZON SNACK FOODS
 |  |  | SCHOOL YEAR 2013 - 2014
 |  |  | COMMODITY CALCULATOR
 |  |  | FRUIT POCKETS
 |  |  |  | Srving | Net | Srvings | Srvings | Cases | Menus | Total | DF LBS | DF LBS
 |  |  | Meal Pattern | Size | Case Wt | per | per | per | per | Cases | per | Needed
Item # | Product Description | USDA COMMODITY | Contribution | (oz) | LBS | Menu | Case | Menu | SY | per SY | Case | per SY
1402-1 | Apple Fruit Pocket | A346  100258 Apple Slices Frozen IQF | 1/2 C Fruit/2 WG Breads | 3.95 oz | 19.75 |  | 80 |  |  |  | 12.4983
1402-3 | Cherry Fruit Pocket | A364  100237 Cherries [NAME] | 1/2 C Fruit/2 WG Breads | 3.95 oz | 19.75 |  | 80 |  |  |  | 13.4258
1401-1 | Apple Fruit Pocket | A346  100258 Apple Slices Frozen IQF | 1/4 C Fruit/1 WG Bread | 2.0 oz | 15 |  | 120 |  |  |  | 9.3737
1401-3 | Cherry Fruit Pocket | A364  100237 Cherries [NAME] | 1/4 C Fruit/1 WG Bread | 2.0 oz | 15 |  | 120 |  |  |  | 10.2668
 |  |  |  |  |  |  |  |  | Apple lbs:
 |  |  |  |  |  |  |  |  | [NAME] lbs: