tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 91113d1290791236-find-text-in-several-tables-and-sum-values-calculations
Sheet: DATA INPUT

 | MONDAY |  |  |  |  | TUESDAY |  |  |  |  | WEDNESDAY |  |  |  |  | THURSDAY |  |  |  |  | FRIDAY |  |  |  |  | SATURDAY |  |  |  |  | SUNDAY
 | PRODUCT 1 |  |  |  |  | PRODUCT 1 |  |  |  |  | PRODUCT 1 |  |  |  |  | PRODUCT 1 |  |  |  |  | PRODUCT 1 |  |  |  |  | PRODUCT 1 |  |  |  |  | PRODUCT 1
 | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required
 | AAA | FGDJF | 2000 |  |  | DDD | RYDJRYJ | 20000
 | BBB | ERYWE | 150 |  |  | AAA | FGDJF | 50000
 | CCC | ERYWYJH | 3000 |  |  | CCC | ERYWYJH | 10000
 | PRODUCT 2 |  |  |  |  | PRODUCT 2 |  |  |  |  | PRODUCT 2 |  |  |  |  | PRODUCT 2 |  |  |  |  | PRODUCT 2 |  |  |  |  | PRODUCT 2 |  |  |  |  | PRODUCT 2
 | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required
 |  |  |  |  |  |  |  |  |  |  | HHH | RTHRT | 1500
 |  |  |  |  |  |  |  |  |  |  | DDD | RYDJRYJ | 35000
 | PRODUCT 3 |  |  |  |  | PRODUCT 3 |  |  |  |  | PRODUCT 3 |  |  |  |  | PRODUCT 3 |  |  |  |  | PRODUCT 3 |  |  |  |  | PRODUCT 3 |  |  |  |  | PRODUCT 3
 | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required
 | PRODUCT 4 |  |  |  |  | PRODUCT 4 |  |  |  |  | PRODUCT 4 |  |  |  |  | PRODUCT 4 |  |  |  |  | PRODUCT 4 |  |  |  |  | PRODUCT 4 |  |  |  |  | PRODUCT 4
 | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required
 | PRODUCT 5 |  |  |  |  | PRODUCT 5 |  |  |  |  | PRODUCT 5 |  |  |  |  | PRODUCT 5 |  |  |  |  | PRODUCT 5 |  |  |  |  | PRODUCT 5 |  |  |  |  | PRODUCT 5
 | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required
 | PRODUCT 6 |  |  |  |  | PRODUCT 6 |  |  |  |  | PRODUCT 6 |  |  |  |  | PRODUCT 6 |  |  |  |  | PRODUCT 6 |  |  |  |  | PRODUCT 6 |  |  |  |  | PRODUCT 6
 | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required |  |  | Code | Item | Quantity required
Spreadsheet: 87622d1287504493-duplicate-values-and-extracting-unique-data-within-the-dup-value-dup-values-and-retrieving-unique-results
Sheet: Sheet1

Name | Fruit | Fruit (Concatenated) | Results Sought
[NAME] | Apple | Apple
[NAME] | Apple | Apple, Apple | Apple, Apple
[NAME] | Grape | Grape | Grape
[NAME] | Orange | Orange
[NAME] | Orange | Orange, Orange | Orange, Orange
[NAME] | [NAME] | [NAME]
[NAME] | Bananna | Bananna,Orange, Orange | Bananna, Orange, Orange
[NAME] | Pinapple | Pinapple
[NAME] | [NAME] | Pinapple, [NAME] | Pinapple, [NAME]
[NAME] | Kiwi | Kiwi
[NAME] | Kiwi | Kiwi, Kiwi | Kiwi, Kiwi
[NAME] | Mango | Mango | Mango
[NAME] | Watermelon | Watermelon | Watermelon
[NAME] | Peach | Peach | Peach
Spreadsheet: 784613d1655859210-in-lieu-of-filtering-pivot-tables-what-formula-can-replicate-filtering-car2
Sheet: Sheet1 (2)

Name | Ford | Chevy | Honda | Nissan | Kia
[NAME] | Y
Fred | Y | Y | Y | Y | Y
[NAME] |  |  | Y |  | Y
[NAME] | Y
Kelly |  |  | Y
Candace | Y
Individuals Who Only Have A Ford
1
2
3
4
5
6
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: QTD Recon Q4FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended March 31, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Strategic Investments |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 979 |  | 0 |  | -129 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 850
Cost of goods sold | 298 |  | -2 |  | 0 |  | 0 |  | 1 |  | 0 |  | -1 |  | 0 |  | 296
Gross profit | 681 |  | 2 |  | -129 |  | 0 |  | -1 |  | 0 |  | 1 |  | 0 |  | 554
Operating expenses:
Marketing and sales | 171 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -4 |  | 0 |  | 167
General and administrative | 79 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 70
Research and development | 311 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 283
Acquisition-related contingent consideration | 2 |  | -2 |  | 0 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 15 |  | -15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 20 |  | 0 |  | 0 |  | 0 |  | 0 |  | -20 |  | 0 |  | 0 |  | 0
Total operating expenses | 598 |  | -17 |  | 0 |  | 0 |  | 0 |  | -20 |  | -41 |  | 0 |  | 520
Operating income | 83 |  | 19 |  | -129 |  | 0 |  | -1 |  | 20 |  | 42 |  | 0 |  | 34
Loss on strategic investments | -1 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income (expense), net | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2
Income before provision for income taxes | 80 |  | 19 |  | -129 |  | 1 |  | -1 |  | 20 |  | 42 |  | 0 |  | 32
Provision for income taxes | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  | -41 |  | 9
Net income | 30 |  | 19 |  | -129 |  | 1 |  | -1 |  | 20 |  | 42 |  | 41 |  | 23
Earnings per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic | 0.09 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 0.07
Diluted | 0.09 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.07
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic | 327 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 327
Diluted | 330 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 330
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: Simons Mobile

O2 | Simons Mobile
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009 | 60
April | 2009 | 55
May | 2009 | 60
June | 2009 | 45
July | 2009 | 45.79
August | 2009 | 45
September | 2009 | 45
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 69207d1269724759-average-based-on-multiple-conditions-test
Sheet: Sheet1

no | fulldate | returna | Year | Month | Quarter
1 | 19970228 | R | 1997 | 2 | 1
1 | 19970331 | -0.011789 | 1997 | 3 | 1
1 | 19970430 | 0.008417 | 1997 | 4 | 2
1 | 19970530 | 0.013523 | 1997 | 5 | 2
1 | 19970630 | 0.012502 | 1997 | 6 | 2
1 | 19970731 | 0.029325 | 1997 | 7 | 3
1 | 19970829 | -0.010477 | 1997 | 8 | 3
1 | 19970930 | 0.014313 | 1997 | 9 | 3
1 | 19971031 | 0.008461 | 1997 | 10 | 4
1 | 19971128 | 0.006949 | 1997 | 11 | 4
1 | 19971231 | 0.009751 | 1997 | 12 | 4
1 | 19980130 | 0.010987 | 1998 | 1 | 1
1 | 19980227 | 0.001899 | 1998 | 2 | 1
1 | 19980331 | 0.001761 | 1998 | 3 | 1
1 | 19980430 | 0.003523 | 1998 | 4 | 2
1 | 19980529 | 0.009521 | 1998 | 5 | 2
1 | 19980630 | 0.007275 | 1998 | 6 | 2
1 | 19980731 | 0.004201 | 1998 | 7 | 3
1 | 19980831 | -0.006952 | 1998 | 8 | 3
1 | 19980930 | 0.025869 | 1998 | 9 | 3
1 | 19981030 | -0.009234 | 1998 | 10 | 4
1 | 19981130 | 0.015529 | 1998 | 11 | 4
1 | 19981231 | -0.000289 | 1998 | 12 | 4
2 | 19970228 | R | 1997 | 2 | 1
2 | 19970331 | -0.013843 | 1997 | 3 | 1
2 | 19970430 | 0.016043 | 1997 | 4 | 2
2 | 19970530 | 0.042105 | 1997 | 5 | 2
2 | 19970630 | 0.034722 | 1997 | 6 | 2
2 | 19970731 | 0.044539 | 1997 | 7 | 3
2 | 19970829 | -0.025117 | 1997 | 8 | 3
2 | 19970930 | 0.04254 | 1997 | 9 | 3
2 | 19971031 | -0.021264 | 1997 | 10 | 4
2 | 19971128 | 0.015854 | 1997 | 11 | 4
2 | 19971231 | 0.012139 | 1997 | 12 | 4
2 | 19980130 | 0.009947 | 1998 | 1 | 1
2 | 19980227 | 0.043453 | 1998 | 2 | 1
2 | 19980331 | 0.031649 | 1998 | 3 | 1
Spreadsheet: 680468d1591037579-linking-cells-to-a-summary-new-mileage-auto-form-forum-copy
Sheet: 25.4.20

Form: Rep08.doc
Revision : 02/01/2018
SALES PERSONNAL - WEEKLY MILEAGE REPORT
Sales Persons Name: [NAME]
Vehicle Model & Registration:
Check List: | Oil | ü | Water | ü | Tyres | ü | Bodywork | ü
Week commencing date: |  |  |  |  | Opening mileage
Day | Date | Business miles |  | Private miles |  | # [NAME] purchased |  | Fuel costs £
Sat |  |  |  | 26
Sun
Mon |  |  |  | 26
Tue |  |  |  | 56 |  | 19.08 |  | 20.4
Wed |  |  |  | 6 |  |  |  | .
Thu |  |  |  | 6
Fri
 |  | Total Business miles |  | Total Private miles |  | Total # [NAME] purchased |  | Total Fuel costs £
Check | Closing Mileage |  |  | 99767 |  | Expenses
 | Amount to be deducted for PRIVATE use / mileage |  |  |  |  | Fuel - PM + Expences
Signed off  &  confirmed by : |  |  |  |  |  |  | Dated:
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -13851 | -21407
2 | -20005 | -20000
3 | -20159 | -20000
4 | -20797 | -20000
5 | -20340 | -20000
6 | -20004 | -20000
7 | -20329 | -20000
8 | -20015 | -20000
9 | -20003 | -20000
10 | -26813 | -25815
11 | -19899 | -20000
12 | -23341 | -23611
13 | -19015 | -18997
14 | -19876 | -18890
15 | -20003 | -19169
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 151464
2001-09-15 00:00:00
CBS Dollars
 |  |  | 125521
Spreadsheet: 44377d1242975327-dropdown-menu-unique-validationlist
Sheet: Sheet1

Dog |  | 1st formula | Bird | List |  |  | [NAME]
Dog |  | 2nd, copy down | Cat
Cat |  |  | Dog
Bird |  |  | Fish |  |  | [NAME] in D1 and D2 are array formulas, confirm any changes
Lizard |  |  | Hamster |  |  | with CTRL-SHIFT-ENTER.
Dog |  |  | Lizard
Cat |  |  | Rabbit |  |  | This does it without helper cells
Fish |  |  | Reptile |  |  | and also results are sorted, but the calculations
Lizard |  |  |  |  |  | occuring are much greater. Do not use this
Bird |  |  |  |  |  | technique to work against a very large dataset or
Reptile |  |  |  |  |  | the spreadsheet may slow down dramatically.
Dog
Reptile |  |  |  |  |  | A dynamic name range [NAME] always shows
Fish |  |  |  |  |  | only the values in column D, no blanks.
Cat
Reptile |  |  |  |  |  | [EMAIL]
Rabbit
Hamster |  |  |  |  |  | ...for any questions about adapting it.
Rabbit
Bird
Dog
Cat
Hamster
Spreadsheet: 490510d1479903142-problem-analysing-data-problem
Sheet: Sheet1

Title Name | Category | Sub Category | [NAME] count Store Count | New York Store Count | Total Store Count | Average sale | Opportinty for Upgrade? | Titles to Target | Is the title under threat | Title (s) where threat is coming from
A | CRAFT | COLOURING | 111 | 114 | 225 | 5.521039316239317 | YES | B,D,E,F,H,I | NO | -
B | CRAFT | COLOURING | 374 | 465 | 839 | 5.066030989272944 | NO | NONE | YES | A
C | CRAFT | COLOURING | 144 | 114 | 258 | 4.591276088252832 | YES | D,E,F,I | YES | A
D | CRAFT | COLOURING | 359 | 218 | 577 | 4.251177176376483 | YES | NONE | YES | A
E | CRAFT | COLOURING | 361 | 218 | 579 | 4.248630264381559
F | CRAFT | COLOURING | 234 | 111 | 345 | 1.869687848383501
G | CRAFT | COLOURING | 54 | 0 | 54 | 1.823119658119658
H | PARTWORKS | COLOURING | 144 | 100 | 244 | 1.728770491803278
I | CRAFT | COLOURING | 144 | 141 | 285 | 1.646491228070175
J | CRAFT | COLOURING | 0 | 94 | 94 | 0.9703355155482816
K | CRAFT | COLOURING | 0 | 0 | 0 | 0
L | CRAFT | COLOURING | 0 | 0 | 0 | 0
I have made a change to the original data set as my original information is quite sensitive. The price column is actually total sales over a 13 week period divided by the total number of stores that magazine is in.
Title Name are actually magazine titles. There are aprox 100 sub categories with a total of 1000 different magazine titles. The analysis can only occur when you break the data set by sub cat because you cannot compare magazine titles outside of its sub sector
In my original spreadsheet, there is a drop down menu that changes sub categories, allowing the user to select which one they would like to view.
Upgrade occurs when the average sale is higher and the total store count is lower compared to other titles within the sub category. When this happens, the better performing title can replce the poorer performing title.
This process is called targeting.
For example, Title A has the opportunity to upgrade as it can replace any title that has a Rate of Sale lower than £5.52 AND with a total store count higher than 225
So using this example, title A has can upgrade against B, D,E,F,H and I.
Title B does not have the opportunity to upgrade as the average sale is £5.07 with the total store count of 839. But at the same time it is under threat from title [NAME] can "take over" its position of 839 as it has a higher Average sale and lower total store count
I have manually entered the desired output (highlighted in yellow), I hope this provides you with a better understanding of the problem. Any input would be a great help.
Spreadsheet: 860448d1708533415-sum-function-not-capturing-all-amount-v2-wip-test
Sheet: WIP

Project No | Proposal | Client | Value | PO Number | Invoice No
2023-200 | WSG23-365 | EFAB | 5570.6 | 470284536 | 23800432
2023-200 | WSG23-365 | EFAB | 14694.6 | 470284536 | 23800455
2023-200 | WSG23-365 | EFAB | 3183.2 | 470284536 | 23800518
2023-200 | WSG23-365 | EFAB | 3553.4 | 470284536 | 23800557
2023-200 | WSG23-365 | EFAB | 2970.4 | 470284536 | 23800586
2023-200 | WSG23-365 | EFAB | 10345.4 | 470284536 | 23800627
2023-200 | WSG23-365 | EFAB | 4774.8 | 470284536 | 23800666
2023-200 | WSG23-365 | EFAB | 13898.8 | 470284536 | 23800700
2023-200 | WSG23-523 | EFAB | 7061.5 | [PHONE] | 23800712
2023-200 | WSG23-522 | EFAB | 51100.53 | [PHONE] | 23800713
2023-200 | WSG23-486 | EFAB | 33874.8 | [PHONE] | 23800715
2023-200 | WSG23-523 | EFAB | 5652.5 | [PHONE] | 23800722
2023-200 | WSG23-365 | EFAB | 3979 | [PHONE] | 23800723
2023-200 | WSG23-522 | EFAB | 37664.8 | [PHONE] | 23800727
2023-200 | WSG23-365 | EFAB | 3729 | [PHONE] | 23800758
2023-200 | WSG23-523 | EFAB | 10867 | [PHONE] | 23800760
2023-200 | WSG23-522 | EFAB | 83017.54 | [PHONE] | 23800761
2023-200 | WSG23-365.1 | EFAB | 18469 | [PHONE] | 23800812
2023-200 | WSG23-611 | EFAB | 14254 | [PHONE] | 23800818
2023-200 | WSG23-598.1 | EFAB | 20148.45 | [PHONE] line 4 | 23800819
2023-200 | WSG23-523.1 | EFAB | 5652.5 | [PHONE] line 1 | 23800820
2023-200 | WSG23-365.1 | EFAB | 9848.8 | [PHONE] | 23800821
2023-200 | WSG23-609 | EFAB | 14169.86 | [PHONE] | 23800822
2023-200 | WSG23-365.1 | EFAB | 5621 | [PHONE] | 23800840
2023-200 | WSG23-523.1 | EFAB | 5621 | [PHONE] line 1 | 23800841
2023-200 | WSG23-598.1 | EFAB | 20094.55 | [PHONE] line 4 | 23800842
2023-200 | WSG23-611 | EFAB | 13532.5 | [PHONE] Line 2 | 23800843
2023-200 | WSG23-610 | EFAB | 8593.57 | [PHONE] | 23800844
2023-200 | WSG23-522 | EFAB | 75355.17 | [PHONE] | 23800849
2023-200 | WSG23-365.1 | EFAB | 4068.9 | [PHONE] | 24800006
2023-200 | WSG23-523.1 | EFAB | 3306.5 | [PHONE] line 1 | 24800007
2023-200 | WSG23-598.1 | EFAB | 14177.15 | [PHONE] line 4 | 24800009
2023-200 | WSG23-365.1 | EFAB | 6470.7 | [PHONE] | 24800011
2023-200 | WSG23-365.1 | EFAB | 5621 | [PHONE] | 24800018
2023-200 | WSG23-523.1 | EFAB | 9835.5 | [PHONE] line 1 | 24800019
2023-200 | WSG23-610 | EFAB | 12118.9 | [PHONE] line 3 | 24800020
2023-200 | WSG23-598.1 | EFAB | 33235.65 | [PHONE] line 4 | 24800023
2023-200 | WSG23-611 | EFAB | 36660.5 | [PHONE] Line 2 | 24800024
2023-200 | WSG23-365.1 | EFAB | 4848.8 | [PHONE] | 24800062
2023-200 | WSG23-523.1 | EFAB | 5621 | [PHONE] line 1 | 24800063
2023-200 | WSG23-610 | EFAB | 4039.63 | [PHONE] line 3 | 24800064
2023-200 | WSG23-611 | EFAB | 15945.5 | [PHONE] Line 2 | 24800065
2023-200 | WSG23-365.1 | EFAB | 8030 | [PHONE] | 24800070
2023-200 | WSG23-523.1 | EFAB | 7392 | [PHONE] line 1 | 24800071
2023-200 | WSG23-610 | EFAB | 21300.17 | [PHONE] line 3 | 24800072
2023-200 | WSG23-610 | EFAB | 495 | [PHONE] line 3 | 24800073
2023-200 | WSG23-523 | EFAB | 8781 | [PHONE] | 23800779/780
Spreadsheet: 41908d1240451120-reading-from-a-particular-page-based-on-drop-list-option-fixexample
Sheet: 5Team

1 | 2
3 | 4
5 | Bye
2 | 4
1 | 5
3 | Bye
4 | 5
2 | 3
1 | Bye
5 | 3
4 | 1
2 | Bye
3 | 1
5 | 2
4 | Bye
1 | 2
3 | 4
5 | Bye
2 | 4
1 | 5
3 | Bye
4 | 5
2 | 3
1 | Bye
5 | 3
4 | 1
2 | Bye
3 | 1
5 | 2
4 | Bye
Spreadsheet: 775032d1648781505-display-certain-periods-based-on-input-example-workbook-ashaman88-
Sheet: Legend

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KEY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version | Director's |  |  |  |  | 1 | January | 1 | Q1 |  | 2022-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  | 2 | February | 2 | Q1 |  | 2022-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year |  |  |  |  |  | 3 | March | 3 | Q1 |  | 2022-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | 2022-04-30 00:00:00 |  |  |  |  | 4 | April | 4 | Q2 |  | 2022-04-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May | 5 | Q2 |  | 2022-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | June | 6 | Q2 |  | 2022-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | 7 | July | 7 | Q3 |  | 2022-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Update Monthly |  |  |  |  | 8 | August | 8 | Q3 |  | 2022-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Update Quarterly |  |  |  |  | 9 | September | 9 | Q3 |  | 2022-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Update Annually |  |  |  |  | 10 | October | 10 | Q4 |  | 2022-10-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Never Update |  |  |  |  | 11 | November | 11 | Q4 |  | 2022-11-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same as the past |  |  |  |  | 12 | December | 12 | Q4 |  | 2022-12-31 00:00:00
Spreadsheet: ae2ea8be-732f-498b-9332-501242cf5268
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8914 | 68348 | Eha | Lehtoja | EST | 291 | 00:20:21 | 00:01:29 | 00:38:30 | 00:01:37 | 00:25:11 | 1 | 01:27:08
Spreadsheet: 31315d1227122634-sum-every-third-cell-sumthird-cell
Sheet: Medizine, Prevention

 |  |  | Prevention Digest Medizine- Mutual
Report Type: Trend
Report Completed: 11/18/2008 02:14:33 PM EST
Reported Time Period: 10/1/2007-10/31/2008 (B)
BRAND | PROPERTY | TOTAL DOLS (000) | TOTAL UNITS | 2008 (B) DOLS (000) | 2008 (B) UNITS | OCT 01, 2007 (B) TO OCT 01, 2008 (B) DOLS (000) | OCT 01, 2007 (B) TO OCT 01, 2008 (B) UNITS
Orencia | MEDIZINE HEALTHY LIVING | 6348.4 | 8 | 5076.4 | 6 | 6348.4 | 8
Orencia | PREVENTION | 1974.8 | 4 | 1011.6 | 2 | 1974.8 | 4
Orencia TOTAL |  | 8323.2 | 12 | 6088 | 8 | 8323.2 | 12
Cymbalta | PREVENTION | 3333.2 | 10 | 2422.7 | 7 | 3333.2 | 10
Cymbalta | MEDIZINE HEALTHY LIVING | 1495.2 | 2 | 1495.2 | 2 | 1495.2 | 2
Cymbalta TOTAL |  | 4828.4 | 12 | 3917.9 | 9 | 4828.4 | 12
Clorox | READER'S DIGEST | 4146.2 | 6 | 2737.2 | 3 | 4146.2 | 6
Clorox | PREVENTION | 607.4 | 3 | 445.3 | 2 | 607.4 | 3
Clorox TOTAL |  | 4753.6 | 9 | 3182.5 | 5 | 4753.6 | 9
Topamax | MEDIZINE HEALTHY LIVING | 2031.6 | 3 | 1405.6 | 2 | 2031.6 | 3
Topamax | PREVENTION | 1900.8 | 4 | 1419.2 | 3 | 1900.8 | 4
Topamax TOTAL |  | 3932.4 | 7 | 2824.8 | 5 | 3932.4 | 7
Singulair | PREVENTION | 965.6 | 3 | 965.6 | 3 | 965.6 | 3
Singulair | MEDIZINE HEALTHY LIVING | 515.9 | 1 | 515.9 | 1 | 515.9 | 1
Singulair TOTAL |  | 1481.5 | 4 | 1481.5 | 4 | 1481.5 | 4
Abilify | MEDIZINE HEALTHY LIVING | 626 | 1 |  |  | 626 | 1
Abilify | PREVENTION | 481.6 | 1 |  |  | 481.6 | 1
Abilify TOTAL |  | 1107.6 | 2 |  |  | 1107.6 | 2
Tylenol Extra Strength | PREVENTION | 408.6 | 3 | 408.6 | 3 | 408.6 | 3
Tylenol Extra Strength | MEDIZINE HEALTHY LIVING | 186.9 | 1 | 186.9 | 1 | 186.9 | 1
Tylenol Extra Strength TOTAL |  | 595.5 | 4 | 595.5 | 4 | 595.5 | 4
PUBLIX SUPERMARKETS | MEDIZINE HEALTHY LIVING | 398.6 | 5 | 396.2 | 4 | 398.6 | 5
PUBLIX SUPERMARKETS | PREVENTION | 24.8 | 2 | 12 | 1 | 24.8 | 2
PUBLIX SUPERMARKETS TOTAL |  | 423.5 | 7 | 408.2 | 5 | 423.5 | 7
US Department Of Health & Human Services | PREVENTION | 219.2 | 2 | 219.2 | 2 | 219.2 | 2
US Department Of Health & Human Services | MEDIZINE HEALTHY LIVING | 186.9 | 1 | 186.9 | 1 | 186.9 | 1
US Department Of Health & Human Services TOTAL |  | 406.1 | 3 | 406.1 | 3 | 406.1 | 3
Quaker Oatmeal To Go | MEDIZINE HEALTHY LIVING | 166.5 | 1 |  |  | 166.5 | 1
Quaker Oatmeal To Go | PREVENTION | 104.4 | 1 |  |  | 104.4 | 1
Quaker Oatmeal To Go TOTAL |  | 270.9 | 2 |  |  | 270.9 | 2
MEDICINE SHOPPE | PREVENTION | 129.7 | 1 |  |  | 129.7 | 1
MEDICINE SHOPPE | MEDIZINE HEALTHY LIVING | 11 | 2 | 11 | 2 | 11 | 2
MEDICINE SHOPPE TOTAL |  | 140.7 | 3 | 11 | 2 | 140.7 | 3
GRAND TOTAL |  | 26263.4 | 65 | 18915.5 | 45 | 26263.4 | 65
Copyright 2008. TNS Media Intelligence Copyright 2008. Magazine Publishers of America  Inc. | q_id: 1279457 Stradegy Online
Data for certain markets may not be available for all time periods. See Methodology for market availability.
Spreadsheet: 157818d1337881301-count-if-example-countif-example
Sheet: Sheet1

KW | Word Count |  | KWD | Total Count | # of times Phrase Used
White Ponys | 2 |  | white ponys
Little White Ponys | 2 |  | white horses
Big White Ponys | 2
White Horses | 2
dark white horses | 2
Total
Spreadsheet: 149834d1334158561-count-of-values-based-on-criteria-which-as-exactly-in-pivot-book1-help
Sheet: Sheet1

Rep | Value |  |  | 0 | 1 | COUNTIFS
ABC | 0 |  | ABC
ABC | 1 |  | BCA
ABC | 0 |  | CAB
ABC | 1 |  |  |  |  |  |  |  |  | Sum of Value | Value
BCA | 1 |  |  |  |  |  |  |  |  | Rep | 0 | 1 | Grand Total
BCA | 1 |  |  |  |  |  |  |  |  | ABC | 0 | 2 | 2
BCA | 0 |  |  |  |  |  |  |  |  | BCA | 0 | 2 | 2
CAB | 1 |  |  |  |  |  |  |  |  | CAB |  | 3 | 3
CAB | 1 |  |  |  |  |  |  |  |  | Grand Total | 0 | 7 | 7
CAB | 1
 |  |  |  | 0 | 1 | SUMIFS
 |  |  | ABC
 |  |  | BCA
 |  |  | CAB