tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6c5b703a-0050-4081-ac36-848f3dfd92cc
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35949978 | 2013-05-15 07:02:49 | ALLIES | 0 | 3 | 6 | 800235 | Black Arrow | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
35950136 | 2013-05-15 07:22:53 | AXIS | 1 | 6 | 4 | 800235 | Black Arrow | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
35961803 | 2013-05-16 03:01:54 | ALLIES | 1 | 6 | 5 | 1273891 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
35961962 | 2013-05-16 03:14:48 | AXIS | 1 | 6 | 4 | 1273891 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
35976408 | 2013-05-17 03:39:24 | ALLIES | 0 | 2 | 5 | 147867 | rockman | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
35976497 | 2013-05-17 03:51:22 | AXIS | 1 | 5 | 2 | 147867 | rockman | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
Spreadsheet: 820375d1678066168-sumifs-to-aggregate-hours-in-scheduling-problem1
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  | Scheduling
 |  |  |  |  |  |  |  |  |  |  | Project | Jan | Feb | Mar | Apr | May | Jun
 |  |  |  |  |  |  |  |  |  |  | A | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  | Table of Inputs |  |  |  |  |  |  | B |  | 1 | 2 | 3 | 4 | 5
 |  |  |  | No | Hours | Beg M | End M |  |  |  | C |  |  | 1 | 2 | 3 | 4
 |  |  |  | A | 8 | 1 | 2 |  |  |  | A | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  | B | 7 | 1 | 3
 |  |  |  | C | 6 | 1 | 4
 |  |  |  | D | 5 | 1 | 3
 |  |  |  | E | 3 | 1 | 3 |  |  | My Formula
 |  |  |  |  |  |  |  |  |  | Expected Result
Spreadsheet: 765906d1643661579-percentage-based-on-age-will-distrabution
Sheet: Sheet1

 | 290000
 |  | Name | Birth | Age | Parent | % | Amount |  |  |  |  | Pot for grandkids
 |  | [NAME] | 2010-08-12 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids |  |  |  | Pot for kids
 |  | [NAME] | 2012-01-26 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids |  |  |  | Total Pot
 |  | Mathew | 2007-03-16 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 |  | [NAME] |  |  | [NAME] |  |  | Based on pot for grandkids
 |  | Tyler TJ |  |  | [NAME] |  |  | Based on pot for grandkids
 |  | [NAME] | 2015-09-12 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 |  | [NAME] | 1995-05-26 00:00:00 |  | Shannon |  |  | Based on pot for grandkids
 |  | Nathen | 1999-04-20 00:00:00 |  | Shannon |  |  | Based on pot for grandkids
 |  | Hayden | 2009-04-22 00:00:00 |  | Shannon |  |  | Based on pot for grandkids
 |  | [NAME] | 1997-04-05 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 |  | Carlyann | 2019-04-23 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 | Great Grandchild | Madalyn |  |  | [NAME] |  |  | Based on pot for grandkids
 |  | Shannon | 1974-08-31 00:00:00 |  | [NAME] |  |  | Based on pot for kids
 |  | [NAME] | 1974-07-22 00:00:00 |  | [NAME] |  |  | Based on pot for kids
 |  | [NAME] | 1978-12-04 00:00:00 |  | [NAME] |  |  | Based on pot for kids
 |  | [NAME] | 1979-08-08 00:00:00 |  | [NAME] |  |  | Based on pot for kids
I have a total pot of B1, I want to take a % of that L3 and divide it up amongst my grandchildren based on their age by a percentage otherwise [NAME] would receive the most and Madyln would receive the least. So for example [NAME] would receive "[NAME] and [NAME] would receive "y" % as well as the rest based on the age percentage.
Aso L4 would be handeled the same based on the same but with the kids
Spreadsheet: 681188d1591380790-need-help-in-creating-a-labor-burden-chart-test-payroll2
Sheet: Sheet1

Employee | Rate/hr | Hours Worked | Gross Pay | Health Ins. Rate | Hlth Ins Deduc | NECA/Hr | [NAME] | NEBF Rate | NEBF Deduc | Training Fund Rate $/Hr | Training Fund Deduc | Annuity Rate | Annuity Deduc | Total Deductions | Net Pay
A | 42.39 | 40 |  | 0.16206652512385 |  | 0.13 |  | 0.03 |  | 0.19 |  | 0.0875
One Year:
A | 42.39 |  |  | 0.16206652512385 |  | 0.13 |  | 0.03 |  | 0.19 |  | 0.0875
 |  |  |  | Annual Income
 |  |  |  | Annual Indirect Costs
 |  |  |  | burden rate
Spreadsheet: 74326d1274873082-produce-data-from-pivot-table-jan-2010
Sheet: 20C01

Ldgr | Account | Period | Trans Date | Journal | Line | Amount | D/C | Reference | Description | Type | TCode 1 | TCode 5
A | 42J19 | 2010/001 | 2010-01-21 00:00:00 | 34489 | 23 | -8711.44 | C | SG2265BRN | REL PROV | GJ | 20C01 | GEN
A | 42J19 | 2010/001 | 2010-01-21 00:00:00 | 34489 | 26 | 8711.44 | D | SG2265BRN | PROJ OPEX Q309 CACS | GJ | 20C01 | GEN
A | 42J19 | 2010/001 | 2010-02-01 00:00:00 | 34592 | 73 | 1243.96 | D | ACCR 0110 | Oth Collection:IS/IT | GJ | 20C01 | GEN
A | 42J19 | 2010/001 | 2010-02-01 00:00:00 | 34592 | 75 | 669.82 | D | ACCR 0110 | Oth Recoveries:IS/IT | GJ | 20C01 | GEN
Spreadsheet: 857320d1706345208-resource-allocation-sheet-resource-allocation-excel-forum
Sheet: Sheet1

Status | Name | Project | Length of Project | Start date | End Date | Weeks in total | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number | Week Number
Active | [NAME] | Pharma APS | 6 months | 2023-12-01 00:00:00 | 2024-05-31 00:00:00 |  |  | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74
Active | Name 2 |  |  | 2023-02-02 00:00:00 |  | 4 |  | 7 | 8 | 9
Active | Name 3 |  |  | 2023-03-03 00:00:00 |  | 3 |  | 11 | 12
Active | Name 4 |  |  | 2023-04-04 00:00:00 |  | 1
Active | Mithilesh | R&D Packaging | 12 months | 2023-12-01 00:00:00 | 2024-12-31 00:00:00 | 52 |  | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100
 |  |  |  |  |  |  | 49 | 50 | 51 | 52 | 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 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  |  |  |  | Name 1
 | current formula result |  |  |  | Name 2
 | expected result- formula to be derived |  |  |  | Name 3
 |  |  |  |  | Name 4
Spreadsheet: 767932d1644747486-prize-pool-distribution-formula-new-microsoft-excel-worksheet
Sheet: Sheet1

Entries/Position | 2 to 20 Entries | 21 to 50 Entries | 51 to 100 Entries | 101 to 500 | 501 to 700 | 701 to 800 | 801 to 1000 | 1001 to 1250 | 1251 to 1500 | 1501 to 1750 | 1751 to 2000 | Result
1 | 1 | 0.5 | 0.4 | 0.27 | 0.24 | 0.235 | 0.23 | 0.225 | 0.22 | 0.2175 | 0.215 |  |  | Participants: | 1000
2 | - | 0.3 | 0.3 | 0.15 | 0.14 | 0.1375 | 0.135 | 0.1325 | 0.13 | 0.1275 | 0.125 |  |  | Total Pool:
3 | - | 0.2 | 0.2 | 0.13 | 0.088 | 0.088 | 0.085 | 0.085 | 0.083 | 0.083 | 0.081 |  |  | Peoples pool:
4 | - | - | 0.1 | 0.1 | 0.068 | 0.068 | 0.065 | 0.065 | 0.063 | 0.063 | 0.061 |  |  | Amount: | 2
5 | - | - | - | 0.09 | 0.058 | 0.058 | 0.055 | 0.055 | 0.053 | 0.053 | 0.051 |  |  | Total Fees: | 0.3
6 | - | - | - | 0.07 | 0.041 | 0.041 | 0.039 | 0.039 | 0.038 | 0.038 | 0.037
7 | - | - | - | 0.07 | 0.031 | 0.031 | 0.029 | 0.029 | 0.028 | 0.028 | 0.027
8 | - | - | - | 0.05 | 0.021 | 0.021 | 0.019 | 0.019 | 0.018 | 0.018 | 0.017
9 | - | - | - | 0.035 | 0.015 | 0.015 | 0.013 | 0.013 | 0.0125 | 0.0125 | 0.0118
10 | - | - | - | 0.035 | 0.011 | 0.011 | 0.01 | 0.01 | 0.0095 | 0.0095 | 0.0099
11-50 | - | - | - | 0.025 | 0.011 | 0.011 | 0.01 | 0.01 | 0.0095 | 0.0095 | 0.0075
16-20 | - | - | - | - | 0.0085 | 0.0075 | 0.007 | 0.007 | 0.0065 | 0.0055 | 0.0055
21-25 | - | - | - | - | 0.0075 | 0.0065 | 0.006 | 0.006 | 0.0055 | 0.0045 | 0.0045
26-30 | - | - | - | - | 0.0065 | 0.0055 | 0.005 | 0.005 | 0.0045 | 0.004 | 0.004
31-35 | - | - | - | - | 0.0055 | 0.005 | 0.0045 | 0.0045 | 0.004 | 0.0035 | 0.0035
36-40 | - | - | - | - | 0.005 | 0.0045 | 0.004 | 0.004 | 0.0035 | 0.003 | 0.003
41-50 | - | - | - | - | 0.0037 | 0.003 | 0.0028 | 0.0024 | 0.0024 | 0.0024 | 0.002
51-60 | - | - | - | - | 0.003 | 0.0027 | 0.0024 | 0.002 | 0.002 | 0.002 | 0.0019
61-75 | - | - | - | - |  | 0.0025 | 0.0022 | 0.0019 | 0.0019 | 0.0019 | 0.0018
76-100 | - | - | - | - |  |  | 0.0021 | 0.0015 | 0.0015 | 0.0015 | 0.0015
101-125 | - | - | - | - |  |  |  | 0.0014 | 0.0014 | 0.0013 | 0.0013
126-150 | - | - | - | - |  |  |  |  | 0.0013 | 0.0012 | 0.0012
151-175 | - | - | - | - |  |  |  |  |  | 0.0011 | 0.00075
175-200 | - | - | - | - |  |  |  |  |  |  | 0.00075
200+
Spreadsheet: 200542d1355617576-randomizing-variables-in-lists-2-pokerdrills22
Sheet: Sheet1

 | [NAME]
 |  |  | Fish Stealing |  |  |  |  |  |  | Isolating
 |  |  | F2ST+F2CB-1/2(Donk+CR) |  | F2 STEAL | F2CB | Donk+CR |  |  | Pos#+3B(oop)+Limper |  | Pos# | 3B% (OOP) | [NAME]
 |  |  |  |  | 33 | 61 | 32 |  |  |  |  | IP vs 2+ opponents | 12 | 140
 |  |  | 36% <150 |  |  |  |  |  |  | 3B% (OOP) -[a.b,c]
 |  |  | 50% 150-169 |  |  |  |  |  |  | a) <15
 |  |  | 75% 170+ |  |  | Reg F2ST |  |  |  | b) 16-20
 |  |  |  |  |  | 76 |  |  |  | c) 21+
 |  |  |  |  |  |  |  |  |  | Limper stats |  | BTN
 |  |  | Reg Stealing |  |  |  |  |  |  | F2 iso (-10) *+ F2 Cbet
 |  |  |  |  |  |  |  |  |  | *(-10) is due to SB freq
 |  |  | BTN vs Blinds (F2ST) | SB vs BB (F2ST)
 |  |  | <139 - 29% | <59 - 20% |  |  |  |  |  | a) 60+ | a) 13% | Only OOP
 |  |  | 140-159 - 43% | 60-64 - 25% |  |  |  |  |  | b) 60- | b) 18% | Both IP (2+) and OOP
 |  |  | 160-169 - 58% | 65-69 - 29% |  |  |  |  |  | a) 140+ | c) 25% | Both IP and OOP
 |  |  | >170 - 100% | 70-74 - 43% |  |  |  |  |  | b) 140- | d) 30% | Only IP (CO+)
 |  |  |  | >75 - 100% |  |  |  |  |  |  | e) 45% | Only IP (BTN+Vs1)
 |  |  | 3-Betting (4 & 5)
 |  |  | 1/ Sample |  |  | <1K |  | 1K+ |  |  |  | 3K+
 |  |  | 2/ [NAME] |  |  | LOW (<1k) |  | MED (1k-5k) |  |  |  | HIGH (>5K)
 |  |  |  |  |  | (Total FE3B) |  | MidLow 1k-2,5k | MidHigh 2,5-5k |  |  | (By Position)
 |  |  |  |  |  | >70 - 6% |  | Low(6%) / Mid(10%) | Mid(10%)/ High(14%) |  | 67-69 | 70-74 | 75+
 |  |  |  |  |  |  |  | Mid-IPvsSB/CO | High-IPvsSB/CO |  | 6% range | 10% range | 14% range
 |  |  |  |  |  |  |  | OOPvs-BTN/CO | OOPvs-BTN/CO
 |  |  |  |  |  |  |  | Low-70-74% FE
 |  |  |  |  |  |  |  | Mid-75%+ FE +POS
 |  |  | 3B-5B ranges (Villain's 4B) | --> If sample low
 |  |  | Vs EP/MP | Use assumption |  |  |  | 4B Range | F23B% | Positional 4B Range
 |  |  | <3.4 - 1% (KK+) | [NAME] use 2.5% range |  |  |  | 8 | 51 | 3
 |  |  | 3.5 - 4.4 - 2.5% (QQ+,AK)
 |  |  | >4.5 - 3% (JJ+,AK [JJ vs MP])
 |  |  | Vs other Pos (count it) | --> If sample low
 |  |  | <3 - 1% (KK+) | Use assumption |  |  | Sample
 |  |  | 3.1-3.9 - 2.5% (QQ+,AK) | [NAME] use 3% range |  |  | 5060
 |  |  | 4-4.9 - 3% (JJ+,AK)
 |  |  | 5-6.9 - 3.5% (TT+,AK)
 |  |  | >7 - 4.5% (TT+,AQ+)
 |  |  | Blocker Broadway Range |  |  |  |  | Positional 3B Range | F24B% | 5B Range
 |  |  | [NAME] 2.5% | KQ (Then Ax) ~1.2% |  |  |  | 4 | 62 | 1
 |  |  | [NAME] 3% | KQ,KJ,AJ ~3.5%
 |  |  | [NAME] 3.5% | KQ,KJ,KT,AJ,AT ~ 6%
 |  |  | [NAME] 4.5% | !!! KQ > Ax > BD !!!
 |  |  | 4% Total range (2.5%)
 |  |  | 5% Total range (3%)
 |  |  | 6% Total range (3.5%)
 |  |  | Calling Ranges
Spreadsheet: 719877d1613864280-auto-populate-date-ranges-to-linear-calendar-weekly-list-template
Sheet: Task List

 | To Weekly Task Schedule
 | TASK LIST
 | Date | Class | Assignment/Task | Match Data
 |  | HIS 101 | Page 90 & review chapter 5 for test on Friday
 |  | MTH 101 | Worksheet 56 (odd only) and study for test on Thursday
 |  | ART 101 | Prep for Lab
 |  | HIS 101 | Chapter 5 - 8 test
 |  | LIT 101 | Pages 78 - 88 & outline chapter 4
 |  | HIS 101 | Study for test
 |  | OTHER | Clean room for inspection
 |  | OTHER | Order pizza for study group
 |  | ENG 101 | Outline Essay
Spreadsheet: 210238d1359406324-spreadsheet-showing-consecutive-mondays-and-dates-in-a-year-2013-01-28-excel-forum-every-monday-oeldere-
Sheet: Blad1

2012-01-02 00:00:00
Spreadsheet: 819266d1677359746-conditional-formatting-does-not-highlight-all-cells-in-a-row-conditional-format-issue
Sheet: Sheet5

Customer | Address
HYFLUX
Network Engineering
Middle East Tech LLC
Network Engineering
DEWA | Dubai Electricity & Water Authority  P.O Box 564  Dubai - UAE.   TRN : 100027620200003
Ghantoot Gulf Contracting
[NAME]
[NAME]
OQ Exploration and Production LLC
[NAME]
Anuj Equipment & Machinery
Taurus General Contracting LLC
ITM O&M
[NAME]
Akar Landscaping Service
[NAME] S.L.U
[NAME] (A.T.E.C)
Camtech Manufacturing | CAMTECH MANUFACTURING FZCO  Plot No: S40309,Jebel Ali Free Zone - South,  [NAME], Dubai  UNITED ARAB EMIRATES  Tel : +[PHONE]   TRN: 100368190300003
[NAME]
Al Mansoori Industry Supply
Acciona Agua
[NAME] | Mustafa Sultan Science & Industry Co.LLC P.O. Box 3340 Ruwi, Postal Code 112 Sultanate of Oman.
Flowserve Gulf FZE
Envicon Emirates
Emirates Steel Industries PJSC
Concorde Trading Co. LLC
Emerson FZE
Flowtech LLC
Powertech System
Kalhour Oilfield Equipments Ltd
Fujairah Cement Industries
DUBAL | Dubai Aluminium (DUBAL) PO BOX 3627 DUBAI , UAE TRN : 100310988900003
[NAME]
[NAME]
Wom Valves and Controls International FZE
Delta Power
Audex [NAME] FZE | Audex [NAME] FZE P.O. Box 5461, Block C, FreeZone-1, [NAME], U A E Tel : +971 9 2281075 TRN: 100043616000003
[NAME]
Emirates Sembcorp Water and Power Company PJSC
L&T Valves Limited
Valtronics DWC LLC
Neway Flow Control DMCC
Samamat Flow Control LLC
Servetech Middle East
S2 O&M
HP Valves BV
Drydocks World Dubai LLC
Hydropower Energy & genral Construction
TECTON Engineering & Construction LLC
Asia Gulf Power Services Company
[NAME] L.L.C
Sanstar General Trading LLC
National Central Cooling Company (Tabreed)
M S H Equipment & Spare Parts
[NAME]
[NAME] (FZC)
TransJordan
Utico FZC
[NAME]
Lafarge Emirates Cement LLC
Mirfa International Power & Water Company
Sewoong Plant Middle East
Right Choice Equipments
Transco
Royal Gardens Agricultural Contracting LLC
VeBes O&M Company
Flowline Instruments FZE
Cunado S.A.U
[NAME] (ME) FZC
Kier Dubai LLC
Auma Actuators. Inc
Sipos Germany
Belfast Controls Equipments
Maintenance Services Gulf
Saveco Middle East FZE
Danway
NOV
L&T Valves
ARABIAN COAST CONTRACTING
WESCO LLC
Fujairah F2 O&M
EMAL
TETRA ENGINEERING CONSULTANCY
[NAME] [NAME]
Green Oasis
BIC Contracting LLC
Powergas Oilfields
Starlight
Kurdistan Pipeline Company Pte. Ltd. (KPC)
Shuweihat O&M
Auma Act Middle East W.L.L
Tecnicas Reunidas S.A.
PTPA Middle East
Sri Energy Valves Private Limited
[NAME]) Co.,Ltd.
Aroma Trading & Oilfield Equipment Est
Automation Solutions Ltd
Anuj Equipment & Machinery Trading LLC
Les Ciments Du Sahel SA
Vopak
Al Mariah United Group
Techno-Solutions & Services
Tech Hard Oilfield Supplies
EMDAD LLC
FUJAIRAH PORT AUTHORITY - Government Company
Control Seal Group FZE
Drehmo Germany
AEON
Spreadsheet: 803510d1667497981-xlookup-with-wildcards-book2-hd
Sheet: Sheet1

Employee ID | First name | Last name | Location | Temp | Location Code |  | Location Code | Location ID
11111111 | [NAME] | [NAME] | 3862 At-Home Texas TXC2 | N |  |  | AZA1 | 3822
22222222 | [NAME] | Jones | MNC1 - 3850 At-Home | Y |  |  | BCP1 | 3895
33333333 | Mark | Smith | 3845 - Louisiana | N |  |  | [NAME] | 3827
 |  |  |  |  |  |  | HIA1 | 3831
 |  |  |  |  |  |  | [NAME] | 3836
 |  |  |  |  |  |  | INC1 | 3840
 |  |  |  |  |  |  | KYC1 | 3843
 |  |  |  |  |  |  | [NAME] | 3845
 |  |  |  |  |  |  | LEX1 | 3889
 |  |  |  |  |  |  | MBC1 | 3816
 |  |  |  |  |  |  | MNC1 | 3850
 |  |  |  |  |  |  | NVP1 | 3855
 |  |  |  |  |  |  | ORP1 | 3866
 |  |  |  |  |  |  | TXC2 | 3862
 |  |  |  |  |  |  | TXM1 | 3875
 |  |  |  |  |  |  | UTM1 | 3877
 |  |  |  |  |  |  | WYM1 | 3882
Spreadsheet: 747207d1631281174-race-position-tracker-calc-ahead-and-behind-relative-to-own-position-race-position-tracker-calc-1-
Sheet: Sheet1 (3)

Lap = | 74
Position | Car | Gap | Diff | Helper1 | Helper2 | AB | AB Should Be
1 | 99
2 | 14 | 10
3 | 22 | 4
4 | 01 | 12
5 | 66 | 5
6 | 11 | 12
7 | 44 | 20
8 | 77 | 2
9 | 653 | 3
10 | 666 | 8 |  |  |  |  | -13
11 | 172 | 24 |  |  |  |  | -37
12 | 171 | 1L |  |  |  |  | -1L
13 | 12 | 2L |  |  |  |  | -3L
14 | 67 | 3L |  |  |  |  | -6L
Spreadsheet: 115512d1311097921-multiple-sumif-criteria-within-same-column-copy-of-multiple-sumif-example-2
Sheet: End table

Criteria | MAY-11 | JUN-11 | JUL-11 | AUG-11 | SEP-11
Apple | 37 | 7 | 24.99999999999994 | 20.99999999999951 | -54.1975815316776
Ford | 0 | 0 | 0 | 0 | 0
Porsche | 0 | 0 | 63.8032666285716 | 74.4371445 | 74.4371445
Mango | 0 | 0 | 117.7714285714266 | 717.72882 | -272
Toyota | 0 | 0 | 0 | 0 | 0
Nissan | 0 | 0 | 23.6785723285773 | -3.25000010000001 | -3.2500001
Honda | 0 | 0 | 366.642870557143 | -914.50003659999 | -15.5000013000008
Carrot | 0 | 0 | -351.517859221429 | 1047.7500062 | -1.00000079328311e-07
Better illustration of end state:
 |  | End Product
Criteria | MAY-11 | JUN-11 | JUL-11 | AUG-11 | SEP-11
Apple | 37 | 7 | 24.99999999999994 | 20.99999999999951 | -54.1975815316776
Ford |  |  | 0 | 0 | 0
Porsche |  |  | 63.8032666285716 | 74.4371445 | 74.4371445
Mango | 0 | 0 | 117.7714285714266 | 717.72882 | -272 | --> lump sum values (Mango + Strawberry) now under "Mango"
Toyota |  | 0 | 0 | 0
Nissan |  |  | 23.6785723285773 | -3.25000010000001 | -3.2500001
Honda |  |  | 366.642870557143 | -914.50003659999 | -15.5000013000008
Carrot | 0 | 0 | -351.517859221429 | 1047.7500062 | -1.00000079328311e-07 | --> lump sum values (Carrot + Bean) now both "Carrot" value
This is the end result of what the table should look like. Is there any way to combine the criteria AND values for certain categories?
Spreadsheet: daren_farmer__6636__CES - April
Sheet: Prebid Info

 | Supply |  |  | Market | Net |  | Comments
 | [NAME] | Other
BDOL | 0 | 208 |  | 208 |  |  | Spinnaker sale to Dow
CCNG | 0 | 1097 |  | 1097 |  |  | [NAME] to CCNG
CSGT | 0 | 1233 |  | 1233 |  |  | Spinnaker sale to Dow
DEFS | 0 | 0 |  | 0 |  |  | Expired
ETXG | 78732 | 3068 |  | 0
GEMC | 15602 | 1124
GPPP | 12474 |  |  |  |  |  | [NAME] Pdn to HPL / Tenn Zn 0
KMID | 2012 | 322 |  | 2334 |  |  | [NAME] sale to Delhi (KMID)
LONE | 4446 | 702 |  | 5148 |  |  | [NAME] sale to TXU Energy
MTPC | 2480 | 0 |  | 2480 |  |  | [NAME] sale to MTPL
TOMC | 2027 | 0 |  | 0 |  |  | Kerr McGee to HPL
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T65

الجدول 65: وفيات الإناث المسجلة، 2000-2012
Table 65: Registered female deaths, 2000-2012
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | البلد
Bahrain | 832 | 771 | 796 | 872 | 919 | 895 | 938 | 847 | 921 | 936 | … | … | … | البحرين
Egypt | 183324 | 181600 | 197224 | 202282 | 198809 | 203895 | 202105 | 204196 | 205817 | 215465 | 218682 | 217549 | 238424 | مصر
Iraq | 125646 | 35522 | 38168 | 38137 | 39905 | 43187 | 85456 | 51321 | 57326 | 51345 | 52792 | … | … | العراق
Jordan | 5411 | 6670 | 7131 | 6911 | 6932 | 7326 | 8644 | 10363 | 8302 | 8856 | 9799 | 9339 |  | الأردن
Kuwait | 1537 | 1603 | 1587 | 1602 | 1705 | 1647 | 1819 | 1938 | 2104 | 2460 | 2081 | 2031 | … | الكويت
Lebanon | 8241 | 7709 | 7681 | 7720 | 7905 | 7983 | 8231 | 9404 | 9420 | 10029 | 10563 | 11350 | 11227 | لبنان
Libya | … | … | … | … | 6613 | 6755 | 7609 | 8677 | 9269 | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | … | … | … | … | … | … | … | … | [NAME]
Oman | 1008 | 1023 | 1033 | 1114 | 1092 | 1186 | 2228 | 2663 | 2667 | 2440 | 2761 | 2685 | … | عمان
Palestine | 4026 | 4009 | 4168 | 4349 | 4140 | 4230 | 4189 | 4327 | 2824 | 2870 | 2866 | 3005 | … | فلسطين
Qatar | 394 | 379 | 365 | 415 | 417 | 437 | 476 | 457 | 487 | 493 | 500 | 547 | … | قطر
Saudi Arabia | 36107 | 36523 | 36945 | 37371 | 37803 | 38232 | 38667 | 39128 | 39609 | 40120 | … | ... | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | … | … | … | … | … | السودان
Syrian Arab Republic | 21804 | 22554 | 23434 | 23647 | 26151 | 26921 | 25522 | 28064 | 30694 | 32312 | 34070 | … | … | الجمهورية العربية السورية
Tunis | … | … | … | … | … | … | 23606 | … | … | … | … | 26250.4 | … | تونس
United Arab Emirates | 1480 | 1644 | 1607 | … | … | 1806 | 1796 | 1946 | 1975 | 1940 | 2129 | 2095 | … | الإمارات العربية المتحدة
Yemen | 4643 | 4605 | 4745 | 4984 | 5372 | 4039 | 4131 | 4817 | 4866 | 6288 | 5330 | 4545 | … | اليمن
Spreadsheet: 40162d1238501218-cell-references-in-formulae-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 377101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date of Input | 2009-01-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mileage | B1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-02 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-03 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-04 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-05 00:00:00 |  | B1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-06 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-07 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-08 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-09 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-10 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-11 00:00:00 |  | #N/A
A | B1 | A1 | B2 | A2 | B12 | A3 | C1 | A4 | B13 | A5 | B21 | A6 | B14 | A7 | C2 |  | 2009-01-12 00:00:00 |  | #N/A
B1 | A1 | B2 | A2 | B12 | A3 | C1 | A4 | B13 | A5 | B21 | A6 | B14 | A7 | C2 | A |  | 2009-01-13 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-14 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-15 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-16 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-17 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-18 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-19 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-20 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-21 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-22 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-23 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-24 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-25 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00 |  | #N/A