tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125675d1319156205-yearly-planner-malbar-tourament-planner-2011_2012-junior-2
Sheet: EXAMPLE

 | 2011 |  |  |  |  |  |  |  |  |  | 2012
Quarter | Q2 |  |  |  | Q3 |  |  |  |  |  | Q4 |  |  |  |  |  | Next years planning will be Apr - Apr
Monday
Tuesday
Wednesday
Thursday |  |  |  | [NAME] |  |  |  |  |  | Welsh IS
Friday |  |  |  | [NAME] |  |  |  |  |  | Welsh IS |  |  |  | Nationals
Saturday |  |  |  | [NAME] |  | Czech IC |  |  |  | Welsh IS |  |  |  | Nationals
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prem A
Monday |  |  |  |  |  |  |  |  |  |  |  | Bank Holiday |  |  |  |  |  |  |  | Bank Holiday |  | Bank Holiday
Tuesday |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Holiday
Wednesday |  |  |  | [NAME]
Thursday |  |  |  | [NAME] |  | Bulgarian IC |  |  |  | Irish IC
Friday |  |  |  | [NAME] |  | Bulgarian IC |  |  |  | Irish IC |  |  |  |  |  |  |  | Bank Holiday
Saturday |  |  |  | Lancs Gold |  | Bulgarian IC |  | German Match (DBL) |  | Irish IC |  |  |  | York Gold
Sunday
Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Holiday
Tuesday |  |  |  | [NAME]
Wednesday |  |  |  | [NAME]
Thursday |  |  |  | [NAME] |  | Turkiye IS |  |  |  |  |  | Estonia IS
Friday |  |  |  |  |  | Turkiye IS |  |  |  |  |  | Estonia IS
Saturday |  |  |  |  |  | Turkiye IS |  |  |  |  |  | Estonia IS |  |  |  | [NAME]
Sunday
Monday
Tuesday |  |  |  |  |  |  |  |  |  | [NAME]
Wednesday |  |  |  |  |  |  |  | Scottish IC |  | [NAME]
Thursday |  |  |  |  |  |  |  | Scottish IC |  | [NAME] |  |  |  | Austrian IC |  | Polish IC
Friday |  |  |  |  |  |  |  | Scottish IC |  |  |  |  |  | Austrian IC |  | Polish IC
Saturday |  |  |  | German Match (Sun) |  |  |  | Scottish IC |  |  |  | German Match (Sun) |  | Austrian IC |  | Polish IC
Sunday |  |  |  |  |  |  |  |  |  | [NAME]
Monday |  | Bank Holiday |  |  |  |  |  |  |  | Bank Holiday
Tuesday |  | [NAME] |  |  |  |  |  |  |  | Boxing Day
Wednesday |  | [NAME]
Thursday |  |  |  | Czech IC
Friday |  |  |  | Czech IC
Saturday |  |  |  |  |  | [NAME] |  |  |  |  |  | German Match (DBL) |  |  |  | Prem A
Sunday
Monday
Tuesday
 | Key: |  |  |  |  |  | Quarterly Key:
 |  | Training Period |  |  |  |  |  | Quarter 1
 |  | Tournament |  |  |  |  |  | Quarter 2
 |  | Weekend Free |  |  |  |  |  | Quarter 3
 |  | Training Camp |  |  |  |  |  | Quarter 4
 | 12 | Czech IC |  |  | 9 | [NAME]
 | 13 | bb |  |  | 10 | [NAME]
 | 14 | vv | 12 | TC bath | 11 | [NAME]
 | 15 |  | 13 | TC bath | 12 | Club Match | 45 | boxing
 | 16 |  | 14 | TC bath | 13 | German Match
 | 17 | Scottish | 15 | Bank Hols |  |  | 34 | xmas
 | 18 | Scottish
 | 19 | Scottish
Spreadsheet: 808590d1670526537-if-a-number-ends-in-x-change-that-digit-to-another-number-digitreplacement-1-
Sheet: Sheet1

21 | 22
23 | 24
26 | 25
27 | 28
29 | 30
101 | 102
103 | 104
106 | 105
107 | 108
109 | 110
22
24
25
28
Spreadsheet: 1f66ca20-df51-461c-b5ea-ba360fdbc985
Sheet: TR_RNSP

Tariff - Regional Network Service Payments Report
TR_RNSP_<customer_id>_<settlement date>_<version>.CSV
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Customer |  |  | Pre 97 RNS Payments |  |  |  |  |  | Post 96 RNS Payments |  |  | ISO OATT Schedule 1  Payments
Customer ID | [NAME] Number | [NAME] Name | Pre 97 Revenue Required Dollars | % Dist. Based on Pre 97 Rev. Req. | $ [NAME]. Based on Pre 97 Rev. Req. | % Dist. Based on MW Mile | $ [NAME]. Based on MW Mile | Total Payment for Pre 97 RNS | Post 96 Rev. Req. Dollars | % Dist. Based on Rev. Req. | Payment for Post 96 RNS | ISO OATT Schedule 1 Cost | % Dist. Based on ISO OATT Schedule 1 Cost | ISO OATT Schedule 1 Payment for RNS | Total RNS Payment
Number | String | String | $ | Number | $ | Number | $ | $ | $ | Number | $ | $ | Number | $ | $
Spreadsheet: 99069d1297843713-countif-and-relative-offsets-from-current-cells-764567_mikejc
Sheet: Sheet1

Package | [NAME] | Second | Sprint1 | Sprint2 | Sprint3 | ProgKey
wp1 | ProgA | ProgC | 1 | 1 |  | ^ProgA^ProgC^
wp2 | ProgB |  |  | 1 |  | ^ProgB^^
wp3 | ProgD | ProgA |  | 1 | 1 | ^ProgD^ProgA^
 |  |  | Sprint1 | Sprint2 | Sprint3
 |  | ProgA | 1 | 2 | 1
 |  | ProgB | 0 | 1 | 0
 |  | ProgC | 1 | 1 | 0
 |  | ProgD | 0 | 1 | 1
Spreadsheet: e750c854-a5e9-4875-9769-120237a40a0a
Sheet: Sheet1

State Senate (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/21/2013 12:17:56 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | [NAME] | TOTALS
Bottineau | 2528 | 943 | 3471
[NAME] | 945 | 392 | 1337
Ward | 883 | 616 | 1499
TOTAL | 4356 | 1951 | 6307
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 752075d1634571013-find-first-and-second-value-return-corresponding-date-example
Sheet: sm

User ID | Name | Title | Shift | Hours | Day 1 | Day 2 | Time |  | 2021-11-24 00:00:00 | 2021-11-25 00:00:00 | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00 | 2021-12-03 00:00:00 | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 2021-12-10 00:00:00 | 2021-12-11 00:00:00 | 2021-12-12 00:00:00
e1 | L1 | Position |  |  |  |  | 07:00 - 19:00 | Days | in | in | in | M | OFF | OFF | OFF | in | in | in | in | M | OFF | OFF | OFF | in | in | in | in
Spreadsheet: 34854d1232208459-possible-combinations-of-columns-668812
Sheet: Sheet1

Cum: | 46332 | 2106 | 117 | 9
Count: | 22 | 18 | 13 | 9
 | Item1 | Item2 | Item3 | Item4
 | discount | [NAME] | Ski | goggles
 | cheap | oakley | Snowboard | pants
 | wholesale | grenade | Snow | jacket
 | best price | L1 | Snow Board | shirt
 | low price | marker | Skiing | hat
 | outlet | helly hansen | Snowboarding | beanie
 | blowout | [NAME] | Snow Boarding | gloves
 | clearance | [NAME] | snowboards | mittens
 | deep discount | salomon | snow boards | sunglasses
 | closeout | dakine | winter
 | last season | anon | mountain
 | last year | red | outdoor
 | reduced | foursquare | downhill
 | 80% off | special blend
 | 75% off | analog
 | 70% off | quiksilver
 | 65% off | roxy
 | 60% off | volcom
 | 55% off
 | 50% off
 | markdown
 | super sale
# | Permutations
1 | discount | [NAME] | Ski | goggles
2 | discount | [NAME] | Ski | pants
3 | discount | [NAME] | Ski | jacket
4 | discount | [NAME] | Ski | shirt
5 | discount | [NAME] | Ski | hat
6 | discount | [NAME] | Ski | beanie
7 | discount | [NAME] | Ski | gloves
8 | discount | [NAME] | Ski | mittens
9 | discount | [NAME] | Ski | sunglasses
10 | discount | [NAME] | Snowboard | goggles
11 | discount | [NAME] | Snowboard | pants
12 | discount | [NAME] | Snowboard | jacket
13 | discount | [NAME] | Snowboard | shirt
14 | discount | [NAME] | Snowboard | hat
15 | discount | [NAME] | Snowboard | beanie
16 | discount | [NAME] | Snowboard | gloves
17 | discount | [NAME] | Snowboard | mittens
18 | discount | [NAME] | Snowboard | sunglasses
19 | discount | [NAME] | Snow | goggles
20 | discount | [NAME] | Snow | pants
21 | discount | [NAME] | Snow | jacket
22 | discount | [NAME] | Snow | shirt
23 | discount | [NAME] | Snow | hat
24 | discount | [NAME] | Snow | beanie
25 | discount | [NAME] | Snow | gloves
26 | discount | [NAME] | Snow | mittens
27 | discount | [NAME] | Snow | sunglasses
28 | discount | [NAME] | Snow Board | goggles
29 | discount | [NAME] | Snow Board | pants
30 | discount | [NAME] | Snow Board | jacket
31 | discount | [NAME] | Snow Board | shirt
32 | discount | [NAME] | Snow Board | hat
33 | discount | [NAME] | Snow Board | beanie
34 | discount | [NAME] | Snow Board | gloves
35 | discount | [NAME] | Snow Board | mittens
36 | discount | [NAME] | Snow Board | sunglasses
37 | discount | [NAME] | Skiing | goggles
38 | discount | [NAME] | Skiing | pants
39 | discount | [NAME] | Skiing | jacket
40 | discount | [NAME] | Skiing | shirt
41 | discount | [NAME] | Skiing | hat
42 | discount | [NAME] | Skiing | beanie
43 | discount | [NAME] | Skiing | gloves
Spreadsheet: 674323d1587756552-adding-to-running-total-and-applying-carryover-rules-for-time-off-accruals-2020-02-24-oeldere-674315d1587752693-adding-to-running-total-and-applying-carryover-rules-for
Sheet: Sheet1

Name | Vacation | StartDate | YearsWorked | NextAnniversary | HoursPerYearToBeGiven | Oeldere |  |  |  | table
[NAME] |  | 2019-10-08 00:00:00 |  |  |  |  |  |  |  | 0 | 40
[NAME] |  | 2008-09-15 00:00:00 |  |  |  |  |  |  |  | 1 | 40
[NAME] |  | 2016-04-22 00:00:00 |  |  |  |  |  |  |  | 3 | 80
[NAME] |  | 2018-12-09 00:00:00 |  |  |  |  |  |  |  | 7 | 120
[NAME] |  | 2008-09-15 00:00:00
<1 Year, accrue time pro-rata up to 40 hours.
1-2 Years, accrue 40 hours on your anniversary of hire date.
3-6 Years, accrue 80 hours on your anniversary of hire date.
7+ Years, accrue 120 hours on your anniversary of hire date.
And then one can carry over hours up to but not exceeding 120 hours.
I have formulas set up where I have the calculated number of years worked based on start date, amount to be given on the anniversary date
depending on the number of years worked, and the anniversary date for the current year.
(Which I may need to rework because I'd like that to be their next anniversary date no matter what the current year is), all in separate columns.
But I'm having my biggest issue with trying to calculate a running total that would add the amount owed on their anniversary date to the total,
but not replace the current running total unless they hit their maximum accrued hours.
Hopefully that makes sense.
I've attached a sample workbook for reference. Any help is appreciated.
Attached FilesAttached Files
File Type: xlsxTestingAccruals.xlsx‎ (13.2 KB, 0 views) Download
Spreadsheet: db552a82-81f3-4f00-a085-1f93bc22c7a5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8447 | 58445 | Gwladys | Lemoussu | FRA | 21 | 00:14:54 | 00:02:07 | 00:42:08 | 00:00:27 | [NAME] | 1 | 01:29:28
Spreadsheet: 043c6db5-6e63-4684-bd60-9145e0299b0f
Sheet: Sheet1

Unnamed: 0 | University of St Thomas | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Enter your personal information on this screen. It will be propagated to all of the spreadsheets contained in this Excel workbook! Click on the tabs at the bottom of the workbook window to select the proper timesheet. The timesheet should have your name and Employee ID already filled in. All you have to do is enter your hours. Excel will total your hours and show totals at the bottom of the page.
 | First Name
 | Last Name
 | Employee ID #
 | [NAME]
 | Department
 | Exempt?
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Non-Union Faculty (FN)
 |  |  |  |  |  |  |  |  | Emp Status |  | See the Info worksheet | Mark your employment status to the right with an "X" in the appropriate box. | Done!
 |  |  |  |  |  |  |  |  | Emp Type |  |  | Mark your employment type to the right with an "X" in the appropriate box. If you are unsure which box to check, call Human Resources at x6010. | Done!
Spreadsheet: 755094d1636654405-countrows-help-customer-count
Sheet: Problem

[NAME] | Exit |  |  |  | Row Labels | Active Customers
2019-09-01 02:28:00 | 2019-09-01 03:26:00 |  |  |  | 02:00:00 | 1
2019-09-01 07:55:00 | 2019-09-01 14:43:00 |  |  |  | 03:00:00 | 1
2019-09-01 06:46:00 | 2019-09-01 09:34:00 |  |  |  | 04:00:00 | 1
2019-09-01 06:04:00 | 2019-09-01 08:00:00 |  |  |  | 05:00:00 | 1
2019-09-01 04:31:00 | 2019-09-01 05:03:00 |  |  |  | 06:00:00 | 3
2019-09-01 06:02:00 | 2019-09-01 10:04:00 |  |  |  | 07:00:00 | 5
2019-09-01 07:37:00 | 2019-09-01 09:05:00 |  |  |  | 08:00:00 | 5
2019-09-01 12:34:00 | 2019-09-01 16:09:00 |  |  |  | 09:00:00 | 5
2019-09-01 09:26:00 | 2019-09-01 12:00:00 |  |  |  | 10:00:00 | 3
2019-09-01 23:22:00 | 2019-09-02 02:05:00 |  |  |  | 11:00:00 | 2
 |  |  |  |  | 12:00:00 | 3
 |  |  |  |  | 13:00:00 | 2
Time before Midnight | Time After Midnight |  |  |  | 14:00:00 | 2
 |  |  |  |  | 15:00:00 | 1
 |  |  |  |  | 16:00:00 | 1
 |  |  |  |  | Grand Total | 10
Spreadsheet: 863701d1711102476-info-from-one-sheet-to-another-it-services-stock-control-aligw
Sheet: Total Assets Demo

IT Services - Asset Control
Asset Information |  |  | Assets Quantities
Inventory ID | Product Name | Product Description | Kingston (A) | Bridge (B) | HESC (G) | Leonardo/The Cove (E/J) | Construction (K) | The Hub (D) | Total
ITS001 | 22' Dell Monitors | 22' Dell Monitors
ITS002 | 27' Dell Monitors | 27' Dell Monitors
ITS003 | Webcams | Assorted Webcams
ITS004 | Keyboards | Assorted Keyboards
ITS005 | Mice | Assorted Mice
ITS006 | Headphones | Assorted USB Headphones
Spreadsheet: 827362d1682627768-extract-and-filter-s666-pq-extract-and-filter
Sheet: Filtered Data

Call Date | Agent Calling | Super Saver | French PT Pilot | [NAME] |  | Call Date | Agent Calling | Super Saver | French PT Pilot | [NAME]
 |  |  |  |  |  | 2023-04-03 00:00:00 | Kurt | No | No | Wi-Fi Password Issue
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Balance / Charge Inquiry
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Service Credit
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Service Reliability
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Balance / Charge Inquiry
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Signal Issue
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Signal Issue
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Service Credit
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Seasonal Location
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Limited State
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Service Reliability
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Account in Arrears
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Equipment Recovery
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | Status Inquiry
 |  |  |  |  |  | 2023-04-03 00:00:00 | Kurt | No | No | Feature Issue
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Equipment
 |  |  |  |  |  | 2023-04-03 00:00:00 | Amanda | No | No | New Physical Location
 |  |  |  |  |  | 2023-04-03 00:00:00 | Kurt | No | No | Network Outage / Degradation
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Equipment not Registered
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Service Credit
 |  |  |  |  |  | 2023-04-03 00:00:00 | [NAME] | No | No | Work Order Credit
 |  |  |  |  |  | 2023-04-04 00:00:00 | Kurt | No | No | 3rd Party Router Issue
 |  |  |  |  |  | 2023-04-04 00:00:00 | [NAME] | No | No | Package Pricing
 |  |  |  |  |  | 2023-04-04 00:00:00 | [NAME] | No | No | Package Pricing
 |  |  |  |  |  | 2023-04-04 00:00:00 | Kurt | No | No | Customer Expectations
 |  |  |  |  |  | 2023-04-04 00:00:00 | [NAME] | No | No | Package Pricing
 |  |  |  |  |  | 2023-04-04 00:00:00 | Kurt | No | No | New Offer Available
 |  |  |  |  |  | 2023-04-04 00:00:00 | Amanda | No | No | Contact Information
 |  |  |  |  |  | 2023-04-04 00:00:00 | Amanda | No | No | Transfer Status Inquiry
 |  |  |  |  |  | 2023-04-04 00:00:00 | [NAME] | No | No | Username / Password Related
 |  |  |  |  |  | 2023-04-04 00:00:00 | Amanda | No | No | Balance / Charge Inquiry
Spreadsheet: sally_beck__35045__Open_Issues
Sheet: TimeLines

 |  |  |  | Actual |  |  | Conversion Cutover Project
 |  |  |  | AR/AP/Accrual/ IC |  |  | Unify - AR Conversion testing
 | [NAME] | SAP Planned | Duration | Start | End |  | Start | End
 | Complete Requirements | 2000-01-31 00:00:00 |  |  | 2000-03-31 00:00:00
 | Complete Specifications | 2000-02-04 00:00:00 |  |  | 2000-03-31 00:00:00
 | Complete Development & System-to-Sys. Test | 2000-03-31 00:00:00 |  |  | 2000-04-14 00:00:00
 | Unit Testing |  |  |  | 2000-04-14 00:00:00
 | FIT 1 |  | 10 days | 2000-04-17 00:00:00 | 2000-04-28 00:00:00
 | Unit Test/ Error Correction |  | 5 days | 2000-05-01 00:00:00 | 2000-05-05 00:00:00
 | FIT 2 |  | 10 days | 2000-05-08 00:00:00 | 2000-05-19 00:00:00 |  | 2000-04-24 00:00:00
 | FIT 3 |  | 5 days | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 |  | 2000-05-15 00:00:00
 | FIT 4 ? - financials
 | SAP configuration lockdown - no testing |  |  | 2000-06-02 00:00:00 | 2000-07-02 00:00:00
 | SAP Production Implementation |  |  | 2000-07-03 00:00:00
 | Significant obstacles during the process:
 | 2000-04-07 00:00:00 | Losing 2 1/2 testing days due to the SAP unit test environment being down
 | 2000-04-10 00:00:00 | Started unit testing the inter-company logic this morning and I noticed that the SAP inter-company tables were not populated with data for our unit test cases
 |  | During FIT 1 testing, I/C data delayed for 3 days into the process, reducing the feedback process
 | 2000-05-08 00:00:00 | Made the Monday 8:00am target for all Jan-Mar I/C, 3rd party files.  However, the I/C tables do not have the correct data, resulting in downtime
 |  | from sending complete I/C data.  This will add 2 days to turnaround on obtaining feedback.
Spreadsheet: 815655d1675130061-avoid-index-small-row-array-formula-to-include-blank-cells-example
Sheet: Sheet2

Full Name | Position | Line Manager | Start Date | :D
Oktyabrina [NAME]
[NAME]
Cunobelinos Caren
Fariha Kumari
Rio Kiki
Alojz [NAME]
Love Nehuén
[NAME]
Thaddeus Wâpanacâhkos
Ottaviano Opaline
Spreadsheet: 725492d1616695706-value-error-from-edate-function-inside-an-if-statment-to-get-one-of-two-numbers-the-problem
Sheet: Sheet1

Base Rent | Increase Sent | Increases On | New Rent | January
1000 | 2020-01-01 00:00:00 |  |  | 1000
1000 | 2020-03-01 00:00:00 |  |  | 1000
1000 | 2020-08-01 00:00:00 |  |  | 1000
1000 | 2020-01-01 00:00:00 |  |  | 1000
1000 | 2020-01-01 00:00:00 |  |  | 1000
1000 | 2021-01-01 00:00:00 |  |  | 1000
1000 | 2020-01-01 00:00:00 |  |  | 1000
1000 | 2020-01-01 00:00:00 |  |  | vacant
1000 | 2020-10-01 00:00:00 |  | 2000 | vacant
1000 | 2020-08-01 00:00:00 |  |  | 1000
 |  |  | 13000
 |  |  | Correct Value | -3000
 |  |  | Expected Total Loss
 |  |  | Expected Total Ignoring values in the "New Rent Column" Loss
 |  |  | Month | 1
Spreadsheet: 119781d1314737724-transpose-a-reference-film-run-times-8-22-
Sheet: copy

 |  | [NAME] | 02:40:00 | 04:50:00 | 07:00:00 | 09:10:00 |  |  |  |  |  |  |  | [NAME] | 01:59:00 | 2000ft | FLAT | mp4 trailers: | [NAME] (____) | Bring Me the Head (____) | Man Who Fell To Earth (____) | Feature (_____)
2011-07-12 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Boom | 02:03:00 | 2000ft | SCOPE | No trailers
 |  | Tree of Life | 03:00:00 | 06:00:00 | 09:00:00 |  |  |  |  |  |  |  |  | [NAME] | 01:40:00 | platter | FLAT | mp4 trailers: | Beats (U) | [NAME] (U) | [NAME] (U) | [NAME] (-5) | Feature (4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | The Trip | 01:57:00 | platter | FLAT | mp4 trailers: | The Future (U) | [NAME] (-5) | [NAME] (U) | Beats (U) | Tablloid (U) | Feature (5)
 |  | [NAME] | 02:40:00 | 04:50:00 | 07:00:00 | 09:10:00 |  |  |  |  |  |  |  | Tree of Life | 02:30:00 | platter | FLAT | 35mm trailers: | The Future (4.5) | The Trip (5.0) | Tablloid (5.5) | [NAME] (5.5) | Feature (7.7 SR.D)
2011-07-13 00:00:00 | Wed |  |  |  |  |  |  |  |  |  |  |  |  | Wrecking crew | 01:37:00 | Digibeta | 16x9 | No trailers
 |  | Tree of Life | 03:00:00 | 06:00:00 | 09:00:00
 |  | [NAME] | 02:40:00 | 04:50:00 | 07:00:00 | 09:10:00
2011-07-14 00:00:00 | Thur
 |  | Tree of Life | 03:00:00 | 06:00:00 | 09:00:00
 |  | [NAME] | 02:40:00 | 04:50:00 | 07:00:00 | The Trip | 09:15:00
2011-07-15 00:00:00 | Fri
 |  | Tree of Life | 03:00:00 | 06:00:00 | 09:00:00
 |  | 09:30:00 | [NAME] | 12:15:00 | Boom | 02:30:00 | [NAME] | 04:50:00 | 07:00:00 | The Trip | 09:15:00
2011-07-16 00:00:00 | Sat | 11:30:00
 |  | Tree of Life | 12:00:00 | 03:00:00 | 06:00:00 | 09:00:00
 |  | [NAME] | 11:40:00 | 01:40:00 | 03:40:00 | The Trip | 05:40:00 | [NAME] | 08:00:00 | Boom | 10:15:00
2011-07-17 00:00:00 | Sun
 |  | Tree of Life | 12:00:00 | 03:00:00 | 06:00:00 | 09:00:00
 |  | [NAME] | 03:20:00 | The Trip | 05:20:00 | [NAME] | 07:40:00 | The Trip | 09:40:00
2011-07-18 00:00:00 | Mon
 |  | Tree of Life | 03:00:00 | 06:00:00 | 09:00:00
 |  | [NAME] | 03:20:00 | The Trip | 05:20:00 | [NAME] | 07:40:00 | The Trip | 09:40:00
2011-07-19 00:00:00 | [NAME]
 |  | Tree of life | 03:00:00 | 06:00:00 | 09:00:00
 |  | [NAME] | 03:20:00 | The Trip | 05:20:00 | [NAME] | 07:40:00 | The Trip | 09:40:00
2011-07-20 00:00:00 | Wed
 |  | Tree of Life | 03:00:00 | 06:00:00 | 09:00:00
 |  | [NAME] | 02:30:00 | 04:30:00 | Wrecking Crew | 07:00:00 | The Trip | 09:40:00
2011-07-21 00:00:00 | Thur
 |  | Tree of Life | 03:00:00 | 06:00:00 | 09:00:00
Spreadsheet: 818106d1676589958-if-and-or-q-and-d-feb-with-summary-end
Sheet: 9th

1 | Defect ID | Unit ID | Unit Date | Prod Date | Act Date | Shift | Year | Serial | z | ID #1 | ID #2 | ID #3 | Product | Color #1 | Color #2 | Part | Location | Concern | [NAME] | Rank | Grid Label | Responsible Area | Responsible Cell | Recording User | Recording Area | Recording Cell | Recording Station | Defect Status | Root Cause | Root Cause User | Comments | sequence no | 1st | 2nd | 3rd | Date
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 879020d1726459193-auto-number-generate-with-conditions-tps_srno_1509-tpsdas-
Sheet: tbl_Data

Deno | Attribute | Value | Time | Rank
111 | [NAME] | 2024-01-01 00:00:00 |  |  |  |  | IF([@Attribute]="Receipt Dt",SUM([@Value],[@Deno]/10000),SUM([@Value],0.99))
111 | [NAME] | 2024-01-01 00:00:00
111 | Return Dt | 2024-01-01 00:00:00
222 | [NAME] | 2024-01-01 00:00:00
222 | Return Dt | 2024-01-01 00:00:00
111 | Return Dt | 2024-01-02 00:00:00
444 | [NAME] | 2024-01-02 00:00:00
444 | [NAME] | 2024-01-02 00:00:00
555 | [NAME] | 2024-01-02 00:00:00
444 | Return Dt | 2024-01-02 00:00:00
444 | Return Dt | 2024-01-02 00:00:00
555 | Return Dt | 2024-01-02 00:00:00