tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4676b776-c339-4758-b2a5-cef56f8e7f77
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
FFURO | Test | FFURO | Furosemide (Lasix) | Furosemide (Lasix) | High Performance Liquid Chromatography with Fluorescence |  |  |  | 1 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 1 mL sodium heparin plasma refrigerated in a plastic vial.  Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Expected serum furosemide concentration in patients on usual daily dosages:  Up to 5.0  ug/mL   Toxic:	greater than 50.0  ug/mL   Test Performed by: Medtox Laboratories, Inc                               402 W. County Road D                               St. Paul, MN 55112 | Monday through Sunday | 7 days | 9 - 11 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
FFURO | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FFURO | Result | Z1189 | Furosemide | Furosemide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 4f5f2cd0-9bcb-4b2e-a805-fd5143765ef9
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40356105 | 2014-03-04 21:06:10 | ALLIES | 1 | 5 | 1 | 412088 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40356359 | 2014-03-04 21:23:49 | AXIS | 0 | 2 | 5 | 412088 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40356669 | 2014-03-04 21:47:51 | ALLIES | 1 | 5 | 4 | 954955 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40357072 | 2014-03-04 22:00:20 | AXIS | 1 | 5 | 2 | 954955 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40418185 | 2014-03-08 19:36:50 | AXIS | 1 | 6 | 1 | 537912 | Paso7 | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
40418435 | 2014-03-08 19:56:49 | ALLIES | 1 | 6 | 4 | 537912 | Paso7 | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
Spreadsheet: drew_fossum__8874__01_19_00StanH_mtg_final
Sheet: TW 

Transwestern Pipeline Company
Variance 1999 Actuals to Restated 1999 Plan & 3CE
Margin Summary
 |  |  | $Millions
1999 Restated Plan |  |  | 147.28306
West |  |  | -0.2755599999999977
East |  |  | -3.5323 | Demand--644/day @ $08 original plan vs. 582/day @ .079 actually achieved
 |  |  |  | Commodity--553/day@$.02 original plan vs. 413/day @ $.018 actually achieved
[NAME] |  |  | -1.4434 | 120/d of Red Cedar capacity partially unsubscribed
San Juan |  |  | 0.1020999999999998
Total |  |  | -5.149159999999998
1999 Actuals |  |  | 142.1339
1999 3rd Current Estimate |  |  | 141.3
West |  |  | 0.5 | Increased daily firm and LFT
East |  |  | 0.4 | Increased IT volumes
[NAME] |  |  | -0.1
San Juan |  |  | 0
Total
1999 Actuals
Transwestern Pipeline Company
Variance 1999 Actuals to 2000 Plan
Margin Summary
1999 Actuals |  |  | 142.1339
West |  |  | 7.7 | Gallup
East |  |  | -3.6 | Burlington contract for 100/d expired Nov. 1999;
 |  |  |  | Burlington contract for 55/d expires Feb. 2000
[NAME] |  |  | 0.2
San Juan |  |  | 0.8 | Gallup
Total
2000 Plan |  |  | 147.2
Transwestern Pipeline Company
[NAME] Plan to 1999 Actuals
1999 Plan Fuel Revenues |  |  | 18.6
Decreases due to index price |  |  |  | Actual index prices less than in plan.
UAF adjustments |  |  | 0.3 | UAF actuals less than in plan.
Decreases due to increased usage % |  |  | -1.4 | Original plan used fuel usage % of .015, changed to .017 in
 |  |  |  | 1st current estimate.
Hedges |  |  | 0.6 | Additional hedge made in April, 1999.
1999 Actuals
Spreadsheet: 674685d1587988464-combination-of-two-iterative-formula-reddit_template_v3
Sheet: Sheet1

 |  | ARRAY 1 |  |  |  |  |  |  |  |  | 1
3 | 1 | [NAME] | STEPHEN | JOANNE |  |  |  |  |  |  | 2
4 | 2 | TREVOR | THOMAS | FRED | [NAME] |  |  |  |  |  | 3
2 | 3 | STEPHEN | ANDREW |  |  |  |  |  |  |  | 4
3 | 4 | CRAIG | TREVOR | THOMAS |  |  |  |  |  |  | 5
7 | 5 | JOANNE | FRED | TREVOR | THOMAS | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  | 3 | 1
 |  |  |  |  |  |  |  |  |  | 4 | 2
 |  |  |  |  |  |  |  |  |  | 2 | 3
 |  | ARRAY 2 |  |  |  |  |  |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  | 7 | 5
 |  |  |  |  |  |  |  |  |  |  | W/O VLOOKUP
 |  |  |  |  |  |  |  |  |  |  | WITH VLOOKUP
Spreadsheet: 298370d1392771287-index-and-match-formula-monthsie-totals
Sheet: Zone Total

 |  |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December | Total
Sr | Category | Description | Pack size | Unit | Zone-A (Total) |  |  |  |  |  |  |  |  |  |  |  | Total
1 |  | Delico | 0.4 | [NAME]
2 |  | Parco | 10 | [NAME]
3 |  | Doce | 0.25 | [NAME]
4 |  | Fast | 0.35 | [NAME]
5 |  | Sider | 1 | [NAME]
6 |  | Glaxo | 10 | [NAME]
7 |  | Sweets | 0.25 | [NAME]
8 |  | Parden | 0.5 | [NAME]
9 |  | Romeo | 0.25 | [NAME]
10 |  | Clutch | 1 | [NAME]
11 |  | [NAME] | 10 | [NAME]
12 |  | Rifit | 0.5 | [NAME]
13 |  | Ganzo | 0.5 | [NAME]
Spreadsheet: 732410d1620931973-add-to-numbers-in-a-string-date-display
Sheet: Sheet1

Start | Finish | Display
2021-05-21 00:00:00 | 2021-05-27 00:00:00
Spreadsheet: 765078d1643149946-determining-work-time-based-on-criteria-book4
Sheet: Sheet2

 |  | [NAME] | ST | Span | Work | Output | w/ [NAME]
 |  | No | 7.25 | 11.25 | 7.5 | 7.75 | 7.749999999999999
 |  | Yes | 7.25 | 11.75 | 7.25 | 7.25
 |  | Yes | 7.25 | 11.75 | 7.25 | 7.25
 |  | Yes | 7.25 | 12 | 7.25 | 7.25
 |  | Yes | 7.25 | 12.5 | 7.5 | 7.25
 |  | No | 7.5 | 11.25 | 7.749999999999999 | 7.75 | 7.749999999999999
 |  | No | 7.5 | 11.25 | 7.749999999999999 | 7.75 | 7.749999999999999
 |  | No | 7.5 | 11.5 | 8.25 | 7.75 | 7.749999999999999
 |  | Yes | 7.5 | 11.5 | 8 | 7.5
 |  | No | 7.5 | 11.5 | 8.25 | 7.75 | 7.749999999999999
 |  | Yes | 7.5 | 12.25 | 8.5 | 7.25
 |  | Yes | 7.5 | 12.5 | 9 | 7.5
 |  | Yes | 7.5 | 13 | 9.5 | 7.5
 |  | Yes | 7.749999999999999 | 11.25 | 8 | 7.75
 |  | Yes | 7.749999999999999 | 11.75 | 8.5 | 7.75
 |  | Yes | 7.749999999999999 | 11.75 | 8.5 | 7.75
 |  | Yes | 7.749999999999999 | 11.75 | 8.5 | 7.75
 |  | Yes | 7.749999999999999 | 11.75 | 8.5 | 7.75
 |  | No | 7.749999999999999 | 12 | 9 | 8 | 8
 |  | Yes | 7.749999999999999 | 12 | 8 | 8
 |  | No | 7.749999999999999 | 13 | 9.5 | 8
 |  | No | 7.5 | 12.5 | 8.5 | 7.75 | 7.75
 |  | No | 7.5 | 12 | 8.75 | 7.75 | 7.75
Spreadsheet: 871129d1717566403-fishing-match-calcs-help-needed-please-fishing-match-v1
Sheet: 2

Croft Fisheries | Huyton 1 | 18th September 2016
Name | lbs | oz | Oz (total) | Points
 | 45 | 1
 | 45 | 2
 | 45 | 3
 | 45 | 4
 | 45 | 5
 | 45 | 6
 | 45 | 7
 | 45 | 8
 | 45 | 9
 | 45 | 10
 | 45
 | 45
 | 45
 | 45
 | 45
Spreadsheet: 836799d1689662962-filter-birthdays-onto-dynamic-calendar-calendar-birthdays-aligw
Sheet: Calendar

 |  | JULY |  | MONDAY
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  |  |  |  |  |  |  |  |  |  | Optional if you can do it too
 |  |  |  |  |  |  |  |  |  |  | 2023-07-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  | PERSON A - AGE 46
 |  |  |  |  |  |  |  |  |  |  | PERSON B - AGE 41
 |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaa
Spreadsheet: 600113d1543479933-blank-repetitive-info-book1
Sheet: Sheet2

12
12
12
12
12
12
12
Spreadsheet: 200487d1355573175-quick-entry-of-biological-species-dynamic-validation-based-on-3-chars
Sheet: Sheet1

Genus | Species |  | agros
Agrostis | [NAME]
Agrostis | vinealis
Agrostis | curtisii
Agrostis | stolonifera
[NAME] | ab1
[NAME] | ab2
[NAME] | [NAME]
[NAME] | ab4
[NAME] | ab5
Spreadsheet: 695339d1600160248-averageif-on-separate-values-without-0-book9-etaf
Sheet: Sheet1

 |  |  | PLANT 1 |  |  |  | PLANT 2 |  |  |  | PLANT 3 |  |  |  | TOTAL
 |  | SEASON | Avail | ADR BAR |  | SEASON | Avail | ADR BAR |  | SEASON | Avail | ADR BAR |  | SEASON | Avail | ADR BAR
 |  | L | 0 | 0 |  | L | 3 | 3000 |  | L | 0 |  |  | L |  |  | average without 0
 |  | H | 72 | 8700 |  | H | 56 | 5000 |  | H | 67 | 4500 |  | H |  |  | average without 1
 |  | P | 34 | 9000 |  | P | 78 | 8000 |  | P | 100 | 5500 |  | P |  |  | average without 2
Spreadsheet: benjamin_rogers__935__PJM DAILY NEW
Sheet: _Wizard

xOTH.TRANSCO.Z6.NY MidPoint Px!$L$1 | x | xOTH.TRANSCO.Z6.NY | xMidPoint | [NAME] | [NAME] | x4 | x1 | [NAME] | x$L$1 | x|False|year(s)|day(s)|1|1|3/12/2001|7:20am|False|False|7:20am|1/1/1998|True|True|False|False|False|USD|MMBTU|False | x|True|True|False|True|False|False | xWizard | xa NaN | xDate is after 1 day before 3/12/2001 | xFalse | xFalse | xTrue | xFalse | xTrue | xMidPoint of OTH.TRANSCO.Z6.NY | xFalse | x-1 | [NAME] | xExpiration Day | x | [NAME] | [NAME] | xUSD | xFalse
Spreadsheet: 218183d1362388241-organising-inventory-upload-for-help
Sheet: Inventory Management

 | Total quantity | loan out | maintenance | present remainder | Date |  | Start Date | End Date
Chair | 10 | what to formular to place here |  |  |  |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00
Table | 10
Lamp | 10
Bottle | 10
[NAME] | 10
Laptop | 10
Spreadsheet: 133983d1324896331-dynamic-dates-range-extend-to-the-associated-cells-book1
Sheet: 1

V2 | V3 | V4 | V5 | V1 | V7 | V8 | V9 | V10 | V6
NV2 | NV3 | NV4 | NV5 | NV1 | NV7 | NV8 | [NAME] | NV10 | NV6
LC2 | LC3 | LC4 | LC5 | LC1 | LC7 | LC8 | LC9 | LC10 | [NAME]
HV2 | HV3 | HV4 | HV5 | HV1 | HV7 | HV8 | HV9 | HV10 | HV6
HNV2 | HNV3 | HNV4 | HNV5 | HNV1 | HNV7 | [NAME] | HNV9 | HNV10 | HNV6
HLC2 | HLC3 | HLC4 | HLC5 | HLC1 | HLC7 | [NAME] | HLC9 | HLC10 | HLC6
row 1 has dynamic dates for two weeks, excluding fri & sat and it is working fine.
row 2 has no purpose except to show the weekday for each date in row 1.
row 3 to 8, each row has 10 codes and are divided over 10 days that represents one code for each day of the week.
two weeks count starts from cell [NAME] which gets updated everyday for the current day
for each day the code is fixed, such as for 1st sunday V1 and for 2nd sunday V6, for 1st monday V2 and 2nd monday V7 and so on….
each day of the week repeated twice so all 10 codes can be represented, I need the code also be dynamic and change everday as dates in row one changes.
from the above example A1 is 1st Monday so the code is [NAME] and F1 is 2nd Monday and code is V7
Spreadsheet: 150828d1334689096-find-and-list-corresponding-values-in-a-column-in-descending-order-sans_descending-order_17apr12_03
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB
 |  |  |  |  |  |  |  |  |  |  |  | 0.02021212727636582 | 0.07064238543125875 | 0.05263157894736842 | 0.08044826896137683 | 0.1420852511506904 | 0.06283770262157294 | 0.05143085851510906 | 0.1364818891334801 | 0.1060636381829097 | 0.0278166900140084 | 0.01681008605163098 | 0.05663398038823294 | 0.07164298579147488 | 0.03702221332799679 | 0.004802881729037423 | 0.002201320792475486 | 0.008805283169901942 | 0.01821092655593356 | 0.01600960576345807 | 0.009405643386031618 | 0.0006003602161296778 | 0 | 0.00100060036021613 | 0.001801080648389033 | 0.001600960576345807 | 0.001600960576345807 | 0.00100060036021613 | 0
 |  |  |  |  |  |  |  |  |  |  |  | List
 |  |  |  |  |  |  |  |  |  |  |  | Letters | Numbers
Spreadsheet: dan_hyvl__4718__City of Palo Alto
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY: | [NAME]
DATE: | 2001-01-12 00:00:00 | ECT CONTACT: | [NAME]
COUNTERPARTY: | City of Palo Alto | CONTACT: | [NAME]
ADDRESS: |  | TITLE:
 |  | PHONE: | [PHONE]
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ECT ENTITY
COLLATERAL
THRESHOLD  in $ | $7.5MM | $10MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | $15MM
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = |  | BBB- | S&P
Financial Covenants | X
-Funded Debt/Net Worth | 0.25:1
-Minimum Net worth | $400MM
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty | $5MM
-Guarantor ($[NAME]) |  | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X5-7095
Spreadsheet: 012e8d62-4303-4276-9b65-bedcb781e84c
Sheet: fy12 budget (2)

FSYR | 2012 |  | 1= president
ORGN CODE | (All) |  | 2= Academic Affairs
 |  |  | 3= Finance & Administration
Row Labels | Sum of BEGINNING BUDGET |  | 4= Strategy & Planning
1 | 1715950 |  | 5= Student Affairs
2 | 24225239 |  | 6= Development
3 | 11834075 |  | 9= Non budgeted
4 | 272144 |  | X= funded by non-transferrable revenue
5 | 2658064 |  | F= Facilities
6 | 449832
9 | 0
X | 4890628
F | 5531857
Grand Total | 51577789
Spreadsheet: 0ac8832c-2688-44b6-9b41-74e8fea284e3
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
AMIKR | Test | AMIKR | Amikacin, Random, Serum | Amikacin, Random, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down within 2 hours of draw. Additional Information: Serum for a peak level should be drawn 30 to 60 minutes after last dose (order AMKPK/82112 Amikacin, [NAME], Serum). Serum for a trough level should be drawn immediately before next scheduled dose (order AMIKT/81593 [NAME], Trough, Serum). | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | AMIKACIN, PEAK Therapeutic range: 20.0-35.0 mcg/mL  AMIKACIN, TROUGH Therapeutic range: <8.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80150 |  |  |  |  | Rochester
AMIKR | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
AMIKR | Result | 81752 | Amikacin, Random, S | Amikacin, Random, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 35669-1 | Amikacin^random:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 46774d1245712803-lookup-or-vlookup-within-cse-array-2007-for-excel-forum
Sheet: Data Table

 |  |  |  |  |  |  |  | 3. Time To Try VLOOKUP
Table="Transactions" |  |  |  |  |  |  |  | In the F column, I try a VLOOKUP version of the formula used in the E |  |  |  |  |  | Table="Shipping"
 |  |  |  |  |  |  |  | column.  Because I request an exact match, I hope that this formula will
[NAME] | Wk | From | To-Country | Sum Of Alt Routes (LOOKUP method) | Sum Of Alt Routes (VLOOKUP method) |  |  | alert me if route data is missing from the [NAME] table.  Unfortunately, I cannot explain the results.  So now I am stuck.  Can you help me?    I am looking for a formula that does not require new rows or columns, |  |  |  |  |  | Route | K-km
1 | 2008-01-10 00:00:00 | ch | asia |  |  |  |  | other than those shown here. And it should alert me in some way |  |  |  |  |  | ch-asia | 2.655768
2 | 2008-01-10 00:00:00 | [NAME] | euro |  |  |  |  | (ex: #N/A) if route data is missing from the [NAME] table. Thanks! |  |  |  |  |  | ch-br | 19.068192
3 | 2008-01-10 00:00:00 | us | lam |  |  |  |  |  |  |  |  |  |  | [NAME] | 16.855052
 |  |  |  |  |  |  | ^^^^^ |  |  |  |  |  |  | [NAME] | 1.54642
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10.098956
 | 1. A Cell That Works Perfectly: The Yellow Cell |  |  |  |  | >>> |  | 2. A Cell That Doesn't Work: The Pink Cell |  |  |  |  |  | tu-ireland | 4.00032
 |  |  |  |  |  |  |  |  |  |  |  |  |  | tu-it | 0.8593280000000001
 | The yellow cell works perfectly.  It asks: |  |  |  |  |  |  | The same formula in the pink cell doesn't meet my needs. It asks: |  |  |  |  |  | tu-lam | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | us-asia | 13.764064
 | Q: Who were the other suppliers -- other than ch -- on 1/10/2008? |  |  |  |  |  |  | Q: Who were the other suppliers -- other than [NAME] -- on 1/10/2008? |  |  |  |  |  | us-br | 9.009979999999999
 | A: [NAME] and us |  |  |  |  |  |  | A: ch and us |  |  |  |  |  | us-lam | 2.189064
 | Q: What is the distance from [NAME] to asia? From us to asia? |  |  |  |  |  |  | Q: What is the distance from ch to euro? From us to euro?
 | A: 16.9 and 13.8 |  |  |  |  |  |  | A: Clunk ! [NAME]! Because neither route is listed in the Shipping table,
 |  |  |  |  |  |  |  | the next "lowest" entries are used.  This results in adding the ch-br
 | Q: Add them together |  |  |  |  |  |  | and us-br distances, yielding 28.1. For my purposes, this result is
 | A: 30.6 |  |  |  |  |  |  | a random number.
 | CORRECT!! |  |  |  |  |  |  | Bigger problem:  aside from being "random", the 28.1 result does not
 |  |  |  |  |  |  |  | warn me that the required route information needed was not listed in the
 |  |  |  |  |  |  |  | Shipping table.  Thus, I can't tell which of my results are valid (yellow)
 |  |  |  |  |  |  |  | or invalid (pink).
Spreadsheet: 763913d1642452938-alternative-for-too-many-ifs-nested-in-the-formula-spreadsheet-is-still-growing-margin
Sheet: Sheet1

 | Sales Margin
Sub-Cat | SELL PRICE 1 - RETAIL/LIST | SELL PRICE 2 - WHOLESALE | SELL PRICE 3 - DISTRIBUTOR | COMMENTS
1 | 1.1 | 1.1 | 1.1 | Customer A
1.1 | 1.1 | 1.4 | 1.3
2 | 1.2 | 1.2 | 1.2
2.1 | 1.2 | 1.15 | 1.1 | Customer B
3 | 1.3 | 1.3 | 1.3 | Customer C
3.1 | 1.3 | 1.25 | 1.2
4 | 1.4 | 1.4 | 1.4 | Customer D
4.1 | 1.4 | 1.3 | 1.2
5 | 1.5 | 1.5 | 1.5 | Customer E
5.1 | 1.5 | 1.4 | 1.3 | Customer F
5.2 | 1.5 | 1.3 | 1.3
Spreadsheet: 759240d1639434693-count-when-certain-amounts-are-reached-from-a-running-total-sum-query
Sheet: Sheet1

 |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | Hours | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 |  | [NAME]
 |  | Requried | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0
 |  | Triggers
 |  | 1600
 |  | 3200
Spreadsheet: 834806d1688097495-excel-sheet-for-project-task-management-project
Sheet: Tasks

a | Task 1
b | Task 2
c | Task 3
d | Task 4
e | Task 5
f | Task 6
g | Task 7
h | Task 8
i | Task 9
j | Task 10
k | Task 11
l | Task 12
m | Task 13
n | Task 14
o | Task 15
p | Task 16
q | Task 17
r | Task 18
s | Task 19
t | Task 20
u | Task 21
v | Task 22
w | Task 23
x | Task 24
y | Task 25
z | Task 26
Spreadsheet: dutch_quigley__9412__NymexPos
Sheet: Gasoline Futures

UNLEADED GASOLINE FUTURES
2001-12-01 00:00:00 | -617
2002-01-01 00:00:00 | 377
2002-02-01 00:00:00 | -32
2002-03-01 00:00:00 | 89
2002-04-01 00:00:00 | 194
2002-05-01 00:00:00 | -188
2002-06-01 00:00:00 | 408
2002-07-01 00:00:00 | -275
2002-08-01 00:00:00 | 110
TOTAL
Spreadsheet: 826253d1681897721-advanced-array-formula-help-example
Sheet: Training Capacity Levels

Training Week | Trainee | Trainer
1 | 0 | 0.25
2 | 0 | 0.25
3 | 0 | 0.25
4 | 0 | 0.25
5 | 0 | 0.25
6 | 0 | 0.25
7 | 0 | 0.25
8 | 0 | 0.75
9 | 0 | 0.75
10 | 0 | 0.75
11 | 0 | 0.75
12 | 0 | 0.75
13 | 0 | 0.75
14 | 0 | 0.75
15 | 0.5 | 0
16 | 0.5937499999999999 | 0
17 | 0.65625 | 0
18 | 0.7499999999999999 | 0
19 | 0.84375 | 0
20 | 0.9062499999999999 | 0
21 | 1 | 0
22 | 1 | 1
Spreadsheet: 1d748d79-d362-48ce-9293-3377124ae372
Sheet: Sheet1

1184 Lenti–Letenye–Nagykanizsa–Budapest | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2
 |  |  |  |  | 82
 |  |  |  |  | E
0 | .. | .. | .. | Lenti, aut. áll. | [NAME]
9.6 | .. | .. | .. | Lovászi, Bányász Presszó | 15:25:00
13.2 | .. | .. | .. | Tornyiszentmiklós, vegyesbolt | 15:30:00
14.2 | .. | .. | .. | Tornyiszentmiklós, kultúrház | 15:31:00
16 | .. | .. | .. | Dobri, vegyesbolt | 15:34:00
20.3 | .. | .. | .. | Csörnyeföld, kh. | 15:41:00
26.5 | .. | .. | .. | [NAME], vegyesbolt | 15:49:00
31.4 | .. | .. | .. | [NAME], aut. áll. | 15:54:00
31.4 | .. | .. | .. | [NAME], aut. áll. | 16:00:00
53.6 | .. | .. | .. | Nagykanizsa, aut. áll. | 16:25:00
53.6 | .. | .. | .. | Nagykanizsa, aut. áll. | 16:40:00
259.7 | .. | .. | .. | Budapest, [NAME] út (csak leszálló utasok részére) | 19:04:00
262 | .. | .. | .. | Budapest, [NAME] út (csak leszálló utasok részére) | 19:07:00
263.6 | .. | .. | .. | Budapest, Petőfi híd, budai hídfő (csak leszálló utasok részére) | 19:11:00
268.3 | .. | .. | .. | Budapest, Népliget aut. pu. | 19:20:00
[NAME]:
A járatok az [NAME], de a mezőben fel [NAME]
[NAME] megállóhelyeknél [NAME] állnak meg.
0 csomagkezelést nem igénylő utasok részére
[NAME]: 82 XII. 26.
E | a hetek első munkanapját megelőző [NAME]
Spreadsheet: 99709d1298306678-count-until-a-condition-is-met-dummydata-2011-02-21
Sheet: Sheet1

Number | Name | Status
1 | Apple | Yes |  | Goal = | 6
2 | Beets | No |  | Number Yes=
3 | Grapes | Never |  | Number No =
4 | Apricots | Maybe
5 | Tangerine | Yes
6 | Plums | No
7 | Lemons | Yes
8 | Limes | Yes
9 | Stawberry | Yes
10 | Peas | Yes
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -492632 | -494656
2 | -501900 | -485325
3 | -540213 | -539549
4 | -472917 | -473220
5 | -501953 | -499242
6 | -549512 | -560014
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
2001-12-31 00:00:00 |  |  |  |  | 104420
2002-01-06 00:00:00
CBS Dollars
 |  |  | 331917