tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 802958d1667178317-formula-to-match-mutiple-items-and-detect-exception-book-2
Sheet: DATA

Store | Item | Rev | Cost
651899 | A - Cost | 0 | 5.56
651899 | B - Cost | 0 | 21.35
651899 | A - Cost | 0 | 81
651899 | B - Cost | 0 | 128
651899 | A - Cost | 0 | 198
651899 | A - Rev | -380 | 0
651899 | C - Rev | -35 | 0
651899 | F - Cost | 0 | 24.15
960829 | A - Rev | -343.4 | 0
960829 | C - Rev | -45 | 0
960829 | B - Rev | -120 | 0
960829 | E - Rev | -31 | 0
960829 | D - Rev | -15.85 | 0
960829 | A - Cost | 0 | 230.6
960829 | E - Cost | 0 | 50
960829 | A - Cost | 0 | 31
960829 | F - Cost | 0 | 54
960829 | F - Rev | -400
173245 | A - Rev | -1172.6 | 0
173245 | C - Rev | -135 | 0
173245 | B - Rev | -210 | 0
173245 | A - Cost | 0 | 459.78
173245 | F - Cost | 0 | 162
173245 | D - Cost |  | 200
Spreadsheet: eric_saibi__9766__012302
Sheet: Unit 01 CTHRSG

Owner Name | NRG Energy Incorporated
Station Name | Long Beach Power Station
Unit Name | Unit 01 CT/HRSG
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas / Jet Fuel
Capacity | 63 MW
Start Date | 2002-01-23 00:00:00
End Date | 2002-01-25 00:00:00
Comments | Inspection
SIC | 4931
Plant ID | 1021594
Unit ID | 1007061
Outage ID | 19600
Spreadsheet: 709474d1608321508-how-to-count-values-in-2nd-column-based-on-another-first-column-temp2
Sheet: Sheet5

Main Department | Department | Count of Department
Anaesthesia | Anaesthesia | 10 |  | 1
Biochemistry | Biochemistry | 40 |  | 1
CAF | CAF | 8 |  | 1
Computer Services Unit | CSU - Faculty | 5 |  | 2
 | CSU - Support | 2
Education services | Educ Anatomy | 6 |  | 12
 | [NAME] | 9
 | Educ Csbl | 314
 | Educ Deli | 13
 | [NAME] | 7
 | [NAME] | 7
 | Educ HSGS | 7
 | Educ ISHS | 2
 | Educ Maccare | 3
 | [NAME] | 6
 | Educ Pa | 10
 | [NAME] | 8
Family Medicine | Family Med | 1 |  | 1
Finance | FHS Finance | 1 |  | 2
 | FHS Research Finance | 2
Health Evidence and Impact | Clinical Epidemiology | 5 |  | 1
Medicine | Emergency Medicine | 1 |  | 2
 | FHS MGD Initiative | 3
Grand Total |  | 470
Spreadsheet: 8da03101-980f-4933-8d75-4f4836318e5e
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
TRYPU | Test | TRYPU | Tryptophan, [NAME] | Tryptophan, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) |  |  |  | 2 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 2 mL Collection Instructions: Collect a random urine specimen. Additional Information:  1. Patient's age is required. 2. Include family history, clinical condition (asymptomatic or acute episode), diet, and drug therapy information. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | < or =35 months: 14-315 nmol/mg creatinine 3-8 years: 10-303 nmol/mg creatinine 9-17 years: 15-229 nmol/mg creatinine > or =18 years: 18-114 nmol/mg creatinine | Monday through Friday; 8 a.m. | 3 days (not reported on Saturday or Sunday) | 5 days | 1 | 82131 |  |  |  |  | Rochester
TRYPU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 7 days
TRYPU | Result | 83823 | Tryptophan, U | Tryptophan, U | Numeric |  |  |  |  | [NAME]/mg Cr |  |  |  |  |  |  |  |  |  | 25139-7
TRYPU | Result | 34618 | Interpretation (TRYPU) | Interpretation (TRYPU) | Alphanumeric
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Docklands

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-10-16 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-10-18 00:00:00
Spreadsheet: 228224d1366045288-match-3-set-of-columns-and-return-value-from-another-column-in-case-of-a-unique-match-saurabh-20test-20sheet-1-
Sheet: Status Summary

Status/ Business-process | In Progress | Tested Successfully | Test Condition Failed - TPR raised | Technical Issue | [NAME] to onshore | Target Count till today | % Completion | Total | Total % Completion
Tariff Modeling | #N/A | 3 | 0 | 0 | 0 | 0
Billing | #N/A | 43 | 0 | 2 | 0 | 0
Credit Collection | 0 | 0 | 0 | 0 | 0 | 0
Finance | 0 | 0 | 0 | 0 | 0 | 0
Orders
Spreadsheet: 728691d1618578693-find-and-move-corresponding-data-between-sheets-example-sheet-1-1-
Sheet: Sheet1

Part Number | Description | Sales
B009OKFXYA | FORMULA NEEDS TO GO HERE.
B009OJJ8HY | LOCATE PART NUMBER FROM COLUMN A IN SHEET 2
B009OL3BSY | [NAME] FROM SHEET 2 HERE
B001378EAC
B000MN1N1A
B000QFKBMG
B000N2YSU8
B000MN3I36
B009OJR1NC
B001P1YXSI
B00G3QVIYM
B009EE4E4Q
B000MS47PY
B009OLR0QS
B009OJ8FC8
B0767JD8KR
B009K5YZT8
B00G3QTL14
B00G3N2D1C
B009OKFNL8
B009OLOMP0
Spreadsheet: 34634178-85f9-406a-a696-d419205d4317
Sheet: ARwT Costs

 | Arcata Rail with Trail Connectivity Project
 | Project Element | Total Project Cost | Tiger III Grant Request | Match Funding | Date of Completion
 | Trail Alignment Alternatives Analysis | 278000 | 0 | 278000 | 2011
 | Project Design Engineering | 577000 | 150000 | 427000 | 2012
 | Project Environmental Review (CEQA / NEPA) | 218000 | 0 | 218000 | 2011
 | Project Environmental Permitting | 142000 | 70000 | 72000 | 2012
 | Project Policy Planning Documents: Operational Plan, Review of compliance with NCRA Rail with Trail Policies | 76000 | 0 | 76000 | 2011
 | Property Acquisition and transfer expenses | 475000 | 375000 | 100000 | 2012
 | Project Construction including required project mitigation measures | 6800000 | 5980000 | 820000 | 2014
 | Totals |  |  |  | 2014
 | Project Operations and Maintenance for 20 years
 | Total 20 Year Project Cost
Spreadsheet: 122530d1316911083-excel-2007-count-or-countif-example-2
Sheet: Sheet1

Company A |  | August 2011 2012 |  |  |  |  |  |  | Total | Total
 |  | 1 |  | 2 |  | 6 |  |  | Breakfast | Lunch
 |  | B | L | B | L | B | L
Employee Name | Dept
 | 5029 | x | x | x | x | x
 | 3011 |  | x |  | x | x | x
 | 5055 | x | x | x | x | x | x
 | 5034 | x | x | x | x | x | x
 | 5043 | x | x | x | x |  | x
 | 5023 | x | x | x | x |  | x
 | 5022 | x | x | x | x |  | x
 | 5008 | x | x | x | x |  | x
 | 5021 | x | x | x | x |  | x
 | 5013 | x | x | x | x |  | x
 | 1001 |  | x | x | x | x
Total 5xxx | 5
Total 3xxx | 3
Total 1xxx | 1
Total Meals
Spreadsheet: 1f53220b-0463-4985-b9ff-5fd6bb2820ef
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
TIU | Test | TIU | Titanium, 24 Hour, [NAME] | Titanium, 24 Hr, U | Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 10 mL Collection Instructions:  1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.  Urine Preservative Collection Options  Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	No 6N HNO3	Yes Boric Acid	No Thymol	No | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-2 mcg/specimen | Thursday; 5 p.m. | Same day/1 day | 7 days | 1 | 83789 |  |  |  |  | Rochester
TIU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
TIU | Order Question | TM108 | Collection Duration |  | Plain Text
TIU | Order Question | VL108 | [NAME] |  | Number
TIU | Result | 33300 | Titanium, 24 Hr, U | Titanium, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | In Process
TIU | Result | VL108 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
TIU | Result | TM108 | Collection Duration | Collection Duration | Alphanumeric
TIU | Result | 33301 | Ti Concentration | Ti Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 275950d1383694032-index-formula-not-working-leavea
Sheet: Sheet2

Name | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 |  | 2013-02-03 00:00:00 |  |  | r
[NAME] | r | [NAME] | u | [NAME] | s
[NAME] | r
[NAME] | s
[NAME] | u
[NAME] | u
Al | r
Geoff | s
Spreadsheet: 833639d1687165750-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-copy-of-fvf_sample
Sheet: Dashboard

 |  | Top Scorer |  |  |  |  | Biggest 'Loser' |  |  |  | POTW League
 |  | Name | Total 'Goals' Scored |  |  |  | Name | %age Weight Loss |  |  | Name | Total POTW Medals
 |  | [NAME] | 5 |  |  |  | [NAME] | 0.05773857257417805 |  |  | [NAME] | 1
 |  | [NAME] | 5 |  |  |  | [NAME] | 0.02248394004282649 |  |  | [NAME] | 1
 |  | [NAME] | 4 |  |  |  | [NAME] | 0.01984564498346193 |  |  | [NAME] | 1
 |  | [NAME] | 3 |  |  |  | [NAME] | 0.01911667765326306 |  |  | Callum Stonehouse | 1
 |  | [NAME] | 3 |  |  |  | [NAME] | 0.01415094339622639 |  |  | [NAME] | 1
 |  | [NAME] | 3 |  |  |  | [NAME] | 0.01367365542388332 |  |  | [NAME] | 0
 |  | Callum Stonehouse | 2 |  |  |  | [NAME] | 0.01249178172255099 |  |  | [NAME] | 0
 |  | [NAME] | 2 |  |  |  | Callum Stonehouse | 0.01062215477996948 |  |  | [NAME] | 0
 |  | [NAME] | 2 |  |  |  | [NAME] | 0.005291005291005366 |  |  | [NAME] | 0
 |  | [NAME] | 2 |  |  |  | [NAME] | 0.002870813397129159 |  |  | [NAME] | 0
 |  | [NAME] | 2 |  |  |  | [NAME] | 0.002631578947368458 |  |  | [NAME] | 0
 |  | [NAME] | 2 |  |  |  | [NAME] | 0.001033057851239757 |  |  | [NAME] | 0
 |  | [NAME] | 1 |  |  |  | [NAME] | 0 |  |  | [NAME] | 0
 |  | [NAME] | 1 |  |  |  | [NAME] | 0 |  |  | [NAME] | 0
 |  | [NAME] | 1 |  |  |  | [NAME] | -0.008290155440414478 |  |  | [NAME] | 0
 |  | [NAME] | 1 |  |  |  | [NAME] | -0.01452282157676354 |  |  | [NAME] | 0
 |  | [NAME] | 0 |  |  |  | [NAME] | -0.01531291611185075 |  |  | [NAME] | 0
 |  | [NAME] | 0 |  |  |  | [NAME] | -0.01944728761514847 |  |  | [NAME] | 0
 |  | [NAME] | 0 |  |  |  | [NAME] | -0.02476515798462845 |  |  | [NAME] | 0
 |  | [NAME] | 0 |  |  |  | [NAME] | -0.1122244488977956 |  |  | [NAME] | 0
Spreadsheet: 250477d1373950685-delete-all-rows-in-workbook-with-same-title-ffcs-sample
Sheet: DRAFT

Round | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 693309d1598907240-sumifs-with-index-match-test1-bvj-
Sheet: Hours

Year | 2020
Period | 1 | 1 | 1 | 1 | P1 | 2 | 2 | 2 | 2 | P2 | 3 | 3 | 3 | 3 | P3 | 4 | 4 | 4 | 4 | P4 | 5 | 5 | 5 | 5 | P5 | 6 | 6 | 6 | 6 | P6 | 7 | 7 | 7 | 7 | P7 | 8 | 8 | 8 | 8 | P8 | 9 | 9 | 9 | 9 | P9 | 10 | 10 | 10 | 10 | P10 | 11 | 11 | 11 | 11 | P11 | 12 | 12 | 12 | 12 | P12 | 13 | 13 | 13 | 13 | P13 | YTD
Week | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | Total
Digging1 | 1 | 7 | 6 | 6 |  | 2 | 0 | 3 | 1 |  | 3 | 3 | 8 | 10 |  | 0 | 8 | 5 | 5 |  | 8 | 4 | 7 | 7 |  | 10 | 7 | 1 | 8 |  |  |  |  |  |  | 1 | 10 | 9 | 5 |  | 3 | 6 | 1 | 3 |  | 4 | 6 | 3 | 5 |  | 10 | 7 | 7 | 6 |  | 0 | 3 | 9 | 6 |  | 5 | 1 | 8 | 8
Digging2 | 1 | 7 | 8 | 0 |  | 3 | 10 | 7 | 3 |  | 8 | 5 | 5 | 7 |  | 5 | 9 | 6 | 5 |  | 1 | 10 | 8 | 6 |  | 10 | 0 | 5 | 10 |  |  |  |  |  |  | 3 | 7 | 10 | 9 |  | 6 | 9 | 7 | 0 |  | 1 | 4 | 0 | 8 |  | 8 | 3 | 7 | 4 |  | 10 | 1 | 6 | 0 |  | 8 | 10 | 6 | 6
Digging3 | 0 | 5 | 4 | 4 |  | 10 | 1 | 1 | 10 |  | 10 | 6 | 4 | 1 |  | 5 | 10 | 8 | 2 |  | 9 | 9 | 2 | 9 |  | 3 | 5 | 1 | 0 |  |  |  |  |  |  | 0 | 7 | 1 | 3 |  | 10 | 6 | 10 | 8 |  | 5 | 1 | 10 | 1 |  | 9 | 6 | 6 | 10 |  | 4 | 7 | 1 | 6 |  | 2 | 1 | 0 | 4
Digging4 | 10 | 0 | 5 | 2 |  | 9 | 10 | 10 | 9 |  | 9 | 2 | 1 | 10 |  | 1 | 7 | 5 | 2 |  | 9 | 9 | 5 | 6 |  | 8 | 6 | 5 | 7 |  |  |  |  |  |  | 8 | 0 | 1 | 2 |  | 6 | 2 | 5 | 1 |  | 8 | 2 | 10 | 8 |  | 1 | 9 | 0 | 5 |  | 2 | 9 | 5 | 1 |  | 9 | 10 | 4 | 0
Digging5 | 4 | 4 | 6 | 1 |  | 8 | 0 | 5 | 6 |  | 3 | 0 | 2 | 5 |  | 7 | 1 | 6 | 9 |  | 8 | 2 | 4 | 4 |  | 9 | 0 | 8 | 4 |  |  |  |  |  |  | 1 | 1 | 3 | 6 |  | 10 | 1 | 6 | 5 |  | 5 | 0 | 1 | 0 |  | 7 | 7 | 3 | 0 |  | 1 | 3 | 2 | 2 |  | 1 | 7 | 7 | 0
Digging6 | 0 | 9 | 0 | 8 |  | 2 | 8 | 7 | 2 |  | 9 | 10 | 3 | 8 |  | 0 | 9 | 10 | 6 |  | 7 | 3 | 5 | 4 |  | 3 | 3 | 0 | 8 |  |  |  |  |  |  | 0 | 9 | 5 | 2 |  | 8 | 8 | 0 | 0 |  | 10 | 9 | 2 | 3 |  | 6 | 3 | 1 | 2 |  | 8 | 1 | 3 | 2 |  | 7 | 3 | 5 | 5
Digging7 | 5 | 6 | 3 | 6 |  | 5 | 8 | 6 | 3 |  | 0 | 3 | 8 | 1 |  | 6 | 9 | 10 | 2 |  | 1 | 5 | 8 | 8 |  | 3 | 5 | 6 | 7 |  |  |  |  |  |  | 3 | 7 | 7 | 2 |  | 7 | 5 | 9 | 0 |  | 2 | 1 | 8 | 6 |  | 10 | 6 | 4 | 9 |  | 0 | 6 | 0 | 3 |  | 4 | 1 | 10 | 5
Spreadsheet: 835200d1688402542-find-multiple-occurrence-of-id-within-ranked-list-return-unique-id-unique-rank-example
Sheet: Unique Rank Example

 | ID | Rank | Child to Parent ID (1st occurrence) | Child to Parent ID (2nd occurrence) | Child to Parent ID (3rd occurrence)
 | 1001 | 1 |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  | 1004 | -
 |  |  |  | 1005 | -
 |  |  |  | 1002 | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  | 1015 | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  | - | -
 |  |  |  |  | 1005
Spreadsheet: 789067d1658879272-finding-same-point-in-3d-space-and-sorting-next-to-each-other-based-on-their-coordinates-3d-coordinates-sorting-example
Sheet: Sheet1

Member | X | Y | Z |  |  |  |  |  | Member | X | Y | Z
1 | 2.21 | 5.45 | -4.14 |  |  |  |  |  | 5 | 2.2 | 5.43 | -4.15
2 | 4.64 | -1.87 | 4.66 |  |  |  |  |  | 1 | 2.21 | 5.45 | -4.14
3 | 4.66 | 2.54 | 4.01 |  | What I would like to have --> |  |  |  | 2 | 4.64 | -1.87 | 4.66
4 | 4.65 | -1.86 | 4.65 |  |  |  |  |  | 4 | 4.65 | -1.86 | 4.65
5 | 2.2 | 5.43 | -4.15 |  |  |  |  |  | 3 | 4.66 | 2.54 | 4.01
6 | 4.64 | 2.56 | 3.99 |  |  |  |  |  | 6 | 4.64 | 2.56 | 3.99
 |  |  |  |  |  |  |  |  | Member | X | Y | Z
 |  |  |  |  |  |  |  |  | 5 | 2.2 | 5.43 | -4.15
 |  |  |  |  |  |  |  |  | 1 | 2.21 | 5.45 | -4.14
 |  |  |  |  | Example of sorting by X (incorrect) --> |  |  |  | 2 | 4.64 | -1.87 | 4.66
 |  |  |  |  |  |  |  |  | 6 | 4.64 | 2.56 | 3.99
 |  |  |  |  |  |  |  |  | 4 | 4.65 | -1.86 | 4.65
 |  |  |  |  |  |  |  |  | 3 | 4.66 | 2.54 | 4.01
Spreadsheet: 776371d1649701418-check-if-cell-contains-numbers-from-list-excel-forum
Sheet: Sheet1

Table Array | No |  | Lookup Value | Result to check if Lookup value (Column D) is in the Table Array Column A and to give result No (Column B)
34861625 | 1 |  | 176 | 4,7,9
2223356 / 8270514 | 2 |  | 552 | 8
612887 and 870012 | 3 |  | 8616 | 1,10
120220/ 1762307 | 4 |  | 436 | 8
39001 | 5
810849 | 6
1762343, 800412 | 7
5527435;5527436 | 8
23176 | 9
8616 | 10
Spreadsheet: 146383d1332161768-which-formula-would-work-weather-data-calculation1-do-not-alter-
Sheet: CALCS DO NOT CHANGE

Heading | Degrees
N | 0
NNE | 22.5
NE | 45
ENE | 67.5
E | 90
ESE | 112.5
SE | 135
SSE | 147.5
S | 180
SSW | 202.5
SW | 225
WSW | 247.5
WSW | 270
WNW | 292.5
NW | 315
NNW | 337.5
Spreadsheet: 855083d1704789521-filter-without-result-to-show-blank-for-vstack-filter-without-result-2-
Sheet: Sheet2

Code | Start | End | Prorate |  |  | 2023-05-31 00:00:00 |  | Code | Start | End | Cost
#1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  |  | 2023-05-12 00:00:00 |  | 500 |  | Basically, I want the top to be Code that start in the Month (E1) and bottom to show Code that end in the Month (E1)
#2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  | However, the formula only work nicely if the filter is a valid for both Start and End.
#3 | 2023-06-11 00:00:00 |  | 150 |  |  |  |  |  |  |  |  |  | How do I make a Iferror, then it will show blank?
#4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600
#5 | 2023-07-11 00:00:00 |  | 800 |  |  |  |  |  |  |  |  |  | *If the eomonth of START = G1, den ((G1-Start)/day(G1))*column D
#6 | 2023-09-01 00:00:00 |  | 300 |  |  |  |  |  |  |  |  |  | if eomonth of [NAME], den ((Day(end)/Day(g1))*column D
#7 | 2023-09-16 00:00:00 |  | 600
#8 | 2023-10-01 00:00:00 |  | 900
#9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
#10 | 2023-10-31 00:00:00 |  | 3000
 |  |  |  |  |  |  |  | Code | Start | End | Cost
 |  |  |  |  |  | 2023-05-31 00:00:00 |  |  |  |  |  |  |  | 2023-12-31 00:00:00
 |  |  |  |  |  |  | Expected |  |  |  |  |  |  |  | Expected
 |  |  |  |  |  |  |  | Code | Start | End | Cost |  |  |  |  | Code | Start | End | Cost
 |  |  |  |  |  |  |  | #1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  | #9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600
 |  |  |  |  |  |  |  | Code | Start | End | Cost | Prorate |  |  |  | Code | Start | End | Cost | Prorate
 |  |  |  |  |  |  |  | #1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  | #9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600
 |  |  |  |  |  | The month in G1 is like "For the Month of xxxxx". Not juz the day itself. Hence 31/5/2023 mean 1st to 31st May
 |  |  |  |  |  | *For the Prorate part, if [NAME] in the Month, the amt to prorate = ((Number of days in the month)-(Start Date)+1)/(Number of days in the month)* Monthly Rate
 |  |  |  |  |  | If it end on the month itself, then would be (Day end)/(Number of days in the month)* Monthly Rate
 |  |  |  |  |  | The formula is fine if the filter criteria is Valid for both Start and End (eg 30/06/2023), but it haywire if either one is error.
Spreadsheet: 101076d1299236824-linking-rows-together-when-cells-can-change-team-stats-sheet-master-
Sheet: ACW

 | ACW
 | Name |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week
 | First | Surname | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Grant | A | 1
 | Mark | B | 2
 | [NAME] | C | 3
 | June | D | 4
 | Julie | E | 5
 | Rosemary | F | 6
 | [NAME] | G | 7
 | Lizzie | H | 8
 | [NAME] | I | 9
 | [NAME] | J | 10
 | [NAME] | K | 11
 | Heather | L | 12
 | [NAME] | M | 13
 | [NAME] | N | 14
 | [NAME] | O | 15
 | [NAME] | P | 16
 | [NAME] | Q | 17
 | Billie | R | 18
 | [NAME] | S | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 | Team Average |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Target | 20
 |  | Copyright 2011 MW
Spreadsheet: 864862d1711992027-formula-for-cell-comparisons-and-mine-sweep-style-corrections-excel-sample-for-excel-forum-1_4_24
Sheet: Sheet1

 |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U
 | x/y
0 |  | 2 | 11 | 29 | 50 | 58 | 50 | 42 | 36 | 40 | 40 | 35 | 22 | 17 | 21 | 21 | 34 | 42 | 47 | 40 | 22 | 22
1 |  | 7 | 10 | 33 | 69 | 61 | 51 | 44 | 44 | 37 | 42 | 42 | 37 | 26 | 25 | 22 | 27 | 52 | 69 | 62 | 46 | 30
2 |  | 12 | 16 | 32 | 65 | 57 | 47 | 42 | 47 | 40 | 45 | 45 | 40 | 42 | 41 | 40 | 50 | 67 | 75 | 72 | 65 | 51
3 |  | 9 | 18 | 34 | 63 | 56 | 50 | 44 | 46 | 39 | 47 | 48 | 47 | 48 | 50 | 54 | 56 | 68 | 78 | 73 | 65 | 51
4 |  | 9 | 15 | 26 | 47 | 58 | 50 | 42 | 45 | 35 | 40 | 47 | 46 | 48 | 52 | 44 | 46 | 60 | 68 | 59 | 49 | 40
5 |  | 1 | 2 | 14 | 33 | 50 | 48 | 39 | 37 | 26 | 24 | 29 | 37 | 41 | 50 | 39 | 40 | 57 | 62 | 55 | 38 | 33
6 |  | 10 | 13 | 20 | 39 | 48 | 47 | 43 | 40 | 33 | 37 | 44 | 45 | 49 | 53 | 51 | 51 | 59 | 66 | 61 | 46 | 34
7 |  | 13 | 16 | 28 | 44 | 52 | 53 | 49 | 48 | 46 | 48 | 63 | 56 | 52 | 58 | 58 | 66 | 71 | 75 | 69 | 56 | 41
8 |  | 13 | 19 | 29 | 44 | 53 | 51 | 46 | 47 | 44 | 43 | 48 | 48 | 49 | 60 | 60 | 63 | 48 | 76 | 69 | 55 | 38
9 |  | 11 | 13 | 20 | 35 | 43 | 37 | 38 | 36 | 30 | 32 | 35 | 34 | 37 | 49 | 48 | 46 | 58 | 65 | 59 | 40 | 27
 |  | 7 | 10 | 33 | 69 | 61 | 51 |  | 6 | 6 | 12 | 18 | 24 | 24 |  | 1 | 4 | 21 | 51 | 37 | 27
 |  | 12 | 16 | 32 | 65 | 57 | 47 |  | 6 | 12 | 12 | 18 | 18 | 24 |  | 6 | 4 | 20 | 47 | 39 | 23
 |  | 9 | 18 | 34 | 63 | 56 | 50 |  | 6 | 6 | 12 | 12 | 18 | 24 |  | 3 | 12 | 22 | 51 | 38 | 26
 |  | 9 | 15 | 26 | 47 | 58 | 50 |  | 6 | 6 | 6 | 12 | 18 | 24 |  | 3 | 9 | 20 | 35 | 40 | 26
 |  | 1 | 2 | 14 | 33 | 50 | 48 |  | 0 | 0 | 6 | 12 | 18 | 24 |  | 1 | 2 | 8 | 21 | 32 | 24
 |  | 10 | 13 | 20 | 39 | 48 | 47 |  | 6 | 6 | 6 | 12 | 18 | 24 |  | 4 | 7 | 14 | 27 | 30 | 23
 |  | 13 | 16 | 28 | 44 | 52 | 53 |  | 12 | 12 | 12 | 12 | 18 | 24 |  | 1 | 4 | 16 | 32 | 34 | 29
Spreadsheet: 88026d1287928945-conversion-within-sum-solution-cntr-freight-rates-3-_dl
Sheet: test

 | exchange rates |  |  |  |  |  |  |  | tonnage
 | IEURUSD |  | 1.3958 |  |  |  | Apple |  | 22.5
 | IGBPUSD |  | 1.3958 |  |  |  | Orange |  | 23
 |  |  |  |  |  |  | Mango |  | 25
Origin | Destination | CR | base rate/tc | CR | BAF | CR | THC +ISPS | CR | ERS/EBS/SUEZ/ERC | rate /mt
Apple | A | EUR | 860 | GBP | 465 | GBP | 100 | EUR | 100 | #N/A
Mango | B |  | 860 |  | INCL |  | INCL |  | 100 | #N/A
Orange | C |  | 860 |  | INCL |  | INCL |  | 100 | #N/A
Apple | D |  | 2060 |  | INCL |  | 830 |  | 0 | #N/A
Mango | E |  | 1700 |  | INCL |  | 0 |  | 175 | #N/A
Spreadsheet: 463994d1464826406-would-like-to-show-days-off-in-my-gantt-chart-would-like-to-show-days-off-in-my-gantt-chart
Sheet: Sheet1

Site 1
Trainer Availability
Trainer 1 | TR 1
Trainer 1 | TR 2
Trainer 1 | TR 3
Trainer 1 | TR 4
Trainer 2 | TR 1
Trainer 2 | TR 2
Trainer 2 | TR 3
Trainer 2 | TR 4
Trainer 3 | TR 1
Trainer 3 | TR 2
Trainer 3 | TR 3
Trainer 3 | TR 4
Trainer 4 | TR 1
Trainer 4 | TR 2
Trainer 4 | TR 3
Trainer 4 | TR 4
Trainer 5 | TR 1
Trainer 5 | TR 2
Trainer 5 | TR 3
Trainer 5 | TR 4
Trainer 6 | TR 1
Trainer 6 | TR 2
Trainer 6 | TR 3
Trainer 6 | TR 4