tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862857d1710432608-dax-test-if-a-consecutive-series-of-cells-fulfill-a-certain-condition-week-violation-logic
Sheet: Abdelrahman

 |  | WK 01 | WK 02 | WK 03 | WK 04 | WK 05 | WK 06 | WK 07 | WK 08 | WK 09 | WK 10 | WK 11 | WK 12 | WK 13 | Count if
 | DIFC | 25 | 26 | 27 | 35 | 34 | 36 | 32 | 29 | 29 | 35 | 29 | 29 | 29
 | [NAME] | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
 | Violation yes/no
 | Cummlative
Spreadsheet: 44932d1243677070-excel-2007-match-a-name-on-one-worksheet-with-a-name-on-another-work-sheet-aimmarketstatistics2008-ver-2
Sheet: List of All Companies @ Jan08

All Companies on the London Stock Exchange |  |  |  | At | 2006-01-04 00:00:00
 |  | Number of Companies |  |  | Market Value (m) | Count of techMARK
 |  | 2 |  |  | 54.95437138625 | 0
List Date |  | Company | Listed | Group | Sector | Sub Sector | Country of Incorporation | Region (UK only) | Market | Ord Shares | Dep Receipts | Fixed Int | Warrants | Mkt Cap £m | techMARK
2003-12-15 00:00:00 |  | EP GLOBAL OPPORTUNITIES TRUST |  | 8985 | Equity Investment Instruments | Equity Investment Instruments | UK | Scotland | UK Main Market | YES | NO | NO | NO | 48.25693449
2006-01-04 00:00:00 |  | E-PAY ASIA LTD | 0 | 9535 | Software & Computer Services | Internet | Australia |  | AIM | YES | NO | NO | NO | 6.69743689625
Spreadsheet: 9ab9f6f3-5abe-4eb9-a512-96135757dd7e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-12-02 14:51:02.620000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.75 | 102.161 | 102.036 | 101.911 | 101.536
4.625 | 101.689 | 101.564 | 101.439 | 101.064 |  | Note: | Refer To Price [NAME]
4.5 | 100.782 | 100.657 | 100.532 | 100.157 |  |  | For all Price Adjs
4.375 | 99.821 | 99.696 | 99.571 | 98.946
4.25 | 99.064 | 98.939 | 98.814 | 98.189
4.125 | 98.248 | 98.123 | 97.998 | 97.373
4 | 97.243 | 97.118 | 96.993 | 96.368
3.875 | 96.192 | 96.067 | 95.942 | 95.317 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.142 | 102.017 | 101.892 | 101.517
3.75 | 101.588 | 101.463 | 101.338 | 100.963
3.625 | 101.169 | 101.044 | 100.919 | 100.544
3.5 | 100.641 | 100.516 | 100.391 | 100.016
3.375 | 99.886 | 99.761 | 99.636 | 99.011
3.25 | 99.158 | 99.033 | 98.908 | 98.283
3.125 | 98.11 | 97.985 | 97.86 | 97.235 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-12-16 14:51:02.620000
30 DAY | 2013-12-31 14:51:02.620000
45 DAY | 2014-01-15 14:51:02.620000
60 DAY | 2014-01-30 14:51:02.620000
90 DAY | 2014-03-01 14:51:02.620000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 780173d1652336399-search-a-column-for-a-string-in-an-array-and-return-value-corresponding-to-that-string-string-lookup-aligw
Sheet: Sheet1

Status: | AliGW
Rag: Red, because….
Rag:Green, moving along
Rag: Green On track
RAG: Not Started
I would like to search the above column for the string listed below on a different sheet, and display in a column on the first sheet, the value in column B
COLUMN A | COLUMN B
[NAME]: Green | G
[NAME]: Red | R
[NAME]: Amber | A
[NAME]:Green | G
[NAME]:Red | R
[NAME]:Amber | A
RAG: RED/AMBER/GREEN | NS
RAG:Not Started | NS
RAG: NOT STARTED | NS
RAG: Not Started | NS
So the result would be
Rag: Red, because…. R
Rag:Green, moving along G
Rag: Green On track G
RAG: Not Started NS
Spreadsheet: 57937d1258145710-checkbox-testdataentry
Sheet: FiberDataEntry

Confirnmed Reported problem?
1 | a
1 | a
1
1 | a
1 |  | Ok so, colum A I want a check box in each cell that when checked "TRUE" it updates the same cell with a 1 instead of the word True so that at the bottom I can add. Right now what it does is if you click on the box it will add a 1 for you. I found a thread on this forum and was able to do it that way, but I want to know If I could use a checkbox instead. Or any othr method adviced will be appreciated.
0
0
0
0
0
0
0
0
0
1
1
1
1
9 | 3
Spreadsheet: 753565d1635518057-setting-a-maximum-value-for-a-number-in-an-array-stdev-s-example
Sheet: GTG

Week | Year | player | player_id | team | Plays | Prior | YTD_Att | [NAME] | YTD_Grade | pGrade | g-1 | g-2 | g-3 | PT% | STDEV
11 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 41 | 500 | 259 | 9.63381997050317 | 10.63533111712753 | 10.34373642003781 | 1 |  | 1 | 1
12 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 47 | 500 | 294 | 9.63381997050317 | 10.38050254398205 | 10.1821067066245 | 1 | 1 |  | 1
17 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 0 | 500 | 422 | 9.63381997050317 | 10.25010923739696 | 10.12602748115677 | 1 |  | 1 | 1
6 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 43 | 500 | 105 | 9.63381997050317 | 10.6478546888715 | 10.13752015521859 | 1 | 0 |  | 0.5
13 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 49 | 500 | 336 | 9.63381997050317 | 10.24120042730179 | 10.09513933245795 | 1 | 1 | 1 | 1
14 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 27 | 500 | 368 | 9.63381997050317 | 10.19333983227701 | 10.06786444167469 | 1 | 1 | 1 | 1
9 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 0 | 500 | 211 | 9.63381997050317 | 10.26785219291734 | 10.05533217467836 | 1 | 1 | 0.9555555555555556 | 0.9851851851851853
10 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 55 | 500 | 211 | 9.63381997050317 | 10.26785219291734 | 10.05533217467836 |  | 1 | 1 | 1
15 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 0 | 500 | 392 | 9.63381997050317 | 10.04483495052555 | 9.957101220158751 | 1 | 1 | 1 | 1
16 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 37 | 500 | 392 | 9.63381997050317 | 10.04483495052555 | 9.957101220158751 |  | 1 | 1 | 1
8 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 41 | 500 | 180 | 9.63381997050317 | 10.13533442433063 | 9.949036335984621 | 1 | 0.9555555555555556 | 1 | 0.9851851851851853
7 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 56 | 500 | 144 | 9.63381997050317 | 10.17659175979573 | 9.945978321109225 | 0.9555555555555556 | 1 | 0 | 0.6518518518518519
2 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 39 | 500 | 40 | 9.63381997050317 | 10.78197568227173 | 9.947560194067833 | 1 |  |  | 1
3 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 0 | 500 | 67 | 9.63381997050317 | 10.28617330479702 | 9.885907422913442 | 0.7959183673469388 | 1 |  | 0.8979591836734694
4 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 0 | 500 | 67 | 9.63381997050317 | 10.28617330479702 | 9.885907422913442 |  | 0.7959183673469388 | 1 | 0.8979591836734694
5 | 2014 | Jameis Winston | 9434 | FLORIDA ST | 44 | 500 | 67 | 9.63381997050317 | 10.28617330479702 | 9.885907422913442 | 0 |  | 0.7959183673469388 | 0.3979591836734694
Spreadsheet: 853747d1703705440-need-help-on-a-formula-that-requires-a-lookup-and-sums-example
Sheet: Sheet1

Company | Agent | Agent name | PERIOD | AXE | SWORD | GUN | POLEARM | WHIP | LASER | KNUCKLE | HAMMER | TOTAL
A | 1 | ABE | 2023-10-31 00:00:00 | 60 | 44 | 25 | 96 | 95 | 81 | 33 | 82
B |  | [NAME] | 2023-10-31 00:00:00 | 58 | 47 | 99 | 40 | 52 | 59 | 79 | 96
A |  | COCO | 2023-10-31 00:00:00 | 89 | 37 | 51 | 35 | 53 | 63 | 57 | 30
A |  | DOE | 2023-10-31 00:00:00 | 60 | 99 | 86 | 85 | 71 | 95 | 66 | 43
C |  | [NAME] | 2023-10-31 00:00:00 | 49 | 72 | 60 | 70 | 44 | 43 | 29 | 62
A |  | FANNY | 2023-10-31 00:00:00 | 40 | 58 | 36 | 76 | 70 | 82 | 54 | 25
C |  | GEO | 2023-10-31 00:00:00 | 80 | 79 | 61 | 29 | 49 | 45 | 37 | 43
B |  | HAN | 2023-10-31 00:00:00 | 73 | 78 | 77 | 35 | 74 | 66 | 34 | 67
A |  | IAN | 2023-10-31 00:00:00 | 31 | 93 | 51 | 68 | 83 | 46 | 30 | 56
B |  | JEN | 2023-10-31 00:00:00 | 64 | 63 | 76 | 59 | 90 | 38 | 42 | 99
C |  | KIRK | 2023-10-31 00:00:00 | 86 | 44 | 98 | 48 | 67 | 53 | 78 | 30
A |  | LEN | 2023-10-31 00:00:00 | 88 | 77 | 96 | 99 | 25 | 98 | 78 | 91
C |  | MAN | 2023-10-31 00:00:00 | 86 | 35 | 49 | 97 | 94 | 81 | 79 | 30
A |  | NANY | 2023-10-31 00:00:00 | 50 | 67 | 41 | 97 | 65 | 51 | 29 | 54
EXPECTED RESULTS:
 | LASER | HAMMER
A
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 6Replace Costs-Results 11-15

Table 5.2.55.  Replacement Costs (Years 11 to 15)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15
 |  |  | Total Present Value of Replacement Costs (Years 11 to 15):
Spreadsheet: 862852d1710431563-help-with-stack-bar-gantt-gantt_mrshorty
Sheet: after6

 |  |  |  |  |  |  |  |  |  |  |  |  | added to sheet to help enter limits for axis.
 | Task | Start Date | Duration | End Date |  |  | Start Date | End date |  | add data for dummy series |  |  |  | primary horizontal axis limits
 | Task 1 | 2024-02-01 00:00:00 | 37 |  |  |  |  |  |  |  |  |  |  | min | [NAME]
 | Task 2 | 2024-02-09 00:00:00 | 379 |  |  |  |  |  |  | 2025-01-01 00:00:00 | 3 |  | serial number | 45323 | 45780
 | Task 3 | 2024-02-09 00:00:00 | 405 |  |  |  |  |  |  |  |  |  | date
 | Task 4 | 2024-07-10 00:00:00 | 268
 | Task 5 | 2024-07-10 00:00:00 | 16 |  |  | dummy series added to chart (green bar stacked on task 1)
 | Task 6 | 2024-12-09 00:00:00 | 16 |  |  | dummy series changed to line chart.
 | Task 7 | 2025-03-20 00:00:00 | 15 |  |  | secondary horizontal axis added (defaults to a single day).
 | Task 8 | 2025-04-04 00:00:00 | 7 |  |  | secondary horizontal axis formatted to use same limits as primary axis and to have 1 month divisions.
 |  |  |  |  |  | primary gridlines removed and secondary gridlines added.
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 23

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap transaction volumes, week ending November 16, by product type, participant type, and cleared status (in number of transactions), all tenors, currencies, and deliveries. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 683247d1592576733-formula-aggregate-and-rank-not-with-pivot-service-pilot
Sheet: Data

DATA
month | service | cost (EUR)
1 | car | 100
1 | car | 120
2 | car | 20
2 | car | 30
1 | train | 80
1 | train | 190
2 | train | 10
1 | bus | 10
2 | bus | 30
2 | bus | 20
RESULTS |  | <-- | I do ranking here manualy from pivot table (as mentioned, I would like to have formulas, and not pivot table as solution)
criteria for rank | service/month
top month | 1
top service | train
2nd top serice | car
top service in month 2 | bus |  | comment: car has the same RANK (both cost 50), and it would be nice to be able to set preference for lets say - bus (i.e. - we do the ranking, but if 'bus' is tight with some other service, then 'bus' is listed (THIS funcionality is not crucial for me)
Spreadsheet: 849092d1699634250-formula-to-return-the-header-with-first-positive-value-after-a-series-of-negative-vaules-test-data
Sheet: Test Data

 | Need formula to return the first positive value after negative values |  | 2023-11-11 00:00:00 | 2023-11-18 00:00:00 | 2023-11-25 00:00:00 | 2023-12-02 00:00:00 | 2023-12-09 00:00:00 | 2023-12-16 00:00:00 | 2023-12-23 00:00:00 | 2023-12-30 00:00:00 | 2024-01-06 00:00:00 | 2024-01-13 00:00:00 | 2024-01-20 00:00:00 | 2024-01-27 00:00:00 | 2024-02-03 00:00:00 | 2024-02-10 00:00:00 | 2024-02-17 00:00:00 | 2024-02-24 00:00:00 | 2024-03-02 00:00:00
Item ID | Return the weekending with positive value | Expected results | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH
Item A |  | 2023-12-02 00:00:00 | -500 | -600 | -700 | 3342 | 3072 | -2000 | 2531 | 2166 | 1801 | 1436 | 1071 | 701 | 330 | 1160 | 789 | 465 | 141
Item B |  | 2023-11-11 00:00:00 | 720 | 840 | 780 | 1188 | 756 | 642 | 489 | 362 | 234 | 106 | -22 | 385 | 263 | 142 | 20 | 547 | 450
Item C |  | 2023-12-23 00:00:00 | -500 | -600 | -700 | -800 | -1000 | -2000 | 2531 | 2166 | 1801 | 1436 | -500 | 701 | 330 | 1160 | 789 | 465 | 141
Spreadsheet: 861043d1709042907-excess-counting-logic-help-incentive-calculation
Sheet: Sheet1

Loans | Loans Conversion | Cards | Target | Total Achievement | Eligible for incentive? | Excess Loan |  | Excess Card | 0-10 | 11-15 | 16-20 | 21+
635500 |  | 10 | 8 |  |  |  |  |  |  |  |  |  | this the formula you gave me which needs some ammendment
Only "Cards" should be counting on slabs after the "Target" but based on the total "Achievement"
Examples:
Loans | Loans Conversion | Cards | Target | Total Achievement | Eligible for incentive? | Excess Loan |  | Excess Card | 0-10 | 11-15 | 16-20 | 21+
635500 |  | 10 | 8 |  |  |  |  |  |  |  |  |  | since total achievement is 22.71 and target is 8, I need to count the 10 cards after the 12.71 loans so 13th onwards as per slab
500000 |  | 4 | 6 |  |  |  |  |  |  |  |  |  | since total achievement is 14 and target is 6, I need to count the 4 cards as 11th,12th,13th,14th
250000 |  | 6 | 5
175000 |  | 2 | 7 |  |  |  |  |  |  |  |  |  | total achievement is less than target so all slabs should be zero
654987 |  | 9 | 11
789654 |  | 5 | 16
 |  |  |  |  |  |  |  |  | Desired
 |  |  |  |  |  |  |  |  | 0 | 3 | 5 | 2
 |  |  |  |  |  |  |  |  | 0 | 4 | 0 | 0
 |  |  |  |  |  |  |  |  | 5 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 2 | 5 | 2
 |  |  |  |  |  |  |  |  | 0 | 0 | 4.79 | 0
Spreadsheet: 201477d1356006125-reducing-balance-asset-get-back-to-purchase-date-reducing-bal-assets
Sheet: Sheet1

PLANT & EQUIPMENT
 | Original Cost | Reducing Balance Depreciation | NBV at year end | Currrent Date
Cabinet | 1257 | 0.225 | 76 | 2012-12-31 00:00:00
Water Pump | 40768 | 0.2 | 16421 | 2012-12-31 00:00:00
Work back to original purchase date of asset
 | Original Cost | Reducing [NAME] | NBV at year end | Date
Cabinet | 1257 |  |  | 2002-12-31 00:00:00
 |  |  |  | 2003-12-31 00:00:00
 |  |  |  | 2004-12-31 00:00:00
 |  |  |  | 2005-12-31 00:00:00
 |  |  |  | 2006-12-31 00:00:00
 |  |  |  | 2007-12-31 00:00:00
 |  |  |  | 2008-12-31 00:00:00
 |  |  |  | 2009-12-31 00:00:00
 |  |  |  | 2010-12-31 00:00:00
 |  |  |  | 2011-12-31 00:00:00
 |  |  |  | 2012-12-31 00:00:00
 | Original Cost | Reducing [NAME] | NBV at year end | Date
Water Pump |  |  |  | 2009-12-31 00:00:00
 |  |  |  | 2010-12-31 00:00:00
 |  |  |  | 2011-12-31 00:00:00
 |  |  |  | 2012-12-31 00:00:00
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: August

Date | Sales
2022-08-01 00:00:00 | 1
2022-08-02 00:00:00 | 1
2022-08-03 00:00:00 | 1
2022-08-04 00:00:00 | 1
2022-08-05 00:00:00 | 1
2022-08-06 00:00:00 | 1
2022-08-07 00:00:00 | 1
2022-08-08 00:00:00 | 1
2022-08-09 00:00:00 | 1
2022-08-10 00:00:00 | 1
2022-08-11 00:00:00 | 1
2022-08-12 00:00:00 | 1
2022-08-13 00:00:00 | 1
2022-08-14 00:00:00 | 1
2022-08-15 00:00:00 | 1
2022-08-16 00:00:00 | 1
2022-08-17 00:00:00 | 1
2022-08-18 00:00:00 | 1
2022-08-19 00:00:00 | 1
2022-08-20 00:00:00 | 1
2022-08-21 00:00:00 | 1
2022-08-22 00:00:00 | 1
2022-08-23 00:00:00 | 1
2022-08-24 00:00:00 | 1
2022-08-25 00:00:00 | 1
2022-08-26 00:00:00 | 1
2022-08-27 00:00:00 | 1
2022-08-28 00:00:00 | 1
2022-08-29 00:00:00 | 1
2022-08-30 00:00:00 | 1
2022-08-31 00:00:00 | 1
Spreadsheet: 176110d1345733914-simplified-way-of-displaying-data-for-training-and-information-house-clearance-log
Sheet: Data Output

Week | Inbound Calls | Viewings Booked | Clearances Booked | Clearances Completed
Week 1
Total Call Centre Lead Generations
Anne
[NAME]
Sue
[NAME]
Leanne
Spreadsheet: 267034d1379917433-vlookup-value-error-exce
Sheet: Cons

Sl.NO | Name | Gender | Service | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00
 |  |  | Service1
 |  |  | Service2
 |  |  | Service3
 |  | Here column D list has the range names
Spreadsheet: 131290d1322844561-excel-2007-sorting-by-array-copy-of-sample-two-sorts-by-array
Sheet: Main Sheet

Place | Name | Month | Dollar Amt
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
31
32
33
34
35
36
Spreadsheet: louise_kitchen__23042__AAearn by month
Sheet: Aug 00

E N R O N   N O R T H  A M E R I C A
August 2000
in Millions of $
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 | 2001-08-01 00:00:00 | 2001-08-02 00:00:00 | 2001-08-03 00:00:00 | 2001-08-04 00:00:00 | 2001-08-07 00:00:00 | 2001-08-08 00:00:00 | 2001-08-09 00:00:00 | 2001-08-10 00:00:00 | 2001-08-11 00:00:00 | 2001-08-14 00:00:00 | 2001-08-15 00:00:00 | 2001-08-16 00:00:00 | 2001-08-17 00:00:00 | 2001-08-18 00:00:00 | 2001-08-21 00:00:00 | 2001-08-22 00:00:00 | 2001-08-23 00:00:00 | 2001-08-24 00:00:00 | 2001-08-25 00:00:00 | 2001-08-28 00:00:00 | 2001-08-29 00:00:00 | 2001-08-30 00:00:00 | 2001-08-31 00:00:00 | Total
Margin
Gas Trading | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Power Trading | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Trading | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Originations/Office of the Chair/Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MPR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Margin
Schedule C
Gas | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Power | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Schedule C
Total Daily Margin
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: mk

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 218493d1362485635-searching-for-a-value-in-multiple-sheets-fame
Sheet: Consolidated

3.059 | 3.017 | 3.1 | TIC | 27581 | 0.31 | 12269 | 0.47 | 2.25 |  | RANI
3.554 | 3.533 | 3.57 | TIC | 4193 | 0.05 | 3532 | 0.14 | 1.19 |  | SURESH
3.707 | 3.653 | 3.75 | TIC | 56270 | 0.64 | 26225 | 1.01 | 2.15 |  | KUMAR
3.753 | 3.75 | 3.773 | TIC | 1924 | 0.02 | 2576 | 0.1 | 0.75 | V | RAVI
3.054 | 3.027 | 3.11 | TIC | 32725 | 0.66 | 16333 | 0.98 | 2 |  | [NAME]
3.193 | 3.16 | 3.227 | TIC | 10302 | 0.21 | 4624 | 0.28 | 2.23 |  | RAJU
3.26 | 3.237 | 3.28 | TIC | 5036 | 0.1 | 2811 | 0.17 | 1.79 |  | KUMARI
3.703 | 3.663 | 3.753 | TIC | 60364 | 1.21 | 28826 | 1.72 | 2.09 |  | SRINU
3.01 | 3.003 | 3.027 | TIC | 2200 | 0.02 | 1344 | 0.04 | 1.64 |  | RAVI
3.06 | 3.027 | 3.09 | TIC | 21333 | 0.22 | 10042 | 0.3 | 2.12 | V | RAJU
3.354 | 3.343 | 3.377 | TIC | 2908 | 0.03 | 3659 | 0.11 | 0.79 |  | RAMU
3.607 | 3.587 | 3.67 | TIC | 8897 | 0.09 | 3049 | 0.09 | 2.92 |  | KRISHNA
Spreadsheet: 700269d1603107083-total-of-quantities-for-unique-parts-that-repeat-at-random-totals-where-unique
Sheet: Sheet1

Part | Qty |  | Totals |  |  | What I would like to be output | Part | qty |  | Part | Sum of Qty
e | 6 |  |  |  |  | Unique parts (ignore case) |  | 142 |  | a | 142
f | 25 |  |  |  |  | and the corresponding | b | 27 |  | b | 27
a | 21 |  |  |  |  | total quantities of each | c | 94 |  | c | 94
e | 22 |  |  |  |  |  | d | 7 |  | d | 7
a | 21 |  |  |  |  |  | e | 36 |  | e | 36
f | 11 |  |  |  |  |  | f | 59 |  | f | 59
f | 15 |  |  |  |  |  |  |  |  | Grand Total | 365
c | 13
b | 3
c | 23
f | 8 |  |  |  |  |  | Ignore that
a | 15
c | 21
b | 17
e | 8
b | 7
c | 9
a | 9
c | 22
a | 20
A | 17
a | 8
A | 4
d | 7
a | 4
A | 23
c | 6
Spreadsheet: 772481d1647297854-extract-text-and-lookup-description-from-another-table-budget-sample
Sheet: Actuals

FY Beginning Date
Actual
Account | Description | Fund | Desired Result
Account | Description | 2019-2021 | 2019-2022
100.0000.5400.000.000 | Beginning Fund Balance |  | General Fund |  |  |  | Current Funds
202.0000.5400.000.000 | Beginning Fund Balance |  |  |  |  |  | Code | Code Description
203.0000.5400.000.000 | Beginning Fund Balance |  |  |  |  |  | 100 | General Fund
204.0000.5400.000.000 | Beginning Fund Balance |  |  |  |  |  | 201 | Food Service Program
205.0000.5400.000.000 | Beginning Fund Balance |  |  |  |  |  | 202 | Title I
206.0000.5400.000.000 | Beginning Fund Balance |  |  |  |  |  | 203 | REAP Flex
210.0000.5400.000.000 | Beginning Fund Balance |  |  |  |  |  | 204 | Small Rural School Achievement
 |  |  |  |  |  |  | 205 | IDEA
 |  |  |  |  |  |  | 206 | CARES Act
 |  |  |  |  |  |  | 207 | CDL
 |  |  |  |  |  |  | 208 | ESSER II
 |  |  |  |  |  |  | 209 | High School Success
 |  |  |  |  |  |  | 210 | Title IV
 |  |  |  |  |  |  | 211 | Building Reserve Fund
 |  |  |  |  |  |  | 212 | TAP Assessments
 |  |  |  |  |  |  | 213 | Title II, IV, SRSA
 |  |  |  |  |  |  | 251 | Student Investment Account
 |  |  |  |  |  |  | 252 | High School Success (M98)
 |  |  |  |  |  |  | 253 | Rental
 |  |  |  |  |  |  | 254 | Preschool
 |  |  |  |  |  |  | 255 | Outdoor School
 |  |  |  |  |  |  | 260 | Seismic Grant
 |  |  |  |  |  |  | 290 | Student Body Fund
 |  |  |  |  |  |  | 299 | Lunch Fund
 |  |  |  |  |  |  | 301 | PERS UAL  Bond
 |  |  |  |  |  |  | 402 | UNDESIGNATED
 |  |  |  |  |  |  | 701 | Scholarship