tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 98907d1297719276-excel-2007-use-of-checkbox-and-cell-links-sample-pn-for-excelforum
Sheet: Month Total

Day of Month | S5109 [NAME] | S5109 Child | H0046 SE | S5150 | S5151 | Nonbillable | Behavioral Support | Personal Care | Psych-Social Rehab | Skills Training & Dev | Transportation | TX/D/C Planning | Per Diem | Objective 1 - 0 | Objective 1 - 1 | Objective 1 - 2 | Objective 1 - 3 | Objective 1 - 4 | Objective - 1 5 | Objective 2 - 0 | Objective 2 - 1 | Objective 2 - 2 | Objective 2 - 3 | Objective 2 - 4 | Objective 2 - 5 | Objective 3 - 0 | Objective 3 - 1 | Objective 3 - 2 | Objective 3 - 3 | Objective 3 - 4 | Objective 3 - 5
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
TOTALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | If yes s/b 0 | If yes s/b 1 | If yes s/b 2 | If yes s/b 3 | If yes s/b 4 | If yes s/b5 | If yes s/b 0 | If yes s/b 1 | If yes s/b 2 | If yes s/b 3 | If yes s/b 4 | If yes s/b5 | If yes s/b 0 | If yes s/b 1 | If yes s/b 2 | If yes s/b 3 | If yes s/b 4 | If yes s/b5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OR | OR | OR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | count trues | count trues then multiply x 2 | count trues then multiply x 3
Spreadsheet: 837285d1689994627-formula-for-number-sequences-book22
Sheet: Sheet1

 | Number | Department
 |  | Marketing |  | Number = sequence
 |  | Marketing
 |  | Marketing |  | Marketing starts @ 100
 |  | Marketing |  | Ecommerce starts @ 200
 |  | Marketing |  | Sales starts @ 300
 |  | E Commerce
 |  | E Commerce |  | Department | Start Number
 |  | E Commerce |  | Marketing | 100
 |  | E Commerce |  | E Commerce | 200
 |  | E Commerce |  | Sales | 300
 |  | E Commerce
 |  | E Commerce
 |  | E Commerce
 |  | E Commerce
 |  | E Commerce
 |  | Sales
 |  | Sales
 |  | Sales
 |  | Sales
 |  | Sales
 |  | Sales
 |  | Marketing
 |  | Marketing
 |  | E Commerce
Spreadsheet: 570cf09e-f974-4111-8cec-343fd9b9812b
Sheet: Capacity Zone

Forward Capacity Market Capacity Load Obligation Settlement Detail Report |  |  |  |  |  |  |  |  |  |  |  | Forward Capacity Market Capacity Load Obligation Settlement Detail Report
SD_FCMCLOSTLDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  | SD_FCMCLOSTLDTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Capacity Zone ID | Capacity Zone Name | Capacity Zone Capacity Supply Obligation | Capacity Zone RTEG Capacity Supply Obligation | Capacity Zone Peak Contributions | Capacity Zone Peak Contributions ([NAME]) | Capacity Zone Capacity Requirement | Capacity Zone HQICC | Capacity Zone Designated FCA Self-Supplied MW | Capacity Zone Capacity Load Obligation | Capacity Zone Net Regional Clearing Price | Capacity Zone Capacity Load Obligation Charge | Capacity Zone CTR Fund | Capacity Zone Specifically Allocated CTR for Pool  Planned Units | Capacity Zone Specifically Allocated CTR Credit for Pool Planned Units | Capacity Zone Specifically Allocated CTR for Transmission Upgrade | Capacity Zone Specifically Allocated CTR Credit for Transmission Upgrade | Capacity Zone Residual CTR Fund | Capacity Zone Residual CTR Fund Distribution Allocation MW
Number | String | MW | MW | MW | MW | MW | MW | MW | MW | $/kW-Month | $ | $ | MW | $ | MW | $ | $ | MW
Spreadsheet: 784942d1656018084-add-holidays-to-calendar-calendar-with-events
Sheet: Activities

 | Ref | Date | Weekday | Activity |  |  |  |  | Date | Weekday | Holiday
 |  | 2022-01-05 00:00:00 |  | Birthday for Kayla |  |  |  |  |  |  | New Year's Day
 |  | 2022-01-05 00:00:00 |  | Dentist appointment at 2 pm |  |  |  |  |  |  | [NAME]
 |  | 2022-01-05 00:00:00 |  | Dinner with the [NAME] |  |  |  |  |  |  | President's Day
 |  | 2022-01-05 00:00:00 |  | New event |  |  |  |  |  |  | Easter
 |  | 2022-01-12 00:00:00 |  | Extra day off for salon |  |  |  |  |  |  | Memorial Day
 |  | 2022-01-12 00:00:00 |  | shopping for the boys |  |  |  |  |  |  | Independence Day
 |  |  |  |  |  |  |  |  |  |  | Labor Day
 |  |  |  |  |  |  |  |  |  |  | Columbus Day
 |  |  |  |  |  |  |  |  |  |  | Veteran's Day
 |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day
 |  |  |  |  |  |  |  |  |  |  | Christmas Day
Spreadsheet: 858257d1706980355-sort-to-new-columns-current
Sheet: Sheet2

 | Action | CategoryPath | Name | Code | Artist | City | Country | Event | Podcast | Radio Show | Series | Venue
28937 | Product | 051 Club | Vertigo @ Liverpool 051 (xx.11.1991) | 6173 |  |  |  |  |  |  |  | Venue
28936 | Product | 051 Club | Parks & Wilson Live @ Club 051 Liverpool (xx.xx.1991) | 18021 |  |  |  |  |  |  |  | Venue
14848 | Product | Boxed | Johnny Vicious & Todd Terry CatBxd1101 (My Girlfriends Got A Pearl Necklace) (xx.xx.1995) | 23307 |  |  |  |  |  |  | Series
37008 | Product | Boxed | Jeremy Healy & Brandon Block Party Anthems Bxd 505 (xx.xx.1995) | 23533 |  |  |  |  |  |  | Series
15738 | Product | 051 Club | [NAME] @ 051 Club Liverpool (xx.10.1991) | 24270 |  |  |  |  |  |  |  | Venue
15739 | Product | 051 Club | Sister Bliss Live @ 051 Club Circus 1st Birthday Morecambe Beach (xx.xx.1992) | 24271 |  |  |  |  |  |  |  | Venue
17953 | Product | Boxed | [NAME] Trip Hop #1 (xx.xx.1996) | 26561 |  |  |  |  |  |  | Series
29806 | Product | A.W.O.L. | [NAME] A.W.O.L. Last Night At The Paradise Club (xx.12.1994) | 36706 |  |  |  | Event
29807 | Product | A.W.O.L. | Dr S [NAME] Last Night At The Paradise Club (xx.12.1994) | 36707 |  |  |  | Event
29808 | Product | A.W.O.L. | [NAME] Last Night At The Paradise Club (xx.12.1994) | 36708 |  |  |  | Event
29809 | Product | A.W.O.L. | Randall & Kenny [NAME] Last Night At The Paradise Club (xx.12.1994) | 36709 |  |  |  | Event
97430 | Product | Dublin Ireland | [NAME] (15.10.1993) | 50853 |  | City
46325 | Product | 1605 Podcast | Beltek 1605 Podcast #003 (05.04.2011) | 51849 |  |  |  |  | Podcast
46329 | Product | 1605 Podcast | Da Fresh 1605 Podcast #001 (xx.03.2011) | 51853 |  |  |  |  | Podcast
46345 | Product | 1605 Podcast | Erphun 1605 Podcast #004 (13.04.2011) | 51869 |  |  |  |  | Podcast
46396 | Product | 1605 Podcast | [NAME] 1605 Podcast #002 (xx.03.2011) | 51920 |  |  |  |  | Podcast
55575 | Product | &ME | &ME On The Global Network (13.02.2011) | 60238 | Artist
58441 | Product | 21st Century House Music | [NAME] On 21st Century House Music 024 (31.10.2012) | 61815 |  |  |  |  |  | Radio Show
58444 | Product | 21st Century House Music | [NAME] On 21st Century House Music 027 (23.11.2012) | 61818 |  |  |  |  |  | Radio Show
58445 | Product | 21st Century House Music | [NAME] On 21st Century House Music 028 (30.11.2012) | 61819 |  |  |  |  |  | Radio Show
97479 | Product | Dublin Ireland | [NAME] On Power FM Dublin (19.03.1994) | 83258 |  | City
97567 | Product | &ME | &ME & Dirk Rumpff On OFFtrack (20.02.2009) | 83331 | Artist
98036 | Product | Dublin | [NAME] @ Sunset Sessions Volume 0 [NAME] (23.09.2023) | 83505 |  |  | Country
98037 | Product | Dublin | [NAME] Takeover [NAME] (01.04.2023) | 83506 |  |  | Country
98038 | Product | Dublin | [NAME] @ The Final District 8 Dance at The Tivoli Dublin (26.01.2019) | 83510 |  |  | Country
98041 | Product | Dublin | Radial Live @ The Hangar Dublin (17.11.2017) | 83515 |  |  | Country
Spreadsheet: 134755d1325614820-commission-formula-based-on-cumulative-percentages-commission-sales-tracker
Sheet: Q1 Commission Tracker

 |  | January | February | March | April | Total
 | QUOTA | 14000 | 18000 | 25000 | 22000 | 79000
 | Cumulative | 14000 | 32000 | 57000 | 79000
 | Total Monthly GP | 13000 | 18000 | 3000 | 18000 | 52000
 | Cumulative Total | 13000 | 31000 | 34000 | 52000
 | % ACHIEVED | 0.9285714285714286 | 1 | 0.12 | 0.8181818181818182 | 0.6582278481012658
 | [NAME] ACHIEVED | 0.9285714285714286 | 0.96875 | 0.5964912280701754 | 0.6582278481012658
PAYOUT | Actual Paid | January | February | March | April
Level 1 | 0 - 84.99% | 0 | 0 | 0 | 0 | 0
Level 2 | 85% - 99.99% | 928.5714285714286 | 968.75 | 0 | 0 | 1897.321428571428
Level 3 | 100% to 125% | 0 | 0 | 0 | 0 | 0
 |  | Adjusted Commission
Level 1 | 0 - 84.99% | 0 | 0 | 0 | 0 | 0
Level 2 | 85% - 99.99% | 0 | 0 | 0 | 0 | 0
Level 3 | 100% to 125% | 0 | 0 | 0 | 0 | 0
 | Annual Bonus Earned | 928.5714285714286 | 0 | 0 | 0 |  | [NAME]
 | Monthly Bonus Paid | 928.5714285714286 | -928.5714285714286 | 0 | 0 | 0
 | [NAME]
Cumulative POT | 4000 | 1000 | 1000 | 1000 | 1000
Spreadsheet: 850452d1700775020-help-with-bankroll-stats-from-different-sheets-to-be-calculated-copy-of-mtt-brm-template-staking1
Sheet: Worksheet

Do not modify anything on this sheet
 |  |  |  | Between
Bankroll |  |  |  | [NAME] | min | > [NAME] | > min | btwn
Average BuyIn |  | 1 | Late % | 0.2 | 0
[NAME] |  |  | Mid Late % | 0.4 | 0.2
[NAME] based on ABI |  |  | Midde % | 0.6 | 0.4
Suggested BI |  | x | Early Mid % | 0.8 | 0.6
Sugg BI Fudged |  |  | Early % | 1 | 0.8
[NAME] Fudged
Spreadsheet: john_griffith__16102__NetcoSWListMASTER2
Sheet: Oracle-Database

 |  |  |  |  |  | NOTE: OPTION 1 (BELOW) IS THE PREFERRED OPTION
Oracle Database Server CPU Counts |  |  |  |  |  | OPTION 1 - Products for all CPUs except  9ias on 4 CPUs
Server Use | Name | # CPUs |  |  |  | Product | Lifetime | 4 Year | 2 Year
Production | Apollo | 28 |  |  |  | Ent. [NAME]. Database
 | [NAME] | 28 |  |  |  | Real Appl. Cluster
 | Skywalker | 24 |  |  |  | Partitioning Option
 | Refraction | 16 |  |  |  | OEM Tuning pack
 | E6800-1 | 16 |  |  |  | OEM Diagnostic Pack
 | [NAME] | 16 |  |  |  | [NAME]. [NAME].
 | Subtotal: |  |  |  |  | Totals:
Test | Diablo | 8
 | Ferrari | 8 |  |  |  | OPTION 2 - Products for most CPUs, RAC - 48 CPUs  Partition - 92 and  9ias - 4
 | Maserati | 8 |  |  |  | Product | Lifetime | 4 Year | 2 Year
 | [NAME] | 8 |  |  |  | Ent. [NAME]. Database | 7200000 | 4320000 | 2520000
 | Subtotal: |  |  |  |  | Real Appl. Cluster
Development | Trout | 4 |  |  |  | Partitioning Option
 | Perch | 4 |  |  |  | OEM Tuning pack | 180000 | 108000 | 63000
 | Croaker | 4 |  |  |  | OEM Diagnostic Pack | 180000 | 108000 | 63000
 | Salmon | 4 |  |  |  | [NAME]. [NAME]. | 40000 | 24000 | 14000
 | Subtotal: |  |  |  |  | Totals:
DBA Infrastructure | [NAME] | 4
 | Subtotal: |  |  |  |  | OPTION 3 - Products (no RAC and Partition) for all CPUs except 9ias - 4 CPUs
 | Total: |  |  |  |  | Product | Lifetime | 4 Year | 2 Year
 |  |  |  |  |  | Ent. [NAME]. Database | 7200000 | 4320000 | 2520000
 |  |  |  |  |  | OEM Tuning pack | 180000 | 108000 | 63000
Oracle List Prices per CPU |  |  |  |  |  | OEM Diagnostic Pack | 180000 | 108000 | 63000
Product | Lifetime | 4 Year | 2 Year |  |  | [NAME]. [NAME]. | 40000 | 24000 | 14000
Ent. [NAME]. Database | 40000 | 24000 | 14000 |  |  | Totals:
Real Appl Cluster | 20000 | 12000 | 7000
Partitioning Option | 10000 | 6000 | 3500
OEM Tuning pack | 1000 | 600 | 350
OEM Diagnostic pack | 1000 | 600 | 350
9ias Standard Ed. | 10000 | 6000 | 3500
Spreadsheet: 818625d1676973241-calculate-with-upper-and-lower-limit-percentage_20022023
Sheet: Blad1

Euwid |  |  |  |  |  |  | Nov. '22 | 800 |  |  |  | Q1 | Q2 | Q3 | Q4
Maand | Dec. | Jan. | Febr. | Ave. |  |  |  | +/- % |  |  | Euwid | -0.0822
Kraft | 938 | 913 | 900 |  |  |  |  |  | Q2 |  | HPE | -0.0737
Wellenstof | 735 | 705 | 695 |  |  |  |  |  |  |  | Solid | 0
Test 2 | 745 | 715 | 700
Totaal
Maand | Mrt. | Apr. | [NAME] | Ave.
Kraft |  |  |  |  |  |  |  |  | Q3
Wellenstof
Test 2 | 2450
Totaal
Maand | Jun. | Jul. | Aug. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q4
Wellenstof
Test 2
Totaal
Maand | Sept. | Okt. | Nov. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q1 '24
Wellenstof
Test 2
Totaal
Wood |  |  |  |  |  |  | Nov. '22
Maand | Dec. | Jan. | Febr. | Ave. |  |  |  | +/- %
Kraft |  |  |  |  |  |  |  |  | Q2
Wellenstof
Test 2
Totaal
Maand | Mrt. | Apr. | [NAME] | Ave.
Kraft |  |  |  |  |  |  |  |  | Q3
Wellenstof
Test 2
Totaal
Maand | Jun. | Jul. | Aug. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q4
Wellenstof
Test 2
Totaal
Maand | Sept. | Okt. | Nov. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q1 '24
Wellenstof
Test 2
Totaal
Solid board |  |  |  |  |  |  | Jul. '22
Maand | Jun. | Jul. | Aug. | Sept. | Okt. | Nov. | Ave. | +/- %
Kraft |  |  |  |  |  |  |  |  | Q1 '24
Wellenstof
Test 2
Totaal
Maand | Dec. | Jan. | Febr. | Mrt. | Apr. | [NAME] | Ave.
Kraft |  |  |  |  |  |  |  |  | Q3
Wellenstof
Test 2
Totaal
Spreadsheet: 125877d1319316580-excel-2007-index-function-and-data-extract-797778-index-function-and-data-extract-book1
Sheet: Sheet1

 |  | Type | LS Code | Priority | Balance | FAC Unique Key |  | Collateral Type | Amount | Collateral Unique Key | Code | Qaulity | Hair Cut | Recognized Amount |  |  |  |  |  |  | S1 | FAC Unique Key | Collateral Unique Key
 |  | Syndicated Loan - قرض تجمع متناقص |  |  |  | S1 |  | Unrated Corporate Debt Securities |  | S2 |  |  |  |  |  |  |  |  |  | << =COUNTIF(FAC_Unique_Key,W4) |  | S1
 |  | Temporary Overdraft - جاري مدين [NAME] |  |  |  | S1 |  | Real Estate Mortgage - رهونات عقارية |  | S3
 |  | Syndicated Revolving Loan - قرض تجمع دوار |  |  |  | S2 |  | Commercial Papers - الأوراق التجارية |  | S1 |  |  |  |  |  |  |  |  |  | Type | LS Code | Priority | Balance | FAC Unique Key |  | Collateral Type | Amount | Collateral Unique Key | Code | Qaulity | Hair Cut | Recognized Amount
 |  | Term Loan - قرض متناقص |  |  |  | S3 |  | Machinery & Equipment - آلات ومعدات |  | S1
Spreadsheet: 115078d1310712013-complex-connecting-data-between-2-table-table-2
Sheet: Sheet1

CODE | Aprroval status
5005023287
5004990694
5005023111
5004993940
5004980191
5004941432
5004954387
5004955222
5004955221
5004790257
5004919296
5004929785
5004964246
5004973382
5004993942
5005002227
5004941375
5004941477
5004962365
5004964435
5004970071
5005008221
5005012458
5004957073
5004955209
5005025927
5005025928
Spreadsheet: 705184d1605905035-nested-function-issue-tat-example
Sheet: Gloabl References

Weeks | SDT | Attempt | Holidays | Weekends | Accomodations | Reasons | TAT FORMULA EXAMPLE |  |  | YN | TATS (#Days)
Week 1 |  |  | 2021-01-01 00:00:00 | 2020-12-26 00:00:00 |  |  | 2020-11-12 16:34:00 | 2020-11-14 14:20:00 |  |  | SDT | 1
Week 2 | Service | 1 | 2021-05-31 00:00:00 |  | FES Replace | EP 1 | 2020-11-12 16:34:00 | 2020-11-14 14:20:00 |  | Yes | FMR/Disp | 2
Week 3 | No Coverage | 2 | 2021-09-06 00:00:00 |  | FES Return | EP 2 |  |  |  | No | NC | 1
Week 4 |  |  | 2021-11-25 00:00:00 |  | On-Site | EP 3 |  |  |  | N/A | ACC | 2
Week 5 |  |  | 2021-12-25 00:00:00 |  | Refund | EP 4 |  |  |  |  | BOS | 2
Week 6 |  |  | 2021-12-31 00:00:00 |  | SRA | EP 5 |  |  |  |  | ESC | 1
Week 7 |  |  |  |  | RGA | EP 6
Week 8 |  |  |  |  |  | EP 7
Week 9 |  |  |  |  |  | EP 8
Week 10 |  |  |  |  |  | EP 9
Week 11 |  |  |  |  |  | EA
Week 12 |  |  |  |  |  | No Coverage
Week 13 |  |  |  |  |  | Repair Delay
Week 14 |  |  |  |  |  | Parts Delay
Week 15 |  |  |  |  |  | Defective
Week 16 |  |  |  |  |  | Multiple Repairs
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Week 31
Week 32
Week 33
Week 34
Week 35
Week 36
Week 37
Week 38
Week 39
Week 40
Week 41
Week 42
Week 43
Week 44
Week 45
Week 46
Week 47
Week 48
Week 49
Week 50
Week 51
Week 52
Spreadsheet: 225135d1364908220-format-cell-4-digit-choy96
Sheet: Sheet1

1 | 1
12 | 12
123 | 123
123 | 123
1234 | 1234
2345 | 2345
3456 | 3456
4567 | 4567
5678 | 5678
6789 | 6789
7890 | 7890
8901 | 8901
9012 | 9012
Spreadsheet: 769095d1645287429-how-many-unique-areas-have-been-visited-by-vehicle-in-date-range-report
Sheet: Sheet2

Vehicle No. | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 | 2021-11-14 00:00:00 | 2021-11-15 00:00:00 | 2021-11-16 00:00:00 | 2021-11-17 00:00:00 | 2021-11-18 00:00:00 | 2021-11-19 00:00:00 | 2021-11-20 00:00:00 | 2021-11-21 00:00:00 | 2021-11-22 00:00:00 | 2021-11-23 00:00:00 | 2021-11-24 00:00:00 | 2021-11-25 00:00:00 | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00 | Total
1/63335
8/12539
11/17055
13/51504
15/70824
13/80857
13/80774
2/98435
1/67031
15/25206
15/58135
13/54318
13/16090
13/69725
_
13/70824
6/1103
13/51814
11/69228
1/64134
13/80774+1/63335
13/51504+1/64134
13/51623
15/70824+1/64134
13/80774+13/51501
12//4496
_______
1/77274
11/63335
Spreadsheet: 453239d1459233812-how-to-make-automatic-parallel-shift-based-on-specific-start-date-test_parallel-shift
Sheet: Sheet1

 |  |  | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00
 |  |  | 2016 | 2016 | 2016 | 2016 | 2017 | 2017 | 2017 | 2017 | 2018 | 2018 | 2018 | 2018 | 2019 | 2019 | 2019 | 2019 | 2020 | 2020 | 2020 | 2020
 |  |  | Q 1 | Q 2 | Q 3 | Q 4 | Q 1 | Q 2 | Q 3 | Q 4 | Q 1 | Q 2 | Q 3 | Q 4 | Q 1 | Q 2 | Q 3 | Q 4 | Q 1 | Q 2 | Q 3 | Q 4
 | Quarterly reduction |  | 0.1 | 0.02 | 0.01 | 0.01 | 0.02 | 0.06 | 0.04 | 0.05 | 0.04 | 0.04 | 0.03 | 0.04 | 0.03 | 0.04 | 0.03 | 0.05 | 0.02 | 0.02 | 0.01 | 0
Test | Start value |  | 10
 | Value adjusted for quarterly reduction
 | Actual start quarter |  | 2016-07-01 00:00:00
 | Parallel shift/offset |  | 0 | 0
 | Issue:   How to create a dynamic formula that always copy/start with cell [NAME] in the actual cell matching the right column in line 11?
Spreadsheet: 750762d1633622121-petty-cash-daily-report-working-sheet
Sheet: Report 1 Oct

 | Statement for: | 1 | 2021-10-01 00:00:00 |  | Current Date | Opening Balance
 |  |  |  |  |  | Closing Balance | 12345
 |  |  |  |  | Total Todate | Cash In
 |  |  |  |  |  | Cash Out
 | DATE | TYPE | [NAME] | Invoice Ref | CASH IN | CASH OUT | BALANCE
 |  |  | Opening Balance
Spreadsheet: 553390d1514290954-how-paste-data-on-only-visible-cells-kesh1
Sheet: Sheet1

AMBIKA SOLVEX LIMITED.,
DAILY RECEIPT/ANALYSIS REPORT
29.01.2017
MR .NO | TRUCK NO. | [NAME] | WEIGHT | NAME OF THE | PLACE |  | AVG. | MITTI | [NAME] | MITTY |  | CONT | MOIST. |  | DAMAGE |  | WEIGH | MANDI/PAR |  |  |  | FREIGHT. | FREIGHT.
 |  |  | GROSS | SUPPLIER |  |  |  | KG. | MITTI. |  | KP | NO. | % | KP | % | KP | GROSS | SHORT |  |  |  | PAID | PER QTL
 |  |  | RECEIVED |  |  |  |  |  |  |  |  |  |  |  |  |  | DESPECH
M539 | MH27/X-501 | 237 | 21.28 | [NAME] | AMARAVATI |  |  | 2.7 | 24 |  |  | 367 | 10.7 | 0 | 0 | 0 | 21.265
 |  |  |  | 60 BAG DAGI |  |  |  |  |  |  |  |  | 11.9 | 0 | 3 | 0
M540
M541 | MH28/AB-7013 | 175 | 15.76 | [NAME] | AMARAVATI |  |  | 2.3 | 20 |  |  | 367 | 11 | 0 | 0 | 0 | 15.755
M542
M543 | MH30/7013 | 200 | 18.76 | KHAMGAON |  |  |  | 2.5 | 22 |  |  | 372 | 12.5 |  | 8 |  | 18.72
M544
TOTAL
ADD OP. BALANCE
GRAND TOTAL
Spreadsheet: 791339d1660293693-problem-with-data-input-using-a-number-of-criteria-my-formula-tryouts-2022
Sheet: Sheet1

 |  |  |  |  |  | Score |  | Player | to be hidden
 |  |  |  |  | Leg 1 | 450
 |  |  |  | Game 1 | [NAME] | 501 |  | Derek
 |  |  |  |  | Leg 3 | 501
 |  |  |  |  | Leg 1 | 501
 |  |  |  | Game 2 | [NAME] | 501 |  | [NAME]
 |  |  |  |  | Leg 3 | 0
 |  |  |  |  | Leg 1 | 450
 |  |  |  | Game 3 | [NAME] | 501 |  | Ray
 |  |  |  |  | Leg 3 | 501
 |  |  |  |  | Leg 1 | 499
 |  |  |  | Game 4 | [NAME] | 501 |  | [NAME]
 |  |  |  |  | Leg 3 | 479
 |  |  |  |  | Leg 1 | 480
 |  |  |  | Game 5 | [NAME] | 501 |  | [NAME]
 |  |  |  |  | Leg 3 | 501
 |  |  |  |  | Leg 1 | 501
 |  |  |  | Game 6 | [NAME] | 501 |  | Tyler
 |  |  |  |  | Leg 3 | 0
 | Player | Leg 1 | [NAME] | Leg 3 |  | Total
 | [NAME] |  |  |  | =
 | [NAME] |  |  |  | =
 | Derek |  |  |  | =
 | Ray |  |  |  | =
 | Tyler |  |  |  | =
 | [NAME] |  |  |  | =
Spreadsheet: 31159d1226961830-allocating-ot-hours-solved-ot-example
Sheet: Solution without PT's

Raw Data |  |  |  | Helper Column | Displayed for explanation only |  |  | This column puts it all together
Employee | Campaign | Week | Hours | Emp_Wk | Hrs % | [NAME] | AllocOTHrs | Alloc OT Hrs
Employee1 | Campaign1 | Week1 | 10 | Employee1Week1 | 0.2439024390243902 | 1 | 0.24 | 0.24
Employee1 | Campaign2 | Week1 | 15 | Employee1Week1 | 0.3658536585365854 | 1 | 0.37 | 0.37
Employee1 | Campaign3 | Week1 | 16 | Employee1Week1 | 0.3902439024390244 | 1 | 0.39 | 0.39
Employee1 | Campaign1 | Week2 | 22.5 | Employee1Week2 | 0.4945054945054945 | 5.5 | 2.72 | 2.72
Employee1 | Campaign2 | Week2 | 23 | Employee1Week2 | 0.5054945054945055 | 5.5 | 2.78 | 2.78
Employee2 | Campaign1 | Week1 | 18.5 | Employee2Week1 | 0.451219512195122 | 1 | 0.45 | 0.45
Employee2 | Campaign2 | Week1 | 22.5 | Employee2Week1 | 0.5487804878048781 | 1 | 0.55 | 0.55
Employee2 | Campaign1 | Week2 | 18 | Employee2Week2 | 0.4285714285714285 | 2 | 0.86 | 0.86
Employee2 | Campaign2 | Week2 | 20 | Employee2Week2 | 0.4761904761904762 | 2 | 0.95 | 0.95
Employee2 | Campaign3 | Week2 | 4 | Employee2Week2 | 0.09523809523809523 | 2 | 0.19 | 0.19
Spreadsheet: 860222d1708409379-need-help-with-rag-status-for-multiple-projects-project-kpi-status-hd
Sheet: Overall Project Status

Overall Project Status
 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
Project-1 | Green | Green | Green
Project-2 | Amber | Green | Red
Project-3 | Green | Green | Green
Project-4 | Green | Red | Green
Project-5 | Green | Green | Green
Project-6 | Green | Green | Green
Overall Status Key:
Below rules apply to the Overall Project Status (see table above), [NAME] sheet 'Project KPIs' for individual project KPIs
RED | If any KPI is red, overall project is Red
AMBER | If any KPI is amber, overall project is amber
GREEN | If all KPIs are green, overall project status is Green