tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cd13ec86-1e75-4c6b-a4a6-b715179dce3a
Sheet: Sheet1

VARSITY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Number | Name | Year | Position | Height
3 | [NAME] | 12 | OH | 5'6"
4 | [NAME] | 10 | OH | 5'6"
5 | [NAME] | 10 | S | 5'6"
10 | [NAME] | 12 | OH | 5'4"
11 | [NAME] | 12 | OH | 5'3"
12 | [NAME] | 11 | OH | 5'7"
13 | Olivia Nagler | 11 | MH | 5'7"
14 | [NAME] | 11 | MH | 5'9"
15 | [NAME] | 9 | OH | 5'5"
20 | [NAME] | 10 | OH | 5'11"
23 | [NAME] | 11 | MH | 5'8"
JV
Number | Name | Year | Position | Height
3 | [NAME] | 10 | OH | 5'5"
4 | [NAME] | 10 | OH | 5'6"
5 | [NAME] | 10 | S | 5'6"
11 | [NAME] | 9 | MH | 5'5"
12 | [NAME] | 10 | OH | 5'3"
13 | [NAME] | 9 | OH | 5'4"
14 | Brooke Silliker | 9 | OH | 5'4"
20 | [NAME] | 10 | MH | 5'11"
21 | [NAME] | 9 | MH | 5'4"
22 | [NAME] | 9 | OH | 5'4"
23 | [NAME] | 11 | MH | 5'8"
FRESHMEN
Number | Name | Year | Position | Height
3 | [NAME] | 9 | OH | 5'7"
4 | Brooke Silliker | 9 | S | 5'4"
5 | [NAME] | 9 | OH | 5'3"
10 | [NAME] | 9 | S | 5'5"
12 | [NAME] | 9 | OH | 5'6"
13 | Lauren Cain | 9 | MH | 5'6"
14 | [NAME] | 9 | OH | 5'6"
15 | Hanna Lewis | 9 | OH | 5'6"
20 | [NAME] | 9 | OH | 5'5
21 | [NAME] | 9 | MH | 5'3"
23 | [NAME] | 9 | MH | 5'4"
24 | [NAME] | 9 | OH | 5'1"
Managers:  [NAME], [NAME], [NAME]
Coach:  [NAME]
Assistant Coaches:  [NAME],  [NAME]
Superintendent:  [NAME]
Principal:  [NAME]
Assistant [NAME]:  [NAME]
Activities Director:  [NAME]
[NAME]:  [NAME]
Cheerleaders:  [NAME], [NAME], [NAME]
Spreadsheet: 809641d1671195000-formula-that-sums-only-positive-values-how-to-avoid-that-it-counts-negative-days
Sheet: Data

 |  |  |  |  | Employee | Title | Fist absence day | Last absence day | Days | Reason
 |  |  |  |  | [NAME] | Sales Manager | 2021-12-08 00:00:00 | 2021-12-08 00:00:00 |  | Sickness
 |  |  |  |  | [NAME] | [NAME] Analyst | 2022-12-12 00:00:00 | 2022-12-15 00:00:00 |  | Sickness
 |  |  |  |  | [NAME] | Sales Advisor | 2021-11-05 00:00:00 | 2021-11-10 00:00:00 |  | Sickness
 |  |  |  |  | [NAME] | Finance Director | 2021-12-20 00:00:00 | 2021-12-23 00:00:00 |  | Sickness
 |  |  |  |  | [NAME] | Sales Manager | 2021-12-17 00:00:00 | 2021-12-23 00:00:00 |  | Sickness
 |  |  |  |  | [NAME] | Sales Advisor | 2021-12-15 00:00:00 | 2021-12-16 00:00:00 |  | Sickness
Spreadsheet: 701645d1603871421-list-all-names-that-contains-specific-text-sample
Sheet: List of Names Here

NURSE III | GRADE | NURSE IV | GRADE | NURSE V | GRADE | NURSE VI | GRADE
Spreadsheet: stacey_white__38844__BLANKBOOKREQUEST
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  |  | Risk Management
Subject: | New Book Request
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason for Book | Administrator* | MTM | Prud | Realized
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
 | BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | Access List:
 | trohaue (needs to have access to all books)
 |  |  | RisktRAC Check list |  | Added (y/n) | Processors ID
 | [NAME]
 | [NAME] |  | Created in RisktRAC
 | [NAME] |  | hierarchy
 | [NAME] |  | Master booklist
 | Any questions, please contact me |  | Sent to GCP
 |  |  | Sent to TAGG/ERMS
 | (x31462) |  | [NAME]
Spreadsheet: 855926d1705370050-add-a-scroll-bar-to-scroll-through-columns-from-left-to-right-w-o-pivot-table-reference-scroll-through-columns
Sheet: Planilha1

 |  | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 125 | 130 | 135 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150
Tag | 1 | 18 | 20 | 19 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 19 | 20 | 19 | 19 | 19 | 19 | 19 | 18 | 19 | 18 | 19 | 18 | 15
Tag | 2 | 18 | 19 | 19 | 19 | 19 | 20 | 20 | 20 | 20 | 20 | 20 | 19 | 20 | 20 | 19 | 20 | 20 | 20 | 19 | 18 | 19 | 19 | 19 | 18 | 19 | 19 | 17
 |  |  |  |  |  |  |  | 0
Spreadsheet: 842294d1694423843-updating-cells-from-one-sheet-to-another-example
Sheet: Workout

 | Venue | Venue tx | Venue £ | Res tx | Res £ | TM tx | TM £ | Disney tx | Disney £ | TOTAL tx | TOTAL £
 | Aberdeen | 3419 | 76699 |  | 0 | 0 |  | 0
 | Belfast | 5521 | 117233.07 |  |  | 1248 | 32364.5
 | Birmingham | 8997 | 194921.31 | 138 | 2863.78 | 1901 | 52055.5
 | Bradford | 586 | 12970 |  |  | 554 | 12253
 | Brighton | 2269 | 52784.5
 | Bristol | 3092 | 74208 | 71 | 1013.5
 | Canterbury | 3943 | 82842.68 | 106 | 2055.08 | 383 | 10256
 | Cardiff | 7021 | 168429 | 375 | 9311 | 3123 | 75726
 | Dublin | 5654 | 131617 |  |  | 0 | 0
 | Edinburgh | 892 | 17514.92 | 32 | 635 | 1920 | 45564
 | [NAME] | 14281 | 317077.5
 | High Wycombe | 1675 | 30150 | 79 | 1422 | 1260 | 22680
 | Hull | 2832 | 62721
 | Ipswich | 2122 | 45199.48 | 4 | 94 | 2071 | 49805 | 0 | 0
 | Leeds | 3466 | 77419 | 0
 | Liverpool | 1820 | 39922.5 |  |  | 2606 | 64497.5
 | Llandudno | 1357 | 30169 | 62 | 1355 | 1309 | 29639
 | London | 28422 | 728140.39 | 6 | 129 | 19070 | 487325
 | Newcastle | 3906 | 84870 | 243 | 4630.2
 | Northampton | 1505 | 28971 |  |  | 1291 | 28605
 | [NAME] | 2785 | 52687.22 | 115
 | [NAME] | 4288 | 94420.45 | 41 | 972 | 1000 | 25000
 | Oxford | 1762 | 36890.75
 | Peterborough | 745 | 17886 | 13 | 341 | 1168 | 27233
 | Plymouth | 2852 | 64360.5 | 61 | 1468
 | Salford | 2031 | 44650.15 | 46 | 951.6 | 3261 | 67776 | 0 | 0
 | Sheffield
 | Southampton | 2026 | 42359.25 | 94 | 2098.08 | 1916 | 41399
 | Southend | 3164 | 73813.68 |  |  | 2869 | 69525
 | Swansea | 1751 | 41858
 | Truro
 | Wolverhampton | 1445 | 29575.75 | 22 | 475.94 | 688 | 13612
 | TOTALS
Spreadsheet: 606266d1547553839-1-to-matching-cells-book2
Sheet: Sheet1

PC | Unique
1010001 |  | 1010001_1
1010001 |  | 1010001_2
1010001 |  | 1010001_3
1010002 |  | 1010002_1
1010002 |  | 1010002_2
1010002 |  | 1010002_3
Spreadsheet: 824127d1680319532-auto-fill-cell-book1
Sheet: SHEET 2

 | Name:
MONDAY | DATE: | 2023-03-20 00:00:00
 | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 5553 |  | AM | 09:00:00 | AM |  | 680 | AM | ✓ | AM | ✓
 |  |  | PM | 17:00:00 | PM |  | 473 | PM | ✓ | PM | ✓
 | CHARTER # | SIGN ON |  | SIGN OFF |  | SIGN ON | SIGN OFF | SIGN ON |  | SIGN OFF
 | 193477
TUESDAY | DATE:
 | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  | AM |  | AM |  |  | AM | ✓ | AM | ✓
 |  |  | PM |  | PM |  |  | PM | ✓ | PM | ✓
 | CHARTER # | SIGN ON |  | SIGN OFF |  | SIGN ON | SIGN OFF | SIGN ON |  | SIGN OFF
 | 0
WEDNESDAY | DATE:
 | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  | AM |  | AM |  |  | AM | ✓ | AM | ✓
 |  |  | PM |  | PM |  |  | PM | ✓ | PM | ✓
 | CHARTER # | SIGN ON |  | SIGN OFF |  | SIGN ON | SIGN OFF | SIGN ON |  | SIGN OFF
 | 0
THURSDAY | DATE:
 | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  | AM |  | AM |  |  | AM | ✓ | AM | ✓
 |  |  | PM |  | PM |  |  | PM | ✓ | PM | ✓
 | CHARTER # | SIGN ON |  | SIGN OFF |  | SIGN ON | SIGN OFF | SIGN ON |  | SIGN OFF
 | 0
FRIDAY | DATE:
 | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  | AM |  | AM |  |  | AM | ✓ | AM | ✓
 |  |  | PM |  | PM |  |  | PM | ✓ | PM | ✓
 | CHARTER # | SIGN ON |  | SIGN OFF |  | SIGN ON | SIGN OFF | SIGN ON |  | SIGN OFF
 | 0
 |  | AM |  |  | PM
 |  | Sign on | Sign Off |  | Sign on | Sign Off
☺ | 1 |  |  |  | 14:45:00 | 16:45:00
😆 | 5551 | 07:15:00 | 08:50:00 |  | 14:45:00 | 16:45:00
☺ | 5552 AM | 07:00:00 | 08:50:00
😆 | 5552 PM |  |  |  | 14:30:00 | 16:00:00
☺ | 5553 | 06:30:00 | 09:00:00 |  | 14:00:00 | 17:00:00
😆 | 5554 | 07:00:00 | 08:50:00 |  | 14:00:00 | 17:00:00
☺ | 5555 | 07:15:00 | 09:15:00 |  | 14:30:00 | 17:00:00
with Tech | 5555T | 07:15:00 | 10:00:00 |  | 13:30:00 | 17:00:00
☺ | 5556 | 07:15:00 | 09:15:00 |  | 14:30:00 | 17:00:00
with Tech | 5556T | 07:15:00 | 10:00:00 |  | 13:30:00 | 17:00:00
☺ | 5557 | 07:35:00 | 08:50:00 |  | 14:45:00 | 16:30:00
😆 | 5558 | 06:55:00 | 08:50:00 |  | 14:45:00 | 16:45:00
☺ | 5559 | 06:45:00 | 08:50:00 |  | 14:00:00 | 16:55:00
😆 | 5560 | 07:15:00 | 08:50:00 |  | 14:45:00 | 16:40:00
☺ | 5561 | 07:00:00 | 08:50:00 |  | 14:00:00 | 16:15:00
😆 | 5562 | 07:15:00 | 08:50:00 |  | 14:45:00 | 16:45:00
☺ | 5563 | 07:00:00 | 08:50:00 |  | 14:45:00 | 16:55:00
Spreadsheet: 121983d1316536960-data-populate-after-choosing-a-field-from-a-drop-down-like-this-1
Sheet: Sheet2

Last | First | MI | Grade
Adams | [NAME] | V | [NAME]
[NAME] | Kayla | P | Grade 5
Dominguez | [NAME] | W | Pre K
Griffin | [NAME] | C | Grade 11 | 5
Henri | [NAME] | M | [NAME]
Hilton | [NAME] | C | Grade 6
Jacobs | Kylie | E | Grade 11 | 8
[NAME] | Stacy | A | Grade 12
Phillips | [NAME] | S | Grade 11 | 10
Simpleton | [NAME] | J | [NAME]
[NAME] | [NAME] | B | Grade 7
[NAME] | Stanley | L | Grade 11 | 13
White | [NAME] | N | Grade 10
Wilshere | [NAME] | P | Grade 11 | 15
Spreadsheet: 124618d1318512549-picking-entries-left-to-right-and-skipping-blanks-example-with-6-columns
Sheet: Sheet1

white | red | blue | green
 | yellow |  | blue | orange
white | black |  |  |  | gold
red |  | green | pink
 | [NAME]
Spreadsheet: 34055d1231173956-trying-to-run-a-script-example
Sheet: Sheet2

ID EX | Script
1 | 1
2 | 1;2
3 | 1;2;3
4 | 1;2;3;4
5 | 1;2;3;4;5
6 | 1;2;3;4;5;6
7 | 1;2;3;4;5;6;7
8 | 1;2;3;4;5;6;7;8
9 | 1;2;3;4;5;6;7;8;9
10 | 1;2;3;4;5;6;7;8;9;10
11 | 1;2;3;4;5;6;7;8;9;10;11
12 | 1;2;3;4;5;6;7;8;9;10;11;12
13 | 1;2;3;4;5;6;7;8;9;10;11;12;13
14 | 1;2;3;4;5;6;7;8;9;10;11;12;13;14
15 | 1;2;3;4;5;6;7;8;9;10;11;12;13;14;15
16 | 1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16
17 | 1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17
18 | 1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18
Spreadsheet: 88267d1288128728-support-renewal-formulae-assistance-support-test
Sheet: Renewals

 | Renewals by Year
 | 2010
 | Product | Serial | Start Date | End Date | 1yr Cost
 | 2011
 | Product | Serial | Start Date | End Date | 1yr Cost
 | 2012
 | Product | Serial | Start Date | End Date | 1yr Cost
 | 2013
 | Product | Serial | Start Date | End Date | 1yr Cost
Spreadsheet: 676562d1588869452-data-validation-automatic-case-adjustment-sample
Sheet: Lists

Source |  | Vendor |  | Expense Category
Cash |  | Albertson's |  | Charity
Check |  | Amazon |  | Clothing
Debit - BofA |  | Home Depot |  | Computer Related
Debit - Credit Union |  | [NAME]'s |  | Credit Card
Discover Card |  | Safeway |  | Dining
MasterCard |  | Target |  | Entertainment
Money Order |  | Tractor Supply |  | Gas
VISA |  |  |  | Groceries
 |  |  |  | Hardware
 |  |  |  | Health Insurance
 |  |  |  | Home Furnishings
 |  |  |  | Home Improvement
 |  |  |  | Home Maintenance
 |  |  |  | Insurance
 |  |  |  | Internet Service
 |  |  |  | Lawn/Garden
 |  |  |  | Life Insurance
 |  |  |  | Medical/Dental
 |  |  |  | Mortgage
 |  |  |  | Other
 |  |  |  | Personal Care
 |  |  |  | Property Tax
 |  |  |  | Recreation
 |  |  |  | Sporting Goods
 |  |  |  | Telephone
 |  |  |  | Tools
 |  |  |  | Travel
 |  |  |  | Utilities
 |  |  |  | Vacation
 |  |  |  | Vehicle Maintenance
 |  |  |  | Vehicle Registration
Spreadsheet: kate_symes__18174__NP 2-26
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
Spreadsheet: 871070d1717510665-combine-with-ampersand-concatenate-example-tms_2-
Sheet: Sheet1

A100 | +1 | -1 | +2 | -2 |  |  | Maybe: A1: A100, B1: +1, C1: -1, D1: +2, E1: -2
 |  |  |  |  |  |  | Output: B2: A101, C2: A99, D2: A102, E2: A98
 |  |  | 43 |  | -5
 |  |  | 22 |  | -1
 |  |  | 55 |  | 0 |  | =  sum    d20    d19 d21 d15 d25 (offset +1 +5 -1 -5 around D20)
 |  |  | 3 |  | +1
 |  |  | -9 |  | +5
Spreadsheet: 881118d1729033428-fairly-easy-problem-rank-items-by-score-using-a-recursive-function-sample-3-
Sheet: Full

Category | Item | Weighted Score | Ranking |  | Category.1 | Item.1 | Weighted Score.1 | Rank.1
Cat1 |  |  |  |  | Cat1 | Item1 | 35 | 3
 | Item1 | 35 |  |  | Cat1 | Item2 | 33 | 6
 | Item2 | 33 |  |  | Cat1 | Item3 | 30 | 9
 | Item3 | 30 |  |  | Cat1 | Item4 | 30 | 9
 | Item4 | 30 |  |  | Cat1 | Item5 | 22 | 17
 | Item5 | 22 |  |  | Cat1 | Item6 | 22 | 17
 | Item6 | 22 |  |  | Cat2 | Item1 | 38 | 1
 |  |  |  |  | Cat2 | Item2 | 36 | 2
 |  |  |  |  | Cat2 | Item3 | 35 | 3
 |  |  |  |  | Cat2 | Item4 | 28 | 12
 |  |  |  |  | Cat2 | Item5 | 21 | 20
 |  |  |  |  | Cat3 | Item1 | 35 | 3
Cat2 |  |  |  |  | Cat3 | Item2 | 32 | 7
 | Item1 | 38 |  |  | Cat3 | Item3 | 32 | 7
 | Item2 | 36 |  |  | Cat3 | Item4 | 29 | 11
 | Item3 | 35 |  |  | Cat3 | Item5 | 27 | 14
 | Item4 | 28 |  |  | Cat3 | Item6 | 26 | 15
 | Item5 | 21 |  |  | Cat3 | Item7 | 23 | 16
 |  |  |  |  | Cat3 | Item8 | 21 | 20
 |  |  |  |  | Cat4 | Item1 | 20 | 22
 |  |  |  |  | Cat4 | Item2 | 19 | 23
 |  |  |  |  | Cat4 | Item3 | 18 | 24
Cat3 |  |  |  |  | Cat4 | Item4 | 16 | 25
 | Item1 | 35 |  |  | Cat4 | Item5 | 16 | 25
 | Item2 | 32 |  |  | Cat5 | Item1 | 28 | 12
 | Item3 | 32 |  |  | Cat5 | Item2 | 22 | 17
 | Item4 | 29
 | Item5 | 27
 | Item6 | 26
 | Item7 | 23
 | Item8 | 21
Cat4
 | Item1 | 20
 | Item2 | 19
 | Item3 | 18
 | Item4 | 16
 | Item5 | 16
Cat5
 | Item1 | 28
 | Item2 | 22
Spreadsheet: 17b14b91-fc5b-4572-b18d-31390b023bba
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Q1 2012 - Largest U.S. Venture Capital Investments
Company | City | State | Industry | Stage of Development | Investment Sequence | Amount | Business Description | Investors
SquareTrade, Inc. | San Francisco | CA | Consumer Products and Services | Later Stage | 4 | 238000000 | SquareTrade, Inc. provides extended warranty services for electronics. | Bain Capital,Bain Capital Ventures
Sapphire Energy, Inc. | San Diego | CA | Industrial/Energy | Early Stage | 7 | 139000000 | Sapphire Energy, Inc. develops algae-based green crude oil. | ARCH Venture Partners,Monsanto Corporation,Undisclosed Firm,Venrock Associates
Fisker Automotive, Inc. | Anaheim | CA | Industrial/Energy | Later Stage | 12 | 129720000 | Fisker Automotive, Inc. designs and manufactures electric vehicles. | Kleiner Perkins Caufield & Byers,New Enterprise Associates, Inc.
[NAME] | [NAME] | TX | Software | Later Stage | 2 | 116832000 | Provides online data and tools to the oil and gas industry. | Battery Ventures, L.P.,Eastern Advisors Private Fund, L.P.,Insight Venture Partners
ConforMIS, Inc. | Burlington | MA | Medical Devices and Equipment | Later Stage | 4 | 89000000 | Develops medical devices for osteoarthritis treatment and joint damage. | AGC Equity Partners, Ltd.,Undisclosed Firm,Undisclosed Firm,Undisclosed Firm
Trion Worlds, Inc. | Redwood City | CA | Software | Expansion | 5 | 85104000 | Develops gaming software and original entertainment. | Bertelsmann Capital,Teachers' Private Capital
Yammer, Inc. | San Francisco | CA | Media and Entertainment | Expansion | 5 | 85000400 | Yammer, Inc. provides social networking services for the enterprise. | Capricorn Investment Group LLC,Charles River Ventures,CrunchFund,Draper Fisher Jurvetson,Emergence Capital Partners LLC,Founders Fund, The,Khosla Ventures,Meritech Capital Partners,Social+Capital Partnership, The,U.S. Venture Partners,Undisclosed Firm
Internet Pipeline, Inc. | Exton | PA | Software | Later Stage | 5 | 71435100 | Provides software services to the insurance and financial services markets. | NewSpring Capital,Technology Crossover Ventures,Volition Capital LLC
PlayPhone, Inc. | San Jose | CA | Software | Later Stage | 10 | 67247200 | PlayPhone, Inc. is a mobile entertainment content provider. | Cardinal Venture Capital,Coral Group LLC,Menlo Ventures,Scale Venture Partners
SolarCity Corporation | San Mateo | CA | Industrial/Energy | Expansion | 8 | 66000000 | SolarCity Corporation provides solar power system installation services. | DBL Investors,J. F. Shea Co., Inc.,Silver Lake,Undisclosed Firm,Valor Equity Partners
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 737165d1624259363-multiple-criteria-lookup-with-index-and-match-match-ans
Sheet: Matrix-2

Data |  |  |  |  |  |  |  |  |  |  | Result 1 |  |  |  |  |  |  |  |  |  |  | Result 2
Match 1 Column | Match 2 Column |  | Match 3 Column |  | Invisible |  |  |  | Match 1 Row > |  | Pol | [NAME] | BOP | Poly | Ink | Red | Chem | Tol | Wov | Pfilm |  | Pol | [NAME] | BOP | Poly | Ink | Red | Chem | Tol | Wov | Pfilm
 |  | Pull 1 |  | PN | Pull 2 | x | y |  |  | PN | Pull 1 i.e C Column Data |  |  |  |  |  |  |  |  |  |  | Pull 1 i.e F Column Data
2077.4.1 | Pol |  |  |  |  | x | y | Match 3 Column | Match 2 Column
 | [NAME] |  |  |  |  | x | y
 | BOP | 1110 | PBS |  |  | x | y
 | Poly | 6500 | PLR | 5850 |  | x | y |  | PLR
 | Ink | 1010 | PBS | 999 | 1010 | x | y |  | PBS
 | Red | 140 | PBS |  | 140 | x | y
 | Red | 1040 | PLR |  | 1040 | x | y
 | Chem | 780 | PLR |  | 780 | x | y
Spreadsheet: 118608d1313786420-duplicate-value-function-pivottable
Sheet: Sheet1

School | Group | Result |  | Result | PASS
School 1 | Computer | PASS
School 1 | Biology | PASS |  | Row Labels
School 2 | Computer | PASS |  | School 1
School 3 | Commerce | PASS |  | School 2
School 4 | Maths | FAIL |  | School 3
 |  |  |  | Grand Total
Total Number of Schools | 4
Total Number of schools passed
Spreadsheet: 124414d1318395773-counting-unique-values-in-a-table-based-upon-criteria-of-other-columns-counting-values
Sheet: Split Sheet

 |  |  |  | VT | 2011 |  | Customers | Count
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | Hi, [NAME]'s in Columns A to D look at your data on the Data sheet. [NAME]'s in Column F Test the Year State and Amount then uses Customers Number If True. Column I Places a 1 if the customer meets Column F criteria. J1 produces Result
 |  |  |  |  |  |  |  |  |  | To use this you should only need to copy the data to this sheet. Provided it is the format is true. I did use Ctrl H to remove Spaces (ie " ")  and the "-"'s.
Spreadsheet: 747394d1631468012-formula-help-to-help-build-a-stock-inventory-excel-help-om-edited
Sheet: Requirements

Candle 1 |  |  |  | Candle 2 |  |  |  |  | Candle 1 | Candle 2 | Candle 3 | Candle 4 | Candle 5 | Candle 6 | Candle 7 | Candle 8 | Candle 9 | Candle 10
[NAME] | 1 | ml |  | OM002 | 1 | ml |  | [NAME] | 1 |  |  |  |  | 1 | 1
OM004 | 10 | piece |  | OM005 | 8 | piece |  | OM002 |  | 1 |  |  | 1 |  |  | 1
OM015 | 165 | g |  | OM015 | 170 | g |  | [NAME] |  |  | 1 | 1 |  |  |  |  | 1 | 1
OM017 | 1 | piece |  | OM017 | 1 | piece |  | OM004 | 10
OM021 | 1 | piece |  | OM022 | 1 | piece |  | OM005 |  | 8
OM031 | 1 | piece |  | OM032 | 1 | piece |  | OM006 |  |  | 9
OM041 | 1 | piece |  | OM41 | 1 | piece |  | OM007 |  |  |  | 11
OM042 | 1 | piece |  | OM43 | 1 | piece |  | OM008 |  |  |  |  | 10
 |  |  |  |  |  |  |  | OM009 |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | OM011 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | OM012 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | OM013 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | OM014 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | OM015 | 165 | 167 | 166 | 164 | 165 | 168 | 165 | 167 | 166 | 166
 |  |  |  |  |  |  |  | OM016
 |  |  |  |  |  |  |  | OM017 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | OM018 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  | OM019
 |  |  |  |  |  |  |  | OM020
 |  |  |  |  |  |  |  | OM021 | 1
 |  |  |  |  |  |  |  | OM022 |  | 1
 |  |  |  |  |  |  |  | OM023 |  |  | 1
 |  |  |  |  |  |  |  | OM024 |  |  |  | 1
 |  |  |  |  |  |  |  | OM025 |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM026 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM027 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM028 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM029 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM031 | 1
 |  |  |  |  |  |  |  | OM032 |  | 1
 |  |  |  |  |  |  |  | OM033 |  |  | 1
 |  |  |  |  |  |  |  | OM034 |  |  |  | 1
 |  |  |  |  |  |  |  | OM035 |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM036 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM037 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM038 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM039 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM040 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | OM041 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | OM042 | 1 |  | 1 |  | 1 |  | 1 |  | 1
 |  |  |  |  |  |  |  | OM043 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 |  |  |  |  |  |  |  | No. Components
Spreadsheet: 217292d1362037784-if-with-vlookup-if-with-vlookup
Sheet: IF

APPLE = 1 | 1 | APPLE | APPLE | 1
ORANGE = 2 | 2 | ORANGE | ORANGE | 2
MANGO = 3 | 3 | MANGO | MANGO | 3
BANANA = 4 | 4 | BANANA | BANANA | 4
Spreadsheet: 160888d1339277408-counting-number-randomly-roulette
Sheet: Sheet2

1 to 18 |  |  | ZERO
19 to 36 |  |  | ZERO %
Red
Black
Even
Odd
1st 12
2nd 12
3rd 12
1st Column
2nd Column
3rd Column