tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715080d1611551583-return-value-with-multiple-conditions-copie-de-forum-excel-25-jan-2021
Sheet: Projection

 | Last month | This month | [NAME] | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
First date |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Last date |  |  | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Épargne et inv.  (défilé [NAME]) | Last month | This month | January | February | March | April | May | June | July | August | September | October | November | December
AR |  |  | 120 | 50 | 90 | 30 |  |  |  | 18 |  |  | 75 | 100
FT |  |  | 20 | 60 | 25 | 45 |  |  |  | 60 |  |  | 95 | 50
PL
UR
BL
YL
Spreadsheet: 06bf0285-1299-4fef-9929-9412aabc640e
Sheet: Country data availability

WATER ABSTRACTIONS BY SECTOR - 1990 vs 2009
To be presented as a separate bar graph for each sector, showing water abstraction and GDP (or some other measure) for 1990 and 2009 - within each bar of the graph showing 'stacking' by Region.
Data based on those received from [NAME], 23 JAN 2012 - see email of same date.
Information on year of data from document from [NAME], email 30 JAN 2012
 |  |  | Agriculture - Irrigation |  | Public Water Supply |  | Industry - Manufacturing |  | Energy - Cooling
 |  | Regions/Countries | 1990's year | Latest year | 1990's year | Latest year | 1990's year | Latest year | 1990's year | Latest year
 |  | Eastern Europe
 |  | Bulgaria | 1990 | 2009 | 1990 | 2009 | 1990 | 2009 | 1990 | 2009
 |  | Croatia |  |  |  |  | 1996 | 2009
 |  | Czech Republic | 1990 | 2009 | 1990 | 2009 | 1990 | 2009 | 1990 | 2009
 |  | Estonia |  |  | 1998 | 2009 | 1998 | 2009 | 1990 | 2009
 |  | Hungary | 1992 | 2006 | 1992 | 2009 | 1992 | 2008 | 1992 | 2008
 |  | Latvia | 1991 | 2007 |  |  | 1991 | 2007
 |  | Poland | 1990 | 2009 | 1990 | 2009 | 1990 | 2009 | 1990 | 2009
 |  | Romania | 1990 | 2009 | 1990 | 2009 | 1990 | 2009 | 1991 | 2009
 |  | Slovakia | 1990 | 2007 | 1990 | 2007 | 1990 | 2007
 |  | Slovenia | 1990 | 2009 | 1990 | 2009 | 1990 | 2009
 |  | Western Europe
 |  | Austria | 1990 | 2002 | 1990 | 2008 | 1990 | 2008 | 1990 | 2008
 |  | Belgium | 1994 | 2007 | 1990 | 2009 | 1994 | 2007 | 1994 | 2007
 |  | Denmark | 1990 | 2009 | 1990 | 2009 | 1990 | 2009
 |  | England & Wales | 1990 | 2008 |  |  | 1990 | 2008 | 1990 | 2008
 |  | Finland | 1994 | 2005 | 1990 | 2005 | 1990 | 2005 | 1990 | 2005
 |  | Germany | 1995 | 2007 | 1991 | 2007 | 1991 | 2009 | 1991 | 2007
 |  | Iceland |  |  | 1992 | 2005 | 1992 | 2005
 |  | Ireland |  |  | 1994 | 2007
 |  | Netherlands | 1995 | 2006 | 1990 | 2008 | 1990 | 2008 | 1990 | 2008
 |  | Norway | 1995 | 2006 | 1990 | 2007 | 1999 | 2009
 |  | Sweden | 1990 | 2007 | 1990 | 2007 | 1990 | 2007 | 1990 | 2007
 |  | Switzerland |  |  | 1990 | 2006 |  |  | 1990 | 2006
 |  | United Kingdom |  |  | 1990 | 2008
 |  | Southern Europe
 |  | Cyprus |  |  | 1998 | 2009
 |  | France | 1991 | 2007 | 1990 | 2007 | 1990 | 2006 | 1990 | 2007
 |  | FYR, of Macedonia |  |  | 1990 | 2009 | 1990 | 2009 | 1990 | 2009
 |  | Greece | 1990 | 2007 | 1997 | 2007 | 1997 | 2003 | 1990 | 2007
 |  | Italy |  |  | 1989 | 2008
 |  | Malta |  |  | 1995 | 2009
 |  | Portugal | 1990 | 1998 | 1990 | 2008
 |  | Spain | 1991 | 2008 | 1991 | 2008 | 1991 | 2006 | 1991 | 2008
 |  | Turkey | 1995 | 2007 | 1994 | 2008 | 1995 | 2008 | 1994 | 2008
 |  |  | Agriculture | GVA year | Public Water Supply | Population year | Industry | GVA year | Energy | Kw/hr year
 |  | No. countries with data | 22 |  | 29 |  | 25 |  | 19
 |  | No. countries with 1990 data | 12 | 1990 | 18 | 1990 | 14 | 1990 | 13 | 1990
 |  | No. countries with 2009 data | 6 |  | 12 |  | 11 |  | 6
 |  |  | 2007(8) |  | 2007 (7) |  | 2008 (5) |  | 2008 (6)
 |  |  |  |  | 2008 (7) |  | 2007 (4) |  | 2007 (5)
Spreadsheet: 6ebf4909-bb13-46e8-81d4-9cbf6ad81e4f
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43597666 | 2014-10-15 23:19:16 | AXIS | 1 | 6 | 2 | 377160 | docsteve | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
43598024 | 2014-10-15 23:49:12 | ALLIES | 1 | 7 | 6 | 1461913 | IgorekUA | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43598373 | 2014-10-16 00:12:00 | AXIS | 1 | 7 | 3 | 1461913 | IgorekUA | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43635120 | 2014-10-18 18:52:12 | AXIS | 1 | 5 | 4 | 1391411 | Vince 56 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43635362 | 2014-10-18 19:19:04 | ALLIES | 1 | 5 | 3 | 1391411 | Vince 56 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43655484 | 2014-10-20 01:32:13 | AXIS | 0 | 4 | 5 | 386133 | jskimming | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43655777 | 2014-10-20 02:07:46 | ALLIES | 1 | 5 | 3 | 386133 | jskimming | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43683852 | 2014-10-22 01:02:07 | ALLIES | 0 | 5 | 7 | 1548227 | Therion75 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43697671 | 2014-10-23 01:17:49 | ALLIES | 1 | 6 | 3 | 692398 | Morgiliath | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43798825 | 2014-10-30 02:17:06 | ALLIES | 0 | 2 | 6 | 26778 | gheintze | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
43798999 | 2014-10-30 02:33:48 | AXIS | 1 | 6 | 1 | 26778 | gheintze | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: 820125d1677869052-multiple-options-for-a-cells-content-based-on-content-in-another-cell-test
Sheet: Master

EMPLOYEE NUMBER | NAME | BARCODE (3 of 9 [NAME]) | DOB | PLACE OF BIRTH | EMPLOYER | TRADE | ISSUE DATE | EXP DATE | US CITIZEN?
13356 | Smith, [NAME] |  | 1988-01-12 00:00:00 | Tampa, FL | [NAME] | Drywall |  |  | YES
15555 | Jones, [NAME] |  | 2000-09-02 00:00:00 | Denver, CO | AcmeCrete | Concrete |  |  | YES
1258899 | Trump, [NAME] |  | 1950-02-12 00:00:00 | New York, NY | Self | Plumber |  |  | NO
Spreadsheet: 03d5e858-3b4a-4531-b503-7fa64f2d87bb
Sheet: 2007

School of Nursing 2007
 |  | BSN |  | MEPN |  | MN & MS |  | [NAME]* |  | PhD |  | DNP |  | School Totals |  | Total Grad
Total Number
Ethnic Diversity
Citizens/Permanent Residents
American Indian or Native Am. |  | 5 |  | 1 |  | 1 |  | 3 |  | 0 |  | 1
Asian or Asian American |  | 36 |  | 4 |  | 17 |  | 0 |  | 8 |  | 0
African American |  | 14 |  | 1 |  | 6 |  | 1 |  | 8 |  | 0
Hispanic or Latino |  | 5 |  | 0 |  | 5 |  | 1 |  | 3 |  | 1
Hawaiian or Pacific Islander |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
White |  | 119 |  | 18 |  | 188 |  | 25 |  | 33 |  | 40
Not Indicated |  | 12 |  | 0 |  | 39 |  | 2 |  | 8 |  | 2
International |  | 1 |  | 0 |  | 1 |  | 0 |  | 22 |  | 0
Minority
Underrepresented Minority
*Formerly listed as Post-masters
**Based on Autumn quarter 10th day census data / Seattle campus only
***Underrepresented students do not include Asian or Asians Americans
****Grad Certificate students may be enrolled in other programs
Spreadsheet: 468674d1467446376-copy-paste-special-between-sheets-problem1
Sheet: 11nov

 |  | st rita2 |  |  |  | kontich |  |  |  | [NAME] | rumst
 |  | 9,98/u | 13,26/u |  | 13,26/u | 9,98/u | 13,26/u | 13,26/u | 6,63/u | 20/u | 14/u | 14/u
 |  | 24.95 | 19.89 |  | 33.15 | 19.96 | 26.52 | 33.15 | 16.58 | 70 | 35 | 24.5
 |  | za | za | woe | di | za | za | di | do | ma | zo | woe
 |  | 9-11.30 | 11.30-13 | 13-15 | 20-22.30 | 9-11 | 11-13 | 20-22.30 | 20-22.30 | 19-22.30 | 19-21.30 | 20.30-22.15
zo | 2015-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | ok
ma | 2015-11-02 00:00:00
di | 2015-11-03 00:00:00 |  |  |  | ok
wo | 2015-11-04 00:00:00
do | 2015-11-05 00:00:00
vr | 2015-11-06 00:00:00
za | 2015-11-07 00:00:00 | ok eb | ok
zo | 2015-11-08 00:00:00 |  |  |  |  |  |  |  |  |  | ok
ma | 2015-11-09 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-11-10 00:00:00
wo | 2015-11-11 00:00:00
do | 2015-11-12 00:00:00
vr | 2015-11-13 00:00:00
za | 2015-11-14 00:00:00 | ok eb | ok
zo | 2015-11-15 00:00:00 |  |  |  |  |  |  |  |  |  | ok
ma | 2015-11-16 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-11-17 00:00:00 |  |  |  | ok pn
wo | 2015-11-18 00:00:00 |  |  | nhp |  |  |  |  |  |  |  | ok k
do | 2015-11-19 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-11-20 00:00:00
za | 2015-11-21 00:00:00
zo | 2015-11-22 00:00:00 |  |  |  |  |  |  |  |  |  | ok
ma | 2015-11-23 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-11-24 00:00:00 |  |  |  | ok pn
wo | 2015-11-25 00:00:00 |  |  | nhp |  |  |  |  |  |  |  | ok k
do | 2015-11-26 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-11-27 00:00:00
za | 2015-11-28 00:00:00 | ok eb | ok
zo | 2015-11-29 00:00:00
ma | 2015-11-30 00:00:00 |  |  |  |  |  |  |  |  | ok
Spreadsheet: 82890d1282897192-table-formatting-fabrication
Sheet: Employees

Name | Position | Jobs | C/Vale Available
[NAME] | Machinist | 0C884 | YES
Abas Silan | Grinder | 0C604 | NO
[NAME] | painter | 0C770
[NAME] | Hard Face welder | 0C666
Antony Sear | Grinder | 0C421
[NAME] | Welder
[NAME] | Hard Face welder
[NAME] | Boilermaker
[NAME] | Boilermaker
[NAME] | Boilermaker
[NAME] | Boilermaker/Welder
[NAME] | Grinder
[NAME] | Welder
[NAME] | Grinder
[NAME] | Blaster
[NAME] | Grinder
[NAME] | Hard Face welder
[NAME] | Welder
[NAME] | Welder
[NAME] | Boilermaker/Pipe Fitter
[NAME] | Hard Face welder
[NAME] | Grinder
[NAME] | Welder Leading Hand
[NAME] | Welder
[NAME] | Boilermaker
[NAME] | Hard Face welder
[NAME] | Welder
[NAME] | Grinder
[NAME] | Machinist
Spreadsheet: 722514d1615304725-linear-forecast-between-two-values-in-a-column-with-empty-cells-between-linear-forecast-ans
Sheet: LINEAR FORECAST

 |  | LINEAR FORECAST BETWEEN VALUES IN YELLOW COLUMN (MANUALLY HANDLED) | DRAG DOWN FORECAST HERE
3.2 | 0
3.4
3.6
3.8
4
4.2
4.4
4.6
4.8
5 | 13
5.2
5.4
5.6
5.8
6
6.2
6.4
6.6
6.8
7 | 11
7.2
7.4
7.6
7.8
8
8.2
8.4 | 13
8.61
8.8
9 | 24
9.2
9.4
9.6
9.8
10
10.2
10.4
10.6
10.8
11 | 15
11.2
11.4
11.6
11.8
12
12.2
12.4
12.6
12.8
13 | 32
13.2
13.4
13.6
13.8
14
14.2
14.4
14.6
14.8
15 | 30
15.2
15.4
15.6
15.8
16
16.2
16.4
16.6
16.8
17 | 35
17.2
17.4
17.6
17.8
18
18.2
18.4
18.6
18.8
19 | 43
19.2
19.4
19.6
19.8
20
20.2
20.4
20.6
20.8
21 | 75
21.2
21.4
21.6
21.8
22
22.2
22.4
22.6
22.8
23 | 98
23.2
23.4
23.6
23.8
24
24.2
24.4
24.6
24.8
25 | 98
25.2
25.4
25.6
25.8
26
26.2
26.4
26.6
26.8
27 | 100
27.2
27.4
27.6
27.8
28
28.2
28.4
28.6
28.8
29 | 190
29.2
29.4
29.6
29.8
30
30.2
30.4
30.6
30.8
31 | 150
31.2
31.4
31.6
31.8
32
32.2
32.4
32.6
32.8
33 | 170
33.2
33.4
33.6
33.8
34
34.2
34.4
34.6
34.8
35 | 175
35.2
35.4
35.6
35.8
36
36.2
36.4
36.6
36.8
37 | 220
37.2
37.4
37.6
37.8
38
38.2
38.4
38.6
38.8
39 | 230
39.2
39.4
39.6
39.8
40
40.2
40.4
40.6
40.8
41 | 280
41.2
41.4
41.6
41.8
42
42.2
42.4
42.6
42.8 | 285
43
43.2
43.4
43.6
43.8
44
44.2
44.4
44.6
44.8
44.98 | 399
Spreadsheet: geir_solberg__11276__10_31act
Sheet: EPEData

 | 37280.48680555556
 | NEWMAN 1 ,ECON, 43  , 75  , 39  , 83  , 33  ,1
 | NEWMAN 2 ,MANL, 78  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 40  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,172  ,215  , 86  ,214  , 43  ,1
 | NEWMAN   ,, 333 ,  467,  194, 483 , 115 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,UNAV,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,MANL,128  ,130  , 56  ,151  ,  0  ,1
 | RIOGRANDE,, 128 ,  130,   56, 151 ,   0 ,
 | PALOVERDE,MANL,191  ,191  ,191  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 96  , 96  , 96  ,104  ,  0  ,1
 | LAMBDA, 31.25,  831,  830,  124,    5,    0,20162,40
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 883672d1732301838-merging-in-out-with-absent-dates-into-a-single-pivot-table-formula-power-query-sample-emp-waqas-gul-
Sheet: Sheet1

First Table |  |  |  |  |  |  | Second Table
Employee | Date | Time | Status | Column1 |  |  | Employee | 1/1/2024 | 1/2/2024 | 1/3/2024
1 | 2024-01-01 00:00:00 | 08:13:00 | IN |  |  |  | 1 |  |  | A |  |  |  | below is the table like what I love to extract from the 2 data tables (Excel or Power Query)
1 | 2024-01-01 00:00:00 | 18:19:00 | OUT |  |  |  | 2 |  | CL
1 | 2024-01-02 00:00:00 | 08:05:00 | IN |  |  |  | 3 | AL |  |  |  |  |  |  | 2024-01-01 00:00:00 |  | 2024-01-02 00:00:00 |  | 2024-01-03 00:00:00
1 | 2024-01-02 00:00:00 | 17:10:00 | OUT |  |  |  |  |  |  |  |  |  |  | Employee Emp | IN | OUT | IN | OUT | IN | OUT
2 | 2024-01-01 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  |  |  |  | 1 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | AL | AL
2 | 2024-01-01 00:00:00 | 17:00:00 | OUT |  |  |  |  |  |  |  |  |  |  | 2 | 08:00:00 | 17:00:00 | CL | CL | 08:00:00 | 17:00:00
2 | 2024-01-03 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  |  |  |  | 3 | A | A | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00
2 | 2024-01-03 00:00:00 | 08:12:00 | IN
2 | 2024-01-03 00:00:00 | 17:00:00 | OUT |  |  |  | Time Text | Date | Status
3 | 2024-01-02 00:00:00 | 08:00:00 | IN |  |  |  |  | 2024-01-01 00:00:00 |  | 2024-01-02 00:00:00 |  | 2024-01-03 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-02-02 00:00:00 |  | 2024-02-03 00:00:00 |  | 2024-03-02 00:00:00
3 | 2024-01-02 00:00:00 | 17:00:00 | OUT |  |  |  | Employee | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN
3 | 2024-01-02 00:00:00 | 18:22:00 | OUT |  |  |  | 1 | 08:13 AM | 06:19 PM | 08:05 AM | 05:10 PM | A |  | 08:00 AM | 05:00 PM |  | 05:00 PM |  |  | 08:00 AM
3 | 2024-01-03 00:00:00 | 08:00:00 | IN |  |  |  | 2 | 08:00 AM | 05:00 PM | CL |  | 08:11 AM | 05:00 PM | 08:00 AM | 05:00 PM |  |  | 08:00 AM | 05:00 PM
3 | 2024-01-03 00:00:00 | 17:00:00 | OUT |  |  |  | 3 | AL |  | 08:00 AM | 06:22 PM | 08:00 AM | 05:00 PM |  |  | 08:00 AM | 05:00 PM | 08:00 AM | 05:00 PM
1 | 2024-02-01 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  | 6:22 PM be here | 8:11 AM here
1 | 2024-02-01 00:00:00 | 17:00:00 | OUT
1 | 2024-03-02 00:00:00 | 08:00:00 | IN
1 | 2024-02-02 00:00:00 | 17:00:00 | OUT
2 | 2024-02-01 00:00:00 | 08:00:00 | IN
2 | 2024-02-01 00:00:00 | 17:00:00 | OUT
2 | 2024-02-03 00:00:00 | 08:00:00 | IN
2 | 2024-02-03 00:00:00 | 17:00:00 | OUT
3 | 2024-02-02 00:00:00 | 08:00:00 | IN
3 | 2024-02-02 00:00:00 | 17:00:00 | OUT
3 | 2024-02-03 00:00:00 | 08:00:00 | IN
3 | 2024-02-03 00:00:00 | 17:00:00 | OUT
Spreadsheet: 239196d1369843540-how-to-create-2-dependent-drop-down-lists-with-1-to-2-relationship-price-calcuation-v2
Sheet: Color and Other Specifications

Name | Color Selection
TableTents | Black
TableTents | Custom
WoodTableStands | Hanging Stand -Mahogany Wood/Brass
WoodTableStands | Hanging Stand -Black Wood/Nickel
WoodTableStands | Top Load Natural Wood
WoodTableStands | Flip Style Natural Wood
SoftTouchTableTents | [NAME] Touch
SoftTouchTableTents | [NAME] Touch
SoftTouchTableTents | Burgundy -Soft Touch
SoftTouchTableTents | Pecan Brown -Soft Touch
SoftTouchTableTents | [NAME] Touch
SoftTouchTableTents | Charcoal Black -Soft Touch
ClearTriangleTableTents | Red -Leatherette Frayless
ClearTriangleTableTents | Mauve -Leatherette Frayless
ClearTriangleTableTents | Turquoise -Leatherette Frayless
ClearTriangleTableTents | Teal -Leatherette Frayless
ClearTriangleTableTents | Brown -Leatherette Frayless
ClearTriangleTableTents | Forest Green -Leatherette Frayless
ClearTriangleTableTents | Black -Leatherette Frayless
ClearTriangleTableTents | Burgundy -Leatherette Frayless
ClearTriangleTableTents | Dark Blue -Leatherette Frayless
ClearTriangleTableTents | Ruby -High Gloss Frayless
ClearTriangleTableTents | Concord Grape -High Gloss Frayless
ClearTriangleTableTents | [NAME] Frayless
ClearTriangleTableTents | Brown Marble -High Gloss Frayless
ClearTriangleTableTents | Red Marble -High Gloss Frayless
ClearTriangleTableTents | Gray Granite -High Gloss Frayless
ClearTriangleTableTents | Black Granite -High Gloss Frayless
ClearTriangleTableTents | Green lizard -Textured Frayless
ClearTriangleTableTents | Brown lizard -Textured Frayless
ClearTriangleTableTents | [NAME] -Textured Frayless
ClearTriangleTableTents | Blue Iguana -Textured Frayless
ClearTriangleTableTents | [NAME] Frayless
ClearTriangleTableTents | Sand Iguana -Textured Frayless
ClearTriangleTableTents | [NAME] Frayless
ClearTriangleTableTents | Black Iguana -Textured Frayless
ClearTriangleTableTents | Bronze -Metallics Frayless
ClearTriangleTableTents | Olive -Metallics Frayless
ClearTriangleTableTents | Green -Metallics Frayless
ClearTriangleTableTents | Blue -Metallics Frayless
ClearTriangleTableTents | Burgundy -Metallics Frayless
ClearTriangleTableTents | Silver -Metallics Frayless
Spreadsheet: 02c5f0e3-48a3-48d0-9027-7f1ee76b3c94
Sheet: Chart Data %

 | FY 2001 | FY 2002 | FY 2003 | FY 2004 | FY 2005 | FY 2006 | FY 2007 | FY 2008
General Appropriations
Federal Grants & Contracts
Student Fees
Sales & Serv of Aux Ent
Other Student Fees
Sales & Serv of Educ Act
Private Gifts, Grts & Contr
State Grants & Contracts
Indirect Costs
Other
Endowment Funds
Federal Approp
Total Revenue
Instruction
Scholarships & Fellowships
Auxiliary Enterprises
Research
Institutional Support
Physical Plant
Academic Support
Public Service
Student Services
Libraries
Total Uses
Spreadsheet: 809217d1670958507-calculate-how-many-people-are-working-at-the-same-time-using-the-countifs-function-stats-sheet-test
Sheet: Sheet1

 |  |  |  |  |  | Working Hours | Staff Working
 | Stephan | 08:00:00 | 16:00:00 |  |  | 08:00:00
 | [NAME] | 08:00:00 | 16:00:00 |  |  | 09:00:00
 | Kelly | 08:00:00 | 16:00:00 |  |  | 10:00:00
 | [NAME] | 10:00:00 | 18:00:00 |  |  | 11:00:00
 | Julian | 10:00:00 | 18:00:00 |  |  | 12:00:00
 | Samantha | 10:00:00 | 18:00:00 |  |  | 13:00:00
 | [NAME] | 10:00:00 | 18:00:00 |  |  | 14:00:00
 | [NAME] | 10:00:00 | 18:00:00 |  |  | 15:00:00
 | Georgine | 10:00:00 | 18:00:00 |  |  | 16:00:00
 | June | 11:00:00 | 15:00:00 |  |  | 17:00:00
 | [NAME] | 11:00:00 | 15:00:00 |  |  | 18:00:00
 | Haydee | 11:00:00 | 15:00:00
 | Asb,ey | 08:00:00 | 16:00:00
 | Tosha | 08:00:00 | 16:00:00
 | Selena | 08:00:00 | 16:00:00
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -14 |  | -54985 | -54900
2 |  |  | -45523 | -45012
3 | -19469 | -20000 | -31996 | -29900
4 | -10157 | -10000 | -65915 | -65318
5 | -29699 | -29869 | -63672 | -63430
6 | -29789 | -29869 | -64157 | -63430
7 | -29899 | -29869 | -83960 | -83430
8 | -10720 | -10152 | -104080 | -104207
9 | -14972 | -15000 | -57592 | -56846
10 | -14997 | -15000 | -93909 | -93216
11 | -613 |  | -79398 | -78955
12 | -5137 | -5000 | -58921 | -59382
13 | -5527 | -5000 | -59922 | -59382
14 | -5814 | -5000 | -57766 | -57060
15 |  |  | -88029 | -87799
16 | -4789 | -4155 | -81538 | -80882
17 | -22716 | -22154 | -91856 | -91315
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 9676
2002-01-17 00:00:00
CBS $
 |  |  | 19943.24
Spreadsheet: 823113d1679715637-summarizing-a-workbook-lego-replacement-parts
Sheet: Set # 7255

Checked | Qty | Part# | Colour | Description
 | 1 | 4227505 | [NAME] | Cape
 | 4 | 30377 | White | Arm Mechanical, Battle Droid
 | 1 | 4073 | Light Grey | Plate, Round 1 x 1
 | 2 | 42003 | Light Grey | Technic, [NAME] and Pin Connector Perpendicular 3L with 2 Pin Holes
 | 1 | 32039 | Pearl Light Grey | Technic, Axle Connector with Axle Hole
Spreadsheet: 869376d1715948392-colour-gradient-formula-dummy
Sheet: Sheet1

 |  | 1 |  | 1.631578947368421 | 1.947368421052631 | 2.263157894736842 | 2.578947368421053 | 2.894736842105263 | 3.210526315789473 | 3.526315789473684 | 3.842105263157895 | 4.157894736842105 | 4.473684210526315 | 4.789473684210526 | 5.105263157894736 | 5.421052631578947 | 5.736842105263158 | 6.052631578947368 | 6.368421052631579 | 6.684210526315789 | 7
 |  | 1
 |  | 1.705882352941177
 |  | 2.058823529411764
 |  | 2.411764705882353
 |  | 2.764705882352941
 |  | 3.117647058823529
 |  | 3.470588235294118
 |  | 3.823529411764706
 |  | 4.176470588235294
 |  | 4.529411764705882
 |  | 4.882352941176471
 |  | 5.235294117647059
 |  | 5.588235294117648
 |  | 5.941176470588236
 |  | 6.294117647058824
 |  | 6.647058823529412
 |  | 7
Spreadsheet: 731466d1620355384-please-help-me-with-these-functions-excel-test-junior-accountant
Sheet: Test 2

Group Name | Group Segment | Physician Expense | Region | Adjusted Region
[NAME] | Big | 6186.995752359548 | N | 1-North
[NAME] | Small | 4918.404737416461 | S | 2-South
Examineers Inc | Medium | 4635.026810398586 | E | 3-East
[NAME] | Small | 7436.590733418787 | W | 4-West
FASST Trax | Small | 3035.751883566108 | SE | 2-South
[NAME] | Big | 3597.815628432074 | NE | 1-North
Hehehe | Medium | 4903.350075762555 | N | 1-North
[NAME] | Small | 2363.567081527782 | S | 2-South
Creepy Lada | Medium | 7128.586370287349 | E | 3-East
Jokes R Us | Big | 7033.60535246887 | W | 4-West
Petie's Palace | Small | 5079.099781827978 | SE | 2-South
Use formulas to calculate the following:
1. Total expense for the "Small" Group Segment
2. Total expense for the "Small" Group Segment and "SE" Region
3. Number of groups names
4. The number of groups in the SE Region
Formatting:
1. Use conditional formatting to highlight duplicate values under the region column
2. Use conditional formatting to highlight in green all expenses greater than $5,000
Spreadsheet: 149260d1333784705-generating-reports-automatically-generating-reports
Sheet: ENGLISH

Roll | Name | CT | IA | GA | OR | EX | AVG | GR
1 | a | 10 | 10 | 10 |  |  |  | A1
2 | b |  | 9 | 5 |  |  |  | B2
3 | c | 5 | 9 |  | 2 | 4 |  | C2
4 | d
5 | e | 4 | 9 | 7 | 6 | 6 |  | B2
6 | f
7 | g
8 | h
9 | i
10 | j