tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 474947d1470982871-timestamping-images-and-file-size-timestamp-test-file-1
Sheet: Log

 |  |  |  | Weekly Status
Start Date: | 2016-08-12 00:00:00 | Interval: | 7 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15
Item No. | Current Status | Issue Date | Close Date
0001 | Closed | 2016-08-12 00:00:00 | 2016-08-26 00:00:00 | New | Processing | Closed | Closed
0002 | Processing | 2016-08-12 00:00:00 |  | New | Pending | Pending | Processing
0003 | Closed | 2016-08-12 00:00:00 | 2016-09-02 00:00:00 | New | Processing | Processing | Closed
0004 | Closed | 2016-08-19 00:00:00 | 2016-09-02 00:00:00 |  | New | Pending | Closed
0005 | Processing | 2016-08-19 00:00:00 |  |  | New | Pending | Processing
0006 | Closed | 2016-08-19 00:00:00 | 2016-09-02 00:00:00 |  | New | Processing | Closed
0007 | Processing | 2016-08-26 00:00:00 |  |  |  | New | Processing
0008 | Closed | 2016-08-26 00:00:00 | 2016-09-02 00:00:00 |  |  | New | Closed
0009 | Closed | 2016-08-26 00:00:00 | 2016-09-02 00:00:00 |  |  | New | Closed
0010 | Cancelled | 2016-08-26 00:00:00 |  |  |  | New | Cancelled
 |  |  |  | This is the current formula put into every cell of the chart (chart depth = 50x1500)
 |  |  |  | Snapshot of weekly status is recorded before moving on to next week.
 |  |  |  | Due to grid size, worried about future file size (fully automated sheet with (50x1500) and images)
 |  |  |  | =IF(AND($L15<=AA$11,$L15>Z$11),"New",IF(COUNTIF($T15:[NAME]:Z15,"Closed")>0,"",IF(AND(AA$11>=ProcessingDate,ProcessingDate>Z$11),IF($BT15="New",$E$7,$BT15),IF(AND(AA$11>$L15,AA$11<ProcessingDate,OR(AA15="Processing",AA15="Pending")),AA15,IF(AND(AA$11>$L15,AA$11<ProcessingDate),IF(AND($BT15="New",COUNTIF($T15:Z15,"New")>0),"Processing",IF(AA15="",$E$7,$E$7)),"")))))))
 |  |  |  | 1) Is there an easier method (excel or VBA) that makes the file smaller
 |  |  |  | 2) Ditto for including images as shown in Report page
Spreadsheet: 267197d1380005753-vlookup-function-excel-help
Sheet: Armstrong, Jason

[NAME], [NAME]
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 186780d1350217165-add-values-till-limit-is-breached-then-exclude-first-value-and-start-again-book1_ayros
Sheet: Sheet1

values | sum (limit = 200) | count |  | how it's calc.
55 | 55 |  |  | 55
65 | 120 |  |  | 55+65
70 | 190 |  |  | 55+65+70
45 | 235 | 4 |  | 55+65+70+45
10 | 190 |  |  | 65+70+45+10
30 | 220 | 5 |  | 65+70+45+10+30
55 | 210 | 5 |  | 70+45+10+30+55
40 | 180 |  |  | 45+10+30+55+40
40 | 220 | 6 |  | 45+10+30+55+40+40
Spreadsheet: 164892d1340955983-returning-values-based-on-date-falling-between-date-ranges-vlookup-true-date-calc-problem
Sheet: Sheet1

Variable value to be inputted by user | Needs the value appearing in column G,  if the value in A5 is (less than F5, then return G5), if its equal or more than F5 but less than F6, then return G6), if its equal or more than F6 but less than F7, then return G7 ) and so on……. |  |  | You need real dates like in Col E instead of what is in Col F.
2012-07-30 00:00:00 |  | <<Look at this formula |  | 2012-06-30 00:00:00 |  | 3
 |  |  |  | 2012-07-15 00:00:00 |  | 4
 |  |  |  | 2012-07-31 00:00:00 |  | 5
 |  |  |  | 2012-08-15 00:00:00 |  | 6
 |  |  |  | 2012-08-31 00:00:00 |  | 7
 |  |  |  | 2012-09-15 00:00:00 |  | 8
 |  |  |  | 2012-09-26 00:00:00 |  | 9
Spreadsheet: 770614d1646200197-extract-between-multiple-brackets-in-single-cell-extract_between_brackets
Sheet: Sheet1

Name | First Set | Second Set | Third Set | Fourth Set | Fifth Set
[NAME] (9867) [NAME] (868798) [NAME] (5434566) [NAME] (34566) [NAME] (372821) | 9867 | 868798 | 5434566 | 34566 | 372821
[NAME] (37262) Hank (7272) [NAME] (76543) | 37262 | 7272 | 76543
[NAME] (8654) | 8654
 |  | 868798 | 5434566 | 34566 | 372821
 | 37262 | 7272 | 76543
 | 8654
Spreadsheet: 77858d1278355033-excel-2007-averaging-no-blanks-and-no-zeros-over-several-sheets-test-monthly-1
Sheet: Summary 

 | Monthly Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TabNames
 |  |  |  |  |  | Tech Individual Ticket Closures |  |  |  |  |  |  |  |  |  |  |  | WK1 Mon
 | Desktop |  | Network |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK1 Tue
 | Opened |  | Opened |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK1 Wed
 | Closed |  | Closed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK1 Thu
 | Backlog |  | Backlog |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK1 Fri
 | Frozen |  | Frozen |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK2 Mon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK2 Tue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK2 Wed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK2 Thu
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK2 Fri
 | Active Install Tickets avg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK3 Mon
 | Install Tickets Frozen avg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK3 Tue
 | Install Tickets in Responded avg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK3 Wed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK3 Thu
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK3 Fri
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | WK4 Mon
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | WK4 Tue
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | WK4 Wed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK4 Thu
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK4 Fri
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK5 Mon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK5 Tue
 |  |  |  |  |  | Total Team |  |  |  |  |  |  |  |  |  |  |  | WK5 Wed
 |  |  |  |  |  | Team Averade |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WK5 Fri
Spreadsheet: 219691d1362883606-conditional-sum-excel-2010-drop-down-lists-2013-planting_2
Sheet: seed

 |  | PURCHASE |  |  |  |  |  | USED |  |  |  |  | LEFT
 | seed
# | variety | dennis | justin | jay | ron | total |  | dennis | justin | jay | ron
1 | 1151 AM |  |  | 9 | 9
2 | 1324 HR | 32 |  |  | 16
3 | 1498 HR | 48 |  |  | 32
4 | 1508 CHR | 32 | 32 |  | 30
5 | 1625 CHR |  |  |  | 30
6 | 1690 HR | 48
7 | 33D42 | 64 |  |  | 32
8 | 33D47 | 32 | 32 | 15 | 44
9 | 92y70 |  |  | 100
10 | 92y83 |  |  |  | 100
11 | DK 63-87 |  | 16
12 | DK 66-87 |  | 16
13
14
15
16
17
18
19
Spreadsheet: 789607d1659235712-top-3-top-3
Sheet: Sheet1

 |  |  |  | TOP 3 Highest tracking Codes
 | Company | Tracking Code |  | Rank | Company |  | Transporter ID |  |  | wk9128
 | 1TXC | A2VN9G8H5ES4N0 |  | 1 | RRS |  | OMW727A430497F1
 | CKU | OMWBC57C629DB7B |  | 2 | CKU |  | OMWBC57C629DB7B
 | RRS | OMW727A430497F1 |  | 3 | RRS |  | A3MA075FNMGQP
 | RRS | A3MA075FNMGQP
 | RRS | A3MA075FNMGQP
 | CKU | OMWBC57C629DB7B
 | RRS | OMW727A430497F1
 | RRS | OMW727A430497F1
 | RRS | OMW727A430497F1
 | CKU | OMWBC57C629DB7B
 | CKU | OMWBC57C629DB7B
 | CKU | OMWBC57C629DB7B
 | CKU | OMWBC57C629DB7B
 | RRS | OMW727A430497F1
 | VVP | OMW727A430497F2
 | VVP | OMW727A430497F2
 | VVP | OMW727A430497F2
 | VVP | OMW727A430497F2
Spreadsheet: 105399d1302767767-multiple-if-statements-in-1-formula-upload-ready-workbook
Sheet: Lookup table

LASER | Laser Printer Toners
PAPER | PAPER
FAX | Facsimile Toners
INK | Ink Cartridges
CALC | Calculators
HARD | Hardware & Office Equipment
COPIER | [NAME]
HACCESS | Hardware Accessories
PROMO | Promotions
RIB | Ribbons
BATTERY | Batteries
ANALOGUE COPIER | Analogue [NAME]
Media | ?
Warranty | ?
Spreadsheet: 267458d1380082850-capturing-and-saving-updated-data-from-fields-driven-by-selections-from-drop-down-menu-20130924-1230-mockup-mr-excel
Sheet: Sheet4

1 | CO 1
2 | CO 2
3 | CO 3
4 | SC 1 |  |  |  |  |  | 1 | 2
5 | SC 2
6 | SC 3 |  |  |  |  |  | 4 | 5
7 | A 1
8 | A 2 |  |  |  |  |  | 3 | 3
9 | A 3
10 | EM 1 |  |  |  |  |  | 5 | 6
11 | EM 2 |  |  |  |  |  | 2 | 3
12 | EM 3 |  |  |  |  |  | 2 | 2
13 | EM 4 |  |  |  |  |  | 4 | 5
14 | PR 1
15 | PR 2
16 | PR 3
17 | PR 4
Spreadsheet: 113733d1309546662-excel-2007-days-within-the-month-book6
Sheet: Sheet1

 |  |  |  |  |  |  | 1 | 2010 | apr
 |  |  |  |  |  |  | 2 | 2011 | may
 |  |  | Select Plan |  |  |  | 3 | 2012 | jun
 |  |  |  |  |  |  | 4 |  | jul
 |  |  | Select Year | 2011 |  |  | 5 |  | aug
 |  |  | Month | dec |  |  | 6 |  | sep
 |  |  | Day | 6 |  |  | 7 |  | oct
 |  |  |  |  |  |  | 8 |  | nov
 |  |  |  |  |  |  | 9 |  | dec
 |  |  |  |  |  |  | 10 |  | jan
 |  |  |  |  |  |  | 11 |  | feb
 |  |  |  |  |  |  | 12 |  | [NAME]
 |  |  |  |  |  |  | 13
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 16
 |  |  |  |  |  |  | 17
 |  | JUL. # of Business Days:(excluding Holidays) |  |  |  |  | 18
 |  | JUL. # of Days Elapsed |  |  |  |  | 19
 |  | JUL. % of Days Elapsed: |  |  |  |  | 20
 |  |  |  |  |  |  | 21
 |  |  |  |  |  |  | 22
 |  |  |  |  |  |  | 23
 |  |  |  |  |  |  | 24
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  | 26
 |  |  |  |  |  |  | 27
 |  |  |  |  |  |  | 28
 |  |  |  |  |  |  | 29
 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | 31
Spreadsheet: 48680d1247913728-copy-row-from-multiple-worksheets-based-on-column-value-in-to-summary-tab-sales-2009
Sheet: Jan

Date | Company | Details | Invoice No. | Net Amount | VAT | Total | Paper Reference | Date Invoice Sent | Date Papment Received
2009-01-01 00:00:00 | SOI | Web Site Work | 4 | 200 | 43 | 243 | J1 | 2009-05-03 00:00:00 | 2009-05-17 00:00:00
2009-01-01 00:00:00 | KPMG | Accounting Work | 5 | 50 | 10.75 | 60.75 | J2 | 2009-04-03 00:00:00 | Unpaid
Spreadsheet: 836176d1689155248-subtract-values-from-2-tables-and-return-in-a-3rd-table-sample39
Sheet: Sheet1

 |  |  |  | Table 1 | [NAME]}
 |  |  |  | Date | Employee | Wage | Balance
 |  |  |  | 2023-07-04 00:00:00 | Stefany | 150 | 950
 |  |  |  | 2023-07-05 00:00:00 | [NAME] | 100 | 805
 |  |  |  | 2023-07-05 00:00:00 | [NAME] | 210 | 750
 |  |  |  | 2023-07-06 00:00:00 | Timmy | 305 | 675
 |  |  |  | Table 2 | {Payroll} |  |  |  |  |  | Table 3 | {New Balance}
 |  |  |  | Date | Amount | Stefany | [NAME] | Timmy | [NAME] |  | Name | New Balance
 |  |  |  | 2023-08-20 00:00:00 |  |  |  |  |  |  | Stefany | 750
 |  |  |  | 2023-08-13 00:00:00 |  |  |  |  |  |  | [NAME] | 405
 |  |  |  | 2023-08-06 00:00:00 |  |  |  |  |  |  | Timmy | 375
 |  |  |  | 2023-07-30 00:00:00 |  |  |  |  |  |  | [NAME] | 650
 |  |  |  | 2023-07-23 00:00:00
 |  |  |  | 2023-07-16 00:00:00
 |  |  |  | 2023-07-09 00:00:00 | 1000 | 200 | 400 | 300 | 100
Spreadsheet: 24fefe46-c5e8-45c9-bb18-26eef5a1e479
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Country | 2012/13 | 2011/12 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | August 2012 to | August 2011 to | market | market | market | market
region | May 2013 | May 2012 | year | year | year | year
 |  |  | 1,000 metric tons
ASIA | 518.625 | 457.693 | 541.563 | 529.833 | 563.943544 | 536.401387
China | 2.571 | 2.805 | 3.571 | 3.1 | 3.786815 | 3.951477
India | 105.259 | 92.77 | 110.58 | 96.454 | 94.809691 | 74.049801
Pakistan | 13.078 | 12.534 | 15.258 | 17.297 | 19.386689 | 16.851572
Thailand | 334.307 | 328.692 | 387.642 | 393.464 | 400.976938 | 422.132044
Vietnam | 60.584 | 18.441 | 21.664 | 15.601 | 41.55395 | 17.477892
Other | 2.825999999999965 | 2.450999999999997 | 2.84800000000007 | 3.916999999999916 | 3.429461 | 1.938601
EUROPE & FSU | 10.474 | 11.711 | 14.236 | 12.485 | 9.411 | 7.564
Italy | 6.406 | 7.009 | 8.201 | 7.53 | 6.220285 | 5.73241
Spain | 2.144 | 3.47 | 4.671 | 3.753 | 1.55218 | 0.419219
Russia | 0.039 | 0.022 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0.112 | 0.057 | 0.039 | 0.009 | 0.126368 | 0.429608
Other | 1.773 | 1.153 | 1.301 | 1.158999999999999 | 1.479725 | 0.9183070000000002
WESTERN HEMISPHERE | 29.827 | 56.2 | 64.526 | 42.735 | 30.357 | 31.065164
Argentina | 4.062 | 2.639 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 4.21 | 28.144 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 9.921 | 13.766 | 16.323 | 17.067 | 15.358 | 18.035834
Mexico | 0.766 | 0.889 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 10.747 | 10.669 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 0.1210000000000004 | 0.09300000000000175 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 1.468000000000004 | 0.8220000000000596 | 0.966000000000065 | 3.532636 | 5.470538 | 39.298261
Egypt | 0.593 | 0.001 | 0 | 0 | 0.645 | 36.591199
United Arab Emirates | 0.269 | 0.484 | 0.522 | 3.03 | 4.441327 | 2.224564
Other | 0.6060000000000035 | 0.3370000000000596 | 4.2 | 0.5 | 0.384703 | 0.482498
TOTAL | 560.394 | 526.426 | 621.291 | 588.611 | 609.182 | 614.331
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated July 12, 2013.
Spreadsheet: 820360d1678060116-how-to-tweak-formula-to-change-calendar-to-include-date-range-book_251717-4
Sheet: Event Log

Event Number | Event Name | Event Start Date | Event End Date | End date code | Event duration | Primary Contact | Organisation | Contact Email | Event Location | Online | Contact Phone | Event Sectors | Column1 | Column2 | Approved by Committee | Website | [NAME] | Column3 | Column4
 | Event 1 ya | 2023-09-28 00:00:00 | 2023-10-02 00:00:00 |  |  | Contact 1 | Org from Contact 1 | [NAME] | Online
 | Event 2 tootle | 2023-09-30 00:00:00 | 2023-10-01 00:00:00 |  |  | Contact A | Org from Contact A | emailfromcontactA@doodoo | Venue TBC
 | Event 3 babi | 2023-01-10 00:00:00 |  |  |  | asdf | sdfasdf
 | Event 4 yernow | 2023-10-02 00:00:00 | 2023-10-04 00:00:00 |  |  | asdf | asdfsdf
 | Event 5 something | 2023-10-02 00:00:00 |  |  |  | asdf asdf | asdfasdf
 | Event 6 now | 2023-09-28 00:00:00 |  |  |  | dfasdf | asdf
 |  |  |  |  |  | sdfa
 |  |  |  |  |  | asdfasdf | asdf
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Schd - Pwr

Scheduling - Power Logistics
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90011269 | BENTLEY, CORRY K | Mgr Trading Supt | MGR-CS
90153305 | BISHOP, SERENA N | Analyst - Rotation 1 | ANL-C
90123464 | BURNETT, LISA A | Spec Sr Trading Supt | SPECSR-CS
90011281 | CHOATE, [NAME] | Spec Sr Trading Supt | SPECSR-CS
90011272 | COULTER, EDWIN K | Mgr Trading Supt | MGR-CS
90007176 | CUTSFORTH, [NAME] | Staff Trading Supt | SPECJR-CS
90012364 | DAY, SMITH L | Mgr Trading Supt | MGR-CS
90012369 | FREELAND-SEMPERGER, CARA L | Spec Sr Trading Supt | SPECSR-CS
90011266 | GILBERT, [NAME] | Spec Sr Trading Supt | SPECSR-CS
90011274 | HANSE, PATRICK E | Spec Sr Trading Supt | SPECSR-CS
90012371 | MILLER, JEFFREY S | Mgr Trading Supt | MGR-CS
90012366 | PLATTER, M PHILLIP | Spec Sr Trading Supt | SPECSR-CS
90012363 | ROBINSON, [NAME] | Spec Trading Supt | SPEC-CS
90005935 | RUNSWICK, STACY | Staff Trading Supt | SPECJR-CS
 |  | Employees
Spreadsheet: sally_beck__35334__cashcoll0901(1)
Sheet: LPG

LPGs - Balances >$50,000
Counterparty | Amount | Due Dates | Paid | Desk
BP AMOCO | 141890.18 | 2001-09-17 00:00:00 | 2001-09-19 00:00:00 | NGL
CHEVRON PHILLIPS | 556500 | 2001-09-11 00:00:00 | 2001-09-24 00:00:00 | NGL
DUPONT | 873141.74 | 2001-09-11 00:00:00 | 2001-09-14 00:00:00 | NGL
DUPONT | 739028.8 | 2001-09-11 00:00:00 | 2001-09-25 00:00:00 | NGL
Dynegy Liquids Marketing and Trade | 355425 | 2001-09-28 00:00:00 |  | NGL
ExxonMobil Chemical Co | 116025 | 2001-09-11 00:00:00 | 2001-09-20 00:00:00 | NGL
ExxonMobil Chemical Co | 2503200 | 2001-09-24 00:00:00 |  | NGL
Louis Dreyfus Energy Services L.P. | 367500 | 2001-09-27 00:00:00 |  | NGL
Natrogas, Inc. | 178500 | 2001-08-30 00:00:00 | 2001-09-04 00:00:00 | NGL
Natrogas, Inc. | 161332.5 | 2001-09-06 00:00:00 | 2001-09-10 00:00:00 | NGL
Natrogas, Inc. | 462446.25 | 2001-09-11 00:00:00 | 2001-09-20 00:00:00 | NGL
Natrogas, Inc. | 381675 | 2001-09-24 00:00:00 |  | NGL
Natrogas, Inc. | 182700 | 2001-09-27 00:00:00 |  | NGL
NGL Supply, Inc. | 219975 | 2001-09-28 00:00:00 |  | NGL
Shell Oil Company | 74160 | 2001-09-19 00:00:00 |  | NGL
[NAME], Inc. | 493500 | 2001-09-28 00:00:00 |  | NGL
TRAFIGURA | 568050 | 2001-09-11 00:00:00 | 2001-09-19 00:00:00 | NGL
VEBA | 568050 | 2001-09-11 00:00:00 | 2001-09-21 00:00:00 | NGL
Total
Unpaid @ 09/30/01 | 4578135
excludes intercompany
Spreadsheet: 72c196ba-a48d-4985-ad45-b714cfff6588
Sheet: Sheet1

Table S1. Ez::TNhyg insertion sites | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Ez::TNhyg insertion sites |  |  |  |  |  | M.tuberculosis H37Rv gene/M.bovis gene
CAGGTGCTGGAAGCCTTGATCCCGGCGGTCATC |  |  |  |  |  | Rv0142 Mb0147
GCAATACGCCAAGTCCAGCGCCGATCTCGCACG |  |  |  |  |  | Rv0200 Mb0206
TCGACCTGTCTGGCGTGTCGCACCGGCTGGCCG |  |  |  |  |  | Rv0359 Mb0366
CTACCGGGGTTCGGGTTGCCTGAGTCCAGGCCG |  |  |  |  |  | Rv0442c Mb0450c
CCCAGACCATCAGCTCGACCCCGTCGTAAGCCA |  |  |  |  |  | Rv0498 Mb0509
TTGCGGTAGGCGGGCAGCCGGTTGGTCTGCGGA |  |  |  |  |  | [NAME]
GCACCTGACGCTCGCACTACCGCTGTAATGTCT |  |  |  |  |  | Rv1093   Mb1123
GCGCCGTGCCCTGGTCTTGGCGGTGCTGGTCGG |  |  |  |  |  | Rv1249c Mb1281c
CCGACCACAGCGAGCAACAATACTGAGACGGTC |  |  |  |  |  | Rv1490 Mb1527
GAAGTTTGTCTTGGCGGTCCACGGAACCCGCGG |  |  |  |  |  | Rv1526c Mb1553c
GATCGAGGCGATGTTGAGCACCGCACCGGCGCC |  |  |  |  |  | Rv1544 Mb1571
GTGCCGTGCGACGGCCGCACCCCACTGTGCGCC |  |  |  |  |  | Rv1639c Mb1666c
GTGGGCTACCGCGCCTCGGTGCCTACACCGACG |  |  |  |  |  | Rv1794-95 Mb1822-23
GGACTTGTAGGACGGTACGTCGAGCTTGGTCGC |  |  |  |  |  | Rv1915 Mb1950
GTTCGTCGCCGAGCATCGAGCCCGGTTCGAGGT |  |  |  |  |  | Rv2024c-25c Mb2049c-50c
GGCGCTCGCGCTGCCCTCGGCGGGCCGCGACCA |  |  |  |  |  | Rv2161c Mb2185c
AAGCAGCGACCTTGCAAGCCTACCGCCCGGCCA |  |  |  |  |  | Rv2209 Mb2232c
CGCCGACAGGGCGTATAACACATGACGGCCTGG |  |  |  |  |  | Rv2270 Mb2293
CCTGCTGGACAGCGGCGACATTGGCGCGGCCGG |  |  |  |  |  | Rv2298 Mb2320
TGGCAGTCAGTGGGTCGGCCCCATCACCAACTT |  |  |  |  |  | Rv2301 Mb2323
AACGTACAGCGCTGCCCTGGCCGCAGAAGAGTG |  |  |  |  |  | Rv2331A Mb2359
AGTCGGGCTATATGTTTCATTCAGACGAGAGGC |  |  |  |  |  | [NAME]
TCCCGGTCCTGGATCCGGATGAGGTCTGCTTCG |  |  |  |  |  | Rv2506 Mb2534
AAGTCCCACGGCCCCCAAGGCACCGTAATGCGC |  |  |  |  |  | Rv2940 Mb2965c
[NAME] |  |  |  |  |  | Rv3236c Mb3264c
TCCGTGCGGCGGGGACATCGAAGCTGAGATGTG |  |  |  |  |  | Rv3373 Mb3408
CGATGTCCACCAGCACCACTGCGCTGAGCAATG |  |  |  |  |  | [NAME]
GCCGCCGACTCCGCTCTGGCCCGACCAGCTCGG |  |  |  |  |  | Rv3707c Mb3734c
TTCCCGCGCGAGGGTCTGGCCGGGTCGCGGAAT |  |  |  |  |  | Rv3746c Mb3772c
AGCGACCGGCAGTGTGAAGTCCATCGCCGTCGG |  |  |  |  |  | [NAME]
NNNNNNNNNNNNGgNcNNNNCNNNNNNNgNNNN |  |  |  |  |  | Consensus (>50% in lower case, >60% in upper case)
Spreadsheet: 681384d1591539326-vlookup-function-finding-data-from-formula-result-excel-example
Sheet: Sheet1

 |  |  |  | valid | tmpc |  |  |  |  |  |  |  |  | valid | tmpc
 |  |  |  | 00:56:00 |  |  |  |  |  |  |  |  |  | 2020-03-03 00:56:00 | 20.22
 |  |  |  | 01:56:00 |  |  |  |  |  |  |  |  |  | 2020-03-03 01:56:00 | 19.72
 |  |  |  | 02:56:00 |  |  |  |  |  |  |  |  |  | 2020-03-03 02:56:00 | 20.11
 |  |  |  | 03:56:00 |  |  |  |  |  |  |  |  |  | 2020-03-03 03:56:00 | 20
 |  |  |  | 04:56:00 |  | EXAMPLE OF COLUMN M CONTAINING NO FORMULA --> |  |  |  |  |  | 04:56:00 |  | 2020-03-03 04:56:00 | 19.89
Spreadsheet: 38340d1236469819-display-data-in-horizontal-format-task2-4
Sheet: Sheet1

Current Format
Material | Component | component category
123456 | [NAME] | label
123456 | VVV | label
123456 | YYY | carton
123456 | ZZZ | bottle
123456 | AAA | cap |  |  |  |  |  |  |  |  |  |  |  | CCC | TTT
123456 | WWW | cap
123457 | BBB | tube
123457 | [NAME] | label
123458 | ZZZ | bottle
123458 | GGG | nozzle
123458 | VVV | label
123458 | JJJ | tin
123458 | [NAME] | label
123458 | QQQ | label
123458 | KKK | can
123458 | BBB | tube
123458 | EEE | carton
123458 | LLL | leaflet
123459 | UUU | box
123460 | BBB | tube
123460 | YYY | carton
123460 | CCC | pin
123460 | TTT | syringe
 |  |  |  |  |  | Required format
 |  |  |  |  |  |  | Label | Label | Label | carton | bottle | cap | cap | tube | nozzle | tin | can | leaflet | box | pin | syringe
 |  |  |  |  |  | 123456 | [NAME] | VVV |  | YYY | ZZZ | AAA | WWW
 |  |  |  |  |  | 123457 | [NAME] |  |  |  |  |  |  | BBB
 |  |  |  |  |  | 123458 | [NAME] | VVV | QQQ | EEE | ZZZ |  |  | BBB | GGG | JJJ | KKK | LLL
 |  |  |  |  |  | 123459 |  |  |  |  |  |  |  |  |  |  |  |  | UUU
 |  |  |  |  |  | 123460 |  |  |  | YYY |  |  |  | BBB |  |  |  |  |  | CCC | TTT
Spreadsheet: 0ff25ebc-3fa2-4fc5-8904-a6fbbc9cd04d
Sheet: Read_Me_First

 | COSME - Enterprise Europe Network - Consortium Preliminary Work Programme (2015-2016) - Annex 1, 2 & 3
 | Every Coordinator must use this EXCEL workbook:  -  to encode their Consortium's PES targets per partner for the 2015-2016 period in Annex 1 of the Preliminary Work Programme ('Encode_PES' sheet); -  to encode the hours planned for the 2015-2016 period per partner and per activity in Annex 2 of the Preliminary Work Programme ('Encode_HRS' sheet); -  to encode the Consortium's services in the matrix of Annex 3 of the Preliminary Work Programme ('Encode_Services' sheet). Encode one service per line and if needed add lines. For each service indicate the corresponding type of activity in the first column; -  to indicate with "X" the services provided by each individual partner in the matrix "Consortium's services" in Annex 3 of the Preliminary Work Programme ('Encode_Services' sheet).  Annex 1, 2 & 3 should be attached to the Preliminary Work Programme and submitted as an integral set.
 |  | Work Programme duration: | 24m
 |  | Enter below your Consortium's ACRONYM
 |  |  |  | * mandatory
 |  | Enter here the highest Partner number in your Consortium  >  (integer) > |  | * mandatory
 |  | Enter below your partner's name(s)
 | Partner # | Partner name | Partner acronym