tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 315c413c-cbe3-4230-ab5b-fee45c1588b7
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Oct. 6 - Oct. 10
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | - | - | -
 | Top (A) | 10349 | 17226 | 73273 | 10370 | 17139 | 30275 | - | - | -
 | Center (A) | 10305 | 17217 | 73359 | 10346 | 17146 | 30015 | - | - | -
 | Flat (A) | 10338 | 17249 | 72404 | 10358 | 17119 | 30196 | - | - | -
 | Left  (A) | 10330 | 17218 | 73434 | 10314 | 17146 | 30201 | - | - | -
 | Right (A) | 10333 | 17228 | 73411 | 10360 | 17122 | 30519 | - | - | -
 | Average (A) | 10331 | 17228 | 73376 | 10366 | 17134 | 30241 | - | - | -
 | [NAME]  (A) | 16 | 13 | 64 | 18 | 13 | 182 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.4s | 3.0s x2 | 1.0s | 1.4s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00
 | Top (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 1.5/2.5 | 1/1.5 | 1.5/1.5 | 2/2.5
 | Center (H/V) (um) | 1.5/1.5 | 1/1.5 | 2/2 | 1/1.5 | 1.5/1.5 | 2/2
 | Flat (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2.5/2.5 | 1/1.5 | 1.5/1.5 | 2/2
 | Left (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2.5/2 | 1/1.5 | 1.5/1.5 | 2.5/2.5
 | Right (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 1.5/2.5 | 1/1.5 | 1.5/1.5 | 2/2.5
 | Comments |  |  |  |  | slight lifting 1um lines
Spreadsheet: 463484d1464597546-format-only-cells-that-sum-of-values-is-higher-than-comparing-value-plan
Sheet: Hárok1

 |  |  |  |  |  |  |  |  | Plan | 10
 | Date: | Fri | Mon | Tue | Wed | Thu | Fri
 |  | 2016-04-01 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00
ID078 |  | 1 | 3 | 2 | 5 | 3 | 1
Goal
 | Date: | Fri | Mon | Tue | Wed | Thu | Fri
 |  | 2016-04-01 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00
ID078 |  | 1 | 3 | 2 | 5 | 3 | 1
 |  |  |  |  | ^
 |  |  |  |  | SUM(C10:[NAME]) is higher than K1
Spreadsheet: 730808d1619962841-highlighting-cells-between-columns-in-a-row-cf-example-time-chart-aligw
Sheet: Sheet1

Event | Start | End | Category | 1800 | 1801 | 1802 | 1803 | 1804 | 1805 | 1806 | 1807 | 1808 | 1809 | 1810 | 1811 | 1812 | 1813 | 1814 | 1815 | 1816 | 1817 | 1818 | 1819 | 1820 | 1821 | 1822 | 1823 | 1824 | 1825 | 1826 | 1827 | 1828 | 1829 | 1830 | 1831 | 1832 | 1833 | 1834 | 1835 | 1836 | 1837 | 1838 | 1839 | 1840 | 1841 | 1842 | 1843 | 1844 | 1845 | 1846 | 1847 | 1848 | 1849 | 1850 | 1851 | 1852 | 1853 | 1854 | 1855 | 1856 | 1857 | 1858 | 1859 | 1860 | 1861 | 1862 | 1863 | 1864 | 1865 | 1866 | 1867 | 1868 | 1869 | 1870 | 1871 | 1872 | 1873 | 1874 | 1875 | 1876 | 1877 | 1878 | 1879 | 1880 | 1881 | 1882 | 1883 | 1884 | 1885 | 1886 | 1887 | 1888 | 1889 | 1890 | 1891 | 1892 | 1893 | 1894 | 1895 | 1896 | 1897 | 1898 | 1899 | 1900 | 1901 | 1902 | 1903 | 1904 | 1905 | 1906 | 1907 | 1908 | 1909 | 1910 | 1911 | 1912 | 1913 | 1914 | 1915 | 1916 | 1917 | 1918 | 1919 | 1920 | 1921 | 1922 | 1923 | 1924 | 1925 | 1926 | 1927 | 1928 | 1929 | 1930 | 1931 | 1932 | 1933 | 1934 | 1935 | 1936 | 1937 | 1938 | 1939 | 1940 | 1941 | 1942 | 1943 | 1944 | 1945 | 1946 | 1947 | 1948 | 1949 | 1950 | 1951 | 1952 | 1953 | 1954 | 1955 | 1956 | 1957 | 1958 | 1959 | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
1 | 1823 | 1901
2 | 1801 | 1831
3 | 1911 | 1952
4 | 1899 | 1977
5 | 1810 | 1844
6 | 1880 | 1932
7 | 1827 | 1948
8 | 1836 | 1886
9 | 1963 | 2007
10 | 1995 | 2015
Spreadsheet: 768376d1644939938-vacation-calendar-salary-vacation-example
Sheet: Data

Employee Name | FILE# | Occur Date | Vacation
Employee 1 |  | 2022-01-10 00:00:00 | 2
Employee 10 |  | 2022-01-01 00:00:00 | 12
Employee 10 |  | 2022-01-02 00:00:00 | 12
Employee 10 |  | 2022-01-03 00:00:00 | 12
Employee 11 |  | 2022-01-28 00:00:00 | 1
Employee 12 |  | 2022-01-21 00:00:00 | 2
Employee 13 |  | 2022-01-18 00:00:00 | 12
Employee 13 |  | 2022-01-19 00:00:00 | 12
Employee 14 |  | 2022-01-07 00:00:00 | 8
Employee 14 |  | 2022-01-25 00:00:00 | 8
Employee 14 |  | 2022-01-26 00:00:00 | 8
Employee 15 |  | 2022-01-10 00:00:00 | 0.5
Employee 15 |  | 2022-01-14 00:00:00 | 1
Employee 15 |  | 2022-01-31 00:00:00 | 1
Employee 2 |  | 2022-01-13 00:00:00 | 2.5
Employee 3 |  | 2022-01-03 00:00:00 | 8
Employee 3 |  | 2022-01-04 00:00:00 | 8
Employee 3 |  | 2022-01-20 00:00:00 | 4
Employee 4 |  | 2022-02-01 00:00:00 | 8
Employee 5 |  | 2022-01-31 00:00:00 | 12
Employee 6 |  | 2022-01-21 00:00:00 | 1
Employee 7 |  | 2022-01-04 00:00:00 | 8
Employee 7 |  | 2022-01-05 00:00:00 | 8
Employee 7 |  | 2022-01-06 00:00:00 | 8
Employee 7 |  | 2022-01-07 00:00:00 | 8
Employee 7 |  | 2022-01-28 00:00:00 | 8
Employee 8 |  | 2022-02-03 00:00:00 | 8
Employee 9 |  | 2022-01-16 00:00:00 | 12
Employee 1 |  |  | 2
Employee 10 |  |  | 12
Employee 10 |  |  | 12
Employee 10 |  |  | 12
Employee 11 |  |  | 1
Employee 12 |  |  | 2
Employee 13 |  |  | 12
Employee 13 |  |  | 12
Employee 14 |  |  | 8
Employee 14 |  |  | 8
Employee 14 |  |  | 8
Employee 15 |  |  | 0.5
Employee 15 |  |  | 1
Employee 15 |  |  | 1
Employee 2 |  |  | 2.5
Employee 3 |  |  | 8
Employee 3 |  |  | 8
Employee 3 |  |  | 4
Employee 4 |  |  | 8
Employee 5 |  |  | 12
Employee 6 |  |  | 1
Employee 7 |  |  | 8
Employee 7 |  |  | 8
Employee 7 |  |  | 8
Employee 7 |  |  | 8
Employee 7 |  |  | 8
Employee 8 |  |  | 8
Employee 9 |  |  | 12
 |  |  |  |  | Canceled
Spreadsheet: 829985d1684597748-how-to-select-invitees-from-a-list-sample-invitees
Sheet: Sheet1

District | Branch | Code | [NAME] | County | Manager |  |  | Seed | 345
1 | 188 | CA | Main | Los Angeles | [NAME]
1 | 454 | CA | North | North Pole | [NAME]
1 | 345 | CA | South | [NAME] | [NAME] |  |  |  | [NAME]
1 | 678 | CA | Left | George | [NAME] |  |  | 2 | Haley
1 | 756.5 | CA | Right | Los Angeles | Jon |  |  | 3 | CJ
1 | 892.6 | CA | [NAME] | North Pole | Aleia |  |  | 4 | Pryce
2 | 1028.7 | CA | White | [NAME] | Turley |  |  | 5 | Wake
2 | 1164.8 | CA | DT | George | Culla |  |  | 6 | [NAME]
2 | 1300.9 | CA | UP | Los Angeles | Maggi |  |  | 7 | [NAME]
2 | 1437 | CA | Soutwest | North Pole | Haley
2 | 1573.1 | CA | Bourbon | [NAME] | [NAME]
3 | 1709.2 | CA | Westbank | George | [NAME]
3 | 1845.3 | CA | Largo | Los Angeles | Nia
3 | 1981.4 | CA | Banks | North Pole | CJ
4 | 2117.5 | CA | Blue | [NAME] | Pryce
4 | 2253.6 | CA | Worthington | George | Guilford
5 | 2389.7 | CA | Mainsouth | Los Angeles | Wake
5 | 2525.8 | CA | Mainnorth | North Pole | Crispin
5 | 2661.9 | CA | Joint | [NAME] | George
6 | 2798 | CA | Beaker | George | [NAME]
6 | 2934.1 | CA | Weston | Los Angeles | [NAME]
7 | 3070.2 | CA | [NAME] | North Pole | [NAME]
7 | 3206.3 | CA | Willa | [NAME] | [NAME]
Spreadsheet: 502e9a8a-e7a7-4773-81e2-968220be8f14
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
43501499 | 2014-10-09 05:15:53 | AXIS | 0 | 0 | 5 | 465599 | Timor | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43501588 | 2014-10-09 05:33:02 | ALLIES | 0 | 4 | 5 | 465599 | Timor | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43656319 | 2014-10-20 02:43:25 | AXIS | 0 | 1 | 5 | 144495 | camwhit | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43656420 | 2014-10-20 03:01:58 | ALLIES | 1 | 5 | 2 | 144495 | camwhit | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 872903d1719356426-sumproduct-sum-date-range-down-to-second-transactions-sample-2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  | SUM SHOULD BE:
FRIDAY |  |  |  |  |  |  |  |  |  |  |  | 499 | 25475
START TIME | END TIME |  |  |  |  |  |  |  |  |  |  | TRANSACTIONS | AMOUNT
00:00:00 | 00:59:59
01:00:00 | 01:59:59
02:00:00 | 02:59:59
03:00:00 | 03:59:59
04:00:00 | 04:59:59
05:00:00 | 05:59:59
06:00:00 | 06:59:59
07:00:00 | 07:59:59
08:00:00 | 08:59:59
09:00:00 | 09:59:59
10:00:00 | 10:59:59
11:00:00 | 11:59:59
12:00:00 | 12:59:59
13:00:00 | 13:59:59
14:00:00 | 14:59:59
15:00:00 | 15:59:59
16:00:00 | 16:59:59
17:00:00 | 17:59:59
18:00:00 | 18:59:59
19:00:00 | 19:59:59
20:00:00 | 20:59:59
21:00:00 | 21:59:59
22:00:00 | 22:59:59
23:00:00 | 23:59:59
 |  |  |  |  |  |  |  |  |  |  | TOTAL:
Spreadsheet: 061b9c9e-c4db-4cb9-b0e6-1e33f91679ec
Sheet: Energy & Clean Tech

Total Venture Capital and Corporate Venture Capital in Energy and Clean Tech Deals
01/01/2012- 06/30/2013
Chart #1
MoneyTree Sector | Total # Deals | % of Total Deals | % of Clean Tech deals | $M Invested | % of Total Investment | % of Clean Tech $
All sectors - US Venture Capital
Clean Technology Deals Only | 375 |  |  | 4057.22
Corporate VC Investment Deals  in Clean Technology companies | 74 |  |  | 577.09
Chart #2
 | # Deals |  |  | $M Invested
Total Corporate VC Investment
% of Total CVC Investment Going to Clean Tech
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 756138d1637302958-can-i-dynamically-reference-the-same-cell-across-multiple-worksheets-in-if-and-textjoin-therapists-availability2-copy
Sheet: Person3

Person3 | Monday | Tuesday | Wednesday | Thursday | Friday
07:30:00 |  | e/o week | Weekly |  | Filled
08:15:00 |  | Filled | Filled |  | Filled
09:00:00 |  | Filled | Weekly |  | Filled
09:45:00 |  | unavailable | unavailable |  | unavailable
10:30:00 |  | unavailable | unavailable |  | unavailable
11:15:00 |  | Filled | Filled |  | Weekly
12:00:00 |  | unavailable | unavailable |  | unavailable
01:00:00 |  | Filled | Filled |  | Filled
01:45:00 |  | Weekly | Filled |  | e/o week
02:30:00 |  | Filled | Filled |  | Filled
03:15:00 |  | Filled | e/o week |  | Filled
04:00:00 |  | Filled | Filled |  | Filled
04:45:00 |  | Filled | Filled |  | Filled
05:30:00 |  | Filled | Filled |  | Weekly
Person3 (w)
Person3 (e/o)
Spreadsheet: 869386d1715953289-count-unique-using-2-criteria-unique-number-per-sport-2-aligw
Sheet: Sheet1

[NAME] | Football
[NAME] | Golf
[NAME] | Rugby
[NAME] | Golf |  |  |  | Sport | Unique of Players
[NAME] | Cricket |  |  |  |  | 1
[NAME] | Football |  |  |  | Cricket | 2
[NAME] | Golf |  |  |  | Football | 3
[NAME] | Rugby |  |  |  | Golf | 2
[NAME] | Football |  |  |  | Rugby | 3
[NAME] | Rugby |  |  |  | Tennis | 1
[NAME] | Rugby |  |  |  | Volleyball | 1
Ringo | Football
Ringo | Bowls
Ringo | Golf
Ringo | Cricket
Ringo | Bowls
George | Rugby
George | Volleyball
George | Rugby
George | Tennis
Spreadsheet: 884954d1734357063-formula-timeline-help-if-and-f-1-b2-f-1-c2-1-0-dashboard-timeline-help_2
Sheet: query (6)

Status | WP ID | Work Package Name | Work Package Owner | Project Manager | Work Package Support | Dependency on another project | Start Date | Baseline End Date | Current End Date
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-04-30 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2025-05-01 00:00:00 | 2025-10-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-06-27 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2024-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2026-01-01 00:00:00
 |  |  |  |  |  |  | 2025-06-02 00:00:00 | 2025-06-30 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-06-30 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-02-28 00:00:00
 |  |  |  |  |  |  | 2025-04-01 00:00:00 | 2025-05-30 00:00:00
 |  |  |  |  |  |  | 2025-04-01 00:00:00 | 2025-07-31 00:00:00
 |  |  |  |  |  |  | 2025-03-02 00:00:00 | 2025-10-31 00:00:00
 |  |  |  |  |  |  | 2025-03-03 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2024-12-27 00:00:00
 |  |  |  |  |  |  | 2025-04-01 00:00:00 | 2025-12-31 00:00:00
Spreadsheet: 0907be3c-9fd1-4f86-9fd8-fc302ab79566
Sheet: Table VI.4

Table VI.4 الجدول
Hazardous Waste (tons)
النفايات الخطرة (طن)
Hazardous waste generated (tons) |  |  |  | Hazardous waste managed (tons)
كمية النفايات الخطرة المنتجة سنوياً (طن) |  |  |  | كمية النفايات الخطرة المتصرف بها داخل البلد سنوياً (طن)
 | 2007 | 2008 | 2009 | 2007 | 2008 | 2009
Bahrain | 35,008a/ | … | … | ... | ... | … | البحرين
Egypt | 692,000b/ | … | … | ... | ... | … | مصر
Iraq | … | 2,338c/, 1 | 373d/, 2 | ... | ... | … | العراق
Jordane/ | 224437 | 12938043 | 108403 | 224437 | 1293804 | 108403 | الأردن
Kuwait | ... | … | … | 60,000c/ | ... | … | الكويت
Lebanon | ... | … | … | … | ... | … | لبنان
Oman | ... | … | … | ... | ... | … | عمان
Palestine | 4,548c/ | 11,886c/ | 14,423c/ | 4,548a/ | 11,886c/ | 14,423c/ | فلسطين
Qatar | 7,224c/ | 11,898c/ | … | 7,224c/ | 11,098c/ | … | قطر
Saudi Arabia | ... | … | … | ... | ... | … | المملكة العربية السعودية
The Sudan | ... | … | … | ... | ... | … | السودان
The Syrian Arab Republic | ... | … | … | ... | ... | … | الجمهورية العربية السورية
The United Arab Emirates | ... | … | 272,855c/ | ... | ... | … | الإمارات العربية المتحدة
Yemen | ... | … | … | … | ... | … | اليمن
Sources: | a/ | UNSD/UNEP questionnaire on environment statistics 2008.
 | [NAME] | Egypt State of the Environment Report 2008, June 2009.
 | c/ | UNSD/UNEP Environment Questionnaire on Environment Statistics 2010.
 | d/ | Environmental Statistics in Iraq Report 2009, COSIT, 2010.
 | e/ | DOS reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.
Note: | 1 | Results of the Environment Survey for medical services activities in Iraq for 2008.
 | 2 | Refer to manufacturing hazardous waste generation only.
 | 3 | Waste is generated from manufacturing of chemicals, rubber and plastic industrial activities which was called hazardous industrials activities which means that not all the waste is hazardous (DOS comment).
Spreadsheet: 75588d1276126892-excel-2007-sorting-formula-before
Sheet: Sheet1

ID |  | PID | Name | Weight | 40 yard
1 |  | 3 | [NAME] | 235 | 2.3
2 |  | 4 | [NAME] | 221 | 1.258
3 |  | 5 | [NAME] | 150 | 9.879
4 |  | 6 | [NAME] | 55 | 3.987
5 |  | 7 | [NAME] | 68 | 5
6 |  | 9 | Adam | 95 | 3
7 |  | 10 | [NAME] | 4635 | 4
8 |  | 11 | [NAME] | 547 | 3.841
9 |  | 12 | [NAME] | 525 | 3.33
10 |  | 20 | [NAME] | 876 | 5.26
11 |  | 21 | [NAME] | 8433 | 1.99
12 |  | 22 | [NAME] | 486 | 1.589
15 |  | 25 | [NAME] | 487 | 1.58
20
21
22
23
25
Spreadsheet: 3f9b00b9-8746-42c0-933d-b1acfc7644d7
Sheet: 20130325 attempt 2

i1 pro 2 spectrophotometer
 | White | Red | Green | Blue | [NAME] | Magenta | Yellow
x: CIE31 | 0.3194 | 0.647 | 0.3086 | 0.1514 | 0.2321 | 0.3311 | 0.4317 | 0.3182
y: CIE31 | 0.3256 | 0.3297 | 0.5943 | 0.0629 | 0.3243 | 0.1575 | 0.4996 | 0.3258
Y | 65.7352 | 14.9528 | 44.7538 | 4.5735 | 51.0654 | 19.1282 | 61.2453 | 124.44
Target Y | 65.7352 | 13.9786 | 47.0118 | 4.7449 | 51.7567 | 18.7234 | 60.9904 | 124.44
ΔE 1994 | 3.607 | 1.7953 | 1.976 | 1.0682 | 2.3141 | 1.2024 | 2.5052 | 3.7765
ΔE 1994 CP sheet
Difference in ΔE
For ΔE 1994
Diffrence < 0.2
Difference > 0.2 but <= 0.5
Difference > 0.5
i1 display 3 OEM colorimeter
 | White | Red | Green | Blue | [NAME] | Magenta | Yellow
x: CIE31 | 0.3194 | 0.6491 | 0.3084 | 0.1506 | 0.2319 | 0.3313 | 0.432 | 0.3182
y: CIE31 | 0.3257 | 0.3297 | 0.5953 | 0.0619 | 0.3246 | 0.157 | 0.5002 | 0.3258
Y | 65.7231 | 14.8837 | 44.8738 | 4.4727 | 51.0867 | 19.0408 | 61.3141 | 124.4266
Target Y | 65.7231 | 13.976 | 47.0032 | 4.744 | 51.7472 | 18.72 | 60.9791 | 124.4266
ΔE 1994 | 3.5611 | 1.9493 | 1.9003 | 1.166 | 2.224 | 1.194 | 2.4999 | 3.8183
ΔE 1994 CP sheet
Difference in ΔE
For ΔE 1994
Diffrence < 0.2
Difference > 0.2 but <= 0.5
Difference > 0.5
Profile verification: PASS (red is a bit dubious perhaps…)
 | White | Red | Green | Blue | [NAME] | Magenta | Yellow
x: CIE31
y: CIE31
Y
Target Y
ΔE 1994
For x,y
Difference < 0.002
Difference > 0.002 but <= 0.005
Difference > 0.005
For ΔE 1994
Diffrence < 0.2
Difference > 0.2 but <= 0.5
Difference > 0.5
Note: this is the 2nd attempt I made and this profile looks a lot better
Spreadsheet: 373053d1422302751-unique-distinct-list-from-a-column-but-what-i-have-and-what-i-need
Sheet: Sheet1

 | I have this: |  |  |  |  | what I need
unique distinct list from a column of values |  |  |  |  |  | unique distinct list from a column of values but if record have any value in column data
values | data |  | result : |  |  |  | values | data |  | result :
AA | 5 |  |  |  |  |  | AA | 5 |  | AA | 5
AB |  |  |  |  |  |  | AB |  |  | AC | 3
AC | 3 |  |  |  |  |  | AC | 3
AB |  |  |  |  |  |  | AB
AA |  |  |  |  |  |  | AA
AD |  |  |  |  |  |  | AD
AE |  |  |  |  |  |  | AE
values | data
AA | 5
AC | 3
Grand Total
Spreadsheet: 273473d1382722619-return-top-10-values-from-table-pt-top-10-value-filter
Sheet: Report

 | Name | Wins
 | [NAME] | 32
 | [NAME] | 13 |  | Row Labels | Sum of Wins |  | Using a Pivot Table of your data
 | [NAME] | 12 |  | [NAME] | 13 |  |  | you will need to put column heads on each column
 | René Arnoux | 7 |  | [NAME] | 3 |  | Do a Pivot using Name as rows and [NAME] as values
 | [NAME] | 5 |  | [NAME] | 2 |  |  | Then filter the pivot using Top 10 filter
 | [NAME] | 5 |  | [NAME] | 32
 | [NAME] | 3 |  | [NAME] | 5 |  | Learn more about Pivot Tables and this is a No Formula Solution.
 | [NAME] | 3 |  | [NAME] | 1
 | [NAME] | 2 |  | [NAME] | 12
 | [NAME] | 1 |  | [NAME] | 5
 | [NAME] | 1 |  | [NAME] | 3
 |  |  |  | [NAME] | 1
 |  |  |  | René Arnoux | 7
 |  |  |  | Grand Total | 84
Spreadsheet: 176248d1345791411-matching-and-printing-values-from-two-excel-columns-in-another-column-on-certain-condition-task
Sheet: Sheet1

Number 1 | Number 2 | Sequence | Final Sequence
1001 | 1001 | AGCTAGCTCTTAGCGCGCGCG | AGCTAGCTCTTAGCGCGCGCG
1002 | 1002 | CTTCAGC | CTTCAGC
1003 | 1003 | AAAAAGCTCC | AAAAAGCTCC
1005 | 1004 | GCTCTTAGCGCGCGCG | AAAGCTCCCAGC
1006 | 1005 | AAAGCTCCCAGC | GCTCTTAGCGCGCGCG
1008 | 1006 | GCTCTTAGCGCGCGCG | CTTAGCGCGCGCG
 | 1007 | TTAGCGCGCGCG
 | 1008 | CTTAGCGCGCGCG
[NAME]
Spreadsheet: f06e684d-bde1-4707-8306-012df89b8755
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FACTO | Test | FACTO | Acetoacetate, Serum or [NAME] | Acetoacetate | Gas Chromatography (GC) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | Submit only 1 of the following specimens:   Preferred: [NAME] blood in a lavender-top (EDTA) or pink-top tube(s). ([NAME] tube is not acceptable.) Spin down and send 3 mL of EDTA plasma frozen in a plastic vial. Note:  	1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma).   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 3 mL of serum frozen in a plastic vial. Note:  	1. Indicate serum on request form. 	2. Label specimen appropriately (serum). | 1.2 mL | Specimens other than	Plasma, serum Anticoagulants other than	EDTA, pink-top, heparin, plain red-top Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icteric	NA | Reporting limit determined each analysis.   Acetoacetate     Normal range for adults:  5-30 mcg/mL   Test Performed By:  NMS Labs                                3701 Welsh Road                                PO Box 433A                               [NAME], PA 19090-0437 | Wednesday | 3 days | 5-11 days | 1 | 82010 |  |  |  |  | NMS Labs
FACTO | [NAME] | VARIES | Varies |  |  |  | Frozen | 4 days
FACTO | Result | Z1433 | Acetoacetate | Acetoacetate | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 1705-2
FACTO | Result | Z1854 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process