tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 822016d1679053593-create-a-rolling-60-minute-window-to-assess-busiest-time-period-rolling60minsample_v4-copy
Sheet: Sheet1

Time Series | Time | Occurences | DateTimetoVal | Rolling 60 minute total? |  | [NAME]
2019-06-15 00:00:00 | 0005 | 4 |  |  |  |  |  |  |  |  | 2019-06-15 00:00:00
2019-06-15 00:00:00 | 0005 | 5 |  |  |  |  |  |  |  | 00:00:00
2019-06-15 00:00:00 | 0010 | 5
2019-06-15 00:00:00 | 0010 | 4
2019-06-15 00:00:00 | 0010 | 5
2019-06-15 00:00:00 | 0010 | 2
2019-06-15 00:00:00 | 0010 | 9
2019-06-15 00:00:00 | 0020 | 1
2019-06-16 00:00:00 | 0030 | 2
2019-06-16 00:00:00 | 0045 | 1
2019-06-16 00:00:00 | 0105 | 13
2019-06-16 00:00:00 | 0105 | 13
2019-06-16 00:00:00 | 0105 | 13
2019-06-16 00:00:00 | 0210 | 1
2019-06-16 00:00:00 | 0430 | 31
2019-06-16 00:00:00 | 0510 | 31
2019-06-17 00:00:00 | 0510 | 31
2019-06-18 00:00:00 | 0510 | 26
2019-06-19 00:00:00 | 0525 | 1
2019-06-20 00:00:00 | 0530 | 30
2019-06-20 00:00:00 | 0530 | 30
2019-06-20 00:00:00 | 0530 | 31
2019-06-20 00:00:00 | 0530 | 31
2019-06-20 00:00:00 | 0530 | 26
2019-06-20 00:00:00 | 0540 | 31
2019-06-20 00:00:00 | 0540 | 21
2019-06-21 00:00:00 | 0540 | 23
2019-06-21 00:00:00 | 0540 | 16
2019-06-21 00:00:00 | 0540 | 1
2019-06-21 00:00:00 | 0550 | 25
2019-06-21 00:00:00 | 0550 | 8
2019-06-21 00:00:00 | 0550 | 31
2019-06-21 00:00:00 | 0600 | 3
2019-06-21 00:00:00 | 0600 | 29
2019-06-21 00:00:00 | 0620 | 31
2019-06-21 00:00:00 | 0620 | 21
2019-06-21 00:00:00 | 0620 | 20
2019-06-21 00:00:00 | 0625 | 1
2019-06-21 00:00:00 | 0630 | 1
2019-06-22 00:00:00 | 0630 | 7
2019-06-23 00:00:00 | 0630 | 28
2019-06-23 00:00:00 | 0630 | 30
2019-06-23 00:00:00 | 0630 | 31
2019-06-23 00:00:00 | 0630 | 31
2019-06-23 00:00:00 | 0630 | 31
2019-06-23 00:00:00 | 0630 | 28
2019-06-23 00:00:00 | 0635 | 9
2019-06-23 00:00:00 | 0640 | 30
2019-06-23 00:00:00 | 0645 | 8
2019-06-23 00:00:00 | 0645 | 8
Spreadsheet: 774804d1648662815-date-in-proper-date-format-date-format
Sheet: Sheet1

date | =INT method |  | But Actual Answer
2021-11-08 21:30:00 |  | 2021-11-08 00:00:00 | 2021-08-11 00:00:00
17-08-2021 9:30 pm |  | 2021-08-17 00:00:00 | 2021-08-17 00:00:00
22-08-2021 9:30 pm |  | 2021-08-22 00:00:00 | 2021-08-22 00:00:00
29-08-2021 9:30 pm |  | 2021-08-29 00:00:00 | 2021-08-29 00:00:00
2021-01-09 21:30:00 |  | 2021-01-09 00:00:00 | 2021-09-01 00:00:00
2021-05-09 21:30:00 |  | 2021-05-09 00:00:00 | 2021-09-05 00:00:00
2021-05-09 21:30:00 |  | 2021-05-09 00:00:00 | 2021-09-05 00:00:00
2021-07-09 21:30:00 |  | 2021-07-09 00:00:00 | 2021-09-07 00:00:00
26-09-2021 9:30 pm |  | 2021-09-26 00:00:00 | 2021-09-26 00:00:00 | So On
2021-04-10 21:30:00 |  | 2021-04-10 00:00:00
2021-06-10 21:30:00 |  | 2021-06-10 00:00:00
2021-12-10 21:30:00 |  | 2021-12-10 00:00:00
2021-12-10 21:30:00 |  | 2021-12-10 00:00:00
13-10-2021 9:30 pm |  | 2021-10-13 00:00:00
17-10-2021 9:30 pm |  | 2021-10-17 00:00:00
18-10-2021 9:30 pm |  | 2021-10-18 00:00:00
20-10-2021 9:30 pm |  | 2021-10-20 00:00:00
24-10-2021 9:30 pm |  | 2021-10-24 00:00:00
25-10-2021 9:30 pm |  | 2021-10-25 00:00:00
25-10-2021 9:30 pm |  | 2021-10-25 00:00:00
2021-08-11 21:30:00 |  | 2021-08-11 00:00:00
2021-11-11 21:30:00 |  | 2021-11-11 00:00:00
2021-06-12 21:30:00 |  | 2021-06-12 00:00:00
2021-06-12 21:30:00 |  | 2021-06-12 00:00:00
2021-06-12 21:30:00 |  | 2021-06-12 00:00:00
2021-06-12 21:30:00 |  | 2021-06-12 00:00:00
2021-12-12 21:30:00 |  | 2021-12-12 00:00:00
15-12-2021 9:30 pm |  | 2021-12-15 00:00:00
19-12-2021 9:30 pm |  | 2021-12-19 00:00:00
20-12-2021 9:30 pm |  | 2021-12-20 00:00:00
28-12-2021 9:30 pm |  | 2021-12-28 00:00:00
2022-02-01 21:30:00 |  | 2022-02-01 00:00:00
2022-09-01 21:30:00 |  | 2022-09-01 00:00:00
2022-11-01 21:30:00 |  | 2022-11-01 00:00:00
13-01-2022 9:30 pm |  | 2022-01-13 00:00:00
16-01-2022 9:30 pm |  | 2022-01-16 00:00:00
19-01-2022 9:30 pm |  | 2022-01-19 00:00:00
24-01-2022 9:30 pm |  | 2022-01-24 00:00:00
31-01-2022 9:30 pm |  | 2022-01-31 00:00:00
2022-01-02 21:30:00 |  | 2022-01-02 00:00:00
2022-01-02 21:30:00 |  | 2022-01-02 00:00:00
2022-01-02 21:30:00 |  | 2022-01-02 00:00:00
2022-01-02 21:30:00 |  | 2022-01-02 00:00:00
2022-03-02 21:30:00 |  | 2022-03-02 00:00:00
2022-06-02 21:30:00 |  | 2022-06-02 00:00:00
2022-06-02 21:30:00 |  | 2022-06-02 00:00:00
2022-08-02 21:30:00 |  | 2022-08-02 00:00:00
2022-08-02 21:30:00 |  | 2022-08-02 00:00:00
2022-08-02 21:30:00 |  | 2022-08-02 00:00:00
13-02-2022 9:30 pm |  | 2022-02-13 00:00:00
22-02-2022 9:30 pm |  | 2022-02-22 00:00:00
22-02-2022 9:30 pm |  | 2022-02-22 00:00:00
22-02-2022 9:30 pm |  | 2022-02-22 00:00:00
14-03-2022 9:30 pm |  | 2022-03-14 00:00:00
20-03-2022 9:30 pm |  | 2022-03-20 00:00:00
22-03-2022 9:30 pm |  | 2022-03-22 00:00:00
Spreadsheet: 55413af9-e66a-4426-8031-317038b5e743
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Oct. 6 - Oct. 15
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-06 00:00:00 | 2009-10-06 00:00:00 | 2009-10-15 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-06 00:00:00 | 2009-10-06 00:00:00 | 2009-10-15 00:00:00 | - | - | -
 | Top (A) | 10069 | 16806 | 71726 | 10335 | 17205 | 30154 | - | - | -
 | Center (A) | 10058 | 16873 | 71632 | 10321 | 17201 | 30187 | - | - | -
 | Flat (A) | 10044 | 16804 | 71710 | 10339 | 17208 | 30107 | - | - | -
 | Left  (A) | 10034 | 16790 | 71686 | 10543 | 17209 | 30101 | - | - | -
 | Right (A) | 10058 | 16820 | 71724 | 10330 | 17189 | 30138 | - | - | -
 | Average (A) | 10053 | 16819 | 71696 | 10334 | 17202 | 30127 | - | - | -
 | [NAME]  (A) | 14 | 32 | 39 | 9 | 8 | 23 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-10-06 00:00:00 | 2009-10-06 00:00:00 | 2009-02-10 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.1s | 2.9s x2 | 1.0s | 1.3s | 2.5s
 | Problems
SVG                            Developer | Date (Develop) | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-15 00:00:00 | 2009-10-15 00:00:00
 | Top (H/V) (um) | 1/1.5 | 1/1.5 | 3/3.5 | 1/1 | 1/1 | 2/2.5
 | Center (H/V) (um) | 1/1 | 1/1.5 | 3/3 | 1/1.5 | 1/1.5 | 1.5/2
 | Flat (H/V) (um) | 1/1 | 1/1.5 | 2/2.5 | 1/1.5 | 1/2 | 1.5/2
 | Left (H/V) (um) | 1/1.5 | 1/1.5 | 2/2.5 | 1/1.5 | 1/1.5 | 1.5/2
 | Right (H/V) (um) | 1/1 | 1/1.5 | 2/2.5 | 1/1.5 | 1/1.5 | 1.5/2
 | Comments
Spreadsheet: 672866d1587047692-fvschedule-function-determine-of-periods-to-calculate-example
Sheet: Payouts

Company 1 |  |  | Company 2
Age | Payout |  | Age | Payout
45 | 0.03 |  | 45 | 0.03
46 | 0.03 |  | 46 | 0.03
47 | 0.03 |  | 47 | 0.03
48 | 0.03 |  | 48 | 0.03
49 | 0.03 |  | 49 | 0.03
50 | 0.03 |  | 50 | 0.03
51 | 0.03 |  | 51 | 0.03
52 | 0.03 |  | 52 | 0.03
53 | 0.03 |  | 53 | 0.03
54 | 0.03 |  | 54 | 0.03
55 | 0.03 |  | 55 | 0.03
56 | 0.03 |  | 56 | 0.03
57 | 0.03 |  | 57 | 0.03
58 | 0.03 |  | 58 | 0.03
59 | 0.03 |  | 59 | 0.03
60 | 0.035 |  | 60 | 0.035
61 | 0.035 |  | 61 | 0.035
62 | 0.035 |  | 62 | 0.035
63 | 0.035 |  | 63 | 0.035
64 | 0.035 |  | 64 | 0.035
65 | 0.0525 |  | 65 | 0.0525
66 | 0.0525 |  | 66 | 0.0525
67 | 0.0525 |  | 67 | 0.0525
68 | 0.0525 |  | 68 | 0.0525
69 | 0.0525 |  | 69 | 0.0525
70 | 0.0525 |  | 70 | 0.0525
71 | 0.0525 |  | 71 | 0.0525
72 | 0.055 |  | 72 | 0.055
73 | 0.055 |  | 73 | 0.055
74 | 0.055 |  | 74 | 0.055
75 | 0.055 |  | 75 | 0.055
76 | 0.055 |  | 76 | 0.055
77 | 0.055 |  | 77 | 0.055
78 | 0.055 |  | 78 | 0.055
79 | 0.055 |  | 79 | 0.055
80 | 0.055 |  | 80 | 0.055
81 | 0.055 |  | 81 | 0.055
82 | 0.055 |  | 82 | 0.055
83 | 0.055 |  | 83 | 0.055
84 | 0.055 |  | 84 | 0.055
85 | 0.055 |  | 85 | 0.055
86 | 0.055 |  | 86 | 0.055
87 | 0.055 |  | 87 | 0.055
88 | 0.055 |  | 88 | 0.055
89 | 0.055 |  | 89 | 0.055
90 | 0.055 |  | 90 | 0.055
91 | 0.055 |  | 91 | 0.055
92 | 0.055 |  | 92 | 0.055
93 | 0.055 |  | 93 | 0.055
94 | 0.055 |  | 94 | 0.055
95 | 0.055 |  | 95 | 0.055
96 | 0.055 |  | 96 | 0.055
97 | 0.055 |  | 97 | 0.055
98 | 0.055 |  | 98 | 0.055
99 | 0.055 |  | 99 | 0.055
100 | 0.055 |  | 100 | 0.055
Spreadsheet: john_arnold__15119__Evaluation Form - Marc Findsen
Sheet: Sheet1

CANDIDATE EVALUATION FORM
Candidate:  [NAME] | Interviewer: Chad South
Requisition No. | Reports to:
Position: | Date:  10/18/01
Rate Candidate according to scale (5=highest, 1=lowest) in the following areas:
Customer Relations/Dealmaking | 5 | 4 | 3 | 2 | 1
Comments: | Build Relationships, Account Management, [NAME],
 | Select quality customers, Anticipate needs, Develop new ways to serve
 | customer, Propose workable deals, Negotiations, Closing.
Leadership/Visionary | 5 | 4 | 3 | 2 | 1
Comments: | Initiative, Motivating, Focus on results, Visionary thinking, Coaching,
 | Decision making, Performance measurement.
Industry Knowledge/Dealmaking | 5 | 4 | 3 | 2 | 1
Comments: | Knowledgeable about energy industry;  financial background,
 | physical  background.
Technical Knowledge/Financial/Derivatives | 5 | 4 | 3 | 2 | 1
Comments: | Specific to function, ability to learn and train others.
Strategic Skills/Innovation/Connecting/Leveraging: | 5 | 4 | 3 | 2 | 1
Comments: | Defining customer's problem/opportunity, [NAME] solve,Logical/
 | Analytical thought process, Product Development,Sees big picture,
 | Sees & defines new business opportunities.
Teamwork/Communications | 5 | 4 | 3 | 2 | 1
Comments: | Oral/Written communications,listening, team player, involves others,
 | shares information, values contributions.
Other Comments:
I think he is more fit for a trader than originator
Overall Rating: | 5 | 4 | 3 | 2 | 1
 | [NAME] |  | Acceptable |  | Don't [NAME]
Obstacles to hiring this candidate:
Would  you like this candidate on your team: | Yes |  | No
Refer to other area:  Trading in Global Products
Please return to:  [NAME] EB 3678H
Spreadsheet: 842839d1694811771-feed-single-array-via-vstack-and-reduce-issue-reduce
Sheet: Feuil1

ID;PST||ee;gg||ff;20
aa;PST||Puy;gg||Primary;20 |  |  |  |  | test |  | EXPECTED RESULT (spilling array)
bb;PST||Puy;gg||Secondary;20 |  |  |  |  |  |  | ID
 |  |  |  |  | ee |  | ee
 |  |  |  |  | ff |  | ff
 |  |  |  |  | aa |  | aa
 |  |  |  |  | Puy |  | Puy
 |  |  |  |  | Primary |  | Primary
 |  |  |  |  | bb |  | bb
 |  |  |  |  | Puy |  | Puy
 |  |  |  |  | Secondary |  | Secondary
Spreadsheet: 143458d1330431183-subtotaling-based-on-product-descrption-sample
Sheet: Summary

Bin | Empty | Article | EAN | Description | Qty
71AU3515 |  | 90014349 | 17804421542800 | Agustinos Merlot Reserve 75cl
71AU5241 |  | 90014350 | 17804421542817 | [NAME]
71AU5251 | X | 90014411 | 17804421000379 | Agustinos Sauvignon Blanc Reserve
71AU4635 |  | 90014412 | 17804421542794 | Agustinos Chardonnay Reserve
71AU2615 | X | 90056523 | 16004786007131 | [NAME] The Shore Red
71AU5237 | X | 90056524 | 16004786007124 | [NAME] The Shore White
71AU6071 |  | 90063044 | 10892931000344 | A to Z Oregon Pinot Noir
71AU5235 |  | 90077237 | 8410702012317 | Analivia Sauvignon Blanc Verdejo Rueda
70AT4715 |  | 90079135 | 3479842075106 | [NAME] Low Alcohol Merlot
70AT5011 |  | 90079136 | 3479842074109 | [NAME] Low Alcohol Chard
Spreadsheet: 736619d1623767465-nested-if-formula-with-isblank-and-max-functions-testing_formulas
Sheet: Sheet1

 | hse1 | hse1c | hse2 | hse2c | hse3 | hse3c | final (it should always show the last result) | Result (based on cell G - but this I have) | Different versions of what I tried. The simpler versions that I used in the original file and work, they do not include the 'c' cells
student 1 | 70 |  |  |  |  |  | 70 | Pass | IF(ISBLANK(E2),C2,IF(ISBLANK(A2),"",MAX(A2,B2),IF(NOT(ISBLANK(C2),MAX(C2,D2),IF(NOT(ISBLANK(E2),MAX(E2,F2))))))
student 2 | 50 |  | 45 | 50 | 30 |  | 30 | Fail | IFS(NOT(ISBLANK(A3),MAX(A3,B3),IF(NOT(ISBLANK(C3),MAX(C3,D3),IF(NOT(ISBLANK(E3),MAX(E3,F3),"")
student 3 | 65 | 67.5 |  |  |  |  | 67.5 | Pass | IF(ISBLANK(A4),"n/a",IF(ISBLANK(C4),A4,IF(ISBLANK(A4),MAX(B4,A4))))
student 4 | 50 |  | 55 |  | 60 | 62.5 | 62.5 | Pass | IF(ISBLANK(E2),C2,MAX(F2,E2)),IF(ISBLANK(C2),A2,MAX(D2,C2)),IF(ISBLANK(A2),"",MAX(B2,A2))
student 5 | 50 |  | 50 | 55 |  |  | 55 | Fail | IF(NOT(ISBLANK(B5)),B5,IF(NOT(ISBLANK(C5)),C5,IF(NOT(ISBLANK(D5)),D5,IF(NOT(ISBLANK(E5)),E5,"novalue"))))
 |  |  |  |  |  |  |  |  | IF HSE attempt 3 is blank; then check IF HSE attempt 2 is blank ; then check if HSE attempt 1 is blank, show “N/A”, else then [NAME] attempt 1, else show HSE attempt 2, else show HSE attempt 3).
Spreadsheet: 814642d1674523149-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test2
Sheet: Production

 |  |  |  |  |  | Expected results with the word: "Production"
 |  | APR | MAY | JUN |  | APR | MAY | JUN
 | 2022FY Production Claims |  |  |  | <---------- |  | 0
 | Production Sheets 2019FY
 | KPI (N.º Claims/10.000 PS)
 |  | APR | MAY | JUN | <---------- | APR | MAY | JUN
 | 2023FY Production Claims
 | Production Sheets 2019FY
 | KPI (N.º Claims/10.000 PS)
 | Complaints | 5
 | Production Sheets NOT TFM | 109447
 | KPI fy2021
 | Number of complaints per FY | FY2019 | FY2020 | FY2021
 | Gapping defect | 1
 | Marking failure | 1
 | Slider enamelling | 1
 | Wrong length | 1 | 1
 | Wrong reference/color/finish | 1 | 1
 | Manual work |  | 1 | 1
 | Slider mix | 3 | 1
 | Oxidation/MF Chain | 4
 | Wrong slider | 3 | 1 | 1
 | Dyeing | 1 |  | 5
 | Defects / Lack of terminals/open parts | 5 | 5 | 4
 | By Location | FY2019 | FY2020 | FY2021
 | Chain / Item | 7 | 2 | 5
 | Slider | 4 | 3 | 1
 | Tape | 3
 | Open parts | 3 | 1 | 1
 | Top stop | 2 | 4 | 3
 | Bottom stop | 2
 | By Section
 | CF Assembly TFM | 4 | 2 | 3
 | CF Assembly Apparel | 6 | 4 | 3
 | MF Assembly | 5 | 3 | 1
 | Dyeing TFM | 1 |  | 3
 | [NAME] | 1 | 1 | 2
 | Oxidation/MF Chain | 3
 | Enamelling | 1
 | By [NAME]
 | Wrong component / color | 2 |  | 1
 | Wrong quantity |  | 1
 | Wrong item | 2
 | Stains/Spots - Dirtiness | 1 | 2 | 1
 | Missing component | 3 | 2 | 2
 | Unleveling |  |  | 3
 | Different color/tone | 4 | 2 | 2
 | Slider Mix | 3 | 1
 | Wrong Slider | 3
 | Deficient Operation | 1 | 1 | 1
 | Wrong length | 1 | 1 | 1
 | Marking failure | 1
 |  | 2019 | 2020 | 2021
 |  | 3 CF FR-13 chain | 5 CIFOR | 5 CIFC
 |  | 3 Y | 5 CIFC | 5 CF roll
 |  | 3 CFO | 3 CHC | 5 MF
 |  | 2 CHC | 5 CIFC | 3 CF
 |  | 5 CIFC | 5 CIFC | 5 MF
 |  | 3 Y | 5 VS
 |  | 5 RC | 5 CIFOR
 |  | 3 CF | 5 CIFOR
 |  | 5 CIFC
 |  | 2 CHC
 |  | 5 MFC
 |  | 5 MFC
 |  | 5 MFC
Spreadsheet: 843394d1695242664-calculating-meal-time-out-and-in-by-employee-meal-time-test
Sheet: Meal Punch

 |  | Display Date | Actual Punch Time
 | 1 | 2023-06-21 00:00:00 | 02:18 AM
 | 1 | 2023-06-21 00:00:00 | 02:49 AM
 | 2 | 2023-06-21 00:00:00 | 02:18 AM
 | 2 | 2023-06-21 00:00:00 | 02:49 AM
 | 1 | 2023-06-22 00:00:00 | 02:21 AM
 | 1 | 2023-06-22 00:00:00 | 02:51 AM
 | 2 | 2023-06-22 00:00:00 | 02:20 AM
 | 2 | 2023-06-22 00:00:00 | 02:50 AM
 | 1 | 2023-06-25 00:00:00 | 02:19 AM
 | 1 | 2023-06-25 00:00:00 | 03:01 AM
 | 2 | 2023-06-25 00:00:00 | 02:19 AM
 | 2 | 2023-06-25 00:00:00 | 02:50 AM
 | 1 | 2023-06-26 00:00:00 | 02:23 AM
 | 1 | 2023-06-26 00:00:00 | 02:53 AM
 | 2 | 2023-06-26 00:00:00 | 02:23 AM
 | 2 | 2023-06-26 00:00:00 | 02:54 AM
 | 1 | 2023-06-27 00:00:00 | 02:18 AM
 | 1 | 2023-06-27 00:00:00 | 02:49 AM
 | 2 | 2023-06-27 00:00:00 | 02:18 AM
 | 2 | 2023-06-27 00:00:00 | 02:49 AM
 | 1 | 2023-06-28 00:00:00 | 02:17 AM
 | 1 | 2023-06-28 00:00:00 | 02:58 AM
 | 1 | 2023-06-29 00:00:00 | 02:33 AM
 | 1 | 2023-06-29 00:00:00 | 03:31 AM
 | 1 | 2023-07-02 00:00:00 | 02:23 AM
 | 1 | 2023-07-02 00:00:00 | 02:54 AM
 | 2 | 2023-07-02 00:00:00 | 02:22 AM
 | 2 | 2023-07-02 00:00:00 | 02:54 AM
 | 1 | 2023-07-03 00:00:00 | 02:20 AM
 | 1 | 2023-07-03 00:00:00 | 02:52 AM
 | 2 | 2023-07-03 00:00:00 | 02:20 AM
 | 2 | 2023-07-03 00:00:00 | 02:52 AM
 | 1 | 2023-07-05 00:00:00 | 02:16 AM
 | 1 | 2023-07-05 00:00:00 | 02:48 AM
 | 2 | 2023-07-05 00:00:00 | 02:18 AM
 | 2 | 2023-07-05 00:00:00 | 02:48 AM
 | 1 | 2023-07-06 00:00:00 | 02:25 AM
 | 1 | 2023-07-06 00:00:00 | 02:55 AM
 | 2 | 2023-07-06 00:00:00 | 02:15 AM
 | 2 | 2023-07-06 00:00:00 | 02:45 AM
 | 1 | 2023-07-09 00:00:00 | 02:28 AM
 | 1 | 2023-07-09 00:00:00 | 03:02 AM
 | 2 | 2023-07-09 00:00:00 | 02:29 AM
 | 2 | 2023-07-09 00:00:00 | 03:04 AM
 | 1 | 2023-07-10 00:00:00 | 02:19 AM
 | 1 | 2023-07-10 00:00:00 | 02:54 AM
 | 2 | 2023-07-10 00:00:00 | 02:19 AM
 | 2 | 2023-07-10 00:00:00 | 02:54 AM
 | 1 | 2023-07-11 00:00:00 | 02:18 AM
 | 1 | 2023-07-11 00:00:00 | 02:51 AM
 | 2 | 2023-07-11 00:00:00 | 02:18 AM
 | 2 | 2023-07-11 00:00:00 | 02:50 AM
 | 1 | 2023-07-16 00:00:00 | 02:48 AM
 | 2 | 2023-07-16 00:00:00 | 02:17 AM
 | 2 | 2023-07-16 00:00:00 | 02:48 AM
 | 1 | 2023-07-17 00:00:00 | 02:18 AM
 | 1 | 2023-07-17 00:00:00 | 02:48 AM
 | 2 | 2023-07-17 00:00:00 | 02:18 AM
 | 2 | 2023-07-17 00:00:00 | 02:48 AM
Spreadsheet: richard_shapiro__32164__CorpContr'00 analysis
Sheet: Breakouts

Contribution Breakout
A total of 152 contributions have been disbursed to date, totaling $949,675.
3 contrib. were not used because they were outside the scope of  this analysis.
The # of contribs & the percentages were calculated w/o using those 3 contribs. which
are listed at the bottom of the chart.
 | Contribution Destination | # of Contribs | $$ amt | % of Total Contrib | % of Total $$
 | Republicans | 66 | 505225 | 0.44295 | 0.552656
 | Democrats | 83 | 408950 | 0.55704 | 0.44734
 | State | 133 | 249175 | 0.89261 | 0.272568
 | Federal | 16 | 665000 | 0.10738 | 0.72743
 | SOM/SEBI | 18 | 42800 | 0.120805 | 0.05
 | Leadership | 27 | 31675 | 0.181208 | 0.03464
 | Key Comm. | 33 | 28600 | 0.22147 | 0.031285
 | Supports Legis | 14 | 14000 | 0.09395 | 0.015314
 | Key Dist | 8 | 6750 | 0.05369 | 0.00738
 | Not counted | 3 | 35500 | 0.01973 | 0.04
Spreadsheet: 1c628e56-0aab-4ead-8b70-f401d59dd01c
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
DIG | Test | DIG | Digoxin, Serum | Digoxin, S | Electrochemiluminescent Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Therapeutic concentration: 0.5-2.0 ng/mL Toxic concentration: > or =4.0 ng/mL Pediatric toxic concentrations may be higher. Reference values have not been established for patients that are <16 years of age. | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 80162 |  |  |  |  | Rochester
DIG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
DIG | Result | DIG | Digoxin, S | Digoxin, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 10535-3 | Digoxin:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 376843d1423727585-can-this-be-done-link-cells-update-one-cell-other-cells-in-same-column-are-updated-voucher-finder
Sheet: Sheet2

Newspaper/Magazine | Date | Page No. | Column No. |  | Rows |  | Coupon |  |  |  |  |  | News/zine List
The New York Times | 2015-01-03 00:00:00 | 1 | Start | 3 | Start | 2 | Shoes |  |  |  |  |  | The New York Times
 |  |  | End | 3 | End | 4 |  |  |  |  |  |  | Daily News
The New York Times | 2015-01-03 00:00:00 | 2 | Start | 1 | Start | 1 | Chocolate |  |  |  |  |  | Washington Post
 |  |  | End | 2 | End | 5 |  |  |  |  |  |  | USA Today
USA Today | 2015-01-05 00:00:00 | 7 | Start | 1 | Start | 7 | Dinner |  |  |  |  |  | AARP
 |  |  | End | 1 | End | 9 |  |  |  |  |  |  | Better Homes & Gardens
 |  |  | Start |  | Start |  |  |  |  |  |  |  | Family Circle
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
 |  |  | Start |  | Start
 |  |  | End |  | End
Spreadsheet: 858735d1707310409-getting-price-using-multiple-reference-points-test-new
Sheet: Mon

Job No. | CreatedDate | Sender | Consignee | Consignee Post Code | Service | Pallets | Customer Reference | Zone | Eco Full Pallets | Eco Half Pallets | Full Pallets | Half Pallets | Quarter Pallets | Delivery Cost | Supplementary Charges | Total Delivery Charge | Difference | Total Delivey Cost Excluding Extras |  | Total Difference |  | Total Pallets |  | 60 | 1 | Local
83816956 | [NAME] | Polyseam Limited | Safestore | PL6 8LH | ND | 1 | SO/49912-DN60027 | Local |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  | ND | 1 |  | Local |  |  |  | 1
 |  |  |  |  | ND | 1 |  | Local |  |  |  |  | 1
 |  |  |  |  | ND | 2 |  | Local |  |  | 1 | 1
 |  |  |  |  | ND | 2 |  | Local |  |  | 1 |  | 1
 |  |  |  |  | ND | 2 |  | Local |  |  |  | 1 | 1
 |  |  |  |  | EC | 1 |  | Local | 1
 |  |  |  |  | EC | 1 |  | Local |  | 1
 |  |  |  |  | EC | 2 |  | Local | 1 | 1
 |  |  |  |  |  |  | Prices above should be same as below
 |  |  |  |  | ND | 1 | SO/49912-DN60027 | Local |  |  | 1 |  |  | 35.43
 |  |  |  |  | ND | 1 |  | Local |  |  |  | 1 |  | 27.09
 |  |  |  |  | ND | 1 |  | Local |  |  |  |  | 1 | 22.92
 |  |  |  |  | ND | 2 |  | Local |  |  | 1 | 1 |  | 62.52
 |  |  |  |  | ND | 2 |  | Local |  |  | 1 |  | 1 | 58.35
 |  |  |  |  | ND | 2 |  | Local |  |  |  | 1 | 1 | 50.01
 |  |  |  |  | EC | 1 |  | Local | 1 |  |  |  |  | 32.3
 |  |  |  |  | EC | 1 |  | Local |  | 1 |  |  |  | 26.05
 |  |  |  |  | EC | 2 |  | Local | 1 | 1 |  |  |  | 58.35
Spreadsheet: 234797d1368192815-using-a-drop-down-to-pull-data-from-another-sheet-drop-down-for-sheet-name-v2
Sheet: Summary

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hawthorn
 | Month | RepairCenterRollUpName | Cookies sent to store | Cookies not sold | percent of cookies not sold
 | Month 1
 | Month 2
 | Month 3
 | Month 4
 | Month 5
 | Month 6
Spreadsheet: 845704d1697101233-arranging-data-for-match-with-approx-match-1-and-1-match-approx
Sheet: Sheet1

Score | Grade | Match ([NAME]) (1) |  |  | Score | Grade | Match ([NAME]) (-1)
0 | E | 90 |  |  | 100 | A |  |  | <---Why return 2 instead of 1?
30 | D |  |  |  | 90 | B
50 | C |  |  |  | 70 | C
70 | B |  |  |  | 50 | D
90 | A |  |  |  | 30 | E
 |  | Min Score=0
 |  | [NAME] =100
 |  | Score < 30 | E
 |  | 30<=Score<50 | D
 |  | 50<=Score<70 | C
 |  | 70<=Score<90 | B
 |  | Score>=90 | A