tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 539016d1505924286-sort-by-month-into-two-separate-columns-s666v2-1201700-sort-by-month-into-two-separate-columns
Sheet: Sheet1

Item Code | PO Date | Unit Cost | Qty Received |  | Sum of Unit Cost
APT171750 | 2017-08-02 00:00:00 | 93.5 | 20 |  |  | 2017-07-05 00:00:00 | 2017-07-13 00:00:00 | 2017-07-14 00:00:00 | 2017-07-18 00:00:00 | 2017-07-19 00:00:00 | 2017-07-24 00:00:00 | 2017-08-02 00:00:00 | 2017-08-07 00:00:00 | 2017-08-08 00:00:00 | 2017-08-09 00:00:00 | 2017-08-10 00:00:00 | 2017-08-11 00:00:00 | 2017-08-15 00:00:00 | 2017-08-16 00:00:00 | 2017-08-23 00:00:00 | 2017-08-24 00:00:00 | 2017-08-29 00:00:00
APT84 | 2017-08-10 00:00:00 | 100.03 | 2 |  | APT171750 |  |  |  |  |  |  | 93.5
APT84BD | 2017-07-18 00:00:00 | 112.53 | 20 |  | APT84 |  |  |  |  |  |  |  |  |  |  | 100.03
APT84BD | 2017-08-02 00:00:00 | 112.53 | 20 |  | APT84BD |  |  |  | 112.53 |  |  | 112.53 |  |  |  |  |  |  |  | 112.53
APT84BD | 2017-08-23 00:00:00 | 112.53 | 10 |  | APT8626S |  |  |  | 100.02 |  |  | 100.02 |  |  |  |  |  |  |  | 100.02
APT8626S | 2017-07-18 00:00:00 | 100.02 | 20 |  | APT88RENEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 126.19
APT8626S | 2017-08-02 00:00:00 | 100.02 | 20 |  | APTBIONOVUSE |  | 85
APT8626S | 2017-08-23 00:00:00 | 100.02 | 20 |  | APTEZBIO14 |  | 110 |  | 110 |  |  |  |  |  | 110 |  |  |  |  |  | 110
APT88RENEW | 2017-08-23 00:00:00 | 126.19 | 10 |  | APTFP17A |  | 83 |  |  |  |  |  |  |  |  |  |  | 166
APTBIONOVUSE | 2017-07-13 00:00:00 | 85 | 48 |  | APTMPDCB |  |  |  |  |  |  |  |  | 90 |  |  |  | 90 |  |  |  | 90
APTEZBIO14 | 2017-07-13 00:00:00 | 110 | 36 |  | B1150CT-A |  |  | 38 |  |  |  |  |  |  |  |  |  | 38
APTEZBIO14 | 2017-07-18 00:00:00 | 110 | 144 |  | BB12231 |  |  |  |  |  | 34.45
APTEZBIO14 | 2017-08-09 00:00:00 | 110 | 72 |  | BB1517I |  |  |  |  |  |  |  |  |  |  |  |  |  | 258
APTEZBIO14 | 2017-08-24 00:00:00 | 110 | 72 |  | BB45 |  |  |  |  |  |  | 32
APTFP17A | 2017-07-13 00:00:00 | 83 | 80 |  | BB685I | 18 |  |  |  |  |  |  | 16.4 |  |  |  |  |  | 36 |  |  | 18
APTFP17A | 2017-08-15 00:00:00 | 83 | 10 |  | BB685P |  |  |  |  | 39.1 |  |  |  |  |  |  |  |  |  | 41.054
APTFP17A | 2017-08-15 00:00:00 | 83 | 80 |  | BB912I |  |  |  |  |  | 15 | 15 | 13.9 |  |  |  | 15 |  | 15 |  |  | 14.55
APTMPDCB | 2017-08-08 00:00:00 | 90 | 60
APTMPDCB | 2017-08-15 00:00:00 | 90 | 10
APTMPDCB | 2017-08-29 00:00:00 | 90 | 60
B1150CT-A | 2017-07-14 00:00:00 | 38 | 50
B1150CT-A | 2017-08-15 00:00:00 | 38 | 10
BB12231 | 2017-07-24 00:00:00 | 34.45 | 4
BB1517I | 2017-08-16 00:00:00 | 129 | 0
BB1517I | 2017-08-16 00:00:00 | 129 | 1
BB45 | 2017-08-02 00:00:00 | 32 | 1
BB685I | 2017-08-07 00:00:00 | 16.4 | 35
BB685I | 2017-07-05 00:00:00 | 18 | 50
BB685I | 2017-08-16 00:00:00 | 18 | 16
BB685I | 2017-08-16 00:00:00 | 18 | 34
BB685I | 2017-08-29 00:00:00 | 18 | 60
BB685P | 2017-07-19 00:00:00 | 39.1 | 10
BB685P | 2017-08-23 00:00:00 | 41.054 | 20
BB912I | 2017-08-07 00:00:00 | 13.9 | 100
BB912I | 2017-07-24 00:00:00 | 15 | 10
BB912I | 2017-08-02 00:00:00 | 15 | 20
BB912I | 2017-08-11 00:00:00 | 15 | 20
BB912I | 2017-08-16 00:00:00 | 15 | 30
BB912I | 2017-08-29 00:00:00 | 14.55 | 10
Spreadsheet: 723219d1615562440-how-to-rank-by-4-criteria-rank-by-4-criteria
Sheet: Sheet1

Exam Roll | Math Score (2nd criteria) | Phy Score (3rd criteria) | Chem Score (4th criteria) | Eng Score | Total Score (1st criteria) | Rank [formula needed]
101 | 50 | 50 | 50 | 50 |  | 1
102 | 40 | 50 | 50 | 60 |  | 2
103 | 40 | 40 | 60 | 60 |  | 3
104 | 40 | 40 | 50 | 70 |  | 4
Spreadsheet: 165341d1341185783-project-timeline-calculation-workday-calcs-for-cogic
Sheet: Aux

 | Table1 |  |  | Table2 |  |  | Table4
 | Holidays | Desc |  | Begin | End |  | Hrs_Pcs
 | 2011-01-01 00:00:00 | New Year |  | 08:00:00 | 16:00:00 |  | 01:10:00
 | 2011-01-17 00:00:00 | MLK
 | 2011-02-21 00:00:00 | President
 | 2011-04-24 00:00:00 | Easter
 | 2011-05-30 00:00:00 | Memorial
 | 2011-07-04 00:00:00 | Independence
 | 2011-09-05 00:00:00 | Labor
 | 2011-11-11 00:00:00 | Veterans
 | 2011-11-24 00:00:00 | Thanksgiving
 | 2011-12-25 00:00:00 | Christmas
Spreadsheet: 795444d1662701378-excel-project-dpendecies-calculation-and-formula-ms-excel-grand-quiz-q3
Sheet: Task Sheet

 | Question 3
 | You have a Task Spreadsheet of 5 Tasks of a Project in the 'Task Sheet' tab, All Column names are self-explanatory. Your task is to complete the Blank Cells of Task Spreadsheet Data and Answer the below mentioned question (From cell C27 till C38)
 | Task Spreadsheet
 |  |  |  |  |  |  |  |  |  | [NAME]
 | Activity | Task Dependency | Start Date | Actual Duration (Days) | Actual Finish Date | Actual % Completion | Resources | Actual Task Cost |  | [NAME] | Cost charged per Day (PKR)
 | Task A |  | 2022-07-15 00:00:00 | 3 |  | 1 | R3, R2 |  |  | R1 | 1000
 | Task B |  |  | 4 |  | 0.75 | R5 |  |  | R2 | 1500
 | Task C |  |  | 8 |  | 0.6 | R3, R4 |  |  | R3 | 2000
 | Task D |  |  | 10 |  | 0.5 | R4 |  |  | R4 | 2500
 | Task E |  |  | 13 |  | 0.25 | R1, R3 |  |  | R5 | 3000
 |  |  |  |  |  |  |  |  |  | List of Task Dependencies
 |  |  |  |  |  |  |  |  |  | FS
 |  |  |  |  |  |  |  |  |  | FF
 | Functions & Formula |  |  |  |  |  |  |  |  | SS
 | Task Dependency | Create a Drop down menu for the Task Dependencies |  |  |  |  |  |  |  | SF
 | Actual Finish Date | Calculate the Finish Date
 | Start Date | Assign a Start date based on the Link in Column C
 | Actual Task Cost | Calculate the Task Cost
 | Answer the below Questions
 | Q1 | What will be the Actual Project Duration & Finish Date ? (If Task B have SS, Task C have FF, Task D & Task E have FS dependency type)
 | Q2 | If we change the dependency type of Task D from FS to SS what will be the Actual Finish Date of Task D
 | Q3 | What is the Project Actual Cost (in PKR) ?
 | Q4 | If Task E duration delay from 3 days what will be the Project Duration, Finish Date & Project Cost ? (use same dependency type that we used in Q1)
 | Q5 | Mention the Most Costly Task Name ? Also if we  Add a Resource R1 in Task B than which task is most costly ?
 | Formatting & Visualization
 |  | Create a Gantt Chart of Above mentioned Task Spreadsheet (from Task A to Task E)
Spreadsheet: a1efb20e-0eb6-4a35-b7ad-0c8c2b8e731a
Sheet: Sheet1

Breakeven Analysis | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Business Name Here
Cost Description | Fixed Costs ($) |  | Variable Costs (%)
Variable Costs
Cost of Goods Sold |  |  | 0
Inventory |  |  | 0
Raw Materials |  |  | 0
Direct Labor (Includes Payroll Taxes) |  |  | 0
Fixed Costs
Salaries (includes payroll taxes) | 0
Supplies | 0
Repairs & maintenance | 0
Advertising | 0
Car, delivery and travel | 0
Accounting and legal | 0
Rent | 0
Telephone | 0
Utilities | 0
Insurance | 0
Taxes (Real estate, etc.) | 0
Interest | 0
Depreciation | 0
Taxes & Licenses | 0
Other (specify) | 0
Miscellaneous expenses | 0
Principal portion of debt payment | 0
Owner's draw | 0
Total Fixed Costs | 0
Total Variable Costs |  |  | 0
Breakeven Sales level   = | 0
Spreadsheet: aca91c1f-756b-43a5-a10d-dfdef6cdc31a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LPAGF | Test | LPAGF | Lymphocyte Proliferation to Antigens, Blood | [NAME], Antigens | Flow Cytometry | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 20 | mL | [NAME] must arrive within 24 hours of draw and by 10 a.m. on Friday. Send specimen Sunday through Thursday only. Draw and package specimen as close to shipping time as possible.   Container/Tube: Green top (sodium heparin) [NAME] <3 months: 1 mL 3-24 months: 3 mL 25 months-18 years: 5 mL >18 years: 20 mL Collection Instructions:  1. Send specimen in original tube. Do not aliquot.  2. Ship specimen overnight in an [NAME] Specimens Only (Supply T668). Additional Information:  1. Date and time of draw and ordering physician name and phone number are required. 2. Specify "Antigen" to differentiate from "Mitogen" testing. This information is required. 3. If both antigens and mitogens are desired, order LPMAF/60593 Lymphocyte Proliferation Panel for Mitogens and [NAME]. 4. For serial monitoring, we recommend that specimen draws be performed at the same time of day. | <6 years: 1 mL 6-18 years: 2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Lithium heparin | Viability of lymphocytes at day 0: > or =75.0% Maximum proliferation of Candida albicans as % CD45: > or =5.7% Maximum proliferation of Candida albicans as % CD3: > or =3.0% Maximum proliferation of tetanus toxoid as % CD45: > or =5.2% Maximum proliferation of tetanus toxoid as % CD3: > or =3.3% | Monday through Friday Do not send specimen after Thursday. | 11 days | 14 days | 1 | 86353 |  |  |  |  | Rochester
LPAGF | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Ambient | 48 hours
LPAGF | Result | 32325 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69052-9
LPAGF | Result | 32326 | Viab of Lymphs at Day 0 | Viab of Lymphs at Day 0 | Unknown |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
LPAGF | Result | 32327 | [NAME] of CA as % CD45 | [NAME] of CA as % CD45 | Alphanumeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
LPAGF | Result | 32328 | [NAME] of CA as % CD3 | [NAME] of CA as % CD3 | Alphanumeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
LPAGF | Result | 32329 | [NAME] of TT as % CD45 | [NAME] of TT as % CD45 | Alphanumeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
LPAGF | Result | 32330 | [NAME] of TT as % CD3 | [NAME] of TT as % CD3 | Alphanumeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
LPAGF | Result | 32331 | Antigen Comment | Antigen Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
Spreadsheet: 26875d1219478193-keeping-track-daily-average
Sheet: Sheet1

Month | January (21) | February (20) | March (21) | April (22) | May (21) | June (21) | July (22) | August (21) | September (21) | October (22) | November (18) | December (21)
Number of days | 21 | 20 | 21 | 22 | 21 | 21 | 22 | 21 | 21 | 22 | 18 | 21
 | Monthly Sales |  |  |  |  | Daily Average
 | May (21) | Pant | Shirt | Dress |  | May (21) | Pant | Shirt | Dress
 | 10AM | 8000 | 10000 | 5000 |  | 10AM | 380.952380952381 | 476.1904761904762 | 238.0952380952381
 | 2PM | 16000 | 15000 | 7000 |  | 2PM | 761.9047619047619 | 714.2857142857143 | 333.3333333333333
 | 6PM | 20000 | 17000 | 8000 |  | 6PM | 952.3809523809524 | 809.5238095238095 | 380.952380952381
 | 10PM | 24000 | 20000 | 10000 |  | 10PM | 1142.857142857143 | 952.3809523809524 | 476.1904761904762
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: SITHE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  SITHE
 |  |  | Total |  | Reclasses |  | February |  | March |  | April |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 762096d1641395121-conditional-highlighting-a-cell-when-a-different-cell-contains-specific-text-recruiting-stats-2022
Sheet: Dashboard

 |  |  |  |  | Monthly Recruiting Data |  |  |  |  |  |  |  |  |  | Started with Pending BG
 |  |  |  |  | Month | Applications Received | Scheduled Interviews | Actual Interviews | Job Offers Made | Job Offers Accepted
 |  |  |  |  | January |  |  |  |  |  |  |  |  |  | Status |  |  | Total
 |  |  |  |  | February |  |  |  |  |  |  |  |  |  | Started with Pending BG
 |  |  |  |  | March |  |  |  |  |  |  |  |  |  | Cleared BG
 |  |  |  |  | April |  |  |  |  |  |  |  |  |  | Flagged BG pending LMV approval
 |  |  |  |  | May |  |  |  |  |  |  |  |  |  | BG approved by LMV
 |  |  |  |  | June |  |  |  |  |  |  |  |  |  | BG denied by LMV
 |  |  |  |  | July |  |  |  |  |  |  |  |  |  | Adverse Action Process
 |  |  |  |  | August
 |  |  |  |  | September |  |  |  |  |  |  |  |  |  | Pre-Hires Background Data
 |  |  |  |  | October
 |  |  |  |  | November |  |  |  |  |  |  |  |  |  | PENDING LMV APPROVAL
 |  |  |  |  | December |  |  |  |  |  |  |  |  |  | PENDING VALIDITY
 |  |  |  |  | TOTALS |  |  |  |  |  |  |  |  |  | CLEAR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DENIED
 |  | Declination Reasons (Monthly/ Yearly)
 |  | Pay | Hours | Location | Too much overtime | Start date too far out | Onboarding Requirements | Transportation | Currently Employed | Already worked at LMV | No reason given
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | TOTALS
Spreadsheet: 846718d1697845526-how-to-transform-data-from-a-weekly-schedule-into-daily-shifts-shift-coverage-excel-ahmedsayedmu-
Sheet: Schedule

Name | Department | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
[NAME] | SME | 15:00 - 00:00 | 15:00 - 00:00 | Off | Off | 15:00 - 00:00 | 15:00 - 00:00 | 15:00 - 00:00
Maria |  | 11:00 - 20:00 | 11:00 - 20:00 | 11:00 - 20:00 | 11:00 - 20:00 | 11:00 - 20:00 | Off | Off
Adly |  | 12:00 - 21:00 | 12:00 - 21:00 | 12:00 - 21:00 | 12:00 - 21:00 | 12:00 - 21:00 | Off | Off
Spreadsheet: 848544d1699278908-complex-problem-on-how-to-analyze-sales-data-sales-data
Sheet: Sheet2

Article number | Country | 2023.01 | 2023.02 | 2023.03 | 2023.04
1001 | NL | 2 | 0 | 1 | 0
1001 | BE | 4 | 1 | 1 | 2
1001 | FR | 5 | 0 | 1 | 6
1001 | DE | 1 | 8 | 2 | 5
1001 | PL | 2 | 5 | 3 | 0
1003 | NL | 3 | 3 | 2 | 1
1003 | BE | 7 | 2 | 5 | 3
1003 | FR | 0 | 5 | 7 | 3
1003 | DE | 4 | 8 | 3 | 3
1003 | PL | 1 | 7 | 4 | 2
1004 | NL | 5 | 5 | 6 | 3
1004 | BE | 0 | 4 | 1 | 6
1004 | FR | 5 | 2 | 2 | 5
1005 | NL | 3 | 3 | 0 | 3
1005 | BE | 1 | 7 | 7 | 5
1006 | NL | 5 | 5 | 3 | 7
1006 | BE | 7 | 0 | 1 | 2
1006 | FR | 9 | 4 | 1 | 7
1006 | DE | 1 | 3 | 2 | 5
1006 | PL | 0 | 0 | 0 | 7
Spreadsheet: 757682d1638394360-search-for-any-text-from-multiple-cells-within-multiple-cells-sample
Sheet: Sheet1

Name1 | [NAME] | Name3 | Name4 | Name5 | Name6 | Email1 | Email2 | Email3 | Email4 | Email5 | Email6 | Result
[NAME] | Doe | 1 |  |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | Yes
[NAME] | M | Doe |  |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | Yes
[NAME] | Bi | Fred | Said | None | Yes | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | No
Julie | L | Some | Thing | Special |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | No
Ellie | Is | Last | Good | Mai | 12 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | No
Spreadsheet: 1737f71e-7a55-46cf-8da5-8b509a5c4eb9
Sheet: Sheet1

Unnamed: 0 | Isolate 1 | Unnamed: 2 | Isolate 2 | Unnamed: 4 | Isolate 3 | Unnamed: 6
SNP Marker | Fis | P-value | Fis | P-value | Fis | P-value
SpSNAKElike-40693950 | -0.576 | 0.0000 * | -0.0732 | 1 | -0.0412 | 1
TOLL6-41490803 | 0.4857 | 0.0000 * | 0.2551 | 0.0006 * | 0.6347 | 0.0000 *
SpPPOact-58805968 | 0.0884 | 0.6312 | -0.0113 | 1 | 0.0676 | 1
CLIPB4-34473971 | 0.147 | 0.0744 | 0.2467 | 0.0024 * | -0.118 | 0.7704
AgMDL1-40910564 | -0.0498 | 1 | -0.0422 | 1 | 0.0946 | 1
CEC1-12441661 | 0.0735 | 1 | 0.3582 | 0.0000 * | 0.0675 | 1
Spreadsheet: 480575d1473964840-advanced-filter-column-book1-30-
Sheet: A_F

Lease Forecast | Lease Actual | Acquisition Forecast | Acquisition Actual | Work Start Forecast | Work Start Actual | Work Complete | Work Complete Actual | Job Complete Forecast | Job Complete Actual | Transfer Forecast | Transfer Actual | Engineer Forecast | Engineer Actual | Deliverable Forecast | Deliverable Actual | Customer Accepted Forecast | Customer Accepted Actual
 | Bad |  |  |  |  |  |  |  | Bad |  |  |  |  |  |  |  | Bad
Good
 |  |  |  |  |  |  | Number to filter
 |  |  |  |  |  |  | in column L of Beta Tracker
Good | means that dates are not empty and dates are greater than 1
Bad | means that dates are empty or dates are smaler than 1
<Empty> | means you do not want control
Spreadsheet: 790056d1659525352-sum-hours-times-aligw
Sheet: Sheet1

 |  | WORK ORDER ID | TIME START | TIME FINISH |  | AUGUST22
 |  | AUGUST22 | 07:00:00 | 08:00:00
 |  | 18-1370 | 08:00:00 | 10:00:00
 |  | AUGUST22 | 10:00:00 | 12:00:00
 |  | 21-1375 | 12:30:00 | 13:30:00
 |  | 18-1370 | 13:30:00 | 14:00:00
 |  | 22-1976 | 14:00:00 | 15:00:00
 |  | 21-1375 | 15:00:00 | 15:30:00
Spreadsheet: 680247d1590876587-subtract-a-periode-with-another-period-datedif-essai-habiler-
Sheet: Feuil2

 | Periode |  |  |  |  |  | Ans | Mois | Jours
 | 2001-09-01 00:00:00 | 2006-08-31 00:00:00 | 1 |  | 1
 | 1997-09-01 00:00:00 | 1999-01-06 00:00:00 | 1
 | 2006-09-01 00:00:00 | 2009-12-31 00:00:00 | 1
 | 1996-09-01 00:00:00 | 1997-11-30 00:00:00 | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 | 2001-11-21 00:00:00 | 2002-08-30 00:00:00 | 0.5 |  | 0.5
 | 1995-09-01 00:00:00 | 1996-08-31 00:00:00 | 0.5
 | 1994-11-07 00:00:00 | 1995-08-31 00:00:00 | 0.5
 | 1994-12-01 00:00:00 | 1996-07-31 00:00:00 | 0.5
 |  |  | 0.5
 |  |  | 0.5
 |  |  | 0.5
 |  |  | 0.5
 |  |  | 0.5
 |  |  | 0.5
=
- |  |  |  |  |  |  |  | 54 | 26
Spreadsheet: 123905d1317922634-grouping-multi-year-values-by-category-in-a-chart-excel-help-graph
Sheet: Sheet1

 |  | 2010 | 2011 | 2012
Product A | Revenue | 100 | 200 | 400
 | Profit | 20 | 40 | 80
Product B | Revenue | 50 | 100 | 200
 | Profit | 10 | 20 | 40
Spreadsheet: 721378d1614685997-automated-leaderboard-based-on-three-factors-example
Sheet: Sheet1

 |  | Team | Kills | Damage | Points |  | Hello, I would like to rank the teams automatically in a separate table. I need the points to be prioritised, if the points are equal I would like the total kills to be prioritised and then again if the points and kills are equal to prioritise the damage. Thank you! |  |  |  |  | Overall Leaderboard
 |  |  |  |  |  |  |  |  |  |  |  | Rank | Team | Points | Kills | Damage
 |  | [NAME] | 45 | 15012 | 30
 |  | Life Takers & Jail Breakers | 45 | 7929 | 29
 |  | Two Ste's In A Pod | 34 | 1001 | 30
 |  | Cumfy Bus Boys | 65 | 11263 | 25
 |  | Dec's Destroyers | 65 | 11728 | 25
 |  | Double Trouble | 23 | 13029 | 24
 |  | Unnerved & Unnerfed | 24 | 9362 | 24
 |  | Team 1 | 23 | 9725 | 26
 |  | 60% Of The Time It Works Everytime | 23 | 10234 | 32
Spreadsheet: kate_symes__18780__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202