tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885647d1735461208-create-multiple-vertical-lines-programmatically-from-single-cell-mcmxd-sample-workbook-spill-365-aligw
Sheet: Roster

Start Date | 3-Feb | 10-Feb | 17-Feb | 24-Feb | 2024-03-03 00:00:00
 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5
Staff Name | Days (Wed off) | Days ([NAME] off) | RLEAVE | RLEAVE | Days (ELEAVE Mon/Tue, Wed off)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start date | Start time | End date | End time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days (Wed off) | 2024-02-03 00:00:00 | 7.30 | 2024-02-04 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days (Wed off) | 2024-02-04 00:00:00 | 7.30 | 2024-02-05 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days (Wed off)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days (Wed off) | 2024-02-06 00:00:00 | 7.30 | 2024-02-07 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days (Wed off) | 2024-02-07 00:00:00 | 7.30 | 2024-02-08 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days (Wed off)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days (Wed off)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days ([NAME] off) | 2024-02-10 00:00:00 | 7.30 | 2024-02-11 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days ([NAME] off) | 2024-02-11 00:00:00 | 7.30 | 2024-02-12 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days ([NAME] off) | 2024-02-12 00:00:00 | 7.30 | 2024-02-13 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days ([NAME] off) | 2024-02-13 00:00:00 | 7.30 | 2024-02-14 00:00:00 | 17.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days ([NAME] off)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days ([NAME] off)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days ([NAME] off)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLEAVE
Spreadsheet: 127882d1320671677-conditional-formatting-to-indicate-start-date-and-end-date-sample1
Sheet: Nov11

Name | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00 | 2011-11-08 00:00:00 | 2011-11-09 00:00:00 | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 | 2011-11-13 00:00:00 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 | 2011-11-16 00:00:00 | 2011-11-17 00:00:00 | 2011-11-18 00:00:00 | 2011-11-19 00:00:00 | 2011-11-20 00:00:00 | 2011-11-21 00:00:00 | 2011-11-22 00:00:00 | 2011-11-23 00:00:00 | 2011-11-24 00:00:00 | 2011-11-25 00:00:00 | 2011-11-26 00:00:00 | 2011-11-27 00:00:00 | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00
 | AL | MC
 | TR
Spreadsheet: 61523d1262399634-calculate-hours-between-two-dates-hours-between
Sheet: Foglio1

Start | End | Hours
2009-11-18 10:11:58 | 2009-11-18 10:11:58 | ?
2009-11-20 12:48:04 | 2009-11-20 13:08:00
2009-11-19 15:33:50 | 2009-11-19 15:40:56
2009-11-20 16:59:13 | 2009-11-20 17:36:00
2009-11-20 23:59:45 | 2009-11-20 23:59:45
2009-11-18 16:33:23 | 2009-11-18 16:33:23
2009-11-19 20:58:14 | 2009-11-19 21:07:46
2009-11-19 11:29:16 | 2009-11-19 11:32:58
2009-11-18 11:26:41 | 2009-11-20 23:55:54
2009-11-18 11:39:38 | 2009-11-18 11:48:01
2009-11-18 11:39:38 | 2009-11-18 11:48:01
2009-11-18 20:10:29 | 2009-11-18 20:14:12
2009-11-19 22:41:44 | 2009-11-19 23:23:39
Spreadsheet: 772239d1647102367-named-manager-formula-not-producing-result-sbd-price-list-2022
Sheet: Main Sizes Sheet

 |  |  |  |  | ZIP |  | TWIN ZIP |  |  | HONEYCOMB |  |  |  |  | TWIN HONEYCOMB |  |  |  | SKYFIT & SKYFIT XL
BLIND 1 |  | Qty | QUOTATION TEMPLATE |  | Mains | Battery | Mains | Battery |  | Electric | Crank | Wand | OPENVIEW |  | Electric | Crank | Wand |  | Manual | Motorised
[NAME] | Length | 1
1000 | 2000
BLIND 2
[NAME] | Length | 1
BLIND 3
[NAME] | Length | 1
 |  |  | Tahoma Hub (£225) |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  |  | Sub Total
 |  | Discount | 0.15
 |  |  | Total
Converter
Feet | Inches | CM | MM
12
20
0 | 28
0 | 40
Spreadsheet: 748603d1632237176-populate-dynamic-calendar-with-tasks-based-on-task-frequency-rebecca
Sheet: Sheet1

Year | 2021 |  | Task 1 | Task 2 | Task 3 | Task 4 | Task 5 | Task 6 | Task 7 | Task 8 | Task 9 | Task 10
Date | Day | Week
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
Spreadsheet: 551180d1512753076-roundupfunction-book1
Sheet: Sheet1

Number | Closest ABOVE | Closest BELOW | CLOSEST |  |  | [NAME] | [NAME]
6.7 |  |  |  |  |  | 14 | -2
12 |  |  |  |  |  | 9 | 1
1.1 |  |  |  |  |  | 8 | 4
5.1 |  |  |  |  |  | 5 | 5
7.8 |  |  |  |  |  | 4 | 8
0.8 |  |  |  |  |  | 1 | 9
16.4 |  |  |  |  |  | -2 | 14
-7
2.6
4.9
6.9
-2.3
7.6
Spreadsheet: 1c9ea39a-fbbd-4abe-ab7a-aaf9489c9031
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
 | 5302.0 Balance of Payments and International Investment Position, Australia
 | TABLE 83. EXCHANGE RATES - FINANCIAL YEAR
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
United States Dollar ;  Period average - ; |  |  | Original | A3538164A | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
United Kingdom Pound ;  Period average - ; |  |  | Original | A3538163X | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Euro ;  Period average - ; |  |  | Original | A3538165C | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
[NAME] ;  Period average - ; |  |  | Original | A3538161V | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Special Drawing Rights ;  Period average - ; |  |  | Original | A3538166F | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
United States Dollar ;  End of period - ; |  |  | Original | A3538171X | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
United Kingdom Pound ;  End of period - ; |  |  | Original | A3538170W | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Euro ;  End of period - ; |  |  | Original | A3538172A | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
[NAME] ;  End of period - ; |  |  | Original | A3538168K | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Special Drawing Rights ;  End of period - ; |  |  | Original | A3538173C | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Trade Weighted Index ;  Period average - ; |  |  | Original | A3538162W | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Trade Weighted Index ;  End of period - ; |  |  | Original | A3538169L | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
© Commonwealth of Australia  2011
Spreadsheet: 849364d1699884246-changing-the-number-of-one-cell-removes-1-from-one-cell-and-adds-it-to-another-icc-25m-gdkp-test-sheet
Sheet: TEST UNDER DEVELOPMENT

 | < NEVERMIND GDKP > ICC (25 Man) GDKP
 | Lord Marrowgar |  |  |  |  |  |  |  | Pool
 |  | item |  |  |  | [NAME] | 25000 |  |  | # | Total Gold
 |  |  |  |  |  |  |  |  |  | 25 | Payout
 |  |  |  |  |  |  |  |  |  | 5 | Hosts (10%)
 |  |  |  |  |  |  |  |  |  | 1 | Tank(1%)
 | [NAME] |  |  |  |  |  |  |  | Hosts (10%)
 |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  |  |  |  | 3 | Efil
 |  |  |  |  |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  |  |  |  |  | 5 | [NAME]
 | Icecrown Gunship Battle |  |  |  |  |  |  |  | Tanks (1%)
 |  |  |  |  |  |  |  |  |  | 1 | Tank 1
 |  |  |  |  |  |  |  |  |  | 2 | Tank 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | Raiders |  |  |  |  |  | Gold Spent
 |  |  |  |  |  |  |  |  |  | 1
 | [NAME] |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | 7
 | Festergut |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 13
 | Rotface |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  | 19
 | Professor Putricide |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  | 25
 | Blood Prince Council
 | Blood [NAME]
 | [NAME]
 | Sindragosa
 | The Lich King
 | BoE/Fragments/Other
 |  | Shadowfrost Shard
 |  | Primordial Saronite
Spreadsheet: 874852d1721366798-translating-table-for-importin-erp-excel-forum-question
Sheet: Blad1

 | Input
 | Customer | Pricelist 1 | Pricelist 2 | Pricelist 3 | Pricelist 4 | Pricelist 5
 | L10000 | 41 | 42 | 43 | 44 | 45
 | [NAME] | 61 | 62
 | [NAME] | 71 | 72 | 73
 | [NAME] | 81 | 82 | 83 | 84 | 85
 | L50000 | 91 | 93 | 95
 | Output
 | 41 | L10000
 | 42 | L10000
 | 43 | L10000
 | 44 | L10000
 | 45 | L10000
 | 61 | [NAME]
 | 62 | [NAME]
 | 71 | [NAME]
 | 72 | [NAME]
 | 73 | [NAME]
 | 81 | [NAME]
 | 82 | [NAME]
 | 83 | [NAME]
 | 84 | [NAME]
 | 85 | [NAME]
 | 91 | L50000
 | 93 | L50000
 | 95 | L50000
Spreadsheet: john_griffith__16200__1_30_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG H2 | 210 | 31.5 | 32.5 | 70.7 | 73 | 9.49 | 2002-01-30 15:01:00
 | NG J2 | 215 | 37 | 38.5 | 56.5 | 58.8 | 7.79 | 2002-01-30 15:01:00
 | NG K2 | 225 | 43 | 44.5 | 50.2 | 52 | 7.23 | 2002-01-30 15:01:00
 | NG M2 | 230 | 48 | 49.5 | 46.7 | 48.2 | 6.86 | 2002-01-30 15:01:00
 | NG N2 | 240 | 55 | 57.5 | 46.3 | 48.4 | 7.14 | 2002-01-30 15:01:00
 | NG Q2 | 245 | 62.5 | 65 | 47 | 48.9 | 7.39 | 2002-01-30 15:01:00
 | NG U2 | 245 | 67 | 69.5 | 46.6 | 48.4 | 7.32 | 2002-01-30 15:01:00
 | NG V2 | 245 | 72.5 | 74.5 | 47.5 | 48.8 | 7.42 | 2002-01-30 15:01:00
 | NG X2 | 270 | 84 | 87 | 47.1 | 48.8 | 8.14 | 2002-01-30 15:02:00
 | [NAME] | 295 | 95 | 97.5 | 46.6 | 47.8 | 8.75 | 2002-01-30 15:02:00
 | NG F3 | 300 | 106 | 109 | 49 | 50.4 | 9.37 | 2002-01-30 15:02:00
 | NG G3 | 300 | 105 | 110 | 46.5 | 48.7 | 8.98 | 2002-01-30 15:02:00
 | NG H3 |  |  |  |  |  |  | 2002-01-30 10:03:00
 | NG M3 |  |  |  |  |  |  | 2002-01-25 14:56:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 513606d1492618990-calculate-price-of-hotel-room-according-to-season-room_bookings-v2
Sheet: Prices

 |  |  | Adult | Children 6 - 14 | Children 2 - 5 | Children > 2
Low | L | Room + Breakfast | 42 | 31.5 | 27.5 | Free
 | L | Half Board | 58.5 | 42.5 | 34.5 | Free
 | L | Full Board | 70 | 51.5 | 40.5 | Free
Medium | M | Room + Breakfast | 45 | 31.5 | 27.5 | Free
 | M | Half Board | 61.5 | 42.5 | 34.5 | Free
 | M | Full Board | 73 | 51.5 | 40.5 | Free
High | H | Room + Breakfast | 48 | 31.5 | 27.5 | Free
 | H | Half Board | 64.5 | 42.5 | 34.5 | Free
 | H | Full Board | 76 | 51.5 | 40.5 | Free
Spreadsheet: 94614d1294376776-date-and-venue-wise-meeting-schedule-meeting-schedule
Sheet: Schedule 

 |  |  |  |  | Meeting Venues
 |  |  |  |  | Conf Hall A | Conf Hall B | Conf Hall C | Conf Hall D | Conf Hall E | Conf Hall F
 | Date | Day | Time | Group
 | 2010-12-04 00:00:00 |  | 1st Half | A | [NAME]
 | 2010-12-04 00:00:00 |  | 2nd Half | A | B1 Vs B2
 | 2010-12-05 00:00:00
 | 2010-12-11 00:00:00
 | 2010-12-12 00:00:00
 | 2010-12-18 00:00:00
 | 2010-12-19 00:00:00
 | 2010-12-25 00:00:00
 | 2010-12-26 00:00:00
 | 2011-01-01 00:00:00
 | 2011-01-02 00:00:00
 | 2011-01-08 00:00:00
 | 2011-01-09 00:00:00
 | 2011-01-15 00:00:00
 | 2011-01-16 00:00:00
 | 2011-01-22 00:00:00
 | 2011-01-23 00:00:00
 | 2011-01-29 00:00:00
 | 2011-01-30 00:00:00
 | 2011-02-05 00:00:00 |  | Ist Half |  | B4 [NAME] |  |  |  |  | B5 Vs B7
 | 2011-02-05 00:00:00 |  | 2nd Half |  | A4 Vs A8 |  |  |  | B5 Vs B6
 | 2011-02-06 00:00:00
 | 2011-02-12 00:00:00
 | 2011-02-13 00:00:00
Spreadsheet: 1998d70d-18a7-4991-9e64-3f9bf2dfbb8b
Sheet: Sheet1

Release: Quarterly Retail E-Commerce Sales | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=179
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-12 7:00 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Quarterly Retail E-Commerce Sales | 2009-02-17 00:00:00 | Current
Link:
http://www.census.gov/mrts/www/ecomm.html | 2009-02-17 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2009-02-17 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2009-02-17 00:00:00
2009-05-15 00:00:00
2009-08-17 00:00:00
2009-11-18 00:00:00
2010-02-16 00:00:00
2010-05-18 00:00:00
2010-08-17 00:00:00
2010-11-17 00:00:00
2011-02-17 00:00:00
2011-05-16 00:00:00
2011-08-16 00:00:00
2011-11-17 00:00:00
2012-02-16 00:00:00
2012-05-17 00:00:00
2012-08-16 00:00:00
2012-11-16 00:00:00
2013-02-15 00:00:00
2013-05-15 00:00:00
2013-08-15 00:00:00
2013-11-22 00:00:00
2014-02-18 00:00:00
Spreadsheet: 111300d1307698205-league-table-lookup-football
Sheet: Sheet1

FANTASY FOOTBALL TABLE
2011/12 PREMIER LEAGUE SEASON
Aug
 |  | Paid |  |  |  |  |  |  |  |  |  | Month Points | Total Points
Name | Team Name | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May
Player 1 | Team 1 |  |  |  |  |  |  |  |  |  |  | 11 | 444
Player 2 | Team 2 |  |  |  |  |  |  |  |  |  |  | 2 | 21
Player 3 | Team 3 |  |  |  |  |  |  |  |  |  |  | 1234 | 1245
Player 4 | Team 4 |  |  |  |  |  |  |  |  |  |  | 112 | 1234
Player 5 | Team 5 |  |  |  |  |  |  |  |  |  |  | 44 | 123
Player 6 | Team 6 |  |  |  |  |  |  |  |  |  |  | 412 | 1235
Player 7 | Team 7 |  |  |  |  |  |  |  |  |  |  | 123 | 411
Player 8 | Team 8 |  |  |  |  |  |  |  |  |  |  | 4123 | 9221
Player 9 | Team 9 |  |  |  |  |  |  |  |  |  |  | 124 | 441
Player 10 | Team 10 |  |  |  |  |  |  |  |  |  |  | 3 | 145
Player 11 | Team 11 |  |  |  |  |  |  |  |  |  |  | 212 | 1234
Player 12 | Team 12 |  |  |  |  |  |  |  |  |  |  | 1 | 561
Player 13 | Team 13 |  |  |  |  |  |  |  |  |  |  | 312 | 15
Player 14 | Team 14 |  |  |  |  |  |  |  |  |  |  | 45 | 13412
Player 15 | Team 15 |  |  |  |  |  |  |  |  |  |  | 14 | 14
Player 16 | Team 16 |  |  |  |  |  |  |  |  |  |  | 24 | 11
Player 17 | Team 17 |  |  |  |  |  |  |  |  |  |  | 14 | 145
Player 18 | Team 18 |  |  |  |  |  |  |  |  |  |  | 124 | 14
Player 19 | Team 19 |  |  |  |  |  |  |  |  |  |  | 12 | 124
Player 20 | Team 20 |  |  |  |  |  |  |  |  |  |  | 214 | 1
 | Monthly Prize Total | 0 |  |  | Monthly Leader |  |  |  | #N/A
 | Total Prize Pot | 0 |  |  | Current Leader
Spreadsheet: 20c4cc08-72bf-48ca-a831-6023d6e48059
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
42346676 | 2014-07-18 04:32:26 | ALLIES | 1 | 7 | 6 | 1024315 | dangie | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42346901 | 2014-07-18 04:55:16 | AXIS | 0 | 5 | 7 | 1024315 | dangie | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42388544 | 2014-07-21 05:19:54 | ALLIES | 1 | 6 | 4 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42388733 | 2014-07-21 05:39:25 | AXIS | 0 | 4 | 6 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42483749 | 2014-07-28 03:23:05 | ALLIES | 0 | 2 | 10 | 1024315 | dangie | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42484082 | 2014-07-28 03:43:48 | AXIS | 0 | 5 | 10 | 1024315 | dangie | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42498222 | 2014-07-29 02:53:58 | ALLIES | 1 | 6 | 4 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42498850 | 2014-07-29 03:44:10 | AXIS | 1 | 6 | 4 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 116425d1311818964-merge-duplicate-rows-deletenotallowed
Sheet: Sheet1

 |  | Index | Helper | Formula1 | Formula2
SNO | Name
1 | Cal
1 | Cal
1 | Cal
1 | Va
1 | Va
1 | Tx
1 | Tx
1 | Tx
2 | London
2 | London
2 | [NAME]
2 | [NAME]
Spreadsheet: 813475d1673801335-pls-help-average-with-if-conditions-need-average-of-each-product-specified-by-year-and-market-entry-date-for-blank
Sheet: Product Price & Average

Data |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  | 2018 |  |  | 2019 |  |  | 2020 |  |  | 2021 |  |  | 2022 |  |  | 2023 |  |  | 2024
Product ID | Product Name | Amount | Effective Date | Expiration Date | Start Year | End Year |  | Product ID | Product Name | Market Entry Date | Market Entry Year | Average Amt for 2017 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2018 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2019 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2020 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2021 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2022 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2023 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2024 | % Increased based on previous year | Amount Increased Based on Previous Year
1003 | Candy A | 8754.9 | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 |  |  |  | 1003 | Candy A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | need condition to pull based on product ID and year Start and End Date Matching AH2
1003 | Candy A | 9297.7 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 |  |  |  | 1004 | Candy B
1003 | Candy A | 9985.73 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 |  |  |  | 1005 | Candy C
1003 | Candy A | 10604.85 | 2021-01-01 00:00:00 | 2022-01-13 00:00:00 |  |  |  | 1006 | Candy D
1003 | Candy A | 11124.49 | 2022-01-14 00:00:00 | 2023-01-02 00:00:00
1003 | Candy A | 11680.71 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00
1004 | Candy B | 370.29 | 2013-12-27 00:00:00 | 2014-06-30 00:00:00
1004 | Candy B | 388.44 | 2014-07-01 00:00:00 | 2014-12-30 00:00:00
1004 | Candy B | 415.24 | 2014-12-31 00:00:00 | 2015-12-22 00:00:00
1004 | Candy B | 443.89 | 2015-12-23 00:00:00 | 2016-12-25 00:00:00
1004 | Candy B | 465.64 | 2016-12-26 00:00:00 | 2017-12-21 00:00:00
1004 | Candy B | 497.77 | 2017-12-22 00:00:00 | 4700-12-31 00:00:00
1005 | Candy C | 3225.88 | 2022-09-13 00:00:00 | 2023-01-02 00:00:00
1005 | Candy C | 3451.69 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Answer for [NAME] should be
1006 | Candy D | 18272.79 | 2022-12-15 00:00:00 | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1st Condition |  | if product ID in I Column matches Product ID Data Table
1006 | Candy D | 19734.61 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2nd Condition |  | if start year and end year matches year in S2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd Condition |  | then give me the average of Amount
 | [NAME]