tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703271d1604921912-formula-or-pivot-advice-welcomed-on-how-to-achieve-customer-lifetime-statistics-sample-data
Sheet: Sheet1

ID | Tax date | Date Due | Type | Contact | Details | Order ID | Invoice ref | Currency | Amount | Paid | Cleared
128715 | 2020-05-14 | 2020-05-14 00:00:00 | SI | [NAME] |  | 39970 | SI-36189 | GBP | 44 | 44 | Yes
125425 | 2020-03-31 | 2020-03-31 00:00:00 | SI | [NAME] |  | 39003 | SI-35222 | GBP | 0 |  | Yes
116103 | 2019-12-04 | 2019-12-04 00:00:00 | SI | [NAME] |  | 36074 | SI-32569 | GBP | 53.56 | 53.56 | Yes
110696 | 2019-10-09 | 2019-10-09 00:00:00 | SI | [NAME] |  | 34211 | SI-31005 | GBP | 37.66 | 37.66 | Yes
104807 | 2019-07-23 | 2019-07-23 00:00:00 | SI | [NAME] |  | 32348 | SI-29335 | GBP | 76.36 | 76.36 | Yes
101467 | 2019-06-07 | 2019-06-07 00:00:00 | SI | [NAME] |  | 31388 | SI-28407 | GBP | 4.95 | 4.95 | Yes
96520 | 2019-04-03 | 2019-04-03 00:00:00 | SI | [NAME] |  | 29799 | SI-27019 | GBP | 40.56 | 40.56 | Yes
17074 | 2016-07-15 | 2016-07-15 00:00:00 | SI | [NAME] |  | 4981 | SI-5043 | GBP | 19.96 | 19.96 | Yes
13849 | 2016-06-07 | 2016-07-07 00:00:00 | SI | A. Clarkson Associates |  | 3983 | SI-4217 | GBP | 75.79 | 75.79 | Yes
13833 | 2016-06-07 | 2016-06-07 00:00:00 | SI | A Tyers |  | 3944 | SI-4206 | GBP | 90.48 | 90.48 | Yes
12288 | 2016-05-20 | 2016-05-20 00:00:00 | SI | A Tyers |  | 3496 | SI-3800 | GBP | 75.48 | 75.48 | Yes
6827 | 2016-03-15 | 2016-03-13 00:00:00 | SI | A Tyers |  | 1912 | SI-2433 | GBP | 58.75 | 58.75 | Yes
3690 | 2016-02-02 | 2016-01-31 00:00:00 | SI | A Tyers |  | 918 | SI-1617 | GBP | 68.76 | 68.76 | Yes
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -32 | 8
2 |  | -657
3 | -648 | -657
4 | -2024 | -657
5 | -2050 | -657
6 | -2020 | -657
7 | -1834 | -657
8 | -409 | -657 |  |  |  |  |  |  |  |  | Avg
9 | -425 | -657 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10 | -1898 | -657
11 | -1844 | -657 |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 | -1374 | -657 |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 | -1653 | -657 |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 | -582 | -657 |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 | -670 | -657 |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 | -888 | -657 |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 | -2001 | -657 |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18 | -1889 | -657
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -292829
2002-02-18 00:00:00
CBS Volume
 |  |  | -14344
Spreadsheet: 21099d1208220621-adjustable-rate-mortgage-restrict-range-arm
Sheet: Sheet1

ARM Rate | Adjusted |  | Life Max | 0.05
0.06 | 0.06 |  | Year Max | 0.03
0.1 | 0.09
0.12 | 0.11
0.08 | 0.08
0.08 | 0.08
0.04 | 0.05
0.01 | 0.02
0 | 0.009999999999999995
0.03 | 0.03
Spreadsheet: darrell_schoolcraft__7807__imbalsumm0108
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1
2
3 |  | -2368
4 |  | -2368
5 |  | -2368
6 |  | -2368
7 |  | -2368
8
9
10
11
12
13
14
15
16 | -4
17 | -1
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 76325
2001-08-20 00:00:00
CBS Dollars
 |  |  | 341220.3
Spreadsheet: 47617d1246690571-small-function-iannew
Sheet: OUTPUT

Player
Handicap
Date | Course | Score | FH | GIR | Putts | Putts Per GIR | %GIR/PAR | TOT PARS | TOT Birdies | AHS | Handicap at time played | FH Possible | GIR/PAR
Totals
Averages | n/a
Percentages | n/a | n/a |  |  |  | n/a | n/a |  |  | n/a | n/a | n/a
Spreadsheet: 800566d1665743382-alternative-to-nested-ifs-nested-if-examples
Sheet: Sheet1

 |  | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032
 | % of people who sign up to new scheme
 | Uptake Scenarios | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032
 | High | 0.9 | 0.9 | 0.8 | 0.8 | 0.7 | 0.7 | 0.6 | 0.6 | 0.5 | 0.5
 | Medium | 0.9 | 0.8 | 0.7 | 0.6 | 0.5 | 0.5 | 0.4 | 0.4 | 0.4 | 0.3
 | Low | 0.7 | 0.6 | 0.5 | 0.4 | 0.3 | 0.2 | 0.1 | 0 | 0 | 0
 | Uptake in new scheme | High
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 8697 | 6399 | 114 | 179 | 1543 | 1323 | 322 | 298
2 | 8008 | 6399 | 120 | 179 | 1630 | 1323 | 176 | 298
3 | 7274 | 6399 | 177 | 179 | 1555 | 1323 | 41 | 298
4 | 6935 | 6399 | 213 | 179 | 1427 | 1323 | 0 | 298
5 | 6927 | 6399 | 188 | 179 | 1521 | 1323 | 5 | 298
6 | 2953 | 6399 | 167 | 179 | 1484 | 1323 | 318 | 298
7 | 6098 | 6399 | 170 | 179 | 442 | 1323 | 408 | 298
8 | 8005 | 6399 | 97 | 179 | 276 | 1323 | 308 | 298
9 | 7359 | 6878 | 112 | 179 | 346 | 1323 | 242 | 298
10 | 6248 | 6857 | 192 | 179 | 604 | 1323 | 201 | 298
11 | 6822 | 6848 | 90 | 179 | 1135 | 1323 | 82 | 298
12 | 3692 | 6899 | 16 | 179 | 1161 | 1406 | 143 | 298
13 | 6044 | 6872 | 99 | 179 | 759 | 1323 | 144 | 298
14 | 7706 | 6899 | 157 | 179 | 653 | 1423 | 38 | 298
15 | 6236 | 6899 | 131 | 179 | 1179 | 1323 | 92 | 298
16 | 6459 | 6899 | 187 | 179 | 890 | 1423 |  | 298
17 | 6567 | 6899 | 202 | 179 | 1063 | 1423 |  | 298
18 | 6214 | 6899 | 162 | 179 | 1759 | 1423 | 1038 | 298
19 | 6380 | 6899 | 137 | 179 | 1806 | 1423 | 917 | 298
20 | 6020 | 6899 | 175 | 179 | 1734 | 1423 | 804 | 298
21 | 6377 | 6899 | 133 | 179 | 1154 | 1423 | 1020 | 298
22 | 6054 | 6899 | 100 | 179 | 1462 | 1423 |  | 298
23 | 6365 | 7371 | 103 | 179 | 1502 | 1323 | 57 | 1298
24 | 6060 | 7371 | 126 | 179 | 1452 | 1323 | 824 | 1298 |  |  | 377
25 | 4400 | 7371 | 181 | 179 | 810 | 1323 | 782 | 1298 |  |  | 725
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | 509472.93
2000-12-25 00:00:00
Spreadsheet: 485370d1476851572-select-value-in-table-based-on-gender-and-weight-select-value-in-table-based-on-gender-and-weight-v2
Sheet: Before

 | Male |  |  |  | Name | Gender | Weight | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 |  | Total | End Score |  |  | Coefficient check
 | Weight | coefficient |  |  |  |  |  |  |  |  |  |  |  |  | = total * Coeffiecient |  |  | = end score / total
 | 60 | 1.5 |  |  |  | Male | 80.7 | 50 | 51 | 60 | 55 | 62
 | 70 | 1.4 |  |  |  | Male | 75.6 | 55 | 52 | 58 | 60 | 61
 | 80 | 1.3 |  |  |  | Female | 60 | 40 | 48 | 48 | 50 | 0
 | 90 | 1.2 |  |  |  | Male | 95.1 | 60 | 65 | 66 | 68 | 0
 | 100 | 1.1 |  |  |  | Female | 75 | 45 | 0 | 50 | 52 | 53
 | Female |  |  |  |  | Excel Forum
 | Weight | coefficient
 | 55 | 1.63
 | 65 | 1.52
 | 75 | 1.41
 | 85 | 1.3
 | 95 | 1.19
Spreadsheet: 218575d1362501958-conditional-formatting-based-on-dates-2-copy-of-mss
Sheet: Sheet1

 |  |  | Type | DG1 | M2 | M3 | M4 | DG2 | M5 | M6 | M7 | M8 | DG3 | M9 | DG4 | M11
 |  |  | Planned à | 2012-03-21 12:02:08 | 2012-08-21 00:00:00 | 2012-09-24 00:00:00 | 2013-01-04 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-25 00:00:00 | 2013-03-13 00:00:00 | 2013-03-17 00:00:00 | 2013-03-17 00:00:00 | 2013-04-17 00:00:00
 |  |  | Actual à | 2012-08-21 00:00:00 | 2012-08-21 00:00:00 | 2012-09-25 00:00:00 | 2013-01-04 00:00:00 | 2013-02-20 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
Spreadsheet: 158607d1338317374-lookup-in-split-ranges-as-in-one-copy2-copy
Sheet: Sheet1

Code | Category 1 |  |  |  | Category 2
 | ProductA | ProductB | ProductC | TOTAL | ProductD | ProductE | ProductG | ProductH | TOTAL | etc.
123 | 10 | 40 | 20 | 70 | 5 | 15 | 25 | 30 | 75
456 | 432 | 4 | 45 | 54353 | 435 | 23 | 123 | 5 | 3432342
789
etc. |  |  |  |  |  |  |  |  |  |  |  | Need to:
 |  |  |  |  | 75 |  |  |  |  |  |  | 1. [NAME] that would: based on a Code return Top X value of a product EXCLUDING totals
 |  |  |  |  | 70 |  |  |  |  |  |  | 2. [NAME] that would: based on a Code return Top X name of a product EXCLUDING totals
 |  |  |  |  | 40
 |  |  |  |  | 25 |  |  |  |  |  |  | Example:
 |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | Enter Code: |  | 123 |  | < user inputs any code
 |  |  |  |  |  |  |  |  |  |  |  |  | Top 5 | Value | Name
 |  |  |  |  |  |  |  |  |  | 40 | ProductB |  | 1 | 40 | ProductB |  | < formulas in O and P
 |  |  |  |  |  |  |  |  |  | 30 | ProductH |  | 2 | 30 | ProductH |  | return values based on data above to the left
 |  |  |  |  |  |  |  |  |  | 25 | ProductG |  | 3 | 25 | ProductG
 |  |  |  |  |  |  |  |  |  | 20 | ProductC |  | 4 | 20 | ProductC
 |  |  |  |  |  |  |  |  |  | 15 | ProductE |  | 5 | 15 | ProductE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula needed here
Spreadsheet: 34755d1232072210-graphing-dynamic-line-chart-axes-book1
Sheet: Sheet1

 | 1 | 1.6 | 1.5 | 1.4
 | 2 | 1.6 | 1.5 | 1.4
 | 3 | 1.6 | 1.5 | 1.4
 | 4 | 1.6 | 1.5 | 1.4
 | 5 | 1.6 | 1.5 | 1.4
 | 6 | 1.6 | 1.5 | 1.4
 | 7 | 1.6 | 1.5 | 1.4
 | 8 | 1.6 | 1.5 | 1.4
 | 9 | 1.6 | 1.5 | 1.4
 | 10 | 1.6 | 1.5 | 1.4
 | 11 | 1.6 | 1.5 | 1.4
 | 12 | 1.6 | 1.5 | 1.4
 | 13 | 1.6 | 1.5 | 1.4
 | 14 | 1.6 | 1.5 | 1.4
 | 15 | 1.6 | 1.5 | 1.4
 | 16 | 1.6 | 1.5 | 1.4
 | 17 | 1.6 | 1.5 | 1.4
 | 18 | 1.6 | 1.5 | 1.4
 | 19 | 1.6 | 1.5 | 1.4
 | 20 | 1.6 | 1.5 | 1.4
 | 21 | 1.6 | 1.5 | 1.4
 | 22 | 1.6 | 1.5 | 1.4
 | 23 | 1.6 | 1.5 | 1.4
 | 24 | 1.6 | 1.5 | 1.4
 | 25 | 1.6 | 1.5 | 1.4
 | 26 | 1.6 | 1.5 | 1.4
 | 27 | 1.6 | 1.5 | 1.4
 | 28 | 1.6 | 1.5 | 1.4
 | 29 | 1.6 | 1.5 | 1.4
 | 30 | 1.6 | 1.5 | 1.4
 | 31 | 1.6 | 1.5 | 1.4
Spreadsheet: 747218d1631287992-how-to-count-the-total-of-numbers-in-a-range-of-percentage-sample-opp-
Sheet: PV

Adjusted Cycle | C1
Grouping | A
 |  |  | I tried the formula below but it is not the result I wish to get
Row Labels | Count of ID |  | =COUNTIFS(OPP[Adjusted Cycle],"C1",OPP[Grouping],"A",OPP[VAL %],">=32%")
0.35 | 8
70% | 58
APP CLOSED | 1
APP REJ | 1 |  | 1) I would like to count the total of those more than or equals to 32% |  |  |  |  |  |  |  | 66
DOC | 4 |  | 2) I would like to count the total of those listed as words instead of numbers |  |  |  |  |  |  |  | 7
WTH | 1
Grand Total | 73
Spreadsheet: 680120d1590784028-using-isnumber-for-ifs-function-over-a-range-im_not_ben_wyatt-apartment-items-expenses
Sheet: Sheet1

 |  | Apartment Items - Expenses
 |  | Item |  | Location | Control | Price |  | A's Expenses |  | A | My attempt
 |  | Door Draft Stopper |  | Living | Both | 9.99 |  |  |  | Both
 |  | Room Divider |  | Bed | A | 47.99 |  | D's Expenses |  | D
 |  | [NAME] |  | Bed | A | 30.95
 |  | Coat Hanger |  | Living | Both | 19.97
 |  | Coffee Maker |  | Kitchen | A | 24.99
 |  | TV LED Strip |  | Living | Both | 13.99
 |  | Coasters |  | Living | Both | 16.99
 |  | Canvas Art |  | Living | Both | 29.9
 |  | Pillow Cover |  | Bed | A | 13.99
 |  | [NAME] |  | Bath | A | 20.99
Spreadsheet: 41b095bc-2883-499e-9f28-1f71ff3d7aef
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (6 [NAME]):
 | 1 Applikationen 1.7 Sonderanwendungen 1.7.3 Zerstörungsfreie Werkstoffprüfung
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | analyticon instruments gmbh | Deutschland | Rosbach | 61191 | A2.439
2 | Helmut Fischer GmbH Institut für Elektronik und [NAME] | Deutschland | Sindelfingen | 71069 | A1.204
3 | Innov-X Systems Europe B.V. | Niederlande | s&#39;-Hertogenbosch | 5222 AX | A2.534
4 | PANalytical GmbH | Deutschland | Kassel | 34123 | A2.227
5 | Shimadzu Deutschland GmbH | Deutschland | Duisburg | 47269 | [NAME]
6 | [NAME] | Großbritannien | St. [NAME], [NAME] | BR5 4HE | A1.538B
Spreadsheet: 874678d1721225256-problem-with-loop-in-excel-circular-references-that-creates-errors-ex_model-corrected
Sheet: Sheet2

size | 5 | MW
efficiency  system | 0.6
[NAME] | 33 | kwh/kg |  |  | system is dependent on tank inventory
[NAME] - load | 0.8 |  |  |  | tank - start with 100 just the 1h, I dont want tank to go under min, this is why i want to adjust electrolyzer up and down
min -load | 0.2
[NAME] tank | 350 | [NAME]
min-tank | 10 | [NAME]
start tank | 100 | [NAME]
energy (kwh) | system size to meet energy (kw) | system (kW) | biogas produced (kg) | biogas required (kg) | diff [NAME] | energy from system (kwh) | additional heat | [NAME] to tank | adding to tank | Tank inventory (kg)
4567
4568
4569
4570
Spreadsheet: 32dbbd1e-bdc0-49e1-9b80-78a66a5b65d8
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Technical Services | 1 | Objective 1 | None | -- Pick One -- | 1.1.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 1 | Objective 1 | None | -- Pick One -- | 2.1.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 1 | Objective 1 | None | -- Pick One -- | 2.1.r2 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 2 | Objective 2 | None | -- Pick One -- | 2.2.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 3 | Objective 3 | None | -- Pick One -- | 2.3.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 3 | Objective 3 | None | -- Pick One -- | 2.3.r2 | Resource Request | OneTime | 8000 | 0 | 16000 | 0 | 0 | 0 | 0 | 0
Technical Services | 5 | Objective 4 | None | -- Pick One -- | 2.4.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 1 | Objective 1 | None | -- Pick One -- | 3.1.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 3 | Objective 2 | None | -- Pick One -- | 3.2.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 106535d1303815172-match-cell-contents-display-difference-in-another-cell-book1_gsisbay
Sheet: Sheet1

A | B |  |  |  | C(result)
Seattle, Washington, USA | Washington USA |  | Seattle |  | Seattle
Washington Seattle USA | Washington USA |  | Seattle |  | Seattle
Washington, USA | Seattle Washington USA |  | Seattle |  | Seattle
Washington USA | Washington Seattle USA |  | Seattle |  | Seattle
Seattle Washington | Seattle USA |  | Washington USA |  | Washington USA
Spreadsheet: 763920d1642455818-why-the-iferror-does-not-work-here-copy-of-why-iferror-not-working-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  | 77 | 555 | 222 | #N/A
 |  |  | 11 | 22 | 66 | 444 | 333
 |  |  | 23 | 33 | 77 | 555 | 222 |  | Array items:
 |  |  | 45 | 44 | 88 | 666 | 777
 |  |  | 67 | 55 | 99 | 777 | 212
 |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  | 555
 |  |  |  |  |  |  |  |  |  | 222
Spreadsheet: 274103d1383012174-vlookup-problems-or-other-formula-to-pull-information-please-help-lookup-partial-number
Sheet: Sheet1

Member | Member ID
[NAME] | 123789456
[NAME] | 7654321
[NAME] | 4567
[NAME] | 23654789
Member ID | Deposite | Name
123456789 | $2
987654321 | $2
456789123 | $2
Spreadsheet: 330392d1404738324-inventory-tracking-inventory
Sheet: Deletions

Bar Code | Stock ref | Description | Date | Quantity | Reference
130-001 |  |  | 2014-07-01 00:00:00 | 1 | aaa1
140-002 |  |  | 2014-07-02 00:00:00 | 2 | aaa2
150-005 |  |  | 2014-07-03 00:00:00 | 1 | aaa3
130-001 |  |  | 2014-07-04 00:00:00 | 3 | aaa4
140-002 |  |  | 2014-07-05 00:00:00 | 1 | aaa5
150-005 |  |  | 2014-07-05 00:00:00 | 2 | [NAME]
Spreadsheet: 181439d1348045633-auto-sort-multiple-fields-using-macro-project-list-template
Sheet: Office

Priority | Task | Importance | Effort | Urgency | Due Date | Ramp Up | Extension | Days Left | Finished | Comments
14 | Case 15742 Confirmatin | a | 3 | 4 | 2012-10-01 00:00:00 | 12 | 15 | 12
16 | Case 17363 Examination | c | 2 | 4 | 2012-09-20 00:00:00 | 10 | 7 | 1
59 | Case 17234 MR | d | 1 | 5 | 2012-10-22 00:00:00 | 2 | 2 | 33
77 | Case 17352 Needs a visit | e | 4 | 5 | 2012-10-22 00:00:00 | 14 | 30 | 33
92 | Case 17234 MR | f | 5 | 5 | 2012-10-22 00:00:00 | 4 | 3 | 33
Spreadsheet: 125139d1318890986-excel-2007-lookup-with-multiple-criteria-in-row-and-column-vac_calc
Sheet: Sheet1

Sheet 1 |  |  |  | 2012-05-01 00:00:00
No | Name | Start Date | Vac entitlement years | Class | Entitlement
1 | Test | 2004-01-01 00:00:00 |  | ABC
2 | Test1 | 2007-02-03 00:00:00 |  | BCD
3 | Test2 | 2006-05-06 00:00:00 |  | DEF
Sheet 2 | Vacation weeks based on year and class
 | Vac entitlement | ABC | BCD | DEF
 | 1 | 0 | 0 | 0
 | 2 | 1 | 1 | 2
 | 3 | 2 | 2 | 2
 | 4 | 3 | 3 | 3
 | 5 | 4 | 4 | 4
 | 6 | 5 | 5 | 5
 | 7 | 6 | 6 | 6
 | 8 | 7 | 7 | 7
 | 9 | 8 | 8 | 8
I need to pull the value into col F based on the Class and Vac entitlement
Spreadsheet: 687860d1595447841-getting-last-date-using-an-aggreate-function-aggregate
Sheet: Sheet1

County | State | Date | Rating |  | Example of Desired Table for Last Occurrence
Dodge | MN | 2020-05-01 00:00:00 | NR
Fillmore | MN | 2020-05-02 00:00:00 | NR |  |  | Ratings of Last Occurrence
Dodge | MN | 2020-05-03 00:00:00 | EF0 |  |  | NR | F0 or EF0 | F1 or EF1 | F2 or EF2 | F3 orEF3 | F4 or EF4 | F5 or EF5
Fillmore | MN | 2020-05-04 00:00:00 | EF0 |  | Dodge | 2020-05-01 00:00:00 | 2020-05-05 00:00:00 | 2020-05-09 00:00:00 | 2020-05-13 00:00:00 | 2020-05-17 00:00:00
Dodge | MN | 2020-05-05 00:00:00 | F0 |  | Fillmore | 2020-05-02 00:00:00 | 2020-05-06 00:00:00 | 2020-05-10 00:00:00 | 2020-05-14 00:00:00 |  | 2020-05-18 00:00:00
Fillmore | MN | 2020-05-06 00:00:00 | F0
Dodge | MN | 2020-05-07 00:00:00 | F1
Fillmore | MN | 2020-05-08 00:00:00 | F1
Dodge | MN | 2020-05-09 00:00:00 | EF1
Fillmore | MN | 2020-05-10 00:00:00 | EF1 |  | EXCEL Table
Dodge | MN | 2020-05-11 00:00:00 | EF2
Fillmore | MN | 2020-05-12 00:00:00 | EF2 |  |  | Ratings of Last Occurrence
Dodge | MN | 2020-05-13 00:00:00 | F2 |  |  | NR | F0 or EF0 | F1 or EF1 | F2 or EF2 | F3 orEF3 | F4 or EF4 | F5 or EF5
Fillmore | MN | 2020-05-14 00:00:00 | F2 |  | Dodge
Dodge | MN | 2020-05-15 00:00:00 | F3 |  | Fillmore
Fillmore | MN | 2020-05-16 00:00:00 | F4
Dodge | MN | 2020-05-17 00:00:00 | EF3
Fillmore | MN | 2020-05-18 00:00:00 | EF4
Spreadsheet: 2ff467d2-f3b6-458e-a25f-2ed286b4f88f
Sheet: Table 7.2

Monthly Statistical Bulletin
7.2 Components of population change
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Births – '000
September
December
March
June
Annual
Deaths – '000
September
December
March
June
Annual
Natural increase – '000
September
December
March
June
Annual
Net overseas migration (a) – '000
September
December
March
June
Annual
(a) From September 2006 the ABS introduced an improved methodology for estimating net
overseas migration. These data are not comparable with earlier data.
 |  |  |  |  |  |  |  | Update
Source: ABS, Australian demographic statistics, Cat. no. 3101.0 | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3101.0&viewtitle=Australian%20Demographic%20Statistics~Sep%202007~Latest~19/03/2008&&tabname=Past%20Future%20Issues&prodno=3101.0&issue=Sep%202007&num=&view=&
Spreadsheet: chris_stokley__3876__CDWR 7day settlements
Sheet: Invoice5

 | INVOICE DETAIL
 |  |  |  |  |  | ENRON POWER MARKETING, INC.
CUSTOMER INFORMATION |  |  | INVOICE INFORMATION |  |  |  |  | CONTRACT INFORMATION |  | PAYMENT INFORMATION
California Energy Resources Scheduling |  |  | INVOICE NUMBER: | NTP010313 |  |  |  | CONTRACT NO: | 95001154 | WIRE TRANSFER:
PO Box 942836 |  |  | INVOICE DATE: | 2001-03-28 00:00:00 |  |  |  | CONTRACT DATE: |  | Enron Power Marketing Inc.
Sacremento, California |  |  | DUE DATE: | 2001-03-30 00:00:00 |  |  |  |  |  | Bank Of America - Dallas, TX
94236-0001 |  |  |  |  |  |  |  | TERMS: rolling seven day cycle per confirmation |  | Account Number:  [PHONE]
Attn: Cecilia Vasquez |  |  | CONTACT: | [NAME] |  |  |  |  |  | ABA Number:  111000012
Phone: [PHONE] |  |  | Phone:  (713)  853-9741
Fax:        [PHONE] |  |  | Fax:      (713)  646-4061
TO INVOICE FOR SALES FOR THE MONTH OF February 2001
 |  |  | DATES |  | HOUR |  |  | ENERGY | PRICE | PRICE | TOTAL
[NAME] |  |  | START | END | START | END |  | [NAME] | CODE | $[NAME] | DOLLARS
SALES |  |  | 2001-03-22 00:00:00 | 2001-03-28 00:00:00 |  |  |  | 19200 |  |  | 5088000
SALES |  |  | 2001-03-22 00:00:00 | 2001-03-28 00:00:00 |  |  |  | 14400 |  |  | 1000800
TOTAL NET DUE ENRON POWER MARKETING, INC.
Spreadsheet: 293851d1391108065-cell-formatting-sample1
Sheet: Sheet2

 |  | NAMES WILL BE HIGHLIGHTED HERE
 | WALTER F. |  |  | DEROY D.
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | BRENNEN R.
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | PHIL
 | JOEY M. |  |  | [NAME]
 | TOMMY M |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | THAD A.
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | LAURENCE
 | [NAME] |  |  | [NAME]
 |  |  |  | KAULANA
 |  |  |  | [NAME]
 |  |  |  | J.LIMAHAI
Spreadsheet: 57029d1257201773-creating-a-report-from-a-table-sample-worksheet
Sheet: Sheet1

AcctNum | AcctDescr | Year | Month | Scenario | Amount
10110 | Food | 2009 | 1 | Actuals | 1000
10115 | Travel | 2009 | 1 | Actuals | 1100
10110 | Food | 2009 | 2 | Actuals | 2000
10115 | Travel | 2009 | 2 | Actuals | 2100
10133 | Gifts | 2009 | 2 | Actuals | 2200
10110 | Food | 2009 | 1 | Budgets | 1500
10115 | Travel | 2009 | 1 | Budgets | 900
10133 | Gifts | 2009 | 1 | Budgets | 1200
10110 | Food | 2009 | 2 | Budgets | 2500
10115 | Travel | 2009 | 2 | Budgets | 1900
10133 | Gifts | 2009 | 2 | Budgets | 2200
Summary
February 2009
 |  | Actuals | Budgets
10110 | Food | 1500 | 2500
10133 | Gifts | 1200 | 2200
10115 | Travel | 900 | 1900
Total |  | 3600 | 6600
Spreadsheet: 878909d1726239351-excel-formula-to-correct-vat-calculations-correction-of-vat
Sheet: Sheet1

Kindly asking for excel formula to correct VAT charged as shown on the desired solution
 |  |  |  |  |  |  |  | Desired Solution
Date | Customer | Vat Number | Amount (Excl.) | Tax (15%) | Total |  |  | Date | Customer | Vat Number | Amount (Excl.) | Tax (15%) | Total
2024-07-01 | Cash | - | 1.7 | 0.3 | 2 |  |  | 2024-07-01 | Cash | - | 1.739130434782609 | 0.2608695652173913 | 2
2024-07-01 | Cash | - | 1.7 | 0.3 | 2 |  |  | 2024-07-01 | Cash | - | 1.739130434782609 | 0.2608695652173913 | 2
2024-07-01 | Cash | - | 5.44 | 0.96 | 6.4 |  |  | 2024-07-01 | Cash | - | 5.565217391304348 | 0.8347826086956521 | 6.399999999999999
2024-07-01 | Cash | - | 1 | 0 | 1 |  |  | 2024-07-01 | Cash | - | 1 |  | 1
2024-07-01 | Cash | - | 0.425 | 0.075 | 0.5 |  |  | 2024-07-01 | Cash | - | 0.4347826086956522 | 0.06521739130434782 | 0.5
2024-07-01 | Cash | - | 0.0425 | 0.0075 | 0.05 |  |  | 2024-07-01 | Cash | - | 0.04347826086956522 | 0.01 | 0.05
2024-07-01 | Cash | - | 4.5 | 0 | 4.5 |  |  | 2024-07-01 | Cash | - | 4.5 |  | 4.5
2024-07-01 | Cash | - | 5.95 | 1.05 | 7 |  |  | 2024-07-01 | Cash | - | 6.086956521739131 | 0.9130434782608696 | 7
2024-07-01 | Cash | - | 0.85 | 0.15 | 1 |  |  | 2024-07-01 | Cash | - | 0.8695652173913043 | 0.1304347826086956 | 1
Spreadsheet: 0783432b-7609-4784-8b4e-d48987df3dc7
Sheet: Sheet1

1933 - 21st Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Expo Century of Progress, Chicago, Illinois, USA |  |  |  |  | September 2nd, 1933
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | POL | [NAME] | [NAME] | Burzynski | Zbigniew | Kosciuszko | Port Neuf/Quebec/Canada | 1361 | 1900-01-01 14:32:00
2 | USA | Settle | Lt. T.G.W. | Kendall | Lt. | US Navy | Lake Ontario | 1248 | 1900-01-02 03:00:00
3 | USA | Orman | [NAME] | Trotter | [NAME] | Goodyear IX | Ca. | 791
4 | GER | Schütze | [NAME] | Körner | (Dr.) | Deutschland | Klingstone/Michigan | 403 | 1900-01-01 02:00:00
5 | BEL | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 368
6 | FRA | Ravaine | Georges | [NAME] | [NAME] | [NAME] |  | 249
7 | GER | Deku | Erich | Opel | Fritz v. | [NAME] |  | no start
8 | SUI | Tilgenkamp | Dr. E. | Maag | Ernest |  |  | no start