tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 149739d1334103744-if-forumula-problem-bo-simulation
Sheet: Business Operations

Simulations of Weekly Business Operations on BC-6
 | Selling price ($): |  | 91.8 | per case
 | Salvage value ($): |  | 12.5 | per case unsolde at the end of a week
 | Order cost ($): |  | 56.95 | per case
 | Goodwill penalty ($): |  | 4 | per case short
 | Number of cases of BC-6 to order every week: |  |  |  |  | 12 | <- enter your trial order quantity in cases
 | Total number of cases shortage in 52 weeks:
 | Total number of cases surplus in 52 weeks:
 | Total profit in 52 weeks:
 | Average weekly profit of 52 weeks:
Week # | Number of cases ordered per week | Random # | Weekly Demand (case) | Numbr of cases sold in the week | Revenue of the week  from regular sales ($) | Number of cases short in the week | Goodwill penalty in the week due to shortage ($) | Number of cases surplus in the week | Revenue of the week from selling surplus at salvage price ($) | Total revenue of the week ($) | Total cost of the week ($) | Total profit of the week ($)
1
Spreadsheet: 109686d1306470569-window-change-event-changeselection-1
Sheet: Vac

Holidays to Exclude from Working Days
New Year | 2010-01-01 00:00:00 | 2010
Family Day | 2010-02-15 00:00:00
Good Friday | 2010-04-02 00:00:00
Easter Sunday | 2010-04-04 00:00:00
Easter Monday | 2010-04-05 00:00:00
[NAME] | 2010-05-24 00:00:00
Canada Day | 2010-07-01 00:00:00
Civic day | 2010-08-02 00:00:00
Labor day | 2010-09-06 00:00:00
Thanksgiving | 2010-10-11 00:00:00
Remembrance Day | 2010-11-11 00:00:00
Christmas Day | 2010-12-25 00:00:00
Boxing Day | 2010-12-26 00:00:00
New Year | 2011-01-01 00:00:00 | 2011
Family Day | 2011-02-21 00:00:00
Good Friday | 2011-04-22 00:00:00
Easter Sunday | 2011-04-24 00:00:00
Easter Monday | 2011-04-25 00:00:00
[NAME] | 2011-05-23 00:00:00
Canada Day | 2011-07-01 00:00:00
Civic day | 2011-08-01 00:00:00
Labor day | 2011-09-05 00:00:00
Thanksgiving | 2011-10-10 00:00:00
Remembrance Day | 2011-11-11 00:00:00
Christmas Day | 2011-12-25 00:00:00
Boxing Day | 2011-12-26 00:00:00
New Year | 2012-01-01 00:00:00 | 2012
Family Day | 2012-02-20 00:00:00
Good Friday | 2012-04-06 00:00:00
Easter Sunday | 2012-04-08 00:00:00
Easter Monday | 2012-04-09 00:00:00
[NAME] | 2012-05-28 00:00:00
Canada Day | 2012-07-01 00:00:00
Civic day | 2012-08-06 00:00:00
Labor day | 2012-09-03 00:00:00
Thanksgiving | 2012-10-08 00:00:00
Remembrance Day | 2012-11-11 00:00:00
Christmas Day | 2012-12-25 00:00:00
Boxing Day | 2012-12-26 00:00:00
Spreadsheet: 586861d1534692183-how-to-get-specific-rows-in-a-worksheet-copied-from-another-coloured-backgrounds
Sheet: Original

Date | Title | Money
2018-02-08 00:00:00 | Lunch | -10
 | Car petrol | -50
 | Stationary | -2
 | Sale A | 21.5
 | Sale B | 32
 | Travel | -44
 | Sale A | 22
 | Sale A | 22
 | Sale Z | 23
 | Cleaning | -3
 | Marketing | -78
 | Train | -2
 | Bus | -1
 | [NAME] | 200
Spreadsheet: 772700d1647436763-how-to-create-formula-index-and-small-rank-index
Sheet: Sheet1

NAME | SCORE |  | ORDER | SCORE | NAME
A | 40
B | 10
C | 37
D | 55
E | 10
F | 0
G | 25
based on this formula is to obtain scores from high to low. how to use the same formula from low to high.  I don't want to count the number 0 as a ranking. i want to start ranking with number 10 as the lowest number in the first ranking.  and as seen 10 the first should be B but calculated E is the first
Spreadsheet: 850721d1701107928-return-value-yes-or-no-if-a-time-is-greater-or-less-than-a-time-displayed-in-another-cell-times-etaf
Sheet: Sheet1

Late? | SLA | Delivered time
 | 0.375 | 0.4548611111111111
 | 0.3333333333333333 | 0.4545949074074074
 | 0.375 | 0.4513888888888889
 | 0.3333333333333333 | 0.4478819444444445
 | 0.7291666666666666 | 0.4474884259259259
 | 0.7291666666666666 | 0.4474884259259259
 | 0.7291666666666666 | 0.4474884259259259
 | 0.3333333333333333 | 0.4470717592592592
Spreadsheet: 81977d1282064125-vlookup-or-index-match-for-multiple-criteria-and-return-a-date-value-from-cell-all-projects-status-report-new-report-test
Sheet: Status Report

Project | Predictive Testing Complete | FMS: Discovery Complete | FMS:   EAA Complete | Conduct Buildability Review | FMS: Server Builds Complete | FMS:  Server Delivery Request Complete | FMS:  Capacity Delivery Complete (All Environments) | FMS:  Application Functional Testing Complete - DEV | FMS:  Application DEV Launch Complete | FMS:  Application Install & Configure - QA Complete | FMS: Baseline Load & Performance Tests Complete | FMS:  Application Testing Complete - QA | FMS: Ported  Load & Performance Test Complete | FMS:  Application QA Launch Complete | FMS:  Application Install & Configure PROD Complete | FMS:  Application Functional Testing PROD Complete | FMS:  Application PROD Launch Complete | FMS:  Migration Complete | FMS:  Notification Received that Decommission Servers Complete | FMS:    Project Complete | GAO Review Complete
Project1
Project2
Project3
Project4
I want to know if A2=Column A in sharepoint tab and $b$1=Column C in sharepoint tab, return the value from Sharepoint tab Column F to Cell B2.  Need this for all columns and rows.
Spreadsheet: 27f150d4-e3f8-47e2-8925-24aaafc45abc
Sheet: Sheet1

AUSTRADE AND ALLY OFFICES IN AUSTRALIA                                                               (As at 1 September 2001) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
State | Location | Austrade | TradeStart | TradeSat | Export Access
New South | Sydney
Wales | [NAME]
 | Tamworth
 | Newcastle
 | Gosford
 | Bathurst |  |  | Orange
 | Parramatta
 | Campbelltown
 | [NAME]
 | Nowra
 | [NAME]
Victoria | Melbourne
 | Wangaratta*
 | Bendigo
 | Ballarat
 | [NAME]
 | Vermont
 | Dandenong
Queensland | Brisbane
 | [NAME]
 | Townsville
 | Rockhampton
 | Bundaberg
 | Toowoomba
 | Southport
South | Adelaide
Australlia | Mt Gambier
 | Berri
 | Whyalla
Western | Perth
Australia | Kununurra
 | Carnarvon
 | [NAME]
 | Albany
Tasmania | [NAME]
 | [NAME]
Australian | Canberra (Civic)
Capital | Canberra (Barton)
Territory | Canberra ([NAME])
Northern | [NAME]
Territory | [NAME]
Austrade Offices - 16 Locations
TradeStart Offices - 24 Locations
Export Access - 25 Locations
* Part-time office operated from Bendigo
Spreadsheet: 824905d1680948511-sum-by-item-and-year-from-another-sheet-book1-1-
Sheet: Sheet2

Inv | Date | Decription | Debit | Credit | Debit
 | 2022-12-30 00:00:00 | rent dec | Co-Operative Bank | Equity | 24662
 | 2022-12-30 00:00:00 | rent dec | Saleem | Equity | 2630
 | 2022-12-30 00:00:00 | rent dec | PK Stores | Equity | 4830
 | 2022-12-30 00:00:00 | rent dec | Cable TV | Equity | 1130
 | 2022-12-30 00:00:00 | rent dec | Falcon Tailors | Equity | 2020
 | 2022-12-30 00:00:00 | rent dec | Shafeeq | Equity | 5000
 | 2022-12-30 00:00:00 | bf | Cash In Hand |  | 3172
 | 2022-12-30 00:00:00 | bf | Cash In Bank |  | 7076
 | 2022-12-30 00:00:00 | sec shafeeq | Security Deposit |  | 7500
 | 2022-12-30 00:00:00 | adj | Management Fees | Management Fees | 0.01
 | 2023-01-30 00:00:00 | rent dec | Cash In Bank | Co-Operative Bank | 24662
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Saleem | 2630
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Cable TV | 1130
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Falcon Tailors | 2020
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Shafeeq | 5000
 | 2023-01-30 00:00:00 | ELEC | Cash In Hand | Misc Income | 350
 | 2023-01-30 00:00:00 | WATER | Cash In Hand | Misc Income | 100
 | 2023-01-30 00:00:00 | main | Maintenanace | Cash In Hand | 360
Spreadsheet: louise_kitchen__24100__Org Chart
Sheet: Power

 |  |  |  | Power
 | East Power |  |  |  |  | Power Structuring |  |  | Control Room
 |  |  |  |  |  | Nick Hiemstra |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Manager
Vice President |  |  | Vice President |  |  | [NAME] |  |  | x33313
x58958 |  |  | x36351
 |  |  |  |  |  | [NAME] |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Manager
Manager |  |  | Director |  |  | x36480 |  |  | x30478
x57702 |  |  | x39633
 |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  |  |  |  | Manager
Associate |  |  | Associate
x34748 |  |  | x53548
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  |  | [NAME]
 |  |  | Analyst |  |  |  |  |  | x31984
 |  |  | x35190
Spreadsheet: 840889d1693122014-return-split-values-in-a-dynamic-range-and-include-blanks-split-text-example-2-
Sheet: Sheet1

Name |  | Name.1 | Name.2 | Name.3 | Name.4 | Name.5
[NAME] |  | [NAME] | [NAME]
Hortensia Gaius Aurelia Valentina Maximilla |  | Hortensia | Gaius | Aurelia | Valentina | [NAME]
 |  | Olivia | [NAME]
[NAME] |  | [NAME] | de | la | Cruz
[NAME] |  | Juan | Martin | Hernandez
 |  | Ava | [NAME]
[NAME] |  | [NAME] | White
[NAME] |  | Charlotte | [NAME]
[NAME] |  | [NAME] | de | la | Cruz
[NAME]
[NAME]
Spreadsheet: 802647d1666957310-index-match-match-not-working-on-all-instances-mismatched-index-match-match
Sheet: Sheet1

Date | Product | Variant | SKU | S/be |  |  |  |  | Product | Variant | SKU
2022-02-17 00:00:00 | Product 1 | Variant 1 |  |  | "=INDEX(SKU,MATCH(B2,Product,0)*MATCH(C2,Variant,0))" |  |  |  | Product 1 | Variant 1 | SKU 1
2022-03-12 00:00:00 | Product 1 | Variant 1 |  |  |  |  |  |  | Product 1 | [NAME] | SKU 2
2022-02-06 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 1 | [NAME] | SKU 3
2022-02-17 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 1 | [NAME] | SKU 4
2022-02-24 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | Variant 1 | SKU 5
2022-01-13 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | [NAME] | SKU 6
2022-01-16 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | [NAME] | SKU 7
2022-02-02 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | [NAME] | SKU 8
2022-03-01 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | Variant 5 | SKU 9
2022-03-17 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 3 | Variant 1 | SKU 10
2022-01-13 00:00:00 | Product 2 | Variant 1 |  |  |  |  |  |  | Product 3 | [NAME] | SKU 11
2022-02-26 00:00:00 | Product 2 | [NAME] |  | SKU 6 |  |  |  |  | Product 3 | [NAME] | SKU 12
2022-03-23 00:00:00 | Product 2 | [NAME] |  | SKU 6
2022-02-11 00:00:00 | Product 2 | [NAME] |  | SKU 7 |  |  |  |  | Set as Named Ranges (e.g. 'Product'=Sheet1!$J$2:$J$13, etc)
2022-03-30 00:00:00 | Product 2 | [NAME] |  | SKU 7
2022-02-01 00:00:00 | Product 2 | [NAME] |  | SKU 8
2022-03-10 00:00:00 | Product 2 | [NAME] |  | SKU 8
2022-03-24 00:00:00 | Product 2 | [NAME] |  | SKU 8
2022-03-19 00:00:00 | Product 2 | Variant 5 |  | SKU 9
2022-03-12 00:00:00 | Product 2 | Variant 5 |  | SKU 9
2022-01-10 00:00:00 | Product 3 | Variant 1
2022-02-08 00:00:00 | Product 3 | Variant 1
2022-02-11 00:00:00 | Product 3 | Variant 1
2022-03-13 00:00:00 | Product 3 | [NAME] |  | SKU 11
2022-03-10 00:00:00 | Product 3 | [NAME] |  | SKU 11
2022-01-10 00:00:00 | Product 3 | [NAME] |  | SKU 11
2022-01-18 00:00:00 | Product 3 | [NAME] |  | SKU 12
2022-02-11 00:00:00 | Product 3 | [NAME] |  | SKU 12
2022-02-19 00:00:00 | Product 3 | [NAME] |  | SKU 12
2022-03-16 00:00:00 | Product 3 | [NAME] |  | SKU 12
Spreadsheet: 763381d1642148951-how-do-i-create-an-autofill-template-excel-template-2-upd
Sheet: Sheet1

P# W# | 2022-04-19 00:00:00
Name | Associate Number | Performance % |  |  | Name: | Associate Number
 | 523095 | 29.3 |  |  | [NAME] | 408123
 | 827943 | 40.5 |  |  | [NAME] | 120421
 | 987234 | 49.5 |  |  | [NAME] | 523095
 | 120421 | 63.4 |  |  | Jeremiah | 827943
 | 408123 | 76.7 |  |  | [NAME] | 987234
 | 879634 | 96.6 |  |  | Jasmine | 918347
 | 918347 | 99.5 |  |  | [NAME] | 879634
 |  | Goal: 70%
 |  |  |  |  | Quarter | Period | Week | Year | Every Period has 4 weeks with the exception of p13 2023/2024 which has 5. I want excel to detect the date and determine which P and W we're on.
 |  |  |  |  | 1 | 1 | 01/30-02/26 | 2022
 |  |  |  |  | 1 | 2 | 02/27-03/26 | 2022
 |  |  |  |  | 1 | 3 | 03/27-04/23 | 2022 |  | Example of weeks
 |  |  |  |  | 1 | 4 | 04/24-05/21 | 2022 |  | PERIOD | WEEK | DATE
 |  |  |  |  | 2 | 5 | 05/22-06/18 | 2022 |  |  | 1 | 2022-01-30 00:00:00
 |  |  |  |  | 2 | 6 | 06/19-07/16 | 2022 |  |  | 2
 |  |  |  |  | 2 | 7 | 07/17-08/13 | 2022 |  |  | 3
 |  |  |  |  | 3 | 8 | 08-14-09/10 | 2022 |  |  | 4
 |  |  |  |  | 3 | 9 | 09/11-10/8 | 2022 |  |  | 1
 |  |  |  |  | 3 | 10 | 10/9-11/5 | 2022 |  |  | 2
 |  |  |  |  | 4 | 11 | 11/6-12/3 | 2022 |  |  | 3
 |  |  |  |  | 4 | 12 | 12/4-12/31 | 2022 |  |  | 4
 |  |  |  |  | 4 | 13 | 1/1/-1/28 | 2023 |  |  | 1
 |  |  |  |  | 1 | 1 | 1/29-2/25 | 2023 |  |  | 2
 |  |  |  |  | 1 | 2 | 2/26-3/25 | 2023 |  |  | 3
 |  |  |  |  | 1 | 3 | 3/26-4/22 | 2023 |  |  | 4
 |  |  |  |  | 1 | 4 | 4/23-5/20 | 2023 |  |  | 1
 |  |  |  |  | 2 | 5 | 5/21-6/17 | 2023 |  |  | 2
 |  |  |  |  | 2 | 6 | 6/18-7/15 | 2023 |  |  | 3
 |  |  |  |  | 2 | 7 | 7/16-8/12 | 2023 |  |  | 4
 |  |  |  |  | 3 | 8 | 8/13-9/9 | 2023 |  |  | 1
 |  |  |  |  | 3 | 9 | 9/10-10/7 | 2023 |  |  | 2
 |  |  |  |  | 3 | 10 | 10/8-11/4 | 2023 |  |  | 3
 |  |  |  |  | 4 | 11 | 11/5-12/2 | 2023 |  |  | 4
 |  |  |  |  | 4 | 12 | 12/3-12/30 | 2023 |  |  | 1
 |  |  |  |  | 4 | 13 | 12/31-2/3 | 2023/2024 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
Spreadsheet: 821119d1678459775-convert-month-name-into-numeric-value-monthnumber
Sheet: Sheet1

 |  | month value
 | January |  |  | Column1 | Merged
 | February |  |  | Januar | 1
 | March |  |  | Februar | 2
 | April |  |  | März | 3
 | May |  |  | April | 4
 | June |  |  | Mai | 5
 | July |  |  | Juni | 6
 | August |  |  | [NAME] | 7
 | September |  |  | August | 8
 | October |  |  | September | 9
 | November |  |  | Oktober | 10
 | December |  |  | November | 11
 |  |  |  | [NAME] | 12
 |  |  |  | Februar | 2
 |  |  |  | März | 3
 |  |  |  | April | 4
 |  |  |  | Mai | 5
 |  |  |  | [NAME] | 7
 |  |  |  | August | 8
 |  |  |  | September | 9
 |  |  |  | Oktober | 10
 |  |  |  | November | 11
 |  |  |  | [NAME] | 12
Spreadsheet: 219400d1362749035-how-to-fill-in-multiple-cells-from-a-dropdown-list-template-20pv-20installations-1-
Sheet: Cost Breakdown

 |  |  | Cost Breakdown
 |  |  | Tray 1: |  |  | [NAME] |  | Factor
 | Sub Header | Quantity | Description | Part No | Mats Cost | 0.2 | Total Mats Cost | 1 | Labour Cost | Total Cost
 | 1.1: Tray | 24 | Meters 150mm MRF tray + 1no pair of couplers
 | 1.2: Flat Bend | 1 | 225mm MRF flat bend + 2no pairs of couplers
 | 1.3: [NAME] | 12 | Meters 225mm Lid c/w brackets
 | 1.4: Tray stand off bracket | 18 | 225[NAME] stand off bracket
 | 1.5: Non penetrate feet | 9 | 150mm Non penetrate feet
 | 1.6: Cable penetration | 1
 | 1.7: Lot Sundries | 1
 |  |  |  | Sub Total, Tray 1:
Spreadsheet: 49287d1248605201-creating-sheets-while-referencing-a-new-row-in-some-cells-sample-data
Sheet: Data Tab

Name | Address | city | state | zip | account | id# | type | amount 1 | amount 2 | amount 3 | amount 4 | amount 5 | amount 6 | amount 7 | amount 8 | amount 9 | amount 10
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Spreadsheet: 860454d1708535407-solver-simplex-lp-negative-profit-tax-problem-solver_profittax_demo
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MUST BE TAKEN FROM EBT>0 ONLY
 | Location | Revenue | Expense | Net Revenue | Unallocated resources | Cost of resource | Resources Bought | Resources Sold | Remaining resources | Internal Revenue | Internal Expenses | EBT Min Threshold | EBT | % Profit Tax | Profit Tax | NetPL | indicator
 | A | 10000 | 500 |  | 100 | 5 |  |  |  |  |  |  |  | 0.5 |  |  | 0
 | B | 100 | 300 |  | 1000 | 1 |  |  |  |  |  |  |  | 0.3 |  |  | 0
 | C | -5000 | 1000 |  | 500 | 3 |  |  |  |  |  |  |  | 0.2 |  |  | 0
 | D | 2000 | 250 |  | 400 | 2 |  |  |  |  |  |  |  | 0.15 |  |  | 0
 | E | 1000 | 50 |  | 1000 | 4 |  |  |  |  |  |  |  | 0.1 |  |  | 0
 | Total
 | Internal distribution.
 | [NAME] | Buyer | Resources sold | Amount | Cost of resource | [NAME]'s cost of  resource | Purchase permitted |  | Objective: maximize | SUM(NetPL)
 | B | A | 0
 | B | C | 0
 | B | D | 0
 | B | E | 856.25
 | C | A | 0 |  |  |  |  |  | Constraints: | Remaining resources >=0
 | C | E | 0 |  |  |  |  |  |  | EBT >= Net Revenue ,  Net Revenue<=0
 | D | A | 0 |  |  |  |  |  |  | EBT >= NetRevenue*5% ,  Net Revenue>0
 | D | C | 0 |  |  |  |  |  |  | [NAME]'s cost of resource >= [NAME]'s cost of resource
 | D | E | 400
 | E | A | 2256.25 |  |  |  |  |  | Issue: | Profit Tax must be taken from positive EBT only
 | A | B
 | A | C
 | A | D
 | A | E
 | C | B
 | C | D
 | D | B
 | E | B
 | E | C
 | E | D
Spreadsheet: 41917d1240472373-vlookup-across-multiple-columns-680826_taylor1978
Sheet: Sheet1

MATCHID# | Team |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATCHID# | Team |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATCHID# | Team
1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Metro Dodgers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n1 | [NAME]
2 | Gremlins |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Wii Not Fit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n2 | Dabba
3 | FooFighters |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Rockets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n2 | Doo
4 | Cougars |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Neverminds |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n4 | !
Spreadsheet: 36384d1234272728-pulling-data-based-on-date-copy-of-test2
Sheet: Sheet1

 | Sum of Value | Date
 | Type | Jan | Feb | Grand Total
 | Cat | 3 | 2 | 5
 | Dog | 18 |  | 18
 | [NAME] | 8 | 1 | 9
 | Grand Total | 29 | 3 | 32
Spreadsheet: 119447d1314391196-call-in-multiple-entries-from-master-sheet-example
Sheet: Mutiple

 |  |  |  |  | COMPANY
 | UNITS | PACKAGING |  | PKG TYPE | BRAND | LOT
 | CUSTOMER | CON # |  |  |  |  |  |  |  | PLAIN BB |  | PLAIN PB |  | TRTD BB |  | TRTD PB |  | BOL
 |  |  |  |  |  |  |  |  | Total
ERROR
CHECKS |  |  |  |  |  |  |  | Balance |  | #N/A |  | #N/A |  | #N/A |  | #N/A
Spreadsheet: 102911d1300809486-concatenate-table-sort-error-concatenate-error
Sheet: TL

ID | SecurityID | Delivery Coupon | Settlement Date | Price | Commitment | BBG Code
0 | FN30 | 5 | 2011-04-13 00:00:00 |  |  |  |  |  | FNCL 5 4/11 Mtge | 100
1 | FN15 | 4 | 2011-04-18 00:00:00 |  |  |  |  |  | FNCI 4 4/11 Mtge | 100.125
2 | FN15 | 3.5 | 2011-04-18 00:00:00 |  |  |  |  |  | FNCI 3.5 4/11 Mtge | 100.25
3 | GN30 | 4.5 | 2011-05-18 00:00:00 |  |  |  |  |  | GNSF 4.5 5/11 Mtge | 100.375
4 | FN30 | 4 | 2011-04-13 00:00:00 |  |  |  |  |  | FNCL 4 4/11 Mtge | 100.5
5 | FN30 | 4.5 | 2011-05-12 00:00:00 |  |  |  |  |  | FNCL 4.5 5/11 Mtge | 100.625
6 | FN30 | 4.5 | 2011-05-12 00:00:00 |  |  |  |  |  | FNCL 4.5 5/11 Mtge | 100.75
7 | FN30 | 4.5 | 2011-04-13 00:00:00 |  |  |  |  |  | FNCL 4.5 4/11 Mtge | 100.875
8 | GN30 | 4.5 | 2011-04-20 00:00:00 |  |  |  |  |  | GNSF 4.5 4/11 Mtge | 101
9 | GN30 | 4.5 | 2011-05-18 00:00:00 |  |  |  |  |  | GNSF 4.5 5/11 Mtge | 101.125
10 | FN30 | 4.5 | 2011-04-13 00:00:00 |  |  |  |  |  | FNCL 4.5 4/11 Mtge | 101.25
11 | FN30 | 4.5 | 2011-05-12 00:00:00 |  |  |  |  |  | FNCL 4.5 5/11 Mtge | 101.375
12 | FN30 | 4.5 | 2011-04-13 00:00:00 |  |  |  |  |  | FNCL 4.5 4/11 Mtge | 101.5
13 | FN15 | 4 | 2011-05-17 00:00:00 |  |  |  |  |  | FNCI 4 5/11 Mtge | 101.625
14 | FN30 | 5 | 2011-05-12 00:00:00 |  |  |  |  |  | FNCL 5 5/11 Mtge | 101.75
15 | GN30 | 4.5 | 2011-04-20 00:00:00 |  |  |  |  |  | GNSF 4.5 4/11 Mtge | 101.875
16 | FN30 | 5 | 2011-05-12 00:00:00 |  |  |  |  |  | FNCL 5 5/11 Mtge | 102
17 | GN30 | 5 | 2011-05-18 00:00:00 |  |  |  |  |  | GNSF 5 5/11 Mtge | 102.125
18 | FN30 | 4.5 | 2011-06-13 00:00:00 |  |  |  |  |  | FNCL 4.5 6/11 Mtge | 102.25
Total
 |  |  |  | original total: | 85807.5
Spreadsheet: 113977d1309860044-extract-the-next-future-date-with-criteria-from-other-column-futuredate2
Sheet: Ark1

[NAME] | 2011-08-01 00:00:00 |  | Today
[NAME] | 2011-06-20 00:00:00
[NAME] | 2011-07-05 00:00:00 |  | Name: | Next future date:
[NAME] | 2011-05-15 00:00:00 |  | [NAME]
[NAME] | 2010-04-13 00:00:00
[NAME] | 2010-09-20 00:00:00
[NAME] | 2010-01-01 00:00:00
Spreadsheet: 477095d1472137162-backwards-vlookup-forum-example
Sheet: Audit

Date | Fixture | Shelf | Position | Title
2016-08-27 00:00:00 | Checklane #1 | 1 | 1
2016-08-27 00:00:00 | Checklane #1 | 1 | 2
2016-08-27 00:00:00 | Checklane #1 | 1 | 3
2016-08-27 00:00:00 | Checklane #1 | 1 | 4
2016-08-27 00:00:00 | Checklane #1 | 2 | 1 | Title 1
2016-08-27 00:00:00 | Checklane #1 | 2 | 2
2016-08-27 00:00:00 | Checklane #1 | 2 | 3
2016-08-27 00:00:00 | Checklane #1 | 2 | 4
2016-08-27 00:00:00 | Checklane #1 | 3 | 1 | Title 2
2016-08-27 00:00:00 | Checklane #1 | 3 | 2
2016-08-27 00:00:00 | Checklane #1 | 3 | 3
2016-08-27 00:00:00 | Checklane #1 | 3 | 4
2016-08-27 00:00:00 | Checklane #1 | 4 | 1
2016-08-27 00:00:00 | Checklane #1 | 4 | 2
2016-08-27 00:00:00 | Checklane #1 | 4 | 3 | Title 3
2016-08-27 00:00:00 | Checklane #1 | 4 | 4 | Title 4
2016-08-27 00:00:00 | Checklane #1 | 5 | 1
2016-08-27 00:00:00 | Checklane #1 | 5 | 2
2016-08-27 00:00:00 | Checklane #1 | 5 | 3
2016-08-27 00:00:00 | Checklane #1 | 5 | 4
2016-08-27 00:00:00 | Checklane #2 | 1 | 1
2016-08-27 00:00:00 | Checklane #2 | 1 | 2
2016-08-27 00:00:00 | Checklane #2 | 1 | 3
2016-08-27 00:00:00 | Checklane #2 | 1 | 4
2016-08-27 00:00:00 | Checklane #2 | 2 | 1
2016-08-27 00:00:00 | Checklane #2 | 2 | 2
2016-08-27 00:00:00 | Checklane #2 | 2 | 3
2016-08-27 00:00:00 | Checklane #2 | 2 | 4 | Title 1
2016-08-27 00:00:00 | Checklane #2 | 3 | 1
2016-08-27 00:00:00 | Checklane #2 | 3 | 2
2016-08-27 00:00:00 | Checklane #2 | 3 | 3
2016-08-27 00:00:00 | Checklane #2 | 3 | 4
2016-08-27 00:00:00 | Checklane #2 | 4 | 1
2016-08-27 00:00:00 | Checklane #2 | 4 | 2
2016-08-27 00:00:00 | Checklane #2 | 4 | 3
2016-08-27 00:00:00 | Checklane #2 | 4 | 4
2016-08-27 00:00:00 | Checklane #2 | 5 | 1
2016-08-27 00:00:00 | Checklane #2 | 5 | 2
2016-08-27 00:00:00 | Checklane #2 | 5 | 3
2016-08-27 00:00:00 | Checklane #2 | 5 | 4
2016-08-27 00:00:00 | Backroom | 1 | 1
2016-08-27 00:00:00 | Backroom | 1 | 2
2016-08-27 00:00:00 | Backroom | 1 | 3
2016-08-27 00:00:00 | Backroom | 1 | 4
2016-08-27 00:00:00 | Backroom | 2 | 1
2016-08-27 00:00:00 | Backroom | 2 | 2 | Title 1
2016-08-27 00:00:00 | Backroom | 2 | 3
2016-08-27 00:00:00 | Backroom | 2 | 4
2016-08-27 00:00:00 | Backroom | 3 | 1
2016-08-27 00:00:00 | Backroom | 3 | 2
2016-08-27 00:00:00 | Backroom | 3 | 3
2016-08-27 00:00:00 | Backroom | 3 | 4
2016-08-27 00:00:00 | Backroom | 4 | 1
2016-08-27 00:00:00 | Backroom | 4 | 2
2016-08-27 00:00:00 | Backroom | 4 | 3
2016-08-27 00:00:00 | Backroom | 4 | 4
2016-08-27 00:00:00 | Backroom | 5 | 1
2016-08-27 00:00:00 | Backroom | 5 | 2
2016-08-27 00:00:00 | Backroom | 5 | 3
2016-08-27 00:00:00 | Backroom | 5 | 4
Spreadsheet: 888726d1739298091-looking-for-formula-to-calculate-eligibility-date-chrisdon23-bsb-1-
Sheet: Sheet1

Name | Date Boots Bought | Amount
[NAME] | 2022-01-01 00:00:00 | 200
Mungo | 2022-02-01 00:00:00 | 500
Midge | 2022-01-02 00:00:00 | 250 |  |  |  |  |  | Next Eligible For Boots
[NAME] | 2023-01-03 00:00:00 | 295 |  |  |  |  | [NAME]
Mungo | 2024-02-01 00:00:00 | 500 |  |  |  |  | Midge
Midge | 2023-01-02 00:00:00 | 260 |  |  |  |  | Mungo
[NAME] | 2024-01-04 00:00:00 | 250
Midge | 2024-01-03 00:00:00 | 270