tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164402d1340746395-add-rows-if-referenced-cells-in-another-sheet-contain-data-excel-help
Sheet: Sheet5

Job: | #N/A |  | Description: | Metal Pan Stair |  |  |  |  |  |  |  |  | Reference
Phase: | 2 |  | Comment: |  |  |  |  |  |  |  |  |  |  | Type: | Drawing number:
Date: | 2012-06-26 17:24:24 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Exclusions and Qualifications: |  |  |  |  |  |  |  |  |  | 2
Drawing Reference |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LF/SF: | Quantities: | Connections: | Material: | Finish:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Other
Spreadsheet: phillip_allen__29932__house
Sheet: Sheet1

 | # of units | per unit cost | Total cost |  | Chapman
Legal
Builders risk Insurance |  |  | 1000
Add'l Insurance |  |  |  |  | 2000
Design
Engineering Slab |  |  | 480
Energy audit |  |  | 150
Archictect |  |  | 4500 |  | 5000
Fees & Permits
Building & Septic Permit |  |  | 410
Utility
Construction Electric |  |  | 150
Construction Water |  |  | 100
Foundation
Slab |  | 7.5
Framing
Panels  per quote |  |  | 26000
Frame Labor | 5770 | 5.45
Panel Beams |  |  | 2000
Frame Materials |  |  | 18000
[NAME] |  |  | 5000
Porch Posts(4X300,4X225) |  |  | 2100
Equipment Rental |  |  | 1250
Windows | 30 | 150
Doors
interior doors | 16 | 75
exterior doors | 4 | 600
garage door & opener |  |  | 1500
Roof
Gutters |  |  | 1000
Roofing bid (30 yr. Composition) |  | 88
Masonry
Stucco |  |  | 14000
Rock |  |  | 8500
Mailbox |  |  | 400
fireplace |  |  | 2500
Electrical
Electrical bid |  |  | 11000
Central Vacuum |  |  | 1400
lights&fans |  |  | 3000
HVAC
a/c(2 units-3 ton up, 2.5 ton down) |  |  | 12000
air exchanger |  |  | 1000
Plumbing
plumbing bid |  |  | 15000
septic |  |  | 7500
Propane Tank(buried) |  |  | 1500
Insulation
insulation |  |  | 1000
Soundproofing | 800 | 1.2
Tyvek |  |  | 600
Drywall
sheetrock |  |  | 13000
Rounded Corners |  |  | 1000
Trim Out
trim |  |  | 8500
stairs+railings |  |  | 3500
Cabinets
cabinet-kitchen |  |  | 9000
Cabinet-wetbar |  |  | 2500
Cabinet-entertainment
Bookshelves(living) |  |  | 2500
Back door bench&shelves |  |  | 500
Computer Nook |  |  | 750
Office desk |  |  | 750
Laundry cabinets |  |  | 1500
Master Bath-Vanities |  |  | 2000
[NAME] |  |  | 1000
2 Girls Vanities |  |  | 1500
Painting
paint |  |  | 12500
Bath & Shower
MasterBath-vanity tops |  |  | 1500
[NAME] top |  |  | 800
Girls Baths-vanity tops |  |  | 800
Master Bath Shower(Tile & Glass) |  |  | 1500
[NAME] surround |  |  | 750
[NAME] surround |  |  | 750
Counter tops
counter-kitchen | 80 | 50
[NAME] |  |  | 1000
Counter-wetbar |  |  | 2000
Flooring
floor | 4000 | 7
[NAME]
Master [NAME] |  |  | 500
Bathroom Mirrors |  |  | 600
Hardware
Hardware Allowance |  |  | 1000
Appliances
appliances-kitchen |  |  | 6000
Appliance -wetbar |  |  | 1300
Flatwork
driveway |  |  | 7500
landscape
landscape |  |  | 3000
General Expenses
Clean up-Exterior |  |  | 800
Clean up Interior |  |  | 650
[NAME] |  |  | 1000
Job toilet |  |  | 500
Superintendent |  |  | 1000
Punch out |  |  | 500
Miscellaneous |  |  | 4000
Subtotal
contractor fee |  |  | 35000
Total
Per sq. ft.(4100)
Spreadsheet: 95552d1295137106-need-solution-to-pull-data-from-sheet1-to-sheet2-if-value-0-mafiawars_testsheet
Sheet: Sheet2

Top Weapons | Attack: | Defense: | Using: | Owned: | Total: | Giftable:
Little Dog | 190 | 160 | 1 | 1 | 190 | 0
Set of Hill's Heavy Weapons | 160 | 175 | 1 | 1 | 160 | 0
Gun Powdered Milk | 134 | 105 | 2 | 2 | 268 | 0
Executive Decision | 130 | 102 | 1 | 1 | 130 | 5
Trieste's Pistol | 129 | 104 | 1 | 1 | 129 | 0
Power Rifle | 120 | 160 | 1 | 1 | 120 | 0
North Pole | 110 | 93 | 1 | 1 | 110 | 0
[NAME] | 110 | 135 | 1 | 1 | 110 | 0
[NAME] Shotgun | 107 | 69 | 1 | 1 | 107 | 0
40mm Bunker Buster | 101 | 68 | 1 | 1 | 101 | 10
[NAME] | 94 | 136 | 1 | 1 | 94 | 0
Power Armor Claw | 91 | 49 | 1 | 1 | 91 | 0
[NAME] | 88 | 51 | 1 | 1 | 88 | 0
Black Irish | 84 | 59 | 4 | 4 | 336 | 0
Silk Thunder | 84 | 59 | 1 | 1 | 84 | 0
Sin City Shooter | 81 | 36 | 1 | 1 | 81 | 0
Rico's Revenge | 81 | 37 | 3 | 3 | 243 | 0
Nightmare Claw | 80 | 41 | 1 | 1 | 80 | 0
Tiebreaker | 76 | 42 | 1 | 1 | 76 | 0
Anesthesia | 75 | 50 | 2 | 2 | 150 | 0
[NAME] | 75 | 39 | 2 | 2 | 150 | 0
Hood Gun | 74 | 39 | 1 | 1 | 74 | 0
Garrotte | 73 | 44 | 1 | 1 | 73 | 0
9mm Fury | 72 | 49 | 7 | 7 | 504 | 0
Fish Spear | 72 | 45 | 1 | 1 | 72 | 0
Del Brenta Cane Sword | 72 | 133 | 1 | 1 | 72 | 0
Silenced Sniper Rifle | 70 | 28 | 4 | 4 | 280 | 0
Whiplash | 69 | 29 | 7 | 7 | 483 | 0
Z17 Micro | 69 | 45 | 23 | 23 | 1587 | 0
New Years Resolution | 69 | 46 | 427 | 456 | 29463 | 29
[NAME] | Attack: | Defense: | Using: | Owned: | Total: | Giftable:
Experimental Exosuit | 185 | 106 | 1 | 1 | 185 | 0
D.R.E. | 140 | 95 | 2 | 2 | 280 | 0
Bidwell's Suit | 130 | 151 | 1 | 1 | 130 | 0
Night Vision Viewer | 106 | 71 | 1 | 1 | 106 | 0
Set of Government Secrets | 103 | 132 | 1 | 1 | 103 | 0
[NAME] | 89 | 51 | 1 | 1 | 89 | 0
HALO Wingsuit | 88 | 51 | 1 | 1 | 88 | 0
Igloo Shield | 82 | 44 | 1 | 1 | 82 | 0
Orange Peel | 79 | 40 | 1 | 1 | 79 | 0
Black Friday Mask | 79 | 44 | 1 | 1 | 79 | 0
[NAME] | 79 | 47 | 2 | 2 | 158 | 0
Pair of [NAME]'s [NAME] | 76 | 125 | 1 | 1 | 76 | 0
Enzo's Monocle | 74 | 104 | 1 | 1 | 74 | 0
Ballistic Vest | 72 | 103 | 1 | 1 | 72 | 0
Infiltration Gear | 72 | 40 | 3 | 3 | 216 | 0
Orange Peel | 71 | 33 | 1 | 1 | 71 | 0
Rogue CIA Agent | 69 | 30 | 5 | 5 | 345 | 0
Hit Squad | 65 | 45 | 1 | 1 | 65 | 0
[NAME] | 63 | 31 | 77 | 77 | 4851 | 0
Gluttony | 63 | 30 | 1 | 1 | 63 | 0
[NAME] | 60 | 29 | 10 | 10 | 600 | 0
ShrapShield | 59 | 30 | 2 | 2 | 118 | 0
[NAME] | 58 | 28 | 10 | 10 | 580 | 0
[NAME]'s Mask | 58 | 40 | 1 | 1 | 58 | 0
[NAME] and [NAME] | 57 | 36 | 372 | 394 | 21204 | 22
Pantomime Horse | 57 | 31 | 2 | 2 | 114 | 0
Spreadsheet: 199494d1355236364-index-formula-with-multiple-matches-index-multi-match_a
Sheet: MATCH-INDEX

 |  |  |  |  |  |  | Index & Match
Name | Department | Employee ID# |  |  |  | Employee ID# | Name
Hackenbush, Hugo | Accounting | 119073 |  |  | Accounting | 136001
Driftwood, Christy | Accounting | 143791 |  |  | Administration | 146432
Hollerith, [NAME] | Accounting | 142064 |  |  | Accounting | 143791
[NAME], [NAME] | Accounting | 136001 |  |  | Sales | 107215
Martinet, [NAME] | Administration | 121543 |  |  | Sales | 143791
Portnoy, Harold | Administration | 142912
Babbitt, George | Administration | 146432
Firefly, [NAME] | IT | 144774 |  |  |  |  | Index & Two Matches
[NAME], [NAME] | IT | 113393 |  |  |  | Employee ID# | Name
Watson, [NAME] | IT | 141202 |  |  | Accounting | 136001
Melish, Fielding | IT | 104009 |  |  | Administration | 146432
[NAME], Hannibal | Manufacturing | 107431 |  |  | Accounting | 143791
Bickle, Travis | Manufacturing | 100430 |  |  | Sales | 107215
Kimble, [NAME] | Manufacturing | 144170 |  |  | Sales | 143791
Malloy, [NAME] | Manufacturing | 142736
Mantee, [NAME] | Manufacturing | 111833
[NAME], [NAME] | Manufacturing | 150472
[NAME], [NAME] | Manufacturing | 132491
Bailey, [NAME] | Marketing | 118466
Quigley, [NAME] | Marketing | 101890
Tetrazzini, [NAME] | Marketing | 107216
Thompson, Sara | Marketing | 147008
[NAME], [NAME] | Marketing | 125544
Rodgers, [NAME] | Marketing | 146796
Riley, [NAME] | Marketing | 138082
Kobus, [NAME] | Sales | 107324
Loman, Willy | Sales | 107796
McMahon, [NAME] | Sales | 100468
Singer, Alvy | Sales | 137598
[NAME], [NAME] | Sales | 107215
Driftwood-Mann, [NAME] | Sales | 143791
Spreadsheet: 35645d1233242304-creating-a-formula-for-periodic-increases-along-a-sloped-length-stud-counter-for-sloped-roofs
Sheet: Sheet1

Starting height in feet |  | slope |  | length in feet | Studs OC inches
8 | 10 | / | 12 | 6 | 24
 | 8' |  | 1
 | 10' |  | 2
 | 12' |  | 1
 | 14'
 | 16'
 | 18'
 | 20'
Spreadsheet: a9dcf6ea-313f-42ba-8378-770713591077
Sheet: Sheet1

Commercial Construction Permits | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Entries made in the last 7 day(s)
Permit |  | Permit Type |  |  | Date Recorded | [NAME] | Job Address | Project |  | Contractor |  | Est Value
14-2279 |  | Commercial Interior |  |  | 2014-08-14 00:00:00 | 110 | 5105 SOUTH NATIONAL DR KNOXVILLE TN 37914 | FRESENIUS MEDICAL STRUCTURAL UPGRADE |  | [NAME], Inc. |  | 800000
14-3336 |  | Sign |  |  | 2014-12-12 00:00:00 |  | 617 LOVELL RD KNOXVILLE 37932 | SPEEDWAY |  | Sycamore Sign Service |  | 65000
14-3344 |  | Sign |  |  | 2014-12-12 00:00:00 |  | 9724 PARKSIDE DR KNOXVILLE 37922 | VERMEER HEARTLAND |  | Signco, Inc. |  | 4000
14-3345 |  | Sign |  |  | 2014-12-12 00:00:00 |  | 9929 PARKSIDE DR KNOXVILLE 37922 | KIA TED RUSSEL |  | Signco, Inc. |  | 15000
14-3343 |  | Sign |  |  | 2014-12-12 00:00:00 |  | 9296 KINGSTON PIKE KNOXVILLE TN 37922 | FRIEDMANS APPLIANCE |  | Signs First |  | 11000
14-3346 |  | Sign |  |  | 2014-12-12 00:00:00 |  | 229 E EMORY RD POWELL TN 37849 | MAX AIR TRAMPOLINE PARK |  | Signco, Inc. |  | 6000
14-3337 |  | Sign |  |  | 2014-12-12 00:00:00 |  | 835 #103 INNOVATION DR KNOXVILLE 37932 | EMERSON PROCESSMANAGEMENT |  | T And T Signs, Inc. |  | 1000
14-3384 |  | Commercial Demo |  |  | 2014-12-15 00:00:00 | 119 | 412 #108 N CEDAR BLUFF RD KNOXVILLE TN 37923 | AIG FINANCIAL NETWORK |  | Wakefield Corp., The |  | 0
14-3272 |  | Commercial Interior |  |  | 2014-12-15 00:00:00 |  | 122 PERIMETER PARK RD KNOXVILLE TN 37922 | SADDLEBROOK PROPERTIES SHOWROOM RENOVATION |  | Jenkins & Stiles Llc. |  | 200000
14-2588 |  | Commercial Building Shell |  |  | 2014-12-16 00:00:00 |  | 10530 KINGSTON PIKE KNOXVILLE 37922 | LIBERTY PLAZA SHELL BLDG |  | Merit Construction, Inc. |  | 535780
14-2519 |  | Commercial Building New |  |  | 2014-12-16 00:00:00 |  | 10606 KINGSTON PIKE KNOXVILLE TN 37922 | WALKERS COLLISION CENTER |  | Merit Construction, Inc. |  | 3000000
14-2520 |  | Commercial Building New |  |  | 2014-12-16 00:00:00 |  | 10606 KINGSTON PIKE KNOXVILLE TN 37922 | WALKERS COLLISION CENTER CARPORT |  | Merit Construction, Inc. |  | 60000
14-2963 |  | Commercial Demo |  |  | 2014-12-16 00:00:00 |  | 10405 LEXINGTON DR KNOXVILLE TN 37932 | OLD CRETE CARRIER TERMINAL |  | [NAME], Inc. |  | 0
14-2575 |  | Commercial Interior |  |  | 2014-12-16 00:00:00 |  | 9161 MIDDLEBROOK PIKE KNOXVILLE TN 37931 | KROGER BAKERY/DELI/PRODUCE INTERIOR REMODEL |  | Farris Interior Installation |  | 375000
14-3330 |  | Commercial Improvement Minor |  |  | 2014-12-17 00:00:00 |  | 1149 CATLETT RD KNOXVILLE 37932 | KNOXVILLE LEARNING ACCADEMY |  | [NAME] |  | 600
 | Total |  | 15 |  |  |  |  |  |  | Sum | 5073380
Spreadsheet: 880188d1727808404-dynamic-calendar-with-autofilling-entries-dynamic-calendar-with-autofill
Sheet: Calendar

 | August 2024
 |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Spreadsheet: 738367d1624989082-looking-for-a-formula-that-copies-entire-row-of-matching-criteria-onto-a-new-sheet-sample-workbook
Sheet: Sheet1

Date | Estimate # | Site Address | Client Name | Status | Followed Up | Follow Up Required | Notes
 | 3522 | 123 Apple Street | [NAME] | Accepted | No
44348 | 3523 | 456 Knight Street | [NAME] | Accepted | No
44348 | 3524 | 15748 88 Street | [NAME] | Accepted | Yes
44348 | 3525 | 401 5 5 Avenue | [NAME] | Accepted | No
44349 | 3528 | 33445 Strawberry Crescent | Amanda | Accepted | No
44350 | 3529 | 7809 Surrey Street | [NAME] | Accepted | No
44350 | 3530 | 6731 Duchess Street | [NAME] | Accepted | No
44351 | 3533 | 90923 Cantalope Avenue | [NAME] | Accepted | No
44351 | 3534 | 19300 Oak Street | [NAME] | Accepted | No
44351 | 3535 | 871 Velma Avenue | [NAME] | Accepted | No
Spreadsheet: 1495b370-b0ee-4be6-8c5f-e0096ed0db2d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  | Coffee Suply Order Form
 | Location: |  |  |  |  | Date:
 |  |  | Please order by the following
 | Item: | pack size: | current price:* | 1/2cs or whole | ORDER:
 | Regular Coffee | 1/2cs or 1 cs | $74/$148 | 96/192
 | Decaf Coffee | 1/2cs or 1 cs | $47/$94 | 48/96
 | Tea Bags | 1box | 4.50/box
 | Decaf Tea Bags | 1 box | 5.25/box
 | Sugar | 1 box | 1.75/box
 | Sweet and Low | bag | 3
 | [NAME] | 1 cannister | 1.50/cannister
 | Paper Cup | 20 sleeves/case | 2.55/sleeve | 8oz only
 | Stirrers | 1 box | 1.85/box
 | Filters | 1 pack | 1.00/pack
 | Please record amount of each item you are requesting
 | individual department uses.
 | * Prices subject to change with supplier increases.
 | * Please Return by the 15th of every month to get an order
Spreadsheet: 173272d1344504663-need-vlookup-to-accept-errors-in-names-and-name-formats-vlookup_sample
Sheet: Sheet1

 |  | my list |  |  |  |  |  | imported list
 |  | [NAME] |  |  |  |  |  | [NAME] | Boilermaker
 |  | [NAME] |  |  |  |  |  | [NAME] | Fitter
 |  | [NAME] |  |  |  |  |  | [NAME] | Fitter
 |  | [NAME] |  |  |  |  |  | [NAME] | Plumber
 |  | [NAME] |  |  |  |  |  | [NAME] | Driver
 |  | [NAME] |  |  |  |  |  | [NAME] | Boilermaker
 |  | [NAME] |  |  |  |  |  | [NAME] | Driver
 |  | [NAME] |  |  |  |  |  | [NAME] | Plumber
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: Time period

 |  | Time period |  |  |  |  | Time period
 |  |  |  |  |  |  | Please select and provide data only for the selected year.testing
 |  |  |  |  |  |  | Preferably, please provide data for
 |  | Please select and provide data only for the selected year. |  |  |  |  | 2007 (complete) | 0
 |  |  |  |  |  |  | If data for 2007 are not yet completely available, please provide data for
 |  | Preferably, please provide data for |  |  |  |  | 2006 (complete) | 0
 |  |  |  |  |  |  | If complete data for 2007 or 2006 are not available.
 |  | 2008 (complete) |  |  |  |  | Please specify period for provided data: | 0 | 0
 |  |  |  |  |  |  | If changes in test procedures/test systems have been made during the indicated year. same assay
 |  | If data for 2008 are not yet completely available, please provide data for |  |  |  |  | Please specify: | 0 | 0
 |  | 2007 (complete)
 |  | If complete data for 2008 or 2007 are not available.
 |  | Please specify period for provided data:
 |  | If changes in test procedures/test systems have been made during the indicated year.
 |  | Please specify:
 |  |  |  | Page 3 of 34
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: StewP

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 85233d1285267265-average-highest-value-per-unique-items-book22-1-
Sheet: Sheet1

Qty: | Item:
1 | 10513 | 1
59 | 12991 | 61
61 | 12991 | 61 | I need two formulas to calculate the Average
1 | 16608 | 1 | of the HIGHEST sell per unique Items
34 | 12991 | 61 | Table is and should not be sorted !
1 | 13604 | 1 | Pls note Item 16608 appears twice with the same Qty.
0 | 14697 | 0 | It should be counted only once.
8 | 15117 | 8
1 | 15505 | 1 | 9.625 | Average incl. Zeros |  | 9.625
4 | 14714 | 4
1 | 16608 | 1 | 11 | Average excl. Zeros |  | 11
Spreadsheet: 690650d1597222557-automatically-place-an-assigned-code-when-a-subject-is-typed-in-test1
Sheet: Sheet1

Subject | Code
Maths
English
English |  |  |  | Key
IT |  |  |  | Subject | Code
English |  |  |  | Maths | M1234
Maths |  |  |  | English | E1234
IT |  |  |  | IT | I1234
IT |  |  |  | Hair | H1234
Maths |  |  |  | Beauty | B1234
English
Beauty
Beauty
Hair
Beauty
Hair
Hair
Beauty
Spreadsheet: 704206d1605440465-formula-retrieving-data-from-other-worksheet-when-changing-month-_01-_02-_03-in-a-cell-exampleforformula
Sheet: Output

Product |  | Limestone |  | CB |  | …
MONTH
February | Item
 | …
 |  | Depending on the Product (C1, E1) & month (cell [NAME]), it should find corresponding data of each item of sheets "Data_Limestone" respective "CB".
 |  | So for example for Month _01 it should find for Product Limestone above values in blue cells
 |  | If I change cell [NAME] to _02 for the month February, it should find corresponding data of February and give it back in the blue colored cells
 |  | And so on.
 |  | Which excel formula withouth [NAME] is able to do this?
 |  |  |  | Which excel formula solves this problem (w/o [NAME])?
Spreadsheet: 835058d1688248427-return-monthly-items-by-day-order-example-30-
Sheet: Planilha1

 |  |  |  | Items of the month>> | July
Item | Date
Item 1 | 1978-07-09 00:00:00 |  |  | Item | Date
Item 2 | 1980-07-02 00:00:00 |  |  |  |  |  | <<< When selecting a month from the drop-down list (F1), I would like to return the records from smallest to largest day.
Item 3 | 1980-07-03 00:00:00
Item 4 | 1980-07-04 00:00:00
Item 5 | 1980-07-25 00:00:00
Item 6 | 1980-07-06 00:00:00
Item 7 | 1980-07-07 00:00:00
Item 8 | 1980-07-08 00:00:00
Item 9 | 1980-01-30 00:00:00
Item 10 | 2020-08-01 00:00:00
Item 11 | 2020-08-02 00:00:00
Item 12 | 2020-01-30 00:00:00
Item 13 | 2020-01-04 00:00:00
Item 14 | 2020-01-05 00:00:00
Item 15 | 2020-01-06 00:00:00
Item 16 | 2020-01-07 00:00:00
Spreadsheet: 35878d1233606948-breakdown-to-this-structure-solution-commisions-calculator
Sheet: Sheet2

Commisions Calculator
Comission Base | 1200 | Charge Backs | Quota | C.B. + Quota | Actual | % to Quota | >$59 quota | >$59 actual
Activations 35% | 5 |  | 20 |  | 16 |  | 15 | 6
Upgrades 30% | 5 |  | 30 |  | 24
Features 25% | 0.75 |  |  |  | 800
Accessories 10 | 0.1 |  |  |  | 1000
Activations
$ Per Unit |  | Pay Out |  | > $59 |  | Total Payout
Upgrade
$ Per Unit |  | Pay Out |  | Total Payout
Features
% Per Unit |  | Pay Out |  | Total Payout
Accessories
%Per Unit |  | Pay Out |  | Total Payout
Home Products
U-verse |  | Direct T.V. |  |  | Home Phone/Internet
$25 Per Unit | Units | $25 Per Unit |  | Units | Face Falue |  |  | Units
Gross Commision Check
Spreadsheet: 8fbe859e-c675-4b17-b554-2ce24e290396
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Retail Trade and Food Services
 |  | 44831: Jewelry Stores: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2013
 |  | Data Extracted on: October 22, 2014 (11:28 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 796 | 1021 | 912 | 969 | 1171 | 1094 | 1037 | 1089 | 1034 | 1122 | 1364 | 3436
1993 | 795 | 992 | 895 | 997 | 1235 | 1259 | 1267 | 1260 | 1180 | 1203 | 1549 | 3797
1994 | 897 | 1181 | 1050 | 1161 | 1356 | 1246 | 1214 | 1309 | 1236 | 1312 | 1718 | 4172
1995 | 908 | 1213 | 1128 | 1195 | 1590 | 1377 | 1250 | 1382 | 1315 | 1360 | 1854 | 4435
1996 | 1036 | 1428 | 1306 | 1347 | 1755 | 1397 | 1366 | 1466 | 1323 | 1451 | 1830 | 4464
1997 | 1034 | 1400 | 1175 | 1258 | 1585 | 1330 | 1313 | 1348 | 1334 | 1395 | 1799 | 4658
1998 | 1110 | 1502 | 1228 | 1352 | 1742 | 1515 | 1405 | 1455 | 1362 | 1495 | 1909 | 5196
1999 | 1155 | 1650 | 1392 | 1457 | 1863 | 1623 | 1585 | 1606 | 1520 | 1641 | 2165 | 6034
2000 | 1244 | 1979 | 1500 | 1560 | 2126 | 1771 | 1632 | 1757 | 1694 | 1670 | 2159 | 5729
2001 | 1322 | 1960 | 1569 | 1534 | 1977 | 1617 | 1519 | 1667 | 1383 | 1575 | 2137 | 5301
2002 | 1294 | 1989 | 1600 | 1614 | 2105 | 1655 | 1542 | 1733 | 1492 | 1651 | 2193 | 5770
2003 | 1356 | 2012 | 1474 | 1612 | 2066 | 1707 | 1674 | 1758 | 1626 | 1756 | 2288 | 6164
2004 | 1463 | 2346 | 1766 | 1829 | 2230 | 1887 | 1792 | 1800 | 1732 | 1852 | 2409 | 6517
2005 | 1469 | 2412 | 1786 | 1924 | 2261 | 1968 | 1767 | 1954 | 1756 | 1892 | 2471 | 6761
2006 | 1560 | 2600 | 1968 | 1876 | 2568 | 2122 | 1928 | 2093 | 2017 | 1993 | 2630 | 6748
2007 | 1699 | 2521 | 1999 | 1954 | 2678 | 2226 | 2052 | 2178 | 2025 | 2175 | 2792 | 6521
2008 | 1804 | 2621 | 2084 | 2054 | 2729 | 2171 | 2175 | 2236 | 1921 | 2009 | 2267 | 5079
2009 | 1487 | 2132 | 1638 | 1774 | 2264 | 1853 | 1775 | 1846 | 1788 | 1850 | 2264 | 5325
2010 | 1518 | 2124 | 1811 | 1822 | 2281 | 1831 | 1845 | 1841 | 1713 | 1939 | 2434 | 5175
2011 | 1649 | 2270 | 2014 | 2236 | 2677 | 2136 | 2024 | 2224 | 2123 | 2045 | 2506 | 5738
2012 | 1715 | 2673 | 2109 | 2006 | 2749 | 2210 | 2006 | 2187 | 2119 | 2139 | 2643 | 6294
2013 | 1933 | 2748 | 2324 | 2433 | 2943 | 2321 | 2194 | 2362 | 2218 | 2465 | 2943 | 6365
Spreadsheet: 157875d1337896619-calculation-in-a-list-wtlossex
Sheet: Sheet1

ID | Month | Weight | Weight Loss
1 | Jan | 150
2 | Jan | 160
3 | Jan | 190
4 | Jan | 231
5 | Jan | 178
1 | Feb | 148
2 | Feb | 155
3 | Feb | 184
4 | Feb | 205
5 | Feb | 177
1 | Mar | 145
2 | Mar | 150
3 | Mar | 185
4 | Mar | 200
5 | Mar | 176
Spreadsheet: 760270d1640113473-vlookup-not-returning-desired-result-cellref-test
Sheet: 201

Sheet1 | formula:
 | typed: | 201 | INDIRECT
 | [NAME] based on forumla:
 | [NAME] based on typed:
 | 201 | Smith | University 1
 | 203 | Jones | University 2
 | 205 | [NAME] | University 3
Spreadsheet: 122233d1316687682-countifs_two-text-criteria-and-one-color-criteria-110922-example-of-issue
Sheet: Data

BG | Window | Month
[NAME] | 2011-W2 | 2012-10-01 00:00:00
LS&C | 2011-W2B | 2012-10-01 00:00:00
Consumer Luminaires | 2012-W1 | 2011-04-01 00:00:00
Professional Luminaires | 2012-W1B | 2011-04-01 00:00:00
[NAME] | 2012-W2 | ?
LS&C | 2012-W2B | 2011-01-01 00:00:00
Consumer Luminaires | 2013-W1 | 2011-04-01 00:00:00
Professional Luminaires | 2013-W1B | 2011-04-01 00:00:00
[NAME] | 2011-W2 | 2012-10-01 00:00:00
LS&C | 2011-W2B | 2011-04-01 00:00:00
Consumer Luminaires | 2012-W1 | 2011-04-01 00:00:00
Professional Luminaires | 2012-W1B | 2012-10-01 00:00:00
[NAME] | 2012-W2 | 2011-04-01 00:00:00
LS&C | 2012-W2B | 2011-04-01 00:00:00
Consumer Luminaires | 2013-W1 | 2011-04-01 00:00:00
Professional Luminaires | 2013-W1B | 2012-10-01 00:00:00
[NAME] | 2011-W2 | 2012-10-01 00:00:00
LS&C | 2011-W2B | 2012-10-01 00:00:00
Consumer Luminaires | 2012-W1 | 2011-04-01 00:00:00
Professional Luminaires | 2012-W1B | 2012-10-01 00:00:00
[NAME] | 2012-W2 | 2012-10-01 00:00:00
LS&C | 2012-W2B | 2012-10-01 00:00:00
Consumer Luminaires | 2013-W1 | 2011-04-01 00:00:00
Professional Luminaires | 2013-W1B | 2012-10-01 00:00:00
Spreadsheet: 676822d1589003230-pull-contact-info-from-multiple-rows-and-deliver-across-multiple-columns-based-on-company-ozgothic6568_excelforumexample
Sheet: #1

Company Name | Contact 1: First Name | Contact 1: Last Name | Contact 1: Email | Contact 2: First Name | Contact 2: Last Name | Contact 2: Email | Contact 3: First Name | Contact 3: Last Name | Contact 3: Email | Contact 4: First Name | Contact 4: Last Name | Contact 4: Phone | Contact 4: Email
A J Edden