tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 888790d1739369686-how-to-get-sum-and-avagerage-of-certain-text-using-subtotal-function-daily-problem-template-for-excel-help-forum
Sheet: Sheet1

Sr.No. | Trouble ID | Section | Name of Exchange | Start Date | Start time | End Date | End Time | Duration | Duration
1 | 879730 | Problem-1 | ABC | 03rd January, 2025 | 00:21:00 | 03rd January, 2025 | 04:48:00 | 4 hr. 27 min. | 04:27:00
2 | 54157 | Problem-2 | ABC | 09th January, 2025 | 15:20:00 | 09th January, 2025 | 19:44:00 | 4 hr. 24 min. | 04:24:00
3 | 135318 | Problem-3 | ABC | 13th January, 2025 | 12:24:00 | 14th January, 2025 | 02:41:00 | 14 hr. 17 min. | 14:17:00
4 | 208098 | Problem-4 | ABC | 16th January, 2025 | 20:11:00 | 16th January, 2025 | 21:48:00 | 1 hr. 37 min. | 01:37:00
5 | 944268 | Problem-5 | ABC | 05th January, 2025 | 20:28:00 | 06th January, 2025 | 02:39:00 | 6 hr. 11 min. | 06:11:00
6 | 12865 | Problem-1 | DEF | 07th January, 2025 | 17:55:00 | 07th January, 2025 | 21:41:00 | 3 hr. 46 min. | 03:46:00
7 | 218618 | Problem-2 | DEF | 17th January, 2025 | 10:19:00 | 17th January, 2025 | 23:53:00 | 13 hr. 34 min. | 13:34:00
8 | 333951 | Problem-3 | DEF | 22nd January, 2025 | 15:24:00 | 23rd January, 2025 | 14:27:00 | 9 hr. 42 min. | 09:42:00
9 | 359832 | Problem-4 | DEF | 23rd January, 2025 | 19:25:00 | 23rd January, 2025 | 22:49:00 | 3 hr. 24 min. | 03:24:00
10 | 414511 | Problem-1 | GHI | 26th January, 2025 | 12:33:00 | 26th January, 2025 | 18:34:00 | 6 hr. 01 min. | 06:01:00
11 | 999829 | Problem-2 | GHI | 07th January, 2025 | 06:12:00 | 07th January, 2025 | 09:54:00 | 3 hr. 42 min. | 03:42:00
12 | 252367 | Problem-3 | GHI | 19th January, 2025 | 01:27:00 | 19th January, 2025 | 03:06:00 | 1 hr. 39 min. | 01:39:00
13 | 840923 | Problem-4 | GHI | 01st January, 2025 | 09:21:00 | 01st January, 2025 | 11:11:00 | 1 hr. 50 min. | 01:50:00
14 | 922603 | Problem-5 | GHI | 05th January, 2025 | 03:12:00 | 05th January, 2025 | 09:53:00 | 6 hr. 41 min. | 06:41:00
15 | 137397 | Problem-6 | GHI | 13th January, 2025 | 14:09:00 | 13th January, 2025 | 18:51:00 | 4 hr. 42 min. | 04:42:00
16 | 150004 | Problem-1 | JKL | 14th January, 2025 | 05:21:00 | 14th January, 2025 | 10:34:00 | 5 hr. 13 min. | 05:13:00
17 | 161649 | Problem-2 | JKL | 14th January, 2025 | 16:43:00 | 14th January, 2025 | 22:34:00 | 5 hr. 51 min. | 05:51:00
18 | 163717 | Problem-3 | JKL | 14th January, 2025 | 18:23:00 | 15th January, 2025 | 07:49:00 | 13 hr. 26 min. | 13:26:00
19 | 175242 | Problem-4 | JKL | 15th January, 2025 | 09:27:00 | 15th January, 2025 | 12:32:00 | 3 hr. 05 min. | 03:05:00
Spreadsheet: c1c65821-064c-42c5-b632-2b7620ea73fb
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187938724 | Various | Insanity Of God | 2014-06-17 | Compact Disc | Ac | 5.99 | Y | NYP
Curb Records | 715187934122 | [NAME] | Glory All Around | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Curb Records | 715187934023 | [NAME] | Work Of Love | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Curb Records | 715187913820 | [NAME] | You Deliver Me | 2009-08-25 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187902527 | [NAME] | Relentless | 2008-02-12 | Compact Disc | Ac | 9.99 | Y | Available
Curb Records | 715187931824 | [NAME] | Some People Change | 2013-03-26 | Compact Disc | Pop | 13.99 | Y | Available
Curb Records | 715187935921 | [NAME] | Hurricane | 2013-10-15 | Compact Disc | Ac | 13.99 | Y | Available
Curb Records | 715187915725 | Plumb | Beautiful History: A Hits Collection | 2009-11-03 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187918825 | [NAME] | Love Revolution | 2010-08-24 | Compact Disc | Pop | 13.99 | Y | Available
Curb Records | 715187925120 | Mikeschair | Beautiful Life, A | 2011-08-23 | Compact Disc | Rock | 11.99 | Y | Available
Curb Records | 715187925021 | [NAME] | Hope Of The Broken World | 2011-08-23 | Compact Disc | Insp | 13.99 | Y | Available
Curb Records | 715187921627 | Dr. [NAME] | [NAME], The: The Definitive Collection | 2011-09-13 | Compact Disc | Insp | 24.98 | Y | Available
Curb Records | 715187882621 | [NAME] | [NAME] | 2004-08-10 | Compact Disc | Ac | 7.99 | Y | Available
Curb Records | 715187883420 | [NAME] | Hiding Place | 2004-05-25 | Compact Disc | Insp | 7.99 | Y | Available
Curb Records | 715187886025 | [NAME] | Awaken | 2005-03-22 | Compact Disc | Ac Pop | 7.99 | Y | Available
Curb Records | 715187889026 | [NAME] | Greatest Hymns ([NAME]) | 2005-08-23 | Compact Disc | Ac | 9.99 | Y | Available
Curb Records | 715187893122 | [NAME] | In Christ Alone-Greatest Hits ([NAME]) | 2006-06-27 | Compact Disc | Ac | 9.99 | Y | Available
Curb Records | 715187894426 | [NAME] | Bless The Broken Road: The Duets Album | 2006-08-08 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187895225 | [NAME] | Shadow Of Your Wings: Hymns And [NAME], The | 2006-10-24 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187931725 | Plumb | Need You Now | 2013-02-26 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187781221 | Oak Ridge Boys | Old Time Gospel Favorites | 2001-01-16 | Compact Disc | [NAME] | 7.99 | Y | Available
Curb Records | 715187732629 | Tennessee [NAME] | All Time Greatest Hymns | 2001-01-16 | Compact Disc | Country | 9.99 | Y | Available
Curb Records | 715187793828 | [NAME] | Be Still My Soul | 2001-01-16 | Compact Disc | Ac Pop | 7.99 | Y | Available
Curb Records | 715187871328 | [NAME] | Press On | 2001-05-29 | Compact Disc | Insp | 5.99 | Y | Available
Curb Records | 715187873421 | [NAME] | Stronger | 2002-02-20 | Compact Disc | Ac | 5.99 | Y | Available
Spreadsheet: 00b27eb0-08b6-47b4-820b-7e9bc21f43fd
Sheet: Statistical Functions

Average |  | Count |  | CountA |  | CountIF |  | [NAME] |  | Min
34 |  | 34 |  | [NAME] |  | Yes |  | 190 |  | 190
56 |  | 56 |  | Smith |  | No |  | 90 |  | 90
23 |  | 23 |  |  |  | No |  | 87 |  | 87
30 |  | 30 |  | Smith |  | No |  | 298 |  | 298
40 |  | 40 |  |  |  | No |  | 390 |  | 390
35 |  | 35 |  | [NAME] |  | Yes |  | 192 |  | 192
67 |  | 67 |  | [NAME] |  | Yes |  | 390 |  | 390
98 |  | 98 |  | [NAME] |  | Yes |  | 402 |  | 402
 |  |  |  | Smithers |  | No |  | 89 |  | 89
 |  |  |  |  |  | No |  | 76 |  | 76
 |  |  |  |  |  | No |  | 47 |  | 47
 |  |  |  |  |  | No |  | 80 |  | 80
Spreadsheet: 228387d1366105079-please-help-me-d-table-of-info
Sheet: Sheet1

 | Unit prices
Product | Units 1+ | Units 12+ | Units 20+
Fleece | 17.75 | 17.25 | 16.95
Hardshell | 44.95 | 42.98 | 40
Softshell | 22.95 | 21.55 | 20.05
 | Transfer art work cost
 |  | Units 1+ | Units 20+
Unit Price |  | 10.5 | 7.5
 | [NAME] work cost
Machine set up cost |  |  | 35
Unit price |  |  | 3.5
 | Packaging
Bagging per item |  |  | 0.25
postage per box ([NAME] 12 items) |  |  | 5.99
 | Taxes
VAT rate |  |  | 0.2
Spreadsheet: 30825d1226514233-selecting-specific-value-within-a-range-indicators
Sheet: Sheet1

Indicator | Score | % |  | Score | %
O |  | 0.06 |  | 71 | 0.03
F | 40 | 0 |  | 98 | 0.055
E | 51 | 0.02 |  | 112 | 0.09
D | 70 | 0.03
D | 71.5 | 0.035
D | 80.5 | 0.04
C | 90 | 0.05
C | 91.5 | 0.055
C | 100.5 | 0.06
B | 105 | 0.07
B | 106.5 | 0.085
B | 110.5 | 0.09
A | 114 | 0.1
Spreadsheet: drew_fossum__8688__Scott exp 12-08-00
Sheet: Short Form

 |  |  | Enron Corp
 |  |  | Employee Expense Report |  |  |  |  |  |  |  |  | EXP | 2000-12-08 00:00:00
 |  |  | Short Form |  |  |  |  |  |  | Page | 1 | of
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  | EMPLOYEE NUMBER
Scott |  |  |  | [NAME] |  |  | Sr. Counsel |  |  | P00505330
COMPANY NUMBER |  |  |  | OFFICE NUMBER/FIELD LOCATION |  |  |  |  |  | PHONE NUMBER FOR QUESTIONS
0366 |  |  |  | EB4788 |  |  |  |  |  | [PHONE]
MEALS AND ENTERTAINMENT -  Enter the cost of all meals (including food charges from hotel receipts) and entertainment.  Attach guest list for entertainment expense.
Meal: B = Breakfast, L = Lunch, D = Dinner, R = Refreshments, T = Travel Status.  See the Accounts Payable information page at http://hrweb.enron.com/accts/index.asp for detailed instructions.
Date | Meal |  | Location and Business Purpose |  |  |  | Guests |  |  |  | Cost/Quantity | Rate | $ [NAME]
ACCOUNT CODING - For multiple lines of coding, use supplemental page. |  |  |  |  |  |  |  |  |  |  | MEALS THIS PAGE
GL Acct      Asset | GL Co       Tr Ptr |  | Cost Center                  WBS Element |  |  | Order                                      Network |  | Material        Activity | Plant                            Func Area |  | MEALS, SUPP PAGES
 |  | 111679 |  |  |  |  |  |  |  |  | TOTAL MEALS
[NAME] all other expenses (memberships, fees, supplies, mileage, etc.) not associated with business transportation or lodging.
Date |  |  |  |  | Description |  |  |  |  |  | Cost/Quantity | Rate | $ [NAME]
2000-11-15 00:00:00 | PrimeCo - monthly cell phone service from 10/15/00 to 11/14/00. |  |  |  |  |  |  |  |  |  | 37.83
ACCOUNT CODING - For multiple lines of coding, use supplemental page. |  |  |  |  |  |  |  |  |  |  | MISC THIS PAGE
GL Acct      Asset | GL Co       Tr Ptr |  | Cost Center                  WBS Element |  |  | Order                                      Network |  | Material        Activity | Plant                            Func Area |  | MISC., SUPP PAGES
52503500 | 0366 | 111679 |  |  |  |  |  | 9000021 |  |  | TOTAL MISC
This section used in conjunction with all expense reports. |  |  |  |  |  |  |  |  | Total Travel  (attach Summary)
ADVANCES TO BE CLEARED |  |  |  |  |  |  |  |  | Total Expenses (travel, entertainment, [NAME].)
DATE |  | CO. |  | AMOUNT |  |  |  |  | Less: Total Advances
DATE |  | CO. |  | AMOUNT |  |  |  |  | Balance Due: |  |  | Company
DATE |  | CO. |  | AMOUNT |  |  |  |  |  |  |  | Employee
 |  |  | TOTAL ADVANCES |  |  |  |  |  | Personal Check Amount
SIGNATURES
I have paid the amount shown on this statement for necessary expenses incurred on behalf of the Company.  Original receipts are attached or have been mailed to Accounts Payable.
EMPLOYEE |  |  |  |  | DATE | APPROVAL |  |  |  | DATE | APPROVAL |  | DATE
Revised 7/1/00 |  |  |  |  |  | (Print Name) |  |  |  |  | (Print Name)
lname | fname | expdate | socsec | bal | code | sform | trav | mealsup | miscsup | travsup2 | mealsup2 | miscsup2 | cono
 |  |  |  |  | 1 | 2
Spreadsheet: 20bddffa-38c8-4ab4-a472-e6722e57ee79
Sheet: Financial Position

Farm & Ranch Land Protection Program (FRPP)
Financial Position
Entity:
County:
Cash and Investments
Easement Commitments
Uncommitted funds currently available
Estimated Operations next 12 Months:
Transfer Tax Revenues
Administrative & Overhead
Other Easement Commitments Planned
Net available
Available for USDA Match
Print Name: |  |  |  | Title:
Phone: |  |  |  | E-Mail:
Signature: |  |  |  |  | Date:
Spreadsheet: 14b7e98f-9fa8-4d1e-a162-27196f94f2b4
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2013/14 |  |  | 2012/13 |  |  | 2011/12
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 12.08 | 12.43 |  | 11.91 | 12.13 |  | 14.08 | 14.4
September | 11.87 | 12.22 |  | 12.57 | 12.81 |  | 15.09 | 15.44
October | 11.95 | 12.3 |  | 12.72 | 12.97 |  | 15.63 | 15.99
November | 11.78 | 12.13 |  | 12.92 | 13.17 |  | 14.93 | 15.28
December | 11.93 | 12.29 |  | 12.62 | 12.86 |  | 13.9 | 14.21
January 2/ | 11.84 | 12.19 |  | 12.35 | 12.59 |  | 12.61 | 12.88
February |  |  |  | 11.77 | 12.43 |  | 11.81 | 12.2
March |  |  |  | 12.16 | 12.84 |  | 11.52 | 11.92
April |  |  |  | 12.18 | 12.86 |  | 11.15 | 11.54
May |  |  |  | 12.08 | 12.75 |  | 11.42 | 11.82
June |  |  |  | 12.17 | 12.85 |  | 11.93 | 12.35
July |  |  |  | 12.18 | 12.86 |  | 11.97 | 12.4
Market-year
average 1/ | 11.90833333333333 | 12.26 |  | 12.3025 | 12.76 |  | 13.00333333333334 | 13.36916666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated January 10, 2013.
Spreadsheet: 27651d1221070899-subtotal-by-item-in-a-pivottable-pivot-by-item
Sheet: Pivot Data

Business | Subgroup | Month | Amount
1 | A | January | 52
1 | A | February | 77
1 | A | March | 70
1 | B | January | 22
1 | B | February | 12
1 | B | March | 49
1 | C | January | 93
1 | C | February | 33
1 | C | March | 85
2 | D | January | 37
2 | D | February | 56
2 | D | March | 53
2 | E | January | 86
2 | E | February | 16
2 | E | March | 93
2 | F | January | 34
2 | F | February | 30
2 | F | March | 94
3 | G | January | 87
3 | G | February | 2
3 | G | March | 84
3 | H | January | 93
3 | H | February | 11
3 | H | March | 89
3 | I | January | 21
3 | I | February | 3
3 | I | March | 11
Spreadsheet: 161063d1339397696-find-nearest-higher-value-nearest-value2
Sheet: Sheet1

Value | Match #1 | Match #2 | Match #3 | Match #4 |  | Result | Should Be
0.9438 | 0.94215 | 0.9371 | 0.951 | 0.9511 |  | 0.951 | 0.951
0.9286 | 0.9221 | 0.9202 | 0.9218 | 0.9217 |  | #N/A | 0.92205 | > can't find the error some of the numbers are 5 decimal they are not rounded.
0.9198 | 0.9209499999999999 | 0.9195666666666665 | 0.9245 | 0.9246 |  | 0.9209499999999999 | 0.9209499999999999 | but actually its returning .9221
0.9246 | 0.9209499999999999 | 0.9195666666666665 | 0.9245 | 0.9246 |  | 0.9246 | 0.9246
0.9113 | 0.9111 | 0.9089666666666667 | 0.9176 | 0.918 |  | 0.9176 | 0.9176
0.9144 | 0.9145000000000001 | 0.9137333333333334 | 0.9212 | 0.9213 |  | 0.9145000000000001 | 0.9145000000000001
0.9155 | 0.9145000000000001 | 0.9137333333333334 | 0.9212 | 0.9213 |  | 0.9212 | 0.9212
0.9149 | 0.9145000000000001 | 0.9137333333333334 | 0.9212 | 0.9213 |  | 0.9212 | 0.9212
0.9066 | 0.90725 | 0.9061666666666667 | 0.909 | 0.9093 |  | 0.90725 | 0.90725
 |  |  |  |  |  |  |  |  |  | INDEX($A$1:$A$4,MIN(IF($A$1:$A$4>=B1,ROW(A1:A4)-ROW(A1)+1,ROWS(A1:A4))))
 |  |  |  |  |  | 0.951
 |  | click on the red above |  |  |  | #N/A
 |  | check also the formating. |  |  |  | 0.9209499999999999 |  | look at this it return 5 decimal because the number is actually five
 |  |  |  |  |  | 0.9246
 |  |  |  |  |  | 0.9176
 |  |  |  |  |  | 0.9145000000000001
 |  |  |  |  |  | 0.9212
Spreadsheet: 68194d1268748346-to-vlookup-or-not-to-vlookup-textindexmatch
Sheet: Sheet1

name | phone | email
a | 1 | [EMAIL]
b | 2 | [EMAIL]
c | 3 | [EMAIL]
d | 4 | [EMAIL]
e | 5
f | 6
g | 7
h | 8
Spreadsheet: 105147d1302604952-search-typed-string-and-paste-related-content-book1_deksiberu
Sheet: Sheet1

devicename | StartDate | EndDate |  |  |  |  |  |  |  |  |  |  | devicename | StartDate | EndDate
E63 | 2010-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | E72 | 2010-03-01 00:00:00 | 2010-03-06 00:00:00
E63 | 2010-03-02 00:00:00 | 2010-03-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | E71 | 2010-03-02 00:00:00 | 2010-03-08 00:00:00
E71 | 2010-03-10 00:00:00 | 2010-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | E63 | 2010-03-02 00:00:00 | 2010-03-08 00:00:00
E71 | 2010-03-02 00:00:00 | 2010-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  | E63 | 2010-03-08 00:00:00 | 2010-03-12 00:00:00
E72 | 2010-03-10 00:00:00 | 2010-03-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | E72 | 2010-03-10 00:00:00 | 2010-03-13 00:00:00
E72 | 2010-03-01 00:00:00 | 2010-03-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | E71 | 2010-03-10 00:00:00 | 2010-03-14 00:00:00
Spreadsheet: 707611d1607363158-find-the-last-occurrence-of-cell-value-after-matching-date-sample-previous-occasion
Sheet: Duty Rota

CACS Duty Rota - Year: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Day | Role | Name | Duty Manager | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duty Officer
Please enter the YEAR (1st April): |  | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duty Officer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duty Officer
Which Month? | February |  |  |  | Which Month? | December |  |  |  | Which Month? | January |  |  |  |  |  |  |  |  |  | Duty Officer
 |  | (Use Dropdown) |  |  |  |  | (Use Dropdown) |  |  |  |  | (Use Dropdown)
Column1 | Column2 | Column3 | Column4 |  | Column1 | Column2 | Column3 | Column4 |  | Column1 | Column2 | Column3 | Column4 |  |  |  |  |  |  |  | Duty Officer
 |  |  | Comments |  |  |  |  | Comments |  |  |  |  | Comments |  |  |  |  |  | CalendarD | WorkD | Day | Officer | [NAME] | StartDate | EndDate
 |  | A Person |  |  |  | Duty Manager | A Person |  |  |  | Duty Manager | B Person
 |  | Holiday |  |  |  |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | A Person
 |  | Rachel |  |  |  |  | Mark |  |  |  |  | [NAME] |  |  |  | Months
 |  | Sue |  |  |  |  |  |  |  |  |  | Cas |  |  |  | January
 |  |  |  |  |  |  | C Person |  |  |  |  | Lome |  |  |  | February
 |  | B Person |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  | March
 |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | Caster |  |  |  | April
 |  | [NAME] |  |  |  |  | Wally |  |  |  |  |  |  |  |  | May
 |  | [NAME] |  |  |  |  | Dolly |  |  |  |  | G Person |  |  |  | June
 |  | Fred |  |  |  |  | Polly |  |  |  |  | Ole |  |  |  | July
 |  | Kelly |  |  |  |  |  |  |  |  |  | Dolly |  |  |  | August
 |  |  |  |  |  |  | E Person |  |  |  |  | [NAME] |  |  |  | September
 |  | C Person |  |  |  |  | Jasper |  |  |  |  | [NAME] |  |  |  | October
 |  | [NAME] |  |  |  |  | Neville |  |  |  |  | [NAME] |  |  |  | November
 |  | [NAME] |  |  |  |  | Vic |  |  |  |  |  |  |  |  | December
 |  | [NAME] |  |  |  |  | Tic |  |  |  |  | D Person |  |  |  | Year End
 |  | [NAME] |  |  |  |  | Toc |  |  |  |  | [NAME]
 |  | Lola |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Fiscal Month
 |  | [NAME] |  |  |  |  | B Person |  |  |  |  | [NAME] |  |  |  | 4
 |  | D Person |  |  |  |  | One |  |  |  |  | Neville
 |  | Apple |  |  |  |  | Two |  |  |  |  | [NAME]
 |  | Orange |  |  |  |  | Three
 |  | Kiwi |  |  |  |  | Four |  |  |  |  | B Person
 |  | Lemon |  |  |  |  | Five |  |  |  |  | [NAME]
 |  | Grape |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | F Person |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] |  |  |  |  | Jon
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Rocky
Spreadsheet: 586247d1534272076-concatenating-based-on-conditions-sampledataset
Sheet: Sheet1

Question | Qualifier | Desired Result
PLJ | R | PLJ_r
PLJ
PLJ | R | PLJ_r
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ
PLJ | R | PLJ_r
PLJ | R | PLJ_r
PLJ | R | PLJ_r
PLJ | R | PLJ_r
Spreadsheet: 169263d1342760520-addidtional-calculation-and-conditional-formating-within-pivot-table-calculation-and-conditional-formating-with-in-the-pivot-table
Sheet: Data

Period | Customer | Sales |  | Pivot table
1.2012 | ABB | 200 |  | Sum of Sales | Period
1.2012 | ABC | 100 |  | Customer | 1.2012 | 2.2012 | 3.2012 | 4.2012 | 5.2012 | 6.2012 | 7.2012 | Grand Total
1.2012 | ABD | 358 |  | ABB | 200 | 243 | 324 | 456 | 345 | 658 | 124 | 2350
2.2012 | ABB | 243 |  | ABC | 100 | 276 | 578 | 56 | 567 | 568 | 897 | 3042
2.2012 | ABC | 276 |  | ABD | 358 | 456 | 987 | 456 | 45 | 555 | 23 | 2880
2.2012 | ABD | 456 |  | ABE |  | 321 | 443 |  |  |  |  | 764
2.2012 | ABE | 321 |  | Grand Total | 658 | 1296 | 2332 | 968 | 957 | 1781 | 1044 | 9036
3.2012 | ABB | 324
3.2012 | ABC | 578 |  | I need to include three columns in the pivot table
3.2012 | ABD | 987
3.2012 | ABE | 443 |  | July Extrapolated |  | Average of Last 5 months (Feb Mar, April,May, June) |  |  |  |  | Comparisson of July Extrapolated with Average
4.2012 | ABB | 456 |  | 181.8666666666667 |  | 405.2 |  |  |  |  | 0.4488318525830866
4.2012 | ABC | 56 |  | 1315.6 |  | 409 |  |  |  |  | 3.216625916870415
4.2012 | ABD | 456 |  | 33.73333333333333 |  | 499.8
5.2012 | ABB | 345
5.2012 | ABC | 567
5.2012 | ABD | 45
6.2012 | ABB | 658
6.2012 | ABC | 568
6.2012 | ABD | 555 |  |  |  |  |  |  |  |  | If [NAME] figures is better than average, colour of cell to be green with % calculation
7.2012 | ABB | 124
7.2012 | ABC | 897 |  | July Data  is not full month data. There are 22 working days in july
7.2012 | ABD | 23 |  | This data is for 15  days in July. So I have to extrapolate it to reflect full month value
 |  |  |  | Not sure if this is the right way to extrapolate. Or can we use a trend analysis formula or something else based on the last 6 months data ??
Spreadsheet: 840800d1692991809-conditional-formatting-with-dates-from-a-cell-plus-days-conditional-formatting-1-
Sheet: Sheet1

Conf Date | Change to Date |  |  | Conf Date | Change to Date |  |  | Conf Date | Change to Date
2023-09-19 00:00:00 | 2023-10-02 00:00:00 |  |  | 2023-09-19 00:00:00 | 2023-10-02 00:00:00 |  |  | 2023-09-19 00:00:00 | 2023-10-02 00:00:00
2023-09-19 00:00:00 | 2023-10-02 00:00:00 |  |  | 2023-09-19 00:00:00 | 2023-10-02 00:00:00 |  |  | 2023-09-19 00:00:00 | 2023-10-02 00:00:00
2023-10-11 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-10-11 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-10-11 00:00:00 | 2023-11-02 00:00:00
2023-09-29 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-09-29 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-09-29 00:00:00 | 2023-11-02 00:00:00
2023-12-21 00:00:00 | 2024-02-28 00:00:00 |  |  | 2023-12-21 00:00:00 | 2024-02-28 00:00:00 |  |  | 2023-12-21 00:00:00 | 2024-02-28 00:00:00
2023-10-19 00:00:00 | 2023-11-03 00:00:00 |  |  | 2023-10-19 00:00:00 | 2023-11-03 00:00:00 |  |  | 2023-10-19 00:00:00 | 2023-11-03 00:00:00
2023-10-18 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-11-02 00:00:00
2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00
2023-10-18 00:00:00 | 2024-01-25 00:00:00 |  |  | 2023-10-18 00:00:00 | 2024-01-25 00:00:00 |  |  | 2023-10-18 00:00:00 | 2024-01-25 00:00:00
2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00
2023-10-18 00:00:00 | 2023-12-07 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-07 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-07 00:00:00
2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00
2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00
2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00
2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00 |  |  | 2023-10-18 00:00:00 | 2023-12-14 00:00:00
2023-09-13 00:00:00 | 2024-03-14 00:00:00 |  |  | 2023-09-13 00:00:00 | 2024-03-14 00:00:00 |  |  | 2023-09-13 00:00:00 | 2024-03-14 00:00:00
2023-10-11 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-10-11 00:00:00 | 2023-11-02 00:00:00 |  |  | 2023-10-11 00:00:00 | 2023-11-02 00:00:00
2023-09-20 00:00:00 | 2024-01-26 00:00:00 |  |  | 2023-09-20 00:00:00 | 2024-01-26 00:00:00 |  |  | 2023-09-20 00:00:00 | 2024-01-26 00:00:00
2023-09-20 00:00:00 | 2023-10-06 00:00:00 |  |  | 2023-09-20 00:00:00 | 2023-10-06 00:00:00 |  |  | 2023-09-20 00:00:00 | 2023-10-06 00:00:00
2023-09-18 00:00:00 | 2023-10-10 00:00:00 |  |  | 2023-09-18 00:00:00 | 2023-10-10 00:00:00 |  |  | 2023-09-18 00:00:00 | 2023-10-10 00:00:00
Spreadsheet: 166403d1341579577-auto-populating-a-spreadsheet-training-example-2-
Sheet: Training matrix

 |  | IOSH Working Safely | Asbestos Awareness | Ladders and Steps
Surname 1 | Forename 1
Surname 2 | Forename 2
Surname 3 | Forename 3
Surname 4 | Forename 4
Surname 5 | Forename 5