tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56d40267-65cb-43af-aa43-f910bcab45ba
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (16 Entries):
 | 8 Passive components 8.8 Piezoelectric components 8.8.1 Piezoelectric signal generators
No. | Company | Country | City | [NAME] | Hall/Booth
1 | CeramTec AG Electronic Applications Division | Germany | [NAME] | 95615 | B1.206
2 | CODICO GmbH | Austria | Perchtoldsdorf | 2380 | A5.507
3 | [NAME]Vertriebs GmbH | Germany | Nagold | 72202 | A5.138
4 | ESS GmbH | Germany | Norderstedt | 22846 | B6.346
5 | [NAME] | Germany | Ostfildern | 73760 | B6.124
6 | Micro Crystal AG | Switzerland | Grenchen | 2540 | A4.206
7 | Morgan Technical Ceramics Electroceramics | United Kingdom | Ruabon | [NAME] 6HY | B5.509
8 | M+R Multitronik GmbH | Germany | [NAME] | 23564 | B2.260
9 | N&H Technology GmbH | Germany | Willich | 47877 | B5.279
10 | NINGBO BEST GROUP CO., LTD. | China | Ningbo | 315040 | B6.536/10
11 | Sonitron N.V. | Belgium | Sint-Niklaas | 9100 | B2.260
12 | South China Electronics Co Ltd. | Hong Kong | Fo [NAME], N.T. |  | B6.463/5
13 | SUMIDA Components GmbH | Germany | Neumarkt | 92318 | B5.325
14 | TDK Electronics Europe GmbH | Germany | [NAME] | 40472 | B5.506
15 | Vectron International Hudson | USA | Hudson | NH 03051 | B5.237
16 | Vectron International Mt. Holly Springs | USA | Mt. Holly Springs | PA 17065 | B5.237
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: info for DPR

 | Links |  |  |  | Values
 | Date |  |  |  | Date
 | Var |  |  |  | Var
 | Notional |  |  |  | Notional
 | Daily P&L |  |  |  | Daily P&L
 | QTD |  |  |  | QTD
 | YTD |  |  |  | YTD
 | the ENE position.  This caused most of the $3.8mm gain.
Spreadsheet: 682071d1591893321-reduce-data-held-in-3-columns-to-2-columns-testfile3
Sheet: Sheet1

 |  | JAN |  |  | FEB |  |  | MAR
 |  | GEN | LAB | TAP | GEN | LAB | TAP | GEN | LAB | TAP
 |  | 1000 | 0 | 0 | 1243 | 0 | 0 | 2179 | 0 | 0
 |  | 1 |  | 3 | 4 |  | 6 | 7 |  | 9
 |  | 0 |  | 2 | 0 |  | 2 | 0 |  | 2
Spreadsheet: 142332d1329775761-npv-formula-with-positive-cash-flow-before-an-initial-outlay-npv-question-v2
Sheet: Sheet1

 | Rate | 0.2 |  | Rate | 0.2
 | NPV |  |  | NPV
 | Date | Cash Flows |  | Date | Cash Flows
 | 2011-02-01 00:00:00 | 27500 |  | 2011-02-01 00:00:00 | 27500
 | 2011-03-01 00:00:00 | 0 |  | 2011-03-01 00:00:00 | 0
 | 2011-04-01 00:00:00 | 0 |  | 2011-04-01 00:00:00 | 0
 | 2011-05-01 00:00:00 | -1157859 |  | 2011-05-01 00:00:00 | -1157859
 | 2011-06-01 00:00:00 | -15799 |  | 2011-06-01 00:00:00 | -15799
 | 2011-07-01 00:00:00 | 0 |  | 2011-07-01 00:00:00 | 0
 | 2011-08-01 00:00:00 | 0 |  | 2011-08-01 00:00:00 | 0
 | 2011-09-01 00:00:00 | 9534.805186923162 |  | 2011-09-01 00:00:00 | 9534.805186923162
 | 2011-10-01 00:00:00 | 10151.86912618949 |  | 2011-10-01 00:00:00 | 10151.86912618949
 | 2011-11-01 00:00:00 | 10048.66338887612 |  | 2011-11-01 00:00:00 | 10048.66338887612
 | 2011-12-01 00:00:00 | 7080.572420636153 |  | 2011-12-01 00:00:00 | 7080.572420636153
 | 2012-01-01 00:00:00 | 10984.67120031488 |  | 2012-01-01 00:00:00 | 10984.67120031488
 | 2012-02-01 00:00:00 | 12409.3549720021 |  | 2012-02-01 00:00:00 | 12409.3549720021
 | 2012-03-01 00:00:00 | 10961.1043951709 |  | 2012-03-01 00:00:00 | 10961.1043951709
 | 2012-04-01 00:00:00 | 11694.35976257058 |  | 2012-04-01 00:00:00 | 11694.35976257058
 | 2012-05-01 00:00:00 | 12496.59183435658 |  | 2012-05-01 00:00:00 | 12496.59183435658
 | 2012-06-01 00:00:00 | 12071.21660116701 |  | 2012-06-01 00:00:00 | 12071.21660116701
 | 2012-07-01 00:00:00 | 12654.01540906436 |  | 2012-07-01 00:00:00 | 12654.01540906436
 | 2012-08-01 00:00:00 | 12892.95283849709 |  | 2012-08-01 00:00:00 | 12892.95283849709
 | 2012-09-01 00:00:00 | 13451.98374578584 |  | 2012-09-01 00:00:00 | 13451.98374578584
 | 2012-10-01 00:00:00 | 13253.14132817025 |  | 2012-10-01 00:00:00 | 13253.14132817025
 | 2012-11-01 00:00:00 | 13171.12969859307 |  | 2012-11-01 00:00:00 | 13171.12969859307
 | 2012-12-01 00:00:00 | 10965.40799845733 |  | 2012-12-01 00:00:00 | 10965.40799845733
 | 2013-01-01 00:00:00 | 14539.69980907964 |  | 2013-01-01 00:00:00 | 14539.69980907964
 | 2013-02-01 00:00:00 | 14530.34146026005 |  | 2013-02-01 00:00:00 | 14530.34146026005
 | 2013-03-01 00:00:00 | 14514.68836852685 |  | 2013-03-01 00:00:00 | 14514.68836852685
 | 2013-04-01 00:00:00 | 2804095.929105625 |  | 2013-04-01 00:00:00 | 2804095.929105625
Spreadsheet: 217724d1362159564-pulling-date-from-9-sheets-to-be-displayed-on-front-sheet-packet-list
Sheet: Collections

Courier Collections
 | Collection Date | 2013-02-27 00:00:00 | - | 2013-02-28 00:00:00 |  |  | 2013-03-01 00:00:00
Total number of Collections | [NAME] | Magnum | TNT Post | TNT UK | Dachser | Returns | Delivery | Showroom | Store
 | Packing No. | Packing No. | Packing No. | Packing No. | Packing No. | Packing No. | Packing No. | Packing No. | Packing No.
1 | 5245
2 | 4928
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 87605d1287496089-cross-referencing-formula-to-leave-the-cell-blank-until-its-ready-to-be-populated-dummy
Sheet: Sheet2

Product Code Number/Catalogue Number | Multi Language Tag sheet [NAME]?    Y/N? | Comments
466514346 | 0
845645 | Y
64642168 | Y
514657675 | 0
14599988 | 0
12366558 | 0
123456 | 0
Yes "Y" | 2
To [NAME] (blank cell) | 0 |  | The formula states "0", and I want a blank cell to show the same as sheet 1 as in cell I8
% Completed | 1
Spreadsheet: 877317d1724107754-formula-to-remove-names-w-unique-names-formula-to-remove-names-w-unique-names-v2
Sheet: Sheet1

Name | First Name | Last Name | Note
[NAME], [NAME] |  |  | Need John in B2 and [NAME] in C2
Doe, [NAME] |  |  | [NAME] in B3 and Doe in C3
Brown, [NAME] |  |  | Need Al Amour in B4 and [NAME] in C4
Smith-Jones, [NAME] |  |  | [NAME] in B5 and Smith-Jones in C5
 |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | q
Spreadsheet: 34d114c4-482f-43dc-80d8-c9d2989f11cb
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: Construction Spending
 |  | Annual Rate for Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: April 20, 2014 (9:36 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002 | 858654 | 862338 | 844551 | 858240 | 850935 | 846777 | 847129 | 839008 | 832134 | 839690 | 844697 | 855921
2003 | 863855 | 859225 | 851132 | 859459 | 866814 | 880865 | 891264 | 901839 | 911589 | 925732 | 925985 | 948491
2004 | 938826 | 938656 | 960946 | 967761 | 974158 | 983072 | 1006119 | 1013724 | 1012290 | 1015562 | 1023210 | 1037684
2005 | 1036187 | 1056492 | 1065262 | 1058365 | 1078586 | 1089505 | 1109691 | 1119782 | 1131739 | 1145663 | 1156977 | 1178305
2006 | 1183861 | 1199767 | 1213270 | 1183485 | 1180059 | 1172932 | 1165093 | 1158193 | 1151104 | 1139292 | 1137488 | 1153491
2007 | 1149899 | 1156008 | 1167402 | 1159124 | 1168195 | 1166892 | 1154018 | 1160593 | 1165162 | 1152511 | 1127558 | 1108958
2008 | 1106047 | 1092331 | 1094910 | 1091142 | 1091008 | 1074637 | 1066919 | 1057459 | 1056666 | 1050690 | 1029211 | 993515
2009 | 962704 | 959907 | 954984 | 929593 | 911241 | 901987 | 899601 | 889643 | 880259 | 869374 | 850732 | 832565
2010 | 816132 | 795808 | 805985 | 824008 | 816318 | 816302 | 788524 | 791653 | 798916 | 800266 | 798328 | 779895
2011 | 757039 | 754169 | 763058 | 772204 | 773764 | 797080 | 789297 | 801196 | 805519 | 806514 | 809089 | 817569
2012 | 817616 | 823331 | 826641 | 833243 | 844709 | 855779 | 856348 | 854048 | 873259 | 863065 | 882685 | 883550
Spreadsheet: 775121d1648826366-calculation-incorrect-when-multiplying-multiple-cells-excel-help
Sheet: Sheet1 (3)

Water Plant TSS Data (1st quarter)
Date Sampled |  | TSS (mg/L |  | Flow Reading
2022-01-03 00:00:00 |  | 660 |  | 2022-01-05 00:00:00 | 632043000
2022-01-04 00:00:00 |  | 1110 |  | 2022-01-12 00:00:00 | 633137000
2022-01-05 00:00:00 |  | 920 |  | 2022-01-19 00:00:00 | 634460000
2022-01-10 00:00:00 |  | 170 |  | 2022-01-26 00:00:00 | 635726000
2022-01-11 00:00:00 |  | 210 |  | 2022-02-02 00:00:00 | 636591000
2022-01-12 00:00:00 |  | 310 |  | 2022-02-09 00:00:00 | 637651000
2022-01-18 00:00:00 |  | 670 |  | 2022-02-16 00:00:00 | 638706000
2022-01-19 00:00:00 |  | 2590 |  | 2022-02-23 00:00:00 | 639501000
2022-01-20 00:00:00 |  | 1460 |  | 2022-03-02 00:00:00 | 640618000
2022-01-24 00:00:00 |  | 520 |  | 2022-03-09 00:00:00 | 641708000
2022-01-25 00:00:00 |  | 380 |  | 2022-03-16 00:00:00 | 642773000
2022-01-26 00:00:00 |  | 290 |  | 2022-03-23 00:00:00 | 643849000
2022-01-31 00:00:00 |  | 190 |  | 2022-03-30 00:00:00 | 644970000
2022-02-01 00:00:00 |  | 270
2022-02-02 00:00:00 |  | 130 |  | Quarterly Flow Total:
2022-02-07 00:00:00 |  | 1520
2022-02-08 00:00:00 |  | 660
2022-02-09 00:00:00 |  | 620
2022-02-14 00:00:00 |  | 270
2022-02-15 00:00:00 |  | 230
2022-02-16 00:00:00 |  | 140
2022-02-22 00:00:00 |  | 660
2022-02-23 00:00:00 |  | 510
2022-02-24 00:00:00 |  | 320
2022-02-28 00:00:00 |  | 910
2022-03-01 00:00:00 |  | 380
2022-03-02 00:00:00 |  | 440
2022-03-07 00:00:00 |  | 380
2022-03-08 00:00:00 |  | 360
2022-03-09 00:00:00 |  | 440
2022-03-14 00:00:00 |  | 450
2022-03-15 00:00:00 |  | 770
2022-03-16 00:00:00 |  | 480
2022-03-21 00:00:00 |  | 570
2022-03-22 00:00:00 |  | 430
2022-03-23 00:00:00 |  | 340
2022-03-28 00:00:00 |  | 440
2022-03-29 00:00:00 |  | 560
2022-03-30 00:00:00 |  | 540
[NAME]: |  | 572
Surcharge: |  | Monthly Avg-250 |  | Quarterly Flow | Price/lb. | Total
 |  |  | 8.34 |  | 0.3
Spreadsheet: 02b6bd8b-97cd-4a16-942a-15ec494cdac4
Sheet: Scl Lvrs

 | Elementary | Intermediate | Advanced
1995 | 37 | 27.2 | 14.1
1996 | 37 | 26.9 | 13.5
1997 | 39 | 27.1 | 13.5
1998 | 39 | 26.1 | 12.7
1999 | 41 | 25.1 | 12.3
2000 | 47 | 25 | 11.9
2001 | 45 | 24.2 | 11.3
2002 | 46 | 23.4 | 11.1
2003 | 47 | 23.5 | 11.8
2004 | 46 | 22.6 | 11.7
2005 | 47 | 22 | 11.3
2006 | 48 | 21.9 | 10.7
2007 | 48 | 21.2 | 10.3
From a report for Australian Mathematical Sciences Institute & International Centre of Excellence for Education in Mathematics 2008
National strategy for Mathematical Science in Australia
[NAME]
Department of Mathematics and Statistics
The University of Melbourne
Victoria 3010 AUSTRALIA
[EMAIL]
Spreadsheet: phillip_m_love__30531__CustomerList
Sheet: ENA Upstream

 | [NAME] |  |  | [NAME]
SAP ID | [NAME] |  | SAP ID | [NAME]
3000003498 | Ashland Chemical Company |  | 3000006600 | Cabot Oil & Gas Marketing Corporation
3000007639 | Aquila Energy Marketing Corporation |  | 3000013388 | Camerick Gas Processing Company, LLC
3000005093 | Aspect Resources, LLC |  | 3000014533 | Century Exploration Company
3000009018 | ATP Oil & Gas Corporation |  | 3000013343 | Continental Land & Fur Co., Inc.
3000002116 | Aviara Energy Corporation |  | 3000007641 | Coral Energy Resources, LP
3000015171 | Brazos VPP Limited Partnership |  | 3000006379 | Crosstex Energy Services, Ltd.
3000002543 | Devon Energy Corporation |  | 3000007886 | Dynegy Marketing and Trade
3000012865 | Devon Energy Production Company, LP |  | 3000017800 | El Paso Merchant Energy, LP
3000018704 | Devon SFS Operating, Inc. |  | 3000013908 | Fairways Offshore Exploration, Inc.
3000018841 | Duke Energy Trading and Marketing, LLC |  | 3000015408 | Flextrend Development Company, LLC
3000011867 | EEX E&P Company, LP |  | 3000018331 | Forest Oil Corporation
3000002064 | Energy Resource Technology, Inc. |  | 3000014551 | Grand Goldking LLC
3000010794 | Enterprise Oil Louisiana Inc. |  | 3000012388 | Hassie Hunt Exploration Company
3000014816 | EXCO Resources, Inc. |  | 3000001605 | Hunt Petroleum Corporation
3000011278 | Nexen Petroleum Sales USA, Inc. |  | 3000012381 | Hydrocarbon Lease Management, Inc.
3000007990 | North Central Oil Corporation |  | 3000012004 | Juniper Energy, LP
3000014584 | Orion Pipeline, LLC |  | 3000018847 | KCS Energy Marketing Inc.
3000007626 | Pioneer Natural Resources USA, Inc. |  | 3000018433 | KCS Energy Service Inc.
3000019315 | Reliant Energy Services, Inc. |  | 3000011832 | KCS Medallion Resources, Inc.
3000000073 | Samedan Oil Corporation |  | 3000001812 | KCS Resources Inc.
3000004732 | Shoreline Gas Inc. |  | 3000000827 | Linder Oil Company, a Partnership
3000010515 | Spinnaker Exploration Company, LLC |  | 3000006098 | Louis Dreyfus Natural Gas Corp.
3000014612 | [NAME] Production, LLC |  | 3000015529 | Magnum Hunter Production, Inc.
3000018363 | TDC Energy Corporation |  | 3000005276 | Mariner Energy, Inc.
3000013396 | Texoma Trading, LLC |  | 3000012458 | Matrix Gas Corporation
3000011107 | Tolar Corporation |  | 3000006364 | Matrix Oil & Gas, Inc.
3000010558 | TotalFinaElf Gas & Power North America |  | 3000011550 | Mayne & Mertz, Inc.
3000011545 | W&T Offshore, Inc. |  | 3000003739 | Mid-Continent Energy, Inc.
3000015517 | Westport Oil & Gas Company, Inc. |  | 3000014584 | Orion Pipeline LLC
3000008001 | Wilmar Pipelines, Inc. |  | 3000001657 | Phoenix Gas Pipeline Company
 |  |  | 3000012992 | ProGas, Inc.
 | Currently ALL SALES Invoices |  | 3000000073 | Samedan Oil Corporation
 |  |  | 3000004732 | Shoreline Gas Inc.
 |  |  | 3000015888 | Star VPP, LP
 |  |  | 3000003869 | Stone Energy Corporation
 |  |  | 3000014541 | Transworld Exploration & Production, Inc.
 |  |  | 3000003371 | Tristar Gas Marketing Company
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0113

 | Date: | 2013-01-13 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 7 | 33.13
 | 11:00:00 | 34 | 306.9
 | 12:00:00 | 43 | 354.85
 | 13:00:00 | 47 | 323.38
 | 14:00:00 | 33 | 234.12
 | 15:00:00 | 29 | 184.6
 | 16:00:00 | 23 | 145.29
 | 17:00:00 | 44 | 450.54
 | 18:00:00 | 37 | 263.54
 | 19:00:00 | 26 | 189.38
 | 20:00:00 | 13 | 117.06
 | 21:00:00 | 20 | 155.28
 | 22:00:00 | 14 | 72.2
 | 23:00:00 | 11 | 81.36
 | 1900-01-01 00:00:00 | 8 | 59.42
 | 1900-01-01 01:00:00 | 1 | 4.67
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 679817d1590647804-date-cell-for-a-max-and-min-value-suppot
Sheet: Sheet1

Date |  | Units | Unit value | Total value
2019-05-25 00:00:00 |  | 1000 | 1.54 |  |  | Highest Unit Value | Lowest  Unit Value
2019-05-26 00:00:00 |  | 1000 | 1.64
2019-05-27 00:00:00 |  | 1000 | 1.55
2019-05-28 00:00:00 |  | 1000 | 1.65
2019-05-29 00:00:00 |  | 1000 | 1.64
2019-05-30 00:00:00 |  | 1000 | 1.56
2019-05-31 00:00:00 |  | 1000 | 1.72
2019-06-01 00:00:00 |  | 1000 | 1.7
Spreadsheet: e4730fed-aab2-4407-8b48-1c744ed8f8f4
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998418228 | Butler & The Fountain Boys | Stepping Up & Stepping Out | 2009-08-25 | Compact Disc | Gospel | 15.99 | Y | Available
Spreadsheet: 790960d1660078256-look-up-tool-calc-x
Sheet: Master Calculator

 |  |  |  | 0-14999 | 10
 |  |  |  | 15-20 | 15
 |  |  |  | 20+ | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30% is ideal |  |  |  |  | plus comms at |  |  |  | total |  |  |  | Whats left
 |  |  |  |  |  |  | Billings |  | Commision Paid Per Year @ |  |  | OTE |  |  | % of billings |  |  |  | 0.181 | 10 | 20 | 30 |  | 10 | 20 | 30 |  | 10 | 20 | 30
Basic |  | Days Per Week | Runners | Days Average | Margin Average | Per Week | Per 4 Week Average | Per Year | 0.1 | 0.15 | 0.2 | 0.1 | 0.2 | 0.3 | 0.1 | 0.2 | 0.3 |  | [NAME] cost to us True cost to us
25000 | Trainee | 5 |  | 25 | 50
28000 | Junior | 5 |  | 50 | 50
32500 | Consultant | 5 |  | 100 | 50
35000 | Consultant 2 | 5 |  | 150 | 50
40000 | Consultant 3 | 5 |  | 200 | 50
45000 | Consultant 3 | 5 |  | 250 | 50
50000 | Principal | 5 |  | 300 | 50
65000 | Partner | 5 |  | 500 | 50
For them… |  |  | Average Days |  |  |  | (4 weeks)
Basic |  |  | Runners | Days | Margin | GP Week | GP Month | GP Year
28000 |  | 5 |  | 50 | 50
 |  |  |  | *Input | *Input
Commision
 |  |  | True cost | GP for the business
OTE | Per Month
Rate | Range | Rate Diff | Amount
0.1 | 0 | 0.1
0.15 | 14999
0.2 | 19999
See …
http://www.mcgimpsey.com/excel/variablerate.html
Spreadsheet: 773353d1647807115-count-unique-but-ignore-results-containing-specific-text-sample-visit-count
Sheet: Sheet1

 |  |  |  | Manual | [NAME]
 |  |  | Total Unique Clients | 5
 |  |  | Total Companies with at least 1 contact visit | 3 | ?
 |  |  | Total Companies with no contact visits | 2 | ?
 | Company | Rep | Contact | Visit Type | Helper Column |  |  | Visit Type Lilst
 | ABC | [NAME] | [NAME] | Lunch |  |  |  | Lunch
 | ABC | [NAME] | [NAME] |  |  |  |  | Dinner
 | ABC | [NAME] | [NAME] | Dinner |  |  |  | Breakfast
 | ABC | [NAME] | [NAME] | No Visit |  |  |  | Golf
 | XYZ | [NAME] | [NAME] |  |  |  |  | Coffee
 | XYZ | [NAME] | [NAME] | No Visit |  |  |  | No Visit
 | XYZ | [NAME] | [NAME] | No Visit
 | [NAME] | [NAME] | [NAME] | Golf
 | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | Breakfast
 | [NAME] | [NAME] | [NAME] | Lunch
 | [NAME] | [NAME] | [NAME] | No Visit
 | [NAME] | [NAME] | [NAME] | No Visit
 | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | No Visit
 | [NAME] | [NAME] | [NAME] | No Visit
 | [NAME] | [NAME] | [NAME] | No Visit
 | Creekside | [NAME] | [NAME] | Dinner
 | Creekside | [NAME] | [NAME] | Coffee
 | Creekside | [NAME] | [NAME] | Dinner
 | Creekside | [NAME] | [NAME]
 | Creekside | [NAME] | Gretchen Spring | Golf
Spreadsheet: 716918d1612423034-count-the-ordered-frequency-sequence-of-0-and-1-test
Sheet: Tabelle1

 |  |  |  |  |  | January | Februari | Mars | April | Maj | Juni | [NAME] | Augusti | September | Oktober | November | December |  | Preffered Output
 |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  |  | 3 | 6 | 1
 |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  |  | 6 | 5
 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |  |  | 5 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 3
Spreadsheet: f382cc0a-155b-41a9-ad09-b4d443bdbd84
Sheet: weight_calc

 | NB: All Dimensions must be in [NAME] (millimetres)
 |  | An average density factor has been used therefore all weights are approximate only
 | Enter the measurement for the dimension(s) shown on the pictures to the left, in the yellow boxes.
 |  |  |  | The result will appear on the right.
 | Round Bar
 |  |  |  | Diameter |  |  |  | Kgs/Meter
 |  |  | Stainless
 |  |  | Brass
 |  |  | Copper
 |  |  | Aluminium
 | Hexagonal Bar
 |  |  |  | A/F (across flat) |  |  |  | Kgs/Meter
 |  |  | Stainless
 |  |  | Brass
 |  |  | Copper
 |  |  | Aluminium
 | Octagonal Bar
 |  |  |  | A/F (across flat) |  |  |  | Kgs/Meter
 |  |  | Brass
 |  |  | Copper
 | Square & Flat Bar
 |  |  |  | W (width) |  | T (thickness) |  | Kgs/Meter
 |  |  | Stainless
 |  |  | Brass
 |  |  | Copper
 |  |  | Aluminium
 | Tube
 |  |  |  | OD (outside [NAME]) |  | WT (wall thickness) |  | Kgs/Meter
 |  |  | Stainless
 |  |  | Brass
 |  |  | Copper
 |  |  | Aluminium
 | Strip, Sheet, Plate
 |  |  |  | T (thickness) |  |  |  | Kgs/Sq Meter
 |  |  | Stainless
 |  |  | Brass
 |  |  | Copper
 |  |  | Aluminium
Spreadsheet: 03626d4f-06a4-4a72-99e2-cca90d10c727
Sheet: Sheet1

参考表　　  主 要 国 の 消 費 者 物 価 指 数 変 化 率 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Reference Table 　 Rates of Change in Consumer Price Index of Principal Countries
 |  |  |  |  |  |  |  | 前年(同月)比 (％)
 |  |  |  |  |  |  |  | Change over the year in ％
 |  |  |  | 1） |  |  | 2）
 | 日　本 | アメリカ | カ ナ ダ | イギリス | ド イ ツ | フランス | イタリア | 中  国 | 韓 　国 | Year
年　月 |  |  |  |  |  |  |  | People's   Rep. of   China |  | and
 | Japan | United 　 States | Canada | United 　 Kingdom | Fed. Rep. 　of Germany | France | Italy |  | Rep. of 　 Korea | month
平成14年平均 | -0.9 | 1.6 | 2.2 | 1.7 | 1.5 | 1.9 | 2.5 | -0.8 | 2.8 | 2002
15 | -0.3 | 2.3 | 2.8 | 2.9 | 1 | 2.1 | 2.6 | 1.2 | 3.5 | 2003
16 | 0 | 2.7 | 1.8 | 3 | 1.7 | 2.1 | 2.1 | 3.9 | 3.6 | 2004
17 | -0.3 | 3.4 | 2.2 | 2.8 | 1.5 | 1.8 | 1.8 | 1.8 | 2.8 | 2005
18 | 0.3 | 3.2 | 2 | 3.2 | 1.6 | 1.6 | 2.1 | 1.5 | 2.2 | 2006
19 | 0 | 2.8 | 2.2 | 4.3 | 2.3 | 1.5 | 1.9 | 4.8 | 2.5 | 2007
20 | 1.4 | 3.8 | 2.3 | 4 | 2.6 | 2.8 | 3.3 | 5.9 | 4.7 | 2008
平成19年 8月 | -0.2 | 2 | 1.7 | 4.1 | 2.2 | 1.2 | 1.6 | 6.5 | 2 | Aug. 2007
9 | -0.2 | 2.8 | 2.5 | 3.9 | 2.7 | 1.5 | 1.6 | 6.2 | 2.3 | Sep.
10 | 0.3 | 3.5 | 2.4 | 4.2 | 2.8 | 2 | 2.2 | 6.5 | 3 | Oct.
11 | 0.6 | 4.3 | 2.5 | 4.3 | 3.2 | 2.4 | 2.4 | 6.9 | 3.5 | Nov.
12 | 0.7 | 4.1 | 2.4 | 4 | 3.1 | 2.6 | 2.6 | 6.5 | 3.6 | Dec.
平成20年 1月 | 0.7 | 4.3 | 2.2 | 4.1 | 2.8 | 2.8 | 2.9 | 7.1 | 3.9 | Jan. 2008
2 | 1 | 4 | 1.8 | 4.1 | 2.8 | 2.8 | 2.8 | 8.7 | 3.6 | Feb.
3 | 1.2 | 4 | 1.4 | 3.8 | 3.1 | 3.2 | 3.3 | 8.3 | 3.9 | Mar.
4 | 0.8 | 3.9 | 1.7 | 4.2 | 2.4 | 3 | 3.3 | 8.5 | 4.1 | Apr.
5 | 1.3 | 4.2 | 2.2 | 4.3 | 3 | 3.3 | 3.6 | 7.7 | 4.9 | May
6 | 2 | 5 | 3.1 | 4.6 | 3.3 | 3.6 | 3.9 | 7.1 | 5.5 | June
7 | 2.3 | 5.6 | 3.4 | 5 | 3.3 | 3.6 | 4 | 6.3 | 5.9 | July
8 | 2.1 | 5.4 | 3.5 | 4.8 | 3.1 | 3.2 | 4 | 4.9 | 5.6 | Aug.
9 | 2.1 | 4.9 | 3.4 | 5 | 2.9 | 3 | 3.7 | 4.6 | 5.1 | Sep.
10 | 1.7 | 3.7 | 2.6 | 4.2 | 2.4 | 2.7 | 3.4 | 4 | 4.8 | Oct.
11 | 1 | 1.1 | 2 | 3 | 1.4 | 1.6 | 2.6 | 2.4 | 4.5 | Nov.
12 | 0.4 | 0.1 | 1.2 | 0.9 | 1.1 | 1 | 2.2 | 1.2 | 4.1 | Dec.
平成21年 1月 | 0 | 0 | 1.1 | 0.1 | 0.9 | 0.7 | 1.6 | 1 | 3.7 | Jan. 2009
2 | -0.1 | 0.2 | 1.4 | 0 | 1 | 0.9 | 1.6 | -1.6 | 4.1 | Feb.
3 | -0.3 | -0.4 | 1.2 | -0.4 | 0.5 | 0.3 | 1.1 | -1.2 | 3.9 | Mar.
4 | -0.1 | -0.7 | 0.4 | -1.2 | 0.7 | 0.1 | 1.1 | -1.5 | 3.6 | Apr.
5 | -1.1 | -1.3 | 0.1 | -1.1 | 0 | -0.3 | 0.7 | -1.4 | 2.7 | May
6 | -1.8 | -1.4 | -0.3 | -1.6 | 0.1 | -0.5 | 0.4 | -1.7 | 2 | June
7 | -2.2 | -2.1 | -0.9 | -1.4 | -0.5 | -0.7 | 0 | -1.8 | 1.6 | July
1）　小売物価指数 |  | Retail Price Index
2）  たばこを除く総合 |  | Excluding Tobacco