tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b9a47419-fc87-4f2c-8bdc-4d1969285da5
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
[NAME] | Test | [NAME] | Hepatitis B Surface Antibody Monitor, Post-Transplant, Serum | HBs Ab Monitor, Post-transplant, S | Chemiluminescent Immunoassay (CIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Additional Information: Date of draw is required. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Plasma | Not applicable | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86317 |  |  |  |  | Rochester
[NAME] | [NAME] | SST | Serum SST |  |  |  | Frozen
[NAME] | Result | [NAME] | HBs Ab Monitor, Post-transplant, S | HBs Ab Monitor, Post-transplant, S | Alphanumeric |  |  |  |  | mIU/mL |  |  |  |  |  |  |  |  |  | 32019-2
Spreadsheet: 220209d1363099305-using-formula-to-answer-a-maths-question-transport-card-split
Sheet: START

 |  |  |  | Payment Date | 2013-03-11 00:00:00
 |  |  |  | Transaction Limit | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 |  |  |  | Value Limit | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000
Payment Narrative | Payment Value | Payment Date |  |  | Card 1 | Card 2 | Card 3 | Card 4 | Card 5 | Card 6 | Card 7 | Card 8
[NAME] | 1000 | 2013-03-11 00:00:00
[NAME] | 2000 | 2013-03-11 00:00:00
jones | 1850 | 2013-03-11 00:00:00
grandad | 1000 | 2013-03-11 00:00:00
grumpy | 1500 | 2013-03-11 00:00:00
sold | 1200 | 2013-03-11 00:00:00
parents | 3000 | 2013-03-11 00:00:00
tranport | 1000 | 2013-03-11 00:00:00
should | 1500 | 2013-03-11 00:00:00
pick | 1200 | 2013-03-11 00:00:00
pig | 3000 | 2013-03-11 00:00:00
dog | 1000 | 2013-03-11 00:00:00
short | 1500 | 2013-03-11 00:00:00
tall | 600 | 2013-03-11 00:00:00
tree | 1150 | 2013-03-11 00:00:00
space | 500 | 2013-03-11 00:00:00
Leaves | 2000 | 2013-03-11 00:00:00
roots | 500 | 2013-03-12 00:00:00
Spreadsheet: 7977d3bf-e206-4573-8c01-c8cc0433b33f
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Physical Education
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 493995d1482061674-distributing-cell-value-to-specific-cells-randomly-h3ct0r-bsb-
Sheet: Sheet1

25 | 3 | 3 | 2 | 9 | 4 | 4
33 | 3 | 4 | 3 | 12 | 6 | 5
41 | 4 | 5 | 3 | 16 | 7 | 6
19 | 2 | 3 | 1 | 7 | 3 | 3
 | 0.2288919818924879 | 0.3009717322525621 | 0.1731167487750835 | 0.8593570786260549 | 0.3874304968514782 | 0.3225991811043126
Spreadsheet: 64680d1265476521-check-a-column-for-certain-characters-characters
Sheet: Sheet1

BGW | R | 0 | #N/A | 30
3UG |  | 0 | 3
WWU |  | 0 | #N/A
1BR |  | 1 | 1
UUBRG |  | 1 | #N/A
WUBRG |  | 1 | #N/A
7UUGGRRR |  | 3 | 7
20UGGRRR |  | 3 | 20
2UGGRRR |  | 3 | 2
20UGGRRR |  | 3 | 20
2UGGRRR |  | 3 | 2
19UGGRRR |  | 3 | 19
2UGGRRR |  | 3 | 2
20UGGRRR |  | 3 | 20
2UGGRRR |  | 3 | 2
Spreadsheet: 42ce7792-7e32-4963-af63-0630577b5a96
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Paramount | 667068485325 | Various | Prince Of Egypt | 1999-09-01 | DVD | Children | 7.99 | Y | Available
Paramount | 667068645224 | Various | [NAME]: King Of Dreams (D-Se-Ws) | 2008-12-02 | DVD | Children | 7.99 | Y | Available
Paramount | 97368748347 | Peanuts | Cbs: Boy Named [NAME] (D-Se) | 2008-12-02 | DVD | Children | 14.99 | Y | Available
Paramount | 97368945241 | Various | Let'S Hear It: The Laurie Berkner Band | 2010-10-05 | DVD | Children | 17.99 | Y | Available
Paramount | 841887051989 | Various | [NAME] The Jet Plane: [NAME] Sensational Mystery | 2009-09-01 | DVD | Children | 5.99 | Y | Available
Paramount | 841887052184 | Various | [NAME] The Jet Plane: [NAME] | 2009-09-01 | DVD | Children | 5.99 | Y | Available
Paramount | 32429032638 | Various | [NAME] Web (1973) / Cw2 (Side By Side 2Pk) | 2008-04-01 | DVD | Children | 19.99 | Y | Available
Paramount | 667068994629 | Various | Spirit: Stallion Of The Cimarron (Wide Screen) | 2008-04-01 | DVD | Children | 14.99 | Y | Available
Paramount | 32429032492 | [NAME] | Big Sister Dora / City Of Lost Toys (Side By Side 2Pk) | 2008-04-01 | DVD | Children | 19.99 | Y | Available
Paramount | 32429032478 | Various | Springtime For Max & Ruby / Afternnon With Max & Ruby (Side By Side 2Pk) | 2008-04-01 | DVD | Children | 19.99 | Y | Available
Spreadsheet: 871790d1718203881-teacher-markbook-letter-grade-to-numerical-value-average-excel-markbook-ans
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 | C+ | B- | C+ | N | C | [NAME] | B- | [NAME] | B | A- | C- | B- | C+ | C+
express natural numbers as products of factors and identify multiples | A- | [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 | C+ | 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
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 | N | 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 | N | 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 | N | 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+ | 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 | B- | 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
Spreadsheet: 830231d1684812340-automate-totals-from-employees-entering-data-book1-1-
Sheet: Expenses Trips (2)

 |  | INPUT AREA FOR STAFF
 |  | Enter Trip number (1, 2, 3…) | Month Needed | Transport | Taskforce days | Room | Room  Cost | Meals  Cost | Automatic calculation | Automatic calculation | Automatic calculation | 12 | 11.5 | 11 | 10.5 | 10 | 9.5 | 9 | 8.5 | 8 | 7.5 | 7 | 6.5 | 6 | 5.5 | 5 | 4.5 | 4 | 3.5 | 3 | 2.5 | 2 | 1.5 | 1 | 0.5 | Opening
 | Position | Trip Number | Month out | Plane/car | Work Days | Nights | Per Night | Per Day | Room & Meals Cost | Transportation Cost | TOTAL  Cost | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months
5.101 | Position 1 | 1 | 12 | 5000 | 5 | 4 | 2000 | 300
 | Position 1 | 2 | 8 | 5000 | 5 | 4 | 2000 | 300
 | Position 1 | 3 | 6 | 5000 | 6 | 5 | 2000 | 300
 | Position 2 | 1 | 2 | 5000 | 14 | 13 | 2000 | 300
 | Position 2 | 2 | 1 | 5000 | 7 | 6 | 2000 | 300
 |  | DESIRED OUTPUT
 |  |  |  | 12 | 11.5 | 11 | 10.5 | 10 | 9.5 | 9 | 8.5 | 8 | 7.5 | 7 | 6.5 | 6 | 5.5 | 5 | 4.5 | 4 | 3.5 | 3 | 2.5 | 2 | 1.5 | 1 | 0.5 | Opening
 | Position | total trips | Total Trips days | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months
 | Position 1 | 3 | 26 | 14500 |  |  |  |  |  |  |  | 14500 |  |  |  | 16800
 | Position 2 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35200 |  | 19100
Spreadsheet: 111713d1308046212-count-multiple-criteria-multiple-sheets-and-date-range-report-template
Sheet: DATA SHEET

[NAME] | End Dates | Holidays
2011-04-04 00:00:00 | 2011-04-10 00:00:00 | 2010-05-07 00:00:00
2011-04-11 00:00:00 | 2011-04-17 00:00:00 | 2010-12-28 00:00:00
2011-04-18 00:00:00 | 2011-04-24 00:00:00 | 2010-12-29 00:00:00
2011-04-25 00:00:00 | 2011-05-01 00:00:00 | 2011-01-03 00:00:00
2011-04-04 00:00:00 | 2011-05-01 00:00:00 | 2011-04-22 00:00:00
 |  | 2011-04-25 00:00:00
 |  | 2011-04-29 00:00:00
 |  | 2011-05-02 00:00:00
 |  | 2011-05-30 00:00:00
 |  | 2011-08-29 00:00:00
Spreadsheet: 79a22f95-0bb2-4441-a014-b6039bb1f7c8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-09-14 10:00:08.800000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 102.038 | 101.913 | 101.788 | 101.413
3.75 | 101.909 | 101.784 | 101.659 | 101.284 |  | Note: | Refer To Price [NAME]
3.625 | 101.357 | 101.232 | 101.107 | 100.732 |  |  | For all Price Adjs
3.5 | 100.565 | 100.44 | 100.315 | 99.69
3.375 | 99.746 | 99.621 | 99.496 | 98.871
3.25 | 98.905 | 98.78 | 98.655 | 98.03
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.051 | 101.926 | 101.801 | 101.426
3.25 | 101.772 | 101.647 | 101.522 | 101.147
3.125 | 101.474 | 101.349 | 101.224 | 100.849
3 | 101.039 | 100.914 | 100.789 | 100.414
2.875 | 100.37 | 100.245 | 100.12 | 99.495
2.75 | 99.718 | 99.593 | 99.468 | 98.843
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-09-28 10:00:08.800000
30 DAY | 2012-10-13 10:00:08.800000
45 DAY | 2012-10-28 10:00:08.800000
60 DAY | 2012-11-12 10:00:08.800000
90 DAY | 2012-12-12 10:00:08.800000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 61096d1261722797-find-minimum-sum-if-no-minimum-number-in-row-711894-find-minimum-sum-if-no-minimum-number-in-row
Sheet: Sheet1

321 | <--- minimum SUM if no minimum number in row
365 |  |  |  |  |  |  |  |  |  |  | SUM | Min number
 |  | 46 | 60 | 68 | 34 | 62 | 31 | 37 | 72 | 10 | 420 | 10 | 9 | 0 | 0 |  |  |  | 3.697296376497263e+197
 |  | 10 | 30 | 58 | 21 | 51 | 68 | 82 | 65 | 10 | 395 |  | 1 | 0 | 0 |  |  |  | 3.697296376497263e+197
 |  | 22 | 62 | 20 | 58 | 33 | 58 | 74 | 72 |  | 399 |  | #N/A | 0 | 0 |  |  |  | 399
 |  | 63 | 81 | 46 | 47 | 55 | 68 | 66 | 66 | 10 | 502 |  | 9 | 0 | 0 |  |  |  | 3.697296376497263e+197
 |  | 59 | 46 | 58 | 69 | 30 | 10 | 95 | 52 |  | 419 |  | 6 | 0 | 0 |  |  |  | 3.697296376497263e+197
 |  | 55 | 17 | 59 | 92 | 93 | 93 | 70 | 90 | 10 | 579 |  | 9 | 0 | 0 |  |  |  | 3.697296376497263e+197
 |  | 96 | 76 | 21 | 90 | 97 | 15 | 44 | 59 |  | 498 |  | #N/A | 0 | 0 |  |  |  | 498
 |  | 17 | 99 | 84 | 24 | 53 | 28 | 92 | 75 | 10 | 482 |  | 9 | 0 | 0 |  |  |  | 3.697296376497263e+197
 |  | 45 | 22 | 87 | 32 | 12 | 26 | 66 | 21 | 10 | 321 |  | 9 | 1 | 1 |  |  |  | 3.697296376497263e+197
 |  | 18 | 30 | 78 | 90 | 27 | 40 | 59 | 13 | 10 | 365 |  | 9 | 0 | 0 |  |  |  | 3.697296376497263e+197
399 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 399
 |  |  | M | E | R | R | Y |  | C | H | R | I | S | T | M | A | S
 | A | N | D |  | H | A | P | P | Y |  | N | E | W |  | Y | E | A | R
 |  | by Zbor
Spreadsheet: 801387d1666184422-comment-based-on-criteria-exercise_-aligw
Sheet: Sheet1

Part | Component | expected result | AliGW
55135100007000 | H116658000 | basic
55135100007000 | H117616001 | basic
55135100007000 | H159490000 | basic
55135100007000 | H172135000 | basic
55135100007000 | H172141000 | basic
55135100007000 | H500046000 | basic
55135100007000 | H740834000 | basic
55135100007000 | H740838000 | basic
55135100007000 | H740932000 | basic
55135100007000 | H742202000 | basic
55135100007000 | H742203000 | basic
55135100007000 | K109870001 | basic
55135100028000 | H103067001 | basic
55135100028000 | H103077000 | basic
55135100028000 | H104919001 | basic
55135100028000 | H116658000 | basic
55135100028000 | H192163000 | basic
55135100028000 | H741442000 | basic
55135100028000 | H741557000 | basic
55135109729000 | 5120850000 | complex
55135109729000 | H102990000 | complex
55135109729000 | H103090000 | complex
55135109729000 | H116292000 | complex
55135109729000 | H500046000 | complex
55135109729000 | H740604000 | complex
55135109729000 | H740605000 | complex
55135109729000 | H740939000 | complex
55135109729000 | H742123000 | complex
55135109729000 | K109870001 | complex
55135109729000 | K116920001 | complex
Spreadsheet: 98110d1297167437-need-help-with-the-way-excel-connects-to-cells-in-my-woorkbook-examples
Sheet: Journal

Company Code
Spreadsheet: kate_symes__18302__EES Variances April 13
Sheet: April

Date | Buy/Sell | Del Pt | Deal # | Total Hrs | Total MWH | Rate | Problem | KATE'S ANSWER
4/1 | Buy | SP-15 | 566424.1 |  | 341 | 125 | Rate should be $125.73 per [NAME]'s schedule | Rate changed to $125.73
4/1 | Buy | Nepool | 302293.1 |  | 625 | 34 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings | This is an East trade - did not originate from our office/I cannot access it in our system
4/1 | Buy | Nepool | 399863.1 |  | 600 | 24.25 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings | This is an East trade - did not originate from our office/I cannot access it in our system
4/1 | Sell | Nepool | 302297.1 |  | 625 | 35 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings | This is an East trade - did not originate from our office/I cannot access it in our system
4/2 | Buy | SP-15 | 566391.1 | off peak | 416 | 125.73 | Total MWh for 566391.1 and 566426.1 off peak should be 599 per [NAME]'s schedule
4/2 | Buy | SP-15 | 566426.1 | off peak | 142.8 | 125 | Rate should be $125.73 per [NAME]'s schedule | Rate changed to $125.73
4/2 | Buy | SP-15 | 566391.1 | on peak | 96 | 220.17 | Total MWh for 566391.1 and 566426.1 on peak should be 331 per [NAME]'s schedule
4/2 | Buy | SP-15 | 566426.1 | on peak | 252.46 | 220 | Rate should be $220.17 per [NAME]'s schedule | Rate changed to $220.17
4/8 | Buy | SP-15 | 573785.1 |  | 115 | 80 | Real time sheet sent to EES has 35 @ $80
4/8 | Buy | SP-15 | 576512.1 |  | 17 | 80 | Real time sheet sent to EES has 35 @ $80
4/9 | Buy | SP-15 | 576512.1 |  | 31 | 80 | Real time sheet sent to EES has 48 @ $80
4/9 | Sell | SP-15 | 573862.1 |  | 0.2 | 107 | EES not showing this deal
4/11 | Buy | SP-15 | 578856.1 |  | 21 | 150 | EES not showing this deal
Spreadsheet: 2a2e48e9-81ef-4ee4-8e72-f38e99cb9342
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: March 7, 2014 (8:01 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 5552b33b-be4f-4e1b-9348-0d11a9c30679
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7402 | 56363 | [NAME] | Briscoe | GBR | 2 | 00:20:07 | 00:02:54 | 01:09:02 | 00:00:00 | 00:00:00 | 1 | 02:15:17
7402 | 57543 | Omer | Straschnow | ISR | 5 | [NAME] | 00:02:28 | 01:07:04 | 00:00:00 | 00:00:00 | 2 | 02:18:18
7402 | 56365 | [NAME] | Glynn | GBR | 4 | 00:22:30 | 00:02:46 | 01:08:18 | 00:00:00 | 00:00:00 | 3 | [NAME]
7402 | 56364 | [NAME] | Gibbons | GBR | 3 | 00:22:25 | 00:03:14 | 01:13:42 | 00:00:00 | 00:00:00 | 4 | 02:21:34
Spreadsheet: 773720d1648024480-wrong-nested-if-formula-ifnesdedformulas
Sheet: Sheet1

Field: | Formula 1: | [NAME] over 1: | Nested 1 and 2:
Not Excelent String
Bad Super String
Bad Ideal String
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: RefWorks

RefWorks (CSA)
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per unit
New Users | 3 | 7 | 21 | 16 | 16 | 7 | 3 | 98 | 9 | 21 | 5 | 6 |  | 11025
Repeat Users | 12 | 4 | 14 | 25 | 37 | 27 | 18 | 33 | 77 | 69 | 49 | 16 |  | 11025
Total Monthly Users | 15 | 11 | 35 | 41 | 53 | 34 | 21 | 131 | 86 | 90 | 54 | 22 |  | 11025 |  | per user
Total Sessions per month | 79 | 25 | 87 | 161 | 236 | 187 | 98 | 351 | 484 | 589 | 192 | 128 |  | 11025 |  | per session
Average Sessions Per User | 5.27 | 2.27 | 2.49 | 3.93 | 4.45 | 5.5 | 4.67 | 2.68 | 5.63 | 6.54 | 3.56 | 5.82 |  | 11025
Total Subscriber References added | 728 | 136 | 144 | 740 | 3492 | 592 | 174 | 617 | 1202 | 1186 | 581 | 464 |  | 11025 |  | per reference added
Average References added per user | 48.53 | 12.36 | 4.11 | 18.05 | 65.89 | 17.41 | 8.29 | 4.71 | 13.98 | 13.18 | 10.76 | 21.09 |  | 11025
COUNTER-Compliant?: | No
Spreadsheet: 1bc52e83-8346-4bc7-95d8-fabfc7f3cb70
Sheet: School Leaver

 | Mathematics Core | Mathematics Full | Additional Mathematics | Mathematics | Applied | Mathematics with Calculus | Mathematics with Statistics |  | School Leavers |  | High School Certificate
1963 |  | 1526 | 658 |  |  |  |  |  |  |  | 2847
1964 | 1 | 1967 | 848 |  |  |  |  |  |  |  | 3604
1965 |  | 2096 | 930 |  |  |  |  |  |  |  | 3683
1966 |  | 2133 | 883 |  |  |  |  |  |  |  | 2156
1967 | 9 | 2275 | 859 |  |  |  |  |  |  |  | 2417
1968 | 124 | 2638 | 1006 |  |  |  |  |  |  |  | 2617
1969 |  | 2915 | 1053 |  |  |  |  |  |  |  | 2886
1970 |  | 3274 | 1178 |  |  |  |  |  |  |  | 2886
1971 | 3 | 3734 | 1303 |  |  |  |  |  |  |  | 2847
1972 |  | 4035 | 1261 |  |  |  |  |  |  |  | 2897
1973 | 19 | 4058 | 1126 |  |  |  |  |  |  |  | 2981
1974 | 92 | 5162 | 1405 |  |  |  |  |  |  |  | 2967
1975 | 27 | 5366 | 1682 |  |  |  |  |  |  |  | 2980
1976 | 8 | 5728 | 2209 |  |  |  |  |  |  |  | 3133
1977 | 252 | 5241 | 2027 |  |  |  |  |  |  |  | 3237
1978 | 71 | 6226 | 2683 |  |  |  |  |  |  |  | 3401
1979 | 95 | 6477 | 3112 |  |  |  |  |  |  |  | 3228
1980 |  |  |  | 6625 | 3957 |  |  |  |  |  | 3599
1981 |  |  |  | 6776 | 4442 |  |  |  |  |  | 3554
1982 |  |  |  | 6488 | 4325 |  |  |  |  |  | 3385
1983 |  |  |  | 6767 | 5004 |  |  |  |  |  | 3387
1984 |  |  |  | 7077 | 5495 |  |  |  |  |  | 3329
1985 |  |  |  | 6975 | 5340 |  |  |  |  |  | 3785
1986 |  |  |  | 7318 | 6097 |  |  |  |  |  | 4904
1987 |  |  |  | 7068 |  |  | 8926 |  |  |  | 6371
1988 |  |  |  | 7819 |  |  | 10691 |  |  |  | 6308
1989 |  |  |  | 8946 |  |  | 12198 |  | 59420 |  | 8310
1990 |  |  |  | 8457 |  |  | 11974 |  | 55437 |  | 8164
1991 |  |  |  | 9011 |  |  | 12549 |  | 52232 |  | 8654
1992 |  |  |  | 10149 |  |  | 13118 |  | 57868 |  | 9450
1993 |  |  |  | 1220 |  | 9489 | 12414 |  | 56240 |  | 6942
1994 |  |  |  | 1105 |  | 9437 | 12232 |  | 56061 |  | 6130
1995 |  |  |  | 596 |  | 9018 | 12460 |  | 53819 |  | 5674
1996 |  |  |  | 4084 |  | 8331 | 11512 |  | 51487 |  | 5778
1997 |  |  |  | 4280 |  | 8213 | 12037 |  | 50193 |  | 6439
1998 |  |  |  | 4387 |  | 7959 | 12032 |  | 51866 |  | 6779
1999 |  |  |  | 4678 |  | 7833 | 11826 |  | 54400 |  | 6501
2000 |  |  |  | 4468 |  | 8096 | 12009 |  | 54633 |  | 5857
2001 |  |  |  | 4262 |  | 8553 | 12120 |  | 53517 |  | 5837
2002 |  |  |  | 3945 |  | 9447 | 13357 |  | 52546 |  | 6147
2003 |  |  |  | 1578 |  | 10708 | 13780 |  | 53471 |  | 7292
2004 |  |  |  | 2704 |  | 8845 | 12802 |  | 55634
2005 |  |  |  | 2777 |  | 7781 | 12349 |  | 57454
2006 |  |  |  | 3828 |  | 7760 | 12557 |  | 56895
2007 |  |  |  | 5451 |  | 7969 | 12811 |  | 56670
2008
2009
2010
http://www.educationcounts.govt.nz/statistics/schooling/july_school_roll_returns/6052
Spreadsheet: 804463d1668088392-extract-data-from-12-different-sheets-into-one-single-column-without-vba-and-powerquerry-test-4-
Sheet: data

Jan |  | Feb
Style No. | Unit Price | Style No. | Unit Price
WTB181693 | 51 | WTE181103 | 302
WTB371652 | 59.1 | WTE181103 | 302
WTB371652 | 59.1 | WTB181657 | 18
WTC181281 | 213 | WTB181657 | 18
WTC181275 | 41.75 | WTB181658 | 16
WTC181304 | 64.6 | WTE181123 | 57
WTC181275 | 41.75 | WTC181314 | 47.2
[NAME] | 38.5 | WTC181314 | 47.2
WTB371647 | 64 | WTC181245 | 20.25
WTC181313 | 87.5 | WTC181245 | 20.25
WTC181313 | 87.5 | WTB181659 | 43.5
WTC181313 | 87.5 | WTB181659 | 43.5
WTB181693 | 51 | WTB181602 | 31.2
WTC181281 | 213 | WTB181602 | 31.2
WTC181304 | 64.6 | WTC181292 | 39
[NAME] | 38.5 | WTC181292 | 39
WTC181260 | 50.5 | WTC181311 | 41
WTC181260 | 50.5 | WTC181311 | 41
WTC181297 | 32.5 | WTC181287 | 46.2
WTC181297 | 32.5 | WTC181287 | 46.2
WTE181121 | 88.9 | WTB181715 | 165
WTE181121 | 88.9 | WTB181715 | 165
WTB181678 | 40 | WTB181723 | 58.4
WTB181678 | 40 | WTB181723 | 58.4
 |  | [NAME] | 85.6
 |  | [NAME] | 85.6