tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 712805d1610416123-data-transfer-from-one-worksheet-to-others-golf-group-composite-spreadsheet
Sheet: Assignment Sheet

 |  | SUNDAY |  | DATE:
 |  | WEDNESDAY
 |  | Team #1 |  | [NAME] | Strokes |  | GAME
 | 1 |  |  |  |  |  |  | Regular Stroke Play
 | 2 |  |  |  |  |  |  | Match Play
 | 3 |  |  |  | 0 |  |  | Stableford
 | 4 |  |  |  | 0 |  |  | 2-Man Scramble
 | 5 |  |  |  |  |  |  | 3-Man Scramble
 |  |  |  |  |  |  |  | 4-Man Scramble
 |  | Team #2 |  | [NAME] | Strokes |  | SCORING
 | 1 |  |  |  |  |  |  | 1 Low Score
 | 2 |  |  |  |  |  |  | 2 Low Scores
 | 3 | [NAME] |  | 94 | 0 |  |  | 3 Low Scores
 | 4 |  |  |  | 0 |  | TODAY'S LOCAL RULES
 | 5 |  |  |  |  |  |  | Play ball down (as it lies)
 |  |  |  |  |  |  |  | Lift, clean & place within 1 club length no closer to hole
 |  | Team #3 |  | [NAME] | Strokes |  |  | (only where carts can drive)
 | 1 |  |  |  | 0 |  |  | Lift, clean & place within 1 club length, no closer to hole
 | 2 |  |  |  | 0 |  |  | (anywhere on course)
 | 3 |  |  |  | 0 |  |  | Hole-out all scoring balls
 | 4 |  |  |  | 0 |  |  | Gimmies length of "your own" foot
 | 5 |  |  |  | 0 |  | BUNKER PLAY
 |  |  |  |  |  |  |  | Play bunkers as the ball lies
 |  | Team #4 |  | [NAME] | Strokes |  |  | Lift, clean and place within 1 club length, no closer to hole
 | 1 |  |  |  |  |  |  | Remove ball from bunker, no closer to hole
 | 2 |  |  |  | 0 |  |  | Rake and place within 12 inches of original position
 | 3 |  |  |  | 0 |  | WILDCARD PLAYER
 | 4 |  |  |  | 0 |  |  | Charlie for Team #1; [NAME] for Team #2
 | 5 |  |  |  | 0 |  | OTHER
 |  | Team #5 |  | [NAME] | Get /Give Strokes
 | 1
 | 2
 | 3
 | 4
 | 5 |  |  |  | 0
Spreadsheet: 752600d1634842991-returning-one-value-contained-in-a-list-wordmatch_
Sheet: Sheet1

 |  |  | [NAME] attempt | GW attempt |  |  |  | Ideal Answers | GW attempt-2 | GW attempt-3 | [NAME]
 | red |  |  |  |  | red ball, walk, show, tent, invade,matchmake,computer,
 | red ball |  |  |  |  |  |  | Red Ball
 | red pen
 | make
 | shift
 | computer |  |  |  |  |  |  | Computer
Spreadsheet: 867593d1714423829-failed-if-function-pasta1
Sheet: Planilha1

 |  |  |  |  |  |  | 15000 | 15000 | 15000
 |  | 10000 | 0 | 0 | 0 | 0
 |  | 15000 | 0 | 0 | 0 | 0 |  |  |  |  | How can I solve the SE formula when I don't
 |  | 10000 | 0 | 0 | 0 | 0 |  |  |  |  | there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance.
 |  | 0 | 30000 | 0 | 0 | 0 |  |  |  |  | Can you solve this problem?
 |  | 15000 | 0 | 0 | 0 | 0
 |  | 0 | 5000 | 0 | 0 | 0
 |  | 50000 | 0 | 0 | 0 | 0
 |  | 1 | 0 | 0 | 0 | 0
 |  | 15000 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 15000 | 0 | 0 | 0 | 0
Spreadsheet: 115747d1311263519-change-alignment-based-on-if-cell-is-text-or-number-example
Sheet: Sheet1

 |  |  |  |  | 0 |  | 15
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 5
 | What I get |  | What I want
 |  |  | N.A.
 |  |  | 15
 |  |  | 7.5
 |  |  | 5
 |  |  | 3.75
 |  |  | 3
Spreadsheet: 769312d1645463671-count-of-unique-values-with-various-conditions-test-makaveeti-
Sheet: Dashboard

 | Manual Count |  |  | [NAME]
 | All IDs | Match IDs |  | All IDs | Match IDs
Total Users | 593 | 157
Logged in the last 6 months - Yes | 308 | 66
Logged in the last 6 months - No | 285 | 91
In 6 months date from 20th Aug to today
Not in 6 months date from 19th Aug backwards
Spreadsheet: 0b96ff2f-cb07-41a3-b490-dc004f2b7726
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2011-06-10 00:00:00 | Software Packages | ICT | Tor Systems Ltd | 141230 | 45451.96
DCMS | NMSI | 2011-06-10 00:00:00 | Build Construction | York Major project | [NAME] | 141415 | 180695.95
DCMS | NMSI | 2011-06-10 00:00:00 | Professional Fees | ScM Major projects | Universal Design Studio Limited | 141658 | 55250
DCMS | NMSI | 2011-06-10 00:00:00 | Build Construction | National MPG | MB Construction Services Ltd | 141660 | 31032.73
DCMS | NMSI | 2011-06-23 00:00:00 | Legal | Change Management | Drivers Jonas | 142217 | 39800
DCMS | NMSI | 2011-06-23 00:00:00 | Rates (CILOR) | Science Museum Estates | Royal Borough of Kensington & Chelsea | 142278 | 44938
DCMS | NMSI | 2011-06-10 00:00:00 | Contract Cleaning | SCM Visitor Experience | Servest (Sherwood) Ltd | 100415 | 90786.68
DCMS | NMSI | 2011-06-10 00:00:00 | Contract Cleaning | SCM Visitor Experience | Servest (Sherwood) Ltd | 100416 | 90786.68
DCMS | NMSI | 2011-06-10 00:00:00 | Contract Cleaning | SCM Visitor Experience | Servest (Sherwood) Ltd | 100417 | 90786.68
Spreadsheet: 44456d1243225993-skip-blank-cells-seroleh-2
Sheet: Sheet1

 |  | data
 |  | No | Name | Word | Good | Excel | Good
 |  | 631 | [NAME] | 1 |  | 1
 |  | 632 | Beckham |  | 1 | 1 | 1
 |  | 633 | [NAME] | 1 | 1
 |  | 634 | Lampard | 1
 |  | 635 | Gerrard |  | 1 | 1 | 1
 |  | 636 | [NAME] |  |  | 1
 |  | 637 | [NAME] | 1 | 1
 |  | solution
 |  | No | Name
 |  |  | I don't want the #0 on D15, [NAME] and [NAME]. skip it. List down all the name that have 1 at course(word and excel) and their rating(good) in second column in one sheet. Using excel code. I want Like this:
 |  |  | Word |  |  |  | Excel
 |  |  | Name | Good |  |  | Name | Good
 |  | 1 | [NAME] |  |  | 1 | [NAME]
 |  | 2 | [NAME] | 1 |  | 2 | Beckham | 1
 |  | 3 | Lampard |  |  | 3 | Gerrard | 1
 |  | 4 | [NAME] | 1 |  | 4 | [NAME]
Spreadsheet: 224202d1364485176-sorting-project-task-list-with-merged-cells-sample-excelforums-2-solution
Sheet: Sheet1

Stage | Program Components | Sub Task | Assigned Resource | Dates | Status | Communication Manager(M)/ Participant (P) | Location (Delivery Method) | Comments
Stage 1 | Task #1 | Subtask #1 | [NAME], [NAME] | 2013-02-19 00:00:00 | Complete
Stage 1 | Task #1 | Subtask #2 | [NAME], [NAME] | 2013-02-20 00:00:00 | Complete
Stage 1 | Task #1 | Subtask #3 | [NAME], [NAME] | 2013-02-21 00:00:00 | Complete
Stage 1 | Task #1 | Subtask #4 | [NAME], [NAME] | 2013-02-22 00:00:00 | Complete
Stage 1 | Task #2 | Subtask #1 | [NAME], [NAME] | 2013-02-19 00:00:00 | Complete
Stage 1 | Task #2 | Subtask #2 | [NAME], [NAME] | 2013-02-20 00:00:00 | Complete
Stage 1 | Task #2 | Subtask #3 | [NAME], [NAME] | 2013-02-21 00:00:00 | Complete
Stage 1 | Task #3 | Subtask #1 | [NAME] | 2013-02-19 00:00:00 | Complete
Stage 1 |  | Subtask#2 | [NAME] | Feburary 19, 2013 | Complete
Stage 1 | Task #3 | Subtask #3 | [NAME] | Feburary 19, 2013 | Complete
Stage 1 | Task #4 | Subtask #1 | [NAME] | 2013-02-19 00:00:00 | Complete
 |  |  |  |  |  |  | Delivered to Home
 |  |  |  |  |  |  | Delivered to Home
 |  |  |  |  |  |  | Mailed to home
 |  |  |  |  |  |  | Delivered to Home
Spreadsheet: 82084d1282136892-clone-worksheet-from-one-workbook-to-another-sample-summary-2
Sheet: Summary

Plan: | 401k
Employer: | Doe, Inc.
Year: | 1/1/10 - 12/31/10
 |  | Platform | Employee |  | Employee | Employee | Employee | Employee |  | Beginning
SS | Participant | Employee | Receivable | Total | Contribution | Gain/Loss | Fees | Distribution | Forfeiture | Balance | Proof
1 | Doe, [NAME] | 13535.11 | 0 | 19032.43 | 4000 | 988.98 | -15 | 0 | 0 | 14058.45 | 0
2 | Doe, [NAME] | 1687.52 | 0 | 7229 | 1000 | 804.52 | -15 | 0 | 0 | 5439.48 | 0
3 | Doe, [NAME] | 26497.21 | 0 | 31632.1 | 2500 | 664.99 | -15 | 0 | 0 | 28482.11 | 0
4 | Doe, [NAME] | 4884.66 | 0 | 10078.37 | 2000 | 980.44 | -15 | 0 | 0 | 7112.93 | 0
 | Ending Balance | 46604.5 | 0 | 67971.9 | 9500 | 1401.54 | -60 | 0 | 0 | 55092.97 | 0
 |  |  |  | 67971.9
 | Statement Balance | 46604.5 |  | 67971.9 | 9500 | 1401.54 | -60 | 0 | 0 | 55092.97
 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0
Spreadsheet: 106469d1303756382-cross-referencing-with-partial-match-list-sample-forum-upload
Sheet: All Prods

Submitted Description | Correct Description
0.5W LED MINI LNTRN GIFT
10 WATT PRACTICE AMP
10 X 25 MONOCULAR PMU
100 YR CALENDAR V1.5
[NAME]
10X25 DIGITL CAMERA BINO
11-IN-1 TOOL W LED
12 LANG TRANSLTR
12 MSG TOPPER WITH HEAT
12IN1AUTO EMERGENCY TOOL
16 FOOT TELESCOPING POLE
16000 BTU PORTABLE AC
16000 BTU PORTABLE AC
16X7 GARAGE SCREEN
180S JVC EAR WARMER
18IN WREATH MULTI KIT
19IN EXP HRDSD,SLVR
1X7X LIGHTD MIRROR/CLK
2 FLOW HAND SHOWERHEAD
2 ZONE WINE CELLAR
2 ZONE WINE CELLAR BAR
20 FOOT TAPERED FLAGPOLE
21 IN EXP HRDSD,SLVR
21 INCH QUILTD BAG BLACK
21.5IN EXP HRDSD, GRN
21.5IN EXP HRDSD,PNK
21.5IN EXP HRDSD,RED
21.5IN EXP HRDSD,SLVR
21.5IN EXP HRDSD,YLLW
21.5IN EXP HRDSDE, BLK
21IN BALLSTC
Spreadsheet: 56c8f55f-94b2-4b57-8291-349316e645bb
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (2 Entries):
 | 7 Biotechnology 7.14 Proteomics 7.14.7 Protein chips
No. | Company | Country | City | [NAME] | Hall/Booth
1 | European Biotech Network | Belgium | Dolembreux | 4140 | A3.254
2 | Luminex B.V. | Netherlands | Oosterhout | 4906 CR | A3.311
Spreadsheet: 758650d1638983581-is-there-any-possiblity-to-do-several-plots-out-of-a-column-in-one-diagram-excel_plot
Sheet: Tabelle1

 | Date | Timestamp | Boolean | elapsed time [h] | Value
 | 2021-12-07 00:00:00 | 14:00:00 | False | 0 | 1e-06
 | 2021-12-08 00:00:00 | 15:00:00 | False | 25 | 8e-07
 | 2021-12-09 00:00:00 | 15:30:00 | False | 49.5 | 5e-07
 | 2021-12-09 00:00:00 | 17:12:00 | True | 1.699999999999999 | 5e-07
 | 2021-12-10 00:00:00 | 15:54:00 | False | 24.4 | 4e-07
 | 2021-12-10 00:00:00 | 17:00:00 | False | 25.5 | 3.8e-07
 | 2021-12-11 00:00:00 | 02:00:00 | False | 34.5 | 3.8e-07
 | 2021-12-12 00:00:00 | 15:34:00 | False | 72.06666666666666 | 3.5e-07
 | 2021-12-12 00:00:00 | 16:00:00 | False | 72.5 | 2.1e-07
 | 2021-12-14 00:00:00 | 13:00:00 | False | 117.5 | 1e-07
 | 2021-12-14 00:00:00 | 15:00:00 | True | 2.000000000000001 | 9e-08
 | 2021-12-15 00:00:00 | 09:00:00 | False | 20 | 8.5e-08
 | 2021-12-15 00:00:00 | 13:00:00 | False | 24 | 8.4e-08
 | 2021-12-16 00:00:00 | 01:20:00 | False | 36.33333333333334 | 8.3e-08
Spreadsheet: f6f1ee36-85c6-4c87-a335-0a5cbb3b2d93
Sheet: Sheet1

Unnamed: 0 | COL_MSG | COL_CODE_DATES | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | COL_MNT_DATE_CHK | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
LN_NO_GROUPE | Employer's no. | 66329
LN_NOM_EMPL | Employer's name | Metal Work inc.
LN_MOIS_REMISE |  |  | Remittance month |  | Mois de remise | 2013-02
LN_RESP_FACT | Payroll responsible | [NAME]
[NAME] | Service | Payroll service | Total employee |  |  | 0 |  |  | Cheque
LN_ENTREPRISE | Company | Metal Work inc. | Total employer |  |  | 0 |  |  | Electronic payment (Internet)
LN_TOTAL_AUTRE |  |  | Total other |  |  | 0 |  |  | Bank transfer
[NAME] |  |  | Total contribution |  |  | 0
LN_SOLDE | Remittance for the period | 2013-01-30 to 2013-02-26 | Balance |  |  | 0
LN_MNT_CHK | Corrected remittance period |  | Payment amount
LN_DATE_CHK |  |  | Date of payment
LN_DT_DEB | Début 1ère période de paie couverte | 2011-01-29 |  |  |  |  | Payment amount page 1 | Corrected period remittance page 1 | Payment amount page 1    |    Date of payment page 1    |    Payment method page 1    |    Corrected period remittance page 1
LN_DT_FIN | Fin dernière période de paie couverte | 2011-02-25 |  |  |  |  | Date of payment page 1 |  | Payment method page 1
 |  |  | Payment method
LN_MSG | Remittance for the month must be received by the 15 of the following month. For more information, contact the Employers Services at (514) 385-3723  or from outside Montreal at [PHONE].
 | Missing: Payment amount page 1   |  Date of payment page 1   |   Payment method page 1   |   Corrected remittance period page 1
LN_MSG1
LN_MSG2
Spreadsheet: 136112d1326409942-text-data-manipulation-from-different-dumps-text-data-manipulation
Sheet: Sheet1

[NAME] we receive data | Personnel Number |  |  | Personnel Number
[NAME] | 333 |  |  | Smith 0333
[NAME] | 1234 |  |  | Umber-Green 1234
[NAME] | 5678 |  |  | Grey 5678
All in One |  |  |  | in One
[NAME] 0333 |  |  |  | Smith 0333
[NAME] 1234 |  |  |  | Umber-Green 1234
[NAME] 5678 |  |  |  | Grey 5678
Forename | Middle | Surname | Personnel Number | Personnel Number
[NAME] |  | Smith | 333 | Smith 0333
[NAME] |  | Umber-Green | 1234 | Umber-Green 1234
[NAME] | R | Grey | 5678 | Grey 5678
Spreadsheet: 887184d1737400747-copying-similar-data-from-multiple-sheets-onto-one-summary-sheet-how-to-quickly-and-easily-test1
Sheet: Sheet2

INFORMATIONAL CERTIFICATE
PUT Type: | RTD
PUT Tag No.: | 281-TE-5712G-B
Tolerance: | Class A
Calib. Ambient Temp. | 22
Calib. Date: | Dec. 02 2024
Actual Temperature (°C) | PUT Output (Ohms) | T  PUT Output (°C) | Deviation from Actual (°C) | Acceptable Tolerance (°C) •
-0.03 | 100.049 | 0.13 | 0.16 | 0.13
NOTES:  PUT = Probe Under Test PRT = Platinum Resistance Thermometer
All calibrations are based on ITS-90 temperature scale.
Approved by:
Performed by:
TV
00506, Rev.8, 2013-08-30, 1/1
Spreadsheet: 87852d1287712450-excel-2007-make-text-like-mode-fuction-code-breaker
Sheet: Sheet1

intergrated similarites 1. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IN
intergrated similarites 2. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OUT
intergrated similarites 3.
intergrated similarites 4.
intergrated similarites 5. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a |  | most used
intergrated similarites 6. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b |  | second most
intergrated similarites 7. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c |  | third most
 |  | IN | a | f | f | r | o | n | t |  |  |  |  |  |  |  | d |  | fouth most
 |  | IN | c | o | n | t | e | n | t |  |  |  |  |  |  |  | e
 |  | IN | c | a | l | l | i | n | g |  |  |  |  |  |  |  | f
 |  | IN | w | a | n | t | i | n | g |  |  |  |  |  |  |  | g |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | IN | l | a | r | g | e | s | t |  |  |  |  |  |  |  | h |  |  |  |  |  | i | n | g
 |  | IN | b | a | r | r | e | n | s |  |  |  |  |  |  |  | i
 |  | IN | w | o | r | k | i | n | g |  |  |  |  |  |  |  | j
 |  | IN | s | e | a | l | i | n | g |  |  |  |  |  |  |  | k |  |  | n | 5
 |  | IN | d | e | c | l | i | n | e |  |  |  |  |  |  |  | l |  |  | d | 3
 |  | IN | h | e | a | l | i | n | g |  |  |  |  |  |  |  | m |  |  | i | 2
 |  | IN | d | e | n | y | i | n | g |  |  |  |  |  |  |  | n |  |  | r | 3
 |  | IN | s | e | r | m | o | n | s |  |  |  |  |  |  |  | o |  |  | w | 2
 |  | IN | w | a | r | r | i | o | r |  |  |  |  |  |  |  | p |  |  | a | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | q
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z
Spreadsheet: 35123d1232638375-search-for-hidden-data-league-table
Sheet: workings

 | BOURNEMOUTH |  | BRIGHTON |  | BRISTOL ROVERS |  | CARLISLE |  | CHELTENHAM |  | CREWE |  | DONCASTER |  | GILLINGHAM |  | HARTLEPOOL |  | HUDDERSFIELD |  | LEEDS |  | LEYTON ORIENT |  | LUTON |  | MILLWALL |  | NORTHAMPTON |  | NOTTINGHAM FOREST |  | OLDHAM |  | PORT VALE |  | SOUTHEND |  | SWANSEA |  | SWINDON |  | TRANMERE |  | WALSALL |  | YEOVIL |  |  | goals scored | goals against |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WINS | DRAWS | LOSSES
BOURNEMOUTH
BRIGHTON
BRISTOL ROVERS
CARLISLE
CHELTENHAM
CREWE
DONCASTER
GILLINGHAM
HARTLEPOOL
HUDDERSFIELD
LEEDS
LEYTON ORIENT
LUTON
MILLWALL
NORTHAMPTON
NOTTINGHAM FOREST
OLDHAM
PORT VALE
SOUTHEND
SWANSEA
SWINDON
TRANMERE
WALSALL
YEOVIL
WINS
DRAW
LOSE
Spreadsheet: 806904d1669658426-numbering-tasks-and-sub-tasks-sdm-task-list_cash
Sheet: Master_Task_List

SDM Task ID # | Product | Section | Sub-Section | Task | Start Date | Duration | End Date | Progress    (Days Completed)
1.04.01.01 | Print | Lighting | Introduction | Proof read for updates | 2022-11-23 00:00:00 | 7 | 2022-12-01 00:00:00
1.04.02.01 | Print | Lighting | Standard Poles | Send to lighting for comments | 2022-11-24 00:00:00 | 7 | 2022-12-02 00:00:00
2.06.02.01 | Online | Landscape | Tree Beds | Review | 2022-11-27 00:00:00 | 2 | 2022-11-29 00:00:00
2.05.05.01 | Online | Furniture | other elements | Review with street furnishings for updates | 2022-11-28 00:00:00 | 2 | 2022-11-29 00:00:00
Spreadsheet: 215abfb2-a386-4ec8-b225-ffd6d1fd00dc
Sheet: Sheet1

Start Date | End Date | Meeting Name | HQ Hotel | Venues | Attendees
2015-06-08 00:00:00 | 2015-06-08 00:00:00 | Clark County School District Veterans Tribute CTA Graduation | Cashman Center | Cashman Center | 2000
2014-11-22 00:00:00 | 2014-11-22 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
2014-11-06 00:00:00 | 2014-11-06 00:00:00 | [NAME]/ASPA Connecting for Change Conference | Cashman Center | Cashman Center | 200
2014-10-25 00:00:00 | 2014-10-25 00:00:00 | Seventh-Day Adventist Church Nevada / Utah Conference Las Vegas Convocation | Cashman Center | Cashman Center | 5000
2014-10-20 00:00:00 | 2014-10-20 00:00:00 | Nevada Future Business Leaders Fall Leadership Extravaganza | Cashman Center | Cashman Center | 650
Spreadsheet: 83026d1283047104-sorting-and-summing-for-a-bank-statement-bankstatement
Sheet: Sheet1

 | Spent | [NAME] | Supplier Category
 | 54 | Superstore #3 |  |  | Gasbar #1 | Gas |  | Row Labels | Sum of Spent
 | 55 | Gasbar #5 |  |  | Gasbar #2 | Gas |  | Gas | 211
 | 12 | Superstore #2 |  |  | Gasbar #3 | Gas |  | Superstore | 254
 | 5 | Walmart #5 |  |  | Gasbar #4 | Gas |  | Walmart | 170
 | 48 | Superstore #3 |  |  | Gasbar #5 | Gas |  | Grand Total | 635
 | 75 | Superstore #2 |  |  | Gasbar #6 | Gas
 | 25 | Gasbar #5 |  |  | Gasbar #7 | Gas
 | 14 | Gasbar #6 |  |  | Gasbar #8 | Gas
 | 25 | Gasbar #5 |  |  | Superstore #1 | Superstore
 | 46 | Walmart #2 |  |  | Superstore #2 | Superstore
 | 64 | Walmart #5 |  |  | Superstore #3 | Superstore
 | 65 | Superstore #3 |  |  | Superstore #4 | Superstore
 | 26 | Gasbar #2 |  |  | Superstore #5 | Superstore
 | 66 | Gasbar #7 |  |  | Walmart #1 | Walmart
 | 55 | Walmart #4 |  |  | Walmart #2 | Walmart
 |  |  |  |  | Walmart #3 | Walmart
 |  |  |  |  | Walmart #4 | Walmart
 |  |  |  |  | Walmart #5 | Walmart
 | In this example there are 3 different stores (Superstore, Walmart and Gasbar). But there is more than one of each. I want to see a sum of all purchases made at all Walmarts combined, [NAME] combined, and  gasbars combined. Sort and subtotal will total each individulal Walmart ect..
Spreadsheet: 293594d1391029706-help-with-combining-information-from-two-workbooks-adriscott-sample-1-
Sheet: Sheet2

Business Name | # | Street
 | 86 | 7th Avenue
 | 89 | 7th Avenue
 | 90 | 7th Avenue
 | 97 | 7th Avenue
 | 100 | 7th Avenue
 | 106 | 7th Avenue
 | 108 | 7th Avenue
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 5789 | 7579
2 | 2411 | 7579
3 | 7806 | 7579
4 | 7637 | 7579
5 | 7209 | 7579
6 | 4529 | 7579
7 | 1886 | 7579
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 326755
2001-08-07 00:00:00
CBS Volume
 |  |  | 6289
Spreadsheet: 756024d1637244978-if-text1-and-text-2-are-equal-to-text-3-then-return-value-catalogue-issue
Sheet: Sheet1

 | Order Code | PP |  | Order Code | PP,OS,NH | NH | Code Insert | Code Price
 | 1433 | 28.5 |  | 1433 | NH | 20 | CDG
 | ABA | 70.24 |  | ABA | NH | 68 | [NAME] |  |  | Follow the steps in the comments
 | [NAME] | 109.94 |  | [NAME] | NH | 68 | XSTA |  |  | It doesn’t follow the steps I need but I would like it work so that whatever code I place in the column "code insert",  it should return the price value into the cell to the right with the price according to the acronymn in the "PP,OS,NH". As in if [NAME] is entered and the cell to the right of [NAME] in the order code column states its PP then £47.53 IS returned.
 | ACCR | 25.45 |  | ACCR | NH | 20 | CLDH
 | AZ1 | 132 |  | AZ1 | PP | 145 | CSFG
 | CSFA | 110 |  | CSFA | NH | 110 | GAB1
 | XSTA | 55 |  | XSTA | NH | 55 | [NAME]
 | Triage | 85 | 0 | Triage | NH | 59 | NMAG
 | CDG | 53.95 |  | CDG | pp | 50 | AZ1
 | CFER | 10.18 |  | CFER | NH | 5 | CGAD
 | CIGM | 10 |  | CIGM | PP | 6 | NEUR
 | CLDH | 12 |  | CLDH | PP | 8 | CSFL
 | CNFL | 45 |  | CNFL | PP | 40 | DPPX
 | CSFG | 12.22 |  | CSFG | NH | 10 | GAD
 | CSFL | 25.45 |  | CSFL | PP | 20 | CSFG
 | DPPX | 50 |  | DPPX | NH | 50 | VEGF
 | GAB1 | 47.85 |  | GAB1 | PP | 40 | OCB
 | GAB2 | 32.58 |  | GAB2 | NH | 20 | CNEU
 | [NAME] | 47.85 |  | [NAME] | PP | 40 | PLAC
 | GAD | 30 |  | GAD | NH | 30 | NMDA
 |  | 30 |  |  |  | 30 | NMOD
 | CGAD | 30 |  | CGAD | NH | 30 | NCYK
 | NABS | 53.95 |  | NABS | PP | 90 | PLAC
 | NCYK | 0.01 |  | NCYK | NH | 0.01
 | NEUR | 54.97 |  | NEUR | PP | 40
 | CNEU | 54.97 |  | CNEU | NH | 40
 | NIAT | 35 |  | NIAT | PP | 35
 | PLAC | 8.14 |  | PLAC | NH | 5.09
 | NLAC | 8.14 |  | NLAC | PP | 5
 | NMAG | 30 |  | NMAG | NH | 30
 | CNMD | 50 |  | CNMD | PP | 40
 | NMDA | 50.9 |  | NMDA | NH | 40
 | CMOD | 45 |  | CMOD | PP | 40
 | NMOD | 45 |  | NMOD | NH | 40
 |  | 5 |  |  |  | 5
 | OCB | 47.85 |  | OCB | PP | 45
 | [NAME] | 55 |  | [NAME] | NH | 55
 | S100 | 70 |  | S100 | PP | 40
 | VEGF | 59.04 |  | VEGF | NH | 55
 | CVKC | 100 |  | CVKC | PP | 75
 | VKCA | 100 |  | VKCA | NH | 75
 | XANT | 98.75 |  | XANT |  | 58
Spreadsheet: 724270d1616091438-2-way-index-match-headache-sample_online
Sheet: Data

 | TABLE1
 | Year | Month | Metric | Lookup | Target | Actual | [NAME] | Bonus_Baseline | %Payout
 | 2021 | January | Profit |  | 1000000 | 1060000 |  | 700
 | 2021 | January | Count |  | 4000 | 3789 |  | 500
 | 2021 | February | Profit |  | 978686 | 812668 |  | 575
 | 2021 | February | Count |  | 3741 | 3855 |  | 600
 | [NAME]
 | Year | Month | Metric | Low | High | %Bonus_Earned | Lookup
 | 2021 | January | Profit | -1 | -0.2 | 0
 | 2021 | January | Profit | -0.1999 | -0.15 | 0.5
 | 2021 | January | Profit | -0.1499 | -0.1 | 0.65
 | 2021 | January | Profit | -0.0999 | -0.05 | 0.75
 | 2021 | January | Profit | -0.0499 | -0.0001 | 0.9
 | 2021 | January | Profit | 0 | 1 | 1.25
 | 2021 | January | Count | -1 | -0.5 | 0
 | 2021 | January | Count | -0.4999 | -0.25 | 0.15
 | 2021 | January | Count | -0.2499 | -0.0001 | 0.4
 | 2021 | January | Count | 0 | 0.08 | 0.65
 | 2021 | January | Count | 0.0801 | 0.2 | 0.9
 | 2021 | January | Count | 0.2001 | 1000 | 1.5
 | 2021 | February | Profit | -1 | -0.4 | 0
 | 2021 | February | Profit | -0.3999 | -0.2 | 0.48
 | 2021 | February | Profit | -0.1999 | 0.0001 | 0.63
 | 2021 | February | Profit | 0 | 0.15 | 0.73
 | 2021 | February | Profit | 0.1501 | 1000 | 0.88
 | 2021 | February | Profit | 0 | 1 | 1.23
 | 2021 | February | Count | -1 | -0.75 | 0.02
 | 2021 | February | Count | -0.7499 | -0.25 | 0.13
 | 2021 | February | Count | -0.2499 | -0.0001 | 0.38
 | 2021 | February | Count | 0 | 0.08 | 0.61
 | 2021 | February | Count | 0.0801 | 0.2 | 0.75
 | 2021 | February | Count | 0.2001 | 1000 | 1