tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 003235ed-285a-488a-a981-d352ef1336c9
Sheet: Sheet1

Clinical Supervisor (CS)  Applicant Documentation Checklist | Unnamed: 1 | Unnamed: 2
IDAPA 16.07.20 subsection 216.02.a through f
Name:
Documentation/Licensure/Certification | Documentation to be submitted to SUD in compliance with IDAPA 16.07.20,  subsection 216.2.a | a
[NAME] | Applicant must meet all requirements of  IDAPA 16.07.20, subsection 218 prior to submitting documentation as a  clinical supervisor (instructions for documenting 1040 hours as a QSUDP is attached.)
[NAME], or | Copy of Current Certification.
Clinical License Supervisor Endorsement from IBOL, or | Copy of Current Clinical License with Supervisor  Endorsement from IBOL
Masters Degree from an accredited, approved, and recognized college or university in health and human Services. | Copy of Diploma (note, if applicant is already listed as a QSUDP on the DHW Website, this documentation should already be on file at DHW)
4 years paid FT Professional Experience | Documentation must be verified by employer for whom paid experience is being reported.
1 year Supervision Experience | Documentation must be verified by employer for whom paid experience is being reported.
Demonstrated KSA Competency in providing [NAME] | Verified by QP documentation and employer report of applicant experience
2 years experience working with adolescents & family in SUD Setting -  applies if intend to provide CS in OP Adolecent Tx Facility | Documentation must be verified by employer for whom paid experience is being reported.
NFATTC  [NAME] | Copy of Certificate of Completion.  Applicant has 180 days from date of employment to complete this training
Co-Occuring Disorders | under review - see  IDAPA 16.07.20.216.02.f  (error in rule needs to be corrected in next rules cycle)
IDAPA Website:   http://adm.idaho.gov/adminrules/rules/idapa16/0720.pdf
[NAME]
(Form created 7-8-10 -  updated 11-3-11)
Spreadsheet: 715080d1611551583-return-value-with-multiple-conditions-copie-de-forum-excel-25-jan-2021
Sheet: Archive

AR |  | BL
FT |  | YL
 | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00
 | January | February | March | April | May | June | July | August | September | October | November | December
 | FORMULA?
Spreadsheet: 112048d1308231939-gantt-chart-with-a-twist-vehicle_booking
Sheet: Sheet2

2011-07-01 00:00:00
00:00:00
Spreadsheet: 860706d1708700585-of-true-and-false-excluding-blank-cells-how-do-i-count-true-and-false-but-ignore-cells-that-have-an-embedded-forula-that-returns-a-blan
Sheet: Sheet1

 | RAW DATA |  |  |  |  |  |  | TRUE/FALSE LOGIC FOR MATCHES - RETURNS BLANK WHEN DOES NOT MEET INCLUSION CRITERIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMMARY IN % AND TOTAL COUNT OF TRUE/FALSE
Facility | Disch Disp | PT D/C Recommendations | OT D/C Recommendations | PT DARRT | OT DARRT | OT-PT Tool Time |  | [NAME], PT D/C AND OT D/C Match | [NAME] and PT Match | [NAME] and OT Match | PT and OT Match when OT-PT tool time is <48hrs | PT and OT Match when OT-PT tool time is <24hrs | PT D/C and PT DARRT Match | OT D/C and OT DARRT Match | [NAME] and PT DARRT Match | [NAME] and OT DARRT Match | [NAME] and OT DARRT Match AND OT D/C Nonmatch | [NAME] and PT DARRT Match AND PT D/C Nonmatch | All 5 agree when OT-PT tool time is <48hrs | All 5 agree when OT-PT tool time is <24hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <48hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <24hrs |  |  | [NAME], PT D/C AND OT D/C Match | [NAME] and PT Match | [NAME] and OT Match | PT and OT Match when OT-PT tool time is <48hrs | PT and OT Match when OT-PT tool time is <24hrs | PT D/C and PT DARRT Match | OT D/C and OT DARRT Match | [NAME] and PT DARRT Match | [NAME] and OT DARRT Match | [NAME] and OT DARRT Match AND OT D/C Nonmatch | [NAME] and PT DARRT Match AND PT D/C Nonmatch | All 5 agree when OT-PT tool time is <48hrs | All 5 agree when OT-PT tool time is <24hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <48hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <24hrs
 | Home | Home | Home | Home | Home | 28.14097222220153 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | Home | Home | Home | Home | Home | 22.11111111110222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True count
 | Home | Home | Home | Home | Home | 22.08611111110076 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] count
 | Home | Home | Home | Home | Home | 16.08819444439723 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | count
 | Home | Home | Home | IRF | IRF | 15.79166666670062
 | Home | Home | Home | SNF | SNF | 15.08333333340124
 | Home | Home | Home | Home | Home | 15.03194444449764
 | Home | Home | Home | Home | Home | 14.96944444449764
 | Home | Home | Home | Home | SNF | 14.96250000000146
 | Home | Home | Home | Home | Home | 14.95486111110222
 | Home | Home | Home | Home | Home | 14.20833333329938
 | Home | Home | Home | Home | Home | 14.11111111110222
 | Home | Home | Home | Home | Home | 13.27083333329938
 | Home | Home | Home | Home | Home | 13.125
 | Home | Home | Home | Home | SNF | 13.06597222229902
 | Home | Home | Home | Home | Home | 12.875
 | Home | Home | Home | Home | Home | 12.83958333329792
 | Home | SNF | SNF | SNF | SNF | 12.08333333340124
 | Home | Home | Home | Home | Home | 11.97777777779993
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 757365d1638209547-get-results-from-large-data-in-excel-book2-2
Sheet: Sheet2

Short description | Symptom | Number | Created | Assignment group
Problem with X | NA | INC98457 | 2021-01-02 00:00:00 | DUMMYWORKPLACE NL
Problem with Y | NA | INC98458 | 2021-01-03 00:00:00 | DUMMWOKRPLACE FRA
Problem with W | NA | INC98459 | 2021-01-04 00:00:00 | [NAME]
Problem with Z | NA | INC98460 | 2021-01-05 00:00:00 | DUMMWOKRPLACE FRA
Problem with D | NA | INC98461 | 2021-01-06 00:00:00 | [NAME]
Problem with B | NA | INC98462 | 2021-01-07 00:00:00 | DUMMWOKRPLACE FRA
Problem with A | NA | INC98463 | 2021-01-08 00:00:00 | DUMMYWORKPLACE NL
Problem with G | NA | INC98464 | 2021-01-09 00:00:00 | DUMMWOKRPLACE FRA
Problem with K | NA | INC98465 | 2021-01-10 00:00:00 | DUMMWOKRPLACE FRA
Problem with U | NA | INC98466 | 2021-01-11 00:00:00 | DUMMWOKRPLACE FRA
Problem with D | NA | INC98461 | 2021-01-06 00:00:00 | [NAME]
Problem with D | NA | INC98461 | 2021-01-06 00:00:00 | [NAME]
Problem with D | NA | INC98461 | 2021-01-06 00:00:00 | [NAME]
Problem with D | NA | INC98461 | 2021-01-06 00:00:00 | [NAME]
Problem with W | NA | INC98459 | 2021-01-04 00:00:00 | [NAME]
Problem with W | NA | INC98460 | 2021-01-05 00:00:00 | [NAME]
Problem with W | NA | INC98461 | 2021-01-06 00:00:00 | [NAME]
Problem with W | NA | INC98462 | 2021-01-07 00:00:00 | [NAME]
Problem with W | NA | INC98463 | 2021-01-08 00:00:00 | [NAME]
Problem with W | NA | INC98464 | 2021-01-09 00:00:00 | [NAME]
Problem with W | NA | INC98465 | 2021-01-10 00:00:00 | [NAME]
Problem with W | NA | INC98466 | 2021-01-11 00:00:00 | [NAME]
Problem with W | NA | INC98467 | 2021-01-12 00:00:00 | [NAME]
Problem with W | NA | INC98468 | 2021-01-13 00:00:00 | [NAME]
Spreadsheet: 263434d1378474747-ifvlookup-issue-ifvlookup-problem
Sheet: Input

LINE |  | CODE | QTY | CASE | HEADER LABEL | BASE LABEL | BSTO
 |  | 15024503 |  | BCD009207 | [NAME] | NA | NA
 |  | 15114329 |  | BCD008103 | BLB197102 | BLL012401 | BST193001
 |  | 15577600 |  | 0 | 0 | 0 | 0
 |  | 1557900
Spreadsheet: 764098d1642588749-dynamic-list-with-multiple-criteria-example
Sheet: Data

Code | SD | Item Code | Description
10141721 | 10 |  | Raw Mat 1
10141721 | 20 |  | Raw Mat 2
10141721 | 30 |  | Raw Mat 3
10141721 | 40 |  | Raw Mat 4
10141721 | 50 | 245895 | [NAME]
10141721 | 60 | 255478 | Stickers
10141721 | 70 | 546547 | Sleeves
10141721 | 80 | 155451 | Film
10141721 | 90 | 454554 | Sheets
10184528 | 10 |  | Raw Mat 1
10184528 | 20 |  | Raw Mat 2
10184528 | 30 |  | Raw Mat 3
10184528 | 40 |  | Raw Mat 4
10184528 | 50 | 42482 | Trays
10184528 | 60 | 454751 | Accetate
10184528 | 70 | 145425 | FIlm
10184528 | 80 | 21474 | Greaseproof Paper
10184528 | 90 | 147851 | [NAME]
10222300 | 10 |  | Raw Mat 1
10222300 | 20 |  | Raw Mat 2
10222300 | 30 |  | Raw Mat 3
10222300 | 40 |  | Raw Mat 4
10222300 | 50 | 125485 | Stickers
10222300 | 60 | 22455 | [NAME]
10222300 | 70 | 540545 | [NAME]
10222300 | 80 | 54898 | Sleeves
10222300 | 90 | 87497 | Film
10222361 | 10 |  | Raw Mat 1
10222361 | 20 |  | Raw Mat 2
10222361 | 30 |  | Raw Mat 3
10222361 | 40 |  | Raw Mat 4
10222361 | 50 | 98565 | Lids
10222361 | 60 | 450454 | Tubs
10222361 | 70 | 45487 | Boxes
10222361 | 80 | 454575 | Tape
10222361 | 90 | 457877 | Cardboard
Spreadsheet: 88843d1288681310-excel-2007-i-would-like-to-create-3-conditional-formula-excel-help
Sheet: Sheet1

User ID | Date | Start Time | End Time | Meal Allowance
ABC | 2010-10-05 00:00:00 | 06:30:00 | 07:30:00
ABC | 2010-10-05 00:00:00 | 07:30:00 | 08:00:00
ABC | 2010-10-05 00:00:00 | 19:00:00 | 20:30:00 | 5
ABC | 2010-10-08 00:00:00 | 06:30:00 | 07:30:00
ABC | 2010-10-08 00:00:00 | 19:00:00 | 20:30:00 | 5
EFG | 2010-10-05 00:00:00 | 19:00:00 | 20:30:00 | 5
EFG | 2010-10-06 00:00:00 | 19:00:00 | 20:30:00 | 5
EFG | 2010-10-07 00:00:00 | 19:00:00 | 20:30:00 | 5
Spreadsheet: 49071d1248347832-auto-count-then-auto-sum-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | Manager |  | Number of calls made |  | Applicable |  | Answered |  | willing participait |  | Average Score |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  | [NAME] |  |  |  |  |  |  |  | 2 |  | 5.5 |  |  |  |  |  | 7
 |  |  | [NAME] |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 8
 |  |  | [NAME] |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 9
 |  |  | [NAME] |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 10
Spreadsheet: 66707d1267396684-interval-jumps-between-a-min-and-max-value-book1
Sheet: Sheet1

 | Base Currency |  |  |  |  | Selected currency:
 | Euro: | 1 |  |  |  | Dollar: | 0.741 |  |  | Currency: | 1
 |  |  |  |  |  | Won: | 1000 |  |  | Dial radius: | 100
 |  |  |  |  |  | Euro: | 1 |  |  | Threshhold: | 0.3
 | Row | MIN | MAX | JUMPS |  | Row | MIN | MAX | JUMPS |  | Table
 | A | 35 | 75 | 1 |  | A |  |  |  |  | 0.005
 | B | 0.2 | 1.1 | 0.01 |  | B |  |  |  |  | 0.01
 | D | 1500 | 3800 | 100 |  | D |  |  |  |  | 0.05
 | E | 3.7 | 14.8 | 0.1 |  | E |  |  |  |  | 0.1
 | F | 3 | 5.5 | 0.1 |  | F |  |  |  |  | 0.5
 | G | 75000 | 150000 | 1000 |  | G |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 10
 | Length | Easy | [NAME] | Test |  | Length | Easy | [NAME] | Test |  | 50
 |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | 100000
 |  |  |  |  |  |  |  |  |  |  | 500000
 |  |  |  |  |  |  |  |  |  |  | 1000000
Spreadsheet: 774358d1648422376-how-to-validate-a-sum-of-data-addingcompareef
Sheet: Sheet1

Total
DURATION | START | END
 | 04:50:00 | 13:36:00
 | 05:15:00 | 15:17:00
 | 05:17:00 | 08:37:00
 | 05:30:00 | 15:36:00
 | 05:30:00 | 09:02:00
 | 05:37:00 | 09:27:00
 | 05:40:00 | 08:56:00
 | 05:46:00 | 08:02:00
 | 05:47:00 | 11:34:00
 | 05:50:00 | 08:59:00
 | 05:52:00 | 09:17:00
 | 05:52:00 | 09:56:00
 | 05:53:00 | 08:02:00
 | 05:57:00 | 10:00:00
 | 06:00:00 | 08:02:00
 | 06:02:00 | 09:39:00
 | 06:03:00 | 09:33:00
 | 06:04:00 | 16:04:00
 | 06:05:00 | 16:04:00
 | 06:05:00 | 08:02:00
 | 06:12:00 | 10:15:00
 | 06:12:00 | 10:16:00
 | 06:15:00 | 10:32:00
 | 06:17:00 | 10:12:00
 | 06:25:00 | 10:26:00
 | 06:28:00 | 07:43:00
 | 06:32:00 | 14:36:00
 | 06:33:00 | 11:12:00
 | 06:35:00 | 14:15:00
 | 06:46:00 | 14:38:00
 | 06:50:00 | 14:41:00
 | 06:50:00 | 12:26:00
 | 06:50:00 | 10:54:00
 | 06:52:00 | 08:05:00
 | 06:55:00 | 16:22:00
 | 07:00:00 | 11:45:00
 | 07:02:00 | 12:09:00
 | 07:03:00 | 15:03:00
 | 07:12:00 | 12:06:00
 | 07:17:00 | 14:42:00
 | 07:20:00 | 15:51:00
 | 07:23:00 | 17:43:00
 | 07:29:00 | 12:00:00
 | 07:30:00 | 11:32:00
 | 07:30:00 | 11:06:00
 | 10:25:00 | 16:28:00
 | 10:35:00 | 17:13:00
 | 10:57:00 | 17:12:00
 | 11:20:00 | 17:30:00
 | 11:38:00 | 12:42:00
 | 11:47:00 | 18:05:00
 | 11:52:00 | 19:55:00
 | 12:05:00 | 17:42:00
 | 12:16:00 | 20:45:00
 | 13:07:00 | 21:41:00
 | 13:25:00 | 18:28:00
 | 13:30:00 | 18:17:00
 | 13:30:00 | 17:48:00
 | 13:32:00 | 20:13:00
 | 13:45:00 | 22:31:00
 | 13:50:00 | 18:06:00
 | 13:54:00 | 19:30:00
 | 14:00:00 | 21:21:00
 | 14:07:00 | 22:37:00
 | 14:08:00 | 22:48:00
 | 14:10:00 | 18:10:00
 | 14:12:00 | 18:19:00
 | 14:22:00 | 18:52:00
 | 14:25:00 | 21:54:00
 | 14:30:00 | 21:43:00
 | 14:31:00 | 17:56:00
 | 14:32:00 | 1900-01-01 01:03:00
 | 14:32:00 | 18:02:00
 | 14:33:00 | 1900-01-01 00:58:00
 | 14:38:00 | 23:41:00
 | 14:42:00 | 18:47:00
 | 14:42:00 | 1900-01-01 00:25:00
 | 14:42:00 | 19:14:00
 | 14:42:00 | 19:02:00
 | 14:42:00 | 19:13:00
 | 14:42:00 | 22:30:00
 | 14:45:00 | 23:46:00
 | 14:45:00 | 18:59:00
 | 14:45:00 | 18:58:00
 | 14:46:00 | 22:30:00
 | 14:48:00 | 18:47:00
 | 14:49:00 | 19:03:00
 | 14:52:00 | 18:01:00
 | 14:55:00 | 19:32:00
 | 14:55:00 | 20:55:00
 | 14:59:00 | 19:14:00
 | 15:00:00 | 1900-01-01 00:52:00
 | 15:00:00 | 19:00:00
 | 15:01:00 | 19:13:00
 | 15:05:00 | 19:18:00
 | 15:10:00 | 19:14:00
 | 15:14:00 | 1900-01-01 00:20:00
 | 15:22:00 | 1900-01-01 00:05:00
 | 15:32:00 | 16:53:00
 | 15:35:00 | 23:59:00
 | 17:24:00 | 1900-01-01 01:11:00
 | 17:42:00 | 1900-01-01 01:20:00
Spreadsheet: 107913d1305055120-move-data-based-upon-number-carshow
Sheet: Results by Owner # 

 | Owner ID | Class 1 Votes | Owner ID | Class 2 Votes | Owner ID | Class 3 Votes | Owner ID | Class 4 Votes | Owner ID | Class 6 Votes
1st Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
2nd Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
3rd Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Owner ID | Class 7 Votes | Owner ID | Class 8 Votes | Owner ID | Class 9 Votes | Owner ID | Class 10 Votes | Owner ID | Class 11 Votes
1st Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
2nd Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
3rd Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Owner ID | Class 12 Votes | Owner ID | Class 13 Votes | Owner ID | Class 14 Votes | Owner ID | Class 15 Votes | Owner ID | Class 16 Votes
1st Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
2nd Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
3rd Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 163505d1340332038-autosort-formula-rnklist
Sheet: helper

Ale | 64 | 17
Antidote | 56 | 11
EB Sports | 52 | 7
Bumme | 45 | 3
Clint | 73 | 22
Cruijff | 90 | 26
Ekslem | 73 | 21
Ernst | 36 | 1
Freek | 50 | 6
Gittermaster | 57 | 12
[NAME] | 74 | 23
[NAME] | 56 | 10
Jan | 71 | 20
Jansoe | 70 | 19
[NAME] | 49 | 5
[NAME] | 66 | 18
Kraai | 54 | 9
Kuiper | 61 | 13
Lars | 53 | 8
Mac | 62 | 15
Nico | 79 | 24
[NAME] | 91 | 27
Sander | 62 | 14
Sebas | 44 | 2
Seyun | 64 | 16
Tampie | 81 | 25
[NAME] | 48 | 4
Spreadsheet: 171786d1343858195-using-multiple-filter-for-pivot-table-a1
Sheet: Sheet5

Project Manager | (All)
Quarter | (All)
Quarter2 | (All)
Quarter3 | (All)
 | Values |  |  |  |  | It does not give me the sales of Q1 for Infra and Industrial, If I select Q1 in both Quarter and Quarter 2 then it gives me zero sales in quarter 1.
Row Labels | Sum of z1 | Sum of z2 | Sum of z3
AA | 1 | 9 | 17
AAB | 3 | 9 | 15
AABC | 2 | 14 | 26
AADF | 3 | -1 | -5
ACDR | 9 | -1 | -11
ADFG | 4 | 0 | -4
AFGH | 6 | -6 | -18
ASDF | 5 | 7 | 9
AWED | 19 | 73 | 127
AWES | 21 | -15 | -51
AXCD | 20 | -18 | -56
CDRF | 12 | -8 | -28
[NAME] | 7 | 43 | 79
FDRT | 29 | 5 | -19
GFTY | 16 | -12 | -40
SDER | 31 | -9 | -49
SDFG | 8 | 6 | 4
SDFR | 10 | 0 | -10
SERF | 17 | 9 | 1
SWED | 22 | 90 | 158
XSDE | 11 | -9 | -29
Grand Total | 256 | 186 | 116
Spreadsheet: 126510d1319727779-multiple-criteria-statement-constant
Sheet: Sheet1

A | A |  | 0.1
B | B |  | 0.1
C | C |  | 0.1
E | E |  | 0.1
D | D |  | 0.1
C | B |  | 0.2
A | C |  | 0.1
B | D |  | 0.15
B | A |  | 0.15
E | B |  | 0.2
D | E |  | 0.1
A | D |  | 0.1
A | C |  | 0.1
B | A |  | 0.15
C | B |  | 0.2
D | C |  | 0.1
E | D |  | 0.1
E | C |  | 0.1
D | B |  | 0.2
C | A |  | 0.2
 |  | Equation fill here | result should be
A=0.1
B=0.15
[NAME]
If a1=b1 the result is 0.1
if [NAME] doesn't equal b1 the result is the following cases:
if both a1 and b1 are either C,D,E the result is 0.1
if the first case doesn't apply then the result is what a1 equals above
Spreadsheet: 112681d1308725513-excel-2007-rank-abs-data-with-if-function-forum-post-1
Sheet: Post

SCORE | ABS | RANK
98.7 | 2.299999999999997 | 6
98.94 | 2.060000000000002 | 4
97.79 | 16.20999999999999 | 13
99.5 | 1.5 | 3
100.32 | 14.31999999999999 | 9
98.84 | 2.159999999999997 | 5
101.71 | 15.70999999999999 | 11
101.05 | 15.05 | 10
97.83 | 16.17 | 12
103.47 | 17.47 | 14
98.68 | 2.319999999999993 | 7
99.99 | 1.010000000000005 | 2
100.01 | 14.01000000000001 | 8
100 | 1 | 1
Spreadsheet: 1a30f645-1e0a-4fe4-bf51-e71025e17ece
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-08-23 09:28:21.980000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.392 | 101.267 | 101.142 | 100.767 |  | and are added to price quote
4.75 | 100.891 | 100.766 | 100.641 | 100.266
4.625 | 100.154 | 100.029 | 99.904 | 99.529 |  | Note: | Refer To Price [NAME]
4.5 | 99.244 | 99.119 | 98.994 | 98.619 |  |  | For all Price Adjs
4.375 | 98.293 | 98.168 | 98.043 | 97.418
4.25 | 97.507 | 97.382 | 97.257 | 96.632
4.125 | 96.699 | 96.574 | 96.449 | 95.824
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 101.981 | 101.856 | 101.731 | 101.356
3.875 | 101.291 | 101.166 | 101.041 | 100.666
3.75 | 100.579 | 100.454 | 100.329 | 99.954
3.625 | 100.115 | 99.99 | 99.865 | 99.49
3.5 | 99.591 | 99.466 | 99.341 | 98.716
3.375 | 98.829 | 98.704 | 98.579 | 97.954
3.25 | 98.104 | 97.979 | 97.854 | 97.229 |  | Minimum loan amount:
3.125 | 96.965 | 96.84 | 96.715 | 96.09 |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-09-06 09:28:21.980000
30 DAY | 2013-09-21 09:28:21.980000
45 DAY | 2013-10-06 09:28:21.980000
60 DAY | 2013-10-21 09:28:21.980000
90 DAY | 2013-11-20 09:28:21.980000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 880112d1727734323-dd-mm-yyyy-hh-mm-assistance-in-converting-via-formula-time-zone-conversion-eba2
Sheet: Testing

Region | Instance  ID | Cutoff_time | TEST DATES |  | DATE + TIME (DD/MM/YYYY HH:MM) | DATE | TIME | TIME ZONE | TIME ZONE CONVERT | FINAL
ap-southeast-1 | i-0849426863c1ed206 | 2024/09/11 17:47 GMT+5:30 | 11/09/2024 03:30 EDT |  |  |  |  |  | UTC
us-east-2 | i-08d944b0cf71c1383 | 2024/09/11 17:34 GMT+5:30 | 11/09/2024 21:30 EDT |  |  |  |  |  | UTC
 |  |  | 11/09/2024 19:30 JST |  |  |  |  |  | UTC
 |  | DD-MM-YYYY HH:MM TZ | 05/07/2024 19:30 INST |  |  |  |  |  | UTC
 |  |  | 30/09/2024 22:30 PST |  |  |  |  |  | UTC
 |  |  | TEST DATES
 |  |  | 11/09/2024 03:30 EDT
 |  |  | 11/09/2024 21:30 EDT
 |  |  | 11/09/2024 19:30 JST
 |  |  | 11/09/2024 19:30 IST
 |  |  | 30/09/2024 22:30 PST
Spreadsheet: 118755d1313984110-if-statement-to-compare-times-variation_calc
Sheet: Sheet1

1st Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
2nd Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
3rd Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
Spreadsheet: 485119d1476715448-basic-index-match-question-example-15-
Sheet: Sheet1

 |  |  |  | LOGIC IN COLUMNS B & C
 | [NAME] | michelle |  | <<<< | MIKE IS RELATED TO MICHELLE
 | [NAME] | angelina |  | <<<< | MIKE IS RELATED TO ANGELINA
 | [NAME] | bradley |  | ETC
 | tom | Aiesha |  | <<<< | [NAME] IS RELATED TO AIESHA
 | michelle | [NAME] |  | ETC
 | [NAME] | tom |  | ETC
 | michelle | [NAME] |  | ETC
 | tom | laurance
 | tom | [NAME]
 |  |  |  |  |  |  |  | None duplicate names | relationships (Show all named related to values in column i18:i27)
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | tom
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | angelina
 |  |  |  |  |  |  |  | bradley
 |  |  |  |  |  |  |  | Aiesha
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 767689d1644581851-help-combining-a-column-reference-with-a-number-calculated-in-a-cell-excel-forum-help-doc
Sheet: Excel Forum Help doc

VC:2f90039 BD:Jan 16 2014 SN:LGR-14-0059
Time | Time (minutes) | [CH4]_ppm | [H2O]_ppm | [CO2]_ppm | [CH4]d_ppm | [CO2]d_ppm
01/01/2002 00:02:10.406 | 0 | 2.116873 | 21439.64 | 406.8412 | 2.163252 | 415.7548
01/01/2002 00:02:11.384 | 0.016 | 2.121468 | 22032.71 | 405.2872 | 2.169263 | 414.4179
01/01/2002 00:02:12.359 | 0.033 | 2.122251 | 22250.36 | 404.8852 | 2.170546 | 414.099
01/01/2002 00:02:13.336 | 0.049 | 2.119908 | 22192.05 | 405.0458 | 2.168021 | 414.2386
01/01/2002 00:02:14.313 | 0.065 | 2.118347 | 21917.45 | 405.7206 | 2.165816 | 414.8122
01/01/2002 00:02:15.290 | 0.081 | 2.118155 | 21681.4 | 405.8362 | 2.165097 | 414.8303
01/01/2002 00:02:16.267 | 0.098 | 2.121172 | 21730.36 | 406.1452 | 2.168289 | 415.1669
01/01/2002 00:02:17.244 | 0.114 | 2.130545 | 21880.19 | 405.5263 | 2.178204 | 414.5978
01/01/2002 00:02:18.221 | 0.13 | 2.137695 | 22083.98 | 405.1317 | 2.18597 | 414.2806
01/01/2002 00:02:19.198 | 0.147 | 2.14408 | 22120.3 | 404.5318 | 2.19258 | 413.6826
01/01/2002 00:02:20.175 | 0.163 | 2.144686 | 22100.45 | 404.814 | 2.193156 | 413.9628
01/01/2002 00:02:21.152 | 0.179254545454545 | 2.141517 | 21986.75 | 405.4351 | 2.18966 | 414.5497
01/01/2002 00:02:22.129 | 0.195554545454545 | 2.136702 | 21855.39 | 405.579 | 2.184444 | 414.6412
01/01/2002 00:02:23.106 | 0.211854545454545 | 2.13259 | 21559.16 | 405.44 | 2.17958 | 414.3735
01/01/2002 00:02:24.083 | 0.228154545454545 | 2.127057 | 21339.23 | 405.8518 | 2.173436 | 414.7012
01/01/2002 00:02:25.059 | 0.244454545454545 | 2.122335 | 21209.41 | 405.6752 | 2.168324 | 414.4658
01/01/2002 00:02:26.036 | 0.260754545454545 | 2.122048 | 21055.45 | 405.9675 | 2.16769 | 414.6992
 |  |  |  |  | 2.15
 |  |  |  |  | 2.16
 |  |  |  |  |  |  |  | Number of cells in Column