tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58480d1258720439-advanced-formula-to-gather-data-from-one-sheet-to-another-variance-tracking-edit-copy
Sheet: Employee Search

Employee Variances
Employee:
Track Back:
Month Tracking:
Total NET:
Total ABS:
# of Variances:
Date | [NAME] |  |  |  |  |  |  |  | 2009-03-01 00:00:00
 |  |  |  |  |  |  |  | 30 | 2009-04-01 00:00:00
 |  |  |  |  |  |  |  | 60 | 2009-05-01 00:00:00
 |  |  |  |  |  |  |  | 90 | 2009-06-01 00:00:00
 |  |  |  |  |  |  |  | 180 | 2009-07-01 00:00:00
 |  |  |  |  |  |  |  | 365 | 2009-08-01 00:00:00
 |  |  |  |  |  |  |  | 730 | 2009-09-01 00:00:00
 |  |  |  |  |  |  |  | 1095 | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
Spreadsheet: 862259d1710004913-for-me-this-is-a-conundrum-same-formula-two-data-sources-and-one-not-working-test-straight-losses
Sheet: In a row

 | [NAME] |  |  |  |  |  |  |  | https://fbref.com/en/comps/9/schedule/Premier-League-Scores-and-Fixtures
 | Warning two home wins in a row | Warning two home losses in a row | Warning two home draws in a row | Warning two away wins in a row | Warning two away losses in a row | Warning two away draws in a row |  |  | Advarsel to hjemmeseire sist | Advarsel to  hjemmetap sist | Advarsel to uavgjorte hjemme | Advarsel to uavgjorte borte | Advarsel  to  borteseire sist | Advarsel to bortetap sist
[NAME]
Bournemouth
Brentford
Brighton
Burnley
Chelsea
Crystal Palace
Everton
Fulham
Liverpool
[NAME]
Manchester City
[NAME]
Newcastle Utd
Nott'ham Forest
Sheffield Utd
Tottenham
West Ham
Wolves
Spreadsheet: 941f1ee1-16c7-4347-94f2-f52de79902b4
Sheet: Table S2 - GO term enrichment

Supplemenary Table 2. Moehle et al. "The Yeast SR-like Protein Npl3 Links Chromatin Modification to mRNA processing"
GO-term analysis of npl3∆ synthetic interactions by biological process
GO term | P-value | Bonferoni Corrected P-value
RNA metabolic process | 7.02924663372e-28 | 3.16316098518e-26
chromosome organization | 4.15085721785e-18 | 1.86788574803e-16
transcription, DNA-dependent | 2.46255019032e-14 | 1.10814758564e-12
DNA metabolic process | 2.22538992074e-07 | 1.00142546433e-05
response to stress | 3.24867014536e-06 | 0.000146190156541
cell cycle | 5.40781606127e-06 | 0.000243351722757
meiosis | 3.23834848107e-05 | 0.00145725681648
nucleus organization | 0.000340890865684 | 0.0153400889558
protein modification process | 0.000343845522516 | 0.0154730485132
ribosome biogenesis | 0.00315874307467 | 0.14214343836
chromosome segregation | 0.0100301682182 | 0.451357569818
translation | 0.0126641184629 | 0.569885330828
transport | 0.0195461107991 | 0.879574985961
cytokinesis | 0.0931900145203 | 1
vesicle organization | 0.118901311241 | 1
sporulation resulting in formation of a cellular spore | 0.156448129997 | 1
signal transduction | 0.207599145126 | 1
vesicle-mediated transport | 0.258090874035 | 1
conjugation | 0.306679875484 | 1
transposition | 0.416834228383 | 1
cell budding | 0.436343679845 | 1
cellular protein catabolic process | 0.517729305482 | 1
pseudohyphal growth | 0.567602334191 | 1
cellular aromatic compound metabolic process | 0.65442825331 | 1
cellular homeostasis | 0.656610333785 | 1
cellular component morphogenesis | 0.702138739595 | 1
protein complex biogenesis | 0.761603691057 | 1
vacuole organization | 0.819966309824 | 1
fungal-type cell wall organization | 0.829967576944 | 1
peroxisome organization | 0.835593659915 | 1
other | 0.863236356787 | 1
cytoskeleton organization | 0.91722046905 | 1
cellular lipid metabolic process | 0.922879504672 | 1
cellular amino acid metabolic process | 0.933894451764 | 1
response to chemical stimulus | 0.938426540548 | 1
mitochondrion organization | 0.952453899322 | 1
cellular carbohydrate metabolic process | 0.955353645181 | 1
heterocycle metabolic process | 0.959144161708 | 1
cellular membrane organization | 0.970291172215 | 1
generation of precursor metabolites and energy | 0.995849959824 | 1
biological_process | 0.999937113448 | 1
Spreadsheet: 106932d1304082025-need-a-formula-or-macro-to-count-book1_annyfouanny-
Sheet: Sheet1

A | B |  | Name | Closed | Open
[NAME] | Closed |  | [NAME] | 1 | 1
Billy | Closed |  | Billy | 1 | 2
[NAME] | Closed |  | [NAME] | 2 | 1
[NAME] | Closed
[NAME] | Open
Billy | Open
Billy | Open
[NAME] | Open
Spreadsheet: 870420d1716934060-barclays-premier-league-best-11-for-2024-toty-23-24-premier-league-alif
Sheet: Team of the Year 23-24 (Raj)

 |  |  |  |  |  | Team of the Year 2023 - 2024
 |  |  |  |  |  |  |  |  | GK | Club
 |  |  |  |  |  |  |  | 1 | Guglielmo Vicario
 |  |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  |  | 4 | Emiliano Martínez
 |  |  |  |  |  |  |  | 5
 |  |  | RB | Club |  | RCB | Club |  |  |  |  | LCB | Club |  | LB | Club
 |  | 1 | [NAME] |  | 1 | [NAME] |  |  |  |  | 1 | [NAME] |  | 1 | Destiny [NAME]
 |  | 2 | [NAME] |  | 2 | [NAME] |  |  |  |  | 2 | [NAME] |  | 2 | [NAME]
 |  | 3 | [NAME] |  | 3 | [NAME] |  |  |  |  | 3 | [NAME] |  | 3
 |  | 4 |  |  | 4 |  |  |  |  |  | 4 |  |  | 4
 |  | 5 |  |  | 5 |  |  |  |  |  | 5 |  |  | 5
 |  |  |  |  |  |  |  |  | CM | Club
 |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  | 2 | Rodri
 |  |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  | CM | Club |  |  |  |  | CM | Club
 |  |  |  |  | 1 | [NAME] |  |  |  |  | 1 | [NAME]
 |  |  |  |  | 2 | [NAME] |  |  |  |  | 2 | [NAME]
 |  |  |  |  | 3 | [NAME] |  |  |  |  | 3 | [NAME]
 |  |  |  |  | 4 |  |  |  |  |  | 4
 |  |  |  |  | 5 |  |  |  |  |  | 5
 |  |  | RW | Club |  |  |  |  |  |  |  |  |  |  | LW | Club
 |  | 1 | [NAME] |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  | 2 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 |  | 3 | [NAME] |  |  |  |  |  |  |  |  |  |  | 3 | Alejandro Garnacho
 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME]
 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | ST | Club
 |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  | 2 | Erling Haaland
 |  |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  |  | 4
 |  | Signing of the season |  |  |  |  |  | 5
 |  |  | Player | Club
 |  | 1 | [NAME]
 |  | 2 | [NAME]
 |  | 3 | [NAME]
 |  | 4 | [NAME] |  |  | Make sure PLAYERS you have selected have transferred to their teams this season please!!!
 |  | 5 | [NAME]
 |  | Worst Signing of the season
 |  |  | Player | Club
 |  | 1 | [NAME] Onana
 |  | 2 | Moisés Caicedo
 |  | 3 | Mason Mount
 |  | 4
 |  | 5
 |  | Best player of the season
 |  |  | Player | Club
 |  | 1 | [NAME]
 |  | 2 | [NAME]
 |  | 3 | [NAME] |  |  | Can be any PLAYER
 |  | 4 | [NAME]
 |  | 5
 |  | Worst player of the season
 |  |  | Player | Club
 |  | 1 | [NAME]
 |  | 2 | Casemiro
 |  | 3 | Mykhaylo Mudryk
 |  | 4 | [NAME] Onana
 |  | 5
Spreadsheet: 745689d1630110245-pulling-data-validation-dropdown-options-from-another-sheet-not-dependent-dropdown-1706-data-validation
Sheet: Data Worksheet

Cars | Shoes | Movies | Movie Studios | Fruits | Minerals | Animals
Ford | Nike | [NAME] | Disney | Grape | Gold | Dog
Kia | [NAME] | Frozen | Universal | [NAME] | Silver | Cat
Chevy | Dockers | Avengers | Marvel | Orange | Platinum
Audi |  | LOTR |  |  | [NAME] | Horse
 |  |  |  |  |  | Hippo
Key: | Found on the "Valid Values by Field" tab |  |  |  |  |  |  |  | Fruits | Cars | Shoes | Movie Studios | Movies | Minerals
 | Not Found on the "Valid Values by Field" tab
 | Blank Cell
Data Validation Formula Starting on [NAME] (in Cell I2 currently): | =INDEX('Valid Values by Field'!$A$2:$BC$100000,MATCH(A2,INDEX('Valid Values by Field'!$A$2:$BC$100000,,MATCH(A$1,'Valid Values by Field'!$A$1:$BC$1,0)),0),MATCH(A$1,'Valid Values by Field'!$A$1:$BC$1,0))
Background: | This tool matches-up the column names (in any order, regardless if the same column appears on the "Valid Values by Field" sheet.
 | If the same column appears on both sheets, the data is validated (green indicates the data is under the same column heading on the Valid Values sheet).
Goal: | Add data validation to each cell, to allow the user to choose one of the Valid options from a dropdown.
 | Example: under Cars, Audi is not on the Valid Values list for Cars, so I need a dropdown to allow the user to select Ford, Kia, or Chevy.
 | (I'd like to avoid named ranges, if possible)
 | I've already added placeholder data validations to each cell; I just need the magic formula!
 | I've spent hours trying to get this to work, but no luck. I have included the Conditioonal Formatting formula I used in cell C19 for reference. I have a feeling the solution is a variation on the Conditional Formatting formula. I've tried CHOOSE(), but I could not get that to work, either....
Spreadsheet: benjamin_rogers__1069__Consolidated 2000 Peaker
Sheet: Wilton

INCOME STATEMENT - WILTON
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
Revenue
Merchant Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Variable Revenue
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 572 | 583.4 | 595.1 | 607 | 619.1 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - WILTON
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA
Plus Property Tax Liability
Less Property Tax Expense | -333.7
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - WILTON
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Paid-In-Capital
State Franchise Tax Rate
State Franchise Tax Liability
STATE TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 689032d1596093716-full-and-partial-matches-with-lookup-values-in-array-excelquery
Sheet: Question for a Col

Description | Expecting result
The box having - apple | Apple
Pencil is on the table | Pencil
5 box of Rubber | Rubber
cdef3840 blue color | Color
Painting brush | Brush
Office maintained | Office building
rent property | Lease building property
Use dish washer | Dishwasher
[NAME] using tomato | Tomato
vegetable Beans is good for health | Beans
printing paper | Paper
Writing ball point pen | Pen
Container box | box
Study table | Table
Spreadsheet: 328525d1403936405-formula-to-sum-by-month-and-financial-year-sum-by-mth-and-financial-year
Sheet: Sum by month and financial year

Year | SubTotal by FinYear Prod1 | SubTotal by FinYear Prod2 | SubTotal by FinYear Prod3 | SubTotal by FinYear Prod4 | Total by FinYear |  | Monthly Total by Fin. Year Across All Products | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
12/13 | 200 | 300 | 3520 | 1440 | 5460 |  |  |  |  |  |  | 1960 |  |  | 2480 |  |  | 1020
13/14 | 3137.5 | 900 | 2876 | 1935 | 8848.5 |  |  | 1116 | 3280 |  |  |  | 1450 | 425 |  | 2337.5 |  |  | 240
1. [NAME] for calculating given income for given month in financial year across all products.
2. [NAME] for calculating given income for given financial year for given product.
In | Prod1 | Prod2 | Prod3 | Prod4
2012-08-01 00:00:00 |  |  | 1760 | 720
2012-11-03 00:00:00 |  | 300 |  | 720
2012-05-05 00:00:00 | 200 |  | 1760
2013-07-02 00:00:00 |  |  |  | 425
2013-09-14 00:00:00 | 2337.5
2014-02-25 00:00:00 |  |  | 1760 | 720
2014-06-02 00:00:00 |  | 550
2014-12-25 00:00:00 |  |  |  | 240
2014-01-02 00:00:00 |  |  | 1116
2014-02-25 00:00:00 | 800
2014-06-02 00:00:00 |  | 350 |  | 550
Spreadsheet: louise_kitchen__22856__Netco Commercial4122pm
Sheet: West Power

Axford | Kathy | [NAME]
[NAME] | Jessica | [NAME]
Butler | Emily | [NAME]
Chatterton | [NAME] | [NAME]
Gustafson | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Hall | Erin | [NAME]
Hrach | April | [NAME]
Mehrer | Anna | [NAME]
Rodriguez | Grace | [NAME]
Heizenrader | [NAME] | Fundies
[NAME] | [NAME] | Fundies
[NAME] | Kourtney | Fundies
[NAME] | Julie | Fundies
Van Houten | Maria | Fundies
Swain | [NAME] | Fundies
Oh | [NAME] | Fundies
Stokley | [NAME] | Keepers
Furrow | Dale | Keepers
[NAME] | Jake | Orig
McDonald | [NAME] | Orig
Shields | [NAME] | Orig
Etringer | [NAME] | Orig
Choi | [NAME] | Orig
Rosman | [NAME] | Orig
Buerkle | [NAME] | Orig
Lackey | [NAME] | Orig
Malowney | [NAME] | Orig
Woodland | [NAME] | Orig
[NAME] | [NAME] | Orig
Wente | [NAME] | Orig
Thome | [NAME] | Orig
[NAME] | [NAME] | Real Time
[NAME] | [NAME] | Real Time
Merriss | [NAME] | Real Time
Slinger | [NAME] | Real Time
[NAME] | [NAME] | Real Time
Guzman | Mark | Real Time
Linder | [NAME] | Real Time
Meyers | [NAME] | Real Time
Presto | Darin | Real Time
[NAME] | Geir | Real Time
Mier | [NAME] | Real Time
Rawson | Les | Services
Cocke | [NAME] | Services
[NAME] | [NAME] | Services
[NAME] | Todd | Structuring
[NAME] | [NAME] | Structuring
Elafandi | Mo | Structuring
[NAME] | [NAME] | Structuring
[NAME] | Gray | Structuring
Stokley | [NAME] | Structuring
Badeer | [NAME] | Trading
Motley | [NAME] | Trading
Driscoll | [NAME] | Trading
Swerzbin | [NAME] | Trading
Belden | [NAME] | Trading
Crandall | Sean | Trading
Scholtes | [NAME] | Trading
Mallory | [NAME] | Trading
Fischer | Mark | Trading
Salisbury | Holden | Trading
[NAME] | [NAME] | Trading
Richter | [NAME] | Trading
Spreadsheet: 802287d1666772755-display-and-count-values-in-an-array-that-do-not-match-values-another-array-display_count_unmatches_v2
Sheet: Feuil1

 | UNMATCHES:
 | list |  | authorized_values
 | black |  | green
 | black |  | white
 | black |  | light
 | black |  | yellow
 | transparent |  | transparent
 | gray,white |  | gray
 | white |  | red
 | white |  | [NAME]
 | light,yellow
 | dark,gray,black
 | black
 | white
 | black
 | black
 | green
 | red
 | red,brown
Spreadsheet: 1728db2a-acd0-40fc-b531-b9cd5d4d43c5
Sheet: Sheet1

CHECKLIST FOR MUNICIPAL APPLICATION REQUIREMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
MUNICIPAL TYPE | EPA FORM 2A? | IF COMPLETING FORM 2A, DO YOU NEED THE FOLLOWING?
 |  | PART A - Basic Application Information | PART B - Add'l Application Information (expanded testing) | PART C - Certification | PART D - Priority Pollutant Analysis* | PART E - TOX       (2nd species)** | PART F - SIUs Supplement Info.
Less than 0.1MGD (minor) | No (use NC Short Form A Or Short Form D) | No | No | No | No | No | No
Greater than/equal to 0.1 MGD but less than 1.0 MGD  -- without pretreatment | Yes | Yes | Yes | Yes | No | No | No
Greater than/equal to 0.1 MGD but less than 1.0 MGD  -- with pretreatment | Yes | Yes | Yes | Yes | Yes | Yes | Yes
1.0 MGD or Greater (major)  -- without pretreatment | Yes | Yes | Yes | Yes | Yes | Yes | No
1.0 MGD or Greater (major)  -- with pretreatment | Yes | Yes | Yes | Yes | Yes | Yes | Yes
*3 samples with seasonal variation (at least 4 months separation between samples)
**4 samples with seasonal variation (for information on second species toxicity testing, call Aquatic Toxicology Unit at [PHONE]
Spreadsheet: 861922d1709749059-creating-a-scoring-system-considering-10-values-above-and-below-book1
Sheet: Sheet1

Number | Grade |  | Grade | Value |  | Number | Score
0536 | B0 |  | B0 | 0 |  | 0536
0542 | B0 |  | B1 | 0.1 |  | 0542 | 4.8
0553 | B1 |  | B2 | 0.1 |  | 0553 | 5.4
0563 | B5 |  | B3 | 0.3 |  | 0563 | 4.5
0565 | B5 |  | B4 | 0.7 |  | 0565 | 4.6
0569 | B0 |  | B5 | 1 |  | 0569 | 5.699999999999999
0574 | B5 |  |  |  |  | 0574 | 4.699999999999999
0574 | B0 |  |  |  |  | 0574 | 5.699999999999999
0576 | B0 |  |  |  |  | 0576 | 5.799999999999999
0584 | B5 |  |  |  |  | 0584 | 4.799999999999999
0585 | B4 |  |  |  |  | 0585 | 6.099999999999999
0588 | B0 |  |  |  |  | 0588 | 7.799999999999999
0605 | B4 |  |  |  |  | 0605 | 7.199999999999998
0606 | B0 |  |  |  |  | 0606 | 7.899999999999999
0608 | B2 |  |  |  |  | 0608 | 6.799999999999999
0622 | B2 |  |  |  |  | 0622 | 5.8
0641 | B0 |  |  |  |  | 0641 | 5.9
0644 | B0 |  |  |  |  | 0644 | 4.899999999999999
0665 | B2 |  |  |  |  | 0665 | 5.099999999999999
0667 | B0 |  |  |  |  | 0667 | 5.199999999999999
0673 | B5 |  |  |  |  | 0673 | 3.2
0678 | B5 |  |  |  |  | 0678 | 2.5
0678 | B1 |  |  |  |  | 0678 | 4.4
0687 | B1 |  |  |  |  | 0687 | 3.7
0688 | B0 |  |  |  |  | 0688 | 4.8
0709 | B0 |  |  |  |  | 0709 | 4.7
0710 | B0 |  |  |  |  | 0710 | 4.6
0711 | B0 |  |  |  |  | 0711 | 4.6
0724 | B3 |  |  |  |  | 0724 | 5.300000000000001
0726 | B0 |  |  |  |  | 0726 | 5.5
0734 | B0 |  |  |  |  | 0734 | 5.5
0735 | B0 |  |  |  |  | 0735 | 4.6
0736 | B5 |  |  |  |  | 0736 | 3.3
0740 | B0 |  |  |  |  | 0740 | 5.2
0741 | B5 |  |  |  |  | 0741 | 4.1
0759 | B0 |  |  |  |  | 0759 | 5.1
0760 | B0 |  |  |  |  | 0760 | 6.1
0763 | B0 |  |  |  |  | 0763 | 6.1
0769 | B5 |  |  |  |  | 0769 | 5.1
0778 | B0 |  |  |  |  | 0778 | 5.8
0781 | B0 |  |  |  |  | 0781 | 5.8
0782 | B2 |  |  |  |  | 0782 | 5.7
0782 | B4 |  |  |  |  | 0782 | 5.1
0783 | B5 |  |  |  |  | 0783 | 3.8
0788 | B0 |  |  |  |  | 0788 | 4.8
0794 | B0 |  |  |  |  | 0794 | 3.8
0802 | B5 |  |  |  |  | 0802 | 2.8
Spreadsheet: 134818d1325650139-removing-repeated-listings-book1
Sheet: Sheet2

# of days | Name
Spreadsheet: 175646d1345589671-matching-two-variables-with-output-to-a-matrix-matrixexample
Sheet: Matrix (2)

 |  | Sub Department
 |  | Payroll | Tax | Contracts | HIPAA
Department | HR | 72 | 0 | 0 | 0
 | Regulatory | 0 | 0 | 0 | 720
 | Legal | 0 | 0 | 168 | 0
 | Finance | 0 | 24 | 0 | 0
Spreadsheet: 132003d1323437266-excel-2008-need-help-adding-a-maximum-value-to-a-formula-please-help-picture-attached-book1
Sheet: Sheet1

 |  |  | TOTAL GP | 10000
 |  | GP BANDINGS | COMMISSION % | MONTH 1 | MONTH 2 | MONTH 3
 |  | £0 - £2000 | 0 | OVER 2000 | LOWER THAN 2000 | LOWER THAN 2000
 |  | £2000 - £10,000 | 0.035 | 8000
 |  | £10,000 - £25,000 | 0.05 | -2000
 |  | £25,000 - £40,000 | 0.06
 |  | £40,000 - £60,000 | 0.08
 |  | £600,00 + | 0.1
 |  |  | (SUM,E7-2000
Spreadsheet: 21217d1208441860-pivottable-fill-all-rows-pivottquestion_fill-in-all-rows
Sheet: Sheet1

From this:
 |  | Data
Company code | Source Category2 | Sum of Sales Qty TNE Adj (GLP Asia fix) | Average of Region weight
ACO | OPP | 17944.19 | 0.5
 | OBL/TPP//JV | 37197.69 | 0.5
AGH | OPP | 42866.324 | 1
 | OBL/TPP//JV | 12758.631 | 1
AGR | OPP | 2713 | 1
 | OBL/TPP//JV | 30680 | 1
AIA | OPP | 255.6 | 1
 | OBL/TPP//JV | 133125.03 | 1
Wanted result:
 |  | Data
Company code | Source Category2 | Sum of Sales Qty TNE Adj (GLP Asia fix) | Average of Region weight
ACO | OPP | 17944.19 | 0.5
ACO | OBL/TPP//JV | 37197.69 | 0.5
AGH | OPP | 42866.324 | 1
AGH | OBL/TPP//JV | 12758.631 | 1
AGR | OPP | 2713 | 1
AGR | OBL/TPP//JV | 30680 | 1
AIA | OPP | 255.6 | 1
AIA | OBL/TPP//JV | 133125.03 | 1
Where A column is filled in all rows. ( I am using the sumif function an need the codes in all rows.)
Spreadsheet: 64b36bde-9ed6-4aeb-bd81-5e14054de1fa
Sheet: Sheet1

Release: International Financial Statistics | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=239
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-09-16 11:33 PM CDT
 | Real-Time | Period
Name: | Start | End
International Financial Statistics | 2011-10-13 00:00:00 | Current
Link:
http://www.imf.org/external/data.htm | 2011-10-13 00:00:00 | Current
Source:
International Monetary Fund | 2011-10-13 00:00:00 | Current
Notes:
The International Financial Statistics (IFS) consist of approximately | 2011-10-13 00:00:00 | Current
32,000 time series covering more than 200 countries starting in 1948.
Includes exchange rates, Fund accounts and the main global and country
economic indicators.
The IMF does not make this data available to the public free of charge
on its website.  The Federal Reserve Bank of St. Louis has been given
permission by the IMF to publish a limited number of IFS time series.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-10-13 00:00:00
2012-02-08 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-06-29 00:00:00
2012-08-02 00:00:00
2012-09-04 00:00:00
2012-10-01 00:00:00
2012-11-15 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-02 00:00:00
2014-01-01 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
2014-04-01 00:00:00
2014-05-01 00:00:00
2014-06-02 00:00:00
2014-07-01 00:00:00
2014-08-01 00:00:00
2014-09-02 00:00:00
Spreadsheet: 121220d1315927555-dynamic-named-range-in-chart-dynamic-named-range
Sheet: Pay

Contractor | 2011-08-12 00:00:00 | 2011-08-19 00:00:00 | 2011-08-26 00:00:00 | 2011-09-02 00:00:00 | 2011-09-09 00:00:00 | 2011-09-16 00:00:00 | 2011-09-23 00:00:00 | 2011-09-30 00:00:00 | 2011-10-07 00:00:00 | 2011-10-14 00:00:00 | 2011-10-21 00:00:00 | 2011-10-28 00:00:00 | 2011-11-04 00:00:00 | 2011-11-11 00:00:00 | 2011-11-18 00:00:00 | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-23 00:00:00 | 2011-12-30 00:00:00 | 2012-01-06 00:00:00 | 2012-01-13 00:00:00 | 2012-01-20 00:00:00 | 2012-01-27 00:00:00 | 2012-02-03 00:00:00 | 2012-02-10 00:00:00 | 2012-02-17 00:00:00 | 2012-02-24 00:00:00 | 2012-03-02 00:00:00 | 2012-03-09 00:00:00 | 2012-03-16 00:00:00 | 2012-03-23 00:00:00 | 2012-03-30 00:00:00 | 2012-04-06 00:00:00 | 2012-04-13 00:00:00 | 2012-04-20 00:00:00 | 2012-04-27 00:00:00 | 2012-05-04 00:00:00 | 2012-05-11 00:00:00 | 2012-05-18 00:00:00 | 2012-05-25 00:00:00 | 2012-06-01 00:00:00 | 2012-06-08 00:00:00 | 2012-06-15 00:00:00 | 2012-06-22 00:00:00 | 2012-06-29 00:00:00 | 2012-07-06 00:00:00 | 2012-07-13 00:00:00 | 2012-07-20 00:00:00 | 2012-07-27 00:00:00 | 2012-08-03 00:00:00 | 2012-08-10 00:00:00