tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 24d00b60-962f-4468-b24d-1c2dcc006cfb
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
 | 6345.0 Labour Price Index, Australia
 | Table 3b. Total Hourly Rates of Pay Excluding Bonuses: Private Sector by State, Original (Quarterly Index Numbers)
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
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Private ;  All industries ; |  |  | Original | A2599049K | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  Private ;  All industries ; |  |  | Original | A2608359V | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  Private ;  All industries ; |  |  | Original | A2600379J | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  Private ;  All industries ; |  |  | Original | A2609689C | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  Private ;  All industries ; |  |  | Original | A2607029K | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  Private ;  All industries ; |  |  | Original | A2601709F | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  Private ;  All industries ; |  |  | Original | A2605699K | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private ;  All industries ; |  |  | Original | A2604369A | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private ;  All industries ; |  |  | Original | A2603039T | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 1bc52e83-8346-4bc7-95d8-fabfc7f3cb70
Sheet: UoA Data

 | Total UoA Graduates | UoA Mathematical Science Bachelor Graduates |  | Percentage of Total Bachelor Graduates |  | Mathematical Science PhD Graduates - University of Auckland
1960 | 268 | 25 |  |  |  | 0
1961 | 341 | 27 |  |  |  | 0
1962 | 326 | 16 |  |  |  | 0
1963 | 380 | 38 |  |  |  | 0
1964 | 474 | 47 |  |  |  | 0
1965 | 554 | 55 |  |  |  | 0
1966 | 564 | 52 |  |  |  | 0
1967 | 582 | 60 |  |  |  | 1
1968 | 724 | 89 |  |  |  | 0
1969 | 828 | 118 |  |  |  | 0
1970 | 967 | 102 |  |  |  | 0
1971 | 1120 | 120 |  |  |  | 0
1972 | 1295 | 93 |  |  |  | 0
1973 | 1376 | 112 |  |  |  | 1
1974 | 1536 | 66 |  |  |  | 0
1975 | 1350 | 62 |  |  |  | 2
1976 | 1371 | 56 |  |  |  | 2
1977 | 1452 | 41 |  |  |  | 0
1978 | 1566 | 50 |  |  |  | 2
1979 | 1714 | 49 |  |  |  | 2
1980 | 1698 | 67 |  |  |  | 0
1981 | 1717 | 58 |  |  |  | 0
1982 | 1763 | 59 |  |  |  | 3
1983 | 1849 | 54 |  |  |  | 2
1984 | 1863 | 74 |  |  |  | 2
1985 | 1983 | 97 |  |  |  | 1
1986 | 1911 | 97 |  |  |  | 0
1987 | 2022 | 49 |  |  |  | 1
1988 | 2010 | 74 |  |  |  | 2
1989 | 2044 | 87 |  |  |  | 2
1990 | 2237 | 91 |  |  |  | 1
1991 | 2509 | 80 |  |  |  | 0
1992 | 2775 | 159 |  |  |  | 1
1993 | 3018 | 141 |  |  |  | 2
1994 | 3200 | 129 |  |  |  | 5
1995 | 3580 | 160 |  |  |  | 6
1996 | 3931 | 186 |  |  |  | 1
1997 | 4139 | 154 |  |  |  | 4
1998 | 4168 | 155 |  |  |  | 7
1999 | 4301 | 221 |  |  |  | 14
2000 | 4214 | 243 |  |  |  | 6
2001 | 4098 | 213 |  |  |  | 5
2002 | 4227 | 203 |  |  |  | 7
2003 | 4442 | 205 |  |  |  | 5
2004 | 5206 | 242 |  |  |  | 5
2005 | 5525 | 200 |  |  |  | 15
2006 | 5957 | 263 |  |  |  | 6
2007 | 5919 | 243 |  |  |  | 13
2008 | 5722 | 136 |  |  |  | 8
2009 | 4966 | 97 |  |  |  | 12
2010 | 5714 | 179 |  |  |  | 9
Spreadsheet: 773229d1647714766-extract-all-values-in-column-excluding-immediate-duplicates-only-column-list
Sheet: Sheet1

Alejandro [NAME] |  |  | Alejandro [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Spreadsheet: 837503d1690208586-match-a-name-with-two-columns-then-displaying-the-most-recent-number-excelformula
Sheet: Sheet1

Futures 2022 | AbderrahmanW. | ScottA. | 2022-06-01 00:00:00 |  | 1500 | 1500 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 1
Futures 2022 | AbderrahmanW. | AlvarezM. | 2022-06-02 00:00:00 |  | 1516 | 1500 | 0 | 1 | 1 |  |  |  |  |  |  |  |  | 2
[NAME] | AbderrahmanW. | MarkovaJ. | 2022-06-03 00:00:00 |  | 1531 | 1500 | 0 | 2 | 2 |  |  |  |  |  |  |  |  | 3
Futures 2022 | AbderrahmanW. | PonwithN. | 2022-06-04 00:00:00 |  | 1545 | 1500 | 0 | 3 | 3 |  |  |  |  |  |  |  |  | 4
Tbilisi 2 ITF | AbderrahmanW. | AyukawaM. | 2022-06-05 00:00:00 |  | 1559 | 1500 | 0 | 4 | 4 |  |  |  |  |  |  |  |  | 5
[NAME] ITF | AbderrahmanW. | OmaeA. | 2022-06-06 00:00:00 |  | 1572 | 1500 | 0 | 5 | 5 |  |  |  |  |  |  |  |  | 6
[NAME] ITF | AbderrahmanW. | MiL. | 2022-06-07 00:00:00 |  | 1585 | 1500 | 0 | 6 | 6 |  |  |  |  |  |  |  |  | 7
Tbilisi 2 ITF | AbderrahmanW. | RyserV. | 2022-06-08 00:00:00 |  | 1597 | 1500 | 0 | 7 | 7 |  |  |  |  |  |  |  |  | 8
Futures 2022 | AbderrahmanW. | HenningB. | 2022-06-09 00:00:00 |  | 1620 | 1500 | 0 | 8 | 8 |  |  |  |  |  |  |  |  | 9
Rancho Santa Fe ITF | AbderrahmanW. | BursulayaS. | 2022-06-10 00:00:00 |  | 1631 | 1500 | 0 | 9 | 9 |  |  |  |  |  |  |  |  | 10
 | ConwayJ. | AbderrahmanW. | 2022-06-11 00:00:00 |  | 1500 | 1641
 | CooperL. | AbderrahmanW. | 2022-06-12 00:00:00 |  | 1500 | 1619
 | CorseJ. | AbderrahmanW. | 2022-06-13 00:00:00 |  | 1500 | 1598
 | CossuM. | AbderrahmanW. | 2022-06-14 00:00:00 |  | 1500 | 1578
 | CozbinovA. | AbderrahmanW. | 2022-06-15 00:00:00 |  | 1500 | 1558
 | [NAME] | AbderrahmanW. | 2022-06-16 00:00:00 |  | 1500 | 1539
 | DougazA. | AbderrahmanW. | 2022-06-17 00:00:00 |  | 1500 | 1521
 |  |  |  |  | the excel should retrieve the latest number available except the current one
 |  |  |  |  | but it is trickier because it is retrieving just for one column
 |  |  |  |  | those are the desired results
 |  |  |  |  | the latest current value of the player should be displayed
 |  |  |  |  | if it is on column B it will display the latest(except for the current value), need to be 1 before the current one
 |  |  |  |  | on column F it will get the latest number on both column F and G, if the name is on column F it will retrieve the latest number that match with that name on column F or G, and if the name is on column G, it will retrieve the latest number that match with that name on column F or G
Spreadsheet: 73b737c2-9ec9-47d0-a4da-2ecfab3521f5
Sheet: Sheet1

Unnamed: 0 | dorsal centrum length ([NAME]) | ventral central length ([NAME])
pre-bend | 51.7 | 51.6
 | 50.2 | 50.9
 | 51.7 | 50.7
 | 47.6 | 46.9
 | 49.7 | 48.9
 | 50.3 | 49.4
 | 50.3 | 50
 | 50.2 | 50.2
 | 47.4 | 47.1
 | 47.5 | 46.7
 | 46.1 | 44.8
 | 42.7 | 42.1
 | 40.9 | 42
bend | 43.1 | 37.6
 | 44.1 | 40.9
 | 39.8 | 39.8
 | 42.3 | 40.7
 | 40.4 | 39.8
 | 41.7 | 38.6
 | 40.2 | 37.2
 | 38.1 | 37.5
 | 35.7 | 34.6
 | 36.5 | 36.5
 | 37.5 | 35.8
 | 37.6 | 35.9
 | 36.4 | 35.7
post-bend | 34.7 | 34.7
 | 34.8 | 33.8
 | 35.2 | 34.6
 | 34 | 34
 | 33.8 | 33.8
 | 34.1 | 33.1
 | 33.5 | 32.7
 | 32.9 | 32.5
 | 30.9 | 30.7
 | 32 | 32
 | 29.6 | 31.6
 | 31 | 30.2
 | 29.8 | 29.6
Spreadsheet: 698915d1602246323-vlookup-with-condition-book1-example
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2
Employee | Week | Rate |  |  | Employee | Rate 1a | Rate 1b | Rate 2b | Rate 2b | Reason for rate change
Number 3 | 27.2020 |  |  |  | Number 1 | 5 |  | 9
Number 5 | 28.2020 |  |  |  | Number 2 | 6 |  | 34 | 422 | change from week 33.2020 onwards
Number 3 | 29.2020 |  |  |  | Number 3 | 7 | 6 | 22 |  | change from week 28.2020 onwards
Number 4 | 30.2020 |  |  |  | Number 4 | 12 |  | 11 | 87 | change from week 34.2020 onwards
Number 5 | 31.2020 |  |  |  | Number 5 | 55 | 4 | 78 |  | change from week 29.2020 onwards
Number 6 | 32.2020 |  |  |  | Number 6 | 3 |  | 4
Number 8 | 33.2020 |  |  |  | Number 7 | 77 | 81 | 99 |  | change from week 30.2020 onwards
Number 8 | 34.2020 |  |  |  | Number 8 | 45 |  | 56 | 23 | change from week 34.2020 onwards
Number 9 | 35.2020 |  |  |  | Number 9 | 86 |  | 78
Spreadsheet: 543093d1508237391-supplier-lead-times-formula-data
Sheet: Lead Times

 |  |  |  |  | Total Monthly Orders
Part | Component Part Number | Supplier | Quantity Per Item | Lead Time (days) | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00
Item 1 | 1001 | S1 | 1 | 322
Item 2 | 1002 | S2 | 1 | 90
Item 3 | 1003 | S3 | 1 | 90
Item 4 | 1004 | [NAME] | 1 | 90
Item 5 | 1005 | S5 | 1 | 90
Item 6 | 1006 | S6 | 1 | 90
Item 7 | 1007 | S7 | 1 | 112
Spreadsheet: 91612d1291301032-no-menu-appears-when-using-right-click-test-sheet
Sheet: Ark1

LEVERANDØRER
Firmanavn | tekstboks
Adresse | tekstboks
Postnr. - By | tekstboks
Telefon | tekstboks
[NAME] | tekstboks
Hjemmeside | tekstboks
[NAME]. | tekstboks
Kontakt person | tekstboks
Telefon | tekstboks
[NAME] | tekstboks
Brugernavn | tekstboks
Password | tekstboks
Branche | checkboks
Præsentation af firmaet | tekstfelt med begrænset plads
Præsentation af produkter/sortiment | tekstfelt med begrænset plads
Annonce 1 | checkboks
Annonce 2 | checkboks
Annonce 3 | checkboks
Logo | ???
Spreadsheet: 24c7d48a-0525-4f24-bd25-7e3088ca60eb
Sheet: Sheet1

Surname | First Name | Birth Date | Death Date | Age | Notes
Town Unknown
Old Associate Reformed Church Yard at "Stone House" Dickinson Township.
1905.  B. 1768 - 1850, D. 1834 - 1880.
On the same plot of ground where has long stood the "Shady Grove" school house, in Dickinson township, there was erected in 1803-1804, by an Associate Reformed, or Seceder, congregation a stone church building. In 1803 [NAME] deeded to [NAME], [NAME], [NAME], [NAME], and [NAME], trustees of the Associate Presbyterian Church of Dickinson twp., one acre of ground for the uses and purposes of a house of worship, a schoolhouse and burying ground. The church building long ago fell into decay and was removed but some of the interments made in the burying plot on this ground are marked with headstones upon which the inscriptions were legible as late as March 28, 1905, when Capt. Wm. [NAME] and [NAME] visited the place and obtained the following:
MOORE | [NAME] | 14 November 1768 | 17 July 1834
MOORE | [NAME] |  | 29 August 1854 | 54y
MOORE | [NAME] | 22 February 1827 | 4 September 1861
MOORE | [NAME] | 18 July 1817 | 14 August 1880
Spreadsheet: 887604d1737848763-lost-in-a-challenging-formula-challenge_costs_demo2
Sheet: Summary

 |  |  |  | FILTER | GROUPBY |  |  |  |  | GROUPBY
 |  |  | Lumpsum | Costs | Costs |  |  | Single Formula | → |  | Costs
 |  |  | direct |  |  | [NAME] | Individual [NAME] |  |  | direct | 5240
 |  |  | indirect |  |  | [NAME] | Individual [NAME] |  |  | indirect | 2700
 |  |  | open book | Costs | Costs |  |  |  |  | open book | Costs
 |  |  | direct |  |  | [NAME] | Individual [NAME] |  |  | direct | 3410
 |  |  | indirect |  |  | [NAME] | Individual [NAME] |  |  | indirect | 5300
Spreadsheet: 875436d1722001253-sum-based-on-multiple-criteria-demo-260724-1-
Sheet: Vertical TB. - Sumproduct

G2 | G3 | G4 |  | F | Months
Main Vertical | PC Name | PC Code | FS Item/Acct/FA Long | GL Code | 2024-04-01 00:00:00 | 2024-05-01 00:00:00
Head Office | Head Office | 629050001 | Fully Paid Equity Sh MMC /10010000 | 10010000
Franchisee | [NAME] | 629060001 | Fully Paid Equity Sh MMC /10010000 | 10010000
Franchisee | Fran East | 629060002 | Fully Paid Equity Sh MMC /10010000 | 10010000
Franchisee | Fran South | 629060003 | Fully Paid Equity Sh MMC /10010000 | 10010000
Head Office | Head Office | 629050001 | Share Application Eq MMC /10050000 | 10050000
Franchisee | [NAME] | 629060001 | Share Application Eq MMC /10050000 | 10050000
Franchisee | Fran East | 629060002 | Share Application Eq MMC /10050000 | 10050000
Franchisee | Fran South | 629060003 | Share Application Eq MMC /10050000 | 10050000
 |  |  |  |  |  |  |  |  | Months
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
Spreadsheet: 285809d1387861242-need-all-sheet-to-be-change-if-i-change-the-master-sample10
Sheet: Summary

Category | Chiller | [NAME] | DRY | FROZEN | HO | PROMO - DRY | PROMO - FROZEN | Grand Total
BEVRAGES |  | 0.79 | 14333 |  | 54.09 |  |  | 14387.88
CANNED FOOD |  |  | 485 |  | 1 |  |  | 486
CHKN PARTS |  |  |  | 1559.23 | 7.709999999999999 |  | 304.33 | 1871.27
CONDIMENTS |  |  | 3317 |  | 0.08 |  |  | 3317.08
EDIBLE |  |  | 2966 |  | 6.84 |  |  | 2972.84
EGG | 250.17 |  |  |  |  |  |  | 250.17
FPP |  | 0.21 |  | 11632.96 | 0.71 |  | 4838.940000000001 | 16472.82
GRAINS |  | 16 | 2025.6 |  | 0.9 | 28.1 |  | 2070.6
WHOLE POULTRY |  |  |  | 6046.39 | 106.17 |  | 4862.84 | 11015.4
Grand Total | 250.17 | 17 | 23126.6 | 19238.58 | 177.5 | 28.1 | 10006.11 | 52844.06
Brand | Chiller | [NAME] | DRY | FROZEN | HO | PROMO - DRY | PROMO - FROZEN | Grand Total
CROFTERS |  |  | 3317 |  | 0.08 |  |  | 3317.08
GIZE |  |  | 3051 |  | 46.17 |  |  | 3097.17
KESKINOGLU | 250.17 | 0.21 | 485 | 19238.58 | 115.59 |  | 10006.11 | 30095.66
MINTA |  | 0.79 | 2456 |  | 1.33 |  |  | 2458.12
QILA |  | 16 | 2025.6 |  | 0.9 | 28.1 |  | 2070.6
REVIKA |  |  | 2966 |  | 6.84 |  |  | 2972.84
SOL MATE |  |  | 6276 |  | 5.92 |  |  | 6281.92
WHYNATTE |  |  | 2550 |  | 0.67 |  |  | 2550.67
Grand Total | 250.17 | 17 | 23126.6 | 19238.58 | 177.5 | 28.1 | 10006.11 | 52844.06
Spreadsheet: 126979d1320091553-how-to-sumif-between-dates-dummy
Sheet: Summary

Month | Amount | Count
January
February
March
April
May
June
July
August
September
October
November
December
Total:
Spreadsheet: 221063d1363358696-check-time-from-one-sheet-wrt-time-between-another-sheet-in-given-range-of-two-and-return-excel-query
Sheet: main

ID | THK | wid | grd | hrd | item | HIT | TOC | Date
74321700100 | 2.75 | 1185 | AP1480C1 | Group1 | [NAME] | 100 | 2012-12-01 04:10:18 | 2012-12-01 00:00:00 | to check time "TOC' to be inside the range of time given in Roll data " inline time" and "offline time" and return the value from "stand" & :roll shape'
74321700100 | 2.75 | 1185 | AP1480C1 | Group1 | thicknessF7EXIT | 98.4299540519714 | 2012-12-01 07:46:18 | 2012-12-01 00:00:00
74321700100 | 2.75 | 1185 | AP1480C1 | Group1 | thicknessF7EXIT | 100 | 2012-12-01 07:47:50 | 2012-12-01 00:00:00
74321700400 | 2.83 | 1260 | DN0140E1 | Group1 | [NAME] | 100 | 2012-12-03 03:10:18 | 2012-12-01 00:00:00
74321700200 | 2.75 | 1185 | AP1480C1 | Group1 | thicknessF7EXIT | 98.6585378646851 | 2012-12-02 10:10:18 | 2012-12-01 00:00:00
74321700200 | 2.75 | 1185 | AP1480C1 | Group1 | thicknessF7EXIT | 97.68292903900151 | 2012-12-01 08:10:18 | 2012-12-01 00:00:00
74321700300 | 2.83 | 1260 | DN0140E1 | Group1 | [NAME] | 100 | 2012-12-04 00:10:18 | 2012-12-01 00:00:00
74321700400 | 2.83 | 1260 | DN0140E1 | Group1 | thicknessF7EXIT | 99.717116355896 | 2012-12-03 15:10:18 | 2012-12-01 00:00:00
74321700400 | 2.83 | 1260 | DN0140E1 | Group1 | thicknessF7EXIT | 98.72701764106749 | 2012-12-03 16:10:18 | 2012-12-01 00:00:00
74321700600 | 2.75 | 1260 | DN0140E1 | Group1 | [NAME] | 100 | 2012-12-04 16:10:18 | 2012-12-01 00:00:00
74321700300 | 2.83 | 1260 | DN0140E1 | Group1 | thicknessF7EXIT | 99.85895752906801 | 2012-12-04 08:10:18 | 2012-12-01 00:00:00
74321700300 | 2.83 | 1260 | DN0140E1 | Group1 | thicknessF7EXIT | 100 | 2012-12-04 09:10:18 | 2012-12-01 00:00:00
74321700500 | 2.75 | 1260 | DN0140E1 | Group1 | [NAME] | 100 | 2012-12-06 03:10:18 | 2012-12-01 00:00:00
74321700600 | 2.75 | 1260 | DN0140E1 | Group1 | thicknessF7EXIT | 99.74619150161739 | 2012-12-05 10:10:18 | 2012-12-01 00:00:00
74321700600 | 2.75 | 1260 | DN0140E1 | Group1 | thicknessF7EXIT | 100 | 2012-12-05 11:10:18 | 2012-12-01 00:00:00
Spreadsheet: 875964d1722598611-vlookup-not-giving-the-intended-answer-error
Sheet: Sheet1

 |  | Name | Work Days | Salary |  | VLOOKUP | Salary
 |  | [NAME] | 29 | 45600 |  | [NAME]
 |  | [NAME] | 26 | 45200 |  | [NAME]
 |  | Saroj Chandra | 34 | 62200 |  | Saroj Chandra
 |  | [NAME] | 37 | 30600 |  | [NAME]
 |  | [NAME] | 33 | 40800 |  | [NAME]
 |  | [NAME] | 36 | 39200 |  | [NAME]
 |  | [NAME] | 20 | 41500 |  | [NAME]
 |  | Karthik Jeeva | 30 | 58000 |  | Karthik Jeeva
 |  | [NAME] | 21 | 23100 |  | [NAME]
Spreadsheet: 675082d1588154488-sumif-not-including-filtered-data-help-test
Sheet: Sheet1

 |  | Unresolved hours | Resolved hours | Outstanding
 | Early
 | Late
 | Night
 | Weekend
 | [NAME]
Spreadsheet: 76327d1276829049-my-formula-a-calculating-blank-cells-test-6
Sheet: Sheet1

FY 11 | 2010-05-01 00:00:00 |  | 2010-06-01 00:00:00 |  | 2010-07-01 00:00:00 |  | 2010-08-01 00:00:00 |  | 2010-09-01 00:00:00 |  | 2010-10-01 00:00:00 |  | 2010-11-01 00:00:00 |  | 2010-12-01 00:00:00 |  | 2011-01-01 00:00:00 |  | 2011-02-01 00:00:00 |  | 2011-03-01 00:00:00 |  | 2011-04-01 00:00:00
Vehicle Number | start Mileage | Monthly Mileage | [NAME] | Monthly Mileage | [NAME] | Monthly Mileage | [NAME] | Monthly Mileage | start Mileage | Monthly Mileage | [NAME] | Monthly Mileage | [NAME] | Monthly Mileage | Startl Mileage | Monthly Mileage | [NAME] | Monthly Mileage | [NAME] | Monthly Mileage | [NAME] | Monthly Mileage | [NAME] | Monthly Mileage | ENDING | ADVANCE FORWARD | Cumulative | Monthly Average
1 | 87684 | 3838 | 91522 | -91522 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -87684 | -7307
2 | 22493 | 5392 | 27885 | -27885 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -22493 | -1874.416666666667
3 | 86160 | 44 | 86204 | -86204 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -86160 | -7180
4 | 7123 | 3845 | 10968 | -10968 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -7123 | -593.5833333333334
5 | 7567 | 5448 | 13015 | -13015 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -7567 | -630.5833333333334
6 | 43414 | 15091 | 58505 | -58505 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -43414 | -3617.833333333333
7 | 10618 | 5476 | 16094 | -16094 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -10618 | -884.8333333333334
8 | 97863 | 1817 | 99680 | -99680 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -97863 | -8155.25
9 | 81619 | 4026 | 85645 | -85645 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -81619 | -6801.583333333333
10 | 68666 | 1449 | 70115 | -70115 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -68666 | -5722.166666666667
11 | 33616 | 2249 | 35865 | -35865 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -33616 | -2801.333333333333
12 | 89753 | 5079 | 94832 | -94832 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 | -89753 | -8159.363636363636
Spreadsheet: 705582d1606206429-transpose-from-row-to-column-along-with-other-numeric-data-test2
Sheet: Results

Pulling from Row to Column | Pulling into a Single Column
Spreadsheet: 831581c6-cb00-4105-9ff0-62774d11a89d
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
[NAME] | Test | [NAME] | Interleukin-2 Receptor(IL-2R),ELISA | Interleukin-2 Receptor (IL-2R) | Enzyme-Linked Immunosorbent Assay (ELISA) | Plastic vial: PlV |  |  | 2 | mL | Submit only 1 of the following specimens:   Serum Draw sufficient blood in plain, red-top tube(s) (Serum gel tube is acceptable.)  [NAME] down and pour into a plastic, screw-capped, vial. Freeze immediately. Send 2.0 mL serum, [NAME], in a plastic vial.   [NAME] sufficient blood in a yellow-top (ACD), green-top (Heparinized) or lavender-top (EDTA) tube(s) ([NAME] is acceptable.) Spin down and pour into a plastic, screw-capped, vial. Freeze immediately. Send 2.0 mL plasma, [NAME], in a plastic vial. | 0.5 mL | Specimens other than	Serum, plasma Anticoagulants other than	ACD, heparin, EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range:  <970 Units/mL INTERPRETIVE CRITERIA:   <970  Normal Level                                                             > or = 970  Elevated Level      Clinical conditions in which elevated soluble IL-2R levels  are detected include AIDS, autoimmune diseases, sarcoidosis, and a variety of leukemias and lymphomas. In HIV positive individuals, IL-2R is elevated during the asymptomatic phase as well as during persistent generalized lymphadenopathy and symptomatic phases.  IL-2R detection may be useful in  measuring T-cell activation and monitoring HIV pathogenesis. Elevated IL-2R levels may also have clinical and prognostic  significance in patients with malignant lymphoma, non- [NAME]'s lymphoma, B-cell lymphoma, and undifferentiated  lymphomas.      Test Performed by: Focus Diagnostics                                       5785 Corporate Avenue                                       Cypress, CA   90630-4750 | Tuesday | 1 - 8 days | 3 - 11 days | 1 | 84238 |  |  |  |  | Focus Diagnositics, Inc.
[NAME] | [NAME] | VARIES | Varies |  |  |  | Frozen
[NAME] | Result | Z0589 | Interleukin-2 Receptor (IL 2R) | Interleukin-2 Receptor (IL 2R) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 141916329 | 78260027 | 220176356
FRA | 48396104 | 7681041 | 56077145
OIS | 26550967 | 9059168 | 35610135
Swaption | - | 20953345 | 20953345
OTHER* | 6525190 | 27932756 | 34457946
TOTAL | 223388590 | 143886337 | 367274927
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 770006d1645778750-lookup-formula-in-a-block-of-cells-lookup-test
Sheet: Sheet1

First Set | Second Set | Third Set | First Match | Second Match | Third Match
 | 16 |  | Myra Colby | [NAME] Beaumont | [NAME] |  | Lookup value | 27
2 | 20 |  | [NAME] | Honey Trask | Raine [NAME] |  | Result
 | 23 | 40 | Clay North | Daffodil Abrams | [NAME]
11 |  | 75 | [NAME] | Alayna [NAME] | Jodi Bryant
 | 27 |  | Cat Armstrong | Rose Bain | [NAME]