tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124094d1318089692-countifs-and-averageifs-nfl-stats
Sheet: PlayerPtsGAme

Player Name | Date of Birth | Age | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | TOTALS
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Hakeem Nicks
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Marques Colston
[NAME]
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Anquan Boldin
[NAME]
[NAME]
[NAME]
[NAME]
Deion Branch
[NAME]
Davone Bess
[NAME]
[NAME]
Malcom [NAME]
[NAME]
[NAME]
[NAME]
Nate Washington
Hines Ward
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Dez Bryant
[NAME]
[NAME]
[NAME]
[NAME]
Eddie Royal
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Jordy [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
T.J. Houshmandzadeh
[NAME]
Jerricho Cotchery
[NAME]
[NAME]
[NAME]
Roscoe Parrish
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Justin Gage
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Terrance Copper
[NAME]
[NAME]
[NAME]
[NAME]
Chaz Schilens
[NAME]
Donte' Stallworth
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Curtis Conway
Qadry Ismail
[NAME]
[NAME]
[NAME]
[NAME]
Plaxico Burress
Amani Toomer
[NAME]
Peerless Price
[NAME]
[NAME]
Laveranues Coles
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ike Hilliard
[NAME]
[NAME]
[NAME]
Raghib [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Oronde Gadsden
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Az-Zahir Hakim
[NAME]
[NAME]
Dez White
[NAME]
Tai Streets
[NAME]
[NAME]
[NAME]
[NAME]
Freddie Mitchell
[NAME]
Troy Edwards
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Derrius Thompson
[NAME]
[NAME]
[NAME]
[NAME]' [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Josh Reed
[NAME]
Dane Looker
[NAME]
Tyrone Calico
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Reche Caldwell
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Arnaz Battle
[NAME]
Keary Colbert
[NAME]
[NAME]
[NAME]
[NAME]
Jerheme Urban
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: PoncaOsage

Ponca/Osage
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
PONCA CITY/MANNFORD STATIONS - PLP - 172871
Beginning Inventory | 9493.01
Receipts | 29635.76
Deliveries | 29353.51
Ending Inventory | 9521
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
CLEAR STATION - PLP - 172852
Beginning Inventory | 6329.97
Receipts | 35751.23
Deliveries | 0
Ending Inventory | 6996.07
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
HOMINY STATION - PLP - 172845
Beginning Inventory | 52953.82
Receipts | 92120.82
Deliveries | 87195.96
Ending Inventory | 57951.99
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | -168.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
THAT CREEK STATION - PLP - 172840
Beginning Inventory | 5189.61
Receipts | 80216.84
Deliveries | 80292.05
Ending Inventory | 5183.91
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
WEBB CITY MAINLINE - PLP - 172961
Beginning Inventory | 86262.47
Receipts | 121106.52
Deliveries | 145342.75
Ending Inventory | 96424.38
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
CIMARRON STATION - PLP - 172870 - SWT
Beginning Inventory | 106957.3
Receipts | 133191.28
Deliveries | 170172
Ending Inventory | 66643.12
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
CIMARRON STATION - PLP - 172931 - OSR
Beginning Inventory | 160564.87
Receipts | 45111.75
Deliveries | 45253.72
Ending Inventory | 164294.51
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
TOTAL PONCA/OSAGE PIPELINE
Beginning Inventory |  | 0
Receipts | 309115.51
Deliveries | 329591.3
Ending Inventory
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's |  |  | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 871342d1717729861-filter-function-e1-and-e2
Sheet: Expected1

 |  |  | Last Column F of D' Sheet
 | 646 | American Express  Pvt.Ltd,Los angles (30018) | 5343114.98
 | 846 | Lantus Incoporation.,New Airland | -2081323.2
 | New | New Vaccine Corporation,Greenland (25636) | 1924111
 | 12 | Jhonson & Johnson Movers  Ltd,Tumbaktu | 1102100
 | 724 | [NAME] [P] Ltd (605053) | -223902.7
 | 948 | Cal Industries Pvt Ltd,[NAME] (4000) | 4286.39
 |  | Total
Spreadsheet: 288948d1389357571-sorting-question-trying-to-force-a-row-of-data-to-apper-in-the-wrong-sort-location-excelforumsupersort-2014-01-10-07-34
Sheet: Unique Start Values

 |  |  | Production ID | ProjectID | Start | Super Sort
 |  |  |  | 4 | 12 | 12
 |  |  |  | 2 | 14 | 14
 |  |  |  | 7 | 16 | 16
 |  |  |  | 15 | 23 | 23
 |  |  | 5 | 1 | 26 | 26
 |  |  |  | 5 | 99 | 26.1
 |  |  |  | 8 | 56 | 56
 |  |  |  | 12 | 88 | 88
 |  |  | 14 | 9 | 91 | 91
 |  |  |  | 14 | 1 | 91.1
 |  |  |  | 10 | 115 | 115
 |  |  |  | 11 | 123 | 123
 |  |  |  | 13 | 236 | 236
 |  |  |  | 6 | 458 | 458
 |  |  |  | 3 | 498 | 498
 |  |  | After [NAME], the 5 and 14 ended underneith 1 and 9 respectively, that’s what I want
Spreadsheet: 775151d1648842252-help-with-transpose-and-frequency-formula-excel-example
Sheet: Example

Filter by Rep email address | Cadence
 | Monthly | Weekly | Daily | Never / Rarely |  |  | Monthly | Weekly | Daily | Never / Rarely
Assist warehouse with lost/mis-directed shipments - Cadence | 6 | 2 | 1 | 2
Assist warehouse with product identifcation - Cadence | 6 | 5 | 2 | 3 |  | Assist warehouse with product identifcation - Cadence
Calling customers for pickup orders - Cadence | 6 | 2 | 2 | 0 |  | Calling customers for pickup orders - Cadence
Collections / Chasing Payments - Cadence | 1 | 5 | 5 | 2 |  | Collections / Chasing Payments - Cadence
Contacting Purchasing for missing order confirmation in JDE - Cadence | 4 | 3 | 5 | 2 |  | Contacting Purchasing for missing order confirmation in JDE - Cadence
Correcting JDE or warehouse generated errors (kits, ship confirm, ) - Cadence | 5 | 5 | 5 | 2 |  | Correcting JDE or warehouse generated errors (kits, ship confirm, ) - Cadence
Costing from vendor - Cadence | 2 | 1 | 5 | 2 |  | Costing from vendor - Cadence
Credit card orders - Cadence | 1 | 2 | 5 | 2 |  | Credit card orders - Cadence
Credits/RGA/Debits - Cadence | 4 | 2 | 5 | 2 |  | Credits/RGA/Debits - Cadence
Drop Ship Orders - Cadence | 6 | 2 | 5 | 2 |  | Drop Ship Orders - Cadence
Expediting- internal departments (warehouse, shop) - Cadence | 8 | 5 | 5 | 2 |  | Expediting- internal departments (warehouse, shop) - Cadence
Expediting- with vendor - Cadence | 3 | 2 | 5 | 2 |  | Expediting- with vendor - Cadence
Export Docs - Cadence | 2 | 6 | 5 | 2 |  | Export Docs - Cadence
Freight Quotes & Freight Charges on Orders - Cadence | 5 | 6 | 5 | 2 |  | Freight Quotes & Freight Charges on Orders - Cadence
Generate customer UPS pick-up & waybills - Cadence | 6 | 8 | 5 | 2 |  | Generate customer UPS pick-up & waybills - Cadence
Incorrect JDE information - parts needing corrections/duplicates - Cadence | 7 | 8 | 5 | 2 |  | Incorrect JDE information - parts needing corrections/duplicates - Cadence
New Vendor Set Up - Cadence | 8 | 2 | 5 | 2 |  | New Vendor Set Up - Cadence
Non divisional Calls from customers - Cadence | 5 | 1 | 5 | 2 |  | Non divisional Calls from customers - Cadence
Release M1/C1 Holds - Cadence | 5 | 0 | 5 | 2 |  | Release M1/C1 Holds - Cadence
Reseller Quote Follow Ups - Cadence | 3 | 6 | 5 | 2 |  | Reseller Quote Follow Ups - Cadence
Re-send Packing Slips - Cadence | 3 | 5 | 5 | 2 |  | Re-send Packing Slips - Cadence
Send tracking information - Cadence | 2 | 3 | 5 | 2 |  | Send tracking information - Cadence
Sending invoices to customers - Cadence |  | 8 | 5 | 2 |  | Sending invoices to customers - Cadence
Sorting out billing issues/advising correct amounts - Cadence | 5 | 7 | 5 | 2 |  | Sorting out billing issues/advising correct amounts - Cadence
Vendor Purchase order Corrections - Cadence | 6 | 1 | 5 | 2 |  | Vendor Purchase order Corrections - Cadence
Spreadsheet: 159699d1338820613-lookup-on-two-criteria-values-sample-worksheet
Sheet: Sheet1

 | Price |  |  | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25
Model 1 | 401 |  |  | 401 | 418 | 436 | 456 | 477 | 501 | 528 | 557 | 580 | 587 | 595 | 603 | 611 | 619
Model 2 | 413 |  |  | 413 | 430 | 449 | 469 | 492 | 516 | 543 | 574 | 600 | 608 | 615 | 623 | 632 | 640
Model 3 | 414 |  |  | 414 | 432 | 450 | 471 | 493 | 518 | 545 | 576 | 600 | 608 | 615 | 623 | 632 | 640
Model 4 | 422 |  |  | 422 | 439 | 458 | 479 | 502 | 527 | 555 | 586 | 620 | 633 | 641 | 649 | 658 | 667
Model 5 | 432 |  |  | 432 | 450 | 470 | 491 | 514 | 540 | 569 | 600 | 635 | 643 | 651 | 660 | 668 | 677
Model 6 | 443 |  |  | 443 | 461 | 481 | 503 | 527 | 553 | 582 | 610 | 618 | 625 | 633 | 642 | 650 | 659
Model 7 | 447 |  |  | 447 | 466 | 486 | 508 | 532 | 559 | 588 | 621 | 648 | 656 | 664 | 673 | 682 | 691
Model 8 | 468 |  |  | 468 | 487 | 508 | 531 | 557 | 585 | 615 | 648 | 656 | 665 | 673 | 682 | 691 | 700
Model 9 | 474 |  |  | 474 | 493 | 515 | 538 | 564 | 592 | 623 | 658 | 670 | 678 | 687 | 696 | 705 | 715
Model 10 | 496 |  |  | 496 | 516 | 539 | 563 | 590 | 620 | 652 | 663 | 671 | 680 | 688 | 697 | 707 | 716
Model 4
Spreadsheet: 716900d1612412848-return-latest-balance-for-each-accounts-return-n-a-if-no-rows-of-data-forum-excel-3-f-v-2021
Sheet: Épargne Inv.

 | Date | Description | Compte | Solde relevé |  | Compte | Profit /perte (12 mois A.F.) | Solde fermeture
 | 2020-01-01 00:00:00 | Solde départ | Chèque | 1000 |  | Chèque
 | 2020-01-31 00:00:00 | Solde de fermeture | Chèque | 1200 |  | A
 | 2020-02-29 00:00:00 | Solde de fermeture | Chèque | 1100 |  | B
 | 2020-03-31 00:00:00 | Solde de fermeture | Chèque | 900 |  | C
 | 2020-04-30 00:00:00 | Solde de fermeture | Chèque | 1250 |  | D
 | 2020-05-31 00:00:00 | Solde de fermeture | Chèque | 1400
 | 2020-06-30 00:00:00 | Solde de fermeture | Chèque | 1100
 | 2020-07-31 00:00:00 | Solde de fermeture | Chèque | 1300
 | 2020-08-31 00:00:00 | Solde de fermeture | Chèque | 1150
 | 2020-09-30 00:00:00 | Solde de fermeture | Chèque | 1000
 | 2020-10-31 00:00:00 | Solde de fermeture | Chèque | 800
 | 2020-11-30 00:00:00 | Solde de fermeture | Chèque | 600
 | 2020-12-31 00:00:00 | Solde de fermeture | Chèque | 500
 | Date | Description | Compte | Solde [NAME] | Montant | Profit / perte | Solde  fermeture
 | 2020-01-01 00:00:00 |  | A | 1000 | 200
 | 2020-01-01 00:00:00 |  | B | 1500 | 500
 | 2020-01-14 00:00:00 |  | C |  | 300
 | 2020-02-13 00:00:00 |  | A |  | 350
 | 2020-02-27 00:00:00 |  | B |  | 1014
 | 2020-02-27 00:00:00 |  | C |  | 100
 | 2020-03-03 00:00:00 |  | A |  | 1026
 | 2020-03-03 00:00:00 |  | D |  | 550
 | 2020-06-30 00:00:00 |  | C | 500
 | 2020-12-31 00:00:00 |  | D | 600
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 2

 | October 11 | October 18 | October 25 | November 1 | November 8
Total Interest Rate*
SDs and MSPs** | 516604549.51 | 518535428.73 | 525887281 | 526615510.35 | 531262207.76
Other | 104873972.25 | 106329233.95 | 107203817.45 | 107316418.04 | 108919626.9
Total Cross-Currency
SDs and MSPs | 20073975 | 20119076 | 21275125 | 20107498 | 20188287
Other | 6127128 | 6090620 | 7885678 | 5933178 | 5920825
Total Credit
SDs and MSPs | 14083490 | 14224869 | 14384079 | 14396393 | 13836753
Other | 4350141 | 4458756 | 4460924 | 4490323 | 4267972
Total FX**** | 62900000 | 62900000 | 62900000 | 62900000 | 62900000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 8840000 | 8840000 | 8840000 | 8840000 | 8840000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 3400000 | 3400000 | 3400000 | 3400000 | 3400000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL
Weekly snapshot, gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. Because this table shows the aggregated notional values of swaps by participant, the totals on this table are twice those displayed on the "Gross Notional Outstanding by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 73cc597c-25f7-4e4a-af95-086950399102
Sheet: Sheet1

State [NAME] (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 12/17/2014 10:16:34 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
District | [NAME] | [NAME] | [NAME] | Whitney Hauz | TOTALS
District 02 | 1 | 0 | 0 | 0 | 1
District 03 | 0 | 0 | 0 | 0 | 0
District 04 | 0 | 0 | 0 | 0 | 0
District 05 | 0 | 1 | 0 | 0 | 1
District 06 | 0 | 0 | 0 | 0 | 0
District 11 | 0 | 0 | 0 | 0 | 0
District 13 | 0 | 0 | 0 | 0 | 0
District 20 | 0 | 0 | 0 | 0 | 0
District 21 | 0 | 0 | 0 | 0 | 0
District 22 | 0 | 0 | 0 | 0 | 0
District 27 | 0 | 0 | 0 | 0 | 0
District 36 | 0 | 0 | 0 | 0 | 0
District 37 | 0 | 0 | 0 | 0 | 0
District 38 | 0 | 0 | 0 | 0 | 0
District 40 | 0 | 0 | 0 | 0 | 0
District 41 | 0 | 0 | 0 | 0 | 0
District 44 | 1 | 0 | 1 | 1 | 3
District 45 | 0 | 0 | 1 | 0 | 1
District 46 | 0 | 0 | 0 | 0 | 0
TOTAL | 2 | 1 | 2 | 1 | 6
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 3162b01c-7700-4a0e-8362-179d22852037
Sheet: Disability codes

 |  | SFY 2014 FEDERAL CODE SHEET
SFY 2014 FEDERAL EDRS-SERVS-UFARS codes crosswalk
UFARS Program Code to EDRS Disability Code
UFARS PROGRAM CODE | EDRS DISABILITY CODE | [NAME]
401 | 401 | Speech or Language Impairments
402 | 402 | Developmental Cognitive Disability - Mild -Moderate
403 | 403 | Developmental Cognitive Disability - Severe-Profound
404 | 404 | Physically Impaired
405 | 405 | Deaf and Hard of Hearing
406 | 406 | Visually Impaired
407 | 407 | Specific Learning Disability
408 | 408 | Emotional or Behavioral Disorders
409 | 409 | Deaf-Blind
410 | 410 | Other Health Disabilities
411 | 411 | Autism Spectrum Disorders
412 | 412 | Developmentally Delayed
414 | 414 | Traumatic Brian Injury
416 | 416 | Severely Multiply Impaired
420 | 420 | Special Education - Aggregate (3 or more Disabilities)
422 | 422 | Non-Disabled (no IEP/IFSP/IIIP) (use FSC Z CEIS and FSC z MCEIS only)
Spreadsheet: 37241d1235172276-addition-calculation-not-giving-correct-answer-question
Sheet: sheet1

 | date | Item | listing price | sold for up to $25 | sold for over $25 | total sale price | ship fees | total sale price incl shipping | insertion fee | final value fee up to $25 | final value fee over $25 | sale price less fees | total fees | paypal fees | delivery confirm fee | ins fees I paid | total of all fees paid on the sale | final amount I get from sale | THE ADDITION IS NOT COMING UP CORRECTLY SEE BELOW
 |  |  | 74 | 25 | 82.01 | 107.01 | 5.62 | 112.63 | 2.25 | 2.1875 | 2.870350000000001 | 99.70215 | 7.30785 | 3.56627 | 0.18 | 2.6 | 13.65412 | 93.35588 | THIS FIGURE SHOUD BE 13.66
 |  |  | 49.99 | 25 | 24.99 | 49.98999999999999 | 4.96 | 54.95 | 1 | 2.1875 | 0.87465 | 45.92784999999999 | 4.06215 | 1.89355 | 0.18 | 1.7 | 7.8357 | 42.15429999999999 | THIS FIGURE SHOULD BE 7.83
 |  |  | 44.99 | 25 | 31.88 | 56.88 | 6.43 | 63.31 | 1 | 2.1875 | 1.1158 | 52.5767 | 4.3033 | 2.13599 | 0.18 | 0 | 6.619289999999999 | 50.26071 | SHOULD BE 4.31
 |  |  | 19.99 | 25 | 56 | 81 | 3.68 | 84.68 | 0.55 | 2.1875 | 1.96 | 76.3025 | 4.6975 | 2.75572 | 0.18 | 2.15 | 9.78322 | 71.21678 | SHOULD BE 9.79
 |  |  | 130.99 | 25 | 153.05 | 178.05 | 6.62 | 184.67 | 2.25 | 2.1875 | 5.356750000000001 | 168.25575 | 9.794250000000002 | 5.655430000000001 | 0.18 | 2.6 | 18.22968 | 159.82032 | total fees should be $9.80
 |  |  | 24.99 | 25 | 6 | 31 | 3.98 | 34.98 | 0.55 | 2.1875 | 0.21 | 28.0525 | 2.9475 | 1.31442 | 0.18 | 1.7 | 6.14192 | 24.85808 | THIS ROW IS FINE
 |  |  | 174.99 | 25 | 149.99 | 174.99 | 6.96 | 181.95 | 2 | 2.1875 | 5.249650000000001 | 165.55285 | 9.43715 | 5.576550000000001 | 0.18 | 2.6 | 17.7937 | 157.1963 | SHOULD BE 17.80
 |  |  | 94.99 | 25 | 182.5 | 207.5 | 5.62 | 213.12 | 2 | 2.1875 | 6.3875 | 196.925 | 10.575 | 6.48048 | 0.18 | 4.6 | 21.83548 | 185.66452 | THIS ROW IS FINE
Spreadsheet: 752592d1634841379-circular-reference-issue-copy-of-excel-employee-vacation-sheet-2021-prototype
Sheet: Oct

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative A; Approved
Compressed Day Off
Assignment / Left
Half Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
October | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 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 |  | Replaced by:
October Total
Spreadsheet: 743342d1628428667-date-calculation-date-calculation
Sheet: Sheet1

Example 1 |  |  | Example 2
Working Date | Task |  | Working Date | Task
- | 0 |  | - | 0
- | 0 |  | 2021-01-30 00:00:00 | 20
2021-02-15 00:00:00 | 100 |  | 2021-02-15 00:00:00 | 100
- | 0 |  | 2021-02-28 00:00:00 | 0
- | 0 |  | - | 0
Number of days |  |  | Number of days
Finished date | 2021-06-30 00:00:00 |  | Finished date | 2021-06-30 00:00:00
What is the formula in cell that is highlighted in yellow color?
Finished date will auto minus the first working date in the column and working date is only shown if there have any number in Task column.
Meaning to say Working date is dependent on Task column
Inside the highlighted cell got formula to solve this problem but I think this formula is not good enough. My actual data is very long.
This formula can be very long if the actual data continue to increase
So I looking alternative formula
Spreadsheet: 60054d1260557660-copy-cells-to-adjacent-column-removing-blanks-710062_jbitluk
Sheet: Example

 |  |  |  |  |  |  |  |  | Inputs | Results
A |  | 1 |  |  |  |  |  |  | A | A
B |  | 1 |  |  |  |  |  |  | B | B |  | C is presently using a RAND function to vary the output per calculation so you can see it working...
C |  | 0 |  |  |  |  |  |  |  | F
D |  | 0 |  |  |  |  |  |  |  | L
E |  | 0 |  |  |  |  |  |  |  | N
F |  | 1 |  |  |  |  |  |  | F | O
G |  | 0 |  |  |  |  |  |  |  | Q
H |  | 0 |  |  |  |  |  |  |  | R
I |  | 0 |  |  |  |  |  |  |  | S
J |  | 0 |  |  |  |  |  |  |  | T
K |  | 0 |  |  |  |  |  |  |  | V
L |  | 1 |  |  |  |  |  |  | L | W
M |  | 0 |  |  |  |  |  |  |  | X
N |  | 1 |  |  |  |  |  |  | N | Y
O |  | 1 |  |  |  |  |  |  | O | AA
P |  | 0 |  |  |  |  |  |  |  | AE
Q |  | 1 |  |  |  |  |  |  | Q | AG
R |  | 1 |  |  |  |  |  |  | R | AH
S |  | 1 |  |  |  |  |  |  | S | AI
T |  | 1 |  |  |  |  |  |  | T | AJ
U |  | 0 |  |  |  |  |  |  |  | AL
V |  | 1 |  |  |  |  |  |  | V | AM
W |  | 1 |  |  |  |  |  |  | W | AQ
X |  | 1 |  |  |  |  |  |  | X | AR
Y |  | 1 |  |  |  |  |  |  | Y | AU
Z |  | 0 |  |  |  |  |  |  |  | AW
AA |  | 1 |  |  |  |  |  |  | AA | AY
AB |  | 0
AC |  | 0
AD |  | 0
AE |  | 1 |  |  |  |  |  |  | AE
AF |  | 0
AG |  | 1 |  |  |  |  |  |  | AG
AH |  | 1 |  |  |  |  |  |  | AH
AI |  | 1 |  |  |  |  |  |  | AI
AJ |  | 1 |  |  |  |  |  |  | AJ
AK |  | 0
AL |  | 1 |  |  |  |  |  |  | AL
AM |  | 1 |  |  |  |  |  |  | AM
AN |  | 0
AO |  | 0
AP |  | 0
AQ |  | 1 |  |  |  |  |  |  | AQ
AR |  | 1 |  |  |  |  |  |  | AR
AS |  | 0
AT |  | 0
AU |  | 1 |  |  |  |  |  |  | AU
AV |  | 0
AW |  | 1 |  |  |  |  |  |  | AW
AX |  | 0
AY |  | 1 |  |  |  |  |  |  | AY
Spreadsheet: 20db7227-fb63-40d1-bf3d-2b123f3bdc17
Sheet: AMI

DistrictCountyNumber | DistrictNumber | DistrictType | DistrictName | DemographicGroup | DemographicCategory | DemographicDescription | FourYearCount_2011 | FourYearPercent_2011 | FourYearCount_2012 | FourYearPercent_2012 | Percent_Increase
04 | 0038 | 01 | RED LAKE PUBLIC SCHOOL DISTRICT | Ethnicity | B | American Indian/Alaskan Native | 9 | 8.74 | 23 | 22.77 | 14.03
69 | 0709 | 01 | DULUTH PUBLIC SCHOOL DISTRICT | Ethnicity | B | American Indian/Alaskan Native | 17 | 26.56 | 20 | 39.22 | 12.66
04 | 0031 | 01 | BEMIDJI PUBLIC SCHOOL DISTRICT | Ethnicity | B | American Indian/Alaskan Native | 17 | 21.52 | 26 | 30.95 | 9.43
11 | 0115 | 01 | CASS LAKE-BENA PUBLIC SCHOOLS | Ethnicity | B | American Indian/Alaskan Native | 18 | 30 | 24 | 38.71 | 8.71
62 | 0625 | 01 | ST. PAUL PUBLIC SCHOOL DISTRICT | Ethnicity | B | American Indian/Alaskan Native | 21 | 46.67 | 21 | 52.5 | 5.83
27 | 0001 | 03 | MINNEAPOLIS PUBLIC SCHOOL DIST. | Ethnicity | B | American Indian/Alaskan Native | 27 | 21.77 | 21 | 25 | 3.23
Spreadsheet: andy_zipper__792__10_26_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22 | 206 | 213 | 51.5 | 53.3 | 0.72 | 2001-10-26 11:28:00
 | CL F2 | 22.5 | 335 | 342 | 51.2 | 52.3 | 0.73 | 2001-10-26 11:28:00
 | CL G2 | 22.5 | 420 | 435 | 49.9 | 51.7 | 0.72 | 2001-10-26 11:28:00
 | CL H2 | 22.5 | 470 | 485 | 48.2 | 49.7 | 0.69 | 2001-10-26 11:28:00
 | CL J2 | 22.5 | 500 | 520 | 45.8 | 47.7 | 0.66 | 2001-10-26 11:28:00
 | CL K2 | 22.5 | 525 | 540 | 43.5 | 44.7 | 0.62 | 2001-10-26 11:28:00
 | CL M2 | 22 | 530 | 545 | 41.7 | 42.9 | 0.59 | 2001-10-26 11:28:00
 | CL N2 | 22 | 545 | 560 | 40 | 41.1 | 0.56 | 2001-10-26 11:28:00
 | CL Q2 | 22 | 550 | 565 | 38.1 | 39.2 | 0.53 | 2001-10-26 11:28:00
 | CL U2 | 22 | 555 | 570 | 36.7 | 37.7 | 0.51 | 2001-10-26 11:28:00
 | [NAME] | 22 | 560 | 575 | 35.3 | 36.2 | 0.49 | 2001-10-26 11:28:00
 | CL X2 | 22 | 560 | 575 | 33.9 | 34.8 | 0.48 | 2001-10-26 11:28:00
 | [NAME] | 22 | 562 | 575 | 32.9 | 33.6 | 0.46 | 2001-10-26 11:28:00
 | CL M3 | 21.5 | 555 | 575 | 28.1 | 29.2 | 0.39 | 2001-10-26 11:28:00
 | CL Z3 | 21.5 | 555 | 575 | 25.1 | 26 | 0.35 | 2001-10-26 11:28:00
Spreadsheet: 750276d1633366424-nested-formulas-sample-update
Sheet: Client List

Programme Date | Stage | Type | Description | Account Name | Delivery | Product Fee | Actual
2021-04-10 00:00:00 | Order | Veg | Organic | Number1
2021-04-11 00:00:00 | Order | Meat | [NAME] | Number2
2021-04-12 00:00:00 | Buy | Fuit | Frozen | Number3
2021-04-13 00:00:00 | Order | Fresh | Single Pack | Number4
2021-04-14 00:00:00 | Query | Other | Cooked | Number5
2021-04-15 00:00:00 | Query | Fuit | No Package | Number6
2021-04-16 00:00:00 | Buy | Veg | Cooked | Number7