tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 705341d1606041820-calculate-the-total-number-of-people-on-a-training-course-at-a-certain-time-in-the-day-formula
Sheet: Sheet1

Daily Totals (People) | 09:00:00 | 50
 | 10:00:00 |  | 15
 | 11:00:00 | 15
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00
Trainer 1 | 09:00:00 | CCC01 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 10:00:00 |  | CCC02 |  |  |  |  |  |  |  |  |  |  |  | Course Title | People
 | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC01 | 15
 | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC02 | 15
 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC03 | 50
 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC04 | 15
 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC05 | 20
Trainer 2 | 09:00:00 | CCC01 |  |  |  |  |  |  |  |  |  |  |  |  | CCC06 | 15
 | 10:00:00
 | 11:00:00 | CCC01
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
Trainer 3 | 09:00:00 | CCC05
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
Spreadsheet: 843163d1695110876-calculate-overlap-costs-with-date-paramaters-overlap-cost
Sheet: Sheet1

 |  |  | Period Start Date | Period End
 |  |  | 2023-08-28 00:00:00 | 2023-09-27 00:00:00 |  |  | No Days
 |  | ID  Old | Exit Date | Monthly Cost |  | ID New | Start Date | Answer | Comment
 |  | A | 2023-10-20 00:00:00 | 1000 |  | E | 2023-07-01 00:00:00 | 1000 | Full Period as ID A overlapping ID E for full timeframe
 |  | B | 2023-09-30 00:00:00 | 1100 |  | F | 2023-07-01 00:00:00 |  | Full Period as ID B overlapping ID E for full timeframe
 |  | C | 2023-07-29 00:00:00 | 1200 |  | G | 2023-09-01 00:00:00 | 0 | ID Exited 19 Jul so outside Period (28th Aug - 27sep)
 |  | D | 2023-09-19 00:00:00 | 1300 |  | H | 2023-09-01 00:00:00 |  | ID H in place for 19 days during Period (28th - 27 Sep)
Spreadsheet: 2b9aa2b9-0ecb-493e-b3da-6ac838f33bfb
Sheet: FusionRefSheet1

[1,1(1,1,1)]
[1,1(1,1,1)] | [1,1(1,1,1)] | [1,1(1,1,1)] | [1,1(1,1,1)] |  |  | [1,1(1,1,1)] |  |  | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
 | [1,1(1,1,1)]
Spreadsheet: 717509d1612709122-array-formula-that-return-city-with-two-condition-and-have-no-sales-new-microsoft-excel-worksheet-1-
Sheet: Sheet1

month | product | city | total sales |  |  |  | month | 4 |  | Not listed |  |  |  |  |  | c1
1 | a2 | c1 | 1000 |  |  |  | product | a1 |  |  |  |  |  |  |  | c2
4 | a1 | c2 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | c3
2 | a1 | c3 | 3000 |  |  |  |  |  |  |  |  |  |  |  |  | c4
3 | a2 | c4 | 4000 |  |  |  |  |  |  |  |  |  |  |  |  | c5
4 | a1 | c5 | 5000
5 | a2 | c2 | 6000
Spreadsheet: 109408d1306271801-formula-problem-example
Sheet: Sheet1

Date | Customer | House | Quote Details | Supplier Quote | Mode | Job Cost | Quoted Sale | Inc fuel | % MU | Profit Made Before Fuel | Status | Tariff/Non Tariff | Quoted | Outcome of follow up call
2011-05-02 00:00:00 | [NAME] | PP | 2 from Luxembourg | [NAME] | EU Parcels | 13.79 | 28.08 | 28.08 | 0.5089031339031339 | 14.29 | Won | Non Tariff | LH | 1182548
2011-05-02 00:00:00 | [NAME] | PP | 2 to France | DPD | EU Parcels | 15.62 | 32 | 32 | 0.5118750000000001 | 16.38 | Won | Non Tariff | LH | 1182524
Spreadsheet: 696342d1600767729-help-if-matching-value-return-1st-value-attach-file-sample-excel-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CASE 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CASE 2
 |  |  |  |  |  |  |  |  | BEFORE |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 1 |  | 8 |  |  |  |  |  | BEFORE |  |  |  |  | 2 |  | 7 |  | 1 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 1 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 8 |  | 9
 |  |  |  |  |  |  |  |  | AFTER |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | AFTER |  |  |  |  |  |  |  | 9
Spreadsheet: 42823d1241472275-pulling-detailed-data-from-one-sheet-to-another-keyedsearch
Sheet: Employee Search

Employee: | Employee #1
Total Variances: | 40.85 | # of Dates | 6
Date | [NAME]
2009-03-07 00:00:00 | 31
2009-03-31 00:00:00 | 5
2009-04-05 00:00:00 | -0.05
2009-04-06 00:00:00 | 0
2009-04-07 00:00:00 | 5
2009-04-25 00:00:00 | -0.1
Spreadsheet: 864615d1711712794-please-help-to-create-accounting-sheet-accounts-follow-up-list-2024
Sheet: PO CAPEX LIST Hidden

PO Type: | RecurringPO
OneOff
RecurringPO
Spreadsheet: 127557d1320408049-working-out-a-tariff-from-a-date-and-time-peak-time
Sheet: Sheet3

Arrival/Departure date time UTC | Arrival/Departure time UTC | Peak Minutes | Off-Peak Minutes | Total Time
2011-01-01 10:50:00 | 10:50:00 |  |  |  | 05:30:00 | morning peak | [NAME]. Saturday and Sunday
2011-01-01 12:13:00 | 12:13:00 |  |  |  | 09:00:00
2011-01-02 12:40:00 | 12:40:00 |  |  |  | 15:00:00 | evening peak
2011-01-02 14:07:00 | 14:07:00 |  |  |  | 19:00:00
2011-01-02 14:30:00 | 14:30:00
2011-01-02 15:40:00 | 15:40:00
2011-01-02 16:01:00 | 16:01:00
2011-01-02 16:29:00 | 16:29:00
2011-01-02 16:32:00 | 16:32:00
2011-01-02 20:28:00 | 20:28:00
2011-01-02 20:56:00 | 20:56:00
2011-01-03 12:00:00 | 12:00:00
2011-01-03 12:03:00 | 12:03:00
2011-01-03 13:17:00 | 13:17:00
2011-01-03 13:59:00 | 13:59:00
2011-01-03 15:17:00 | 15:17:00
2011-01-03 19:39:00 | 19:39:00
2011-01-03 20:04:00 | 20:04:00
2011-01-03 20:38:00 | 20:38:00
2011-01-04 10:06:00 | 10:06:00
2011-01-04 10:28:00 | 10:28:00
2011-01-04 10:39:00 | 10:39:00
2011-01-04 13:58:00 | 13:58:00
2011-01-04 14:54:00 | 14:54:00
2011-01-04 14:57:00 | 14:57:00
2011-01-04 15:24:00 | 15:24:00
2011-01-04 16:44:00 | 16:44:00
2011-01-04 20:04:00 | 20:04:00
2011-01-04 20:22:00 | 20:22:00
2011-01-05 09:31:00 | 09:31:00
2011-01-05 11:44:00 | 11:44:00
2011-01-05 14:32:00 | 14:32:00
2011-01-05 16:05:00 | 16:05:00
2011-01-05 16:40:00 | 16:40:00
2011-01-06 07:05:00 | 07:05:00
2011-01-06 09:48:00 | 09:48:00
2011-01-06 11:13:00 | 11:13:00
2011-01-06 11:33:00 | 11:33:00
2011-01-06 14:52:00 | 14:52:00
2011-01-06 14:58:00 | 14:58:00
2011-01-06 15:33:00 | 15:33:00
Spreadsheet: 729908d1619438120-finding-the-most-popular-popular-sector
Sheet: Sheet1

site | Customer_Firstname | Customer_Surname | Sector | Date_Ref
[NAME] | [NAME] | Boulton | Retail Trade | 2021-01-22 00:00:00
[NAME] | [NAME] | [NAME] | IT & Communications | 2021-01-23 00:00:00
Fulham | [NAME] | [NAME] | Public Sector | 2021-01-24 00:00:00
Fulham | Enesa | Gara | IT & Communications | 2021-01-25 00:00:00
Fulham | Enesa | mark | IT & Communications | 2021-01-25 00:00:00
Fulham | [NAME] | Dunnett | Voluntary, Charity & Social Enterprise | 2021-02-26 00:00:00
Fulham | Yelena | Aleksic | Arts, Entertainment & Recreation | 2021-02-27 00:00:00
Ealing | [NAME] | [NAME] | Legal, Accountancy & Consultancy Services | 2021-02-28 00:00:00
Uxbridge | Josaphat | Koko | Retail Trade | 2021-03-01 00:00:00
Fulham | Shania | Breedy | Retail Trade | 2021-03-02 00:00:00
Wembley | Duaa | Chleyah | Childcare & Child Social Work | 2021-03-22 00:00:00
Uxbridge | [NAME] | Fox | Healthcare | 2021-03-22 00:00:00
Uxbridge | Jordan | Gallagher | IT & Communications | 2021-03-22 00:00:00
Wandsworth | Mohamed | Abdulaziz | Retail Trade | 2021-03-22 00:00:00
Uxbridge | Jordan | [NAME] | Healthcare | 2021-03-22 00:00:00
[NAME] | [NAME] | Boulton | Retail Trade | 2021-03-22 00:00:00
Wembley | Alina | Dote | Public Sector | 2021-03-22 00:00:00
Wembley | [NAME] | Simpson-Black | Administration (inc Call Centres) | 2021-03-22 00:00:00
Wembley | [NAME] | Simpson-Black | Hospitality | 2021-04-01 00:00:00
Wembley | Alina | Dote | Retail Trade | 2021-04-02 00:00:00
Fulham | Shania | Breedy | Retail Trade | 2021-04-03 00:00:00
[NAME] | Erin | Haggaty | Voluntary, Charity & Social Enterprise | 2021-04-04 00:00:00
[NAME] | Erin | Haggaty | Voluntary, Charity & Social Enterprise | 2021-04-05 00:00:00
[NAME] | Erin | Haggaty | IT & Communications | 2021-04-06 00:00:00
Wandsworth | Mohamed | Abdulaziz | Wholesale Trade | 2021-04-07 00:00:00
HARLESDEN | Jordan | Groves | Childcare & Child Social Work | 2021-04-08 00:00:00
Spreadsheet: 05a33973-62f5-45bd-a496-727c0d5a9dea
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Annexure A - Corp 2379 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
TASK GRADE | POSITIONS | MIN REQUIRMENTS | Related years of experience | Annual Basic Salary Range | Proposed agency fee (%) | Please indicate the percentage (%) as mark up
T06 | Secretary | Grade 12 | 5 | R170 100.00 - R204 120.00
T09 | [NAME] | Grade 12 | 5 | R216 090.00 - R259 320.00
 |  | 3yr Business Admin Diploma | 2 | R216 090.00 - R259 320.00
T10 | Cost Controller | 3yr ND in Accounting or Equivalent | 3 | R406 036.50 - R462 030.00
T11 | Contracts Supervisor / Safety Officer | [NAME] or equivalent | 6 | R441 640.50 - R504 775.50
T12 | Snr Contracts Supervisor | [NAME] or equivalent | 6 | R481 729.50 - R552 868.50
 |  | N6 / T3 | 10 | R526 890.00 - R607 033.50
 |  | [NAME] | 7 | R526 890.00 - R607 033.51
T13 | Snr Contracts Supervisor / Technician | T4 | 6 | R526 890.00 - R607 033.52
 |  | B-Tech (Technical) | 5 | R526 890.00 - R607 033.53
 |  | BSc Degree (Technical) | 3 | R526 890.00 - R607 033.54
[NAME] | Senior Advisor Projects | 12+3 Technical Project Management | 5 | R1 083 235.50 - R1 431 009.00
M16 | Technical Contracts Manager | 4yr BSc or Equivalent NQF 6 Advantage: Project Management NQF 6 | 5 | R1 149 544.50 - R1529 031.00
[NAME] | Middle Manager Capital Expansion` | M + 4  Extensive Project mngt | 7 | R1 501 237.50 - R2 048 925.01
M18 | Site Project Manager | BSc Engineering or B Tech Degree with Project Management qualification | 7 | R1 501 237.50 - R2 048 925.00
 |  |  | The mark-up percentage should include all fees (statutory, additional bonuses, training, administration, interview, etc.) charged by your agency other than the salary.
 | Note: It is compulsory to maintain this format when responding to this tender. This document must be handed in with the retunables
Spreadsheet: 0741dc6f-9315-4c7e-9271-36d1c92b331d
Sheet: TR_TOUTP

Tariff - Through or Out Service Payments
TR_TOUTP_<customer id>_<settlement date>_<version>.CSV
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Customer ID | [NAME] Number | [NAME] Name | Through or Out Service Payment | Through or Out Service Penalty Payment | ISO OATT Schedule 1 Payment for Through or Out Service | ISO OATT Schedule 1 Penalty Payment for Through or Out Service | Total Through or Out Service Payment including ISO SFT Schedule 1 | ISO SFT Schedule 1 Payment for Through or Out Service | ISO SFT Schedule 1 Penalty Payment for Through or Out Service
Number | String | String | $ | $ | $ | $ | $ | $ | $
Spreadsheet: 55690d1255862443-racing-leader-board-leaderboard2
Sheet: leaderboard

overall standings | driver name | points
1 | driver 12 | 18
2 | driver 19 | 13
3 | driver 2 | 10
3 | driver 8 | 10
3 | driver 11 | 10
6 | driver 15 | 9
7 | driver 13 | 8
8 | driver 9 | 7
8 | driver 10 | 7
10 | driver 20 | 6
11 | driver 5 | 4
11 | driver 6 | 4
13 | driver 3 | 3
13 | driver 17 | 3
15 | driver 7 | 2
15 | driver 14 | 2
17 | driver 1 | 1
18 | driver 4 | 0
18 | driver 16 | 0
18 | driver 18 | 0
Spreadsheet: 770372d1646040361-summarize-from-multiple-table-s-brr
Sheet: Summary

CURRENT PRACTISE | [NAME]
 | SALES |  |  |  |  |  |  |  | PURCHASE
MONTH | TAXABLE | EXEMPTED | CGST | SGST | IGST | TOTAL OUTPUT | CESS |  | IGST | CGST | SGST | CESS | DEBIT NOTE | ITC AVAILABLE | INTRA STATE EXEMPTED | INTER STATE EXEMPTED | TAX | L/F | TOTAL
APRIL
TOTAL
FUTURE REQUIREMENT | I require this.
GST Summary Report
I: SALES (Outward Supply)
Month | Total Taxable Value (₹) | Exempt | CGST | SGST | IGST | Cess | Total Outward
April
May
June
July
August
September
October
November
December
January
February
March
II: PURCHASES (Inward Supply)
Month | IGST | CGST | SGST | Cess | Debit Note | ITC Available
April
May
June
July
August
September
October
November
December
January
February
March
III: Grand Total
Month | Tax | Late Fees | Total
April
May
June
July
August
September
October
November
December
January
February
March
Data in separate sheet
I: SALES (Outward Supply)
Taxable Value | 3.1 (a) [NAME] taxable supplies (other than zero rated, nil rated and exempted)
Exempt | 3.1 (c)   Other outward supplies (nil rated, exempted)
CGST | 6.2 Breakup of tax liability declared (for interest computation)- Central Tax (₹)
SGST | 6.2 Breakup of tax liability declared (for interest computation)-State/UT Tax (₹)
IGST | 6.2 Breakup of tax liability declared (for interest computation)-Integrated Tax (₹)
Cess | 6.2 Breakup of tax liability declared (for interest computation)-Cess (₹)
Total Outward | ∑ of all the above excluding "Taxable Value"
II: PURCHASES (Inward Supply)
IGST | 6.1 Payment of tax-->Tax paid through ITC (₹)-->∑ Integrated Tax
CGST | 6.1 Payment of tax-->Tax paid through ITC (₹)-->∑ Central Tax
SGST | 6.1 Payment of tax-->Tax paid through ITC (₹)[NAME]
Cess | 6.1 Payment of tax-->Tax paid through ITC (₹)-->∑ Cess
Debit Note | N.A.
ITC Available | ∑ of all the above (-) Debit Note
III: Grand Total
Tax | Total [NAME] (-) ITC Available
Late Fees | 5.1 ∑ late fees
Total | Tax (+) Late Fees
Spreadsheet: 181906d1348192643-return-all-rows-with-duplicate-numbers-in-column-b-example
Sheet: Client Purchases

4 | <--- I want to be able to type a client number in here...
 | ...and have the rows where that clients' number is in column B to populate below
 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Date | Client Number | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | Item 11 | Item 12 | Item 13 | Item 14 | Item 15 | Item 16
 | 5
Spreadsheet: 674513d1587890058-format-problem-and-the-lookup-function-format-problem-and-vlookup
Sheet: Sheet-2

Account | Description
1011
1031
1060
1100
1101
1102
1150
1211
1214
1215
1230
1250
1251
1252
1280
1281
1299
1340
1341
1350
1351
1352
1353
1354
1380
1381
1382
1383
1385
1390
1460
1461
1462
1463
1465
1468
1469
1470
1471
1500
Spreadsheet: david_delainey__8186__ENA End of Year 1-9-01
Sheet: Sheet1

Name | Prelim. Bonus | Proposed Bonus |  | Difference | Rationale
[NAME] | 100000 | 110000 |  |  | Played a major role in the structuring and negotiation of Bighorn
 |  |  |  |  | Gas Gathering ($22 MM contribution of $204MM)
 |  |  |  |  | Has originated and at PSA stage for over $500 MM in acquisitions.
[NAME] | 80000 | 100000 |  |  | Originated and negotiated the 11 gathering deals that
 |  |  |  |  | created the value of EMS Gathering ($54MM of the $204MM)
 |  |  |  |  | He clearly deserves a larger bonus than last year given his work and
 |  |  |  |  | contribution on Project 20/20
[NAME] | 30000 | 35000 |  |  | Performance did not deteriorate from last year
[NAME] | 55000 | 40000 |  |  | Received $30,000 last year. Would like to maintain at $55,000 but
 |  |  |  |  | am open to re-distributing to those that had a more direct and significant
 |  |  |  |  | role in closing Project 20/20
[NAME] | 25000 | 25000
[NAME] | 7200 | 7200
[NAME] | 14000 | 14000
[NAME] | 5000 | 8000 |  |  | Worked incredibly hard (saw her in the office every weekend for a 4 month period
 |  |  |  |  | reconciling accounts payable/receivable and determining cash price adjustments for
 |  |  |  |  | for Project 20/20.  Created at least $1.5 MM in value to ENA through her efforts.
[NAME] Felling | 2400 | 2400
Spreadsheet: 815214d1674819607-advance-filter-from-master-sheet-to-another-sheet-kitap1
Sheet: Sayfa1

 | ADMİN | NAME | DÖNEM |  | "C3& Name"  ı selected also as you see sheet2 also selected same name
 | BÜNYAMİN YAVUZ | Ayülker İhsanoğlu | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] Sakarya Bilge | 2022-1
 | BÜNYAMİN YAVUZ | Arcan Ülker | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] Yorulmaz | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] | 2022-1
 | BÜNYAMİN YAVUZ | [NAME] | 2022-1
 | BÜNYAMİN YAVUZ | Bayan Nürice Nuriyet Aksu Mansız | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Dr. [NAME] İnönü | 2022-1
 | [NAME] | Dr. [NAME] Çetin Ülker | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Görklü [NAME] | 2022-1
 | [NAME] | Dr. Uğur Semine Öcalan Şama | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Dr. [NAME] Öcalan | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Bayan Mübetcel Nilcan Tevetoğlu | 2022-1
 | [NAME] | [NAME] Sezgin | 2022-1
 | [NAME] | Dr. [NAME] | 2022-1
 | [NAME] | Dr. [NAME] | 2022-1
 | [NAME] | Bayan Aral [NAME] | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Aslanhan Ulutay Sezgin | 2022-1
 | BÜNYAMİN YAVUZ | Dr. [NAME] | 2022-1
 | [NAME] | Tanses Semat Akçay Sezgin | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Faize Nurveren Zengin | 2022-1
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Görklü [NAME] | 2022-1
 | [NAME] | Ozansü Ferihan Sezgin | 2022-1
 | [NAME] | [NAME] | 2022-2
 | [NAME] | [NAME] | 2022-2
 | [NAME] | [NAME] | 2022-1
 | [NAME] | Ginyas Erdoğan | 2022-2
Spreadsheet: 163223d1340226151-how-to-use-vlookup-for-a-ranges-of-values-in-an-equation-analysis-example
Sheet: Analysis

 | Lower Wavenumber | Upper Wavenumber | Root Mean Square Deviation |  | I need to calculate the RMS deviation for the absorbances associated with a range of wavenumbers
 | 2000.07 | 2006.34 |  |  | RMS equation: |  | =SQRT(DEVSQ(a:b)/COUNTA(a:b))
 | 2010.18 | 2015.12
 | 2020.09 | 2022.05 |  |  |  |  | where a is the absorbance at the lower wavenumber and b the absorbance at the upper wavenumber
 | 2023.93 | 2025.47 |  |  |  |  | I can use the VLOOKUP formula to find the absorbance at any wavenumber:
 | 2027.93 | 2032.97 |  |  |  |  |  |  | absorbance at 2000.07 wavenumbers
 | 2034.78 | 2036.51 |  |  | How can I use the VLOOKUP command in the RMS equation to look up a range of numbers?
 | 2038.02 | 2039.74
 | 2044.78 | 2045.79 |  |  | Here is what I tried - gives an ERROR:
 | 2047.15 | 2059.99
 | 2060.99 | 2063.65 |  |  | "=SQRT(DEVSQ(VLOOKUP(B2,Data!A2:B17010,2,TRUE):VLOOKUP(c2,Data!A2:B17010,2,TRUE))/COUNTA(LOOKUP(B2,Data!A2:B17010,2,TRUE):VLOOKUP(c2,Data!A2:B17010,2,TRUE))
 | 2067.98 | 2073.8
 | 2081.07 | 2086.89
 | 2094.48 | 2105.89
 | 2108.67 | 2113.6
 | 2117.28 | 2135.63
 | 2140.76 | 2143.48
 | 2146.8 | 2160.11
 | 2164.78 | 2183.96
 | 2188.49 | 2203.93
Spreadsheet: 730413d1619693908-how-to-sum-formula-to-get-total-value-from-another-column-times-with-another-column-get-total-sum-number-from
Sheet: example

 | Subject : | Product | [NAME] : |  | Supplier 1 | Supplier 2 | Supplier 3
 | Item Code | Description | Unit | QTY | Price1 | Price2 | Price3 | Price4 | Price5 | Remark | Toal
 |  | A | Pair | 40 | 36.5 | 25 | 27.06
 |  | B | Pair | 10 | 36.5 | 28 | 49.42
 |  | C | PCS | 50 | 7.8 | 6 | 7.75
 |  | D | PCS | 50 | 17.25 | 16 | 15.63
 |  | E | PCS | 3 | 6.5 | 3 | 20
 |  | F | Pair | 110 | 0.65 | 1 | 1.12
 |  | G | PCS | 3 | 28.8 | 30 | 53.8
 |  | Total Example |  |  | 3254.9 | 2589 | 3090.2
 |  | I want a formular
 |  | I want to have total sum from Supplier 1 , 2 or 3 in below colume by not use formular from colume "L"
 |  | This table was create from team, and it really annoy me while I cannot change or delet anything due to table. Can you give me some idea to eleminate this table role.
Spreadsheet: 71912d1272582070-start-end-dates-between-overlap-multiple-start-end-dates-format-date-periods
Sheet: Sheet1

time off |  |  |  | tasks
start | end |  |  | start | end
2010-01-01 00:00:00 | 2010-01-01 00:00:00 |  |  | 2010-03-03 00:00:00 | 2010-03-12 00:00:00
2010-03-13 00:00:00 | 2010-03-20 00:00:00 |  |  | 2010-08-27 00:00:00 | 2010-08-27 00:00:00
2010-08-20 00:00:00 | 2010-08-29 00:00:00 |  |  | 2010-08-30 00:00:00 | 2010-08-30 00:00:00
2010-09-04 00:00:00 | 2010-09-04 00:00:00 |  |  | 2010-09-03 00:00:00 | 2010-09-04 00:00:00
Spreadsheet: 848108d1698910118-conditional-formatting-with-transposed-data-book1-4-
Sheet: Sheet3

 |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  | velit & dolore | nulla & sint | non & in | officia & anim | laborum. & perspiciatis | iste & sit | doloremque & rem | ipsa & illo | et & beatae | sunt & enim | quia & aspernatur | aut & quia | dolores & ratione | nesciunt. & quisquam | dolorem & dolor | consectetur, & sed | numquam & tempora | labore & magnam | voluptatem. & ad | quis & ullam | laboriosam, & aliquid | commodi & autem | iure & in | velit & nihil | vel & dolorem | quo & pariatur?
Spreadsheet: 61198d1262015130-how-to-find-new-accounts-come-in-with-match-function-testdhyun
Sheet: Sheet1

Account as of yesterday | Account as of today.
159 | 159
354 | 354
659 | 659
487 | 487
956 | 956
123 | 123
568 | 568
481 | 111 | new
359 | 222 | new
659 | 333 | new
789 | 444 | new
548 | 555 | new
659 | 481
789 | 359
 | 659
 | 789
 | 548
 | 659
 | 789
Spreadsheet: 885809d1735655438-dependent-drop-down-lists-based-off-table-example
Sheet: Sheet1

Location | Person | Car | Colour
London | [NAME] | BMW | Black |  | DROP-DOWN 1 | DROP-DOWN 2 | DROP-DOWN 3 | DROP-DOWN 4
London | [NAME] | Ford | White |  | London | [NAME] | BMW | White
London | [NAME] | Ford | Red |  | Birmingham | [NAME] | Ford | Red
London | [NAME] | Mercedes | Green |  | [NAME]
London | [NAME] | Honda | Red
London | [NAME] | Toyota | White
Birmingham | [NAME] | BMW | White
Birmingham | [NAME] | BMW | Black
Birmingham | [NAME] | BMW | Red
Birmingham | [NAME] | Ford | Blue
Birmingham | Eleanor | Toyota | Green
Birmingham | Eleanor | Toyota | White
Birmingham | Eleanor | Honda | White
[NAME] | Greg | Ford | Black
[NAME] | Greg | Ford | Red
[NAME] | Greg | Honda | Blue
[NAME] | Helen | BMW | Green
[NAME] | Helen | Toyota | Red
[NAME] | Helen | Toyota | Black
Spreadsheet: 738522d1625082973-index-match-index-match
Sheet: Filter

Region | Location | Division | Name | Title | Training
Spain | Barcelona | AP | [NAME] | Manager | Antibribery
Spain | Sevilla | AR | [NAME] | Staff | AML
France | Paris | Finance | [NAME] | Coordinator | Finance
France | Toulouse | HR | [NAME] | Director | Leadership
Germany | Berlin | Operations | [NAME] | VP | Motivation
France | Marseille | IT | [NAME] | Analyst | Entrepreneur
Portugal | Lisbon | Logistics | [NAME] | Associate | Business inteligence |  |  | Index match
Greece | Athens | Sales | Lukatoni | VP | Maths |  |  |  | [NAME]
Spain | Malaga | HR | [NAME] | Associate | Encouragement
Germany | Berlin | HR | [NAME] | Director | Leadership |  |  | [NAME]
Spain | Barcelona | Finance | Bartomeu | VP | AML
Spreadsheet: 740617d1626426133-how-you-link-a-drop-down-to-populate-information-from-other-sheets-quotation-type-of-fo-drawing-calc-1-
Sheet: Products

Carbon Fibre |  |  | Flocking | F_Cost |  | Powdercoating |  |  | 3D Printing |  |  | Ceramic Coating |  |  | Injector Diagnostics |  |  | Site Services
Item | Cost |  | Item | Cost |  | Item | Cost |  | Item | Cost |  | Item | Cost |  | Item | Cost |  | Item | Cost
A |  |  | AA | 111
B |  |  | BB | 222
C |  |  | CC | 333
Spreadsheet: 023b695a-c5a5-46e1-8639-3740366b0daf
Sheet: Journal

10 digit nominal code | Sub analysis code | Supplier & description of goods/services | [NAME] | [NAME] | Project code
1900341753 |  | Company X-Training course | 100 |  | FIN001 |  | Example 1: How to record a payment
1900341754 |  | Company X-Training course | 15 |  | FIN001
1900341753 |  | Company X-Training course |  | 100 | FIN001 |  | Example 2: How to record a refund
1900341754 |  | Company X-Training course |  | 15 | FIN001