tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109405d1306270671-excel-2007-slow-code-in-2007-should-look-like-this
Sheet: Sheet1

DFT | 6000 | ZA | GBP | MIKE | MIKE | 30.04.11 | 24.05.11 | 194069 | 63.33 | 40 |  |  |  | 600000 | MTA_0001 |  | 234
 |  |  |  |  |  |  |  | 194069 | 37.5 | 40 |  |  |  | 600000 |  |  | 250
 |  |  |  |  |  |  |  | 194069 | 31.25 | 40 |  |  |  | 600000 |  |  | 266
 |  |  |  |  |  |  |  | 194069 | 114.58 | 40 |  |  |  | 600000 |  |  | 282
 |  |  |  |  |  |  |  | 194069 | 10.41 | 40 |  |  |  | 600000 |  |  | 294
 |  |  |  |  |  |  |  | 194069 | 145.83 | 40 |  |  |  | 600000 |  |  | 310
 |  |  |  |  |  |  |  | 194069 | 79.16 | 40 |  |  |  | 600000 |  |  | 326
 |  |  |  |  |  |  |  | 194069 | 63.33 | 40 |  |  |  | 600000 |  |  | 342
 |  |  |  |  |  |  |  | 194069 | 114.58 | 40 |  |  |  | 600000 |  |  | 354
 |  |  |  |  |  |  |  | 194069 | 31.66 | 40 |  |  |  | 600000 |  |  | 370
 |  |  |  |  |  |  |  | 194069 | 174.16 | 40 |  |  |  | 600000 |  |  | 386
 |  |  |  |  |  |  |  | 194069 | 10.41 | 40 |  |  |  | 600000 |  |  | 402
 |  |  |  |  |  |  |  | 194069 | 145.83 | 40 |  |  |  | 600000 |  |  | 418
 |  |  |  |  |  |  |  | 194069 | 37.5 | 40 |  |  |  | 600000 |  |  | 430
 |  |  |  |  |  |  |  | 194069 | 31.25 | 40 |  |  |  | 600000 |  |  | 446
 |  |  |  |  |  |  |  | 194069 | 114.58 | 40 |  |  |  | 600000 |  |  | 462
 |  |  |  |  |  |  |  | 194069 | 31.66 | 40 |  |  |  | 600000 |  |  | 478
 |  |  |  |  |  |  |  | 194069 | 145.83 | 40 |  |  |  | 600000 |  |  | 490
 |  |  |  |  |  |  |  | 194069 | 79.16 | 40 |  |  |  | 600000 |  |  | 506
 |  |  |  |  |  |  |  | 194069 | 63.33 | 40 |  |  |  | 600000 |  |  | 522
 |  |  |  |  |  |  |  | 194069 | 37.5 | 40 |  |  |  | 600000 |  |  | 538
 |  |  |  |  |  |  |  | 194069 | 31.25 | 40 |  |  |  | 600000 |  |  | 554
 |  |  |  |  |  |  |  | 194069 | 174.16 | 40 |  |  |  | 600000 |  |  | 566
 |  |  |  |  |  |  |  | 194069 | 10.41 | 40 |  |  |  | 600000 |  |  | 582
 |  |  |  |  |  |  |  | 194069 | 145.83 | 40 |  |  |  | 600000 |  |  | 598
 |  |  |  |  |  |  |  | 194069 | 79.16 | 40 |  |  |  | 600000 |  |  | 614
 |  |  |  |  |  |  |  | 194069 | 31.25 | 40 |  |  |  | 600000 |  |  | 626
 |  |  |  |  |  |  |  | 194069 | 114.58 | 40 |  |  |  | 600000 |  |  | 642
 |  |  |  |  |  |  |  | 194069 | 31.66 | 40 |  |  |  | 600000 |  |  | 658
 |  |  |  |  |  |  |  | 194069 | 79.16 | 40 |  |  |  | 600000 |  |  | 674
 |  |  |  |  |  |  |  | 194069 | 63.33 | 40 |  |  |  | 600000 |  |  | 690
 |  |  |  |  |  |  |  | 194069 | 114.58 | 40 |  |  |  | 600000 |  |  | 702
 |  |  |  |  |  |  |  | 194069 | 31.66 | 40 |  |  |  | 600000 |  |  | 718
 |  |  |  |  |  |  |  | 194069 | 174.16 | 40 |  |  |  | 600000 |  |  | 734
 |  |  |  |  |  |  |  | 194069 | 10.41 | 40 |  |  |  | 600000 |  |  | 750
 |  |  |  |  |  |  |  | 541032 | 2654.439999999999 | 50 | 600000 |  |  | 600000 |  |  | [NAME]
Spreadsheet: 22799d1211957466-updating-contents-of-one-worksheet-based-on-criteria-in-another-worksheet-book2-1-
Sheet: Sheet1

Salutation | Customer ID | Forename | Surname | 1st Address
Miss | 275290 | [NAME] | [NAME] | 29 Royal Road
Mr | 9564 | [NAME] | Arne-Rise | 65 Halton Road
Miss | 3335 | [NAME] | Batt | 90 Hollyoaks
Mrs | 338546 | [NAME] | Beale | 10 Moor Lane
Mr | 45334 | [NAME] | Bell | 23 Main Street
Miss | 643 | y | Cleves | 332 Low Road
0 | 23452 | Will | Keating | 2 The Copse
Mrs | 75345 | A. | Kenwright | 207 East Avenue
Mr | 23489 | [NAME] | Littleton | 4 Long Marsh
0 | 6675 | Leanne | Moore | 49 Kiln Road
Miss | 87877 |  | [NAME] | 43 Bryony Close
0 | 765335 | [NAME] | Norton | 10 The Birches
Miss | 555 | [NAME] | Shostakova | 18 Crossley Drive
Mrs | 12 | Kath | Sparrow | 99 Telford Rise
Mrs | 67456 | Carol | [NAME] | 101 Central Drive
Spreadsheet: 713057d1610542418-sum-number-s-from-part-of-cell-value-plantsalesformulae1
Sheet: Sheet1

Submission Date | Basil £1.25 ea | Coriander £1.25 ea | Mint £1.25 ea | Parsley Curly £1.25 ea | Parsley Flat £1.25 ea | Tomato Red Alert £1.50 ea
2021-01-10 14:45:20
2021-01-10 15:36:39
2021-01-10 16:48:45
2021-01-10 17:35:00 | Basil [1] | Coriander [2] |  |  |  | Tomato Red Alert [1]
2021-01-10 19:50:14 | Basil [1] | Coriander [1] |  | Parsley Curly [1]
2021-01-10 20:49:08 | Basil [2] | Coriander [3] |  |  | Parsley Flat [1]
2021-01-10 21:19:30 | Basil [1] | Coriander [1] |  | Parsley Curly [1] | Parsley Flat [1]
2021-01-11 11:36:48 | Basil [1] |  | Mint [1] |  | Parsley Flat [1]
2021-01-11 11:43:25 | Basil [1] |  | Mint [2] |  | Parsley Flat [1] | Tomato Red Alert [2]
2021-01-11 11:56:36 | Basil [1] | Coriander [1]
2021-01-11 12:06:19 | Basil [1] |  |  | Parsley Curly [1] |  | Tomato Red Alert [1]
2021-01-11 12:16:19 | Basil [1] | Coriander [1] |  | Parsley Curly [2]
2021-01-11 12:45:44 |  |  |  |  | Parsley Flat [4]
2021-01-11 13:11:26 | Basil [1] |  |  |  | Parsley Flat [1]
2021-01-11 13:42:27
2021-01-11 14:45:17
2021-01-11 15:56:04 | Basil [1] | Coriander [1] |  |  |  | Tomato Red Alert [3]
2021-01-11 17:41:37
2021-01-11 18:36:37
2021-01-11 22:29:18
2021-01-12 09:21:34 |  |  |  | Parsley Curly [1] |  | Tomato Red Alert [1]
2021-01-12 11:39:01 | Basil [2] | Coriander [2] | Mint [1] |  | Parsley Flat [2]
2021-01-12 14:04:21 |  |  |  | Parsley Curly [2] | Parsley Flat [2]
2021-01-12 16:47:46
2021-01-12 22:54:35 | Basil [2]
2021-01-12 23:19:08 |  |  |  | Parsley Curly [1]
2021-01-13 09:47:52 |  |  |  | Parsley Curly [1]
2021-01-13 10:11:08 | Basil [1] | Coriander [1] |  | Parsley Curly [1] | Parsley Flat [1] | Tomato Red Alert [2]
Spreadsheet: 033cca33-53f9-489b-94e2-0eff8dee055d
Sheet: Sheet1

 | GRADUATE MEDICAL EDUCATION EDUCATIONAL SUPPORT FUNDS REIMBURSEMENT
 | **Income tax will be charged at the time of reimbursement.
 | Employee Name: |  |  |  |  |  |  |  | Extension:
 | Address: |  |  |  |  |  |  |  | [NAME] ID:
 | City/State/Zip: |  |  |  |  |  |  |  | PSU ID:
 | Department: |  |  |  |  |  |  |  | Mail Code:
 | My signature below certifies that the following expenses are true and accurate. The cost center(s) and account number(s) are correct and reasonable and that reimbursement/settlement has not been requested or received from another source. I understand that any reimbursement made where the item is interpreted by the IRS as “common or listed property,” will be reported as taxable income. I attest that the program pre-approved this expense.  By signing this form, I understand that sensitive patient data should not be stored on the device.
 | Employee Signature |  |  |  | Date
 | Expense Information
 | Cost Center: |  |  |  |  | Expense Code: |  | 690240 [NAME]
 |  |  |  |  |  |  |  |  | Amount: |  | $
 | Explanation/Reason for Expense:
 | (Detailed receipt MUST be attached.)
 | Approvals
 | **By signing this form, you verify that the above named has sufficient GME Educational Support Fund dollars allotted for reimbursement of this expense.
 | Cost Center Manager: |  |  |  |  |  |  | Program Director or Coordinator:
 | Print Name |  |  |  |  |  |  | Print Name
 | Signature* |  |  | Date |  |  |  | Signature |  |  | Date
 | Send completed forms to: |  |  | [NAME]
 |  |  |  | Graduate Medical Education H088
Spreadsheet: 885941d1735871973-common-formula-for-different-cases-common-formula-needed
Sheet: Sheet1

 | CASE - 1 | 698013
 |  | 466394
 | CASE - 2 | 466394
 |  | 698013
 | CASE - 3 | 698013
 |  | 0
 | CASE - 4 | 0
 |  | 698013
Spreadsheet: 850135d1700515137-wrong-sum-up-values-from-a-range-with-xlookup-and-index-match-formula-overtime-blank-format-2017-2-
Sheet: Sheet5

Ser | Day | Date | IN | OUT | Public Holiday | on Leave | off Day | Work Day
4192 |  | 2023-10-01 00:00:00 | 16:30:00 | 16:51:49 |  |  |  | 00:21:49
4192 |  | 2023-10-02 00:00:00 | 16:30:00 | 16:48:40 |  |  |  | 00:18:40
4192 |  | 2023-10-04 00:00:00 | 16:30:00 | 18:37:28 |  |  |  | 02:07:28
4192 |  | 2023-10-05 00:00:00 | 16:30:00 | 18:58:33 |  |  |  | 02:28:33
4192 |  | 2023-10-08 00:00:00 | 16:30:00 | 17:56:09 |  |  |  | 01:26:09
4192 |  | 2023-10-09 00:00:00 | 16:30:00 | 18:33:13 |  |  |  | 02:03:13
4192 |  | 2023-10-10 00:00:00 | 16:30:00 | 18:55:51 |  |  |  | 02:25:51
4192 |  | 2023-10-11 00:00:00 | 16:30:00 | 19:39:17 |  |  |  | 03:09:17
4192 |  | 2023-10-13 00:00:00 | 10:23:19 | 17:47:45 |  |  | 07:24:26 | 07:24:26
4192 |  | 2023-10-14 00:00:00 | 09:59:12 | 21:15:49 |  |  | 11:16:37 | 11:16:37
4192 |  | 2023-10-15 00:00:00 | 16:30:00 | 16:37:36 |  |  |  | 00:07:36
4192 |  | 2023-10-16 00:00:00 | 16:30:00 | 17:28:17 |  |  |  | 00:58:17
4192 |  | 2023-10-17 00:00:00 | 16:30:00 | 19:00:58 |  |  |  | 02:30:58
4192 |  | 2023-10-18 00:00:00 | 16:30:00 | 19:05:59 |  |  |  | 02:35:59
4192 |  | 2023-10-19 00:00:00 | 16:30:00 | 18:55:16 |  |  |  | 02:25:16
4192 |  | 2023-10-29 00:00:00 | 16:30:00 | 17:55:42 |  |  |  | 01:25:42
4192 |  | 2023-10-30 00:00:00 | 16:30:00 | 18:20:56 |  |  |  | 01:50:56
4192 |  | 2023-10-31 00:00:00 | 16:30:00 | 19:00:12 |  |  |  | 02:30:12
8754 |  | 2023-10-01 00:00:00 | 16:30:00 | 16:51:49 |  |  |  | 0.31.25
8754 |  | 2023-10-02 00:00:00 | 16:30:00 | 16:48:40 |  |  |  | 0.32.12
8754 |  | 2023-10-04 00:00:00 | 16:30:00 | 18:37:28 |  |  |  | 02:07:28
8754 |  | 2023-10-05 00:00:00 | 16:30:00 | 18:58:33 |  |  |  | 02:28:33
8754 |  | 2023-10-08 00:00:00 | 16:30:00 | 17:56:09 |  |  |  | 01:26:09
8754 |  | 2023-10-09 00:00:00 | 16:30:00 | 18:33:13 |  |  |  | 02:03:13
8754 |  | 2023-10-10 00:00:00 | 16:30:00 | 18:55:51 |  |  |  | 02:25:51
8754 |  | 2023-10-11 00:00:00 | 16:30:00 | 19:39:17 |  |  |  | 03:09:17
8754 |  | 2023-10-13 00:00:00 | 10:23:19 | 17:47:45 |  |  | 07:24:26
8754 |  | 2023-10-14 00:00:00 | 09:59:12 | 21:15:49 |  |  | 11:16:37
8754 |  | 2023-10-15 00:00:00 | 16:30:00 | 16:37:36 |  |  |  | 00:07:36
8754 |  | 2023-10-16 00:00:00 | 16:30:00 | 17:28:17 |  |  |  | 00:58:17
8754 |  | 2023-10-17 00:00:00 | 16:30:00 | 19:00:58 |  |  |  | 02:30:58
8754 |  | 2023-10-18 00:00:00 | 16:30:00 | 19:05:59 |  |  |  | 02:35:59
8754 |  | 2023-10-19 00:00:00 | 16:30:00 | 18:55:16 |  |  |  | 02:25:16
8754 |  | 2023-10-29 00:00:00 | 16:30:00 | 17:55:42 |  |  |  | 01:25:42
8754 |  | 2023-10-30 00:00:00 | 16:30:00 | 18:20:56 |  |  |  | 01:50:56
8754 |  | 2023-10-31 00:00:00 | 16:30:00 | 19:00:12 |  |  |  | 02:30:12
Spreadsheet: fc379ac5-02f0-4054-a3df-6247a9ee4799
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FCUIP | Test | FCUIP | CU Index Panel | CU (Chronic Urticaria) Index Panel | Ex Vivo Challenge, Cell Culture and Histamine Analysis | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain, red-top tube(s). Allow to clot; then spin down and separate. Submit 3 mL serum refrigerated in a plastic vial.   Note:	1) Patients taking calcineurin inhibitors should stop medication 72 hours prior to draw.  	2) Patients taking prednisone should be off their medication 2 weeks prior to draw. | 1.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | Anti-Thyroid Peroxidase IgG:	<35 IU/mL Anti-Thyroglobulin IgG:		<40 IU/mL TSH (Thyrotropin):		0.4 - 4.0 uIU/mL CU Index:			<10.0  The CU Index test is the second generation Functional Anti-FceR test.  Patients with a CU Index greater than or equal to 10 have basophil reactive factors in their serum which supports and autoimmune basis for disease.  Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday, Wednesday, Friday | 2 - 5 days | 4 - 9 days |  | Profile |  |  |  |  | Viracor-IBT Laboratories
FCUIP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
FCUIP | Result | Z3144 | Anti-Thyroid Peroxidase IgG | Anti-Thyroid Peroxidase IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCUIP | Result | Z3145 | Anti-Thyroglobulin IgG | Anti-Thyroglobulin IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCUIP | Result | [NAME] | TSH (Thyrotropin) | TSH (Thyrotropin) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCUIP | Result | Z3147 | CU Index | CU Index | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCUIP | Billing Component | FCUIP |  | THYROGLOBULIN ANTIBODY |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86800
FCUIP | Billing Component | FCUIP |  | MICROSOMAL ANTIBODY EACH |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86376
FCUIP | Billing Component | FCUIP |  | CELL FUNCTION ASSAY W/STIM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86352
FCUIP | Billing Component | FCUIP |  | ASSAY THYROID STIM HORMONE |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84443
Spreadsheet: 787508d1657822786-calculating-commission-with-multiple-hurdles-example-file
Sheet: Sheet1

Invoice | Total Rev | Comp |  | Hurdle %
1 | 300000 |  |  | 40% up to $1 million
2 | 200000 |  |  | 45% $1M-$2M
3 | 300000 |  |  | 50% $2M - $3M
4 | 100000 |  |  | 55% over $3M
5 | 500000
6 | 2000000
7 | 150000
8 | 200000
9 | 300000
10 | 500000
Spreadsheet: 878362d1725438238-find-min-and-max-date-for-each-vehicle-inspection-when-there-are-several-dates-laura
Sheet: Sheet1

Number | Task | Date | Month | Year | Month year | Unique Month year | Month | Year | Number | Min | [NAME]
15787987 | Inspection | 2022-09-01 00:00:00
15787987 | Inspection | 2022-09-02 00:00:00 |  |  |  | 15787987;10;2023 | 10 | 2023 | 15787987
15787987 | Inspection | 2022-09-03 00:00:00 |  |  |  | 15787987;10;2019 | 10 | 2019 | 15787987
15787987 | Inspection | 2022-09-04 00:00:00 |  |  |  | 45484848;9;2018 | 9 | 2018 | 45484848
15787987 | Inspection | 2022-09-05 00:00:00 |  |  |  | 45484848;10;2017 | 10 | 2017 | 45484848
15787987 | Inspection | 2023-10-01 00:00:00 |  |  |  | 45484848;6;2016 | 6 | 2016 | 45484848
15787987 | Inspection | 2023-10-02 00:00:00
15787987 | Inspection | 2019-10-10 00:00:00
15787987 | Inspection | 2019-10-11 00:00:00
15787987 | Inspection | 2019-10-12 00:00:00
45484848 | Inspection | 2018-09-04 00:00:00
45484848 | Inspection | 2018-09-05 00:00:00
45484848 | Inspection | 2017-10-01 00:00:00
45484848 | Inspection | 2017-10-02 00:00:00
45484848 | Inspection | 2016-06-13 00:00:00
45484848 | Inspection | 2016-06-14 00:00:00
45484848 | Inspection | 2016-06-15 00:00:00
45484848 | Inspection | 2016-06-16 00:00:00
45484848 | Inspection | 2016-06-16 00:00:00
Spreadsheet: 65641d1266343317-understanding-how-this-factor-is-calculated-how-factor-is-calculated-improved
Sheet: temp correction

 | Temp | 17.362
 | Correction
 | Corr. Curve
 | Temp(x) | °C | 34 | 33 | 32 | 31 | 30.5 | 30 | 29 | 28 | 27 | 26 | 25.5 | 25 | 24.5 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9
 | correction(y) |  | 1.06280243421613 | 1.05578615902926 | 1.04845588806701 | 1.031183997383186 | 1.02672070094287 | 1.024371308378185 | 1.018050188986899 | 1.012286214789809 | 1.007537943660338 | 1.003333588006641 | 1.001608009951706 | 1 | 0.9985100709248589 | 0.9971381872245121 | 0.9949642081103467 | 0.9931632199585045 | 0.9920123670164718 | 0.9910714566903372 | 0.9903306406956988 | 0.9897784582534002 | 0.9894019927724257 | 0.989146630000986 | 0.9889225320010581 | 0.9887225282984441 | 0.9885237776015761 | 0.9883113668162781 | 0.988078311045766 | 0.987825553590648 | 0.9875619659489241
Spreadsheet: 90211d1289962437-data-all-over-the-sheet-to-be-cleaned-example
Sheet: Pivot Table

Sum of Amount | Group
Number | AAA | BBB | CCC | DDD | Grand Total
111111111 | 500 |  | 1000 | 500 | 2000
222222222 | 400 |  | 800 | 400 | 1600
333333333 | 255 |  | 510 | 255 | 1020
444444444 | 200 |  | 200 |  | 400
555555555 | 300 |  | 300 |  | 600
666666666 | 700 | 6854 | 700 | 6854 | 15108
777777777 | 200 | 400 | 200 | 400 | 1200
888888888 | 400 | 954 | 400 | 954 | 2708
999999999 | 255 | 510 | 255 | 510 | 1530
Grand Total | 3210 | 8718 | 4365 | 9873 | 26166
Spreadsheet: 103708d1301436559-count-conditional-formatted-cells-2-example-wkbook
Sheet: Sheet2

Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | BONUS
1982-06-12 00:00:00
1982-06-19 00:00:00
1982-06-26 00:00:00
1982-07-03 00:00:00
1982-07-10 00:00:00
1982-07-17 00:00:00
1982-07-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 7 | 19 | 24 | 34 | 42
1982-07-31 00:00:00
1982-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 11 | 13 | 14
1982-08-14 00:00:00
1982-08-21 00:00:00
1982-08-28 00:00:00
1982-09-04 00:00:00
1982-09-11 00:00:00
1982-09-18 00:00:00
1982-09-25 00:00:00
1982-10-02 00:00:00
1982-10-09 00:00:00
1982-10-16 00:00:00
1982-10-23 00:00:00
1982-10-30 00:00:00
1982-11-06 00:00:00
1982-11-13 00:00:00
1982-11-20 00:00:00
1982-11-27 00:00:00
1982-12-04 00:00:00
1982-12-11 00:00:00
1982-12-18 00:00:00
1982-12-25 00:00:00
1983-01-01 00:00:00
1983-01-08 00:00:00
1983-01-15 00:00:00
1983-01-22 00:00:00
1983-01-29 00:00:00
1983-02-05 00:00:00
1983-02-12 00:00:00
1983-02-19 00:00:00
1983-02-26 00:00:00
1983-03-05 00:00:00
1983-03-12 00:00:00
1983-03-19 00:00:00
1983-03-26 00:00:00
1983-04-02 00:00:00
1983-04-09 00:00:00
1983-04-16 00:00:00
1983-04-23 00:00:00
1983-04-30 00:00:00
1983-05-07 00:00:00
Spreadsheet: 267393f4-b755-4de9-a298-4a159cf68a46
Sheet: Table 2June2013

Table 2.  Quarterly costs of transporting Brazilian soybeans to Hamburg, Germany
 | 2013      1st qtr | 2013    2nd qtr | Average Jan-June |  | % Change | 2013      1st qtr | 2013    2nd qtr | Average Jan-June |  | % Change
 |  |  | 2012 | 2013 |  |  |  | 2012 | 2013
 | [NAME]                                                                          --US$/mt-- |  |  |  |  | Northwest RS1 - Rio Grande2                                              --US$/mt--
Truck | 124.0323831540148 | 112.3847368149359 | 113.7945948683853 |  |  | 25.9605259048745 | 23.96061107531101 | 26.64220163851658
Ocean | 30 | 29 | 33.5 |  |  | 30 | 29 | 34.29
Total transportation | 154.0323831540148 | 141.3847368149359 | 147.2945948683853 |  |  | 55.9605259048745 | 52.96061107531101 | 60.93220163851657
Farm price3 | 419.3474275143831 | 391.5827767203564 | 412.9965152397739 |  |  | 460.1310844536767 | 459.9638523671281 | 426.7675408588689
Landed cost | 573.3798106683978 | 532.9675135352923 | 560.2911101081593 |  |  | 516.0916103585513 | 512.9244634424391 | 487.6997424973855
Transport % of landed cost | 26.86393561267126 | 26.52783391563577 | 26.40434969748392 |  |  | 10.84313807503987 | 10.32522619800026 | 12.50680158179743
 | North Center PR1 - Paranagua2                                                  --US$/mt-- |  |  |  |  | South GO1 - Santos2                                                              --US$/mt--
Truck | 37.03577485141204 | 35.62321249951808 | 34.38951309740222 |  |  | 59.14184864322448 | 57.40002101401112 | 55.4647694790675
Ocean | 30 | 29 | 33.29 |  |  | 30 | 29 | 33.5
Total transportation | 67.03577485141204 | 64.62321249951808 | 67.67951309740222 |  |  | 89.14184864322448 | 86.40002101401112 | 88.96476947906748
Farm price3 | 476.2183622450593 | 461.969780836477 | 452.2424698801404 |  |  | 445.5639926271772 | 419.6164038972868 | 414.9872945563532
Landed cost | 543.2541370964714 | 526.5929933359951 | 519.9219829775426 |  |  | 534.7058412704017 | 506.0164249112979 | 503.9520640354206
Transport % of landed cost | 12.33967130185109 | 12.27194689586098 | 13.03480126834488 |  |  | 16.67119409644625 | 17.07454872223893 | 17.66941124119656
1Producing regions: RS = Rio Grande Do Sul, MT= [NAME], GO = Goiás, PR = Paraná
2Export ports
3Source: Companhia Nacional de Abastecimento (CONAB) www.conab.gov.br
Source: ESALQ/ USP (University of São Paulo, Brazil) and USDA/AMS
Spreadsheet: 300012d1393351746-count-unique-values-across-multiple-sheets-based-on-date-book1_sample
Sheet: A Codes

2014-02-02 00:00:00 | 16 | Day | Indian | Booked | 02084876 | 004753 | Consultant | 13839 - 00 | 1858
2014-02-02 00:00:00 | 16 | Day | Indian | Booked | 01965933 | 004753 | Consultant | 13839 - 00 | 1858
2014-02-02 00:00:00 | 16 | Day | Qatari | Booked | 00237805 | 004753 | Consultant
2014-02-02 00:00:00 | 16 | Day | Uzbekistan | Booked | 02466398 | 004753 | Consultant
2014-02-02 00:00:00 | 16 | Day | Filipino | Booked | 00364068 | 004753 | Consultant
2014-02-02 00:00:00 | 16 | Day | Yemeni | Booked | 00078391 | 004753 | Consultant | 13839 - 00 | 1858
2014-02-02 00:00:00 | 16 | Day | Pakistani | Booked | 01953150 | 004753 | Consultant
2014-02-03 00:00:00 | 16 | Day | Iran | Booked | 00061956 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Egyptian | Booked | 00069078 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | USA | Booked | 02084876 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Sudanese | Booked | 00237805 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Egyptian | Booked | 02934677 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Yemeni | Booked | 02249288 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Spanish | Booked | 02281650 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Egyptian | Booked | 02963170 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Iran | Booked | 02084876 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Qatari | Booked | 00237805 | 004753 | Consultant | 13839-00 | 1858
2014-02-03 00:00:00 | 16 | Day | Qatari | Booked | 00034469 | 004753 | Consultant | 13839-00 | 1858
2014-02-04 00:00:00 | 16 | Day | Pakistani | Booked | 02084876 | 004753 | Consultant | 13839 - 00 | 1858
2014-02-04 00:00:00 | 16 | Day | Egyptian | Booked | 00113202 | 004753 | Consultant | 13839 - 00 | 1858
2014-02-04 00:00:00 | 16 | Day | Qatari | Booked | 00122056 | 004753 | Consultant | 13839 - 00 | 1858
2014-02-04 00:00:00 | 16 | Day | Egyptian | Booked | 02084876 | 004753 | Consultant | 13839 - 00 | 1858
2014-02-04 00:00:00 | 16 | Day | Iranian | Booked | 00230567 | 004753 | Consultant | 13839 - 00 | 1858
Spreadsheet: 586589d1534450789-copy-data-from-one-excel-sheet-to-another-if-a-value-is-present-only-from-drop-down-list-sample-of-billing-matrix
Sheet: ATT

DATE | COMPANY | TOTAL COUNT | 1 COUNT | 1 AMOUNT | 2 COUNT | 2 AMOUNT | 3 COUNT | 3 AMOUNT | 4 COUNT | 4 AMOUNT | 5 COUNT | 5 AMOUNT | 6 COUNT | 6 AMOUNT | TOTAL AMOUNT
2018-08-01 00:00:00 | 1 - ATT | 550 | 350 | 35000 | 200 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 53000
2018-08-02 00:00:00 | 1 - ATT | 555 | 350 | 35000 | 200 | 18000 | 5 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 53400
2018-08-03 00:00:00 | 1 - ATT | 550 | 350 | 35000 | 200 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 53000
Spreadsheet: 875871d1722503027-can-you-please-help-to-find-the-value-using-date-book2
Sheet: Sheet1

SAL APR'24 | 802.6000000000001 | DATE | 2024-07-31 00:00:00 |  | LOOKUP FOR DATE FROM D6 FROM THAT DATE FIND MONTH AND RELEVANT TO THAT MONTH FIND VALUE FROM AN ARRAY FROM A6 TO B17
SAL MAY'24 | 2092.8
SAL JUN'24 | 2349.87
SAL JUL'24 | 1612.1
SAL AUG'24 | 0
SAL SEP'24 | 0
SAL OCT'24 | 0
SAL NOV'24 | 0
SAL DEC'24 | 0
SAL JAN'25 | 0
SAL FEB'25 | 0
SAL MAR'25 | 0
Spreadsheet: 844296d1696008753-some-excel-tasks-forecast-and-demand-tasks
Sheet: Zad.1

Zad.1 | Based on the image below, do the same formatting for line 10-13
*Item code | Description | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | 2022-02-17 00:00:00 | 2022-02-18 00:00:00
36147 | Lay's paprika 40g_57848 | 297131 | 139090 | 86126.00000000003 | 86126.00000000003
36312 | Lay's green onion 40g_68084 | 513399 | -356089 | -217346 | -185842
36149 | Lay's fromage 40g_57848 | 38570 | 283927 | 283927 | 283927
 |  |  |  |  |  | A