tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 51015d1250610889-finding-out-whether-4-lengths-are-equivalent-equivalent-lengths
Sheet: Sheet1

A |  | B |  | C |  | D |  |  | km | m | cm | [NAME]
310249 | [NAME] | 31024.9 | cm | 310.249 | m | 0.310249 | km |  |  |  |  |  | Need a formula to say whether
50794.6 | cm | 507946 | [NAME] | 5079.46 | m | 5.07946 | km |  |  |  |  |  | these are equivalent lengths.
2235.77 | m | 223577 | [NAME] | 22357.7 | cm | 22.3577 | km
0.000310249 | km | 386635 | [NAME] | 38663.5 | cm | 386.635 | m
132386 | [NAME] | 13238.6 | cm | 132.386 | m | 0.132386 | km
90499.5 | cm | 904995 | [NAME] | 9049.95 | m | 9.04995 | km
6386.31 | m | 638631 | [NAME] | 63863.1 | cm | 63.8631 | km
0.000132386 | km | 194804 | [NAME] | 19480.4 | cm | 194.804 | m
430024 | [NAME] | 43002.4 | cm | 430.024 | m | 0.430024 | km
81291.7 | cm | 812917 | [NAME] | 8129.17 | m | 8.12917 | km
Spreadsheet: 700317d1603127337-power-query-or-formulas-or-vba-sample-1-
Sheet: Sheet3

Order | Items | Picker | Table3.Box Type | Table3.Packer ID | Table3.Shipped
1001 | X123 | 11 ,12 | LRG | 9 | 2020-10-19 00:00:00
1001 | Z324 | 11 | LRG | 9 | 2020-10-19 00:00:00
1001 | T223 | 11 | LRG | 3 | 2020-10-19 00:00:00
1002 | X123 | 3 ,7 ,3 ,7 ,11 ,11 ,25 ,25 | MED | 12 | 2020-10-19 00:00:00
1002 | T223 | 4 | MED | 12 | 2020-10-19 00:00:00
Spreadsheet: 167711d1342073784-calculate-the-difference-vlookup-not-enough-calculate-the-diff
Sheet: Sheet1

company | department | revenue | company | department | revenue | difference
92 | R010 | 1000 | 190 | R090 | 100
190 | R020 | 1100 | 92 | R001 | 300
190 | R030 | 2000 | 92 | R010 | 200
Spreadsheet: 764837d1643029838-rank-not-correct-working-berekening-ranking_resultaten-ter-info-aan-ray-aligw
Sheet: Blad ter info aan Ray

 |  | Column D - all with same value should be ranked the same # |  |  |  |  |  |  |  |  |  |  |  | Afstand | 30 |  |  |  | 2 | Str.Pnt Te vroeg
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Φ [NAME] | 30 |  |  |  | 1 | Str.Pnt Te Laat
 |  | Car-NR | RANG | Driver | Co-Driver | START | AANKOMST | TIJD | PNT | STR.PNT |  | RANK (AliGW) |  | Ideale Tijd |  |  |  |  |  | =Ideale Tijd
 |  | 1 |  | A | K | 09:15:00 | 10:18:00
 |  | 2 |  | B | L | 09:16:00 | 10:19:00
 |  | 3 |  | C | M | 09:17:00 | 10:18:00
 |  | 4 |  | D | N | 09:18:00 | 10:19:00
 |  | 5 |  | E | O | 09:19:00 | 10:16:00
 |  | 6 |  | F | P | 09:20:00 | 10:17:00
 |  | 7 |  | G | Q | 09:21:00 | 10:16:00
 |  | 8 |  | H | R | 09:22:00 | 10:17:00
 |  | 9 |  | I | S | 09:23:00 | 10:23:00
 |  | 10 |  | J | T | 09:24:00 | 10:24:00
Spreadsheet: d54d441a-718a-4958-aa5a-f9ec1a7a9ddd
Sheet: WW Gross Sales Trends - FP

MATTEL, INC. AND SUBSIDIARIES
[NAME] REVENUE GROWTH TRENDS - FISHER-PRICE BRANDS
 |  |  |  |  | 2011 |  | 2012
 |  |  |  |  | 1 Qtr |  | 1 Qtr
[NAME] Sales Fisher-Price:
Fisher-Price - Worldwide
 | % Change |  |  |  | -0.02 |  | 0
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 1 |  | -2
Fisher-Price - North American1
 | % Change |  |  |  | -0.05 |  | -0.05
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 0 |  | 0
Fisher-Price - International
 | % Change |  |  |  | 0.02 |  | 0.08
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 1 |  | -5
Fisher-Price Core:
Fisher-Price Core - Worldwide
 | % Change |  |  |  | 0 |  | -0.06
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 1 |  | -1
Fisher-Price Core - North American1
 | % Change |  |  |  | -0.03 |  | -0.09
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 0 |  | 0
Fisher-Price Core - International
 | % Change |  |  |  | 0.04 |  | -0.03
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 1 |  | -3
Fisher-Price Friends:
Fisher-Price Friends - Worldwide
 | % Change |  |  |  | -0.13 |  | 0.34
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 1 |  | -3
Fisher-Price [NAME] American1
 | % Change |  |  |  | -0.18 |  | 0.19
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 0 |  | -1
Fisher-Price Friends - International
 | % Change |  |  |  | -0.05 |  | 0.52
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 2 |  | -8
1 Consists of the U.S. and Canada
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 718842d1613388862-what-recipe-can-be-made-from-available-stock-recipe
Sheet: Sheet1

 |  | Recipe |  |  |  | Available Stock
 | Recipe name | Ingredients | Kilogram |  |  | Ingredients | Kilogram
 | [NAME] | Carrot | 1000 |  |  | Carrot | 2000
 |  | Spice | 25 |  |  | Spice | 25 |  | "What can be made from this stock?"
 |  | Salt | 50 |  |  | Salt | 50
 |  | Onion | 150 |  |  | Onion | 150
 |  | capsicum | 200 |  |  | capsicum | 200
 |  | water | 3000 |  |  | water | 3550
 |  | culture | 20 |  |  | culture | 20
 |  | tea | 40 |  |  | tea | 40
 |  | total |  |  |  | total
 | Recipe name | Ingredients | Kilogram
 | [NAME] | Carrot | 7000
 |  | Spice | 50
 |  | Salt | 100
 |  | Onion | 300
 |  | capsicum | 500
 |  | water | 6000
 |  | culture | 50
 |  | tea | 70
 |  | total
Spreadsheet: 743755d1628698379-how-to-create-multiple-dependent-drop-downs-using-array-formulas-in-excel-array-formulas-for-dependent-drop-downs-manteigas-
Sheet: SampleData

Laptop Brand | Model | RAM Desktop | RAM Laptop | Processor Desktop | Processor Laptop | Price Desktop | Price Laptop
Dell | [NAME] | 4 | 8 | 2.5 | 2.8 | 10 | 20
Dell | Dell Inspirion | 8 | 16 | 3.2 | 3.6 | 25 | 30
Hewlett Packard | HP Notebook | 4 | 8 | 2.5 | 2.8 | 10 | 20
Hewlett Packard | HP EliteBook | 8 | 12 | 2.8 | 3.2 | 25 | 30
Hewlett Packard | HP ProBook | 12 | 16 | 3.2 | 3.6 | 30 | 35
Lenovo | Lenovo ThinkPad | 4 | 8 | 2.5 | 2.8 | 10 | 20
Lenovo | Lenovo IdeaPad | 8 | 12 | 3.2 | 3.6 | 25 | 30
Asus | [NAME] | 4 | 4 | 2.5 | 2.8 | 10 | 20
Asus | [NAME] | 8 | 8 | 3.2 | 3.6 | 25 | 30
 |  |  |  |  |  |  |  |  | Author: | https://www.p2w2.com/blog/how-to-create-multiple-dependent-dropdowns-using-array-formulae-in-excel/
Spreadsheet: 11e37916-2348-4b4b-bfeb-414b8a8e0ad0
Sheet: Sheet1

Committee | Chair(s) | Committee Members
Alumni Business Council | [NAME] | N/A
 | Bhargav Srinivasan
Company Field Trip | [NAME] | [NAME]
 |  | Seong Yoon
 |  | [NAME]
 |  | [NAME]
Corporate Relations | [NAME] | Khushboo Kamnani
 |  | [NAME]
 |  | Petra Koid
 |  | [NAME]
Faculty Relations | [NAME] | Morgan Lundy
 |  | [NAME]
 |  | [NAME]
Fall Case Competition | [NAME] | [NAME]
 |  | Christie Nguyen
 |  | [NAME]
 |  | [NAME]
[NAME] | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
First Year Leadership | [NAME] | N/A
 | [NAME]
McCombs Kickoff | [NAME] | [NAME]
 |  | [NAME]
 |  | Petra Koid
 |  | Mukthi Desaraju (External)
McCombs Executive Summit | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Morgan Lundy
 |  | Dustin Pourbaba (External)
Public Relations | [NAME] | N/A
Publicity | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Ryan Upchurch
Administrative Assistant | [NAME] | N/A
Audit Committee | [NAME] | [NAME]
 |  | Bhargav Srinivasan
 |  | Kayla Messamore
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
IM Sports & Wellness | [NAME] | N/A
 | [NAME]
Financial Assistant | [NAME] | N/A
Traditions | [NAME] Nunez | [NAME]
 | [NAME] | [NAME]
 |  | [NAME]
 |  | Jamal Deek
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Tech Team | N/A | Kayla Messamore
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
VIP Committee | [NAME] | Petra Koid
 | [NAME] | [NAME]
 |  | [NAME]
 |  | Andy Theodosis
 |  | [NAME]
VISIT | [NAME] | N/A
MBA For a Day | [NAME] | N/A
Community Service | [NAME] | [NAME]
 | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Constitutional Review | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Wiki Team | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Texas Revue | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spring Case Competition | Khushboo Kamnani | [NAME]
 |  | [NAME] Nunez
 |  | Ryan Upchurch
 |  | [NAME]
Engineering vs. Business Week | [NAME] | N/A
 | [NAME]
 | [NAME]
BBA Legacy Campaign | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
[NAME] George Mitchell Awards | [NAME] | Kayla Messamore
 |  | [NAME]
 |  | Seher Dholakia
 |  | [NAME]
 |  | Morgan Lundy
Spreadsheet: 135709d1326200944-populate-a-formula-to-update-leave-days-attendance-tracker
Sheet: Attendance Tracker

 | Data |  |  |  |  | Desired Result
 | ID | [NAME] | Leave End | Leave |  | ID | 2012-01-01 00:00:00
 | 111 | 2012-01-01 00:00:00 | 2012-01-06 00:00:00 | VL |  | 111
 | 121 | 2012-01-02 00:00:00 | 2012-01-10 00:00:00 | EL |  | 121
 | 111 | 2012-01-10 00:00:00 | 2012-01-13 00:00:00 | SL
 |  |  |  |  |  | Populate a formula in H5:AL6 with use of Data and result will come as appears in Desired Result area
Spreadsheet: louise_kitchen__24066__NETCO4122pm
Sheet: IT Infra

Area | Critical | #
Mgmt/Admin Support | [NAME] | 2
 | Mercedes Estrada
Architecture & | [NAME] | 10
Operational Trouble- | [NAME]
shooting | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Network -- LAN/WAN | [NAME] | 11
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Morgan Gothard
 | [NAME]
 | [NAME]
Telephony (Trading | [NAME] | 7
turrets and desktop) | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
[NAME] | [NAME] | 3
(Vendor mgmt/bills, | [NAME]
video conf, churns) | [NAME]
Trading/Executive | [NAME] | 8
Support | Jeremy May
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Desktop Support | LaMetrice [NAME] | 7
(non-traders) | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Help Desk | [NAME] | 7
 | Nhonai Tran
 | Melody Gray
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Desktop Hardware | [NAME] | 4
Support | [NAME]
 | [NAME]
 | [NAME]
Remote Site Support | [NAME] | 4
 | [NAME]
 | [NAME]
 | [NAME]
[NAME] | [NAME] | 5
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Web Ops/Terminal | [NAME] | 4
Server Support | [NAME] Jeska
 | Brent Tiner
 | Chrysti Hardy
Application Integration | [NAME] | 4
 | [NAME]
 | [NAME]
 | [NAME]
Market Data | [NAME] | 2
 | [NAME]
Server/Storage Support | [NAME] | 16
(NT and UNIX) | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Thais Hensch
Command Center | [NAME] | 5
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Security Administration | [NAME] | 3
 | [NAME]
 | [NAME]
[NAME] | Troy Beyer | 3
Source Code Mgmt | [NAME]
 | [NAME]
Data Center Support | [NAME] | 1
Security & Controls | [NAME] | 2
(includes litigation | [NAME]
support)
Totals
Portland
Steiner | [NAME] | Infrastructure
Cox | Chip | Infrastructure
Bulbes | Victor | Infrastructure
Tully | [NAME] | Infrastructure
Spreadsheet: 18016723-1ad0-47b0-b573-2b9dce0dbc53
Sheet: Stepped Rent Input

Stepped Rent Input
Enter Value For Each Year of Lease
 | Shell | Orig | Shell | Renew | Shell | Structured | Orig | Structured | Renew | Structured | Surface | Orig | Surface | Renew | Surface
Year | Original | Months | Renewal | Months | Total | Original | Months | Renewal | Months | Total | Original | Months | Renewal | Months | Total
1 | 18.18
 | 18.18
 | 18.18
 | 18.18
 | 18.18
 | 20.09
 | 20.09
 | 20.09
 | 20.09
 | 20.09
 | 22.09
 | 22.09
 | 22.09
 | 22.09
 | 22.09
Spreadsheet: 07a8b5a7-ac9e-4191-8b22-d5db489e3414
Sheet: CVC by Year and Quarter

Corporate Venture Capital Group Investment Analysis 1995 Through Q2 2012
Year | Count of All Venture Capital Deals | Number of Deals with CVC Involvement | Calculated Percentage of Deals with Corporate VC Involvement | $M Average Amount of All VC Deals | $M Average Amount of CVC Participation | Total VC Investment $M | Total CVC Investment $M | Calculated Percentage of Dollars Coming from CVCs
1995 | 1897 | 146 |  |  |  | 8001.1014 | 437.5
1996 | 2639 | 228 |  |  |  | 11351.2401 | 685.2
1997 | 3225 | 352 |  |  |  | 14916.6092 | 956.3
1998 | 3727 | 505 |  |  |  | 21221.7688 | 1696.1
1999 | 5597 | 1210 |  |  |  | 54677.5558 | 7354
2000 | 8033 | 2002 |  |  |  | 105199.6262 | 15158.1
2001 | 4587 | 974 |  |  |  | 41009.2285 | 4602
2002 | 3202 | 569 |  |  |  | 22214.9172 | 1956
2003 | 3009 | 454 |  |  |  | 19655.134 | 1287.1
2004 | 3199 | 529 |  |  |  | 23234.2791 | 1559.4
2005 | 3285 | 540 |  |  |  | 23589.719 | 1572
2006 | 3859 | 638 |  |  |  | 27553.7985 | 2050.6
2007 | 4182 | 773 |  |  |  | 31962.3547 | 2631.2
2008 | 4155 | 829 |  |  |  | 30036.1052 | 2404.7
2009 | 3110 | 385 |  |  |  | 20161.5315 | 1353.7
2010 | 3598 | 464 |  |  |  | 23383.1114 | 1895.6
2011 | 3838 | 565 |  |  |  | 29544.0243 | 2265
1H 2012 | 1719 | 280 |  |  |  | 13184.6327 | 1026.7
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Recent Quarterly Investment
Recent Quarters | Count of All Venture Capital Deals | Number of Deals with CVC Involvement | Calculated Percentage of Deals with Corporate VC Involvement | $M Average Amount of All VC Deals | $M Average Amount of CVC Participation | Total VC Investment $M | Total CVC Investment $M | Calculated Percentage of Dollars Coming from CVCs
Q1 2007 | 904 | 167 |  |  |  | 7542.9 | 617.4
Q2 2007 | 1100 | 221 |  |  |  | 7755.9 | 750.7
Q3 2007 | 1041 | 184 |  |  |  | 8222.7 | 609.6
Q4 2007 | 1137 | 201 |  |  |  | 8440.9 | 653.5
Q1 2008 | 1054 | 207 |  |  |  | 8133.2 | 578.2
Q2 2008 | 1103 | 222 |  |  |  | 8042.9 | 570.5
Q3 2008 | 1044 | 251 |  |  |  | 7658.9 | 842.2
Q4 2008 | 954 | 149 |  |  |  | 6201.1 | 413.8
Q1 2009 | 674 | 87 |  |  |  | 3868.1 | 228.1
Q2 2009 | 758 | 93 |  |  |  | 5053.8 | 373.4
Q3 2009 | 749 | 82 |  |  |  | 5361.8 | 283.9
Q4 2009 | 929 | 123 |  |  |  | 5877.9 | 468.3
Q1 2010 | 809 | 98 |  |  |  | 5195.5 | 372.5
Q2 2010 | 1015 | 120 |  |  |  | 7131.9 | 637.3
Q3 2010 | 879 | 113 |  |  |  | 5435.3 | 454.6
Q4 2010 | 895 | 133 |  |  |  | 5620.4 | 431.2
Q1 2011 | 887 | 121 |  |  |  | 6751 | 433.5
Q2 2011 | 1057 | 160 |  |  |  | 8006.2 | 734.9
Q3 2011 | 972 | 152 |  |  |  | 7692.1 | 561.7
Q4 2011 | 922 | 132 |  |  |  | 7094.7 | 534.9
Q1 2012 | 810 | 140 |  |  |  | 6045.5 | 495.4
Q2 2012 | 909 | 140 |  |  |  | 7139.2 | 531.2
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: geir_solberg__11281__11-17act
Sheet: EPEData

 | 37308.97847222222
 | NEWMAN 1 ,ECON, 41  , 75  , 39  , 83  , 34  ,1
 | NEWMAN 2 ,UNAV, -0  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON,100  ,100  , 35  ,103  ,  0  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 141 ,  175,   74, 186 ,  34 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 28  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 78  ,120  , 55  ,151  ,  0  ,1
 | RIOGRANDE,, 107 ,  158,   87, 200 ,   0 ,
 | PALOVERDE,MANL,595  ,595  ,595  ,600  ,  0  ,1
 | FOURCRNRS,MANL,  2  , 20  , 20  ,104  ,  0  ,1
 | LAMBDA, 37.07,  632,  632,  165,    1,    0,13411,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 271092d1381821976-excel-formula-for-percentage-completion-my-sheet1
Sheet: Sheet2

 |  | Start | 2013-06-21 00:00:00 | 2013-06-28 00:00:00 | 2013-07-05 00:00:00 | 2013-07-12 00:00:00 | 2013-07-19 00:00:00 | 2013-07-26 00:00:00 | 2013-08-02 00:00:00 | 2013-08-09 00:00:00 | 2013-08-16 00:00:00 | 2013-08-23 00:00:00 | 2013-08-30 00:00:00 | 2013-09-06 00:00:00 | 2013-09-13 00:00:00 | 2013-09-20 00:00:00 | 2013-09-27 00:00:00 | 2013-10-04 00:00:00 | 2013-10-11 00:00:00 | 2013-10-18 00:00:00 | 2013-10-25 00:00:00
 | Plan | 0 | 0 | 1 | 1 | 2 | 3 | 7 | 2 | 4 | 9 | 6 | 6 | 0 | 2 | 3 | 8 | 9 | 2 | 8 | 4
 | Actual | 0 | 0 | 1 | 1 | 2 | 3 | 7 | 2 | 4 | 9 | 6 | 5 | 1 | 2 | 3
Spreadsheet: 287406d1388778919-looking-up-clients-sample
Sheet: Sheet1

Date | Employee | Client | Activity | Hours | Department
2013-03-25 08:00:00 | Ruby | Macy's | Shorts | 1.25 | FA
2013-03-26 08:00:00 | Ruby | Macy's | Shorts | 1 | FA
2013-03-27 08:00:00 | Ruby | Macy's | shits | 0.25 | FA
2013-10-04 08:00:00 | Yuri | Macy's | skirts | 1.5 | FA
2013-04-19 13:30:00 | [NAME] | [NAME]'s | skirts | 1 | M
2013-05-07 11:00:00 | [NAME] | [NAME]'s | pants | 1 | M
2013-10-07 10:30:00 | Greg | Kohls | skirts | 0.5 | PMI
2013-11-22 08:00:00 | TJ | H&M | shirts | 1.5 | M
2013-11-22 09:30:00 | TJ | H&M | skirts | 0.5 | M
2013-01-21 00:00:00 | [NAME] | Keppel Union Elementary | skirts | 1.5 | FA
2013-02-01 00:00:00 | [NAME] | Keppel Union Elementary | pants | 0.5 | FA
2013-02-05 00:00:00 | [NAME] | Keppel Union Elementary | skirts | 0.5 | FA
2013-01-21 00:00:00 | Emily | Keppel Union Elementary | shirts | 0.5 | FA
Spreadsheet: 769061d1645275707-adding-extra-spaces-in-a-cell-separating-data-from-a-single-cell-aligw
Sheet: Sheet3

 | 73.29 BF2192 Brown-line Bright-eye [NAME] conigera | 73.29 | BF2192 | Brown-line Bright-eyeMythimna conigera
 | 73.291 BF2199 [NAME] Mythimna pallens | 73.291 | BF2199 | [NAME] pallens
 | 73.292 BF2200 [NAME]'s Wainscot [NAME] favicolor | 73.292 | BF2200 | Mathew's WainscotMythimna favicolor
 | 73.293 BF2198 [NAME] [NAME] impura | 73.293 | BF2198 | [NAME] impura
 | 73.294 BF2197 Southern Wainscot [NAME] straminea | 73.294 | BF2197 | Southern WainscotMythimna straminea
 | 73.295 BF2195 The Delicate [NAME] vitellina | 73.295 | BF2195 | The DelicateMythimna vitellina
 | 73.296 BF2203 White-speck [NAME] unipuncta | 73.296 | BF2203 | White-speckMythimna unipuncta
 | 73.297 BF2194 White-point [NAME] albipuncta | 73.297 | BF2194 | White-pointMythimna albipuncta
 | 73.298 BF2193 The Clay Mythimna ferrago | 73.298 | BF2193 | The ClayMythimna ferrago
 | 73.299 BF2201 Shore Wainscot [NAME] litoralis | 73.299 | BF2201 | Shore WainscotMythimna litoralis
 | 73.3 BF2202 L-album Wainscot Mythimna l-album | 73.3 | BF2202 | L-album WainscotMythimna l-album
 | [NAME] Shoulder-striped [NAME] Leucania comma | 73.301 | BF2205 | Shoulder-striped WainscotLeucania comma
 | 73.302 BF2204 Obscure Wainscot Leucania obsoleta | 73.302 | BF2204 | Obscure WainscotLeucania obsoleta
 | 73.303 BF2206 [NAME] Leucania putrescens | 73.303 | BF2206 | Devonshire WainscotLeucania putrescens
 | 73.3031 BF2210 The Maori Graphania averilla [NAME] | 73.3031 | BF2210 | The MaoriGraphania averillaAppendix A
Spreadsheet: cd3025f5-8e10-4f80-b586-8ad258b7ba3e
Sheet: F5

 | 5 |  |  |  |  |  |  |  | Purchased Cost of Nutrient
 | Inputs
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | What is the name of this feed? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feed | Price per Unit | lbs per unit | %DM | CP | TDN |  |  |  | Rate per mile | miles | Units per load |  | Waste (per cent) |  | Price per Unit | Waste (per cent) |  | Price per Unit | Waste (per cent) | Units consumed
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | How much does this feed cost? | $ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | The above price is for how many pounds of feed? |  | 2000 | pounds per unit
 |  | What is the percent dry matter? |  |  |  |  |  |  | Delivered Cost of Nutrient
 |  | What is the percent Crude Protein (on a DM basis) |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | What is the percent TDN (on a DM basis) |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | How far will this feed be transported? |  |  | miles |  |  |  |  | $ |  | per pound of DM
 |  | What is the cost per loaded mile? | $ |  | per mile
 |  |  |  |  |  |  |  |  | Fed Cost of Nutrient
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | How much of the feed will be lost in hauling?
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | How much will it cost to store this feed? | $
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | How much of the feed will be lost in storage?
 |  | How much will it cost to feed this feed? | $ |  |  |  |  |  | Consumed Cost of Nutrient
 |  | How much will be lost when feeding? |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
Spreadsheet: 0a6402e4-be1c-4e89-bca0-8646b6412f1b
Sheet: Sheet1

ALL SMOKE ALARMS SHALL BE CEILING MOUNTED |  | YEAR BUILT or SUBSTANTIALLY MODIFIED
 | Before 1975 | 1975 - 8/27/97 | 8/27/97 - 2007 | 1/08 - 2/11 | 2/11 - Present
SMOKE ALARM POWER = | BATTERY or | HARDWIRED, | HARDWIRED, | HARDWIRED, | HARDWIRED,
 | HARDWIRED | INTERCONNECTED | INTERCONNECTED | INTERCONNECTED | INTERCONNECTED
 |  |  | W/ BATTERY B/U | W/ BATTERY B/U | W/ BATTERY B/U
TYPE OF SMOKE ALARM ( Photoelectric or Ionization)
On the same level, If a required detector is More Than 20 ft. from a kitchen or full bathroom doorway it shall be: | Either: a Dual Detector* OR One Photoelectric AND One Ionization alarm | Photoelectric OR Ionization | Photoelectric OR Ionization | Photoelectric OR Dual Detector* | Photoelectric Only
On the same level, If a required detector is Within 20 ft. of kitchen or full bathroom doorway it shall be: | Photoelectric Only | Photoelectric OR Ionization | Photoelectric Only | Photoelectric Only | Photoelectric Only
[NAME] detectors:
Shall be located on each habitable level including; in the hallway Outside each separate Sleeping Area (bedrooms), no farther than 10 ft. from any bedroom door.
[NAME] (CO) Alarm Power Supply
Battery or Plug-In w/battery backup | Allowed | Allowed | Allowed | NOT  Allowed | NOT  Allowed
Hardwired, interconnected w/battery backup | Allowed | Allowed | Allowed | Required | Required
Alarm Locations
Finished Basement at base of stairs | Smoke & CO | Smoke & CO | Smoke & CO | Smoke & CO | Smoke & CO
[NAME] | Smoke | Smoke | Smoke | Smoke & CO | Smoke & CO
Base of Stairs leading to Occupied floor above | Smoke | Smoke | Smoke | Smoke | Smoke
Outside each Sleeping Area (in hallway) | Smoke & CO | Smoke & CO | Smoke & CO | Smoke & CO | Smoke & CO
Inside every Bedroom |  |  | Smoke | Smoke | Smoke
Finished Attic (Habitable) | Smoke & CO | Smoke & CO | Smoke & CO | Smoke & CO | Smoke & CO
Garage (Attached) |  |  |  | Heat Detector | Heat Detector
*A Dual Detector consists of one detector with both photoelectric and ionization technology
One Smoke Alarm is needed for each 1,200 square feet of area, per floor
Low Voltage fire warning systems are exempt from the dual detector technology requirement
Combination Smoke and Carbon Monoxide Alarms MUST have a Voice Feature
Spreadsheet: 869608d1716216549-index-and-match-multiple-rows-only-returning-top-row-gw_test2-aligw
Sheet: Sheet3

 | Dataset |  |  |  | Index and Match retrieve
 | Unique ID | Town | In the area? |  | Unique ID | In the area?
 | A2G00043 | Bury | No |  | A2G00043
 | A2G00044 | Matlock | No |  | A2G00044 | No
 | A2G00044 | Matlock | Yes |  | A2G00045 | No
 | A2G00045 | [NAME] | No |  | A2G00052 | Yes
 | A2G00052 | Rochdale | Yes |  | A2G00053 | Yes
 | A2G00053 | Oldham | Yes |  | A2G00054 | Yes
 | A2G00054 | Stockport | Yes |  | A2G00065 | No
 | A2G00065 | [NAME] | No |  | A2G00067 | No
 | A2G00067 | [NAME] | No |  | A2G00078 | No
 | A2G00078 | Partington | No
 | A2G00078 | Partington | Yes
Spreadsheet: 33352d1229646113-pivot-table-filtering-on-individual-counts-not-total-test4
Sheet: 45

Week Num | 45
Count of Case ID.
Name | Total
Name 106 | 10
Name 1354 | 6
Name 1507 | 7
Name 1929 | 8
Name 1960 | 7
Name 2073 | 6
Name 323 | 6
Name 876 | 13
Name 952 | 6
Grand Total | 69