tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 24962d1216042255-excel-2007-problem-with-time-tidrapport2008
Sheet: Juli2008

 |  | TIDRAPPORT
 |  | Name: | [NAME] |  | Anställnings nummer | 1011 |  | År: | 2008 | Månad: | [NAME]
Datum | Projekt | Ort | Resa från hemmet |  |  | Arbetad tid ([NAME]) | Resa till hemmet |  |  | [NAME] ([NAME]) | Orsak till ledighet
 |  |  | Avresa kl. | Framme kl. | Restid (min) |  | Avresa kl. | Framme kl. | Restid (min)
2008-07-01 00:00:00 | Enaco | Lund | 07:05:00 | 07:25:00 | 0.0138888888888889 | 11 | 19:00:00 | 19:20:00 | 0.01388888888888884
2008-07-02 00:00:00 | Enaco | Lund | 07:05:00 | 07:25:00 | 0.0138888888888889 | 11 | 19:00:00 | 19:20:00 | 0.01388888888888884
2008-07-03 00:00:00 | Enaco | Lund | 07:05:00 | 07:25:00 | 0.0138888888888889 | 8 | 16:00:00 | 16:20:00 | 0.01388888888888884
2008-07-04 00:00:00 | Enaco | Lund | 07:05:00 | 07:25:00 | 0.0138888888888889 | 8 | 16:00:00 | 16:20:00 | 0.01388888888888884
2008-07-05 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-06 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-07 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-08 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-09 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-10 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-11 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-12 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-13 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-14 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-15 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-16 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-17 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-18 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-19 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-20 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-21 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-22 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-23 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-24 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-25 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-26 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-27 00:00:00 |  |  |  |  | 0 |  |  |  | 0
2008-07-28 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-29 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-30 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
2008-07-31 00:00:00 | Semester | - |  |  | 0 |  |  |  | 0
Summa: |  | totalt resa från hemmet ([NAME]) |  | 01:20:00 | totalt resa till hemmet ([NAME]) |  | 01:20:00 |  | Totalt resa ([NAME]) | 02:40:00
Underskrift: |  | [NAME] |  |  |  |  |  |  | Attest:
Spreadsheet: 119406d1314370387-alternative-way-to-calculate-with-multiple-functions-inventory-allocation-tool-dummy-
Sheet: Sheet4

Qty of Aged Inv | Qty of Allocated Inv | Qty of Remaining Inv | Asys Product Number | PIM Product Description Short | Inventory $ | REF | 8N SOUTH FLORIDA | 5Z PORT ORANGE | 6Q LAKELAND | 5I ATLANTA | 5Y MONTGOMERY | 8N SOUTH FLORIDA | 5Z PORT ORANGE | 6Q LAKELAND | 5I ATLANTA | 5Y MONTGOMERY
2 | 2 | 0 | 2013035 | COOKIE, GNGRS OLD FSHND | 1.5932 | D |  |  |  |  | 8 | 0 | 0 | 0 | 0 | 2
4 | 4 | 0 | 8386955 | OIL, PAN COTG AERSL SPRAY | 11.5496 | D |  | 6 |  | 12 |  | 0 | 0 | 0 | 4 | 0
149 | 102 | 47 | 4568861 | PIE, PMKN TFF BKD 10" FZN | 303.632 | F | 50 | 3 | 28 | 21 |  | 50 | 3 | 28 | 21 | 0
4 | 4 | 0 | 4936068 | SEASONING, LIME PPR [NAME] | 4.36 | D | 5 |  | 17 | 16 | 16 | 0 | 0 | 4 | 0 | 0
12 | 12 | 0 | 5763685 | BAR MIX, MRITA STWBY CKTL PLST | 20.2666 | D | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 0 | 0 | 3
11 | 11 | 0 | 9140393 | LID, CUP 5-8 Z DOME PLST CLR | 71.368 | D | 3 | 1 | 2 | 4 | 3 | 3 | 0 | 1 | 4 | 3
15 | 11 | 4 | 693333 | DISPENSER, FORK PLST | 0.8776 | D | 2 | 3 | 1 | 5 |  | 2 | 3 | 1 | 5 | 0
1 | 1 | 0 | 5747456 | CUP, PAPR 20 Z SNGL POLY COTED | 14.5635 | D | 2 | 3 | 4 | 5 |  | 0 | 0 | 0 | 1 | 0
10 | 1 | 9 | 693358 | DISPENSER, CTLY 10X8.75X24.5 | 1 | D | 1 |  |  |  |  | 1 | 0 | 0 | 0 | 0
Spreadsheet: 98038d1297121761-problem-using-formula-to-find-row-numbers-inventory-20test
Sheet: Search

 |  | Columns "T" thru "AB" are in question.
 | Heads
TYPE | Hybrid | Controls Column "W" on [NAME]
MFG | Wishon | Controls Column "T" on [NAME]
Row | Model | Club | Item | [NAME] | RH/LH | QT | Cost
1 | [NAME] | Hybrid | # 1 | 15 | Y | 1 | 26.5 | 1
2 | [NAME] | Hybrid | # 2 | 18 | Y | 3 | 26.5 | 2
3 | [NAME] | Hybrid | # 3 | 21 | Y | 2 | 26.5 | 3
4 | [NAME] | Hybrid | # 4 | 24 | Y | 1 | 26.5 | 4
5 | [NAME] | Hybrid | # 5 | 28 | Y | 1 | 26.5 | 5
6 | [NAME] | Hybrid | # 6 | 32 | X | 1 | 26.5 | 6
7 | [NAME] | Hybrid | # 1 | 15 | R | 1 | 26.5 | 7
8 | [NAME] | Hybrid | # 2 | 18 | R | 3 | 26.5 | 8
9 | [NAME] | Hybrid | # 3 | 21 | R | 2 | 26.5 | 9
10 | [NAME] | Hybrid | # 4 | 24 | R | 1 | 26.5 | 10
11 | [NAME] | Hybrid | # 5 | 28 | R | 1 | 26.5 | 11
12 | [NAME] | Hybrid | # 6 | 32 | R | 1 | 26.5 | 12
13 | 731 CL | Hybrid | Long Fairway | 0 | R | 2 | 29.5 | 13
14 | 732 CL | Hybrid | High Fairway | 0 | R | 2 | 29.5 | 14
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  | 30
Spreadsheet: 117861d1313168898-averaging-based-on-different-column-tigeravatar-example-for-corky1111
Sheet: Sheet1

HeaderA | HeaderB | HeaderC
1 | 6 | 5.666666666666667
1 | 5 | 5.666666666666667
1 | 6 | 5.666666666666667
2 | 4 | 6.5
2 | 9 | 6.5
3 | 7 | 6.25
3 | 6 | 6.25
3 | 5 | 6.25
3 | 7 | 6.25
Spreadsheet: 852781d1702731077-how-to-join-the-text-of-several-cells-with-a-single-comma-sample-data1-aligw
Sheet: Foaie1

 |  | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | 2016 | 365
1 | DINING1 |  | pears |  |  |  | grapes
2 | DINING2 |  |  | lemon |  | pears |  |  |  | cherries |  |  | !!!!! In the "Result" column marked with yellow, I would like to join the words from the "Field 1...9" columns, but each word separated from the other by a comma.
3 | DINING3 | oranges |  | pears
4 | DINING4
5 | [NAME] |  |  |  | grapes |  |  |  | pears | cherries
6 | DINING6 |  |  | cherries
7 | DINING7 | pears
8 | DINING8 |  |  |  | oranges
9 | DINING9 |  |  |  | pears
10 | DINING10 |  |  |  |  |  |  | pears
11 | DINING11 |  | oranges
12 | DINING12 |  |  |  |  | grapes
13 | DINING13 |  |  |  |  |  |  | oranges
14 | DINING14 | grapes
15 | [NAME] |  |  |  |  |  |  |  |  | oranges
16 | DINING16 |  | pears
17 | DINING17 |  |  |  | lemon |  | pears
18 | DINING18 |  | cherries |  |  |  |  |  |  | pears
19 | DINING19 |  |  |  |  |  |  |  | pears
20 | DINING20 |  |  | grapes
Spreadsheet: 876880d1723593204-tranpose-data-from-row-to-column-based-on-sequence-tranpose-data-from-row-to-column-based-on-sequence
Sheet: Sheet1

Key | Person 1 | Person 2 | Person 3 | Person 4
K123 | [NAME] | [NAME]
B456 | [NAME] | Will | Anna
Result Needed |  |  | [NAME] results
Key | Person |  | Key | Person
 | [NAME]
K123 | [NAME] |  |  | [NAME]
B456 | [NAME] |  |  | [NAME]
B456 | Will |  |  | Will
B456 | Anna |  |  | Anna
Spreadsheet: 94835d1294603026-pulling-out-minimum-and-maximum-values-weightvaluedate
Sheet: aaaa

Weight | Value | Date
10 | 1000 | 2011-01-01 00:00:00 |  | Row Labels | Min of Value | Min of Date | Max of Value | Max of Date
20 | 1500 | 2011-01-01 00:00:00 |  | 10 | 800 | 2011-01-01 00:00:00 | 1000 | 2011-02-01 00:00:00
30 | 2500 | 2011-01-01 00:00:00 |  | 20 | 1500 | 2011-01-01 00:00:00 | 1600 | 2011-02-01 00:00:00
40 | 3000 | 2011-01-01 00:00:00 |  | 30 | 2000 | 2011-01-01 00:00:00 | 2500 | 2011-02-01 00:00:00
50 | 4000 | 2011-01-01 00:00:00 |  | 40 | 3000 | 2011-01-01 00:00:00 | 3100 | 2011-02-01 00:00:00
10 | 800 | 2011-02-01 00:00:00 |  | 50 | 3900 | 2011-01-01 00:00:00 | 4000 | 2011-02-01 00:00:00
20 | 1600 | 2011-02-01 00:00:00 |  | Grand Total | 800 | 2011-01-01 00:00:00 | 4000 | 2011-02-01 00:00:00
30 | 2000 | 2011-02-01 00:00:00
40 | 3100 | 2011-02-01 00:00:00
50 | 3900 | 2011-02-01 00:00:00
Spreadsheet: 129058d1321432272-excel-2007-identify-duplicate-find-duplicates2
Sheet: Arkusz1

1 | Duplicate
1 | Duplicate
2 | Duplicate
3 | Unique
2 | Duplicate
4 | Unique
4.5 | Duplicate
4.5 | Duplicate
6 | Unique
7 | Duplicate
7 | Duplicate
7 | Duplicate
8 | Unique
fgd | Unique
dfg | Duplicate
fdg | Unique
dfg | Duplicate
dfg | Duplicate
Spreadsheet: 860133d1708351078-winning-streaks-pong-streaks
Sheet: Sheet1

Round | Home | Score | Score2 | Away
1 | [NAME] | 21 | 13 | Nathan
1 | [NAME] | 21 | 15 | Nathan |  | Nathan:2W
1 | [NAME] | 11 | 4 | Nathan |  | Mark:1W
1 | Nathan | 21 | 17 | [NAME] |  | James:6L
1 | Nathan | 21 | 14 | [NAME] |  | Pratik:2L
1 | Nathan | 11 | 5 | [NAME]
1 | [NAME] | 21 | 18 | Mark
1 | [NAME] | 21 | 13 | Pratik
2 | [NAME] | 21 | 9 | Nathan
2 | [NAME] | 21 | 11 | [NAME]
2 | Nathan | 21 | 17 | [NAME]
2 | Nathan | 21 | 14 | [NAME]
2 | [NAME] | 21 | 12 | Pratik
2 | [NAME] | 21 | 19 | Mark
2 | Mark | 11 | 8 | [NAME]
Spreadsheet: 105268d1302690784-extract-lookup-value-from-many-duplicates-pain
Sheet: Sheet1

 |  |  |  | PICK A CUSTOMER |  | PRODUCTS?
CUSTOMER | PRODUCT |  |  | customer 4
customer 1 | A
customer 2 | B
customer 3 | C
customer 4 | D
customer 5 | E
customer 6 | F
customer 2 | J
customer 2 | G
customer 4 | H
customer 2 | I
customer 5 | J
customer 6 | K
customer 4 | L
customer 5 | M
customer 6 | N
customer 7 | O
customer 5 | P
customer 4 | R
drop down data
customer 1
customer 2
customer 3
customer 4
customer 5
customer 6
customer 7
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 265797 | 254322 | 39793 | 37941 | 27327 | 49663 | 98034 | 88072 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 277624 | 290502 | 41157 | 40713 | 43302 | 49663 | 99079 | 82401 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 307171 | 315078 | 38098 | 38046 | 47669 | 45711 | 136447 | 129393 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 |  |  |  |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 |  |  |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 |  |  |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 |  |  |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 |  |  |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 |  |  |  |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 |  |  |  |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-04 00:00:00
16
17
18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.98
20 |  |  |  |  |  |  |  |  |  |  |  |  | 1378106 | 1316146
21 |  |  |  |  |  |  |  |  |  |  |  |  | 9216070 | 9272400
22 |  |  |  |  |  |  |  |  |  |  |  |  | 3546065 | 3512740
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-01-03 00:00:00
CBS Dollars
 |  |  | 0
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: 183951d1349100968-blank-cells-in-worksheet-example-2
Sheet: Sheet1

Before |  | Need
316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH
 |  | S31803/GRAPH
 |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH
 |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH
 |  | S31803/GRAPH
 |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH
 |  | S31803/GRAPH
 |  | S31803/GRAPH
S31803/GRAPH |  | S31803/GRAPH
Spreadsheet: darrell_schoolcraft__7707__IPnet-addresses-3-1-02
Sheet: Sheet3

 | IP Net - Enron WAN Access Cost
 | 2002-03-01 00:00:00
 | Status | Name |  | IPNet Bandwidth | Base $$ | Allocation | Adjusted Monthly plus Tax | Install $ | New IP-Dterm |  | Total Cost first Month Plus Tax
1 | New Request | [NAME], [NAME] | idsl | 144k | 96.39 | 32.3 |  | 299 | na
2 | New Request | [NAME] | adsl | 128k | 88 | 32.3 |  | 299 | 270
3 | New Request | [NAME] | adsl | 128k | 88 | 32.3 |  | 299 | 270
4 | New Request | [NAME]
5 | New Request | [NAME] | idsl | 144k | 96.39 | 32.3 |  | 299 | 270
6 | New Request | [NAME]
7 | New Request | [NAME]
8 | New Request | [NAME] | idsl | 144k | 96.39 | 32.3 |  | 299 | 270
9 | New Request | Rodriguez, Ruben | idsl | 144k | 96.39 | 32.3 |  | 299 | 270
10 | New Request | Dannis Bellard
11 | New Request | [NAME]
12 | New Request | [NAME] | idsl | 144k | 96.39 | 32.3 |  | 299 | 270
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: X663 GBF

 |  |  |  |  | X663 GBF
Registration number : | X663 GBF |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2001-09-28 00:00:00 | 12 Months + 1 Week | 2001-10-01 00:00:00 | 1530
Specification : | 6 x 2 A (3 Axle) |  | 2002-09-30 00:00:00 | 12 Months | 2002-10-01 00:00:00 | 750
Type : | FTG85 CF 380 |  | 2003-09-30 00:00:00 | 12 Months | 2003-10-01 00:00:00 | 700
1st Registered : | 22.09.00 |  | 2004-09-30 00:00:00 | 12 Months | 2004-10-01 00:00:00 | 700
Engine : | DAF XF280M |  | 2005-09-29 00:00:00 | 12 Months | 2005-10-01 00:00:00 | 700
[NAME] : | 44,000kg |  | 2006-09-29 00:00:00 | 12 Months | 2006-10-01 00:00:00 | 700
 |  |  | 2007-09-30 00:00:00 | 12 Months | 2007-10-01 00:00:00 | 700
 |  |  | 2008-09-29 00:00:00 | 12 Months | 2008-10-01 00:00:00 | 700
 |  |  | 2009-09-30 00:00:00 | 12 Months | 2010-10-01 00:00:00 | 700
Back To Index |  |  | Licence Surrendered 26/2/2010
 |  |  | 2010-02-26 00:00:00 | 12 Months | 2011-03-01 00:00:00 | 165 | Private HGV
 |  |  | 2011-02-28 00:00:00 | 12 Months | 2012-03-01 00:00:00 | 165
 |  |  | 2012-02-29 00:00:00 | 12 Months | 2013-03-01 00:00:00 | 165
Spreadsheet: 693322d1598920712-returning-blank-cell-if-value-already-exists-sample
Sheet: Sheet1

 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Fred
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Greg
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: diana_scholtes__8570__Letter Log 01-24
Sheet: Termination

 | Events of Default/Termination
 | As of January 24, 2002
Term | Counterparty | Attorney Assigned | Enron Entity | Amount (if applicable) | Early Termination Date | Nature of Default (if any) | Contract Type(s) | Comments | Margin: (Posted by Enron)/Posted to Enron
 | Belden & Blake Corporation |  | ENA | 43680 | 2001-12-03 00:00:00 | bankruptcy | GTC's (10/22/2001) | 12/03 ltr stated that they were suspending deliveries, 01/23 ltr is a calculation of a termination amount
Y | Contour Energy Co. |  | ENA |  | 2002-01-18 00:00:00 | sect. 5(b) | Master Agreement (02/07/1995) (financial)
Y | NSTAR Electric (Boston Edison Company, Commonwealth Electric Company, Cambridge Electric Light Company) |  | EPMI |  | 2002-01-31 00:00:00 | sect. 8.2 | Default Service Power Supply Agreement (03/29/2001) | NSTAR will calculate amount due
Y | Praxair, Inc. |  | ENA |  | 2001-12-02 00:00:00 | bankruptcy | Master Commodity Price Swap Agreement (03/26/1993)
Y | Primary Natural Resources, Inc. |  | ENA | 775000 | 2002-01-30 00:00:00 | bankruptcy | Deal Nos. V57252.1-4, Q94376.1-4, Q96273.1,2, NR3978.1,2 | $200,000 for period 11/01 - 12/31, $575,000 for period following ET Date
Spreadsheet: 162227d1339770875-subscript-out-of-range-error-9-test-vnhgc
Sheet: Summary of Quotations

Summary Of Quotations
Rep Name | No. of Quotes Assigned | No. of Quotes Older than 6 Months | No. of Quotes Past Review Date | No. of Quotes Due for Review in Next 5 Days | % of Quotes Past Review Date
[NAME]
[NAME]
Declan Donnelly
[NAME]
[NAME]
[NAME]
[NAME] Reilly
[NAME]
Spreadsheet: 270243d1381421534-if-statement-difficult-ef496_generate_text_conditionally
Sheet: Sheet1

A | 3 |  |  |  |  | 1 |  |  |  |  | -2
B | 5 |  |  |  |  | 3 |  |  |  |  | -3
C | -10 |  |  |  |  | 5 |  |  |  |  | -5
Spreadsheet: e620e69d-b85b-422c-bbfd-55c0f9db5878
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Printing Services | 1 | [NAME] | 1.1 | Four color press | 2 | None | -- Pick One --
Printing Services | 2 | Goal 2: Improve the reliability and consistency of user experiences. | 2.1 | implementation | 4 | None | -- Pick One --
Printing Services | 2 | Goal 2: Improve the reliability and consistency of user experiences. | 2.2 | implementation | 4 | None | -- Pick One --
Spreadsheet: 141399d1329246716-help-creating-columns-book3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | % complete | Baseline | 1 | 40725 | 1 | 40817
Project Name - Lyman |  | % complete | Baseline
 | ROW | 1 | 2011-07-01 00:00:00
 | GDB | 1 | 2011-10-01 00:00:00
 | Route | 0.5 | 2011-08-01 00:00:00
Project Name - Dunney
 | ROW | 0.75 | 2011-07-01 00:00:00
 | GDB | 0.5 | 2011-10-01 00:00:00
 | Route | 0.5 | 2011-08-01 00:00:00
Spreadsheet: 850365d1700730334-expected-result-base-on-few-conditions-sample
Sheet: Sheet1

 |  |  | Item Code | Item 1 | Item 2 | Posted Code |  |  | Match Item Code | Expected Result
 |  |  | PT-001-223 | 0 | 0 | 45 |  |  | PT-001-223 | 45
 |  |  | PT-001-224 | 0 | 50 | 60 |  |  | PT-001-226 | 150
 |  |  | PT-001-225 | 50 | 100 | 75 |  |  | PT-001-228 | 45
 |  |  | PT-001-226 | 0 | 150 | 90
 |  |  | PT-001-227 | 0 | 200 | 105
 |  |  | PT-001-228 | 45 | 250 | 120
 |  |  | PT-001-229 | 0 | 300 | 135
 |  |  | PT-001-230 | 0 | 350 | 150
Spreadsheet: 771132d1646435026-formula-which-should-return-empty-returns-0-new-microsoft-excel-worksheet
Sheet: Sheet B

Header | Header
More Test Data1 | 11
More Test Data2 | 12
More Test Data3 | 13
More Test Data4 | 14
More Test Data5 | 15
More Test Data6 | 16
More Test Data7 | 17
More Test Data8 | 18
More Test Data9 | 19
More Test Data10 | 20
More Test Data11 | 21
More Test Data12 | 22
More Test Data13 | 23
More Test Data14 | 24
More Test Data15 | 25
More Test Data16 | 26
More Test Data17 | 27
More Test Data18 | 28
More Test Data19 | 29
Spreadsheet: jonathan_mckay__16921__Frank Sissons Buy
Sheet: Enron Direct Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | ECC |  |  |  |  | Deal Date: |  | 2001-08-09 00:00:00 |  |  |  |  | 3 | March
Originator: | [NAME] |  |  |  |  | Deal ID #: |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-10-01 00:00:00 |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  | 6 | June
Deal End Date: | 2004-09-30 00:00:00 |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  | 4.725 |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Buy |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total
 | January |  |  |  |  | 1147
 | February |  |  |  |  | 784
 | March |  |  |  |  | 713
 | April |  |  |  |  | 510
 | May |  |  |  |  | 341
 | June |  |  |  |  | 210
 | July |  |  |  |  | 186
 | August |  |  |  |  | 186
 | September |  |  |  |  | 300
 | October |  |  |  |  | 589
 | November |  |  |  |  | 990
 | December |  |  |  |  | 1023
 | TOTAL:
Spreadsheet: 214906d1361184980-using-text-forumlas-accounts-test-sheet
Sheet: April

 |  | KEY: |  | CREDIT ACCOUNTS: |  |  |  |  |  |  |  | CUSTOMER ORIGIN
 |  | Credit Account | ACC | TPS = |  | NET PURCHACED  TOTAL = |  |  |  |  |  | Repeat | ??????? | NET SALES TOTAL =
 |  | CASH | CASH | OTHER 1 = | ?????? | VAT PAID OUT = |  |  |  |  |  | Recommend | ??????? | VAT RECEIVED =
 |  | CHEQUE | CHQ | OTHER 2 = | ?????? |  |  |  |  |  |  | Leaflet | ??????? | TOTAL AMOUNT OF JOBS =
 |  | CARD | CARD | OTHER 3 = | ?????? |  |  |  |  |  |  | Website | ?????? | MONTH NET PROFIT =
 | PURCHASE LEDGER | BANK CREDIT | BACS |  |  |  |  |  |  | SALES LEDGER |  | Phone book | ???????
 |  |  |  |  |  |  |  |  |  |  |  | Other | ???????
DATE | DESCRIPTION OF TRANSACTION | INVOICE NO or REF | OUTGOING ££ | VAT % | OUTGOING ££ | PAYMENT | CREDIT |  | DATE | DESCRIPTION OF TRANSACTION | INVOICE NO or REF | INCOME ££ | VAT % | INCOME ££ | PAYMENT | CUSTOMER
 |  |  | NET | PAID | GROSS | METHOD | ACCOUNT |  |  |  |  | NET |  | GROSS | METHOD | ORIGIN
2013-02-01 00:00:00 | SERVICE PARTS FOR PIGGLES PASSAT 1000987 | 1 | 100 | 20 | 120 | ACC/BACS | 100 |  | 2013-02-01 00:00:00 | PIGGLES FULL SERVICE | S1000987 | 250 | 50 | 300 | CASH | Repeat
2013-02-01 00:00:00 | CREDIT NOTE FOR WRONG PARTS SUPPLIED | 2 | -20 | -4 | -24 | ACC/BACS | -20 |  | 2013-02-09 00:00:00 | Parts supply for dave | S1000988 | 100 | 20 | 120 | CASH | Website
 |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  | Repeat
 |  |  |  |  |  |  | 56 |  |  |  |  |  |  |  |  | Repeat
 | CREDIT ACCOUNTS (PURCHACE LEDGER)
 | JOB TOTALS (SALES LEDGER)
 | Customer Origin (SALES LEDGER)
Spreadsheet: e71e7652-16b1-47ab-8747-5e48e720331a
Sheet: 1.1 Employment

1.1 Employment
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
Number employed (a) – '000
July | 11019.5048468 | 11213.4511346 | 11352.4441504 | 11468.3240077 | 11583.0005151
August | 11054.3168935 | 11225.4760731 | 11359.7785212 | 11470.5547932 | 11585.8868383
September | 11088.2093176 | 11236.7202804 | 11370.1511208 | 11472.3291207 | 11587.628497
October | 11118.8650135 | 11245.8037911 | 11383.8220562 | 11474.7020073 | 11588.9691761
November | 11145.146407 | 11252.6983478 | 11398.8979901 | 11480.555927
December | 11165.4869223 | 11261.5300582 | 11414.1192665 | 11490.3999766
January | 11179.4048179 | 11274.5693125 | 11428.0846247 | 11503.9306092
February | 11187.1974328 | 11291.2928269 | 11441.2396565 | 11520.2814641
March | 11190.7549483 | 11309.3449285 | 11452.3199773 | 11538.9806548
April | 11192.7826868 | 11325.6777842 | 11460.2194881 | 11557.3535215
May | 11196.2338017 | 11337.7941106 | 11464.1851672 | 11571.2599251
June | 11203.4729593 | 11345.9768076 | 11466.2760385 | 11579.0496493
Annual average | 11145.114670625 | 11276.69462129167 | 11415.96150479167 | 11510.643471375
Employment to population ratio (a) – per cent
July | 61.9264385 | 62.0528413 | 61.7265853 | 61.2395501 | 60.7410548
August | 62.0520808 | 62.0382977 | 61.6785285 | 61.162898 | 60.6717232
September | 62.1707151 | 62.0172401 | 61.6449836 | 61.0815883 | 60.6050769
October | 62.2682243 | 61.9809289 | 61.6273696 | 61.0014508 | 60.5509853
November | 62.337265 | 61.9281102 | 61.6153421 | 60.9388052
December | 62.368441 | 61.8810385 | 61.6018448 | 60.8972396
January | 62.3600444 | 61.8535064 | 61.5796087 | 60.8755737
February | 62.3159825 | 61.8452709 | 61.552183 | 60.8690996
March | 62.2494772 | 61.8465147 | 61.5145541 | 60.8750114
April | 62.177319 | 61.8425448 | 61.4625549 | 60.8793794
May | 62.1159806 | 61.8197083 | 61.3929091 | 60.8602882
June | 62.077011 | 61.7777803 | 61.3159494 | 60.809636
Annual average | 62.20158161666667 | 61.90698184166667 | 61.55936775833334 | 60.95754335833332
(a) Monthly figures are trend. Annual figures are from the original series.
 |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-12-11 00:00:00