tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142820d1330019154-pto-accrual-spreadsheet-tmf-pto-2012
Sheet: Vacation Time

TMF PTO 2012
Employee | Last | First | Start | # years | Accrual | Hours | Total Entitled |  | Date(s) | Hours | Date(s) | Hours | Date(s) | Hours | Total | Balance
Number | Name | Name | Date | of service | Rate | Earned | # days | # hours | Taken | Used | Taken | Used | Taken | Used | Used | Remaining
1 | Borek Manion | [NAME] | 2010-05-15 00:00:00 | 1.778314592364436 |  |  | 15 |  |  | 16 |  |  |  |  | 16 | -16
2 | Brobyn | [NAME] | 2011-05-15 00:00:00 | 0.7789990550612194 | 0.769 | 5.383 |  |  |  |  |  |  |  |  | 0 | 0
3 | Finngan | Lindsey | 2011-09-12 00:00:00 | 0.4504569606053672 | 0.769 | 5.383 |  |  |  |  |  |  |  |  | 0 | 0
4 | Foy | [NAME] | 2010-06-10 00:00:00 | 1.707130471899002 | 1.538 | 10.766 |  |  |  |  |  |  |  |  | 0 | 0
5 | [NAME] | [NAME] | 2011-11-14 00:00:00 | 0.2779723610160448 | 0.769 | 5.383 |  |  |  |  |  |  |  |  | 0 | 0
6 | [NAME] | [NAME] | 2011-01-03 00:00:00 | 1.140395358962657 | 1.538 | 10.766 |  |  |  |  |  |  |  |  | 0 | 0
7 | [NAME] | [NAME] | 2011-10-25 00:00:00 | 0.2588074055061201 | 0.769 | 5.383 |  |  |  |  |  |  |  |  | 0 | 0
8 | Stanton | Samantha | 2011-11-21 00:00:00 | 0.3327293767586869 | 0.769 | 5.383 |  |  |  |  |  |  |  |  | 0 | 0
9 | Tranauskas | [NAME] | 2011-09-26 00:00:00 | 0.4121270495855178 | 0.769 | 5.383 |  |  |  |  |  |  |  |  | 0 | 0
10 | Vollmer | Billie | 2011-09-12 00:00:00 | 0.4504569606053672 | 0.769 | 5.383 |  |  |  |  |  |  |  |  | 0 | 0
11 | Gretz | [NAME] | 2011-01-01 00:00:00 | 1.145871060536921 | 1.538 | 10.766 |  |  |  |  |  |  |  |  | 0 | 0
12 | Doe | [NAME] |  | 112.1492933740208 | 2.307 | 16.149 |  |  |  |  |  |  |  |  | 0 | 0
13 | Doe | [NAME] |  | 112.1492933740208 | 2.307 | 16.149 |  |  |  |  |  |  |  |  | 0 | 0
14 | Doe | [NAME] |  | 112.1492933740208 | 2.307 | 16.149 |  |  |  |  |  |  |  |  | 0 | 0
15 | Doe | [NAME] |  | 112.1492933740208 | 2.307 | 16.149 |  |  |  |  |  |  |  |  | 0 | 0
16 | Doe | [NAME] |  | 112.1492933740208 | 2.307 | 16.149 |  |  |  |  |  |  |  |  | 0 | 0
17 | Doe | [NAME] |  | 112.1492933740208 | 2.307 | 16.149 |  |  |  |  |  |  |  |  | 0 | 0
18 | Doe | [NAME] |  | 112.1492933740208 | 2.307 | 16.149 |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 867079d1713970420-if-cell-then-return-a-list-s1-science-practical-skills-level-4-23-24-2-
Sheet: Pupil and class info

Class name | Pupil name (randomly generated for GDPR)
1.1 | Skyla Castaneda
1.1 | [NAME]
1.1 | Gabriella Noble
1.1 | [NAME]
1.1 | Tatum Wall
1.1 | Issac Barnes
1.1 | [NAME]
1.1 | Rayden Jones
1.1 | [NAME]
1.1 | [NAME]
1.1 | [NAME]
1.1 | [NAME]
1.1 | Paris Hickman
1.1 | [NAME]
1.1 | Laney Peralta
1.1 | [NAME]
1.1 | [NAME]
1.1 | [NAME]
1.1 | Capri Curry
1.1 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | Brynlee Morris
1.2 | Christian Flores
1.2 | [NAME]
1.2 | Nehemiah Ponce
1.2 | Aileen Rosas
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | Ryland Sandoval
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.2 | [NAME]
1.3 | [NAME]
1.3 | Zayden Warner
1.3 | Wynter Lugo
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | Lincoln Love
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.3 | [NAME]
1.4 | [NAME]
1.4 | Aubree Holland
1.4 | [NAME]
1.4 | Dalary [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | Sariah [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
1.4 | [NAME]
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 1023

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OTV 1023 |  | Start Date | 24/07/2011 |  |  |  | [NAME] |  | 666
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | 6
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 470305d1468428531-creating-a-drop-down-list-that-filters-data-based-on-selection-book2
Sheet: Sheet1

Welcome to the [NAME] |  |  |  |  |  |  |  |  | Select Business Below:
Order # | Product | Frequency | Business
123 | Product A | Daily | Business A
124 | Product B | Weekly | Business A
125 | Product C | Monthly | Business D
126 | Product D | Quarterly | Business C
127 | Product E | Semi-Annual | Business B
128 | Product F | Annual | Business D
129 | Product G | Daily | Business C
130 | Product H | Weekly | Business D
Spreadsheet: 134772d1325626617-sumproduct-with-array-test
Sheet: Formulas

 |  | Individual
 |  |  | Week 1
 |  | 2012-01-02 00:00:00 | through | 2012-01-08 00:00:00
 |  | Total Sched | Total Worked | % Hours Worked
Name | ID
Employee A | 5630
Employee B | 5610
 |  |  | c6 should =22.5 | c7 should =20
 |  |  | d6 should =22.5 | d7 should =15
 |  |  | e6 should =100% | e7 should =75%
Spreadsheet: 888290d1738780394-summary-of-data-ezdizzy
Sheet: Blad1

 | 500 | red |  |  |  |  | red
 | 501 | green |  |  |  | 501 | green
 | 502 | red |  |  |  | 502 | red
 | 502 | red |  |  |  | 504 | purple; red; blue
 | 504 | purple |  |  |  | 505 | green
 | 504 | red |  |  |  | 506 | yellow
 | 504 | blue |  |  |  | 507 | black
 | 505 | green
 | 506 | yellow
 | 507 | black
Spreadsheet: 179617d1347316327-value-error-dow
Sheet: 3

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 175000 |  |  |  |  |  | 187000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 49800 |  |  |  |  |  | 44200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 233000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAX |  |  | PAD
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 0 | F | C | Y | F | C | Y
 |  |  |  |  |  |  | Tr
 |  |  | 202 | 8 | 2 |  | B
 |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  | . PAX/ |  |  | .PAD/
 |  |  |  |  |  |  | M
 |  |  | 75 | 40 | 10 |  | .T
 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SI
 | Adjusted
 | [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OC
 | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OF
 | [NAME].
Spreadsheet: 118991d1314123751-counting-ocurances-within-a-range-copy
Sheet: Sheet2

PTE
CPL
MCPL
SGT
WO
MWO
CWO
AS
OS
LS
MS
PO2
PO1
CPO2
CPO1
CADET
2LT
LT
CAPT
MAJ
LTCOL
COL
ASLT
SLT
COM
LTCOM
BGEN
MGEN
LGEN
GEN
ADM
VADM
RADM
COMM
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 18

Product* | February 7 | February 14 | February 21 | February 28 | March 7
Total**
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, March 7 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 874923d1721437182-how-to-get-the-number-after-the-country-name-to-match-the-country-name-0720
Sheet: Sheet1

 |  | USA | France | India | China | Russia | Germany | Japan
China35，France26，USA38 |  | 38 | 26 | 0 | 35 | 0 | 0 | 0
China68，USA69，Germany45 |  | 69 | 0 | 0 | 68 | 0 | 45 | 0
India32，Russia65，Japan38 |  | 0 | 0 | 32 | 0 | 65 | 0 | 38
Spreadsheet: 674979d1588097232-count-values-based-on-multiple-cell-matches-categories
Sheet: DataSource

[NAME] | Counter | CountryCode | Colour
28 | 30 | DK | Green
41 | 19 | DK | Green
43 | 37 | DK | Blue
45 | 44 | DK | Red
46 | 11 | DK | Red
47 | 29 | DK | Red
69 | 22 | GB | Green
76 | 1 | GB | Green
77 | 19 | GB | Green
78 | 24 | GB | Green
82 | 11 | GB | Green
84 | 5 | GB | Blue
Spreadsheet: 6b300904-ed72-401c-b924-b4cfd33f1220
Sheet: Sheet1

Unnamed: 0 | US Municipal Bond Issuance | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Table | Description | Time Period | Currency | Value | Last Value | Last Updated
 | 1.1. | US Municipal Issuance, Bond (Go/Revenue), Bid (Competitive/Negotiated), and Coupon Type | A, M | USD | Billions | June 2014 | 2014-07-01 00:00:00
 | 1.2. | US Municipal Issuance, New Capital & Refunding | A, M | USD | Billions | June 2014 | 2014-07-01 00:00:00
 | 1.3. | US Municipal Issuance, Callable and Noncallable | A, M | USD | Billions | June 2014 | 2014-07-01 00:00:00
 | 1.4. | US Municipal Issuance, Average Maturity | A, M |  | Years | June 2014 | 2014-07-01 00:00:00
 | 2.1. | FAQ |  |  |  |  | 2012-07-12 00:00:00
 | Contact
 | [NAME] | [EMAIL]
 | All data are subject to revision.
 | The Securities Industry and Financial Markets Association (SIFMA) prepared this material for informational purposes only. [NAME] obtained this information from multiple sources believed to be reliable as of the date of publication; SIFMA, however, makes no representations as to the accuracy or completeness of such third party information. SIFMA has no obligation to update, modify or amend this information or to otherwise notify a reader thereof in the event that any such information becomes outdated, inaccurate, or incomplete.
 | The Securities Industry and Financial Markets Association (SIFMA) brings together the shared interests of hundreds of securities firms, banks and asset managers. [NAME]'s mission is to support a strong financial industry, investor opportunity, capital formation, job creation and economic growth, while building trust and confidence in the financial markets. SIFMA, with offices in New York and Washington, D.C., is the U.S. regional member of the Global Financial Markets Association (GFMA). For more information, visit www.sifma.org.
 | FAQ
 | Issuance | All issuance figures are based on deals with maturity of 13 months or greater.
 | Average Maturity | Average maturity is based on issuance, rather than outstanding, volumes.
 | Source: | Thomson Reuters
Spreadsheet: 22702d1211845531-calendar-help-excelforum-calendar-demo
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Mon
Tue | [NAME]
Wed
Thu
Fri |  | [NAME]
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun |  |  |  | [NAME]
Mon |  |  |  | [NAME] |  |  | [NAME]
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Spreadsheet: eric_saibi__9941__103101
Sheet: Four Corners 05

Owner Name |  | Arizona Public Service
Station Name |  | Four Corners Power Station
Unit Name |  | Four Corners 05
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 818 MW
Start Date |  | 2001-10-31 00:00:00
End Date |  | 2001-10-31 00:00:00
Prv. Start Date |  | 2001-10-31 00:00:00
Prv. End Date |  | 2001-11-02 00:00:00
Comments |  | [NAME] problem- Not as extensive as first thought.
SIC |  | 4911
Plant ID |  | 1523368
Unit ID |  | 1007555
Outage ID |  | 18767
Spreadsheet: phillip_platter__31375__dailypowerprices
Sheet: Sheet5

YearNum | 2001
MonthNum | 10
PeakorOffPeak | P
Sum of Price | ZoneCode
CADateTime | COB | MC | NP | PV | SP
2001-10-01 00:00:00 | 26 | 22 | 26.93000030517578 | 28.64999961853027 | 26.56999969482422
2001-10-02 00:00:00 | 27.75 | 24.54999923706055 | 28.30999946594238 | 29.73999977111816 | 28.54000091552734
2001-10-03 00:00:00 | 25.5 | 23.39999961853027 | 26.75 | 25.42000007629395 | 25.81999969482422
2001-10-04 00:00:00 | 24.75 | 22.85000038146973 | 25.48999977111816 | 25.39999961853027 | 25.60000038146973
2001-10-05 00:00:00 | 23.25 | 21.60000038146973 | 24.1200008392334 | 23.64999961853027 | 24.1299991607666
2001-10-06 00:00:00 | 23.25 | 21.60000038146973 | 24.1200008392334 | 23.64999961853027 | 24.1299991607666
2001-10-07 00:00:00 | 0 | 0 | 0 |  | 0
2001-10-08 00:00:00 | 23.70000076293945 | 22.70000076293945 | 23.96999931335449 |  | 24.03000068664551
2001-10-09 00:00:00 | 22.5 | 22.10000038146973 | 22.97999954223633 |  | 23.13999938964844
2001-10-10 00:00:00 | 22 | 21.10000038146973 | 23.29000091552734 |  | 23.29999923706055
Spreadsheet: 132686d1323881879-combining-data-on-list-containing-blank-lines-wound-list
Sheet: Sheet1

Wound Supplies
 | [NAME] | True
 | Aquacel AG | True
 |  | False
 | Hydrogel Sheet | False
 |  | False
 | Regranex | True
 |  | False
 |  | False
 |  | False
 |  | True
Question:  Is there a way to combine the values in column D into cell A13 to read like as follows?
[NAME], Aquacel AG, Regranex, e-stim
Cell A13 must be dynamic, depending on chosen procedures/supplies from column B.
Columns C and D will be hidden on final form.
Spreadsheet: 676694d1588937723-how-to-get-data-based-on-date-criteria-excel-solution-miranti-
Sheet: 2 REV FUNC

REVISION FUNCTION
Periode :
TYPE | START DATE | FINISH DATE
A | 2020-03-16 00:00:00 | 2020-03-23 00:00:00
B | 2020-03-16 00:00:00 | 2020-03-23 00:00:00
C | 2020-03-17 00:00:00 | 2020-03-24 00:00:00
D | 2020-03-17 00:00:00 | 2020-03-24 00:00:00
F | 2020-03-17 00:00:00 | 2020-03-24 00:00:00
G | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
H | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
I | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
J | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
K | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
L | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
M | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
N | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
O | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
P | 2020-03-23 00:00:00 | 2020-03-30 00:00:00
Q | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
R | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
S | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
T | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
U | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
V | 2020-03-25 00:00:00 | 2020-04-01 00:00:00
W | 2020-03-25 00:00:00 | 2020-04-01 00:00:00
X | 2020-03-26 00:00:00 | 2020-04-02 00:00:00
Y | 2020-03-26 00:00:00 | 2020-04-02 00:00:00
Z | 2020-03-27 00:00:00 | 2020-04-03 00:00:00
AA | 2020-03-27 00:00:00 | 2020-04-03 00:00:00
AB | 2020-03-27 00:00:00 | 2020-04-03 00:00:00
AC | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AD | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AE | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AF | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AG | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AH | 2020-03-31 00:00:00 | 2020-04-07 00:00:00
AI | 2020-03-31 00:00:00 | 2020-04-07 00:00:00
AJ | 2020-03-31 00:00:00 | 2020-04-07 00:00:00
AK | 2020-04-01 00:00:00 | 2020-04-08 00:00:00
AL | 2020-04-01 00:00:00 | 2020-04-08 00:00:00
AM | 2020-04-01 00:00:00 | 2020-04-08 00:00:00
AN | 2020-04-02 00:00:00 | 2020-04-09 00:00:00
AO | 2020-04-02 00:00:00 | 2020-04-09 00:00:00
AP | 2020-04-02 00:00:00 | 2020-04-09 00:00:00
AQ | 2020-04-06 00:00:00 | 2020-04-13 00:00:00
AR | 2020-04-07 00:00:00 | 2020-04-14 00:00:00
AS | 2020-04-07 00:00:00 | 2020-04-14 00:00:00
AT | 2020-04-07 00:00:00 | 2020-04-14 00:00:00
AU | 2020-04-08 00:00:00 | 2020-04-15 00:00:00
AV | 2020-04-08 00:00:00 | 2020-04-15 00:00:00
AW | 2020-04-08 00:00:00 | 2020-04-15 00:00:00
AX | 2020-04-09 00:00:00 | 2020-04-16 00:00:00
AY | 2020-04-09 00:00:00 | 2020-04-16 00:00:00
AZ | 2020-04-10 00:00:00 | 2020-04-17 00:00:00
UPDATE PRODUCTION
DATE | TYPE
Spreadsheet: richard_sanders__31864__InfineumSteamTakes
Sheet: Sheet1

EAST COAST POWER L.L.C.
STEAM REVENUE ANALYSIS
AS OF
JANUARY - MAY 1999
 | CONTRACT | PAID |  | LOST
MONTH | LIMIT | AMOUNT |  | REVENUE
1999-01-01 00:00:00 | 876060.83 | 428999.93
1999-02-01 00:00:00 | 808051.57 | 402365.68
1999-03-01 00:00:00 | 886853.26 | 541651.18
1999-04-01 00:00:00 | 857672.88 | 411873.62
1999-05-01 00:00:00 | 895070.17 | 780294.37
1999-12-01 00:00:00 | Side Letter Adjustment |  |  | -615000
Total
EAST COAST POWER L.L.C.
STEAM VOLUME COMPARISON
AS OF
JANUARY - MAY 1999
 | HP | HP |  | LP | LP |  | (INFINEUM TAKE - LIMIT)
 | CONTRACT | INFINEUM |  | CONTRACT | INFINEUM |  | HP | LP
MONTH | LIMIT | TAKE |  | LIMIT | TAKE |  | DIFFERENCE | DIFFERENCE
1999-01-01 00:00:00 | 14136 | 162505 |  | 120528 | 118705
1999-02-01 00:00:00 | 12768 | 113174 |  | 108864 | 144129
1999-03-01 00:00:00 | 14136 | 14136 |  | 120528 | 252049
1999-04-01 00:00:00 | 13661 | 97200 |  | 116478 | 186480
1999-05-01 00:00:00 | 14136 | 45455 |  | 120528 | 120528
 |  |  |  |  | DIFFERENCE
 |  |  |  |  | TOTAL DIFFERENCE
Spreadsheet: 840837d1693035295-adding-multiple-criteria-to-countifs-dont-count-duplicates-countifs-but-exclude-duplicates-1-ans
Sheet: Sheet1

Business Name | Zone | Manager | Status | Notes |  |  |  | Plain text formula ideas |  | [NAME]
Homer Home Improvements | A | Homer | Active |  |  | Total Businesses |  | =SUM(1/COUNTIF(A2:A14,A2:A14))
Homer Home Improvements | A | Homer | Active | Duplicate |  | Total Active | 5 | =COUNTIFS(D:D,"Active",A:A,<>)
D'oh Playdough | B | [NAME] | Active |  |  | Total Inactive | 1 | =COUNTIFS(D:D,"Inactive",A:A,???)
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive | Duplicate
Santa's Little Helper Inc. | A | [NAME] | Inactive | Duplicate
Straight A Tutors | B | [NAME] | Active
Straight A Tutors | B | [NAME] | Active | Duplicate
Straight A Tutors | B | [NAME] | Active | Duplicate
Duff LLC | C | Homer | Active
Poetry Club LLC | A | [NAME] | Active
Poetry Club LLC | A | [NAME] | Active | Duplicate
Spreadsheet: 678979d1590146226-auto-populating-date-based-on-dropdown-selection-weekly-timesheet-test
Sheet: Weekly Time Card

 | Engineer Name |  |  |  |  | Month | July
 | Customer Site |  |  |  |  | Week | 2 |  |  |  |  |  | [NAME] | 00:45:00 |  | Customer Site | Example 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 2
Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 3
 |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Total |  |  |  |  |  |  | Example 4
Weekly Time Card |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 5
Start Time |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  |  |  |  | Month | January |  |  | Example 6
Finish Time |  |  | 17:15:00 | 17:15:00 | 17:15:00 | 17:15:00 | 17:15:00 |  |  |  |  |  |  | February |  |  | Example 7
Total Hours Worked |  |  |  |  |  |  |  |  |  |  |  |  |  | March |  |  | Example 8
Regular Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | April |  |  | Example 9
Overtime *Must be approved |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  | Example 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | June |  |  | Example 11
Description |  |  |  |  |  |  |  |  |  |  |  |  |  | July |  |  | Example 12
 |  |  | Total | Managers Name |  |  |  |  |  |  |  |  |  | August |  |  | Example 13
Total Weekly Hours |  |  |  | Date |  |  |  |  |  |  |  |  |  | September |  |  | Example 14
Regular |  |  |  | Additional Notes |  |  |  |  |  |  |  |  |  | October |  |  | Example 15
Overtime *Must be approved |  |  |  |  |  |  |  |  |  |  |  |  |  | November |  |  | Example 16
Total Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | December |  |  | Example 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 18
 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 1 |  |  | Example 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | Example 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | Example 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | Example 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | Example 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 26
Spreadsheet: 72910d1273606347-first-and-second-place-from-a-data-set-world-cup-tables
Sheet: MATHS

Group A | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
south africa
mexico
uruguay
france
Group B | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
argentina
nigeria
south korea
greece
Group C | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
england
usa
slovenia
algeria
Group D | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
germany
australlia
serbia
ghana
Group E | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
holland
denmark
japan
cameroon
Group F | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
italy
paraguay
new zealand
slovakia
Group G | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
brazil
north korea
ivory coast
portugal
Group H | win |  |  | Total | draw |  |  | Total | lose |  |  | Total | goaldiff | goals for | goals against
spain
switzerland
honduras
chile
Spreadsheet: 104041d1301663659-matching-data-with-multiple-columns-problem-formula
Sheet: Sheet1

Data Set 1 |  |  | Data Set 2
Name | Food | Colour | Name | Food | Colour | Desired Response | current response & formula
[NAME] | sandwich | red | [NAME] | cheese | pink | 1 | FALSE
babs | steak | pink | [NAME] | sandwich | purple | 0 | FALSE
babs | apple | blue | babs | steak | pink | 1 | TRUE
[NAME] | cheese | pink | babs | apple | blue | 1 | FALSE
 |  |  | bill | apple | blue | N/A | #N/A
 | [NAME] IN RED
Spreadsheet: 824422d1680573633-show-movements-between-selected-dates-sales-order-movements-andyd1234-
Sheet: Sheet1

Sales ID | [NAME] | Date | Q1 Revenue | Q2 Revenue | [NAME] | Q4 Revenue | Total Value | Change | Change Q1 | Change Q2 | [NAME] | Change Q4
A001 | Artemis Ltd | 2023-03-01 00:00:00 | 400 | 100 | 250 | 50
A002 | Bon Voyage Ltd | 2023-03-01 00:00:00 | 100 | 500 | 1000 | 1500
A003 | Mint Ltd | 2023-03-01 00:00:00 | 0 | 0 | 400 | 400
A004 | [NAME] | 2023-03-01 00:00:00 | 600 | 600 | 0 | 0
A005 | Bernies | 2023-03-01 00:00:00 | 200 | 250 | 300
A006 | Mac Attack Ltd | 2023-03-01 00:00:00 | 0 | 0 | 0 | 500
A007 | Jones & Jones | 2023-03-01 00:00:00 | 65 | 0 | 0 | 0
A008 | E [NAME] | 2023-03-01 00:00:00 | 300 | 300 | 350 | 350
A001 | Artemis Ltd | 2023-03-02 00:00:00 | 400 | 100 | 250 | 50
A002 | Bon Voyage Ltd | 2023-03-02 00:00:00 | 100 | 500 | 1000 | 1500
A003 | Mint Ltd | 2023-03-02 00:00:00 | 0 | 0 | 400 | 400
A004 | [NAME] | 2023-03-02 00:00:00 | 600 | 600 | 0 | 0
A005 | Bernies | 2023-03-02 00:00:00 | 200 | 250 | 300
A006 | Mac Attack Ltd | 2023-03-02 00:00:00 | 0 | 0 | 0 | 500
A007 | Jones & Jones | 2023-03-02 00:00:00 | 65 | 0 | 0 | 0
A008 | E [NAME] | 2023-03-02 00:00:00 | 300 | 300 | 450 | 450
A009 | Office Supplies Ltd | 2023-03-02 00:00:00 | 1000 | 1000 | 0 | 0
A001 | Artemis Ltd | 2023-03-03 00:00:00 | 400 | 100 | 250 | 50
A002 | Bon Voyage Ltd | 2023-03-03 00:00:00 | 100 | 500 | 1000 | 1500
A003 | Mint Ltd | 2023-03-03 00:00:00 | 400 | 400 | 400 | 400
A005 | Bernies | 2023-03-03 00:00:00 | 200 | 250 | 300
A006 | Mac Attack Ltd | 2023-03-03 00:00:00 | 0 | 0 | 0 | 500
A007 | Jones & Jones | 2023-03-03 00:00:00 | 65 | 0 | 0 | 0
A008 | E [NAME] | 2023-03-03 00:00:00 | 300 | 300 | 450 | 450
A009 | Office Supplies Ltd | 2023-03-03 00:00:00 | 1000 | 1000 | 1000 | 0
A010 | Security plus Ltd | 2023-03-03 00:00:00 | 0 | 0 | 750 | 750
Spreadsheet: 848962d1699549250-lookup-and-find-the-in-between-days-and-return-number-of-days-20231109
Sheet: Sheet1

Number | From Date | To Date | Total Days
30114 | 2021-06-09 00:00:00 | 2021-12-08 00:00:00
30153 | 2021-06-10 00:00:00 | 2021-12-09 00:00:00 | 54
30159 | 2021-06-11 00:00:00 | 2021-12-10 00:00:00 | 25
30165 | 2021-06-11 00:00:00 | 2021-12-10 00:00:00 | 20
30675 | 2021-06-25 00:00:00 | 2021-12-24 00:00:00 | 26