tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a57c1e2-2042-473e-b768-f3ea7502eba2
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
TRIG | Test | TRIG | Triglycerides, Serum | Triglycerides, S | [NAME] | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Collection Instructions:  1. Fasting-overnight (12-14 hours) 2. Patient must not consume any alcohol for 24 hours before the specimen is drawn. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | The National Cholesterol Education Program (NCEP) has set the following guidelines for lipids (total cholesterol, triglycerides, HDL, and LDL cholesterol) in adults ages 18 and up: TRIGLYCERIDES Normal: <150 mg/dL Borderline high: 150-199 mg/dL High: 200-499 mg/dL Very high: > or =500 mg/dL The National Cholesterol Education Program (NCEP) and National Health and Nutrition Examination Survey (NHANES) has set the following guidelines for lipids (total cholesterol, triglycerides, HDL, and LDL cholesterol) in children ages 2 to 17: TRIGLYCERIDES Normal: <90 mg/dL Borderline high: 90-129 mg/dL High: > or =130 mg/dL Also see age- and sex-adjusted reference values in Triglycerides-Percentile Ranking in Lipids and [NAME] in Blood Plasma (Serum) in Special Instructions. | Monday through Sunday; Continuously | 1 day | 1 day | 1 | 84478 |  |  |  |  | Rochester
TRIG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TRIG | Result | TRIG | Triglycerides, S | Triglycerides, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2571-8
Spreadsheet: 061f6032-fc48-4bb8-b863-6c244549dbef
Sheet: Sheet1

ECOLAB INC. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
CONSOLIDATED BALANCE SHEET
(unaudited)
 |  |  | September 30 |  | December 31 |  | September 30
(millions) |  |  | 2011 |  | 2010 |  | 2010
Assets
Current assets
 | Cash and cash equivalents |  | 207.3 |  | 242.3 |  | 168.4
 | Accounts receivable, net |  | 1143.1 |  | 999.6 |  | 1019.8
 | Inventories |  | 504.9 |  | 447.6 |  | 456.5
 | Deferred income taxes |  | 86.5 |  | 78.9 |  | 78.6
 | Other current assets |  | 149.2 |  | 101.5 |  | 131.2
 | Total current assets |  | 2091 |  | 1869.9 |  | 1854.5
Property, plant and equipment, net |  |  | 1218.2 |  | 1148.3 |  | 1137.3
Goodwill |  |  | 1504 |  | 1329.3 |  | 1313.8
Other intangible assets, net |  |  | 418.8 |  | 282.5 |  | 291.2
Other assets |  |  | 273.6 |  | 242.2 |  | 264.7
Total assets |  |  | 5505.6 |  | 4872.200000000001 |  | 4861.5
Liabilities and Equity
Current liabilities
 | Short-term debt |  | 336.8 |  | 189.2 |  | 343.6
 | Accounts payable |  | 413.4 |  | 349.3 |  | 346.9
 | Compensation and benefits |  | 300 |  | 308.1 |  | 267.7
 | Income taxes |  | 36.5 |  | 36.7 |  | 25
 | Other current liabilities |  | 531 |  | 441.5 |  | 455.4
 | Total current liabilities |  | 1617.7 |  | 1324.8 |  | 1438.6
Long-term debt |  |  | 700.2 |  | 656.4 |  | 647.3
Postretirement health care and pension benefits |  |  | 494.8 |  | 565.8 |  | 577.5
Other liabilities |  |  | 222 |  | 192.2 |  | 230.3
Equity
 | Common stock |  | 335.1 |  | 333.1 |  | 332.5
 | Additional paid-in capital |  | 1404.8 |  | 1310.2 |  | 1281.3
 | Retained earnings |  | 3531.2 |  | 3279.1 |  | 3188.4
 | Accumulated other comprehensive loss |  | -160.7 |  | -271.9 |  | -320.2
 | Treasury stock |  | -2643.4 |  | -2521.3 |  | -2517.8
 | Total Ecolab shareholders' equity |  | 2467 |  | 2129.2 |  | 1964.2
 | Noncontrolling interest |  | 3.9 |  | 3.8 |  | 3.6
 | Total equity |  | 2470.900000000001 |  | 2133 |  | 1967.8
Total liabilities and equity |  |  | 5505.6 |  | 4872.2 |  | 4861.5
Spreadsheet: 758646d1638980656-sumif-get-value-from-different-row-example
Sheet: Planif_Prod (2)

 |  |  | Machine | S1
 |  |  | [NAME] | 57
 |  |  |  | Prévisions
Produit | MP | Ligne Prod | Data Stream | S1
1000 | MR1000 | [NAME] | Hist / Fcst | 20
 |  |  | [NAME] | 45
 |  |  | Ajustement
 |  |  | Production réelle | 45
 |  |  | Stock projeté
1600 | MR1600 | [NAME] | Hist / Fcst | 20
 |  |  | [NAME] | 12
 |  |  | Ajustement
 |  |  | Production réelle | 12
 |  |  | Stock projeté
Spreadsheet: c559eb0d-b63c-465d-8f04-0a4a1b21454a
Sheet: Sheet1

 |  |  | PeopleSoft Financials |  |  |  |  |  |  |  | Version 1.4
 |  |  | University of Southern Queensland
 |  | Homestay Payment Request
 |  |  | Please forward to Financial & Business Services - Accounts Payable
 |  |  |  |  |  |  |  |  |  |  | Feb 2012
Department Paying for Service |  |  | Dept ID: |  | 4420
 |  |  | Dept Name: |  | Open Access College
 |  |  | Contact:
 |  |  | Phone: |  |  |  |  |  | Date:
Please ensure that all information for the Vendor is correct on PeopleSoft prior to submitting this form.
NOTE:  The University's preferred method of payment is EFT - if not already supplied, please obtain
current bank account details for the vendor.
ABN (if applicable)
Vendor Number:
Vendor Name:
Please remember to attach any Supporting Documentation
Group Details
Name of Tour Group
Dates | From |  | to |  |  | inclusive
Number of Nights |  | 0
Number of Students |  | 0
Payment calculation |  |  |  |  | Gross Amount | BU | Account | FD | Dept | Prog | Project
Rate per night |  | 28.57 |  |  |  | USQ10 | 33605 | 2 | 4420 | 70
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | Comments:
Total for Payment
I certify that the sum above is due and payable to the above-mentioned vendor and that any services referred to above have been supplied in a satisfactory manner as required by the University of Southern Queensland. |  |  |  |  | I certify that the payment detailed herein is necessary for the proper operation of the University, that this expenditure is within my level of delegated authority, and hereby authorise this expenditure.
______________________________________ |  |  |  |  | _____________________________________ |  |  |  |  | /         /
Requesting Officer |  |  |  |  | Authorising Officer (Please Print)
(Please Print) |  |  |  |  | (Financial Delegate)
Spreadsheet: 888715d1739292839-how-to-use-vlookup-sum-sumifs-with-multiple-criteria-excel-question
Sheet: Sheet1

 | Master table
 |  | ProductGroup | Group3 | Group2 | Group1 | Group2 | Group 3 | Group3 | Group2 | Group1 | Group2 | Group 3 | Group3 | Group2 | Group1 | Group2 | Group 3
 |  | Segment | Large | Large | Large | Large | Large | Medium | Medium | Medium | Medium | Medium | Small | Small | Small | Small | Small
 |  | Product | A | B | C | D | E | A | B | C | D | E | A | B | C | D | E
 |  | COUNTRIES
 |  | Country1 | 12 | 22 | 32 | 42 | 52 | 52 | 62 | 72 | 82 | 92 | 92 | 102 | 112 | 122 | 132
 |  | Country2 | 13 | 17 | 21 | 25 | 29 | 29 | 33 | 37 | 41 | 45 | 45 | 49 | 53 | 57 | 61
 |  | Country3 | 15 | 28 | 41 | 54 | 67 | 67 | 80 | 93 | 106 | 119 | 119 | 132 | 145 | 158 | 171
 |  | Country4 | 40 | 42 | 44 | 46 | 48 | 48 | 50 | 52 | 54 | 56 | 56 | 58 | 60 | 62 | 64
 | New table |  |  |  |  |  |  |  |  |  |  |  | TRANSPOSE-GROUPBY:
 |  | Product Group | Group1 | Group2 | Group3 | Group1 | Group2 | Group3 | Group1 | Group2 | Group3 |  |  | Group1 | Group2 | Group3 | Group1 | Group2 | Group3 | Group1 | Group2 | Group3
 |  | Segment | Large | Large | Large | Medium | Medium | Medium | Small | Small | Small |  | Segment | Large | Large | Large | Medium | Medium | Medium | Small | Small | Small
 |  | COUNTRIES |  |  |  |  |  |  |  |  |  |  | COUNTRIES
 |  | Country1 |  | 64 | 64 | 72 | 144 | 144 | 112 | 224 | 224 |  | Country1 | 32 | 64 | 64 | 72 | 144 | 144 | 112 | 224 | 224
 |  | Country2 | 21 | 42 | 42 | 37 | 74 | 74 | 53 | 106 | 106 |  | Country2 | 21 | 42 | 42 | 37 | 74 | 74 | 53 | 106 | 106
 |  | Country3 | 41 | 82 | 82 | 93 | 186 | 186 | 145 | 290 | 290 |  | Country3 | 41 | 82 | 82 | 93 | 186 | 186 | 145 | 290 | 290
 |  | Country4 | 44 | 88 | 88 | 52 | 104 | 104 | 60 | 120 | 120 |  | Country4 | 44 | 88 | 88 | 52 | 104 | 104 | 60 | 120 | 120
 | Products & Group
 |  | Product | ProductGroup
 |  | A | Group3
 |  | B | Group2
 |  | C | Group1
 |  | D | Group2
 |  | E | Group 3
 |  |  |  |  |  | How to use vlookup/sum/sumifs
 |  |  |  |  |  | Hi, I would like to create a new table based on a master table (which I cannot change). How do I get the sum of values into the new table using vlookup/sum/sumifs with multiple criteria (see example picture). Since the actual master table is way more complex, I would like to use a single defined ranges for the ProductGroup, Segment, Countries and the values in the master table. Fyi, the country list is the same for both master table and new table.
 |  |  |  |  |  | Thanks for your help!
Spreadsheet: joe_parks__14601__POSTIONTRAX_OCT
Sheet: FEB_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  |  |  |  |  | 20000
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 62309 | 62102
2 | 50220 | 49280
3 | 49998 | 49280
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
2002-02-28 00:00:00 |  |  | 9003
2002-03-03 00:00:00
CBS Volume
 |  |  | 4076
Spreadsheet: 98571d1297428749-sales-spread-sheet-and-calculating-percent-copy-of-telesales-appointments
Sheet: Sheet1

Targets | Pauline | 10
 | [NAME] | 20
 |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Staff | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls | Appointments | Total Calls
 | Pauline | 15 | 709 | 9 | 652 | 11 | 715
 | [NAME] | 22 | 1024 | 14 | 1010 | 9 | 1060
 |  | January % |  | February % |  | March % |  | April % |  | May % |  | June % |  | July % |  | August % |  | September % |  | October % |  | November % |  | December %
 |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments |  | Appointments
 | Pauline
 | [NAME]
 |  | 1st Quarter % |  |  |  |  |  | 2nd Quarter % |  |  |  |  |  | 3rd Quarter % |  |  |  |  |  | 4th Quarter %
 | Pauline
 | [NAME]
 |  | Annual %
 | Pauline
 | [NAME]
Spreadsheet: 709071d1608145028-matching-different-dates-with-same-item-sample-example-multi-match-same-id
Sheet: Intakes

ID # | Name | Intake Date | Intake Date | Address | Type | Condition | Species | Sex | Age | Breed | Color
A826777 |  | 2020-12-05 17:38:00 | 2020-12-05 17:38:00 | 6405 Cir S Rd in Austin (TX) | Stray | Normal | Dog | Intact Female | 4 months | Pit Bull Mix | Black/White
[NAME] | [NAME] | 2020-12-05 16:37:00 | 2020-12-05 16:37:00 | 8107 Manassas in Austin (TX) | Stray | Injured | Dog | Intact Female | 10 years | Lhasa Apso | White/White
A826773 |  | 2020-12-05 16:21:00 | 2020-12-05 16:21:00 | [NAME] (TX) | Stray | Normal | Cat | Intact Male | 4 weeks | Domestic Shorthair | [NAME]
A826772 |  | 2020-12-05 16:18:00 | 2020-12-05 16:18:00 | [NAME] (TX) | Stray | Normal | Cat | Intact Male | 4 weeks | Domestic Shorthair | [NAME]
A826771 |  | 2020-12-05 16:13:00 | 2020-12-05 16:13:00 | [NAME] (TX) | Stray | Normal | Cat | Intact Male | 4 weeks | Domestic Shorthair | [NAME]
A825700 |  | 2020-12-04 12:52:00 | 2020-12-04 12:52:00 | 9500 Dessau Rd in Austin (TX) | Owner [NAME] | Normal | Dog | Neutered Male | 3 months | [NAME] | [NAME]
A825492 | Luna | 2020-12-04 12:40:00 | 2020-12-04 12:40:00 | Manor (TX) | Owner [NAME] | Normal | Dog | [NAME] | 1 month | [NAME] | Black
A826166 | *Ophelia | 2020-12-01 16:49:00 | 2020-12-01 16:49:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | [NAME] | 2 years | German Shepherd | Black/Brown
A826774 |  | 2020-11-26 16:30:00 | 2020-11-26 16:30:00 | 22914 [NAME] in  (TX) | Stray | Normal | Cat | NULL | NULL | Sphynx | Unknown
A826166 | *Ophelia | 2020-11-20 14:48:00 | 2020-11-20 14:48:00 | 1433 Bradbury Lane in Austin (TX) | Stray | Normal | Dog | Intact Female | 2 years | German Shepherd | Black/Brown
A825863 | *Poppet | 2020-11-19 19:15:00 | 2020-11-19 19:15:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | [NAME] | 8 months | [NAME] | Brown/White
A825700 |  | 2020-11-19 19:15:00 | 2020-11-19 19:15:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | Neutered Male | 3 months | [NAME] | [NAME]
A825653 | [NAME] | 2020-11-16 13:38:00 | 2020-11-16 13:38:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | [NAME] | 3 years | Beagle/Chihuahua Shorthair | Tan/White
A825863 | *Poppet | 2020-11-14 08:36:00 | 2020-11-14 08:36:00 | 15204 Eilers Road in Travis (TX) | Stray | Normal | Dog | Intact Female | 8 months | [NAME] | Brown/White
A825700 |  | 2020-11-09 15:32:00 | 2020-11-09 15:32:00 | 11220 [NAME] in Austin (TX) | Stray | Normal | Dog | Intact Male | 2 months | [NAME] | [NAME]
A825653 | [NAME] | 2020-11-08 14:28:00 | 2020-11-08 14:28:00 | 7201 [NAME] in Austin (TX) | Abandoned | Normal | Dog | Intact Female | 3 years | Beagle/Chihuahua Shorthair | Tan/White
A825492 | Luna | 2020-11-05 10:55:00 | 2020-11-05 10:55:00 | 8102 [NAME] in Travis (TX) | Stray | Normal | Dog | Intact Female | 4 weeks | [NAME] | Black
Spreadsheet: 883913d1732690245-lambda-and-xlookup-issue-jp-bagel-excel-sumif-let-riddle-spill-365-aligw
Sheet: Sheet1

Raw data |  |  |  |  |  |  |  | Named ranges
Fruits | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | References | Name
Apples | 2229 | 2366 | 2623 | 2878 | 3001 |  |  | A2:F13 | tblData
Pears | 700 | 849 | 1140 | 1294 | 1568 |  |  | B3:F13 | tblDataBody
[NAME] | 0 | 0 | 0 | 0 | 0 |  |  | B2:F2 | lstMonths
Bananas | 176 | 184 | 219 | 224 | 226 |  |  | A3:A13 | lstFruits
Peaches | 7 | 8 | 9 | 10 | 10 |  |  | A17:[NAME] | tblBundles
Cherries | 296 | 207 | 205 | 217 | 222 |  |  | A11:A19 | lstBundles
Tomatoes | 155 | 158 | 161 | 164 | 168
Dates | 383 | 390 | 397 | 444 | 451
Nuts | 0 | 23 | 46 | 35 | 89
Raspberries | 4511 | 5622 | 7732 | 8966 | 11132
Strawberries | 11877 | 12088 | 15770 | 16041 | 18154
Bundles
Name | Includes
Red | Strawberries | Raspberries | Cherries | Tomatoes
Yellow | Pears | Apples | Peaches
Dry | Nuts | [NAME] | Dates
Reports
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- This solution works great enough, but I am looking to simplify it even more.
Red |  |  |  |  | =SUM(SUMIFS(B$4:B$14,lstFruits,FILTER(tblBundles,lstBundles=$A25,0)))
Yellow |  |  |  |  | Look in January data,in the list of fruits and sum if fruit is included in the bundle filtered to the bundle color.
Dry
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- I'd love to have a clean LET function, pass the ranges for months and bundle names to a LAMBDA function
Red |  | 18075 | 23868 |  | and spill the values in the table. I banged my head on the SUMIF only accepting ranges issue for days…
Yellow | 2936 | 3223 | 3772 |  | Can I use the same FILTER approach, and use a LAMBDA to SUM all the XLOOKUP values for each fruit?
Dry | 383 | 413 | 443 |  | I've failed so far…
Spreadsheet: 132e1599-661a-478f-8205-6a03f83ca873
Sheet: Template

Cash Flow Forecast
 | Project Name:
 | Date of Forecast:
 |  |  |  |  | Revenue |  |  |  |  |  | Forecasted Revenue |  |  |  |  |  |  |  |  |  |  | Check
Source of Funds |  |  |  |  | [NAME] | Received to Date | Balance | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Cumulated Remaining |  | Should = 0
 | RACP Grant
Total Source of Funds
 |  |  |  |  | Expenditures |  |  |  |  |  | Forecasted Expenditures |  |  |  |  |  |  |  |  |  |  | Check
Use of Funds |  |  |  |  | RDA-301 Amounts | Expended to Date | Balance | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |  |  | Should = 0
Total Use of Funds
Monthly Cash Flow
 |  |  |  |  |  |  |  |  |  |  | Financing Forecast
Financing: |  |  |  |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 | Cumulative Source of Funds
 | Cumulative Use of Funds
 | Cumulative Cash Flow
 | Line of Credit - Outstanding Balance
 | Interest estimated at |  |  | 0.08 |  | Total
Spreadsheet: 838242d1690847994-dynamic-column-for-index-match-match-formula-index-match-match-example-tms-v2
Sheet: Customer Codes Table

Customer 1 | Customer 1 Description | Customer 2 | Customer 2 Description | Customer 3 | Customer 3 Description | Customer 4 | Customer 4 Description | Customer 5 | Customer 5 Description |  | Customers
5011 | General [NAME] | LF | [NAME] | 4-Person Crew | 4-Person Crew | 120747 | Flagger | 331 | Supervisor |  |  | Customer 2 | Customer 3 | Customer 4 | Customer 5
5012 | [NAME] | CF | [NAME] | 5-Person Crew | 5-Person Crew | 700000-HR | Skilled Truck Operator | 332 | Contact Person
90077 | Working Foreman A | CL | [NAME]Climber | 6-Person Crew | 6-Person Crew | 799070 | Laborer/Brushman | 333 | Casual Labor |  | Codes
50003 | Working Foreman B | EO | Equipment Operator |  |  | 799090 | [NAME]/Trimmer | 334 | Leader  A
90009 | [NAME] | GM | [NAME] |  |  | 799095 | [NAME] | 335 | Leader B |  | 5-Person Crew
50130 | Climber A |  |  |  |  |  |  | 336 | Journeyperson |  | 6-Person Crew
50195 | Climber B |  |  |  |  |  |  | 337 | Apprentice B
Spreadsheet: 798808d1664746656-formula-not-working-as-expected-display-x-when-duplicate-but-not-the-first-one-sample
Sheet: Sheet1

Machine | [NAME] | Filter | Chosen | Disipline | Control | Current Score | Residual Score | Risk Reduction | Budget | $/Risk Reduction | Selected Low Risk | 18
 | Transmission hazards - finger/hand amp and crush in the chain and sprockets |  |  | M | Fixed barriers along control panel side and end. Ensure barriers are capble of impact from coil/crane impact without deformation or structural damage. Fixed barriers to extend out to the light curtain position. | 10 | 7
 |  |  |  | FS | Light curtain along loading side. 14[NAME] resolution. <40mm to ground. >1200mm high. Reach over position >550mm from hazard (edge of coil loader for simplicity). Approach speed position >500mm (based on 0.25[NAME] stopping time). Light curtain to stop coil loading carriage and the unwinder movement across to coil loader only. Other unwinder movement can continue. Reset buttons fitted to both ends of the light curtain. | 10 | 7
 | Finger draw in and crush in the carriage (rollers in guides, end strokes) |  |  | M | Fixed barriers along control panel side and end. Ensure barriers are capble of impact from coil/crane impact without deformation or structural damage. Fixed barriers to extend out to the light curtain position. | 10 | 7
 |  |  |  | FS | Light curtain along loading side. 14[NAME] resolution. <40mm to ground. >1200mm high. Reach over position >550mm from hazard (edge of coil loader for simplicity). Approach speed position >500mm (based on 0.25[NAME] stopping time). Light curtain to stop coil loading carriage and the unwinder movement across to coil loader only. Other unwinder movement can continue. Reset buttons fitted to both ends of the light curtain. | 10 | 7
 | Finger/hand crush between the carriage lifting plate and coil when the coil is being loaded onto unwinder or the coil and the machine frame when loading |  |  | M | Fixed barriers along control panel side and end. Ensure barriers are capble of impact from coil/crane impact without deformation or structural damage. Fixed barriers to extend out to the light curtain position. | 17 | 7
 |  |  |  | FS | Light curtain along loading side. 14[NAME] resolution. <40mm to ground. >1200mm high. Reach over position >550mm from hazard (edge of coil loader for simplicity). Approach speed position >500mm (based on 0.25[NAME] stopping time). Light curtain to stop coil loading carriage and the unwinder movement across to coil loader only. Other unwinder movement can continue. Reset buttons fitted to both ends of the light curtain. | 17 | 7
 | Fall >2.7m into pit |  |  | M | Fit edge potection barriers along the open side and along the end compliant with AS 1657. (100mm toeboard, 450mm mid rail, 950mm upper rail). Note this will need to be positioned inside the light curtain with enough clearance for the coils to pass by. | 18 | 14
Spreadsheet: 749081d1632494643-sort-by-column-in-one-sheet-and-maintain-row-formula-references-in-another-sheet-test-metrics-tms
Sheet: Mar

ISP | Hours Worked | Avg. ACD Talk Time | Auto-In Calls | Top Line Calls | Outbound Calls | Total Calls | Avg. Calls/Hour | ISP Emails | Clearslide Email Campaigns | Avg. Emails/Hour | Webinars Conducted | SF Leads Created | Avg. Work Volume/Hour | SF Tasks w/out Clearslide | SF Opp. | Total SF | Avg. SF/Hour | Clearslide Emails Sent | Total Contacts | Avg. Contacts/Hour
a | 168.5 | 02:56:00 | 113 | 66 | 134 |  |  | 575 | 0 |  | 12 | 3 |  | 485 | 55 |  |  | 0
b | 182.25 | 04:29:00 | 147 | 128 | 169 |  |  | 633 | 2 |  | 0 | 3 |  | 468 | 60 |  |  | 297
c | 189.5 | 05:39:00 | 93 | 168 | 104 |  |  | 671 | 0 |  | 0 | 6 |  | 184 | 75 |  |  | 0
Spreadsheet: 147215d1332606363-problem-with-sumif-sumif-error
Sheet: Sheet1

 | Table Name |  |  |  | =SUMIF(Range_DataCenters,$C$12,'tbl_DataCenters'!AX5:AX384) |  |  |  |  |  |  | << Can copy this formula across multiple columns
 | tbl_DataCenters['
 |  |  |  |  | =SUMIF(Range_DataCenters,$C$12,tbl_DataCenters['[01'] Nov-2011]) |  |  |  |  |  |  | << Can NOT copy this formulas across multiple columns, always copies tbl_DataCenters['[01'] Nov-2011]
 | Table Columns
 | [01] Nov-2011 |  |  |  |  |  | =SUMIF(Range_DataCenters,$C$12,$D9) |  |  |  | or | =SUMIF(Range_DataCenters,$C$12,CONCATENATE($B$2,$B7,"]")) |  |  |  |  |  |  | << Tried these but both give me an error
 | [02] Dec-2011 |  |  |  |  |  | =SUMIF(Range_DataCenters,$C$12,$D10)
 | [03] Jan-2012 |  |  |  |  |  | =SUMIF(Range_DataCenters,$C$12,$D11)
 | [04] Feb-2012
 | [05] Mar-2012
 | [06] Apr-2012
 | [07] May-2012
 | [08] Jun-2012
 | [09] Jul-2012
 | [10] Aug-2012
Spreadsheet: 718276d1613066967-how-to-search-keywords-in-a-sentence-keyword-search-new-1-
Sheet: Master

 | KW1 | KW2 | KW3 | KW4 | KW5 | KW6
Hello my name is Silmiya. I work for 3m company fom adt street
[NAME] plays with Adobe, dislikes ADT and is blackmailing the CEO of the 3M company for corruption concerning the Action Mining services Inc.
Silmiya does not use any prohibited words
Lookup Table
3M Company
3Skulls Paintball
AAT - The Association of Acounting Technicians
Abercrombie & Fitch
AC Service Tech LLC
Action Mining Services Inc.
Adobe
ADT