tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | BUG
 |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  | 61951 |  | -61951 |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  | -130500 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  | 0 |  |  |  |  |  |  | 201035 |  |  |  |  |  |  |  | -236103 |  |  |  |  |  |  |  |  | 0
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -940000
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  | 0 | -502160
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -95808
18 |  | W/D (Purchase from Stg) |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13427849
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  | 409000
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -50000
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 |  |  |  |  |  |  |  |  |  |  |  | -135000 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | -21000 |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME] |  |  |  |  |  | 22942
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | -178764
 |  | TOTAL
Spreadsheet: lynn_blair__24319__INTERCONNECT NOMvsSCHED
Sheet: Dec 05

 |  | INTERCONNECT NOMINATED vs. SCHEDULED FOR NNG
 | Gas Day: | 2001-12-05 00:00:00 |  | Cycle: |  | Timely |  | Evening |  | IntraDay 1 |  | IntraDay 2
 |  |  |  | Prior Day | Prior Day |  |  |  |  |  |  |  |  | REDUCTION
IC PIPE | POI | K# | Gas Type | [NAME] | Sched | NOM | SCHED | NOM | SCHED | NOM | SCHED | NOM | SCHED | REASON
EPNG | 169 |  |  | 10500 | 10500 | 3000 | 3000 |  |  |  |  |  |  | Nom decrease
 | 186 |  |  | 15000 | 4894 | 75525 | 5000 |  |  |  |  |  |  | Nom increase
 | 2618 |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  | n/a
 | 57088 |  |  | 4000 | 0 | 0 | 0 |  |  |  |  |  |  | Nom decrease
 | 57100 |  |  | 120194 | 60147 | 154884 | 94809 |  |  |  |  |  |  | Nom increase
[NAME] | 2174 | Nothing significant to report |  | eport
OASIS | 62148 |  |  | 24788 | 24788 | 63157
PEPL | 173 | Nothing significant to report |  |  | 0 | 0 | 0 | 0
 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 |  | 0 | 0 | 0 | 0 | 0
TWPL | 3531 | Nothing significant to report
 | 60667
 | 60749
ENA/LE330 |  | K# | Gas Type |  |  | NOM | SCHED | NOM | SCHED | NOM | SCHED | NOM | SCHED | REASON
[NAME] | 37654 | 100919 | IT |  |  | 18677 | 2010 | 2010 | 2010
 |  | 101099 | [NAME]
Note: | K#101099 is an administrative contract set up to reimburse ENA for providing Electricity to operate the electric compressors on NNG.
 | This gas should continue to flow when nominated.  The volume is 2,010 dth per day for December.  If you have any questions, please call.
Spreadsheet: 522ab9fb-10b8-409b-ade6-62acb28bfd61
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Water Productivity(€/m3) per secrtor in Cyprus
 |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
tertiary sector | water use ([NAME]) | 42.7 | 48.2 | 47.9 | 58 | 63 | 65.8 | 68.9 | 73.3 | 73.7 | 73.9 | 62.5
NACE (F-T) | GDP (mio €) at current market price | 6445.44 | 7014.801000000001 | 7580.115 | 8183.415999999999 | 8373.644 | 8905.415000000003 | 9608.011 | 10357.04 | 11279.214 | 12326.464 | 13387.9
 | water productivity (€/m3) | 150.9470725995316 | 145.5352904564315 | 158.2487473903967 | 141.0933793103448 | 132.9149841269841 | 135.3406534954408 | 139.4486357039187 | 141.2965893587995 | 153.0422523744912 | 166.7992422192151 | 214.2064
industry (nace C) | water use ([NAME]) | 2 | 2 | 2 | 21.3 | 19.9 | 18.6 | 10.2 | 5.2 | 5.4 | 6.2 | 6
 | GDP (mio €) at current market price | 817.15 | 847.421 | 871.354 | 892.662 | 923.071 | 946.488 | 1002.988 | 1014.673 | 987.577 | 1012.014 | 1040.231
 | water productivity(€/m3) | 408.575 | 423.7105 | 435.677 | 41.90901408450704 | 46.38547738693468 | 50.88645161290322 | 98.33215686274511 | 195.1294230769231 | 182.8846296296296 | 163.228064516129 | 173.3718333333333
agriculture (nace A) | water use ([NAME]) | 132.3 | 145.6 | 135.5 | 143.2 | 158.4 | 165.9 | 173.5 | 166.7 | 159.2 | 149.4 | 150
 | GDP (mio €) at current market price | 329.821 | 344.564 | 341.126 | 363.376 | 376.275 | 347.763 | 341.791 | 346.674 | 312.91 | 312.626 | 354.014
 | water productivity (€/m3) | 2.492978080120937 | 2.366510989010989 | 2.517535055350554 | 2.537541899441341 | 2.375473484848484 | 2.096220614828209 | 1.969976945244957 | 2.079628074385123 | 1.965515075376885 | 2.092543507362784 | 2.360093333333333
Spreadsheet: 682926d1592396947-combine-multiple-rows-data-in-to-one-row-combine-multiple-rows
Sheet: Sheet1

job | building | phase | Plan | Balance | category | CLEARED | UNCLEARED
[NAME] | A1 | 1 | 25 | 5 | 5 Site Clearance Awtd. |  | A1/1,2,3 | (Add up Building (Col.B and Col. C), wherever Category (Col.F) and Job (Col. B) matches.  Requirement is as shown in Col. G & H i.e. Building number followed by "/" and phases separated by a ","
[NAME] | A1 | 2 | 80 | 60 | 4 To be cleared |  | A1/1,2,3 | Note: 0 Closed, 1 Cleared and 2 Insp. Cleared are to be considered as CLEARED
[NAME] | A1 | 3 | 120 | 40 | 3 Insp. To be cleared |  | A1/1,2,3 | 3 Insp. To Be cleared, 4 To be Cleared and 5 Site Clearance Awtd. comes under UNCLEARED category
[NAME] | B1 | 3 | 90 | 50 | 1 Cleared | B1/3,4,5
[NAME] | B1 | 4 | 20 |  | 0 Closed | B1/3,4,5
[NAME] | B1 | 5 | 30 | 8 | 1 Cleared | B1/3,4,5
HY-03456 | A1 | 1 | 8 | 6 | 1 Cleared | A1/1,2
HY-03456 | A1 | 2 | 19 | 14 | 1 Cleared | A1/1,2
HY-03456 | A1 | 3 | 6 | 2 | 3 Insp. To be cleared |  | A1/3
HY-03456 | D1 | 2 | 4 |  | 0 Closed | D1/2
HY-03456 | D2 | 1 | 5 | 1 | 4 To be cleared |  | D2/1
Desired output Pivot:
category | job | CLEARED | UNCLEARED | Sum of Plan | Shipment Balance
0 Closed | [NAME] | B1/3,4,5 |  | 20
 | HY-03456 | D1/2 |  | 4
1 Cleared | [NAME] | B1/3,4,5 |  | 120 | 58
 | HY-03456 | A1/1,2 |  | 27 | 20
3 Insp. To be cleared | [NAME] |  | A1/1,2,3 | 120 | 40
 | HY-03456 |  | A1/3 | 6 | 2
4 To be cleared | [NAME] |  | A1/1,2,3 | 80 | 60
 | HY-03456 |  |  | 5 | 1
5 Site Clearance Awtd. | [NAME] |  | A1/1,2,3 | 25 | 5
Grand Total |  |  |  | 407 | 186
Spreadsheet: 268416d1380629191-if-a2-blank-then-copy-information-to-another-sheet-gasfilter_alkey
Sheet: Gasifier

CRAFT | ONSITE | EMPLOYEE NAMES | CRAFT | TIMESHEET | DATE
PIPEFITTERS (A-C) | 1 | ADAMS, [NAME] | MECH FMAN | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) |  | BOURGEOIS, JARED M. | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | BROOKS, [NAME] | MECH JOURNYMN A | ADAMS, DARRON LEVON
SUPPORT | 1 | BURNSIDE, DARRELL | LABR JOURNEYMAN | ADAMS, DARRON LEVON
PIPE WELDERS | 1 | GEORGE, ANTONY | BM 657B | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) |  | HAMNER, [NAME] | MW GFMAN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | LONGORIA, EDGAR | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | MORALES, ORLANDO | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | SANTOS CRUZ, [NAME] | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) |  | STEELE, HOUSTON KENNETH | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPE SUPPORT FITTER (A-C) | 1 | ALVAREZ, EMANUEL | MECH FMAN | ALVAREZ, EMANUEL
PIPE SUPPORT WELDERS | 1 | APONTE, CARLOS A DIAZ | BM WELDER | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | DEANDA, RAYMOND | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT WELDERS | 1 | DELGADO, JULIO BERRIOS | BM WELDER | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | MARTINEZ, GILBERTO | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | MELENDEZ, [NAME] | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) |  | [NAME], ALEXANDER | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | MUNOZ, RICHARD | MW GFMAN A | ALVAREZ, EMANUEL
PIPE SUPPORT WELDERS | 1 | RIVERA, SAMUEL | BM WELDER | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | RODRIGUEZ, CARLOS A. | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | SAUCEDO, [NAME] | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPEFITTERS (A-C) | 1 | ANDREWS, MILTON | MECH FMAN | ANDREWS, MILTON
PIPEFITTERS (A-C) | 1 | DANIEL, WILL | MECH [NAME] | ANDREWS, MILTON
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: williams

 | La Maquina |  | Milagro |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 334710 | 339430 | 67545 | 70147 | 44382 | 44890 | 165424 | 152641
2 | 234782 | 259819 | 87870 | 67797 | 30709 | 34191 | 121870 | 130584
3 | 326583 | 336985 | 74701 | 67075 | 39819 | 31890 | 165343 | 168246
4 | 339549 | 338460 | 42482 | 48418 | 41468 | 31612 | 144642 | 153213
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | -44637
2001-02-03 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 841150d1693394900-sum-values-if-certain-name-and-certain-month-test-55-
Sheet: Sheet1

 | [NAME] | Date | Hours Worked
 |  | 2023-06-26 00:00:00 | 8 |  |  |  |  | June | July
 |  | 2023-06-27 00:00:00 | 7 |  |  |  | [NAME] | 43 | 68
 |  | 2023-06-28 00:00:00 | 9 |  |  |  | [NAME] | 41 | 97
 |  | 2023-06-29 00:00:00 | 10
 |  | 2023-06-30 00:00:00 | 9
 |  | 2023-07-01 00:00:00 | 9
 |  | 2023-07-02 00:00:00 | 4
 |  | 2023-07-03 00:00:00 | 5
 |  | 2023-07-04 00:00:00 | 6
 |  | 2023-07-05 00:00:00 | 10
 |  | 2023-07-06 00:00:00 | 5
 |  | 2023-07-07 00:00:00 | 5
 |  | 2023-07-08 00:00:00 | 9
 |  | 2023-07-09 00:00:00 | 8
 |  | 2023-07-10 00:00:00 | 7
 | [NAME] | 2023-06-26 00:00:00 | 9
 |  | 2023-06-27 00:00:00 | 7
 |  | 2023-06-28 00:00:00 | 7
 |  | 2023-06-29 00:00:00 | 8
 |  | 2023-06-30 00:00:00 | 10
 |  | 2023-07-01 00:00:00 | 6
 |  | 2023-07-02 00:00:00 | 7
 |  | 2023-07-03 00:00:00 | 8
 |  | 2023-07-04 00:00:00 | 4
 |  | 2023-07-05 00:00:00 | 7
 |  | 2023-07-06 00:00:00 | 5
 |  | 2023-07-07 00:00:00 | 7
 |  | 2023-07-08 00:00:00 | 5
 |  | 2023-07-09 00:00:00 | 6
 |  | 2023-07-10 00:00:00 | 6
 |  | 2023-07-11 00:00:00 | 8
 |  | 2023-07-12 00:00:00 | 9
 |  | 2023-07-13 00:00:00 | 7
 |  | 2023-07-14 00:00:00 | 4
 |  | 2023-07-15 00:00:00 | 8
Spreadsheet: 488341d1478620962-keep-different-cells-in-the-same-row-after-moving-one-example
Sheet: Sheet1

Configuration before change |  |  |  |  |  |  |  | Configuration after change
2027 | 66 |  | 100000 |  |  |  | 0.03 | 2027 | 63 |  | 100000
 | 67 |  |  |  |  |  | 0.03 |  | 64
 | 68 |  |  |  |  |  | 0.03 |  | 65
 | 69 |  |  |  |  |  | 0.03 |  | 66
 | 70 |  |  | 27.4 |  |  | 0.03 |  | 67
 |  |  |  | 26.5 |  |  | 0.03 |  | 68
 |  |  |  | 25.6 |  |  | 0.03 |  | 69
 |  |  |  | 24.7 |  |  | 0.03 |  | 70 |  |  | 27.4
 |  |  |  | 23.8 |  |  | 0.03 |  | 71 |  |  | 26.5
 |  |  |  | 22.9 |  |  | 0.03 |  | 72 |  |  | 25.6
 |  |  | If numbers in column B move, need the numbers in columns E&F to move with it
 |  |  | as shown in the difference between the above before and after examples
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: April NZ

Margin and Sales by Vendor - April 2020
Vendor | Sales | Margin $ | Margin %
F5 | 1 | 1
Extreme Networks | 1 | 1
NetApp | 1 | 1
Ribbon | 1 | 1
Tenable | 1 | 1
Palo Alto Networks | 1 | 1
ForeScout | 1 | 1
Infoblox | 1 | 1
Riverbed | 1 | 1
Cylance | 1 | 1
Channel Services | 1 | 1
CS Vendors | 1 | 1
Grand Total
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 12767378 | 33255264.36
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 15000 | 44650
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 12782378 | 33299914.36
 | Purchases:
6 |  | 3rd Party / Inter Enron | -7612939 | -20225698
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -11290 | -27847.6
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 80 | 198.29
 | Total Purchases: |  | -7624149 | -20253347.31
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 9692997 | 25871132.78
12 |  | Purchases | -9692997 | -25871134.7
 | Total Intra CTS Sales / Purchases |  | 0 | -1.919999998062849
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | -5158229 | -14992482.9372805
23 | Fuel: |  | -80 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -1210108.62
31 |  | Prior Month Book Balance | 0 | 876740
 |  | Total MTM Income | 0 | -333368.62
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -619419.84
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 697272
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0 | -152498
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: jeff_dasovich__14130__FIN Exhibit C G D
Sheet: facts premium

Facts:
20 year lease
min 90% home games
3-yrs to build
est cost: | 363.5
County pd |  | (384 - 45) |  | Assumes project goes over, as most do.
Construction Duration | 30 | (7/1/97 - 12/31/99)
Monthly pymt
Discount Rate: |  | 0.0488
Discount Rate w/ premium: |  | 0.057
Residual value of stadium
 | PV 1/19 | 0.6
 | PV 7/97
Cost of Building (Expense)
 | Cost to County | 339
 | Cost of Construction 7/97
Bonds issued at DR w/ Premium
PV of future tax revenue
Face value of bonds issued
Lease Payments (Revenue)
 | 40 payments of $350,000
 | PV 3/1/99
 | PV 7/97
NPV of Investments
Spreadsheet: 680310d1590933299-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-2020-05-30-oeldere3-rezalearner-680235d1590866880-how-to-copy-every-10-rows-from-multiple-she
Sheet: sheet3

...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Spreadsheet: 147287d1332698715-how-to-extract-3-last-words-from-an-excel-cell-using-a-predefined-delimiter-nearly
Sheet: Sheet1

Tahvili | Sq | 17th | St | No | 403 | [NAME] | Fars | IR |  |  |  |  |  |  |  |  |  | [NAME] | Fars | IR
No | 31 | Jafar | Gholi | Alley | West | Nostrat | Tohid | Sq | Tehran | Tehran | IR |  |  |  |  |  |  | Tehran | Tehran | IR
22 | No | - | 2 | West | St | - | Seol | St | tehran | IR1995934733 | IR |  |  |  |  |  |  | tehran | IR1995934733 | IR
Qazi | [NAME] | Sq | No | 6 | 1st | Floor | Kashan | Isfahan | IR |  |  |  |  |  |  |  |  | Kashan | Isfahan | IR
No | 63 | Abdoos | Alley | Vaziri | St | Tehran | Tehran | IR |  |  |  |  |  |  |  |  |  | Tehran | Tehran | IR
No | 48 | [NAME] | [NAME] | Kashfi | St | Beginning | Of | [NAME] | Madani | Ave | Resalat | Sq | Tehran | IR1634957514 | IR |  |  | Tehran | IR1634957514 | IR
Faramarz | Abbasi | Sq | Baharan | St | 7th | Fajr | Alley | No | 139 | Mashhad | Khorasan | [NAME] | IR |  |  |  |  | Khorasan | [NAME] | IR
[NAME] | Blindalley | The | Fifth | St | [NAME] | Safi | Esfahan | Esfahan | IR |  |  |  |  |  |  |  |  | Esfahan | Esfahan | IR
No | 11 | East | 15 | South | Shaghayegh | Ferdows | Blvd | Sadeghieh | Sq | Tehran | IR1484983664 | IR |  |  |  |  |  | Tehran | IR1484983664 | IR
Arghavan | St | - | No | 4 | Esfahan | Esfahan | IR |  |  |  |  |  |  |  |  |  |  | Esfahan | Esfahan | IR
Unit | 2 | No | 58 | Milad | Cr | Azadshahr | Mashhad | Khorasan | [NAME] | IR |  |  |  |  |  |  |  | Khorasan | [NAME] | IR
Mehrshahr | Eram | Blvd | Milade | 4 | St | No | 58 | Karaj | Tehran | IR |  |  |  |  |  |  |  | Karaj | Tehran | IR
#48 | 2nd | Fl | Masoud | Bazar | Zand | Blvd | [NAME] | Fars | IR |  |  |  |  |  |  |  |  | [NAME] | Fars | IR
Molla | [NAME] | Ave | At | Sheikh | Bahai | Setade | Farmandehi | Sazemane | Atashneshani | Tehran | IR14358-63151 | IR |  |  |  |  |  | Tehran | IR14358-63151 | IR
[NAME] | Meidane | [NAME] | Mosavi | Ghochani | Mashhad | Khorasan | Razavai | IR |  |  |  |  |  |  |  |  |  | Khorasan | Razavai | IR
4th | Floor | [NAME] | Building | Moallem | St | Rasht | Guilan | IR |  |  |  |  |  |  |  |  |  | Rasht | Guilan | IR
No | 20 | Sadoughi | Blvd | Yazd | IR89197 | IR |  |  |  |  |  |  |  |  |  |  |  | Yazd | IR89197 | IR
Khiaban | Talaghani | [NAME] | Khiaban | Sepahbod | [NAME] | Tehran | IR1581795411 | IR |  |  |  |  |  |  |  |  |  | Tehran | IR1581795411 | IR
No | 51 | West | 188 | St | Tehranpars | Tehran | Tehran | IR |  |  |  |  |  |  |  |  |  | Tehran | Tehran | IR
No | 7 | [NAME] | Alley | Mojahedin | St | Tehran | IR11577 | IR |  |  |  |  |  |  |  |  |  | Tehran | IR11577 | IR
Tehranmunicipality(1888) | No | 59 | Ansari | Alley | Behesht | St | Parkeshahr | Tehran | Tehran | IR |  |  |  |  |  |  |  | Tehran | Tehran | IR
No | 27 | 32th | [NAME] | [NAME] | Blvd | Mashhad | Khorasan | [NAME] | IR |  |  |  |  |  |  |  |  | Khorasan | [NAME] | IR
No | 25 | Secend | Laleh | Alley | Mojahed | Kabir | Street | Laleh | Sharghi | Street | [NAME] | Abad | Tehran | Tehran | IR |  |  | Tehran | Tehran | IR
Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1209-SP

Phase | Project No. | Segment ID (GIE) | Route No. | Facility Type | Pipe O.D., in. | Segment Length, ft | Proposed [NAME] | Proposed End M.P. | Proposed total length, ft. | Proposed [NAME], in. | Segment Length per Construction Classification, ft |  |  | Bored Crossings |  | HDDs |  | Potential Re-route | Move-arounds | Comments, notes, assumptions
 |  |  |  |  |  |  |  |  |  |  | Non-cong. | Semi-cong. | High-cong. | Q-ty | Length, Feet | Q-ty | Length, Feet | Yes/No | Q-ty |  | [NAME] | MP1 | MP2 | JNTEFF | GIRTH_WELD | LONG_SEAM | JOINT_TYPE | [NAME] | W_THICK | TEST_DATE | TEST_PRESS | [NAME] | TEST_DUR | MAOP | SMYS_MAOP | MOP | SMYS_MOP | YR_INSTALL | CLASSESENT | HCA_ID | SCC_THREAT | MANU_HREAT | CONSTHREAT | OF_THREAT | HS_THREAT | Legend Name | PerSMYS | TestPer | Sub_J | Fab_Note | Threat | Seismic | Object_ID | Shape_Length
1 | 1209 | 23427 | SP3 | SP | 16 | 14 | 198.4882 | 198.4883 | 14 | 16 |  | 14 |  |  |  |  |  |  |  |  | 160.3 | 198.4882 | 198.4883 | -0.800 | ARC | SSAW | BBCR | -35000 | -0.25 |  | 0 |  | 0 | 250 | -28.5714 | 380 | -43.4286 | 1930-01-01 00:00:00 | 3 | I5 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -43.43 | 0 | N |  |  |  | 15463 | 4.360331517759077
1 | 1209 | 24481 | STUB9015 | SP | 2.375 | 10 | 0 | 0 | 10 | 2.375 |  | 10 |  |  |  |  |  |  |  |  | 101 | 0 | 0 | -0.600 | UNK | UNK | UNK | -25000 | -0.154 |  | 0 |  | 0 | 0 | 0 | -600 | -30.8442 |  | -3 | N9 |  |  |  |  |  | ManuNoTestHCA | -30.84 | 0 | N |  |  |  | 16259 | 3.048601194032341
Spreadsheet: 718b16e4-d016-4a2d-9af8-d6af6c4f0c91
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
FOGT | Test | FOGT | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
FOGT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FOGT | Result | FOGT | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6726-4 | Arrhenatherum elatius [NAME].IgE:ACnc:Pt:Ser:Qn: