tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 127903d1320678024-vlookups-with-multiple-choices-excel-help-sample-data
Sheet: Customers

UK | GMBH | SING
Acryate Research & Development Ltd | 3M Belgium N.V./S.A. | Acrilab S.A.
Advanced Healthcare Limited | 3M ESPE AG | [NAME], [NAME]
Associated Dental Products Ltd | Aacure Adhesives GmbH | Amtrade International Pty Ltd
Bausch & Lomb | Acheson Industries (Europe) Ltd | Antler General Industries (Pvt) Ltd
Bausch & Lomb Inc | ACTEGA Rhenania GmbH | Aquilus Lens International Pte Ltd
Biomer Technology Ltd | ACTIOL GmbH | [NAME]
Cantor & Nissel Ltd | Adley-Certis b.v. | BASF
Carbon Chemicals Group Limited | [NAME] | Bausch and [NAME]
Citifluor Ltd | Agfa-Gevaert N.V. | Bescon
Cognis | Alberdingk Boley GmbH | Chaks Cosmetic Design & Servic
Contamac Limited | Alfa Aesar GmbH & Co KG | Clearlab SG Pte Ltd
Coopervision Manufacturing Ltd | [NAME] | Dong Won Corporation
Cornelius Specialties Limited | Ametech SRL | Dreamcon
CV Manufacturing and Supply UK Ltd | Andreas Jennow A/S | Fotopolymer Pte Ltd
Daysoft Limited | ANNO Chemicals NV | Gelflex Laboratories
DePuy (Ireland) Limited | [NAME] S.A.U. | Globus Global Supply
Esschem Europe Ltd | Arkema France | Grechem Materials Technologies
Fisher Scientific UK Ltd | Arkema France | Henkel (Malaysia) Sdn. Bhd.
Gelflex Laboratories | Atlantic Polymers & Chemicals GmbH | Honour Enterprise Limited
Honour Enterprise Limited | Avery Dennison Materials Europe GmbH | Hoya Corporation Eye Care Solution
Spreadsheet: 888737d1739304092-formula-to-compile-concatenate-these-values-sample-notebook
Sheet: Demands

Name |  |  |  |  |  |  |  | PID [NAME] | Target | Negotiation Notes | NOTES |  | Exposure | PID Product |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Occupation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Affidavit file location
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plumber
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Laborer
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Engineman
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx_ 1.1971-12.1979)-373689.pdf | Paste here
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx_ 01.1971-12.-394320.pdf
 |  |  |  |  |  |  |  |  |  |  |  |  | Hands-On Primary | Steam Traps |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Machinist Mate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 8.1973-8.1976)-378602.pdf
Spreadsheet: 8d6f3c6e-12b7-4581-b92c-43d1a82db81a
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
COMM | Test | COMM | Identification, [NAME] | Identification [NAME] |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87077 |  |  |  |  | Rochester
COMM | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: daren_farmer__6006__EI305reveff061500
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/19/00
Subject:  Revised Availabilities Effective 6/15/00 - 6/16/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-15 00:00:00 | EI 305 | 3800 | 0.1392 |  |  | 3271
1st of month DBQ = 3280/d
Spreadsheet: 125226d1318940730-conditional-formatting-formula-copy-of-help-20conditional-20formatting-1-
Sheet: Til powerpoint

 | Likelihood | Consequense | LXC | Colour
 | 5 | 2 |  |  | WRONG
 | 2 | 5 |  |  | OK
 | 1 | 4 |  |  | WRONG
 | 4 | 1 |  |  | OK
 | 5 | 4 |  |  | OK
 | 2 | 5 |  |  | OK
 | 3 | 3 |  |  | OK
 | 1 | 1 |  |  | OK
 | 3 | 3 |  |  | OK
 | 3 | 3 |  |  | OK
 | 3 | 2 |  |  | OK
 | 4 | 3 |  |  | OK
 | 4 | 3 |  |  | OK
 | 4 | 3 |  |  | OK
 | 3 | 4 |  |  | OK
 | 3 | 4 |  |  | OK
 | 3 | 4 |  |  | OK
 | 3 | 3 |  |  | OK
 | 1 | 4 |  |  | OK
Spreadsheet: 808680d1670586776-calculate-commission-rates-based-on-different-criteria-book60
Sheet: Sheet1

BDC | Target | Actual | Volume | % to target | 2022 | 2023 model |  |  | 2022 | Band 1 | Band 2 | Band 3 | Band 4 | Band 5
DT | 17500 | 88832 | 23 |  |  |  |  |  | % Achieved | 0.75 | 0.99 | 1 | 1.2 | 1.7
SB | 12000 | 36486.95 | 8 |  |  |  |  |  | % Commission | 0.005 | 0.0125 | 0.0235 | 0.0325 | 0.0415
MK | 20000 | 57829.5 | 4
MH | 30000 | 24000 | 4
 |  |  |  |  |  |  |  |  | 2023 | Band 1 | Band 2 | Band 3 | Band 4 | Band 5 | Band 6
 |  |  |  |  |  |  |  |  | % Achieved | 0.75 | 0.99 | 1 | 1.2 | 1.7 | 2
 |  |  |  |  |  |  |  |  | % Commission | 0 | 0.01 | 0.0235 | 0.0345 | 0.0445 | 0.05
 |  |  |  |  |  |  |  |  | Volume |  |  | 20 | 25 | 30 | 35
 |  |  |  |  |  |  |  |  |  |  |  | 100 | 150 | 250 | 500
Spreadsheet: 9d21a424-d0d0-4d78-b60a-0a1fa934ec3f
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
08/19/2011 | Women's Soccer | at Virginia | L, 1-2
08/21/2011 | Women's Soccer | PURDUE | W, 3-0
08/26/2011 | Women's Soccer | at Penn State (Penn State Invitational) | L, 0-5
08/28/2011 | Women's Soccer | vs. [NAME] (Penn State Invitational) | W, 3-0
09/01/2011 | Women's Soccer | OHIO STATE | L, 0-2
09/05/2011 | Women's Soccer | [NAME] | W, 3-0
09/11/2011 | Women's Soccer | HIGH POINT | W, 1-0
09/15/2011 | Women's Soccer | at USF | W, 2-1 (2OT)
09/18/2011 | Women's Soccer | MARQUETTE | W, 3-1
09/23/2011 | Women's Soccer | SETON HALL | W, 4-0
09/25/2011 | Women's Soccer | RUTGERS | W, 1-0 (OT)
09/30/2011 | Women's Soccer | at Georgetown | W, 3-1
10/02/2011 | Women's Soccer | at Villanova | L, 1-4
10/07/2011 | Women's Soccer | ST. [NAME]'S | W, 3-0
10/09/2011 | Women's Soccer | SYRACUSE | W, 5-1
10/14/2011 | Women's Soccer | at Providence | W, 1-0
10/16/2011 | Women's Soccer | at Connecticut | W, 2-1
10/21/2011 | Women's Soccer | at Pitt | W, 1-0
10/30/2011 | Women's Soccer | SETON HALL (Big East Quarterfinals) | W, 5-0
11/04/2011 | Women's Soccer | GEORGETOWN (BIG EAST Semifinal) | W, 5-1
11/06/2011 | Women's Soccer | [NAME] (BIG EAST Final) | W, 2-0
11/12/2011 | Women's Soccer | VIRGINIA TECH (NCAA) | L, 0-1
Spreadsheet: 86190d1286220274-text-into-a-cell-2010-09-28-vendas-de-animais-janeiro-2010
Sheet: Tipos produto

REF. | DESCRIÇÃO / APRESENTAÇÃO |  |  | TIPO
MP ACB 2.5 | Premix engorda acabamento ACB 2.5 |  |  | MATÉRIAS PRIMAS
MP CCC | Carbonato de Cálcio |  |  | MATÉRIAS PRIMAS
MP CLZ | Colza |  |  | MATÉRIAS PRIMAS
MP CR 2.5 | Premix engorda iniciação CR 2.5 |  |  | MATÉRIAS PRIMAS
MP CVD | Cevada |  |  | MATÉRIAS PRIMAS
MP GSS | [NAME] |  |  | MATÉRIAS PRIMAS
MP [NAME] | Milho |  |  | MATÉRIAS PRIMAS
MP PST50 | Premix pré-starter PST50 |  |  | MATÉRIAS PRIMAS
MP R 2.5 | Premix reprodutores R 2.5 |  |  | MATÉRIAS PRIMAS
MP SJ | Soja |  |  | MATÉRIAS PRIMAS
MP ST10 | Premix starter ST 10 |  |  | MATÉRIAS PRIMAS
MP STR | Sêmea de Trigo |  |  | MATÉRIAS PRIMAS
MP TRG | Trigo |  |  | MATÉRIAS PRIMAS
NC | Nota [NAME] |  |  | NOTA CRÉDITO
PABT | Porcos p/ abate |  |  | VENDA ANIMAIS
RABT | Reprodutoras p/ abate |  |  | VENDA ANIMAIS
REABT | Reprodutores p/ abate |  |  | VENDA ANIMAIS
VQA | [NAME] agrícolas |  |  | VENDA EQUIPAMENTOS AGRíCOLAS
Spreadsheet: 718818d1613374167-how-to-copy-values-from-multiple-cells-to-another-multiple-cells-based-on-value-from-book2-4-ans
Sheet: Sheet1

CODE: | FRUIT: | QUANTITY | INSERT CODE: | copied data 1 | copied data 2
a1 | apple | 2 | a1
a2 | lemon | 5
a3 | orange | 3
Spreadsheet: 792011d1660692551-move-year-to-the-front-rename-carnames-hd-all-excel-versions
Sheet: Sheet1

Old name | New name | Years
[NAME] NKK 2002 V |  | 1900
FVDKDF 363 MODEL 2003  DNNFRV
NNJ RKK 7777 KR 1907 MKMD 1 FKFDM
HFKFKF 2000 VHIDID 1999 [NAME]
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
[NAME] |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Conoco |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
NGPL |  |  |  | Volumetric | [NAME]
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | ending 5/31/01 bal of $295,327 invoiced
Receivable imbalances
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Panhandle Eastern |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 866900d1713809127-summing-up-supplier-amounts-from-the-same-column-sample-sheet
Sheet: Sheet1

ID | Client Name | Client Type | DOB | Province | End Date | Total # of orders | N/A | Supplier
1 | Person 1 | N/A | N/A | N/A | 2024-02-23 00:00:00 | 5 | N/A | Supplier A 5
2 | Person 2 | N/A | N/A | N/A | 2024-02-28 00:00:00 | 3 | N/A | Supplier B 3
3 | Person 3 | N/A | N/A | N/A | 2024-04-13 00:00:00 | 6 | N/A | Supplier B 6
4 | Person 4 | N/A | N/A | N/A | 2024-05-01 00:00:00 | 2 | N/A | Supplier B 2
5 | Person 5 | N/A | N/A | N/A | 2024-05-01 00:00:00 | 5 | N/A | Supplier C 2.5, Supplier A 2.5
6 | Person 6 | N/A | N/A | N/A | 2024-05-02 00:00:00 | 3 | N/A | Supplier D 1, Supplier E 1, Supplier F 1
7 | Person 7 | N/A | N/A | N/A | 2024-05-03 00:00:00 | 3 | N/A | Supplier E 3
8 | Person 8 | N/A | N/A | N/A | 2024-05-15 00:00:00 | 2 | N/A | Supplier F 2
9 | Person 9 | N/A | N/A | N/A | 2024-05-16 00:00:00 | 3 | N/A | Supplier G 3
10 | Person 10 | N/A | N/A | N/A | 2024-05-16 00:00:00 | 2 | N/A | Supplier B 2
Spreadsheet: 787910d1658150532-dynamically-converting-2d-matrix-data-to-a-sorted-list-without-duplicates-and-spaces-matrix-to-sorted-list
Sheet: Tabelle1

 | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10
Owner 1 | kiwi | raspberry | star fruit
Owner 2 | apple | banana
Owner 3 | banana | kiwi | star fruit | cucumber
Owner 4 | raspberry | pear | apple | durian | blueberry | apple | banana | star fruit | cucumber
Owner 5 | raspberry | date | pear
Owner 6 | banana | star fruit
Owner 7 | pear | cucumber
Owner 8 | durian | raspberry | star fruit | orange | date
Owner 9 | raspberry
Owner 10 | pear | apple | banana | kiwi | raspberry | orange | date
Owner 11 | star fruit
Owner 12 | date
Owner 13 | cucumber
Owner 14 | banana | orange
Owner 15 | orange
Owner 16 | kiwi | star fruit | orange
Owner 17 | apple | banana | star fruit | cucumber
Owner 18 | date
Owner 19 | orange | cucumber
Owner 20 | kiwi | orange | pear
 | Sorted List
 | apple
 | banana
 | blueberry
 | cucumber
 | date
 | durian
 | kiwi
 | orange
 | pear
 | raspberry
 | star fruit
Spreadsheet: 487608d1478164714-reading-age-problem-when-showing-some-minus-ages-test-data-2
Sheet: NGRT Digital Results Yr 2 Sept

Age at test  in Months | Age at Test in YY:MM | Reading Age | Reading Age | Reading Age Difference
79 |  | 06:08:00
81 |  | 07:01:00
75 |  | 06:04:00
80 |  | 06:07:00
83 |  | 06:10:00
73 |  | 05:10:00
80 |  | 06:04:00
78 |  | 06:01:00
77 |  | 05:10:00
81 |  | 06:02:00
81 |  | 06:00:00
75 |  | 05:05:00
84 |  | 05:09:00
82 |  | 05:05:00
80 |  | 05:02:00
77 |  | 05:00:00
77 |  | 05:00:00
79 |  | 05:00:00
77 |  | 05:00:00
72 |  | 05:00:00
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: DataSheet

 | R1 Color | R1 Due Days | R2 Color | R2 Due Days | R3 Color | R3 Due Days | R4 Color | R4 Due Days | R5 Color | R5 Due Days | R6 Color | R6 Due Days | R7 Color | R7 Due Days | R8 Color | R8 Due Days | R9  Color | R9 Due Days | R10 Color | R10 Due Days | R11 Color | R11 Due Days | R12 Color | R12 Due Days | R13 Color | R13 Due Days | R14 Color | R14 Due Days | R15 Color | R15 Due Days | R16 Color | R16 Due Days | R17 Color | R17 Due Days
Spreadsheet: 165245d1341123661-change-value-automatically-with-drop-down-list-change-values-with-drop-down-list_rev1
Sheet: Sheet1

Change Value |  |  |  |  |  | Cm | Inch | Cm |  | Use any of these [NAME] below
Item | Unit in inch |  |  |  |  |  |  | For [NAME] |  | Index/Match |  | Vlookup |  | Offset
Length | 73 |  |  |  |  | 50.8 | 20 | 50.8 |  | 73 |  | 73 |  | 73
 |  |  |  |  |  | 53.34 | 21 | 53.34 |  | 185.42 |  | 185.42 |  | 185.42
 |  |  |  |  |  | 55.88 | 22 | 55.88
 |  |  |  |  |  | 58.42 | 23 | 58.42 |  |  |  | Column i
 |  |  |  |  |  | 60.96 | 24 | 60.96 |  |  |  | needed for
 |  |  |  |  |  | 63.5 | 25 | 63.5 |  |  |  | Vlookup
Change Value |  |  |  |  |  | 66.04 | 26 | 66.04
Item | Unit in Cm |  |  |  |  | 68.58 | 27 | 68.58
Length | 185.42 |  |  |  |  | 71.12 | 28 | 71.12
 |  |  |  |  |  | 73.66 | 29 | 73.66 |  | You may hide these Colomns
 |  |  |  |  |  | 76.2 | 30 | 76.2
 |  |  |  |  |  | 78.74 | 31 | 78.74
 |  |  |  |  |  | 81.28 | 32 | 81.28
1 inch = 2.54 Cm |  |  |  |  |  | 83.82 | 33 | 83.82
 |  |  |  |  |  | 86.36 | 34 | 86.36
 |  |  |  |  |  | 88.9 | 35 | 88.9
 |  |  |  |  |  | 91.44 | 36 | 91.44
 |  |  |  |  |  | 93.98 | 37 | 93.98
 |  |  |  |  |  | 96.52 | 38 | 96.52
 |  |  |  |  |  | 99.06 | 39 | 99.06
 |  |  |  |  |  | 101.6 | 40 | 101.6
 |  |  |  |  |  | 104.14 | 41 | 104.14
 |  |  |  |  |  | 106.68 | 42 | 106.68
 |  |  |  |  |  | 109.22 | 43 | 109.22
 |  |  |  |  |  | 111.76 | 44 | 111.76
 |  |  |  |  |  | 114.3 | 45 | 114.3
 |  |  |  |  |  | 116.84 | 46 | 116.84
 |  |  |  |  |  | 119.38 | 47 | 119.38
 |  |  |  |  |  | 121.92 | 48 | 121.92
 |  |  |  |  |  | 124.46 | 49 | 124.46
 |  |  |  |  |  | 127 | 50 | 127
 |  |  |  |  |  | 129.54 | 51 | 129.54
 |  |  |  |  |  | 132.08 | 52 | 132.08
 |  |  |  |  |  | 134.62 | 53 | 134.62
 |  |  |  |  |  | 137.16 | 54 | 137.16
 |  |  |  |  |  | 139.7 | 55 | 139.7
 |  |  |  |  |  | 142.24 | 56 | 142.24
 |  |  |  |  |  | 144.78 | 57 | 144.78
 |  |  |  |  |  | 147.32 | 58 | 147.32
 |  |  |  |  |  | 149.86 | 59 | 149.86
 |  |  |  |  |  | 152.4 | 60 | 152.4
 |  |  |  |  |  | 154.94 | 61 | 154.94
 |  |  |  |  |  | 157.48 | 62 | 157.48
 |  |  |  |  |  | 160.02 | 63 | 160.02
 |  |  |  |  |  | 162.56 | 64 | 162.56
 |  |  |  |  |  | 165.1 | 65 | 165.1
 |  |  |  |  |  | 167.64 | 66 | 167.64
 |  |  |  |  |  | 170.18 | 67 | 170.18
 |  |  |  |  |  | 172.72 | 68 | 172.72
 |  |  |  |  |  | 175.26 | 69 | 175.26
 |  |  |  |  |  | 177.8 | 70 | 177.8
 |  |  |  |  |  | 180.34 | 71 | 180.34
 |  |  |  |  |  | 182.88 | 72 | 182.88
 |  |  |  |  |  | 185.42 | 73 | 185.42
 |  |  |  |  |  | 187.96 | 74 | 187.96
 |  |  |  |  |  | 190.5 | 75 | 190.5
 |  |  |  |  |  | 193.04 | 76 | 193.04
 |  |  |  |  |  | 195.58 | 77 | 195.58
 |  |  |  |  |  | 198.12 | 78 | 198.12
 |  |  |  |  |  | 200.66 | 79 | 200.66
 |  |  |  |  |  | 203.2 | 80 | 203.2
Spreadsheet: 65014d1265795918-count_question-717466_excelhelp18_v2
Sheet: Sheet1

Site ID | Volt 1 | Volt 2 | Volt 3 | Volt 4 | Volt 5 | 24 | 48 | All |  | Criteria's | Output I need |  | Criteria
1ID | 24 |  | 24 |  |  | 2 | 0 | 2 |  | Sites Count With > 1   24V SMPS | 5 |  | 2
1ID | 48 |  | 24 | 48 |  | 1 | 2 | 3 |  | Sites Count With > 2   24V SMPS | 2 |  | 3
1ID | 24 | 48 |  | 48 |  | 1 | 2 | 3 |  | Sites Count With > 3   24V SMPS | 1 |  | 4
1ID | 48 |  |  | 48 | 48 | 0 | 3 | 3 |  | Sites Count With > 4   24V SMPS | 0 |  | 5
1ID | 24 |  | 24 | 24 | 48 | 3 | 1 | 4
1ID | 48 |  | 24 |  | 48 | 1 | 2 | 3 |  | Sites Count With > 1   48V [NAME] | 6 |  | 2
1ID | 24 | 48 |  |  |  | 1 | 1 | 2 |  | Sites Count With > 2   48V [NAME] | 1 |  | 3
2ID | 24 | 48 |  |  | 24 | 2 | 1 | 3 |  | Sites Count With > 3   48V [NAME] | 0 |  | 4
1ID | 48 | 48 |  |  | 24 | 1 | 2 | 3 |  | Sites Count With > 4   48V [NAME] | 0 |  | 5
1ID | 48 |  |  | 24 |  | 1 | 1 | 2
1ID | 24 |  |  | 24 |  | 2 | 0 | 2 |  | Sites with > 1 SMPS | 13 |  | 2
1ID | 48 | 24 |  | 48 |  | 1 | 2 | 3 |  | Sites with > 2 SMPS | 9 |  | 3
1ID | 24 | 24 | 24 | 48 | 24 | 4 | 1 | 5 |  | Sites with > 3 SMPS | 2 |  | 4
1ID | 24 |  |  |  |  | 1 | 0 | 1 |  | Sites with > 4 SMPS | 1 |  | 5
 |  |  |  |  |  |  |  |  |  | Sites With [NAME] | 14
 |  |  |  |  |  |  |  |  |  | Sites with No [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Total SMPS | 39
Spreadsheet: 692188d1598160774-extracting-data-from-a-column-into-another-but-sorted-and-with-2-related-cells-next-to-it-book4-reply
Sheet: Sheet1

MY Index | Serial Number | Supplier | Sales | Revenue
23 | B52XN2 | AccuBuddy | 21 | 17274.05
11 | B07379JP | The Inspired Home | 170 | 3568.3
14 | 6HQF8PJ | Arswintech | 222 | 2323.45
13 | B07LKK8 | SKCTech | 429 | 7288.71
1 | fgdgfd | gr | 11 | 543543
54 | grt | btrbrt | 55 | 65454
Spreadsheet: 718726d1613313484-extract-values-into-column-a-to-column-k-of-sheet-named-here_1-ignoring-blanks-extract-values-ignoring-blanks
Sheet: Here_1

Name_1 | Name_2 | Middle | Area | Area Time | Local Time | GPS | Letter | District Name | Distance | Status
Spreadsheet: daren_farmer__6666__Consolidated_2000
Sheet: ZoneBreakout

1999-06-25 09:55:51.350000
July Nom
 |  |  |  |  | Zone Specific Adjustments |  |  | System Adjustments |  |  | Total
TRADE ZONE | GRANDPA | PIPELINE | Grand Total |  | GRANDPA | PIPELINE |  | GRANDPA | PIPELINE |  | GRANDPA | PIPELINE
001Gulf Coast | 858 | 0
001Gulf Energy | 4172 | 1270
01 | 19275 | 2115
02 | 2222 | 12823
03 | 2707 | 983
04 | 123 | 0
05 | 29802 | 159498
06 | 2984 | 20755
07 | 1210 | 4500
08 | 74234 | 9719 |  |  |  | 0
09 | 4066 | 2128
10 | 9250 | 9719 |  |  | -1000
11 | 1314 | 0
12 | 1408 | 5727 |  |  |  | -1000
13 | 0 | 995 |  |  |  |  |  | 0
14 | 6558 | 16616
15 | 2105 | 0
16 | 6007 | 8000
17 | 1378 | 5386
18 | 15455 | 4367 |  |  | -1280
19 | 12601 | 3501 |  |  | -1882.15942956157
20 | 2107 | 200
21 | 30244 | 330 |  |  | -8117.84057043843
22 | 0 | 0
23 | 10608 | 12760
OFF | 950 | 0
Grand Total
HPLR 2% TESORO (Zn1) |  | -171 | -171
HPLR 2.5% TESORO (Zn18) |  | -25 | -25
HPLR 4% WELLHAUSEN (Zn18) |  | -46 | -46
SHRINK KING RANCH (Zn19 & 21) | -10000 | -1500
[NAME] (Zn18) |  |  | -2417
PETRO PRO-TX @ 6896 (Zn1) |  | -705 | -705
BLACKSTONE (Zn8) |  | 0 | 0
LAMAY GAS LIFT (Zn12) |  | -1000 | -1000
ENTEX (Zn10) |  |  | -1000
UA4 |  |  | -10000
COMPRESSOR FUEL |  |  | -4333
PIPELINE DRIP |  |  | -17
LOSS DUE TO CONSTRUCTION |  |  | -396
BANK IMBALANCE | 0 | 0 | 0
LINEPACK |  |  | -176
SUBTOTAL USES
Uses Strictly Proportionate
Uses Allocated by Vintage
Spreadsheet: 133254d1324308692-offset-formula-error-2012-service-prices
Sheet: Service Costs

Model | Engine Size/Type | Variant
308 | 1.4 Petrol | Annual Mileage < 14000 (Inc Interim Servs)
Year of Service | Cost of Service | Type Of Service
Year 1 Service
Year 2 Service
Year 3 Service
Year 4 Service
Year 5 Service
Year 6 Service
Year 7 Service
Year 8 Service
Year 9 Service
Year 10 Service
Year 11 Service
Year 12 Service
Spreadsheet: richard_ring__31655__Sample Invoice (10-15-01)
Sheet: Installed Capacity Calcs

 | Enron Energy Services Operations, Inc.
 | BGE Index Product Installed Capacity Costs - Example Calculations
Maryland Customer
Attn:
 |  | From: | To:
Baltimore, MD |  | 2003-01-01 00:00:00 | 2003-01-31 00:00:00
SITE | Description
 | (A) | (B) | (C) | (D) | (E) | (F) | (G)
 |  |  |  | PJM Daily Deficiency Rate | Daily Capacity Obligation | Capacity Cost | Capacity Cost
Site 1 | Hour | kWh | Day
 |  |  |  | ($/MW Day) | (MW) | ($/Day) | ($/KWh)
 | 1 |  | 1 | 177