tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 781490d1653376543-check-ready-when-two-columns-match-requirements-testbook-1-
Sheet: Sheet1

 | Client | Client 1 | Client 2 | Client 3 | Client 4 | Client 5 | Client 6 | Client 7 | Client 8 | Client 9 | Client 10
Item | Prepared
1 | YES | x | x | x
2 |  |  |  | x |  |  |  |  |  |  |  |  | Still return "R" as ready.
3 | YES | x | x
4 |  |  | x |  | x |  |  |  |  |  |  |  | Client 5 example : after deleting G8 "x", "R" remains
5 | YES |  |  | x
6 | YES
7 | YES |  |  |  | x
8 | YES |  |  |  |  | x
9
10
 | Client | Client 1 | Client 2 | Client 3 | Client 4 | Client 5 | Client 6 | Client 7 | Client 8 | Client 9 | Client 10
Item | Prepared | R | F | F | F | F |  |  |  |  |  |  |  | Expected result : case is blank, as no "x" are written down
1 | YES | x | x | x
2 |  |  |  | x
3 | YES | x | x
4 |  |  | x |  | x |  |  |  |  |  |  |  |  | G25 removed, G17 turns "F"
5 | YES |  |  | x
6 | YES
7 | YES |  |  |  | x
8 | YES |  |  |  |  | x
9
10
Spreadsheet: 834176d1687517610-duplicate-issue-example
Sheet: Sheet1

row_number | ambiance_grades | sound_sentiment_score | smell_sentiment_score | light_sentiment_score | ID_sentiment_score |  |  |  |  |  | row_number | ambiance_grades | sound_sentiment_score | smell_sentiment_score | light_sentiment_score | ID_sentiment_score
16 | 4 | 2 | 0 | 0 | 0 |  |  |  |  |  | 16 | 4 | 2 | 3.2 | 0 | 0
39 | 2 | 3.05 | 0 | 0 | 0 |  |  |  |  |  | 39 | 2 | 3.05 | 0 | 0 | 0
72 | 4 | 2.5 | 0 | 0 | 0 |  |  |  |  |  | 72 | 4 | 2.5 | 0 | 0 | 0
16 | 4 | 0 | 3.2 | 0 | 0 |  |  |  |  |  | 103 | 2 | 3.4 | 0 | 0 | 0
103 | 2 | 3.4 | 0 | 0 | 0
Spreadsheet: 5ca22c18-3781-4eee-afb2-becd8033d933
Sheet: Affordability-Tuition

Achieve 2015
Affordability
Maintain tuition and fees at less than half of the comparable cost of attending Virginia’s public four-year institutions, and increase the annual number of students who receive financial assistance through grants and scholarships by 36,000.
 | 2007-2008 | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2014-2015
Average 4-year1,2 | 7083 | 7582 | 7984 | 8830 | 9536
VCCS | 2404 | 2584 | 3000 | 3225 | 3570
VCCS Tuition as % of Average 4-year | 0.3394042072568121 | 0.3408071748878924 | 0.375751503006012 | 0.3652321630804077 | 0.3743708053691275
1VCCS Tuition for 2009-2010 reflects Summer 2010 Tuition Rate
22011-2012 Average 4-year Tuition is preliminary
Data Source for the 4-year Average Tuition is the SCHEV Tuition and Fees Report which is published each August and is available on the SCHEV website (http://www.schev.edu/reports/reportsindex.asp) .
Spreadsheet: 151001d1334756398-help-with-getting-a-specific-row-and-column-cell-value-to-another-spreadsheet-sample-report
Sheet: Data

4/2/2012 |  |  |  |  | 2012-04-02 00:00:00 |  |  |  |  | 2012-04-02 00:00:00
 | Large | Medium | Small |  |  | Not Destroyed | Cant be Broken | Unknown |  |  | Finished
Doe, [NAME] | 0 | 3 | 0 |  | Doe, [NAME] | 0 | 1 | 0 |  | Doe, [NAME] | 1
[NAME], [NAME] | 0 | 0 | 1 |  | [NAME], [NAME] | 0 | 1 | 0 |  | [NAME], [NAME] | 1
Bond, [NAME] | 1 | 0 | 0 |  | Connery, Sean | 0 | 1 | 0 |  | [NAME], [NAME] | 1
[NAME], [NAME] | 1 | 1 | 0 |  | [NAME], [NAME] | 1 | 0 | 0 |  | Costello, Abbot | 1
Costello, Abbot | 0 | 1 | 0 |  | [NAME], [NAME] | 0 | 2 | 3
[NAME], [NAME] | 0 | 1 | 0
Spreadsheet: 217523d1362088751-converting-military-time-to-a-number-semi-monthly-timesheet_test
Sheet: Sheet1

Name |  |  | ID
Pay Period Beginning |  | 2013-02-18 00:00:00 | Pay Period Ending
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | TOTAL
 | 08:00:00 |  |  | 14:00:00
 | 08:00:00 |  |  | 15:00:00
 |  |  |  | CUMULATIVE TOTAL
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | TOTAL
 | 09:00:00 |  |  | 11:00:00
 | 09:00:00 |  |  | 14:00:00
 | 09:00:00 |  |  | 14:00:00
 |  |  |  | CUMULATIVE TOTAL
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | TOTAL
Use this 3rd week if necessary |  |  |  | CUMULATIVE TOTAL
 |  | TOTAL HOURS FOR PAY PERIOD
REPORT TIME IN QUARTERLY (.00, .25, .50, .75) INCREMENTS
SIGNATURE |  |  |  | DATE
SUPERVISOR SIGNATURE |  |  |  | DATE
ORGANIZATION/UTD DEPARTMENT |  |  |  | CONTACT PHONE NO.
 |  |  |  |  | Rev. 8/2012
Spreadsheet: 723025d1615481742-index-match-vs-vlookup-or-is-there-a-better-way-sample_pr
Sheet: ALCO-G001^ (2)

Job Number: | ALCO-G001^ |  |  | Certified? |  |  |  | Prevailing Wage?
Job Description:
Customer: |  |  |  | OCIP? |  |  |  | Base Rate:
 |  |  |  |  |  |  |  | Fringe:
Portal: |  |  |  |  |  |  |  | Total Rate:
Notes/Instructions:
Employee First Name | Employee Last Name | Employee Number | Date | Job Number | Job Description | City | State | Earning Code | Hours Amount | Note
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T30

الجدول 30: تقديرات السكان حسب فئات العمر والمواطنون/غير مواطنين وحضر/ريف والجنس  في الأردن، 2010
Table 30: Population etimates by age groups, nationals/non-nationals, urban/rural and sex in Jordan,  2010
 | Nationals | المواطنون | Non- Nationals | [NAME] | Urban | حضر | Rural | ريف | Total | المجموع | المجموع
[NAME] | رجال | نساء | رجال | نساء | رجال | نساء | رجال | نساء | رجال | نساء | [NAME]
Age group | Men | Women | Men | Women | Men | Women | Men | Women | Men | Women | Both sexes
0-4 | ... | ... | ... | ... | ... | ... | ... | ... | 400180 | 379430 | 779610
5-9 | ... | ... | ... | ... | ... | ... | ... | ... | 395140 | 375290 | 770430
10-14 | ... | ... | ... | ... | ... | ... | ... | ... | 376230 | 355440 | 731670
15-19 | ... | ... | ... | ... | ... | ... | ... | ... | 345350 | 325520 | 670870
20-24 | ... | ... | ... | ... | ... | ... | ... | ... | 335580 | 311900 | 647480
25-29 | ... | ... | ... | ... | ... | ... | ... | ... | 288000 | 259180 | 547180
30-34 | ... | ... | ... | ... | ... | ... | ... | ... | 248930 | 229850 | 478780
35-39 | ... | ... | ... | ... | ... | ... | ... | ... | 201660 | 186310 | 387970
40-44 | ... | ... | ... | ... | ... | ... | ... | ... | 148730 | 140400 | 289130
45-49 | ... | ... | ... | ... | ... | ... | ... | ... | 104610 | 99820 | 204430
50-54 | ... | ... | ... | ... | ... | ... | ... | ... | 77510 | 76120 | 153630
55-59 | ... | ... | ... | ... | ... | ... | ... | ... | 66800 | 69310 | 136110
60-64 | ... | ... | ... | ... | ... | ... | ... | ... | 62390 | 55980 | 118370
65-69 | ... | ... | ... | ... | ... | ... | ... | ... | 44420 | 41490 | 85910
70-74 | ... | ... | ... | ... | ... | ... | ... | ... | 28280 | 27730 | 56010
75+ | ... | ... | ... | ... | ... | ... | ... | ... | 27190 | 28230 | 55420
المجموع Total | ... | ... | ... | ... | ... | ... | ... | ... | 3151000 | 2962000 | 6113000
Spreadsheet: 830819d1685132019-problem-with-filter-and-values-for-a-graphic-livro88
Sheet: Folha1

 |  |  |  | =<>""
 |  |  | EMPTY (WITHOUT ANY FORMULA OR VALUE)
 |  |  | EMPTY ( BUT WITH A FORMULA) - HIDDEN
 |  |  |  |  |  |  | JANEIRO | FEVEREIRO | MARÇO | ABRIL | MAIO | JUNHO | JULHO | AGOSTO | SETEMBRO | OUTUBRO | NOVEMBRO | DEZEMBRO | JANEIRO
 |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
 |  |  |  |  |  |  | [NAME] | FEV-13 | MAR-13 | ABR-13 | MAI-13 | JUN-13 | JUL-13 | AGO-13 | SET-13 | OUT-13 | NOV-13 | DEZ-13 | JAN-14
 |  |  | PRODUT - 1 | (Colunns With another Information) |  | 10000 |  |  | 12400 | 9500 | 10100 | 12000 | 10706 | 11200 | 11850 | 11851 | 11852 | 11853 | 11854
 |  |  | PRODUT - 2 |  |  | 15000 | 10000 | 14500 |  | 15200 | 15700 | 16250 | 13500 | 14500 | 14900 | 14901 | 14902 | 14903 | 14904
 |  |  | PRODUT - 3 |  |  | 7500 | 10700 | 10850 | 7800 | 8000 | 9200
 |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  | 2014
 |  |  |  | PRODUT - 1 |  |  | 12400 | 9500 | 10100 | 12000 | 10706 | 11200 | 11850 | 11851 | 11852 | 11853 | 11854
 |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  | 2014
 |  |  |  | PRODUT - 2 |  |  | 10000 | 14500 | 15200 | 15700 | 16250 | 13500 | 14500 | 14900 | 14901 | 14902 | 14903 | 14904
 |  |  |  |  |  |  | 2013
 |  |  |  | PRODUT - 3 |  |  | 10700 | 10850 | 7800 | 8000 | 9200
Spreadsheet: 269807d1381290799-index-match-with-multiple-columns-there83
Sheet: Sheet1

Month | Location | Morning | Lunch | Afternoon | Night |  | Month |  | Location
January | WA | 2000 | 100 | 1000 | 500 |  | January |  | Wa
January | OR | 500 | 300 | 400 | 750
January | CA | 750 | 400 | 30 | 550 |  | Month | Location | Morning | Lunch | Afternoon | Night
February | WA | 3 | 9 | 100 | 50 |  |  |  |  |  |  |  | Non-array
February | OR | 5 | 200 | 100 | 95 |  |  |  |  |  |  |  | Array
February | CA | 8 | 10 | 50 | 85 |  |  |  |  |  |  |  | Array
March | WA | 9 | 60 | 200 | 75 |  |  |  |  |  |  |  | Array
March | OR | 10 | 75 | 60 | 65 |  |  |  |  |  |  |  | Non-array
March | CA | 5 | 50 | 425 | 55 |  |  |  |  |  |  |  | Array
Spreadsheet: 0d9367c8-52c7-4523-af51-41cd5f5fa026
Sheet: DDR Results

DDR Test Results
Person 2 | Left | Down | Up | Right | Total | Score
Perfect | 23 | 23 | 13 | 27 | 82 | A
Great | 5 | 6 | 11 | 7 | 29 | 23399250
Good | 1 | 3 | 0 | 0 | 4
Miss | 0 | 0 | 0 | 1 | 1
Person 1 | Left | Down | Up | Right | Total | Score
Perfect | 24 | 4 | 7 | 15 | 58 | AA
Great | 2 | 0 | 3 | 10 | 14 | 10838940
Good | 0 | 0 | 0 | 0 | 0
Miss | 0 | 1 | 0 | 0 | 1
Person 3 | Left | Down | Up | Right | Total | Score
Perfect | 15 | 0 | 13 | 23 | 51 | B
Great | 11 | 0 | 6 | 7 | 24 | 9649680
Good | 4 | 0 | 1 | 2 | 7
Miss | 2 | 0 | 0 | 0 | 2
Person 4 | Left | Down | Up | Right | Total | Score
Perfect | 16 | 6 | 17 | 15 | 53 | A
Great | 5 | 1 | 4 | 9 | 19 | 9836160
Good | 0 | 0 | 1 | 0 | 1
Miss | 1 | 0 | 0 | 0 | 1
Person 5 | Left | Down | Up | Right | Total | Score
Perfect | 9 | 1 | 2 | 5 | NA | NA
Great | 6 | 3 | 5 | 9 | NA | NA
Good | 7 | 0 | 1 | 5 | NA | NA
Miss | 1 | 1 | 1 | 3 | NA | NA
Person 6 | Left | Down | Up | Right | Total | Score
Perfect | 11 | 2 | 3 | 5 | NA | D
Great | 5 | 0 | 3 | 3 | NA | NA
Good | 9 | 2 | 5 | 2 | NA
Miss | 0 | 0 | 0 | 0 | NA
Person 7 | Left | Down | Up | Right | Total | Score
Perfect | 17 | 1 | 6 | 16 | 36 | B
Great | 14 | 1 | 3 | 12 | 29 | 8877540
Good | 1 | 1 | 0 | 2 | 3
Miss | 0 | 0 | 0 | 0 | 2
Person 8 | Left | Down | Up | Right | Total | Score
Perfect | 9 | 3 | 10 | 14 | 40 | C
Great | 2 | 1 | 3 | 1 | 17 | 8877540
Good | 7 | 0 | 3 | 4 | 8
Miss | 0 | 0 | 0 | 0 | 6
Person 9 | Left | Down | Up | Right | Total | Score
Perfect | 9 | 0 | 5 | 3 | 24 | C
Great | 5 | 1 | 4 | 9 | 44 | 7040335
Good | 2 | 1 | 1 | 2 | 2
Miss | 0 | 0 | 0 | 0 | 7?
Person 10 | Left | Down | Up | Right | Total | Score
Perfect | 5 | 2 | 10 | 15 | 38 | C
Great | 17 | 0 | 0 | 5 | 26 | 7954650
Good | 4 | 1 | 2 | 3 | 10
Miss | 2 | 1 | 0 | 0 | 6
 | Left Sum | Down Sum | Up Sum | Right Sum
Perfect
Great
Good
Miss
 | Left Sum | Down Sum | Up Sum | Right Sum
% Perfect
% Great
% Good
% Miss
Spreadsheet: 271605d1381998869-several-line-graphs-w-drop-down-list-961894b
Sheet: Sheet1

Section | Part Code | Description | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | Total 11-12 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | Total 12-13
Budget Locks and Accessories | JBC101 | BRASS BUDGET LOCK NYLON BOLT | 510 | 211 | 92 | 320 | 481 | 345 | 50 | 285 | 330 | 391 | 634 | 761 | 4410 | 152 | 341 | 478 | 180 | 275 | 266 | 130 | 100 | 345 | 774 | 19 | 100 | 3160
 | JBC108 | SHORT REACH KEY | 3200 | 19360 | 4400 | 18350 | 2800 | 360 | 2375 | 24305 | 17030 | 635 | 1390 | 3205 | 97410 | 20570 | 4730 | 600 | 29834 | 6170 | 1167 | 15870 | 7280 | 20106 | 4350 | 2260 | 13500 | 126437
 | JBC109 | [NAME] | 55 | 10 | 110 | 45 | 113 | 150 | 0 | 10 | 594 | 299 | 0 | 70 | 1456 | 320 | 50 | 50 | 460 | 300 | 100 | 400 | 120 | 0 | 0 | 200 | 450 | 2450
 | JBC146 | T- [NAME] 125mm | 0 | 0 | 0 | 500 | 0 | 20 | 20 | 5 | 400 | 120 | 0 | 50 | 1115 | 200 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 240
 | JBC159 | YELLOW GAS KEY | 0 | 0 | 0 | 100 | 2600 | 0 | 0 | 0 | 0 | 50 | 0 | 400 | 3150 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 100 | 70 | 20 | 490
 |  |  |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
 |  | BRASS BUDGET LOCK NYLON BOLT | 2011
 |  |  | 2012
Spreadsheet: 158855d1338410020-results-summarizing-across-multiple-sheets-copy-of-guest-comments-card
Sheet: Total Summary

Aquarius Lunch | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling
Table service
Variety of food and beverage menu
Server's knowledge of menu selection
Quality and presentation of food
Portion size of food
Quality and presentation of beverage
Restaurant atmosphere
[NAME] handling
Aquarius Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling
Table service
Variety of food and beverage menu
Server's knowledge of menu selection
Quality and presentation of food
Portion size of food
Quality and presentation of beverage
Restaurant atmosphere
[NAME] handling
[NAME] Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling
Table service
Variety of food and beverage menu
Server's knowledge of menu selection
Quality and presentation of food
Portion size of food
Quality and presentation of beverage
Restaurant atmosphere
[NAME] handling
Spreadsheet: 707172d1607082610-find-the-earliest-occurence-date-and-time-and-the-corresponding-category-sample
Sheet: Sheet1

Resco Overview DATE | Resco Overview TIME | Resco Mobile CRM Application DATE | Resco Mobile CRM Application TIME | Woodford Walkthrough DATE | Woodford Walkthrough TIME | Entities DATE | Entities TIME | Entity Views DATE | Entity Views TIME | Entity Forms DATE | Entity Forms TIME | Views & Forms: Advanced Customizations DATE | Views & Forms: Advanced Customizations TIME | Business Logic via Rules DATE | Business Logic via Rules TIME | Component Configuration DATE | Component Configuration TIME | User full name
2019-10-21 00:00:00 | 16:13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User 1
 |  |  |  |  |  |  |  | 2020-11-12 00:00:00 | 12:14 |  |  |  |  | 2020-11-12 00:00:00 | 12:14 |  |  | User 2
2019-10-24 00:00:00 | 13:25 |  |  |  |  | 43762 | 13:38 | 2019-10-24 00:00:00 | 13:39 | 2019-10-24 00:00:00 | 13:42 | 2019-10-24 00:00:00 | 13:46 | 2019-10-25 00:00:00 | 07:59 |  |  | User 3
2019-10-24 00:00:00 | 14:36 |  |  |  |  |  |  |  |  |  |  | 2019-10-24 00:00:00 | 14:38 |  |  |  |  | User 4
2019-10-24 00:00:00 | 16:42 | 2020-02-17 00:00:00 | 11:48 | 2020-02-17 00:00:00 | 12:36 | 2019-10-31 00:00:00 | 12:56 | 2020-02-18 00:00:00 | 10:50 | 2019-11-20 00:00:00 | 12:05 | 2019-10-31 00:00:00 | 16:07 | 2020-02-17 00:00:00 | 12:40 | 2020-02-17 00:00:00 | 12:40 | User 5
2019-10-25 00:00:00 | 10:17 | 2020-08-28 00:00:00 | 09:41 | 2020-08-28 00:00:00 | 09:41 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:31 | User 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User 7
2019-10-27 00:00:00 | 00:40 | 2020-02-03 00:00:00 | 14:50 | 2020-07-02 00:00:00 | 21:41 | 2020-07-02 00:00:00 | 21:42 | 2020-07-02 00:00:00 | 21:42 | 2020-07-02 00:00:00 | 21:42 | 2020-07-02 00:00:00 | 21:43 | 2020-07-02 00:00:00 | 21:44 | 2020-07-02 00:00:00 | 21:45 | User 8
Spreadsheet: phillip_m_love__30130__InventoryNapoleonville00
Sheet: InvP&L

Inventory Profit and Loss
Production Month | VNG |  |  |  |  | [NAME] |  |  |  |  | Bistineau |  |  |  |  | Spindletop |  |  |  |  | Napoleonville
 | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L | Total
2000-12-01 00:00:00
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
Spreadsheet: 143204d1330293767-i-need-dates-to-change-colors-when-within-certain-number-of-days-of-current-date-due-dates-submit
Sheet: Sheet1

Client Name | Admit date | Initial Treatment Plan | Initial Treatment Plan Actual | First Treatment Plan Update | First Treatment Plan Update Actual | Second Treatment Plan Update | Second Treatment Plan Update Actual | Third Treatment Plan Update | Third Treatment Plan Actual | Fourth Treatment Plan Update |  |  |  | Updates Due
[NAME] | 2012-02-08 00:00:00
[NAME] | 2012-02-01 00:00:00
Shawn Doe | 2012-01-12 00:00:00
Spreadsheet: 681132df-042d-479d-b743-87a2de7d2047
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
BFBL | Test | BFBL | [NAME], [NAME] | Bilirubin, BF | Photometric, Diazonium Salt | Amber vial (Supply T192) |  |  | 3 | mL | Collection Container/Tube: Body fluid container Submission Container/Tube: Opaque, amber vial (Supply T192) [NAME]: 1 mL Collection Instructions: 1. Centrifuge, separate supernatant, and send both supernatant and sediment. 2. Protect specimen from light. 3. Label specimens as sediment and supernatant.  Additional Information: Indicate specimen source. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Not applicable The reference range has not been established for bilirubin in body fluids. The test result should be integrated into the clinical context for interpretation. | Monday through Saturday; Continuously | Same day | 1 day | 1 | 82247 |  |  |  |  | Rochester
BFBL | [NAME] | BODYFL | Body Fluid |  |  |  | Frozen | 70 days
BFBL | Order Question | FLD14 | [NAME]: |  | Plain Text
BFBL | Result | BRNBF | [NAME] (BF) | [NAME] (BF) | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1974-5 | Bilirubin:MCnc:Pt:Body fld:Qn:
BFBL | Result | FLD14 | [NAME]: | [NAME]: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6 | Fluid:Type:Pt:Body fld:Nom:
Spreadsheet: 692349d1598287686-need-to-extract-data-and-skip-blanks-machine-shop-schedules_excel-forum
Sheet: Millroom_Laser

Projected Delivery Date (to Production / ENG) | Priority | Part# | S/O # | S/O Due / ENG PROMISE | Rev | ORIG Job Qty | ACTUAL QTY | Raw Mat'l PO / ECO# | Job # | VT MEC PO# | Status | Chemfilm/PASSIVATE | Paint / Silkscreen | PROJECTED RUN TIME (IN DAYS) | Projected Machine Finish Date | Actual Machine Finish Date | Notes | Ready for Plating process
 |  | PN 16 |  |  | A1 | 1 |  |  | 27418 |  |  | No | No
 |  | PN 17 |  |  | A | 2 |  |  | 27612 |  |  | No | No
 |  | PN 18 | 16336 | 2019-08-20 00:00:00 | A | 12 |  |  | 21579 | - |  | No | No | 0.04166666666666666 |  |  | LASER SHELF
 |  | PN 19 | 16336 | 2019-08-30 00:00:00 | A | 10 |  |  | 20528 | - |  | No | No | 0.04166666666666666
 |  | PN 20 | NPI | 2019-09-05 00:00:00 | A | 1 |  |  | 27624 |  |  | No | No
 |  | PN 21 | 16771 | 2020-02-21 00:00:00 | B | 3 |  |  | 26791 | - |  | Yes | No | 0 |  |  |  | x
 |  | PN 22 | 16756 | 2020-03-10 00:00:00 | A2 | 2 |  |  | 27394 |  |  | No | No
 |  | PN 23 | 16782 | 2020-03-13 00:00:00 | A | 10 |  |  | 26113 | - |  | Yes | No | 0.04166666666666666 |  |  |  | x
 |  | PN 24 | 16657 | 2020-03-13 00:00:00 | A | 5 |  |  | 27283 |  |  | Yes | No |  |  |  |  | x
 |  | PN 25 | 15889 | 2020-03-20 00:00:00 | A | 27 |  |  | 26850 |  |  | No | No
 |  | PN 26 | 15889 | 2020-03-20 00:00:00 | A | 17 |  |  | 27289 |  |  | No | No
 |  | PN 27 | 15889 | 2020-03-20 00:00:00 | A | 17 |  |  | 27289 |  |  | No | No
 |  | PN 28 | 15889 | 2020-03-20 00:00:00 | A | 35 |  |  | 27290 |  |  | No | No
 |  | PN 29 | 17020 | 2020-05-04 00:00:00 | A | 5 |  |  | 25052 | - |  | Yes | No | 0.04166666666666666 |  |  |  | x
 |  | PN 30 | 17025 | 2020-05-08 00:00:00 | A | 19 |  |  | 24729 | - |  | Yes | No | 0.04166666666666666 |  |  |  | x
Spreadsheet: 702309d1604268666-formula-that-refernces-resource-to-give-a-monthly-total-resource1-v2
Sheet: Sheet3

 | Resourcing as at
 |  | Oct-20 Planned |  |  |  | Nov-20 Planned |  |  |  | Dec-20 Planned |  |  |  | Jan-21 Planned
 | Resource
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 454694d1459950044-sumifs-dsum-index-match-help-excel-training
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Department | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 |  | Row Labels | Count of Jan-16
 |  |  |  |  |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 |  | Development | 1 | 9 | 3 |  | Development | 2
 |  |  |  | Finance |  |  |  |  |  | Finance | 2 | 7 | 5 |  | Finance | 2
 |  |  |  | Support |  |  |  |  |  | Finance | 6 | 1 | 4 |  | MD | 2
 |  |  |  | Development |  |  |  |  |  | Finance | 54 | 67 | 7 |  | Support | 5
 |  |  |  | MD |  |  |  |  |  | Support | 5 | 2 | 1 |  | Grand Total | 11
 |  |  |  |  |  |  |  |  |  | Support | 41 | 45 | 7
 |  |  |  |  |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 |  | MD | 5 | 56 | 5
 |  |  |  | Finance |  |  |  |  |  | Support | 2 | 2 | 56
 |  |  |  | Support |  |  |  |  |  | Support | 1 | 56 | 5
 |  |  |  | Development |  |  |  |  |  | Finance | 3 | 6 | 5
 |  |  |  | MD |  |  |  |  |  | Development | 2 | 5 | 1
 |  |  |  |  |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00
 |  |  |  | Finance
 |  |  |  | Support
 |  |  |  | Development
 |  |  |  | MD
 |  | CountIf
 |  |  |  |  |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00
 | Finance |  |  | Finance
 | Support |  |  | Support
 | Development |  |  | Development
 | MD |  |  | MD
 |  |  | Hi all,
 |  |  | I am trying to learn the SUMIFS, Index/Match & DSUM formula's (or just get an understanding of them) but cant seem to work them.
 |  |  | Attached is an example of data.
 |  |  | Using all 3 different types of formula I am trying to work out how I can use them to get the desired result i.e. total count matching department type against month.
Spreadsheet: 124099d1318098392-calculate-hi-points-points
Sheet: Summary

All Breed Yearling Trail |  |  | [NAME] |  |  | All Breed Walk Trot Trail |  |  | All Breed Youth Trail
Back# | Total |  | Back# | Total |  | Back# | Total |  | Back# | Total
154 | 12 |  | 154 | 0 |  | 154 | 0 |  | 154 | 0
111 | 10 |  | 111 | 0 |  | 111 | 0 |  | 111 | 0
112 | 8 |  | 112 | 0 |  | 112 | 0 |  | 112 | 0
3 | 6 |  | 3 | 0 |  | 3 | 0 |  | 3 | 0
88 | 4 |  | 88 | 0 |  | 88 | 0 |  | 88 | 0
99 | 2 |  | 99 | 0 |  | 99 | 0 |  | 99 | 0
I would like it to Sumarize something like this. Back number with points sorted descending. This would calculate one show and in the year we have a total of four shows just like this. Dream scenario would be that I could add each class for all four shows together to come up with a YEAR END GRAND TOTAL for each back number shown in the class for the year.
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: NewCo_IS

NewCo INCOME STATEMENT
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Check
ENA
FPLE
EBITDA from Projects
Revenue to FPLE (Fees & Interests)
Corporate [NAME]
EBITDA
ENA
FPLE
Depreciation & Amortization
EBIT
ENA
FPLE
Interest Expense
Interest Income
EBT
ENA
FPLE
NewCo
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Wind Portfolio PTC
Net Income
Net Income with Development Pipeline
EBITDA with Development Projects