tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | June |  | July |  | August |  | September |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | 185374 | 473464.26 | 47830 | 12419739.65 | -111245 | -22288.89
2 |  | Liquidations |  |  |  |  |  |  |  | 0
3 |  | Interdesk |  |  |  |  |  |  |  |  |  |  | 1276421 | 4010434
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  | 837781 |  | -15180719.97
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  | 31183 | 2647849.2 | 76011 | -200552.86
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | 3643131 |  | -43697
8 |  | Interdesk |  |  |  |  |  |  |  |  |  |  | -1276421 | -4010434
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  | -81061 | -343698.64 | -153024 | -648821.76 | 1393 | 5906.32
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  |  |  | 28028 | 108468.4 |  | 7751.78
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  | 15092 | 75529.62 | -47844 | -202858.56 | 30744 | 130354.56
14 |  | Cash Out |  |  |  |  |  |  | -48059 | -205070.95 | -2987 | -11806.45
15 |  | Cash In |  |  |  |  |  |  | 49389 | 209951.03 | 3752 | 14943.82
16 |  | Synthetic Storage |  |  |  |  |  |  | -15 |  |  |  | 30
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  | 13347 | 56591.28
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 38463 | 163083.12 | 121090 | 513421.6 | 3067 | 13004.08
23 | Fuel: |  |  |  |  |  |  |  | 81061 | 343698.64 | 153024 | 648821.76 | -1393 | -5906.32
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  | 5001613 | 1379985.78 | -14533614 | -1439002.09 | -27276675 | 33118.81
25 |  | Demand |  |  |  |  |  |  |  | -1523081.06 |  | 1491387.23
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  | 4793328 |  | 1599534.5
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 7b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 1177531 | 8598876 | 2320596 | 1938859 | 349294 | 133158 | 232689 | 14751003
Fixed-Float | 64460329 | 77704041 | 14714568 | 18892310 | 4671785 | 4321226 | 12223828 | 196988087
FRA | 25463442 | 16981438 | 8351293 | 24126 | 281911 | 76770 | 3905984 | 55084964
OIS | 21624151 | 6016069 | 5753870 | 151341 | 1743147 | 906306 | 918622 | 37113506
Swaption | 8048824 | 8109234 | 1298534 | 2574156 | 321399 | 17076 | 273034 | 20642257
OTHER* | 6101745 | 10732537 | 1144760 | 325616 | 164626 | 35501 | 230948 | 18735733
TOTAL
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 26125 | 26316 | 9809 | 8750
2 | 25579 | 26140 | 9577 | 8750 |  |  |  | 176
3 | 25083 | 26316 | 9649 | 8750
4 | 24738 | 26069 | 9083 | 8668
5 | 24635 | 26316 | 9400 | 8750
6 | 24092 | 26316 | 9085 | 8750
7 | 23913 | 26316 | 7801 | 8750 |  |  | 67
8 | 23713 | 26316 | 9583 | 8750
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 150097
2001-08-08 00:00:00
CBS Volume
 |  |  | -60022
Spreadsheet: 889295d1740064070-dynamic-spill-sumif-s-vertically-and-horizontally-dynamic-array-sumif-spilling-vertically-and-horizontally
Sheet: Sheet1

Raw Data |  |  |  |  |  |  |  |  |  |  |  |  |  | GroupA Totals |  |  |  |  |  |  |  |  |  |  |  |  | GroupB Totals
 | GroupA | GroupB | GroupB | GroupA | GroupA | GroupA | GroupA | GroupA | GroupB | GroupB | GroupB | GroupB |  | GroupA | GroupA | GroupA | GroupA | GroupA | GroupA | GroupA | GroupA | GroupA | GroupA | GroupA | GroupA |  | GroupB | GroupB | GroupB | GroupB | GroupB | GroupB | GroupB | GroupB | GroupB | GroupB | GroupB | GroupB
ID | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR |  | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR |  | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR
U.3423 | 292 | 242 | 197 | 192 | 4 | 216 | 232 | 228 | 68 | 494 | 291 | 139 |  |  | 0 | 0 | 192 | 4 | 216 | 232 | 228 | 0 | 0 | 0 | 0 |  |  | 242 | 197 | 0 | 0 | 0 | 0 | 0 | 68 | 494 | 291 | 139
U.3421 | 167 | 456 | 270 | 7 | 53 | 339 | 190 | 267 | 88 | 440 | 459 | 400 |  | 167 | 0 | 0 | 7 | 53 | 339 | 190 | 267 | 0 | 0 | 0 | 0 |  | 0 | 456 | 270 | 0 | 0 | 0 | 0 | 0 | 88 | 440 | 459 | 400
U.3252 | 351 | 233 | 6 | 110 | 13 | 410 | 413 | 166 | 130 | 104 | 200 | 271 |  | 351 | 0 | 0 | 110 | 13 | 410 | 413 | 166 | 0 | 0 | 0 | 0 |  | 0 | 233 | 6 | 0 | 0 | 0 | 0 | 0 | 130 | 104 | 200 | 271
U.435345 | 19 | 471 | 491 | 269 | 118 | 485 | 287 | 389 | 57 | 348 | 490 | 341 |  | 19 | 0 | 0 | 269 | 118 | 485 | 287 | 389 | 0 | 0 | 0 | 0 |  | 0 | 471 | 491 | 0 | 0 | 0 | 0 | 0 | 57 | 348 | 490 | 341
U.353 | 296 | 134 | 250 | 132 | 147 | 287 | 494 | 201 | 73 | 161 | 321 | 161 |  | 296 | 0 | 0 | 132 | 147 | 287 | 494 | 201 | 0 | 0 | 0 | 0 |  | 0 | 134 | 250 | 0 | 0 | 0 | 0 | 0 | 73 | 161 | 321 | 161
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Had to type this formula 5 times (once for each row). Can it just be one formula that spills across all months and rows? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | check
Spreadsheet: 800533d1665715033-dynamic-array-rank-if-dynamic_rank_if_help
Sheet: Sheet1

 |  |  |  |  | Dynamic Array | Dynamic Array | Manual
 |  |  |  |  |  |  | Desired Output
 |  |  |  |  | Name | Score | Ranked Score
Column1 | Column2 |  |  |  |  |  | 1
[NAME] | 10 |  |  |  | [NAME] | 9 | 1
[NAME] | 9 |  |  |  | Raj | 5 | 2
Raj | 5 |  |  |  | Gina | 4 | 4
Gina | 4 |  |  |  | Gina | 5 | 3
Gina | 5 |  |  |  | [NAME] | 8 | 2
[NAME] | 8 |  |  |  | [NAME] | 6 | 2
[NAME] | 6 |  |  |  | Raj | 4 | 3
Raj | 4 |  |  |  | Gina | 7 | 2
Gina | 7 |  |  |  | Dawn | 8 | 1
Dawn | 8 |  |  |  | [NAME] | 2 | 3
[NAME] | 2 |  |  |  | [NAME] | 5 | 3
[NAME] | 5 |  |  |  | Raj | 2 | 4
Raj | 2 |  |  |  | Gina | 11 | 1
Gina | 11 |  |  |  | Raj | 14 | 1
Raj | 14
Spreadsheet: 44627d1243406015-excel-2007-if-function-test
Sheet: List2

[NAME] | Št. Prejema | Šifra | Poz. | Material | [NAME] | Kval. | Dimenzija (mm) | Kol. ([NAME]) | Kol. (m) | Kos. | [NAME] | Št. Plošče | A-TEST | [NAME] | Nalog
Exterfer | 000115 | 10292 | 1 | Pločevina |  | ST-37 | 10x2500x8000 | 1600 |  | 1 | 918168-911894-1-3 |  | [NAME] | Metalna IMPRO\Material\Dobavnice\2009\Exterfer\001.jpg
 |  | 10313 | 2 | Pločevina |  | ST-37 | 8x2500x6000 | 960 |  | 1 | 916336-29-01 |  | [NAME]
Exterfer | 000116 | 10299 | 1 | Pločevina |  | ST-37 | 25x1500x6000 | 1800 |  | 1 | 628968 |  | [NAME] | Metalna IMPRO\Material\Dobavnice\2009\Exterfer\002.jpg
Inox Center | 000114 | 10255 | 1 | Pločevina | Nr. | 1.4301 | 4x1000x2000 | 640 |  | 10 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Inox-Center\001.jpg
 |  | 10258 | 2 | Pločevina | Nr. | 1.4301 | 4x1500x3000 | 864 |  | 6
 |  | 10243 | 3 | Pločevina | Nr. | 1.4301 | 1.5x1500x3000 | 109.6 |  | 2
 |  | 10248 | 4 | Pločevina | Nr. | 1.4301 | 2x1500x3000 | 216 |  | 3
Al/Cu Domžale | 000117 | 10194 | 1 | Kotnik | Nr. enakokraki | Al | 8x80 | 41 | 12 | 2 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Al-Cu\0001.jpg
Pahor | 000118 |  | 1 | Jeklo | Nr. ploščato | 1.4301 | 3x25 | 47 | 12 | 4 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Pahor\0001.tif
 |  | 10018 | 2 | Cev | Nr. šivna okrogla | 1.4301 | 48.3x2 |  | 42 | 7
 |  | 10103 | 3 | [NAME] | Nr. | 1.4301 | 48.3x2 |  |  | 4
 |  |  | 4 | Pločevina | Nr. | 1.4301 | 3x1500x4000 | 283 |  | 2
 |  |  | 5 | Pločevina | Nr. | 1.4301 | 4x1000x4000 | 249 |  | 2
 |  |  | 6 | Pločevina | Nr. | 1.4301 | 4x1000x3000 | 93 |  | 1
 |  |  | 7 | Pločevina | Nr. | 1.4301 | 4x1000x2000 | 63 |  | 1
So what i want is:
IF D2,E2,F2,G2,H2 |  | Match with the values in Sheet1 then copy the value from row A on sheet 1 to C2 and so on
Spreadsheet: 296557d1392128200-create-unique-list-from-data-0a1_a6
Sheet: Department Information

 | Department Name: Development | Applications & Development |  | Interview 1 date: enter date here |  |  | Interview 2 date: enter date here
 | User Surname | User First Name
 | Please insert additional rows in the above table as required
Spreadsheet: 778350d1651013048-apply-variable-compounding-interest-between-two-dates-not-sum-indexation-sample
Sheet: Sheet1

Start Date | End Date | Principal | Final Amount |  | Indexation to today
2020-06-12 00:00:00 | 2021-06-15 00:00:00 | 1000
 |  | 2016-06-01 00:00:00 | -0.005354
 |  | 2016-09-01 00:00:00 | -0.008459
 |  | 2016-12-01 00:00:00 | -0.002181
 |  | 2017-03-01 00:00:00 | 0.009774
 |  | 2017-06-01 00:00:00 | 0.013519
 |  | 2017-09-01 00:00:00 | 0.00961
 |  | 2017-12-01 00:00:00 | 0.008888
 |  | 2018-03-01 00:00:00 | 0.007293
 |  | 2018-06-01 00:00:00 | 0.008743
 |  | 2018-09-01 00:00:00 | 0.00984
 |  | 2018-12-01 00:00:00 | 0.010961
 |  | 2019-03-01 00:00:00 | 0.007353
 |  | 2019-06-01 00:00:00 | 0.004657
 |  | 2019-09-01 00:00:00 | 0.002313
 |  | 2019-12-01 00:00:00 | 0.00289
 |  | 2020-03-01 00:00:00 | 0.000288 |  | Manual Calculation applying compounding interest to Principal between Start and End Dates
 |  | 2020-06-01 00:00:00 | -0.002887
 |  | 2020-09-01 00:00:00 | -0.002304
 |  | 2020-12-01 00:00:00 | 0
 |  | 2021-03-01 00:00:00 | -0.00029
 |  | 2021-06-01 00:00:00 | 0.002597
 |  | 2021-09-01 00:00:00 | 0.005729
 |  | 2021-12-01 00:00:00 | 0.012343
Spreadsheet: 03113223-47e5-4817-83e2-bf23f14917a6
Sheet: VSSDRY

Dry samples | Wt@103 | wt @ 105 | DW | dish wt | VSS% |  | wet samples | wt@103 | wt@105 |  | Beaker
WWTP | 73.4 | 72.7 |  | 72.4 |  |  |  | 51.4 | 50.6 |  | 50.3
Soln | 51.1 | 50.3 |  | 50.1
WWTP | 51.8 | 51.1 |  | 50.8 |  |  |  | 49.8 | 49 |  | 48.6
sol | 58.1 | 57.3 |  | 57.2
sol | 48.7 | 47.9 |  | 47.7 |  |  |  | 51.9 | 51.1 |  | 50.8
sol | 1.4778 | 1.3484 |  | 1.2878 |  |  |  | 1.4 | 1.3188 |  | 1.2878
 | 1.4952 | 1.349 |  | 1.2878
 | 1.4671 | 1.3413 |  | 1.2878
2014-06-29 00:00:00
batch 21 | 51.78 | 50.07 |  | 49.8
2014-07-04 00:00:00
batch 22 | 52.29 | 50.49 |  | 49.96
2014-07-13 00:00:00
batch 23 | 52.89 | 51.29 |  | 50.82
2014-07-15 00:00:00
ddw | 2.96 | 1.71 |  | 1.3
2014-07-20 00:00:00
batch 24 | 51.93 | 50.45 |  | 49.9
2014-08-12 00:00:00
batch 25 | 51.72 | 50.18 |  | 49.53
2014-08-14 00:00:00
ddw | 4.0876 | 2.82 |  | 2.1601
2014-08-19 00:00:00
batch 26 | 51.02 | 50.1 |  | 49.7
2014-08-21 00:00:00
batch 27 | 53.18 | 50.95 |  | 49.99
2014-08-31 00:00:00
batch 27 | 52.19 | 50.15 |  | 49.31
2014-09-02 00:00:00
batch 28 | 53.16 | 50.77 |  | 49.71
2014-09-08 00:00:00
batch 29 | 52.36 | 50.25 |  | 49.3
2014-09-02 00:00:00
air dried | 1.4665 | 1.3626 |  | 1.3216
 | 1.3895 | 1.339 |  | 1.3207
oven dried | 1.568 | 1.4082 |  | 1.3303
2014-09-22 00:00:00
batch 30 | 2.6112 | 2.309 |  | 2.1875
batch 31 | 2.5962 | 2.2765 |  | 2.1579
batch 32 | 2.4047 | 2.2468 |  | 2.1981
2014-09-26 00:00:00
RDW | 2.5043 | 2.2847 |  | 2.2
DDW | 2.4533 | 2.2908 |  | 2.2
DDW | 2.4299 | 2.2718 |  | 2.2
2014-10-05 00:00:00
RDW | 3 | 2.5 |  | 2.2
 | 2.8 | 2.3 |  | 2.1
Spreadsheet: darrell_schoolcraft__7364__imball0201
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -2
2 | -1
3
4
5 | -896
6 | -2012
7 | -2035 | 681
8 | -2068 |  |  |  |  |  |  |  |  |  | Avg
9 | -1970 | 908 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10 | -532
11 | -566 |  |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 | -634 |  |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 | -2025 |  |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 | -1925 |  |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 | -1795 |  |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 | -2006 | -681 |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 | -883 |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18 | -901
19 | -930
20 | -1952
21 | -2043
22 | -2082
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -355805
2002-01-22 00:00:00
CBS Volume
 |  |  | -44621
Spreadsheet: 49b55e9a-5e0e-4ce9-9d8a-911faeb6e946
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTH | Test | FFTH | Cannabinoid Analysis, whole blood | Cannabinoid Analysis, whole blood | Screen by Immunoassay (IA) Gas Chromatography/Mass Spectrometry (GC/MS)-if appropriate | Gray-top (Fluoride Oxalate) tube:GryFlOx |  |  | 7 | mL | Draw blood in grey-top (NaF/oxalate) tube(s). Refrigerate  specimen after collection. Send 7 mL of Sodium fluoride/oxalate whole  blood refrigerated. | 5 mL  NOTE: Submission of the mi | Specimens other than	[NAME] Anticoagulants other than	Sodium fluoride/oxalate Sodium heparin, EDTA Hemolysis	NA Thawing	Cold OK; Warm NO Lipemia	NA Icteric	NA | This specimen was screened by Immunoassay. Any positive result is  confirmed by Gas Chromatography with Mass Spectrometry (GC/MS).  The following threshold concentrations are used for this analysis:   Drug                                                Screening Threshold          Confirmation Threshold   Cannabinoids                 		5 ng/mL Tetrahydrocannabinol (THC)                   		               2 ng/mL Carboxy-THC                                  				2 ng/mL             Test Performed by: Medtox Laboratories, Inc.                                        402 W. County Road D                                        St. Paul, MN. 55112 | Monday through Sunday | 5 days | 6 days | 1 | 80101 |  |  |  |  | Medtox Laboratories, Inc
FFTH | [NAME] | WBNAFL | [NAME] NaFl-KOx |  |  |  | Refrigerated
FFTH | Result | Z1156 | THC ([NAME]) Metabolite | THC ([NAME]) Metabolite | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTH | Result | Z1174 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTH | Result | Z1175 | Tetrahydrocannabinol GC/MS Confirm | Tetrahydrocannabinol GC/MS Confirm | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FFTH | Result | Z1173 | Carboxy-THC | Carboxy-THC | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 749341d1632743659-concatenate-numbers-from-different-string-format-concatenate_numbers-2-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sources | Formated |  | AliGW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Update 6.1, Update 7 - 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Update 9,2, Final 9 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version, 7,4, Update 9-5, Fix 9 Version 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version 9/8, Release 10.1 |  | Version 10.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version 11.2, Release 12.3 |  | Version 12.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Release 7 Version 5, Release 8 Version 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous information 9 version 4, Release 10 Information - Unknown Text 1 |  | Version 10.1
Spreadsheet: 113151d1309137895-filing-in-blank-cells-on-duplicated-rows-sample-starting-data
Sheet: Sheet1

First Name | Last Name | Type | Title | Company | Id | Primary Email | PrimaryPhone | PrimaryCell | PrimaryFax | [NAME] | [NAME] | Primary Address_2 | Primary City | Primary State | [NAME] | Primary Country
Juanita | Caddy |  |  | Department of Education, Employment and Workplace Relations DEEWR FED |  | [EMAIL] | 123 456 789 |  |  | http://www.deewr.gov.au
Juanita | Caddy |  |  | Department of Education, Employment and Workplace Relations DEEWR FED |  | [EMAIL] |  |  | 123 456 789 | http://www.deewr.gov.au | [NAME] |  | Canberra |  | 2601 | Australia
Juanita | Caddy |  | Assistant Director - ISC Funding and Stakeholder Engagement | Department of Education, Employment and Workplace Relations DEEWR FED |  | [EMAIL] |  |  |  | http://www.deewr.gov.au |  |  | Canberra | Australian Capital Territory |  | Australia
Spreadsheet: 971ca242-c987-46c2-beb3-3e0e6f04376d
Sheet: Income Statement

Juniper Networks, Inc.
Preliminary Condensed Consolidated Statement of Operations
(in thousands, except per share amounts)
(unaudited)
 | Three Months Ended March 31,
 | 2012 |  | 2011
Net revenues:
Product | 771873 |  | 877440
Service | 260625 |  | 224172
Total net revenues
Cost of revenues:
Product | 280629 |  | 265746
Service | 117814 |  | 99981
Total cost of revenues
Gross margin
Operating expenses:
Research and development | 269602 |  | 261979
Sales and marketing | 257719 |  | 246291
General and administrative | 54666 |  | 44924
Amortization of purchased intangible assets | 1178 |  | 1544
Restructuring and other charges | 2039 |  | -347
Acquisition-related and other charges | 1142 |  | 4101
Total operating expenses
Operating income
Other (expense) income, net | -24431 |  | -6462
Income before income taxes and noncontrolling interest
Income tax provision | 7008 |  | 41271
Consolidated net income
Adjust for net loss (income) attributable to noncontrolling interest | 0 |  | 90
Net income attributable to Juniper Networks
Net income per share attributable to Juniper Networks common stockholders:
Basic | 0.03 |  | 0.24
Diluted | 0.03 |  | 0.24
Shares used in computing net income per share:
Basic | 527186 |  | 530789
Diluted | 533683 |  | 548825
Spreadsheet: 178291d1346752915-help-with-date-formulas-that-detail-networkdays-and-statutory-uk-holidays-proc-formulas
Sheet: Sheet1

Code | Trade | Proc Mnr | Package Budget | Quality Grading | Procurement Stream to [NAME] (Weeks) |  | Receipt of Initial Design Info for Review | Design Review Period | Package Kick Off Meeting Agree ITT Content | Scope of Works Preparation Period | Scope Received | Prepare Design Info for QS Billing | Issue [NAME] to QS for Billing/ Pricing Document | Billing Period/Pricing Document | Receipt of BoQ / Pricing Document | Prepare Package Programme | Receive of Package Programme | ITT Prep Complete and Bid List Sign Off | [NAME] | Out to Tender | Tender Period | [NAME] | Tender Analysis Period | Post-Tender Meeting | Finalisation Period (weeks) | Issue Package Approval Form & Core Process Approval | Approval Period | Subcontract Document Prep Period (weeks) | Place Order Date | Lead In (weeks | Start on Site
 | Access Control
 |  | KO |  |  |  | Enterprise Solutions |  | 2 |  | 1 |  | 2 |  | 2 |  | 3 |  |  | 1 |  | 4 |  | 2 |  | 2 |  | 1 | 1 |  | 10 | 2013-09-23 00:00:00
Spreadsheet: judy_townsend__17723__trans1
Sheet: Input

 |  |  |  |  |  |  | Gas Daily Override
 | Transport Entry and Amendment Page |  |  |  |  |  | Location | Current | Override |  | Don't Alter this Area
 | All data must be on the same pipe (e.g. Transco/Z1 to Transco/Z3, not Transco/Z1 to Texas Gas) |  |  |  |  |  |  |  |  |  | 25 | 25 | 1 | 10
 |  |  |  |  |  |  |  |  |  |  | From: | To: | TransType | GDCurve | Comm$ | s/c | Fuel%
 | From Pipe Location:
 | To Pipe Location:
 | Transport Type:
 | Gas Daily Curve to Use for Fuel:
 | Commodity Charge ($): | 0.0215
 | [NAME] ($): | 0.0022
 | Fuel Percent (%): | 0.017
 | Fuel Cost:
 | Total Cost per MMBTU:
 | [NAME] L 800
 | [NAME] -- Zone 0
 | [NAME] -- Zone 1 500 (w/surcharge)
 |  |  |  |  |  |  |  | IT Winter
 |  |  |  |  |  |  |  | ITS1 Winter
Spreadsheet: 808665d1670576708-referencing-multiple-tables-named-ranges-variable-column-retrieval-mock-up-for-formula-for-excel
Sheet: Sheet1

Name | Class | SEND | SEN NEED | Photo | PP | Target | T-Initial | Block | Block Target | Overall | Practical | Listening | Listening - Grade |  |  | HHR |  | F | I | A |  | MA |  | F | I | A
SurnameA, FirstA | 8A1 |  |  | Yes | ✕ | Foundation |  | HHR |  |  | S | 10 | E |  |  | 22 | A+ | E | E | E |  | 22 | A+ | X | X | X
SurnameB, FirstB | 8A1 |  |  | Yes | ✕ | Intermediate |  | HHR |  |  | S | 10 | M |  |  | 21 | A+ | E | E | E |  | 21 | A+ | X | X | X
SurnameC, FirstC | 8A1 |  |  | Yes | ✕ | Advanced |  | HHR |  |  | S | 10 | S |  |  | 20 | A | E | E | M |  | 20 | A | X | X | Y
SurnameD, FirstD | 8A1 |  |  | Yes | ✕ | Advanced |  | HHR |  |  | S | 15 | M |  |  | 19 | A | E | E | M |  | 19 | A | X | X | Y
SurnameE, FirstE | 8A1 |  |  | Yes | ✕ | Foundation |  | MA |  |  | S | 10 | X |  |  | 18 | A | E | E | M |  | 18 | A | X | X | Y
SurnameF, FirstF | 8A1 |  |  | Yes | ✕ | Intermediate |  | MA |  |  | S | 10 | Y |  |  | 17 | A | E | E | M |  | 17 | A | X | X | Y
SurnameG, FirstG | 8A1 |  |  | Yes | ✕ | Advanced |  | MA |  |  | S | 10 | Z |  |  | 16 | A | E | E | M |  | 16 | A | X | X | Y
SurnameH, FirstH | 8A1 |  |  | Yes | ✕ | Advanced |  | MA |  |  | S | 15 | Y |  |  | 15 | A | E | E | M |  | 15 | A | X | X | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | I | E | M | S |  | 14 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | I | E | M | S |  | 13 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | I | E | M | S |  | 12 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | I | E | M | S |  | 11 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | I | E | M | S |  | 10 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | I | E | M | S |  | 9 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | F | M | S | D |  | 8 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | F | M | S | D |  | 7 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | F | M | S | D |  | 6 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | F | M | S | D |  | 5 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | U | S | D | D |  | 4 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | U | S | D | D |  | 3 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | U | S | D | D |  | 2 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | U | S | D | D |  | 1 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | U | S | D | D |  | 0 | U | Z | U | U