tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153069d1335745038-excel-2007-conditional-formatting-with-2-variables-rick52a
Sheet: Sheet1

 |  | [NAME] |  |  |  | 2012-04-26 00:00:00
 | Safety | Environmental | Nexfos | Quality | Production | Cost
Lvl 1 KPI | 0 | 0 | 0.1917 | 0.1636 | 935
 | OSHA Rec's | Reportable |  |  | Total > 2350 | Spending
Lvl 2 KPI | 0 | 0 | 0.0532 | 0.0511 | 9.9
 | First Aids | Spills |  |  | Total DT | MMBTU < 1.2
Lvl 3 KPI | 8 | 0 | 0.012 | 0.062 | 110 | 124
 | >8 Observ. | Title V | +12 < 1% | -100  < 5% | Total Off Gr | P/F < 130
Lvl 4 KPI | Good | 4 | 1.55 |  |  | 0
 | House Keeping | Losses  < 5 Tons | Moist  < 1.8% |  |  | Lost Time <1 hr
[NAME]
 | NA high-Cut total of 0.6 ton
 | [NAME] and redistributed load on dedusting screens
 | Production-working rates up in control
 | Off grade - dumping system
P1,P2's | 255924167-S/A Day Bin level indication and bindicators need to be checked
[NAME]
 | Still having problems with Silics Sand transfer tripping on high tank pressure.
 | [NAME] still nor working on Pi
Biofos | 1
Coarse | 1
Dynafos | 1
Nexfos
Spreadsheet: 165fbd04-378a-44f4-a48d-7822080839d0
Sheet: EPR 1X PQY

First Quarter Ended December 31, 2012
 | Product Sales Revenue | Cost of  Interactive | Operating Expenses | Operating Income | Net Income (a) | Diluted EPS
GAAP measures | 234.8 | 22.1 | 191.1 | 118.4000000000001 | 65.30000000000008 | 0.24
% of revenue |  |  | 0.3603620592117669 | 0.2232698472562702
Acquisition-related charges: (b)
Contingent retention & earn-out | 0 | 0 | -17.5 | 17.5 | 11.5 | 0.04
Amortization of intangibles | 0 | -2.3 | -4.4 | 6.7 | 4.4 | 0.02
Royalty settlement | -5 | 0 | 0 | -5 | -5 | -0.02
Total non-GAAP adjustments | -5 | -2.3 | -21.9 | 19.2 | 10.9 | 0.03999999999999999
Adjusted measures | 229.8 | 19.8 | 169.2 | 137.6000000000001 | 76.20000000000007 | 0.28
% of revenue |  |  | 0.3190646803696021 | 0.2594757684329626
(a) Adjustments tax effected at 34%, except no tax effect on royalty settlement
(b) Primarily related to DoubleDown
Spreadsheet: 772420d1647265128-self-marking-quiz-score-form
Sheet: Sheet1

A | B | C | D | E | F | G | H |  |  |  |  |  | M |  |  |  | M |  |  |  | M |  |  | M
AMANDLA | DLN | AAA | M |  | s | 25213 | AAADLMN | 1 |  | 1 | AAADLMN | MANDALA | 1 | 2 | AAADLMN | MANLADA | 0 | 3 | AACDELN |  |  | 4 | AACDELN
MANDALA | DLN | AAA | M |  | s | 25214 | AAADLMN | 2 |  | 5 | AACDELN |  |  | 6 | AADELMN |  |  | 7 | AADELNR |  |  | 8 | AADELNT
CANALED | DLN | AAE | C |  |  | 8049 | AACDELN | 3 |  | 9 | AADELNW |  |  | 10 | AADELNX
CANDELA | DLN | AAE | C |  | s | 8050 | AACDELN | 4
DECANAL | DLN | AAE | C |  |  | 8051 | AACDELN | 5
LEADMAN | DLN | AAE | M |  |  | 8066 | AADELMN | 6
ADRENAL | DLN | AAE | R |  | s | 1666 | AADELNR | 7
LANATED | DLN | AAE | T |  |  | 1667 | AADELNT | 8
DANELAW | DLN | AAE | W |  | s | 8068 | AADELNW | 9
ADNEXAL | DLN | AAE | X |  |  | 12776 | AADELNX | 10
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B10

Local 10
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-31 00:00:00
[NAME]: | 8
Réservé:
Prix: | 100
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 538054d1505392793-for-identical-cells-in-column-a-can-i-use-conditional-formatting-to-find-dups-in-col-b-duplicate_products_per_customer-pcb-
Sheet: Sheet1

a | p1
b | p2
c | p3
d | p4
e | p5
f | p6
a | p1
b | p8
c | p9
d | p10
e | p11
f | p12
a | p13
b | p8
c | p15
d | p16
e | p17
f | p18
Spreadsheet: geir_solberg__11297__2-2act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2 |  |  |  |  |  |  |  | 1.96
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 373615d1422494999-take-corresponding-name-and-points-and-make-a-summary-of-points-sujra-time-sheets-places
Sheet: Super Peewees

 |  | Time Sheet | Event |  |  |  |  | Event |  |  |  |  | Event |  |  | All Around Points
# | # | Contestant | [NAME] | Place | Points | # | Contestant | Barrels | Rank | Points | # | Contestant | Goat Tail Pull | Place | Points | Total:
1 | 1 |  |  |  |  | 1 |  |  |  |  | 1
2 | 2 |  |  |  |  | 2 |  |  |  |  | 2
3 | 3 |  |  |  |  | 3 |  |  |  |  | 3
4 | 4 |  |  |  |  | 4 |  |  |  |  | 4
5 | 5 |  |  |  |  | 5 |  |  |  |  | 5
6 | 6 |  |  |  |  | 6 |  |  |  |  | 6
7 | 7 |  |  |  |  | 7 |  |  |  |  | 7
8 | 8 |  |  |  |  | 8 |  |  |  |  | 8
9 | 9 |  |  |  |  | 9 |  |  |  |  | 9
10 | 10 |  |  |  |  | 10 |  |  |  |  | 10
11 | 11 |  |  |  |  | 11 |  |  |  |  | 11
12 | 12 |  |  |  |  | 12 |  |  |  |  | 12
13 | 13 |  |  |  |  | 13 |  |  |  |  | 13
14 | 14 |  |  |  |  | 14 |  |  |  |  | 14
15 | 15 |  |  |  |  | 15 |  |  |  |  | 15
16 | 16 |  |  |  |  | 16 |  |  |  |  | 16
17 | 17 |  |  |  |  | 17 |  |  |  |  | 17
18 | 18 |  |  |  |  | 18 |  |  |  |  | 18
19 | 19 |  |  |  |  | 19 |  |  |  |  | 19
20 | 20 |  |  |  |  | 20 |  |  |  |  | 20
21 | 21 |  |  |  |  | 21 |  |  |  |  | 21
22 | 22 |  |  |  |  | 22 |  |  |  |  | 22
23 | 23 |  |  |  |  | 23 |  |  |  |  | 23
24 | 24 |  |  |  |  | 24 |  |  |  |  | 24
25 | 25 |  |  |  |  | 25 |  |  |  |  | 25
26 | 26 |  |  |  |  | 26 |  |  |  |  | 26
27 | 27 |  |  |  |  | 27 |  |  |  |  | 27
28 | 28 |  |  |  |  | 28 |  |  |  |  | 28
29 | 29 |  |  |  |  | 29 |  |  |  |  | 29
30 | 30 |  |  |  |  | 30 |  |  |  |  | 30
Spreadsheet: 494842d1482799764-comparing-two-cells-to-provide-lowest-number-but-samplegolf
Sheet: Data

Date | 2016-01-04 00:00:00 | 2016-01-17 00:00:00 | 2016-01-26 00:00:00 | 2016-02-06 00:00:00 | 2016-02-07 00:00:00 | 2016-02-29 00:00:00 | 2016-03-01 00:00:00 | 2016-03-06 00:00:00 | 2016-03-10 00:00:00 | 2016-03-20 00:00:00 | 2016-03-24 00:00:00 | 2016-03-25 00:00:00 | 2016-03-28 00:00:00 | 2016-04-01 00:00:00 | 2016-04-05 00:00:00 | 2016-04-09 00:00:00 | 2016-04-12 00:00:00 | 2016-04-15 00:00:00 | 2016-04-17 00:00:00 | 2016-04-22 00:00:00 | 2016-04-24 00:00:00 | 2016-05-15 00:00:00 | 2016-08-05 00:00:00 | 2016-08-10 00:00:00 | 2016-09-12 00:00:00 | 2016-09-24 00:00:00 | 2016-09-30 00:00:00 | 2016-11-06 00:00:00 | 2016-12-10 00:00:00 | 2016-12-22 00:00:00
Course | SG | SG | I | KD | SG | SG | SG | SG | SG | SG | SG | SG | KD | SG | SG | KD | SG | I | SG | SG | KD | SG | SG | SG | SG | SG | SG | SG | SG | SG
Macca | 28 | 21 | 30 | 30 | 30 | 14 | 28 | 20 | 21 | 15 | 17 | 28 | 18 | 11 | 16 | 22 | 15 | 29 | 26 | 17 | 26 | 18 | 22 | 22 | 19 | 18 | 15 | 17 | 22 | 24
Lav |  |  |  | 30 |  |  |  |  |  | 30 | 17 |  |  | 24 |  |  |  | 27 | 19 | 25 | 23 |  |  |  | 17 |  |  | 23 |  | 18
Skip | 36 |  | 40 | 31 | 26 |  | 27 |  | 40 | 27 | 22 | 25 | 29 | 26 | 25 |  |  |  | 21 |  | 22 | 27 | 34 | 29 | 24 | 15 | 23 | 20 | 15 | 27
Skins | 39 |  | 39 |  |  |  |  |  | 41 | 41 | 44 |  | 26 | 42 | 30 | 37 | 32 | 34 | 27 | 25 |  |  |  |  |  |  |  |  |  | 48
Marto |  |  | 33 | 27 |  |  |  |  |  | 38 |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  | 33 | 42 |  |  | 46
Spreadsheet: 7fc61f38-5d0e-4b9d-a058-2596b420be95
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
EMAY | Test | EMAY | Euroglyphus maynei, IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EMAY | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EMAY | Result | EMAY | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6114-3 | Euroglyphus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 62964d1263942860-lookup-data-from-dissimilar-formats-sample
Sheet: Sheet1

 | Target Data
 | Description | Value
 | Revenue
 | 10000 Sales Product A | 1000
 | 10010 Sales Product B | 2000
 | Total Product Sales | 3000
 | Sundry Income
 | 20010 - Rentals | 500
 | 20020 Other | 250
 | Total other | 750
 | Total Revenue | 3750
 | All Codes are always 5 digits
 | Extracted Data
 | Is it possible to extract the values from the Target to produce the result below?
 |  | Required Output
 | 10000 | 1000
 | 10010 | 2000
 | 10020
 | 20010 | 500
 | 20020 | 250
 | 20030
Spreadsheet: 749568d1632903972-cf-if-cell-contains-specific-text-t3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Owner | Level 1 - Type | Level 2 - Pipeline | Level 3 - Category | Level 4 - Description | Level 5 - Reason | Internal Note 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer | PRODUCT | DRINKS | DRINK QUALITY | 329 NON STANDARD TASTE |  | Sometimes risk
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drinks Quality | PRODUCT | DRINKS | DRINK QUALITY | 329 NON STANDARD TASTE |  | No risk
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer | PRODUCT | DRINKS | CUPS | 286 TELESCOPED |  | Nothing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer | PRODUCT | DRINKS | CUPS | 286 TELESCOPED |  | Risky
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drinks Quality | PRODUCT | DRINKS | CUPS | 286 TELESCOPED |  | Always
Spreadsheet: 587595d1535104933-lowest-average-of-student-and-return-student-name-find-lowest-student-2-
Sheet: Sheet1

ID | Subject | score |  | ID | Name | Age
1000 | Math | 80 |  | 1000 | [NAME] | 14
1001 | English | 45 |  | 1001 | [NAME] | 15
1002 | Math | 60 |  | 1002 | [NAME] | 16
1002 | English | 87 |  |  |  | This solution needs to be a formula that must be within one cell and needs to be dynamic(e.g changes).
1001 | English | 50
1000 | Chem | 54 |  |  |  | Q.
1001 | Math | 71 |  |  |  | Return the 2nd letter for the name of a student with the lowest average score?
1002 | Chem | 83
 |  |  |  |  |  | answer in C18, value should be o as [NAME] has the lowest average
 | Answer
Spreadsheet: 480291d1473852695-text-to-column-conversion-barcode-scanner-1
Sheet: Sheet1

BARCODE | CUSTOMER | PROJECT | DRAWING NO | [NAME] | ROUTECARD NUMBER | ID | QTY | REMARKS | SAL CODE | DATE | TIME | OPR NO
AVIO/160371/2313M28P12/BUSH/641681b/P1254-P1258/05/ | AVIO | 160371 | 2313M28P12 | [NAME] | 641681b | P1254-P1258 | 5
AVIO/160371/2313M28P12/BUSH/641681b/P1254-P1258/05/ | AVIO | 160371 | 2313M28P12 | [NAME] | 641681b | P1254-P1258 | 5
Spreadsheet: 124025d1318003280-countifs-
Sheet: Σεπτέμβριος

 | ΣΕΠΤΕΜΒΡΙΟΣ
 |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ΡΕΠΟ | ΡΕΠΟ ΣΥΝ | ΡΕΠΟ ΜΕΙΟΝ | ΣΥΝΟΛΟ ΡΕΠΟ
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 |  | Κ/Α |  | ΜΗΧ/ΑΔ |  | ΦΟΙΤ.ΑΔ. |  | ΓΟΝ.ΑΔ. |  | ΑΔ.ΜΗΤ.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 86212d1286236268-best-price-spreadsheet-best-price-spreadsheet-packing-cost-evaluation-1-
Sheet: Lightning

 | Lightning Packaging
 |  | Price
Lightning Packaging | Europa 1/1 | 12.6
Lightning Packaging | Europa 1/2 | 11
Lightning Packaging | 50mm Clear Tape | 0.48
Lightning Packaging | 25mm Clear tape | 0.43
Lightning Packaging | Fragile Tape | 0.82
Lightning Packaging | Pallet Wrap
Lightning Packaging | Bubble Wrap | 17.4
Lightning Packaging | Grip top bags 3.5"x4.5" (per 1000) | 8.6
Lightning Packaging | Grip top bags 4.5"x4.5" (per 1000) | 9.65
Lightning Packaging | Grip top bags 3x7.5" (per 1000) | 10.4
Lightning Packaging | Open ended poly bags 10"x12" (per 1000) | 14.5
Lightning Packaging | Open ended poly bags 12"x15" (per 1000) | 16.8
Lightning Packaging | Open ended poly bags 15"x20" (per 1000) | 21
Lightning Packaging | Open ended poly bags 18"x24" (per 1000) | 26
Lightning Packaging | Open ended poly bags 24"x36" (per 1000) | 92
Spreadsheet: 789865d1659418644-displaying-wrong-result-while-using-let-function-let-function
Sheet: Result

 | [NAME] used
Lookup range | < data to pulled> |  |  |  | Expected Result |  | Lookup range
856964 |  | New Yrk |  |  | RAM | Denmark | 856964 |  |  | Denmark
652364 | AB | Austria |  |  | [NAME] | UK | 652364 |  | [NAME] | UK
8965412 | DK | Canada |  |  | AB | Austria | 8965412 |  | AB | Austria
364564 | RAM | Denmark |  |  | DK | Switzerland | 364564 |  | DK | Switzerland
 |  |  |  |  |  |  |  |  |  | Denmark
 |  |  |  |  |  |  |  |  | [NAME] | UK
 |  |  |  |  |  |  |  |  | AB | Austria
 |  |  |  |  |  |  |  |  | DK | Switzerland
Spreadsheet: 219bb193-7118-459e-9ca4-a494a82a3510
Sheet: Spell Data

Spell | Rank | Level obtained | Effect
Faerie Fire Feral | 1 | 30 | 175 | Armor reduction
Faerie Fire Feral | 2 | 40 | 285 | Armor reduction
Faerie Fire Feral | 3 | 50 | 395 | Armor reduction
Faerie Fire Feral | 4 | 60 | 505 | Armor reduction
Faerie Fire Feral | 5 | 70 | 610 | Armor reduction
Mangle | 1 | 50 | 158 | Extra damage
Mangle | 2 | 58 | 205 | Extra damage
Mangle | 3 | 68 | 264 | Extra damage
[NAME] | 1 | 20 | 197 | Base dot
[NAME] | 2 | 28 | 335 | Base dot
[NAME] | 3 | 36 | 438 | Base dot
[NAME] | 4 | 44 | 678 | Base dot
[NAME] | 5 | 52 | 961 | Base dot
[NAME] | 6 | 60 | 1347 | Base dot
[NAME] | 7 | 67 | 1562 | Base dot
Shred | 1 | 22 | 54 | Extra damage
Shred | 2 | 30 | 72 | Extra damage
Shred | 3 | 38 | 99 | Extra damage
Shred | 4 | 46 | 144 | Extra damage
Shred | 5 | 54 | 180 | Extra damage
Shred | 6 | 61 | 236 | Extra damage
Shred | 7 | 70 | 405 | Extra damage
ZZZ ---end of list. do not remove this line, and ensure spells are in alphabetical order
Spreadsheet: 105639d1302939221-excel-2007-extracting-values-from-specific-row-and-column-with-criteria-book2
Sheet: Sheet2

[NAME] | Punct (m) | FX (kN) | MY (kNm) | MZ (kNm)
1 | x= 0.0 | 7243.41 | 128.22 | 76.16
1 | x= 0.0 | 3596.11 | -133.26 | 63.21 |  |  | For | Bar number: |  | 1
1 | x= 0.0 | 6556.04 | 248.17 | 44.61 |  |  |  | Section: |  | x=0.0
1 | x= 0.0 | 4817.86 | -306.33 | 108.8
1 | x= 0.0 | 5732.85 | 77.51 | 198.53 |  |  | Nmax= |  | Myaf= |  | Mzaf=
1 | x= 0.0 | 5717.27 | 81.92 | -183.5 |  |  | Nmin= |  | Myaf= |  | Mzaf=
1 | x=3.50 | 7186.62 | -208.55 | -174.21 |  |  | Naf= |  | Mymax= |  | Mzaf=
1 | x=3.50 | 3554.04 | -40.02 | -93.06 |  |  | Naf= |  | Mymin= |  | Mzaf=
1 | x=3.50 | 6015.06 | -10.85 | -162.1 |  |  | Naf= |  | Myaf= |  | [NAME]
1 | x=3.50 | 7122.87 | -237.66 | -168.92 |  |  | Naf= |  | Myaf= |  | Mzmin=
1 | x=3.50 | 5660.48 | -160.44 | -16.62
1 | x=3.50 | 5971.98 | -159.85 | -234.92
2 | x= 0.0 | 7457.98 | -1.5 | -149.45
2 | x= 0.0 | 3872.74 | -3.57 | -16.27 |  |  | I have the data in column  A:E. I need a formula or a vba code to sort like above. I give the bar number and the section. From the first find to the last .If i get the values from column C with a vlookup i could get the others.I just couldnt find a solution.
2 | x= 0.0 | 5989.54 | 140.46 | -124.25
2 | x= 0.0 | 5988.74 | -341.22 | -124.32
2 | x= 0.0 | 6099.51 | -2.09 | 38.41
2 | x= 0.0 | 5917.84 | -3.86 | -383.15
2 | x=3.50 | 7401.19 | 2.01 | 233.14
2 | x=3.50 | 3830.67 | 5.16 | 154.74
2 | x=3.50 | 5931.95 | 268.47 | 226.57
2 | x=3.50 | 6491.57 | -164.41 | 236.87
2 | x=3.50 | 6088.05 | 6.57 | 363.92
2 | x=3.50 | 4682.43 | 2.15 | 111.3
Spreadsheet: 154944d1336616080-whole-row-conditional-formatting-on-text-value-copy-of-xl0000315
Sheet: Sheet1

2nd Item Number | Description 1 | Description 2 | Sum of Short Shipped Qty | Sum of Short Shipped $ | Sum of Quantity On Hand | Sum of Quantity Available | Sum of Quantity Held | Lot Status | Comment
22267 | [NAME] ANTISEPTIC |  | 3888 | 8125.919999999999 | #N/A | 48 | #N/A |  | Production WC23.04.2012. ETA 30.04.2012, customer has been notified
21553 | [NAME] T/PASTE | 578893 | 5184 | 6220.8 | #N/A | 6 | #N/A | #N/A | 2 weeks away
100428 | STARLET 125ML POLISH  REMOVER | VITAMIN E | 4224 | 4139.52 | 48 | 0 | 0 | #N/A | Starts Today 7200 units
21268 | FOA SUN 140ML BRONZER | MOUSSE | 636 | 3542.520000000004 | 6 | #N/A | #N/A | #N/A | Made and stock available
100427 | STARLET 125ML POLISH  REMOVER | NON ACETONE | 2544 | 2518.56 | 4128 | #N/A | #N/A | #N/A | Need Reconfirmed Date
22231 | FOA MINERAL LOOSE POWDER | NATURAL HONEY | 237 | 1971.899999999998 | #N/A | 0 | #N/A |  | OOS
21785 | FOA LIPGLOSS DIVINE SHINE | MORNING MIST | 429 | 1927.889999999998 | #N/A | #N/A | #N/A | #N/A | Back in Stock
20037 | BEAUTY ESSENTIALS 125ML | POLISH REMOVER VITAMIN E | 1872 | 1815.84 | 2 | 24 | #N/A | #N/A | Back in Stock
21789 | FOA LIPGLOSS DIVINE SHINE | [NAME] RUSH | 387 | 1733.129999999998 | #N/A | 0 | #N/A | #N/A
21786 | FOA LIPGLOSS DIVINE SHINE | SILK FORTUNE | 243 | 1096.229999999999 | 24 | #N/A | #N/A
20988 | FOA LIQUID  EYELINER | CHARCOAL | 195 | 837.0600000000001 | 3 | 0 | #N/A
21762 | [NAME] QUENCH 30+ | PURE PLUM | 186 | 829.8899999999994 | #N/A | 0 | #N/A | #N/A | Back in Stock
101757 | FOA LIP DEFINER | RUBY RED | 234 | 828.5099999999994 | 7 | #N/A | #N/A |  | Back in Stock
21783 | FOA LIP PLUMP | LAVISH INSTINCT | 165 | 825.33 | 9 | #N/A | #N/A
19873 | FOA NAIL POLISH REMOVER | MOISTURISING | 432 | 648.0000000000002 | #N/A | 0 | #N/A
100930 | FOA MECHANICAL EYELINER PENCIL | BROWN | 120 | 591.3899999999998 | #N/A | #N/A | #N/A
13303 | HOMEBRAND 200G PETROLEUM JELLY | 1995 | 216 | 324 | 3 | 18 | #N/A | E
22237 | FOA MINERAL BLUSH | BERRY PINK | 42 | 260.94 | #N/A | 0 | #N/A
100429 | STARLET 125ML POLISH  REMOVER | OILY | 252 | 249.48 | 18 | 12714 | #N/A
20979 | FOA TINTED MOISTURISER SPF30+ | MEDIUM | 39 | 241.02
19521 | FOA PRESSED POWDER | IVORY | 30 | 180
100429 | STARLET 125ML POLISH  REMOVER | OILY | 180 | 178.2
100930 | FOA MECHANICAL EYELINER PENCIL | BROWN | 30 | 154.77
102392 | CLASSICS LIQUID EYELINER | BLACK | 72 | 148.32
101757 | FOA LIP DEFINER | RUBY RED | 36 | 142.5
20039 | BEAUTY ESSENTIALS 125ML | POLISH REMOVER NNNON ACETONE | 144 | 139.68
22237 | FOA MINERAL BLUSH | BERRY PINK | 15 | 100.65
Spreadsheet: tracy_geaccone__40442__OM EST - OSS - 2001 - 2002 REVISED FORMAT
Sheet: Orig '02 Plan Net

ORIGINAL '02 PLAN NET  O & M COSTS
(including Benefits & Payroll Taxes)
OPERATIONS SUPPORT SERVICES (Included in Finance & Accounting)
( $ In Thousands)
 |  |  |  |  |  |  |  |  |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Gross O&M |  | Net |  | Net
 |  |  |  |  |  |  |  |  |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | % O(U) |  | 2002 |  | 2002
Department |  |  |  |  |  |  |  |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | 2000 Plan |  | Dec |  | Sum
NNG
TW
Citrus
Northern Border Partners
EOTT (Co 1195) **
[NAME]
GCO/HPL
EAMR
ETS
Other *
Total
* For companies outside of ETS
**  Exclude Co. 1195
Spreadsheet: 673650d1587479424-find-minimum-value-and-corresponding-value-from-multiple-tables-index-match-maybe-excel-table-lookup-problem-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Return Corresponding Value of Heading D for the Minimum Value of Heading B
Table 1
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | The above example searches for the minimum value of Heading B from Table 1. It then returns the value from Heading D from the same Column as the minimum value.
Heading B | 47 | 52 | 63 | 51 | 48 | 59 | 62 | 64 | 67 | 54
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 2 |  |  |  |  |  |  |  |  |  |  |  | Step 1
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Search the row's highlighted with red border for the minimum value
Heading B | 46 | 51 | 62 | 50 | 47 | 58 | 61 | 63 | 66 | 53
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Step 2
 |  |  |  |  |  |  |  |  |  |  |  | Use the minimum value from all tables to select the column in that table.
Table 3
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 45 | 50 | 61 | 49 | 46 | 57 | 60 | 62 | 65 | 52
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Step 3
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847 |  | Return the data from a cell that intersects with that column when i specify a row
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 4
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 52 | 57 | 68 | 56 | 53 | 64 | 67 | 69 | 72 | 59
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 5
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 50 | 55 | 66 | 54 | 51 | 62 | 65 | 67 | 70 | 57
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 6
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 47 | 52 | 63 | 51 | 48 | 59 | 38 | 64 | 67 | 54
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15750 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 131899d1323374921-pivot-table-not-suming-properly-book2_jpr73
Sheet: PT

# Item | (Tous)
month | hours | Somme de Pieces
11 | 6 | 18
 | 7 | 219
 | 8 | 478
 | 9 | 564
 | 10 | 987
 | 11 | 497
 | 12 | 670
 | 13 | 776
 | 14 | 1139
 | 15 | 778
 | 16 | 465
 | 17 | 241
 | 18 | 53
Total 11 |  | 6885
Total général |  | 6885
Spreadsheet: 833136d1686807348-if-statement-with-multiple-conditions-result-is-inconsistent-look-up-with-multiple-if-condition-aligw
Sheet: Element

Item | Total Cost
P04538-01 | 908.62
P04538-02 | 856.15
P04538-03 | 908.62
P04538-04 | 908.62
P04538-10 | 854.51
P07694-21A | 842.2
P07694 | 400
P20554-01 | 120
V05301-08R | 710
V05301-08R | 730
V05301-08R | 720
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 101561 | 99387
2 | 104070 | 104668
3 | 102908 | 102434
4 | 84773 | 83676
5 | 70058 | 70461
6 | 93868 | 93801
7 | 91997 | 92787
8 | 92287 | 91788
9 | 92020 | 91755
10 | 92001 | 91755
11 | 106982 | 105491
12 | 71838 | 70381
13 | 72981 | 72469
14 | 92471 | 92484
15 | 95420 | 94718
16 | 96997 | 96172
17 | 98737 | 97875
18 | 70178 | 70454
19 | 74069 | 74603
20 | 113995 | 119852
21 | 116731 | 115830
22 | 87813 | 87532
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 40812.85
2001-09-22 00:00:00
CBS Volume
 |  |  | -36540