tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675558d1588353491-conditional-drop-down-auto-fill-option-is-this-possible-competitor-autofill-eba
Sheet: Source Data Tab

Technology |  |  | Service Area to be used in Drop Down
Logic |  |  | Alaska | 010
 |  |  | California | 054, 055
 |  |  | Colorado | 070, 071, 072, 073
 |  |  | Hawaii | 148
 |  |  | Idaho | 150, 151, 152, 153
 |  |  | Montana | 360, 361, 362, 363
 |  |  | North Dakota | 472, 473
 |  |  | Oregon | 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527
 |  |  | Utah | 620
 |  |  | Washington | 637, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659
 |  |  | Wyoming | 690, 691, 692, 693, 694, 695, 696
Current Fiscal Year: |  |  | FY20
Technology: |  |  | Hydraulic IND
Service Area/ Province Name: |  |  | Wyoming
Trade Areas:
Data To Be Used:
Parker Sales |  | Total
Parker Sales |  | Total
 |  |  | ENTER Data in Grey Shaded
 |  |  | Area.  This Data is carried
 |  |  | Throughout the Market
 |  |  | Share Template.
Spreadsheet: 96525d1295908231-i-dentifying-a-date-within-a-range-identifying-date-qualification-within-a-range
Sheet: Sheet4

Project Start Date |  | 2010-10-01 00:00:00
Current Date |  | 2010-10-30 00:00:00
 |  |  | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending
1 | 1 |  | 2010-10-01 00:00:00 | 2010-11-12 00:00:00 | 2010-11-12 00:00:00 | 2010-11-26 00:00:00 | 2010-11-26 00:00:00
1 | 2 |  | 2010-10-01 00:00:00 | 2010-11-05 00:00:00 | 2010-11-12 00:00:00 | 2010-11-19 00:00:00 | 2010-11-19 00:00:00
1 | 3 |  | 2010-10-01 00:00:00 | 2010-12-10 00:00:00 | 2010-12-10 00:00:00 | 2011-01-07 00:00:00 | 2011-01-07 00:00:00
1 | 4 |  | 2010-10-01 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-12-24 00:00:00 | 2011-01-07 00:00:00
0 | 5 |  | 2010-12-03 00:00:00 | 2010-12-17 00:00:00 | 2010-12-17 00:00:00 | 2011-01-14 00:00:00 | 2011-01-14 00:00:00
0 | 6 |  | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-10 00:00:00 | 2011-01-07 00:00:00 | 2011-01-07 00:00:00
0 | 7 |  | 2010-12-03 00:00:00 | 2010-12-17 00:00:00 | 2010-12-17 00:00:00 |  | 2011-01-21 00:00:00
0 | 8 |  | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-17 00:00:00 | 2011-01-14 00:00:00 | 2011-01-14 00:00:00
0 | 9 |  | 2010-12-03 00:00:00 | 2010-12-17 00:00:00 | 2010-12-17 00:00:00
0 | 10 |  | 2010-12-03 00:00:00 | 2010-12-17 00:00:00 | 2010-12-17 00:00:00 |  | 2011-01-21 00:00:00
Spreadsheet: 179524d1347288934-some-sort-of-sumifs-to-remove-pivot-table-0a1sumifs-of-months
Sheet: Example

DATA |  |  | INPUT |  |  |  | Row Labels | Sum of Amount
Date | Amount |  | Month: | 2012-02-01 00:00:00 |  |  | Jan | 10
2012-01-01 00:00:00 | 1 |  | Year: | 2012 |  |  | Feb | 18
2012-01-08 00:00:00 | 2 |  |  |  |  |  | Mar | 17
2012-01-22 00:00:00 | 3 |  | OUTPUT |  |  |  | Grand Total | 45
2012-01-31 00:00:00 | 4 |  |  | formula??
2012-02-01 00:00:00 | 5
2012-02-03 00:00:00 | 6
2012-02-20 00:00:00 | 7 |  |  |  |  |  |  | Look the format here
2012-03-06 00:00:00 | 8
2012-03-15 00:00:00 | 9
Anyone able to produce a formula in cell D6 to remove my need for a pivot table?
Simply needs to be based on the two input cells E2 & E3
Spreadsheet: 73743d1274339872-excel-2007-listing-x-largest-values-sample
Sheet: randomdata (3)

No. | Name | [NAME] | Value
1 | Wade Summers | [EMAIL]
2 | [NAME] | [EMAIL] | 1575
3 | [NAME] | [EMAIL] | 1582
4 | [NAME] | [EMAIL] | 625
5 | Driscoll Delgado | [EMAIL]
6 | Steel Salazar | [EMAIL] | 676
7 | Griffith Alston | [EMAIL] | 241
8 | [NAME] | [EMAIL]
9 | [NAME] | [EMAIL] | 552
10 | Kermit Walton | [EMAIL]
11 | [NAME] | [EMAIL] | 895
12 | [NAME] | [EMAIL] | 683
13 | [NAME] | [EMAIL] | 710
14 | [NAME] | [EMAIL] | 826
15 | [NAME] | [EMAIL]
16 | Castor Landry | [EMAIL] | 419
17 | [NAME] | [EMAIL] | 97
18 | [NAME] | [EMAIL]
19 | [NAME] | [EMAIL] | 276
20 | Gannon [NAME] | [EMAIL] | 1553
21 | [NAME] | [EMAIL] | 428
22 | [NAME] | [EMAIL]
23 | [NAME] | [EMAIL] | 1718
24 | [NAME] | [EMAIL] | 392
25 | [NAME] | [EMAIL] | 400
26 | [NAME] | [EMAIL] | 1325
27 | [NAME] | [EMAIL] | 1292
28 | [NAME] | [EMAIL] | 528
29 | Addison Johns | [EMAIL]
30 | Arden Wells | [EMAIL] | 1945
31 | [NAME] | [EMAIL] | 382
32 | [NAME] | [EMAIL] | 1848
33 | [NAME] | [EMAIL] | 596
34 | [NAME] | [EMAIL] | 1048
35 | Slade [NAME] | [EMAIL] | 458
36 | [NAME] | [EMAIL] | 364
37 | [NAME] | [EMAIL] | 1014
38 | [NAME] | [EMAIL] | 1207
39 | Palmer Hunter | [EMAIL] | 368
40 | [NAME] | [EMAIL] | 301
41 | [NAME] | [EMAIL] | 1679
42 | [NAME] | [EMAIL] | 695
43 | [NAME] | [EMAIL] | 158
44 | [NAME] | [EMAIL] | 1458
45 | [NAME] | [EMAIL] | 311
46 | Hashim Guthrie | [EMAIL] | 660
47 | Dieter Carpenter | [EMAIL] | 1836
48 | [NAME] | [EMAIL] | 471
49 | [NAME] | [EMAIL] | 754
50 | [NAME] | [EMAIL] | 1322
51 | [NAME] | [EMAIL] | 646
52 | [NAME] | [EMAIL] | 129
53 | [NAME] | [EMAIL] | 1285
54 | [NAME] | [EMAIL] | 424
55 | [NAME] | [EMAIL] | 821
56 | Fuller Harrell | [EMAIL] | 677
57 | [NAME] | [EMAIL] | 1341
58 | [NAME] | [EMAIL] | 1669
59 | [NAME] | [EMAIL] | 603
60 | [NAME] | [EMAIL] | 1723
61 | [NAME] | [NAME] | 1169
62 | [NAME] | [EMAIL] | 797
63 | [NAME] | [EMAIL] | 1436
64 | Dillon Haynes | [EMAIL] | 1731
65 | [NAME] | [EMAIL] | 726
66 | [NAME] | [EMAIL] | 1668
67 | [NAME] | [EMAIL] | 972
68 | [NAME] | [EMAIL] | 5
69 | [NAME] | [EMAIL] | 559
70 | [NAME] | [EMAIL] | 673
71 | [NAME] | [EMAIL] | 992
72 | [NAME] | [EMAIL] | 1646
73 | [NAME] | [EMAIL] | 52
74 | [NAME] | [EMAIL] | 1825
75 | [NAME] | [EMAIL] | 496
76 | [NAME] | [EMAIL] | 578
77 | [NAME] | [EMAIL] | 765
78 | [NAME] | [EMAIL] | 1383
79 | Rigel Osborne | [EMAIL] | 679
80 | [NAME] | [EMAIL] | 727
81 | [NAME] | [EMAIL] | 849
82 | [NAME] | [EMAIL] | 1916
83 | Cruz Gaines | [EMAIL] | 1240
84 | [NAME] | [EMAIL] | 363
85 | [NAME] | [EMAIL] | 1938
86 | [NAME] | [EMAIL] | 1298
87 | [NAME] | [EMAIL] | 1568
88 | [NAME] | [EMAIL] | 1311
89 | [NAME] | [EMAIL] | 237
90 | [NAME] | [EMAIL] | 1467
91 | [NAME] | [EMAIL] | 510
92 | [NAME] | [EMAIL] | 1053
93 | [NAME] | [EMAIL] | 1817
94 | [NAME] | [EMAIL] | 1610
95 | [NAME] | [EMAIL] | 1010
96 | [NAME] | [EMAIL] | 1816
97 | [NAME] | [EMAIL] | 1074
98 | [NAME] | [EMAIL] | 1444
99 | [NAME] | [EMAIL] | 1801
100 | [NAME] | [EMAIL] | 1458
Spreadsheet: 164355d1340732547-using-sumifs-how-to-create-criteria-to-include-if-cell-doesnt-match-specific-data-12-13-budget-test
Sheet: Student Worker List

Student Name | Department | Start Date | End Date
[NAME] | Earth Sciences | 2012-07-01 00:00:00 | 2012-08-26 00:00:00
[NAME] | Wildlife | 2012-07-01 00:00:00 | 2012-08-26 00:00:00
Robyn Solis | Wildlife | 2012-07-01 00:00:00 | 2012-08-26 00:00:00
[NAME] | Earth Sciences | 2012-07-01 00:00:00 | 2012-08-26 00:00:00
Spreadsheet: 837236d1689952838-fill-in-missing-cells-with-copy-of-data-from-above-example-workbook-missing-cells
Sheet: Solved

ID | First Name | Last Name
1001 | [NAME] | Bloggs
1001 | [NAME] | Bloggs
1001 | [NAME] | Bloggs
1002 | [NAME] | Booker
1002 | [NAME] | Booker
1003 | [NAME] | Edwards
1003 | [NAME] | Edwards
1003 | [NAME] | Edwards
1003 | [NAME] | Edwards
1003 | [NAME] | Edwards
1007 | Walter | White
1007 | Walter | White
1007 | Walter | White
1007 | Walter | White
1007 | Walter | White
1007 | Walter | White
1007 | Walter | White
1007 | Walter | White
1008 | [NAME] | Fernandes
Spreadsheet: 00d842c0-28c1-48d3-8422-18e7879b0c65
Sheet: Sheet1

Preveniton Intervention Services | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
County | City | Location | Program | Population Served | Contact Person | Phone Number | [NAME]
Bannock | Pocatello | Still Waters Counseling | Prevention   Intervention | High School Students | [NAME] | [PHONE] | swcounseling!@questoffice.net
Boise | Garden Valley | Boise County Juvenile Probation | Prevention   Intervention | Middle/Junior High School | [NAME] | [PHONE] | [EMAIL]
Boise | Horseshoe Bend | Boise County Juvenile Probation | Prevention   Intervention | Middle/Junior High School | [NAME] | [PHONE] | [EMAIL]
Boise | Idaho City | Boise County Juvenile Probation | Prevention   Intervention | Middle/Junior High School | [NAME] | [PHONE] | [EMAIL]
Boise | Garden Valley | Boise County Juvenile Probation | Prevention   Intervention | High School Students | [NAME] | [PHONE] | [EMAIL]
Boise | Horseshoe Bend | Boise County Juvenile Probation | Prevention   Intervention | High School Students | [NAME] | [PHONE] | [EMAIL]
Boise | Idaho City | Boise County Juvenile Probation | Prevention   Intervention | High School Students | [NAME] | [PHONE] | [EMAIL]
Canyon | Caldwell | Prevention Associates LLC | Prevention   Intervention | High School Students | [NAME] | [PHONE] | [EMAIL]
Kootenai | [NAME] | AJI Counseling, LLC | Prevention   Intervention | High School Students | [NAME] | [PHONE] | [EMAIL]
Minidoka | [NAME] | Minidoka Juvenile Probation | Prevention   Intervention | High School Students | Dixie Tate | [PHONE] | [NAME]
Cassia | Burley | Minidoka Juvenile Probation | Prevention   Intervention | High School Students | Dixie Tate | [PHONE] | [NAME]
Spreadsheet: 86f37233-03f9-4bfa-81e5-de42ccce9ba8
Sheet: Sheet1

AGCO CORP /DE | Unnamed: 1
10-K
02/27/2013
Summary Compensation
TABLE OF CONTENTS
PART I
 | Item 1. Business
 | Item 1A. Risk Factors
 | Item 1B. Unresolved Staff Comments
 | Item 2. Properties
 | Item 3. Legal Proceedings
 | Item 4. Mine Safety Disclosures
PART II
 | Item 5. Market For Registrant s Common Equity,
 | Related Stockholder Matters and Issuer
 | Purchases of Equity Securities
 | Item 6. Selected Financial Data
 | Item 7. Management s Discussion and Analysis
 | of Financial Condition and Results of Operations
 | Item 7A. Quantitative and Qualitative
 | Disclosures About Market Risk
 | Item 8. Financial Statements and Supplementary
 | Data
 | Item 9. Changes in and Disagreements with
 | Accountants on Accounting and Financial
 | Disclosure
 | Item 9A. Controls and Procedures
 | Item 9B. Other Information
PART III
 | Item 10. Directors, Executive Officers
 | and Corporate Governance
 | Item 11. Executive Compensation
 | Item 12. Security Ownership of Certain
 | Beneficial Owners and Management and Related
 | [NAME]
 | Item 13. Certain Relationships and Related
 | Transactions, and Director Independence
 | Item 14. Principal Accounting Fees and
 | Services
PART IV
 | Item 15. Exhibits and Financial Statement
 | Schedules
SIGNATURES
ANNUAL REPORT ON FORM 10-K ITEM 15 (A)(2)
FINANCIAL STATEMENT SCHEDULE YEAR ENDED
DECEMBER 31, 2012
SCHEDULE II - VALUATION AND QUALIFYING
ACCOUNTS
EX-10.20
EX-21.1
EX-23.1
EX-24.1
EX-31.1
EX-31.2
EX-32.1
EX-101 [NAME]
EX-101 SCHEMA DOCUMENT
EX-101 [NAME]
EX-101 [NAME]
EX-101 [NAME]
EX-101 PRESENTATION LINKBASE DOCUMENT
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 684254d1593229938-calendar-showing-multiple-assignments-on-one-date-follow-up
Sheet: FOLLOW UP

 | MONTH VIEW |  |  | WEEK VIEW
 | ASSIGNMENTS
 | Follow up | Quote # | Notes | Follow Up / Date of Contact
 | fgsdfgsdf |  |  | 2020-07-02 00:00:00
 | adsufhaod |  |  | 2020-07-02 00:00:00
 | Assignment 11
 | Assignment 12
 | ouh[oi
 | Assignment 3
 | Assignment 4
 | Assignment 5
 | Assignment 6
 | Assignment 7
 | Assignment 8
 | Assignment 9
Spreadsheet: 872653d1719007855-getting-data-from-one-workbook-to-another-athletics-spreadsheet-v14
Sheet: Age Champ

[NAME]
AGE GROUP | GENDER |  | STUDENT NAME | POINTS | HOUSE
8 YRS | Boys | Winner
 |  | [NAME] Up
8 YRS | Girls | Winner
 |  | [NAME] Up
9 YRS | Boy | Winner
 |  | [NAME] Up
9 YRS | Girls | Winner
 |  | [NAME] Up
10 YRS | Boy | Winner
 |  | [NAME] Up
10 YRS | Girls | Winner
 |  | [NAME] Up
11 YRS | Boys | Winner
 |  | [NAME] Up
11 YRS | Girls | Winner
 |  | [NAME] Up
12 YRS | Boys | Winner
 |  | [NAME] Up
12 YRS | Girls | Winner
 |  | [NAME] Up
Spreadsheet: a513f6e2-1c23-432a-93d2-6ce8dc8735a5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7973 | 28254 | Pavel | Yakimov | RUS | 25 | 00:25:32 | 00:00:00 | [NAME] | 00:00:00 | 00:29:57 | 1 | 01:25:01
7973 | 28250 | Pavel | Khanzhin | RUS | 26 | 00:25:29 | 00:00:00 | 00:31:17 | 00:00:00 | 00:33:02 | 2 | 01:29:49
7973 | 28394 | Martin | Husek | CZE | 24 | 00:28:33 | 00:00:00 | 00:31:19 | 00:00:00 | 00:32:08 | 3 | 01:32:01
7973 | 49118 | Julian | Erhardt | GER | 29 | 00:25:04 | 00:00:00 | [NAME] | 00:00:00 | 00:34:35 | 4 | 01:33:45
7973 | 21621 | Felix | [NAME] | AUT | 27 | [NAME] | 00:00:00 | 00:32:45 | 00:00:00 | 00:34:21 | 5 | 01:34:25
7973 | 54701 | [NAME] | Ager | GER | 28 | 00:25:37 | 00:00:00 | 00:33:42 | 00:00:00 | 00:39:05 | 6 | 01:38:24
7973 | 46613 | [NAME] | Gschwendner | GER | 30 | 00:27:01 | 00:00:00 | 00:44:39 | 00:00:00 | 00:37:25 | 7 | [NAME]
Spreadsheet: 808518d1670503430-formula-to-extend-to-next-day-in-an-excel-table-table-extend-formula
Sheet: Sheet1

Date | Total Required | Total installed up to date | in percent | up to 26-Oct-22 | 27/10/2022 | 28/10/2022 | 28/10/2023
Item1 |  |  |  | 289066 | 0
Item2 | 57325.19 |  |  | 57164.25 | 7.53 | 15.06 | 20.25
Item3 | 58591.63 |  |  | 48480.47 | 0
Item4 | 145002.12 |  |  | 144780.06 | 0
Item5 | 162708.72 |  |  | 123461.49 | 1136.1 | 1216.3 | 1234
Item6 |  |  |  | 21486 | 0
Item7 | 144926.7 |  |  | 142176.7 | 331.28 |  | 123.45
Item8 | 37852.11 |  |  | 19023.71 | 0
Item9 | 23832.43 |  |  | 12463.03 | 137.66 | 181.2 | 234.56
Total |  |  |  |  |  |  | 1987.56
 |  | This is the current [NAME] in Col C
 |  | =SUM(Table1[@[up to 26-Oct-22]:[28/10/2022]]) |  |  |  |  | This does not gets inclued
 |  |  |  |  |  |  | in the SUM Function
 |  |  |  |  |  |  | in Column C
Spreadsheet: 328274d1403851006-bonus-disqualifiers-for-excess-vacation-days-bonus-disqualifiers-ans
Sheet: Your help

base bonus amount | 2903.336 |  | 2014-01-06 00:00:00 |  | Number of workdays | 19
# of work days | 0.1 |  | excess days | deduction | amount | total | all shaded in gray not needed to be displayed or shown
19 |  |  | 1 | -0.25 |  |  | all shaded in gray should not be hidden
20 |  |  | 2 | -0.5 |  |  | treat all cells shaded in gray as nowehere to be found in the sheet
21 |  |  | 3 | -0.75
22 |  |  | 4 | -1
23
Agent | Leave(s) | bonus
Agent 01 | 0 | 2903.336
Agent 02 | 0.5 | 2903.336 |  |  | D2,G2 are added | apologies, I do not understand this portion
Agent 03 | 2 | 2903.336 |  |  |  | is d2 required to put compute for workdays?
Agent 04 | 2.01
Agent 05 | 1 | 2903.336
Agent 06 | 2.5
Agent 07 | 2.1
Agent 08 | 3.5
Agent 09 | 4.06
Agent 10 | 6.2
Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1210-LT 300A

Phase | Project No. | Segment ID (GIE) | Route No. | Facility Type | Pipe O.D., in. | Segment Length, ft | Proposed [NAME] | Proposed End M.P. | Proposed total length, ft. | Proposed [NAME], in. | Segment Length per Construction Classification, ft |  |  | Bored Crossings |  | HDDs |  | Potential Re-route | Move-arounds | Comments, notes, assumptions
 |  |  |  |  |  |  |  |  |  |  | Non-cong. | Semi-cong. | High-cong. | Q-ty | Length, Feet | Q-ty | Length, Feet | Yes/No | Q-ty |  | [NAME] | MP1 | MP2 | JNTEFF | GIRTH_WELD | LONG_SEAM | JOINT_TYPE | [NAME] | W_THICK | TEST_DATE | TEST_PRESS | [NAME] | TEST_DUR | MAOP | SMYS_MAOP | MOP | SMYS_MOP | YR_INSTALL | CLASSESENT | HCA_ID | SCC_THREAT | MANU_HREAT | CONSTHREAT | OF_THREAT | HS_THREAT | Legend Name | PerSMYS | TestPer | Sub_J | Fab_Note | Threat | Seismic | Object_ID | Shape_Length
1 | 1210 | 12680 | 300A | BB | 34 | 77 | 494.91 | 494.92 | 300 | 34 |  | 300 |  | 1 | 300 |  |  |  |  |  | 402.5 | 494.91 | 494.92 | 1.000 | ARC |  | BUTT | 46000 | 0.5 | 1957-01-01 00:00:00 | 0 |  | 0 | 558 | 41.2435 | 555 | 41.0217 | 1957-01-01 00:00:00 | 3 | B5 | No | Yes | No | Yes | No | ManuNoTestHCA | 41.02 | 0 | N |  |  |  | 20996 | 22.86174055804429
Spreadsheet: 812132d1672990904-index-match-with-array-criteria-index-match-multiple-aligw
Sheet: Sheet1

row
128
 |  |  | 2 |  | in this cell i would like to look up the row in column A that would then look up that row in column A sheet 2 and count how many times the value in d6 occurs in column B in sheet 2
 |  |  |  |  | It occurs 3 times
Spreadsheet: b5d1637d-fdc4-47fa-ab53-a3e3a32a4742
Sheet: Sheet1

Attorney General - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/19/2013 9:32:11 PM
Precincts Reporting: 604/604 - Total Ballots Cast: 92213
2004 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 3901 | 191 | 191
Precinct 3902 | 60 | 60
Precinct 3903 | 49 | 49
Precinct 3904 | 73 | 73
TOTAL | 373 | 373
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 125eee9e-a660-4a34-af0f-4637e8d95f59
Sheet: Survey

Last Name | First Name | [NAME] | do you like apples | do you like green appls | how many apples per week | Favorite apple | where do you buy | do you like citrus | dislike grapefuit? | favorite citrus | where do you buy | how many citrus per week |  | Summary Stats |  | [NAME]
Smith | [NAME] |  | y | y |  |  |  | y | y |  |  |  |  | Count number of responses |  | =COUNTA(C:C)-1
[NAME] | Will |  | y | n |  |  |  | y | y |  |  |  |  | Likes apples |  | =[NAME]:E,"y")
[NAME] | Maria |  | y | y |  |  |  | y | y |  |  |  |  | Like apples and citrus |  | =COUNTIFS(D:D,"y",I:I,"y")
Jones | [NAME] |  | y | n |  |  |  | y | y |  |  |  |  | Likes apples not green apples |  | =COUNTIFS(D:D,"y",E:E,"n")
[NAME] | [NAME] |  | n |  |  |  |  | y | y |  |  |  |  | Apples: average |  | =AVERAGE(F:F)
[NAME] | [NAME] |  | y | y |  |  |  | y | y |  |  |  |  | Apples: average if greater zero |  | =AVERAGEIF(F:F,">0")
[NAME] | [NAME] |  | y | n |  |  |  | y | y |  |  |  |  | Apples: sum if [NAME]'s market |  | =SUMIF(H:H,"farmer's market",F:F)
Wilson | [NAME] |  | n |  |  |  |  | y | y |  |  |  |  | Citrus: sum of corner deli |  | =SUMIF(L:L,"corner deli",M:M)
Moore | [NAME] |  | n |  |  |  |  | y | y
[NAME] | [NAME] |  | y | n |  |  |  | y | y
[NAME] | Helen |  | n |  |  |  |  | n |  |  |  |  |  | Percentages
[NAME] | [NAME] |  | y | y |  |  |  | y | n |  |  |  |  | Likes apples |  | =P3/P2
[NAME] | [NAME] |  | y | y |  |  |  | y | y |  |  |  |  | Like apples and citrus |  | =P4/P2
White | [NAME] |  | y | n |  |  |  | y | n |  |  |  |  | Likes apples not green apples |  | =P5/P2
[NAME] | Kamala |  | n |  |  |  |  | y | y
Martin | [NAME] |  | n |  |  |  |  | n
Thompson | Lorenzo |  | n |  |  |  |  | n
[NAME] | Maria |  | n |  |  |  |  | n
Martinez | Sonia |  | n |  |  |  |  | y | n
[NAME] | [NAME] |  | n |  |  |  |  | y | y
[NAME] | Lewis |  | y | n |  |  |  | y | y
Rodriguez | [NAME] |  | y | y |  |  |  | y | n
Lewis | [NAME] |  | y | n |  |  |  | y | y
[NAME] | Harper |  | y | y |  |  |  | y | y
Walker | [NAME] |  | y | n |  |  |  | y | y
Hall | Arsenio |  | y | n |  |  |  | y | y
[NAME] | George |  | y | n |  |  |  | y | n
Young | [NAME] |  | y | y |  |  |  | y | y
Hernandez | Erasmo |  | y | y |  |  |  | n
Spreadsheet: 824516d1680634993-combining-aggregate-with-if-and-functions-book3-sample
Sheet: sample

SCENARIO 1 | Dollars in Thousands
 | FY19 | FY20 | FY21 | FY22 | FY23 | FY24
# installs |  | 1 | 2 | 1 | 4 | 0
First install cost
cost per first install = $6    subsequent installs = $4 |  | 6 | 8 | 4 | 16
SCENARIO 2 | Dollars in Thousands
 | FY19 | FY20 | FY21 | FY22 | FY23 | FY24
# installs |  | 2 | 2 | 1 | 4 | 0
First install cost
cost per first install = $6    subsequent installs = $4 |  | 10 | 8 | 4 | 16
Spreadsheet: 4d077891-a594-4a62-96bc-f445287164b6
Sheet: page2

Section 2a |  |  |  |  |  |  | INTERESTS IN CLOSELY HELD BUSINESS
 |  |  |  |  |  |  | Registered in |  | Source and Date |  | Total
Description |  |  |  | Value of Business |  |  | Name of |  | of Valuation |  | Value
 |  |  |  | 0 |  |  |  |  |  | 1
 |  |  |  | 0 |  |  |  |  |  | 1
Section 3 |  |  |  | TAXES
 |  |  |  |  |  |  | Amount of Tax | Amount of Tax
 |  |  |  |  |  |  | Refund Due | Owed
Section 4 |  |  |  | LIFE INSURANCE
 |  |  |  |  |  |  |  |  |  |  |  | Location of
Insured |  |  |  | Primary Beneficiary |  |  | Face Amount | Actual Cash Value | Loans on Policy | Name of Company |  | Office
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | Total
Section 5 |  |  |  | ACCOUNTS AND NOTES RECEIVABLE
 |  |  |  |  |  |  |  |  |  |  | How Payable
Owners |  |  | Due From |  | Address |  |  | Collateral | Maturity Date |  | $  per month | Balance Due
Section 6 |  |  |  | REAL ESTATE OWNED
 |  |  |  | Property A |  |  | Property B |  | Property C |  | Property D
Type of Property
Address
Owner
Date Purchased
Original Cost
Present Market Value
Mortgage Holder
Annual Taxes
Monthly Income
Monthly Payments
Mortgage Balance
Section 7 |  |  |  | OTHER ASSETS AND PERSONAL PROPERTY
Automobiles |  |  |  |  | RV / Boats
Year/Make |  |  | Value |  | Year/Make |  | Value | Personal Prop. | Value |  | Totals
 |  |  |  |  |  |  |  | Furniture |  |  | Autos
 |  |  |  |  |  |  |  | Jewelry |  |  | R/V's
 |  |  |  |  |  |  |  | Equipment |  |  | Per. Prop.
 |  |  |  |  |  |  |  | Others
Subtotal Autos |  |  |  |  | Subtotal R/V's |  |  | Subtotal per. [NAME] |  |  | Total-oth. assets
Type of Property
Primary Residence
Residential Rental Property
Undeveloped Land
Commercial Property
Registered in Name Of
Spreadsheet: 682949d1592406124-lookup-if-cell-contains-targeted-text-lookup-if-contains
Sheet: Sheet1

 | Name1, Surname1, Middlename1 |  |  |  | Name1, Surname1 | Value1
 | Name2, Surname2, Middlename2 |  |  |  | [NAME], Surname2 | Value2
 | Name3, Surname3, Middlename3 |  |  |  | Name3, Surname3 | Value3
 | Name4, Surname4, Middlename4 |  |  |  | Name4, Surname4 | Value4
 | Name5, Surname5, Middlename5 |  |  |  | Name5, Surname5 | Value5
Spreadsheet: 61912d1262811570-excel-2007-pivot-table-secondary-sort-pivot_sort_dummy
Sheet: Sheet4

 | Values
Row Labels | Sum of Last Week Sales | Sum of Last Week Sales in $s
AUR | 28 | 8
100035 - Citizen Printer AUR | 0 | 5
100040 - G3 AUR | 0 | 2
100034 - Chenbro PC AUR | 0 | 1
100038 - DIS-2 AUR (XM-28U, EX-3U) | 7 | 0
100043 - MP III Printer AUR | 3 | 0
100042 - LMC-2 AUR | 6 | 0
100039 - DPT-2 AUR (XM-28U, EX-3U) | 10 | 0
100044 - Pakon Film Scanner AUR | 1 | 0
100045 - Pakon Film Scanner Plus AUR | 0 | 0
100036 - Copal Printer AUR (Q8) | 1 | 0
100041 - FlyTech AUR | 0 | 0
Adapter | 15 | 687.93
200002 - SCSI to IDE Bridge Board Adapter (FRONTIER PIC USE) | 6 | 542.04
200001 - IDE to USB Bridge Board Adapter (KIS 785 USE) | 3 | 131.25
200349 - DVI-I Dual Link Male to HD15(VGA)Female Adapter (Gold Plated) | 6 | 14.64
200473 - ACDC to 4pin [NAME] (KIS 785 USE) | 0 | 0
200348 - PS2 to USB Adapter | 0 | 0
Grand Total | 43 | 695.93