tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865952d1712902166-power-query-move-every-second-row-book1-1-
Sheet: Sheet1

Emp ID | Level | Employee Name | Attendance/Score |  |  |  | Emp ID | Level | Employee Name | Attendance | Score
1 | OO1 | A | 0.3 |  |  |  | 1 | OO1 | A | 0.3 | 0
1 | OO1 | A | 0 |  |  |  | 2 | PP1 | B | 0.6 | 1
2 | PP1 | B | 0.6 |  |  |  | 3 | CC3 | C | 0.8 | 1
2 | PP1 | B | 1 |  |  |  | 4 | OI11 | D | 0.1 | 0
3 | CC3 | C | 0.8
3 | CC3 | C | 1
4 | OI11 | D | 0.1
4 | OI11 | D | 0
RAW
Spreadsheet: 600730d1543933299-indirect-need-cell-range-to-change-to-the-indirect-method-indirect
Sheet: Age

Current Method |  |  |  | Desired Method |  |  |  |  |  |  |  |  |  | RowStart | RowEnd | Start Date | End Date
Age - From | Age - To | Count |  | Age - From | Age - To | Count |  |  |  |  |  |  |  | A2 | A11 | 2017-01-01 00:00:00 | 2018-03-31 00:00:00
18 | 25 |  |  | 18 | 25 |  |  |  |  |  |  |  |  | 2 | 11
26 | 35 |  |  | 26 | 35
36 | 45 |  |  | 36 | 45
46 | 55 |  |  | 46 | 55
56 | 70 |  |  | 56 | 70
Unknown |  |  |  | Unknown
Total: |  |  |  | Total:
Spreadsheet: ed21d094-4d53-4419-b930-3fd8a264b64b
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
RYEG | Test | RYEG | Rye Grass, IgE | Rye Grass, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RYEG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RYEG | Result | RYEG | Rye Grass, IgE | Rye Grass, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7369-2
Spreadsheet: 766195d1643795427-find-words-with-letter-interchange-copy-of-vowel-exchange-1
Sheet: Sheet1

 |  |  |  |  |  |  |  | check with next row |  |  |  |  |  |  |  |  |  | Result | if 2 , swap |  |  | check with above row |  |  |  |  |  |  |  |  |  | Result
NOTAIRE |  | s | 1 | AEINORT
OTARINE |  |  | 2 | AEINORT
ETAERIO |  | s | 3 | AEEIORT
ANEROID |  | s | 4 | ADEINOR
AILERON | t | s | 5 | AEILNOR
ALERION |  | s | 6 | AEILNOR
ALIENOR |  | s | 7 | AEILNOR
ELATION | dgr | s | 8 | AEILNOT
DODMANS |  | s | 9 | AEILNOT
ODDSMAN |  | s | 10 | AEINORS
ATONIES |  |  | 11 | AEINOST
OARIEST | hr |  | 12 | AEIORST
OTARIES | [NAME] |  | 13 | AEIORST
ROASTIE |  | s | 14 | AEIORST | NEW IN CSW15
SKREIGH |  | s | 21463 | EGHIKRS
SKRIEGH |  | s | 21464 | EGHIKRS
Spreadsheet: 732695d1621172720-getting-cell-address-for-formula-from-list-example
Sheet: example

1 |  |  | JANUARI | TOTAL
 | 1
 | 2 |  | Insurance | 21
 | 3 |  | Rent | 32 |  |  | Tools cost
 | 4
 | 5 |  | Clothing | 54
 | 6
 | 7 |  |  |  |  |  | ROW | details | cost
 | 8 |  | Phone | 18 |  |  | 13
 | 9 |  |  |  |  |  | 17
 | 10
 | 11
 | 12 |  | Tools | 54
 | 13
 | 14
 | 15
 | 16 |  | Other tools | 48
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31 |  |  |  |  |  |  | SUM
 |  |  | MND.TOTAL
 |  |  | CUMM.TOTAL
Spreadsheet: 803949d1667819735-formula-for-9-box-grid-9-box-grid
Sheet: Sheet1

EMPLOYEE ID | NAME | DEPARTMENT | POSITION | YEARS OF EXPERIENCE | JOB LEVEL | AGE | PERFORMANCE | POTENTIAL | 9 BOX CATEGORIZATION |  | Potential
1 |  |  |  |  |  |  | 3 | 1 | [NAME] |  |  | 3
2 |  |  |  |  |  |  | 3 | 3 | Star |  |  | 2
3 |  |  |  |  |  |  | 1 | 3 | Potential Gem |  |  | 1
4 |  |  |  |  |  |  | 1 | 2 | Inconsistent player |  |  |  | 1 | 2 | 3
5 |  |  |  |  |  |  | 3 | 2 | High performance |  | Perfromacne
6 |  |  |  |  |  |  | 2 | 2 | Core Player
7 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
8 |  |  |  |  |  |  | 2 | 3 | High potential
9 |  |  |  |  |  |  | 3 | 1 | [NAME]
10 |  |  |  |  |  |  | 2 | 1 | Average performer
11 |  |  |  |  |  |  | 2 | 2 | Core Player
12 |  |  |  |  |  |  | 2 | 3 | High potential
13 |  |  |  |  |  |  | 3 | 1 | [NAME]
14 |  |  |  |  |  |  | 2 | 1 | Average performer
15 |  |  |  |  |  |  | 1 | 3 | Potential Gem
16 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
17 |  |  |  |  |  |  | 2 | 3 | High potential
18 |  |  |  |  |  |  | 1 | 1 | Risk
19 |  |  |  |  |  |  | 2 | 1 | Average performer
20 |  |  |  |  |  |  | 1 | 3 | Potential Gem
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -3406 |  |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
2 | -1974 |  |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
3 | -1939 | -1900 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
4 | -1840 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
5 | -1968 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
6 | -1992 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
7 | -1997 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
8 | -2162 | -2104 | -3 | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
9 | -2166 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
10 | -2130 | -2104 | -7 | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
11 | -2131 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
12 | -2157 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
13 | -2181 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
14 | -2112 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
15 | -2111 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
16 | -2215 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
17 | -2164 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
18 | -2162 | -2104 | -18 | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
19 | -2159 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
20 | -2140 | -2104 |  | -1 |  | -1 |  | -2 |  |  |  |  |  | 0
21 | -2115 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
22 | -2176 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
23 | -2183 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
24 | -2174 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
25 | -2182 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
26 | -2148 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
27 | -2182 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
28 | -2168 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
29 | -2240 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
30 | -2267 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
31 | -2229 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
index
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102894.9
2001-12-31 00:00:00
CBS Volume
 |  |  | 43028
Spreadsheet: 2e9a35c1-16bd-428e-b47c-ba79210d850a
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
BGRS | Test | BGRS | Barley Grass, IgE | Barley Grass, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BGRS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BGRS | Result | BGRS | Barley Grass, IgE | Barley Grass, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6037-6
Spreadsheet: 6873e6a7-95fa-437c-93e5-6c937a0b8f24
Sheet: Sheet1

 | Cola  per ounce | Diet Cola per ounce | Lemon Lime | Other flavors | Co2 (20lb)
Coca Cola | 0.009 | 0.009 | 0.009 | 0.009 | 6
DPS | 0.0104 | 0.0104 | 0.0104 | 0.0104 | 7
Pepsi | 0.0104 | 0.0104 | 0.0104 | 0.0104 | 4 and 8
Spreadsheet: 689399d1596377377-use-data-in-one-array-in-formulas-for-another-sample-cash-flow
Sheet: Assumptions

 | ASSUMPTION REPORT
 | Acquisition |  |  |  | Equity Assumptions |  |  |  |  | Revenues/Expenses - Hotel
 | Units | 93 |  |  | Class A Equity | 0.9 |  |  |  | F&B Revenue | 0.03
 | Purchase Price | 7600000 |  |  | Class A Sponsor Equity | 0.1 |  |  |  | Ancillary Revenue | 0.0335
 | Acquisition Fee | 0.025 |  |  | Class B Equity |  |  | 10 |  | Other Revenue | 7000
 | Closing Costs | 0.03 |  |  | [NAME] | 0.08 | 1 |  |  | Room [NAME] | 0.271
 | P&I Reserve (Months) | 12 |  |  | Tier 1 | 0.12 | 0.9 |  |  | F&B OpEx | 0.53
 | PIP | 480000 |  |  | [NAME] | 0.15 | 0.7 |  |  | Ancillary [NAME] | 0.42
 | PIP Contingency | 0 |  |  | Tier 3 | 15+% | 0.65 |  |  | Undistributed [NAME] | 0.425
 | PIP Developer Fee | 0 |  |  |  |  |  |  |  | Property Management Fee | 0.03
 | Loan Origination Fee | 0.01 |  |  | Uses - Consolidated |  |  |  |  | Annual Reserve | 0.03
 | Financing Fee | 0.01 |  |  | Unlevered Development Costs
 | PIP Credit | 1 |  |  | Financing/Closing Costs |  |  |  |  | Year | ADR | Occupancy | Room Revenue | Room [NAME] | F&B Revenue | F&B OpEx | Ancillary Revenue | Ancillary [NAME] | Rental Revenue
 | Total Acquisition Cost |  |  |  | PrimeCore Fund Costs |  |  |  |  | 2021 | 110 | 0.638465 |  | 0.287 | 79000 | 0.544 | 89000 | 0.404 | 6000
 |  |  |  |  | Total |  |  |  |  | 2022 | 120 | 0.68 |  | 0.277 | 87000 | 0.54 | 98000 | 0.418 | 6000
 | Mortgage Loan |  |  |  |  |  |  |  |  | 2023 | 126 | 0.72 |  | 0.277 | 95000 | 0.526 | 107000 | 0.439 | 7000
 | Debt Ratio1 | 0.7 |  |  | Sponsor Fees |  |  |  |  | 2024 | 133 | 0.73 |  | 0.272 | 99000 | 0.525 | 112000 | 0.438 | 7000
 | Interest Rate |  | 0.0385 |  | Asset Management Fee | 0.01 |  | Operating |  | 2025 | 137 | 0.73 |  | 0.271 | 102000 | 0.529 | 115000 | 0.443 | 7000
 | Amortization Period (Years) |  |  |  | Guarantee Fee | 0.005 |  | Operating |  | 2026 | 141 | 0.73 |  | 0.272 | 105000 | 0.533 | 118000 | 0.441 | 7000
 | Loan Start Date |  | 2020-12-01 00:00:00 |  | Developer Fee |  |  | One Time |  | 2027 |  | 0.73
 |  |  |  |  | Acquisition Fee |  |  | One TIme |  | 2028 |  | 0.73
 | Refinancing |  |  |  |  |  |  |  |  | 2029 |  | 0.73
 | Refinance Period |  | 60 |  | Terminal Value |  |  |  |  | 2030 |  | 0.73
 | Refinance Cap Rate |  | 0.07 |  | Revenue |  |  |  |  | 2031 |  | 0.73
 | LTV |  | 0.7 |  | Operating Expenses
 | Third Party Finance Fee |  | 0.005 |  | Total
 | Mortgage Interest |  | 0.0385 |  | Terminal [NAME]
 | Amortization Period (Years) |  |  |  | Terminal Value
 | Mortgage Repayment |  | 2031-01-01 00:00:00 |  | Sales Commission |  |  | 0.04
 |  |  |  |  | Exit Fee |  |  | 0.015
 | Disposition |  |  |  | Terminal Value
 | Length of Investment |  | 10 Years
 | Month of Sale |  | 2031-01-01 00:00:00 |  | Return Summary
 | [NAME] |  | 0.07 |  | Purchase [NAME]
 |  |  |  |  | Class A IRR
1 |  |  |  |  | Equity Multiple
 |  | of Total Acquisition Cost |  |  | Cash-on-Cash
 | 1
Spreadsheet: 702565d1604415158-sorting-lists-of-numbers-in-pairs-and-in-ascending-order-ascending-timing
Sheet: Sheet1

 |  |  |  | Single column Start-End time | Time after removing duplicates | Difference in time
 |  |  |  | 0
 |  |  |  | 180
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 120
 |  |  |  | 30
 |  |  |  | 120
 |  |  |  | 30
 |  |  |  | 60
 |  |  |  | 179
 |  |  |  | 180
 |  |  |  | 180
 |  |  |  | 181
Spreadsheet: 126610d1319774043-automatically-copy-across-columns-coloursanswer
Sheet: Sheet1

Red | Red
 | Red
 | Red
 | Red
 | Red
 | Red
 | Red
 | Red
Blue | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
 | Blue
Yellow | Yellow
 | Yellow
 | Yellow
 | Yellow
 | Yellow
 | Yellow
 | Yellow
 | Yellow
 | Yellow
Green | Green
 | Green
 | Green
 | Green
 | Green
 | Green
 | Green
Spreadsheet: andy_zipper__118__Broker detail 6-4-01
Sheet: FAILED DEALS SUMMARY

Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no bid access to product | 1 | 10 | 11
 | [NAME]: counterparty has no offer access to product |  | 4 | 4
 | FAILURE: Limit price violated |  | 13 | 13
 | [NAME]: product violates counterparty term limit | 3 |  | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 6 |  | 6
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 26 | 4 | 30
APB Energy, Inc. Total |  | 38 | 31 | 69
Natsource LLC | FAILURE: counterparty exceeded credit limit | 2 | 5 | 7
 | [NAME]: counterparty has no bid access to product | 1 | 4 | 5
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated | 1 | 13 | 14
 | [NAME]: product violates counterparty term limit |  | 3 | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 9 | 10
 | FAILURE: Base product not active for hedge | 1 |  | 1
Natsource LLC Total |  | 6 | 39 | 45
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 2 |  | 2
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: product violates counterparty term limit | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 3 |  | 3
 | FAILURE: Order pended due to limit price violation | 3 |  | 3
Power Merchants Group, LLC Total |  | 20 |  | 20
Amerex Natural Gas I, Ltd. | FAILURE: Limit price violated | 2 |  | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 4 |  | 4
Amerex Natural Gas I, Ltd. Total |  | 6 |  | 6
Amerex Power, Ltd. | FAILURE: counterparty exceeded credit limit |  | 1 | 1
 | [NAME]: counterparty has no bid access to product |  | 5 | 5
 | FAILURE: Limit price violated |  | 2 | 2
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: counterparty has no access to product |  | 1 | 1
Amerex Power, Ltd. Total |  |  | 11 | 11
Prebon Energy, Inc. | FAILURE: Order pended due to limit price violation | 1 |  | 1
Prebon Energy, Inc. Total |  | 1 |  | 1
Grand Total |  | 71 | 81 | 152
Spreadsheet: mark_taylor__24791__Development Checklist
Sheet: Stack Manager

 |  | Done |  | Responsibility | Resources | Date | Status Notes
[NAME]
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME] | [NAME]
[NAME]
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME]
Configuration Settings Saving |  |  |  | [NAME] |  | 2000-10-05 00:00:00 | Expected Construction Completion week of 8/5/00
Price and Volume Delta Saving |  |  |  | [NAME] |  | 2000-10-05 00:00:00 | Expected Construction Completion week of 8/5/00
Grandparents |  |  |  | [NAME] |  | 2000-10-05 00:00:00 | Expected Construction Completion week of 15/5/00
Advanced Options
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME]
Intermediate Options
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME]
Advanced Sorting
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME]
Grouping of Products
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME]
[NAME]
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME]
Floating "Other Products" Window |  |  |  | [NAME]
Autotrader/autoarbitrager
 | Functional Specification |  |  | [NAME]
 | Functional Construction |  |  | [NAME]
[NAME] and Syncopated Links |  |  |  | [NAME]
Autohedge |  |  |  | [NAME] |  | 2000-10-05 00:00:00 | Done & tested, but needs to be officially rolled out to Traders
Spreadsheet: 490230d1479754185-requesting-some-help-with-regards-to-a-vlookup-formula-sample-sheet
Sheet: Sheet1

Date | Time | Location | Repair | A/B |  |  |  |  |  | 3/20 - 3/22 |  |  | your values
2016-03-17 00:00:00 | 250 | 111 access st | road sign | a |  |  |  | Date Range |  | 2016-03-20 00:00:00 | 2016-03-22 00:00:00
2016-03-17 00:00:00 | 1350 | 3941 adams ave | road sign | a |  |  |  | Number of B's | b |  |  |  | 2
2016-03-19 00:00:00 | 1440 | 218 freedom | road sign | a
2016-03-20 00:00:00 | 1445 | 897 rock well | pavement | a |  |  |  | Number of A's | a |  |  |  | 3
2016-03-21 00:00:00 | 1928 | 2240 steam st | pavement | a
2016-03-22 00:00:00 | 120 | 5992 major st | pavement | b |  |  |  | Time Slots | 0 | 700 |  |  | 2
2016-03-22 00:00:00 | 700 | 4876 arthur st west | road sign | b |  |  |  |  | 701 | 1600 |  |  | 0
2016-03-22 00:00:00 | 1850 | 2401 zebra | pavement | b |  |  |  |  | 1601 | 2400 |  |  | 2
Spreadsheet: 182977d1348673911-how-do-i-return-a-blank-cell-value-if-that-cell-does-not-have-color-formatting-0a1_fot_book1-72-
Sheet: Sheet3

 |  |  |  |  |  |  |  | I have a range of cells that are formula driven as follows:
 |  |  |  |  |  |  |  | =IF($G187=0,"",T176)
 |  |  |  |  |  |  |  | I am trying to return a blank cell if the cell has NO color formatting, and return a value if the cell DOES have color formatting. Is there a way or setting a conditional format? I do not want to 'hide' rows or columns.
 |  |  |  |  |  |  |  | =$[NAME]>>> Color Green.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  | See here |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  | I am highlighting the cell using a different macro,
 |  |  |  |  |  | 15 |  |  |  |  |  |  |  | After I highlight, I want the cells with no highlight (40,70,80)
 |  |  |  |  |  | 1 |  |  |  |  |  |  |  | to have NO text showing.
 |  |  |  |  |  | -5
 |  |  |  |  |  | 10
 |  |  |  |  |  | 1
 |  |  |  |  |  | -10
 |  |  |  |  |  |  |  |  | I have this |  |  |  | I need this - change text color to white when no color is present
Spreadsheet: 157530d1337784073-updating-a-cell-on-multiple-spreadsheets-dummy-file
Sheet: Sheet1

Average Weekly Staffing Ratios
DT&H Individual Client Worksheet
Client Name | [NAME]
Date Form Completed | 05.07.2012-05.11.2012
Completed by | Kris
Approved by | Kathy
 | Staffing Ratio (Enter staffing ratio  as X:Y, where X = number of staff and Y = number of clients)
 | Monday |  |  |  |  | Tuesday |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  |  |  | Friday |  |  |  |  | Saturday |  |  |  |  | Sunday
Hour/Day | # of Staff | # of Clients | Ratio | DIV | Activity | # of Staff | # of Clients | Ratio | DIV | Activity | # of Staff | # of Clients | Ratio | DIV | Activity | # of Staff | # of Clients | Ratio | DIV | Activity | # of Staff | # of Clients | Ratio | DIV | Activity | # of Staff | # of Clients | Ratio | DIV | Activity | # of Staff | # of Clients | Ratio | DIV | Activity
Example | 1 | 10 | 1:10 |  | Exercise
6:00-7:00 AM
7:00-8:00 AM
8:00-9:00 AM
9:00-10:00 AM
10:00-11:00 AM | 1 | 3 | 1:3 | 3 | Work | 1 | 2 | 1:2 | 2 | Work | 1 | 3 | 1:3 | 3 | Work | 1 | 3 | 1:3 | 3 | Work | 1 | 2 | 1:2 | 2 | Work
11:00 AM-Noon
Noon-1:00 PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 1:3 | 3 | Work | 1 | 4 | 1:4 | 4 | Work
1:00-2:00 PM |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1:1 | 1 | Work
2:00-3:00 PM | 1 | 3 | 1:3 | 3 | Work
3:00-4:00 PM
4:00-5:00 PM
5:00-6:00 PM
6:00-7:00 PM
7:00-8:00 PM
8:00-9:00 PM
Total Daily Hours Served | 1 |  |  |  |  | 0.5 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 0 |  |  |  |  | 0
Do Not Write Below This Line - For Administrative Purposes Only
Average Daily Ratios |  |  |  | 6 | 1:3 |  |  |  | 2 | 1:2 |  |  |  | 4 | 1:2 |  |  |  | 6 | 1:3 |  |  |  | 6 | 1:3 |  |  |  | 0 |  |  |  |  | 0
Average Weekly Staffing Ratio.  Transfer this ratio to the DT&H Summary Sheet, Column G. ) |  |  |  |  | 1:2
Average Attendance Hours/Week |  |  |  |  | 4.5
Client Name: |  |  |  |  | Average Hrs/Week: |  |  |  |  | Average Weekly Staff [NAME]:
[NAME] |  |  |  |  | 4.5 |  |  |  |  | 1:2
Spreadsheet: 0958776b-c1fa-49b6-9d31-9a04e522803f
Sheet: Sheet2

Date | Billed kWh | kWh Charges | Demand | Demand $ | Taxes | Other Charges | Month Total
2009-04-09 00:00:00 | 16960 | 1691.45 | 52 | 797.44 | 7.8 | 149.54 | 2646.23
2009-05-09 00:00:00 | 20000 | 1981.64 | 75.2 | 1638.39 | 9.2 | 164.96 | 3794.19 |  | Date | Month Total
2009-06-09 00:00:00 | 18960 | 1869.7 | 72 | 1826.64 | 8.72 | 158.76 | 3863.82 |  | 2009-04-09 00:00:00 | 2646.23
2009-07-09 00:00:00 | 26320 | 2580.75 | 80.8 | 2049.89 | 12.11 | 197.24 |  |  | 2009-05-09 00:00:00 | 3794.19
2009-08-09 00:00:00 | 25920 | 2600.19 | 88 | 2232.56 | 11.92 | 195.29 |  |  | 2009-06-09 00:00:00 | 3863.82
2009-09-09 00:00:00 | 26960 | 2658.33 | 78.4 | 1985.9 | 12.4 | 200.74 |  |  | 2009-07-09 00:00:00 | 4839.989999999999
2009-10-09 00:00:00 | 26480 | 2618.9 | 90.4 | 1706.66 | 12.19 | 198.51 |  |  | 2009-08-09 00:00:00 | 5039.96
2009-11-09 00:00:00 | 25520 | 2479.56 | 103.2 | 1533.34 | 11.73 | 194.92 |  |  | 2009-09-09 00:00:00 | 4857.369999999999
2009-12-09 00:00:00 | 17360 | 1733.45 | 69.6 | 985.66 | 7.99 | 151.26 |  |  | 2009-10-09 00:00:00 | 4536.26
2010-01-09 00:00:00 | 16560 | 1553.62 | 48 | 773.3 | 7.61 | 147.54 |  |  | 2009-11-09 00:00:00 | 4219.549999999999
2010-02-09 00:00:00 | 15520 | 1419.96 | 44 | 756.75 | 7.13 | 142.13 |  |  | 2009-12-09 00:00:00 | 2878.36
2010-03-09 00:00:00 | 14560 | 1340.27 | 46.4 | 756.75 | 6.69 | 137.53 |  |  | 2010-01-09 00:00:00 | 2482.07
2010-04-09 00:00:00 | 16800 | 1531.63 | 48 | 779.93 | 7.73 | 149.76 |  |  | 2010-02-09 00:00:00 | 2325.97
2010-05-09 00:00:00 | 17840 | 1583.6 | 60.8 | 1247.65 | 8.2 | 155.34 |  |  | 2010-03-09 00:00:00 | 2241.24
2010-06-09 00:00:00 | 20480 | 1765.32 | 68.8 | 1691.8 | 9.43 | 168.63 |  |  | 2010-04-09 00:00:00 | 2469.05
2010-07-09 00:00:00 | 24480 | 2149.62 | 76 | 1868.84 | 11.27 | 189.55 |  |  | 2010-05-09 00:00:00 | 2994.79
2010-08-09 00:00:00 | 23280 | 2048.3 | 76.8 | 1888.52 | 10.71 | 183.36 |  |  | 2010-06-09 00:00:00 | 3635.18
 |  |  |  |  |  |  |  |  | 2010-07-09 00:00:00 | 4219.28
 |  |  |  |  |  |  |  |  | 2010-08-09 00:00:00 | 4130.89
1 Year