tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 764802d1643013652-enter-two-values-and-find-the-third-one-findfl
Sheet: Sheet1

 |  |  |  |  |  |  |  | Tab2 | ISA
 | FL | Temp | ISA |  |  |  |  | WT | -10 | -5 | 0 | 5 | 10 | 15 | 20
 | 200 | -25 | 0 |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 240
 | WT | ISA | FL |  |  |  |  | 16 |  |  |  |  | 240 | 220 | 220
 | 22 |  | 180 |  |  |  |  | 17 |  |  | 240 | 240 | 220 | 220 | 200
 |  |  |  |  |  |  |  | 18 |  | 240 | 220 | 220 | 200 | 200 | 180
 |  |  |  |  |  |  |  | 19 | 240 | 220 | 220 | 200 | 200 | 180 | 180
 |  |  |  |  |  |  |  | 20 | 220 | 220 | 200 | 200 | 180 | 180 | 160
 |  |  |  |  |  |  |  | 21 | 200 | 200 | 200 | 180 | 180 | 160 | 140
 |  |  |  |  |  |  |  | 21.5 | 200 | 200 | 180 | 180 | 160 | 140 | 120
 |  |  |  |  |  |  |  | 22 | 200 | 180 | 180 | 180 | 160 | 140 | 120
 |  |  |  |  |  |  |  | 22.5 | 200 | 180 | 180 | 160 | 160 | 140 | 120
 |  |  |  |  |  |  |  | 23 | 180 | 180 | 160 | 160 | 140 | 120 | 100
 |  |  |  |  |  |  |  | Tab1 | ISA
 |  |  |  |  |  |  |  | FL | -10 | -5 | 0 | 5 | 10 | 15 | 20
 |  |  |  |  |  |  |  | 100 | -15 | -10 | -5 | 0 | 5 | 10 | 15
 |  |  |  |  |  |  |  | 110 | -17 | -12 | -7 | -2 | 3 | 8 | 13
 |  |  |  |  |  |  |  | 120 | -19 | -14 | -9 | -4 | 1 | 6 | 11
 |  |  |  |  |  |  |  | 130 | -21 | -16 | -11 | -6 | -1 | 4 | 9
 |  |  |  |  |  |  |  | 140 | -23 | -18 | -13 | -8 | -3 | 2 | 7
 |  |  |  |  |  |  |  | 150 | -25 | -20 | -15 | -10 | -5 | 0 | 5
 |  |  |  |  |  |  |  | 160 | -27 | -22 | -17 | -12 | -7 | -2 | 3
 |  |  |  |  |  |  |  | 170 | -29 | -24 | -19 | -14 | -9 | -4 | 1
 |  |  |  |  |  |  |  | 180 | -31 | -26 | -21 | -16 | -11 | -6 | -1
 |  |  |  |  |  |  |  | 190 | -33 | -28 | -23 | -18 | -13 | -8 | -3
 |  |  |  |  |  |  |  | 200 | -35 | -30 | -25 | -20 | -15 | -10 | -5
 |  |  |  |  |  |  |  | 210 | -37 | -32 | -27 | -22 | -17 | -12 | -7
 |  |  |  |  |  |  |  | 220 | -39 | -34 | -29 | -24 | -19 | -14 | -9
 |  |  |  |  |  |  |  | 230 | -41 | -36 | -31 | -26 | -21 | -16 | -11
 |  |  |  |  |  |  |  | 240 | -43 | -38 | -33 | -28 | -23 | -18 | -13
 |  |  |  |  |  |  |  | 250 | -45 | -40 | -35 | -30 | -25 | -20 | -15
Spreadsheet: 795241d1662570995-how-to-use-vloop-up-formula-to-retrieve-the-values-from-different-work-sheet-test1
Sheet: Salary

 |  |  | Sr. # | Name | No. of Days | Salary | Commission
 |  |  | 1 | [NAME]
 |  |  | 2 | [NAME]
 |  |  | 3 | Michelle
 |  |  | 4 | [NAME]
 |  |  | 5 | [NAME]
 |  |  | 6 | Asmos
 |  |  | 7 | Senti
 |  |  | 8 | [NAME]
 |  |  | 9 | [NAME]
 |  |  | On F2 to F9 I want "R2 to R10" value from Attendace sheet
 |  |  | On G2 to G9 I want "S2 to S10" value from Attendace sheet
 |  |  | On H2 to H9 I want "E2 to E7" value from Commission sheet
Spreadsheet: 030de5c9-08d1-4687-adb5-d9cdb35d7d5f
Sheet: H

Course color corresponds with term of offering.  ORANGE  for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
History
HIST 100 | Civilizations-History | See CAR list at bottom of this page
HIST 101 | Civilizations-History | See CAR list at bottom of this page
HIST 111 | Civilizations-History
HIST 112 | Civilizations-History
HIST 221 |  | Non-Western; Experiential-Travel | cross-listed with JAPN 221
HIST 230 |  | Experiential-Research
HIST 251 |  | Non-Western
HIST 252 |  | Non-Western
HIST 281 |  | Non-Western
HIST 282 |  | Non-Western
HIST 320 |  | Non-Western; Experiential-Research
HIST 323 |  | Experiential-Research
HIST 328 |  | Experiential-Research
HIST 332 |  | Non-Western
HIST 347 |  | Non-Western; Experiential-Research
HIST 348 |  | Non-Western; Experiential-Research
HIST 352 |  | Experiential-Research
HIST 354 |  | Experiential-Research
HIST 355 |  | Experiential-Research
HIST 361 |  | Non-Western; Experiential-Research
HIST 365 |  | Non-Western; Experiential-Research
HIST 367 |  | Non-Western
HIST 371 |  | Experiential-Research
HIST 372 |  | Experiential-Research
HIST 375 |  | Experiential-Research;Experiential-Travel when course travels
HIST 376 |  | Experiential-Research
HIST 381 |  | Experiential-Travel | Summer 08; J-term 2010 cross-listed with BLST 381
HIST 381 |  | Experiential-Travel | J-term 09; 10  cross-listed with BLST 381
HIST 381 |  | Non-Western | J-term 2013-(The US and SE Asia)
HIST 386 |  | Experiential-Research
HIST 391 |  | Non-Western; Experiential-Research
HIST 392 |  | Non-Western; Experiential-Research
HIST 393 |  | Non-Western
HIST 394 |  | Non-Western
HIST 395 |  | Non-Western
HIST 396 |  | Non-Western; Experiential-Research
HIST 397 |  | Non-Western; Experiential-Research; Experiential-Travel when course travels
HIST 401 |  | Capstone
HIST 450-451 |  | Experiential-Internship
HIST 481-482 |  | Experiential-Research
HIST 487-488 |  | Experiential-Research
HIST 491-492 |  | Experiential-Research
HIST 496-498 |  | Experiential-Research
HIST 100-101 CAR designations
HIST 100 | Modern Iraq |  | Non-Western
 | History of Ancient Egypt |  | Non-Western
 | Intro to Southeast Asian History & Civilization |  | Non-Western
 | [NAME] to History, I: African History Before 1885 |  | Non-Western
HIST 101 | History of Ancient Egypt |  | Non-Western
 | [NAME] to History II: African History Since 1885 |  | Non-Western
 | China: Ancient to Modern |  | Non-Western; Travel for J-term 2014.
Spreadsheet: benjamin_rogers__1308__site_visit_schedule for Dave Kristich
Sheet: Confirm NRG

 |  | Company | NRG
 |  | Company Contact & Number | [NAME]  (612) 373-5406  Cell: (612) 859-8145
 |  | Site or Sites | [NAME]
 |  | Site Visit Date | Wednesday October 18th
 |  | Directions to Hotels/Site | See DealBench - Due Diligence List/Plant Pictures Section
 |  | Meeting Time/Place | Wednesday Morning
 |  |  | Gleason Plant
 |  |  | 1166 [NAME].
 |  |  | Gleason, TN 38229
 |  | Enron Site Visit Coordinator | [NAME]
 |  |  | Work: (713) 853-7626 / Cell: (713) 515-9477
 |  |  | [NAME] Manager
 |  |  | Work: (901) 648-2190
 |  | Company Site Visit Team
Spreadsheet: 716258d1612124376-retrieve-filtered-rows-from-one-table-into-another-tables-sample
Sheet: Sheet1

id | region | quantity |  | northerns |  | Northerns | Quantity | Height |  | Northerns | Quantity | Height
1 | North | 100 |  |  |  | 1
2 | North | 200 |  |  |  | 2
3 | South | 100 |  |  |  | 4
4 | North | 300 |  |  |  | 7
5 | South | 100 |  |  |  | 8
6 | South | 400 |  |  |  | 9
7 | North | 500 |  |  |  | 11
8 | North | 100 |  |  |  | 14
9 | North | 200 |  |  |  | 15
10 | South | 100 |  |  |  | 16
11 | North | 300 |  |  |  | 18
12 | South | 100 |  |  |  | 21
13 | South | 400
14 | North | 500
15 | North | 100
16 | North | 200
17 | South | 100
18 | North | 300
19 | South | 100
20 | South | 400
21 | North | 500
source table
Spreadsheet: 861159d1709121861-vertically-combining-data-from-multiple-columns-to-have-all-data-in-1-column-sku-list-example
Sheet: main skus

sku 1 | sku 2
ID000001
ID000002
ID000003 | ID000025
ID000004
ID000005
ID000006
ID000007
ID000008
ID000009
ID000010 | ID000026
ID000011
ID000012
ID000013
ID000014
ID000015
ID000016
ID000017
ID000018 | ID000027
Spreadsheet: stacey_white__39128__new BOOK REQUEST TAGG
Sheet: Sheet1

From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Requestor: | [NAME]
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
PWR-GAS-WMGMT | POWERGASWESTMANAGEMENT | x |  |  |  | NYMEX | x |  |  |  |  |  | NG/MMBtu/USD | [NAME] | MTM | Netco | ASAP
PWR-GAS-NW | POWERGASNORTHWEST | x |  |  |  | NYMEX | x |  |  |  |  |  | NG/MMBtu/USD | [NAME] | MTM | Netco | ASAP
PWR-GAS-SW | POWERGASSOUTHWEST | x |  |  |  | NYMEX | x |  |  |  |  |  | NG/MMBtu/USD | [NAME] | MTM | Netco | ASAP
PWR-GAS-CALI | POWERGASCALIFORNIA | x |  |  |  | NYMEX | x |  |  |  |  |  | NG/MMBtu/USD | [NAME] | MTM | Netco | ASAP
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
 |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Book | Login |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC
Administrator* | Names |  |  |  |  |  |  |  |  |  |  |  | Hierarchy
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
Heather Dunton
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | PORTFOLIO NAME |  | Added (Y/N) | Processors ID
Casey Evans |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM
 |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD
 |  |  |  |  |  |  |  |  |  |  |  | IF: | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
Spreadsheet: 826b8f0c-138c-43b4-bed1-b53c7debaace
Sheet: Sheet1

Resolution of GNG genes associated with blocked genes | Unnamed: 1 | Unnamed: 2
Deleted Gene | Reactant added to biomass equation | Product added to biomass equation
argS | argtrna[c] | trnaarg[c]
[NAME] | asntrna[c] | trnaasn[c]
aspS | asptrna[c] | trnaasp[c]
bioB | btn[c]
bioD | btn[c]
bioF | btn[c]
cysS | cystrna[c] | trnacys[c]
fmt | fmettrna[c] | mettrna[c]
[NAME] | glntrna[c] | trnagln[c]
glyQ | glytrna[c] | trnagly[c]
hisS | histrna[c] | trnahis[c]
leuS | leutrna[c] | trnaleu[c]
pheS | phetrna[c] | trnaphe[c]
pheT | phetrna[c] | trnaphe[c]
proS | protrna[c] | trnapro[c]
serS* | sertrna[c] or sertrna(sec) [c] | trnasec[c] or trnasecys[c]
thrS | thrtrna[c] | trnathr[c]
trpS | [NAME]] | trnatrp[c]
tyrS | tyrtrna[c] | trnatyr[c]
valS | valtrna[c] | trnaval[c]
alsB | all-D[c]
caiT | crn[c]
int | [NAME]]
*Alternate solutions since this gene is associated with two blocked reactions
Spreadsheet: d32d9cc3-eeef-4674-bf0e-9f4f88d86e20
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Berechnung der [NAME] ab 2008 mit Zellfunktionen
 | Steuermesszahl beträgt 3,5 vom Hundert
 |  |  |  |  | Eingabefelder
 | Gewerbeertrag (Negativbetrag mit Minusvorzeichen) |  |  |  | 34000 |  |  |  | § 7 Gewerbesteuergesetz
 | [NAME] |  |  |  | 4
 | Entgelte für Schulden (Kreditzinsen), [NAME] und dauernde Lasten, Gewinnanteile des stillen Gesellschafters |  |  |  |  |  | berücksichtigt
 |  |  |  |  |  |  | 1
 |  |  |  |  | 110000 |  | 110000 |  | § 8 GewStG, [NAME]-c
 | Miet- und [NAME] (einschließlich [NAME]) für die [NAME] beweglichen Wirtschaftsgüter des Anlagevermögens, die im Eigentum eines anderen stehen
 |  |  |  |  |  |  | 0.2
 |  |  |  |  | 0 |  | 0 |  | § 8 GewStG, [NAME]
 | Miet- und [NAME] (einschließlich [NAME]) für die Benutzung der unbeweglichen Wirtschaftsgüter des Anlagevermögens, die im Eigentum eines anderen stehen
 |  |  |  |  | [NAME] wählen!
 |  |  |  |  | ab 2010 |  | 0.5 |  | ab 2010 nur noch 50% zu berücksichtigen
 |  |  |  |  | 0 |  | 0 |  | § 8 GewStG, Nr.1e
 | [NAME] für die [NAME]) |  |  |  |  |  | 0.25
 |  |  |  |  | 0 |  | 0 |  | § 8 GewStG, Nr.1f
 | [NAME] Hinzurechnungen |  |  |  |  |  | 110000
 | abzüglich Freibetrag |  |  |  |  |  | -100000
 | verbleiben |  |  |  |  |  | 10000
 | [NAME] (25% dieser [NAME]) |  |  |  |  |  | 2500
 | andere Hinzurechnungen |  |  |  | 0 |  |  |  | § 8 GewStG, Nr.4-12
 | Kürzungen (ohne Minuszeichen eingeben) |  |  |  | 0 |  |  |  | § 9 Gewerbesteuergesetz
 | [NAME] unterliegender, abgerundeter Gewerbeertrag |  |  |  |  |  | 36500 |  | minus = Gewerbeverlust
 | Steuermeßzahl (abger. Gewerbeertrag x 3,5%) |  |  |  |  |  | 1277.5
 | Gewerbesteuer der Kapitalgesellschaft |  |  |  |  |  | 5110.000000000001
 | [NAME] unterliegender, abgerundeter Gewerbeertrag
 | abzüglich 24.500 € Freibetrag bei Personengesellschaften |  |  |  |  |  | 12000 |  | minus = Gewerbeverlust
 | Steuermeßzahl |  |  |  |  |  | 420.0000000000001
 | Gewerbesteuer der Personengesellschaft |  |  |  |  |  | 1680
 | Anrechnungsbetrag nach § 35 EStG (Meßbetrag x 3,8) |  |  |  |  |  | 1596
 | Parmentier [NAME] |  |  |  |  |  |  |  | letzte Änderung: 19.1.2010
Spreadsheet: benjamin_rogers__1224__test model from Erin
Sheet: BKDEPR 144A

BOOK DEPRECIATION
 | Depreciate | Total in
 | (1=Yes,0=No) | US $ [NAME] | Category | Rate
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 0
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 0
 | 1
 | 0
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
Spreadsheet: 127123d1320171176-excel-2007-help-with-matching-downloaded-file-to-a-table-test3
Sheet: table

 | Table | [NAME] |  | units | dollars
1 | AN/DN |  | 1 |  |  | 45.89359375
2 | CS |  | 2 |  |  | 0.200625
3 | DC |  | 3 |  |  | 119.110625
4 | DH |  | 4 |  |  | 2348.058125
5 | DH (HCQ) |  | 5 |  |  | 124.85828125
6 | DM/DP |  | 6 |  |  | 166.17890625
7 | DR |  | 7 |  |  | 10.3565625
8 | DS |  | 8 |  |  | 7004.58828125
9 | HB & HB/HG |  | 9 |  |  | 2.55296875
10 | DX |  |  | 0 | 0 | 0
11 | JK |  | 10 |  |  | 108.4125
12 | JR |  | 11 |  |  | 5.8946875
13 | KJ |  | 12 |  |  | 14.786875
14 | LH |  | 13 |  |  | 8.7609375
15 | LX |  | 14 |  |  | 1929.0378125
16 | LX POL |  | 15 |  |  | 60.9875
17 | LX SRT 8 |  | 16 |  |  | 95.26578125
18 | ND |  | 17 |  |  | 0.6490625
19 | ND/NM |  |  | 0 | 0 | 0
20 | PT |  |  | 0 | 0 | 0
21 | RT |  |  | 0 | 0 | 0
22 | R2 |  |  | 0 | 0 | 0
23 | RS |  | 18 |  |  | 12.73453125
24 | C SERVICE |  | 19 |  |  | 9237.49984375
25 | CHRY VIPER |  |  | 0 | 0 | 0
26 | CHRY WK |  | 20 |  |  | 282.11953125
27 | SRT8 |  | 21 |  |  | 1.281875
28 | F |  | 22 |  |  | 0.7009375
29 | C170 |  |  | 0 | 0 | 0
30 | DEW |  |  | 0 | 0 | 0
31 | D186 |  | 23 |  |  | 1.140625
32 | D219 |  |  | 0 | 0 | 0
33 | D258 |  | 24 |  |  | 12.515625
34 | D3 |  |  | 0 | 0 | 0
35 | D385 |  | 25 |  |  | 965.82265625
36 | D471/D47X |  | 26 |  |  | 461.1121875
37 | EN/FN |  | 27 |  |  | 2797.00796875
38 | F53 |  | 28 |  |  | 214.05609375
39 | PN96 |  | 29 |  |  | 263.6090625
40 | P131 |  | 30 |  |  | 72.3059375
41 | P150 |  | 31 |  |  | 332.2309375
42 | P221 |  | 32 |  |  | 4658.73078125
43 | P356 |  | 33 |  |  | 7.9165625
44 | P415 |  | 34 |  |  | 654.30640625
45 | P473 |  | 35 |  |  | 18428.62953125
46 | F SERVICE |  | 36 |  |  | 10414.6515625
47 | SN95 |  |  | 0 | 0 | 0
48 | S197 |  | 37 |  |  | 48.136875
49 | U152 |  | 38 |  |  | 2653.68921875
50 | U22X |  | 39 |  |  | 42.46
51 | U222 |  | 40 |  |  | 1753.63703125
52 | U204 |  |  | 0 | 0 | 0
53 | U231 |  |  | 0 | 0 | 0
54 | U251 |  |  | 0 | 0 | 0
55 | U377 |  | 41 |  |  | 24.5184375
56 | U387 |  | 42 |  |  | 4806.8459375
57 | U387/U388 |  | 43 |  |  | 1472.630625
 |  |  |  | 0 | 0 | 0
58 | U502 |  | 45 |  |  | 1825.5375
59 | [NAME] |  | 46 |  |  | 4689.37796875
60 | V229 |  |  | 0 | 0 | 0
61 | WIN126 |  |  | 0 | 0 | 0
62 | KARMA |  | 47 |  |  | 5040.7475
63 | GMT257 |  |  | 0 | 0 | 0
64 | GMT355 |  | 48 |  |  | 184.6875
65 | GMT560 |  | 49 |  |  | 1686.54703125
 |  |  |  |  |  | 158.5275
 |  |  |  |  |  | 4
Spreadsheet: andy_zipper__141__ICE - Mar14 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-14-01 thru Mar-14-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - TCO - Apr01-Oct01 | Apr01-Oct01 | 0.228 | 0.233 | 0.23 | 0.228 | Mar-14-01 20:10 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for IF - CNG-SP - Apr01 | Apr01 | 0.31 | 0.31 | 0.31 | 0.31 | Mar-14-01 14:31 GMT | 150000 | MMBtus
 | NG Fin BS, LD1 for IF - CNG-SP - Apr01-Oct01 | Apr01-Oct01 | 0.31 | 0.31 | 0.31 | 0.31 | Mar-14-01 15:33 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for IF - Panhandle - Apr01-Oct01 | Apr01-Oct01 | -0.065 | -0.065 | -0.065 | -0.065 | Mar-14-01 15:53 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for IF - Transco Z6 (NY) - Apr01-Oct01 | Apr01-Oct01 | 0.49 | 0.49 | 0.49 | 0.49 | Mar-14-01 15:43 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Chicago - Apr01 | Apr01 | 0.14 | 0.14 | 0.14 | 0.14 | Mar-14-01 14:58 GMT | 300000 | MMBtus
 | NG Fin BS, LD1 for NGI - Chicago - Nov01-Mar02 | Nov01-Mar02 | 0.248 | 0.25 | 0.248 | 0.248 | Mar-14-01 18:46 GMT | 6040000 | MMBtus
 | NG Fin BS, LD1 for NGI - Socal - Nov01-Mar02 | Nov01-Mar02 | 2.6 | 2.6 | 2.6 | 2.6 | Mar-14-01 16:47 GMT | 755000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 4.993 | 5.04 | 5.005 | 5.04 | Mar-14-01 16:14 GMT | 510000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 4.925 | 5.063 | 5.009 | 4.935 | Mar-14-01 21:15 GMT | 6750000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 4.975 | 5.055 | 5.002 | 4.975 | Mar-14-01 20:45 GMT | 465000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.04 | 5.04 | 5.04 | 5.04 | Mar-14-01 20:13 GMT | 1070000 | MMBtus
Spreadsheet: 89377d1289184412-extract-data-from-different-sheet-test-1
Sheet: Sheet1

Content | Application Name | Severity | Update | Date Of | Today | Number | Status
Infrastructure System | Active Directory Services (Global) | Low | 2006-04-18 00:00:00 | 2011-04-19 00:00:00 | 2010-11-07 18:46:27 | 5 | X
Application | ADP | Low | 2006-07-06 00:00:00 | 2011-07-07 00:00:00 | 2010-11-07 18:46:27 | 8 | Y
Infrastructure System | Application Portal Service (APS) | High | 2010-06-30 00:00:00 | 2012-06-30 00:00:00 | 2010-11-07 18:46:27 | 19 | Z
Application | ARBBL/MOC | Low | 2006-07-06 00:00:00 | 2011-07-07 00:00:00 | 2010-11-07 18:46:27 | 8 | X
Application | AR-CC | Low | 2005-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-11-07 18:46:27 | 8 | Y
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | Z
Application | ARBBL/MOC | Low | 2006-07-06 00:00:00 | 2011-07-07 00:00:00 | 2010-11-07 18:46:27 | 8 | Y
Application | AR-CC | Low | 2005-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-11-07 18:46:27 | 8 | Z
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | X
Application | ARBBL/MOC | Low | 2006-07-06 00:00:00 | 2011-07-07 00:00:00 | 2010-11-07 18:46:27 | 8 | Y
Application | AR-CC | Low | 2005-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-11-07 18:46:27 | 8 | Y
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | Y
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | X
Application | ARBBL/MOC | Low | 2006-07-06 00:00:00 | 2011-07-07 00:00:00 | 2010-11-07 18:46:27 | 8 | X
Application | AR-CC | Low | 2005-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-11-07 18:46:27 | 8 | Z
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | Z
Application | AR-CC | Low | 2005-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-11-07 18:46:27 | 8 | Y
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | Z
Spreadsheet: 826320d1681925797-countif-formula-for-names-appearing-in-all-or-some-months-book2-2-
Sheet: Sheet1

Name | Jan | Feb | March |  | Total | All 3 months | Any 2 months | Any 1 month
[NAME] | 15200 | 6950 | 0
[NAME] | 37693 | 74303 | 80712
[NAME] | 366615 | 0 | 0
[NAME] | 4838 | 0 | 6048
[NAME] | 22805 | 0 | 0
[NAME] | 10207 | 0 | 0
[NAME] | 33377 | 0 | 0
Spreadsheet: 0066e1a8-8592-45c4-801f-ee47b173de67
Sheet: Sheet1

LAB LOG SHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | MONTH OF SERVICE: | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Date | Grant | PATIENT INFORMATION | PAP | RESULTS |  | STD | RESULTS |  | MAMMO | RESULTS |  | OTHER | RESULTS |  | ACTION/NOTES
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  | NAME:
 |  | D.O.B.
 |  | PHONE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | spoc 8.18.11
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-11-P-0020

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-11-P-0020 |  |  | 1P
W912LP-11-P-0020 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 67901d1268409178-moving-dynamic-data-to-a-specific-row-despite-row-being-filtered-example-for-web
Sheet: Input

 | Account Number | Name | Area | Total | Date
 | 1 | The Greyhound | LONDON | 50 | 2010-03-01 00:00:00
 | 2 | The Bell | OXFORD | 50 | 2010-03-01 00:00:00
 | 3 | the [NAME] | DEVON | 50 | 2010-03-01 00:00:00
 | 4 | Fox and Hounds | LONDON | 50 | 2010-03-01 00:00:00
 | 1 | The Greyhound | LONDON | 60 | 2010-02-20 00:00:00
Spreadsheet: 843004d1694980845-sort-text-strings-based-on-two-criteria-sort-strings-by-two-criteria
Sheet: Sheet2

 | Data |  | Desired result
 | 2r 37m2 |  | 2r 37m2
 | 2r 49m2 |  | 2r 49m2 | 2r 49m2
 | 2r 50m2 |  | 2r 50m2 | 2r 50m2
 | 2r 51m2 |  | 2r 51m2 | 2r 51m2
 | 2r 58m2 |  | 2r 58m2 | 2r 58m2
 | 3r 81m2 |  | 3r 81m2 | 3r 81m2 |  | https://www.excelforum.com/excel-formulas-and-functions/1412168-using-textsplit-with-map-and-lambda-is-not-working.html
 | 4r 101m2 |  | 4r 89m2 | 4r 89m2
 | 4r 89m2 |  | 4r 94m2 | 4r 94m2
 | 4r 94m2 |  | 4r 96m2 | 4r 96m2
 | 4r 96m2 |  | 4r 97m2 | 4r 97m2
 | 4r 97m2 |  | 4r 101m2 | 4r 101m2
 | 5r 104m2 |  | 5r 98m2 | 5r 98m2
 | 5r 98m2 |  | 5r 104m2 | 5r 104m2
 |  |  |  |  |  |  | 37m2
 |  |  |  |  |  | 2r | 49m2
 |  |  |  |  |  | 2r | 50m2
 |  |  |  |  |  | 2r | 51m2
 |  |  |  |  |  | 2r | 58m2
 |  |  |  |  |  | 3r | 81m2
 |  |  |  |  |  | 4r | 101m2
 |  |  |  |  |  | 4r | 89m2
 |  |  |  |  |  | 4r | 94m2
 |  |  |  |  |  | 4r | 96m2
 |  |  |  |  |  | 4r | 97m2
 |  |  |  |  |  | 5r | 104m2
 |  |  |  |  |  | 5r | 98m2
Spreadsheet: 48554d1247771123-ammending-conditional-array-code-to-include-another-condition-conditon-to-exclude-lowest-value
Sheet: Sheet1

 | Want abilities to exclude smallest value in the C12:H12 range and use the next smallest value when a "Flag" value is placed into S12
 | Before Correction: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flag
8 | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B | 0 | 3.85 | 6.09 | 5.49 | 0 |  | JL Matthews | No Bid | 3.85 |  |  | No Bid | No Bid | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B , (31) | 4
 | Result After Correction:
8 | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B | 0 | 3.85 | 6.09 | 5.49 | 0 |  | JL Matthews | No Bid |  | 6.09 |  | No Bid | No Bid | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B , (31) | 4 | P