tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 821865d1678956022-combining-if-and-or-statements-to-produce-results-based-on-multiple-criteria-formula-help
Sheet: formula testing do not use

Nominal | amount | Sch %/ AP%/Bur% | Staff Based at | [NAME] | % based on contract hours | Value
40151 | 7560 | 0 | abc |  | 0.5330769230769231 |  | 0.66
50151 | 5510 | 0 | abc |  | 0.4038461538461539 |  | 0.5
50151 | 4015 | 0 | xyz |  | 0.61875 |  | 0.66
50151 | 5510 | 0 | xyz |  | 0.61875 |  | 0.66
50151 | 5510 | 0 | abc |  | 0.5 |  | 0.5
40151 | 7560 | 0 | abc |  | 0.66 |  | 0.66
40151 | 7560 | 0 | abc |  | 0.66 |  | 0.66
50151 | 5510 | 0 | xyz |  | 0.66 |  | 0.66
40151 | 7560 | 0 | xyz |  | 0.5 |  | 0.5
40151 | 7560 | 0.1 | abc |  | 0.6000000000000001 |  | 0.66
40151 | 7560 | 0 | xyz |  | 0.5 |  | 0.5
Spreadsheet: 99301d1297972930-solved-comparing-2-worksheets-to-find-unique-additions-sample2
Sheet: Sheet1

State Code (2) | Local Code (4) | EE File Number (6) | Branch Code (2) | Company Code (4) | SSN (9) | Lived in Code (6)
PA | 7609 | 0000051 | EA | ABC | 123456789 | 061001
PA | 7609 | 0000066 | EA | ABC | 598634896 | 061001
PA | 7609 | 0000052 | EA | ABC | 987654321 | 380503
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: September

 |  | 2022-08-29 00:00:00 | 2022-08-30 00:00:00 | 2022-08-31 00:00:00 | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00
 |  | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00 | 2022-09-09 00:00:00 | 2022-09-10 00:00:00
 |  | Labor Day                         Office Closed
 |  | 2022-09-12 00:00:00 | 2022-09-13 00:00:00 | 2022-09-14 00:00:00 | 2022-09-15 00:00:00 | 2022-09-16 00:00:00 | 2022-09-17 00:00:00
 |  | 2022-09-19 00:00:00 | 2022-09-20 00:00:00 | 2022-09-21 00:00:00 | 2022-09-22 00:00:00 | 2022-09-23 00:00:00 | 2022-09-24 00:00:00
 |  | 2022-09-26 00:00:00 | 2022-09-27 00:00:00 | 2022-09-28 00:00:00 | 2022-09-29 00:00:00 | 2022-09-30 00:00:00 | 2022-10-01 00:00:00
 |  | 2022-10-03 00:00:00 | Notes
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: NFP

 | Janurary |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges
 |  |  |  |  |  |  |  |  |  | Total
 | Navy Federal Platinum |  |  |  |  |  |  |  |  | Prior Year
 | Month | Day | Transaction | Category | Description | Subcategory | Amount | Paid
Spreadsheet: 683351d1592657585-multi-criteria-formula-to-copy-from-different-cells-into-other-different-cells-example
Sheet: Sheet1

LookUp A | Parent A |  | LookUp B | Parent B | Shade | UniqueID
001 | [NAME] |  | 001 | [NAME] | Aqua | 01
002 | Magenta |  | 001 | [NAME] | Celeste | 02
003 | Yellow |  | 001 | [NAME] | Sky Blue | 03
004 | Black |  | 001 | [NAME] | Turquoise | 04
005 | Red |  | 002 | Magenta | Amaranth pink | 01
 |  |  | 002 | Magenta | Fuchsia | 02
 |  |  | 002 | Magenta | Orchid | 03
 |  |  | 003 | Yellow | Amber | 01
 |  |  | 003 | Yellow | [NAME] | 02
 |  |  | 003 | Yellow | Gold | 03
 |  |  | 003 | Yellow | Mustard | 04
 |  |  | 004 | Black | Bistre | 01
 |  |  | 004 | Black | Eerie black | 02
 |  |  | 004 | Black | Ebony | 03
 |  |  | 004 | Black | Licorice | 04
 |  |  | 005 | Red | Scarlet | 01
 |  |  | 005 | Red | Cinnabar | 01
 |  |  | 005 | Red | Tomato | 01
Spreadsheet: stacey_white__38969__1-31 Wind Position
Sheet: Daily Change By Deal

 |  |  |  |  |  |  |  |  | ENRON POWER TRADING AND [NAME] |  |  |  |  |  |  |  |  |  | Run Date: | 2001-10-01 00:00:00 | 2001-09-01 00:00:00
Report Date: | 2001-01-31 00:00:00 |  |  |  |  |  |  |  | Daily Change in Profit & Loss Report By Deal |  |  |  |  |  |  |  |  |  | Run Time: | 14:02:00 | 01:52:00
Post ID: | 13694
Desk: TEXAS-PLANT
 |  |  |  |  |  | Current Day | Prior Day |  |  |  |  |  | Gas
 |  | Swap | [NAME] | Option | [NAME] | Deal MTM P/L | Deal MTM P/L | Total Daily | Curve |  |  |  | Curve | Gas | Gas | Cross |  |  | Daily | 2nd | New | FX
 |  | Notional | [NAME] | Notional | [NAME] | Mid | Mid | Change | Shift | Gamma | Vega | Theta | Shift | Gamma | Vega | Gamma | Eta | Rho | Liquidation | order | Deals | Delta
Deal Number | Counterparty
459594.01 | ENRONWINCOR | 753455 | 413602 | 0 | 0 | 4470864 | 4570171 | -99307 | -147437 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 49676 | 0 | -1546 | 0 | 0
459594.02 | ENRONWINCOR | 756489 | 413052 | 0 | 0 | 3990686 | 4024028 | -33342 | -76825 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44303 | 0 | -820 | 0 | 0
459594.03 | ENRONWINCOR | 882260 | 479270 | 0 | 0 | 3031124 | 3088403 | -57279 | -88171 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31824 | 0 | -932 | 0 | 0
459594.04 | ENRONWINCOR | 925810 | 500215 | 0 | 0 | 2808305 | 2871948 | -63643 | -92343 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29682 | 0 | -982 | 0 | 0
459594.05 | ENRONWINCOR | 975880 | 541070 | 0 | 0 | 4431732 | 4423300 | 8432 | -40182 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 49045 | 0 | -430 | 0 | 0
459594.06 | ENRONWINCOR | 874200 | 482237 | 0 | 0 | 1335968 | 1341152 | -5184 | -22287 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17338 | 0 | -235 | 0 | 0
459594.07 | ENRONWINCOR | 858080 | 470859 | 0 | 0 | 7053759 | 7060986 | -7227 | -87169 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80888 | 0 | -946 | 0 | 0
459594.08 | ENRONWINCOR | 665880 | 363469 | 0 | 0 | 5317647 | 5325170 | -7523 | -68297 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61522 | 0 | -748 | 0 | 0
459594.09 | ENRONWINCOR | 687600 | 373410 | 0 | 0 | 4785836 | 4945461 | -159625 | -212875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 55577 | 0 | -2327 | 0 | 0
459594.1 | ENRONWINCOR | 866720 | 468196 | 0 | 0 | 1993207 | 2136810 | -143603 | -167030 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25259 | 0 | -1832 | 0 | 0
459594.11 | ENRONWINCOR | 736200 | 395651 | 0 | 0 | 1522063 | 1639478 | -117416 | -135607 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19698 | 0 | -1507 | 0 | 0
459594.12 | ENRONWINCOR | 644800 | 344689 | 0 | 0 | 2482186 | 2576310 | -94124 | -122923 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30177 | 0 | -1379 | 0 | 0
Total for R6
Spreadsheet: 139367d1328202458-nested-if-and-and-or-statements-loan-approval-limits
Sheet: Sheet1

Officer | Loan Amt | [NAME] |  |  | Officer | Limit
BK | 150000 |  |  |  | BK | 200000
GG | 375000 |  |  |  | GG | 300000
RD | 225000 |  |  |  | RD | 300000
RD | 100000
GG | 125000
BK | 1000000 |  |  | You need to use a Vlookup into the table above.
Spreadsheet: 115866d1311343635-conditional-formatting-book1
Sheet: Sheet2

 | 0
 | 9
 | 8
 | 7
 | 6
 | 5
 | 4
 | 3
 | 2
 | 1
 | 22
 | 11
 | 2
 | 44
 | 33
 | 66
 | 55
 | 99
 | 77
 | 88
 | 901
Spreadsheet: 860472d1708547420-i-need-help-for-the-formula-time-sheet
Sheet: TIME SHEET

 |  |  |  | START DATE | END DATE | PAY DATE |  |  | EMPLOYEE NAME
 |  |  |  | 2024-02-05 00:00:00
Testing
 | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 | 2024-02-05 00:00:00
TIME ON | 10:00:00 | 10:00:00 | 09:00:00
TIME OFF | 14:00:00 | 18:00:00 | 18:00:00
TIME ON | 14:00:00
TIME OFF | 18:00:00
OT ON | 18:00:00
OT OFF | 22:00:00
DBL ON | 22:00:00
DBL OFF | 23:30:00
HOL ON |  | 10:00:00
HOL OFF |  | 18:00:00
PTO ON |  |  |  | 10:00:00
PTO OFF |  |  |  | 18:00:00
REG TIME |  | OT TIME |  | DBL TIME |  | HOL TIME |  | PTO |  | TOTAL HOURS |  | NOTES
Spreadsheet: 103660d1301401697-get-list-of-values-from-survey-monkey-ranking-survey-monkey-data-example
Sheet: Sheet1

This is how the data is now
 | 1 | 2 | 3 | 4 | 5
Exciting | 1 | 5 | 3 | 0 | 0
Old-fashioned | 0 | 0 | 2 | 3 | 4
This is how I would like the data to look
Exciting | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3
Old-fashioned | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 5
Spreadsheet: 47997d1247169996-how-to-pull-info-in-column-c-when-a-and-b-match-certain-criteria-sap-log-audit-template-07-09-09-fs
Sheet: Paste SFHS

[01]lastfirst | Subtype | Entry Date | Entry Author
[NAME], [NAME] | 08-Wave/Stu. Goals | 2008-08-05 00:00:00 | Santana, [NAME]
[NAME], [NAME] | 08-Wave/Stu. Goals | 2008-08-05 00:00:00 | Santana, [NAME]
Chung, [NAME] | 08-Wave/Stu. Goals | 2008-08-05 00:00:00 | Santana, [NAME]
[NAME], [NAME] | 09-Wave/Stu. Updates | 2008-08-06 00:00:00 | Santana, [NAME]
Cerquera, Joey Esteban | 08-Wave/Stu. Goals | 2008-08-07 00:00:00 | Santana, [NAME]
[NAME], [NAME] |  | 2008-08-11 00:00:00 | Brooks, [NAME]
[NAME], [NAME] | 09-Wave/Stu. Updates | 2008-08-11 00:00:00 | Brooks, [NAME]
[NAME], [NAME] | 08-Wave/Stu. Goals | 2008-08-12 00:00:00 | Santana, [NAME]
[NAME], [NAME] | 08-Wave/Stu. Goals | 2008-08-12 00:00:00 | Santana, [NAME]
Cannada-Webb, [NAME] | 08-Wave/Stu. Goals | 2008-09-06 00:00:00 | Santana, [NAME]
Covington, [NAME] | 07-Student Snapshot | 2008-09-13 00:00:00 | Soto, [NAME]
Covington, [NAME] | 07-Student Snapshot | 2008-09-25 00:00:00 | Soto, [NAME]
Covington, [NAME] | 07-Student Snapshot | 2008-09-27 00:00:00 | Soto, [NAME]
Cannada-Webb, [NAME] | 07-Student Snapshot | 2008-11-04 00:00:00 | [NAME], Brooklyn
Campos, [NAME] | 07-Student Snapshot | 2009-01-13 00:00:00 | [NAME], Brooklyn
[NAME], [NAME] | 07-Student Snapshot | 2009-01-27 00:00:00 | [NAME], Brooklyn
[NAME], [NAME] | 09-Wave/Stu. Updates | 2009-01-27 00:00:00 | [NAME], Brooklyn
[NAME], [NAME] | 07-Student Snapshot | 2009-02-03 00:00:00 | [NAME], Brooklyn
[NAME], [NAME] | 07-Student Snapshot | 2009-02-03 00:00:00 | [NAME], Brooklyn
Cannada-Webb, [NAME] | 07-Student Snapshot | 2009-02-03 00:00:00 | [NAME], Brooklyn
Cannada-Webb, [NAME] | 09-Wave/Stu. Updates | 2009-02-10 00:00:00 | Reyes, [NAME]
Cannada-Webb, [NAME] | 07-Student Snapshot | 2009-03-11 00:00:00 | [NAME], Brooklyn
Spreadsheet: 105965d1303227583-extract-data-between-two-dates-dates
Sheet: Sheet1

Date | Value | Remark | StartDate | EndDate | Data | Value | Remark
2001-04-01 00:00:00 | 50 | abc | 2001-04-01 00:00:00 | 2001-04-07 00:00:00 | 2001-04-01 00:00:00 | 50 | abc
2001-04-02 00:00:00 | 30 | bbb |  |  | 2001-04-02 00:00:00 | 30 | bbb
2001-08-03 00:00:00 | 25 | ddd |  |  | 2001-04-07 00:00:00 | 39 | iii
2002-05-04 00:00:00 | 10 | ggg
2002-12-08 00:00:00 | 15 | ttt
2001-04-07 00:00:00 | 39 | iii |  |  | This should form in sheet 2
2003-11-09 00:00:00 | 40 | uuu |  |  | or in this sheet (is easier)
Spreadsheet: 680268d1590901446-eliminating-an-unnecessary-column-sampleoutstandingbalance
Sheet: Sheet1

Date | Remaining Balance | Ending Balance
2020-05-01 00:00:00 | 12 |  |  |  | Outstanding Balance
2020-06-01 00:00:00 | 11
2020-07-01 00:00:00 | 10
2020-08-01 00:00:00 | 9
2020-09-01 00:00:00 | 8
2020-10-01 00:00:00 | 7
2020-11-01 00:00:00 | 6
2020-12-01 00:00:00 | 5
2021-01-01 00:00:00 | 4
2021-02-01 00:00:00 | 3
2021-03-01 00:00:00 | 2
2021-04-01 00:00:00 | 1
Spreadsheet: 156421d1337282635-reformatting-data-rearangeexample
Sheet: Sheet1

Item | [NAME] | Item Code
Chevrolet Silverado, GMC Sierra Pick-ups, Tahoe, Suburban, Yukon, Denali, Avalanche Repair Manual 1999-2006 | 185 | CH28625 | HY24066 | [NAME] | SA159 | HP1526 | SA207
Harley Twin Cam 88, Road King Repair Manual 1999-2010 | 185 | HYM2478 | [NAME] | HYM4071 | HYM3515 | MB-13418 | HYM3470 | HYM3514 | MB-17453 | HYM3471 | M430-4 | AD-11CDA140 | BT-58354 | MB-13477 | MB-149866 | MB-149691 | MB-13813
Harley-Davidson FLH, FLT Twin Cam 88 & 103 Repair Manual 1999-2005 | 176 | M430-4 | HYM2478 | MB-13477 | MB-31378 | MB-13813 | MB-33536 | DE-1441
Volvo S60, X to 09 Reg, Gasoline and Diesel Repair Manual 2000-2009 | 174 | HYH4793 | HY10415 | MB-39893 | SA196
Honda Shadow [NAME], VT750, VLX, A.C.E., [NAME], Spirit Repair Manual 1988-2009 | 171 | [NAME] | M314-3 | MB-31378 | HYM3515 | MB-27166 | MB-13418 | DE-1441
Spreadsheet: 66571d1267203423-chart-bellpiero-charthelp
Sheet: Sheet1

Country | Operator
france | tom |  | Count of Country
germany | [NAME] |  | Operator | Country | Total
france | rich |  | jo | brazil | 1
uk | jo |  |  | germany | 1
brazil | jo |  |  | holland | 1
germany | jo |  |  | sweden | 1
france | tom |  |  | uk | 3
germany | [NAME] |  | jo Total |  | 7
uk | rich |  | Grand Total |  | 7
uk | jo
uk | jo
uk | rich
uk | [NAME]
holland | tom
sweden | tom
holland | jo
sweden | jo
uk | rich
uk | [NAME]
Spreadsheet: 709780d1608554278-how-to-find-the-percentage-of-two-summed-columns-bok1
Sheet: Ark1

 | Sale =1 | No sale =0
[NAME] | 1 | 0
[NAME] | 1 | 0
[NAME] | 0 | 1
[NAME] | 1 | 0
[NAME] | 0 | 1
Sum (B2:B6)
Sum (C2:C6)
=B8/B9
Spreadsheet: mary_fischer__25617__37D
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 40f87161-ce7f-4fd9-b0f7-5f6cd3233a07
Sheet: S12

Table S12. Tests of neutrality for 8 geographic regions based on resequencing data.
 | Sub Saharan Africa | Europe | Middle East_Europe | Central Asia | South Asia | East Asia | Melanasia | Native American
Sample size | 44 | 22 | 32 | 14 | 46 | 28 | 12 | 8
Segregating sites, S | 44 | 8 | 8 | 9 | 15 | 27 | 2 | 16
Pi | 7.64271 | 0.96537 | 6e-05 | 2.53846 | 2.22899 | 5.08201 | 0.33333 | 7
Tajima's D | -0.85233 | -1.83874 | -1.89346 | -0.39543 | -1.079 | -0.97112 | -1.45138 | 0.6905
Tajima's D p value | 0.201 | 0.019 | 0.009 | 0.364 | 0.15 | 0.18 | 0.061 | 0.788
Cosi reference value,mean | -0.5811157 | -0.006172422 | -0.006172422 | 0.1380596 | 0.1380596 | 0.1380596 | 0.1380596 | 0.1380596
Cosi reference value, SD | 0.6469617 | 0.8686363 | 0.8686363 | 0.9345331 | 0.9345331 | 0.9345331 | 0.9345331 | 0.9345331
COSI p-value | 0.67 | 0.034 | 0.03 | 0.56 | 0.19 | 0.23 | 0.09 | 0.55
[NAME] and D* | -1.596 | -2.15326 | -1.90014 | 0.02189 | -1.57771 | 0.04597 | -1.72038 | 1.34287
Cosi reference value,mean | -0.6845396 | -0.355181429 | -0.355181429 | -0.3040111 | -0.3040111 | -0.3040111 | -0.3040111 | -0.3040111
Cosi reference value, SD | 0.8441062 | 1.0225487 | 1.0225487 | 1.0412056 | 1.0412056 | 1.0412056 | 1.0412056 | 1.0412056
COSI p-value | 0.28 | 0.07 | 0.13 | 0.75 | 0.22 | 0.73 | 0.17 | 0.11
[NAME] and F* | -1.58554 | -2.39197 | -2.21843 | -0.10229 | -1.66717 | -0.32642 | -1.86451 | 1.32298
Cosi reference value,mean | -0.7712832 | -0.27364194 | -0.27364194 | -0.1740688 | -0.1740688 | -0.1740688 | -0.1740688 | -0.1740688
Cosi reference value, SD | 0.8352203 | 1.0468537 | 1.0468537 | 1.0835656 | 1.0835656 | 1.0835656 | 1.0835656 | 1.0835656
COSI p-value | 0.33 | 0.04 | 0.063 | 0.94 | 0.16 | 0.88 | 0.12 | 0.17
Note : Under the [NAME] package Sub-Saharan Africa was compared to Africans, Middle East_Europe was compared to Europeans, Central Asia, South Asia, East Asia, Melanasia and Native Americans to Asians
Values in bold comply to significance level at 0.05
Spreadsheet: 45453d1244191155-match-formula-example
Sheet: Sheet1

 | Height | [NAME] | Depth | Name
 | 950 | 600 | 18 | 4100 |  | 1 | 1 |  |  |  | 1
 | 725 | 500 | 465 | 150 |  | 2 | 4 |  |  |  | 2
 | 205 | 495 | 18 | 1000 |  | 1 | 1 |  |  |  | 3
 | 150 | 800 | 425 | 330 |  | 1 | 1 |  |  |  | 4
 | 145 | 795 | 18 | 1000 |  | 1 | 1 |  |  |  | 5
 | 2400 | 500 | 85 | 70 |  | 2 | 4 |  |  |  | 6
 | 2300 | 496 | 18 | 2100 |  | 1 | 1 |  |  |  | 7
 | 2400 | 500 | 85 | 70 |  | 2 | 4 |  |  |  | 8
 | 725 | 500 | 465 | 150 |  | 2 | 4 |  |  |  | 9
Spreadsheet: 868378d1715106928-going-to-kill-myself-over-this-anyone-please-help-help-latest
Sheet: my working

 |  |  |  |  |  |  | right now | expected | reason
 |  |  | csutomer name | cutomer id | My data |  | gl number |  |  |  | Raw data I am comparing too
 |  |  | baby | 0.009 | 1391499 | 128.57 | 999 | 999 | based on invoice number in F6 it looks in L6:L10 then gives back 999 |  | 1391499 | 169.99 | 456
 |  |  | baby | 0.009 | 1391499 | 1121.92 | not found | 456 | currently it says not found, but in cells M6:M8 total is 1121.92 but because its looking for 1121.92 it says not found |  | 1391499 | 101.99 | 456
 |  |  |  |  |  |  |  |  |  |  | 1391499 | 849.94 | 456
 |  |  |  |  |  |  |  |  |  |  | 1391499 | 128.57 | 999
 |  |  |  |  |  | what I want to do is this I am trying to get the GL codes and I have concanted the invoice numbers with customer ID and amount
 |  |  |  |  |  | problem is based on above this is how it looks
Spreadsheet: 683019d1592432838-dragging-vertical-formulas-referencing-horizontal-cells-vertical-formula-w-horizontal-reference
Sheet: Costing - Dec 2019

 | Verizon | Interac | Dairy Farmers | Chevrolet | York University
WHAT ARE WE TESTING?
Total # of TEST cells needed   (# of concepts you want to test independently) | 1 | 1 | 1 | 1 | 2
Do you want a CONTROL cell?   (for benchmarking Brand [NAME]) | No | Yes | Yes | Yes | Yes
TOTAL # of cells (control + test) | 1 | 2 | 2 | 2 | 2
# of in-feed STATIC POSTS to be tested in situ | 0 | 3 | 1 | 0 | 6
# of in-feed VIDEOS to be tested in situ | 3 | 0 | 3 | 3 | 0
TOTAL # of test media for Eye Square | 3 | 3 | 4 | 3 | 6
WHO ARE WE INTERVIEWING?
Test Cell Sample Size   (n=300 per sub-group breakout in each test cell) | 300 | 300 | 300 | 300 | 300
Control Cell Sample Size   (n=150 in each control cell) | 0 | 150 | 150 | 150 | 200
TOTAL SAMPLE SIZE REQUIRED | 300 | 450 | 450 | 450 | 500
 | Cost per Study
Dynata Programming and Sample Costs | 3050 | 3650 | 3650 | 3650 | 3900 | <-- Cost is partially driven by total sample size, but will also fluctuate depending on incidence of the target audience
Eye Square programming and Data Pull |  |  |  |  |  | <-- Cost is driven by the # of test media for Eye Square
Dig Insights Consulting and Management | 3600 | 3900 |  | 3900 | 4950
TOTAL STUDY COST
HST
Spreadsheet: 146245d1332003395-monthly-averages-help-pt-acme-incytdfin
Sheet: Sheet1

Job Number | Client | Description | Date Billed | Amount | Date Paid | Total Paid
09-001 |  |  |  | 1345 | 2012-02-04 00:00:00
09-002 |  |  |  | 2270 | 2012-01-12 00:00:00
09-003 |  |  |  | 819 | 2012-01-18 00:00:00
09-004 |  |  |  | 664 | 2012-02-01 00:00:00 |  |  | Row Labels | Sum of Amount | Average of Amount2
09-005 |  |  |  | 1540 | 2012-02-26 00:00:00 |  | ` | Jan | 26421 | 1554.176470588235
09-006 |  |  |  | 492 | 2012-01-02 00:00:00 |  |  | Feb | 18080 | 1506.666666666667
09-007 |  |  |  | 1644 | 2012-02-04 00:00:00 |  |  | Grand Total | 44501 | 1534.51724137931
09-008 |  |  |  | 2323 | 2012-01-18 00:00:00
09-009 |  |  |  | 2019 | 2012-01-20 00:00:00
09-011 |  |  |  | 1676 | 2012-01-16 00:00:00
09-012 |  |  |  | 886 | 2012-01-17 00:00:00
09-013 |  |  |  | 357 | 2012-01-09 00:00:00
09-014 |  |  |  | 2690 | 2012-02-19 00:00:00
09-015 |  |  |  | 1700 | 2012-01-08 00:00:00
09-016 |  |  |  | 938 | 2012-02-15 00:00:00
09-017 |  |  |  | 1278 | 2012-01-02 00:00:00
09-018 |  |  |  | 504 | 2012-02-18 00:00:00
09-019 |  |  |  | 2602 | 2012-02-22 00:00:00
09-020 |  |  |  | 517 | 2012-01-09 00:00:00
09-021 |  |  |  | 2874 | 2012-01-05 00:00:00
09-022 |  |  |  | 1045 | 2012-01-21 00:00:00
09-023 |  |  |  | 2511 | 2012-01-07 00:00:00
09-024 |  |  |  | 1077 | 2012-02-05 00:00:00
09-025 |  |  |  | 2869 | 2012-01-15 00:00:00
09-026 |  |  |  | 974 | 2012-01-19 00:00:00
09-027 |  |  |  | 2078 | 2012-02-07 00:00:00
09-028 |  |  |  | 1225 | 2012-02-06 00:00:00
09-029 |  |  |  | 1773 | 2012-02-18 00:00:00
09-030 |  |  |  | 1811 | 2012-01-18 00:00:00
 |  |  |  | Total to Date
 |  |  |  | Monthly Average
 |  |  |  | Projected Yearly
Spreadsheet: 835498d1688633250-text-split-then-create-spilling-table-textsplit
Sheet: Feuil1

 |  |  |  |  |  |  | EXPECTED RESULT (SPILLING ARRAY)
values |  |  | values |  |  |  | value1 | value2 | value3 | value4
value1:554,value2:36,value3:987 |  |  |  |  |  |  | 554 | 36 | 987
value1:54,value2:396,value4:52 |  |  | value1:54,value2:396,value4:52 |  |  |  | 54 | 396 |  | 52
value3:594,value2:6 |  |  | value3:594,value2:6 |  |  |  |  | 6 | 594
 |  |  |  |  |  |  |  | 36 | 987
 |  |  |  |  |  |  | 54 | 396 |  | 52
 |  |  |  |  |  |  |  | 6 | 594
Spreadsheet: 160037d1338935724-formula-for-sumifs-mock-excel-sheet
Sheet: Sheet2

 |  |  |  | PO Num | Item # | Name | Source Name | Qty | [NAME] | U/M | Backordered
 | Inventory
 |  |  |  | 6290 | Part C |  |  |  |  |  | 40360
 |  |  |  |  |  |  |  |  |  |  | 40360
 |  |  |  | 6551 | Part D |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  |  | 2000
 |  |  |  | 6094 | Part E |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  | 6323 | Part F |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  | 6551 | Part G |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  | 6267 | Part B |  |  |  |  |  | 1700
 |  |  |  |  |  |  |  |  |  |  | 1700
 |  |  |  | 6489 | Part A |  |  |  |  |  | 19950
 |  |  |  |  |  |  |  |  |  |  | 19950
 |  |  |  | 6223 | Part M |  |  |  |  |  | 4600
 |  |  |  | 6267 | Part M |  |  |  |  |  | 150000
 |  |  |  |  |  |  |  |  |  |  | 154600
 |  |  |  | 6267 | Part B |  |  |  |  |  | 115000
 |  |  |  |  |  |  |  |  |  |  | 115000
Spreadsheet: 889924d1740962205-filter-function-nested-if-multi-better-simpler-expression-combobox-filter-4multi-any-search-xl21-dyn-spill-srch-cam-slicer-trick-
Sheet: DATA

MAKE | MODEL | FUEL | TYPE | DESC | IG |  | UNIQUE MAKE |  | Formula SRCH Col A | Formula SRCH Col B | Formula SRCH Col C | Formula SRCH Col D
Peugeot | 2O7 | PETROL | Gti | OK | 15
Peugeot | 3O6 | DIESEL | TD | [NAME] | 13 |  |  |  |  | 2O7 | PETROL | Type R
Honda | Civic | PETROL | Type R | [NAME] | 13 |  |  |  |  | 3 series
Fiat | Panda | PETROL | Dlux | Poor |  |  |  |  |  | 3O6
Citreon | Ax | PETROL | Vibe | Poor |  |  |  |  |  | 3O7
Vauxhall | Nova | PETROL | SRI | Dull | 8 |  |  |  |  | Astra
Rover Metro | Metro | PETROL | Club | Dull |  |  |  |  |  | Ax
Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11 |  |  |  |  | Civic
Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7 |  |  |  |  | Focus
Bmw | 3 series | DIESEL | Tdi | Nice | 10 |  |  |  |  | Impian
Bmw | Z4 | PETROL | Sport | Great | 15 |  |  |  |  | Megane
Bmw | X4 | PETROL | 4WD | 4x4 | 16 |  |  |  |  | Metro
Renault | Megane | DIESEL | Dci | Great | 8 |  |  |  |  | Nova
Proton | Impian | PETROL | Sport | Dull | 8 |  |  |  |  | Panda
Ford | Focus | DIESEL | TDCi | Great | 11 |  |  |  |  | Punto
Honda | Civic | DIESEL | CDTi | Great | 10 |  |  |  |  | X4
Peugeot | 3O7 | DIESEL | Hdi | Super | 11 |  |  |  |  | Z4
Fiat | Punto | PETROL | Sport | Tidy | 8
Vauxhall | Astra | PETROL | VXR | Great | 9
Peugeot | 2O6 | PETROL | GTI | Sporty | 10
Honda | Civic | DIESEL | CDTi | Excellent | 10
Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Bmw | 3 series | DIESEL | Tdi | Nice | 10
Bmw | 3 series | DIESEL | [NAME] | Nice | 10
Spreadsheet: 481637d1474560068-vlook-up-across-2-tables-is-it-possible-excess-lookup
Sheet: Sheet1

Policy Year | Claim Type | Excess
2013 | Liability
2013 | Liability
2013 | Liability
2013 | Liability
2014 | Liability
2014 | Liability
2015 | Property
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Property
Spreadsheet: 144648d1331075409-cell-referencing-test-sheet
Sheet: Sheet1

Jones | [NAME]
1 | Y75
2 | D39
3 | L51
4 | L24
5 | C55
[NAME] | Mark
1 | K12
2 | S72
Simpson | Homer
1 | C55
2 | K12
3 | S72
4 | S72