tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 873809d1720376852-returning-a-single-value-based-on-two-different-cells-cdrl-cover-letter-copy
Sheet: CDRL List

 | CDRL Number | CDRL Title
CONTRACT#1 | A001 | TEST#1
 | A002 | TEST#2
 | A003 | TEST#3
 | A004 | TEST#4
 | A005 | TEST#5
 | A006 | TEST#6
 | A007 | TEST#7
 | A008 | TEST#8
 | A009 | TEST#9
 | A010 | TEST#10
 | A011 | TEST#11
 | A012 | [NAME]
 | A013 | TEST#13
 | A014 | TEST#14
 | A015 | TEST#15
 | A016 | TEST#16
 | A017 | TEST#17
 | A018 | TEST#18
 | A019 | TEST#19
 | A020 | TEST#20
CONTRACT#2 | A001 | TEST#1
 | A002 | TEST#2
 | A003 | TEST#3
 | A004 | TEST#4
 | A005 | TEST#5
 | A006 | TEST#6
 | A007 | TEST#7
 | A008 | TEST#8
 | A009 | TEST#9
 | A010 | TEST#10
 | A011 | TEST#11
 | A012 | [NAME]
 | A013 | TEST#13
 | A014 | TEST#14
 | A015 | TEST#15
CONTRACT#3 | A001 | TEST#1
 | A002 | TEST#2
 | A003 | TEST#3
 | A004 | TEST#4
 | A005 | TEST#5
 | A006 | TEST#6
 | A007 | TEST#7
 | A008 | TEST#8
 | A009 | TEST#9
 | A010 | TEST#10
 | A011 | TEST#11
 | A012 | [NAME]
 | A013 | TEST#13
 | A014 | TEST#14
 | A015 | TEST#15
 | A016 | TEST#16
Spreadsheet: 328848d1404117676-inventory-disqualifiers-inventory-disqualifier-v2
Sheet: Sample & Expected Output

*** Sample Worksheet ***
Balance | 2427.043182580531 | (manually assigned base amount or running balance)
Amount to distribute | 13136.797 | (manually assigned amount will be divided to all who are eligible)
Eligible |  | (computed count from list of associates below who are qualified)
 | (incentive will only be given if 0 (or no) aged inventory greater than 7 days, depending on # of eligible)
Aged Inventory | Disqualifier | (to add to or deduct from B1 (balance) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aged Inventory |  | Instances
8-20 days | -0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Below 10 days | 1 to 9 days | 0
21-30 days | -0.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 10 days | 10 to 29 days | >0<=3
31-60 days | -0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 30 days | 10 to 29 days | >3
61-99 days | -0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 60 days | 30 to 59 days | >0<=3
100 days | -0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 100 days | 30 to 59 days | >3
 | (instances of aged inventories may not matter for now; can be either yes or no or with or without)
 | Aged Groups |  |  |  |  | (disqualifier is the accumulation of presence of inventories in any/all aged groups)
Associate | 8-20 days | 21-30 days | 31-60 days | 61-99 days | > 100 days | Disqualifier | Incentive | Remark
Associate 1 | 1 | 2 | 3 | 4 | 5
Associate 2 | 1 | 8 |  | 1 | 1
Associate 3
Associate 4
Associate 5 |  |  | 1
Associate 6 |  |  |  |  | 1
Associate 7 |  |  |  | 1
Associate 8 | 5
Associate 9 |  | 7 | 6
Associate 10
Associate 11 | 6 |  |  | 1
Associate 12 |  | 3 | 4
Associate 13
Associate 14 |  |  |  | 2 | 1
Associate 15 |  |  | 2 | 3
Associate 16
Associate 17 |  | 2
Associate 18
Associate 19 | 7 | 10
Associate 20
 | (all columns may be a separate table in another sheet)
 | (final table will only show column A (Associate), column G (Disqualifier), H (Incentive)
*** Expected Output ***
Balance | 2427.043182580531
Amount to distribute | 13136.797
Eligible | 7
Aged Inventory | Disqualifier
8-20 days | -0.1
21-30 days | -0.15
31-60 days | -0.2
61-99 days | -0.25
> 100 days | -0.3
Associate | Disqualifier | Incentive
Associate 1 | -1 | -2427.043182580531
Associate 2 | -0.8 | -1941.634546064425
Associate 3 |  | 1876.685285714286
Associate 4 |  | 1876.685285714286
Associate 5 | -0.2 | -485.4086365161063
Associate 6 | -0.3 | -728.1129547741593
Associate 7 | -0.25 | -606.7607956451328
Associate 8 | -0.1 | -242.7043182580531
Associate 9 | -0.35 | -849.4651139031859
Associate 10 |  | 1876.685285714286
Associate 11 | -0.35 | -849.4651139031859
Associate 12 | -0.35 | -849.4651139031859
Associate 13 |  | 1876.685285714286
Associate 14 | -0.55 | -1334.873750419292
Associate 15 | -0.45 | -1092.169432161239
Associate 16 |  | 1876.685285714286
Associate 17 | -0.15 | -364.0564773870797
Associate 18 |  | 1876.685285714286
Associate 19 | -0.25 | -606.7607956451328
Associate 20 |  | 1876.685285714286
Spreadsheet: 135862d1326283997-filter-data-advanced-filter
Sheet: Sheet1

transaction_id | sub_id | [NAME] |  |  | sub_id | yellow named cells  must be identical
10232094ce99ad52f94e7713d3fa2f | 1456789 | 1252344 |  |  | 1252344
10232094ce99ad52f94e7713d3fa2f | 1252340 | 1252358 |  |  | 1252358
10242062c71c07416210bba1cd34cf | 1252355 | 1252362 |  |  | 1252362
102cb7ce3e217b52b2348391fec55a | 1252344 | 1252355 |  |  | 1252355
102ada5404f7cbf9a041bcf9c73795 | 1252358
10224612c44abf14a8897093b54ea6 | 1252332
1021da950b261f9f9f5cd74f7aef05 | 1252321
102e4276ccb10d90e78b4253121ced | 1252311
102da542eb257e099d615f98fcf65c | 1252362
Spreadsheet: 844894d1696518404-write-formula-to-compare-planned-amounts-by-vendor-in-one-sheet-to-approved-amounts-by-ven-workbook-sample-for-formula-excelmuch-
Sheet: Project ID TEST3

Project ID | Project ID TEST3
 | Total Approved Amount
Partner Type 3
Vendor 8
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 212000
Partner Type 1
Vendor 9 (Parent Company 3)
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 46
Partner Type 5
Vendor 1
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 16257
Vendor 2
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 394000
Spreadsheet: c2c7f8b3-b920-48ca-9171-aab140275728
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PIGF | Test | PIGF | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PIGF | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PIGF | Result | PIGF | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10948-8 | [NAME] feather [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 848274d1699022206-data-based-on-range-60713342-wsdot-i-405-brickyard-progress_sk
Sheet: Prog Summary

Current Period
 | Input
 | [NAME]
Effort Hours |  | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
Plan - Period |  |  |  |  |  |  | 0 | 0
A Segment 1 Roadway | 1000 |  |  | 50 | 400 | 500 | 50
Plan - Cum
Actual - Period |  | 0 | 329 | 2143.5 |  |  |  |  |  |  |  | Example
Actual - Cum
Earned - Period |  | 0 | 329 | 2143.5
Earned - Cum
To Be Earned - Period |  |  |  |  |  | 5949 | 1000 | 0
To Be Earned - Cum
ETC - Period
EAC - Cum
Metrics
Plan - Period |  | 0 | 0.05 | 0.35 | 0.45 | 0.15 | 0 | 0
Plan - Cum
Actual - Period
Actual - Cum
Earned - Period
Earned - Cum
ETC - Period
EAC - Cum
CPI - Period
CPI - Cum
SPI - Period
SPI - Cum
ETC - CPI |  | 0.8
Spreadsheet: louise_kitchen__22773__kevin
Sheet: Estate

Trading | Marketing
[NAME], [NAME] | Tricoli, [NAME]
[NAME], [NAME] | Ivani, [NAME]
Lenartowicz, [NAME] | Luong, [NAME]
Baughman, [NAME] | Tapscott, [NAME]
 | Dypiangco, [NAME]
 | Booth, [NAME]
 | Mitro, Fred
 | Hamlin, Mason
 | Ward, [NAME]
 | Hill, [NAME]
 | [NAME]
 | [NAME], [NAME]
 | [NAME], [NAME]
 | Ahmed, Naveed
 | [NAME], [NAME]
 | Kroll, Heather
 | Jester, [NAME]
Spreadsheet: 2d07b398-c711-4eb3-95c8-5f5b7d297c72
Sheet: In hours

Enter full year entitlement in hours
(if part-time, use calculator 1 on leave calculator if not known) |  |  | Working hours |  |  | INSTRUCTIONS FOR USE
 |  |  | Monday |  |  | 1.  Calculate entitlement (pro-rated if part-time)
Enter date of start of contract e.g. 1 September 2012 | 2012-09-01 00:00:00 |  | Tuesday |  |  | 2. Put your working hours in the table to the left (as a reminder).
(or  start date for annual leave year) |  |  | Wednesday |  |  | 3. Complete the table for Bank and University Holidays, putting in the hours you would normally work on that day. If you do not normally work that day, enter zero.
Enter end date of holiday year  i.e. 31 August 2012 | 2013-08-31 00:00:00 |  | Thursday |  |  | 4. Put zero for any days that occurred before you started work at the University.
 |  |  | Friday |  |  | 5. Add on the further days of bookable annual leave as they are taken, or when they are planned.
Number of days between the these two dates |  |  | Total
Entitlement in hours
HOLIDAY RECORD
 | Normal hours worked on that day(s) | Running total of leave taken | Running total of leave remaining |  |  | Note: The values used are fractions of an hour not minutes e.g. 7hrs 18 mins = 7.3 hours, NOT 7.18 hours
Bank and University Holidays
Tuesday 25th December 2012
Wednesday 26th December
Thursday 27th December
Friday 28th December
Monday 31st December
Tuesday 1st January 2013
Friday 29th March
Monday 1st April
Tuesday 2nd April
Monday 6th May
Monday 27th May
Monday 26th August
Tuesday 27th August
Bookable Leave
Spreadsheet: 50832d1250332089-excel-2007-help-with-vlookup-hlookup-footy
Sheet: League

 |  | Correct Score | Correct Result | Points |  |  | Correct Score |  |  |  | Correct Score | Correct Result |  |  |  |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CR
 | RAB | 3 | 2
 | DEAN | 1 | 4
 | PAUL A | 1 | 4
 | [NAME] | 1 | 4
 | RICKY | 1 | 2
 | HEATHER | 0 | 1
 | [NAME]
 | DARREN
 | DEREK
 | [NAME]
 | JOSS
 | NIGEL
 | PAUL D
 | [NAME]
 | STUART
Spreadsheet: 11a1cdb5-4d96-4191-84e7-5d55f76a9f2b
Sheet: Graph

 | Year | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
 | Canada
 | France
 | Russian Federation
 | China
 | India
 | Ukraine
 | United States of America
 | Australia
 | Germany
 | United Kingdom
Spreadsheet: 00e20d50-5d6f-4730-b744-aac67f3dfa0b
Sheet: Danville

BCTC Master [NAME]
 | MW | MW | MW | MW | MW | MW | MW | MW | MW | TR | TR | TR | TR | TR | TR | TR | TR | TR | F | F | Sat | Sat | Sun
 | 8:00-9:15 | 9:30-10:45 | 11:00-12:15 | 12:30-1:45 | 2:00-3:15 | 3:30-4:45 | 5:00-6:15p | 6:30-7:45p | 8:00-9:15p | 8:00-9:15 | 9:30-10:45 | 11:00-12:15 | 12:30-1:45 | 2:00-3:15 | 3:30-4:45 | 5:00-6:15p | 6:30-7:45p | 8:00-9:15p | 8:00-10:45 | 11:00-1:45 | 9:0-0-11:45 | 1:00-3:45 | 1:00-3:45
DAN 104  HUM
DAN 110  MS/HUM
DAN 112  MS
DAN 113  CHLSS
DAN 114 Comp Lab BusEd
DAN 115 Comp Lab CSIS
DAN 116  NSG
DAN 118  NSG/NS
DAN 120  NSG/CHLSS
DAN 122  NSG
DAN 124  NS
DAN 129  TT
DAN 130  MIT
DAN 131  TT
DAN 133  TT
DAN 134  MIT
DAN 136  MIT
Spreadsheet: 760299d1640125949-display-names-of-individuals-trained-small-sample
Sheet: Shift Bid

Name | SUN | MON | TUE | WED | THU | FRI | SAT |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | TRunTaxi
Suzy
[NAME]
[NAME]
[NAME]
Dale
Goal: This is the schedule by day. What I want the spreadsheet to do is on the next worksheet (Run_Taxi) pull data from the training list and only display the individuals by day that are Run/Taxi and then the same for the confined space. This is a very small sample of what I am trying to do, but if I can get the overall formula or steered in the right direction, then I can make the overall live spreadsheet do what I want it to do.
Spreadsheet: 885236d1734679210-changing-multiplier-based-on-cell-value-points-form-jt-
Sheet: January

Date | Day | Attended | Points
2025-01-01 00:00:00 |  | 1 |  |  | In individual month sheet:
 |  |  |  |  | With Date, Day, Attended and Points in columns A to D, and 1st day of the month in A2,
 |  | 1
 |  | 1
 |  |  |  |  | Conditional Formatting formula: =OR($B2="Sat",$B2="Sun"), applies to: =$A$2:$C$32
 |  |  |  |  | In Total sheet:
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
Total
 | Day | Attended | Points
 | Mon
 | Tue
 | Wed
 | Thu
 | Fri
 | Sat
 | Sun
 | Total
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: ivomir

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
[NAME]
[NAME]
Add as a friend Send message Donate
Experience level 29
21,252 / 25,000
Location: PolandPoland, Great Poland Citizenship: CroatiaCroatia
eRepublik birthday
Sep 08, 2009
National rank: 503
Congress Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
Archijev kutak
Friends(538)
sv3mir
Goonie GooGoo
L0rDPh03n1X
[NAME]
[NAME]
valkinor
[NAME]
eTomislav
dado007
view all
Land of ivomir: 17 buildings
Visit
About me
Wiki page
ARCHIBALD11
El Presidente novog svjetskog poretka!
Achievements
hard worker
11
Hard Worker
Worked 30 days in a row
congressman
1
Congress Member
Won the Congress elections
president
Country President
Win the Presidential elections
media mogul
2
Media Mogul
Reached 1000 subscribers to your newspaper
battle hero
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
17
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
4,444.00
Super soldier:4,443 / 4,500
Rank
Field Marshal ***Field Marshal ***
Rank points:
2,363,035 / 2,550,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 99462d1298068983-help-using-lookup-for-multiple-positions-in-fantasy-baseball-draft-bb-dft2
Sheet: DH

Column1 | First name | Last Name | Team | Owner |  | Position | My Team
1 | [NAME] | Scott, | BAL |  |  | C
2 | [NAME] | Ortiz, | BOS |  |  | 1B
3 | [NAME] | Guerrero, | BAL |  |  | 2B
4 | Adam | Lind, | TOR |  |  | 3B
5 | Hideki | Matsui, | OAK |  |  | SS
6 | [NAME] | Cust, | SEA |  |  | OF
7 | [NAME] | Thome, | MIN |  |  | OF
8 | Travis | Hafner, | CLE |  |  | OF
9 | Jake | Fox, | BAL |  |  | Util
 |  |  |  |  |  | Util
 |  |  |  |  |  | BN
 |  |  |  |  |  | BN
 |  |  |  |  |  | BN
 |  |  |  |  |  | BN
 |  |  |  |  |  | SP
 |  |  |  |  |  | SP
 |  |  |  |  |  | SP
 |  |  |  |  |  | SP
 |  |  |  |  |  | RP
 |  |  |  |  |  | RP
 |  |  |  |  |  | P
Spreadsheet: 169741d1343047548-lookup-more-than-one-table-depending-on-user-input-blank-database-2003-copy
Sheet: Quality

Date | Week | Month | Year | Product | Version | Passed | Failed | Total | Failure Code | Failure
2012-01-01 00:00:00 | 52 | Jan | 2012 | U/H |  | 7736 | 161 | 7897
2012-02-01 00:00:00 | 5 | Feb | 2012 | U/H |  | 3216 | 54 | 3270
2012-03-01 00:00:00 | 9 | Mar | 2012 | U/H |  | 4719 | 113 | 4832
2012-04-01 00:00:00 | 13 | Apr | 2012 | U/H |  | 4219 | 74 | 4293
2012-05-01 00:00:00 | 18 | May | 2012 | U/H |  | 6631 | 102 | 6733
2012-06-01 00:00:00 | 22 | Jun | 2012 | U/H |  | 5389 | 126 | 5515
2012-06-06 00:00:00 | 23 | Jun | 2012 | U/H |  | 400 |  | 400
2012-06-07 00:00:00 | 23 | Jun | 2012 | U/H |  | 281 | 1 | 282
2012-06-07 00:00:00 | 23 | Jun | 2012 | U/H |  |  | 2 | 2
2012-06-07 00:00:00 | 23 | Jun | 2012 | U/H | Iguana |  | 3 | 3
2012-06-11 00:00:00 | 24 | Jun | 2012 | U/H |  | 429 | 1 | 430 | 5 | [NAME]
2012-06-11 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 2 | 2 | 8 | Plug Fitting
2012-06-11 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 5 | 5
2012-06-12 00:00:00 | 24 | Jun | 2012 | U/H |  | 285 | 1 | 286 | 2 | Gear Cover
2012-06-12 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 1 | 1 | 3 | Coin Vibrator
2012-06-12 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 1 | 1 | 4 | [NAME]
2012-06-12 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 2 | 2 | 5 | [NAME]
2012-06-12 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 2 | 2 | 8 | Plug Fitting
2012-06-12 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 2 | 2 | 10 | Motor
2012-06-12 00:00:00 | 24 | Jun | 2012 | U/H |  |  | 1 | 1
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  | 376 | 0 | 376
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 1 | 1 | 5 | [NAME]
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 3 | 3 | 8 | Plug Fitting
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 1 | 1 | 12 | Damage C/Box
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 2 | 2
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 3 | 3
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 1 | 1
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 1 | 1
2012-07-02 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 1 | 1
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H |  | 415 | 1 | 416
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H |  |  | 1 | 1 | 4 | [NAME]
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H |  |  |  | 0 | 1 | Gears
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H | Iguana | 7 | 1 | 8
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H | Iguana |  | 2 | 10
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H | Iguana | 4 | 6 | 6
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H | Iguana | 6 |  | 0
2012-07-03 00:00:00 | 27 | Jul | 2012 | U/H | Iguana |  |  | 0
Spreadsheet: 182152d1348308722-function-similar-to-sumproduct-for-subtotal-exampleshadrack
Sheet: ALL

Name | Invoice Number | Year | Project Name | Project Address | A | B | C | D | E | F | G | H | I | J | K | L | Total
[NAME] | #1 | 2012 | Chase | Second Ave & 43rd Street; New York NY | 1000 | 8 | 8 | 8 | 4
[NAME] | #2 | 2012 | Chase | Park Avenue and 60th Street; New York NY | 1000 | 8 | 4 | 4 | 2
Nick | #3 | 2012 | Chase | Park Avenue and 57th Street; New York NY | 1000 | 2 | 4 | 32 | 7
[NAME] | #4 | 2012 | Chase | 3rd and 19th Street; New York NY | 1000 | 6 | 1 | 56 | 8
[NAME] | #5 | 2012 | Chase | Hauppauge; Hauppauge NY | 1000 | 2 | 52 | 7 | 4
[NAME] | #6 | 2012 | Chase | [NAME] and 69th Street; New York NY | 1000 | 2 | 3 | 3322 | 2
[NAME] | #7 | 2012 | Chase | Mounting Freedom Sussex; Mount Freedom NJ | 1000 | 7 | 7 | 4 | 6
[NAME] | #8 | 2012 | Chase | Chase WestField Broad; WestField NJ | 1000 | 3 | 8 | 4 | 8
Nick | #9 | 2012 | Chase | [NAME] NY | 1000 | 4 | 9 | 68 | 96
[NAME] | #10 | 2012 | Chase | Whitestone; Whitestone NY | 1000 | 4 | 6 | 9 | 4
[NAME] | #11 | 2012 | Chase | North Shore Tower; Floral Park NY | 1000 | 4 | 3 | 6 | 1
[NAME] | #12 | 2012 | Chase | Greenvale Northern; Greenvale N | 1000 | 2 | 3 | 6 | 5
[NAME] | #13 | 2012 | Chase | Morris Park Avenue; Bronx NY | 1000 | 8 | 5 | 3 | 7
[NAME] | #14 | 2012 | Chase | [NAME]; Woodbury NY | 1000 | 4 | 7 | 3 | 42
Nick | #15 | 2012 | Chase | East Hampton Main Street; East Hampton NY | 1000 | 1 | 5 | 31 | 5
[NAME] | #16 | 2012 | Chase | North Village and [NAME]; Rockville Center NY | 1000 | 1 | 4 | 4 | 5
[NAME] | #17 | 2012 | Chase | Queen Boulevard & 46th Street; Sunnyside NY | 1000 | 2 | 33 | 6 | 79
[NAME] | #18 | 2012 | Chase | Williston Park and Hillside Ave; Willistone Park NY | 1000 | 3 | 25 | 73 | 0
[NAME] | #19 | 2012 | Chase | Commack Vets Hwy; Commack NY | 1000 | 4 | 65 | 35 | 0
[NAME] | #20 | 2012 | Chase | Syosset; Syosset NY | 1000 | 3 | 42 | 335 | 74
Nick | #21 | 2012 | Chase | Wait Whitman; Huntington Station NY | 1000 | 4 | 57 | 24 | 4
[NAME] | #22 | 2012 | Chase | Hicksville; Hicksville NY | 1000 | 8 | 52 | 2 | 6
[NAME] | #23 | 2012 | Chase | Chatham; Chatham NJ | 1000 | 9 | 46 | 24 | 3
[NAME] | #24 | 2012 | Chase | Avenue J; Brooklyn NY | 1000 | 4 | 2 | 7 | 1
Spreadsheet: 175074d1345370969-which-lookup-function-to-use-pivot
Sheet: Sales by Person

Sum of Sales
name | date | Total
[NAME] | 2012-07-04 00:00:00 | 124
 | 2012-08-08 00:00:00 | 345
 | 2012-09-14 00:00:00 | 21
 | 2012-10-01 00:00:00 | 434
 | 2012-10-05 00:00:00 | 65
 | 2012-10-22 00:00:00 | 332
 | 2012-11-04 00:00:00 | 121
 | 2012-11-12 00:00:00 | 35
 | 2012-11-15 00:00:00 | 678
 | 2012-11-18 00:00:00 | 211
[NAME] | 2012-06-04 00:00:00 | 123
 | 2012-08-08 00:00:00 | 588
 | 2012-10-14 00:00:00 | 545
 | 2012-10-15 00:00:00 | 854
 | 2012-10-16 00:00:00 | 336
 | 2012-10-22 00:00:00 | 468
 | 2012-11-05 00:00:00 | 842
 | 2012-11-07 00:00:00 | 842
 | 2012-11-12 00:00:00 | 843
 | 2012-11-24 00:00:00 | 547
Elvis | 2012-01-12 00:00:00 | 446
 | 2012-01-31 00:00:00 | 545
 | 2012-02-12 00:00:00 | 874
 | 2012-02-14 00:00:00 | 120
 | 2012-02-18 00:00:00 | 120
 | 2012-03-05 00:00:00 | 325
 | 2012-04-01 00:00:00 | 841
 | 2012-04-06 00:00:00 | 545
 | 2012-08-12 00:00:00 | 898
 | 2012-09-11 00:00:00 | 894
Fred | 2012-07-04 00:00:00 | 456
 | 2012-08-08 00:00:00 | 965
 | 2012-09-14 00:00:00 | 215
 | 2012-10-01 00:00:00 | 854
 | 2012-10-05 00:00:00 | 841
 | 2012-10-22 00:00:00 | 898
 | 2012-11-04 00:00:00 | 123
 | 2012-11-12 00:00:00 | 842
 | 2012-11-15 00:00:00 | 554
 | 2012-11-18 00:00:00 | 544
[NAME] | 2012-06-04 00:00:00 | 74
 | 2012-08-08 00:00:00 | 45
 | 2012-10-14 00:00:00 | 56
 | 2012-10-15 00:00:00 | 848
 | 2012-10-16 00:00:00 | 453
 | 2012-10-22 00:00:00 | 953
 | 2012-11-05 00:00:00 | 873
 | 2012-11-07 00:00:00 | 554
 | 2012-11-12 00:00:00 | 123
 | 2012-11-24 00:00:00 | 783
[NAME] | 2012-06-04 00:00:00 | 152
 | 2012-08-08 00:00:00 | 145
 | 2012-10-14 00:00:00 | 452
 | 2012-10-15 00:00:00 | 225
 | 2012-10-16 00:00:00 | 665
 | 2012-10-22 00:00:00 | 455
 | 2012-11-05 00:00:00 | 875
 | 2012-11-07 00:00:00 | 215
 | 2012-11-12 00:00:00 | 230
 | 2012-11-24 00:00:00 | 980
Grand Total |  | 29410