tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871791d1718204660-teacher-markbook-letter-grade-to-numerical-value-average-excel-markbook
Sheet: Y5

 | Student 1 | Student 2 | Student 3 | Student 4 | Student 5 | Student 6 | Student 7 | Student 8 | Student 9 | Student 10 | Student 11 | Student 12 | Student 13 | Student 14
Achievement standard
students use place value to write and order decimals including decimals greater than one | A | B- | C+ | N | C | [NAME] | B- | [NAME] | B | A- | C- | B- | C+ | C+
express natural numbers as products of factors and identify multiples | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | A- | N | A- | A- | A | [NAME] | [NAME] | C- | [NAME]
order and represent, add and subtract fractions with the same or related denominators | A- | A- | C- | C- | C | A | A- | [NAME] | A | [NAME] | C+ | A | C | N
represent common percentages and connect them to their fraction and decimal equivalents | C+
use their proficiency with multiplication facts and efficient calculation strategies to multiply large numbers by one- and two-digit numbers and divide by single-digit numbers | B | C | [NAME] | C | C+ | [NAME] | [NAME] | N | A | [NAME] | [NAME] | N | [NAME] | N
check the reasonableness of their calculations using estimation |  | A- | C+ | A | C | A | A- | C | A- | A | [NAME] | A- | C | N
use mathematical modelling to solve financial and other practical problems, formulating and solving problems, choosing arithmetic operations and interpreting results in terms of the situation
apply properties of numbers and operations to find unknown values in numerical equations involving multiplication and division |  | C | N | A- | C+ | [NAME] | B | D | A- | A- | N | [NAME] | [NAME] | N
create and use algorithms to identify and explain patterns in the factors and multiples of numbers |  | B | N | B | C+ | [NAME] | B- | C- | A- | [NAME] | N | N | C | N
choose and use appropriate metric units to measure the attributes of length, mass and capacity, and to solve problems involving perimeter and area |  | C+ | C+ | B | C- | [NAME] | B | D | B | B | C+ | B | C | B-
convert between 12- and 24-hour time
estimate, construct and measure angles in degrees |  | A- | A+ | A | N | [NAME] | A | C | B | A | B- | A | C | N
use grid coordinates to locate and move positions
connect objects to their two-dimensional nets
perform and describe the results of transformations and identify any symmetries
plan and conduct statistical investigations that collect nominal and ordinal categorical and discrete numerical data using digital tools
identify the mode and interpret the shape of distributions of data in context
interpret and compare data represented in line graphs
conduct repeated chance experiments, list the possible outcomes, estimate likelihoods and make comparisons between those with and without equally likely outcomes
Average mark |  | B | B- | B | C+ | A- | B | C- | A- | [NAME] | C+ | B | C | B-
Spreadsheet: 107920d1305057287-filtering-text-using-a-formula-evaluation-calcs
Sheet: Sheet2

 |  |  |  |  | Name | Score | Areas for Training | Identified Training Needs
 |  |  |  |  | Welcome using company name | 0.4
 |  |  |  |  | Effective greeting | 0.6
 |  |  |  |  | Agent introduction including name | 0.7
 |  |  |  |  | Ask customers name | 0.45
 |  |  |  |  | Attempted to resolve all issues within call | 0.67
 |  |  |  |  | Asked clarifying questions | 0.21
 |  |  |  |  | Demonstrated knowledge of products/services | 0.26
 |  |  |  |  | Understand and diagnosed problem | 0.66
 |  |  |  |  | Provide Information | 0.99
 |  |  |  |  | Volume & clarity of agent | 1
 |  |  |  |  | Interruption of customer during call | 0.55
 |  |  |  |  | Focus of agent during call | 0.5
 |  |  |  |  | Formality of agent during call | 0.34
 |  |  |  |  | Used the 'phone smile' | 0.34
 |  |  |  |  | Avoided silence / pauses during call | 0.77
 |  |  |  |  | Requested permission to put on hold | 0.8
 |  |  |  |  | Used mute procedure effectively | 0.32
 |  |  |  |  | Thanked customer for being on hold | 0.1
 |  |  |  |  | Used correct applications effectively | 0
 |  |  |  |  | Correctly escalated issues through [NAME] | 0.24
 |  |  |  |  | Offer to assist with any other issue | 0.55
 |  |  |  |  | Close by thanking customer using company name | 0.09
Spreadsheet: 133594d1324492662-count-unique-values-in-three-columns-depending-on-multiple-values-sample
Sheet: Sheet1

Statut | Semaine | Date début | Hr | Tech | Tech | Tech | Unique count Names | Day/Night work
menu | Auto | [NAME]/jj | 24h00 | menu | menu | menu
[NAME] |  | 2011-10-07 00:00:00 | 8h00 | AM | AM | AnC
Attente NI |  | 2011-10-07 00:00:00 | 8h00 | AuC | AuC | BR
Showstopper |  | 2011-10-12 00:00:00 | 00h01 | AnC | AnC
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | BO | BO
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | SJ | SJ | NB
Complété |  | 2011-10-12 00:00:00 | 8h00 | JMA | JMA | DV
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | SJ | SJ
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | GL | GL
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | MP | MP | AO
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | AnC | AnC | AuC
[NAME] |  | 2011-10-25 00:00:00 | 00h01 | PC | PC
[NAME] |  | 2011-10-25 00:00:00 | 00h01 | BR | BR
[NAME] |  | 2011-10-25 00:00:00 | 00h01 | AnC | AnC
[NAME] |  | 2011-10-25 00:00:00 | 8h00 | AnC | AnC
Spreadsheet: 839666d1692143925-countifs-formula-for-filtered-list-to-find-unique-values-ignore-hidden-rows-test
Sheet: Sheet1

Type | Name | Amount | Manager
Normal | Audi | 6 | [NAME]
Normal | Audi | 5 | [NAME]
Normal | Mercedes | 15 | [NAME]
Normal | Mercedes | 9 | [NAME]
Special | BMW | 4 | [NAME]
Special | BMW | 3 | [NAME]
Special | Audi | 2 | [NAME]
Special | Honda | 10 | [NAME]
Special | Honda | 10 | [NAME]
Unique Count |  |  |  | B12=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(OFFSET(B1,1,0):B11,ROW(OFFSET(B1,1,0):B11)-ROW(OFFSET(B1,1,0)),,1)), IF(OFFSET(B1,1,0):B11>"",MATCH("~"&OFFSET(B1,1,0):B11,OFFSET(B1,1,0):B11&"",0))),ROW(OFFSET(B1,1,0):B11)-ROW(OFFSET(B1,1,0))+1),1))
Normal
Special
Normal & Special | 1
Spreadsheet: 9e12236c-4e92-43b8-b8d9-52b91229f067
Sheet: ENGL 473

COURSE ASSESSMENT MATRIX
Engl 473 Scholarly Project Prerequisites:  Engl 113, Senior Standing English and Communication Studies majors engaged in a scholarly project have opportunities to explore various areas of interest. Students who are interested in doing a scholarly project are requested to contact full-time faculty in the Humanities and Social Science Department. Instructor and student will collaborate in organizing a scholarly project in the field-of-interest of the latter.  3 credits
Goal:  The goal of this course is to engage English and Communication Studies majors in a scholarly project to explore an area of interest.
Objective | Assessment Method | Desired Result | Corrective Action
Develop a project of interest. | Weekly Assignments                                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                       80% students pass writing assignments | [NAME]Revise Weekly Assignments                      Revise Rubrics
Date | Form of Assessment and Actions Taken
Spring 2011 | Syllabus Reviewed --Mainly looked to see that all sections on checklist were present.  Scheduled to review content during the Fall 2011 semester.
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Spreadsheet: 754117d1635953012-search-the-nearest-number-in-a-range-with-a-criteria-test-file_mit_neuer_formel_2
Sheet: Tabelle1

Eingabe-Parameter |  |  |  | [NAME], wo ein Getriebe sitzen kann |  |  | [NAME] auf dem Kragarm | KL | Getriebe | PA | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | [NAME] PA | Kontrolle Trackerlänge
 |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
Modulbreite | 1134 |  |  | zwischen |  |  | 1
Modulabstand | 16
Stringlänge | 30
Pfostenanzahl | 6
[NAME] | 50
Breite Getriebe | 250 | ("Tabu-Zone" = 2 x 125)
Trackerlänge (berechnet)
Pfostenabstand PA (theoretisch opt.) |  | (bei KL = 0,35 * PA)
[NAME] (theoretisch opt.) |  | (Kontrolle: |  | (inkl. [NAME])
Pfostenabstand PA ([NAME]. rechts)
[NAME] ([NAME]. rechts)
Spreadsheet: 800949d1666008038-dynamic-formula-that-subtracts-last-column-from-second-last-column-in-the-grand-total-line-pivothelp
Sheet: Pivot

Sum of Numer of Accounts | Column Labels
Row Labels | 1 | 2 | 5 | 10 | 15 | 20
[NAME] | 16 | 5
Jery |  |  | 15 | 63 | 4 | 3
[NAME] |  |  |  |  | 50
[NAME] |  |  | 3
Grand Total | 16 | 5 | 18 | 63 | 54 | 3
Scenario:
Each week we will be adding a week which will expand the columns.  I would like some sort of a dynamic function that as the pivot table rows it would look at the Grand Total line and subtract
the last column from the second last column.  So in this case it would be 3 - 54.
Spreadsheet: 32991d1229188326-data-validation-from-2-list-and-in-alpha-order-sortedlistfromformula
Sheet: Sheet3

Original List |  | Data Validation List
hhh |  | a |  |  | Data Validation
c |  | aa
f |  | c
mmm |  | cc
s |  | e
e |  | f
w |  | f |  | C2 has {=INDEX($A$2:$A$26,MATCH(SMALL(COUNTIF($A$2:$A$26,"<"&$A$2:$A$26),ROW(C2)),COUNTIF($A$2:$A$26,"<"&$A$2:$A$26),0))}
s |  | g
a |  | h |  | This is an array formula, you will have to use the keys Ctrl & Shift & Enter instead of just pressing the enter key when entering the formula
q |  | hhh |  | Notice the braces around the formula, this indicates an array formula, the braces show when you use the keys Ctrl & Shift & Enter
w |  | j
r |  | l
t |  | m
g |  | mmm
f |  | p
cc |  | q
aa |  | r
m |  | s
j |  | s
h |  | t
y |  | w
l |  | w
p |  | y
z |  | z
Spreadsheet: 820097d1677860719-skip-transferring-rows-with-certain-values-sample-spreadsheet
Sheet: Input

Count# | Document# | Scope Impact | Status
1 | 1 | Will comply | Closed
2 | 1 | Adder | Open
3 | 3 | Adder | Open
4 | 3 | Not applicable | Closed
5 | 3 | Adder | Open
6 | 3 | Not applicable | Closed
7 | 8 | Not applicable | Open
8 | 8 | Not applicable | Open
9 | 8 | Adder | Open
10 | 8 | None | Closed
11 | 9 | None | Open
12 | 12 | Adder | Open
13 | 12 | Adder | Open
14 | 12 | None | Closed
15 | 15 | Will comply | Closed
16 | 15 | None | Closed
17 | 18 | Not applicable | Closed
18 | 18 | Not applicable | Open
19 | 18 | Not applicable | Closed
20 | 19 | Adder | Open
Spreadsheet: 468161d1467146916-how-to-look-up-column-and-row-headings-that-match-table-value-sample
Sheet: 1 team sheet

 | Team1
1 | 16:45 - 17:00 | Football
2 | 17:15 - 17:30 | Cube
3 | 17:45 - 18:00 | Tie game
4 | 18:15 - 18:30 | Puzzle
 |  | Break
5 | 19:15 - 19:30 | SUP
6 | 19:45 - 20:00 | [NAME]
7 | 20:15 - 20:30 | Catapult
8 | 20:45 - 21:00 | Disk Golf
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 58538 | 63848
2 | 58642 | 55697
3 | 58406 | 59792
4 | 59692 | 63944
5 | 46721 | 47218
6 | 54155 | 54685
7 | 64066 | 62444
8 | 58452 | 62839
9 | 59525 | 62898
10 | 58572 | 62898
11 | 64462 | 63297
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 14916.9
2001-09-11 00:00:00
CBS Volume
 |  |  | 5234
Spreadsheet: benjamin_rogers__1039__Consolidated 6 Peaker-051800
Sheet: Allocation

ALLOCATION
Project |  | By Project Cost |  | By Cashflow
Brownsville |  | 0.125039438479223 |  | 0.1550182327305518
Caledonia |  | 0.1511835224699338 |  | 0.1560578076182236
New Albany |  | 0.145392174776267 |  | 0.1194463322642859
Sub Total
[NAME] |  | 0.170742065516558 |  | 0.1761136938171022
Wheatland |  | 0.1561848046993598 |  | 0.1707348783344037
[NAME] |  | 0.2514579940586584 |  | 0.2226290552354327
Sub Total
Total
[NAME]
Franchise Tax - Brownsville, Caledonia, New Albany, Gleason, Wheatland
Solve Equity
Spreadsheet: 6a1cfa9b-15e3-4e17-8120-83e1bd668117
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Table S6: Protein abundance of the various tRNA synthetases | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | and the stechiometry of the different amino acids (downloaded from the work of [NAME]. 2003).  ALA and VAL tRNA synthetases have high levels
 |  | of protein abundance and the aminoacids exhibit a high concentration in the yeast cell. These  factors also make the translation
 |  | of ALA and VAL more efficient.
 |  | Data that do not appear in our dataset are denoted by ###
 | Ctoplasmatic | Cytosolic | PA - YEPD | PA - SD | Mitochondrial | PA - YEPD | PA - SD | Bio-mass (stechiometry)
1) ASN | DED81 - YHR019C | asparaginyl-tRNA synthetase | ### | ### | SLM5 - YCR024C | 0 | 0 | (0.1017) [NAME]
2) ASP | DPS1 - YLL018C | aspartyl-tRNA synthetase | 1555 | 1306 | MSD1 - YPL104W | 0 | 0 | (0.2975) asp-L
3) GLY | GRS1 - YBR121C | Glycyl-tRNA Synthase | 2608 | 2160 | GRS1 - YBR121C | 2608 | 2160 | (0.2904) gly
4)  HIS | HTS1 -  YPR033C | histidyl-tRNA synthetase | 1119 | 777 | HTS1 -  YPR033C | 1119.5 | 777 | (0.0663) his-L
5)  ILE | ILS1 -  YBL076C | IsoLeucine-tRNA Synthetase | 3489 | 3530 | ISM1 -   YPL040C | 0 | 0 | (0.1927) ile-L
8) LEU | CDC60 - YPL160W | leucyl-tRNA synthetase | 3516 | 2858 | [NAME] | 0 | 0 | (0.2964)leu-L
7) LYS | KRS1 - YDR037W | lysyl-tRNA synthetase | ## | ## | MSK1- YNL073W | 0 | 84.5 | (0.2862) lys-L
8) MET | MES1 - YGR264C | methionyl-tRNA synthetase | 3215 | ## | MSM1 - YGR171C | 0 | 0 | (0.0507) met-L
9) SER | SES1 -  YDR023W | [NAME] synthetase | 2307 | 1773 | DIA4   - YHR011W | 0 | 0 | ((0.1854) ser-L
10) THR | THS1 - YIL078W | threoninyl-tRNA synthetase | 1795 | 1570 | [NAME] – [NAME] | 0 | 0 | (0.1914) [NAME]
11) TRP | WRS1 - YOL097C | tryptophanyl-tRNA synthetase | 943 | 836 | MSW1 -  YDR268W | ## | ## | (0.0284) trp-L
12)  TYR | TYS1 -  YGR185C | tyrosyl-tRNA synthetase | 1705 | 1474 | MSY1 - YPL097W | 52 | 86 | (0.102) tyr-L
13)  VAL | VAS1 - YGR094W | valyl-tRNA synthetase | 2485 | 2574 | VAS1 - YGR094W | 2485 | 2574 | (0.2646) val-L
14)  GLU | GUS1 - YGL245W | GlUtamyl-tRNA Synthetase | 2527 | 1950 | MSE1 - YOL033W | 0 | 0 | (0.3018) [NAME]
15) ALA | ALA1 – YOR335C | Alanyl-tRNA synthetase | 3562 | 2770 | ALA1 – YOR335C | 3562 | 2770 | (0.4588) ala-L
16) [NAME] | YNL247W | Cysteinyl-tRNA synthetase | 522 | 458 | [NAME] ? | ## | ## | (0.0066) [NAME]
17) PHE | FRS   - YLR060W | Phenylalanyl-tRNA synthetase, beta subunit, cytosolic | 1321 | 1242 | MSF1- YPR047W | 0 | 0 | (0.1339) phe-L
18) ARG | - YDR341C | [NAME]-tRNA synthetase, cytosolic | ## | ## | MSR1 -   YHR091C | 0 | 0 | (0.1607) arg-L
19) GLN | GLN4 - YOR168w | Glutaminyl-tRNA synthetase | 1489 | 1088 | ? |  |  | (0.1054) gln-L
20) PRO | YER087w | Putative prolyl-tRNA synthetase | ## | ## | YER087w ? | ## | ## | (0.1647) [NAME]
Spreadsheet: 584813d1533410158-just-like-database-vampzzz-just-like-database
Sheet: Sheet1

Name | [NAME] | [NAME] | Something | Comment
[NAME] | Truck | Black
[NAME] | Truck | Red
[NAME] | Car | Yellow
[NAME] | Car | Blue
[NAME] | Van | Green
[NAME] | Bike | yellow
Spreadsheet: 132533d1323804921-weekly-bill-caculator-bill-forcaster
Sheet: Sheet1

Due Day | [NAME] | Vendor |  | 2010-11-28 00:00:00 | 2010-12-05 00:00:00 | 2010-12-12 00:00:00 | 2010-12-19 00:00:00 | 2010-12-26 00:00:00 | 2011-01-02 00:00:00 | 2011-01-09 00:00:00 | 2011-01-16 00:00:00 | 2011-01-23 00:00:00 | 2011-01-30 00:00:00 | 2011-02-06 00:00:00 | 2011-02-13 00:00:00 | 2011-02-20 00:00:00
1 | 40 | Cell
2 | 30 | Rent
2 | 15 | Electricity
6 | 50 | Parking
9 | 80 | Mortgage
28 | 10 | Water
Spreadsheet: 170274d1343224995-pull-data-from-another-sheet-if-specified-cells-match-sample
Sheet: Sheet2

School Name | Address | Phone | Principal 2012
Adams | main st | 123-4567 | [NAME]
Byant | oak st | 123-4568 | Marks
[NAME] | elm st | 123-4569 | Murphey
Washington | birch st | 123-4570 | [NAME]
Spreadsheet: 679975d1590712524-calculating-a-percentage-closure-rate-for-calls-test-sheet
Sheet: Sheet1

Case Closed | [NAME] |  |  |  |  |  | Case Closed | [NAME] |  |  |  |  |  | Case Closed | [NAME]
CLOSED | [NAME] |  | Number of Cases by Staff |  | Percent Close Rate |  | CLOSED | Chief Deputy [NAME] |  | Number of Cases by Staff |  | Percent Close Rate |  | CLOSED | [NAME], Chief Deputy |  | Number of Cases by Staff |  | Percent Close Rate
CLOSED | [NAME] |  | Coroner Kiessling |  |  |  | CLOSED | Chief Deputy [NAME] |  | Coroner Kiessling |  |  |  | CLOSED | [NAME], Chief Deputy |  | Kiessling, Coroner
 | [NAME] |  | Chief Deputy [NAME] |  |  |  |  | Chief Deputy [NAME] |  | Chief Deputy [NAME] |  |  |  |  | [NAME], Chief Deputy |  | [NAME], Chief Deputy
CLOSED | Forney |  | Deputy [NAME] |  |  |  | CLOSED | Deputy [NAME] |  | Deputy [NAME] |  |  |  | CLOSED | Forney, Deputy |  | Woodruff, Deputy
 | Nickles |  | Deputy Nickles |  |  |  |  | Deputy Nickles |  | Deputy Nickles |  |  |  |  | Nickles, Deputy |  | Nickles, Deputy
CLOSED | Nickles |  | Deputy [NAME] |  |  |  | CLOSED | Deputy Nickles |  | Deputy [NAME] |  |  |  | CLOSED | Nickles, Deputy |  | Forney, Deputy
CLOSED | Woodruff |  | Deputy [NAME] |  |  |  | CLOSED | Deputy [NAME] |  | Deputy [NAME] |  |  |  | CLOSED | Woodruff, Deputy |  | [NAME], Deputy
CLOSED | Woodruff |  | Deputy Hughes |  |  |  | CLOSED | Deputy [NAME] |  | Deputy Hughes |  |  |  | CLOSED | Woodruff, Deputy |  | Hughes, Deputy
CLOSED | [NAME] |  | Deputy Turner |  |  |  | CLOSED | Chief Deputy [NAME] |  | Deputy Turner |  |  |  | CLOSED | [NAME], Chief Deputy |  | Turner, Deputy
 | [NAME] |  | Deputy Whitford |  |  |  |  | Chief Deputy [NAME] |  | Deputy Whitford |  |  |  |  | [NAME], Chief Deputy |  | Whitford, Deputy
 | Woodruff |  |  |  |  |  |  | Deputy [NAME] |  |  |  |  |  |  | Woodruff, Deputy
CLOSED | [NAME] |  |  |  |  |  | CLOSED | Chief Deputy [NAME] |  |  |  |  |  | CLOSED | [NAME], Chief Deputy
 | [NAME] |  |  |  |  |  |  | Deputy [NAME] |  |  |  |  |  |  | [NAME], Deputy
CLOSED | [NAME] |  |  |  |  |  | CLOSED | Chief Deputy [NAME] |  |  |  |  |  | CLOSED | [NAME], Chief Deputy
 | [NAME] |  |  |  |  |  |  | Chief Deputy [NAME] |  |  |  |  |  |  | [NAME], Chief Deputy
Spreadsheet: 75412d1275996825-calculate-weighted-average-with-missing-values-weighted-average
Sheet: Weighted

Branch | Jan | Feb | Mar | Apr | May | Weighted Average |  | 0.6 | 0.2 | 0.2
Cork | 0 | 0.2 | 0.3 | 0.4 | 0.5 | 0.4000000000000001
Dublin | 0.5 | 0.4 | 0.3 | 0.2 | 0 | 0.4000000000000001
Wexford | n/a | 0.1 | n/a | 0.2 | 0.5 | 0.2666666666666667
Galway | 0.1 | n/a | 0.2 | 0.3 | n/a | 0.2
Clare | 0.3 | 0.2 | n/a | 0.2 | 0.4 | 0.3000000000000001
Waterford | 0.1 | 0.3 | 0.5 | n/a | n/a | 0.3
Limerick | n/a | n/a | n/a | 0.2 | 0.4 | #N/A
Kildare | n/a | n/a | 0.2 | 0.3 | 0.4 | 0.3000000000000001
Mayo | 0.5 | 0.2 | n/a | n/a | 0.3 | 0.3333333333333333
Spreadsheet: bf975939-552e-4b35-a619-3308909b44db
Sheet: Example 1.1

Example 1.1 - A study is conducted to measure monthly soil erosion from a research plot.  Given the measured and predicted data, does the measured data seem intuitively correct and which predictive method is best?
By: | [NAME]
Date: | 2010-01-18 00:00:00
Table 1.8 from Environmental Hydrology
 |  | Method 1 |  | Method 2
Month | Measured Soil Loss | Predicted Loss | Residual Loss | Predicted Loss | Residual Loss
Jan | 0 | 0 |  | 0.1
Feb | 0.1 | 0 |  | 0
Mar | 0.3 | 0.3 |  | 0.3
Apr | 0.6 | 0.9 |  | 0.5
May | 0.5 | 0.7 |  | 0.8
Jun | 0.4 | 0.5 |  | 0.4
Jul | 0.3 | 0.3 |  | 0.2
Aug | 0.2 | 0.1 |  | 0.1
Sep | 0.1 | 0 |  | 0.1
Oct | 0.2 | 0.1 |  | 0.1
Nov | 0.2 | 0.1 |  | 0.1
Dec | 0.1 | 0 |  | 0.3
Mean
Solution Steps
1 | Calculate residual losses
2 | Graph measured soil and predicted erosion (figure 1.9)
2 | Graph measured soil erosion vs. residual (figure 1.10)
3 | Explain in your own words: 1)how the models perform over time and 2) which method is better.
Spreadsheet: 733499d1621601735-using-a-sum-array-to-grade-homework-with-multiple-correct-answers-best-practice-for-grading-multiple-correct-answers-with-sum
Sheet: Example Gradebook 101

Class | Seat Number | Name | Overall Grade | Assignment A /3 | Assignment B /2 | Assignment C /1
101 | 1 | [NAME]
101 | 2 | [NAME]
101 | 3 | [NAME]
101 | 4 | [NAME]
101 | 5 | [NAME]
101 | 6 | [NAME]
101 | 7 | Greg |  |  |  |  | <this guy should have a '2' for Assignment B
101 | 8 | Horace
101 | 9 | Iguana
101 | 10 | [NAME]
Total
Spreadsheet: 135887d1326293373-sumif-and-with-a-filter-excel-upload-paste-into-pivot-table
Sheet: Front Sheet £

ALM
ALM | test 40 Expenses
 |  | £
 | Press Cuttings/Media Monitoring | 233.1
 | [NAME] | 0
 | Travel | 50.88
 | Conference Call | 0
 | Entertainment | 93.03999999999999
 | Accommodation | 0
 | Share Price Listing | 0
 | Licensing Fee | 0
 | Subsistence | 0
 | Miscellaneous | 0
 | Grand Total | 377.02
 | Grand Total | 377.02
Spreadsheet: 819333d1677433404-plot-graph-without-blank-values-test3
Sheet: INPUT

# |  | distance (m1) | 0 | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500 | 1550 | 1600 | 1650 | 1700 | 1750 | 1800 | 1850 | 1900 | 1950 | 2000 | 2050 | 2100 | 2150 | 2200 | 2250 | 2300 | 2350 | 2400 | 2450 | 2500 | 2550 | 2600 | 2650 | 2700 | 2750 | 2800 | 2850 | 2900 | 2950 | 3000 | 3050 | 3100 | 3150 | 3200 | 3250 | 3300 | 3350 | 3400 | 3450 | 3500 | 3550 | 3600 | 3650 | 3700 | 3750 | 3800 | 3850 | 3900 | 3950 | 4000 | 4050 | 4100 | 4150 | 4200 | 4250 | 4300 | 4350 | 4400 | 4450 | 4500 | 4550 | 4600 | 4650 | 4700 | 4750 | 4800 | 4850 | 4900 | 4950 | 5000 | 5050 | 5100 | 5150 | 5200 | 5250 | 5300 | 5350 | 5400 | 5450 | 5500 | 5550 | 5600 | 5650 | 5700 | 5750 | 5800 | 5850 | 5900 | 5950 | 6000
 |  | hits (#)
1 | test |  |  |  |  |  |  | 400 | 380 | 358 | 330 | 308 | 285 | 250 | 228
2
3
4
5
Spreadsheet: 689042d1596097637-offset-function-to-change-based-on-the-number-of-days-per-week-daily-report
Sheet: STATS 

 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5
# OF DAYS IN WEEK | 5 | 7 | 7 | 7 | 5
ROOM NIGHTS SOLD
ROOM REVENUE
MARKET REVENUE