tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 425LS

425LS
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO ASSISTED | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 2009-05-14 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
meneese |  | 2009-04-09 00:00:00
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 733174d1621428157-how-to-return-date-format-in-cell-instead-of-general-format-blank-project-planner_eh
Sheet: Background stuff_DO NOT AMEND!

Andi |  |  |  |  |  | On hold |  |  |  |  |  |  | Low |  | No |  |  | N/A
[NAME] |  |  |  |  |  | Not Started |  |  |  |  |  |  | Medium |  | Yes |  |  | 0
[NAME] |  |  |  |  |  | In progress |  |  |  |  |  |  | High |  | N/A |  |  | 1
Ray |  |  |  |  |  | Completed |  |  |  |  |  |  |  |  | TBC |  |  | 2
Rohit |  |  |  |  |  | Total Tasks |  |  |  |  |  |  |  |  |  |  |  | 3
[NAME]
Shetal
Shetal & Molly
Other (specify in notes)
Spreadsheet: 778d20f8-bf58-4298-b5be-e90ad86a4a7e
Sheet: Sheet1

CIBER Hourly Rates | Unnamed: 1 | Unnamed: 2
 | Category One | [NAME]
 | Technology Strategy Consultant | 95
 | Project Manager | 80
 | IT Project Logistics Support | 48
 | Business Analyst | 72
 | Business Architect | 80
 | Category Two | [NAME]
 | Project Manager | 80
 | Programmer/System Analyst | 60
 | Programmer | 50
 | Quality Assurance Inspector/Analyst | 58
 | Quality Control Planner | 55
 | Quality Control Testers | 52
 | Technical Writer | 45
 | IT End-User Trainer | 48
 | Category Five | [NAME]
 | [NAME] | 70
 | Data Analyst/Administrator | 70
 | Data Architect | 85
 | Data Warehousing & Busn Intel Developer | 80
 | Category Six | [NAME]
 | Network Administrator | 65
 | Network Specialist | 64
Spreadsheet: 107621d1304735961-excel-2007-help-with-formulas-examplefractions
Sheet: Sheet2

1 | 2 | 5 | 3 | 2
3 | 5 | 2 | 1 | 1
2 | 9 | 2 | 3 | 1
5 | 15 | 3 | 2 | 0
Spreadsheet: larry_campbell__20964__Kingman3
Sheet: Turbine

[NAME]
RED ROCK EXPANSION PROJECT
KINGMAN COMPRESSOR STATION
Table 1
TURBINE INFORMATION
Manufacturer: | GE LM2500
Fuel Type: | Sweet Natural Gas
HHV: | 1020 | Btu/scf
Site Elevation: | 5063
Inlet Loss: | 4 | in H2O
Exhaust Loss: | 4 | in H2O
Shaft Power: | 40916 | hp @ 12.8oF (Base Load)
 | 33526 | hp @ 60oF (Base Load)
[NAME]: | 9429 | Btu/hp-hr @95oF (50% Load)
 |  | [NAME]/hr | ([NAME] x shp@12.8oF)
[NAME]: | 6298 | Btu/hp-hr @60oF (Base Load)
 |  | [NAME]/hr | ([NAME] x shp@60oF)
Speed: | 6100 | rpm
[NAME]: |  | [NAME]/hr | ([NAME])
[NAME]: |  | [NAME]/hr | (Avg Heat Rate/HHV)
Annual Fuel: |  | [NAME]/yr | ([NAME])
Potential Emissions
Temp | Turbine | NOx (as NO2) |  | CO |  | THC
(oF) | Load (%) | (lb/hr) | (tpy) | (lb/hr) | (tpy) | (lb/hr) | (tpy)
0 | Base | 24.6 |  | 15 |  | 5.1
0 | 64 | 27.8 |  | 16.9 |  | 5.9
0 | 50 | 25.2 |  | 15.3 |  | 5.4
12.8 | Base | 24.9 |  | 15.2 |  | 5.1
12.8 | 50 | 24.7 |  | 15 |  | 5.3
40 | Base | 22.8 |  | 13.8 |  | 4.7
40 | 50 | 22.5 |  | 13.7 |  | 4.8
60 | Base | 21.2 |  | 12.9 |  | 4.4
60 | 50 | 14.5 |  | 8.8 |  | 3
95 | Base | 18.5 |  | 11.3 |  | 3.8
95 | 50 | 13.1 |  | 8 |  | 2.7
 | [NAME]
 | Base [NAME] | 24.9
[NAME] (04/00)
PM | 0.0066 | lb/MMBtu
SO2 | 0.0034 | lb/MMBtu
Formaldehyde | 0.00071 | lb/MMBtu
Proposed Turbine Emissions
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX |  |  | @base load 80% of time, 64% load 20% of time
CO |  |  | @base load 80% of time, 64% load 20% of time
VOC |  |  | @base load 80% of time, 64% load 20% of time; assume 10% NMHC.
PM |  |  | @max hourly based on [NAME] heat rate, annuals based on avg heat rate
SO2 |  |  | @max hourly based on [NAME] heat rate, annuals based on avg heat rate
Formaldehyde |  |  | @max hourly based on [NAME] heat rate, annuals based on avg heat rate
Proposed [NAME] with 15% Safety Factor
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX
CO
VOC
PM
SO2
Formaldehyde
Spreadsheet: 106b466c-4170-4914-9db4-f99032fb90bc
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 21. Value of Dwelling Units Approved in New Residential Buildings, Original, 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 ;  New ;  Total houses ; |  |  | Original | A418405W | 1970-07-01 00:00:00 | 2010-11-01 00:00:00 | 485 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415787K | 1991-07-01 00:00:00 | 2010-11-01 00:00:00 | 233 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422928K | 1991-07-01 00:00:00 | 2010-11-01 00:00:00 | 233 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416423R | 1991-07-01 00:00:00 | 2010-11-01 00:00:00 | 233 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423531F | 1991-07-01 00:00:00 | 2010-11-01 00:00:00 | 233 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424176T | 1991-07-01 00:00:00 | 2010-11-01 00:00:00 | 233 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424728C | 1991-07-01 00:00:00 | 2010-11-01 00:00:00 | 233 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417065V | 1991-07-01 00:00:00 | 2010-11-01 00:00:00 | 233 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total other residential building ; |  |  | Original | A419140V | 1970-07-01 00:00:00 | 2010-11-01 00:00:00 | 485 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total residential building ; |  |  | Original | A419826L | 1956-01-01 00:00:00 | 2010-11-01 00:00:00 | 659 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 862855d1710432254-due-date-exercise-due-date-exercise-aligw
Sheet: Sheet1

 |  |  |  |  |  | DEADLINE (DAYS)
 |  |  |  |  |  | 30
 |  | Doc. No. | Title | Submitted Date | Review Status | DUE STATUS
 |  | NCR-C-0335 | Work Procedure for Corrective action | 2024-02-01 00:00:00 | PENDING
 |  | JFGP-HD-MNF-002 | [NAME] | 2024-03-10 00:00:00 | PENDING
 |  | JUS&ICS-ME-PD-7709 | Procedure for Gasket Installation and Bolt Tightening_AIC | 2024-01-20 00:00:00 | FOR INFORMATION
 |  | MME-J-623 | Request for Approval of Test Manifold (Valve) | 2024-02-12 00:00:00 | APPROVED
 |  | JUS&ICS-PM-PD-6031 | Construction NDT and PWHT Matrix per Line Class | 2024-03-01 00:00:00 | REJECTED
 |  |  |  | EXPECTED OUTPUT
 |  | Doc. No. | Title | Submitted Date | Review Status | DUE STATUS
 |  | NCR-C-0335 | Work Procedure for Corrective action | 2024-02-01 00:00:00 | PENDING | DUE
 |  | JFGP-HD-MNF-002 | [NAME] | 2024-03-10 00:00:00 | PENDING | NOT DUE
 |  | JUS&ICS-ME-PD-7709 | Procedure for Gasket Installation and Bolt Tightening_AIC | 2024-01-20 00:00:00 | FOR INFORMATION | DUE
 |  | MME-J-623 | Request for Approval of Test Manifold (Valve) | 2024-02-12 00:00:00 | APPROVED | NOT DUE
 |  | JUS&ICS-PM-PD-6031 | Construction NDT and PWHT Matrix per Line Class | 2024-03-01 00:00:00 | REJECTED | NOT DUE
1. Please, I need a formula / function that will help me identify on my document register of which document or documents review status was already in 30 days from the submitted date up to the current date (as per the setting of days in G2 cell, for me to easily toggle or change whatever days needed)
2. "DUE" will be the output for the document in which the review status was "PENDING" or "FOR INFORMATION" with reference to the submitted date to the today date
3. If possible please include in the formula the cell G2 for me to toggle or change to any date the deadline
Spreadsheet: joe_parks__14593__ECS LLC Nomination Model 2002 with Noms2
Sheet: TW Demand Revenue

ENA/Bisti & Bloomfield Compressor Stations
2001 ENA Demand Revenue
2001 ENA Revenue | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Totals | 2001 Average
Bisti Demand Revenue | 168121.75 | 168121.75 | 168121.75 | 168121.75 | 168121.75 | 168121.75 | 168121.75 | 168121.75 | 168121.75 | 168121.75 | 0 | 0 |  |  |  |  | 2001 Contract Terms
Bloomfield Demand Revenue | 64764.42 | 64764.42 | 64764.42 | 64764.42 | 64764.42 | 64764.42 | 64764.42 | 64764.42 | 64764.42 | 64764.42 | 0 | 0 |  |  |  |  | 2001 Contract Terms
Gallup Demand Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  | 1681217.5 |  | 542274.96 | 2001 Contract Terms
Total Demand Revenue
2002 Revenue Forecast | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total | Average
Bisti Demand Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2083946 | 2002 Contract Terms
Bloomfield Demand Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 797229 | 2002 Contract Terms
Gallup Demand Revenue
2002 Total Demand Revenue
Spreadsheet: 525084d1498549076-need-help-looking-for-a-formula-that-will-will-extract-data-by-date-and-employee-number-review
Sheet: Sheet1

57022 | PA | LD | RM | Pallets | Cases | Lines | PA Hrs | [NAME] | [NAME] | RECV Hrs | Payroll Hrs | Labor Hrs | Total Trans | [NAME] | PA PH | PA % | [NAME] | LD PH | LD % | RECV [NAME] | RECV PH | Recv   % | Labor %
2017-01-14 00:00:00
 | 12 | 45 | 2 | 216 | 2847 | 203 | 0.4194444444444444 | 2.508888888888889 | 0.015 | 10.045 | 10.52 | 12.98833333333333 | 275 | 24 | 28.60927152317881 | 1.19205298013245 | 17 | 17.9362267493357 | 1.055072161725629 | 40 | 21.50323544051767 | 0.5375808860129417 | 1.234632446134347
 | 31 | 30 | 0 | 5 | 46 | 5 | 0.8255555555555554 | 1.206944444444444 | 0 | 9.373611111111112 | 9.2 | 11.40611111111111 | 66 | 24 | 37.55047106325707 | 1.564602960969045 | 17 | 24.85615650172612 | 1.462126853042713 | 40 | 0.5334123573862795 | 0.01333530893465699 | 1.239794685990338
 | 116 | 3 | 0 | 0 | 0 | 0 | 5.1725 | 0.1016666666666667 | 0 | 6.924444444444444 | 8.53 | 12.19861111111111 | 119 | 24 | 22.42629289511842 | 0.934428870629934 | 17 | 29.50819672131148 | 1.735776277724205 | 40 | 0 |  | 1.430083365898137
 | 71 | 45 | 2 | 0 | 0 | 0 | 2.142777777777778 | 2.819166666666667 | 0.04416666666666667 | 7.806666666666667 | 8.7 | 12.81277777777778 | 118 | 24 | 33.13456053927923 | 1.380606689136634 | 17 | 15.96216375997635 | 0.9389508094103736 | 40 | 0 |  | 1.472733077905492
Spreadsheet: 878140d1725134946-amortization-for-those-payday-loans-with-apr-300-samstam-sample-amortization
Sheet: Cash Net

Loan amortization schedule without term
Name | Cash Net
Loan Amount | 1000
APR | 4.2151
Monthly Payment | 457.73
Monthly Interest
 | Below is incorrect.
Month | Beginning Balance | Payment | Interest | Principal | Ending Balance
1
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
Spreadsheet: 93186d1292786513-transpose-column-data-to-row-data-example001
Sheet: Sheet1

current data | transposed data
AP,A | AP,A | Air Filtration Systems for the Army National Guard | 1600000 | --- | Bond
Air Filtration Systems for the Army National Guard
1600000
---
Bond
AP,A | AP,A | Air Warrior Survival Vest Ensemble Reset Program | 2400000 | --- | Warner, Webb
Air Warrior Survival Vest Ensemble Reset Program
2400000
---
Warner, Webb
AP,A | AP,A | Damage Tolerance Improvement and Monitoring for Condition Based Maintenance | 2080000 | --- | Shelby
Damage Tolerance Improvement and Monitoring for Condition Based Maintenance
2080000
---
Shelby
Spreadsheet: 713232d1610611528-help-with-a-formula-to-average-if-cell-value-appears-in-one-of-two-columns-average-when-looking-at-a-table-with-data-in-two-rows
Sheet: Sheet1

 | Oeste | I need a formula to find the average of the numbers in column C: of Oeste's (cell B1) games  within the table below, but with the following conditions
 |  | If [NAME] appears in Column A, use the value in the equivalent cell in column C
 |  | If instead [NAME] appears in Column B, use the value *-1 of the equivalent cell in column C
 |  | Therefore it should be the average of the following numbers:
 | 0.06 | vs Chapecoense from row 19
 | -1.02 | vs CRB on row 28
 | 0.76 | vs Brazil de Pelotas on row 33
 | -0.84 | vs [NAME] on row 40
 |  | AVERAGE of those numbers
Confianca | Parana | 1.432
[NAME] | CRB | 1.272
[NAME] | Figueirense | 0.7179999999999999
Vitoria | [NAME] | 0.7879999999999998
Avai | Nautico | 0.692
Cruzeiro | Botafogo SP | 0.2669999999999999
CS Alagoano | Guarani SP | -0.365
[NAME] | America Mineiro | -0.5469999999999999
Oeste | Chapecoense | 0.057 | [NAME]
Botafogo SP | Confianca | -0.03500000000000003
Brazil de Pelotas | [NAME] | -0.9469999999999998
[NAME] | [NAME] | -0.09400000000000008
Guarani SP | Cruzeiro | -1.038
Parana | Avai | -0.04400000000000004
Nautico | [NAME] | 0.264
Figueirense | Vitoria | -0.008000000000000007
America Mineiro | Cuiaba | -0.4739999999999999
CRB | Oeste | 1.022 | [NAME]
America Mineiro | [NAME] | 0.607
[NAME] | Vitoria | -0.08199999999999985
Parana | [NAME] | 1.707
Botafogo SP | Guarani SP | 0.55
Brazil de Pelotas | Oeste | -0.76 | [NAME]
Nautico | CRB | -0.542
Chapecoense | [NAME] | 1.883
Figueirense | Cruzeiro | 0.7189999999999999
[NAME] | America Mineiro | -1.169
[NAME] | CS Alagoano | 1.061
Avai | Botafogo SP | -2.03
Oeste | [NAME] | -0.8420000000000001 | [NAME]
Guarani SP | Parana | -0.4320000000000001
CRB | Brazil de Pelotas | 2.499
Spreadsheet: 877686d1724495421-finding-potential-values-for-x-and-y-linear-equation
Sheet: Sheet2

 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | A | B | A | B | A | B | A | B | A | B | A | B |  | A B | 0
15 | A | + | 25 | B | = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
 | A | + |  | B | =
Spreadsheet: 47994d1247167248-count-per-unique-dates-and-names-book9
Sheet: Sheet1

Date: | Name:
2007-01-01 00:00:00 | A
2007-01-01 00:00:00 | B
2007-01-02 00:00:00 | B
2007-01-01 00:00:00 | C
2007-01-01 00:00:00 | D
2007-01-01 00:00:00 | C
2007-01-01 00:00:00 | A
2007-01-02 00:00:00 | A
2007-01-03 00:00:00 | A
ok | ok
3 | 4
unique dates | unique names
I tried to return unique names as per unique dates without success
A should return: | 3
B should return: | 2
C should return: | 1
A | 1.833333333333333 | wrong
B | 0.6666666666666666 | wrong
C | 0.3333333333333333 | wrong
Spreadsheet: 686059d1594333520-sum-range-based-on-column-and-row-criteria-test-test-test
Sheet: Referencing

London Employees |  | Employee Role |  | Roles | Rates | Rates -10% | Rates -20% |  | Week Numbers
Person 1 |  | Consultant |  | Administrator |  |  |  |  | 21
Person 2 |  | Director |  | Office Manager |  |  |  |  | 22
Person 3 |  | Senior Consultant |  | Freelance |  |  |  |  | 23
Person 4 |  | Project Consultant |  | Head of Communications |  |  |  |  | 24
Person 5 |  | Project Consultant |  | Consultant |  |  |  |  | 25
Person 6 |  | Director |  | Project Consultant |  |  |  |  | 26
Person 7 |  | Associate |  | Senior Consultant |  |  |  |  | 27
Person 8 |  | Principal Consultant |  | Principal Consultant |  |  |  |  | 28
Person 9 |  | Project Consultant |  | Associate |  |  |  |  | 29
Person 10 |  | Consultant |  | Director |  |  |  |  | 30
Person 11 |  | Director |  | Principal Graphic Designer |  |  |  |  | 31
Person 12 |  | Project Manager |  | [NAME] |  |  |  |  | 32
Person 13 |  | Communications |  | Project Manager |  |  |  |  | 33
Person 14 |  | Project Consultant |  | Communications |  |  |  |  | 34
Person 15 |  | Administrator |  |  |  |  |  |  | 35
Person 16 |  | Associate |  |  |  |  |  |  | 36
Person 17 |  | Administrator |  |  |  |  |  |  | 37
Person 18 |  | Consultant |  |  |  |  |  |  | 38
Person 19 |  | Project Consultant |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  | 43
Spreadsheet: 704749d1605728273-ref-error-sum-offset-and-indirect-functions-to-map-sum-alternating-ranges-of-values-example-revisited-
Sheet: Sheet1

1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** Adjust to range from CHK1 Tto CHK3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Checkpoints |  | Frame Point | Frame Count | Frame Sum | Frame Reference
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0-Start |  | 00:30:00 | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1- Artery vs Vein |  | 00:30:01.020000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2- Venous Puncture |  | 00:30:05.020000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3- [NAME] |  | 00:30:11.750000 |  |  | -
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 15th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 169236d1342736521-merge-3-spreadsheets-into-1-master-worksheet-with-conditions-merge_sample_19jul12
Sheet: FINAL_GOAL

ID | MPO | SURVEY | SAMPN | PERNO | [NAME] | HMCHAIN | CHAIN | MODECOUNT | GEND | AGE | RACE | [NAME] | LIC | EMPLY | STRATA | DAY | RIBUS | WABIK | HHVEH | HHSIZ
HH4000001-PER1-DAY1-PLA1 | 1 | 2 | 4000001 | 1 | 1 | 0 | 3 | 1 | 2 | 30 | 4 | 2 | 1 | 2 | 3 | 7 | 2 | 1 | 2 | 3
HH4000001-PER2-DAY1-PLA1 | 1 | 2 | 4000001 | 2 | 1 | 1 | 6 | 1 | 1 | 36 |  | 2 | 1 | 1 | 3 | 7 | 2 | 1 | 2 | 3
HH4000001-PER3-DAY1-PLA1 | 1 | 2 | 4000001 | 3 | 1 | 1 | 6 | 1 | 1 | 6 |  | 2 |  |  | 3 | 7 | 2 | 1 | 2 | 3
HH4000064-PER1-DAY1-PLA1 | 1 | 1 | 4000064 | 1 | 1 | 0 | 5 | 1 | 1 | 52 | 1 | 2 | 1 | 1 | 4 | 2 | 2 | 2 | 3 | 3
HH4000064-PER2-DAY1-PLA1 | 1 | 1 | 4000064 | 2 | 1 | 1 | 8 | 1 | 2 | 54 |  | 2 | 1 | 1 | 4 | 2 | 2 | 2 | 3 | 3
HH4000064-PER3-DAY1-PLA1 | 1 | 1 | 4000064 | 3 | 1 | 0 | 3 | 2 | 1 | 13 |  | 2 |  |  | 4 | 2 | 2 | 2 | 3 | 3
HH4000066-PER1-DAY1-PLA1 | 1 | 1 | 4000066 | 1 | 1 | 1 | 6 | 1 | 2 | 80 | 1 | 1 | 1 | 2 | 3 | 2 | 2 | 2 | 1 | 1
HH4000136-PER1-DAY1-PLA1 | 1 | 2 | 4000136 | 1 | 1 | 1 | 7 | 1 | 2 | 46 | 1 | 2 | 1 | 1 | 3 | 1 | 2 | 2 | 2 | 2
HH4000136-PER1-DAY2-PLA1 | 1 | 2 | 4000136 | 1 | 2 | 1 | 6 | 1 | 2 | 46 | 1 | 2 | 1 | 1 | 3 | 1 | 2 | 2 | 2 | 2
HH4000154-PER1-DAY1-PLA1 | 1 | 2 | 4000154 | 1 | 1 | 0 | 3 | 1 |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 1
HH4000154-PER1-DAY2-PLA1 | 1 | 2 | 4000154 | 1 | 2 | 0 | 3 | 1 |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 1
 | 1 | 2 | 4000158 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 2 | 2 | 2 | 2
 | 1 | 1 | 4000160 |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 2 | 2 | 2 | 2
 | 1 | 2 | 4000176 |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 2 | 2 | 2
 | 1 | 2 | 4000193 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 2 | 2 | 1 | 1
Spreadsheet: 355808d1414787513-move-a-row-to-a-new-sheet-based-on-a-cells-value-job-requisition-workbook
Sheet: ALTA AL

Welcov Assisted Living at Alta |  |  |  | Director: [NAME]  DOHS: [NAME] |  | EEO: [EMAIL] Phone: [PHONE]
Requisition # | Job Title | Department | [NAME] | Position Open | Offer Accepted | Shift | Reason for Opening | Days Open | Satus
ALTA14003 | [NAME]'s Assistant | Dietary | $9.00-$10.00 | 2014-10-12 00:00:00 | 2014-10-31 00:00:00 | FT DAY | [NAME].
ALTA14002 | PRN | Nursing | $16.00-$23.00 | 2014-10-30 00:00:00 |  | FT DAY | [NAME].
ALTA14001 | PSA | Nursing | 9.5 | 2014-10-30 00:00:00 |  | FT DAY | [NAME].
Spreadsheet: 93895d1293658320-formula-for-sport-rankings-cagrapplerrankings2010
Sheet: 140

Ranking | First Name | Last Name | School | Section | Grade
1 | [NAME] | [NAME] | Oakdale | SJ | 12
2 | [NAME] | Martinez | Lemoore | CS | 10 | reno 1
3 | Blake | [NAME] | Gilroy | CC | 11 | reno 3
4 | Nick | Cano | [NAME] | CC | 12 | 2010 CIF 3
5 | Adam | Hendrickson | Healdsburg | NC | 11 | 2010 CIF 7
6 | [NAME] | Abono | De La Salle | NC | 11 | reno 5
7 | [NAME] | [NAME] | Pitman | SJ | 12 | 2010 CIF 8
8 | Timmy | Box | Bakersfield | CS | 12
9 | [NAME] | [NAME] | Sultana | SS | 12
10 | Nick | [NAME] | Paradise | NS | 12 | zink 1
Spreadsheet: 541374d1507246222-cant-unhide-rows-weekly-scorecard-template-copy
Sheet: Weekly Result Recap

 | Period: |  | Week: |  |  |  | Results
 |  |  | Actual |  | Goal |  | [NAME]
 | GES (customer satisfaction) |  |  |  | 0.73
 | Labor (team productivity)
 | Food (menu & ingredient waste)
period
 | P11 |  | P12 |  | P13
Week
GES
Labor
Food
Spreadsheet: 70801d1271487872-sorting-data-based-on-individual-fields-book1
Sheet: Reports

Total Number of Staff = | 10
Number of Administration Staff = | 0
Number of Allied Health Staff = | 0
Number of Catering Staff = | 0
Number of Executive Staff = | 0
Number of Housekeeping Staff = | 0
Number of ICU Staff = | 0
Number of Maintenance Staff = | 0
Number of Maternity Staff = | 0
Number of Medical Staff = | 0
Number of Operating Theatre Staff = | 0
Number of Rehab Staff = | 0
Number of Surgical Staff = | 0
Number of Wards General Staff= | 0
Administration Complete = | 0
Allied Health Staff Complete =
Catering Staff Complete=
Executive Staff [NAME] =
Housekeeping Staff Complete =
ICU Staff [NAME] =
[NAME] =
Maternity Staff Complete =
Medical Staff Complete =
Operating Theatre Staff Complete =
Rehab Staff Complete =
Surgical Staff Complete =
Wards General Staff Complete =
Spreadsheet: 03c19c51-6151-4153-9e3a-6a89408e3483
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Category
of Revenue | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
Watercraft Rental | 25281 | 31564 | 32049 | 17187 | 20596 | 30959 | 22340.2 | 20441.6 | 16534.8 | 16605.4 | 19778.8 | 18415.4 | 18562.6
Cruise Boat, Boat Rentals | 10490 | 12157 | 13720 | 10158 | 14722 | 14939 | 12840 | 15930.37 | 16560.4 | 14814.4 | 17142 | 17650.2 | 19314.9
Food and Beverage | 0 | 0 | 0 | 0 | 0 | 0 | 4471.81 | 3726.45 | 3222.75 | 3528.68 | 4106.76 | 3956.86 | 2688.48
All Other Receipts | 3597.58 | 5025.54 | 6080.73 | 4221.470000000001 | 4517.95 | 5835.070000000001 | 350 | 275 | 369 | 194 | 188 | 374 | 230
Total | 39368.58 | 48746.54 | 51849.73 | 31566.47 | 39835.95 | 51733.07 | 40002.00999999999 | 40373.42 | 36686.95 | 35142.48 | 41215.56 | 40396.45999999999 | 40795.98
Commissions Paid | 3936.85 | 4874.67 | 5184.98 | 3156.66 | 3983.59 | 5173.31 | 4000.2 | 4037.35 | 3668.690000000001 | 3514.25 | 4121.56 | 4039.65 | 4079.6
Food and [NAME] not a category from 2000-2005