tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 790704d1659959787-cell-adds-one-to-last-entry-used-depending-on-selection-animal-name
Sheet: Sheet2

Animal |  | Animal ID
Addax |  | XAS
Beagle |  | ALM
[NAME] |  | ASD
[NAME] |  | QWE
Ermine |  | FFF
Flamingo |  | EAS
[NAME] |  | UEN
Hyaenodon |  | OOO
Ibis |  | LSY
Jackdaw |  | KWC
Kiwi |  | ERT
[NAME] |  | BBB
Mongoose |  | MZT
Narwhal |  | EOL
Okapi |  | OKA
Ptarmigan |  | PTA
[NAME] |  | QQQ
Rhinoceros |  | UUU
Starfish |  | FTE
Termite |  | RSN
Uintatherium |  | JME
Vizsla |  | ZZZ
Wallaby |  | QYX
Xerus |  | IAM
[NAME] |  | TVA
Zuchon |  | DEW
Spreadsheet: 734285d1622090202-im-trying-to-return-the-5-smallest-values-that-meet-certain-criteria-book-1-2-
Sheet: B.E. Jr's

[NAME]: |  |  |  |  |  |  | [NAME] RANK:
B.E. | Test Review Ends at 1:30 pm
Test |  |  |  |  |  | Showmanship
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Horsemanship |  |  |  |  |  | Ranch Riding
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Barrels |  |  |  |  |  | Poles
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Time | Ribbon | Points
1 |  | 17.576 | B | 15 |  | 1
2 | Sydney Opeikens | 19.116 | B | 15 |  | 2
3 | [NAME] | 21.262 | R | 10 |  | 3
4 | [NAME] | 21.267 | R | 10 |  | 4
5 | [NAME] | 25.204 | W | 5 |  | 5
6 | [NAME] | 25.892 | W | 5 |  | 6
7 | [NAME] | 29.354 | W | 5 |  | 7
8 | [NAME] | 31.16 | W | 5 |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Keyhole |  |  |  |  |  | Portfolio
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Score | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Bonus Top 5 Total Points:
 | TOTAL points for all Box Elder County members:                  (This is NOT the top 5 team points) |  |  |  |  |  | Maximum event points possible is 75                                                   Maximum team points possible is 600
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 18

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
18 | 2007-02-16 00:00:00 | 7.5 | 1.48 | 7.6 | 2.6 | 6.1 | 4.8 |  |  |  | 8 |  | 3.819968175619412 | 3.6 | 0 | 7 |  |  |  |  | 0.6
MTTR Well 18A  1200gpm | 2012-03-29 00:00:00 | 8 | 1.94 | 8.73 | 3.27 | 6.4 | 6.2 |  |  | 1.1 | 11 |  | 2.6 | 7 | 0.04 | 5 |  | <0.01 | <0.01 |  | 1.3
Well #18 | 2013-10-11 00:00:00 | 7.4 | 2.08 | 8.85 | 3.24 | 6 | 6.2 |  |  | 1 | 13.6 |  | 2.5 | 6.5 | 0.04 | 3.2 |  | <0.10 | <0.02 |  | 0.6
Well - 18 | 2014-01-27 00:00:00 | 8 | 2.1 | 10.33 | 3.8 | 7.5 | 5.9 |  |  | 1 | 14.1 |  | 2.8 | 7.6 | 0.03 | 4.5 |  | <0.10 | <0.02 |  | 1.3
Well 18 | 2016-04-01 00:00:00 | 7.97 | 2.218 | 10.63 | 3.85 | 6.9 | 5.774918072096555 | 5.774918072096555 | 0 | 1.15 | 15.748 | 1420.8 | 2.56 | 6.51 | 0.042 | 3.6235 | 0.024 | 0 | 0.011 | 0.039
W18 | 2018-05-29 00:00:00 | 7.87 | 2.23 | 12.7 | 4.62 | 8.74 |  | 5.597074574374552 | 0 | 1.45 | 9.616 | 1427.2 |  |  | 0.057 | 6.29 | 0.052 | 0 | 0 | 0.007
Spreadsheet: 267597d1380118867-using-tables-contraload-deliveries-into-purfleet
Sheet: Data

Tool | Order Reference | Production Date |  | Qty | 13985 | 14138 | 14139
Spreadsheet: 876842d1723555891-function-similiar-to-sumproduct-an06-task-copy-tms
Sheet: needed function

Group 1
Group 2
Group 3
Group 4
Spreadsheet: 772752d1647453785-gantt-chart-drop-down-box-help-needed-fake-data
Sheet: Gantt Chart

 |  |  |  | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00
Tuesday | Time In | Time Out
[NAME]
[NAME]
Chrissy
Spreadsheet: 8760a3f5-12b4-4e52-b039-25b1f41c9a9b
Sheet: Operating stats

The NASDAQ OMX Group, Inc.
Quarterly Key Drivers Detail
(unaudited)
 |  | Three Months Ended
 |  | December 31, |  | September 30, |  | December 31,
 |  | 2009 |  | 2009 |  | 2008
Market Services
 | Cash Equity Trading
 | NASDAQ securities
 | Average daily share volume (in billions) | 2.06 |  | 2.25 |  | 2.32
 | Matched market share executed on NASDAQ | 0.311 |  | 0.304 |  | 0.428
 | Matched market share executed on NASDAQ OMX BX | 0.027 |  | 0.02 |  | 0
 | Market share reported to the FINRA/NASDAQ
 | Trade Reporting Facility(1) | 0.38 |  | 0.393 |  | 0.254
 | Total market share (2) | 0.718 |  | 0.718 |  | 0.683
 | NYSE securities
 | Average daily share volume (in billions) | 4.72 |  | 5.53 |  | 6.01
 | Matched market share executed on NASDAQ | 0.15 |  | 0.141 |  | 0.22
 | Matched market share executed on NASDAQ OMX BX | 0.041 |  | 0.031 |  | 0
 | Market share reported to the FINRA/NASDAQ
 | Trade Reporting Facility(1) | 0.332 |  | 0.354 |  | 0.217
 | Total market share (2) | 0.523 |  | 0.526 |  | 0.437
 | NYSE Amex and regional securities
 | Average daily share volume (in billions) | 1.43 |  | 1.53 |  | 2.17
 | Matched market share executed on NASDAQ | 0.235 |  | 0.222 |  | 0.348
 | Matched market share executed on NASDAQ OMX BX | 0.024 |  | 0.021 |  | 0
 | Market share reported to the FINRA/NASDAQ
 | Trade Reporting Facility(1) | 0.329 |  | 0.344 |  | 0.172
 | Total market share (2) | 0.588 |  | 0.586 |  | 0.52
 | Total U.S.-listed equities
 | Matched share volume (in billions) | 126.1 |  | 131.4 |  | 196.6
 | Matched market share executed on NASDAQ | 0.206 |  | 19.4 |  | 29.2
 | Matched market share executed on NASDAQ OMX BX | 0.034 |  | 0.027 |  | 0
 | NASDAQ OMX Nordic and NASDAQ OMX Baltic Markets
 | Average daily number of equity trades | 219811 |  | 189002 |  | 250497
 | Average daily value of shares traded (in billions) | 3.3 |  | 3 |  | 3.6
 | Derivative Trading and Clearing
 | U.S. Equity Options Contracts
 | Total industry average daily volume (in millions) | 12.9 |  | 13.2 |  | 12
 | Matched market share:
 | [NAME] | 0.194 |  | 0.17 |  | 0.169
 | The NASDAQ Options Market | 0.031 |  | 0.032 |  | 0.018
 | NASDAQ OMX Nordic and NASDAQ OMX Baltic Markets
 | Average daily volume:
 | Equity options and fixed-income contracts | 363347 |  | 298849 |  | 382170
 | Equity options contracts traded on EDX London | 51498 |  | 87636 |  | 136446
 | Finnish option contracts traded on Eurex | 86381 |  | 65779 |  | 73365
 | NASDAQ OMX Commodities
 | Clearing Turnover:
 | Power contracts (TWh)(3) | 600 |  | 480 |  | 531
 | Carbon contracts (1000 tCO2)(3) | 12155 |  | 13745 |  | 18882
Issuer Services
 | NASDAQ
 | Initial public offerings | 18 |  | 12 |  | 1
 | New listings (4) | 64 |  | 33 |  | 29
 | Number of listed companies (5) | 2852 |  | 2863 |  | 3023
 | NASDAQ OMX Nordic and NASDAQ OMX Baltic Markets
 | Initial public offerings | 1 |  | 0 |  | 3
 | New listings | 3 |  | 2 |  | 10
 | Number of listed companies (6) | 797 |  | 800 |  | 824
Market Technology
 | Order intake (in millions)(7) | 148 |  | 37 |  | 30
 | Total order value (in millions)(8) | 417 |  | 318 |  | 427
Spreadsheet: 884290d1733368944-three-dimensional-lookup-table-formula-for-excelforum
Sheet: Formula-New

Emp ID | Start Date | End Date | UNOPAY | OVTPAY | REGPAY
1 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00
1 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00
1 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00
2 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00
2 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00
2 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00
After formula is appied in yellow shaded area above, the results should be:
Emp ID | Start Date | End Date | UNOPAY | OVTPAY | REGPAY
1 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00 | 100 | 200 | 300
1 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00 | 400 | 500 | 600
1 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00 | 700 | 800 | 900
2 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00 | 1000 | 1100 | 1200
2 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00 | 1300 | 1400 | 1500
2 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00 | 1600 | 1700 | 1800
Spreadsheet: 04041334-68f8-45b4-b8ba-c0bab10c554c
Sheet: Sheet1

May | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | Legend
 |  | 30 | 1 | 2 | 3 | 4 |  | [NAME] *
 |  |  | breakfast time TBD | breakfast time TBD | breakfast time TBD | breakfast time TBD |  | Lowenberger Dining Hall *
 |  |  | lunch TBD | lunch TBD | lunch TBD | lunch TBD
 |  |  | dinner TBD | dinner TBD | dinner TBD | dinner TBD |  | Market
 |  | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm |  |  | [NAME]
 |  | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm |  |  | Union Station (Subway & Harveys
 |  | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm
5 | 6 | 7 | 8 | 9 | 10 | 11 |  | * meal times are subject to change
lunch TBD |  | 7:15am-8:15am | 7:15am-8:15am | 7:15am-8:15am | 7:15am-8:15am | dinner time TBD |  | contact the front desk for
dinner TBD | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm |  |  | confirmed meal times in dining
 | 5:15pm-6:15pm | 5:15pm-6:15pm | 5:15pm-6:15pm | 5:15pm-6:15pm |  |  |  | halls
 | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm
 | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm
 | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm
12 | 13 | 14 | 15 | 16 | 17 | 18
 |  | 7:15am-8:15am | 7:15am-8:15am | 7:15am-8:15am | 7:15am-8:15am | breakfast TBD
 | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm | lunch TBD
 | 5:15pm-6:15pm | 5:15pm-6:15pm | 5:15pm-6:15pm | 5:15pm-6:15pm |  | dinner TBD
 | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm
 | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm
 | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm
19 | 20 | 21 | 22 | 23 | 24 | 25
breakfast TBD |  |  |  | 7:15-8:15 | 7:15-8:15
lunch TBD |  |  |  | 12:15pm-1:15pm | 12:15pm-1:15pm
dinner TBD |  |  | 5:15pm-6:15pm | 5:15pm-6:15pm
 | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm
 | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm
 | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm
26 | 27 | 28 | 29 | 30 | 31
 |  | 7:15am-8:15am | 7:15am-8:15am | 7:15am-8:15am | 7:15am-8:15am
 | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm | 12:15pm-1:15pm
 | 5:15pm-6:15pm | 5:15pm-6:15pm | 5:15pm-6:15pm | 5:15pm-6:15pm
 | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm | 10am-3pm
 | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm | 8am-4pm
 | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm | 11am-5pm
Spreadsheet: 683019d1592432838-dragging-vertical-formulas-referencing-horizontal-cells-vertical-formula-w-horizontal-reference
Sheet: Tiers

 | BRONZE | SILVER | GOLD (A) | GOLD (B) | GOLD (C)
WHAT WE'RE TESTING:
# of test cells | 1 | 1 | 1 | 1 | 2 | <-- Each cell can test up to 3 influencer posts in Eye Square. If you have more to test, we will have to create multiple cells (as per "GOLD Option C").
# of targeted audience members | 1 | 1 | 1 | 2 | 1 | <-- Targeted audience members are based on age cohort. E.g., Millennials are 1 target audience, [NAME] are a second audience.
Minimum incidence of target group | 0.25 | 0.25 | 0.1 | 0.1 | 0.1 | <-- Incidence after all screening criteria is applied.
Sample size per cell | 150 | 150 | 300 | 600 | 300
Total sample size | 150 | 150 | 300 | 600 | 600
Interview length (in minutes) | 10 | 15 | 20 | 20 | 20
WHAT WE'RE BENCHMARKING AGAINST:
# of control cells | n/a | 1 | 1 | 1 | 2 | <-- If including a benchmark to measure brand lift, the # of cells has to mirror the test (above).
# of benchmark audience members | n/a | 1 | 1 | 2 | 1
Sample size per cell | n/a | 150 | 150 | 300 | 150
Total sample size | n/a | 150 | 150 | 300 | 300
Interview length (in minutes) | n/a | 10 | 10 | 10 | 10
WHAT WE MEASURE:
In-feed behavioural metrics for client (test) post | X | X | X | X | X
In-feed behavioural metrics for avg of all other posts | X | X | X | X | X
Brand lift metrics |  | X | X | X | X
Campaign diagnostics |  |  | X | X | X
Per-Post (Content) diagnostics |  |  | X | X | X
TOTAL COST: | 5000 | 6000 | 8000 | 12000 | 15000
ADDITIONAL COSTS, AS APPLICABLE:
Cost per additional question | n/a | n/a | 500 | 500 | 500
Cost for Dig Insights to write PPT report | n/a | n/a | 5000 | 5000 | 7500
Cost to duplicate study for French influncer posts | 5800 | 6800 | 8800 | 12800 | 15800 | <-- Calculated as a duplicated English cell + $800 to cover French translations and French programming.
Spreadsheet: 53841d1253777465-excel-2007-compare-3-columns-in-sheet-1-with-sheet-2-then-add-sheet-1-fourth-column-data-compare-3-columns
Sheet: Sheet1 & Sheet2

 | Excel Sheet 1
 | COLUMN 1 | COLUMN 2 | COLUMN 3 | COLUMN 4
 | 1005 | 10 | [NAME] | Royal Blue
 | 1005 | 20 | [NAME] | Navy Blue
 | 1006 | 50 | [NAME] | Rose
 | 1100 | 40 | Sonam | Green
 | 1156 | 80 | Rashmi | Pink
 | RESULT
 | Excel Sheet 2
 | COLUMN 1 | COLUMN 2 | COLUMN 3 | COLUMN 4
 | 997 | 90 | Rupa
 | 1005 | 10 | [NAME] | Royal Blue
 | 1100 | 40 | Sonam | Green
 | 1100 | 40 | Sonam | Green
 | 1156 | 80 | Rashmi | Pink
 | 886 | 30 | Vanaja
 | 775 | 50 | Vivek
 | 1005 | 20 | [NAME] | Navy Blue
 | 1006 | 50 | [NAME] | Rose
 | 1006 | 60 | Varun
 | 1100 | 40 | Sonam | Green
 | 1005 | 40 | Priya
 | 1156 | 80 | Rashmi | Pink
Spreadsheet: 812748d1673358133-need-help-on-a-count-formula-sample-for-question
Sheet: Sheet1

Bus Unit | 2022-09-03 00:00:00 |  | 2022-09-10 00:00:00 |  | 2022-09-17 00:00:00 |  | 2022-09-24 00:00:00
 | Count | Paid | Count | Paid | Count | Paid | Count | Paid
FB601 |  |  |  | 2455.3 |  |  |  | 3176.3
FB602 |  |  |  | 2840 |  |  |  | 2864
FB604 |  |  |  | 7142.300000000001 |  |  |  | 6981.8
FB605 |  |  |  | 1753.6 |  |  |  | 2048
FB606 |  |  |  | 3092 |  |  |  | 2912
FB607 |  |  |  | 1826.8 |  |  |  | 2412.5
FB608 |  |  |  | 5330.800000000001 |  |  |  | 7083.000000000002
[NAME] |  |  |  | 2684.39 |  |  |  | 2886
[NAME] |  |  |  | 1068.54 |  |  |  | 1095.76
FB615 |  |  |  | 1766.2 |  |  |  | 2259
FB616 |  |  |  | 4216 |  |  |  | 4146
FB619 |  |  |  | 912 |  |  |  | 1004
Spreadsheet: 117319d1312658769-if-help-to-give-value-if-true-shipping-info-book1-1-
Sheet: Sheet1

Desired Ship Date | [NAME] | Invoice Date | [NAME] | Unit Price | Trade Discount | unit price with discount | Ext | Days Early/Late | Ship On Time | Ship late 1-10 days | Ship Late 11-30 days | Ship Late 31-60 days | Ship Late 61-90 days | Ship Late 91 plus days | Ship Early 1-10 days | Ship Early 11-30 days | Ship Early 31-60 days | Ship Early 61-90 days | Ship Early 91 plus days
2011-01-03 00:00:00 | 2011-01-03 00:00:00 | 2011-01-03 00:00:00 | 635 | 11.5 | 0
2010-12-30 00:00:00 | 2011-01-03 00:00:00 | 2011-01-03 00:00:00 | 28 | 43 | 0
2010-10-04 00:00:00 | 2011-01-03 00:00:00 | 2011-01-03 00:00:00 | 6 | 36 | 0
2010-01-23 00:00:00 | 2011-01-03 00:00:00 | 2011-01-03 00:00:00 | 125 | 21 | 0
Spreadsheet: 51726d1251358095-situational-average-697143_lordfa9
Sheet: Sales Records

Date | Item | Price | Quantity | Profit
2009-08-27 00:00:00 | Apples | 0.5 | 100 | 50 |  | 0.4833333333333333
2009-08-27 00:00:00 | Oranges | 0.45 | 50 | 22.5
2009-08-27 00:00:00 | Apples | 0.45 | 50 | 22.5
2009-08-28 00:00:00 | Grapes | 1 | 100 | 100
Spreadsheet: 862476d1710195032-exclude-holidays-in-total-holiday-sample
Sheet: Mar

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  | 2024-03-02 00:00:00 | 2024-03-03 00:00:00 | 2024-03-04 00:00:00 | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00 | 2024-03-11 00:00:00 | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00 | 2024-03-18 00:00:00 | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2024-03-21 00:00:00 | 2024-03-22 00:00:00 | 2024-03-23 00:00:00 | 2024-03-24 00:00:00 | 2024-03-25 00:00:00 | 2024-03-26 00:00:00 | 2024-03-27 00:00:00 | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-03-30 00:00:00 | 2024-03-31 00:00:00 |  |  |  |  |  | 10
 |  |  |  | 2024-03-02 00:00:00 | 2024-03-03 00:00:00 | 2024-03-04 00:00:00 | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00 | 2024-03-11 00:00:00 | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00 | 2024-03-18 00:00:00 | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2024-03-21 00:00:00 | 2024-03-22 00:00:00 | 2024-03-23 00:00:00 | 2024-03-24 00:00:00 | 2024-03-25 00:00:00 | 2024-03-26 00:00:00 | 2024-03-27 00:00:00 | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-03-30 00:00:00 | 2024-03-31 00:00:00
 |  | 2024-03-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 328355d1403877703-sumproduct-with-different-sized-arrays-sumproductexample
Sheet: Sheet2

Code | Cost
1003 | 107759
1004 | 156813
1005 | 23580
1007 | 200169
1012 | 99892
1014 | 280895
1015 | 21708
1016 | 602622
1017 | 160248
1018 | 46688
1019 | 99892
1020 | 59173
1021 | 52293
1026 | 15899
1027 | 75382
Spreadsheet: 765880d1643648646-vlookup-with-condition-price-lists
Sheet: 122

Product | Price | Valid To |  |  | 2021-12-31 00:00:00
400012345 | 30 | 2022-02-28 00:00:00 |  | 400012345 | 31
400012345 | 31 | 9999-12-31 00:00:00 |  | 400012347 | 32
400012347 | 32 | 9999-12-31 00:00:00 |  | 400012348 | 33
400012348 | 33 | 9999-12-31 00:00:00 |  | 400012349 | 35
400012349 | 35 | 9999-12-31 00:00:00 |  | 400012351 | 100
400012351 | 35 | 2022-02-28 00:00:00
400012351 | 100 | 9999-12-31 00:00:00
Spreadsheet: 849053d1699617572-help-index-match-for-rows-and-column-to-pull-text-from-text-string-ms-worksheet-for-m
Sheet: MS Data

M1 | M1 Year | M2 | M2 Year | M3 | M3 Year | M4 | M4 Year | M5 | M5 Year | Grouped | Grouped Year |  | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024
M1- | M1- Year | M2- | M2- Year | M3- | M3- Year | M4- | M4- Year | M5- | M5- Year | Group- | Group- Year | ID | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
 |  |  |  |  |  |  |  |  |  |  |  | 9715 | M1 |  |  |  |  |  |  |  |  |  | M2 | M3 |  | M4 | M5
 |  |  |  |  |  |  |  |  |  |  |  | 9716 | M1 |  |  |  |  | M2 |  |  | M3 |  | M4 | M5
 |  |  |  |  |  |  |  |  |  |  |  | 9717 | M1 |  |  |  |  |  |  | M2 |  |  |  |  |  | M3 |  |  |  | M4
 |  |  |  |  |  |  |  |  |  |  |  | 9718 | M1 |  | M2 |  |  |  | M3 |  | M4 |  |  | M5
 |  |  |  |  |  |  |  |  |  |  |  | 9214 | M2, M3 |  |  |  |  |  |  | M4 |  | M5
 |  |  |  |  |  |  |  |  |  |  |  | 10085 |  |  | M1 |  | M2 | M3, M4 | M5
 |  |  |  |  |  |  |  |  |  |  |  | 10056 |  |  | M1, M2 |  | M3, M4 | M5
 |  |  |  |  |  |  |  |  |  |  |  | 9971 | M1 |  |  |  |  |  | M3, M4 |  |  |  | M5
 |  |  |  |  |  |  |  |  |  |  |  | 10154 |  |  |  |  | M2 |  | M3 | M4 |  | M5
 |  |  |  |  |  |  |  |  |  |  |  | 10039 |  | M1
 |  |  |  |  |  |  |  |  |  |  |  | 10040 |  | M1 |  | M2 |  | M3 | M4 | M5
 |  |  |  |  |  |  |  |  |  |  |  | 9981 | M1 | M2 | M3 |  |  |  |  | M4 |  |  |  | M5
 |  |  |  |  |  |  |  |  |  |  |  | 9985 |  | M1 | M2 | M3 |  |  |  |  | M4 |  |  | M5
 |  |  |  |  |  |  |  |  |  |  |  | 9723 |  | M2 |  |  | M3 | M4 |  |  | M5
 |  |  |  |  |  |  |  |  |  |  |  | 8842
 |  |  |  |  |  |  |  |  |  |  |  | 10183 |  |  | M1, M5 |  |  |  | M2 |  |  | M3 |  | M4
Spreadsheet: 80784d1280980344-excel-2007-pivot-table-pivothelp
Sheet: Result

BU | Dept | C01 | C03 | C05 | C06 | C07
Power | Maintenance | 0 | 0 | 0 | 156 | 40
 | Production | 32 | 4 | 4 | 0 | 0
 | Transport | 20 | 32 | 0 | 30 | 0
Pulp | Maintenance | 172 | 0 | 0 | 84 | 8
 | Transport | 834 | 0 | 32 | 27 | 0
Support | Maintenance | 104 | 0 | 0 | 647 | 14
 | Transport | 236 | 0 | 32 | 262 | 46
 |  | Data
Unit | Dept | Sum of    CO01 | Sum of  CO03 | Sum of  CO05 | Sum of    CO06 | Sum of  CO07
Power | Maintenance | 0 | 0 | 0 | 156 | 40
 | Production | 32 | 4 | 4 | 0 | 0
 | Transport | 20 | 32 | 0 | 29.5 | 0
Pulp | Maintenance | 172 | 0 | 0 | 83.5 | 7.5
 | Transport | 834 | 0 | 32 | 27 | 0
Support | Maintenance | 104 | 0 | 0 | 646.5 | 13.5
 | Transport | 236 | 0 | 32 | 261.5 | 46
Spreadsheet: 849718d1700132492-allocation-of-hours-between-dates-formula-issues-example-data
Sheet: Sheet1

2023-10-23 00:00:00 | 2023-10-30 00:00:00 | 2023-11-06 00:00:00 | 2023-11-13 00:00:00 | 2023-11-20 00:00:00 | 2023-11-27 00:00:00 | 2023-12-04 00:00:00 | 2023-12-11 00:00:00 | 2023-12-18 00:00:00 | 2023-12-25 00:00:00 | 2024-01-01 00:00:00
2023-10-29 00:00:00 | 2023-11-05 00:00:00 | 2023-11-12 00:00:00 | 2023-11-19 00:00:00 | 2023-11-26 00:00:00 | 2023-12-03 00:00:00 | 2023-12-10 00:00:00 | 2023-12-17 00:00:00 | 2023-12-24 00:00:00 | 2023-12-31 00:00:00 | 2024-01-07 00:00:00
43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Spreadsheet: 269091d1380956723-range-reference-range
Sheet: Sheet1

R1 | R2 |  | Num | Since x1 | Since x2
11 | 13 |  | 11 |  | ?
12 | 14 |  | 12 |  | ?
11 | 15 |  | 14 |  | ?
14 | 16 |  | 16 |  | ?
11 | 17 |  | 17 |  | ?
16 | 18 |  | 19 |  | ?
12 | 19
11 | 20
19 | 21
 | Trying to find a way to change the formula range "$A$2:$A$10" by pointing to a reference cell
 | In this case the reference would be column "E", so that the formula range IN "F2" would be "A2 +E2+1 = A4 Giving a new range of  $A$4:$A$10
 | Etc, to complete column "F"
Spreadsheet: 754292d1636058472-excel-conditional-formatting-based-on-start-and-end-date-lowanger_conditional_based_on_date
Sheet: Tabelle1

 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00
 | a | a | a | a | a | a | a | a | a | a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mitarbeiter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-01-06 00:00:00