tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 879301d1726766123-unalbe-to-get-dates-and-times-to-convert-and-cant-combine-columns-a-and-b-date-and-time-etc
Sheet: Sheet1

AGENCY | CASE # | OCCU DATE/TIME | RPT DATE/TIME | UCR CODE |  | COMBINED | DATE | TIME
FMO | 190900002 | 2019-09-01 23:25:00 | 2019-09-01 23:25:00 | 200 |  |  | 2019-09-01 00:00:00 | 23:25:00
FMO | 190900003 | 2019-09-01 23:58:00 | 2019-09-01 23:59:00 | 200 |  |  | 2019-09-01 00:00:00 | 23:58:00
FMO | 190900001 | 2019-09-01 13:34:00 | 2019-09-01 13:35:00 | 200 |  |  | 2019-09-01 00:00:00 | 13:34:00
FMO | 200700014 | 2020-07-05 18:35:00 | 2020-07-05 18:36:00 | 200 |  |  | 2020-07-05 00:00:00 | 18:35:00
HCC1 | 200200524 | 2019-05-23 08:00:00 | 2020-02-28 11:51:00 | 720 |  |  | 2019-05-23 00:00:00 | 08:00:00
HCC1 | 200500155 | 2020-05-10 18:00:00 | 2020-05-11 20:04:00 | 13B |  |  | 2020-05-10 00:00:00 | 18:00:00
HCC1 | 210400271 | 2021-04-15 00:00:00 | 2021-04-15 14:49:00 | 23F |  |  | 2021-04-15 00:00:00
Spreadsheet: 318461d1400151526-calculate-price-based-on-number-of-miles-miles
Sheet: Sheet1

miles | rate
50
 |  |  |  |  |  |  | Actual [NAME] - 12 steps
 |  |  | [NAME] | Rate
 |  |  | 1 | 10 |  |  | For The First |  | 1 Miles |  | Charge | 10 | Flat Rate
 |  |  | 5 | 18.8 |  |  | For The Next |  | 29 Miles |  | Charge | 2.2 | For Every 1 Mile
 |  |  | 10 | 29.8 |  |  | For The Next |  | 5 Miles |  | Charge | 2.15 | For Every 1 Mile
 |  |  | 20 | 51.8 |  |  | For The Next |  | 5 Miles |  | Charge | 2.1 | For Every 1 Mile
 |  |  | 30 | 73.8 |  |  | For The Next |  | 2 Miles |  | Charge | 0.5 | For Every 1 Mile
 |  |  | 40 | 95.05 |  |  | For The Next |  | 5 Miles |  | Charge | 2.05 | For Every 1 Mile
 |  |  | 50 | 112.3 |  |  | For The Next |  | 5 Miles |  | Charge | 2 | For Every 1 Mile
 |  |  | 60 | 131.6 |  |  | For The Next |  | 5 Miles |  | Charge | 1.95 | For Every 1 Mile
 |  |  | 70 | 149.95 |  |  | For The Next |  | 10 Miles |  | Charge | 1.85 | For Every 1 Mile
 |  |  | 80 | 167.8 |  |  | For The Next |  | 10 Miles |  | Charge | 1.8 | For Every 1 Mile
 |  |  | 90 | 185.3 |  |  | For The Next |  | 20 Miles |  | Charge | 1.75 | For Every 1 Mile
 |  |  | 100 | 202.65 |  |  | For The Next |  | 999 Miles |  | Charge | 1.7 | For Every 1 Mile
 |  |  | 150 | 287.65
 |  |  | 250 | 457.65
 |  | Working examples ^
Spreadsheet: 99701d1298301446-a-list-of-days-by-date-to-the-end-of-the-next-month-then-the-list-turns-to-months-book1
Sheet: Sheet1

2011-02-21 00:00:00
Spreadsheet: andy_zipper__172__DYNEGY-ICE VOL Apr17
Sheet: E-Mail

 | 2001-04-17 00:00:00
 | Intercontinental Exchange |  |  | Enron's Activity on ICE
 | Commodity | Volume |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  | ECC
 |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  | EPM | POWER
 |  |  |  | ENA | POWER
 |  |  |  | ENA | US NATURAL GAS
 |  |  |  | ENA | COAL
 |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: 96701d1296031340-excel-2007-matching-and-combining-data-out-of-3-columns-combining-data
Sheet: Sheet2

Dim a, b, c, i As Long, j As Long, zctrl As Long, n As Long, k As Long, m As Long, t As Long
a = Range([a1], Cells(ActiveSheet.UsedRange.Rows.Count, 3)): [NAME]), 1 To 3)
For i = 1 To UBound(a)
If a(i, 1) <> "" Or a(i, 2) <> "" Or a(i, 3) <> "" Then
j = j + 1: b(j, 1) = a(i, 1): b(j, 2) = a(i, 2): b(j, 3) = a(i, 3)
End If
Next: zctrl = 1
For m = 2 To UBound(b, 2)
t = IIf(b(1, m) = "", -1, 1)
For i = 1 To UBound(b)
If b(i, m) <> "" Then
If t = -1 Then
For n = i To zctrl Step -1
If [NAME], 1) <> "" Then [NAME], m) = b(i, m)
Next: zctrl = i + 1
Else
For n = i + 1 To UBound(b)
If [NAME], m) <> "" Then
i = n - 1: Exit For
Else
If [NAME], m - 1) <> "" And [NAME], m) = "" Then [NAME], m) = b(i, m)
End If
Next
End If
End If
Next
Next
ReDim c(1 To UBound(b), 1 To 3)
For i = 1 To UBound(b)
If b(i, 1) <> "" Then k = k + 1: c(k, 1) = b(i, 1): c(k, 2) = b(i, 2): c(k, 3) = b(i, 3)
Next
Range([E1], Cells(j, "g")) = c:
Spreadsheet: 39717d1238003420-finding-the-modal-value-of-a-word-in-a-set-of-filtered-data-sample
Sheet: Calculations (2)

 | Grower | Lot | Product | Variety | Amount Received | Amount Rejected | Reason | Percentage
 | GROWER1 | 1231453 | Product A | MIXED | 24000
 | GROWER2 | 2342342 | Product B | MIXED | 33655 | 2200 | OPEN BUDS | 6
 | GROWER2 | 23476623 | Product A | PINK FANCY | 55000 | 54000 | YELLOWING | 95
 | GROWER2 | 234623 | Product C | TASSMAN FA | 4000 | 120 |  | 3
 | GROWER2 | 23627 | Product D | GIOELLE FA | 6400 | 64 |  | 1
 | GROWER2 | 12336 | Product B | PINK FANCY | 11960 | 1018 | BRUISING | 14
 | GROWER2 | 23462345 | Product E | SPRAY PINK | 6200 | 62 |  | 1
 | GROWER2 | 6234 | Product F | ROSITAVEND | 2112 | 21.12 |  | 1
 | GROWER2 | 234156 | Product B | OCEANSONG | 1728 | 172.8 | BRUISING | 10
 | GROWER2 | 2356 | Product A | PINK FANCY | 14400 | 1152 | BRUISING | 8
 | GROWER2 | 236214 | Product N | PRADO | 1600 | 16 |  | 1
 | GROWER2 | 236243 | Product M | [NAME] | 1600 | 16 |  | 1
 | GROWER2 | 13625 | Product B | VENDELA | 9024 | 902.4 | BRUISING | 10
 |  |  |  |  |  | Main Rejection Reason | OPEN BUDS | <--------
Spreadsheet: 27056d1219860077-seeking-tips-on-dealing-with-n-a-vlookup
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2
Number | Name | Country |  |  | Number | Name | Country
1 | [NAME] | Germany | Good |  | 1 | [NAME] | Germany
2 | [NAME] | #N/A | #N/A |  | 3 | [NAME] | Sweden
3 | [NAME] | Sweden | Good |  | 4 | [NAME] | France
4 | [NAME] | France | Good
5 | [NAME] | #N/A | #N/A
Notes:  In column D I am trying to display the word Good if a country is listed in column C.  If a country doesn’t exist, display [NAME].
Spreadsheet: 293862d1391111499-create-list-listing-each-item-multiple-times-based-number-in-another-column-book1-ndm
Sheet: Sheet1

Item | Count
175 | 3
176 | 7
177 | 2
178 | 9
179 | 1
180 | 8
181 | 11
182 | 10
183 | 6
184 | 5
Spreadsheet: jonathan_mckay__16918__CODA - Buy
Sheet: Enron Direct Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | ECC |  |  |  |  | Deal Date: |  | 2001-08-07 00:00:00 |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-10-01 00:00:00 |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  |  | 6 | June
Deal End Date: | 2002-09-30 00:00:00 |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  | 4.33 |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Buy |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total |  | Adjustment to hedge Round number of Days
 | January |  |  |  |  |  |  | 6014 |  | 6003
 | February |  |  |  |  |  |  | 4284 |  | 4296
 | March |  |  |  |  |  |  | 4030 |  | 4041
 | April |  |  |  |  |  |  | 2610 |  | 2620
 | May |  |  |  |  |  |  | 2015 |  | 2027
 | June |  |  |  |  |  |  | 930 |  | 921
 | July |  |  |  |  |  |  | 992 |  | 1004
 | August |  |  |  |  |  |  | 1116 |  | 1111
 | September |  |  |  |  |  |  | 2010 |  | 2086
 | October |  |  |  |  |  |  | 3503 |  | 3495
 | November |  |  |  |  |  |  | 4950 |  | 4955
 | December |  |  |  |  |  |  | 5425 |  | 5430
 | TOTAL:
Spreadsheet: 28080d1221926549-transfering-data-to-new-source-copy-of-transferring-crystal-to-excel
Sheet: Sheet4

Sum of Ntr
Time | Total
0 | 7
1 | 1
2 | 3
3 | 2
4 | 3
5 | 3
6 | 1
7 | 5
8 | 16
9 | 24
10 | 14
11 | 9
12 | 15
13 | 14
14 | 16
15 | 35
16 | 14
17 | 18
18 | 5
19 | 9
20 | 12
21 | 4
22 | 8
23 | 8
Grand Total | 246
Spreadsheet: 822843d1679563603-sum-from-drop-down-live-nics-clinics
Sheet: WC 27.03.2023

 | Service | Weekly Allocation | Remaining
 | Accute Illness Clinic | 25 |  | < Weekly Accute Clinic allocation minus Hot Clinic and Cold Clinic
 | First Contact Physio | 2 |  | <- Sum of all week [NAME] |  | Hot Clinic | Cold Clinic
 |  |  |  | - | Sum of all week Hot clinic (service = Hot Clinic-> |  |  | <- sum of all week cold clinic (Service = Cold Clinic)
 | Phlebotomy | 4 |  | <-Sum of all week Phlebotomy
 | Spiro and FeNO | n/a | n/a |  |  | WC 27.03.23
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | Service | PT Reference | Service | PT Reference | Service | PT Reference | Service | PT Reference | Service | PT Reference
 | Hot Clinic | 123456
 | Physio | 7890
Spreadsheet: 329862d1404434430-need-help-with-an-excel-formula-book1
Sheet: Sheet1

 | [NAME]
1 |  | <- should be Dog
2 |  | <- should be Cat
3
4
3 |  | <- should be chicken
6 |  |  |  | 1 | Dog
7 |  |  |  | 2 | Cat
8 |  |  |  | 3 | Chicken
9 |  |  |  | 4 | Rabbit
10 |  |  |  | 5 | Horse
 |  |  |  | 6 | Snake
 |  |  |  | 7 | Tiger
 |  |  |  | 8 | Lion
 |  |  |  | 9 | Monkey
 |  |  |  | 10 | Goat
Spreadsheet: 853929d1703872344-next-row-down-progressive-subtraction-help-needed-samplefile2
Sheet: Sheet1

1 | 25.345 | manual | new formula
2 | 49.139664
3 | 60.179838
4 | 52.24716
5 | 46.426695
1 | 52.4741
2 | 36.4878
3 | 75.142
4 | 66.1454
5 | 78.1425
Spreadsheet: 719875d1613863941-auto-populate-date-ranges-to-linear-calendar-90-day-mx-outlook-automated-test-1
Sheet: Task List

 | To Weekly Task Schedule
 | TASK LIST
 | [NAME] | Assignment/Task | Date Start | Date End | Duration | Match Data | 0
 | 101 | 364 DSI | 2021-03-01 00:00:00 | 2021-03-15 00:00:00
 | 101 | 84 DSI | 2021-03-01 00:00:00 | 2021-03-12 00:00:00
 | 101 | 28 DSI | 2021-03-01 00:00:00 | 2021-03-02 00:00:00
 | 101 | 14 DSI | 2021-03-01 00:00:00 | 2021-03-01 00:00:00
 | 110 | 728 DSI | 2021-03-14 00:00:00 | 2021-03-16 00:00:00
 | 120 | 728 | 2021-08-27 00:00:00 | 2021-09-05 00:00:00
Spreadsheet: 147691d1332934534-how-to-find-multiple-peaks-in-a-data-set-edited_-vgrf_data
Sheet: Sheet1

time | vGRF
0 | 177.6
0.01 | 23.3
0.015 | -12
0.02 | 26.5
0.025 | -0.2
0.03 | -20.8
0.035 | 8
0.04 | 46.7
0.045 | 91.6
0.05 | 159.5
0.055 | 263.4
0.06 | 360.8
0.065 | 403.4
0.07 | 465.8
0.075 | 608.8
0.08 | 752.8
0.085 | 844.5
0.09 | 915.5
0.095 | 992.3
0.1 | 1061.9
0.105 | 1119.9
0.11 | 1207.2
0.115 | 1321.2
0.12 | 1396
0.125 | 1408.3
0.13 | 1430.6
0.135 | 1525.1
0.14 | 1608.5
0.145 | 1602.4
0.15 | 1590
0.155 | 1633.2
0.16 | 1664.6
0.165 | 1641.6
0.17 | 1613.9
0.175 | 1617.4
0.18 | 1620.2
0.185 | 1581
0.19 | 1501.7
0.195 | 1434.5
0.2 | 1407.6
0.205 | 1369.1
0.21 | 1280.6
0.215 | 1193.5
0.22 | 1150.2
0.225 | 1100.4
0.23 | 997
0.235 | 881.8
0.24 | 806.6
0.245 | 738.5
0.25 | 628.1
0.255 | 503.3
0.26 | 403.8
0.265 | 321.9
0.27 | 244.5
0.275 | 161.8
0.28 | 98
0.285 | 85.7
0.29 | 66
0.295 | 2.3
0.3 | -19.7
0.305 | 23.7
0.31 | 31.7
0.315 | -10.6
0.32 | -9.4
0.325 | 28.9
0.33 | 14.7
0.335 | -27.9
0.34 | -6.4
0.345 | 43.8
0.35 | 25.8
0.355 | -22.5
0.36 | -24.2
0.365 | 0.3
0.37 | 47.5
0.375 | 118.2
0.38 | 176.4
0.385 | 276.3
0.39 | 409.7
0.395 | 469.2
0.4 | 556.3
0.405 | 775.2
0.41 | 954.8
0.415 | 998
0.42 | 1017.4
0.425 | 1086.8
0.43 | 1175.4
0.435 | 1250.5
0.44 | 1342.7
0.445 | 1449.7
0.45 | 1501.6
0.455 | 1497.9
0.46 | 1520
0.465 | 1593.7
0.47 | 1646.6
0.475 | 1638.7
0.48 | 1633.1
0.485 | 1673.6
0.49 | 1689.4
0.495 | 1624.1
0.5 | 1550.7
0.505 | 1528.4
0.51 | 1506.4
0.515 | 1432.3
0.52 | 1333
0.525 | 1264.8
0.53 | 1224.1
0.535 | 1180.8
0.54 | 1125.7
0.545 | 1053.7
0.55 | 973.9
0.555 | 900.6
0.56 | 829.9
0.565 | 746.4
0.57 | 661.3
0.575 | 584.8
0.58 | 490.6
0.585 | 394.8
0.59 | 326.8
0.595 | 251.2
0.6 | 162.4
0.605 | 106.3
0.61 | 80.8
0.615 | 53
0.62 | 20.2
0.625 | 3.9
0.63 | 13.9
0.635 | 22.5
0.64 | 6.2
0.645 | -8.8
0.65 | 0.4
0.655 | 7.3
0.66 | -1.3
0.665 | 4.1
0.67 | 18.5
0.675 | 5.4
0.68 | -22.3
0.685 | -13.4
0.69 | 56.7
0.695 | 153.6
0.7 | 227.8
0.705 | 295.5
0.71 | 382.2
0.715 | 469
0.72 | 587.3
0.725 | 755.3
0.73 | 883.8
0.735 | 928.8
0.74 | 954.4
0.745 | 1016.2
0.75 | 1123.9
0.755 | 1235.4
0.76 | 1287.4
0.765 | 1310.9
0.77 | 1382.3
0.775 | 1474.5
0.78 | 1520.7
0.785 | 1534.2
0.79 | 1566.1
0.795 | 1603.5
0.8 | 1611.4
0.805 | 1610.8
0.81 | 1612.1
0.815 | 1600.2
0.82 | 1582.6
0.825 | 1557.9
0.83 | 1512.8
0.835 | 1470.4
0.84 | 1441.1
0.845 | 1383.2
0.85 | 1305.3
0.855 | 1250.4
0.86 | 1200.1
0.865 | 1128
0.87 | 1047.6
0.875 | 964.1
0.88 | 874.7
0.885 | 785.8
0.89 | 680.8
0.895 | 561.3
0.9 | 459.5
0.905 | 366.2
0.91 | 271.9
0.915 | 207.7
0.92 | 156.2
0.925 | 84.6
0.93 | 33
0.935 | 24.6
0.94 | 22.7
0.945 | 11.2
0.95 | 2.7
0.955 | 2.3
0.96 | 0.9
0.965 | -3
0.97 | 4.9
0.975 | 17.7
0.98 | 13.7
0.985 | -0.4
0.99 | -5.3
0.995 | 0.7
1 | 4.1
1.005 | -5.1
1.01 | 11
1.015 | 97.1
1.02 | 196.2
1.025 | 261.2
1.03 | 364.8
1.035 | 508
1.04 | 630.9
1.045 | 787.5
1.05 | 976.5
1.055 | 1105
1.06 | 1182.9
1.065 | 1263.3
1.07 | 1352.6
1.075 | 1441.6
1.08 | 1509.1
1.085 | 1543.2
1.09 | 1573.1
1.095 | 1628.6
1.1 | 1671.3
1.105 | 1655.4
1.11 | 1634.1
1.115 | 1662.6
1.12 | 1685.5
Spreadsheet: 453956d1459535245-fill-in-areas-between-graphs-filled-graph
Sheet: Sheet1

 |  | First | Second | Third | Fourth
 | 1 | 4 | 1 | 1 | 2
 | 2 | 4 | 5 | 3 | 5
 | 3 | 4 | 2 | 5 | 1
 | 4 | 5 | 2 | 4 | 5
 | 5 | 3 | 3 | 2 | 4
Spreadsheet: 767230d1644343952-splitting-commission-and-revenue-between-two-sales-reps-revenue-example
Sheet: Summary

Inside Reps | ABCPass Product | ABCPass Plus Product | Tolls Only Product | [NAME] | Revenue |  |  |  |  |  | Rate of Commission
[NAME] | 36 | 18 | 0 | 1 |  |  |  |  |  | ABCPass Product | 17.65
Christina Applewood | 9 | 21 | 0 | 0 |  |  |  |  |  | ABCPass Plus Product | 23.15
ABC Doe | 27 | 23 | 3 | 0.5 |  |  |  |  |  | Tolls Only Product | 8.5
[NAME] | 34 | 32 | 0 | 0
[NAME] | 42 | 64 | 2 | 1.5
Outside Reps | ABCPass Product | ABCPass Plus Product | Tolls Only Product | [NAME] | Revenue
[NAME] | 29 | 0 |  | 1
[NAME] | 0 | 22 |  | 0
Ox Gray | 0 | 26 |  | 1.5
Bla bla bla | 0 | 1 |  | 5
Spreadsheet: 100486d1298851748-sumifs-alternative-for-excel-2003-sumproduct-not-working-newkvs
Sheet: Saturday

Weekly [NAME] |  |  |  |  | Saturday
Hour | T/C | TTL | TTTL | Name | Shift Manager
0000 - 0100 | 0 | 0 | #N/A
0100 - 0200 | 0 | 0 | #N/A
0200 - 0300 | 0 | 0 | #N/A
0300 - 0400 | 0 | 0 | #N/A
0400 - 0500 | 0 | 0 | #N/A
0500 - 0600 | 0 | 0 | #N/A
0600 - 0700 | 6 | 56 | 9.333333333333334 |  | [NAME]
0700 - 0800 | 12 | 82 | 6.833333333333333 |  | [NAME]
0800 - 0900 | 41 | 717 | 17.48780487804878 |  | [NAME]
0900 - 1000 | 74 | 1350 | 18.24324324324324 |  | [NAME]
1000 - 1100 | 68 | 1783 | 26.22058823529412 |  | [NAME]
1100 - 1200 | 48 | 1965 | 40.9375 |  | [NAME]
1200 - 1300 | 90 | 3362 | 37.35555555555555 |  | [NAME]
1300 - 1400 | 88 | 2136 | 24.27272727272727 |  | [NAME]
1400 - 1500 | 69 | 2427 | 35.17391304347826 |  | [NAME]
1500 - 1600 | 60 | 1505 | 25.08333333333333 |  | [NAME]
1600 - 1700 | 47 | 1682 | 35.78723404255319 |  | [NAME]
1700 - 1800 | 53 | 1409 | 26.58490566037736 |  | [NAME]
1800 - 1900 | 41 | 1251 | 30.51219512195122 |  | [NAME]
1900 - 2000 | 24 | 3305 | 137.7083333333333 |  | [NAME]
2000 - 2100 | 14 | 490 | 35 |  | [NAME]
2100 - 2200 | 12 | 187 | 15.58333333333333 |  | [NAME]
2200 - 2300 | 5 | 82 | 16.4 |  | [NAME]
2300 - 0000 | 0 | 0 | #N/A
Spreadsheet: b4a9173d-3d11-40d4-8187-c58c0eaebd80
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CBGC | Test | CBGC | Galactosylceramide Beta-Galactosidase, Leukocytes | [NAME], WBC | Radioisotopic | Yellow-Top (ACD) Tube: ACD |  |  | 7 | mL | [NAME] must arrive within 48 hours of draw to be stabilized. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: Yellow top (ACD solution A) [NAME]: 7 mL  Collection Instructions: Do not transfer blood to other containers. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | 21.5-59.2 mU/g of protein Note: The upper limit of normal may change with the specific activity of the substrate. This is of no consequence since Krabbe patients are below the lower limit. | [NAME] are processed Monday through Sunday. Assay is performed on Wednesday; 8 a.m. | 9 days | 16 days | 1 | 82658 |  |  |  |  | Rochester
CBGC | [NAME] | ACDZ | [NAME] ACD |  |  |  | Refrigerated | 48 hours
CBGC | Result | 8816 | [NAME], WBC | [NAME], WBC | Numeric |  |  |  |  | mU/g Prot |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 689039d1596097192-create-delimeted-list-instead-of-constant-array-book1
Sheet: Sheet1

A | 1
A | 2
A | 85
A | 4
B | 11
B | 9
B | 7
C | 8
C | 20
C | 10
 |  |  |  |  | Drop list 1 | Drop list 2
 |  |  |  |  | C | 4
Spreadsheet: 167739d1342087969-sorting-by-date-problem-0aatext-to-columnscopy-of-book2
Sheet: Sheet1

Row Labels | Sum of Rev
2012-05-02 00:00:00 | 35.97 |  | When I data sort (the attached sample list) by date Excel only accounts for the DD part of the DD/MM/YYYY format. So I get a numerical rather than a date sort. How can I solve that?
2012-05-03 00:00:00 | 11.99
2012-05-04 00:00:00 | 11.99
2012-05-09 00:00:00 | 11.99
2012-05-13 00:00:00 | 11.99
2012-05-22 00:00:00 | 23.98
2012-05-24 00:00:00 | 11.99
2012-05-29 00:00:00 | 23.98
2012-05-30 00:00:00 | 11.99
2012-06-04 00:00:00 | 11.99
2012-06-07 00:00:00 | 11.99
2012-06-12 00:00:00 | 11.99
2012-06-14 00:00:00 | 11.99
2012-06-15 00:00:00 | 11.99
2012-06-16 00:00:00 | 23.98
2012-06-17 00:00:00 | 17.99
2012-06-21 00:00:00 | 11.99
2012-06-23 00:00:00 | 11.99
2012-06-24 00:00:00 | 11.99
2012-06-25 00:00:00 | 2925
2012-06-26 00:00:00 | 2907
2012-06-27 00:00:00 | 3231
2012-06-28 00:00:00 | 3177
2012-06-29 00:00:00 | 4014
2012-06-30 00:00:00 | 3753
2012-07-01 00:00:00 | 2538
2012-07-02 00:00:00 | 3051 |  | Check the date
2012-07-03 00:00:00 | 2664
2012-07-04 00:00:00 | 2763
2012-07-05 00:00:00 | 2205
2012-07-06 00:00:00 | 2653.5
2012-07-07 00:00:00 | 2997
2012-07-08 00:00:00 | 1809
2012-07-09 00:00:00 | 2088
2012-07-10 00:00:00 | 1962
2012-07-11 00:00:00 | 1719
Spreadsheet: benjamin_rogers__1169__Base
Sheet: New Albany

 |  |  |  |  | 12
INCOME STATEMENT - NEW ALBANY
('000 $) |  |  |  | 1999
Revenue
PPA Period:
Demand Payment |  |  |  |  |  |  |  | 0
Energy Payment |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Block Payment |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Market Period:
Demand Payment |  |  |  | 0 | 0 | 0 | 0
Variable Revenue |  |  |  | 0 | 0 | 0 | 0
Energy Margin |  |  |  | 0 | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fuel |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
Insurance
SG&A
Utility Start Up Power
Property, Other Taxes |  |  |  | 0 | 659.8548044302499 | 646.5244043407499 | 633.1940042512499 | 619.86360416175 | 606.5332040722499 | 593.20280398275 | 573.2072038485 | 553.2116037142499 | 533.21600358 | 506.555203401 | 1115.6297748084 | 1038.15548489115 | 945.1863369904497 | 852.2171890897499 | 759.2480411890499 | 635.2891773214499 | 495.8354554704 | 356.3817336193499 | 309.897159669 | 309.897159669 | 0
Debt Service L/C Fee |  |  |  | 0
Marketing Fee |  |  |  | 0 | 0 | 0 | 0
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
New Albany Net Income
CASH FLOW  NEW ALBANY
Investor Interest
('000 $) |  |  |  | 1999
EBITDA
Capital Expenditures |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense) |  |  |  | 0
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
Investor Net Income
Investor [NAME]
Spreadsheet: 127740d1320517399-vlookup-query-vlookup-problem
Sheet: Results

GROUP | POS | SCORE
C | 1
C | 2
C | 3
1 | 1
1 | 2
1 | 3
2 | 1
2 | 2
2 | 3
3 | 1
3 | 2
3 | 3
Spreadsheet: 0193243a-de05-4342-b2ad-24ad3040577a
Sheet: MULTIFAMILY  

 |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  | FEBRUARY 2014 MULTI-FAMILY
APPLICATION TYPE | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT |  | STATUS | YMMDD | SQUARE FOOTAGE | VALUATION | # OF UNITS
 | Street Number | Street Name | Suffix | Quandrant | Unit | Block | Lot | Permit Year | Permit number
 |  |  | NONE | FOR | FEBRUARY | 2014
Spreadsheet: 268002d1380348246-need-to-search-array-and-return-value-along-with-title-and-row-values-book2-as-an-example
Sheet: Sheet1

 | 2013-09-09 00:00:00 | 2013-09-10 00:00:00 | 2013-09-11 00:00:00 | 2013-09-12 00:00:00 | 2013-09-13 00:00:00 | 2013-09-14 00:00:00 | 2013-09-15 00:00:00 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Midnight - 2:00 | 12.20689655172414 |  | 7.741935483870968 | 16.60869565217391 | 10.17241379310345 | 7.708333333333333 | 11.45454545454546
0.08333333333333333 | 10.3448275862069 |  | 8.6 | 16.03333333333333 | 8.68 | 5.826086956521739 | 11 |  | I need the corresponding date and time for each
0.166666666666667 | 11 |  | 8.92 | 13.95833333333333 | 8.766666666666667 | 7.3
0.25 | 10.03571428571429 |  | 9.344827586206897 | 15.14814814814815 | 8.068965517241379 | 7.033333333333333 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
0.333333333333333 | 15.18181818181818 | 11 | 16.57142857142857 | 19.44 | 13.15384615384615 | 12.4 | 10.73333333333333
0.416666666666667 | 20.53846153846154 | 18.69230769230769 | 23.38461538461538 | 23.48387096774194 | 20.2 | 13.78571428571429 | 12.14705882352941 |  | I need the corresponding date and time for each
0.5 | 19.46428571428572 | 15.54838709677419 | 28.8 | 25.14285714285714 | 19.26923076923077 | 12.28571428571429 | 8.703703703703704
0.583333333333333 | 15.38888888888889 | 15.55555555555556 | 30.8 | 24.53846153846154 | 20.55555555555556 | 11.33333333333333 | 6.285714285714286
0.666666666666667 | 13.8 | 16.92 | 26.76923076923077 | 8.666666666666666 | 14.46428571428571 | 9.724137931034482 | 7.714285714285714
0.75 | 12 | 13.5 | 19.18518518518519 | 12.86111111111111 | 11.06896551724138 | 8.08 | 15.17857142857143
0.833333333333333 | 11.46153846153846 | 12.09090909090909 | 20.34615384615385 | 13.93333333333333 | 15.28 | 10.11538461538461 | 9.9375
0.916666666666667 | 12 | 8.75 | 20.80769230769231 | 11.69444444444444 | 14.5 | 12.18181818181818 | 8.923076923076923