tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 108569d1305616999-how-to-pick-out-multiple-values-from-a-range-that-are-in-a-separate-table-forum-example
Sheet: Sheet1

 |  | WEEK # |  |  |  |  |  |  |  | WEEK # |  |  |  |  |  |  |  | WEEK # |  |  |  |  |  |  |  | WEEK #
 |  | 2011-03-31 00:00:00
 | [NAME] | DAY | DAY | DAY | DAY | NT | NT | RDO |  | NT | NT | NT | NT | RDO | RDO | RDO |  | AHOD | NT | NT | AHOD | NT | NT | RDO |  | NT | LEAD | NT | NT | NT | NT | RDO
 | CURLEY | NT | NT | NT | NT | DAY | LEAD | RDO |  | DAY | DAY | DAY | DAY | RDO | RDO | RDO |  | HOD | NT | NT | NT | LEAD | NT | RDO |  | DAY | DAY | DAY | DAY | DAY | DAY | RDO
 | MO | DAY | DIL | DAY | DAY | DAY | PHO | RDO |  | DAY | DIL | DAY | DAY | DAY | DAY | DAY |  | DAY | NT | DAY | DAY | DAY | DAY | RDO |  | DAY | PHO | DAY | DAY | DAY | DAY | RDO
 |  | WEEK # |  |  |  |  |  |  |  | WEEK # |  |  |  |  |  |  |  | WEEK # |  |  |  |  |  |  |  | WEEK #
 | [NAME] | DAY | DAY | DAY | DAY | NT | NT | RDO |  | NT | NT | NT | NT | RDO | RDO | RDO |  | AHOD | NT | NT | AHOD | NT | NT | RDO |  | NT | LEAD | NT | NT | NT | NT | RDO
 | CURLEY | NT | NT | NT | PHO | DAY | LEAD | RDO |  | DAY | DAY | DAY | DAY | RDO | RDO | RDO |  | HOD | NT | NT | NT | LEAD | NT | RDO |  | DAY | DAY | DAY | DAY | DAY | DAY | RDO
 | MO | DAY | DIL | DAY | NT | DAY | PHO | RDO |  | DAY | DIL | DAY | DAY | DAY | DAY | DAY |  | DAY | NT | DAY | DAY | DAY | DAY | RDO |  | DAY | PHO | DAY | DAY | DAY | DAY | RDO
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | NYD | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-03 00:00:00 | CNY | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-04 00:00:00 | CNY | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-05 00:00:00 | CNY | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-05 00:00:00 | CHING MING | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-01 00:00:00 | LABOUR DAY | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-13 00:00:00 | MAF | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-01 00:00:00 | NATIONAL DAY | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-05 00:00:00 | CHUNG YEUNG | type 1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-20 00:00:00 | MACAU EST DAY | type 2
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-22 00:00:00 | GOOD FRIDAY | type 2
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-06 00:00:00 | DBF | type 2
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-22 00:00:00 | WINTER SOLSTICE | type 2
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-25 00:00:00 | xmas | type 2
Spreadsheet: cca41e6e-475b-443b-9d57-658ea1b32aaf
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193150226 | L Spenser Smith & Testament | Assignment No. 1 | 2004-06-08 | Compact Disc | Black Gospel | 16.99 | N | To Be Retired
Taseis | 801193150790 | L Spenser Smith & Testament | Live At The Ritz | 2005-03-22 | Music DVD | Black Gospel | 14.97 | N | To Be Retired
Spreadsheet: 101967d1300039548-problem-with-function-when-cutting-the-cell-content-and-then-pasting-to-another-cell-problem
Sheet: 2

podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4 |  | "Podatak" means data in Serbian language
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4 |  | How to, for all these data, automatically implement the formula (function)
podatak 1 | podatak 2 | podatak 3 | podatak 4 |  | which wont change source cell when I use "cut" option?
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
Spreadsheet: ec5edb04-69d9-4c9e-acdd-05ca82efad64
Sheet: Sheet1

County Commissioner - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/22/2013 10:28:43 PM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | write-in | TOTALS
Precinct 43 | 28 | 0 | 28
Precinct 45 | 18 | 0 | 18
Precinct 55 | 16 | 1 | 17
Precinct 60 | 134 | 1 | 135
Precinct 67 | 46 | 3 | 49
Precinct 74 | 8 | 0 | 8
TOTAL | 250 | 5 | 255
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 2d533331-4adc-4882-bf47-d55d7a0299dd
Sheet: Sheet1

Offense | Conquences | Press Charges | Monticello | NCWISE Code | Notes
Possession of Firearm | 365 Days OSS | Yes | No | 8 - Possession of Firearm | Indication to use recommended expulsion
Possession of Weapon (BB/pellet gun, bow & arrow, stun gun, bowie knife, dagger, leaded cone, switchblade, blackjack, brass knuckles, razors, razor blades, pepper spray, martial arts weapons, etc.) | 365 Days OSS | Yes | Case by case* | 9 - Possession of Weapon | *Monticello placement for rest of year
Possession of pocket knife or multi-use tool (No Intent)* | 10 Days OSS | Yes/No* | Yes | Possession of Dangerous Object | Must consider intent.  *Student turns in - may reduce OSS (consult with SRO)
Possession of pocket knife or sharpe objects (Intent) | 10 Days OSS | Yes | Case by case* | 9 - Possession of Weapon | *Monticello placement for rest of year
Selling, transmitting, distributing illegal drugs (including prescription medicine) | OSS Remainder of the year | Yes | Case by case | Possession of a controlled substance in violation of law [NAME] to chart for code for drugs
Possession of illegal drugs, alcohol, prescription medicine | 10 Days OSS* | Yes | Yes |  | *May reduce to 5 days with outside intervention, one time during 6th-12th grades
Possession of over-the-counter drugs (diet pills, caffeine, etc.) (Distribution - case by case, administration must consider intent) | 3-10 Days OSS | No/Yes* | Yes |  | *If distribution, consult with SRO
Under the influence of drugs, alcohol, or odor of same on person | 10 Days OSS* | Yes | Yes | Violation of School Rules | *May reduce to 5 days with outside intervention, one time during 6th-12th grades
*Fighting or [NAME] | 5-10 Days OSS* | Yes | Yes | 24 - Fighting Aggressive Behavior to Student Refer to chart for code | Principal consider mitigating factors (i.e., self defense)
Fighting, assault with serious injury | Minimum of 10 Days OSS* | Yes | Case by case* | 1 - Assault Resulting in Serious Injury | *Long term suspension may be recommended
Threats/Harassment, Bullying | 3-10 Days OSS | Case by case | Case by case | Case by case | Consider mediation
Felony Arrest Outside School | Case by case | Case by case | Case by case | Case by case | Report to Central Office.  Can't participate in Extra-curricular Activities until charges are cleared
Possession or Use of Tobacco | 3,5,10 Days of OSS | No | Yes | 41 - Possession of tobacco 70 -Use of tobacco  Violation of School Rules | Refer to SAP
Making a Bomb Threat | 365 Days OSS | Yes | No | 43 - Bomb Threat
Setting a Fire in Building | 365 Days OSS | Yes | No | 53 - Burning a School
Pulling a Fire Alarm | 10 Days OSS | Yes | Yes | 29 - False fire alarm Violation of School Rules | Report to [NAME]
[NAME] related activity, wardrobe, flashing sign, graffiti | 5-10 Days | Case by case | Case by Case | 79 - Gang activity Case by case | Notify SRO Required parent conference
2008-08-14 00:00:00
Spreadsheet: 713043d1610539396-random-allocation-require-to-be-based-on-few-criteria-sample
Sheet: List of operatives working 

 |  |  | Packing only | Both | Putting only | Selection
Worker | Packing | Putting | 0
[NAME] | y | n
[NAME] | Y | y
[NAME] | y | n
[NAME] | n | y
[NAME] One | n | y
[NAME] | y | y
Spreadsheet: 111775d1308076840-sorting-list-acording-to-lookup-values-sortlist-1-
Sheet: MAIN

RESULTS |  |  |  |  |  |  | INPUT
 | PRODUCT | QTY |  |  |  |  | PRODUCT | QTY
BROWNIE | PRODUCT 2 | 2 |  |  |  |  | PRODUCT 1 | 1
 |  |  |  |  |  |  | PRODUCT 2 | 2
 |  |  |  |  |  |  | PRODUCT 4 | 3
FLAPJACK | PRODUCT 4 | 3
SHORTBREAD | PRODUCT 1 | 1
Spreadsheet: 5eba3c98-7e89-43f3-b521-d9ddb3eb035c
Sheet: Sheet1

Course Title: _________________________________________      CE PIN # ____________ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Course Provider/Sponsor: ______________________ | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Course Instructor: _________________________ |  |  |  | Course Date: ___________ | Location: __________________________
 | Attendees: Your NC Certification # is required to receive credit for attending this class.                                           If you are not currently NC Certified, please mark "N/A"  for certification #. |  |  |  |  |  |  | This Section to be Completed by Class Monitor
 | Attendee Name  (Typed / Printed) |  |  | Signature |  | NC Well [NAME]. # |  | Time In | Time Out | Total Hours Earned
 | Last Name | First Name |  | [NAME] |  | NCWC 1234-A |  | 07:55:00 | 05:02:00 | 8
1)
2)
3)
4)
5)
6)
7)
8)
9)
10)
11)
12)
13)
14)
15)
16)
17)
18)
19)
20)
 |  | Class Monitor: Time docked in 1/2 hour increments. Dock time for more than 10 min. late or leaving early.
Spreadsheet: 38610d1236770123-summarizing-data-over-several-sheets-manual-bolts-summary
Sheet: Sheet1

 |  | BOLTS SUMMARY
CLIENT   U.M.A GREENWICH |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB No   A11502
PLANT SECTION CONVEYOR CV6 TAIL |  |  |  |  |  |  |  |  |  |  |  |  |  | LIST No……1 of2
[NAME] | [NAME] LG | [NAME] 50 LG |  | M20 SPRING WASHER | M20 FORM C WASHER | M20 HEX NUT | M20 NYLOC NUT | M20 X 45 LG | M20 X 50 LG | M20 X 55 LG | M20 X 80 LG | M20 X 100 SETS |  | M24 FORM C WASHER | M24 NYLOC NUT | M24 X 110 LG
94 | 4 | 90 |  | 4 | 26 | 4 | 26 | 16 | 4 | 4 | 2 | 4 |  | 4 | 4 | 4 | Sub total
9.4 | 0.4 | 9 | 0 | 0.4 | 2.6 | 0.4 | 2.6 | 1.6 | 0.4 | 0.4 | 0.2 | 0.4 |  | 0.4 | 0.4 | 0.4 | 0.1
103.4 | 4.4 | 99 | 0 | 4.4 | 28.6 | 4.4 | 28.6 | 17.6 | 4.4 | 4.4 | 2.2 | 4.4 |  | 4.4 | 4.4 | 4.4 | TOTAL
 |  | BOLTS SUMMARY
CLIENT   U.M.A GREENWICH |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB No   A11502
PLANT SECTION CONVEYOR CV6 TAIL |  |  |  |  |  |  |  |  |  |  |  |  |  | LIST No……2 of 2
 | M10 SPRING WASHER | M10 FORM C WASHER | M10 HEX NUT | M10 NYLOC NUT | M10 X 25 LG | M10 X 30 LG | M10 X 35 LG |  | M12 SPRING WASHER | M12 FORM C WASHER | M12 HEX NUT | M12 NYLOC NUT | M12 X 40 LG | M12 X 45 LG |  | M16 HEX NUT
 | 57 | 20 | 57 | 20 | 9 | 60 | 8 |  | 8 | 20 | 8 | 20 | 20 | 8 |  | 94 | Sub total
0 | 5.7 | 2 | 5.7 | 2 | 0.9 | 6 | 0.8 |  | 0.8 | 2 | 0.8 | 2 | 2 | 0.8 |  | 9.4 | 0.1
0 | 62.7 | 22 | 62.7 | 22 | 9.9 | 66 | 8.8 |  | 8.8 | 22 | 8.8 | 22 | 22 | 8.8 |  | 103.4 | TOTAL
Spreadsheet: 45c3890f-5981-4d56-b009-63cf12095953
Sheet: Sheet1

genome sequence | accession
Acidothermus cellulolyticus 11B | NC_008578
Arthrobacter aurescens TC1 | NC_008711
Arthrobacter sp. FB24 | NC_008541
Bifidobacterium adolescentis ATCC 15703 | NC_008618
Bifidobacterium longum NCC2705 | NC_004307
Clavibacter michiganensis subsp. michiganensis NCPPB 382 | NC_009480
Corynebacterium glutamicum ATCC 13032 | NC_003450
Frankia alni ACN14a | NC_008278
Frankia sp. CcI3 | NC_007777
Frankia sp. [NAME] | NC_009921
Kineococcus radiotolerans SRS30216 | NC_009664
Leifsonia xyli subsp. xyli str. CTCB07 | NC_006087
Mycobacterium smegmatis str. MC2 155 | NC_008596
Mycobacterium sp. JLS | NC_009077
Mycobacterium tuberculosis H37Rv | AL123456
Mycobacterium vanbaalenii PYR-1 | NC_008726
Nocardia farcinica IFM 10152 DNA | AP006618
Propionibacterium acnes KPA171202 | NC_006085
Ralstonia eutropha H16 chromosome 1 | NC_008313
Ralstonia eutropha H16 chromosome 2 | NC_008314
Ralstonia eutropha H16 megaplasmid pHG1 | NC_005241
Renibacterium salmoninarum ATCC 33209 | NC_010168
Rhodococcus opacus B4 DNA | AP011115
Rhodococcus sp. RHA1 | NC_008268
Rubrobacter xylanophilus DSM 9941 | NC_008148
Saccharopolyspora erythraea NRRL 2338 | NC_009142
[NAME] tropica CNB-440 | CP000667
Streptomyces avermitilis MA-4680 | NC_003155
Streptomyces coelicolor A3(2) | AL645882
Thermobifida fusca YX | NC_007333
Tropheryma whipplei str. Twist | NC_004572
organism (FAS) | accession
Saccharomyces cerevisiae | NP_012739+NP_015093
Schizosaccharomyces pombe | NP_594370+NP_593823
Ustilago maydis | XP_759118
Schizochytrium sp. ACTT | ABJ98780
Phytophthora infestans | EEY57114
organism (MAS) | accession
Ciona intestinalis | XP_002124749
[NAME] rerio | XP_001923643
Mus musculus | NP_03201
Homo sapiens | NP_004095
Spreadsheet: 850632d1701036677-if-with-and-function-not-working-properly-book2
Sheet: Sheet1 (2)

1)      If the increase is more than expected, the write "Worse Than Expected". The same can be said if a decline is less than expected.
2)      If the increase is less than expected, then write "Better Than Expected". The same can be said if a decline is more than expected.
Date | Actual | Forecast | Previous
2023-11-15 00:00:00 | 3.6 | 1.793 | 13.869
2023-11-01 00:00:00 | 0.774 | 1.261 | 1.371
2023-10-25 00:00:00 | 1.371 | 0.239 | -4.491
2023-10-18 00:00:00 | -4.491 | 0.3 | 10.176
2023-10-12 00:00:00 | 10.176 | 0.492 | -2.224
2023-10-04 00:00:00 | -2.224 | -0.446 | -2.17
2023-09-27 00:00:00 | -2.17 | -1.32 | 2.135
2023-09-20 00:00:00 | -2.135 | -2.2 | 3.954
2023-09-13 00:00:00 | 3.95 | -1.912 | -6.307
2023-09-07 00:00:00 | -6.307 | -2.064 | -10.584
2023-08-30 00:00:00 | -10.584 | -3.267 | -6.135
2023-08-23 00:00:00 | -6.135 | -2.85 | -5960
2023-08-16 00:00:00 | -5.96 | -2.32 | 5.851
2023-08-09 00:00:00 | 5.851 | 0.567 | -17.049
2023-08-02 00:00:00 | -17.049 | -1.367 | -0.6
2023-07-26 00:00:00 | -0.6 | -2.348 | -0.708
2023-07-19 00:00:00 | -0.708 | -2.44 | 5.946
2023-07-12 00:00:00 | 5.946 | 0.483 | -1.508
2023-07-06 00:00:00 | -1.508 | -0.983 | -9.603
2023-06-28 00:00:00 | -9.603 | -1.757 | -3.831
2023-06-22 00:00:00 | -3.831 | 0.329 | 7.919
2023-06-14 00:00:00 | 7.919 | 1.482 | -0.451
2023-06-07 00:00:00 | -0.451 | 1.022 | 4.488
2023-06-01 00:00:00 | 4.488 | -1.101 | -12.456
2023-05-24 00:00:00 | -12.456 | -0.92 | 5.04
2023-05-17 00:00:00 | 5.04 | -0.92 | 2.951
2023-05-10 00:00:00 | 2.951 | -917 | -1.28
2023-05-03 00:00:00 | -1.28 | -1.1 | -5.054
2023-04-26 00:00:00 | -5.054 | -1.486 | -4.581
2023-04-19 00:00:00 | -4.581 | -1.088 | 0.597
2023-04-12 00:00:00 | 0.597 | -0.583 | -3.739
2023-04-05 00:00:00 | -3.739 | -2.329 | -7.489
2023-04-29 00:00:00 | -7.489 | 0.092 | 1.117
2023-04-22 00:00:00 | 1.117 | -1.565 | 1.55
2023-04-05 00:00:00 | -3.739 | -2.329 | -7.489
2023-03-29 00:00:00 | -7.489 | 0.092 | 1.117
2023-03-22 00:00:00 | 1.117 | -1.565 | 1.55
2023-03-15 00:00:00 | 1.55 | 1.188 | -1.694
2023-03-08 00:00:00 | -1.694 | 0.395 | 1.165
2023-03-01 00:00:00 | 1.165 | 0.457 | 7.648
2023-02-23 00:00:00 | 7.648 | 2.083 | 16.283
2023-02-15 00:00:00 | 16.283 | 1.166 | 2.423
2023-02-08 00:00:00 | 2.423 | 2.457 | 4.14
2023-02-01 00:00:00 | 4.14 | 0.376 | 0.533
2023-01-25 00:00:00 | 0.533 | 0.971 | 8.408
2023-01-19 00:00:00 | 8.408 | -0.593 | 18.962
2023-01-11 00:00:00 | 18.962 | -2.243 | 1.694
2023-01-05 00:00:00 | 1.694 | 1.154 | 0.718
2022-12-29 00:00:00 | 0.718 | -1.52 | -5.894
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Apr2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-04-01 00:00:00
2021-04-02 00:00:00
2021-04-03 00:00:00
2021-04-04 00:00:00
2021-04-05 00:00:00
2021-04-06 00:00:00
2021-04-07 00:00:00
2021-04-08 00:00:00
2021-04-09 00:00:00
2021-04-10 00:00:00
2021-04-11 00:00:00
2021-04-12 00:00:00
2021-04-13 00:00:00
2021-04-14 00:00:00
2021-04-15 00:00:00
2021-04-16 00:00:00
2021-04-17 00:00:00
2021-04-18 00:00:00
2021-04-19 00:00:00
2021-04-20 00:00:00
2021-04-21 00:00:00
2021-04-22 00:00:00
2021-04-23 00:00:00
2021-04-24 00:00:00
2021-04-25 00:00:00
2021-04-26 00:00:00
2021-04-27 00:00:00
2021-04-28 00:00:00
2021-04-29 00:00:00
2021-04-30 00:00:00
Totals:
Spreadsheet: 220344d1363124873-index-match-play
Sheet: Batch Data

Room | Date | Job No | Quantity | No of tasks | Total [NAME] | Total Tasks | KPI | Room
1 | 2013-02-12 00:00:00 | 3455 | 200 | 12 | 122
2 | 2013-02-11 00:00:00 | 3455 | 200 | 12 | 122
3 | 2013-02-11 00:00:00 | 3455 | 200 | 12 | 122
3 | 2013-02-12 00:00:00 | 3454 | 400 | 12 | 3432
3 | 2013-02-13 00:00:00 | 3454 | 10 | 36 | 222
2 | 2013-02-13 00:00:00 | 3453.7 | 20 | 35 | 11515
2 | 2013-02-14 00:00:00 | 3453.4 | 30 | 30 | 22
1 | 2013-02-15 00:00:00 | 3453.1 | 40 | 22 | 22
1 | 2013-02-18 00:00:00 | 3452.8 | 50 | 10 | 36
1 | 2013-02-19 00:00:00 | 3452.5 | 3 | 2 | 3
1 | 2013-02-19 00:00:00 | 3452.2 | 2 | 2 | 3
1 | 2013-02-19 00:00:00 | 3451.9 | 999 | 36 | 1
2 | 2013-02-20 00:00:00 | 3451.6 | 21 | 9 | 2
2 | 2013-02-20 00:00:00 | 3451.3 | 112 | 6 | 22
2 | 2013-02-21 00:00:00 | 3451 | 21 | 9 | 3
2 | 2013-02-21 00:00:00 | 3450.7 | 111 | 4 | 336
3 | 2013-02-22 00:00:00 | 3450.4 | 22 | 7 | 6
3 | 2013-02-23 00:00:00 | 3453.7 | 20 | 35 | 11515
3 | 2013-02-24 00:00:00 | 3453.4 | 30 | 30 | 22
2 | 2013-02-25 00:00:00 | 3453.1 | 40 | 22 | 22
1 | 2013-02-21 00:00:00 | 3452.8 | 50 | 10 | 36
3 | 2013-02-22 00:00:00 | 3452.5 | 3 | 2 | 3
1 | 2013-02-23 00:00:00 | 3452.2 | 2 | 2 | 3
2 | 2013-02-24 00:00:00 | 3451.9 | 999 | 36 | 1
3 | 2013-02-25 00:00:00 | 3451.6 | 21 | 9 | 2
1 | 2013-02-23 00:00:00 | 3451.3 | 112 | 6 | 22
1 | 2013-02-24 00:00:00 | 3451 | 21 | 9 | 3
1 | 2013-02-25 00:00:00 | 3450.7 | 111 | 4 | 336
3 | 2013-02-26 00:00:00 | 3450.4 | 22 | 7 | 6
Spreadsheet: 847674d1698514840-concatenate-multiple-cells-but-need-1900-jan-00-to-not-show-concatenate-dates
Sheet: Sheet1

2024-02-09 00:00:00 | 2024-02-11 00:00:00 | 2024-04-15 00:00:00 | 2024-04-17 00:00:00 | 2024-04-22 00:00:00 | 2024-04-24 00:00:00
2024-02-10 00:00:00 | 2024-02-15 00:00:00 | 2024-05-01 00:00:00 | 2024-05-04 00:00:00 | 2024-10-01 00:00:00 | 2024-10-06 00:00:00
2024-02-09 00:00:00 | 2024-02-15 00:00:00 | 2024-04-29 00:00:00 | 2024-05-03 00:00:00 | 2024-09-29 00:00:00 | 2024-10-05 00:00:00
2024-04-30 00:00:00 | 2024-05-04 00:00:00 | 2024-09-29 00:00:00 | 2024-10-05 00:00:00
2024-05-01 00:00:00 | 2024-05-03 00:00:00 | 2024-09-30 00:00:00 | 2024-10-06 00:00:00
Spreadsheet: 145657d1331680364-sumif-type-formula-question-example2012_summer_internship
Sheet: Roster

Summer 2012 Interns |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intern Orientation (LA) | AEG Live Paperwork | Credit Letter | IT Setup |  | ü |  |  |  |  |  |  |  |  | Error
Office | Department | Last | First | Year | College | Major | App. Rec. | Phone Int. | Live Int./Sent | TBNT | Status | [NAME] | Phone | Comments | M | T | W | Th | F | Start | End | Schedule Notes
Spreadsheet: 1e6ea4c3-51ce-4a73-a30d-0aad07fd012a
Sheet: Legend for Agency

Agency Abbreviation | Full Agency Name
DHS | Department of Homeland Security
DOC | Department of Commerce
DOD | Department of Defense
DOI | Department of the Interior
DOJ | Department of Justice
DOL | Department of Labor
DOT | Department of Transportation
EPA | Environmental Protection Agency
GSA | General Services Administration
HHS | Department of Health and Human Services
HUD | Department of Housing and Urban Development
LSC | Legal Services Corporation
NASA | National Aeronautics and Space Administration
SBA | Small Business Administration
SI | Smithsonian Institution
SSA | Social Security Administration
USACE | United States Army Corps of Engineers
USDA | Department of Agriculture
VA | Department of Veterans Affairs
Spreadsheet: 781336d1653237426-data-table-to-work-with-reference-to-pivot-table-pivot-table-and-data-table-1-
Sheet: Sheet1

Source data |  |  |  |  | Pivot Table |  |  |  |  | Data table
CSO | bw backlog
H5806A14 | 50
H5806A199 | 10
[NAME]
H5806A24 | 30 |  |  | bw backlog | CSO | bw | CSO | 20.May | 21.May | 22.May | 23.May | 24.May
H5806A299 |  |  |  | 10 | H5806A199 | 10 |  | 5 |  | 5
H5815A11 | 20 |  |  | 20 | H5815A11 | 20 |  |  | 10 |  | 10
H5815A12 |  |  |  |  | H5856A117 | 20 |  | 5 | 5 | 5 | 5
[NAME] |  |  |  | 30 | H5806A24 | 30
H5856A117 | 20 |  |  | 50 | H5806A14 | 50 |  | 15 | 15 | 15
H5856A118 |  |  |  | 60 | H5856A153 | 60 |  | 12 | 12 | 12 | 12 | 12
H5856A153 | 60
 |  |  |  | Requirement:
 |  |  |  | My source data is huge and rows increases day by day.  For better visibility of only BALANCE rows, a pivot table is made and distributed into days.
 |  |  |  | Above Data table should change with reference to the Pivot Table (i.e. when the [NAME] table increases or decreases, data table also should change .
 |  |  |  | Is there a way out.
 |  |  |  | Sum of Value |  | Attribute
 |  |  |  | CSO | bw backlog | 20.May | 21.May | 22.May | 23.May | 24.May | Grand Total
 |  |  |  | H5806A14 | 50 | 15 | 15 | 15 |  |  | 45
 |  |  |  | H5806A199 | 10 | 5 |  | 5 |  |  | 10
 |  |  |  | H5815A11 | 20 |  | 10 |  | 10 |  | 20
 |  |  |  | H5856A117 | 20 | 5 | 5 | 5 | 5 |  | 20
 |  |  |  | H5856A153 | 60 | 12 | 12 | 12 | 12 | 12 | 60
 |  |  |  | Grand Total |  | 37 | 42 | 37 | 27 | 12 | 155
Spreadsheet: 157613d1337803519-automatically-emailing-notifications-when-dates-in-columns-is-or-to-computer-date-pda-sample-for-auto-email
Sheet: Sheet1

 | NAME | PROGRAM OR [NAME] | TYPE | DATE | NUMBER | STATUS (1 - 6) | HYPERLINK  .PDF | [NAME] | [NAME]other | EXPIRES | RENEWAL NOTIF. DATE | Days till  Renewal Notif.
S | AACME ANVILS |  | PIXA | 2010-10-15 00:00:00 |  | 6 |  |  |  | 2015-10-16 00:00:00 | 2015-09-14 00:00:00 | 1795 | IF L2 = or < today (on computer), then: email [EMAIL] with message that B2 needs an updated D2 because it expires on K2 AND attach hyperlinked document from H2, THEN: change L2 color to red
Spreadsheet: phillip_m_love__30637__storage 9912&0001
Sheet: 0002

 |  | Storage Reconciliation - 0002
Facility | 0002 GL |  | 0003 GL |  | 0004 GL |  | Total
 | Volume | $ | Volume | $ | Volume | $ | Volume | $
[NAME] |  |  | -2574630 | -5818535 | 870
[NAME] |  |  | -409770 | -927925.31 |  | 0
Centana Co 016 |  |  |  |  |  | 0
CILCO  Co 016
Enron Gas Mktg Liquidations |  |  |  |  |  | 885543
Total
* inventory profit of $(447,550) added to 0004 GL column
Spreadsheet: 860826d1708850904-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-check_formula-play_with-expected-results-highlighted-in-yellow_v5_return-dates_hans
Sheet: Leave

employee | Start | end |  | Leave type
AS123 | 2024-02-11 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-03-12 00:00:00 | 2024-03-19 00:00:00 |  | Recreational
AS123 | 2024-02-07 00:00:00 | 2024-02-10 00:00:00 |  | Sick without Pay - MC
AP346 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | Leave without pay
[NAME] | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
Spreadsheet: 124449d1318423082-sumifs-problem-sumifs-problem
Sheet: Link Factors

 | Click to Change
Status | Incurred
Open/Closed
[NAME] (>=) :
 |  | Development Year
 | Year | DevYr1 | DevYr2 | DevYr3 | DevYr4 | DevYr5 | DevYr6 | DevYr7 | DevYr8 | DevYr9 | DevYr10 | DevYr11 | DevYr12 | DevYr13 | DevYr14 | DevYr15 | DevYr16
 | 1996
 | 1997
 | 1998
 | 1999
 | 2000
 | 2001
 | 2002
 | 2003
 | 2004
 | 2005
 | 2006
 | 2007
 | 2008
 | 2009
 | 2010
 | 2011
 |  | Development Periods
 |  | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-13 | 13-14 | 14-15 | 15-16
 | [NAME]
Spreadsheet: errol_mclaughlin_jr__10330__NG-Price PMA for Oct file
Sheet: Sheet 1

Variances as of September Accounting
Bookcode | Month | Code | Type | Description | Risk
NG PRICE | Jul | RM | E | NYMEX Options/Futures | 500
NG PRICE | Sep | RM | E | Broker Fees | -510112
NG PRICE | Sep | RM | E | Qualitech Steel Corp.- Reverse DPR Adjustments taken; Brooklyn had been sending deal E49515.1 as a revenue adjustment to the DPR because she was told that this deal was in bankrupt status. However, there was an offsetting deal E49515.2 that should have been coded to offset the bankrupt deal. So, in total there should have been no P&L affect. | -1059860.9
NG PRICE | Sep | RM | E | Access Differences | -4439.09