tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 722553d1615311986-consolidate-but-calculate-the-difference-subtract-during-consolidate-dia-textbook
Sheet: Sheet1

Name | Sales |  |  |  |  | Unique Books | Difference first vs last
fred's journey | 11
jan's dogs | 14
[NAME]'s adventures | 15
mark's cookbook | 11
fred's journey | 18
[NAME] hams | 14
[NAME] ted talks | 22
julia's child | 25
[NAME]'s folly | 27
[NAME]'s adventures | 24
mark's cookbook | 28
[NAME]'s folly | 30
[NAME] hams | 33
Spreadsheet: 83717d1283765908-averages-and-vlookup-solution-book1
Sheet: Sheet1

 |  | TALBE OF "C" VALUES
 |  | Intensity | [NAME] (fi) |  |  |  |  |  |  |  |  |  |  |  | [NAME] (fi) |  | 0
 |  | (mm/hr) | 0 | 0.2 | 0.4 | 0.6 |  | 0.8 | 0.9 | 1
 |  | 39 | REFER ADDITIONAL TABLE. | 0.44 | 0.55 | 0.67 |  | 0.78 | 0.84 | 0.9 |  |  |  |  | INTENSITY (mm/hr) |  | 57
 |  | 45 |  | 0.49 | 0.6 | 0.7 |  | 0.8 | 0.85 | 0.9
 |  | 50 |  | 0.55 | 0.64 | 0.72 |  | 0.81 | 0.86 | 0.9 |  |  |  |  | "C" Value |  | Refer additional table
 |  | 55 |  | 0.6 | 0.68 | 0.75 |  | 0.83 | 0.86 | 0.9
 |  | 60 |  | 0.65 | 0.72 | 0.78 |  | 0.84 | 0.87 | 0.9
 |  | 65 |  | 0.71 | 0.76 | 0.8 |  | 0.85 | 0.88 | 0.9
 |  | 70 |  | 0.74 | 0.78 | 0.82 |  | 0.86 | 0.88 | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional input | REQUIRED
 |  | TALBE OF "C" VALUES for ZERO FRACTION IMPERVIOUS (fi)
 |  | LAND DESCRIPTION | (1) Dense bushland |  |  |  | Medium density [NAME] or |  |  |  | Light cover bushland,or
 |  |  |  |  |  | (2) | Goog grass cover, or |  |  | (3) | Poor grass cover, or
 |  |  |  |  |  |  | High density pasture, or |  |  |  | Low density pature, or |  |  |  | [NAME] (1, 2 OR 3) |  | 1
 |  |  |  |  |  |  | Zero tillage cropping |  |  |  | Low cover bare fallows
 |  | Intensity | Soil permeability |  |  | Soil permeability |  |  |  | Soil permeability |  |  |  |  | Soil permeability |  | HIGH
 |  | (mm/hr) | HIGH | MEDIUM | LOW | HIGH |  | MEDIUM | LOW | HIGH |  | MEDIUM | LOW
 |  | 39 | 0.08 | 0.24 | 0.32 | 0.16 |  | 0.32 | 0.4 | 0.24 |  | 0.4 | 0.48 |  | C Value |  | 0
 |  | 45 | 0.1 | 0.29 | 0.39 | 0.2 |  | 0.39 | 0.49 | 0.29 |  | 0.49 | 0.59
 |  | 50 | 0.12 | 0.35 | 0.46 | 0.23 |  | 0.46 | 0.58 | 0.35 |  | 0.58 | 0.69
 |  | 55 | 0.13 | 0.4 | 0.53 | 0.27 |  | 0.53 | 0.66 | 0.4 |  | 0.66 | 0.7
 |  | 60 | 0.15 | 0.44 | 0.59 | 0.3 |  | 0.59 | 0.7 | 0.44 |  | 0.7 | 0.7
 |  | 65 | 0.17 | 0.5 | 0.66 | 0.33 |  | 0.66 | 0.7 | 0.5 |  | 0.7 | 0.7
 |  | 70 | 0.18 | 0.53 | 0.7 | 0.35 |  | 0.7 | 0.7 | 0.53 |  | 0.7 | 0.7
 |  |  |  |  | I need to complete the formula in cell R25 similar to the R7 formula supplied by zbor
 |  |  |  |  |  |  | : INDICATES USER INPUT
Spreadsheet: 857676d1706630641-conditional-formatting-formula-training-copy-2-
Sheet: Sheet1

 | Training1 | Training2 | Training3 | Training4 | Training5 | Training6 | Training7 | Training8
User1 | 2024-01-22 00:00:00 | 2023-05-10 00:00:00 | Booked for 01/31/2024 |  | Booked for 02/14/2024 | Booked for 02/08/2024 | Booked for 02/08/2024 | Booked for 02/08/2024
User2 | 2024-01-22 00:00:00 | 2023-05-26 00:00:00 |  |  |  | 2023-08-04 00:00:00 | 2023-08-04 00:00:00 | 2023-08-04 00:00:00
User3 | 2024-01-22 00:00:00 | 2023-05-02 00:00:00 | Booked for 01/31/2024 |  | Booked for 02/14/2024 | 2023-03-28 00:00:00 | 2023-03-28 00:00:00 | 2023-03-28 00:00:00
User4 | 2024-01-22 00:00:00 | 2023-05-09 00:00:00 |  |  | Booked for 02/14/2024 | 2023-03-28 00:00:00 | 2023-03-28 00:00:00 | 2023-03-28 00:00:00
[NAME] | 2024-01-22 00:00:00 | 2023-05-10 00:00:00 | Booked for 01/31/2024 |  | Booked for 02/16/2024 | 2023-03-28 00:00:00 | 2023-03-28 00:00:00 | 2023-03-28 00:00:00
[NAME] | 2024-01-22 00:00:00 | Booked for 01/30/2024 | Booked for 01/31/2024 |  | Booked for 02/14/2024 | Booked for [NAME] | Booked for [NAME] | Booked for [NAME]
Spreadsheet: dutch_quigley__9372__Notional Bid Spread-NYMEX
Sheet: New

 | NOTIONAL BID SPREADS ONLY!!!!!
 | EFP NOT CONSIDERED
 | As of _______________________
 |  | Less than 10,000/day | 10,000 - 30,000/day | Greater than 30,000/day
 |  | MMBtu | MMBtu | MMBtu
 | Year 1
 | Year 2
 | Year 3
 | Year 4
 | Year 5
 | Year 6
 | Year 7
 | Year 8
 | Year 9
 | Year 10
 | DO NOT TRANSACT ON THESE NUMBERS!!!!!
 | Prepared by:_________________________________
Spreadsheet: 472264d1469522463-converting-data-between-tabs-department-performance-current
Sheet: 332082

332082
[NAME]
 | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | 220 | 6.55 |  | 393 | 15.1 |  | 0 | 0
2016-07-10 00:00:00 | 21 | 1.44 |  | 53 | 3.77 |  | 298 | 10.83
2016-07-17 00:00:00 | 0 | 0 |  | 24 | 0.98 |  | 685 | 29.76
2016-07-24 00:00:00
2016-07-31 00:00:00
2016-08-07 00:00:00
2016-08-14 00:00:00
2016-08-21 00:00:00
2016-08-28 00:00:00
2016-09-04 00:00:00
2016-09-11 00:00:00
2016-09-18 00:00:00
2016-09-25 00:00:00
2016-10-02 00:00:00
2016-10-09 00:00:00
2016-10-16 00:00:00
2016-10-23 00:00:00
2016-10-30 00:00:00
2016-11-06 00:00:00
2016-11-13 00:00:00
2016-11-20 00:00:00
2016-11-27 00:00:00
2016-12-04 00:00:00
2016-12-11 00:00:00
2016-12-18 00:00:00
2016-12-25 00:00:00
Spreadsheet: d88bebe4-6452-415b-b294-1a3f698edf84
Sheet: Sheet 1 - Table 1

TEAM | Games with, TEAM | Home Games , TEAM | Away Games, TEAM | 10-11 Winning percentage | 10-11 Winning % * no of games | 10-11 WP  Home CALC | 10-11 WP Away CALC
ATL | 2 | 1 | 1 | 0.537
BOS | 1 | 0 | 1 | 0.683
CHA | 1 | 1 | 0 | 0.415
CHI | 1 | 0 | 1 | 0.756
CLE | 2 | 1 | 1 | 0.232
DAL | 4 | 2 | 2 | 0.695
DEN | 3 | 1 | 2 | 0.61
DET | 1 | 1 | 0 | 0.366
[NAME] | 3 | 2 | 1 | 0.439
HOU | 4 | 2 | 2 | 0.524
IND | 1 | 0 | 1 | 0.451
LAC | 4 | 2 | 2 | 0.39
LAL | 4 | 2 | 2 | 0.695
MEM | 3 | 2 | 1 | 0.561
MIA | 1 | 0 | 1 | 0.707
MIL | 2 | 1 | 1 | 0.427
MIN | 3 | 2 | 1 | 0.207
NJN | 1 | 1 | 0 | 0.293
NOH | 4 | 2 | 2 | 0.561
NYK | 1 | 0 | 1 | 0.512
OKC | 3 | 1 | 2 | 0.671
ORL | 1 | 0 | 1 | 0.634
PHI | 1 | 1 | 0 | 0.5
PHX | 0 | 0 | 0 | 0.488
POR | 3 | 2 | 1 | 0.585
SAC | 3 | 1 | 2 | 0.293
SAS | 4 | 2 | 2 | 0.744
TOR | 1 | 1 | 0 | 0.268
UTA | 3 | 1 | 2 | 0.476
WAS | 1 | 1 | 0 | 0.28
Total
WP per game
Spreadsheet: lisa_gang__22278__EPE_APRIL_2002
Sheet: APRIL (14)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-04-14 00:00:00
HR ENDING | . | PALO VERDE | FOUR CORNERS | FOUR CORNERS |  | EDDY | EDDY | EDDY
Pacific | Mountain | SALE | SALE | SALE |  | SALE | SALE | SALE OPTION
Daylight | Standard | SPS | SPS | EPMI |  | SPS | SPS | SPS
Time | Time |  |  | 22.25
 |  | FOR THE DAY | ON GOING DAILY | ON GOING DAILY |  | FOR THE DAY | FOR THE DAY | FOR THE DAY
 |  | 4/1/02-4/30/02 | 4/1/02-4/30/02 | 4/1/02-4/30/02 |  | 4/1/02-4/30/02 | 4/1/02-4/30/02 | 4/1/02-4/30/02
 |  | CALPINE TAG#CPN169 | PSCO TAG#55849 | EPMI TAG#124;125 |  | SPS TAG#55814 | SPS TAG#55812 | SPS TAG#55813 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PDT | MST | DIRECT BILL | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL | DIRECT BILL
0100 | 0100 | 0 | 0 | 25 |  | 0 | 0 | 0
0200 | 0200 | 0 | 0 | 25 |  | 0 | 0 | 0
0300 | 0300 | 0 | 0 | 25 |  | 0 | 0 | 0
0400 | 0400 | 0 | 0 | 25 |  | 0 | 0 | 0
0500 | 0500 | 0 | 0 | 25 |  | 0 | 0 | 0
0600 | 0600 | 0 | 0 | 25 |  | 0 | 0 | 0
0700 | 0700 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
0800 | 0800 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
0900 | 0900 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1000 | 1000 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1100 | 1100 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1200 | 1200 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1300 | 1300 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1400 | 1400 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1500 | 1500 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1600 | 1600 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1700 | 1700 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1800 | 1800 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
1900 | 1900 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
2000 | 2000 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
2100 | 2100 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
2200 | 2200 | 50 | 30 | 25 |  | -50 | -30 | -53 |  |  | 50
2300 | 2300 | 0 | 0 | 25 |  | 0 | 0 | 0
2400 | 2400 | 0 | 0 | 25 |  | 0 | 0 | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  |  | TOTAL SALES |  |  |  | TOTAL PURCHASES
 | PDT TOTAL
 |  | EPE(G)PV | EPE(G)4C | EPE(G)4C
 |  | EPMI | EPMI | EPMI |  | SPS (G) @ EDDY TIE | SPS (G) @ EDDY TIE | SPS (G) @ EDDY TIE
 |  | SPS | SPS | AZPS(T)FC3/PPD2 |  | PSCO | PSCO | PSCO
 |  | CALPINE | PSCO | PSCO |  | AEP | EPMI | EPMI
 |  | SRP | CRSP | CRSP(L)COOLIDGE |  | EPE (L) @ EDDY TIE | EPE (L) @ EDDY TIE | EPE (L) @ EDDY TIE
 |  | SRP(T)PV/WW | PSCO
 |  | SRP(L)WW | PNM
 |  |  | PNM(T)4C345/4C345
 |  |  | PNM(L)4C345
Spreadsheet: 59076d1259510192-generate-a-master-spreadsheet-consolidated
Sheet: Sheet1

Action | Resp | Due
Review of powerboss | Shaun | June Meeting
Plan Raw Mill 4 Audit with Energy Balance | [NAME] | Plan by June
RM4 tech evaluation |  | GPS Invocom
RM4 Liner Strategy Review | VEGA / BP |  | Start with one mill - Hercules - Evaluate improvement
False Air audit of SK8 | Lucien | June Meeting | Fans
Fan efficiency evaluation - quote from suppliers | SS | June Meeting | Airflowmatic, Howden,
Investgate VSD's in plant fan systems | MG |  | Rating, Savings potential
[NAME], [NAME], RM4 airlift to BE | Lucien |  | Calculate potential
Coal mills to be benchmarked |  |  | Leave for later
Investigate mill charge management - CO spikes | Lucien | June Meeting | Is it true?
Compressor audits and usage audits information. Advice from expert. What is name plate value at Slurry. How are compressors interconnected. | Shaun |  | Cost for audit? Data to be collected by [NAME]
Review ME baalance of SK8 | BP
Automate blaster across plant to process | MG
Stopping conveyors when empty | MG
waste heat recovery | EO
Request pre-engineering funding for plan development (10% of 3.5 Mio/MW and PPC Saving) | EO
FM4&3 Audit Planning | BP
Fillter pulsing on continuous | SS |  | Cost and re-design information
Handling problems during acquisition of materials | Lucien |  | Cause and cost of handling problem
Pregrinding for FM4 (VSI or Roller Press) | BP |  | Approach suppliers
FM4 Liner Strategy | VEGA / BP
[NAME] | BP
FM Inlet Modification | SS
Airslides to replace screws | Ernst C
Investigate SCO Efficiency | MG |  | Get Power Africa Information to EO to forward to SW
Rewinding policy | Shaun |  | DSM policy to be shared
Power Factor - Power Quality | MG |  | Report to SW. SW to see with regard to metering
Lighting surveys (domestic and plant) | MG |  | Voltech review and lighting design. Quote for review
Housing - Groupwide | EO
Screw compressors vs Reciprocating | SS |  | Get information on
Send a list of e mail addresses
10th 09h00.
Spreadsheet: 485387d1476863091-formula-making-problem-ef-zoharsb-2
Sheet: Sheet1

 |  | 7.54 |  | 7.54
 |  | calculated field |  | calculated field
 |  | data feed (manually feed) |  | data feed
2016-08-01 00:00:00 | mon | 9.543 |  | 9.543
2016-08-02 00:00:00 | tue | 8.97 |  | 8.97
2016-08-03 00:00:00 | wed | 10.47 |  | 10.47
2016-08-04 00:00:00 | thu | 9.87 |  | 9.87
2016-08-05 00:00:00 | fri | 8.79 |  | 8.79
2016-08-06 00:00:00 | sat
2016-08-07 00:00:00 | [NAME]
2016-08-08 00:00:00 | mon | 7.32 |  | 7.32
2016-08-09 00:00:00 | tue | 7.85 |  | 7.85
2016-08-10 00:00:00 | wed | 8.945 |  | 8.945
2016-08-11 00:00:00 | thu | 7.89 |  | 7.89
2016-08-12 00:00:00 | fri | 7.65 |  | 7.65
2016-08-13 00:00:00 | sat
2016-08-14 00:00:00 | [NAME]
2016-08-15 00:00:00 | mon | 7.33 |  | 7.33
2016-08-16 00:00:00 | tue | 6.99 |  | 6.99
2016-08-17 00:00:00 | wed | 7.834 |  | 7.834
2016-08-18 00:00:00 | thu | 6.87 |  | 6.87
2016-08-19 00:00:00 | fri | 17.98 |  | 6.02
2016-08-20 00:00:00 | sat
2016-08-21 00:00:00 | [NAME]
2016-08-22 00:00:00 | mon | 6.02 |  | 17.98
2016-08-23 00:00:00 | tue | 8.02 |  | 8.02
2016-08-24 00:00:00 | wed | 8.04 |  | #8.02
2016-08-25 00:00:00 | thu | 26.89 |  | 6.89
2016-08-26 00:00:00 | fri | 6.34 |  | 6.34
Spreadsheet: 44dd8df5-0051-4eb6-a266-55a60bc92a50
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
STKKM | Test | STKKM | STK11 Gene, Known Mutation | STK11 Gene, Known Mutation | Polymerase Chain Reaction (PCR) Amplification/DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.  [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Colon Cancer Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Note: No specimen should be rejected. If specimen is received in wrong anticoagulant or at an inappropriate temperature, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Wednesday; 10 a.m. | 10 days | 16 days | 1 | 81403 |  |  |  |  | Rochester
STKKM | [NAME] | VARIES | Varies |  |  |  | Ambient
STKKM | Result | 34175 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
STKKM | Result | 34176 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
STKKM | Result | 34177 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
STKKM | Result | 34178 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
STKKM | Result | 34179 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
STKKM | Result | 34180 | [NAME] | [NAME] | Alphanumeric
STKKM | Result | 34181 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
STKKM | Result | 34182 | Reviewed By | Reviewed By | Alphanumeric
STKKM | Result | 34183 | Release Date | Release Date | Alphanumeric
Spreadsheet: 868272d1715008281-question-regarding-on-conditional-formatting-conditional-formatting-_etaf
Sheet: Sheet1

0 | 0 | 0 | 4 | 0 | 0 | 0 | 8 | 1 | 1 | 2 | 0 | 16 | 22 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6 | 8 | 3 | 0 | 0
0 | 10 | 0 | 5 | 0 | 0 | 2 | 14 | 1 | 2 | 7 | 9 | 50 | 41 | 70 | 0 |  | 0
10 | 11 | 1 | 5 | 1 | 4 | 0 | 0 | 9 | 2 | 0 | 7 | 50 | 152 | 10 | 0
6 | 27 | 0 | 0 | 6 | 6 | 9 | 11 | 0 | 4 | 1 | 0 | 70 | 49 | 0 | 0
1 | 2 | 4 | 4 | 6 | 12 | 19 | 20 | 9 | 6 | 0 | 0 | 83 | 31 | 0 | 0
0 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 6 | 1 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | 1 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 1 | 0 | 0
 | The idea is to highligh the selected range with anything 1.3 time bigger than the value in Column T or anything negative.
Spreadsheet: 703663d1605105112-monthly-report-using-index-match-2nd-sheet
Sheet: Monthly Report

 | Sales Report for the Month of: |  | 2020-01-01 00:00:00
 | The invoice formula is repeating invoice 1 & 3. The formulas for columns G, H and I are giving wrong answers.
 | Date | Customer Code | Customer Number | VAT Number | Invoice | Amount Excl VAT | VAT | Amount Including VAT | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
Spreadsheet: 236139d1368709541-calculating-staff-roster-time-to-hours-depending-on-time-worked-book1_reply
Sheet: Sheet1

Formula 1 |  |  |  | Formula 2
Time start | Time finish | Hours |  | Time start | Time finish | Hours
09:00:00 | 17:30:00 | 08:30:00 | 07:30:00 | 09:00:00 | 17:30:00 | 07:30:00
12:00:00 | 15:00:00 | 03:00:00 | 03:00:00 | 12:00:00 | 15:00:00 |  | <--Formular is entered but cell is blank
h:[NAME] | h:[NAME] | h:[NAME] | <-- Format for each cell | h:[NAME] | h:[NAME] | h:[NAME] | <-- Format for each cell
 |  | [NAME] and you will see my formula |  |  |  | [NAME] and you will see my formula
I need to have one formular I can use no matter how may hours are worked as long as if it is over 6 hours it takes an hour off and under 6 it leaves all hours there.
[NAME]?
Time start | Time finish | Hours
09:00:00 | 17:30:00 | 07:30:00 | < [NAME] formatted: [h]:mm
12:00:00 | 15:00:00 | 03:00:00 | * MOD function allows hours to straddle midnight without producing negative error.
h:[NAME] | h:[NAME] | [h]:mm
Spreadsheet: 93105d1292605194-sum-across-a-row-by-column-heading-and-row-criteria-invoice-total-example
Sheet: Sheet1

 | August |  |  |  |  |  | September |  |  |  |  |  | October
Client | Billed Date | Billed Amount | Invoice # | Received Date | Received Amount | Billed vs. [NAME] | Billed Date | Billed Amount | Invoice # | Received Date | Received Amount | Billed vs. [NAME] | Billed Date | Billed Amount | Invoice # | Received Date | Received Amount | Billed vs. [NAME] | Total RCVD | Total Invoice # >=12 Received Amount | Total >=12
A | 2010-10-21 00:00:00 | 100 | 1 | 2010-11-02 00:00:00 | 100 |  | 2010-12-06 00:00:00 | 200 | 2 |  |  |  |  |  |  |  |  |  |  |  | 0
B | 2010-09-30 00:00:00 | 300 | 11 | 2010-10-11 00:00:00 | 300 |  | 2010-11-01 00:00:00 | 500 | 12 | 2010-11-16 00:00:00 | 500 |  |  |  |  |  |  |  |  |  | 500
C | 2010-09-21 00:00:00 | 600 | 13 | 2010-10-08 00:00:00 | 600 |  | 2010-10-13 00:00:00 | 700 | 14 | 2010-10-29 00:00:00 | 700 |  | 2010-12-06 00:00:00 | 700 | 15
Spreadsheet: 45544d1244285230-pivot-table-662009104516
Sheet: CUSTOMRPT_0718_662009104516

[Card_Number] | [Quantity] | [Invoice_Rate] | [Invoice_Amount] | [Fleet_No] | [Transaction_Date] | [Odometer] | [Vehicle_Number] | [Product_Name] | [Invoice_Month] | [Registration_Region]
5.93274071800001e+16 | 85 | 0.146 | 12.41 | IN-122 | 2009-01-05 00:00:00 | 38966 | 1456 | DIESEL | 5/31/2009 | AD
5.93274071800002e+16 | 52 | 0.146 | 7.592 | IN-123 | 2009-01-05 00:00:00 | 84592 | 6298 | DIESEL | 5/31/2009 | KL
5.93274071800002e+16 | 147 | 0.146 | 21.462 | IN-124 | 2009-01-05 00:00:00 | 95866 | 1455 | DIESEL | 5/31/2009 | PM
5.93274071800002e+16 | 95 | 0.1469 | 13.9555 | IN-125 | 2009-01-05 00:00:00 | 936942 | 6293 | DIESEL | 5/31/2009 | DK
5.93274071800002e+16 | 340 | 0.146 | 49.64 | IN-126 | 2009-01-05 00:00:00 | 277431 | 9002 | DIESEL | 5/31/2009 | WH
5.93274071800002e+16 | 137 | 0.146 | 20.002 | IN-127 | 2009-01-05 00:00:00 | 636606 | 1032 | DIESEL | 5/31/2009 | DS
5.93274071800004e+16 | 152 | 0.146 | 22.192 | IN-128 | 2009-01-05 00:00:00 | 260839 | 4568 | DIESEL | 5/31/2009 | DS
5.93274071800004e+16 | 143 | 0.1469 | 21.0067 | IN-129 | 2009-01-05 00:00:00 | 16404 | 3337 | DIESEL | 5/31/2009 | OW
5.93274071800005e+16 | 60 | 0.133 | 7.98 | IN-130 | 2009-01-05 00:00:00 | 207401 | 6257 | SUPER | 5/31/2009 | KW
5.93274071800005e+16 | 46 | 0.146 | 6.716 | IN-131 | 2009-01-05 00:00:00 | 258259 | 5200 | DIESEL | 5/31/2009 | RK
Spreadsheet: 854830d1704589890-if-and-to-get-a-name-from-a-list-based-on-date-and-time-plus-extract-tl-name-daily-tl-report-mente73-
Sheet: Summary

 | Shift |  |  | Chats
 | Start | End |  | Offered
 |  |  | 00:00:00
 |  |  | 01:00:00
 |  |  | 02:00:00
 |  |  | 03:00:00
 |  |  | 04:00:00
 |  |  | 05:00:00
 |  |  | 06:00:00
 |  |  | 07:00:00
 |  |  | 08:00:00
 |  |  | 09:00:00
 |  |  | 10:00:00
 |  |  | 11:00:00
 |  |  | 12:00:00
 |  |  | 13:00:00
 |  |  | 14:00:00
 |  |  | 15:00:00
 |  |  | 16:00:00
 |  |  | 17:00:00
 |  |  | 18:00:00
 |  |  | 19:00:00
 |  |  | 20:00:00
 |  |  | 21:00:00
 |  |  | 22:00:00
 |  |  | 23:00:00
 |  |  | Totals |  |  | in A29,A54,A79, A104 Need the name of the TL based o n the date (A4) same names in TL daily Shifts
 |  |  | 00:00:00
 |  |  | 01:00:00
 |  |  | 02:00:00
 |  |  | 03:00:00
 |  |  | 04:00:00
 |  |  | 05:00:00
 |  |  | 06:00:00
 |  |  | 07:00:00
 |  |  | 08:00:00
 |  |  | 09:00:00
 |  |  | 10:00:00
 |  |  | 11:00:00
 |  |  | 12:00:00
 |  |  | 13:00:00
 |  |  | 14:00:00
 |  |  | 15:00:00
 |  |  | 16:00:00
 |  |  | 17:00:00
 |  |  | 18:00:00
 |  |  | 19:00:00
 |  |  | 20:00:00
 |  |  | 21:00:00
 |  |  | 22:00:00
 |  |  | 23:00:00
 |  |  | Totals
 |  |  | 00:00:00
 |  |  | 01:00:00
 |  |  | 02:00:00
 |  |  | 03:00:00
 |  |  | 04:00:00
 |  |  | 05:00:00
 |  |  | 06:00:00
 |  |  | 07:00:00
 |  |  | 08:00:00
 |  |  | 09:00:00
 |  |  | 10:00:00
 |  |  | 11:00:00
 |  |  | 12:00:00
 |  |  | 13:00:00
 |  |  | 14:00:00
 |  |  | 15:00:00
 |  |  | 16:00:00
 |  |  | 17:00:00
 |  |  | 18:00:00
 |  |  | 19:00:00
 |  |  | 20:00:00
 |  |  | 21:00:00
 |  |  | 22:00:00
 |  |  | 23:00:00
 |  |  | Totals
 |  |  | 00:00:00
 |  |  | 01:00:00
 |  |  | 02:00:00
 |  |  | 03:00:00
 |  |  | 04:00:00
 |  |  | 05:00:00
 |  |  | 06:00:00
 |  |  | 07:00:00
 |  |  | 08:00:00
 |  |  | 09:00:00
 |  |  | 10:00:00
 |  |  | 11:00:00
 |  |  | 12:00:00
 |  |  | 13:00:00
 |  |  | 14:00:00
 |  |  | 15:00:00
 |  |  | 16:00:00
 |  |  | 17:00:00
 |  |  | 18:00:00
 |  |  | 19:00:00
 |  |  | 20:00:00
 |  |  | 21:00:00
 |  |  | 22:00:00
 |  |  | 23:00:00
 |  |  | Totals
Spreadsheet: 542349d1507818891-workflow-how-to-show-this-weeks-tasks-sum-product-pivot-workflow-this-weeks-tasks-full-answer
Sheet: Sheet2

just one example…
SHOWDATE | ARTIST | TOWN / CITY | VENUE | FACEBOOK TOUR 3 | ASK VENUE TO DO MAILSHOT | ASK TICKET OUTLET NEXT MAILER
2017-10-27 00:00:00 | BAND 398 | ST HELENS | CITADEL | 2017-10-09 00:00:00 | 2017-10-13 00:00:00 | 2017-10-13 00:00:00
2017-10-28 00:00:00 | BAND 400 | BURY | THE MET | 2017-10-09 00:00:00
Spreadsheet: 728140d1618333129-xlookup-when-there-are-blanks-in-the-data-book1
Sheet: Sheet1

[NAME] | No. Customers | Net Sales | Profit / Loss
[NAME] | 8 | 1592 | 563
[NAME] | 8 | 1088 | 397 |  |  | Salesperson | [NAME]
Skyler Hale | 8 | 1680 | 753
Lorena Washington | 9 | 2133 | 923
[NAME] | 10 | 1610 | 579
[NAME] | 10 | 1540 | 570
[NAME] | 7 | 1316 | 428
[NAME] | 7 | 1799 | 709
[NAME] | 8 | 1624 | 621
[NAME] | 6 | 726 | 236
[NAME] | 9 | 2277 | 966
[NAME] | 6 | 714 | 221
[NAME] | 9 | 2682 | 1023
[NAME] | 8 | 2724 | 1498
[NAME] | 9 | 1779 | 551
[NAME] | 11 | 1497 | 554
Lucas Novak | 12 | 2652 | 1379
[NAME] | 7 | 1415 | 792
[NAME]
[NAME]
Spreadsheet: 729879d1619426657-flexible-range-dropdown-with-previous-conditions-over-the-range-of-two-sheets-tripple-dropdown-error-example
Sheet: Settings

Locations |  | Zurich_Departments | Berlin_Departments | London_Departments | Zurich_Sales | Zurich_Finance | Zurich_Logistics | Berlin_Sales | Berlin_Finance | Berlin_Logistics
Zurich |  | Finance | Finance | Finance | Manager | Manager | Manager | Manager | Manager | Manager
Berlin |  | Sales | Sales | Sales | Team Leader | Team Leader | Team Leader | Team Leader | Team Leader | Team Leader
London |  | Logistics | Logistics | Logistics | Specialist | Specialist | Specialist | Specialist | Specialist | Specialist
 |  |  |  |  | Co-worker | Co-worker | Co-worker | Co-worker | Co-worker | Co-worker