tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848962d1699549250-lookup-and-find-the-in-between-days-and-return-number-of-days-20231109
Sheet: Sheet2

Number | Date From | Date To | Number Of Days
30114 | 2021-09-02 00:00:00 | 2021-09-16 00:00:00
30114 | 2021-12-06 00:00:00 | 2021-12-12 00:00:00
30114 | 2022-01-10 00:00:00 | 2022-01-31 00:00:00
30114 | 2022-02-01 00:00:00 | 2022-02-13 00:00:00
30114 | 2022-04-25 00:00:00 | 2022-04-25 00:00:00
30153 | 2021-06-12 00:00:00 | 2021-06-30 00:00:00
30153 | 2021-07-01 00:00:00 | 2021-07-05 00:00:00
30153 | 2021-07-10 00:00:00 | 2021-07-31 00:00:00
30153 | 2021-08-01 00:00:00 | 2021-08-08 00:00:00
30153 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00
30153 | 2023-05-01 00:00:00 | 2023-05-31 00:00:00
30153 | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
30159 | 2021-08-23 00:00:00 | 2021-08-31 00:00:00
30159 | 2021-09-01 00:00:00 | 2021-09-16 00:00:00
30159 | 2022-01-17 00:00:00 | 2022-01-31 00:00:00
30159 | 2022-02-12 00:00:00 | 2022-02-19 00:00:00
30159 | 2022-02-20 00:00:00 | 2022-02-20 00:00:00
30159 | 2022-02-23 00:00:00 | 2022-02-28 00:00:00
30159 | 2022-03-01 00:00:00 | 2022-03-06 00:00:00
30165 | 2021-07-26 00:00:00 | 2021-07-31 00:00:00
30165 | 2021-09-18 00:00:00 | 2021-09-18 00:00:00
30165 | 2021-11-20 00:00:00 | 2021-11-25 00:00:00
30165 | 2021-11-26 00:00:00 | 2021-11-30 00:00:00
30165 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
30165 | 2021-12-13 00:00:00 | 2021-12-13 00:00:00
30165 | 2022-03-19 00:00:00 | 2022-03-31 00:00:00
30165 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
30165 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00
30165 | 2022-06-06 00:00:00 | 2022-06-30 00:00:00
30165 | 2022-07-01 00:00:00 | 2022-07-31 00:00:00
30675 | 2021-08-19 00:00:00 | 2021-08-22 00:00:00
30675 | 2021-09-27 00:00:00 | 2021-09-30 00:00:00
30675 | 2021-10-01 00:00:00 | 2021-10-11 00:00:00
30675 | 2021-10-18 00:00:00 | 2021-10-24 00:00:00
30675 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00
30675 | 2022-04-04 00:00:00 | 2022-04-17 00:00:00
30675 | 2022-05-30 00:00:00 | 2022-05-31 00:00:00
30675 | 2022-06-01 00:00:00 | 2022-06-12 00:00:00
Spreadsheet: mary_fischer__25641__111
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 848330d1699041577-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left-example-for-forum-3-nov-2023
Sheet: Forum

Some examples for strings that occur in the big data sheet (80 columns; 900 rows) |  |  |  | Two attemps from myself (but not succesful yet)
Attempt 1
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
Attempt 2
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2 |  |  |  |  |  | How can I adapt the formula to only exclude strings that start with "Method", "A method", "The Method"?
Spreadsheet: 692700d1598512636-formulas-to-replenish-stock-inventory-rolling-ballances
Sheet: Sheet1

Component |  |  | S&OP DEMAND |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Months Stock | 1.75 | Closing Stock Balance |  |  |  |  |  |  |  |  |  |  |  |  | Replenishment Plan |  |  |  |  |  |  |  |  |  |  |  | Opening Balance |  |  |  |  |  |  |  |  |  |  |  | Supplier OTIF on Product
SAP SKU | GENERIC | Cost £ | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-03 00:00:00 | 2020-04-03 00:00:00 | 2020-05-04 00:00:00 | 2020-06-04 00:00:00 | 2020-07-05 00:00:00 | 2020-08-05 00:00:00 | 2020-09-05 00:00:00 | 2020-10-06 00:00:00 | 2020-11-06 00:00:00 | 2020-12-07 00:00:00 | 2021-01-07 00:00:00 | TOTAL | Spoilage | Split | Ave Month | Safety | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-03 00:00:00 | 2020-04-03 00:00:00 | 2020-05-04 00:00:00 | 2020-06-04 00:00:00 | 2020-07-05 00:00:00 | 2020-08-05 00:00:00 | 2020-09-05 00:00:00 | 2020-10-06 00:00:00 | 2020-11-06 00:00:00 | 2020-12-07 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-03 00:00:00 | 2020-04-03 00:00:00 | 2020-05-04 00:00:00 | 2020-06-04 00:00:00 | 2020-07-05 00:00:00 | 2020-08-05 00:00:00 | 2020-09-05 00:00:00 | 2020-10-06 00:00:00 | 2020-11-06 00:00:00 | 2020-12-07 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-03 00:00:00 | 2020-04-03 00:00:00 | 2020-05-04 00:00:00 | 2020-06-04 00:00:00 | 2020-07-05 00:00:00 | 2020-08-05 00:00:00 | 2020-09-05 00:00:00 | 2020-10-06 00:00:00 | 2020-11-06 00:00:00 | 2020-12-07 00:00:00 | 1 |  | Safety uplift | New Safety Stock
48007956 | 49300396 | 1.39 | 78 | 72.8 | 55.12 | 52 | 46.8 | 60.32000000000001 | 57.2 | 52 | 60.32000000000001 | 41.6 | 41.6 | 35.36000000000001 | 78 |  | 1.04 | 0.1 |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
48003677 | 49300596 | 1.25 | 702 | 655.2 | 496.08 | 468 | 421.2 | 542.8800000000001 | 514.8000000000001 | 468 | 542.8800000000001 | 374.4 | 374.4 | 318.24 | 702 |  | 1.04 | 0.9 |  |  | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
Spreadsheet: b102dd1e-6ec8-4148-856e-50dd9e37a68d
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Water Resources Investigations - Blue River Basin
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2006-07 |  |  | FY 2007-08
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2006-07 |  |  | FY 2007-08
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  |  | No |  | X | Yes
 | (If yes, please detail the purpose and source for that mandate).
 | This project is a result of a federal and state combined sewer policy.
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 121533d1316120812-pivot-table-excel-2007-normalizingdata2
Sheet: Sheet9

Count of Time | Day of Week
Time | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Grand Total
08:40:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
08:45:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
08:46:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
17:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
17:15:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
18:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
Grand Total | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 42
LAST STEP, Start with Original [NAME] and work this way.
Spreadsheet: 98bd0f86-280f-4c86-b835-4d6648013c40
Sheet: Sheet1

Table S5. Jaspar motif enrichment in the set of a-DMR genes. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
TF_NAME | MATRIX_ID | Z_SCORE | P_VALUE | SAMPLE_AVERAGE | BACKGROUND_AVERAGE | SAMPLE_DEVSTD | SAMPLE_SIZE
SP1 | MA0079.2 | 9.6855 | 1.11183e-22 | 0.949558 | 0.923577 | 0.0404751 | 435
TFAP2A | MA0003.1 | 9.54613 | 4.99319e-22 | 0.968956 | 0.947571 | 0.0280653 | 435
Egr1 | MA0162.1 | 8.22214 | 6.81094e-17 | 0.87678 | 0.85586 | 0.0418158 | 435
Zfx | MA0146.1 | 6.59347 | 1.70281e-11 | 0.879567 | 0.859545 | 0.0482737 | 435
E2F1 | MA0024.1 | 6.26857 | 1.39484e-10 | 0.849159 | 0.831963 | 0.0490696 | 435
PLAG1 | MA0163.1 | 6.26057 | 1.52658e-10 | 0.818691 | 0.803403 | 0.0404528 | 435
NFKB1 | MA0105.1 | 6.06243 | 5.19899e-10 | 0.830566 | 0.814351 | 0.0482242 | 435
Klf4 | MA0039.2 | 5.83911 | 2.20593e-09 | 0.926211 | 0.907702 | 0.0490424 | 435
MZF1_1-4 | MA0056.1 | 5.61167 | 8.82522e-09 | 0.981578 | 0.970947 | 0.0260597 | 435
Pax5 | MA0014.1 | 5.08293 | 1.51042e-07 | 0.844135 | 0.836862 | 0.0276239 | 435
[NAME] | MA0259.1 | 4.79477 | 6.88329e-07 | 0.907049 | 0.893396 | 0.0524023 | 435
NHLH1 | MA0048.1 | 4.68737 | 1.14637e-06 | 0.83569 | 0.824365 | 0.0480336 | 435
Mycn | MA0104.2 | 4.53935 | 2.40794e-06 | 0.851706 | 0.839892 | 0.049008 | 435
MZF1_5-13 | MA0057.1 | 4.50614 | 2.76271e-06 | 0.919586 | 0.911364 | 0.0366414 | 435
INSM1 | MA0155.1 | 4.45267 | 3.65771e-06 | 0.867102 | 0.858146 | 0.0372746 | 435
Arnt::Ahr | MA0006.1 | 4.09324 | 1.83981e-05 | 0.928338 | 0.915559 | 0.0620456 | 435
Myc | MA0147.1 | 4.08712 | 1.91288e-05 | 0.852182 | 0.842614 | 0.0445513 | 435
Tcfcp2l1 | MA0145.1 | 4.0086 | 2.64629e-05 | 0.844943 | 0.837299 | 0.0384271 | 435
CTCF | MA0139.1 | 3.7597 | 7.75479e-05 | 0.788707 | 0.780845 | 0.0360296 | 435
MIZF | MA0131.1 | 3.6942 | 9.83987e-05 | 0.819804 | 0.811694 | 0.0426722 | 435
REST | MA0138.2 | 3.38118 | 0.000316105 | 0.697133 | 0.690686 | 0.0432963 | 435
NF-kappaB | MA0061.1 | 3.06576 | 0.00100579 | 0.84998 | 0.842332 | 0.0472543 | 435
Myf | MA0055.1 | 2.7434 | 0.00284289 | 0.863459 | 0.857157 | 0.0451782 | 435
EWSR1-FLI1 | MA0149.1 | 2.62045 | 0.00408084 | 0.696549 | 0.689573 | 0.0569279 | 435
EBF1 | MA0154.1 | 2.03741 | 0.0199402 | 0.882466 | 0.877975 | 0.0449755 | 435
Mafb | MA0117.1 | 1.90069 | 0.0277292 | 0.925679 | 0.922403 | 0.0331797 | 435
ESR1 | MA0112.2 | 1.89483 | 0.0281374 | 0.73457 | 0.730957 | 0.0361194 | 435
Zfp423 | MA0116.1 | 1.66873 | 0.0461221 | 0.830852 | 0.827379 | 0.043269 | 435
Spreadsheet: 87886d1287749289-excel-2007-automatically-ordering-function-solved-by-donkey-d-example
Sheet: Sheet1

 | Period: | 2010-07-01 00:00:00 |  |  | Incoming:
VTUK Internal Code | Stock Item Description | Qty Remaining In Stock | Usage | No. Of Working Days | Number of Working Days Supply | [NAME]
1603 | Material 1 | 0 | 20 | 82 | 0 |  |  | =IF(ISNA(IF($f3<20,CEILING(D3/(E3/5)*3,50),"0")),0,IF($C3<50&$E3>5,50,""))
1604 | Material 2 | 400 | 20 | 82 | 1640
1605 | Material 3 | 0 | 100 | 82 | 0
1606 | Material 4 | 43 | 650 | 82 | 5.424615384615385
1607 | Material 5 | 360 | 600 | 82 | 49.2
1608 | Material 6 | 0 | 200 | 82 | 0
1609 | Material 7 | 0 | 0 | 82
1610 | Material 8 | 3 | 4562 | 82 | 0.05392371766768961
1611 | Material 9 | 574 | 0 | 82
1612 | Material 10 | 159 | 1154 | 82 | 11.29809358752166
1613 | Material 11 | 177 | 0 | 82
1614 | Material 12 | 70 | 0 | 82
1615 | Material 13 | 30 | 0 | 82
Spreadsheet: kate_symes__19011__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 | 2001-03-18 00:00:00 |  | 370 | 0 | 330 | 0 | 140.35 | 285 | 146.22 | 1255 |  | 343.75 | 22080
 | 2001-03-17 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 400 | 50 | 215.18 | 140
 | 2001-03-16 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 325 | 415 | 188.89 | 405
 | 2001-03-15 00:00:00 |  | 216.73 | 20560 | 174.7 | 10144 | 237.58 | 642 | 186.25 | 260
 | 2001-03-14 00:00:00 |  | 211.45 | 25360 | 172.67 | 8512 | 225.87 | 1552 | 157.5 | 480
 | 2001-03-13 00:00:00 |  | 211.79 | 20960 | 168.03 | 9088 | 235.45 | 33 | 150.36 | 445
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632 | 223.3 | 996 | 176.32 | 106
 | 2001-03-11 00:00:00 |  | 265 | 0 | 230 | 200 | 219.32 | 111 | 174.9 | 264 |  | 255.41 | 23256
 | 2001-03-10 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 247.11 | 873 | 227.78 | 709
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 277.5 | 52 | 230.19 | 982
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 |  |  |  |  |  | ..
Spreadsheet: 167277d1341940880-creating-buckets-based-on-lookup-table-bucket-list
Sheet: Sheet1

Title | Rate | Bucket? |  |  |  |  | Buckets | (lookup table)
Director | 275.4285714285714 | 3 |  |  |  |  |  | from: | to:
Sr Director | 340.6666666666667 | lookup in table ====> |  |  |  |  | >300 | 300 |  | 4
Sr Manager | 275.4166666666667 |  |  |  |  |  | 250-299 | 250 | 299 | 3
Manager | 183.3706666666667 |  |  |  |  |  | 200-249 | 200 | 249 | 2
Associate | 223.232 |  |  |  |  |  | <200 | 0 | 200 | 1
[NAME] | 107.7142857142857
Sr Manager | 361.6666666666667
Sr Manager | 292.4
Manager | 275.056
Associate | 334.848
Associate | 161.5714285714286
[NAME] | 542.5
Director | 438.6
Sr Director | 412.5839999999999
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Gas Settlemnt

 | Gas Settlement
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  |  | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  |  | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 20 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 0 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 58872d1259158418-daily-repetitive-import-and-sort-macro-lookup-or-am-i-totally-on-the-wrong-track-book1
Sheet: Variables

 |  | INPUT |  | tue | wed | thu | fri | sat | [NAME]
 | DAY
 | DATE |  | IMPORT | IMPORT | IMPORT | IMPORT | IMPORT | IMPORT | IMPORT
 | CALENDAR WORKING DAYS
INVENTORY |  | INVENTORY | FCAST | FCAST | FCAST | FCAST | FCAST | FCAST | FCAST
SKU NUMBER | SKU NAME
Spreadsheet: 679587d1590510576-worksheet-formula-to-count-repeating-sequence-pattern-in-cells-of-column-list-testing-counting-patterns-in-a-column
Sheet: Testing Mixed Formulas

 | Text Set 3 Overlapping | Correct Answer = |  |  |  |  |  |  | 4 | 3 | 5 | 4 | 3 | 5
1 | Data List |  |  | Number Sequence 1 | Text Sequence 1 | Number Sequence 2 Repeting numbers | Text Sequence 2 Repeating text |  | Number Set 1 | Number Set 2 | Number Set 3 Overlapping | Text Set 1 | Text Set 2 | Text Set 3 Overlapping
2 |  |  |  | 3 | Z | 4 | T |  | 3 | 4 | 4 | Z | T | T |  | 3 | Z | 4 | T
3 |  |  |  | 5 | A | 9 | G |  | 5 | 3 | 9 | A | Z | G |  | 5 | A | 9 | G
4 |  |  |  | 2 | C | 2 | L |  | 2 | 5 | 2 | C | A | L |  | 2 | C | 2 | L
5 |  |  |  | 6 | B | 6 | M |  | 6 | 2 | 6 | B | C | M |  | 6 | B | 6 | M
6 |  |  |  | 9 | E | 3 | S |  | 9 | 6 | 3 | E | B | S |  | 9 | E | 3 | S
7 |  |  |  | 8 | F | 4 | T |  | 8 | 9 | 4 | F | E | T |  | 8 | F | 4 | T
8 |  |  |  | 5 | G | 9 | G |  | 5 | 8 | 9 | G | F | G |  | 5 | G | 9 | G
9 |  |  |  |  |  |  |  |  | 3 | 5 | 2 | Z | G | L
10 |  |  |  |  |  |  |  |  | 5 | 2 | 6 | A | C | M |  |  |  | 1 | K
11 |  |  |  |  |  |  |  |  | 2 | 3 | 3 | C | Z | S |  |  |  | 5 | Z
12 |  | The following formulas work with both numbers and text: |  |  |  |  |  |  | 6 | 5 | 4 | B | A | T
13 |  |  |  |  |  |  |  |  | 9 | 2 | 9 | E | C | G
14 |  |  |  |  |  |  |  |  | 8 | 6 | 1 | F | B | K
15 |  |  |  |  |  |  |  |  | 5 | 9 | 4 | G | E | T
16 |  |  |  |  |  |  |  |  | 5 | 8 | 9 | 5 | F | G
17 |  |  |  |  |  |  |  |  | 4 | 5 | 2 | 4 | G | L
18 |  |  |  |  |  |  |  |  | 3 | 9 | 6 | Z | E | M
19 |  |  |  |  |  |  |  |  | 5 | 9 | 3 | A | E | S
20 |  |  |  |  |  |  |  |  | 2 | 1 | 4 | C | L | T
21 |  |  |  |  |  |  |  |  | 6 | 6 | 9 | B | B | G
22 |  |  |  |  |  |  |  |  | 9 | 9 | 5 | E | E | Z
23 |  |  |  |  |  |  |  |  | 8 | 7 | 4 | F | 7 | T
24 |  |  |  |  |  |  |  |  | 5 | 5 | 9 | G | 5 | G
25 |  |  |  |  |  |  |  |  | 9 | 4 | 2 | 9 | 4 | L
26 |  |  |  |  |  |  |  |  | 1 | 6 | 6 | 1 | 6 | M
27 |  |  |  |  |  |  |  |  | 6 | 7 | 3 | 6 | 7 | S
28 |  |  |  |  |  |  |  |  | 9 | 3 | 4 | 9 | Z | T
29 |  |  |  |  |  |  |  |  | 7 | 5 | 9 | 7 | A | G
30 |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 2 | C | S
31 |  |  |  |  |  |  |  |  | 3 | 6 | 4 | Z | B | T
32 |  |  |  |  |  |  |  |  | 5 | 9 | 9 | A | E | G
33 |  |  |  |  |  |  |  |  | 2 | 8 | 2 | C | F | L
34 |  |  |  |  |  |  |  |  | 6 | 5 | 6 | B | G | M
35 |  |  |  |  |  |  |  |  | 9 | 6 | 3 | E | B | S
36 |  |  |  |  |  |  |  |  | 8 | 9 | 4 | F | E | T
37 |  |  |  |  |  |  |  |  | 5 | 7 | 9 | G | Z | G
Spreadsheet: 852655d1702610577-excel-formula-to-separate-name-in-two-columns-separating-names-1-
Sheet: Tax schedule

KINDLY ASKING FOR EXCEL FORMULA TO SEPARATE NAME INTO SURNAME AND FIRST NAME IN TWO COLUMNS AND MATCH THE I.D NUMBR, FISCAL YEAR AND DATE OF BIRTH
USE INFORMATION IN EMPLOYEES SHEEET
Surname | First Name | I.D | Fiscal Year | Date of Birth
Smith | [NAME] | 08-965660 G73 | 2023 | 01/04/2021
[NAME] | [NAME] | 79-2013160 T79 | 2023 | 08/02/2023
Johns | Cain | 08-2101012 E39 | 2023 | 01/04/2021
 | [NAME] | 08-965660 G73 | 2023 | [NAME]
[NAME] | [NAME] | 79-2013160 T79 | 2023 | 03/03/2003
Johns | Cain | 08-2101012 E39 | 2023 | 10/06/2003