tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676142d1588677253-index-and-match-returning-multiple-results-from-a-range-index-match-sample-problem
Sheet: Sheet1

 | List of ingredients: | Recipe used in: |  | Cake |  |  | Bread |  |  | Bread
 | Frosting | Cake |  | Ingredient 1: |  |  | Ingredient 1: |  |  | Ingredient 1:
 | Eggs | Cake, Bread |  | Ingredient 2: |  |  | Ingredient 2: |  |  | Ingredient 2:
 | Milk | Cake |  | Ingredient 3: |  |  | Ingredient 3: |  |  | Ingredient 3:
 | Water | Bread |  | Ingredient 4: |  |  | Ingredient 4:
 | Yeast | Bread |  | Ingredient 5:
 | Sugar | Cake
 | [NAME] | Bread, Pancakes |  |  | I'm not sure what to enter in the yellow fields to produce results as depicted below.
 | Cream | Cake
 | Butter | Pancakes
 | Syrup | Pancakes
 |  |  |  |  | Desired results would look like this table.
 |  |  |  | Cake |  |  | Bread |  |  | Bread
 |  |  |  | Ingredient 1: | Frosting |  | Ingredient 1: | Eggs |  | Ingredient 1: | [NAME]
 |  |  |  | Ingredient 2: | Eggs |  | Ingredient 2: | Water |  | Ingredient 2: | Butter
 |  |  |  | Ingredient 3: | Milk |  | Ingredient 3: | Yeast |  | Ingredient 3: | Syrup
 |  |  |  | Ingredient 4: | Sugar |  | Ingredient 4: | [NAME]
 |  |  |  | Ingredient 5: | Cream
Spreadsheet: 8af124d8-b0e9-4272-9bbf-b2dd91c638f7
Sheet: Operating

OPERATING/PROGRAMMATIC |  |  |  |  |  |  | 120430
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | To authorize Director of Convention and Entertainment
 | to enter into a contract with CVA of Greater Kansas City, Inc.
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | x | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY2011-12 |  |  | FY2012-13
 | General Fund |  |  |  | 0 |  |  | 0
 | Special Revenue |  |  |  |  |  |  | 425000
 | Enterprise
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | x | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY2011-12 |  |  | FY2012-13
 | General Fund |  |  |  | 0 |  |  | 0
 | Special Revenue |  |  |  |  |  |  | 425000
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 27946d1221689833-excel-2007-copying-and-pasting-condtional-formatting-prices-and-specs
Sheet: Mod Stats

Ship | Speed(m/s) | Cargo (m3) | Structure (HP) | Adaptions
[NAME] | 169 | 7500 | 1856 | Base
 | 108 | 16797 | 440 | Expanded Cargo Hold I x 5
 | 126 | 25270 | 608 | Expanded Cargo Hold II x 5
 | 265 | 3327 | 1856 | Overdrive Injector x 5
 | 272 | 3327 | 1856 | Type D Altered SS  Overdrive Injector x 5
Viator | 262 | 3750 | 3252 | Base
 | 203 | 7772 | 1665 | Expanded Cargo Hold II x 5
Spreadsheet: 34931d1232390196-auto-sum-formula-adding-20stuff-1-
Sheet: Sheet1

1
3 | 3
4 | 7
5 | 12
6 | 18
7 | 25
8 | 33
9 | 42
0 | 42
5 | 47
3 | 50
4 | 54
2 | 56
6 | 62
7 | 69
Spreadsheet: 123726d1317828624-returning-multiple-results-from-vlookup-copy-of-help-2
Sheet: Original Data

Company A | Product Description | Current Manufacturer | Current Product Number | Quantity Per Case | Similar or Identical | Company A Product Description | Quantity per Case
1000 | High | Comp d | 12 | 50 | S | high | 50
1000 | High | Comp e | 32 | 50 | S | high, twist | 50
1000 | High | Comp f | 42 | 50 | S | high, twist | 50
1000 | High | Comp f | 63 | 50 | S | high | 50
1000 | High | Comp e | 132 | 50 | S | high, twist swirel | 50
1000 | High | Comp t | 65 | 12 | S | high, twist swirel | 50
1000 | High | Comp r | 453 | 50 | I | twist, swirel | 50
1000 | High | Comp r | 3654-22 | 41 | S | twist, high | 50
1007 | Low | Comp e | 466 | 50 | S | L | 50
1007 | Low | Comp e | 123 | 50 | I | L+h | 50
1007 | Low | Comp f | 865 | 50 | S | L+h | 50
1007 | Low | Comp r | 435 | 50 | S | L | 50
1007 | Low | Comp t | 285 | 12 | S | L | 50
1007 | Low | Comp d | 143 | 12 | S | L+lh | 50
1007 | Low | Comp s | 8685 | 50 | S | L+h | 50
1007 | Low | Comp t | 234 | 50 | S | L | 50
1007 | Low | Comp h | 97-44 | 50 | S | L+lh | 50
1007 | Low | Comp f | 4325 | 50 | S | L | 50
1007 | Low | Comp f | 6657 | 50 | I | L | 50
1007 | Low | Comp f | 34 | 50 | I | L+h | 50
1007 | Low | Comp r | 2 | 50 | S | L+s | 50
1007 | Low | Comp t | 4786 | 50 | S | S | 50
1007 | Low | Comp t | 2345 | 12 | S | S | 50
1007 | Low | Comp t | 9869 | 50 | S | H | 50
1007 | Low | Comp f | 234 | 12 | S | H | 50
1007 | Low | Comp d | 785 | 12 | S | L | 50
1007 | Low | Comp e | 234 | 12 | S | H | 50
1009 | Med | Comp t | 73 | 50 | S | A | 50
1009 | Med | Comp e | 32 | 50 | S | AS | 50
1009 | Med | Comp e | 7642 | 50 | S | A | 50
1009 | Med | Comp e | 234 | 12 | I | AA | 50
1009 | Med | Comp f | 62 | 50 | S | AAA | 50
1009 | Med | Comp f | 243 | 50 | S | AAS | 50
1009 | Med | Comp r | 2435 | 12 | S | A | 50
1009 | Med | Comp e | 73 | 50 | S | AS | 50
1009 | Med | Comp f | 987 | 50 | S | AS | 50
Spreadsheet: 871486d1717912490-sum-exempt-vat-and-vateable-items-exempt-vat-aligw
Sheet: Invoice

 | I'm kindly asking for formula to calculate VAT and where VAT is exempt it will write exempt as shown in the desired solution, using the data on the Item  sheet
 | And if total items on the invoice are exempt, on Cell H44 write exempt and if all items on the invoice are 0% write 0% and if items are 15%, exempt and, or 0% write 15%
 |  |  |  |  |  |  |  |  |  |  | Desired Solution
 | Description |  |  |  | Quantity | Price | VAT | Total excl. VAT |  |  | Description |  |  |  | Quantity | Price | VAT | Total excl. VAT
 | sponge mix 25kg |  |  |  | 1 |  |  |  |  |  | metal  turntable |  |  |  | 1
 | sponge mix 25kg |  |  |  | 4 |  |  |  |  |  | sponge mix 25kg |  |  |  | 4 |  | Exempt
 | 10 inch board silver |  |  |  | 10 |  |  |  |  |  | 10 inch board silver |  |  |  | 10
 | sponge mix 25kg |  |  |  | 20 |  |  |  |  |  | 10 Cake dooms" |  |  |  | 20
 | 10 inch board silver |  |  |  | 29 |  |  |  |  |  | 12 inch baking tin |  |  |  | 29
 | 10 inch cake tins square |  |  |  | 4 |  |  |  |  |  | 10 inch cake tins square |  |  |  | 4 |  | Exempt
 |  |  |  |  |  | Sub total |  |  |  |  |  |  |  |  |  | Sub total
 |  |  |  |  |  | Discount | 0.1 |  |  |  |  |  |  |  |  | Discount | 0.1
 |  |  |  |  |  | Amount Excl Tax |  |  |  |  |  |  |  |  |  | Amount Excl Tax
 |  |  |  |  |  | VAT: |  |  |  |  |  |  |  |  |  | VAT: | 0.15
 |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  | Total
 | THANK YOU!
Spreadsheet: 3fbc0e69-b8fa-4ce5-9011-f3e6555cbf3d
Sheet: Sheet1

09/24805 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Puljen, andre kulturelle opgaver, diverse tilskud 2010
Budgettet for puljen udgør |  | netto | 353000
 |  |  | +restmidler fra 2008 (5305,00) herefter ialt 358.305 til rådighed
Ansøger: | Arrangement | Acadrenr. | [NAME] beløb | Bevilget beløb: | Nettoudgift | Tilskud/underskudsgaranti:
Styregruppen for Lejre kulturdage | Lejre Kulturdage | 09/24805 | 60000 | 55000 | 50600 | tilskud
Styregruppe for kulturnatten | Kulturnat 2010 | 10/1 | 80000 | 60000 | 55200 | Underskudsgaranti
[NAME] for [NAME] | [NAME] | 09/24972 | 4000 | 0 | 0
Musikforeningen | Sang Café | 10/988 | 13294 | 13294 | 12230.48 | tilskud
Styregruppen for Hvalsø kulturhus | Temaweekend | 10/1420 | 20000 | 20000 | 18400 | Underskudsgaranti
Kultunaut | Kultunaut 2010 |  | 25650 | 25650 | 23598
Kunstdage i pinsen | kunstdage |  | 4500 | 4500 | 4140
[NAME] | [NAME] | 10/5170 | 80000 | 50000 | 46000 | Underskudsgaranti
[NAME] | Sekretariatsbistand |  | 26794 | 26794 | 26794
Osted bylaug | Sommerkoncert | 10/8279 | 4000 | 4000 | 3680 | Underskudsgaranti
Lejre Musikskolen | [NAME] | 10/8769 | 25000 | 25000 | 23000 | Underskudsgaranti
KomVest | koncertaktiviteter | 10/9802 | 15000 | 15000 | 13800 | Underskudsgaranti
Smily Days | Musikfestival | 10/9285 | 17375 | 0 | 0
Høstfestival | Høstfestival | 10/11370 | 15000 | 15000 | 13800 | Underskudsgaranti
 |  |  | 390613 | 314238 | 291242.48
Forventet
[NAME] den 15.07.2010 | 67062.52 |  | konto 364.007.59.01
Spreadsheet: 1b810cca-8b01-4a1a-b08e-1a9f4acd4e19
Sheet: Sheet1

Table 8--Wheat: U.S. exports and imports for last 6 months (1,000 bushels), 7/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item |  | Nov | Dec | Jan | Feb | Mar | Apr
 |  | 2011 | 2011 | 2012 | 2012 | 2012 | 2012
Exports | All wheat grain | 61287.0674509317 | 72638.94776939221 | 71446.9193831526 | 68957.24431477141 | 86770.22803909531 | 103778.2448934
 | All wheat flour 1/ | 1182.22789550215 | 724.6641874465105 | 766.4467702242576 | 727.3769051867293 | 1151.665442573141 | 779.6496041287544
 | All wheat products 2/ | 590.3890889710959 | 516.2017512977295 | 564.9332796612778 | 720.1099419000456 | 731.1408444789558 | 861.8054622245811
 | Total all wheat | 63059.68443540495 | 73879.81370813644 | 72778.29943303815 | 70404.73116185819 | 88653.0343261474 | 105419.6999597533
Imports | All wheat grain | 7778.758318684501 | 8059.447301073001 | 7600.2476502603 | 7262.404908089101 | 10449.5319510246 | 6495.080158278602
 | All wheat flour 1/ | 894.7257383932828 | 828.4103513404835 | 1015.848956093801 | 823.7276552796673 | 863.686902021029 | 978.440444345295
 | All wheat products 2/ | 1697.331749228987 | 1642.153293160664 | 1588.438507200813 | 1267.596672426241 | 1710.450728002489 | 1657.370215401005
 | Total all wheat | 10370.81580630677 | 10530.01094557415 | 10204.53511355492 | 9353.729235795006 | 13023.66958104812 | 9130.890818024902
Totals may not add due to rounding. [NAME] in grain-equivalent bushels. Includes meal, groats, and durum. 2/ Expressed in grain-equivalent bushels. Includes bulgur, couscous, and selected categories of pasta. Source: U.S. Department of Commerce, U.S. Census Bureau, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Date run: 7/12/2012
Spreadsheet: 05a80bc4-5535-48d5-899e-25d2b3abd1f7
Sheet: SWCC - Clarke

Southwestern Community College Career Academies
2012-2013 Osceola Career Academy
Course Number | Course Title | Schedule | College Credit Hours | Contact Minutes | SCED Code           Replace 'uu' with sequencing | Comments
Construction (30 credits - 18 week schedule)
Year 1 - Fall Semester
CON 141 | Basic Construction Skills | M-F 8-11 am | 2 credits | 1920 | 17002C027uu
CON 183 | Construction Lab IA | M-F 8-11 am | 5 credits | 14280 | 17002C198uu
Year 1 - Spring Semester
CON 155 | Carpentry Level I | M-F 8-11 am | 3 credits | 3840 | 17003C053uu
CON 184 | Construction Lab IB | M-F 8-11 am | 5 credits | 12360 | 17002C172uu
Year 2 - Fall Semester
CON 188 | Construction Lab IIA | M-F 8-11 am | 5 credits | 12360 | 17002C172uu
CON 266 | Carpentry Lab IIA | M-F 8-11 am | 3 credits | 3840 | 17003C053uu
Year 2 - Spring Semester
CON 189 | Construction Lab IIB | M-F 8-11 am | 5 credits | 14280 | 17002C198uu
CON 267 | Carpentry Level IIB | M-F 8-11 am | 2 credits | 1920 | 17003C027uu
Spreadsheet: 696419d1600800541-how-to-efficiently-manage-trapping-value-and-n-a-errors-vault_gw
Sheet: Vault

Level 1 - 10 - Country Carnival & Level 6-10 State Challenge - 7th & 8th November 2020 Session 1 Gymnastics Club ABC & Gymnastics Club [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Please select one gymnast for the Springiest Vault Novelty Award | Please select one gymnast considered for the Sportmanship Novelty Award | Please select one gymnast considered for the Superhero Costume Novelty Award | Award Bagged
Club | Comp Number | First Name | Last Name | Level | Judge 1 |  | Judge 2 |  | Scratch | Average | Score | [NAME] | Springiest Vault | Sportmanship | Superhero Costume
 |  |  |  |  | Vault 1 | Vault 2 | Vault 1 | Vault 2
ABC | 1111 | Gymnast | One | 3 | 0 | 0 | 1
ABC | 2222 | Gymnast | Two | 4 | 2 | 3
ABC | 3333 | Gymnast | Three | 5 | 1 | nv | 2
XYZ | 9999 | Gymnast | One | 3 | 1
XYZ | 8888 | Gymnast | Two | 3
XYZ | 7777 | Gymnast | Three | 4
XYZ | 6666 | Gymnast | Four | 4
XYZ | 5555 | Gymnast | Five | 5
XYZ | 4444 | Gymnast | Six | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: sally_beck__33996__MgmtSum-Q201-Global-0420
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIVATE & CONFIDENTIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd QTR 2001 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT |  |  |  | Change - Fav / (Unfav)
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Margin | Expenses (1) | Total
Crude & Products
Coal
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight Markets
LNG
Puerto Rico
Finance and Structuring
Office of the Chairman
Overview
Total Commercial
Group Support Cost
Support Cost Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
Interest Expense/(Income)
Global Markets Pre-tax Income
(1) Includes direct and allocated expenses
 |  | Margin change from: 10/26/00 |  |  |  | Expense changes from: 10/26/00
 |  | DPR Change |  |  |  | Operating Expense
 |  | MPR Change |  |  |  | Commercial Expense
 |  | Other Margin Changes |  |  |  | Other
 |  | Total Change |  |  |  | Total Change
 |  | Total Margin - QTD |  |  |  | Total Expense
 |  | Prior Week: |  |  |  | Prior Week:
 |  | This Week: |  |  |  | This Week:
 |  | Change: |  |  |  | Change:
Spreadsheet: joe_parks__14959__BridgeDPR0503
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1153.3436989 | 3156.3436989 | 8447.3436989
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1153.3436989 | 3156.3436989 | 8447.3436989
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 40be2a76-1258-4aa0-8064-16349eb3b177
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF DECEMBER 22, 2014 THROUGH JANUARY 2, 2014
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, December 22, 2014
 | NO COURT PROCEEDINGS
Tuesday, December 23, 2014
02:00:00 | CA#9809-VCN | Vice Chancellor [NAME] | Oral Argument | Capella Holdings, Inc. v. [NAME] | Dover
Wednesday, December 24, 2014
 | NO COURT PROCEEDINGS
Thursday, December 25, 2014
 | COURTS CLOSED - MERRY CHRISTMAS
Friday, December 26, 2014
 | COURTS CLOSED
Monday, December 29, 2014
 | NO COURT PROCEEDINGS
Tuesday, December 30, 2014
10:00:00 | CA#10324-CB | Chancellor [NAME] | PI Hearing | [NAME], [NAME] v. World Energy Solutions, Inc. | [NAME]
Wednesday, December 31, 2014
 | NO COURT PROCEEDINGS
Thursday, January 1, 2015
 | COURTS CLOSED -
Friday, January 2, 2015
01:00:00 | CA#10398&10402-CB | Chancellor [NAME] | PI Hearing | New Maurice J. Moyer Academy, Inc., et [NAME]. Dept. of [NAME]., et [NAME]. | [NAME]
Spreadsheet: 794124d1661887797-lookup-with-conditions-2022-08-30-oeldere2-aboumtl-lookup-with-conditions
Sheet: Name

Name | Organisme
a
b
c
d
e
f
 | choice 1 to x = organismes affiliated with unique names
 | choice = the function
Spreadsheet: dan_hyvl__4877__Sent to Legal - Reliant
Sheet: Sheet1

Buyer | [NAME] | Deal No. | Originator | Broker | Type | Deal Date | Reason | Quantity | Comm | Delivery Ref | Index | Beg Date | End Date | N | Premium | Price
ENA | [NAME] | NQ0954.1 | [NAME] |  | Swap | 2000-07-07 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2001-01-31 00:00:00 | F |  | US 4.2600
ENA | [NAME] | NT8254.1 | Wallis Jan |  | Swap | 2000-08-03 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-10-01 00:00:00 | 2001-03-31 00:00:00 | F |  | US 4.2250
ENA | [NAME] | [NAME] | Wallis Jan |  | Swap | 2000-08-30 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | F |  | US 4.6900
ENA | [NAME] | NY4414.2 |  |  | Swap | 2000-09-07 00:00:00 | Sent to legal | 5000 [NAME]/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-10-01 00:00:00 | 2001-09-30 00:00:00 | F |  | US 4.5300
ENA | [NAME] | NY8330.1 |  |  | Swap | 2000-09-11 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2001-02-01 00:00:00 | 2001-08-31 00:00:00 | P |  | US 4.4200
ENA | RELIANTENESER | NZ7026.1 | Wallis Jan |  | Swap | 2000-09-15 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-10-01 00:00:00 | 2000-11-30 00:00:00 | F |  | US 5.3500
[NAME] | ENA | NO0793.2 |  |  | Swap | 2000-06-27 00:00:00 | Sent to legal | 20000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-07-01 00:00:00 | 2000-10-31 00:00:00 | F |  | US 4.4925
[NAME] | ENA | NP4359.1 | [NAME] |  | Swap | 2000-06-30 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | F |  | US 4.4650
[NAME] | ENA | NP4459.1 | Wallis Jan |  | Swap | 2000-06-30 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | F |  | US 4.4500
[NAME] | ENA | NP5288.1 |  |  | Swap | 2000-07-05 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | F |  | US 4.2400
[NAME] | ENA | NP5288.2 |  |  | Swap | 2000-07-05 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | F |  | US 4.2750
[NAME] | ENA | NP8804.1 | [NAME] |  | Swap | 2000-07-06 00:00:00 | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2001-01-31 00:00:00 | F |  | US 4.1750
RELIANTENESER | ENA | NY4684.1 | [NAME] | Amerex | Forward | 2000-09-07 00:00:00 | Sent to legal | 20000 MMBtu/day | NG | IF-ANR/LA |  | 2000-11-01 00:00:00 | 2001-03-31 00:00:00 | P |  | US 0.0150
Spreadsheet: 814298d1674264166-look-up-same-requirements-output-different-results-automated-schedule-gk
Sheet: Workers

Date | Activity | Results |  |  | Notes
2023-04-01 00:00:00 | Work |  |  |  | This is to build an automated schedule. The "Work, Work, and Help" all start on the same day.  I would like C2,C3, and C4 to display the person from the "schedule" sheet in row C into the corrosponding activity. For example C2,C3, and C4 would all reference A2.  C5,C6,C7 would all reference A5  C8, C9, C10 would all reference A7
2023-04-02 00:00:00 | Work
2023-04-03 00:00:00 | Help
2023-04-04 00:00:00 | Work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected Results
2023-04-05 00:00:00 | Work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Activity | Results
2023-04-06 00:00:00 | Help |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00 | Work | [NAME]
2023-04-07 00:00:00 | Work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-02 00:00:00 | Work | [NAME]
2023-04-08 00:00:00 | Work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-03 00:00:00 | Help | [NAME]
2023-04-09 00:00:00 | Help |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-04 00:00:00 | Work | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-05 00:00:00 | Work | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-06 00:00:00 | Help | Cameron
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-07 00:00:00 | Work | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-08 00:00:00 | Work | Helen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-09 00:00:00 | Help | [NAME]
Spreadsheet: 716729d1612345285-beginner-help-formula-across-2-sheets-help
Sheet: Sheet1

ID | Code | Comments
4 | Flagged | Good!
4 | Flagged | Easy!
4 | X | Hi
5 | X | Hello
5 | Flagged | Yes!
5 | Flagged | Great!
5 | X | No
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1
2
3
4
5 | -214
6 | -705
7 | -18575 | -34000
8 | -286 | -23996
9 | -25195 | -20832
10 | -33303 | -32500
11 | -25560 | -26902
12 | -90
13
14 | -66 | -6981
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 67742.52
2002-01-14 00:00:00
CBS Volume
 |  |  | 36151
Spreadsheet: 90533d1290255321-hyperlink-formula-doesnt-show-text-test-hyperlink
Sheet: IndiceBaseDados

 |  |  |  | A | A | B | C | TOTAL | B | A | B | C | TOTAL
ARG | 1 |  | M3
ARG | 2 |  | M3
ARG | 3 |  | M3
ARG | 4 |  | M3
ARG | 5 |  | M3
ARG | 6 |  | M3
ARG | 7 |  | M3
ARG | 8 |  | M3
ARG | 9 |  | M3
ARG | 10 |  | M3
ARG | 11 |  | M3
ARG | 12 |  | M3
ARG | 13 |  | M3
ARG | 14 |  | M3
ARG | 15 |  | M3
ARG | 16 |  | M3
ARG | 17 |  | M3
ARG | 18 |  | M3
Spreadsheet: 775101d1648822313-if-function-using-and-with-dates-example_1
Sheet: Sheet1

Entry | Exit
2021-11-26 00:00:00 | 2021-12-22 00:00:00
2021-11-26 00:00:00 | 2021-12-22 00:00:00
2021-12-03 00:00:00 | 2021-12-11 00:00:00
2021-12-22 00:00:00 | 2022-02-10 00:00:00
2022-01-06 00:00:00 | On
2022-01-07 00:00:00 | 2022-01-22 00:00:00
2022-01-07 00:00:00 | On
2022-01-07 00:00:00 | 2022-01-24 00:00:00
2022-01-07 00:00:00 | 2022-01-24 00:00:00
2022-01-07 00:00:00 | 2022-01-28 00:00:00
2022-01-07 00:00:00 | 2022-01-24 00:00:00
2022-01-07 00:00:00 | 2022-01-25 00:00:00
2022-01-07 00:00:00 | 2022-01-24 00:00:00
2022-01-07 00:00:00 | 2022-01-22 00:00:00
2022-01-08 00:00:00 | 2022-02-04 00:00:00
2022-01-11 00:00:00 | 2022-01-31 00:00:00
2022-01-13 00:00:00 | 2022-03-02 00:00:00
2022-02-01 00:00:00 | 2022-03-18 00:00:00
2022-02-04 00:00:00 | On HFH
2022-02-07 00:00:00 | 2022-02-23 00:00:00