tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840460d1692753579-formula-to-bring-latest-value-related-to-a-reference-example
Sheet: Sheet1

Reference | Date | Value |  |  |  |  |  |  | Reference | W
X | 2023-04-18 00:00:00 | 30 |  |  |  |  |  |  | Value
X | 2023-04-19 00:00:00 | 31
X | 2023-04-20 00:00:00 | 32
X | 2023-04-21 00:00:00 | 33
X | 2023-04-22 00:00:00 | 34
X | 2023-04-23 00:00:00 | 35
X | 2023-04-24 00:00:00 | 36
X | 2023-04-25 00:00:00 | 37
X | 2023-04-26 00:00:00 | 38
X | 2023-04-27 00:00:00 | 39
X | 2023-04-28 00:00:00 | 40
X | 2023-04-29 00:00:00 | 41
X | 2023-04-01 00:00:00 | 42
X | 2023-04-02 00:00:00 | 43
X | 2023-04-03 00:00:00 | 44
X | 2023-04-04 00:00:00 | 45
X | 2023-04-05 00:00:00 | 46
X | 2023-04-06 00:00:00 | 47
X | 2023-04-07 00:00:00 | 48
X | 2023-04-08 00:00:00 | 49
X | 2023-04-09 00:00:00 | 50
X | 2023-04-10 00:00:00 | 51
X | 2023-04-11 00:00:00 | 52
X | 2023-04-12 00:00:00 | 53
X | 2023-04-13 00:00:00 | 54
X | 2023-04-14 00:00:00 | 55
X | 2023-04-15 00:00:00 | 56
X | 2023-04-16 00:00:00 | 57
X | 2023-04-17 00:00:00 | 58
Y | 2023-04-18 00:00:00 | 30
Y | 2023-04-19 00:00:00 | 31
Y | 2023-04-20 00:00:00 | 32
Y | 2023-04-21 00:00:00 | 33
Y | 2023-04-22 00:00:00 | 34
Y | 2023-04-23 00:00:00 | 35
Y | 2023-04-24 00:00:00 | 36
Y | 2023-04-25 00:00:00 | 37
Y | 2023-04-26 00:00:00 | 38
Y | 2023-04-27 00:00:00 | 39
Y | 2023-04-28 00:00:00 | 40
Y | 2023-04-29 00:00:00 | 41
Y | 2023-04-01 00:00:00 | 42
Y | 2023-04-02 00:00:00 | 43
Y | 2023-04-03 00:00:00 | 44
Y | 2023-04-04 00:00:00 | 45
Y | 2023-04-05 00:00:00 | 46
Y | 2023-04-06 00:00:00 | 47
Y | 2023-04-07 00:00:00 | 48
Y | 2023-04-08 00:00:00 | 49
Y | 2023-04-09 00:00:00 | 50
Y | 2023-04-10 00:00:00 | 51
Y | 2023-04-11 00:00:00 | 52
Y | 2023-04-12 00:00:00 | 53
Y | 2023-04-13 00:00:00 | 54
Y | 2023-04-14 00:00:00 | 55
Y | 2023-04-15 00:00:00 | 56
Y | 2023-04-16 00:00:00 | 57
Y | 2023-04-17 00:00:00 | 58
W | 2023-04-18 00:00:00 | 30
W | 2023-04-19 00:00:00 | 31
W | 2023-04-20 00:00:00 | 32
W | 2023-04-21 00:00:00 | 33
W | 2023-04-22 00:00:00 | 34
W | 2023-04-23 00:00:00 | 35
W | 2023-04-24 00:00:00 | 36
W | 2023-04-25 00:00:00 | 37
W | 2023-04-26 00:00:00 | 38
W | 2023-04-27 00:00:00 | 39
W | 2023-04-28 00:00:00 | 40
W | 2023-04-29 00:00:00 | 41
W | 2023-04-01 00:00:00 | 42
W | 2023-04-02 00:00:00 | 43
W | 2023-04-03 00:00:00 | 44
W | 2023-04-04 00:00:00 | 45
W | 2023-04-05 00:00:00 | 46
W | 2023-04-06 00:00:00 | 47
W | 2023-04-07 00:00:00 | 48
W | 2023-04-08 00:00:00 | 49
W | 2023-04-09 00:00:00 | 50
W | 2023-04-10 00:00:00 | 51
W | 2023-04-11 00:00:00 | 52
W | 2023-04-12 00:00:00 | 53
W | 2023-04-13 00:00:00 | 54
W | 2023-04-14 00:00:00 | 55
W | 2023-04-15 00:00:00 | 56
W | 2023-04-16 00:00:00 | 57
W | 2023-04-17 00:00:00 | 58
Spreadsheet: 7fae8448-68ab-4535-adab-e3fd0f0f78f3
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
ANST | Test | ANST | Androstenedione, Serum | Androstenedione, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 0.6 | mL | Container/Tube: Red top [NAME]: 0.6 mL | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | PEDIATRICS* Premature infants 26-28 weeks, day 4: 92-282 ng/dL 31-35 weeks, day 4: 80-446 ng/dL Full-term infants 1-7 days: 20-290 ng/dL 1 month-1 year: <69 ng/dL   Males* Tanner Stages	Age (Years)	[NAME] (ng/dL) Stage I (prepubertal)	<9.8	<51 Stage II	9.8-14.5	31-65 Stage III	10.7-15.4	50-100 Stage IV	11.8-16.2	48-140 Stage V	12.8-17.3	65-210   Females* Tanner Stages	Age (Years)	[NAME] (ng/dL) Stage I (prepubertal)	<9.2	<51 Stage II	9.2-13.7	42-100 Stage III	10.0-14.4	80-190 Stage IV	10.7-15.6	77-225 Stage V	11.8-18.6	80-240 *Source: Androstenedione. In Pediatric Reference Ranges. Fourth edition. Edited by [NAME], C Brugnara, [NAME]. Washington, DC, AACC Press, 2003, pp 32-34    ADULTS Males: 40-150 ng/dL Females: 30-200 ng/dL | Monday through Friday; 2 p.m. | 2 days | 5 days | 1 | 82157 |  |  |  |  | Rochester
ANST | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
ANST | Result | 7730 | Androstenedione, S | Androstenedione, S | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 1854-9 | Androstenedione:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 699658d1602694426-how-to-split-raw-data-based-on-value-of-a-cell-test
Sheet: Janet

s_id | associate_task | associate_queue | associate | associate_resolve_time | metric_wk_no | a_action | investigator_task | investigator_queue | investigator | investigator_resolve_time | metric_wk_no | verification_action | country | merchant_program_at_reg | associate_country | hire_to_task | in_ramp_phase | m_customer_id | language
Spreadsheet: 6a492ed8-a069-4eb2-97c1-ae5b0cfd900e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259275 | 50447 | Mohamed | [NAME] | EGY | 78 | 00:24:33 | 00:01:33 | 01:13:00 | 00:01:04 | 00:36:06 | 1 | 2:16:14
Spreadsheet: 220817d1363274243-which-function-to-use-or-vlookup-match-values
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/907026-which-function-to-use-or-vlookup.html
 | B | 123 | hh |  |  |  | 123
 | G | 123 | Iii |  |  |  | 555
 | A | 123 | Iii |  |  |  | 666
 | C | 100 | xy |  |  |  | 999
 | S | 200 | xy
 | T | 300 | xy
 | X | 400 | ww
 | C | 500 | rr
 | O | 555 | rr
 | Y | 555 | ttt
 | A | 700 | [NAME]
 | F | 800 | oo
 | C | 900 | op
Spreadsheet: 736079d1623340573-adaptive-chart-based-off-months-and-between-dates-example1
Sheet: Sheet1

*If NOI year is less then sale month; then it equals previous years NOI
*If Sale month is between two dates; then make NOI a factor of the month. Ex. 6 Months = 138,000*(6/12); see below as well
Sale Month | 84
NOI@Sale | 138000
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
NOI |  | 127680
Sale Month | 42
NOI | 138000
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
NOI |  | 127680
Spreadsheet: 749600d1632921517-if-statement-some-results-coping-a-cell-and-other-entering-na-if-statement
Sheet: Sheet1

UC | d9189f33-e619-4db7-aa44-78b5dee |  | IF UC OR X COPY INFORMATION IN COLMUN B
ESA | 2b9afce9-4fb8-4bf0-93e6-01a02d01269a |  | IF JSA OR ESA ENTER NA | NA
JSA | 19ab8e5d-afcb-4615-885f-59d888ff9a86 |  | IF JSA OR ESA ENTER NA | NA
UC | X |  | IF UC OR X COPY INFORMATION IN COLMUN B | X
X | 11b0bd91-ee14-4aba-a6b0-d774d86 |  | IF UC OR X COPY INFORMATION IN COLMUN B
 |  |  | `
Spreadsheet: 20589a40-9b1d-45b5-b7e6-1b784dc7693f
Sheet: Sheet1

COUNTRY X: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
A | B | C | D | E | F | G | H | I
 |  |  |  |  | Maternal Mortality Ratio 1 | Maternal Mortality Ratio 2 | Maternal Mortality Rate per 100000 | % Lifetime Risk of
 | # women | # with livebirth | # with any | # women dying in | per 100000 livebirths | per 100000 pregnancies | women of reproductive age | Maternal Death
[NAME] group i | in age group i | pregnancy | pregnancy* | pregnancy/puerperium | (= 100000 x E/C) | (= 100000 x E/D) | (= 100,000 x E/B) | (= (ΣHi) x 5/1000
10-14 | 100000 | 9000 | 10000 | 30 | 333.3333333333333 | 300 | 30
15-19 | 100000 | 9000 | 10000 | 12 | 133.3333333333333 | 120 | 12
20-24 | 100000 | 9000 | 10000 | 10 | 111.1111111111111 | 100 | 10
25-29 | 100000 | 9000 | 10000 | 14 | 155.5555555555555 | 140 | 14
30-34 | 100000 | 9000 | 10000 | 12 | 133.3333333333333 | 120 | 12
35-39 | 100000 | 9000 | 10000 | 14 | 155.5555555555555 | 140 | 14
40-44 | 100000 | 9000 | 10000 | 12 | 133.3333333333333 | 120 | 12
45-49 | 100000 | 9000 | 10000 | 18 | 200 | 180 | 18 | 0.61
COUNTRY Y:
A | B | C | D | E | F | G | H | I
 |  |  |  |  | Maternal Mortality Ratio 1 | Maternal Mortality Ratio 2 | Maternal Mortality Rate per 100000 | % Lifetime Risk of
 | # women | # with livebirth | # with any | # women dying in | per 100000 livebirths | per 100000 pregnancies | women of reproductive age | Maternal Death
[NAME] group i | in age group | pregnancy | pregnancy* | pregnancy/puerperium | (= 100000 x E/C) | (= 100000 x E/D) | (= 100,000 x E/B) | (= (ΣHi) x 5/1000
10-14 | 100000 | 4500 | 5000 | 15 | 333.3333333333333 | 300 | 15
15-19 | 100000 | 4500 | 5000 | 6 | 133.3333333333333 | 120 | 6
20-24 | 100000 | 4500 | 5000 | 5 | 111.1111111111111 | 100 | 5
25-29 | 100000 | 4500 | 5000 | 7 | 155.5555555555555 | 140 | 7
30-34 | 100000 | 4500 | 5000 | 6 | 133.3333333333333 | 120 | 6
35-39 | 100000 | 4500 | 5000 | 7 | 155.5555555555555 | 140 | 7
40-44 | 100000 | 4500 | 5000 | 6 | 133.3333333333333 | 120 | 6
45-49 | 100000 | 4500 | 5000 | 9 | 200 | 180 | 9 | 0.305
*Any pregnancy that results in a livebirth, stillbirth or an abortion
Spreadsheet: 632ff516-f63a-4159-9a58-0a094fc32726
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
264109 | 72713 | [NAME] | Ellis | GBR | 2972 | 00:11:05 | 00:02:11 | 00:29:31 | 00:01:40 | 00:19:04 | 1 | [NAME]
264109 | 40957 | Iain | Dawson | GBR | 2973 | 00:11:07 | 00:02:10 | 00:28:24 | [NAME] | 00:21:03 | 2 | 01:04:34
264109 | 47874 | Sean | [NAME] | GBR | 2974 | [NAME] | 00:02:42 | 00:29:28 | 00:00:00 | 03:23:38 | 3 | 01:06:24
Spreadsheet: 767982d1644771771-help-with-this-test-buy-random_test
Sheet: Some

A# | A.Name | Location | Stock
123 | Hi | qwe | 2
234 | Bye | wer | 4
345 | Goodbye | ert | 0
456 | Hola | asd | 32
567 | Adios | zcxz | 0
678 | Day | xcvvx | 43
789 | Night | 34fsed | 222
890 | [NAME] | dfdzs34 | 0
98 | Noche | sad4 | 123
987 | Sun | cvcgh | 42
876 | [NAME] | 098jsa | 543
765 | Sol | 32fsdfv | 0
654 | Luna | oinasdf32 | 12345
543 | Snow | jbndlsn | 435
432 | Rain | adbnln1 | 0
321 | Nieve | vnxcnvlsd | 123123
210 | Lluvia | u4uwsafb | 124455
1234 | One | 2[4jhpqsfhal | 1
2345 | Two | 143pjhashif1 | 3
3456 | Three | 5wefzxclnkl23 | 5
4567 | Four | 42pjhlfahslh | 6
5678 | Five | 564lflzfn | 32
6789 | Six | 69usdflsh | 231
7890 | Seven | 054jlslshlt23 | 56234
987 | Eight | 2354halsfhlh3124 | 0
986554 | Uno | 08isdjr | 123
654 | Dos | ndsvjknahr2h | 423342
418798471 | Tres | [NAME] | 1235678
12498570 | Cuatro | 0987dvsaih | 341245
6423234 | Cinco | pafyup23hyu | 23567
1235566234 | Seis | 09ugdwsoihpoi23h4r | 123
Spreadsheet: 829527d1684294619-creating-a-formula-to-return-the-average-of-the-top-5-scores-for-a-certain-player-in-table-season-long-ppr-rankings-session-1-2023
Sheet: RoundRobin-Standings

Position | Team Name | Team PPR | PlayerName1 | PlayerEmail1 | Game Name
1 | [NAME] | 6.91 | [NAME] | [EMAIL] | A League of Their Own - Week 10
2 | Wags | 6.79 | Wags | [EMAIL] | A League of Their Own - Week 10
3 | [NAME] | 6.05 | [NAME] | [EMAIL] | A League of Their Own - Week 10
4 | [NAME] | 5.93 | [NAME] | [EMAIL] | A League of Their Own - Week 10
5 | [NAME] | 5.73 | [NAME] | [EMAIL] | A League of Their Own - Week 10
6 | [NAME] | 5.58 | [NAME] | [EMAIL] | A League of Their Own - Week 10
7 | [NAME] | 5.55 | [NAME] | [EMAIL] | A League of Their Own - Week 10
8 | [NAME] | 5.39 | [NAME] | [EMAIL] | A League of Their Own - Week 10
9 | [NAME] | 4.77 | [NAME] | [EMAIL] | A League of Their Own - Week 10
10 | Kyle N | 4.52 | [NAME] | [EMAIL] | A League of Their Own - Week 10
Spreadsheet: 118561d1313758778-if-and-or-or-function-to-remove-data-from-certain-cells-ak-testing
Sheet: Models

Code | Area | RBM | SDM | DEALER | Live Date | Term Date | Original Target (Key) | Updated target (Actual) | CAR1 | CAR2 | CAR3 | CAR4 | [NAME] | [NAME] | [NAME] | TQ | TOTAL | Retail | Motability | Business User | TOTAL | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | P1 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | P2 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | P3 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | P4 | Total
 |  |  |  |  |  |  |  |  | 0.28 | 0.195 | 0.192 | 0.029 | 0.064 | 0.148 | 0.069 | 0.023 |  |  |  |  |  | 0.0736 | 0.0338 | 0.176 | 0.2834 | 0.0743 | 0.0719 | 0.0899 | 0.2361 | 0.0723 | 0.0354 | 0.1769 | 0.2846 | 0.0763 | 0.0661 | 0.0535 | 0.1959
45633 | 1 | NAME | NAME | DEALER | 2011-01-01 00:00:00 | 2011-07-31 00:00:00 | 232 | 138 | 39 | 27 | 26 | 4 | 9 | 20 | 10 | 3 | 138 |  | 8 |  | 8 | 17 | 8 | 41 | 66 | 17 | 17 | 21 | 55 | 17 |  |  | 17 |  |  |  | 0 | 138 | DEALER
Spreadsheet: 878868d1726169071-i-want-criteria-base-index-with-count-function-criteria-base-index
Sheet: Sheet1

 | Index | [NAME] |  |  |  |  |  | Criteria
 | a | small | small |  | find with formula | find with formula |  | small
 | b | big | big |  |  |  |  | big
 | c | XL | XL |  |  |  |  | large
 | a | XXL | XXL |  | Result
 | c | big | big |  | a
 | b | XXXL | XXXL |  | b
 | a | large | large |  | c
 | c | small | small
 | b | large | large
Spreadsheet: caeaa619-ad13-4a6e-b128-fdd8e936b54f
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Estimating $4,362,172; Appropriating $1,807,661 to EDI Fund
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY2006-07 |  |  | FY2007-08
 | General Fund |  |  | $ |  |  | $
 | Special Revenue |  |  | $ | 0 |  | $ | 0
 | Enterprise |  |  | $ |  |  | $
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known or, if grant revenue, please identify source of funds (federal or state) and duration of grant support.)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY2006-07 |  |  | FY2007-08
 | General Fund |  |  | $
 | Special Revenue |  |  | $ |  |  | $ | 1807661
 | Enterprise/Other |  |  | $ |  |  | $
 |  |  | Total: | $ | 0 |  | $ | 1807661
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | Unknown
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimated number of people to be served, who is currently delivering services to that population, service
 | performance expectations and, if grant supported, provisions for support if grant support ends.)
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
0ffice of Management and Budget |  |  |  |  |  | OMB Approval Date
Spreadsheet: 794404d1662037286-consecutive-dividend-increases-sample
Sheet: Sheet1

 | Dividends |  |  |  |  |  |  | Consecutive Dividend Increases
 | Fiscal | Q1 | Q2 | Q3 | Q4 | Total
 | 2016 |  |  | 0.15 | 0.15 |  |  | 2
 | 2017 | 0.25 | 0.25 | 0.25 | 0.35
 | 2018 | 0.35 | 0.45 | 0.6 | 0.78
 | 2019 | 1 | 1 | 1.06 | 1.17
 | 2020 | 1.24 | 1.32 | 1.4 | 1.5
 | 2021 | 1.5 | 1.75 | 1.75 | 1.75
 | 2022 | 1.75 | 1.38 | 1.38 | 1.38
 | 2023 | 1.38 | 1.51 | 1.51 | 1.51
 | 2024 | 1.51 | 1.55 | 1.55 | 1.55
 | 2025
 | 2026
 | 2027
 | 2028
 | 2029
Spreadsheet: 476892d1472059401-sorting-addresses-example
Sheet: Sheet1

Name | Address | Subscribe |  | Subscribing Odds | Subscribing Evens | All subscribers (O then E)
Person 1 | 860 north 200 west | Yes
Person 2 | 865 north 200 west | No
Person 3 | 840 north 200 west | Yes
Person 4 | 845 north 200 west | Yes
Person 5 | 860 north 300 west | No
Person 6 | 835 north 200 west | No
Person 7 | 865 north 300 west | No
Person 8 | 850 north 300 west | Yes
Person 9 | 855 north 200 west | Yes
Person 10 | 845 north 300 west | Yes
Person 11 | 840 north 300 west | No
Person 12 | 855 north 300 west | Yes
Person 13 | 835 north 300 west | No
Person 14 | 850 north 200 west | Yes
Spreadsheet: 848025d1698838449-comparing-number-and-text-irregardless-of-arrangement-book1
Sheet: Sheet1

 | Number | Criteria | to show
 | 12345 | 21463 | 0.8 | 4/5 correct
 | 12345 | 21543 | 1 | 5/5 correct
 | 12345 | 88543 | 0.6 | 3/5 correct
 | 11122 | 18881 | 0.4 | 2/5 correct
 | 12121 | 11221 | 1 | 5/5 correct
 | 22221 | 2222111 | 1 | 5/5 correct
 | qwerty | wert |  | 4/6 correct
 | qwerty | qxxx |  | 1/6 correct
 | [NAME] | abxxx | 0 | 0/5 correct
 | [NAME] | qtqtq | 1 | 5/5 correct
 | what | hatwww | 1 | 4/4 correct
 | what | whhae | 0.75 | 3/4 correct
Spreadsheet: 765470d1643346848-counting-cells-with-a-criteria-that-have-a-condition-book-page-calculation
Sheet: Pages

DATA |  |  |  | RESULTS
No. | Book Type | Pages Per Book |  | No. | Number of Book Types | Total Books per Type | Total Pages per Book Type | Number of Books with more than 100 Pages |  | Manual Calculation Results
1 | History | 125 |  | 1 |  |  |  |  |  | 1
2 | Geography | 137 |  | 2 |  |  |  |  |  | 3
3 | Science | 98 |  | 3 |  |  |  |  |  | 3
4 | Biology | 62 |  | 4 |  |  |  |  |  | 1
5 | History | 150 |  | 5 |  |  |  |  |  | 0
6 | History | 220 |  |  | Total
7 | Science | 200
8 | Science | 287
9 | Science | 182
10 | Biology | 152
Total
Spreadsheet: chris_stokley__3917__0201 PGES2
Sheet: Top

 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 4
 | Date Range | Use | Current |  |  |  |  |  |  |  |  | 51
 | Start Date: | 2000-06-01 00:00:00 | 2000-06-01 00:00:00 |  |  |  |  |  |  |  |  | 54
 | End Date: | 2001-02-28 00:00:00 | 2001-02-28 00:00:00 |  |  |  |  |  |  |  |  | 101
 | [NAME]: | True | False |  |  |  |  |  |  |  |  | 102
 |  |  |  |  |  |  |  |  |  |  |  | 103
 | Parameters | Pull1 | Pull2 | Pull3 |  |  |  |  |  |  |  | 111
 | Trans Type: | A | M |  |  |  |  |  |  |  |  | 112
 | Ledger Date: | 2001-06-01 00:00:00 | 2001-06-01 00:00:00 |  |  |  |  |  |  |  |  | 114
 | Multiplier: |  |  |  |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  |  |  |  |  | 116
 | Settlement Entity: | ISO |  |  |  |  |  |  |  |  |  | 151
 | Customer: | PGES |  |  |  |  |  |  |  |  |  | 152
 | Auto Clear: | True |  |  |  |  |  |  |  |  |  | 153
 | Oracle DB: | ODBC;DSN=pwrprodn_ded;DBQ=pwrprodn_ded;UID[NAME]=mbennet_pc |  |  |  |  |  |  |  |  |  | 202
 | Database: | r:\enpowercaps\settle\isoandpx\settle.mdb |  |  |  |  |  |  |  |  |  | 203
 | Charge | False |  |  |  |  |  |  |  |  |  | 203
 | [NAME] | False |  |  |  |  |  |  |  |  |  | 252
 |  |  |  |  |  |  |  |  |  |  |  | 253
 |  |  |  |  |  |  |  |  |  |  |  | 256
 |  |  |  |  |  |  |  |  |  |  |  | 301
 |  |  |  |  |  |  |  |  |  |  |  | 303
 |  |  |  |  |  |  |  |  |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  |  | 351
 |  |  |  |  |  |  |  |  |  |  |  | 352
 |  |  |  |  |  |  |  |  |  |  |  | 401
 |  |  |  |  |  |  |  |  |  |  |  | 402
 |  |  |  |  |  |  |  |  |  |  |  | 403
 |  |  |  |  |  |  |  |  |  |  |  | 404
 |  |  |  |  |  |  |  |  |  |  |  | 405
 |  |  |  |  |  |  |  |  |  |  |  | 406
 |  |  |  |  |  |  |  |  |  |  |  | 452
 |  |  |  |  |  |  |  |  |  |  |  | 999
 |  |  |  |  |  |  |  |  |  |  |  | 1010
 |  |  |  |  |  |  |  |  |  |  |  | 1101
 |  |  |  |  |  |  |  |  |  |  |  | 1302
 |  |  |  |  |  |  |  |  |  |  |  | 1303
 |  |  |  |  |  |  |  |  |  |  |  | 1353
 |  |  |  |  |  |  |  |  |  |  |  | False
Spreadsheet: 874170d1720731452-transpose-not-quite-what-im-after-transpose-example
Sheet: Sheet1

Stock Number | DP1 | DP2 | DP3 | DP4 | DP5 | DP6
120/802131 | Model No 120/802131 | Application(s): SUPERSTART550, SUPERSTART650, ECS400, ECS650 | Brand: Sealey | [NAME]: 0.06kg
120/802260 | Model No 120/802260 | Application(s): SUPERBOOST160, SUPERBOOST180, SUPERSTART300, SUPERSTART500, ECS300, ECS350 | Brand: Sealey | [NAME]: 0.03kg
120/803150 | Model No 120/803150 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690049 | Length: 120mm | [NAME]: 0.76kg
120/803151 | Model No 120/803151 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690047, 120/690050 | Length: 130mm | [NAME]: 0.78kg
120/803152 | Model No 120/803152 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690047, 120/690050 | Length: 250mm | [NAME]: 1.49kg
120/803153 | Model No 120/803153 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690049 | Length: 350[NAME] | [NAME]: 2.05kg
120/803154 | Model No 120/803154 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690050 | Length: 350[NAME] | [NAME]: 2.02kg
120/803155 | Model No 120/803155 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690051 | Length: 120mm | [NAME]: 0.92kg
120/803156 | Model No 120/803156 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690048, 120/690050 | Length: 500mm | [NAME]: 3.14kg
120/803158 | Model No 120/803158 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690046, 120/690052 | Length: 120mm | [NAME]: 0.86kg
120/803159 | Model No 120/803159 | Application(s): SR122, SR123 | Brand: Sealey | Electrodes Model No's: 120/690046, 120/690052 | Length: 120mm | [NAME]: 1.22kg
168.200155 | Model No 168.200155
168.200155 | Brand: Sealey
168.200155 | [NAME]: 0.03kg
168.200155 | Pack Qty: 1
168.200155 | Torch Type: MB15
168.200162 | Model No 168.200162
168.200162 | Brand: Sealey
168.200162 | [NAME]: 0.04kg
168.200162 | Pack Qty: 1
168.200162 | Torch Type: MB15
Spreadsheet: 138408d1327648616-converting-row-data-to-columns-unsorted
Sheet: Sheet1

Name | [NAME] |  | Name | Company | Street | Suite | City, State, Zip
Company | Widgets Inc.
Street | 200 Main Street
City, State, Zip | Anywhere, KS  20010
Name | [NAME]
Street | 100 Main Street
City, State, Zip | Anywhere, KS  20010
Name | [NAME]
Street | P.O. Box 111
City, State, Zip | Anywhere, KS  20010
Name | [NAME]
Street | 500 Main Street
Suite | Ste. 395
City, State, Zip | Anywhere, KS  20010
Name | [NAME]
Company | CPAs of America
Street | 1000 Main Street
Suite | Suite 10
City, State, Zip | Anywhere, KS  20010