tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a9e2ec95-2c88-467b-bc28-9702f2dc04f1
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
Wines offered in GBP per case of 12 bottles, 24 half-bottles or 6 magnums, unless otherwise indicated. 26 October 2014.  Wines lying in bond at London City Bond. E&O.E.  Prices exclude duty and VAT.  For all enquiries, please contact us at [EMAIL]
Region | Producer | Vintage | Wine | Condition | Cs | Bt | GBP Sell | Per | Size | Units | GBP/bt
Dry White Bordeaux | - | 2012 | Carbonnieux Blanc | - | 20 | - | 200 | CS | 75cl | 240 | 16.67
Dry White Bordeaux | - | 2011 | Carbonnieux Blanc | - | 3 | 6 | 215 | CS | 75cl | 42 | 17.92
Dry White Bordeaux | - | 2010 | Carbonnieux Blanc | - | 2 | - | 240 | CS | 75cl | 24 | 20
Dry White Bordeaux | - | 2005 | Domaine de Chevalier Blanc | - | 1 | - | 580 | CS | 75cl | 12 | 48.33
Dry White Bordeaux | - | 1999 | Domaine de Chevalier Blanc | - | 1 | - | 450 | CS | 75cl | 12 | 37.5
Dry White Bordeaux | - | 2009 | Haut Brion Blanc | - | - | 6 | 6600 | CS | 75cl | 6 | 550
Dry White Bordeaux | - | 2005 | [NAME] | - | - | 6 | 450 | CS | 75cl | 6 | 37.5
Dry White Bordeaux | - | 2013 | Ygrec | - | 8 | - | 980 | CS | 75cl | 96 | 81.67
Spreadsheet: sally_beck__35538__Outsourcing Margin
Sheet: USD

 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | Total
Revenue
Petro Canada
Suncor/Sonoco
Small MSA
Total Revenue
Costs
Petro-Canada
Confirmations | 605.643141 | 1171.797136 | 268.718225 | 838.057501
Deal/Data Setup | 2652.293407000001 | 2662.540892 | 872.593453 | 1686.623341
Logistics | 23893.578622 | 12408.197329 | 5311.873487000001 | 7086.642468
Risk Management | 605.643141 | 1171.797136 | 268.718225 | 838.057501
Settlements | 21960.8945 | 10833.645762 | 6615.693607 | 11151.431579
Volume Management | 14543.581609 | 8735.632671 | 5713.619795 | 8307.234314
Total
Suncor/Sunoco
Confirmations | 587.830108 | 891.5010749999999 | 174.170683 | 774.552074
Deal/Data Setup | 2617.281632 | 2970.946187 | 641.23043 | 1426.213134
Logistics | 6399.489769 | 5373.071094000002 | 2129.101655 | 3196.756359
Risk Management | 587.830108 | 891.5010749999999 | 174.170683 | 774.552074
Settlements | 12377.958718 | 6317.332448000001 | 3078.474334 | 5172.897854
Volume Management | 7551.226403000001 | 4844.328420000001 | 2545.828403 | 4065.645231
Total
Small MSA Companies
Confirmations | 587.830108 | 1048.740329 | 310.2269019999999 | 867.2356699999999
Deal/Data Setup | 3907.187261999999 | 2672.416648 | 1107.530914 | 1593.908074
Logistics | 11910.546345 | 8453.073403 | 3540.112856 | 5571.2266
Risk Management | 587.830108 | 1048.740329 | 310.2269019999999 | 867.2356699999999
Settlements | 6388.623853999999 | 4122.936561 | 1489.987747 | 2444.11491
Volume Management | 6113.42738 | 4051.699748 | 2328.301212 | 3514.537052000001
Total
Total Costs
Margin
Driver Counts
Petro-Canada
CF (New Deals) | 119 | 157 | 128 | 181
DS (New Deals) | 119 | 157 | 128 | 181
LG (Receipt Points/Facilities) | 171 | 173 | 178 | 178
RM (Active Books) |  | 2 | 4 | 4
ST (Invoices) | 55 | 55 | 66 | 63
VM (Invoices/Receipt Points) | see above | see above | see above | see above
Suncor/Sunoco
CF (New Deals) | 118 | 219 | 99 | 139
DS (New Deals) | 118 | 219 | 99 | 139
LG (Receipt Points/Facilities) | 58 | 69 | 69 | 69
RM (Active Books) |  | 2 | 3 | 3
ST (Invoices) | 31 | 31 | 30 | 29
VM (Invoices/Receipt Points) | see above | see above | see above | see above
Small MSA Companies
CF (New Deals) | 193 | 171 | 169 | 155
DS (New Deals) | 193 | 171 | 169 | 155
LG (Receipt Points/Facilities) | 113 | 114 | 114 | 134
RM (Active Books) |  | 5 | 5 | 5
ST (Invoices) | 16 | 16 | 13 | 13
VM (Invoices/Receipt Points) | see above | see above | see above | see above
Spreadsheet: 0e6a4cfd-4f6b-45fa-a62a-bed85dbeca89
Sheet: HSSA

 | The University of Texas Health Science Center at San Antonio |  |  |  |  |  |  |  |  |  |  |  | Return to Index |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | Zoom % should be at 75%.
 | Summary of R & D Expenditures |  |  |  |  |  |  |  |  | Overall Total | Defined For Survey
 | R & D Expenses as defined for the Research Expenditure Survey
 | R & D Expenses not meeting the narrow definition of R & D used in the Research Expenditures Survey
 | Total Expenses for R & D as reported on the Statement of Revenues, Expenses and Changes in Net Assets
 | Other Research-related Equipment Expenditures (noncurrent fund expenditures, etc. - do not include R & D plant expenses or construction)
 | Indirect Costs associated with Expenses for R & D as defined for this survey
 | Capital Outlay for research equipment (do not include R & D plant expenses or construction)
 | Expenditures for conduct of R & D made by institution's research foundation or 501© corporation on behalf of the institution and not report in institution AFR, including indirect costs not reported above
 | Pass-throughs from Texas Engineering Experiment Station not reported in R & D Expenditures as defined for the Research Expenditure Survey
 | Total R & D Expenditures |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | R & D Expenditures By Funding Source |  |  |  | Federal | State Appropriations | State Contracts/Grants | Institution Resources | Private                  For-Profit | Private                     Non-Profit | Total
 | Agricultural Sciences
 | Biological and Other Life Sciences
 | Computer Science
 | Engineering
 | Environmental Sciences
 | Mathematical Sciences |  |  |  |  |  |  |  |  |  |  |  |  | Difference
 | Medical Sciences
 | Physical Sciences
 | Psychology
 | Social Sciences
 | Other Sciences not classified above
 | Arts and Humanities
 | Business Administration
 | Education
 | Law
 | Field of Study - Future Use 1
 | Field of Study - Future Use 2
 | Field of Study - Future Use 3
 | Field of Study - Future Use 4
 | Field of Study - Future Use 5
 | Other Non-Science Activities |  |  |  |  |  |  |  |  |  |  |  |  | To Accountability | Sources & Uses
 | Total R & D Expenditures By Funding Source |  |  |  |  |  |  |  |  |  |  |  |  | ResPercGenRev | State Appropriations
 |  |  |  |  |  | State Total |  |  | Pvt. Total |  | Federal & Private
 | R & D Expenditures - Select Areas of Special Interest |  |  |  |  |  |  |  |  |  |  |  |  | ExpendPerFTE
 | Aging
 | Cancer Research |  |  |  |  |  |  |  |  |  |  |  |  | T/TT Fall Fac FTE
 | Cardiovascular Research
 | Child Health and Human Development |  |  |  |  |  |  |  |  |  |  |  |  | As of Fall xxxxx
 | Mental Health
 | HRI Special Interest - Future Use 1
 | HRI Special Interest - Future Use 2
 | HRI Special Interest - Future Use 3
 | HRI Special Interest - Future Use 4
 | HRI Special Interest - Future Use 5
 | Total R & D Expenditures - Select Areas of Special Interest
Spreadsheet: 702480d1604378638-vlookup-sample
Sheet: Order

 |  |  | Date | Name | Mobile | [NAME] | [NAME] | Anjeer Medium | Cardamom Green 8mm | Cashew  W 210 | [NAME] | Cashew Tukda | [NAME]) | Cashew W 240 | Clove
 |  |  |  |  |  | अक्रोड | बदाम | अंजीर | वेलची | काजू-W210 | दोन तुकडा काजू | काजू तुकडा | काजू-180 | काजू-W240 | लवंग
 |  |  | 2020-10-28 00:00:00 | [NAME] |  | 500 |  | 1000 |  | 250 | 1000
 |  |  | 2020-10-28 00:00:00 | [NAME]
 |  |  | 2020-10-28 00:00:00 | [NAME] |  |  |  |  |  |  | 500
 |  |  | 2020-10-28 00:00:00 | SUDHIR  REGE |  |  | 500
 |  |  | 2020-10-28 00:00:00 | MANJU GODHIA |  |  | 225 |  |  |  |  | 500 |  | 250
 |  |  | 2020-10-28 00:00:00 | MANJU GODHIA |  |  |  | 1000 |  |  |  |  |  | 225 | 500
 |  |  | 2020-10-28 00:00:00 | KALPANA SHASHTRI |  | 225 |  |  |  |  | 500
Spreadsheet: jim_schwieger__14291__BammelOA2001
Sheet: 9811

519 | I | 15261 | 16923
3082 | I | 272061 | 294418
3098 | I | 8632 | 8847
3100 | I | 1294861 | 1327121
3102 | I | 489098 | 500830
5499 | I | 455466 | 476446
9631 | I | 37890 | 40246
1355 | O | 0 | 0
3099 | O | 1690751 | 1734457
3101 | O | 258849 | 266569
3103 | O | 241149 | 248035
3052 | F | 0 | 0
3073 | F | 0 | 0
3074 | F | 0 | 0
3075 | F | 0 | 0
3083 | F | 3052 | 3125
3084 | F | 3780 | 3879
3085 | F | 2897 | 2968
3086 | F | 1788 | 1832
3087 | F | 2247 | 2303
3088 | F | 0 | 0
3089 | F | 776 | 804
3090 | F | 492 | 504
3091 | F | 227 | 232
3092 | F | 306 | 313
3093 | F | 388 | 397
3094 | F | 13 | 13
3095 | F | 1123 | 1151
3096 | F | 910 | 930
3097 | F | 920 | 941
8645 | F | 0 | 0
Spreadsheet: 68683d1269278348-index-of-all-numbers-in-a-range-no-white-space-cc-deposits
Sheet: Data

 | Month: | 3
 | Year: | 2010
 | 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
Interac | 470.91 | -43.57 | 188.65 | 272.32
310100 | 461.89 | 287.22 | 210.42 | 394
 | 381.77 | 3533.62 | -176.24 | 352.12
 |  | 58.77
Cash | 162.85 | 159.5 | 208.8 | 180.3
310020 | 772.95 | 142.05 | 170.5 | 165.9
 | 10962.6 | 115.4 | 179.35 | 222.93
 | 273.92 | 1771.12 | 570.87 | 74.05
Imprest | -424.57 |  | 2307.83
327030
Cash Over/Short
155030
 | 13062.32 | 6024.11 | 3660.18 | 1661.62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 750414d1633443988-automating-color-coding-and-trend-help-needed-jlausier-data-color-coding-request
Sheet: Nov 2021

 | Data accuracy |  |  | 98-100% Accuracy |  | 95-97% Acccuracy |  | <95 Accuracy
 | On order no activity
 |  | United States | Trend | EMEA | Trend | WEC | Trend | LATAM | Trend | [NAME] | Trend
 | Total Records | 51348 |  | 4479 |  | 20557 |  | 2451 |  | 8284
 | Erroneous Records | 56 |  | 330 |  | 232 |  | 253 |  | 354
 | % of Erroneous Data
 | In Stock but network activity
 |  | United States | Trend | EMEA | Trend | WEC | Trend | LATAM | Trend | [NAME] | Trend
 | Total Records
 | Erroneous Records | 93 |  | 7 |  | 12 |  | 8 |  | 200
 | % of Erroneous Data
 | In Use but no network activity
 |  | United States | Trend | EMEA | Trend | WEC | Trend | LATAM | Trend | [NAME] | Trend
 | Total Records
 | Erroneous Records | 169 |  | 21 |  | 35 |  | 19 |  | 40
 | % of Erroneous Data
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: Intra-EMWNSS1

 | Intra-EMWNSS1 - FINANCIAL
 | Financial Values (May-out)
 | Price Positions
 | New Price Positions
 | Basis Positions
 | Index Positions
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
 | [NAME] in the previous month
 | Price Positions |  | -9765870
 | Basis Positions |  | -32673
 | Index Positions |  | 8270
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
31
 | Financial Liquidations - August only (Enter liquidations at end of month)
 | Price Positions |  | 1541520
 | Basis Positions |  | -104464
 | Index Positions |  | -26117
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
33
 | MTM Values (Sept-out)
 | Price Positions
 | Basis Positions
 | Index Positions
 | Gas Daily Swaps
 | Price Option
 | Basis Option
 | Gas Daily Option
30
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Mr. Antonie Rustom

Contract Terms (*)
 |  | Revenue Target (Physiotherapy) | Incentive
 |  | Tier 1 - 0 to 130,000 | 0
 |  | [NAME] to 150,000 | 0.037
 |  | [NAME] to 160,000 | 0.047
 |  | [NAME] and ABOVE | 0.057
 |  | Wellness Machines Participation | Revenue Share
 |  | Tonie  Rustom (Operation) | 0.0411
Doctor Calculation
 |  | Physio Total Revenue | 122867.85
 |  | Amount to be paid
 |  | Wellness Revenue Share | 82385.06
 |  | Amount to be paid |  | 0.0411
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 107772d1304935850-how-to-return-a-value-a-row-below-the-search-value-excel-problem
Sheet: Sheet1

Report |  |  | What I'm trying to get
Invoice No.
Invoice Value
Inv 123/2011 |  |  | Inv 123/2011
10000 |  |  | Inv 124/2011
 |  |  | Inv 125/2011
Inv 124/2011 |  |  | Inv 126/2011
15000 |  |  | Inv 127/2011
Inv 125/2011
20000
Inv 126/2011
25000
Inv 127/2011
30000
Spreadsheet: 152111d1335263660-finding-a-value-within-two-different-ranges-template
Sheet: Formula result

status | week |  |  |  | commentaire
On-Call | 9 |  |  |  | robert.germain, jeanf.mongrain
Night Shift | 10 |  |  |  | x
On-Call | 8 |  |  |  | dave.richard,luc.ladouceur
Vacance | 12 |  |  |  | x
On-Call | 10 | 40980
On-Call | 11 | 40980 | 8h00 | E1740
Completed | 3
On-Call | 12 | 40980 | 8h00 | E1758
On-Call | 1 | 40980 | 8h00 | E1958
On-Call | 2 | 40980 | 8h00 | E1958
On-Call | 3
On-Call | 4 | 40981 | 10h00 | E1758
On-Call | 5 | 40981 | 10h00 | E0170
On-Call | 6
On-Call | 7 | 40982 | 00h01 | E5368
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 143 | 143
Asia | - | - | -
Europe | - | 30 | 30
North America | - | 113 | 113
Other | - | - | -
Index | 5225 | 2561 | 7786
Asia | - | 40 | 40
Europe | 2009 | 471 | 2480
North America | 3119 | 1958 | 5077
Other | 97 | 92 | 189
Other | 7 | 167 | 174
Exotic | - | 19 | 19
Swaptions | 7 | 132 | 139
Total Return Swap | - | 16 | 16
TOTAL | 5232 | 2871 | 8103
Spreadsheet: 01c1b147-9d55-41a2-bcd6-23bf6a472866
Sheet: Sheet1

Eight Grant Programs for Nonprofits to Consider | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Close Date | Opportunity Title | Agency | description | category | minimum | maximum | total
 | Rural Business Enterprise [NAME] (RBEG) | Business and Cooperative Programs | USDA Rural Business Enterprise Grants | community?
 | Department of Labor Recovery Act Competitive Grant Opportunities | Employment and Training Administration | job training in energy efficiency, renewable energy, heath sector, and other | workforce |  |  | $750 mil
02/16/2011 | Assisted Housing Stability and Energy and Green Retrofit | Department of Housing and Urban Development | for owners of 202, 811 projects - energy and green retrofit | housing |  |  | $250 mil
09/30/2010 | Recovery Act Funds - Environmental Internships | Fish and Wildlife Service | environmental internships | workforce | 1000 | 500000 | $5 mil
08/03/2010 | American Recovery and Reinvestment Act of 2009, Health Information Technology Extension Program: Regional Centers | Office of Public Health and Science | for nonprofits, HIT regional center | health | $1 mil | $30 mil | $598 mil
06/30/2010 | EDA Recovery Act Funding | Economic Development Administration | for communities that have experienced sudden and severe economic dislocation | workforce
10/05/2009 | Recovery Act-Health Care Sector and Other High Growth and Emerging Industries | Employment and Training Administration | worker training and placement in health care | workforce | $2 mil | $5 mil | $220 mil
09/29/2009 | Recovery Act - Pathways Out of Poverty | Employment and Training Administration | worker training and placement | workforce | $2 mil | $8 mil | $150 mil
Five [NAME] to Watch for Possible Partnerships
 | Office of Elementary & Secondary Education; Overview Information: Race to the Top Fund (ARRA) CFDA 84.395 | Department of Education | for states, Race to the Top | education |  |  | $4.35 bil
10/20/2009 | Recovery Act - State Energy Sector Partnership (SESP) and [NAME] | Employment and Training Administration | for [NAME] for worker training in green economy | workforce | $2 mil | $6 mil | $190 mil
10/16/2009 | American Recovery and Reinvestment Act of 2009, State Grants to Promote Health Information Technology Planning and Implementation Projects | Office of Public Health and Science | grants to states to improve HIT technology | health | $4 mil | $40mil | $564 mil
10/08/2009 | Recovery Act Local Energy Assurance Planning (LEAP) Initiative | National Energy Technology Laboratory | planning $ to cities for reliable energy delivery | energy | 60000 | 300000
09/30/2009 | Recovery Act - Fish Passage | Fish and Wildlife Service | habitat restoration | community? |  | 500000 | $2.8 mil
Spreadsheet: 703656d1605101662-monthly-report-using-index-match-2nd-sheet
Sheet: ZW$ Sales

 | Date | Order Number | Customer Code | Customer Name | VAT Number | Invoice | Product Code | Description | Unit Price | Quantity | Gross Amount | Discount % | Discount Amount | Amount Excl VAT | VAT % | [NAME] | Amount Incl VAT | Notes
 | 2020-01-10 00:00:00 |  | ST 001 | [NAME] | 2018 | 1 | 100 | sales | 10 | 100 | 1000 | 10 | 10000 | 11000 | 0.15 | 1650 | 12650 | 30
 | 2020-01-10 00:00:00 |  | ST 001 | [NAME] | 2018 | 1 | 100 | sales | 10 | 101 | 1010 |  | 0 | 1010 | 0.15 | 151.5 | 1161.5 | 40
 | 2020-01-12 00:00:00 |  | ST 003 | [NAME] | 2019 | 3 | 100 | sales | 10 | 102 | 1020 |  | 0 | 1020 | 0.15 | 153 | 1173
 | 2020-01-13 00:00:00 |  | ST 004 | O'Neil James | 2019 | 4 | 100 | sales | 10 | 103 | 1030 |  | 0 | 1030 | 0.15 | 154.5 | 1184.5
 | 2020-01-23 00:00:00 |  | ST 001 | [NAME] | 2018 | 5 | 100 | sales | 10 | 104 | 1040 |  | 0 | 1040 | 0.15 | 156 | 1196
 | 2020-02-13 00:00:00 |  | ST 006 | ALEXANDER NDEBELE | 0 | 6 | 100 | sales | 10 | 105 | 1050 |  | 0 | 1050 | 0.15 | 157.5 | 1207.5
 | 2020-02-14 00:00:00 |  | ST 007 | [NAME] | 0 | 7 | 100 | sales | 10 | 106 | 1060 |  | 0 | 1060 | 0.15 | 159 | 1219
 | 2020-03-15 00:00:00 |  | ST 008 | NCUBE ANDILE B | 0 | 8 | 100 | sales | 10 | 107 | 1070 |  | 0 | 1070 | 0.15 | 160.5 | 1230.5
 | 2020-09-09 00:00:00 |  | ST 009 | [NAME] | 0 | 9 | 100 | sales | 10 | 108 | 1080 |  | 0 | 1080 | 0.15 | 162 | 1242
 | 2020-09-10 00:00:00 |  | ST 010 | ASHER | 0 | 10 | 100 | sales | 10 | 109 | 1090 |  | 0 | 1090 | 0.15 | 163.5 | 1253.5
 | 2020-09-11 00:00:00 |  | ST 011 | THOKOZILE SIBANDA | 0 | 11 | 100 | sales | 10 | 110 | 1100 |  | 0 | 1100 | 0.15 | 165 | 1265
 | 2020-09-12 00:00:00 |  | ST 001 | [NAME] | 2018 | 12 | 100 | sales | 10 | 79 | 790 |  | 0 | 790 | 0.15 | 118.5 | 908.5
Spreadsheet: 65383d1266073711-validate-multiple-date-and-time-for-getting-tat-command-buttons-for-filtering-and-date-and-time-function-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | 12 | 01:59:59
 |  |  |  |  |  |  |  | 01:59:59
Sr. # | Route File | Route Recd. Date and Time | Route Comp. Date and Time | Search Start Time | Search End Time | On Hold | Search Received | Remaining TAT | Escalated Hour(s) | Search Period | Completed Time |  | TAT
1 | XYZ 99986789 | 2010-02-04 07:10:30 | Pending | 2010-02-04 07:10:30 | 2010-02-04 08:10:13 | Yes | No | 01:59:59 |  | 00:59:43 | 2010-02-04 09:10:13 |  | 01:00:00
2 | ABC 99799758 | 2010-02-04 07:00:00 |  | 2010-02-04 07:10:00 | 2010-02-04 07:30:01 | Yes | No | 00:20:01 | 00:20:01 |  | 2010-02-04 08:10:12
3 | XYZ 12345678 | 2010-02-04 20:00:00 | Pending | 2010-02-04 20:30:00 | 2010-02-04 22:30:00 | Yes | No | {=IF(OR(F6="",F6="Pending",D6="Pending"),"",(F6-E6))
4 | ABC 99799758 | 2010-02-04 09:10:00 | Pending | 2010-02-04 09:20:00 | 2010-02-04 10:30:00 | No | No
5
6
7
8
9
10
Spreadsheet: 781013d1652943966-formula-to-sort-lowest-value-of-doublets-returning-criteria-aligw
Sheet: Ark1

 |  | Customer | Returning | Price
 |  | 56615 |  | 68.5
 |  | 153454 |  | 456
 |  | 6351351 |  | 15
 |  | 6468 |  | 95 | This should return single in A5, because it's the lowest price of the 2 on that customer
 |  | 635418564 |  | 541
 |  | 153513 |  | 15
 |  | 6548645 |  | 2123
 |  | 51356 |  | 61
 |  | 115 |  | 15461
 |  | 54561516 |  | 5641
 |  | 541561 |  | 5000 | Returning
 |  | 6468 |  | 750 | This should return single in A13, because it's 2 equal prices(750) and I only want 1 showing
 |  | 6468 |  | 750 | As long as just one is "Returning", this should work for you.
 |  | 879 |  | 81
 |  | 7545451 |  | 351
 |  | 4664 |  | 651
 |  | 8944 |  | 651
 |  | 84968964 |  | 1561
 |  | 541561 |  | 3000 | This should return single in A20, because it's the lowest price of the 2 on that customer
Spreadsheet: 793286d1661392467-sum-across-multiple-sheets-dsc-order-summary
Sheet: Product Summary

Product | Quantity
Rolled oats
Plain flour
desicated coconut
Caster sugar
[NAME]
butter
golden syrup
baking paper
baking tray
cellophane bags
sticky labels
Self-raising flour
vegetable oil
eggs
buttermilk
[NAME]
jam raspberry
unsalted butter
cinnamon
bran
breadcrumbs
wholemeal flour
low fat cheese slices
canola oil
wholemeal roll
mixed herbs
onion
carrot
parsley
tomatoes
lettuce
egg
parmesan cheese
cheese slices
burger buns
lemon juice
dill
[NAME]
white vinegar
salt
pepper
white fish fillets
flat leaf parsley
lettuce leaves
Sushi rice
sushi seasoning
avocado
nori seaweed sheets
cucumber
Kewpie Mayonnaise
soy sauce
[NAME]
minced garlic
chicken tenderloins
yeast
Milk
caster sugar
[NAME] sugar
cream
vanilla extract
sea salt
Rump steak
olive oil
oyster sauce
rice wine vinegar
red onion
broccoli
snow peas
red capsicum
zucchini
Hokkien noodles
minced ginger
beef stock
sweet chilli sauce
chicken mince
spring onion
hoi sin sauce
yeast
steamer
maple syrup
sesame oil
sesame seeds
paprika
chilli flakes
sweet potatoes
chicken wings
cabbage
capsicum
celery
Coleslaw dressing
French dressing
ricotta cheese
icing sugar
puff pastry sheets
apricot halves tinned
lemon juice
greek yoghurt
grated cheese
oregano fresh
thyme fresh
diced lamb
rolling pin small
paprika smoked
cream cheese
avocadoes
sliced white bread
corn [NAME]
food processor
grated mozzarella cheese
sunflower oil
sebago potatoes
bacon
Sour cream
chives
beef stock powder
spray oil
beef mince
muffin tray
egg for egg wash
outback tomato chutney
Smokey BBQ Sauce
salt and pepper
glad wrap
foil
tomato sauce to serve
rice paper sheets
lime juice
chinese cabbage
coriander fresh
mint fresh
crushed pineapple
strawberries
orange
kiwi fruit
baking trays
[NAME]
[NAME]
Spreadsheet: 865887d1712849435-advanced-filter-sample
Sheet: Source Data

Zone | Location | Name | Address | Status | Temp Address | Date
North | City | [NAME] | 123 Everywhere | Current | 987 There | 2024-01-13 00:00:00
South | City | [NAME] | 123 Everywhere | Current | 987 There
North | Rural | Adam | 123 Everywhere | Previous | 987 There | 2024-02-04 00:00:00
North | Rural | Brittany | 123 Everywhere | Current | 987 There
East | City | Carol | 123 Everywhere | Previous | 987 There | 2024-01-13 00:00:00
Spreadsheet: 3c8be800-59dc-4f4c-94d9-8cf7bc861c07
Sheet: Fig2A(main)

PropTimeOut_DAY3 | PropTimeOut_DAY4
0.5 | 0.313344595
0.309314 | 0.003248129
0.36172 | 0.339908519
0.057533 | 0.067181246
0.468527 | 0.844546235
0.107092 | 0.13701016
0.585588 | 0.253701016
0.046995 | 0
0.440046 | 0.458448753
0.524922 | 0.826367461
0.310738 | 0.330434783
0.504984 | 0.350843767
0.123042 | 0.214207948
0.300769 | 0.197094298
0.448875 | 0.102210663
0.095699 | 0.033795014
0 | 0.11719979
0.111934 | 0.030676455
0.167474 | 0.102707229
0.233837 | 0.100753558
0.161492 | 0.0496614
0.328112 | 0.066309255
0.534606 | 0.324539709
0.111934 | 0.180818906
0.187981 | 0.063505269
0.003418 | 0
0.235545 | 0.16050102
0.067502 | 0.015019115
0.090003 | 0.109141274
0.131017 | 0.062430939
0.091997 | 0.261666667
0.092851 | 0.190277778
0.07149 | 0.117581499
Spreadsheet: 813366d1673699038-formula-to-grouping-data-grouping-data
Sheet: Sheet1

 |  | abc | Amount
 |  | 1 a | 3000 |  |  | 3000
 |  | 1 a | 2000 |  |  | 2000
 |  | 2 a | 4000 |  | Sub Total | 5000
 |  | 2 a | 5000 |  | 2 a | 4000
 |  | 2 a | 6000 |  |  | 5000
 |  | 3 a | 7000 |  |  | 6000
 |  | 3 a | 8000 |  | Sub Total | 15000
 |  | 3 a | 9000 |  | 3 a | 7000
 |  | 3 a | 10000 |  |  | 8000
 |  | 3 a | 9000 |  |  | 9000
 |  |  |  |  |  | 10000
 |  |  |  |  |  | 9000
 |  |  |  |  | Sub Total | 43000
 |  |  |  |  | Grand Total | 63000
Spreadsheet: 765931d1643675051-formula-to-calculate-number-of-days-in-corresponding-month-year-excel-help-1
Sheet: Sheet5

2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022
January | February | March | April | May | June | July | August | September | October | November | December
 | I need a formula in each yellow cell that will return the number of days in the corresponding month (cell above) and year (cell above the month). And have it update depending on what year I put in Row 1
Spreadsheet: 729947d1619450561-use-formula-only-if-there-is-a-value-in-another-cell-example-forum
Sheet: Before

Result | CF
10
11
12
4
11
-
-
-
-
-
-