tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41549d1240031696-consolidating-text-in-rows-by-zipcode-concatif-sample
Sheet: Sheet1

[NAME] | Customer |  |  | Zip Code | Customers
00008 | Customer 1 |  |  | 00001 | Customer 8, Customer 19, Customer 24
00007 | Customer 2 |  |  | 00002 | Customer 6, Customer 9, Customer 18
00007 | Customer 3 |  |  | 00003 | Customer 16, Customer 20, Customer 21
00005 | Customer 4 |  |  | 00004 | Customer 10, Customer 25, Customer 29
00007 | Customer 5 |  |  | 00005 | Customer 4, Customer 13
00002 | Customer 6 |  |  | 00006 | Customer 15
00009 | Customer 7 |  |  | 00007 | Customer 2, Customer 3, Customer 5, Customer 17, Customer 22, Customer 26
00001 | Customer 8 |  |  | 00008 | Customer 1, Customer 23, Customer 27, Customer 28
00002 | Customer 9 |  |  | 00008 | Customer 1, Customer 23, Customer 27, Customer 28
00004 | Customer 10 |  |  | 00009 | Customer 7, Customer 11, Customer 12, Customer 14
00009 | Customer 11
00009 | Customer 12
00005 | Customer 13
00009 | Customer 14
00006 | Customer 15
00003 | Customer 16
00007 | Customer 17
00002 | Customer 18
00001 | Customer 19
00003 | Customer 20
00003 | Customer 21
00007 | Customer 22
00008 | Customer 23
00001 | Customer 24
00004 | Customer 25
00007 | Customer 26
00008 | Customer 27
00008 | Customer 28
00004 | Customer 29
Spreadsheet: 854900d1704648785-need-to-get-right-date-transactions_export_21482__07_01_2024__111227-aligw
Sheet: Transactions_Export_21482__07_0

created_at
2024-01-06 21:45:00
2024-01-06 21:17:00
2024-01-01 20:18:00
2024-01-01 20:17:00
2023-12-30 02:17:00
2023-12-29 02:17:00
2023-12-20 22:08:00
2023-12-18 12:46:00
2023-12-17 19:37:00
2023-12-14 21:20:00
2023-12-14 00:59:00
2023-12-13 03:55:00
2023-12-13 03:51:00
2023-12-13 03:47:00
Spreadsheet: 2880c537-6f06-437b-807e-a542a4ce5c4f
Sheet: Sheet1

2002 official [NAME] | Unnamed: 1
State of North Dakota Results
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
Downloaded at 3/7/2014 10:54:37 PM
 | [NAME] ([NAME]) Neumann - NON
Justice of the Supreme Court - NON | 97859
 | [NAME]
Public Service Commissioner - DEM | 46446
 | [NAME]
Public Service Commissioner - REP | 54859
 | [NAME]
Representative in Congress - DEM | 52403
 | [NAME]
Representative in Congress - REP | 56570
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 0633a02a-86e6-49e2-adf6-78ae2a7ea888
Sheet: Roads General Obligation Bonds

GENERAL OBLIGATION - Road Commission Schedule |  |  |  |  |  |  |  |  | DECEMBER 31, 2013
 |  |  | refunded 04 |  |  |  | new 12
 | MTF Notes |  | Building Authority |  | MTF Notes |  | MTF Notes
ISSUE: | 2002 Ypsi Twp |  | 2003 A refunding |  | 2000 [NAME] |  | Series 2012 |  | TOTAL GENERAL OB |  | ANNUAL TOTAL GENOB
DATE | principal | interest | principal | interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest
----------- | ---------- | ---------- | ---------- | ---------- | ----------- | ---------- | ----------- | ---------- | ----------- | ---------- | ----------- | ----------
Feb 1 2014 |  |  |  |  |  |  |  | 54000
Aug 1 2014 |  |  |  |  |  |  | 600000 | 54000
Feb 1 2015 |  |  |  |  |  |  |  | 51000
Aug 1 2015 |  |  |  |  |  |  | 600000 | 51000
Feb 1 2016 |  |  |  |  |  |  |  | 45000
Aug 1 2016 |  |  |  |  |  |  | 600000 | 45000
Feb 1 2017 |  |  |  |  |  |  |  | 39000
Aug 1 2017 |  |  |  |  |  |  | 600000 | 39000
Feb 1 2018 |  |  |  |  |  |  |  | 33000
Aug 1 2018 |  |  |  |  |  |  | 600000 | 33000
Feb 1 2019 |  |  |  |  |  |  |  | 27000
Aug 1 2019 |  |  |  |  |  |  | 600000 | 27000
Feb 1 2020 |  |  |  |  |  |  |  | 21000
Aug 1 2020 |  |  |  |  |  |  | 600000 | 21000
Feb 1 2021 |  |  |  |  |  |  |  | 15000
Aug 1 2021 |  |  |  |  |  |  | 600000 | 15000
Feb 1 2022 |  |  |  |  |  |  |  | 7500
Aug 1 2022 |  |  |  |  |  |  | 600000 | 7500
 | --------------- | --------------- | --------------- | --------------- | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------
Issuance Date |  |  | 1/21/04 |  |  |  | 6/21/12
Issuance Amount |  |  | 3535000 |  |  |  | 6000000
[NAME]): |  |  | General Fund Road Commission |  |  |  | Ypsilanti Township
Spreadsheet: joe_parks__14513__P&L_JUN01
Sheet: NYMEX_juL2

Sells |  |  |  | Buys
 |  |  |  |  |  |  |  | TXOK
 |  |  |  |  |  |  |  |  |  |  |  | 15 | 3.995
 |  |  |  |  |  |  |  |  |  |  |  | 30 | 4.02
 |  |  |  |  |  |  |  | *
 |  |  |  |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  |  |  |  | <- MTM PL w/o Real PL |  | preserve realized
 |  |  |  |  |  |  |  |  |  | <- MTM PL with Real PL |  | breakeven
 |  | <- Current Nymex
 |  | <- Price Overide |  |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 53257d1253169519-help-grouping-times-together-699783_darkflame808
Sheet: PT

 |  | Data
Type of work | Log | Min of Start time | [NAME] of End time | Sum of Hours
Labor | 1 | 04:00:00 | 07:00:00 | 09:00:00
Maintainence | 1 | 07:00:00 | 08:00:00 | 04:00:00
 | 2 | 10:00:00 | 12:00:00 | 14:00:00
Tech | 1 | 07:00:00 | 08:00:00 | 03:00:00
 | 2 | 09:00:00 | 10:00:00 | 06:00:00
Spreadsheet: 693143d1598797055-how-to-write-formula-for-column-hurdle-query-sample0830
Sheet: Sheet3

 | Name | Code | Name | Code | Name | Code |  | Name | Code
 | Adam1 | A | Adam6 | F | Adam11 | K |  | Adam7 | G
 | Adam2 | B | Adam7 | G | [NAME] | L
 | Adam3 | C | Adam8 | H | [NAME] | M
 | Adam4 | D | Adam9 | I | Adam14 | N
 | Adam5 | E | Adam10 | J | Adam15 | O
 |  |  |  |  |  |  |  | I2 cell name
 |  |  |  |  |  |  |  | I3 cell Let user input name
 |  |  |  |  |  |  |  | [NAME] a formula to find out the result
 |  |  |  |  |  |  |  | The name is in the B, D, F column
 |  |  |  |  |  |  |  | The CODE to be queried is in column C, E, G
Spreadsheet: 862343d1710101813-determine-first-of-the-day-in-a-sequence-and-how-many-are-needed-to-become-good-example
Sheet: Sheet1

date | condition | # needed | first of day good |  |  | the result i want to become |  |  | after filtering this row  on value 1
2024-02-01 00:00:00 | bad | 1
2024-02-01 00:00:00 | good | 1 | 1 |  |  | date | condition | # needed | first of day good
2024-02-02 00:00:00 | bad | 1 |  |  |  | 2024-02-01 00:00:00 | good | 1 | 1 |  | 1 bad attempt before a good one
2024-02-02 00:00:00 | good | 1 | 1 |  |  | 2024-02-02 00:00:00 | good | 1 | 1 |  | 1 bad attempt before a good one
2024-02-03 00:00:00 | good | 0 | 1 |  |  | 2024-02-03 00:00:00 | good | 0 | 1 |  | first time right
2024-02-04 00:00:00 | good | 0 | 1 |  |  | 2024-02-04 00:00:00 | good | 0 | 1 |  | first time right, few later attemps but not needed to take in account
2024-02-04 00:00:00 | bad | later then the first good so no value needed |  |  |  |  |  |  |  |  | 5/02/24 has only a bad attempt and no good one, so wil not appear in the list
2024-02-04 00:00:00 | good | later then the first good so no value needed |  |  |  | 2024-02-06 00:00:00 | good | 2 | 1 |  | 2 bad attempts before a good one
2024-02-04 00:00:00 | good | later then the first good so no value needed |  |  |  | 2024-02-07 00:00:00 | good | 0 | 1
2024-02-05 00:00:00 | bad | 1 |  |  |  | 2024-02-08 00:00:00 | good | 1 | 1
2024-02-06 00:00:00 | bad | 1 |  |  |  | 2024-02-09 00:00:00 | good | 0 | 1
2024-02-06 00:00:00 | bad | 2 |  |  |  | 2024-02-10 00:00:00 | good | 0 | 1
2024-02-06 00:00:00 | good | 2 | 1 |  |  | 2024-02-11 00:00:00 | good | 0 | 1
2024-02-07 00:00:00 | good | 0 | 1 |  |  | 2024-02-12 00:00:00 | good | 0 | 1
2024-02-08 00:00:00 | bad | 1 |  |  |  | 2024-02-13 00:00:00 | good | 0 | 1
2024-02-08 00:00:00 | good | 1 | 1 |  |  | 2024-02-14 00:00:00 | good | 0 | 1
2024-02-09 00:00:00 | good | 0 | 1 |  |  | 2024-02-15 00:00:00 | good | 0 | 1
2024-02-10 00:00:00 | good | 0 | 1 |  |  | 2024-02-16 00:00:00 | good | 2 | 1
2024-02-11 00:00:00 | good | 0 | 1 |  |  | 2024-02-17 00:00:00 | good | 0 | 1
2024-02-11 00:00:00 | good | later then the first good so no value needed
2024-02-12 00:00:00 | good | 0 | 1
2024-02-13 00:00:00 | good | 0 | 1
2024-02-13 00:00:00 | good | later then the first good so no value needed
2024-02-13 00:00:00 | bad | later then the first good so no value needed
2024-02-13 00:00:00 | good | later then the first good so no value needed
2024-02-14 00:00:00 | good | 0 | 1
2024-02-15 00:00:00 | good | 0 | 1
2024-02-16 00:00:00 | bad | 1
2024-02-16 00:00:00 | bad | 2
2024-02-16 00:00:00 | good | 2 | 1
2024-02-16 00:00:00 | bad | later then the first good so no value needed
2024-02-17 00:00:00 | good | 0 | 1
Spreadsheet: 780401d1652436579-if-formula-using-index-match-with-help-from-helper-sample
Sheet: Sheet1

Old Report
PARTICIPANT_NAME | NUMBER | BOOKING_ID | SERVICE_BOOKING_TYPE | SUPPORT_CATEGORY | SUPPORT_Number | START_DATE | END_DATE | STATUS
Participant 1 | 294566094 | 6565625 | Standard | IT Support | 06_05_001_1_5 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | Active
Participant 2 | 676442211 | 6795483 | Standard | IT Support | 06_05_001_1_5 | 2021-05-30 00:00:00 | 2022-04-30 00:00:00 | Inactive
Participant 3 | 741035032 | 3497568 | Standard | IT Support | 06_05_001_1_5 | 2022-03-20 00:00:00 | 2023-03-20 00:00:00 | Active
Participant 4 | 130289078 | 9346824 | Standard | IT Support | 06_05_001_1_5 | 2021-10-11 00:00:00 | 2022-04-17 00:00:00 | Active
Participant 5 | 845963037 | 5973164 | Standard | IT Support | 06_05_001_1_5 | 2022-04-12 00:00:00 | 2022-04-30 00:00:00 | Active
Participant 6 | 246487752 | 5731648 | Standard | IT Support | 06_05_001_1_5 | 2021-04-11 00:00:00 | 2022-06-30 00:00:00 | Active
New Report
PARTICIPANT_NAME | NUMBER | BOOKING_ID | SERVICE_BOOKING_TYPE | SUPPORT_CATEGORY | SUPPORT_Number | START_DATE | END_DATE | STATUS | TRUE / FALSE | Current Formula | Cell Meant To Say
Participant 1 | 294566094 | 6565625 | Standard | IT Support | 06_05_001_1_5 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | Active |  |  | No Change in Plan
Participant 2 | 676442211 | 6795483 | Standard | IT Support | 06_05_001_1_6 | 2021-05-30 00:00:00 | 2022-04-30 00:00:00 | Inactive |  |  | New but Not Active
Participant 3 | 741035032 | 3497568 | Standard | IT Support | 06_05_001_1_7 | 2022-03-20 00:00:00 | 2023-03-20 00:00:00 | Active |  |  | No Change in Plan
Participant 4 | 130289078 | 9346824 | Standard | IT Support | 06_05_001_1_8 | 2021-10-11 00:00:00 | 2023-04-17 00:00:00 | Active |  |  | Extended
Participant 5 | 845963037 | 5973164 | Standard | IT Support | 06_05_001_1_9 | 2022-05-01 00:00:00 | 2023-05-01 00:00:00 | Active |  |  | New
Participant 6 | 246487752 | 5731648 | Standard | IT Support | 06_05_001_1_10 | 2021-04-11 00:00:00 | 2022-06-30 00:00:00 | Active |  |  | No Change in Plan
Spreadsheet: 711949d1609997647-how-to-retrieve-datapoint-based-on-criteria-in-three-separate-columns-sample
Sheet: Sheet1

Younger Age | Older Age (min) | Older Age ([NAME]) | Payment Rate
73 | 77 | 79 | 7.6 |  | Younger Age | 74
73 | 80 | 81 | 7.7 |  | Older Age | 83
73 | 82 | 84 | 7.8
73 | 85 | 87 | 7.9 |  | Payment Rate
73 | 88 | 88 | 8
73 | 89 | 110 | 8.1
74 | 74 | 75 | 7.5
74 | 76 | 77 | 7.6
74 | 78 | 79 | 7.7
74 | 80 | 81 | 7.8
74 | 82 | 84 | 7.9
74 | 85 | 87 | 8
74 | 88 | 88 | 8.1
74 | 89 | 110 | 8.2
Spreadsheet: 48680d1247913728-copy-row-from-multiple-worksheets-based-on-column-value-in-to-summary-tab-sales-2009
Sheet: Feb

Date | Company | Details | Invoice No. | Net Amount | VAT | Total | Paper Reference | Date Invoice Sent | Date Papment Received
2009-01-01 00:00:00 | SOI | Leaflet Distribution | 6 | 560 | 120.4 | 680.4 | J1 | 2009-01-01 00:00:00 | 2009-01-15 00:00:00
2009-01-01 00:00:00 | KPMG | [NAME] | 7 | 100 | 21.5 | 121.5 | J2 | 2009-04-03 00:00:00 | Unpaid
Spreadsheet: 66941d1267617077-hyperlink-to-a-cell-in-another-worksheet-using-vlookup-hyperlink_eg2
Sheet: Inv Breakdown

[NAME]
PO No. | Invoice No | Invoice Date | Invoiced | Remaining | Matched | Matched Cumulative | PO Amount | Variance (Matched / PO ) | Comments
10502 | 1800000498 | 13.07.2009 | 86862.72 | 0 | 75532.8 | 226598.4
10502 | 1800000523 | 04.09.2009 | 43431.36 | 0 | 37766.4 | 226598.4
10502 | 1800000573 | 17.02.2010 | 66563.28 | 66563.28 | 56649.6 | 226598.4
10502 | 180000553 | 03.12.2009 | 65147.04 | 0 | 56649.6 | 226598.4
10502 | 1800000553 | 03.12.2009 | 65147.04 | 0 | 0 | 226598.4
9891 | 10001 | 15.12.2010 | 3500 | 0 | 0 | 0
TOTAL |  |  | 330651.44 | 66563.28 | 226598.4
Spreadsheet: 696861d1601016163-fomula-to-display-average-of-last-12-months-data-metric-excel
Sheet: Mining Graph

Mining Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tanami - 12MM, 6MM TRAFR & Reportable Injuries
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 12MM TRIFR | 6MM TRIFR | LTI- Actual | RWC- Actual | MTI - Actual | TRIFR Target | Employee | Business Partner | TRI Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 227332d1365680792-need-help-in-developing-a-customized-time-sheet-and-summary-new-microsoft-office-excel-worksheet
Sheet: Man

Empl Name | Emp ID | 2013-04-01 00:00:00 | 2013-04-02 00:00:00 | 2013-04-03 00:00:00 | 2013-04-04 00:00:00 | 2013-04-05 00:00:00 | 2013-04-06 00:00:00 | 2013-04-07 00:00:00 | 2013-04-08 00:00:00 | 2013-04-09 00:00:00 | 2013-04-10 00:00:00
[NAME] | 1300 | A | A | C | D | SL | AB | SL | E | D | HD
[NAME] | 1301
[NAME] | 1302
[NAME] | 1304
[NAME] | 1305
 |  | Legends
PROJECT No | Code | P | Present for work |  | Empl No | OT Rates
141356 | A | AL | Annual Leave |  | 1300 | 5
141357 | B | SL | [NAME] |  | 1301
141358 | C | EL | Emergency Leave |  | 1302 | 3
141359 | D | AB | Absent |  | 1304 | 10
141360 | E | HD | Holiday |  | 1305
Spreadsheet: 867853d1714640018-formula-to-zero-tables-within-kpi-spreadsheet-new-hs-kpi-updated-max-percentage-100
Sheet: H&S Eng Comb

 |  |  |  |  | Friday to Thursday
 | Safety | Points avaliable | Month score | Total | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Monthly Target | Annual Target | % | Clancy Target | % Against Target
 | Major injury | -50 |  |  |  |  |  |  |  | 0 | 0
 | Lost time injury | -25 |  |  |  |  |  |  |  | 0 | 0
 | Non-lost time injury | 0 |  |  |  |  |  |  |  | 0 | 0
 | Service Strike (HV) | -20 |  |  |  |  |  |  |  | 0 | 0
 | Service Strike (LV) | -15 |  |  |  |  |  |  |  | Less than 3 | Less than 36 |  | <6
 | Service Strike (Gas) | -10 |  |  |  |  |  |  |  |  |  |  | <33
 | Service Strike (Other) | -5 |  |  |  |  |  |  |  |  |  |  | <33
 | Manager [NAME] | 0.1 |  |  |  |  |  |  |  | 12
 | Safety observations | 0.01 |  |  |  |  |  |  |  | 50
 | H&S advisor visits | 0.2 |  |  |  |  |  |  |  | 12
 | Manager/Supervisor Safety Visits | 0.01 |  |  |  |  |  |  |  | 39
 | [NAME] | 0.01 |  |  |  |  |  |  |  | 100
 | ABC Tours | 0.01 |  |  |  |  |  |  |  | 10
 | HAVS |  |  |  | 0 | 0 | 0 | 0 | 0
 | Total
Spreadsheet: drew_fossum__8687__Fixed3_113000
Sheet: Back End Deal

NORTHERN NATURAL GAS COMPANY
Trading BOOK
Back End Swap
Prod. | Contract | Contract |  |  | Volume |  |  | (Gains) and Losses
Date | Number | Name | AECO + .94 |  | Dth | AECO + .90 |  | Total | Realized | Unrealized
 |  |  | Receiving |  |  | Paying | Difference | (4) | (4) | (4)
2000-11-01 00:00:00 | Back End Swap | TC
2000-12-01 00:00:00 | Back End Swap | TC
2001-01-01 00:00:00 | Back End Swap | TC
2001-02-01 00:00:00 | Back End Swap | TC
2001-03-01 00:00:00 | Back End Swap | TC
2001-04-01 00:00:00 | Back End Swap | TC
2001-05-01 00:00:00 | Back End Swap | TC
2001-06-01 00:00:00 | Back End Swap | TC
2001-07-01 00:00:00 | Back End Swap | TC
2001-08-01 00:00:00 | Back End Swap | TC
2001-09-01 00:00:00 | Back End Swap | TC
2001-10-01 00:00:00 | Back End Swap | TC
2001-11-01 00:00:00 | Back End Swap | TC
2001-12-01 00:00:00 | Back End Swap | TC
2002-01-01 00:00:00 | Back End Swap | TC
2002-02-01 00:00:00 | Back End Swap | TC
2002-03-01 00:00:00 | Back End Swap | TC
2002-04-01 00:00:00 | Back End Swap | TC
2002-05-01 00:00:00 | Back End Swap | TC
2002-06-01 00:00:00 | Back End Swap | TC
2002-07-01 00:00:00 | Back End Swap | TC
2002-08-01 00:00:00 | Back End Swap | TC
2002-09-01 00:00:00 | Back End Swap | TC
2002-10-01 00:00:00 | Back End Swap | TC
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 9b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Fixed-Float | 933096 | 549680 | 156570 | 28735 | 18757 | 31148 | 56976 | 1774962
OTHER* | 443006 | 441498 | 77433 | 11357 | 49215 | 7100 | 20920 | 1050529
TOTAL | 1376102 | 991178 | 234003 | 40092 | 67972 | 38248 | 77896 | 2825491
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: 45341d1244100720-nesting-vlookup-in-if-vice-versa-and-pivot-table-686167_jbritt609
Sheet: Feb Cat1

Model | Amount-Cat1 |  |  |  |  |  |  | 500 | 0
750 | -205.6622 |  |  |  |  |  |  | 750 | -205.6622
900 | -2669.357555600005 |  |  |  |  |  |  | 900 | -2669.357555600005
AB | -781.1330488 |  |  |  |  |  |  | AB | -781.1330488
AG | -63.58996399999999 |  |  |  |  |  |  | AD | 0
AN | -1797.5294 |  |  |  |  |  |  | AG | -63.58996399999999
BX | -4786.3809 |  |  |  |  |  |  | AL | 0
BZ | -3810.1728 |  |  |  |  |  |  | AN | -1797.5294
CA | -2172.7989 |  |  |  |  |  |  | BX | -4786.3809
CB | -474.72875 |  |  |  |  |  |  | BZ | -3810.1728
DE | -1471.4364 |  |  |  |  |  |  | CA | -2172.7989
DV | -4460.2879 |  |  |  |  |  |  | CB | -474.72875
DX | -3484.0798 |  |  |  |  |  |  | DE | -1471.4364
MF | -891.2694208362112 |  |  |  |  |  |  | DF | 0
MR | -10948.26850350159 |  |  |  |  |  |  | DS | 0
OA | -387.3093814209659 |  |  |  |  |  |  | DV | -4460.2879
OB | -145.4543661579462 |  |  |  |  |  |  | DX | -3484.0798
OR | -182.7213715871364 |  |  |  |  |  |  | FA | 0
RA | -565.1764208362113 |  |  |  |  |  |  | GL | 0
RF | -10622.17550350159 |  |  |  |  |  |  | GM | 0
TM | -61.21638142096588 |  |  |  |  |  |  | MF | -891.2694208362112
ZP | -320.4162152328041 |  |  |  |  |  |  | MR | -10948.26850350159
Grand Total | -50301.16518289542 |  |  |  |  |  |  | OA | -387.3093814209659
 |  |  |  |  |  |  |  | OB | -145.4543661579462
 |  |  |  |  |  |  |  | OR | -182.7213715871364
 |  |  |  |  |  |  |  | RA | -565.1764208362113
 |  |  |  |  |  |  |  | RF | -10622.17550350159
 |  |  |  |  |  |  |  | TM | -61.21638142096588
 |  |  |  |  |  |  |  | ZP | -320.4162152328041
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Grand Total | -50301.16518289542
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 728644d1618558837-excel-combination-of-letters-and-numbers-book1
Sheet: Sheet1

S/No. | Company Code | Staff IDs.
1 | CT | CT694
2 | CT | CT695
3 | LC | LC2799
4 | LC | LC2800
5 | LC | LC2796
6 | LC | LC2797
7 | LC | LC2798
8 | MT | MT741
9 | MT | MT742
10 | MT | [NAME]
11 | MT | [NAME]
12 | MT | [NAME]
13 | MT | MT746
14 | MT | MT747
Spreadsheet: 108443d1305534260-excel-2007-pivot-table-formulas-with-custom-subtotals-sample
Sheet: pivot1

 |  | year | month
 |  | 2010 |  | Toplam 2010 | 2011 |  | Toplam 2011 | Genel Toplam
name | Değerler | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00
[NAME] | Toplam balance | 10 | 32 | 42 | 14 | 24 | 38 | 80
 | Toplam quantity | 2 | 5 | 7 | 2 | 4 | 6 | 13
 | Toplam tax | 2 | 2 | 4 | 2 | 2 | 4 | 8
 | Toplam % | 0.2 | 0.0625 | 0.09523809523809523 | 0.1428571428571428 | 0.08333333333333333 | 0.1052631578947368 | 0.1
item2 | Toplam balance | 24 | 26 | 50 | 52 | 53 | 105 | 155
 | Toplam quantity | 3 | 3 | 6 | 4 | 4 | 8 | 14
 | Toplam tax | 5 | 6 | 11 | 7 | 8 | 15 | 26
 | Toplam % | 0.2083333333333333 | 0.2307692307692308 | 0.22 | 0.1346153846153846 | 0.1509433962264151 | 0.1428571428571428 | 0.167741935483871
item3 | Toplam balance | 100 | 102 | 202 | 107 | 108 | 215 | 417
 | Toplam quantity | 5 | 5 | 10 | 5 | 5 | 10 | 20
 | Toplam tax | 22 | 23 | 45 | 24 | 25 | 49 | 94
 | Toplam % | 0.22 | 0.2254901960784314 | 0.2227722772277228 | 0.2242990654205607 | 0.2314814814814815 | 0.2279069767441861 | 0.2254196642685851
Toplam balance Toplamı |  | 134 | 160 | 294 | 173 | 185 | 358 | 652
Toplam quantity Toplamı |  | 10 | 13 | 23 | 11 | 13 | 24 | 47
Toplam tax Toplamı |  | 29 | 31 | 60 | 33 | 35 | 68 | 128
Toplam % Toplamı |  | 0.2164179104477612 | 0.19375 | 0.2040816326530612 | 0.1907514450867052 | 0.1891891891891892 | 0.1899441340782123 | 0.196319018404908
Spreadsheet: 679707d1590593812-count-if-with-an-index-match-example
Sheet: Sheet1

Item | Data point 1 | Data point 2 | Data point 3 | Data point 4
Product 1 | 1 |  |  |  | Data entered correctly |  | Row Labels | Expected count
Product 1 |  | 1 |  |  | Data entered correctly |  | Product 1 | 2
Product 2 | 1 |  |  |  | Data entered correctly |  | Product 2 | 3
Product 2 |  | 1 |  |  | Data entered correctly |  | Product 3 | 4
Product 2 |  |  | 1 |  | Data entered correctly |  | Product 4 | 2
Product 3 | 1 |  |  |  | Data entered correctly |  | Product 5 | 1
Product 3 |  | 1 |  |  | Data entered correctly |  | Product 6 | 3
Product 3 |  |  | 1 |  | Data entered correctly |  | Product 7 | 4
Product 3 |  |  |  | 1 | Data entered correctly |  | Product 8 | 2
Product 4 | 1 |  |  |  | Data entered correctly |  | Grand Total
Product 4 |  | 1 |  |  | Data entered correctly
Product 5 | 1 |  |  |  | Data entered correctly
Product 6 | 1 | 1 | 1 |  | Data incorrectly entered
Product 7 | 1 | 1 | 1 | 1 | Data incorrectly entered
Product 8 | 1 | 1 |  |  | Data incorrectly entered
Spreadsheet: 165941d1341403293-problem-creating-ohlc-chart-ohlc-problem
Sheet: Sheet1

date | open | high | low | close
jan | 1.582 | 1.592 | 1.499 | 1.501
feb | 1.5821 | 1.5925 | 1.4993 | 1.5301
[NAME] | 1.5915 | 1.5962 | 1.5011 | 1.5434
Spreadsheet: 854233d1704192832-looking-for-a-formula-ifs-with-multi-criteria-sample-sheet
Sheet: Main

SR# | DATE | REFERENCE | Weight |  | [NAME] ([NAME]'s) |  | ALL | X | Y | Z
1 |  | x | 0.5 |  | 0.5 | 5
2 |  | x | 2 |  | 5.5 | 10
3 |  | y | 5 |  | 10.5 | 15
4 |  | y | 6
5 |  | x | 12
6 |  | x | 3.5
7 |  | z | 0.5
8 |  | x | 2.5
9 |  | z | 3
10 |  | y | 2.5
11 |  | z | 12