tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 692382d1598299311-how-to-search-name-and-return-the-numeric-value-when-in-colunm-for-desired-task-example
Sheet: Sheet1

 | Task | Friday  28/08 | Saturday  29/08 | Sunday  30/08 | Monday  31/08 | Tuesday  01/09 | Wednesday  02/09 | Thursday  03/09
 | Meetings | [NAME] | Kate & Mary | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Data Admin | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Training | [NAME] | [NAME] | [NAME] | [NAME] & John | [NAME] | [NAME] | [NAME]
 | Resourcing | Kate & Bob | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Task | TIME UNIT
 | Meetings | 2
 | Data Admin | 0.5
 | Training | 4
 | Resourcing | 1
 | Employee | Friday  28/08 | Saturday  29/08 | Sunday  30/08 | Monday  31/08 | Tuesday  01/09 | Wednesday  02/09 | Thursday  03/09
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 860174d1708372470-need-help-with-rag-status-for-multiple-projects-project-kpi-status-tms
Sheet: Overall Project Status

Overall Project Status
Project Name | 2023-12-01 00:00:00 | 2024-01-24 00:00:00 | 2024-02-24 00:00:00 | 2024-03-24 00:00:00 | 2024-04-24 00:00:00 | 2024-05-24 00:00:00 | 2024-06-24 00:00:00 | 2024-07-24 00:00:00 | 2024-08-24 00:00:00 | 2024-09-24 00:00:00 | 2024-10-24 00:00:00 | 2024-11-24 00:00:00 | 2024-12-24 00:00:00
Project-1
Project-2
Project-3
Project-4
Project-5
Project-6
Overall Status Key:
Below rules apply to the Overall Project Status (see table above), [NAME] sheet 'Project KPIs' for individual project KPIs
RED | If any KPI is red, overall project is Red
AMBER | If any KPI is amber, overall project is amber
GREEN | If all KPIs are green, overall project status is Green
Spreadsheet: 217777d1362176235-complex-vlook-and-or-index-formula-question-expert-advice-needed-excel-forum-sample-1v3
Sheet: Budget

 | [PHONE]
 |  |  |  |  | 41274 | 41305 | 41333 | 41364
 | HOURS
 | JOB NO | EMPLOYEE ID | EMPLOYEE NAME | LCAT | 2012-12-31 00:00:00 | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-03-31 00:00:00 | GRAND TOTAL
 |  | 23043 |  | [NAME] Analyst (Master) CY4
 |  | 23043 |  | [NAME] Analyst (Master) CY4
 | COST
 | JOB NO | EMPLOYEE ID | EMPLOYEE NAME | LCAT | 2012-12-31 00:00:00 | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-03-31 00:00:00 | GRAND TOTAL
 |  | 23043 |  | [NAME] Analyst (Master) CY4
 |  | 23043 |  | [NAME] Analyst (Master) CY4
 | REVENUE
 | JOB NO | EMPLOYEE ID | EMPLOYEE NAME | LCAT | 2012-12-31 00:00:00 | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-03-31 00:00:00 | GRAND TOTAL
 |  | 23043 |  | [NAME] Analyst (Master) CY4
 |  | 23043 |  | [NAME] Analyst (Master) CY4
Spreadsheet: 715776d1611858736-averageifs-gives-me-two-different-results-in-two-tables-that-have-same-values-average-issue
Sheet: List of countries

Country Event Occurred | Cluster
Austria | GSA
Belgium | BENELUX
Bulgaria | CEE
Czech Republic | CEE
Croatia
Cyprus
Denmark | NORDIC
Estonia | NORDIC
Finland | NORDIC
France | FRANCE
Germany | GSA
Greece
Hungary | CEE
Iceland | NORDIC
Ireland | UK-IR
Italy | ITALY
Latvia | NORDIC
[NAME]
Lithuania | NORDIC
Luxembourg | BENELUX
Malta
Netherlands | BENELUX
Norway | NORDIC
Poland | CEE
Portugal | IBERIA
Romania | CEE
Slovakia | CEE
Slovenia | CEE
Spain | IBERIA
Turkey
Sweden | NORDIC
Switzerland | GSA
United Kingdom | UK-IR
Spreadsheet: 871327d1717702650-spillable-multiplication-formula-use-spill-operator-book2
Sheet: Travel

Type of Travel/Meeting Expense NOT related to a training/conference | Registration* | Lodging* | Meals* | Mileage and Incidentals (parking, tolls, etc.) | Number of Employees Attending | Subtotal | Subtotal | Subtotal (Non Spill) | Just the Sum | Just the Sum (Non Spill) | % Allocated to Project | Travel Expenses
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 0.1 |  | 1
 | 57 | 14 | 2 | 2.56 | 7.89 | 28108.5984 | 78.89999999999999 |  | 3562.56 |  | 0.05 | 1405.42992 | 1
 | 81 | 51 | 13 | 28 | 6 | 21375.36 | 60 |  | 3562.56 |  | 0.81 | 17314.0416 | 1
 | 19 | 90 | 67 | 86 | 5 | 17812.8 | 50 |  | 3562.56 |  | 0.19 | 3384.432 | 1
 | 17 | 3 | 47 | 1 | 6 | 21375.36 | 60 |  | 3562.56 |  | 0.17 | 3633.811200000001 | 1
 | 89 | 72 | 21 | 88 | 4 | 14250.24 | 40 |  | 3562.56 |  | 0.89 | 12682.7136 | 1
 | 78 | 30 | 73 | 61 | 2 | 7125.12 | 20 |  | 3562.56 |  | 0.78 | 5557.5936 | 1
 | 40 | 34 | 12 | 52 | 15 | 53438.4 | 150 |  | 3562.56 |  | 0.4 | 21375.36 | 1
 | 24 | 27 | 41 | 49 | 14 | 49875.84 | 140 |  | 3562.56 |  | 0.24 | 11970.2016 | 1
 | 63 | 58 | 2 | 77 | 5 | 17812.8 | 50 |  | 3562.56 |  | 0.63 | 11222.064 | 1
 | 71 | 43 | 11 | 60 | 3 | 10687.68 | 30 |  | 3562.56 |  | 0.71 | 7588.2528 | 1
 | 25 | 75 | 76 | 64 | 4 | 14250.24 | 40 |  | 3562.56 |  | 0.25 | 3562.56 | 1
 | 35 | 18 | 32 | 16 | 3 | 10687.68 | 30 |  | 3562.56 |  | 0.35 | 3740.688 | 1
 | 44 | 10 | 87 | 83 | 2 | 7125.12 | 20 |  | 3562.56 |  | 0.1 | 712.5120000000001 | 1
 | 82 | 56 | 59 | 50 | 7 | 24937.92 | 70 |  | 3562.56 |  | 0.05 | 1246.896 | 1
 | 53 | 31 | 79 | 37 | 12 | 42750.72 | 120 |  | 3562.56 |  | 0.81 | 34628.0832 | 1
 | 62 | 20 | 80 | 65 | 9 | 32063.04 | 90 |  | 3562.56 |  | 0.19 | 6091.9776 | 1
 | 84 | 74 | 42 | 45 | 9 | 32063.04 | 90 |  | 3562.56 |  | 0.17 | 5450.7168 | 1
 | 54 | 36 | 8 | 66 | 18 | 64126.08 | 180 |  | 3562.56 |  | 0.89 | 57072.21120000001 | 1
 | 57 | 38 | 26 | 29 | 7 | 24937.92 | 70 |  | 3562.56 |  | 0.78 | 19451.5776 | 1
 |  |  |  |  |  |  |  |  |  |  | Total Direct Personnel Travel |  | 1
*estimated total cost for Title IV-E related activities (if applicable)
Note:  Please refer to Title IV-E Training Handbook for detailed information regarding allowable expenses, documentation requirements, etc.
Title IV-E Training Contracts Financial Handbook
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.3

Table 1.3: Population etimates by age groups, nationality, residence and sex in Iraq,  2012
 | Nationals |  | Non- Nationals |  | Urban |  | Rural |  | Total
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | ... | ... | ... | ... | 1602176 | 1565093 | 869677 | 800602 | 2471853 | 2365695 | 4837548
5-9 | ... | ... | ... | ... | 1546833 | 1415420 | 841105 | 776623 | 2387938 | 2192043 | 4579981
10-14 | ... | ... | ... | ... | 1434366 | 1332252 | 760796 | 692689 | 2195162 | 2024941 | 4220103
15-19 | ... | ... | ... | ... | 1304921 | 1226817 | 605093 | 574149 | 1910014 | 1800966 | 3710980
20-24 | ... | ... | ... | ... | 1187288 | 1127914 | 476045 | 424011 | 1663333 | 1551925 | 3215258
25-29 | ... | ... | ... | ... | 1005604 | 911359 | 383495 | 370946 | 1389099 | 1282305 | 2671404
30-34 | ... | ... | ... | ... | 819626 | 790662 | 316874 | 338541 | 1136500 | 1129203 | 2265703
35-39 | ... | ... | ... | ... | 698972 | 724031 | 287577 | 302833 | 986549 | 1026864 | 2013413
40-44 | ... | ... | ... | ... | 653404 | 650717 | 264315 | 233941 | 917719 | 884658 | 1802377
45-49 | ... | ... | ... | ... | 533721 | 541545 | 177800 | 197196 | 711521 | 738741 | 1450262
50-54 | ... | ... | ... | ... | 379555 | 409923 | 91296 | 112563 | 470851 | 522486 | 993337
55-59 | ... | ... | ... | ... | 278046 | 294533 | 92272 | 109039 | 370318 | 403572 | 773890
60-64 | ... | ... | ... | ... | 243230 | 269470 | 81723 | 88871 | 324953 | 358341 | 683294
65-69 | ... | ... | ... | ... | 139296 | 149830 | 41631 | 55851 | 180927 | 205681 | 386608
70-74 | ... | ... | ... | ... | 106720 | 101324 | 26613 | 35263 | 133333 | 136587 | 269920
75-79 | ... | ... | ... | ... | 56585 | 63605 | 19011 | 22765 | 75596 | 86370 | 161966
80+ | ... | ... | ... | ... | 67977 | 46202 | 26081 | 30944 | 94058 | 77146 | 171204
Not stated | … | … | … | … | … | … | … | … | … | … | …
Total | ... | ... | ... | ...
Spreadsheet: 682437d1592098154-sumif-depending-on-a-data-validation-amendedinventory
Sheet: Sheet1

NIKE ELEMENT 55 SILVER | 4400
NIKE ELEMENT 55 WHITE GRID | 4100
NIKE VAPORMAX BLACK GOLD | 5500
NIKE CLASSIC CORTEZ LEATHER | 4100
NIKE AIR MAX WOMENS | 4600
ADIDAS NITE JOGGER [NAME] | 4400
ADIDAS NITE JOGGER CYAN | 4400
NIKE PRESTO REACT | 4800
NIKE ELEMENT 55 PSYCHIC BLUE | 4400
Grand Court Shoes - Black | 3800
Adidas Tubular Radial Chinese New Year | 3900
Adidas Originals ZX 8000 Boost Floral | 4600
EQT Support 91/18 Shoes | 5800
EQT Racing ADV Shoes | 3800
adidas EQT Support 93/17 | 3800
Adidas Pure Boost Men Red Athletic Running Shoes | 5200
EQT Support 93/17 White Blue | 3800
Adidas Running Ultraboost Parley of the Ocean | 4800
Adidas Forest [NAME] Shoes Core Black | 3700
Adidas Originals Youth N--5923 Running Shoes | 3800
Adidas Superstar Women Pink/White | 2900
Spreadsheet: 851017d1701282169-staff-scheduling-calculator-holidays-year-over-year-year-over-year-schedule
Sheet: STAT Holidays

 | 2019 | 2020 | 2021 | 2022 | 2023
New Years Day | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00
Family Day February | 2019-02-18 00:00:00 | 2020-02-17 00:00:00 | 2021-02-15 00:00:00 | 2022-02-21 00:00:00 | 2023-02-20 00:00:00
Good Friday April | 2019-04-19 00:00:00 | 2020-04-10 00:00:00 | 2021-04-02 00:00:00 | 2022-04-15 00:00:00 | 2023-04-07 00:00:00
Easter Monday April | 2019-04-22 00:00:00 | 2020-04-13 00:00:00 | 2021-04-05 00:00:00 | 2022-04-18 00:00:00 | 2023-04-10 00:00:00
[NAME]May | 2019-05-20 00:00:00 | 2020-05-18 00:00:00 | 2021-05-24 00:00:00 | 2022-05-23 00:00:00 | 2023-05-22 00:00:00
Canada Day July 1 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | 2023-07-01 00:00:00
Heritage Day August | 2019-08-05 00:00:00 | 2020-08-03 00:00:00 | 2021-08-02 00:00:00 | 2022-08-01 00:00:00 | 2023-08-07 00:00:00
Labour Day September | 2019-09-02 00:00:00 | 2020-09-07 00:00:00 | 2021-09-06 00:00:00 | 2022-09-05 00:00:00 | 2023-09-04 00:00:00
Thanksgiving October | 2019-10-14 00:00:00 | 2020-10-12 00:00:00 | 2021-10-11 00:00:00 | 2022-10-10 00:00:00 | 2023-10-09 00:00:00
Remembrance Day November 11 | 2019-11-11 00:00:00 | 2020-11-11 00:00:00 | 2021-11-11 00:00:00 | 2022-11-11 00:00:00 | 2023-11-11 00:00:00
Christmas Day December 25 | 2019-12-25 00:00:00 | 2020-12-25 00:00:00 | 2021-12-25 00:00:00 | 2022-12-25 00:00:00 | 2023-12-25 00:00:00
Boxing Day December 26 | 2019-12-26 00:00:00 | 2020-12-26 00:00:00 | 2021-12-26 00:00:00 | 2022-12-26 00:00:00 | 2023-12-26 00:00:00
Spreadsheet: 43bcc5cd-6175-4fa0-9708-ee5e5b0214be
Sheet: Sheet1

Table ST12 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
SAGE tag | Gene | Probe accession number | Mm Accession | Hs Accesssion | Blast N | Blast X | ncRNA?
TACCTTTGTC | 135991 ESTs | BE633326 | AK013883 | [NAME] | 2.00E-40 | NS | likely
GATTATTCAA | 258150 ESTs | AI425618 | AK011787 | XM_299912 | 7.00E-09 | NS | likely
TTGCTGGTTT | 38582 ESTs | AA860047 | AK012876 | AK094378 | 7.00E-57 | NS | likely
GGCAGACTGT | 194050 ESTs/no obvious ORF | BF449937 | AK044422 | XM_088347 | 1.00E-53 | 1.00E-04 | likely
CTTGTAGCTG | 44854 ESTs/no obvious ORF | AW050310 | AK028326 | ND | 7.00E-55 | NS | likely
GGGAAGATTT | 150838 ESTs/15kb 5' of Six3 | AW209946 | AK044330 | ND | e-125 | NS | likely
CAAACAGTGA | 37607 BC003498 cDNA sequence BC00398 | AI846073 | NM_030263 | NM_018422 | 8.00E-79 | NS | likely
CAGGCAAAAT | 151012 ESTs | AW125320 | ND | ND | NS | NS | possible
CTCCTGCCAT | 182462 ESTs (inside RGS9) | AW533667 | ND | ND | NS | NS | possible
TACAAACACA | 44702 EST/contained inside rdgB2 | AW050046 | ND | ND | NS | NS | possible
ACAACTCTGA | 131260 ESTs | AI642627 | ND | ND | NS | NS | possible
TGGTTACTGG | 151553 ESTs | BE984878 | AK080586 | ND | NS | NS | possible
CAGGGCAGGA | 269342 ESTs | AW490107 | ND | ND | NS | NS | possible
CATCTAGAGG | 188410 ESTs | BE994660 | ND | ND | NS | NS | possible
CCCTGAATAA | 130902 ESTs | AA616812 | AK037284 | ND | NS | NS | possible
AAATGTAAAT | 32434 ESTs/no predicted gene | AA189760 | ND | ND | NS | NS | possible
TTTAGACCAG | 150542 ESTs | BE949265 | BI732599 | ND | NS | NS | possible
GCCCCCAATG | 196727 ESTs | AI841594 | AK004167 | ND | 0.000006 (contains repeat) | NS | possible
AGGAGCAAGC | 150554 EST | BE949356 | ND | ND | NS | NS | possible
Spreadsheet: 87011d1286943684-consolidate-function-minimaidspivottable
Sheet: Try this

Date | Name | Activity | Time
2010-10-11 00:00:00 | [NAME] | Bathroom | 2.5
2010-10-12 00:00:00 | [NAME] | Vacuum | 2
2010-10-13 00:00:00 | [NAME] | Vacuum | 3
2010-10-12 00:00:00 | [NAME] | Vacuum | 4 |  |  | Sum of Time | Column Labels
2010-10-12 00:00:00 | [NAME] | Dusting | 2 |  |  | Row Labels | [NAME] | Jasmine | [NAME] | Grand Total
2010-10-13 00:00:00 | [NAME] | Window | 1 |  |  | 2010-10-10 00:00:00 |  | 2 |  | 2
2010-10-10 00:00:00 | Jasmine | Vacuum | 2 |  |  | Vacuum |  | 2 |  | 2
2010-10-12 00:00:00 | Jasmine | Laundry | 3.5 |  |  | 2010-10-11 00:00:00 | 2.5 |  |  | 2.5
2010-10-13 00:00:00 | Jasmine | Dusting | 1.5 |  |  | Bathroom | 2.5 |  |  | 2.5
 |  |  |  |  |  | 2010-10-12 00:00:00 | 2 | 3.5 | 6 | 11.5
 |  |  |  |  |  | Dusting |  |  | 2 | 2
 |  |  |  |  |  | Laundry |  | 3.5 |  | 3.5
 |  |  |  |  |  | Vacuum | 2 |  | 4 | 6
 |  |  |  |  |  | 2010-10-13 00:00:00 | 3 | 1.5 | 1 | 5.5
 |  |  |  |  |  | Dusting |  | 1.5 |  | 1.5
 |  |  |  |  |  | Vacuum | 3 |  |  | 3
 |  |  |  |  |  | Window |  |  | 1 | 1
 |  |  |  |  |  | Grand Total | 7.5 | 7 | 7 | 21.5
Spreadsheet: 748035d1631847926-dynamic-list-from-matrix-matrix-table-to-list-v2-with-helper-
Sheet: 1

Monday | Tuesday | Wednesday | Thursday | Friday |  |  |  | 5 | 4 | 4 | 3
Store 1 | Store 6 | Store 101 | Store 19 | Store 62
Store 7 | Store 12 | Store 3 | Store 31 | Store 63
Store 9 | Store 15 | Store 54 | Store 33 | Store 71
Store 20 | Store 2 | Store 22 | Store 61
 | Store 8
Count | Store List | Column Indx | Store List
1 | Store 1
2 | Store 7
3 | Store 9 |  |  |  |  |  |  |  |  |  | <<<< Looking for the Store List to auto-populate based on whats in the table above.
4 | Store 20
5 | Store 6
6 | Store 12
7 | Store 15
8 | Store 2
9 | Store 8
10 | Store 101
11 | Store 3
12 | Store 54
13 | Store 22
14 | Store 19
15 | Store 31
16 | Store 33
17 | Store 61
18 | Store 62
19 | Store 63
20 | Store 71
Spreadsheet: 855997d1705415318-automatically-distributing-quiz-scores-automatically-distributing-quiz-scores
Sheet: Sayfa1

 |  | 10 | 10 | 25 | 20 | 20 | 15
no | adı soyadı | 1. Soru(10 puan) | 2. Soru(10 puan) | 3. [NAME]) | 4. [NAME]) | 5. [NAME]) | 6. [NAME]) | Aldığı Not
1 | [NAME] |  |  |  |  |  |  | 60
2 | test2 |  |  |  |  |  |  | 70
3 | test3 |  |  |  |  |  |  | 60
Spreadsheet: 269891d1381318570-subtracting-duplicated-text-between-cells-of-two-columns-sp86
Sheet: Sheet1

 | GEN, SEC, SLY | GEN, OFF, SEC, SLY |  | OFF | #N/A | OFF
 | GEN,SLY,SPX | GEN,SLY |  | #N/A | SPX | SPX
 | GEN,SPX,ZXO | GEN,ZXO |  | #N/A | SPX | SPX
 | EAT,NEG,PEP,PER,PPL,SLY | EAT,NEG,OFF,PEP,PER,PPL,SLY |  | OFF | #N/A | OFF
 | CSL,GEN,HEA,SLY,SPX | CSL,GEN,HEA,SLY |  | #N/A | SPX | SPX
 | AVI,WET | AVI,SPX,WET |  | SPX | #N/A | SPX
 | CSL,GEN,SLY | CSL,GEN,SLY,SPX |  | SPX | #N/A | SPX
 | GEN,ZXO | GEN,SPX,ZXO |  | SPX | #N/A | SPX
 | GEN,HEA,SLY | GEN,HEA,IAA,SLY |  | IAA | #N/A | IAA
 | GEN,HEA,IAA,SLY,SPX | GEN,HEA,IAA,SLY |  | #N/A | SPX | SPX
 | GEN,ZXF | GEN,SPX,ZXF |  | SPX | #N/A | SPX
 | GEN,HEA,NEG,SLY,SPX | GEN,HEA,NEG,SLY |  | #N/A | SPX | SPX
 | CSL,GEN,HEA,IAA,MDL,ZXF,ZXL | CSL,GEN,HEA,IAA,MDL,SPX,ZXF,ZXL |  | SPX | #N/A | SPX
 | EAT,HEA,MDL,NEG,PEP,PER,PPL,SPX,ULD | EAT,HEA,MDL,NEG,PEP,PER,PPL,SLY,ULD |  | SLY | SPX | SLY
 | Old | New | Difference | Extra word in column C | Extra word in column B | Result
Spreadsheet: 019ecda6-69fc-417a-809d-b6e74e2243ec
Sheet: Sheet1

Pre-requisites | CERTIFICATE | COURSE TITLE | NO | SECT | CREDS | PROFESSOR | DAY/TIME | ROOM | EXAM DATE | EXAM TIME
 |  | BUSINESS ORGANIZATIONS | 631 | 1 | 3 | HUSSEY | MTH 6:00 - 7:50 PM / T 8:00 - 9:50 PM | L202 | 2013-07-18 00:00:00 | 6:00 - 9:00 PM
 |  | CONFLICTS | 700 | 1 | 3 | SEALING | MTH 8:00 - 9:50 PM / T 6:00 - 7:50 PM | L202 | 2013-07-22 00:00:00 | 6:00 - 9:00 PM
[NAME] |  | FIRST AMENDMENT | 810 | 1 | 3 | DIMINO | MTH 6:00 - 7:50 PM / T 8:00 - 9:50 PM | L203 | TAKE-HOME EXAM
 |  | PROFESSIONAL RESPONSIBILITY | 702 | 1 | 3 | ROBINETTE | MTH 8:00 - 9:50 PM / T 6:00 - 7:50 PM | L203 | 2013-07-22 00:00:00 | 6:00 - 9:00 PM
 |  | SEMINAR: CAPITAL PUNISHMENT@ | 843 | 1 | 2 | RAEKER-JORDAN, S. | M 8:00 - 9:50 PM / T 6:00 - 7:50 PM | L201 | NO EXAM
NON -CLASSROOM CREDITS
Coreq: Prof. [NAME]. Prereq:  Evidence |  | [NAME] | 803 | 1 | 2-4 | DURKIN | M 5:00 - 5:55PM | L205 | NO EXAM
Coreq: Prof. [NAME]. Prereq:  Evidence |  | JUDICIAL EXTERNSHIP | 809 | 1 | 2-4 | DURKIN | M 5:00 - 5:55PM | L205 | NO EXAM
Evidence | Trial Ad Cert | I.T.A.P.# | 779 | 1 | 3 | LOCKARD | MAY 17 - MAY 24 |  | NO EXAM
Pro. Resp. and Evidence |  | PA CIVIL CLINIC# | 925 | 1 | 4 | LOCKARD |  |  | NO EXAM
 |  | Textbook information (e.g., price, title, ISBN number, etc.) is available at www.widenerlawbookstore.com
 |  | # [NAME] SATISFY THE SKILLS REQUIREMENT             @ WILL SATISFY THE WRITING REQUIREMENT (Final grade will be based on either an exam or a research paper)
Spreadsheet: 57c14e08-7009-4335-817f-7b572625e0ac
Sheet: FY 2007-2008 Summary

USRC AWARDS SUMMARY FY 2007-2008
Month | Year | Proposals | Awards | % Funding | Amount Requested | Amount Awarded
May | 2007 | 33 | 21 |  | 38154.76 | 22418
September | 2007 | 20 | 16 |  |  | 19310
October | 2007 | 19 | 16
November | 2007 | 19 | 14
December | 2007 | 14 | 11 |  | 16311.6 | 11597.1
February | 2008 | 25 | 21
March | 2008 | 22 | 16
April | 2008 | 19 | 17 |  | 21665.27 | 18717
SUMMARY
 | TOTAL AWARDS BY COLLEGE FOR FY 2007-2008
 | College/Academic Unit |  |  | # Proposals | # Awards | Amount Awarded
 | Business and Information Technology |  |  | 17 | 13 | 15000
 | Education and Educational Technology |  |  | 38 | 31 | 25353
 | Fine Arts |  |  | 13 | 12 | 15166
 | Health and Human Services |  |  | 26 | 21 | 21249
 | Humanities and Social Sciences |  |  | 39 | 28 | 26805
 | Natural Sciences and Mathematics |  |  | 37 | 26 | 28198
 | University Services |  |  | 1 | 1 | 859.1
 | Totals
 | TOTAL AWARDS BY CATEGORY FOR FY 2007-2008
 | # | Category Description |  | # Proposals | # Awards | Amount Awarded
 | 1 | Coop. Pgms with Industry/Community |  | 3 | 3 | 3630
 | 2 | Small Research Grants |  | 14 | 12 | 16814
 | 3 | Innovative Teaching Projects |  | 3 | 3 | 4500
 | 4 | To Present Papers at Int'l Meetings |  | 52 | 42 | 57780
 | 5 | Student/Faculty Research Awards |  | 16 | 13 | 15509.1
 | 6 | New Investigator Awards |  | 14 | 9 | 10925
 | 7 | Domestic Travel |  | 69 | 50 | 23472
 | Totals
Spreadsheet: 89766d1289504540-converting-time-to-hours-and-minutes-comp-form-fy-2011
Sheet: Apr

Comp Time Form
 | Name : |  |  | Month: | April 2011
 | Title:
 | Earned/Taken  E or T | Date Earned/Taken | Activity | Director [NAME] | Time Worked | Time Granted      (@ time & 1/2) | Time Used | Time Available
 | E |  | Forwarded from Previous Month
 |  |  |  | Sub Totals
Spreadsheet: 95973d1295468254-multiple-line-invoices-customers-orders-accounts-copy
Sheet: Invoices

Inv. No | Date | Cust. No | Company name | Product | Net | VAT | Gross | Payment | Pay date | Bank ref |  | Debt
110001 | 2011-01-19 00:00:00 | 11001 |  | 500 business cards | 20
110001 | 2011-01-19 00:00:00 | 11001 |  | 1000 letterheads | 55
Spreadsheet: 3e7c6c7b-9b29-4da2-a715-61e614612906
Sheet: Almanac

 |  |  |  |  | Health-Related Institutions |  |  |  |  | Return to Index
 |  |  |  |  | FY 2011 Summary of Research Expenditures Data to Almanac Publication
 |  |  |  |  | December 16, 2011
Note:  [NAME] and past Column E values to S&U Almanac Tab.  Do not send separately.
Almanac Order | FICE Code | Year | Institution | Total Research Expenditures As Deetermined by Research Survey
1 | 000089 | FY 11 | Texas A&M HSC
2 | 000412 |  | Texas Tech HSC
3 | 000130 |  | U. North Texas HSC
4 | 104952 |  | UT Galveston Medical Branch
5 | 000404 |  | UT Health Center Tyler
6 | 011618 |  | UT Houston Health Science Center
7 | 025554 |  | UT [NAME]
8 | 000040 |  | UT San Antonio HSC
9 | 000030 |  | UT Southwestern Med.
 |  |  | Total
 |  |  | 9 Ok
 |  |  | 12-16-2011 Totals | 1813143351
Spreadsheet: 72528d1273214544-conditional-drop-downs-test
Sheet: Sheet1

LIST 1 | LIST 2
A | A
A | B
A | C
A | D
B | A
B | B
B | C
B | D
C | A
C | B
C | C
C | D
D | A
D | B
D | C
Spreadsheet: 769574d1645605783-return-single-value-out-of-several-matching-values-get-uniques-ans
Sheet: Sheet1

name | rn | cl | m | A |  |  |  |  |  | name | rn | cl | m | A
a | 2 | c1 | j | 100
b | 3 | c2 | j | 200
c | 4 | c2 | m | 300
a | 2 | c1 | f | 400
b | 3 | c2 | m | 500
a | 2 | c1 | m | 600
Spreadsheet: 74980d1275507528-summing-accross-multiple-worksheets-ron
Sheet: Sheet1

 | 105 | 205 | 305 | 405 | 505
2010-01-01 00:00:00 | 54.2499445080793 | 86.65153797450371 | 25.88714760095314 | 58.80928896080804 | 87.1595840957327
2010-01-01 00:00:00 | 72.8486544943342 | 16.74490540214788 | 21.84050628300602 | 29.46753974201028 | 98.1782236879892
2010-02-01 00:00:00 | 72.80671862409491 | 15.40810419085261 | 44.12395836349987 | 62.52778793223408 | 6.537982470901227
2010-03-01 00:00:00 | 55.91630723613746 | 30.658546720949 | 18.72004644016518 | 70.70878886226595 | 52.14811631387262
2010-04-01 00:00:00 | 75.18606610592062 | 67.78301854296859 | 18.15781049460385 | 48.98956750445331 | 47.67516123598678
2010-04-01 00:00:00 | 6.473581664157213 | 18.20439271781531 | 41.7673426018448 | 39.47873278104082 | 52.32851502217504
2010-05-01 00:00:00 | 23.48792624644505 | 38.8911986262145 | 71.59440805267397 | 49.81418531099511 | 46.24663928294738
2010-06-01 00:00:00 | 96.0563663367925 | 9.377097826299874 | 13.6104520910613 | 89.38268631306269 | 48.49498058875774
2010-07-01 00:00:00 | 90.70649363901407 | 90.33706218977633 | 21.42046579332995 | 91.52725629339795 | 10.3167574612832
2010-08-01 00:00:00 | 49.60672875711305 | 42.00772726229884 | 79.02214303689257 | 97.59946532190074 | 45.48162638712591
2010-09-01 00:00:00 | 8.815823607263695 | 96.18544796363508 | 58.41715086016519 | 35.97129768233192 | 95.24723818173986
2010-10-01 00:00:00 | 1.336346936751481 | 44.25888286713784 | 87.62133816071386 | 50.29477637090353 | 66.13143864364481
2010-11-01 00:00:00 | 45.39596583629791 | 97.99161923571012 | 96.82521390903514 | 41.55850063406001 | 67.16742710339577
2010-12-01 00:00:00 | 54.91317828180833 | 72.43428244976275 | 98.22063912001342 | 46.0294976517968 | 76.82913829639651
Spreadsheet: 835026d1688232885-transposing-data-and-splitting-cells-sampleworkbook
Sheet: DesiredResult

Type | Score 1 | Score 2
AA | 0 | 1
AA | 1 | 1
AA | 2 | 1
AA | 3 | 1
AA | 4 | 1
AA | 5 | 1
AA | 6 | 1
AA | 7 | 1
AA | 8 | 2
AA | 9 | 2
AA | 10 | 2
AA | 11 | 3
AA | 12 | 3
AA | 13 | 3
AA | 14 | 3
AA | 15 | 4
AA | 16 | 4
AA | 17 | 4
AA | 18 | 4
AA | 19 | 4
AA | 20 | 5
AA | 21 | 5
AA | 22 | 5
AA | 23 | 5
AA | 24 | 5
AA | 25 | 6
AA | 26 | 6
AA | 27 | 6
AA | 28 | 6
AA | 29 | 6
AA | 30 | 7
AA | 31 | 7
AA | 32 | 7
AA | 33 | 7
AA | 34 | 7
AA | 35 | 7
AA | 36 | 8
AA | 37 | 8
AA | 38 | 8
AA | 39 | 8
AA | 40 | 8
AA | 41 | 9
AA | 42 | 9
AA | 43 | 9
AA | 44 | 9
AA | 45 | 10
AA | 46 | 10
AA | 47 | 10
AA | 48 | 10
AA | 49 | 11
AA | 50 | 11
AA | 51 | 11
AA | 52 | 11
AA | 53 | 11
AA | 54 | 12
AA | 55 | 12
AA | 56 | 12
AA | 57 | 13
AA | 58 | 13
AA | 59 | 14
AA | 60 | 14
AA | 61 | 15
AA | 62 | 15
AA | 63 | 16
AA | 64 | 17
AA | 65 | 18
AA | 66 | 19
BB | 0 | 1
BB | 1 | 1
BB | 2 | 1
BB | 3 | 1
BB | 4 | 1
BB | 5 | 1
BB | 6 | 2
BB | 7 | 2
BB | 8 | 3
BB | 9 | 3
BB | 10 | 4
BB | 11 | 4
BB | 12 | 5
BB | 13 | 5
BB | 14 | 6
BB | 15 | 6
BB | 16 | 7
BB | 17 | 7
BB | 18 | 7
BB | 19 | 8
BB | 20 | 8
BB | 21 | 9
BB | 22 | 9
BB | 23 | 10
BB | 24 | 11
BB | 25 | 11
BB | 26 | 12
BB | 27 | 13
BB | 28 | 13
BB | 29 | 14
BB | 30 | 15
BB | 31 | 16
BB | 32 | 17
BB | 33 | 18
BB | 34 | 19
BB | 35 | 19
BB | 36 | 19
Spreadsheet: 744065d1628897900-conditional-formatting-cell-if-value-exists-on-another-table-with-the-same-column-header-mismatch-finder-v3-081321-help
Sheet: Data Worksheet

Animal | Vegetable | Mineral | Soda
Cat | Squash | Silver | Dog
Potato | Celery | Pepsi | [NAME]
Horse | Platinum | Gold | Coke
Celery | Lead | [NAME] | Horse
Spreadsheet: 703094d1604750989-use-index-match-with-an-isblank-excel-problem
Sheet: Sheet1

 | Sheet 1 |  |  | Sheet 2
 | Item Code | Add-in Code |  | Add-in Code | Item Code |  | Item Code (Wanted Result)
 | A100 | S100 |  | S100
 |  | S101 |  | S101
 |  | S102 |  | S102
 | B100 | R101 |  | R101
 |  | R102 |  | R102
 |  | R103 |  | R103