tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73114d1273763463-maximum-number-of-if-fomulas-in-a-single-cell-test-130510
Sheet: Sheet1

Policy No. | Insured | Renewal Date | Last year's gross written premium (ACE portion) | Last Year's Renewal Premium | Type | Policy Type | Branch | Contact | Quoted Premium | Bound Y/N | Lost WS+ Premium | ACE % | ACE Forecast | Gross/Net | Current Insurer |  | Exposure Change | 24 hr PA rate (if appl) | Date Received | 1st Action | Quote Deadline | Date Quoted | Event Limit | Postcode | Best Doctors | Flagged MN | Comments/Status | Date Booked | Date Docs Issued | Bound Chk | Month | Forecast
UKBBBC37770 | ABC Ltd | 13/08/2009 | 112.21 | 224.46 | Ren | Travel Only | Birmingham | [NAME] | 142.42 | Y | 0 | 0.55 | 78.331 | N | Facility |  | no change |  | 2009-07-17 00:00:00 | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 | 2009-07-29 00:00:00 | N/A | DY2 8TA | Y |  |  | 2009-08-20 00:00:00 | Eurotrade 31/07/09 | RY | 8 | 78.331 |  |  | 12 | 7
UKBBBC37644 | 123 Corp | 01/08/2009 | 688 | 1376 | Ren | PA & Travel | [NAME] | Parwinder Pawar | 250 | Y | 0 | 0.55 | 137.5 | N | Facility |  | Only 1 employee covered |  | 2009-07-29 00:00:00 | 2009-07-29 00:00:00 | 2009-07-29 00:00:00 | 2009-07-29 00:00:00 | 15000000 | WA4 4HS | Y |  | business relocated to sweden, drastic reduction so offerig minimum premium | 2009-08-20 00:00:00 | Eurotrade 31/07/09 | RY | 8 | 137.5 |  |  | 0 | 19
UKBBBC34995 | Tech Ltd | 14/08/2009 | 142.07 | 537.5 | Ren | PA & Travel | [NAME] | Carly Bourne | 612.21 | Y | 0 | 0.55 | 336.7155 | G | Facility |  | > 10% |  | 2009-06-17 00:00:00 | 2009-06-29 00:00:00 | 2009-07-07 00:00:00 | 2009-06-19 00:00:00 | 10000000 | G52 4XB | Y |  |  | 2009-08-20 00:00:00 | Eurotrade 07/08/09 | RY | 8 | 336.7155 |  |  | 2 | 6
UKBBBC37839 | [NAME] | 19/08/2009 | 867.1 | 1734.22 | Ren | PA & Travel | [NAME] | [NAME] | 714.46 | Y | 0 | 0.55 | 392.953 | G | Facility |  | Travel down 35% |  | 2009-07-01 00:00:00 | 2009-07-02 00:00:00 | 2009-07-09 00:00:00 | 2009-07-03 00:00:00 | 15000000 | GU35 9QE | Y |  | Annual premium is 825.25, but pro ratering to cover until 30-09-2009 only | 2009-08-24 00:00:00 | Eurotrade 11/08/09 | RY | 8 | 392.953 |  |  | 2 | 5
UKBBBC37677 | AJH Limited | 01/08/2009 | 174.99 | 350 | Ren | Travel Only | Maidstone | [NAME] | 737.37 | Y | 0 | 0.55 | 405.5535 | N | Facility |  | TP up 58% |  | 2009-07-21 00:00:00 | 2009-07-21 00:00:00 | 2009-07-21 00:00:00 | 2009-07-21 00:00:00 | 0 | W12 7RR | Y |  |  | 2009-08-12 00:00:00 | Eurotrade 28/07/09 | RY | 8 | 405.5535 |  |  | 0 | 11
UKBBBC37610 | Resource GB Ltd | 01/08/2009 | 731 | 1462 | Ren | PA & Travel | Bristol | [NAME] | 988 | Y | 0 | 0.55 | 543.4 | N | Facility |  | down 33%, rate 0.1 |  | 2009-07-16 00:00:00 | 2009-07-21 00:00:00 | 17-07-20009 | 2009-07-21 00:00:00 | 10000000 | CF72 8PN | Y |  |  | 2009-08-12 00:00:00 | 2009-09-15 00:00:00 | RY | 8 | 543.4 |  |  | 5 | 11
Spreadsheet: 90670d1290453806-record-how-often-each-number-occurs-see-sample-sample-file
Sheet: Sheet1

number |  |  |  | Each # that occurred at least 1x |  | Number of occurrences |  | space between each occurrence
9 |  |  |  | 9 |  | 3 | # | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
7 |  |  |  | 7 |  | 3 |  | 14 | 13 | 3 | 11 | 10 | 5 | 4 | 2 | 26 | 1
2 |  |  |  | 2 |  | 4 |  |  | 9 | 4 | 10 | 9 | 4 | 12 | 4 |  | 7
6 |  |  |  | 6 |  | 3 |  |  |  | 17 |  | 4 | 3 | 1 | 14 |  | 7
5 |  |  |  | 5 |  | 4 |  |  |  | 3 |  | 2
7 |  |  |  | 4 |  | 4
2 |  |  |  | 3 |  | 2
9 |  |  |  | 1 |  | 2
5 |  |  |  | 0 |  | 1
4 |  |  |  | 2 |  | 4
3 |  |  |  | 8 |  | 1
5
1
0
9
6
6
5
4
7
3
1
4
2
4
8
2
Spreadsheet: sally_beck__33985__Weekly Operating Report 4-4 - Revised
Sheet: template from eol

EOL
 | Week ending 4th |  | Week ending 11th |  | Week ending 18 |  | Week ending 25 |  | Volumetric
New Deals for: | New Deals | Volume | New Deals | Volume | New Deals | Volume | New Deals | Volume | Units
EA
Gas | 8160 | 867868927 | 12264 | 1430792953 | 10083 | 878002281 | 13198 | 1733178545 | MMBTU
Power | 657 | 6392800 | 1630 | 15194425 | 1725 | 17506625 | 1546 | 14286440 | MHtz
EGM
Liquids | 840 | 20894000 | 1580 | 40911000 | 1052 | 25743000 | 1552 | 36444595 | BBL
Coal | 25 | 1054250 | 32 | 697000 | 21 | 677000 | 12 | 258000 | TONNE
Coal International | 4 | 153000 | 4 | 177000 | 11 | 465000 | 5 | 225000 | TONNE
Weather | 9 | 2700 | 8 | 2400 | 26 | 8400 | 13 | 3900 | HDD/CDD
IR/FX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | USD
Emissions | 2 | 5000 | 2 | 5000 | 10 | 25000 | 4 | 10000 | CONTRACTS
EIM
Pulp & Paper | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TONNE
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TONNE
Number of new EOL Counterparties | 5 |  | 7 |  | 7 |  | 14
Non-EOL
 | Week ending 4th |  | Week ending 11th |  | Week ending 18 |  | Week ending 25 |  | Volumetric
New Deals for: | New Deals | Volume | New Deals | Volume | New Deals | Volume | New Deals | Volume | Units
EA
Gas | 1993 | 890462662 | 3200 | 1770313517 | 2671 | 1064343180 | 3425 | 3219027521 | MMBTU
Power | 1073 | 9653441 | 1806 | 37468366 | 2056 | 30644030 | 2149 | 23302801 | MHtz
EGM
Liquids | 995 | 69536383 | 1678 | 131872348 | 1147 | 82109720 | 1511 | 114536993 | BBL
Coal | 8 | 691091 | 39 | 2157306 | 34 | 2376119.09 | 24 | 1716010 | TONNE
Coal International | 15 | 1089373 | 8 | 357627 | 18 | 1166000 | 34 | 1765000 | TONNE
Weather | 4 | 46550 | 19 | 42950 | 11 | 112500 | 23 | 111600 | HDD/CDD
IR/FX | 91 | 6275000 | 130 | 6398750 | 103 | 3718000 | 169 | 6618000 | USD
Emissions | 0 | 0 | 0 | 0 | 4 | 9100 | 9 | 97570 | CONTRACTS
EIM
Pulp & Paper | 29 | 59379.954 | 33 | 23310.969 | 31 | 213378.002 | 53 | 19114.955 | TONNE
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TONNE
Clickpaper
 | Week ending 4th |  | Week ending 11th |  | Week ending 18 |  | Week ending 25 |  | Volumetric
New Deals for: | New Deals | Volume | New Deals | Volume | New Deals | Volume | New Deals | Volume | Units
EIM
Lumber | 4 | 247000 | 9 | 492000 | 4 | 88000 | 2 | 220000 | Board Feet
Newsprint | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pulp (recycled paper) | 4 | 910 | 4 | 12450 | 1 | 20 | 0 | 0 | [NAME]
Number of new CP Counterparties | 1 |  | 1 |  | 0 |  | 0
Lumber Converted
EIM TOTAL
EOL
 | Week ending 4th |  | Week ending 11th |  | Week ending 18 |  | Week ending 25 |  | Volumetric
New Deals for: | New Deals | Volume | New Deals | Volume | New Deals | Volume | New Deals | Volume | Units
EA
Gas |  |  |  |  |  |  |  |  | MMBTU
Power |  |  |  |  |  |  |  |  | MHtz
EGM
Liquids |  |  |  |  |  |  |  |  | BBL
Coal |  |  |  |  |  |  |  |  | TONNE
Coal International |  |  |  |  |  |  |  |  | TONNE
Weather |  |  |  |  |  |  |  |  | HDD/CDD
IR/FX |  |  |  |  |  |  |  |  | USD
Emissions |  |  |  |  |  |  |  |  | CONTRACTS
EIM
Pulp & Paper |  |  |  |  |  |  |  |  | TONNE
Steel |  |  |  |  |  |  |  |  | TONNE
Spreadsheet: 762012d1641349025-unique-entries-keeping-only-one-with-a-labelled-word-copy-of-unique-entries-keeping-only-one-with-a-labelled-word
Sheet: Dateset

Raw Data | Uniq | labeled | one labeled | select | Unique entries, keeping only one with a labelled word |  | Word labels
 |  |  | or uniq |  | Example
I have a purple bottle |  |  |  |  |  |  | Purple
She eats Orange |  |  |  |  |  |  | Blue
She eats Orange |  |  |  |  |  |  | Orange
She eats Orange 12345
She eats Orange 77777
She eats Orange 99999
Blue is my favorite color
The grass is green
The grass is green 1234
 | Change formula if need
Spreadsheet: 0d25a036-1cc5-4a61-a6b2-2b525cb585e1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Child and Adult Care Food Program
Program Year Expenses
(Cumulative)
Program Name: |  |  |  |  |  | Date:
 | Month: |  |  |  | Year:
FY _____________ Expenses
Month | CACFP Food Expenses | CACFP Non-Food Expenses | CACFP Administrative Labor Expenses | CACFP Operating Labor Expenses | CACFP Other Expenses | CACFP Total/Month Expenses | Total CACFP Reimbursement | %
Example | 3500 | 250 | 2025 | 1115 | 500 | 7390 | 6532 | 0.5358236374770361
October |  |  |  |  |  | 0
November |  |  |  |  |  | 0
December |  |  |  |  |  | 0
January |  |  |  |  |  | 0
February |  |  |  |  |  | 0
March |  |  |  |  |  | 0
April |  |  |  |  |  | 0
May |  |  |  |  |  | 0
June |  |  |  |  |  | 0
July |  |  |  |  |  | 0
August |  |  |  |  |  | 0
September |  |  |  |  |  | 0
TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0
*Aim for at least 50% of your CACFP Reimbursement to be CACFP Food Expenses
Prepared By: |  |  |  |  |  | Date:
Spreadsheet: 54443d1254415747-how-to-combine-occurences-by-date-dummy-workbook
Sheet: Sheet1

 | Date | Term Mentioned
Article 1 | 2008-12-01 00:00:00 | 1
Article 2 | 2008-12-01 00:00:00 | 1
Article 3 | 2008-12-01 00:00:00 | 1
Article 4 | 2008-12-01 00:00:00 | 1
Article 5 | 2008-12-01 00:00:00 | 1
Article 6 | 2008-12-03 00:00:00 | 1
Article7 | 2008-12-05 00:00:00 | 1
Article 8 | 2008-12-09 00:00:00 | 1
Spreadsheet: 140846d1328907299-if-and-formula-to-display-numbers-and-text-vacation-allotments-dummy
Sheet: Jill

WHITBY FIRE & EMERGENCY SERVICES VACATION ALLOTMETS - 2012 - SUPPRESSION
EMPLOYEE NAME | FULL TIME START DATE | ENTITLEMENT (Weeks) | Qualify in Staring Year? | Total Years In Service | Qualifying Years (Vacation Time) | Month of Hire | Applicable Days  (If Hired before June 30) | # OF DAYS THIS YEAR (If Applicable) | # DAYS NEXT YEAR (If Applicable) | 2 WEEKS AFTER 1 YEAR | 3 WEEKS AFTER  3 YEARS | 4 WEEKS AFTER  8 YEARS | 5 WEEKS AFTER  18 YEARS | 6 WEEKS AFTER  25 YEARS
Name 1 | 1989-09-05 00:00:00 | 5 | No | 23 | 23 | 9 | - | 0 | 0 | 1991-09-05 00:00:00 | 1993-09-05 00:00:00 | 1998-09-05 00:00:00 | 2008-09-05 00:00:00 | 2015-09-05 00:00:00
Name 2 | 2000-11-06 00:00:00 | 4 | No | 12 | 12 | 11 | - | 0 | 0 | 2002-11-06 00:00:00 | 2004-11-06 00:00:00 | 2009-11-06 00:00:00 | 2019-11-06 00:00:00 | 2026-11-06 00:00:00
Name 3 | 1987-12-07 00:00:00 | 6 | No | 25 | 25 | 12 | - | 0 | 0 | 1989-12-07 00:00:00 | 1991-12-07 00:00:00 | 1996-12-07 00:00:00 | 2006-12-07 00:00:00 | 2013-12-07 00:00:00
Name 4 | 2001-10-01 00:00:00 | 4 | No | 11 | 11 | 10 | - | 0 | 0 | 2003-10-01 00:00:00 | 2005-10-01 00:00:00 | 2010-10-01 00:00:00 | 2020-10-01 00:00:00 | 2027-10-01 00:00:00
Name 5 | 2009-07-06 00:00:00 | 3 | No | 3 | 3 | 7 | - | 0 | 0 | 2011-07-06 00:00:00 | 2013-07-06 00:00:00 | 2018-07-06 00:00:00 | 2028-07-06 00:00:00 | 2035-07-06 00:00:00
Name 6 | 1985-10-07 00:00:00 | 6 | No | 27 | 27 | 10 | - | 0 | 0 | 1987-10-07 00:00:00 | 1989-10-07 00:00:00 | 1994-10-07 00:00:00 | 2004-10-07 00:00:00 | 2011-10-07 00:00:00
Name 7 | 2000-09-05 00:00:00 | 4 | No | 12 | 12 | 9 | - | 0 | 0 | 2002-09-05 00:00:00 | 2004-09-05 00:00:00 | 2009-09-05 00:00:00 | 2019-09-05 00:00:00 | 2026-09-05 00:00:00
Name 8 | 2012-05-01 00:00:00 | 2 | Yes | 0 | 1 | 5 | 2 | 2 | 0 | 2013-05-01 00:00:00 | 2015-05-01 00:00:00 | 2020-05-01 00:00:00 | 2030-05-01 00:00:00 | 2037-05-01 00:00:00
Name 9 | 2012-07-09 00:00:00 | - | No | 0 | 0 | 7 | - | - | 8 | 2014-07-09 00:00:00 | 2016-07-09 00:00:00 | 2021-07-09 00:00:00 | 2031-07-09 00:00:00 | 2038-07-09 00:00:00
Name 10 | 2012-04-03 00:00:00 | 3 | Yes | 0 | 1 | 4 | 3 | 3 | 0 | 2013-04-03 00:00:00 | 2015-04-03 00:00:00 | 2020-04-03 00:00:00 | 2030-04-03 00:00:00 | 2037-04-03 00:00:00
Name 11 | 2012-01-05 00:00:00 | 6 | Yes | 0 | 1 | 1 | 6 | 6 | 0 | 2013-01-05 00:00:00 | 2015-01-05 00:00:00 | 2020-01-05 00:00:00 | 2030-01-05 00:00:00 | 2037-01-05 00:00:00
Name 12 | 2012-03-04 00:00:00 | 4 | Yes | 0 | 1 | 3 | 4 | 4 | 0 | 2013-03-04 00:00:00 | 2015-03-04 00:00:00 | 2020-03-04 00:00:00 | 2030-03-04 00:00:00 | 2037-03-04 00:00:00
Name 13 | 2012-10-12 00:00:00 | - | No | 0 | 0 | 10 | - | - | 8 | 2014-10-12 00:00:00 | 2016-10-12 00:00:00 | 2021-10-12 00:00:00 | 2031-10-12 00:00:00 | 2038-10-12 00:00:00
Spreadsheet: 145607d1331661941-vlookup-copy-of-phys-dimension-scrub2-1
Sheet: Sheet2

 | Provider Dept # | Class
MP28 | 1 | 2009
MP28 | 2 | 2009
MP28 | 3 | 2006
MP28 | 5 | 2007
MP28 | 6 | 2009
ME28 | 7 | 2008
ME28 | 8 | 2004
MP28 | 9 | 2006
MP9 | 11 | 2009
MP9 | 12 | 2009
MP9 | 13 | 2006
MP28 | 14 | 2009
ME28 | 15 | NA
MP28 | 16 | 2008
MP28 | 17 | 2007
MP28 | 18 | 2008
MP28 | 19 | 2005
Spreadsheet: 142330d1329775442-determing-area-under-a-line-book1
Sheet: Sheet1

0 | 0
0 | 6
2 | 5
4 | 4
5 | 4
6 | -2
8 | -3
10 | -4
12 | -5
12 | 0
Spreadsheet: 142971d1330106013-drop-down-list-to-auto-populate-fields-and-multiplied-by-another-field-example
Sheet: Sheet1

 | Selection | Quantity
 | Food 1
 | Food 2
 | Food 3
 | Food 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food 1
 |  |  |  | Pizza | Tacos | Apples | Oranges |  |  |  |  |  |  |  |  |  |  | Food 2
 |  | Food 1 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | Food 3
 |  | Food 2 |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  | Food 4
 |  | Food 3 |  | X | X | X
 |  | Food 4 |  | X | X | X | X
Spreadsheet: 852375d1702428738-vlook-up-not-finding-what-i-am-looking-for-problem-snook-adj-
Sheet: Sheet1

Customer | Stock No. | Stock Item | Purchase Price | Sell Price
C1 | 50ht | 50mm Hook and Tail | 15.5 | 20.37
C2 | 102Bkl | 2nd side Buckle 250kgs capacity | 14.56 | 22.93
[NAME] | 106HS | 2nd type hookup 2.5m x 5mm with sleeper | 14.56 | 17.61
C4 | 106PB-5 | [NAME] 50mm | 30.89 | 38.71
C5 | 106PB-7 | [NAME] 70mm | 33.1 | 40.6
Spreadsheet: 800289d1665582777-formula-to-count-if-one-or-more-criteria-are-met-example-file-combine-failures
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | COUNTIF >= |  | COUNTIF >= |  | FILTER >= |  | FILTER >
 |  |  |  |  | a | 0.05
 |  |  |  |  | b | 0.06 | 0.07
 |  |  |  |  | c | 0.08 | 0.09 | 0.1
 |  |  |  |  | d | 0.03 | 0.02 | 0.04
I have the values in three columns G3, H3, I3. If the cell in column G3 value is above 5 the tests fails, if the cell in in column H3 value is above 5% it fails, and if the cell in in column I3 value is above 5% it fails. I can't get the formula to work that if one, two or all three fail, only count it as "1" in cell I1. I have about 120 tests to do, and I want to make sure the spreadsheet only counts a failed test once.
 |  |  |  |  |  |  |  |  |  | =IF(COUNTIF(G3:I3,">=5%"),1,0)
 |  |  |  |  |  |  |  |  |  |  |  | =IF(COUNTIF(G3:I3,">5%"),1,0)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(ROWS(FILTER(F:F,( F:F<>"")*((G:G>=5%)+(H:H>=5%)+(I:I>=5%)))),0)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(ROWS(FILTER(F:F,( F:F<>"")*((G:G>5%)+(H:H>5%)+(I:I>5%)))),0)
Spreadsheet: 78103d1278528090-sum-on-various-conditions-forum-example
Sheet: Sheet1

 |  |  |  |  |  |  |  | From | To
date | client | sports | profit/loss |  |  |  |  | 2010-04-01 00:00:00 | 2010-04-30 00:00:00
2010-04-01 00:00:00 | Smith | Football | -1000 |  | Football | -2900
2010-04-05 00:00:00 | Smith | Tennis | -500 |  | Tennis
2010-04-12 00:00:00 | Smith | Tennis | 0 |  | Darts
2010-04-13 00:00:00 | Smith | Tennis | 500 |  | Snooker
2010-04-14 00:00:00 | Smith | Tennis | 1000
2010-04-15 00:00:00 | Smith | Tennis | 1500
2010-04-16 00:00:00 | Jones | Tennis | 2000
2010-04-17 00:00:00 | Smith | Snooker | 2500
2010-04-18 00:00:00 | Jones | Snooker | 1000
2010-04-19 00:00:00 | Jones | Snooker | -500
2010-04-20 00:00:00 | Jones | Snooker | -2000
2010-04-21 00:00:00 | Jones | Snooker | -3500
2010-04-22 00:00:00 | Jones | Darts | -5000
2010-04-23 00:00:00 | Jones | Darts | 200
2010-04-24 00:00:00 | Jones | Darts | 5400
2010-04-25 00:00:00 | Jones | Darts | 2000
2010-04-26 00:00:00 | Jones | Darts | 500
2010-04-27 00:00:00 | Smith | Football | -1000
2010-04-28 00:00:00 | Smith | Football | -2500
2010-04-29 00:00:00 | Smith | Football | 3000
2010-04-30 00:00:00 | Jones | Football | 100
2010-05-01 00:00:00 | Jones | Football | 1000
2010-05-02 00:00:00 | Smith | Football | 2000
2010-05-03 00:00:00 | Smith | Football | 1500
2010-05-04 00:00:00 | Smith | Football | 1000
2010-05-05 00:00:00 | Smith | Football | -2000
Spreadsheet: 718123d1612993413-stat-tools-add-in-for-forecasting-hardware-sales-example
Sheet: Data

Week | Sales
1 | 1526
2 | 1929
3 | 1704
4 | 1423
5 | 1430
6 | 1410
7 | 1478
8 | 1698
9 | 2223
10 | 2420
11 | 1938
12 | 2053
13 | 2412
14 | 1939
15 | 2845
16 | 2290
17 | 2618
18 | 2309
19 | 2474
20 | 3038
21 | 2076
22 | 2967
23 | 2583
24 | 2484
25 | 2525
26 | 2500
27 | 2508
28 | 2254
29 | 1862
30 | 2021
31 | 2594
32 | 2080
33 | 1396
34 | 1858
35 | 1867
36 | 1923
37 | 1736
38 | 2111
39 | 1642
40 | 2428
41 | 2071
42 | 2020
43 | 1973
44 | 2486
45 | 2292
46 | 2216
47 | 2473
48 | 2996
49 | 2548
50 | 2637
51 | 2412
52 | 2084
53 | 2676
54 | 1988
55 | 2202
56 | 2428
57 | 2012
58 | 2305
59 | 2060
60 | 2044
61 | 2641
62 | 2402
63 | 2346
64 | 2282
65 | 2686
66 | 2706
67 | 2196
68 | 2576
69 | 1972
70 | 2097
71 | 1953
72 | 2119
73 | 2085
74 | 2364
75 | 1648
76 | 1903
77 | 2055
78 | 2277
79 | 2191
80 | 1735
81 | 1969
82 | 2456
83 | 1842
84 | 2198
85 | 2074
86 | 1842
87 | 2611
88 | 1629
89 | 1517
90 | 1378
91 | 1448
92 | 2196
93 | 2053
94 | 2170
95 | 1755
96 | 2056
97 | 2152
98 | 1069
99 | 1306
100 | 1302
101 | 2361
102 | 1658
103 | 1903
104 | 1702
Spreadsheet: 824036d1680259429-formula-to-pick-up-data-dependent-on-multiple-variables-test1-beamer
Sheet: Sheet1

Date | Period | Account | Forecast | Owner | Qty | Cost |  |  | Period | Q1
2023-03-01 00:00:00 | Q1 | a | Yes | [NAME] | 1 | 500 |  |  | Account | All
2023-03-01 00:00:00 | Q1 | a | Yes | [NAME] | 1 | 750 |  |  | Forecast | All
2023-03-01 00:00:00 | Q1 | b | No | Graeme | 1 | 45 |  |  | Owner | All
2023-03-01 00:00:00 | Q2 | a | No | [NAME] | 1 | 86 |  |  | Date | 2023-03-01 00:00:00
2023-03-01 00:00:00 | Q3 | c | Yes | [NAME] | 1 | 99
2023-03-01 00:00:00 | Q4 | a | No | Sophie | 1 | 245 |  |  |  |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  | Q1 | Q2 | Q3 | Q4 | Total
2023-03-02 00:00:00 | Q1 | a | Yes | [NAME] | 1 | 600 |  |  |  |  | Account |  |  |  |  |  |  | Account
2023-03-02 00:00:00 | Q4 | a | Yes | [NAME] | 1 | 750 |  |  |  |  | a |  |  |  |  |  |  | a
2023-03-02 00:00:00 | Q2 | b | Yes | Graeme | 1 | 65 |  |  |  |  | b |  |  |  |  |  |  | b
2023-03-02 00:00:00 | Q2 | a | No | [NAME] | 1 | 86 |  |  |  |  | c |  |  |  |  |  |  | c
2023-03-02 00:00:00 | Q3 | c | Yes | [NAME] | 1 | 99 |  |  |  |  | Total |  |  |  |  |  |  | Total
2023-03-02 00:00:00 | Q4 | a | No | [NAME] | 1 | 245
 |  |  |  |  |  |  |  |  |  |  | Forecast |  |  |  |  |  |  | Forecast
 |  |  |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Owner |  |  |  |  |  |  | Owner
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Graeme |  |  |  |  |  |  | Graeme
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Sophie |  |  |  |  |  |  | Sophie
 |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
Spreadsheet: 218959d1362619844-formula-check-counting-the-number-of-0s-in-a-array-test3
Sheet: Sheet1

1 | Active |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
1 | Active
1 | Active |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | Year
1 | Active |  |  |  |  |  |  |  |  |  |  |  |  | Start Month/Year |  | Nov | 2012
1 | Active |  |  |  |  |  |  |  |  |  |  |  |  | End Month/Year |  | Jul | 2013
1 | Active
3 | Active
1 | Active
4 | Active
1 | Active
0 | current
0 | current |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013
0 | current |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |  |  | Aug YTD
0 | current |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 478638d1472927017-how-to-automate-date-in-subsequent-tabs-general-daily-cashflow_sept_vik-rev-02
Sheet: 092716

XXXX INC.
DAILY CASH FLOW POSITION AS ON |  |  |  | 2016-09-27 00:00:00
 | .
INCOMING (XXXX) |  |  |  |  |  | INCOMING (YYYY)
Driver | ROUTE | MONEY COLLECTED |  |  |  | Driver | ROUTE | MONEY COLLECTED
 |  | CASH | Money Order | CHECKS |  |  |  | CASH | Money Order | CHECKS
[NAME] | 8 |  |  |  |  | LUIS C | 31
HARVEY | 12 |  |  |  |  | AUGY | 32
ROJO | 13 |  |  |  |  | BUD | 33
EFREN | 16
BRENT | 25 |  |  |  |  |  | Total Routes
LUIS G | 50
[NAME] | 150 |  |  |  |  |  | SHORT
[NAME] | 550 |  |  |  |  |  | HOLDS
WILSON | 76 |  |  |  |  |  | RECEIPTS
CLAUDIO RT | 152 |  |  |  |  |  | Total Outgo
 | Collection |  |  |  |  |  | DEPOIST TO ROCKVIEW
 | Total Routes
 | Other Cashflow
 | Previous Day not accounted
 | Checks reced in Mail |  |  |  |  | XXXX- MISC.
 | Checks redeposited NSF
 | Checks on HOLD |  |  |  |  | NAME |  | SHORTAGE
 |  |  |  |  |  | [NAME] |  | 0
 | Total Incoming (XXXX) |  |  |  |  | HARVEY |  | 0
 |  |  |  |  |  | ROJO |  | 0
 |  |  |  |  |  | EFREN |  | 0
OUTGOING (XXXX) |  |  |  |  |  | BRENT |  | 0
 | [NAME] |  |  |  |  | LUIS G |  | 0
 | Petty cash (Receipts) |  |  |  |  | [NAME] |  | 0
 | Mechanics |  |  |  |  | [NAME] |  | 0
 | Payroll |  |  |  |  | WILSON |  | 0
 | [NAME] |  |  |  |  | CLAUDIO RT |  | 0
 | [NAME]
 | Rockview |  |  |  |  | TOTAL SHORTAGE
 | [NAME]
 | Checks Bounced |  |  |  |  | [NAME]
 |  |  |  |  |  | DATE |  | CREDIT
 | Total Outgoing (XXXX)
RECONCILIATION (XXXX)
 | Total Incoming (XXXX)
 | Total Outgoing (XXXX)
 | [NAME]
 | BANK DEPOSITS
 | CASH HANDED OVER
 | SHORTAGE
Spreadsheet: 42c2d213-a373-4136-afb0-d5851e904a24
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261672 | 56314 | [NAME] | Devicenzi | ITA | 5 | 00:33:38 | 00:01:02 | 00:41:31 | 00:01:43 | 00:15:40 | 1 | 01:33:32
261672 | 7966 | [NAME] | Peiffer | FRA | 4 | 00:29:17 | 00:01:41 | 00:46:21 | 00:02:13 | 00:16:14 | 2 | 01:35:43
Spreadsheet: 123996d1317987521-find-cells-with-data-cheat-sheet
Sheet: CheatSheet

Day: |  | Date: |  | Manager:
Floor
AM | Rota'd |  | Actual |  | PM | Rota'd |  | Actual
Staff | In | Out | In | Out | Staff | In | Out | In | Out
[NAME] | 8898 | 1700 | 8898 | 1000 | Aga | 1800 | 2400
[NAME] | 1015 | 1600 |  |  | [NAME] | 1800
[NAME] |  |  |  |  | [NAME]
Sophie |  |  |  |  | mark
Ania |  |  |  |  | luke
[NAME] |  |  |  |  | [NAME]
aga |  |  |  |  | orwell
Sejdi |  |  |  |  | [NAME]
Flis |  |  |  |  | gabi
[NAME] |  |  |  |  | grant
Food runners
AM | Rota'd |  | Actual |  | PM | Rota'd |  | Actual
Bar
AM | Rota'd |  | Actual |  | PM | Rota'd |  | Actual
Staff | In | Out | In | Out | Staff | In | Out | In | Out
[NAME] | #N/A | 1700 |  |  | [NAME] | 1900 | 0000
 | #N/A |  |  |  | [NAME] | 1030
 | 0
 | #N/A
Reception
AM | Rota'd |  | Actual |  | PM | Rota'd |  | Actual
Staff | In | Out | In | Out | Staff | In | Out | In | Out
Bussing
AM | Rota'd |  | Actual |  | PM | Rota'd |  | Actual
Spreadsheet: 43751d1242360031-viewing-multiple-worksheets-on-one-main-worksheet-solutioncalendar
Sheet: GuideLine

Select The Month & Type of Calendar & Click to change
Month | Type
May | Child | Click to Go on Specific Calendar
Guide Lines
1.  Don't use Space or special characters in Sheet names / File Name
2.  I've created two ranges Month & Type and using in Validation of Cell A3 & B3.
3.  This is just an example and you can further expand it
4.  I've hidden Sheet Tabs so user will just think as Calnder is changing as we are selecting month & type
Month Rante | Type Range
GuideLine |  | You can take out GuideLine Sheet from this as its only for your info.
Jan | Child
Feb | [NAME]
Mar
Apr
May
June
July
Aug
Sep
Oct
Nov
Dec