tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 204473d1357546253-production-line-calculation-production-sample-1-
Sheet: Database

Workings:
Daily Minute workings:
Workers | 30
Hours every worker | 8
Total:
[NAME] |  |  |  |  |  |  |  | Workings for the delivery dates fo amount of doors
Flush Door |  |  |  |  |  |  | Job: | Qty | Product: | Minutes needed | Days needed
 |  |  |  |  |  |  | 123456 | 56
 |  |  |  |  |  |  | 123457 | 56
 |  |  |  |  |  |  | 123458 | 56
Calculating calender days for delivery dates:
Job: | Days: | Start Date: | Delivery Date:
 |  | 2013-01-05 00:00:00
The problem is when calculating delivery dates, the dates should include public holidays and even the weekends, The other problem is however I need to make a constant of input date to plan automaticly how my Job listed with quantities,
It will constantly calculate between jobs listed by work person For example:
Product: | Worker 1 | Worker 2 | Worker 3 | Worker 4 | Worker 5 | Worker 6 | Worker 7 | Worker 8 | Worker 9 | Worker 10 | Worker 11 | Worker 12 | Worker 13 | Worker 14 | Worker 15 | Worker 16 | Worker 17 | Worker 18 | Worker 19 | Total
Flush Door | 20 | 50 | 24 | 29 | 21 | 5 | 30 | 10 | 6 | 8 | 10 | 25 | 34 | 9 | 4 | 50 | 30 | 10 | 10
Therefore i need to calculate the Start date of a job depending on Worker 1 (The cutting proccess so it will calculate how much time he needs to start another job) if he needs 2 hours he still have time to do another job or begin it,
This part i cant really imagine how i can do it by any ways, would apreciate some help.
Spreadsheet: d5075e81-ac76-454f-9eda-cee1a3324446
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ausländer und Ausländerinnen, welche länger als 2 Jahre in der [NAME] bleiben möchten, werden verpflichtet, die Sprache des jeweiligen Landesteils zu lernen.
 | Welcher Partei haben [NAME] bei der letzten <b>Nationalratswahl im Oktober 2011</b> hauptsächlich [NAME] gegeben?
Antwort | CVP | EDU | EVP | FDP / Liberale | Grüne | SD | SP | SVP | Andere | Weiss nicht/Keine | Grünliberale | BDP | PdAS | Nicht zur Wahl gegangen
[NAME] | 0.92 | 0.95 | 0.94 | 0.89 | 0.78 | 0.94 | 0.83 | 0.96 | 0.82 | 0.89 | 0.89 | 0.94 | 0.67 | 0.89
Neutral / Weiss nicht | 0.05 | 0.03 | 0.05 | 0.06 | 0.11 | 0.03 | 0.09 | 0.03 | 0.12 | 0.07 | 0.07 | 0.04 | 0.13 | 0.07
[NAME] | 0.04 | 0.02 | 0.01 | 0.06 | 0.11 | 0.04 | 0.08 | 0.01 | 0.06 | 0.04 | 0.04 | 0.02 | 0.2 | 0.04
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 683921d1593054987-check-same-for-3-column-check-same-for-3-column
Sheet: Sheet1

Column A | Column B | Column C | Check if same, if any value of A,B,C, are same, Shows "SAME", else shows "NOT SAME"
BLANK | BLANK | BLANK | No data
123 | 123 | BLANK | Same
123 | BLANK | 123 | Same
BLANK | 123 | 123 | Same
123 | 123 | 123 | Same
123 | 234 | BLANK | NOT same
123 | BLANK | 234 | NOT same
BLANK | 123 | 234 | NOT same
123 | 234 | 123 | NOT same
123 | 123 | 234 | NOT same
234 | 123 | 123 | NOT same
Spreadsheet: 021d2828-6ba7-43d0-9c6d-c5d87876d442
Sheet: Sheet1

QTY. | Unnamed: 1 | Agrium Advanced Tech. | [NAME] | [NAME] Landscapes | Winfield | Helena Chemical | BWI Companies
1000 bags | 28-3-10 Granular Turf Fertilizers (50 lb bags) | 19.25 | 19.05 | 22.12 | 18.58 | 19.5 | 20.6
10 bags | 18-24-12 Starter (50lb bags) | 19 | 38.54 | 19.47 | 22.35 | 20.1 | 21.8
1600bags | 28-0-0 (50lb bags) | 16.95 | 14.9 | 20.65 | 15.6 | 16 | 16.75
1200 bags | 28-0-0 fertilizer w/ simazine overlay (50 lb. [NAME]) | n/b | n/b | n/b | 17.15 | 19.7 | 19.25
800 bags | 0-0-7 w/ simazine overlay (50lb bags) | n/b | n/b | 11.83 | 9.95 | 10.7 | 9.75
80bags | Ronstar G (50lb bags) | 77.5 | n/b | 76.87 | 67 | 68.5 | 74
800 bags | [NAME] 9spring time application) (50lb bags) 0-0-7 | 10.4 | n/b | 12.78 | 9.45 | 9.85 | 10.4
160 bags | 28-0-3 (50 lb bags)  8000lbs | 16.25 | 13.43 | 17.67 | 12.45 | n/b | 13.65
120 bags | [NAME] ant killer [NAME]. | 125 | n/b | $125.00* | 137.5 | 125 | 137.5
 |  |  |  | * 20 bags or more. $137.00 if less than 20 bags. Agency product. |  | Alternate product ([NAME]) at same cost as above
Spreadsheet: 818045d1676561728-takeaway-number-in-sequence-book1
Sheet: Sheet1

 | Item | Rate 1 | Rate 2 | Rate 3 | Rate 4 | Rate 5 | Rate 6 | TOTAL | TARGET |  |  | New Rate 1 | New Rate 2 | New Rate 3 | New Rate 4 | New Rate 5 | New Rate 6 | Rate over Target | TOTAL
 | A | 95 | 12 | 0 | 10 | 22 | 0 |  | 100 |  |  |  | 12 | 0 | 10 | 22 | 0 |  |  | * This is straightforward
 | B | 20 | 50 | 0 | 2 | 3 | 0 |  | 80 |  |  | 20 | 50 | 0 | 2 | 3 | 0
 | C | 0 | 0 | 20 | 35 | 40 | 50 |  | 100 |  |  | 0 | 0 | 0 | 10 | 40 | 50 |  |  | * In this row, I need to look at column C, if that is 0 then move to next column and when we reach Column E, we take away 20 as the rate over target is 45, then move to next column and remove the remainder.
 | D | 0 | 0 | 10 | 20 | 50 | 95 |  | 100 |  |  | 0 | 0 | 0 | 0 | 5 | 95 |  |  | * In this row, same as above but have to take away from another column.
 | E | 0 | 10 | 0 | 0 | 50 | 75 |  | 100 |  |  | 0 | 0 | 0 | 0 | 25 | 75 |  |  | * In this row, same as above, but zero in between.
 | * Values in Column J and Column T must be equal
 | * Rate over Target will always be positive, if negative count as zero
 | Start with Rate 1, then move rate 2 when rate 1 is less than 0
Spreadsheet: 133687d1324545480-automatically-copy-an-entire-row-test
Sheet: Foundation

LBP | Date | USD | Main List | List | Description
 | 2011-04-27 00:00:00 | 5000 | Sales | Cash
 | 2011-04-28 00:00:00 | -700 | Misc | Repair
 | 2011-04-29 00:00:00 | 500 | Bank | Visa
 | 2011-04-30 00:00:00 | -1000 | Salary | Samer
 | 2011-05-01 00:00:00 | 2000 | Sales | Cash
 | 2011-05-02 00:00:00 | -2000 | Bank | Check | Num.00519
 | 2011-05-03 00:00:00
 | 2011-05-04 00:00:00
 | 2011-05-05 00:00:00
 | 2011-05-06 00:00:00
 | 2011-05-07 00:00:00
 | 2011-05-08 00:00:00
 | 2011-05-09 00:00:00
 | 2011-05-10 00:00:00
 | 2011-05-11 00:00:00
 | 2011-05-12 00:00:00
 | 2011-05-13 00:00:00
 | 2011-05-14 00:00:00
 | 2011-05-15 00:00:00
 | 2011-05-16 00:00:00
 | 2011-05-17 00:00:00
Spreadsheet: 27ef82bf-7034-4832-9f7d-a6b4cfebf608
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-12-09 09:31:39.320000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.874 | 101.749 | 101.624 | 101.249
4.25 | 101.176 | 101.051 | 100.926 | 100.551 |  | Note: | Refer To Price [NAME]
4.125 | 100.67 | 100.545 | 100.42 | 100.045 |  |  | For all Price Adjs
4 | 100.229 | 100.104 | 99.979 | 99.354
3.875 | 99.669 | 99.544 | 99.419 | 98.794
3.75 | 98.82 | 98.695 | 98.57 | 97.945
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.863 | 101.738 | 101.613 | 101.238
3.75 | 101.335 | 101.21 | 101.085 | 100.71
3.625 | 101.02 | 100.895 | 100.77 | 100.395
3.5 | 100.706 | 100.581 | 100.456 | 100.081
3.375 | 100.301 | 100.176 | 100.051 | 99.426
3.25 | 99.749 | 99.624 | 99.499 | 98.874
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-12-23 09:31:39.320000
30 DAY | 2012-01-07 09:31:39.320000
45 DAY | 2012-01-22 09:31:39.320000
60 DAY | 2012-02-06 09:31:39.320000
90 DAY | 2012-03-07 09:31:39.320000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 842890d1694877213-automatically-updates-score-sheet-live-sample1-gk-both-venues
Sheet: SELECTIONS

 | VENUE 1 |  |  |  |  |  |  |  |  |  |  | VENUE 2 |  |  |  |  |  |  |  |  |  |  | Race 1 |  |  | Race 2 |  |  | Race 3 |  |  | Race 4 |  |  | Race 5 |  |  | Race 6 |  |  | Race 7 |  |  | Race 8 |  |  | Race 9 |  |  | Race 10 |  |  |  |  | Venue 2 points per race
NAME | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 |  | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 |  | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | total |  | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | total
HOPE | 8 | 8 | 4 | 1 | 7 | 3 | 6 | 5 | 10 | 2 |  | 1 | 2 | 3 | 3 | 9 | 5 | 2 | 7 | 2 | 9
FAITH | 2 | 2 | 8 | 333 | 2 | 4 | 1 | 8 | 5 | 5 |  | 3 | 2 | 4 | 2 | 6 | 10 | 10 | 5 | 5 | 3
ab | 9 | 8 | 7 | 8 | 6 | 4 | 10 | 8 | 10 | 5 |  | 10 | 4 | 5 | 5 | 5 | 3 | 1 | 8 | 9 | 6
cb | 1 | 8 | 10 | 5 | 6 | 2 | 7 | 6 | 9 | 5 |  | 8 | 5 | 8 | 3 | 4 | 7 | 1 | 5 | 2 | 5
db | 4 | 8 | 10 | 10 | 7 | 10 | 10 | 4 | 7 | 6 |  | 7 | 3 | 8 | 9 | 6 | 8 | 2 | 1 | 1 | 2
ek | 7 | 4 | 6 | 5 | 6 | 2 | 6 | 2 | 6 | 7 |  | 7 | 3 | 4 | 6 | 7 | 4 | 8 | 1 | 8 | 6
rk | 8 | 9 | 5 | 10 | 8 | 4 | 1 | 3 | 6 | 3 |  | 2 | 1 | 10 | 2 | 7 | 7 | 10 | 6 | 6 | 7
sk | 5 | 6 | 2 | 5 | 10 | 10 | 9 | 5 | 8 | 8 |  | 2 | 2 | 5 | 2 | 6 | 10 | 7 | 7 | 7 | 7
Spreadsheet: scott_neal__37993__Baylor_Interviews_2
Sheet: Sheet1

Baylor
Candidate | Address | City | State | Zip | 2nd Round | Super Saturday | Phone | [NAME]
Bagby, [NAME] | 1500 S. 9th Street, #203 | [NAME] | Texas | 76706 | Declined | Declined | [PHONE] | [EMAIL]
[NAME], [NAME] | 400 Ivy Avenue, #162 | [NAME] | Texas | 76706 | Did Not Sign | Did Not Sign | [PHONE] | [EMAIL]
Blok, Justin | 153 [NAME] | Hewitt | Texas | 76643 | Declined | Declined | [PHONE] | [EMAIL]
[NAME], Adam | 406 Daughtrey Avenue | [NAME] | Texas | 76706 | Did Not Sign | Did Not Sign | [PHONE] | [EMAIL]
Comer, [NAME] | 5612 Lake Haven | [NAME] | Texas | 76710 | Invited | Yes | [PHONE] | [EMAIL]
Diharjo, [NAME] | 2014 South 2nd Street, #33 | [NAME] | Texas | 76706 | Declined | Declined | [PHONE] | [EMAIL]
El-Khatib, [NAME] | 1335 South 11th Street | [NAME] | Texas | 76706 | Declined | Declined | [PHONE] | [EMAIL]
Fenn, [NAME] | 1804 South 10th | [NAME] | Texas | 76706 | Invited | Declined | [PHONE] | [EMAIL]
Finan, [NAME] | 1508 South 13th Street, #114 | [NAME] | Texas | 76706 | Invited | Yes | [PHONE]
Flowers, [NAME] | 1111 S. University Parks, #93 | [NAME] | Texas | 76706 | Invited | Yes/Confirmed | [PHONE] | [EMAIL]
Freije, [NAME] | 1222 South 11th Street, #6101 | [NAME] | Texas | 76706 | Invited | Yes | [PHONE] | [EMAIL]
Gibbs, Shannon | 1008 [NAME] | [NAME] | Texas | 76706 | Did Not Sign | Did Not Sign | [PHONE] | [EMAIL]
Ice, Nathan | 66 Daughttrey Avenue, #702 | [NAME] | Texas | 76706 | Did Not Sign | Did Not Sign | [PHONE] | [EMAIL]
[NAME], [NAME] | 1400 South Park Avenue, #[NAME] | [NAME] | Texas | 76706 | Declined | Declined | [PHONE] | [EMAIL]
Koop, [NAME] | 1818 South 7th Street, #16D | [NAME] | Texas | 76706 | Invited | IT - Yes | [PHONE] | [EMAIL]
[NAME], [NAME] | 325 Station Creek | [NAME] | Texas | 76708 | Declined | Declined | [PHONE] | [EMAIL]
Morman, Lance | 153 [NAME] | Hewitt | Texas | 76643 | Invited | Declined | [PHONE] | [EMAIL]
Sibley, D. | 1824 South 10th St. #2 | [NAME] | Texas | 76712 | Invited | Declined | [PHONE] | [EMAIL]
Tran, Kimberly | 1919 South Fifth Street #22 | [NAME] | Texas | 76706 | Invited | Declined | [PHONE] | [EMAIL]
Watson, Sara | 66 Daughtry Avenue #520 | [NAME] | Texas | 76706 | Declined | Declined | [PHONE] | [EMAIL]
Wells, [NAME] | 1222 S. 11th #7205 | [NAME] | TX | 76706 | Invited | Declined | 254/759-2559 | [EMAIL]
Wilson, Derek | 1613 Bagby, Apt. A | [NAME] | Texas | 76706 | Invited | Yes/Confirmed | [PHONE] | [EMAIL]
Worley III, Fred | 110 [NAME] | [NAME] | Texas | 76706 | Did Not Sign | Did Not Sign | [PHONE] | [EMAIL]
Spreadsheet: 6fa69e92-ab7e-47db-aa9f-53b8ae26434c
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (5 Entries):
 | 7 Biotechnology 7.6 Substances, cultures 7.6.2 Equipment vessels and nutrients for cultures
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Biotool Swiss AG | Switzerland | Kirchberg/BE | 3422 | B1.106
2 | Integra Biosciences AG | Switzerland | Zizers | 7205 | A3.401/504
3 | Parker Hannifin GmbH | Germany | Kaarst | 41564 | A1.515
4 | Sarstedt AG & Co. | Germany | Nümbrecht | 51588 | B1.113/212
5 | Th. Geyer GmbH & Co. [NAME] | Germany | Renningen | 71272 | B1.430
Spreadsheet: 123469d1317672281-excel-2007-merging-multiple-updated-worksheets-book1-copy
Sheet: manager worksheet

Order Id | Order # | Line # | Order Date | Part # | Qty | Date Sold | Date Shipped
 |  |  |  |  |  | 2011-06-03 00:00:00 | 2011-07-14 00:00:00
 |  |  |  |  |  | 2011-08-02 00:00:00 | 2011-09-01 00:00:00
 |  |  |  |  |  | 2011-07-04 00:00:00
 |  |  |  |  |  | 2011-08-15 00:00:00 | 2011-10-01 00:00:00
Spreadsheet: 844586d1696352347-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-master-copy
Sheet: Summary

 | Golborne League Table 2024
 |  | Points |  |  |  | Total Weight |  | Total Matches Fished
 | Name | Rank | Total Points |  |  | lbs | oz
 | Biggest Weight to date : | 68 lbs |  |  |  | [NAME] | 2016-08-29 00:00:00
 | Biggest fish to date : | n/a
 | Golden peg Pot : | £43
 | Leauge Prize Pot : | £4
Spreadsheet: 188097d1350675658-copying-3-sheets-into-one-sheet-mergeworksheetscode
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME]
[NAME] of Sheet1 | Cell B2 of Sheet1 | Cell C2 of Sheet1 | Cell D2 of Sheet1 | Cell E2 of Sheet1 | Cell F2 of Sheet1 | Cell G2 of Sheet1
Cell A3 of Sheet1 | Cell B3 of Sheet1 | Cell C3 of Sheet1 | Cell D3 of Sheet1 | Cell E3 of Sheet1 | Cell F3 of Sheet1 | Cell G3 of Sheet1
Cell A4 of Sheet1 | Cell B4 of Sheet1 | Cell C4 of Sheet1 | Cell D4 of Sheet1 | Cell E4 of Sheet1 | Cell F4 of Sheet1 | Cell G4 of Sheet1
Spreadsheet: 677994d1589647254-univocal-and-ordered-list-of-years-from-list-of-dates-anni-univoci
Sheet: Foglio1

DATE |  | RESULT
2017-02-01 00:00:00 |  | 2017
2017-02-15 00:00:00 |  | 2018
 |  | 2019
 |  | 2020
2017-02-21 00:00:00
2017-03-13 00:00:00
2017-05-10 00:00:00
2017-11-27 00:00:00
2017-12-12 00:00:00
2019-02-08 00:00:00
2019-04-30 00:00:00
2019-07-03 00:00:00
2019-07-22 00:00:00
2019-07-31 00:00:00
2019-08-08 00:00:00
2019-09-02 00:00:00
2019-10-08 00:00:00
2019-10-09 00:00:00
2019-11-06 00:00:00
2019-11-11 00:00:00
2019-12-30 00:00:00
2019-12-31 00:00:00
2019-12-31 00:00:00
2019-12-31 00:00:00
2018-03-06 00:00:00
2018-03-13 00:00:00
2018-03-13 00:00:00
2018-03-22 00:00:00
2018-04-17 00:00:00
2018-06-27 00:00:00
2018-09-19 00:00:00
2018-10-16 00:00:00
2018-10-23 00:00:00
2018-11-12 00:00:00
2018-12-15 00:00:00
2020-01-29 00:00:00
2020-02-21 00:00:00
2020-02-26 00:00:00
2020-03-04 00:00:00
2020-03-04 00:00:00
2020-03-06 00:00:00
2020-03-13 00:00:00
2020-03-28 00:00:00
Spreadsheet: 789829d1659387288-vlookup-wirking-except-in-one-cell-word-count-tracker-2022-for-upload
Sheet: Aug

Date | Total Word Count | Worked on Project 1 | Worked on Project 2 | Worked on Project 3 | Total Project 1 Word Count | Total Project 2 Word Count | Total Project 3 Word Count | Hours spent | No. of Sprints | Primary Writing Location | Comments | Words Written Today - Project 1 | Words Written Today - Project 2 | Words Written Today - Project 3 | Daily Target Met | Monthly Target | + / - Target |  | % complete
2022-08-01 00:00:00 |  | PGT3 |  |  |  |  |  |  |  |  |  | 758 |  |  |  |  |  |  |  |  | Month Goal | 15500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERFORMANCE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | At your rate, this is the minimum number of words you need to type per day to meet your goal. If the box is blue, you're moving fast. If it's red, you're going slow and have to catch up
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total words
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Words / Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Words / Hour
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage left
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Words to reach goal
Spreadsheet: 112443d1308579462-counting-certain-cells-formula-test
Sheet: Sheet1

PROCESSED | 190
REJECTED | 190
PROCESSED | 190
PROCESSED | 190
PROCESSED | 190
REJECTED | 190
REJECTED | 187
REJECTED | 187
PROCESSED | 187
PROCESSED | 187
REJECTED | 190
 |  | *I would like to display the result of 2, though "REJECTED" was repeated, it has the same number.
Spreadsheet: 586221d1534262616-consildating-rows-with-same-data-test-delivery
Sheet: Sheet1

[NAME] | Rep | Company | Salesman | Day
12707 | 25 | HARRIS TEETER #181 | CODY DEAL | F
12707 | 25 | HARRIS TEETER #181 | CODY DEAL | T
12707 | 25 | HARRIS TEETER #181 | CODY DEAL | R
1005 | 25 | KROGER #533 | CODY DEAL | F
1005 | 25 | KROGER #533 | CODY DEAL | W
12700 | 25 | NEX CONSOL PKG STORE #2 | CODY DEAL | F
12700 | 25 | NEX CONSOL PKG STORE #2 | CODY DEAL | T
12700 | 25 | NEX CONSOL PKG STORE #2 | CODY DEAL | R
47780 | 25 | WALMART SUPER CTR #5922 | CODY DEAL | F
47780 | 25 | WALMART SUPER CTR #5922 | CODY DEAL | T
47780 | 25 | WALMART SUPER CTR #5922 | CODY DEAL | R
Spreadsheet: 0b2a1c11-26d4-4c2b-91b7-de49eafe10f6
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14
 |  |  |  |  |  | 2/ | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.761 | 2.995 | 3.135 | 3.636 | 2.689 | 2.699 | 2.47
Harvested | 2.748 | 2.976 | 3.103 | 3.615 | 2.617 | 2.678 | 2.449
 |  |  |  | Pounds per harvested acre
Yield | 7219 | 6846 | 7085 | 6725 | 7067 | 7449 | 7406
 |  |  |  | Million cwt
Beginning stocks | 39.315 | 29.492 | 30.419 | 36.499 | 48.467 | 41.07900000000004 | 34.55800000000005
Production | 198.388 | 203.733 | 219.85 | 243.104 | 184.941 | 199.479 | 181.364
Imports | 23.9 | 19.218 | 19.023 | 18.338 | 19.359 | 21 | 22.5
Total supply | 261.603 | 252.443 | 269.292 | 297.941 | 252.767 | 261.558 | 238.4220000000001
Food, industrial,
& residual 3/ | 123.152 | 123.77 | 119.947 | 133.603 | 107.505 | 116.951
Seed | 3.697 | 3.87 | 4.488 | 3.324 | 3.332 | 3.049
Total domestic use | 126.849 | 127.64 | 124.435 | 136.927 | 110.837 | 120 | 112
Exports | 105.262 | 94.384 | 108.358 | 112.547 | 100.851 | 107 | 96
Rough | 37.663 | 31.633 | 40.351 | 34.595 | 32.94 | 34.5 | 35
Milled 4/ | 67.599 | 62.751 | 68.007 | 77.952 | 67.911 | 72.5 | 61
Total use | 232.111 | 222.024 | 232.793 | 249.474 | 211.688 | 227 | 208
Ending stocks | 29.49200000000002 | 30.41899999999998 | 36.49900000000002 | 48.46700000000004 | 41.07900000000004 | 34.55800000000005 | 30.42200000000005
 |  |  |  | Percent
Stocks-to-use ratio | 12.70598980660116 | 13.70077108781032 | 15.6787360444687 | 19.42767582994622 | 19.40544575034959 | 15.22378854625553 | 14.62596153846157
 |  |  |  | $/cwt
Average farm |  |  |  |  |  |  | 14.50 to
price 5/ | 12.8 | 16.8 | 14.4 | 12.7 | 14.5 | 14.9 | 15.5
 |  |  |  | Percent
Average
milling rate | 69.88 | 70.83 | 71.53 | 68.86 | 69.93 | 70 | 70.25
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated August 12, 2013.
Spreadsheet: 84732d1284730716-column-consolidation-column-consolidation-macro
Sheet: Consolidation

Department | Postion | Status 1 | Status 2 | Status 3 | Status 4 | HC postion | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: May

Employee Absence Schedule
May | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
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 | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 710429d1608969800-extend-formula-based-on-data-in-adjacent-cell-exend-formula
Sheet: Sheet1

Example-1
2020-05-01 00:00:00 |  |  | I download raw data from SAP to excel. Depends on the date range, the data keep extending (rows).
2020-05-02 00:00:00 |  |  | I put formula in B2 to B10. I need the formula in Col.B to extend when I paste the data in col.A. i.e. If I paste data from A2:A11, the formula to be extended from A2:A10 to A2:A11
2020-05-02 00:00:00 |  |  | In short, if there is data in Col. A, the formula in Col.B to be extended.
2020-05-02 00:00:00 |  |  | Sometimes the data goes up to 1-2 Lakh rows.  Putting formula up to 2 Lakhs in several places resulting increased file size and slow down the process for calculations.
2020-05-03 00:00:00 |  |  | Note: Sometimes data will be of lesser rows when we run backlog report.
2020-05-03 00:00:00
2020-05-03 00:00:00
2020-05-03 00:00:00
2020-05-03 00:00:00
Example-2
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03
HY-05641.01.03