tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676354d1588771203-retun-emplyee-name-and-team-based-on-criteria-from-a-table-work-location
Sheet: Sheet1

Name | Team | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | 2020-05-10 00:00:00 | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-05-17 00:00:00 | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00
A | 1 | Office | Home | Home | Office | Home | Home | Home | Home | Home | Home | Home | Home | Home | Office | Home | Home | Home | Home | Home
B | 1 | Home | Home | Home | Home | Home | Home | Office | Home | Home | Home | Home | Home | Home | Office | Home | Home | Home | Home | Home
C | 2 |  | Home | Home | Home | Home | Home | Home | Home | Home | Home | Home | Home | Home | Office | Home | Home | Home | Home | Home
D | 2 |  | Home | Home | Office | Home | Home | Home | Home | Home | Home | Home | Home | Home | Office | Home | Home | Home | Home | Home
E | 2 |  | Home | Home | Office | Home | Home | Home | Home | Home | Home | Home | Home | Home | Office | Home | Home | Home | Home | Home
F | 3 |  | Home | Home | Home | Home | Home | Home | Home | Home | Office | Home | Home | Home | Office | Home | Home | Home | Home | Home
 | Date | 2020-05-07 00:00:00
 | Auto populated data of people working from office for the selected date
 | Name | Team |  |  | Name | Team
 | A | 1
 | D | 2
 | E | 2
Spreadsheet: kimberly_watson__20554__imbalsumm0108
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 199740 | 206461 |  | -6136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 124221 | 140424 |  | -16997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 208560 | 226875 |  | -13759 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 174497 | 201790 |  | -27623 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 170484 | 195304 |  | -25217 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 171739 | 196507 |  | -26132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 181261 | 192920 |  | -9874 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 197070 | 204844 |  | -4417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 193826 | 201331 |  | -8466 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 183951 | 200529 |  | -19807 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 205187 | 209202 |  | -5480 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 196282 | 206942 |  | -11937 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 208969 | 209066 |  | -807 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 200915 | 207816 |  | -8506
15 | 185028 | 192042 |  | -7418 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 205829 | 210433 |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 203994 | 209294 |  | -5929 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 230790 | 250585 |  | -6265
19 | 180146 | 245466 |  | -6387
20 | 216439 | 221942 |  | -6231
21 | 183412 | 215195 |  | -28318
22 | 167828 | 203102 |  | -36302
23 | 178676 | 190275 |  | -10586
24 | 175424 | 196078 |  | -20083
25 | 183300 | 180188
26 | 186775 | 185860
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 5110
 | 2001-08-26 00:00:00
 | CBS Dollars
 |  |  |  | -487771.44
Spreadsheet: 298513d1392825165-system-specs-for-heavy-processing-cleanup-process
Sheet: Step 5 - Remove Remaining Blank

CODVUC01 |  | IZL8941 | CODVPUC01064 | 41275.38026620371 | 41275.41569444444 | 192.168.1.131 | AAAAAA | 0:51:01
CODVUC01 |  | IZL8941 | CODVPUC01145 | 41275.43021990741 | 41275.46384259259 | 192.168.1.131 | AAAAAA | 0:48:25
CODVUC01 |  | IZL8941 | CODVPUC01111 | 41275.50862268519 | 41275.58930555556 | 192.168.1.131 | AAAAAA | 1:56:11
CODVUC01 |  | IZL8941 | CODVPUC01097 | 41275.68673611111 | 41275.70693287037 | 192.168.1.131 | AAAAAA | 0:29:05
CODVUC01 |  | QXA8700 | CODVPUC01102 | 41275.40171296296 | 41275.57107638889 | 192.168.2.2 | AAAAAA | 4:03:53
CODVUC01 |  | DZF7342 | CODVPUC01065 | 41275.44215277777 | 41275.50519675926 | 192.168.1.3 | AAAAAA | 1:30:47
CODVUC01 |  | DZF7342 | CODVPUC01056 | 41275.51886574074 | 41275.56275462963 | 192.168.1.3 | AAAAAA | 1:03:12
CODVUC01 |  | DZF7342 | CODVPUC01139 | 41275.95144675926 | 41275.99555555556 | 192.168.1.3 | AAAAAA | 1:03:31
CODVUC01 |  | MVA9800 | CODVPUC01052 | 41275.36358796296 | 41275.45924768518 | 192.168.0.3 | AAAAAA | 2:17:45
CODVUC01 |  | MVA9800 | CODVPUC01145 | 41275.6274074074 | 41275.67236111111 | 192.168.0.3 | AAAAAA | 1:04:44
CODVUC01 |  | DEY9939 | CODVPUC01034 | 41275.64484953704 | 41275.69354166667 | 10.0.1.10 | AAAAAA | 1:10:07
CODVUC01 |  | DEY9939 | CODVPUC01081 | 41275.88410879629 | 41275.96996527778 | 192.168.1.3 | AAAAAA | 2:03:38
CODVUC01 |  | EVH9051 | CODVPUC01122 | 41275.68197916666 | 41275.80578703703 | 192.168.1.4 | AAAAAA | 2:58:17
CODVUC01 |  | FTI8914 | CODVPUC01146 | 41275.45381944444 | 41275.57719907408 | 192.168.1.101 | AAAAAA | 2:57:40
CODVUC01 |  | FTI8914 | CODVPUC01082 | 41276.1072337963 |  | 10.153.174.78 | AAAAAA
Spreadsheet: 127377d1320328123-filter-example
Sheet: Sheet1

ORIGINAL |  |  |  |  |  | Count | #1 | #2 | Name | Address | Value | Count
#1 | #2 | Name | Address | Value | Count |  | 1 | 11 | a | aa | W | 4
1 | 11 | a | aa | W | 4 |  | 5 | 55 | b | ee | W | 0
2 | 22 | b | bb | W | 5 |  | 6 | 66 | c | ff | W | 1
3 | 33 | c | cc | W | 6 |  | 21 | 3333 | c | uu | W | 2
4 | 44 | a | dd | W | 7 |  | 22 | 4444 | a | vv | W | 3
5 | 55 | b | ee | W | 0 |  | 23 | 5555 | b | ww | W | 4
6 | 66 | c | ff | W | 1 |  | 7 | 77 | a | gg | Y | 0
21 | 3333 | c | uu | W | 2 |  | 8 | 88 | b | hh | Y | 0
22 | 4444 | a | vv | W | 3 |  | 9 | 99 | c | ii | Y | 0
23 | 5555 | b | ww | W | 4 |  | 10 | 111 | a | jj | Y | 0
24 | 333 | A | WW | X | 5 |  | 11 | 222 | b | kk | Y | 0
7 | 77 | a | gg | Y | 0 |  | 18 | 999 | c | rr | Y | 0
8 | 88 | b | hh | Y | 0 |  | 19 | 1111 | a | ss | Y | 0
9 | 99 | c | ii | Y | 0 |  | 20 | 2222 | b | tt | Y | 0
10 | 111 | a | jj | Y | 0 |  | 12 | 333 | c | ll | Z | 0
11 | 222 | b | kk | Y | 0 |  | 13 | 444 | a | [NAME] | Z | 0
18 | 999 | c | rr | Y | 0 |  | 14 | 555 | b | nn | Z | 0
19 | 1111 | a | ss | Y | 0 |  | 15 | 666 | c | oo | Z | 0
20 | 2222 | b | tt | Y | 0 |  | 16 | 777 | a | pp | Z | 0
12 | 333 | c | ll | Z | 0 |  | 17 | 888 | b | qq | Z | 0
13 | 444 | a | [NAME] | Z | 0
14 | 555 | b | nn | Z | 0
15 | 666 | c | oo | Z | 0
16 | 777 | a | pp | Z | 0
17 | 888 | b | qq | Z | 0
Spreadsheet: 708989d1608120388-help-with-index-match-with-multipe-criteria-seniority-count
Sheet: Sheet2

CEO - Amministratore Delegato |  |  |  |  |  |  |  |  | VP | 0
CEO & Co-Founder - Pre-Seed AI Start Up Â© â­ï¸ |  |  |  |  |  |  |  |  | Manager | 0
Group CEO |  |  |  |  |  |  |  |  | Director | 17
Founder & Ceo |  |  |  |  |  |  |  |  | CXO | 13
CEO & Founder |  |  |  |  |  |  |  |  | Senior/Other | 1
Co-Founder and CEO |  |  |  |  |  |  |  |  | Founder/Owner | 13
CEO
Managing Director
Managing Director
Managing Director
President & CEO
Founder & CEO
Group Controller GMV - CEO & Founder Domotic One
Co-founder & CEO
Chief Executive Officer
CEO & Founder
Director of Sales and Marketing
[NAME]
CEO and Co-founder
Sales & Marketing Director @NUO Digital Company _ Falck Group
CEO & Co-Founder
CEO & Co-Founder
Managing Director in greentech and environmental finance
Managing Director
CEO & GM
CEO
MANAGING DIRECTOR
Main Owner, Chairman [NAME]
Managing Director, Middle East, Africa & Web Studio Global Direct
Managing Director
Founder & CEO
CEO & Managing Director
CEO founder
Managing Director
Chief Digital Officer | Head of Digital Transformation
Managing Director Italy
Founder & CEO
Managing Director
Chief Executive Officer
Executive Director, International Operations
Managing Director
Managing Director
Founder e CEO
Managing Director
Founder & CEO
CEO & Managing Director
Managing Director [NAME]
CEO
CEO
Spreadsheet: 69455d1269976913-vlookup-maybe-employee-data
Sheet: Employee Data

ID | Names | Title | Department | Pay/Serv No | RN or Civ | P or T | Toil B/f | [NAME] | [NAME] | Toil T | Toil Rem
46 | [NAME] | Fitter |  | 001667 | Civilian | P |  | 0 | 0 | 0 | 0
65 | [NAME] | Fitters mate |  | 002850 | Civilian | P
59 | [NAME] | Slinger |  |  | Civilian | P
10 | [NAME] | CPO | RA322 |  | RN | P
22 | Beaty | LH |  |  | RN | P
38 | [NAME] | WO2 |  |  | RN
28 | Bryning | PO |  |  | RN
45 | [NAME] | Fitter |  | 002844 | Civilian | P
56 | [NAME] | Fitter |  |  | Civilian | P
6 | [NAME] | CPO | [NAME] |  | RN | P
29 | [NAME] | PO |  |  | RN | P
53 | Cliff Batty | Fitter | [NAME] | 002327 | Civilian | P
60 | [NAME] | Slinger |  |  | Civilian | P
49 | [NAME] | Fitter |  |  | Civilian | P
66 | [NAME] | Fitters mate |  | 002485 | Civilian | P
41 | [NAME] | TL | RA1 |  | Civilian | P
34 | Goldsmith | PO |  |  | RN
55 | [NAME] | Fitter |  |  | Civilian | P
40 | [NAME] | TL | RA1 |  | Civilian | P
8 | Grant | CPO | [NAME] |  | RN | P
16 | Gregory | CPO |  |  | RN
67 | [NAME] | Fitters mate |  | 002614 | Civilian | P
51 | Iain Christie | Fitter |  |  | Civilian | P
64 | [NAME] | Fitters mate |  | 002953 | Civilian | P
44 | [NAME] | Fitter |  | 002347 | Civilian | P
23 | Jones | LH |  |  | RN
27 | Knight | PO |  |  | RN
32 | [NAME] | PO |  |  | RN
35 | Luszneak | PO |  |  | RN
43 | [NAME] | CPO |  |  | RN
48 | [NAME] | Fitter |  | 001869 | Civilian | P
24 | McCallum | PO |  |  | RN
13 | McClure | CPO |  |  | RN
12 | McEvoy | CPO | RA124 |  | RN
2 | McKeown | CPO |  |  | RN
20 | [NAME] | LET |  |  | RN
52 | [NAME] | Fitter |  |  | Civilian | P
42 | [NAME] | TL | RA1 |  | Civilian | P
36 | [NAME] | PO |  |  | RN
14 | O'Neill | CPO |  |  | RN
31 | Paice | PO |  |  | RN
47 | [NAME] | Fitter |  | 001681 | Civilian | P
9 | [NAME] | CPO | RA322 |  | RN
11 | Preston | CPO | RA322 |  | RN
26 | Price | PO |  |  | RN
37 | Ramsdale | PO |  |  | RN
15 | [NAME] | CPO | RA124 |  | RN | P
57 | [NAME] | Slinger |  |  | Civilian | P
61 | [NAME] | Slinger |  |  | Civilian | P
39 | [NAME] | TL | RA1 |  | Civilian | P
30 | Rogers | PO |  |  | RN
54 | [NAME] | S/Fitter | RA124 |  | Civilian | P
19 | Sadler | LET |  |  | RN
4 | Shearin | CPO |  |  | RN
21 | Small | LET |  |  | RN
17 | [NAME] | CPO |  |  | RN
1 | [NAME] | CPO |  |  | RN
58 | [NAME] | Slinger |  |  | Civilian | P
3 | Swift | CPO |  |  | RN
62 | [NAME] | Fitter |  |  | Civilian | P
50 | [NAME] | Fitter |  |  | Civilian | P
18 | Walke | ET |  |  | RN
63 | [NAME] | Fitters mate |  | 001748 | Civilian | P
33 | Wilson | PO |  |  | RN
5 | Wishart | CPO |  |  | RN
25 | Worth | PO |  |  | RN
Spreadsheet: 50443d1249906412-autofilter-ex
Sheet: Sheet1

Name | Ex |  |  | Name | Ex
A | CCC |  |  | K | AAA
B | A |  |  | N | AA+
C | A- |  |  | I | AA
D | B- |  |  | G | AA-
E | BB |  |  | O | A+
F | B |  |  | B | A
G | AA- |  |  | C | A-
H | BBB |  |  | Q | BBB+
I | AA |  |  | H | BBB
J | BB- |  |  | M | BBB-
K | AAA |  |  | L | BB+
L | BB+ |  |  | E | BB
M | BBB- |  |  | J | BB-
N | AA+ |  |  | P | [NAME]
O | A+ |  |  | F | B
P | [NAME] |  |  | D | B-
Q | BBB+ |  |  | A | CCC
Spreadsheet: 875867d1722500078-logging-and-calculating-half-day-absences-in-spreadsheet-dummy-sickpay-halfdays-august-2024
Sheet: Sheet1

 |  |  |  |  | Startdate | Year service
 |  |  |  |  | 2023-06-01 00:00:00
Name: | Employee |  |  | [NAME] entitlement
Number of working hours | 25.5
Number of  Working days per week | 4
Working  days | Monday/Tuesday/Wednesday/Thursday |  |  |  |  |  | Number of weeks Full Pay | Number of weeks half Pay
End Date of last sickness |  |  |  |  |  | Less Than 6 months service | SSP | SSP | 0
No of Sick Days in  12 month Period |  |  |  |  |  | Less than 1 year servcie | 1 | 1 | 0.5
Number of sick [NAME] |  |  |  |  |  | One to two years' service: | 2 | 2 | 1
 |  |  |  |  |  | Two to three years’ service: | 4 | 4 | 2
 |  |  |  |  |  | Three years service and above | 6 | 6 | 3
First Day of Absence | Last Day of Absence | Number of Days off | Reason for Absence | Days of Week off
2024-01-09 00:00:00 | 2024-01-21 00:00:00 |  |  |  |  | Total Days Entitelment
2024-07-31 00:00:00 | 2024-07-31 00:00:00 |  | Half day
 |  |  |  |  |  | Days Entitlement used
Spreadsheet: 776308d1649683593-conditional-formating-based-on-cell-value-test
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | STATUS | LAST BILLED
9
8
7
6
5
4
3
2
1
Spreadsheet: chris_dorland__1589__X Forecast
Sheet: X Forecast

Dorland's NWP / PGT X Forecast
 |  | Sumas | Sumas - Chehalis | Chehalis | Washougal | Kelso / [NAME] | Other Chehalis /  Roosevelt | JP  INJ+ / WD- | JP Balance | % Full | Roosevelt | Starr Road | Other [NAME] / Meacham | Stanfield Net | Meacham | Reno Lateral | Mystery Demand | Other Meecham/ Kemmerer | Kemmerer |  | [NAME] | Rathdrum | Spokane NWP | Spokane WWP | Other/ Fuel | PGT Stanfield | South Hermiston | Coyote Springs | [NAME] | [NAME] [NAME] | Malin
 |  |  |  |  |  |  |  |  | 19000
2001-11-01 00:00:00 |  | 850 | 525 |  | -300 | -60 | -260 |  |  |  |  |  | -220 |  |  | -125 | -25 | -200 | -460 |  | 2575 | -50 | 75 | -25 | -75 |  | -80 | -40 | -100 | -80 | -1775
2001-12-01 00:00:00 |  | 850 | 575 |  | -300 |  | -290 |  |  |  |  |  | -240 |  |  | -125 | -25 | -205 | -460 |  | 2575 | -50 | 100 |  | -75 |  | -80 |  | -110 | -80 | -1775
2002-01-01 00:00:00 |  | 850 | 600 |  | -280 |  | -305 |  |  |  |  |  | -240 |  |  | -125 | -25 | -205 | -460 |  | 2575 | -50 | 105 |  | -75 |  | -80 |  | -90 | -80 | -1775
2002-02-01 00:00:00 |  | 850 | 590 |  | -270 |  | -280 |  |  |  |  |  | -220 |  |  | -125 | -25 | -186 | -460 |  | 2525 | -50 | 90 |  | -75 |  | -80 |  | -90 | -80 | -1775
2002-03-01 00:00:00 |  | 850 | 505 |  | -235 |  | -240 |  |  |  |  |  | -175 |  |  | -125 | -25 | -125 | -460 |  | 2475 | -50 | 85 |  | -75 |  | -80 |  | -60 | -80 | -1775
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
2002-11-01 00:00:00
2002-12-01 00:00:00
2003-01-01 00:00:00
2003-02-01 00:00:00
2003-03-01 00:00:00
2003-04-01 00:00:00
2003-05-01 00:00:00
2003-06-01 00:00:00
2003-07-01 00:00:00
2003-08-01 00:00:00
2003-09-01 00:00:00
2003-10-01 00:00:00
2003-11-01 00:00:00
Spreadsheet: 97557d1296693485-dynamic-cell-references-in-excel-2010-sample-list
Sheet: Sheet2

 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Fred |  | date | date | date | date | date | date | date
[NAME]
[NAME] |  | date | date | date | date | date | date | date
[NAME]
[NAME] |  | date | date | date | date | date | date | date
Sue
[NAME]
[NAME]
[NAME]
Mark
[NAME]
George
Neville
[NAME]
Molly
[NAME]
Greg
[NAME]
[NAME]
[NAME]
Trish
[NAME]
Spreadsheet: 58d244c8-e722-44b6-a946-a9164ea530d1
Sheet: Sheet1

State Representative - REP (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/18/2013 8:25:23 PM
Precincts Reporting: 565/565 - Total Ballots Cast: 111325
2006 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Precinct 3117 | 119 | 128 | 247
Precinct 3118 | 55 | 58 | 113
Precinct 3120 | 29 | 27 | 56
Precinct 3123 | 30 | 28 | 58
Precinct 3124 | 73 | 80 | 153
TOTAL | 306 | 321 | 627
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 885174d1734607788-help-with-timesheet-overtime-and-night-calculation-example-timeshee-new-correctedt
Sheet: BEFORE

Date | 1st Shift |  | 2nd Shift |  | Lunch Dinner Break | Total Worked
 | Time in | Time out | Time out | Time out
1 | 19:00:00 | 1900-01-01 00:00:00 | 00:00:00 | 07:00:00 | 01:00:00
2 | 05:00:00 | 15:00:00 |  |  | 01:00:00
3 | 07:00:00 | 17:00:00 |  |  | 00:30:00
4 | 08:00:00 | 16:30:00 |  |  | 00:30:00
5 |  |  |  |  | 00:30:00
6 |  |  |  |  | 00:30:00
7 |  |  |  |  | 00:30:00
8 |  |  |  |  | 00:30:00
9 |  |  |  |  | 00:30:00
10 |  |  |  |  | 00:30:00
11 |  |  |  |  | 00:30:00
12 |  |  |  |  | 00:30:00
13 |  |  |  |  | 00:30:00
14 |  |  |  |  | 00:30:00
15 |  |  |  |  | 00:30:00
16 |  |  |  |  | 00:30:00
17 |  |  |  |  | 00:30:00
18 |  |  |  |  | 00:30:00
19 |  |  |  |  | 00:30:00
20 |  |  |  |  | 00:30:00
21 |  |  |  |  | 00:30:00
22 |  |  |  |  | 00:30:00
23 |  |  |  |  | 00:30:00
24 |  |  |  |  | 00:30:00
25 |  |  |  |  | 00:30:00
26 |  |  |  |  | 00:30:00
27 |  |  |  |  | 00:30:00
28 |  |  |  |  | 00:30:00
29 |  |  |  |  | 00:30:00
30 |  |  |  |  | 00:30:00
31 |  |  |  |  | 00:30:00
TOTAL
Spreadsheet: 834888d1688134241-auto-populate-cell-based-on-criteria-with-date-range-sample-worksheet
Sheet: Sheet1

 | PRICE |  | Effective Date of Price
 | PRODUCT | CATEGORY | 04/15/2023 | 06/28/2023 | 06/30/2023
 | PEN | OFFICE SUPPLIES | 5 | 7 | 10
 | PENCIL | OFFICE SUPPLIES | 5 | 8 | 9
 | PAPER | OFFICE SUPPLIES | 2 | 3 | 5
 | ALCOHOL | CLINIC SUPPLIES | 100 | 120 | 125
 | FACE MASK | CLINIC SUPPLIES | 10 | 20 | 25
 | SALES
 | DATE | PRODUCT | PRICE
 | 2023-04-15 00:00:00 | PEN
 | 2023-06-30 00:00:00 | ALCOHOL
Spreadsheet: 148227d1333270417-calculate-max-using-dropdown-criteria-sampleclass
Sheet: Class Data

SAMPLE CLASS
 | Test Name | Pretest | Test 1 | Test 2 | Test 3 | Midterm | Test 4 | Test 5 | Test 6 | Final
 | Total Points | 100 | 20 | 20 | 20 | 100 | 20 | 20 | 20 | 100
 | [NAME]
Student Name | Average
Student A |  | 35 | 5 | 6 | 8 | 39 | 7 | 5 | 14 | 43
Student B |  | 60 | 6 | 7 | 9 | 64 | 6 | 6 | 15 | 68
Student C |  | 53 | 7 | 8 | 10 | 57 | 0 | 7 | 16 | 61
Student D |  | 46 |  | 9 | 11 | 50 | 1 | 8 | 17 | 54
Student E |  | 65 | 9 | 10 | 12 | 69 | 2 | 9 | 18 | 73
Student F |  | 36 | 10 | 11 | 13 | 40 | 3 | 10 | 19 | 44
Student G |  | 0 | 11 | 12 | 14 | 80 | 4 | 11 | 20 | 84
Student H |  | 50 | 12 | 13 | 15 | 54 | 5 |  | 11 | 58
Student I |  | 72 | 13 | 14 | 16 | 76 | 6 | 13 | 12 | 80
Student J |  | 88 | 14 | 15 | 17 | 92 | 7 | 14 | 13 | 96
Student K |  | 34 | 10 | 12 | 3 | 89 | 7 | 18 | 13 | 76
Spreadsheet: 234017d1367982051-how-to-create-option-or-combo-box-within-cell-copy-of-test
Sheet: Lead

Date | Name | Gender | Residence Status | Contact | Contact content | Project Type | Subject Property Address | Advisor | MLS | Listing Price | Offer price | Down Payment | Loan Amount | Last Follow up date | Next Follow up date | Referred by | Commission Ratio | Current Status | Note
 | Client1 | M |  |  | [PHONE]
 | Client2 | F |  |  | [PHONE]
 | Client3 | F |  |  | 875623212
 | Client4 | M |  |  | [EMAIL]
 | Client5 | F |  |  | 1393023348
 | Client6 | F |  |  | 88 Somewhere St
 | Client7 | M |  |  | CEO
 | Client8 | M |  | Cell | [PHONE]
 | Client9 | M |  | [NAME] | [EMAIL]
Spreadsheet: b700502b-dd6c-4d27-b164-57956a5573c8
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (4 Entries):
 | 9 Electromechanics/System peripherals 9.1 Switches and keybords 9.1.4 Detector components 9.1.4.1 Event detectors/counters
No. | Company | Country | City | [NAME] | Hall/Booth
1 | ALDERS electronic GmbH | Germany | Tönisvorst | 47918 | B5.464
2 | [NAME]Vertriebs GmbH | Germany | Nagold | 72202 | A5.138
3 | [NAME], Inc. | USA | [NAME] | IL 60008 | B5.464
4 | Georg Schlegel GmbH & Co. [NAME]Elektrotechnische [NAME] | Germany | Dürmentingen | 88525 | B5.472
Spreadsheet: 799396d1665065673-icon-set-on-cell-with-formula-sample
Sheet: FOLDER 1

 | FOLDER 1 - FAMILY PROFILE
 | HH NO. | NO. OF HH MEMBERS | NO. OF CHILDREN |  |  |  |  | NAME OF FAMILY (LAST NAME, FIRST NAME) | NAME OF FAMILY (LAST NAME, FIRST NAME) | OCCUPATION | EDUCATIONAL ATTAINMENT | CHECK IF: |  |  | METHOD OF FAMILY PLANNING |  | CHECK IF:
 |  |  | 0-5  MOS. OLD | 6-11 MOS. OLD | 12-23 MOS. OLD | 24-59 MOS. OLD | [NAME] 60 MOS. OLD | HEAD OF FAMILY | HEAD OF FAMILY |  |  | MOTHER |  | COUPLE PRACTICING FAMILY PLANNING |  |  | NURSING ≤ 6 MOS. CHILD
 |  |  |  |  |  |  |  | SPOUSE | SPOUSE |  |  | PREGNANT | LACTATING |  |  |  | EBF
 | 1
 |  |  |  |  |  |  |  | IF(ISERROR(VLOOKUP(A4&":"&$H$2,'FOLDER 0.2'!$A:$AG,6,FALSE)),"",(VLOOKUP(A4&":"&$H$2,'FOLDER 0.2'!$A:$AG,6,FALSE))) | IF(ISERROR(VLOOKUP(A4&":"&$H$2,'FOLDER 0.2'!$A:$AG,6,FALSE)),"",(VLOOKUP(A4&":"&$H$2,'FOLDER 0.2'!$A:$AG,6,FALSE)))
Spreadsheet: 798128d1664313354-vlookup-combined-with-other-functions-error-fourth-option-question-copy
Sheet: Data

 | Almería
 | CURRENT SEQUENCES | Home | Away | Total |  | SCORING | Home | Away | All |  | Column1 | Home | Away | All
 | 1 goal scored or more | 2 | - | - |  | GF per match | 1.50 | 0.50 | 1.00 |  | Scoring Rate | 100% | 50% | 75%
 | 1 goal conceded or more | 2 | 2 | 4 |  | GA per match | 1.50 | 1.00 | 1.25 |  | Scoring Rate 1st-Half | 100% | 50% | 75%
 | No goal scored | - | 1 | 1 |  | GF + GA per match | 3.00 | 1.50 | 2.25 |  | Scoring Rate 2nd-Half | 50% | 0% | 25%
 | No goal conceded | - | - | - |  | GF+GA over 0.5 | 100% | 100% | 100% |  | Scored in both halves | 50% | 0% | 25%
 | 2 goals scored or more | 1 | - | - |  | GF+GA over 1.5 | 100% | 50% | 75% |  | Both teams scored | 100% | 50% | 75%
 |  |  |  |  |  | GF+GA over 2.5 | 100% | 0% | 50% |  | [NAME] | 100% | 100% | 100%
 |  |  |  |  |  | GF+GA over 3.5 | 0% | 0% | 0% |  | Conceding Rate 1st-Half | 50% | 50% | 50%
 |  |  |  |  |  | GF+GA over 4.5 | 0% | 0% | 0% |  | [NAME] 2nd-Half | 50% | 50% | 50%
 |  |  |  |  |  | GF+GA over 5.5 | 0% | 0% | 0% |  | Conceded in both halves | 0% | 0% | 0%
 |  |  |  |  |  | GF+GA over 0.5 at HT | 100% | 50% | 75%
 |  |  |  |  |  | GF+GA over 1.5 at HT | 50% | 50% | 50%
 |  |  |  |  |  | GF+GA over 2.5 at HT | 0% | 0% | 0%
 | Athletic Club
 | CURRENT SEQUENCES | Home | Away | Total |  | SCORING | Home | Away | All |  | Column1 | Home | Away | All
 | 1 goal scored or more | - | 1 | - |  | GF per match | 0.33 | 4.00 | 1.25 |  | Scoring Rate | 33% | 100% | 50%
 | 1 goal conceded or more | 1 | - | 1 |  | GA per match | 0.33 | 0.00 | 0.25 |  | Scoring Rate 1st-Half | 33% | 100% | 50%
 | No goal scored | 1 | - | 1 |  | GF + GA per match | 0.67 | 4.00 | 1.50 |  | Scoring Rate 2nd-Half | 0% | 100% | 25%
 | No goal conceded | - | 1 | - |  | GF+GA over 0.5 | 67% | 100% | 75% |  | Scored in both halves | 0% | 100% | 25%
 | 2 goals scored or more | - | 1 | - |  | GF+GA over 1.5 | 0% | 100% | 25% |  | Both teams scored | 0% | 0% | 0%
 |  |  |  |  |  | GF+GA over 2.5 | 0% | 100% | 25% |  | [NAME] | 33% | 0% | 25%
 |  |  |  |  |  | GF+GA over 3.5 | 0% | 100% | 25% |  | Conceding Rate 1st-Half | 0% | 0% | 0%
 |  |  |  |  |  | GF+GA over 4.5 | 0% | 0% | 0% |  | [NAME] 2nd-Half | 33% | 0% | 25%
 |  |  |  |  |  | GF+GA over 5.5 | 0% | 0% | 0% |  | Conceded in both halves | 0% | 0% | 0%
 |  |  |  |  |  | GF+GA over 0.5 at HT | 33% | 100% | 50%
 |  |  |  |  |  | GF+GA over 1.5 at HT | 0% | 0% | 0%
 |  |  |  |  |  | GF+GA over 2.5 at HT | 0% | 0% | 0%