tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 19b8e5d7-794f-4e2e-8be8-c7489ef8b29e
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/28/2010 | Volleyball | HOWARD (WVU Classic) | 12:00 AM | W, 3-0
08/28/2010 | Volleyball | BUFFALO (WVU Classic) | 12:00 AM | W, 3-1
08/29/2010 | Volleyball | YOUNGSTOWN (WVU Classic) | 12:00 AM | W, 3-0
08/29/2010 | Volleyball | AKRON (WVU Classic) | 12:00 AM | W, 3-0
09/03/2010 | Volleyball | vs. [NAME] (George Mason Tournament) | 12:00 AM | L, 3-0
[NAME] | Volleyball | at George Mason (George Mason Tournament) | 12:00 AM | L, 3-0
[NAME] | Volleyball | vs. Army (George Mason Tournament) | 12:00 AM | W, 3-0
09/10/2010 | Volleyball | at Wake Forest (Wake Forest Classic) | 12:00 AM | L, 3-0
09/11/2010 | Volleyball | vs. East Carolina (Wake Forest Classic) | 12:00 AM | W, 3-0
09/11/2010 | Volleyball | vs. Campbell (Wake Forest Classic) | 12:00 AM | W, 3-0
09/14/2010 | Volleyball | [NAME] | 12:00 AM | W, 3-0
09/17/2010 | Volleyball | vs. [NAME] ([NAME]) | 12:00 AM | W, 3-1
09/17/2010 | Volleyball | at Cal State Fullerton ([NAME]) | 12:00 AM | L, 0-3
09/18/2010 | Volleyball | vs. [NAME] ([NAME]) | 12:00 AM | W, 3-1
09/18/2010 | Volleyball | vs. Pennsylvania ([NAME]) | 12:00 AM | L, 0-3
09/24/2010 | Volleyball | at Notre Dame | 12:00 AM | L, 0-3
09/26/2010 | Volleyball | at DePaul | 12:00 AM | W, 3-0
10/02/2010 | Volleyball | at Seton Hall | 12:00 AM | L, 3-0
10/03/2010 | Volleyball | at Rutgers | 12:00 AM | W, 3-0
10/08/2010 | Volleyball | GEORGETOWN | 12:00 AM | L, 2-3
10/10/2010 | Volleyball | USF | 12:00 AM | W, 3-1
10/16/2010 | Volleyball | PITT | 12:00 AM | W, 3-2
10/19/2010 | Volleyball | at Duquesne | 12:00 AM | L, 1-3
10/24/2010 | Volleyball | at Villanova | 12:00 AM | L, 3-0
10/29/2010 | Volleyball | at Marquette | 12:00 AM | L, 3-0
10/31/2010 | Volleyball | at Syracuse | 12:00 AM | L, 3-2
11/06/2010 | Volleyball | CINCINNATI | 12:00 AM | L, 3-2
[NAME] | Volleyball | LOUISVILLE | 12:00 AM | L, 3-0
11/12/2010 | Volleyball | ST. [NAME]'S | 12:00 AM | W, 3-0
[NAME] | Volleyball | CONNECTICUT | 12:00 AM | L, 3-2
Spreadsheet: phillip_m_love__30145__200003_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 0003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
Regions | Consolidated Flash | DPR vs. Consol. [NAME] | DPR | Adj. To NGPL | Revised NGPL | Actuals | [NAME]
Central
Sithe
Aruba
Northeast | 0 |  | 0 |  | 0 | 0
East- EGM
East-LRC
FT-East
Texas-EGM
Texas-HPLR
Texas-HPLC
FT-SouthTexas
West
Denver
FT - Denver
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
 |  |  |  |  |  |  | 0
Spreadsheet: f157e286-d32d-4781-bab0-fcec5ae6a7fc
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42269441 | 2014-07-12 15:48:16 | ALLIES | 0 | 5 | 6 | 957719 | battlemace | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42269757 | 2014-07-12 16:30:29 | ALLIES | 0 | 5 | 6 | 446704 | oggy990 | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
42270244 | 2014-07-12 16:51:54 | AXIS | 1 | 6 | 2 | 446704 | oggy990 | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
42279722 | 2014-07-13 08:29:32 | ALLIES | 0 | 5 | 6 | 1594632 | azur94 | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
42356037 | 2014-07-18 20:53:43 | ALLIES | 0 | 2 | 6 | 1025801 | Claybirds | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
42356459 | 2014-07-18 21:32:25 | ALLIES | 1 | 6 | 5 | 225841 | sacas | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
42356851 | 2014-07-18 22:03:51 | AXIS | 1 | 6 | 3 | 225841 | sacas | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
42398330 | 2014-07-21 20:29:37 | ALLIES | 0 | 1 | 6 | 681889 | bobgun | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42398570 | 2014-07-21 20:42:24 | AXIS | 1 | 6 | 2 | 681889 | bobgun | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42398825 | 2014-07-21 21:23:12 | AXIS | 0 | 5 | 6 | 1602523 | Charly Swade | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42399390 | 2014-07-21 21:54:10 | ALLIES | 1 | 6 | 3 | 1602523 | Charly Swade | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 78384d1278713194-class-schedulee-issues-dummy-schedule
Sheet: Sheet1

 |  |  | LINEAR SESSIONS
 |  | Start | Total Instructional days | Total days | End
 | Manually entered starting date → | 2010-08-09 00:00:00 | 9 | 15 | 2010-08-23 00:00:00
 |  | 2010-08-24 00:00:00 | 10 | 16 | 2010-09-08 00:00:00
 |  | 2010-09-09 00:00:00 | 11 | 17 | 2010-09-25 00:00:00
 |  | 2010-09-26 00:00:00 | 12 | 21 | 2010-10-16 00:00:00 |  |  | the problem is that instructional days are based on a 4-day week (mon-thrs.)
 |  | 2010-10-17 00:00:00 | 13 | 22 | 2010-11-07 00:00:00 |  |  | and the formula I have now in the yellow column, although able to convert and calculate how many linear days the class will take,
 |  | 2010-11-08 00:00:00 | 14 | 23 | 2010-11-30 00:00:00 |  |  | does NOT know to differentiate between a regular weekday and weekend so the dates get skewed.
 |  | 2010-12-01 00:00:00 | 15 | 24 | 2010-12-24 00:00:00
 |  | 2010-12-25 00:00:00 | 16 | 28 | 2011-01-21 00:00:00
 |  | 2011-01-22 00:00:00 | 17 | 29 | 2011-02-19 00:00:00
 |  | 2011-02-20 00:00:00 | 18 | 30 | 2011-03-21 00:00:00
 |  | 2011-03-22 00:00:00 | 19 | 31 | 2011-04-21 00:00:00
 |  | 2011-04-22 00:00:00 | 20 | 35 | 2011-05-26 00:00:00
 |  | 2011-05-27 00:00:00 | 21 | 36 | 2011-07-01 00:00:00
 |  | 2011-07-02 00:00:00 | 22 | 37 | 2011-08-07 00:00:00
 |  | 2011-08-08 00:00:00 | 23 | 38 | 2011-09-14 00:00:00
 |  | 2011-09-15 00:00:00 | 24 | 42 | 2011-10-26 00:00:00
 |  | 2011-10-27 00:00:00 | 25 | 43 | 2011-12-08 00:00:00
 |  | 2011-12-09 00:00:00 | 26 | 44 | 2012-01-21 00:00:00
 |  | 2012-01-22 00:00:00 | 27 | 45 | 2012-03-06 00:00:00
 |  | 2012-03-07 00:00:00 | 28 | 49 | 2012-04-24 00:00:00
 |  | 2012-04-25 00:00:00 | 29 | 50 | 2012-06-13 00:00:00
 |  | 2012-06-14 00:00:00 | 30 | 51 | 2012-08-03 00:00:00
 |  | 2012-08-04 00:00:00 | 31 | 52 | 2012-09-24 00:00:00
 |  | 2012-09-25 00:00:00 | 32 | 56 | 2012-11-19 00:00:00
 |  | 2012-11-20 00:00:00 | 33 | 57 | 2013-01-15 00:00:00
 |  | 2013-01-16 00:00:00 | 34 | 58 | 2013-03-14 00:00:00
 |  | 2013-03-15 00:00:00 | 35 | 59 | 2013-05-12 00:00:00
 |  | 2013-05-13 00:00:00 | 36 | 63 | 2013-07-14 00:00:00
 |  | 2013-07-15 00:00:00 | 37 | 64 | 2013-09-16 00:00:00
 |  | 2013-09-17 00:00:00 | 38 | 65 | 2013-11-20 00:00:00
 |  | 2013-11-21 00:00:00 | 39 | 66 | 2014-01-25 00:00:00
 |  | 2014-01-26 00:00:00 | 40 | 70 | 2014-04-05 00:00:00
 |  | 2014-04-06 00:00:00 | 41 | 71 | 2014-06-15 00:00:00
 |  | 2014-06-16 00:00:00 | 42 | 72 | 2014-08-26 00:00:00
 |  | 2014-08-27 00:00:00 | 43 | 73 | 2014-11-07 00:00:00
 |  |  | Manually entered | Calculation of total days based on a 7 day week.
Spreadsheet: 126632d1319798743-evaluating-arrays-book1
Sheet: Sheet1

Data |  | Unique Items
Dog
Dog
Dog
Dog
Cat
Cat
Cat
Cat
Monkey
Cat
Elephant
Elephant
Elephant
Pigeon
Pigeon
Pigeon
Donkey
Dog
Monkey
Spreadsheet: 83619d1283597219-text-wrap-issue-shift-doc
Sheet: Reminders

 |  |  | Reminder Sheet |  |  |  | Date: | 2010-09-01 00:00:00
 | Wake-Up Calls Today
 | Name |  |  | Reason |  |  |  | Wake-up Time |  | Done By
 | Appointments Today
 | Name |  |  | Details: where, who with etc |  |  |  | Time |  | Reminded By
 | Top-Ups Due Today
 | Name |  |  | Amount Due |  | Reminded By |  | Amount paid |  | Recieved By
 | Benefit Confirmation Forms Due Today
 | Name |  |  | Reminded By |  | Recieved By
 | Nights Out
 | Name |  |  | Nights absent |  | Resaon Given |  |  | [NAME] to Keyworker by
 | Keyworking Appointments Today
 | Name |  |  | Keyworker |  |  |  | Time |  | Reminded By
 | Keyworking Appointments Today
 | Name |  |  | Reminded By |  | Helped at lunchtime? |  |  | Helped at teatime?
 | Keyworking Appointments Today
 | Activity |  |  |  | Name |  |  | Reminded By |  | Participated?
Spreadsheet: 78338d1278696949-index-match-lookup-thru-multiple-columns-sample
Sheet: 7-4-10

 |  |  |  |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Week |  | Total Kitted Boxes on Hand |  | Total Kits Shippable
 |  |  |  |  |  |  |  |  |  |  | 2010-07-05 00:00:00 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | 2010-07-08 00:00:00 | 2010-07-09 00:00:00 | 2010-07-10 00:00:00 |  | Total
 |  |  | Admiral's Outpost Box A #3341 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | Admiral's Outpost Box A #3343 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | Captains Loft  #3260 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | Captain's Loft II #3272 |  |  |  |  |  |  |  | 36 | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | #N/A
 |  |  | Adventure Fortress Box #3306 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | Adventure Fortress Box #3307 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | Costco (2009) Box #3200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | Costco (2009) Box #3280 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | Costco (2009) Box #3285 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | Costco (2009) Box #3290 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | [NAME] A #3333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | [NAME] A #3335 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | [NAME] A #3337 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | Costco Monkey Bar #4061 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | [NAME] #4054 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | Picnic Table #3240 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | Tower & Bridge #3230 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
 |  |  | Tower & Bridge #3235 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A
 |  |  | Tube Slide Kit #2126 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | #N/A
Spreadsheet: 0e4f04c7-40c6-48d0-a81a-d2c81f941ddc
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 42. OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number: $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413806K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413807L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413808R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413809T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413810A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413811C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413812F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413813J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413814K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413815L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413816R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 215267d1361319773-summing-vlookup-values-sample-average-vlookup
Sheet: Sheet7

Week of December 11
Agent Name | Avaya | ACD Calls | Avg ACD Time | Avg ACW Time | % Agent Occupancy w/ ACW | [NAME] In Time | Extn Out Calls | [NAME] Time | ACD Time | ACW Time | Agent [NAME] | Other Time | AUX Time | Avail Time | Staffed Time | Utilization | Aux Abuse | ABS | Tardiness | Early Departure | Attrition | Managed OT | Expedite Fee Waive | Replace Fee Waive | Transfer | QA
 | 8062022
 | 8062033
 | 8062134
 | 8062109
 | 8062005
 | 8062053
 | 8062026
 | 8062067
 | 8062056
 | 8062114
 | 8062088
 | 8062133
 | 8062077
 | 8062054
 | 8062020
 | 8062044
 | 8062100
 | 8062031
 | 8062043
 | 8062013
 | 8062082
 | 8062117
 | 8062036
Spreadsheet: 57be4888-3ea0-441f-9d79-6052a74fa6d5
Sheet: Sheet1

Manufacturer Item# | Description | [NAME]
101 | Comfy Dog | 8-52343-00101-1
102 | Sparkle & Shine Shampoo | 8-52343-00102-8
103 | Dry Dog Instant Clean | 8-52343-00103-5
106 | [NAME] | 8-52343-00106-6
105 | Calming Aromatherapy Spritzer | 8-52343-00105-9
122 | Shimmering Mist | 8-52343-00122-6
117 | Flea the Scene | 8-52343-00117-2
124 | Fur Breeze- Citrus Vanilla | [PHONE]-0
125 | Fur Breeze- Rosemary Peppermint | [PHONE]-7
123 | [NAME] (or [NAME]) | [PHONE]-3
107 | Dog [NAME] | 8-52343-00107-3
128 | ReBound Herbal Elixir | [PHONE]-8
127 | Sleepy Time Tonic Herbal Elixir | [PHONE]-1
129 | [NAME] Herbal Elixir | [PHONE]-4
118 | Travel Dog Collection | 8-52343-00118-9
130 | Spa on the Go | 8-52343-00130-1
131 | EyePack | 8-52343-00131-8
132 | Eyemunity | 8-52343-00132-5
133 | EyePads | 8-52343-00133-2
Spreadsheet: 43010d1241619830-lookup-question-query
Sheet: Sheet1

[NAME] | 7 | 5 | 5
[NAME] | 3 | 6 | 5
[NAME] | 5 | 2 | 5
[NAME] | 4 | 5 | 5
[NAME] | 5 | 6 | 5
[NAME] | 5 | 7 | 3
[NAME] | 5 | 4 | 4
 | 3 | 2 | 3
 | 1 | 1 | 1
How do I return | [NAME] | [NAME] | [NAME]
Spreadsheet: 856580d1705776085-dependent-dropdown-list-based-on-value-from-another-dropdown-list-and-data-from-table-dropdown-list-table-data-sample-01-nickpavlov-
Sheet: Sheet2

 |  |  |  |  |  | I am looking to create a dropdown list in G10 that is the departments from Table1.   I am then looking to have a dropdown list in H10 that will pull employees from Table1 that are in the corresponding department.
DEPARTMENT | EMPLOYEE |  | Dept Drop Down |  |  | [NAME] for Departments | Dropdown List for Employees in Department in G1
Department #01 | Employee #1 |  | Department #01 |  |  | Department #01 | Employee #1
Department #01 | Employee #4 |  | Department #02
Department #01 | Employee #10 |  | Department #03
Department #02 | Employee #2 |  | Department #04
Department #02 | Employee #5 |  | Department #05
Department #02 | Employee #9
Department #03 | Employee #3
Department #03 | Employee #8
Department #04 | Employee #6
Department #05 | Employee #7
Spreadsheet: 801309d1666170631-merging-3-sheets-to-one-then-using-filter-function-example-attached-excel-help-3-vstack-aligw
Sheet: Collation

Name | Position | State | Type | Done
 | RN | SA | New | Yes |  |  | I want to filter the ones from sheet 1, 2 & 3 that, type = new & done = yes
AE | EN | SA | New | Yes
AJ | EN | WA | New | Yes
AM | EN | NT | New | Yes
AN | MR | NT | New | Yes
BC | RN | NZ | New | Yes
BD | EN | NZ | New | Yes
BH | RN | NZ | New | Yes
BI | EN | NZ | New | Yes
BN | EN | NZ | New | Yes
CC | RN | VIC | New | Yes
CD | RN | VIC | New | Yes
CI | RN | ACT | New | Yes
CL | RN | ACT | New | Yes
CM | RN | ACT | New | Yes
Spreadsheet: 139614d1328337304-excel-2010-bi-weekly-paycheck-tracker-income-calculator
Sheet: Mar 2012

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Made with [NAME]: | Calendar Creator Software
 | ◄ February |  |  |  | ~ March 2012 ~ |  |  |  |  |  |  |  | April ► |  |  |  |  |  |  |  |  |  |  |  | 2011 XLS Calendars
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  |  |  |  |  |  |  |  | 2012 XLS Calendars
 |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 |  | 2012-03-02 00:00:00 |  | 2012-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | XLS Calendar Templates
 | 2012-03-04 00:00:00 |  | 2012-03-05 00:00:00 |  | 2012-03-06 00:00:00 |  | 2012-03-07 00:00:00 |  | 2012-03-08 00:00:00 |  | 2012-03-09 00:00:00 |  | 2012-03-10 00:00:00
 | 2012-03-11 00:00:00 |  | 2012-03-12 00:00:00 |  | 2012-03-13 00:00:00 |  | 2012-03-14 00:00:00 |  | 2012-03-15 00:00:00 |  | 2012-03-16 00:00:00 |  | 2012-03-17 00:00:00
 | 2012-03-18 00:00:00 |  | 2012-03-19 00:00:00 |  | 2012-03-20 00:00:00 |  | 2012-03-21 00:00:00 |  | 2012-03-22 00:00:00 |  | 2012-03-23 00:00:00 |  | 2012-03-24 00:00:00
 | 2012-03-25 00:00:00 |  | 2012-03-26 00:00:00 |  | 2012-03-27 00:00:00 |  | 2012-03-28 00:00:00 |  | 2012-03-29 00:00:00 |  | 2012-03-30 00:00:00 |  | 2012-03-31 00:00:00
Spreadsheet: 786510d1657221768-sum-of-one-month-between-2-dates-example
Sheet: Sheet1

Start Date | Month Count | End Date | Monthly Hours
2022-01-01 00:00:00 | 24 | 2023-12-31 00:00:00 | 0 |  |  | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00
2022-10-01 00:00:00 | 1 | 2022-10-31 00:00:00 | 0 |  | Hours
2023-01-01 00:00:00 | 3 | 2023-03-31 00:00:00 | 0
2023-01-01 00:00:00 | 3 | 2023-03-31 00:00:00 | 0
2023-04-01 00:00:00 | 3 | 2023-06-30 00:00:00 | 0
2022-06-01 00:00:00 | 1 | 2022-06-30 00:00:00 | 16
2022-09-01 00:00:00 | 2 | 2022-10-31 00:00:00 | 24.5
2022-04-01 00:00:00 | 8 | 2022-11-30 00:00:00 | 30
2021-02-01 00:00:00 | 14 | 2022-03-31 00:00:00 | 34.28571428571428
2022-06-01 00:00:00 | 1 | 2022-06-30 00:00:00 | 40
2024-01-01 00:00:00 | 4 | 2024-04-30 00:00:00 | 84.5
2022-08-01 00:00:00 | 5 | 2022-12-31 00:00:00 | 96
2022-02-01 00:00:00 | 6 | 2022-07-31 00:00:00 | 96.33333333333333
2022-03-01 00:00:00 | 4 | 2022-06-30 00:00:00 | 98
2022-09-01 00:00:00 | 1 | 2022-09-30 00:00:00 | 98
2022-09-01 00:00:00 | 1 | 2022-09-30 00:00:00 | 98
2023-06-01 00:00:00 | 6 | 2023-11-30 00:00:00 | 104.5
2022-08-01 00:00:00 | 2 | 2022-09-30 00:00:00 | 120
2022-09-01 00:00:00 | 2 | 2022-10-31 00:00:00 | 120
2022-09-01 00:00:00 | 2 | 2022-10-31 00:00:00 | 120
2022-10-01 00:00:00 | 4 | 2023-01-31 00:00:00 | 120
2022-11-01 00:00:00 | 7 | 2023-05-31 00:00:00 | 123.8571428571429
2022-11-01 00:00:00 | 7 | 2023-05-31 00:00:00 | 123.8571428571429
2022-08-01 00:00:00 | 6 | 2023-01-31 00:00:00 | 129
2023-03-03 00:00:00 | 8 | 2023-10-31 00:00:00 | 138.375
2022-08-01 00:00:00 | 6 | 2023-01-31 00:00:00 | 145.3333333333333
2023-03-01 00:00:00 | 6 | 2023-08-31 00:00:00 | 156.75
2022-04-01 00:00:00 | 6 | 2022-09-30 00:00:00 | 169
2022-04-01 00:00:00 | 6 | 2022-09-30 00:00:00 | 169
2023-07-01 00:00:00 | 2 | 2023-08-31 00:00:00 | 169
2022-03-01 00:00:00 | 2 | 2022-04-30 00:00:00 | 218
2023-01-01 00:00:00 | 2 | 2023-02-28 00:00:00 | 218
2022-11-01 00:00:00 | 3 | 2023-01-31 00:00:00 | 256.3333333333333
Spreadsheet: 728746d1618595914-bowling-league-spreadsheet-closest-to-zero-bowling
Sheet: Desired Result

ID | Bowler | Date | Game | Score | [NAME] | Difference
1 | Adam | 2020-12-19 00:00:00 | 1 | 156 | 160
2 | Doug | 2020-12-16 00:00:00 | 1 | 186 | 180
3 | Rory | 2020-12-16 00:00:00 | 2 | 104 | 110
Spreadsheet: 273925d1382967414-help-plz-on-my-shipping-cost-calculator-boss-deadline-sulcide-shipping-cost-calculator-281013_1
Sheet: By Air Courier 1 - 20kg

 | FREIGHT COST BY AIR  From SIDOARJO By Courier |  |  |  |  | COURIER | LIST | COURIER
 | Destination | 1 kg | 5 kg | 20 kg |  | YES | 1 | SIDOARJO
 | INDIA | 77.83 | 75.49 | 36.38 |  | NO | 2 | JAKARTA
 | UAE | 99.4 | 96.41 | 46.28
 | FRANCE | 88.74 | 86.07 | 41.62
 | BANGKOK | 35.67 | 34.59 | 16.61
 | FREIGHT COST BY AIR From JAKARTA By Courier
 | Destination | 1 kg | 5 kg | 20 kg
 | INDIA | 65.5 | 63.54 | 30.46
 | UAE | 113.27 | 109.88 | 52.62
 | FRANCE | 86.61 | 84.05 | 40.28
 | BANGKOK | 35.94 | 34.85 | 15.24
Spreadsheet: 117519d1312840804-pulling-multiple-pieces-of-data-to-new-sheet-based-on-criteria-progress-report-for-students
Sheet: Data

Student Name | Date | Class | Assignment
Student 1 | 2011-07-01 00:00:00 | 1 | AA
Student 2 | 2011-07-01 00:00:00 | 2 | AA
Student 1 | 2011-07-02 00:00:00 | 2 | BB
Student 3 | 2011-07-03 00:00:00 | 1 | BB
Student 3 | 2011-07-04 00:00:00 | 3 | AA
Student 2 | 2011-07-05 00:00:00 | 4 | DD
Spreadsheet: 3c4bf031-ce03-41e7-abc1-d127ca684296
Sheet: Sheet1

Supplementary Table S3. Comparison of ComiR to TargetScan and PITA on the let-7d / miR-30b transfection and co-transfection datasets. Performance was measured on the set of down-regulated genes in each experiment.
Top 20% of the predictions of each tool |  |  |  |  |  |  | Top 25% of the predictions of each tool |  |  |  |  |  |  | Top 30% of the predictions of each tool
 | Sensitivity |  |  |  |  |  |  | Sensitivity |  |  |  |  |  |  | Sensitivity
 | [NAME] | TS | PITA | miRanda | [NAME] |  |  | [NAME] | TS | PITA | miRanda | [NAME] |  |  | [NAME] | TS | PITA | miRanda | [NAME]
Both | 0.336 | 0.412 | 0.218 | 0.226 | 0.178 |  | Both | 0.3936477382098171 | 0.411934552454283 | 0.2646775745909528 | 0.274 | 0.178 |  | Both | 0.438 | 0.412 | 0.324 | 0.332 | 0.178
let-7d | 0.309 | 0.259 | 0.223 | 0.241 | 0.1 |  | let-7d | 0.3531493276716207 | 0.2590233545647558 | 0.2653927813163482 | 0.284 | 0.1 |  | let-7d | 0.4 | 0.259 | 0.332 | 0.338 | 0.1
miR-30b | 0.259 | 0.24 | 0.205 | 0.181 | 0.121 |  | miR-30b | 0.3040131940626718 | 0.240241891148983 | 0.2429906542056075 | 0.229 | 0.121 |  | miR-30b | 0.345 | 0.24 | 0.269 | 0.274 | 0.121
 | Specificity |  |  |  |  |  |  | Specificity |  |  |  |  |  |  | Specificity
 | [NAME] | TS | PITA | miRanda | [NAME] |  |  | [NAME] | TS | PITA | miRanda | [NAME] |  |  | [NAME] | TS | PITA | miRanda | [NAME]
Both | 0.7835324547358049 | 0.7203473334154452 | 0.8010838773247937 | 0.804 | 0.855 |  | Both | 0.7335878802808228 | 0.7203473334154452 | 0.7509545510530854 | 0.754 | 0.855 |  | Both | 0.6809951964527651 | 0.7203473334154452 | 0.7015642320482818 | 0.704 | 0.855
let-7d | 0.7900277357539082 | 0.8632753403933434 | 0.8020675743822491 | 0.795 | 0.941 |  | let-7d | 0.73613212304589 | 0.8632753403933434 | 0.7514498234997479 | 0.743 | 0.941 |  | let-7d | 0.6812279374684821 | 0.8632753403933434 | 0.7029122541603631 | 0.692 | 0.941
miR-30b | 0.7822486738258507 | 0.8170526588174408 | 0.8005563462284901 | 0.789 | 0.898 |  | miR-30b | 0.731530599042567 | 0.8170526588174408 | 0.7494501229137016 | 0.74 | 0.898 |  | miR-30b | 0.6749902962867124 | 0.8170526588174408 | 0.7280372622590244 | 0.687 | 0.898