tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 473102d1470050225-finding-data-from-tables-using-match-dependant-on-cell-value-quoteform-test
Sheet: Quote

 |  |  |  | QC | 2 |  |  |  |  |  |  | Cost Price | Cost price Total | Retail Total | Gross Profit
Client: |  |  | Delivery Address: | Section Notes: |  |  |  |  |  |  |  |  | Cost Total | Retail Total | Gross Profit
Price Group: |  |  |  |  |  |  |  |  |  |  |  | TOTALS:
Range: |  | Fusion Linear
Door: |  | BFH10
Painted Door Colour: |  | N/A
Carcase: |  | Graphite GF U961
MATCHINGS / END PANELS: |  | Match Door
[NAME]: |  | [NAME]
Worktop: |  | AK Arkosa Sand 2550
Plinth: |  | SSP30 Stainless Steel
Unit No. | Unit Code | Description |  | [NAME] | Depth | Height | Handing | Qty | Quote Price | Total |  | Cost Price | Cost price Total | Retail Total | Gross Profit
1 | BFH3 | If B13 is blank, then blank, otherwise [NAME] on Range Table matching C4 returning the matched result for Column 2 (Description) |  |  |  |  | Left | 1 |  |  |  | If B13 is blank, then 0, otherwise [NAME] on Range Table matching C4 headers returning the matched result for C3 from the price group column
*** Please hover your mouse over the sections with Comment corners, to see what it is that I need to acheive ***  To create a quote, the user must 1st select the 'Range' they will be using, then select an available 'Door' finish from that range.  Once these are selected, the 'Price Group' is shown, which will determine the price of the selected items.  The user will then go on to select the other relevant selections and proceed to add their quote items into the 'Unit Code' section, and the price returned will be based on the selections made.
Spreadsheet: 140792d1328890648-fill-series-if-adjacent-cell-value-is-greater-than-zero-example-modified-by-tigeravatar-
Sheet: Sheet1

Name 1 | Name 2 | Value 1 | Value 2
a |  | 0 | 0
b |  | 0 | 1
c |  | 2 | 0
d |  | 0 | 0
e |  | 0 | 0
f |  | 1 | 1
g |  | 2 | 1
h |  | 1 | 1
i |  | 0 | 0
j |  | 0 | 5
k |  | 2 | 0
l |  | 6 | 0
Spreadsheet: 0302ba7b-cc5c-4760-b259-ca825ae31d4b
Sheet: Sheet1

Idaho School-Based Medicaid Reimbursable Evaluation Services Recommendation
Student Name: |  | Date of Birth: |  | Age | Grade | Sex
School District |  | School: |  | Case Manager: |  | Date:
Current IEP: |  | Projected Annual: |  | Current Evaluation: | Projected Triennial:
If the student is or becomes eligible for Medicaid and if they meet the requirements to receive specific evaluations or interventions, the following services and hours may be billed with parental consent:
These services are effective as of the date of the physician's signature and services will not exceed 365 days.  The below services are deemed medically necessary as recommended.
Physician's Signature: |  |  |  |  | Date:
School-Based Medicaid Evaluation Services
Evaluation(s) for the following IEP Development
IEP Assessment Areas |  | Assessment Recommended | Medicaid Code | Medicaid Code Description
Personal Care Services - QIDP |  | [   ] | G9001 | Personal Care Services-(QIDP) Assessment and Plan  (1 unit = 1 Assessment)
Personal Care Services - RN |  | [   ] | G9002 | Personal Care Services RN Assessment and Plan (1 unit = 15 minutes)  (Initial = 14 units, Annual = 8 units)
Emotional/Social/Behavioral |  | [   ] | 96150 | Behavioral Assessment  (1 unit = 15 minutes)
Intellectual/Cognitive/                   Functioning and/or Social Emotional (psychological testing) |  | [   ] | 90791 | Psychiatric Diagnostic Evaluation  (1 unit = 15 minutes)
Psychological Testing |  | [   ] | 96101 | Psychological Testing for Diagnosis/Evaluation - Psychologist/Physician (1 unit = 1 hour)
Psychological testing conducted by a technician |  | [   ] | 96102 | Psychological Testing for Diagnosis/Evaluation - Technician  (1 unit = 1 hour)
Psychological Testing:  Respondent taking assessment on computer/Professional interpretation |  | [   ] | 96103 | Psychological Testing for Diagnosis/Evaluation (with computer and professional interpretation)  (1 unit = 1 test)
Developmental/Medical History |  | [   ] | T1028 | Medical/Social History  (1 unit = 15 minutes)
Speech/Language |  | [   ] | 92506 | SLP Evaluation (1 unit = 1 evaluation)
Physical Therapy |  | [   ] | 97001 | PT Evaluation (1 unit = 1 evaluation)
Occupational Therapy |  | [   ] | 97003 | OT Evaluation (1 unit = 1 evaluation)
Audiology Services |  | [   ] | V5008 | Hearing Evaluation (1 unit = 15 minutes)
Case Manager: |  |  | Title: |  | Date:
Other: |  |  | Title: |  | Date:
Spreadsheet: 07705997-95b3-439d-aa43-85faba5cecb5
Sheet: Sheet1

F/Y 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Justice of the Peace Authorized Bail Bond Agencies
Bail Bond Agencies | Address | Telephone  Number | Counties | Registered Agents | Authorized Agents to Pick Up Refunds
1st Choice Bail Bonds | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805
2nd Chance Bail Bonds | 25675 Covert Street |  | Kent | [NAME] | [NAME]
 | Seaford, DE  19973 | [PHONE] | Sussex
A Bail Bond by Resto & Co. | 1200 Northeast Boulevard, Unit B | [PHONE] | All | [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME]
 | [NAME], DE  19802 |  |  | [NAME], Crystal DuPree | [NAME], Crystal DuPree
 |  |  |  | Krystal Pagan | Krystal Pagan
Above and Beyond Bail Bonds | 94A Quigley Boulevard
 | New Castle, DE  19720-4150 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | [NAME] | [NAME]
Absolute Bail Bonds | 104 [NAME] | [PHONE] | Kent | [NAME] | [NAME]
 | Milford, DE  19963 |  | Sussex
Ace Bail Bonds | 475 Bowers Beach Road | [PHONE] | Kent | [NAME] | [NAME]
 | Frederica, DE  19946
All Star Bail Bonds, LLC | 2915 Lancaster Avenue | [PHONE] | All | [NAME], Sr. | [NAME], Sr.
 | [NAME], DE  19805 |  |  | [NAME], Jr. | [NAME], Jr.
American Funding Services Corp. | 2062 New Castle Ave, Suite A |  |  | [NAME], [NAME], [NAME], [NAME] | [NAME]
CASH ONLY | New Castle, DE  19720 | [PHONE] | All |  | [NAME]
Axe Bail Bonds | 977 Lochmeath Way
 | Dover, DE  19901 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | Trinity Goldsborough | Trinity Goldsborough
Bail Bond Agency, Inc. | 102 Larch Avenue, Suite 302 | [PHONE] | All | [NAME] | [NAME]
 | Newport, DE  19804 |  |  | Khyon Church
Bovell Bail Bond, Inc. | 1900 W. 4th Street | [PHONE] | All | [NAME], [NAME], | [NAME]
 | [NAME], DE  19805 |  |  | Gregory Dennis II (Kent and New Castly only)
Bruny's Bail Bonds | 1927 W. 4th Street | [PHONE] | All | Brunilda Mercado | Brunilda Mercado
 | [NAME], DE  19805
Cutting Edge Bail Bonds, LLC | 315 South State Street
 | Dover, DE  19901 | [PHONE] | All* | [NAME] | [NAME]
 |  |  | *Cannot post in JP 7
 |  |  |  | [NAME] | [NAME]
Dale's Bail Bonds LLC | 11 E. Market Street, Suite 1 | [PHONE] | Kent | R. [NAME] | R. [NAME]
 | Georgetown, DE  19947 | [PHONE] | Sussex | [NAME] | [NAME]
[NAME], Jr. Bail Bonds | 411 S. Queen Street | [PHONE] | Kent | [NAME], Jr. | [NAME], Jr.
 | Apt. 213
 | Dover, DE  19904
Fast Bail Bonds LLC | 1224 [NAME] | [PHONE] | All* | [NAME] | [NAME]
 | [NAME], DE  19801 |  | *Cannot post in JP 7
Lorenzo's Bail Bonds, Inc. | 5 E. Market Street | [PHONE] | Kent | [NAME] | [NAME]
 | Georgetown, DE  19947 |  | Sussex | [NAME]
Paragon Associates of Delaware | 583 N. Commerce Street | [PHONE] | Kent
 | Townsend, DE  19734 |  | Sussex | [NAME] | [NAME]
[NAME]'s Bail Bonds, LLC | 424 S. State Street | [PHONE] | Kent | [NAME] | [NAME]
 | Dover, DE  19901
T&H Bail Bond, Inc. | 625 [NAME] | [PHONE] | All | [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME], [NAME]
 | [NAME], DE  19801
Top Bail Surety, Inc. | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME], [NAME] | [NAME]
 | [NAME], DE  19805 |  |  |  | [NAME]
Spreadsheet: 108655d1305670775-multiple-criteria-search-sample
Sheet: Sheet2

Date | Time | Code | Concat
2011-03-15 00:00:00 | 17:41:13 | 1
2011-03-15 00:00:00 | 17:42:20 | DL1
2011-03-15 00:00:00 | 17:42:50 | 9
2011-03-15 00:00:00 | 17:49:28 | RP_
2011-03-15 00:00:00 | 17:49:34 | 43
2011-03-15 00:00:00 | 17:55:54 | RP_
2011-03-15 00:00:00 | 17:56:06 | 47
2011-03-15 00:00:00 | 17:56:27 | RP_
2011-03-15 00:00:00 | 17:56:36 | 53
2011-03-15 00:00:00 | 17:56:59 | DM_
2011-03-15 00:00:00 | 17:57:05 | 52
2011-03-15 00:00:00 | 17:58:39 | RP_
2011-03-15 00:00:00 | 17:58:52 | 50
2011-03-15 00:00:00 | 17:59:40 | TV_
2011-03-15 00:00:00 | 17:59:48 | 48
2011-03-15 00:00:00 | 17:59:57 | DM_
2011-03-15 00:00:00 | 18:00:05 | 45
2011-03-16 00:00:00 | 01:00:20 | RP_
2011-03-16 00:00:00 | 03:45:00 | DL1
Spreadsheet: 82878d1282875108-table-formatting-sample-fabrication
Sheet: Canning Vale Employees

WELDERS/BOILERMAKERS YARLOOP |  | C/Vale Available | FOR WEEKENDING 05.09.10 |  |  |  |  |  |  | Total Hours |  |  | JOB NUMBERS
Name | Position |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  | Job No. | 0C884 | 0C604 | 0C770 | 0C666 | 0C421
[NAME] | Boilermaker | YES |  |  |  |  |  |  |  |  |  | Hours | 4 | 2 | 3 | 1.5 | 3
[NAME] | Welder | YES |  |  |  |  |  |  |  |  |  |  | 1.5 | 2 | 3 | 1 | 4
HARDFACE WELDERS
Name | Position
[NAME] | Hard Face welder | YES
[NAME] | Hard Face welder | YES
[NAME] | Hard Face welder | YES
[NAME] | Hard Face welder | YES
[NAME] | Hard Face welder | YES
WELDERS
Name | Position
[NAME] | Welder | YES
[NAME] | Welder | YES
[NAME] | Welder | YES
[NAME] | Welder | YES
[NAME] | Welder | YES
BOILERMAKER
Name | Position
[NAME] | Boilermaker | YES
[NAME] | Boilermaker | YES
[NAME] | Boilermaker | YES
[NAME] | Boilermaker/Pipe Fitter | YES
[NAME] | Boilermaker/Welder | YES
GRINDER
Name | Position
[NAME] | Grinder | YES
[NAME] | Grinder | YES
Antony Sear | Grinder | YES
Abas Silan | Grinder | YES
[NAME] | Grinder | YES
[NAME] | Grinder | YES
[NAME] | Grinder | YES
Machinist
Name | Position
[NAME] | Machinist | YES
[NAME] | Machinist | YES
BLASTER
Name | Position
[NAME] | blaster | YES
PAINTER
Name | Position
[NAME] | painter | YES
WELDER LEADING HAND
Name | Position
[NAME] | Welder Leading Hand | YES
Spreadsheet: mark_taylor__24952__Deal update
Sheet: Wholesale Market

 | Wholesale Market
 |  | Product | Details | To do list | Relationship Manager | Product Responsible | Expected date | NPV (R$ 1.000) | Status
 | Tradener |  | 60 MW peak and off peak (firm) | They want a 5 years deal |  |  | Second quarter
 |  |  | We will offer them 50 reais per MWh
 | Luiz Otavio |  | 3 years
 | [NAME] |  | PR
 |  |  | Copel territory
 |  |  |  | Decide on pricing
 | Escelsa |  | 10 MW peak and off peak (firm) | They want a 1 year deal |  |  |  |  | They promised to send terms
 |  |  | Up to 70 MW |  |  |  |  |  | and conditions till 27/01
 | Luiz Otavio |  | We will offer 65
 | [NAME] |  | ES
 |  |  | Escelsa
 |  |  | Jan-Apr or/and May-Dec
 | Eletronuclear |  | They will be short in January; 600.000 MWh, but they say that they are not going to buy in the short term market
 | Luiz Otavio
 | [NAME]
 | CELG
 |  |  | They will be short in January; 60.000 MWh
 | Luiz Otavio
 | [NAME]
 | Coelba |  | 40 MW peak and off peak (firm) | They have sold some energy lately for R$120/MWh
 | [NAME]
 |  | Product | Details | To do list | Relationship Manager | Product Responsible | Expected date | NPV (R$ 1.000) | Status
 | Coelce |  | 15 MW peak and off peak (firm)
 | [NAME] |  | They have sold 20 MW in jan for AES for R$ 128/MWh
Spreadsheet: 756540d1637620230-retrieve-hours-worked-based-on-day-of-week-in-rota-gamersheek-rota
Sheet: March

` | 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 | MON | TUE | WED | THU
 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-07 00:00:00 | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-13 00:00:00 | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-27 00:00:00 | 2021-03-28 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | 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 | MON | TUE | WED | THU
 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-07 00:00:00 | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-13 00:00:00 | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-27 00:00:00 | 2021-03-28 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 141358d1329231292-can-only-select-a-drop-down-option-once-0201
Sheet: Sheet1

Name | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 |  |  |  |  |  |  |  |  |  |  |  |  | Arsenal | 1 | Arsenal
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | [NAME]
[NAME] m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chelseaa | 5 | Chelseaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Evertona | 6 | Evertona
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fulham | 7 | Fulham
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Liverpool | 8 | Liverpool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manchester City | 9 | Manchester City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newcastle United | 11 | Newcastle United
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Norwich City | 12 | Norwich City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Queens Park Rangers | 13 | Queens Park Rangers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoke City | 14 | Stoke City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunderland | 15 | Sunderland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swansea City | 16 | Swansea City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 17 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Bromwich Albion | 18 | West Bromwich Albion
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wigan Athletic | 19 | Wigan Athletic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 20 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: Apr 2021

Subscriptions | [NAME] | [NAME]
Gas |  | 35
Gas
Net Flix |  | 12.99
Cox |  | 163.09
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Club Carwash | 21.75
Discovery plus | 7.78
Chewy | 56.71
Sprint | 135.83
Totals |  |  | 78.91 | luci owes
Spreadsheet: 269823d1381299218-help-please-need-formula-to-sum-and-average-data-using-multiple-vlookup-s-credit-dashboard-monthly-yearly-excel-submission-
Sheet: Dashboard

 | North East Credit |  |  |  |  |  | From | [NAME]
 | Performance Report |  |  |  |  |  | To | Adriano-Sep11
 |  |  |  | Collection (%) |  |  | Exposure > 60 Days (%) |  |  | DSO (#)
 | Performance
 | Collection
 | Collection (%) | 1.1
 | Exposure (%) | 0.008
 | DSO (#) | 18
 |  |  |  | [NAME]. Days (#) |  |  | [NAME] 20 Days (#) |  |  | [NAME]. Vs Comp. (#)
 | Disputes
 | Bus. Days (#) | 11
 | > 20 Days (#) | 1
 | Received (#) | 200
 | Completed (#) | 220
 | Banking
 | Unallocated ($M) | 1
 | Processed (#) | 1200 |  | Unallocated Funds ($M) |  |  | Payments Processed (#) |  |  | Unclaimed EFT EOM ($M)
 | Unclaimed  ($M) | 2
 | Reporting
 | Doubtful ($M) | 1.5
 | Adjustments ($M) | 1.2
 | Resource
 | FTE (#) | 25.6 |  | Doubtful ($M) |  |  | Adjustments ($M) |  |  | FTE (#)
 | Review Comments | Strong Collection & Exposure. Dispute |  |  |  |  | Next Steps | Target FTE reduction. Need to reduce
 |  | turn around below target. Doubtul has |  |  |  |  |  | credit volume. Project to improve EFT
 |  | increased which is a concern |  |  |  |  |  | automatch
Spreadsheet: 692958d1598653000-conditional-formatting-duplicates-but-with-conditions-reopened-example
Sheet: Escalations

[NAME] | Restaurant | ID | Original Action | Actual Action | Intake Agent | Notes |  |  | Total
 | C12 |  |  | Verbal Negative |  |  |  | 911
 | C12 |  |  | Escalation |  |  |  | Escalation
 | C12 |  |  | 911 |  |  |  | Non-Escalation
 | C12 |  |  | Non-Escalation |  |  |  | Verbal Negative
 |  |  |  |  |  |  |  | More Info
 |  |  |  |  |  |  |  | High [NAME] |  |  |  |  |  | Restaurant Key:
 |  |  |  |  |  |  |  | 1) Immediate positive test results (when we have them or have confirmed). |  |  |  |  |  | If Cell is RED then it is a High Alert Restaurant
 |  |  |  |  |  |  |  | 2) Outbreak potential situations (multiple CMs impacted).
 |  |  |  |  |  |  |  |  |  |  |  |  |  | If Cell is ORANGE then it is a California Restaurant (Overrided by HARs)
 |  |  |  |  |  |  |  | 3) COVID-related Hospitalizations of any kind.
 |  |  |  |  |  |  |  | 4) Multiple CMs that are testing. |  |  |  |  |  | If cell is YELLOW then the Restaurant has multiple cases (Overrided by HARs/CA)
 |  |  |  |  |  |  |  | High Alert / CA Locations |  | Total Occurances
 |  |  |  |  |  |  |  | Location # | Case count
 |  |  |  |  |  |  |  | C051
 |  |  |  |  |  |  |  | C200
 |  |  |  |  |  |  |  | C287
 |  |  |  |  |  |  |  | C324
 |  |  |  |  |  |  |  | C338
 |  |  |  |  |  |  |  | C446
 |  |  |  |  |  |  |  | C189
 |  |  |  |  |  |  |  | C190
 |  |  |  |  |  |  |  | C200
 |  |  |  |  |  |  |  | C206
 |  |  |  |  |  |  |  | C211
 |  |  |  |  |  |  |  | C272
 |  |  |  |  |  |  |  | C281
 |  |  |  |  |  |  |  | C282
 |  |  |  |  |  |  |  | C292
 |  |  |  |  |  |  |  | C300
 |  |  |  |  |  |  |  | C320
 |  |  |  |  |  |  |  | C321
 |  |  |  |  |  |  |  | C331
 |  |  |  |  |  |  |  | C327
 |  |  |  |  |  |  |  | C329
 |  |  |  |  |  |  |  | C330
 |  |  |  |  |  |  |  | C332
 |  |  |  |  |  |  |  | C337
 |  |  |  |  |  |  |  | C338
 |  |  |  |  |  |  |  | C349
 |  |  |  |  |  |  |  | C357
 |  |  |  |  |  |  |  | C358
 |  |  |  |  |  |  |  | C365
 |  |  |  |  |  |  |  | C366
 |  |  |  |  |  |  |  | C373
 |  |  |  |  |  |  |  | C380
 |  |  |  |  |  |  |  | C384
 |  |  |  |  |  |  |  | C389
 |  |  |  |  |  |  |  | C390
Spreadsheet: 9d84fe75-de66-4baa-8b7c-2387a19dc829
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5338 | 7145 | [NAME] | Matheus | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:59:02
5338 | 9919 | Danilo | Pimentel | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:59:05
5338 | 7834 | Rafael | Fonseca | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:59:59
5338 | 33644 | Diego | [NAME] | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:01:07
5338 | 7938 | [NAME] | Rivera | CHI | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:06:52
Spreadsheet: 3e130cea-42da-40b0-90ed-a2db36b917b2
Sheet: Subv socials

2014-01-28 00:00:00 | [NAME] UNIDES "Llar infantil Índia" | 1000
2014-01-28 00:00:00 | [NAME]. [NAME] | 2000
2014-01-14 00:00:00 | [NAME] 2013. [NAME] | 3500
2013-09-30 00:00:00 | Conveni col·laboració amb la Creu Roja | 18240.62
2013-09-02 00:00:00 | Projecte RIU 4a edició. | 7260
2013-05-15 00:00:00 | Associació Familiars Malalts Mentals de la Ribera | 1500
2013-05-08 00:00:00 | Conveni campany prevenció ceguera. FUNDACIÓ JORGE ALIÓ | 11850
2013-04-10 00:00:00 | Subvenció ADISALGE | 3300
2013-03-27 00:00:00 | Suvenció As. JUBILATS I PENSIONISTES ADP | 19000
2013-03-06 00:00:00 | Subvenció ASFAL | 20000
2013-02-13 00:00:00 | [NAME], 4a edició. CENTRE SUPERIOR INVESTIGACIÓ SALUT PÚBLICA | 7600
2013-02-06 00:00:00 | [NAME] UNIDES "Escoles infantils per a beduins" | 1000
2013-02-06 00:00:00 | [NAME]. [NAME] | 2000
2012-11-28 00:00:00 | Conveni col·laboració. 80% de 2012. CREU ROJA | 17761
2012-06-06 00:00:00 | [NAME], 3a edició. CENTRE SUPERIOR INVESTIGACIÓ SALUT PÚBLICA | 6000
2012-05-23 00:00:00 | Subvenció Amics de la Providència | 1000
2012-04-11 00:00:00 | Subvenció ASFAL | 14000
2012-04-11 00:00:00 | Suvenció As. JUBILATS I PENSIONISTES ADP | 19000
2012-03-13 00:00:00 | Subvenció ADISALGE | 3000
2012-03-07 00:00:00 | Aportació al Fons Valencià de Solidaritat 2012 | 8000
2012-02-29 00:00:00 | Associació Familiars Malalts Mentals de la Ribera | 1225
2012-02-01 00:00:00 | Subvenció a ALGEMESÍ SOLIDARI. [NAME] | 10000
2012-01-25 00:00:00 | [NAME]. [NAME] | 2000
2012-01-25 00:00:00 | Subvenció projecte "Mans Unides" Guatemala | 1000
2011-11-28 00:00:00 | Conveni col·laboració amb la Creu Roja (20%) | 4000
2011-09-07 00:00:00 | Conveni col·laboració. 80% de 2011. CREU ROJA | 16000
2011-05-16 00:00:00 | Aportació al Fons Valencià de Solidaritat 2011 | 11800
2011-05-11 00:00:00 | Associació Familiars Malalts Mentals de la Ribera | 1225
2011-05-04 00:00:00 | Subvenció ASFAL | 13600
2011-04-20 00:00:00 | As. JUBILATS I PENSIONISTES UDP (Activitats exercici 2010) | 19000
2011-02-23 00:00:00 | [NAME]. [NAME] | 2000
2011-02-23 00:00:00 | Subvenció projecte "Mans Unides" Índia | 1200
Spreadsheet: 846455d1697643295-issue-with-using-countifs-for-non-consecutive-cells-games-demo
Sheet: Games

Date | at/vs | W/L | Score | Winning G | Losing G | Lifetime (H) | Lifetime (A) | Lifetime Total
2019-11-07 00:00:00 | vs Reds | L | 1-3 | [NAME] | [NAME] |  | -
2020-12-03 00:00:00 | at Greens | W | 6-2 | [NAME] | [NAME]
2021-02-24 00:00:00 | vs Golds | L | 4-5 | [NAME] | [NAME] |  | -
2023-02-07 00:00:00 | at Purples | SOL | 4-5 | [NAME] | [NAME] |  | 0-1-0-1
Spreadsheet: 681798d1591754214-importing-data-from-several-sheets-indirect-vlookup
Sheet: DV-COA

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P |  | 1720.75 |  |  |  |  | 19887
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Less: 5% FVAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -76.82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2% EWT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -30.73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P |  | 1613.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount Due |  |  |  |  |  |  |  |  |  |  |  |  | P |  | 1613.2
B. Accounting Entry:
Account Title |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UACS Code |  |  |  |  |  | Debit |  |  |  |  |  | Credit
 |  | Auditing Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | 1720.75
 |  |  |  | Due to BIR - Withholding Tax on Suppliers/Creditors |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20201010 00 02 |  |  |  |  |  |  |  |  |  |  |  | 107.55
 |  |  |  | Cash - Modified Disbursement System (MDS), Regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10104040 00 |  |  |  |  |  |  |  |  |  |  |  | 1613.2 |  |  |  |  |  | 1720.75