tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 797141d1663739744-powerquery-date-and-time-extraction-power-query-help
Sheet: Sheet1

Resolved |  | Resolved | Resolved - Copy
01.10.2020 08:42:59 |  | 2020-01-10 00:00:00 | 08:42:59
01.10.2020 09:14:36 |  | 2020-01-10 00:00:00 | 09:14:36
01.10.2020 09:15:00 |  | 2020-01-10 00:00:00 | 09:15:00
01.10.2020 10:34:16 |  | 2020-01-10 00:00:00 | 10:34:16
01.10.2020 14:35:33 |  | 2020-01-10 00:00:00 | 14:35:33
01.10.2020 14:50:20 |  | 2020-01-10 00:00:00 | 14:50:20
01.10.2020 15:11:55 |  | 2020-01-10 00:00:00 | 15:11:55
01.10.2020 16:01:07 |  | 2020-01-10 00:00:00 | 16:01:07
01.10.2020 17:05:12 |  | 2020-01-10 00:00:00 | 17:05:12
02.10.2020 08:49:34 |  | 2020-02-10 00:00:00 | 08:49:34
02.10.2020 09:04:27 |  | 2020-02-10 00:00:00 | 09:04:27
02.10.2020 09:44:36 |  | 2020-02-10 00:00:00 | 09:44:36
02.10.2020 09:45:00 |  | 2020-02-10 00:00:00 | 09:45:00
02.10.2020 10:44:34 |  | 2020-02-10 00:00:00 | 10:44:34
02.10.2020 11:03:16 |  | 2020-02-10 00:00:00 | 11:03:16
02.10.2020 11:07:01 |  | 2020-02-10 00:00:00 | 11:07:01
02.10.2020 11:36:23 |  | 2020-02-10 00:00:00 | 11:36:23
02.10.2020 11:56:35 |  | 2020-02-10 00:00:00 | 11:56:35
02.10.2020 12:00:47 |  | 2020-02-10 00:00:00 | 12:00:47
02.10.2020 12:14:22 |  | 2020-02-10 00:00:00 | 12:14:22
02.10.2020 12:34:58 |  | 2020-02-10 00:00:00 | 12:34:58
02.10.2020 12:49:54 |  | 2020-02-10 00:00:00 | 12:49:54
02.10.2020 12:56:28 |  | 2020-02-10 00:00:00 | 12:56:28
Spreadsheet: 713316d1610643879-how-to-split-a-quantity-across-time-periods-example-for-volume-split
Sheet: View 1

Shipping Year | 2019
Sum of Volume | Column Labels
Row Labels | 112019 | 22019 | 32019 | 42019 | 52019 | 62019 | 82019 | Grand Total
7-Eleven | 84.64 | 333 | 411.84 | 0.75 | 44 | 534.24 | 74.88 | 1483.35
Amazon | 216.72 |  | 360.36 | 105.84 |  | 186.48 |  | 869.4000000000001
Costco | 814.3199999999999 | 417 |  | 332.28 | 47 |  |  | 1610.6
Walmart |  | 750 |  | 346.32 |  | 98.28 | 372.6 | 1567.2
Whole Foods |  |  | 378 | 146.16 | 715.68 | 341.64 | 2505.48 | 4086.96
Grand Total | 1115.68 | 1500 | 1150.2 | 931.35 | 806.68 | 1160.64 | 2952.96 | 9617.509999999998
Spreadsheet: 701940d1603993533-equation-for-averaging-cells-that-include-signs-excel-help-2
Sheet: Sheet1

I came across the example below  and I wanted to know how to make the result show <2 in cell J54 in these situations.  No sample can be reported at a value lower than 2.
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 106 | 200 | 4 | 8.04 | 5.84 |  | 1.27
 | 107 | 180 | 4 | 8.15 | 6.05 |  | 1.27
 | 108 | 150 | 4 | 8.29 | 6.31 |  | 1.27
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Average:
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 109 | 200 | 4 | 8.17 | 6.02 |  | 1.27
 | 110 | 180 | 4 | 8.28 | 6.16 |  | 1.27
 | 111 | 150 | 4 | 8.45 | 6.47 |  | 1.27
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Duplicate Average:
 |  |  |  |  |  |  | Duplicate % Recovery (<20%):
 |  |  |  |  |  |  | Effluent & Duplicate Average: |  |  |  |  |  | Eff and Dup average should read <2 because we can't use numbers <2
In this example, I changed the final DO value to 2 and the result is an 8.  With the other two replicates not following both of the rules in red,  the average should be 8 in cell J65
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 106 | 200 | 4 | 8.17 | 6.02 |  | 1.27
 | 107 | 180 | 4 | 8.28 | 2 |  | 1.27
 | 108 | 150 | 4 | 8.45 | 6.47 |  | 1.27
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Average:
Spreadsheet: 867864d1714645978-return-value-based-on-multiple-selections-issue-log
Sheet: Issue Log (2)

 | Issue Log
 | Team name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effort | Benefit | Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | Low | 5
ID | Issue Description | Captured by | Raised by | Date captured | Issue Type | Status | Root Cause Analysis | Resolution | MoSCoW | Effort | Benefit | Rating | Update Log |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | Medium | 3
1 |  |  |  |  |  |  |  |  | Should Have | Low | Medium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | High | 2
2 |  |  |  |  |  |  |  |  | Must Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | Very High | 1
3 |  |  |  |  |  |  |  |  | Won't Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Low | 6
4 |  |  |  |  |  |  |  |  | Could Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Medium | 4
5 |  |  |  |  |  |  |  |  | Must Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | High | 3
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Very High | 2
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Low | 7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Medium | 6
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | High | 4
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Very High | 3
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | Low | 8
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | Medium | 7
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | High | 6
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | Very High | 5
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 226666d1365468590-help-how-to-automatic-reference-and-update-in-master-copy-book1
Sheet: Sheet1

 | Doc 1
File | File #
file 1 | 1
file 2 | 2
file 3 | 3
file 4 | 4
file 5 | 5
file 6 | 6
file 7 | 7
file 8 | 8
file 9 | 9
file 10 | 10
file 11 | 11
file 12 | 12
file 13 | 13
file 14 | 14
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Estimate

Job/Quote Number
 |  | Description | Price
Item |  |  |  |  | [NAME]
Substrate Color |  |  |  |  | Alumicor 10mm
Side(s) |  |  |  |  | Alumicor 6mm
Quantity |  |  |  |  | Sign Board
Height |  |  |  |  | Acrylic
[NAME] |  |  |  |  | PVC 3mm
Number of Color(s) Front |  |  |  |  | Coroplast 10mm
Number of Color(s) Back |  |  |  |  | Coroplast 4mm
 |  |  |  |  | Aluminum 80
[NAME]) Front |  |  |  |  | Aluminum 40
[NAME]) Back |  |  |  |  | Magnetic
[NAME]
[NAME] |  |  |  |  | 1 Sided
 |  |  |  |  | 2 Sided
 |  |  |  |  | Other
Subtotal |  | 0 |  |  | Design
Tax |  | 0 |  |  | Shipping
Total |  | 0 |  |  | Delivery
Deposit |  | 0 |  |  | Install
 |  |  |  |  | Custom Cut
Spreadsheet: 77253d1277761140-conditional-format-based-on-information-on-another-worksheet-blackoutgreen
Sheet: Target Date

Task ID | Task | Frequency | Target Date | Actual Date
1 | x | QTR | 2010-02-01 00:00:00 | 2010-01-31 00:00:00
2 | x | SEMIANNU | 2010-03-01 00:00:00 | 2010-03-01 00:00:00
3 | x | QTR | 2010-03-15 00:00:00
4 | x | QTR | 2010-04-01 00:00:00 | 2010-03-31 00:00:00
5 | x | QTR | 2010-05-01 00:00:00 | 2010-04-30 00:00:00
6 | x | QTR | 2010-06-01 00:00:00 | 2010-06-10 00:00:00
7 | x | QTR | 2010-06-30 00:00:00
8 | x | QTR | 2010-07-01 00:00:00
9 | x | QTR | 2010-08-01 00:00:00
10 | x | QTR | 2010-08-01 00:00:00
11 | x | SEMIANNU | 2010-08-10 00:00:00
12 | x | QTR | 2010-08-16 00:00:00
13 | x | QTR | 2010-08-16 00:00:00
14 | x | YR | 2010-08-16 00:00:00
15 | x | QTR | 2010-08-16 00:00:00
16 | x | QTR | 2010-08-30 00:00:00
17 | x | SEMIANNU | 2010-08-30 00:00:00
18 | x | SEMIANNU | 2010-09-01 00:00:00
19 | x | SEMIANNU | 2010-09-15 00:00:00
20 | x | YR | 2010-10-01 00:00:00
21 | x | SEMIANNU | 2010-10-01 00:00:00
22 | x | QTR | 2010-10-01 00:00:00
23 | x | SEMIANNU | 2010-10-01 00:00:00
24 | x | SEMIANNU | 2010-10-15 00:00:00
25 | x | YR | 2010-10-15 00:00:00
26 | x | YR | 2010-10-15 00:00:00
27 | x | QTR | 2010-10-15 00:00:00
28 | x | QTR | 2010-11-01 00:00:00
29 | x | YR | 2010-11-14 00:00:00
30 | x | YR | 2010-11-15 00:00:00
31 | x | QTR | 2010-11-14 00:00:00
32 | x | QTR | 2010-12-01 00:00:00
33 | x | SEMIANNU | 2010-11-14 00:00:00
34 | x | SEMIANNU | 2010-11-15 00:00:00
35 | x | MO | 2010-09-30 00:00:00
36 | x | MO | 2010-10-01 00:00:00
Spreadsheet: 240649d1370379008-create-subtotal-lines-excel_tablecopy
Sheet: report

Monthly summary type 1
Monthly summary type 2
Total
customer | oder | description | doc ID | requestor | hours
A Total
B Total
C Total
Grand Total
x
Spreadsheet: 329076d1404196616-calculate-up-to-a-value-oeldere-329004d1404157357-calculate-up-to-a-value-hours
Sheet: Sheet1

 | Week |  | Week | Total | Total | Total | Total
 | Commencing |  | No | Hours | None Wk | Holidays | [NAME]
 | 00:00:00 |  | 1 | 1 day, 21:00:00 | 6:00:00
 |  |  | 2 |  |  | 5
 |  |  | 3 | 2 days, 4:00:00 | 7:00:00
 |  |  | 4 |  |  | 5
 |  |  | 5
 |  |  | 6
 |  |  | 7 |  |  | 5
 |  |  | 8
 |  |  | 9 |  |  | 5
 |  |  | 10
 |  |  | 11 |  |  | 3
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
Spreadsheet: 207422d1358452048-sumif-with-multiplication-excel-help
Sheet: Sheet2

 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
 | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
8654
9164
9627
9635
9659
Spreadsheet: 117269d1312607114-excel-2007-return-values-that-fall-within-a-date-range-excel-help-1-
Sheet: RECAP

VEND_CODE | 2011-08-15 00:00:00 | 2011-08-22 00:00:00 | 2011-08-29 00:00:00 | 2011-09-12 00:00:00 | TOTAL
ALLEN
CHARLIE
CURTIS
DAVE
TOTAL
Spreadsheet: 021bbd65-c88b-425e-9ed5-11376a26ae1b
Sheet: Sheet1

Table 10--Global rice exporters, calendar years; monthly revisions and annual changes | 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
 | 2011 |  |  |  | 2012 |  |  |  |  |  | 2013 1/
 | September |  | August | September |  | Monthly | Annual |  | August | September |  | Monthly | Annual
 | 2012 |  | 2012 | 2012 |  | revisions | changes |  | 2012 | 2012 |  | revisions | changes
 |  |  |  |  |  |  | 1,000 metric tons (milled basis)
Argentina | 732 |  | 650 | 650 |  | 0 | -82 |  | 560 | 560 |  | 0 | -90
Australia | 311 |  | 450 | 450 |  | 0 | 139 |  | 500 | 500 |  | 0 | 50
Brazil | 1296 |  | 1000 | 1000 |  | 0 | -296 |  | 600 | 800 |  | 200 | -200
Burma | 778 |  | 600 | 600 |  | 0 | -178 |  | 750 | 600 |  | -150 | 0
Cambodia | 860 |  | 800 | 800 |  | 0 | -60 |  | 950 | 950 |  | 0 | 150
China | 487 |  | 500 | 500 |  | 0 | 13 |  | 600 | 600 |  | 0 | 100
Ecuador | 70 |  | 15 | 30 |  | 15 | -40 |  | 15 | 15 |  | 0 | -15
Egypt | 320 |  | 600 | 600 |  | 0 | 280 |  | 600 | 600 |  | 0 | 0
European Union-27 | 241 |  | 245 | 245 |  | 0 | 4 |  | 235 | 235 |  | 0 | -10
Guinea | 80 |  | 80 | 80 |  | 0 | 0 |  | 80 | 80 |  | 0 | 0
Guyana | 250 |  | 230 | 230 |  | 0 | -20 |  | 250 | 250 |  | 0 | 20
India | 4637 |  | 8000 | 8000 |  | 0 | 3363 |  | 6500 | 6500 |  | 0 | -1500
Japan | 200 |  | 200 | 200 |  | 0 | 0 |  | 200 | 200 |  | 0 | 0
Korea, South | 4 |  | 5 | 5 |  | 0 | 1 |  | 5 | 5 |  | 0 | 0
Pakistan | 3414 |  | 3750 | 3750 |  | 0 | 336 |  | 4000 | 4000 |  | 0 | 250
Paraguay | 208 |  | 200 | 250 |  | 50 | 42 |  | 150 | 200 |  | 50 | -50
Peru | 50 |  | 20 | 20 |  | 0 | -30 |  | 60 | 60 |  | 0 | 40
Russia | 142 |  | 150 | 200 |  | 50 | 58 |  | 150 | 160 |  | 10 | -40
Thailand | 10647 |  | 6500 | 6500 |  | 0 | -4147 |  | 8000 | 8000 |  | 0 | 1500
Turkey | 90 |  | 75 | 75 |  | 0 | -15 |  | 80 | 80 |  | 0 | 5
Uganda | 40 |  | 35 | 35 |  | 0 | -5 |  | 35 | 35 |  | 0 | 0
United States | 3247 |  | 3500 | 3500 |  | 0 | 253 |  | 3100 | 3350 |  | 250 | -150
Uruguay | 841 |  | 850 | 850 |  | 0 | 9 |  | 850 | 850 |  | 0 | 0
Vietnam | 7000 |  | 7000 | 7000 |  | 0 | 0 |  | 7000 | 7000 |  | 0 | 0
Subtotal | 35945 |  | 35455 | 35570 |  | 115 | -375 |  | 35270 | 35630 |  | 360 | 60
Other | 234 |  | 199 | 304 |  | 105 | 69 |  | 225 | 225 |  | 0 | -79
 |  |  |  |  |  |  |  |  |  |  |  | 0
World total | 36179 |  | 35654 | 35874 |  | 220 | -305 |  | 35495 | 35855 |  | 360 | -19
U.S. Share | 0.08974819646756406 |  | 0.09816570370785886 | 0.09756369515526565 |  | -- | -- |  | 0.08733624454148471 | 0.09343187839910752 |  | -- | --
-- Not available.  Note: All trade data are reported on a calendar-year basis.
1/ Projected.
Source: Production, Supply, & Distribution Online Data Base, FAS/USDA, http://www.fas.usda.gov/psdonline/psdHome.aspx.
Last updated September 12, 2012.
Spreadsheet: 738301d1624961185-data-range-copy-and-paste-book1
Sheet: Sheet1

730 | Q | 795 | 678 | 337 | 456 | 970
604 | W | 895 | 594 | 322 | 516 | 244
439 | E | 773 | 507 | 751 | 721 | 558
607 | R | 219 | 33 | 643 | 823 | 587
487 | T | 192 | 876 | 55 | 836 | 933
624 | Y | 786 | 12 | 443 | 647 | 123
13 | U | 631 | 791 | 791 | 884 | 727
396 | I | 576 | 937 | 129 | 871 | 207
391 | O | 141 | 15 | 62 | 917 | 410
44 | P | 386 | 371 | 248 | 791 | 865
978 | A | 321 | 205 | 431 | 497 | 708
483 | S | 798 | 672 | 778 | 248 | 20
117 | D | 302 | 23 | 188 | 427 | 420
586 | F | 586 | 33 | 275 | 419 | 580
658 | G | 72 | 948 | 315 | 554 | 541
Spreadsheet: 196054d1353811224-how-to-avoid-blank-rows-in-data-validation-list-datavallist
Sheet: Sheet1

WEEK | TOPIC | [NAME] | LEARNING STANDARDS
1 | MY BEAUTIFUL WORLD | 1.Believe in God | At the end of the lesson,the pupils will be able to
 |  |  | 1.1.1 describe their unique nature of daily living
 |  |  | 1.1.2 know [NAME]'s power in creating natures.
 |  | 1.1 To know the uniqueness of nature | 1.1.3 feel thanks to GOD.
 |  |  | 1.1.4 involve oneself to keep enviroment cleans.
 |  | 1.Believe in God
 |  | 1.2 Believe that GOD is the real power
2 | MY BEAUTIFUL WORLD | 2. Kindness
 |  | Able to help others | At the end of the lesson,the pupils will be able to
 |  |  | 2.1.1 to know the example of kind-hearted activities.
 |  | 2.1 give a hand in the family | 2.1.2 To help poor families.
 | Week
 | 1
 | Week
1
2
Spreadsheet: 739676d1625851667-counting-unique-values-within-a-date-range-count-unique-sample
Sheet: CALC

Commission Event
 | Amount Paid | Appointments | Unique QCN | Start Month | End Month
2020-10-01 00:00:00 | 150 | 2 | 2 | 2020-10-01 00:00:00 | 2020-10-31 00:00:00
2020-11-01 00:00:00 | 750 | 13 | 7 | 2020-11-01 00:00:00 | 2020-11-30 00:00:00
Spreadsheet: 113652d1309483457-how-to-sort-grouped-data-in-excel-multilevelsort2003
Sheet: Sheet1

Delivery Date | Project | Task
2011-09-12 00:00:00 | Project 1 | Task 41 |  | Hi bool,
2011-10-03 00:00:00 | Project 1 | Task 11 |  | Here is some fake data to see if it works for you.
2011-10-29 00:00:00 | Project 1 | Task 21
2011-11-06 00:00:00 | Project 1 | Task 31 |  | I sorted the List to the left first by Date and second by Project.
2011-11-29 00:00:00 | Project 1 | Task 1 |  | In newer versions of excel you can add levels to the sort and do the same thing.
2011-07-24 00:00:00 | Project 10 | Task 40
2011-09-04 00:00:00 | Project 10 | Task 10 |  | I think this is what you want.
2011-09-09 00:00:00 | Project 10 | Task 20
2011-10-07 00:00:00 | Project 10 | Task 50
2011-12-19 00:00:00 | Project 10 | Task 30
2011-08-30 00:00:00 | Project 2 | Task 12
2011-09-20 00:00:00 | Project 2 | Task 32
2011-09-23 00:00:00 | Project 2 | Task 22
2011-10-31 00:00:00 | Project 2 | Task 2
2011-11-15 00:00:00 | Project 2 | Task 42
2011-07-25 00:00:00 | Project 3 | Task 13
2011-07-30 00:00:00 | Project 3 | Task 43
2011-09-30 00:00:00 | Project 3 | Task 3
2011-12-27 00:00:00 | Project 3 | Task 33
2012-01-07 00:00:00 | Project 3 | Task 23
2011-09-06 00:00:00 | Project 4 | Task 24
2011-11-05 00:00:00 | Project 4 | Task 44
2011-11-25 00:00:00 | Project 4 | Task 4
2011-12-25 00:00:00 | Project 4 | Task 14
2012-01-07 00:00:00 | Project 4 | Task 34
2011-10-14 00:00:00 | Project 5 | Task 45
2011-10-19 00:00:00 | Project 5 | Task 15
2011-10-28 00:00:00 | Project 5 | Task 5
2011-11-20 00:00:00 | Project 5 | Task 35
2012-01-09 00:00:00 | Project 5 | Task 25
2011-07-04 00:00:00 | Project 6 | Task 36
2011-08-13 00:00:00 | Project 6 | Task 16
2011-08-29 00:00:00 | Project 6 | Task 6
2011-10-17 00:00:00 | Project 6 | Task 46
2011-12-12 00:00:00 | Project 6 | Task 26
2011-07-09 00:00:00 | Project 7 | Task 37
2011-09-24 00:00:00 | Project 7 | Task 27
2011-11-24 00:00:00 | Project 7 | Task 47
2011-12-31 00:00:00 | Project 7 | Task 7
2012-01-01 00:00:00 | Project 7 | Task 17
2011-07-15 00:00:00 | Project 8 | Task 48
2011-08-11 00:00:00 | Project 8 | Task 28
2011-08-28 00:00:00 | Project 8 | Task 18
2011-09-16 00:00:00 | Project 8 | Task 8
2012-01-01 00:00:00 | Project 8 | Task 38
2011-07-02 00:00:00 | Project 9 | Task 49
2011-08-18 00:00:00 | Project 9 | Task 9
2011-09-24 00:00:00 | Project 9 | Task 39
2011-09-28 00:00:00 | Project 9 | Task 29
2011-11-19 00:00:00 | Project 9 | Task 19
Spreadsheet: 156254d1337243356-excel-2007-meeting-criteria-in-a-range-yes-no
Sheet: Sheet1

Column A | Column B
1 | A
4 | J
7 | A
4 | B
5 | c
6 | E
5 | E
8 | C
9 | F
8 | D
Does 5 and A or 8 and D appear on same row within the range
Spreadsheet: 781691d1653491369-calculate-time-of-arrival-with-if-condition-based-on-departure-calculate-time-of-arrival-with-if-condition-based-on-departure
Sheet: Sheet1

Date | Departure | Destination | Truck nr | Planned hr for truck to load | Departure hr | Nr of hr from C to D | Estimated hr of arrival to store
 | BAIA MARE | SATU MARE | B400TBL | 11:00:00 | 12:00:00 | 01:45:00 |  |  |  |  | Unloadin time at 1st store
 | CAMPUS CALAN | BAIA MARE | B400TBL | 11:00:00 | 12:00:00 | 08:00:00 |  |  |  |  | 02:00:00
 | CAMPUS CALAN | [NAME] | B401TBL | 11:00:00 | 12:00:00 | 04:00:00
 | CAMPUS CALAN | TG.MURES ISTORIC | B402TBL | 11:00:00 | 12:00:00 | 05:00:00
 | [NAME] | [NAME] | B403TBL | 12:00:00 | 13:00:00 | 01:30:00
 | CAMPUS CALAN | [NAME] | B403TBL | 14:00:00 | 15:00:00 | 04:00:00
 | CAMPUS CALAN | TG.MURES [NAME] | B404TBL | 14:00:00 | 15:00:00 | 05:00:00
 | CAMPUS CALAN | ORADEA | B405TBL | 13:00:00 | 14:00:00 | 05:00:00
 | CAMPUS CALAN | CLUJ NORD | B406TBL | 15:00:00 | 16:00:00 | 04:00:00
 | CAMPUS CALAN | CLUJ ISTORIC | B407TBL | 16:00:00 | 17:00:00 | 04:00:00
 | CAMPUS CALAN | [NAME] | B408TBL | 17:00:00 | 18:00:00 | 01:00:00
 | CAMPUS CALAN | BUZIAS | B409TBL | 21:00:00 | 22:00:00 | 04:00:00
 | CAMPUS CALAN | TURDA | B410TBL | 21:00:00 | 22:00:00 | 04:00:00
Spreadsheet: 94507d1294309702-excel-2007-excel-experts-plz-i-need-help-project-data-4
Sheet: Sheet4

 |  |  |  | ID | 900007161 |  | Major
Different Courses | Grade |  | Accounting
 |  |  |  | Course | Grade |  | Course | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI101 |  |  | ENG204 |  |  |  |  | ENG208 |  |  | ACC305
 |  |  | 1st semester | BIS101 |  | 3rd semester | ACC201 |  |  |  | 5th semester | BLW301 |  | 7th semester | ACC410
 |  |  |  | MTH101 |  |  | ECO201 |  |  |  |  | QBA202 |  |  | MJEXXX
 |  |  |  | HUMXXX |  |  | QBA201 |  |  |  |  | ACC301 |  |  | FREEXXX
 |  |  |  | SCIXXX |  |  | MGT201 |  |  |  |  | FREEXXX |  |  | FREEXXX
 |  |  |  |  | Grade |  |  | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI102 |  |  | ECO202 |  |  |  |  | [NAME] |  |  | MGT406
 |  |  | 2nd semester | ARAXXX |  | 4th semester | ACC202 |  |  |  | 6th semester | ACC302 |  | 8th semester | ACC406
 |  |  |  | MTH102 |  |  | FIN201 |  |  |  |  | HSSXXX |  |  | MJEXXX
 |  |  |  | SCIXXX |  |  | MKT201 |  |  |  |  | MGT360 |  |  | FREEXXX
 |  |  |  | HUMXXX |  |  | MIS201 |  |  |  |  | ACC303 |  |  | FREEXXX
 |  |  |  |  |  |  |  |  |  |  |  | FREEXXX
Spreadsheet: 85050d1285126861-reshaping-data-gquinn-ef746330-sdg10
Sheet: Instructions

Current DATA: |  |  |  |  |  |  |  |  | Yesterday, 02:05 PM
Payment | [NAME] | Dt2 | Dt3 | Dt4 |  |  |  |  | Gquinn - EF746330 - SDG10.xls
15 | 2009-06-07 00:00:00 | 2009-10-04 00:00:00 | 2010-02-07 00:00:00 |  |  |  |  |  | Registered User   Join Date: 16 Sep 2010
3 | 2009-08-15 00:00:00 | 2009-10-15 00:00:00 | 2009-12-15 00:00:00 | 2010-02-15 00:00:00 |  |  |  |  | Location: Clearwater, Florida
 |  |  |  |  |  |  |  |  | MS Office Version:Excel 2007
 |  |  |  |  |  |  |  |  | Posts: 6
LOOKING For: |  |  |  |  |  |  |  |  | Reshaping Data
Payment | Date |  |  |  |  |  |  |  | http://www.excelforum.com/excel-worksheet-functions/746330-reshaping-data.html
15 | 2009-06-07 00:00:00 |  |  |  |  |  |  |  | Hi all,
15 | 2009-10-04 00:00:00 |  |  |  |  |  |  |  | I need to reshape data.
15 | 2010-02-07 00:00:00 |  |  |  |  |  |  |  | Currently it is in this form:
3 | 2009-08-15 00:00:00 |  |  |  |  |  |  |  | Payment Dt1 Dt2 Dt3 Dt4
3 | 2009-10-15 00:00:00 |  |  |  |  |  |  |  | 15.00 6/7/2009 10/7/2009 2/7/2010
3 | 2009-12-15 00:00:00 |  |  |  |  |  |  |  | 3.00 8/15/2009 10/15/2009 12/15/2009 2/15/2010
3 | 2010-02-15 00:00:00 |  |  |  |  |  |  |  | Payment, Dt1, Dt2, Dt3 and Dt4 are all seperate variables/head up seperate columns.
 |  |  |  |  |  |  |  |  | I need it to be in the following form:
 |  |  |  |  |  |  |  |  | Payment Date
 |  |  |  |  |  |  |  |  | 15.00 6/7/2009
 |  |  |  |  |  |  |  |  | 15.00 10/7/2009
 |  |  |  |  |  |  |  |  | 15.00 2/7/2010
 |  |  |  |  |  |  |  |  | 3.00 8/15/2009
 |  |  |  |  |  |  |  |  | 3.00 10/15/2009
 |  |  |  |  |  |  |  |  | 3.00 12/15/2009
 |  |  |  |  |  |  |  |  | 3.00 2/15/2010
 |  |  |  |  |  |  |  |  | is there any way to do this? Let me know if anything needs to be clarified.
 |  |  |  |  |  |  |  |  | I attached a spreadsheet with this template for easier viewing.
 |  |  |  |  |  |  |  |  | thanks much!
 |  |  |  |  |  |  |  |  | Payment
 |  |  |  |  |  |  |  |  | Date
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -137341 | -136796
2 | -125680 | -124374
3 | -103730 | -110538
4 | -64504 | -65000
5 | -65339 | -64480
6 | -110873 | -111438
7 | -104259 | -103558
8 | -123476 | -123233
9 | -115393 | -114855
10 | -91816 | -91920
11 | -44422 | -44371
12 | -18430 | -18414
13 | -44797 | -44092
14 | -194555 | -194162
15 | -206012 | -204162
16 | -194790 | -194162
17 | -77025 | -77300
18 | -126017 | -123466
19 | -94130 | -93379
20 | -116887 | -116464
21 | -126531 | -124368
22 | -109715 | -109429
23 | -100746 | -99430
24 | -80474 | -80000
25 | -95281 | -93844
26 | -96315 | -95758
27 | -79910 | -79523
28 | -113521 | -112302
29
30
31
 | 2001-06-30 00:00:00 |  | 28278
 | 2001-07-28 00:00:00
Spreadsheet: 673194d1587240243-possibly-a-complicated-index-match-book1test
Sheet: Sheet1

 | Alibaba Group Holding
Code | Name | Risk & Obj | Tgt %
ABCD123 | Account 1 | MH G
ABCD124 | Account 2 | MH B
ABCD125 | Account 3 | M B
ABCD126 | Account 4 | M B
ABCD127 | Account 5 | MH G
ABCD128 | Account 6 | M G
ABCD129 | Account 7 | MH B
ABCD130 | Account 8 | H G
ABCD131 | Account 9 | MH G
[NAME] | Account 10 | M G
ABCD133 | Account 11 | M G
ABCD134 | Account 12 | M B
ABCD135 | Account 13 | M B
ABCD136 | Account 14 | M B
ABCD137 | Account 15 | MH G
ABCD138 | Account 16 | MH B
ABCD139 | Account 17 | MH B
ABCD140 | Account 18 | M G
ABCD141 | Account 19 | M B
ABCD142 | Account 20 | M B
ABCD143 | Account 21 | M B
ABCD144 | Account 22 | M B
ABCD145 | Account 23 | M B
ABCD146 | Account 24 | M B
[NAME] | Account 25 | MH G
ABCD148 | Account 26 | M B
ABCD149 | Account 27 | M B
ABCD150 | Account 28 | M B
ABCD151 | Account 29 | M B
ABCD152 | Account 30 | M B
ABCD153 | Account 31 | M G
Spreadsheet: 135848d1326274354-importing-linking-cell-contents-from-another-excel-workbook-samplea
Sheet: Sheet1

Job Number | Due Date | SPEC 1? | SPEC 2? | STEP 1 HRS | STEP 2 HRS | STEP 3 HRS | Proposed Job Hours | Actual Job Hours
ABC1 (PROP HOURS) | DATE | Y/N | Y/N | 1 | 1 | 1 |  |  |  | TOTAL PROPOSED HOURS (ALL JOBS)
ABC1 (ACTUAL HOURS) | DATE | Y/N | Y/N | 0.5 | 0.5 | 0.5 |  |  |  | TOTAL ACTUAL HOURS (ALL JOBS)