tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d1d06ae0-7117-423a-9dd5-963c8d2f3790
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
6MAMU | Test | 6MAMU | 6-Monoacetylmorphine (6-MAM), [NAME] | 6-MAM, U | 6MAMU/89605: Gas Chromatography-Mass Spectrometry (GC-MS) ADULT/29345: Spectrophotometry (SP) |  |  |  |  |  | Container/Tube: Plastic, 60-mL urine bottle [NAME]: 20 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative.  Additional Information: For situations where chain-of-custody is required, a Chain-of-Custody Kit (Supply T282) is available. For chain-of-custody information, see COCH / Chain-of-Custody Processing. | 2.1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative Positives are reported with a quantitative GC-MS result. [NAME] concentrations: 6-MAM <5 ng/mL | Wednesday, Sunday | 2 days | 6 days | 1 | 83925 |  |  |  |  | Rochester
6MAMU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
6MAMU | Result | 30983 | 6-Monoacetylmorphine by GC/MS | 6-Monoacetylmorphine by GC/MS | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 10975-1 | 6-Monoacetylmorphine:MCnc:Pt:[NAME]:Qn:
6MAMU | Result | 29898 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
6MAMU | Result | 29899 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
6MAMU | [NAME] | ADULT | Adulterants Survey, [NAME] | Adulterants Survey, U |  |  |  |  |  |  | This test is only orderable as a reflex. |  |  |  | Monday through Sunday | Same day/1 day | 2 days |  |  |  |  | Yes | No
ADULT | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
ADULT | Result | 20606 | Creatinine, U | Creatinine, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
ADULT | Result | 22312 | Specific Gravity | Specific Gravity | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5811-5 | Specific gravity:Rden:Pt:[NAME]:Qn:Test strip
ADULT | Result | 23509 | pH | pH | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2756-5 | pH:LsCnc:Pt:[NAME]:Qn:
ADULT | Result | 23511 | Oxidants | Oxidants | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
ADULT | Result | 23510 | Nitrites | Nitrites | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 32710-6 | Nitrite:ACnc:Pt:[NAME]:[NAME]:
ADULT | Result | 30914 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
Spreadsheet: 839707d1692176015-sumproduct-sum-from-multiple-sheets-depending-on-specific-month-file
Sheet: 3

3 |  | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY
 |  | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals
 |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312
Opening |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 776696d1649860407-find-product-id-and-name-from-barcode-book-4
Sheet: Sheet1

 | Barcode | Product ID | Product Name (英) | Product Name (中)
 | 1
 | 11
 | 111
 | 1111
 | 11111
 | test
 | test2
Spreadsheet: d1373407-a31e-4e22-b0f7-b020ec805762
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Distribution Rec | 9781933876061 | [NAME] | Living With Unmet Desires | 2009-10-26 | Paperback Book | Ac | 14.95 | N | To Be Retired
Word Distribution Rec | 9780615538259 | [NAME] | Encountering Healing Power Of Forgiveness | 2011-11-08 | Paperback Book | Insp | 14.95 | N | To Be Retired
Spreadsheet: 864358d1711557799-the-solution-for-displaying-several-different-descriptions-and-codes-of-the-same-part-numb-test-ordera
Sheet: KAM

PID | Projekat | KAM
1002 | General - Learning Project | Nikola Veselinović
1073 | Bojan Vasiljević - Presales - SERVICE | Bojan Vasiljević
1085 | Dušan Milunović - Presales - SERVICE | Dušan Milunović
1106 | [NAME] | [NAME]
1126 | [NAME] | [NAME]
1146 | [NAME] | [NAME]
1177 | [NAME] | [NAME]
1187 | Nikola Simić - Presales - SERVICE | Nikola Simić
1198 | [NAME] | [NAME]
Spreadsheet: 150423d1334521599-auto-populating-a-calendar-based-on-two-variables-training-plan
Sheet: April

EE Division Short Range Training Plan |  |  |  |  |  |  |  | 2012-04-01 00:00:00
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 | 2012-04-01 00:00:00 |  | 2012-04-02 00:00:00 |  | 2012-04-03 00:00:00 |  | 2012-04-04 00:00:00 |  | 2012-04-05 00:00:00 |  | 2012-04-06 00:00:00 |  | 2012-04-07 00:00:00
Topic Name
Topic Number
Presenter
Integration
 | 2012-04-08 00:00:00 |  | 2012-04-09 00:00:00 |  | 2012-04-10 00:00:00 |  | 2012-04-11 00:00:00 |  | 2012-04-12 00:00:00 |  | 2012-04-13 00:00:00 |  | 2012-04-14 00:00:00
Topic Name
Topic Number
Presenter
Integration
 | 2012-04-15 00:00:00 |  | 2012-04-16 00:00:00 |  | 2012-04-17 00:00:00 |  | 2012-01-18 00:00:00 |  | 2012-04-19 00:00:00 |  | 2012-04-20 00:00:00 |  | 2012-04-21 00:00:00
Topic Name
Topic Number
Presenter
Integration
 | 2012-04-22 00:00:00 |  | 2012-04-23 00:00:00 |  | 2012-04-24 00:00:00 |  | 2012-04-25 00:00:00 |  | 2012-04-26 00:00:00 |  | 2012-04-27 00:00:00 |  | 2012-04-28 00:00:00
Topic Name
Topic Number
Presenter
Integration
 | 2012-04-29 00:00:00 |  | 2012-04-30 00:00:00
Topic Name
Topic Number
Presenter
Integration
 |  |  |  |  |  | Submitted: |  |  |  | Reviewed:
Topic Name |  |  |  |  |  |  | Training Petty Officer |  |  |  | Division LCPO
Topic Number
Presenter |  |  |  |  |  | Reviewed: |  |  |  | Approved:
Integration |  |  |  |  |  |  | Division Officer |  |  |  | Department Head
Spreadsheet: 64273d1265141248-search-tabs-and-return-results-kc_environmental_aspects-1-
Sheet: Process - Activity 6

Operating Condition | Process Evaluated | Cafeteria | Date |  |  | Enter Date |  | Team | 0
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0 | 6 | Yes
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
Spreadsheet: 814290d1674257601-look-up-same-requirements-output-different-results-automation-test-real-world
Sheet: Schedule

2022-06-12 00:00:00 | Sunday | D22550
2022-06-13 00:00:00 | Monday | Prep: |  |  | Notes
2022-06-14 00:00:00 | Tuesday |  |  |  | Here, we would like the name from "Source" to fill into D4, D5, and D6 using the date from [NAME] and the activity from C4:C6
2022-06-15 00:00:00 | Wednesday | Lead Trip
2022-06-16 00:00:00 | Thursday | Lead Trip
2022-06-17 00:00:00 | Friday | Lead Trip
2022-06-18 00:00:00 | Saturday
2022-06-19 00:00:00 | Sunday
2022-06-20 00:00:00 | Monday
2022-06-21 00:00:00 | Tuesday
2022-06-22 00:00:00 | Wednesday
2022-06-23 00:00:00 | Thursday
2022-06-24 00:00:00 | Friday
2022-06-25 00:00:00 | Saturday
2022-06-26 00:00:00 | Sunday
2022-06-27 00:00:00 | Monday | Prep Trip: |  |  | Notes
2022-06-28 00:00:00 | Tuesday |  |  |  | Same as above, but now [NAME]:D20 will look at the date on A17 and the actvity from C18:C20
2022-06-29 00:00:00 | Wednesday | Lead Trip
2022-06-30 00:00:00 | Thursday | Lead Trip
2022-07-01 00:00:00 | Friday | Lead Trip
2022-07-02 00:00:00 | Saturday
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: CPSC

Old course number | New course number
CPSC-305 | CPSC-2005
CPSC-310 | [NAME]
CPSC-312 | CPSC-3112
CPSC-320 | CPSC-3120
CPSC-321 | CPSC-3121
CPSC-330 | CPSC-3130
CPSC-342 | CPSC-3142
CPSC-343 | CPSC-3143
CPSC-345 | CPSC-3145
CPSC-351 | CPSC-3151
CPSC-365 | CPSC-3265
CPSC-390 | CPSC-4190
CPSC-405 | CPSC-4205
CPSC-415 | CPSC-3415
CPSC-435 | CPSC-4335
CPSC-437 | CPSC-4137
CPSC-438 | CPSC-4338
CPSC-441 | CPSC-4341
CPSC-442 | CPSC-4342
CPSC-445 | CPSC-4345
CPSC-446 | CPSC-4346
CPSC-450 | CPSC-4350
CPSC-455 | CPSC-4255
CPSC-458 | CPSC-4358
CPSC-470 | CPSC-4700
CPSC-480 | CPSC-4800
CPSC-490 | CPSC-4890
CPSC-501 | CPSC-5000
CPSC-520 | [NAME]
CPSC-520 | CPSC-6520
CPSC-535 | CPSC-4535
CPSC-535 | CPSC-6535
CPSC-540 | CPSC-4540
CPSC-540 | CPSC-6540
CPSC-542 | CPSC-4542
CPSC-542 | CPSC-6542
CPSC-548 | CPSC-3148
CPSC-548 | CPSC-6548
CPSC-560 | CPSC-4560
CPSC-560 | CPSC-6560
CPSC-562 | CPSC-4562
CPSC-562 | CPSC-6562
CPSC-565 | CPSC-4565
CPSC-565 | CPSC-6565
CPSC-566 | CPSC-4566
CPSC-566 | CPSC-6566
CPSC-570 | CPSC-4570
CPSC-570 | CPSC-6570
CPSC-572 | CPSC-4572
CPSC-572 | CPSC-6572
CPSC-576 | CPSC-4576
CPSC-576 | [NAME]
CPSC-578 | CPSC-4578
CPSC-578 | CPSC-6578
CPSC-580 | CPSC-4580
CPSC-580 | CPSC-6580
CPSC-581 | CPSC-4581
CPSC-581 | CPSC-6581
CPSC-582 | CPSC-4582
CPSC-582 | CPSC-6582
CPSC-583 | CPSC-4583
CPSC-583 | CPSC-6583
CPSC-584 | CPSC-4584
CPSC-584 | [NAME]
CPSC-610 | CPSC-6610
CPSC-622 | CPSC-6622
CPSC-630 | CPSC-6630
CPSC-635 | CPSC-6635
CPSC-642 | CPSC-6642
CPSC-643 | CPSC-6643
CPSC-646 | CPSC-6646
CPSC-648 | CPSC-6648
CPSC-656 | CPSC-6656
CPSC-660 | CPSC-6660
CPSC-700 | CPSC-7700
CPSC-702 | CPSC-7702
CPSC-705 | CPSC-6705
CPSC-710 | CPSC-7710
CPSC-720 | CPSC-8720
CPSC-735 | CPSC-8735
CPSC-742 | CPSC-8742
CPSC-745 | CPSC-7745
CPSC-760 | CPSC-7760
CPSC-762 | CPSC-7762
CPSC-790 | CPSC-8790
CPSC-810 | CPSC-8810
CPSC-812 | CPSC-8812
CPSC-815 | CPSC-8815
CPSC-820 | CPSC-8820
CPSC-825 | [NAME]
CPSC-845 | CPSC-8845
CPSC-870 | CPSC-8700
CPSC-880 | CPSC-8800
CPSC-885 | CPSC-8985
CPSC-890 | CPSC-8900
CPSC-898 | CPSC-8999
CPSC-899 | CPSC-8990
Spreadsheet: 772978d1647544727-vlookup-formula-with-multi-column-book-1
Sheet: Book-2

Nr. | Data | Sun | [NAME]
1 | 2021-01-01 00:00:00 |  | 1
2 | 2021-01-02 00:00:00 |  | 1
3 | 2021-01-03 00:00:00 |  | 1
4 | 2021-01-04 00:00:00 |  | 1
5 | 2021-01-05 00:00:00 |  | 1
6 | 2021-01-06 00:00:00 |  | 1
7 | 2021-01-07 00:00:00 |  | 1
8 | 2021-01-08 00:00:00 |  | 1
9 | 2021-01-09 00:00:00 |  | 1
10 | 2021-01-10 00:00:00 |  | 1
11 | 2021-01-11 00:00:00 |  | 1
12 | 2021-01-12 00:00:00 |  | 2
13 | 2021-01-13 00:00:00 |  | 3
14 | 2021-01-14 00:00:00 |  | 4
15 | 2021-01-15 00:00:00 |  | 5
16 | 2021-01-16 00:00:00 |  | 6
17 | 2021-01-17 00:00:00 |  | 7
18 | 2021-01-18 00:00:00 |  | 8
19 | 2021-01-19 00:00:00 |  | 9
20 | 2021-01-20 00:00:00 |  | 10
21 | 2021-01-21 00:00:00 |  | 11
22 | 2021-01-22 00:00:00 |  | 12
23 | 2021-01-23 00:00:00 |  | 13
24 | 2021-01-24 00:00:00 |  | 14
25 | 2021-01-25 00:00:00 |  | 15
26 | 2021-01-26 00:00:00 |  | 16
27 | 2021-01-27 00:00:00 |  | 17
28 | 2021-01-28 00:00:00 |  | 18
29 | 2021-01-29 00:00:00 |  | 19
30 | 2021-01-30 00:00:00 |  | 20
31 | 2021-01-31 00:00:00 |  | 21
32 | 2021-02-01 00:00:00 |  | 22
33 | 2021-02-02 00:00:00 |  | 23
34 | 2021-02-03 00:00:00 |  | 24
35 | 2021-02-04 00:00:00 |  | 25
36 | 2021-02-05 00:00:00 |  | 26
37 | 2021-02-06 00:00:00 |  | 27
38 | 2021-02-07 00:00:00 |  | 28
39 | 2021-02-08 00:00:00 |  | 29
40 | 2021-02-09 00:00:00 |  | 30
41 | 2021-02-10 00:00:00 |  | 31
42 | 2021-02-11 00:00:00 |  | 32
43 | 2021-02-12 00:00:00 |  | 33
44 | 2021-02-13 00:00:00 |  | 34
45 | 2021-02-14 00:00:00 |  | 35
46 | 2021-02-15 00:00:00 |  | 36
47 | 2021-02-16 00:00:00 |  | 37
48 | 2021-02-17 00:00:00 |  | 38
49 | 2021-02-18 00:00:00 |  | 39
50 | 2021-02-19 00:00:00 |  | 40
51 | 2021-02-20 00:00:00 |  | 41
52 | 2021-02-21 00:00:00 |  | 42
53 | 2021-02-22 00:00:00 |  | 43
54 | 2021-02-23 00:00:00 |  | 44
55 | 2021-02-24 00:00:00 |  | 45
56 | 2021-02-25 00:00:00 |  | 46
57 | 2021-02-26 00:00:00 |  | 47
58 | 2021-02-27 00:00:00 |  | 48
59 | 2021-02-28 00:00:00 |  | 49
60 | 2021-03-01 00:00:00 |  | 50
61 | 2021-03-02 00:00:00 |  | 51
62 | 2021-03-03 00:00:00 |  | 52
63 | 2021-03-04 00:00:00 |  | 53
64 | 2021-03-05 00:00:00 |  | 54
65 | 2021-03-06 00:00:00 |  | 55
66 | 2021-03-07 00:00:00 |  | 56
67 | 2021-03-08 00:00:00 |  | 57
68 | 2021-03-09 00:00:00 |  | 58
69 | 2021-03-10 00:00:00 |  | 59
70 | 2021-03-11 00:00:00 |  | 60
71 | 2021-03-12 00:00:00 |  | 61
72 | 2021-03-13 00:00:00 |  | 62
73 | 2021-03-14 00:00:00 |  | 63
74 | 2021-03-15 00:00:00 |  | 64
75 | 2021-03-16 00:00:00 |  | 65
76 | 2021-03-17 00:00:00 |  | 66
77 | 2021-03-18 00:00:00 |  | 67
78 | 2021-03-19 00:00:00 |  | 68
79 | 2021-03-20 00:00:00 |  | 69
80 | 2021-03-21 00:00:00 |  | 70
81 | 2021-03-22 00:00:00 |  | 71
82 | 2021-03-23 00:00:00 |  | 72
83 | 2021-03-24 00:00:00 |  | 73
84 | 2021-03-25 00:00:00 |  | 74
85 | 2021-03-26 00:00:00 |  | 75
86 | 2021-03-27 00:00:00 |  | 76
87 | 2021-03-28 00:00:00 |  | 77
88 | 2021-03-29 00:00:00 |  | 78
89 | 2021-03-30 00:00:00 |  | 79
90 | 2021-03-31 00:00:00 |  | 80
Spreadsheet: 809250d1670989122-coloring-cells-based-on-a-formula-excel-problem
Sheet: Sheet1

 |  | 1 | Text A | 1, 3, 5
 |  | 2 | Text B | 1
 |  | 3 | Text C | 4
 |  | 4 | Text D | 3, 4
 |  | 5 | Text E | 7
 |  | 6 | Text F
 |  | 7 | Text G | 2
 |  |  | D5 should be GREEN if the count of C5 in the range (E5 to E11) is greater than 1
 |  |  | D5 should be YELLOW if the count of C5 in the range (E5 to E11) is 1
 |  |  | D5 should be RED if the count of C5 in the range (E5 to E11) is less than 1
Spreadsheet: 863209d1710780514-to-insert-the-risk-category-according-to-the-score-residual-risk-aligw
Sheet: Sheet1

 | Risk Category | Risk score |  |  | Risk score | Risk Category
 | Low | 1 |  | Case 1 | 2
 | Medium | 4 |  | Case 2 | 13 | High
 | High | 9 |  | Case 3 | 18 | Extreme
 | Extreme | 15 |  | Case 4 | 3 | Low
 |  |  |  | Case 5 | 5 | Medium
 |  |  |  | Case 6 | 9 | High
 |  |  |  | Case 7 | 25 | Extreme
 |  |  |  | Case 8 | 5 | Medium
 |  |  |  | Case 9 | 5 | Medium
 |  |  |  | Case 10 | 7 | Medium
 |  |  |  | Case 11 | 1 | Low
 |  |  |  | Case 12 | 14 | High
 |  |  |  | Case 13 | 8 | Medium
Spreadsheet: 52314d1252006900-sorting-multiple-columns-sorting
Sheet: Sheet1

3 | 4 | 34 | 7 | 22 |  | 1 | 5 | 12 | 34 | 65
6 | 77 | 65 | 4 | 41 |  | 3 | 6 | 22 | 41 | 77
1 | 32 | 45 | 9 | 52 |  | 4 | 7 | 23 | 45 | 79
5 | 12 | 94 | 23 | 79 |  | 4 | 9 | 32 | 52 | 94
original data |  |  |  |  |  | sorted data, formula in G1, dragdown and sideways
Spreadsheet: 761614d1641113171-eomonth-issue-homeloan-testing-2
Sheet: Final

Todays Date |  |  | Current Loan Balance |  |  |  | LENDER NAME |  | Finance Company
only fill in yellow squares
calculate before extra payments |  |  |  |  |  |  |  |  |  |  |  |  | Opening Balance
 |  |  |  |  |  |  |  |  |  |  |  |  | Purchase
Loan amount |  |  | 237500 |  | Scheduled payment |  |  | 625.22 |  |  |  |  | Repayment
Interest rate |  |  | 0.0269 |  | Scheduled number of payments |  |  | 489 |  |  |  |  | Interest
 |  | period |  |  | Actual number of payments
Loan term in years |  |  | 19 |  | Payments made to date
months |  |  | 4 |  | Number of payments saved
Payments made per year |  |  | 26 |  | Years saved off original loan term
Loan repayment start date |  |  | 2021-08-12 00:00:00 |  | Total early payments
Loan repayment end  date |  |  | 2040-11-20 00:00:00 |  | Total interest
New Loan repayment End date
Time saved
Optional extra payments |  |  | 25.78
 | Date | Details | Actual Interest as per statement | Debit | Credit | Total including Interest | Statement total | correcting value |  |  | days since last transaction | Month | Interest calculated for days between activity | Interest manual check
 | 2021-08-06 00:00:00 | Opening Balance |  |  |  | 0
 | 2021-08-06 00:00:00 | Purchase |  | 237500
1 | 2021-08-12 00:00:00 | Repayment |  |  | 625.22
 | 2021-08-26 00:00:00 | Repayment |  |  | 625.22
 | 2021-08-31 00:00:00 | Interest | 436.48 |  |  |  |  | 0.24
 | 2021-09-09 00:00:00 | Repayment |  |  | 651
 | 2021-09-23 00:00:00 | Repayment |  |  | 651
 | 2021-09-30 00:00:00 | Interest | 521.96 |  |  |  |  | 0.37
 | 2021-10-07 00:00:00 | Repayment |  |  | 651
 | 2021-10-21 00:00:00 | Repayment |  |  | 651
 | 2021-10-31 00:00:00 | Interest | 537.33 |  |  |  |  | 0.4
 | 2021-11-04 00:00:00 | Repayment |  |  | 651
 | 2021-11-18 00:00:00 | Repayment |  |  | 651
 | 2021-11-30 00:00:00 | Interest | 518.06 |  |  |  |  | 0.35
 | 2021-12-02 00:00:00 | Repayment |  |  | 651
 | 2021-12-16 00:00:00 | Repayment |  |  | 651
 | 2021-12-30 00:00:00 | Repayment |  |  | 651
 | 2021-12-31 00:00:00 | Interest | 533.27 |  |  |  |  | 0.36
Spreadsheet: 791773d1660582366-formula-for-co-occurrence-with-counting-and-percentage-book1
Sheet: Sheet1

 | PRODUCT #1 | PRODUCT #2 | PRODUCT #3 | COLOR |  |  |  | [NAME] | PANTS | COAT | JACKET
DAY1 | [NAME] | PANTS | JACKET | RED |  |  | [NAME]
DAY2 | PANTS | JACKET | COAT | YELLOW |  |  | PANTS
DAY3 | COAT | PANTS | [NAME] | BLUE |  |  | COAT
DAY4 | JACKET | COAT | PANTS | BLUE |  |  | JACKET
DAY5 | [NAME] | PANTS | JACKET | RED
[NAME] | PANTS | [NAME] | COAT | YELLOW
DAY7 | [NAME] | COAT | PANTS | BLUE
Spreadsheet: c4f340cf-78da-4d5b-9067-1bb62fb685e8
Sheet: Sheet1

Table 8--Oilseed prices received by U.S. farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybeans2 | Cottonseed3 | Sunflowerseed2 | Canola4 | Peanuts3 | Flaxseed4
year
 | $/bushel | $/short ton | $/cwt. | $/cwt. | Cents/pound | $/bushel
2004/05 | 5.74 | 107 | 13.7 | 10.7 | 18.9 | 8.07
2005/06 | 5.66 | 96 | 12.1 | 9.62 | 17.3 | 5.94
2006/07 | 6.43 | 111 | 14.5 | 11.9 | 17.7 | 5.8
2007/08 | 10.1 | 162 | 21.7 | 18.3 | 20.5 | 13
2008/09 | 9.97 | 223 | 21.8 | 18.7 | 23 | 12.7
2009/10 | 9.59 | 158 | 15.1 | 16.2 | 21.7 | 8.15
2010/11 | 11.3 | 161 | 23.3 | 19.3 | 22.5 | 12.2
2011/12 | 12.5 | 260 | 29.1 | 24 | 31.8 | 13.9
2012/13 | 14.4 | 252 | 25.4 | 26.5 | 30.1 | 13.8
2013/141 | 13.1 | 248 | 21.55 | 20.5 | 23.5 | 13.7
2014/151 | 9.75-11.75 | 220-260 | 19.60-22.90 | 17.35-20.65 | 18.35-21.65 | 10.50-12.50
2012/13
September | 14.3 | 254 | 28.9 | 26.5 | 35.2 | 13.3
October | 14.2 | 254 | 26.3 | 27 | 33.7 | 13.6
November | 14.3 | 255 | 26.7 | 26.7 | 32.6 | 14.1
December | 14.3 | 252 | 24.8 | 27.1 | 36.9 | 13.8
January | 14.3 | 249 | 26.3 | 26.8 | 31.2 | 13.7
February | 14.6 | 217 | 26.1 | 27.8 | 28.2 | 14.3
March | 14.6 |  | 24.6 | 27.3 | 27.8 | 14.4
April | 14.4 |  | 24.8 | 27.5 | 26.8 | 14.9
May | 14.9 |  | 24 | 28 | 27.1 | 15.4
June | 15.1 |  | 24.4 | 27.4 | 27 | 15.2
July | 15.3 |  | 23.7 | 26.2 | 24.2 | 15.1
August | 14.1 |  | 23.7 | 22.2 | 25.1 | 14.9
2013/14
September | 13.3 | 190 | 22.6 | 20.7 | 25.5 | 13.1
October | 12.5 | 281 | 23 | 21 | 26 | 13.5
November | 12.7 | 248 | 20.8 | 20.4 | 26.6 | 13.4
December | 13 | 246 | 18.8 | 21.2 | 24.6 | 13.5
January | 12.9 | 230 | 20.3 | 18.4 | 25.4 | 13.3
February | 13.2 | 227 | 22.9 | 18.5 | 24.2 | 13.8
March | 13.7 |  | 21.5 | 18.4 | 25.2 | 13.5
April | 14.3 |  | 22.3 | 19.3 | 24.2 | 13.9
May1 | 14.5 |  | 22.2 | 20.3 | 23.8 | 14.2
1 Preliminary.  2 September-August.  3August-July. 4 July-June.
NA = Not available. |  | cwt.=hundredweight.
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Last update: | 2014-06-13 08:21:49.530000
Spreadsheet: 735974d1623291981-trimmean-if-trades
Sheet: CALCS

TIME
 |  | (Total Time in range) | (entries in range)
START | END | SUMIFS | COUNTIFS | AVERAGE
04:00:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 14:59:00
15:00:00 | 16:00:00
 | Total:
PRICE
 |  | (Total Price in range) | (entries in range) | (ave price in range) | (Total G/L in range) | (ave price in range)
LOW | HIGH | SUMIFS | COUNTIFS | AVERAGE | SUMIFS | AVERAGE
0.01 | 2
2.01 | 5
5.01 | 7
7.01 | 10
10.01 | 15
15.01 | 20
20.01 | 25
25.01 | 30
30.01 | 300
Spreadsheet: 858183d1706912514-more-than-one-occurrences-but-not-consecutive-more-than-one-occurrences-but-not-consecutive
Sheet: Sheet1

date | code | type | info
2024-01-01 00:00:00 | 100 | tea | test | I want this true because it is duplicated and not consecutive
2024-01-02 00:00:00 | 200 | tea
2024-01-03 00:00:00 | 100 | water
2024-01-01 00:00:00 | 100 | tea | test | I want this true because it is duplicated and not consecutive
2024-01-05 00:00:00 | 200 | milk
2024-01-06 00:00:00 | 100 | tea | test | I want this false because it is duplicated and it is consecutive
2024-01-06 00:00:00 | 100 | tea | test | I want this false because it is duplicated and it is consecutive
2024-01-08 00:00:00 | 100 | water
2024-01-09 00:00:00 | 100 | tea
2024-01-10 00:00:00 | 200 | milk
2024-01-11 00:00:00 | 200 | ice | test | this should stay true with last 2 records because it is dupliacted and not consecutive
2024-01-12 00:00:00 | 100 | water
2024-01-13 00:00:00 | 100 | tea
2024-01-11 00:00:00 | 200 | ice | test
2024-01-11 00:00:00 | 200 | ice | test
Spreadsheet: john_griffith__15721__AK Steel
Sheet: 3.00 put

Nymex Daily Option
 |  |  |  | Nymex | Nymex | Interest |  |  | Option Premium/mmbtu
# of Days |  | Volume |  | Price | Vol | Rate | cof
 | 2001-10-01 00:00:00 | 2330323 | 2001-11-01 00:00:00 | 2.27 | 0.7 | 0.0276 | 0.015
 | 2001-11-01 00:00:00 | 3020000 | 2001-12-01 00:00:00 | 2.6525 | 0.6 | 0.0269 | 0.015 |  | Option Premium dollars
 | 2001-12-01 00:00:00 | 3020000 | 2002-01-01 00:00:00 | 2.865 | 0.57 | 0.0267 | 0.015
 | Total |  | 2002-02-01 00:00:00 | 2.8675 | 0.55
Option | Days to |  |  |  | Put/ | Option | Pmt | Interest | Discount | Daily | Discounted | Discounted
Expire Date | Expire | Strike | Volatility | Fwd Price | Call | Value | Date | Rate | Factor | Volume | Volume | Cash Flows
2001-10-08 00:00:00 |  | 3 |  |  | P |  | 2001-11-05 00:00:00
2001-10-09 00:00:00
2001-10-10 00:00:00
2001-10-11 00:00:00
2001-10-12 00:00:00
2001-10-15 00:00:00
2001-10-16 00:00:00
2001-10-17 00:00:00
2001-10-18 00:00:00
2001-10-19 00:00:00
2001-10-22 00:00:00
2001-10-23 00:00:00
2001-10-24 00:00:00
2001-10-25 00:00:00
2001-10-26 00:00:00
2001-10-29 00:00:00
2001-10-30 00:00:00
2001-10-31 00:00:00
2001-11-01 00:00:00 |  |  |  |  |  |  | 2001-12-05 00:00:00
2001-11-02 00:00:00
2001-11-05 00:00:00
2001-11-06 00:00:00
2001-11-07 00:00:00
2001-11-08 00:00:00
2001-11-09 00:00:00
2001-11-12 00:00:00
2001-11-13 00:00:00
2001-11-14 00:00:00
2001-11-15 00:00:00
2001-11-16 00:00:00
2001-11-19 00:00:00
2001-11-20 00:00:00
2001-11-21 00:00:00
2001-11-23 00:00:00
2001-11-26 00:00:00
2001-11-27 00:00:00
2001-11-28 00:00:00
2001-11-29 00:00:00
2001-11-30 00:00:00
2001-12-03 00:00:00 |  |  |  |  |  |  | 2002-01-05 00:00:00
2001-12-04 00:00:00
2001-12-05 00:00:00
2001-12-06 00:00:00
2001-12-07 00:00:00
2001-12-10 00:00:00
2001-12-11 00:00:00
2001-12-12 00:00:00
2001-12-13 00:00:00
2001-12-14 00:00:00
2001-12-17 00:00:00
2001-12-18 00:00:00
2001-12-19 00:00:00
2001-12-20 00:00:00
2001-12-21 00:00:00
2001-12-26 00:00:00
2001-12-27 00:00:00
2001-12-28 00:00:00
2001-12-31 00:00:00
Spreadsheet: 693150d1598805374-how-do-i-add-data-to-a-sheet-without-messing-up-the-formatting-for-the-whole-workbook-problems
Sheet: Pivot Table

Row Labels | Sum of Hours
Aug | 312
Adams, Bob | 38
01-Aug | 10
02-Aug | 8
29-Aug | 8
30-Aug | 12
[NAME], [NAME] | 24
02-Aug | 8
22-Aug | 8
29-Aug | 8
[NAME], Charles | 24
02-Aug | 8
16-Aug | 8
22-Aug | 8
Credence, [NAME] | 16
15-Aug | 8
16-Aug | 8
[NAME], [NAME] | 34
01-Aug | 10
02-Aug | 8
15-Aug | 8
22-Aug | 8
Edwards, [NAME] | 54
01-Aug | 10
02-Aug | 8
15-Aug | 8
22-Aug | 16
30-Aug | 12
[NAME], Anne | 24
02-Aug | 8
16-Aug | 8
22-Aug | 8
Gonzales, George | 24
02-Aug | 8
16-Aug | 8
29-Aug | 8
Hernandez, [NAME] | 36
15-Aug | 8
16-Aug | 8
29-Aug | 8
30-Aug | 12
Smith, [NAME] | 38
01-Aug | 10
02-Aug | 8
22-Aug | 8
30-Aug | 12
Sep | 148
Adams, Bob | 22
02-Sep | 10
30-Sep | 12
[NAME], [NAME] | 16
01-Sep | 8
22-Sep | 8
Credence, [NAME] | 4
16-Sep | 4
Edwards, [NAME] | 26
02-Sep | 10
15-Sep | 8
22-Sep | 8
Gonzales, George | 26
01-Sep | 8
02-Sep | 10
22-Sep | 8
Smith, [NAME] | 54
01-Sep | 8
02-Sep | 10
15-Sep | 8
22-Sep | 8
29-Sep | 8
30-Sep | 12
Grand Total | 460