tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 76854d1277330718-lookup-tersterror
Sheet: tblHistory1

EIN | TypeCode | CourseCompletionCodeID | CompletionDate | DurationHours | CourseID | LastName | FirstName | MiddleInitial | CreatedBy | CourseTitle
100507377 | S | COMPLETD | 2006-12-20 00:00:00 | 4 | 25780
100507377 | S | COMPLETD | 2006-09-19 00:00:00 | 1 | 33827
100507377 | S | COMPLETD | 2006-09-19 00:00:00 | 1 | 35091
100783190 | S | COMPLETD | 2006-08-08 00:00:00 | 1 | 35091
100864232 | S | COMPLETD | 2006-12-22 00:00:00 | 8 | 18566
100864232 | S | COMPLETD | 2006-10-02 00:00:00 | 1 | 33827
100864232 | S | COMPLETD | 2006-10-02 00:00:00 | 1 | 35091
101793350 | S | COMPLETD | 1998-12-07 00:00:00 | 4 | 3916
101793350 | S | COMPLETD | 1998-07-29 00:00:00 | 1 | 6400
101793350 | S | COMPLETD | 1999-02-12 00:00:00 | 1 | 6400
101793350 | S | COMPLETD | 2000-12-04 00:00:00 | 1 | 11233
101793350 | S | COMPLETD | 1998-12-07 00:00:00 | 1 | 12765
101793350 | S | COMPLETD | 1999-07-16 00:00:00 | 40 | 13007
101793350 | S | COMPLETD | 1999-02-11 00:00:00 | 1 | 13132
101793350 | S | COMPLETD | 1999-08-31 00:00:00 | 1 | 13132
101793350 | S | COMPLETD | 1998-12-08 00:00:00 | 4 | 14131
101793350 | S | COMPLETD | 1999-07-16 00:00:00 | 8 | 14229
101793350 | S | COMPLETD | 1999-03-23 00:00:00 | 1 | 15858
101793350 | S | COMPLETD | 1999-05-11 00:00:00 | 1 | 16048
101793350 | S | COMPLETD | 1999-06-15 00:00:00 | 1 | 16049
Spreadsheet: 700468d1603201782-countifs-with-date-between-formula-sip-plan-excelforum
Sheet: Site

 |  |  |  |  |  |  | High | Intermediate | Low |  | Total Proj Cost Open
 | Total Actions Open |  |  | Open Actions/Tasks
 | Total Actions closed |  |  | Closed Actions/Tasks
Action raised (date) | Raised by | Assigned Owner | Details (outline task to do) | Improvemnet area | Findings/Source of change | Task/Action | Priority/Risk | Action Source | Projected cost | Accepted/Rejected | Accepted/Rejected by? | Rejected Reason | Days Remaining | Due by | Status | Completed date | Verified by? | PO No.
2020-09-27 00:00:00 | LT | [NAME] | example 1 | Transport | Bridge strike it was discovered we had no way of knowing precise heights of vehicle | Buy measuring poles x 2 | High | PIP MH | 300 | Accepted | BM | N/A |  | 2020-10-15 00:00:00 |  | 2020-10-20 00:00:00
2020-09-30 00:00:00 | [NAME] | [NAME] | example 2 | Systems |  |  | Intermediate | PIP MH | 0 | Accepted | [NAME] | Don’t like it |  | 2020-10-29 00:00:00
2020-10-14 00:00:00 | [NAME] | [NAME] | example 3 | FM |  |  | Intermediate | PIP RR | 5000 | Accepted | [NAME] | N/A |  | 2020-12-21 00:00:00
2020-10-17 00:00:00 | LT | Joel | example 4 | Operations |  |  | Intermediate | PIP RR | 3000 | Accepted | [NAME] | ok |  | 2020-11-13 00:00:00 |  | 2020-12-15 00:00:00
2020-10-26 00:00:00 | [NAME] | [NAME] | example 5 | Transport |  |  | High | PIP WPT | 250 | Rejected | Billy | ok |  | 2020-12-12 00:00:00
2020-10-12 00:00:00 | [NAME] | [NAME] | example 6 | PIP WPT |  |  | Intermediate | [NAME] | 450 | Accepted | [NAME] | PIP Action |  | 2020-12-12 00:00:00
2020-10-15 00:00:00 | TV | [NAME] | example 7 | Transport |  |  | Low | Incident | 500 | Accepted | [NAME] | N/A |  | 2020-10-18 00:00:00 |  | 2020-10-20 00:00:00
Spreadsheet: 55472aba-12c6-47f0-89cb-02fc2c8ea4f1
Sheet: 2013 Sales

Vehicle Sales BMW of North America, LLC, November 2013
 | Nov. 2013 | Nov. 2012 | % | YTD Nov. 2013 | YTD Nov. 2012 | %
1 Series | 699 | 619 |  | 6181 | 6932
3/4 Series | 13148 | 10776 |  | 102784 | 88857
Z4 | 162 | 229 |  | 2289 | 2427
5 Series | 5060 | 5857 |  | 48761 | 48413
6 Series | 729 | 919 |  | 8684 | 7171
7 Series | 617 | 939 |  | 9813 | 9676
X1 | 2364 | 2088 |  | 23771 | 6141
BMW passenger cars
X3 | 4032 | 4172 |  | 26916 | 30011
X5 | 4445 | 4801 |  | 37865 | 38723
X6 | 496 | 813 |  | 4827 | 5710
BMW light trucks
BMW brand
Cooper /S Hardtop | 1727 | 2490 |  | 23959 | 26267
Cooper /S Convertible | 252 | 325 |  | 4198 | 4488
Cooper /S Clubman | 330 | 480 |  | 4776 | 5324
Coupe | 91 | 149 |  | 2423 | 2702
Roadster | 109 | 196 |  | 2672 | 2098
Countryman | 1435 | 1608 |  | 19270 | 18788
Paceman | 631 | 0 | N/A | 2612 | 0 | N/A
MINI brand
TOTAL BMW of North America, LLC
Spreadsheet: 114042d1309910297-formula-to-create-a-random-date-essay-practice-schedule
Sheet: Sheet1

Exam / Year / Question | Test | Date
July 2001 / 1 |  | 2011-07-11 00:00:00
July 2001 / 2 |  | 2011-07-11 00:00:00
July 2001 / 3 |  | 2011-07-11 00:00:00
July 2001 / 4 |  | 2012-07-12 00:00:00
July 2001 / 5 |  | 2012-07-12 00:00:00
July 2001 / 6 |  | 2012-07-12 00:00:00
Feb 2002 / 1 |  | 2011-07-13 00:00:00
Feb 2002 / 2 |  | 2011-07-13 00:00:00
Feb 2002 / 3 |  | 2011-07-13 00:00:00
Feb 2002 / 4 |  | 2011-07-14 00:00:00
Feb 2002 / 5 |  | 2011-07-14 00:00:00
Feb 2002 / 6 |  | 2011-07-14 00:00:00
July 2002 / 1 |  | 2011-07-15 00:00:00
July 2002 / 2 |  | 2011-07-15 00:00:00
July 2002 / 3 |  | 2011-07-15 00:00:00
July 2002 / 4 |  | 2011-07-16 00:00:00
July 2002 / 5 |  | 2011-07-16 00:00:00
July 2002 / 6 |  | 2011-07-16 00:00:00
July 2003 / 1 |  | 2011-07-17 00:00:00
July 2003 / 2 |  | 2011-07-17 00:00:00
July 2003 / 3 |  | 2011-07-17 00:00:00
July 2003 / 4 |  | 2011-07-18 00:00:00
July 2003 / 5 |  | 2011-07-18 00:00:00
July 2003 / 6 |  | 2011-07-18 00:00:00
Feb 2004 / 1 |  | 2011-07-19 00:00:00
Feb 2004 / 2 |  | 2011-07-19 00:00:00
Feb 2004 / 3 |  | 2011-07-19 00:00:00
Feb 2004 / 4 |  | 2011-07-20 00:00:00
Feb 2004 / 5 |  | 2011-07-20 00:00:00
Feb 2004 / 6 |  | 2011-07-20 00:00:00
July 2004 / 1 |  | 2011-07-21 00:00:00
July 2004 / 2 |  | 2011-07-21 00:00:00
July 2004 / 3 |  | 2011-07-21 00:00:00
July 2004 / 4 |  | 2011-07-22 00:00:00
July 2004 / 5 |  | 2011-07-22 00:00:00
July 2004 / 6 |  | 2011-07-22 00:00:00
Feb 2005 / 1 |  | 2011-07-23 00:00:00
Feb 2005 / 2 |  | 2011-07-23 00:00:00
Feb 2005 / 3 |  | 2011-07-23 00:00:00
Feb 2005 / 4 |  | 2011-07-24 00:00:00
Feb 2005 / 5 |  | 2011-07-24 00:00:00
Feb 2005 / 6 |  | 2011-07-24 00:00:00
July 2006 / 1 |  | 2011-07-25 00:00:00
July 2006 / 2 |  | 2011-07-25 00:00:00
July 2006 / 3 |  | 2011-07-25 00:00:00
July 2006 / 4
July 2006 / 5
July 2006 / 6
Feb 2007 / 1
Feb 2007 / 2
Feb 2007 / 3
Feb 2007 / 4
Feb 2007 / 5
Feb 2007 / 6
July 2007 / 1
July 2007 / 2
July 2007 / 3
July 2007 / 4
July 2007 / 5
July 2007 / 6
Feb 2008 / 1
Feb 2008 / 2
Feb 2008 / 3
Feb 2008 / 4
Feb 2008 / 5
Feb 2008 / 6
July 2008 / 1
July 2008 / 2
July 2008 / 3
July 2008 / 4
July 2008 / 5
July 2008 / 6
Feb 2009 / 1
Feb 2009 / 2
Feb 2009 / 3
Feb 2009 / 4
Feb 2009 / 5
Feb 2009 / 6
July 2009 / 1
July 2009 / 2
July 2009 / 3
July 2009 / 4
July 2009 / 5
July 2009 / 6
Feb 2010 / 1
Feb 2010 / 2
Feb 2010 / 3
Feb 2010 / 4
Feb 2010 / 5
Feb 2010 / 6
July 2010 / 1
July 2010 / 2
July 2010 / 3
July 2010 / 4
July 2010 / 5
July 2010 / 6
Feb 2011 / 1
Feb 2011 / 2
Feb 2011 / 3
Feb 2011 / 4
Feb 2011 / 5
Feb 2011 / 6
Spreadsheet: dan_hyvl__4871__Master Physical Worksheet Template_GRE
Sheet: Sheet1

Master Firm Purchase/Sale Agreement Worksheet
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Great River Energy | CONTACT:
ADDRESS: | 17845 East Highway 10 | TITLE:
 | Elk River, Minnesota 55330 | PHONE:
 |  | FAX:
Incorporation State | Minnesota | FITCH IBCA Implied Senior Secured Rating | BBB+
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 0
Incorporation State
COLLATERAL  THRESHOLD
 | 5000000 | 25000000
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change
Below | BBB- | BBB-/Baa3
Financial Covenants
-Funded debt/Worth | [NAME] | S&P and/or Moody's
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 25 | 100
-Guarantor ($[NAME])
Change in ownership
FINANCIAL STATEMENTS
-Standard |  | X
- Request financials on: | 100 Days after FYE and 45 Days aftter each quarter end.
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: x | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x33565
Spreadsheet: 134817d1325648380-solved-if-indirect-v-and-h-lookup-multi-condition-validation-list
Sheet: Sheet1

Padding |  | Category
H47 |  | Group A | APRO 1 | BPRO 1 | CPRO A | D PRO 1 | AB PRO | F 1 | GG1
H57 |  | Group B | APRO 2 | BPRO 2 | CPRO B | D PRO 2 | BC PRO | F 2 | GG2
 |  | Group C | APRO 3 | BPRO 3 | CPRO C | D PRO 3 | CD PRO | F 3 | GG3
 |  | Group D | APRO 4 |  | CPRO D | D PRO 4 | DE PRO | F 4
 |  | Group E | APRO 5 |  | CPRO E | D PRO 5 | EF PRO | F 5
 |  | Group F | APRO 6 |  | CPRO F | D PRO 6
 |  | Group G |  |  | CPRO G | D PRO 7
 |  | End | End | End | End | End | End | End | End
 |  | Padding
 |  | APRO 1 | APRO 2 | APRO 3 | BPRO 1 | … | … | F 4 | F 5 | GG1 | GG2 | GG3
 |  | Black | Black | Red | Pruple |  |  | Red | Blue | Blue | Red | Black
 |  | White | White | Orange | Yellow |  |  |  | Navy | Red | Orange | red
 |  |  | [NAME] | Blue | Green |  |  |  | Red | White | Yellow
 |  |  |  | White | White |  |  |  |  | Yellow | Blue
 |  |  |  |  | Pink |  |  |  |  | Green | Navy
 |  |  |  |  |  |  |  |  |  |  | Purp
 |  |  |  |  |  |  |  |  |  |  | white
 |  | End | End | End | End | End | End | End | End | End | End | End
 |  | Padding
 |  | APRO 2 | APRO 3 | BPRO 1 | … | … | F 4 | F 5 | GG1 | GG2 | GG3 | GG3
 |  | Red | Black | Red |  |  | Pruple | Blue | Red | Blue | Blue
 |  | Orange | White |  |  |  | Yellow | Navy | Orange | Red | Navy
 |  | Blue |  |  |  |  | Green | Red | Yellow | White | Red
 |  | White |  |  |  |  | White |  | Blue | Yellow
 |  |  |  |  |  |  | Pink |  | Navy | Green
 |  |  |  |  |  |  |  |  | Purp
 |  |  |  |  |  |  |  |  | white
 |  | End | End | End | End | End | End | End | End | End | End | End
Spreadsheet: 951cb451-7518-4e6c-9717-466b816918dd
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
손실보상명세서
일련번호 | [NAME] | 지번 | 지목 | 면적 | 지분 |  | [NAME] |  | 소유자 |  | 비고
 |  |  |  |  | 분자 | 분모 | 단가 | 금액 | 성명 | [NAME]
1 | 안동시 임동면 망천리 | 산 115-2 | 임야 | 10268 | 1 | 1 | 3100 | 31830800 | 류동희 |  | 미등기
Spreadsheet: 033382fe-0ba4-42b7-a5f4-b276af6cc2d6
Sheet: Price Reductions

Price Reductions Spreadsheet
SIN | Manufacturer | Manufacturer Part # | GSA or Dealer Part # | Product Description | Current Approved Commercial Price List | Proposed Commercial Price List | $ Change | % Change | [NAME] | [NAME] | Current GSA Price Including IFF | Proposed  GSA Price Including IFF | COO | Reason for Decrease
302-49 | ACME | 123ABC | Same | Ice Machine | 2100 | 2000 |  |  | 0.05 | 0.1
Fair and Reasonable Pricing
To determine fair and reasonable pricing, the GSA Contracting Officer may consider many factors, including pricing on competitor contracts, historical pricing, and currently available pricing in other venues.
Offers which provide Most Favored Customer pricing, but which are not highly competitive will not be found fair and reasonable and will not be accepted.
Spreadsheet: 61dbfb6e-2f74-4048-a950-4a96b237c3ae
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Nov. | Dec. | Jan. |  | Jan.
Region/country | 2013 | 2013 | 2014 |  | 2013
 | 1,000 pounds 1/
North America | 126548.189 | 126147.956 | 107336.796 |  | 104814.416
Canada | 3051.128 | 2650.07 | 2570.917 |  | 2959.098
Costa Rica | 331.098 | 352.284 | 172.569 |  | 199.368
Dominican Republic | 5837.042 | 4836.861 | 4233.296 |  | 3981.692
El Salvador | 17369.602 | 21454.375 | 13589.676 |  | 13232.068
Guatemala | 7760.285 | 7625.182 | 6276.437 |  | 6580.228
Haiti | 10101.988 | 9870.263 | 9064.227 |  | 8448.22
Honduras | 25155.866 | 26406.457 | 17422.389 |  | 17598.227
Mexico | 42732.526 | 38215.884 | 39282.197 |  | 38789.236
Nicaragua | 14186.174 | 14719.551 | 14634.486 |  | 13025.862
South America | 3627.323 | 4038.24 | 4215.851 |  | 5059.74
Colombia | 1519.032 | 1637.477 | 1502.693 |  | 1794.295
Peru | 1874.647 | 2208.495 | 2471.179 |  | 3129.484
Europe | 12973.31 | 11844.843 | 11265.47 |  | 10660.673
Germany | 925.34 | 1002.564 | 950.001 |  | 863.799
Italy | 1736.338 | 1783.291 | 1648.907 |  | 1686.528
Portugal | 1700.429 | 1198.517 | 1648.164 |  | 1194.01
Turkey | 6120.26 | 5260.313 | 4620.221 |  | 4847.443
Turkmenistan | 245.429 | 658.693 | 482.257 |  | 248.974
Asia | 504923.688 | 464528.488 | 561645.752 |  | 547968.57
Bahrain | 897.785 | 1638.068 | 1535.24 |  | 1166.533
Bangladesh | 43205.38 | 35791.506 | 53167.288 |  | 52851.101
Cambodia | 17713.164 | 14151.178 | 16278.375 |  | 18211.497
China | 219329.719 | 204402.039 | 241662.517 |  | 234106.926
Hong Kong | 1368.809 | 724.772 | 971.004 |  | 877.38
India | 61617.173 | 60226.036 | 66381.362 |  | 60273.695
Indonesia | 25955.998 | 20361.075 | 28858.744 |  | 32741.73
Israel | 771.095 | 625.84 | 1107.747 |  | 888.908
Japan | 1007.177 | 1119.785 | 1049.012 |  | 992.684
Jordan | 4310.543 | 4517.307 | 4749.102 |  | 4267.479
Malaysia | 2589.225 | 2608.321 | 2899.899 |  | 3207.3
Pakistan | 54501.304 | 52410.165 | 65480.212 |  | 64598.634
Philippines | 3312.851 | 3506.532 | 4236.087 |  | 4982.837
South Korea | 5222.777 | 5127.101 | 7692.49 |  | 5997.976
Sri Lanka | 8009.494 | 7204.405 | 8706.686 |  | 7697.095
Taiwan | 1833.09 | 1970.411 | 2345.505 |  | 2664.392
Thailand | 5948.006 | 5810.107 | 6103.222 |  | 6680.908
United Arab Emirates | 895.65 | 735.266 | 416.968 |  | 473.112
Vietnam | 46119.173 | 41098.262 | 47625.531 |  | 44721.133
Oceania | 46.531 | 17.797 | 82.472 |  | 26.855
Africa | 12606.393 | 14364.683 | 15670.1 |  | 16080.987
Egypt | 6181.281 | 7415.911 | 8820.115 |  | 8995.577
Kenya | 2494.03 | 2076.901 | 1977.613 |  | 1693.832
[NAME] | 2281.772 | 2009.654 | 2645.941 |  | 3032.771
[NAME] | 571.575 | 1366.258 | 926.684 |  | 892.035
World 2/ | 660725.435 | 620942.007 | 700216.441 |  | 684611.241
 |  |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update:  03/12/14.
Spreadsheet: 891f15a6-5648-40e0-982a-15b43254c96d
Sheet: Consolidated Cash Flow Statemen

 | ([NAME]) | ([NAME])
 | Current period | Prior period
 | 1 January - | 1 January -
 | 30 September 2010 | 30 September 2009
Profit for the period before tax | 2411078 | 1709709
Adjustments to reconcile profit before tax to cash provided
by operating activities:
Depreciation and amortization expense | 1127709 | 1199995
Gain on sale of property, plant  and equipment | -31077 | -4672
IFRIC 12 adjustment | -4117 | 0
Foreign currency exchange (income) / expense, net | -182106 | -24771
Interest income and (expense), net | 206930 | 70894
Reversal of doubtful receivables | -145211 | -127433
Allowance for doubtful receivables | 223308 | 262758
Provision for employee termination benefits | 83263 | 68149
Litigation provision / (release), net | 46199 | -3208
Loss on derivative financial instruments | 70876 | 1119
Unused vacation provision / (release), net | 100 | 3871
Other provisions | 1642 | 1109
Operating profit before working capital changes | 3808594 | 3157520
Net working capital changes in:
Trade receivables and other receivables | -365519 | -309070
Other current assets and inventories | 57472 | 8878
Trade payables and other payables | -289692 | -70870
Other non-current assets | 6082 | -445563
Other current liabilities and provisions | 131202 | -6988
Other non-current liabilities and provisions | -1365 | 92503
Payments of employee termination benefits | -58726 | -2288
Restricted cash | -28901 | -19186
Provision payments | -3769 | -
Income taxes paid | -596851 | -488392
Net cash provided by operating activities | 2658527 | 1916544
Investing activities
Interest received | -61009 | 144271
Proceeds from sale of property, plant, equipment and intangible assets | 49376 | 27920
Purchases of property, plant and equipment and intangible assets | -923071 | -1548512
Net cash used in  investing activities | -934704 | -1376321
Cash flows from financing activities
Proceeds from bank borrowings (Note 8) | 10648459 | 11510768
Repayment of bank borrowings (Note 8) | -10442576 | -10500210
Repayment of obligations under finance leases (Note 8) | -3765 | -3594
Interest paid | -143921 | -234129
Derivative instrument payments | -57453 | -
Dividends paid | -1589712 | -1490157
Net cash used in financing activities | -1588968 | -717322
Net decrease in cash and cash equivalents | 134855 | -177099
Cash and cash equivalents at the beginning of the period  (Note 6) | 317681 | 616109
Cash and cash equivalents at the end of the period (Note 6) | 452536 | 439010
Spreadsheet: cara_semperger__1441__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (20&21)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | DAILY DEAL=2 LLH
 |  |  |  |  | Mid Columbia Paths
11/20/2001-11/21/2001
 | HLH
 | DAY | 12 | CHPD(G)MIDC-CHPD | X | PSPL | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 20 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 2 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | MIDC
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 164981d1340977826-clear-2-ranges-of-cell-data-when-value-is-changed-in-primary-drop-down-no-programming-development_swing-ticket-20120628-beta
Sheet: SwingTicketData

PrintshopID | DateInSystem | CustOrgID | CustPONumber | POCtrlNo | ShippingMethodCode | VendorRefCode | Courier | CourierAcctNo | VendorRef | ShipToOrgName | ShipToContactName | ShipToAddress1 | ShipToAddress2 | ShipToAddress3 | ShipToCity | ShiptoState | ShiptoZip | ShipToCountryCode | ShipToCountryName | ShipToPhone | [NAME] | ShipToEmail | VendorRef | DetailCtrlNo | SBOrigCode | CustItemCode | Quantity | UOM | OrderWeight | ItemCtrlID | PrimarySize | SecondarySize | PantoneCode | MSRP | UPC | InforLine1 | Color | Story | StyleNumber | XPartSets
Z56 | 2012-06-01 00:00:00 |  | 1063710 |  | REGULAR | 05254 |  |  | 1063710 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000000 | AQ | ANTARCTICA | 0 | 0 | 0 |  |  |  | ST/L2101OT | 20 |  |  |  |  | 41cm - 16in | #N/A | 99.99 | 86535763 | [NAME] | BLUE MIX | Story Desc Test | T32/5089
Z56 | 2012-06-01 00:00:00 |  | 1063710 |  | REGULAR | 05254 |  |  | 1063710 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000000 | AQ | ANTARCTICA | 0 | 0 | 0 |  |  |  | ST/L2101OT | 12 |  |  |  | 28-30 | 43cm - 17in | #N/A |  | 77987689 | [NAME] | BLUE MIX |  | T32/5089 | 2 PART SET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: print size X - Y onto left and right size block if there is "-", print "-" across the two upper size blocks
remark: Z56 refers to Brilliant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: texts print to next line after "/" within same size block |  |  |  | remark: Concatenate "Dept" + "/" + "SupplierCode" + "/" + "Stroke"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: secondary size is printed at lower part size block. when there is "-", print size in cm on the left size block, print size in inch on the right size block |  |  |  |  |  |  | remark: concatenate "Dept" + "Stroke"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: When there is "/", use two pantone colors on 4 size blocks, the former for the upper left, the later one for upper right size block.
Spreadsheet: 752386d1634739112-highlightning-duplicates-with-multiple-rules-excel-example-sheet
Sheet: Copy of test

 | Test | Example | HIGHLIGHT |  | <- These should be highlighted, as theyre duplicate in B, C and D
 | Test | Example | HIGHLIGHT |  | <- These should be highlighted, as theyre duplicate in B, C and D
 |  | Example | HIGHLIGHT |  | <- These should be highlighted, as theyre duplicate in B, C and D (check if B is empty)
 |  | Example | HIGHLIGHT |  | <- These should be highlighted, as theyre duplicate in B, C and D (check if B is empty)
 | Test2 | Example2 | HIGHLIGHT2
 | Test2 | Example2 | HIGHLIGHT2
 |  | Example2 | HIGHLIGHT2 |  | <- Should not be highlighted as its not a duplicate in B, C and D
 | What would be best, but not sure if possible :
 | Test3 | Example3 | [NAME] |  | <- Gets highlighted because it is a duplicate of column 15 in row C and D (even if B isnt a duplicate)
 |  | Example3 | [NAME] |  | <- Doesn't get highlighted because its not a duplicate in B, C and D
 | Test4 | Example4 | HIGHLIGHT4 |  | <- Gets highlighted because duplicate of another column in B C and D
 | Test4 | Example4 | HIGHLIGHT4
 |  | Example4 | HIGHLIGHT4 |  | <- Gets highlighted if its a duplicate of another column that has Blank B and duplicate C and D
 |  | Example4 | HIGHLIGHT4
 | Test5 | Example5 | HIGHLIGHT5
 | Test5 | Example5 | HIGHLIGHT5
 | Test5 | Example5 | HIGHLIGHT5
 |  | Example5 | HIGHLIGHT5 |  | <- doesn't get highlighted because there is no other column with a duplicate in C and D thats blank in B
 | Test5 | Example5 | HIGHLIGHT5
 |  |  |  |  | Current formula = | =COUNTIFS($B$1:$B,$B1,$C$1:$C,$C1,$D$1:$D,$D1)>1
Spreadsheet: 814187d1674219435-need-help-returning-a-value-from-a-tab-name-but-for-cell-to-look-for-that-tab-name-example-for-forum
Sheet: Sep 22

2022-09-01 00:00:00
 | Items
Branch 1 | 31
Branch 2 | 32
Branch 3 | 33
Branch 4 | 34
Branch 5 | 35
Branch 6 | 36
Branch 7 | 37
Branch 8 | 38
Branch 9 | 39
Branch 10 | 40
Branch 11 | 41
Branch 12 | 42
Branch 13 | 43
Branch 14 | 44
Branch 15 | 45
Branch 16 | 46