tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686325d1594500652-salary-increase-per-team-across-year-salcalc
Sheet: Sheet1

Department | Start Date | End Date | Name | Monthly Salary | Starting Salary | Currently Employed | Increase Number | Current Salary | Increase 1 | Increase Date From | Increase Date To | Increase 2 | Increase Date From | Increase Date To | Increase 3 | Increase Date From | Increase Date To | Increase 4 | Increase Date From | Increase Date To | Increase 5 | Increase Date From | Increase Date To | Increase 6 | Increase Date From | Increase Date To | Increase 7 | Increase Date From | Increase Date To | Increase 8 | Increase Date From | Increase Date To | Increase 9 | Increase Date From | Increase Date To | Increase 10 | Increase Date From | Increase Date To
Team 1 | 2019-01-27 00:00:00 |  | [NAME] |  | 21000
Team 3 | 2018-11-10 00:00:00 |  | [NAME] |  | 18000 |  |  |  | 21000 | 2019-05-04 00:00:00
Team 1 | 2018-03-20 00:00:00 |  | Nick |  | 30000
Team 5 | 2020-01-27 00:00:00 |  | [NAME] |  | 35000
Team 5 | 2019-11-25 00:00:00 | 2020-05-28 00:00:00 | Abbey |  | 28000 |  |  |  | 29000 | 2020-05-28 00:00:00
Team 4 | 2020-02-24 00:00:00 | 2020-06-30 00:00:00 | [NAME] |  | 25000
Team 5 | 2019-07-02 00:00:00 | 2020-02-28 00:00:00 | [NAME] |  | 21500
Team 1 | 2015-02-03 00:00:00 | 2020-06-30 00:00:00 | [NAME] |  | 45000 |  |  |  | 48000 | 2019-02-02 00:00:00
Team 4 | 2014-02-10 00:00:00 |  | Fred |  | 35000
 | Range Start | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
 | Range End
Department |  | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January
Team 1
Team 2
Team 3
Team 4
Team 5
Spreadsheet: john_griffith__15913__11_13_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 280 | 37 | 38 | 84.7 | 87 | 15.11 | 2001-11-13 14:41:00
 | NG F2 | 300 | 66 | 67 | 80.9 | 82.2 | 15.38 | 2001-11-13 14:41:00
 | NG G2 | 300 | 78 | 81 | 72.3 | 75.1 | 13.9 | 2001-11-13 14:41:00
 | NG H2 | 300 | 81 | 83 | 64.4 | 66 | 12.3 | 2001-11-13 14:41:00
 | NG J2 | 295 | 76.5 | 77.5 | 55.1 | 55.8 | 10.28 | 2001-11-13 14:41:00
 | NG K2 | 300 | 79 | 80.5 | 50.5 | 51.5 | 9.62 | 2001-11-13 14:41:00
 | NG M2 | 305 | 85 | 87 | 49 | 50.2 | 9.51 | 2001-11-13 14:41:00
 | NG N2 | 310 | 92 | 94 | 49 | 50.1 | 9.66 | 2001-11-13 14:41:00
 | NG Q2 | 310 | 100 | 103 | 50.2 | 51.7 | 9.93 | 2001-11-13 14:41:00
 | NG U2 | 310 | 104 | 109 | 49.5 | 51.9 | 9.88 | 2001-11-13 14:41:00
 | NG V2 | 320 | 110 | 115 | 48.5 | 50.7 | 9.98 | 2001-11-13 14:41:00
 | NG X2 | 340 | 124 | 126 | 49.2 | 50 | 10.6 | 2001-11-13 14:41:00
 | [NAME] | 360 | 135 | 140 | 49 | 50.9 | 11.31 | 2001-11-13 14:41:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 688773d1595948081-calculating-interval-data-for-specific-dates-and-times-interval-data
Sheet: Sheet2

 | Date
Interval | 2020-05-29 00:00:00 | 2020-06-02 00:00:00
00:00:00
00:30:00
01:00:00
01:30:00
02:00:00
02:30:00
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
23:30:00
Spreadsheet: 794913d1662396689-conditional-formatting-to-highlight-all-values-from-a-cell-table-1-
Sheet: CHORDS

 | Chord intervals |  |  |  |  |  |  | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1
 | 1 3 b5 b7 |  |  |  |  |  |  | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5
 |  |  |  |  |  |  |  | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3
 |  |  |  |  |  |  |  | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7
 |  |  |  |  |  |  |  | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4
 |  |  |  |  |  |  |  | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1
Spreadsheet: 220069d1363045189-find-row-where-time-value-falls-between-start-and-end-time-values-time-activity-problem
Sheet: Activites

Name | Activity | Start Time | End Time
[NAME] | Sales | 2013-03-05 13:46:03 | 2013-03-05 13:46:16
[NAME] | Paperwork | 2013-03-05 13:46:49 | 2013-03-05 13:47:20
[NAME] | kissing up to the boss | 2013-03-05 14:37:55 | 2013-03-05 14:38:15
[NAME] | Inventory | 2013-03-05 14:38:15 | 2013-03-05 14:52:58
[NAME] | Sales | 2013-03-05 15:01:15 | 2013-03-05 15:01:18
[NAME] | Paperwork | 2013-03-05 15:01:18 | 2013-03-05 15:41:07
[NAME] | kissing up to the boss | 2013-03-05 15:41:07 | 2013-03-05 15:54:59
[NAME] | Inventory | 2013-03-05 16:18:41 | 2013-03-05 16:18:47
[NAME] | Sales | 2013-03-05 16:18:53 | 2013-03-05 16:19:24
[NAME] | Paperwork | 2013-03-05 16:19:40 | 2013-03-05 16:21:58
[NAME] | kissing up to the boss | 2013-03-05 16:34:13 | 2013-03-05 16:34:14
[NAME] | Inventory | 2013-03-05 16:34:24 | 2013-03-05 16:34:31
[NAME] | Sales | 2013-03-05 16:34:33 | 2013-03-05 16:34:38
[NAME] | Paperwork | 2013-03-05 16:36:15 | 2013-03-05 16:36:32
[NAME] | kissing up to the boss | 2013-03-05 16:39:53 | 2013-03-05 16:40:10
[NAME] | Inventory | 2013-03-05 16:43:23 | 2013-03-05 16:43:30
[NAME] | Sales | 2013-03-05 16:43:41 | 2013-03-05 16:43:59
[NAME] | Paperwork | 2013-03-05 16:45:56 | 2013-03-05 16:46:16
[NAME] | kissing up to the boss | 2013-03-05 16:51:16 | 2013-03-05 16:51:34
[NAME] | Inventory | 2013-03-05 16:51:50 | 2013-03-05 16:52:05
[NAME] | Sales | 2013-03-05 16:52:12 | 2013-03-05 16:52:30
[NAME] | Paperwork | 2013-03-05 17:14:01 | 2013-03-05 17:15:08
[NAME] | kissing up to the boss | 2013-03-05 17:15:08 | 2013-03-05 17:15:46
[NAME] | Inventory | 2013-03-05 17:22:20 | 2013-03-05 17:24:04
[NAME] | Sales | 2013-03-05 17:24:04 | 2013-03-05 17:25:08
[NAME] | Paperwork | 2013-03-05 17:30:24 | 2013-03-05 17:30:34
[NAME] | kissing up to the boss | 2013-03-05 17:30:34 | 2013-03-05 17:30:46
[NAME] | Inventory | 2013-03-05 17:35:40 | 2013-03-05 17:37:30
[NAME] | Sales | 2013-03-05 17:37:30 | 2013-03-05 17:40:49
Spreadsheet: 727748d1618069379-need-help-with-filter-and-name-look-up-book1
Sheet: Sheet1

# | NAME | SERIAL NUMBER | JOB | PLACE | EDUCATION | SEX
1 | TOM | 112233 | ACCOUNTS | DUBAI | UNIVERSITY | MALE |  |  |  | JOB |  |  | EDUCATION |  |  | SEX
2 | JACK | 112244 | DRIVER | ABUDHABI | DIPLOMA | MALE
3 | MARTIN | 112255 | SALESMAN | [NAME] | UNIVERSITY | MALE
4 | SMITH | 112266 | HR | AJMAN | DIPLOMA | MALE |  |  |  | # | NAME | SERIAL NUMBER | JOB | PLACE | EDUCATION | SEX
5 | DANIEL | 112277 | FINANCE | RAS AL KHAIMAH | UNIVERSITY | MALE
6 | CLARK | 112288 | CEO | [NAME] | HIGH SCHOOL | FEMALE
7 | ANNE | 112299 | PURCHASE | FUJEIRAH | UNIVERSITY | FEMALE
8 | LISA | 112200 | SALESMAN | [NAME] | UNIVERSITY | FEMALE
9 | MONA | 112211 | WAREHOUSE | MADINAT ZAYED | HIGH SCHOOL | FEMALE
10 | BRAD | 112222 | ACCOUNTS | DUBAI | UNIVERSITY | MALE
 | JOBS | EDUCATION | SEX
 | ACCOUNTS | UNIVERSITY | MALE
 | DRIVER | DIPLOMA | FEMALE
 | SALESMAN | HIGH SCHOOL
 | HR
 | CEO
 | PURCHASE
 | WAREHOUSE
Spreadsheet: 801602d1666270858-data-retrieval-from-multiple-sheets-for-multiple-variables-excel-file
Sheet: Check

 |  |  | Table 1 | Short Term Accounts | Currency | Amount Extract |  |  |  | System |  | Gap
 |  |  |  | 2310100 | CAD
 |  |  |  | 2320200 | [NAME]
 |  |  |  | 2330300 | USD
 | List ID | [NAME] | Table 2 |  |  |  |  |  |  | System |  | Gap
 |  |  | Entity | Counterparty | Currency | Balance amount in Acct. Currency |  |  | The formulas needed in column K => | Balance Amount in Acct. Currency
 | 1 |  |  |  |  |  | ST
 |  |  |  |  |  |  | ST |  | search for value in sheet 2330300 & column O, for the references from sheet Extract (cell V5) and equivalent to column N sheet 2330300 =>
 |  |  |  |  |  |  | LT |  | Search in sheet System, column J, for value of the account 2220004 =>
 |  |  |  |  |  |  |  |  | always sum of all transactions from sheet 1340001 column K=>
 |  |  |  |  |  |  | ST
 |  |  |  |  |  |  | LT |  | Search in sheet System, column J, for value of the account 2220001 =>
Spreadsheet: 147923d1333036413-pull-in-a-number-based-on-an-answer-that-falls-in-different-ranges-pull-in-a-number
Sheet: Sheet2

2313 |  | 1000 | 2000 | 1.04
 |  | 2000 | 3000 | 1.08
 |  | 3000 | 4000 | 1.12
 |  | 4000 | 5000 | 1.16
 |  | 5000 | 6000 | 1.2
 |  | 7000 | 8000 | 1.24
Spreadsheet: 194538d1353231373-display-the-value-of-a-row-with-the-higher-corresponding-bottom-value-example
Sheet: Foglio1

100 | 0 | -100 | -100 | -100 |  | -100 | -100
50 | 0 | 0 | -50 | 50 |  | 50 | 50
25 | 25 | -25 | 0 | 0 |  | 25 | 25
0 | 0 | 0 | 0 | 0 |  | 0 | 0
40 | -40 | 40 | -40 | 0 |  | -40 | -40
10 | 50 | 40 | 20 | 30 | INDEX
Spreadsheet: tracy_geaccone__40259__C0366-111727
Sheet: Dept_100192

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
CAFETERIA - Dept. 100192
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-06-21 00:00:00 | CFT2001/06-0366/111727 |  | Work Place | Work Place Count | 7 | 14.08 | /MNTH | 98.56
 |  |  |  |  |  |  | Ticket Total |  | 98.56
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 98.56
 |  |  |  |  |  |  | Total for Dept_100192 |  | 98.56
Spreadsheet: 118489d1313726935-group-picker-improvement-fix-needed-grouppicker-jvr-4-and-5-4-and-3
Sheet: GroupP4&3

ID | Students |  | 25 | <<  # of Students
23 | MAHONRI S |  |  | [NAME] |  | Group:1 | MAHONRI S | KONI O | JOSEPHINE | MICHELE T
17 | KONI O |  | 4 | <<   4-Somes |  | Group:2 | ROSS M | PAENUI L | NALIA K | TUTEPAOA T
13 | JOSEPHINE |  | 3 | <<   3-Somes |  | Group:3 | TAYLOR W | GEMMA C | MANSHIK V | KIOLA F
25 | MICHELE T |  |  |  |  | Group:4 | WHITNEY R | KEISHA P | JOSHUA L | ARAHINA P
14 | ROSS M |  | 7 | <<Total Teams |  | Group:5 | AMY-LEE A | CALEB H | TYSON C | NIKLAUS B | [NAME]
10 | PAENUI L |  |  |  |  | Group:6 | SHARUQ R | SHAUN N | SHAE N | BIANCA K
7 | NALIA K |  |  |  |  | Group:7
24 | TUTEPAOA T
27 | TAYLOR W
3 | GEMMA C
26 | MANSHIK V
5 | KIOLA F
22 | WHITNEY R
18 | KEISHA P
9 | JOSHUA L
19 | ARAHINA P
1 | AMY-LEE A
6 | CALEB H
4 | TYSON C
2 | NIKLAUS B
12 | [NAME]
21 | SHARUQ R
15 | SHAUN N
16 | SHAE N
8 | BIANCA K
Spreadsheet: 83087d1283153107-excel-2007-assigning-values-in-cells-and-then-summing-total-score-excluding-blanks-scoring-table
Sheet: Sheet1

 | ac1 | ty1 | ac2 | ty2 | ac3 | ty3 | ac4 | ty4 | ac5 | ty5 | ac6 | ty6 | ac7 | ty7 | ac8 | ty8 | ac9 | ty9 | Score??
person1 | 2 | 2 | 1 | 3 | 2 | 3 | 2 | 1 | 2 | 1 |  |  | 1 |  | 4 |  | 2 | 3
person2
person3 | 1 | 2 | 2 | 3 | 4 |  | 2 | 1 | 2 | 1 | 3 | 5 | 2 | 1 | 4 | 2 | 1 | 3
person4
person5 | 2 | 2 | 1 | 5 | 1 | 5 | 1 | 5 | 2 | 1 | 2 | 3 | 1 | 5 | 1 | 5 | 2 | 3
person6
person7
person8 | 2 | 2 | 1 |  | 2 | 3 | 2 | 1 | 2 | 1 | 2 | 3 | 1 |  | 2 | 2 | 2 | 3
person9 | 2 | 3 | 1 |  | 2 | 3 | 2 | 1 | 2 | 1 | 2 | 3 | 1 |  | 4 |  | 1 | 3
person10
person11
person12
[NAME]
person14
person15 | 2 | 2 | 4 |  | 2 | 3 | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 2 | 3
person16
person17
person18
person19 | 3 | 5 | 2 | 5 | 2 | 3 | 2 | 1 |  | 1 | 2 | 3 | 4 |  |  | 2 | 2 | 3
[NAME] | 1 |  | 1 |  | 2 | 3 | 1 |  | 2 | 1 | 4 |  | 1 |  | 3 |  | 2 | 3
person21
person22
person23 | 4 |  | 4 |  | 4 |  | 1 |  | 2 | 3 | 3 |  | 1 |  | 3 |  | 4
Spreadsheet: 801661d1666284323-struggling-with-a-sum-if-formula-sum-if-difficulty
Sheet: Sheet1

JOB | Number from Team A | Number from Team B | 01-Jan-23 | 02-Jan-23 | 03-Jan-23 |  |  | Column1 | Team A | Team B
1 | 2 | 2 | 1.5 | 1.5 | 1.5 |  |  | 2023-01-01 00:00:00 | 2 | 2
2 | 2 | 2 | 1.5 | 1.5 | 1.5 |  |  | 2023-01-02 00:00:00 | 6 | 6
3 | 1 |  |  |  |  |  |  | 2023-01-03 00:00:00 | 7 | 6
4 | 1
5 | 1
6 | 1
7 | 1 |  |  |  | 2
8 | 1
9 | 1
10 | 1
11 | 1 | 2
12 | 1 | 2
13 | 2 | 2 |  | 3 | 3
14 |  | 2
15 |  | 1
16 |  | 1
17 | 2
18 | 2
19
20
Spreadsheet: 265986d1379456659-comparing-the-balance-of-a-paypal-account-with-other-numbers-from-the-spreadsheet-model-kits-for-forum
Sheet: Paid Out

DATE | PAID OUT |  | DATE | PAID OUT |  | DATE | PAID OUT |  | DATE | PAID OUT |  | DATE | PAID OUT |  | DATE | PAID OUT |  | DATE | PAID OUT | TO | SHARE | PAID OUT | STILL OWE
2012 | 1300 |  | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M
2012 | 1300 |  | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
2012 | 2713 |  | 2013 |  |  | Sep 13th | 250 |  |  |  |  |  |  |  |  |  |  |  |  | F
Spreadsheet: 268569d1380694693-how-can-i-find-team-name-above-and-count-the-time-since-last-game-nhl-excel-forum
Sheet: Taul1

DATE | TIME | TEAMHOME | TEAMAWAY | Home team time since last game | Away team time since last game
2013-10-02 00:00:00 | 02:00:00 | philadelphia | toronto
2013-10-02 00:00:00 | 03:00:00 | detroit | buffalo
2013-10-02 00:00:00 | 05:00:00 | colorado | anaheim
2013-10-03 00:00:00 | 02:00:00 | montreal | toronto
2013-10-03 00:00:00 | 03:00:00 | chicaco | washington
2013-10-03 00:00:00 | 05:00:00 | edmonton | winnipeg
2013-10-04 00:00:00 | 02:00:00 | boston | tampa
2013-10-04 00:00:00 | 02:00:00 | pittsburgh | [NAME]
2013-10-04 00:00:00 | 02:00:00 | washington | calgary
2013-10-04 00:00:00 | 03:00:00 | minnesota | los angeles
2013-10-04 00:00:00 | 03:30:00 | dallas | florida
2013-10-04 00:00:00 | 03:30:00 | st louis | nashville
2013-10-04 00:00:00 | 05:00:00 | [NAME] | rangers
2013-10-04 00:00:00 | 05:00:00 | san jose | vancouver
Spreadsheet: 738167d1624883256-finding-the-maximum-between-4-variables-mappe1
Sheet: Tabelle1

 | "Participant" | "1_Neutral" | "1_Happy" | "1_Surprised" | "1_Sad" | "1_Angry" | "1_Scared" | "1_Disgusted" | "1_Contempt" |  | [NAME]
1 | 109 | 0.644764576111834 | 0.00344786714044213 | 0.0186654190715215 | 0.115745883241873 | 0.0101221860182055 | 0.000724367855656697 | 0.000669524801040312 | 0.000582628817945384
2 | 110 | 0.649348220761671 | 0.0358455942616708 | 0.0184492965356265 | 0.00265949047788698 | 0.00130460764004914 | 0.00112445477149877 | 0.00505755598648649 | 0.00679897095823096
3 | 111 | 0.588311761851852 | 0.0119776674925926 | 0.0186308245617284 | 0.0374461030901235 | 0.0112350046493827 | 0.00799714631111111 | 0.0204276727395062 | 0.00414964294074074
4 | 112 | NA | NA | NA | NA | NA | NA | NA | NA
5 | 113 | NA | NA | NA | NA | NA | NA | NA | NA
6 | 114 | NA | NA | NA | NA | NA | NA | NA | NA
7 | 115 | 0.650263312187919 | 0.0107601104671141 | 0.0244619301959732 | 0.141909515065772 | 0.00412583744563758 | 0.0308269281825503 | 0.00599083613422819 | 0.00232108546845638
8 | 116 | 0.709588214827109 | 0.110603266330567 | 0.0236097714757953 | 0.0506539575408022 | 0.00403557107745505 | 0.0105776616417704 | 0.00359326620470263 | 0.00504766015214385
9 | 117 | 0.704969672631579 | 0.0242334902210526 | 0.0166381187697368 | 0.[PHONE] | 0.00581440682236842 | 0.00791218796184211 | 0.0255023136684211 | 0.00968640628815789
10 | 118 | 0.569835562690542 | 0.0245783636905418 | 0.0147425296216713 | 0.228787832421488 | 0.00291721614784206 | 0.0234992656657484 | 0.000883732572084481 | 0.00518402137465565
11 | 119 | 0.841981593582453 | 0.0251244861405362 | 0.00249321896669374 | 0.020340612037368 | 0.0119957879301381 | 0.004082781981316 | 0.000764892861900894 | 0.00231738081153534
12 | 120 | 0.526079386933388 | 0.23295936842892 | 0.0109174318017872 | 0.0262718981624695 | 0.00271476789358245 | 0.0205808146393176 | 0.0496540526181966 | 0.00310925072623883
Spreadsheet: 09d44c63-68e0-4904-bea6-24954acd733a
Sheet: 2013 by quarter

PEABODY ENERGY CORPORATION
Key Performance Indicators
([NAME])
 |  |  | Quarter Ended
 |  |  | March 31, 2013
[NAME] (In Millions)
 | Midwestern U.S. Mining Operations |  | 6.5
 | Western U.S. Mining Operations |  | 37.6
 | Australian Mining Operations |  | 8.3
 | Trading and Brokerage Operations |  | 4.8
 | Total |  | 57.2
Revenues - Mining Operations |  |  | $'s in millions |  | $'s per ton
 | Midwestern U.S. |  | 336.7 |  | 51.39
 | Western U.S. |  | 640.1 |  | 17.04
 | Total - U.S. Mining Operations |  | 976.8 |  | 22.14
 | Australia |  | 738 |  | 89.3
Operating Costs - Mining Operations
 | Midwestern U.S. |  | 224.4 |  | 34.25
 | Western U.S. |  | 479.6 |  | 12.77
 | Total - U.S. Mining Operations |  | 704 |  | 15.96
 | Australia |  | 637.6 |  | 77.15
Gross Margin - Mining Operations
 | Midwestern U.S. |  | 112.3 |  | 17.14
 | Western U.S. |  | 160.5 |  | 4.27
 | Total - U.S. Mining Operations |  | 272.8 |  | 6.18
 | Australia |  | 100.4 |  | 12.14999999999999
Adjusted EBITDA - Trading and Brokerage Operations |  |  | 16
Adjusted EBITDA - Resource Management  (1) |  |  | 2.1
Selling and Administrative Expenses |  |  | -65.1 |  | -1.138111888111888
Other Operating Costs, Net (2) |  |  | -46.1 |  | -0.8059440559440559
Adjusted EBITDA (3) |  |  | 280.1 |  | 4.896853146853147
(1) Includes certain asset sales, property management costs and revenues, and coal royalty expense.
(2) Includes Generation Development and Btu Conversion costs, costs associated with post-mining activities, loss from equity affiliates and provisions for certain litigation.
(3) Adjusted EBITDA is defined as (loss) income from continuing operations before deducting net interest expense, income taxes, asset retirement obligation expenses, depreciation, depletion and amortization, asset impairment and mine closure costs and amortization of basis difference associated with equity method investments.  Adjusted EBITDA, which is not calculated identically by all companies, is not a substitute for operating income, net income or cash flow as determined in accordance with United States generally accepted accounting principles.  Management uses Adjusted EBITDA as a key measure of operating performance and also believes it is a useful indicator of the company’s ability to meet debt service and capital expenditure requirements.
This information is intended to be reviewed in conjunction with the company's filings with the Securities and Exchange Commission.
Spreadsheet: 852865d1702861109-aggregate-function-not-working-with-filter-function-acquisition-channel-report-v2
Sheet: Sheet1

 | 2023-01-01 00:00:00
MS
[NAME]
Travis
JK
Mark
[NAME]
[NAME]
Clinten
Muha
[NAME]
Nick
[NAME]
[NAME]
Spreadsheet: 02c66b6a-39d9-4496-a3c8-fe4469e5b1ee
Sheet: 6-8

MENU - 6-8
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No |  |  | Decimal Equivalents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/8 Cup | 0.125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4 Cup | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/8 Cup | 0.375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/3 Cup | 0.333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/2 Cup | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/8 Cup | 0.625
 |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  |  |  |  | 2/3 Cup | 0.666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/4 Cup | 0.75
Mt/MA (1 oz eq per day)  (9-10 oz eq per week) |  |  |  | Chicken |  | Fish Nuggets |  | Low Fat Mozz |  | Grilled Chicken |  |  |  |  | 7/8 Cup | 0.875
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  |  |  | 1 Cup | 1
Vegetables (3/4 Cup per day) (3 3/4 Cup per week)
[NAME]  (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Red/Orange  (3/4 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Beans/Peas (Legumes) (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Starchy  (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Other  (1/2 cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Daily total
Additional Vegetable to reach [NAME] (1 Cup per week)
Grains(1 oz eq day) (8-10 oz eq per week)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Fruits (1/2 Cup per day)  (2 1/2 cups per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
[NAME] (1 Cup per day)  (5 a week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Spreadsheet: 852359d1702419563-how-do-i-seperate-negatives-from-positives-book2
Sheet: Sheet1

 |  |  |  | WHAT I HAVE
 |  | 2023-10-14 00:00:00 |  | Mountain Warehouse Clothing | -145
 |  | 2023-10-14 00:00:00 |  | Happy Dog Pet Insurance | -40
 |  | 2023-10-14 00:00:00 |  | [NAME] (wages) | 325
 |  | 2023-10-18 00:00:00 |  | Waterstones refund | 19.99
 |  | 2023-10-18 00:00:00 |  | AAA Taxi Service | -35
 |  | 2023-10-24 00:00:00 |  | L Smith (handyman job) | 65
 |  |  |  | WHAT I WANT
 |  | 2023-10-14 00:00:00 |  | Mountain Warehouse Clothing | -145
 |  | 2023-10-14 00:00:00 |  | Happy Dog Pet Insurance | -40
 |  | 2023-10-14 00:00:00 |  | [NAME] (wages) |  | 325
 |  | 2023-10-18 00:00:00 |  | Waterstones refund |  | 19.99
 |  | 2023-10-18 00:00:00 |  | AAA Taxi Service | -35
 |  | 2023-10-24 00:00:00 |  | L Smith (handyman job) |  | 65
Spreadsheet: 45757d1244568174-data-validation-indirect-function-book4_jun9
Sheet: Sheet1

joinery | hltd | s |  |  | Building |  | Roofery |  | [NAME]
 |  |  |  |  | altd | x | dltd | u | gltd | r
 |  |  |  |  | bltd | y | eltd | v | hltd | s
 |  |  |  |  | cltd | z | fltd | w | iltd | t
Spreadsheet: sally_beck__35041__MgmtSum-Q2-0501
Sheet: GM-WklyChnge

ENRON NORTH AMERICA
2ND QUARTER 2000 DETAIL OF GROSS MARGIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
WEEKLY CHANGE
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR* | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Gas Trading |  |  |  |  |  |  |  |  | 0
Power Trading |  |  |  |  |  |  |  |  | 0
Financial Drift |  |  |  |  |  |  |  |  | 0
Financial Trading |  |  |  |  |  |  |  |  | 0
Canada Trading |  |  |  |  |  |  |  |  | 0
Coal |  |  |  |  |  |  |  |  | 0
GRM -  Weather |  |  |  |  |  |  |  |  | 0
Emissions |  |  |  |  |  |  |  |  | 0
GRM - New Products |  |  |  |  |  |  |  |  | 0
Total Trading & Risk Management
East Midstream |  |  |  |  |  |  |  |  | 0
West Midstream |  |  |  |  |  |  |  |  | 0
Industrial Downstream |  |  |  |  |  |  |  |  | 0
Midstream IPP |  |  |  |  |  |  |  |  | 0
Canada Origination & Finance |  |  |  |  |  |  |  |  | 0
Mexico |  |  |  |  |  |  |  |  | 0
Total Origination
Generation Investments |  |  |  |  |  |  |  |  | 0
ENA Upstream Assets |  |  |  |  |  |  |  |  | 0
ENA Upstream Assets - Trading |  |  |  |  |  |  |  |  | 0
Total Assets
Principal Investing |  |  |  |  |  |  |  |  | 0
Energy Capital Services |  |  |  |  |  |  |  |  | 0
Special Assets |  |  |  |  |  |  |  |  | 0
CTG Assets |  |  |  |  |  |  |  |  | 0
CTG Assets
Total Investing
Commercial Transactions Group |  |  |  |  |  |  |  |  | 0
Office of the Chairman |  |  |  |  |  |  |  |  | 0
Other Interest Related Charges |  |  |  |  |  |  |  |  | 0
Overview |  |  |  |  |  |  |  |  | 0
Total
* Excludes Cap. Charge & Operating Costs
 |  |  |  | Deals Added:
 |  |  |  | Deals Changed:
 |  |  |  | Deals Removed:
 |  |  |  | Deals Completed: