tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813965d1674075565-selecting-the-nearest-static-location-weather-station-for-a-list-of-gps-tracker-points-gps_weather_sample_data
Sheet: Utrera Weather

Station name | Latitude | Longitude | dt_iso | Date_Time | T_Min (C) | [NAME] (C) | Pressure (hPa) | Humidity (%) | Wind_Speed (m/s) | Wind_Deg (˚) | [NAME]) | Clouds (%)
Utrera | 37.184813 | -5.779515 | 2020-06-05 06:00:00 +0000 UTC |  | 18.05 | 20 | 1013 | 88 | 4.1 | 200 |  | 75
Utrera | 37.184813 | -5.779515 | 2020-06-05 07:00:00 +0000 UTC |  | 19.44 | 20.56 | 1014 | 82 | 4.6 | 200 |  | 75
Utrera | 37.184813 | -5.779515 | 2020-06-05 08:00:00 +0000 UTC |  | 20.7 | 22.26 | 1014 | 77 | 5.7 | 210 |  | 75
Utrera | 37.184813 | -5.779515 | 2020-06-05 09:00:00 +0000 UTC |  | 21.67 | 23.65 | 1014 | 73 | 4.1 | 200 |  | 40
Utrera | 37.184813 | -5.779515 | 2020-06-05 10:00:00 +0000 UTC |  | 23.21 | 25.48 | 1014 | 57 | 3.6 | 210 |  | 40
Utrera | 37.184813 | -5.779515 | 2020-06-05 11:00:00 +0000 UTC |  | 24.44 | 26.6 | 1014 | 53 | 4.1 | 230 |  | 40
Utrera | 37.184813 | -5.779515 | 2020-06-05 12:00:00 +0000 UTC |  | 24.44 | 28 | 1013 | 50 | 5.1 | 230 |  | 40
Utrera | 37.184813 | -5.779515 | 2020-06-05 13:00:00 +0000 UTC |  | 25.11 | 28.33 | 1013 | 42 | 5.1 | 250 |  | 20
Utrera | 37.184813 | -5.779515 | 2020-06-05 14:00:00 +0000 UTC |  | 25.36 | 28.35 | 1012 | 39 | 5.1 | 270 |  | 20
Utrera | 37.184813 | -5.779515 | 2020-06-05 15:00:00 +0000 UTC |  | 25.3 | 28.33 | 1013 | 36 | 6.2 | 220 |  | 20
Spreadsheet: 706814d1606908782-lookup-across-multiple-columns-across-multiple-sheets-test
Sheet: Result

 |  |  |  |  |  |  |  |  |  |  | Apple
 |  | Apple |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 0 | 1 | 2 | 3 |  | Orange
 |  |  |  |  |  | 123 | Apple | Yes | Red |  | Pear
 |  | 745 | Apple | No | Blue | 847 | Apple | No | Red
 |  | 421 | Apple | Yes | Blue | 998 | Apple | Yes | Red
 |  | 207 | Apple | No | Red | 745 | Apple | No | Blue
 |  | 847 | Apple | No | Red | 108 | Apple | Yes | Blue
 |  | 108 | Apple | Yes | Blue | 421 | Apple | Yes | Blue
 |  | 855 | Apple | Yes | Blue | 207 | Apple | No | Red
 |  | 2654 | Apple | No | Blue | 855 | Apple | Yes | Blue
 |  | 998 | Apple | Yes | Red | 2654 | Apple | No | Blue
Spreadsheet: daren_farmer__5531__HPLN1021
Sheet: Sheet1

HPLN1017.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 21-23, 2000
 |  |  |  |  |  | *Sat/Mon. | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 10/21-22' | 2000-10-23 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  |  | 5 | 0 | 0 | *
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 870168d1716727080-is-there-a-way-to-simplify-this-formula-excel-help-with-formulas-aligw
Sheet: Results

Week Commencing | Contract | Contract % | Days Worked | Days Lost | Daily Average m3 | Reasons for Days Lost | Reasons for Days Lost | Contract Profit | Profit per Machine | Daily Average Profit | Contract Notes
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Week Number |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Spreadsheet: 29cfa88e-0be1-4ef2-9bd7-dbdc824f1403
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-05-17 09:16:58.430000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.212 | 101.087 | 100.962 | 100.587
4.625 | 100.395 | 100.27 | 100.145 | 99.77 |  | Note: | Refer To Price [NAME]
4.5 | 99.923 | 99.798 | 99.673 | 99.298 |  |  | For all Price Adjs
4.375 | 99.314 | 99.189 | 99.064
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.25 | 101.875 | 101.75 | 101.625 | 101.25
4.125 | 101.299 | 101.174 | 101.049 | 100.674
4 | 100.979 | 100.854 | 100.729 | 100.354
3.875 | 100.586 | 100.461 | 100.336 | 99.961
3.75 | 100.016 | 99.891 | 99.766
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-05-31 09:16:58.430000
30 DAY | 2011-06-15 09:16:58.430000
45 DAY | 2011-06-30 09:16:58.430000
60 DAY | 2011-07-15 09:16:58.430000
90 DAY | 2011-08-14 09:16:58.430000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 299446d1393191078-help-to-count-please-forum-question
Sheet: Sheet1

 | System | Priority | Status
 | AB | 1 | ok
 | AS | 2 | ok
 | SD | 2a | not ok |  |  |  | Number of "OK" Systems in Priority 1 ???
 | DS | 1 | ok
 | SD | 2 | not ok
 | DF | 2a | ok
 | FD | 1 | not ok
 | HJ | 2 | ok
 | UI | 2a | not ok
 | TY | 1 | not ok
 | BN | 2 | not ok
 | CF | 2a | ok
 | SE | 1 | not ok
 | AW | 2 | ok
 | ZQ | 2a | ok
 | MK | 1 | ok
 | LP | 2 | not ok
 | PY | 2a | ok
 | FU | 1 | not ok
 | EI | 2 | ok
 | NO | 2a | not ok
Spreadsheet: 689827d1596687286-randbetween-function-no-duplicates-in-specific-area-book1
Sheet: Sheet1

 |  |  | <= test if it is 1
 |  |  |  |  |  |  | CARD 1
 |  |  |  |  |  |  | CARD 2
 |  |  |  |  |  |  | CARD 3
Spreadsheet: 862254d1710000775-prevent-multiple-instances-of-incorrect-username-data-being-copied-reduced-list-no-repeats
Sheet: Trg Result

Employee Number | Emailaddress | Employee Name | User's Country | Registration Date | Last Login | Course Name | Completion Status | Completion Date | [NAME] | FirstName | Surname | Incorrect | Status |  | Date enrolled | Username Correct
g70030240 | [EMAIL]
g70030240 | [EMAIL]
g70030240 | [EMAIL]
guk7b3b | [EMAIL]
guk7b3b | [EMAIL]
guk7b3b | [EMAIL]
g70008526 | [EMAIL]
g70008526 | [EMAIL]
g70008526 | [EMAIL]
g70012650 | [EMAIL]
g70012650 | [EMAIL]
g70012650 | [EMAIL]
spurstat | [EMAIL]
spurstat | [EMAIL]
spurstat | [EMAIL]
g70012448 | [EMAIL]
g70012448 | [EMAIL]
g70012448 | [EMAIL]
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Chambersburg

 |  |  |  |  |  |  | 2013 Chambersburg
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Every other Tuesday. (opp. [NAME]) Schedule is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: phillip_m_love__30122__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 4/30/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Acme Brick Company | V67789.1 | F | NG | [NAME]
Black Stone Energy Company | V66594.1 | F | NG | [NAME]
Energy Partners, Ltd. | V67330.1/2 | F | WTI | [NAME]
Maverick Steel Enterprises Inc. | V57665.1/2/3/4/5/6 | F/P | SHRC | [NAME]
Mitsui & Co. (USA) Inc. | V54159.7/8 | F | SHRC | [NAME]
New Counterparty | V56821.1/2/3 | P/F | SCRC | [NAME]
New Counterparty | V66760.1/2 | P/F | NG | [NAME]
New Counterparty | V67892.1/2 | F | C2GC | Brant Reves
New Counterparty | V67941.1 | F | NG | [NAME]
New Counterparty | V67927.1 | P | ONP | [NAME]
Powell-Clinch Utility District | QY1215.3 | P | NG | [NAME]
Primagaz | V66761.1 | F | C3GC | Brant Reves
Steelsource International Corp | V67557.1/2/3/4/5 V67705.1/2/3/4 | F/P | SHRC | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Chase/Mahonia | V67581.1 | F | WTI | The Chase Manhattan Bank
Kinder Morgan Energy Parnters, LP | V67247.1 | F | NG | Kinder Morgan Inc.
National Fuel Resources, Inc. | V67077.1 | F | NG | National Fuel Marketing Company LLC
Texaco Energy Marketing L.P. | V67953.1 | F | [NAME] | Texaco Inc.
Spreadsheet: 769731d1645657984-help-finding-qty-at-a-specific-date-on-inventory-burndown-plan-inventory-excess-example
Sheet: Sheet1

Material | Inventory | Shop Deliveries | Total Inventory | Required Date | Required Qty | Allocation Window | Pegged Qty | Qty Remaining | Inventory
abc123 | 5 | 3 |  | 2022-02-28 00:00:00 | 2 | 2022-03-31 00:00:00
abc123 | 5 | 3 |  | 2022-04-15 00:00:00 | 6 | 2022-03-31 00:00:00
abc123 | 5 | 3 |  | 2022-05-31 00:00:00 | 3 | 2022-03-31 00:00:00
xyz345 | 9 | 2 | 21 | 2022-02-13 00:00:00 | 5 | 2022-03-31 00:00:00
xyz345 | 9 | 2 | 21 | 2022-02-14 00:00:00 | 2 | 2022-03-31 00:00:00
xyz345 | 9 | 2 | 21 | 2022-02-19 00:00:00 | 3 | 2022-03-31 00:00:00
xyz345 | 9 | 2 | 21 | 2022-04-30 00:00:00 | 2 | 2022-03-31 00:00:00
xyz345 | 9 | 2 | 21 | 2022-05-13 00:00:00 | 1 | 2022-03-31 00:00:00
qrs789 | 7 | 6 | 9 | 2022-02-27 00:00:00 | 3 | 2022-03-31 00:00:00
qrs789 | 7 | 6 | 9 | 2022-02-28 00:00:00 | 7 | 2022-03-31 00:00:00
qrs789 | 7 | 6 | 9 | 2022-04-01 00:00:00 | 5 | 2022-03-31 00:00:00
Spreadsheet: 269720d1381255829-one-column-to-auto-show-dollar-value-when-drop-down-selected-fseco-18-xxxx-di-asi-or-pco-
Sheet: Breakdown

LINE | [NAME] | QTY | UNIT(EA/FT) | ST LABOR UNIT | OT LABOR UNIT | PT LABOR UNIT | EQUIPMENT COST | MATERIAL COST | UNIT PRICE COST | EXTENDED EQUIPMENT COST | EXTENDED MATERIAL COST | EXTENDED UNIT PRICE COST | EXTENDED ST LABOR HOURS | EXTENDED OT LABOR HOURS | EXTENDED PT LABOR HOURS
#
1 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
2 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
19 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
20 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
21 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
24 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
25 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
26 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
27 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
28 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
29 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
30 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | EA
31 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | FT
32 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
33 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
34 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
35 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
36 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
37 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
38 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
39 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
40 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
41 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | Qualifications:
Spreadsheet: 870725d1717177759-add-a-row-before-a-group-of-values-latest-mubijazz-2-1-
Sheet: Sheet2

 | Region | Employee | Product |  |  | Regions | Title
 | Region-1 | EMP-1 | PRO-1 |  |  | Region-1 | East Region
 | Region-1 | EMP-2 | PRO-2 |  |  | [NAME] | East Region
 | Region-1 | EMP-3 | PRO-4 |  |  | Region-3 | North Region
 | Region-1 | EMP-4 | PRO-2 |  |  | Region-4 | Centeral Region
 | Region-1 | EMP-5 | PRO-1 |  |  | Region-5 | Centeral Region
 | Region-1 | [NAME] | PRO-2 |  |  | Region-6 | Centeral Region
 | [NAME] | EMP-1 | PRO-3 |  |  | [NAME] | West Region
 | [NAME] | EMP-2 | PRO-2
 | [NAME] | EMP-3 | PRO-3
 | [NAME] | EMP-4 | PRO-2
 | Region-3 | EMP-1 | PRO-3
 | Region-3 | EMP-2 | PRO-2
 | Region-3 | EMP-3 | PRO-3
 | Region-3 | EMP-4 | PRO-2
 | Region-4 | EMP-1 | PRO-3
 | Region-4 | EMP-2 | PRO-1
 | Region-4 | EMP-3 | PRO-3
 | Region-4 | EMP-4 | PRO-2
 | Region-5 | EMP-1 | PRO-1
 | Region-5 | EMP-2 | PRO-3
 | Region-5 | EMP-3 | PRO-3
 | Region-6 | EMP-1 | PRO-1
 | Region-6 | EMP-2 | PRO-3
 | Region-6 | EMP-3 | PRO-3
 | Region-6 | EMP-4 | PRO-1
 | Region-6 | EMP-5 | PRO-3
 | Region-6 | [NAME] | PRO-1
 | Region-6 | EMP-7 | PRO-3
 | Region-6 | EMP-8 | PRO-3
 | [NAME] | EMP-1 | PRO-1
Spreadsheet: 765375d1643296594-sum-if-cell-value-false-true-or-false
Sheet: Prev working day Quote (2)

 |  |  | 0
Total for the day:
 |  |  | Quote value
M | Inside sales | Quote info | USD
True | [NAME] | Don’t know | 265888
True | [NAME] | 1 | 7975
True | Felix | 2 | 2268 | the rows that says FALSE, I would like them
True | [NAME] | 3 | 2303 | as a sum on D1
True | [NAME] | 3 | 4261
True | [NAME] | 3 | 6069 | The cell with the FALSE changes from day to day
False | [NAME] | 3 | 2452 | so tomorrow it can be
True | [NAME] | 3 | 1826 | A12, A27 and then next day it can be 0 rows with FALSE
True | [NAME] | 3 | 4958
True | Felix | 4 | 10950
True | Felix | 4 | 1032
False | Felix | 4 | 10094
True | Felix | 4 | 1517
True | Felix | 4 | 850
True | Felix | 4 | 16304
True | Felix | 4 | 5419
True | Felix | 4 | 3117
False | [NAME] | 7 | 2188
True | [NAME] | 7 | 150
 | [NAME] | 7 | 543
 | [NAME] | 7 | 1807
 | [NAME] | 7 | 112
 | [NAME] | 7 | 3939
Spreadsheet: 790770d1659983951-return-row-value-with-reference-to-separate-worksheets-column-value-2022-08-08-oeldere-bishnu-adhikari-show-value-of-row-with-ref-to-column-value
Sheet: Result

ID# | Value1 | Value2 | Value3 | Report |  | ID# = | Show the row value of worksheet Source$A:$A has N
2326558 | 22.908 | 31.681 | 22.94 | Report |  | Value1 = | Show the row value of worksheet Source$A:$A has N
2326580 | 22.486 | 30.422 | 23.642 | Normal |  | Value2 = | Show the row value of worksheet Source$A:$A has N
 |  |  |  |  |  | Value3 = | Show the row value of worksheet Source$A:$A has N
 |  |  |  |  |  | Report = | Show the row value of worksheet Source$A:$A has N where if columns F, H and J has 'Normal' show 'Normal' else show <>'Normal'
Report | N
Rijlabels | Som van Value1 | Som van Value2 | Som van Value3
2326558 | 22.908 | 31.681 | 22.94
2326575 | 22.85 | 33.359 | 22.978
2326580 | 22.486 | 30.422 | 23.642
2326585 | 23.865 | 31.538 | 23.754
2326597 | 24.811 | 33.289 | 24.345
Eindtotaal | 116.92 | 160.289 | 117.659
Spreadsheet: dfb060ae-f775-4af5-88b1-4807ab3ecc57
Sheet: 2nd Qtr

Johnson & Johnson and Subsidiaries
Condensed Consolidated Statement of Earnings
(Unaudited; in Millions Except Per Share Figures) | SECOND QUARTER
 | 2011 |  |  |  | 2010 |  |  |  | Percent
 |  |  | Percent |  |  |  | Percent |  | Increase
 | Amount |  | to Sales |  | Amount |  | to Sales |  | (Decrease)
Sales to customers | 16597 |  | 100 |  | 15330 |  | 100 |  | 8.2648401826484
Cost of products sold | 5172 |  | 31.16225823944087 |  | 4630 |  | 30.20221787345075 |  | 11.70626349892009
Selling, marketing and administrative expenses | 5215 |  | 31.42134120624209 |  | 4756 |  | 31.02413568166993 |  | 9.650967199327166
Research and development expense | 1882 |  | 11.33939868650961 |  | 1648 |  | 10.7501630789302 |  | 14.19902912621359
Interest (income)expense, net | 111 |  | 0.668795565463638 |  | 58 |  | 0.3783431180691454
Other (income)expense, net | 206 |  | 1.341188166536121 |  | 18 |  | 0.1174168297455969
Restructuring expense | 589 |  | 3.548834126649394 |  | - |  | -
Earnings before provision for taxes on income | 3422 |  | 20.60818400915828 |  | 4220 |  | 27.52772341813438 |  | -18.90995260663507
Provision for taxes on income | 646 |  | 3.892269687292884 |  | 771 |  | 5.029354207436399 |  | -16.21271076523995
Net earnings | 2776 |  | 16.7259143218654 |  | 3449 |  | 22.49836921069798 |  | -19.51290229051899
Net earnings per share  (Diluted) | 1 |  |  |  | 1.23 |  |  |  | -18.69918699186992
Average shares outstanding  (Diluted) | 2781.3 |  |  |  | 2796
Effective tax rate | 18.87784921098773 | % |  |  | 18.27014218009479 | %
Adjusted earnings before provision for taxes and net earnings
Earnings before provision for taxes on income | 4413 | (1) | 26.58914261613545 |  | 4377 | (2) | 28.5518590998043 |  | 0.822481151473612
Net earnings | 3548 | (1) | 21.37735735373863 |  | 3382 | (2) | 22.06131767775603 |  | 4.908338261383797
Net earnings per share  (Diluted) | 1.28 | (1) |  |  | 1.21 | (2) |  |  | 5.785123966942153
Effective tax rate | 19.6 | % |  |  | 22.7 | %
(1) The $991 million difference between as reported earnings and as adjusted earnings before provision for taxes on income is the exclusion of expense due to  restructuring ($676 million, of which $589 million is reported as restructuring expense and $87 million is included in cost of products sold), expense due to litigation matters ($363 million), additional DePuy ASR™ Hip recall costs ($54 million) and a mark-to-market gain associated with a currency option related to the planned acquisition of Synthes ($102 million).  Net earnings and net earnings per share (diluted) on these items are $772 million and $0.28 per share, respectively.
(2) The difference between as reported and as adjusted earnings before provision for taxes on income, net earnings and net earnings per share (diluted) is the exclusion of net litigation expense of $157 million before tax, net litigation income of $67 million after tax and $0.02 per share, respectively.
Spreadsheet: 785563d1656496194-conditional-sum-by-multiple-complex-criteria-example
Sheet: List1

Main table |  |  |  |  |  |  |  |  |  | Cathegory |  |  |  | Cathegories
Person | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total for person by cathegory |  | Person | Cath. |  |  | A | B | C
Person 1 | 4 | 8 | 5 | 5 | 6 | 3 | 3 | 18 |  | Person 1 | A |  |  | 1 | 3 | 2
Person 2 | 4 | 6 | 5 | 4 | 3 | 4 | 5 |  |  | Person 2 | B |  |  | 2 | 5 | 3
Person 3 | 3 | 6 | 1 | 1 | 7 | 2 | 8 |  |  | Person 3 | A |  |  | 6 | 6 | 1
Person 4 | 7 | 8 | 8 | 2 | 4 | 9 | 2 |  |  | Person 4 | C |  |  | 7 | 7 | 6
Person 5 | 5 | 4 | 4 | 2 | 9 | 4 | 10 |  |  | Person 5 | B |  |  |  | 1 | 5
Person 6 | 9 | 10 | 4 | 10 | 8 | 3 | 3 |  |  | Person 6 | A |  |  |  |  | 4
Person 7 | 3 | 10 | 3 | 4 | 5 | 8 | 3 |  |  | Person 7 | C
Person 8 | 7 | 9 | 9 | 3 | 3 | 4 | 4 |  |  | Person 8 | B
Person 9 | 10 | 5 | 5 | 6 | 7 | 8 | 6 |  |  | Person 9 | C
Person 10 | 5 | 6 | 9 | 5 | 7 | 6 | 2 |  |  | Person 10 | A