tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 469424d1467910295-help-with-difficult-unique-countifs-helpie-
Sheet: Sheet1

 |  |  | Date | Status
 |  |  | 2015-01-02 00:00:00 | Paid |  |  | Number of Dates in January
 |  |  | 2015-01-02 00:00:00 | Paid |  |  | Count of Unique Dates WITH PAID STATUS | ???? |  | Should be equal to |  | 8
 |  |  | 2015-01-02 00:00:00 | Paid |  |  | Number by year
 |  |  | 2015-01-02 00:00:00 | No
 |  |  | 2015-01-02 00:00:00 | No
 |  |  | 2015-01-02 00:00:00 | No
 |  |  | 2015-01-05 00:00:00 | No
 |  |  | 2015-01-05 00:00:00 | Paid
 |  |  | 2015-01-08 00:00:00 | Paid
 |  |  | 2015-01-08 00:00:00 | Paid
 |  |  | 2015-01-10 00:00:00 | No
 |  |  | 2015-01-10 00:00:00 | No
 |  |  | 2015-01-10 00:00:00 | No
 |  |  | 2015-01-10 00:00:00 | Paid
 |  |  | 2015-01-11 00:00:00 | Paid
 |  |  | 2015-01-11 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | No
 |  |  | 2015-01-19 00:00:00 | No
 |  |  | 2015-01-19 00:00:00 | No
 |  |  | 2015-01-21 00:00:00 | No
 |  |  | 2015-01-21 00:00:00 | Paid
 |  |  | 2015-01-21 00:00:00 | Paid
 |  |  | 2015-01-21 00:00:00 | Paid
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-29 00:00:00 | No
 |  |  | 2015-01-29 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | No
 |  |  | 2015-02-07 00:00:00 | No
 |  |  | 2015-02-07 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | Paid
 |  |  | 2015-02-16 00:00:00 | No
 |  |  | 2015-02-16 00:00:00 | No
 |  |  | 2015-02-22 00:00:00 | Paid
 |  |  | 2015-02-22 00:00:00 | Paid
 |  |  | 2015-03-08 00:00:00 | No
 |  |  | 2015-03-08 00:00:00 | Paid
 |  |  | 2015-03-11 00:00:00 | Paid
 |  |  | 2015-03-11 00:00:00 | Paid
 |  |  | 2015-03-13 00:00:00 | Paid
 |  |  | 2015-03-13 00:00:00 | Paid
Spreadsheet: 328255d1403842247-how-to-calculate-no-of-right-answers-correct-answer-counter
Sheet: Sheet1

ABCD | << Answer
Student1 | ABDD
Student2 | ABCD
Student3 | DDDA
Spreadsheet: 881490d1729560908-max-range-position-based-on-cell-value-excel-help-staffing-bvj-
Sheet: Sheet1

 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00
Role | Lead Time (Months) | Monthly Unit Capacity |  | Units |  | 25 | 25 | 35 | 35 | 55 | 55 | 75 | 75 | 100 | 75 | 75 | 75 | 55 | 55 | 75 | 75 | 100 | 100 | 125 | 125 | 150 | 150 | 125 | 125
Assist 1 | 2 | 15 |  | Staff Count
Assist 2 | 3 | 35
Assist 3 | 4 | 50
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 5

 | Dec 28 | Jan 4 | Jan 11 | Jan 18 | Jan 25
Total Interest Rate* | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 57367d1257459457-compare-cells-with-other-other-worksheets-compare-cells-example
Sheet: Sheet6

Color | [NAME] | [NAME] | [NAME]
Yellow
Orange
White
Pink
Red
Green
Blue
Spreadsheet: 673519d1587419483-data-export-to-condensed-list-form-inventory-example-sheet-2
Sheet: Orders

 | Orders | Company | Product | Amount
 | 123 | South Park Corp | Oranges | 5
 | 321 | Nickelodeon | Oranges | 4
 | 321 | Nickelodeon | Peaches | 3
 | 321 | Nickelodeon | Apples | 3
Spreadsheet: 8f5e8b2e-d71f-4a29-aaeb-a12fb370be22
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Financial Report
 |  | All Manufacturing: U.S. Total
 |  | Not Seasonally Adjusted Net Sales, Receipts, and Operating Revenues [Millions of Dollars]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: November 27, 2014 (6:36 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2000 |  |  |  | 1128790
2001 | 1082233 | 1116597 | 1062443 | 1033734
2002 | 994073 | 1071574 | 1068667 | 1082128
2003 | 1072017 | 1096910 | 1109436 | 1118800
2004 | 1145872 | 1248717 | 1250976 | 1288495
2005 | 1258442 | 1352179 | 1384246 | 1416600
2006 | 1397414 | 1485624 | 1467143 | 1432485
2007 | 1405836 | 1526484 | 1539399 | 1588312
2008 | 1566418 | 1724172 | 1682270 | 1401261
2009 | 1196693 | 1253821 | 1305867 | 1353446
2010 | 1349210 | 1461717 | 1463507 | 1481530
2011 | 1532484 | 1657405 | 1650561 | 1645072
2012 | 1648177 | 1689523 | 1656755 | 1673633
2013 | 1626424 | 1703610 | 1703748 | 1707827
Spreadsheet: 869721d1716302181-pull-data-through-from-a-worksheet-which-worksheet-is-defined-by-the-value-in-a-cell-using-indirect-with-filter-_with-spaces-etaf
Sheet: 010624

Date | Customer | Site | Product | Del. Site | [NAME] | Quantity | Count | Pack Weight (g) | Total No. Packs | Weight (kg) | Total No. Pallets
 | Tesco | A | Peas | A2B | [NAME] | 1 | 12 | 225 | 0 | 0
 | Sainsburys | B | Carrots | B2C | [NAME] | 2 | 12 | 225 | 0 | 0
 | Morrisons | C | Broccoli | C2D | [NAME] | 3 | 12 | 225 | 0 | 0
 | Asda | D | Cauliflower | D2E | [NAME] | 4 | 12 | 225 | 0 | 0
 | Lidl | E | Cabbage | E2F | [NAME] | 5 | 12 | 225 | 0 | 0
 | Aldi | F | Lettuce | F2G | [NAME] | 6 | 12 | 225 | 0 | 0
Spreadsheet: f1742816-1ba2-4d60-bcb8-90151ddda8bd
Sheet: Sheet1

Release: Quarterly Starts and Completions by Purpose and Design | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=228
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-19 8:33 PM CST
 | Real-Time | Period
Name: | Start | End
Quarterly Starts and Completions by Purpose and Design | 2011-05-17 00:00:00 | Current
Link:
http://www.census.gov/const/www/newresconstindex_excel.html | 2011-05-17 00:00:00 | Current
Source:
US. Bureau of the Census | 2011-05-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:
2011-05-17 00:00:00
2011-08-16 00:00:00
2011-11-17 00:00:00
2012-02-16 00:00:00
2012-05-16 00:00:00
2012-08-16 00:00:00
2012-11-20 00:00:00
2013-02-20 00:00:00
2013-05-16 00:00:00
2013-08-16 00:00:00
2013-12-18 00:00:00
2014-02-19 00:00:00
2014-05-16 00:00:00
2014-08-19 00:00:00
2014-11-19 00:00:00
Spreadsheet: 76323d1276822612-piecewise-function-example1
Sheet: Sheet1

Net value | 0 | 3 | 8 | 19 | 40 | 120
Net Value | Return
0 |  |  |  | Return Milestones | percentage of net
20 |  |  |  | <25 | 0
30 |  |  |  | 25-50 | 0.025
60 |  |  |  | 50-100 | 0.05
90 | 0 |  |  | >100 | 0.1
100 | 0
120
Spreadsheet: 792058d1660725119-count-unique-values-from-a-data-table-that-match-a-value-on-another-sheet-formula
Sheet: Data

A | B | C | D | E | F | G | H | I | Budget | K | L | N | Company
 |  |  |  |  |  |  |  |  | A-2018 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | A-2018 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | A-2018 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  | A-2018 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  | A-2018 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  | N-2018 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | N-2018 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | NL-2019 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | NL-2019 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0020904
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0020904
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0022809
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0022809
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0000468
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0000468
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0000836
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0000836
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0000836
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001988
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  | L-99 |  |  |  | P0001699
 |  |  |  |  |  |  |  |  |  | Unique values in column N ---->
Spreadsheet: 152905d1335584620-remove-blanks-from-data-validation-list-jame24_non_blanks_list_27apr12_01
Sheet: Sheet2

Full List |  | Helper Column |  | Non-blanks List ê
Jan |  | Jan |  | Jan
Feb |  | Feb
Mar |  | Mar
Apr |  | Apr
May |  | May
 |  | Jun
Jun |  | Jul
 |  | Aug
 |  | Sep
Jul
Aug
Sep
Spreadsheet: 779132d1651596270-need-2-net-and-2-gross-golf-scores-added-together-without-using-same-user-for-both-golf-league-example-fixed
Sheet: Sheet1

Date: | 2022-04-27 00:00:00
Side: | Front
Par: | 36
 |  |  | Team
 |  |  |  | H | Gross | + / - Par | Net | + / - Par | Gross Tie-break | Net Tie-Break
 |  |  | Player 1 | 1 | 99
 |  |  | Player 2 | 1 | 42
 |  |  | Player 3 | 4 | 49
 |  |  | Player 4 | 5 | 48
 |  |  | Player 5 | 8 | 45
 |  |  | Player 6 | 8 | 46
 |  |  | Team score |  |  |  |  |  | <= formula here
Spreadsheet: 769952d1645730084-repeat-cell-4-times-and-move-to-next-row-excel-solution
Sheet: Sheet1

Program | Activity Nbr
Budget Office | 2410120001
Information Technology | 2410120002
Development | 2410120003
Assoc. [NAME] of Admin | 2410120004
Activity Nbr
Spreadsheet: fcb6b0ed-e678-49dc-a1e8-18a529ce58bd
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 | Unnamed: 13
 |  |  |  |  |  | 1ST PLACE:
 |  |  |  |  |  | 2ND PLACE:
 |  |  |  |  |  | 3RD PLACE:
 |  |  |  |  |  | 4TH PLACE:
1 |  | 32 |  |  |  |  |  |  |  |  | 3 |  | 30
33 |  | 64 |  |  |  |  |  |  |  |  | 35 |  | 62
16 |  | 17 |  |  |  |  |  |  |  |  | 14 |  | 19
48 |  | 49 |  |  |  |  |  |  |  |  | 46 |  | 51
9 |  | 24 |  |  |  |  |  |  |  |  | 11 |  | 22
41 |  | 56 |  |  |  |  |  |  |  |  | 43 |  | 54
8 |  | 25 |  |  |  |  |  |  |  |  | 6 |  | 27
40 |  | 57 |  |  |  |  |  |  |  |  | 38 |  | 59
5 |  | 28 |  |  |  |  |  |  |  |  | 7 |  | 26
37 |  | 60 |  |  |  |  |  |  |  |  | 39 |  | 58
12 |  | 21 |  |  |  |  |  |  |  |  | 10 |  | 23
53 |  | 44 |  |  |  |  |  |  |  |  | 42 |  | 55
13 |  | 20 |  |  |  |  |  |  |  |  | 15 |  | 18
45 |  | 52 |  |  |  |  |  |  |  |  | 47 |  | 50
4 |  | 29 |  |  |  |  |  |  |  |  | 2 |  | 31
36 |  | 61 |  |  |  |  |  |  |  |  | 34 |  | 63
 |  |  |  |  |  | 5TH PLACE:
 |  |  |  |  |  | 6TH PLACE:
 |  |  |  |  |  | 7TH PLACE:
 |  |  |  |  |  | 8TH PLACE:
Spreadsheet: 936c1d96-eca4-4f83-afca-374c60aafcaf
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
40894812 | 2014-04-08 04:00:15 | AXIS | 1 | 7 | 3 | 386133 | jskimming | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40895135 | 2014-04-08 04:26:35 | ALLIES | 0 | 6 | 7 | 386133 | jskimming | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 1fe1b1a0-be6c-49f3-aa43-768ef6502001
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | State of New Hampshire
 |  | 2012 State Primary Election
 |  | Names on Checklist Worksheet
Instructions: This worksheet is to assist you in completing the Names on Checklist form.
Names on Checklist (NOC) Worksheet
 | Follow these STEPS |  |  |  | REP | DEM | UND | TOTAL
1) | Enter the number of voters by party on the
 | last page of the checklist.
2) | Enter the number of persons who registered
 | to vote at the polling place by party.
3) | Enter the number of Undeclared voters declaring |  |  |  |  |  |  | 0
 | a party and voting: (Count from the checklist.)
4) | Enter the number of Undeclared voters that |  |  |  |  |  |  | 0
 | returned back to Undeclared. (From Undeclared
 | Voter Re-registration" list with voter signatures.)
5) | TOTAL number of voters at the end of the
 | election by party.
 | Contact [NAME] at 271-8241 for help with the above worksheet.
 | Notes:
1) | Apply + and - signs to numbers you have entered, when completing a sum down or across.
2) | Line 3 and Line 4, when summed across, should equal zero.
3) | Line 5 total (on far right) should be the same sum down or across.
 | Town or City  ______________________   Ward _________ |  |  |  | County ____________________________
 | Prepared by _________________________________
Spreadsheet: 848457d1699195991-excel-formular-for-receipts-contents-invoice-vat-jacc
Sheet: Fiscal Tax Invoice

 | Kindly asking for excel formula to fill receipt contents using information from sales worksheet
 | The desired solution is on row B26
 | Fiscal Tax Invoice
 |  | Invoice Number |  | BK 006
 | Received From:
 | VAT Number
 | BP Number
 | Desired solution using information on sales worksheet
 | Description | Quantity | Unit Per Price | Amount | VAT | Net Amount
 | TOPPERS
 | GREEN
 |  | Total Net Amount
 |  | Total VAT
 |  | Invoice Total
Spreadsheet: 870275d1716814033-suitable-formula-for-matching-the-work-counter-code-for-each-name-for-each-date-roster-trial
Sheet: Hermes

NOV 2022 - HERMES BA WORKING SCHEDULE
Counter | Business Hour |  | Special Schedule |  | Period |  | A |  |  | B |  |  | C |  |  | W |  |  |  | Date | [NAME] |  |  |  | Time |  |  |  | OFF | 例假 |  | AL | 大假
LCTSQ | 10:00 - 22:00 |  | 10:00 - 21:00 |  | From 25 Feb |  | 9:30 - 18:30 |  |  |  |  |  | 12:00 - 21:00 |  |  | 9:30 - 21:00 |  |  |  | 2021-07-20 00:00:00 | Hermes Office Training (CR) |  |  |  | 1300-1445 |  |  |  | BD | 生日假 |  | SL | 病假
LCCR | 10:00 - 22:00 |  | 10:00 - 21:00 |  | From 25 Feb |  | 9:30 - 18:30 |  |  | 11:00 - 20:00 |  |  | 12:00 - 21:00 |  |  | 9:30 - 21:00 |  |  |  | 28 - 3 Aug | Sogo tunnel |  |  |  |  |  |  |  | SH | 法定假期 |  | NPL | 無薪假
SOGO CWB | 10:00 - 22:00 |  |  |  |  |  | 9:30 - 18:30 |  |  | 11:30 - 20:30 |  |  | 12:00 - 22:00 |  |  | 9:30 - 22:00 |  |  |  |  |  |  |  |  |  |  |  |  | PH | 公眾假期 |  | ML | 產假
SOGO TST | 10:00 - 22:00 |  | 11:00 - 20:00 |  | From 5 Feb |  | 10:30 - 19:30 |  |  |  |  |  | 11:00 - 20:00 |  |  | 10:30 - 20:00
updated on : |  |  |  | TSQ TUNNEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roadshow
Counter | Staff no. | Name | Tel no. | 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 | 1 | 2 | 3 | 4
 |  |  |  | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
SF60 LC CR |  | Promoter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | A | A | A | A | A
 |  | Promoter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | C | C | C | C | C
SF11 TSQ LC |  | Promoter |  |  | A | C | A | A | A |  | C | C | A | C |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | A | A | A | A | A
 |  | Promoter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | C | C | C | C | C
SF44 CWB SOGO |  | Promoter |  | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | A | A | A | A | A
 |  | Promoter |  | A | A | A | A | A |  |  | A | A | C | C |  |  | A | C |  | A | A |  |  |  | A | C | C |  |  |  | C | A | C | C | C | C | C
 |  | [NAME] |  |  |  |  |  |  |  |  | C | C |  |  |  |  |  | C |  |  |  |  |  |  | C |  |  |  |  |  | C | OFF | Roadshow
SF65 TST SOGO |  | Promoter |  | A | A | A | A | A | A | A | C | C | C | A | A | C | C | A | A | A | A | C | C | C | C | A | A | C | C | A | A | A | A | A | A | A | A
 |  | Promoter |  | C |  |  |  |  | C |  |  |  |  | C |  |  |  | C |  |  | C |  |  |  |  | C |  |  |  | C | C | C | C | C | C | C | C
Spreadsheet: 696527d1600874428-dynamic-table-creation-template_111-bluya-
Sheet: INFORMATION

 |  | First table |  |  | Second table
 |  | If sent date column (in the sending sheet) is an old date than A5 (in this sheet) write package unique number (in sending sheet) in C column and sent date (in sending sheet) in D column |  |  | If package unique number (in waiting sheet) is not in the Sending and sent excel sheet and written here column (in waiting sheet) is an old date than A5 (in information sheet) than write package unique number (in waiting sheet) in F column and sent data information (in waiting sheet) in H column
2020-09-01 00:00:00 |  | Package Unique number | Sent date |  | Package Unique number | Sent date
 |  | And In D column and G column, is it possible that mark month in different colors? For example, package passes A5 by 1 month, marks as orange and package passes A5 by 2 months, marks as red. It is enough only for two months.
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: 313 Calendar

 | 2020 | FEBRUARY |  | MONDAY |  | 313 Issue [NAME]
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  | 43851 | 43852 | 43853 | 43854 | 43855 | 43856
 |  | 2020-01-28 00:00:00 | 2020-01-29 00:00:00 | 2020-01-30 00:00:00 | 2020-01-31 00:00:00 | 2020-02-01 00:00:00 | 2020-02-02 00:00:00
 |  | 2020-02-04 00:00:00 | 2020-02-05 00:00:00 | 2020-02-06 00:00:00 | 2020-02-07 00:00:00 | 2020-02-08 00:00:00 | 2020-02-09 00:00:00
 |  | 2020-02-11 00:00:00 | 2020-02-12 00:00:00 | 2020-02-13 00:00:00 | 2020-02-14 00:00:00 | 2020-02-15 00:00:00 | 2020-02-16 00:00:00
 |  | 2020-02-18 00:00:00 | 2020-02-19 00:00:00 | 2020-02-20 00:00:00 | 2020-02-21 00:00:00 | 2020-02-22 00:00:00 | 2020-02-23 00:00:00
 |  | 2020-02-25 00:00:00 | 2020-02-26 00:00:00 | 2020-02-27 00:00:00 | 2020-02-28 00:00:00 | 2020-02-29 00:00:00 | 2020-03-01 00:00:00
 |  | 2020-03-03 00:00:00 | 2020-03-04 00:00:00 | 2020-03-05 00:00:00 | 2020-03-06 00:00:00 | 2020-03-07 00:00:00 | 2020-03-08 00:00:00
Spreadsheet: 462105d1463877786-function-match-issues-due-to-number-type-public
Sheet: Sheet1

 | Xvar | Yvar
 | BE02684 | 1.3
 |  | RP | BP | FIN
 | BE01820 | BE02511 | BE02520 | BE0182 | BE02684 | BE04076 | BE01820 | BE02511test | BE02511
0.2
0.3
0.4
0.5
0.6
0.7
0.8
1.1
1.1-0.2
1.1-2.0
1.2
1.2-0.3
1.2-2.1
1.2-3.0
1.3
1.3-0.4
1.3-2.2
1.3-3.1
1.3-4.0
1.4
1.4-3.2
1.4-4.1
1.5
1.5-0.6
1.5-6.0
1.6
1.6-2.5
1.7
2.0
2.0-0.2
2.0-1.1
2.1
2.1-0.3
2.1-1.2
2.2-0.4
2.2-4.0
2.2
2.2-1.3
2.3
2.3-0.5
2.3-1.4
2.3-3.2
2.3-4.1
2.4
2.4-0.6
2.4-6.0
2.4-1.5
2.4-3.3
2.4-4.2
2.5
2.5-0.7
2.6
2.6-1.7
2.6-4.4
3.0
3.0-0.3
3.0-1.2
3.0-2.1
3.1
3.1-0.4
3.1-1.3
3.1-2.2
3.1-4.0
3.2
3.2-0.5
3.2-1.4
3.2-4.1
3.3
3.3-0.6
3.3-1.5
3.3-2.4
3.3-4.2
3.3-6.0
3.4
3.4-0.7
3.4-2.5
3.4-4.3
3.5
3.5-2.6
3.5-4.4
4.0
4.0-0.4
4.0-1.3
4.0-2.2
4.0-3.1
4.1
4.1-0.5
4.1-1.4
4.2
4.2-0.6
4.2-1.5
4.3
4.3-0.7
4.4
4.4-3.5
4.4 -6.2
4.4-0.8
4.4-8.0
5.0
5.0-0.5
5.0-2.3
5.0-3.2
5.0-4.1
5.1
5.1-0.6
5.1-4.2
5.2
5.2-1.6
5.3
5.3-0.8
5.3-6.2
6.0
6.0-0.6
6.0-2.4
6.0-4.2
6.0-5.1
6.1
6.1-0.7
6.1-1.6
6.1-2.5
6.2
6.2-5.3
7.0
7.0-0.7
7.0-5.2
7.1
7.1-8.0
8.0
8.0-0.8
8.0-6.2
8.0-7.1
MhoB Open Data 3-2
MhoB Open Data 1-1
Spreadsheet: 86219d1286239912-how-to-lookup-multiple-rows-of-data-by-value-groupdata-1-
Sheet: Data

Group | Data 1 | Data 2 | Data 3 | Data 4 | Data 5
A | 77 | 2 | 3 | 4 | 5
A | 6 | 7 | 8 | 9 | 10
A | 11 | 12 | 13 | 14 | 15
A | 16 | 17 | 18 | 19 | 20
A | 21 | 22 | 23 | 24 | 25
A | 26 | 27 | 28 | 29 | 30
A | 31 | 32 | 33 | 34 | 35
B | 40 | 37 | 38 | 39 | 40
B | 41 | 42 | 43 | 44 | 45
B | 46 | 47 | 48 | 49 | 50
B | 51 | 52 | 53 | 54 | 55
B | 56 | 57 | 58 | 59 | 60
B | 61 | 62 | 63 | 64 | 65
B | 66 | 67 | 68 | 69 | 70
C | 71 | 72 | 73 | 74 | 75
C | 76 | 77 | 78 | 79 | 80
C | 81 | 82 | 83 | 84 | 85
C | 86 | 87 | 88 | 89 | 90
C | 91 | 92 | 93 | 94 | 95
C | 96 | 97 | 98 | 99 | 100
C | 101 | 102 | 103 | 104 | 105