tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b9cd02f5-16e8-4e01-b6d3-e8e76a142e6a
Sheet: Sheet1

 | WANNEROO SPORTS AND SOCIAL CLUB
 | SATURDAY PENNANT PRACTICE - 13/10/12
 | Team Managers in Blue
 | PREMIER LEAGUE - HOME
 | Skipper | Third | Second | Lead
 | C Adams | J ODonohoe | M Hulbert | G Gunning
 | R Bates | D Moore | K Boswell | L Bryson
 | D Turra | T Kay | L [NAME] | [NAME]
 | B [NAME] | N Costello | J Weir | I [NAME]
 | DIVISION 1 BLUE NORTH - AWAY TO TATTERSALLS - BUS LEAVES AT 11:15AM
 | Skipper | Third | Second | Lead
 | D Triffitt | H Ward | S Denny | P Potts
 | M Golding | D Watson | N Palmer | D Dobb
 | D Bowen | [NAME] | J [NAME] | M Brown
 | M Nievelstein | C Buchholz | B Sing | [NAME]
 | DIVISION I BLUE SOUTH - HOME
 | Skipper | Third | Second | Lead
 | K Broad | M McMurdo | B [NAME] | M McGillivray
 | J Ingram | B Mulroy | R Ryan | S Ingram
 | [NAME] | R Beazley | C Kingston | G Lindsay
 | B [NAME] | J Pordan | A Smith | W Neilson
 | DIVISION 3 GOLD - AWAY TO TATTERSALLS - BUS BLEAVES 11:15AM
 | Skipper | Third | Second | Lead
 | T Traynor | P McGinn | L Gordon | P Firth
 | G Sarich | D Humphries | S Norman | J Rogers
 | V Humphries | J Marinovich | C Tremlett | P Gooch
 | B [NAME] | R Connor | M Wild | G Scorer
 | DIVISION 4 GOLD - HOME
 | Skipper | Third | Second | Lead
 | B Cowan | J Woods | R Prosser | R Pitts
 | T Pethrick | D Bennett | M Morgan | B [NAME]
 | V Street | D Hampton | M Harper | [NAME]
 | R McKenzie | P [NAME] | P Huddy | J Smith
 | DIVISION 5 GOLD - HOME
 | Skipper | Third | Second | Lead
 | C McEvoy | D Snooks | K Coulson | M Bergensen
 | C Woods | B [NAME] | J Parker | G Wylie
 | K Styles | B Atkins | B White | W Okis
 | P Quick | M Danker | N Raar | R [NAME]
Spreadsheet: 457146d1461222157-select-best-supplier-choose-min-if-none-suppliers
Sheet: Products

SKU | Description | Category | Sales Price | Supplier | Purchase price | In stock
100001 | Product A | Category A | 1499
100002 | Product B | Category A | 5499
100003 | Product A | Category B | 149
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: Jun 24

2024 WORKSHEET
Source: |  |  | Daily Sheets |  |  | ABC |  |  |  |  |  |  |  | MONTH |  |  |  |  |  | 2024-06-01 00:00:00
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY |  | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
Total
avg
 |  |  |  |  |  | 4TH FL |  |  |  |  |  |  |  | MONTH:
Source: |  |  | Daily Sheets
Total
avg
Source: |  |  | Daily Sheets |  |  | 5TH FL |  |  |  |  |  |  |  | MONTH:
Total
avg
 |  |  |  |  |  | 6TH FL |  |  |  |  |  |  |  | MONTH:
Source: |  |  | NICU Daily Sheets
Total
avg
 |  |  |  |  |  | DEF |  |  |  |  |  |  |  | MONTH:
Source: |  |  | MCH Daily Sheets
Total
avg
 |  |  |  |  |  | GHI |  |  |  |  |  |  |  | MONTH:
Source: |  |  | MCH Daily Sheets
Total
avg
 |  |  |  |  |  | JKL |  |  |  |  |  |  |  | MONTH:
Source: |  |  | MCH Daily Sheets
Total
avg
 |  |  |  |  |  | MNO |  |  |  |  |  |  |  | MONTH:
Source: |  |  | Daily Sheets
Total
avg
 |  |  |  |  |  | 3RD FL |  |  |  |  |  |  |  | MONTH:
Source: |  |  | Daily Sheets
Total
avg
Spreadsheet: 65627d1266337124-cell-reference-example1-2
Sheet: Sheet1

 |  |  |  |  |  |  |  | Item # | Target |  | Oct 07 | Nov 07 | Dec 07 | Jan 08 | Feb 08 | [NAME] 08 | Apr 08 | May 08 | Jun 08 | Jul 08 | Aug 08 | Sep 08 | Oct 08 P1Y09 | Nov 08 P2Y09 | Dec 08 P3Y09 | Jan 09 P4Y09 | Feb 09 P5Y09 | Mar 09 P6Y09 | Apr 09 P7Y09 | May 09 P8Y09 | Jun 09 P9Y09 | Jul 09 P10Y09 | Aug 09 P11Y09 | Sep 09 P12Y09 | Oct 09 P01Y10 | Nov 09 P02Y10 | Dec 09 P03Y10 | Jan 09 P04Y10 |  |  |  |  |  | NOTES |  |  | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
 |  |  |  |  |  |  |  | 4.3 | >94% | 0.94 |  |  |  | 0.07043650793650794 | 0.3898809523809524 | 0.8928571428571428 | 0.9952380952380953 | 0.9938271604938271 | 0.5059523809523809 | 0.5726190476190476 | 0.8705357142857143 | 0.3708 | 0.4607 | 0.5086 | 0.5225 | 0.5854 | 0.7961 | 0.9464 | 0.9828 | 0.9136 | 0.9762 | 0.9559 | 0.9252 | 0.9383 | 0.9642 | 0.8475 | 0.8965 | 0.927 | Y | I | n | n |  |  | Y |  | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 4.4 | 0.98 | 0.98 |  |  |  | 0.5060881691223841 | 0.6616 | 0.627 | 0.7204 | 0.7168 | 0.7277 | 0.6265 | 0.6117 | 0.5566 | 0.6016 | 0.5195 | 0.5055 | 0.5197 | 0.8077 | 0.8922 | 0.9407 | 0.9687 | 0.9654 | 0.9522 | 0.9848 | 0.9726 | 0.9972 | 0.9839 | 0.9744 | 0.984 | Y |  | n | n |  |  | Y |  | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  | 0.02 | 0.02 |  |  |  |  | 0.057 | 0.048 | 0.072 | 0.092 | 0.072 | 0.076 | 0.071 | 0.053 | 0.051 | 0.064 | 0.057 | 0.047 | 0.05 | 0.032 | 0.024 | 0.022 | 0.017 | 0.019 | 0.012 | 0.017 | 0.01 | 0.016 | 0.019 | 0.014 | N |  | y |  |  |  | N |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | 4.4 | 0.95 | 0.95 |  |  |  | 0.814046007369374 | 0.8814989714850582 | 0.850837462969952 | 0.9013490540928736 | 0.8905012783082142 | 0.9093605357775864 | 0.9026937950937951 | 0.8737451537433156 | 0.8686 | 0.874 | 0.8536 | 0.8499 | 0.86 | 0.8895 | 0.9068 | 0.9155 | 0.9496 | 0.9271 | 0.9612 | 0.9632 | 0.9677 | 0.9742 | 0.9816 | 0.9776 | 0.9693 | Y |  | y |  |  |  | Y |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These are the formulas that I would like to reference the latest 6 months
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | When I insert a new month I will insert it between AM and AN |  |  |  |  |  |  |  |  | when I insert the new month.
 |  |  |  |  |  | Target |  |  | VQG |  |  |  | 12.68 | 12.68 | 12.68 | 15.59 | 15.59 | 15.59 | 14.12 | 14.12 | 14.12 | 15.43 | 15.43 | 15.43 | 14.22 | 14.22 | 14.22 | 13.73 | 13.73 | 12.91 | 13 | 13.02 | 13.52 | 13.62 | 13.45 | 14.56 | 14.4 | N |  |  |  |  |  |  | No
 |  |  |  |  |  | Actual |  | 4.5 | < VQG |  |  |  | 12.45196822514753 | 15.06067340267459 | 13.67 | 13.242 | 13.2825 | 13.3525 | 16.17 | 17.135 | 15.67 | 14.35 | 14.22 | 15.1 | 15.09 | 14.2 | 13.5 | 12.19 | 11.75 | 12.69 | 12.73 | 12.47 | 13.42 | 13.58 | 13.26 | 14.24 | 14.17 | Y |  | y |  |  |  |  | M6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12.87333333333333 | 1 | 1 | 1 | 4.5 |  |  |  | 1
Spreadsheet: 65f8c35f-7cef-4338-a185-c950054aa9ea
Sheet: Payments

Monthly OATT Schedule 1 Regional Network Service (RNS) Settlement
TR_OATTSCH1RNS_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Customer Details |  |  |  | Pool Details |  | Payment
[NAME] Number | [NAME] Name | Customer OATT Schedule 1 Revenue Requirements Dollars | Customer OATT Schedule 1 Revenue Requirements Percent | Pool OATT Schedule 1 RNS Charge | Pool OATT Schedule 1 Revenue Requirements Dollars | OATT Schedule 1 RNS Payment
String | String | $ | % | $ | $ | $
Spreadsheet: louise_kitchen__22784__Residualassets
Sheet: Retained Value or Liability

 |  |  |  |  |  | *For internal use only
Disposed Assets
Status of Retained Value or Liability
As of April 25, 2001
 |  | Investment Name | Funding Vehicle | Type of Investment | Retained Value or Liability | Resolution/Comments
 | Retained Assets
 |  | Allied Integrated Materials (LSI) | [NAME] | Equity - Private | 29.5% LP Interest | Active in Special Assets
 |  | Basic Energy | [NAME] | Equity - Private | Cash flow participation | Active in Special Assets
 |  | Blue Moon Holdings LLC | B/S | Equity - Private | Remaining LLC Interest | Will be reviewed by Legal.
 |  | [NAME] LLC | [NAME] I | Equity - Real Property | Exploration option (EI 30) | Special Assets to monitor.
 |  | Forman Petroleum Co. | [NAME] I | Equity - Real Property | Retained ORRI | Active in Energy Capital Resources.
 |  | [NAME] | [NAME] | Equity - Public | Common Stock - Settlement of FORCE Energy VPP deficiency | Active in Energy Capital Resources
 |  | Midwest Gas Storage | [NAME] I | Debt | Equity - Income Participation | Special Assets to monitor.
 |  | Neutralysis Industries Development Company | B/S | Equity - Private | Retained Warrants | Active in Special Assets
 |  | Southwest Royalties | [NAME] I | Equity - Private | Retained Warrants | Active in Special Assets
 |  | Sweetwater Gas Partners LP | [NAME] I | Equity - Real Property | WI/ORRI from Farmout | Will be reviewed by Landman/Legal.
 | Bankruptcy / Guarantor Claim
 |  | Costilla Energy, Inc | JEDI II & B/S | Equity - Public | Bankruptcy | Special Assets and Legal to monitor bankruptcy proceedings.
 |  | Hogan Exploration LLC | B/S | Equity - Private | Active Bankruptcy | Special Assets and Legal to monitor bankruptcy proceedings.
 |  | Ice Drilling | EnSerCo | Debt | Guarantors - C$1.6MM balance | Active in Special Assets
 | Bankruptcy / Guarantor Claim
 |  | Noram Offshore Ltd | EnSerCo | Debt | Guarantors & other collateral | Active in Special Assets
 |  | Qualitech Steel Corporation | B/S | Debt | Active Bankruptcy | Special Assets and Legal to monitor bankruptcy proceedings.
 | Legal Documentation Closure Required
 |  | Browning Exploration LP | [NAME] | Equity - Private | Partnership interest in Browning | Legal to prepare assignment documents -  2Q-01
 |  | KMS | B/S | Equity - Private | Retained Joint Venture Interest | Legal to unwind in 2Q-01.
Spreadsheet: 487137d1477932827-formula-to-consolidate-tables-consolidatetables2
Sheet: Table3

DESIRED RESULT
Code | Name | Age | [NAME] | Age2 | Name3 | Age3 | Name4 | Age4 | Name5 | Age5 | Name6 | [NAME]
A16 | [NAME] | 43 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
R6O | [NAME] | 29 | [NAME] |  | Londa |  | [NAME] |  | Ursula |  | Gavin
69U | [NAME] | 32 | [NAME] |  | [NAME]
TEST
A16
R6O
69U
Spreadsheet: 175235d1345468935-macro-to-check-column-a-and-copy-text-from-cell-above-task-codes
Sheet: Sheet1

Task Code | <---BEFORE |  | Task Code | <--AFTER
1001 |  |  | 1001
 |  |  | 1001
 |  |  | 1001
 |  |  | 1001
1003 |  |  | 1003
 |  |  | 1003
 |  |  | 1003
 |  |  | 1003
 |  |  | 1003
 |  |  | 1003
 |  |  | 1003
1234 |  |  | 1234
 |  |  | 1234
 |  |  | 1234
 |  |  | 1234
 |  |  | 1234
2226 |  |  | 2226
 |  |  | 2226
 |  |  | 2226
 |  |  | 2226
 |  |  | 2226
2359 |  |  | 2359
 |  |  | 2359
 |  |  | 2359
2360 |  |  | 2360
 |  |  | 2360
 |  |  | 2360
 |  |  | 2360
 |  |  | 2360
2401 |  |  | 2401
 |  |  | 2401
2402 |  |  | 2402
 |  |  | 2402
 |  |  | 2402
3333 |  |  | 3333
 |  |  | 3333
3334 |  |  | 3334
 |  |  | 3334
 | additioanl data here |  | 3334
Spreadsheet: 165967d1341411811-removing-extensive-duplicates-copy-of-sorting-1
Sheet: Sheet1

 |  | Name | Quantity | Price |  | Name | Quantity | Price
 | North | Apple | 3 | 1 |  | Apple | 13 | 1
 | North | [NAME] | 5 | 2 |  | [NAME] | 15 | 2
 | North | Bean | 7 | 4 |  | Bean | 21 | 4
 | North | Orange | 2 | 3 |  | Orange | 31 | 3
 | North | PineApple | 1 | 6 |  | PineApple | 3 | 6
 | North | Apple | 4 | 1
 | North | Orange | 7 | 3
 | South | Apple | 2 | 1
 | South | [NAME] | 5 | 2
 | South | Bean | 7 | 4
 | South | Orange | 6 | 3
 | South | PineApple | 1 | 6
 | South | Apple | 2 | 1
 | South | Orange | 6 | 3
 | Middle | Apple | 1 | 1
 | Middle | [NAME] | 5 | 2
 | Middle | Bean | 7 | 4
 | Middle | Orange | 5 | 3
 | Middle | PineApple | 1 | 6
 | Middle | Apple | 1 | 1
 | Middle | Orange | 5 | 3
Spreadsheet: 836444d1689356080-iferror-vlookup-with-an-if-isna-condition-multiple-vlookup-test
Sheet: Review

VPC ID | Phase 2 Lookup | Phase 3 Lookup | Combined Phase Lookup | TMS | Hans | Phuocam
vpc-123456
vpc-123457
vpc-123458
vpc-123459
vpc-123460
vpc-123461
vpc-123462
vpc-123463
vpc-123464
vpc-123465
vpc-123466
vpc-123467
vpc-123468
vpc-123469
vpc-123470
vpc-123471
vpc-123472
vpc-123473
vpc-123474
Spreadsheet: mary_fischer__25721__20Q July MTM
Sheet: July

Enron Energy Services
MTM Summary
Company 20Q
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
7/01 |  | 21060000 Asset-C |  | 1277047002 |  |  |  | 218478592
7/01 |  | 30300000 Liab-C |  | -1247510983 |  |  |  | -179024538
7/01 |  | 25100200 Prudency |  | 12033165 |  |  |  | -3360737
7/01 |  | 25100300 Prudency |  | 0 |  |  |  |  | Reduced the original ending balance of (28,818,837)
 |  |  |  |  |  |  |  |  | by the 5,577,900 bad debt reserve set up this month
7/01 |  | 25100000 Asset-NC |  | 196011309 |  |  |  | 202614660
7/01 |  | 33100000 Liab-NC |  | -155003635 |  |  |  | -109312628
7/01 |  | 20032500 Liquidation |  | -8673064 |  |  |  | 12467417
7/01 |  | 25100100 Credit Rreserve |  | 0 |  |  |  | -1762590
Assets held on company #1572 |  |  |  | 0 |  |  |  | 26570503
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
7/01 |  | 42000000 MTM Rev |  |  |  | -58370148
 |  | Difference
Spreadsheet: 219017d1362647064-search-in-sheet-1-and-return-to-sheet-2-using-lookup-find-and-match-3
Sheet: Blad1

2013-03-04 00:00:00 | 4/3- | 11/3- | 18/3- | 25/3-
Week | 10 | 11 | 12 | 13
Text A | SKM | SKM | SKM | SKM
Text 1 | EA | EA | EA,PAS
Text 2 | rrrr | SAN,LO |  | PAS
Text 3 | SAN | rrrr | SAN
Text 4 | MM | [NAME] | AB
Text 5 | [NAME] | MM | MLA21-22 | [NAME]
Text 6 | AB,LO | CF |  | AB,EA
Text 7 | CF7 e m |  | CF | rrr
Text 8 | WA | AB,HBA | WA | rrr
Text 9 | HBA | MP13-15 | MP18-20 | rrr
Text 10 |  | rrr |  | HBA
Text 11 | EGU | RAS | RAS | JOS
Text 12 | AMY7-8 | JOS | AMY | SAN
 |  | In Sheet 2 cell B3, I want to be able to type in a search string ie "CF" and extract the information from Sheet 1 column A on the same row "CF" occurs for each column in Sheet 1.
 |  | This should be done for each column that "CF" occurs in Sheet 1. I have used LOOKUP like this:
 |  | [CODE]=LOOKUP($B$3,Sheet1!$B$3:$B$100,Sheet1!$A$3:$A$100)[/CODE]
 |  | but it returns faulty values.
 |  | Other characters are involved in the cells like "," and elevated text, perhaps that is the issue?
 |  | I have attached a sample file with an example in sheet 2.
 |  | Here is another EXAMPLE:
 |  | If I type in "AB" in Sheet 2 cell B3, it should return the values (using the attached sample)
 |  | Text 6 (from [sheet 1 A9])
 |  | Text 8 (from [sheet 1 A11])
 |  | Text 4 (from [sheet 1 A7])
 |  | Text 6 (from [sheet 1 A9])
 |  | All comments are welcome! Thank you for your help.
 |  | Excel 2003 PC
Spreadsheet: 539070d1505946019-scatter-chart-different-color-dots-prices
Sheet: Before

Description | Side | price
Hog Dec17 | B | 345.25 |  |  |  | SCATTER CHART
Hog Dec17 | B | 335.25
Hog Dec17 | B | 330.25
Hog Dec17 | B | 349
Hog Dec17 | B | 349.5
Hog Dec17 | B | 351.25
Hog Dec17 | B | 350
Hog Dec17 | B | 349.25
Hog Dec17 | S | 352
Hog Dec17 | S | 351.75
Hog Dec17 | S | 381
Hog Dec17 | S | 376
Hog Dec17 | S | 363
Hog Dec17 | S | 422
Hog Dec17 | S | 409
Hog Dec17 | S | 424
Hog Dec17 | S | 420
Spreadsheet: 695230d1600103341-vlookup-with-dashes-samplebook
Sheet: sales

MONTH | PRODUCT | AMOUNT | Department
January | [NAME] | 100
January | NHG-RXX99 | 50
January | 735-VAX | 50
January | 735-2677 | 25
Spreadsheet: 159045d1338482570-is-there-a-display-if-function-or-a-way-to-create-one-book1
Sheet: Sheet1

Input
Source of Names | Source letter | A | b
A. School friends |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
B. Friend of family | Client Name | Valued Client | [NAME] | [NAME] | [NAME]
C. Neighbors
D. Known through Spouse
E. Known through children
F. Known through hobbies
[NAME] through church
[NAME] through social groups
[NAME] through community activities
[NAME] through past employment
K. Newly married persons
L. New parents
M. New homeowners
[NAME] job or job location
O. People with whom you do business with
Annual Income | Under $25,000
 | $25,001 - $51,000 | 1 | 1
 | $50,001 - $85,000
 | $85,001 - $120,000 |  |  | 1 | 1
 | $120,000+
Age | Under 25 | 1
 | 26-34
 | 35-44 |  | 1
 | 45-60
 | 61+
Spreadsheet: 800259d1665564160-replace-outlier-and-empty-cell-to-calculate-reliable-average-media-no-outlier_celle-vuote
Sheet: Foglio1

[NAME] originale | Serie modificata
5
8
2
8
2
3
9
12
5
3
5
7
9
8
4
6
2
2
2
8
2
3
6
5
60
4
8
1
6
5
2
10
6
7
8
3
9
9
5
1
Spreadsheet: 225345d1364971764-really-complex-problem-remaining-value-check-help-example
Sheet: My way for calculating 4 values

 | Import1 | Import2 | Import3 | Import4 |  |  | Export1 | Izvoz2 | Izvoz3 |  | Norm1 | Norm2 | Norm3 |  |  | Kvota
Quantity | 1000 | 1200 | 1300 | 1400 |  |  | 444 | 0 | 0 |  | 450.75768 | 0 | 0 |  |  | 1.01522
Value | 1300 | 1560 | 1690 | 1820 |  |  | 888 | 0 | 0 |  | 585.984984 | 0 | 0
 | Razlika1 | Razlika2 | Razlika3 | Razlika4
Remaining | 549.2423200000001 | 0 | 0 | 0
value | 714.0150160000001 | 0 | 0 | 0
 |  |  |  |  |  | Criteria
 |  |  |  |  |  | <0 | 1 | 0 | 0
 |  |  |  |  |  | <Izvoz1 | 0 | 0 | 0
 |  |  |  |  |  | <iz1+iz2 | 0 | 0 | 0
 |  |  |  |  |  | <1+2+3 | 0 | 0 | 0
 |  |  |  |  |  | >1+2+3+4 | 0 | 0 | 0
 |  |  |  |  |  | Reaction
 |  |  |  |  |  | 1 | 549.2423200000001
 |  |  |  |  |  | 2 | 1749.24232
 |  |  |  |  |  | 3 | 3049.24232
 |  |  |  |  |  | 4 | 0 | 0 | 0
 |  |  |  |  |  | minimum
 |  |  |  |  |  | 549.2423200000001
Spreadsheet: 96432d1295837101-lookup-function-help-weeklysalestotals
Sheet: Worksheet 2

 | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | 2011-01-17 00:00:00 | 2011-01-24 00:00:00 | 2011-01-31 00:00:00 | 2011-02-07 00:00:00 | 2011-02-14 00:00:00 | 2011-02-21 00:00:00 | 2011-02-28 00:00:00
widgets
wadgets
oopums
thingamabobs
Data is entered on this worksheet weekly so a history of activity is tracked.
The Pivot table below is from the data on the first page.  No formula needed for this.
Sum of Sold | Column Labels
Row Labels | oopums | thingamabobs | wadets | widgets | Grand Total
12/26/2010 - 1/1/2011 |  | 1 |  | 1 | 2
1/2/2011 - 1/8/2011 | 20 | 17 | 20 | 13 | 70
1/9/2011 - 1/15/2011 | 52 | 34 | 36 | 46 | 168
1/16/2011 - 1/21/2011 | 38 | 53 | 54 | 35 | 180
Grand Total | 110 | 105 | 110 | 95 | 420
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: LP

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
LP BLUBRY ACAI 12/12Z BTL | 10207
LP DRGNFRT MNG 12/12Z BTL | 10205
LP JUST LEMON 12/12Z BTL | 10204
LP KIWI STRFRT 12/12Z BTL | 10210
LP PCH RSPBRY 12/12Z BTL | 10206
LP PNAPL COCON 12/12Z BTL | 10209
LP STRWBRY PAS 12/12Z BTL | 10208
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
LP BLUBRY ACAI 12/12Z BTL | 10207
LP DRGNFRT MNG 12/12Z BTL | 10205
LP JUST LEMON 12/12Z BTL | 10204
LP KIWI STRFRT 12/12Z BTL | 10210
LP PCH RSPBRY 12/12Z BTL | 10206
LP PNAPL COCON 12/12Z BTL | 10209
LP STRWBRY PAS 12/12Z BTL | 10208
Spreadsheet: 208905d1358959840-copy-ranges-of-data-from-master-sheet-to-slave-sheets-time-off-2013
Sheet: February

February 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal |  |  | Sick |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Has | Used | Remaining | Has | Used | Remaining | Has | Used | Remaining
EMPLOYEE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th
Drivers
Employee 01
Employee 02
Employee 03
Employee 04 |  |  |  | V | V | V | V | V
Employee 05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
Employee 06
Employee 07
Warehouse/Attendant
Employee 08
Employee 09
Employee 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V
Mechanics
Employee 11
Employee 12
Employee 13
 |  |  |  |  |  |  |  |  |  |  |  |  | To keep all formatting (cell sizes, colors) exactly the same, I must copy and paste the entire Master and then eliminate the other months.  This creates an information vacuum and I'm not sure what I can do to get February's information to populate as it appears on the Master Sheet.
KEY
Name (Weeks Vacation, Departmental Seniority Rank)
P=Personal Day
S=Sick Day
J=Jury Duty
V=Vacation Day
H=Holiday
Spreadsheet: 804644d1668195490-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-mmjj-drivosity-scores-test
Sheet: 1555

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
[NAME] | [NAME] |  |  | 98 | 0.4 | 97 | 0.51 | 97 | 0.49 | 97 | 0.51
Tre | [NAME] |  |  | 97 | 0.65 | n/a | n/a | 95 | 1.13 | 95 | 0.82
[NAME] | Morici |  |  | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a
Trevor | Ugalde |  |  | 94 | 1.05 | 92 | 1.41 | n/a | n/a | 92 | 1.5
[NAME] | Wickersham |  |  | 97 | 0.53 | 95 | 0.95 | n/a | n/a | n/a | n/a
 | Store Average
Spreadsheet: 823521d1679999900-complex-split-formula-to-split-column-to-different-columns-sample-split
Sheet: sample (2)

POGB0006075-MB2 |  | MB2
POGB0006106-MB2 |  | MB2
[NAME] |  | MB1
POGB0005754-MB2 |  | MB2
POGB0005847-MB2 |  | MB2
POGB0006120-MB2 |  | MB2
POGB0006110-MB2 |  | MB2
POTR0004601-MB1 .POTR0004724-MB1 ,POTR0004723-MB1 .POTR0004719-MB1 ,POTR0004721-MB1 .POTR0004720-MB1 .POT [NAME] |  | MB1 .POTR0004724 | MB1 ,POTR0004723 | [NAME] | MB1 ,POTR0004721 | MB1 .POTR0004720 | MB1 .POT [NAME] | MB1.POTR0004671 | MB1
POGB0005983-MB2,POGB0005893-MB2,POGB0005975-MB2.POGB0005968-MB2.PO GB0005970-MB2.POGB0005961-MB2.POG B0005969-MB2.POGB0005965-MB2.POGB 0005966-MB2.POGB0005964-MB2.POGB0 005967-MB2.POGB0005963-MB2.POGB0005948-MB2 |  | MB2,POGB0005893 | MB2,POGB0005975 | MB2.POGB0005968 | MB2.PO GB0005970 | MB2.POGB0005961 | MB2.POG B0005969 | MB2.POGB0005965 | MB2.POGB 0005966 | MB2.POGB0005964 | MB2.POGB0 005967 | MB2.POGB0005963 | MB2.POGB0005948 | MB2
POGB0006088-MB2 |  | MB2
POTR0004774-MB1 |  | MB1
POTR0004741-MB1 |  | MB1
POGB0006072-MB2 |  | MB2
POGB0005755-MB2 |  | MB2
POTR0004789-MB1 |  | MB1
POTR0004790-MB1 |  | MB1
POGB0006086-MB2 |  | MB2
POGB0006113-MB2 |  | MB2
POTR0004556-MB1 |  | MB1
[NAME] |  | MB1
POTR0004684-MB1 |  | MB1
POTR0004755-MB1 |  | MB1
POTR0004797-MB1 |  | MB1
POTR0004646-MB1 |  | MB1
POTR0004822-MB1 |  | MB1
POGB0006129-MB2.POGB0006130-MB2 |  | MB2.POGB0006130 | MB2
POTR0004823-MB1 |  | MB1
[NAME] |  | MB1
POTR0004836-MB1 |  | MB1
[NAME] |  | MB1
POGB0006285-MB2 |  | MB2
POGB0006277-MB2 |  | MB2