tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 491421d1480466696-weighted-percentile-calculation-help-copy-of-weightedpercentilesample
Sheet: Sheet1

Sample Data |  |  |  |  |  |  | Desired Result
Item Number | Qty | Value |  |  |  |  |  |  | 0.05
101 | 1 | 289 |  |  |  |  |  |  | 0.25
102 | 1 | 207 |  |  |  |  |  |  | 0.5
103 | 1 | 255
104 | 2 | 204
105 | 3 | 270
106 | 1 | 277
107 | 5 | 272
108 | 1 | 259
109 | 1 | 257
110 | 1 | 253
111 | 4 | 212
112 | 1 | 234
113 | 4 | 241
114 | 3 | 291
115 | 3 | 282
116 | 4 | 231
117 | 4 | 204
118 | 4 | 277
119 | 2 | 247
120 | 2 | 237
121 | 2 | 265
122 | 1 | 278
123 | 4 | 233
124 | 4 | 202
125 | 3 | 202
126 | 2 | 210
127 | 1 | 288
128 | 2 | 259
129 | 1 | 200
130 | 2 | 268
131 | 4 | 202
132 | 1 | 238
133 | 1 | 295
134 | 3 | 267
135 | 8 | 232
136 | 1 | 227
137 | 4 | 280
138 | 1 | 252
139 | 1 | 242
140 | 1 | 270
141 | 4 | 261
142 | 2 | 209
143 | 1 | 272
144 | 3 | 286
145 | 3 | 294
146 | 4 | 209
147 | 1 | 293
148 | 4 | 217
Spreadsheet: 195817d1353672167-subtracting-one-date-for-another-using-countif-criteria-test-file
Sheet: Sheet1

[NAME] | Programme Title | Production No | Episode Title
2012-11-10 00:00:00 |  | 1/3856/4586#001 | EPISODE 7997
2012-11-19 00:00:00 |  | 1/3856/4586#001 | EPISODE 7997
2012-11-12 00:00:00 |  | 1/2516/8346#001 | EPISODE 7998
2012-11-19 00:00:00 |  | 1/2516/8346#001 | EPISODE 7998
2012-11-19 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999
2012-11-19 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999
2012-11-20 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999
2012-11-20 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999
2012-11-19 00:00:00 |  | 1/8845/4285#001 | EPISODE 8000
2012-11-20 00:00:00 |  | 1/8845/4285#001 | EPISODE 8000
2012-11-20 00:00:00 |  | 1/8845/4285#001 | EPISODE 8000
2012-11-21 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001
2012-11-22 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001
2012-11-22 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001
2012-11-26 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001
2012-11-23 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002
2012-11-26 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002
2012-11-26 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002
2012-11-27 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002
2012-11-23 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003
2012-11-26 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003
2012-11-26 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003
2012-11-27 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003
Spreadsheet: 37042d1234980902-find-doubles-in-number-group-sort-numbers-within-cell-using-morefunc-array
Sheet: Sheet1

9584 | 9520 | 9674 | 9854 | 9070 | 9070 | 5623 | 3120 | 3634 | 3625 | 3030 | 3085 | 4174 | 4129 | 4534 | 4525 | 4039 | 4075 | 8170 | 8189 | 8530 | 8585 | 8639 | 8675
4589 | 0259 | 4679 | 4589 | 0079 | 0079 | 2356 | 0123 | 3346 | 2356 | 0033 | 0358 | 1447 | 1249 | 3445 | 2455 | 0349 | 0457 | 0178 | 1889 | 0358 | 5588 | 3689 | 5678
true | false | false | true | true | true | true | false | false | true | false | true | false | false | false | false | false | false | false | false | true | false | false | false
Spreadsheet: 81077d1281356213-excel-2007-conditional-formating-specific-to-filtered-results-book1
Sheet: Sheet2

1
test1 | test2 | test3 | test4 | test5 | test6 | [NAME] | test8
94 | 61 | 20 | 60 | 100 | 54 | 47 | 41
98 | 26 | 59 | 54 | 83 | 87 | 49 | 56
99 | 69 | 4 | 20 | 84 | 43 | 3 | 90
76 | 38 | 35 | 95 | 86 | 68 | 62 | 34
95 | 30 | 78 | 20 | 55 | 85 | 15 | 94
32 | 64 | 41 | 27 | 26 | 50 | 98 | 14
74 | 28 | 57 | 6 | 72 | 95 | 70 | 65
82 | 41 | 96 | 93 | 6 | 88 | 10 | 72
84 | 41 | 46 | 83 | 83 | 28 | 84 | 94
65 | 44 | 8 | 13 | 68 | 11 | 27 | 65
70 | 10 | 98 | 80 | 2 | 29 | 61 | 12
64 | 91 | 82 | 16 | 41 | 23 | 19 | 86
36 | 73 | 81 | 2 | 31 | 59 | 69 | 61
55 | 70 | 38 | 32 | 3 | 62 | 4 | 94
18 | 54 | 26 | 37 | 62 | 84 | 17 | 81
1 | 63 | 6 | 44 | 13 | 36 | 80 | 27
82 | 30 | 39 | 89 | 24 | 34 | 90 | 20
53 | 79 | 53 | 32 | 47 | 5 | 43 | 52
76 | 62 | 97 | 51 | 91 | 73 | 84 | 80
97 | 21 | 96 | 31 | 82 | 87 | 36 | 20
95 | 52 | 29 | 24 | 66 | 57 | 85 | 29
81 | 6 | 47 | 46 | 32 | 94 | 92 | 83
64 | 36 | 54 | 21 | 53 | 24 | 96 | 74
83 | 89 | 62 | 58 | 63 | 31 | 45 | 53
67 | 64 | 54 | 57 | 72 | 42 | 77 | 44
99 | 71 | 27 | 14 | 51 | 41 | 74 | 27
76 | 71 | 34 | 63 | 46 | 19 | 44 | 42
79 | 52 | 40 | 88 | 40 | 16 | 84 | 51
96 | 65 | 76 | 4 | 43 | 32 | 88 | 63
84 | 13 | 80 | 86 | 6 | 94 | 94 | 81
97 | 44 | 89 | 70 | 14 | 64 | 77 | 71
24 | 87 | 67 | 87 | 28 | 51 | 25 | 3
94 | 7 | 13 | 29 | 55 | 15 | 3 | 82
68 | 70 | 92 | 73 | 45 | 86 | 94 | 16
Spreadsheet: 71950d1272634927-conditional-formatting-relative-reference-icon-sets-relcondformatting
Sheet: Sheet1

1250 |  |  |  |  |  |  |  | I want to apply the conditional formatting (icon set) to the top 15 rows, depending on
1213 |  |  |  |  |  |  |  | what the value of the cell is in row 16 - 30, or 31-45.
1305 |  |  |  |  |  |  |  | So for example
1169
1256 |  |  |  |  |  |  |  | A1 = 1500
1202 |  |  |  |  |  |  |  | A16 = 1300
1565 |  |  |  |  |  |  |  | A31 = 1200
1231
1210 |  |  |  |  |  |  |  | I would want the "green arrow" for A1 because 1500 is more than A16.
1269
1429 |  |  |  |  |  |  |  | A2 = 1300
1526 |  |  |  |  |  |  |  | A17 = 1400
1441 |  |  |  |  |  |  |  | A31 = 1200
1365
1360 |  |  |  |  |  |  |  | I would want the "yellow arrow" for A2 because 1300 is less than A17, but more than A31.
1512
1359 |  |  |  |  |  |  |  | Now, I can do the above via the conditional formatting icon set currently. However, I want to copy
1563 |  |  |  |  |  |  |  | the relative reference down the list and to the next 5 columns.
1466
1539
1238
1597
1385
1356
1196
1463
1495
1571
1114
1120
1483
1283
1352
1561
1221
1193
1100
1569
1418
1201
1171
1304
1254
1379
1184
Spreadsheet: 831019d1685359492-referencing-spilled-array-to-create-spilled-array-test1
Sheet: Sheet1

Data Table |  |  |  | Set Target Name: |  | Yellow section should match Green sections |  |  |  |  |  |  |  |  |  |  |  |  |  | Scores Table
[NAME] | Report Year | Sales |  | [NAME] |  | Spilled arrays. |  |  |  |  |  | Expected Results |  |  |  |  |  |  |  |  | 2001 | 2002
Name1 | 2001 | 0.2601754007917111 |  |  |  | Automatically adjusting number of rows |  |  |  |  |  | Manually set number of Rows |  |  |  |  |  |  |  |  | 3 | 5
Name1 | 2001 | 0.5589487394348224 |  | Year List |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  |  | [NAME] | 2 | 4 | 6
Name1 | 2002 | 0.0339131073571044
Name1 | 2003 | 0.6124610747021023 |  | 2001 |  |  | 1.352177124367662 |  |  | 0 |  | 0.5
Name1 | 2002 | 0.2151687574897279 |  | 2002 |  |  | 0.3461924333011996 |  |  | 0 |  | 0.3
[NAME] | 2000 | 0.0273300349704646
[NAME] | 2001 | 0.5169532134791222 |  |  |  |  | 0.0273300349704646 | 1 | Name1 | 0
[NAME] | 2001 | 0.8352239108885394 |  |  |  | 4 | 1.352177124367662 | 3 | Name1 | 0.8191241402265335
[NAME] | 2002 | 0.3439801552874848 |  |  |  | 6 | 0.3461924333011996 | 5 | Name1 | 0.2490818648468323
[NAME] | 2002 | 0.002212278013714819
Name3 | 2005 | 0.33333
Spreadsheet: 1cb69a83-f302-4cc8-8bd7-4756e9999454
Sheet: Sheet1

EDUCATOR PREPARATION PROGRAM CANDIDATES - ADVANCED CERTIFICATIONS (Revised 11/08/2012)
Advanced Cert Description | Admission Year | Total Candidates
Educational Diagnostician | 2008-2009 | 6
(2011-2012 in Moratorium) | 2009-2010 | 5
 | 2010-2011 | 4
 | 2011-2012 | 7
Principal | 2008-2009 | 47
 | 2009-2010 | 57
 | 2010-2011 | 38
 | 2011-2012 | 52
Reading Specialist | 2008-2009 | 4
(2011-2012 in Moratorium) | 2009-2010 | 1
 | 2010-2011 | 0
 | 2011-2012 | 1
School Counselor | 2008-2009 | 41
 | 2009-2010 | 66
 | 2010-2011 | 69
 | 2011-2012 | 94
Superintendent | 2008-2009 | 41
 | 2009-2010 | 14
 | 2010-2011 | 11
 | 2011-2012 | 11
Data Retrieved from ASU EPP Database
Spreadsheet: 4692c2fc-6888-4ee2-ad27-aac259ee0c82
Sheet: Sheet1

 | MARTA ?? |  |  | Ligia Florim
 | 2:45 - 4:00 PM |  |  | BCA
 | [NAME], [NAME] [PHONE] |  |  | Bron Cleveland Associates, Inc.
 | 500 Plasamour Dr Atlanta |  |  | 16-B Lenox Pointe, NE, Atlanta 30324
 | Depart 4pm to Georgia Power |  |  | [PHONE]
 |  |  |  | 9:45am - 11:30am
 |  |  |  | Mechanical Engr Lab Tech Tour
 |  |  |  | Sterling Skinner [PHONE]
 |  |  |  | [NAME]. MARC&MRDC [NAME] (Bldg #48)
 |  |  |  | Meet at 813 Ferst Dr [NAME]
 |  |  |  | then to MARC Lab #114
 |  |  |  | Lunch 11:30 am- 12:15 pm
 |  |  |  | Woodruff Dining Hall
 |  |  |  | 890 [NAME]
 |  |  |  | tech rec
 |  | gregory abowd
 |  | [EMAIL]
 |  | [PHONE]
 | tech rec | [NAME] | [PHONE]
 | [NAME] [PHONE]
Spreadsheet: 847165d1698226511-calculate-time-differences-between-rows-of-dates-and-time-time_differnces-aligw
Sheet: time_differences

login_date | time diff.
2023-05-30 18:38:00
2023-05-30 18:38:00
2023-05-30 16:39:00
2023-05-30 16:39:00
2023-05-30 14:57:00
2023-05-30 14:57:00
2023-05-30 14:57:00
2023-05-30 11:35:00
2023-05-30 11:35:00
2023-05-30 10:23:00
2023-05-30 10:23:00
2023-05-30 09:58:00
2023-05-30 09:58:00
2023-05-30 09:51:00
2023-05-30 09:51:00
2023-05-30 09:25:00
2023-05-30 09:25:00
2023-05-30 09:09:00
2023-05-30 09:04:00
2023-05-30 09:04:00
2023-05-30 08:54:00
2023-05-30 08:54:00
2023-05-29 18:49:00
Spreadsheet: 68557d1269094746-excel-2007-how-do-i-a-return-value-from-one-column-using-multiple-criteria-on-others-722495-how-do-i-a-return-value
Sheet: Sheet1

Lookup | City1 | City2 | Price | Total
LondonBerlin | London | Berlin | 120 | 1
BerlinLondon | Berlin | London | 50 | 2
London | London |  | 25 | 5
Berlin | Berlin |  | 95 | 4
 | City1 | City2 | Price
 | London |  | 25
 | London | Berlin | 120
 | Berlin | London | 50
 | Berlin |  | 95
Spreadsheet: 100871d1299090804-add-figures-based-on-3-criteria-from-test-data-sheet-bdm-test2
Sheet: Result

Depot
 |  |  |  | ==IF(A10="","",SUMPRODUCT(Test!$C$9:$Z$30,(Test!$A$9:$A$30=$A10)*(Test!$B$9:$B$30="Budget")*ISNUMBER(MATCH(Test!$C$7:$Z$7,{"July","August","September","October","November","December","January","February"},0))))
A |  |  |  | I also want to be able to apply same conditions to work on second formula but this I want to add the sum of (multiply c10*d10 and so on)  to achive the result
B
C
D
Targeted branches
E
F
G
H
I
Other branches
Total
Spreadsheet: 72546d1273235274-remove-duplicates-test-data-for-randy
Sheet: Names-Maint&Support

Dept / Shift | Name | Added | Shift | [NAME] | 1 | 2 | 3 | 4 | 5 | 6
Support/Maintenance Departments:
39-Paint Support | MOORE,KENNETH |  | 3 | 0
42-WFG Power H | HONEYSETT,ROGER | 2010-02-12 00:00:00 | 1 | 0
42-WFG Power H | LOTHAMER,JOHN | 2010-02-12 00:00:00 | 2 | 0
45-Paint Maint. | FORD,[NAME],H | 2010-02-12 00:00:00 | 1 | 0
45-Paint Maint. | SHUMAN,SCOTT,W | 2010-02-12 00:00:00 | 1 | 0
45-Paint Maint. | LINKENHOKER,BRUCE |  | 1 | 0
45-Paint Maint. | MASSEY,SCOTT,P | 2010-03-16 00:00:00 | 2 | 0
45-Paint Maint. | FOWLER,CHRISTOPHER | 2010-03-16 00:00:00 | 2 | 0
WFG01 Salary | FONDAW,[NAME],D | 2010-03-16 00:00:00 | 1 | 0
46-GA Maint. | GREGORY,PAUL | 2010-02-12 00:00:00 | 1 | 0
46-GA Maint. | SHUE,STEPHEN,D | 2010-02-12 00:00:00 | 3 | 0
4502 | FOWLER,CHRISTOPHER,M |  | 2 |  |  |  |  |  |  |  | didn’t find
3902 | WEITZEL,TIMOTHY,A |  | 2
4202 | LOTHAMER,JOHN,LOUIS |  | 2 |  |  |  |  |  |  |  | didn’t find
4601 | GREGORY,PAUL,K |  | 1
4501 | HAZELETT,KIRK,D |  | 1
4501 | LINKENHOKER,BRUCE,A |  | 1 |  |  |  |  |  |  |  | didn’t find
4501 | RICHMOND,SCOTT,W |  | 1
4101 | WILLIAMSON,GREGORY,L |  | 1
4201 | HONEYSETT,ROGER,W |  | 1
 |  |  |  | from 17 - 25 are the test names for the duplicates in the rows 3-16
Spreadsheet: 773652d1647975569-tabulating-data-for-specific-dates-copy
Sheet: 120 Data 3.1-3.21

Unit Number | Location | Operation Type | Unit Type | Timestamp | Result
321LSD05925445 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:00:22 | 1
321LSD05925419 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:01:52 | 1
321LSD05925446 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:03:02 | 1
321LSD05925447 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:04:33 | 1
321LSD05925449 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:08:20 | 1
321LSD05925450 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:11:39 | 1
321LSD05925451 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:12:45 | 1
321LSD05925453 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:14:06 | 1
321LSD05925454 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:16:50 | 0
321LSD05925457 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:19:57 | 1
321LSD05925458 | A120 (Mod 5.2) - Set Spread and Measure Spread / Set and [NAME] | Station worked OK | 68303061AC | 2022-03-01 00:25:46 | 1
Spreadsheet: 798036d1664283070-alternating-formulas-every-two-cells-needs-to-reference-same-column-book3
Sheet: Sheet3

 |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | A
 | B
 | C
 | D
Spreadsheet: 750099d1633264201-highlighting-selected-text-book1_cf
Sheet: Sheet1

A1 |  |  |  |  | Q13
A2
A3
A4
A5
A6
A7
A8
Q9
Q10
Q11
Q12
Q13
Q14
Q15
Q16
Q17
Q18
Q19
Z20
Z21
[NAME]
Z23
Z24
Z25
Z26
Z27
Z28
Spreadsheet: 864525d1711653229-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22-mattg-
Sheet: Game 6

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 266859d1379788340-help-with-sumif-forumula-lakewestassessment
Sheet: Section 2

 | Instructor:  Gates
Student Number | Major | Classification | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10
21 | MNGT | Freshman | a | b | d | b | a | d | c | c | e | a
22 | ECON | Senior | a | c | d | d | a | b | c | c | d | c
23 | MNGT | Sophomore | a | c | a | b | a | b | c | c | d | b
24 | MRKT | Junior | a | c | d | b | a | b | c | c | d | d
25 | MIS | Sophomore | a | c | d | b | a | b | c | c | e | a
26 | FIN | Freshman | a | c | d | d | a | c | c | c | e | a
27 | MIS | Sophomore | a | c | d | b | a | b | c | a | e | a
28 | ACCT | Sophomore | b | c | d | b | c | b | c | c | e | a
29 | MIS | Junior | a | c | e | b | a | b | c | c | e | a
30 | FIN | Sophomore | a | c | c | d | a | b | c | c | e | a
31 | MRKT | Sophomore | a | a | d | b | a | b | c | c | b | a
32 | MNGT | Senior | d | c | d | b | a | b | c | c | e | a
33 | ECON | Freshman | a | c | d | b | a | b | c | d | e | a
34 | FIN | Sophomore | a | a | e | b | a | b | a | c | e | a
35 | ACCT | Sophomore | a | c | c | b | a | b | c | c | e | a
36 | MRKT | Freshman | a | a | d | b | a | b | c | c | e | a
37 | ECON | Junior | a | c | d | b | a | c | c | c | e | a
38 | MNGT | Sophomore | a | c | d | b | a | b | c | c | e | a
39 | MIS | Junior | a | d | e | b | a | b | c | c | e | a
40 | MRKT | Sophomore | a | d | d | b | a | b | c | c | e | a
Spreadsheet: 0bc58b25-ab92-4e63-aa72-d20f6a96e89d
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Cobb | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Holland | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | McLean | [NAME] | [EMAIL] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Hilton | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Wicker-McCree | Ingrid | [EMAIL] | [PHONE] |  | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Yow | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Cone | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Cunningham | Bubba | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Rose | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Record | [NAME] | [EMAIL] | [PHONE] |  | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Sterk | Parick | [EMAIL] | [PHONE] |  | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts |  |  |  |  |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Eaton | [NAME] | [EMAIL] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 767658d1644575445-conditional-formatting-based-on-multiple-criteria-learnexcel
Sheet: Sheet1

Date | Details | Category | Paids | Income | Expenses | Running
2022-01-01 00:00:00 | Opening | Opening | SIB | 795.55
2022-01-01 00:00:00 | Opening | Opening | ENBD | 669.3
2022-01-01 00:00:00 | Opening | Opening | Pay IT | 1000
2022-01-01 00:00:00 | Opening | Opening | NoL | 113
2022-01-01 00:00:00 | Opening | Opening | Cash | 323.5
2022-01-06 00:00:00 | December | Salary | ENBD | 3726
2022-01-09 00:00:00 | Dinner | Food | Cash |  | 10
2022-01-09 00:00:00 | Water | Beverages | Cash |  | 2
2022-01-09 00:00:00 | Breakfast | Food | Cash |  | 4.5
2022-01-09 00:00:00 | RTA | Transport | NoL |  | 7.5
2022-01-09 00:00:00 | Transport | Transport | Cash |  | 250
2022-01-09 00:00:00 | Dinner | Food | Cash |  | 7
2022-01-10 00:00:00 | Office | OfficeRent | Cash | 500
2022-01-10 00:00:00 | Office | LoanReturn | Cash | 969
2022-01-10 00:00:00 | Lunch | Food | ENBD |  | 18.75
2022-01-10 00:00:00 | Dinner | Food | Cash |  | 17
2022-01-11 00:00:00 | Rent | Room | Cash |  | 500
2022-01-11 00:00:00 | Dinner | Food | Cash |  | 10
2022-01-12 00:00:00 | Dinner | Food | Cash |  | 20
2022-01-12 00:00:00 | Bilal | OutLoan | Cash |  | 800
2022-01-13 00:00:00 | Breakfast | Food | Cash |  | 7
2022-01-13 00:00:00 | Dinner | Food | Cash |  | 10
2022-01-14 00:00:00 | Breakfast | Food | Cash |  | 5
2022-01-14 00:00:00 | Lunch | Food | Cash |  | 13
2022-01-14 00:00:00 | Dinner | Food | Cash |  | 5
2022-01-15 00:00:00 | Breakfast | Food | Cash |  | 4
Spreadsheet: 780905d1652863627-excel-2013-negatives-values-treated-as-positive-negative-counted-as-positive
Sheet: Data Sheet

 |  | Finance Code |  |  |  |  |  | Authorised |  |  |  |  | ACTUALS | not spent
 |  | C/DR/0403.01 |  |  |  |  |  | 248721 |  |  |  |  | 19854.48
 |  | C/DR/0403.01.03 |  |  |  |  |  | 860.5 |  |  |  |  | 860.5
 |  | C/DR/0403.01.04 |  |  |  |  |  | 860.5 |  |  |  |  | 860.5
 |  | C/DR/0403.01.05 |  |  |  |  |  | 40000 |  |  |  |  | 40000
 |  | C/DR/0403.01.06 |  |  |  |  |  | 12000 |  |  |  |  | 58160 |  | <<<< | Cell O20 value summed as positive.
 |  | C/DR/0403.01.07 |  |  |  |  |  | 30000 |  |  |  |  | 30000
 |  | C/DR/0403.01.08 |  |  |  |  |  | 6000 |  |  |  |  | 6000
 |  | C/DR/0404.01 |  |  |  |  |  | 278255.29 |  |  |  |  | 128277.76
 |  |  |  |  |  |  |  |  |  |  |  |  | =SUM(O16:O21) >>
 |  |  |  |  |  |  |  |  |  |  |  |  | =SUM(O16:O23) >>
Spreadsheet: 836613d1689527197-helper-free-non-volatile-pre-o365-selecting-visible-cells-for-other-functions-exercise-for-the-little-grey-cells
Sheet: Sheet1

Parameter | Helper
1
2
3
4
5
5
5
5
5
6
6
5
5
5
5
5
6
5
8
9
6
 |  |  | HELPER | OFFSET | BYROW AGGREGATE | Helper free Non-Volatile Pre-O365
 |  |  |  |  |  | ??
 |  |  | 1 |  | 1
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 1 |  | 1
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 1 |  | 1
Spreadsheet: 817100d1675994862-finding-date-in-which-the-average-for-trailing-6-months-is-x-gk-average2
Sheet: Sheet1

Dates | 2024-01-31 00:00:00
Value | 60 | 60 | 70 | 150 | 70 | 65 | 65 | 65 | 77 | 77 | 77 | 62 | 62 | 62 | 80 | 80 | 80
 |  |  |  |  |  | First date where trailing 6 dates have an average of 70 or greater: | ???
 |  |  |  |  |  | Correct Answer: | 2022-11-30 00:00:00 | (Cell: L1)
 |  |  |  |  |  | Value associated with correct answer: | 71 | (Average of G2:L2)
 | * Trailing 6 means the previous 5 months plus the "current" month
 |  |  |  |  |  | 85