tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_shapiro__32398__Shapiro OS Template1 (Canada) 100301
Sheet: Scenario 1

Cost Center Owner
Cost Center Number
 | Please use this form only for Outside Services
 | Scenario 1:  The "ideal" world
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | Equicom/Sasha Jacob | Lobbying support electricity market opening/Ontario | 80000
 | Frontier Economics | Consultant to advise on Electricity Industry Structure Review/Alberta | 30000
 | Altitude Energy | Consulting support Atco - Affiliate Code of Conduct Hearing - Alberta | 5000
 | Donahue & Partners | Legal support Atco - Affiliate Code of Conduct Hearing - Alberta | 20000
 | [NAME] | Legal support ESBI 2001 GTA (PPA Module) - Alberta | 15000
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | GPC | Lobbying support re electricity mkt opening/Ontario | 200000
 | Tabors/Frontier Economics | Consulting support on technical design issue effecting electricity mkt opening/Ontario | 60000
 | Lawyer/consultant | Legal and consulting support OEB proceedings re retail gas markets/Ontario | 30000
 | Consultant | Consulting advice on current rules status and retail gas market tariffs/Ontario | 40000
 | Donahue & Partners | Legal support retail gas & electric market tariffs/Alberta | 70000
 | Altitude Energy Mgt | Consulting support retail gas & electric market tariffs/Alberta | 30000
 | Frontier Economics | Consulting support on transmission congestion management design/Alberta | 50000
 | Frontier Economics | Consulting support on issues effecting value of PPA (e.g. disposition by [NAME] of unsold PPAs)/Alberta | 50000
 | Lawyer/Consultant | Legal support to review draft amendments/consolidation of Electric Utilities Act/Alberta | 40000
 | GPC | Introductions and Energy Restructuring Vision Presentations/BC | 40000
 |  | Total:
 | Total Both Categories
Spreadsheet: 847625d1698473705-look-up-and-return-row-sample-4-
Sheet: result

Column1 | Column2 | Column3 | Column4 | Column5 | Column6
2023-10-27 00:00:00 | FRI | 0.2083333333333333 | 2023-10-27 00:00:00 | 14339.5 | 63.5
2023-10-27 00:00:00 | FRI | 0.406574074074074 | 2023-10-27 00:00:00 | 14357 | 55
2023-10-27 00:00:00 | FRI | 0.4217592592592592 | 2023-10-27 00:00:00 | 14358.25 | 64.5
2023-10-27 00:00:00 | FRI | 0.4265625 | 2023-10-27 00:00:00 | 14369.5 | 75.75
2023-10-27 00:00:00 | FRI | 0.4351273148148149 | 2023-10-27 00:00:00 | 14359 | 50.5
2023-10-27 00:00:00 | FRI | 0.4583333333333333 | 2023-10-27 00:00:00 | 14336.75 | 62.75
2023-10-27 00:00:00 | FRI | 0.4703125 | 2023-10-27 00:00:00 | 14404.75 | 68
2023-10-27 00:00:00 | FRI | 0.5951736111111111 | 2023-10-27 00:00:00 | 14267.5 | 55.25
2023-10-27 00:00:00 | FRI | 0.6149652777777778 | 2023-10-27 00:00:00 | 14284.75 | 69
2023-10-27 00:00:00 | FRI | 0.6666666666666666 | 2023-10-27 00:00:00 | 14265.75 | 56
Spreadsheet: cara_semperger__1450__ENA_PGE_DEC07_2001
Sheet: COB N>S

From: | EPMI
To: | PGE System Transactions
Date: | 2001-12-07 00:00:00
HE
ENDING | GRIZZLY/MALIN | TOTAL
Pacific Prevailing
Time |  | JD/COB
(PPT) |  | Total In To PGE Trans (N > S)
0100 | 0
0200 | 0
0300 | 0
0400 | 0
0500 | 0
0600 | 0
0700 | 0
0800 | 0
0900 | 0
1000 | 0
1100 | 0
1200 | 0
1300 | 0
1400 | 0
1500 | 0
1600 | 0
1700 | 0
1800 | 0
1900 | 0
2000 | 0
2100 | 0
2200 | 0
2300 | 0
2400 | 0
Spreadsheet: 848955d1699546081-list-missing-numbers-in-range-not-as-an-array-forumla-list-missing-numbers-in-range
Sheet: Sheet1

 | Production Task # |  | Production Line 1 | Production Line 2 | Production Line 3 |  | Production Line 3
 | 1 |  | 1 |  |  |  | 6
 | 2 |  | 2 | 3 |  |  | 7
 | 3 |  | 5 | 4 |  |  | 8
 | 4 |  | 10 |  |  |  | 9
 | 5 |  | 12 | 14 |  |  | 11
 | 6 |  | 13 |  |  |  | 19
 | 7 |  | 15
 | 8 |  | 16 | 18
 | 9 |  | 17
 | 10 |  | 20
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 701523d1603801404-compound-interest-calculation-deposit-commpound-int-calculator-tora-
Sheet: Sheet1

Date | Bank Interest rate | Monthly Int |  | [NAME] | interest per month
2018-10-01 00:00:00 | 0.065 |  |  |  |  |  | Principal amount | 6000
2018-11-01 00:00:00 | 0.0675 |  |  |  |  |  | Average Interest
2018-12-01 00:00:00 | 0.0675 |  |  |  |  |  | Compunding periods per year | 12
2019-01-01 00:00:00 | 0.0675 |  |  |  |  |  | No of years
2019-02-01 00:00:00 | 0.0675 |  |  |  |  |  | [NAME]
2019-03-01 00:00:00 | 0.0675
2019-04-01 00:00:00 | 0.0675
2019-05-01 00:00:00 | 0.0675
2019-06-01 00:00:00 | 0.0675
2019-07-01 00:00:00 | 0.0675
2019-08-01 00:00:00 | 0.0675
2019-09-01 00:00:00 | 0.0675
2019-10-01 00:00:00 | 0.0675
2019-11-01 00:00:00 | 0.0675
2019-12-01 00:00:00 | 0.0675
2020-01-01 00:00:00 | 0.0625
2020-02-01 00:00:00 | 0.0625
2020-03-01 00:00:00 | 0.0525
2020-04-01 00:00:00 | 0.0425
2020-05-01 00:00:00 | 0.0375
2020-06-01 00:00:00 | 0.0375
2020-07-01 00:00:00 | 0.035
2020-08-01 00:00:00 | 0.035
2020-09-01 00:00:00 | 0.035
2020-10-01 00:00:00 | 0.035
 |  |  |  |  |  | total
Spreadsheet: 886338d1736356088-populating-a-briefing-spreadsheet-starting-from-a-weekly-rota-table-rota-template-briefing-sheet
Sheet: Monday

Cheat Sheet
Monday
MANAGERS
Name | Start | Finish | Section |  | Name | Start | Finish | Section
WAITERS
Name | Start | Finish | Section |  | Name | Start | Finish | Section
BAR
Name | Start | Finish | Section |  | Name | Start | Finish | Section
HOST TEAM
Name | Start | Finish | Section |  | Name | Start | Finish | Section
SOMMELIER
Name | Start | Finish | Section |  | Name | Start | Finish | Section
RUNNERS
Name | Start | Finish | Section |  | Name | Start | Finish | Section
Spreadsheet: 871699d1718116677-in-need-of-formulas-to-combine-the-data-from-3-sheets-into-1-sheet-overall-list-overall-list
Sheet: Q2

S.N. | Identity No. | Category | Discipline | Document Type | Document No. | Rev. No. | Document Title | Created Date | Submitted Date | Created By | Status
1 | Q2-1 | Hydrostatic Test Package | Piping | Test Package | U862-FW-001 | 00 | U862-FW-001_Hydro Test | 2023-07-18 00:00:00 | 2023-07-22 00:00:00 | AHMADOS | Closed
2 | Q2-2 | Hydrostatic Test Package | Piping | Test Package | U861-FW-013 | 00A | U861-FW-013_Hydro Test | 2023-08-27 00:00:00 | 2023-08-27 00:00:00 | SYEDASOF | Open
3 | Q2-3 | Hydrostatic Test Package | RTR | Test Package | U861-FW-034 | 00D | U861-FW-034_Hydro Test | 2023-09-06 00:00:00 | 2023-09-06 00:00:00 | JAYAKUMB | Closed
Spreadsheet: 97877d1296991900-is-multilookup-possible-alongwith-like-sorting-for-only-months-757993_e4excel
Sheet: Chk

 | 'A'! | Arvind Deshmukh |  | [NAME] | 3 |  |  |  | Data |  |  |  |  | Result |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HLY
Row No | Sr.No | Date of  Comm | POLICY NO | Mode | PREMIUM |  | Interest |  | Policy Holders Name | POLICY NO | Date of  Comm | MODE |  | Policy Holders Name | POLICY NO | Date of  Comm | MODE |  | QLY
2 | 1 | 2003-01-14 01:00:00 | 791787833 | [NAME] |  |  |  |  | Arvind Deshmukh | 791787833 | 2003-01-14 00:00:00 | [NAME] |  | Arvind Deshmukh | 791787833 | 2003-01-14 00:00:00 | [NAME] |  | ECS
7 | 2 | 2006-06-21 01:00:00 | 792969818 | [NAME] |  |  |  |  | Arvind Deshmukh | 792383786 | 2004-06-28 00:00:00 | SGL |  | Arvind Deshmukh | 792997163 | 2005-01-15 00:00:00 | ECS |  | SGL
8 | 3 | 2006-06-21 01:00:00 | 792969819 | [NAME] |  |  |  |  | Arvind Deshmukh | 792383787 | 2004-06-28 00:00:00 | ECS |  | Arvind Deshmukh | 792969818 | 2006-06-21 00:00:00 | [NAME] | Same Mode appearing below one other plus SORTING of the Months as earlier
 |  |  |  |  |  |  |  |  | Arvind Deshmukh | 792383788 | 2004-06-28 00:00:00 | SGL |  | Arvind Deshmukh | 792969819 | 2006-06-21 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  | Arvind Deshmukh | 792997163 | 2005-01-15 00:00:00 | ECS |  | Arvind Deshmukh | 792383786 | 2004-06-28 00:00:00 | SGL
 |  |  |  |  |  |  |  |  | Arvind Deshmukh | 792969818 | 2006-06-21 00:00:00 | [NAME] |  | Arvind Deshmukh | 792383788 | 2004-06-28 00:00:00 | SGL
 |  |  |  |  |  |  |  |  | Arvind Deshmukh | 792969819 | 2006-06-21 00:00:00 | [NAME] |  | Arvind Deshmukh | 792383787 | 2004-06-28 00:00:00 | ECS
Spreadsheet: kate_symes__18408__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | 2000-12-19 00:00:00 |  | 450 | 2400 | 346.89 | 1608 | 477.03 | 1720 | 210 | 697
 | 2000-12-18 00:00:00 |  | 377 | 2000 | 325 | 400 | 593.64 | 3048 | 423.21 | 1126
 | 2000-12-17 00:00:00 |  |  |  |  |  |  |  | 551.77 | 2065 |  | 325 | 600
 | 2000-12-16 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 587.5 | 1400 | 537.5 | 1200
 | 2000-12-15 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 571.38 | 3975 | 517.59 | 3375
 | 2000-12-14 00:00:00 |  | 484.61 | 5200 | 256.22 | 1608 | 654.11 | 730 | 437.04 | 1340
 | 2000-12-13 00:00:00 |  | 688.24 | 6800 | 500 | 200 | 454.83 | 6475 | 350 | 100
 | 2000-12-12 00:00:00 |  | 818.75 | 3200 | 300 | 200 | 800 | 0 | 600 | 0
 | 2000-12-11 00:00:00 |  | 3200 | 2800 | 1187.5 | 400 | 597.15 | 1192 | 561.22 | 245
 | 2000-12-10 00:00:00 |  |  |  |  |  |  |  | 740.4 | 5823 |  | 1187.5 | 1200
 | 2000-12-09 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 450 | 450 | 487.5 | 0
 | 2000-12-08 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 325 | 630 | 487.5 | 0
 | 2000-12-07 00:00:00 |  | 679.17 | 2400 | 412.5 | 400 | 505.96 | 235 | 320.47 | 265
 | 2000-12-06 00:00:00 |  | 357.3 | 9600 | 275 | 800 | 342 | 858 | 237.5 | 200
 | 2000-12-05 00:00:00 |  | 278.47 | 7600 | 245 | 200 | 388 | 125 | 237.5 | 0
 | 2000-12-04 00:00:00 |  | 283.12 | 10000 | 255 | 400 | 281.5 | 0 | 255 | 0
 | 2000-12-03 00:00:00 |  |  |  |  |  |  |  | 224 | 375 |  | 255 | 1200
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 883476d1732095381-table-sum-formula-tonyphilbrick-sample-365-aligw
Sheet: Sheet1

 |  |  |  | Date | Total |  |  |  |  | 2024-11-01 00:00:00
 |  |  |  | 2024-10-18 00:00:00 | 40
 |  |  |  | 2024-10-18 00:00:00 | 25
 |  |  |  | 2024-10-19 00:00:00 | 15
 |  |  |  | 2024-10-19 00:00:00 | 92
 |  |  |  | 2024-10-20 00:00:00 | 23
 |  |  |  | 2024-10-20 00:00:00 | 93
 |  |  |  | 2024-10-21 00:00:00 | 16
 |  |  |  | 2024-10-21 00:00:00 | 25
 |  |  |  | 2024-10-22 00:00:00 | 71
 |  |  |  | 2024-10-22 00:00:00 | 57
 |  |  |  | 2024-10-23 00:00:00 | 16
 |  |  |  | 2024-10-23 00:00:00 | 90
 |  |  |  | 2024-10-24 00:00:00 | 99
 |  |  |  | 2024-10-24 00:00:00 | 68
 |  |  |  | 2024-10-25 00:00:00 | 30
 |  |  |  | 2024-10-25 00:00:00 | 18
 |  |  |  | 2024-10-26 00:00:00 | 41
 |  |  |  | 2024-10-26 00:00:00 | 73
 |  |  |  | 2024-10-27 00:00:00 | 82
 |  |  |  | 2024-10-27 00:00:00 | 38
 |  |  |  | 2024-10-28 00:00:00 | 93
 |  |  |  | 2024-10-28 00:00:00 | 92
 |  |  |  | 2024-10-29 00:00:00 | 89
 |  |  |  | 2024-10-29 00:00:00 | 48
 |  |  |  | 2024-10-30 00:00:00 | 2
 |  |  |  | 2024-10-30 00:00:00 | 85
 |  |  |  | 2024-10-31 00:00:00 | 33
 |  |  |  | 2024-10-31 00:00:00 | 82
 |  |  |  | 2024-11-01 00:00:00 | 46
 |  |  |  | 2024-11-01 00:00:00 | 70
 |  |  |  | 2024-11-02 00:00:00 | 43
 |  |  |  | 2024-11-02 00:00:00 | 50
 |  |  |  | 2024-11-03 00:00:00 | 26
 |  |  |  | 2024-11-03 00:00:00 | 76
 |  |  |  | 2024-11-04 00:00:00 | 48
 |  |  |  | 2024-11-04 00:00:00 | 18
 |  |  |  | 2024-11-05 00:00:00 | 81
 |  |  |  | 2024-11-05 00:00:00 | 86
 |  |  |  | 2024-11-06 00:00:00 | 19
 |  |  |  | 2024-11-06 00:00:00 | 38
 |  |  |  | 2024-11-07 00:00:00 | 36
 |  |  |  | 2024-11-07 00:00:00 | 79
 |  |  |  | 2024-11-08 00:00:00 | 16
 |  |  |  | 2024-11-08 00:00:00 | 76
 |  |  |  | 2024-11-09 00:00:00 | 36
 |  |  |  | 2024-11-09 00:00:00 | 78
 |  |  |  | 2024-11-10 00:00:00 | 3
 |  |  |  | 2024-11-10 00:00:00 | 50
 |  |  |  | 2024-11-11 00:00:00 | 71
 |  |  |  | 2024-11-11 00:00:00 | 89
Spreadsheet: 97480d1296652858-excel-count-text-in-column-match-date-only-worksheet-open-vs-closed
Sheet: To Do List data

To-Do List |  |  |  |  |  |  |  |  |  |  | Wednesday | 2011-02-02 00:00:00
Month Of : |  | January
Done? | # | Issue | Type of Issue | Priority | Open Date | Current Status | Open By | % Complete | Close Date | Final Status | Close By | Comments
a | 1 | abc | Risk | High | 2011-01-05 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-06 00:00:00 | Closed | [NAME]
a | 2 | abc | Question | Medium | 2011-01-05 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-06 00:00:00 | Closed | [NAME] and [NAME]
 | 3 | abc | Others | Medium | 2011-01-05 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-06 00:00:00 | Closed | [NAME]
 | 4 | abc | Error | Low | 2011-01-06 00:00:00 | Open | [NAME] and [NAME] | 1 |  |  | [NAME] and [NAME]
 | 5 | abc | Risk | Low | 2011-01-29 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-05 00:00:00 | Closed | Vennus
 | 5 | abc |  |  | 2011-02-02 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-06 00:00:00 | Closed
 | 6 | abc |  |  | 2011-02-03 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-07 00:00:00 | Closed
 | 7 | abc |  |  | 2011-02-04 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-08 00:00:00 | Closed
 | 8 | abc |  |  | 2011-02-05 00:00:00 | Open | [NAME] and [NAME] | 1 | 2011-02-09 00:00:00 | Closed
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 95553d1295137220-giving-a-true-answer-forum-sample-13
Sheet: Sheet1

9230
2319
4517
3471
8311
9327
7698
9283
9107
2633
0847
0900
1393
6903
2789
2509
8934
0062
6133
8128
2975
8845
3230
1917
4142
4839
4169
9917
1032
8389
7067
7467
6821
3052
7458
6891
3264
4809
7797
3965
2410
7755
2733
0289
3258
3058
5441
9633
0552
5170
6369
2374
0818
7550
2089
2700
6041
3013
8811
1617
6991
0903
4135
9713
4794
0372
6879
0956
9322
6594
3459
8261
0452
5537
6688
3209
4350
1819
7221
4216
6224
4000
0149
0054
5630
0165
9255
1385
6539
2557
3284
2584
6076
6846
2991
1958
5372
0947
8934 |  |  |  |  |  |  |  |  |  |  |  | 0
8655 |  |  |  |  |  |  |  |  |  |  |  | 1
4481 |  |  |  |  |  |  |  |  |  |  |  | 2
0007 |  |  |  |  |  |  |  |  |  |  |  | 3
1256
2574
9260
1942
Spreadsheet: 821599d1678811749-single-array-multiple-criteria-single-column-output-example-ss
Sheet: Example

Data Column | Desired Outcome | Current Formula | Attempted Formula
 | 18:01:33
2023-02-27 18:01:32, Processing ABCDEF (123456) | 18:03:47 | 18:03:47 | #[NAME]!
2023-02-27 18:01:32, Sorting... | 18:06:15 | 18:06:15 | #[NAME]!
2023-02-27 18:01:32, [NAME]… | 18:09:47 | 18:09:47 | #[NAME]!
2023-02-27 18:01:32, Pass ended | 18:09:51 | 18:11:05 | #[NAME]!
2023-02-27 18:01:33, [NAME] ended, 1 reconciles | 18:11:05 | #REF! | #[NAME]!
2023-02-27 18:01:33, Processing FEDCBA (654321)
2023-02-27 18:01:49, Sorting...
2023-02-27 18:02:11, Updating…
2023-02-27 18:03:02, Pass ended
2023-02-27 18:03:47, [NAME] ended, 9 reconciles
2023-02-27 18:03:47, Processing ABCFED (123654)
2023-02-27 18:04:31, Sorting...
2023-02-27 18:05:58, [NAME]…
2023-02-27 18:06:09, Pass ended
2023-02-27 18:06:15, [NAME] ended, 5 reconciles
2023-02-27 18:06:16, Processing CBADEF (321456)
2023-02-27 18:06:47, Sorting...
2023-02-27 18:08:22, Updating…
2023-02-27 18:09:37, Pass ended
2023-02-27 18:09:47, [NAME] ended, 4 reconciles
2023-02-27 18:09:51, Processing account FBCDEA (623451)
2023-02-27 18:09:51, Warning: Nothing for this account, skipping…
2023-02-27 18:09:52, Processing ACBDFE (132465)
2023-02-27 18:09:59, Sorting...
2023-02-27 18:10:22, [NAME]…
2023-02-27 18:11:01, Pass ended
2023-02-27 18:11:05, [NAME] ended, 4 reconciles
Spreadsheet: 116592d1311938522-index-match-only-4-results-required-date-and-name-example-1-1-
Sheet: Data Set

Name | Renewal Date
Name 1 | 2011-10-01 00:00:00
Name 2 | 2011-08-01 00:00:00
Name 3 | 2011-09-01 00:00:00
Name 4 | 2011-08-01 00:00:00
Name 5 | 2011-12-01 00:00:00
Name 6 | 2011-12-01 00:00:00
Name 7 | 2012-02-01 00:00:00
Name 8 | 2011-09-01 00:00:00
Name 9 | 2011-11-01 00:00:00
Name 10 | 2011-08-01 00:00:00
Name 11 | 2012-01-01 00:00:00
Name 12 | 2011-08-01 00:00:00
Name 13 | 2012-01-01 00:00:00
Name 14 | 2011-08-01 00:00:00
Name 15 | 2012-02-01 00:00:00
Spreadsheet: 767164d1644320575-first-occurance-formula-example-workbook
Sheet: Sheet1

Dilution |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
40 | A | 1 | 1 | 0.98 | 1 | 1 | 0.99 | 1 | 1 | 0.96 | 1 | 0.95 | 0.63
80 | B | 1 | 1 | 0.99 | 1 | 0.99 | 1 | 0.99 | 1 | 0.83 | 1 | 0.94 | 0.61
160 | C | 0.99 | 1 | 0.96 | 0.98 | 0.99 | 0.95 | 0.99 | 1 | 0.81 | 1 | 0.86 | 0.74
320 | D | 1 | 0.99 | 0.96 | 0.96 | 0.95 | 0.94 | 0.98 | 0.99 | 0.42 | 0.98 | 0.66 | -0.03
640 | E | 0.98 | 0.99 | 0.95 | 0.79 | 0.96 | 0.92 | 0.96 | 0.98 | 0.33 | 0.93 | 0.61 | -0.03
1280 | F | 0.96 | 0.97 | 0.78 | 0.77 | 0.88 | 0.86 | 0.92 | 1 | 0.32 | 0.97 | 0.49 | 0.06
2560 | G | 0.91 | 0.94 | 0.65 | 0.63 | 0.8 | 0.82 | 0.82 | 0.95 | 0.22 | 0.85 | 0.62 | 1
5120 | H | 0.76 | 0.82 | 0.61 | 0.35 | 0.58 | 0.71 | 0.65 | 0.83 | 0.08 | 0.8 | 0.31 | 1
>5120
 | Example: | 2560 | >5120 |  |  | 1280
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 16

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
3 1 |  |  | 15:10    23:09 | 23:55     6:31 | 22:39     7:17 |  | 15:00     1:00
 | 16:19    23:17 | 12:05    21:47 |  | 5:42     14:47 | 6:27     14:24
 | 6:27     14:24 |  | 6:19     14:31 | 6:00     16:00 |  | 7:57     16:23 | 17:57     0:47
 | 15:00     1:00 | 15:00    24:00 | 14:00    24:00 | 14:00    22:24
 |  | 23:55     6:31 | 23:00     7:21 |  |  | 8:31     16:11 | 22:00     6:00
 | 22:47     6:04 |  | 13:55    23:02 | 16:19    23:17
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
3 2 | 6:19     14:31 | 5:55     14:17 |  |  | 17:40     2:25 | 15:00    24:00 | 15:57    22:54
 |  | 7:00     16:00 | 6:00     15:00 | 4:17     10:27 | 6:00     14:00
 |  | 6:00     16:00 | 6:00     16:00 |  | 23:09     6:47 | 22:00     6:00
 | 13:55    23:02 | 23:10     7:02 | 23:55     6:31
 |  |  | 12:00    20:48 | 15:00     1:00 | 13:49    22:31 | 22:55     7:47 | 23:31     7:41
 |  |  | 6:25     15:49 | 5:49     13:22 | 5:42     14:47
Spreadsheet: 836487d1689404667-query-across-multiple-columns-and-multiple-criteria-with-flexible-content-ice-monthly-plan
Sheet: Project B

Project | Project B
Start | 2024-07-01 00:00:00
Months (+2) | 38
DOA | 2000000
Person ID | Person Name | Period Cost |  | Project Cost
B |  |  |  |  |  | 0.75 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
D |  |  |  |  |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
TOTAL
Diff to DOA
 |  |  |  |  |  | NB The date starts at 2024-07-01 and 2 people are used BD
Spreadsheet: 723727d1615855784-excel-math-equation-project
Sheet: Vehicle Sales

Model | Sales Volume | Manufacturing Cost per Vehicle | Total Cost | [NAME] | Total Sales to Dealers | % of Total Sales Volume
VX201 | 2831 | 29362.6 |  | 0.21
VX202 | 9308 | 16195.41 |  | 0.12
VX203 | 7704 | 12381.3 |  | 0.16
VX204 | 669 | 27978.45 |  | 0.22
VX205 | 7178 | 14523.84 |  | 0.25
VX206 | 6393 | 16774.66 |  | 0.16
VX207 | 125 | 35608.14 |  | 0.22
[NAME] | 1980 | 32476.92 |  | 0.23
VX209 | 5605 | 28247.82 |  | 0.21
VX210 | 4923 | 26507.06 |  | 0.2
[NAME] | 3650 | 27334.6 |  | 0.2
VX212 | 159 | 35431.2 |  | 0.21
VX213 | 6462 | 17371.7 |  | 0.15
VX214 | 5415 | 24585.48 |  | 0.18
VX215 | 4464 | 27998.08 |  | 0.22
VX216 | 5281 | 25198.81 |  | 0.18
VX217 | 794 | 31837.44 |  | 0.21
VX218 | 5891 | 18237.6 |  | 0.19
VX219 | 2678 | 29167.59 |  | 0.21
VX220 | 1485 | 31427.52 |  | 0.2
VX221 | 7468 | 12926.7 |  | 0.15
VX222 | 7493 | 13713.52 |  | 0.23
VX223 | 12118 | 17184.68 |  | 0.18
VX224 | 5710 | 23899.15 |  | 0.2
VX225 | 630 | 25362.35 |  | 0.19
VX226 | 1520 | 30582.4 |  | 0.2
VX227 | 269 | 412358.28 |  | 0.2
VX228 | 8965 | 19852.57 |  | 0.22
[NAME] | 2300 | 18784.15 |  | 0.16
VX230 | 1874 | 20850.63 |  | 0.21
Spreadsheet: 491050d1480279279-time-formula-to-calculate-employees-working-employees-working-1
Sheet: Sheet1

Start | End | Hours | Agents |  | Time of day | Workers present
06:00:00 | 16:15:00 |  |  |  | 00:00:00
06:00:00 | 16:15:00
06:30:00 | 16:45:00
07:45:00 | 17:30:00
Spreadsheet: 478591d1472886853-need-an-indexmatch-lookup-formula-tweak-i-keep-getting-n-a-s-please-help-lookupwcriteria-2-
Sheet: Display

 |  |  |  |  |  |  |  |  |  |  | [NAME] here
 | Site Code | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
 | 1165
 | 1178
 | 4050
 |  |  |  |  |  |  |  |  |  |  | Need to look up with data in Column A as a unique identifier
Spreadsheet: 267182d1379994380-concatenate-blues-test
Sheet: EventSearchResults 1 

ID | Event Date |  |  |  |  |  |  |  | Region Code | Primary Location |  |  | Event Title | Event number | [NAME]
16066 | 2013-08-27 11:15:00 |  |  |  |  |  |  |  | SI | [NAME] |  |  | Crane bucket slid-out of the crane arm contacting the ground | 1234 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | had
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | little
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lamb
16067 | 2013-08-21 21:40:00 |  |  |  |  |  |  |  | NNI | Ohinewai |  |  |  | 5678 | the
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | quick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | fox
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | over
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lazy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | so
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | there
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | !!!!!!
Spreadsheet: 416265d1440803277-index-only-visible-cells-formula-test
Sheet: Sheet1

 |  |  |  |  | User filters this data to remove all values of 0%
Data 1 | Data 2 | Data 3 | Data 4 | Data 5 | Data 6
Red | Apple | 123456 | West | US | 0.75
Red | Apple | 123457 | West | US | 0.75
Red | Apple | 123458 | East | US | 0.75
Red | Apple | 123459 | East | US | 0.75
Blue | Apple | 123460 | North | US | 1
Blue | Apple | 123461 | North | US | 1
Red | Apple | 123462 | South | US | 1
[NAME] | Apple | 123463 | South | US | 1
[NAME] | Apple | 123464 | West | US | 1
[NAME] | [NAME] | 123465 | West | US | 0.75
Yellow | [NAME] | 123466 | East | US | 0.8
Yellow | [NAME] | 123467 | East | US | 0.8
[NAME] | [NAME] | 123468 | North | US | 0.8
[NAME] | [NAME] | 123469 | North | US | 0.8
[NAME] | [NAME] | 123470 | South | US | 0.8
[NAME] | [NAME] | 123471 | South | US | 0.8
Green | [NAME] | 123472 | West | US | 0.8
Green | [NAME] | 123473 | West | US | 0.8
Green | Watermelon | 123474 | East | US | 0
Black | Watermelon | 123475 | East | US | 0
Black | Watermelon | 123476 | North | US | 0
Green | Watermelon | 123477 | North | US | 0.8
White | Watermelon | 123478 | South | US | 0.8
White | Watermelon | 123479 | South | US | 0.8
Green | Watermelon | 123480 | West | US | 0.8