tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845871d1697194575-transform-time-ranges-to-hourly-values-example
Sheet: Sheet1

Input |  |  |  | Output
Quality | Start | End |  | Hour | 2023-10-15 00:00:00 | 2023-10-16 00:00:00 | 2023-10-17 00:00:00 | 2023-10-18 00:00:00
1 | 2023-10-15 00:00:00 | 2023-10-16 04:00:00 |  | 00:00:00 | 1 | 1 | 3 | 2
2 | 2023-10-16 04:00:00 | 2023-10-16 18:00:00 |  | 01:00:00 | 1 | 1 | 3 | 2
3 | 2023-10-16 18:00:00 | 2023-10-17 07:00:00 |  | 02:00:00 | 1 | 1 | 3 | 2
2 | 2023-10-17 07:00:00 | 2023-10-18 04:00:00 |  | 03:00:00 | 1 | 1 | 3 | 2
 |  |  |  | 04:00:00 | 1 | 1 | 3 | 2
 |  |  |  | 05:00:00 | 1 | 2 | 3 | 2
 |  |  |  | 06:00:00 | 1 | 2 | 3 | 2
 |  |  |  | 07:00:00 | 1 | 2 | 3 | 2
 |  |  |  | 08:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 09:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 10:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 11:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 12:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 13:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 14:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 15:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 16:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 17:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 18:00:00 | 1 | 2 | 2 | 2
 |  |  |  | 19:00:00 | 1 | 3 | 2 | 2
 |  |  |  | 20:00:00 | 1 | 3 | 2 | 2
 |  |  |  | 21:00:00 | 1 | 3 | 2 | 2
 |  |  |  | 22:00:00 | 1 | 3 | 2 | 2
 |  |  |  | 23:00:00 | 1 | 3 | 2 | 2
Spreadsheet: 145319d1331530890-sheet-number-to-be-dynamic-in-the-formula-test-
Sheet: 3

 | Date
 | Total Invoices to be Processed
 | Total Invoices Processed
 | Total Pending
 | MTD Invoices Processed
 | Description | [NAME] |  | Assigned to |  | Status |  | Pending
 |  | Imported | Approved | Imported | Approved | Imported | Approved | Imported | Approved
Spreadsheet: 142367d1329795948-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: AT&T Natnl

 |  | WEEK 13 AT&T National
 |  | Total Earnings |  |  |  | Rankings Through Week 13 | Total
 |  |  |  | YTD
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
Spreadsheet: 129293d1321539406-match-with-a-parametric-table-array-that-links-to-different-files-sample
Sheet: File

Cariche | Alky | Alky | 01- | 02- | 03- | 04- | 05- | 06- | 07- | 08- | 09- | 10-
 | Alky | Cariche | Gennaio | [NAME] | Marzo | Aprile | Maggio | [NAME] | Luglio | [NAME] | Settembre | Ottobre
 | Alky | 1
 | Alky | 2
 | Alky | 3
 | Alky | 4
 | Alky | 5
 | Alky
 | Alky | Produzioni
 | Alky | 1
 | Alky | 2
 | Alky | 3
 | Alky | 4
 | Alky | 5
 | Alky
 | CR | CRR
 | CR | Cariche
 | CR | 1
 | CR | 2
 | CR | 3
 | CR | 4
 | CR | 5
 | CR
 | CR | Produzioni
 | CR | 1
 | CR | 2
 | CR | 3
 | CR | 4
 | CR | 5
 | CR
 | FC | FCC
 | FC | Cariche
 | FC | 1
 | FC | 2
 | FC | 3
 | FC | 4
 | FC | 5
 | FC
 | FC | Produzioni
 | FC | 1
 | FC | 2
 | FC | 3
 | FC | 4
 | FC | 5
 | FC
 | MH | MHC
 | MH | Cariche
 | MH | 1
 | MH | 2
 | MH | 3
 | MH | 4
 | MH | 5
 | MH
 | MH | Produzioni
 | MH | 1
 | MH | 2
 | MH | 3
 | MH | 4
 | MH | 5
 | MH
 | MH | MHC2
 | MH | Cariche
 | MH | 1
 | MH | 2
 | MH | 3
 | MH | 4
 | MH | 5
 | MH
 | MH | Produzioni
 | MH | 1
 | MH | 2
 | MH | 3
 | MH | 4
 | MH | 5
 | MH
 | rt | [NAME]
 | rt | Cariche
 | rt | 1
 | rt | 2
 | rt | 3
 | rt | 4
 | rt | 5
 | rt
 | rt | Produzioni
 | rt | 1
 | rt | 2
 | rt | 3
 | rt | 4
 | rt | 5
 | rt
 | t1 | t1
 | t1 | Cariche
 | t1 | 1
 | t1 | 2
 | t1 | 3
 | t1 | 4
 | t1 | 5
 | t1
 | t1 | Produzioni
 | t1 | 1
 | t1 | 2
 | t1 | 3
 | t1 | 4
 | t1 | 5
 | t1
 | t2 | t2
 | t2 | Cariche
 | t2 | 1
 | t2 | 2
 | t2 | 3
 | t2 | 4
 | t2 | 5
 | t2
 | t2 | Produzioni
 | t2 | 1
 | t2 | 2
 | t2 | 3
 | t2 | 4
 | t2 | 5
 | t2
 | u3 | u300
 | u3 | Cariche
 | u3 | 1
 | u3 | 2
 | u3 | 3
 | u3 | 4
 | u3 | 5
 | u3
 | u3 | Produzioni
 | u3 | 1
 | u3 | 2
 | u3 | 3
 | u3 | 4
 | u3 | 5
 | u3
 | u4 | u400
 | u4 | Cariche
 | u4 | 1
 | u4 | 2
 | u4 | 3
 | u4 | 4
 | u4 | 5
 | u4
 | u4 | Produzioni
 | u4 | 1
 | u4 | 2
 | u4 | 3
 | u4 | 4
 | u4 | 5
 | u4
 | u5 | u500
 | u5 | Cariche
 | u5 | 1
 | u5 | 2
 | u5 | 3
 | u5 | 4
 | u5 | 5
 | u5
 | u5 | Produzioni
 | u5 | 1
 | u5 | 2
 | u5 | 3
 | u5 | 4
 | u5 | 5
 | u5
 | u7 | u700
 | u7 | Cariche
 | u7 | 1
 | u7 | 2
 | u7 | 3
 | u7 | 4
 | u7 | 5
 | u7
 | u7 | Produzioni
 | u7 | 1
 | u7 | 2
 | u7 | 3
 | u7 | 4
 | u7 | 5
 | u7
 | u8 | u800
 | u8 | Cariche
 | u8 | 1
 | u8 | 2
 | u8 | 3
 | u8 | 4
 | u8 | 5
 | u8
 | u8 | Produzioni
 | u8 | 1
 | u8 | 2
 | u8 | 3
 | u8 | 4
 | u8 | 5
 | u8
 | vs | vsb
 | vs | Cariche
 | vs | 1
 | vs | 2
 | vs | 3
 | vs | 4
 | vs | 5
 | vs
 | vs | Produzioni
 | vs | 1
 | vs | 2
 | vs | 3
 | vs | 4
 | vs | 5
 | vs
 | v1 | v1
 | v1 | Cariche
 | v1 | 1
 | v1 | 2
 | v1 | 3
 | v1 | 4
 | v1 | 5
 | v1
 | v1 | Produzioni
 | v1 | 1
 | v1 | 2
 | v1 | 3
 | v1 | 4
 | v1 | 5
 | v1
 | v2 | v2
 | v2 | Cariche
 | v2 | 1
 | v2 | 2
 | v2 | 3
 | v2 | 4
 | v2 | 5
 | v2
 | v2 | Produzioni
 | v2 | 1
 | v2 | 2
 | v2 | 3
 | v2 | 4
 | v2 | 5
Spreadsheet: 220696d1363237701-sum-if-formula-financial-accounting-columbia-cu-checking-working-correctly
Sheet: Categories

[Categories]
***** ADDITIONS *****
AV Cash Deposits
AV ACH Qwest Pension
AV ACH Social Security
AV ACH US Treasury
AV US Treasury Tax Refund
AV Account Earned Interest
AV Check Deposits
AV Starting Account Balance
[NAME]
***** ADDITIONS *****
AP Cash Deposits
AP Transfer Deposits
***** SUBTRACTIONS *****
***** AV EXPENSES *****
AV ACH Withdrawals
AV Cash Withdrawals
AV Check Withdrawals
[NAME]
AV Debit Withdrawals
AV Account Fees
***** AP EXPENSES *****
AP Cash Withdrawals
AP ACH Withdrawals
AP Check Withdrawals
AP Debit Withdrawals
AP Transfer Withdrawals
AP Overdraft Fees
***** UNKNOWN EXPENSE *****
Unknown Check Withdrawals
***** HOUSEHOLD EXPENSES *****
Household ACH Withdrawals
[NAME]
Household Debit Withdrawals
***** ACCOUNT FEES *****
Account Overdraft Fees
Spreadsheet: 803998d1667837892-formula-to-create-a-date-from-a-cell-value-date-help
Sheet: Data

PASTE | PASTE | PASTE | PASTE | FORMULA
Date | Transaction ID | Amount | Currency | Dupe? | Correct Date | [NAME]
2022-05-11 00:00:00 | 5497070997073281-10946658 | 250 | USD
2022-02-11 00:00:00 | 5556711977775848-10924633 | 250 | USD
30/10/2022 | 5497539000359807-10905167 | 175 | USD
Spreadsheet: 859214d1707676192-recursive-lambda-samplefile
Sheet: Sheet1

MGRNAME | MGRID | EENAME | EEID | HLVL |  | [NAME] |  |  |  | [NAME] HD
[NAME] | 123 | [NAME] | 134 | 1 |  |  | Direct | Indirect |  |  | Direct | Indirect
[NAME] | 123 | [NAME] | 145 | 1 |  | [NAME] | 4 | 6 |  | [NAME] | 3 | 5
[NAME] | 123 | [NAME] | 198 | 1 |  | [NAME] | 3 | 5 |  | [NAME] | 5 | 0
[NAME] | 123 | [NAME] | 156 | 1 |  | [NAME] | 3 | 5 |  | [NAME] | 5 | 8
[NAME] | 134 | [NAME] | 456 | 2 |  | [NAME] | 5 | 8 |  | [NAME] | 3 | 5
[NAME] | 134 | [NAME] | 845 | 2 |  | [NAME] | 5 | 0 |  | [NAME] | 4 | 6
[NAME] | 134 | [NAME] | 334 | 2 |  | Missy Rower | 8 | 0 |  | Missy Rower | 8 | 0
[NAME] | 145 | [NAME] | 688 | 2
[NAME] | 145 | [NAME] | 543 | 2
[NAME] | 145 | [NAME] | 789 | 2
[NAME] | 543 | [NAME] | 877 | 3
[NAME] | 543 | [NAME] | 455 | 3
[NAME] | 543 | [NAME] | 322 | 3
[NAME] | 543 | Missy Rower | 111 | 3
[NAME] | 543 | [NAME] | 226 | 3
[NAME] | 456 | Carm Gower | 833 | 3
[NAME] | 456 | [NAME] | 412 | 3
[NAME] | 456 | [NAME] | 288 | 3
[NAME] | 456 | [NAME] | 999 | 3
[NAME] | 456 | [NAME] | 733 | 3
Missy Rower | 111 | [NAME] | 311 | 4
Missy Rower | 111 | [NAME] | 855 | 4
Missy Rower | 111 | [NAME] | 357 | 4
Missy Rower | 111 | [NAME] | 880 | 4
Missy Rower | 111 | [NAME] | 343 | 4
Missy Rower | 111 | [NAME] | 661 | 4
Missy Rower | 111 | [NAME] | 222 | 4
Missy Rower | 111 | [NAME] | 187 | 4
Spreadsheet: 747019d1631184596-how-many-names-are-common-between-lists-and-how-many-are-not-in-any-list-compare-3-lists-for-all-and-neither-match
Sheet: Webinar

Violet
Nova
[NAME]
[NAME]
Zoe
Ava
Charlotte
Sophia
Amelia
[NAME]
[NAME]
[NAME]
Harper
Camila
[NAME]
[NAME]
Luna
Ella
[NAME]
Sofia
Emily
Avery
Mila
[NAME]
Eleanor
[NAME]
Layla
Penelope
Aria
Chloe
With Webinar
Webinar Only
All 3
Spreadsheet: 16e00fe3-a209-454e-9562-9b8d0a702559
Sheet: บัตรเลือกตั้ง

บัตรเลขที่ ....................... |  |  | บัตรเลขที่ ....................... |  |  | บัตรเลขที่ .......................
บัตรลงคะแนนเลือกตั้งประธานนักเรียน |  |  | บัตรลงคะแนนเลือกตั้งประธานนักเรียน |  |  | บัตรลงคะแนนเลือกตั้งประธานนักเรียน
โรงเรียนสามแยกบางคูลัด |  |  | โรงเรียนสามแยกบางคูลัด |  |  | โรงเรียนสามแยกบางคูลัด
ประจำปีการศึกษา  ๒๕๕๕ |  |  | ประจำปีการศึกษา  ๒๕๕๕ |  |  | ประจำปีการศึกษา  ๒๕๕๕
หมายเลข | ช่อง X |  | หมายเลข | ช่อง X |  | หมายเลข | ช่อง X
1 |  |  | 1 |  |  | 1
2 |  |  | 2 |  |  | 2
3 |  |  | 3 |  |  | 3
4 |  |  | 4 |  |  | 4
5 |  |  | 5 |  |  | 5
6 |  |  | 6 |  |  | 6
7 |  |  | 7 |  |  | 7
บัตรเลขที่ ....................... |  |  | บัตรเลขที่ ....................... |  |  | บัตรเลขที่ .......................
บัตรลงคะแนนเลือกตั้งประธานนักเรียน |  |  | บัตรลงคะแนนเลือกตั้งประธานนักเรียน |  |  | บัตรลงคะแนนเลือกตั้งประธานนักเรียน
โรงเรียนสามแยกบางคูลัด |  |  | โรงเรียนสามแยกบางคูลัด |  |  | โรงเรียนสามแยกบางคูลัด
ประจำปีการศึกษา  ๒๕๕๕ |  |  | ประจำปีการศึกษา  ๒๕๕๕ |  |  | ประจำปีการศึกษา  ๒๕๕๕
หมายเลข | ช่อง X |  | หมายเลข | ช่อง X |  | หมายเลข | ช่อง X
1 |  |  | 1 |  |  | 1
2 |  |  | 2 |  |  | 2
3 |  |  | 3 |  |  | 3
4 |  |  | 4 |  |  | 4
5 |  |  | 5 |  |  | 5
6 |  |  | 6 |  |  | 6
7 |  |  | 7 |  |  | 7
Spreadsheet: 192048d1352297232-looking-for-a-text-string-and-putting-that-cell-value-into-a-table-excel-forum-example
Sheet: Sheet1

 | COLUMN B | COLUMN C | COLUMN D | COLUMN E |  | Search Text | Results
ROW 2 | Address: 105 Fairway Green Drive Wilmington, NC ; 28557 |  |  |  |  | Aprx Htd SqFt: | 2300
ROW 3 | MLS#: 121-458 |  | List Price: $ 229,900 |  |  | SqFt. Upper: | 550
ROW 4 | Property Type: Residential |  | Sales Price: $201,000 |  |  | SqFt. Lower: | 1750
ROW 5 | Pin 15: | 635606286652000 |  |  |  | Year Built: | 2005
ROW 6 | Status: Closed |  | Bank OwnedNo |  |  | [NAME]: | X
ROW 7 | TypeSingle Family Residential |  | Zoning: | Residential |  | [NAME]: | 350
ROW 8 | Lot Size: | 135 x 125 | Style: [NAME] |  |  | Prop. Taxes: | 1275
ROW 9 | Subdivision: [NAME] |  | Subdivision Phase:IV |  |  | Tax Year: | 2012
ROW 10 | Area: Morehead City |  | Lot #: | 16 |  | Lot #: | 16
ROW 11 | Rooms: | 8 | Aprx Lot Acres: | 0.39 |  | Aprx Lot Acres: | 0.39
ROW 12 | Bedrooms: 3 |  |  |  |  | Zoning: | Residential
ROW 13 | Bathrooms: 2.00 |  |  |  |  | Lot Size: | 135 x 125
ROW 14 | Half Baths: 1.0 |  |  |  |  | Pin 15: | 635606286652000
ROW 18 | Aprx Htd SqFt: | 2300 | [NAME]: | X |  | Address: | 105 Fairway Green Drive
ROW 15 | SqFt. Upper: | 550 | [NAME]: | 350 |  | MLS#: | 121-458
ROW 16 | SqFt. Lower: | 1750 | Prop. Taxes: | 1275 |  | List Price: | 229900
ROW 17 | Year Built: | 2005 | Tax Year: | 2012 |  | Sales Price: | 201000
 |  |  |  |  |  | Status: | Closed
 |  |  |  |  |  | Type | Single Family Residential
 |  |  |  |  |  | Bank Owned | No
Spreadsheet: 1fbadd0f-16e3-4e4d-99cb-fe8198502c03
Sheet: Sheet1

Table 3--U.S. monthly average farm prices and marketings | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2010/11
Month |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August |  | 14.6 |  | 10856 |  | 13.6 |  | 11434 |  | 11.7 |  | 10691
September |  | 14.3 |  | 10630 |  | 14.4 |  | 12704 |  | 11 |  | 15095
October |  | 14.2 |  | 14547 |  | 14.9 |  | 12070 |  | 11.5 |  | 17131
November |  | 14.4 |  | 15772 |  | 15.3 |  | 11404 |  | 12.6 |  | 16929
December |  | 14.6 |  | 15163 |  | 15 |  | 14624 |  | 13.9 |  | 19137
January |  | 14.5 |  | 18693 |  | 15.2 |  | 15053 |  | 14 |  | 21806
February |  | 14.8 |  | 14029 |  | 14.1 |  | 13555 |  | 13.4 |  | 14847
March |  | 15 |  | 13775 |  | 14.1 |  | 14682 |  | 13 |  | 15844
April |  | 15.2 |  | 12444 |  | 14.4 |  | 13311 |  | 13.1 |  | 12727
May |  | 15.7 | 1/ |  |  | 14.1 |  | 13127 |  | 12.7 |  | 14227
June |  |  |  |  |  | 14.2 |  | 10510 |  | 12.1 |  | 11317
July |  |  |  |  |  | 14.5 |  | 11380 |  | 12.9 |  | 12369
Average price to date |  | 14.73 | 2/
Season average farm price |  | 14.9 | 3/ |  |  | 14.5 |  |  |  | 12.7
Average Marketings |  |  |  | 13989.88888888889 |  |  |  | 12821.16666666667 |  |  |  | 15176.66666666667
Total volume marketed |  |  |  | 125909 |  |  |  | 153854 |  |  |  | 182120
N/A = Not available.
1/ Mid-month only.  2/ Simple average.  3/ Mid-point of season-average farm price projection range.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated June 14, 2013.
Spreadsheet: 23717d1213368402-moving-around-cells-zipped-example
Sheet: Sheet1

Example data:
RECORD ID | TAG |  |  |  |  |  |  | RECORD ID | TAG 1 | TAG 2 | TAG 3
1 | Approved |  |  |  |  |  |  | 1 | Approved | Hold | Completed
1 | Hold |  |  |  |  |  |  | 2 | Approved | Cancelled
1 | Completed |  |  |  |  |  |  | 3 | Approved | Hold | Completed
2 | Approved |  |  |  |  |  |  | 4 | Approved | Completed
2 | Cancelled |  |  |  |  |  |  | 5 | Completed
3 | Approved |  | Want this to look like this…. |  |  |  |  | 6 | Completed
3 | Hold |  |  |  |  |  |  | 7 | Cancelled
3 | Completed |  |  |  |  |  |  | 8 | Approved | Hold
4 | Approved |  | So that I have only one instance of a record id
4 | Completed
5 | Completed
6 | Completed
7 | Cancelled
8 | Approved
8 | Hold
Spreadsheet: 184822d1349383210-some-equations-not-updating-immediately-example
Sheet: RP1

 | & "EDB" BRANCH CIRCUIT BREAKERS,18,000 AMP IESC RATING
 | VOLTS --> |  |  | [NAME]> |  | 100
CT. | LOCATION/DECSRIPTION/ | WATTS | WIRE | C.B. |  | PHASE |  | C.B. | WIRE | WATTS | LOCATION/DESCRIPTION/ | CT.
NO. | QUANTITY |  | SIZE | AMP | A | B | C | AMP | SIZE |  | QUANTITY | NO.
1 |  |  |  |  |  | ----- | ----- |  |  |  |  | 2
3 |  |  |  |  | ---- |  | ----- |  |  |  |  | 4
5 |  |  |  |  | ---- | ----- |  |  |  |  |  | 6 |  |  |  |  |  |  |  | 1
7 |  |  |  |  |  | ----- | ----- |  |  |  |  | 8 |  |  |  |  |  |  |  | 2
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 |  |  |  |  | ---- | ----- |  |  |  |  |  | 36
37 |  |  |  |  |  | ----- | ----- |  |  |  |  | 38
39 |  |  |  |  | ---- |  | ----- |  |  |  |  | 40
41 |  |  |  |  | ---- | ----- |  |  |  |  |  | 42
 | P--PADLOCK ATTACHMENT |  |  |  | A | B | C
 | L--LOCK ON ATTACHMENT
 | TOTAL WATTS PER PHASE: |  |  |  |  |  |  |  |  |  | TOTAL KILOWATTS:
 | TOTAL AMPS PER PHASE: |  |  |  |  |  |  |  |  |  | TOTAL AMPS:
 |  |  |  |  | Manual Panel Upsize (Amps): | 100
 |  |  |  |  |  |  |  |  |  |  |  | yes
 |  |  | [NAME]: |  |  |  | 480Y/277V: |  |  |  |  | ongoing
 |  |  | Main Lugs Only: |  |  |  | 208Y/120V:
 | Copy and paste cells for original formatting |  |  |  |  |  |  | Copy and paste cells for original formatting
Spreadsheet: 817012d1675949909-power-query-extracting-text-instead-of-web-link-copy
Sheet: DROPDOWN

Completed |  |  | ACTON
Unable to [NAME] |  |  | EALING
Moved to Another Office |  |  | EalingReep
 |  |  | FULHAM
 |  |  | HAMMERSMITH
 |  |  | Harlesden
 |  |  | QUEENSPARK
 |  |  | HARROW
WC (NAME) |  |  | HARROWREEP
TEAM LEADER (NAME) |  |  | HAYES
 |  |  | VALIANTHOUSE
 |  |  | HOUNSLOW
 |  |  | HOUNSLOWREEP
 |  |  | KINGSTON
 |  |  | KINGSTONREEP
 |  |  | SHEPHERDSBUSH
 |  |  | TWICKENHAM
 |  |  | UXBRIDGE
 |  |  | WANDSWORTH
 |  |  | PUTNEY
 |  |  | WEMBLEY
 |  |  | WEMBLEYREEP
Spreadsheet: 221453d1363559542-sum-the-value-of-multiple-cells-off-the-description-field-test-forecaster-2
Sheet: FINISHED-GOOD

FINISHED PART NUMBER | QTYONHAND | QTYALLOCATED | QTYONORDER | LOCATIONGROUPID |  | QTY AVAILABLE
13003CR | 20 | 54 | 0 | 1
13003CRA | 20 | 28 | 0 | 1
13003CRE | 20 | 28 | 0 | 1
13003CRF | 20 | 28 | 0 | 1
Spreadsheet: 749784d1633006189-calculate-period-and-annual-interest-calculo-juros
Sheet: Folha1

 |  |  |  |  |  |  |  | Investment |  | Today | win or lose value | Elapsed Time  (days) | Profitability
 |  |  |  |  |  |  |  | Date | Ammount | Ammount |  |  | Períod | Yearly
 |  |  |  |  |  |  |  | 2020-06-05 00:00:00 | 5000 | 7325.8
 |  |  |  |  |  |  |  | Investment |  | Today | win or lose value | Elapsed Time  (days) | Profitability
 |  |  |  |  |  |  |  | Date | Ammount | Ammount |  |  | Períod | Yearly
 |  |  |  |  |  |  |  | 2014-07-07 00:00:00 | 35000 | 58029.55 |  |  | ???
 |  |  |  |  |  |  |  | 2019-11-28 00:00:00 | 10000
 |  |  |  |  |  |  |  | Investment |  | Today | win or lose value | Elapsed Time  (days) | Profitability
 |  |  |  |  |  |  |  | Date | Ammount | Ammount |  |  | Períod | Yearly
 |  |  |  |  |  |  |  | 2014-07-07 00:00:00 | 35000 | 58029.55 |  |  | ???
 |  |  |  |  |  |  |  | 2019-11-28 00:00:00 | 10000
Spreadsheet: 31221d1227021117-summary-sheet-problem-2009-pipeline-test
Sheet: Summary

Summary Of 2009 Events Key Opportunities by Area, Tier and Status
 |  | 1 |  |  | 0.95 |  |  | 0.75 |  |  | 0.5 |  |  | 0.25 |  | Grand Total
Sum of Total | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3
Area | € | € | € | € | € | € | € | € | € | € | € | € | € | € | €
Central | 13020.304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 78338.74399999999 | 0 | 0 | 0 | 0 | 0 | 91359.048
Scotland | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37893.372 | 0 | 0 | 0 | 0 | 0 | 37893.372
South East | 6380 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 144232.66 | 0 | 0 | 0 | 0 | 0 | 150612.66
South West | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 47867.864 | 0 | 0 | 0 | 0 | 0 | 47867.864
Grand Total | 19400.304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 308332.64 | 0 | 0 | 0 | 0 | 0 | 327732.944
Totals | 19400.304 |  |  | 0 |  |  | 0 |  |  | 308332.64 |  |  | 0
 |  |  | Prospect Totals |  |  |  |  |  |  |  |  | Lost
Sum of Total | 2009 Budget | 2009 orders | [NAME] | [NAME] | [NAME] | Prospect Total | 2008 Gap |  |  | Sum of Total | Tier 1 | [NAME] | Tier 3
Area | € | € | € | € | € | € | € |  |  | Area | € | € | €
Central | 1476487 | 13020.304 | 78338.74399999999 | 0 | 0 | 78338.74399999999 |  |  |  | Central
Scotland | 308903 | 0 | 37893.372 | 0 | 0 | 37893.372 |  |  |  | Scotland
South East | 2194127 | 6380 | 144232.66 | 0 | 0 | 144232.66 |  |  |  | South East
South West | 1584308 | 0 | 47867.864 | 0 | 0 | 47867.864 |  |  |  | South West
Grand Total | 5563825 | 19400.304 | 308332.64 | 0 | 0 | 308332.64 |  |  |  | Grand Total | 0 | 0 | 0
 |  |  |  | 0.95 | 0.75 | 0.5 | 0.25
 | Orders |  |  | Prospects
 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3
Spreadsheet: 829077d1683899301-check-whether-the-childs-corresponding-parent-value-is-present-in-dataset-example
Sheet: Sheet1

MetaData |  |  |  | DATASET
Child | Parent |  |  | SKU | Trait | P/C
Fruit | Apple |  |  | Delmonte | [NAME] | P
Red | Apple |  |  | Delmonte | Soft | C | YES | [NAME] checks if the parent value for [NAME] (banana) is present in column F where the corresponding value is [NAME]
Crunchy | Apple
Fruit | Pear |  |  | [NAME] | Carrot | P
Green | Pear |  |  | [NAME] | Crunchy | C | YES | [NAME] checks if the parent value for crunchy (either apple,carrot,pear) is present in column F where the corresponding value is [NAME]
Crunchy | Pear
Fruit | [NAME]
Soft | [NAME]
Veg | Carrot |  |  | RedDelish | Red | C | NO | [NAME] returns NO because the parent value red is not in column F, where the corresponding value in column E is RedDelish. Adding the below values to column E and F will change the formula result to YES
Orange | Carrot |  |  | RedYummy | Apple | P
Crunchy | Carrot
 |  |  |  |  |  |  |  | SKU | Trait | P/C
 |  |  |  |  |  |  |  | RedDelish | Apple | P
Spreadsheet: 788371d1658420395-coping-specific-names-from-one-sheet-to-a-another-automatically-test
Sheet: R

Surname | Given Name(s) | Section | Lot | Number | Date Bought | Date Paid | Address | Town / City | Prov | Postal | Phone
Ramey | kathy | 1 | 1 | 1 | July 20 2022 | July 20 2020 | 123 Any street | Anywhere | ON | H0H 0H0 | [PHONE]
Spreadsheet: 128343d1320923548-formula-totals-forum
Sheet: Arkusz1

 |  |  |  | Hey guys,
 |  | 500 | yes
 |  | 200 | yes | basically i want it to work out it say in column a1 if anything between d2 to d15 = yes to calculate the value in c2 to c15 and put the value into a1
 |  |  | no
 |  | 100 | yes | the d column can either say yes in a cell or no in a cell
 |  | 150 | yes | d2 = yes
 |  | 1 | yes | d3 = yes
 |  | 1 | yes | d4 = no
 |  | 1 | yes | d5 = yes
 |  | 1 | yes | d6 = yes
 |  | 1 | yes
 |  | 1 | yes | the c colum has the figures if it says yes the column will say
 |  | 1 | yes | c2 = 500
 |  | 1 | yes | c3 = 200
 |  | 1 | yes | c4
 |  |  |  | c5 = 100
 |  |  |  | c6 = 150
Spreadsheet: 219834d1362982487-vlookup-issue-book2
Sheet: Stock

ITEMID | [NAME] |  |  |  | <----------Database---------->
Z0P2002A9 |  |  |  |  | 90035 | [NAME] 20"
90039 |  |  |  |  | 90039 | CarryCase Black 24''
90035 |  |  |  |  | DEMO TV | Display + TV
DEMO TV |  |  |  |  | Z0P2002A9 | COM PRO
ITEMID | [NAME]
Z0P2002A9 | =(VLOOKUP(A9,F$2:G$5,2,FALSE))
90039 | =(VLOOKUP(A10,F$2:G$5,2,FALSE))
90035 | =(VLOOKUP(A11,F$2:G$5,2,FALSE))
DEMO TV | =(VLOOKUP(A12,F$2:G$5,2,FALSE))
Spreadsheet: 883538d1732151766-elderly-user-needs-a-formula-present-value
Sheet: Sheet1

 |  |  |  |  |  |  |  | Year | Balance b/f | Interest | Withdrawal | Balance c/f
 | Interest rate per annum | rate | 0.06 |  |  |  |  | 1
 | Annual withdrawal | pmt | 110000
 | Withdrawal period in years | nper | 25
 | Future value | fv | 0
 | When to withdraw | type | 1 | 0 = end of period, 1 = beginning of period
 | Present value | pv |  | = pv(rate, nper, pmt, [fv], [type])
 |  |  | Current Pool | % share | Contribution
 | Person A |  | 1000000
 | Person B |  | 700000
 | Total
 |  |  |  |  |  |  |  | Total