tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124506d1318446410-identifying-duplicates-and-their-frequency-helpmeplz55-counts-of-counts-sample
Sheet: Sheet1

State | Value | Times Values Appears |  | Intermediate |  |  |  | Helper columns |  |  |  | Correct Results |  |  |  | Expected Results
AL | a-1 | 2
AL | a-2 | 2 |  | Count of Times Values Appears |  |  |  |  |  |  |  |  |  |  |  | State | Times Values Appears | Total
AL | a-5 | 2 |  | State | Value | Total |  | State | Value | Times Value Appears |  | Count of Times Value Appears |  |  |  | AL | 1 | 1
AL | a-2 | 2 |  | AL | a-1 | 2 |  | AL | a-1 | 2 |  | State | Times Value Appears | Total |  |  | 2 | 3
AL | a-1 | 2 |  |  | a-2 | 2 |  | AL | a-2 | 2 |  |  |  | 4 |  |  | 3 | 1
AL | [NAME] | 3 |  |  | a-3 | 1 |  | AL | a-3 | 1 |  | AL | 1 | 1 |  | MN | 1 | 2
AL | a-3 | 1 |  |  | [NAME] | 3 |  | AL | [NAME] | 3 |  |  | 2 | 3 |  |  | 2 | 1
AL | [NAME] | 3 |  |  | a-5 | 2 |  | AL | a-5 | 2 |  |  | 3 | 1 |  |  | 3 | 2
AL | [NAME] | 3 |  | AL Total |  | 10 |  |  |  |  |  | MN | 1 | 2 |  | SD | 1 | 1
AL | a-5 | 2 |  | MN | a-0 | 1 |  | MN | a-0 | 1 |  |  | 2 | 1 |  |  | 2 | 1
MN | [NAME] | 2 |  |  | a-6 | 3 |  | MN | a-6 | 3 |  |  | 3 | 2 |  |  | 3 | 1
MN | a-7 | 3 |  |  | a-7 | 3 |  | MN | a-7 | 3 |  | SD | 1 | 1 |  |  | 4 | 1
MN | [NAME] | 2 |  |  | a-8 | 1 |  | MN | a-8 | 1 |  |  | 2 | 1
MN | a-8 | 1 |  |  | [NAME] | 2 |  | MN | [NAME] | 2 |  |  | 3 | 1
MN | a-6 | 3 |  | MN Total |  | 10 |  |  |  |  |  |  | 4 | 1
MN | a-6 | 3 |  | SD | a-10 | 1 |  | SD | a-10 | 1
MN | a-6 | 3 |  |  | a-11 | 3 |  | SD | a-11 | 3
MN | a-7 | 3 |  |  | a-12 | 2 |  | SD | a-12 | 2
MN | a-7 | 3 |  |  | a-15 | 4 |  | SD | a-15 | 4
MN | a-0 | 1 |  | SD Total |  | 10
SD | a-10 | 1 |  | Grand Total |  | 30
SD | a-12 | 2
SD | a-15 | 4
SD | a-15 | 4
SD | a-11 | 3
SD | a-12 | 2
SD | a-11 | 3
SD | a-15 | 4
SD | a-15 | 4
SD | a-11 | 3
Spreadsheet: 72539d1273230497-lookup-values-in-2-different-workbooks-workbook-1
Sheet: Bracelet 4

Barcode | Code | Price | Category | Supplier
104970640001 | BC97-1 | 180 | 4 | 97
104970300002 | [NAME] | 125 | 4 | 97
104970440003 | BC97-3 | 125 | 4 | 97
104970440004 | BC97-4 | 150 | 4 | 97
Spreadsheet: 99452d1298060653-delete-n-a-row-sample1
Sheet: 4

Week | ID | Employee | Hour
4 |  | [NAME] | 40
4 |  | Chad | 20
4 |  | [NAME] | 35
4 |  | Fred | 40
Spreadsheet: 94248d1294118085-text-to-excel-excel
Sheet: Sheet1

MD-DD-030000 | XC-DD-25001 | SN1OOOO25001 | E-NZ1055111 | CORIER | VVI | N.A | 2010-04-06 00:00:00 | 12:00:15 | ARSHAD | MAHMOOD | 14131 Highway # 43 | Russellville | AL | 35653-2847 | 2563321881 | N.A | ANYTIME IN MORNING | CASH | MEDICO-Y | 6573835-SE-5004 | 36200-0EM-0001805-85001 | 37479132201 | 10350 | 3 | FIXED | 0.0082 | 2 YEARS
MD-DD-030001 | XC-DD-25002 | SN1OOOO25002 | E-NZ1055112 | CORIER | VVI | N.A | 2010-04-06 00:00:00 | 12:00:15 | KENNETH | MAHOI | 1414 10th Ave | Tuscaloosa | AL | 35401-3304 | 2052480021 | N.A | ANYTIME IN MORNING | CASH | MEDICO-Y | 6573834-SE-5005 | 36200-0EM-0001805-85002 | 37479132201 | 10350 | 3 | FIXED | 0.0082 | 2 YEARS
MD-DD-030002 | XC-DD-25003 | SN1OOOO25003 | E-NZ1055113 | CORIER | VVI | N.A | 2010-04-06 00:00:00 | 12:00:15 | PATRICIA | MAHONE | 1414 14th St | Phenix City | AL | 36867-4882 | 3342988445 | N.A | ANYTIME IN MORNING | CASH | MEDICO-Y | 6573835-SE-5005 | 36200-0EM-0001805-85003 | 37479132201 | 10350 | 3 | FIXED | 0.0082 | 2 YEARS
MD-DD-030003 | XC-DD-25004 | SN1OOOO25004 | E-NZ1055114 | CORIER | VVI | N.A | 2010-04-06 00:00:00 | 12:00:15 | [NAME] | MAHRENHOLZ | 1414 23rd Ave | Fairbanks | AK | 99701-6704 | [PHONE] | N.A | ANYTIME IN MORNING | CASH | MEDICO-Y | 6573834-SE-5006 | 36200-0EM-0001805-85004 | 37479132201 | 10350 | 3 | FIXED | 0.0082 | 2 YEARS
MD-DD-030004 | XC-DD-25005 | SN1OOOO25005 | E-NZ1055115 | CORIER | VVI | N.A | 2010-04-06 00:00:00 | 12:00:15 | [NAME] | MAIN | 1414 2nd Ave NW | Cullman | AL | 35055-1705 | 2567347443 | N.A | ANYTIME IN MORNING | CASH | MEDICO-Y | 6573835-SE-5006 | 36200-0EM-0001805-85005 | 37479132201 | 10350 | 3 | FIXED | 0.0082 | 2 YEARS
 |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 883159d1731650695-filter-function-to-display-result-next-to-each-row-person_list-no-vba
Sheet: person

PersonID | PersonName
P001 | [NAME]
P002 | [NAME]
P003 | [NAME]
P004 | [NAME]
P005 | [NAME]
P006 | [NAME]
P007 | Avery Campbell
P008 | [NAME]
P009 | Morgan Ellis
P010 | [NAME]
P011 | Dakota Jordan
P012 | [NAME]
P013 | [NAME]
P014 | [NAME]
Spreadsheet: phillip_m_love__30141__200001_OA
Sheet: TX-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -28079.64 | 2674 | 3649.9
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24596.81 | -2674 | -5971.34 | -1758 | -3850.02
7 |  | Liquidations |  |  |  |  |  |  |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3516 | 8375.17
12 |  | Purchases |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 383 | 912.59 | -383 | -912.59 | -1758 | -4185.69
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -383 | -870.56
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 383 | 870.56
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -114707 | -7384.68 | -14000 | -1154.66 |  | -33.99
25 |  | Demand
 | 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
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 738016f0-d5f0-43db-ae67-b18e343ff768
Sheet: Sheet1

Table S7. Complete phenotypic descriptions for the 14 zebrafish morphants with confirmed blood defects. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Gene | Blood Phenotype | Other Phenotypes | Vasculature in fli1:GFP fish
C12ORF2 | 90% of embryos with dramatically reduced gata1:DsRed+ blood cells. Remaining gata1:DsRed+ blood cells localized on dorsal side on yolk sack, heart beat normal. | mild head cell death, mild ventral curve in 30% | No major vascular defects
CCR7 | 90% of embryos with reduced gata1:DsRed+ blood cells with no circulation, and remaining cells pooled in tail and on yolk sack. | small head and eyes, slow heart rate | Slight reduction in intersegmental vessels, cardinal vein remodeling defect
FOXM1 | 70% of embryos with reduced gata1:DsRed+ blood cells, no circulation, most remaining cells pooled on yolk. | lethal at 4ng, 60% with head cell death at 2ng and mild pigment delay | No major vascular defects
HSPC039 | 80% of embryos with reduced gata1:DsRed+ blood cells with remaining cells pooled in tail, yolk sack, and head. | pigment delay | No major vascular defects
IRAK3 | 85% of embryos with reduced gata1:DsRed+ blood cells with normal circulation of remaining cells. | mild delay, approximately 2 hours behind at 24 hours post fertilization | Cardinal vein remodeling defects
SUZ12 | 70% of embryos with reduced gata1:DsRed+ blood cells with cells pooling in tail. | lethal at 6ng | N/D
MAFB | 70% of embryos with reduced gata1:DsRed+ blood cells with most remaining cells in tail and none circulating. | mild edema and decreased pigment | No major vascular defects
[NAME] | 80% of embryos with reduced gata1:DsRed+ blood cells with remaining cells circulating. | mild edema at 4ng | No major vascular defects
[NAME] | 70% of embryos with reduced gata1:DsRed+ blood cells. | general “sick” fish starting at 6ng | N/D
PRKCH | 70% of embryos with reduced gata1:DsRed+ blood cells with some circulating and cells pooled on yolk sack. | 40% with head cell death and small eyes | No major vascular defects
SLC40A1 | 90% of embryos with reduced gata1:DsRed+ blood cells and remaining cells only in tail. Heart beat normal, however no cells are circulating. | reduced eye and trunk pigment and ventral tail kink in 30%. | Slight reduction in intersegmental vessels and discontinuous DLAV.
SPARC | 70% of embryos with reduced gata1:DsRed+ blood cells with no circulating, and few remaining cells in tail. | less then 10% with head cell death and dorsal tail kink | No major vascular defects
SPRY4 | 85% of embryos with reduced gata1:DsRed+ blood cells with some circulation of remaining cells, and other cells pooled on yolk or posterior end of tail. | mild head cell death and weakly dorsalized at 6ng and higher | Cardinal vein remodeling defect at posterior end.
SNX5 | 80% or embryos with reduced gata1:DsRed+ blood cells with some circulation of remaining cells. | ventral curve and blocky somites at posterior end of tail | Abnormal branching of segmental vessels at dorsal end.
 |  |  | N/D = not done
Spreadsheet: 135671d1326175437-copy-and-paste-using-a-macro-macro_test
Sheet: Days

Date | Name | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Total
2012-01-10 00:00:00 | [NAME] | 1 | 2 | 7 | 8 | 1 | 2 | 5
2012-01-11 00:00:00 | Fred | 3 | 4 | 9 | 10 | 2 | 4 | 7
2012-01-12 00:00:00 | [NAME] | 5 | 6 | 11 | 12 | 3 | 6 | 9
Spreadsheet: 549162d1511477456-how-to-use-vlookup-to-sum-multi-values-in-one-column-and-lso-get-the-max-value-q-1
Sheet: Sheet1

Table 1
Serial | date | Location | Data
43063Giza | 2017-11-24 00:00:00 | [NAME] | 85 |  |  | Table 2
43063Haram | 2017-11-24 00:00:00 | Haram | 20 |  |  | Serial | Date | Location | Sum Values Of Location
43063Mohandessin | 2017-11-24 00:00:00 | Mohandessin | 45 |  |  | 43063Giza |  | [NAME] | Sum  vales here of the same location
43063Mohandessin | 2017-11-24 00:00:00 | Mohandessin | 75 |  |  | 43063Haram |  | Haram | get the [NAME]  value
43063Mohandessin | 2017-11-24 00:00:00 | Mohandessin | 89 |  |  | 43063Mohandessin |  | Mohandessin
43063Giza | 2017-11-24 00:00:00 | [NAME] | 86 |  |  | 43063Masr Gideda |  | [NAME]
43063Masr Gideda | 2017-11-24 00:00:00 | [NAME] | 445 |  |  | 43063Sherouk |  | Sherouk
43063Madinit [NAME] | 2017-11-24 00:00:00 | [NAME] | 856 |  |  | 43063Obour |  | Obour
43063Sherouk | 2017-11-24 00:00:00 | Sherouk | 85
43063Obour | 2017-11-24 00:00:00 | Obour | 969
Spreadsheet: drew_fossum__8935__Lexis Sep 2000
Sheet: Sheet1

[NAME] September, 2000 Usage (Actuals) Report
[NAME] | 2000-09-01 00:00:00 | Legal Groups Account Only
Account# | Name | Usage% | Gross $ | Approx.# [NAME] | Est. Allocation/Bill Rate $40/ Per User ID
100P01 | Moran/Fossum |  | 17948.76 | 15
103F8D | Cheek |  | 1978.32 | 13
103F7T | [NAME] |  | 5630.05 | 75
103F7Z | Hunsaker |  | 84.24 | 3
1003KQ | Place |  | 0 | 5
1057XB | PGE |  | 20708.18 | 16
103F8G | Rogers |  | 4675.5 | 13
 | [NAME] |  | 1643.72 | 1
108CKJ | EE&CC |  | 2720.03 | 4
 | ESA |  | 0 | 2
 | APACHI |  | 0 | 2
 | Azurix |  | 0 | 3
 | CALME |  | 0 | 6
107WXJ | Sharp |  | 0 | 9
100A6Q | Corp-HQ-Cooley |  | 127.17 | 1
 | ENE Global Fin |  | 0 | 1
 | Legal Library |  | 81.34 |  | 40
Legal Total: |  |  |  | [NAME] is responsible for [NAME] allocations.
Enron Total: | 376034.61 |  |  | Contact her at [PHONE] if you have any Qs.
Spreadsheet: 1b95a8d1-1da0-4bb5-a8fe-0ff665538d1f
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
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 21. Quarter measure of aggregate monthly hours worked by Industry Sector - Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  Agriculture ; |  |  | Seasonally Adjusted | A3539308V | 1984-12-01 00:00:00 | 2012-06-01 00:00:00 | 111 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Market excluding Agriculture (Rest of Market) ; |  |  | Seasonally Adjusted | A3539305L | 1984-12-01 00:00:00 | 2012-06-01 00:00:00 | 111 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Market ; |  |  | Seasonally Adjusted | A3539309W | 1984-12-01 00:00:00 | 2012-06-01 00:00:00 | 111 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Education ; |  |  | Seasonally Adjusted | A3539306R | 1984-12-01 00:00:00 | 2012-06-01 00:00:00 | 111 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Non Market excluding Education (Rest of Non Market) ; |  |  | Seasonally Adjusted | A3539307T | 1984-12-01 00:00:00 | 2012-06-01 00:00:00 | 111 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Non Market ; |  |  | Seasonally Adjusted | A3539310F | 1984-12-01 00:00:00 | 2012-06-01 00:00:00 | 111 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Total (Industry ANZSIC06) ; |  |  | Seasonally Adjusted | A3539311J | 1984-12-01 00:00:00 | 2012-06-01 00:00:00 | 111 | 000 Hours | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 74401d1274915825-collate-cash-flow-series-by-dates-mrange-explain
Sheet: Sheet2

Horizontal Data Range 1 |  |  | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 |  |  | Horizontal XIRR Figure | 0.5892155587673189
 |  |  | -2 | 3 | 3 |  |  | [NAME] | XIRR(mrange(G2:I2,G5:J5),mrange(G1:I1,G4:J4))
Horizontal Data Range 2 |  |  | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00
 |  |  | -5 | -1 | -1 | 10
Vertical Data Range 1 |  |  | Vertical Data Range 2 |  |  |  |  | Vertical XIRR Figure | 1.126331150531769
 |  |  |  |  |  |  |  | [NAME] | XIRR(mrange(C11:[NAME]:F14),mrange(B11:B13,E11:E14))
2010-02-01 00:00:00 | -2 |  | 2010-01-01 00:00:00 | -5
2010-03-01 00:00:00 | 3 |  | 2011-01-01 00:00:00 | 1
2010-04-01 00:00:00 | 3 |  | 2012-01-01 00:00:00 | 1
 |  |  | 2013-01-01 00:00:00 | 10
Combined Data Ranges 1 & 2 |  |  |  |  |  |  |  | Mixing Vertical and Horizontal XIRR Figure | 0.5892155587673189
 |  |  |  |  |  |  |  | [NAME] | XIRR(mrange(E6:H6,C11:C13),mrange(E5:H5,B11:B13))
2010-02-01 00:00:00 | -2
2010-03-01 00:00:00 | 3
2010-04-01 00:00:00 | 3
2010-01-01 00:00:00 | -5
2011-01-01 00:00:00 | 1
2012-01-01 00:00:00 | 1
2013-01-01 00:00:00 | 10
 |  |  |  |  |  |  |  | Combined Data Ranges - no MRANGE | 1.126331150531769
 |  |  |  |  |  |  |  | [NAME] | XIRR(C18:C24,B18:B24)
Spreadsheet: bb1cfceb-bf6d-4c43-8d64-25d3df65eeb1
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 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34
Figure S8A: genetic loci in C. metallidurans CH34 involved in hydrogen oxidation (hydrogenotrophy)
First gene cluster on Chromosome 1
 |  | Rmet_1280 |  |  | Rmet_1281 |  |  | Rmet_1282 |  |  | Rmet_1283 |  |  | Rmet_1284 |  |  | Rmet_1285 |  |  | Rmet_1286 |  |  | Rmet_1287 |  |  | Rmet_1288
 |  | Rmet_1289 |  |  | Rmet_1290 |  |  | Rmet_1291 |  |  | Rmet_1292 |  |  | Rmet_1293 |  |  |  | Rmet_1295 |  |  |  | Rmet_1297 |  |  | Rmet_1298 |  |  |  |  |  |  | Rmet_1301
Second gene cluster on Chromosome 1
 |  | Rmet_1506 |  |  |  |  | Rmet_1522 |  |  | Rmet_1523 |  |  | Rmet_1524 |  |  | Rmet_1525 |  |  | Rmet_1526 |  |  | Rmet_1527 |  |  |  |  | Rmet_1529 |  |  |  | Rmet_1533 |  |  | Rmet_1534
 |  | Rmet_1535 |  |  | Rmet_1536 |  |  | Rmet_1537 |  |  | Rmet_1538 |  |  | Rmet_1539 |  |  | Rmet_1540 |  |  | Rmet_1541 |  |  | Rmet_1542 |  |  |  |  | Rmet_1544
Spreadsheet: 41504d1239982116-counting-duplicates-example-for-madd
Sheet: Example

[NAME] | [NAME]
mary | mary
bob | bob
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
bob | bob
[NAME] | [NAME]
bob | bob
mary | mary
bob | bob
[NAME] | [NAME]
mary | mary 3
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME] 6
[NAME] | jon 5
bob | bob 5
Spreadsheet: mary_fischer__25623__31Y
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y
COMPANY NAME  The LINC Corp Holding Company
EQUITY INVESTEE'S SUMMARIZED INFORMATION
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 5d793d86-b3f1-4fad-aacf-9dfd6f607500
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5840 | 29433 | Fabrizio | Vignali | ITA | 0 | 00:24:53 | [NAME] | 00:47:19 | 00:00:00 | 00:14:15 | 1 | 01:27:06
5840 | 30688 | [NAME] | Smith Tri 3 | GBR | 0 | 00:26:28 | 00:00:43 | 00:52:33 | 00:00:00 | 00:14:14 | 2 | 01:34:00
5840 | 7981 | [NAME] | [NAME] | USA | 0 | 00:25:26 | 00:00:49 | 00:54:02 | 00:00:00 | 00:16:11 | 3 | 01:36:32
5840 | 42399 | [NAME] | Smyth | IRL | 0 | 00:31:01 | 00:01:09 | 01:01:49 | 00:00:00 | 00:29:51 | 4 | 02:03:53
5840 | 40953 | [NAME] | [NAME] | GBR | 0 | 00:43:03 | 00:01:24 | 01:06:59 | 00:00:00 | 00:26:25 | 5 | 02:17:54
Spreadsheet: 854920d1704686988-formula-to-solve-if-with-or-condition-and-duplicate-simulasi
Sheet: Sheet2

Given table |  | column helper |  |  |  |  |  | View | yes |  | expected pivot
Name | Facilty | Duplicate Name | View |  | Facilty | View
A | MOTOR A |  |  |  | MOTOR A | NO |  | Row Labels |  |  | view | yes
A | MOBIL A |  |  |  | MOBIL C | NO |  | B
B | MOBIL B |  |  |  | MOBIL A | YES |  | E |  |  | nama
C | MOTOR A |  |  |  | MOBIL B | YES |  | Grand Total |  |  | B
D | MOBIL B |  |  |  | MOTOR B | YES |  |  |  |  | E
D | MOTOR A |  |  |  |  |  |  |  |  |  | H
E | MOTOR B
F | MOTOR A
G | MOBIL C
G | MOTOR B
H | MOTOR B
H | MOBIL A
*1 Name can get several facilities
*Create a pivot, if you have motorbike A, car C then the name does not appear
*For example, if 1 name has motorbike facility A or car C, then it has motorbike facility B, then it will not appear
*If 1 name has several facilities other than motorbike a/car c, it will still be displayed
*1 Nama bisa [NAME] fasilitas
*Buat pivot, jika memiliki motor A, mobil c maka [NAME]
*Contoh jika 1 nama memiliki fasilitas motor a atau mobil c, lalu memiliki fasilitas motor b maka tidak tampil
*Jika 1 nama memiliki beberapa fasilitas diluar motor a/mobil c, tetap ditampilkan
Spreadsheet: 681677d1591699644-how-to-base-a-formula-on-data-selected-from-a-drop-down-box-and-linking-to-another-sheet-feeds-test-1-
Sheet: P1

 |  | Based on |  | Feed |  |  | Energy
Age | Date | Weight (kg) | Feed | Volume [NAME] (ml) | Volume del (ml) | Volume del (%) | Energy Req (kcal/kg/d) | Energy Px (kcal/kg) | Vitamin A (µg RE) | Vitamin D (µg) | Vitamin E (mg α-TE) | [NAME] (µg) | [NAME] (mg) | [NAME] (mg) | [NAME] (mg) | [NAME] (mg) | Pantothenic Acid | [NAME] (mg) | Folate (µg) | [NAME] (µg) | [NAME] (µg) | Calcium (mg) | Phosphorus (mg) | Magnesium (mg) | Iron (mg) | Zinc (mg) | Copper (mg) | Manganese (mg) | Selenium (µg) | Iodine (µg) | Molybdenum | Chromium
 | 2020-06-09 00:00:00 |  | Aptamil First 19% | 200 | 196 |  | 95 | 48 |  | 0.01672 | 0.01539 | 0.07600000000000001 | 0.1311 | 0.0007599999999999999 | 0.001672 | 0.00722 | 0.004940000000000001 | 0.0006460000000000001 | 0.1805 | 0.00266 | 0.0247 | 0.7467 | 0.5453 | 0.0684 | 0.008360000000000001 | 0.0076 | 0.0006270000000000001 | 0.000114 | 0.0247 | 0.19 | 0 | 0
Spreadsheet: 704e67d3-ccef-47d2-8664-ac7e6cf2c44f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4365 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
4365 | 14920 | [NAME] | Macmartin | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:00:00
4365 | 10336 | [NAME] | [NAME] | IRL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:00:00
Spreadsheet: 885339d1734829930-all-rows-matching-column-including-blanks-true-if-not-false-and-link-to-empty-cell-excel_validation
Sheet: Sheet2

1 | 2 | 3 | 4
777999 | A99SV1115555 | A99SV1115555 | A99SV1115555
536489 | [NAME] | [NAME] | [NAME]
1549976 | A99SV555997 | A99SV555997 | A99SV555997
33366497 | A99SV679137 |  | A99SV679137
33366497 |  | A99SV445998
22224499 | A99SV22256 | A99SV22256
Spreadsheet: 147804d1332971496-lowest-value-in-group-book2
Sheet: Data

Item | Header1 | Header2 | Header3 | Price | Group
2500 Colour ALOB Aloe Size 2XL [PHONE] | 123 | 456 | 789 | 22
1981 Colour [NAME] 2XL [PHONE] | 123 | 456 | 789 | 40
1981 Colour [NAME] L [PHONE] | 123 | 456 | 789 | 37
2500 Colour [NAME] 3XL [PHONE] | 123 | 456 | 789 | 42
2500 Colour ALOB Aloe Size L [PHONE] | 123 | 456 | 789 | 39
2500 Colour ALOB Aloe Size M [PHONE] | 123 | 456 | 789 | 39