tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862794d1710412507-calculate-deadlines-and-costs-ticket-calculator
Sheet: Tickets (new)

Severity 1 | Severity 2 | Severity 3 | Severity 4 | Severity 5
£2,500 for the first Fix Time Failure for an individual Incident Severity Level 1 Incident and then £500 for each subsequent Fix Time Failure for the same Incident Severity Level 1 Incident. | £1,500 for each Fix Time Failure for Incident Severity Level 2 Incidents. | £1,000 for each Fix Time Failure for Incident Severity Level 3 Incidents. | £500 for each Fix Time Failure for Incident Severity Level 4 Incidents. | £250 for each Fix Time Failure for Incident Severity Level 5 Incidents.
< 4 hours | < 24 hours | < 5 Business Days | <  20 Business Days | As agreed with the Customer
Issue key | Issue Type | Summary | Status | Resolution | Assignee | Reporter | Severity | Created | Resolved | Due date | On Time (YES/NO) | Direct Service Credits
 |  |  |  |  |  |  | 1 | 2024-01-30 07:26:00 | 2024-01-30 08:16:00
 |  |  |  |  |  |  | 2 | 2024-01-26 06:25:00 | 2024-01-27 08:31:00
 |  |  |  |  |  |  | 3 | 2024-01-25 06:22:00 | 2024-02-02 09:26:00
 |  |  |  |  |  |  | 4 | 2024-01-24 14:01:00 | 2024-01-24 16:43:00
 |  |  |  |  |  |  | 5 | 2024-01-24 06:29:00 | 2024-01-24 09:20:00
 |  |  |  |  |  |  | 1 | 2024-01-23 14:34:00 | 2024-01-23 17:12:00
 |  |  |  |  |  |  | 2 | 2024-01-23 12:31:00 | Ongoing
 |  |  |  |  |  |  | 3 | 2024-01-23 06:37:00 | Ongoing
 |  |  |  |  |  |  | 4 | 2024-01-24 06:36:59.995000 | Ongoing
 |  |  |  |  |  |  | 5 | 2024-01-25 06:36:59.995000 | Ongoing
Spreadsheet: 136026d1326378200-sales-by-month-ef8_sample-sales-by-month
Sheet: Sheet1

 |  |  |  |  |  |  | 10 | <== no of date columns
Row | Column |  | Customer | Date | Value |  | 2 | <== start row
 |  |  |  |  |  |  |  | <== change range in D3,E3,F3 to suit
 |  |  |  |  |  |  |  | then copy formulae down until you get blanks
Spreadsheet: 137086d1326947749-calculation-of-hours-worked-but-with-if-and-else-statements-test
Sheet: Sheet1

 | Monthly Hours | Out of office | Member [NAME] hours total | Hours Worked | %
December - Total | 120
[NAME] |  | 8 |  | 130
Mark |  |  | 120 | 120
[NAME] |  | 4 |  | 116
[NAME] |  |  | 120 | 120
Spreadsheet: 67804d1268324963-formula-to-return-value-based-on-category-available-hours
Sheet: Sheet1

Output table |  | Category lookup | Set hours to train
[NAME]
Week 1 |  | Conditon | Training hours per week
Set training hours |  | Healthy | Week 1 | 30
Hours injured | 5 | Injured | Week 2 | 28
Actual training hours | -5 | Quit | Week 3 | 25
Week 1 |  |  | Week 4 | 31
Set training hours
Hours injured | 2
Actual training hours | -2
Week 1
Set training hours
Hours injured | 0
Actual training hours | 0
Set training hours
Hours injured | 3
Actual training hours | -3
(Worksheet 1) |  | (Worksheet 2) | (Worksheet 3)
If [NAME] is healthy he is available to train 30 hours per week if hes injured hes available the 30 hours per week minus the 5 hours injured (25 hours) if he has Quit then his hours to train are zero
Spreadsheet: 741904d1627403535-vlookup-cant-figure-it-out-vlookup-example
Sheet: Sheet1

ID1 | ID 2 | Name |  | Name | New ID |  | Need to look it as follows |  | Name | ID1 | ID2 | New ID
12345 | 987654 | Example_bv |  | Example | 5463271 |  |  |  | 12345 | 987654 | Example_bv | ?
349872 | 1987364 | Test_cd |  | Test | 43281734 |  |  |  | 349872 | 1987364 | Test_cd | ?
6374595 | 192834 | Sample_se |  | Sample | 4958632 |  |  |  | 6374595 | 192834 | Sample_se | ?
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: ACRL1

ACRL Statistics Questions 1-7, 2010-2011
Question | Measure | Total FY11 | Notes
Question 1 | [NAME] held June 30, 2011 | —
Question 1b.i | [NAME] added - Gross | — | —
 | Serials (from Acquisitions Unit) | 1620 | Govt. Pubs not included.
 | Monographs (from Acquisitions Unit) | 10735 | Govt. Pubs not included.
Question 1b.ii | [NAME] withdrawn during year | — | —
 | Serials (from Acquisitions Unit) | 24102 | Govt. Pubs not included.
 | Monographs (from Acquisitions Unit) | 317 | Govt. Pubs not included.
Question 2 | Titles held June 30, 2010 | 1137765 | Footnote: Includes branches."
Question 3 | Number of monographic volumes purchased | 7832
Question 4 | Basis of volume count is: | Physical | —
Question 5a | Number of serial titles currently purchased | — | —
Question 5a.i | Electronic (deduplicated) | 26471 | —
Question 5a.ii | Print (and other format) serials purchased | 577
Question 5a | 5a.i + 5a.ii
Question 5b | Number of serial titles current received but not purchased | —
Question 5b.i | Consortial | 8175
Question 5b.ii | Freely accessible | 22478
Question 5b.iii | Exchanges, gifts, etc. | 51
Question 5b.iv | Government documents | — | Provided by Govt. Pubs.
Question 5 | Total serials received: (a + b) | —
Question 6 | Government documents are included in count of Current Serials? | Yes
Question 7 | Microform units | —
 | Serials (from Acquisitions Unit) | 34
Spreadsheet: aaf13051-747c-414f-b968-da78d8c6b852
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
ROM | Test | ROM | Measles (Rubeola) Antibodies, IgM, Serum | Measles (Rubeola) Ab, IgM, S | Immunofluorescence Assay (IFA) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | Negative (reported as negative or positive) | Monday through Saturday; 9 a.m. | Same day/1 day | 3 days | 1 | 86765 |  |  |  |  | Rochester
ROM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ROM | Result | 80979 | Measles (Rubeola) Ab, IgM, S | Measles (Rubeola) Ab, IgM, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21503-8 | Measles virus Ab.IgM:ACnc:Pt:Ser:Ord:
Spreadsheet: 787821d1658071394-formulas-for-tiered-compensation-structure-book1
Sheet: Sheet1

 |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 | Sales
 | Salesman 1
 | Salesman 2
 | Compensation | Structure for each salesperson
 | Salesman 1 | 40% of sales up to 1.5M - then 45%
 | Salesman 2 | 25% of sales up to 350,000; 30% 350,001-650,000; 35% > 650,000
 |  | ^
 |  | '
 |  | These are based on cumulative sales
Spreadsheet: 166633d1341672816-using-mod-row-to-display-in-every-nth-cell-with-some-cells-skipped-example-3
Sheet: Setup

 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | Frequency | Days Per week
 | Item 1 | 1 | 1 | mg | box |  | 3
 | Item 2 | 1 | 1 | mg | box |  | 4
 | Item 3 | 1 | 1 | mg | box |  | 5
Spreadsheet: 701384d1603730972-vlookup-and-percent-change-calculation-lf-__-customer-health-dashboard-monthly-listenfirst-
Sheet: Sheet12

2020-07-01 00:00:00 |  |  | 2020-06-01 00:00:00
Client A | 1 |  | Client C | 2 |  | Client A
Client B | 1 |  | Client A | 2 |  | Client B
Client C | 5 |  | Client B | 3 |  | Client C
Spreadsheet: 470357d1468440812-pairing-data-with-itself-amolo_self-reference
Sheet: Sheet2

A0050-BD-B0018-14
A0050-BD-B0018-18
A0050-BD-B0018-22
A0050-BD-B0018-26
A0050-BD-B0018-30
A0050-BD-B0018-34
A0050-BD-B0018-38
A0050-BD-B0018-42
A0050-BD-B0018-46
A0050-BD-B0018-50
A0050-BD-B0018-54
A0050-BD-B0018-58
A0050-BD-B0018-62
A0050-BD-B0018-66
A0050-BD-B0018-70
A0050-BD-B0018-74
A0050-BD-B0018-78
A0050-BD-B0018-82
A0050-BD-B0018-86
A0050-BD-B0018-90
A0050-BD-B0018-94
A0050-BD-B0018-98
A0050-OB-B0018-14
A0050-OB-B0018-18
A0050-OB-B0018-22
A0050-OB-B0018-26
A0050-OB-B0018-30
A0050-OB-B0018-34
A0050-OB-B0018-38
A0050-OB-B0018-42
A0050-OB-B0018-46
A0050-OB-B0018-50
A0050-OB-B0018-54
A0050-OB-B0018-58
A0050-OB-B0018-62
A0050-OB-B0018-66
A0050-OB-B0018-70
A0050-OB-B0018-74
A0050-OB-B0018-78
A0050-OB-B0018-82
A0050-OB-B0018-86
A0050-OB-B0018-90
A0050-OB-B0018-94
A0050-OB-B0018-98
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: POJS

Old course number | New course number
POJS-605 | [NAME]
POJS-607 | POJS-6120
POJS-615 | POJS-6150
POJS-620 | POJS-6200
POJS-625 | POJS-6250
POJS-630 | POJS-6300
POJS-632 | POJS-6320
POJS-705 | POJS-7150
POJS-707 | POJS-7070
POJS-709 | POJS-7190
POJS-710 | POJS-7101
POJS-715 | POJS-7330
POJS-718 | POJS-7180
POJS-720 | POJS-7200
POJS-721 | POJS-7210
POJS-722 | POJS-7220
POJS-725 | POJS-7250
POJS-730 | POJS-7300
POJS-735 | POJS-7350
POJS-805 | POJS-8150
POJS-806 | POJS-8160
POJS-808 | POJS-8170
POJS-810 | POJS-8100
POJS-811 | POJS-8110
POJS-819 | POJS-8190
POJS-820 | POJS-8200
POJS-821 | POJS-8210
POJS-824 | POJS-8240
POJS-825 | POJS-8250
POJS-830 | POJS-8300
POJS-831 | POJS-8310
POJS-835 | POJS-7035
POJS-836 | [NAME]
POJS-837 | POJS-7037
POJS-839 | POJS-8390
POJS-840 | POJS-7400
POJS-845 | POJS-8450
POJS-846 | POJS-8460
POJS-850 | POJS-8500
POJS-869 | POJS-8981
POJS-869 | POJS-8982
POJS-870 | POJS-8700
POJS-880 | POJS-8800
POJS-885 | POJS-8970
POJS-889 | POJS-8890
POJS-890 | POJS-8990
POJS-898 | POJS-8999
Spreadsheet: 86735d1286708695-complicated-and-or-statment-help-required-book2
Sheet: Calcs

Additional Programme Properties
Decent Homes | [NAME] | All Windows | Windows (Inc DH) | Windows Only | Cyclical | Other | No. of Props
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 23

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-23 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1387 |  | 1259 |  | 67694 |  |  |  |  |  | 29 | 1 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 2 | 32
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 3202 |  | 2560 |  | 67694 |  |  |  |  |  | 30 | 3 | 32
 |  |  |  |  |  |  |  |  | 6999 |  | 6999 |  | 68918 | 0 |  |  |  |  | 29 | 4 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 5 | 31
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1631 |  | 1504 |  | 67694 |  |  |  |  |  | 31 | 6 | 32
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 30 | 7 | 31
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 31 | 8 | 32
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 30 | 9 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 15 | 34
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 12272 |  | 10973 |  | 67694 |  |  |  |  |  | 30 | 35 | 30
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 29 | 39 | 31
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1536 |  | 1337 |  | 67694 |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 963 |  | 808 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 10724 |  | 11342 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3528 |  | 3422 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3862 |  | 3748 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4963 |  | 4963 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1476 |  | 1476 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 37 |  | 34 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 885106d1734530344-data-analysis-data-sample
Sheet: Sheet1

Date/Time | Event | Value | Unit Of Measure | Commodity | Type | Device | Severity | Account Number |  | Last Name | Address
2024-12-14T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468050 | Critical | 1000394 | 7 | [NAME] | 1 Taylor Ln
2024-12-15T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468050 | Critical | 1000394 | 7 | [NAME] | 1 Taylor Ln
2024-12-16T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468050 | Critical | 1000394 | 7 | [NAME] | 1 Taylor Ln
2024-12-14T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468207 | Critical | 1000048 | 6 | Jones | 10 Jones Circle
2024-12-15T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468207 | Critical | 1000048 | 6 | Jones | 10 Jones Circle
2024-12-16T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468207 | Critical | 1000048 | 6 | Jones | 10 Jones Circle
2024-12-14T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693681 | Critical | 2000774 | 5 | There Apartments | There Apt 14 B
2024-12-14T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693637 | Critical | 2000705 | 3 | There Apartments | There Apt 12 D
2024-12-14T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693628 | Critical | 2000806 | 4 | There Apartments | There Apt 19C
2024-12-15T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693681 | Critical | 2000774 | 5 | There Apartments | There Apt 14 B
2024-12-15T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693628 | Critical | 2000806 | 4 | There Apartments | There Apt 19C
2024-12-15T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693637 | Critical | 2000705 | 3 | There Apartments | There Apt 2 D
2024-12-16T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693681 | Critical | 2000774 | 5 | There Apartments | There Apt 14 B
2024-12-16T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693628 | Critical | 2000806 | 4 | There Apartments | There Apt  19C
2024-12-16T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 46693637 | Critical | 2000705 | 3 | There Apartments | There Apt 12 D
2024-12-14T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 73371239 | Critical | 2003875 | 2 | Unknown | 1 Big Question Way
2024-12-15T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 73371239 | Critical | 2003875 | 2 | Unknown | 1 Big Question Way
2024-12-16T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 73371239 | Critical | 2003875 | 2 | Unknown | 1 Big Question Way
2024-12-15T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468427 | Critical | 3001336 | 1 | Smith | 20 Smith St
2024-12-16T00:00:00 | Read Rate | 0 | Percent | Water | MTU-STAR | 45468427 | Critical | 3001336 | 1 | Smith | 20 Smith St
Spreadsheet: 3492d1b9-2df1-463d-97c7-1097dcdf930a
Sheet: VAR Status Report

OATT Schedule 2 – VAR Status Summary Report [WWW Publication]
WW_VARSTATUS_ISO_<settlement_date>_<version>.CSV
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Asset ID | Asset Name | Asset Type | Leading Status Effective Date | Leading Test Due Date | Schedule 2 Leading Program Status | Lagging Status Effective Date | Lagging Test Due Date | Schedule 2 Lagging Program Status | Lagging Test MW Level | Lagging Qualified VAR Capability | Leading Qualified VAR Capability | Total Qualified VARs
Number | String | String | Date | Date | String | Date | Date | String | MW | MVAR | MVAR | MVAR
Spreadsheet: 160365d1339067114-excel-2007-text-boxes-and-pictures-will-not-print-tried-lots-of-things-to-no-avail-copy-of-recipe-sheet-v5
Sheet: Materials Calc

 |  | OFFICE COPY ONLY
 |  | Type of Job |  |  |  | Mix
 |  | Supply & Lay
 |  | Job No. |  |  | Customer
 |  | 9999 |  |  | Test Ltd
 |  | Date Required |  |  | Site Details
 |  | 2099-01-01 00:00:00 |  |  | Address 1 |  |  | Address 2
 |  | MATERIAL REQUIREMENTS
 |  | Sprinkle? |  |  |  | Area |  | 150 | m2
 |  | Mix Code |  |  |  | Coverage |  |  | [NAME]
 |  | Depth of disc |  | 10 | [NAME] | Tonnes required |  |  | t
 |  | Coverage |  |  | [NAME] | Multiplier |  | 1
 |  | Depth |  | 18 | [NAME] | Revised tonnes (Resin & Agg) |  |  | t
 |  | Coverage |  |  | [NAME] | Aggregate only |  |  | t
 |  | [NAME] |  |  | m2/batch | [NAME] Only |  |  | t
 |  | AGGREGATE INFORMATION
 |  | Number of batches |  |  |  |  |  |  |  | Project Cost
 |  | Size | Source | Supplier | % | [NAME] | [NAME] kg | Total tonnes | No. of [NAME] | Agg
 |  | Total |  |  |  |  |  |  | tonnes
 |  |  |  |  |  | Total Batch size
 |  | RESIN INFORMATION
 |  |  | Disc % |  | Job Target % |  | [NAME] |  | g
 |  |  |  | % | [NAME] g | Total [NAME] | Project Cost |  | Estimated Number of Pallets
 |  |  | I | 50 |  |  |  |  | Aggregate
 |  |  | P | 50 |  |  |  |  | [NAME]
 |  |  | Total
 |  |  | Catalyst Required |  |  |  | [NAME] | Project Costs
 |  |  | Pigment |  |  |  |  | Total
 |  |  |  |  | Total |  | [NAME] |  |  | /m²
 |  | Designed by |  |  |  | Checked by
 |  | Date |  |  |  | Date
Spreadsheet: 87236d1287079026-excel-2007-conditional-formatting-order-book1_jollywood
Sheet: Sheet1

Percentage | 1
Accounting | 1
Accounting | 2.8
Accounting | 3.7
Accounting | 4.6
Accounting | 5.5
Accounting | 6.4
Accounting | 7.3
Percentage | 8.2
Accounting | 9.1
Accounting | 10
Spreadsheet: 774289d1648368391-summarise-sku-arrivals-in-table-consolidate-multiple-lines-into-one-and-group-by-week-inbound_report_upload
Sheet: Data

Purchase order # | SKU | Description | Deliv. date(From/to) | Delivery quantity
110 | 1530 | Gourmet Coarse Grater 45000 | 2022-04-08 00:00:00 | 480
110 | 1532 | Gourmet Fine Grater 45004 | 2022-04-08 00:00:00 | 1200
111 | 1532 | Gourmet Fine Grater 45004 | 2022-04-12 00:00:00 | 720
110 | 1536 | Premium Black Zester Grater 46020 | 2022-04-08 00:00:00 | 1200
111 | 1536 | Premium Black Zester Grater 46020 | 2022-04-12 00:00:00 | 2400
110 | 1570 | Premium Classic Zester Black CDU/12 | 2022-04-08 00:00:00 | 1200
110 | 1571 | Premium Classic Zester Citrus CDU/12 | 2022-04-08 00:00:00 | 480
110 | 1573 | Zester CDU/12 6 xWhite, 6 xFloral | 2022-04-08 00:00:00 | 1200
112 | 2700 | Pasta Machine [NAME] 150 | 2022-04-12 00:00:00 | 2196
112 | 2701 | Ravioli Access | 2022-04-12 00:00:00 | 72
112 | 2705 | Spaghetti Access | 2022-04-12 00:00:00 | 48
112 | 2707 | Parppardelle 50mm Access | 2022-06-16 00:00:00 | 48
Spreadsheet: 699768d1602757058-extract-values-and-place-extracted-values-in-desired-columns-salesid_okaynow_3
Sheet: Sheet1

Data Year (Fiscal) | Sales ID | Sales Count | Lat | Long |  | Data Year (Fiscal) |  | FF_1 | FF_2 | FF_3 | FF_4 | FF_5 | FF_6 | FF_7 | FF_8 | FF_9
Data Year (Fiscal) | Sales ID | Sales Count | Lat | Long |  | 2012 | Lat
2012 | 1 | 6 | 29.857273 | -95.393037 |  | 2012 | Long
2012 | 1 | 6 | 40.776642 | -73.970187 |  | 2011 | Lat
2012 | 1 | 6 | 41.852058 | -88.086039 |  | 2011 | Long
2012 | 1 | 6 | 34.196398 | -118.261862 |  | 2010 | Lat
2012 | 1 | 6 | 41.227413 | -73.367061 |  | 2010 | Long
2012 | 1 | 6 | 41.214236 | -103.011929
2011 | 1 | 5 | 36.699376 | -93.834334
2011 | 1 | 5 | 45.77173 | -122.485953
2011 | 1 | 5 | 35.246862 | -80.833832
2011 | 1 | 5 | 40.209999 | -75.370201
2011 | 1 | 5 | 39.325414 | -104.925987
2010 | 1 | 3 | 40.776642 | -73.970187
2010 | 1 | 3 | 33.205132 | -97.12114
2010 | 1 | 3 | 26.193535 | -80.476683
Spreadsheet: 88961d1288765202-vlookup-and-countif-in-the-same-formula-table-example
Sheet: Sheet1

[NAME] | 0.56 | 0.82 | 0 | 0 | 0 | 0.83 | 0 |  | 0.73
[NAME] | 0.82 | 0.9 | 0.8 | 0.75 | 0.69 | 0 | 0 |  | 0.79
[NAME] | 0 | 0 | 0.25 | 0.35 | 0 | 0 | 0 |  | 0.3
[NAME] | 0 | 0 | 0.35 | 0.56 | 0 | 0 | 0 |  | 0.46
Spreadsheet: a4c36637-76c0-401b-82b5-e34a4b664320
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3784 | 10307 | [NAME] | De Marcellis | ITA | 273 | 00:43:01 | [NAME] | 01:10:08 | 00:01:23 | 00:24:09 | 1 | 02:20:09
3784 | 13503 | [NAME] | [NAME] | FRA | 271 | 00:52:56 | 00:01:11 | 01:23:41 | 00:01:26 | [NAME] | 2 | 02:51:05
Spreadsheet: 758557d1638950087-column-c-lists-all-missing-dates-12-08
Sheet: Sheet1

Date |  | Column B  lists all missing dates
2021-12-01 00:00:00 |  | 2021-12-04 00:00:00
2021-12-02 00:00:00 |  | 2021-12-05 00:00:00
2021-12-03 00:00:00 |  | 2021-12-11 00:00:00
2021-12-06 00:00:00 |  | 2021-12-14 00:00:00
2021-12-07 00:00:00 |  | 2021-12-15 00:00:00
2021-12-08 00:00:00 |  | 2021-12-16 00:00:00
2021-12-09 00:00:00 |  | 2021-12-17 00:00:00
2021-12-10 00:00:00 |  | 2021-12-20 00:00:00
2021-12-12 00:00:00 |  | 2021-12-21 00:00:00
2021-12-13 00:00:00 |  | 2021-12-24 00:00:00
2021-12-18 00:00:00 |  | 2021-12-25 00:00:00
2021-12-19 00:00:00 |  | 2021-12-27 00:00:00
2021-12-22 00:00:00
2021-12-23 00:00:00
2021-12-26 00:00:00
2021-12-28 00:00:00
2021-12-29 00:00:00
2021-12-30 00:00:00
2021-12-31 00:00:00
Spreadsheet: 870252d1716799419-sumproduct-formula-not-giving-any-results-excel-help-with-formulas-2-aligw
Sheet: Results2

Week Commencing | Contract | Contract % | Days Worked | Days Lost | Daily Average m3 | Reasons for Days Lost | Reasons for Days Lost | Contract Profit | Profit per Machine | Daily Average Profit | Contract Notes
2024-05-20 00:00:00 |  | 0.4128719700658893 |  |  | 0 | N/A | N/A | 0 | 0 | 0
Week Number |  | 0.2685192032446584 |  |  | 0 | N/A | N/A | 0 | 0 | 0
21 |  | -0.0240430185085006 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5621419179755577 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.4986884850326427 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | -3.188679245283019 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | -0.907337315301817 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.4610992148465382 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.2984562607204116 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5339903123434107 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.533648738653455 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5055384901796519 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5652835314996856 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.6893036611629576 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5522838807097018 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5104021049172628 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | -0.3474453888652783 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.4396701303217971 |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  |  | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0