tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677546d1589392098-determine-if-any-dates-in-range-of-cells-meet-the-criteria-calc-date-example
Sheet: Sheet1

 | Admit Date | Discharge Date | (helper) How many Appointments |  | Are any within 3 days? | Are any within 7 days? | Appointment Date 1 | Appointment Date 2 | Appointment Date 3 | Appointment Date 4 | Appointment Date 5
Patient A | 2019-12-31 17:10:07 | 2020-01-01 06:22:00 | 4 |  | no | yes | 2020-01-07 00:00:00 | 2020-02-15 00:00:00 | 2020-03-12 00:00:00 | 2020-03-25 00:00:00
Patient B | 2019-12-31 22:09:00 | 2020-01-01 04:26:00 | 4 |  | yes | no | 2020-01-23 00:00:00 | 2020-01-28 00:00:00 | 2020-02-28 00:00:00 | 2020-01-06 00:00:00
Patient C | 2019-12-31 22:46:00 | 2020-01-01 00:02:00 | 0 |  | no | no
Patient D | 2019-12-31 22:58:00 | 2020-01-01 02:14:00 | 1 |  | no | yes | 2020-01-06 12:26:21
Patient E | 2019-12-31 23:41:00 | 2020-01-01 01:06:00 | 1 |  | yes | yes | 2020-01-02 00:00:00
Patient F | 2019-12-31 23:45:00 | 2020-01-01 03:09:00 | 3 |  | yes | no | 2020-02-07 00:00:00 | 2020-03-05 00:00:00 | 2020-01-06 12:43:09
Patient GA | 2019-12-31 23:46:17 | 2020-01-01 02:42:00 | 0 |  | no | no
Patient H | 2019-12-31 23:48:36 | 2020-01-01 07:23:00 | 0 |  | no | no
Patient I | 2020-01-01 00:56:58 | 2020-01-01 04:38:00 | 0 |  | no | no
Patient J | 2020-01-01 01:12:00 | 2020-01-01 02:52:00 | 0 |  | no | no
Patient K | 2020-01-01 01:48:00 | 2020-01-01 03:35:00 | 1 |  | no | yes | 2020-01-07 00:00:00
Patient L | 2020-01-01 02:22:25 | 2020-01-01 05:29:00 | 0 |  | no | no
Patient M | 2020-01-01 02:24:55 | 2020-01-01 07:05:00 | 0 |  | no | no
Patient N | 2020-01-01 04:36:00 | 2020-01-01 06:51:00 | 0 |  | no | no
Patient O | 2020-01-01 05:13:15 | 2020-01-01 08:11:00 | 0 |  | no | no
Patient P | 2020-01-01 07:47:22 | 2020-01-01 08:24:00 | 5 |  | yes | yes | 2020-01-03 00:00:00 | 2020-01-22 00:00:00 | 2020-01-31 00:00:00 | 2020-02-13 00:00:00 | 2020-03-04 00:00:00
Spreadsheet: 293516d1391011027-give-a-estimate-based-on-a-result-group-by-range
Sheet: Sheet1

PerCent |  |  |  |  |  | PerCent | Lookup |  |  | VL Table
97 |  |  |  |  |  | 97 |  | [NAME] |  | 0 | 0-10
47 |  |  | [NAME] |  |  | 47 |  |  |  | 10 | 1-10
1 |  |  |  |  |  | 1 |  |  |  | 20 | 10-20
84 |  |  |  |  |  | 84 |  |  |  | 30 | 20-30
91 |  |  | Row Labels | Count of PerCent |  | 91 |  |  |  | 40 | 30-40
92 |  |  | 1-10 | 6 |  | 92 |  |  |  | 50 | 40-50
38 |  |  | 11-20 | 5 |  | 38 |  |  |  | 60 | 50-60
59 |  |  | 21-30 | 11 |  | 59 |  |  |  | 70 | 60-70
12 |  |  | 31-40 | 5 |  | 12 |  |  |  | 80 | 70-80
25 |  |  | 41-50 | 9 |  | 25 |  |  |  | 90 | 80-90
29 |  |  | 51-60 | 4 |  | 29 |  |  |  | 100 | 90-100
36 |  |  | 61-70 | 7 |  | 36
41 |  |  | 71-80 | 10 |  | 41
74 |  |  | 81-90 | 10 |  | 74
98 |  |  | 91-100 | 8 |  | 98
32 |  |  | Grand Total | 75 |  | 32
90 |  |  |  |  |  | 90
42 |  |  |  |  |  | 42
93 |  |  |  |  |  | 93
84 |  |  |  |  |  | 84
76 |  |  |  |  |  | 76
72 |  |  |  |  |  | 72
30 |  |  |  |  |  | 30
77 |  |  |  |  |  | 77
56 |  |  |  |  |  | 56
26 |  |  |  |  |  | 26
82 |  |  |  |  |  | 82
29 |  |  |  |  |  | 29
90 |  |  |  |  |  | 90
45 |  |  |  |  |  | 45
10 |  |  |  |  |  | 10
5 |  |  |  |  |  | 5
82 |  |  |  |  |  | 82
44 |  |  |  |  |  | 44
26 |  |  |  |  |  | 26
47 |  |  |  |  |  | 47
24 |  |  |  |  |  | 24
95 |  |  |  |  |  | 95
28 |  |  |  |  |  | 28
67 |  |  |  |  |  | 67
29 |  |  |  |  |  | 29
50 |  |  |  |  |  | 50
20 |  |  |  |  |  | 20
47 |  |  |  |  |  | 47
74 |  |  |  |  |  | 74
69 |  |  |  |  |  | 69
93 |  |  |  |  |  | 93
76 |  |  |  |  |  | 76
43 |  |  |  |  |  | 43
85 |  |  |  |  |  | 85
13 |  |  |  |  |  | 13
37 |  |  |  |  |  | 37
63 |  |  |  |  |  | 63
70 |  |  |  |  |  | 70
67 |  |  |  |  |  | 67
75 |  |  |  |  |  | 75
79 |  |  |  |  |  | 79
6 |  |  |  |  |  | 6
20 |  |  |  |  |  | 20
71 |  |  |  |  |  | 71
67 |  |  |  |  |  | 67
11 |  |  |  |  |  | 11
21 |  |  |  |  |  | 21
89 |  |  |  |  |  | 89
21 |  |  |  |  |  | 21
97 |  |  |  |  |  | 97
58 |  |  |  |  |  | 58
5 |  |  |  |  |  | 5
39 |  |  |  |  |  | 39
62 |  |  |  |  |  | 62
71 |  |  |  |  |  | 71
83 |  |  |  |  |  | 83
10 |  |  |  |  |  | 10
55 |  |  |  |  |  | 55
81 |  |  |  |  |  | 81
Spreadsheet: 0ad907d6-42cf-4162-b265-e0b61ce844e0
Sheet: Sheet1

Unnamed: 0 | MJ SUMMER 2013 SCHEDULE | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
TRACKS |  | SUBJ | NO | SEC | CREDITS | PROFESSOR
ALL - HLTH OR CORP | ADMINISTRATIVE LAW | MJ | 726 | 0 | 2 | ROTTURA
YR 2 ONLY   HLTH OR CORP | EXTERNSHIP | MJ | 929 | 0 | 2--3 | GRENA
ALL - HLTH OR CORP | HEALTHCARE ADMINISTRATION | MJ | 6067X | 0 | 2 | GRENA
ENTERING STUDENTS ONLY | MJ INTRODUCTION TO LAW | MJ | 500 | 0 | 2 | GRENA/KROH
ALL - HLTH OR CORP | WORKPLACE INVESTIGATION & REPORT WRITING | MJ | 727 | 0 | 2 | O'NEILL
Spreadsheet: sara_shackleton__36447__MorganSTanVapSev ISDA
Sheet: ms

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER:
COUNTERPARTY: | Morgan Stanley Capital Services Inc. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) | Morgan Stanley Dean Witter & Co. | Enron Corp
LIMIT $ MILLIONS | 25 | 25
Incorporation State |  | OR
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | 15 | 15
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit | X | X
MINIMUM TRANSFER $ | 250000
COLLATERAL ROUNDING
Delivery Amount | 250000
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable | delete non-specific MAC in exeisting contract.
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change
-Below = S&P/Moody's | BBB- | BBB-
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 100
-Guarantor ($[NAME]) |  | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS: | Use current set-off language.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-3559
Spreadsheet: 829536d1684301799-return-data-from-one-table-to-another-table-based-on-dates-entered-and-summing-duplicates-book1-146-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  | Table2 Data Manually Entered
 |  |  |  |  |  |  |  | Name | Date | Week # | Year | Data1 | Data2 | Data3
Date: | 2023-01-10 00:00:00 | <-- Enter Date  (Use 1/1/23 or 1/10/23 for this example) |  |  |  |  |  | [NAME] | 2023-01-01 00:00:00 |  |  | 10 | 20 | 30
Week #: |  |  |  |  |  |  |  | [NAME] | 2023-01-05 00:00:00 |  |  | 5 | 25 | 20
Year: | 2023 | <-- Or enter Year (Enter 2023 and Totals are not working) |  |  |  |  |  | [NAME] | 2023-01-10 00:00:00 |  |  | 5 | 15 | 35
 |  |  |  |  |  |  |  | [NAME] | 2023-01-12 00:00:00 |  |  | 15 | 20 | 25
 |  |  |  |  |  |  |  | [NAME] | 2023-01-12 00:00:00 |  |  | 10 | 20 | 35
Table1 to Return Data from Table2 Based on "Date" Entered in B2
Name | Data1 | Data2 | Data3 |  | Name | Data1 | Data2 | Data3
 |  |  |  |  |  | 15 | 35 | 65
 |  |  |  |  | [NAME] | 15 | 45 | 55
 |  |  |  |  | [NAME] | 15 | 35 | 65
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74031

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 408 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20734 |  | Asset Binder |  |  |  |  |  | Z0074031
 |  | Lewis Petro Properties/Segundo Navarro |  |  |  | 01/01/96 | 01/01/97
 |  | Forman Petroleum Corp |  |  |  | 01/01/96 | 12/21/96
 |  | ECT Gain on Sale of Coda Efftv.11/26/97 |  |  |  | 11/01/97 | 11/30/97
 |  | Grand Gulf Production Folder |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: 100766d1299014553-limited-if-then-statement-bonus-test
Sheet: Sheet1

WEIGHT GAIN |  | 228306 |  |  |  |  |  | WEIGHT GAIN |  | 328306
FEED LBS. |  | 728672.5 |  |  |  |  |  | FEED LBS. |  | 728672.5
FEED EFFICIENCY |  |  |  |  |  |  |  | FEED EFFICIENCY
AVG. CONV. |  | 2.903 |  |  |  |  |  | AVG. CONV. |  | 2.903
DIFFERENCE |  |  |  |  |  |  |  | DIFFERENCE
1500 | X | 0 | = |  |  |  |  | 1500 | X | 0 | =
TOTAL FEED EFFICIENCY BONUS |  |  |  |  |  |  |  | TOTAL FEED EFFICIENCY BONUS
Spreadsheet: jim_schwieger__14301__Bronco Playoff Schedule
Sheet: Sheet1

Bronco Maroon [NAME]
Monday 5/14 | Friday 5/18 | Monday 5/21
#1 Braves-Labay
WLY#5 @ 8:00pm | #1 Braves-Labay
#8 Marlins-Bleyl |  | Winner of Round 2
 | Friday 5/18
 | BC#2 @ 8:00pm
#5 Cardinals-Hamilton
5/16 Wednesday | Winner of 4 vs. 5
BC#2 @ 8:00pm
#4 A's-Hamilton |  | Monday 5/21
 |  | WLY#5 @ 7:00am
Game #1217
#3 Reds-Cook
5/16 Wednesday | Winner of 3 vs.6
WLY#5 @ 6:00pm
#6 Dodgers-Truitt
 | Friday 5/18
 | BC#2 @ 6:00pm | Winner of Round 2
#7 Astros-Campbell
5/16 Wednesday | Winner of 2 vs. 7
BC#2 @ 6:00pm
#2 Angels-Arnold
Spreadsheet: errol_mclaughlin_jr__10076__Bkrqs854
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request # 854
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
JL-RESID-SPEC | JL-RESID-SPEC | X |  |  | &H | DESK | X |  |  |  |  |  | 61GC/BBL/USD | [NAME] | MTM | [NAME] | ASAP
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JV
emclaug |  |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JV
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JV
kloibl |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JV
ghuan |  |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JV
 |  |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
 |  |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact :
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x57197)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x31462)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ([NAME])
Spreadsheet: 146072d1331889111-sales-report-analysis-__salesanalysis
Sheet: Sheet1

Order # | Customer | Item Type | Weight | Amount
4784654 | Customer A | Group 1 | 4523 | 700
4731897 | Customer B | Group 2 | 6533 | 433
6577942 | Customer C | Group3 | 56 | 856
8795431 | Customer D | Group 1 | 63 | 8344
3249642 | Customer A | Group 2 | 632 | 733
4157985 | Customer B | Group3 | 6223 | 7333
4587469 | Customer C | Group 1 | 6341 | 734
9854331 | Customer D | Group 2 | 633 | 7321
4784654 | Customer A | Group 1 | 4523 | 700
6577942 | Customer C | Group3 | 56 | 856
4587469 | Customer C | Group 1 | 6341 | 734
 |  | Data
Order # | Item Type | Count of Order # | Sum of Weight | Sum of Amount
3249642 | Group 2 | 1 | 632 | 733
4157985 | Group3 | 1 | 6223 | 7333
4587469 | Group 1 | 2 | 12682 | 1468
4731897 | Group 2 | 1 | 6533 | 433
4784654 | Group 1 | 2 | 9046 | 1400
6577942 | Group3 | 2 | 112 | 1712
8795431 | Group 1 | 1 | 63 | 8344
9854331 | Group 2 | 1 | 633 | 7321
Grand Total |  | 11 | 35924 | 28744
Spreadsheet: 7b9233d8-6b1f-4465-b856-b19672f0411a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 80. Value of Building Approved, Chain Volume Measures, Original - Victoria
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  Houses ;  New ; |  |  | Original | A590487F | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  Total Other Residential ;  New ; |  |  | Original | A590488J | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME] ;  New ; |  |  | Original | A590489K | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME] ;  Alterations and additions including conversions ; |  |  | Original | A590490V | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME] ;  Total Work ; |  |  | Original | A590491W | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME]-residential ;  Total Work ; |  |  | Original | A590492X | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  Total (Type of Building) ;  Total Work ; |  |  | Original | A590493A | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: jeffrey_a_shankman__13966__MgmtSum-Q401-Global-102601
Sheet: YTD Mgmt Summary

ENRON GLOBAL MARKETS
2001 EARNINGS ESTIMATE
4th QUARTER YTD
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Crude & Products
Coal / Emissions
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Middle East (1Q01 only)
Puerto Rico
Japan
Drift
Finance and Structuring
Office of the Chairman
Overview
Total Commercial
Group Cost
Support Cost Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income)
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes direct and allocated expenses
Spreadsheet: 0810f74b-3210-4bdc-b47f-ce02ed9a7c25
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 26. Output of the Public administration and safety industries, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  7712  Investigation and security services ; |  |  | Original | A2314256X | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 39985d1238261023-excel-2007-organizing-and-transposing-data-in-excel-sheet-result
Sheet: Sheet1

NAME | [NAME] |  |  | NAME | ADDRESS | PHONE
ADDRESS | 110 MAIN ST |  |  | [NAME] | 110 MAIN ST | [PHONE]
PHONE | [PHONE] |  |  | [NAME] | 215 BROADWAY | [PHONE]
 |  |  |  | [NAME] | 615 BLVD | [PHONE]
ADDRESS | 215 BROADWAY
NAME | [NAME]
PHONE | [PHONE]
PHONE | [PHONE]
NAME | [NAME]
ADDRESS | 615 BLVD
Spreadsheet: 828028d1683197120-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-o-number-1-
Sheet: Hoja1

your table |  |  |  |  |  | your costs |  |  | just for checking (is not necessary for the solution)
TRACKID | Products | Cost | Shipping Cost | TOTAL |  | TrackID | cost |  |  | Waarden
TBA001 | Product A | 19.99 |  |  |  | TBA001 | 14.6 |  | TRACKID | sum | count
TBA001 | Product B | 19.99 |  |  |  | TBA002 | 5.2 |  | TBA001 | 14.6 | 9
TBA001 | Product C | 160.99 |  |  |  | TBA003 | 2.85 |  | TBA002 | 5.199999999999999 | 3
TBA001 | Product D | 160.99 |  |  |  |  |  |  | TBA003 | 2.85 | 2
TBA001 | Product E | 12.95 |  |  |  |  |  |  | Eindtotaal | 22.65000000000001 | 14
TBA001 | Product F | 12.95
TBA001 | Product G | 7.99
TBA001 | Product H | 10.99
TBA001 | Product I | 24.99
TBA002 | [NAME] | 36.99
TBA002 | Product L | 27.99
TBA002 | Product M | 3.99
TBA003 | Product N | 47.99
TBA003 | Product O | 76.99
Spreadsheet: 596004d1540906254-if-and-using-vlookup-from-another-tab-using-table-but-if-over-roundup-to-next-cell-med-gas-branch-pipe-sizing-test-autosaved-
Sheet: Medical Oxygen 

MEDICAL OXYGEN LINE SIZING (10 LPM PER OUTLET) |  |  |  |  |  |  |  |  | OXYGEN PRESSURE DROP
START | END | RUN (FEET) | FLOW (LPM) | PIPE SIZE | LOSS PER 100' | LOSS | RUNNING SUB TOTAL
 |  |  |  |  |  |  |  |  | FLOW |  | NOMINAL PIPE SIZE
A | B | 25 | 30 | 1/2" |  |  |  |  | LPM | SCFM | 1/2" | 3/4" | 1" | 1-1/4" | 1-1/2" | 2" | 2-1/2" | 3" | 4"
B | C | 16 | 60 | 1/2" |  |  |  |  | 3060
C | D | 17 | 90 | 1/2"
D | E | 19 | 120 | 1/2"
E | F | 16 | 150 | 1/2" |  |  |  |  | System Totals
F | G | 16 | 180 | 1/2" |  |  |  |  | [NAME] | LPM Per Section |  | Pressure [NAME] (PSIG/100 FT) |  |  |  | Equivalent (LF) |  | Pressure Drop
G | H | 16 | 210 | 1/2" |  |  |  |  | 4"
H | I | 16 | 240 | 1/2" |  |  |  |  | 3" |  |  |  |  |  |  | 35
I | J | 16 | 270 | 3/4" |  |  |  |  | 2 1/2"
J | K | 10 | 300 | 3/4" |  |  |  |  | 2" |  |  |  |  |  |  | 46
K | L | 138 | 600 | 1" |  |  |  |  | 1 1/2" |  |  |  |  |  |  | 24
L | M | 15 | 1020 | 1" |  |  |  |  | 1 1/4" | 3500 |  |  |  |  |  | 173
M | N | 15 | 2040 | 2" |  |  |  |  | 1" | 3501
N | O | 15 | 3060 | 2" |  |  |  |  | 3/4" |  |  |  |  |  |  | 113
O | P | 15 | 3790 | 2" |  |  |  |  | 1/2" | 180 |  |  |  |  |  | 97
P | Q | 25 | 4780 | 2" |  |  |  |  | Total Maximum System Loss Per 100' = |  |  |  |  |  | System Total Pressure Drop
 |  |  |  |  |  |  |  |  | Place your flow rate for the overall zone of pipe you are sizing up top, then place the flow rate for the section you are sizing and the length of that section in the middle. |  |  |  |  |  | LENGTH OF LONGEST RUN |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADD FOR FITTING  LOSS |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL EQUIVALENT LENGTH |  |  |  | LF
Spreadsheet: 135833d1326267433-excel-2007-by-selecting-a-month-in-a-cell-want-to-list-out-full-dates-in-the-subsequent-cells-book1
Sheet: Sheet1

Month |  |  | February
Period Start Date |  |  | 2012-02-01 00:00:00
Date | Day
Total
Spreadsheet: 1f1d1560-0c9e-4531-be8d-934fd864dac3
Sheet: DistrictsMidJrHigh

 |  |  |  |  |  | Middle School
District | Bullying | Alcohol | Tobacco | Other Drugs | Distribution | Assaults | [NAME] | Handgun | Rifle | Other Firearm | Other Weapon | Total
Alpine | 118 | 2 | 15 | 62 | 12 | 36 | - | - | - | 6 | 26
Beaver | - | - | - | - | - | - | - | - | - | - | -
[NAME] | 1 | - | 8 | 5 | - | 4 | 1 | - | - | - | 3
Cache | 28 | 1 | 2 | 9 | - | 17 | 2 | - | - | - | 1
Canyons | 3- | 4 | 11 | 37 | 11 | 23 | - | - | - | 6 | 16
Carbon | - | - | - | - | - | - | - | - | - | - | -
Daggett | - | - | - | - | - | - | - | - | - | - | -
[NAME] | 24 | 14 | 49 | 6- | - | 36 | - | - | - | 5 | 14
Duchesne | 1 | - | 2 | 1 | - | 1 | - | - | - | - | 1
Emery | - | - | - | - | - | - | - | - | - | - | -
[NAME] | - | - | - | - | - | - | - | - | - | - | -
Grand | - | - | - | - | - | - | - | - | - | - | -
Granite | 54 | 31 | 21 | 151 | 7 | 121 | - | 1 | - | 1 | 5-
Iron | 6 | 1 | 1 | 1 | - | 14 | - | - | - | - | 1
Jordan | 48 | 1 | 9 | 4- | 16 | 22 | - | - | - | - | -
[NAME] | - | - | - | - | - | - | - | - | - | - | -
[NAME] | - | - | - | - | - | - | - | - | - | - | -
Logan | - | - | - | - | - | 2 | - | - | - | - | 1
Millard | - | - | - | - | - | 5 | - | - | - | - | -
Morgan | 1 | - | - | 1 | - | - | - | - | - | - | -
[NAME] | 1- | 2 | 3 | 9 | - | 4 | - | - | - | 2 | 5
Nebo | 19 | 1- | 17 | 12 | 3 | 32 | 4 | - | - | 2 | 18
[NAME] | 4 | - | - | - | - | 12 | - | - | - | 1 | 1
North Summit | - | - | - | - | - | - | - | - | - | - | -
Ogden | 4 | 1 | 5 | 14 | 1 | 13 | - | 1 | - | - | 4
Park City | 2 | - | 1 | 8 | - | 2 | - | - | - | - | 2
Piute | - | - | - | - | - | - | - | - | - | - | -
Provo | - | - | 1 | 8 | 3 | 7 | - | - | - | - | 1
Rich | - | - | - | - | - | - | - | - | - | - | -
[NAME] | 4 | - | - | 15 | 3 | 14 | - | 1 | - | - | 1
San Juan | - | - | - | - | 1 | 5 | - | - | - | - | 2
Sevier | - | - | - | 7 | - | - | - | - | - | - | -
South Sanpete | - | - | - | - | - | 1 | - | - | - | 1 | -
South Summit | - | - | 1 | - | - | - | - | - | - | - | -
Tintic | - | - | - | - | - | - | - | - | - | - | -
Tooele | - | - | - | 1 | - | 6 | - | - | - | - | 2
Uintah | - | 1 | - | 5 | - | 4 | 1 | - | - | - | 3
Wasatch | 4 | - | 3 | - | - | 1 | - | - | - | - | -
Washington | - | - | - | 5 | - | - | - | - | - | - | 3
Wayne | 9 | 1 | - | - | - | - | - | - | - | - | -
Weber | 12 | 3 | 44 | 27 | - | 32 | 4 | - | - | 12 | 32
District School Totals
Spreadsheet: 776299d1649681561-sorting-data-by-specific-name-into-different-sheets-test-worksheet
Sheet: Sheet1

 |  | Company Name | Date | Cost
 |  | Company A | 2022-04-02 00:00:00 | 15
 |  | Company B | 2022-04-04 00:00:00 | 10
 |  | Company A | 2022-04-02 00:00:00 | 22
 |  | Company C | 2022-04-08 00:00:00 | 19
 |  | Company A | 2022-04-08 00:00:00 | 10
 |  | Company A | 2022-04-10 00:00:00 | 22
 |  | Company B | 2022-04-02 00:00:00 | 5
 |  | Company C | 2022-04-08 00:00:00 | 7
 |  | Company A | 2022-04-10 00:00:00 | 29
 |  | Company B | 2022-04-04 00:00:00 | 14
 |  | Company B | 2022-04-04 00:00:00 | 12
 |  | Company C | 2022-04-02 00:00:00 | 20
Spreadsheet: 769794d1645688484-array-formula-for-multiple-savings-multiply
Sheet: Sheet1

 | Startvalue | 100
 | 1 |  | 2 |  | array formula for this yellow area needed.
 | 2 |  | 2
 | 3 |  | 2 |  |  | 100 | My try, start value is fixed
 |  |  |  |  |  | 98
 |  |  |  |  |  | 98