tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274670d1383175688-time-vs-rate-value-booking-sheet-template
Sheet: Rate Card

 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
06:00 | 5.6 | 40.6 | 40.6 | 40.6 | 40.6 | 40.6 | 5.6
06:30 | 5.6 | 40.6 | 40.6 | 40.6 | 40.6 | 40.6 | 5.6
07:00 | 30.8 | 40.6 | 40.6 | 40.6 | 40.6 | 40.6 | 34.3
07:30 | 30.8 | 40.6 | 40.6 | 40.6 | 40.6 | 40.6 | 34.3
08:00 | 30.8 | 40.6 | 40.6 | 40.6 | 40.6 | 40.6 | 34.3
08:30 | 30.8 | 40.6 | 40.6 | 40.6 | 40.6 | 40.6 | 34.3
09:00 | 30.8 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 16.8
09:30 | 30.8 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 16.8
10:00 | 30.8 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 16.8
10:30 | 30.8 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 16.8
11:00 | 30.8 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 16.8
11:30 | 30.8 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8
12:00 | 30.8 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 25.9
12:30 | 30.8 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 25.9
13:00 | 30.8 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 25.9
13:30 | 30.8 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 25.9
14:00 | 30.8 | 15.4 | 15.4 | 15.4 | 15.4 | 15.4 | 25.9
14:30 | 30.8 | 15.4 | 15.4 | 15.4 | 15.4 | 15.4 | 25.9
15:00 | 30.8 | 15.4 | 15.4 | 15.4 | 15.4 | 15.4 | 25.9
15:30 | 30.8 | 0 | 0 | 0 | 0 | 0 | 25.9
16:00 | 30.8 | 17.5 | 17.5 | 17.5 | 17.5 | 17.5 | 25.9
16:30 | 30.8 | 19.6 | 19.6 | 19.6 | 19.6 | 19.6 | 25.9
17:00 | 60.2 | 46.2 | 46.2 | 46.2 | 46.2 | 46.2 | 28
17:30 | 60.2 | 104.3 | 104.3 | 104.3 | 104.3 | 104.3 | 72.8
18:00 | 215.6 | 189 | 189 | 189 | 189 | 189 | 215.6
18:30 | 193.9 | 189 | 189 | 189 | 189 | 189 | 101.5
19:00 | 193.9 | 148.4 | 148.4 | 148.4 | 148.4 | 148.4 | 101.5
19:30 | 193.9 | 186.2 | 215.6 | 193.9 | 152.6 | 215.6 | 101.5
20:00 | 193.9 | 186.2 | 215.6 | 193.9 | 152.6 | 215.6 | 101.5
20:30 | 199.5 | 258.3 | 280 | 193.9 | 162.4 | 215.6 | 105.7
21:00 | 199.5 | 258.3 | 280 | 193.9 | 162.4 | 129.5 | 105.7
21:30 | 153.3 | 143.5 | 151.2 | 114.8 | 123.9 | 129.5 | 105.7
22:00 | 153.3 | 143.5 | 151.2 | 114.8 | 123.9 | 129.5 | 105.7
22:30 | 46.9 | 52.5 | 52.5 | 52.5 | 52.5 | 52.5 | 46.9
23:00 | 46.9 | 52.5 | 52.5 | 52.5 | 52.5 | 52.5 | 46.9
23:30 | 46.9 | 21 | 21 | 21 | 21 | 21 | 46.9
24:00 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
24:30 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
25:00 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
25:30 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
26:00 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
26:30 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
27:00 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
27:30 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
28:00 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
28:30 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
29:00 | 11.2 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 11.2
29:30 | 11.2 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 | 11.2
Spreadsheet: 726575d1617299681-sumifs-issue-template
Sheet: MAY

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-05-01 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 15
Spreadsheet: 214667d1361042106-macro-for-merging-multiple-work-books-sample
Sheet: S2

Date | Name | Start time | End time | Total time
2012-01-02 00:00:00 | III | 22:51:46 | 22:51:49 | 00:00:03
2012-01-03 00:00:00 | JJJ | 22:52:05 | 22:52:01 | 04:11:55
2012-01-04 00:00:00 | KKK | 23:12:41 | 19:23:18 | 00:22:58
2012-01-05 00:00:00 | LLL | 19:23:18 | 19:32:48 | 00:09:30
2012-01-06 00:00:00 | MMM | 10:45:29 | 10:56:53 | 00:11:24
2012-01-07 00:00:00 | NNN | 11:58:59 | 12:07:00 | 00:08:01
2012-01-08 00:00:00 | OOO | 12:25:33 | 12:36:34 | 00:11:01
2012-01-09 00:00:00 | PPP | 13:11:05 | 13:20:45 | 00:09:40
Spreadsheet: 814187d1674219435-need-help-returning-a-value-from-a-tab-name-but-for-cell-to-look-for-that-tab-name-example-for-forum
Sheet: Oct-22

2022-10-01 00:00:00
 | Items
Branch 1 | 21
Branch 2 | 22
Branch 3 | 23
Branch 4 | 24
Branch 5 | 25
Branch 6 | 26
Branch 7 | 27
Branch 8 | 28
Branch 9 | 29
Branch 10 | 30
Branch 11 | 31
Branch 12 | 32
Branch 13 | 33
Branch 14 | 34
Branch 15 | 35
Branch 16 | 36
Spreadsheet: 744107d1628958465-strokes-per-hole-pine-hollow-sc
Sheet: Sheet1

Course Name: |  | PINE HOLLOW GOLF CLUB
Hole |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Out
Gold  68.0/125 |  | 340 | 464 | 169 | 332 | 131 | 242 | 359 | 382 | 348 | 2767 | No Stroke |  | o
Red  69.0/122 |  | 305 | 394 | 137 | 310 | 114 | 222 | 332 | 322 | 317 | 2453 | 1 Stroke
Hcp. |  | 13 | 9 | 11 | 7 | 15 | 17 | 3 | 1 | 5 |  | 2 Strokes |  | .
Par |  | 4 | 5 | 3 | 4 | 3 | 4 | 4 | 5 | 4
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Birdey |  | 4
5 | 5 |  |  |  |  |  |  |  |  |  |  | Par |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 1
18 | 18 |  |  |  |  |  |  |  |  |  |  | Dbl. [NAME] |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Trip. [NAME] |  | -1
20 | 20
[NAME]
29 | 29
TEAM TOTAL
TEAM POINTS
Hole |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | In | Total | Hcp. | Net
Gold |  | 339 | 364 | 276 | 150 | 331 | 165 | 445 | 433 | 346 | 2849 | 5616
Red |  | 294 | 337 | 268 | 125 | 287 | 136 | 399 | 399 | 250 | 2495 | 4948
Hcp. |  | 12 | 8 | 18 | 16 | 2 | 10 | 14 | 6 | 4
Par |  | 4 | 4 | 4 | 3 | 4 | 3 | 5 | 5 | 4
[NAME]
5 |  |  |  |  |  |  |  |  |  |  |  |  | 15
[NAME]
18 |  |  |  |  |  |  |  |  |  |  |  |  | 20
[NAME]
20 |  |  |  |  |  |  |  |  |  |  |  |  | 23
[NAME]
29 |  |  |  |  |  |  |  |  |  |  |  |  | 28
TEAM TOTAL
TEAM POINTS
Spreadsheet: 873493d1719994928-logistics-time-on-the-road-per-day-logistics-revised-2-
Sheet: Sheet1 (2)

 | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Hour
 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 24 | 24 | 8 | 24 | 16 | 24 | 24 | 24 | 24 | 8 |  |  | not same as expected result
 | 1 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 16 |  | 8 |  |  |  |  | 16
 | 2 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | inconsistent expected result
 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 2 | 17 | 24 |  | 24 | 23 | 24 | 24 | 7 | 24 | 15
 | 4 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 9 |  | 1 |  |  | 17 |  | 9
 | 5 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0
 | 6 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 3 | 10 | 24 | 22 | 24 | 24 | 6 | 24 | 14 | 24 | 22
 | 7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 2 |  |  | 18 |  | 10 |  | 2
 | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | 9 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 4 | 3 | 24 | 24 | 5 | 24 | 13 | 24 | 21 | 24 | 24
 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 19 |  | 11 |  | 3
 | 11 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0
 | 12 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 20 | 24 | 12 | 24 | 20 | 24 | 24 | 4 | 24
 | 13 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 12 |  | 4 |  |  | 20
 | 14 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0
 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |  | 6 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 13 | 24 | 19 | 24 | 24 | 3 | 24 | 11 | 24
 | 16 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  | 6 |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | 5 |  |  | 21 |  | 13
 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0
 | 18 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 |  | 7 |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 6 | 24 | 24 | 24 | 24 | 10 | 24 | 18 | 24
 | 19 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 |  | 7 |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 14 |  | 6
 | 20 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0
 | 21 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 23 | 24 | 24 | 24 | 17 | 24 | 24 | 1
 | 22 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 7 |  |  | 23
 | 23 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 13 - Table 2

LAS CSD&Nanc |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 9037.154000000002 | 0 | 0 | 6.141999999996187 | 9043.295999999998 | 0.0006796387446752483 | 0.0006796387446751694
Net revenue | 698.535 | 0 | -114.2241693118591 | 205.5921693118591 | 789.903 | 0.130799458867487 | 0.2943190667781272
Net revenue/hl | 77.29590532594662 | 0 | -12.63081174295955 | 22.68171006028638 | 87.34680364327345 | 0.1300314457142784 | 0.2934399948437191
[NAME] | -436.9899999999999 | 0 | 71.33249309720856 | -126.0474530972086 | -491.70496 | 0.1252087233117465 | 0.2884447083393411
[NAME]/hl | -48.35482498140452 | 0 | 7.887886573347656 | -13.90537894172358 | -54.37231734978044 | 0.1244445072583764 | 0.2875696261349528
Gross profit | 261.5450000000001 | 0 | -42.89167621465054 | 79.54471621465045 | 298.19804 | 0.1401404729587641 | 0.3041339586482266
Gross margin | 0.3744193204349103 | 0 | 0 | 0 | 0.3775122261847341 | 30 | 30
SG&A excl. deprec.&amort. | -156.807 | 0 | 23.87162992015897 | -37.56962992015897 | -170.505 | 0.08735579406531602 | 0.2395915355829713
SG&A deprec.&amort. | -22.903 | 0 | 3.342088838490163 | -2.69508883849016 | -22.256 | -0.02824957429157759 | 0.1176740531148828
SG&A total | -179.71 | 0 | 27.21371875864915 | -40.26471875864913 | -192.761 | 0.0726225585665794 | 0.2240538576520457
Other operating income/expenses | -0.6599999999999997 | 0 | -1.111980327581732 | 9.63718918382089 | 7.865208856239159 | nm | nm
Normalized EBIT | 81.17500000000007 | 0 | -16.78993778358313 | 48.91718663982221 | 113.3022488562392 | 0.3957776268092286 | 0.6026139407431126
Normalized EBIT margin | 0.1162074913927005 | 0 | 0 | 0 | 0.1434381802021757 | 270 | 280
Normalized EBITDA | 127.661 | 0 | -23.2559602846718 | 52.12920914091095 | 156.5342488562392 | 0.2261712571281687 | 0.408340911796954
Normalized EBITDA margin | 0.1827553379572964 | 0 | 0 | 0 | 0.1981689509423805 | 150 | 160
Spreadsheet: 677518d1589382333-match-numbers-and-add-an-existing-value-from-a-third-column-example
Sheet: 1

Patientnumber | PID | Patientnumber2 | PID2
1 | 1234 | 1 | 1234
1 | 1234 | 0 | 2
2 | 2345 | 6 | 6789
3 | 3456 | 4 | 4567
3 | 3456 | 3 | 3456
4 | 4567 | 5 | 5678
4 | 4567 | 4 | 4567
5 | 5678 | 5 | 5678
6 | 6789 | 6 | 6789
Spreadsheet: 736714d1623831215-transpose-formula-error-transpose
Sheet: Sheet1

 | CODE | A | B | C | D | E |  |  |  | NUMBER
 | NUMBER | 50 | 65 | 12 | 145 | 65 |  |  | A | 50
 |  |  |  |  |  |  |  |  | B | 65
 |  |  |  |  |  |  |  |  | C | 12
 |  |  |  |  |  |  |  |  | D | 145
 |  |  |  |  |  |  |  |  | E | 65
 |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A
Spreadsheet: 180170d1347500305-create-an-automatically-sorting-ranking-list-rank-result
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Label | Score1 | Score2 | helper |  | Output
 |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 20
 |  |  |  |  |  |  |  |  |  | [NAME] | 24 | 35
 |  |  |  |  |  |  |  |  |  | Lina | 10 | 35
 |  |  |  |  |  |  |  |  |  | [NAME] | 17.5 | 27.5
 |  |  |  |  |  |  |  |  |  | [NAME] | 45 | 55
 |  |  |  |  |  |  |  |  |  | Holly | 6 | 15
 |  |  |  |  |  |  |  |  |  | [NAME] | 20 | 45
 |  |  |  |  |  |  |  |  |  | [NAME] | 17.5 | 39
Spreadsheet: 66624d1267245898-automatic-calculation-from-last-figure-in-a-table-with-total-nos-of-blank-cells-book1
Sheet: 2009-2010

Month | Amount
2009-04-01 00:00:00 | 14631
2009-05-01 00:00:00 | 14943
2009-06-01 00:00:00 | 14556
2009-07-01 00:00:00 | 14790
2009-08-01 00:00:00 | 14674
2009-09-01 00:00:00 | 0
2009-10-01 00:00:00 | 0
2009-11-01 00:00:00 | 0
2009-12-01 00:00:00 | 0
2010-01-01 00:00:00 | 0
2010-02-01 00:00:00 | 0
2010-03-01 00:00:00 | 0
Total
Required |  | A6*7 | (14674*7)
Grand Total
Spreadsheet: 06c7ea65-b56f-44c9-a416-1aea0d9252f7
Sheet: Figure 6

Figure 6:  State Scorecard
 | Findings | Delaware |  | Use the following options only
Federal Funding | Charters have access to federal funds according to state statutes (Yes = black, No = white)* | Y |  | Y
 | Percentage of federal revenue equals percentage of total enrollment for charter schools (<, >, or =) | > |  | P
State Funding | Charters have access to state funds according to state statutes (Yes = black, No = white) | Y |  | N
 | Percentage of state revenue equals percentage of total enrollment for charter schools (<, >, or =) | >
Local Funding | Charters have access to local funds according to state statutes (Yes = black, No = white) | Y
 | Percentage of local revenue equals percentage of total enrollment for charter schools (<, >, or =) | >
Facilities Funding | Charters have access to facilities funds according to state statutes (Yes = black, No = white) | N |  | http://www.doe.k12.de.us/infosuites/schools/charterschools/Reports/charter_DECharterSchoolFAQ-Apr06.pdf
 | Percentage of facilities revenue equals percentage of total enrollment for charter schools (<, >, or =) | N
Data Availability | State provides detailed, public data on federal, state, local and other revenues for district schools (Yes = black, Partial = grey, No = white) | Y
 | State provides detailed, public data on federal, state, local and other revenues for charter schools (Yes = black, Partial = grey, No = white) | Y
Funding Formula | Charters are treated as LEAs for funding purposes (Yes = black, Partial = grey, No = white) | Y
 | State funds student (black) or the LEA (grey) | S |  | S | L |  | Use these options for the query to the left only (B18)
 | State funding formula is fair and equitable (Yes = black, No = white | N
* For this finding, No could indicate that the statue is silent or that it denies access.
Spreadsheet: 798393d1664460457-pull-text-from-one-worksheet-to-another-filling-in-the-column-without-skipping-rows-tournament-tracker
Sheet: Bowlers

Name | USBC Number | Bowling with Team | Avg | HCP | GM1 SCR | GM1 HCP | GM2 SCR | GM2 HCP | GM3 SCR | GM3 HCP | TOTAL SCR | TOTAL W/HANDICAP |  | Rank | TOP SCR | BOWLER |  | Rank | TOP HCP | BOWLER |  |  |  |  |  | In excel 365
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  |  |  |  | Katrina Battle
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | 3 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  | 15
Spreadsheet: 150904d1334725315-sum-every-2nd-column-up-to-specified-column-example
Sheet: Sheet1

Month: | 2012-04-01 00:00:00
YTD |  | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00
Data | % | Data | % | Data | % | Data | % | Data | % | Data | %
 |  | 10 | 0.5 | 20 | 100 | 20 | 1 | 10 | 0.5 | 10 | 0.5
Spreadsheet: 172978d1344398701-lookup-most-current-date-within-a-range-copy-of-excel-20book-205-1-
Sheet: Sheet1

Name | Date |  | Name 2 | Date 2
[NAME] |  |  | [NAME] | 2012-05-14 00:00:00
Nicole |  |  | Nicole | 2012-04-30 00:00:00
Holly |  |  | Holly | 2012-01-17 00:00:00
Ricky |  |  | Holly | 2012-04-03 00:00:00
May |  |  | Holly | 2012-06-19 00:00:00
Winston |  |  | Ricky | 2011-10-07 00:00:00
 |  |  | Ricky | 2011-09-22 00:00:00
 |  |  | Ricky | 2012-03-15 00:00:00
 |  |  | Ricky | 2012-05-04 00:00:00
 |  |  | [NAME] | 2011-12-29 00:00:00
 |  |  | Ricky | 2011-10-11 00:00:00
 |  |  | Ricky | 2012-04-03 00:00:00
 |  |  | Winston | 2012-06-19 00:00:00
 |  |  | Winston | 2011-10-07 00:00:00
 |  |  | [NAME] | 2011-09-22 00:00:00
Spreadsheet: 738916d1625335688-need-a-single-formulas-to-calculate-net-worth-overall-gain-and-couple-of-more-parameters-port
Sheet: port

 |  |  |  |  | Current Qty
 |  |  | Invested | 12 | Overall Gain |  |  |  | [NAME]
 |  |  | Prev Close | 7.45 | Today Gain
 |  |  | LTP | 7.8 | Networth
 |  |  | Rate | P / L % | Type | Qty | Cost | Bal_Qty | Portfolio_Bal
 | 2021-06-28 00:00:00 |  | 10 |  |  | 5
 | 2021-06-29 00:00:00 |  | 17 |  |  | -3
 | 2021-06-30 00:00:00 |  | 3 |  |  | 17
 | 2021-07-01 00:00:00 |  | 7.8 |  |  | -15
Spreadsheet: 829440d1684231264-add-days-to-a-date-but-display-following-monday-if-result-falls-on-a-weekend-dayof-week-not-weekend-etaf
Sheet: Sheet1

date | plus 5 | day of week | date plus 5 not weekend | day of week
2023-05-13 00:00:00
2023-05-14 00:00:00
2023-05-15 00:00:00
2023-05-16 00:00:00
2023-05-17 00:00:00
2023-05-18 00:00:00
2023-05-19 00:00:00
2023-05-20 00:00:00
2023-05-21 00:00:00
2023-05-22 00:00:00
2023-05-23 00:00:00
2023-05-24 00:00:00
2023-05-25 00:00:00
2023-05-26 00:00:00
2023-05-27 00:00:00
2023-05-28 00:00:00
2023-05-29 00:00:00
2023-05-30 00:00:00
2023-05-31 00:00:00
2023-06-01 00:00:00
2023-06-02 00:00:00
2023-06-03 00:00:00
2023-06-04 00:00:00
2023-06-05 00:00:00
2023-06-06 00:00:00
2023-06-07 00:00:00
Spreadsheet: 89501d1289295307-best-way-to-integrate-excel-with-access-importsdept01
Sheet: Data01

 | Inv.No | Inv.Date | Supp.Name | [NAME] | Ship.Type | Ship.Mod | Ship.POD | Ship.POA | PaymntType | Iconic | Cartons | Qty | TotVal | CurrType | ValInDhs | Doc.OrigBL | Doc.OrigFCR | Doc.OrigInvoice | Doc.OrigPKList | Doc.OrigCOO | DateOfOrg | DateOfCopy | FCR-No | SSN1 | SSN2 | Job Status | POsAdded | Remarks
Spreadsheet: 123276d1317482384-conditional-formula-with-summation-not-returning-correct-result-why-just-because
Sheet: Sheet1

 | Does not work |  |  |  | ???? | Works
 | 59 | 0.3 | Total 1 |  |  | -2 | -0.5 | Total 1
 | 216 | 0 | Total 2 |  |  | 25 | 0 | Total 2
 | -264 | 0.3 | Total 3 |  |  | -150 | 0 | Total 3
 | -16 | -0.5 | Total 4 |  |  | -23 | -0.5 | Total 4
 | -4.5 | 0 | Total 5 |  |  | 4 | 0 | Total 5
 |  |  | Total |  |  |  |  | Total
 | Actual values
 |  |  | Zero does not always equal zero in Excel.  Internal Excel issue that has been around for years. Because of the computer and not excel.
 |  |  | Use round function to take care of the problem
 | Does not work - Modified so it does
 | 59 | 0.3 | Total 1
 | 216 | 0 | Total 2
 | -264 | 0.3 | Total 3
 | -16 | -0.5 | Total 4
 | -4.5 | 0 | Total 5
 |  |  | Total
Spreadsheet: 698068d1601720432-extract-specific-numbers-and-text-from-long-string-product-codes
Sheet: Test

 | Product Codes (Manual) |  |  |  |  |  | Model Version Code Table
 | Product | List of Codes | Model Version Code | Model Version |  |  | Model Version Code | Model Version
 | Product 1 | 6P5 ,800 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50 | 800 | 2020 |  |  | 800 | 2020
 | Product 1 | 6P5 ,801 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50 | 801 | 2021 |  |  | 801 | 2021
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY0 | XY0 | 2020 |  |  | XY0 | 2020
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY1 | XY1 | 2021 |  |  | XY1 | 2021
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XZ9 | XZ9 | 2020 |  |  | XZ9 | 2020
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,X20 | X20 | 2021 |  |  | X20 | 2021
 | Product Codes (Auto - Required Formulas)
 | Product | List of Codes | Model Version Code | Model Version
 | Product 1 | 6P5 ,800 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50
 | Product 1 | 6P5 ,801 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY0
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY1
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XZ9
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,X20
Spreadsheet: 173903d1344849552-get-number-of-non-sum-zero-columns-findnumberofnonzerocolumns
Sheet: Tabelle1

12 | 12 | 21 | 0
12 | 12 | 12 | 0
12 | 12 | 12 | 34
A | B | C | D | E | F | G | H
 |  |  |  | 5 | 6 | 7 | 8 | 5
I would like to get the number "4", because this table has 4 non-zero (or non-empty) columns
Spreadsheet: 129849d1321929623-sorting-data-sorting
Sheet: Sheet1

Employee a
Promotion1 | 2
Promotion2 | 1
Promotion3 | 1
Promotion4 | 5
Employee b
Promotion1 | 3
Promotion2 | 1
Promotion3 | 3
Promotion4 | 15
Employee c
Promotion1 | 1
Employee d
Promotion1 | 1
Employee e
Promotion1 | 34
Promotion2 | 2
Employee f
Promotion1 | 39
Employee g
Promotion1 | 1
Promotion2 | 4
Promotion3 | 4
Promotion4 | 231
Promotion5 | 2
Employee h
Promotion1 | 2
Promotion2 | 2
Promotion3 | 3
Promotion4 | 10
Promotion5 | 1
Promotion6 | 33
Promotion7 | 1
Spreadsheet: 750622d1633545641-vlookup-formula-mixed-with-sumproduct-formula-problem-example-problem
Sheet: Sheet1

Timing | Amount | Data A | Data B
2022-01-30 00:00:00 | 50000 | 0.6 | 0.4
2022-03-28 00:00:00 | 350000 | 0.6 | 0.4
2022-05-28 00:00:00 | 20000 | 0.6 | 0.4
2022-06-28 00:00:00 | 50000 | 0.6 | 0.4
2022-07-28 00:00:00 | 100000 | 0.6 | 0.4
2023-01-28 00:00:00 | 200000 | 1 | 0
2023-02-28 00:00:00 | 50000 | 1 | 0
2023-02-28 00:00:00 | 25000 | 1 | 0
2023-02-28 00:00:00 | 25000 | 1 | 0
[NAME] (example 1) | 2023-02-28 00:00:00
Desired Output 1
Desired Output 2
[NAME] (example 1) | 2022-01-30 00:00:00
Desired Output 1
Desired Output 2
Spreadsheet: 680422d1591013695-simplest-way-to-filter-dates-date-filters
Sheet: Sheet1

Customer ID | Total Invoiced | Date of Purchase DDMMYYYY
71061 | 5248 | 2020-02-01 00:00:00
71183 | 5240 | 2020-02-01 00:00:00
72064 | 5323 | 2020-02-03 00:00:00
71631 | 5263 | 2020-03-02 00:00:00 |  |  |  |  | Quantity
71840 | 5264 | 2020-05-02 00:00:00 |  |  |  | Q1
71842 | 5280 | 2020-05-02 00:00:00 |  |  |  | Q2
71844 | 5287 | 2020-05-02 00:00:00
71356 | 5303 | 2020-06-02 00:00:00
70571 | 5241 | 2020-07-01 00:00:00
70775 | 5219 | 2020-07-01 00:00:00
70726 | 5266 | 2020-10-01 00:00:00
71841 | 5276 | 2020-10-02 00:00:00
71432 | 5284 | 2020-11-02 00:00:00
71737 | 5260 | 2020-11-02 00:00:00
72220 | 5338 | 2020-12-03 00:00:00
71693 | 5270 | 13/02/2020
70699 | 6749 | 14/01/2020
72087 | 5307 | 14/02/2020
71843 | 5282 | 14/02/2020
71606 | 6748 | 15/01/2020
70700 | 5256 | 15/01/2020
71062 | 5259 | 15/01/2020
72685 | 5347 | 15/05/2020
72643 | 5320 | 15/05/2020
72650 | 5321 | 15/05/2020
72632 | 5311 | 15/05/2020
72635 | 5312 | 15/05/2020
71839 | 5216 | 18/02/2020
72255 | 5296 | 18/02/2020
71845 | 5295 | 18/02/2020
72273 | 5359 | 19/03/2020
70776 | 5251 | 20/01/2020
71846 | 5302 | 20/02/2020
72738 | 7610 | 22/05/2020
71463 | 5254 | 23/01/2020
71775 | 5315 | 25/02/2020
72737 | 7611 | 25/05/2020
71063 | 5267 | 29/01/2020
71542 | 5261 | 31/01/2020