tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69947d1270606245-matching-results-book1
Sheet: Sheet1

COL 1 |  | COL 2 |  | RESULTS
001 |  | 001 |  | 003
002 |  | 002 |  | 004
003 |  | 005 |  | 006
004 |  | 008 |  | 007
005 |  | 014 |  | 009
006 |  | 021 |  | 010
007 |  | 027 |  | 011
008 |  | 028 |  | 012
009 |  | 033 |  | 013
010 |  | 035 |  | 015
011 |  | 039 |  | 016
012 |  | 040 |  | 017
013 |  | 041 |  | 018
014 |  | 042 |  | 019
015 |  |  |  | 020
016 |  |  |  | 022
017 |  |  |  | 023
018 |  |  |  | 024
019 |  |  |  | 025
020 |  |  |  | 026
021 |  |  |  | 029
022 |  |  |  | 030
023 |  |  |  | 031
024 |  |  |  | 032
025 |  |  |  | 034
026 |  |  |  | 036
027 |  |  |  | 037
028 |  |  |  | 038
029 |  |  |  | 043
030 |  |  |  | 044
031 |  |  |  | 045
032
033
034
035
036
037
038
039
040
041
042
043
044
045
Spreadsheet: 1603ab6b-f874-4461-b251-0c5a6891afe8
Sheet: Sheet1

Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Adcock | Bradley | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 2291 |  | [NAME] | NC | 27702
Hall, Sr. | [NAME] | [EMAIL] | [PHONE] |  | 216 Day Break Drive |  | [NAME] | NC | 27284
Barnes | [NAME] | [EMAIL] | [PHONE] |  | 3605 Glenwood Avenue |  | Raleigh | NC | 27612-3909
Barnes, Jr. | [NAME] | [EMAIL] | [PHONE]-215 | [PHONE] | 4220 Neal Road |  | [NAME] | NC | 27705
Beaver | [NAME] | [EMAIL] | [PHONE] |  | 3763 Golf Drive NE |  | Conover | NC | 28613
Daniels, Jr. | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 234 Fayetteville Street | Suite 600 | Raleigh | NC | 27604
Lancaster | [NAME] | [EMAIL] | [PHONE] |  | 410 [NAME] | #611 | Falls Church | VA | 22046
[NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 102 W 3rd | Suite 810 | Winston-Salem | NC | 27101
Rich | [NAME] | [EMAIL] | [PHONE] | [PHONE] | [NAME] | Campus | Boone | NC | 28608
Roess | [NAME] | [EMAIL] | [PHONE] | [PHONE] | [NAME] 83 |  | Blowing Rock | NC | 28605
Steinback | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 54 Cedar Hill Drive |  | Asheville | NC | 28803
Wilson | Carole | [EMAIL] | [PHONE] |  | 1421 Canterbury Road |  | Raleigh | NC | 27608
[NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1821 Birchwood Road |  | Kingsport | TN | 37660
Spreadsheet: 77366d1277846944-populate-cells-sign-off-test
Sheet: Lists

Department List | Topic List | Target List | ID List
Accounting | Employee Emergency Preparedness | All Employees | Safety
Administration | Million Nurse Moment Campaign | Nursing Supervisors | Regulatory Agencies
Admitting | Annual Review | All Pastoral Care Employees | Organizational Requirements
Bioengineering | [NAME] | All Patient Services Employees | Safety/Policy Procedure
Cardiac Rehab | Hazardous Waste Management | All Physical Therapy Employees
Communication | Right To Know | All Respiratory Employees
Community Center | Falls - How to safely move a patient post fall | All SDS Employees
Contractural Social Services | Hazardous Waste Black Boxes and Affinity Allergy Entry | Registered Nurses
Corporate Compliance | Silver Coated Foleys
Development
Diabetes Educator
Diagnostic Imaging
Dietary SACH
Emergency Department
Houskeeping
Human Resources
ICU-CCU
Infection Control
Information Services
[NAME]
Laboratory
Materials Management
Medical Records
Medical Records-Volunteers
Medical Surgical
Nursing-Administration
Nursing-Diagnostic Imaging
Nursing-Spectrum
Nursing-Supervisors
Obstetrics
[NAME]
Operating Room
Pastoral Care
Patient Relations
Patient Services
Patient Services-Contractual Services
Pharmacy
Physical Therapy
Plant Operations
Quality Improvement
Regulated Medical Waste
[NAME] PT
Respiratory
Risk Management
Same Day Surgery
Same Day Surgery-Endoscopy
Speech
Volunteers
Wound Care
Spreadsheet: 832979d1686713757-formula-to-add-or-subtract-previous-balance-based-on-transaction-type-sample33
Sheet: Sheet1

 |  |  | Name | Date | Transaction Type | Amount | Balance
 |  |  | Employee 1 | 2023-06-01 00:00:00 | Borrow | 4550
 |  |  | Employee 2 | 2023-06-05 00:00:00 | Borrow | 2500
 |  |  | Employee 2 | 2023-06-07 00:00:00 | Borrow | 200 | 2700
 |  |  | Employee 1 | 2023-06-09 00:00:00 | Payment | 450 | 4100
 |  |  | Employee 2 | 2023-06-09 00:00:00 | Borrow | 200 | 4900
 |  |  | Employee 1 | 2023-06-10 00:00:00 | Borrow | 310 | 4410
 |  |  | Employee 2 | 2023-06-11 00:00:00 | Payment | 690 | 4210
Spreadsheet: sara_shackleton__36837__Merrill copy
Sheet: Gas_Opt_Final

ENA ID | Transact | Trade Date | B/S | Type | Beg Date | End_Date | Vol | Location | [NAME] |  | Comments
NX6365.1 | 107553 | Aug 30 2000 12:00AM | SELL | PUT | 2001-03-18 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM |  | Match
QS8074.1 | 116964 | Feb 20 2001  2:45PM | BUY | CALL | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM |  | Match
QT6340.1 | 117231 | Feb 23 2001 12:00AM | BUY | CALL | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM |  | Match
Q97452.2 | 112085 | Nov 14 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM |  | Match
Q97452.3 | 112087 | Nov 14 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 5000 | Southern California | Mar 30 2001 12:00AM |  | Match
[NAME] | 112123 | Nov 14 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM |  | Match
QA9189.1 | 112353 | Nov 17 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2003-01-01 00:00:00 | 10000 | Southern California | Dec 30 2001 12:00AM |  | Calendar 2001 option
[NAME] | 112358 | Nov 17 2000 12:00AM | SELL | PUT | 2001-07-02 00:00:00 | 2001-10-01 00:00:00 | 10000 | Southern California | Sep 29 2001 12:00AM |  | Match
QA9189.3 | 112360 | Nov 17 2000 12:00AM | SELL | PUT | 2001-07-02 00:00:00 | 2001-10-01 00:00:00 | 10000 | Southern California | Sep 29 2001 12:00AM |  | Match
Spreadsheet: tracy_geaccone__40439__twfuelanal
Sheet: Analysis

 |  | Average Daily Volume
 |  | 2000 | 2001 | Red Rock | 1 | 2002
 | % | Actual | Actual | (120 [NAME]/d) | Capacity West | Plan
East to West (5%) | 0.05 | 331.8 | 358.4 |  | 478.4 | 427.73
Thor to West (4.5%) | 0.045 | 403.9 | 465.7 |  | 465.5 | 389.96
IG/SJ  to West (4.75%) | 0.0475 |  |  |  | 296.1 | 248.56
Total [NAME]
IG to El Paso Blanco (.25%) | 0.0025 | 309.9 | 335.3 |  |  | 304.7
IG to Blanco Hub and SJ to Thor (.25%) | 0.0025 | 736.9 |  |  |  | 642.9
IG/SJ  to East (1.56%) | 0.0156 |  |  |  |  | 66.37
East to East (1.31%) | 0.0131 | 266.5 |  |  |  | 347.9
Total Volumes
East to West (5%)
Thor to West (4.5%)
IG/SJ  to West (4.75%)
IG to El Paso Blanco (.25%)
IG to Blanco Hub and SJ to Thor (.25%)
IG/SJ  to East (1.56%)
East to East (1.31%)
Total Retention
Actual Fuel Usage |  |  |  |  |  | 33.7
Over Retention per day
Spreadsheet: 408b9465-dd54-43c5-8907-1bbd149ac36b
Sheet: Sheet1

>P4P6 | Unnamed: 1 | Unnamed: 2
GGCCAAAACAACGGAAUUGCGGGAAAGGGGUCAACAGCCGUUCAGUACCAAGUCUCAGGGGAAACUUUGAGAUGGCCUUGCAAAGGGUAUGGUAAUAAGCUGACGGACAUGGUCCUAACCACGCAGCCAAGUCCUAAGUCAACAGAUCUUCUGUUGAUAUGGAUGCAGUUCAAAACCAAACCAAAGAAACAACAACAACAAC
G14C | eSDC | 0.32431887059379
[NAME] | eSDC | 0.426177097602118
G22C | eSDC | 0.574108284918477
A25U | eSDC | 0.159594956752821
G28C | eSDC | 0.184912981525103
G30C | eSDC | 0.534656741990596
U31A | eSDC | 1.4778441826955
C32G | eSDC | 2.60153687252117
A33U | eSDC | 0.574442850087335
A34U | eSDC | 0.337120530056095
C35G | eSDC | 0.719934255406166
A36U | eSDC | 0.1729624529308
[NAME] | eSDC | 0.732522993553816
U41A | eSDC | 0.300453058240139
U42A | eSDC | 0.543269476760307
C43G | eSDC | 0.928643627100153
G45C | eSDC | 0.33443751980996
[NAME] | eSDC | 0.26475938262753
C49G | eSDC | 0.801352172176922
A51U | eSDC | 0.262869581828428
G52C | eSDC | 0.104309089246986
A57U | eSDC | 0.352833845840266
G59C | eSDC | 0.578531163712368
A62U | eSDC | 0.681839556765767
A63U | eSDC | 1.02537388984391
A64U | eSDC | 0.659587709626125
C65G | eSDC | 1.87743579598703
U66A | eSDC | 1.55450820159777
U67A | eSDC | 0.512915159588966
U68A | eSDC | 1.51834453174839
A72U | eSDC | 0.187555881162708
U73A | eSDC | 0.360630489486111
G74C | eSDC | 0.191811616719949
[NAME] | eSDC | 1.00468794863033
U88A | eSDC | 0.532621493089315
A94U | eSDC | 0.564356026702338
A95U | eSDC | 0.38397091158154
U96A | eSDC | 1.02822313057627
A107U | eSDC | 2.13568008159904
U110A | eSDC | 0.164250723068111
G112C | eSDC | 0.66852826404501
U113A | eSDC | 0.378206165521796
C119G | eSDC | 0.729222084025977
C120G | eSDC | 0.486917618345837
A121U | eSDC | 1.15633120873829
C128G | eSDC | 0.0687941354378059
A129U | eSDC | 0.0817843029061471
C133G | eSDC | 0.317750762978184
C134G | eSDC | 0.568317754492152
U135A | eSDC | 0.546878850733369
G138C | eSDC | 0.167215801308095
U139A | eSDC | 0.582077833828558
A141U | eSDC | 0.144403860028318
A142U | eSDC | 0.131540291698619
C143G | eSDC | 0.596215398786751
A144U | eSDC | 0.242458448864682
A146U | eSDC | 0.228291660110979
C151G | eSDC | 0.272523531034127
U152A | eSDC | 0.790040716388597
A157U | eSDC | 0.300973949572419
A159U | eSDC | 0.457610416824098
U160A | eSDC | 0.163718229418795
G161C | eSDC | 0.309019685491139
G162C | eSDC | 0.583987636012827
A163U | eSDC | 0.595764353500735
C166G | eSDC | 0.283016724442965
A167U | eSDC | 0.557460045317569
U169A | eSDC | 0.097075606372766
U170A | eSDC | 0.125500199100468
C171G | eSDC | 0.269828923536046
Spreadsheet: 691068d1597430486-excel-fuel-calculation-fuel-formula
Sheet: JAN 2020

Fuel
SL | ID | Rider's Name | Deliveries | Fuel | Actual Fuel | Fuel Consumption
1 | 1500 | Ahmed | 400 |  | 115
2 | 1501 | [NAME] | 430 |  | 220 | Normal
3 | 1502 | [NAME] | 500 |  | 150 | High
4 | 1503 | Rubel | 360 |  | 150 | Very High
5 | 1504 | Ahmed | 250 |  | 65 | Normal
6 | 1505 | [NAME] | 365 |  | 90 | Normal
7 | 1506 | [NAME] | 590 |  | 180 | High
8 | 1507 | Rubel | 400 |  | 160 | Very High
9 | 1508 | Ahmed | 430 |  | 120 | Normal
10 | 1509 | [NAME] | 500
11 | 1510 | [NAME] | 360
12 | 1511 | Rubel | 250
13 | 1512 | Ahmed | 365
14 | 1513 | [NAME] | 590
15 | 1514 | [NAME] | 400
16 | 1515 | Rubel | 430
17 | 1516 | Ahmed | 500
18 | 1517 | [NAME] | 360
19 | 1518 | [NAME] | 250
20 | 1519 | Rubel | 365
21 | 1520 | Ahmed | 590
22 | 1521 | [NAME] | 400
23 | 1522 | [NAME] | 430
24 | 1523 | Rubel | 500
25 | 1524 | Ahmed | 360
26 | 1525 | [NAME] | 250
27 | 1526 | [NAME] | 365
28 | 1527 | Rubel | 365
29 | 1528 | Ahmed | 365
30 | 1529 | [NAME] | 365
Spreadsheet: 154949d1336622498-conditional-formatting-for-dates-and-highlighting-cells-example
Sheet: Sheet1

Date | 2012-05-10 00:00:00
Days Overdue |  |  |  |  |  |  |  | Date of decision | Decision |  |  | Date final report delivered
 |  |  |  |  |  |  |  | 2012-05-08 00:00:00 | Approved
 |  |  |  |  |  |  |  |  | (none)
 |  |  |  |  |  |  |  | 2012-03-14 00:00:00 | Approved |  |  | 2012-04-24 00:00:00
 |  |  |  |  |  |  |  | 2011-12-01 00:00:00 | Approved
 |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | Approved
 |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | Not Approved
I need column A to calculate the number of days between todays date (cell B 1) and the date of decision (eg 20 days).  Obviously todays date will keep changing.
I also need the cells in column A to change colour: turn green when the days overdue are 120 or less, yellow when they are between 121 and 150 days overdue and red when they are 150 or more days overdue.
Also I need the cell in column A to stay blank if there is either no date in the Date Final Report Delivered column (M) or the text in Decision column (J) is other than Approved.
Spreadsheet: 702743d1604508442-copy-different-and-changing-length-lists-from-multiple-sheets-dept-summary-for-questions
Sheet: 1ST DIV

 |  |  |  |  | LAST NAME | FIRST NAME | TYPE 1 | TYPE 2 | TYPE 3 | TYPE 4
 |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
TYPE 1 |  |  |  |  |  |  |  |  | X
TYPE 2 |  |  |  |  |  |  |  |  |  | X
TYPE 3 |  |  |  |  |  |  |  |  | X
TYPE 4 |  |  |  |  |  |  |  | X
TOTAL |  |  |  |  |  |  |  | X
TYPE 2
FIRST NAME | LAST NAME | START | STOP
 |  | 1800 | 2700
 |  | 1700 | 2900
 |  | 600 | 1500
TYPE 3
 |  | 7000 | 9000
 |  | 6200 | 8000
Spreadsheet: 889490d1740328928-charts-drop-to-zero-cedward-dynamic-charting-with-zeros
Sheet: Quarterly Exp.  Redesign

Quarter | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |  | Date
Year | 2025 | 2025 | 2025 | 2025 | 2026 | 2026 | 2026 | 2026 | 2027 | 2027 | 2027 | 2027 | 2028 | 2028 | 2028 | 2028 | 2029 | 2029 | 2029 | 2029 |  | Quarter | 1
Total
Spreadsheet: 791108d1660155653-sliding-scale-formula-correction-2022-08-10-oeldere-jslost-sample-11-
Sheet: Formula Comparison

 | Commission Table
 | [NAME] | [NAME] | [NAME] | [NAME] | cummulative | Fee | Adjust
 | 0 | 5000000 | 0.01 |  |  |  |  |  |  | *This is not intended as the fee is less despite a higher amount. I would like to figure out a formula that will increase any fees to the highest range of the previous tier when this occurs. For example, the result in this scenario would be:
 | 5000000.01 | 10000000 | 0.009
 | 10000000.01 | 20000000 | 0.008 |  |  |  |  |  |  | $5M - $10M / 0.9%: $9,750,000 x 0.9% = $87,750
 | 20000000.01 | 30000000 | 0.007 |  |  |  |  |  |  | $10M - $20M / 0.8% $10,050,000 x 0.8% = $80,400 + $7,350 = $87,750.
 | 30000000.01 | 40000000 | 0.006
 | 40000000.01 | 50000000 | 0.005
 | 25000000
 | Sales Amount | 10500000
 | Problem Example
 | [NAME] | Sales | [NAME] |  |  | Amount
 | $5M-$10M | 9750000
 | $10M-$20M | 10050000
 |  |  | Difference
Spreadsheet: 232794d1367523027-calculating-overtime-over-several-jobs-copy-of-time-sheet-and-job-costing
Sheet: Teeter Master Time Sheet

 |  |  |  | Sunday 5/5/13 |  |  | Monday 5/6/13 |  |  | Tuesday 5/7/13 |  |  | Wednesday 5/8/13 |  |  | Thursday 5/9/13 |  |  | Friday 5/10/13 |  |  | Saturday 5/11/13 |  |  | Total Days | Total Hours | Regular | OT
 |  |  |  | Start | Stop | Total | Start | Stop | Total | Start | Stop | Total | Start | Stop | Total | Start | Stop | Total | Start | Stop | Total | Start | Stop | Total
Last Name | First Name | Middle Initial | Job #
Non-Drivers
Amaya | Miguel
Spreadsheet: 860821d1708842194-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-formula-play_with-expected-results-highlighted-in-yellow_v5_return-dates
Sheet: Leave

employee | Start | end |  | Leave type
AS123 | 2024-02-11 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-03-12 00:00:00 | 2024-03-19 00:00:00 |  | Recreational
AS123 | 2024-02-07 00:00:00 | 2024-02-10 00:00:00 |  | Sick without Pay - MC
AP346 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | Leave without pay
[NAME] | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
Spreadsheet: 454495d1459864506-value-return-based-on-multiple-criteria-example-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected output after validation
ISO | Country | Region | Business Unit | Category | Scope | Periodicity | Frequency |  | Completion Date | Periodicity | Frequency
BE | Belgium |  |  | Core Sparkling |  |  |  |  | 2016-01-01 00:00:00 | W | M
BE | Belgium |  |  | Juice |  |  |  |  | 2016-01-02 00:00:00 | W | M
BE | Belgium |  |  | Water |  |  |  |  | 2016-01-03 00:00:00 | W | M
BE | Belgium |  |  | Sports |  |  |  |  | 2016-01-04 00:00:00 | W | M
BE | Belgium |  |  | Energy |  |  |  |  | 2016-01-05 00:00:00 | W | M
BE | Belgium |  |  | RTD Tea |  |  |  |  | 2016-01-06 00:00:00 | W | M
GB | Great Britain |  |  | Core Sparkling
GB | Great Britain |  |  | Juice |  |  |  |  | 2016-01-08 00:00:00 | W | W
GB | Great Britain |  |  | Water |  |  |  |  | 2016-01-09 00:00:00 | W | W
GB | Great Britain |  |  | Sports |  |  |  |  | 2016-01-10 00:00:00 | W | W
GB | Great Britain |  |  | Energy |  |  |  |  | 2016-01-11 00:00:00 | N/A | N/A
GB | Great Britain |  |  | Tea |  |  |  |  | 2016-01-12 00:00:00 | W | W
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Heating & Air

AIR CONDITIONING AND REFRIGERATION TECHNOLOGY
Diploma - Heating, Ventilation and Air Conditioning Mechanic
Student Name:
ID #
General Education | Semester | Grade
___ Area 1 Writing/Accessing Information, Oral Communication, Humanities or [NAME] (3)
___ Area 2 Social Science, Beharvioral Science, Natural or Applied Science or Mathematics (3)
___ Area 3 CIT 105 Introduction to Computers OR IC3 Computer Literacy Exam (0-3)
Program Courses
___ ACR 100 (3) Regrigeration Fundamentals
___ ACR 101 (2) Refrigeration Fundamentals Lab
___ ACR 102 (3) HVAC Electricity AND ___ ACR 103 (2) HVAC Electricity  Lab
OR ___ Comparable Electircal Course* (4-5)
___ ACR 130 (3) Electrical Components
___ ACR 131 (2) Electrical Components Lab
___ ACR 170 (3) Heat Load/Duct Design
___ ACR 250 (3) Cooling & Dehumidification
___ ACR 251 (2) Cooling & Dehumidification Lab
___ ACR 260 (3) Heating & Humidification
___ ACR 261 (3) Heating & Humidification Lab
___ ACR 270 (3) Heat Pump Applications
___ ACR 271 (2) Heat Pump Applications Lab
___ Technical Electives (8-11) Approved by Program Coordinator
* Comparable Electrical Courses
___ EET 154 (2) Electrical Construction AND EET 155 Electrical Construction Lab (2)
OR ___ ETT 112 (3) Basic Electrical Theory: Telenetworking
AND ETT 113 (1) Basic Electrical Theory Lab
OR ___ ELT 110 (5) Circuits I
OR ___ IMT 110 (3) Industrial Maintenance Electrical Principles
AND ___ IMT 111 (2) Industrial Maintanance Electrical [NAME]
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 08ebd7a6-e211-4f32-b48d-5928b94f872c
Sheet: Grade 8 Science

2013 Minnesota Comprehensive Assessments-Series III (MCA-III)
Grade 8 Science
Raw Score | Scale Score | Level | Percentile Rank
0 | 801 | D | 1
1 | 801 | D | 1
2 | 801 | D | 1
3 | 801 | D | 1
4 | 801 | D | 1
5 | 801 | D | 1
6 | 801 | D | 1
7 | 803 | D | 1
8 | 809 | D | 1
9 | 813 | D | 1
10 | 816 | D | 2
11 | 819 | D | 2
12 | 821 | D | 3
13 | 823 | D | 4
14 | 825 | D | 5
15 | 827 | D | 6
16 | 828 | D | 8
17 | 830 | D | 9
18 | 831 | D | 11
19 | 833 | D | 13
20 | 834 | D | 15
21 | 835 | D | 17
22 | 837 | D | 19
23 | 838 | D | 22
24 | 839 | D | 25
25 | 840 | P | 28
26 | 842 | P | 31
27 | 843 | P | 34
28 | 844 | P | 38
29 | 845 | P | 42
30 | 846 | P | 46
31 | 847 | P | 50
32 | 849 | P | 54
33 | 850 | M | 58
34 | 851 | M | 63
35 | 852 | M | 67
36 | 853 | M | 71
37 | 855 | M | 75
38 | 856 | M | 79
39 | 858 | M | 82
40 | 859 | M | 86
41 | 861 | M | 89
42 | 863 | E | 91
43 | 864 | E | 94
44 | 866 | E | 96
45 | 868 | E | 97
46 | 871 | E | 98
47 | 874 | E | 99
48 | 878 | E | 99
49 | 883 | E | 99
50 | 892 | E | 99
51 | 899 | E | 99
End of Worksheet
Spreadsheet: 5253090e-7413-4850-8764-6b57f5613157
Sheet: Sheet1

Supports and Services Authorization Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Participant: |  | MID#: |  | [NAME]:              A&D/DD State Plan:              DD State Plan:
[NAME] | Procedure Code | Start Date | Stop Date | Units | Unit Cost | Frequency (x365, x52, x12, etc.) | Annual Cost | Annual Units | IPA #- Dept. use only
DD Services
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0
Ancillary Services (OT,PT, SL & DME)
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0
DD Service Coordination Services
(Agency Name) - PD - MMCP (Costed/No PA) |  |  |  |  |  |  | 0 | 0
(Agency Name) - TSC - (Prof.) - MMCP (Costed/No PA) |  |  |  |  |  |  | 0 | 0
(Agency Name) - TSC  (Para) - MMCP (Costed/No PA) |  |  |  |  |  |  | 0 | 0
(Agency Name) - PD - Non-MMCP (Costed/PA) |  |  |  |  |  |  | 0 | 0
(Agency Name) - TSC (Prof.)- Non-MMCP (Costed/PA) |  |  |  |  |  |  | 0 | 0
(Agency Name) - TSC (Para) - Non-MMCP (Costed/PA) |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0
 |  |  |  | Annual Total |  |  | 0
 |  |  |  | Calculated Budget Amount: |  |  | 0
 |  |  |  | +/- Medicaid Budget Total |  |  | 0
 |  |  |  | Final Plan Amount:
Spreadsheet: 141427d1329257519-need-help-with-multiple-criteria-h-vlookup-sample-census-data
Sheet: Sheet1

Census | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00
Facility | Category 1 | Category 2 | Category 3 | Category 1 | Category 2 | Category 3
Site A | 0 | 0 | 0 | 12 | 1 | 0
Site B | na | na | na | 20 | na | 1
Site A | 61.95714285714286 | 12.10780669144981 | 7.24390243902439 | 40 | 15 | 0
Spreadsheet: 864065d1711391419-how-to-create-a-max-min-and-average-chart-358750170394173_logs
Sheet: Sheet1

Row Labels | [NAME] of Temperature | Average of Temperature | Min of Temperature | Max of Humidity | Average of Humidity | Min of Humidity
01-Mar | 76.5 | 70.96483516483516 | 59.7 | 26.5 | 21.4956043956044 | 17
02-Mar | 76.1 | 72.877 | 70.2 | 35.5 | 30.224 | 24.9
03-Mar | 78.5 | 74.86321839080459 | 72.2 | 35.4 | 31.38045977011493 | 27.3
04-Mar | 77 | 74.6444444444444 | 72.3 | 35.9 | 32.33333333333333 | 30.4
05-Mar | 77 | 73.76976744186045 | 69.6 | 39.9 | 35.91627906976744 | 32.5
06-Mar | 75.8 | 73.27105263157894 | 70.7 | 43.5 | 38.97631578947368 | 35.3
07-Mar | 78.5 | 74.14943820224717 | 69.6 | 44.5 | 35.16292134831461 | 27.6
08-Mar | 78.6 | 74.68043478260869 | 69.6 | 32.8 | 29.37608695652174 | 26
09-Mar | 75.9 | 72.50215053763439 | 67.1 | 36.5 | 30.93010752688171 | 26
10-Mar | 70.4 | 64.79761904761907 | 57.8 | 35.8 | 24.65119047619049 | 19
11-Mar | 70.7 | 65.6268292682927 | 57.6 | 25.1 | 18.90975609756098 | 14.1
12-Mar | 79.7 | 74.45232558139533 | 69.5 | 25 | 21.01976744186046 | 17.1
13-Mar | 78.1 | 75.2195652173913 | 69.6 | 25.5 | 22.93152173913044 | 20.1
14-Mar | 79.5 | 76.9448275862069 | 74 | 27.9 | 23.9 | 21.3
15-Mar | 79 | 76.31348314606743 | 71.4 | 37 | 29.65955056179775 | 22.2
16-Mar | 82.2 | 73.09555555555555 | 69.6 | 30 | 25.82222222222222 | 21.3
17-Mar | 77 | 74.96511627906979 | 71.1 | 27.7 | 23.01046511627907 | 16.6
18-Mar | 73.1 | 69.44222222222221 | 66.6 | 20.6 | 17.83888888888889 | 14.9
19-Mar | 77.7 | 73.33734939759036 | 67.7 | 19.1 | 16.75903614457831 | 14.7
20-Mar | 77.4 | 72.73124999999999 | 66 | 20.3 | 17.36354166666667 | 12.7
21-Mar | 74.3 | 68.3741573033708 | 59.4 | 20.2 | 16.73595505617977 | 13.8
22-Mar | 75.8 | 70.91046511627906 | 60.8 | 27 | 20.73139534883721 | 16.7
23-Mar | 71.6 | 67.36185567010311 | 63.2 | 36.3 | 28.21958762886598 | 17.5
24-Mar | 74.9 | 69.6010752688172 | 62.8 | 20.4 | 18.6268817204301 | 16.8
25-Mar | 72.2 | 69.78055555555555 | 68.4 | 23.5 | 20.18888888888889 | 18.3
Grand Total | 82.2 | 72.24021286441456 | 57.6 | 44.5 | 25.34937528921792 | 12.7