tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 687887d1595474033-multiple-lists-dependent-on-one-independent-list-multiple-dependent-lists
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Model | VER_Physical | VER_Power | VER_CRI_CCT | VER_Distribution | VER_Baffle | VER_Driver
 |  |  |  |  |  |  |  |  |  | VER | 125 | 15 | 830 |  | S | D
 | Model | Physical | Power (W) | CRI/CCT | Distribution | Baffle | Driver |  |  | CUR | 150 | 20 | 840 | 25 | M
 | VER | 125 | 15 | 830 |  | S |  |  |  | OND |  | 27 | COI | 36 | W
 |  | 150 | 20 | 840 | 25 | M | D |  |  |  |  | 37 |  |  | B
 |  |  | 27 | COI | 36 | W |  |  |  |  |  |  |  |  | C
 |  |  | 37 |  |  | B
 |  |  |  |  |  | C |  |  |  |  | CUR_Physical | CUR_Power | CUR_CRI_CCT | CUR_Distribution | CUR_Baffle | CUR_DriCUR
 | Model | Physical | Power (W) | CRI/CCT | Distribution | Baffle | Driver |  |  |  | ST | 10 | 830 |  |  | D
 | CUR | ST | 10 | 830 |  |  | D |  |  |  | MT | 15 | 840 |  |  | P
 |  | MT | 15 | 840 |  |  | P |  |  |  | LT | 22 | 850
 |  | LT | 22 | 850
 |  |  |  |  |  |  |  |  |  |  | OND_Physical | OND_Power | OND_CRI_CCT | OND_Distribution | OND_Baffle | OND_DriOND
 |  |  |  |  |  |  |  |  |  |  | 123 | 18 | 830 |  | SM | D
 | Model | Physical | Power (W) | CRI/CCT | Distribution | Baffle | Driver |  |  |  | 603 | 24 | 840 |  | PL | P
 | OND | 123 | 18 | 830 |  | SM |  |  |  |  | 606 | 32 | COI
 |  | 603 | 24 | 840 |  | PL | D |  |  |  | 126 | 38
 |  | 606 | 32 | COI |  |  | P |  |  |  | 153
 |  | 126 | 38
 |  | 153
Spreadsheet: gerald_nemec__11416__Equity valuation - for condor
Sheet: LCGG valuation

Fort  Union Gas Gathering and Lost Creek Gas Gathering
Lost Creek Valuation
Lost Creek Gas Gathering
For the period beginning | 2000-09-30 00:00:00
Ending | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00 | 2003-01-31 00:00:00 | 2003-02-28 00:00:00 | 2003-03-31 00:00:00 | 2003-04-30 00:00:00 | 2003-05-31 00:00:00 | 2003-06-30 00:00:00 | 2003-07-31 00:00:00 | 2003-08-31 00:00:00 | 2003-09-30 00:00:00 | 2003-10-31 00:00:00 | 2003-11-30 00:00:00 | 2003-12-31 00:00:00 | 2004-01-31 00:00:00 | 2004-02-29 00:00:00 | 2004-03-31 00:00:00 | 2004-04-30 00:00:00 | 2004-05-31 00:00:00 | 2004-06-30 00:00:00 | 2004-07-31 00:00:00 | 2004-08-31 00:00:00 | 2004-09-30 00:00:00 | 2004-10-31 00:00:00 | 2004-11-30 00:00:00 | 2004-12-31 00:00:00 | 2005-01-31 00:00:00 | 2005-02-28 00:00:00 | 2005-03-31 00:00:00 | 2005-04-30 00:00:00 | 2005-05-31 00:00:00 | 2005-06-30 00:00:00 | 2005-07-31 00:00:00 | 2005-08-31 00:00:00 | 2005-09-30 00:00:00 | 2005-10-31 00:00:00 | 2005-11-30 00:00:00 | 2005-12-31 00:00:00
INCOME STATEMENT
REVENUES
Burlington Demand Charge
ENA Demand Charge
Total Revenues
EXPENSES
O&M Escalator
O&M Expense
Ad Valorem Tax Expense
Other | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total O&M Expenses
EBITDA
Interest Expense
Depreciation Expense
Amortization of Capitalized Interest
Net Income
STATEMENT OF CASH FLOWS
Cash at beginning of period | 0
OPERATIONS
Pre Tax Income
Plus Depreciation Expense
Cash Flows from Operations
INVESTMENTS
Purchases of PP&E |  | 0
Cash Flows from Investments
FINANCING
Increase in Long Term Debt
Dividends Paid
Increase in Paid-In Capital
Cash Flows from Financing
Cash at end of period
Increase in cash
Spreadsheet: 874980d1721514867-use-formulas-logic-of-one-field-as-if-statement-for-another-field-very-complex-countif-samplefile_improved-sabs12-
Sheet: VIS_07-24

NUP_VERFAHREN | [NAME] | ADRESSE | FIRMA1 | Status Vertrag | Anfangsdatum Vertrag | Endedatum Vertrag | ARTIKEL | NAMEINTERN | Status Position | Anfangsdatum Position | Endedatum Position | DiWo | VIS
 |  |  | [NAME] | 2 |  |  |  | [NAME] zu DMS - monatlich | 2
 |  |  | Smith | 2 |  |  |  | [NAME] zu DMS - monatlich | 2
 |  |  | [NAME] | 2 |  |  |  | [NAME] (LK) - monatlich | 2
 |  |  | Walter | 2 |  |  |  | [NAME] (LK) - monatlich | 2
 |  |  | Kent | 2 |  |  |  | [NAME] | 2
 |  |  | Note | 2 |  |  |  | [NAME] | 3
 |  |  | [NAME] | 2 |  |  |  | [NAME] | 2
 |  |  | Hagen | 2 |  |  |  | [NAME] | 3
 |  |  | Forest | 2 |  |  |  | [NAME] | 2
 |  |  | Clock | 2 |  |  |  | [NAME] | 2
 |  |  | Berris | 2 |  |  |  | [NAME] | 2
 |  |  | Docs | 2 |  |  |  | [NAME] | 2
 |  |  | Obs | 2 |  |  |  | [NAME] | 2
 |  |  | Full | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | Smith | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | Stern | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 3
 |  |  | Beauford | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | [NAME] | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | [NAME] | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | Hank | 2 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | Hoffs | 3 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | [NAME] | 3 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | Jenkins | 2 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | Bell | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | [NAME] | 3 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 3
 |  |  | Munch | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | Rio | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | [NAME] | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | Port | 1 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 1
 |  |  | Good | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Tree | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Alfred | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Wills | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Ink | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Melody | 2 |  |  |  | VIS [NAME] | 2
 |  |  | [NAME] | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Green | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Woods | 2 |  |  |  | VIS [NAME] | 2
Spreadsheet: 689155d1596145471-a-maximum-cumulative-average-of-minimum-60-cells-over-a-larger-data-range-excelhelp1
Sheet: Sheet1

 |  |  | Data Range | 8 | 14 | 5 | 87 | 28 | 51 | 19 | 24 | 5 | 13 | 0 | 24 | 28 | 11 | 17 | 19 | 26 | 0 | 0 | 11 | 77 | 22 | 75 | 37 | 116 | 10 | 15 | 40 | 116 | 0 | 1 | 6 | 19 | 0 | 14 | 27 | 36 | 11 | 33 | 8 | 20 | 5 | 9 | 1 | 32 | 1 | 4 | 48 | 4 | 40 | 36 | 38 | 41 | 21 | 83 | 1 | 13 | 47 | 173 | 14 | 25 | 4 | 18 | 51 | 92 | 23 | 27 | 0 | 34 | 47 | 60 | 0 | 35 | 17 | 105 | 94 | 123 | 18 | 29 | 53 | 16 | 42 | 54 | 40 | 54 | 4 | 22 | 0 | 9 | 6 | 25 | 34 | 124 | 13 | 19 | 70 | 8 | 106 | 61 | 77 | 20 | 32 | 51 | 54 | 4 | 6 | 23 | 37 | 58 | 46 | 61 | 5 | 13 | 52 | 61 | 6 | 26 | 4 | 5 | 5 | 59 | 0 | 79 | 5 | 13
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 4 Math

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 4
[NAME]
Raw Score | Scale Score** | Level
0 | 96 | D
1 | 114 | D
2 | 126 | D
3 | 134 | D
4 | 140 | D
5 | 146 | D
6 | 152 | D
7 | 158 | D
8 | 165 | D
9 | 171 | D
10 | 177 | D
11 | 181 | D
12 | 185 | D
13 | 190 | P
14 | 192 | P
15 | 194 | P
16 | 197 | P
17 | 200 | M
18 | 202 | M
19 | 204 | M
20 | 207 | M
21 | 210 | M
22 | 213 | M
23 | 216 | M
24 | 219 | E
25 | 226 | E
26 | 235 | E
27 | 251 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 810493d1671807955-need-an-automated-list-updater-rating-system-test
Sheet: RATING SYSTEM

XCL RATING SYSTEM
ELO FACTOR |  | RATING LIST | 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
50 |  | FACTOR | 1 | 0.95 | 0.9 | 0.85 | 0.8 | 0.75 | 0.7 | 0.65 | 0.6 | 0.55 | 0.5 | 0.45 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0 | 0 | 0 | 0 | 0 | -0.05 | -0.1 | -0.2 | -0.4 | -0.5
ID | Gamertags | RACE NUMBER | BASE RATING | LAST RACE RESULT | NEW RATING |  | TRANSFORMED RATING | WIN CHANCE | FACTOR
#229830 | Klorpte
#229309 | SLR oluvion |  |  |  |  |  |  |  |  |  | How do I easily update the new ratings to the "ID List" tab without creating a loop??
#227153 | Baspw
#224285 |  |  |  |  |  |  |  |  |  |  | The calculation of rating is inside the hidden tabs.
#228477
#226005 |  |  |  |  |  |  |  |  |  |  | On the original sheet, I import a list with csv's  from a website that has the gamertags in it.
#224542
#226970 |  |  |  |  |  |  |  |  |  |  | Then I put the Gamertags in the same kind of calculator like the one on the left
#225885
#223944 |  |  |  |  |  |  |  |  |  |  | After that, I now need to update everyones new rating by hand, one by one. This becomes too much work.
#229606
#228993 |  |  |  |  |  |  |  |  |  |  | And then the list gets displayed on a website with the new ratings.
#221051
 |  |  |  |  |  |  |  |  |  |  | We don't need to store  or keep the old ratings/results (would be a good extra feature, but not necessary for now)
 |  |  |  |  |  |  |  |  |  |  | NOTE: List gets updated every day!
Spreadsheet: 670056d1585738918-creating-a-cleaning-and-product-usage-schedule-cleaning-time-3-
Sheet: Sheet1

Choose Current Product |  |  |  | Choose Product your changing to |  |  |  |  |  | Product | Hopper | Helper | Material |  |  | Hopper | Clean Time |  | All Products
3 |  |  |  | 2 |  |  |  |  |  | 1 | 1 |  | Mat1 |  |  | 1 | 12 |  | 1
 |  |  |  |  |  |  |  | <=Total Time |  | 1 | 2 |  | Mat2 |  |  | 2 | 14 |  | 2
Hopper | Material |  | Clean Time | Hopper | Material |  | Clean Time |  |  | 1 | 4 |  | Mat4 |  |  | 3 | 12 |  | 3
 |  |  |  |  |  |  |  |  |  | 1 | 6 |  | Mat6 |  |  | 4 | 15
 |  |  |  |  |  |  |  |  |  | 1 | 8 |  | Mat8 |  |  | 5 | 17
 |  |  |  |  |  |  |  |  |  | 1 | 9 |  | Mat9 |  |  | 6 | 11
 |  |  |  |  |  |  |  |  |  | 2 | 2 |  | Mat2 |  |  | 7 | 20
 |  |  |  |  |  |  |  |  |  | 2 | 3 |  | Mat3 |  |  | 8 | 15
 |  |  |  |  |  |  |  |  |  | 2 | 5 |  | Mat5 |  |  | 9 | 5
 |  |  |  |  |  |  |  |  |  | 2 | 7 |  | Mat7 |  |  | 10 | 25
 |  |  |  |  |  |  |  |  |  | 2 | 9 |  | Matx
 |  |  |  |  |  |  |  |  |  | 3 | 1 |  | Maty
 |  |  |  |  |  |  |  |  |  | 3 | 5 |  | Matz
 |  |  |  |  |  |  |  |  |  | 3 | 6 |  | Mat6
 |  |  |  |  |  |  |  |  |  | 3 | 7 |  | Mat7
 |  |  |  |  |  |  |  |  |  | 3 | 8 |  | Mat8
 |  |  |  |  |  |  |  |  |  | 3 | 9 |  | Mat9
 |  |  |  |  |  |  |  |  |  | 3 | 10 |  | Mat10
Spreadsheet: 6d116a95-ac92-465b-b07e-2cbd964fd40a
Sheet: Sheet1

Student Name and Site: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME]
Clinical Mental Health Counseling Log
 | Week 1 | Week 2 | Week 3 | Week 4
Activity | From: | From: | From: | From: | Totals
 | To: | To: | To: | To:
Individual Counseling (includes intake interviews) | 0 |  |  |  | 0
Group Counseling | 0 |  |  |  | 0
Family Counseling | 0 |  |  |  | 0
[NAME] | 0 |  |  |  | 0
Mental Status or Other Assessment/ Interpretation | 0 |  |  |  | 0
Other Direct | 0 |  |  |  | 0
Indirect Hours (e.g., case consultation, observation, paperwork, meetings, etc.) | 0 |  |  |  | 0
Individual/Triadic Supervision | 0 |  |  |  | 0
Group Supervision | 0 |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0
Monthly Totals | Direct |  | 0
 | Nondirect |  | 0
 | Supervision |  | 0
 | Direct Individual & Group |  | 0
Semester Totals To Date | Direct |  | 0
 | Nondirect |  | 0
 | Supervision |  | 0
 | Direct Individual & Group |  | 0
 | TOTAL HRS |  | 0
As the intern, my signature below verifies that I completed these hours AND during this time, I maintained
current liability insurance and clearances in accordance with the IUP Department of Counseling policy.
Intern's Signature: |  |  |  |  |  | Date:
Site [NAME]'s Signature: |  |  |  |  |  | Date:
Spreadsheet: 134451d1325287991-how-do-i-write-a-formula-to-tally-class-participation-copy_of_speech
Sheet: School Students

School 1 | School 2 | School 3 | School 4 | School 5 | School 6 | School 7 | School 8
Barker | Chambers | Martin | Dart | Helton | Gant | Orr | Quinn
Bain | [NAME] | [NAME] | Fox | Star | Park | [NAME]
North
Spreadsheet: 0700e193-8b5a-47b1-b86b-b766ca8adaef
Sheet: Elementary

 | Elementary
 |  | Alcohol | Tobacco | Other Drugs | Distribution | Assaults | [NAME] | Handgun | Rifle | Other Firearm | Other Weapon | Totals
 | District
 | Alpine | - | - | 3 | - | 6 | - | - | - | - | 3
 | Beaver | - | - | - | - | - | - | - | - | - | -
 | [NAME] | - | - | - | - | 7 | - | - | - | - | 1
 | Cache | - | - | - | - | 40 | - | 1 | - | - | -
 | Canyons | - | 2 | 12 | - | 44 | 2 | - | - | 3 | 39
 | Carbon | - | - | 1 | - | - | - | - | - | - | -
 | Daggett | - | - | - | - | - | - | - | - | - | -
 | [NAME] | 2 | 2 | 2 | - | 259 | - | 1 | - | - | 65
 | Duchesne | - | - | - | - | 7 | - | - | - | - | -
 | Emery | - | - | - | - | - | - | - | - | - | -
 | [NAME] | - | - | - | - | 2 | - | - | - | - | -
 | Grand | - | - | - | - | 1 | - | - | - | - | 5
 | Granite | - | 5 | 18 | 6 | 121 | - | - | - | - | 31
 | Iron | - | - | - | - | - | - | - | - | - | -
 | Jordan | - | - | - | - | 159 | 1 | 1 | - | - | 33
 | [NAME] | - | - | - | - | - | - | - | - | - | -
 | [NAME] | - | - | - | - | 1 | - | - | - | - | -
 | Logan | - | - | - | - | 4 | - | - | - | - | 1
 | Millard | - | - | - | - | 6 | - | - | - | - | -
 | Morgan | - | - | - | - | - | - | - | - | - | -
 | [NAME] | - | - | 1 | - | 1 | - | - | - | - | 1
 | Nebo | - | - | - | - | 22 | - | - | - | - | 3
 | [NAME] | - | - | - | - | - | - | - | - | - | -
 | North Summit | - | - | - | - | - | - | - | - | - | -
 | Ogden | - | - | - | - | 6 | - | - | - | - | 5
 | Park City | - | - | - | - | - | - | - | - | - | 2
 | Piute | - | - | - | - | - | - | - | - | - | -
 | Provo | - | - | - | - | 8 | - | - | - | - | 1
 | Rich | - | - | - | - | - | - | - | - | - | -
 | [NAME] | - | 3 | 2 | - | 73 | - | - | 2 | 5 | 33
 | San Juan | - | - | - | - | 2 | - | - | - | - | 1
 | Sevier | - | - | - | - | - | - | - | - | - | -
 | South Sanpete | - | - | - | - | - | 2 | - | - | - | -
 | South Summit | - | - | - | - | - | - | - | - | - | -
 | Tintic | - | - | - | - | - | - | - | - | - | -
 | Tooele | - | - | 5 | - | 1 | - | - | - | - | 2
 | Uintah | 1 | - | 2 | - | - | - | - | - | - | 8
 | Wasatch | - | - | - | - | - | - | - | - | - | 1
 | Washington | - | - | - | - | 5 | - | - | - | - | 2
 | Wayne | - | - | - | - | - | - | - | - | - | 1
 | Weber | - | 1 | 1 | - | 110 | - | 1 | - | - | 22
 | District Total |  |  |  |  |  |  |  |  |  |  | 1233
Spreadsheet: 674998d1588101364-less-than-and-greater-than-sample
Sheet: Sheet1

Entry | Exit | Duration
04/09/20 21:24:00 | 04/09/20 22:24:09 |  | if a3 - a2 is a positive number, and less than 5 minutes difference, put an "X". Otherwise, do nothing.
04/10/20 18:35:32 | 04/10/20 19:41:50 |  | if a4 - a3 is a positive number, and less than 5 minutes difference, put an "X". Otherwise, do nothing.
04/10/20 21:27:19 | 04/10/20 21:44:24 |  | etc.
 | 04/10/20 22:21:52 | 0:00:00 | etc.
04/11/20 16:23:53 | 04/11/20 18:11:49 |  | etc.
04/11/20 18:30:16 | 04/11/20 19:15:03 |  | etc.
Spreadsheet: 491076d1480305262-can-i-create-a-formula-and-drag-the-cell-and-duplicate-the-formula-duplicate-formula
Sheet: Sheet1

 | 166.4
 | 4
 | 5.4
 | 7.5
 | 8.9
 | 10.6
 | 11.3
 | 12.3
 | 13.7
 | 16.5
 | 17.7
 | 18.3
 | 19.3
 | 19.9
 | 21.6
 | 22.6
 | 22.8
 | 25.3
 | 28.3
 | 28.5
 | 30
Spreadsheet: 197433d1354353338-remove-certain-information-from-a-list-and-auto-create-new-list-on-other-sheet-01122012-enquiry
Sheet: Employees-Present

s/n | File Number | Name | ID | Status | Salary Mode
 |  |  |  |  |  | From the other sheet "DataBase", how do we remove all the employees with the "RESIGNED" status and list out only those which are present onto this sheet without sorting?
Spreadsheet: 882869d1731347978-copying-creating-a-zipcode-postcode-distance-checker-assistance-postcode-distance-checker
Sheet: UK_PostCodes

PostCode | County or Area | Latitude | Longitude
AB10 | Aberdeen | 57.135 | -2.117
AB11 | Aberdeen | 57.138 | -2.092
AB12 | Aberdeen | 57.101 | -2.111
AB13 | Aberdeen | 57.108 | -2.237
AB14 | Aberdeen | 57.101 | -2.27
AB15 | Aberdeen | 57.138 | -2.164
AB16 | Aberdeen | 57.161 | -2.156
AB21 | Aberdeen | 57.21 | -2.2
AB22 | Aberdeen | 57.187 | -2.119
[NAME] | Aberdeen | 57.212 | -2.088
Spreadsheet: 105640d1302940576-excel-2007-extracting-values-from-specific-row-and-column-with-criteria-book2
Sheet: Sheet2

[NAME] | Punct (m) | FX (kN) | MY (kNm) | MZ (kNm) |  |  |  |  |  |  |  |  |  | Bar numbers | Sections
1 | x= 0.0 | 7243.41 | 128.22 | 76.16
1 | x= 0.0 | 3596.11 | -133.26 | 63.21 |  |  | For | Bar number: |  | 2
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
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 |  |  | 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=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: kate_symes__18155__Deal Correction 2-20
Sheet: Prior Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-02-16 00:00:00 | 2001-02-16 00:00:00 | 2001-02-15 00:00:00 | STSW | MF | Houston | Prebon | Time zone: from PST to PPT |  | 524249 | SP-15 | J-01 | [NAME] | 25 | 121 | [NAME]
 |  |  |  | [NAME]
 | 2001-02-16 00:00:00 | 2001-02-16 00:00:00 | 2001-02-15 00:00:00 | LTNW | MS | Houston | Amerex | MW: from 25 to 50 |  | 524267 | COB N-S/MID-C | Q3-01 | [NAME] | 50 | 300/286 | EES
 | 2001-02-16 00:00:00 | 2001-02-16 00:00:00 | 2001-02-15 00:00:00 | LTNW | MS | Houston | TFS | MW: from 25 to 50 |  | 524175 | Palo Verde | Q3-01 | On [NAME] | 50 | 420 | Nevada
 |  |  |  | MS Count
 | 2001-02-16 00:00:00 | 2001-02-16 00:00:00 | 2001-02-15 00:00:00 | STNW | DS | Houston | Amerex | Price: from 335 to 345 |  | 523984 | MID-C | 2001-02-17 00:00:00 | On [NAME] | 25 | 345 | PSCO
 |  |  |  | DS Count
 |  |  |  | Grand Count
Spreadsheet: 63091d1264053937-stock-portfolio-aggregating-over-multi-sheets-stock-portfolio-aggregating-over-multi-sheets
Sheet: SUMMARY

Page1 | (All) |  |  | To Create this kind of Report
Sum of Value | Column Labels |  |  | 1. You must add pivot table [NAME] button on Quick Access toolbar
Row Labels | Amount | Grand Total |  |  | To do this follow these steps.
ABC | 10000 | 10000 |  |  | 1.1 Office Button > Excel Options > Customize
TTT | 500 | 500 |  |  | 1.2 From Choose Command From drop-down select Command not in the Ribbon
[NAME] | 1500 | 1500 |  |  | and scroll down untill you find Pivot Report and [NAME]
XZY | 17000 | 17000
(blank) |  |  |  | 2. After you have placed the button on Quick Access Toolbar, push it to start [NAME] table [NAME]
Grand Total | 29000 | 29000 |  | 3. On the 1st step of the [NAME], select Multiple Consolidation Ranges option and Press NEXT button
 |  |  |  | 4. Press NEXT again
 |  |  |  | 5. Specify your ranges
 |  |  |  | 6. Press Finish
 |  |  |  | 7. READY!!!!!!!!!!
Spreadsheet: monika_causholli__28142__EIM- Steel Pricing Update101601
Sheet: Steel Pricing Update

ENRON INDUSTRIAL MARKETS
Steel Pricing Update
 | Financial Steel Products |  |  |  |  |  |  |  | Physical Steel Products
 | Financial Steel |  | $/ Net Ton |  |  |  |  |  | Physical Steel, Cash |  |  |  | $/ Net Ton
 | November Start
 | Product | Term | Bid |  | Offer | Volume/Month |  |  | Commodity | Term | Product |  | Bid | Offer | Minimum Volume
 | HRC PMAG | Nov 01 - Dec 01 | 220 | - | 224 | 10000 |  |  | HRC | Nov 01 |  | 10 Gauge 48" [NAME] A1011 B | 199 | 204 | 100
 | HRC PMAG | Nov 01- Oct 02 | 236 | - | 241 | 10000 |  |  | HRC | Dec 01 |  | 10 Gauge 48" [NAME] A1011 B | 199 | 204 | 100
 | HRC PMAG | Jan 02 - Mar 02 | 225 | - | 230 | 10000 |  |  | HRC | 2002-01-02 00:00:00 |  | Base Chi | 203 | 211 | 100
 | HRC PMAG | Jan 02 -Dec 02 | 241 | - | 247 | 10000 |  |  | HRC | 2002-02-03 00:00:00 |  | Base Chi | 205 | 214 | 100
 | HRC PMAG | Apr 02 - Jun 02 | 236 | - | 242 | 10000 |  |  | HRC | 2002-03-07 00:00:00 |  | Base Chi | 210 | 219 | 100
 | HRC PMAG | Jul 02-Sep 02 | 248 | - | 254 | 10000
 | HRC PMAG | Nov 01-0ct 04 | 257 | - | 267 | 1000
 |  |  |  | -
 | CRC PMAG | Nov 01 - Dec 01 | 303 | - | 307 | 2000 |  |  | Other Gauges, Widths, Loacations and [NAME] are Quoted from Trading Desk
 | CRC PMAG | Nov 01- Oct 02 | 319 | - | 324 | 2000 |  |  | Cold Rolled Coils, HD Galvanized Coils and Plate are Qouted from Trading Desk
 | CRC PMAG | Jan 02 - Mar 02 | 312 | - | 317 | 2000
 | CRC PMAG | Jan 02 -Dec 02 | 326 | - | 332 | 2000
 | CRC PMAG | Apr 02 - Jun 02 | 321 | - | 328 | 2000
 | CRC PMAG | Jul 02-Sep 02 | 331 | - | 338 | 2000
 | CRC PMAG | Nov 01-Oct 04 | 351 | - | 361 | 1000 |  |  |  | Please visit www.enrononline.com for transactable prices and volumes
 | Options |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
 | Floors, Caps, Collars, Three Ways and Call Spreads are Quoted from Trading Desk
 | Market Commentary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enron Industrial Markets Steel Desk Contacts
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Financial Traders
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | (713) 345-7415
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | (713) 345-4702
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Physical Traders
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | (713) 345-3753
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | (713) 345-7675
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | (713) 345-7592
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | (713) 345-7596
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sanjaya Varma |  |  | (713) 345-7593
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | (713) 345-9530
Spreadsheet: 126449d1319700850-using-reference-with-inserting-rows-sample
Sheet: plan

task | planned | 2011-10-04 00:00:00
task 1 - draw |  | 8
task 2 - build |  |  | 8 | 8 | 8
INSERTED TASK
task 3 - assemble something |  |  |  |  | 8 | 8 | 8
task 4 - some task again |  |  |  |  |  | 8 | 8 | 8 | 8
Spreadsheet: 804209d1667936865-trying-to-add-missing-cases-test1
Sheet: Raw Data updated Daily

12345678 | andre |  | 2022-10-13 00:00:00
12345679 | marc |  | 2022-10-14 00:00:00
52345680 | luc |  | 2022-10-19 00:00:00
62345681 | andre |  | 2022-10-19 00:00:00
12345682 | andre |  | 2022-10-15 00:00:00
52345683 | marc |  | 2022-10-18 00:00:00
12345684 | [NAME] |  | 2022-10-18 00:00:00