tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 201705d1356084740-issues-with-a-weekly-clock-card-report-cranwick-help
Sheet: t_Personnel_data

employee_id | badge | first_name | middle_name | last_name | paylink | ni_code | [NAME] | badge_expiry | Sex | passport_number | visa_number | known_as | union_name | union_details | union_number | address | postcode | home_tel | mobile_tel | pager_number | e_mail | nok_name | nok_tel | bank_name | bank_address | bank_tel | account_name | account_number | account_sort_code | pension_name | pension_number | pension_details | pension_date_of_entry | pension_voluntary_contribution | vehicle_registration_number | vehicle_make_and_model | driving_licence_number | driving_endorsements_last_checked | driving_endorsements_review | driving_endorsements_review_rfa | driving_endorsement_details | date_started_with_company | appraisal_next | appraisal_next_rfa | appraisal_comment | doctor_name | doctor_address | doctor_tel | blood_group | disability_rating | medication_details | vts_user_name | [NAME] | vts_administrator | wti_status | wti_opted_out_date | wti_opted_out_review_date | wti_opted_out_review_date_rfa | wti_night_shift_worker | wti_opt_out_letter | employee_grouping_id | employee_status | employee_title | employee_religion | employee_nationality | employee_ethnic_origin | employee_marital_status | employee_vehicle_ownership | Sub Departme | Department | Location | Catagory | Grouping 05 | Grouping 06 | Grouping 07 | Grouping 08 | Grouping 09 | Grouping 10 | period_schedule_allocation_week | absence_entitlement | period_schedule | selected | secondary_employment | secondary_employment_identifier | flexitime_balance_date | flexitime_balance | personal_information_portal | enrolment_state | retirement_age_rfa | years_service_rfa | email_policy | terminal_policy | badge_activation | remuneration | [NAME]
8 |  | Loraine | [NAME] | LEUTY | PY/00003
9 |  | [NAME] | [NAME] | [NAME] | PY/00012
10 |  | [NAME] |  | Boxall | PY/00016
13 |  | Christine |  | Watson | PY/00026
19 |  | Nathan |  | Jones | PY/00061
Spreadsheet: 831050d1685373055-match-and-sum-match-and-sum2
Sheet: Sheet1

Case1
 |  |  |  | Expected result
Magh | Ma-45/49/54 | [NAME]
Case2
 |  |  |  |  |  |  | Expected result
Magh | Ma-45/49/54 | [NAME]
Case3 |  |  |  |  |  |  | Expected result
 | Ma-45/49/54 | [NAME] |  |  |  |  | 4626/2023.5.26,846/2023.5.24,342/2023.5.27
Spreadsheet: 743806d1628741088-sumproduct-with-substitute-book1
Sheet: Sheet1

No . | Name | Attendance |  |  | SUMPRODUCT | SUMPRODUCT+SUBSTITUTE
1 | A | Yes |  | Yes
2 | B | Yes |  | No
3 | C | No
4 | D | No
5 | E | Yes
6 | F | Yes
7 | G | Yes
8 | H | Yes
9 | I | Yes
10 | J | Yes
Spreadsheet: 0fd43d2c-8729-4ba2-92d0-9c93cdfd7084
Sheet: Table 6.1

Monthly Statistical Bulletin
6.1 International trade in goods and services
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Exports of goods and services (a) – $ million
July | 19285 | 24979 | 26056 | 25353 | 26272
August | 18849 | 24282 | 27984 | 24228 | 27185
September | 19863 | 23999 | 27112 | 23740 | 27309
October | 19407 | 24371 | 26999 | 24330
November | 19145 | 24397 | 27045 | 24655
December | 19847 | 24446 | 27068 | 24960
January | 20628 | 23780 | 25059 | 24875
February | 20748 | 23468 | 24744 | 25687
March | 20956 | 25555 | 24894 | 25807
April | 23280 | 25478 | 25907 | 25474
May | 24498 | 26334 | 26159 | 26443
June | 25900 | 25897 | 25991 | 26051
Annual | 252154 | 297321 | 315638 | 301499
Imports of goods and services (a) – $ million
July | 20932 | 23613 | 25411 | 27221 | 27685
August | 20447 | 22957 | 25886 | 26607
September | 21943 | 22816 | 26061 | 26441
October | 21434 | 23040 | 26268 | 26749
November | 21195 | 23011 | 26698 | 27821
December | 21937 | 23239 | 26299 | 26308
January | 21836 | 23029 | 27378 | 26424
February | 22192 | 23931 | 25633 | 26165
March | 22848 | 23979 | 26846 | 25862
April | 22975 | 24273 | 27187 | 26574
May | 23483 | 24667 | 27536 | 27098
June | 23879 | 24853 | 27363 | 26541
Annual | 264754 | 283348 | 318710 | 319350
(a) Balance of payments definition. Monthly figures are seasonally adjusted.
Source: ABS, International trade in goods and services, Cat. no. 5368.0
 |  |  |  |  |  |  |  | Update
http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& |  |  |  | 2013-12-05 00:00:00
Spreadsheet: 841304d1693493579-match-date-on-two-different-pages-and-paste-data-in-columns-ef-file
Sheet: 2-5 Day

 | CR1 | Priority | Headcount
1 | Alinity RV | 19 | 0.25
2 | Alinity RV | 18 | 0.25
3 | Alinity RV | 17 | 0.25
4 | Alinity RV | 16 | 0.25
5 | Alinity RV | 15 | 0.25
12 | [NAME]
13 | [NAME] | 21 | 0.25
9 | Architect RV | 14 | 0.25 |  |  |  | 2 call ins
15 | Lid tray | 15 | 0.5
16 | Architect RV | 12 | 0.25
17 | Alinity RV | 11 | 0.25
50 | Baxter SIV Assy
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME]
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Base Trays | 23 | 0.5 |  | switch to trays
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
71 | PP4 ES
72 | 8ul ES
73 | PP1 | 4 | 0.25
74 | PP3 | 3 | 0.25
77 | Base Cassette B | 2 | 1
78 | Side Cassette A | 1 | 0.25
79 | NP Medical V-102 | 6 | 0.25
87 | [NAME] | 7 | 0.25
52 | Architect RV | 10 | 0.25
53 | Architect RV | 9 | 0.25
54 | NP Medical | 12 | 0.25
59 | Architect RV | 11 | 0.25
61 | [NAME] | 15 | 0.5
66 | [NAME] | 14 | 0.5
83 | Ceph OM#1
84 | Ceph MB#1
86 | [NAME] | 13 | 0.25
62 | NP227 | 16 | 0.25
63 | NP Birdcage | 17 | 0.25
64 | Siemens 1ML |  |  | *** last order ***
67 | [NAME]
69
88 | [NAME] | 8 | 0.25
89 | Top Frame B ES
106
107
108 | [NAME] |  | 1 | ES
109 | Baxter 4 Cavity Neck PQ | 5 | 1
Total
Spreadsheet: 27757d1221307695-dynamic-data-validation-changing-drop-down
Sheet: Sheet1

PHASE 1 |  | PHASE 2 |  |  |  | Q1 2008
Q1 2008 |  |  |  |  |  | Q2 2008 |  | Q4 2008
 |  |  |  |  |  | Q3 2008 |  | Q1 2009
 |  |  |  |  |  | Q4 2008 |  | Q2 2009
 |  |  |  |  |  | Q1 2009 |  | Q3 2009
 |  |  |  |  |  | Q2 2009 |  | Q4 2009
 |  |  |  |  |  | Q3 2009 |  | Q1 2011
 |  |  |  |  |  | Q4 2009 |  | Q2 2011
 |  |  |  |  |  | Q1 2011 |  | Q3 2011
 |  |  |  |  |  | Q2 2011 |  | Q4 2011
 |  |  |  |  |  | Q3 2011 |  | Q1 2012
 |  |  |  |  |  | Q4 2011 |  | Q2 2012
 |  |  |  |  |  | Q1 2012 |  | Q3 2012
 |  |  |  |  |  | Q2 2012 |  | Q4 2012
 |  |  |  |  |  | Q3 2012 |  | Q1 2013
 |  |  |  |  |  | Q4 2012 |  | Q2 2013
 |  |  |  |  |  | Q1 2013 |  | Q3 2013
 |  |  |  |  |  | Q2 2013 |  | Q4 2013
 |  |  |  |  |  | Q3 2013 |  | Q1 2014
 |  |  |  |  |  | Q4 2013 |  | Q2 2014
 |  |  |  |  |  | Q1 2014 |  | Q3 2014
 |  |  |  |  |  | Q2 2014 |  | Q4 2014
 |  |  |  |  |  | Q3 2014 |  | Q1 2015
 |  |  |  |  |  | Q4 2014 |  | Q2 2015
 |  |  |  |  |  | Q1 2015 |  | Q3 2015
 |  |  |  |  |  | Q2 2015 |  | Q4 2015
 |  |  |  |  |  | Q3 2015 |  | Q1 2016
 |  |  |  |  |  | Q4 2015 |  | Q2 2016
 |  |  |  |  |  | Q1 2016 |  | 0
 |  |  |  |  |  | Q2 2016 |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: 725728d1616819408-identify-the-latest-time-a-name-is-mentioned-and-return-adjacent-cell-value-book3
Sheet: Sheet2

Monday | 3 |  |  | Monday | 23
Wednesday | 2 |  |  | Tuesday | 3
Thursday | 4 |  |  | Wednesday | 6
Friday | 1 |  |  | Thursday | 7
Saturday | 3 |  |  | Friday | 1
Monday | 24 |  |  | Saturday | 3
Tuesday | 3 |  |  | Sunday | 8
Friday | 1
Monday | 23
Wednesday | 6
Thursday | 7
Sunday | 8
Spreadsheet: 85817d1285854606-how-to-create-a-list-based-on-another-column-weddingtrackerfinal
Sheet: Sheet1

Guest Name | # of ppl | Address on File | [NAME] sent | [NAME] | Table # | [NAME] | TY Card
[NAME] | 1 | Yes | Yes |  | 1 |  |  | Total Invited | Total Confirmed
Kris Quenneville | 1 | Yes | Yes |  |  |  |  | 118 | 23
Tasha Vanwinkle | 1 | Yes | Yes |  | 1
[NAME] and [NAME] | 3 | Yes | Yes |  |  |  |  | Left to Respond | Total Declined
Shannon Gorneault | 2 | Yes | Yes |  | 2 |  |  | 83 | 12
[NAME] | 1 | Yes | Yes | Yes | 2
[NAME] | 1 | Yes | Yes | Yes | Head |  |  | Table 1 | Table 7
Claude and [NAME] | 2 | Yes | Yes |  |  |  |  | 2 | 0
[NAME] and [NAME] | 5 | Yes | Yes |  |  |  |  | Table 2 | Table 8
[NAME] | 1 | Yes | Yes | Yes |  |  |  | 3 | 0
[NAME] | 2 | Yes | Yes | Yes |  |  |  | Table 3 | Table 9
[NAME] and [NAME] | 2 | Yes | Yes | Yes |  |  |  | 0 | 0
[NAME] | 1 | Yes | Yes |  |  |  |  | Table 4 | Table 10
[NAME] and [NAME] | 2 | Yes | Yes | No |  | $50.00 |  | 0 | 0
[NAME] and [NAME] | 2 | Yes | Yes | No |  |  |  | Table 5 | Table 11
[NAME] and [NAME] | 2 | Yes | Yes | No |  |  |  | 0 | 0
[NAME] | 2 | Yes | Yes |  |  |  |  | Table 6 | Table 12
[NAME] and [NAME] | 2 | Yes | Yes | Yes | Head |  |  | 0 | 0
[NAME] | 1 | Yes | Yes |  |  |  |  | Head Table | 6
[NAME] and [NAME] | 2 | Yes | Yes
[NAME] and [NAME] | 2 | Yes | Yes |  |  |  |  | Table 1 | Table 2
Crystal Litchfield | 2 | Yes | Yes |  |  |  |  | [NAME] | [NAME]
[NAME] | 2 | Yes | Yes | No |  |  |  | Tasha Vanwinkle | Shannon Gorneault
[NAME] Guests | 3 | Yes | Yes | Yes
[NAME] and [NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes | Yes
[NAME] and [NAME] | 5 | Yes | Yes
Shauna and [NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes | Yes
[NAME] and [NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes
Dawn and [NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes
[NAME] and [NAME] | 2 | Yes | Yes | No |  | $50.00
[NAME] and [NAME] | 2 | Yes | Yes
April and [NAME] | 2 | No
[NAME] and Boots | 2 | Yes | Yes
[NAME] | 1 | Yes | Yes
[NAME] | 2 | Yes | Yes
[NAME] and [NAME] | 2 | Yes | Yes
[NAME] and [NAME] | 3 |  |  | Yes | Head
[NAME] and [NAME] | 2 | Yes | Yes
[NAME] | 2 | No
[NAME] | 2 | Yes | Yes | No
[NAME] and [NAME] | 3 | No
[NAME] | 3 | Yes
[NAME] | 2 | Yes | Yes
DJ and Photographer | 2 |  |  | Yes
Dennis | 2 | Yes | Yes
[NAME] and [NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes
Dr. [NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes
[NAME] | 2 | Yes | Yes | Yes
[NAME] and Heather | 2 | Yes | Yes
Spreadsheet: 883723d1732375815-merging-in-out-with-absent-dates-into-a-single-pivot-table-formula-power-query-sample-emp-waqas-gul-
Sheet: Sheet1

First Table |  |  |  |  |  |  | Second Table
Employee | Date | Time | Status | Column1 |  |  | Employee | 1/1/2024 | 1/2/2024 | 1/3/2024
1 | 2024-01-01 00:00:00 | 08:00:00 | IN |  |  |  | 1 |  |  | A |  |  |  | below is the table like what I love to extract from the 2 data tables (Excel or Power Query)
1 | 2024-01-01 00:00:00 | 17:00:00 | OUT |  |  |  | 2 |  | CL
1 | 2024-01-02 00:00:00 | 08:00:00 | IN |  |  |  | 3 | AL |  |  |  |  |  |  | 2024-01-01 00:00:00 |  | 2024-01-02 00:00:00 |  | 2024-01-03 00:00:00
1 | 2024-01-02 00:00:00 | 17:00:00 | OUT |  |  |  |  |  |  |  |  |  |  | Employee Emp | IN | OUT | IN | OUT | IN | OUT
2 | 2024-01-01 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  |  |  |  | 1 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | AL | AL
2 | 2024-01-01 00:00:00 | 17:00:00 | OUT |  |  |  |  |  |  |  |  |  |  | 2 | 08:00:00 | 17:00:00 | CL | CL | 08:00:00 | 17:00:00
2 | 2024-01-03 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  |  |  |  | 3 | A | A | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00
2 | 2024-01-03 00:00:00 | 08:11:00 | IN |  |  |  | Time Text | Date | Status
2 | 2024-01-03 00:00:00 | 17:00:00 | OUT |  |  |  |  | 2024-01-01 00:00:00 |  | 2024-01-02 00:00:00 |  | 2024-01-03 00:00:00
3 | 2024-01-02 00:00:00 | 08:00:00 | IN |  |  |  | Employee | IN | OUT | IN | OUT | IN | OUT
3 | 2024-01-02 00:00:00 | 17:00:00 | OUT |  |  |  | 1 | 08:00 AM | 05:00 PM | 08:00 AM | 05:00 PM | A
3 | 2024-01-02 00:00:00 | 17:11:00 | OUT |  |  |  | 2 | 08:00 AM | 05:00 PM | CL |  | 08:11 AM | 05:00 PM
3 | 2024-01-03 00:00:00 | 08:00:00 | IN |  |  |  | 3 | AL |  | 08:00 AM | 05:11 PM | 08:00 AM | 05:00 PM
3 | 2024-01-03 00:00:00 | 17:00:00 | OUT
Spreadsheet: 854412d1704297080-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W13

IDs (Week 7 data (Week 19 since letter))
Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 5114504721 | 2023-12-19 00:00:00
Spreadsheet: 71155d1271865242-next-cell-content-book1
Sheet: Sheet1

No | Row1 | Row2 | Row3 | Row4
1 | chairs1 | 25 | chairs20 | 25
2 | houses2 | 24 | houses20 | 46
3 | roofs3 | 65 | roofs30 | 25
4 | tables4 | 85 | tables40 | 54
5 | computers5 | 45 | computers50 | 45
6 | chairs2 | 25 | chairs10 | 21
7 | houses3 | 26 | houses10 | 65
8 | [NAME] | 65 | roofs10 | 65
9 | tables2 | 44 | tables10 | 54
10 | computers2 | 54 | computers10 | 11
Spreadsheet: 494445d1482396525-date-is-converted-to-number-while-apply-formula-book2
Sheet: OLT

CHEQ DATE | CHEQUE NO: | AMOUNT | CUSTOMER | Checked
2016-12-28 00:00:00 | 2644 | 1 | Merit
2016-12-29 00:00:00 | 929928 | 2 | ASL
ISSUED CHEQUES FROM OLT
CHEQ DATE | CHEQUE NO: | AMOUNT | SUPPLIER
 | 2 nos
Spreadsheet: 140403d1328734178-weighted-averages-using-a-qualified-sumproduct-formula-reference-sheet-qualified-weighted-average-problem
Sheet: Sheet1

 | Example A (sorted) |  |  |  | Example B (unsorted) |  |  |  | Desired Output (Example A) |  |  |  | Desired Output (Example B)
 | Status | Equity | % Debt |  | Status | Equity | % Debt |  | Status | Equity | % Debt |  | Status | Equity | % Debt
 | Closed | 938645.1941174022 | 0.7 |  | Pipeline | 753511.5260890513 | 0.7 |  | Closed |  |  |  | Closed
 | Closed | 1368300.007224153 | 0.7 |  | Closed | 1280730.314807457 | 0.65 |  | Delayed |  |  |  | Delayed
 | Closed | 788475.75 | 0.65 |  | Closed | 788475.75 | 0.65 |  | Pipeline |  |  |  | Pipeline
 | Closed | 1261456.84 | 0.65 |  | Closed | 863770.4394435851 | 0.7 |  | Total / Avg |  |  |  | Total / Avg
 | Closed | 1280730.314807457 | 0.65 |  | Delayed | 881939.2153083184 | 0.65
 | Closed | 925502.2538922525 | 0.7 |  | Closed | 925502.2538922525 | 0.7
 | Closed | 1300790.973315803 | 0.72904653 |  | Closed | 1300790.973315803 | 0.72904653
 | Closed | 863770.4394435851 | 0.7 |  | Closed | 1306360.090045471 | 0.65
 | Closed | 1306360.090045471 | 0.65 |  | Pipeline | 1311528.581719239 | 0.7
 | Closed | 2454900.291166465 | 0.6 |  | Closed | 1368300.007224153 | 0.7
 | Closed | 1188457.907152929 | 0.65 |  | Closed | 938645.1941174022 | 0.7
 | Delayed | 1564882.732712457 | 0.7 |  | Pipeline | 1128524.689581397 | 0.65
 | Delayed | 1213620.148097466 | 0.65 |  | Pipeline | 1187440.035424126 | 0.7
 | Delayed | 881939.2153083184 | 0.65 |  | Closed | 1188457.907152929 | 0.65
 | Pipeline | 4322499.988109671 | 0.65 |  | Delayed | 1213620.148097466 | 0.65
 | Pipeline | 2780162.458056359 | 0.65 |  | Closed | 1261456.84 | 0.65
 | Pipeline | 1128524.689581397 | 0.65 |  | Delayed | 1564882.732712457 | 0.7
 | Pipeline | 1187440.035424126 | 0.7 |  | Pipeline | 1917958.919648064 | 0.65
 | Pipeline | 753511.5260890513 | 0.7 |  | Closed | 2454900.291166465 | 0.6
 | Pipeline | 1917958.919648064 | 0.65 |  | Pipeline | 2780162.458056359 | 0.65
 | Pipeline | 1311528.581719239 | 0.7 |  | Pipeline | 4322499.988109671 | 0.65
 | Total / Avg |  |  |  | Total / Avg
Spreadsheet: 273351d1382688208-dynamic-matching-cell-in-table-and-returning-column-example
Sheet: Sheet 1

 |  |  |  |  |  |  |  | Driven by | Change Magnitude
 | A
 | B
 | C
 | D
 | E
 | F
 | G
 | H
Spreadsheet: 64889d1265725618-generating-a-2nd-list-based-off-a-1st-list-help-1-
Sheet: Sheet2

Doe, Jane 1 | A111
Doe, Jane 2 | A112
Doe, [NAME] 3 | A113
Doe, [NAME] | A114
Doe, Jane 5 | A115
Doe, [NAME] 6 | A116
Doe, Jane 7 | A117
Doe, [NAME] 8 | A118
Doe, [NAME] 9 | A119
Doe, [NAME] 10 | A120
Doe, [NAME] 11 | A121
Spreadsheet: 119603d1314614489-how-to-calculate-the-average-of-minimum-values-weather
Sheet: Results

 | Day no | Date | Ave Min | Ave [NAME] | Ave
 |  | 2011-01-01 00:00:00
Spreadsheet: 806650d1669454219-trying-to-modify-a-complex-formula-that-outputs-a-spilled-result-in-multiple-columns-sample-data-1-
Sheet: Result

Generic Name | Strength | Dosage Form | Route | DIN/PDIN/NPN
 |  |  |  | Marketed | Approved
 | 25 mg | Tablet | Oral | 2141728 2017849 2097583 2229492 2229960 2239029 2257548 2348608 2479710 | 2246449 2258994 2249529 2515849 2245778 2521512 2431599 2436930 2508796
Diphenhydramine | 50 mg/mL | Liquid | Intramuscular | 2219336 596612
Diphenhydramine | 50 mg/mL | Liquid | Intravenous | 2219336 596612
Diphenhydramine | 6.25 mg/5 mL | Solution | Oral | 2019698 2248858 2478242 | 2311232
Diphenhydramine | 50 mg | Tablet | Oral | 1934414 1991086 1946986 2097575 2229959 2230398 2230485 [PHONE] 2239138 2257556 2490943 2478757 2498952 2470144 2409259 | 2246450 2263882 2456303 2515830 2532484
Diphenhydramine | 50 mg | Capsule | Oral | 2061597 757691 [PHONE] 2238644 2244203 2409224 2321270 | 2361256 2447827 2247659 2270900 2318849 2483122 2491850
Diphenhydramine | 25 mg | Capsule | Oral | [PHONE] 2383268 2365685 2304252 | 2520745 2411415
Diphenhydramine | 12.5 mg | Tablet (Chewable) | Oral | 2061287 | 2312352
Diphenhydramine | 12.5 mg/5 mL | Solution | Oral | 2019736 2465108
Diphenhydramine | 2% | Cream | Topical | 2247560 | 2401932 2354578
Diphenhydramine | 12.5 mg/5 mL | Liquid | Oral | 2248859
Diphenhydramine | 12.5 mg/5 mL | Elixir | Oral | 2298503 | 2311240
Diphenhydramine | 50 mg/mL | Solution | Intramuscular | 2369567
Diphenhydramine | 50 mg/mL | Solution | Intravenous | 2369567
Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | Oral | 2505649
Diphenhydramine | 50 mg/30 mL | Liquid | Oral | 2419769
Diphenhydramine | 50 mg/30 mL | Solution | Oral | 2427427 2432129 2474867 2464683
DIPHENHYDRAMINE | 6.25 mg/5 mL | Syrup | Oral |  | 2368374
DIPHENHYDRAMINE | 2%/w/w | Cream | Topical |  | 2321076
DIPHENHYDRAMINE | 25 mg | Strip | Oral |  | 2284170
DIPHENHYDRAMINE | 12.5 mg | Tablet | Oral |  | 2247762
Spreadsheet: 164983d1340977992-using-a-drop-down-list-to-bring-back-data-appropriate-to-the-date-selected-book2
Sheet: Summary

Today's Date | 2012-06-29 00:00:00 | Average Accounts Per Day from 3/6/2012 to Present
History
 | Owner | Worklist Name | Avg | Today's Total |  | Owner | Worklist Name | Avg | Today's Total
 | Rachel | FIFO BC/MGD MEDICARE A-LH | 64.63157894736842 |  |  | Terrie | FIFO BC/MGD MEDICARE LI-Z | 64.03508771929825
 |  | FIFO DENIAL BC/MGD MEDICARE A-LH | 57.68421052631579 |  |  |  | FIFO DENIAL BC/MGD MEDICARE LI-Z | 59.98245614035088
 |  | FIFO LC BC/MGD MEDICARE A-LH | 2.491228070175439 |  |  |  | FIFO LC BC/MGD MEDICARE LI-Z | 5.508771929824562
 |  | FIFO SPAY BC/MGD MEDICARE A-LH | 25.71929824561403 |  |  |  | FIFO SPAY BC/MGD MEDICARE LI-Z | 17.54385964912281
 |  | Totals | 150.5263157894737 | 0 |  |  | Totals | 147.0701754385965 | 0
 | [NAME] | FIFO HMO/PPO A-LH | 93.08771929824562 |  |  | Marianne | FIFO HMO/PPO LI-Z | 156.1929824561404
 |  | FIFO DENIAL HMO/PPO A-LH | 84.70175438596492 |  |  |  | FIFO DENIAL HMO/PPO LI-Z | 77.80701754385964
 |  | FIFO LC HMO/PPO A-LH | 9.736842105263158 |  |  |  | FIFO LC HMO/PPO LI-Z | 16.10526315789474
 |  | FIFO SPAY HMO/PPO A-LH | 40.43859649122807 |  |  |  | FIFO SPAY HMO/PPO LI-Z | 29.21052631578947
 |  | Totals | 227.9649122807018 | 0 |  |  | Totals | 279.3157894736842 | 0
 | Anna | FIFO MEDICARE A-LH | 187.3157894736842 |  |  | Mila | FIFO MEDICARE LI-Z | 246.4561403508772
 |  | FIFO DENIAL MEDICARE A-LH | 74.50877192982456 |  |  |  | FIFO DENIAL MEDICARE LI-Z | 22.92982456140351
 |  | FIFO LC MEDICARE A-LH | 16.7719298245614 |  |  |  | FIFO LC [NAME] | 4.350877192982456
 |  | FIFO SPAY MEDICARE A-LH | 92.73684210526316 |  |  |  | FIFO SPAY MEDICARE LI-Z | 43.2280701754386
 |  | Totals | 371.3333333333334 | 0 |  |  | Totals | 316.9649122807018 | 0
 | [NAME] | FIFO CHARTER OAK/COMM DISC | 74.85964912280701 |  |  | Nat | FIFO MEDICAID, INST, MGD MEDICAID | 101.280701754386
 |  | FIFO LC CHARTER OAK/COMM DISC | 1.052631578947368 |  |  |  | FIFO DENIAL MEDICAID, INST, MGD MEDICAID | 27.26315789473684
 |  | FIFO DENIAL CHARTER OAK/COMM DISC | 4.578947368421052 |  |  |  | FIFO LC MEDICAID, INST, MGD MEDICAID | 2.771929824561404
 |  | FIFO SPAY CHARTER OAK/COMM DISC | 4.736842105263158 |  |  |  | FIFO SPAY MEDICAID, INST, MGD MEDICAID | 4.280701754385965
 |  | FIFO COMM | 80.7719298245614 |  |  |  | FIFO HIGH $ MEDICARE | 13.19298245614035
 |  | FIFO DENIAL COMM | 14.33333333333333 |  |  |  | FIFO DENIAL HIGH $ MEDICARE | 10.56140350877193
 |  | FIFO LC COMM | 2.263157894736842 |  |  |  | FIFO LC HIGH $ MEDICARE | 1.052631578947368
 |  | FIFO SPAY COMM | 0.2105263157894737 |  |  |  | FIFO SPAY HIGH $ MEDICARE | 3.192982456140351
 |  | Totals | 182.8070175438597 | 0 |  |  | Totals | 163.5964912280702 | 0
 | Sue | FIFO HIGH $ NON GOV | 196.2456140350877
 |  | FIFO DENIAL HIGH $ NON GOV | 0.8596491228070176
 |  | FIFO LC HIGH $ NON GOV | 0.1929824561403509
 |  | FIFO SPAY HIGH $ NON GOV | 0.1228070175438596
 |  | FIFO HMO/PPO Under $300 | 145.4561403508772
 |  | Totals | 342.8771929824562 | 0
Spreadsheet: 870122d1716663158-adjustment-of-formulas-from-google-sheets-to-excel-file-my-staking
Sheet: Sheet1

Time | Tournament Event |  | Entry | Buy-in | [NAME] | Action Sold | Result
Time | Tournament Event | Share Dilution | Entry | Buy-in | [NAME] | Action Sold
May 25, 09:10 | Speed Racer Bounty $3.21 [10 BB] | No (Only first Bullet) | 1 | 3.21 | 1.1 up to 50% | 1 | 0.75
May 24, 21:05 | Daily Special $3 | No (Only first Bullet) | 2 | 3 | 1.01 up to 50% | 1 | 0
May 24, 19:10 | Speed Racer Bounty $3.21 [10 BB] | No (Only first Bullet) | 2 | 3.21 | 1.01 up to 50% | 1 | 0
Spreadsheet: 43fb1595-244e-4abc-b1a7-04c64d2d3822
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
[NAME] |  |  | Marschmusikwertung
 |  |  | Stufe A | [NAME] | [NAME] | Stufe D | [NAME] | Stufe F
Konzertwertung | [NAME] | [NAME] --> | 0.75 | 0.79 | 0.83 | 0.87 | 0.91 | 0.95
 |  | Punkte | 100 | 100 | 100 | 100 | 100 | 100
Stufe A | 0.75 | 100 | 150 | 154 | 158 | 162 | 166 | 170
[NAME] | 0.81 | 100 | 156 | 160 | 164 | 168 | 172 | 176
[NAME] | 0.87 | 100 | 162 | 166 | 170 | 174 | 178 | 182
Stufe D | 0.93 | 100 | 168 | 172 | 176 | 180 | 184 | 188
[NAME] | 1 | 100 | 175 | 179 | 183 | 187 | 191 | 195
 |  | Stufen
 |  |  | Stufe A | [NAME] | [NAME] | Stufe D | [NAME] | Stufe F
 |  | [NAME] | 0.75 | 0.81 | 0.87 | 0.93 | 1 | 1
 |  | [NAME] | 0.75 | 0.79 | 0.83 | 0.87 | 0.91 | 0.95