tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729745d1619301165-help-with-countif-formula-for-calendar-countif-any-date-in-table-present-schedule-workbook-stat-holiday-help
Sheet: LOCKED

START
END
Current Date
Month | Year |  | Holiday | Description | Date
January | 2018 |  | New Years Day | 2021-01-01 00:00:00
February | 2019 |  | Family Day | 3rd Monday in Feb
March | 2020 |  | Good Friday | 2 days before Easter Sunday
April | 2021 |  | Easter Sunday | Something to do with Moons
May | 2022 |  | [NAME] | Last Monday before May 25
June | 2023 |  | Canada Day | 2021-07-01 00:00:00
July | 2024 |  | Saskatchewan Day | 1st Monday in Aug
August | 2025 |  | Labour Day | 1st Monday in Sept
September | 2026 |  | Thanksgiving Day | 2nd Monday in Oct
October | 2027 |  | Remberance Day | 2021-11-11 00:00:00
November | 2028 |  | Christmas Day | 2021-12-25 00:00:00
December | 2029 |  | Boxing Day | 2021-12-26 00:00:00
 | 2030
 | 2031
 | 2032
 | 2033
 | 2034
 | 2035
 | 2036 |  | NUMBERS  FORMULA | IF(COLUMNS($B2:B2)>DAY(LOCKED!$B$4),"",LOCKED!$B$3+COLUMNS($B2:B2)-1)
 | 2037 |  | WEEKDAY FORMULA | IF(COLUMNS($B17:B17)>DAY(LOCKED!$B$4),"",LOCKED!$B$3+COLUMNS($B17:B17)-1)
 | 2038 |  | Conditional Formatting | OR(COUNTIF(B$3:B$15,1)<>2,COUNTIF(B$3:B$15,2)<>2)
 | 2039 |  | Count only weekends worked | IF(C8="","",SUMPRODUCT((Schedule!$A$5:$A$32=STATS!$A8)*((TEXT(Schedule!$B$4:$AE$4,"ddd")="Sat")+(TEXT(Schedule!$B$4:$AE$4,"ddd")="Sun"))*(Schedule!$B$5:$AE$32>=1)*(MOD(ROW($A$5:$A$32),2)=1)))
 | 2040
 | 2041
 | 2042
 | 2043
 | 2044
 | 2045
 | 2046
 | 2047
 | 2048
 | 2049
 | 2050
Spreadsheet: 85573d1285667184-vlookup-formatting-error-book1
Sheet: Sheet1

1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
5 | 5 | 6 | 7 | 8 | 9 | 4 | 7 | 3 | 8 | 0 | 3 | 7 | 8 | 0 | 3 | 5 | 7 | 9 | 5 | 3 | 7 | 3 | 7 | 3 | 8 | 3 | 7 | 3
1998
10
2009-2010 | 2011-2014
6 | 2
1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
0.5 | 0.3 | 0.6 | 0.7 | 0.8 | 0.5 | 0.3 | 0.6 | 0.7 | 0.8 | 0.5 | 0.3 | 0.6 | 0.7 | 0.8 | 0.5 | 0.3 | 0.6 | 0.7 | 0.8 | 0.6 | 0.7 | 0.8 | 1 | 1 | 1 | 1 | 1 | 1
1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
150 | 90 | 180 | 210 | 240 | 150 | 90 | 180 | 210 | 240 | 150 | 90 | 180 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 850825d1701175175-to-pull-out-data-in-excel-on-the-basis-of-conditions-sample-sheet-1-
Sheet: Result Sheet

 | 2023-04-25 00:00:00
 | A/C TITLE | A/C NUMBER | AMOUNT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
Spreadsheet: b060f0dd-290b-43d2-bb34-6649bce3c3e7
Sheet: Sheet1

spt4d / IA: Differential Expression Gene List | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
* fold change (logMut - logwt) > 0
Rank | Name | ID | q-value | Median FC (log2) | Description
1 | [NAME] | YFL039C | 0 | 1.18* | [NAME], involved in cell polarization, endocytosis, and other cytoskeletal functions.
2 | ASC1 | YMR116C | 0 | 1.57* | Abundant protein with effects on translational efficiency and cell size, has two WD (WD-40) repeats.
3 | ECM33 | YBR078W | 0 | 1.49* | Protein with predicted GPI-anchor, involved in cell wall structure or biosynthesis.
4 | RPL22B | YFL034C-A | 0 | 1.14* | [YPD] Ribosomal protein [NAME] (YL31)
5 | PCH2 | YBR186W | 0 | -1 | Protein required for cell cycle arrest at the pachytene stage of meiosis in a zip1 mutant, has similarity to Rpt5p and NSF vesicular fusion protein and other members of the AAA family of ATPases
6 | YNL194c | [NAME] | 0 | 1.52*
7 | RPS14A | YCR031C | 0 | 1.04* | Ribosomal protein S14A involved in crytopleurine resistance; (rp59) (E. coli S11) (rat and human S14).
8 | YDR367w | YDR367W | 0 | 1.27* | Protein of unknown function.
9 | UBC8 | YEL012W | 0 | -0.93 | Ubiquitin-conjugating enzyme that is able to ubiquitinate histones in vitro.
10 | RPL22A | YLR061W | 0 | 1.17* | Ribosomal protein L22A.
11 | YOL048c | YOL048c | 0 | -1.03
12 | RPS25A | [NAME] | 0 | 0.9* | Ribosomal protein [NAME] (yeast [NAME]) (YS23) (rp45) (rat S25).
13 | RPL27B | YDR471W | 0 | 0.83* | Ribosomal protein L27B (yeast L27) (mammalian L27).
14 | RPS11A | [NAME] | 0 | 1.08* | Ribosomal protein S11A; (yeast S18) (YS12) (rp41) (E. coli S17) (human and rat S11).
Spreadsheet: 465480d1465686439-excel-solver-lp-help-golf-fantasy
Sheet: Sheet2

Bond | Annual Return | Maturity | Risk | Tax-Free
A | 0.095 | 0 | 1 | 1
B | 0.08 | 1 | 0 | 1
C | 0.09 | 0 | 0 | 0
D | 0.09 | 0 | 1 | 1
E | 0.09 | 1 | 1 | 0
Totals | 0.445 | 2 | 3 | 3
Decision Variables
x1 | amount to invest in bond A
x2 | amount to invest in bond B
[NAME] | amount to invest in bond C
x4 | amount to invest in bond D
x5 | amount to invest in bond E
Objective | Total
maximize total annual return
Constraints
 | total investment = 100k
 | at least 50% in short term
 | No more than 50% in high risk
 | at least 30% in tax free
 | at least 40% of annual return should be tax free
 | nonnegativity
Spreadsheet: 3256bb5e-67b2-4135-8bfa-182a4777103c
Sheet: Option 2

Cycle Menu Template for Grades 9-12
(Include serving sizes and component contribrtions daily for each menu item)
Daily Menus | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 |  |  |  |  |  |  |  |  |  |  | Weekly Total
Daily Total | Serving Size | Component Contribution* | Serving Size | Component Contribution | Serving Size | Component Contribution | Serving Size | Component Contribution | Serving Size | Component Contribution | Total Component Contribution for week
Meat/Meat Alternates (oz) (minimum 2 oz./day)
Grains (minimum 2 oz./day)
Vegetables (cups)  (minimum 1 cup/day)
dark green  (½ c minimum)
red/orange  (1 ¼ c minimum)
beans/legumes  ([NAME] c minimum)
starchy  ([NAME] c minimum)
other  (¾ c minimum)
additional  (1 ½ c minimum)
Fruit (1 cup minimum/day)
Milk (1 cup; offer variety)
* Component contribution should represent the Food Buying Guide and/or the Child Nutrition (CN) labels or manufacturer's signed specificiation
 |  | 4-day School Week | Grades 9-12 |  | 5-day Week | Grades 9-12
 |  | Fruit | 4 cups |  | Fruit | 5 cups
 |  | Vegetables | 4 cups |  | Vegetables | 5 cups
 |  | Grains | 8 - 9.5 |  | Grains | 10 - 12
 | Meat/Meat Alternates |  | 8 - 9.5 | Meat/Meat Alternates |  | 10 - 12
 |  | Milk (cups) | 4 |  | Milk (cups) | 5
Spreadsheet: 475627d1471380704-how-to-add-value-from-new-inserted-row-and-also-add-the-new-row-count-to-an-average-goonbah
Sheet: Gantt Chart

 | Project Planner
 |  |  |  |  |  |  |  | Period Highlight: |  |  |  |  | 1 |  |  |  | Plan |  |  | Actual |  |  |  | % Complete |  |  |  |  | Actual (beyond plan) |  |  |  |  |  |  |  | % Complete (beyond plan)
 |  | PLAN | PLAN | ACTUAL | ACTUAL | PERCENT
 | ACTIVITY | START | DURATION | START | DURATION | [NAME]
 |  |  |  |  |  |  |  |  | 2016-08-19 00:00:00 | 2016-08-22 00:00:00 | 2016-08-26 00:00:00 | 2016-08-29 00:00:00 | 2016-09-02 00:00:00 | 2016-09-05 00:00:00 | 2016-09-09 00:00:00 | 2016-09-12 00:00:00 | 2016-09-16 00:00:00 | 2016-09-19 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
 | VF Organization & Management Model (Federated) (MSF)
 | Complete IT Plan, Budget and Vendor Strategy/Selections (Phases 1 and 2) (HF)
 | Accounting/Finance Operations and Controls (Phase 1) (CF)
 | Establish Inventory Management Functions (??)
 | Client Services (Phases 1 and 2) (HF)
 | Establish HR Functions & Policies
 | Legal Matters (MSF)
 | Practice Reviews
Spreadsheet: 786644d1657317365-named-range-brings-an-error-when-used-in-a-chart-customer-trend-analysis-draft-3a-
Sheet: LIST

 | Total Estimates |  | Overall Totals
 | Converted Estimates |  | Accent Lighting, Inc
 | Win-Rate
 | Win-Rate Over 10K
 | Win-Rate Under 10K
 | Amount $ Quoted
 | Amount $ Won
 | Percent $ Won
 | Average Quote Amount
 | Average Amount Won
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: Savings

 | Navy Fed-Andrew |  |  |  | Navy Fed-Megan |  |  |  | USAA |  |  |  | Chase |  |  |  | Total Savings
 | Month | Incoming | Outgoing |  | Month | Incoming | Outgoing |  | Month | Incoming | Outgoing |  | Month | Incoming | Outgoing
 | January |  |  |  | January |  |  |  | January |  |  |  | January
 | February |  |  |  | February |  |  |  | February |  |  |  | February
 | March |  |  |  | March |  |  |  | March |  |  |  | March
 | April |  |  |  | April |  |  |  | April |  |  |  | April
 | May |  |  |  | May |  |  |  | May |  |  |  | May
 | June |  |  |  | June |  |  |  | June |  |  |  | June
 | July |  |  |  | July |  |  |  | July |  |  |  | July
 | August |  |  |  | August |  |  |  | August |  |  |  | August
 | September |  |  |  | September |  |  |  | September |  |  |  | September
 | October |  |  |  | October |  |  |  | October |  |  |  | October
 | November |  |  |  | November |  |  |  | November |  |  |  | November
 | December |  |  |  | December |  |  |  | December |  |  |  | December
 | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | Prior Year |  |  |  | Prior Year |  |  |  | Prior Year |  |  |  | Prior Year
Spreadsheet: 219365d1362737169-match-multiple-criteria-then-select-the-smallest-value-the-lookup-value-multimatchlookupsampledata
Sheet: Sheet1

IsPro? | Price Schedule | Tier | Break Even Txns
Basic | ERP1 | 1000000 | 10000000
Basic | ERP1 | 750000 | 854062.5
Basic | ERP1 | 500000 | 588500
Basic | ERP1 | 300000 | 387538.4615384615
Basic | ERP1 | 144000 | 226343.75
Basic | ERP1 | 96000 | 116086.2068965517
Basic | ERP1 | 48000 | 63657.89473684211
Basic | ERP1 | 24000 | 35428.57142857143
Basic | ERP1 | 14400 | 19187.23404255319
Basic | ERP1 | 7200 | 12755.55555555555
Basic | ERP1 | 3300 | 5607.058823529412
Basic | ERP1 | 1440 | 2461.978021978022
Basic | ERP1 | 720 | 1056.842105263158
Pro | ERP1 | 1000000 | 10000000
Pro | ERP1 | 750000 | 835769.2307692308
Pro | ERP1 | 500000 | 570000
Pro | ERP1 | 300000 | 355434.7826086957
Pro | ERP1 | 144000 | 181364.8648648649
Pro | ERP1 | 96000 | 115860
Pro | ERP1 | 48000 | 67957.62711864407
Pro | ERP1 | 24000 | 33444.44444444445
Pro | ERP1 | 14400 | 19634.375
Pro | ERP1 | 7200 | 12101.96078431373
Pro | ERP1 | 3300 | 5540.853658536585
Pro | ERP1 | 1440 | 2463.529411764706
Pro | ERP1 | 720 | 1114.444444444444
Basic | ERP2 | 1000000 | X
Basic | ERP2 | 750000 | X
Basic | ERP2 | 500000 | X
Basic | ERP2 | 300000 | X
Basic | ERP2 | 144000 | X
Basic | ERP2 | 96000 | X
Basic | ERP2 | 48000 | X
Basic | ERP2 | 24000 | X
Basic | ERP2 | 14400 | X
Basic | ERP2 | 7200 | X
Basic | ERP2 | 3300 | X
Pro | ERP2 | 1000000 | 10000000
Pro | ERP2 | 750000 | 845000
Pro | ERP2 | 500000 | 569473.6842105263
Pro | ERP2 | 300000 | 353695.652173913
Pro | ERP2 | 144000 | 180283.7837837838
Pro | ERP2 | 96000 | 120260
Pro | ERP2 | 48000 | 72533.89830508475
Pro | ERP2 | 24000 | 34666.66666666666
Pro | ERP2 | 14400 | 20988.54166666667
Pro | ERP2 | 7200 | 13572.54901960784
Pro | ERP2 | 3300 | 5906.707317073171
Basic | SDK | 1500000 | 10000000
Basic | SDK | 1000000 | 1067000
Basic | SDK | 750000 | 866071.4285714285
Basic | SDK | 500000 | 616562.5
Basic | SDK | 300000 | 375611.1111111111
Basic | SDK | 144000 | 215000
Basic | SDK | 96000 | 120791.6666666667
Basic | SDK | 48000 | 60500
Basic | SDK | 24000 | 35785.71428571428
Basic | SDK | 14400 | 21573.91304347826
Basic | SDK | 7200 | 12894.44444444445
Basic | SDK | 3300 | 4519.512195121952
Basic | SDK | 1440 | 2440
Basic | SDK | 720 | 1740.689655172414
Basic | SDK | 360 | 559.047619047619
Basic | SDK | 180 | 270.1639344262295
Pro | SDK | 1500000 | 10000000
Pro | SDK | 1000000 | 1187142.857142857
Pro | SDK | 750000 | 843125
Pro | SDK | 500000 | 604772.7272727273
Pro | SDK | 300000 | 363392.8571428572
Pro | SDK | 144000 | 181000
Pro | SDK | 96000 | 111196.4285714286
Pro | SDK | 48000 | 65068.96551724138
Pro | SDK | 24000 | 33516.12903225806
Pro | SDK | 14400 | 22275
Pro | SDK | 7200 | 13137.5
Pro | SDK | 3300 | 5759.677419354839
Pro | SDK | 1440 | 2208.656716417911
Pro | SDK | 720 | 1382.337662337662
Pro | SDK | 360 | 724.516129032258
Pro | SDK | 180 | 380
Lookup Values:
Basic | SDK | 19304
It should return 14400
Spreadsheet: 1d2fe607-2866-435d-b525-d95f7d0c8d38
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
CEAPC | Test | CEAPC | Carcinoembryonic Antigen (CEA), Pancreatic Cyst Fluid | CEA, Pancreatic Cyst | Immunoenzymatic Assay |  |  |  | 1 | mL | Collection Container/Tube: Body fluid container Submission Container/Tube: Plastic vial [NAME]: 1 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm Reject; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; Varies | Same day/1 day | 3 days | 1 | 82378 |  |  |  |  | Rochester
CEAPC | [NAME] | PCF | Pancreatic Cyst Fluid |  |  |  | Frozen | 30 days
CEAPC | Result | CEAP | CEA, Pancreatic Cyst | CEA, Pancreatic Cyst | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 12515-3
CEAPC | Result | SITE6 | Site | Site | Numeric
Spreadsheet: 84341d1284394052-using-multi-conditional-formats-for-a-calendar-index
Sheet: Sheet1

Date | Name | Code | Interval | Min | Comments | Column1
2010-07-08 00:00:00 | [NAME] | V | S | 1
2010-08-24 00:00:00 | [NAME] | Q | S
2010-08-31 00:00:00 | [NAME] | V | L |  | asdfasdfas
2010-09-01 00:00:00 | [NAME] | V | S | 3
2010-09-02 00:00:00 | [NAME] | F | B1 | 2 | kjasdhkjasdhkj
2010-09-06 00:00:00 | [NAME] | V | B3 | 3 | asdfsdf
2010-09-07 00:00:00 | [NAME] | FMLA | B1 | 2
2010-09-07 00:00:00 | [NAME] | V | S | 1 | asdfsd
2010-09-07 00:00:00 | [NAME] | S | B2 | 5
2010-09-08 00:00:00 | [NAME] | V | S | 3
2012-08-08 00:00:00 | [NAME] | V | S |  | asdfsdf
2010-09-09 00:00:00 | [NAME] | S | B2 | 2
2010-09-09 00:00:00 | [NAME] | S | B2 | 2 | asdfasdfas
2010-09-10 00:00:00 | [NAME] | V | S | 1
2010-09-13 00:00:00 | [NAME] | FMLA | S | 1 | asdfsdf
2010-09-14 00:00:00 | [NAME] | V | S
2010-09-18 00:00:00 | [NAME] | V | S |  | asfsdsaf
2010-09-22 00:00:00 | [NAME] | V | S | 1
2010-09-22 00:00:00 | [NAME] | V | S
2010-09-22 00:00:00 | [NAME] | F | S |  | asdfasfsdf
2010-09-23 00:00:00 | [NAME] | V | S | 1
2010-09-23 00:00:00 | [NAME] | V | B2 | 2
2010-09-25 00:00:00 | [NAME] | V | B2 | 3
2010-09-29 00:00:00 | [NAME] | V | B1 | 5
Spreadsheet: 50315d1249676683-how-can-i-get-around-the-dv-drop-down-list-limit-test
Sheet: GAS INFO

Leak Definition | Calibration Gas Concentration | Cylinder # | Shelf Life:
0 GAS: | <1 | 2044829Y | 2009-12-30 00:00:00
500 GAS: | 490 | 1997010Y | 2010-04-04 00:00:00
1,000 GAS: | 993 | 2074000Y | 2010-04-04 00:00:00
2,000 GAS: | 1988 | 2451885Y | 2010-03-24 00:00:00
10,000 GAS: | 9945 | 987257Y | 2009-11-25 00:00:00
0 |  |  | 500 |  |  | 1000 |  |  | 2000 |  |  | 10000
Cylinder # | Concentration | Expiration | Cylinder # | Concentration | Expiration | Cylinder # | Concentration | Expiration | Cylinder # | Concentration | Expiration | Cylinder # | Concentration | Expiration
2044829Y | <1 | 2009-06-27 00:00:00 | 3439417Y | 497 | 2009-12-22 00:00:00 | 3426470Y | 998 | 2011-03-09 00:00:00 | 2451885Y | 1988 | 2010-03-24 00:00:00 | 987257Y | 9945 | 2009-11-25 00:00:00
2044829Y | <1 | 2009-12-30 00:00:00 | 1997010Y | 490 | 2010-04-04 00:00:00 | 2074000Y | 993 | 2010-04-04 00:00:00
Spreadsheet: 751443d1634118581-sum-of-column-b-based-on-column-a-sample-3-
Sheet: Sheet1

01F02 | 1 |  | Criteria
01F05 | 10 |  | 01F02
01F02 | 15 |  | 01F05
01F02 | 2 |  | 01F09
01F02 | 6 |  | 01F03
01F09 | 55 |  | 01F04
01F09 | 5 |  | 01F06
01F09 | 5 |  | 01F08
01F09 | 48 |  | 01F10
01F09 | 86
01F09 | 62
01F09 | 36
01F09 | 45
01F09 | 22
01F09 | 1
01F09 | 1
01F09 | 1
01F09 | 1
01F03 | 1
01F03 | 25
01F03 | 2
01F03 | 2
01F03 | 2
01F03 | 2
01F03 | 2
01F03 | 15
01F03 | 14
01F03 | 14
01F03 | 12
01F04 | 15
01F04 | 1
01F04 | 1
01F04 | 1
01F04 | 1
01F04 | 1
01F04 | 1
01F04 | 6
01F04 | 2
01F04 | 3
01F04 | 4
01F04 | 5
01F04 | 6
01F04 | 8
01F04 | 87
01F04 | 45
01F04 | 87
01F04 | 7
01F06 | 4
01F06 | 1
01F06 | 5
01F06 | 4
01F06 | 25
01F06 | 5
01F06 | 2
01F06 | 2
01F06 | 77
01F06 | 4
01F06 | 8
01F06 | 8
01F06 | 7
01F06 | 7
01F06 | 7
01F08 | 8
01F08 | 8
01F10 | 6
01F10 | 1
Spreadsheet: 484849d1476489234-meal-plan-to-return-fat-protein-etc-mealplanning
Sheet: Weekly Plan

 | Weekly Meal Planner
 | Date | Dish | Side 1 | Side 2 | Protein(g) | Carbs(g) | Fat(g)
 | MON | Soft [NAME] (Half) | Salad |  |  |  |  |  | I'd like the total protein/carb/fat of each dish (from the ingredients section) to be listed here (and on dishes sheeT)
 | TUE | [NAME] |  |  |  |  |  |  | However, I'd also like to be able to add an infinite amount of dishes and ingredients without having to rename lists or change things manually
 | WED | Spaghetti Bolognese |  | Baked Potato
 | THUR | Chicken & Chorizo Jambalaya
 | FRI | Meatballs Macaroni |  | Quinoa
 | SAT | Chicken Provencal | Chips
 | SUN | Mexican [NAME]
Spreadsheet: 07d9c4d8-97e8-4180-a1e5-daaabc7c07e4
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
FFTIN | Test | FFTIN | Tin, Serum | Tin, Serum | Inductively Coupled Plasma/Mass Spectrometry (ICP-MS) | Metal free or acid washed containers: MForAW OR Royal blue-top Monoject trace element blood collection tube: RylBlue OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a metal free tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of metal free serum refrigerated in a plastic vial.   [NAME] blood in an EDTA metal-free royal blue-top tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL metal-free EDTA plasma refrigerated in a plastic vial. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reference Range:  <5.0 ng/mL   Toxic range has not been established.      Note: Whole blood is the preferred specimen for monitoring exposure to tin.   Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc.
FFTIN | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FFTIN | Result | Z1182 | Tin | Tin | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 216663d1361837554-find-percentage-of-times-two-adjacent-cells-have-the-same-data-test-sheet
Sheet: Sheet1

Step one completed | Step two completed | Step threee completed | Step four completed
TBA | TBA | TBA | TBA
TBA | TBA | TBA | TBA
RPL | RPL | RPL | TBA
RPL | RPL | RPL | TBA
TBA | TBA | TBA | TBA
2013 | 2013 | TBA | TBA
RPL | RPL | TBA | TBA
RPL | RPL | RPL | TBA
RPL | RPL | TBA | TBA
RPL | RPL | TBA | TBA
RPL | RPL | RPL | TBA
Spreadsheet: 588246d1535540879-copying-conditional-formatting-in-different-rows-example
Sheet: Sheet1

 | Maths |  |  | English |  |  | Science
 | Written (80) | Viva (20) | Total (100) | Written (80) | Viva (20) | Total (100) | Written (80) | Viva (20) | Total (100)
[NAME] | 75 | 10 |  | 57 | 13 |  | 70 | 17
Broad | 78 | 13 |  | 53 | 19 |  | 62 | 17
[NAME] | 59 | 17 |  | 71 | 18 |  | 55 | 11
Dino | 73 | 14 |  | 50 | 16 |  | 59 | 18
Spreadsheet: 87836d1287693539-populating-data-from-one-table-to-another-excelrequest
Sheet: Sheet1

Table 1: data
category | amount
Dog | 1
Dog | 3
Dog | b
Dog | c
Cat | 1
Cat | 4
Cat | 5
Cat | 6
Cat | a
Cat | b
Man | 1
Man | 2
Man | 3
Man | 4
Man | 5
Man | 6
Girl | a
Girl | c
Girl | b
Potato | 1
Potato | 5
Potato | 6
Potato | a
Potato | b
Table 2: requiring populating
 | 1 | 2 | 3 | 4 | 5 | 6 | a | b | c
Dog
Cat
Man
Girl
Potata
[NAME]
required outcome
 | 1 | 2 | 3 | 4 | 5 | 6 | a | b | c
Dog | yes |  | yes |  |  |  |  | yes | yes
Cat | yes |  |  | yes | yes | yes | yes | yes
Man | yes | yes | yes | yes | yes | yes
Girl | yes | yes | yes
Potata | yes |  |  |  | yes | yes | yes | yes
[NAME]
Spreadsheet: 3c54bed4-3358-49a9-bcd6-8accdbca4656
Sheet: Project Scaling Worksheet

Project Scaling Worksheet       V2
 | Project Complexity
 |  |  | N/A | Low               High
 |  |  |  |  |  |  |  |  |  | Weight
 | Sponsor | One | 0 |  |  |  |  |  | More than 1 | 0.5
 | Project Objectives | Clear | 0 |  |  |  |  |  | Vague | 0.5
 | Business Impact | Minimal | 0 |  |  |  |  |  | Major | 0.5
 | Technical Requirements | Familiar | 0 |  |  |  |  |  | Unfamiliar | 0.5
 | Team Location | One | 0 |  |  |  |  |  | More than 1 | 0.25
 | Deadline | Loose | 0 |  |  |  |  |  | Defined | 0.5
 | Stakeholder Involvement | 2 People | 0 |  |  |  |  |  | More than 20 | 0.5
 | External Dependencies | None | 0 |  |  |  |  |  | Many | 0.25
 | Project Team | Experienced | 0 |  |  |  |  |  | Inexperienced | 0.5
 | Cross-Agency | One | 0 |  |  |  |  |  | Many | 0.25
 | Number of Systems Impacted | One | 0 |  |  |  |  |  | Many | 0.5
 | Organizational Risks | Not Likely | 0 |  |  |  |  |  | Likely | 0.25
 | Project Complexity Score
 | Project Visibility
 |  |  | No |  |  | Yes
 |  |  |  |  |  |  |  |  |  | Weight
 | Legislative Initiative | No | 0 |  |  |  |  |  | Yes | 0.5
 | Governor Initiative | No | 0 |  |  |  |  |  | Yes | 1
 | Federal Mandate | No | 0 |  |  |  |  |  | Yes | 0.7
 | Public Facing | No | 0 |  |  |  |  |  | Yes | 0.7
 | Project Visibility Score
 | Project Duration
 |  |  | < 6 months |  |  |  |  |  | 6 - 12 months | > 12 months
 | Duration of the Project
 | Project Costs
 |  |  | =<250k |  |  |  |  |  | 250k - 1M | > 1M
 | Cost of the Project
 | Project Score
 | Total Calculated Score
 | Level One Project |  | < 50
 | Level Two Project |  | 50 - 74
 | Level Three Project |  | 75 - 100
 |  | Project Complexity Values |  | 0
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  | Project Visibility Values |  | 0
 |  |  |  | 5
 |  | Project Duration |  | 5
 |  |  |  | 10
 |  |  |  | 20
 |  | Project Costs |  | 10
 |  |  |  | 25
 |  |  |  | 40
Spreadsheet: 173728d1344695858-dynaimc-sum-range-sample
Sheet: Data

2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140