tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: US OPEN

 |  | WEEK 11 US OPEN
 |  | Total Earnings |  |  |  | Rankings Through Week 11 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | US OPEN |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: 812491d1673188843-number-of-days-passed-in-given-month-formula-major-al-bsb-
Sheet: Sheet1

Month | Days Passed
2023-01-01 00:00:00
Spreadsheet: 860458d1708538596-summing-values-from-multiple-workbooks-all-in-the-same-format-sample-7
Sheet: Room2

Project: | x
Area | Room 2
Service  Tested | Measurement | Compliance Score
General Lighting | Lux levels | 1
Ventilation | Supply air volumes | 2
Ventilation | Supply air temperature | 1
Ventilation | Humidity at normal operating conditions | 2
Ventilation | Extract air volumes | 2
Ventilation | Air changes per hour | 3
Spreadsheet: 213582d1360585052-return-a-1st-2nd-or-3rd-from-row-of-numbers-society-scoring-system-template
Sheet: north oxford

 |  |  | Am Results |  |  |  |  |  |  |  | Pm Results
 | Name          H/caps |  | Front 9 | Back 9 | Total | Points |  |  | Name         H/caps |  | Front 9 | Back 9 | Total | Points
Leaders in red
 |  |  |  |  | 0
 | Team Ball   J Cooper  P Brown  M Stokes 63 points
 | Handicap change Jan Maciejewski 16 to 12,  A Stokes 20 to 18, D Sumner 11 to 10.
Spreadsheet: 25390d1216681065-vlookup-in-a-range-nominal-dollar-amounts-percentage
Sheet: Sheet1

% of [NAME] expiring in
0 | 365 | 0.3207547169811321
366 | 1460 | 0.1509433962264151
1461 | 3285 | 0.1886792452830189
3286 | 4745 | 0.3396226415094339
sum |  | 1
Instrument | Value | Expiration | Days until expiration | Weight of Portolio
BondA | 1000 | 2008-12-31 00:00:00 | 163 | 0.03773584905660377
BondB | 3500 | 2009-05-07 00:00:00 | 290 | 0.1320754716981132
BondC | 4000 | 2010-05-09 00:00:00 | 657 | 0.1509433962264151
BondD | 9000 | 2020-12-08 00:00:00 | 4523 | 0.3396226415094339
BondE | 5000 | 2014-09-09 00:00:00 | 2241 | 0.1886792452830189
BondF | 1800 | 2008-08-08 00:00:00 | 18 | 0.06792452830188679
BondG | 2200 | 2008-09-16 00:00:00 | 57 | 0.0830188679245283
total | 26500 |  |  | 1
Spreadsheet: 819266d1677359746-conditional-formatting-does-not-highlight-all-cells-in-a-row-conditional-format-issue
Sheet: Database

FZE OUTSTANDING INVOICES AS ON 15.12.2022
Invoice No | PO NUMBER | Dept/Name | Customer | Delivery DATE | Value in EUROS | Value in AED | PAYMENT DUE | REMARKS | sales Person |  | Status
FZE 6685 | CAS-428304-S0Q5H3 | Service | AM Germany | 2022-12-30 00:00:00 | 850 |  |  |  | Tej
FZE 6686 | CAS-428307-H7Z5Q5 | Service | AM Germany | 2022-12-30 00:00:00 | 975 |  |  |  | Tej
FZE 6687 | [NAME] | Service | AM Germany | 2022-12-30 00:00:00 | 975 |  |  |  | Tej |  | pending
FZE 6688 | PO-00030 | Sales | DLV L.L.C | 2022-12-30 00:00:00 | 27759.72 | 118256.4 |  |  | Shamanth
FZE 6689 | P28005982 | Sales | SON | 2022-12-30 00:00:00 | 1956 |  |  |  | Shamanth
FZE 6690 | PO-00000215-3 | Sales | Tenant LLC | 2022-12-30 00:00:00 | 329480.1 |  |  |  | Shamanth
FZE 6691 | IPO22D01748 | Sales | Tenant LLC | 2022-12-30 00:00:00 | 86325 |  |  |  | Shamanth
FZE 6692 | LPO 226003781 | Sales | Blue Oasis | 2022-12-30 00:00:00 | 38279.81 | 163072 |  |  | Shamanth |  | closed
FZE 6693 | LPO 226003782 | Sales | Blue Oasis | 2022-12-30 00:00:00 | 13363.38 | 56928 |  |  | Shamanth
FZE 6694 | CAS-428304-S0Q5H3 | Spares | AM Germany | 2022-12-30 00:00:00 | 261 |  |  |  | Tej
FZE 6695 | PC2100333 | Service | AM Iberia S.L.U | 2022-12-30 00:00:00 | 29296.73 |  |  |  | Rojer
FZE 6696 | 94955404 | Service | AM Benelux | 2022-12-30 00:00:00 | 1875.48 |  |  |  | Rojer
Spreadsheet: 863745d1711129940-index-match-formula-returning-incorrect-values-cashflow-dj
Sheet: Cashflow Master

 |  |  |  |  |  | 2024-02-05 00:00:00 |  |  | 2024-02-12 00:00:00 |  |  | 2024-02-19 00:00:00 |  |  | 2024-02-26 00:00:00 |  |  | 2024-03-04 00:00:00 |  |  | 2024-03-11 00:00:00 |  |  | 2024-03-18 00:00:00 |  |  | 2024-03-25 00:00:00 |  |  | 2024-04-01 00:00:00 |  |  | 2024-04-08 00:00:00 |  |  | 2024-04-15 00:00:00 |  |  | 2024-04-22 00:00:00 |  |  | 2024-04-29 00:00:00 |  |  | 2024-05-06 00:00:00 |  |  | 2024-05-13 00:00:00 |  |  | 2024-05-20 00:00:00 |  |  | 2024-05-27 00:00:00 |  |  | 2024-06-03 00:00:00 |  |  | 2024-06-10 00:00:00 |  |  | 2024-06-17 00:00:00 |  |  | 2024-06-24 00:00:00 |  |  | 2024-07-01 00:00:00 |  |  | 2024-07-08 00:00:00 |  |  | 2024-07-15 00:00:00 |  |  | 2024-07-22 00:00:00 |  |  | 2024-07-29 00:00:00 |  |  | 2024-08-05 00:00:00 |  |  | 2024-08-12 00:00:00 |  |  | 2024-08-19 00:00:00 |  |  | 2024-08-26 00:00:00 |  |  | 2024-09-02 00:00:00 |  |  | 2024-09-09 00:00:00 |  |  | 2024-09-16 00:00:00 |  |  | 2024-09-23 00:00:00 |  |  | 2024-09-30 00:00:00 |  |  | 2024-10-07 00:00:00 |  |  | 2024-10-14 00:00:00 |  |  | 2024-10-21 00:00:00 |  |  | 2024-10-28 00:00:00 |  |  | 2024-11-04 00:00:00 |  |  | 2024-11-11 00:00:00 |  |  | 2024-11-18 00:00:00 |  |  | 2024-11-25 00:00:00
 |  |  | Job Name | Job Number | Event Date | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC
 |  |  | 2404 JTG Live | ST369 | 2024-04-22 00:00:00
 |  |  | 2609 ACT Launch | ST370 | 2026-08-16 00:00:00
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
Spreadsheet: chris_germany__1977__lonestarnom2
Sheet: Apr 17

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  | [NAME]
 |  |  |  |  | 713/853-9781 (Phone)
 |  |  |  |  | 713/345-7374 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: | 2002-04-17 00:00:00 |  | End Date: | 2002-04-17 00:00:00
RECEIPT POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
17-1436-00 | Conger | Conoco System Supply | 10000 | 0.01 | 9900
17-1240-50 | NNG Sprayberry | 108466 | 0 | 0.01 | 0
17-7462-50 | [NAME] | 5268 | 0 | 0.01 | 0
17-0071-00 | [NAME] | at plant | 0 | 0.01 | 0
17-3000-00 | [NAME] |  | 13000 | 0.01 | 12870
17-1201-11 | Koche Cayanosa | REM | 12000 | 0.01 | 11880
DELIVERY POINT INFORMATION:
STATION # | [NAME] | DOWNSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 | 35000 |  | 35000
FYI:  Buy/Sell Information
17-1240-50 | NNG Sprayberry | 107903 | 10000 | 0.01 | 9900 | sold to TXU K501
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-12-31 00:00:00 |  | 1531269.56
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2002-01-27 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262 | -128
500267
Duke Energy Trading and Marketing
Contract  24693
2001-12-31 00:00:00 |  | 275313.72
2002-01-20 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 378562 | 117857 | 186976
2001-12-31 00:00:00 |  | 842376.79
2002-01-27 00:00:00
500241
500391
500392
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 173271 | 176394
2 | 177225 | 188500
3 | 173559 | 172558
4 | 188978 | 195274
5 | 184605 | 181847
6 | 191169 | 192336
7 | 213637 | 217025
8 | 195649 | 195210
9 | 198999 | 197970
10 | 195598 | 203483
11 | 189560 | 188209
12 | 197789 | 206944
13 | 207921 | 206540
14 | 227933 | 227895
15 | 200491 | 215379
16 | 201563 | 211642
17 | 204380 | 221578
18 | 175953 | 170000
19 | 187798 | 175000
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | 0
2000-12-19 00:00:00
Spreadsheet: 798619d1664590389-most-recent-date-based-on-match-excelforum-recentdate
Sheet: Results

ID | data | Name | data2 | Date
154284 |  | ABC123 |  | 2024-01-15 00:00:00
154284 |  | DEF456 |  | 2022-09-09 00:00:00
154284 |  | GHI789 |  | 2021-07-06 00:00:00
154284 |  | MNO345 |  | 2021-06-30 00:00:00
258431 |  | ABC123 |  | 2021-07-06 00:00:00
258431 |  | DEF456 |  | 2021-07-15 00:00:00
258431 |  | MNO345 |  | 2021-07-06 00:00:00
258431 |  | PQR678 |  | 2018-04-20 00:00:00
847782 |  | GHI789 |  | 2017-09-09 00:00:00
847782 |  | JKL012 |  | 2019-07-21 00:00:00
847782 |  | MNO345 |  | 2022-12-11 00:00:00
856695 |  | ABC123 |  | 2022-09-09 00:00:00
856695 |  | JKL012 |  | 2021-11-15 00:00:00
856695 |  | MNO345 |  | 2021-06-21 00:00:00
856695 |  | PQR678 |  | 2015-03-21 00:00:00
856895 |  | DEF456 |  | 2018-07-18 00:00:00
856895 |  | GHI789 |  | 2019-08-05 00:00:00
856895 |  | JKL012 |  | 2020-08-05 00:00:00
856895 |  | PQR678 |  | 2013-12-20 00:00:00
Spreadsheet: 850502d1700842352-lookup-value-across-multiple-worksheet-and-locate-sample_
Sheet: Search

Brand | Item Code | EXPECTED RESULT (HYPERLINK FORMULA)
A |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
B |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
C |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
D |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
E |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
F |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
G |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
H |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
I |  |  | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 1996-97

Table C
Graduate Student Numbers by Faculty and Year Group
1996-97
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Total
Arts and Humanities | 376 | 175 | 54 | 13 | 11
Built Environment | 524 | 71 | 42 | 24 | 20
Clinical Sciences | 290 | 212 | 129 | 61 | 25
Engineering | 309 | 113 | 64 | 26 | 9
Laws | 287 | 35 | 6 | 5 | 4
Life Sciences | 365 | 186 | 183 | 86 | 18
Mathematical and Physical Sciences | 264 | 131 | 93 | 33 | 6
Social and Historical Sciences | 366 | 123 | 70 | 22 | 14
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 40765d1239159204-get-first-higher-number-example
Sheet: Folha1

 |  |  |  |  | Φ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  | 6 | 0.28 | 0.57 | 0.85 | 1.13 | 1.41 | 1.7 | 1.98 | 2.26 | 2.54 | 2.83 | 3.11 | 3.39
 |  |  |  |  | 8 | 5 | 1.01 | 151 | 2.01 | 2.51 | 3.02 | 3.52 | 4.02 | 4.52 | 5.03 | 5.53 | 6.03
 |  |  |  |  | 10 | 0.79 | 1.57 | 2.36 | 3.14 | 3.93 | 4.71 | 5.5 | 6.28 | 7.07 | 7.85 | 8.64 | 9.42
 |  |  |  |  | 12 | 1.13 | 2.26 | 3.39 | 4.52 | 5.65 | 6.79 | 7.92 | 9.05 | 10.18 | 11.31 | 12.44 | 13.57
 |  |  |  |  | 16 | 2.01 | 4.02 | 6.03 | 8.04 | 10.05 | 12.06 | 14.07 | 16.08 | 18.1 | 20.11 | 22.12 | 24.13
 |  |  |  |  | 20 | 3.14 | 6.28 | 9.42 | 12.57 | 15.71 | 18.85 | 21.99 | 25.13 | 28.27 | 31.42 | 34.56 | 37.7
 |  |  |  |  | 25 | 4.91 | 9.82 | 14.73 | 19.63 | 24.54 | 29.45 | 34.36 | 39.27 | 44.18 | 49.09 | 54 | 58.9
 |  |  |  |  | 32 | 8.04 | 16.08 | 24.13 | 32.17 | 40.21 | 48.25 | 56.3 | 64.34 | 72.38 | 80.42 | 88.47 | 96.51
 |  |  |  |  |  |  | Specified number: |  | 17.85
 |  |  |  |  |  |  | Lowest number higher than specified:
Spreadsheet: 160646d1339156995-how-do-you-return-multiple-rows-and-columns-book1
Sheet: Sheet2

Input: | [NAME] | 4
Name: | Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 | Col8 | Col9 | Col10
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME] | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
[NAME] | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
[NAME] | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Spreadsheet: 850864d1701183070-shading-weekend-cloumns-meeting-rooms-aligw
Sheet: February 2024

 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-10 00:00:00 | 2024-02-11 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-24 00:00:00 | 2024-02-25 00:00:00 | 2024-02-26 00:00:00 | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00
 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-10 00:00:00 | 2024-02-11 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-24 00:00:00 | 2024-02-25 00:00:00 | 2024-02-26 00:00:00 | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00
BIG BOARDROOM: 0800-0900
BIG BOARDROOM: 0900-1000
BIG BOARDROOM: 1000-1100
BIG BOARDROOM: 1100-1200
BIG BOARDROOM: 1200-1300
BIG BOARDROOM: 1300-1400
BIG BOARDROOM: 1400-1500
BIG BOARDROOM: 1500-1600
BIG BOARDROOM: 1600-1700
SMALL BOARDROOM: 0800-0900
SMALL BOARDROOM: 0900-1000
SMALL BOARDROOM: 1000-1100
SMALL BOARDROOM: 1100-1200
SMALL BOARDROOM: 1200-1300
SMALL BOARDROOM: 1300-1400
SMALL BOARDROOM: 1400-1500
SMALL BOARDROOM: 1500-1600
SMALL BOARDROOM: 1600-1700
Spreadsheet: 116442d1311842608-excel-2007-lookup-if-then-multiple-rows-duplicate-data-l-and-d-account-template
Sheet: Estate Detail

DETAILS |  |  | Liabilities | Enter these figures as a negative number
Name | [NAME] |  | L1 | 40 Rathfelder Avenue Constantia Cape Town, Erf 20199 [NAME] | -900000
ID Number | 6405015109080 |  | L2
Estate number | 1378/2010 |  | L3
Place of Death | Cape Town |  | [NAME]
How Married | MARRIED ANC accrual |  | L5
Wife's Name |  |  | L6
Wife ID Number | 1 |  | L7
Address of Deceased | 40 Rathfelder Avenue Constantia Cape Town |  | L8
Date of Death | 20th June 2010 |  | L9
 |  |  | L10
[NAME] |  |  | L11
IP1 | 40 Rathfelder Avenue Constantia Cape Town, Erf 20199 [NAME] | 1000000 | L12
IP2 | Wish I had property, Erf 567 | 500000 | [NAME]
IP3 |  |  | [NAME]
IP4 |  |  | L15
IP5 |  |  | L16
IP6 |  |  | L17
IP7 |  |  | L18
IP8 |  |  | L19
IP9 |  |  | L20
IP10 |  |  | [NAME]
Moveable Property |  |  | Claims in Favour
MP1 | Stanlib Unit trust # 234567890 | 30000 | C1 | Brett Redelinghuys Loan | 5000
MP2 | Liberty Life shares | 6000 | C2 | Couzin Loan owed | -2000
MP3 |  |  | [NAME]
MP4 |  |  | C4
MP5 |  |  | C5
MP6 |  |  | C6
MP7 |  |  | C7
MP8 |  |  | C8
MP9 |  |  | C9
MP10 |  |  | C10
 |  |  | Heading
Spreadsheet: 222124d1363771431-format-rows-based-on-predecessor-value-in-a-column-pivot-solution_20-03-13-
Sheet: Sheet1

BEFOR
Customer | PartNo | Qty
AA | 6547 | 45
AA | 32657 | 8
AA | 3474 | 64
BB | 3441 | 21
BB | 65754 | 15
CC | 21574 | 36
DD | 2154 | 98
DD | 35454 | 65
DD | 544 | 32
DD | 65441 | 654
DD | 6544 | 455
EE | 311 | 259
FF | 364 | 54
FF | 3465 | 21
GG | 3216 | 46
HH | 13246 | 65
HH | 3215 | 987
AFTER
Customer | PartNo | Qty |  | Sum of Qty
AA | 6547 | 45 |  | Customer | PartNo | Total
 | 32657 | 8 |  | AA | 3474 | 64
 | 3474 | 64 |  |  | 6547 | 45
BB | 3441 | 21 |  |  | 32657 | 8
 | 65754 | 15 |  | AA Total |  | 117
CC | 21574 | 36 |  | BB | 3441 | 21
DD | 2154 | 98 |  |  | 65754 | 15
 | 35454 | 65 |  | BB Total |  | 36
 | 544 | 32 |  | CC | 21574 | 36
 | 65441 | 654 |  | CC Total |  | 36
 | 6544 | 455 |  | DD | 544 | 32
EE | 311 | 259 |  |  | 2154 | 98
FF | 364 | 54 |  |  | 6544 | 455
 | 3465 | 21 |  |  | 35454 | 65
GG | 3216 | 46 |  |  | 65441 | 654
HH | 13246 | 65 |  | DD Total |  | 1304
 | 3215 | 987 |  | EE | 311 | 259
 |  |  |  | EE Total |  | 259
 |  |  |  | FF | 364 | 54
 |  |  |  |  | 3465 | 21
 |  |  |  | FF Total |  | 75
 |  |  |  | GG | 3216 | 46
 |  |  |  | GG Total |  | 46
 |  |  |  | HH | 3215 | 987
 |  |  |  |  | 13246 | 65
 |  |  |  | HH Total |  | 1052
 |  |  |  | Grand Total |  | 2925
Spreadsheet: 59003d1259330156-sumproduct-not-all-employees-are-working-sumproduct
Sheet: Formulae1

 |  | Start | End(and incl) | Value
 |  | 2010-01-01 00:00:00 | 2011-09-01 00:00:00 | 10
 |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 0 | 0 | 0
 |  | if c8 is in the range of c6 and D6 then return e6 otherwise 0
 |  | Salary: | First looks up cost center in summary table to determine what the % holiday allowance is in that cost center.(these are the listed exceptions)
 |  |  | If not in the summary table above then use standard formuale to look at the monthly calculated salary and then deduct the holiday amount calculated separately in the holiday line.
 |  | [NAME] 1
 |  | Cost center | Start | End(and incl) | Annual value
 |  | xx | 2010-01-01 00:00:00 | 2011-09-01 00:00:00 | 20000
 |  | xx | 2010-01-01 00:00:00 | 2010-08-01 00:00:00 | 25000
 |  | xx | 2010-12-01 00:00:00 | 2011-09-01 00:00:00 | 25000
 |  | Calculation Budget template
 |  | xx | Cost center
 |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
 |  | 22083.33333333333 | 22083.33333333333 | 22083.33333333333 | 22083.33333333333 | 22083.33333333333 | 22083.33333333333 | 22083.33333333333 | 22083.33333333333 | 1666.666666666667 | 1666.666666666667 | 1666.666666666667 | 22083.33333333333 | 22083.33333333333 | 22083.33333333333 | etc
 |  | I have a salary database and a budget template which needs to calculate salaries by month if the employee is working in that month
 |  | The budget template is by cost center (eg xx, aa in example)
 |  | The formulae needs to do a sum of the monthly salaries from the database. This is the easy part, I can simply do a "sumif" and divide by 12.
 |  | The problem is that I also need to only return a value by line item if the employee is working in that month.eg if employee start end date is in the current month then return the annual salary divided by 12
 |  | In example above for cost center XX the salary would be flat till Sep 10 when one employee leaves, and it would change again when a new employee joins in Dec
Spreadsheet: 859974d1708198940-aggregate-formula-gets-wrong-data-formulas-do-not-work
Sheet: Sheet1

2022-07-15 00:00:00 | p | 5 | 8.55
2022-08-16 00:00:00 | d | 4.32 | 8.41
2022-09-12 00:00:00 | d | 4.12 | 8.49
2022-10-15 00:00:00 | d | 3.98 | 8.66
2022-11-23 00:00:00 | d | 3.75 | 8.87 |  |  | 33.26 |  |  | Cell I5 should be 33.26 but comes up blank
2022-12-15 00:00:00 | p | 5 | 8.8
2023-07-24 00:00:00 | p | 6 | 8.46
2023-07-31 00:00:00 | d | 3.167 | 8.6655
2023-08-01 00:00:00 | p | 30 | 8.64
2023-09-01 00:00:00 | d | 3.708 | 8.497
2023-10-05 00:00:00 | d | 4.025 | 7.9056
2023-10-17 00:00:00 | p | 28 | 7.55
2023-11-01 00:00:00 | d |  |  |  |  | 20.15
2023-11-07 00:00:00 | d | 4.281 | 7.5286
2023-12-05 00:00:00 | d | 4.345 | 8.1772 |  |  |  |  |  | Cell I9 should have 35.53 but comes up blank
2023-12-29 00:00:00 | p | 18 | 8.335
2024-01-08 00:00:00 | d | 4.258 | 8.4476
2024-02-08 00:00:00 | d | 4.389 | 8.56 |  |  |  |  |  | Cell I18 should have 37.57 but comes up blank
2024-02-12 00:00:00 | p | 5 | 8.39