tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38785d1236930554-need-help-with-complex-conditional-counting-from-multiple-columns-please-help-quickly-675628_fingraphics
Sheet: Sheet3

Count of Beds | Column Labels
Row Labels | 200-299 | 300-399 | 400-499 | 500-599 | 600-699 | 800-899 | 900-1000 | Grand Total
AL |  | 1 |  |  |  |  |  | 1
FL | 1 |  |  |  |  | 1 |  | 2
IN |  | 1 |  |  |  |  |  | 1
MD | 1 | 1 |  |  |  |  |  | 2
MI | 2 |  | 2 | 1 | 1 |  |  | 6
NC | 1 |  |  |  |  |  |  | 1
NJ |  | 1 |  |  |  |  |  | 1
NY |  |  |  |  |  |  | 1 | 1
OH | 2 | 2 |  |  |  |  |  | 4
PA | 2 |  |  |  |  |  |  | 2
TX |  | 2 |  | 1 | 1 |  | 1 | 5
VA |  | 1 |  |  |  |  |  | 1
WI |  | 1 |  |  |  |  |  | 1
WY | 1 |  |  |  |  |  |  | 1
Grand Total | 10 | 10 | 2 | 2 | 2 | 1 | 2 | 29
Spreadsheet: 186192d1349956783-how-to-filter-data-at-row-level-in-excel-2003-0a1_fot_1sample-file
Sheet: Sheet1

SI | Garment | Color | Date | Purchsed |  |  |  |  | Color | Purchse
1 | T-Shirt |  |  | Yes |  |  |  |  | Violet | Yes
2 | Frock |  |  | No |  |  |  |  | Indigo | No
3 | Leggings |  |  |  |  |  |  |  | Black
4 | Trouser | Indigo |  |  |  |  |  |  | Green
5 |  |  |  |  |  |  |  |  | Yellow
6 |  |  |  |  |  |  |  |  | Orange
7 |  |  |  |  |  |  |  |  | Red
8 |  |  |  |  |  |  |  |  |  | Add to column J, as many colors as you want.
9 |  |  |  |  |  |  |  |  |  | Your Validation list refreshing automatically.
10
Spreadsheet: 728950d1618831394-how-to-sumif-with-criteria-sumif-with-criteria
Sheet: Sheet1

Name | Qty | Pur / Sold | Sold / not sold | Con | Comment
a | 75 |  | Sold
a | -75
d | 75
a | 75
b | 75
b | 75
c | -75
d | 100 |  | Sold
d | -100 |  | Sold
0 | 0 |  | 0 |  | 0
a | -40 |  | Not Sold
a | -25 |  | Not Sold
b | 10 |  | Sold
c | 10 |  | Sold
c | 10 |  | Not Sold
b | -10 |  | Sold
c | -10 |  | Sold
Spreadsheet: 800055d1665476195-sum-the-total-of-3-separate-if-statements-excel-query-rev1gk
Sheet: Cashflow

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Base Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weeks
 | 2022-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Months | 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
Plant & Equipment ID | Plant No | Status | Cost Code | Activity Code | Equipment | Vendor | Total number of equipment | Mob Date | Demob Date | UOM Days, Weeks, months | Duration | # Mob/ Demob | Mob | Demob | Total Mob/Demob Cost | Unit Price | Total Unit Price | Total Price | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
PE-H-001 |  |  |  |  |  |  |  | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 |  |  |  | 0 | 0
PE-H-025
PE-H-146
PE-H-147
Spreadsheet: 199433d1355216506-how-to-copy-fill-from-another-cell-that-is-formatted-to-change-depending-on-its-formula-cf-formattinghelpexample-reply
Sheet: Sheet1

S/N | Start Date | Target/Actual | Task 1 (30%) | Task 2 (45%) | Task 3 (25%) | Total Percentage
1 | 2012-11-20 00:00:00 | Target | 2012-11-27 00:00:00 | 2012-11-29 00:00:00 | 2012-12-04 00:00:00 | 1
 |  | Actual | 2012-11-25 00:00:00 | 2012-11-29 00:00:00 | 2012-12-03 00:00:00
2 | 2012-12-01 00:00:00 | Target | 2012-12-08 00:00:00 | 2012-12-10 00:00:00 | 2012-12-15 00:00:00 | 0.3
 |  | Actual | 2012-12-07 00:00:00
3 | 2012-12-16 00:00:00 | Target | 2012-12-23 00:00:00 | 2012-12-25 00:00:00 | 2012-12-30 00:00:00 | 0
 |  | Actual
Example 1:
Date today = 11-Dec
S/N | Start Date | Target/Actual | Task 1 (30%) | Task 2 (45%) | Task 3 (25%) | Total Percentage
1 | 2012-11-20 00:00:00 | Target | 2012-11-27 00:00:00 | 2012-11-29 00:00:00 | 2012-12-04 00:00:00 | 1
 |  | Actual | 2012-11-25 00:00:00 | 2012-11-29 00:00:00 | 2012-12-03 00:00:00
2 | 2012-12-01 00:00:00 | Target | 2012-12-08 00:00:00 | 2012-12-10 00:00:00 | 2012-12-15 00:00:00 | 0.3 | An amber fill as a warning that target is the next day
 |  | Actual | 2012-12-07 00:00:00
3 | 2012-12-16 00:00:00 | Target | 2012-12-23 00:00:00 | 2012-12-25 00:00:00 | 2012-12-30 00:00:00 | 0
 |  | Actual
Example 2:
Date today = 15-Dec
S/N | Start Date | Target/Actual | Task 1 (30%) | Task 2 (45%) | Task 3 (25%) | Total Percentage
1 | 2012-11-20 00:00:00 | Target | 2012-11-27 00:00:00 | 2012-11-29 00:00:00 | 2012-12-04 00:00:00 | 1
 |  | Actual | 2012-11-25 00:00:00 | 2012-11-29 00:00:00 | 2012-12-03 00:00:00
2 | 2012-12-01 00:00:00 | Target | 2012-12-08 00:00:00 | 2012-12-10 00:00:00 | 2012-12-15 00:00:00 | 0.3 | A red fill as an alert that target is not met and task not done
 |  | Actual | 2012-12-07 00:00:00 |  |  |  | And... red fill as an alert that target is on the current day
3 | 2012-12-16 00:00:00 | Target | 2012-12-23 00:00:00 | 2012-12-25 00:00:00 | 2012-12-30 00:00:00 | 0
 |  | Actual
However, after filling up the actual dates:
S/N | Start Date | Target/Actual | Task 1 (30%) | Task 2 (45%) | Task 3 (25%) | Total Percentage
1 | 2012-11-20 00:00:00 | Target | 2012-11-27 00:00:00 | 2012-11-29 00:00:00 | 2012-12-04 00:00:00 | 1
 |  | Actual | 2012-11-25 00:00:00 | 2012-11-29 00:00:00 | 2012-12-03 00:00:00
2 | 2012-12-01 00:00:00 | Target | 2012-12-08 00:00:00 | 2012-12-10 00:00:00 | 2012-12-15 00:00:00 | 1 | Green fill to denote task completion
 |  | Actual | 2012-12-07 00:00:00 | 2012-12-15 00:00:00 | 2012-12-15 00:00:00 |  | Regardless if target is met or not
3 | 2012-12-16 00:00:00 | Target | 2012-12-23 00:00:00 | 2012-12-25 00:00:00 | 2012-12-30 00:00:00 | 0
 |  | Actual
Spreadsheet: 695539d1600269944-part-checker-and-quote-maker-test-claculator-dawondr-
Sheet: Products

Part number | Part name | Quantity | List Price | Sock Location | Our Part | Comments
A1 | Widget - Blue |  | 5 | A12 -1 | Yes
A2 | Widget - Red |  | 5 | A12 -2 | Yes
A3 | Widget - Green |  | 5 | A12 -3 | Yes
A4 | Widget - Purple |  | 5 | A12 -4 | Yes
A5 | Widget - Orange |  | 5 | A12 -5 | Yes
A6 | Widget - White |  | 5 | A12 -6 | Yes
A7 | Widget - Black |  | 5 | A12 -7 | Yes
A8 | Widget - Tan |  | 5 | A12 -8 | Yes
A9 | Widget - Brown |  | 5 | A12 -9 | Yes
A10 | Widget - Silver |  | 5 | A12 -10 | Yes
A11 | Widget - Gold |  | 5 | A12 -11 | Yes
Spreadsheet: 706e81eb-67d4-4908-b21b-31c5858fce83
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7838 | 58910 | Margriet | Uil | NED | 198 | [NAME] | 00:02:02 | 01:26:49 | 00:02:30 | 01:00:13 | 1 | 02:54:10
Spreadsheet: 756540d1637620230-retrieve-hours-worked-based-on-day-of-week-in-rota-gamersheek-rota
Sheet: July

` | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-10 00:00:00 | 2021-07-11 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-16 00:00:00 | 2021-07-17 00:00:00 | 2021-07-18 00:00:00 | 2021-07-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-22 00:00:00 | 2021-07-23 00:00:00 | 2021-07-24 00:00:00 | 2021-07-25 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-10 00:00:00 | 2021-07-11 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-16 00:00:00 | 2021-07-17 00:00:00 | 2021-07-18 00:00:00 | 2021-07-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-22 00:00:00 | 2021-07-23 00:00:00 | 2021-07-24 00:00:00 | 2021-07-25 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00
[NAME]
Scott
Adam
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: October 27 & 28  2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-10-27 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
Spreadsheet: 686919d1594873347-remove-the-tables-descriptions-and-blank-rows-for-range-of-cells-book1-1-
Sheet: SOR

 | Pay Item | Description of Work | Quantity | Unit
 | G1~JOB SPECIFIC REQUIREMENTS
 | G1P1. | New bridge 1500mm Super T (8055m2) | 953 | m2
 | G1P3. | Protection slab - Sewer 1752 x 1700mm (365m) | 496 | [NAME]
 | G1P4. | Demolition of existing bridge Grand Ave Bridge (500m2) | 395 | [NAME]
 | G1P5. | Demolition of existing Pedestrian bridge (755m2) | 216 | [NAME]
 | G1P6. | Retaining walls - Less than 2m high (900m2) - Updated quantity | 438 | [NAME]
 |  |  |  | G1~JOB SPECIFIC REQUIREMENTS
 | G2-C2~GENERAL REQUIREMENTS - MAJOR CONTRACTS  Ed 5/Rev 8
 | G2-C2P1. | Primary Testing Subcontract (Provisional Sum) 1% of Construction Costs | 566 | Provisional Sum
 | [NAME]. | WAE Drawings 1% of Construction Costs | 511 | [NAME]
 | G2-C2P3. | Wet Weather Delay Costs | 385 | Rate Only (day)
 |  |  |  | G2-C2~GENERAL REQUIREMENTS - MAJOR CONTRACTS  Ed 5/Rev 8
 | G4~PRINCIPAL'S PROJECT ACCOMMODATION Ed1 /Rev 7
 | G4P1. | Establishment of Principal's Project Accommodation | 163 | [NAME]
 | G4P2. | Maintenance of Principal's Project Accommodation until Completion | 573 | week
 | [NAME]. | Maintenance of Principal?s Project Accommodation after Completion (Item with Provisional Quality) | 486 | week
 | G4P4. | Removal of Principal's Project Accommodation | 280 | [NAME]
 |  |  |  | G4~PRINCIPAL'S PROJECT ACCOMMODATION Ed1 /Rev 7
 | G7~UTILITY ADJUSTMENT Ed1 /Rev 1
 | G7P1. | Coordination and Management of Utility Adjustment work | - | [NAME]
 | G7P6.1. | Relocate - 395m underground Electrical service | 447 | m
 | G7P7. | Engagement of Water Servicing Coordinator | 965 | [NAME]
 | G7P8. | Water Mains | 873
 | G7P8.1. | Relocate - 150mm (310m) | 57 | m
 | G7P8.2. | Relocate - 250mm (400m) | 340 | m
 | G7P8.3. | Relocate - 300mm (65m) | 484 | m
 | G7P10. | Traffic signals | 156 | [NAME]
 | G7P10.1. | Reonstruct - James Ruse / Grand / Hassall | 756 | [NAME]
 | G7P10.2. | Decommision - James Ruse / Prospect | 529 | [NAME]
 | G7P10.3. | Reconstruct - Hassall / Arthur | 195 | [NAME]
 | G7P12. | Telecommunications | 419
 | G7P12.1. | Relocate - 50mm Local service (200m) | 807 | m
 | G7P12.2. | Relocate - 35mm Local service (20m) | 442 | m
Spreadsheet: daren_farmer__6362__CES INFO
Sheet: TOMC

Purchase
 | From Kerr McGee
 | At Matagorda Island 587
 | At GDA Tetco STX+.01
Sale
 | Transported from the terminus of Tomcat
 |  | into HPL (Mtr 14940)
Term
 | Thru 4/00. Contract is being renegotiated
Deals
 | P-141125
 | S-144230
Other
 | [NAME] at CES will be moving to Kerr McGee
 |  | She will continue to handle the noms on TOMC
 |  | She will notify us of any changes/issues
 |  | [NAME]
 | Anadarko operated MI 587
 |  | [NAME] [PHONE]
 | Current volumes are about 2000 MMBtu/d
Spreadsheet: 335ce279-de0e-4358-a7c9-e0f81bddf3c3
Sheet: Sheet1

Unnamed: 0 | 국제로타리 PR 보조금 환불 양식 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 지구 #___________________________ | RI 12-13 연도
 | 담당자 성명/이메일 _________________________________  보조금 총액  _______________________ | 수령자 보고 양식 첨부  A 보고서 첨부                  A |  |  | SPA TO A/P ________________
 |  |  |  |  |  |  | 홍보 활동 자료 첨부 여부
 | 환불/신청 가능한 항목에 대해서는 보조금 승인 서신을 참조해 주십시오. 공급업체 혹은 [NAME] 서류(영수증 혹은 결제된 수표 등), 홍보 활동을 [NAME] 증명하는 자료들을 로타리안 수령자 보고 양식과 함께 제출해 주십시오. [NAME]. http://www.rotary.org/RIdocuments/ko_pdf/rits_payment_guidelines_ko.pdf
 |  |  |  |  | 영수증 첨부 여부 | [NAME]
 |  |  | 통화 | 경비 총액
 | [NAME] 내역 | 날짜
 | Office Use Only. Notes: |  | 합계 |  | 현지 통화
 |  |  | Office Use Only |  | Currency exchange rate
 |  |  |  |  | Total US$
 |  |  |  |  | [NAME] amount  (local currency)
 |  |  | TOTAL |  | TOTAL  US$ AMOUNT PAID
Spreadsheet: 71438d1272152443-run-a-data-series-through-custom-calculator-pigging-log-40-2-to-47-2-
Sheet: Gas Loss Report

Pig Log Chemical Cleaning Project I.D.145422
Run and Pig # | Date | Pig Type | Location Launched | Time Launched | Gas Controller | Time Called | Location Received | Time Received | Gas Controller | Time Called | Chemicals Injected (gal.) | Diesel Injected (gal.) | % Chemical in Solution | Total Injected | Quanity (gal.) Liquids/Solids Received in [NAME] | Liquids Accounted For | Percent Solids | Gallons of Solids | Pounds of Solids | Liquids Accounted for Including Solids | Pressure of Launcher | Pressure of Receiver | Launcher Gas Loss/MCF | Receiver Gas Loss/MCF | Vented Gas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 525 |  | 3.77
Run 1 Pig 1 | 2010-04-23 00:00:00 | 30" 5# [NAME] Pig w/Transmitter | 40-2D | 06:01:00 | [NAME] | 06:02:00 | 46-2S | 19:38:00 | [NAME] | 20:34:00 | 510 | 6800 |  |  |  |  | 0.12 |  |  |  | 560 | 545
Run 2 Pig 1 | 2010-04-24 00:00:00 | 30" 8# WB Javelina Poly Pig | 40-2D | 05:42:20 | [NAME] | 05:43:00 | 46-1S |  |  |  | 176 | 2334 |  |  |  |  |  |  |  |  | 600
Run 2 Pig 2 | 2010-04-24 00:00:00 | 30" 8# WB Javelina Poly Pig w/Transmitter | 40-2D | 07:50:10 | [NAME] | 07:55:00 | 46-1S |  |  |  | 210 | 2790 |  |  |  |  |  |  |  |  | 560
TOTALS:
Spreadsheet: 183319d1348776318-multiple-if-then-statement-book2
Sheet: Summary

Vision / Splendour Cabotage Dates
Type | Date | Class | Other |  | Type | Date | Class | Other |  | Type | Date | Class | Other
MK | 12/15/09 | C |  |  | JK | 12/03/09 | C |  |  | LO | 02/15/11 | C
MK | 12/18/09 | C |  |  | JK | 12/07/09 | C |  |  | LO | 02/21/11 | C
MK | 12/21/09 | C |  |  | JK | 12/11/09 | C |  |  | LO | 02/27/11 | C
MK | 01/03/10 | C |  |  | JK | 12/14/09 | C |  |  | LO | 03/05/11 | C
MK | 01/17/10 | C |  |  | JK | 12/18/09 | C |  |  | LO | 03/11/11 | C
MK | 01/31/10 | C |  |  | JK | 12/21/09 | C
MK | 02/28/10 | C |  |  | JK | 12/27/09 | C
MK | 03/14/10 | C |  |  | JK | 01/04/10 | C
MK | 12/12/10 | C |  |  | JK | 01/08/10 | C
MK | 12/16/10 | C |  |  | JK | 01/15/10 | C | S&S
MK | 02/14/11 | C |  |  | JK | 01/18/10 | C
MK | 02/18/11 | C |  |  | JK | 01/22/10 | C
MK | 02/21/11 | C |  |  | JK | 01/29/10 | C | S&S
MK | 02/25/11 | C |  |  | JK | 02/01/10 | C
MK | 02/28/11 | C |  |  | JK | 02/05/10 | C | S&S
MK | 03/11/11 | C |  |  | JK | 02/08/10 | C
MK | 03/14/11 | C |  |  | JK | 02/12/10 | C
MK | 03/18/11 | C |  |  | JK | 02/19/10 | C
MK | 12/09/11 | C |  |  | JK | 02/22/10 | C
MK | 12/11/11 | C |  |  | JK | 02/26/10 | C
MK | 12/15/11 | C |  |  | JK | 03/01/10 | C
MK | 12/18/11 | C |  |  | JK | 03/05/10 | C
MK | 02/12/12 | C |  |  | JK | 03/12/10 | C
MK | 03/04/12 | C |  |  | JK | 03/15/10 | C
MK | 03/25/12 | C |  |  | JK | 03/19/10 | C
MK | 03/30/12 | C |  |  | JK | 03/26/10 | C
MK | 04/02/12 | C |  |  | JK | 03/29/10 | C
MK | 04/06/12 | C |  |  | JK | 12/14/10 | C
MK | 12/09/12 | C |  |  | JK | 12/17/10 | C
MK | 12/14/12 | C |  |  | JK | 12/20/10 | C
MK | 12/17/12 | C |  |  | JK | 12/26/10 | C
MK | 12/28/12 | C |  |  | JK | 01/03/11 | C
MK | 01/19/13 | C |  |  | JK | 01/08/11 | C
MK | 02/23/13 | C |  |  | JK | 01/15/11 | C
MK | 03/08/13 | C |  |  | JK | 01/22/11 | C
MK | 03/11/13 | C |  |  | JK | 01/29/11 | C
MK | 03/22/13 | C |  |  | JK | 02/05/11 | C
MK | 04/01/13 | C |  |  | JK | 02/12/11 | C
MK | 04/05/13 | C |  |  | JK | 02/19/11 | C
MK | 04/08/13 | C |  |  | JK | 02/26/11 | C
MK | 04/19/13 | C |  |  | JK | 03/05/11 | C
 |  |  |  |  | JK | 03/12/11 | C
 |  |  |  |  | JK | 03/18/11 | C
 |  |  |  |  | JK | 03/21/11 | C
 |  |  |  |  | JK | 03/25/11 | C
 |  |  |  |  | JK | 03/28/11 | C
 |  |  |  |  | JK | 04/01/11 | C
 |  |  |  |  | JK | 12/02/11 | C
 |  |  |  |  | JK | 12/05/11 | C
 |  |  |  |  | JK | 12/09/11 | C
 |  |  |  |  | JK | 12/12/11 | C
 |  |  |  |  | JK | 12/16/11 | C
 |  |  |  |  | JK | 12/19/11 | C
 |  |  |  |  | JK | 12/23/11 | C
 |  |  |  |  | JK | 12/29/11 | C
 |  |  |  |  | JK | 01/06/12 | C
 |  |  |  |  | JK | 01/13/12 | C
 |  |  |  |  | JK | 01/27/12 | C
 |  |  |  |  | JK | 02/03/12 | C
 |  |  |  |  | JK | 02/17/12 | C
 |  |  |  |  | JK | 02/24/12 | C
 |  |  |  |  | JK | 02/27/12 | C
 |  |  |  |  | JK | 03/09/12 | C
 |  |  |  |  | JK | 03/12/12 | C
 |  |  |  |  | JK | 03/16/12 | C
 |  |  |  |  | JK | 03/19/12 | C
 |  |  |  |  | JK | 03/30/12 | C
 |  |  |  |  | JK | 04/02/12 | C
 |  |  |  |  | JK | 04/06/12 | C
 |  |  |  |  | JK | 04/09/12 | C
 |  |  |  |  | JK | 04/13/12 | C
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 348740 | 348593 | 44952 | 39832 | 34864 | 38368 | 138333 | 132994 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 326868 | 331402 | 44933 | 40489 | 36801 | 38316 | 105582 | 103708 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 327137 | 330848 | 45018 | 40410 | 34501 | 39399 | 111726 | 105510 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 327600 | 330450 | 31087 | 40426 | 42627 | 39399 | 126063 | 126994 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 305375 | 307821 | 35408 | 35617 | 42536 | 40399 | 135758 | 134714 |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 | 328360 | 331758 | 32048 | 35617 | 44703 | 37058 | 132131 | 131043 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 319506 | 320155 | 23179 | 22626 | 38348 | 37079 | 129327 | 126563 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 286158 | 281186 | 22743 | 22671 | 38426 | 40918 | 111115 | 111192 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 302691 | 299195 | 19977 | 22175 | 40192 | 40918 | 124988 | 121550 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 | 294278 | 299195 | 22860 | 22094 | 42910 | 40918 | 128025 | 125624 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 308297 | 314941 | 23014 | 21854 | 38296 | 34629 | 136518 | 133999 |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 | 323009 | 340013 | 23025 | 21500 | 48171 | 28668 | 119665 | 121497 |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 | 251547 | 255068 | 22924 | 11153 | 34346 | 29840 | 120632 | 119766 |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 | 302986 | 300798 | 23089 | 12065 | 30114 | 36168 | 118174 | 128285 |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 | 320781 | 321683 | 7129 | 11514 | 33386 | 33898 | 132774 | 133680 |  |  |  | 2001-12-04 00:00:00
16 | 294339 | 291714 |  | 4943 | 38975 | 35013 | 131155 | 131546
17 | 290904 | 293264 |  | 4862 | 36131 | 36168 | 126129 | 119066
18 | 305922 | 303311 |  | 4930 | 35067 | 35103 | 117947 | 116578
19 | 301502 | 302180 |  | 4734 | 35147 | 35103 | 120094 | 125238 |  |  |  |  |  |  | 1.98
20 |  |  |  |  |  |  |  |  |  |  |  |  | 1378106 | 1316146
21 |  |  |  |  |  |  |  |  |  |  |  |  | 9216070 | 9272400
22 |  |  |  |  |  |  |  |  |  |  |  |  | 3546065 | 3512740
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2002-01-31 00:00:00
2002-02-19 00:00:00
CBS Dollars
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Clinical Lab Phlebotomy Certs

CLINICAL LAB TECH - PHLEBOTOMY
Certificates
Physician's Office Laboratory Certificate | Semester | Grade
___ PHB 151 (1) Phlebotomy
___ PHB 152 (1) Phlebotomy Clinical Experience
___ CLT 101 Introduction to the Clinical Laboratory
OR ___ PHB 170 (3) Applied Phlebotomy
AND ___ PHB 152 (1) Phlebotomy Clinical Experience
___ CLT 111 (2) Urinalysis
___ CLT 125 (2) Serology
Phlebotomy for the Health Care Worker
___ PHB 151 (1) Phlebotomy
___ PHB 152 (1) Phlebotomy Clinical Experience
___ CLT 101 Introduction to the Clinical Laboratory
OR ___ PHB 170 (3) Applied Phlebotomy
AND ___ PHB 152 (1) Phlebotomy Clinical Experience
Advanced Phlebotomy Technician
___ PHB 151 (1) Phlebotomy
___ PHB 152 (1) Phlebotomy Clinical Experience
___ PHB 155 (2) Clinical Phlebotomy
___ CLT 101 Introduction to the Clinical Laboratory
OR ___ PHB 151 (1) Phlebotomy
AND ___ PHB 153 (4) Advanced Topics in Phlebotomy
AND ___PHB 155 (3) Phlebotomy Clinical
OR ___ PHB 170 (3) Applied Phlebotomy
AND ___ PHB 152 (1) Phlebotomy Clinical Experience
AND ___ PHB 155 Phlebotomy Clinical
Southeast Kentucky Community & Technical College | Updated Spring 2013