tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883311d1731917413-cumulative-value-graph-in-pivot-chart-test2
Sheet: Sheet1

Department | Month-Year | Product 1 | Product 2
A | 2024-01-01 00:00:00 | 4 | 0
B | 2024-01-01 00:00:00 | 0 | 0
C | 2024-01-01 00:00:00 | 0 | 1
D | 2024-01-01 00:00:00 | 1 | 0
E | 2024-01-01 00:00:00 | 0 | 1
F | 2024-01-01 00:00:00 | 0 | 1
G | 2024-01-01 00:00:00 | 0 | 0
H | 2024-01-01 00:00:00 | 0 | 0
A | 2024-02-01 00:00:00 | 4 | 1
B | 2024-02-01 00:00:00 | 1 | 0
C | 2024-02-01 00:00:00 | 0 | 1
D | 2024-02-01 00:00:00 | 0 | 2
E | 2024-02-01 00:00:00 | 0 | 5
F | 2024-02-01 00:00:00 | 0 | 0
G | 2024-02-01 00:00:00 | 0 | 0
H | 2024-02-01 00:00:00 | 0 | 0
A | 2024-03-01 00:00:00 | 1 | 2
B | 2024-03-01 00:00:00 | 0 | 0
C | 2024-03-01 00:00:00 | 0 | 0
D | 2024-03-01 00:00:00 | 0 | 0
E | 2024-03-01 00:00:00 | 0 | 5
F | 2024-03-01 00:00:00 | 0 | 1
G | 2024-03-01 00:00:00 | 0 | 0
H | 2024-03-01 00:00:00 | 0 | 1
A | 2024-04-01 00:00:00 | 1 | 0
B | 2024-04-01 00:00:00 | 0 | 0
C | 2024-04-01 00:00:00 | 1 | 1
D | 2024-04-01 00:00:00 | 0 | 0
E | 2024-04-01 00:00:00 | 2 | 2
F | 2024-04-01 00:00:00 | 0 | 0
G | 2024-04-01 00:00:00 | 1 | 0
H | 2024-04-01 00:00:00 | 2 | 0
A | 2024-05-01 00:00:00 | 0 | 3
B | 2024-05-01 00:00:00 | 0 | 0
C | 2024-05-01 00:00:00 | 0 | 1
D | 2024-05-01 00:00:00 | 0 | 0
E | 2024-05-01 00:00:00 | 0 | 3
F | 2024-05-01 00:00:00 | 0 | 3
G | 2024-05-01 00:00:00 | 0 | 0
H | 2024-05-01 00:00:00 | 0 | 0
A | 2024-06-01 00:00:00 | 0 | 1
B | 2024-06-01 00:00:00 | 0 | 0
C | 2024-06-01 00:00:00 | 0 | 3
D | 2024-06-01 00:00:00 | 1 | 0
E | 2024-06-01 00:00:00 | 0 | 1
F | 2024-06-01 00:00:00 | 0 | 1
G | 2024-06-01 00:00:00 | 0 | 0
H | 2024-06-01 00:00:00 | 0 | 0
A | 2024-07-01 00:00:00 | 0 | 6
B | 2024-07-01 00:00:00 | 1 | 0
C | 2024-07-01 00:00:00 | 1 | 5
D | 2024-07-01 00:00:00 | 0 | 0
E | 2024-07-01 00:00:00 | 0 | 4
F | 2024-07-01 00:00:00 | 2 | 1
G | 2024-07-01 00:00:00 | 0 | 0
H | 2024-07-01 00:00:00 | 0 | 1
A | 2024-08-01 00:00:00 | 0 | 0
B | 2024-08-01 00:00:00 | 0 | 0
C | 2024-08-01 00:00:00 | 0 | 0
D | 2024-08-01 00:00:00 | 0 | 0
E | 2024-08-01 00:00:00 | 0 | 1
F | 2024-08-01 00:00:00 | 0 | 1
G | 2024-08-01 00:00:00 | 3 | 0
H | 2024-08-01 00:00:00 | 2 | 2
A | 2024-09-01 00:00:00 | 0 | 2
B | 2024-09-01 00:00:00 | 2 | 0
C | 2024-09-01 00:00:00 | 0 | 0
D | 2024-09-01 00:00:00 | 0 | 0
E | 2024-09-01 00:00:00 | 1 | 1
F | 2024-09-01 00:00:00 | 0 | 2
G | 2024-09-01 00:00:00 | 0 | 0
H | 2024-09-01 00:00:00 | 0 | 1
Spreadsheet: 881547d1729624424-help-automating-dates-and-data-across-multiple-sheets-excel-2016-test-attendance-calendar
Sheet: INSTRUCTIONS

 |  |  | Sa/Su | PD | HOL | ADM |  |  |  |  |  |  | Sat/Sun's | ***L6 is date cell
 |  |  |  |  |  |  |  |  |  |  |  |  | …=$[NAME]""
 |  |  | Make a 'copy' of the previous year
 |  |  | Rename the tab
 |  |  | Rename the year title on the page
 |  |  |  |  |  |  |  |  |  |  |  |  | …=COUNTA($L$6)>0
** To adjust calendar edit the date for January 1st |  |  |  |  |  |  |  |  |  |  |  |  | …=COUNTA($L$6)>0
** The schedule date for January 1st must also be updated to reflect the correct day in the cycle
** The 28 day cycle starts with [NAME] and ends with B14
** to determine the start of a new year look at the bottom right corner which indicates January 1st for the next year
 |  |  |  |  |  |  |  |  |  |  |  |  | …=COUNTA($L$6)>0
Year: | Cell C1
This calandar is built with formulas.
Change the first day of each month
and the ABC date and the month will
automatically fill in.
Cheat Sheet:
3 day weekend (Fri - Sun) B shift
2 A's |  |  |  |  |  |  |  |  |  |  |  |  | …=ISNUMBER($L$6)
2 B's
3 day weekend (Fri - Sun) A shift
2 B's
2 A's
3 day weekend (Fri - Sun) B shift
SUN | M | T | W | TH | F | SA
 |  |  |  |  | B OFF | B OFF
B OFF | A OFF | A OFF | B OFF | B OFF | A OFF | A OFF
A OFF | B OFF | B OFF | A OFF | A OFF | B OFF | B OFF
B OFF | A OFF | A OFF | B OFF | B OFF | A OFF | A OFF |  |  |  |  |  |  | Mon-Fri's | ***M6 is date cell & J4 is the month cell
A OFF | B OFF | B OFF | A OFF | A OFF | B OFF | B OFF |  |  |  |  |  |  | …=$[NAME]""
3 day weekend (Sat - Mon) C-LT |  |  |  |  |  |  |  |  |  |  |  |  | …=COUNTA($M$6)>0
2 W-LT's
2 C-LT's
3 day weekend (Sat - Mon) W-LT
2 C-LT's
2 W-LT's |  |  |  |  |  |  |  |  |  |  |  |  | …=COUNTA($M$6)>0
3 day weekend (Sat - Mon) C-LT
SUN | M | T | W | TH | F | SA
 |  |  |  |  |  | C-LT OFF
C-LT OFF | C-LT OFF | W-LT OFF | W-LT OFF | C-LT OFF | C-LT OFF | W-LT OFF |  |  |  |  |  |  | …=COUNTA($M$6)>0
W-LT OFF | W-LT OFF | C-LT OFF | C-LT OFF | W-LT OFF | W-LT OFF | C-LT OFF
C-LT OFF | C-LT OFF | W-LT OFF | W-LT OFF | C-LT OFF | C-LT OFF | W-LT OFF
W-LT OFF | W-LT OFF | C-LT OFF | C-LT OFF | W-LT OFF | W-LT OFF | C-LT OFF
 |  |  |  |  |  |  |  |  |  |  |  |  | …=ISNUMBER(MATCH(DATEVALUE(CONCATENATE($J$4," ",$M$6,", ",$C$1)),'ADMIN DATES'!$A:$A,0))
 |  |  |  |  |  |  |  |  |  |  |  |  | …=ISNUMBER(MATCH(DATEVALUE(CONCATENATE($J$4," ",$M$6,", ",$C$1)),'PAY DATES'!$A:$A,0))
** To change year type in year in the block at top |  |  |  |  |  |  |  |  |  |  |  |  | …=ISNUMBER(MATCH(DATEVALUE(CONCATENATE($J$4," ",$M$6,", ",$C$1)),HOLIDAYS!$A:$A,0))
** Schedule date must be changed to align with year (i.e. [NAME], A2, B1 etc)
Spreadsheet: 783572d1654923530-not-equal-to-formula-within-an-if-and-formula-not-working-sample
Sheet: New Report

Participants_Name | Booking_ID
Participant1 | 58887895
Participant2 | 58887897
Participant3 | 60015592
Participant4 | 60015660
Participant5 | 60209659
Participants_Name | Booking_ID | Current Formula | Meant to Say | New Formula
Participant5 | 60209659 |  | N
Participant4 | 60015660 |  | N
Participant2 | 58887897 |  | N
Participant1 | 58887995 |  | Y
Participant3 | 60015692 |  | Y
Spreadsheet: 59965d1260478508-excel-2007-help-with-a-lookup-that-will-return-multiple-occurrences-multiple-occurrences
Sheet: Flags

HID | Number | Batch | Review Priority | Status | Processor | [NAME] | Code | Mortgage Flag Description
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | 600 | Priority 1 - | 407196110:1
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | DEF | Defaulted | 407196110:2
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | DLQ | [NAME] | 407196110:3
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | NCO | No Cash | 407196110:4
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | NPL | NPL Group | 407196110:5
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | OOC | Owner | 407196110:6
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | TPO |  | 407196110:7
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | APP | Review Required | 407196110:8
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | 501 | CRS - | 407196110:9
161963 | 407196110 | [NAME] | Regular | Sent to Client | Processor | [NAME] | 417 | Risk Full | 407196110:10
162498 | 430651643 | [NAME] | Regular | In Print Batch | Processor | [NAME] | COR | Cash | 430651643:1
162498 | 430651643 | [NAME] | Regular | In Print Batch | Processor | [NAME] | DEF | Defaulted | 430651643:2
162498 | 430651643 | [NAME] | Regular | In Print Batch | Processor | [NAME] | NPL | NPL Group | 430651643:3
162498 | 430651643 | [NAME] | Regular | In Print Batch | Processor | [NAME] | OOC | Owner | 430651643:4
162498 | 430651643 | [NAME] | Regular | In Print Batch | Processor | [NAME] | TPO |  | 430651643:5
162498 | 430651643 | [NAME] | Regular | In Print Batch | Processor | [NAME] | 417 | Risk Full | 430651643:6
163018 | 458407747 | [NAME] | Regular | In Print Batch | Processor | [NAME] | 417 | Risk Full | 458407747:1
163018 | 458407747 | [NAME] | Regular | In Print Batch | Processor | [NAME] | CEA | CE Approved by Vendor | 458407747:2
163018 | 458407747 | [NAME] | Regular | In Print Batch | Processor | [NAME] | COR | Cash | 458407747:3
163018 | 458407747 | [NAME] | Regular | In Print Batch | Processor | [NAME] | DEF | Defaulted | 458407747:4
163018 | 458407747 | [NAME] | Regular | In Print Batch | Processor | [NAME] | NPL | NPL Group | 458407747:5
163018 | 458407747 | [NAME] | Regular | In Print Batch | Processor | [NAME] | OOC | Owner | 458407747:6
163018 | 458407747 | [NAME] | Regular | In Print Batch | Processor | [NAME] | TPO |  | 458407747:7
Spreadsheet: stacey_white__39144__East delivery points
Sheet: East region list

region_cd | maintenance_group_cd | region_id | region_desc | iso_country_cd | trading_desk_id | peak_offpeak_set_id | holiday_set_id | default_delivery_pt_id | location_name
R1 | HOUPOW | 1 | NY EAST | US | 1 | 11 | 32 | 5890 | [NAME] (HUD VL)
R1A | HOUPOW | 9 | PJM | US | 1 | 19 | 32 | 1918 | Financial Deal - R1A
R1B | HOUPOW | 12 | NEPOOL | US | 1 | 22 | 32 | 1957 | Financial Deal - R1B
R1C | HOUPOW | 13 | NY WEST | US | 1 | 11 | 32 | 5889 | NYISO Zone A (WEST)
R1D | HOUPOW | 24 | EASTERN HUB | US | 1 | 19 | 32 | 11475 | Financial Deal-R1D Eastern Hub
R1E | HOUPOW | 25 | WESTERN HUB | US | 1 | 19 | 32 | 5854 | FINANCIAL DEAL-R1E Western HUB
R1Z | HOUPOW | 247 | NY Zone J | US | 1 | 11 | 32 | 5956 | NYISO Zone J (N.Y.C.)
R20 | HOUPOW | 263 | Ontario | US | 1 | 11 | 32
R3 | HOUPOW | 3 | SOCO | US | 1 | 13 | 32 | 1914 | Financial Deal - R3
R3B | HOUPOW | 20 | INTO TVA | US | 1 | 25 | 32 | 1287 | Into TVA System Border
R4 | HOUPOW | 4 | CINERGY | US | 1 | 14 | 32 | 1915 | Financial Deal - R4
R4C | HOUPOW | 18 | INTO COMED | US | 1 | 27 | 32 | 2902 | Into COMED System Border
R5 | HOUPOW | 5 | Entergy | US | 1 | 15 | 32 | 1916 | Financial Deal - R5
R6 | HOUPOW | 6 | Ercot South | US | 1 | 16 | 32 | 1917 | Financial Deal - R6
R6A | HOUPOW | 337 | Ercot North | US | 1 | 16 | 32 | 11502 | Financial Deal - R6A
Spreadsheet: 124105d1318111686-using-a-vlookup-and-if-statement-inside-an-if-statement-overtime-test-upload-
Sheet: Shifts

Shift | Hours
Day | 1
Swing | 1
Night | 1
Shift A | 1
Shift B | 1
Shift C | 1
Shift  D | 1
Shift E | 1
Vacation | 1
Notes:
1) Change shift start times, end times, and payable work hours as needed to match your operations.
2) If you change the shift description or colors, you must manually update the affected shift assignments in the [NAME] worksheet
Spreadsheet: 1547503d-990e-4dcb-90c0-595c1b0d6336
Sheet: 8.14.11

Instructions: Click under "name" to select food from "FoodList."  Highlight cells from "base unit" to the last column and drag directly below to copy for a new line.  Under "portion" add a number to multiple the the "base unit" by based upon how much you consumed.  Add new foods/portions by adding them to the FoodList page.  You can always manually type in a unique food/meal below if you don't wish to add it to the FoodList.  For a new day, "Insert" a new worksheet and copy/paste this entire page. |  |  |  |  |  |  |  |  |  |  | Waking weight: | 159.8
 |  |  |  |  |  |  |  |  |  |  | (Use "BMR Guidelines" to determine goal)
Food | Base Unit | Portion | Fat | Carbs | Fiber | Protein | Calories | Sodium (mg) | Cost |  | Goal: | 2118
oatmeal |  | 0.5 |  |  |  |  |  |  |  |  | Total Calories:
Tuna |  | 1
ketchup |  | 1 |  |  |  |  |  |  |  |  | Total Fiber:
fib1bar |  | 1 |  |  |  |  |  |  |  |  | % Daily Fib:
cantaloupe |  | 1.98
gatorade |  | 1 |  |  |  |  |  |  |  |  | Total Fat Cals:
apple |  | 2.24 |  |  |  |  |  |  |  |  | Total Carb Cals:
lentils |  | 0.25 |  |  |  |  |  |  |  |  | Total Protein Cals:
pumpkin seeds |  | 0.75
french green beans |  | 1 |  |  |  |  |  |  |  |  | % Fat Cals:
fib1bar |  | 1 |  |  |  |  |  |  |  |  | % Carb Cals:
grapes |  | 1 |  |  |  |  |  |  |  |  | % Protein Cals:
kashi cereal | 0.75 | 1 | 1.5 | 25 | 5 | 4 |  | 85 | 0
whey |  | 1 |  |  |  |  |  |  |  |  | Total Sodium (mg):
dextrose |  | 1.66 |  |  |  |  |  |  |  |  | % Daily Sodium:
maltodextrin |  | 1.66
olive oil |  | 1 |  |  |  |  |  |  |  |  | Cost:
brown rice |  | 0.25
egg |  | 1
egg white |  | 2
french green beans |  | 1
carrot |  | 0.92
TVP |  | 1
Spreadsheet: 9acf9703-910e-44ac-9321-584e324e4a3b
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: |  |  | 2013-11-07 09:25:14.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.75 | 102.5 | 102.375 | 102.25 | 101.875 |  | and are added to price quote
4.625 | 102.218 | 102.093 | 101.968 | 101.593
4.5 | 101.844 | 101.719 | 101.594 | 101.219 |  | Note: | Refer To Price [NAME]
4.375 | 100.923 | 100.798 | 100.673 | 100.298 |  |  | For all Price Adjs
4.25 | 100.386 | 100.261 | 100.136 | 99.511
4.125 | 99.595 | 99.47 | 99.345 | 98.72
4 | 98.607 | 98.482 | 98.357 | 97.732
3.875 | 97.581 | 97.456 | 97.331 | 96.706
3.75 | 96.706 | 96.581 | 96.456 | 95.831 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.476 | 102.351 | 102.226 | 101.851
3.625 | 102.071 | 101.946 | 101.821 | 101.446
3.5 | 101.556 | 101.431 | 101.306 | 100.931
3.375 | 100.803 | 100.678 | 100.553 | 100.178
3.25 | 100.08 | 99.955 | 99.83 | 99.205
3.125 | 99.144 | 99.019 | 98.894 | 98.269
3 | 98.394 | 98.269 | 98.144 | 97.519 |  | 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 | 2013-11-21 09:25:14.360000
30 DAY | 2013-12-06 09:25:14.360000
45 DAY | 2013-12-21 09:25:14.360000
60 DAY | 2014-01-05 09:25:14.360000
90 DAY | 2014-02-04 09:25:14.360000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -55843 | -31330
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -3069632 | -3154103
58710 | -22709 | -1181
60921 | 2687795 | 2610405
78026 |  | 64200
500084 | -20590 | -27000
500085
500097 | -272
INDEX
2001-07-31 00:00:00 |  |  | 296780.47
2001-08-27 00:00:00
CBS Volume
 |  |  | 67620
2001-08-11 00:00:00
Spreadsheet: darrell_schoolcraft__7408__sharris0102wk4
Sheet: Plan vs. Forecast

Transwestern Pipeline Company
($[NAME])
Plan vs. Forecast
 |  |  | Weekly
 |  | Plan | Forecast | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | New Contracts; Lower West flow on 1-Part rate contracts
West Commodity Revenues |  |  |  |  |  | Lower Volumes
East Demand Revenues
East Commodity Revenues |  |  |  |  |  | Higher [NAME]
[NAME] |  |  |  |  |  | Higher rates
[NAME] Revenues |  |  |  |  |  | Higher IT Volumes
PNR Revenues |  | 0
Revenue Variance
Fuel Price [NAME] |  |  |  |  |  | MTD index price of $2.08 vs. Plan index price of $2.41
Fuel Volume Variance-Unhedged |  |  |  |  |  | Lower retained volumes due to lower West flow; Fuel payback to ECS
Sales Margin Variance on Unhedged
Hedging Adjustment
Plan Fuel Stretch |  |  | 0
Other Adjustment
Fuel Variance (Excludes UAF)
Monthly Stretch |  | 0 | 0
Target Adjustment |  | 0 | 0
Current Month Margin Variance
Expenses |  | -0.984
Non-Recurring |  | 0
Other |  | -0.006
Total Current Month Variance
May |  | 0 | 0
April |  | 0 | 0
March |  | 0 | 0
February |  | 0 | 0
January |  | 0 | 0
January 31, 2001 YTD
Spreadsheet: 832780d1686584494-multiple-column-matches-book-1-rev-1
Sheet: Sheet1

 |  | Duration |  | C1 | C2 | [NAME] |  |  |  |  |  | Duration totals when C1=C4, C2=C5, [NAME]C6 |  | C4 | C5 | C6
 |  | 3 |  | 1 | 2 | 1 |  |  |  |  |  |  |  | 1 | 2 | 1 |  | 100
 |  | 6 |  | 2 | 2 | 2 |  |  |  |  |  |  |  | 2 | 3 | 1 |  | 150
 |  | 4 |  | 2 | 2 | 5 |  |  |  |  |  |  |  | 2 | 2 | 5 |  | 200
 |  | 5 |  | 3 | 3 | 6 |  |  |  |  |  |  |  | 3 | 3 | 6 |  | 200
 |  | 3 |  | 4 | 2 | 4 |  |  |  |  |  |  |  | 2 | 2 | 2 |  | 100
 |  | 4 |  | 4 | 1 | 4
 |  | 4 |  | 1 | 2 | 1
 |  | 8 |  | 5 | 5 | 2
 |  | 5 |  | 3 | 3 | 1
 |  | 6 |  | 2 | 3 | 1
 |  | 5 |  | 3 | 3 | 6
Spreadsheet: 78541d1278941245-text-recognition-template-excel-help-forum-example
Sheet: Sheet1

Result | Address
 |  |  | Key
a | 2857 ALDEN GREEN TRL |  | a-apron
a | 2867 ALDEN GREEN TRL |  | g-gutter
a | 2876 ALDEN GREEN TRL |  | d-delivered correctly
d | 2905 ALDEN GREEN TRL |  | l-lawn
d | 2906 ALDEN GREEN TRL |  | sw-sidewalk
d | 2915 ALDEN GREEN TRL |  | st-street
l | 2916 ALDEN GREEN TRL |  | n-not delivered
l | 2577 ARROWOOD DR
l | 2585 ARROWOOD DR
l | 2601 ARROWOOD DR
l | 2609 ARROWOOD DR |  | How many
l | 2617 ARROWOOD DR |  | a-
g | 2624 ARROWOOD DR |  | g-
g | 2625 ARROWOOD DR |  | d-
g | 2634 ARROWOOD DR |  | l-
d | 2635 ARROWOOD DR |  | sw-
g | 2644 ARROWOOD DR |  | st-
d | 2645 ARROWOOD DR |  | n-
g | 2654 ARROWOOD DR
d | 2655 ARROWOOD DR
g | 2702 ARROWOOD DR
st | 2703 ARROWOOD DR
st | 2707 ARROWOOD DR
st | 2712 ARROWOOD DR
sw | 2717 ARROWOOD DR
sw | 2722 ARROWOOD DR
l | 2727 ARROWOOD DR
a | 2732 ARROWOOD DR
a | 2737 ARROWOOD DR
a | 2742 ARROWOOD DR
a | 2752 ARROWOOD DR
a | 2762 ARROWOOD DR
d | 2767 ARROWOOD DR
d | 2777 ARROWOOD DR
d | 2787 ARROWOOD DR
n | 2811 ARROWOOD DR
n | 2826 ARROWOOD DR
n | 2831 ARROWOOD DR
n | 2838 ARROWOOD DR
n | 2850 ARROWOOD DR
n | 2860 ARROWOOD DR
n | 2871 ARROWOOD DR
n | 2872 ARROWOOD DR
a | 2882 ARROWOOD DR
a | 2883 ARROWOOD DR
g | 2893 ARROWOOD DR
g | 2894 ARROWOOD DR
a | 2905 ARROWOOD DR
n | 2926 ARROWOOD DR
n | 2949 ARROWOOD DR
Spreadsheet: 168259d1342353164-excel-2007-vlookup-returns-n-a-with-special-characters-arrayvlookup
Sheet: Sheet2

Folder ID | [NAME]
-uecBgd@Do[XaZ.T5%0g | Bases 1
+0*2hqH"+sJ\&`X?c[sQ | Bases 2
9(Dij':``%U33O7DX@MM | Data
*5bF#XA16=XGfQRXs.&O | Data 2
!!!!!!!!!!!!!!!!!!!! | Root
3Y=A[$(c!/VH!ga`,T&u | Folder 1
gQ1rgV*`$kO9JKLjcCC" | Folder 2
N[0$CF$h<CM0qqoVjoPs | Folder 3
`&HC#GeTG1S>+s?J#A1g | Folder 5
\BqcJLABFgS<hh=?,Nhq | Folder 4
Kjo@FZoK4%T$qe.WC;kb | Folder 6
Spreadsheet: 525527d1498760510-output-a-number-based-on-depth-and-date-when-there-are-overlapping-dates-and-depths-bhaslideexample-bw2
Sheet: Sheet1

Date |  | BHA |  | Start Date | End Date | depth in | depth out | BHA #
2017-06-30 00:00:00 | 326 |  |  |  |  | 109 | 723 | 1
2017-07-02 00:00:00 | 1085 |  |  |  |  | 723 | 2390 | 2
2017-07-04 00:00:00 | 1218 |  |  |  |  | 878 | 1668 | 3
2017-07-05 00:00:00 | 2085 |  |  |  |  | 1668 | 2111 | 4
2017-07-08 00:00:00 | 1426 |  |  |  |  | 816 | 2161 | 5
2017-07-10 00:00:00 | 2200 |  |  |  |  | 778 | 2455 | 6
Spreadsheet: 191981d1352271312-how-to-count-the-text-and-at-the-same-time-disregard-counting-those-that-repeats-help-1-
Sheet: Sheet1

Member ID | Month
SP00002 | May |  | I want to count the number of memberID in may, diregarding those that repeat.
SP00051 | Feb
SP00052 | August |  | 3 |  | May
SP00053 | September
SP00054 | October
SP00055 | November
SP00056 | December
sp00058 | May
sp00058 | May
SP00057 | August
SP00060 | Feb
SP00061 | September
sp00062 | May
SP00062 | May
SP00064 | September
Spreadsheet: 114684d1310411030-how-to-calculate-the-quarterly-increase-given-a-yearly-percentage-increase-increase
Sheet: Sheet1

BuildingName | RankGroup | Date | Staff
Atlanta | Staff | 2011-07-01 00:00:00 | 394
Boston | Staff | 2011-07-01 00:00:00 | 443
Atlanta | Staff | 2011-10-01 00:00:00
Boston | Staff | 2011-10-01 00:00:00
Atlanta | Staff | 2012-01-01 00:00:00
Boston | Staff | 2012-01-01 00:00:00
Atlanta | Staff | 2012-04-01 00:00:00
Boston | Staff | 2012-04-01 00:00:00
Atlanta | Staff | 2012-07-01 00:00:00
Boston | Staff | 2012-07-01 00:00:00
Atlanta | Staff | 2012-10-01 00:00:00
Boston | Staff | 2012-10-01 00:00:00
Atlanta | Staff | 2013-01-01 00:00:00
Boston | Staff | 2013-01-01 00:00:00
Atlanta | Staff | 2013-04-01 00:00:00
Boston | Staff | 2013-04-01 00:00:00
Atlanta | Staff | 2013-07-01 00:00:00
Boston | Staff | 2013-07-01 00:00:00
Atlanta | Staff | 2013-10-01 00:00:00
Boston | Staff | 2013-10-01 00:00:00
Atlanta | Staff | 2014-01-01 00:00:00
Boston | Staff | 2014-01-01 00:00:00
Atlanta | Staff | 2014-04-01 00:00:00
Boston | Staff | 2014-04-01 00:00:00
Atlanta | Staff | 2014-07-01 00:00:00
Boston | Staff | 2014-07-01 00:00:00
Atlanta | Staff | 2014-10-01 00:00:00
Boston | Staff | 2014-10-01 00:00:00
Atlanta | Staff | 2015-01-01 00:00:00
Boston | Staff | 2015-01-01 00:00:00
Atlanta | Staff | 2015-04-01 00:00:00
Boston | Staff | 2015-04-01 00:00:00
Spreadsheet: 15f1aa40-3a9b-4ca7-a36f-1f991203b9b3
Sheet: Sheet1

Release: House Price Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=171
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-05-25 7:57 PM [NAME]
 | Real-Time | Period
Name: | Start | End
House Price Index | 2008-05-22 00:00:00 | Current
Link:
http://www.fhfa.gov/ | 2008-05-22 00:00:00 | Current
Source:
Federal Housing Finance Agency | 2008-05-22 00:00:00 | Current
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:
2008-05-22 00:00:00
2008-08-26 00:00:00
2008-11-25 00:00:00
2009-02-24 00:00:00
2009-05-27 00:00:00
2009-08-25 00:00:00
2009-11-24 00:00:00
2010-02-25 00:00:00
2010-05-25 00:00:00
2010-08-25 00:00:00
2010-11-24 00:00:00
2011-02-24 00:00:00
2011-05-25 00:00:00
2011-08-24 00:00:00
2011-11-29 00:00:00
2012-02-23 00:00:00
2012-05-23 00:00:00
2012-06-21 00:00:00
2012-07-24 00:00:00
2012-08-23 00:00:00
2012-09-25 00:00:00
2012-10-24 00:00:00
2012-11-27 00:00:00
2012-12-20 00:00:00
2013-01-23 00:00:00
2013-02-26 00:00:00
2013-03-21 00:00:00
2013-04-23 00:00:00
2013-05-23 00:00:00