tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4f933d8f-6af2-4187-8ffe-5a75117e7b46
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
Journalism (TExES) | - | - | - | - | - | - | - | - | - | - | - | - | 1 | 0 |  | 1 | 0 |  | - | - | - | - | - | - | - | - | - | - | - | - | 1 | 1 | 1 | 1 | 1 | 1
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
Spreadsheet: 130276d1322147938-alternative-to-summing-multiple-vlookup-formulas-vlookup-example
Sheet: status

Store | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL | FY11 ACTUAL
Number | Jul 2010 | Aug 2010 | Sep 2010 | Oct 2010 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
A | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
B | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
C | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
D | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
E | COMP | COMP | COMP | COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP
F | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
G | COMP | COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP
H | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
I | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
J | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP
K | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP
L | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | NON-COMP | COMP | COMP
Spreadsheet: 487526d1478117492-select-random-product-stock-ids-copy-of-product_list-1
Sheet: P_Pivot

Count of Product ID |  |  |  |  |  | Best-selling products (First 2)
197 |  |  |  |  |  | Beverages > Product F, Product D
 |  |  |  |  |  | [NAME] B, Product C
 |  |  |  |  |  | I need this: Five random Product Stock IDs for First two products for count of sales
 |  |  |  |  |  | Product ID
 |  |  |  |  |  | DD00156
 |  |  |  |  |  | DD00157
 |  |  |  |  |  | DD00158
 |  |  |  |  |  | DD00159
 |  |  |  |  |  | DD00160
 |  |  |  |  |  | DD00161
 |  |  |  |  |  | DD00162
 |  |  |  |  |  | DD00163
 |  |  |  |  |  | DD00164
 |  |  |  |  |  | DD00194
 |  |  |  |  |  | DD00195
 |  |  |  |  |  | DD00196
 |  |  |  |  |  | DD00197
 |  |  |  |  |  | DD00198
 |  |  |  |  |  | DD00244
 |  |  |  |  |  | DD00245
 |  |  |  |  |  | DD00246
 |  |  |  |  |  | DD00247
 |  |  |  |  |  | DD00248
 |  |  |  |  |  | DD00256
 |  |  |  |  |  | DD00257
 |  |  |  |  |  | DD00258
 |  |  |  |  |  | DD00259
 |  |  |  |  |  | DD00260
 |  |  |  |  |  | DD00289
 |  |  |  |  |  | DD00290
 |  |  |  |  |  | DD00291
 |  |  |  |  |  | DD00292
 |  |  |  |  |  | DD00293
 |  |  |  |  |  | DD00294
 |  |  |  |  |  | DD00295
 |  |  |  |  |  | DD00296
 |  |  |  |  |  | DD00297
 |  |  |  |  |  | DD00298
 |  |  |  |  |  | DD00299
 |  |  |  |  |  | DD00300
 |  |  |  |  |  | DD00301
 |  |  |  |  |  | DD00302
 |  |  |  |  |  | DD00303
 |  |  |  |  |  | DD00304
 |  |  |  |  |  | DD00305
 |  |  |  |  |  | DD00306
 |  |  |  |  |  | DD00307
 |  |  |  |  |  | DD00317
 |  |  |  |  |  | DD00323
 |  |  |  |  |  | DD00324
 |  |  |  |  |  | DD00325
 |  |  |  |  |  | DD00326
Spreadsheet: 237738d1369302259-dynamic-row-column-change-on-list-box-combo-namedrange-with-validation
Sheet: Sheet1

 |  |  |  |  |  | Plase cursor in G3 & H3 cell and make selection from drop down…
 |  |  |  |  |  | Selection-1 | Selection-2
 |  |  | All | [NAME] or Combo |  | A1 | Data1
 |  |  | A1
 |  |  | A2
 |  |  | A3
 |  | If select ALL from dropdown then table will be like below. First column heading is linked with Listbox value
 |  | All | B1 | B2
 |  | Data1 | Data 10 | Data 20
 |  | Data2 | Data 11 | Data 21
 |  | Data3 | Data 12 | Data 22
 |  | If select [NAME] from dropdown then table will be like below. Change will be in first column heading (which is linked with Listbox value) and additional Row at bottom
 |  | A1 | B1 | B2
 |  | Data1 | Data 10 | Data 20
 |  | Data2 | Data 11 | Data 21
 |  | Data3 | Data 12 | Data 22
 |  | row for [NAME] only | Data 13 | Data 23
 |  | If select A2 from dropdown then table will be like below. Change will be in first column heading (which is linked with Listbox value) and additional Row at bottom
 |  | A2 | B1 | B2
 |  | Data1 | Data 10 | Data 20
 |  | Data2 | Data 11 | Data 21
 |  | Data3 | Data 12 | Data 22
 |  | row for A2 only | Data 14 | Data 24
Spreadsheet: 863426d1710923247-search-a-table-and-paste-the-content-from-a-specific-cell-suche-b-texte
Sheet: Tabelle2

 | 1 | Person 1
 | 2 | Person 2
 | 3 | Person 3
 | 4 | Person 4
 | 5 | Person 5
 | 6 | Person 6
 | 7 | Person 7
 | 8 | Person 8
 | 9 | Person 9
 | 10 | Person 10
Spreadsheet: 151148d1334803961-excel-2007-cell-designation-in-formula-changes-after-sort-is-there-a-better-way-hrderby2012-picksheet
Sheet: Payouts

45 Entries x $50 = | 2250 | Total In
1st Half Winners
(Pre-All Star Game)
1st - (50%) | 275
2nd-(30%) | 165
3rd-(20%) | 110
2nd Half Winners
(Post-All Star Game)
1st - (50%) | 275
2nd-(30%) | 165
3rd-(20%) | 110
Overall Winners
Yearly Totals
1st - (50%) | 550
2nd-(30%) | 330
3rd-(20%) | 220
Last Place (Overall) | 50
 | 2250 | Total Out
Spreadsheet: 593824d1539346660-looking-for-ideas-item-order-tracking-sheet-order-track
Sheet: Sheet1

 |  | Category 1 |  | Category 2 |  | Category 3 |  |  |  | Category 4 |  |  |  |  |  | Category 5 |  | Category 6 |  | Category 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | Category 8 |  | Category 9 | Category 10 |  |  |  | Category 11 |  |  | Category 12 |  |  |  |  |  |  |  | Category 13 |  |  | Category 14 |  | Category 15 |  |  |  |  | Category 16 | Category 17
Date | Ordered By | Item | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Item8 | Item9 | Item10 | Item11 | Item12 | Item13 | Item14 | Item15 | Item16 | Item17 | Item18 | Item19 | Item20 | Item21 | Item22 | Item23 | Item24 | Item25 | Item26 | Item27 | Item28 | Item29 | Item30 | Item31 | Item32 | Item33 | [NAME] | Item35 | Item36 | [NAME] | Item38 | Item39 | Item40 | Item41 | Item42 | Item43 | Item44 | Item45 | Item46 | Item47 | Item48 | Item49 | Item50 | Item51 | Item52 | Item53 | Item54 | Item55 | [NAME] | Item57 | Item58 | Item59 | Item60 | Item61 | Item62 | Item63 | Item64
Spreadsheet: 232148d1367341522-auto-fill-with-one-column-and-multiple-unique-rows-autofillquestion
Sheet: Sheet1

Data as I get it |  |  |  |  |  |  | I need to make a function to autofill the depts to the left. I can alwase insert a colum to get the calculation and then remove it if I need to.
Dept | Category | Data1 | Data2 | Data3 | etc |  | Dept | Category | Data1 | Data2 | Data3 | etc
2 | This Year | 530 | 311 | 220 | 24 |  | 2 | This Year | 530 | 311 | 220 | 24
 | Last Year | 914 | 1873 | 21 | 1252 |  | 2 | Last Year | 914 | 1873 | 21 | 1252
 | TY Sales Class | 1232 | 218 | 1112 | 165 |  | 2 | TY Sales Class | 1232 | 218 | 1112 | 165
 | LY Sales Class | 1244 | 981 | 1558 | 412 |  | 2 | LY Sales Class | 1244 | 981 | 1558 | 412
 | TY US SC | 1486 | 865 | 1995 | 1416 |  | 2 | TY US SC | 1486 | 865 | 1995 | 1416
4 | This Year | 1899 | 1069 | 616 | 637 |  | 4 | This Year | 1899 | 1069 | 616 | 637
 | Last Year | 1942 | 1656 | 209 | 1123 |  | 4 | Last Year | 1942 | 1656 | 209 | 1123
 | TY Sales Class | 1824 | 1744 | 1176 | 827 |  | 4 | TY Sales Class | 1824 | 1744 | 1176 | 827
 | LY Sales Class | 748 | 1420 | 569 | 299 |  | 4 | LY Sales Class | 748 | 1420 | 569 | 299
 | TY US SC | 431 | 932 | 1497 | 574 |  | 4 | TY US SC | 431 | 932 | 1497 | 574
8 | This Year | 985 | 1526 | 1094 | 1298 |  | 8 | This Year | 985 | 1526 | 1094 | 1298
 | Last Year | 1988 | 1869 | 959 | 578 |  | 8 | Last Year | 1988 | 1869 | 959 | 578
 | TY Sales Class | 1494 | 820 | 1989 | 1085 |  | 8 | TY Sales Class | 1494 | 820 | 1989 | 1085
 | LY Sales Class | 1897 | 1792 | 1841 | 206 |  | 8 | LY Sales Class | 1897 | 1792 | 1841 | 206
 | TY US SC | 1808 | 544 | 1252 | 1785 |  | 8 | TY US SC | 1808 | 544 | 1252 | 1785
1 | This Year | 277 | 254 | 1811 | 1738 |  | 1 | This Year | 277 | 254 | 1811 | 1738
 | Last Year | 1190 | 1024 | 1680 | 1985 |  | 1 | Last Year | 1190 | 1024 | 1680 | 1985
 | TY Sales Class | 1108 | 1685 | 690 | 1589 |  | 1 | TY Sales Class | 1108 | 1685 | 690 | 1589
 | LY Sales Class | 756 | 1327 | 898 | 713 |  | 1 | LY Sales Class | 756 | 1327 | 898 | 713
 | TY US SC | 1732 | 1585 | 1404 | 1682 |  | 1 | TY US SC | 1732 | 1585 | 1404 | 1682
5 | This Year | 1122 | 436 | 511 | 1821 |  | 5 | This Year | 1122 | 436 | 511 | 1821
 | Last Year | 581 | 1059 | 278 | 525 |  | 5 | Last Year | 581 | 1059 | 278 | 525
 | TY Sales Class | 1635 | 1440 | 660 | 1919 |  | 5 | TY Sales Class | 1635 | 1440 | 660 | 1919
 | LY Sales Class | 1892 | 393 | 772 | 236 |  | 5 | LY Sales Class | 1892 | 393 | 772 | 236
 | TY US SC | 588 | 573 | 881 | 679 |  | 5 | TY US SC | 588 | 573 | 881 | 679
10 | This Year | 666 | 1637 | 157 | 550 |  | 10 | This Year | 666 | 1637 | 157 | 550
 | Last Year | 1478 | 1961 | 1165 | 1687 |  | 10 | Last Year | 1478 | 1961 | 1165 | 1687
 | TY Sales Class | 665 | 1195 | 419 | 1494 |  | 10 | TY Sales Class | 665 | 1195 | 419 | 1494
 | LY Sales Class | 277 | 254 | 1811 | 1738 |  | 10 | LY Sales Class | 277 | 254 | 1811 | 1738
 | TY US SC | 1190 | 1024 | 1680 | 1985 |  | 10 | TY US SC | 1190 | 1024 | 1680 | 1985
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: MW Orig AA

 | Midwest Power Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 2
 |  |  |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 1
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: phillip_m_love__30544__Daily Prices
Sheet: Sheet1

Summary of Central EOL Deals
All Central EOL Deals: 9/21/2001 11:54:36 AM
Product ID | [NAME] | Weighted Average | High Trade | Low Trade | [NAME]
27760 | Cons. Power (Large) | 2.147500506585613 | 2.175 | 2.135 | 148050
27764 | MichCon (Large) | 2.181197201384882 | 2.225 | 2.15 | 138640
27812 | ANR | 1.98759960789274 | 2.06 | 1.95 | 205556
27813 | ANR-OK | 1.87652904974886 | 1.955 | 1.845 | 225372
27817 | NGPL (La Pool) | 2.009970833747391 | 2.06 | 1.98 | 301890
27818 | NGPL (Midcontinent) | 1.875722616380571 | 2 | 1.845 | 331649
27821 | NGPL (STX) | 2.01420867663712 | 2.05 | 1.915 | 51218
27822 | NGPL (TexOk East) | 1.965935940151037 | 2.0338 | 1.93 | 120236
27824 | [NAME] ([NAME]) | 1.950638583706727 | 2.03 | 1.91 | 501704
27826 | PEPL | 1.878041535856235 | 1.975 | 1.85 | 258644
29490 | ONG | 1.868521366257578 | 1.88 | 1.83 | 6763
29602 | [NAME] | 2.195811272224824 | 2.23 | 2.17 | 689713
32775 | [NAME] | 1.919964765828274 | 2.0175 | 1.8975 | 46120
32779 | [NAME] | 1.882136746987952 | 1.895 | 1.84 | 16600
47095 | [NAME] | 1.958427178906221 | 2.04 | 1.915 | 80327
Chicago | Chicago City Gates | 2.037481 | 2.125 | 2.01 | 1392135
Note: EOL Deals only.
Chicago City Gates composed of Peoples, NBPL Nicor, NGPL Nicor, and NIPSCO.
Spreadsheet: 544464d1508916659-scatter-with-line-chart-axis-text-values-are-not-appearing-1205991
Sheet: Sheet1

 |  |  |  | 2016 | 2015 | 2014
 |  |  | A+ | 2 | 2 | 4
 |  |  | A | 15 | 15 | 17
 |  |  | [NAME] | 26 | 27 | 30
 |  |  | B | 4 | 4 | 1
 |  |  | C | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  | instead of numbers I want rankings (A+, A, [NAME], C) in the axis
Spreadsheet: 08d6bf48-d0ba-4555-b84e-8d930ef3d23d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | [NAME] 3- پروژه‌هاي پيشنهادي جديد و ادامه دار   طرح توسعه ، تكميل ، تجهيز  و تامين ماشين‌آلات موسسه رازي (40108030) در سال 1390
 |  | شعبه [NAME] واكسن و سرم‌سازي رازي منطقه : جنوب كشور - شيراز |  |  |  |  |  |  |  |  |  |  |  |  |  | مبالغ به ميليون ريال
 | رديف | [NAME] | نوع عمليات |  |  |  | حجم كار در سال 1390 |  | اعتبار مورد نياز سال 1390
 |  |  | آزمايشگاهي و توليدي |  | اداري و پشتيباني |  | مقدار | واحد | فصل اول(ساختمان و مستحدثات) |  |  |  | فصل دوم (ماشين آلات و تجهيزات) | فصل سوم (ساير داراييهاي ثابت) | فصل هفتم (ساير داراييهاي توليد نشده) | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] احداث ساختمان و مستحدثات | ساير اعتبارات ساختمانها و مستحدثات |  | [NAME]
 |  |  | ادامه دار | [NAME] | ادامه دار | [NAME] |  |  |  | پيماني | اماني
 | [NAME] |  | آزمايشگاهي و توليدي
 |  |  | اداري و پشتيباني
 |  |  | كــــــــــل
 | * | مصوب سفرهاي استاني
Spreadsheet: 743595d1628608770-get-the-value-from-the-right-most-non-blank-cell-of-an-array-get-right-most-value-v2
Sheet: Sheet1

Version 1 |  |  |  | Version 2 |  |  |  | Version 3 |  |  |  | Latest
Rev | Date | Status | Trans | Rev | Date | Status | Trans | Rev | Date | Status | Trans
P01 | 2021-04-07 00:00:00 | A |  | C01 | 2021-05-28 00:00:00 | A | 12 |  |  |  |  | C01
P01 | 2021-04-07 00:00:00 | B |  | C01 | 2021-05-28 00:00:00 | A | 12 |  |  |  |  | C01
P01 | 2021-04-07 00:00:00 | C |  | P02 | 2021-05-28 00:00:00 | B |  | C01 | 2021-08-03 00:00:00 | A |  | C01
P01 | 2021-04-07 00:00:00 | C |  | C01 | 2021-05-28 00:00:00 | C |  | C02 | 2021-08-03 00:00:00 | B |  | C02
P01 | 2021-04-07 00:00:00 | C |  | P02 | 2021-05-28 00:00:00 | A |  | C01 | 2021-08-03 00:00:00 | A |  | C01
P01 | 2021-04-07 00:00:00 | B |  |  |  |  |  |  |  |  |  | P01
Spreadsheet: 847898d1698744145-bulk-substitute-in-a-spilling-array-cannot-split
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array)
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty
 |  |  |  |  |  |  | split (range O2#, row 1) |  | split (array, row 1) ([NAME]) |  |  | split (array, row 1) (glenn formula)
Spreadsheet: frank_ermis__11222__West NatGas Prices 1120
Sheet: Gas Average FinIdx

FinIdx Curves
 |  | WEST NATURAL GAS PRICES- Fin Idx
 |  | AS OF
 |  |  |  |  |  |  |  |  |  | Last-Day | Cash | Cash | Change | BOM | BOM | Change | Prompt Month | Change | Q4 | Change | Winter 2001-02 | Change | Q1 | Change | Q2 | Change | Summer 2002 | Change | Q3 | Change | Q4 | Change | Winter 2002-03 | Change
 |  |  |  |  |  |  |  |  |  | Cash Settle | Price | Spread |  | Price | Spread |  |  |  | 2001 |  | Nov-01/Mar-02 |  | 2002 |  | 2002 |  | Apr-02/Oct-02 |  | 2002 |  | 2002 |  | Nov-02/Mar-03
 |  | California Region Notional
 |  |  |  |  | Sheet Name | Row Num for CurveName | Column Letter for Date
 |  |  |  | Basis | IndexCurves | 13 | B
 |  | Gas Trading |  | IntraMonth | CurveFetch | 4 | D
 |  |  |  |  |  |  |  |  | IntraMonth
 |  |  |  | IntraMonth Hub Curve | IF-HEHUB
 |  |  |  | IntraMonth Month
 |  |  |  |  |  |  |  |  | Date Start |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  |  |  | 2002-01-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-07-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-11-01 00:00:00
 |  |  |  |  |  |  |  |  | Date End |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-06-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-09-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-03-01 00:00:00
 |  | WEST REGION BASIS NOTIONAL |  | Intra-Month | Basis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IntraMonth Match |  | Basis Match
 |  | NGI-PGE/CG |  | NGI-PGE/CG | GD-PG&E/CITIGAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | GDP-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | GDP-MALIN-CTYGA
 |  | NGI-SOCAL |  | NGI-SOCAL | GDP-CAL BORDER
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | GDP-ELPO/SANJUA
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | GDP-ELPO/PERM2
 |  | WAHA |  | IF-WAHA-TX | GDP-WAHA
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | GDP-NGPL/OK
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | GDP-KERN/OPAL
 |  | STANFIELD |  | NW-STANFIELD | GD-NW STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | GDP-NTHWST/CANB
 |  | AECO |  | CGPR-AECO/USIM | [NAME]
 |  | CIG |  | IF-CIG/RKYMTN | GDP-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | GDP-HEHUB | NG
Spreadsheet: 268736d1380758195-equation-which-searches-a-cell-for-pm-or-p-and-replaces-number-after-with-an-x-pmx
Sheet: Sheet1

Q-PM6-SI-AAAA |  |  |  |  |  |  | P1 | PX
Q-AAA-PM6-SI |  |  |  |  |  |  | P2 | PX
Q-AAA-BBB-PM6 |  |  |  |  |  |  | P3 | PX
or |  |  |  |  |  |  | P4 | PX
Q-P6-SI-AAAA |  |  |  |  |  |  | P5 | PX
Q-AAA-P6-SI |  |  |  |  |  |  | P6 | PX
Q-AAA-BBB-P6 |  |  |  |  |  |  | PM1 | PMX
wer-z-p7 |  |  |  |  |  |  | PM2 | PMX
Q-PM6-AAA |  |  |  |  |  |  | PM3 | PMX
Q-P6-AAA |  |  |  |  |  |  | PM4 | PMX
Q-PM8-AAA |  |  |  |  |  |  | PM5 | PMX
Q-PMT-AAA |  |  |  |  |  |  | PM6 | PMX
Q-PM7-AAA
Spreadsheet: 684164d1593180224-formula-to-consolidate-a-range-in-a-single-column-sample
Sheet: Data

 |  |  | Id | N
 |  |  | 1947 | 4
 |  |  | 5629 | 5
 |  |  | 14361 | 6
 |  |  | 14743 | 5
 |  |  | 17366 | 5
 |  |  | 18369 | 5
 |  |  | 25177 | 3
 |  |  | 26197 | 3
 |  |  | 29063 | 3
 |  |  | 29252 | 3
 |  |  | 31287 | 3
 |  |  | 32585 | 4
 |  |  | 33103 | 4
 |  |  | 33722 | 3
 |  |  | 33869 | 7
 |  |  | 34084 | 2
 |  |  | 34393 | 2
 |  |  | 35862 | 4
 |  |  | 37826 | 3
 |  |  | 39579 | 3
 |  |  | 40421 | 4
 |  |  | 42654 | 3
 |  |  | 45213 | 3
 |  |  | 45258 | 1
 |  |  | 48802 | 1
 |  |  | 49790 | 2
 |  |  | 51635 | 2
 |  |  | 54682 | 1
 |  |  | 55071 | 2
 |  |  | 56770 | 1
 |  |  | 57232 | 1
 |  |  | 57676 | 1
 |  |  | 57699 | 1
 |  |  | 57756 | 2
 |  |  | 58368 | 1
 |  |  | 58724 | 1
 |  |  | 58976 | 1
 |  |  | 60043 | 1
 |  |  | 60198 | 1
 |  |  | 60304 | 1
 |  |  | 60497 | 1
 |  |  | 60663 | 1
 |  |  | 62159 | 1
 |  |  | 62349 | 1
Spreadsheet: 437745d1451493171-help-with-sorting-adresses-copy-of-example-1
Sheet: Ark1

 | THE LIST AS I GET IT
 | Zip code | City | Street | Info #1 | Info #2 | Name | Phone number | Misc
 | 1234 | Oslo | Oslostreet 1 | Yes | No | [NAME] | 12345678 | Insert comments here
 | 5678 | Bergen | Bergenstreet 2 | No | Yes | [NAME] | 87654321 | Witty comment
 | 2468 | Hamar | Hamarstreet 3 | No | No | [NAME] | 24681012 | Not so witty comment
 | AFTER RUN IT THROUGH SOFTWARE TO ROUTE IT MOST EFFICIENTLY I GET A CSV FILE LIKE THIS
 | Hamarstreet 3, 2468, Hamar
 | Oslostreet 1, 1234, Oslo
 | Bergenstreet 2, 5678, Bergen
 | SO I THEN MANUALLY CUT AND PASTE THE CORRECT ORDER
 | Zip code | City | Street | Info #1 | Info #2 | Name | Phone number | Misc
 | This is all well and easy for 3 adresses, but I'm anywhere from 400-700 adresses I need to do this. Based on this information, can I make it automatically?
Spreadsheet: 801891d1666456018-retrieve-working-business-days-in-excel-sequence-working-days-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  | Holidays
 |  |  |  |  |  |  |  | 2022-10-06 00:00:00
 |  |  |  |  |  |  |  | 2022-10-17 00:00:00