tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: PP

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 215548d1361404726-order-form-worksheet-populated-sequentially-with-items-selected-from-other-worksheets-ef360_sample
Sheet: Fluorescent

SKU | CAT # | [NAME] | PRICE |  |  |  | 0 | <-- NOTE: starting sheet, so must be zero
5587456 | CB 601 | 1 Lamp Surface Wrap | 88 |  |  | False
558746 | CB 608 | 2 lamp Surface Wrap | 89 |  |  | False
6985569 | CB 995 | 3 Lamp Suface Wrap | 98 |  |  | True
6652138 | CG 88 | 2 Lamp Recessed Troffer | 105 |  |  | False
842684 | CG 98 | 3 Lamp Recessed Troffer | 110 |  |  | False
8887988 | CG 108 | 4 Lamp Recessed Troffer | 155 |  |  | True
898815 | EF 885 | 2 Lamp Strip | 68 |  |  | False
 |  |  |  |  |  |  |  | <-- [NAME] copied
 |  |  |  |  |  |  |  | down to row 15 - copy
 |  |  |  |  |  |  |  | further if needed
Spreadsheet: 806702d1669497733-spill-array-with-textjoin-and-duplicate-lines-textjoin-filtered
Sheet: Sheet1

 | Starting Point |  |  |  |  | SINGLE spill array wanted |  |  |  | Currently, I can't get the green bit to spill
 | Thing 1 | Thing 2 | Thing 3 |  |  | Thing 1 | Thing 2 | Thing 3
 | QQQ | ASD | abc |  |  | QQQ | ASD | abc |  |  | ASD
 | WWW | SDF | bcd |  |  | WWW | SDF | bcd, cde,def |  | WWW | SDF
 | WWW | SDF | cde |  |  | EEE | DFG | efg |  | EEE | DFG
 | WWW | SDF | def |  |  | RRR | FGH | fgh |  | RRR | FGH
 | EEE | DFG | efg |  |  | TTT | GHJ | ghi |  | TTT | GHJ
 | RRR | FGH | fgh |  |  | YYY | HJK | hij, ijk |  | YYY | HJK
 | TTT | GHJ | ghi
 | YYY | HJK | hij
 | YYY | HJK | ijk
Spreadsheet: 861125d1709098664-please-help-me-sum-values-in-one-column-when-values-from-another-column-changes-example-3-
Sheet: Sheet1

Long | 2
Long | 3
Short | 1
Short | 5
Short | 6
Long | 4
Long | 2
Long | 1
Long | 1
Short | 3
Long | 4
Long | 5
Short | 2
Short | 3
Short | 1
Short | 1
Long | 3
Long | 1
Spreadsheet: 127460d1320354482-skipping-rows-when-autofilling-formulas-excell-need-help
Sheet: Sheet1

 | Sample X1 | 0.02413333333333334 | 0.008933333333333328
 | Sample X1 | 0.03883333333333334 | 0.01253333333333333
 | Sample X1 | 0.03113333333333333 | 0.01163333333333333
 | Sample X2 | 0.01733333333333334 | 0.00973333333333333
 | Sample X2 | 0.02093333333333333 | 0.01733333333333333
 | Sample X2 | 0.01523333333333333 | 0.01553333333333333
 | Sample X3 | 0.02143333333333333 | 0.01163333333333333
 | Sample X3 | 0.01303333333333334 | 0.01433333333333333
 | Sample X3 | 0.02083333333333334 | 0.01273333333333333
 | [NAME] | -0.001666666666666664 | 0.006533333333333332
 | [NAME] | 0.01033333333333333 | 0.01493333333333333
 | [NAME] | 0.01993333333333334 | 0.01743333333333333
averages
Spreadsheet: 774274d1648349599-looking-for-formula-to-extract-values-into-column-a-d-looking-into-tab-here-and-look-pullvaluesindexandaggregate
Sheet: Here

Sales ID | Dealer | [NAME] I | Sales Person II
1103 | GEE G | [NAME] | Facc
1103 | GEE G | [NAME] | Murp
1103 | GEE G | [NAME] | Fitz
1103 | GEE G | Well | Jone
1103 | GEE G | Lawr | Hile
1103 | GEE G | E. W | [NAME]
1103 | GEE G | [NAME] | Bowl
1103 | GEE G | Rich | [NAME]
1103 | GEE G | [NAME] | Ozar
1103 | GEE G | Dane | [NAME]
1103 | GEE G | Will | [NAME]
1103 | GEE G | Rex | Mart
1103 | GEE G | [NAME] | Murp
1103 | GEE G | [NAME] | Fitz
1103 | GEE G | Well | Jone
1103 | GEE G | [NAME] | Hile
1103 | GEE G | E. W | [NAME]
1103 | GEE G | [NAME] | Bowl
1103 | GEE G | Rich | [NAME]
1103 | GEE G | [NAME] | Ozar
1103 | GEE G | Clai | Skin
1103 | GEE G | Dane | [NAME]
1103 | GEE G | Will | [NAME]
1103 | GEE G | Rex | Mart
1103 | GEE G | [NAME] | Murp
1103 | GEE G | [NAME] | Fitz
1103 | GEE G | Well | Jone
1103 | GEE G | Lawr | Hile
1103 | GEE G | E. W | [NAME]
1103 | GEE G | Rich | [NAME]
1103 | GEE G | [NAME] | Ozar
1103 | GEE G | Clai | Skin
1103 | GEE G | Dane | [NAME]
1103 | GEE G | Will | [NAME]
1103 | GEE G | Rex | Mart
N193 | [NAME] | [NAME] | Fost
N193 | [NAME] | Robe | Sand
N193 | [NAME] | [NAME] | Misc
N193 | [NAME] | Greg | Shep
N193 | [NAME] | [NAME] | De N
N193 | [NAME] | Roxa | [NAME]
N193 | [NAME] | Will | Dool
N193 | [NAME] | Howa | Smit
N193 | [NAME] | Will | Mell
N193 | [NAME] | [NAME] | Misc
N193 | [NAME] | Greg | Shep
N193 | [NAME] | [NAME] | De N
N193 | [NAME] | Roxa | [NAME]
N193 | [NAME] | Will | Dool
N193 | [NAME] | Bruc | Marl
N193 | [NAME] | Howa | Smit
N193 | [NAME] | [NAME] | Fost
N193 | [NAME] | Robe | Sand
N193 | [NAME] | [NAME] | Misc
N193 | [NAME] | Greg | Shep
N193 | [NAME] | [NAME] | De N
N193 | [NAME] | Roxa | [NAME]
N193 | [NAME] | Will | Dool
N193 | [NAME] | Bruc | Marl
N193 | [NAME] | Howa | Smit
N193 | [NAME] | [NAME] | Fost
N193 | [NAME] | Robe | Sand
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 16b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending December 14, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 717360d1612611338-having-a-2nd-and-3rd-cascading-dropdown-list-off-a-first-dropdown-book1-11-ans
Sheet: Sheet1

dogs |  | dogs | cats | mice
cats | mice | black | yelllow | red |  | Three named ranges created.
mice | violet | [NAME] | white | green |  | dogsexn
 | [NAME] | green | teal | orange |  | catsexn
 |  | blue | [NAME] | violet |  | miceexn
 |  | dogs | cats | mice
 |  | long | bald | short1
 |  | short | short | [NAME] |  | formula for DV in B4 is
 |  | medium | long | short3 |  | =INDIRECT($B$2&"exn")
Spreadsheet: 82236d1282241338-hyperlink-hyperlink
Sheet: Data

Number | Consumers | Date | products ordered | cost per unit | Units ordered | TAX | Total Cost | Hyperlinks
1 | Consumer 1 | 2010-01-02 00:00:00 | computer | 300 | 5 | 0.1 | 150 | File1
2 | Consumer 2 | 2010-02-02 00:00:00 | scaner | 50 | 6 | 0.1 | 30 | File2
3 | Consumer 3 | 2010-03-02 00:00:00 | printer | 60 | 7 | 0.1 | 42 | etc…
4 | Consumer 4 | 2010-04-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
5 | Consumer 5 | 2010-05-02 00:00:00 | computer | 300 | 5 | 0.1 | 150
6 | Consumer 6 | 2010-06-02 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 7 | 2010-07-02 00:00:00 | printer | 60 | 7 | 0.1 | 42
 | Consumer 8 | 2010-08-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
 | Consumer 9 | 2010-09-02 00:00:00 | computer | 300 | 5 | 0.1 | 150
 | Consumer 10 | 2010-10-02 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 11 | 2010-11-02 00:00:00 | printer | 60 | 7 | 0.1 | 42
7 | Consumer 5 | 2010-01-03 00:00:00 | calculator | 5 | 100 | 0.1 | 50
8 | Consumer 6 | 2010-02-03 00:00:00 | computer | 300 | 5 | 0.1 | 150
9 | Consumer 7 | 2010-03-03 00:00:00 | scaner | 50 | 6 | 0.1 | 30
10 | Consumer 8 | 2010-04-03 00:00:00 | printer | 60 | 7 | 0.1 | 42
11 | Consumer 9 | 2010-05-03 00:00:00 | calculator | 5 | 100 | 0.1 | 50
 | Consumer 10 | 2010-06-03 00:00:00 | computer | 300 | 5 | 0.1 | 150
 | Consumer 11 | 2010-07-03 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 12 | 2010-08-03 00:00:00 | printer | 60 | 7 | 0.1 | 42
 |  |  | Totals: | 2070 | 490 |  | 1310
Spreadsheet: 181962d1348220675-if-data-is-changed-in-cells-a-o-i-want-in-column-p-date-on-which-last-change-was-done-rowaudit
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | Last Updated
 |  |  |  |  |  |  | d |  |  |  | d |  |  |  | 2012-09-21 17:42:10
 |  |  |  |  |  |  |  |  | f |  |  |  |  |  | 2012-09-21 17:42:13
 |  |  |  |  |  |  |  | f |  |  |  |  |  |  | 2012-09-21 17:42:08
 |  |  |  |  |  |  |  |  |  | f |  |  |  |  | 2012-09-21 17:42:12
 |  |  |  |  |  | d |  |  |  |  |  |  |  |  | 2012-09-21 17:42:11
 |  |  |  |  |  |  |  |  |  |  | d |  |  |  | 2012-09-21 17:42:09
Spreadsheet: 10e4b8be-a7b1-4a3f-8442-d290b7f41ecd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | ePFS | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Please change password on initial login - See Instructions tab below
 | The Hometown Bank ePFS has been designed for the convenience for those bank customers that want to automate the computation of their Personal Financial Statements.
 | Please fill in the following personal information, it will feed throughout the subsequent statements.
 | Note that all information located within this workbook will be held in the strictest of confidence and will not be shared with any parties outside of Hometown Bank.
 | Applicant
 | Address
 | City, State, Zip Code
 | Home/Preferred Phone
 | Business Phone
 | *Social Security Number
 | Spouse
 | *Social Security Number
 | Business Name of Applicant/Borrower
 | *The social security number is used to check credit bureaus only
Spreadsheet: 478821d1473085820-excel-formula-to-convert-data-range-to-columns-excel-formula-to-convert-data-range-to-columns-1-
Sheet: Sheet1

 |  |  |  |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre#
 |  |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4
 |  |  |  |  |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus
 | Table of Contents
Employee | Work Centre# | Bonus
[NAME] | 1 | 253
[NAME] | 2 | 255
[NAME] | 4 | 277
[NAME] | 4 | 244
Duanne Busch | 6 | 256 |  |  |  |  | need Excel formula/s to create output in coloumns as above please
[NAME] | 6 | 277
Ingrid Jones | 5 | 288 |  |  |  |  | [NAME] does not work as the dominant factor is the work centre # followed by employee name with bonus in decending order.
[NAME] | 5 | 211
[NAME] | 7 | 166 |  |  |  |  | any help is welcome, thank you!
[NAME] | 3 | 287
[NAME] | 3 | 287 |  |  |  |  |  |  | Is this at all possible? |  |  | Work Centre#
[NAME] | 4 | 259 |  |  |  |  |  |  |  |  |  | 3
[NAME] | 1 | 258
[NAME] | 6 |  |  |  |  |  |  |  |  |  |  | Employee | Bonus
[NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 287
Ingrid Jones | 7 | 299 |  |  |  |  |  |  |  |  |  | [NAME] | 287
[NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 287
[NAME] | 2 | 122
[NAME] | 3 | 287
Spreadsheet: 732376d1620918752-index-and-match-function-no-searching-full-string-formula-issue
Sheet: Sheet1

Policy [NAME] | Amt | Policy Type Search |  | Policy Types | SUM based on Policy Type
XXXXXST25-87512 | 2000 |  |  | ST
XXXXXST25-87512 | -1000 |  |  | STMD
XXXXSTMD25-87512 | 5000
XXXXSTMD25-87512 | -3000
Spreadsheet: 124841d1318645148-excel-2007-vlookup-n-a-error-master
Sheet: Sheet1

http://google.com | Sep 7 2011 3:56PM | File1.mp3
http://google.com | Sep 7 2011 3:14PM | [NAME]
http://google.com | Sep 7 2011 3:14PM | File2.mp4
http://google.com | Sep 7 2011 3:14PM | File2.mp5
http://google.com | Sep 7 2011 3:14PM | File2.mp6
http://google.com | Sep 7 2011 3:14PM | File2.mp7
http://google.com | Sep 7 2011 3:14PM | File2.mp8
http://google.com | Sep 7 2011 3:14PM | File2.mp9
Spreadsheet: 809483d1671113006-ranking-formular-rank-ans
Sheet: Sheet1

 | NO | POSITION
 | 2 | 6
 | X | X
 | X | X | [NAME]
 | 4 | 4.5
 | 4 | 4.5
 | 6 | 2.5
 | 6 | 2.5
 | 8 | 1
Spreadsheet: 820987d1678374720-four-cascading-data-validation-lists-that-can-be-used-on-multiple-rows-cascadedatavalexample-data-validation-formulas
Sheet: Sheet1

Options |  |  |  |  |  |  |  | Lists
Name1 | [NAME] | Name3 | Location1 | misc1 | misc2 | misc3 |  | Name1 | [NAME] | Name3 | Location1
[NAME] | [NAME] | [NAME] | Amber Place |  |  |  |  | [NAME] | [NAME] | [NAME] | Amber Place
[NAME] | [NAME] | [NAME] | St. Vale |  |  |  |  | [NAME] | [NAME] | [NAME] | St. Vale
[NAME] | [NAME] | [NAME] | The Prime |  |  |  |  | [NAME] | [NAME] | [NAME] | The Prime
[NAME] | [NAME] | [NAME] | The Place |  |  |  |  | [NAME] | [NAME] | Osric Doe | The Guy
*Each color is a separate data validation row based on Sheet 2 data |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | The Hospital
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | The Pizza Place
DESIRED RESULT |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | The Place
Name1 | [NAME] | Name3 | Location1 | misc1 | misc2 | misc3 |  | [NAME] | [NAME] | Brand [NAME] | The Thing
[NAME] | [NAME] | [NAME] | Amber Place
[NAME] | [NAME] | [NAME] | St. Vale
[NAME] | [NAME] | [NAME] | The Prime
[NAME] | [NAME] | [NAME] | The Place
Data Validation in cell A11: =Name1 (named range I3:I10)
Data Validation in cell B11: =OFFSET(J2,MATCH(A11,I3:I10,0),0,COUNTIF(I3:I10,A11),1)
Data Validation in cell C11: =OFFSET(K2,MATCH(B11,J3:J10,0),0,COUNTIF(J3:J10,B11),1)
Data Validation in cell D11: =OFFSET(L2,MATCH(C11,K3:[NAME]:[NAME])
Spreadsheet: 9cc32a12-9057-45a4-b355-a555737be195
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
SAA | Test | SAA | Sperm Antibody, Indirect, Serum | [NAME], Serum | Immunobead Technique | Varies: Var |  |  | 2 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 2 mL Collection Instructions: Draw blood from the individual suspected of having sperm antibodies. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | <50% binding | Wednesday; 8:30 a.m. Send specimen Monday through Friday | 7 days | 8 days | 1 | 89325 |  |  |  |  | Rochester
SAA | [NAME] | SERUM | Serum |  |  |  | Frozen
SAA | Result | SA_A | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31631-5 | [NAME]:ACnc:Pt:Ser:Ord:
SAA | Result | STDYT | Study Type | Study Type | Alphanumeric
SAA | Result | H_IGA | Head, IgA | Head, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38674-8 | [NAME].IgA/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | H_IGG | Head, IgG | Head, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38678-9 | [NAME].IgG/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | M_IGA | Midpiece, IgA | Midpiece, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38675-5 | Spermatozoa.midpiece [NAME].IgA/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | M_IGG | Midpiece, IgG | Midpiece, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38679-7 | Spermatozoa.midpiece [NAME].IgG/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | TIGA | Tail, IgA | Tail, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38677-1 | [NAME].IgA/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | TIGG | Tail, IgG | Tail, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38681-3 | [NAME].IgG/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | TTIGA | Tail Tip, IgA | Tail Tip, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38676-3 | Spermatozoa.tail tip [NAME].IgA/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | TTIGG | Tail Tip, IgG | Tail Tip, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38680-5 | Spermatozoa.tail tip Ab.IgG/100 spermatozoa:NFr:Pt:[NAME]:Qn:Immunobead
SAA | Result | [NAME] | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -802 | -906
2 |  |  |  |  |  |  |  |  |  |  | -799 | -906
3 |  |  |  |  |  |  |  |  |  |  | -812 | -906
4 |  |  |  |  |  |  |  |  |  |  | -801 | -906
5 |  |  |  |  |  |  |  |  |  |  | -684 | -906
6 |  |  |  |  |  |  |  |  |  |  | -666 | -906
7 |  |  |  |  |  |  |  |  |  |  | -720 | -906
8 |  |  |  |  |  |  |  |  |  |  | -747 | -906
9 |  |  |  |  |  |  |  |  |  |  | -776 | -906
10 |  |  |  |  |  |  |  |  |  |  | -703 | -414
11 |  |  |  |  |  |  |  |  |  |  | -733 | -709
12 |  |  |  |  |  |  |  |  |  |  | -1042 | -906
13 |  |  |  |  |  |  |  |  |  |  | -1392 | -906
14 |  |  |  |  |  |  |  |  |  |  | -1580 | -906
15 |  |  |  |  |  |  |  |  |  |  | -1152 | -906
16 |  |  |  |  |  |  |  |  |  |  | -951 | -906
17 |  |  |  |  |  |  |  |  |  |  | -657 | -906
18 |  |  |  |  |  |  |  |  |  |  | -793 | -906
19 |  |  |  |  |  |  |  |  |  |  | -717 | -906
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 19523.17
2002-03-19 00:00:00
CBS Volume
 |  |  | 5871
Spreadsheet: 879212d1726665677-formula-for-automatically-populating-a-row-of-information-from-entering-a-key-word-example-contact-sheet
Sheet: Full Contact List

Project
Project Directory
General Notes:
1. New changes since last revision shown in blue bold
2. Any omitted items are shown in red strikethrough and will be omitted on the next issue
Rev | Date | Description
- |  | First Issue
A
B
C
Discipline | Company Name | Name | Role | [NAME] | Phone Numbers
Client Project Team | Company | Name 1 | Managing Director | email 1 | Direct: +44 2074 000000 Mobile: +44 7831 000 000
 |  | Name 2 | Development Director | email 2 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 3 | Group Development Director | email 3 | Direct: +44 2074 000000 Mobile: +44 7831 000 002
 |  | Name 4 | Technical Director | email 4 | Direct: +44 2074 000000 Mobile: +44 7831 000 003
 |  | Name 5 | Director | email 5 | Direct: +44 2074 000000 Mobile: +44 7831 000 004
 |  | Name 6 | Analyst | email 6 | Direct: +44 2074 000000 Mobile: +44 7831 000 005
 |  | Name 7 | Financial Controller | email 7 | Direct: +44 2074 000000 Mobile: +44 7831 000 006
 |  | Name 8 | Financial Controller | email 8 | Direct: +44 2074 000000 Mobile: +44 7831 000 007
 |  | Name 9 | Senior Team Administrator | email 9 | Direct: +44 2074 000000 Mobile: +44 7831 000 008
 |  | Name 10 | PA | email 10 | Direct: +44 2074 000000 Mobile: +44 7831 000 009
Client Project Team | Company | Name 11 | Chairman & Chief Executive | email 11 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 12 | Development Director | email 12 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 13 | Legal Director | email 13 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 14 | Head of Strategic Partnerships | email 14 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 15 | Investment Director | email 15 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 16 | Investment & Development Director | email 16 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 17 | Inestment Analyst | email 17 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 18 | Utilities Manager | email 18 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 19 | Director of Land | email 19 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 20 | Managing Director, [NAME] | email 20 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 21 | Architectural & Technical Director | email 21 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 22 | Head of Sustainability & Urban Development | email 22 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
 |  | Name 23 | Property Development Finance | email 23 | Direct: +44 2074 000000 Mobile: +44 7831 000 001
Spreadsheet: 1b37d5e3-94b4-46ee-9346-fdb9453845e2
Sheet: Sheet1

Math 219A | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Date | Score | Date | Score | Date | Score | Date | Score
Quiz 1 | Ch. 1
Quiz 2 | 2.1-2.3
Quiz 3 | 2.4-2.6
Test 1-2 | Ch. 1-2
Quiz 4 | 3.1-3.4
Quiz 5 | 3.5-3.8
Test 3 | Ch. 3
Mod 1 | Ch. 1-3
Math 219B
 |  | Date | Score | Date | Score | Date | Score | Date | Score
Quiz 6 | 4.1-4.2
Quiz 7 | 4.3 and 4.5
Test 4 | Ch. 4, A&B
Quiz 8 | 5.1-5.3
Quiz 9 | 5.4-5.8
Test 5 | Ch. 5
[NAME] | Ch. 1-5
Math 219C
 |  | Date | Score | Date | Score | Date | Score | Date | Score
Quiz 10 | 6.1-6.3
Quiz 11 | 6.4-6.7
Test 6 | Ch. 6, App. C & SS 1
Quiz 12 | 7.1-7.3
Quiz 13 | 7.4-7.7
Test 7 | Ch. 7
[NAME] | Ch. 1-7
Spreadsheet: 819579d1677586555-countif-with-let-function-error-st
Sheet: Sheet1

 |  | Countif=0
 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | #[NAME]! |  | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0
 |  | #[NAME]! |  | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1