tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 836355d1689299733-payments-allocation-to-bills-in-fifo-basis-fifo-sample-data-001-harshit8999-
Sheet: payments

payment date | payment number | payment vendor name | payment amount
2015-06-16 00:00:00 | 125/JNL/37 | ALMT Legal | 3550
2015-07-09 00:00:00 | 139/JNL/45 | ALMT Legal | 1600
2015-07-09 00:00:00 | 141/JNL/47 | ALMT Legal | 3375
2018-05-05 00:00:00 | 2077/JNL/66 | [NAME] (Photographer) | 1000
2019-04-30 00:00:00 | 3656/JNL/73 | [NAME] (Photographer) | 580.29
2018-06-07 00:00:00 | 2162A/Pay133 | [NAME] (Photographer) | 102252.05
2019-07-19 00:00:00 | 4086A/Pay118 | [NAME] (Photographer) | 5049
Spreadsheet: 693211d1598866524-remove-yelow-cell-whit-formula-is-possible-match-formula
Sheet: Sheet1

 |  | excel
 |  | power point | 11
 |  | office
 |  | excel file | 250
 |  | london
 |  | excel power | 350
 |  | force temp
 |  | love bite | 1
Spreadsheet: 768087d1644837789-xlookup-sumif-and-trend-functions-for-particle-size-distribution-calculation-particle-size-distribution
Sheet: Sheet2

Particle size ([NAME]) | Percent (%)
 |  |  |  |  |  |  |  |  | Particle size interval (mm) | Quantity (%)
 |  |  |  |  |  |  |  | (lBo) | > 630 | -
 |  |  |  |  |  |  |  | (Bo) | > 200 to ≤ 630 | -
 |  |  |  |  |  |  |  | (Co) | > 63 to ≤ 200
 |  |  |  |  |  |  |  | (cGr) | > 20 to ≤ 63
 |  |  |  |  |  |  |  | (mGr) | > 6,3 to ≤ 20
 |  |  |  |  |  |  |  | (fGr) | >  2 to ≤ 6,3
 |  |  |  |  |  |  |  | ([NAME]) | >  0,63 to ≤ 2
 |  |  |  |  |  |  |  | (mSa) | >  0,20 to ≤ 0,63
 |  |  |  |  |  |  |  | (fSa) | >  0,063 to ≤ 0,20
 |  |  |  |  |  |  |  | (cSi) | >  0,02 to  ≤ 0,063
 |  |  |  |  |  |  |  | (mSi) | >  0,0063 to ≤ 0,02
 |  |  |  |  |  |  |  | (fSi) | >  0,002 to ≤ 0,0063
 |  |  |  |  |  |  |  | (Cl) | ≤0,002
Spreadsheet: 796819d1663579459-amending-a-formula-to-change-the-result-from-highest-to-lowest-ramsey
Sheet: Results

CAMBRIDGESHIRE |  |  |  |  |  |  |  |  |  | MASTERS |  |  |  |  |  |  |  |  | LAST CHANCE
No | PLAYER | PAR 3 | TOTAL | S/I 1 | S/I 2 | S/I 3 | No |  |  | No | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | No |  |  | No | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | No
1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18
19
20
21
22
23
24
25
26
Spreadsheet: jonathan_mckay__17203__Tariffs New Update
Sheet: WinterSum

WINTER TARIFF SUMMARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROLL EACH MONTH
(Using average 2000 winter fuel ratios, IT floor bid calculated using Marginal fuel cost)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FP | BASIS
FX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AECO CAD
Aeco to Empress |  | $US/MMBtu |  |  |  |  |  | Mids Date: |  |  |  |  |  |  |  |  |  | AECO USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NX1
 |  |  |  |  |  | PRICE TERM: | 2001-11-01 00:00:00 | - | 2002-03-31 00:00:00 |  |  |  |  |  |  |  |  | EMPRESS CAD
Gas Prices | $C/GJ | $US/MMBTU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHICAGO
AECO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAWN
Empress/Border |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MALIN
Station 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATION 2
Stanfield
Sumas
Emerson
 |  |  |  |  | $US/MM | $US/MMBTU |  |  | $C/GJ |  |  | FIRM TRANSPORTATION
Transportation Point | Firm Variable | IT Variable | % Fuel |  | Fuel | Firm Variable Total | IT Total |  | Firm Variable Total | IT Total |  | RECP | DELIV | SPREAD | VALUE
Aeco to [NAME]
Aeco to Stanfield*
Aeco to Stanfield (NWPL)*
Aeco to Malin*
Aeco to Ventura
Aeco to Chicago
Aeco to Saskatchewan
Aeco to GLGT
Aeco to Dawn
Aeco to [NAME]
Aeco to Iroquois
Aeco to Chippawa
Aeco to Phillipsburg
Aeco to St Clair
Aeco to Parkway
Aeco to St. Clair (GLGT) w/o GLGT
Emerson to St. Clair (GLGT) w/o GLGT
Emerson to Fortune Lake (GLGT) w/o GLGT
Emerson to Carlton (GLGT) w/o GLGT
Alberta to Chicago via Alliance
BC to Chicago via Alliance
Stanfield to Malin*
Station 2 to AECO
Station 2 to Huntingdon
Station 2 to NWPL*
Huntingdon to NWPL*
AECO to Station 2 **
All numbers in $US/MMBtu
*Includes GRI
**AECO to Station 2 IT priced off of Empress
Station 2 to NWPL IT has T-South firm and NWPL IT
TCPL IT costs assume floor bid of 80% of firm
Spreadsheet: 871785d1718201373-march-fishing-xls-hpe-needed-sac-league
Sheet: 2

Name | lbs | oz | Oz (total) | Points
 | 68
 | 78 | 13
 | 33 | 12
 | 10 | 13
 | 48 | 9
 | 54 | 3
 | 41 | 12
 | 66 | 15
 | 83 | 6
 | 44 | 10
 | 3 | 9
 | 26 | 6
 | 19 | 3
 | 34 | 3
Spreadsheet: 9b562d70-88ce-45b4-9cf1-4dbce290878a
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Jax Distribution | 9781770933897 | Flower Pot Press | Story Of Creation, The | 2013-02-08 | Printed Books | Children | 7.99 | N | To Be Retired
Jax Distribution | 9781770933880 | Flower Pot Press | The Story Of Moses | 2013-02-08 | Printed Books | Children | 7.99 | N | To Be Retired
Spreadsheet: 711940d1609981991-formula-help-finding-formula
Sheet: Sheet1

[NAME] (RETURNS COMMENT) | UNIT | OIL FILTER | FUEL FILTER | WHEEL SEAL | ANNUAL INSPECTION
GOOD | 1 | GOOD | GOOD | GOOD | GOOD
OIL SOON, WEEL NOW | 2 | OIL SOON | GOOD | WHEEL NOW | GOOD
OIL NOW, FUEL NOW, WHEEL SOON, ANNUAL NOW | 3 | OIL NOW | FUEL NOW | WHEEL SOON | ANNUAL NOW
FUEL SOON, WHEEL SOON | 4 | GOOD | FUEL SOON | WHEEL SOON | GOOD
OIL NOW, ANNUAL SOON | 5 | OIL NOW | GOOD | GOOD | ANNUAL SOON
Spreadsheet: 137253d1327014905-excel-2007-drop-down-box-with-autocomplete-on-cells-parts-
Sheet: Sheet5

Note | Job to Job Trsfr. | Unit of Meas. | Part# | Distributor | Cost Each | Qty. | Total Cost | ACCT#. | From Job # | To Job# | Acct#/Job # Subtotal | From Syserco Tax Code | From Tax Rate | From Tax Amount | To Syserco Tax Code | To Tax Rate | To Tax Amount | Total Frm Tx Amt | Total To Tx Amt.
 |  |  | 0-BULK DISCOUNT
Spreadsheet: 844145d1695917765-help-with-date-formulas-please-test1-etaf
Sheet: Sheet1

A | B | C | DATE | DATE B | DATE C | TARGET DATE | WITHIN [NAME]? | DAYS TAKEN
 |  |  | 2023-09-28 00:00:00
What I want to happen is that in Column G (Target Date), the 15th of the next month (based upon the date in Column D) is displayed if the date (Column D) is the 15th or earlier. If the date in Column D is the 15th or later then I want the date displayed in Column G to be the 15th of the month after next.
For example:
If Column D = 12/09/2023 then Column G = 15/10/2023
or
If Column D = 18/09/2023 then Column G = 15/11/2023.
I also would like Column H to say Yes if within target (if date as above is before the 15th) or No if its outside of target (if date as above if after the 15th).
I would then like Column I to contain the number of days between the date in Column D and the date in Column G.
Spreadsheet: 31754d1227707848-combining-if-function-and-a-list-trip-budget-calculator
Sheet: Sheet1

Trip Budget Calculator
 |  |  |  | Boat
 | TO |  |  | Bus
Mode of Travel |  |  |  | Car
 | 0 |  |  | Plane
Number of Travelers | 0 |  |  | Train
Meals per Day | 0 |  |  | 0
Price per Meal | 0 |  |  | 1
 | 0 |  |  | 2
 | 0 |  |  | 3
 | 0 |  |  | 4
 | 0 |  |  | 5
 | 0 |  |  | 6
 | 0 |  |  | 7
 | 0 |  |  | 8
 | 0 |  |  | 9
 | 0 |  |  | 10
 | 0 |  |  | 11
 | 0 |  |  | 12
 | 0 |  |  | 13
 | 0 |  |  | 14
 | 0 |  |  | 15
 | 0 |  |  | 16
Total (Travel) | 0 |  |  | 17
 |  |  |  | 18
Days At Destination | 0 |  |  | 19
Hotel Cost Per Night Per Room | 0 |  |  | 20
# of Rooms | 0 |  |  | 21
Meals Per Day | 0 |  |  | 22
Cost Per Meal | 0 |  |  | 23
Misc | 0 |  |  | 24
Misc | 0 |  |  | 25
Misc | 0 |  |  | 26
Misc | 0 |  |  | 27
Misc | 0 |  |  | 28
Misc | 0 |  |  | 29
Misc | 0 |  |  | 30
Misc | 0 |  |  | 31
Misc | 0 |  |  | 32
Misc | 0 |  |  | 33
 | 0 |  |  | 34
Total At Destination | 0 |  |  | 35
 |  |  |  | 36
Plans |  | Same Route Back |  | 37
 |  |  |  | 38
 |  |  |  | 39
 |  |  |  | 40
 |  |  |  | Same Route Back
 |  |  |  | New Route Back
 |  |  |  | New Destination
Spreadsheet: 871915d1718296967-table-with-numbes-as-text-not-adding-up-help
Sheet: Sheet17

SITE |  | NAME ON BUILD |  | Self-employment review | Commitments review | First Commitments | Standard identity | Work Search Review | Gateway intervention | Self-employment review
 |  | [NAME]
 |  | Hayley Amanda H
 | ANSWER SHOULD BE | [NAME] |  |  |  |  |  | 20 | 60 | 60
 |  | Hayley Amanda H |  |  |  | 30
Spreadsheet: mark_haedicke__24590__2002 Plan Budget Pack - Legal Group 021001(HCODE)
Sheet: Adaytum Flight Details

 | 2002    ( Refresh view for your relevant CC or Region )
 | Adaytum
 | Legal | No. of flights/nights | Total | Budget 2002
 |  | Economy Class | Business Class | First Class | Hotel Rate
 | Europe internal | 0 | 60 | 0 | 120
 | Europe - US | 14 | 8 | 0 | 84
 | Europe - Asia | 0 | 0 | 0 | 0
 | US intenal | 0 | 0 | 0 | 0
Spreadsheet: 804392d1668037600-index-match-with-unique-results-non-duplicate-bowling-record
Sheet: 2

 | Individual Bowling Record |  |  |  |  |  |  |  |  | Bowler Name:
 | Handicap Basis: |  |  |  |  | Handicap % Factor: |  |  |  | Bowler Starting Average: |  |  |  |  | Beginning Handicap:
 | Scratch |  |  |  |  |  |  |  |  | w/ Handicap
 | Week | Game 1 | Game 2 | Game 3 | Series | Series Average | New Average | Total Pins |  | Week | Handicap | Game 1 | Game 2 | Game 3 | Series | Series Average | New Average | Total Pins
3 | 1 | 137 | 139 | 142 |  |  |  |  |  | 1
 |  | 138 | 136 | 155
 |  | 133 | 154 | 141
 |  |  |  |  | Current Average: |  |  |  |  |  |  |  |  |  | Current Average:
 | High |  |  |  |  | High Game |  |  |  | High |  |  |  |  |  | High Game
 | Low |  |  |  |  | Low Game |  |  |  | Low |  |  |  |  |  | Low Game
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 49839 | 42521
2 | 58661 | 61095
3 | 57956 | 59505
4 | 62170 | 61574
5 | 63269 | 58996
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
2001-07-31 00:00:00 |  |  | 167936
2001-08-05 00:00:00
Spreadsheet: 98cca56e-fa58-40f6-bde9-76ded889665a
Sheet: New Table 3

Table 3
Rail Deliveries to Port (carloads)1
 | Mississippi |  | Pacific | Atlantic & |  |  | Cross-Border
Week ending | Gulf | Texas Gulf | Northwest | East Gulf | Total | Week ending | Mexico3
05/15/2013p |  |  |  |  |  | 2013-05-11 00:00:00
05/08/2013r |  |  |  |  |  | 2013-05-04 00:00:00
2013 YTDr |  |  |  |  |  | 2013 YTD
2012 YTDr |  |  |  |  |  | 2012 YTD
2013 YTD as % of 2012 YTD |  |  |  |  |  | % change YTD
Last 4 weeks as % of 20122 |  |  |  |  |  | Last 4wks % 2012
Last 4 weeks as % of 4-year avg.2 |  |  |  |  |  | Last 4wks % 4 yr
Total 2012 |  |  |  |  |  | Total 2011 | 97118
Total 2011 |  |  |  |  |  | Total 2010 | 90175
1 Data is incomplete as it is voluntarily provided
2 Compared with same 4-weeks in 2011 and prior 4-year average.
3 Cross- border weekly data is aproximately 15 percent below the Association of American Railroads reported weekly carloads received by Mexican railroads
to reflect switching between KCSM and FerroMex.
YTD = year-to-date; p = preliminary data; r = revised data; YTD PNW carloads includes revisions back to August 2011 ; n/a = not available
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: f05e44c1-b945-4459-8029-877847de7505
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
SULFU | Test | SULFU | Sulfate, [NAME] | Sulfate, U | High-Performance Liquid Chromatography (HPLC) | Plastic, urine tube: PlUrTb |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. Specimen must be kept refrigerated during and after collection. 4. Specimen pH should be between 4.5 and 8 and will stay in this range if kept refrigerated. Specimens with pH >8 indicate bacterial contamination, and testing will be cancelled. Do not attempt to adjust pH as it will adversely affect results. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	No Refrigerated	Preferred Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	Yes Toluene	Yes 6N HNO3	No Boric Acid	Yes Thymol	Yes | 2 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | 7-47 mmol/specimen | Monday through Friday; 8 a.m.-3 p.m. | 1 day | 3 days | 1 | 84392 |  |  |  |  | Rochester
SULFU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
SULFU | Order Question | TM89 | Collection Duration |  | Plain Text
SULFU | Order Question | VL71 | [NAME] |  | Plain Text
SULFU | Result | SLF_U | Sulfate, U | Sulfate, U | Numeric |  |  |  |  | mmol/spec |  |  |  |  |  |  |  |  |  | 39576-4
SULFU | Result | TM89 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9
SULFU | Result | VL71 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4
SULFU | Result | SUL_C | [NAME] | [NAME] | Alphanumeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 12920-5
Spreadsheet: bbf3f15b-ce45-4cc8-a0e6-dbfcf68552a1
Sheet: Sheet1

Votre recherche : OXFORD, [NAME], Barocci 013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Folios | Auteur | Oeuvre | CPG | Commentaire | Incipit | Siècle | Source
020v-22 | IOHANNES CHRYSOSTOMVS | EXPOSITIONES IN PSALMOS 119-150 | 4413.6 | Expositio in Psalmum 140, excerptum (PG 55, 432, [NAME]. 31-437, [NAME]. 19) |  | 15 | R(III)0134
024-25v* | BASILIVS CAESARIENSIS | OPERA |  |  |  | 15
025v-30v | BARSANVPHIVS ET IOHANNES | QVAESTIONES ET RESPONSIONES | 7350 |  |  | 15
030v-37v* | ANASTASIVS SINAITA | QVAESTIONES ET RESPONSIONES | 7746 |  |  | 15
040v-45* | PETRVS DAMASCENVS | THESAVRVS |  |  |  | 15
045-47v* | ISAAC NINIVITA SYRVS | CAPITA ASCETICA | 7869 |  |  | 15
053--99* | MACARIVS/SYMEON (PSEVDO) | OPERA |  |  |  | 15
053-99*,167v-8v* | IOHANNES CHRYSOSTOMVS | OPERA |  |  |  | 15
145-150v* | ISIDORVS PELVSIOTA | EPISTVLAE | 5557 |  | Ο ΤΟΝ ΧΡΙΣΤΟΝ ΑΓΑΠΩΝ ΟΙΟΣ ΑΝ ΚΑΙ ΕΙΗ Ο ΙΕΡΕΥΣ | 15
168v-182v* | EPHRAEM GRAECVS | BEATITVDINES, CAPITA 55 | 3935.1 |  |  | 15
182v-201* | IOHANNES CLIMACVS | SCALA PARADISI | 7852 |  |  | 15
Spreadsheet: 781522d1653394510-calculate-values-based-on-day-of-the-week-sample-41-aligw
Sheet: Sheet1

Date | Type
2022-05-10 00:00:00
2022-05-11 00:00:00
2022-05-12 00:00:00
2022-05-13 00:00:00
2022-05-14 00:00:00
2022-05-15 00:00:00
2022-05-16 00:00:00
2022-05-17 00:00:00
2022-05-18 00:00:00
2022-05-19 00:00:00
2022-05-20 00:00:00
2022-05-21 00:00:00
2022-05-22 00:00:00
2022-05-23 00:00:00
2022-05-24 00:00:00
2022-05-25 00:00:00
2022-05-26 00:00:00
2022-05-27 00:00:00
2022-05-28 00:00:00
2022-05-29 00:00:00
2022-05-30 00:00:00
2022-05-31 00:00:00
Spreadsheet: 65313d1265993954-looking-for-the-closest-price-to-a-reference-price-717827_peteroconnor
Sheet: Sheet1

 |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Primary Price | Closest fit to primary source) | x | Source | Source 0 | Source 1 | Source 2 | Source 3 | Source 4 | Source 5 | Source 6 | Source 7 | Source 8 | Source 9 | Source 10
99.58031876 | 99 |  | Source 1 |  | 99
99.88224522 | 105 |  | Source 1 |  | 105
-0.21346017 | 5 |  | Source 3 |  |  |  | 5
-2.56476953 |  |  | No Coverage
-2.14146095 |  |  | No Coverage
-2.32626704 |  |  | No Coverage
-2.99746026 |  |  | No Coverage
-3.83220414 |  |  | No Coverage
-1.06792557 |  |  | No Coverage
-1.29966488 | -1.3 |  | Source 1 |  | -1.3
-1.65575821 |  |  | No Coverage
-2.86311947 |  |  | No Coverage
-2.71914448 |  |  | No Coverage
-2.63732451 |  |  | No Coverage
-2.19589001 |  |  | No Coverage
-1.30152079 |  |  | No Coverage
-3.11398066 |  |  | No Coverage
-2.35655931 |  |  | No Coverage
-2.17611484 |  |  | No Coverage
Spreadsheet: 682101d1591901586-extracting-lines-after-change-test
Sheet: Sheet1

ID | Invoice Number | ItemCode | LineAmount
1 | INVE0105742 | PARTS070 | 0
2 | INVE0105742 | PARTS070 | 0
3 | INVE0105742 | PARTS070 | 0
1158 | INVE0105742 | 5500N3VD | 0
1159 | INVE0105742 | 5500N3VD | 0
1160 | INVE0105742 | 5500N3VD | 0
9323 | INVE0105742 | D-5500-36-HHP | 0
9324 | INVE0105742 | D-5500-36-HHP | 0
9325 | INVE0105742 | D-5500-36-HHP | 0
11647 | INVE0105742 | D-5500-36-HUP | 0
11648 | INVE0105742 | D-5500-36-HUP | 0
11649 | INVE0105742 | D-5500-36-HUP | 0
40592 | INVE0105742 | D-5500-36-SUP | 0
40593 | INVE0105742 | D-5500-36-SUP | 0
40594 | INVE0105742 | D-5500-36-SUP | 0
3860 | INVE0106234 | PARTS045 | 70
3861 | INVE0106234 | PARTS045 | 70
3862 | INVE0106234 | PARTS045 | 70
7085 | INVE0106234 | FREIGHT | 3.79
7086 | INVE0106234 | FREIGHT | 3.79
7087 | INVE0106234 | FREIGHT | 3.79
Desired Results
1 | INVE0105742 | PARTS070 | 0
1158 | INVE0105742 | 5500N3VD | 0
9323 | INVE0105742 | D-5500-36-HHP | 0
11647 | INVE0105742 | D-5500-36-HUP | 0
40592 | INVE0105742 | D-5500-36-SUP | 0
3860 | INVE0106234 | PARTS045 | 70
7085 | INVE0106234 | FREIGHT | 3.79
Spreadsheet: 24894d1215788068-putting-text-in-a-referenced-cell-wallchart
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
Type | Group | [NAME] | Inventory Number | W/G | Code: | Price Category | Existing Cell |  |  |  |  |  |  | 24
 |  |  |  |  |  |  | A1 |  | -  -  -  -
Finish | Finish Color | Brownstone | 3G | N | I.FN1047-1 |  | A2 |  | Finish   - Finish Color - Brownstone - 3G
Finish | Finish Color | Dune | 7L | N | I.FN1111-1 |  | A3 |  | Finish   - Finish Color - Dune - 7L
Finish | Finish Color | [NAME] | 7m | n | I.FN1112-1 |  | A4 |  | Finish   - Finish Color - Chai - 7m
Finish | Finish Color | Grass | 7N | n | I.FN1113-1 |  | A5 |  | Finish   - Finish Color - Grass - 7N
Finish | Finish Color | Blue Ridge | 7U | N | I.FN1114-1 |  | A6 |  | Finish   - Finish Color - Blue Ridge - 7U
Finish | Finish Color | Loden | 7V | N | I.FN1117-1 |  | A7 |  | Finish   - Finish Color - Loden - 7V
Finish | Finish Color | Napa | 7W | N | I.FN1118-1 |  | A8 |  | Finish   - Finish Color - Napa - 7W
Finish | Finish Color | Sedona | 7Y | N | I.FN1119-1 |  | A9 |  | Finish   - Finish Color - Sedona - 7Y
Finish | Finish Color | Mink | 7Z | N | I.Fn1120-1 |  | A10 |  | Finish   - Finish Color - Mink - 7Z
Finish | Finish Color | [NAME] | 8Q | N | I.FN1061-1 |  | A11 |  | Finish   - Finish Color - Folkstone Grey - 8Q
Finish | Finish Color | Gull | 8T | N | I.FN1115-1 |  | A12 |  | Finish   - Finish Color - Gull - 8T
Finish | Finish Color | Moonbeam | 8Y | N | I.FN1116-1 |  | A13 |  | Finish   - Finish Color - Moonbeam - 8Y
Finish | Finish Color | White | 91 | N | I.FN1110-1 |  | A14 |  | Finish   - Finish Color - White - 91
Finish | Finish Color | Sparrow | 9J | N | I.FN1003-1 |  | A15 |  | Finish   - Finish Color - Sparrow - 9J
Finish | Finish Color | Blue Medium | B4 | N | I.FN1056-1 |  | A16 |  | Finish   - Finish Color - Blue Medium - B4
Finish | Finish Color | Black | BK | N | I.FN1018-1 |  | A17 |  | Finish   - Finish Color - Black - BK
Finish | Finish Color | Stonewash | BQ | N | I.FN1055-1 |  | A18 |  | Finish   - Finish Color - Stonewash - BQ
Finish | Finish Color | Black Umber | BU | N | I.FN1009-1 |  | A19 |  | Finish   - Finish Color - Black Umber - BU
Finish | Finish Color | Chrome/Polished Aluminum | CD/CH/L/PA | N | I.FN1002-1 |  | A20 |  | Finish   - Finish Color - Chrome/Polished Aluminum - CD/CH/L/PA
Finish | Finish Color | Cool Grey Neutral | CL | N | I.FN1014-1 |  | A21 |  | Finish   - Finish Color - Cool Grey Neutral - CL
Finish | Finish Color | [NAME] | CN | N | I.FN1052-1 |  | A22 |  | Finish   - Finish Color - Metallic Champagne - CN
Finish | Finish Color | [NAME] | EH | N | I.FN1121-1 |  | A23 |  | Finish   - Finish Color - Metallic Bronze - EH
Finish | Finish Color | Graphite | [NAME] | N | I.FN1048-1 |  | A24 |  | Finish   - Finish Color - Graphite - G1
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 15d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index/Index Tranche | 64409 | 206888 | 260876 | 85171 | 161149 | 145332
OTHER* | 0 | 0 | 9878 | 0 | 0 | 6540
TOTAL | 64409 | 206888 | 270754 | 85171 | 161149 | 151872
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 767825d1644664378-count-the-number-sample
Sheet: Vehicle Details

 |  |  |  |  |  |  |  |  |  | Answer (Only status=freight should be counted here)
 |  |  | NO | Name | Vehicle No | Amount | Status |  |  | No | Total Vehicle
 |  |  | 1111 | A | AP 16 TS 5657 | 35000 | Freight |  |  | 1111 | 2
 |  |  | 2222 | B | AP 31 TF 5899 | 48000 | Freight |  |  | 2222 | 2
 |  |  | 3333 | C | MH 09 FL 6622 | 69120 | Freight |  |  | 3333 | 1
 |  |  | 1111 | A | AP 16 TS 5657 | 5000 | Payment |  |  | 4444 | 2
 |  |  | 4444 | D | AP 16 TJ 5589 | 67500 | Freight
 |  |  | 4444 | D | AP 39 TV 2799 | 58900 | Freight
 |  |  | 2222 | B | AP 31 TF 5899 | 5000 | Payment
 |  |  | 3333 | C | MH 09 FL 6622 | 5000 | Payment
 |  |  | 1111 | A | AP 32 B 9866 | 70000 | Freight
 |  |  | 2222 | B | AP 16 GB 8945 | 50000 | Freight
Spreadsheet: 61589d1262526555-two-y-axis-both-using-same-data-series-frost-20iwi-20graphsv1-1-
Sheet: old results

OLD RESULTS SBM
 | Zone 1 |  | Zone 2 |  | Zone 3 |  | Zone 4
 | London |  | Oakley |  | Bristol |  | Swansea | Rawtenstall
None | 0 |  | 70.99 |  | 0 |  | 35.58 | 42.51
WF | 67.9 |  | 143.7 |  | 63.6 |  | 81.8 | 85.6
MW | 67.8 |  | 143.6 |  | 64 |  | 81.9 | 85.7
EPS | 68.2 |  | 144.3 |  | 65 |  | 83.1 | 86.2
PF | 68.2 |  | 144.2 |  | 66.1 |  | 84.6 | 86.8
 | red dotted line denotes frost threshold (75% wf)
 |  |  |  |  |  |  |  |  |  |  | frostI
FLETTON OLD RESULTS
 | Moisture content  of Stweartby Flettons on freezing with different types of internal wall insulation to 0.15W/m2K
 |  | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5
 |  | London | Oakley | Bristol | Swansea | Rawtenstall
 | None | 3.1 | 45.6 | 5 | 5.3 | 0
 | WF | 38.8 | 94.1 | 21.8 | 30.7 | 27.2
 | MW | 39 | 94.8 |  | 31.2 | 27.7
 | EPS | 39 | 94.6 | 24.8 | 31.3 | 49.5
 | PF | 39 | 93.6 | 19.7 | 31 | 27.8
 | red dotted line signifies frost threshold (75% wf)