tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 843646d1695423817-issues-with-combined-line-stacked-area-charts-mrshorty-linescatterareacombochart
Sheet: changes

150
220
 | [NAME] data
 | normal | new | day*10 | normal2 | above | below
16 | 165.57 | 222.5
17 | 163.71 | 226.1
18 | 165.86 | 225.4
18.5 |  |  |  |  |  |  | new row
19 | 166.07 | 130.4
20 | 165.1 | 134.4
21 | 163.41 | 140.8
Spreadsheet: 767107d1644303741-use-index-match-to-find-greater-than-equal-to-value-excel-formula-get-value-just-greater-than-an-other-ans
Sheet: Sheet1

 |  | 25 |  |  |  | 25
10 | red |  |  | 70 | violet
20 | orange |  |  | 60 | indigo
30 | yellow |  |  | 50 | blue
40 | green |  |  | 40 | green
50 | blue |  |  | 30 | yellow
60 | indigo |  |  | 20 | orange
70 | violet |  |  | 10 | red
Spreadsheet: b631c467-e08f-400d-9627-5a9cfccfdd06
Sheet: Sheet1

[NAME] | INSTCODE | NPANUMB | CONTACT | [NAME] | CONTYP_COL | PLANCONU | ASPECT | INCLI | ELEVATION | CANTON | MUNICIPALITY | SWISSLONGITUDE | SWISSLATITUDE | NUMBACCCON | NUMBVARCON | NUMBSPECCON | SIZELOT | TYPESOIL | SOILGRAN | SOILROOTPEN | SOILSTONE | SOILLIME | SOILACTLIME | SOILPH | SOILWATER | [NAME] | REMUNICON | NEMATEST1 | NEMATEST2 | FARMERNAME | FARMERADDRESS | FARMERMUNICIPALITY | FARMERPHONE | FARMERMOBILE | FARMEREMAIL
 | CHE001=Station de recherche Agroscope Changins-Wädenswil, 1260 Nyon | 04-NAP-S65=04-NAP-S65 | Köhler [NAME] | 1=primary collection | 1=in vitro collection |  |  |  |  | VD=Waadt | Changins | 507169 | 139153 | 100 | 94 | 7
Spreadsheet: 865585d1712650673-adding-merging-a-formula-with-an-existing-formula-to-capture-2-conditions-pay-calculator_2024_rev-04_forum-version
Sheet: ADO Build-Up Time

DATE | DAY | SHIFT [NAME] |  | TOTAL HOURS WORKED | DEFAULT HOURS |  |  | BUILD-UP TIME BASED ON DEFAULT HOURS |  | BUILD-UP TIME BASED ON WORK HOURS |  |  | BALANCE RE-CALCULATED BASED ON WORK DAYS
 |  |  |  | Hrs:mins | hrs:mins format | Decimal format |  | TIME DEDUCTED (Decimal) | [NAME] | TIME DEDUCTED hrs:mins | RE-DISTRIBUTED BALANCE                                 hrs:mins |  | NOS. DAYS NOT DEDUCTED | DAYS DEDUCTED | DAILY BALANCE TO BE ADDED
WEEK 1
 | Monday | 'Work Calculator'!C10 | 'Work Calculator'!C10
 | Tuesday | 'Work Calculator'!C11
 | Wednesday
 | Thursday
 | Friday
 |  | WEEK 1 Sub-Total :
WEEK 2
 | Monday
 | Tuesday
 | Wednesday |  |  |  |  |  |  |  |  |  |  |  | 04:00:00 | Hours to be deducted for this 2 week pay period
 | Thursday |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Friday |  |  |  |  |  |  |  |  |  |  |  |  | Balance to be re-distributed over each day for the pay period
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Days worked over the pay period
 |  | WEEK 2 Sub-Total :
Spreadsheet: 741412d1627032419-sum-single-cell-from-multiple-sheets-if-criteria-met-in-summary-sheet-sum-criteria-multiple-sheets1
Sheet: Sheet2

 |  |  |  |  |  | Test Case Results
 |  |  |  |  |  | Qty | % | Time
 |  |  |  |  | Untested | 39 | 0.9069767441860465 | 1:46:00
 |  |  |  |  | Passed | 1 | 0.02325581395348837 | 1:00:00
 |  |  |  |  | Failed | 0 | 0 | 0:00:00
 |  |  |  |  | Skipped | 3 | 0.06976744186046512 | 0:00:00
 |  |  |  |  | Observation | 0 | 0 | 0:00:00
 |  |  |  |  | N/A | 0 | 0 | 0:00:00
 |  |  |  |  | Total Tested | 1 | 0.02325581395348837 | 1:00:00
 |  |  |  |  | % of test complete |  | 0.09302325581395349
 |  |  |  |  | Total tasks for Test | 43 |  | 2:46:00
Spreadsheet: 819953d1677777558-need-a-formula-that-looks-up-balance-on-1st-or-2nd-day-of-month-based-on-2-criteria-sample13
Sheet: Sheet1

 |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec
 | Date | Card # | Balance |  |  | Card 1
 | 2023-03-01 00:00:00 | Card 1 | 456 |  |  | Card 2
 | 2023-03-01 00:00:00 | Card 2 | 542 |  |  | Card 3
 | 2023-03-01 00:00:00 | Card 3 | 165 |  |  | Card 4
 | 2023-03-02 00:00:00 | Card 4 | 856 |  |  | Card 5
 | 2023-03-02 00:00:00 | Card 5 | 254
 | 2023-04-01 00:00:00 | Card 1 | 132
 | 2023-04-01 00:00:00 | Card 2 | 332
 | 2023-04-02 00:00:00 | Card 3 | 861
 | 2023-04-02 00:00:00 | Card 4 | 878
 | 2023-04-02 00:00:00 | Card 5 | 461
Spreadsheet: 725764d1616843821-monthly-to-cusotm-date-report-sample
Sheet: Report (F)

Criteria |  | Total Entries
Start Date | 2020-09-16 00:00:00
End Date | 2020-10-13 00:00:00
Total Unit Sold |  | Total Sell Price |  | Total Charges on Sell
Total Unit Sold |  | Total Sell Return Amt |  | Total Sell Return Charges
After Return |  | Actual Sell Price
 |  |  | TOTAL
Date | Model | Leather | Color | Unit Sold | Status | Sell Price | VAT | Unit Cost | DHL Cost | Handling Charges | Amazon Fees | PPC Cost | Total Cost | Net Sales | [NAME] | After [NAME] | Date of Return | Amazon Comm on Return | [NAME] after return | Ship Return Charges | DHL Cost | Handling Chges | Total Return Charges | Profit/Loss
Spreadsheet: dana_davis__4507__1 Central Records Form
Sheet: ZOO63227

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 #
20403 |  | Cactus Reports |  |  |  |  |  | [NAME]
 |  | 1996
 |  | Servicer Fee Schedules
 |  | Monthly Income Statement by Asset
 |  | Distribution from Available Cash |  |  |  | 1996-01-01 00:00:00 | 1996-09-01 00:00:00
 |  | Distribution from Available Cash |  |  |  | 1996-11-01 00:00:00
 |  | DB Commitment Fee Schedules
 |  | Interest Rate Swap Schedules
 |  | Outstanding Balance Schedules
 |  | Sales Schedules
 |  | Sheffield/Audubon C/F Schedules
 |  | Price Swaps
 |  | Sales/True-Ups to EGM/ERAC/Producer
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: 161029d1339372802-excel-2007-how-to-fix-sum-if-formula-mjc-registro-interactivo
Sheet: TNSR

TOTAL DE  NOTAS DE LOS ESTUDIANTES SEGUNDO R
[NAME] |  |  |  |  | 1ER SEMESTRE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2DO SEMESTRE
 |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS |  |  |  |  |  |  |  |  |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS
NOMBRE DEL ALUMNO |  |  |  | [NAME] | 60 | 50 | 50 | 40 |  |  |  |  |  |  |  |  |  | RESUMEN 1ER SEM |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  | RESUMEN 2DO SEM |  |  |  | TOTAL
 |  |  |  |  | A
Apellido 1ro |  | Apellido 2do | Nombre |  | N1 | N2 | N3 | N4 | SUMATIVA1 | SUMATIVA2 | SUMATIVA3 | [NAME] | SUMATIVA5 | SUMATIVA6 | SUMATIVA7 | SUMATIVA8 | SUMATIVA9 | [NAME] | [NAME] | [NAME] | NOTA | N5 | [NAME] | N7 | N8 | SUMATIVA10 | [NAME] | SUMATIVA12 | SUMATIVA13 | [NAME] | SUMATIVA15 | SUMATIVA16 | SUMATIVA17 | SUMATIVA18 | [NAME] | [NAME] | [NAME] | NOTA | [NAME] | [NAME] | [NAME] | NOTA |  |  | SEXO
 |  |  |  |  |  | A
 |  |  |  |  |  | D
 |  |  |  |  | N | N | N | N | N | N |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  | 1 | 30 | 25 | 50 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
 |  |  |  | 12
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
 |  |  |  | 28
 |  |  |  | 29
 |  |  |  | 30
 |  |  |  | 31
 |  |  |  | 32
 |  |  |  | 33
 |  |  |  | 34
 |  |  |  | 35
Spreadsheet: 13a737d6-05c9-4cfa-8333-05de8b8ac19d
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
FSOYG | Test | FSOYG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) |  |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | < 2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:  Viracor-IBT Laboratories                               1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FSOYG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FSOYG | Result | FSOYG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: joe_parks__14880__Contacts for MCV Auction
Sheet: Notes

Add
Alleghaney | [NAME] (President) | left voceimail to ask about gas potential interest in gas auction and appropriate gas contact.
Ameren | [NAME] (VP) | left voceimail to ask about gas potential interest in gas auction and appropriate gas contact.
Avista | [NAME] (VP) | left voceimail to ask about gas potential interest in gas auction and appropriate gas contact.  [NAME]
CLECO | [NAME] | Spoke with [NAME].  He says there would probably be interest on CLECO's part.  Will forward me the appropriate gas contact via email
ConAgro | [NAME] | Spoke with [NAME]. He says they do mostly financial but there may be some interest on physical.  He is the appropriate contact.
ConEd |  | Have not found contact info.
DTE | [NAME] | Spoke with [NAME].  He said he is interested.  He is the appropriate contact.
FLP Power Energy Marketing | [NAME] | left voceimail to ask about gas potential interest in gas auction and appropriate gas contact.
Merrill Lynch Capital | [NAME] | left voceimail to ask about gas potential interest in gas auction and appropriate gas contact.
Morgan Stanley | [NAME] | Spoke with [NAME].  She is the contact at this time, but they may appoint a lead contact for gas in the future.  There is interest.
Pacifcorp | [NAME] | There is interest.  He asked to send him the information and they will decided internally on the appropriate contact for gas
Southern Company Services |  | left voceimail to ask about gas potential interest in gas auction and appropriate gas contact.
TransCanada Energy |  | Spoke with [NAME].  They got rid of the gas marketing business.  No interest.
Shell Energy Trading |  | [NAME].  [NAME]'s contact.
Pancanadian
Total ELF | [NAME] [Heads up the office in Houston…] | Left message with [NAME]'s Assistant.
Spreadsheet: 694729d1599763991-if-formula-help-dschittone-sample
Sheet: Cap Proj List

LIST PROJECT # | Project | PRIORITY (A,B,C,D,E) | 2021-2022 | 2022-2023 | 2023-2024 | 2024-2025 | 2025-2026 | Quantity | Unit Cost | Raw Sub-Total | Soft Costs @ 28% | Soft Costs @ 30% | Remarks:
 |  |  |  |  |  |  |  |  |  |  | 1.28 | 1.3
 | Building Name
A | SITE WORK
1 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1
2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | EXTERIOR ENVELOPE
6 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 271287d1381892423-need-formula-to-this-logic-a-column-number-b-column-blank-then-c-column-desired-name-display-name-as-desired-bvj-
Sheet: Sheet1

MENTIONED CUG | GIVEN CUG | COMPARE A AND B | is b blank? | numbers in column A
CUG NEW ([PHONE],[PHONE],[PHONE]) | /919821049
ADMIN NO - [PHONE] | /999900260
ADMIN NO - [PHONE] | /919849643
CUG NOT REQUIRED
CUG NOT REQUIRED
CUG NOT REQUIRED
CUG NEW ([PHONE],[PHONE],[PHONE])
CUG NEW ([PHONE],[PHONE],[PHONE]) | /999900636
CUG NEW ([PHONE],[PHONE],[PHONE])
CUG NEW ([PHONE],[PHONE],[PHONE])
CUG NOT REQUIRED | /919840798
CUG NOT REQUIRED
ADMIN NO - [PHONE]
CUG NEW ([PHONE],[PHONE]) | /919852051
CUG NEW ([PHONE],[PHONE])
INT - 919852051
CUG 999964248
CUG 877776544
CUG 222244 | /222244
Spreadsheet: 720206d1614071849-index-lookup-2-criteria-with-few-strings-can-be-match-with-any-criteria-ask-excelforum-index-match-advance-1
Sheet: Sheet1

 | Fact Table |  |  |  | Dimension Table
 | Criteria 1 | [NAME] |  |  | Criteria 1 | [NAME] | Result
 | apple |  |  |  | apple |  | FRUIT 1 | > any record in Criteria B to result FRUIT 1
 | apple | red |  |  | orange | yellow | FRUIT 2 | > record in Criteria B should "yellow" to result FRUIT 2
 | apple | blue |  |  | orange | green | FRUIT 3 | > record in Criteria B should "green" to result FRUIT 3
 | apple
 | orange | yellow
 | orange | green
 | orange
Spreadsheet: 758783d1639064339-averaging-entries-per-day-by-date-sumproduct-excel_example
Sheet: Sheet1

ID | Start time | Completion time | Call Number
43 | 2021-12-06 09:00:03 | 2021-12-06 09:17:47 | 904
44 | 2021-12-06 06:05:43 | 2021-12-06 10:37:33 | 935 | Average, all people, all days
45 | 2021-12-06 09:39:49 | 2021-12-06 12:11:45 | 914
46 | 2021-12-06 12:14:06 | 2021-12-06 12:15:18 | 947 | Average 904, all days present |  | 3 days, 904 only present on two of them
47 | 2021-12-06 12:15:22 | 2021-12-06 12:15:58 | 947
48 | 2021-12-06 12:22:30 | 2021-12-06 12:23:18 | 904 | Average 904, all days in range |  | Counting all 3 days
49 | 2021-12-06 10:37:38 | 2021-12-06 14:14:43 | 935
50 | 2021-12-06 14:14:53 | 2021-12-06 15:33:54 | 935
51 | 2021-12-06 15:39:35 | 2021-12-06 15:40:27 | 904
52 | 2021-12-06 15:56:19 | 2021-12-06 15:58:58 | 752
53 | 2021-12-06 15:59:01 | 2021-12-06 15:59:37 | 752
54 | 2021-12-06 15:59:39 | 2021-12-06 16:00:17 | 752
55 | 2021-12-06 16:09:10 | 2021-12-06 16:10:08 | 947
56 | 2021-12-06 16:43:24 | 2021-12-06 16:44:02 | 947
57 | 2021-12-06 15:34:02 | 2021-12-06 16:59:08 | 935
59 | 2021-12-07 08:37:27 | 2021-12-07 08:38:40 | 940
60 | 2021-12-07 10:12:46 | 2021-12-07 10:13:27 | 914
61 | 2021-12-07 11:01:50 | 2021-12-07 11:02:41 | 947
62 | 2021-12-07 11:02:46 | 2021-12-07 11:04:19 | 947
63 | 2021-12-07 11:28:43 | 2021-12-07 11:29:14 | 904
64 | 2021-12-07 11:29:18 | 2021-12-07 11:29:48 | 904
65 | 2021-12-07 11:29:50 | 2021-12-07 11:30:42 | 904
66 | 2021-12-07 11:31:06 | 2021-12-07 11:31:44 | 904
67 | 2021-12-07 11:31:54 | 2021-12-07 11:32:48 | 904
68 | 2021-12-07 11:59:12 | 2021-12-07 11:59:45 | 914
69 | 2021-12-07 07:02:32 | 2021-12-07 12:05:47 | 935
70 | 2021-12-07 15:24:06 | 2021-12-07 15:25:35 | 935
71 | 2021-12-07 15:44:09 | 2021-12-07 15:44:50 | 904
72 | 2021-12-07 15:54:22 | 2021-12-07 15:55:04 | 914
74 | 2021-12-07 15:26:41 | 2021-12-07 17:33:44 | 935
75 | 2021-12-07 22:38:13 | 2021-12-07 22:40:32 | 947
76 | 2021-12-07 22:40:36 | 2021-12-07 22:41:09 | 947
77 | 2021-12-08 05:57:16 | 2021-12-08 05:57:49 | 911
78 | 2021-12-08 05:57:58 | 2021-12-08 05:58:29 | 911
79 | 2021-12-08 05:58:30 | 2021-12-08 05:58:46 | 911
80 | 2021-12-08 05:58:48 | 2021-12-08 05:59:04 | 911
Spreadsheet: c21b11d8-81ce-41be-abf6-c16e9a64499e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6526 | 50329 | [NAME] | [NAME] | POL | 133 | 00:19:09 | 00:01:30 | 01:29:03 | 00:00:50 | 00:42:38 | 1 | 02:33:14
Spreadsheet: 34c80a7b-2eb0-4d6e-925e-58bf8b29987f
Sheet: Sheet1

 |  | University Means | National Means | CACREP Means | Non-CACREP Means | Minimum Criteria
2002-04-13 00:00:00 | 83.33% Passed | 111 | 108.8 | 117.42 | 114.85 | 102
2002-10-19 00:00:00 | 79.16% Passed | 112.88 | 108.53 | 115.33 | 108.19 | 97
2003-04-12 00:00:00 | 75% Passed | 115.5 | 111.7 | 123.07 | 120.54 | 103
2003-10-18 00:00:00 | 100% Passed | 124.5 | 108.5 | 113.82 | 110.82 | 98
2004-04-24 00:00:00 | 91.66% Passed | 117.33 | 105.44 | 117.62 | 115.01 | 100
2004-10-23 00:00:00 | 100% Passed | 110.27 | 102.91 | 110.18 | 107.34 | 93
2005-04-16 00:00:00 | 75% Passed | 113.63 | 105.04 | 115.5 | 113.67 | 99
2005-10-22 00:00:00 | 81% Passed | 111.69 | 105.29 | 114.15 | 108.77 | 95
2006-04-22 00:00:00 | 91% Passed | 111.91 | 101.31 | 115.11 | 114.51 | 98
2006-10-21 00:00:00 | 89% Passed | 114.68 | 99.12 | 110.89 | 108.22 | 92
2007-04-21 00:00:00 | 63.64% Passed | 111.18 | 105.18 | 120.53 | 115.63 | 102
2007-10-20 00:00:00 | 100% Passed | 115.86 | 97.51 | 109.69 | 106.3 | 90
2008-04-12 00:00:00 | 84.61% Passed | 109.54 | 100.11 | 114.44 | 113.56 | 97
2008-10-18 00:00:00 | 88.89% Passed | 116.11 | 99.24 | 111.55 | 105 | 91
2009-04-18 00:00:00 | 90% Passed | 115.1 | 92.82 | 112.62 | 109.32 | 94
2009-10-17 00:00:00 | 60% Passed | 100.9 | 99.62 | 110.01 | 106.25 | 91
2010-04-17 00:00:00 | 75% Passed | 105.2 | 97.6 | 111.77 | 110.57 | 95
2010-10-16 00:00:00 | 90% Passed | 110 | 96.7 | 108.28 | 105.41 | 89
2011-04-16 00:00:00 | 77% Passed | 112.85 | 99.53 | 116.44 | 114.94 | 100
Spreadsheet: 685316d1593907987-dynamically-change-a-cell-value-based-on-a-range-of-over-values-sample_pricing_model_07-04-2020
Sheet: Value ranges

 |  |  |  |  | Enter discreet value | 275000 | 325000 | 370000 | 430000 | 835000 | 603000 | 945000 | 530000 | 782500 | 963000
 |  |  |  |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
 | Volume range from | Volume range to | Value
 | 251000 | 300000 | 187500 |  |  | 187500
 | 301000 | 350000 | 218250 |  |  |  | 218250
 | 351000 | 400000 | 246986.25 |  |  |  |  | 246986.25
 | 401000 | 450000 | 273801.9 |  |  |  |  |  | 273801.9
 | 451000 | 500000 | 298786.323375
 | 501000 | 550000 | 322025.2596375 |  |  |  |  |  |  |  |  |  | 322025.2596375
 | 551000 | 600000 | 343600.9520332125
 | 601000 | 650000 | 363592.2801515085 |  |  |  |  |  |  |  | 363592.2801515085
 | 651000 | 700000 | 382074.8877258768
 | 701000 | 750000 | 399121.3057936467
 | 751000 | 800000 | 414801.0713783971 |  |  |  |  |  |  |  |  |  |  | 414801.0713783971
 | 801000 | 850000 | 429180.8418528482 |  |  |  |  |  |  | 429180.8418528482
 | 851000 | 900000 | 442324.5051345917
 | 901000 | 950000 | 454293.285861763 |  |  |  |  |  |  |  |  | 454293.285861763
 | 951000 | 1000000 | 465145.8476906829 |  |  |  |  |  |  |  |  |  |  |  | 465145.8476906829
Spreadsheet: 002ff4e6-d470-495b-8139-1c76f4d5934b
Sheet: Sheet1

Date | Channel | Start (MYT) | Match | Notes
2012-03-01 00:00:00 | ASSP 2 (Ch 816) | 07:00:00 | Last 16 | Live
2012-03-01 00:00:00 | ASSP 2 (Ch 816) | 11:00:00 | Last 16 | Live
2012-03-02 00:00:00 | ASSP 2 (Ch 816) | 05:00:00 | Quarter Finals | Live
2012-03-03 00:00:00 | ASSP 2 (Ch 816) | 07:00:00 | Semi Final | Live
2012-03-03 00:00:00 | ASSP 2 (Ch 816) | 11:00:00 | Semi Final | Live
2012-03-04 00:00:00 | ASSP 2 (Ch 816) | 11:00:00 | Final | Live
Spreadsheet: 544132d1508772925-inserting-predefined-cells-using-button-budget-outline-copy
Sheet: Submission Report

 | Project Title
 | Project ID
 | Principal Investigator
 | Funder (Scheme)
 | Start Date
 | End Date
 | Project Duration
 | Lead Org Unit
 | Report Date
 | Status
 | Currency
 | Resource Summary
 | Summary funding heading | Funding heading | Full Economic Cost | Funder Contribution | %  Contribution
 | Directly Incurred
 |  | Staff | 0 | 0 | 1
 |  | Travel and Subsistence | 0 | 0
 |  | Equipment | 0 | 0 | 0
 |  | Other Costs | 0 | 0
 |  | Subtotal
 | Directly Allocated
 |  | Investigators | 0 | 0
 |  | Estates Costs |  | 0
 |  | Other Directly Allocated | 0 | 0
 |  | Subtotal
 | Indirect Costs
 |  | Indirect Costs |  | 0
 | Exceptions
 |  | Staff | 0 | 0 | 0
 |  | Other Costs | 0 | 0 | 0
 |  | Subtotal |  |  | 0
 | Total
 | Staff Costs
 | Principal Investigator |  | Directly Allocated
 | Staff Member Name
 | Role
 | Post Start Date
 | Post End Date
 | Post Duration/Months on Project
 | Post Duration/Weeks on Project
 | Hours Per Week |  | 4.125
 | Total Number of Hours to be worked
 | Full Time %
 | Starting [NAME] |  | 0
 | Grade
 | Effective Date Of Payscale
 | Increment Date
 | Basic Starting Salary
 | [NAME]
 | Other Allowance |  | 0
 | Superannuation + NI
 | [NAME] |  | 0
 | Cost Estimate
 |  |  | ADD NEW DA STAFF
 | Researcher |  | Directly Incurred
 | Staff Member Name
 | Role
 | Post Start Date
 | Post End Date
 | Post Duration/Months on Project
 | Post Duration/Weeks on Project
 | Hours Per Week
 | Total Number of Hours to be worked
 | Full Time %
 | Starting [NAME] |  | 0
 | Grade
 | Effective Date Of Payscale
 | Increment Date
 | Basic Starting Salary
 | [NAME]
 | Other Allowance |  | 0
 | Superannuation + NI
 | [NAME] |  | 0
 | Cost Estimate
 |  |  | ADD NEW DI STAFF
 | Non-Staff Costs
 | Directly Incurred | Budget Item Description | Cost | Quantity | Total (inc. VAT)
 | Travel and Subsistence
 | Subtotal
 | Consumables
 | Subtotal
 | Other Directly Incurred
 | Subtotal
 | Subcontractor
 | Subtotal
 | Equipment
 | Subtotal
 | Total
 | Exceptions | Budget Item Description | Cost | Quantity | Total (inc. VAT)
 |  |  |  |  | 0
 | Overhead Caculations
 | Estate Costs | Directly Allocated |  |  | Amount
 |  |  | 7260 |  | 0
 |  |  |  |  | 0
 | Indirect Costs | Indirect Costs
 |  |  | 38702 |  | 0
 |  |  |  |  | 0
Spreadsheet: 43594d1242235827-nested-if-statement-example-spreadsheet
Sheet: Sheet1

 | Car | 0 | No | Car | 0 | No | 1 | No | No | 1 | 1 | 1 | 1
 | House | 1 | House | No | 0 | No | 1 | No | 1 | 1 | 1 | 1 | 0
 | Car | 0 | No | 1 | Car | 0 | 1 | No | No | 0 | 1 | 0 | 1
 | Ship | 1 | No | Ship | 0 | No | 1 | No | 0 | 1 | 1 | 1 | 0
 |  | 1 | No | no | 0 | No | 1 | No | 0 | 1 | 1 | 1 | 0
 | I want B to show the word that is in each row, so for example I want B4 to say [NAME] and [NAME] to say House etc. The range is actually much bigger than I have show but this is just an example. There is also a chance that there wont be a word so in this case just to return a blank cell
Spreadsheet: 713453d1610724558-return-headers-from-matches-in-a-list-menu-items-and-inventory-gk-friday-
Sheet: Sort

[NAME] (single)
Purchase
1 EA
5
Whipped Cream (วิปปิ้งครีม)
Purchase
20 gr
3.084
[NAME]
Purchase
30 gr
4.16
[NAME]
Purchase
30 gr
3.75
Peanuts
Purchase
10 gr
0.781
[NAME] Pancakes
Purchase
3 EA
3.183
(CV) Vanilla Ice Cream Scoop
Sub-Recipe
3 EA
11.215
Mint
Purchase
5 gr
0.43
Butter Block
Purchase