tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855864d1705337437-list-by-highest-including-joint-highest-ranking
Sheet: Sheet1

Team | Rank | Name | Dec | Best | Cost
101 | 3 | [NAME] | 105 | 105 | 2.2
101 | 1 | [NAME] | 100 | 110 | 1.7
101 | 4 | [NAME] | 96 | 96 | 6.5
101 | 1 | [NAME] | 92 | 109 | 3.3
102 | 1 | Vicky | 109 | 109 | 1.8
102 | 3 | [NAME] | 109 | 109 | 5
102 | 2 | [NAME] | 107 | 107 | 1.5
102 | 4 | Ian | 106 | 108 | 6
103 | 1 | [NAME] | 90 | 95 | 1.75
103 | 2 | [NAME] | 89 | 89 | 2.3
103 | 4 | [NAME] | 80 | 86 | 2.2
103 | 3 | [NAME] | 78 | 78 | 4
104 | 1 | [NAME] | 116 | 116 | 1.8
104 | 2 | Moh | 114 | 114 | 1.5
104 | 4 | [NAME] | 114 | 121 | 3
104 | 3 | Asif | 110 | 110 | 4
105 | 4 | [NAME] | 123 | 123 | 2.5
105 | 3 | Berti | 106 | 106 | 4
105 | 1 | Chess | 104 | 104 | 2
105 | 2 | Gaby | 75 | 75 | 6.6
106 | 1 | [NAME] | 121 | 121 | 1.4
106 | 2 | Asha | 121 | 122 | 2
106 | 3 | Greta | 111 | 111 | 2.4
106 | 4 | Simone | 110 | 110 | 3
Spreadsheet: 147478d1332814267-organizing-lists-organizing-problem-1
Sheet: Sheet1

1 | op | aal | 5 |  | The yellow values are the input list
1 | de | [NAME] | 235
1 | op | [NAME] | 1
2 | op | ew | 253
2 | de | ui | 76 |  |  |  |  |  | The blue output displays the two rows of information from the yellow array, organized using the green array.
2 | va | [NAME] | 2 |  |  |  |  |  | It is important that the blue values are in the same manner organized as the yellow i.e. the first values in the yellow list for "we" are "8 and te" etc.
3 | va | vl | 6
3 | we | te | 9
3 | we | te | 8
3 | we | dw | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | de | [NAME] | 235
 | op |  |  |  |  |  |  |  | op | aal | 5 |  |  |  | 1 | op | [NAME] | 1
 | we |  |  |  |  |  |  |  | we | te | 9 |  |  |  | 2 | op | ew | 253
 | we |  |  |  |  |  |  |  | we | te | 8 |  |  |  | 2 | de | ui | 76
 | we |  |  |  |  |  |  |  | we | dw | 4 |  |  |  | 3 | va | vl | 6
 | va |  |  |  |  |  |  |  | va | [NAME] | 2
 | The green names determine which yellow values are outputted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The red is the final output, describing the input list, minus the names used in the green list.
Spreadsheet: john_griffith__15791__10_19_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 60 | 250 | 350 | 37.7 | 52.8 | 1.71 | 2001-10-19 14:35:00
 | [NAME] | 60 | 700 | 750 | 44.9 | 48.1 | 1.75 | 2001-10-19 14:35:00
 | HU F2 | 60 | 900 | 1000 | 43.9 | 48.8 | 1.75 | 2001-10-19 14:35:00
 | HU G2 | 61 | 1075 | 1175 | 42.5 | 46.5 | 1.71 | 2001-10-19 14:35:00
 | [NAME] | 61 | 1175 | 1275 | 41.3 | 44.8 | 1.65 | 2001-10-19 14:35:00
 | [NAME] | 67 | 1350 | 1475 | 39.3 | 42.9 | 1.73 | 2001-10-19 14:35:00
 | [NAME] | 67 | 1475 | 1550 | 39.4 | 41.4 | 1.7 | 2001-10-19 14:35:00
 | [NAME] | 68 | 1425 | 1600 | 34.7 | 39 | 1.58 | 2001-10-19 14:35:00
 | HU N2 | 67 | 1400 | 1600 | 32.7 | 37.4 | 1.48 | 2001-10-19 14:35:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 831627d1685783169-i-want-to-use-a-modified-version-of-index-match-function-in-excel-book1
Sheet: Sheet1

Up miRNA | Down genes |  | TF | Target | Relationship
hsa-miR-34a | GRM7 |  | AATF | BAX | Repression
hsa-miR-21 | BCL2 |  | AATF | CDKN1A | Unknown
hsa-miR-15a | BCL2 |  | AATF | [NAME] | Unknown
hsa-miR-21 | SOX5 |  | AATF | MYC | Activation
hsa-miR-222 | KIT |  | AATF | TP53 | Unknown
hsa-miR-221 | KIT |  | [NAME] | BAX | Activation
hsa-miR-34a | BCL2 |  | [NAME] | BCL2 | Repression
hsa-miR-424 | ITPR1 |  | [NAME] | BCL6 | Repression
hsa-miR-224 | FOSB |  | [NAME] | CCND2 | Activation
hsa-miR-181d | BCL2 |  | [NAME] | CDKN1A | Activation
hsa-miR-181c | BCL2 |  | [NAME] | CSF1 | Activation
hsa-miR-372 | ERBB4 |  | [NAME] | CSF1 | Unknown
hsa-miR-200b | WASF3 |  | [NAME] | FOXO3 | Activation
Spreadsheet: 192387d1352393351-help-with-some-sort-of-vlookup-book1
Sheet: Sheet1

customer part no. | product no. | formula |  |  | 77921381A | ID found
011 786.3 | 77921381A |  |  |  | 77932541A | ID found
CV CUTTING GENERAL | 11001
[NAME] TUBE CUT | 11022 |  |  | from here to hear I also want to say ID found
CV CRIMPING AREA | 11033
CV PRE-ASSEMBLY AREA | 11051
[NAME] CLAAS | 21005
CV PACKING AREA | 99001
Standard Time
013 113.0 | 77902531A |  | <- here is not found so it's ok as N/A
CV CUTTING GENERAL | 11001
CLOSED CONVOLUTE TUB | 11023
[NAME] CLAAS | 21005
CV TEST AREA | 90001
CV PACKING AREA | 99001
Standard Time
013 224.2 | 77932541A
CV CUTTING GENERAL | 11001 |  |  | from here to hear I also want to say ID found
CV TUBE CUT TO 6,5 M | 11020
[NAME] CLAAS | 21005
CV TEST AREA | 90001
CV PACKING AREA | 99001
Standard Time
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 18

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, October 31 monthly snapshot, by product, participant type, and cleared status (millions of USD).
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 participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****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: 61811d1262728592-nested-ifs-sched-with-omm
Sheet: Friday

 | One Minute Meeting
 | Date:
 | Yest.Goal | Yest Act. |  | $ +/- | TODAY'S GOAL | ASH | ADT Goal | UPT Goal
 | $ | $ |  | $ | 0 | $ | $
 | WTD Goal | WTD Act. |  | $ +/- |  |  | ADT WTD | UPT WTD
 | $ | $ |  | $ |  |  | $
 | MTD [NAME] | MTD Act. |  | $ +/- |  |  | ADT MTD | UPT MTD
 | $ | $ |  | $ |  |  | $
 | Merchandise Message
 | Today's Schedule
 | Employees Scheduled |  |  | 0
 | Name/Initals | Shift Start | Shift End | Sales Goal | Sales Actual | % to Goal | ADT | UPT | SOCKS
1 |  |  |  | $ | $ | % | $
2 |  |  |  | $ | $ | % | $
3 |  |  |  | $ | $ | % | $
4 |  |  |  | $ | $ | % | $
5 |  |  |  | $ | $ | % | $
6 |  |  |  | $ | $ | % | $
7 |  |  |  | $ | $ | % | $
8 |  |  |  | $ | $ | % | $
9 |  |  |  | $ | $ | % | $
10 |  |  |  | $ | $ | % | $
 | [NAME]
 | Hour | % By Hour |  | Target Sales | Actual Sales | UPT | ADT | ASH
 | 11:00:00 | 0.1 |  | 0 | $ |  | $ | $
 | 12:00:00 | 0.2 |  | 0 | $ |  | $ | $
 | 13:00:00 | 0.3 |  | 0 | $ |  | $ | $
 | 14:00:00 | 0.4 |  | 0 | $ |  | $ | $
 | 15:00:00 | 0.5 |  | 0 | $ |  | $ | $
 | 16:00:00 | 0.6 |  | 0 | $ |  | $ | $
 | 17:00:00 | 0.7 |  | 0 | $ |  | $ | $
 | 18:00:00 | 0.8 |  | 0 | $ |  | $ | $
 | 19:00:00 | 0.9 |  | 0 | $ |  | $ | $
 | 20:00:00 | 1 |  | 0 | $ |  | $ | $
Spreadsheet: 3c1a164f-8999-477d-9851-7bd992042ab1
Sheet: Sheet1

[NAME] | Unnamed: 1 | Mena | Devíza nákup | Devíza predaj | Valuta nákup | Valuta predaj
Austrália |  | AUD | 1.3263 | 1.2914 | 1.3704 | 1.2643
[NAME] |  | BGN | 0 | 0 | 2.0096 | 1.8629
Kanada |  | CAD | 1.3281 | 1.2932 | 1.3717 | 1.2667
[NAME] rep. |  | CZK | 26.316 | 25.625 | 26.79 | 25.229
[NAME] |  | DKK | 7.5519 | 7.3537 | 7.7584 | 7.2218
V. Británia |  | GBP | 0,8540 | 0,8315 | 0,8757 | 0,8208
Chorvátsko |  | HRK | 7.6851 | 7.4579 | 7.8176 | 7.174
[NAME] |  | HUF | 295.66 | 287.91 | 305.91 | 279.69
[NAME] |  | CHF | 1.2561 | 1.2231 | 1.2784 | 1.2132
Japonsko |  | [NAME] | 133.28 | 129.78 | 137.5 | 127.28
[NAME] |  | NOK | 7.625 | 7.4251 | 7.8219 | 7.2809
[NAME] |  | PLN | 4.236 | 4.1246 | 4.3436 | 3.9877
[NAME] |  | RON | 4.4028 | 4.2726 | 0 | 0
[NAME] |  | RUB | 41.039 | 39.961 | 0 | 0
Švédsko |  | SEK | 8.6923 | 8.4641 | 8.9496 | 8.2925
Turecko |  | TRY | 2.4195 | 2.3015 | 0 | 0
USA |  | USD | 1.3071 | 1.2728 | 1.3259 | 1.245
Spreadsheet: 764043d1642541991-look-for-last-instance-of-a-phrase-and-return-column-header-new-dashboard
Sheet: Dashboard

Release | Epic | Site1 | Site2 | Site3
Global | Environment Setup
Global | Set up AWS Integration Infrastructure
Global | DAX Integration
Global | B2C Customer Group
Global | B2B Customer Group
Global | Initial Data Loads
Global | Global Elements
Global | Home Page
Global | Global Cart
Shopping | Product Detail Page
Shopping | Product Listing Page & Search Results
Shopping | Category Gateway Page
Shopping | Login/Registration
Shopping | Sort by brand
Shopping | Facets
Shopping | Site Search
Shopping | Add to Wishlist
Shopping | Inventory messaging
Shopping | Product Kits (BOM)
Shopping | Product groups (Collections)
Shopping | Product image zoom
Shopping | Video in alt images
Shopping | Q&A
Shopping | Customer reviews
Shopping | Inventory updates
Shopping | Pricing
Shopping | Promotions & discounting
Shopping | Recently Viewed Products
Shopping | Backorder Messaging
Shopping | Serialized Products & Core Charges
Checkout | Operationalized Data Loads
Checkout | Shipping Calculation
Checkout | Cart
Checkout | Checkout
Checkout | PayPal Payments
Checkout | Authorize.net payment gateway
Checkout | ACH Payments
Checkout | Avalara Tax
Checkout | Avalara Tax Exempt
Checkout | Avalara address verification
Checkout | Transactional emails
Checkout | Coupons
Checkout | Guest Checkout
Checkout | Handling Fee Surcharge
My Account | Customer Service
My Account | GDPR + CCPA Compliance
My Account | Implement [NAME] feature
My Account | My Account
My Account | Order History
My Account | Address book
My Account | Order details
My Account | Invoice History (B2B)
My Account | Order History shipping tracking
My Account | Purchase orders
My Account | [NAME]
My Account | Google Analytics
My Account | Google Tag Manager
My Account | Google Shopping Feed
My Account | DataLayer Support
My Account | Credit Application
My Account | Wishlist Management
My Account | Static Pages
My Account | 301 Redirects
 | New Feature
Spreadsheet: 328813d1404102711-hidden-and-unhidden-a-text-box-by-check-box-sample
Sheet: Sheet1

NO | CODE | VALUE
1 | 2345 | 2981264
2 | 4563 | 87862545
3 | 5423 | 812348
4 | 4574 | 12846124
5 | 4321 | 12486
TOTAL
Spreadsheet: 29803d1224889479-excel-2007-data-validation-with-time-problem-hotel
Sheet: Payroll DATA

 | Legal Working Rules |  |  | General Information
 | [NAME] shift per day | 1 |  | Number of hours in a Day | 24
 | Time between shifts | 8
 | Standard working week | 37
 | Maximum Number of consecutive work days | 6
 |  | Status Rate Multiplier |  |  | Overtime pay Rate Multiplier
Wages per department | Wages hourly Rate | Worker | Supervisors | Managers | >37 but <42 | >42
Front Office | 8 | 0 | 1.25 | 1.75 | 1.25 | 1.5
F&B | 7 | 0 | 1.25 | 1.75 | 1.25 | 1.5
Housekeeping | 6 | 0 | 1.25 | 1.75 | 1.25 | 1.5
All others | 5.5 | 0 | 1.25 | 1.75 | 1.25 | 1.5
Distribution of F&B Sales | Percentage of Sales Distributed
 |  | Distribution in proportion to number of  hours worked per employee / total number of hours worked by employees
Workers | 0.08
Supervisors
 | Minimum hotel occupancy during the week
 | <50% | >50 and <70 | >70 and <90 | >=90 |  |  | Amount of sales:
Managers Bonus (% of sales) | 0 | 0.0005 | 0.00065 | 0.00085 |  |  | Bonus
Number of managers who worked during week
Managers Additionnal Bonus
% Of sales | if worker labor cost percentage <20% Sales
Additionnal Bonus amount | 200
Tax Information | Single | Married | Divorced/Widowed
Tax free Allowances | 3000 | 6000 | 5500 |  |  | Based on 50 weeks per year. Compute for a week
Additionnal Tax Free Allowance | 500
Number of dependent child | n | total = | 500 n
Income Tax
Taxable income | Gross income - Tax free Allowance
Social Charges | Gross Income
 | <=10000 | >10000
Rate | 0.055 | 0.035
Spreadsheet: 826663d1682145463-hardcode-text-to-spilled-array-spilled-range
Sheet: convert

 |  |  |  |  |  |  | expected result
Al-100 | 1000 | mg |  |  |  |  |  | g
Al-100 | 1 | mt |  |  |  |  |  | [NAME] |  |  |  | #N/A
[NAME] | 0.025 | [NAME] |  |  |  |  |  | g |  |  |  | 25
[NAME] | 0.5 | [NAME] |  |  |  |  |  | g |  |  |  | 500
[NAME] | 0.1 | [NAME] |  |  |  |  |  | [NAME] |  |  |  | 100
Al-102 | 0.025 | [NAME] |  |  |  |  |  | g |  |  |  | 25
Al-102 | 1 | [NAME] |  |  |  |  |  | g |  |  |  | 1000
Al-103 | 0.025 | [NAME] |  |  |  |  |  | g |  |  |  | 25
Al-103 | 1 | g |  |  |  |  | 1 | g |  |  |  | 1
Al-104 | 1 | [NAME] |  |  |  |  |  | g |  |  |  | 1000
Al-105 | 25 | [NAME] |  |  |  |  |  | g |  |  |  | 25000
[NAME] | 25 | [NAME] |  |  |  |  |  | g |  |  |  | 25000
Al-111 | 1 | [NAME] |  |  |  |  |  | g |  |  |  | 1000
Al-112 | 1 | L |  |  |  |  |  | mL |  |  |  | 1000
Al-113 | 1 | g |  |  |  |  | 1 | g |  |  |  | 1
Al-113 | 500 | g |  |  |  |  | 500 | g |  |  |  | 500
AA7075-100 | 1 | [NAME] |  |  |  |  |  | g |  |  |  | 1000
Spreadsheet: stacey_white__39169__Pre-bankruptcy Payouts31
Sheet: as of 1-2

 | Pre-bankruptcy Payouts
In Legal Pre-Petition Packet? | Counterparty | Date of Liquidation | Cash In | Related Commodities | Commodity MTM | Commodity Receivable / (Payable) | % of Total Cash In | Net Gain / (Loss) | Comments
No | Bear Stern | ? | 541000 |  |  | 0 |  |  | May be same as BP Capital Energy below
Yes | BP Capital Energy Equity Fund, L.P. | 2001-11-30 00:00:00 |  | Financial (Non-power) |  | 0
Yes | BP Capital Energy Equity International Holdings I, Ltd. | 2001-11-30 00:00:00 | 541000 | Natural Gas Only |  | 0 |  |  | Deal #'s: YJ4705.1, YJ4707.1, YJ7870.1, YM0130.2
Yes | Constellation Power Source, Inc. | 2001-11-30 00:00:00 | 45000000 | Power (Physical Only) |  | 6902944.75 |  |  | Per Contract: $45 MM = Physical Power, ($3) MM = All Financial Commodities
 | Constellation Power Source, Inc. |  | -3000000 | Financial (including weather) - no power |  | 0
 | Constellation Power Source, Inc. |  |  | Physical Gas
 | Constellation Power Source, Inc. |  |  | Coal |  | 0
 | Constellation Power Source, Inc. |  |  | Emissions |  | 0
Yes | Energy Authority, The | 2001-11-30 00:00:00 | 724333.25 | Power |  | 111664
 | Energy Authority, The |  |  | Gas
Yes | International Paper Company | 2001-11-30 00:00:00 | 12163283 | Gas & Financial |  | 44880
Yes | Michigan Consolidated Gas Company | 2001-11-28 00:00:00 | 0 | Firm Gas Storage Contract
Yes | NUI Energy Brokers, Inc. | 2001-11-30 00:00:00 | 42900000 | No Power |  | 6102464.05 |  |  | Includes NUI Energy Brokers, Inc, NUI Corporation, NUI Utilities, Inc., Elizabethtown Gas Company, NUI Corporation - City Gas Company
No | Pemex |  | 4122000
Yes | Public Service Company of Colorado | 2001-11-30 00:00:00 | 6000000 | Power |  | -2200000
 | Public Service Company of Colorado |  |  | Gas
Yes | Sequent Energy Management, L.P., successor to AGL Energy Services, Inc. as agent for Virginia Natural Gas, Inc. | 2001-12-01 00:00:00 | 0 | Gas |  |  |  |  | Balance is both VNG $6,861,645.01 and Sequent ($2,895,027.83).  [NAME] is reduced for Demand/FS Service that VNG paid directly to the pipe since ENA did not pay the pipe.
No | Socal - J.P. Morgan | ? | 1200000 |  |  | 0
Yes, but amount not confirmed | Southern California Edison Company, PG& E Energy Trading-Power, L.P. | 2001-11-30 00:00:00 | 5000000 | Power (assignment # 461072) |  | 0
Yes | Sprague Energy Corp. | 2001-11-30 00:00:00 | 14000000 | Gas Only |  |  |  |  | Deal #'s: YC7501.1, [NAME], [NAME], [NAME]
Yes | [NAME] | 2001-11-30 00:00:00 | 7073860 | Financial (Non-power) |  | 0
Yes | Thermo Cogeneration Partnership LP | 2001-11-29 00:00:00 | 274396 | Gas Only |  |  |  |  | Deal #[NAME]
Yes | UGI Utilities, Inc. | 2001-12-01 00:00:00 | 1460000 | Gas |  | -2731.66 |  |  | Deal #'s:QY7884.2, 689564
Yes | Wells Fargo Bank N.A. | 2001-11-29 00:00:00 | 43638 | Gas Only |  | 0 |  |  | Deal #VQ6899.1
Yes | Wells Fargo Bank N.A. | 2001-11-29 00:00:00 | 32280 | Timber Only |  | 0 |  |  | Deal #VV1232.1
Yes | Wells Fargo Bank N.A. | 2001-12-03 00:00:00 | 75918 | Financial Gas Only |  | 0 |  |  | Deal#'s: VQ6899.1, [NAME]
Spreadsheet: 851283d1701509079-how-to-calculate-fibonacci-retracements-ratio-by-excel-formula-fibonacci-retracement-aligw
Sheet: Fibonacci Retracement  Pre-365

High | Low | Close | Fibonacci Retracement % |  |  |  |  | RETRACEMENTS
116 | 73 | 116 |  |  |  |  |  | 0.9443
116 | 73 |  |  |  |  |  |  | 0.854
116 | 73 | 99.6 |  |  |  |  |  | 0.786
116 | 73 | 83.1 |  |  |  |  |  | 0.764
116 | 73 | 73 |  |  |  |  |  | 0.618
116 | 73 | 93 |  |  |  |  |  | 0.5
116 | 73 | 80 |  |  |  |  |  | 0.382
 |  |  |  |  |  |  |  | 0.236
 |  |  |  |  |  |  |  | 0.146
 |  |  |  |  |  |  |  | 0.0902
 |  |  |  |  |  |  |  | 0.0557
Spreadsheet: 150079d1334270402-vlookup-return-multiple-values-jill-working-margins
Sheet: April Summary

[NAME] # | Salesperson | Quote | Dicing Margin | Packaging Margin | Assembly Margin
10001 | Mark | 1234 | 30 | 100 | 50
10012 | [NAME] | 7890 |  | 30 | 10
10023 | none | none | 75
Spreadsheet: 853698d1703662953-how-to-combine-2-different-filter-formula-from-2-different-sheets-book2
Sheet: Sheet1

Product | Quantity |  |  | Sheet1 | Quantity |  | Product | <formula
ABC 123 | 3 |  |  |  | 3
ABC 123 | 6 |  |  |  |  |  | DEF 123
ABC 123 | 5
DEF 123 | 3
GHI 123 | 4
ABC 123 | 4 |  |  | Sheet2 | Quantity |  | Product | <formula
DEF 123 | 3 |  |  |  | 3
GHI 123 | 4 |  |  |  |  |  | 123 GHI
 |  |  |  | what I want is to combine this formula from 2 different sheets to become:
 |  |  |  |  | Quantity |  | Product
 |  |  |  |  | 3 |  | ABC 123
 |  |  |  |  |  |  | DEF 123
 |  |  |  |  |  |  | 123 GHI
Spreadsheet: 684112d1593151199-spread-data-by-numbers-example
Sheet: Sheet1

MyData | Amount |  | count data | count amount | out |  |  |  | the needed out
A | 1 |  | 3 | 12 |  |  |  |  |  | 1
B | 2 |  |  |  |  |  |  |  |  | 2
C | 3 |  |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  | 12
Spreadsheet: 66667d1267319288-collating-grouping-data-from-different-sheets-hourexample-1-
Sheet: Sheet1

names | hours | date |  |  | Sum of hours
[NAME] | 4 | 2010-02-28 00:00:00 |  |  | names | Total
Fred | 4 | 2010-02-28 00:00:00 |  |  | [NAME] | 40
[NAME] | 8 | 2010-02-28 00:00:00 |  |  | [NAME] | 34
[NAME] | 8 | 2010-02-28 00:00:00 |  |  | Emma | 14
[NAME] | 6 | 2010-03-01 00:00:00 |  |  | [NAME] | 36
[NAME] | 6 | 2010-03-01 00:00:00 |  |  | Fred | 34
[NAME] | 8 | 2010-03-01 00:00:00 |  |  | [NAME] | 16
Fred | 8 | 2010-03-01 00:00:00 |  |  | [NAME] | 14
Mark | 4 | 2010-03-01 00:00:00 |  |  | [NAME] | 40
[NAME] | 8 | 2010-03-01 00:00:00 |  |  | Maria | 8
[NAME] | 8 | 2010-03-02 00:00:00 |  |  | Mark | 20
[NAME] | 8 | 2010-03-02 00:00:00 |  |  | [NAME] | 8
[NAME] | 8 | 2010-03-02 00:00:00 |  |  | [NAME] | 8
Fred | 6 | 2010-03-02 00:00:00 |  |  | [NAME] | 15
Mark | 4 | 2010-03-02 00:00:00 |  |  | [NAME] | 9
[NAME] | 8 | 2010-03-02 00:00:00 |  |  | Grand Total | 296
[NAME] | 8 | 2010-03-03 00:00:00
[NAME] | 8 | 2010-03-03 00:00:00
[NAME] | 8 | 2010-03-03 00:00:00
Emma | 8 | 2010-03-03 00:00:00
Mark | 4 | 2010-03-03 00:00:00
[NAME] | 8 | 2010-03-03 00:00:00
[NAME] | 6 | 2010-03-04 00:00:00
Emma | 6 | 2010-03-04 00:00:00
[NAME] | 8 | 2010-03-04 00:00:00
Fred | 8 | 2010-03-04 00:00:00
Mark | 4 | 2010-03-04 00:00:00
[NAME] | 8 | 2010-03-04 00:00:00
[NAME] | 8 | 2010-03-05 00:00:00
[NAME] | 8 | 2010-03-05 00:00:00
[NAME] | 8 | 2010-03-05 00:00:00
Mark | 4 | 2010-03-05 00:00:00
[NAME] | 8 | 2010-03-05 00:00:00
[NAME] | 8 | 2010-03-05 00:00:00
Maria | 8 | 2010-03-06 00:00:00
[NAME] | 8 | 2010-03-06 00:00:00
Fred | 8 | 2010-03-06 00:00:00
[NAME] | 6 | 2010-03-06 00:00:00
[NAME] | 8 | 2010-03-06 00:00:00
[NAME] | 7 | 2010-03-07 00:00:00
[NAME] | 8 | 2010-03-08 00:00:00
[NAME] | 9 | 2010-03-09 00:00:00
Spreadsheet: 48687d1247925936-selecting-values-based-on-conditions-value-test
Sheet: Data

Month | Truck Details | Qty | Unit Cost | Total Cost
2009-03-01 00:00:00 | Truck 1 | 48 | 1307.3096
2009-03-12 00:00:00 | Truck 2 | 47 | 1246.7391
2009-04-01 00:00:00 | Truck 3 | 48 | 1274.0161
2009-05-01 00:00:00 | Truck 4 | 46 | 1476.7701
2009-05-10 00:00:00 | Truck 5 | 30 | 1474.0777
2009-05-21 00:00:00 | Truck 6 | 42 | 1460.4657
2009-06-01 00:00:00 | Truck 7 | 47 | 1426.7566
2009-06-15 00:00:00 | Truck 8 | 47 | 1463.7648
2009-06-19 00:00:00 | Truck 9 | 47 | 1501.9593
Spreadsheet: 494080d1482165324-sort-array-formula-results-in-descending-order-sort-array-formula-results-in-descending-order-download-example-1
Sheet: PS_TRANSPORT PLAN

 | TRANSPORT PLAN
 |  |  |  |  |  |  |  |  |  |  | Date | 2017-02-22 00:00:00 |  | ←1) Enter Date
 |  |  |  |  |  |  |  |  |  |  | Vehicle | Vehicle 2 |  | ←2) [NAME]
I would like these rows to be ordered as ↓ | DELIVERY ORDER | DRIVER | T/PORT | P/CODE | ADDRESS | CLIENT/CUSTOMER | CONTACT NAME | PHONE NO. | [NAME] | QTY | DELIVERY TYPE | DELIVERY RESTRICTIONS | TIME
 | PLEASE RING CUSTOMER BEFORE DELIVERY / COLLECTION
1
1
2
2
3
4
5
Spreadsheet: 97912d1297017889-filter-within-a-filter-within-a-filter-excel
Sheet: Sheet1

Date | Area | Normal Tix | Sale Tix | Advertised |  | Date | (All)
2011-01-01 00:00:00 | BL | Day | Day | News |  | Advertised | (All)
2011-01-06 00:00:00 | E | Month | 3Month | TS
2011-01-06 00:00:00 | MH | Month | Year | High |  | Row Labels | Count of Sale Tix | Count of Normal Tix
2011-02-02 00:00:00 | BL | Day | 10J | High |  | BL | 2 | 2
 |  |  |  |  |  | E | 1 | 1
 |  |  |  |  |  | MH | 1 | 1
 |  |  |  |  |  | Grand Total | 4 | 4
Spreadsheet: 111997d1308196167-array-calculation-and-percentile-percentile
Sheet: Sheet1

0 | 94
0 | 71
0 | 66
0 | 99
0 | 40
0 | 19
0 | 7
0 | 8
0 | 95
0 | 43
1 | 64 |  | [NAME] all OK
1 | 98
1 | 97 |  | 95%ile of a=1 | 97.55
1 | 10 |  | 95%ile of a=2 | 71.89999999999998
1 | 31 |  | 95%ile of a=3 | 84.14999999999999
1 | 23 |  | 95%ile of a=4 | 91.04999999999998
1 | 56 |  | 95%ile of a=5 | 89.3
1 | 48 |  | 95%ile of a=10 | 97.55
1 | 46 |  | 95%ile of a=11 | 80.39999999999998
1 | 84
2 | 14 |  | Fixed calculation - all OK
2 | 28 |  | rows 11 - 30  (A=1 or 2) | 97.05
2 | 35
2 | 26
2 | 17 |  | Array caclulation - fails
2 | 15 |  | when a = 1 or 2   - FAILS | #N/A
2 | 80
2 | 39
2 | 62
2 | 45
3 | 2
3 | 34
3 | 16
3 | 90
3 | 68
3 | 24
3 | 77
3 | 21
3 | 72
3 | 63
4 | 4
4 | 44
4 | 6
4 | 85
4 | 29
4 | 83
4 | 96
4 | 22
4 | 82
4 | 5
5 | 47
5 | 20
5 | 92
5 | 79
5 | 86
5 | 18
5 | 70
5 | 11
5 | 3
5 | 50
6 | 38
6 | 76
6 | 41
6 | 60
6 | 81
6 | 67
6 | 91
6 | 33
6 | 37
6 | 57
7 | 30
7 | 93
7 | 1
7 | 51
7 | 65
7 | 36
7 | 12
7 | 61
7 | 27
7 | 58
8 | 100
8 | 9
8 | 74
8 | 88
8 | 32
8 | 55
8 | 52
8 | 49
8 | 53
8 | 87
9 | 13
9 | 42
9 | 25
9 | 89
9 | 59
9 | 78
9 | 75
9 | 73
9 | 54
9 | 69
10 | 94
10 | 71
10 | 66
10 | 99
10 | 40
10 | 19
10 | 7
10 | 8
10 | 95
10 | 43