tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56650d1256785130-summarizing-raw-data-score-sample
Sheet: RAW DATA

RoomNumber | SCORE 1 | SCORE 2 | SCORE 3
711 | 75 | 75 | 25
1229 | 100 | 100 | 75
1534 | 100 | 100 | 100
808 | 75 | 75 | 75
708 | 100 | 100 | 75
321 | 100 | 100 | 100
1831 | 100 | 100 | 100
821 | 75 | 25 | 75
1128 | 75 | 75 | 75
912 | 75 | 75 | 75
1929 | 25 | 75 | 75
425 | 75 | 75 | 75
1128 | 100 | 100 | 100
815 | 75 | 100 | 75
2022 | 75 | 75 | 75
1930 | 75 | 75 | 75
2029 | 100 | 100 | 100
1412 | 100 | 100 | 75
1016 | 75 | 75 | 75
428 | 75 | 75 | 75
806 | 100 | 100 | 100
1104 | 100 | 100 | 100
2020 | 100 | 100 | 100
602 | 75 | 100 | 75
1415 | 75 | 75 | 75
408 | 75 | 75 | 75
1225 | 25 | 75 | 100
1025 | 75 | 75 | 75
1022 | 75 | 75 | 75
831 | 75 | 75 | 75
1406 | 100 | 100 | 100
729 | 75 | 75 | 75
728 | 100 | 100 | 100
829 | 100 | 100 | 100
1228 | 100 | 100 | 100
314 | 75 | 75 | 75
812 | 25 | 25 | 75
420 | 75 | 75 | 75
1634 | 100 | 100
1005 | 75 | 75 | 25
1216 | 75 | 75 | 75
1033 | 100 | 100 | 100
922 | 75 | 75 | 75
308 | 25 | 75 | 75
501 | 75 | 75 | 75
528 | 75 | 75 | 75
1022 | 75 | 75 | 75
316 | 100 | 100 | 25
710 | 100 | 100 | 100
721 | 100 | 100
412 | 100 | 100 | 75
428 | 100 | 100 | 75
224 | 100 | 75 | 75
629 | 75 | 75 | 75
708 | 75 | 75 | 25
1529 | 100 | 100 | 100
1920 | 100 | 100 | 75
704 | 75 | 75 | 75
401 | 75 | 75 | 75
711 | 75 | 75 | 75
1031 | 100 | 100 | 100
822 | 75 | 75 | 75
1217 | 25 | 25 | 25
212 | 75 | 75 | 25
917 | 75 | 75 | 75
302 | 75 | 75 | 75
419 | 75 | 75 | 25
1202 | 75 | 75 | 75
1533 | 75 | 75 | 75
712 | 75 | 100 | 100
2030 | 75 | 75 | 75
534 | 75 | 75 | 75
512 | 100 | 100 | 100
1108 | 100 | 100 | 75
1129 | 75 | 25 | 75
314 | 25 | 75 | 75
1820 | 75 | 75 | 75
1118 | 100 | 100 | 100
302 | 75 | 75 | 75
1031 | 100 | 100 | 25
1217 | 100 | 100 | 100
406 | 100 | 100 | 100
1104 | 75 | 100 | 75
1128 | 100 | 100 | 75
1408 | 75 | 75 | 25
917 | 75 | 75 | 75
1215 | 100 | 100 | 100
1210 | 100 | 75 | 75
420 | 100 | 100 | 75
916 | 75 | 75 | 75
1930 | 100 | 75 | 75
1225 | 100 | 100 | 25
1017 | 75 | 75 | 75
528 | 100 | 100 | 100
620 | 100 | 100 | 100
729 | 25 | 75 | 25
1421 | 75 | 75 | 75
821 | 100 | 100 | 100
730 | 100 | 100 | 75
902 | 75 | 75 | 75
714 | 100 | 100 | 100
904 | 100 | 100 | 75
516 | 75 | 75 | 100
725 | 75 | 75 | 75
514 | 75 | 75
425 | 25 | 75 | 75
634 | 75 | 75 | 75
703 | 75 | 75 | 75
825 | 100 | 100 | 100
510 | 75 | 75 | 75
808 | 75 | 75 | 75
502
1416 | 100 | 100 | 100
803 | 75 | 75 | 25
721 | 100 | 100 | 100
1425 | 75 | 75 | 25
521 | 100 | 100 | 75
1416 |  | 75 | 75
501 | 75 | 75 | 75
419 | 75 | 75 | 75
210 | 100 | 100 | 100
1930 | 75 | 75 | 75
1925 | 75 | 75
409 | 100 | 100 | 100
729 | 75 | 25 | 75
508 | 100 | 100
1421 | 25 | 75 | 75
934 | 75 | 75 | 75
419 | 100 | 100 | 100
416 | 75 | 75 | 25
705 | 75 | 75 | 75
1134 | 100 | 100 | 75
734 | 100 | 100 | 100
420 | 100 | 100 | 100
1201 |  | 75 | 75
Spreadsheet: 37fd9c27-f882-4136-ae00-350d7a9729fd
Sheet: Sheet1

COUNTY SUMMARY/NAMES ON CHECKLIST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Sept. 11, 2012 | Republican | Democratic | Undeclared | Total |  | 1 | 2A | 2B | 3 | 4
Belknap County | 14990 | 9218 | 13668 | 37876 |  | 312 | 1617 | 1393 | 2394 | 615
Carroll County | 11656 | 6725 | 14270 | 32651 |  | 257 | 1781 | 1606 | 2572 | 715
Cheshire County | 12536 | 15280 | 19096 | 46912 |  | 351 | 1470 | 2011 | 2911 | 1002
Coos County | 5070 | 5660 | 7376 | 18106 |  | 150 | 1011 | 812 | 1566 | 424
Grafton County | 15418 | 16391 | 23311 | 55120 |  | 406 | 1592 | 2381 | 3222 | 1363
Hillsborough County | 77351 | 64427 | 87806 | 229584 |  | 1628 | 7742 | 6431 | 12096 | 3265
Merrimack County | 30180 | 26081 | 33802 | 90063 |  | 879 | 3114 | 4662 | 6602 | 1934
Rockingham County | 66594 | 50821 | 72320 | 189735 |  | 1134 | 6151 | 5688 | 9775 | 2302
Strafford County | 19516 | 23641 | 27770 | 70927 |  | 683 | 1619 | 2302 | 3399 | 703
Sullivan County | 7343 | 7043 | 9933 | 24319 |  | 316 | 864 | 1064 | 1606 | 513
Totals | 260654 | 225287 | 309352 | 795293 |  | 6116 | 26961 | 28350 | 46143 | 12836
1. Number of persons who registered to vote at the polling place
2A. Number of undeclared voters voting Republican
2B. Number of undeclared voters voting Democratic
3. Number of undeclared voters declaring a party to vote and
returned to undeclared status before leaving the polling place
4. Number of voters who did not present a valid photo ID
Spreadsheet: 163655d1340388016-cell-contents-overwritten-by-successive-cells-but-maybe-theres-a-way-for-it-not-to-temp
Sheet: Tasks

 |  |  | Start | End
Phase 1
 | Server Piece
 |  | Vendor recommendation/Server Specs | 2012-06-25 00:00:00 | 2012-06-29 00:00:00
 |  | Investigate pricing | 2012-07-02 00:00:00 | 2012-07-06 00:00:00
 |  | Procure Server | 2012-07-09 00:00:00 | 2012-07-13 00:00:00
 | Software Piece
 |  | Obtain Software and License | 2012-07-09 00:00:00 | 2012-07-13 00:00:00
 |  | Install Server Software | 2012-07-16 00:00:00 | 2012-07-18 00:00:00
 |  | Install Client Software | 2012-07-16 00:00:00 | 2012-07-20 00:00:00
 |  | Test Communications | 2012-07-20 00:00:00 | 2012-07-20 00:00:00
Phase 2
 | Training
 |  | Train the Trainers | 2012-07-23 00:00:00 | 2012-07-27 00:00:00
 |  | Schedule Staff Training Sessions | 2012-07-25 00:00:00 | 2012-07-27 00:00:00
 |  | Train Staff | 2012-07-30 00:00:00 | 2012-08-03 00:00:00
Spreadsheet: 2eb56c63-6d23-414a-ba0a-fa600213d773
Sheet: DC FIN 1010

Making Money Work: Distance Learning FIN 1010 - Dual Credit Enrollment
Spring and Fall Terms Only: Fall 2009 through Fall 2012
Making Money Work: Distance Learning FIN 1010 - Dual Credit Enrollment
Student Type | Course | Number of Students
 |  | Fall 2009 | Spring 2010 | Fall 2010 | Spring 2011 | Fall 2011 | Spring 2012
DUAL CREDIT | FIN 1010 | 39 | 125 | 363 | 221 | 405 | 296
Total Number of Students: Fall 2009 through Spring 2012
Making Money Work: Distance Learning FIN 1010 - Dual Credit Enrollment
Student Type | Course | Number of Students2
 |  | Fall 2009 through Spring 2012
DUAL CREDIT | FIN 1010 | 1400
1 Since Fall 2012 is ongoing, all Fall 2012 data are derived from a daily report of Dual Credit enrollment created by ITS and not from Institutional Research.  All Fall 2012 data are unofficial at this time.
2 Total unduplicated number of students enrolled in Fin 1010 between Fall 2009 and Spring 2012.
Making Money Work: Distance Learning FIN 1010 - Dual Credit Enrollment
Academic Year1 (Fall and Spring terms only): AY 2009-2010 through AY 2011-2012
Making Money Work: Distance Learning FIN 1010 - Dual Credit Enrollment
Student Type | Course | Number of Students2
 |  | AY 2009-2010 | AY 2010-2011 | AY 2011-2012
DUAL CREDIT | FIN 1010 | 164 | 571 | 682
[NAME] (Spring and Fall terms only): AY 2009-2010 through AY 2011-2012
Making Money Work: Distance Learning FIN 1010 - Dual Credit Enrollment
Student Type | Course | Number of Students2
 |  | CY 2010 | CY 2011
DUAL CREDIT | FIN 1010 | 483 | 622
1 Academic year is comprised of Fall, Spring, and Summer Terms of the given year.
2 Number of students is unduplicated, which means each student is counted once for every year he or she was enrolled in FIN 1010 on the census date for the given term.
3 Calendar year is comprised of Spring, Summer, and Fall terms of the given year.
Spreadsheet: 769737d1645659683-excel-math-question-excel-question
Sheet: Sheet1

1. Change the dates below to the following format (dd-MMM-yyyy)
Current Format | New Format
Jan 27th 1986
2001-01-15 00:00:00
2013-08-23 00:00:00
1989-06-13 00:00:00
2. Complete the following math equations
Number 1 | Number 2 | Type | Answer
18 | 1523 | Add
226 | 4 | Divide
1833 | 1881 | Subtract
236849 | 5.49 | Multiply
Spreadsheet: 488372d1478628207-need-formula-to-calculate-start-time-and-end-time-book1
Sheet: Sheet8

Shift Start Date | Shift Start Time | Shift End Time
2016-10-25 17:30:00 | 2016-10-25 17:30:00 | 2016-10-25 18:30:00
2016-10-31 14:40:00 | 2016-10-31 14:40:00 | 2016-10-31 15:20:00
2016-10-26 16:20:00 | 2016-10-26 16:20:00 | 2016-10-26 17:20:00
2016-10-31 16:00:00 | 2016-10-31 16:00:00 | 2016-10-31 17:00:00
2016-10-20 10:00:00 | 2016-10-20 10:00:00 | 2016-10-20 11:00:00
2016-10-25 16:30:00 | 2016-10-25 16:30:00 | 2016-10-25 17:30:00
2016-10-24 15:00:00 | 2016-10-24 15:00:00 | 2016-10-24 16:00:00
2016-10-26 14:30:00 | 2016-10-26 14:30:00 | 2016-10-26 15:30:00
2016-10-25 12:30:00 | 2016-10-25 12:30:00 | 2016-10-25 13:30:00
2016-10-25 11:00:00 | 2016-10-25 11:00:00 | 2016-10-25 12:00:00
2016-10-27 14:30:00 | 2016-10-27 14:30:00 | 2016-10-27 16:30:00
2016-10-25 14:45:00 | 2016-10-25 14:45:00 | 2016-10-25 15:45:00
2016-10-18 10:00:00 | 2016-10-18 10:00:00 | 2016-10-18 11:00:00
2016-10-24 16:30:00 | 2016-10-24 16:30:00 | 2016-10-24 17:30:00
2016-10-17 10:00:00 | 2016-10-17 10:00:00 | 2016-10-17 11:00:00
2016-10-31 13:30:00 | 2016-10-31 13:30:00 | 2016-10-31 14:30:00
2016-10-24 10:00:00 | 2016-10-24 10:00:00 | 2016-10-24 12:00:00
2016-10-28 11:00:00 | 2016-10-28 11:00:00 | 2016-10-28 12:00:00
2016-10-21 13:00:00 | 2016-10-21 13:00:00 | 2016-10-21 14:00:00
2016-10-21 16:30:00 | 2016-10-21 16:30:00 | 2016-10-21 17:00:00
2016-10-27 10:20:00 | 2016-10-27 10:20:00 | 2016-10-27 11:20:00
2016-10-26 13:00:00 | 2016-10-26 13:00:00 | 2016-10-26 14:00:00
2016-10-21 10:50:00 | 2016-10-21 10:50:00 | 2016-10-21 11:50:00
2016-10-05 16:40:00 | 2016-10-05 16:40:00 | 2016-10-05 17:40:00
2016-10-17 11:00:00 | 2016-10-17 11:00:00 | 2016-10-17 12:00:00
2016-10-17 13:30:00 | 2016-10-17 13:30:00 | 2016-10-17 14:30:00
2016-10-06 15:30:00 | 2016-10-06 15:30:00 | 2016-10-06 16:00:00
2016-10-10 12:30:00 | 2016-10-10 12:30:00 | 2016-10-10 12:45:00
2016-10-20 11:00:00 | 2016-10-20 11:00:00 | 2016-10-20 12:00:00
Spreadsheet: 77713d1278145688-collate-and-index-info-example2-adeassessor
Sheet: Main

Entry | Unit 1 Criteria 1 | Unit 1 Criteria 2 | Unit 1 Criteria 3 | Unit 1 Criteria 4 | Unit 1 Criteria 5 | Unit 1 Criteria TRIM | Unit 2 Criteria 1 | Unit 2 Criteria 2 | Unit 2 Criteria 3 | Unit 2 Criteria 4 | Unit 2 Criteria 5 | Unit 2 Criteria TRIM
Entry 1 | 1 |  | 3 |  | 5 |  |  | 2 | 3 | 4
Entry 2 |  |  |  |  |  |  | 1 | 2
Entry 3 |  |  |  | 4 | 5 |  |  |  |  |  | 5
 |  |  |  |  |  | <--on ths example, TRIM formula has ben used to collate data from Critieria columes
Spreadsheet: 816977d1675930030-add-calculate-field-in-pivot-year
Sheet: Sheet7

Accounting Year | Accounting Month | Name | VOL
2022 | 2022 - 01 | AAA | 100
2022 | 2022 - 01 | BBB | 300
2023 | 2023 - 01 | AAA | 299
2023 | 2023 - 01 | BBB | 200
 |  |  |  |  |  |  | Accounting Month | (All)
 |  |  |  |  |  |  | Sum of VOL | Accounting Year
 |  |  |  |  |  |  | Name | 2022 | 2023 | Growth | %Growth
 |  |  |  |  |  |  | AAA | 100 | 299 | 199 | 1.99
 |  |  |  |  |  |  | BBB | 300 | 200 | -100 | -0.3333333333333333
 |  |  |  |  |  |  | Grand Total | 400 | 499 | 99 | 1.656666666666667
Spreadsheet: 57600d1257808296-summing-total-with-pushbutton-testtt6
Sheet: Year 4W

 | Surname | Forename | Gender | Read | Write | FSM | Math | Science
 | One | [NAME] | M | 1 | 1 | Y | 1 | 1
 | Two | [NAME] | F | 2 | 2 | N | 2 | 2
 | Three | [NAME] | M | 3 | 3 | N | 3 | 3
 | Four | Devine | F | 4 | 5 | N | 4 | 4
Spreadsheet: 745747d1630160640-pulling-data-validation-dropdown-options-from-another-sheet-not-dependent-dropdown-data-validation
Sheet: Data Worksheet

Cars | Shoes | Movies | Movie Studios | Fruits | Minerals | Animals
Ford | Nike | [NAME] | Disney | Grape | Gold | Dog
Kia | [NAME] | Frozen | Universal | [NAME] | Silver | Cat
Chevy | Dockers | Avengers | Marvel | Orange | Platinum
Audi |  | LOTR |  |  | [NAME] | Horse
 |  |  |  |  |  | Hippo
Key: | Found on the "Valid Values by Field" tab |  |  |  |  |  |  |  | Fruits | Cars | Shoes | Movie Studios | Movies | Minerals
 | Not Found on the "Valid Values by Field" tab
 | Blank Cell
Data Validation Formula Starting on [NAME] (in Cell I2 currently): | =INDEX('Valid Values by Field'!$A$2:$BC$100000,MATCH(A2,INDEX('Valid Values by Field'!$A$2:$BC$100000,,MATCH(A$1,'Valid Values by Field'!$A$1:$BC$1,0)),0),MATCH(A$1,'Valid Values by Field'!$A$1:$BC$1,0))
Background: | This tool matches-up the column names (in any order, regardless if the same column appears on the "Valid Values by Field" sheet.
 | If the same column appears on both sheets, the data is validated (green indicates the data is under the same column heading on the Valid Values sheet).
Goal: | Add data validation to each cell, to allow the user to choose one of the Valid options from a dropdown.
 | Example: under Cars, Audi is not on the Valid Values list for Cars, so I need a dropdown to allow the user to select Ford, Kia, or Chevy.
 | (I'd like to avoid named ranges, if possible)
 | I've already added placeholder data validations to each cell; I just need the magic formula!
 | I've spent hours trying to get this to work, but no luck. I have included the Conditioonal Formatting formula I used in cell C19 for reference. I have a feeling the solution is a variation on the Conditional Formatting formula. I've tried CHOOSE(), but I could not get that to work, either....
Spreadsheet: 858142d1706891335-dynamic-formula-to-calculate-value-based-on-multiple-criteria-book4
Sheet: Before Data

 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Product Code | Total |  |  | Total  Town Qty | TOWN 1 | TOWN 2 | TOWN 3 | TOWN 4 |  |  |  | TOTAL
A1010 |  |  |  | 33
A1010 |  |  |  | 98
A1010 |  |  |  | 41
A1010 |  |  |  | 570
A1010 |  |  |  | 0
A1010 |  |  |  | 214
A1010 |  |  |  | 36
A1010 | Total |  |  |  | 400 | 262 | 180 | 150
A1030 |  |  |  | 25
A1030 |  |  |  | 75
A1030 | Total |  |  |  | 40 | 20 | 10 | 30
A1035 |  |  |  | 15
A1035 |  |  |  | 0
A1035 |  |  |  | 30
A1035 | Total |  |  |  | 20 | 10 | 5 | 10
B1150 |  |  |  | 30
B1150 |  |  |  | 20
B1150 |  |  |  | 0
B1150 |  |  |  | 45
B1150 |  |  |  | 65
B1150 | Total |  |  |  | 50 | 60 | 20 | 30
Spreadsheet: 42393d1240974155-look-up-multiple-columns-return-multiple-values-testing
Sheet: Sheet1

9 | A | B | C | 9 | A | B | C | Testing
8 | D | J | O | 7
7 | B | G | U | 6
6 | C | H | Q | 5 | A | B | C
5 | B | B | D | 3
4 | G | H | M | 2
3 | F | C | Y
2 | E | B | A | 7
 |  |  |  | 6
 |  |  |  | 5
1 | A | B | C | 3
2 | D | J | O | 2
3 | B | G | U
4 | C | H | Q
5 | B | B | D
6 | G | H | M
7 | F | C | Y
8 | E | B | A
Spreadsheet: 876414d1723107550-filter-with-match-text-join-1-
Sheet: Result

 |  |  |  |  |  |  |  |  |  | Reqired Result | [NAME]
 |  |  |  |  | A-174 |  |  |  |  | 50741/2080.06.30
 |  |  |  |  | K-59/70/84 |  |  |  |  | 53204/2080.07.19,53490/2080.07.20,53353/2080.07.19
 |  |  |  |  | Ash-123 |  |  |  |  | 33630/2081.03.25
 |  |  |  |  | Ash-139 |  |  |  |  | 794/2081.03.28
Spreadsheet: 98043d1297125263-vb-code-to-copy-range-of-cells-upload
Sheet: Sheet1

Level 2 Maintenance
Date/Machine | Total Hours
32 - 2/15/11 | 35 | 32 - 2/15/11 | 35
 |  | 11- 2/18/11 | 40
11- 2/18/11 | 40 | 41 - 2/20/11 | 50
41 - 2/20/11 | 50 | 33 - 3/05/11 | 24
 |  | 41 - 3/15/11 | 24
33 - 3/5/11 | 24
41 - 3/15/11 | 24
Spreadsheet: mary_fischer__25818__RETAIL4 1CE 2CE variance analysis
Sheet: WHSEES4

EES - WHSEES4
Analysis of 1st CE to 2nd CE Variances
For the tax year 2001
(in millions)
DR/(CR)
(Income)/Loss
 | 1CE | 2CE | [NAME] |  | Reasons for variance
Net Income Before Tax | 830 | 762 |  |  | Estimation of losses adjusted by accounting
Permanent Differences
Dividends | 0 | 0
Equity Earnings | 0 | 0
Foreign Operations | 0 | 0
Foreign Taxes | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Other - Expense related to IC purchase | 0 | -20 |  |  | See Note 1
Other - Reverse additional June revenue | 0 | 5 |  |  | See Note 1
Total Permanent Differences
Temporary Differences
Depreciation, Depletion, & Amort. | 0 | -1 |  |  | Adjusted estimate on tax depreciation - Co 87c
Partnership Equity | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Price Risk Management | -249 | 165 |  |  | See Note 2
Regulatory Contingencies | 0 | 0
Other - Rev of Purchase Price Write-off | 0 | -8 |  |  | Adjustment of the purchase price for Co. 87c
Other - Rev Management Overview | 0 | 4 |  |  | Overview not reported separately in 1 CE
Total Temporary Differences
Total State Taxable Income
Current State Tax Exp/(Bene) | 0 | 0
Total Federal Taxable (Income)/Loss
Current Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | 91 | 91
Other State | 0 | 0
Other Foreign | 0 | 0
Total Current Tax Expense (Benefit)
Deferred Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | -91 | -91
Other State | 0 | 0
Other Foreign | 0 | 0
Total Deferred Tax Expense (Benefit)
Total Tax Expense (Benefit)
Net (Income) / Loss
Effective Rate
Additional Notes regarding changes from 1CE to 2CE:  [NAME] (DR/(CR)
Note 1:  Co. 87c  was purchased on June 29, 2000
per the 338(h)(10) election.  Accounting recognizes the date as
May 31, 2000.   During Q2 of 2001 accounting discovered
income and expense activity from the month of June, 2000
that had not been booked/tax reverses the amount.
Note 2: The following changes were made to PRM activity for WHSEES4:
Avista [NAME] transferred to WHSEES4 from RETAIL4 |  | 137
Changes to MTM estimates |  | 277
Spreadsheet: 0106eeea-0b67-4a72-84ac-22520e8fd084
Sheet: TEST 2 (T2)

 |  |  | TEST 2 (volume used in this UV spectrophotometer was doubled as the samples contained greater liquid content than tests 1, 3 and 4)
 |  |  | Table 2a: Test occurred using 100 ul of sample.
 |  |  | Sample id. | v (ul) | 230 | 260 | 270 | 280 | 260/280 |  |  | NOTE: 'Red mark' indicates sample with DNA pellet which was particularly difficult to breakup by vortexing.
 | Lower volume |  | 1 | 100 | 0.058 | 0.018 | 0.019 | 0.017
 |  |  | Table 2b: Test using 150 ul of sample |  |  |  |  |  |  |  |  | Table 2c: Repeat tests using 150 ul of sample
 |  | Solid DNA pellet | Sample id. | v (ul) | 230 | 260 | 270 | 280 | 260/280 |  |  | NLIS tag | v | 230 | 260 | 270 | 280 | 260/280
 |  | * | 1 | 150 | 0.1 | 0.045 | 0.046 | 0.043 |  |  | Repeat | 1 | 150 | 0.1 | 0.037 | 0.035 | 0.031
 |  |  | 2 | 150 | 0.01 | 0.031 | 0.031 | 0.028 |  |  | Repeat | 3 | 150 | 0.077 | 0.025 | 0.027 | 0.026
 |  | * | 3 | 150 | 0.155 | 0.048 | 0.044 | 0.039 |  |  |  | Median
 |  |  | 4 | 150 | 0.065 | 0.011 | 0.012 | 0.01 |  |  |  | STDEV
 |  |  | 5 | 150 | 0.138 | 0.028 | 0.033 | 0.032 |  |  |  | AV
 |  |  | 6 | 150 | 0.142 | 0.027 | 0.033 | 0.031
 |  |  | 7 | 150 | 0.122 | 0.025 | 0.029 | 0.028
 |  |  | 8 | 150 | 0.083 | 0.02 | 0.023 | 0.021 |  |  |  | IMPORTANT: TEST 2 samples were placed in rotating incubator for 1000 mins @ 64 d C at speed 6 on 10/09/2012
 |  |  | 9 | 150 | 0.084 | 0.009 | 0.014 | 0.014
 |  |  | 10 | 150 | 0.057 | 0.002 | 0.007 | 0.008
 |  |  | 11 | 150 | 0.071 | 0.012 | 0.017 | 0.018
 |  | * | 12 | 150 | 0.008 | -0.011 | -0.007 | -0.004
 |  |  | 13 | 150 | 0.078 | 0.016 | 0.019 | 0.018
 | Red mark |  | 14 | 150 | 0.087 | 0.01 | 0.014 | 0.014
 |  |  | 15 | 150 | 0.068 | 0.004 | 0.008 | 0.01
 | Red mark |  | 16 | 150 | 0.04 | -0.008 | -0.003 | -0.003
 |  |  | 17 | 150 | 0.126 | 0.035 | 0.036 | 0.028
 |  | * | 18 | 150 | 0.114 | 0.028 | 0.033 | 0.031
 |  |  | 19 | 150 | 0.06 | 0.013 | 0.018 | 0.014
 |  |  | 20 | 150 | 0.051 | 0.001 | 0.014 | 0.019
 | 600 ul FG3 | * | 21 | 150 | 0.063 | 0.001 | 0.004 | 0.007
 |  | * | 22 | 150 | 0.102 | 0.011 | 0.018 | 0.021
 |  | * | 23 | 150 | 0.059 | 0.01 | 0.015 | 0.014
 |  | * | 24 | 150 | 0.062 | 0.008 | 0.01 | 0.007
 |  |  | Median
 |  |  | STDEV
 |  |  | AV
Spreadsheet: 820360d1678060116-how-to-tweak-formula-to-change-calendar-to-include-date-range-book_251717-4
Sheet: Contact Details

Event Name | Primary Contact | Organisation | Contact Email | Contact Phone | Website
Event 1 ya | Contact 1 | Org from Contact 1 | [NAME]
 | An additional contact | Org again | email2@email
 | Another additional contact | Org again | email3@email
 | another additional contact | Org again | email4@email
Event 2 tootle | Contact A | Org from Contact A | emailfromcontactA@doodoo
Event 3 babi
Event 4 yernow
Event 5 something
Event 6 now
Spreadsheet: 816918d1675891162-xlookup-and-if-formula-roadblock-for-commissions-sample_2023_commission
Sheet: Abby

ABBY | January | February | March | April | May | June | July | August | September | October | November | December |  | Sales | Bonus | Class
Sales Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Subtotal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Damage and Loss | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
D&L Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Subtotal of D&L Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Open Invoice - 120 Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Expectation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | ` |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | `
Spreadsheet: 262106d1377952540-choosing-one-of-the-duplicate-customer-info-testworkbook_-ijulian-
Sheet: Report

Date From | 2013-01-01 00:00:00
Date To | 2013-08-27 00:00:00
Agent | PENDING | CANCEL | GOOD | Total
[NAME]
VIOLETTA
SHARON
MARILYN
STEVE
RUBEN
WILLIAM
VERONICA
Total
Spreadsheet: 99446d1298056773-predetermined-sliding-scale-765048_thesavo
Sheet: Sheet1

type | A | B | C
Total # of users | photoshop | Illustrator | Photoshop + Illustrator
0 | 12 | 11 | 20
10 | 11 | 10 | 19
40 | 10 | 9.5 | 18.5
80 | 9 | 9 | 16
150 | 8 | 7.5 | 13
230 | 7 | 6 | 10
350 | 6 | 3 | 9
500 | 5 | 2 | 8
750 | 4 | 1.5 | 7
 |  | Sept
 |  | Users
Mo | All | 52 | Total user Usage % | Pays # of mo | Pay for  # of users | User Cost
Project A | C | 150 | 0.8379888268156425 | 43.57541899441341 | 193.5754189944134 | 2516.480446927374 |  | 2516.480446927374
Project B | C | 8 | 0.0446927374301676 | 2.324022346368715 | 10.32402234636871 | 206.4804469273743 |  | 196.1564245810056
Project C | B | 10 | 0.05586592178770949 | 2.905027932960894 | 12.90502793296089 | 129.0502793296089 |  | 129.0502793296089
Project D | A | 11 | 0.06145251396648044 | 3.195530726256983 | 14.19553072625698 | 156.1508379888268 |  | 156.1508379888268
total P Users |  | 179 | 0.9999999999999999 | 52 | 231
total all |  | 231
Spreadsheet: 758397d1638847174-pull-data-from-other-tabs-into-a-summary-tab-only-if-certain-data-selected-in-column-pull-data-from-other-tabs-into-a-summary-tab-only-if-certain-data-selected-in-column
Sheet: SURGICAL & IMPLANTS

 | SURGICAL & IMPLANTS
 | BRAND | ITEM CODE | [NAME] | AVG QTY PER CHAIR | CHAIR COUNT | AUTOMATED TOTAL | ADJUSTED TOTAL | ACTUAL TOTAL | UOM | POST SSU TRAINING
 | SURGICAL MOTORS
 |  | Surgical & Implants | Test 1 |  |  |  |  |  |  | 5-6 weeks
 | SURGICAL HANDPIECES
 |  | Surgical & Implants | Test 2
 | BIOLOGICS
 |  | Surgical & Implants | Test 3 |  |  |  |  |  |  | 7-8 weeks
 |  | Surgical & Implants | Test 4 |  |  |  |  |  |  | 3-4 weeks
 | KITS & INSTRUMENTS
 |  | Surgical & Implants | Test 5 |  |  |  |  |  |  | 1-2 Weeks
 |  | Surgical & Implants | Test 6
 | IMPLANTS
 |  | Surgical & Implants | Test 7 |  |  |  |  |  |  | 5-6 weeks