tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155913d1337101945-summation-formula-sample-12-
Sheet: Sheet1

1 | 7
1 | 4
1 | 5
1 | 5
1 | 6
1 | 3
1 | 0
1 | 7
1 | 6
1 | 10
1 | 5
1 | 4 | 62 | 62
2 | 7
2 | 9
2 | 8
2 | 7
2 | 7
2 | 13
2 | 6
2 | 0
2 | 10
2 | 5
2 | 7
2 | 8 | 87 | 87
3 | 12
3 | 9
3 | 9
3 | 7
3 | 5
3 | 0
3 |  | 42 | 42
Spreadsheet: 726711d1617382196-convert-text-days-hours-minutes-to-total-hours-example
Sheet: Sheet1

Location | Time in location | Actions | Total Dwell
a | 2 day(s), 17 hour(s), 26 minute(s) | none
b | 4 hour(s), 59 minute(s) | move | 5
c | 8 hour(s), 43 minute(s) | waiting | 9
d | 100 day(s), 4 hour(s), 15 minute(s) | none
e | 7 day(s), 17 minute(s) | move
a | 4 minute(s) | waiting | 1
b | 4 minute(s) | none | 1
c | 6 hour(s), 10 minute(s) | move | 7
d | 17 day(s), 5 hour(s), 34 minute(s) | waiting
e | 8 day(s), 7 hour(s), 16 minute(s) | none
a | 1 day(s), 19 hour(s), 32 minute(s) | move
b | 23 day(s), 10 hour(s), 50 minute(s) | waiting
c | 4 day(s), 9 hour(s), 11 minute(s) | none
d | 1 day(s), 18 hour(s), 54 minute(s) | move
e | 17 day(s), 7 hour(s), 3 minute(s) | waiting
a | 1 day(s), 5 hour(s), 56 minute(s) | none | 30
b | 16 hour(s), 36 minute(s) | move | 17
c | 297 day(s), 6 hour(s), 2 minute(s) | waiting
Spreadsheet: 42980d1241604439-data-from-text-to-number-and-an-if-then-formula-daily-cash-debit-downloads
Sheet: Bank Data Download

As-of Date | Date | BankID Type | BankID | BankID Description | Account Number | Account Description | Row Type | [NAME] | BAI Code | Description | Amount | Balance/Value date | Customer Reference | Bank Reference | Credit Immediate Availability | Credit 1 Day Float | Credit 2+ Day Float | Item Count | Text
20090427 | 2009-04-27 00:00:00 |  |  |  |  |  | Data | [NAME] | 738 | CONTROLLED DISB FUNDING DEBIT | 105645.48 |  | 12342470
20090427 | 2009-04-27 00:00:00 |  |  |  |  |  | Data | [NAME] | 738 | CONTROLLED DISB FUNDING DEBIT | 1146896.1 |  | 12344396
20090427 | 2009-04-27 00:00:00 |  |  |  |  |  | Data | [NAME] | 738 | CONTROLLED DISB FUNDING DEBIT | 221487.23 |  | 12344409
20090427 | 2009-04-27 00:00:00 |  |  |  |  |  | Data | [NAME] | 738 | CONTROLLED DISB FUNDING DEBIT | 428073 |  | 12341698
20090427 | 2009-04-27 00:00:00 |  |  |  |  |  | Data | [NAME] | 738 | CONTROLLED DISB FUNDING DEBIT | 6038.16 |  | 12341700
20090427 | 2009-04-27 00:00:00 |  |  |  |  |  | Data | [NAME] | 738 | CONTROLLED DISB FUNDING DEBIT | 354.21 |  | 12341727
20090427 | 2009-04-27 00:00:00 |  |  |  |  |  | Data | [NAME] | 738 | CONTROLLED DISB FUNDING DEBIT | 1138.23 |  | 12341735
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 674532d1587897374-conditional-formats-base-don-cell-results-condformtest
Sheet: Sheet1

Approved Overdraft | 10000 | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period
 |  | 2019-12-30 00:00:00
 |  | 1
 |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual
 | OPENING CASH BALANCE | -5000 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
So Because B1>0 I would like the cell colour of cells C5:M5 to be either Red if the value is greater than -B1, or Orange if betwwen 0 and B1
If B1 = 0, then I would like the clolur of cells C5:M5 to be red, if the value is<0
Spreadsheet: 729365d1619042991-find-maximum-value-matching-specific-names-with-multiple-entries-find-maximum-value-matching-specific-names-with-multiple-entries
Sheet: Sheet1

ClubId | CourseName | Slope | MarkerName |  |  |  |  |  | Expected
30232 | Achill | 95 | White |  |  |  |  |  | Achill | 95 | White
30232 | Achill | 95 | White B9 |  |  |  |  |  | Athenry | 122 | White B9
30232 | Achill | 94 | White F9 |  |  |  |  |  | Athlone | 126 | Blue
30398 | Athenry | 122 | White B9
30398 | Athenry | 121 | White
30398 | Athenry | 121 | Green B9
30398 | Athenry | 119 | White F9
30398 | Athenry | 118 | Green
30398 | Athenry | 114 | [NAME]
30400 | Athlone | 126 | Blue
30400 | Athlone | 126 | Blue B9
30400 | Athlone | 126 | Blue F9
30400 | Athlone | 126 | White F9
30400 | Athlone | 125 | White
30400 | Athlone | 123 | White B9
30400 | Athlone | 123 | [NAME]
30400 | Athlone | 121 | Yellow
30400 | Athlone | 118 | [NAME]
30400 | Athlone | 117 | [NAME]
30400 | Athlone | 116 | Green
30400 | Athlone | 116 | Green B9
Spreadsheet: 274780d1383218498-how-to-show-values-less-than-or-equal-to-another-value-in-drop-down-list-data-validation-marbles
Sheet: Sheet1

Number of marbles |  | validation is here |  |  |  |  |  |  | Bag | Capacity of bag | validation calc
70 |  |  |  |  |  |  |  |  | 1 | 60
 |  |  |  |  |  |  |  |  | 2 | 300
 |  |  |  |  |  |  |  |  | 3 | 450
 |  |  |  |  |  |  |  |  | 4 | 150
 |  |  | in name manager
 |  |  | insert a named formula of
 |  |  | myrange | =Sheet1!$L$2:INDEX(Sheet1!$L$2:$L$5,COUNTIF(Sheet1!$L$2:$L$5,"<>0"))
Spreadsheet: 06b75c60-7d72-4335-b586-17872bb20cf5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 | Kelompok Kerja Pengadaan Jasa Konsultansi Unit Layanan Pengadaan [NAME] Umum Provinsi Sulawesi Barat [NAME] 2012
 | PENGUMUMAN HASIL PERINGKAT TEKNIS
 | [NAME] : 13/CK/ULP-DPU/AWS/JL-DES/ IX/2012
 |  |  |  |  |  | Nama  [NAME] |  |  |  |  |  | : | [NAME]
 |  |  |  |  |  | Nama  Kegiatan |  |  |  |  |  | : | Pengawasan Teknis Jalan Desa
 |  |  |  |  |  | [NAME] (HPS) |  |  |  |  |  | : | 179905000
 |  |  |  |  |  | [NAME] |  |  |  |  |  | : | APBD [NAME] tahun anggaran 2012
 | Berdasarkan surat Kepala Unit [NAME] [NAME] Umum Provinsi Sulawesi Barat [NAME] 2012 nomor : 01/ULP-DPU/CK/AWS-JL/DS/ IX/2012 tanggal 03 Sept. 2012  tentang Penetapan Peringkat Teknis Paket Pekerjaan Pengawasan Teknis Jalan Desa maka dengan ini diberitahukan bahwa Penyedia Jasa Konsultansi yang LULUS [NAME] teknis untuk pekerjaan tersebut di atas [NAME] berikut :
 | No. | Nama / Alamat Perusahaan |  |  |  |  |  |  |  |  |  | NPWP |  |  |  |  | Evaluasi Administrasi | [NAME] |  | Kesimpulan Evaluasi Sampul I | Keterangan/Peringkat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nilai | [NAME]
 | 1 | CV. [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lulus | 72.4 | Lulus | Lulus | I
 | 2 | CV. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lulus | 71.95 | Lulus | Lulus | II
 | 3 | CV. C97 Consultant |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lulus | 59.2 | Gugur | Gugur | -
 | 4 | PT. [NAME] |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | Lulus | 63.44 | Gugur | Gugur | [NAME] tidak cukup
 | 5 | PT. Praprimadani Pratama |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | Lulus | 63.16 | Gugur | Gugur | [NAME] tidak cukup
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 65
 | Demikian Pengumuman ini untuk [NAME] perhatian para Penyedia Jasa, [NAME] terima [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mamuju, 03 Sept. 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kelompok Kerja Pengadaan [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HARYANTO, ST., MT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K e t u a
Spreadsheet: 804188d1667929206-why-is-this-simple-excel-logic-if-then-escaping-me-please-help-sample_excel_query
Sheet: Sheet1

 | SAMPLE #1
 |  | Items | Rating
 |  | A | Optimal
 |  | B | Effective
 |  | C | Adequate
 |  | D | Weak
 |  | E | Ineffective
 |  | F | Adequate |  | <-- Lowest Rating - to - Highest Rating -->
 |  | G | Weak |  | Ineffective | Weak | Adequate | Effective | Optimal
 | Final Group Rating |  | Weak
 | Since the lowest rating of "Ineffective" had one vote, the next higher rating of "Weak" was assigned
 | SAMPLE #2
 |  | Items | Rating
 |  | A | Adequate
 |  | B | Weak
 |  | C | Optimal
 |  | D | Adequate
 |  | E | Optimmal
 |  | F | Adequate |  | <-- Lowest Rating - to - Highest Rating -->
 |  | G | Weak |  | Ineffective | Weak | Adequate | Effective | Optimal
 | Final Group Rating |  | Weak
 | Since the lowest, non-zero rating of "weak" was voted more than once, the rating assigned will be "Weak"
 | Note: The logic must run from the lowest rating to the highest rating.
Spreadsheet: 473835d1470419908-mileage-reimbursement-form-formulas-not-working-mileage-reimbursement
Sheet: Mileage Log and Reimbursement

Mileage Log and Reimbursement Form (effective 7.21.16)
Employee Name |  | [NAME] |  | Amityville |  | Huntington 148 E Main
Manager's Name |  | [NAME] |  | Bay Shore 180 |  | [NAME] 281 Main
Manager's Signature |  |  |  | Bay Shore 375 |  | Little Neck
 |  |  |  | Brentwood |  | Other
Rate Per Mile |  | 0.54 |  | Deer Park |  | Port Jefferson
 | Total Mileage |  |  | Garden City |  | Riverhead
Total Mileage Reimbursement LIEYE Managers enter in payroll |  |  |  | Hauppauge |  | Sayville
Total Mileage Hours/Minutes LIEYE Managers enter in payroll |  |  | Mileage minutes are rounded to the nearest quarter hour | Haupauge (LIVM/MCM) |  | Smithtown
 |  |  |  | Hempstead |  | Southampton
Pay Date |  |  |  | Holbrook |  | Southold
Pay Period Start (Monday) |  |  |  |  |  | West Islip
Pay Period End (Sunday)
Please keep in mind that mileage reimbursement is only applicable towards travel that exceeds one's normal commute.
If the location you are traveling to or from is not listed in Column C or D, please select "Other" and explain the location and mileage rationale thoroughly.
You must include mileage data from Google Maps only if "Other" is selected.
Date | [NAME] | Starting Location | Destination | Description/Reason | Mileage (one way) | Reimbursement | Mileage Hours /Minutes |  | Reimbursement
2016-08-03 00:00:00 | No | Amityville | Bay Shore 180 | Food Run |  |  |  | 18 | =IF($B26="Yes",F26*$C$7*2,$F26*$C$7)
2016-08-03 00:00:00 | Yes | [NAME] | Amityville | Food Run |  |  |  | 23
2016-08-03 00:00:00 | Yes | Garden City | Sayville | Food Run |  |  |  | 50
Spreadsheet: 113064d1309009191-countif-for-two-criteria-countif-for-two-criteria
Sheet: upg-column D is text

 |  |  |  |  |  | Desired data range : D5 to aa9999
 |  | cust_id | bank_section_Canada | [NAME] | bank_ret_cu | upgrade_second | upgrade_ret | upgrd_abc | cls_flag | ip_id | bank_code | week_start | account name | Customer segment | cust_no_random | Remark | account reprsentative | monitor | date of complete
 |  | 19293949 | 5 | 2 | 3 | 3 | 5 | 5 |  |  | 11333 | week1 | BBABCD123456789 | pct |  | sales complete | [NAME] | y | 20110420
 |  | 19320932 | 5 | 4 | 3 | 5 | 5 | 7 |  |  | 44333 | week2 | BBABCD030221111 | act |  | customer refuse | [NAME] | n | 20110319
 |  | 23493222 | 3 | 5 | 5 | 6 | 6 | 7 |  |  | 44555 | week2 | BBABCD300000123 | act |  |  | [NAME] | n | 20110301
 |  | 43243131 | 5 | 1 | 3 | 3 | 5 | 6 |  |  | 43343 | week2 | BBABCD300000113 | act |  | customer refuse | [NAME] | y | 20110222
 |  | 32112312 | 7 | 2 | 2 | 4 | 7 | 6 |  |  | 32433 | week2 | BBABCD300000143 | act |  | sales complete | [NAME] | y | 20110222
 |  | 10203047 | 4 | 2 | 4 | 4 | 5 | 6 |  |  | 22333 | week3 | BBABCD203002000 | act |  | sales decline | [NAME] | y | 20110222
 |  | 43000020 | 7 | 3 | 4 | 4 | 3 | 4 |  |  | 43342 | week4 | BBABCD300000977 | act |  | sales decline | Tin | y | 20110222
 |  | 23429900 | 5 | 2 | 3 | 3 | 5 | 5 |  |  | 43343 | week4 | BBABCD300000999 | act |  | business retain | [NAME] | y | 20110222
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act |  | sales decline | Baggio | y | 20110222
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act |  | sales decline | Baggio | y | 20110222
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act |  | sales decline | Baggio | y | 20110222
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act |  | sales decline | Baggio | y | 20110222
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act |  | sales decline | Baggio | y | 20110222
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | act
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | pct
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | pct
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | pct
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | pct
 |  | 12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 | pct
Spreadsheet: 144497d1330998499-if-contains-vlookup-formula-copy-of-vlookup-if-contains
Sheet: Sheet1

Description | Lowest Level |  | Short Key | Lowest Level
abrasive blasting |  |  | abras | SANDBLASTING
access - products |  |  | acces | FALL PROTECTION AND RESCUE EQUIPMENT
account & audit services |  |  | accou | ACCOUNTING AND AUDITING
adhesive |  |  | adhes | ADHESIVES AND SEALANTS
advertising |  |  | adver | ADVERTISING
aggregates |  |  | aggre | EARTH AND STONE
agricultural machinery |  |  | agric | AGRICULTURAL AND FORESTRY AND LANDSCAPE MACHINERY AND EQUIPMENT
agricultural supplies |  |  | agric | LIVE PLANT AND ANIMAL MATERIAL AND ACCESSORIES AND SUPPLIES
air con - products |  |  | air c | AIR CONDITIONERS
Spreadsheet: 855641d1705148311-spreadsheet-function-to-calculate-the-shortest-amount-of-time-for-a-set-of-occurences-magic-spells-calculations
Sheet: Arkusz1

 | cast 1 | cast 2 | cast 3 |  | required total | 6
cooldown | 12 | 18 | 25
initial sentence (1 at t=0, 2 at t=1 and 3 at t=2) | 2 | 1 | 3
times used | 3 | 2 | 1 |  | total used
really finished |  |  |  |  | finished all
Spreadsheet: 836364d1689312370-provide-last-user-ignoring-blanks-except-if-only-data-catz-example-hd-2-
Sheet: Logins

Device SN | User | Date/time |  |  | DESIRED RESULTS: Unique SN | DESIRED RESULTS: Last user | DESIRED RESULTS: Last login time
sn1 |  | 2023-06-25 00:00:00 |  | [NAME] of Glenn |  | u1 | 2023-06-24 00:00:00
sn1 | u1 | 2023-06-24 00:00:00 |  |  | sn2 | u3 | 2023-06-21 15:13:00
sn1 | u1 | 2023-06-23 13:42:00 |  |  | sn3 | u2 | 2023-06-16 00:00:00
sn1 | u2 | 2023-06-22 00:00:00 |  |  | sn4 | No User ID | 2023-06-25 00:00:00
sn2 | u3 | 2023-06-21 15:13:00 |  |  | sn5 | u5 | 2023-06-21 13:05:00
sn2 | u3 | 2023-06-20 04:20:00 |  |  | sn6 | u6 | 2023-06-20 00:00:00
sn2 | u3 | 2023-06-19 05:15:00 |  |  | sn7 | u7 | 2023-07-02 20:00:00
sn2 | u3 | 2023-06-18 08:37:00
sn2 | u3 | 2023-06-17 16:01:00 |  | Expected results | sn1 | u1 | 06/24/2023 00:00
sn3 |  | 2023-06-16 00:00:00 |  |  | sn2 | u3 | 06/21/2023 15:13
sn3 | u2 | 2023-06-16 00:00:00 |  |  | sn3 | u2 | 06/16/2023 00:00
sn3 | u3 | 2023-06-14 12:14:00 |  |  | sn4 | no user information available | 06/13/2023 11:57
sn4 |  | 2023-06-13 11:57:00 |  |  | sn5 | u4 | 06/22/2023 13:20
sn4 |  | 2023-06-22 13:20:00 |  |  | sn6 | u6 | 06/20/2023 00:00
sn5 | u5 | 2023-06-21 13:05:00 |  |  | sn7 | u7 | 2023-02-07 20:00:00
sn5 | u4 | 2023-06-12 14:00:00
sn6 | u6 | 2023-06-20 00:00:00 |  | [NAME] HD |  | u1 | 2023-06-24 00:00:00
sn7 | u7 | 2023-07-02 20:00:00 |  |  | sn2 | u3 | 2023-06-21 15:13:00
sn7 |  | 2023-07-02 19:59:00 |  |  | sn3 | u2 | 2023-06-16 00:00:00
 |  |  |  |  | sn4 | No User ID | 2023-06-13 11:57:00
 |  |  |  |  | sn5 | u5 | 2023-06-21 13:05:00
 |  |  |  |  | sn6 | u6 | 2023-06-20 00:00:00
 |  |  |  |  | sn7 | u7 | 2023-07-02 20:00:00
Spreadsheet: 841e60c5-9eb5-4b8d-8448-d505a1edc246
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
GRW | Test | GRW | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GRW | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GRW | Result | GRW | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6124-2
Spreadsheet: 880819d1728658671-creating-a-grid-of-combined-scores-with-a-twist-combined-scores-grid
Sheet: People

Name | L/R | Score |  | Name | Score vs L | Score vs R
[NAME] | L | 43 |  | Rita | 13 | 45
[NAME] | L | 54 |  | Serena | 7 | 44
[NAME] | R | 23 |  | [NAME] | 65 | 32
[NAME] | R | 22 |  | [NAME] | 43 | 12
Grant | L | 11 |  | [NAME] | 21 | 13
[NAME] | L | 75 |  | Marge | 87 | 15
[NAME] | L | 66 |  | Fran | 56 | 65
[NAME] | L | 43 |  | [NAME] | 21 | 43
[NAME] | R | 19 |  | Veronica | 34 | 18
[NAME] | R | 76 |  | Kathy | 11 | 65
[NAME] | L | 23 |  | Rebecca | 54 | 43
Walter | R | 12 |  | [NAME] | 65 | 11
[NAME] | L | 11 |  | Amanda | 12 | 21
Pablo | R | 78 |  | [NAME] | 76 | 45
Spreadsheet: 85799d1285839722-add-up-values-of-a-specific-month-based-on-status-copy-of-sum-20of-20values-1-
Sheet: Sheet1

Date | Value | Status
2010-09-01 00:00:00 | 27.8784 | OK
2010-03-08 00:00:00 | 138.24 | NOK
2010-03-01 00:00:00 | 28.8 | NOK |  | Sum of value/month | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
2009-12-20 00:00:00 | 4.32 | OK |  | Total Sum
2010-04-30 00:00:00 | 3.6864 | NOK |  | OK | 5.248200000000001 | 98.66999999999999 | 128.6532 | 0 | 76.9984 | 489.8307 | 0 | 32.121 | 27.9752 | 142.4704 | 73.853 | 61.36
2010-01-29 00:00:00 | 7.2 | NOK |  | NOK | 129.985 | 192.8514 | 169.3 | 270.9457 | 46.23 | 237.6843 | 12.1 | 216.296 | 100.7712 | 80.5 | 0 | 244.6733
2010-06-07 00:00:00 | 197.298 | OK
2010-06-10 00:00:00 | 81.36 | NOK
2010-03-30 00:00:00 | 2.26 | NOK
2010-03-30 00:00:00 | 10.8932 | OK
2010-06-10 00:00:00 | 41.22239999999999 | OK
2010-06-14 00:00:00 | 116.39 | OK
2010-09-05 00:00:00 | 24.86 | NOK
2010-10-30 00:00:00 | 142.4704 | OK
2010-06-14 00:00:00 | 18.165 | OK
2010-08-01 00:00:00 | 8.65 | OK
2010-08-01 00:00:00 | 8.65 | OK
2010-08-01 00:00:00 | 8.65 | NOK
2010-08-01 00:00:00 | 8.65 | NOK
2010-08-01 00:00:00 | 8.65 | OK
2010-04-30 00:00:00 | 232.5293 | NOK
2009-12-21 00:00:00 | 12.7413 | NOK
2010-08-30 00:00:00 | 6.170999999999999 | OK
2010-07-30 00:00:00 | 12.1 | NOK
2010-09-01 00:00:00 | 0.0968 | OK
2010-09-01 00:00:00 | 2.5102 | NOK
2010-01-04 00:00:00 | 2.7412 | OK
2010-02-12 00:00:00 | 121.3674 | NOK
2010-09-01 00:00:00 | 16.016 | NOK
2010-06-01 00:00:00 | 14.322 | OK
2010-06-01 00:00:00 | 83.3294 | NOK
2010-06-01 00:00:00 | 37.1756 | NOK
2010-05-02 00:00:00 | 2.2484 | OK
2010-06-01 00:00:00 | 12.8193 | NOK
2010-01-04 00:00:00 | 7.785 | NOK
2010-06-01 00:00:00 | 93.26429999999999 | OK
2010-06-01 00:00:00 | 9.169 | OK
2009-11-20 00:00:00 | 73.853 | OK
2010-02-12 00:00:00 | 71.484 | NOK
2010-02-25 00:00:00 | 19.32 | OK
2010-02-12 00:00:00 | 79.35 | OK
2010-12-15 00:00:00 | 46.92 | OK
2009-12-14 00:00:00 | 10.12 | OK
2010-09-19 00:00:00 | 11.385 | NOK
2010-12-09 00:00:00 | 5.52 | NOK
2010-05-20 00:00:00 | 5.75 | OK
2010-10-01 00:00:00 | 80.5 | NOK
2010-06-28 00:00:00 | 23 | NOK
2010-05-15 00:00:00 | 69 | OK
2010-08-31 00:00:00 | 198.996 | NOK
2010-01-27 00:00:00 | 2.507 | OK
2010-12-15 00:00:00 | 86.34199999999998 | NOK
2010-03-20 00:00:00 | 34.5 | OK
2010-04-16 00:00:00 | 34.73 | NOK
2010-05-03 00:00:00 | 46.23 | NOK
2010-03-11 00:00:00 | 48.3 | OK
2010-09-30 00:00:00 | 46 | NOK
2010-12-15 00:00:00 | 22.77 | NOK
2010-03-23 00:00:00 | 34.96 | OK
2010-01-30 00:00:00 | 115 | NOK
2009-12-10 00:00:00 | 117.3 | NOK
Spreadsheet: barry_tycholiz__847__2002 Plan Worksheet CC107321
Sheet: HC Load

 |  | COMPANY NUMBER: |  |  |  |  | HYPERION ENTITY:
 |  | R/C NUMBER: |  |  |  |  | HYPERION CATEGORY: | PLAN2000
 |  | R/C NAME: |  |  |  |  | HYPERION FREQUENCY: | M.PER
 |  | R/C OWNER: |  |  |  |  | HYPERION APPLICATION: | ECT
 | STAFFING SUMMARY |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
EXECUTIVE_CAP | Executive
DIRECTOR_CAP | Director
MANAGER_CAP | Manager
EXECUTIVE_NC_CAP | Non-Commercial Executive
DIRECTOR_NC_CAP | Non-Commercial Director
MANAGER_NC_CAP | Non-Commercial Manager
ASSOCHC_CAP | Associates
ALYSTHC_CAP | Analysts
OTHER_HC_CAP | Other Commercial
OTHER_NC_HC_CAP | Other Non Commercial
ADMIN_ASST_CAP | Administrative Asst.
 | Subtotal Employee Headcount
CONTHC_CAP | Contractors
 | TOTAL HEADCOUNT