tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e07e580d-306f-4df8-b76b-755d0e9cb446
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. ACC, BCIS, ECO,  BUSI, FIN) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. ACC, BCIS, ECO,  BUSI, FIN) | PSY
Discipline codes:  ACC = 5203,  BCIS = 5212,  ECO = 4506,  FIN = 5208,   FIN w/ FIN Plan or REAL = 5215       LAW = 2200              (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for ECO2300, 2301, 2302 = 0800 or  Honors = 0801 Local Code for BCIS1305 = 0200 or  Honors = 0201              (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 544026d1508738812-number-of-days-calculation-excel-report-enhancement-need-help-testing
Sheet: Sample

Monthly Income & Expense
 | Days to get cash | Days of the month | Income & Expense |  |  |  |  | CASH EARNED
 |  |  | Income | Expense | Net |  | 2016-12-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-08-31 00:00:00 | 2017-09-30 00:00:00 | 2017-10-31 00:00:00 | 2017-11-30 00:00:00 | 2017-12-31 00:00:00
Syncreon
2016-11-30 00:00:00 | 48 | 30 | 1471221.97 | 1434441.18
2016-12-31 00:00:00 | 48 | 31 | 1438819.66 | 1402849.21
2017-01-31 00:00:00 | 48 | 31 | 951883.2900000002 | 925345.47
2017-02-28 00:00:00 | 48 | 28 | 1061543.22 | 1059056.64
2017-03-31 00:00:00 | 34 | 31 | 1523495.9 | 1485408.59
2017-04-30 00:00:00 | 34 | 30 | 1015251.68 | 989870.47
2017-05-31 00:00:00 | 34 | 31 | 1295982.14 | 1263582.640000001
2017-06-30 00:00:00 | 50 | 30 | 1365457.27 | 1331320.88
2017-07-31 00:00:00 | 50 | 31 | 1191806.82 | 1162011.66
2017-08-31 00:00:00 | 50 | 31 | 1452857.51 | 1416536.12
2017-09-30 00:00:00 | 51 | 30 | 1711547.05 | 1668758.46
ACC RECEIVABLE / CONSIGNED ASSETS
BPD - HW & SU |  |  | [NAME] | REVENUE | MARGIN
Syncreon
Assets Bought Back - Margin Deferred
BPD - HW
Syncreon
Spreadsheet: 680935d1591268695-count-unique-non-blank-cells-with-criteria-book1
Sheet: Sheet1

Organization Name | Transaction Type Name | Trans Reference
[NAME] | Miscellaneous issue |  |  |  | [NAME]
[NAME] | Miscellaneous issue | RM02 - 0354056 |  |  | Miscellaneous issue
[NAME] | Miscellaneous issue | RM02 - 0354056 |  |  | ???
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous receipt | RM02 - 0354056
[NAME] | Miscellaneous receipt | RM02 - 0354056
[NAME] | Miscellaneous receipt | RM02 - 0354204
[NAME] | Miscellaneous receipt | RM02 - 0354204
WM1 WASTE MANAGEMENT | Miscellaneous issue | WM 13405 MARK LAWLOR
WM1 WASTE MANAGEMENT | Miscellaneous issue | WM 13405 MARK LAWLOR
WM1 WASTE MANAGEMENT | Miscellaneous issue | WM 13405 MARK LAWLOR
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue | 36
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue | 36
[NAME] | Miscellaneous issue | 36
HM1 HOUSING AND COMMUNITY | Miscellaneous issue | 23051
Spreadsheet: 851081d1701336124-time-formatting-help-time-formatting-help
Sheet: Sheet1

[NAME] Campaign | Type | Activity Type | Brand | Send List | Date | Week | Day of Week | Time
Campaign 1 |  |  |  |  | 2021-09-29 18:08:00 |  |  | 2021-09-29 18:08:00
Campaign 2 |  |  |  |  | 2021-10-01 00:04:00 |  |  | 2021-10-01 00:04:00
Campaign 3 |  |  |  |  | 2021-10-01 08:08:00 |  |  | 2021-10-01 08:08:00
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: da

[NAME]. Martyn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 137912d1327428684-how-to-find-the-smaller-number-in-the-list-smallest-time
Sheet: Sheet1

S.No | Name | Scores
1 | a | 00:25:40.490000
2 | b | 00:32:10.406000
3 | c | 00:35:11.253000
4 | d | 00:35:55.662000
5 | e | NA
6 | f | 00:41:30.680000
7 | c | 00:47:36.709000
8 | d | Na
9 | e | 00:38:28.926000
10 | f | 00:31:50.259000
11 | a | 00:26:12.216000
Spreadsheet: 728395d1618428148-how-to-get-specific-return-value-with-multiple-criteria-raider
Sheet: Month code

Code | Description
1 | January
2 | February
3 | March
4 | April
5 | May
6 | June
7 | July
8 | August
9 | September
10 | October
11 | November
12 | December
Spreadsheet: 839984d1692344359-sum-product-with-merged-cells-sumproduct-merged-cell
Sheet: Expected Result

 | [NAME] |  |  | McDonaldtrut Ellie |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Myerstrut [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Okpevbatrut Victor |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  |  |  | Norristrut Robert |  |  | [NAME] |  |  | Mairtrut Ruairidh |  |  | [NAME] |  |  | [NAME]
 | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time
Total Days
Days X Rate
 | =SUMPRODUCT(('Brist Combined'!G13:CI13="Booked")*(IF('Brist Combined'!G12<>0, G2, INDEX('Brist Combined'!$G$12:$CI$12, [NAME], 0)))),'Brist Combined'!G167:CI167*SUMIF('Billing Rate'!A:A,'Brist Combined'!$G$12:$CI$12,'Billing Rate'!D:D))
Spreadsheet: 453842d1459470449-how-to-rank-based-on-2-columns-rank-the-speed
Sheet: Sheet1

PLAYER | DURATION | CYCLE | RANK |  | DURATION | CYCLE | RANK
[NAME] | 00:44:59 | 1 | 6 |  | 00:44:59 | 1 |  |  | =COUNTIF($G$2:$G$9,">"&G2)+SUMPRODUCT(--($G$2:$G$9=G2),--($F$2:$F$9<F2))+1
[NAME] | 01:24:02 | 2 | 2 |  | 01:24:02 | 2
[NAME] | 00:56:59 | 1 | 8 |  | 00:56:59 | 1
[NAME] | 02:00:09 | 2 | 5 |  | 02:00:09 | 2
[NAME] | 00:45:06 | 1 | 7 |  | 00:45:06 | 1
Rico |  | 0 |  |  | 01:46:07 | 2
Seven | 01:46:07 | 2 | 4 |  | 02:25:12 | 3
[NAME] |  | 0 |  |  | 01:32:56 | 2
[NAME] |  | 0
Rolly |  | 0
Bong |  | 0
[NAME] |  | 0
April | 02:25:12 | 3 | 1
Eli |  | 0
Emma |  | 0
[NAME] |  | 0
[NAME] |  | 0
[NAME] |  | 0
[NAME] |  | 0
Venus | 01:32:56 | 2 | 3
Spreadsheet: 70865d1271610165-voedselgenerator-voedselgenerator-help-
Sheet: invoer

invoer aantal personen en het avondeten |  |  |  |  |  |  |  |  | aant pers.
aantal [NAME] | 20
aantal [NAME] | 0
[NAME] | dag 1 | dag 2 | dag 3 | dag 4 | dag 5 | dag 6 |  | totaal |  | ochtend
ochtend |  | 20 | 20 | 20 | 20 |  |  |  |  | middag
middag | 20 | 20 | 20 | 20 | 20 |  |  |  |  | avond
avond | 20 | 20 | 20 | 20 |  |  |  |  |  | late avond
late avond | 20 | 20 | 20 | 20 |  |  |  |  |  | overig
[NAME] | dag 1 | dag 2 | dag 3 | dag 4 | dag 5 | dag 6
ochtend
middag
avond
late avond
 |  |  |  |  |  |  |  |  |  | overig
avondeten | geen avondmaal | macaroni | stamppot boerenkool | rijst met [NAME] | geen avondmaal | geen avondmaal | .
[NAME] | 2010-05-21 00:00:00 | 2010-05-22 00:00:00 | 2010-05-23 00:00:00 | 2010-05-24 00:00:00 | 2010-05-25 00:00:00
geen avondmaal
Spreadsheet: 101042d1299193391-excel-2007-revenue-recognition-projections-revenue-projections
Sheet: Sheet2

Fixed Dates |  | For all of these, if the original date field is text, it's converted to date with the "datevalue" funtion.  If it's blank, or is already in acceptable date formatting, the value is simply copied to this cell.
NBC UNIVERSAL |  |  | National Client Service |  | Client Vertical | New | White, [NAME] | Solutions - BTA: Pharma Fusion |  |  |  |  |  |  |  |  | 3-Proposal delivered / In consideration | 12/31/2010
Spreadsheet: 763915d1642452956-sum-cells-with-text-and-numbers-samplevendors
Sheet: SUMMARY

 | [NAME] | EVV App Functionality | Waterfall Billing | POS Transactions | eMAR Functionality | UI/UX Score | 837i Ability | Scheduling Functionality | App Functionality | Cost | Score X/40
 | Vendor A | 1. Very Limited | 3. Basic | 0. None | 3. Basic | 1. Very Limited | 4. Acceptable | 2. Limited | 0. None
 | Vendor B | 2. Limited | 4. Acceptable | 4. Acceptable | 4. Acceptable | 5. Exemplary | 4. Acceptable | 5. Exemplary | 4. Acceptable
 | Vendor C | 3. Basic | 1. Very Limited | 0. None | 4. Acceptable | 3. Basic | 0. None | 4. Acceptable | 3. Basic
 | Vendor D | 2. Limited | 2. Limited | 0. None | 0. None | 5. Exemplary | 3. Basic | 5. Exemplary | 5. Exemplary
 | Vendor E | 5. Exemplary | 4. Acceptable | 4. Acceptable | 5. Exemplary | 3. Basic | 4. Acceptable | 4. Acceptable | 5. Exemplary
 | Vendor G | 4. Acceptable | 3. Basic | 3. Basic | 3. Basic | 3. Basic | 4. Acceptable | 1. Very Limited | 4. Acceptable
 | Vendor H | 5. Exemplary | 2. Limited | 1. Very Limited | 5. Exemplary | 4. Acceptable | 4. Acceptable | 3. Basic | 5. Exemplary
Spreadsheet: 58394d1258643582-find-closest-value-in-a-range-sample-workbook
Sheet: Sheet1

 |  |  | Equipment Cost | Payment Values
250 | Payment Amount |  | 5000 | 234.2
 |  |  | 7500 | 351.3
 | Equipment Cost |  | 10000 | 468.4
 |  |  | 15000 | 691.05
 |  |  | 16000 | 737.12
 |  |  | 17000 | 783.19
 |  |  | 18000 | 829.26
 |  |  | 19000 | 875.33
 |  |  | 20000 | 921.4
 |  |  | 21000 | 967.47
 |  |  | 22000 | 1013.54
 |  |  | 23000 | 1059.61
 |  |  | 24000 | 1105.68
 |  |  | 25000 | 1151.75
Spreadsheet: 153538d1335957702-rolling-over-man-hours-into-next-month-page-tab-complete-ps-2012
Sheet: Feb 2012

2012-02-01 00:00:00
Date Submitted | Job No | Site | Customer | Project Engineer / Manager | Scope of work | Min People | Actual People | Budget Hours | Actual Hours | Field of work | Start Date | Finish Date | Comments / Additional Information | Special Tools |  |  | Match
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Man Hours | Available Hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mechanical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Mechanical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Supervisor
Spreadsheet: 801016d1666029285-need-to-add-match-mode-of-positive-1-to-xlookup-rows-and-columns-formula-find-nearest-match
Sheet: Sheet2

 |  | WEIGHT
 |  | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400
 | Customer 1 | 10.91 | 17.204 | 35.29199999999999 | 37.094 | 46.3675 | 55.64100000000001 | 60.21399999999999 | 74.188
 | Customer 2 | 13.12 | 22.304 | 33.456 | 41.984 | 52.48 | 62.976 | 73.472 | 83.968
 | Customer 3 | 12.84 | 23.528 | 27.8205 | 43.00999999999999 | 58.82 | 70.58399999999999 | 82.348 | 94.112
 | Customer 4 | 11.12 | 18.547 | 25.806 | 34.40799999999999 | 47.056 | 51.61199999999999 | 64.9145 | 68.81599999999999
 | Customer | Weight | COST | S/be
 | Customer 1 | 200
 | Customer 2 | 275 |  |  | (Consignments up to 250kg)
 | Customer 3 | 150
 | Customer 4 | 25 |  |  | (Consignments up to 50kg)
Spreadsheet: 3bdd9f97-dfe8-4e94-a8b3-71aae9b5df49
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
FZIP | Test | FZIP | Ziprasidone (Geodone, [NAME]) | Ziprasidone | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Plain, Red-Top Tube: Red OR Sodium Heparin: NaHp OR |  |  | 2 | mL | Submit only 1 of the following specimens   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.    Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Units:	ng/mL  Expected plasma concentrations in patients taking Recommended Daily Dosages: 	Up to 220 ng/mL  Test Performed by:	Medtox Laboratories, Inc. 			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FZIP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FZIP | Result | Z2232 | Ziprasidone | Ziprasidone | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 720864d1614336173-extract-entire-row-when-condition-is-met-and-create-a-funnel-between-the-tabs-example-1-
Sheet: To Analyse

Internal ID | City | Region | Analysed?
 | GVA | GE | yes
245-04 | GVZ | FR | yes
245-05 | ZRC | ZH | no
246-07 | AGH | TG | yes
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 313116 | 325830
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 310005 | 321026 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 387828 | 403451
500293 | 159897 | 204311
500302 | 3730
500303 | 69937 | 110745
500305 | 347815 | 449866
500307 | 21714 | 21103
500313 |  | 1003
500314
500655 | 250161
500657 | 70481 | 60000
INDEX
2001-05-31 00:00:00 |  |  | 151158.36
2001-06-10 00:00:00
Spreadsheet: 884609d1733840235-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: User8

Main | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received
Order Date | 2024-11-19 00:00:00
 | Socket | 10mm 1/2" | 7.2 | Y
 | Socket | 13mm 1/2" | 7.16 | Y
Total
Spreadsheet: 888654d1739222071-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 13

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 6.8
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 1 Aug Glucose mmol/L
 |  |  |  |  | 6.9
Wed 2 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 7.2
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 3 Aug Glucose mmol/L
 |  |  |  |  | 6.9
Fri 4 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 5.9 | 8.1
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 5 Aug Glucose mmol/L
 |  |  |  |  | 6.8 7.5
Sun 6 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.3
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 7 Aug Glucose mmol/L
 |  |  |  |  |  | 6.2
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Tue 8 Aug Glucose mmol/L
Spreadsheet: 98176d1297198834-average-using-results-of-sumproduct-copy-of-outbound-2
Sheet: SUMMARY

REPORT DATE RANGE | 2011-02-14 00:00:00 | 2011-02-28 00:00:00
COMPANY
DATE RANGE |  | 0.9500000000000001 | 0.5900000000000001 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.12 | 0.13 | 0.14
YEAR TO DATE |  | 0.3166666666666667 | 0.1966666666666667 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.12 | 0.13 | 0.14
AVERAGE |  | 0.3166666666666667 | 0.1966666666666667 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.12 | 0.13 | 0.14
Spreadsheet: 552847d1513799375-make-text-white-depending-on-another-cell-white-text
Sheet: Data

 | MH Rings | Drain Dia | Count | Yes / No | Spoil | B & S | Backfill | Pipe Material | Gully | Raising pieces
 | 900 | 0.1 | 1 | Yes | On Site | Stone | [NAME] | Plastic | 0.6 | 0.15
 | 1050 | 0.11 | 2 | No | Off Site | Concrete | Stone | Clay | 0.75 | 0.225
 | 1200 | 0.15 | 3 |  |  |  |  | Concrete | 0.9 | 0.3
 | 1350 | 0.16 | 4 |  |  |  |  | Aquaspira
 | 1500 | 0.225 | 5
 | 1800 | 0.3 | 6
 | 2100 | 0.375 | 7
 | 2400 | 0.45 | 8
 | 2700 | 0.525 | 9
 | 3000 | 0.6
 |  | 0.75
 |  | 0.9
 |  | 1.05
 |  | 1.2
 |  | 1.35
 |  | 1.5
 |  | 1.8
 |  | 2.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | put bedding size dependant on pipe size
Spreadsheet: 805204d1668588813-horizontal-middle-data-sequencing-horizontal-sequencing-example
Sheet: Sheet1

 | 01.02.21.01 | 01.02.22.01 | 01.02.23.01 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.02 | 01.02.22.02 | 01.02.23.02 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.03 | 01.02.22.03 | 01.02.23.03 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.04 | 01.02.22.04 | 01.02.23.04 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.05 | 01.02.22.05 | 01.02.23.05 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.06 | 01.02.22.06 | 01.02.23.06 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.07 | 01.02.22.07 | 01.02.23.07 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.08 | 01.02.22.08 | 01.02.23.08 | 24 | 25 | 26 | 27 | 28 | 29
 | I have a numbering convention that needs to be adhered to and i am able to perform the sequencing vertically since its the last two digits that need to change vertically, but allowing the 3rd set of digits within the cell to sequence horizontally without changing the last set of digits doesn't seem to work for me. The example data is as follows:
 |  |  |  |  |  | G'day,
 |  |  |  |  |  | 01.01.01.01  01.01.02.01  01.01.03.01
 |  |  |  |  |  | 01.01.01.02  01.01.02.03  01.01.03.02
 |  |  |  |  |  | 01.01.01.03  01.01.02.03  01.01.03.03
 |  |  |  |  |  | When I autofill vertically its fine but it wont let me begin the first cell in the row to sequence horizontally.
 |  |  |  |  |  | Any insight or solutions are greatly appreciated.
Spreadsheet: 39386d1237547441-producing-automatic-reports-with-2-variables-sample
Sheet: Coupon Recording

 | Today |  |  | 2009-03-20 11:09:07
 | Marketing Conversion Cummulative YTD
 |  |  |  |  | Outcome
 | Source Code | Coupon |  | Outcome 1 |  | Outcome 2 |  | Outcome 3 |  | Outcome 4 |  | Outcome 5 |  | Outcome 6 |  | Outcome 7 |  | Outcome 8 |  | Outcome 9 |  | Outcome 10
 |  | % | No | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | %
Spreadsheet: 39198d1237392947-finding-expected-values-seed
Sheet: Sheet1

Method 1
Probability | 0.3
Seed per sample | Probability of no plant | Number of expected plant
2 | 0.4899999999999999 | 0.51
2 | 0.4899999999999999 | 0.51
2 | 0.4899999999999999 | 0.51
2 | 0.4899999999999999 | 0.51
2 | 0.4899999999999999 | 0.51
3 | 0.3429999999999999 | 0.657
3 | 0.3429999999999999 | 0.657
3 | 0.3429999999999999 | 0.657
3 | 0.3429999999999999 | 0.657
3 | 0.3429999999999999 | 0.657
 | Total | 5.835
Method 2
Probability | 0.3
Seed per sample | Probability of no plant | Number of expected plant
2
2
2
2
2
3
3
3
3
3
5.835000000000001
Spreadsheet: 59689d1260276407-can-a-formula-only-occupy-certain-cells-based-on-criteria-example
Sheet: 2009

Region | Area | Venue | Course | Date | Name | Emp No. | CC | Store Name | Duration | Employee Position
 | midlands |  | Induction |  | [NAME] bloggs | 11111 |  | Birmingham
 | midlands |  | Induction 2 |  | [NAME] bloggs | 11111 |  | Birmingham
 | midlands |  | H & S |  | [NAME] bloggs | 11111 |  | Birmingham
 | midlands |  | Cleaning |  | [NAME] bloggs | 11111 |  | Birmingham
 | midlands |  | Induction |  | [NAME] | 12345 |  | Birmingham
 | midlands |  | Induction 2 |  | [NAME] | 12345 |  | Birmingham