tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 91002d1290685242-vlookup-with-multiple-values-test
Sheet: Pattern Equipment

Precision Disc Castings LTD |  |  |  |  | Master Information Record
 | Part No. | 12244 |  |  |  | Tooling Ref. | AM054F |  | Casting Weight |  | Kgs |  |  |  |  | PATT SHOP
 | Customer. |  |  |  |  | Drg/lss.No. |  |  | Casting Wt./Mld |  | Kgs |  |  |  |  | FETT SHOP
 | Material. |  |  |  |  |  |  |  | Yield |  | % |  |  |  |  | CORE SHOP
q | Cust. Spec |  |  |  |  |  |  |  | Castings/Mould
PATTERN EQUIPMENT
[NAME] |  | Equipment |  | AM Number |  | Rack Number |  | Department
 |  |  |  |  |  |  |  | PATT SHOP
PATTERN EQUIPMENT NOTES
qDenotes Customer Significant Characteristic |  |  |  |  |  | pDenotes PDC Significant Characteristic
(WHEN PRINTED) THIS IS AN UNCONTROLLED DOCUMENT
Spreadsheet: 111116d1307585057-last-12-entries-last-12-entries-w-sum
Sheet: Calculation

First 4 Entries Total is | 218,266,610.00
Date | Net Asset | Investment Income |  |  |  | Expenses |  |  |  |  |  |  |  | Unrealized Gain/Loss | Realized Gain/Loss
2010-06-30 00:00:00 | 1000000 | 1472168 | 210 | 0 | 0 | 743327 | 0 | 504540 | 1200 | 10 | 540450 | 4054 | 20450 | 109705 | 0
2010-07-01 00:00:00 | 10000000 | 2837985 | 0 | 0 | 0 | 974004 | 154000 | 201 | 0 | 0 | 0 | 0 | 0 | 1052967 | 545400
2010-07-02 00:00:00 | 2222050 | 4437335 | 0 | 0 | 0 | 979316 | 350000 | 0 | 0 | 0 | 0 | 0 | 0 | 597717 | 518130
2010-07-03 00:00:00 | 205044560 | 5127171 | 0 | 0 | 0 | 991460 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 748375 | 492223.5
2010-07-04 00:00:00 | 2005460000 | 6612000 | 0 | 0 | 0 | 997000 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 673537.5 | 467612.325
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 781563d1653416853-averageif-across-multiple-sheets-q1-agents-metrics-copy
Sheet: Agents

Agent | Session | System | Working | Wrap | Idle | Talk In | Talk Out | Set | Holds | Tot. Talk |  |  |  |  |  | Week 1 | <--- you can always make this list somewhere else
LESLEY BROWN |  |  |  |  |  |  |  |  |  |  |  | <-- used this as a test |  |  |  | Week 2 | just make sure to update the named range
LESIA HAWKINS |  |  |  |  |  |  |  |  |  |  |  | to make sure math worked |  |  |  | Week 3
NICHELLE RAINES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 4
TRICIA CHAMBERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 6
ANNE SLONE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7
PATRICIA CHAMBERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 8
AKIRA CROSS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 9
KIMBERLY BEAVERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 10
EBONY RICHARDSON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 11
PATRICIA WILLYARD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 12
SHIRLEY LYALLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13
AMANDA THOMPSON
CARLY ALLGOOD
[NAME]
KEANDRIA DUBLIN
CHASITY DAVIS
ELLI-GRACE PROVENCE
MIRANDA RICHMOND
JALEAHA ROBINSON
[NAME]
NATASHA WIDEMAN
TRAINER LESLEY
Spreadsheet: 479436d1473356517-need-help-formatting-referencing-cyclic-data-test-data
Sheet: Data Set 2

RPM | Torque
0 | 577
0 | 578
0 | 576
0 | 575
998 | 481
1010 | 477
1019 | 475
1988 | 352
1999 | 350
2005 | 349
2015 | 347
2997 | 235
3002 | 234
3007 | 232
3010 | 231
Spreadsheet: 692395d1598303595-calculating-ticket-age-from-audit-trail-records-sample
Sheet: Sheet1

Reference # | Hops | Date Created | Date Assigned to Other Group | Date Closed | Hosting Ticket Age | Total Ticket Age | Transacting Group | [NAME] | Destination | Status | Initial Assignment | Final Assignment
[NAME] |  | 02/08/2019 10:02 PM | 07/10/2020 04:20 PM | 2020-07-15 05:46:00 |  |  | No Value | Administrator - | To Hosting | Completed | 2020-07-13 01:13:00 | 2020-07-13 01:13:00
[NAME] |  | 02/08/2019 10:02 PM | 07/13/2020 01:13 AM | 2020-07-15 05:46:00 |  |  | Hosting | [NAME] | To Hosting / Jay | Completed | 2020-07-13 01:13:00 | 2020-07-13 01:13:00
[NAME] |  | 02/24/2020 04:26 PM | 07/06/2020 02:34 AM | 2020-07-17 01:13:00 |  |  | Hosting | Cecil | To Hosting / Cecil | Completed | 2020-07-06 02:34:00 | 2020-07-13 02:19:00
[NAME] |  | 02/24/2020 04:26 PM | 07/13/2020 02:19 AM | 2020-07-17 01:13:00 |  |  | Hosting | Amit | To Hosting / Amit | Completed | 2020-07-06 02:34:00 | 2020-07-13 02:19:00
C-000924 |  | 03/27/2020 05:14 AM | 07/24/2020 03:16 AM | 2020-07-30 14:08:00 |  |  | Hosting | [NAME] | To Hosting | Completed | 2020-07-22 01:19:00 | 2020-07-28 06:16:00
C-000924 |  | 03/27/2020 05:14 AM | 07/22/2020 01:19 AM | 2020-07-30 14:08:00 |  |  | Hosting | [NAME] | To Hosting / Jay | Completed | 2020-07-22 01:19:00 | 2020-07-28 06:16:00
C-000924 |  | 03/27/2020 05:14 AM | 07/21/2020 09:41 AM | 2020-07-30 14:08:00 |  |  | No Value | Administrator - | To Hosting | Completed | 2020-07-22 01:19:00 | 2020-07-28 06:16:00
C-000924 |  | 03/27/2020 05:14 AM | 07/28/2020 06:16 AM | 2020-07-30 14:08:00 |  |  | Hosting | [NAME] | To Hosting / Vinny | Completed | 2020-07-22 01:19:00 | 2020-07-28 06:16:00
C-000924 |  | 03/27/2020 05:14 AM | 07/24/2020 06:42 AM | 2020-07-30 14:08:00 |  |  | Hosting | [NAME] | To Hosting | Completed | 2020-07-22 01:19:00 | 2020-07-28 06:16:00
C-000924 |  | 03/27/2020 05:14 AM | 07/24/2020 06:06 AM | 2020-07-30 14:08:00 |  |  | Hosting | [NAME] | To Hosting / Jay | Completed | 2020-07-22 01:19:00 | 2020-07-28 06:16:00
Spreadsheet: 288948d1389357571-sorting-question-trying-to-force-a-row-of-data-to-apper-in-the-wrong-sort-location-excelforumsupersort-2014-01-10-07-34
Sheet: Before Sort

 |  |  | Production ID | ProjectID | Start | Super Sort
 |  |  |  | 4 | 88 | 88
 |  |  |  | 14 | 458 | 123.1
 |  |  |  | 2 | 23 | 23
 |  |  |  | 7 | 56 | 56
 |  |  |  | 15 | 498 | 498
 |  |  | 5 | 1 | 26 | 26
 |  |  |  | 8 | 14 | 14
 |  |  |  | 12 | 16 | 16
 |  |  | 14 | 9 | 123 | 123
 |  |  |  | 10 | 91 | 91
 |  |  |  | 11 | 1 | 1
 |  |  |  | 13 | 236 | 236
 |  |  |  | 5 | 99 | 26.1
 |  |  |  | 6 | 115 | 115
 |  |  |  | 3 | 12 | 12
 |  |  | If you sort this by Super Sort which is a formula that plays off of column F you will get what you see on the "Unique Start Values" Tab
Spreadsheet: 136229d1326484075-rank-formula-and-duplicates-unique_numbers
Sheet: Sheet1

Range |  |  |  | brojeve
20 |  |  |  | 1
6 |  |  |  | 2
10 |  |  |  | 3
13 |  |  |  | 4
12 |  |  |  | 6
2 |  |  |  | 7
11 |  |  |  | 9
10 |  |  |  | 10
13 |  |  |  | 11
15 |  |  |  | 12
11 |  |  |  | 13
11 |  |  |  | 15
9 |  |  |  | 18
10 |  |  |  | 20
1
13
4
1
1
6
7
6
12
9
20
3
10
11
18
Spreadsheet: 182234d1348377917-pivot-dates-not-sorting-september-2012-week-3
Sheet: May - 2012

Actual Production vs Production Capacity
Months | May
Row Labels | Sum of Quantity | Sum of Capacity | Sum of Percentage
10-May | 28552 | 20000 | 1.4276
13-May | 31570 | 20000 | 1.5785
14-May | 47130 | 20000 | 2.3565
15-May | 19758 | 20000 | 0.9879
16-May | 13594 | 20000 | 0.6797
17-May | 18992 | 20000 | 0.9496
1-May | 29962 | 20000 | 1.4981
20-May | 14192 | 20000 | 0.7096
21-May | 12282 | 20000 | 0.6141
22-May | 13096 | 20000 | 0.6548
23-May | 22600 | 20000 | 1.13
24-May | 32272 | 20000 | 1.6136
27-May | 17450 | 20000 | 0.8725
28-May | 16392 | 20000 | 0.8196
29-May | 18380 | 20000 | 0.919
2-May | 29228 | 20000 | 1.4614
30-May | 35666 | 20000 | 1.7833
31-May | 32504 | 20000 | 1.6252
3-May | 33734 | 20000 | 1.6867
6-May | 30728 | 20000 | 1.5364
7-May | 16572 | 20000 | 0.8286
8-May | 25126 | 20000 | 1.2563
9-May | 24664 | 20000 | 1.2332
Grand Total | 564444 | 460000 | 1.227052173913044
Average per day:
Spreadsheet: 472028d1469407880-converting-data-between-tabs-copy-of-department-performance
Sheet: 332082

332082 |  | [NAME]
 |  |  | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week |  |  | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | - |  | 220 | 6.55 |  | 393 | 15.1 |  | 0 | 0
2016-07-10 00:00:00 | - |  | 21 | 1.44 |  | 53 | 3.77 |  | 298 | 10.83
2016-07-17 00:00:00 | -
2016-07-24 00:00:00 | -
2016-07-31 00:00:00 | -
2016-08-07 00:00:00 | -
2016-08-14 00:00:00 | -
2016-08-21 00:00:00 | -
2016-08-28 00:00:00 | -
2016-09-04 00:00:00 | -
2016-09-11 00:00:00 | -
2016-09-18 00:00:00 | -
2016-09-25 00:00:00 | -
2016-10-02 00:00:00 | -
2016-10-09 00:00:00 | -
2016-10-16 00:00:00 | -
2016-10-23 00:00:00 | -
2016-10-30 00:00:00 | -
2016-11-06 00:00:00 | -
2016-11-13 00:00:00 | -
2016-11-20 00:00:00 | -
2016-11-27 00:00:00 | -
2016-12-04 00:00:00 | -
2016-12-11 00:00:00 | -
2016-12-18 00:00:00 | -
2016-12-25 00:00:00 | -
 |  | TOTAL
Spreadsheet: 839100d1691657936-sumif-formula-help-financial-report-2023-season-financial-report
Sheet: Report

PLAYHQ
REIMB
SQ
WAFC
TRO
PHT
[NAME]
UMP
UNI
OTH+
OTH-
SPO
KID
WDL
DEP
GRNT
Spreadsheet: 819467d1677522097-running-countif-between-two-dates-and-other-criteria-countif
Sheet: Sheet1

Order Date | Month Order | Salesperson | Running total per EE per year
2021-01-06 00:00:00 | 2021-01-31 00:00:00 | EE1 | 1
2021-01-07 00:00:00 | 2021-01-31 00:00:00 | EE2 | 1
2022-03-24 00:00:00 | 2022-03-31 00:00:00 | EE3 | 1
2022-04-15 00:00:00 | 2022-04-30 00:00:00 | EE1 | 1
2022-04-17 00:00:00 | 2022-04-30 00:00:00 | EE1 | 2
2022-06-05 00:00:00 | 2022-06-30 00:00:00 | EE3 | 2
2022-06-08 00:00:00 | 2022-06-30 00:00:00 | EE4 | 1
2022-07-21 00:00:00 | 2022-07-31 00:00:00 | EE2 | 1
2022-09-27 00:00:00 | 2022-09-30 00:00:00 | EE1 | 3
2023-01-19 00:00:00 | 2023-01-31 00:00:00 | EE4 | 2
2023-02-05 00:00:00 | 2023-02-28 00:00:00 | EE5 | 1
2023-02-05 00:00:00 | 2023-02-28 00:00:00 | EE5 | 2
Spreadsheet: 3dd86781-c137-458f-be72-bd94d07dbc42
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 12. LEASE FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Transport equipment ; |  |  | Original | A2413515K | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Construction and earthmoving equipment ; |  |  | Original | A2413516L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Agricultural machinery and equipment ; |  |  | Original | A2413517R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Manufacturing equipment ; |  |  | Original | A2413518T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Electronic data processing equipment ; |  |  | Original | A2413519V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Office machines ; |  |  | Original | A2413520C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Shop and office furniture, fittings and equipment ; |  |  | Original | A2413521F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Other goods ; |  |  | Original | A2413522J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413523K | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 02da4ee7-3f72-4728-92d6-e626599c8d66
Sheet: Sheet1

Engineering Technology* | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Associate of Applied Science Degree
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Remedial Courses As Needed |  |  |  | Grade | Semester Taken
010 RDG + 12 DRE - Intro. to [NAME]
020 RDG + 101 GE - Improved College Reading
030 RDG + 101 GE (if not already completed)
090 ENC - Foundations of College Writing I
091 ENC - Foundations of College Writing II
055 MT - Pre-Algebra
065 MT - Elemtary Algebra
120 MT - Intermediate Algebra
General Education Courses (Core Curiculum) |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ENG101 - Writing I |  |  |  |  | 3
Communications Course |  |  |  |  | 3
Mathematics Course (MT 150 or MT 125) |  |  |  |  | 3
Heritage/Humanities Course |  |  |  |  | 3
Social Science Course |  |  |  |  | 3
Physics Course (PHY 171 or higher level) |  |  |  |  | 3-4
Total Gen. [NAME]. Semester Hours |  |  |  |  | 18-19
Technical Core Courses |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ENGT 110 | Circuits I |  |  |  | 5
ENGT 114 | Circuits II |  |  |  | 5
ENGT 210 | Devices I |  |  |  | 5
ENGT 120 | Digital Logic Circuits |  |  |  | 3
CAD 100 | Introduction to Computer Aided Design OR |  |  |  | 3
BRX 120 | Basic Blueprint Reading OR |  |  |  | 3
EET  148 | Electronic Drafting |  |  |  | 3
 | Computer Literacy Course |  |  |  | 3
ET 234 | Computer Hardware Maintenance OR |  |  |  | 3
ET 250 | Programmable Logic Controllers OR |  |  |  | 4
ET 256 | Microprocessors Fundamentals |  |  |  | 4
Total Technical Core Hours |  |  |  |  | 27-29
*This curriculum is to be followed by students entering this program beginning Fall 2005 or after.
Spreadsheet: 679762d1590610828-how-to-calculate-multi-tier-tariff-tier-tariff-calculation
Sheet: Sheet1

 |  |  |  | Unit Cunsumption | 170 Kw
 |  |  | Kw | Amount | Manually calculated Cost
 |  |  | 0-50 | 3.5 | 175
 |  |  | 51-100 | 3.9 | 195
 |  |  | 101-150 | 4.8 | 240
 |  |  | 151-200 | 5.2 | 104
 |  |  | >200 | 6.1
 |  |  |  |  | 714
Spreadsheet: 842209d1694295801-transform-certain-columns-to-rows-based-on-the-values-sample_m-2-
Sheet: Output

Cat | Sub | Add | Add1 | Add2
Exp | [NAME] | LPB | [NAME] | InCo | Percentage? | 0 to 25%
Rev | CM | SPB | [NAME] | InCo | Percentage? | 50 to 75%
Acct | Asst | SPB | [NAME] | Rep | Percentage? | 0 to 25%
Exp | [NAME] | LPB | [NAME] | InCo | Percentage? | 50 to 75%
Rev | CM | SPB | [NAME] | InCo | Time? | Planning
Acct | Asst | SPB | [NAME] | Rep | Time? | Planning
Rev | CM | SPB | [NAME] | InCo | Effort? | Analysis
Exp | [NAME] | LPB | [NAME] | InCo | Effort? | Review
Spreadsheet: 94820d1294584218-extend-index-match-billing-statement1
Sheet: Sales

 |  |  | 0
Inv # | Sold to: | Inv Date | Subtotal | Tax | Total | Received | SALESPERSON | P.O. # | SHIP DATE | SHIP VIA | F.O.B. | TERMS
661 | ABC |  | 100 | 17.5 | 117.5 | 2010-01-01 00:00:00
662 | [NAME] | 2010-09-24 00:00:00 | 200 | 0 | 200 | 2010-08-31 00:00:00
663 | Acme Inc | 2010-10-04 00:00:00 | 100 | 0 | 100
664 | ABC | 2010-10-04 00:00:00 | 100 | 0 | 100
664 | Acme Inc | 2010-10-08 00:00:00 | 745.67 | 0 | 745.67
665 | Acme Inc | 2010-10-08 00:00:00 | 1491.34 | 0 | 1491.34
666 | ABC | 2010-10-08 00:00:00 | 745.67 | 0 | 745.67
667 | ABC | 2010-10-08 00:00:00 | 745.67 | 0 | 745.67
668 | Acme Inc | 2010-10-08 00:00:00 | 1491.34 | 0 | 1491.34
669 | FOSH | 2010-10-12 00:00:00 | 385 | 0 | 385
670 | [NAME] | 2011-01-08 00:00:00 | 16.5 | 0 | 16.5
671 | [NAME] | 2011-01-08 00:00:00 | 16.5 | 0 | 16.5 |  | bill | a3 | 1 | 2 | 3 | 4
Spreadsheet: 823696d1680097738-finding-the-next-latest-date-with-conditions-and-returning-a-lookup-value-example-excel
Sheet: dates with #

ID | date2 | #
10086248 | 2022-06-16 00:00:00 | 1
10086248 | 2022-07-07 00:00:00 | 9
10086248 | 2022-07-14 00:00:00 | 8
10086248 | 2022-07-21 00:00:00 | 7
10086248 | 2022-07-28 00:00:00 | 6
10086248 | 2022-08-04 00:00:00 | 5
10086248 | 2022-08-11 00:00:00 | 4
10086248 | 2022-08-18 00:00:00 | 3
10086248 | 2022-08-25 00:00:00 | 2
10087080 | 2021-08-10 00:00:00 | 1
10087080 | 2021-08-26 00:00:00 | 9
10087080 | 2021-09-01 00:00:00 | 27
10087080 | 2021-09-08 00:00:00 | 26
10087080 | 2021-09-16 00:00:00 | 6
10087080 | 2021-09-23 00:00:00 | 5
10087080 | 2021-09-30 00:00:00 | 4
10087080 | 2021-10-07 00:00:00 | 3
10087080 | 2021-10-14 00:00:00 | 25
10087080 | 2021-10-22 00:00:00 | 24
10087080 | 2021-10-27 00:00:00 | 23
10087080 | 2021-11-04 00:00:00 | 22
10087080 | 2021-11-18 00:00:00 | 21
10087080 | 2021-11-23 00:00:00 | 20
10087080 | 2021-12-02 00:00:00 | 19
10087080 | 2021-12-09 00:00:00 | 18
10087080 | 2021-12-18 00:00:00 | 17
10087080 | 2021-12-21 00:00:00 | 16
10087080 | 2021-12-30 00:00:00 | 15
10087080 | 2022-01-06 00:00:00 | 14
10087080 | 2022-01-13 00:00:00 | 13
10087080 | 2022-01-20 00:00:00 | 12
10087080 | 2022-02-16 00:00:00 | 11
10087080 | 2022-03-24 00:00:00 | 10
10087080 | 2022-03-31 00:00:00 | 2
10087229 | 2022-03-30 00:00:00 | 1
10087229 | 2022-04-20 00:00:00 | 9
10087229 | 2022-04-26 00:00:00 | 27
10087229 | 2022-05-03 00:00:00 | 26
10087229 | 2022-05-10 00:00:00 | 39
10087229 | 2022-05-17 00:00:00 | 38
10087229 | 2022-05-24 00:00:00 | 37
10087229 | 2022-05-31 00:00:00 | 36
10087229 | 2022-06-07 00:00:00 | 35
10087229 | 2022-06-14 00:00:00 | 34
10087229 | 2022-06-21 00:00:00 | 23
10087229 | 2022-06-28 00:00:00 | 33
10087229 | 2022-07-05 00:00:00 | 32
10087229 | 2022-07-12 00:00:00 | 31
10087229 | 2022-07-27 00:00:00 | 19
10087229 | 2022-08-02 00:00:00 | 30
10087229 | 2022-08-09 00:00:00 | 29
10087229 | 2022-08-16 00:00:00 | 16
10087229 | 2022-08-23 00:00:00 | 28
10087229 | 2022-08-30 00:00:00 | 2
Spreadsheet: 787881d1658133308-if-vlookup-and-mod-subtotal-backwards-math-calculation-examplev2-aligw
Sheet: Sheet1

 | CURRENT RESULTS:
 | Item | Current Price | Start to calculate in how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 2 | 2
 | Pears | 15 | 3 | 1
 | Strawberries | 13 | 5 | 1
 | [NAME] | 22 | 2 | 1
 | EXPECTED RESULTS:
 | Item | Current Price | Start to calculate in how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 2 | 2
 | Pears | 15 | 3 | 1
 | Strawberries | 13 | 5 | 0
 | [NAME] | 22 | 2 | 0
 | NOTE: Main formula considers an increase of 10% per year
Spreadsheet: 250191d1373864106-condition-formatting-for-a-negative-number-considers-it-still-positive-wow-characters
Sheet: Lansalot

Item
Spreadsheet: 111500d1307880624-summarising-data-from-multiple-worksheets-cashbook-sample-2
Sheet: Bank Expenditure

Date | Source | Transaction Type | Invoice ref | Bank Ref | Cost Centre | Invoice number | Paid To | Budget Header | Description | Net Amount | VAT amount | Total invoice amount
2011-04-01 00:00:00 | Bank | DD | 001540 |  | OH18PD | MA40384 | [NAME] | Subscriptions | Misc | 18.75
2011-04-04 00:00:00 | Bank | BULKPAY | 000003 | 11120001 | OH18PD | 8745932 | [NAME] | Research & Development | Project A | 250 | 0
2011-04-04 00:00:00 | Bank | BULKPAY | 000016 | 11120001 | _RR11 |  | [NAME] | Previews | Project B | 2000
2007-04-03 00:00:00 | Bank | BULKPAY | 000011 | 11120001 | _RG1112 |  | [NAME] | Research & Development | Books | 24.24 | 0
2007-04-03 00:00:00 | Bank | BULKPAY | 000011 | 11120001 | OH2SU | IBM201734 | [NAME] | Office sundries | Coffee, tea for office | 6 | 0
2007-04-03 00:00:00 | Bank | BULKPAY | 000011 | 11120001 | OH2SU |  | [NAME] | Research & Development |  | 95
2011-04-04 00:00:00 | Bank | BULKPAY | 000002 | 11120001 | _WV1112 |  | [NAME] | Writer Lecturer | Writers fee | 500 | 0
2011-04-04 00:00:00 | Bank | BULKPAY | 000001 | 11120001 | _YPBG1112 |  | [NAME] | Reader in Residence | Fee | 100 | 0
2011-04-04 00:00:00 | Bank | BULKPAY | 000015 | 11120001 | _SE2011 | 14sh934vv | [NAME] | Photography | Project C | 300 | 0
2011-04-04 00:00:00 | Bank | CHQ | 000005 | 6017 | _RR11 | 1112SJKHH2 | The National Trust | Reading Groups | Meetings | 35
2011-04-04 00:00:00 | Bank | CHQ | 000013 | 6018 | _[NAME] |  | [NAME] | Festival | Travel | 211 | 0
2011-04-04 00:00:00 | Bank | CHQ | 000006 | 6019 | _CP1112 |  | [NAME] | Research & Development | Travel | 210
2011-04-04 00:00:00 | Bank | CHQ | 000010 | 6020 | _RR11 |  | [NAME] | Research & Development | Freelance support | 100 | 0
2011-04-04 00:00:00 | Bank | CHQ | 000004 | 6021 | _WV1112 | [NAME] | [NAME] | Accommodation | Writers expenses | 200
2011-04-04 00:00:00 | Bank | CHQ | 000007 | 6022 | _RG1112 |  | [NAME] | Research & Development | Books | 9.26 | 0
2011-04-04 00:00:00 | Bank | CHQ | 000014 | 6023 | OH6PO |  | Digital Communications Limited | Franking machine consumables | Cartridges | 89.02 | 0
2011-04-05 00:00:00 | Bank | D/D |  |  | OH12TF |  | Vodafone | Telephone & Broadband | April | 142.97 | 0
2011-04-11 00:00:00 | Bank | SO |  |  | OH17DC |  | Inovica | Website hosting | Website.com | 66
2011-04-14 00:00:00 | Bank | D/D |  |  | OH13BC |  | Barclays Bank | Service Charges | Fees | 26.98 | 0
2011-04-15 00:00:00 | Bank | SO |  |  | _YW1112 |  | [NAME] | Workshops | April | 200 | 0
2011-04-15 00:00:00 | Bank | DD |  |  | _SE2011 | 346580 | Travelodge | Accommodation | Guest accommodation | 696.62 | 139.3
2011-04-15 00:00:00 | Bank | CHQ |  | 6024 | OH1PC |  | Cash | Petty Cash | Cash | 100 | 0
2011-04-15 00:00:00 | Bank | BULKPAY |  | 2 | OH15SAL |  | [NAME] | Deputy Director | April | 2196.31 | 0
Spreadsheet: 144383d1330962329-button-to-change-cell-contents-formulas-flowers-for-excelhelp
Sheet: Main

Flower | Budget 1 | Budget 2 | As a % | Budget 1a | Budget 2a | As a %a
Roses
Tulips
Posies
Weddings
Church
Funerals
Snap Dragons
Total
Current Budget 1/2 | 0.1
Current Budget 1a/2a | 0.02
The idea here would be to have a button over to one side (or the bottom) that could change the data in the fields above to calculate different metrics (say I only wanted Weddings, Church and Funerals) and then possibly pull data from the budgets sheet.  I'm also realizing that if was possible to have a drop down box to choose different options (I may need like 12 variations) that could be useful as well. Whomever looks that this, thanks!  I'm not looking for a perfect solution, just more of direction or an example of what it might look like so that I can extrapolate on that.
Spreadsheet: 834519d1687881534-extract-data-with-conditions-filter-example-multiple-variations-v2
Sheet: data

PRODUCT CODE | PRODUCT NAME | 1Y | 3Y | 5Y | L1 | L2 | VALUE | EXCLUDED
AAA |  | 1 | 2 | 3 | [NAME] | IGH | 100 | No
BBB |  | 4 | 5 | 6 | FM | IGH | 200 | No
CCC |  | 7 | 8 | 9 | [NAME] | IGH | 300 | Yes
DDD |  | n/a | n/a | n/a | FM | ICJ | 400 | No
EEE |  | 13 | 14 | 15 | FM | IGH | 500 | No
FFF |  | 16 | 17 | 18 | FM | ICJ | 600 | No
GGG |  | 19 | n/a | n/a | [NAME] | IGH | 700 | No
HHH |  | 22 | 23 | 24 | FM | ICJ | 800 | Yes
III |  | n/a | n/a | n/a | [NAME] | IGH | 900 | No
JJJ |  | 28 | 29 | 30 | [NAME] | IGH | 1000 | No