tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 810515d1671815001-excel-formula-to-track-salary-raise-by-pay-period-test-employee-raise-by-period-calculated-on-each-period
Sheet: Test

 | Sum of  (1)Regular Earnings
Employee Count | Employee Name | Raise % | Hire Date | Start Date | Same Year Current | 2023 Anniversary | Term Date | Current Salary | [NAME] | Total Comp w Raise | Annual Salary | SS/Tax | Medicare | SUI | MCTMT | Health Insurance | Total Fringe | 2023 Comp |  |  | 2023-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Salary
1 | Employee 1 | 0.06 | 2021-12-13 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 84000 |  |  | 84000 | 5487 | 1283 | 484 | 301 | 9085 |  |  | thru Q2; $50k
1 | Employee 2 | 0.05 | 2022-01-31 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 335000 |  |  |  |  |  |  |  |  |  |  | thru Feb 2023 |  |  | 12885 | 12885
1 | Employee 3 | 0.05 | 2004-09-13 00:00:00 | 2023-01-01 00:00:00 |  |  |  |  |  |  | 156000 | 9114 | 2262 | 484 | 530 | 0 |  |  | freelance; $50k
1 | Employee 4 | 0.025 | 2021-03-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 182000 |  |  | 182000 | 9114 | 2784 | 484 | 653 | 0 |  |  | 9 mos; $160,751
1 | Employee 5 | 0.02 | 2017-03-24 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 255000 |  |  | 255000 | 9114 | 4567 | 484 | 1071 | 9105 |  |  | thru Q1;  $88,459
1 | Employee 6 | 0.02 | 2021-06-28 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 90000 |  |  | 90000 | 6200 | 1450 | 484 | 340 | 7200 |  |  | thru Q1; $30,201
1 | Employee 10 | 0.07 | 2014-01-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 215000 |  |  | 215000 | 9114 | 3552 | 484 | 833 | 18901
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $ -
 | Grand Total
Spreadsheet: daren_farmer__6515__egmnom-Jan
Sheet: EGM 202

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-002
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-01-01 00:00:00
Fax: | (713)646-5799 | Stop:
 |  | 2000-01-31 00:00:00
RECEIPTS |  |  | JAN
METER # | [NAME] | SUPPLIER | 1
553 | TOMCAT
553 | TOMCAT
584 | VALERO - AGUA DULCE
3536 | BLESSING
3536 | BLESSING
4132 | EXXON KATY | TX ENERGY
5674 | MOPS
7038 | TRANS TX - AGUA DULCE
5674 | MOPS | SUPERIOR
7061 | MARKHAM
ZZZZ | IMBALANCE |  | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
713 | GEORGIA GULF
1008 | NEUCES BAY
1057 | CORPUS PLANT
1060 | SHELL DEER PARK
1168 | BAMMEL
1233 | TEXAS CITY
1244 | KOCH REFINERY
1258 | LUFKIN CHAMPION | DONAHOE
1319 | BAMMEL
1326 | ENTERPRISE
1373 | LYONDELL
1427 | GSU SABINE
1427 | GSU LEWIS CREEK
1431 | MARATHON TEXAS CITY
1563 | DESTECH
3551 | VALERO RED BLUFF
4132 | EXXON KATY HPL
4531 | NEEDVILLE
7285 | MOSS BLUFF
ZZZZ | IMBALANCE |  | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 266748d1379709854-if-column-a-column-b-list-in-column-d-else-if-column-b-column-a-list-in-column-e-if-then-example
Sheet: Sheet1

23 | 20 |  |  |  | 1
30 | 45 |  |  |  | 2
45 | 40 |  |  |  | 3
57 | 60
24 | 46
85 | 27
Spreadsheet: 266752d1379710818-formula-for-value-by-date-and-find-number-count-with-word-on-multiple-sheets-one-from-many
Sheet: Combined Data

 | March | April | May | June | July | August | September | October | November | December
# of Exceptions
# of Submissions
% of exceptions
AE % share of total exceptions for month
Abdul
[NAME]
[NAME]
[NAME]
[NAME]
Dirk
Jessica
[NAME]
[NAME]
[NAME]
Kris
[NAME]
[NAME]
[NAME]
Vince
AE total submissions for month | March | April | May | June | July | August | September | October | November | December
Abdul
[NAME]
[NAME]
[NAME]
[NAME]
Dirk
Jessica
[NAME]
[NAME]
[NAME]
Kris
[NAME]
[NAME]
[NAME]
Vince
Average submission count
AE exception % of their individual submissions
Abdul
[NAME]
[NAME]
[NAME]
[NAME]
Dirk
Jessica
[NAME]
[NAME]
[NAME]
Kris
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] is great
[NAME]
Vince
Average exception %
Exception Type by Frequency
Prelim (Missing or >45)
Paystubs (>30)
Asset ( >45)
Asset Missing (pages or missing entirely)
Missing W2
Missing 4506
Credit Report (>45)
Bank Statement
 |  |  | AWESOMESAUCE!
Spreadsheet: eric_saibi__9961__110801
Sheet: Diablo Canyon 01

Owner Name | Pacific Gas and Electric Company
Station Name | Diablo Canyon Nuclear Power Station
Unit Name | [NAME]
NERC Region | WSCC
State | CA
Fuel Type | Nuclear
Capacity | 1,137 MW
Start Date | 2001-11-09 00:00:00
End Date | 2001-11-13 00:00:00
Comments | Derated 50% now due to a vibration in the unit. Will be at 0% starting late Friday or early Saturday for repairs.
SIC | 4911
Plant ID | 1016043
Unit ID | 1004942
Outage ID | 18832
Spreadsheet: 0a2b3e64-3140-47d8-acbb-b7f194c40023
Sheet: Sheet1

 | IB 350 International Trade  - Planned Schedule  - Spring 2012  (subject to change)
 | Dr. [NAME]
 | DATE |  | TOPIC | Text/Reading Assignments*
 | SECTION 1:  The Global Economy  - Laying a foundation
 | Jan | 17 | Overview of course themes | Reading/Syllabus
 |  | 19 | What's going on in the Global Economy? | Ch. 1
 |  | 24 | Globalization - for better or worse | Ch. 1 Quiz
 |  | 26 | Prospects for globalization | Ch. 1 Review & Readings*
 |  | 31 | Differences between nations:  Political and Legal Systems | Ch. 2 - Quiz
 | Feb | 2 | Is global poverty fixed?  Influences on Development | Ch. 2 Readings *
 |  | 7 | How do firms "go international"? (at 1,000 mph) | Ch. 12  and Summary Chart - Quiz
 |  | 9 | Ethical decision in IB | Ch. 4 - Quiz
 |  | 14 | Corruption and other Ethical issues | Ch. 4 Readings*
 |  | 16 | Exam 1 | Ch. 1,2 4,12  & Readings
 |  | 17
 | SECTION 2:  Government Involvement in the Global Economy
 |  | 21 | Exam 1 Review/ Classical Trade Theory | Ch. 5  - Quiz
 |  | 23 | Why do Countries Engage in Trade? Newer Answers | Ch. 5 -  Readings*
 |  | 28 | Who cares about the Balance of Payments? | App A (p. 197 - 201) & Lecture Note -  QUIZ
 | Mar | 1 | Protectionism and the Role of the WTO | Ch. 6 -  QUIZ
 |  | 6 | The Future of the WTO? | Ch. 6 [NAME]*
 |  | 8 | FDI:  Patterns and Perspectives | Ch. 7  - Quiz
 |  | 13/15 | SPRING BREAK | Have fun and be careful!
 |  | 20 | FDI: Blessing or [NAME]? | Ch. 7 Readings *
 |  | 22 | Exam 2 | BOP, [NAME]. 5, 6, 7 & Readings
 |  | 27 | Exam 2 Review/ Regional Integration - Past and Future | Ch. 8
 |  | 29 | Integration in the EU/Will the [NAME] survive? | Ch. 8 Quiz/Readings - EU
 | Apr | 3 | Trade in the Hood/Regional vs. Global Integration | Ch. 8 Readings - Latin America*
 | SECTION 3: Money, Money, Money
 |  | 5 | Intro to the Forex | Ch. 9 -  Quiz
 |  | 10 | How are Exchange Rates Determined? (The Forex Files) | Ch. 9 Readings
 |  | 12 | Speculation and Arbitrage | Ch. 9 [NAME]*
 |  | 17 | International Monetary System | Ch. 10 Quiz
 |  | 19 | How the World Manages Money (Monetary Systems) | Ch. 10 Readings
 |  | 24 | Hamlet and the Forex (To fix or to [NAME]? That is the question) | Ch. 10  Readings*
 |  | 26 | Crises in the Monetary System -  IMF:  Savior or Satan? | Ch. 10 (p. 356 - 369)
 | May | 1 | EXAM 3 | Ch. 8, 9, 10, and Readings
 |  | 3 | Course Wrap-up/Exam 3 Review/Final Exam Info
 | May | 10 | (Thursday) FINAL EXAM:   Best Estimate  9:00 - 10:30 AM
 | May | 14 | (Monday) FINAL EXAM:   Best Estimate 9:00 - 10:30 PM
 | All students may take either Final above.  Student in 3:30 PM class may arrange another date if these have conflicts.
 | May | 19 | GRADUATION DAY FOR SENIORS (you hope… :-) )
 | NOTE:   days marked with "*" will have dedicated discussion times
Spreadsheet: 721397d1614690364-need-help-to-remove-false-and-shorten-the-formula-sample-workbook-revised-
Sheet: Prototype

Care Setting: |  |  |  | Start Point: | Free text field |  | Total Manpower Cost:
Length of Inpatient Stay: |  |  |  | End Point: | Free text field |  | Total Non-Manpower Cost:
Date of Update: |  |  |  | Exclusions: | Free text field |  | Overall Cost per Carepath:
S/N | Type of Cost | Type of Care Setting | Activity/ Therapy/ Procedures | Profession | Seniority | Generic Cost from Finance (Manpower) | FTE required | Activity Duration (minutes) | Manpower Cost per Activity | Generic Cost from Finance (Non-Manpower) | Non-Manpower Cost based on LOS
1 | Manpower Cost
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
Spreadsheet: 0aaf25eb-8796-401f-aa82-6aa6a39f0b03
Sheet: Example

 | Outbreak Name:
 |  | Total Residents: | 40 |  |  |  | Case definition: Anyone ill with vomit and/or at least diarrhea x2 within 24 hours. If resident/staff
 |  | Total Staff: | 10 |  |  |  |  | meets case definition, enter info into linelist.
 |  |  |  |  |  |  | SYMPTOMS |  |  |  |  |  |  |  |  |  |  |  |  | POTENTIAL HIGH RISK POPULATIONS |  |  | LAB TESTING |  |  |  | OUTCOMES
 | Name | Res/Staff? (R/S) | Unit | Age | Sex   (M/F) |  | Onset date | Date of Last Symptoms | Duration of Symptoms (days) |  | [NAME]i 24 hr (Y/N) | Bloody diarrhea (Y/N) | Vomiting (Y/N) | Nausea (Y/N) | Abdominal cramps (Y/N) | Fever >100.4˚ (Y/N) | Headache (Y/N) | Other (specify) |  | Pregnant | Immunocompromised |  | Stool sample tested? (Y/N) | Positive for Norovirus? (Y/N) | Comments/ Results |  | Hospitalized?  (Y/N) | Died?
 | [NAME] | R | 14-F | 80 | M |  | 2011-02-01 00:00:00 | 2011-02-06 00:00:00 | 6 |  | Y | Y | Y | N | N | Y | Y |  |  | N | Y |  | N | N |  |  | Y | N
 | [NAME] | S | front desk | 40 | F |  | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2 |  | Y | N | N | N | N | N | N |  |  | N | N |  | N | N |  |  | N | N
 | [NAME] | S | F-wing | 25 | M |  | 2011-02-03 00:00:00 | 2011-02-05 00:00:00 | 3 |  | N | N | Y | Y | N | N | N |  |  | N | N |  | N | N |  |  | N | N
 | [NAME] | S | F-wing | 35 | F |  | 2011-02-05 00:00:00 | 2011-02-09 00:00:00 | 5 |  | Y | Y | Y | Y | N | N | N |  |  | Y | N |  | Y | N | positive for C. difficile |  | Y | N
 | [NAME] | R | 10-F | 55 | M |  | 2011-02-06 00:00:00 | 2011-02-08 00:00:00 | 3 |  | Y | N | Y | Y | Y | Y | N |  |  | N | N |  | N | N |  |  | Y | N
 | [NAME] | R | 8-F | 60 | F |  | 2011-02-06 00:00:00 | 2011-02-06 00:00:00 | 1 |  | Y | N | Y | Y | Y | Y | N |  |  | N | N |  | N | N |  |  | N | Y
 | [NAME] | R | 10-F | 77 | M |  | 2011-02-08 00:00:00 | 2011-02-09 00:00:00 | 2 |  | Y | Y | N | Y | Y | Y | N |  |  | N | N |  | N | N |  |  | N | N
 | [NAME] | R | 5-F | 93 | F |  | 2011-02-09 00:00:00 | 2011-02-11 00:00:00 | 3 |  | Y | Y | Y | Y | N | N | N |  |  | N | Y |  | Y | N | positive for C. difficile |  | Y | Y
Spreadsheet: 763196d1642037789-formula-calculation-with-multiple-conditions-copy-of-book2
Sheet: Sheet1

 |  |  |  | Number of Fields each customer owns of respective Crop
 | Customer | Product Name (ENG) | Price Paid | Corn | Cereals | Vine | Apples | [NAME] | Carrots |  | Product Name | Crop
 | A | ADENGO SC465 | 100 | 57.69230769230769 | 184.6153846153846 | 57.69230769230769 | 0 | 0 | 0 |  | ADENGO SC465 | Corn
 | B | BETANAL EXPERT EC274 | 200 | 95.88340577857326 | 97.49424699565327 | 0 | 49.09230375862951 | 57.53004346714395 | 0 |  | BELT SC480 | Corn
 | C | BELT SC480 | 300 | 57.69230769230769 | 184.6153846153846 | 57.69230769230769 | 0 | 0 | 0 |  | BELT SC480 | Carrots
 | D | BELT SC480 | 400 | 63.64922206506365 | 172.7015558698727 | 63.64922206506365 | 0 | 0 | 0 |  | BELT SC480 | Vine
 | E | ADENGO SC465 | 500 | 63.64922206506365 | 172.7015558698727 | 63.64922206506365 | 0 | 0 | 0 |  | BELT SC480 | Cereals
 | F | ADENGO SC465 | 600 | 40.74074074074074 | 185.1851851851852 | 74.07407407407408 | 0 | 0 | 0 |  | BETANAL EXPERT EC274 | Cereals
 | G | TILMOR EC240 | 700 | 72.35256816740647 | 109.7019657577679 | 0 | 46.29042485732403 | 64.04565630944832 | 7.609384908053266 |  | PROPULSE SE250 | [NAME]
 | H | PROPULSE SE250 | 800 | 63.64922206506365 | 172.7015558698727 | 63.64922206506365 | 0 | 0 | 0 |  | PROPULSE SE250 | Apples
 |  |  |  |  |  |  |  |  |  |  | PROPULSE SE250 | Vine
 |  |  |  |  |  |  |  |  |  |  | TILMOR EC240 | Apples
 | Manual Solution |  |  | Revenue generated per customer with each crop |  |  |  |  |  |  | TILMOR EC240 | Vine
 | Customer | Product Name (ENG) | Price Paid | Corn | Cereals | Vine | Apples | [NAME] | Carrots
 | A | ADENGO SC465 | 100 | 100
 | B | BETANAL EXPERT EC274 | 200 |  | 200
 | C | BELT SC480 | 300 | 57.69230769230769 | 184.6153846153846 | 57.69230769230769
 | D | BELT SC480 | 400 | 84.86562942008487 | 48.854754135749 | 10.36522364973458
 | E | ADENGO SC465 | 500 | 500
 | F | ADENGO SC465 | 600 | 600
 | G | TILMOR EC240 | 700 |  |  |  | 700
 | H | PROPULSE SE250 | 800 |  |  | 800
 | [NAME] E27:[NAME] |  |  | Revenue generated per customer with each crop
 | Customer | Product Name (ENG) | Price Paid | Corn | Cereals | Vine | Apples | [NAME] | Carrots
 | A | ADENGO SC465 | 100
 | B | BETANAL EXPERT EC274 | 200
 | C | BELT SC480 | 300
 | D | BELT SC480 | 400
 | E | ADENGO SC465 | 500
 | F | ADENGO SC465 | 600
 | G | TILMOR EC240 | 700
 | H | PROPULSE SE250 | 800
Spreadsheet: 128670d1321184219-conditional-formatting-using-formulas-book1
Sheet: Sheet1

 |  | a1 | b1 | c1 | d1 | e1 | f1
 |  | - | 12 | 160 | 1 | 24 | 1
 |  | - | 1 | 27 | 1 | 2 | 1
 |  | - | 1 | 16 | 1 | 30 | 9
 |  | - | 2 | 14 | 1 | 7 | 33
 |  | - | 1 | 10 | 1 | 11 | 1
 |  | - | 4 | 4 | 4 | 1 | 1
 |  | - | - | - | - | 1 | 1
 |  | - | - | - | - | 1 | 1
 |  | - | - | - | 1 | 1 | 1
 |  | - | - | - | 6 | 12 | 88
 |  | - | - | - | - | 2 | 28
 |  | - | - | - | 3 | 1 | 27
 |  | - | - | - | - | 1 | 8
 |  | - | - | - | - | - | -
 |  | - | - | - | 5 | - | -
 | averages per column | 11 | 4 | 11 | 5 | 8 | 21
Spreadsheet: 31aebef3-8b78-4d59-aaea-9f6307cbd240
Sheet: Sheet1

Start Date | End Date | Meeting Name | HQ Hotel | Venues | Attendees
2014-09-08 00:00:00 | 2014-09-08 00:00:00 | Center for Transportation Safety Driver Safety Class | Cashman Center | Cashman Center | 20
2014-10-20 00:00:00 | 2014-10-20 00:00:00 | Nevada Future Business Leaders Fall Leadership Extravaganza | Cashman Center | Cashman Center | 650
2014-09-02 00:00:00 | 2014-09-02 00:00:00 | Clark County School District Social Studies Teacher Training | Cashman Center | Cashman Center | 1000
2014-11-22 00:00:00 | 2014-11-22 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
2014-10-25 00:00:00 | 2014-10-25 00:00:00 | Seventh-Day Adventist Church Nevada / Utah Conference Las Vegas Convocation | Cashman Center | Cashman Center | 5000
Spreadsheet: 03521272-89bf-4849-9718-a35a9154914b
Sheet: FY 2012 Lease Turnover Analysis

FY 2012 Lease Turnover Analysis
Disposition Of Leases Expiring in FY 2012 | Sq Ft | % of Total Sq Ft | Count | % of Total Count
Leases Scheduled to Expire in FY 2012 | 33034410.1 | 1 | 1919 | 1
Extended in FY 2012 Beyond FY 2012 | 16212853.09 | 0.4907868201951031 | 919 | 0.4788952579468473
Renewed During FY 2012 | 2264180 | 0.06854004636819593 | 134 | 0.06982803543512246
Replaced in Same Building with New Leases | 3126455 | 0.09464237413459972 | 223 | 0.116206357477853
Subtotal | 21603488.09 | 0.6539692406978987 | 1276 | 0.6649296508598228
Leases Terminated | 4070215 | 0.123211372253322 | 165 | 0.0859822824387702
Leases Moved to Another Leased Building | 7360707.01 | 0.2228193870487792 | 478 | 0.249088066701407
Subtotal | 11430922.01 | 0.3460307593021011 | 643 | 0.3350703491401772
[Non-add: Leases Terminated - Move to Federal Bldg | 125019 | 0.0037845083239431 | 21 | 0.01094319958311621
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 1091152 | 0.03303076993646694 | 92 | 0.04794163626889004
Disposition of Leases Expiring After FY 2012
Leases Scheduled to Expire After FY 2012 | 161145433.91 | 1 | 6985 | 1
Lease Replaced In Same Leased Building After [NAME] | 105691 | 0.0006558733774549803 | 15 | 0.002147458840372226
Lease Replaced In Same Leased Building Before Firm Term | 129112 | 0.0008012141384788433 | 7 | 0.001002147458840372
Lease Replaced In Different Leased Building After [NAME] | 306981 | 0.001904993474226825 | 29 | 0.00415175375805297
Lease Replaced In Different Leased Building Before Firm Term | 41197 | 0.0002556510538363042 | 3 | 0.0004294917680744452
Lease Terminate W/O Lease Replacement After [NAME] | 1441225 | 0.008943629149336784 | 67 | 0.009591982820329277
Lease Terminate W/O Lease Replacement Before Firm Term | 179579 | 0.001114390868191122 | 19 | 0.002720114531138153
[Non-add: Leases Terminated - Move to Federal Bldg | 92768 | 0.0005756787378276638 | 8 | 0.001145311381531854
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 943076 | 0.005852328403712076 | 66 | 0.009448818897637795
FY 2012 Lease Turnover
Total Leases At Start of FY 2012 | 194179844.01 | 1 | 8904 | 1
Same/Replacement Leases Continued Past FY 2012 | 180779940 | 0.9309923021191122 | 8143 | 0.9145327942497754
Same Lease Space Dis-Continued Past FY 2012 (Turnover) | 13399904.01 | 0.06900769788088781 | 761 | 0.08546720575022462
[Non-add: Leases Terminated - Move to Federal Bldg | 217787 | 0.001121573668525474 | 29 | 0.00325696316262354
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 2034228 | 0.01047599976388507 | 158 | 0.01774483378256963
1/ Only counts actions where leases had to be terminated due to customer office closures, partial reductions in space not included.
Spreadsheet: 292920d1390835941-how-to-select-one-of-six-cell-values-depending-on-the-value-of-another-cell-select-a-value-from-a-choice-of-6-possible-cells
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choose
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Selection | Value | Selection | Value | Selection | Value | Selection | Value | Selection | Value | Selection | Value |  |  |  | Answer
 |  | 1 | 257 | 2 | 631 | 3 | 475 | 4 | 209 | 5 | 987 | 6 | 105
 |  | What I would like to do is to change the number in cell P3, and have the spreadsheet enter the value that is next to the selection number in row 6, into cell R6. So If I enter a 1 into cell P3, I want the answer cell(R6) to display the value for selection 1, which is 257. Selection 2 would copy the value of 631 into the answer cell etc. etc.
Spreadsheet: 47284d1246308764-job-hour-summary-using-daily-pivot-totals-can-it-be-done-weekly-timesheet-summary-7-days-
Sheet: Wednesday

2009-01-14 00:00:00 | Wednesday
Job # | Employee | Total Hours
870 |  | 1.5
 | [NAME] | 1.5
1223-5567 |  | 50
 | [NAME] | 4
 | [NAME] | 5.5
 | [NAME] | 2.5
 | [NAME] | 8
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 3
 | [NAME] | 4.5
 | [NAME] | 3
 | [NAME] | 8
 | [NAME] | 4
 | [NAME] | 2.5
5553-6789 |  | 6.5
 | [NAME] | 6.5
5553-6788 |  | 1.5
 | [NAME] | 1.5
shop |  | 16.5
 | [NAME] | 8.5
 | [NAME] | 8
yard |  | 8
 | Cecil Elliot | 8
7445-1234 |  | 3
 | [NAME] | 3
7445-1235 |  | 5
 | [NAME] | 5
out |  | 0
 | Chase Payne | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | Pascual Mateo | 0
shipping office |  | 12
 | [NAME] | 8
 | [NAME] | 4
6789-9433 |  | 10.5
 | [NAME] | 2.5
 | [NAME] | 8
4567-9089 |  | 4
 | [NAME] | 4
5678-2345 |  | 1.5
 | [NAME] | 1.5
shop/tool manitenance |  | 3
 | [NAME] | 3
4567-7543 |  | 5
 | [NAME] | 3.5
 | [NAME] | 1.5
4568-8467 |  | 3
 | [NAME] | 3
870 |  | 2
 | [NAME] | 2
4567-8211 |  | 1.5
 | [NAME] | 1.5
4567-8210 |  | 2.5
 | [NAME] | 2.5
4568-9832 |  | 3.5
 | [NAME] | 2
 | [NAME] | 1.5
load trucks |  | 7.5
 | [NAME] | 4
 | [NAME] | 3.5
3450-6743 |  | 2.5
 | [NAME] | 2.5
5678-3832 |  | 7
 | [NAME] | 3.5
 | [NAME] | 3.5
3456-9876 |  | 5.5
 | [NAME] | 2
 | [NAME] | 3.5
Tarmac schematic |  | 2
 | [NAME] | 2
sales |  | 3
 | [NAME] | 3
design |  | 6.5
 | [NAME] | 6.5
Grand Total |  | 174.5
Spreadsheet: 880848d1728676449-cross-reference-data-in-2-columns-time-and-shift-book1
Sheet: Sheet2

 |  | Shift
 | Dept | 1 | 2 | 3
 | Grocery | 32
 | Deli | 141 | 32 | 29
 | Meat |  | 17
 | Freezer | 50 |  | 50
 | Produce | 99 | 44
Injury by shift |  |  |  | Shift/Months of Service
1 | 2 | 3 |  | 1 - <6
 |  |  |  | 1 - >6
 |  |  |  | 1 - 1y+
Injury by hire time
<6 | <12 | 1year+ |  | 2 - <6
 |  |  |  | 2 - >6
 |  |  |  | 2 - 1y+
 |  |  |  | 3 - <6
 |  |  |  | 3 - >6
 |  |  |  | 3 - 1y+
Spreadsheet: 47996d1247169550-adding-mm-ss-schedule-adherence-draft
Sheet: OP Stats

 |  |  | BCMS Vu Agent Daily Summary Report |  |  |  |  | Page 1
 |  |  | From: 6/1/2009  To: 6/30/2009
 |  |  | Days of Week Included: Monday Tuesday Wednesday Thursday Friday
 |  | AVG | TOTAL | TOTAL | TOTAL |  | AVG | TOTAL | TOTAL
 | ACD | TALK | AFTER | AVAIL | AUX/ | EXTN | EXTN | TIME | HOLD
Agent | CALLS | TIME | CALL | TIME | OTHER | CALLS | TIME | STAFFED | TIME
7302 | 1411 | 2:27 | 830:39 | 1,167:30 | 659:12 | 256 | 0:47 | 6,108:58 | 48:08
7305 | 62 | 3:04 | 232:25 | 0:39 | 37:53 | 7 | 1:05 | 460:24 | 3:40
7312 | 1708 | 2:43 | 370:44 | 3,069:54 | 1,546:46 | 255 | 1:20 | 9,628:46 | 57:21
7313 | 2060 | 2:13 | 418:23 | 4,023:16 | 1,861:44 | 235 | 1:25 | 10,871:18 | 106:10
7314 | 1873 | 2:38 | 249:37 | 3,629:01 | 1,917:29 | 312 | 1:55 | 10,727:53 | 163:32
7317 | 1337 | 2:20 | 4,004:43 | 1,228:12 | 1,405:29 | 425 | 1:41 | 9,767:53 | 115:02
7322 | 1466 | 2:19 | 239:53 | 1,686:20 | 1,169:24 | 174 | 1:06 | 6,485:32 | 86:50
7324 | 1478 | 2:32 | 1,099:35 | 1,902:05 | 1,994:56 | 164 | 0:54 | 8,725:54 | 109:01
7360 | 1529 | 2:31 | 114:52 | 2,747:55 | 1,523:44 | 154 | 1:25 | 8,217:26 | 86:54
7361 | 846 | 2:39 | 537:25 | 1,514:57 | 1,154:35 | 136 | 2:17 | 5,450:52 | 33:32
7377 | 2158 | 2:25 | 448:49 | 3,285:04 | 2,457:49 | 326 | 2:01 | 11,419:52 | 73:38
7378 | 1451 | 2:25 | 88:59 | 2,580:22 | 1,465:23 | 195 | 1:43 | 7,638:02 | 73:42
7379 | 2185 | 2:06 | 399:33 | 4,101:14 | 2,549:45 | 183 | 0:40 | 11,651:21 | 53:10
7806 | 5 | 2:17 | 9,898:43 | 0:00 | 2,642:28 | 572 | 4:23 | 12,552:35 | 0:10
7813 | 1823 | 2:13 | 76:45 | 1,995:34 | 3,545:12 | 634 | 1:42 | 9,650:19 | 232:41
7816 | 2238 | 2:06 | 520:50 | 2,599:55 | 2,199:18 | 394 | 1:39 | 10,033:38 | 138:35
7819 | 854 | 2:47 | 7,947:53 | 27:24 | 1,559:13 | 525 | 1:50 | 11,905:47 | 39:11
7821 | 1459 | 2:20 | 1,415:49 | 1,693:23 | 1,825:30 | 299 | 1:21 | 8,327:02 | 125:32
7822 | 1371 | 2:35 | 112:07 | 1,243:31 | 6,119:21 | 501 | 1:29 | 11,019:22 | 83:21
7826 | 226 | 2:26 | 79:34 | 184:27 | 253:47 | 55 | 0:41 | 1,068:36 | 10:27
7833 | 164 | 2:36 | 0:00 | 0:52 | 53:33 | 15 | 1:31 | 480:14 | 5:19
7841 | 1215 | 2:37 | 534:59 | 1,089:41 | 795:02 | 200 | 0:58 | 5,594:35 | 43:58
7849 | 200 | 2:25 | 15:25 | 17:29 | 29:13 | 16 | 0:47 | 545:22 | 12:28
7855 | 1530 | 3:19 | 2,526:56 | 1,316:52 | 1,328:59 | 451 | 1:19 | 10,247:26 | 194:30
7866 | 692 | 2:19 | 8,730:42 | 113:40 | 942:25 | 404 | 2:18 | 11,388:00 | 13:03
7884 | 2026 | 1:52 | 850:16 | 3,290:46 | 2,901:28 | 555 | 1:56 | 10,806:10 | 479:44