tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69548d1270076600-find-weekly-average-based-on-dynamic-date-vlookup-email-trends
Sheet: Report

 | 2010-03-28 00:00:00 |  | Week Over Week Percent Change | Trend | Correct Trends
[NAME] (column V) |  |  |  |  | 0.2316575345344253
[NAME] (column w) |  |  |  |  | 0.08326493973243357
[NAME] (column x) |  |  |  |  | -0.01229955046964454
Total Addressbook Import Succes (column y) |  |  |  |  | 0.1313636569086826
Addressbook/Reg (column z) |  |  |  |  | 0.1288874749279704
Contacts Imported (column aa) |  |  |  |  | 0.2542552291860461
Contacts Imported/Addressbook (column ab) |  |  |  |  | 0.1053349070960868
Spreadsheet: tracy_geaccone__40529__ETS - NPNG IC 10-19
Sheet: IT Development

Cost Center | Project Manager | Activity | Project Name | ETS $ Expense | ETS $ [NAME]
103152 | Ogg | DEVELOPMENT SUPPORT | Oracle Software Maintenance** | 351424.8136782113 | 0
103152 | Ogg | DEVELOPMENT SUPPORT | [NAME] renewal | 92711.416781293 | 0
103153 | S.Cleverly | INTRANET | IZZIE Maintenance* | 16203.91567464527 | 0
Totals
ETS Company |  | Desktop Counts | Percentage | Oracle | Tibco | Other* | Total Projects
Northern Plains Natural Gas |  | 119 | 0.1187624750499002
Enron Transportation Services |  | 168 | 0.1676646706586826
Northern Natural Gas |  | 368 | 0.3672654690618762
[NAME] |  | 57 | 0.05688622754491018
Citrus Corp |  | 136 | 0.1357285429141717
Enron Asset Management Resources |  | 141 | 0.1407185628742515
Enron Pipeline Services Co. |  | 13 | 0.01297405189620758
ETS Total
*Other - remaining projects broken out by desktop counts.
**Please note tht the above Oracle amount is subject to change based on renegotiation of the project.
Spreadsheet: 54196d1254225372-counting-additional-entries-on-a-linked-spreadsheet-adding-records-example
Sheet: Summary Sheet

Name | Jan | Feb | Mar | Apr | May | Totals
[NAME] | 500 | 500 | 500 | 500 | 500 | 2000
[NAME] | 0 | 0 | 1000 | 0 | 0 | 1000
Guy | 500 | 500 | 500 | 500 | 500 | 2000
[NAME] | 0 | 0 | 1000 | 0 | 0 | 1000
[NAME] | 100 | 200 | 300 | 400 | 500 | 1000
 |  |  |  |  |  | 7000
5 | UNIQUE NAME COUNT
Spreadsheet: 04596521-d3b9-4c04-83ca-181891d3cd94
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | Meal Information
TEAM
Verpflegung / Meals
Wir bieten eine vegetarische Mahlzeit und eine Mahlzeit mit [NAME] an.
We offer a vegetarian meal and a meal with meat (no pork).
 | Anzahl / number | Anzahl / number
 |  | Fleisch ([NAME]) /
 | vegetarisch / vegetarian | meat (no pork)
Thursday, 7th November
Friday, 8th November
Saturday, 9th November
Sunday, 10th November
gesamt / total | 0 | 0
Deadline 20th September 2013
Spreadsheet: 579775d1530196212-excel-sheet-reference-book1-hwall85-
Sheet: Sheet1

CH1 | CH2 | CH3
RH1 | D1 | DD1
RH2 | D2 | DD2
RH3 | D3 | DD3
RH4 | D4 | DD4
RH5 | D5 | DD5
RH6 |  | DD6
Spreadsheet: 842408d1694500616-help-with-ifs-statements-cpp-test-spreadsheet-v2
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Income | 1000 | 1200 | 900 | 1000 | 1100 | 850 | 950 | 1000 | 1150 | 1200 | 950 | 1000 |  | Tax Rate
CPP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0559
Overflow |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
YTD |  |  |  |  |  |  |  |  |  |  |  |  |  | 450
 | 1. if the SUM of the YTD is < O5 ([NAME] amount)  "do nothing"
 | 2. if the SUM of the YTD is > O5 ([NAME] amount) AND < the SUM of the YTD + the next month (only the one where it pass the $450.00 (MAX amount)
 | 3. if the SUM of the YTD is > OS ([NAME] amount) multiply MONTH INCOME by [NAME] (tax rate)
Spreadsheet: 206691d1358258285-statistical-spreadsheet-test
Sheet: more informations

CostCenter | costcenters are production areas | CostDriver (CD) | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
DD | digital direct |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
DT/DTO | digital Transfer |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
BatchCards | putting documents in sleeves |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Weeding | weeding area |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Layout | cutting the designs and match with documents |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Plott | cutting the foils with machine |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Press | press design on shirt |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Inventory | pick shirt and match to order document |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Quality Control | quality control |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Tassen/Button | [NAME] printing |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Packing&Shipping | pack and ship |  | cost drivers are prints or products, as some departments handle complete orders or we measure time per prints( print = design)
Spreadsheet: 71173d1271873891-chart-plots-blanks-and-n-a-as-zero-example
Sheet: OriginalData

 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
Station 1a |  | 32400 |  | 37100 |  | 39700 | < | 30000
Station 1b | < | 339000 |  | 48400 |  | 55400 |  | 61000
Station 2a |  | 1190 |  | 952 |  | 964 |  | 948
Station 3a | < | 336000 | < | 181000 | < | 255000 | < | 167000
Station 3b |  | 3070000000000 | < | 1560000000000 |  | 2040000000000 |  | 1610000000000
Spreadsheet: 682811d1592336212-looking-for-an-alternate-formula-that-will-not-bog-down-sample
Sheet: Sheet2

Category | Week | Count | Multibox | Item
Apples | 1 |  |  | A
Apples | 1 |  | 1 | B
Apples | 1 |  | 1 | C
Apples | 1 |  | 2 | D
Apples | 1 |  | 2 | E
Apples | 2 |  | 1 | A
Apples | 2 |  | 1 | B
Spreadsheet: john_griffith__16131__1_23_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 53 | 220 | 320 | 40.4 | 60.6 | 1.68 | 2002-01-23 13:24:00
 | [NAME] | 53 | 610 | 700 | 47.4 | 55.3 | 1.71 | 2002-01-23 13:24:00
 | HO J2 | 53 | 825 | 920 | 47.8 | 53.7 | 1.69 | 2002-01-23 13:24:00
 | HO K2 | 54 | 960 | 1060 | 45.8 | 50.5 | 1.6 | 2002-01-23 13:24:00
 | HO M2 | 54 | 1075 | 1175 | 45.6 | 49.7 | 1.59 | 2002-01-23 13:24:00
 | HO N2 | 54 | 1125 | 1225 | 42 | 45.7 | 1.49 | 2002-01-23 13:24:00
 | HO Q2 | 55 | 1225 | 1300 | 40.3 | 43.6 | 1.45 | 2002-01-23 13:24:00
 | HO U2 | 56 | 1300 | 1375 | 38.9 | 41.9 | 1.42 | 2002-01-23 13:24:00
 | [NAME] | 57 | 1300 | 1450 | 36 | 40.2 | 1.37 | 2002-01-23 13:24:00
 | HO X2 | 58 | 1375 | 1525 | 35.3 | 39.2 | 1.36 | 2002-01-23 13:24:00
 | [NAME] | 58 | 1400 | 1525 | 34.4 | 37.5 | 1.31 | 2002-01-23 13:24:00
 | HO F3 | 59 | 1425 | 1575 | 33 | 36.5 | 1.29 | 2002-01-23 13:24:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 124336d1318342037-trying-to-have-excel-autofill-based-on-a-chart-gpa-calculator-1
Sheet: GPA Calculator

Student PUID -
5 Subject Grade Calculation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A+ | 4
Count |  |  |  |  | Count |  |  |  |  | Count |  |  |  |  | Count |  |  |  |  | Count |  |  |  |  | A | 4
English 9 |  |  |  |  | Algebra |  |  |  |  | Biology |  |  |  |  | US History |  |  |  |  | Language 1 |  |  |  |  | A- | 3.7
English 10 |  |  |  |  | Geometry |  |  |  |  | Chemistry |  |  |  |  | World History |  |  |  |  | Language 2 |  |  |  |  | [NAME] | 3.3
English 11 |  |  |  |  | [NAME] |  |  |  |  | Biology 2 |  |  |  |  | Geography |  |  |  |  | Language 3 |  |  |  |  | B | 3
English 12 |  |  |  |  | [NAME] |  |  |  |  | Chemistry 2 |  |  |  |  | Gov/Econ |  |  |  |  | Language 4 |  |  |  |  | B- | 2.7
Comm |  |  |  |  | PreCalc |  |  |  |  | Physics |  |  |  |  | Psy/Soc |  |  |  |  | Language 5 |  |  |  |  | C+ | 2.3
Other |  |  |  |  | Calc |  |  |  |  | Earth/Space |  |  |  |  | Other |  |  |  |  |  |  |  |  |  | C | 2
 |  |  |  |  | Prob/Stat |  |  |  |  | Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C- | 1.7
 |  |  |  |  | Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1.3
Total = |  |  |  |  | Total = |  |  |  |  | Total = |  |  |  |  | Total = |  |  |  |  | Total = |  |  |  |  | D | 1
Sub GPA = |  |  |  |  | Sub GPA = |  |  |  |  | Sub GPA = |  |  |  |  | Sub GPA = |  |  |  |  | Sub GPA = |  |  |  |  | D- | 0.7
5 Subjuct GPA Calculation = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 0
SAT Score |  |  | Total
Spreadsheet: 239160d1369835988-question-about-addin-and-a-special-function-bfes_interest
Sheet: Discrete TS models - examples

Examples - valuing caps and callable bonds
1) Black, [NAME] and Toy |  |  |  |  |  |  |  | 2) Valuation of Interest Rate Cap
Time step | 1 | years |  |  |  |  |  | Maximum Rate |  | 0.06
Period | Yield | Volatility |  |  |  |  |  | Payoffs
1 | 0.05 | 0.12 |  |  |  |  |  | 0 | 1 | 2 | 3 | 4
2 | 0.055 | 0.13
3 | 0.057 | 0.12 |  |  |  |  |  | 0 | 7.246643143511672 | 19.41815391271577 | 27.21207904085882 | 27.8750548347405
4 | 0.059 | 0.11 |  |  |  |  |  |  | 0 | 0.02209862303682864 | 11.17257610631596 | 14.69088521400329
5 | 0.06 | 0.105 |  |  |  |  |  |  |  | 0 | 0 | 3.484777842163264
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
SPOT RATE TREE, CALCULATED USING ADD-IN FUNCTION BDTTREE |  |  |  |  |  |  |  | Now discount back, adding in payoffs each period
0 | 1 | 2 | 3 | 4 |  |  |  | 0 | 1 | 2 | 3 | 4
0.05 | 0.06724664314351167 | 0.07941815391271577 | 0.08721207904085881 | 0.08787505483474049 |  |  |  | 19.3512642752962 | 35.48128406532241 | 50.19602622877827 | 46.78780896022081 | 27.8750548347405
 | 0.05289808305988643 | 0.06002209862303683 | 0.07117257610631596 | 0.07469088521400329 |  |  |  |  | 5.156370912799614 | 10.0706252595516 | 19.65657927331012 | 14.69088521400329
 |  | 0.04536308319471945 | 0.05808295875203407 | 0.06348477784216326 |  |  |  |  |  | 0.7876408397133404 | 1.646741313305631 | 3.484777842163264
 |  |  | 0.0474007023765873 | 0.053959957846546 |  |  |  |  |  |  | 0 | 0
 |  |  |  | 0.04586417641785048 |  |  |  |  |  |  |  | 0
3) Hull and White |  |  |  |  |  |  |  | 4) Valuation of Callable Bond
Time step | 1 | years |  |  |  |  |  | Payoffs
Volatility (bp) | 0.02
Mean rev. | 0.1 |  |  |  |  |  |  | 0 | 1 | 2 | 3
Period | Yield |  |  |  |  |  |  |  |  | 5.5 | 105.5
 |  |  |  |  |  |  |  |  | 5.5 | 5.5 | 105.5
1 | 0.05 |  |  |  |  |  |  |  | 5.5 | 5.5 | 105.5
2 | 0.055 |  |  |  |  |  |  |  | 5.5 | 5.5 | 105.5
3 | 0.057 |  |  |  |  |  |  |  |  | 5.5 | 105.5
SPOT RATE TREE, CALCULATED USING ADD-IN FUNCTION HWTREE |  |  |  |  |  |  |  | Discount back (blue cells indicate calling is optimal)
Probabilities |  |  |  | 0 | 1 | 2 |  | 0 | 1 | 2 | 3
pu | pm | pd
 |  |  |  |  |  | 0.1276157498444351 |  |  |  | 93.56023983751086 | 105.5
0.1236133341876778 | 0.657610749660604 | 0.2187759161517183 |  |  | 0.09316028502219828 | 0.09463673406876177 |  |  | 93.47719699442241 | 96.37900567054496 | 105.5
0.1666666666666667 | 0.6666666666666666 | 0.1666666666666667 |  | 0.05 | 0.06018126924652496 | 0.06165771829308846 |  | 98.92708144842372 | 98.54770440607929 | 99.37289409021652 | 105.5
0.2187759161517183 | 0.657610749660604 | 0.1236133341876778 |  |  | 0.02720225347085165 | 0.02867870251741515 |  |  | 102.5725985063299 | 100 | 105.5
 |  |  |  |  |  | -0.004300313258258165 |  |  |  | 100 | 105.5
Note: This model's rates are defined as continuously compounded interest rates |  |  |  |  |  |  |  | Note: prices calculated are prices after current coupon payment,
 |  |  |  |  |  |  |  | except period 3 price which is just terminal payoff
Spreadsheet: 785367d1656360885-table-referencing-add-empty-cells-between-the-output-test
Sheet: Sheet1

 |  |  |  |  | Outcome
 |  | Name |  |  | Name
 |  | [NAME]
 |  | [NAME]
 |  | Susanna
 |  | Theodor |  |  |  |  |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Roland |  |  |  |  |  | Susanna
 |  | [NAME]
 |  |  |  |  |  |  |  | Theodor
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Roland
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 732452d1620967450-trying-to-populate-cells-in-a-specific-order-on-a-sheet-with-data-from-an-unsorted-sheet-book-1
Sheet: Weber Jr's

Weber County Team Total Points: |  |  |  |  |  |  | Weber Juniors RANK:
Weber | Test Review Ends at 1:30 pm
Test |  |  |  |  |  | Showmanship
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Horsemanship |  |  |  |  |  | Bareback Equitation on the Rail
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Barrels |  |  |  |  |  | Poles
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Time | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Keyhole |  |  |  |  |  | Portfolio
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Score | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Bonus Top 5 Total Points:
 | Weber County Team Total Points: |  |  |  |  |  | Maximum event points possible is 75                                         Maximum team points possible is 600
Spreadsheet: 35823d1233534598-sum-cells-from-rows-with-same-criteria-budget1
Sheet: Balance

DATE | ACCOUNT | BALANCE | AVAIL | T AVAIL | T BAL
2009-01-25 00:00:00 | S | 10 | 10
2009-01-25 00:00:00 | P | 15 | 35
2009-01-25 00:00:00 | H | 17.5 | 37.5 | 82.5 | 42.5
2009-02-25 00:00:00 | S | 16 | 16
2009-02-25 00:00:00 | P | 12 | 32
2009-02-25 00:00:00 | H | 19 | 39 | 87 | 47
2009-03-25 00:00:00 | S | 22 | 22
2009-03-25 00:00:00 | P | 9 | 29
2009-03-25 00:00:00 | H | 20.5 | 40.5 | 91.5 | 51.5
 | 000000 CREDIT
 | AAA
 | THREE
 | ATM
 | TALKTALK
 | ATM
Spreadsheet: 64702d1265502312-complex-calculations-competition-partisipants-and-scores-09-10
Sheet: July

July Competition - Open |  |  |  |  | 56 | Total Partisipants |  |  | 0.6904761904761906
 |  |  |  |  |  |  |  |  |  |  | Missing [NAME] email
Beginners | Image | Score | Place | Edit | 21 | 0.7142857142857143
[NAME] | His thinking face | 11 | 21 | X
[NAME] | Hawk with Prey | 11 | 20 | X
[NAME] | Reflections | 11 | 19 | X
[NAME] | Tarnished | 11 | 18 | X
[NAME] | Whooping Crane | 11 | 17 | X
[NAME] | Number One Red Porche | 11 | 16
[NAME] | The Thinker | 11 | 15 | X
[NAME] | The Kansas I Found | 12 | 14 | X
[NAME] | Akard | 13 | 13
[NAME] | Sailboats in Love | 13 | 12
[NAME] | Peaceful Way | 13 | 11
[NAME] | Mr. [NAME] | 13 | 10
[NAME] | Flowers on Lava Flat | 14 | 9 | X
[NAME] | Riding the Wind | 14 | 8 | X
[NAME] | An irish Farm | 14 | 7
[NAME] | Downtown with Flags | 14 | 6 | X
[NAME] | lets look into each others souls | 14 | 5 | X
Agnieszka Szczurowska | Power | 14 | 4 | X
[NAME] | Dancing in the Water | 14 | 3 | X
[NAME] | Monarch on Flower | 14 | 2 | X
[NAME] | In a Dream | 15 | 1 | X
Advanced | Image | Score | Place | Edit | 21 | 0.7142857142857143
[NAME] | Red Hat Hay Ride | 11 | 21 | X
[NAME] | Time Square Light Show | 11 | 20
[NAME] | The Fairest Cape | 11 | 19 | X
[NAME] | Smokin' | 11 | 18
[NAME] | Clouds on the Sand Dunes | 11 | 17 | X
[NAME] | Lieing on Lobby Floor Looking Up | 12 | 16 | X
[NAME] | Infrastructure | 12 | 15 | X
[NAME] | Venice | 12 | 14 | X
[NAME] | [NAME] | 12 | 13 | X
[NAME] | Double Take | 12 | 12 | X
[NAME] | Decent | 12 | 11
[NAME] | Idyllic Farm | 13 | 10 | X
[NAME] | Butterfly | 13 | 9 | X
[NAME] | Pigion's Roost | 13 | 8
[NAME] | Venice Church | 13 | 7
[NAME] | Color [NAME] Dallas | 14 | 6
[NAME] | Ready for Trout | 14 | 5 | X
[NAME] | Hot Air Storage | 14 | 4 | X
[NAME] | Side Saddle | 14 | 3 | X
[NAME] | KT Air Show 2009 | 14 | 2 | X
[NAME] | Intensity | 15 | 1 | X
Masters | Image | Score | Place | Edit | 14 | 0.6428571428571429
[NAME] | Fall | 10 | 14 | X
[NAME] | Pelican Fishing | 11 | 13 | X
[NAME] | Landing on White Sand | 11 | 12
[NAME] | Orchid in Pink | 11 | 11 | X
[NAME] | Denizen of the Deep | 13 | 10 | X
[NAME] | Mobilegas | 13 | 9
[NAME] | [NAME] | 13 | 8
[NAME] | Roots | 14 | 7 | X
[NAME] | Rugby-Trying to Score | 14 | 6 | X
[NAME] | Red Butte | 14 | 5 | X
Eleanore Avery | Red Crowned Crane in Snow | 14 | 4
[NAME] | Grand Tetons View | 14 | 3 | X
[NAME] | Rabbit on the Run | 14 | 2 | X
[NAME] | Merriment | 15 | 1
Spreadsheet: 52420d1252103706-summing-based-on-conditions-sumproduct-isnumber-john-bates-sdg
Sheet: Data

 | Start Date
 | End Date
 |  |  |  |  |  |  |  | AMER:Consumer Online
 |  |  |  |  |  |  |  | [NAME]:Consumer Online
 |  |  |  |  |  |  |  | APJ:Consumer Online
 |  |  |  |  |  |  |  | Consumer
 |  |  | Region:Request Segment | Visits |  |  | Visits |  |  |  | '=SUMPRODUCT(--($E$11:$E$1000),--(ISNUMBER(MATCH($D$11:$D$1000,$I$4:$I$6,0))))
 |  |  | AMER:General Content
 |  |  | AMER:Consumer Online |  |  |  |  |  |  |  | Today, 05:31 PM
 |  |  | EMEA:General Content |  |  |  |  |  |  |  | [NAME] |  | SUMPRODUCT ISNUMBER - [NAME] SDG.xlsx
 |  |  | APJ:General Content |  |  |  |  |  |  |  | Registered User   Join Date: 02 Jul 2008
 |  |  | AMER:BSDT Online |  |  |  |  |  |  |  | Location: Utah
 |  |  | [NAME]:Consumer Online |  |  |  |  |  |  |  | Posts: 77
 |  |  | APJ:Consumer Online |  |  |  |  |  |  |  | Summing Based on Conditions
 |  |  | not set:undefined |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/698380-summing-based-on-conditions.html
 |  |  | None |  |  |  |  |  |  |  | Hi,
 |  |  | APJ:BSDT Online |  |  |  |  |  |  |  | In the attached [NAME] I have two dynamic named ranges called GlobalOnline_PriorRegions and GlobalOnline_PriorVisits.
 |  |  | [NAME]:BSDT Online |  |  |  |  |  |  |  | If the values in the GlobalOnline_PriorRegions are equal to either "AMER:Consumer Online", "EMEA:Consumer Online"
 |  |  | not set:General Content |  |  |  |  |  |  |  | or "APJ:Consumer Online" then I want to sum up the relative values in GlobalOnline_PriorVisits.
 |  |  | AMER:ATG Online |  |  |  |  |  |  |  | Basically, the equation in cell $I$10 needs to sum up column E if column D is equal to any of the following values:
 |  |  | AMER:Consumer ARB Online |  |  |  |  |  |  |  | AMER:Consumer Online
 |  |  | AMER:SMB ARB Online |  |  |  |  |  |  |  | [NAME]:Consumer Online
 |  |  | AMER:ARB Online |  |  |  |  |  |  |  | APJ:Consumer Online
 |  |  | AMER:BSDR Online |  |  |  |  |  |  |  | Thanks,
 |  |  | AMER:undefined |  |  |  |  |  |  |  | [NAME]
 |  |  | :General Content
 |  |  | [NAME]:Consumer ARB Online
 |  |  | :BSDT Online
 |  |  | [NAME]:ARB Online
 |  |  | [NAME]:undefined
 |  |  | APJ:ARB Online
 |  |  | APJ:undefined
 |  |  | not set:Consumer Online
 |  |  | not set:BSDT Online
 |  |  | :Consumer Online
 |  |  | [NAME]:SMB ARB Online
 |  |  | AMER:PCA Online
 |  |  | APJ:SOHO Online
 |  |  | :undefined
 |  |  | AMER:LB Online
 |  |  | AMER:Provincial Online
 |  |  | APJ:Consumer ARB Online
 |  |  | [NAME]:ATG Online
 |  |  | APJ:ATG Online
 |  |  | APJ:SMB ARB Online
 |  |  | AMER:Global Online
 |  |  | not set:ARB Online
 |  |  | APJ:BSDR Online
 |  |  | :ATG Online
 |  |  | not set:SMB ARB Online
 |  |  | AMER:EBD Online
 |  |  | not set:Consumer ARB Online
 |  |  | EMEA:BSDR Online
Spreadsheet: 455018d1460064933-team-composition-maker-for-game-ferdyhar
Sheet: Sheet1

Example Team Selection
 | Kael'thas | [NAME] | Kharazim | Sonya | [NAME] |  | TOTAL:
BEST USER
1st
2nd
3rd
4th
5th
BEST FOR:
1st
2nd
3rd
4th
5th
Spreadsheet: 96989d1296211695-excel-2007-turn-back-2-last-flight-dates-forum-help
Sheet: PILAR JOBSHEET

2011-01-27 00:00:00 |  |  |  |  |  | Last 2 Orders for this Aircraft
 |  |  |  |  |  | 1.
 |  |  |  |  |  | 2.
GWABB |  |  |  |  | @ | 14:00:00
@ RUAG Airport |  |  |  |  | F/A
 |  |  |  |  | Invoicing
KITCHEN LEAVE TIME |  |  |  |  | DRIVER LEAVE TIME
PAX PREFERENCES
Allergies
Packaging Preferences
Food Pref
Antipasti
Starters
Main Course
Desserts
Specials
Others
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT TOUCH DOWN HERE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AIRCRAFT | Delivery Place
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ TAG Airport
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ RUAG Airport
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ Global Jet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ Private Port
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ Other - please specify
Spreadsheet: 68398d1268930978-combo-line-and-scatter-chart-722256
Sheet: Sheet1

# of Tickets | Tier 1 Capacity
153 | 248
155 | 270
132 | 293
113 | 315
93 | 338
156 | 360
124 | 383
154 | 405
127
183
167
185
115
160
185
188
189
271
301
138
140
494
Spreadsheet: 0f2afb1b-00d4-4286-af5f-c761d9c16433
Sheet: SD_LRBASELINE

Load Response Customer Baseline Report
SD_LRBASELINE_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | Asset Information |  |  | Location Information
Trading Interval | Asset ID | Asset Name | Metering Type | Location ID | Location Name | Day Ahead Cleared Schedule (Y/N) | Real Time Interruption Event (Y/N) | Actual [NAME] | [NAME]
Hour End | Number | String | String | Number | String | Flag | Flag | MWh | MWh
Spreadsheet: 96927d1296162614-taking-info-from-one-sheet-to-another-example1
Sheet: Sheet1

Rep Sheet
 | Territory 1 | Terr 2 | Terr 3
[NAME] | 12345 | 14235 | 13452
[NAME] | 13245 | 15342 | 14324
[NAME] | 14352 | 13221 | 11112
[NAME] | 12354 | 11111 | 11232
Sheet 2 (overdue clients)
 | Zip Code
Company 1 | 14235 |  | Rep 1 | <-------- | I want reps names to pop up here automatically
Company 2 | 11111 |  | Rep 2
Company 3 | 11232 |  | Rep 3
Company 4 | 13452 |  | Rep 4
Spreadsheet: 39658d1237933716-auto-populating-excel-calendar-example
Sheet: Table

Implementation Client: | Client 1 | Client 2
[NAME]: | ● | ●
KOM | 2009-03-23 00:00:00 | [NAME]
Implementation Training | 2009-03-27 00:00:00 | [NAME]
[NAME] | 2009-03-31 00:00:00 | [NAME]
[NAME] signoff | 2009-04-02 00:00:00 | [NAME]
Portal Configuration | 2009-04-15 00:00:00 | Apr 8/09
Security Audit - Acceptance |  | Apr 9 -10/09
Security Audit - Production |  | Apr 28/09
Internal Verification | 2009-04-15 00:00:00 | Apr 9 -10/09
Implementation [NAME] | 2009-04-20 00:00:00 | Apr 15/09
Client Verification of Portal Configuration | Apr-20-09 — Apr-27-09 | Apr 16-22/09
Resolution of Portal Verification Issues | Apr-28-09 — Apr-30-09 | Apr 23/09
Client Re-verification of resolved issues | May-01-09 | 2009-04-24 00:00:00
Client Configuration Verification Sign-off | May-01-09 | 2009-04-27 00:00:00
Client sign-off on Workbook Implementation Close Document. | May-01-09 | Apr 30/09
Installation of Web Service completed by Ceridian/Client | May-04-09 — May-06-09 | Apr 27/09
Final Release to Production | May-06-09 | May 6/09