tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217240d1362007523-populating-a-drop-down-list-dependent-on-multiple-matching-variables-ac-workbook
Sheet: Test

 | Country | City | Street |  | Netherlands | Britain | Germany
[NAME] | Netherlands | Amsterdam | Amsterdam Street 1
[NAME] |  |  |  |  | Amsterdam | London | Bonn
[NAME] |  |  |  |  | [NAME] | Canterbury | Berlin
 |  |  |  |  | Eindhoven | [NAME] | Munich
 |  |  |  |  | Amsterdam Street 1 | London Street 1 | Bonn Street 1
 |  |  |  |  | Amsterdam Street 2 | London Street 2 | Bonn Street 2
 |  |  |  |  | Rotterdam Street 1 | Canterbury Street 1 | Berlin Street 1
 |  |  |  |  | Rotterdam Street 2 | Canterbury Street 2 | Berlin Street 2
 |  |  |  |  | Eindhoven Street 1 | Manchester Street 1 | Munich Street 1
 |  |  |  |  | Eindhoven Street 2 | Manchester Street 2 | Munich Street 2
Spreadsheet: 731839d1620638172-count-in-a-range-along-a-row-instances-that-occur-only-on-before-today-of-a-value-anonymised-blue-green-mauve-red
Sheet: GREEN

GREEN ENTITIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS PER ENTITY |  |  |  | 169208142
 |  |  | 2021-03-02 00:00:00 | 2021-03-09 00:00:00 | 2021-03-16 00:00:00 | 2021-03-23 00:00:00 | 2021-03-30 00:00:00 | 2021-04-06 00:00:00 | 2021-04-13 00:00:00 | 2021-04-20 00:00:00 | 2021-04-27 00:00:00 | 2021-05-04 00:00:00 | 2021-05-11 00:00:00 | 2021-05-18 00:00:00 | 2021-05-25 00:00:00 | @ | % | ! | _
 | Roxane | Darlena | @ | @ | @ | @ | @ | @ | @ | @ | ! | @ | @ | @ | @ |  |  |  |  |  | 226,239,218
 | Clay | Kelley | @ | @ | @ | @ | _ | @ | _ | _ | @ | _ | @ | @ | @ |  |  |  |  |  | @
 | [NAME] | Retta | @ | _ | @ | @ | @ | @ | @ | ! | @ | @ | @ | @ | @ |  |  |  |  |  | %
 | [NAME] | [NAME] | @ | @ | @ | @ | ! | @ | ! | @ | @ | ! | @ | @ | @ |  |  |  |  |  | !
 | [NAME] | [NAME] | @ | @ | @ | @ | ! | @ | @ | @ | @ | @ | @ | @ | @ |  |  |  |  |  | F | FLOATING
 | Tatyana | Darrel | ! | @ | % | _ | _ | _ | _ | _ | @ | _ | @ | @ | @ |  |  |  |  |  | _ | [NAME]
 | [NAME] | [NAME] | @ | @ | _ | @ | @ | @ | @ | % | @ | @ | @ | @ | @ |  |  |  |  |  | N/A
 | [NAME] | Ramiro | ! | ! | % | ! | ! | ! | ! | % | @ | ! | @ | @ | @ |  |  |  |  |  |  | follow up
 | [NAME] | [NAME] | % | % | % | % | % | % | % | _ | % | % | @ | @ | @
 | Carlotta | [NAME] | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 green entities
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 green entities |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Increase/decrease
_  s N/A
_  s N/A
 | confirm
Spreadsheet: 098334f7-6e72-49dc-972c-c10a18913793
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 8/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2010/11 | Q1 Sep-Nov | 126.248 | 65.111 | 66.286 | 1240.169 | 33.02 | 49.115 | 0 | 1579.949
 | [NAME] | 116.275 | 59.718 | 62.534 | 1257.314 | 34.588 | 48.575 | 0 | 1579.004
 | [NAME] | 138.897 | 70.856 | 64.409 | 1259.428 | 36.164 | 49.655 | 20.24 | 1639.649
 | [NAME] | 139.635 | 76.694 | 64.697 | 1264.303 | 31.228 | 49.655 | 2.76 | 1628.972
 | MY Sep-Aug | 521.055 | 272.379 | 257.926 | 5021.214 | 135 | 197 | 23 | 6427.574
2011/12 | Q1 Sep-Nov | 119.607 | 77.97 | 64.635 | 1268.06 | 33.02 | 50.1 | 0 | 1613.392
 | [NAME] | 114.999 | 71.005 | 62.018 | 1304.439 | 34.588 | 50.1 | 0 | 1637.149
 | [NAME] | 135.734 | 73.136 | 62.214 | 1246.548 | 36.164 | 49.899 | 23.401 | 1627.096
 | MY Sep-Aug | 495 | 285 | 250 | 5000 | 135 | 200.7 | 24.3 | 6390
2012/13 | MY Sep-Aug | 465 | 285 | 235 | 4500 | 135 | 205 | 25 | 5850
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 8/14/2012
ERRATA: On August (date), 2012, Table 5 was replaced with an updated table.
Spreadsheet: 808383d1670436071-sales-order-sequence-when-customer-repeating-sequence-numbering
Sheet: Sheet1

Date | Customer | Sequence
2022-01-01 00:00:00 | A | 1 |  |  |  |  | Customer Orders repeated on different dates
2022-01-01 00:00:00 | A | 1 |  |  |  |  | I want to add sequence numbers for each occurrence
2022-01-01 00:00:00 | A | 1 |  |  |  |  | Customer A placed 3 orders on different dates.
2022-01-01 00:00:00 | B | 1 |  |  |  |  | I am trying to add sequence numbers as highlighted
2022-01-01 00:00:00 | B | 1
2022-02-01 00:00:00 | C | 1
2022-02-01 00:00:00 | C | 1
2022-02-01 00:00:00 | C | 1
2022-02-01 00:00:00 | C | 1
2022-04-01 00:00:00 | A | 2
2022-04-01 00:00:00 | A | 2
2022-04-01 00:00:00 | A | 2
2022-10-01 00:00:00 | C | 2
2022-10-01 00:00:00 | C | 2
2022-10-01 00:00:00 | C | 2
2022-10-01 00:00:00 | C | 2
2022-10-01 00:00:00 | A | 3
2022-10-01 00:00:00 | A | 3
2022-10-01 00:00:00 | A | 3
Spreadsheet: 62593d1263502268-subtract-time-nursing-scheduling-spreadsheet2010
Sheet: Data

Department | Shift
Dr. [NAME] | 1st
Dr. [NAME] | 2nd
Dr. [NAME] | Off
Dr. [NAME] | Sick
Dr. [NAME] | Per Day
Dr. [NAME] | Vacation
Dr. Francillion
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Dr. [NAME]
Surgery
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: Input

2000-08-31 00:00:00 |  | Price-NSS1 |  |  |  |  |  |  |  |  |  |  |  | ignore this
 |  | Basis-NSS1
 |  | Index-NSS1
 |  | Price-NSS2
 |  | Basis-NSS2
 |  | Index-NSS2
 |  | Price-MEH
 |  | Basis-MEH
 |  | Index-MEH
 |  | TP-EMWNSS
 |  | TP-EMWNSS
 |  | TP-EMWNSS
Spreadsheet: 691642d1597806952-need-help-with-a-formula-using-multiple-criteria-cant-find-a-solution-anywhere-example
Sheet: Sheet1

Name | Label | Tests | Q_YEAR | Name/Label | 2019-Q1 | 2019-Q2 | 2020-Q1 | 2020-Q2
[NAME] | Blue | 1416 | 2019-Q1 |  | 1 |  |  | 1 |  | I've used [NAME] and [NAME] as examples. I'd like a 1 to appear if the name/label has tests for the year/quarter on any row where their name appears.
[NAME] | Red | 2205 | 2019-Q2 |  | 1 | 1
[NAME] | Red | 5048 | 2019-Q1
[NAME] | Purple | 1620 | 2020-Q1
[NAME] | Blue | 8505 | 2020-Q2 |  | 1 |  |  | 1
[NAME] | Red | 5682 | 2019-Q1 |  | 1 | 1
Spreadsheet: 0f0ad938-56c8-4462-b8bc-8f292ca48fc1
Sheet: Funding Source codes

 |  | SFY 2013 STATE CODE SHEET
SFY 2013 STATE EDRS-UFARS codes crosswalk
UFARS Finance Dimensions (FIN) to EDRS Funding Source Codes (FSC)
UFARS FIN | EDRS FSC | [NAME]
740 | A | Program Aid - Regular School Year
740 | C | Alternative Delivery of Specialized Instructional Services - Regulat School Year
741 | c | Part C Infants and Toddlers Birth-2 NEW
740 | E | Program Aid - Extended School Year (July-August 2012 and June 2013)
372 | i | Third Party Revenue/Expenditures Extended School Year
372 | j | Third Party Revenue/Expenditures Regular School Year
740 | M | Court Placement (Non-Minnesota Resident) (ENTERED BY MDE)
740 | N | Alternative Delivery of Specialized Instructional Services - Extended School Year
740 | P | Out-of State Tuition (Minnesota Residents with IEP's) (ENTERED BY MDE)
799 | R | Local Collaborative Time Study (LCTS)
756 | U | Full State Payment - Pupils with IEP's (ENTERED BY MDE)
761 | X | Full State Payment - Pupils without IEP's (ENTERED BY MDE)
Spreadsheet: 2e20a7ff-6183-43aa-a390-b4fbc8a119b8
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-04-01 09:20:19.940000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.832 | 101.582 | 101.457 | 101.082 |  | and are added to price quote
5.125 | 100.844 | 100.594 | 100.469 | 100.094
5 | 100.406 | 100.156 | 100.031 | 99.656 |  | Note: | Refer To Price [NAME]
4.875 | 99.913 | 99.663 | 99.538 | 99.163 |  |  | For all Price Adjs
4.75 | 98.893 | 98.643 | 98.518
4.625 | 97.755 | 97.505 | 97.38
 |  |  |  |  |  | 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.375 | 100.945 | 100.695 | 100.57 | 100.195
4.25 | 100.371 | 100.121 | 99.996 | 99.621
4.125 | 99.371 | 99.121 | 98.996 | 98.621
4 | 99.026 | 98.776 | 98.651 | 98.276
3.875 | 98.57 | 98.32 | 98.195
 |  |  |  |  |  | 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: |  |  | 2011-03-28 09:32:41.950000
 |  |  |  |  |  | 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-04-11 09:32:41.950000
30 DAY | 2011-04-26 09:32:41.950000
45 DAY | 2011-05-11 09:32:41.950000
60 DAY | 2011-05-26 09:32:41.950000
90 DAY | 2011-06-25 09:32:41.950000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 797655d1664026218-ifs-to-return-dynamic-spill-range-ifs-to-return-dynamic-array
Sheet: Sheet1

Fiscal year/period | Cost Element | Cost Category | Cost Category of Interest |  | Desired Result (in a dynamic spill range)
JAN 2022 | 608500 | Material |  |  | Exclude
JAN 2022 | 608500 | Material | Material |  | Exclude | Material
JAN 2022 | 608500 | Material | Material |  | Exclude | Material
JAN 2022 | 610000 | Contractor | Contractor |  | Contractor | Contractor
JAN 2022 | 630100 | Personnel Costs | Personnel Costs |  | Personnel Costs | Personnel Costs
MAR 2022 | 91002 | Personnel Costs | Personnel Costs |  | Exclude - Cost Category of Interest | Exclude - Cost Category of Interest
MAR 2022 | 93000 | Contractor | Contractor |  | Exclude - Cost Category of Interest | Exclude - Cost Category of Interest
MAR 2022 | 94000 | Personnel Costs | Personnel Costs |  | Exclude - Cost Category of Interest | Exclude - Cost Category of Interest
MAR 2022 | 94000 | Personnel Costs | Personnel Costs |  | Exclude - Cost Category of Interest | Exclude - Cost Category of Interest
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -89270 | -72220 | 0 | -16950
2 | -96891 | -72220 | 0 | -24950 |  |  |  |  |  |  |  |  |  | Avg
3 | -97853 | -72220 |  | -24950 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -102776 | -77338 |  | -24624
5 | -85125 | -69960 |  | -14933
6 |  |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-08-31 00:00:00 |  |  | 472010
 |  |  |  | 2001-09-05 00:00:00
 | CBS Volume
 |  |  |  | 115270
Spreadsheet: 546776d1510198034-fill-summary-sheet-from-multiple-tabs-with-different-names-workers-comp
Sheet: SUMMARY

NAME | SITE | DOI | INJURY | COC | REVIEW | FINAL
Spreadsheet: 743009d1628166635-looking-up-by-two-variables-tesing
Sheet: Sheet1

Order Date | Total Invoice | Deposit | Name | 2nd Payment | 3rd payment | Total | Payment status | Order Details | Code
2021-07-24 00:00:00 | 4439 | 99 | [NAME] | 4340 |  |  |  | Ex-Display Chestfield | 880
2021-07-24 00:00:00 | 6000 | 99 | Booth |  |  |  |  |  | 451
2021-07-23 00:00:00 | 6169 | 3084.5 | [NAME] |  |  |  |  | SO-091270 | 455
2021-07-25 00:00:00 | 4995 | 2448 | [NAME] | 2448 |  |  |  |  | 913
2021-07-25 00:00:00 | 5995 | 2998 | Wylie |  |  |  |  |  | 451
2021-07-25 00:00:00 | 4995 | 99 | Barden |  |  |  |  |  | 913
2021-07-24 00:00:00 | 5479 | 99 | Shaw |  |  |  |  |  | 452
2021-07-27 00:00:00 | 4995 | 2448 | Upton |  |  |  |  |  | 912
2021-07-27 00:00:00 | 5995 | 99 | Riches |  |  |  |  |  | 451
2021-07-27 00:00:00 | 6075 | 99 | Damalitis |  |  |  |  | In Stock at [NAME] | 451
2021-07-28 00:00:00 | 6995 | 3497.5 | [NAME] |  |  |  |  |  | 453
2021-07-29 00:00:00 | 4104 | 2002.5 | [NAME] |  |  |  |  |  | 888
2021-07-30 00:00:00 | 6224 | 99 | Moodey |  |  |  |  |  | 451
Spreadsheet: c4978a63-0979-4217-9017-33461217580f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5209 | 30601 | Clare | Cunningham | GBR | 0 | 00:28:10 | 00:01:37 | 01:25:12 | 00:01:27 | 00:38:55 | 1 | 02:35:21
Spreadsheet: e8e13368-ec01-452c-8eda-7f7c650c3e1e
Sheet: Sheet1

Release: Financial Soundness Indicators | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=238
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-10 7:44 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Financial Soundness Indicators | 2011-11-01 00:00:00 | Current
Link:
http://fsi.imf.org/ | 2011-11-01 00:00:00 | Current
Source:
International Monetary Fund | 2011-11-01 00:00:00 | Current
Notes:
The Financial Soundness Indicators (FSIs) were developed by the IMF, | 2011-11-01 00:00:00 | Current
together with the international community, with the aim of supporting
macroprudential analysis and assessing strengths and vulnerabilities
of financial systems.
The website, hosted by the Statistics Department of the IMF,
disseminates data and metadata on selected FSIs provided by
participating countries. For a description of the various FSIs, as
well as the consolidation basis, consolidation adjustments, and
(http://fsi.imf.org/misc/FSI%20Concepts%20and%20Definitions.pdf). The
Statistics Department will steadily increase the number of countries
reporting FSIs for dissemination on this site.
Reporting countries compile FSI data presented on this website by
using different methodologies, which may also vary for different
points in time for the same country. Users are advised to consult the
accompanying [NAME] (http://fsi.imf.org/CountryList.aspx) to conduct
more meaningful cross-country comparisons or to assess the evolution
of a given FSI for any of the countries. For a customized search of
the database please use the the query builder
(http://elibrary-data.imf.org/QueryBuilder.aspx?s=322&key=1445284&f=1&ts=1&ys=2002&ye=2011&ms=1&me=12&ds=1&de=31&did=323&id=195)
in IMF eLibrary Data.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-11-01 00:00:00
2012-02-08 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-06-29 00:00:00
2012-08-02 00:00:00
2012-10-01 00:00:00
2012-11-15 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-02 00:00:00
2014-01-01 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
Spreadsheet: 676564d1588870270-who-supplies-what-example
Sheet: Sheet2

Apples
Bananas
Strawberries
Blackberries
Pineapples
Spreadsheet: debra_perlingiere__8517__enronnoam deals - nov 01
Sheet: enronnoam deals - nov 01

DEAL ID | START | STOP | METER | PIPE | FIXED PRICE | VOLUME | GROUP PRICE | DEAL TYPE
KJM-0111-P-046-02 | 2001-11-10 00:00:00 | 2001-11-12 00:00:00 | DAWN | UNION | 2.8 | 9000 Dth | 2.800000 | DAILY FIRM
KJM-0111-P-046-01 | 2001-11-10 00:00:00 | 2001-11-12 00:00:00 | DAWN | UNION | 2.855 | 20000 Dth | 2.855000 | DAILY FIRM
KJM-0111-S-009-01 | 2001-11-01 00:00:00 | 2001-11-01 00:00:00 | DAWN | UNION | 3.335 | 10000 Dth | 3.335000 | DAILY FIRM
KJM-0111-S-007-02 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | DAWN | UNION | 3.32 | 5000 Dth | 3.320000 | FIRM
KJM-0111-S-007-01 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | DAWN | UNION | 3.315 | 5000 Dth | 3.315000 | FIRM
KJM-0111-S-011-01 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | DAWN | UNION | 3.23 | 10000 Dth | 3.230000 | FIRM
KJM-0111-S-006-01 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | DAWN | UNION | 0 | 10000 Dth | NYMEX @ Henry Hub NYMEX Final Settlement Price Plus $0.20 | FIRM
KJM-0111-S-016-02 | 2001-11-02 00:00:00 | 2001-11-02 00:00:00 | DAWN | UNION | 3.15 | 5071 Dth | 3.150000 | DAILY FIRM
KJM-0111-S-016-04 | 2001-11-02 00:00:00 | 2001-11-02 00:00:00 | DAWN | UNION | 3.145 | 10000 Dth | 3.145000 | DAILY FIRM
KJM-0111-S-016-03 | 2001-11-02 00:00:00 | 2001-11-02 00:00:00 | DAWN | UNION | 3.16 | 5000n Dth | 3.160000 | DAILY FIRM
KJM-0111-S-022-01 | 2001-11-03 00:00:00 | 2001-11-05 00:00:00 | DAWN | UNION | 3.16 | 1896 Dth | 3.160000 | DAILY FIRM
KJM-0111-S-021-01 | 2001-11-03 00:00:00 | 2001-11-05 00:00:00 | DAWN | UNION | 3.09 | 5700 Dth | 3.090000 | DAILY FIRM
KJM-0111-S-024-02 | 2001-11-06 00:00:00 | 2001-11-06 00:00:00 | DAWN | UNION | 3 | 2843 Dth | 3.000000 | DAILY FIRM
KJM-0111-S-024-01 | 2001-11-06 00:00:00 | 2001-11-06 00:00:00 | DAWN | UNION | 3.01 | 30000 Dth | 3.010000 | DAILY FIRM
KJM-0111-S-031-01 | 2001-11-07 00:00:00 | 2001-11-07 00:00:00 | DAWN | UNION | 2.895 | 4739 Dth | 2.895000 | DAILY FIRM
KJM-0111-S-031-03 | 2001-11-07 00:00:00 | 2001-11-07 00:00:00 | DAWN | UNION | 2.9 | 20000 Dth | 2.900000 | DAILY FIRM
KJM-0111-S-031-02 | 2001-11-07 00:00:00 | 2001-11-07 00:00:00 | DAWN | UNION | 2.92 | 10000 Dth | 2.920000 | DAILY FIRM
Spreadsheet: 840142d1692481141-need-help-with-iferror-function-returning-zero-instead-of-blank-book2
Sheet: Ratio-Monthly

 |  |  |  |  |  |  |  |  |  |  |  | January 23
 |  | DAYS |  |  |  | NIGHTS |  |  |  |  | DAY RATIO |  |  | NIGHT RATIO
 | Date | Census | RN | Supp.Staff |  | Census | RN | Supp.Staff |  |  | RN | Supp.Staff |  | RN | Supp.Staff
SUN | 1
MON | 2
TUE | 3
WED | 4
THU | 5
FRI | 6
SAT | 7
SUN | 8
MON | 9
TUE | 10
WED | 11
THU | 12
FRI | 13
SAT | 14
SUN | 15
MON | 16
TUE | 17
WED | 18
THU | 19
FRI | 20
SAT | 21
SUN | 22
MON | 23
TUE | 24
WED | 25
THU | 26
FRI | 27
SAT | 28
SUN | 29
MON | 30
TUE | 31
 | Total
 | avg
 |  |  |  |  |  |  |  |  |  |  |  | February 23
 |  | DAYS |  |  |  | NIGHTS |  |  |  |  | DAY RATIO |  |  | NIGHT RATIO
 | Date | Census | RN | Supp.Staff |  | Census | RN | Supp.Staff |  |  | RN | Supp.Staff |  | RN | Supp.Staff
WED | 1
THU | 2
FRI | 3
SAT | 4
SUN | 5
MON | 6
TUE | 7
WED | 8
THU | 9
FRI | 10
SAT | 11
SUN | 12
MON | 13
TUE | 14
WED | 15
THU | 16
FRI | 17
SAT | 18
SUN | 19
MON | 20
TUE | 21
WED | 22
THU | 23
FRI | 24
SAT | 25
SUN | 26
MON | 27
TUE | 28
 | Total
 | avg
 |  |  |  |  |  |  |  |  |  |  |  | March 23
 |  | DAYS |  |  |  | NIGHTS |  |  |  |  | DAY RATIO |  |  | NIGHT RATIO
 | Date | Census | RN | Supp.Staff |  | Census | RN | Supp.Staff |  |  | RN | Supp.Staff |  | RN | Supp.Staff
WED | 1
THU | 2
FRI | 3
SAT | 4
SUN | 5
MON | 6
TUE | 7
WED | 8
THU | 9
FRI | 10
SAT | 11
SUN | 12
MON | 13
TUE | 14
WED | 15
THU | 16
FRI | 17
SAT | 18
SUN | 19
MON | 20
TUE | 21
WED | 22
THU | 23
FRI | 24
SAT | 25
SUN | 26
MON | 27
TUE | 28
WED | 29
THU | 30
FRI | 31
 | Total
 | avg
Spreadsheet: 836081d1689080664-vlookup-formula-which-will-return-the-assignments-name-from-sheet-2-into-sheet-1by-namei-demo
Sheet: Sheet1

Project Owner | Project: Name | Project: Reference Number | Assignments
A | nxjnx | 123 | [NAME]
A | dnks | 456 | [NAME]
A | c ksnc | 789 | [NAME]
E | ncjksc | 987 | [NAME]
F | sncknc | 765 | [NAME]
G | ndsjkcn | 543 | [NAME]
H | ndjs | 321 | [NAME]
I | sn dn | 145 | [NAME]
Spreadsheet: 207590d1358506297-filling-a-list-from-the-top-example
Sheet: Overview

 | Item | Description | date on | Date off | owner | contact
 | H1 | Tenerife | 2012-01-16 00:00:00 | 2012-02-18 00:00:00 | ZZ | 6162
 | H3 | Hawaii | 2012-01-22 00:00:00 | 2012-02-24 00:00:00 | AA | 1111
 | H4 | Scotland | 2012-01-25 00:00:00 | 2012-02-27 00:00:00 | BB | 2222
 | H8 | Sweden | 2012-02-06 00:00:00 | 2012-03-10 00:00:00 | FF | 6666
Spreadsheet: 855058d1704781852-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker-aligw
Sheet: Oct

 |  |  |  |  |  | CALENDAR MONTH | OCTOBER
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 220030d1363037230-solver-sampler_1
Sheet: Sheet1

AMOUNT | Dates
-152810.47 | 2013-01-12 00:00:00
-15045.29 | 2013-01-12 00:00:00
-7640.52 | 2013-01-12 00:00:00
-320.33 | 2013-01-12 00:00:00
127086.23 | 2013-01-12 00:00:00
-79222.11 | 2013-02-12 00:00:00
-9066.14 | 2013-02-12 00:00:00
-3961.11 | 2013-02-12 00:00:00
49446.68 | 2013-02-12 00:00:00
109133.09 | 2013-02-12 00:00:00
-53423.02 | 2013-03-12 00:00:00
-11365.9 | 2013-03-12 00:00:00
-4644.2 | 2013-03-12 00:00:00
-65.38 | 2013-03-12 00:00:00
195047.53 | 2013-03-12 00:00:00
-82378.79 | 2013-04-12 00:00:00
-8337.68 | 2013-04-12 00:00:00
-4118.94 | 2013-04-12 00:00:00
151905.28 | 2013-04-12 00:00:00
-88820.97 | 2013-05-12 00:00:00
-9495.89 | 2013-05-12 00:00:00
-4438.12 | 2013-05-12 00:00:00
145832.74 | 2013-05-12 00:00:00
-5207.02 | 2013-06-12 00:00:00
-109396.71 | 2013-06-12 00:00:00
-5181.15 | 2013-06-12 00:00:00
226088.86 | 2013-06-12 00:00:00
-17249.5 | 2013-07-12 00:00:00
-188665.63 | 2013-07-12 00:00:00
89984.72 | 2013-07-12 00:00:00
274931.68 | 2013-07-12 00:00:00
-37.38 | 2013-08-12 00:00:00
-10540.96 | 2013-08-12 00:00:00
-102711.36 | 2013-08-12 00:00:00
4.18 | 2013-08-12 00:00:00
198817.26 | 2013-08-12 00:00:00
-153.24 | 2013-09-12 00:00:00
-6277.32 | 2013-09-12 00:00:00
-111832.52 | 2013-09-12 00:00:00
226293.44 | 2013-09-12 00:00:00
-12342.93 | 2013-10-12 00:00:00
-114628.65 | 2013-10-12 00:00:00
35740.69 | 2013-10-12 00:00:00
15555.3 | 2013-10-12 00:00:00
34587.76 | 2013-10-12 00:00:00
-70328.45 | 2013-10-12 00:00:00 | Sum of row 47 & 49 equals to sum of row 44,45,46 & 48
15053.51 | 2013-10-12 00:00:00
-30608.81 | 2013-10-12 00:00:00
-12175.47 | 2013-11-12 00:00:00
3.18 | 2013-11-12 00:00:00
-222.24 | 2013-12-12 00:00:00
-18054.6 | 2013-12-12 00:00:00
-88081.24 | 2013-12-12 00:00:00
239206.82 | 2013-12-12 00:00:00