tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 494450d1482400535-conditional-formatting-with-multiple-criteria-team-full-stats-record-editable-v2
Sheet: Year To Date

 | Year to Date Data
January | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration (Mins) | Av Per person | Prod Per Hr
February | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
March | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
April | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
May | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
June | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
July | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
August | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
September | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
October | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
November | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
December | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 | Acc QA Pass | Acc QA Rec | Acc QA AR | Total Pass Acc | BAU Pass | BAU Rec | BAU AR | Total Pass BAU | [NAME] | Duration | Av Per Person | Prod Per Hr
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
YTD | Pass | Rec | AR | Total Acc Pass | Pass | Rec | AR | Total BAU Pass | [NAME] | Duration | Av Per Person | Prod Per Hr
Spreadsheet: 94562d1294339757-if-cell-a1-x-then-cell-b1-y-kkt_datavalidation-dynamic-
Sheet: Sheet1

Code | Title |  | Names
Please select |  |  | Mathew
AA | [NAME]: |  | Mark
EWR | Date submitted: |  | [NAME] |  |  |  |  | BP
BP | BP Approved by rep on: |  | [NAME]
 |  |  |  |  |  |  |  | BP Approved by rep on:
 |  |  |  |  | I am working on a spreadsheet that requires cell I4 to be a drop down selection. What I want is to have cell I6 display different things depending on the selection made in cell I4.
 |  |  |  |  | Cell I4 menus :
 |  |  |  |  | Please select (I want I6 to be blank)
 |  |  |  |  | AA (I want I6 to display title "AA Name:") then J6 to display a drop down list of names IF possible, if not they can type it in)
 |  |  |  |  | EWR (I want I6 to display title "Date submitted:")
 |  |  |  |  | BP (I want I6 to display title "BP Approved by rep on:")
Spreadsheet: 885877d1735805304-help-with-sum-formula-leave-tracker-copy
Sheet: Registration

 | LEAVE REGISTRATION
 | Employee Name | Leave Type | Leave START Date | Leave END Date | Total Days | Net Working Days (Exc. Weekends & Holidays)
 | Almas, Vishram | Paid time off (PTO) | 2025-01-02 00:00:00 | 2025-01-14 00:00:00 |  |  |  |  | Employee Name | Almas, Vishram
 | Almas, Vishram | Sick Leave (Unpaid) | 2025-02-01 00:00:00 | 2025-02-06 00:00:00 |  |  |  |  | Year | 2025
 | Almas, Vishram | [NAME] | 2025-04-03 00:00:00 | 2025-04-09 00:00:00 |  |  |  |  | Month | Paid time off (PTO) | Sick Leave (Unpaid) | [NAME] | Remotely Working | Special Leave
 | Almas, Vishram | Remotely Working | 2025-07-01 00:00:00 | 2025-07-17 00:00:00 |  |  |  |  | January |  | 0 | 0 | 0 | 0
 | Almas, Vishram | Special Leave | 2025-11-09 00:00:00 | 2025-11-18 00:00:00 |  |  |  |  | February | 0 | 4 | 0 | 0 | 0
 | Almas, Vishram | Sick Leave (Unpaid) | 2026-05-01 00:00:00 | 2026-07-25 00:00:00 |  |  |  |  | March | 0 | 0 | 0 | 0 | 0
 | Ana M,  Barrera | Paid time off (PTO) |  |  |  |  |  |  | April | 0 | 0 | 5 | 0 | 0
 | [NAME], [NAME] | Sick Leave (Unpaid) |  |  |  |  |  |  | May | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | June | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | July | 0 | 0 | 0 | 12 | 0
 |  |  |  |  |  |  |  |  | August | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | September | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | October | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | November | 0 | 0 | 0 | 0 | 7
 |  |  |  |  |  |  |  |  | December | 0 | 0 | 0 | 0 | 0
Spreadsheet: 862813d1710415076-lookinf-for-a-formula-to-compare-columns-ip-common-2-
Sheet: Sheet1

IP1 | IP2 | IP3 | IP4
172.185.32.1 | 172.555.231.2 | 199.99.85.2 | 166.896.12.1
199.258.2.1 | 144.254.32.25 | 198.87.65.2 | 123.454.65.8 |  |  | 172.555.231.2
199.257.5.2 | 199.99.85.2 | 172.555.231.2 | 136.258.35.2 |  |  | 199.99.85.2
166.896.12.1 | 172.185.32.1 | 144.254.32.25 | 172.555.231.2 |  |  | 166.896.12.1
 |  |  | 172.185.32.1 |  |  | 144.254.32.25
Spreadsheet: 217808d1362196920-using-price-list-to-populate-purchase-order-test2013
Sheet: Order Form

23 | 50
Product | Code | Description | Qty | Unit Price | Line Total |  | Product | Code | Description | Qty | Unit Price | Line Total
 |  |  |  |  |  |  | OUTFITS | VZK48034 | ZULU outfit 8.0 #3-4 | 50 | 1733.1 | 86655
 |  |  |  | SubTotal
 |  |  |  | 14% Tax
 |  |  |  | Total
Spreadsheet: 877916d1724851734-index-and-match-function-not-working-help-aop-per-tech
Sheet: Jun

TECH | HOURS | AVG-PER DAY | OBJ RATE | % OF TOTAL HOURS | OBJECTIVE |  |  | Column1 | Column2
ANZOR KHATAEV, | 96.95 |  |  |  |  |  |  | AOP $
CHASE FRY, | 103.4 |  |  |  |  |  |  | ELR
[NAME], | 111.05 |  |  |  |  |  |  | AOP HOURS
[NAME], | 91.7 |  |  |  |  |  |  | WORKING DAYS
[NAME], | 122.2
[NAME], | 213.75 |  |  |  |  |  |  | TOTAL HOURS
COELLO VALLEJO, | 78.5
DIEGO MERCADO, | 207.22
DONOVAN OCONNOR, | 91.9
FLORES GUARDADO, | 109.8
GIANCARLO PACHECO, | 0.4
GILBERTO GALENOCAMPOS, | 107.1
[NAME], | 79.4
GRIFFYN BRODHUN, | 11.9
GUARDADO RODAS, | 136.53
[NAME], | 93.8
[NAME], | 73.6
[NAME], | 37.6
JOSHUA MATUDAN, | 49
MASON SHAWN, | 128.9
[NAME], | 229.61
[NAME], | 75.1
[NAME], | 17.6
[NAME], | 238.4
RYAN GUAGENTI, | 112.4
SEAN BRADLEY, | 82.63
[NAME], | 138.91
SHANE GILLESPIE, | 101.14
SHAWN GROOVER, | 80.31
SIMON NELSON, | 112.9
SUBLET TECH, | 0
THOAI LE, | 227.4
TRAVIS GREGORY, | 165.5
TYLER BIXLER, | 144.36
TYLER MUNGER, | 192.6
URBINA GOMEZ, | 75.76
[NAME], | 29.1
WYLIE ROWE, | 18.8
BRANDON HAASE,
Spreadsheet: 166044d1341437140-drop-down-menu-to-show-data-4-variables-by-weeks-drop-down-showing-data
Sheet: Data

 | Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | local damages | 14 | 12 | 5 | 11
 | mistakes | 5 | 3 | 1 | 9
 | lacks | 2 | 6 | 15 | 2
 | remote damages | 8 | 16 | 4 | 3
 | No ZEROES in this spreadsheet | ?
Spreadsheet: 28f8e1cf-8bea-4a8f-bab0-799eb2ee4144
Sheet: Sheet1

APPENDIX C | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
2012–2013 Salary Schedule—38 Weeks*
Training | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
BS+0 | 52086 | 53757 | 55424 | 57096 | 58762 | 60432 | 62102 | 63768 | 65444 | 67111 | 68779 | 74396
BS+6 | 52946 | 54619 | 56287 | 57956 | 59626 | 61295 | 62966 | 64633 | 66304 | 67974 | 69640 | 75308
BS+12 | 53813 | 55480 | 57154 | 58823 | 60492 | 62163 | 63831 | 65496 | 67167 | 68836 | 70505 | 76218
BS+18 | 54679 | 56351 | 58022 | 59685 | 61353 | 63026 | 64692 | 66363 | 68036 | 69701 | 71370 | 77134
BS+24 | 55542 | 57210 | 58878 | 60552 | 62218 | 63887 | 65556 | 67228 | 68894 | 70568 | 72235 | 78050
BS+30 | 56405 | 58072 | 59745 | 61412 | 63084 | 64753 | 66422 | 68089 | 69762 | 71429 | 73093 | 78963
BS+36 | 57720 | 59538 | 61357 | 63177 | 64994 | 66818 | 68640 | 70455 | 72277 | 74097 | 75919 | 82103
MS+0 | 57720 | 59538 | 61357 | 63177 | 64994 | 66818 | 68640 | 70455 | 72277 | 74097 | 75919 | 82103 | 84328
MS+6 | 58587 | 60397 | 62222 | 64043 | 65866 | 67679 | 69501 | 71319 | 73147 | 74957 | 76778 | 83008 | 85241
MS+12 | 59450 | 61267 | 63086 | 64906 | 66726 | 68546 | 70363 | 72184 | 74008 | 75822 | 77635 | 83926 | 86156
MS+18 | 60310 | 62133 | 63950 | 65771 | 67590 | 69409 | 71226 | 73051 | 74864 | 76688 | 78505 | 84840 | 87064
MS+24 | 61176 | 62994 | 64816 | 66634 | 68455 | 70271 | 72091 | 73913 | 75734 | 77551 | 79373 | 85749 | 87979
MS+30 | 62040 | 63860 | 65676 | 67500 | 69312 | 71135 | 72957 | 74775 | 76594 | 78417 | 80230 | 86664 | 88892
SPC+0 | 62901 | 64724 | 66540 | 68363 | 70181 | 72001 | 73819 | 75642 | 77458 | 79280 | 81096 | 87569 | 89795
EDD+0 or PHD+0 | 63763 | 65589 | 67404 | 69228 | 71046 | 72865 | 74682 | 76506 | 78323 | 80144 | 81961 | 88472 | 90702
*Longevity, if applicable, is calculated in the hourly rate.
Spreadsheet: 810664d1671941399-sum-all-identical-merged-columns-1225help
Sheet: Sheet1

Category | Type | price |  | expected end result |  |  | [NAME]
pencil | A | 100 |  | pencil | 480 |  |  | 480
 | B | 60 |  | ink | 220 |  | ink | 220
ink | A | 80 |  | ruler | 80 |  | ruler | 80
 | C | 30 |  | rubber stamp | 60 |  | rubber stamp | 60
ruler | D | 40
rubber stamp | E | 10
 | F | 20
pencil | A | 100
 | B | 60
ink | A | 80
 | C | 30
ruler | D | 40
rubber stamp | E | 10
 | F | 20
pencil | A | 100
 | B | 60
Total
Spreadsheet: 270287d1381429339-duplicates-within-a-date-rage-example-sori4289-oeldere-
Sheet: Sheet1

Unique Close | Sales Owner and Customer | [NAME] | Customer Close | Close date |  | 90 |  | help  1 | help 2 | help3
 |  | [NAME] | 12345678 - Customer xyz | 2013-07-15 00:00:00
 |  | [NAME] | 78987654 - ABC Inc | 2013-05-01 00:00:00
 |  | [NAME] | 12345678 - Customer xyz | 2013-07-30 00:00:00
 |  | [NAME] | 78987654 - ABC Inc | 2013-10-01 00:00:00
Spreadsheet: 7571c8d5-826b-433e-8d56-cfaab57ad5fe
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Started: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: November 28, 2014 (12:22 pm)
Period | Value
Jan-2008
Feb-2008
Mar-2008
Apr-2008
May-2008
Jun-2008
Jul-2008
Aug-2008
Sep-2008
Oct-2008
Nov-2008
Dec-2008
Jan-2009
Feb-2009
Mar-2009
Apr-2009
May-2009
Jun-2009
Jul-2009
Aug-2009
Sep-2009
Oct-2009
Nov-2009
Dec-2009
[NAME]
[NAME]
Mar-2010
Apr-2010
[NAME]
[NAME]
[NAME]
Aug-2010
Sep-2010
Oct-2010
Nov-2010
Dec-2010
Jan-2011
Feb-2011
Mar-2011
Apr-2011
May-2011
Jun-2011
Jul-2011
Aug-2011
Sep-2011
Oct-2011
Nov-2011
Dec-2011
Jan-2012
Feb-2012
Mar-2012
Apr-2012
May-2012
Jun-2012
Jul-2012
Aug-2012
Sep-2012
Oct-2012
Nov-2012
Dec-2012
Spreadsheet: 01233a58-a09e-42e9-b5dd-3dfae1032a0b
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
 | Total Hourly Rates of Pay Excluding Bonuses: Public 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 ;  Public ;  All industries ; |  |  | Original | A2599999R | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  Public ;  All industries ; |  |  | Original | A2609309R | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  Public ;  All industries ; |  |  | Original | A2601329C | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  Public ;  All industries ; |  |  | Original | A2610639C | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  Public ;  All industries ; |  |  | Original | A2607979R | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  Public ;  All industries ; |  |  | Original | A2602659L | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  Public ;  All industries ; |  |  | Original | A2606649F | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Public ;  All industries ; |  |  | Original | A2605319W | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Public ;  All industries ; |  |  | Original | A2603989W | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 675697d1588433326-leaderboard-duplicate-scores-leaderboard
Sheet: Sheet1

Column1 | Total Score | Position | Round 1 | Round 2 | Round 3 | Round 4 | Round 5 | Column2 | Leaderboard | Column3
A |  |  | 4 | 7 |  |  |  | 1 | 1st Place
B |  |  | 5 | 6 |  |  |  | 2 | 2nd Place
C |  |  | 2 | 2 |  |  |  | 3 | 3rd Place
D |  |  | 6 | 9 |  |  |  | 4 | 4th Place
E |  |  | 7 | 9 |  |  |  | 5 | 5th Place
F |  |  | 8 | 4 |  |  |  | 6 | 6th Place
G |  |  | 3 | 7 |  |  |  | 7 | 7th Place
Spreadsheet: 293025d1390860098-how-to-select-one-of-six-cell-values-depending-on-the-value-of-another-cell-select-a-value-from-a-choice-of-6-possible-cells-version-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choose
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Selection | Value | Selection | Value | Selection | Value | Selection | Value | Selection | Value | Selection | Value |  |  |  | Answer
 |  | 6 | 257 | 1 | 631 | 4 | 475 | 3 | 209 | 1 | 987 | 5 | 105
 |  |  | In this case the selection numbers (1 - 6) in cells C6, E6, G6, I6, K6 and M6 (highlighted in Orange) are not in numerical order.  This means that when I enter, say, a number 1 in the 'choose' cell - P3, the answer comes out as the 1 st selection (cell 6), rather than the one that is linked to the number 1 in cell F6 i.e. 631.
Spreadsheet: marie_heard__24530__ABN Amro ISDA
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY: | Brent Hendry
DATE: | 2001-10-10 00:00:00 | DEAL MAKER: | [NAME]
COUNTERPARTY: | ABN Amro Bank N.V. | CONTACT: | [NAME]
ADDRESS: | [NAME] 10 | TITLE:
 | 1082 PP Amsterdam | PHONE: | 31-20-3836454
 | The Netherlands | FAX: | [EMAIL]
Incorporation State | The Netherlands | S&P Rating | AA
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 100
Incorporation State |  | OR
ELEGIBLE SWAP PARTICIPANT
Counterparty | X | X
Guarantor
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and | AA or above                    50 | AA or above                    50
Moody's ratings | A- or above                      35 | A- or above                      35
 | BBB or above                25 | BBB or above                25
 | BBB-                                   10 | BBB-                                   10
 | Below BBB-                       0 | Below BBB-                       0
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit | X | X
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's
Financial Covenants
-Total Debt to Net Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 100
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
Please deliver draft to [NAME]
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x39591
Spreadsheet: 145537d1331644662-how-to-find-minimum-can-produce-min-how-much-can-do
Sheet: How Much Can Do

 | Product AAA
Requirement | 10000
 | How Many Per | Item Requirement |  | Current Inventory
Item 1 | 1 |  |  | 11000
Item 2 | 5 |  |  | 45000
Item 3 | 6 |  |  | 57000
Item 4 | 9 |  |  | 72000
Item 5 | 10 |  |  | 150000
Item 6 | 11 |  |  | 90000
Item 7 | 7 |  |  | 65000
Item 8 | 0 |  |  | 28000
Item 9 | 1 |  |  | 99000
Item 10 | 2 |  |  | 17100
 |  | Bare Minimum Qty Can do |  | ?????????:)
Spreadsheet: 76019d1276614675-vlookup-example-vlookup
Sheet: Time boxes

 | Time box | Dates | Planned number of hours per time box | Number of hours available | Difference
 | TX1 | 20100531-20100630 | 368 | #N/A | #N/A
 | TX2 | 20100701-20100730 | 0 | #N/A | #N/A
 | TX3 | 20100802-20100831 | 0 | #N/A | #N/A
 | TX4 | 20100901-20100930 | 0 | #N/A | #N/A
 | TX5 | 20101001-20101029 | 0 | #N/A | #N/A
 | TX6 | 20101101-20101130 | 0 | #N/A | #N/A
 | TX7 | 20101201-20101223 | 0 | #N/A | #N/A
 | TX8 | 20110103-20110131 | 0 | #N/A | #N/A
 | TX9 | 20110201-20110228 | 0 | #N/A | #N/A
 | [NAME] | 20110301-20110331 | 0 | #N/A | #N/A
 | TX11 | 20110401-20110429 | 0 | #N/A | #N/A
 | TX12 | 20110502-20110531 | 0 | #N/A | #N/A
 | TX13 | 20110601-20110630 | 0 | #N/A | #N/A
 | TX14 | 20110701-20110729 | 0 | #N/A | #N/A
 |  |  | 368 | #N/A | #N/A
Spreadsheet: 864323d1711544046-how-to-determine-whether-an-employee-is-stiil-working-for-the-same-company-test-m-tier
Sheet: Feuil1

Last Name | First Name | Job Title | Fonction | Sous Fonction | Company Name | [NAME] | Phone Number | Person Score | Toujours dans la société | [NAME] société | MAJ [NAME] | New Job Title | Fonction2 | Sous Fonction3 | MAJ Numéro de téléphone PRO | [NAME]
Bazain | [NAME] | Responsable achats prestations intellectuelles | Achats | Stratégie | Croco |  |  |  | Non | TE
Brazain | Bernard | Performance Achats | Achats | Stratégie | Société Test B |  |  |  | Oui | Société Test B
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: Journal Packages

Packages of Serials Subscribed FY11
Package | No. of Titles | Consortium | Agent | FY10 Price | FY11 Price | % change
Association for [NAME] — ACM Digital Library Package | 250 | [NAME] | HELIN | 3950.99 | 3762.85
American Institute of Physics — AIP Select | 15 | N/A | HELIN | 23440 | 24190
American Accounting Association Electronic Journals Package | 15 | N/A | HELIN | 1354 | 1397
American Chemical Society Web Editions | 45 | N/A | HELIN | 64205 | 65779.38
American Economic Association Journals Site License | 7 | N/A | Direct | 735 | 735
American Fisheries Society Library Subscription Package | 5 | N/A | EBSCO | 1361.28 | 1419.63
American Geophysical Union (AGU) Full Online Journal Publication Package | 19 | N/A | HELIN | 0 | 26296 | N/A
American Physical Society — APS-All | 17 | N/A | EBSCO | 20018.05 | 21048.05
American Society for Microbiology — ASM Online | 16 | N/A | EBSCO | 3980.44 | 4150.93
American Society of Civil Engineers (ASCE) Combination | 36 | N/A | HELIN | 10802 | 11777
American Society of Mechanical Engineers (ASME) Transactions Package 2 | 25 | N/A | HELIN | 7035 | 7310
Annual Reviews Economics Collection | 3 | N/A | HELIN | 0 | 4084 | N/A
Annual Reviews Sciences Collection | 38 | N/A | HELIN | 0 | 7776 | N/A
Anthrosource | 59 | N/A | HELIN | 1516 | 1537
BioOne.1 and BioOne.2 | 162 | N/A | HELIN | 0 | 14472.9 | N/A
Brill Publications Complete Collection | 135 | NERL | HELIN | 3943 | 1347
Cambridge Journals Online | 314 | HELIN | HELIN | 25678 | 28617
Chemical Journal Package International Edition (Wiley) | 8 | N/A | HELIN | 33759 | 37672
[NAME] | 40 | HELIN | HELIN | 2917.45 | 3145.45
Geological Society of America — GSA All | 6 | N/A | EBSCO | 0 | 1837 | N/A
IEEE All-Society Periodicals Package | 168 | N/A | HELIN | 45695 | 47495
JAMA & Archives Journals | 11 | HELIN |  | 0 | 7116.67 | N/A
Journals @ OVID LWW Custom Package | 59 | HELIN | HELIN | 14956 | 16004
JSTOR Current Scholarship Program Current Collections - All (Arts & Sciences I-VIII + Life Sciences) | 170 | N/A | HELIN | 0 | 28582.55 | N/A
Oxford University Press Complete Collection | 242 | NERL | HELIN | 35524.48 | 38340.24
Project Muse Premium collection | 495 | [NAME] | HELIN | 21879 | 23719.78
PsycARTICLES (EBSCO) | 95 | NERL | HELIN | 17969 | 20529
Royal Society of Chemistry Gold Package | 94 | [NAME] | HELIN | 0 | 32340 | N/A
Sage Premier All Access Journals Collection | 600 | NERL | HELIN | 87592.66 | 90380.44
ScienceDirect Book Series | 14 | N/A | HELIN | 3858 | 9434.63
ScienceDirect Freedom Collection | 2088 | Lyrasis | HELIN | 572824.42 | 595837.42
TOTAL / AVERAGE % CHANGE |  |  |  |  |  | 0.064
green = new for FY11
Spreadsheet: 127687d1320480589-index-match-function-how-to-make-row-lookup-array-dynamic-or-variable-index-match-example
Sheet: Raw Data

House | YYYYMM | Plan | Actual
5216 | 201106 | 100 | 85
5216 | 201107 | 100 | 105
5216 | 201109 | 100 | 75
5216 | 201110 | 100 | 93
5216 | 201112 | 78 | 3
4518 | 201101 | 45 | 68
4518 | 201102 | 45 | 0
4518 | 201105 | 60 | 53
4518 | 201106 | 60 | 0
4518 | 201111 | 50 | 40
4518 | 201112 | 25 | 10
5216 | 201101 | 54 | 0
4518 | 201104 | 75 | 32
5216 | 201102 | 133 | 67
4518 | 201107 | 0.35 | 65.8
Spreadsheet: 43317d1241957581-analysing-survel-data-mode-or-count-survey-analysis
Sheet: Sheet1

1
2 | 432 |  |  |  |  |  |  | 5342
23 | 5 | 3 |  |  |  |  |  |  | 4 | 432
324 |  |  | 5 | 3 |  |  | 4325 | 45 |  | 4
32 |  |  | 5 | 4 |  | 34 |  |  |  |  | 243
4 |  |  | 34 |  |  | 4 |  | 452 |  |  | 4
543 |  |  |  | 32 | 4 |  |  |  | 52
5324
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 150034d1334253595-take-column-data-from-one-sheet-to-another-based-on-unique-identifier-sample1
Sheet: Sales

[NAME] | Order number | Version
[EMAIL] | 69009
[EMAIL] | 69010
[EMAIL] | 69011
[EMAIL] | 69012
[EMAIL] | 69013
[EMAIL] | 69014
[EMAIL] | 69015
[EMAIL] | 69016
[EMAIL] | 69017
[EMAIL] | 69018
[EMAIL] | 69019
[EMAIL] | 69020
[EMAIL] | 69021
[EMAIL] | 69022
Spreadsheet: 204979d1357703970-duplicate-values-multiple-rows-to-be-highlited-namematch-moo
Sheet: Sheet1

LAST NAME | FIRST NAME | MIDDLE NAME
BACALLA | CARMELIN | DATO-ON
DESCATIAR | AMALIA | LIBRADILLA
SABANAL | APOLINARIA | PANTINOPLE
ANCILING | MERALONA | PAGLINAWAN
GARBO | ROUGIE | LAPING
SELERIO | CATALINA | ELESTERIO
AMIT | MARICEL | TAMPUS
GARBO | ROUGIE | LAPING
TABORADA | ELENA | YBANEZ
LILO-AN | RODELYN | CORTA
DESCATIAR | AMALIA | LIBRADILLA
SUMALINOG | ARLINDA | BAAY
COSEDO | DIOGRACIA | INCIPIDO
TAC-AN | CHEERY | TERO
Spreadsheet: 286995d1388566629-find-out-common-and-uncommon-records-data-match-jacc
Sheet: Sheet1

CC-1 | CC-2 | CC-3 | Common in A and B | Only in A not in B | Only in B not in A | Common in A and C | Only in A not in C | Only in C not in A | Common in B and C | Only in B not in C | Only in C not in B | Common in A, B and C
12 | 22 | 44 |  |  | 22 |  |  | 44 |  |  | 44 | ??
11 | 11 | 13 |  |  |  |  |  |  |  |  | 13
13 | 33 | 14 |  |  | 33
14 | 14 | 16 |  |  |  |  |  |  |  |  | 16
15 | 15 | 20
16 | 17 | 17
17 | 20 | 25 |  |  |  |  |  | 25 |  |  | 25
18 | 33 | 29 |  |  | 33 |  |  | 29 |  |  | 29
19 | 14 | 40 |  |  |  |  |  | 40 |  |  | 40
20 | 21 | 18 |  |  | 21 |  |  |  |  |  | 18