tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 674721d1587995995-excel-large-data-to-summary-table-example-by-pq
Sheet: Result

Length |  | Type
Start | End |  |  | Start | End | Type of Pole
 |  |  |  | 0 | 890 | B
 |  |  |  | 900 | 2590 | A | Start and End to come in table for each type
 |  |  |  | 2600 | 9590 | E
 |  |  |  | 9600 | 9610 | C
 |  |  |  | 9620 | 9630 | B
 |  |  |  | 9640 | 10140 | A
 |  |  |  | 10150 | 11570 | E
 |  |  |  | 11580 | 11590 | A
 |  |  |  | 11600 | 12590 | E
 |  |  |  | 12600 | 13250 | C
 |  |  |  | 13260 | 14690 | E
 |  |  |  | 14700 | 15650 | A
 |  |  |  | 15660 | 18340 | E
 |  |  |  | 18350 | 20230 | A
 |  |  |  | 20240 | 20530 | E
 |  |  |  | 20540 | 20550 | A
Spreadsheet: 103352d1301080581-macro-malfunction-sample_test
Sheet: Facilator and location detail

 |  | No. | Training Start Date | Training End Date | Training Course | Facilitator (s) | Location
 |  | Ex. | 2011-01-24 00:00:00 | 2011-01-26 00:00:00 | Sales Executive | EXAMPLE - John DOE | Philadelphia
 |  |  | 2010-02-16 00:00:00 | 2010-02-18 00:00:00 | ISE | [NAME] | Newark
 |  |  | 2010-02-23 00:00:00 | 2010-02-25 00:00:00 | ISE/SE | Pascale Lessard | Quebec City
 |  |  | 2010-03-01 00:00:00 | 2010-03-01 00:00:00 | ISE | [NAME] | Norfolk
 |  |  | 2010-04-01 00:00:00 | 2010-04-01 00:00:00 | SE | [NAME] | Philadelphia
 |  |  | 2010-05-01 00:00:00 | 2010-05-01 00:00:00 | SE | [NAME] | Atlanta
 |  |  | 2010-06-01 00:00:00 | 2010-06-01 00:00:00 | SM/DSM | [NAME],Pauli Samra, [NAME] | Support Center
 |  |  | 2010-06-02 00:00:00 | 2010-06-03 00:00:00 | SM/GM/DSM | Pauli Samra | Denver
 |  |  | 2010-06-15 00:00:00 | 2010-06-17 00:00:00 | SE | Pauli Samra, [NAME] | Atlanta
 |  |  | 2010-06-22 00:00:00 | 2010-06-24 00:00:00 | SE | Pauli Samra | Los Angeles
 |  |  | 2010-08-01 00:00:00 | 2010-08-01 00:00:00 | SE | [NAME] | Philadelphia
 |  |  | 2010-09-01 00:00:00 | 2010-09-01 00:00:00 | SE | Pascale Lessard | Long Island
 |  |  | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | ISE/SE | [NAME],Pascale Lessard | San Francisco
 |  |  | 2010-11-15 00:00:00 | 2010-11-18 00:00:00 | ISE/SE | [NAME], Pascale Lessard | Philadelphia
 |  |  | 2010-12-01 00:00:00 | 2010-12-01 00:00:00 | SM/DSM | [NAME],Pauli Samra, [NAME] | Support Center
 |  |  | 2010-12-14 00:00:00 | 2010-12-16 00:00:00 | ISE/SE | Pascale Lessard | Montreal
 |  |  | 2011-01-24 00:00:00 | 2011-01-26 00:00:00 | SE | [NAME] and [NAME] | Philadelphia
 |  |  | 2011-02-22 00:00:00 | 2011-02-24 00:00:00 | SE | [NAME], Pascale Lessard and [NAME] | Houston
 |  |  | 2011-03-15 00:00:00 | 2011-03-17 00:00:00 | SE | [NAME], Pascale Lessard and [NAME] | Toronto
Spreadsheet: 376638d1423669081-select-entire-sheet-and-delete-all-cells-except-column-a-protected_gen-switch-stock
Sheet: HSB & QTs

Model # | Serial # | KW | Cost | P.O. # | Received | Comments | Location
5837 | 6958601 | 7 | 1591.92 | 20388 | 2012-03-08 00:00:00 | GIVE AWAYS FOR 2015 EVENTS | BHAM
5837 | 7649490 | 7 | 1679.76 | 23386 | 2012-12-06 00:00:00 | GIVE AWAYS FOR 2015 EVENTS | BHAM
5837 | 7649491 | 7 | 1679.76 | 23386 | 2012-12-06 00:00:00 | GIVE AWAYS FOR 2015 EVENTS | BHAM
5837 | 7649492 | 7 | 1679.76 | 23386 | 2012-12-06 00:00:00 | GIVE AWAYS FOR 2015 EVENTS | BHAM
5837 | 7553232 | 7 | 1679.76 | 23361 | 2012-12-17 00:00:00 | GIVE AWAYS FOR 2015 EVENTS | BHAM
5837 | 7553233 | 7 | 1679.76 | 23361 | 2012-12-17 00:00:00 | GIVE AWAYS FOR 2015 EVENTS | BHAM
6245 |  | 8/7 |  |  |  |  | BHAM
6245 |  | 8/7 |  |  |  |  | BHAM
6245 |  | 8/7 |  |  |  |  | BHAM
6439 |  | 11/10 |  |  |  |  | BHAM
6439 |  | 11/10 |  |  |  |  | BHAM
6439 |  | 11/10 |  |  |  |  | BHAM
6439 |  | 11/10 |  |  |  |  | BHAM
6247 | 8764883 | 14 | 2415.75 | 32412 | 2014-06-02 00:00:00 | HOLD FOR SCOTTY | BHAM
6459 |  | 16 |  |  |  |  | BHAM
6459 |  | 16 |  |  |  |  | BHAM
6459 |  | 16 |  |  |  |  | BHAM
6459 |  | 16 |  |  |  |  | BHAM
6459 |  | 16 |  |  |  |  | BHAM
6250 | 8679308 | 20/18 | 3394.56 | 35403 | 2014-09-08 00:00:00 |  | ATL
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6730 |  | 20/18 |  |  |  |  | BHAM
6055 | 9149801 | 20 | 4612.78 | 38077 | 2014-11-18 00:00:00 | Synergy With RTS200A | BHAM
6055 | 9149830 | 20 | 4612.78 | 38077 | 2014-11-18 00:00:00 | Synergy With RTS200A | BHAM
6552 | 9219321 | 22/19.5 | 3418.21 | 36581 | 2014-10-22 00:00:00 |  | BHAM
6552 | 9219322 | 22/19.5 | 3418.21 | 36581 | 2014-10-22 00:00:00 |  | BHAM
6552 | 9226131 | 22/19.5 | 3611.26 | 38077 | 2014-11-18 00:00:00 |  | BHAM
6552 |  | 22/19.5 |  |  |  |  | BHAM
6552 |  | 22/19.5 |  |  |  |  | BHAM
6552 |  | 22/19.5 |  |  |  |  | BHAM
6552 |  | 22/19.5 |  |  |  |  | BHAM
6552 |  | 22/19.5 |  |  |  |  | BHAM
6552 |  | 22/19.5 |  |  |  |  | BHAM
6552 |  | 22/19.5 |  |  |  |  | BHAM
QT02224ANAX | 9225664 | 22 | 7016.52 | 38077 | 2014-11-18 00:00:00 |  | BHAM
QT02224ANAX |  | 22 |  |  |  |  | BHAM
[NAME] |  | 27 |  |  |  |  | BHAM
[NAME] |  | 27 |  |  |  |  | BHAM
QT03624ANAX | 9110098 | 36 | 9016.9 | 35403 | 2014-09-04 00:00:00 |  | BHAM
QT03624ANAX | 9191203 | 36 | 8913.78 | 36581 | 2014-10-22 00:00:00 |  | BHAM
[NAME] | 9202477 | 48 | 11421.62 | 36581 | 2014-10-22 00:00:00 |  | BHAM
[NAME] | 9202480 | 48 | 11421.62 | 36581 | 2014-10-22 00:00:00 |  | BHAM
UNITS ON HOLD FOR CUSTOMER WITH SALESMEN ID
6250 | 8179296 | 20 | 3602.88 | 25175 | 2013-06-04 00:00:00 | K Electric-SS | BHAM
QT02224ANAX | 9065371 | 22 | 6995.14 | 34450 | 2014-08-07 00:00:00 | Paulding Cty Fire Station | BHAM
QT02515ANSX | 8680312 | 25 | 6239.34 | 29437 | 2014-03-17 00:00:00 |  | BHAM
[NAME] | 8194823 | 48 | 11593.29 | 34450 | 2014-08-07 00:00:00 |  | BHAM
Spreadsheet: 74ab1885-8dd4-454e-b47c-c78d2bedea50
Sheet: ST9

Supplementary Table 9 ([NAME] et al.) Interacting regions
Human Specific Interacting Peaks
Overlapping Data Region A |  | Overlapping Data Region B
H3K4me3 Peak 1 | ChIA PET Interaction 1 | H3K4me3 Peak 2 | ChIA PET Interaction 2
chr5:180586923-180587796 | chr5:180585150-180588033 | chr5:180610881-180611525 | chr5:180609744-180613590
chr16:2204504-2205607 | chr16:2203385-2206711 | chr16:2954113-2955495 | chr16:2953948-2956847
chr16:21512663-21514196 | chr16:21512002-21513858 | chr16:22448157-22449013 | chr16:22446978-22449925
Region | [NAME] (bp) | Nearest TSS | Distance to TSS (bp) | DECIPHER syndroms
chr5:180586923-180587796 | 873 | OR2V2 | 4981
chr5:180610881-180611525 | 644 | TRIM7 | 16405
chr16:21512663-21514196 | 1533 | LOC100271836 | 0
chr16:2204504-2205607 | 1103 | SNORD60 | 0
chr16:22448157-22449013 | 856 | LOC641298 | 0 | 16p11.2-p12.2  syndrome
chr16:2954113-2955495 | 1382 | FLYWCH1 | 6484
ChIA-PET peaks from  [NAME], [NAME], et al. Extensive promoter-centered chromatin interactions provide a topological basis for transcription regulation. Cell 148, 84-98 (2012).
Spreadsheet: 546279d1509976682-creating-a-specific-hierarchy-chart-hierarchy-chart
Sheet: Tabelle1

 |  | USA | 500
 |  | Canada | 300
 |  | Germany | 200
 |  | France | 100
 |  | Italy | 80
 |  | Spain | 70
 |  | Portugal | 65
 |  | Greece | 58
 |  | Malta | 47
 |  | Sweden | 39
 |  | Norway | 34
 |  | Turkey | 31
 |  | Russia | 28
 |  | China | 25
 |  | Japan | 22
Spreadsheet: 377868d1424190630-fetch-values-from-same-row-repetedly-book3-2
Sheet: Sheet1

Person ID | Assignment ID | Name | Col 1 | Col 2 | Col 3
1 | 1 | [NAME] | A | B | C
2 | 2 | Bran | D | E | F
3 | 3 | Fan | G | H | I
4 | 4 | [NAME] | J | K | L
5 | 5 | Gann | M | N | O
Person ID | Assignment ID |  | Value |  |  |  |  |  | Person ID | Assignment ID |  | Value
 |  |  |  |  |  |  |  |  | 1 | 1 | A | Col 1
 |  |  |  |  |  |  |  |  | 1 | 1 | B | Col 2
 |  |  |  |  |  |  |  |  | 1 | 1 | C | Col 3
 |  |  |  |  |  |  |  |  | 2 | 2 | D | Col 1
 |  |  |  |  |  |  |  |  | 2 | 2 | E | Col 2
 |  |  |  |  |  |  |  |  | 2 | 2 | F | Col 3
 |  |  |  |  |  |  |  |  | 3 | 3 | G | Col 1
 |  |  |  |  |  |  |  |  | 3 | 3 | H | Col 2
 |  |  |  |  |  |  |  |  | 3 | 3 | I | Col 3
 |  |  |  |  |  |  |  |  | 4 | 4 | J | Col 1
 |  |  |  |  |  |  |  |  | 4 | 4 | K | Col 2
 |  |  |  |  |  |  |  |  | 4 | 4 | L | Col 3
 |  |  |  |  |  |  |  |  | 5 | 5 | M | Col 1
 |  |  |  |  |  |  |  |  | 5 | 5 | N | Col 2
 |  |  |  |  |  |  |  |  | 5 | 5 | O | Col 3
Spreadsheet: 21d1d11f-6222-4552-bd60-a275c667817e
Sheet: Sheet1

Simulation of Stock and Put Option Prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Risk-free Int Rate | 0.03 | Days in a Year | 250 | Simulation Runs |  | 20
Initial Stock Price | 40 | Days to [NAME] | 125
Exercise Price | 39.5 | (enter up to 500)
Put Price, User Input (1) | 2 | [NAME], in Years | 0.5
Put Price, [NAME] | 38.91192161432097
Put Price, Lower Bound | 0 | Find Implied Volatility |  |  |  | Stock Price | Put Profit
[NAME] | Pass | Difference, (1) - (2) | -0.0001787701423836552 |  |  | (Exp Date) | (for [NAME])
 |  |  |  |  | Expected | 37.46959239886147
Implied Volatility | 0.2254689434647947 | Choice of Volatility |  | Indicator | Mean | 36.18355226111183 | 2.181050362022532
d1 | 0.2526982809761311 | Implied Volatility |  | 1 | Median | 36.23304718846077 | 1.236523659694862
d2 | 0.09326766210520848 | [NAME] |  |  | [NAME] | 48.75532123216867 | 9.535356174073291
Put Price, Computed (2) | 2.000178770142384 |  |  |  | Min | 27.93421467408235 | -2.030429151844361
 |  | Choice of Drift |  | Indicator
Volatility, User Input | 0.25 | Expected Price = Exercise Price |  | 2 | Exercised | 14 | 0.7
d1 | 0.2443974989710203 | Expected Profit = 0 |  |  | Profitable | 14 | 0.7
d2 | 0.06762080367438342 | Risk-free Interest Rate |  |  | (for buyer)
Put Price, Computed | 2.268581638654076 | [NAME]
 |  |  |  | Drift
Volatility for Simulation | 0.2254689434647947 | Exp. Price = Exercise Price |  | -0.02515756441372015
Put Price for Simulation | 2.000178770142384 | Expected Profit = 0 |  | -0.1306994388673082
Drift for Simulation | -0.1306994388673082 | Risk-free Interest Rate |  | 0.03
 |  | [NAME] |  | 0.02
 |  |  |  |  | Sorted Run Number |  | 10
Spreadsheet: 126607d1319772938-excel-2007-how-to-populate-a-cell-via-various-selections-from-two-other-cells-transport-control-sheet
Sheet: Transport costing October 2011

2011-10-01 00:00:00
 | Transport1 |  |  | Transport2
Trip | [NAME] | Rate |  | [NAME] | Rate
Melbourne to Sydney | 0.125 | 1800 |  | 0.11 | 2000
Melbourne to Adelaide | 0.125 | 1500 |  | 0.11 | 1800
Melbourne to Brisbane | 0.125 | 5000 |  | 0.11 | 6000
Melbourne to Perth | 0.125 | 10000 |  | 0.11 | 9500
Sydney to Melbourne | 0.1 | 2300 |  | 0.085 | 2500
Sydney to Adelaide | 0.1 | 3000 |  | 0.085 | 3500
Sydney to Brisbane | 0.1 | 2000 |  | 0.085 | 2500
Spreadsheet: 50674d1250154802-matrix-transpose-695516_stianabra
Sheet: Sheet4

Sum of Value | Column
Row | a | b | c | d | e | Grand Total
a | 500 | 121 | 353 | 2321 | 21 | 3316
b | 203 | 232 | 1231 | 123 | 12 | 1801
c | 120 | 0.2222 | 42342 | 124 | 1242 | 43828.2222
d | 320 | 303 | 121 | 145 | 41 | 930
e | 12 | 233 | 454 | 675 | 896 | 2270
Grand Total | 1155 | 889.2221999999999 | 44501 | 3388 | 2212 | 52145.2222
Spreadsheet: 847475d1698391473-dynamic-filtering-when-data-is-vertical-and-horizontal-resource-test-data
Sheet: Sheet1

 |  | 2023-10-23 00:00:00 | 2023-10-30 00:00:00 | 2023-11-06 00:00:00 | 2023-11-13 00:00:00 | 2023-11-20 00:00:00 | 2023-11-27 00:00:00 | 2023-12-04 00:00:00 | 2023-12-11 00:00:00 | 2023-12-18 00:00:00 | 2023-12-25 00:00:00 | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 | 2024-01-29 00:00:00 | 2024-02-05 00:00:00 | 2024-02-12 00:00:00 | 2024-02-19 00:00:00 | 2024-02-26 00:00:00 | 2024-03-04 00:00:00 | 2024-03-11 00:00:00 | 2024-03-18 00:00:00 | 2024-03-25 00:00:00
 |  | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | 2023-11-12 00:00:00 | 2023-11-19 00:00:00 | 2023-11-26 00:00:00 | 2023-12-03 00:00:00 | 2023-12-10 00:00:00 | 2023-12-17 00:00:00 | 2023-12-24 00:00:00 | 2023-12-31 00:00:00 | 2024-01-07 00:00:00 | 2024-01-14 00:00:00 | 2024-01-21 00:00:00 | 2024-01-28 00:00:00 | 2024-02-04 00:00:00 | 2024-02-11 00:00:00 | 2024-02-18 00:00:00 | 2024-02-25 00:00:00 | 2024-03-03 00:00:00 | 2024-03-10 00:00:00 | 2024-03-17 00:00:00 | 2024-03-24 00:00:00 | 2024-03-31 00:00:00
Resource Name | Weekly Hours | Wk43 | Wk44 | Wk45 | Wk46 | Wk47 | Wk48 | Wk49 | Wk50 | Wk51 | Wk52 | Wk1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk6 | Wk7 | Wk8 | Wk9 | Wk10 | Wk11 | Wk12 | Wk13 | Projected Annual Hrs
Employee1 |  | 1.3 | 1.3 | 1.3
Employee2 |  |  |  |  | 25 | 25 | 25 | 17
Employee3 |  |  |  | 10 | 8 |  | 6
Spreadsheet: 704950d1605815032-remove-first-two-digits-cell-nos-v3
Sheet: Sheet1

TELE_CELL_PRIMARY
82906451
603193793
603890194
603994547
603998252
604173945
604471051
604673926
604676268
[PHONE]
605020758
605208905
605250444
605261525
605268466
605290266
605330693
605338673
605449274
605484070
605587530
605857696
606007860
606034659
606107623
606238019
606369786
606388643
606585097
606677666
606847000
606995864
607148865
607698420
607736577
607826733
607866213
607877853
608143859
[PHONE]
608305661
608383446
608441397
608578995
608963394
609360513
609479459
609627199
609716204
609718540
609868967
609887943
610081479
[PHONE]
610293532
610506760
610604004
610698655
[PHONE]
610883525
610916375
611231171
611454455
611598035
611626963
611637020
611811583
611934567
612012772
612190326
612241234
612312968
612405921
612616542
612821173
612877877
613118526
613138766
613426756
613623974
613718955
613935606
[PHONE]
614084971
614089633
614104010
614109141
614158453
614194816
614214602
614222291
614226725
614227486
614296999
614300613
614345360
614370612
614424888
[PHONE]
614552620
614571546
614612933
614658035
614690824
614744300
614747734
[PHONE]
614774370
614806388
614863436
614939929
614969358
614985085
615080589
618985877
619122177
[PHONE]
619331820
619550809
619690469
619697546
620034323
620143083
620328847
620480015
620514229
620828514
[PHONE]
[PHONE]
621140849
621297530
621544303
621558002
621665496
621740600
621985473
622792750
[PHONE]
623098827
623356156
623695542
623824953
623984795
624346001
624391427
624422781
624429767
624980025
625001923
625140838
625309835
625456120
625612409
625668064
625669969
625735348
626433125
626482504
[PHONE]
626735199
626797662
626824369
626996633
627126480
627170152
[PHONE]
627758600
627808634
628169624
628532025
[PHONE]
629304338
629774329
629846978
629857345
629942431
629952579
630042226
630148376
630241085
630424889
630647246
630744462
630806871
631109604
632921009
632929506
632946429
[PHONE]
633537743
270847867758
270847868401
270848003786
270848078696
270848383565
270848400021
270848503851
270848677010
270848786048
270849012375
270849178638
270849226526
270849295860
270849456603
270849683784
270849846414
270849854368
[PHONE]
276143395516
276771300780
277724198763
277761044786
277769291883
Spreadsheet: 740313d1626275957-finding-the-second-and-third-last-values-book1-2-
Sheet: Sheet1

1.12 | 6
1.1 | 5
1.12 | 2
1.13 | 1
1.13 | 1
1.11 | 4
1.15 | 5
1.16 | 3
10.2 | 2
16.2 | 1
3.2 | 0
5.6 | 1
3.6 | 3
6 | 3
2.12 | 0
8.2 | 5
9.3 | 4
2.5 | 4
1.72 | 6
1.67 | 1
1.67 | 1
1.65 | 2
1.73 | 2
1.79 | 0
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: Pacu 2003415

Pacu 2003415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Broth, [NAME] | 0.1
Broth, Beef | 0.1
Coffee Decaf Prepack cs. | 37.84
Coffee, [NAME]. cs. | 95.11
Coffee Liquid | 43.26
Sugar | 0.02
Sweetner-Sweet N Low | 0.03
Sweetner-Splenda | 0.03
Plates | 0.03
Bowls | 0.03
Plastic Ware (fork,spoon knife) | 0.03
Straws | 1.75
Salt & Pepper Shakers | 2
Monthly coffee charge
Monthly Total
Spreadsheet: 52166d1251878726-sum-formula-with-multiple-criteria-example-1-
Sheet: Sheet2

Sum of Hours | Category
Employee | [NAME] | Maintenance | Training | Grand Total
[NAME] |  | 20.5 |  | 20.5
JONES [NAME] | 25.5 |  | 34 | 59.5
[NAME] | 34 | 22.5 |  | 56.5
SMITH JOHN | 16 | 22.5 | 6 | 44.5
Grand Total | 75.5 | 65.5 | 40 | 181
Spreadsheet: 134653d1325545611-extract-login-and-logut-data-from-one-worksheet-to-another-index
Sheet: Summary

 | EMPLOYEE NAME: | EMPLOYEE17 |  |  | YEAR: | 2011
 | POSITION: |  |  |  | MONTH: | December
 | DATE | LOGIN | LOGOUT | STAFFED HOURS | TOTAL HOURS
Spreadsheet: 118522d1313745519-conditional-range-example
Sheet: Sheet1

BEFORE |  |  |  | AFTER
Piece | Price | Level |  | Piece | Price | Level
CAR | 1000 | 0 |  | CAR | =SUM(LEVEL1 ITEMS) | 0
Door | 200 | 1 |  | Door | =SUM(LEVEL2 ITEMS) Until the next level 1 (Roof) | 1
Window | 150 | 2 |  | Window | 150 | 2
Lock | 50 | 2 |  | Lock | 50 | 2
Roof | 500 | 1 |  | Roof | =SUM(LEVEL2 ITEMS) Until the next level 1 (Interior) | 1
[NAME] | 200 | 2 |  | [NAME] | 200 | 2
[NAME] | 200 | 2 |  | [NAME] | =SUM(LEVEL3 ITEMS) Until the next level 2 (lights) | 2
Rod 1 | 50 | 3 |  | Rod 1 | 50 | 3
Rod 2 | 50 | 3 |  | Rod 2 | 50 | 3
Rod 3 | 50 | 3 |  | Rod 3 | 50 | 3
Rod 4 | 50 | 3 |  | Rod 4 | 50 | 3
Lights | 100 | 2 |  | Lights | 100 | 2
Interior | 300 | 1 |  | Interior | =SUM(LEVEL2 ITEMS) Until the next level 1 | 1
Seats | 200 | 2 |  | Seats | 200 | 2
[NAME] | 100 | 2 |  | [NAME] | 100 | 2
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 770317d1645988726-how-to-convert-text-to-rows-report-filter-format-help
Sheet: Desired Report Format

RO # | RO-DATE | WIDATE-CAT | CWI-FLAG | ADV-NO | MISC-CODE | CODE-AMT | JOB# | OPERATION CODE
423067 | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | C | 285 | PAGL | -18.57 | 1 | 92AUZWB
423070 | 2022-02-01 00:00:00 | 2022-02-16 00:00:00 | C | 416 | D2 | -26.5 | 1 | 24AUZ1
423070 | 2022-02-01 00:00:00 | 2022-02-16 00:00:00 | C | 416 | E2 | -13.25 | 1 | 24AUZ1
423070 | 2022-02-01 00:00:00 | 2022-02-16 00:00:00 | C | 416 | D2 | -2.75 | 4 | 00AUZMPI
423070 | 2022-02-01 00:00:00 | 2022-02-16 00:00:00 | C | 416 | E2 | -1.38 | 4 | 00AUZMPI
423070 | 2022-02-01 00:00:00 | 2022-02-16 00:00:00 | C | 416 | D2 | -92.75 | 5 | 24AUZZWARN1
423070 | 2022-02-01 00:00:00 | 2022-02-16 00:00:00 | C | 416 | E2 | -46.38 | 5 | 24AUZZWARN1
423093 | 2022-02-01 00:00:00 | 2022-02-10 00:00:00 | C | 416 | D2 | -22 | 1 | 24AUZ1
423093 | 2022-02-01 00:00:00 | 2022-02-10 00:00:00 | C | 416 | E2 | -11 | 1 | 24AUZ1
423093 | 2022-02-01 00:00:00 | 2022-02-10 00:00:00 | C | 416 | D2 | -39.75 | 4 | 46AUZ-RR-BRAKES
423093 | 2022-02-01 00:00:00 | 2022-02-10 00:00:00 | C | 416 | E2 | -19.88 | 4 | 46AUZ-RR-BRAKES
423093 | 2022-02-01 00:00:00 | 2022-02-10 00:00:00 | C | 416 | D2 | -39.75 | 4 | 46AUZ-RR-BRAKES
Spreadsheet: 807651d1669986290-how-to-filter-a-lot-of-values-at-once-s666-pt-how-to-filter-a-lot-of-values-at-once
Sheet: Sheet1

 | First | Second | Rows |  | Rows | (Multiple Items)
 | 321 | 101 | 1
 | 412 | 102 | 2 |  | Max of First | Min of First | [NAME] of Second | Min of Second
 | 123 | 103 | 3 |  | 960 | 123 | 108 | 103
 | 543 | 104 | 4
 | 431 | 105 | 5
 | 432 | 106 | 6
 | 323 | 107 | 7
 | 960 | 108 | 8
 | 423 | 109 | 9
 | 752 | 110 | 10
Spreadsheet: 542075d1507707729-return-the-2nd-smallest-number-within-a-date-range-small-kevin-test
Sheet: Sheet1

2017-01-01 00:00:00 | 2017-05-04 00:00:00 |  | 2017-01-01 00:00:00 | 06:45:00
 |  |  | 2017-03-02 00:00:00 | 11:00:00
 |  |  | 2017-03-03 00:00:00 | 00:00:00
 |  |  | 2017-05-05 00:00:00 | 06:45:00
 |  |  | 2017-02-01 00:00:00 | 09:15:00
 |  |  | 2017-01-21 00:00:00 | 10:15:00
 |  |  | 2017-01-18 00:00:00 | 00:00:00
 |  |  | 2017-05-15 00:00:00 | 09:15:00
 |  |  | 2017-06-14 00:00:00 | 06:30:00
 |  | I wish to return the 2nd smallest number, ignoring duplicates, between the date range A1:B1
Spreadsheet: tracy_geaccone__40272__AEL 06 01 (GBP)
Sheet: Income State. - YTD

Azurix Europe Ltd
Statement of Income
YTD June 2001
(US GAAP & £ sterling 000)
 |  |  | YTD
 |  |  | Actuals |  | Forecast |  | [NAME] |  | Budget |  | [NAME]
Revenues:
 | WWSL Potable Water |  | 39095 |  | 38485 |  |  |  | 38606
 | WWSL Sewage |  | 83807 |  | 83988 |  |  |  | 82980
 | WWSL Unregulated |  | 6180 |  | 6099 |  |  |  | 5326
 | Swiss Combi |  | 5080 |  | 4741 |  |  |  | 5394
 | Wessex Water Enterprises |  | 3706 |  | 3906 |  |  |  | 3686
Net operating revenues
Operating and maintenance expenses:
 | Personnel |  | 7869 |  | 7806 |  |  |  | 7096
 | Power |  | 4658 |  | 4710 |  |  |  | 4843
 | Chemicals and materials |  | 1346 |  | 1601 |  |  |  | 2052
 | Equipment costs |  | 1393 |  | 1323 |  |  |  | 1210
 | Abstraction/Discharge fees |  | 2516 |  | 2465 |  |  |  | 2347
 | Transportation |  | 2305 |  | 2130 |  |  |  | 2257
 | Rent and rates |  | 5104 |  | 5074 |  |  |  | 4944
 | Other operations costs |  | 4967 |  | 4738 |  |  |  | 4410
 | WWSL Unregulated |  | 2568 |  | 2220 |  |  |  | 2245
 | Swiss Combi |  | 5859 |  | 5639 |  |  |  | 5748
 | Wessex Water Enterprises |  | 3917 |  | 4065 |  |  |  | 3372
Total O&M expense
General and administrative expense
 | Billing and customer services |  | 5869 |  | 5895 |  |  |  | 6282
 | Other overhead departments |  | 4546 |  | 4556 |  |  |  | 4231
 | Azurix Corp share options |  | 529 |  | 529 |  |  |  | 0
Total G&A expense
EBITDA
Depreciation and amort. expense |  |  | 27607 |  | 27126 |  |  |  | 26808
Goodwill amortization expense |  |  | 6648 |  | 6740 |  |  |  | 6700
Total D&A expense
Equity in (gain)/loss of unconsolidated affiliates
Interest income - affiliates (list separately) |  |  | -3491 |  | -3477 |  |  |  | -3380
Interest income - 3rd party |  |  | -2179 |  | -2329 |  |  |  | -3080
Interest expense, gross - affiliates (list separately) |  |  | 2281 |  | 2271 |  |  |  | 2220
Interest expense, gross - 3rd parties |  |  | 23825 |  | 24723 |  |  |  | 27180
Amort. & W/O, deferred financing costs |  |  | 470 |  | 492 |  |  |  | 600
(Capitalized interest) |  |  | -1534 |  | -1678 |  |  |  | -2500
Dividend Income
(Gain)/loss on disposition of assets
Currency transaction (gain)/loss
Total other (income)/expense
Income tax expense, current |  |  | 3449 |  | 3039 |  |  |  | 700
Income tax expense, deferred |  |  | 7784 |  | 8150 |  |  |  | 10500
Total income tax expense
Minority Interest
Net Income
Spreadsheet: 886320d1736348308-doing-sum-doing-sum
Sheet: Required1

 | New Testament |  | 1 | 2
 | List | Code | Papermint | Papermint
 |  | 119232628 | 0 | 0
 | Amit Chaudary | 119212921 | 0 | 0
 | Arjun PD Yadav | 0 | 0 | 0
 | Arjun Razzak | 119232448 | 0 | 0
 | Ajal Kumar Mukhiya | 139420531 | 0 | 0
 | [NAME] | 119213117 | 0 | 0
 | [NAME] | 119228041 | 21469.68 | 24032.72
 | [NAME] | 0 | 15392.36 | 20474.15
 | [NAME]. Mandal | 119227334 | 0 | 0
 | Total