tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Verify

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Verification
Activity Name | Verify
Activity Description / Purpose | Before a client can qualify for a benefit they must prove that specific information is true. Producing proof of information is called verification. Information that requires verification varies from program to program, and district procedures vary as to whether workers need to retain a copy of the verification documents or simply attest that they have seen the documents
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Send letter requesting additional information/proof
Review proof
Set alert to check for received proof
Apply information from proof to eligibility decision
Identify sources for the verifying information
Checking for consistency
Reconcile identified difference from proof and application or interview
Review compliance of required referrals
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 715918d1611921871-error-with-countif-why-sum-with-criteria
Sheet: Sheet1

CalendarWeek | Year | Value | helper
1 | 2020 | 18695.92 |  |  | CRITERIA
2 | 2020 | 25778.31 |  |  | 52021
3 | 2020 | 10174.06
4 | 2020 | 13163.79 |  |  | number of rows
5 | 2020 | 13402.45
6 | 2020 | 17256.78
7 | 2020 | 15241.13
8 | 2020 | 23650.76
9 | 2020 | 7774.820000000001
10 | 2020 | 12469.86
11 | 2020 | 15347.92
12 | 2020 | 10576.4
13 | 2020 | 14839.47
14 | 2020 | 20338.5
15 | 2020 | 20647.78
16 | 2020 | 7136.88
17 | 2020 | 20551.89
18 | 2020 | 8803.33
19 | 2020 | 16665
20 | 2020 | 9539.5
21 | 2020 | 26539.34
22 | 2020 | 30439.33
23 | 2020 | 31021.46
24 | 2020 | 11590.66
25 | 2020 | 17167.82
26 | 2020 | 14020.98
27 | 2020 | 34754.38
28 | 2020 | 19736.92
29 | 2020 | 19069.58
30 | 2020 | 9606.36
31 | 2020 | 26037.5
32 | 2020 | 30417.69
33 | 2020 | 19399.86
34 | 2020 | 12063.99
35 | 2020 | 23507.9
36 | 2020 | 24940.7
37 | 2020 | 16071.47
38 | 2020 | 24550.17
39 | 2020 | 17508.69
40 | 2020 | 18167.2
41 | 2020 | 7369.59
42 | 2020 | 13055.22
43 | 2020 | 16689.03
44 | 2020 | 11733.18
45 | 2020 | 18712.8
46 | 2020 | 14536.38
47 | 2020 | 14229.84
48 | 2020 | 14075.66
49 | 2020 | 32626.99
50 | 2020 | 34174.36
51 | 2020 | 11078.88
52 | 2020 | 21485.36
2 | 2021 | 9374.880000000001
3 | 2021 | 10807.27
4 | 2021 | 19113.33
5 | 2021 | 9645.42
Spreadsheet: 104824d1302274485-searching-and-comparing-text-string-in-2-columns-notional-sheet
Sheet: Sheet1

**Data located on other sheet**
Keywords | Occurrances
adjacent tanks | 0
adjacent buildings | 0
fuel capacity label | 0
fire extinguisher | 0
placards | 0
fall risk | 0
fuel capacity | 0
filling platform | 0
chronic spillage | 0
vehicular protection | 0
coating failure | 0
interstice monitor | 0
normal vent device | 0
debris | 0
drain not locked | 0
other purposes than venting | 0
plastic*tank openings | 0
Spreadsheet: james_steffes__12842__CTCanalysis3
Sheet: SCE_Summary

 |  |  | [NAME] 00 | Oct-Dec 00
SCE |  |  |  |  | Jan 5-18 | Jan 19-31 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | Fwd (PV)
DA Volumes/Fwd Position
Bundled Rate -- No Surcharges
Non-Gen (T&D plus Other)
Gen (Bundled - Non-Gen)
Jan 4 Surcharge |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
[NAME] |  |  | 0 | 0
PX Price: Assuming DWR = $54.71
PX Price: PG&E "Adjusted"
PX Price: Actual/DJ/ENA Fwd
CTC: Assuming DWR = $54.71
CTC: PG&E "Adjusted"
CTC: Actual/DJ/ENA Fwd
As Booked, Collected, Paid, Reserved, Etc.
CTC
[NAME]
PX Price
CTC
MTM Value ($000)
Surcharge(s)
Total Surcharge |  |  | 0 | 0
MTM Value ($000)
Net P/L Impacts of Changes
CTC Eliminated as of Jan 4 |  |  | 0 | 0
CTC Eliminated as of Jan 19 |  |  | 0 | 0 | 0
CTC Adjusted as of Jan 4
DWR = $54.71 |  |  | 0 | 0
PG&E "Adjusted" |  |  | 0 | 0
CTC Adjusted as of Jan 19
DWR = $54.71
PG&E "Adjusted"
Jan Surcharge Goes Away
Jan Surcharge Goes Away as of Sep 1
Return to Bundled Service
Spreadsheet: 853636d1703567140-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised
Sheet: Sheet1

aa | TGNo | Blank1 | Date | Category | [NAME] | Party Name | Item Name | Person | # [NAME] | J S (From) | J S (To) | JRT(From) | JRT(To) | SW (cmr) | OW | IG | Fewa | IP Length | FW Size | FMC | HEader1 | HEader2 | HEader3 | 1st Part | [NAME] | HEader6 | 2nd Part | HEader8 | HEader9 | HEader10 | HEader11 | HEader12 | HEader13 | HEader14 | HEader15 | HEader16 | HEader17 | HEader18 | HEader19 | x | Code
 | AC-125/X |  | 2023-09-12 00:00:00 | 8C | A-1256 | Apple Inc | Iphone 11 | [NAME] | 5 |  |  |  |  |  |  |  |  | ABC | 440 | 45 |  |  |  | 2563 |  |  | 564 |  |  |  |  |  |  |  |  |  |  | ABC-DSC/SE |  |  | 12563
 | BC-125/X |  | 2023-09-12 00:00:00 | 8C | PC-3458 | Google Inc | X-Watch | [NAME] | 4 |  |  |  |  |  |  |  |  | PLAT | 350 | 61 |  |  |  | 643 |  |  | 6314 |  |  |  |  |  |  |  |  |  |  | SALA-LA |  |  | 9781
 |  |  | 2023-09-13 00:00:00 | 8C | A/658 | Apple | Ultra | Hapkins | 3 |  |  |  |  |  |  |  |  | Disc | 90 | 71 |  |  |  | 479 |  |  | 3641 |  |  |  |  |  |  |  |  |  |  | MAS/RAKE-45 |  |  | 2364
 | CS-536 |  | 2023-09-13 00:00:00 | 4C | DC/536 | Microsoft | [NAME] | Tabla | 2 |  |  |  |  |  |  |  |  | ABC | 145 | 90 |  |  |  | 634 |  |  | 792 |  |  |  |  |  |  |  |  |  |  | SALMON-50/TC-15 |  |  | 61364
Spreadsheet: 1e3f2765-3176-4599-b797-f1f62f22a235
Sheet: Table of Contents

Center for Health Information and Analysis
Massachusetts Hospital Profiles: Data Through Fiscal Year 2012
March, 2014
Acute Hospital Data Appendix
Table of Contents
Appendix A – Demographics/ At a Glance (FY12 data)
- | Cohort Assignment
- | Region Assignment
- | Hospital System
- | Change in Ownership
- | Tax status
- | Special Public Funding
- | Hospital City location
- | Hospital County location
- | Trauma Level Designation (Adult)
- | Trauma Level Designation (Pediatric)
- | Case Mix Index (CMI)
Appendix B – Beds (FY12 data)
- | Staffed Beds by Unit
- | Total Percent Occupancy
- | Total Average Daily Census
Appendix C – Services (FY08-FY12 data)
- | Most Common Inpatient cases (DRGs): Top 15 DRGs
- | Inpatient Communities: Top 10 communities
- | Severity Quintiles
Appendix D – Payer Mix and Utilization
- | GPSR by [NAME] (FY12 data only)
- | Inpatient NPSR (FY08-FY12)
- | Outpatient NPSR (FY08-FY12)
- | Total IP Costs (FY08-FY12)
- | Total GME costs (FY09-FY12)
- | Total Physician Compensation Costs (FY09-FY12)
- | Total Adjusted Costs (FY09-FY12)
- | Case Mix Adjusted Discharges (CMAD) (FY09-FY12)
- | IP Cost/ CMAD (FY09-FY12)
- | Total Outpatient Costs (FY08-FY12)
- | Discharges (FY08-FY12)
- | Outpatient Visits (FY08-FY12)
Appendix E – Relative Price (RP)
- | Blended Composite Relative Price
- | Top 3 Commercial Payers Relative Price
[NAME] (FY08-FY12 Data)
- | Total Revenue
- | Total Expenses
- | Total Surplus
- | Total Margin
[NAME] Region Zip Codes
- | USPS Community Postal Codes for Massachusetts; Related HPC Region
Spreadsheet: 98624d1297468913-matching-3-columns-with-criteria-and-calculation-sample-data
Sheet: Sheet1

DATE | COMPANY ID | ITEM | UOM | COST
2009-01-02 00:00:00 | 1111111 | 1 | BX | 10
2009-02-03 00:00:00 | 1111111 | 1 | EA | 10
2009-03-07 00:00:00 | 2222222 | 1 | BX | 10
2009-04-08 00:00:00 | 1111111 | 1 | BX | 20
2009-05-10 00:00:00 | 2222222 | 2 | EA | 10
2009-06-11 00:00:00 | 2222222 | 2 | BX | 20
2009-07-13 00:00:00 | 3333333 | 2 | BX | 10
2009-08-14 00:00:00 | 3333333 | 1 | EA | 20
2009-09-15 00:00:00 | 4444444 | 2 | BX | 40
2009-10-17 00:00:00 | 4444444 | 1 | BX | 10
2009-11-18 00:00:00 | 1111111 | 2 | EA | 20
2009-12-20 00:00:00 | 1111111 | 2 | BX | 10
2010-01-21 00:00:00 | 3333333 | 2 | BX | 10
2010-02-22 00:00:00 | 3333333 | 2 | EA | 20
2010-03-26 00:00:00 | 4444444 | 1 | BX | 10
2010-04-27 00:00:00 | 1111111 | 2 | BX | 20
2010-05-29 00:00:00 | 1111111 | 2 | EA | 10
2010-06-30 00:00:00 | 2222222 | 3 | BX | 20
2010-07-01 00:00:00 | 2222222 | 3 | BX | 40
2010-08-01 00:00:00 | 1111111 | 1 | EA | 50
2010-08-01 00:00:00 | 2222222 | 1 | EA | 50
2010-08-01 00:00:00 | 3333333 | 1 | EA | 50
2010-08-01 00:00:00 | 4444444 | 1 | EA | 50
2010-08-01 00:00:00 | 1111111 | 1 | BX | 100
2010-08-01 00:00:00 | 2222222 | 1 | BX | 100
2010-08-01 00:00:00 | 3333333 | 1 | BX | 100
2010-08-01 00:00:00 | 4444444 | 1 | BX | 100
2010-08-01 00:00:00 | 1111111 | 2 | EA | 50
2010-08-01 00:00:00 | 2222222 | 2 | EA | 50
2010-08-01 00:00:00 | 3333333 | 2 | EA | 50
2010-08-01 00:00:00 | 4444444 | 2 | EA | 50
2010-08-01 00:00:00 | 1111111 | 2 | BX | 100
2010-08-01 00:00:00 | 2222222 | 2 | BX | 100
2010-08-01 00:00:00 | 3333333 | 2 | BX | 100
2010-08-01 00:00:00 | 4444444 | 2 | BX | 100
2010-08-01 00:00:00 | 1111111 | 3 | EA | 50
2010-08-01 00:00:00 | 2222222 | 3 | EA | 50
2010-08-01 00:00:00 | 3333333 | 3 | EA | 50
2010-08-01 00:00:00 | 4444444 | 3 | EA | 50
2010-08-01 00:00:00 | 1111111 | 3 | BX | 100
2010-08-01 00:00:00 | 2222222 | 3 | BX | 100
2010-08-01 00:00:00 | 3333333 | 3 | BX | 100
2010-08-01 00:00:00 | 4444444 | 3 | BX | 100
Spreadsheet: 785226d1656261534-conditional-lookup-based-on-two-cells-cadet-tracker
Sheet: Cadet

No | Name | Status | Contact # | Staff # | Initial PC | Start of GS | Start of SIM | Completion Date | A/C Trng | Start of flying | [NAME] | Civil ID | Sponsorship | Remarks
1 | aaa | [NAME] | 1 | 36878 | 2021-04-16 00:00:00 |  | 2021-03-08 00:00:00 |  |  |  |  |  | MOHE
2 | bbb | SIM Phase - Advanced | 2 | 36879 | 2021-07-12 00:00:00 |  | 2021-06-01 00:00:00 |  |  |  |  |  | MOHE
3 | [NAME] | SIM Phase - Intermediate | 3 | 36884 | 2021-07-09 00:00:00 |  | 2021-06-01 00:00:00 |  |  |  |  |  | MOHE
4 | ddd | SIM Phase - Basic | 4 | 36890 | 2021-09-09 00:00:00 |  | 2021-08-01 00:00:00 |  |  |  |  |  | self
5 | eee | Flight School CK51 - CK70 | 5 | 37146 | 2021-10-19 00:00:00 |  | 2021-09-15 00:00:00 |  |  |  |  |  | MOHE
6 | [NAME] | Flight School CK31 - CK50 | 6 | 37147 | 2021-11-19 00:00:00 |  | 2021-10-01 00:00:00 |  |  |  |  |  | MOHE
7 | ggg | Flight School CK01 - CK30 | 7 | 29095 | 2021-11-25 00:00:00 |  | 2021-10-17 00:00:00 |  |  | 2022-06-10 00:00:00 |  |  | MOHE
8 | hhh | Ground School | 8 | 36899 | 2021-11-28 00:00:00 |  | 2021-10-17 00:00:00 |  |  | 2022-06-10 00:00:00 |  |  | MOHE
9 | iii | SIM Phase - Advanced | 9 | 37148 | 2021-12-11 00:00:00 |  | 2021-10-01 00:00:00 |  | 2022-04-16 00:00:00 |  |  |  | Self
10 | jjj | SIM Phase - Advanced | 10 | 37149 | 2021-12-29 00:00:00 |  | 2021-09-15 00:00:00 |  | 2022-04-16 00:00:00 |  |  |  | MOHE
11 | kkk | SIM Phase - Basic | 11 | 36937 | 2022-01-02 00:00:00 |  | 2021-11-28 00:00:00 |  |  |  |  |  | Self
Spreadsheet: 83860d1283889473-excel-2007-extracting-rows-of-data-based-on-date-time-and-price-excel-forum-sample-spreadsheet
Sheet: Sheet2

RACE MEETING
GB / Ludl 13th Dec
GB / Taun 13th Dec
GB / Wolv 13th Dec
GB / Sthl 14th Dec
GB / Chelt 14th Dec
GB / Wolv 14th Dec
GB / Sthl 15th Dec
GB / Ling 15th Dec
GB / Chelt 15th Dec
GB / Wolv 15th Dec
GB / Kemp 16th Dec
GB / Plump 17th Dec
GB / Wolv 17th Dec
GB / Catt 18th Dec
GB / Sthl 18th Dec
Spreadsheet: 50858d1250417474-data-validation-dropdowns-and-change-events-695842
Sheet: Sheet1

 | A | B | C |  |  |  | C |  | C | 3
AA | 1 | 5 | 1 |  |  | AA | 1 |  |  |  |  |  |  | Data Source
BB | 2 | 4 | 2 |  |  | BB | 2 |  |  |  |  |  |  | Chart Data Source
CC | 3 | 3 | 3 |  |  | CC | 3 |  |  |  |  |  |  | User Selection
DD | 4 | 2 | 2 |  |  | DD | 2 |  |  |  |  |  |  | Column Index of User Selection
EE | 5 | 1 | 1 |  |  | EE | 1
Spreadsheet: 551642d1513067720-search-for-closest-value-or-greater-fill_order-lookup-v1
Sheet: Lots

Item Number | Lot Number | Qty.
SKU001 | Lot 11 | 2
SKU001 | Lot 12 | 6
SKU001 | Lot 13 | 3
SKU001 | Lot 14 | 4
SKU001 | Lot 15 | 5
SKU001 | Lot 16 | 4
SKU002 | Lot 21 | 2
SKU002 | Lot 22 | 1
SKU002 | Lot 23 | 5
SKU002 | Lot 24 | 4
SKU003 | Lot 31 | 2
SKU003 | Lot 32 | 8
SKU003 | Lot 33 | 1
SKU004 | Lot 41 | 3
SKU004 | Lot 42 | 3
SKU005 | Lot 51 | 8
SKU005 | Lot 52 | 5
SKU006 | Lot 61 | 4
SKU006 | Lot 62 | 8
SKU007 | Lot 71 | 10
SKU007 | Lot 72 | 5
SKU008 | Lot 81 | 6
SKU008 | Lot 82 | 1
Spreadsheet: 93835d1293621867-how-to-put-these-two-sets-of-data-together-for-adwords-generate-lists
Sheet: gen list

generated |  |  | or
martin 1 | things |  | martin 1 things
[NAME] | things |  | [NAME] things
[NAME] | things |  | [NAME] things
[NAME] | things |  | [NAME] things
martin5 | things |  | martin5 things
[NAME] | things |  | [NAME] things
martin7 | things |  | martin7 things
martin 1 | bits |  | martin 1 bits
[NAME] | bits |  | martin 2 bits
[NAME] | bits |  | martin 3 bits
[NAME] | bits |  | [NAME] bits
martin5 | bits |  | martin5 bits
[NAME] | bits |  | [NAME] bits
martin7 | bits |  | martin7 bits
martin 1 | eggs |  | martin 1 eggs
[NAME] | eggs |  | [NAME] eggs
[NAME] | eggs |  | martin 3 eggs
[NAME] | eggs |  | [NAME] eggs
martin5 | eggs |  | martin5 eggs
[NAME] | eggs |  | [NAME] eggs
martin7 | eggs |  | martin7 eggs
martin 1 | frogs |  | martin 1 frogs
[NAME] | frogs |  | [NAME]
[NAME] | frogs |  | [NAME]
[NAME] | frogs |  | [NAME]
martin5 | frogs |  | martin5 frogs
[NAME] | frogs |  | [NAME]
martin7 | frogs |  | martin7 frogs
martin 1 | shovels |  | martin 1 shovels
[NAME] | shovels |  | [NAME] shovels
[NAME] | shovels |  | [NAME] shovels
[NAME] | shovels |  | [NAME] shovels
martin5 | shovels |  | martin5 shovels
[NAME] | shovels |  | [NAME] shovels
martin7 | shovels |  | martin7 shovels
Spreadsheet: 838926d1691520659-averageifs-with-isformula-averageifs-help
Sheet: Solution 1

time/date | a(%) | b(%) | c(%) | [NAME]) | [NAME]
2020-01-23 12:15:07 | 95.8077 | 2.7815 | 1.410800000000003
2020-01-24 12:15:00 | 95.4539 | 2.557 | 1.989099999999996
2020-01-29 10:30:00 | 96.1821 | 2.4956 | 1.322299999999994 | 0.63
2020-02-05 10:05:00 | 96.1561 | 2.6413 | 1.202600000000005 | 0.37
2020-02-12 11:30:00 | 94.4905 | 3.9694 | 1.540100000000003
2020-02-19 10:00:48 | 96.5018 | 2.161 | 1.337199999999997 | 2.873
2020-02-26 11:40:00 | 96.8241 | 1.9614 | 1.214499999999999 | 0.07
2020-03-06 15:15:00 | 96.9922 | 1.4135 | 1.594300000000003 | 0.83
2020-03-11 13:05:00 | 95.9704 | 1.9137 | 2.115900000000002 | 1.05
2020-03-18 10:10:49 | 96.472 | 1.9753 | 1.552700000000006
2020-03-25 08:55:00 | 93.5054 | 4.8329 | 1.661700000000005 | 0.66
2020-05-10 22:35:00 | 33.47 | 0.5 | 66.03 | 0.62
2020-05-13 12:30:37 | 0 | 0 | 100 | 0
2020-06-02 12:30:00 | 97.2685 | 1.343
Spreadsheet: 267701d1380140200-cant-figure-out-the-right-formula-for-data-sharing-between-worksheets-inventory-help
Sheet: Product

STYLE | SKU | [NAME] | COST | RETAIL | DEPARTMENT | CLASS
10873 |  | Gloves Giant Road Pro Gel Lrg |  |  | Cloth | Gloves
10893 |  | Gloves Giant Chill Mid Med Blk |  |  | Cloth | Gloves
10894 |  | Gloves Giant Chill Mid Lrg Blk |  |  | Cloth | Gloves
10895 |  | Gloves Giant Chill Mid XL Blk |  |  | Cloth | Gloves
10905 |  | Gloves Giant Plush Mens Large |  |  | Cloth | Gloves
11121 |  | [NAME] [NAME] |  |  | Cloth | Jersey
11123 |  | [NAME] [NAME] |  |  | Cloth | Jersey
11124 |  | [NAME] |  |  | Cloth | Jersey
11134 |  | [NAME] [NAME] |  |  | Cloth | Jersey
11137 |  | [NAME] Lady Sm Blue |  |  | Cloth | Jersey
11138 |  | [NAME] [NAME] |  |  | Cloth | Jersey
11139 |  | [NAME] Lady Lg Blue |  |  | Cloth | Jersey
11181 |  | Gloves Giant Slab Black XL |  |  | Cloth | Gloves
11215 |  | Gloves Giant U-Lite Lady XS |  |  | Cloth | Gloves
11219 |  | Gloves Giant U-Lite Lady XS |  |  | Cloth | Gloves
11223 |  | Gloves Giant U-Lite Mens Sm |  |  | Cloth | Gloves
11227 |  | Gloves Giant U-Lite Mens Sm |  |  | Cloth | Gloves
11280 |  | Gloves Giant Pro Gel Lady Lg |  |  | Cloth | Gloves
11283 |  | Gloves Giant Pro Gel Lady Md |  |  | Cloth | Gloves
11284 |  | Gloves Giant Pro Gel Lady Lg |  |  | Cloth | Gloves
11286 |  | Gloves Giant Pro Gel [NAME] |  |  | Cloth | Gloves
11288 |  | Gloves Giant Pro Gel Mens XL |  |  | Cloth | Gloves
11290 |  | Gloves Giant Pro Gel [NAME] |  |  | Cloth | Gloves
11382 |  | Gloves Giant Ultralite [NAME] |  |  | Cloth | Gloves
11383 |  | Gloves Giant Ultralite Mens Lg |  |  | Cloth | Gloves
11384 |  | Gloves Giant Ultralite [NAME] |  |  | Cloth | Gloves
11390 |  | Gloves Giant Ultralite [NAME] |  |  | Cloth | Gloves
11391 |  | Gloves Giant Ultralite [NAME] |  |  | Cloth | Gloves
11392 |  | Gloves Giant Ultralite Lady Lg |  |  | Cloth | Gloves
11526 |  | Gloves Giant Pro Gel [NAME] |  |  | Cloth | Gloves
11532 |  | Gloves Giant Pro Gel [NAME] |  |  | Cloth | Gloves
11533 |  | Gloves Giant Pro Gel Mens XL |  |  | Cloth | Gloves
11538 |  | Gloves Giant Pro Gel Mens XL |  |  | Cloth | Gloves
11593 |  | Gloves Giant Plush Gel Men Med |  |  | Cloth | Gloves
11594 |  | Gloves Giant Plush Gel Men Lrg |  |  | Cloth | Gloves
11595 |  | Gloves Giant Plush Gel Men XL |  |  | Cloth | Gloves
11598 |  | Gloves Giant Plush Gel [NAME] |  |  | Cloth | Gloves
11599 |  | Gloves Giant Plush Gel Lady Lg |  |  | Cloth | Gloves
11873 |  | Gloves Giant Crochet SF Med |  |  | Cloth | Gloves
11874 |  | Gloves Giant Crochet [NAME] |  |  | Cloth | Gloves
11875 |  | Gloves Giant Crochet SF XL |  |  | Cloth | Gloves
11878 |  | Gloves Giant [NAME] |  |  | Cloth | Gloves
11879 |  | Gloves Giant Crochet [NAME] |  |  | Cloth | Gloves
11880 |  | Gloves Giant Crochet SF XL |  |  | Cloth | Gloves
11916 |  | Jersey Giant C.I.D Medium |  |  | Cloth | Jersey
11917 |  | [NAME] C.I.D [NAME] |  |  | Cloth | Jersey
11918 |  | [NAME] C.I.D [NAME] |  |  | Cloth | Jersey
11931 |  | Sock Giant C.I.D. OSFM Blu |  |  | Cloth | Socks
12014 |  | [NAME] |  |  | Cloth | Misc
Spreadsheet: 768851d1645166280-if-cell-contains-a-certain-letter-then-i-need-to-divide-my-formula-by-2-or-50-light-and-ventilation-calculator-example
Sheet: Sheet1

Room | Floor Area (Sqm) | Window / Door Type | Window / Door (H) | Window / Door (W) |  | Total Opening Area | Light 10% | Ventilation
 |  |  |  |  |  |  |  | Fans 12.5% | No Fans 15% | Bathroom 5%
Lounge | 55 | SW | 1.2 | 1.8
 |  | LW | 1.8 | 1.8
 |  | SD | 2.1 | 2.1
 |  | FD | 2.1 | 2.1
EXAMPLES
Spreadsheet: 43837d1242445830-solved-changing-contents-of-list-via-validation-example1
Sheet: Sheet2

CATEGORIES LIST | NAMED List
Class 1 Radioactive
Class 2 Radioactive |  |  | Choose Category |  | Category List
Class 3 Radioactive
Class 1 Radioactive | NAMED List
Carbalaneksis*
Omnihawo* |  |  | Choose the "Category" |  | The list of names under the chosen
Eforoete* |  |  | from the [NAME] validation |  | Category should appear automatically
 |  |  | Cell |  | in the green area.
Class 2 Radioactive | NAMED List
[NAME]*
Omnifofiba* |  |  | Example: Should look like this…
Tokiw* |  |  | Choose Category |  | Category List
 |  |  | Class 1 Radioactive |  | Carbalaneksis*
Class 3 Radioactive | NAMED List |  |  |  | Omnihawo*
Ecoaw* |  |  |  |  | Eforoete*
Oratiine*
Pruton*
Scoskeu*
EXCEL 2003
Spreadsheet: 198187d1354697313-how-to-do-a-search-in-a-few-colums-sumproduct_solution
Sheet: Info

Policy |  | Schedule |  | Server | Backup_server | Status
All_Local_Drives |  | Daily_diff |  | erpbkmaster | Unix | Error
erpbk-FS |  | Default-Application-Backup |  | erpbkmedia1 | Windows | Successful
erpdev-erpqas-FS |  | Dup |  | erpbkmedia2 |  | Partially successful
erpdev-gd1ci-FS |  | FSDaily |  | erpdev
erpdev-GD1-SAP-Daily |  | FSWeekly |  | erpkmaster
erpdev-id1ci-FS |  | SAPDaily |  | erpnkmedia1
erpdev-ID1-SAP-Daily |  | SAPMonthly |  | erpqas
erpdev-pd1ci-FS |  | SAPWeekly |  | erprdn01
erpdev-PD1-SAP-Daily |  | Weekly_Full |  | erprdn02
erpdev-PD1-SAP-Weekly |  |  |  | erqas
erpdev-rd1ci-FS |  |  |  | HONT01
erpdev-RD1-SAP-Daily |  |  |  | HONT14
erpdev-rd2ci-FS |  |  |  | HONT21
erpdev-SD1-SAP-Daily |  |  |  | INTER-APPS-1
erpdev-SD1-SAP-Weekly |  |  |  | INTER-FOREST-1
erpqas-OD1-SAP-Daily |  |  |  | INTER-FOREST-2
erpqas-OD1-SAP-Weekly |  |  |  | INTER-LAND-1
erpqas-rd1ci-FS |  |  |  | INTER-MAIL-1
erpqas-rq2ci-FS |  |  |  | INTER-WWW-2
erpqas-sq1ci-FS |  |  |  | PRASAGPPADS01
erpqas-SQ1-SAP-Daily |  |  |  | PRASAGPPBCK01
erpqas-SQ1-SAP-Weekly |  |  |  | PRASAGPPBCK02
erprd-FS-Node |  |  |  | PRASAGPPDAG01
erprd-gp1app-FS |  |  |  | PRASAGPPFLS01
erprd-gp1ci-FS |  |  |  | PRASAGPPMBX01
erprd-GP1-FS-NFS |  |  |  | PRASAGPPMBX02
erprd-GP1-SAP-Daily |  |  |  | PRCGPGIS01
erprd-ip1app-FS |  |  |  | PRCGPMANAPP01
erprd-ip1ci-FS |  |  |  | PRCGPORA01
erprd-IP1-FS-NFS |  |  |  | sapgd1app70
erprd-IP1-SAP-Daily |  |  |  | sapgd1ci70z
erprd-IP1-SAP-Monthly |  |  |  | [NAME]
erprd-IP1-SAP-Weekly |  |  |  | sapgp1app75
erprd-op1app-FS |  |  |  | sapgp1app76
erprd-op1ci-FS |  |  |  | sapgp1ci70
erprd-OP1-FS-NFS |  |  |  | sapid1ci30z
erprd-OP1-SAP-Daily |  |  |  | sapip1
erprd-rp1app-FS |  |  |  | [NAME]
erprd-rp1ci-FS |  |  |  | sapip1app36
erprd-RP1-FS-NFS |  |  |  | sapip1ci30
erprd-RP1-SAP-Daily |  |  |  | sapop1
erprd-RP1-SAP-Weekly |  |  |  | sapop1app55
erprd-sp1app-FS |  |  |  | sapop1app56
erprd-sp1ci-FS |  |  |  | sapop1ci50
erprd-SP1-FS-NFS |  |  |  | sappd1app40
erprd-SP1-SAP-Daily |  |  |  | sappd1ci40z
erprd-SP1-SAP-Monthly |  |  |  | saprd1app00
erprd-SP1-SAP-Weekly |  |  |  | saprd1ci00z
erprd-tp1ci-FS |  |  |  | saprd2ci00z
erprd-TP1-FS-NFS |  |  |  | saprdci00z
Exchange |  |  |  | saprp1
SLP_dev-qa-disk-to tape-daily |  |  |  | saprp1app05
SLP_dev-qa-disk-to tape-weekly |  |  |  | saprp1app06
SLP_prod-disk-tape-daily |  |  |  | saprp1ci00
SLP_prod-disk-to-tape-Daily |  |  |  | saprq1ci00z
SLP_prod-disk-to-tape-monthly |  |  |  | saprq2ci00z
SLP_prod-disk-to-tape-Weekly |  |  |  | saprqci00z
 |  |  |  | sapsd1app20
 |  |  |  | sapsd1ci20z
 |  |  |  | [NAME]
 |  |  |  | sapsp1app25
 |  |  |  | sapsp1app26
 |  |  |  | sapsp1ci20
 |  |  |  | sapsq1app20
 |  |  |  | sapsq1ci20z
 |  |  |  | saptp1
 |  |  |  | saptp1ci90