tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875238d1721823739-formula-to-calculate-values-based-on-criteria-example
Sheet: Info

 | Item | Component | Component Task | Light Tower | Flag Pole | Comms Tower | [NAME] | WT M&T | Array Towers | [NAME] | Mono Poles | Sat Dish | [NAME] | Time (Mins)
 | 1 | Details | Conduct survey and check area | X | X | X | X | X | X | X | X | X | X | 20
 | 2 | Structure | [NAME] To Be Sound and Safe | X | X | X |  | X | X | X | X | X | X | 5
 | 3 | Structure | Check Fasteners | X | X | X | X | X | X | X | X | X | X | 5
 | 4 | Structure | Fasteners Secure | X | X | X | X |  | X | X | X | X | X | 3
 | 5 | Structure | Drainage Holes unblocked |  | X | X | X | X | X | X | X | X | X | 2
 | 6 | Structure | No Corrosion | X | X | X | X | X | X |  | X | X | X | 20
 | 7 | Structure | Base Plate Fasteners Secure | X | X | X | X | X | X | X | X | X | X | 2
 | 8 | Structure | Pivot Joint Fastener Present |  |  |  |  |  |  |  |  | X | X | 1
 | 9 | Structure | Cables And Fittings Are Secure And Free From Corrosion. | X | X | X | X |  | X | X | X | X | X | 3
 | 10 | Structure | Earth Wire Present | X |  | X | X | X | X | X | X | X |  | 2
 | 11 | Structure | Terminals Of The Earth Wire Secure | X |  | X | X | X | X | X | X | X | X | 5
 | 12 | [NAME] | Guy Cables Free From Sag |  |  | X | X |  | X |  |  |  | X | 10
 | 13 | [NAME] | Mast Concrete Pad Footing Free From Surface Soil and Debris | X | X | X |  |  | X | X |  | X | X | 10
 | 14 | Antenna Ropes | Ropes Are Free From Damage Or Deterioration |  |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 758457d1638885314-populate-data-based-on-selection-from-dropdown-project-planning
Sheet: failsafe

Project Estimation Report
S.no | Invoice No | Invoice Value | Project Code | Client | Type | [NAME] | Region | Work Day | Petty Cash | Labor Cost | Inventory Cost | Other Cost | Admin Cost
1 |  |  |  |  |  |  |  |  |  | 208909 | 186391.67
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 152242d1335299490-appropriate-formula-if-match-book1a
Sheet: Sheet1

[NAME] | Item | Qty
111 | Pen | 10
112 | Ruler | 20
113 | Jacket | 30
113 | Calculator | 50
113 | Chair | 60
115 | Pencil | 70
115 | Telephone | 80
Spreadsheet: 8e2856f9-28b1-4794-823b-eae87d894289
Sheet: Sheet1

Early and Adequate Prenatal Care by Year,  Births to 15-44 Year Old Maine Women, 2000-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Live Births for which Mother Received  Early and Adequate Prenatal Care*
Year |  | Number | %† | 95% CI
2000 |  | 11360 | 84.8 | 83.2 - 86.3
2001 |  | 11605 | 85.3 | 83.7 - 86.8
2002 |  | 11447 | 84.9 | 83.4 - 86.5
2003 |  | 11898 | 86.5 | 84.9 - 88.1
2004 |  | 12074 | 87.3 | 85.7 - 88.9
2005 |  | 12316 | 87.8 | 86.3 - 89.4
2006 |  | 12296 | 87.3 | 85.8 - 88.8
2007 |  | 12160 | 86.7 | 85.2 - 88.3
2008 |  | 11505 | 85.2 | 83.6 - 86.7
2009 |  | 11401 | 85.3 | 83.8 - 86.9
2010 |  | 10991 | 85.8 | 84.2 - 87.4
* Defined as an adequate or adequate-plus rating on the Kotelchuck Adequacy of Prenatal Care Utilization Index.
† Percents are based on live births with known prenatal care initiation and adequacy.
CI: Confidence Interval.
Data Source: Birth certificate datasets obtained from the Office of Data, Research and Vital Statistics, Maine Center for Disease Control and Prevention.
Spreadsheet: 356670d1415184142-top-5-numbers-in-a-range-2014
Sheet: Sheet1

42 | 39 | 16 | 9 | 5
10 | 32 | 18 | 29 | 19 |  |  |  | Top Five Numbers
5 | 7 | 37 | 17 | 13 |  |  | 1
38 | 1 | 37 | 26 | 32 |  |  | 2
6 | 13 | 18 | 23 | 45 |  |  | 3
6 | 43 | 13 | 2 | 16 |  |  | 4
8 | 29 | 45 | 21 | 6 |  |  | 5
40 | 9 | 16 | 3 | 33
17 | 19 | 41 | 14 | 21
36 | 12 | 35 | 11 | 17
19 | 2 | 31 | 30 | 40
43 | 15 | 37 | 14 | 10
9 | 42 | 26 | 11 | 6
29 | 14 | 9 | 43 | 8
6 | 1 | 14 | 34 | 41
5 | 24 | 18 | 13 | 35
35 | 23 | 30 | 4 | 7
23 | 14 | 37 | 7 | 2
40 | 23 | 25 | 33 | 17
41 | 36 | 29 | 1 | 11
5 | 4 | 14 | 8 | 13
31 | 25 | 21 | 41 | 19
19 | 34 | 18 | 25 | 36
7 | 27 | 25 | 36 | 44
10 | 29 | 34 | 31 | 21
20 | 8 | 6 | 16 | 43
15 | 36 | 23 | 11 | 20
20 | 6 | 39 | 13 | 12
12 | 27 | 41 | 11 | 43
9 | 33 | 3 | 16 | 36
8 | 32 | 7 | 25 | 9
29 | 24 | 9 | 42 | 36
29 | 14 | 4 | 31 | 15
17 | 2 | 28 | 22 | 14
4 | 13 | 42 | 3 | 28
24 | 38 | 7 | 33 | 14
12 | 22 | 5 | 34 | 19
19 | 20 | 41 | 22 | 4
24 | 40 | 19 | 44 | 4
21 | 35 | 25 | 42 | 3
7 | 4 | 19 | 34 | 9
21 | 28 | 20 | 45 | 44
30 | 41 | 10 | 6 | 35
39 | 11 | 9 | 2 | 7
18 | 8 | 42 | 27 | 1
11 | 44 | 13 | 16 | 39
2 | 16 | 7 | 10 | 40
44 | 37 | 16 | 15 | 34
13 | 24 | 16 | 30 | 21
31 | 22 | 37 | 24 | 25
16 | 14 | 9 | 11 | 24
28 | 31 | 15 | 12 | 9
40 | 44 | 13 | 30 | 25
22 | 9 | 20 | 40 | 31
41 | 42 | 28 | 14 | 31
5 | 24 | 16 | 17 | 31
14 | 6 | 26 | 18 | 35
37 | 26 | 30 | 17 | 15
45 | 4 | 30 | 8 | 6
38 | 17 | 42 | 3 | 39
35 | 27 | 5 | 11 | 3
23 | 30 | 24 | 26 | 6
6 | 33 | 41 | 24 | 43
33 | 12 | 23 | 17 | 1
30 | 18 | 14 | 19 | 26
27 | 3 | 15 | 33 | 11
39 | 16 | 38 | 14 | 32
44 | 30 | 14 | 23 | 41
42 | 27 | 43 | 25 | 1
31 | 20 | 17 | 35 | 19
4 | 1 | 45 | 33 | 40
27 | 32 | 14 | 19 | 43
26 | 10 | 17 | 34 | 1
3 | 10 | 6 | 40 | 45
12 | 11 | 18 | 38 | 8
2 | 35 | 25 | 30 | 17
22 | 35 | 42 | 26 | 41
42 | 5 | 18 | 10 | 4
5 | 22 | 44 | 38 | 6
30 | 23 | 21 | 26 | 28
21 | 32 | 44 | 12 | 29
7 | 4 | 12 | 38 | 40
42 | 3 | 41 | 22 | 17
44 | 28 | 1 | 8 | 24
1 | 16 | 12 | 26 | 43
28 | 25 | 27 | 19 | 32
3 | 17 | 34 | 9 | 43
20 | 4 | 7 | 31 | 40
Spreadsheet: 829584d1684323692-function-to-find-most-common-text-based-on-criteria-function-to-find-most-common-text-based-on-criteria-using-unique-and-countifs
Sheet: Sheet1

 |  | Function to Find Most Common Text Based on Criteria
 |  |  |  |  | Function to Find Most Common Text Based on Criteria using =[NAME] and =[NAME]
 |  | Reason for Absence | Department
 |  | Injury Outside Work | Production |  | By Department |  |  | By Reason
 |  | Cold/Flu | Production
 |  | Headache/Migraine | Production |  | Research and Design | 2 |  | Cold/Flu | 4
 |  | Cold/Flu | Production |  | Administration | 3 |  | Headache/Migraine | 1
 |  | Cold/Flu | Research and Design |  |  |  |  | Infection | 2
 |  | Cold/Flu | Research and Design |  |  |  |  | Gynaecological | 1
 |  | Infection | Administration
 |  | Gynaecological | Administration
 |  | Infection | Administration
Spreadsheet: 1a2558dd-4e46-4c11-9ca6-5a9385b41f9c
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 78. Value of Building Approved, Chain Volume Measures, Original - South Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total houses ;  New ; |  |  | Original | A590507C | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total other residential building ;  New ; |  |  | Original | A590508F | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  New ; |  |  | Original | A590509J | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590510T | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590511V | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590512W | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590513X | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 1a298b0d-bb0d-44b4-9ae6-2a1a3aa4d4ee
Sheet: Checklist

B.S. Electrical Engineering Curriculum Checklist
Course | Credits | Completed
University Requirements | 24
First Year Composition
Philosophy (2)
Theology (2)
Literature- Fine Arts
Social Sciences
History
Mathematics | 18
MATH 10550 Calculus I
MATH 10560 Calculus II
MATH 20550 Calculus III
MATH 20580 [NAME] to Linear Algebra and Differential Equations
MATH 30650 Differential Equations
Science | 18.5
CHEM 10171 Gen Chem- Fundamental Principles
CHEM 10122 Gen Chem- Biological Processes
PHYS 10310 General Physics
PHYS 10320 General Physics II
PHYS 20330 General Physics III
Introductory to Engineering | 6
EG 10111 Intro. Engr. Systems I
EG 10112  Intro. Engr. Systems II
Electrical Engineering Core | 36
CSE 20232 C/C++ Programming
EE 20224 Intro to Electrical Engineering
EE 20242 Electronics
EE 20234 Electric Circuits
CSE 20221 Logic Design
EE 30344 Signals and Systems
EE 30347 Fundamentals of Semiconductors
EE 30348 Electromagnetic Fields
EE 30363 Random Phenomena in EE
EE 41430 Senior Design I
EE 41440 Senior Design II
Electrical Engineering Electives | 18
(Lab Elective)
Engineering Science | 3
Technical Electives | 6
Total | 129.5
Spreadsheet: 798579d1664558231-sumproduct-arrays-different-size-match1
Sheet: match-1array

UNMATCH |  | (check existing grades) |  | =SUMPRODUCT((1*ISNA(MATCH(A5:A1000,E5:E8,0))=1)*(A5:A1000<>"")*1) |  |  |  |  |  | case-unsensitive
 |  |  |  | =REDUCE(0,FILTER(A5:A1000,A5:A1000<>""),LAMBDA(a,b,a+ISNA(MATCH(TRUE,EXACT(b,E5:E8),0)))) |  |  |  |  |  | case-sensitive
grade |  |  |  | grade
A | 1 |  |  | A
A | 2 |  |  | B
B | 3 |  |  | b
C | 4 |  |  | C
D | 5
a | 6
F | 7
A | 8
A | 9
B | 10
B | 11
D | 12
A | 13
B | 14
Spreadsheet: 879406d1726891951-indirect-lookup-and-last-value-entered-formulas-ncaa-stats
Sheet: Sheet38

SCHEDULE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFFENSIVE GAME LOG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEFENSIVE GAME LOG
G | Date | Time | Day | School |  | Opponent | Conf | Win/Loss | Pts | Opp | W | L | Streak | Notes |  | G | Date |  | Opponent | Result | Passing |  |  |  |  | Rushing |  |  |  | Total Offense |  |  | First Downs |  |  |  | Penalties |  | Turnovers |  |  |  | G | Date |  | Opponent |  | Passing |  |  |  |  | Rushing |  |  |  | Total Offense |  |  | First Downs |  |  |  | Penalties |  | Turnovers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cmp | Att | Pct | Yds | TD | Att | Yds | Avg | TD | Plays | Yds | Avg | Pass | Rush | Pen | Tot | No. | Yds | Fum | Int | Tot |  |  |  |  |  |  | Cmp | Att | Pct | Yds | TD | Att | Yds | Avg | TD | Plays | Yds | Avg | Pass | Rush | Pen | Tot | No. | Yds | Fum | Int | TO
1
2
3
4
5
6
7
8
9
10
11
12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cmp | Att | Pct | Yds | TD | Att | Yds | Avg | TD | Plays | Yds | Avg | Pass | Rush | Pen | Tot | No. | Yds | Fum | Int | Tot |  |  |  |  |  |  | Cmp | Att | Pct | Yds | TD | Att | Yds | Avg | TD | Plays | Yds | Avg | Pass | Rush | Pen | Tot | No. | Yds | Fum | Int | TO
Spreadsheet: 55482d1255598725-if-function-query-mearsy
Sheet: Sheet1

245.25 | 225 | 1.09
 | 452
6423.34 | 2115 | 3.037040189125296
6877.52 | 231 | 29.77281385281385
34564.25 | 231 | 149.6287878787879
 | 55
1233.45 |  | #N/A
 | 2135
321115.2 |  | #N/A
32155.4 |  | #N/A
2333.22 | 311 | 7.502315112540193
24455 | 254 | 96.27952755905511
Spreadsheet: john_griffith__15724__10_15_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | 22.5 | 90 | 105 | 67.7 | 79 | 1.04 | 2001-10-15 10:06:00
 | CL Z1 | 23 | 270 | 285 | 51.5 | 54.4 | 0.77 | 2001-10-15 10:06:00
 | CL F2 | 23 | 355 | 370 | 48.1 | 50.1 | 0.71 | 2001-10-15 10:06:00
 | CL G2 | 23 | 415 | 435 | 45.3 | 47.5 | 0.67 | 2001-10-15 10:06:00
 | CL H2 | 23 | 455 | 470 | 43.6 | 45 | 0.64 | 2001-10-15 10:06:00
 | CL J2 | 23 | 475 | 495 | 41 | 42.8 | 0.61 | 2001-10-15 10:06:00
 | CL K2 | 23 | 490 | 510 | 38.5 | 40.1 | 0.57 | 2001-10-15 10:06:00
 | CL M2 | 23 | 505 | 525 | 37 | 38.5 | 0.55 | 2001-10-15 10:06:00
 | CL N2 | 23 | 510 | 530 | 35 | 36.4 | 0.52 | 2001-10-15 10:06:00
 | CL Q2 | 23 | 518 | 538 | 33.7 | 35 | 0.5 | 2001-10-15 10:06:00
 | CL U2 | 23 | 520 | 540 | 32.3 | 33.6 | 0.48 | 2001-10-15 10:06:00
 | [NAME] | 22.5 | 520 | 545 | 31.5 | 33 | 0.46 | 2001-10-15 10:06:00
 | [NAME] | 22.5 | 525 | 550 | 29.6 | 31 | 0.43 | 2001-10-15 10:06:00
 | CL M3 | 22 | 525 | 560 | 25.8 | 27.5 | 0.37 | 2001-10-15 10:06:00
 | CL Z3 | 22 | 525 | 560 | 23 | 24.6 | 0.33 | 2001-10-15 10:06:00
Spreadsheet: 68634d1269229052-excel-2007-help-populating-cells-according-to-combinations-dummydoc
Sheet: Sheet2 (2)

 |  |  |  |  | Upgrade |  | New
Plan Type | New / Upgrade | Months 12/24 |  |  | 12 | 24 | 12 | 24
TMP 20 | NEW | 12 |  | TMP 20 | 5 | 9 | 8 | 16
TMP 30 | UPGRADE | 24 |  | TMP 30 | 6 | 12 | 11 | 21
TMP 40 |  |  |  | TMP 40 | 8 | 15 | 13 | 26
TMP 60 |  |  |  | TMP 60 | 9 | 18 | 16 | 32
TMP 80 |  |  |  | TMP 80 | 14 | 27 | 24 | 47
TMP 100 |  |  |  | TMP 100 | 17 | 33 | 29 | 58
TMP 150 |  |  |  | TMP 150 | 23 | 45 | 39 | 79
TMP 250 |  |  |  | TMP 250 | 30 | 60 | 53 | 105
TMP 350 |  |  |  | TMP 350 |  | 81 |  | 142
TMP 500 |  |  |  | TMP 500 |  | 120 |  | 210
*** |  |  |  | ***
3GCAP 49 |  |  |  | 3GCAP 49 | 6 | 12 | 11 | 21
3GCAP 79 |  |  |  | 3GCAP 79 | 12 | 24 | 21 | 42
3GCAP 99 |  |  |  | 3GCAP 99 | 14 | 29 | 25 | 50
3GCAP 129 |  |  |  | 3GCAP 129 | 17 | 35 | 30 | 60
*** |  |  |  | ***
TBMS 20 |  |  |  | TBMS 20 | 15 | 12 | 26 | 21
TBMS 25 |  |  |  | TBMS 25 |  | 15 |  | 26
TBMS 30 |  |  |  | TBMS 30 | 18 | 36 | 32 | 63
TBMS 35 |  |  |  | TBMS 35 |  | 30 |  | 53
TBMS 40 |  |  |  | TBMS 40 | 20 | 39 | 34 | 68
TBMS 45 |  |  |  | TBMS 45 |  | 36 |  | 63
TBMS 50 |  |  |  | TBMS 50 | 21 | 42 | 37 | 74
TBMS 55 |  |  |  | TBMS 55 |  | 39 |  | 68
TBMS 65 |  |  |  | TBMS 65 |  | 42 |  | 74
*** |  |  |  | ***
ULT 55 |  |  |  | ULT 55 | 9 | 15 | 14 | 24
ULT 85 |  |  |  | ULT 85 | 15 | 27 | 24 | 45
ULT 110 |  |  |  | ULT 110 | 17 | 32 | 28 | 53
ULT 150 |  |  |  | ULT 150 | 20 | 39 | 34 | 68
*** |  |  |  | ***
TBFS 30 |  |  |  | TBFS 30 | 8 | 15 | 14 | 26
TBFS 40 |  |  |  | TBFS 40 | 9 | 18 | 16 | 32
TBFS 60 |  |  |  | TBFS 60 | 11 | 22 | 19 | 38
TBFS 80 |  |  |  | TBFS 80 | 16 | 32 | 28 | 57
TBFS 100 |  |  |  | TBFS 100 | 19 | 38 | 33 | 66
TBFS 150 |  |  |  | TBFS 150 | 27 | 54 | 47 | 95
TBFS 250 |  |  |  | TBFS 250 | 36 | 72 | 63 | 126
*** |  |  |  | ***
TMB 20 |  |  |  | TMB 20 | 6 | 12 | 11 | 21
TMB 30 |  |  |  | TMB 30 | 8 | 15 | 13 | 26
TMB 40 |  |  |  | TMB 40 | 9 | 18 | 16 | 32
TMB 60 |  |  |  | TMB 60 | 11 | 22 | 19 | 38
TMB 80 |  |  |  | TMB 80 | 16 | 32 | 28 | 57
TMB 100 |  |  |  | TMB 100 | 19 | 38 | 33 | 66
TMB 150 |  |  |  | TMB 150 | 27 | 54 | 47 | 95
TMB 250 |  |  |  | TMB 250 | 36 | 72 | 63 | 126
TMB 350 |  |  |  | TMB 350 | 50 | 99 | 87 | 173
TMB 500 |  |  |  | TMB 500 | 60 | 120 | 105 | 210
Spreadsheet: 704666d1605691489-average-display-amount-of-values-used-book1
Sheet: Sheet1

 | CL 1 | CL 2 |  |  | CL 1 | CL 2
1 | 20 | 10 |  | Average
2 | 30 | 20 |  | Count
3 | cntrl 20 | cntrl 15
4 | 60
5 | 40
Spreadsheet: c4ca4d6f-ae20-4a23-87ad-2d170ec567a4
Sheet: 3. Preguntas Claves

Estudiantes esperados a 2015 |  |  | Proporción de estudiantes extranjeros esperados a 2015 (%)
Pregrado | 150 |  | Pregrado | 0.05
Maestría | 20 |  | Maestría | 0.05
Doctorado | 30 |  | Doctorado | 0.05
Profesores esperados a 2015 |  |  | Proporción de Profesores Internaciones a 2015 (%) |  |  |  | 0.1
Planta | 30
Cátedra | 2
[NAME] ofrecidos esperados a 2015
Pregrado | x
Maestría | x
Doctorado | x
[NAME]
[NAME]
[NAME]
Planta Física
Salones Generales
Spreadsheet: b92afab6-7af5-4750-9212-f973b43efeaf
Sheet: Sheet2

Check Payable to (Name) |  |  |  |  |  | Phone
Mailing Address (Please include: Street, City, State, Zip) |  |  |  |  |  | [NAME]
Dates of Trip
Purpose of Trip |  |  |  |  |  |  |  |  | Travel Expense Report
Date |  |  |  |  |  |  |  | TOTAL | NOTES |  | GUIDELINES
Air/Train
Mileage (.56) |  |  |  |  |  |  |  |  | Enter mileage in this row and attach proof for mileage (e.g. map) |  | Mileage | Mileage rate includes gas.
Taxi/Shuttle |  |  |  |  |  |  |  |  |  |  | Lodging Bill | Detailed Lodging [NAME] must be included.  If meals are included in [NAME], a separate itemized receipt is required.
Auto Rental |  |  |  |  |  |  |  |  |  |  | Receipts | Submit all receipts with expense report. Meal receipts must be itemized.
Parking/Tolls
Lodging
Breakfast
Lunch
Dinner
Tips/Gratuities
Other
TOTAL
Liquor Consumption | 0 | Please provide total costs of liquor consumption for this trip here and highlight liquor on each meal receipt. Federal compliance requires separate tracking of these costs. (Do not substract the liquor costs from your meals above; liquor consumption has to be listed additionally and separately here.)
Signature: |  |  |  |  | Date: |  |  | Cost Center:
1st Approver: |  |  |  |  | Date: |  |  | 2nd Approver:
Spreadsheet: 762210d1641453380-if-cell-contains-product-name-then-count-all-the-cells-that-contain-the-letter-a-sumproduct-sample-aligw
Sheet: Sheet1

Agru
BTR
Cut To Size
Dotmar
Engineering Export
Eplas
Islex
[NAME]
Other
OEM
Plastic Eng
Plastral
Spare Stock
Trelleborg
QLD
SA
WA
NSW
NT
VIC
TAS
POLYETHYLENE
NYLON - PA
ACETAL - POM
POLYESTER - PET
TEFLON - PTFE
[NAME]'S
POWER TRANS
CONPRO
Spreadsheet: 76f03d71-a480-4ebe-ade9-253a49b3109a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4951 | 29625 | [NAME] | [NAME] | ITA | 346 | 00:31:09 | 00:01:52 | 02:46:46 | 00:02:36 | [NAME] | 1 | 04:20:59
4951 | 8035 | Stuart | Lumb | GBR | 348 | 00:32:06 | 00:03:52 | 02:54:56 | 00:05:15 | 01:25:30 | 2 | 05:01:38
Spreadsheet: 740453d1626345587-vslookup-with-two-conditions-sample
Sheet: table2

 | ABCDE | AAA | 1
 | ABCDE | BBB
 | ABCDE | CCC
 | ABCDE | DDD
 | ABCDE | EEE
 | ACCCDFG | CCC
 | ACCCDFG | AAA
 | ACCCDFG | DDD
 | ACCCDFG | BBB
 | AZZ123AAA | EEE
 | AZZ123AAA | AAA
 | AZZ123AAA | BBB
 | AYKLLMN | AAA
 | AYKLLMN | EEE
 | AYKLLMN | BBB
Spreadsheet: 03e8fba0-0c2b-415e-8d45-bc3dc588e51c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Crossroads of America Council | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  | Boy Scouts of America
 |  |  | 7125 Fall Creek Road North
 |  |  | Indianapolis, IN 46256
 |  |  | PH (317) 813-7070 / Fax (317) 813-7126
 |  |  | [EMAIL]
 |  |  | [NAME] Uniform Order Form
 |  |  |  |  | Item Cost | SIZE | Quantity | Total Cost
 | Scout Uniform (TAN) YOUTH - Short Sleeve |  | Medium / Large
 |  | [NAME] |  |  | 24.99
 |  | Nylon |  |  | 34.99
 | Patches | Crossroads Shoulder Patch |  |  | 2.2
 |  | World Scouting Crest |  |  | 1.99
 |  | Unit Numbers ( 0 to 9) | Unit # __________ |  | $1.49 each
 |  | Den # Strip | Den # __________ |  | 1.49
 |  | Shoulder Loops (BLUE) |  |  | 2.99
 |  | WEBELOS COLORS (tri-color pin on ribbon) |  |  | 4.99
 | Neckerchief | Webleos (4th/5th Grade) |  |  | 7.99
 | Hat | Webleos (4th/5th Grade) | S/M   or    M/L |  | 12.99
 | Slides | Webleos (4th/5th Grade) |  |  | 4.99
 | Belt | S/M (up to size 12 youth pants) | BLUE |  | 7.99
 |  | M/L (over size 12 youth pants) | BLUE |  | 8.99
 | Canvas Pants | Youth size 8 to 22 (evens) | 8,10,12,14,16,18,20,22 |  | 34.99
 |  | Husky size 32 to 36 ([NAME]) | 32H, 34H, 36H
 | Nylon Pants | S / M / L / XL |  |  | 44.99
 | Socks | Ankle  (XS to L) | S, M, L, XL |  | 5.99
 | [NAME] | Crew   ([NAME] to L) | S, M, L, XL |  | 5.99
 | Book | [NAME] |  |  | 10.99
 |  | Handbook Cover | Blue Fabric |  | 9.99
 | Badge Adhesive | [NAME] precut |  |  | 8.99
 |  | FreeStyle |  |  | 8.99
 |  |  |  |  |  | Total Items/Sub Total: | 0 | 0
 | Other Items to be added to the order (not included in TOTAL COST) |  |  |  |  | Shipping Cost (see chart): |  | 0
 | Item # | Description |  |  |  | Total Cost: |  | 0
 | Name |  |  |  | Order Amount |  |  | Domestic Shipping Cost
 | Address |  |  |  | Up to $50 |  |  | 7.50
 | City, State |  |  |  | $50.01 to $100 |  |  | 9.95
 | Zip Code |  |  |  | $100.01 to $150 |  |  | 13.95
 | Telephone # |  |  |  | Over $150.01 |  |  | 8% of the total order
 | [NAME]
 | PRICES SUBJECT TO CHANGE : CURRENT AS OF 12/12/2013
Spreadsheet: 1188ba59-06b9-4a04-bb3b-bc7a760b85bf
Sheet: Sheet1

Table 3--U.S. fiber supply | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | 2010 | 2011 |  | 2012 |  | 2011
Item | Nov. |  | Dec. |  | Jan. |  | Jan.
 | 1,000 480-lb. [NAME]
Cotton:
Ginnings | 5341 |  | 2306 |  | 878 |  | 1109
Imports since August 1 | 3.7 |  | 9.8 |  | 9.8 |  | 2
Stocks, beginning | 7089 |  | 11396 | 13592 | 12612 |  | 13592
At mills |  |  |  |  |  |  | 150
Public storage |  |  |  |  |  |  | 11621
CCC stocks | 1976 |  | 3744 |  | 4368 |  | 4576
 | Million pounds
Manmade:
Production | 439.7 |  | 382 |  | 474.9 |  | 536.2
Noncellulosic | 439.7 |  | 382 |  | 474.9 |  | 536.2
Cellulosic
Total since January 1 | 4957.4 |  | 5339.4 |  | 5814.3 |  | 6557
 | 2011 |  |  |  |  |  | 2010
 | Oct. |  | Nov. |  | Dec. |  | Dec.
 | Million pounds
Raw fiber imports: | 139.7 |  | 131.6 |  | 128 |  | 125.9
Noncellulosic | 125.6 |  | 119.8 |  | 117.5 |  | 114.3
Cellulosic | 14.1 |  | 11.8 |  | 10.5 |  | 11.6
Total since January 1 | 1475.1 |  | 1606.7 |  | 1734.7 |  | 1814
 | 1,000 pounds
Wool and mohair:
Raw wool imports, clean | 1168.2 |  | 635.5 | 385.4 | 426.1 |  | 385.4
48s-and-finer | 570.8 |  | 266.1 | 184.1 | 107.3 |  | 184.1
Not-finer-than-46s | 597.4 |  | 369.4 | 201.3 | 318.8 |  | 201.3
Total since January 1 | 7406.6 |  | 8042.1 |  | 8468.2 |  | 8036.1
Wool top imports | 239.1 |  | 297.9 |  | 309 |  | 257.5
Total since January 1 | 2909.7 |  | 3207.6 |  | 3516.6 |  | 3952.3
Mohair imports, clean | 0 |  | 0 |  | 0 |  | 1.5
Total since January 1 | 2.9 |  | 2.9 |  | 2.9 |  | 2
NA = Not available.
Last update:  03/12/12.
Sources: USDA, National Agricultural Statistics Service; USDC,
U.S. Census Bureau; and [NAME].
Spreadsheet: 81835d1281984681-organise-data-with-pivot-table-dummydataset
Sheet: Sheet1

Data
 | A | A1 | B | B1 | C | R | 1 | I
America Fund | 5214552AA |  |  | 55211AAB4 |  |  | 214AFVB55
Europe Fund | 554AF521M |  | 78EV97841
Africa Fund | 337WW8RT5 |  |  |  | 5597AST88
Australia Fund |  | 78114AS55 | 553163AED |  | 7766FA554
Japan Fund | 22462AGE5 |  | 66347ASQ5 | 22345ASER
China Fund |  |  |  | 8862FEH44 | 112347ASD