tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 776958d1650021320-look-up-formula-lg-enhancement-team-tracking-sheet-ans
Sheet: Chad Bid Details

JOB # | EXCEPTION FORM DATE | SO # | BRANCH NAME | BRANCH | MARKET | CONTRACTOR | TYPE | PROPERTY NAME | JOBS | PROPERTY ADDRESS | BID BY | BID DUE DATE | BID SENT DATE | AWARDED DATE | REVISED DATE | BID $ | SOLD $ | DATE OF INSTALL | DAYS TO CLOSE | HRS | NOTES | DATE OF INSTALL NOTES
B1 |  |  | ALLENTOWN |  |  | Quandel | BID |  |  |  | CB
B2 |  |  | ALLENTOWN |  |  | Quandel | BID |  |  |  | CB
B3
B4
Spreadsheet: 722233d1615127680-need-help-with-multiple-conditions-vix
Sheet: VIX

Country | VIX
Germany | -4.14
Portugal | -3.03
UK | 0.13
France | 2.4
Russia | 6.5
Japan | 4.5
Spain | -4
Belgium | 1.8
US | -0.47
China | 1.65
Hong Kong | -3.25
India | 5.5
Singapore | -0.82
South Korea | -4.75
Vietnam | -1.51
Isreal | 1.31
Saudi Arabia | -1.37
Taiwan | -1.26
Cambodia | -1.03
Nepal | -6
Macao | -1.78
UAE | -1.03
South Africa | 2
Kenya | -0.93
Morocco | 3.32
Spreadsheet: 329955d1404466180-sorting-5-columns-keeping-the-earlier-column-data-fixed-sort-sheet-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Company Name | Product | Quality | Source | time | Helper C | Helper D | Helper E |  |  | none | Orange | Best | Hawaii | 1 Day
 | Company A | Orange | Good | Hawaii | 5 Days | 1 | 2 | 1 |  |  |  | [NAME] | Good | Indiana | 2 Days
 | Company A | Apple | Best | Michigan | 4 Days | 3 | 1 | 4 |  |  |  | Apple | Average | Texas | 3 Days
 | Company A | Apple | Good | Hawaii | 5 Days | 3 | 2 | 1 |  |  |  | Grapes |  | Michigan | 4 Days
 | Company A | Apple | Average | Oregon | 3 Days | 3 | 3 | 5 |  |  |  |  |  | Oregon | 5 Days
 | Company B | Orange | Good | Texas | 1 Day | 1 | 2 | 3
 | Company B | Orange | Average | Indiana | 4 Days | 1 | 3 | 2
 | Company B | [NAME] | Best | Hawaii | 1 Day | 2 | 1 | 1 |  | Helper columns G, H & I are used.
 | Company B | [NAME] | Average | Oregon | 3 Days | 2 | 3 | 5
 | Company B | Grapes | Best | Indiana | 4 Days | 4 | 1 | 2 |  | In [NAME] the formula   [NAME])
 | Company C | Orange | Best | Texas | 1 Day | 1 | 1 | 3 |  | Drag upto I26
 | Company C | Orange | Good | Hawaii | 5 Days | 1 | 2 | 1 |  | Select the entire table
 | Company C | Orange | Good | Indiana | 3 Days | 1 | 2 | 2 |  | Then DATA --> SORT
 | Company C | Apple | Good | Michigan | 1 Day | 3 | 2 | 4 |  | Company name  A to Z
 | Company C | Grapes | Best | Indiana | 4 Days | 4 | 1 | 2 |  | Helper C  Smallest to Biggest
 | Company C | Grapes | Average | Texas | 3 Days | 4 | 3 | 3 |  | Helper D  Smallest to Biggest
 | Company D | Orange | Best | Oregon | 5 Days | 1 | 1 | 5 |  | Helper E  Smallest to Biggest
 | Company D | Orange | Good | Oregon | 3 Days | 1 | 2 | 5 |  | time  A to Z
 | Company D | Orange | Average | Hawaii | 5 Days | 1 | 3 | 1 |  | If [NAME] helper columns or can be deleted
 | Company D | Apple | Best | Oregon | 5 Days | 3 | 1 | 5
 | Company D | Apple | Good | Michigan | 3 Days | 3 | 2 | 4
 | Company D | Apple | Good | Michigan | 3 Days | 3 | 2 | 4 |  | If your order of sorting for each column same always ,Custom list can be prepared
 | Company D | Apple | Average | Michigan | 5 Days | 3 | 3 | 4 |  | Then table can be sorted straigtaway in version 2007 onwords.
 | Company D | Grapes | Good | Oregon | 1 Day | 4 | 2 | 5
 | Company D | Grapes | Average | Hawaii | 4 Days | 4 | 3 | 1
Spreadsheet: 878159d1725188282-consolidation-of-marks-excel-help
Sheet: Sheet1

 |  |  |  | Name | Level | Marks
 |  |  |  | ADHVIK A | F1 | 15
 |  |  |  | ADIDEV | F1 | 45
 |  |  |  | ADITHYA | A1 | 25
 |  |  |  | KRISHNA | A2 | 15
 |  |  |  | HARI | F3 | 35
 |  |  |  | ETHAN | A2 | 45
 |  |  |  | THOMAS | A5 | 55
 |  |  |  | SREENATH | F3 | 45
 |  |  |  | [NAME] | F4 | 85
 |  |  |  | [NAME] | A7 | 95
 |  |  |  | SREEHARI | F2 | 45
 |  |  |  | AARAVI S | F4 | 48
 |  |  |  | SHANKAR | F6 | 81
 |  |  |  | RAHUL | F9 | 84
 |  |  |  | AAHAN | F4 | 88
 |  |  |  | ADEEP | A7 | 54
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 9902
Regions | NGP&L | Actuals | [NAME] |  | All Reclass
Central
Northeast | 0 | 0
East- EGM
East-LRC
FT-South East
Texas-EGM
Texas-HPL
FT-South Texas
West
Storage
Ontario
FT-Ontario
Boston Gas
Total Per Indiv. Tabs
Per TOTAL Tab
Regions | Revised NGP&L | Actuals | [NAME]
Central
Northeast | 0
East
Texas
West
Storage
Ontario
Boston Gas
Total Per Indiv. Tabs
Per TOTAL Column
Regions | NGP&L | Actuals | [NAME]
Central
Northeast
Southeast- EGM
Southeast-LRC
Texas-EGM
Texas-HPL
West
Storage
Transport
BGC
Total Per Indiv. Tabs
Per TOTAL Tab
Regions | Revised NGP&L | Actuals | [NAME]
Central
Northeast
Southeast
Texas
West
Storage
Transport
BGC
Total Per Indiv. Tabs
Per TOTAL Column
Spreadsheet: a731a1d0-ff37-4412-b44d-23c5755d4bf2
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
PCHES | Test | PCHES | Pseudocholinesterase, Total, Serum | Pseudocholinesterase, Total, S | Photometric, Acetylthiocholine Substrate | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Additional Information: 1. Patient's age and sex are required. 2. For cases of prolonged apnea following surgery, wait 24 hours before obtaining specimen. | 0.25 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males > or =18 years: 3,100-6,500 U/L Females 18-49 years: 1,800-6,600 U/L > or =50 years: 2,550-6,800 U/L Reference values have not been established for patients that are <18 years of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82480 |  |  |  |  | Rochester
PCHES | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
PCHES | Result | PCHES | Pseudocholinesterase, Total, S | Pseudocholinesterase, Total, S | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 2098-2 | Cholinesterase:CCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 865568d1712642123-assign-data-items-within-my-cells-to-specific-groups-question-explained-in-message-qualifications-and-competencies-expiration-tracker-sample
Sheet: Sheet2

Performance Currency Duration |  | Taskbook Completion %
1 |  | 0
2 |  | 0.05
3 |  | 0.1
4 |  | 0.15
5 |  | 0.2
 |  | 0.25
 |  | 0.3
Status |  | 0.35
Qualified |  | 0.4
Certified |  | 0.45
Trainee |  | 0.5
 |  | 0.55
 |  | 0.6
 |  | 0.65
 |  | 0.7
 |  | 0.75
 |  | 0.8
 |  | 0.85
 |  | 0.9
 |  | 0.95
 |  | 0.99
 |  | 1
 |  | N/A
 |  | Complete
Spreadsheet: 85024d1285093897-conditional-formatting-time-comparison-w-now-book1
Sheet: Sheet1

2010-09-21 00:00:00
Tail Number |  | Departure Location | [NAME] | Dep Time | Arr Time
United Airlines 106 |  | LAX | ORD | 15 | 55
American Airlines 1598 |  | LAX | ORD | 600 | 700
American Airlines 1196 |  | LAX | ORD | 900 | 1000
American Airlines 2 |  | LAX | [NAME] | 1215 | 1945
Spreadsheet: 24569d1215050186-sorting-and-formulas-marc-investment-accts-2
Sheet: Sheet1

Company | Issue Date | Term Years | Maturity Term Date | Owner [NAME] | Option | Contract Value
Axa | 2005-09-28 00:00:00 | 1 | 2011-10-20 00:00:00 | [NAME] | 1 | 54664.07
Axa | 2006-06-30 00:00:00 | 1 | 2011-10-21 00:00:00 | [NAME] | 1 | 51601.7
Hartford | 2004-08-25 13:08:06 | 4 | 2011-10-22 00:00:00 | [NAME] | OPT1 | 98593.17
Hartford | 2004-09-13 15:58:26 | 4 | 2011-10-23 00:00:00 | [NAME] | OPT1 | 299111.46
Hartford | 2004-09-17 12:45:55 | 4 | 2011-10-24 00:00:00 | [NAME] | OPT1 | 88212.1
Hartford | 2004-09-22 22:34:44 | 4 | 2011-10-25 00:00:00 | Onish | OPT1 | 296453.71
Hartford | 2004-10-04 13:01:35 | 4 | 2011-10-26 00:00:00 | [NAME] | OPT1 | 30796.07
Hartford | 2004-10-04 13:03:51 | 4 | 2011-10-27 00:00:00 | [NAME] | OPT1 | 89507.36
Hartford | 2004-10-18 17:35:20 | 4 | 2011-10-28 00:00:00 | [NAME] | OPT1 | 9608.66
Hartford | 2004-10-26 18:00:49 | 4 | 2011-10-29 00:00:00 | [NAME] | OPT1 | 113016.02
Hartford | 2004-10-26 18:04:39 | 4 | 2011-10-30 00:00:00 | Nicholson | OPT1 | 182491.14
Hartford | 2004-11-01 17:55:09 | 4 | 2011-10-31 00:00:00 | Deare | OPT1 | 14250.36
Hartford | 2004-11-01 17:59:11 | 4 | 2011-11-01 00:00:00 | Deare | OPT1 | 42930.33
Hartford | 2004-11-03 19:13:30 | 4 | 2011-11-02 00:00:00 | Matias | OPT1 | 61519.15
Hartford | 2004-11-10 14:23:25 | 4 | 2011-11-03 00:00:00 | Wade | OPT1 | 40253.06
Axa | 2004-12-08 00:00:00 | 4 | 2012-02-08 00:00:00 | Testa | 1 | 40724.16
Axa | 2004-12-16 00:00:00 | 4 | 2012-02-09 00:00:00 | Weiss | 1 | 634786.37
Axa | 2004-12-16 00:00:00 | 4 | 2012-02-10 00:00:00 | Weiss | 1 | 661088.97
Axa | 2004-12-20 00:00:00 | 4 | 2012-02-11 00:00:00 | Banks | 1 | 80600.4
Axa | 2004-12-22 00:00:00 | 4 | 2012-02-12 00:00:00 | Weiss | 1 | 68256.09
Axa | 2004-12-22 00:00:00 | 4 | 2012-02-13 00:00:00 | Weiss | 1 | 65862.79
Hartford | 2004-12-28 14:51:14 | 4 | 2012-02-14 00:00:00 | Smith | OPT2 | 13982.7
Hartford | 2004-12-28 14:55:45 | 4 | 2012-02-15 00:00:00 | Smith | OPT2 | 29351.49
Axa | 2005-01-04 00:00:00 | 4 | 2012-02-16 00:00:00 | [NAME] | 2 | 49914.83
Axa | 2005-01-19 00:00:00 | 4 | 2012-02-17 00:00:00 | Komlosy | 1 | 55606.17
Axa | 2005-01-31 00:00:00 | 4 | 2012-02-18 00:00:00 | Reluzco | 1 | 59483.64
Hartford | 2005-01-31 13:45:33 | 4 | 2012-02-19 00:00:00 | Young | OPT1 | 7507.93
Spreadsheet: 737064d1624093836-lookup-in-2-ranges-ranges-and-return-a-value-sample-sheet
Sheet: Sheet2

 | Sheet 1 Documents |  | [NAME] | [NAME] | Mark | Ian |  | Add a STAR to the column if the document on Sheet one is assigned to the name in columns D:G
 | Document 1 |  | *
 | Document 2 |  | * | *
 | Document 3 |  | * | *
 | Document 4 |  | *
 | Document 5 |  | * | *
 | Document 6 |  | * | *
 | Document 7 |  | * | *
 | Document 8 |  | *
 | Document 9 |  | * | *
 | Document 10 |  | *
 | Document 11 |  | *
 | Document 12
 | Document 13
 | Document 14
 | Document 15 |  |  | *
 | Document 16 |  |  | *
 | Document 17 |  | * | *
 | Document 18
 | Document 19
 | Document 20
 | Document 21 |  | * | *
 | Document 22 |  | * | *
 | Document 23 |  |  | *
 | Document 24 |  | *
 | Document 25 |  | *
 | Document 26
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 19

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap transaction volumes, month ending July 31, by product, participant type, and cleared status (in number of transactions).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared 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: cooper_richey__4013__AB Power Fax
Sheet: Sheet1

 |  | GFI Alberta Electricity Desk
 |  | [NAME] [PHONE]
 |  | [EMAIL]
 |  | FLAT | LOAD
 | Maturity | bid $/Mwh | ask $/Mwh
 | Day Ahead | 36 | 39
 | BOM | 37 | 39
 | 2001-12-01 00:00:00 | 41.5 | 42.5
 | 2002-01-02 00:00:00 | 44 | 45
 | Q1 2002 | 43.75 | 44.75
 | Q2 2002 | 38.75 | 39.75
 | Q3 2002 | 41.25 | 42.25
 | Q4 2002 | 44.5 | 45.5
 | Cal 2002 | 42 | 43
 | Cal 2003 | 40.75 | 42.25
Note:
GFI Brokers Limited ("GFI") has provided this information on the basis that its intended use is for indicative price only.
GFI provides no warranties as to the accuracy of this information.
GFI (and its affiliates) accept no liability whatsoever for any loss that may arise as a result of the provision and use of this information.
Spreadsheet: 133816d1324652924-pivot-table-not-showing-row-label-new-work_2
Sheet: Table input

Current week | Y |  |  |  |  | Current week | Y
Count of Ticket # | Column Labels |  |  |  |  |  | Column Labels
Row Labels | Severity 3 | Severity 4 | Grand Total |  |  |  | Grand Total
closed | 2 |  | 2 |  |  | Count of Ticket #
resolved | 16 | 2 | 18
pending | 2 | 1 | 3
Grand Total | 20 | 3 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  | Week Reported | (All)
Total Tickets submitted |  |  |  |  |  |  |  |  |  |  |  |  | Count of Ticket # | Column Labels |  |  |  |  | Incident Status by Severity
 |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Severity 3 | Severity 4 | Grand Total
Count of Ticket # |  |  |  |  |  |  |  |  |  |  |  |  | Infrastructure-AIX | 4 | 1 | 5 |  |  |  | Resolved | In-Progress | Pending | Total
8 |  |  |  |  |  |  |  |  |  |  |  |  | Infrastructure-WIN | 1 |  | 1 |  |  | Severity 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Infrastructure-SAN |  | 1 | 1 |  |  | Severity 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Administration | 1 |  | 1 |  |  | Severity 3
Incidents by Support Agent |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 6 | 2 | 8 |  |  | Severity 4
Count of Ticket # | Column Labels
Row Labels | [NAME] | [NAME] | [NAME] | [NAME] | #N/A | Grand Total
 |  | 1 |  |  |  | 1
Infosys |  |  | 1 | 2 |  | 3
Technology Service Delivery (TSD) | 1 |  |  | 3 |  | 4
#N/A
Grand Total | 1 | 1 | 1 | 5 |  | 8
Teams that raise incidents
Row Labels | Count of Ticket #
 | 1
Infosys | 3
Technology Service Delivery (TSD) | 4
#N/A
Grand Total | 8
Cis with Incidents raised
Week resolved | 51
Row Labels | Count of Ticket #
Grand Total
Spreadsheet: 479661d1473478516-dynamic-filter-conversion-for-excel-2002-dynamic-excel-filter
Sheet: Dynamic Filter Demo

 | Product Name | Sales Rep | Country | Helper 1 | Helper 2 | Helper 3 |  | Product Name | Sales Rep | Geography
 | Product 1 | [NAME] | India
 | Product 2 | [NAME] | China
 | Product 3 | [NAME] | Japan
 | Product 4 | Racheal | US
 | Product 5 | Arvind | India
 | Product 6 | [NAME] | China
 | Product 7 | [NAME] | US
 | Product 8 | [NAME] | India
 | Product 9 | [NAME] | Indonesia
 | Product 10 | Stephen | Philippines
 | Product 11 | [NAME] | Singapore
 | Product 12 | [NAME] | Singapore
 | Product 13 | [NAME] | India
 | Product 14 | [NAME] | Canada
 | Product 15 | [NAME] | Japan
 | Product 16 | [NAME] | Japan
 | Product 17 | Racheal | US
 | Product 18 | [NAME] | US
 | Product 19 | [NAME] | Canada
 | Product 20 | [NAME] | India
Spreadsheet: 64273d1265141248-search-tabs-and-return-results-kc_environmental_aspects-1-
Sheet: Process - Activity 8

Operating Condition | Process Evaluated | Loading & Unloading | Date |  |  | Enter Date |  | Team | 0
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0 | 6 | Yes
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
Spreadsheet: 656529d1578290464-calculating-values-depending-on-variable-suppliers-sample-supplier-products-calcs-beamer-
Sheet: Sheet1

 | Shift | Time of Day | Supplier | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Cost
 | 1 | Day | Supplier 1 | 1 | 1
 | 2 | Night | Supplier 1 |  | 3 | 1
 | 3 | Day | Supplier 2 | 2 | 2 | 1
 | 4 | Weekend | Supplier 1 |  |  | 4
 |  |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10
 | Supplier 1 | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | Night | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | Weekend | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5
 | Supplier 2 | Day | 2 | 3 | 1 | 1 | 0.5 | 0 | -0.5 | -1 | -1.5 | -2
 |  | Night | 3 | 4 | 2 | 2 | 1.5 | 1 | 0.5 | 0 | -0.5 | -1
 |  | Weekend | 3.5 | 4.5 | 2.5 | 2.5 | 2 | 1.5 | 1 | 0.5 | 0 | -0.5
 | Supplier 3 | Day | 3.83333333333333 | 4.83333333333333 | 1.63333333333333 | 1.23333333333333 | 0.133333333333329 | -0.966666666666667 | -2.06666666666662 | -3.16666666666671 | -4.26666666666669 | -5.36666666666668
 |  | Night | 4.26190476190476 | 5.26190476190476 | 1.29047619047619 | 0.633333333333334 | -0.852380952380951 | -2.33809523809524 | -3.82380952380952 | -5.30952380952381 | -6.79523809523809 | -8.28095238095238
 |  | Weekend | 4.69047619047619 | 5.69047619047619 | 0.94761904761905 | 0.0333333333333341 | -1.83809523809524 | -3.70952380952384 | -5.58095238095242 | -7.45238095238091 | -9.32380952380949 | -11.1952380952381
 | Supplier 4 | Day
 |  | Night
 |  | Weekend
 | Supplier 5 | Day
 |  | Night
 |  | Weekend
 | Supplier 6 | Day
 |  | Night
 |  | Weekend
 | Supplier 1
 | Supplier 2
 | Supplier 3
Spreadsheet: 275189d1383378124-write-over-data-validation-with-drop-down-dependant-menu-example
Sheet: data

 | Menu | Product
 | breakfast | eggs
 | breakfast | bacon
 | breakfast | muffin
 | lunch | salad
 | lunch | burger
 | lunch | sandwich
 | dinner | steak
 | dinner | fish
 | dinner | chicken
Spreadsheet: 709483d1608325221-help-me-to-use-another-cell-value-as-the-range-value-of-correl-or-similar-function-book2-excelforum
Sheet: Sheet1

Col A | Col B |  |  |  |  |  | Rows up: | 1
9 | 94
10 | 108 |  |  |  |  |  | Correlation
1 | 13
8 | 89
9 | 99
3 | 38
2 | 21
4 | 46
10 | 108
1 | 20
4 | 45
4 | 45
5 | 57
10 | 103
10 | 103
10 | 108
2 | 28
9 | 100
7 | 72
9 | 95
5 | 51
7 | 78
8 | 85
4 | 49
9 | 99
4 | 46
9 | 97
9 | 98
3 | 38
Spreadsheet: 718054d1612968952-excel-formula-for-confidence-interval-confidence-interval
Sheet: Sheet1

 | I am kindly asking for execl formula to calculate 95% confidence Interval - column F7
 | Details | Mean | Standard Deviation | 95% Confidence Interval
 | Do not stigmatise patients | 1.75 | 1.1
 | Good communication skills | 1.77 | 1.19
 | Works in a patient centred way | 1.77 | 1.02
 | Knowledge about mental health law | 1.84 | 0.84
 | Are able to effectively manage crisis situations | 1.84 | 1.07
 | Have good observation skills | 1.84 | 1.25
 | Are able to express empathy | 1.86 | 1.04
 | Are knowledgable about risk factors for mental illness | 1.88 | 1
 | Skilled at talking to patients families and friends | 1.93 | 1.16
Spreadsheet: eric_saibi__9771__012802R
Sheet: Quad Cities 02

Owner Name |  | Exelon Nuclear
Station Name |  | Quad Cities Nuclear Power Station
Unit Name |  | Quad Cities 02
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nuclear
Capacity |  | 828 MW
Start Date |  | 2002-02-04 00:00:00
End Date |  | 2002-03-10 00:00:00
Prv. Start Date |  | 2002-02-08 00:00:00
Prv. End Date |  | 2002-03-14 00:00:00
Comments |  | Refuel
SIC |  | 4931
Plant ID |  | 1515021
Unit ID |  | 1007230
Outage ID |  | 10969
Spreadsheet: 740740d1626518922-commission-allocation-based-on-variable-targets-commission-cal
Sheet: Cost Calculation (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | CommissionBenchmark |  |  | Commission %
 |  | Unit Cost / Sale / Margin |  |  |  |  |  |  |  |  |  |  |  | Target unit + 250 surplus |  |  | 2
 |  | Unit Cost | 120 |  |  |  |  |  |  |  |  |  |  | Target unit + 500 surplus |  |  | 3
 |  | Our Margin | 0.5 |  |  |  |  |  |  |  |  |  |  | Target unit + 750 surplus |  |  | 4
 |  | Margin Amount |  |  |  |  |  |  |  |  |  |  |  | Target unit + 1000 surplus |  |  | 5
 |  | Retail Price |  |  |  |  |  |  |  |  |  |  |  | Target unit + 1500 surplus |  |  | 5.5
 |  |  |  |  |  | Following units sold to cover the Salary of Sales Rep |  |  |  |  |  | Target Factor Calculation |  |  |  |  | Commission Calculations
 |  | Overhead Fixed Expenses / Month | Column2 |  |  | Salaries of Sale Staff | Salary | Slry trgt unit | Sale Amount | Cost Amount | Margin=slry | Factor | Target Unit | Sale | Cost | Margin | Unit Sold | [NAME] | Unit Cost | Comm % | Comm Amount | Column6
 |  | Rent | 10000 |  |  | Sales Rep 1 | 15000 |  |  |  |  | 2 |  |  |  |  | 650
 |  | Transportation | 2000 |  |  | [NAME] | 25000 |  |  |  |  | 2 |  |  |  |  | 751
 |  | Storage Charge | 5000 |  |  | [NAME] 3 | 0
 |  | Utilities | 3000 |  |  | [NAME] | 0
 |  | Admin Salaries | 10000 |  |  | Sales Rep 5 | 0
 |  |  |  |  |  | Sales Rep 6 | 0
 |  | Subtotal |  |  |  | Sales Rep 7 | 0
 |  |  |  |  |  | Sales Rep 8 | 0
 |  |  |  |  |  | Sales Rep 9 | 0
 |  |  |  |  |  | Sales Rep 10 | 0
 |  |  |  |  |  | Total
 |  |  |  |  |  | Total Expense covering |  |  |  |  |  |  | Case: | 1st row in above table
 |  |  |  |  |  |  |  |  |  |  |  |  | If he sells less than his target unit, No COMMISSION
 |  |  |  |  |  |  |  |  |  |  |  |  | If he sells his target unit + 250 units extra, then commission
 |  |  |  |  |  |  |  |  |  |  |  |  | will be 2%
 |  |  |  |  |  |  |  |  |  |  |  |  | Example is in the 1st row above, where his target is to sell 500 units and he sold 650, so 150 units sold extra,
 |  |  |  |  |  |  |  |  |  |  |  |  | that means he is entitle for 2% commission of extra unit sold which is 150
 |  |  |  |  |  |  |  |  |  |  |  |  | Case 2 | 2nd row in above table
 |  |  |  |  |  |  |  |  |  |  |  |  | His target units are 833, and he sold 751, that means no commission, and incase he sells target unit +  500 extra units, he will be entitled to 3% commission
 |  |  |  |  |  |  |  |  |  |  |  |  | So every one has different target, and based on the we have to decide commission
Spreadsheet: 794684d1662215154-how-to-identify-reproduce-a-fill-colour-rock-n-roll-bingocd-xx-game-xx-master-document
Sheet: MAIN

 |  | DO NOT EXCEDE THIS WIDTH | DO NOT EXCEDE THIS WIDTH
 |  | Songs | Artists
Disc: |  | Song 1 a very long Song Nam | Artist 1 a very long Artist Nam
Game: |  | Song 2 | Artist 2
 |  | Song 3 | Artist 3
 |  | Song 4 | Artist 4
 |  | Song 5 | Artist 5
 |  | Song 6 | Artist 6
 |  | Song 7 | Artist 7
 |  | Song 8 | Artist 8
 |  | Song 9 | Artist 9
 |  | Song 10 | Artist 10
 |  | Song 11 | Artist 11
 |  | Song 12 | Artist 12
 |  | Song 13 | Artist 13
 |  | Song 14 | Artist 14
 |  | Song 15 | Artist 15
 |  | Song 16 | Artist 16
 |  | Song 17 | Artist 17
 |  | Song 18 | Artist 18
 |  | Song 19 | Artist 19
 |  | Song 20 | Artist 20
 |  | Song 21 | Artist 21
 |  | Song 22 | Artist 22
 |  | Song 23 | Artist 23
 |  | Song 24 | Artist 24
 |  | Song 25 | Artist 25
 |  | Song 26 | Artist 26
 |  | Song 27 | Artist 27
 |  | Song 28 | Artist 28
 |  | Song 29 | Artist 29
 |  | Song 30 | Artist 30
 |  | Song 31 | Artist 31
 |  | Song 32 | Artist 32
 |  | Song 33 | Artist 33
 |  | Song 34 | Artist 34
 |  | Song 35 | Artist 35
 |  | Song 36 | Artist 36
 |  | Song 37 | Artist 37
 |  | Song 38 | Artist 38
 |  | Song 39 | Artist 39
 |  | Song 40 | Artist 40
 |  | Song 41 | Artist 41
 |  | Song 42 | Artist 42
 |  | Song 43 | Artist 43
 |  | Song 44 | Artist 44
 |  | Song 45 | Artist 45
Spreadsheet: 49355d1248709716-sum-numbers-from-a-table-totals10
Sheet: Sheet2

 | Do simple if's for each value in column D on Sheet 1,  then do a Sum for each column D value on a separate spreadsheet and hide
 | the spreadsheet that is doing the calulations
 | 850691 |  | 855663
 | 36.55 |  | 0
 | 44.25 |  | 0
 | 80 |  | 0
 | 0 |  | 0
 | 0 |  | 18.4
 | 0 |  | 3.64
 | 0 |  | 0
 | 0 |  | 0
 | 0 |  | 0
 | 0 |  | 0
 | 0 |  | 0
 | 160.8 |  | 22.04 |  | place these sum formula's on total sheet
 | 160.8 |  | 22.04