tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 119334d1314325173-formula-to-return-the-values-in-the-attached-sheet-sheet1dates
Sheet: Sheet1

2011-08-04 00:00:00 |  | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W
Tower | NAME | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
Net | Y | 5 | 5 | WO | 1 | 1 | 1 | 1 | 1 | WO | WO | 4 | 4 | 5 | 5 | 5 | WO | WO | 1 | 1 | 1 | 1 | 1 | WO | WO | 4 | 5 | WO | WO | 4 | 4 | 5
Spreadsheet: vkaminski__40976__Example
Sheet: GREEN BAY

 |  | YEAR | HDDs | PAYOUT
 |  | 1961 | 7778.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALL | 2
 |  | 1962 | 7614 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT
 |  | 1963 | 7130
 |  | 1964 | 7674.5
 |  | 1965 | 7167.5
 |  | 1966 | 7421
STRIKE = | 6715 | 1967 | 7169.5
NOTIONAL = | 5650 | 1968 | 7447
LIMIT = | 2000000 | 1969 | 7853.5
 |  | 1970 | 7837
 |  | 1971 | 7690.5
 |  | 1972 | 6958.5
 |  | 1973 | 7131
 |  | 1974 | 7513.5
 |  | 1975 | 6974.5
 |  | 1976 | 8120.5
 |  | 1977 | 8105
 |  | 1978 | 8194
 |  | 1979 | 7261
 |  | 1980 | 7214.5
 |  | 1981 | 7833
 |  | 1982 | 6815
 |  | 1983 | 7545
 |  | 1984 | 7072.5
 |  | 1985 | 7597.5
 |  | 1986 | 6632
 |  | 1987 | 7365.5
 |  | 1988 | 7518.5
 |  | 1989 | 7002.314814814816
 |  | 1990 | 6841.151785714285
 |  | 1991 | 6949.5
 |  | 1992 | 7326
 |  | 1993 | 7444.25
 |  | 1994 | 6567.5
 |  | 1995 | 7881.5
 |  | 1996 | 7588.5
 |  | 1997 | 6496
 |  | 1998 | 6494.5
 |  | 30 YEAR
 |  | 20 YEAR
 |  | 10 YEAR
 |  | 5 YEAR
Spreadsheet: 686321d1594497564-how-to-insert-a-hyperlink-based-on-finding-text-in-a-cell-sample
Sheet: Sheet1

HG | 1070-1 | X-001 | 20 | y | 90703 |  | 548728 |  | n | dg | MG
HG | 1070-1 | X-002 | 20 | y | 548728 |  | 90703 |  | n | AA | DM
HG | 1070-1 | X-003 | 20 | y | tl10025717 |  | 90703 |  | n | AA | DM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90703 | Documents\Jobs\800227\mtr\MTR\90703.pdf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tl10025717 | Documents\Jobs\800227\mtr\MTR\tl10025717.pdf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 548728 | Documents\Jobs\800227\mtr\MTR\548728.pdf
Spreadsheet: 35937d1233660150-validating-multiple-checks-doublevalidation
Sheet: Sheet1

23 | Vendor1 |  | No | [NAME] | Problem2
45 | Vendor2 |  | 1 | 590
78 | Vendor3 |  | 1 | 998
80 | Vendor5 |  | 1 | 999
 |  |  | 2 | 1000
 |  |  | 2 | 1001
 |  |  | 2 | 1002
 |  |  | 3 | 2000
 |  |  | 3 | 2001
 |  |  | 3 | 2002
Spreadsheet: 50500d1249950181-text-to-colomn-help-needed-excel-forum-help
Sheet: Roan

From Cell | From Sector | Sector IS NBR (Y/N) | To_Cell_Channel (Channel:Not NBR) | To_Sector_PN Offset (Not NBR) | To_Active IP | Soft_Add_Complete | Soft_Add_Attempt | [NAME] | Soft_Drop_Attempts | Hard_Add_Complete | Hard_Add_Attempt
2 | 1 | Y | 2 | 2 | 10.33.24.4 | 1 | 2 | 1 | 1 | 0 | 0 | Y | 2 | 3 | 10.33.24.4 | 0 | 0 | 1 | 1 | 0 | 0 | Y | 32 | 2 | 10.33.24.4 | 2 | 2 | 0 | 0 | 0 | 0 | Y | 33 | 3 | 10.33.24.4 | 5 | 5 | 0 | 0 | 0 | 0 | Y | 202 | 1 | 10.33.24.4 | 1 | 1 | 0 | 0 | 0 | 0 | Y | 220 | 3 | 10.33.24.4 | 3 | 3 | 2 | 2 | 0 | 0 | Y | 221 | 3 | 10.33.24.4 | 0 | 0 | 1 | 1 | 0 | 0
Spreadsheet: cara_semperger__1433__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (14)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | DAILY MIDC =7 LLH, 3 HLH
 |  |  |  |  | Mid Columbia Paths
2001-11-14 00:00:00
 | HLH
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R | 10
 | DAY | 12 | AVISTA(G) AT CHPD-PSPL | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R | 12
 | DAY | 3 | AVISTA(G) AT CHPD-PSPL | X | PINWEST | ENRON | PGE | X |  | 3
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R | 2
 | DAY | 20 | CHPD | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R | 20
 | DAY | 7 | CHPD | X | AVISTA | ENRON | PGE | X |  | 5
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 8

 | Dec 21 |  | Dec 28 |  | Jan 4 |  | Jan 11
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and participant type (value of all trades in milliions of USD), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type 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: kate_symes__18188__EOL 11-10
Sheet: EOL Deals

EOL Deals | From: 11/1/2000   To: 11/10/2000 |  |  | EnPower Deals | From: 11/1/2000   To: 11/10/2000
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 3289800 | 186 |  | EPMI Long Term California | 3106000 | 75
EPMI Long Term Northwest | 1850200 | 129 |  | EPMI Long Term Northwest | 6140500 | 133
EPMI Long Term Southwest | 1235200 | 66 |  | EPMI Long Term Southwest | 3334000 | 78
EPMI Short Term California | 1018640 | 598 |  | EPMI Short Term California | 1566000 | 167
EPMI Short Term Northwest | 337600 | 202 |  | EPMI Short Term Northwest | 526160 | 163
EPMI Short Term Southwest | 1913200 | 419 |  | EPMI Short Term Southwest | 1428000 | 225
Grand Total | 9644640 | 1600 |  | Grand Total | 16100660 | 841
EOL Deals | From: 11/10/2000   To: 11/10/2000 |  |  | EnPower Deals | From: 11/10/2000   To: 11/10/2000
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term Northwest | 93200 | 5 |  | EPMI Long Term Southwest | 28800 | 3
EPMI Long Term Southwest | 41600 | 4 |  | EPMI Short Term Northwest | 21200 | 3
EPMI Short Term Southwest | 25600 | 3 |  | EPMI Short Term Southwest | 50000 | 5
Grand Total | 160400 | 12 |  | Grand Total | 100000 | 11
Spreadsheet: 32cbc554-c98c-4fc2-af2f-1a4a7145f830
Sheet: KFDM NREV Growth bridge

GAAP to Non-GAAP Reconciliation
Net Revenues to Organic Net Revenues Growth
Kraft Foods Developing Markets
For the Twelve Months Ended December 31,
($ in millions, except percentages) ([NAME])
 | As Reported (GAAP) |  | Impact of [NAME] |  | Impact of Acquisitions |  | Impact of Accounting Calendar Changes (1) |  | Impact of Currency |  | Organic (Non-GAAP)
2007 | 0.18 |  | 0.0pp |  | 0.2pp |  | 0.0pp |  | 6.5pp |  | 0.113
2008 | 0.38 |  | (0.1)pp |  | 15.8pp |  | 0.0pp |  | 4.8pp |  | 0.175
2009 | -0.035 |  | (0.5)pp |  | 0.0pp |  | 0.0pp |  | (12.9)pp |  | 0.099
2010 | 0.711 |  | (0.3)pp |  | 59.8pp |  | 1.9pp |  | (0.2)pp |  | 0.099
2011 | 0.162 |  | (0.9)pp |  | 2.9pp |  | 0.1pp |  | 2.9pp |  | 0.112
Compound Annual Growth Rate, 2006 - 2011: | 0.256 |  |  |  |  |  |  |  |  |  | 0.119
(1)  Includes the impacts of accounting calendar changes in 2010 and the impacts of both accounting calendar changes and the 53rd
week of shipments in 2011.
Spreadsheet: 376658d1423673437-indirect-function-on-this-formula-single-cell-array-formulas
Sheet: Sheet12

Sum of the digits of a value
Number | Sum of Digits | Improved Version
132
9
111111
980991
-980991
409
123A6
12
98763023
111111111
Spreadsheet: 551058d1512680773-average-multiple-months-book1
Sheet: Sheet1

Date | Amount | Category |  |  | Clothes |  | Total amount
2017-05-22 00:00:00 | -14.25 | Alcohol |  |  |  | 5 | Number of months where clothes were purchased
2017-03-13 00:00:00 | -51.29 | Apparel |  |  |  |  | Desired result
2017-07-28 00:00:00 | -24.55 | Automotive_Expenses
2017-06-28 00:00:00 | -22.43 | Automotive_Expenses
2017-09-26 00:00:00 | -1 | Charitable_Giving
2017-08-28 00:00:00 | -162 | Child_Care
2017-10-30 00:00:00 | -0.87 | Clothes
2017-10-30 00:00:00 | -2.98 | Clothes
2017-10-30 00:00:00 | -1.38 | Clothes
2017-10-30 00:00:00 | -0.8 | Clothes
2017-10-30 00:00:00 | -0.8 | Clothes
2017-09-26 00:00:00 | -0.79 | Clothes
2017-04-22 00:00:00 | -1.98 | Clothes
2017-04-22 00:00:00 | -3.32 | Clothes
2017-04-22 00:00:00 | -7.87 | Clothes
2017-02-25 00:00:00 | -4.22 | Clothes
2017-02-25 00:00:00 | -1.96 | Clothes
2017-01-28 00:00:00 | -2 | Clothes
2017-05-22 00:00:00 | 100 | Credit_Payment
2017-03-10 00:00:00 | -5.3 | Frivolous
2017-03-10 00:00:00 | -1 | Frivolous
2017-07-28 00:00:00 | -60 | Gifts
2017-10-30 00:00:00 | -2.08 | Groceries
2017-10-30 00:00:00 | -4.92 | Groceries
2017-10-30 00:00:00 | -1.96 | Groceries
2017-09-26 00:00:00 | -0.79 | Groceries
2017-08-27 00:00:00 | -6.24 | Groceries
2017-05-22 00:00:00 | -6.47 | Groceries
2017-04-22 00:00:00 | -0.98 | Groceries
2017-04-22 00:00:00 | -1 | Groceries
2017-02-25 00:00:00 | -5.88 | Groceries
2017-02-25 00:00:00 | -2 | Groceries
2017-02-25 00:00:00 | -2.98 | Groceries
2017-01-28 00:00:00 | -14.72 | Groceries
2017-03-11 00:00:00 | -9.96 | Healthcare_Medical
2017-08-28 00:00:00 | -9.47 | Household
2017-05-22 00:00:00 | -20 | Household
2017-04-22 00:00:00 | -6.98 | Household
2017-04-22 00:00:00 | -19.84 | Household
2017-01-28 00:00:00 | -2 | Household
2017-01-28 00:00:00 | -2 | Household
2017-11-30 00:00:00 | 1538.71 | Income
2017-11-30 00:00:00 | 868.6 | Income
2017-06-29 00:00:00 | 1945.04 | Income
2017-09-26 00:00:00 | -102 | Loans
2017-07-28 00:00:00 | -112.23 | Loans
2017-07-28 00:00:00 | -650 | Loans
2017-06-28 00:00:00 | -112.23 | Loans
2017-05-22 00:00:00 | -70.32 | Pet_Care
2017-11-30 00:00:00 | -5.32 | Qapital
2017-08-27 00:00:00 | -1.1 | Tax
2017-01-28 00:00:00 | -0.66 | Tax
2017-07-28 00:00:00 | -75 | Transfers
2017-06-27 00:00:00 | 25 | Transfers
2017-06-27 00:00:00 | 100 | Transfers
2017-06-27 00:00:00 | -35 | Travel
2017-08-28 00:00:00 | -94 | Utilities
2017-05-22 00:00:00 | -64 | Utilities
Spreadsheet: bc8ea6b1-e43a-4b4e-a29b-5c462250f5ef
Sheet: Legend

Interpro ID | Contained transcription factor [NAME] IDs in the protein
Species Codes | F.verticillioides ([NAME]), F.oxysporum (Foxy), F.circinatum ([NAME]), F.graminearum ([NAME]), [NAME] ([NAME]), [NAME] ([NAME])
Ortholog | Protein with highest identity in the respective organism
BBH | Indicates whether hit is a bidirectional best hit between the two compared species
[NAME].Ratio | Protein identity ratio: identity*overlap/max(protein lengths)
Experimental Conditions | 10%Gln vs. 100%Gln (wt10GLN.wt100GLN) and 5%NO3 vs. 100%NO3 (wt5NO3.wt100NO3)
[NAME] | Fold change between two experimental conditions in log2 scale
[NAME] | Significance of differential expression (False Discovery Rate)
TargetP RC | TargetP RC-Score
TargetP Target | Predicted target by TargetP
Wolfpsort | Predicted compartments by Wolfpsort
SignalP | Classification by SignalP
Spreadsheet: 120832d1315569878-excel-2007-condition-to-add-only-sum-if-a-certain-criteria-is-met-test
Sheet: Sheet1

Name | Phone | ID | Department | Analysis Description | Application | DVM | Priority | Analysis Start Date | Analysis Drop Dead Date | Estimated End Date | [NAME] | Number of Cores | [NAME] [Gbytes]
K.green | 21972957 | u14714 |  | TXWB FTL | PATRAN | Definition |  | 2011-01-01 00:00:00 | 22/01/2011 | 19/01/2011 | Silo 3 | 22 | 20
y.h | 14215 | u21489 |  | TXWB Mk2 | PATRAN | Definition |  | 2011-12-04 00:00:00 | 2011-12-14 00:00:00 | 2011-12-12 00:00:00 | Silo 3 | 144 | 10
T.T | 258 | T14021 | NA | Trent 700 | SC03 | Methods |  | 2011-02-02 00:00:00 | 25/05/2011 | 19/05/2011 | Silo 3 | 512 | 40
j.test | 14215 | u14521 |  | TXWB Mk2 | SC03 | Definition |  | 2011-02-04 00:00:00 | 2011-05-04 00:00:00 | 2011-03-04 00:00:00 | Silo 3 | 768 | 25
K.jo | 14215 | u14521 |  | TXWB Mk2 | SC03 | Definition |  | 2011-02-04 00:00:00 | 2011-05-09 00:00:00 | 2011-04-09 00:00:00 | Silo 1 | 64 | 25
w.w | 142155 | u1452124 |  | TXWB Mk2 | SC03 | Definition |  | 2011-07-07 00:00:00 | 14/08/2011 | 2011-07-08 00:00:00 | Silo 1 | 256 | 20
with these inputted dates in particular for calculate cores, It should surely add up all silo 3 entries as the date range is big enough to select all that's in their?
Calculate Cores |  |  | Calculate Disc Space
Start Date: | 2010-01-01 00:00:00 |  | Start Date: | 2011-12-04 00:00:00
End Date: | 2013-01-01 00:00:00 |  | End Date: | 2011-12-14 00:00:00
Enter Silo Name: | Silo 3 |  | Enter Analysis Description: | TXWB Mk2
Total Cores | 912 |  | [NAME]: | 10
Spreadsheet: 88434d1288264524-vlookup-or-if-statement-needed-751081-vlookup-or-if-statement-needed
Sheet: Sheet1

 | +
 | Item code | Quantity | Weight | Total weight | Sent via
 | bs | 1 | 66 | 66 | Large letter
 | bct | 1 | 2940 | 2940 | Packet
 | ch300 | 2 | 560 | 1120 | packet
 |  | Going out
 |  |  | Quantity | weight in grams
 |  | Large letters
 |  | Packets
 |  | 1st
 |  | ok, don’t laugh there’s no formulas in this one at all could work out how to do it at all. What I’m trying to achieve is add the large letters up (just worked out how to do that now) then add up the packets up but only the ones that weigh less than 2000 and then have the first add up but only the ones that are over 2001. I’ve filled the table out how it should be just don’t know how to get the formula to do thanks in advance for any help/input it greatly appreciated
Spreadsheet: 883408d1732029145-dynamic-drop-down-using-tables-testworkbook-alexhen-
Sheet: Lists

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rng_CostType
 | lst_Status |  | lst_PricingType |  | lst_ChargingApproach |  | rng_LabourRate |  |  |  | Paid |  | lst_InvoiceSelector |  | lst_CostType | lst_CostDetail |  | Prep Table |  | DropDownSample | Filter Sample |  | rng_InvoicePaymentTarget |  |  | rng_Margin |  |  | dd_OpenJobs |  | dd_Tasks |  | lst_SpendType |  | lst_InvoiceOrReceipt
 | Planned |  | Estimate |  | Hourly |  | Date | Hourly | Daily |  | Part |  |  |  | Aggregates | Sand - Building |  |  |  | Electrics |  |  | 0 | Ok |  | date | margin |  |  |  |  |  | Overhead |  | INVOICE
 | Ongoing |  | Quote |  | Daily |  | 2024-09-02 00:00:00 | 20 | 120 |  | Full |  |  |  | Aggregates | Cement |  | Timber |  |  | Fixings |  | 10 | Chase 1 |  | 2024-09-01 00:00:00 | 1.05 |  |  |  |  |  | Customer |  | RECEIPT
 | Completed |  |  |  | Fixed |  | 2025-03-01 00:00:00 | 30 | 150 |  | Not Paid |  |  |  | Aggregates | Sand - Sharp |  | Roofing |  |  | Consumer Units |  | 20 | Chase 2 |  | 2024-10-31 00:00:00 | 1.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aggregates | Post Mix |  | Electrics |  |  | Commissioning |  | 30 | Overdue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aggregates | Scalpings |  | Flooring
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Timber | Planed |  | Windows
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Timber | Tanalised |  | Doors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Timber | Natural |  | Insulation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roofing | Tiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roofing | Felt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roofing | Corrugate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Cables
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Fixings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Consumer Units
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Commissioning
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Floorboards
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Tiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Carpet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Lino
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Substrate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | Frame
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | Fixings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | Locks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doors | Internal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doors | External
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insulation | Board
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insulation | Fibre
Spreadsheet: 176579d1345950728-want-to-get-highest-sales-qty-and-sales-person-name-within-specified-dates-sample-sheet
Sheet: Sheet1

Sales person | Date | Product | Qty
[NAME] | 2012-08-01 00:00:00 | Pen | 10
[NAME] | 2012-08-02 00:00:00 | Pencil | 10
Leo | 2012-08-03 00:00:00 | eraser | 10
Ravi | 2012-08-04 00:00:00 | ruler | 10
[NAME] | 2012-08-01 00:00:00 | books | 10
[NAME] | 2012-08-02 00:00:00 | note books | 10
Leo | 2012-08-03 00:00:00 | Pins | 10
Ravi | 2012-08-04 00:00:00 | Sharpner | 10
[NAME] | 2012-08-01 00:00:00 | Compas box | 10
[NAME] | 2012-08-02 00:00:00 | ruler | 10
Leo | 2012-08-03 00:00:00 | books | 10
Ravi | 2012-08-04 00:00:00 | note books | 10
[NAME] | 2012-08-01 00:00:00 | Pins | 10
[NAME] | 2012-08-02 00:00:00 | Sharpner | 10
Leo | 2012-08-03 00:00:00 | Compas box | 10
Ravi | 2012-08-04 00:00:00 | eraser | 10
I want formula which will give highest sold qty in ( Cell C21) and sales person name in ( Cell D21) after putting the date ranges in cells A21 and B21
 |  | Qty ? | Sale person name ?
2012-08-01 00:00:00 | 2012-08-04 00:00:00
Spreadsheet: 824380d1680532935-query-to-help-compute-depreciation-within-period-depreciate-by-period
Sheet: What i do

Asset | Purchase Price | Depreciation/mth | Depreciation Years | Start Date | End Date | 2021-01-01 00:00:00
Equipment #1 | 30000 |  | 3 | 2021-01-01 00:00:00 |  | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334
 |  |  |  |  | Accumulative
Equipment #2 | 97000 |  | 1 | 2021-03-01 00:00:00 |  |  |  | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333 | 8083.333333333333
 |  |  |  |  | Accumulative
Equipment #3 | 1200 |  | 2 | 2021-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
 |  |  |  |  | Accumulative
Spreadsheet: 540569d1506784975-sum-values-until-the-first-time-a-condition-is-met-sum-to-first-zero-in-cell
Sheet: Sheet1

 | << Sum to first Zero
5 | 6 | 9 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
Put a zero in and cell above and see the sum to first zero change above.
Spreadsheet: 719564d1613726553-index-and-matching-one-ore-more-criteria-pq-zugliste-test-with-slicers-aligw
Sheet: Search

Search criteria:
Container | Liste | Lieferant | Artikelnummer | GAS | T1 | [NAME] | Lot / Info | CH/RS | VZ | Entladen
 |  |  |  |  |  |  |  |  | VZ | 2021-02-18 00:00:00
Search results:
Container | Liste | Lieferant | Artikelnummer | GAS | T1 | [NAME] | Lot / Info | CH/RS | VZ | Entladen
Spreadsheet: 80159d1280365451-excel-2007-looking-for-formula-that-links-corresponding-column-data-example
Sheet: Sheet1

Player | Cost
Manning | 8
[NAME] | 19
Jones | 25
Fitzgerald | 60
Moore | 25
[NAME] | 18
[NAME] | 3
Dude | 3
Dallas | 3
Man | 9
Stud | 10
Beefy | 6
Chalrles | 3
Stewie | 2
Amen | 2
Hiya | 4
Remaining
Highest Bid
Spreadsheet: 99087d1297852115-summing-across-multiple-sheets-summing-sheets
Sheet: SUMMARY

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
NET OPERATING INCOME |  |  | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | <<< SUMMING FROM CHILD SHEETS
ADDITIONAL COSTS |  |  | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | <<< SUMMING FROM CHILD SHEETS
Spreadsheet: 702943d1604625027-dynamic-drop-down-list-data-validation-issue-for-multi-rowed-table-dynamicdropdown-forumsafe-
Sheet: O Locations

Office Name | Associated Region |  | Option One |  |  |  |  | Option Two
A - 1 | 1 |  | Region | Office names |  |  |  | Region_1 | Region_2 | Region_3 | Region_4 | [NAME] | Region_6 | [NAME] | Region_8 | Region_9
B - 1 | 1 |  | 1 | A - 1 | B - 1 | C - 1 |  | A - 1 | D - 2 | G - 3 | I - 4 | L - 5 |  | N - 7 |  | O - 9
C - 1 | 1 |  | 2 | D - 2 | E - 2 | F - 2 |  | B - 1 | E - 2 | H - 3 | J - 4 | M - 5
D - 2 | 2 |  | 3 | G - 3 | H - 3 |  |  | C - 1 | F - 2 |  | K - 4
E - 2 | 2 |  | 4 | I - 4 | J - 4 | K - 4
F - 2 | 2 |  | 5 | L - 5 | M - 5 |  |  |  |  | needs nine named ranges
G - 3 | 3 |  | 6 |  |  |  |  |  |  | Region_1 | ='O Locations'!$I$3:$I$5
H - 3 | 3 |  | 7 | N - 7 |  |  |  |  |  | Region_2 | ='O Locations'!$J$3:$J$5
I - 4 | 4 |  | 8 |  |  |  |  |  |  | Region_3 | ='O Locations'!$K$3:$K$4
J - 4 | 4 |  | 9 | O - 9 |  |  |  |  |  | Region_4 | ='O Locations'!$L17:$L$5
K - 4 | 4 |  |  |  |  |  |  |  |  | [NAME] | ='O Locations'!$M$3:$M$4
L - 5 | 5 |  |  |  |  |  |  |  |  | [NAME] | ='O Locations'!$O$3:$O$3
M - 5 | 5 |  |  | two named ranges: |  |  |  |  |  | Region_9 | ='O Locations'!$Q$3:$Q$3
N - 7 | 7 |  |  | Office_Name | ='O Locations'!$E$3:$G$11
O - 9 | 9 |  |  | Region | ='O Locations'!$D$3:INDEX('O Locations'!$D:$D,COUNTA('O Locations'!$D:$D))