tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 850839d1701180156-shading-weekend-cloumns-book1
Sheet: Sheet1

 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00
 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00
MEETING ROOM: 0800-0900
MEETING ROOM: 0900-1000
MEETING ROOM: 1000-1100
MEETING ROOM: 1100-1200
MEETING ROOM: 1200-1300
MEETING ROOM: 1300-1400
MEETING ROOM: 1400-1500
MEETING ROOM: 1500-1600
MEETING ROOM: 1600-1700
Spreadsheet: 59451d1259942007-multiple-criteria-frequency-count-sample_v2009-1204
Sheet: SUMMARY

 | MULT | FREQ | TOTAL 09 | AVG 09 | 0 | 5000 | 5001-20000 | 20001-40000 | 40001-75000 | 75001-125000 | 125001-250000 | 250001 | TOTAL 08 | AVG 08
 | 0 | 12 | 36400 | 3033.333333333333 |  |  | EX:  Need count of all customers who had sales within $5-20K range, who also had mult of 0 |  |  |  |  |  | 6300 | 525
 | 0.355 | 1 | 52000 | 52000 |  |  |  |  |  |  |  |  | 33000 | 33000
 | 0.37 | 1 | 73000 | 73000 |  |  |  |  |  |  |  |  | 90000 | 90000
 | 0.375 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.38 | 17 | 665000 | 39117.64705882353 |  |  | EX:  Need count of all customers who had sales within $5-20K range, who also had mult of 0.380 |  |  |  |  |  | 620000 | 36470.58823529412
 | 0.385 | 1 | 1000 | 1000 |  |  |  |  |  |  |  |  | 1000 | 1000
 | 0.39 | 4 | 97000 | 24250 |  |  |  |  |  |  |  |  | 80000 | 20000
 | 0.395 | 2 | 80000 | 40000 |  |  |  |  |  |  |  |  | 121000 | 60500
 | 0.4 | 9 | 16600 | 1844.444444444444 |  |  |  |  |  |  |  |  | 9900 | 1100
 | 0.405 | 1 | 40000 | 40000 |  |  |  |  |  |  |  |  | 47000 | 47000
 | 0.41 | 3 | 3500 | 1166.666666666667 |  |  |  |  |  |  |  |  | 3500 | 1166.666666666667
 | 0.415 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.42 | 5 | 59000 | 11800 |  |  |  |  |  |  |  |  | 97000 | 19400
 | 0.425 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.43 | 9 | 190000 | 21111.11111111111 |  |  |  |  |  |  |  |  | 194000 | 21555.55555555555
 | 0.435 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.44 | 4 | 2900 | 725 |  |  |  |  |  |  |  |  | 0 | 0
 | 0.445 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.45 | 2 | 800 | 400 |  |  |  |  |  |  |  |  | 100 | 50
 | 0.455 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.46 | 2 | 37000 | 18500 |  |  |  |  |  |  |  |  | 41000 | 20500
 | 0.465 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.47 | 3 | 0 | 0 |  |  |  |  |  |  |  |  | 200 | 66.66666666666667
 | 0.475 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.48 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.485 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.49 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.495 | 0 | 0 | #N/A |  |  |  |  |  |  |  |  | 0 | #N/A
 | 0.5 | 2 | 500 | 250 |  |  |  |  |  |  |  |  | 0 | 0
Greater Than | 0.501 | 9 | Need to sum 09 sales for all items with a mult larger than 0.501 in column A of customers worksheet
Spreadsheet: 681671d1591696457-how-to-base-a-formula-on-data-selected-from-a-drop-down-box-and-linking-to-another-sheet-feeds-test-1-
Sheet: P1

 |  | Based on |  | Feed |  |  | Energy
Age | Date | Weight (kg) | Feed | Volume [NAME] (ml) | Volume del (ml) | Volume del (%) | Energy Req (kcal/kg/d) | Energy Px (kcal/kg) | Vitamin A (µg RE) | Vitamin D (µg) | Vitamin E (mg α-TE) | [NAME] (µg) | [NAME] (mg) | [NAME] (mg) | [NAME] (mg) | [NAME] (mg) | Pantothenic Acid | [NAME] (mg) | Folate (µg) | [NAME] (µg) | [NAME] (µg) | Calcium (mg) | Phosphorus (mg) | Magnesium (mg) | Iron (mg) | Zinc (mg) | Copper (mg) | Manganese (mg) | Selenium (µg) | Iodine (µg) | Molybdenum | Chromium
 | 2020-06-09 00:00:00 |  | Aptamil First 19% | 200 | 196 |  | 95 | 48 | 0.6859
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: bl

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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: 839394d1691927294-lookup-value-from-others-table-to-calculate-and-return-value-eric-test-tomtom1126-
Sheet: Sheet2

INV | PRODUCT | QTY | LOT, Qty |  |  |  |  | Product ID | lot | qty
[NAME] | ABC123 | 9000 |  |  |  |  |  | ABC123 | A | 200000
[NAME] | ABC123 | 90000 |  |  |  |  |  | ABC123 | B | 200000
[NAME] | ABC123 | 35000 |  |  |  |  |  | ABC123 | C | 200000
[NAME] | ABC123 | 30000 |  |  |  |  |  | ABC123 | D | 200000
[NAME] | ABC123 | 15000 |  |  |  |  |  | ABC123 | E | 200000
[NAME] | ABC123 | 24500 |  |  |  |  |  | ABC123 | F | 200000
INV4321 | ABC123 | 65000 |  |  |  |  |  | ABC123 | G | 200000
INV4321 | ABC123 | 154000 |  |  |  |  |  | ABC123 | H | 200000
INV4321 | ABC123 | 160000
INV4321 | ABC123 | 12000
INV2468 | ABC123 | 9000
INV2468 | ABC123 | 8000
INV2468 | ABC123 | 143000
INV2468 | ABC123 | 5000
INV2468 | ABC123 | 6000
Spreadsheet: 742370d1627679258-calculate-the-total-of-two-different-background-colour-figure-cells-in-same-column-test-bvj-1-
Sheet: Example

Agent | Alias | Profile ID | Contact Details | Item | Sold By | Cost | Paid | Received | Review Conditions | Review After | Review text | Review Submitted | Review Published | Refund Conditions | Refund Issued | Refund Received | Refund Email
 |  |  |  |  |  | 6.29 | 5.81 |  |  |  |  |  |  |  |  | 2021-07-30 00:00:00
 |  |  |  |  |  | 9.98 | 9.39 |  |  |  |  |  |  |  |  | 2021-07-31 00:00:00
 |  |  |  |  |  | 16.99 | 16.2 |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  |  | 20 | 35
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 70
 |  |  |  |  |  | 149.9
 |  |  |  |  |  | 26.99
 |  |  |  |  |  | 99.99
 |  |  |  |  |  | 19.99
 |  |  |  |  |  | 29.99
 |  |  |  |  |  | 52.99
 |  |  |  |  |  | 199.99
 |  |  |  |  |  | 10.99
 |  |  |  |  |  | 19.99
 |  |  |  |  |  | 21.9
 |  |  |  |  |  | 2.99
 |  |  |  |  |  | 7.99
 |  |  |  |  |  | 6.47
Spreadsheet: darron_c_giron__7922__LincolnLS
Sheet: 2001

 |  | Lincoln LS
 |  | Invoice | MSRP |  | TMV
 | Base | 33393 | 36120 |  | 33917
 | Sport Package | 1206 | 1385 |  | 1240
 | [NAME] | 874 | 1005 |  | 899
 | Destination | 610 | 610 |  | 610
 | Over Invoice | 500 |  |  | 0
 | Tax
 | Title | 100 |  |  | 100
 | License | 50 |  |  | 50
 | Ford Citibank | -1417 |  |  | -1417
 | Driver Edge Citibank | -1118 |  |  | -1118
 | Down Payment | -2200 |  |  | -2200
 | Payment
 | Interest Rate | 0.08 |  |  | 0.08
 | Months | 60 |  |  | 60
Spreadsheet: 100736d1298999099-add-figures-based-on-3-criteria-from-test-data-sheet-bdm-add-test
Sheet: Result

 | want to be able to add based on 3 criteria with 3rd criteria months from Test Data Sheet
 | Budget | Actual
A
B
C
D
E
F
G
H
I
Spreadsheet: 869811d1716373777-auto-calculate-daily-income-from-a-list-example-7-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Week Number | Week beginning Date | Weekly Total
 |  | Income |  |  |  |  | Expenses |  |  |  |  |  | Week 21 | 2024-05-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 22
 |  | Date | Amount | What For? | Payment Method |  | Date | Amount | What For? | Payment Method |  |  | Week 23
 |  | 2024-05-21 00:00:00 | 85 |  | Cash |  | 2024-05-21 00:00:00 | 80 |  | Cash |  |  | Week 24
 |  | 2024-05-21 00:00:00 | 146 |  | Bank Transfer |  | 2024-05-21 00:00:00 | 171.83 |  | Bank Transfer |  |  | Week 25
 |  | 2024-05-21 00:00:00 | 35 |  | Cash |  | 2024-05-22 00:00:00 | 30 |  | Cash |  |  | Week 26
 |  | 2024-05-22 00:00:00 | 160 |  | Card |  | 2024-05-22 00:00:00 | 70 |  | Cash |  |  | Week 27
 |  | 2024-05-22 00:00:00 | 92 |  | Cash |  | 2024-05-22 00:00:00 | 17 |  | Bank Transfer |  |  | Week 28
 |  | 2024-05-22 00:00:00 | 65 |  | Cash |  | 2024-05-22 00:00:00 | 14.39 |  | Bank Transfer |  |  | Week 29
 |  | 2024-05-22 00:00:00 | 124.7 |  | Bank Transfer |  |  |  |  |  |  |  | Week 30
 |  | 2024-05-22 00:00:00 | 199 |  | Card |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 36
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 45
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 46
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 47
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 48
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 49
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 50
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 51
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | Total |  |  |  |  | Total
 |  |  |  |  | Running Total
Spreadsheet: 761106d1640642590-count-active-cases-between-two-dates-workload-testfile_weekly-open-files_eng
Sheet: Tabelle1

 | ID | Date reported | Date closed | Assigned to | Status |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00
 | 805643 | 2021-01-01 00:00:00 | 2021-03-27 00:00:00 | Person 1 | closed |  | 1 | 2 | 6 | 9 | 11 | 10 | 6
 | 805699 | 2021-01-15 00:00:00 | 2021-01-19 00:00:00 | Person 2 | closed
 | 805821 | 2021-01-28 00:00:00 |  | Person 3 | open
 | 805899 | 2021-02-13 00:00:00 | 2021-05-28 00:00:00 | Person 4 | closed
 | 805988 | 2021-02-15 00:00:00 | 2021-03-21 00:00:00 | Person 5 | closed
 | 806077 | 2021-02-27 00:00:00 |  | Person 1 | open
 | 806166 | 2021-02-28 00:00:00 | 2021-06-30 00:00:00 | Person 2 | closed
 | 806255 | 2021-03-05 00:00:00 | 2021-06-30 00:00:00 | Person 1 | closed
 | 806344 | 2021-03-06 00:00:00 |  | Person 2 | open
 | 806433 | 2021-03-11 00:00:00 |  | Person 3 | open
 | 806522 | 2021-03-28 00:00:00 | 2021-04-15 00:00:00 | Person 4 | closed
 | 806611 | 2021-04-01 00:00:00 | 2021-05-20 00:00:00 | Person 5 | closed
 | 806700 | 2021-04-15 00:00:00 | 2021-05-19 00:00:00 | Person 1 | closed
 | 806789 | 2021-04-18 00:00:00 |  | Person 2 | open
 | 806878 | 2021-04-19 00:00:00 | 2021-06-01 00:00:00 | Person 1 | closed
 | 806967 | 2021-05-05 00:00:00 | 2021-05-10 00:00:00 | Person 2 | closed
 | 807056 | 2021-05-31 00:00:00 | 2021-06-17 00:00:00 | Person 3 | closed
 | 807145 | 2021-06-18 00:00:00 |  | Person 4 | open
Spreadsheet: 145eb736-134c-4e22-b938-af3305c4ed44
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 11/13/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2011/12 ---------- |  | ---------- 2012/13 ---------- |  | 2013/14
 |  | Mkt year | [NAME] | Mkt year | [NAME] | [NAME]
Oats | Canada | 1556.499397 | 297.91844 | 1590.304046 | 503.5322180000001 | 269.110987
 | Finland | 34.84057 | 7.837 |  |  | 28.4495
 | Sweden | 29.020381 |  | 7.875
 | All other countries | 1.067246 | 0.22943 | 1.912764 | 0.491874 | 0.9450970000000001
 | Total 2/ | 1621.427594 | 305.98487 | 1600.09181 | 504.0240919999999 | 298.505584
Malting barley | Canada | 263.660306 | 5.771765 | 342.099942 | 96.260888 | 15.011418
 | All other countries | 0.244638 | 0.017 | 0.06603 | 0.016575
 | Total 2/ | 263.904944 | 5.788765 | 342.165972 | 96.277463 | 15.011418
Other barley 3/ | Canada | 89.27383699999999 | 14.675048 | 160.983119 | 13.134776 | 32.40367
 | All other countries | 0.7575109999999999 | 0.01575 | 3.99892 | 0.7971750000000001 | 0.970044
 | Total 2/ | 90.031348 | 14.690798 | 164.982039 | 13.931951 | 33.373714
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 11/12/2013
Spreadsheet: 0bc68901-8886-4e1b-b058-d3358233b26c
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
[NAME] | Women's Soccer | [NAME] | 12:00 AM | L, 1-2
08/19/2012 | Women's Soccer | Western Carolina | 12:00 AM | W, 2-1
08/24/2012 | Women's Soccer | vs. Central Michigan (Penn State Invitational) | 12:00 AM | L, 0-2
08/26/2012 | Women's Soccer | vs. Stanford (Penn State Invitational) | 12:00 AM | W, 1-0
08/31/2012 | Women's Soccer | Penn State (WVU 90 Minute Classic) | 12:00 AM | L, 1-2 (2OT)
09/02/2012 | Women's Soccer | Miami (WVU 90 Minute Classic) | 12:00 AM | T, 0-0 (2OT)
09/06/2012 | Women's Soccer | Duquesne | 12:00 AM | T, 1-1 (2OT)
[NAME] | Women's Soccer | at Purdue | 12:00 AM | T, 2-2 (2OT)
09/14/2012 | Women's Soccer | Towson | 12:00 AM | W, 5-0
09/16/2012 | Women's Soccer | High Point | 12:00 AM | W, 6-0
09/21/2012 | Women's Soccer | Texas Tech* | 12:00 AM | W, 3-2
09/23/2012 | Women's Soccer | Oklahoma State* | 12:00 AM | W, 1-0
09/28/2012 | Women's Soccer | at TCU* | 12:00 AM | W, 2-1
[NAME] | Women's Soccer | at Kansas* | 12:00 AM | W, 1-0
10/07/2012 | Women's Soccer | at Iowa State* | 12:00 AM | W, 3-2
10/12/2012 | Women's Soccer | Baylor* | 12:00 AM | T, 1-1 (2OT)
10/18/2012 | Women's Soccer | Oklahoma* | 12:00 AM | W, 2-0
10/26/2012 | Women's Soccer | at Texas* | 12:00 AM | W, 1-0 (OT)
10/31/2012 | Women's Soccer | vs. TCU (Big 12 Quarterfinals) | 12:00 AM | L, 0-2
11/10/2012 | Women's Soccer | Princeton (NCAA First Round) | 12:00 AM | L, 1-2
Spreadsheet: 143485d1330440588-excel-2007-code-deleting-unintended-buttons-on-main-spreadsheet-inventory-form-test
Sheet: PartsData

[NAME]: | VS4000
Type | Make | Model | Serial Number | Manufacture Date | Building | Room
Processor | Crestron | MC2E | 564739 | 2010-10-01 00:00:00 | A | 2114
Projector | Panasonic | F100 | 564740 | 2010-11-01 00:00:00 | RC | 2012
Codec | Polycom | VS4000 | 564741 | 2010-12-01 00:00:00 | CC | 4409
Projector | Panasonic | F100 | 234567 | 2006-03-01 00:00:00 | E | 4104
Spreadsheet: 743928d1628821311-formulas-to-chart-inventory-levels-count-of-unused-inventory-machinesh0p-
Sheet: Sheet2

Graph information
Date | Items in Inventory on given date
2021-07-01 00:00:00
2021-07-02 00:00:00
2021-07-03 00:00:00
2021-07-04 00:00:00
2021-07-05 00:00:00
2021-07-06 00:00:00
2021-07-07 00:00:00
2021-07-08 00:00:00
2021-07-09 00:00:00
2021-07-10 00:00:00
2021-07-11 00:00:00
2021-07-12 00:00:00
2021-07-13 00:00:00
2021-07-14 00:00:00
2021-07-15 00:00:00
2021-07-16 00:00:00
2021-07-17 00:00:00
2021-07-18 00:00:00
2021-07-19 00:00:00
2021-07-20 00:00:00
2021-07-21 00:00:00
2021-07-22 00:00:00
2021-07-23 00:00:00
2021-07-24 00:00:00
2021-07-25 00:00:00
2021-07-26 00:00:00
2021-07-27 00:00:00
2021-07-28 00:00:00
2021-07-29 00:00:00
2021-07-30 00:00:00
Spreadsheet: 682092d1591899023-if-then-make-multiple-cells-read-n-a-or-remain-fillable-depending-on-1-other-cell-dropdown-excel-forum-sheet
Sheet: HEM-CS

 |  | Oil and Grease HEM Cover Sheet - _______mL
I. HEM- Total Oil and Grease and HEM-SGT |  |  |  |  | Any sample over 28 days:
Was HEM-SGT Analysis Required? |  |  |  | No
A. QC Information: |  | HEM Batch No:_____________ |  |  |  | SGT-HEM Batch________________
 | Analysis Start Date/time: |  | Analyst | Analysis End Date/Time: |  | Analyst
HEM
HEM-SGT |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 | QA Sample ID: |  |  | [NAME]
HEM
HEM-SGT
 |  |  |  | mg/L  (≤ 5 mg/L)
B. Lab Control Standard: |  |  | Calculation for Recovery: (L/A)*100
 | Expected Result HEM | Observed Result HEM | % Recovery (L/A)x100 HEM | %RPD  HEM |  |  | Expected Result HEM-SGT | Observed Result HEM-SGT | % Recovery (L/A)x100 HEM-SGT | %RPD  HEM-SGT
L1 | 22.2 | 20.1 |  |  |  | L1 | 11.1 | 9.1 |  | 34.8387096774193
L2 | 22.2 | 15.4 |  |  |  | L2 | 11.1 | 6.4
 | 78%<LCS<114% |  |  | (≤18 %) |  |  | (64-132%) |  |  | (≤34 %)
[NAME]: |  | Calculation for MS %Recovery:  ((S-O)/B)*100
 |  | Calculation for Amount Spike =  (True Value (mg)/(Vol.))*1000
 | Original Result (O) | Amount Spiked (B) | Spiked Result (S) | [NAME] (U) | % Recovery acceptance criteria range
HEM |  | 22.2 |  |  | (78-114%)
HEM-SGT |  | 11.1 |  |  | (64-132%)
D. Comments:
E. Data Review
Analyst:_____________ |  |  | Chemist:_____________ |  |  | QC:______________
Date:_______________ |  |  | Date:________________ |  |  | Date:______________
Spreadsheet: 871633d1718057758-query-pivot-to-transpose-email-address-email
Sheet: Sheet1

 |  |  |  |  |  |  | Alternative 1: |  |  |  |  |  | Alternative 2:
IDCUST | CUSTOMER NAME | [NAME] |  |  | IDCUST | CUSTOMER NAME | Email #1 | Email #2 | Email #3
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  |  |  | mailto:[EMAIL] | [EMAIL] | [EMAIL] |  |  |  |  | [EMAIL] | [EMAIL]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | UC1002 | [NAME] (UC1002) | [EMAIL] |  |  |  |  |  | [EMAIL]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | UC1005 | Island Car Trading Pte Ltd | [EMAIL] | [EMAIL] |  |  |  |  | [EMAIL] | [EMAIL]
UC1002 | [NAME] (UC1002) | [EMAIL]
UC1005 | Island Car Trading Pte Ltd | [EMAIL]
UC1005 | Island Car Trading Pte Ltd | [EMAIL]
 |  |  |  |  | How do I use Query to to achieve above?
 |  |  |  |  |  |  |  |  |  |  |  |  | Drag down:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | [EMAIL]
IDCUST | CUSTOMER NAME | [NAME] | Unique |  |  |  |  |  |  |  |  |  |  | [EMAIL]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | Count of EMAIL |  | Unique
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | IDCUST | CUSTOMER NAME | UC10011 | UC10012 | UC10013 | UC10021 | UC10051 | UC10052
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | UC1001 | Lake View Credit Pte Ltd (UC1001) | 1 | 1 | 1
UC1002 | [NAME] (UC1002) | [EMAIL] |  |  | UC1002 | [NAME] (UC1002) |  |  |  | 1
UC1005 | Island Car Trading Pte Ltd | [EMAIL] |  |  | UC1005 | Island Car Trading Pte Ltd |  |  |  |  | 1 | 1
UC1005 | Island Car Trading Pte Ltd | [EMAIL]
 |  |  |  |  | Can Pivot Table change all the 1 to the [NAME] instead?
Spreadsheet: 5f842d12-508d-4bcd-8094-a9f39251a555
Sheet: Sheet1

Table S4 : Statistical analysis of the reproducibility of transitions of the gene expression state at the HMR-left PEV.
 | Frequencies of ON and OFF cells |  | Frequencies of ON to ON and On to OFF transitions |  | Frequencies of OFF to ON and OFF to OFF transitions
 | ON | OFF | ON→ON | ON→OFF | OFF→ON | OFF→OFF
HMR-left PEV (1) | 317 | 143 | 238 | 49 | 42 | 81
HMR-left PEV (2) | 299 | 158 | 221 | 46 | 38 | 103
HMR-left PEV (3) | 318 | 165 | 230 | 58 | 52 | 93
HMR-left PEV (4) | 258 | 202 | 184 | 50 | 41 | 135
 | Ratio of ON and OFF cells |  | Ratio of ON to ON and On to OFF transitions |  | Ratio of OFF to ON and OFF to OFF transitions
 | ON | OFF | ON→ON | ON→OFF | OFF→ON | OFF→OFF
HMR-left PEV (1) | 0.689 | 0.311 | 0.829 | 0.171 | 0.341 | 0.659
HMR-left PEV (2) | 0.654 | 0.346 | 0.828 | 0.172 | 0.27 | 0.73
HMR-left PEV (3) | 0.658 | 0.342 | 0.799 | 0.201 | 0.359 | 0.641
HMR-left PEV (4) | 0.561 | 0.439 | 0.786 | 0.214 | 0.233 | 0.767
p-value obtained with ON/OFF state frequencies
 | HMR-left PEV (1) | HMR-left PEV (2) | HMR-left PEV (3) | HMR-left PEV (4)
HMR-left PEV (1) | 0.5283885669392453
HMR-left PEV (2) | 0.1459821266750718 | 0.5277193263680978
HMR-left PEV (3) | 0.174431708008768 | 0.4743407656412468 | 0.5270411883188407
HMR-left PEV (4) | 3.802699894788651e-05 | 0.002323755497636116 | 0.001328805326808626 | 0.5264805682673136
p-value obtained with ON to ON and ON to OFF transition frequencies
 | HMR-left PEV (1) | HMR-left PEV (2) | HMR-left PEV (3) | HMR-left PEV (4)
HMR-left PEV (1) | 0.5441369866944452
HMR-left PEV (2) | 0.5252769115771939 | 0.5455882793659779
HMR-left PEV (3) | 0.201250298733486 | 0.2210884894371455 | 0.5413551781036159
HMR-left PEV (4) | 0.1292285437727713 | 0.1444514328028349 | 0.4059542591608227 | 0.5448704394575514
p-value obtained with OFF to ON and OFF to OFF transition frequencies
 | HMR-left PEV (1) | HMR-left PEV (2) | HMR-left PEV (3) | HMR-left PEV (4)
HMR-left PEV (1) | 0.553451402884913
HMR-left PEV (2) | 0.1282493820511733 | 0.5533486719041703
HMR-left PEV (3) | 0.4349595476021753 | 0.06728599827129744 | 0.5487060181989748
HMR-left PEV (4) | 0.02716023750347408 | 0.2682164758587142 | 0.009538854625538322 | 0.5501389087294012
HMR-left PEV (1) : FUY263, HMR-left PEV (2) : FUY488, HMR-left PEV (3) : [NAME],  HMR-left PEV (4) : FUY804
Spreadsheet: 06e4eb6c-627a-455f-a692-00d1f0a2636d
Sheet: Sheet1

LOYOLA MARYMOUNT UNIVERSITY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
DEPARTMENT RETREAT FUNDING REQUEST
 | Chair Name: |  |  |  | Department/Office: |  |  | Phone Extension:
 | Retreat Date:
 | (Overnight costs will not be reimbursed.)
 | Duration |  |  |  | Start Time: |  |  | End Time:
 | Location Name and City:
 | Purpose of Retreat (Attach agenda [NAME] goals):
 | Number of Faculty Attendees __________.  (List Names - Optional)
 | Number of Other Attendees, (e.g., moderators, speakers, staff) __________.
 | List Names and describe purpose - Required.
 | Cost: |  |  |  |  | Funds Requested |  | Funds Approved | Funds Expended
 |  | Facilitator/Moderator/Speaker
 |  | Facility Fee
 |  | Meals
 |  | Supplies
 |  | Other (describe)
 |  | Total |  |  |  | 0
 |  | Department Chair Signature: |  |  |  |  |  | Date:
 |  | College/School Budget Mgr.: |  |  |  |  |  | Date:
 |  | [NAME]: |  |  |  |  |  | Date:
 |  | Chief Academic Officer Approval: |  |  |  |  |  | Date: