tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 491395d1480450736-vlookup-with-multiple-results-and-multiple-sheets-in-excel-phi_example-v2
Sheet: PO Lines

 | PO Number | Invoice # | Invoice #
 | GPO-0318401 |  |  | This is not correct invoice #
 | GPO-0317061
 | GPO-0317062
 | GPO-0317063
 | GPO-0317064
 | GPO-0317065
 | GPO-0317066
 | GPO-0316201
 | [NAME]
 | GPO-0308851
 | GPO-0308852
 | [NAME]
 | GPO-0308591
 | GPO-0308551
 | GPO-0308541
 | GPO-0306831
 | GPO-0306832
 | GPO-0304991
 | [NAME]
 | [NAME]
 | GPO-0300722
 | GPO-0300723
 | GPO-0300724
 | GPO-0300725
 | GPO-0300726
 | GPO-0297621
 | GPO-0296141
 | GPO-0296131
 | GPO-0295801
 | GPO-0295802
 | GPO-0295803
 | GPO-0295804
 | GPO-0294761
 | GPO-0294762
 | GPO-0294763
 | GPO-0294764
 | GPO-0294765
 | GPO-0294441
 | GPO-0294251
 | GPO-0293571
 | GPO-0293572
 | GPO-0293573
 | GPO-0293574
 | GPO-0293575
 | [NAME]
 | GPO-0293577
 | GPO-0293578
 | [NAME]
 | GPO-02935710
 | GPO-0293461
 | GPO-0293462
 | GPO-0293463
 | GPO-0293464
 | GPO-0293465
 | GPO-0293421
 | GPO-0293401
 | GPO-0293402
 | GPO-0293403
 | GPO-0293404
 | GPO-0293405
 | GPO-0293391
 | GPO-0173021
 | GPO-0173022
 | GPO-0173023
 | GPO-0173024
 | GPO-0173025
Spreadsheet: 853658d1703583765-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised_hans
Sheet: Step2

Search 1 |  | < input field
Search 2 |  | < input field
Search 3 |  | < input field
 |  |  |  | Search1 | Search2 | Search3 |  | 1st Sub | W1 | FM1 | 1st Sub IN | 2nd Sub | 2nd Sub IN | Oqty
Date | Category | [NAME] | TGNo | Party Name | Code | Item Name | Process | IP Length | FW Size | FMC | 1st Part | 2nd Sub | 2nd Sub IN | 2nd Part | HEader18
2023-09-12 00:00:00 | 8C | A-1256 | AC-125/X | Apple Inc | 12563 | Iphone 11 |  | ABC | 440 | 45 | 2563 |  |  | 564 | ABC-DSC/SE
2023-09-12 00:00:00 | MCX-2 | TC-44 | DAC-X/4 | Indian Jones | 6356 | Avatar | XAB | DLC | 636 | 25 | 456 | 256 |  | 636
2023-09-12 00:00:00 | 8C | PC-3458 | BC-125/X | Google Inc | 9781 | X-Watch |  | PLAT | 350 | 61 | 643 |  |  | 6314 | SALA-LA
2023-09-13 00:00:00 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75
2023-09-13 00:00:00 | 8C | A/658 |  | Apple | 2364 | Ultra |  | Disc | 90 | 71 | 479 |  |  | 3641 | MAS/RAKE-45
2023-09-13 00:00:00 | DCV-25 | A/658 | TC-46/6 | Apple Inc | 462 | Apple 13 | MAC | POS | 44 | 12 | 684 | 44 | MS6 | 336
2023-09-13 00:00:00 | 4C | DC/536 | CS-536 | Microsoft | 61364 | [NAME] |  | ABC | 145 | 90 | 634 |  |  | 792 | SALMON-50/TC-15
2023-09-13 00:00:00 | DC-14 | J-44 | AB-463/8 | Edward Co. Pvt | 142 | [NAME] | STIGMA | CCS | 96 | 40 | 634 | 63 | PET | 124
2023-09-13 00:00:00 | MAX-12 | LS-63 | MC-test-36 | Google | 63 | [NAME] | MA-C | MSCX | 102 | 35 |  | 634 | POLY | 63
2023-09-14 00:00:00 | DCV-25 | A/658 |  | Apple | 216 | Iphone 16 | LAS | MC | 26 | 736 | 256 | 12 | MET | 4123
Spreadsheet: 889789d1740705232-gantt-chart-mulitple-due-dates-in-1-line-fund-finance-wa-calendar-test-
Sheet: Tasks

Date | EVENT 01 | EVENT 02 | EVENT 03
2025-01-01 00:00:00 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
 | Asset Management Fee Upload
2025-01-10 00:00:00 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
 | CWA Distributions | AM Fees based on GAV Update
2025-01-24 00:00:00 | PWG Distributions
 | PWG Distributions | Interest Payments Due | [NAME] lodgement
 | PWG Distributions
 | PWG Distributions
 | PWG Distributions | Interest Payments Due | [NAME] lodgement
 | PWG Distributions
 | PWG Distributions
 | PWG Distributions | Interest Payments Due | [NAME] lodgement
 | PWG Distributions
 | PWG Distributions
 | PWG Distributions | Interest Payments Due | [NAME] lodgement
 | PWG Distributions
2025-01-03 00:00:00 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
 | TMS Interest Upload
2025-06-30 00:00:00 | N Ledgers (Swap and revaluation) property movement | Journal import for performance fee
2025-12-31 00:00:00 | N Ledgers (Swap and revaluation) property movement | Journal import for performance fee
2025-01-13 00:00:00 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
 | Fund Summaries Due
2025-03-31 00:00:00 | Line Fees Due
2025-06-30 00:00:00 | Line Fees Due
2025-09-30 00:00:00 | Line Fees Due
2025-12-31 00:00:00 | Line Fees Due
2026-03-31 00:00:00 | Line Fees Due
2026-06-30 00:00:00 | Line Fees Due
2026-09-30 00:00:00 | Line Fees Due
2026-12-31 00:00:00 | Line Fees Due
2025-01-02 00:00:00 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
 | Cash at Bank Report to FMs
Spreadsheet: 150792d1334681308-difficult-making-list-of-unique-values-from-info-in-two-tables-copy-of-excelhelp-custid-to-workorder-list
Sheet: Sheet1

Table 1 |  |  | Table 2 |  |  | Table 3 | NEEDED RESULT
Customer ID | Count--> |  | Customer ID | WorkOrderID |  | Customer ID | WorkorderID
23132 |  |  | 23100 | 36184 |  | 23132 | 36181
23124 |  |  | 23132 | 36181 |  | 23132 | 35973
23100 |  |  | 23100 | 36054 |  | 23132 | 36349
 |  |  | 23132 | 35973 |  | 23132 | 36356
 |  |  | 23132 | 36349 |  | 23132 | 36455
 |  |  | 23132 | 36356 |  | 23124 | 36162
 |  |  | 23100 | 36454 |  | 23124 | 36395
 |  |  | 7284 | 35689 |  | 23124 | 36266
 |  |  | 23124 | 36162 |  | 23100 | 36184
 |  |  | 7773 | 36320 |  | 23100 | 36054
 |  |  | 23132 | 36455 |  | 23100 | 36454
 |  |  | 8155 | 36471 |  | 23100 | 36381
 |  |  | 23124 | 36395
 |  |  | 8344 | 36427
 |  |  | 23124 | 36266
 |  |  | 9686 | 36203
 |  |  | 23100 | 36381
 |  |  | 11298 | 36469
 |  |  | 11485 | 36452
 |  |  | 11485 | 36451
 |  |  | 11689 | 36363
Spreadsheet: 152178d1335279387-drop-down-selection-for-users-dataentry-form
Sheet: Sheet1

 |  |  | Agnostic
 |  |  | Atheist |  |  |  | Pictures | Anointing
 |  |  | Buddhist |  |  |  | Readmission Alert | Holy Communion
 |  |  | Christian (Anglican / Free Church) |  |  |  | Nurse | Prayers for the dying / 'Last Rites'
 |  |  | Christian (Roman Catholic) |  |  |  | Patient | Prayer
 |  |  | Christian  (Other) |  |  |  | Chaplain | Prayer after death
 |  |  | Hindu |  |  |  | [NAME] | Prayer before surgery
 |  |  | Jewish |  |  |  | [NAME] | Advice about funeral
 |  |  | Muslim |  |  |  | Family | Pastoral Support
 |  | ETHB | Sikh |  |  |  | Religious Leader | Staff Support | Yes
 |  | [NAME] | Other |  |  |  | Other | Other | No
Date | Time | Location | Faith | Name of Patient | Chaplain | Ward / Department | Referee | Reason / Action | On Call? | Time with Pt | Total time | Notes
2012-03-24 00:00:00 | 15:34:00 |  |  | [NAME] | AG | H232
Spreadsheet: 129515d1321645818-using-sumproduct-instead-of-countifs-problem-solving-example
Sheet: Sheet1

Source Data |  |  |  |  | Analysis (Expected Results)
Team | Injury Type | Date |  |  | Date Range
Team A | Injury 1 | 2011-11-05 00:00:00 |  |  | 2011-11-01 00:00:00 |  | Injury 1 | Injury 2 | Injury 3
Team B | Injury 2 | 2011-11-04 00:00:00 |  |  | 2011-11-02 00:00:00 | Team A | 2 | 0 | 0
Team C | Injury 3 | 2011-11-04 00:00:00 |  |  | 2011-11-03 00:00:00 | Team B | 0 | 2 | 0
Team D | Injury 1 | 2011-11-03 00:00:00 |  |  |  | Team C | 0 | 0 | 2
Team E | Injury 2 | 2011-11-03 00:00:00 |  |  |  | Team D | 3 | 0 | 0
Team F | Injury 3 | 2011-11-03 00:00:00 |  |  |  | Team E | 0 | 3 | 0
Team A | Injury 1 | 2011-11-03 00:00:00 |  |  |  | Team F | 0 | 0 | 3
Team B | Injury 2 | 2011-11-02 00:00:00
Team C | Injury 3 | 2011-11-02 00:00:00 |  |  | Date range is an input
Team D | Injury 1 | 2011-11-02 00:00:00
Team E | Injury 2 | 2011-11-02 00:00:00
Team F | Injury 3 | 2011-11-01 00:00:00
Team A | Injury 1 | 2011-11-01 00:00:00
Team B | Injury 2 | 2011-11-01 00:00:00
Team C | Injury 3 | 2011-11-01 00:00:00
Team D | Injury 1 | 2011-11-01 00:00:00
Team E | Injury 2 | 2011-11-01 00:00:00
Team F | Injury 3 | 2011-11-01 00:00:00
Spreadsheet: 287730d1388964900-conditional-formatting-for-holidays-ordering-dates-conditional-formating
Sheet: Jan

Date Placed By 12:0 |  | Delivery Required By
 |  | Location A |  | Location B
Day | Date | Day | Date | Day | Date
 | 2013-12-20 00:00:00
 | 2013-12-23 00:00:00
 | 2013-12-24 00:00:00
 | 2013-12-25 00:00:00
 | 2013-12-26 00:00:00
 | 2013-12-27 00:00:00
 | 2013-12-30 00:00:00
 | 2013-12-31 00:00:00
 | 2014-01-01 00:00:00
 | 2014-01-02 00:00:00
 | 2014-01-03 00:00:00
 | 2014-01-06 00:00:00
 | 2014-01-07 00:00:00
 | 2014-01-08 00:00:00
 | 2014-01-09 00:00:00
 | 2014-01-10 00:00:00
 | 2014-01-13 00:00:00
 | 2014-01-14 00:00:00
 | 2014-01-15 00:00:00
 | 2014-01-16 00:00:00
 | 2014-01-17 00:00:00
 | 2014-01-20 00:00:00
 | 2014-01-21 00:00:00
 | 2014-01-22 00:00:00
 | 2014-01-23 00:00:00
 | 2014-01-24 00:00:00
 | 2014-01-27 00:00:00
 | 2014-01-28 00:00:00
 | 2014-01-29 00:00:00
 | 2014-01-30 00:00:00
 | 2014-01-31 00:00:00
Spreadsheet: 672237d1586801465-calculating-based-on-three-or-more-conditions-0_zero-data-sample
Sheet: Sheet1

SKU | OMH120P
Region | East
QTY | 5x
Multiplier |  | This is an array formula. To enter an array formula press CTRL+SHIFT+ENTER instead of just ENTER.
List
Price |  | Calculates price based on three conditions: SKU, Region and QTY and apllies the specific multiplier on the list price (details on sheet "Tables")
Example
IF | SKU | OMH120P
AND | Region | East
AND | QTY | 5x
Multiplier | 1.1
Final Price | 1.1 * 3.86
Spreadsheet: 463a588e-beb6-453d-87ac-add14f00fcc5
Sheet: 172 (2)

EXPLORING MOLECULAR BIOLOGY BIOL 172     tentative schedule Fall 2013
WEEK | DATE |  | Topic
1 | AUG | 20 | INTRO Why biology? Why molecular biology?
 |  | 22 | Macromolecules:  Carbohydrates, Lipids, Proteins, Nucleic Acids Importance of molecular bonds [NAME] of chemical bonds
2 | SEPTEMBER | 3
 |  | 5
3 |  | 10 | EXAM 1
 |  | 12 | Cells & Cell components
4 |  | 17
 |  | 19 | Prokaryotic, Eukaryotic Cells / Viruses
5 |  | 24
 |  | 26
6 | OCTOBER | 1 | ENERGY & METABOLISM
 |  | 3
7 |  | 8 | Mitochondria & Cellular Respiration
 |  | 10
8 |  | 15 | EXAM 2
 |  | 17 | FALL BREAK
9 |  | 22 | Chloroplasts & Photosynthesis
 |  | 24
10 |  | 29 | DNA, RNA components & structure
 |  | 31 | DNA replication
11 | NOVEMBER | 5 | DNA amplification by PCR
 |  | 7 | EXAM 3
12 |  | 12 | Transcription & Translation, Processing of RNA
 |  | 14 | Chromosomes, Genomes & MITOSIS
13 |  | 19 | Cell Cycle
 |  | 21 | Cell Cycle and Cancer
14 |  | 26 | Signal Transduction
 |  | 28 | THANKSGIVING
15 | DEC | 3 | ORAL PRESENTATIONS
 |  | 5
16 |  | Mon 9 | FINAL EXAM 3:15-5:15 pm
Spreadsheet: 167884d1342132963-lookup-formula-using-item-number-excel-two-criteria-search
Sheet: Sheet1

Item |  | Num | Selling
Num | Item Name | Sold | Price
13005 | [NAME] | 151 | 0
13005 | [NAME] | 8 | 17.17
13010 | SOUR-Sauce | 341 | 0
13010 | SOUR-Sauce | 32 | 17.17
13015 | [NAME] | 87 | 0
13015 | [NAME] | 18 | 17.17
 | Total Sold
[NAME] |  | [NAME] to give total sold for BBQ sauce with a selling price
SOUR-Sauce |  | [NAME] to give total sold for SOUR sauce with a selling price
[NAME] |  | [NAME] to give total sold for Honey sauce with a selling price
Spreadsheet: 94910d1294675584-excel-2007-previous-year-as-chart-book-2010
Sheet: consuption

 | r/b | Polyamide type | Length | Jan | Feb | Mar | Apr | Maj | Jun | Jul | Avg | Sep | Okt | Nov | Dec
 | 1 | 14.8 I Black | 6 |  | 1104 | 1248 | 2696 | 3548
 | 2 | 14.8 I Black | 6.5
 | 3 | 14V Black | 6 |  |  | 8
 | 4 | 16I Black | 6 | 140 | 1577 |  | 101 | 556
 | 5 | 10I Black | 6 | 209
 | 6 | 18I Black | 6 | 1060 | 3572 |  | 62 | 1870
 | 7 | 18V Black | 6 |  |  | 216 |  | 482
 | 8 | 18VT Black | 6 | 349 | 1577 |  | 101 | 556
 | 9 | 20V Black | 6.5 | 1081 | 1751 | 1635 | 549
 | 10 | 20VT Black | 6.5 | 1081 | 1751 | 1635 | 549
 | 11 | 20V Black | 6 | 3157 | 4793 | 4146 | 4741
 | 12 | 20VG Black | 6
 | 13 | 20VT Black | 6 | 1948 |  | 4146 | 4741
 | 14 | 24V Black | 6 | 7962 | 7534 | 15330 | 9492
 | 15 | 24V Black | 6.5 | 1348 | 3704 | 3534 | 250
 | 16 | 22I Black | 6 | 392 | 233 | 155
 | 17 | 34 CEL | 6 |  | 63 | 104
 | 18 | 34V2T | 6 |  | 105 | 104 | 26
 | 19 | 38V2TN | 6 |  | 350
 | 20 | 38V Black | 6
 | 21 | 22I Black | 6.5
 | 22 | 24ΩU Black | 6.5
 |  | Total per months
Spreadsheet: joe_parks__14936__BridgeDPR0417
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1282.1420932 | 1282.1420932 | 6573.1420932
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1282.1420932 | 1282.1420932 | 6573.1420932
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 0c26a43b-0ec3-43a9-be53-fc074bdef693
Sheet: TC

New ID Ff | FFUJ | FMAN | FCIRG | FVEG | FOXG | FGSG MIPS | FGSG Broad | Fs | Product
DTC1 | FFUJ_11802 | DTC1 | FCIRG_06985 | FVEG_10718 | FOXG_12144 | FGSG_03066 |  | n.d. | carotenoids
DTC2 | FFUJ_14336 | DTC2 | FCIRG_05400 | n.d. | n.d. | n.d. |  | n.d. | gibberellins
[NAME] | FFUJ_00036 | [NAME] | FCIRG_02712 | FVEG_00016 | n.d. | [NAME] |  | n.d.
STC3 | FFUJ_04067 | STC3 | FCIRG_04852 | FVEG_03771 | FOXG_05900 / FOXG_05901 | n.d. |  | n.d.
STC5 | FFUJ_11739 | STC5 | FCIRG_00171 | n.d. | FOXG_12225 | FGSG_08181 |  | n.d.
STC6 | FFUJ_12585 | STC6 | [NAME] | FVEG_13850 | FOXG_13565 | FGSG_11327 |  | n.d. | caryophylene
STC2 | FFUJ_00969 | STC2 | FCIRG_14668 | FVEG_00910 | n.d. | FGSG_15742 | FGSG_00451 | n.d.
STC4 | FFUJ_10353 | STC4 | FCIRG_06606 | FVEG_13707 | FOXG_16522 | FGSG_03494 |  | n.d. | acorenol
[NAME] | FFUJ_12026 | [NAME] | FCIRG_00876 | FVEG_10529 | FOXG_11949 | n.d. |  | n.d.
STC8 | FFUJ_09423 | STC8 | n.d. | FVEG_10174 | n.d. | n.d. |  | n.d.
STC9 | n.d. | n.d. | n.d. | n.d. | n.d. | FGSG_10397 |  | n.d. | longiborneol
 | 10 | 10 | 9 | 8 | 6 | 7 (1 unique)
Spreadsheet: 769358d1645497101-manufacturing-schedules-copy-of-example
Sheet: Folha1

Schedule of Machine 1
 | Morning |  | Afternoon
Monday | 09:00:00 | 00:00:00 | 13:00:00 | 18:00:00
Tuesday | 09:00:00 | 00:00:00 | 13:00:00 | 18:00:00
Wednesday | 09:00:00 | 00:00:00 | 13:00:00 | 18:00:00
Thursday | 09:00:00 | 00:00:00 | 13:00:00 | 18:00:00
Friday | 09:00:00 | 00:00:00 | 13:00:00 | 17:00:00
Orders | Time of production (hours) | Start time | Production end time
Customer 1 | 2 | 09:00:00
Customer 2 | 16
Customer 3 | 30
Spreadsheet: 854597d1704413558-use-last-cell-address-in-formula-use-last-cell-address-in-formula
Sheet: Sheet1

Corn
40
61 |  |  |  |  |  |  |  |  | 61
64 |  |  |  |  |  |  |  |  | 64
119 |  |  |  |  |  |  |  |  | 119
200 |  |  |  |  |  |  |  |  | 200
219 |  |  |  |  |  |  |  |  | 219
145 |  |  |  |  |  |  |  |  | 145
143 |  |  |  |  |  |  |  |  | 143
86 |  |  |  |  |  |  |  |  | 86
229 |  |  |  |  |  |  |  |  | 229
57 |  |  |  |  |  |  |  |  | 57
55 |  |  |  |  |  |  |  |  | 55
225 |  |  |  |  |  |  |  |  | 225
90 |  |  |  |  |  |  |  |  | 90
61 |  |  |  |  |  |  |  |  | 61
217 |  |  |  |  |  |  |  |  | 217
102 |  |  |  |  |  |  |  |  | 102
282 |  |  |  |  |  |  |  |  | 282
147 |  |  |  |  |  |  |  |  | 147
Spreadsheet: 884728d1733983740-find-data-within-a-dynamic-range-calendar-feed
Sheet: data

 | 2025-03-21 00:00:00
 | ID | Project | Review |  | 2025-03-21 00:00:00 |  |  |  |  | 2
 | P0404 | Project AAA | R5 |  | 2025-03-21 00:00:00 |  |  |  |  | 3
 | P0562 | Project AAB | R7 |  | 2025-03-21 00:00:00 |  |  |  |  | 4
 | P0578 | Project CGA | R7 |  | 2025-03-21 00:00:00 |  |  |  |  | 5
 |  |  |  |  | 00:00:00
 | 2025-03-07 00:00:00 |  |  |  | 2025-03-07 00:00:00
 | ID | Project | Review |  | 2025-03-07 00:00:00
 | P0702 | Project MRG | R7 |  | 2025-03-07 00:00:00
 | P0573 | Project RSA | R6 |  | 2025-03-07 00:00:00
 |  |  |  |  | 00:00:00
 | 2025-02-04 00:00:00 |  |  |  | 2025-02-04 00:00:00
 | ID | Project | Review |  | 2025-02-04 00:00:00
 | P0509 | Project HRD | R7 |  | 2025-02-04 00:00:00
 | P0573 | Project RSA | R5 |  | 2025-02-04 00:00:00
 |  |  |  |  | 00:00:00
 | 2024-12-18 00:00:00 |  |  |  | 2024-12-18 00:00:00
 | ID | Project | Review |  | 2024-12-18 00:00:00
 | P0404 | Project AAA | R4 |  | 2024-12-18 00:00:00
 | P0573 | Project RSA | R4 |  | 2024-12-18 00:00:00
 | P0206 | Project MES | R5 |  | 2024-12-18 00:00:00
 | P0702 | Project MRG | R6 |  | 2024-12-18 00:00:00
Spreadsheet: 714607d1611306936-trades-needed-in-sheet-2-testsubject
Sheet: Sheet2

Trade Number | Date Iniated | Date Terminated | Buy Price | Sell Price | Profit/loss | Period Held in days
1 | 2010-11-11 00:00:00 | 2010-11-23 00:00:00 | 6.54 | 6.67 |  | 12
2 | 2010-11-26 00:00:00 | 2010-11-30 00:00:00 | 6.4 | 6.15 |  | 4
3 | 2010-12-07 00:00:00 | 2010-12-10 00:00:00 | 6.53 | 6.34 |  | 3
Spreadsheet: 707207d1607097085-how-to-return-results-of-a-top-5-lowest-price-top-5-highest-price-and-price-difference-clean-data
Sheet: NEW ZEALAND

Country | NEW-ZEALAND
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | Cochlear | MedEL | OM
Antenna cable |  |  | 58.51
Charger | 57.92489999999999
Full swim kit |  | 32.18049999999999
Swim sleeve kit | 35.10599999999999 |  | 46.80799999999999
Country | NEW-ZEALAND
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | AB | Cochlear | MedEL | OM
[NAME] |  |  | 345.2089999999999
Full swim kit | 295.4755
Recheargable battery |  |  | 526.5899999999999
Streamer (outside sound processor) |  |  |  | 438.825
Wireless Mic |  | 296.0606
Country | NEW-ZEALAND
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | AB | Cochlear | MedEL | OM
[NAME] | 8.776499999999999 |  | 228.7741 | 3.510600000000011
Antenna cable | -77.52574999999999 |  | -43.2974 | -57.92489999999999
Charger | 85.71715 |  | -26.03694999999999 | 102.68505
Drying kit | -14.04239999999999 |  | -8.776499999999999 | 2.9255
Full swim kit | 3.510599999999954 |  | -259.7844 | -291.9649
Recheargable battery | -142.06228 |  | 260.3695 | -35.10599999999997
Swim antenna + cable | -146.275 |  | -146.275 | 0
Swim sleeve kit | -35.10599999999999 |  | -35.10599999999999 | 11.702
Wireless Mic | -296.0606 |  | -296.0606 | -105.9031
[NAME] | 0 |  | 0 | 146.275
Wireless TV | 0 |  | 0 | 146.275
Spreadsheet: 101102d1299255423-trying-to-return-a-year-to-date-amount-offset-tutorial
Sheet: OFFSET tutorial

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | www.thefinancialmodeler.com
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Function Tutorial
 |  | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFFSET
 |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This tutorial shows how the range returned by the OFSSEt formula is affected by diffent input.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The following formats are automatically applied
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference cell
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cells included in the resulting range
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note: Formatting is set up only for the range $A$1:$U$38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inputs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Structure
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference | B2 | Reference from which you want to base the offset
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rows | 1 | Number of rows to offset
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columns | 1 | Number of columns to offset
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Height (Optional) | 2 | Height of the offset. A positive value will heighten the range to the bottom of the reference
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Width (Optional) | 2 | [NAME] of the offset. A positive value will widen the range to the right of the reference
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Examples
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example #1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Returns #[NAME]! Because the resulting range has more than one cell (height or width = 1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example #2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result | 10
Spreadsheet: 8872ca68-e1c5-4c2a-855a-a81eccbc1818
Sheet: Sheet1

Securities | % of Assets
Veresen Inc. | 3.25%
Baytex Energy Corp. | 3.04%
Canadian Oil Sands Ltd | 3.00%
Crescent Point Energy Crp | 2.99%
Capital Power Corp | 2.88%
BCE Inc. | 2.64%
Northland Power Inc | 2.60%
Enbridge Income Fund Hld | 2.59%
National Bank of Canada | 2.45%
Freehold Royalties Ltd | 2.36%
Pembina Pipeline Inc | 2.33%
Bank of Montreal | 2.27%
Great-West Life Company | 2.26%
Emera Inc. | 2.25%
Keyera Corp | 2.24%
Cdn Imperial Bk of Commrc | 2.23%
Inter Pipeline Ltd. | 2.22%
Rogers Communications Inc | 2.21%
TransCanada Corp. | 2.19%
IGM Financial Inc. | 2.17%
Power Financial Corp. | 2.15%
Power Corporation Canada | 2.11%
Fortis Inc. | 2.08%
Royal Bank of Canada | 2.07%
Shaw Communicatn Cl B Nvs | 2.04%
Bank of Nova Scotia | 2.03%
Thomson Reuters Corp | 2.01%
Sun Life Financial Inc. | 1.99%
Potash Corp of Saskatchwn | 1.96%
Toronto-Dominion Bank | 1.88%
[NAME] Cl B Nvs | 1.88%
TELUS Corp. | 1.84%
Transcontinental Inc Cl A | 1.81%
ARC Resources Ltd | 1.77%
Mullen Group Ltd. | 1.69%
AGF Management Ltd Cl B | 1.67%
Vermilion Energy Inc. | 1.62%
Wajax Corporation | 1.57%
Cineplex Inc. | 1.56%
Genworth MI Canada Inc | 1.56%
Husky Energy Inc. | 1.54%
Enbridge Inc. | 1.53%
CI Financial Corp | 1.43%
Brookfield Property Ptner | 1.35%
Dorel Industries Inc Cl B | 1.25%
First Capital Realty Inc | 1.23%
Aimia Inc. | 1.22%
Ensign Energy Srvcs Inc | 1.05%
Teck Resources Ltd Cl B | 1.00%
Canexus Corporation | 0.69%
Cash | 0.26%
Total Holdings in Portfolio | 51