tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 765024d1643126479-formula-to-give-me-the-percent-value-when-my-outcome-cell-falls-between-a-range-of-scores-test-hellp
Sheet: Sheet1

Score Listing |  |  |  |  |  |  |  | 25000 | 0
Item 1 |  | 5856 |  |  |  |  |  | 30000 | 0.25
Item 2 |  |  |  |  |  |  |  | 40000 | 0.5
Item 3 |  |  |  |  |  |  |  | 50000 | 0.75
Item 4 |  | 5187 | 660 |  |  |  |  | 55000 | 1
Item 5 |  | 3142
Score Total |  | 32000
Percentage Total
Spreadsheet: 374e9161-3e8c-483b-bc60-fc034330a7f9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | FIRE  PROTECTION  SYSTEM  MODIFICATION  PERMIT  LOG | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Form Number/Rev # CFM-00009-F2 R1 | Unnamed: 13 | Unnamed: 14
FIRE  PROTECTION  SYSTEM  MODIFICATION  PERMIT  LOG
Permit No. | Date Permit Opened | Bldg. | [NAME]. Zone # | Work Type | Work Description | Owner | Part 1 | Part 2 |  |  |  |  | Date Permit Closed | Notes
 |  |  |  |  |  |  | Design Review Complete | Insp/Test Reports Accepted | Fire Alarm Program Updated | Fire Alarm Graphics Updated | Contractor As-builts Accepted | Facility As-builts Updated
29 | 2010-10-29 00:00:00 | NFE |  |  | False fire alarms |  |  | 1 hour |  |  |  | MWG | 2010-11-19 00:00:00 | repeat of item #2. Closure with item #2.
30 | 2010-11-09 00:00:00 | NFN |  |  | Exhaust flucutations |  |  | 10 minutes |  |  |  | P. O'Dea | 2010-12-10 00:00:00 | Replace cogged pulleys and belts when parts are available.  Stock cogged pulleys. Fans to be taken off line 'manually' in the future.
31 | 2010-11-22 00:00:00 | NFC |  |  | Damage trestle pipe |  |  | ? |  |  |  | MWG | 2010-12-28 00:00:00 | Piping repaired and transition made on 1-10-11.                                 1) Follow written procedures for system start up. Do not deviate without input from others.                    2) Verify operation/position of control valves during design verification.
32 | 2010-11-22 00:00:00 | NFN |  |  | Extended DIW system down time due to control wiring issues |  |  | 1 hr. vs. 5 hrs. |  |  |  | MWG | 2010-12-17 00:00:00 | 1) Verify wire labeling performed.   2) Improve communication between CM & subs.
33 | 2010-11-22 00:00:00 | NFN |  |  | High dissolved O2 levels |  |  | 2 hrs. vs. 15 hrs. |  |  |  | [NAME] | 2010-11-23 00:00:00 | Prolonged DO levels likely due to air trapped in system. Bleed or verify no trapped air in the future.
 |  |  |  | Printed copies are considered uncontrolled.  Verify revision prior to use.
DCN0703 |  |  |  | CNSE Confidential When Completed |  |  |  |  |  |  |  | Page 1 of 1
Spreadsheet: 075f7585-c0f4-4f0b-80e3-0007768e6405
Sheet: Sheet1

Summer Slam | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
14 & Under
#2 C. Flames   4
 | Warriors               1
8:30    (1
Field 3
#3 Warriors   14 | 10:00:00
 | Field 3      (2 | Rascals  7
 | #1 Rascals      7
 |  | 02:30:00
 |  | Field 3
 |  | (4 | Rascals
Loser's | Bracket
 | L-1 Flames      6 |  | "IF" Game
 |  |  | 04:00:00
 | 11:30:00 |  | Field 3
 | Field 3        (3 | Flames 0 | (5
 |  |  |  | 1st Place
 | L2 Warriors   4
 |  |  | L-4
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Northeast

 | Northeast Power Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  | 138000
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  | 0 |  |  |  | Sr. Specialist | 78000 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 4
 |  |  |  |  |  |  |  |  | Director | 156000 | 1
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 1
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 769497d1645561026-if-or-statement-with-multiple-criteria-if-or-statement-issue-type
Sheet: Sheet1

Week # | Issue Type | Category | New Issue Type | Priority |  |  |  |  |  |  | New Issue Type | Class
1 | Issue | Patch |  |  |  |  |  |  |  |  | Issue | High
1 | Idea | Enhancement |  |  |  |  |  |  |  |  | New Feature | Low
2 | Idea |  |  |  |  |  |  |  |  |  | Bug | High
3 | Issue | Patch |  |  |  |  |  |  |  |  | Idea | Low
3 | Idea | Enhancement
4 | Bug
4 | Bug
Expectation
Week # | Issue Type | Category | New Issue Type | Priority
1 | Issue | Patch |  | High
1 | Idea | Enhancement |  | Low
2 | Idea |  |  | Low
3 | Issue | Patch |  | High
3 | Idea | Enhancement |  | Low
4 | Bug |  |  | High
4 | Bug |  |  | High
Spreadsheet: 329388d1404298193-formula-for-calculating-sla-sla
Sheet: Master Sheet

Incident ID | Category | Type | Priority | Employee # Location | Status | Summary | Workgroup | Owner [NAME] | Restoration Goal Achieved | Registered DT | Restored | Pending Closed DT | Classification | SLA | SLA MET (Yes/No)
PM778763 | Incident | Secondary Incident | 4 | Building 1 | Closed | Outlook | techical support | Jhon | True | 2014-06-05 01:58:24 | 2014-06-05 02:17:04 | 2014-06-05 02:17:04
PM778764 | Incident | Standard Incident | 4 | Building 2 | Closed | Power issue | techical support | Jhon | False | 2014-06-17 09:34:20
PM778765 | Incident | Standard Incident | 5 | Building 1 | Pending Closed | internet | techical support | Jhon | True | 2014-06-24 15:24:27 | 2014-06-24 15:45:16 | 2014-06-24 15:45:16
PM778766 | Incident | Standard Incident | 3 | Building 1 | Pending Closed | Outlook | techical support | Jhon | True | 2014-06-25 02:49:20 | 2014-06-25 09:30:04 | 2014-06-25 09:30:04
PM778767 | Incident | Standard Incident | 3 | Building 1 | Closed | Power issue | techical support | Bing | True | 2014-05-01 22:06:53 | 2014-05-02 00:28:00 | 2014-05-02 00:28:00
PM778768 | Incident | Standard Incident | 5 | Building 2 | Closed | internet | techical support | Bing | True | 2014-05-02 00:35:22 | 2014-05-12 01:31:17 | 2014-05-02 01:31:17
PM778769 | Incident | Standard Incident | 4 | Building 2 | Closed | Excel | techical support | Bing | True | 2014-05-02 00:55:17 | 2014-05-02 01:42:05 | 2014-05-02 01:42:05
PM778770 | Incident | Standard Incident | 3 | Building 1 | Closed | internet | techical support | Bing | True | 2014-05-02 01:01:49 | 2014-05-02 02:30:17 | 2014-05-02 02:30:17
Spreadsheet: 271308d1381907074-sort-numbers-and-drag-across-corresponding-column-text-book3
Sheet: Sheet1

 |  | [NAME] | 15 |  | [NAME] | 6000
 |  | [NAME] | 0 |  | [NAME] | 799
 |  | [NAME] | 54 |  | [NAME] | 333
 |  | [NAME] | 6000 |  | Shawn | 202
 |  | Brett | 81 |  | [NAME] | 91
 |  | [NAME] | 0 |  | Brett | 81
 |  | [NAME] | 6 |  | [NAME] | 63
 |  | [NAME] | 4 |  | [NAME] | 54
 |  | [NAME] | 333 |  | [NAME] | 15
 |  | [NAME] | 91 |  | [NAME] | 6
 |  | Shawn | 202 |  | [NAME] | 4
 |  | [NAME] | 0 |  | Leigh | 4
 |  | Leigh | 4 |  | [NAME] | 0
 |  | [NAME] | 63 |  | [NAME] | 0
 |  | [NAME] | 799 |  | [NAME] | 0
Spreadsheet: 0d269de5-5f16-4c25-a9e4-2b902fb9876e
Sheet: Sheet1

CU Proposal No. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Internal | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  | PROPOSED MODULAR BUDGET
Institution: |  |  |  | The Regents of the |  | Title:
 |  |  |  | University of Colorado
 |  |  |  | 572 UCB
 |  |  |  | Boulder, CO 80309-0572
Principal Investigator: |  |  |  |  |  | Duration:
 |  |  |  |  |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Total
A. | Total Direct Costs
 | Total Direct Costs*  (excluding Subrecipient Indirect Costs) |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
B. | Subrecipient Indirect Costs
 |  | Institution A |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Institution B |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Subrecipient Indirect Costs |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
C. | IDC Exempt Direct Costs
 | Equipment |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Subrecipient Direct Costs |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Tuition Remission |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Long-term [NAME] |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total IDC Exempt Direct Costs |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
D. | Total Direct Costs for CU Purposes |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
E. | Modified Total Direct Costs**
 | Total Direct Costs less excluded costs, first $25,000 of each sub |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
F. | Indirect Costs
 | On Campus:  52.5% of MTDC predetermined for the period
 | 7/1/12 - 6/30/13;  provisional  52.5% thereafter
 | per HHS agreeement dated 8/29/13. |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
G. | Total Costs |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Requested for Five Years: |  |  |  |  | 0
* Provide total of all direct costs, excluding any subrecipient indirect costs, in modules of $25,000, up to $250,000.
** Modified total direct costs equals total direct costs less any items in "C. IDC Exempt Direct Costs" plus
 | the addition of the first $25,000 of each subreceipient. (If the amount for the subrecipient is less than
 | $25,000, do not exempt any of that subrecipient's direct or indirect costs.)
Spreadsheet: 689228d1596199421-if-and-vlookup-in-a-dropdown-if-and-vlookup-in-a-dropdown
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Competency
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | Input a value
 |  | Pre-defined Roles | Competency |  |  |  |  |  |  |  |  |  |  | SE | C1/C2
 |  | NA |  | When col C is NA, then  a drop down should open picking values from Col P else vlookup as below |  |  |  |  |  |  |  |  |  | [NAME] | C2(.5),C3(.5)
 |  | SE | C1/C2 |  |  |  |  |  |  |  |  |  |  | System admin | C2(.5),C3(.5)
 |  | SE | C1/C2 |  |  |  |  |  |  |  |  |  |  | SSE | C2(.25),C3(.5),C4(.25)
 |  | [NAME] | C2(.5),C3(.5) |  |  |  |  |  |  |  |  |  |  | Technical Writer | C3/C4
 |  | SE | C1/C2
 |  | Technical Writer | C3/C4
 |  | Technical Writer | C3/C4
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 31118 | 31456
2 | 26432 | 31456
3 | 27387 | 31394
4 | 31954 | 31456
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-01-31 00:00:00 |  |  | 100993
2002-02-04 00:00:00
CBS Volume
 |  |  | 62232
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 4

 | Dec 28 |  | Jan 4 |  | Jan 11 |  | Jan 18
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, cleared and uncleared.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 56924d1257102788-how-to-filter-data-in-spreadsheets-example-workbook
Sheet: Filtered Data

Kanji | WRP_CardID | ExampleKanji | ExampleYomi
国 | 41 | 天国 | てんごく
天 | 41 | 天ぷら | てんぷら
天 | 41 | 天国 | てんごく
子 | 43 | お子さん | おこさん
大 | 44 | 大学生 | だいがくせい
学 | 44 | 大学生 | だいがくせい
学 | 44 | 学ぶ | まなぶ
学 | 44 | 学生 | [NAME]
学 | 44 | 留学生 | りゅうがくせい
Spreadsheet: 740011d1626138379-assign-unique-project-code-project-id-challenge
Sheet: Sheet1

Company Name | Original ID | ID
ABC
ABCD
ACBDE
ABCDE |  |  |  |  |  |  |  |  |  | Requirements
dfsdsdf
sdfsdf |  |  |  |  |  |  |  |  |  | ID should equal first 5 characters of company name | Represented by 'Original ID' which is the value it would be if no dupes
sdfsdf |  |  |  |  |  |  |  |  |  | Where Company name < 5 characters, add trailing zeros to make up to 5 characters
sdfsdf
sdfsdf |  |  |  |  |  |  |  |  |  | If that ID has been taken already, then;
sdfdfsf |  |  |  |  |  |  |  |  |  | if last digit is not a number then replace with a "0"
ddddd |  |  |  |  |  |  |  |  |  | If last 2 digits = 99 then replace with '000'
sss99 |  |  |  |  |  |  |  |  |  | IF last digits is a "9" replace with "00"
ddddd99 |  |  |  |  |  |  |  |  |  | If last digit is any other number add one (eg if 4 replace it with a 5)
sd99
sdfsdf
gg
gs
sdfdsfsfsdf
Spreadsheet: matthew_lenhart__26344__TexacoPG&ETopock deals
Sheet: 695717

Deal Id | 695717 |  |  |  |  |  | Original Deal Volume |  |  |  | Deal Price
Month | 2001-04-01 00:00:00 |  |  |  |  |  | 10000 |  |  |  | 7.25
 |  | Pipe | Zone | MeterCode
 |  | PG&E |  |  | Sum
 |  | SBELP TPCK |  | Sum |  |  |  |  |  | PG&E Large Packages |  |  | Contract |  | PG&E Large Packages
 | Date | EP0202RSB - SB-EPNG/ | Sum |  |  |  | Volume Cut | Make up Allocations |  | Gas Daily Price |  |  | Penalty |  | Gas Daily Hi Price |  | Hi - Penalty
 | 1 |  |  |  |  |  |  | 0 |  | 7.65 |  |  |  |  | 8.31
 | 2 | 8601 | 8601 | 8601 | 8601 |  |  | 0 |  | 7.65 |  |  |  |  | 8.31
 | 3 | 9527 | 9527 | 9527 | 9527 |  |  | 0 |  | 6.035 |  |  |  |  | 6.66
 | 4 | 9208 | 9208 | 9208 | 9208 |  |  | 0 |  | 7.96 |  |  |  |  | 9.3
 | 5 | 5624 | 5624 | 5624 | 5624 |  |  | 0 |  | 10.895 |  |  |  |  | 12.12
 | 6 | 7351 | 7351 | 7351 | 7351 |  |  | 0 |  | 11.59 |  |  |  |  | 12.99
 | 7 | 20000 | 20000 | 20000 | 20000 |  |  |  |  | 11.83 |  |  |  |  | 12.24
 | 8 | 15746 | 15746 | 15746 | 15746 |  |  |  |  | 11.83 |  |  |  |  | 12.24
 | 9 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.83 |  |  |  |  | 12.24
 | 10 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.575 |  |  |  |  | 12.25
 | 11 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.73 |  |  |  |  | 11.93
 | 12 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.62 |  |  |  |  | 12.23
 | 13 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.805 |  |  |  |  | 12.3
 | 14 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.805 |  |  |  |  | 12.3
 | 15 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.805 |  |  |  |  | 12.3
 | 16 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.805 |  |  |  |  | 12.3
 | 17 | 9131 | 9131 | 9131 | 9131 |  |  |  |  | 11.775 |  |  |  |  | 12
 | 18 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.42 |  |  |  |  | 11.9
 | 19 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.37 |  |  |  |  | 11.9
 | 20 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.045 |  |  |  |  | 11.67
 | 21 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 10.67 |  |  |  |  | 11.23
 | 22 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 10.67 |  |  |  |  | 11.23
 | 23 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 10.67 |  |  |  |  | 11.23
 | 24 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 10.855 |  |  |  |  | 11.42
 | 25 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 11.995 |  |  |  |  | 12.6
 | 26 | 20000 | 20000 | 20000 | 20000 |  |  |  |  | 12.52 |  |  |  |  | 13.1
 | 27 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 12.105 |  |  |  |  | 12.6
 | 28 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 12.005 |  |  |  |  | 12.18
 | 29 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 12.005 |  |  |  |  | 12.18
 | 30 | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 12.005 |  |  |  |  | 12.18
 | Sum |  | 305188 | 305188 | 305188
Spreadsheet: 876897d1723616312-sumifs-by-name-and-eomonth-array-formula-bydate-1-
Sheet: Sheet1

Helper | Date | Staff Name | Amount |  |  | Staff Name | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00
 | 2024-03-01 00:00:00 | [NAME] | 11 |  |  |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2024-03-02 00:00:00 | [NAME] | 23 |  |  | [NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2024-03-04 00:00:00 | [NAME] | 23 |  |  | [NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2024-04-04 00:00:00 | [NAME] | 100 |  |  | [NAME] | 0 | 100 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2024-04-16 00:00:00 | [NAME] | 123 |  |  | [NAME] | 0 | 123 | 122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2024-05-01 00:00:00 | [NAME] | 122
 | 2024-05-01 00:00:00 | [NAME] | 20
 |  |  |  |  |  | How do I do the above formula without the Helper Column A?
Spreadsheet: 706175d1606507960-create-unique-list-from-multiple-columns-using-unique-course-test
Sheet: Sheet1

 | Course 1 | Course 2 | Course 3 | Course 4 | Course 5
 | Python for Engineers | Ground Improvement Training | Airphoto Interpretation | Flow3D | GeoStudio Training
 | Facilitation Training | [NAME] | Feedback Training | Other | Other
 | Python for Engineers | Televiewer Data Interpretation | Drilling 201 | Construction Monitor Training | Project Management
 | Civil Geotech Training | Drilling 101 | Glacial Deposition | GeoStudio Training | Drilling 201
 | Speak Like a Leader [NAME] | Python for Engineers | [NAME]
 | Drilling 101 | [NAME] | Construction Monitor Training | [NAME] | Glacial Deposition
 | HEC-RAS 1D & 2D | [NAME] | [NAME] | GeoStudio Training | Glacial Deposition
 | Python for Engineers | Dams 101 | [NAME] | GeoStudio Training
 | Glacial Deposition | Pipeline Lead Inspector Training | Civil Geotech Training | Speak Like a Leader [NAME] | Airphoto Interpretation
 | Airphoto Interpretation | Drilling 101 | Pipeline New Inspector Training | Construction Monitor Training | Hydrogeology 101
 | Glacial Deposition | Structural Geology | [NAME] | Pipeline Construction and Geotechnical Field Support | Drilling 101
 | Speak Like a Leader [NAME] | Leadership Foundation | Python for Engineers | HEC-RAS 1D & 2D | Flow3D
Spreadsheet: 55517d1255624925-data-filteration-sample
Sheet: Sheet1

NAME | TYPE | 2009-01-01 00:00:00 | 2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | 2009-01-05 00:00:00 | 2009-01-06 00:00:00 | 2009-01-07 00:00:00 | 2009-01-08 00:00:00 | 2009-01-09 00:00:00 | 2009-01-10 00:00:00 | 2009-01-11 00:00:00 | 2009-01-12 00:00:00
[NAME] | SENT | 58 | 27 | 92 | 83 | 19 | 8 | 5 | 88 | 36 | 24 | 76 | 79
Emily | SENT | 14 | 73 | 48 | 61 | 69 | 22 | 6 | 23 | 15 | 73 | 4 | 87
Mark | SENT | 74 | 26 | 69 | 37 | 14 | 91 | 31 | 87 | 39 | 52 | 61 | 90
[NAME] | SENT | 39 | 84 | 23 | 57 | 11 | 96 | 25 | 12 | 73 | 57 | 82 | 1
Maria | SENT | 32 | 78 | 62 | 63 | 6 | 0 | 7 | 91 | 21 | 3 | 39 | 86
[NAME] | RECEIVED | 62 | 55 | 14 | 1 | 59 | 58 | 71 | 61 | 16 | 92 | 46 | 31
Emily | RECEIVED | 91 | 83 | 12 | 68 | 34 | 62 | 25 | 54 | 31 | 84 | 7 | 54
Mark | RECEIVED | 95 | 74 | 67 | 33 | 79 | 11 | 25 | 73 | 90 | 49 | 55 | 5
[NAME] | RECEIVED | 68 | 32 | 36 | 19 | 69 | 42 | 12 | 43 | 66 | 49 | 54 | 85
Maria | RECEIVED | 83 | 92 | 62 | 19 | 11 | 15 | 60 | 56 | 38 | 4 | 60 | 9
[NAME] | PENDING | 54 | 21 | 60 | 6 | 95 | 37 | 87 | 68 | 37 | 56 | 0 | 10
Emily | PENDING | 16 | 16 | 25 | 54 | 84 | 82 | 12 | 48 | 12 | 47 | 32 | 22
Mark | PENDING | 28 | 53 | 76 | 60 | 86 | 28 | 23 | 19 | 0 | 19 | 41 | 91
[NAME] | PENDING | 98 | 35 | 73 | 59 | 35 | 79 | 11 | 50 | 26 | 1 | 80 | 27
Maria | PENDING | 30 | 69 | 6 | 62 | 71 | 45 | 12 | 22 | 45 | 72 | 61 | 55
[NAME] | [NAME] | 99 | 9 | 20 | 54 | 3 | 20 | 54 | 4 | 58 | 100 | 66 | 18
Emily | [NAME] | 89 | 75 | 31 | 4 | 2 | 54 | 5 | 6 | 35 | 61 | 84 | 64
Mark | [NAME] | 72 | 61 | 55 | 79 | 45 | 98 | 12 | 87 | 17 | 95 | 47 | 61
[NAME] | [NAME] | 71 | 22 | 86 | 11 | 58 | 17 | 69 | 33 | 53 | 89 | 75 | 77
Maria | [NAME] | 4 | 59 | 11 | 76 | 92 | 12 | 86 | 4 | 22 | 3 | 27 | 60
What I am looking for is A drop down menue here with the names then the table below it will update from the database above for the person selected
Keep in mind my actual data contains more names, more types, and data over 1 year daily. I need a way to call the person name and get his related data for the whole year for each type
 |  | 2009-01-01 00:00:00 | 2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | 2009-01-05 00:00:00 | 2009-01-06 00:00:00 | 2009-01-07 00:00:00 | 2009-01-08 00:00:00 | 2009-01-09 00:00:00 | 2009-01-10 00:00:00 | 2009-01-11 00:00:00 | 2009-01-12 00:00:00
 | SENT | 58 | 27 | 92 | 83 | 19 | 8 | 5 | 88 | 36 | 24 | 76 | 79
 | RECEIVED | 62 | 55 | 14 | 1 | 59 | 58 | 71 | 61 | 16 | 92 | 46 | 31
 | PENDING | 16 | 16 | 25 | 54 | 84 | 82 | 12 | 48 | 12 | 47 | 32 | 22
 | [NAME] | 99 | 9 | 20 | 54 | 3 | 20 | 54 | 4 | 58 | 100 | 66 | 18
Spreadsheet: 136644d1326756492-if-than-help-vlookup-v2
Sheet: Sheet1

 |  |  | Port | Service
 |  |  | 22 | SSH
 |  |  | 23 | TELNET
 |  |  | 80 | HTTP |  |  |  |  |  | Lookup Table TCP |  |  | Lookup Table UDP
 |  |  |  |  |  |  |  |  |  | 22 | SSH |  | 67 | Test
 |  |  |  |  |  |  |  |  |  | 23 | TELNET
 |  |  |  |  |  |  |  |  |  | 80 | HTTP
Port | Protocol | Service
22 | TCP | SSH
23 | TCP
67 | UDP
Spreadsheet: 691134d1597503727-sumif-over-a-range-sumifxl
Sheet: Sheet1

 |  |  |  | Month1 | Month2
Sales | Low | High
 |  |  |  |  |  |  |  | Cell A should contain the sum of all values in sheet2 colC where Sheet2 col A is a number between B4 and C4
SALES OF PRODUCT | 4000 | 4238 |  | "A" | "C" |  |  | [NAME] the same for Sheet2 Col D
SALES ARTWORK | 4239 | 4400 |  | "B" | "D" |  | I tried | SUMIF(Sheet2!A:A,"">=" & B4 & "and" & "<=" & C4",Sheet2!C:C)
SALES OF TRANSPORT | 4401 | 4430
0THER SALES | 4431 | 4999
 |  |  |  |  |  |  |  |  |  |  | Not liked
Direct Expenses | Low | High
ARTWORK COSTS | 5300 | 5339
CARRIAGE COSTS | 5340 | 5449
OTHER COSTS | 5800 | 5999