tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65004bf4-763d-463b-ad19-cf57b97719f1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  |  | Why ATP?
-Factory remanufactured units using the highest quality parts to OE specifications means less combacks.
 | *All internal and external parts are rigorously, thoroughly tested and replaced if out of O.E. specifications.
 | *100% replacement of all bearings and seals.
 | *No gambling with used or questionable quality remaned units.
-Cleaned, painted and complete units delivered directly to your location.
-All gear ratios in stock and available.
-The 5 year/100,000 mile, industry leading, warranty is unique to ATP.
-No core program.  The installer can boost profit margins by selling The old unit and make more money.
-Electronic cataloging highlighting ratio identification methods, not available from [NAME], 4x4 specialists, etc.
 | *Gets the installer the right part the first time.
-The ATP brand name is nationally known and recognized with a reputation for extremely high quality, innovative products.
 | *ATP is a company which proudly stands behind our products.
 | *95.5% of all survey respondents would purchase these products from ATP.
-The ATP customer commitment is backed by  customer service and technical departments which are second to none.
-Product is well suited to 2-step distribution.
-Yet another quality product in the ever growing Driven by ATP product category.
Spreadsheet: 7bb1ce3c-02ee-40b0-83fe-ea22f9e60235
Sheet: Sheet1

Low Birthweight by Year, Births to Maine Women, 2000-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Live Births Weighing Less Than 2500 Grams
Year |  | Number | %* | 95% CI
2000 |  | 819 | 6 | 5.6 - 6.5
2001 |  | 831 | 6 | 5.6 - 6.5
2002 |  | 855 | 6.3 | 5.9 - 6.8
2003 |  | 904 | 6.5 | 6.1 - 7.0
2004 |  | 894 | 6.4 | 6.0 - 6.9
2005 |  | 963 | 6.8 | 6.4 - 7.3
2006 |  | 971 | 6.9 | 6.4 - 7.3
2007 |  | 892 | 6.3 | 5.9 - 6.8
2008 |  | 910 | 6.7 | 6.3 - 7.1
2009 |  | 852 | 6.3 | 5.9 - 6.8
2010 |  | 811 | 6.3 | 5.9 - 6.7
Data Source: Birth certificate datasets obtained from the Office of Data, Research and Vital Statistics, Maine Center for Disease Control and Prevention.
* Percents are based on live births with known birth weights.
CI: Confidence Interval.
Spreadsheet: 456780d1461059976-conditional-formatting-example-file
Sheet: Vakanties

 |  | April
 |  | 2016-04-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00 | 1900-01-30 00:00:00
 | Name 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Name 2
 | Name 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Name 4
 | Name 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1
 | Name 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | Name 7
 | Name 8
 | Name 9
 | Name 10
 | Name 11 | 1
 | Name 12
 | Name 13 |  |  |  |  |  |  | z | z |  |  | z | z | z | z | 1
 | Name 14
 | Name 15
 | Name 16
Spreadsheet: 849626d1700052978-help-request-for-two-accurate-formulas-for-a-report-of-pivot-table-data-in-excel-excel-help-req-15-11-23-amended
Sheet: Report-Result Sheet

 | Today's Coupon Summary |  |  |  |  |  |  |  |  |  | Table 140
 | Nature of operation | Coupon Date | Name of Customer | Customer Quantitative Data |  |  |  | Customer Qualitative Data
 |  |  |  | Currency | Issue Date | Face Value of Investment | Tenor | Certificate # | GL Number | BANK A/C Number | Classification
 | Maturity
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 1

 | Jan 11 | Jan 18 | Jan 25 | Feb 1 | Feb 8
Total Interest Rate* | 380218108 | 385395440 | 388372022 | 395042431 | 391358938
Cleared** | 175639239 | 178792699 | 181091559 | 185636032 | 183646769
Uncleared | 204578869 | 206602742 | 207280462 | 209406399 | 207712170
Total Cross-Currency | 16747192 | 17016046 | 16743138 | 16797419 | 16700745
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 16747192 | 17016046 | 16743138 | 16797419 | 16700745
Total Credit | 20885424 | 20946955 | 21141040 | 21386489 | 21231525
Cleared | 2606053 | 2624288 | 2665557 | 2693840 | 2582325
Uncleared | 18279372 | 18322667 | 18475483 | 18692649 | 18649200
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 420941724 | 426449441 | 429347200 | 436317339 | 432382208
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: andy_zipper__167__DYNEGY-ICE VOL Apr11
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
Power | [NAME] | 1 | 800 |  | Power | [NAME] | 4 | 23200 |  | (blank) | No Activity | 1 | 0
Power Total |  | 1 | 800 |  |  | [NAME] | 2 | 1600 |  | (blank) Total |  | 1 | 0
US Natural Gas | [NAME] | 2 | 15000 |  |  | [NAME] | 2 | 900 |  | Grand Total |  | 1 | 0
 | [NAME] | 5 | 9520000 |  | Power Total |  | 8 | 25700
 | [NAME] | 2 | 10000 |  | Grand Total |  | 8 | 25700
 | [NAME] | 1 | 5000
 | [NAME] | 2 | 2150000
US Natural Gas Total |  | 12 | 11700000
Grand Total |  | 13 | 11700800
Spreadsheet: 3bdfc34c-fdf4-4599-b424-0bfcd3a3f196
Sheet: Budget Summary

FMPP Applicant Proposed Budget Summary
Project Title:
Organization:
Phone:
Contact:
Contact Email:
 | This budget includes items/purchases for a new EBT project
 | This budget includes items/purchases for an exisitng EBT project
 |  |  |  | This Column for FMPP Staff Use Only:
 |  | Requested | Requested Budget
Budget Summary Itemization: |  | Budget | Totals | Revised/Approved
Personnel:
 | Total Personnel
Contractual:
 | Total Contractual
Travel:
 | Total Travel
Equipment:
 | Total Equipment
Supplies:
 | Total Supplies
Other:
 | Total Other
 | Total Direct
Indirect Cost (maximum 10% of total budget (before indirect)):
Must provide a written explanation detailing what this line item covers; no indirect costs will be approved without an explanation.
 | Indirect Percentage of Total Budget
 | TOTAL
Organization:
Project Title:
Supplemental Budget Summary Narrative:  Add additional lines, as needed.
According to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to a collection of information unless it displays a valid OMB control number.  The valid OMB control number for this information collection is 0581-0235.  The time required to complete this information collection is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.  The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, age, disability, and where applicable sex, marital status, or familial status, parental status religion, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual’s income is derived from any public assistance program (not all prohibited bases apply to all programs).  Persons with disabilities who require alternative means for communication of program information (Braille, large print, audiotape, etc.) should contact USDA’s TARGET Center at (202) 720-2600 (voice and TDD).  To file a complaint of discrimination, write USDA, Director, Office of Civil Rights, 1400 Independence Avenue, SW, Washington, DC 20250-9410 or call (800) 795-3272 (voice) or (202) 720-6382 (TDD).  USDA is an equal opportunity provider and employer.
Spreadsheet: 51829d1251431568-countif-and-index-formula-movement-bill
Sheet: DataSheet

 |  |  | BILL # 01
MOVEMENT AREA | TAKA
BOGRA | 3600
BOGRA | 3600
BOGRA | 3700
COX'S BAZAR | 9200
COX'S BAZAR | 9200
KONABARI | 3200
KONABARI | 4200
KONABARI | 4200
RANGPUR | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4600
KONABARI | 4600
DINAJPUR | 4600
DINAJPUR | 4600
DINAJPUR | 4800
KONABARI | 4800
KONABARI | 4800
KONABARI | 4800
KONABARI | 4800
CHITTAGONG | 4800
CHITTAGONG | 4800
PABNA | 5200
TANGAIL | 5200
KUSHTIA | 1300
KUSHTIA | 1300
KUSHTIA | 1600
M. BAZAR | 7200
PABNA | 3600
TANGAIL | 4600
Spreadsheet: 230999d1366916753-group-scores-based-on-value-in-first-column-tournament_excelforum_jlm099
Sheet: Sheet1

DATA
tournament | [NAME] | [NAME] | [NAME] | [NAME] | Player B1 | Pts B1 | Player B2 | Pts B2
Tournament 1 | [NAME] | 1 | [NAME] | 1 | Anna | 1 | [NAME] | 1
Tournament 1 | [NAME] | 0 | [NAME] | 0 | [NAME] | 2 | [NAME] | 2
Tournament 1 | [NAME] | 2 | [NAME] | 2 | [NAME] | 0 | [NAME] | 0
Tournament 2 | [NAME] | 2 | [NAME] | 2 | [NAME] | 0 | [NAME] | 0
Tournament 2 | [NAME] | 1 | Anna | 1 | [NAME] | 1 | [NAME] | 1
...
Tournament N | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1
Tournament N | [NAME] | 2 | [NAME] | 2 | [NAME] | 0 | [NAME] | 0
OUTPUT I WOULD LIKE TO ACHIEVE:
SCORES | Tournament
 | ALL | Tournament 1 | Tournament 2 | ... | Tournament N
Anna |  |  |  | …
[NAME] |  |  |  | …
[NAME] |  |  |  | …
[NAME] |  |  |  | …
[NAME] |  |  |  | …
[NAME] |  |  |  | …
[NAME] |  |  |  | …
[NAME] |  |  |  | …
Spreadsheet: 886909d1737016032-calculcate-total-values-number-values-based-of-meeting-specific-date-range-excel-between-dates
Sheet: Sheet1

 | DATA | Amount | Beginning | End
 |  | 6000 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
 |  | 500 | 2024-03-01 00:00:00 | 2024-06-01 00:00:00
 |  | 750 | 2024-01-01 00:00:00 | 2025-07-01 00:00:00
 | Condition date | Total amount which meets this date? | Solution
 | 2024-01-01 00:00:00 | ? | 6750
 | 2024-02-01 00:00:00
 | 2024-03-01 00:00:00
 | 2024-04-01 00:00:00
 | 2024-05-01 00:00:00
 | 2024-06-01 00:00:00
 | 2024-07-01 00:00:00
 | 2024-08-01 00:00:00
 | 2024-09-01 00:00:00
 | 2024-10-01 00:00:00
 | 2024-11-01 00:00:00
 | 2024-12-01 00:00:00
 |  |  | Question | What is the total amount of column C with the criteria of column B?
 |  |  |  | E.g. the total amount of C3-C5 with conditon date [NAME] and so on?
Spreadsheet: 168792d1342582144-how-do-i-get-excel-to-make-a-master-sheet-from-sub-sheets-phonestest
Sheet: ATT

Name | Phone Number | Phone Type | Provider | Program | Status
[NAME] | (123)123-456 | [NAME] | AT&T | WAP | Out Of Contract
fred blogs | (123)321-654 | [NAME] | AT&T | WAP | Out Of Contract
[NAME] | (123)231-546 | [NAME] | AT&T | WAP | Out Of Contract
Spreadsheet: 69616d1270149851-poker-points-standings-poker-results
Sheet: Sheet1

 |  | Results |  |  |  |  |  |  |  |  |  |  | Player | Tot Season Pts
Week | Player Ct | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | [NAME] | 83 | This should equal 83
1 | 7 | [NAME] | Wayne | Eddie | [NAME] | [NAME] | Heath | J |  |  |  |  | Wayne | 61
2 | 8 | [NAME] | J | Heath | Wayne | [NAME] | Eddie | [NAME] | [NAME] |  |  |  | Eddie | 53
3 | 5 | [NAME] | [NAME] | Heath | Eddie | Wayne |  |  |  |  |  |  | [NAME] | 58
4 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 25
5 | 6 | Eddie | J | [NAME] | Heath | [NAME] | [NAME] |  |  |  |  |  | Heath | 53
6 | 4 | Heath | Wayne | Eddie | [NAME] |  |  |  |  |  |  |  | J | 56
7 | 4 | Heath | [NAME] | [NAME] | Eddie |  |  |  |  |  |  |  | [NAME] | 1
8 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
9 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12
10 | 8 | J | Wayne | [NAME] | [NAME] | Heath | Eddie | [NAME] | [NAME]
11 | 4 | Wayne | Eddie | [NAME] | J
12 | 4 | J | Heath | Wayne | [NAME]
13 | 6 | [NAME] | Wayne | Eddie | [NAME] | Heath | J
14 | 6 | J | Wayne | Eddie | [NAME] | [NAME] | Heath
15 | 4 | [NAME] | [NAME] | Eddie | [NAME]
16 | 5 | Wayne | Eddie | Heath | [NAME] | J
17 | 6 | [NAME] | [NAME] | Eddie | Heath | Wayne | [NAME]
18 | 6 | [NAME] | Heath | [NAME] | Wayne | J | [NAME]
19 | 8 | J | [NAME] | [NAME] | [NAME] | [NAME] | Eddie | Wayne | Heath
20 | 6 | [NAME] | Wayne | [NAME] | Heath | J | [NAME]
21 | 6 | [NAME] | Eddie | [NAME] | J | Heath | [NAME]
22 | 6 | [NAME] | [NAME] | Wayne | J | Heath | Eddie
Spreadsheet: 844226d1695975637-workout-log-stats-not-calculate-the-full-week-blank-workouttracker-h
Sheet: Progress

Progress Report |  |  |  | Set 1 |  |  | Set 2 |  |  | Set 3 |  |  | Set 4 |  |  | Set 5 |  |  | Total
Category: | Biceps |  | Dates | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total
Exercise: | Barbell curl |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Month Averages (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout | ←←←←←←←← | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Second Month Average (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third Month Average (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Three Month OverALL Average (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ↑
 |  |  | =LET(t,DROP(REDUCE("",H2:H7,LAMBDA(i,x,IF(x="",i,VSTACK(i,INDIRECT("'"&x&"'!A10:[NAME],INDEX(t,,2)<>""))
Spreadsheet: 839904d1692287401-finding-partial-text-in-two-arrays-and-returning-one-or-more-values-listed-in-second-array-partial-match-of-arrays-example-4-
Sheet: Result

Narrative | Matching Key Word? | Predetermined Key Words
Professional football players used to wear leather helms. | helmet; Football | width
Many professional athletes are adept at playing many different sports. | adept | height | adept
How was the width and height of the modern football goal posts determined? | width; height; Football | helmet | width; height; Football
Baseball players wear helmets as well. | helmet | adept | helmet
Soccer players don't wear helmets, but due to the many head injuries, perhaps they should. | helmet | Football | helmet
Spreadsheet: 125103d1318878430-summarizing-for-pivot-table-testdatals_v2
Sheet: LeaderScriptMaster

ID | Username | First Name | Last Name | Address | City | State | Zip | Grad Year | School | Degree | Category | Position | Activity | Start Date | End Date | Description | Hours | Submit Date | UniqPerCat
5409 | Jfrank | [NAME] | Franklin | 2800S State St. | [NAME] | AK | 44444 | 2010 | Arizona School of Health Sciences | Occupational Therapy | Leadership | President | Student Occupational Therapy Association | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | Organized events by creating emails, power points and schedules for participants. | 4 | 2009-09-20 01:06:00
6187 | Rlake | [NAME] | Lake | 6360 Iron Road | Bishop | ND | 55555 | 2011 | Kirksville College of Osteopathic Medicine | DO | Development | Member | Student Osteopathic Medical Association | 2007-09-01 00:00:00 | 2011-06-30 00:00:00 | Active member of HHR | 1 | 2009-01-05 14:24:00
3537 | [NAME] | [NAME] | Nair | 404 [NAME] | Main | AK | 41110 | 2009 | Kirksville College of Osteopathic Medicine | Doctor of Osteopathic Medicine | Service | Attendee | American Medical Student Association | 2005-10-21 00:01:00 | 2005-10-21 23:59:00 | Attended a presentation on educating patients on diabetes care. Presenters included a nurse and a dietician. | 8 | 2006-05-29 11:27:00
3539 | Plaird | [NAME] | [NAME] | 89 Elm Ave | Cape | MO | 63501 | 2014 | Kirksville College of Osteopathic Medicine | Doctor of Osteopathic Medicine | Service | [NAME] | Roadside Clean-up | 2005-11-16 00:01:00 | 2005-11-16 23:59:00 | [NAME] has adopted a road near campus which we clean-up periodically. | 12 | 2006-05-29 11:30:00
3540 | Plaird | [NAME] | [NAME] | 90 Elm Ave | Cape | MO | 63501 | 2014 | Kirksville College of Osteopathic Medicine | Doctor of Osteopathic Medicine | Service | [NAME] | Roadside Clean-up | 2005-11-16 00:01:00 | 2005-11-16 23:59:00 | [NAME] has adopted a road near campus which we clean-up periodically. | 13 | 2006-05-30 11:29:59.995000
3543 | [NAME] | [NAME] | Nair | 404 [NAME] | Main | MO | 63501 | 2009 | Kirksville College of Osteopathic Medicine | Doctor of Osteopathic Medicine | Development | Attendee | Presentation on Choosing a Residency | 2006-01-11 00:01:00 | 2006-01-11 23:59:00 | Two residents presented information regarding choosing and being accepted into a residency. | 1 | 2006-05-29 11:39:00
5834 | Msmith | Misty | Smith | 4 Main St. | Birmingham | AL | 35023 | 2011 | School of Osteopathic Medicine in Arizona | Doctorate of Osteopathy | Leadership | Student Ambassador | Student Ambassadors | 2007-08-01 00:01:00 | 2011-07-31 23:59:00 | Attended health fairs and guest spoke at premedical club meetings at various undergraduate universities. | 1 | 2008-08-29 10:28:00
7649 | Rspring | [NAME] | Spring | 2 Stain  St. | Garner | AL | 35023 | 2014 | School of Osteopathic Medicine in Arizona | Doctorate of Osteopathy | Leadership | Class Representative | OSMA Graduation Committee | 2010-04-01 00:01:00 | 2011-06-01 23:59:00 | Class of 2011 representative to the ATSU-SOMA Graduation Committee. | 5 | 2010-07-11 11:06:00
Spreadsheet: 775434d1649098066-if-cell-not-equal-to-n-a-return-cell-contents-book1
Sheet: Sheet1

#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | Pluto | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Zippy | #N/A | #N/A | #N/A
Gonzo | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | Daffy | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 117829d1313060036-help-with-changing-data-in-measure-cell-according-to-other-data-ronel
Sheet: Sheet1

 |  | Resource | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure
Month | 2011-08-01 00:00:00 | Juanita |  |  |  |  |  |  | Manual ST3 | Russian
Wd |  | Toni |  |  |  |  |  |  | Manual ST4 | Dutch
Leave | 0 | Ronel |  |  |  |  |  |  | Manual ST3
Sick days | 0 | [NAME] |  |  |  |  |  |  | Support Docs
[NAME] new project line
 |  |  |  | Languages | Juanita | Ronel | [NAME] | [NAME] | [NAME] | Lauren | Anne | Angelique | Toni
 |  |  |  | Chinese | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.75 | 0.75
 |  |  |  | Dutch | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.75 | 0.75
 |  |  |  | English UK | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.75 | 0.75
 |  |  |  | English US | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.75 | 0.75
 |  |  |  | French | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.75 | 0.75
 |  |  |  | German | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.5 | 0.5
 |  |  |  | Hungarian | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.5 | 0.5
 |  |  |  | Indonesian | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.5 | 0.5
 |  |  |  | Italian | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.5 | 0.5
 |  |  |  | Korean | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.75 | 0.75
 |  |  |  | Polish | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.5 | 0.5
 |  |  |  | Portuguese | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.5 | 0.5
 |  |  |  | Russian | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.5 | 0.5
 |  |  |  | Spanish | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.75 | 0.75
 |  |  |  |  | Measure | Pages pd
 |  |  |  |  | 0.25 | 25
 |  |  |  |  | 0.5 | 50
 |  |  |  |  | 0.75 | 75
 |  |  |  |  | 1 | 100
Spreadsheet: 739553d1625770265-how-to-calculate-sla-weekends-included-calculating-the-excpected-finish-time-for-task-azzo-
Sheet: Sheet1

Classification | Date & Time Received | SLA Due
CASE 1 | 2021-07-01 11:56:13 |  |  |  |  |  |  |  |  |  |  |  |  | Holiday | Description |  | Types of Enquiries | SLA Hours |  | Working Hours Start | Working Hours End
CASE 1 | 2021-07-02 11:56:13 |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-10 00:00:00 | Queen's Birthday |  | CASE 1 | 16:00:00 |  | 09:00:00 | 17:00:00
CASE 3 | 2021-07-04 16:56:13 |  |  |  |  |  | Working Hours Start | Working Hours End |  | [NAME] | SLA Hours |  |  | 2021-10-04 00:00:00 | Labour Day |  | CASE 2 | 2:00:00 |  | 08:00:00 | 20:00:00
CASE 7 | 2021-06-09 16:00:00 |  |  |  |  | Mon-Fri | 08:00:00 | 20:00:00 |  | CASE 1 | 16:00:00 |  |  | 2021-12-27 00:00:00 | Christmas Day |  | CASE 3 | 16:00:00
CASE 4 | 2021-10-03 07:54:00 |  |  |  |  | Sat-Sun | 09:00:00 | 17:00:00 |  | CASE 2 | 2:00:00 |  |  | 2021-12-28 00:00:00 | Boxing Day |  | CASE 4 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 3 | 16:00:00 |  |  |  |  |  | CASE 5 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 4 | 2:00:00 |  |  |  |  |  | CASE 6 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 5 | 2:00:00 |  |  |  |  |  | CASE 7 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 6 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 7 | 2:00:00
 |  |  |  |  |  |  | Holiday | Description
 |  |  |  |  |  |  | 2021-06-10 00:00:00 | Queen's Birthday
 |  |  |  |  |  |  | 2021-10-04 00:00:00 | Labour Day
 |  |  |  |  |  |  | 2021-12-27 00:00:00 | Christmas Day
 |  |  |  |  |  |  | 2021-12-28 00:00:00 | Boxing Day
Classification | Date & Time Received | SLA Due | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
CASE 1 | 2021-07-01 11:56:13
CASE 1 | 2021-07-02 11:56:13
CASE 3 | 2021-07-04 16:56:13
CASE 3 | 2021-06-09 16:00:00
CASE 4 | 2021-10-03 07:54:00
CASE 7 | 2021-06-09 16:00:00