tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758458d1638885338-calculate-the-hourly-difference-between-the-first-time-two-status-have-been-triggered-test-data-example
Sheet: Sheet1

Application  ID | Status | Status Date/Time | time difference
40647563 | Affordability Incomplete | 04/05/2021 13:11:00
40647563 | Affordability Product Incomplete | 04/05/2021 13:32:00
40647563 | Affordability Referred | 04/05/2021 13:32:00
40647563 | Affordability Manual Assessment | 04/05/2021 13:33:00
40647563 | Affordability Accepted | 04/05/2021 13:34:00
40647563 | App incomplete | 04/05/2021 13:34:00
40647563 | App referred | 04/05/2021 22:14:00
40647563 | App Manual Assessment | 05/05/2021 10:24:00
40647563 | App accepted | 05/05/2021 10:25:00
40647563 | App Manual Assessment | 05/05/2021 10:25:00
40647563 | Awaiting documents | 05/05/2021 10:33:00
40647563 | Application awaiting QA | 12/05/2021 15:19:00
40647563 | App Manual Assessment | 13/05/2021 15:34:00
67434572 | Affordability Incomplete | 11/06/2021 12:28:00
67434572 | Affordability Product Incomplete | 11/06/2021 14:04:00
67434572 | Affordability Offered | 11/06/2021 14:09:00
67434572 | Affordability Referred | 11/06/2021 14:17:00
67434572 | Affordability Incomplete | 11/06/2021 14:36:00
67434572 | Affordability Product Incomplete | 11/06/2021 15:16:00
67434572 | Affordability Offered | 11/06/2021 15:16:00
67434572 | Affordability Incomplete | 11/06/2021 15:17:00
67434572 | Affordability Product Incomplete | 11/06/2021 15:17:00
67434572 | Affordability Offered | 11/06/2021 15:17:00
67434572 | Affordability Referred | 11/06/2021 15:23:00
67434572 | Affordability Manual Assessment | 11/06/2021 15:34:00
67434572 | Affordability Accepted | 11/06/2021 15:34:00
67434572 | Affordability Incomplete | 11/06/2021 15:40:00
67434572 | Affordability Product Incomplete | 11/06/2021 16:06:00
67434572 | Affordability Offered | 11/06/2021 16:06:00
67434572 | Affordability Referred | 11/06/2021 16:06:00
67434572 | Affordability Manual Assessment | 11/06/2021 16:13:00
67434572 | Affordability Accepted | 11/06/2021 16:13:00
67434572 | App incomplete | 11/06/2021 16:23:00
67434572 | App referred | 11/06/2021 16:48:00
67434572 | App Manual Assessment | 11/06/2021 16:57:00
67434572 | App accepted | 14/06/2021 09:50:00
67434572 | App Manual Assessment | 14/06/2021 09:50:00
67434572 | Awaiting documents | 14/06/2021 10:02:00
67434572 | App not proceeding | 16/09/2021 12:28:00
Spreadsheet: 824559d1680670606-dynamically-move-cell-value-when-adjacent-cell-is-sorted-sample
Sheet: Sheet1

Input | Process? | Input | Process?
lima | Y | alfa | Y
zulu | N | betta | N
sierra | N | hotel | Y
whiskey | Y | india | N
november | N | lima | Y
oscar | Y | november | N
india | N | oscar | Y
hotel | Y | sierra | N
alfa | Y | whiskey | Y
betta | N | zulu | N
Spreadsheet: 837554d1690236769-excel-non-vba-code-create-a-formula-that-looks-up-multiple-values-total-team-score-formula-error-2
Sheet: Sheet2

Individual Scores
Player 1 | 90
Player 2 | 91
Player 3
Player 4 | 95
Player 5 | 66
Player 6 | 91
Player 7 | 89
Player 8 | 82
Player 9 | 94
Player 10 | 85
Player 11 | 92
Player 12 | 96
Spreadsheet: 887509d1737732518-pulling-data-into-invoice-spreadsheet-samples
Sheet: Invoice

xxx |  |  |  | INVOICE
xxx
xxx
xxx
 |  |  |  |  |  |  | Invoice #: |  | AGJP012
 |  |  |  |  |  |  | Invoice Date:
 |  |  |  |  |  |  | Amount Due:
[NAME] To: |  |  |  |  |  |  | Ship To:
Due Date |  | Terms
 |  | Net 30
Item |  | Description |  |  | Quantity |  | Price | Amount
 |  |  |  |  |  |  | Subtotal:
 |  |  |  |  |  |  | Sales Tax: |  | 0
 |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  | Payments: |  | 0
 |  |  |  |  |  |  | Amount Due:
Popcorn for the People is a trademark name under the non-profit Let's Work for Good 501c(3) popcornforthepeople.com
Spreadsheet: 825030d1681056079-array-formula-keep-using-the-1st-row-as-reference-formula-help-array
Sheet: Data

Asset Category | Asset Name | Asset Number | Region / Location | Rate (%) | Dep Start Date | Dep End Date | Per day | No Days | Purchased Date | Purchased Cost | Residual value
Car | Hyundai [NAME] | C-BKK-001 | HEADQUATERS | 0.2 | 2021-01-14 00:00:00 | 2026-01-13 00:00:00 | 383.8986856516977 | 1825 | 2021-01-14 00:00:00 | 701000 | 1
Car | Hyundai H-1 ฮย4569 | C-BKK-002 | HEADQUATERS | 0.2 | 2021-01-14 00:00:00 | 2026-01-13 00:00:00 | 398.0279299014239 | 1825 | 2021-01-14 00:00:00 | 726800 | 1
Computer Equipment | AC164-NB ACER Nitro AN515-57-7083 | OE-BKK657 |  | 0.2 | 2022-01-27 00:00:00 | 2027-01-26 00:00:00 | 17.23748083242059 | 1825 | 2022-01-27 00:00:00 | 31476.64 | 1
Computer Equipment | AC164-NB ACER Nitro AN515-57-7083 | OE-BKK658 |  | 0.2 | 2022-01-27 00:00:00 | 2027-01-26 00:00:00 | 17.23748083242059 | 1825 | 2022-01-27 00:00:00 | 31476.64 | 1
Computer Equipment | AC164-NB ACER Nitro AN515-57-7083 | OE-BKK659 |  | 0.2 | 2022-01-27 00:00:00 | 2027-01-26 00:00:00 | 17.23748083242059 | 1825 | 2022-01-27 00:00:00 | 31476.64 | 1
Computer Equipment | AC164-NB ACER Nitro AN515-57-7083 | OE-BKK656 |  | 0.2 | 2022-01-27 00:00:00 | 2027-01-26 00:00:00 | 17.23748083242059 | 1825 | 2022-01-27 00:00:00 | 31476.64 | 1
Furniture and Fixetures | [NAME] | FT-AT-0001 | Automall | 0.2 | 2021-01-31 00:00:00 | 2026-01-30 00:00:00 | 147.5898138006572 | 1825 | 2021-01-31 00:00:00 | 269500 | 1
Furniture and Fixetures | ตู้ออฟฟิศ พร้อมห้องน้ำในตัว | OE-BKK728 |  | 0.2 | 2021-10-04 00:00:00 | 2026-10-03 00:00:00 | 76.67031763417306 | 1825 | 2021-10-04 00:00:00 | 140000 | 0
Office - Equipment | Office - Equipment | OE-BKK192 | HEADQUATERS | 0.2 | 2021-06-17 00:00:00 | 2026-06-16 00:00:00 | 24.6434830230011 | 1825 | 2021-06-17 00:00:00 | 45000 | 1
Office - Equipment | Office - Equipment | OE-UBN-0003 | UBONRATCHATANI Region | 0.2 | 2019-02-04 00:00:00 | 2024-02-03 00:00:00 | 1.918767798466594 | 1825 | 2019-02-04 00:00:00 | 3504.67 | 1
Office - Equipment | Office - Equipment | OE-BKK-0036 | HEADQUATERS | 0.2 | 2019-04-21 00:00:00 | 2024-04-20 00:00:00 | 8.147590361445783 | 1825 | 2019-04-21 00:00:00 | 14878.5 | 1
Office - Equipment | Office - Equipment | OE-BKK-0035 | HEADQUATERS | 0.2 | 2019-04-01 00:00:00 | 2024-03-31 00:00:00 | 2.190032858707557 | 1825 | 2019-04-01 00:00:00 | 4000 | 1
Office - Equipment | Office chair | OE-BKK-74 |  | 0.2 | 2021-02-28 00:00:00 | 2026-02-27 00:00:00 | 10.36374589266156 | 1825 | 2021-02-28 00:00:00 | 18925.2 | 1
Spreadsheet: 824416d1680563372-help-to-write-macro-that-pulls-dates-from-sheet1-and-highlights-related-cells-in-sheet2-resource-tracker1
Sheet: Project Schedules

 |  | 2023-04-03 00:00:00
Jaguar | Adam
Lion | [NAME]
Elephant | [NAME]
Alligator | [NAME]
[NAME] and Condtional Formatting:
 | Adam
Lion | [NAME]
Elephant | [NAME]
Alligator | [NAME]
Badger | [NAME]
Hawk | Gina
Spreadsheet: 93304e5f-9993-42dc-b6e2-4b9fca7b8b95
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0029475 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Sterling Farms WWTF | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Onslow | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 31616 | 00610 | 00620 | 00400 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Chloride | Fecal Coliform | Ammonia | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mg/L | mg/L | NTU
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Composite | Grab | Composite | Composite | Grab | Composite | Composite | Recorder
Monthly Limit: |  |  | 135000 | 10 |  | 14 | 4 |  |  |  | 5
Daily Limit: |  |  |  | 15 |  | 25 | 6 |  | 6-9 |  | 10 | 10
Sample Frequency: |  |  | [NAME] | 2 x Month | 3 x Year | 2 x Month | 2 x Month | 2 x Month | 5 x Week | 3 x Year | 2 x Month | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 59363d1259855090-auto-fill-cells-based-on-value-entered-in-first-cell-schoolquestions
Sheet: GR 7 MTH

FCAT 7th Gr. MATH | DIS 09 | FY09 | FY08 | FY07 | ANALYZE PERFORMANCE; STRATEGIZE  SCHOOL IMPROVEMENT ANALYZE Prior SCHOOL/TEACHER Scores  Declines = Prof. [NAME]., Teaming, Support ANALYZE CURRENT AYP GOALS/SubGroups,  CURRENT Students' Prior Scores, TEST CONTENT  = Target Students, Instructional Focus,  [NAME], RtI
% ≥ Level 3 | 59 | 74 | 72 | 74
NUMBERS (20%) | 56 | 63 | 61 | 65
GEOMETRY (20%) | 47 | 53 | 61 | 66
MSRMNT (20%) | 60 | 68 | 63 | 58
ALGEBRA (18%) | 59 | 67 | 62 | 62
PBLTY/DT ANLYS(20%) | 69 | 76 | 76 | 68
 | Population | PP | PNP | AYP/SH | AYP/SH # | PT | PNT | AT RISK | AYP RISK | SH RISK
TOTAL | 377 | 221 | 122
WHITE | 229 | 156 | 54
BLACK
HISPANIC | 100 | 45 | 47
ASIAN
AM IND
ECON DISADV | 141 | 62 | 62
ELL
 | 39 | 10 | 19
ENTER  DATA  IN  BLUE CELLS  (only) | ENTER  CURRENT #  of students  in  grade level in each subgroup | ENTER  # of current students in grade level who tested previously  &  showed proficiency | ENTER  #  of current students in grade level who tested  previously  &  DID NOT  show proficiency | %  current students  to show proficiency to  make  AYP | #  current students  to show proficiency to  make  AYP | # students who were previously tested in this grade level in each subgroup appears auto-matically | # students who were not previously tested  in this grade level  in each subgroup appears auto-matically | AT RISK  # of current students who  DID NOT previously  test or  DID NOT  show proficiency | AYP RISK  # of current  AT RISK students to show proficiency to make  AYP | SAFE HARBOR RISK       # of current  AT RISK  students  to show proficiency to  make  SAFE  HARBOR
QUESTIONS: 1. IDENTIFY: Who are these students?  Who are their teaching teams? 2. TARGET: Which of these students show the most potential for achievement and readiness  for development? (diagnostic tests, formative assessments, gain scores, anecdotal records)  3. STRATEGIZE: Which of them affect the most AYP subgroup categories? 4. FOCUS: With which (sub)content areas do the students struggle? Can instruction be focused  to help them overcome those challenges? With which (sub)content areas do the students show the most progress? Can cooperative groups, study buddies, and peer tutoring be implemented  to benefit learning?  5. MONITOR: What are their progress monitoring activities? What are their baseline scores?  What data chats are scheduled throughout the year?  What progress charts will the students develop and monitor?
Spreadsheet: 834635d1687959598-need-max-values-from-separated-cells-multiple-sheets-workout-log-sample
Sheet: Exercises

[NAME] | [NAME] | [NAME] | Horizontal Pull | Vertical Push | Vertical Pull | Bonus
Barbell Squat | Barbell Hip Thrust | Barbell Bench Press | Inverted Barbell Row | Barbell Push Press | Pull Up | Dumbbell Bicep Curl
Dumbbell Squat | Romanian Dead-Lift | Dumbell Bench Press | Inverted Dumbbell Row | Dumbbell Push Press | Chin Up | Barbell Bicep Curl
Front Squat | Good Morning | Incline Barbell Bench Press | [NAME] | Barbell Overhead Press | Seated Lat Pull Down - Wide Grip | Cable Bicep Curl
Goblet Squat | Cable Pull-Through | [NAME] Bench Press | [NAME] | Dumbbell Push Press | Seated Lat Pull Down - Narrow Grip | Tricep Cable Pull Down
[NAME] | Reverse Back Extension | Decline Barbell Bench Press | Seated Cable Row | Dumbbell Arnold Press | Seated Lat Pull Down - Underhand Grip | Tricep Dumbbel Kickback
High Step Ups | Conventional Barbell Deadlift | [NAME] Bench Press | Kneeling Single-Arm Cable Row |  | [NAME] | [NAME]
Dumbbell Walking Lunges | Sumo Barbell Deadlift | High Cable Cross-Over | Face Pulls
Barbell Walking Lunges | Single [NAME] RDL | Dumbbell Flys - Flat | Barbell Bent Over Row
Leg Extensions | Back Extension | [NAME] | Dumbbell Bent Over Row
Barbell Reverse Lunge |  | Push Up | [NAME]
Dumbbell Reverse Lunge |  | Dumbbell Pullover
[NAME]
Pistol Squat
Barbell Sumo Squat
Standing Leg Extensions
5
10
Spreadsheet: 77668d1278084167-excel-2007-conditional-format-junesample-1-
Sheet: Sheet1

GL CODE | CARD # | DRIVER | VEH ID | ODO | MPG | DATE | TIME | CITY | STATE | PRODUCT | QUANTITY | PRICE | TOTAL
002Z | 6792083 | [NAME] | 563 | 150300 | 14.4 | 40338 | 819 | SAN LEANDRO | CA | ULN | 19.535 | 2.736199744 | 58.66
002Z | 6792083 | [NAME] | 563 | 154800 |  | 40339 | 909 | SAN LEANDRO | CA | ULN | 10.551 | 2.752599526 | 31.87
002Z | 6792083 | [NAME] | 563 | 150794 |  | 40343 | 714 | SAN LEANDRO | CA | ULN | 22.637 | 2.740399779 | 68.08
002Z | 6792083 | [NAME] | 563 | 151023 | 15 | 40344 | 1035 | SAN LEANDRO | CA | ULN | 15.237 | 2.739799671 | 45.82
002Z | 6792083 | [NAME] | 563 | 151241 | 14.5 | 40346 | 859 | SAN LEANDRO | CA | ULN | 14.956 | 2.8277 | 46.41
002Z | 6792083 | [NAME] | 563 | 151620 | 15.1 | 40347 | 1514 | SAN LEANDRO | CA | ULN | 8.272 | 2.8185 | 25.58
002Z | 6792083 | [NAME] | 563 | 151495 | 14.7 | 40347 | 837 | SAN LEANDRO | CA | ULN | 17.194 | 2.8185 | 53.18
002Z | 6792083 | [NAME] | 563 | 152022 | 18.1 | 40350 | 918 | SAN LEANDRO | CA | ULN | 22.151 | 2.822399774 | 68.62
002Z | 6792083 | [NAME] | 563 | 152296 | 14.3 | 40352 | 958 | SAN LEANDRO | CA | ULN | 19.149 | 2.837399738 | 59.63
002Z | 6792083 | [NAME] | 563 | 152840 | 14.6 | 40354 | 1313 | BUTTONWILLOW | CA | ULN | 20.752 | 2.85889 | 64.22
002Z | 6792083 | [NAME] | 563 | 152535 | 14.5 | 40354 | 620 | SAN LEANDRO | CA | ULN | 16.4 | 2.8458 | 51.22
002Z | 6792083 | [NAME] | 563 | 153083 | 13.3 | 40357 | 849 | SAN LEANDRO | CA | ULN | 18.258 | 2.8755 | 57.62
002Z | 6792083 | [NAME] | 563 | 153380 | 14.5 | 40359 | 1045 | SAN LEANDRO | CA | ULN | 20.462 | 2.8003 | 62.89
002Z | 6792083 | [NAME] | 4309 | 150017 |  | 40337 | 817 | SAN LEANDRO | CA | ULN | 13.246 | 2.7106 | 39.4
 | 6792083 Total |  |  |  |  |  |  |  |  |  |  |  | 733.2
002Z | 6342770 | [NAME] | 7554 | 1 |  | 40333 | 1652 | CONCORD | CA | ULN | 20.045 | 2.81083975 | 61.55
002Z | 6342770 | [NAME] | 7554 | 1 |  | 40340 | 1031 | CONCORD | CA | ULN | 19.475 | 2.761739743 | 58.75
002Z | 6342770 | [NAME] | 7554 | 1 |  | 40346 | 933 | CONCORD | CA | ULN | 21.056 | 2.83344 | 65.18
002Z | 6342770 | [NAME] | 7554 | 1 |  | 40354 | 537 | CONCORD | CA | ULN | 27.148 | 2.85154 | 84.57
 | 6342770 Total |  |  |  |  |  |  |  |  |  |  |  | 270.05
00FS | 5443908 | [NAME] | 0 | 0 |  | 40331 | 532 | SAN LEANDRO | CA | DFN | 31.046 | 2.274959935 | 91.38
00FS | 5443908 | [NAME] | 0 | 0 |  | 40331 | 533 | SAN LEANDRO | CA | DFN | 21.615 | 2.274959768 | 63.62
 | 5443908 Total |  |  |  |  |  |  |  |  |  |  |  | 155
00FS | 5443138 | [NAME] | 0 | 0 |  | 40330 | 1046 | SAN LEANDRO | CA | DFN | 38.041 | 2.305860078 | 113.26
00FS | 5443138 | [NAME] | 0 | 0 |  | 40330 | 1046 | SAN LEANDRO | CA | DFN | 41.767 | 2.305860024 | 124.36
00FS | 5443138 | [NAME] | 0 | 192886 |  | 40351 | 932 | WES | CA | DFN | 85.19 | 2.49521 | 268.14
 | 5443138 Total |  |  |  |  |  |  |  |  |  |  |  | 505.76
Spreadsheet: 824399d1680543214-comparing-two-lists-with-multiple-columns-lists
Sheet: Sheet4

17 | 13 | Laplante | [NAME] | v
 | 13 | Angers-Trottier | Anne-Marie | v
17 | 13 | Belvedere | Calista | v
17 | 13 | Belvedere | [NAME] | v
17 | 13 | Hudon | Sandra | v
17 | 13 | [NAME] | Sylvie | v
17 | 13 | [NAME] | Alain | v
 | 13 | Charbonneau | [NAME] | v
17 | 13 | Lafleur | [NAME]
17 | 13 | Lafleur | [NAME]
 |  | Amal | Diabi
17 |  | Dupont | [NAME]
 |  | George | hebert
Spreadsheet: 94879d1294653749-excel-2007-format-error-timesheet
Sheet: SUMMARY SHEET

 | Abbeyfield Payroll Information
 | House Name |  |  |  |  | Month
 | House number |  |  |  |  | Year
 | Region
 | Name | Payroll No | Job Title | Basic Salary (£) | Basic Hours | Days | Overtime | Nights/Sleeps | Call Outs | Bank Holiday | [NAME] | Cleaning | Gardening |  | Comments
 | Authorised by: |  |  |  |  | Date:
 | payroll
 | Yes
 | No
Spreadsheet: 5a4f4735-0787-4d31-abda-21d39f911424
Sheet: Sheet1

 | 2012년 월별 약가협상 완료약품 현황(합의기준)
 | 구분 | 약품수 | 약품명(제약사명) | 협상완료일 | 등재가격(6월기준)
 | 계 | 39
 | 1월 | 4 | 허셉틴주 150mg(한국로슈) | 2012.1.5 | 590453
 |  |  | 페가시스프리필드135㎍(한국로슈) | 2012.1.5 | 174025
 |  |  | 페브릭정80mg(SK케미칼) | 2012.1.16 | 618
 |  |  | 심발타캡슐30mg(한국릴리) | 2012.1.27 | 753
 | 2월 | 1 | 아자사이트점안액(신풍제약) | 2012.2.2 | 980
 | 3월 | 14 | 스트라이셀정50mg(한국비엠에스제약) | 2012.3.9 | 44950
 |  |  | 카비드츄어블정(나이코메드코리아) | 2012.3.9 | 86
 |  |  | 솔코린점안액(한림제약) | 2012.3.9 | 601
 |  |  | 콤비신주3g(산성제약공업) | 2012.3.12 | 7739
 |  |  | 나자코트비액(사노피-아벤티스코리아) | 2012.3.12 | 13220
 |  |  | 삼아리도맥스로션(삼아제약) | 2012.3.12 | 159
 |  |  | 티오크라주1.6g(삼성제약공업) | 2012.3.12 | 5846
 |  |  | 트리손키드주사(유케이케이팜) | 2012.3.12 | 124780
 |  |  | 스텔라라프리필드45mg(한국얀센) | 2012.3.16 | 2655000
 |  |  | 스텔라라프리필드90mg(한국얀센) | 2012.3.16 | 3982500
 |  |  | 인베가서방정9mg(한국얀센) | 2012.3.29 | 3974
 |  |  | 후콜리스티메테이트주(서울메디칼) | 2012.3.30 | 38000
 |  |  | 유트로핀플러스주9mg(엘지생명과학) | 2012.3.30 | 48120
 |  |  | 애니코프캡슐300mg(안국약품) | 2012.3.30 | 190
 | 4월 | 4 | 피라맥정(신풍제약) | 2012.4.9 | 등재전
 |  |  | 비잔정(바이엘코리아) | 2012.4.9 | 등재전
 |  |  | [NAME]) | 2012.4.9 | 등재전
 |  |  | 에피언트10mg(한국릴리) | 2012.4.9 | 등재전
 | 5월 | 16 | 트라젠타정(한국베링거잉겔하임) | 2012.5.14 | 831
 |  |  | 온브리즈흡입용150㎍(한국노바티스) | 2012.5.14 | 등재전
 |  |  | 온브리즈흡입용300㎍(한국노바티스) | 2012.5.14 | 등재전
 |  |  | 에먼드Ⅳ150mg(한국엠에스디) | 2012.5.14 | 등재전
 |  |  | 콜론라이트산(드림파마) | 2012.5.14 | 6149
 |  |  | 콜론라이트산2ℓ(드림파마) | 2012.5.14 | 3602
 |  |  | 코리트산(태준제약) | 2012.5.14 | 6082
 |  |  | 코리트산2ℓ(태준제약) | 2012.5.14 | 3098
 |  |  | 코리트에프산2ℓ(태준제약) | 2012.5.14 | 3674
 |  |  | 코리트에프산4ℓ(태준제약) | 2012.5.14 | 6271
 |  |  | 센티올과립(대한뉴팜) | 2012.5.14 | 197
 |  |  | 올메텍정40mg(대웅제약) | 2012.5.15 | 948
 |  |  | 토비애즈서방정4mg(한국화이자제약) | 2012.5.15 | 1075
 |  |  | 토비애즈서방정8mg(한국화이자제약) | 2012.5.15 | 1064
 |  |  | 멀티빅무칼륨액4.5ℓ(프레제니우스메디칼케어코리아) | 2012.5.15 | 13894
 |  |  | 정장생과립 | 2012.5.18 | 152
Spreadsheet: 677437d1589360351-conditional-formatting-book1_highlight-sheet2
Sheet: Sheet2

Sl.no | Value | Name | Location | Access
1 | 2004 | [NAME] | Tower A | Serve B2 to B1
2 | 2003 | [NAME] | Tower A | Serve B2 to 4
3 | 2002 | [NAME] | Tower A | Serve B2 to 4
4 | 2009 | [NAME] | Tower A | Serve 1, 5 to 8
5 | 565 | Lindsy Kline | Tower A | Serve 1, 5 to 8
6 | 2003 | [NAME] | Tower B | Serve B1 to 10
7 | 1998 | [NAME] | Tower B | Serve B1 to 10
8 | 2004 | [NAME] | Tower B | Serve B2 to 10
9 | 565 | [NAME] | Tower B | Serve B2 to 10
10 | 2002 | [NAME] | Tower B | Serve B2 to 10
11 | 2009 | [NAME] | Tower B | Serve B2 to 10
12 | 2006 | Lindsy Kline | Tower B | Serve 1 , 4 to 10
13 | 2003 | [NAME] | Tower B | Serve B2 to 11
14 | 1998 | [NAME] | Tower B | Serve 1 , 4 to 11
Spreadsheet: 705281d1605988069-find-duplicate-rows-across-several-columns-with-conditions-and-high-light-them-testfile-1-
Sheet: Sheet1

date_received | Facility_Name | Address1 | CMS | FMID | Group | State | Staff | enrolled
2020-11-02 00:00:00 | Sunrise | 4352 regan rd | 12 | 3425 | ALF | IL | 20 | 1
2020-10-29 00:00:00 | Sunrise | 4352 regan road | 12 | 3425 | Assisted Living Facility | IL | 23 | 1
2020-11-05 00:00:00 | Packed living | 2342 Mayo rd |  |  | ALF | CA | 25 | 1
2020-11-02 00:00:00 | Packed living | 2342 Mayo rd |  |  | Other | CA | 25 | 1
2020-11-02 00:00:00 | Freedom living | 54 Jordon court | 156 | 123 | SNF | OH | 12 | 1
2020-11-02 00:00:00 | Freedom living | 54 Jordon court | 212 | 123 | SNF | OH | 12 | 1
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: NGPL

 | 52862 |  | 6828 |  | 6838
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 36628 | 36611 | -62566 | -64614 | 26856 | 27482
2 | 36686 | 36611 |  |  | 27507 | 27482
3 | 36629 | 36611 |  |  | 27519 | 27482
4 | 36620 | 36611 |  |  | 27475 | 27482 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5
6 |  |  |  |  |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7
8 |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 |  |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 2
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000 | 1.5
2002-02-28 00:00:00 |  |  |  |  |  |  | 45621
2002-03-04 00:00:00
CBS Dollars
 |  |  | 146195 |  | 338741
Spreadsheet: 880520d1728316635-return-result-based-on-two-dates-holidays
Sheet: Sheet1

 | Name | Department | Start Date | End Date |  | New Holiday |  |  | Name | Department | Start Date | End Date |  | Result | Name | Department | Start Date | End Date |  | Name | Department | Start Date | End Date |  | Name | Department | Start Date | End Date
 | A | 1 | 2024-10-07 00:00:00 | 2024-10-18 00:00:00 |  | 1 |  |  | A | 1 | 2024-01-01 00:00:00 | 2024-01-03 00:00:00 |  |  |  | 1 | 2024-10-11 00:00:00 | 2024-10-20 00:00:00 |  | F | 1 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00
 | A | 1 | 2024-01-01 00:00:00 | 2024-01-03 00:00:00 |  |  |  |  | B | 2 | 2024-03-05 00:00:00 | 2024-07-02 00:00:00
 | B | 2 | 2024-03-05 00:00:00 | 2024-07-02 00:00:00 |  |  |  |  | C | 1 | 2024-10-11 00:00:00 | 2024-10-20 00:00:00
 | C | 1 | 2024-10-11 00:00:00 | 2024-10-20 00:00:00 |  |  |  |  | D | 4 | 2024-07-18 00:00:00 | 2024-07-20 00:00:00
 | D | 4 | 2024-07-18 00:00:00 | 2024-07-20 00:00:00 |  |  |  |  | E | 3 | 2024-10-06 00:00:00 | 2024-10-10 00:00:00
 | E | 3 | 2024-10-06 00:00:00 | 2024-10-10 00:00:00 |  |  |  |  | F | 1 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00
 | F | 1 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00
Spreadsheet: 597207d1541657751-no-clue-about-groupings-and-outlines-no-clue-about-groupings-and-outlines
Sheet: Pivot Table

Row Labels
AC
Accessories
Copilot
Guide Wire Kit
[NAME]
Indeflator
Plus 30
Priority pack
DL
Balloon Dilatation Catheters
Armada 14
Armada 14 XT
Armada 18
Armada 35
Armada 35 LL
Mini TREK OTW
Mini TREK RX
NC Traveler RX
NC Trek OTW
NC Trek RX
[NAME]
Trek OTW
Trek RX
Viatrac Plus
n/a
n/a
n/a
Supera 7F (Training required)
Veripath
PC
Angiodynamics
Nevertouch
Tumescent
Venacure
Embolic Protection Devices
Accunet (Training required)
Barewire
Emboshield NAV 6 (Training required)
Peripheral Guide Wires
HT Command
HT Command 18
HT Connect
HT Spartacore
HT Steelcore
HT Supracore
HT Versacore
HT Winn
Surepath
ST
Coronary Stent
Graftmaster
Mini Vision RX
ML8
Ultra
Vision RX
[NAME]
Xience Prime
Xience PRO
Xience Pro 48
Xience PRO A
Xience PRO LL
Xience ProX
[NAME]
Xience V (India only)
Xience Xpedition
Xience Xpedition 48
Xience Xpedition 48 JAPAN
Zeta
Peripheral Stent
Absolute 35
Absolute PRO
Absolute PRO LL
Acculink (Training required)
[NAME]
Omnilink 35
[NAME]
Supera 6F (Training required)
Supera 6F OD (Training required)
Supera PRO (Training required)
XACT (Training required)
Xience Prime BTK
[NAME]
[NAME]
VC
Vessel Closure
Demo
Proglide (China only)
Proglide (Training required)
[NAME] (Training Required
Starclose SE (China only)
Starclose SE (Training required)
VR
Structural Heart
Mitraclip
Mitraclip (Training required)
[NAME] (Training required)
[NAME]
Mitraclip NT (Training required)
Mitraclip NTR (Training required)
Mitraclip Tricuspid (Training required)
Mitraclip [NAME] (Training required)
WR
ASAHI
ASAHI
ASAHI Tornus
HT Guide Wires
Allstar
HT Advance
HT Balance
HT [NAME]
HT BHW Hydro
HT BMW
HT BMW Elite
HT BMW Hydro
HT BMW Universal
HT BMW Universal II
HT Crossit
HT Floppy
HT Floppy Extra Support
HT Intermediate
HT Jet
HT Pilot
HT Powerturn
HT Progress
HT Standard
HT Traverse
HT Turntrac
HT Vektor
HT Whisper
Iron man
S'Port
Wiggle
Peripheral Guide Wires  (Check!)
HT Versaturn
Grand Total