tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 181fd2d5-b923-45f2-ba3d-dbbd79badfa3
Sheet: 1998-99

Table Q
Full Time Affiliate Student numbers
Department | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Anatomy and Developmental Biology | 0 | 2 |  | 0 | 0
Anthropology | 1 | 17 |  | 0 | 1
Institute of Archaeology | 5 | 4 |  | 0 | 2
[NAME] | 26 | 6 |  | 10 | 2
Biochemical Engineering | 2 | 0 |  | 0 | 0
Biochemistry and Molecular Biology | 1 | 0 |  | 0 | 0
Biology | 0 | 12 |  | 0 | 0
Chemical Engineering | 10 | 2 |  | 0 | 0
Chemistry | 1 | 2 |  | 1 | 0
Civil and Environmental Engineering | 1 | 8 |  | 1 | 0
Comparative Literature Affiliates | 0 | 9 |  | 0 | 0
Computer Science | 0 | 3 |  | 2 | 0
Development Planning Unit | 0 | 0 |  | 0 | 1
[NAME] and Literature | 6 | 0 |  | 0 | 0
Economics | 1 | 44 |  | 2 | 1
Electronic and Electrical Engineering | 7 | 0 |  | 1 | 0
English Language and Literature | 4 | 22 |  | 0 | 0
Slade School of Fine Art | 4 | 13 |  | 0 | 1
[NAME] Unit | 0 | 0 |  | 0 | 4
Geography | 9 | 18 |  | 0 | 0
Geological Sciences | 0 | 0 |  | 0 | 1
Geomatic Engineering | 0 | 0 |  | 1 | 0
German | 15 | 2 |  | 0 | 0
Greek and Latin | 3 | 0 |  | 1 | 1
Hebrew and Jewish Studies | 0 | 2 |  | 0 | 0
History | 8 | 14 |  | 3 | 0
History of Art | 5 | 10 |  | 0 | 0
Human Communication Science | 0 | 0 |  | 0 | 1
Italian | 31 | 0 |  | 0 | 0
Laws | 30 | 0 |  | 0 | 34
Mathematics | 0 | 4 |  | 0 | 0
Mechanical Engineering | 0 | 1 |  | 0 | 0
Pharmacology | 1 | 0 |  | 0 | 0
Philosophy | 0 | 9 |  | 0 | 0
Phonetics and [NAME] | 0 | 1 |  | 0 | 0
Physics and Astronomy | 1 | 1 |  | 0 | 0
Psychology | 2 | 20 |  | 0 | 0
Scandinavian Studies | 8 | 0 |  | 0 | 0
Science and Technology Studies | 2 | 7 |  | 0 | 0
Total
Faculty | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Arts and Humanities | 71 | 58 |  | 1 | 2
Built Environment | 26 | 6 |  | 10 | 3
Engineering | 20 | 11 |  | 3 | 0
Laws | 30 | 0 |  | 0 | 34
Life Sciences | 4 | 34 |  | 0 | 6
Mathematical and Physical Sciences | 4 | 17 |  | 3 | 1
Social and Historical Sciences | 29 | 107 |  | 5 | 3
Total
As figures relate to the official HEFCE census date, 1 December, affiliate students who start in January are not included.
Spreadsheet: 107934d1305061499-populate-data-from-1-tab-to-another-samplefile
Sheet: MASTER

REQUIRED TRAINING |  |  | AS OF MAY 1, 2011
STATUS | [NAME] | NOT COMPLETE | LAST NAME | FIRST NAME | DIV | DEPT NAME | SUPERVISOR
Active | X |  | [NAME] | [NAME] | PTSV | Float | NR
Active | X |  | BRADY | [NAME] | PTSV | Critical Care | NR
Active | X |  | CARROLL | KATHY | PTSV | Surgery | NR
Active |  | X | DEED | PETER | VASC | Genetics | MG
Active | X |  | ELLIOT | MAX | SURG | Pain | NK
Active | X |  | FRANK | ALEXANDER | HR | Human Resources | SC
Active | X |  | GABRIEL | MICHELLE | PTSV | Surgery | RN
Active |  | X | HILTON | DIANA | STRAT | Information Services | NK
Active | X |  | ISAAC | RACHEL | CARD | Laboratory | MG
Active | X |  | [NAME] | DENISE | STRAT | Education | MM
Active | X |  | KINCAID | [NAME] | PTSV | Critical Care | RN
Active | X |  | LOINEL | [NAME] | PTSV | Family Services | RN
Active | X |  | MASTERS | CATHERINE | PTSV | NICU | RN
Active | X |  | NORSE | MARY | STRAT | Records | BJ
Active | X |  | OBRIEN | [NAME] | STRAT | Records | BJ
Active | X |  | PARNELL | DEBORAH | [NAME] | R-Therapy | WD
Active | X |  | RICHARDSON | PHILIP | EXTR | Volunteers | BJA
Active | X |  | SMITH | PAMELA | PTSV | Critical Care | NR
Active |  | X | TALENT | SARAH | STRAT | E-Services | BJ
Spreadsheet: 865208d1712247383-keep-a-running-total-of-work-hours-duty-hours
Sheet: Duty Allocation

 | 2023-12-01 00:00:00 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | Weekly Hours
 | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No
[NAME] | OFF | OFF | 1 | 2 | 2 | 5 | 1
[NAME] | 1 | 3 |  | OFF | OFF
Stuart | 2 |  | 3 |  |  | OFF | OFF
[NAME] | 1 | OFF | OFF | 5
[NAME] |  |  | OFF | OFF
[NAME] | OFF | 4 | 1 |  |  |  | OFF
Duty No | Hours
1 | 08:15:00
2 | 10:30:00
3 | 09:00:00
4 | 07:00:00
5 | 09:00:00
Spreadsheet: a8e72dd0-0ea1-439c-9ebe-eebf0941f17f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259310 | 23582 | Eli | Iwens | BEL | 836 | [NAME] | 00:04:27 | 03:28:41 | 00:06:36 | 01:56:10 | 1 | 06:27:35
259310 | 11606 | [NAME] | Escoffier | FRA | 834 | 00:52:26 | 00:03:29 | 03:33:08 | 00:06:27 | [NAME] | 2 | 06:39:00
259310 | 70515 | [NAME] | Bertolino | FRA | 832 | 01:03:12 | [NAME] | 04:36:30 | 00:12:01 | 02:56:36 | 3 | 08:59:00
Spreadsheet: 176164d1345745661-add-data-that-is-missing-because-its-value-is-zero-data_for_help_forum
Sheet: Pivot Table

Blocks | Cover Type | Sum of Area (ha)
1 | 1 | 6.975211099699998
 | 2 | 128.5163625026003
 | 3 | 729.818399914797
 | 4 | 109.1526083195001
 | 5 | 441.0068523999976
 | 6 | 418.049876766697
 | 7 | 1.6385683319
 | 9 | 34.02438274810002
 | 10 | 10.7760498013
 | 11 | 185.6274469667996
 | 12 | 83.97178748930037
 | 13 | 34.75804841830001
 | 14 | 166.6125451293007
2 | 1 | 21.24319261460002
 | 2 | 63.54830972640029
 | 3 | 139.6456120395004
 | 4 | 360.7467016187999
 | 5 | 331.071894809899
 | 6 | 162.9976855451004
 | 7 | 7.9387859726
 | 8 | 0.6299999998999999
 | 9 | 31.3034329815
 | 10 | 130.5651818126002
 | 11 | 47.91240248100005
 | 12 | 795.3224096291917
 | 13 | 40.79302086690001
 | 14 | 207.2794893855996
3 | 1 | 1.0498301049
 | 2 | 106.1926923146006
 | 3 | 500.4029375051952
 | 4 | 338.5424553273999
 | 5 | 280.1277108994989
 | 6 | 351.1351891878996
 | 7 | 1.4741841314
 | 10 | 284.3954413494999
 | 11 | 139.7665609304003
 | 12 | 59.6947496681002
 | 13 | 23.0596395841
 | 14 | 242.4543931352999
4 | 2 | 508.7925187208997
 | 3 | 794.9146970021006
 | 4 | 69.58431155860002
 | 5 | 105.8492214125001
 | 6 | 423.9844197727988
 | 11 | 112.0936943907002
 | 12 | 16.2171448599
 | 14 | 244.5459363583999
5 | 1 | 1.0255517575
 | 2 | 345.3392714966986
 | 3 | 671.6374778298969
 | 4 | 221.9432494835
 | 5 | 312.1112538584991
 | 6 | 315.3982968774984
 | 10 | 147.0337165456
 | 11 | 107.5024076383005
 | 12 | 75.78667567350018
 | 13 | 0.4264889144
 | 14 | 128.2214218584006
6 | 1 | 9.771415165499995
 | 2 | 115.2808640214002
 | 3 | 248.7765462193997
 | 4 | 873.3140066083996
 | 5 | 317.6136543520981
 | 6 | 158.3851133005002
 | 7 | 2.715774275
 | 10 | 530.1325094236997
 | 11 | 97.74895840620019
 | 12 | 55.84821263640006
 | 13 | 0.5846680734999999
 | 14 | 126.7022621154005
7 | 1 | 0.1476342773
 | 2 | 410.6823872172993
 | 3 | 1124.655084732301
 | 4 | 160.630122263
 | 5 | 250.3322640574994
 | 6 | 143.9364859504002
 | 10 | 8.043156651699999
 | 11 | 123.2556082352003
 | 12 | 36.32065643590003
 | 13 | 0.09
 | 14 | 51.12554431750019
8 | 1 | 5.4028218706
 | 2 | 309.7641390708994
 | 3 | 990.3856241718993
 | 4 | 196.7754525593
 | 5 | 188.1799053742
 | 6 | 231.9048096116001
 | 10 | 4.9163775226
 | 11 | 235.2374672029988
 | 12 | 57.83005411360003
 | 13 | 3.6772667595
 | 14 | 94.07764167440041
9 | 1 | 1.6245975199
 | 2 | 487.6352794853981
 | 3 | 761.1098271875004
 | 4 | 80.84687519709999
 | 5 | 573.5425751427996
 | 6 | 161.2556726743001
 | 10 | 8.8528844829
 | 11 | 97.9461084019003
 | 12 | 51.55156913510012
 | 13 | 51.202703083
 | 14 | 74.87862888630025
Grand Total |  | 21137.32100938327
Spreadsheet: 788233d1658336275-finding-sections-of-a-string-of-variable-length-plate-size-proxy-file-v2
Sheet: Job Items

Section |  |  |  |  |  |  |  |  |  | [NAME] | Quantiy | Total Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plate size | Repetative Plates (Gus, Fin) | Plates (end Plates) | Plates Loose | Total Fin Plates | Total End Plates | Loose fin plates | loose end plates |  |  |  |  | Holes of different sizes/types |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total plate cost
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x100x10 | 4 | 4 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1 | 1
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x10 | 3 | 4 | 0 | 4 |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<    my old code with none of the fluff, yours should give the same value for the same size plate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<   your code
Spreadsheet: 858839d1707365263-flatten-a-random-matrix-example-data-dj
Sheet: Sheet1

 |  |  |  | Red | Blue
a | 1 | 2 | 3
b | 4
c | 5 | 6
a | 1Red
a | 2Red | 2Red
a | 3Red | 3Red
a | 1Blue | 1Blue
a | 2Blue | 2Blue
a | 3Blue | 3Blue
b | 4Red | 4Red
b | 4Blue | 4Blue
c | 5Red | 5Red
c | 6Red | 6Red
c | 5Blue | 5Blue
c | 6Blue | 6Blue
Spreadsheet: 167946d1342164942-excel-2007-changing-denominator-every-nth-cell-copy-of-changing-denominator
Sheet: Sheet1

2007-12-30 00:00:00 | 1588052 |  |  | New sol
2008-01-31 00:00:00 | 158802
2008-02-29 00:00:00 | 146346
2008-03-31 00:00:00 | 155.56
2008-04-30 00:00:00 | 147403
2008-05-30 00:00:00 | 158988
2008-06-30 00:00:00 | 125726
2008-07-31 00:00:00 | 142128
2008-08-29 00:00:00 | 166699
2008-09-30 00:00:00 | 144865
2008-10-31 00:00:00 | 182443
2008-11-28 00:00:00 | 57245
2008-12-31 00:00:00 | 92926
2009-01-30 00:00:00 | 20226
2009-02-28 00:00:00 | 146346
2009-03-30 00:00:00 | 155.56
2009-04-30 00:00:00 | 147403
2009-05-30 00:00:00 | 158988
2009-06-30 00:00:00 | 125726
2009-07-30 00:00:00 | 142128
2009-08-30 00:00:00 | 142128
2009-09-30 00:00:00 | 166699
2009-10-30 00:00:00 | 144865
2009-11-30 00:00:00 | 182443
2009-12-30 00:00:00 | 57245
2010-01-30 00:00:00 | 92926
2010-02-29 | 447
2010-03-30 00:00:00 | 7786
2010-04-30 00:00:00 | 48567
2010-05-30 00:00:00 | 786
2010-06-30 00:00:00 | 78864
2010-07-30 00:00:00 | 4686
2010-08-30 00:00:00 | 486846
2010-09-30 00:00:00 | 4868
2010-10-30 00:00:00 | 7866
2010-11-30 00:00:00 | 486
2010-12-30 00:00:00 | 486
Spreadsheet: 858210d1706950510-looking-for-formula-to-create-number-series-creating-number-series_sample-aligw
Sheet: Here

Numbering | 16 |  |  | Creating number series
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: 4e5b635f-01e9-4d4f-9766-ddc397517d3f
Sheet: Sheet1

Colorado Department of ______________________ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
FY 2010-11 Budget Request
Schedule 5:  Line Item to Statute
(1) Long Bill Group / Division Name, (A) Program
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
(1) Long Bill Group / Division Name, (B) Program
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
(2) Long Bill Group / Division Name, (A) Program
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
(2) Long Bill Group Name, Division Name #2
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
(2) Long Bill Group / Division Name, (B) Program
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
 | Line Item Name | Line Item Description | Statutory Citation
Spreadsheet: 866864d1713789334-scatter-plot-data-labels-duplicating-sample-worksheet
Sheet: data

Year | Month | Income sources | Income Breakdowns | Counts | Income | Target Income | operating profit | Marketing Strategies
2020 | Jan | Licensing | Software [NAME] | 3566 | 5492.76 | 5126.576 | 1098.552 | B2B
2020 | Jan | Licensing | Floating License | 2498 | 9600 | 8960 | 1920 | B2B
2020 | Jan | Renting | Equipments | 1245 | 5492.639999999999 | 5126.464 | 1098.528 | B2B
2020 | Jan | Subscription | Prime | 644 | 6892.2 | 6432.72 | 1378.44 | B2B
2020 | Jan | Usage fees | Renewal | 643 | 7700 | 7840 | 1540 | B2B
2020 | Jan | Advertising | Facebook Page | 78 | 5492.639999999999 | 5126.464 | 1098.528 | B2B
2020 | Jan | Advertising | Google Ad | 76 | 5492.28 | 5126.128 | 1098.456 | B2B
2020 | Jan | Asset sale | Asset sale | 3 | 7260 | 7392 | 1452 | B2B
2021 | Jan | Licensing | Software [NAME] | 6591.168 | 4577.3 | 5126.576 | 915.46 | B2B
2021 | Jan | Licensing | Floating License | 8270.64 | 8800 | 8960 | 1760 | B2B
2021 | Jan | Renting | Equipments | 8470 | 5034.92 | 5126.464 | 1006.984 | B2B
2021 | Jan | Subscription | Prime | 6055.1985 | 6317.85 | 6432.72 | 1263.57 | B2B
2021 | Jan | Usage fees | Renewal | 10368.4 | 7700 | 7840 | 1540 | B2B
2021 | Jan | Advertising | [NAME] | 7986 | 4576.8 | 5126.016000000001 | 915.3600000000001 | B2B
2021 | Jan | Renting | Lands | 5538.533 | 200 | 224 | 40 | B2B
2021 | Jan | Asset sale | Asset sale | 3 | 6600 | 7392 | 1320 | B2B
Spreadsheet: 155041d1336658380-is-there-a-code-that-will-automatically-post-a-row-of-info-based-on-a-qualifying-cell-excel-forum
Sheet: Sheet1

Link | Last Name | First Name | Sport | L-number | Major | Position | Start Date | Hrs. Passed Fall | Hrs. Passed Spring | 6 & 18 Rule | Hrs. Passed Sum/ May | [NAME]. | Quality Pts. | GPA Hours | Total Degree Hours | Hours Needed | PTD | PTD Required | Eligible???
X | doe | [NAME] | FB | 123456 | Gen stud | OL | Fall 09 | 12 | 9 |  |  | 48 | 96 | 42 | 120
X | dough | billy | fb | 123567 | kin | QB | Fall 11 | 15 | 16 |  |  | 12 | 36 | 12 | 122
Spreadsheet: 484634d1476366615-how-to-group-data-sample
Sheet: Data

Period | Weight
1 | 16
2 | 15.9
3 | 16
4 | 16
5 | 16
6 | 16
7 | 15.8
8 | 15.9
9 | 16.1
10 | 15.8
11 | 15.9
12 | 15.8
13 | 15.8
14 | 15.9
15 | 16
16 | 16
17 | 16
18 | 15.9
19 | 15.9
20 | 15.9
21 | 16.2
22 | 16
23 | 15.9
24 | 16.1
25 | 16.1
26 | 16.1
27 | 16.4
28 | 15.8
29 | 15.9
30 | 15.7
31 | 16.1
32 | 16.1
33 | 16.1
34 | 16.1
35 | 16
36 | 16
37 | 15.9
38 | 16.1
39 | 15.7
40 | 16.3
41 | 16.1
42 | 15.9
43 | 15.6
44 | 15.8
45 | 15.8
46 | 16.2
47 | 16.1
48 | 15.9
49 | 16.1
50 | 16.3
51 | 16.1
52 | 16
53 | 16.4
54 | 16.3
55 | 15.8
56 | 16
57 | 16.1
58 | 16.3
59 | 16
60 | 16
Spreadsheet: 191206d1351968923-time-and-a-half-calulated-on-real-time-not-after-x-many-hours-worked-timesheettest2
Sheet: Timesheet

 |  | Strt | End | Total Due | Notes
[NAME] | Band A | 2012-03-14 15:00:00 | 2012-03-14 22:00:00 | 91 | 7hrs @ £13
[NAME] | Band A | 2012-03-14 12:00:00 | 2012-03-14 18:30:00 | 84.5 | 6.5hrs @ £13
[NAME] | Band A | 2012-03-15 12:00:00 | 2012-03-16 03:30:00 | 149.5 | 5.5hrs @ £13 plus 4hrs @ @19.50
[NAME] | Band B | 2012-03-16 06:00:00 | 2012-03-16 11:30:00 |  | 1.5 hrs @ 22.50 plus 4hrs @ £15
[NAME] | Band C | 2012-03-16 06:00:00 | 2012-03-16 11:30:00 |  | 1.5hrs @ 13.35 plus 4hrs @ 8.90
 | 7.30am - 11.30pm | 11.30pm - 7.30am
Band A | 13
Band B | 15
Band C | 8.9
Spreadsheet: 797486d1663920444-return-sum-of-occurances-of-a-list-of-letters-excel-forum-23-sept
Sheet: Sheet1

 |  |  |  |  | formula downwards
 |  |  |  | a | 3
 |  |  |  | a | 3
 |  |  |  | a | 3
 |  |  |  | b | 4
 |  |  |  | b | 4
 |  |  |  | b | 4
 |  |  |  | b | 4
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | k | 5
 |  |  |  | k | 5
 |  |  |  | k | 5
 |  |  |  | k | 5
 |  |  |  | k | 5
Spreadsheet: 89366d1289173580-sumif-not-working-with-today-today-
Sheet: Today(1)

Property value | Commission | Date of purchase
100000 | 7000 | 2010-09-02 00:00:00
200000 | 14000 | 2010-09-04 00:00:00
300000 | 21000 | 2010-10-04 00:00:00
400000 | 28000 | 2010-11-10 00:00:00
[NAME] | Description (Result)
 | Sum of the commissions for property values over 160000 (63,000)
 | Sum of the property values over 160000 (900,000)
 | Sum of the commissions for property values that equal 300000 (21,000)
 | Sum of property values bought after Oct 1st
 | Today() is not working…
 | I have to go around in this way: | Date of purchase | different way
 |  | 2010-09-02 00:00:00
 |  | 2010-09-04 00:00:00
 |  | 2010-10-04 00:00:00
 |  | 2010-11-10 00:00:00
Spreadsheet: 836626d1689540054-aggregate-formula-with-conditions-and-text-test1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL:
 | APROVADO | ORÇAM | DATA | PEÇAS | SERVIÇOS | TOTAL 1 | PARCELAS | - |  | TOTAL 2 | 1 | DATE | OBS | 2 | DATE | OBS
 |  | 300 | 2023-07-05 00:00:00 | 250 |  |  | 1 |  |  |  |  | 2023-07-06 00:00:00 |  |  | -
 |  | 301 | 2023-08-06 00:00:00 | 650 |  |  | 1 |  |  |  |  | - |  |  | -
 |  | 302 | 2023-08-07 00:00:00 | 300 |  |  | 2 |  |  |  |  | 2023-07-05 00:00:00 |  |  | 2023-07-06 00:00:00
 |  | 303 | 2023-08-08 00:00:00 | 410 |  |  | 1 |  |  |  |  | - |  |  | -
 |  | 304 | 2023-08-09 00:00:00 | 78 |  |  | 2 |  |  |  |  | - |  |  | 2023-07-11 00:00:00
Spreadsheet: 72545d1273235102-2-criteria-forecast-average-temp
Sheet: Sheet2

type | arces | manpower | tractor | ppt | Cost
WRT12 | 124351 | 12 | 6 | 18 | 277.8 |  |  |  | type |  |  |  | manpower
WRT12 | 122172 | 12 | 6 | 18 | 277.8 |  |  |  | acres |  |  |  | tractor
WRT12 | 89799 | 8 | 4 | 12 | 185.2 |  |  |  |  |  |  |  | ppt
WRT12 | 108227 | 10 | 3 | 13 | 231.5 |  |  |  |  |  |  |  | cost
EE14 | 114760 | 52 | 12 | 64 | 1203.8
RRV5 | 203091 | 123 | 18 | 141 | 2847.45
RRV5 | 198146 | 118 | 17 | 135 | 2731.7
RRV5 | 209139 | 127 | 20 | 147 | 2940.05
RRV5 | 215586 | 130 | 23 | 153 | 3009.5
EE14 | 206959 | 110 | 17 | 127 | 2546.5
EE14 | 196968 | 103 | 12 | 115 | 2384.45
RRV5 | 210488 | 124 | 22 | 146 | 2870.6
RRV5 | 225336 | 141 | 31 | 172 | 3264.15
RRV5 | 99428 | 84 | 15 | 99 | 1944.6
EE14 | 210083 | 119 | 20 | 139 | 2754.85
EE14 | 210400 | 112 | 17 | 129 | 2592.8
EE14 | 204167 | 102 | 14 | 116 | 2361.3
EE14 | 210835 | 108 | 12 | 120 | 2500.2
RRV5 | 203091 | 110 | 12 | 122 | 2546.5
RRV5 | 44752 | 26 | 3 | 29 | 601.9
RRV5 | 149704 | 95 | 9 | 104 | 2199.25
RRV5 | 155083 | 106 | 11 | 117 | 2453.9
Spreadsheet: 763174d1642017947-combining-different-if-fuctions-based-on-multiple-criterias-in-different-tabs-example-pl-act-bud-ly-and-departments-2-
Sheet: P&L

Month: | December
Department: | Department 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | January | Department 1
 | MTD |  |  | YTD |  |  |  |  |  |  |  |  |  |  | February | Department 2
Category | Actual | Budget | 2020 | Actual | Budget | 2020 |  |  |  |  |  |  |  |  | March | Department 3
Revenue 1 |  |  |  |  |  | ? |  |  |  |  |  |  |  |  | April
Revenue 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
Total revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
Cost 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
Cost 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
Total costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
1. I want a formula that returns values based on Month (B1), Department (B2), Actual/Budget/2020 on MTD and YTD and the categories (A5,A6,A8 and A9). So when I change the month and department, the values in my MTD and YTD table will change according to this.
2. In this example I have created 3 departments in 3 different tabs with unique values in actual, budget and 2020 numbers (the set up is the same in all tabs).
3. In the D1,D2 and [NAME] tabs I have set different categories (column A in each tab).
4. The formulas I have put in this tab (P&L) in cell B5, C5 and D5 is the correct numbers, and somehow how I want it, but the problem is that if i change Month and Department in Cell B1 and B2, the whole table wont update.
5. I also have an issue figuring out how I can get the Year-to-date numbers based on Month and Department.
Spreadsheet: 156122d1337183667-formula-for-cell-count-matrixed-data-and-result-going-to-sheet-2-matrix-data-count_ver2
Sheet: Sheet1

MATRIX
COLOR | BOX A | BOX B | BOX C | BOX D
GREEN | 2
YELLOW | 0
WHITE |  |  |  | 2
WHITE | 2
GREEN |  | 0
GREEN | 3 |  |  | 1
YELLOW | 1 |  | 1
WHITE |  | 0
GREEN | 1 |  | 1
GREEN | 0 |  | 2
YELLOW | 4 |  |  | 3
GREEN |  | 2 | 1
WHITE |  |  |  | 1
GREEN |  | 1
Spreadsheet: 170637d1343336833-separating-cells-containing-values-separated-by-commas-while-keeping-the-rows-columns-samplebook
Sheet: Sheet1

WHAT THE SHEET LOOKS LIKE NOW"
category | performer | country | profession | sex
Baseball | [NAME], [NAME], [NAME], [NAME] | America | athlete | male
music | mariah carey, [NAME], [NAME], lady gaga | America | singer | female
WHAT THE SHEET NEEDS TO LOOKS LIKE:
category | performer | country | profession | sex
baseball | [NAME] | america | athlete | male
baseball | [NAME] | america | athlete | male
baseball | [NAME] | america | athlete | male
baseball | [NAME] | america | athlete | male
music | mariah carey | america | singer | female
music | [NAME] | america | singer | female
music | [NAME] | america | singer | female
music | lady gaga | america | singer | female
Spreadsheet: 385895d1427476616-how-to-sort-two-columns-but-one-has-formulas-ipad-inventory_test
Sheet: SOrt

 | ID | Number of iPads
 | DE0087
 | RI0068
 | MO0047
 | CO0199
 | GA0026
 | IL0277
 | WV0077
 | CT0115
 | LA0035
 | WA0112
 | MA0038
 | LA0300
 | MA0094
 | DC0135
 | MI0042
 | MI0201
 | MO0270
 | FL0088
 | NC0136
 | NJ0291
 | NJ0224
 | NY0052
 | OK0062
 | TX0073
 | IN0032
 | TX0074
 | UT0220
 | TX0164
 | TX0165
 | ME0203
 | MO0157
 | MT0207
 | NY0231
 | KS0092
 | CA0020
 | IL0152
 | AK0001
 | [NAME]
 | OH0059
 | FL0025