tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120628d1315412429-compare-dates-using-2-conditions-reddwarf_book1
Sheet: Sheet1

ID | Date | Type | Test |  | Row no for testing only, can be deleted. |  | Check formula reducing range to test 2003 > | ID | Date | Type | Test
1 | 2010-01-31 00:00:00 | A |  |  | 5 |  |  | 1 | 2010-01-31 00:00:00 | A
1 | 2011-12-31 00:00:00 | A |  |  | 5 |  |  | 1 | 2011-12-31 00:00:00 | A
1 | 2011-12-31 00:00:00 | C | No |  | 5 |  |  | 1 | 2011-12-31 00:00:00 | C | No
1 | 2012-02-01 00:00:00 | I |  |  | 5 |  |  | 1 | 2012-02-01 00:00:00 | I
2 | 2012-02-28 00:00:00 | C | Yes |  | 7 |  |  | 2 | 2012-02-28 00:00:00 | C | Yes
2 | 2010-12-31 00:00:00 | I |  |  | 7 |  |  | 2 | 2010-12-31 00:00:00 | I
3 | 2011-11-30 00:00:00 | A |  |  | 10 |  |  | 3 | 2011-11-30 00:00:00 | A
3 | 2011-11-30 00:00:00 | C | Yes |  | 10 |  |  | 3 | 2011-11-30 00:00:00 | C | Yes
3 | 2011-03-31 00:00:00 | I |  |  | 10 |  |  | 3 | 2011-03-31 00:00:00 | I
4 | 2011-09-30 00:00:00 | C | Yes |  | 12 |  |  | 4 | 2011-09-30 00:00:00 | C | Yes
4 | 2011-04-30 00:00:00 | I |  |  | 12 |  |  | 4 | 2011-04-30 00:00:00 | I
5 | 2012-08-31 00:00:00 | C | Yes |  | 14 |  |  | 5 | 2012-08-31 00:00:00 | C | Yes
5 | 2011-03-31 00:00:00 | I |  |  | 14 |  |  | 5 | 2011-03-31 00:00:00 | I
6 | 2011-10-31 00:00:00 | C | Yes |  | 16 |  |  | 6 | 2011-10-31 00:00:00 | C | Yes
6 | 2011-04-30 00:00:00 | I |  |  | 16 |  |  | 6 | 2011-04-30 00:00:00 | I
7 | 2011-12-31 00:00:00 | A |  |  | 21 |  |  | 7 | 2011-12-31 00:00:00 | A
7 | 2011-12-31 00:00:00 | A |  |  | 21 |  |  | 7 | 2011-12-31 00:00:00 | A
7 | 2011-12-31 00:00:00 | A |  |  | 21 |  |  | 7 | 2011-12-31 00:00:00 | A
7 | 2011-12-31 00:00:00 | C | No |  | 21 |  |  | 7 | 2011-12-31 00:00:00 | C | No
7 | 2011-12-31 00:00:00 |  |  |  | 21 |  |  | 7 | 2011-12-31 00:00:00
8 | 2011-05-31 00:00:00 | A |  |  | 24 |  |  | 8 | 2011-05-31 00:00:00 | A
8 | 2011-05-31 00:00:00 | C | Yes |  | 24 |  |  | 8 | 2011-05-31 00:00:00 | C | Yes
8 | 2011-03-31 00:00:00 |  |  |  | 24 |  |  | 8 | 2011-03-31 00:00:00
Spreadsheet: 713197d1610588222-filter-range-based-on-unique-values-in-a-column-sample-1-
Sheet: Sheet1

Name | Service | Number | Department
George | Cable | 10 | AC
George | Phone | 10 | AC
[NAME] | Phone | 9 | DP
[NAME] | Internet | 9 | DP
Result:
Name | Service | Number
Spreadsheet: 837140d1689876186-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: PAlfredL

D | CP | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
False | 75000 | 6.15352395749281 | 12.30704791498562 | 18.46057187247843 | 24.61409582997124 | 30.76761978746405 | 36.92114374495686 | 43.07466770244967 | 49.22819165994248 | 55.38171561743529 | 61.5352395749281 | 67.68876353242091 | 73.84228748991373 | 79.99581144740654 | 86.14933540489935 | 92.30285936239216 | 98.45638331988496
False | 76000 | 2.247050913767203 | 4.494101827534407 | 6.74115274130161 | 8.988203655068814 | 11.23525456883602 | 13.48230548260322 | 15.72935639637042 | 17.97640731013763 | 20.22345822390483 | 22.47050913767204 | 24.71756005143924 | 26.96461096520644 | 29.21166187897364 | 31.45871279274085 | 33.70576370650805 | 35.95281462027526
False | 77000 | 5.828121324395612 | 11.65624264879122 | 17.48436397318684 | 23.31248529758245 | 29.14060662197806 | 34.96872794637368 | 40.79684927076929 | 46.6249705951649 | 52.45309191956051 | 58.28121324395612 | 64.10933456835173 | 69.93745589274735 | 75.76557721714296 | 81.59369854153857 | 87.42181986593418 | 93.24994119032979
False | 78000 | 2.391806242474926 | 4.783612484949852 | 7.175418727424779 | 9.567224969899705 | 11.95903121237463 | 14.35083745484956 | 16.74264369732448 | 19.13444993979941 | 21.52625618227434 | 23.91806242474926 | 26.30986866722419 | 28.70167490969911 | 31.09348115217404 | 33.48528739464896 | 35.87709363712389 | 38.26889987959882
False | 79000 | 2.229832588543999 | 4.459665177087999 | 6.689497765631998 | 8.919330354175997 | 11.14916294272 | 13.378995531264 | 15.608828119808 | 17.83866070835199 | 20.06849329689599 | 22.29832588543999 | 24.52815847398399 | 26.75799106252799 | 28.98782365107199 | 31.21765623961599 | 33.44748882815999 | 35.67732141670399
False | 80000 | 0.8157436001246776 | 1.631487200249355 | 2.447230800374033 | 3.26297440049871 | 4.078718000623388 | 4.894461600748066 | 5.710205200872744 | 6.525948800997421 | 7.341692401122098 | 8.157436001246776 | 8.973179601371454 | 9.788923201496132 | 10.60466680162081 | 11.42041040174549 | 12.23615400187016 | 13.05189760199484
Spreadsheet: 150344d1334443358-song-competition-ranking-order-and-breaking-ties-tony-song-list-test-formulae
Sheet: Sheet1

 | artist | song | [NAME] | [NAME] | [NAME] | pete | Total | Rank Helper Column | rank
1 | artist 1 | song 1 | 3 | 3 | 1 | 4 | 11 | 4.03030102 | 11 |  | 4 | 3 | 3 | 1
2 | artist 2 | song 2 | 5 | 5 | 3 | 5 | 18 | 5.05050303 | 8 |  | 5 | 5 | 5 | 3
3 | artist 3 | song 3 | 6 | 8 | 6 | 7 | 27 | 8.070606040000001 | 3 |  | 8 | 7 | 6 | 6
4 | artist 4 | song 4 | 5 | 3 | 5 | 4 | 17 | 5.05040305 | 10 |  | 5 | 5 | 4 | 3
5 | artist 5 | song 5 | 1 | 1 | 0 | 3 | 5 | 3.01010006 | 12 |  | 3 | 1 | 1 | 0
6 | artist 6 | song 6 | 3 | 4 | 4 | 6 | 17 | 6.04040307 | 7 |  | 6 | 4 | 4 | 3
7 | artist 7 | song 7 | 5 | 4 | 4 | 5 | 18 | 5.05040408 | 9 |  | 5 | 5 | 4 | 4
8 | artist 8 | song 8 | 7 | 6 | 5 | 4 | 22 | 7.060504089999999 | 5 |  | 7 | 6 | 5 | 4
9 | artist 9 | song 9 | 5 | 7 | 6 | 9 | 27 | 9.0706051 | 1 |  | 9 | 7 | 6 | 5
10 | artist 10 | song 10 | 7 | 5 | 8 | 8 | 28 | 8.08070511 | 2 |  | 8 | 8 | 7 | 5
11 | artist 11 | song 11 | 6 | 2 | 2 | 6 | 16 | 6.06020212 | 6 |  | 6 | 6 | 2 | 2
12 | artist 12 | song 12 | 6 | 3 | 6 | 7 | 22 | 7.060603130000001 | 4 |  | 7 | 6 | 6 | 3
 |  |  |  |  |  |  |  |  |  |  | Hide them
Spreadsheet: 78e860fe-a9a6-4af5-a013-6333059056c6
Sheet: Protected Areas

Ecoregion | Protected Area (km^2) | Total Area (km^2) | Percentage of Ecoregion Managed as Protected Area
Boreal Transition | 376.448506 | 43628.664175 | 0.8628467387633465
Clear Hills Upland | 803.0644551 | 23511.213161 | 3.415665748937659
Mid-Boreal Uplands | 10122.905544 | 87915.437857 | 11.51436629419459
Peace Lowland | 1022.000264 | 60130.902706 | 1.699625679988374
Slave River Lowland | 27169.282306 | 34782.420277 | 78.11210976588016
[NAME] | 3161.761738 | 51569.153636 | 6.131110392691805
Western Alberta Upland | 584.7990314 | 68474.934948 | 0.8540337159050937
Western Boreal | 31.23354613 | 11393.160189 | 0.2741429560531917
Alberta's Boreal Plains Ecozone | 43271.495391 | 381405.886949 | 11.34526153676964
Spreadsheet: 17831d7c-ca78-4f19-b9d4-7900341d4df8
Sheet: Sheet1

Age | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  | female | male
Sex
 |  |  | yes | no | no answer
Children under 16
 |  |  | none | primary | secondary | higher | no answer
Education level
Attitude statements |  |  | agree | disagree | don’t know | no answer
 | Eat healthy diet
 | Serious health problems
 | Minimize fat
 | Good health
 | Too much pressure healthy eating
 | Minimize salt
 | Know how much salt contains food
 | Sufficient nutritional information on label
 |  |  | never | rarely | sometimes | often | always | don’t know
1. Frequency adding salt at the table
 |  |  | never | rarely | sometimes | often | always | don’t know
2. Frequency adding salt when cooking
 |  |  | too much | right amount | too little | don’t know | no answer
3. Salt consumption
4. Health problem caused by salt
 | high blood pressure
 | osteoporosis
 | stomach cancer
 | kidney stones
 | heart attack/heart failure
 | stroke
 | asthma
 | other
 | none
 | don’t know
 | no answer
5. Diseases |  |  | yes | no | don’t know | no answer
 | High blood pressure
 | Heart attack
 | Stroke
 | Kidney stones
 | Asthma
 | Osteoporosis
 | Stomach cancer
 |  |  | not at all | somewhat | very | don’t know | no answer
6. Importance limiting salt consumption
7. What is done to control of salt/sodium intake
 |  |  | yes | no | don’t know | no answer
8. Knowledge recommended salt/sodium intake
9. Amount indicated (incl. unit)
ONLY IF 8 = yes
 |  |  | yes | no | don’t know | no answer
10. Knowledge of difference salt/sodium
11. Difference between salt & sodium
ONLY IF 10 = yes
 |  |  | always | often | sometimes | rarely | never | don’t know | no answer
12. Paying attention to labels?
 |  |  | always | often | sometimes | rarely | never | don’t know | no answer
13. Frequency reading nutrition labels
 |  |  | salt | sodium | salt & sodium | don’t know | no answer
14. Preference salt vs. sodium vs. salt&sodium
15. Reason for preference
 |  |  | yes | no | don’t know | no answer
16. Preference high/medium/low labeling
 |  |  | yes | no | don’t know | no answer
17. Preference clear warning label
 |  |  | yes | no | don’t know | no answer
18. Preference amounts in (milli)grams
 |  |  | yes | no | don’t know | no answer
19. Preference amounts in percentages DRV
 |  |  | per portion | per 100 gr | total amount | don’t know | no answer
20. Preference per portion or total amount
21. Comments
Spreadsheet: 126645d1319805811-pivot-table-has-2-fridays-instead-of-1-comprehensive-data-analysis
Sheet: OVERALL

 | Averages | [NAME] | Min
Tot Equifax | 33933.19642857143 | 43599 | 20641
Tot Experian | 32249.66071428571 | 41908 | 19264
Tot Succ Equifax | 13649.83928571429 | 18317 | 8341
Tot Succ Experian | 10502.64285714286 | 13823 | 6417
Tot Succ TransUnion | 5104.517857142857 | 11053 | 391
Tot TransUnion | 30431.91071428571 | 39860 | 18125
Tot Unfulfilled Equifax | 4449.982142857143 | 5684 | 2761
Tot Unfulfilled Experian | 6671.321428571428 | 8414 | 4183
Tot Unfulfilled Transunion | 11041.51785714286 | 24247 | 4072
Contact Us Page Hits | 3286.017857142857 | 4877 | 1507
FAQ Page Hits | 7379.303571428572 | 11041 | 4434
Gross Help Page Hits | 11037.125 | 16370 | 6181
Gross Landing Page Hits | 144950.6785714286 | 181776 | 92809
Gross Web Sessions | 137066.8392857143 | 170863 | 88175
Ineligible Page Hits | 0 | 0 | 0
Order Source Page Hits | 4031.553571428572 | 5437 | 2202
Privacy Policy Page Hits | 171.0535714285714 | 220 | 109
Progress Next Button | 27106.625 | 35876 | 16495
Progress Page Hits | 51419.82142857143 | 68061 | 31186
Request Form Page Hits | 84649.66071428571 | 110023 | 50476
Request Process Vol | 69429.46428571429 | 89405 | 41488
Security Policy Page Hits | 151.6428571428571 | 200 | 97
Select all 3 CRA | 28726.80357142857 | 37715 | 17432
Select any 1 CRA | 35666.48214285714 | 45570 | 21322
Select any 2 CRA | 5036.178571428572 | 8156 | 2734
[NAME] | 45199.83928571428 | 58122 | 27224
Select Experian | 44331.55357142857 | 57261 | 26434
Select Mail Source | 844.8214285714286 | 1115 | 444
Select Phone Source | 2782.803571428572 | 3863 | 1542
Select TransUnion | 42387.85714285714 | 55572 | 25428
State Eligible from [NAME] | 3076.178571428572 | 4186 | 1730
State Eligible-Landing | 81573.48214285714 | 105837 | 48746
State Ineligible from Order | 0 | 0 | 0
State Ineligible-Landing | 0 | 0 | 0
Submit Counts | 69364.91071428571 | 89314 | 41443
Tot No Requests Returned | 45194.94642857143 | 59361 | 26844
Tot Succ Transactions | 29257 | 40151 | 15939
Tot Unfulfilled Online Transactions | 22162.82142857143 | 37830 | 11016
Total Connects - Eligible States | 84649.66071428571 | 110023 | 50476
Total Connects - Ineligible States | 0 | 0 | 0
Total Delivered Request Transaction | 96614.76785714286 | 125367 | 58030
Unique Web Sessions | 131132.3571428571 | 163899 | 84035
Use of Site Page Hits | 49.10714285714285 | 66 | 29
Gross CRA Select Page Visits | 69364.91071428571 | 89314 | 41443
Spreadsheet: 80175d1280375965-multi-condition-formula-sample-workbook
Sheet: Battalion Perstat

Battalion PERSTAT
Last Name | First Name | Position | ORG | Location | Status
Betteridge | Randall | Sustainment Mechanic | RRAD | Al Asad | R&R
Champion | Antoine | SAMS-E Operator | JLI | Al Asad | Duty
[NAME] | [NAME] | QA / QC Representative | RRAD | Tallil | Duty
Guillory | Jermaine | Supply Tech | JLI | Liberty | R&R
[NAME] | [NAME] | PBUSE Technician | Honeywell | Liberty | Duty
Hulin | Gregory | SPAWAR C4I FSR | EMA | Balad | Duty
Iran | [NAME] | Mechanic | RRAD | Tallil | Duty
[NAME] | [NAME] | Safety Tech | JLI | PM FWD HQ | TDY
[NAME] | Reginald | Sustainment Mechanic | RRAD | Speicher | Duty
Marsh | [NAME] | SPAWAR C4I FSR | EMA | Balad | TDY
[NAME] | [NAME] | IT Coordinator | JLI | PM FWD HQ | Duty
Schultz | [NAME] | Site Property Book Technician | JLI | Al Asad | Duty
Spreadsheet: 696938d1601044624-vlookup-and-match-problem-vlookup-and-match
Sheet: Detail

Description | Amount | Date | Company
1st Prov Tax | 31685 | 2020-03-31 00:00:00 | BR1
2 nd Prov Tax | 0 | 2020-09-30 00:00:00 | BR1
1st Prov Tax | 55684 | 2020-03-31 00:00:00 | BR2
2 nd Prov Tax | 0 | 2020-09-30 00:00:00 | BR2
 | 0
Spreadsheet: 60988d1261572926-excel-2007-if-formulas-how-to-ask-3-questions-book1
Sheet: Sched

MEETING | DAY | SPECIAL
METRO | Weekend |  | 2 | 1.1 | 10 | 5
METRO | Weekend | Special | 2 | 1.1 | 10 | 5
COUNTRY | Weekdays |  | 2 | 1.1 | 10 | 5
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekend | Special | 2 | 1.1 | 10 | 5
COUNTRY | Weekend | Special | 2 | 1.1 | 10 | 5
COUNTRY | Weekend |  | 2 | 1.1 | 10 | 5
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
 |  |  |  |  |  |  |  |  |  | TOTAL
ALL | All | None |  |  | 10 | 5
The blue cells are where I need the formula. The above shows I have set the Criteria cells for each column to All, All, & None. This should get the data (User defined value of $10) from Cell F10 into all cells for column F & the data from G10 (User defined value of $5) into all cells for colum [NAME]
BUT, If I want to see only the Metro Weekend total I would change the values in the Criteria cells (Yellow cells Column A, B & C) as follows;
METRO | Weekend |  | 2 | 1.1 | 10 | 5
METRO | Weekend |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekdays |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1
COUNTRY | Weekend | Special | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1
METRO | Weekend | None |  |  | 10 | 5
Similarly, If I want to see Weekend & weekday for Metro total I would change the values in the Criteria cells (Yellow cells Column A, B & C) as follows;
METRO | Weekend |  | 2 | 1.1 | 10 | 5
METRO | Weekend |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekdays |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekend | Special | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
METRO | All | None |  |  | 10 | 5
And, If I want to see only weekends for Metro & Country total I would change the values in the Criteria cells (Yellow cells Column A, B & C) as follows;
METRO | Weekend |  | 2 | 1.1 | 10 | 5
METRO | Weekend |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekdays |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekend | Special | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
ALL | Weekend | None |  |  | 10 | 5
ETC ETC ETC for all combinations.
Finally, if I want to see only the total for "Specials" I would do this;
METRO | Weekend |  | 2 | 1.1 | 10 | 5
METRO | Weekend |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekdays |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
COUNTRY | Weekend | Special | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
COUNTRY | Weekend |  | 2 | 1.1
METRO | Weekdays |  | 2 | 1.1 | 10 | 5
None | All | Special |  |  | 10 | 5
Spreadsheet: 671961d1586634981-indirect-problem-when-opening-the-document-indirect-problem
Sheet: Bank info

Account no | Verification no |  |  |  | Invoice no |  | Amount
-------------------------
4206 | Food
 |  |  |  |  |  |  | 0
 | D 251 |  |  |  | Invoice 121 |  | 882
-------------------------
 |  |  |  |  |  |  | 882
 |  |  |  |  |  |  | 882
-------------------------
4215 | Rent
 |  |  |  |  |  |  | 0
 | K 97 |  |  |  | Invoice 234 |  | 2179.49
-------------------------
 |  |  |  |  |  |  | 2179.49
 |  |  |  |  |  |  | 2179.49
-------------------------
4221 | Extra
 |  |  |  |  |  |  | 0
 | D 64 |  |  |  | Invoice 293 |  | 2342.34
 | K 97 |  |  |  | Invoice 301 |  | 2869.32
 | D 64 |  |  |  | Invoice 382 |  | 1253.76
 | K 97 |  |  |  | Invoice 568 |  | 345.43
 | D 64 |  |  |  | Invoice 432 |  | 294.64
 | K 97 |  |  |  | Invoice 654 |  | 1837.54
-------------------------
 |  |  |  |  |  |  | 2132.18
 |  |  |  |  |  |  | 2132.18
-------------------------
4225 | Production
 |  |  |  |  |  |  | 0
 | D 69 |  |  |  | Invoice 870 |  | 2055.79
 | D 306 |  |  |  | Invoice 291 |  | 1327.31
-------------------------
Spreadsheet: 753464d1635451108-get-player-id-of-weekly-ranks-sample-match
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week
 |  | WEEKLY RANKS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  | 1
 | ID | 2021-05-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | ID |  | Week 18 result
 | 1 | 13 | 12 | 7 | 4 | 3 | 4 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 3 | 2 | 2 | 3 | 2 |  | 1 |  |  | 18
 | 2 | 7 | 13 | 14 | 7 | 9 | 8 | 9 | 11 | 10 | 9 | 13 | 9 | 12 | 14 | 16 | 15 | 11 | 14 | 13 | 18 |  |  |  |  | 1
 | 3 | 3 | 2 | 3 | 5 | 5 | 1 | 2 | 4 | 4 | 2 | 3 | 4 | 6 | 5 | 3 | 2 | 1 | 3 | 2 | 1 |  |  |  |  | 3
 | 4 | 14 | 16 | 15 | 9 | 11 | 17 | 10 | 7 | 11 | 10 | 6 | 7 | 7 | 7 | 8 | 9 | 9 | 6 | 6 | 5 |  |  |  |  | 6
 | 5 | 4 | 7 | 5 | 8 | 10 | 16 | 13 | 16 | 14 | 17 | 15 | 11 | 14 | 15 | 12 | 10 | 10 | 11 | 16 | 19 |  |  |  |  | 11
 | 6 | 8 | 3 | 1 | 2 | 4 | 5 | 5 | 3 | 3 | 3 | 5 | 5 | 4 | 4 | 6 | 6 | 4 | 4 | 5 | 6 |  |  |  |  | 4
 | 7 | 17 | 18 | 16 | 17 | 12 | 11 | 8 | 9 | 7 | 12 | 14 | 17 | 17 | 17 | 18 | 17 | 19 | 19 | 18 | 13 |  |  |  |  | 10
 | 8 | 9 | 8 | 9 | 15 | 17 | 18 | 19 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |  |  |  |  | 19
 | 9 | 10 | 4 | 10 | 11 | 7 | 7 | 12 | 15 | 12 | 11 | 7 | 12 | 16 | 16 | 15 | 16 | 16 | 17 | 19 | 14 |  |  |  |  | 12
 | 10 | 15 | 17 | 20 | 19 | 19 | 19 | 20 | 17 | 17 | 13 | 16 | 15 | 8 | 8 | 9 | 7 | 6 | 7 | 8 | 9 |  |  |  |  | 15
 | 11 | 5 | 11 | 13 | 13 | 16 | 10 | 7 | 10 | 8 | 7 | 8 | 6 | 5 | 6 | 5 | 4 | 5 | 5 | 4 | 3 |  |  |  |  | 5
 | 12 | 1 | 5 | 4 | 1 | 1 | 2 | 4 | 2 | 6 | 6 | 9 | 13 | 15 | 12 | 10 | 11 | 12 | 9 | 7 | 7 |  |  |  |  | 17
 | 13 | 19 | 15 | 17 | 14 | 18 | 15 | 11 | 8 | 13 | 14 | 11 | 10 | 9 | 13 | 11 | 14 | 15 | 13 | 17 | 12 |  |  |  |  | 13
 | 14 | 20 | 20 | 19 | 20 | 20 | 20 | 16 | 12 | 9 | 8 | 12 | 16 | 13 | 11 | 14 | 13 | 14 | 15 | 14 | 16 |  |  |  |  | 2
 | 15 | 2 | 1 | 2 | 6 | 8 | 9 | 14 | 18 | 18 | 16 | 10 | 8 | 10 | 9 | 7 | 8 | 8 | 10 | 11 | 15 |  |  |  |  | 14
 | 16 | 6 | 10 | 12 | 16 | 13 | 12 | 17 | 14 | 15 | 18 | 18 | 18 | 18 | 18 | 19 | 19 | 18 | 18 | 12 | 10 |  |  |  |  | 20
 | 17 | 16 | 19 | 18 | 18 | 14 | 13 | 15 | 13 | 16 | 15 | 17 | 14 | 11 | 10 | 13 | 12 | 13 | 12 | 10 | 17 |  |  |  |  | 9
 | 18 | 11 | 6 | 8 | 10 | 6 | 6 | 3 | 6 | 5 | 4 | 2 | 3 | 2 | 2 | 1 | 1 | 3 | 1 | 1 | 4 |  |  |  |  | 16
 | 19 | 12 | 9 | 6 | 3 | 2 | 3 | 6 | 5 | 2 | 5 | 4 | 1 | 3 | 3 | 4 | 5 | 7 | 8 | 9 | 8 |  |  |  |  | 7
 | 20 | 18 | 14 | 11 | 12 | 15 | 14 | 18 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 17 | 18 | 17 | 16 | 15 | 11 |  |  |  |  | 8
Spreadsheet: 585509d1533802701-variable-array-sum-if-sample-sheet
Sheet: Sheet1

 | As Of: | 2018-01-08 00:00:00 |  |  | 2018-01-01 00:00:00 | 2018-01-02 00:00:00 | 2018-01-03 00:00:00 | 2018-01-04 00:00:00 | 2018-01-05 00:00:00 | 2018-01-06 00:00:00 | 2018-01-07 00:00:00 | 2018-01-08 00:00:00 | 2018-01-09 00:00:00 | 2018-01-10 00:00:00 | 2018-01-11 00:00:00 | 2018-01-12 00:00:00
 | PLAN |  |  |  | 10
 | ACTUAL
Spreadsheet: kate_symes__18777__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
Spreadsheet: 704237d1605458466-retrieving-annual-returins-using-lookup-functions-in-big-data-lists-excel-test-function-123
Sheet: Sheet1

 |  |  |  | A | B | C
 |  |  | 2017
 |  |  | 2018
 |  |  | 2019
 |  | A | B | C
 | 2017-01-01 00:00:00 | 100 | 100 | 100
Spreadsheet: 539004d1505921104-hello-i-am-stuck-and-i-need-help-with-if-and-vlookup-formulas-need-help-valley-pl-excel-help
Sheet: Valley April

Valley | # 06382
1001 · Rent-NNN | 4322
1002 · Electricity | 0
1003 · S & U Taxes
1004 · Credit Card Fees | 0
1005 · Property Tax | 381.52
1006 · [NAME] | 0
1007 · [NAME] | 471.4
1008 · Personal Note | 597.87
1009 · Payroll | 0
1010 · Payroll Tax | 0
1011 · Bargreen
1012 · [NAME] | 0
1013 · [NAME] | 0
1014 · Uniforms | 0
1015 · Bank Fees | 0
1016 · Gas | 0
1017 · Telephone/Internet | 0
1018 · Trash | 0
1019 · Landscaping | 0
1020 · Water/Sewer | 0
1021 · Total Insurance/WC | 199.81
1022 · Office Supplies | 0
1023 · Pest Control | 53.64
1024 · Muzak
1025 · Local Advertising/ML | 403.04
1026 · Security | 26.03
1027 · CPA & Legal | 0
1028 · Permits | 0
1029 · [NAME] | 0
1030 · Credit Card Payments | 0
Total Expenses:
Sales | 36679
Total Revenue | 0
Food Costs | 0
Royalty | 0
Advertisement | 0
Sales Tax | 0
Gross Income
Overhead
Payroll %
Food Costs %
Net Income (Monthly)
Combined Monthly Net Income
Spreadsheet: 827210d1682543740-parsing-data-set-with-index-match-or-another-method-test
Sheet: Data Set

 | Data set
 | Company | Division | Status
 | Microsoft | Office | Backlog
 | Microsoft | Windows | In-Progress
 | Intel | Hardware | Backlog
 | Intel | Software | Complete
 | Intel | MobilEye | In-Progress
 | AMD | Hardware | On Hold
 | Tesla | Automotive | In-Progress
 | Telsa | Space | On Hold
 | Adobe | Photoshop | Complete
 | Adobe | Lightroom | Complete
 | Adobe | [NAME] | In-Progress
Spreadsheet: 838926d1691520659-averageifs-with-isformula-averageifs-help
Sheet: Current

time/date | a(%) | b(%) | c(%) | [NAME])
2020-01-23 12:15:07 | 95.8077 | 2.7815 | 1.410800000000003
2020-01-24 12:15:00 | 95.4539 | 2.557 | 1.989099999999996
2020-01-29 10:30:00 | 96.1821 | 2.4956 | 1.322299999999994 | 0.63
2020-02-05 10:05:00 | 96.1561 | 2.6413 | 1.202600000000005 | 0.37
2020-02-12 11:30:00 | 94.4905 | 3.9694 | 1.540100000000003
2020-02-19 10:00:48 | 96.5018 | 2.161 | 1.337199999999997 | 2.873
2020-02-26 11:40:00 | 96.8241 | 1.9614 | 1.214499999999999 | 0.07
2020-03-06 15:15:00 | 96.9922 | 1.4135 | 1.594300000000003 | 0.83
2020-03-11 13:05:00 | 95.9704 | 1.9137 | 2.115900000000002 | 1.05
2020-03-18 10:10:49 | 96.472 | 1.9753 | 1.552700000000006
2020-03-25 08:55:00 | 93.5054 | 4.8329 | 1.661700000000005 | 0.66
2020-05-10 22:35:00 | 33.47 | 0.5 | 66.03 | 0.62
2020-05-13 12:30:37 | 0 | 0 | 100 | 0
2020-06-02 12:30:00 | 97.2685 | 1.343