tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5062__HPLN0509
Sheet: Sheet1

HPLN0509.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - May 9, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-05-09 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 10 | 10
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 674778d1588010145-counting-transitions-between-0-1-but-for-every-year-sample_with_formula
Sheet: sample

Year | Month | Day | SnowDepth | Quality | B | 0-0 transf | 0-1 transf | 1-0 transf | 1-1 transf
1944 | 12 | 17 | 0.35 | G
1944 | 12 | 18 | 0.36 | G
1944 | 12 | 19 | 0.28 | G
1944 | 12 | 20 | 0.26 | G
1944 | 12 | 21 | 0.26 | G
1944 | 12 | 22 | 0.26 | G
1944 | 12 | 23 | 0.26 | G
1944 | 12 | 24 | 0.22 | G
1944 | 12 | 25 | 0.18 | G
1944 | 12 | 26 | 0.18 | G
1944 | 12 | 27 | 0.17 | G
1944 | 12 | 28 | 0.17 | G
1944 | 12 | 29 | 0.17 | G
1944 | 12 | 30 | 0.17 | G
1944 | 12 | 31 | 0.17 | G
1945 | 12 | 17 | 0.08 | G
1945 | 12 | 18 | 0.10 | G
1945 | 12 | 19 | 0.08 | G
1945 | 12 | 20 | 0.08 | G
1945 | 12 | 21 | 0.08 | G
1945 | 12 | 22 | 0.10 | G
1945 | 12 | 23 | 0.10 | G
1945 | 12 | 24 | 0.10 | G
1945 | 12 | 25 | 0.10 | G
1945 | 12 | 26 | 0.11 | G
1945 | 12 | 27 | 0.10 | G
1945 | 12 | 28 | 0.12 | G
1945 | 12 | 29 | 0.13 | G
1945 | 12 | 30 | 0.13 | G
1945 | 12 | 31 | 0.13 | G
1946 | 12 | 17 | 0.25 | G
1946 | 12 | 18 | 0.25 | G
1946 | 12 | 19 | 0.25 | G
1946 | 12 | 20 | 0.22 | G
1946 | 12 | 21 | 0.22 | G
1946 | 12 | 22 | 0.21 | G
1946 | 12 | 23 | 0.19 | G
1946 | 12 | 24 | 0.14 | G
1946 | 12 | 25 | 0.16 | G
1946 | 12 | 26 | 0.16 | G
1946 | 12 | 27 | 0.16 | G
1946 | 12 | 28 | 0.16 | G
1946 | 12 | 29 | 0.16 | G
1946 | 12 | 30 | 0.16 | G
1946 | 12 | 31 | 0.16 | G
1947 | 12 | 17 | 0.33 | G
1947 | 12 | 18 | 0.33 | G
1947 | 12 | 19 | 0.31 | G
1947 | 12 | 20 | 0.31 | G
1947 | 12 | 21 | 0.31 | G
1947 | 12 | 22 | 0.31 | G
1947 | 12 | 23 | 0.34 | G
1947 | 12 | 24 | 0.34 | G
1947 | 12 | 25 | 0.38 | G
1947 | 12 | 26 | 0.38 | G
1947 | 12 | 27 | 0.38 | G
1947 | 12 | 28 | 0.38 | G
1947 | 12 | 29 | 0.39 | G
1947 | 12 | 30 | 0.39 | G
1947 | 12 | 31 | 0.39 | G
1948 | 12 | 17 | 0.12 | G
1948 | 12 | 18 | 0.12 | G
1948 | 12 | 19 | 0.10 | G
1949 | 12 | 17 | 0.10 | G
1949 | 12 | 18 | 0.13 | G
1949 | 12 | 19 | 0.15 | G
1949 | 12 | 20 | 0.16 | G
1949 | 12 | 21 | 0.16 | G
1949 | 12 | 22 | 0.17 | G
1949 | 12 | 23 | 0.18 | G
1949 | 12 | 24 | 0.18 | G
1949 | 12 | 25 | 0.19 | G
1949 | 12 | 26 | 0.19 | G
1949 | 12 | 27 | 0.25 | G
1949 | 12 | 28 | 0.28 | G
1949 | 12 | 29 | 0.29 | G
1949 | 12 | 30 | 0.30 | G
1949 | 12 | 31 | 0.35 | G
1950 | 12 | 17 | 0.37 | G
1950 | 12 | 18 | 0.32 | G
1950 | 12 | 19 | 0.32 | G
1950 | 12 | 20 | 0.32 | G
1950 | 12 | 21 | 0.32 | G
1950 | 12 | 22 | 0.32 | G
1950 | 12 | 23 | 0.32 | G
1950 | 12 | 24 | 0.32 | G
1950 | 12 | 25 | 0.37 | G
1950 | 12 | 26 | 0.40 | G
1950 | 12 | 27 | 0.40 | G
1950 | 12 | 28 | 0.43 | G
1950 | 12 | 29 | 0.44 | G
1950 | 12 | 30 | 0.45 | G
1950 | 12 | 31 | 0.45 | G
1951 | 12 | 17 | 0.08 | Y
1951 | 12 | 18 | 0.07 | Y
1951 | 12 | 19 | 0.07 | Y
1951 | 12 | 20 | 0.06 | Y
1951 | 12 | 21 | 0.00 | G
1951 | 12 | 22 | 0.00 | G
1951 | 12 | 23 | 0.00 | G
1951 | 12 | 24 | 0.00 | G
1951 | 12 | 25 | 0.00 | G
1951 | 12 | 26 | 0.00 | G
1951 | 12 | 27 | 0.00 | G
1951 | 12 | 28 | 0.00 | G
1951 | 12 | 29 | 0.08 | Y
1951 | 12 | 30 | 0.07 | Y
1951 | 12 | 31 | 0.07 | Y
Spreadsheet: 146427d1332179636-excel-2007-conditional-formatting-a-date-occuring-info-1-
Sheet: Sheet1

NAME | Employee # | R&B Eligible | R&B Allowance | HIRE DATE | NEXT RE- APPROVAL DATE |  | # months since hire date | month interval for next requirement (all evenly divisible by 6) | the date of the next review | -14 days
Person 1 | 11030 | Yes | 80.73 | 2010-04-01 00:00:00
Person 2 | 11031 | Yes | 33.63 | 2011-06-06 00:00:00
Person 3 | 11032 | Yes | 31.83 | 2001-10-04 00:00:00
Person 4 | 11033 | Yes | 77.02 | 2011-05-04 00:00:00
Person 5 | 11034 | Yes | 25.25 | 2011-12-31 00:00:00
 |  |  |  |  | * The formula in this column is an imbedded formula of columns H:K |  | NOTE: This is calculated using the =TODAY() function. The day after this requirement, the formula resets and the alert will go away. To add the capability to keep the alert until the requirement is completed, you'll need a column with an identifier, such as a column to enter the most recent completion date.
 |  |  |  |  | **This is the formula used for conditional formatting: =(F2-14)<TODAY()
Spreadsheet: 162611d1340005905-column-chart-displaying-blank-columns-838874
Sheet: Score 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Score 1 | Score 2 | Score 3 | Score 4 | Q2 | Avg
 |  | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | Q2 |  |  |  |  |  |  |  |  | 2011-12-01 00:00:00
 | Score 1 | 67 | 78 |  | 78 | 75 | 77 | 80 | 0 |  |  |  |  |  |  |  |  |  |  | 67
 | Score 2 | 59 | 74 |  | 74 | 69 | 72 | 76 | 0 |  |  |  |  |  |  |  |  |  |  |  | 59 |  |  |  | 69
 | Score 3 | 82 | 77 |  | 80 | 83 | 81 | 87 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 82
 | Score 4 |  | 0 | 0 | 87 | 79 | 82 | 82 | 0
 | Q2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 73 |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00
 | Avg |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00
 |  | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | Q2 |  |  |  |  |  |  |  |  |  |  | 77
 | Score 1 |  | 78 | 77 | 78 | 75 | 77 | 80 |  |  |  |  |  |  |  |  |  |  |  |  | 80
 | Score 2 | 59 | 74 | 80 | 74 | 69 | 72 | 76 |  |  |  |  |  |  |  |  |  |  |  |  |  | 81
 | Score 3 | 82 | 77 | 81 | 80 | 83 | 81 | 87
 | Score 4 |  |  |  | 87 | 79 | 82 | 82 |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00
 | Q2 |  |  |  |  |  |  |  | 73 |  |  |  |  |  |  |  |  |  |  | 78
 | Avg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87 |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
Spreadsheet: 866577d1713486487-not-transferring-employee-names-to-main-sheets-employee-absence-schedule
Sheet: September

 | Employee absence schedule
 | September
 | Absence type key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  | Dates of absence
 | Employee name | 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 |  | Total days
 | [NAME]
 | [NAME]
 | Asaf Karten
 | [NAME]
 | [NAME]
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Welding Tech Certificates 1

WELDING TECHNOLOGY
Certificates
Students Name:
ID #
[NAME] | Semester | Grade
___ WLD 151 (2) Basic Welding - A
OR ___ WLD 120 (2) Shielded Metal Arc Welding (SMAW)
AND ___ WLD 121 (3) Shielded Metal Arc Welding (SMAW) Fillet Lab
___ WLD 130 (2) Gas Tungsten Arc Welding (GTAW)
AND ___ WLD 131 (3) Gas Tungsten Arc Welding (GTAW) Fillet Lab
___ WLD 133 (3) Gas Tungsten Arc Welding (GTAW) Groove Lab
OR ___ WLD 140 (2) Gas Metal Arc Welding (GMAW)
AND ___ WLD 141 (3) Gas Metal Arc Welding (GMAW) Fillet Lab
___ WLD 152 (5) Basic Welding - B
OR ___ IMT 100 (3)Welding for Maintenance
AND ___ IMT 101 (2) Welding for [NAME]
Gas Welder
___ WLD 100 (2) Oxy-Fuel Systems
___ WLD 101 (2) Oxy-Fuel Systems Lab
ARC Cutter
___ WLD 110 (2) Cutting Processes
___ WLD 111 (3) Cutting Processes Lab
[NAME]
___ WLD 170 (2) Blueprint Reading for Welding
___ WLD 171 (3) Blueprint Reading for Welding Lab
___ WLD 151 (2) Basic Welding - A
OR ___ WLD 120 (2) Shielded Metal Arc Welding (SMAW)
AND ___ WLD 121 (3) Shielded Metal Arc Welding (SMAW) Fillet Lab
OR ___ WLD 130 (2) Gas Tungsten Arc Welding (GTAW)
AND ___ WLD 131 (3) Gas Tungsten Arc Welding (GTAW) Fillet Lab
OR ___ WLD 140 (2) Gas Metal Arc Welding (GMAW)
AND ___ WLD 141 (3) Gas Metal Arc Welding (GMAW) Fillet Lab
OR ___ WLD 152 (5) Basic Welding - B
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 1d80b2a8-7143-4e07-a91c-82340c3446c4
Sheet: Sheet1

Table 10--Global rice exporters, calendar years; monthly revisions and annual changes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2011 |  |  |  | 2012 |  |  |  |  |  | 2013 1/
 | June |  | May | June |  | Monthly | Annual |  | May | June |  | Monthly | Annual
 | 2012 |  | 2012 | 2012 |  | revisions | changes |  | 2012 | 2012 |  | revisions | changes
 |  |  |  |  |  |  | 1,000 metric tons (milled basis)
Argentina | 732 |  | 650 | 650 |  | 0 | -82 |  | 560 | 560 |  | -- | -90
Australia | 311 |  | 450 | 450 |  | 0 | 139 |  | 500 | 500 |  | -- | 50
Brazil | 1296 |  | 825 | 900 |  | 75 | -396 |  | 900 | 900 |  | -- | 0
Burma | 778 |  | 600 | 600 |  | 0 | -178 |  | 750 | 750 |  | -- | 150
Cambodia | 860 |  | 800 | 800 |  | 0 | -60 |  | 950 | 950 |  | -- | 150
China | 487 |  | 500 | 500 |  | 0 | 13 |  | 600 | 600 |  | -- | 100
Ecuador | 70 |  | 15 | 15 |  | 0 | -55 |  | 50 | 50 |  | -- | 35
Egypt | 320 |  | 600 | 600 |  | 0 | 280 |  | 600 | 600 |  | -- | 0
European Union-27 | 241 |  | 245 | 245 |  | 0 | 4 |  | 235 | 235 |  | -- | -10
Guyana | 250 |  | 230 | 230 |  | 0 | -20 |  | 250 | 250 |  | -- | 20
India | 4637 |  | 7000 | 8000 |  | 1000 | 3363 |  | 6000 | 6500 |  | -- | -1500
Japan | 200 |  | 200 | 200 |  | 0 | 0 |  | 200 | 200 |  | -- | 0
Korea, South | 4 |  | 5 | 5 |  | 0 | 1 |  | 5 | 5 |  | -- | 0
Pakistan | 3414 |  | 3750 | 3750 |  | 0 | 336 |  | 4000 | 4000 |  | -- | 250
Paraguay | 208 |  | 150 | 150 |  | 0 | -58 |  | 150 | 150 |  | -- | 0
Peru | 50 |  | 20 | 20 |  | 0 | -30 |  | 60 | 60 |  | -- | 40
Russia | 142 |  | 150 | 150 |  | 0 | 8 |  | 150 | 150 |  | -- | 0
Thailand | 10647 |  | 6500 | 6500 |  | 0 | -4147 |  | 8000 | 8000 |  | -- | 1500
Turkey | 90 |  | 75 | 75 |  | 0 | -15 |  | 80 | 80 |  | -- | 5
Uganda | 40 |  | 35 | 35 |  | 0 | -5 |  | 35 | 35 |  | -- | 0
United States | 3213 |  | 3300 | 3400 |  | 100 | 187 |  | 3000 | 3000 |  | -- | -400
Uruguay | 841 |  | 850 | 850 |  | 0 | 9 |  | 850 | 850 |  | -- | 0
Vietnam | 7000 |  | 7000 | 7000 |  | 0 | 0 |  | 7000 | 7000 |  | -- | 0
Subtotal | 35831 |  | 33950 | 35125 |  | 1175 | -706 |  | 34925 | 35425 |  | -- | 300
Other | 314 |  | 279 | 279 |  | 0 | -36 |  | 305 | 305 |  | -- | 26
World total | 36145 |  | 34229 | 35404 |  | 1175 | -741 |  | 35230 | 35730 |  | -- | 326
U.S. Share | 0.08889196292709918 |  | 0.09640947734377282 | 0.09603434640153655 |  | -- | -- |  | 0.08515469770082316 | 0.08396305625524769 |  | -- | --
-- Not available.  Note: All trade data are reported on a calendar-year basis.
1/ Projected.
Source: Production, Supply, & Distribution Online Data Base, FAS/USDA, http://www.fas.usda.gov/psdonline/psdHome.aspx.
Last updated June 12, 2012.
Spreadsheet: 24b8b93c-b6c5-457c-8ea3-01b19715d134
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-28 09:25:10.360000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.24 | 101.115 | 100.99 | 100.615
4.625 | 100.511 | 100.386 | 100.261 | 99.886 |  | Note: | Refer To Price [NAME]
4.5 | 99.996 | 99.871 | 99.746 | 99.371 |  |  | For all Price Adjs
4.375 | 99.387 | 99.262 | 99.137
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.524 | 101.399 | 101.274 | 100.899
4 | 101.202 | 101.077 | 100.952 | 100.577
3.875 | 100.789 | 100.664 | 100.539 | 100.164
3.75 | 100.181 | 100.056 | 99.931 | 99.556
3.625 | 99.031 | 98.906 | 98.781
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-07-12 09:25:10.360000
30 DAY | 2011-07-27 09:25:10.360000
45 DAY | 2011-08-11 09:25:10.360000
60 DAY | 2011-08-26 09:25:10.360000
90 DAY | 2011-09-25 09:25:10.360000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: Faktura

Faktura | A
 | B
 | C
 | D
 | E
 | F
 | G
 | H
 | I
 | J
 | K
 | L
 | M
 | N
 | O
 | P
 | Q
 | R
 | S
 | T
 | U
 | V
 | W
 | X
 | Y
 | Z
 | AB
 | AC
 | AD
 | AE
 | AF
 | AG
 | AH
 | AI
 | AK
 | AK
 | AL
 | AM
 | AN
 | AO
 | AP
 | AQ
 | AR
 | AS
 | AT
 | AW
 | AV
 | AW
 | AX
 | AY
Spreadsheet: 769143d1645347629-extract-strings-based-on-criteria-for-entire-worksheet-extract-unique-aligw
Sheet: Sheet1

Sample Data |  |  |  |  | Expected Result |  |  | Spill Array Version
 |  |  |  |  |  | Count
\fs01\
\fs01\GM\ |  |  |  |  |  |  |  | \SomeOtherNetwork | 3
\fs01\GM\AF\ |  |  |  |  |  |  |  |  | 0
\fs01\GM\AF\1. documentation\
\SomeOtherNetwork\A
\SomeOtherNetwork\A_B
\SomeOtherNetwork\AB43
Spreadsheet: 540460d1506701017-rank-text-alphabetically-with-unique-rank-from-1-2-3-4-wanted-outcome
Sheet: Sheet1

 |  |  | Wanted outcome | Suggested formula (doesn't work with blanks)
 |  | Core system | 1
 |  | Core system | 1
 |  | Option B50 | 2
 |  | Option B50 | 2
 |  | Reverse system | 3
 |  | Reverse system | 3
 |  | Core system | 1
 |  | Option B50 | 2
 |  | Reverse system | 3
 |  | Reverse system | 3
 |  | Core system | 1
 |  | Core system | 1
Spreadsheet: 776481d1649757082-every-unique-uid-to-populate-180-in-column-b-if-countif-sample
Sheet: Sheet1

UID_MIRG_NCRF | AHT
216059938SXX24 | 180
219701978ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 180
220147826ARARA | 0
220147826ARARA | 0
220228144TXXMA | 180
220310022VIJPX | 180
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220362586MXXJA | 180
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
Spreadsheet: 8eccf1c4-79aa-4f9c-aa83-cc99724ed895
Sheet: Sheet1

Unnamed: 0 | Guelph-McL | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | GRAND CHAMPIONSHIP "A" | Unnamed: 6 | Unnamed: 7
 | 8
 | FRI
 | 9:00 PM       5 | Guelph-McL 3 |  |  | Division: NOVICE
 | D1
 |  |  |  |  | Location: PICKERING
 | Barrie  3
WLE-Red   3
 |  | SAT | Guelph-McL |  | Date: AUGUST 3-5, 2012
FRI |  | 3:00 PM    13 | 3
5:00 PM       1 | WLE Red  0 | D1 |  |  | Diamonds: KINSMEN PARK D1, D2
D1
Pickering  1 | SAT
 | 11:00AM     9
Waterloo-Gold | D1 | Miss. Nr.-W 1
1
FRI
5:00 PM      2
D2 | Miss. Nr.-W  1
2
Miss. Nr.- W |  |  | SAT |  | Brampton- W  9
Brampton-W |  |  | 9:00 PM   17
6 |  |  | D1
FRI
7:00 PM      3 | Brampton-W 7
D1
Kitchener  3 | SAT | Brampton-W
Brantford-C  5 | 11:00 AM  10 | 9
 | D2
FRI
7:00 PM       4
D2 | Brantford-C 0 | SAT
 |  | 3:00 PM  14 | 5
Miss. Nr.-V  1 |  | D2 | Brampton-W
 | Oakville  13 |  |  |  |  | SUN | Brampton-W
 |  |  |  |  |  | 2:00 PM     22
 | FRI |  |  |  |  | D1
 | 9:00PM      6 | Oakville  1
 | D2
 | Enniskillen  0
 | Barrie  4
 | Loser 5
 |  |  |  |  |  |  | SUN
Pickering  5 | SAT | Pickering   1 |  |  |  |  | 4:00 PM  23
Loser 1 | 1:00 PM    11 |  |  |  |  |  | D1
 | D1 |  |  |  | Guelph-McL  5
SAT |  | SAT | Brantford-C |  | Loser 17
9:00 AM       7 | Pickering  7 | 5:00 PM  15 | 4
D1 |  | D1 | SAT |  | SUN
Loser 2 |  | Loser 10    3 | 7:00 PM  19 | Miss. Nr.-W  10 | 12:00 PM   21 | Guelph-McL  0
[NAME]  3 |  | Brantford -C | D1 |  | D1
 |  |  | Loser 13    5 | SUN
 |  |  | Miss. Nr.-W | 10:00 AM    20 | Oakville  2 |  | (if first loss)
 |  |  | Oakville  9 | D1 |  |  | Loser 22
 |  |  | Loser 14
Kitchener  1 |  | WLE-Red  19 | SAT
Loser 3 |  | Loser 9 | 7:00 PM  18 | Oakville  14
 |  |  | D2
SAT | Miss. Nr.-V  5 | SAT
9:00 AM      8 |  | 5:00 PM   16 | WLE-Red  5
D2 | SAT | D2
Loser 4 | 1:00 PM    12
Miss. Nr.-V  8 | D2 | Miss. Nr.-V  2
 | Loser 6
 | Enniskillen  0
Spreadsheet: 164832d1340903462-shade-a-cell-based-on-time-of-day-timeshade
Sheet: Sheet1

UTC | EST |  | Time now is:
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00 |  | <--- Time now is 13:09, looking to shade this cell
18:00:00 |  | <--- At 14:00, this cell will shade, B19 will return to green
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
Spreadsheet: 774896d1648715722-dependent-drop-down-lists-simplerelateddropdown
Sheet: List

Must be the first row >>> and Uniq | [NAME] -->
Start Row
 | Size (included blank row) >>
 | Blank Row
 |  |  | Internal |  |  | Int_01 | Ext_01 |  | Int_01_01 | Int_02_01 | Int_03_01 | Int_04_01 | Int_05_01 | Int_06_01 |  | Ext_01_01 | Ext_02_01 | [NAME]
 |  |  | External |  |  | Int_02 | Ext_02 |  | Int_01_02 | Int_02_02 | Int_03_02 | Int_04_02 | Int_05_02 | Int_06_02 |  | Ext_01_02 | Ext_02_02 | Ext_03_02
 |  |  |  |  |  | Int_03 | Ext_03 |  | Int_01_03 | Int_02_03 | Int_03_03 | Int_04_03 | Int_05_03 | Int_06_03 |  | Ext_01_03 | Ext_02_03 | Ext_03_03
 |  |  |  |  |  | Int_04 |  |  | Int_01_04 | Int_02_04 | Int_03_04 | Int_04_04 | Int_05_04 |  |  | Ext_01_04 | Ext_02_04
 |  |  |  |  |  | Int_05 |  |  | Int_01_05 |  | Int_03_05 | Int_04_05 | Int_05_05 |  |  | Ext_01_05 | Ext_02_05
 |  |  |  |  |  | Int_06 |  |  | Int_01_06 |  | Int_03_06 | Int_04_06 | Int_05_06 |  |  | Ext_01_06 | Ext_02_06
 |  |  |  |  |  |  |  |  | Int_01_07 |  | Int_03_07 | Int_04_07 | Int_05_07 |  |  |  | Ext_02_07
 |  |  |  |  |  |  |  |  |  |  | Int_03_08 |  | Int_05_08 |  |  |  | Ext_02_08
 |  |  |  |  |  |  |  |  |  |  | Int_03_09 |  |  |  |  |  | Ext_02_09
 |  |  |  |  |  |  |  |  |  |  | Int_03_10
 |  |  |  |  |  |  |  |  |  |  | Int_03_11
Spreadsheet: bb385814-d7e2-4760-b08b-0cc9b59b65c1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FPIAP | Test | FPIAP | Pineapple IgG | Pineapple IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPIAP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPIAP | Result | FPIAP | Pineapple IgG | Pineapple IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process