tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788969d1658827878-collate-data-from-other-sheets-by-list-selection-example
Sheet: Store 1

 |  |  |  | Back To Main Page
 |  |  | Hours |  | Contract |  | Out's
 |  | Week | Actual | Target | Actual | Target | Training | Other | Total
 |  | Week 49 | 110 | 120 | 130 | 140 | 10 | 5
 |  | Week 50 | 120 | 130 | 140 | 150 | 15 | 10
 |  | Week 51 | 130 | 140 | 150 | 160 | 20 | 15
 |  | Week 52 | 140 | 150 | 160 | 170 | 25 | 20
 |  | Week 1 | 150 | 160 | 170 | 180 | 30 | 25
 |  | Week 2 | 160 | 170 | 180 | 190 | 35 | 30
 |  | Week 3 | 170 | 180 | 190 | 200 | 40 | 35
 |  | Week 4 | 180 | 190 | 200 | 210 | 45 | 40
 |  | Week 5 | 190 | 200 | 210 | 220 | 50 | 45
 |  | Week 6 | 200 | 210 | 220 | 230 | 55 | 50
 |  | Week 7 | 210 | 220 | 230 | 240 | 60 | 55
 |  | Week 8 | 220 | 230 | 240 | 250 | 65 | 60
 |  | Week 9 | 230 | 240 | 250 | 260 | 70 | 65
 |  | Week 10 | 240 | 250 | 260 | 270 | 75 | 70
 |  | Week 11 | 250 | 260 | 270 | 280 | 80 | 75
 |  | Week 12 | 260 | 270 | 280 | 290 | 85 | 80
 |  | Week 13 | 270 | 280 | 290 | 300 | 90 | 85
 |  | Week 14 | 280 | 290 | 300 | 310 | 95 | 90
 |  | Week 15 | 290 | 300 | 310 | 320 | 100 | 95
 |  | Week 16 | 300 | 310 | 320 | 330 | 105 | 100
 |  | Week 17 | 310 | 320 | 330 | 340 | 110 | 105
 |  | Week 18 | 320 | 330 | 340 | 350 | 115 | 110
 |  | Week 19 | 330 | 340 | 350 | 360 | 120 | 115
 |  | Week 20 | 340 | 350 | 360 | 370 | 125 | 120
 |  | Week 21 | 350 | 360 | 370 | 380 | 130 | 125
 |  | Week 22 | 360 | 370 | 380 | 390 | 135 | 130
 |  | Week 23 | 370 | 380 | 390 | 400 | 140 | 135
 |  | Week 24 | 380 | 390 | 400 | 410 | 145 | 140
 |  | Week 25 | 390 | 400 | 410 | 420 | 150 | 145
 |  | Week 26 | 400 | 410 | 420 | 430 | 155 | 150
 |  | Week 27 | 410 | 420 | 430 | 440 | 160 | 155
 |  | Week 28 | 420 | 430 | 440 | 450 | 165 | 160
 |  | Week 29 | 430 | 440 | 450 | 460 | 170 | 165
 |  | Week 30 | 440 | 450 | 460 | 470 | 175 | 170
 |  | Week 31 | 450 | 460 | 470 | 480 | 180 | 175
 |  | Week 32 | 460 | 470 | 480 | 490 | 185 | 180
 |  | Week 33 | 470 | 480 | 490 | 500 | 190 | 185
 |  | Week 34 | 480 | 490 | 500 | 510 | 195 | 190
 |  | Week 35 | 490 | 500 | 510 | 520 | 200 | 195
 |  | Week 36 | 500 | 510 | 520 | 530 | 205 | 200
 |  | Week 37 | 510 | 520 | 530 | 540 | 210 | 205
 |  | Week 38 | 520 | 530 | 540 | 550 | 215 | 210
 |  | Week 39 | 530 | 540 | 550 | 560 | 220 | 215
 |  | Week 40 | 540 | 550 | 560 | 570 | 225 | 220
 |  | Week 41 | 550 | 560 | 570 | 580 | 230 | 225
 |  | Week 42 | 560 | 570 | 580 | 590 | 235 | 230
 |  | Week 43 | 570 | 580 | 590 | 600 | 240 | 235
 |  | Week 44 | 580 | 590 | 600 | 610 | 245 | 240
 |  | Week 45 | 590 | 600 | 610 | 620 | 250 | 245
 |  | Week 46 | 600 | 610 | 620 | 630 | 255 | 250
 |  | Week 47 | 610 | 620 | 630 | 640 | 260 | 255
 |  | Week 48 | 620 | 630 | 640 | 650 | 265 | 260
Spreadsheet: 27377d1220545793-transpose-and-compile-data-for-unique-identifiers-pd-attendance-example
Sheet: After

 |  |  |  | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink | LearningThink
 |  |  |  | New Alg. 1 | Returning Teachers | New Alg. 1 | New Alg. 1 | New Alg. 1 | New Alg. 1 | Alg. 2 | Geometry | Alg. 2 | Alg. 2 | Geometry | Alg. 2 | Geometry | Alg. 2 | Geometry
 |  |  |  | 2008-08-11 00:00:00 | 2008-08-12 00:00:00 | 2008-08-12 00:00:00 | 2008-08-13 00:00:00 | 2008-08-14 00:00:00 | 2008-08-15 00:00:00 | 2008-08-18 00:00:00 | 2008-08-18 00:00:00 | 2008-08-18 00:00:00 | 2008-08-19 00:00:00 | 2008-08-19 00:00:00 | 2008-08-20 00:00:00 | 2008-08-20 00:00:00 | 2008-08-21 00:00:00 | 2008-08-21 00:00:00 | Total
Muir | Simms | [NAME] | 131563 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 6 | 0 | 6 | 0 | 6 | 0 | 30
Lombardi | Wilson | Carrie | 117098 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 0 | 6 | 0 | 6 | 36
Watson | [NAME] | [NAME] | 69204 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12
[NAME] | Broderick | [NAME] | 78093 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 12
Washington | [NAME] | Julie | 19455 | 6 | 0 | 6 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30
Frederickson | Jones | [NAME] | 203626 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12
Frederickson | Jones | [NAME] | 203626
Spreadsheet: 217036d1361973053-percentage-change-between-a-range-of-numbers-please-help-projecting-profits-test_etaf
Sheet: INSTRUCTIONS

 |  | Instructions - Risk Model and Projected Equity Curve
 |  | 1. Put the starting balance in A2 on the "Outcome" sheet for each account.
 |  | 2. Put the winning % for the system in the blue cell, [NAME] (may use historical or current estimate of the winning percentage).
 |  | Note that the actual winning % is listed in C1003, it will likely be a little different from the anticipated winning percentage, as this is based on a 'monte carlo' sample of trades.
 |  | 3. In G1, put the percentage of the account that will be risked per trade. For this spreadsheet this is assumed constant for all trades.
 |  | 4. In I1, put the profit multiple for the take profit point. [EXAMPLE: Stop Loss is 20 pips away, [NAME] point is 40 pips away, so Profit Multiple = 2]
 |  | 5. The % Scratch cell indicates the % of trades that are losers after the stop loss is set to the break-even point. Obviously a higher number of is
 |  | break even "losses" is desirible.
 |  | 6. You can see how changing the winning percentage, amount risked per trade, profit multiple and % scratch trades changes your equity curve at the bottom.
 |  | 7. You may also get a new sequence of random trades from http://www.random.org/nform.html and paste them into the B column from B2. [For this
 |  | example, there were 1000 integers generated between 1 and 100 in one column.]
 |  |  |  |  | Starting Bal. | Pred Win % | Act Win % | Act % Scratch | TP Multiple | Amount Risked Per Trade | Ending Balance |  |  | [NAME] |  |  | Min Balance |  |  | 100000
 |  |  |  | AUDJPY
 |  |  |  | Outcome 2
 |  |  |  | Outcome 3
 |  |  |  | Outcome 4
 |  |  |  | Outcome 5
 |  |  |  | Outcome 6
 |  |  |  | Outcome 7
 |  |  |  | Outcome 8
 |  |  |  | Outcome 9
 |  |  |  | Outcome 10
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: $ monographs totals

Total Monographs Expenditures by [NAME] FY11 and FY12
[NAME], Library Budget Only (No Endowments):
Acquisition Type | FY11 | FY12 | % change | % of total FY12 expend.
Approval plan
Kingston (Strand) | 103206.32 | 50000
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
Firm orders
Kingston | 209393.57 | 243197
[NAME] (pelf) | 462.78 | 541.01
CCE (ccef) | 10237.42 | 10614.7
Standing orders
Kingston | 20841.37 | 20968.69
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
TOTALS
Total Monograph Endowment & Other Funds Expenditures
Acquisition Type | FY11 | FY12 | % change | % of total FY12 expend.
Approval plan | 0 | 0 | 0
Kingston (Strand) | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
Firm orders
Kingston | 4263.48 | 14381.22
[NAME] (pelf) | 0 | 0 | 0
CCE (ccef) | 0 | 1661.35 | 0
Standing orders
Kingston | 114.39 | 211.24
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
TOTALS
Total Monograph Expenditures (Including Endowments & Other Funds):
University Libraries | FY11 | FY12 | % change | % of total FY12 expend.
Library budget (all branches) | 344141.46 | 325321.4
Endowments | 4377.87 | 16253.81
TOTALS
Spreadsheet: 791408d1660324581-formula-not-pulling-through-data-for-text-with-a-space-eh-template-1-
Sheet: TEMPLATE FOR PRIVATE SCORE SUBM

⚽Updated scores⚽ |  |  |  |  |  |  |  |  |  | ⚽Final updated scores⚽
Arsenal 💣  🆚 Man Utd 👺 |  |  |  |  |  |  |  | put names here | copy formula
⚽12.30pm kick-off⚽ |  |  |  |  |  | 1st UPDATE (1 HR B4 K.O) | FINAL UPDATE (Kick-Off)
〰〰〰〰〰〰〰〰〰 |  |  |  |  |  |  |  |  |  | 〰〰〰〰〰〰〰〰〰
[NAME]: 2-0
👺 Aleem: 2-3. Wildcard applied. Amended original prediction of 1-2. 3 wildcards remaining
[NAME]: N-S. No default score in place
👺 [NAME]: N-S. No default score in place
⚽ Alif: 3-1
👺 Alnoor: 1-2
⚽ Alykhan: 2-1
👺 [NAME] A: 0-1
[NAME]: N-S. No default scores remaining
👺 [NAME]: 3-1
⚽ Arif N: 2-2
[NAME]: 1-1
[NAME]: 3-2. Wildcard applied. Amended original prediction of 1-2. No wildcards remaining
👺 [NAME]: 2-1
⚽ Firdous: 2-2
👺 Hafeez: N-S. No default scores remaining
⚽ Hanif E: 2-2
👺 [NAME]: 1-2
[NAME]: 1-1
[NAME] UK: N-S. No default scores remaining
[NAME]: N-S. No default scores remaining
🥉 Imran: 1-2
⚽ Kabir: 1-1
👺 Karim J: 2-2
[NAME] S: 1-2
👺 [NAME]: 1-2
[NAME]: N-S. No default scores remaining
[NAME]: 1-2
⚽ Mehboob: 1-2
👺 [NAME]: 1-2
⚽ Mohamed: 2-3
[NAME]: 1-2
[NAME]: N-S. No default scores remaining
👺 [NAME]: 2-2
⚽ [NAME]: 2-2
👺 [NAME]: N-S. No default scores remaining
⚽ Rahim V: 2-1
👺 Rahul: N-S. No default scores remaining
🥉 Rayyan: 2-1
[NAME] remaining
⚽ Rizwan: 2-1
👺 [NAME]: 3-4. Wildcard applied. Amended original prediction of 1-1. 3 wildcards remaining
⚽ Salim: 3-4. Wildcard applied. Amended original prediction of 1-3. 2 wildcards remaining
[NAME]: 2-2
[NAME]: N-S. No default scores remaining
👺 Shaffin: 2-3. Wildcard applied. Amended original prediction of 1-2. No wildcards remaining
[NAME]: 1-3
👺 [NAME]: 2-2
⚽ Sonef: N-S. No default score in place
🥉 Tariq: 2-1
 |  | Breakdown
Spreadsheet: 58932d1259214214-pivot-table-source-accross-worksheets-book1
Sheet: Week 2

Week | Filter | Project | Unapproved Days | Name
Week 2 | True | [NAME] | 1 | Mark
Week 2 | True | EM | 3 | [NAME]
Week 2 | True | EA | 2 | [NAME]
Week 2 | True | Rel 3 | 5 | [NAME]
Week 2 | True | Rel 3 | 1 | Ursula
Week 2 | True | Rel 3 | 5 | [NAME]
Week 2 | True | [NAME] | 3 | Greg
Week 2 | True | [NAME] | 4 | [NAME]
Week 2 | True | [NAME] | 2 | [NAME]
Week 2 | True | Rel 3 | 3 | [NAME]
Week 2 | True | Rel 3 | 5 | George
Week 2 | False | [NAME] | 6 | [NAME]
Week 2 | True | [NAME] | 6 | [NAME]
Spreadsheet: eric_saibi__9955__110701R
Sheet: Pine Bluff ST 1

Owner Name |  | Calpine Corporation
Station Name |  | Pine Bluff Energy Center
Unit Name |  | Unit 01 ST
NERC Region |  | SERC
State |  | AR
Fuel Type |  | Natural Gas
Capacity |  | 50 MW
Start Date |  | 2001-11-06 00:00:00
End Date |  | 2001-11-11 00:00:00
Comments |  | Design Issues
SIC |  | 4931
Plant ID |  | 1032399
Unit ID |  | 1012294
Outage ID |  | 18819
Spreadsheet: 168596d1342520378-plot-where-blank-fields-are-ignored-not-displayed-workedexample
Sheet: IO

timestamp | I/O
Spreadsheet: b9c99ca7-4182-466a-9f45-8350c4562889
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
MEX | Test | MEX | Mexiletine, Serum | Mexiletine, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Container/Tube: Red top  [NAME]: 3 mL Collection Instructions: Draw blood after patient has been receiving mexiletine for at least 3 days and just before administration of the next dose. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Plasma, serum gel tube | Therapeutic concentration: 0.8-2.0 mcg/mL (trough value) Toxic concentration: >2.0 mcg/mL (trough value) | Monday, Wednesday, Friday; 9:00 a.m. | Same day/1 day | 3 days | 1 | 80299 |  |  |  |  | Rochester
MEX | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
MEX | Result | 9245 | Mexiletine, S | Mexiletine, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3819-0 | Mexiletine:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 8dd34a49-4d95-4b59-937a-917d5624de20
Sheet: Sheet1

Representative in Congress (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/18/2013 12:37:32 PM
Precincts Reporting: 666/666 - Total Ballots Cast: 237224
2002 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Combined Precinct | 1105 | 1966 | 3071
TOTAL | 1105 | 1966 | 3071
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 90119d1289883712-average-d3-on-each-worksheet-if-a1-is-a-weekday-p002a-arc-monthly-workbook
Sheet: AvgCalcWkd

Month
 |  | [NAME] this month
AT1 Average
AT2 Average
AT3 Average
AT4 Average
AT5 Average
AT6 Average
AT7 Average
AT8 Average
AT10 Average
AT11 Average
[NAME]
SR-1 Average
SR-2 Average
99
Average Weekday Ridership
Spreadsheet: 861580d1709467801-filter-range-only-if-cells-in-a-range-are-not-empty-excelforum
Sheet: Sheet1

Code | RED | GREEN | Low | Moderate | High |  |  |  | Code | RED | GREEN | Low | Moderate | High
CD-1 |  |  |  |  |  |  |  |  | CD-2 | 3 |  |  |  | 1
CD-2 | 3 |  |  |  | 1 |  |  |  | CD-4 |  |  | 3
CD-3 |  |  |  |  |  |  |  |  | CD-7 |  | 4
CD-4 |  |  | 3 |  |  |  |  |  | CD-12 |  |  | 2 |  | 1
CD-5
CD-6 |  |  |  |  |  |  |  |  |  | RED | GREEN | Low | Moderate | High
CD-7 |  | 4 | 1 |  | 2 |  |  |  | CD-2 | 3 | 0 | 0 | 0 | 1
CD-8 |  |  |  |  |  |  |  |  | CD-4 | 0 | 0 | 3 | 0 | 0
CD-9 |  |  |  |  |  |  |  |  | CD-7 | 0 | 4 | 1 | 0 | 2
CD-10 |  |  |  |  |  |  |  |  | CD-12 | 0 | 0 | 2 | 0 | 1
CD-11
CD-12 |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | RED | GREEN | Low | Moderate | High
 |  |  |  |  |  |  |  |  | CD-2 | 3 |  |  |  | 1
 |  |  |  |  |  |  |  |  | CD-4 | 0 |  | 3
 |  |  |  |  |  |  |  |  | CD-7 | 0 | 4 | 1 |  | 2
 |  |  |  |  |  |  |  |  | CD-12 | 0 |  | 2 |  | 1
Spreadsheet: 730608d1619790257-sum-total-by-year-user-test-book
Sheet: Sheet1

Unit | Date | Cost |  |  | 2018 | 2019 | 2020 | 2021
30004226 | 2018-02-28 00:00:00 | 21779.4 |  |  | 0 | 0 | 0 | 0
30004226 | 2018-02-28 00:00:00 | 21779.4
30007150 | 2018-01-08 00:00:00 | 21056.96
30004286 | 2019-07-26 00:00:00 | 4930.07
30007192 | 2019-11-08 00:00:00 | 4823.6
30007192 | 2019-11-08 00:00:00 | 4823.6
30007192 | 2020-09-03 00:00:00 | 4744
30007192 | 2020-09-03 00:00:00 | 4744
30007192 | 2020-09-03 00:00:00 | 4744
30004286 | 2019-07-26 00:00:00 | 4705.98
30004261 | 2020-02-28 00:00:00 | 4556.34
30004261 | 2020-02-28 00:00:00 | 4556.34
30007150 | 2019-11-05 00:00:00 | 4402.84
30007191 | 2020-07-22 00:00:00 | 4366.77
30004136 | 2018-10-19 00:00:00 | 4360.08
30004266 | 2020-10-02 00:00:00 | 4154.92
30007194 | 2018-07-16 00:00:00 | 4137
30007194 | 2018-07-16 00:00:00 | 4137
30007194 | 2018-07-16 00:00:00 | 4137
30007194 | 2018-07-16 00:00:00 | 4137
30007196 | 2018-08-22 00:00:00 | 4080
30007196 | 2018-08-22 00:00:00 | 4080
30007195 | 2018-06-13 00:00:00 | 3884.4
30007196 | 2018-08-22 00:00:00 | 3876
30004136 | 2020-11-09 00:00:00 | 3855.5
30007150 | 2018-12-20 00:00:00 | 3826.79
30007178 | 2018-01-29 00:00:00 | 3659.63
30007192 | 2018-11-20 00:00:00 | 3596.4
30007192 | 2018-11-20 00:00:00 | 3596.4
30004266 | 2018-04-13 00:00:00 | 3595.93
30004264 | 2019-09-19 00:00:00 | 3551.48
30007193 | 2018-04-17 00:00:00 | 3222.56
30004264 | 2020-07-31 00:00:00 | 3221.76
30004265 | 2019-03-07 00:00:00 | 3181.08
30007194 | 2020-09-16 00:00:00 | 3089.82
30007106 | 2020-11-16 00:00:00 | 2960.72
30007106 | 2020-11-16 00:00:00 | 2960.72
30007196 | 2019-11-05 00:00:00 | 2955.96
30007196 | 2019-11-05 00:00:00 | 2955.96
30007196 | 2018-06-11 00:00:00 | 2942.62
30007196 | 2019-03-27 00:00:00 | 2931.12
30007196 | 2019-03-27 00:00:00 | 2931.12
30007195 | 2018-09-18 00:00:00 | 2900.12
30007195 | 2020-03-20 00:00:00 | 2895.5
30007195 | 2020-03-20 00:00:00 | 2895.5
30007195 | 2020-03-20 00:00:00 | 2893.75
30004275 | 2020-03-02 00:00:00 | 2835
30004261 | 2018-09-21 00:00:00 | 2759.71
Spreadsheet: 76588d1277142961-match-index-from-data-sheet-to-individual-sheet-subj-reimb-credit-calculation-question
Sheet: Subj Reimbursement EX

Subject # | # of Days |  | 1 | Corresponds to Col A47 Study Site Data Sheet Subject Reimbursement Section
0 | 0
Site: Example |  |  |  |  | There will be a number of sheets like this where D1 corresponds with
COMS #: 2###### |  |  |  |  | A47 - A72.
CVD Study #: 82#####
Sponsor: Example
Protocol: ###xyz
Line Item | Rate | Units | SubTotals
Unit Days | 999 |  | 0 |  | I want to place in the "Units" the corresponding number from the
Unit Day (by Exception)* | 999 |  | 0 |  | Study Site Data Sheet using I think match index formula
OPVs | 999 |  | 0
Extended OPVs | 999 |  | 0
Wash out < 5 Days | 99 |  | 0
Wash out > 5 Days but < 10 Days | 999 |  | 0
Wash out > 10 Days but < 15 Days | 999 |  | 0
Continued participation through follow-up calculated as [NAME] out above | 9 |  | 0
Diaries (per week)** | 99 |  | 0
Telephone Contacts | 99 |  | 0
 |  |  | 0 | Total
0
0
Spreadsheet: 863476d1710947801-if-statement-or-alternative-grading-etaf2
Sheet: Sheet1

Grading | Business Critical | Critical | Major | Minor | Observation |  | Excellent | There are no Non-Compliance issues and no Observations on this audit. | If each column if blank = Blank
Excellent | 0 | 0 | 0 | 0 | 0 |  | Good | There are no Minor Non-Compliances on this audit. (There is at least one Observation.) | If the score in each column is zero the cell populates "Excellent"
Good | 0 | 0 | 0 | 0 | 1 |  | Fair | There are no Major Non-Compliances on this audit. (There is at least one Minor Non-Compliance.) | Business Critical Column (B9) is 1 or more than 1 the cell in All populates "Fail"
Fair | 0 | 0 | 0 | 1 |  |  | Needs Improvement | There are three or fewer (i.e. between 1 and 3) Major Non-Compliances on this audit. | Critical Column (C9) is 1-3 = "Unsatisfactory"
Needs Improvement |  | 0 | 3 |  |  |  | Unsatisfactory | There are four or more Major Non-Compliances on this audit. | Critical Column (C9) is 4 or more than 4 = "Fail"
Unsatisfactory |  | 3 | 4 |  |  |  |  | There are three or fewer (i.e. between 1 and 3) Critical Non-Compliances on this audit. | Major [NAME] (D9) is 1-3 = "Needs Improvement"
Fail | 1 | 4 |  |  |  |  | Fail | There are four or more Critical Non-Compliances on this audit. | Major [NAME] (D9) is 4 or more than 4 = "Unsatisfactory"
 |  |  |  |  |  |  |  | There are one or more Business Critical Non-Compliances on this audit. | Minor Column (E9) is 1 or more than 1 = "Fair"
Factory Result | 0 | 0 | 0 | 0 | 0 |  |  |  | Observation Column (F9) is 1 or more than 1 = "Good"
 |  |  |  |  |  |  |  |  | fail | OR( B9>=1 , c9>=4, E9>=1 )
 |  |  |  |  |  |  |  |  | Unsatisfactory | OR(AND(C9>=1,C9<=3),D9>=4)
 |  |  |  |  |  |  |  |  | Needs Improvement | AND(D9>=1,D9<=3)
 |  |  |  |  |  |  |  |  | Fair | E9>1
 |  |  |  |  |  |  |  |  | good | F9>=1
 |  |  |  |  |  |  |  |  | Excellent | Sum(B9:F9)=0
 |  |  |  |  |  |  |  |  | BLANK | AND(B9="",C9="",D9="",E9="",F9="")
Spreadsheet: 133091d1324163760-simplify-an-if-function-wo-test
Sheet: OCT11

 |  | 2011-10-01 00:00:00 | 2011-10-02 00:00:00 | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 2011-10-07 00:00:00 | 2011-10-08 00:00:00 | 2011-10-09 00:00:00 | 2011-10-10 00:00:00 | 2011-10-11 00:00:00 | 2011-10-12 00:00:00 | 2011-10-13 00:00:00 | 2011-10-14 00:00:00 | 2011-10-15 00:00:00 | 2011-10-16 00:00:00 | 2011-10-17 00:00:00 | 2011-10-18 00:00:00 | 2011-10-19 00:00:00 | 2011-10-20 00:00:00 | 2011-10-21 00:00:00 | 2011-10-22 00:00:00 | 2011-10-23 00:00:00 | 2011-10-24 00:00:00 | 2011-10-25 00:00:00 | 2011-10-26 00:00:00 | 2011-10-27 00:00:00 | 2011-10-28 00:00:00 | 2011-10-29 00:00:00 | 2011-10-30 00:00:00 | 2011-10-31 00:00:00
 |  | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA
 | EMP # | 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
BILLY | 480 |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | V | V | V | D | D | D | D |  |  |  |  |  |  | WN | D | D
JACK | 485 |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N | N | N | N | WN | WN | WN | WN |  |  |  | N | N
[NAME] | 500 | D |  |  |  |  |  |  |  | D | D | D | D | D | D | D |  |  |  |  |  | WD |  | V | V | V | V | N | N | N
FRED | 505 | N |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  | WN |  | V | V | V | V | V | V | V
 |  | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA
 |  | 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
[NAME] | 510 |  | N | N | N | N | N | N | N |  |  |  |  |  | WD |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | N | N
CARL | 515 |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | D | D
DON | 520 | N |  |  |  |  |  |  |  | D | D | D | D | D | D | D |  |  |  |  | WN |  |  | N | N | N | N | N | N | N
FRANK | 525 | D |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | D | D | D | D | D | D | D
Spreadsheet: 150807d1334685081-auto-hide-a-column-departmentalbudgetvsactual
Sheet: BudVsAct 

B U D G E T    VS.    A C T U A L    D E P A R T M E N T A L    R E P O R T
DEPARTMENT: |  | 100 |  | Summary
PERIOD: |  | 4 |  | Actual:
YEAR: |  | 2012 |  | Budget
 | Account | Description | Actual | Actual | Budget | Budget | Variance (Favorable) | [NAME] | % of Budget | Total Balance
 | 40800
 | 43210
 | 43212
 | 43214
 | 43216
 | 43218
 | 50000
 | 50050
 | 50100
 | 50200
 | 50300
 | 50400
 | 50500
 | 50600
 | 50700
 | 50710
 | 50720
 | 50800
 | 50900
 | 50910
 | 51000
 | 51200
 | 51200
 | 51300
 | 51400
 | 51450
 | 51460
 | 51470
 | 51500
 | 51550
 | 51600
 | 51700
 | 51810
 | 51820
 | 51830
 | 51860
 | 51870
 | 51880
 | 51900
 | 52000
 | 52100
 | 52220
 | 52300
 | 52400
 | 52500
 | 53000
 | 53100
 | 53150
 | 53200
 | 53300
 | 53400
 | 54000
 | 54010
 | 54100
 | 54200
 | 54300
 | 54400
 | 54600
 | 54700
 | 54800
 | 54900
 | 55000
 | 55100
 | 57000
 | 57100
 | 58000
 | 58050
 | 58100
 | 58150
 | 58200
 | 58300
 | 58400
 | 58500
 | 58600
 | 58700
 | 58800
 | 59000
 | 59020
 | 55200
 |  | TOTAL OPERATING EXPENSE