tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838890d1691496318-average-based-on-part-number-if-statement-ls-test
Sheet: 005210A

[NAME] along Keystone Road from East Lake Road to the Hillsborough County Line - REBID PID NO. 005210A BID NO. 23-0494-ITB-CP
 |  |  |  | Engineer Estimate |  |  | [NAME] |  | % Difference from Engineer's Estimate
Pay Item No. | Description | Quantity | Unit | UnitPrice | Amount |  | UnitPrice | Amount
General [NAME]
700-1-50 | SINGLE POST SIGN, RELOCATE | 5 | AS | 225 |  |  | 100
104-18 | INLET PROTECTION SYSTEM | 6 | EA | 500 |  |  | 500
536-7-2 | SPECIAL GUARDRAIL POST - SPECIAL STEEL POST FOR CONCRETE STRUCTURE MOUNT | 4 | EA | 225 |  |  | 250
536-85-20 | [NAME] | 24 | EA | 2500 |  |  | 2500
536-85-24 | [NAME] | 30 | EA | 4500 |  |  | 4500
711-11-160 | THERMOPLASTIC, STD, WHITE, MESSAGE | 2 | EA | 400 |  |  | 500
711-11-170 | THERMOPLASTIC, STD, WHITE, ARROW | 1 | EA | 250 |  |  | 350
104-10-3 | SEDIMENT BARRIER | 12970 | LF | 3.5 |  |  | 3
536-1-1 | [NAME], GENERAL TL-3 | 12775 | LF | 35 |  |  | 35
536-6 | PIPE RAIL FOR GUARDRAIL | 9925 | LF | 25 |  |  | 20
711-11-124 | THERMOPLASTIC, STD, WHITE, SOLID, 18" | 8 | LF | 25 |  |  | 50
711-15-101 | THERMOPLASTIC, STD-OP, WHITE, SOLID, 6" | 420 | LF | 3.5 |  |  | 5
800-1615 | IRRIGATION (SPRINKLER) REPAIR OR REPLACE, Including Fittings, Heads, and Related Appurtenances | 100 | LF | 25 |  |  | 30
005-0701 | Survey and Layout | 1 | LS | 5000 |  |  | 40000
101-0100 | MOBILIZATION | 1 | LS | 150000 |  |  | 175000
102-1000 | [NAME] | 1 | LS | 100000 |  |  | 100000
104-10 | PREVENTION, CONTROL AND ABATEMENT OF EROSION AND WATER POLLUTION | 1 | LS | 20000 |  |  | 10000
110-0100 | CLEARING & GRUBBING | 1 | LS | 75000 |  |  | 100000
120-1100 | GRADING | 1 | LS | 100000 |  |  | 100000
527-2 | [NAME] | 29 | SF | 30 |  |  | 20
327-70-5 | MILLING EXIST ASPH PAVT, 2" AVG DEPTH | 194 | SY | 40 |  |  | 45
575-0103 | SODDING, [NAME] | 2587 | SY | 10 |  |  | 5
102-5000 | WATER, for Dust Control | 30 | THG | 150 |  |  | 200
334-1-13 | SUPERPAVE ASPHALT CONC, TRAFFIC C, 2" DEPTH | 21 | TN | 500 |  |  | 700
339-1 | [NAME] PAVEMENT | 685 | TN | 325 |  |  | 360
 | General Roadway Total
Unspecified Work
999-0000 | UNSPECIFIED WORK | 175000 | EA | 1 |  |  | 1
 | Unspecified Work Total
 |  | TOTAL BID
Spreadsheet: 192703d1352497781-right-aligning-cells-to-a-specific-column-right-align
Sheet: Sheet1

Starting Left-Aligned Data
1 | 33 | 55 | 77 | 86 | 49 | 53 | 4 | 2 | 7
14 | 5 | 6 | 9 | 45 | 62
12 | 44 | 51 | 2 | 6 | 8 | 9
1 | 12 | 15 | 5
4 | 6 | 9
Desired Right-Aligned Result
1 | 33 | 55 | 77 | 86 | 49 | 53 | 4 | 2 | 7
 |  |  |  | 14 | 5 | 6 | 9 | 45 | 62
 |  |  | 12 | 44 | 51 | 2 | 6 | 8 | 9
 |  |  |  |  |  | 1 | 12 | 15 | 5
 |  |  |  |  |  |  | 4 | 6 | 9
Spreadsheet: 680027d1590750144-calculation-time-between-start-and-end-time-28_2
Sheet: 28

Order number | Start date | End date
12 | 5/27/2020 4:09:28 PM | 5/27/2020 4:13:22 PM
13 | 5/27/2020 4:21:57 PM | 5/27/2020 4:33:46 PM
14 | 5/27/2020 4:51:13 PM | 5/27/2020 4:55:21 PM
15 | 5/27/2020 6:12:03 PM | 5/27/2020 6:16:59 PM
16 | 5/27/2020 6:23:41 PM | 5/27/2020 6:26:27 PM
17 | 5/27/2020 6:52:25 PM | 5/27/2020 6:56:23 PM
18 | 5/27/2020 7:23:49 PM | 5/27/2020 8:11:20 PM
19 | 5/27/2020 7:13:11 PM | 5/27/2020 8:26:25 PM
20 | 5/27/2020 8:26:50 PM | 5/27/2020 8:29:43 PM
21 | 5/27/2020 8:29:43 PM | 5/27/2020 8:30:59 PM
22 | 5/27/2020 8:24:03 PM | 5/27/2020 8:36:50 PM
23 | 5/27/2020 8:17:39 PM | 5/27/2020 8:40:57 PM
24 | 5/27/2020 8:39:37 PM | 5/28/2020 6:24:24 AM
26 | 5/28/2020 6:31:18 AM | 5/28/2020 6:44:34 AM
27 | 5/28/2020 6:54:50 AM | 5/28/2020 7:18:59 AM
28 | 5/28/2020 7:18:59 AM | 5/28/2020 7:27:29 AM
29 | 5/28/2020 7:41:17 AM | 5/28/2020 7:45:43 AM
30 | 5/28/2020 8:10:04 AM | 5/28/2020 8:12:15 AM
31 | 5/28/2020 8:18:37 AM | 5/28/2020 8:21:51 AM
32 | 5/28/2020 8:49:25 AM | 5/28/2020 9:40:29 AM
33 | 5/28/2020 9:47:41 AM | 5/28/2020 9:56:19 AM
34 | 5/28/2020 9:56:19 AM | 5/28/2020 10:11:37 AM
35 | 5/28/2020 10:24:57 AM | 5/28/2020 10:29:36 AM
36 | 5/28/2020 10:32:10 AM | 5/28/2020 10:38:33 AM
37 | 5/28/2020 11:07:50 AM | 5/28/2020 11:14:26 AM
38 | 5/28/2020 11:34:53 AM | 5/28/2020 11:47:56 AM
39 | 5/28/2020 11:57:47 AM | 5/28/2020 12:01:48 PM
40 | 5/28/2020 12:41:04 PM | 5/28/2020 12:43:36 PM
41 | 5/28/2020 12:59:54 PM | 5/28/2020 1:04:20 PM
42 | 5/28/2020 1:07:51 PM | 5/28/2020 1:10:04 PM
43 | 5/28/2020 2:07:35 PM | 5/28/2020 2:23:22 PM
44 | 5/28/2020 2:30:54 PM | 5/28/2020 2:34:37 PM
45 | 5/28/2020 2:53:16 PM | 5/28/2020 3:04:42 PM
46 | 5/28/2020 4:19:55 PM | 5/28/2020 4:23:47 PM
Spreadsheet: 214703d1361063356-return-a-cell-value-in-a-date-range-break-book1
Sheet: Sheet1

Start | End | First no break date | Text
2012-08-01 00:00:00 | 2012-08-14 00:00:00
2012-08-15 00:00:00 | 2012-08-30 00:00:00
2012-09-20 00:00:00 | 2012-10-03 00:00:00
2012-10-04 00:00:00 | 2012-10-15 00:00:00
2012-10-16 00:00:00 | 2012-10-20 00:00:00
2012-10-22 00:00:00 | 2012-10-30 00:00:00
2012-11-01 00:00:00 | 2012-11-30 00:00:00
Spreadsheet: 15e58ae2-9f0d-4453-a526-7d3e98f1d40c
Sheet: Sheet1

1996 - 40th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Warstein/Sauerland, Germany |  |  |  |  | 1996-09-28 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | GER | Eimers | Wilhelm | Landsmann | Bernd | D-OCOL Columbus II | Petrosani/Rumania | 1286.9 | 1900-01-03 00:01:00
2 | USA | [NAME] | [NAME] | Brielmann | [NAME] | N1636S Spirit of Sprinfield | [NAME] | 1087.3 | 1900-01-02 06:18:00
3 | AUT | Fürstner | [NAME] | Stürzlinger | [NAME] | D-OBFA Ballonfabrik Augsburg | [NAME] | 1004.3 | 1900-01-01 17:19:00
4 | SUI | Imstepf | [NAME] | [NAME] | Kurt | HB-BZH  Stadt Will | [NAME] | 1002.8 | 1900-01-01 10:46:00
5 | SUI | Stoll | Christian | Najer | [NAME] | D-OCFT | [NAME] | 1000.5 | 1900-01-01 15:44:00
6 | SUI | Fröhlin | Hansjörg | Vollenweider | Walter | HB-BTE  [NAME] | Harmashatr Hegy Hungaria | 879.6 | 1900-01-01 17:36:00
7 | AUT | Starkbaum | [NAME] | Starkbaum | Roland | OE-PZS Polarstern | Zarovice Czech Republik | 687.2 | 22:47:00
8 | GER | Höhl | [NAME] | [NAME] | Dr. [NAME] | D-OWML | Zarovice Czech Republik | 645.9 | 21:03:00
9 | POL | Makne | [NAME] | [NAME] |  | SP-BZO Polonez | Zarow/Poland | 567.7 | 16:32:00
10 | NET | [NAME] | Rien | Houten | [NAME] | PH-KTS Festo | Ostritz/Germany | 459.4 | 16:07:00
11 | USA | Abruzzo | [NAME] | [NAME] | [NAME] | G-BWOK | Hirschfelde Germany | 456.8 | 14:03:00
12 | GER | [NAME] | Heinz | Hutmacher | [NAME] | D-Columbus II | [NAME] | 449.5 | 13:33:00
13 | USA | Bradley | Troy | Bradley | Tamara | D-OLAF | Jestribi Czech Republik | 446.1 | 13:33:00
14 | AUT | Wagner | [NAME] | Lewetz | [NAME] | OE-ZZI | Torgau/Germany | 324.2 | 10:35:00
Spreadsheet: 855050d1704773034-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker
Sheet: Sep

 |  |  |  |  |  | CALENDAR MONTH | SEPTEMBER
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 219928d1363015223-if-or-hlookup-formula-sample
Sheet: February 13

 | Reciept |  |  | Deliveries |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beginning Imb: |  |  | Beginning Storage Balance: | 0
Day | Nomination | Reciepts | (-)Long/ (+)Short | Nomination | Burn | (+)Long/(-)Short | Nomination | Burn | (+)Long/(-)Short | Nomination | Burn | (+)Long/(-)Short | Nomination | Burn | (+)Long/(-)Short | Total Nomination | Total Burn | [NAME] (-)Long/ (+)Short | TOTAL Daily Imbalance (+)Long/(-)Short | TOTAL Accumulated Imbalance (+)Long/(-)Short | Storage (-) inj/ (+)wth on OGS | Storage Nom on OGS (+) inj/(-)wth | Storage Balance
2013-02-01 00:00:00
2013-02-02 00:00:00
2013-02-03 00:00:00
2013-02-04 00:00:00
2013-02-05 00:00:00
2013-02-06 00:00:00
2013-02-07 00:00:00
2013-02-08 00:00:00
2013-02-09 00:00:00
2013-02-10 00:00:00
2013-02-11 00:00:00
2013-02-12 00:00:00
2013-02-13 00:00:00
2013-02-14 00:00:00
2013-02-15 00:00:00
2013-02-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3282
2013-02-17 00:00:00
2013-02-18 00:00:00
2013-02-19 00:00:00
2013-02-20 00:00:00
2013-02-21 00:00:00
2013-02-22 00:00:00
2013-02-23 00:00:00
2013-02-24 00:00:00
2013-02-25 00:00:00
2013-02-26 00:00:00
2013-02-27 00:00:00
2013-02-28 00:00:00
TOTALS
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 025PC

[NAME]
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO ASSISTED | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-08-31 00:00:00 |  |  | JAD | 2010-06-08 00:00:00 |  |  | CJY |  | 2010-10-28 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 786349d1657122294-1-for-unique-value-0-for-non-unique-based-on-row-p-filtered-on-row-i-unique-filtered-per-id
Sheet: Sheet1

 |  |  |  |  |  |  |  | ID |  | NAME |  | UNIQUE (Desired result)
 |  |  |  |  |  |  |  | 1 |  | A |  | 1
 |  |  |  |  |  |  |  | 1 |  | B |  | 1
 |  |  |  |  |  |  |  | 1 |  | C |  | 1
 |  |  |  |  |  |  |  | 2 |  | A |  | 1
 |  |  |  |  |  |  |  | 2 |  | B |  | 1
 |  |  |  |  |  |  |  | 2 |  | C |  | 1
 |  |  |  |  |  |  |  | 3 |  | A |  | 1
 |  |  |  |  |  |  |  | 3 |  | A |  | 0
 |  |  |  |  |  |  |  | 3 |  | B |  | 1
 |  |  |  |  |  |  |  | 3 |  | B |  | 0
 |  |  |  |  |  |  |  | 3 |  | B |  | 0
 |  |  |  |  |  |  |  | 3 |  | C |  | 1
 |  |  |  |  |  |  |  | 3 |  | C |  | 0
 |  |  |  |  |  |  |  | 3 |  | C |  | 0
 |  |  |  |  |  |  |  | 4 |  | A |  | 1
 |  |  |  |  |  |  |  | 4 |  | B |  | 1
 |  |  |  |  |  |  |  | 4 |  | C |  | 1
Spreadsheet: 2573d61a-c1af-4e4f-9840-7bfe6c31255f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Managed Futures Strategy HV Fund
 | Monthly Performance History
 | Inception Date | 2013-07-16 00:00:00
 |  | Class N | Class I | Newedge CTA | ML 3-Month T-bill Index
 | Date | QMHNX | QMHIX | Trend Sub-Index | Index
* | 2013-07-31 00:00:00 | 0.0009999999999998899 | 0.0009999999999998899 | -0.005578512396694268 | -7.254167156300895e-06
 | 2013-08-31 00:00:00 | -0.005994005994006013 | -0.004995004995004937 | -0.02528049287250034 | 4.787785054571891e-05
 | 2013-09-30 00:00:00 | -0.0261306533 | -0.0261044177 | -0.005949981232535761 | 4.788e-05
 | 2013-10-31 00:00:00 | 0.0144478844 | 0.0144329897 | 0.02548539729156563 | -3.77183e-05
 | 2013-11-30 00:00:00 | 0.05595116988809767 | 0.05589430894308944 | 0.02702039257757405 | 5.948115027853973e-05
 | 2013-12-31 00:00:00 | 0.04081745 | 0.040778132 | 0.006462292963183014 | 0.00013056
 | 2014-01-31 00:00:00 | -0.04819277108433739 | -0.04814814814814816 | -0.0444574424107026 | 0.00013056
 | 2014-02-28 00:00:00 | -0.01850048685492 | -0.01750972762646 | 0.005771434620323479 | 5.8015493e-06
 | 2014-03-31 00:00:00 | -0.02876984127 | -0.029702970297 | -0.02496213351881393 | 4.2061e-05
 | * partial month return, inception date [NAME]
 | Managed Futures Strategy HV Fund
 | [NAME]
 | Month-end Returns as of | Class N | Class I | Newedge CTA | ML 3-Month T-bill Index
 | March 31, 2014 | QMHNX | QMHIX | Trend Sub-Index | Index
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.01975831856301002 | -0.01875823190475689 | -0.0429572403880697 | 0.0003554580634446136
 | Since Inception Annualized Return
 | Since Inception Annualized Monthly Volatility | 0.1174181009467191 | 0.1173899730332694 | 0.08278254209100472 | 0.0001682114565676338
 | Quarter-end Returns as of | Class N | Class I | Newedge CTA | ML 3-Month T-bill Index
 | March 31, 2014 | QMHNX | QMHIX | Trend Sub-Index | Index
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.01975831856301002 | -0.01875823190475689 | -0.0429572403880697 | 0.0003554580634446136
 | Since Inception Annualized Return
Spreadsheet: 110731d1307365472-automatically-moving-data-between-cells-sheets-in-excel-nbss-operations-subgroup-tasks
Sheet: IT

IT - Tasks
ID | Date Logged | Raised By | Work Stream | Issue | Action taken | Date Signed off | Current status | Notes
18 |  |  | Operations | Undertake baseline service assessment to include: |  |  | Logged
18 |  |  | Operations | Current screening provision within Wales |  |  | Logged
18 |  |  | Operations | assessment of existing laboratory services |  |  | Logged
18 |  |  | Operations | existing information provision for parents |  |  | Logged
18 |  |  | Operations | existing result provision for parents |  |  | Logged
18 |  |  | Operations | Undertake baseline service assessment to include: |  |  | Logged
18 |  |  | Operations | Current screening provision within Wales |  |  | Logged
18 |  |  | Operations | assessment of existing laboratory services |  |  | Logged
18 |  |  | Operations | existing information provision for parents |  |  | Logged
18 |  |  | Operations | existing result provision for parents |  |  | Logged
18 |  |  | Operations | existing failsafe arrangements for samples and results |  |  | Logged
18 |  |  | Operations | existing referral protocols and pathways for babies who have an abnormal result |  |  | Logged
22 |  |  | Operations | Undertake options appraisal for establishment of [NAME] administration |  |  | Logged
23 |  |  | Operations | Undertake options appraisal for IT infrastructure |  |  | Logged
24 |  |  | Operations | Draft specifications for IT system |  |  | Logged
25 |  |  | Operations | Undertake options appraisal for QA infrastructure |  |  | Logged
26 |  |  | Operations | Establish outline pathways for programme |  |  | Logged
27 |  |  | Operations | Develop training plan for midwives and health visitors |  |  | Logged
30 |  |  | Operations | Develop operational plan for introduction of MCADD and Sickle Cell testing |  |  | Logged
31 |  |  | Operations | Undertake equipment specification, appraisal and evaluation |  |  | Logged
36 |  |  | Finance | Develop costed implementation Strategy which takes account of existing activity |  |  | Logged
37 |  |  | Education | Recruit and train programme staff. |  |  | Logged
Spreadsheet: 1444de95-b44c-4a95-a2f3-1b712b45603f
Sheet: Sheet1

Table S1. General frequency of serotypes by years of surveillance. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Serotypes | Years of surveillance |  |  | Total
 | 2005-2006 | 2007-2008 | 2009-2010
 | n= 573 | n=593 | [NAME] | n=1775
 | n (%)
14 | 135(23.6) | 164 (27.7) | 111(18.2) | 410(23.1)
1 | 76(13.3) | 63(10.6) | 77(12.6) | 216(12.2)
6B | 38(6.6) | 43(7.3) | 43(7.1) | 124(7.0)
3 | 27(4.7) | 26(4.4) | 44(7.2) | 97(5.5)
23F | 36(6.3) | 25(4.2) | 25(4.1) | 86(4.8)
19F | 32(5.6) | 27(4.6) | 24(3.9) | 83(4.7)
6A | 25(4.4) | 21(3.5) | 26(4.3) | 72(4.1)
5 | 29(5.1) | 24(4.0) | 9(1.5) | 62(3.5)
19A | 9(1.6) | 17(2.9) | 30(4.9) | 56(3.2)
18C | 11(1.9) | 17(2.9) | 20(3.3) | 48(2.7)
9V | 23(4.0) | 9(1.5) | 16(2.6) | 48(2.7)
7F | 9(1.6) | 12(2.0) | 14(2.3) | 35(2.0)
12F | 2(0.3) | 17(2.9) | 15(2.5) | 34(1.9)
4 | 8(1.4) | 12(2.0) | 13(2.1) | 33(1.9)
16F | 11(1.9) | 7(1.2) | 11(1.8) | 29(1.6)
18A | 10(1.7) | 10(1.7) | 6(1.0) | 26(1.5)
8 | 8(1.4) | 7(1.2) | 10(1.6) | 25(1.4)
9N | 3(0.5) | 7(1.2) | 9(1.5) | 19(1.1)
6C | 6(1.0) | 5(0.8) | 7(1.1) | 18(1.0)
15A | 2(0.3) | 10(1.7) | 6(1.0) | 18(1.0)
10A | 6(1.0) | 7(1.2) | 5(0.8) | 18(1.0)
11A | 5(0.9) | 6(1.0) | 7(1.1) | 18(1.0)
13 | 9(1.6) | 2(0.3) | 6(1.0) | 17(1.0)
34 | 8(1.4) | 2(0.3) | 6(1.0) | 16(0.9)
35B | 5(0.9) | 7(1.2) | 4(0.7) | 16(0.9)
22F | 2(0.3) | 5(0.8) | 7(1.1) | 14(0.8)
23A | 4(0.7) | 3(0.5) | 7(1.1) | 14(0.8)
15C | 4(0.7) | 4(0.7) | 4(0.7) | 12(0.7)
24F | 2(0.3) | 7(1.2) | 3(0.5) | 12(0.7)
15B | 5(0.9) | 3(0.5) | 3(0.5) | 11(0.6)
17F | 2(0.3) | 2(0.3) | 6(1.0) | 10(0.6)
18F | 3(0.5) | 4(0.7) | 3(0.5) | 10(0.6)
23B | 5(0.9) | 0(0.0) | 4(0.7) | 9(0.5)
25A | 2(0.3) | 3(0.5) | 4(0.7) | 9(0.5)
28A | 2(0.3) | 1(0.2) | 4(0.7) | 7(0.4)
20 | 1(0.2) | 3(0.5) | 1(0.2) | 5(0.3)
25F | 3(0.5) | 0(0.0) | 2(0.3) | 5(0.3)
19B | 2(0.3) | 1(0.2) | 1(0.2) | 4(0.2)
35F | 0(0.0) | 3(0.5) | 1(0.2) | 4(0.2)
7C | 0(0.0) | 0(0.0) | 3(0.5) | 3(0.2)
12B | 1(0.0) | 1(0.2) | 1(0.2) | 3(0.2)
33F | 0(0.0) | 0(0.0) | 2(0.3) | 2(0.1)
11F | 0(0.0) | 0(0.0) | 2(0.3) | 2(0.1)
18B | 0(0.0) | 2(0.3) | 0(0.0) | 2(0.1)
NST | 0(0.0) | 1(0.2) | 1(0.2) | 2(0.1)
9L | 0(0.0) | 0(0.0) | 1(0.2) | 1(0.1)
10B | 0(0.0) | 0(0.0) | 1(0.2) | 1(0.1)
35A | 0(0.0) | 1(0.2) | 0(0.0) | 1(0.1)
10F | 0(0.0) | 0(0.0) | 1(0.2) | 1(0.1)
9C | 0(0.0) | 0(0.0) | 1(0.2) | 1(0.1)
35C | 0(0.0) | 0(0.0) | 1(0.2) | 1(0.1)
33 | 1(0.2) | 0(0.0) | 0(0.0) | 1(0.1)
7A | 0(0.0) | 1(0.2) | 0(0.0) | 1(0.1)
15F | 0(0.0) | 0(0.0) | 1(0.2) | 1(0.1)
16A | 1(0.2) | 0(0.0) | 0(0.0) | 1(0.1)
31 | 0(0.0) | 1(0.2) | 0(0.0) | 1(0.1)
Spreadsheet: 30092d1225389765-multiple-rows-make-a-single-order-and-pivot-table-sales3
Sheet: Order Source

Order ID | Order Source |  | Order source | Explanation
237160 | 1 |  | 1 | Online
264693 | 1 |  | 2 | Fax
269762 | 1 |  | 3 | e-mail
270110 | 1 |  | 4 | phone
278622 | 1 |  | 5 | post
278625 | 1 |  | 6 | Other
278930 | 1
279611 | 1
280623 | 4
280862 | 2
281457 | 3
282397 | 1
Spreadsheet: 167394d1341978157-comparing-rows-book1
Sheet: Sheet1

1 | 10 | 1 |  | 1 | 10 | 1
1 | 19 | 55 |  | 1 | 10 | 4
1 | 19 | 56 |  | 1 | 16 | 407
1 | 34 |  |  | 1 | 16 | 408
1 | 121 |  |  | 1 | 19 | 53
1 | 122 |  |  | 1 | 34 | 45
1 | 163 |  |  | 1 | 35 | 46
1 | 289 | 502 |  | 1 | 35 | 48
1 | 345 | 3964 |  | 1 | 35 | 180
1 | 345 | 3965 |  | 1 | 35 | 203
1 | 345 | 3966 |  | 1 | 35 | 481
1 | 346 | 3972 |  | 1 | 37 | 107
1 | 346 | 3973 |  | 1 | 121 | 581
1 | 348 | 140 |  | 1 | 121 | 582
1 | 349 | 139 |  | 1 | 121 | 583
1 | 349 | 141 |  | 1 | 121 | 584
1 | 349 | 141 |  | 1 | 121 | 585
1 | 349 | 160 |  | 1 | 121 | 586
1 | 350 | 1022 |  | 1 | 121 | 587
Spreadsheet: 159681d1338815223-sum-if-based-on-multiple-criteria-sample
Sheet: Wk 2

Client Id | Signings
1511914 | 70000
1533574 | 1000000
1168242 | 10000000
1333836 | 4000000
1623591 | 10000500
1100271 | -1000
P0050AB | -1000000
1438230 | -10000000
1045970 | -4000000
1473461 | -10000500
1234567 | 900000
2345678 | 25000
3456789 | 6000000
4567890 | 3500600
Spreadsheet: 832568d1686440965-how-to-split-cells-into-columns-and-fill-down-help0611
Sheet: Sheet1

A,B,C,D | 10 |  | A | 10
E,F | 20 |  | B | 10
G | 30 |  | C | 10
 |  |  | D | 10
 |  |  | E | 20
 |  |  | F | 20
 |  |  | G | 30
X
X
X
X
X
X
X
X
1
2
3
3
4
5
6
7
8
9
9
10
10
11
11
12
13
13
14
15
15
16
17
17
17
18
18
19
20
21
21
22
22
23
23
23
23
23
23
24
25
25
26
26
26
26
26
27
27
27
27
27
27
28
28
28
28
29
29
29
29
29
29
29
29
30
30
31
31
32
32
32
32
32
33
33
33
33
33
34
34
34
34
34
34
34
35
35
35
35
35
36
37
37
37
37
37
37
37
37
38
39
39
39
39
39
39
40
40
40
40
40
40
40
40
41
42
42
42
42
42
42
42
42
42
42
43
43
43
44
44
44
44
44
44
44
45
45
46
46
46
46
46
47
47
48
48
48
48
49
49
49
49
49
50
50
50
50
51
51
51
52
52
52
52
52
52
53
54
54
54
54
54
55
55
55
55
56
56
56
56
56
56
57
57
57
58
59
59
59
59
60
60
61
61
61
62
63
63
63
63
63
64
64
Spreadsheet: 455766d1460484516-i-need-to-look-up-a-part-number-and-date-on-my-data-sheet-and-return-values-into-a-table-liver
Sheet: Data

 |  |  |  | Min | [NAME] | On Hand
123456 | M71 | Location | 2016-04-11 05:34:00 | 7 | 9 | 69
113440 | M71 | Location | 2016-04-11 05:34:00 | 75 | 100 | 67
114991 | M71 | Location | 2016-04-11 05:34:00 | 321 | 428 | 408
114992 | M71 | Location | 2016-04-11 05:34:00 | 86 | 114 | 154
115727 | M71 | Location | 2016-04-11 05:34:00 | 25 | 35 | 5
116841 | M71 | Location | 2016-04-11 05:34:00 | 0 | 0 | 2
117395 | M71 | Location | 2016-04-11 05:34:00 | 173 | 231 | 82
117399 | M71 | Location | 2016-04-11 05:34:00 | 35 | 47 | 39
121301 | M71 | Location | 2016-04-11 05:34:00 | 113 | 150 | 364
123841 | M71 | Location | 2016-04-11 05:34:00 | 9 | 12 | 2
126384 | M71 | Location | 2016-04-11 05:34:00 | 0 | 0 | 0
123456 | M71 | Location | 2016-04-12 00:00:00 | 7 | 9 | 69
113440 | M71 | Location | 2016-04-12 00:00:00 | 75 | 100 | 67
114991 | M71 | Location | 2016-04-12 00:00:00 | 321 | 428 | 408
114992 | M71 | Location | 2016-04-12 00:00:00 | 86 | 114 | 154
115727 | M71 | Location | 2016-04-12 00:00:00 | 25 | 35 | 5
116841 | M71 | Location | 2016-04-12 00:00:00 | 0 | 0 | 2
117395 | M71 | Location | 2016-04-12 00:00:00 | 173 | 231 | 82
117399 | M71 | Location | 2016-04-12 00:00:00 | 35 | 47 | 39
121301 | M71 | Location | 2016-04-12 00:00:00 | 113 | 150 | 364
123841 | M71 | Location | 2016-04-12 00:00:00 | 9 | 12 | 2
126384 | M71 | Location | 2016-04-12 00:00:00 | 0 | 0 | 0
Spreadsheet: 672791d1587005494-fetch-data-for-todays-date-daily-report-example
Sheet: Summary

STORE | COR | HBO | BEAV | TAY | BPT | EUG | [NAME] | CAM | WIL | SAL | DK | GG | TOTAL
MANAGER
BUDGETED SALES PER DAY %
BUDGETED SALES PER DAY
[NAME]
[NAME]
LY ONLINE SALES PER DAY
LY DELIVERY SALES PER DAY
LY NET SALES PER DAY
CATERING SALES
CATERING AS % GROSS SALES
CATERING SALES Y-Y
ONLINE SALES
ONLINE SALES AS % GROSS SALES
ONLINE SALES Y-Y
DELIVERY SALES
DELIVERY SALES AS A % GROSS SALES
DELIVERY SALES Y-Y
TOTAL GROSS STORE SALES
GROSS SALES Y-Y
GROSS SALES VARIANCE TO BUDGET
PROMO $
PROMO %
VOIDS
NET TOTAL $
Spreadsheet: 164278d1340718745-transposing-across-multiple-worksheets-startend
Sheet: MIDDLE

2000000
3000000
4000000
5000000
6000000
7000000
8000000
9000000
10000000
11000000
12000000
13000000
14000000
15000000
16000000
17000000
18000000
19000000
20000000
21000000
Spreadsheet: 135553d1326121093-generate-value-given-two-different-variables-in-weird-chart-price-generation-sample
Sheet: Sheet3

 | Style | [NAME] | Description | Color | Size | Price
 | 2000L | Gildan | Ladies' Ultra Cotton T-Shirt | Neutrals | S-XL | 3.23
 |  |  |  | Heathers | S-XL | 2.89
 |  |  |  | Colors | S-XL | 4.67
 | 2000 | Gildan | [NAME] | Neutrals | S-XL | 3
 |  |  |  | Heathers | S-XL | 2
 |  |  |  | Colors | S-XL | 4
 |  | Style: | (Manually Entered)
 |  | Color: | (Manually Entered)
 |  | Price: | (Automatically Generated)
Spreadsheet: 475316d1471271867-need-a-formula-for-conditional-text-to-display-in-a-task-planner-a1ksingh
Sheet: Sheet1

Micro Status | Tasks | Final Status | Comments
Complete | Task 1 |  | Need a Formula if status of All Cells is "Complete" than [NAME], If [NAME] in any of the Tasks Shows "Overdue" regardless what else is there, If all Cell value is " Not started " show Not Started
Complete | Task 1
Complete | Task 1
Overdue | Task 2 |  | Overdue ruled every thing else
In progress | Task 2
In progress | Task 2
In progress | Task 2
Not started | Task 2
Not started | Task 3 |  | not all completed so show "in Progress" , if [NAME] value is there here it will show as [NAME]
Complete | Task 3
Complete | Task 3
Complete | Task 3
Complete | Task 3
Complete | Task 3
Overdue | Task 4 |  | Value from [NAME] will Come as Overdue
In progress | Task 4
Complete | Task 4
In progress | Task 4
Not started | Task 5 |  | All Not Started so " Not Started" If all In progress it will show " In Progress
Not started | Task 5
Not started | Task 5
Not started | Task 5