tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: craig_dean__4365__1-06act
Sheet: EPEData

 | 37358.22916666666
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 43  , 77  , 34  , 83  , 38  ,1
 | NEWMAN 3 ,ECON, 77  ,100  , 35  ,103  , 24  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,MANL,166  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 283 ,  392,  155, 400 ,  61 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,604  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 52  , 52  , 52  ,104  ,  0  ,1
 | LAMBDA, 37.38,  670,  670,  156,  -16,    0,12438,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 32338d1228438488-how-to-choose-the-highest-5-numbers-from-4-different-worksheets-marvel-top-trumps
Sheet: DC #1

 | Name | Height (CM) | Intelligence | Strength | Speed | Agility | Fighting Skills
 | Dr. [NAME] | 183 | 8 | 25 | 4 | 14 | 92
 | Batman | 188 | 8 | 31 | 7 | 17 | 92
 | Batgirl | 165 | 4 | 29 | 7 | 19 | 90
 | Super Girl | 165 | 3 | 45 | 17 | 18 | 85
 | [NAME] | 168 | 6 | 42 | 16 | 16 | 82
 | Black Canary | 165 | 3 | 15 | 4 | 17 | 81
 | Fatality | 175 | 3 | 20 | 5 | 15 | 81
 | [NAME] | 171 | 5 | 15 | 4 | 12 | 81
 | [NAME] ([NAME]) | 186 | 4 | 26 | 10 | 12 | 80
 | Parallax | 183 | 4 | 30 | 11 | 13 | 80
 | [NAME] ([NAME]) | 181 | 4 | 26 | 12 | 13 | 80
 | [NAME] | 180 | 3 | 25 | 4 | 16 | 80
 | Ra's [NAME] | 188 | 7 | 24 | 4 | 14 | 80
 | The [NAME] | 183 | 4 | 27 | 20 | 25 | 79
 | Professor [NAME] | 181 | 6 | 24 | 19 | 25 | 79
 | Aquaman | 186 | 5 | 35 | 8 | 14 | 76
 | Shazam! | 191 | 7 | 48 | 17 | 18 | 71
 | [NAME] | 171 | 8 | 15 | 4 | 17 | 71
 | Firestorm | 188 | 4 | 28 | 10 | 14 | 70
 | The Joker | 196 | 5 | 22 | 4 | 12 | 70
 | The Scarecrow | 198 | 6 | 15 | 4 | 12 | 69
 | Starfire | 193 | 4 | 28 | 10 | 15 | 68
 | Ocean Master | 181 | 4 | 22 | 4 | 12 | 68
 | Black Manta | 193 | 3 | 21 | 4 | 12 | 68
 | [NAME] | 165 | 6 | 24 | 5 | 16 | 67
 | Aquagirl | 165 | 3 | 21 | 6 | 20 | 65
 | Raven | 165 | 5 | 14 | 4 | 12 | 65
 | Captain Cold | 188 | 3 | 23 | 4 | 12 | 63
 | The Penguin | 158 | 8 | 18 | 3 | 10 | 62
 | Dr. [NAME] | 168 | 7 | 10 | 3 | 10 | 55
Spreadsheet: 798369d1664448744-q-columns-to-rows-with-if-s666-pq-columns-to-rows
Sheet: Sheet1

# | SS | 1 | 2 | 3 | 4 |  |  |  | # | SS.1 | SS.2 | SS.3 | SS.4
123 | CO987098 |  |  |  |  |  |  |  | 123 | CO987098 | CO987098
123 | CO987098 |  |  |  |  |  |  |  | 456 | CO182678 | CO182678 | CO182678
456 | CO182678 |  |  |  |  |  |  |  | 789 | CO093647 | CO093647
456 | CO182678 |  |  |  |  |  |  |  | 1234 | CO820192 | CO820192
456 | CO182678 |  |  |  |  |  |  |  | 1010 | CO458290 | CO458290 | CO458290 | CO458290
789 | CO093647 |  |  |  |  |  |  |  | 2020 | CO157924 | CO157924
789 | CO093647 |  |  |  |  |  |  |  | 3030 | CO964829 | CO964829
1234 | CO820192
1234 | CO820192
1010 | CO458290
1010 | CO458290
1010 | CO458290
1010 | CO458290
2020 | CO157924
2020 | CO157924
3030 | CO964829
3030 | CO964829
Spreadsheet: 882470d1730861026-sum-hours-if-criteria-is-located-accross-multiple-rows-example
Sheet: Sheet1

 | Project | Cost Centre | Hours to date |  | Latest update | 2024-09-30 00:00:00
 | C-W00093 | W00093 |  |  | C-W00093 Big Project 1 - early works | 8.15
 | C-D00116 | D00116 |  |  | C-D00116 Big project 2 | 141.95
 | C-W00860 | W00860 |  |  | C-W00093 Big Project 1 - construction | 12.65
 | C-D00162 | [NAME] |  |  | C-W00860 Big project 3 | 0.25
 |  |  |  |  | C-D00162 Big project 4 - early works | 11
 |  |  |  |  | C-D00162 Big project 4 - construction | 17
 | Correct formula in column D to SUM hours listed in column G if 'W00093' exists in adjacent cell in column F
 | results should be:
 | Project | Cost Centre | Hours to date
 | C-W00093 | W00093
 | C-D00116 | D00116
 | C-W00860 | W00860
 | C-D00162 | [NAME]
Spreadsheet: 494097d1482172709-distributed-amount-based-on-cells-in-same-column-insurance-premium-example
Sheet: Sheet1

SSN | # of Accts | Life Amt. | FTE | Split | Life Prem | Expected Results |  | Named: [NAME]
123456789 |  | 50000 | 0.3005464480874317 |  |  | 1.28 |  | Life Amt. | Premium
123456789 |  | 50000 | 0.5 |  |  | 2.13 |  | 50000 | 4.25
123456789 |  | 50000 | 0.1994535519125683 |  |  | 0.84
12345678 |  | 50000 | 0.25 |  |  | 1.42 |  | Total Should Equal
12345678 |  | 50000 | 0.25 |  |  | 1.42 |  | =4.25*4
12345678 |  | 50000 | 0.25 |  |  | 1.41 |  | =17
1234567 |  | 50000 | 0.5 |  |  | 1.06
1234567 |  | 50000 | 0.5 |  |  | 1.06
1234567 |  | 50000 | 0.5 |  |  | 1.06
1234567 |  | 50000 | 0.5 |  |  | 1.07
123456 |  | 50000 | 1 |  |  | 4.25
Total
 |  | Actual | Expected
 | 123456789 |  | 4.25
 | 12345678 |  | 4.25
 | 1234567 |  | 4.25
 | 123456 |  | 4.25
Spreadsheet: 299051d1392992295-array-formula-for-top-10-how-to-deal-with-duplicate-values-top-10-formula-v2
Sheet: Current Month

Project Number | Project Title | Accounting Centre Code | Accounting Centre Name | Project Director [NAME] | Parent Practice Description | Group Code | Group Name | Set-Up Date | Client Name | Period Profitability | Cum. Profitability | Period PB Profit % | Cum. PB Profit % | Period Cashflow | Cum. Cashflow | Month Net Cash Total Received | Period PB Bad Debts | Cum. [NAME] | Period Total Invd Excl. Tax | Cum. Total [NAME]. Tax | Work Outstanding | Work In Progress | Financial % Complete | 0-30 days Total Excl. Tax | 31-60 days Total Excl. Tax | 61-90 days Total Excl. Tax | 91-120 days Total Excl. Tax | 121-150 days Total Excl. Tax | 151-183 days Total Excl. Tax | Over 6 Months Total Excl. Tax | Total Debts Excl. Tax | Fcst. Total Income | Fcst Income Previous Month | Mvmt | Increase | SR | SR + PP | X?
23096400 | PADDINGTON NEW YARD | 1212 | Trans. & Civil Eng. NW & Yorks | [NAME] | Infrastructure | GD16 | Infrastructure NW & Yorkshire | 41429 | NETWORK RAIL | 8593.22 | 8593.22 | 6 | 6 | 25271.92 | 25271.92 | 0 | 0 | 0 | 143249.8 | 143249.8 | 206743.39 | -1059.19 | 40.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 348934 | 148934 | 200000 | Increase | NW & Yorkshire | Infrastructure NW & Yorkshire
23413600 | CP - MOBILISATION PHASE | 1123 | Economics & Planning South | [NAME] | Consulting | GD41 | Consulting Planning South | 41620 | TO FOLLOW | 2869.5 | 2869.5 | 4.5 | 4.5 | 52007.15 | 52007.15 | 110000 | 0 | 0 | 161105 | 161105 | 136640 | -97745 | 31.68 | 51105 | 0 | 0 | 0 | 0 | 0 | 0 | 51105 | 200000 | 0 | 200000 | Increase | Planning South | Consulting Planning South
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -677 | -581
2 |  |  |  |  |  |  |  |  |  |  | -928 | -581
3 |  |  |  |  |  |  |  |  |  |  | -911 | -581
4 |  |  |  |  |  |  |  |  |  |  | -981 | -581
5 |  |  |  |  |  |  |  |  |  |  | -658 | -581
6 |  |  |  |  |  |  |  |  |  |  | -805 | -581
7 |  |  |  |  |  |  |  |  |  |  | -709 | -581
8 |  |  |  |  |  |  |  |  |  |  | -828 | -581
9 |  |  |  |  |  |  |  |  |  |  | -884 | -581
10 |  |  |  |  |  |  |  |  |  |  | -856 | -581
11 |  |  |  |  |  |  |  |  |  |  | -595 | -581
12 |  |  |  |  |  |  |  |  |  |  | -581 | -581
13 |  |  |  |  |  |  |  |  |  |  | -639 | -778
14 |  |  |  |  |  |  |  |  |  |  | -677 | -778
15 |  |  |  |  |  |  |  |  |  |  | -865 | -778
16 |  |  |  |  |  |  |  |  |  |  | -591 | -778
17 |  |  |  |  |  |  |  |  |  |  | -988 | -778
18 |  |  |  |  |  |  |  |  |  |  | -803 | -778
19 |  |  |  |  |  |  |  |  |  |  | -882 | -778
20 |  |  |  |  |  |  |  |  |  |  | -768 | -778
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 31688.49
2002-01-20 00:00:00
CBS Volume
 |  |  | 11681
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: JULY 11

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-07-11 00:00:00 | 2011-07-12 00:00:00 | 2011-07-13 00:00:00 | 2011-07-14 00:00:00 | 2011-07-15 00:00:00 | 2011-07-16 00:00:00
[NAME] |  | 8:30-5:30 | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 | off | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 38
[NAME] | 8:30-5:30 | 9:30-5:30 |  | 9:30-5:30 | 8:30-5:30 | 9:15-5:15
 | 2:00-3:00 | 2:00-3:00 | off | 2:00-3:00 | 2:00-3:00 | n/l | 38
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | off | 9:00-5:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 1:00-2:00 | 38
Mark | 8:30-5:30 | 9:00-5:00 | 8:30-5:30 | 8:30-5:30 | 8:00-4:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 38
[NAME] | 8:00-4:00 | 8:30-5:30 | 8:30-5:30 | 7:00-4:00-HOMER | 9:30-5:30-counter
ctr 12-2 | 11:00-12:00 | 11:00-12:00 | 11:00-12:00 | 12:00-1:00 | 11:00-12:00 |  | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00 | 15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours | 205
Spreadsheet: rick_buy__32939__money market wksht _2
Sheet: Sheet1

a/o 01/22/02
Product |  | Class | Yield
AIM Institutional - Short Term Investments |  | Cash Mgmt. | 0.0164
(STIC Prime) - Primary Investments |  | Resource | 0.0156
Taxable |  | Private | 0.0142
AIM Institutional - Short Term Investment Trust |  | Cash Mgmt. | 0.0188
(STIC Liquid) - Treasury Portfolio |  | Resource | 0.0176
Taxable |  | Private | 0.0166
AIM Institutional - Short Term Investment Trust |  | Cash Mgmt. | 0.0184
(STIT Treasury) |  | Resource | 0.0176
Taxable |  | Private | 0.0162
ARPS - 7 Day - Taxable |  |  | 0.0175
- 28 Day - Taxable |  |  | n/a
AIM Institutional - Cash Reserve Portfolio |  | Cash Mgmt | 0.0122
Tax Free Investments Co. - Cash Reserve |  | Resource | 0.0114
Short Term Municipal |  | Private | 0.0105
ARPS - 7 Day - Tax Free |  |  | 1.0-1.30%
- 28 Day - Tax Free |  |  | n/a
Treasuries - Yield |  |  | 0.0546
Spreadsheet: 91531d1291232373-excel-2007-excel-formula-comparing-2-sheets-excel-sheet-help-1
Sheet: % Complete

 | DH Coordinator
REGION 1
Bay
[NAME]
Escambia
Gulf
[NAME]
[NAME]
Okaloosa
Santa Rosa
[NAME]
Washington
Percent Complete
REGION 2
Columbia
Dixie
Franklin
[NAME]
[NAME]
[NAME]
Lafayette
[NAME]
Liberty
[NAME]
[NAME]
[NAME]
Wakulla
Percent Complete
REGION 3
Alachua
[NAME]
Bradford
Clay
Duval
Flagler
Gilchrist
[NAME]
Marion
Nassau
Putnam
[NAME]
Union
Percent Complete
REGION 4
Citrus
Hardee
Hernando
Hillsborough
Pasco
Pinellas
Polk
Sumter
Percent Complete
REGION 5
Brevard
Indian River
Lake
Martin
Orange
Osceola
Seminole
St Lucie
Volusia
Percent Complete
REGION 6
Charlotte
Collier
DeSoto
Glades
Hendry
Highlands
[NAME]
Manatee
Okeechobee
Sarasota
[NAME]
Percent Complete
REGION 7
Broward
Miami-Dade
Monroe
Palm Beach
Percent Complete
Progress
Spreadsheet: 143718d1330536887-excel-2008-cells-with-external-references-not-updating-contract_fishsc_template
Sheet: IncomingData

SupplierName | SupplierPhone | ContractID | PreviousContractID | ContractStart | ContractEnd | ContractEventType | SupplierContactName | SupplierContactEmail | CustomerName | CustomerAddress | CustomerAddress2 | CustomerCity | CustomerState | CustomerZip | FisherAccountNbr | FisherCatalogNbr | VendorCatalogNbr | ProductDesc | UOM | QtyPerUOM | SuggEndUserPrice | GuarMargin | GuarCost | DateItemAdded
Spreadsheet: 82802d1282823927-ip-subnet-finder-subnetlocator
Sheet: Sheet2

Destination | Firewall-Name-Iface
127.0.0.0 | X80-nn-oss-lo3
10.103.51.0 | X80-nn-oss-pe.220
10.104.250.184 | X80-nn-oss-pe.220
10.102.251.31 | X80-nn-oss-pe.221
10.102.252.0 | X80-nn-oss-pe.221
10.103.103.0 | X80-nn-oss-pe.221
10.103.129.0 | X80-nn-oss-pe.221
10.103.14.0 | X80-nn-oss-pe.221
10.103.222.0 | X80-nn-oss-pe.221
10.103.46.0 | X80-nn-oss-pe.221
10.103.71.0 | X80-nn-oss-pe.221
10.104.250.192 | X80-nn-oss-pe.221
10.147.0.128 | X80-nn-oss-pe.221
10.147.11.0 | X80-nn-oss-pe.221
10.147.13.0 | X80-nn-oss-pe.221
10.147.15.0 | X80-nn-oss-pe.221
10.147.5.0 | X80-nn-oss-pe.221
10.147.9.0 | X80-nn-oss-pe.221
10.104.250.200 | X80-nn-oss-pe.222
10.102.254.0 | X80-nn-oss-pe.223
10.103.108.0 | X80-nn-oss-pe.223
10.103.130.0 | X80-nn-oss-pe.223
10.103.170.0 | X80-nn-oss-pe.223
10.103.18.0 | X80-nn-oss-pe.223
10.103.220.0 | X80-nn-oss-pe.223
10.103.223.0 | X80-nn-oss-pe.223
10.103.239.0 | X80-nn-oss-pe.223
10.103.255.0 | X80-nn-oss-pe.223
10.103.50.0 | X80-nn-oss-pe.223
10.103.53.0 | X80-nn-oss-pe.223
10.103.75.0 | X80-nn-oss-pe.223
10.104.250.208 | X80-nn-oss-pe.223
10.103.221.0 | X80-nn-oss-pe.224
10.103.55.0 | X80-nn-oss-pe.224
10.104.250.216 | X80-nn-oss-pe.224
10.144.128.0 | X80-nn-oss-pe.224
10.102.228.0 | X80-nn-oss-pe.225
10.103.19.0 | X80-nn-oss-pe.225
10.103.221.64 | X80-nn-oss-pe.225
10.103.56.0 | X80-nn-oss-pe.225
10.104.251.16 | X80-nn-oss-pe.225
10.103.57.0 | X80-nn-oss-pe.227
10.104.251.216 | X80-nn-oss-pe.227
10.98.25.0 | X80-nn-oss-pe.227
10.98.33.0 | X80-nn-oss-pe.227
10.98.37.0 | X80-nn-oss-pe.227
10.98.44.0 | X80-nn-oss-pe.227
10.98.45.0 | X80-nn-oss-pe.227
10.98.64.0 | X80-nn-oss-pe.227
10.99.0.0 | X80-nn-oss-pe.227
10.104.194.112 | X80-nn-oss-pe.229
10.99.81.0 | X80-nn-oss-pe.229
10.99.90.0 | X80-nn-oss-pe.229
10.99.91.0 | X80-nn-oss-pe.229
10.104.247.0 | X80-nn-oss-pe.235
10.98.20.0 | X80-nn-oss-pe.235
10.104.194.136 | X80-nn-oss-pe.251
10.156.65.0 | X80-nn-oss-pe.251
10.146.128.0 | X80-nn-oss-pe.355
10.146.129.0 | X80-nn-oss-pe.355
10.104.194.32 | X80-nn-oss-pe.525
10.114.255.0 | X80-nn-oss-pe.525
10.104.194.40 | X80-nn-oss-pe.526
10.114.13.0 | X80-nn-oss-pe.526
10.114.14.0 | X80-nn-oss-pe.526
10.114.15.160 | X80-nn-oss-pe.526
10.114.15.224 | X80-nn-oss-pe.526
10.114.15.32 | X80-nn-oss-pe.526
10.114.15.96 | X80-nn-oss-pe.526
10.114.16.128 | X80-nn-oss-pe.526
10.114.16.160 | X80-nn-oss-pe.526
10.114.16.32 | X80-nn-oss-pe.526
10.114.16.64 | X80-nn-oss-pe.526
10.114.19.160 | X80-nn-oss-pe.526
10.114.19.224 | X80-nn-oss-pe.526
10.114.19.32 | X80-nn-oss-pe.526
10.114.19.96 | X80-nn-oss-pe.526
10.114.20.0 | X80-nn-oss-pe.526
10.114.24.16 | X80-nn-oss-pe.526
10.114.6.0 | X80-nn-oss-pe.526
10.114.6.64 | X80-nn-oss-pe.526
10.104.194.48 | X80-nn-oss-pe.527
10.93.128.0 | X80-nn-oss-pe.527
10.94.0.0 | X80-nn-oss-pe.527
10.95.0.0 | X80-nn-oss-pe.527
10.104.194.56 | X80-nn-oss-pe.528
10.104.194.64 | X80-nn-oss-pe.529
10.104.194.128 | X80-nn-oss-pe.551
10.145.5.128 | X80-nn-oss-pe.551
10.144.0.0 | X80-nn-oss-pe.970
10.144.7.32 | X80-nn-oss-pe.970
10.144.6.0 | X80-nn-oss-pe.973
10.144.7.56 | X80-nn-oss-pe.973
Spreadsheet: 846960d1698086635-stuck-with-match-function-match-data_new
Sheet: Φύλλο1

 |  |  |  | ONE |  |  | TWO |  |  | THREE |  |  | FOUR
 |  | STATUS | 1 | X | 2 | 1 | X | 2 | 1 | X | 2 | 1 | X | 2
 |  | TWO | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426 | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426 | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426 | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426
 |  | FOUR | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612 | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612 | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612 | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612
 |  | THREE | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732 | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732 | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732 | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732
 |  | ONE | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747 | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747 | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747 | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747
 |  |  | X
 |  |  | 2
 |  |  | 1
 |  |  | 1
 |  |  | 0.301602 |  |  | In cell [NAME] I need a formula to do this( look at C7 , it says TWO , then go to the TWO SECTION which is g6:i6 and match the d14 to the proper cell of the TWO SECTION. In my example is 0,301602)
 |  |  | 0.238021
 |  |  | 0.330554
 |  |  | 0.517604
Spreadsheet: 92744d1292307101-iteration-continuously-increases-before
Sheet: Week3

Week | Day | Date | Winner/tie | PtsW |  | [NAME]/tie | PtsL
3 | Sun | 2010-09-26 00:00:00 | Kansas City Chiefs | 31 |  | San Francisco 49ers | 10
3 | Sun | 2010-09-26 00:00:00 | Minnesota Vikings | 24 |  | Detroit Lions | 10
3 | Sun | 2010-09-26 00:00:00 | Tennessee Titans | 29 | @ | New York Giants | 10
3 | Sun | 2010-09-26 00:00:00 | Cincinnati Bengals | 20 | @ | Carolina Panthers | 7
3 | Sun | 2010-09-26 00:00:00 | Indianapolis Colts | 27 | @ | Denver Broncos | 13
3 | Sun | 2010-09-26 00:00:00 | Atlanta Falcons | 27 | @ | New Orleans Saints | 24
3 | Sun | 2010-09-26 00:00:00 | Arizona Cardinals | 24 |  | Oakland Raiders | 23
3 | Sun | 2010-09-26 00:00:00 | Dallas Cowboys | 27 | @ | Houston Texans | 13
3 | Sun | 2010-09-26 00:00:00 | Pittsburgh Steelers | 38 | @ | Tampa Bay Buccaneers | 13
3 | Sun | 2010-09-26 00:00:00 | Baltimore Ravens | 24 |  | [NAME] | 17
3 | Sun | 2010-09-26 00:00:00 | New York Jets | 31 | @ | [NAME] | 23
3 | Sun | 2010-09-26 00:00:00 | New England Patriots | 38 |  | Buffalo Bills | 30
3 | Sun | 2010-09-26 00:00:00 | [NAME] | 27 |  | San Diego Chargers | 20
3 | Sun | 2010-09-26 00:00:00 | Philadelphia Eagles | 28 | @ | [NAME] | 3
3 | Sun | 2010-09-26 00:00:00 | St. Louis Rams | 30 |  | Washington Redskins | 16
3 | Mon | 2010-09-27 00:00:00 | Chicago Bears | 20 |  | Green Bay Packers | 17
Spreadsheet: f7e4b931-3e65-46f9-9996-79d05af4fe14
Sheet: Rev Mix by Distribution

[NAME], INC. AND SUBSIDIARIES
FINANCIAL INFORMATION
(Amounts in millions)
 |  | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1
 |  | CY08 | CY09 | CY09 | CY09 | CY09 | CY10 | CY10 | CY10 | CY10 | CY11 | CY11 | CY11 | CY11 | CY12
 | GAAP Net Revenues by Distribution Channel
 | Retail channels | 1151 | 596 | 676 | 351 | 1000 | 906 | 584 | 320 | 820 | 946 | 660 | 250 | 841 | 793
 | Digital online channels* | 316 | 300 | 299 | 298 | 336 | 331 | 332 | 363 | 414 | 428 | 423 | 427 | 363 | 314
 | Total Activision and [NAME]
 | Distribution | 171 | 85 | 63 | 54 | 221 | 71 | 51 | 62 | 193 | 75 | 63 | 77 | 203 | 65
 | Total consolidated GAAP net revenues
 | Change in Deferred Net Revenues (1)
 | Retail channels
 | Digital online channels*
 | Total changes in deferred net revenues
 | Non-GAAP Net Revenues by Distribution Channel
 | Retail channels | 1851 | 325 | 432 | 388 | 1933 |  |  | 432 |  | 240 | 212 | 164 | 1896 | 224
 | Digital online channels* | 321 | 314 | 306 | 313 | 341 |  |  | 363 |  | 440 | 424 | 386 | 309 | 298
 | Total Activision and [NAME]
 | Distribution | 171 | 85 | 63 | 54 | 221 | 71 | 51 | 62 | 193 | 75 | 63 | 77 | 203 | 65
 | Total non-GAAP net revenues (2)
 | (1) We provide net revenues including (in accordance with GAAP) and excluding (non-GAAP) the impact of changes in deferred net revenues.
 | (2) Total non-GAAP net revenues presented also represents our total operating segment net revenues.
 | * Net revenues from digital online channel represent revenues from subscriptions and memberships, licensing royalties, value-added services, downloadable content, digitally distributed products, and wireless
 | devices.
Spreadsheet: 743090d1628200066-multiple-data-for-stock-portfolio-x12
Sheet: Database

Z-CATEGORY |  | PORTFOLIO | CONFLUENCE | [NAME] | LT-SWING | REVERSE | SPE-CON | 3x3DMA | WATCH | Opt. Move
BDWELDING |  | ACFL | [NAME] | AAMRANET |  | INTRACO | SAIFPOWER | AFCAGRO |  | AAMRATECH
ALLTEX |  | ACI | MJLBD | AAMRATECH |  | SONALIANSH | SSSTEEL | RAHIMAFOOD |  | BANGAS
ARAMITCEM |  | AGNISYSL | AMBEEPHA | ACI |  | BEXIMCO | FUWANGCER | CENTRALPHL |  | CVOPRL
BEACHHATCH |  | AZIZPIPES | EPGL | [NAME] |  | NFML | ORIONPHARM | BEACONPHAR |  | FINEFOODS
BIFC |  | BARKAPOWER |  | AMBEEPHA |  | JMISMDL | AGNISYSL | SONALIPAPR |  | GHAIL
BXSYNTH |  | BBS |  | APOLOISPAT |  | IBNSINA | ISLAMIINS | PEOPLESINS |  | HEIDELBCEM
DACCADYE |  | BPPL |  | BSC |  | QUEENSOUTH | PREMIERCEM | FARCHEM |  | MEGHNACEM
DULAMIACOT |  | CENTRALPHL |  | BSRMSTEEL |  | ARGONDENIM | EPGL | GPHISPAT |  | [NAME] | g
BDSERVICE |  | DESHBANDHU |  | CONFIDCEM |  | SHEPHERD |  | METROSPIN |  | DOREENPWR
CNATEX |  | EMERALDOIL |  | EGEN |  | SHASHADNIM |  | COPPERTECH |  | JAMUNAOIL
EMERALDOIL |  | FEDERALINS |  | EXIMBANK |  | TOSRIFA |  | TAUFIKA |  | POWERGRID | 6
FAMILYTEX |  | FORTUNE |  | INDEXAGRO |  |  |  | INDEXAGRO |  | PREMIERCEM
FAREASTFIN |  | GHAIL |  | ITC |  |  |  | DESHBANDHU |  | [NAME]
FIRSTFIN |  | GPHISPAT |  | KOHINOOR |  |  |  | ARAMITCEM |  | UPGDCL
GENNEXT |  | IFADAUTOS |  | MIRAKHTER |  |  |  | GHCL |  | ZEALBANGLA
ICBIBANK |  | INTRACO |  | MJLBD |  |  |  | GHAIL
IMAMBUTTON |  | ISLAMIINS |  | SALVOCHEM |  |  |  | FEKDIL
JUTESPINN |  | KEYACOSMET |  | [NAME] |  |  |  | FUWANGCER
MEGCONMILK |  | LIBRAINFU |  | SHAHJABANK |  |  |  | KBPPWBIL
MEGHNAPET |  | METROSPIN |  | SONALIPAPR |  |  |  | PDL
MITHUNKNIT |  | MIRACLEIND |  | SSSTEEL |  |  |  | SALAMCRST
PADMALIFE |  | NCCBANK |  | TAKAFULINS |  |  |  | QUASEMIND
PLFSL |  | NFML |  |  |  |  |  | [NAME]
RNSPIN |  | NRBCBANK |  |  |  |  |  | ANWARGALV
SAVAREFR |  | OAL |  |  |  |  |  | WMSHIPYARD
SHYAMPSUG |  | PAPERPROC |  |  |  |  |  | RSRMSTEEL
SUNLIFEINS |  | RINGSHINE |  |  |  |  |  | SALVOCHEM
TALLUSPIN |  | RNSPIN |  |  |  |  |  | SILVAPHL
TUNGHAI |  | SAIFPOWER |  |  |  |  |  | GENNEXT
USMANIAGL |  | SANDHANINS |  |  |  |  |  | DOMINAGE
ZEALBANGLA |  | SONALILIFE
ZEALBANGLA |  | STANDBANKL
Spreadsheet: 809290d1671010387-find-and-show-the-last-value-from-a-row-examplefile
Sheet: Sheet1

test | testheader 2 | [NAME] testeheader 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here find last info
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME]
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] | [NAME] 8 | [NAME] 9
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] | [NAME] 8 | [NAME] 9 | [NAME] 10
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: ma

McKenzie. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 221587d1363617638-conditional-drop-down-list-book1
Sheet: Edit

First Name | Middle Name | Surname | Username | Office | Department | Job Title
Nosmo |  | King |  | London | Accounts | Managing Director
Mya | Breath | Reeks |  | Tokyo | Foreign Exchange | Call Analyist