tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 770855d1646303389-replace-multiple-specific-values-database-sample
Sheet: Sheet1

Sample: |  |  |  |  |  |  |  |  |  |  |  | Excepted result:
ID | No. | Title | Slug | Parent [NAME] |  |  |  |  |  |  |  | ID | No. | Title | Slug | Parent [NAME]
11111 | […] | Title […] | db-4186 | db-4167/db-4168/db-4169 |  |  |  |  |  |  |  | 11111 | […] | Title […] | db-4186
22222 | […] | Details | db-4187 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12338/db-9483 |  |  |  |  |  |  |  | 22222 | […] | Details | db-4187
33333 | […] | Title […] | db-4188 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12338/db-9483/db-4187 |  |  |  |  |  |  |  | 33333 | […] | Title […] | db-4188
44444 | […] | Details | db-4189 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12337/db-8890 |  |  |  |  |  |  |  | 44444 | […] | Details | db-4189
55555 | […] | Title […] | db-4190 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12337/db-8890/db-4189 |  |  |  |  |  |  |  | 55555 | […] | Title […] | db-4190
66666 | […] | Title […] | db-4207 | db-4167/db-4168/db-5261/db-9628/db-5277/db-5288/db-5303/db-12106 |  |  |  |  |  |  |  | 66666 | […] | Title […] | db-4207
77777 | […] | Title […] | db-4212 | db-4167/db-4168 |  |  |  |  |  |  |  | 77777 | […] | Title […] | db-4212
88888 | […] | Title […] | db-4213 | db-4167/db-4168/db-4212 |  |  |  |  |  |  |  | 88888 | […] | Title […] | db-4213
Spreadsheet: 94123d1293989175-search-for-string-in-worksheet-s-and-return-results-in-sequential-order-sample-workbook-mahju
Sheet: Sheet1

Department | Status | Name | ID | Hire Date | [NAME]
Engineering | Active | [NAME] | 906.2394028637782 | 2001-05-13 00:00:00
Engineering | Inactive | [NAME] | 838.8524531213054 | 1999-02-07 00:00:00
Engineering | Active | Roxie Sarles | 973.4626260948285 | 2006-05-30 00:00:00
Engineering | Active | [NAME] | 321.8163963434762 | 1997-07-18 00:00:00
Engineering | Inactive | [NAME] | 284.0495376047211 | 1984-11-03 00:00:00
Engineering | Inactive | [NAME] | 681.352207595675 | 2009-04-30 00:00:00
Engineering | Inactive | [NAME] | 356.2992476679557 | 2002-01-06 00:00:00
Facilties | Active | [NAME] | 58.88855863405411 | 2001-05-13 00:00:00
Facilties | Inactive | [NAME] | 280.8997048636497 | 1999-02-07 00:00:00
Facilties | Active | [NAME] | 732.5559100162666 | 2006-05-30 00:00:00
Facilties | Active | [NAME] | 943.6884675896359 | 1997-07-18 00:00:00
Facilties | Inactive | [NAME] | 358.1255816510792 | 1984-11-03 00:00:00
Facilties | Inactive | [NAME] | 817.0125171234417 | 2009-04-30 00:00:00
Facilties | Inactive | [NAME] | 823.3920114019417 | 2002-01-06 00:00:00
HR | Active | [NAME] | 780.6069371775324 | 2001-05-13 00:00:00
HR | Inactive | [NAME] | 31.00591356508782 | 1999-02-07 00:00:00
HR | Active | [NAME] | 155.4330631863325 | 2006-05-30 00:00:00
HR | Active | [NAME] | 335.5980033769903 | 1997-07-18 00:00:00
HR | Inactive | [NAME] | 960.6474696229312 | 1984-11-03 00:00:00
HR | Inactive | [NAME] | 653.7679716269221 | 2009-04-30 00:00:00
HR | Inactive | [NAME] | 962.1323388857961 | 2002-01-06 00:00:00
Spreadsheet: 522451d1497015670-real-estate-tiered-commission-calculator-commision-calculator-1-
Sheet: Sales

 |  |  |  |  |  |  |  |  |  | Gross Sales | Broker Rate | [NAME]
 |  |  |  |  |  |  |  |  |  | 0 | 0.3 | 0.7
 |  |  |  |  |  |  |  |  |  | 2000000 | 0.1 | 0.9
 |  |  |  |  |  |  |  |  |  | 99000000 | 0.1 | 0.9
Date | Client | Address | Price | YTD Sales | Commision Rate | Commission Amount | Broker Commission | Realtor Commission
 |  |  |  |  | 0.03 |  |  |  | Broker Rate | Realator Rate
2016 Totals
2017-06-16 00:00:00 |  |  | 500000 |  | 0.03
 |  |  | 1000000 |  | 0.03
 |  |  | 1 |  | 0.03
 |  |  |  |  | 0.03
 |  |  |  |  | 0.03
2017 Totals
Spreadsheet: dan_hyvl__4878__Pending Legal-10-02-00
Sheet: Sheet1

Buyer | [NAME] | Deal No. | Originator | Type | Deal Date | Status | Reason | Quantity | Comm | Delivery Ref | Beg Date | End Date | Price
[NAME] | ENA | NO0793.2 |  | Swap | 2000-06-27 00:00:00 | Pending | Sent to legal | 20000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-07-01 00:00:00 | 2000-10-31 00:00:00 | US 4.4925
[NAME] | ENA | NP4359.1 | [NAME] | Swap | 2000-06-30 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | US 4.4650
[NAME] | ENA | NP4459.1 | Wallis Jan | Swap | 2000-06-30 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | US 4.4500
[NAME] | ENA | NP5288.1 |  | Swap | 2000-07-05 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-08-01 00:00:00 | 2000-09-30 00:00:00 | US 4.2400
[NAME] | ENA | NP5288.2 |  | Swap | 2000-07-05 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | US 4.2750
[NAME] | ENA | NP5288.4 |  | Swap | 2000-07-05 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-10-01 00:00:00 | 2000-10-31 00:00:00 | US 4.2400
[NAME] | ENA | NP8804.1 | [NAME] | Swap | 2000-07-06 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-08-01 00:00:00 | 2001-01-31 00:00:00 | US 4.1750
RELIANTENESER | ENA | NY4684.1 | [NAME] | Forward | 2000-09-07 00:00:00 | Pending | Sent to legal |  | NG | IF ANR/LA | 2000-11-01 00:00:00 | 2001-03-31 00:00:00 | 0.015
ENA | [NAME] | NQ0954.1 | [NAME] | Swap | 2000-07-07 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-08-01 00:00:00 | 2001-01-31 00:00:00 | US 4.2600
ENA | [NAME] | NT8254.1 | Wallis Jan | Swap | 2000-08-03 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-10-01 00:00:00 | 2001-03-31 00:00:00 | US 4.2250
ENA | [NAME] | [NAME] | Wallis Jan | Swap | 2000-08-30 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | US 4.6900
ENA | [NAME] | NY4414.2 |  | Swap | 2000-09-07 00:00:00 | Pending | Sent to legal | 5000 [NAME]/day | NG | IF-HPL/SHPCHAN | 2000-10-01 00:00:00 | 2001-09-30 00:00:00 | US 4.5300
ENA | [NAME] | NY8330.1 |  | Swap | 2000-09-11 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2001-02-01 00:00:00 | 2001-08-31 00:00:00 | US 4.4200
ENA | [NAME] | NZ7026.1 | Wallis Jan | Swap | 2000-09-15 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | 2000-10-01 00:00:00 | 2000-11-30 00:00:00 | US 5.3500
ENA | RELIANTENESER | Q15401.1 |  | Forward | 2000-09-27 00:00:00 | Pending | Sent to legal |  | NG | IF-CIG/RKYMTN | 2000-11-01 00:00:00 | 2001-03-31 00:00:00 | 0.015
Spreadsheet: 162448d1339888661-excel-2007-how-can-i-join-two-formulas-mjc-registro-interactivo
Sheet: TABSR

 | Volver [NAME] |  |  | TABULACIÓN DE CADA NOTA  Segundo R
 | N1 |  | % |  | N2 |  | % |  | N3 |  | % |  | N4 |  | % |  | S1 |  | % |  | S2 |  | % |  | S3 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 | [NAME] |  | % |  | S5 |  | % |  | S6 |  | % |  | S7 |  | % |  | S8 |  | % |  | S9 |  | % |  | N5 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 | [NAME] |  | % |  | N7 |  | % |  | N8 |  | % |  | S10 |  | % |  | S11 |  | % |  | S12 |  | % |  | S13 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 | S14 |  | % |  | S15 |  | % |  | S16 |  | % |  | S17 |  | % |  | S18 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
Spreadsheet: 885638d1735432825-issues-with-pivotby-function-pivotby_col_labels_mmm
Sheet: Sheet1

 | Date | Type | Description | Amount | Month | Mth |  | Expense
 | 2024-07-25 00:00:00 | Expense | test | 10000 |  |  |  |  | Jul | Aug | Sep | Oct | Total
 | 2024-08-01 00:00:00 | Expense | Office Supplies | 150 |  |  |  | Marketing |  | 400 | 400 | 291 | 1091
 | 2024-08-03 00:00:00 | Revenue | Product Sales | 1200 |  |  |  | Office Supplies |  | 150 | 150 | 230 | 530
 | 2024-08-05 00:00:00 | Expense | Travel | 300 |  |  |  | Rent |  | 1000 | 1000 | 598 | 2598
 | 2024-08-07 00:00:00 | Revenue | Service Fees | 800 |  |  |  | test | 10000 |  |  |  | 10000
 | 2024-08-10 00:00:00 | Expense | Utilities | 200 |  |  |  | Travel |  | 300 | 300 | 1200 | 1800
 | 2024-08-12 00:00:00 | Revenue | Consulting | 1500 |  |  |  | Utilities |  | 200 | 200 | 800 | 1200
 | 2024-08-15 00:00:00 | Expense | Marketing | 400 |  |  |  | Total | 10000 | 2050 | 2050 | 3119 | 17219
 | 2024-08-18 00:00:00 | Revenue | Subscription Fees | 700
 | 2024-08-20 00:00:00 | Expense | Rent | 1000
 | 2024-08-22 00:00:00 | Revenue | Sponsorship | 900
 | 2024-09-01 00:00:00 | Expense | Office Supplies | 150
 | 2024-09-03 00:00:00 | Revenue | Product Sales | 1200
 | 2024-09-05 00:00:00 | Expense | Travel | 300 |  |  |  | Revenue
 | 2024-09-07 00:00:00 | Revenue | Service Fees | 800 |  |  |  |  | Aug | Sep | Oct | Total
 | 2024-09-10 00:00:00 | Expense | Utilities | 200 |  |  |  | Consulting | 1500 | 1500 | 490 | 3490
 | 2024-09-12 00:00:00 | Revenue | Consulting | 1500 |  |  |  | Product Sales | 1200 | 1200 | 352 | 2752
 | 2024-09-15 00:00:00 | Expense | Marketing | 400 |  |  |  | Service Fees | 800 | 800 | 275 | 1875
 | 2024-09-18 00:00:00 | Revenue | Subscription Fees | 700 |  |  |  | Sponsorship | 900 | 900 | 300 | 2100
 | 2024-09-20 00:00:00 | Expense | Rent | 1000 |  |  |  | Subscription Fees | 700 | 700 | 457 | 1857
 | 2024-09-22 00:00:00 | Revenue | Sponsorship | 900 |  |  |  | Total | 5100 | 5100 | 1874 | 12074
 | 2024-10-01 00:00:00 | Expense | Office Supplies | 230
 | 2024-10-03 00:00:00 | Revenue | Product Sales | 352
 | 2024-10-05 00:00:00 | Expense | Travel | 1200
 | 2024-10-07 00:00:00 | Revenue | Service Fees | 275
 | 2024-10-10 00:00:00 | Expense | Utilities | 800
 | 2024-10-12 00:00:00 | Revenue | Consulting | 490
 | 2024-10-15 00:00:00 | Expense | Marketing | 291
 | 2024-10-18 00:00:00 | Revenue | Subscription Fees | 457
 | 2024-10-20 00:00:00 | Expense | Rent | 598
 | 2024-10-22 00:00:00 | Revenue | Sponsorship | 300
Spreadsheet: 78911d1279198235-filtering-status-look-up
Sheet: Sheet1

thing | status
martin 1
[NAME] | pending
[NAME]
[NAME]
martin 5
[NAME]
martin 7
[NAME] | pending
martin 9
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
martin 15 | pending
[NAME]
martin 17
[NAME]
[NAME]
martin 20 | pending
martin 21
[NAME]
martin 23
[NAME]
martin 25
martin 26
Spreadsheet: 63521d1264436871-vlookup-in-a-range-vlookup-question
Sheet: Sheet1

Month Range | Factor
121 - 132 | 1
109 - 120 | 1
97 - 108 | 1
85 - 96 | 1
73 - 84 | 1
61 - 72 | 1.03
49 - 60 | 1.074
37 - 48 | 1.118
25 - 36 | 1.322
13 - 24 | 1.921
1 - 12 | 4.526
Analysis Year               Incept | Data Valued                      As Of | Months of Development | Factor
2005-10-01 00:00:00 | 2009-11-02 00:00:00 |  | 1.074
2006-10-01 00:00:00 | 2009-11-02 00:00:00 |  | 1.118
2007-10-01 00:00:00 | 2009-11-02 00:00:00 |  | 1.322
2008-10-01 00:00:00 | 2009-11-02 00:00:00 |  | 1.92
Spreadsheet: 129704d1321831072-excel-2007-calculate-an-angle-between-2-3d-vectors-demo
Sheet: 5-point practice Cal 02

 | Shoulder |  |  | Hip |  |  | Knee |  |  | Ankle |  |  | Toe
Frame | X | Y | Z | X | Y | Z | X | Y | Z | X | Y | Z | X | Y | Z
0 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1 | 56.5536 | 1141.8 | 1417.38 | 87.4513 | 1093.62 | 863.25 | 144.279 | 961.507 | 505.299 | 53.9009 | 1227.68 | 197.849 | 28.0045 | 1145.58 | 82.3287
2 | 60.7091 | 1139.26 | 1417.73 | 91.4098 | 1088.41 | 864.185 | 149.708 | 952.522 | 506.961 | 64.9521 | 1209.32 | 189.701 | 40.8525 | 1123.16 | 78.313
3 | 64.6619 | 1136.52 | 1418.05 | 94.985 | 1083.49 | 865.348 | 154.496 | 944.285 | 508.815 | 76.0216 | 1191.23 | 181.351 | 54.0247 | 1100.15 | 74.1763
4 | 68.5599 | 1133.8 | 1418.16 | 98.5797 | 1077.69 | 865.966 | 159.576 | 936.719 | 510.34 | 87.6089 | 1172.44 | 172.452 | 66.6031 | 1077.01 | 70.0211
5 | 72.3963 | 1131.16 | 1418.13 | 101.378 | 1072.75 | 867.151 | 164.009 | 929.795 | 511.346 | 98.8513 | 1152.82 | 163.593 | 78.9506 | 1052.85 | 65.4475
6 | 186.975 | -507.698 | 974.498 | 239.396 | -179.868 | 650.55 | 278.238 | -499.909 | 421.548 | 275.629 | -288.828 | 74.0655 | 229.889 | -405.699 | 24.4845
7 | 186.994 | -506.761 | 977.176 | 239.893 | -179.594 | 652.514 | 278.5 | -499.168 | 422.079 | 275.654 | -288.707 | 74.0312 | 229.917 | -405.766 | 24.3805
8 | 187.426 | -505.605 | 980.225 | 240.095 | -179.212 | 654.187 | 278.716 | -498.295 | 422.714 | 275.698 | -288.634 | 73.9903 | 229.916 | -405.775 | 24.3235
9 | 187.589 | -504.649 | 983.591 | 240.428 | -178.973 | 656.169 | 279.051 | -497.32 | 423.406 | 275.665 | -288.566 | 73.9834 | 229.853 | -405.789 | 24.3234
10 | 187.659 | -503.641 | 987.321 | 240.504 | -178.874 | 658.558 | 279.158 | -496.172 | 424.235 | 275.726 | -288.409 | 73.8376 | 229.757 | -405.813 | 24.2311
11 | 187.75 | -502.512 | 991.246 | 240.9 | -178.425 | 661.001 | 278.908 | -495.012 | 425.091 | 275.663 | -288.309 | 73.9203 | 229.738 | -405.872 | 24.1278
Spreadsheet: 296632d1392146188-copying-rows-without-numbers-ascending-example-2-
Sheet: Sheet1

 | Standings | Overall Points | Race Points | Pole | Win | Top 3 | Top 5 | Qual Exact Picks | Race Exact Picks
1 | 2dumb
2 | asphalt-angel
3 | budman271
4 | [NAME]
5 | Dog
6 | drivendirty
7 | eitsfan
8 | lostyankee
9 | m&mfan
10 | [NAME]
11 | rolltide
12 | RoushRanger1
13 | skidmark
14 | vegashotshoe
15 | warrior
Spreadsheet: 67671d1268237837-split-rows-into-columns-testoffsetcolumn
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M
A | B | C |  | [NAME] in cell A4 to be copied ….
D | E | F
G | H | I
J | K | L
Spreadsheet: 752649d1634881094-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test-1-
Sheet: COMPARE (2)

 | SUPPLIER | PRODUCT | FROM | PRICE | ORDER CODE | CHEAPEST PRICE | FROM
 | ABPAC | No. 1 [NAME]
 |  | PRODUCT | SUPPLIER | PRICE | DATE CHECK | DIFFERENCE | PRODUCT CODE | NOTES
Spreadsheet: 97205d1296445530-excel-2007-computer-fiscal-quarter-date-excel-help-attachment-01-29-2011
Sheet: Plan

Table3
State | FY2010_SP | Cnty_Agcy | P_Sec_Inst | Contacts | [NAME] | Start | Finish | FISCAL QUARTER
California | 2409.487604556806 | 58 | 70 |  |  | 2011-02-01 08:00:00
New York | 1788.824460552066 | 62 | 101
Texas | 1215.428490624481 | 254 | 60
Illinois | 1189.191343407895 | 100 | 49
Ohio | 1034.534305810557 | 88 | 52
Pennsylvania | 821.4270940853368 | 67 | 83
Florida | 793.3814105877623 | 67 | 30
North Carolina | 666.9240753706189 | 98 | 46
New Jersey | 614.6944819628037 | 21 | 27
Massachusetts | 611.2163809290954 | 14 | 56
Wisconsin | 563.2109672357537 | 72 | 29
Alabama | 541.815359554758 | 67 | 25
Louisiana | 541.12863199888 | 64 | 20
Georgia | 511.761790684774 | 159 | 36
Virginia | 491.8142053249891 | 136 | 40
Michigan | 487.8569663581036 | 83 | 36
Washington | 465.9488193119547 | 39 | 16
Maryland | 432.399270856357 | 23 | 23
Indiana | 403.7032272217629 | 92 | 42
Arizona | 374.109317530906 | 15 | 5
Minnesota | 371.129504765048 | 87 | 25
Mississippi | 366.7035803161941 | 82 | 15
Connecticut | 358.7975435739108 | 8 | 19
West Virginia | 354.9620868710744 | 55 | 17
Kentucky | 348.7425247458587 | 120 | 24
Missouri | 331.296430914615 | 114 | 15
Tennessee | 312.145893646529 | 95 | 34
Arkansas | 283.1521335552869 | 75 | 17
Colorado | 264.8473793475591 | 64 | 16
Oklahoma | 262.4666484496651 | 77 | 20
Iowa | 248.8896416118606 | 99 | 29
Oregon | 228.1122513673997 | 36 | 18
Kansas | 202.4469543453758 | 103 | 20
New Mexico | 202.1081708726665 | 33 | 9
South Carolina | 197.4019168919547 | 46 | 26
Alaska | 171.9302437702147 | 27 | 4
Hawaii | 171.8594537298531 | 5 | 5
Utah | 146.4173466883235 | 29 | 6
Nevada | 146.092768419409 | 17 | 3
Nebraska | 131.3181955874834 | 93 | 16
Delaware | 117.6701565096356 | 3 | 5
Maine | 104.3968447839554 | 16 | 14
Rhode Island | 86.43239372222516 | 5 | 8
Idaho | 85.67050242156533 | 44 | 9
Montana | 77.85876681692753 | 57 | 9
New Hampshire | 73.4864229696679 | 10 | 13
Wyoming | 66.81075940528135 | 23 | 1
Vermont | 65.03012962767303 | 14 | 14
North Dakota | 57.69276203594998 | 53 | 8
South Dakota | 49.27238827117637 |  | 11
Total
Spreadsheet: 126178d1319556859-populate-cells-in-different-worksheet-test
Sheet: Sheet2

Import Reference | Date Opened | Month | TYPE | Country of Origin | Container / AWB No | CAIRO | COST | No of Shipments | Sender | ID | Ingredient | Weight (KG) | Tariff Code | P/O No | [NAME] | Scheduler Name | Airfreight Reason | Clearance Agent | AGENT REF | Customs Charges | Freight Sea/Air | Freight Inland | Invoice Nr. | Handling Charges | Storage / Demurrage | Total | Delivery | Agent | Comments | 2010 price per kilo | 0.03
11-99-01 | 2011-10-25 00:00:00 | 10 | Sea | Argentina | 711760790 GATU0053648, TCLU2474706, BSIU2050543 |  |  | 4 | ABC | 9876    9875    9874    9873 |  | 320 |  | 123456                     123457                     123458             123459 |  |  |  | EXP |  |  |  |  |  |  |  |  | XYZ
Spreadsheet: 74739d1275271414-linking-multiple-variable-values-timber-cost-examples
Sheet: Sheet1

 |  | Timber length
 |  | 3 | 3.6 | 4.2 | 4.8 | 5.4
Timber types | 150 SED | 30 | 35 | 40 | 45 | 50
 | 175 SED | 55 | 60 | 65 | 70 | 75
 | 200 SED | 80 | 85 | 90 | 95 | 100
Spreadsheet: 866991d1713895170-summation-based-on-multiple-criterias-from-different-sheets-with-indirect-function-19042024-sample-file-for-xlforum-sanjuss2-
Sheet: report

Result |  |  |  |  |  |  | Current Sheet | 31032024
 | Class |  |  |  |  |  | Previous Sheet | 28022024
Migration of class | S1 | S2 | S3 | [NAME] | Total
From S1
From S2
From S3
From s4
Total Upgrade/Degrade
Conditions to be consider while calculation
1. Require data from Current sheet only i.e. in I2 & the summation of amount.
2. I can change current sheet & previous sheet as per requirement.
2. To compare current sheet with Previous sheet must consider (BrCd+PrCd+Acct+Class)
3. If BrCD+PrdCd+Acct+Class is not matched then calculate summation of amount of current sheet
4. Show the summation under the class specified in Current sheet.
5. This is movement of class register
6. See the colors in sheet 31032024
7. If account closed in previous sheet then whole amount must show in S1
Spreadsheet: 874632d1721195478-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime
Sheet: JM

Ticket Update DateTime | Ticket Solve DateTime | Expected Result | [NAME] result |  |  | Public Holiday |  | Start Hour | End Hour |  | First workday | Last workday | Minutes First Day | Minutes Last Day | Minutes Between |  | SLA (in minutes) Exclude non-working Days, Weekend & Public Holidays & specific Datetime (excelforum.com)
 |  | 5940 |  |  |  | 2024-06-03 00:00:00 |  | 09:00:00 | 18:00:00
 |  | 3670 |  |  |  | 2024-06-17 00:00:00
 |  | 9608
 |  | 4626
 |  | 8217
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
Spreadsheet: 839605d1692109332-filter-data-according-to-their-product-number-in-vertical-size-filter-data-according-their-product-number-in-vertical-size
Sheet: Sheet1

 | TIME | PRODUCT NO | PRICE 1
 | 2023-08-03 22:38:05.120000 | 19350 | 87
 | 2023-08-03 22:38:05.120000 | 19400 | 78
 | 2023-08-03 22:38:05.120000 | 19450 | 53 |  |  | Dear Expert Sir / Mam
 | 2023-08-03 22:38:05.120000 | 19500 | 90 |  |  | I have data in sheet 1. Column A contains product numbers and column B contains their prices.
 | 2023-08-03 22:38:05.120000 | 19550 | 72 |  |  | Data in Sheet1 is added every minute. Sheet1's data grows to around 20000 to 25000 thousand rows.
 | 2023-08-03 22:38:05.120000 | 19600 | 84 |  |  | I would like to filter the price of each product number in sheet 2 in a vertical size.
 | 2023-08-03 22:38:05.120000 | 19650 | 84 |  |  | For example, look at column B and column C in sheet 2.
 | 2023-08-03 22:38:05.120000 | 19700 | 99 |  |  | Please Provide formula.
 | 2023-08-03 22:38:05.120000 | 19750 | 77
 | 2023-08-03 22:38:05.120000 | 19800 | 86
 | 2023-08-03 22:39:05 | 19350 | 79
 | 2023-08-03 22:39:05 | 19400 | 80
 | 2023-08-03 22:39:05 | 19450 | 84
 | 2023-08-03 22:39:05 | 19500 | 73
 | 2023-08-03 22:39:05 | 19550 | 85
 | 2023-08-03 22:39:05 | 19600 | 67
 | 2023-08-03 22:39:05 | 19650 | 71
 | 2023-08-03 22:39:05 | 19700 | 55
 | 2023-08-03 22:39:05 | 19750 | 59
 | 2023-08-03 22:39:05 | 19800 | 50
 | 2023-08-03 22:40:05 | 19350 | 55
 | 2023-08-03 22:40:05 | 19400 | 78
 | 2023-08-03 22:40:05 | 19450 | 81
 | 2023-08-03 22:40:05 | 19500 | 54
 | 2023-08-03 22:40:05 | 19550 | 63
 | 2023-08-03 22:40:05 | 19600 | 53
 | 2023-08-03 22:40:05 | 19650 | 90
 | 2023-08-03 22:40:05 | 19700 | 75
 | 2023-08-03 22:40:05 | 19750 | 93
 | 2023-08-03 22:40:05 | 19800 | 90
 | 2023-08-03 22:41:05 | 19350 | 92
 | 2023-08-03 22:41:05 | 19400 | 69
 | 2023-08-03 22:41:05 | 19450 | 72
 | 2023-08-03 22:41:05 | 19500 | 98
 | 2023-08-03 22:41:05 | 19550 | 58
 | 2023-08-03 22:41:05 | 19600 | 60
 | 2023-08-03 22:41:05 | 19650 | 84
 | 2023-08-03 22:41:05 | 19700 | 84
 | 2023-08-03 22:41:05 | 19750 | 67
 | 2023-08-03 22:41:05 | 19800 | 88
 | 2023-08-03 22:42:05 | 19350 | 91
 | 2023-08-03 22:42:05 | 19400 | 99
 | 2023-08-03 22:42:05 | 19450 | 58
 | 2023-08-03 22:42:05 | 19500 | 62
 | 2023-08-03 22:42:05 | 19550 | 56
 | 2023-08-03 22:42:05 | 19600 | 94
 | 2023-08-03 22:42:05 | 19650 | 95
 | 2023-08-03 22:42:05 | 19700 | 80
 | 2023-08-03 22:42:05 | 19750 | 80
 | 2023-08-03 22:42:05 | 19800 | 85
 | 2023-08-03 22:43:05 | 19350 | 64
 | 2023-08-03 22:43:05 | 19400 | 95
 | 2023-08-03 22:43:05 | 19450 | 100
 | 2023-08-03 22:43:05 | 19500 | 85
 | 2023-08-03 22:43:05 | 19550 | 63
 | 2023-08-03 22:43:05 | 19600 | 62
 | 2023-08-03 22:43:05 | 19650 | 94
 | 2023-08-03 22:43:05 | 19700 | 93
 | 2023-08-03 22:43:05 | 19750 | 61
 | 2023-08-03 22:43:05 | 19800 | 66