tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 682303d1591991715-static-date-based-on-single-cell-value-excel-help
Sheet: 2020 - WHAT HAPPENS

2020 |  |  |  |  |  |  | 10 |  |  |  |  |  | er |  |  |  |  |  | Daily Diff - WHAT IT DOES |  | Alternative - WHAT IT DOES
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun | 2nd qtr | moved from AK USA
 | 10 |  | 15 |  | 15 |  | 20 |  | 25 |  | 100 |  | 6.25.14
 | Jul |  | Aug |  | Sep | [NAME] | Oct |  | Nov |  | Dec | [NAME]
Spreadsheet: 883575d1732195807-having-issue-with-countifs-referencing-array-formula-in-a-let-formula-let_countifs-issue-forum
Sheet: sheet1

 | <=Start Date
 | <=End Date
2024-10-01 00:00:00 | <=Start Date Override
2024-10-31 00:00:00 | <=End Date Override
 | 3 |  |  |  |  | #[NAME]!
[NAME] | 1 |  |  |  | [NAME] | #[NAME]!
Name3 | 1 |  |  |  | Name3 | #[NAME]!
Name4 | 1 |  |  |  | Name4 | #[NAME]!
Name5 | 1 |  | Name1 |  | Name5 | #[NAME]!
Name6 | 1 |  |  |  | Name6 | #[NAME]!
 |  |  | [NAME] |  | #N/A | #[NAME]!
 |  |  |  |  | #N/A | #[NAME]!
 |  |  | Name1 |  | #N/A | #[NAME]!
 |  |  | Name3 |  | #N/A | #[NAME]!
 |  |  | Name4 |  | #N/A | #[NAME]!
 |  |  | Name5 |  | #N/A | #[NAME]!
 |  |  | Name1 |  | #N/A | #[NAME]!
 |  |  | Name6 |  | #N/A | #[NAME]!
 |  |  |  |  | #N/A | #[NAME]!
 |  |  |  |  | #N/A | #[NAME]!
Spreadsheet: 141081d1329073240-help-on-function-vlookup-and-time-copy-of-copy-of-time-in-motion-study2
Sheet: Time + Motion 

Begin Time | End Time | task duration
 |  | 5 mins | 10 min | 15 min | 20 min | 25 min | 30 min | 35 min | 40 min | 45 min | 50 min | 55 min | 0 min
08:00:00 | 09:00:00 |  |  |  |  |  |  |  |  |  |  | A | E
09:00:00 | 10:00:00 | E | TO | TO | TO | CA | CA | R | TO | R | R | TO | S
10:00:00 | 11:00:00 | S | S | R | R | R | R | R | R | R | R | R | TO
11:00:00 | 12:00:00 | S | E | TO | TI | CO | R | TI | TI | TI | CA | CA | CA
12:00:00 | 13:00:00 | A | A | A | CA | CA | E | E | TO | B | B | B | B
13:00:00 | 14:00:00 | B | B | B | B | R | TI | TI | TI | TI | TI | TI | TI
14:00:00 | 15:00:00 | E | E | TO | TO | R | TO | TO | R | TO | TO | TI | CO
15:00:00 | 16:00:00 | TO | TO | TO | TO | TO | TO | TO | TO | TO | TO | TO | TO
16:00:00 | 17:00:00 | TO | TO | TI | TI | TO | TO | TO | TO | TO | TI | CA | CA
17:00:00 | 18:00:00 | A |  |  |  | A | A |  |  |  | A
 | time per task
 | total no of hours per task
 | this is the result I want
 |  | A is 8 x 5 = 40 spent on Admin
 |  | E - 7 X 5 - 35 ON EMAIL
 |  | poss use count to add the tasks then the other to multiply results ?
 |  | need TIME function in excel ?
 | Additional notes |  | AS YOUR SAMPLE x 5( solution by fortis) | Ax5 + Ax10 +A15+Ax20 ….
 | admin | A | 40  min. | 195 | get A then multiply by column header time allotments
 | break | B | 35  min.
 | consultation | CO | 35  min.
 | emails | E | 35  min.
 | letters | L | 35  min.
 | Meetings | M | 20  min.
 | phone call in | PI | 20  min.
 | phone call out | PO | 20  min.
 | Cnotes | CA | 20  min.
 | research | R | 20  min.
 | supporting | S | 20  min.
 | Training | T | 20  min.
 | Travel | TR | 20  min.
 | T Process | TP | 20  min.
 | case research | CR | 20  min.
 | TASK DURATION = 5 MIN SLOTS
Spreadsheet: 803385d1667420264-formula-for-one-cell-that-cross-references-different-sums-project-change-request
Sheet: 1-PCR (LMRN)

Project Change Request
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Overall CR Report | Total PCRS submitted | A-Company A Total submitted | B-Company B Total submitted | Network Build | Deployment | Service Readiness | Transition | Total SWZ | Total SEZ | [NAME](Text/Comments format)
Total (to date) |  | 300 | 100 | 300 | 50 | 25 | 25 | 380 | 20
Cancelled | 100 | 50 | 50 | 50 | 35 | 10 | 5 | 85 | 15 |  |  | Colum B4 should equal
Processed | 300 | 250 | 50 | 200 | 50 | 25 | 25 | 280 | 20 |  |  | E4 to H4 | which should also equal to
Quarterly Submitted |  |  |  |  |  |  |  |  |  |  |  | I4 to IJ | which should also equal to
Q1 PCRs |  | 80 | 20 | 10 | 80 | 5 | 5 | 95 | 5 |  |  | [NAME] | which should also equal to
Q2 PCRs |  | 90 | 10 | 5 | 85 | 6 | 4 | 98 | 2 |  |  | sum (B8:B11) | which should also equal to
Q3 PCRs |  | 75 | 25 | 20 | 65 | 7 | 8 | 30 | 70 |  |  | sum (B13:b24)
Q4 PCRs (to date) |  | 85 | 15 | 15 | 70 | 10 | 5 | 80 | 20
Monthly Submitted
Jan | 20
Feb | 10
Mar | 20
Apr | 5
May | 10
Jun | 10
Jul | 10
Aug | 12
Sep | 20
Oct | 30
Nov | 20
Dec | 10
Cancelled | Total PCRS submitted | A-GMCB Total submitted | B-Bell Total submitted | Network Build | Deployment | Service Readiness | Transition | Total SWZ | Total SEZ | [NAME](Text/Comments format)
Total (to date) |  | 300 | 100 | 300 | 50 | 25 | 25 | 380 | 20
Cancelled | 100 | 50 | 50 | 50 | 35 | 10 | 5 | 85 | 15
Quarterly Submitted
Q1 PCRs | 100 | 80 | 20 | 10 | 80 | 5 | 5 | 95 | 5
Q2 PCRs | 100 | 90 | 10 | 5 | 85 | 6 | 4 | 98 | 2
Q3 PCRs | 100 | 75 | 25 | 20 | 65 | 7 | 8 | 30 | 70
Q4 PCRs (to date) | 100 | 85 | 15 | 15 | 70 | 10 | 5 | 80 | 20
Monthly Submitted
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Processed | Total PCRS submitted | A-GMCB Total submitted | B-Bell Total submitted | Network Build | Deployment | Service Readiness | Transition | Total SWZ | Total SEZ | [NAME](Text/Comments format)
Total (to date) |  | 300 | 100 | 300 | 50 | 25 | 25 | 380 | 20
Processed | 300 | 250 | 50 | 200 | 50 | 25 | 25 | 280 | 20
Quarterly Submitted
Q1 PCRs | 100 | 80 | 20 | 10 | 80 | 5 | 5 | 95 | 5
Q2 PCRs | 100 | 90 | 10 | 5 | 85 | 6 | 4 | 98 | 2
Q3 PCRs | 100 | 75 | 25 | 20 | 65 | 7 | 8 | 30 | 70
Q4 PCRs (to date) | 100 | 85 | 15 | 15 | 70 | 10 | 5 | 80 | 20
Monthly Submitted
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Spreadsheet: 798153d1664335149-spill-error-when-converting-to-table-s666-pq-spill-error-when-converting-to-table
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Status
 |  |  |  |  |  |  |  |  | Paid
 |  | No | Place | Status |  |  |  |  | Place | Status
 |  | 1 | Place 1 | Pending |  |  |  |  | Place 2 | 1
 |  | 2 | Place 2 | Paid |  |  |  |  | Place 3 | 3
 |  | 3 | Place 3 | Paid |  |  |  |  | Place 4 | 1
 |  | 4 | Place 4 | Pending |  |  |  |  | Place 12 | 1
 |  | 5 | Place 5 | Pending |  |  |  |  | Place 13 | 1
 |  | 6 | Place 6 | Pending |  |  |  |  | Place 14 | 1
 |  | 7 | Place 1 | Pending |  |  |  |  | Place 20 | 1
 |  | 8 | Place 3 | Pending |  |  |  |  | Place 30 | 1
 |  | 9 | Place 3 | Pending
 |  | 10 | Place 3 | Paid
 |  | 11 | Place 3 | Paid
 |  | 12 | Place 12 | Paid
 |  | 13 | Place 13 | Paid
 |  | 14 | Place 14 | Paid
 |  | 15 | Place 4 | Pending
 |  | 16 | Place 4 | Pending
 |  | 17 | Place 4 | Paid
 |  | 18 | Place 4 | Pending
 |  | 19 | Place 19 | Pending
 |  | 20 | Place 20 | Paid
 |  | 21 | Place 30 | Paid
Spreadsheet: 269207d1381041606-track-employees-which-cross-shifts-and-counted-one-time-each-shift-test-workbook1
Sheet: Sheet1

 | 07:00:00 | 11:00:00
 | 11:00:00 | 16:00:00
 | 16:00:00 | 21:00:00
 | 07:00:00 | 21:00:00
 | 07:00:00 | 00:30:00
 |  | 07:00:00 | 11:00:00
 |  | 11:00:00 | 16:00:00
 |  | 16:00:00 | 21:00:00
 |  | 23:00:00 | 00:30:00
Spreadsheet: 3a6ebdac-9c11-4828-9fbd-c9486d132157
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 7/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
June | 7.41 | 6.37 | 7.13 | 6.17 | 9.18 | 9.04 | 9.26 | 7.74
July | 7.1 |  | 6.77 |  | 10.2 |  | 8.45
August | 7.59 |  | 7.27 |  | 10.2 |  | 8.28
September | 7.54 |  | 7 |  | 10.8 |  | 8.09
October | 7.27 |  | 6.53 |  | 9.6 |  | 8.19
November | 7.3 |  | 6.44 |  | 10.3 |  | 8.43
December | 7.2 |  | 6.41 |  | 10.3 |  | 8.25
January | 7.05 |  | 6.57 |  | 8.84 |  | 8.09
February | 7.1 |  | 6.68 |  | 8.98 |  | 8.01
March | 7.2 |  | 6.7 |  | 8.39 |  | 8.04
April | 7.11 |  | 6.47 |  | 9.22 |  | 7.96
May | 6.67 |  | 6.42 |  | 8.95 |  | 7.93
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 7/12/2012
Spreadsheet: acc9be24-15a6-4b55-b4d1-8daf03f47583
Sheet: Table 8.3

8.3 Unemployment rates
 |  |  |  |  |  | Months (a)
 | Annual average (a) (b) |  |  |  |  | 2014
Country | 2010 | 2011 | 2012 | 2013 |  | Apr | May | Jun | July
Australia | 5.21 | 5.08 | 5.22 | 5.65 |  | 5.850000000000001 | 5.9 | 6.05 | 6.38
Canada | 8 | 7.45 | 7.24 | 7.05 |  | 6.9 | 7 | 7.100000000000001 | 7
France | 9.28 | 9.16 | 9.77 | 10.25 |  | 10.1 | 10.2 | 10.2 | 10.3
Germany | 7.08 | 5.95 | 5.48 | 5.33 |  | 5.100000000000001 | 5 | 5 | 4.9
Italy | 8.43 | 8.38 | 10.7 | 12.19 |  | 12.5 | 12.6 | 12.3 | 12.6
Japan | 5.05 | 4.58 | 4.350000000000001 | 4.03 |  | 3.6 | 3.5 | 3.7 | 3.8
New Zealand (c) | 6.53 | 6.53 | 6.9 | 6.2 |  |  |  | 5.600000000000001
United Kingdom | 7.78 | 8.03 | 7.890000000000001 | 7.53 |  | 6.4 | 6.4
United States | 9.620000000000001 | 8.950000000000001 | 8.07 | 7.38 |  | 6.3 | 6.3 | 6.100000000000001 | 6.2
OECD average | 8.33 | 7.94 | 7.95 | 7.890000000000001 |  | 7.4 | 7.4 | 7.33
G7 average | 8.16 | 7.640000000000001 | 7.37 | 7.100000000000001 |  | 6.45 | 6.46 | 6.390000000000001
Euro-zone average | 10.11 | 10.1 | 11.3 | 11.96 |  | 11.6 | 11.6 | 11.5 | 11.5
(a) Unemployment as a percentage of labour force.
(b) Years shown are calendar years.
(c) Data only available quarterly.
(d) Monthly data seasonally adjusted
Note: Unemployment rates shown above have been adjusted as necessary by the OECD
to conform to international definitions and to ensure consistency over time. |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | 2014-10-01 00:00:00
Source: Datastream
Spreadsheet: 118432d1313683609-sumproduct-returning-zeroes-earning-hrs-by-dept
Sheet: Summary

Wk End | PR Dept | Name | Shift | Cost Center | Dept | D/I | E001 | E002 | E003 | E005 | E053 | E101 | E102 | E056 | E408 | [NAME] | ZZE002 | ZZE003 | ZZE005 | ZZE056
2011-08-13 00:00:00 | 1270 |  | N/A
2011-08-13 00:00:00 | 2030 |  | 1st
2011-08-13 00:00:00 | 2210 |  | 1st
2011-08-13 00:00:00 | 2310 |  | 2nd
2011-08-13 00:00:00 | 3030 |  | 2nd
2011-08-13 00:00:00 | 3045 |  | N/A
2011-08-13 00:00:00 | 3500 |  | N/A
2011-08-13 00:00:00 | 3515 |  | N/A
2011-08-13 00:00:00 | 3580 |  | N/A
2011-08-13 00:00:00 | 3875 |  | N/A
2011-08-13 00:00:00 | 9551 |  | N/A
2011-08-13 00:00:00 | 9610 |  | 1st
2011-08-13 00:00:00 | 9611 |  | 1st
2011-08-13 00:00:00 | 9612 |  | 1st
2011-08-13 00:00:00 | 9613 |  | 1st
2011-08-13 00:00:00 | 9619 |  | 1st
2011-08-13 00:00:00 | 9625 |  | 1st
2011-08-13 00:00:00 | 9648 |  | 1st
2011-08-13 00:00:00 | 9667 |  | 1st
2011-08-13 00:00:00 | 9710 |  | 2nd
2011-08-13 00:00:00 | 9711 |  | 2nd
2011-08-13 00:00:00 | 9712 |  | 2nd
2011-08-13 00:00:00 | 9713 |  | 2nd
2011-08-13 00:00:00 | 9719 |  | 2nd
2011-08-13 00:00:00 | 9748 |  | 2nd/3rd
2011-08-13 00:00:00 | 9767 |  | 2nd
Spreadsheet: 797895d1664206299-using-a-formula-that-brings-about-multiple-results-depending-on-one-cell-excel-forum-help
Sheet: Sheet2

 |  | Qtr | Amount | Currency
 |  | 1 | 5 | EUR
 |  | 2 | 10 | USD
 |  | 3 | 15 | SEK
 |  | 4 | 20 | NOK
 |  | 1 | 5 | DKK
 |  | 2 | 10 | EUR
 |  | 3 | 15 | USD
 |  | 4 | 20 | SEK
 |  | 1 | 5 | NOK
 |  | 2 | 10 | DKK
 |  | 3 | 15 | EUR
 |  | 4 | 20 | USD
Spreadsheet: 220326d1363119547-trim-function-trim
Sheet: Totals 1 

Fueltek Fuel Manager Online
Report Type : Totalised Report
[NAME]
A BARRON
M BEARDSMORE
D BENNETT
G BROUGH
R SANDHU
M TOMLINSON
R COATES
M COLLEY
A CRAIG
R DAVIES
A DENNANT
S DULAI
A ELLAM
H ELLAM
J FOSTER
P FOX
S ENEFER
R GROCUTT
D HANDSAKER
F HENDERSON
P HILL
S HUNTBACH
D HUTCHINSON
M HUTTON
A JACKSON
C LE ROUX
S MARKHAM
R MARSDEN
R HIGGS
M MEENEY
J MULLIGAN
S PONDER
J PURCHASE
K RALPHS
A SAMPLE
T [NAME]
L SHAW
M SIVINS
R SUTTON
M TOMKINS
R WALSH
D WESTWOOD
M WHITEHOUSE
P WALLIS
H SHEPPARD
M STANLEY
R LEE
B ROSE
R GOODALL
A DAVEY
T HAYNES
H SINGH
A NILES
L RICHARDS
D WILLIAMS
C ROSTANCE
R BOUGHTON
P JONES
Spreadsheet: 15454137-2576-44b1-830d-0f009dd0285e
Sheet: Sheet1

Recipe Analysis Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Recipe Name_______________ |  |  |  | Portions per Recipe ___
1. Ingredients | 2. Quantity of  Ingredient As  Purchased (number of pur- chase units) | 3.Purchase Unit | 4. Servings per Purchase Unit in Food Buying Guide | 5. Meat/Meat Alternate (oz. eq.) | 6. Vegetables (1/4 CUP) | 7. Fruits     (1/4 cup) | 8. Grains (oz. eq.)
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  | Totals | 0 | 0 | 0 | 0
 |  | 9. Portions per Recipe |  | 0 | 0 | 0 | 0
 |  |  | Calculations | [NAME] (total/# portions) | Cup total/by 4   (to get units in cups), then /by # portions | CUPS total/by 4 (to get units in cups), then/by # portions | [NAME] total / by # portions
Recipe provides ___________ portions |  |  | Each Portion Contributes
 |  |  |  | meat/ meat alternates | Vegetables | Fruits | Grains
Spreadsheet: 330644d1404822819-summing-across-multiple-sheets-by-specific-name-vlookup-template-trivia-scorecard
Sheet: Week3

TEAM NAME: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL
Stepdads | 5.5 | 5 | 5.5 | 5.5 | 5.5 | 40.5 | 10.5
Danites | 2 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 4
[NAME] | 1
Spreadsheet: 163659d1340388752-identify-records-where-sales-order-contains-multiple-items-1
Sheet: Sheet1

[NAME] | Item ID | Accessory | Multiple?
ABC100 | 302 | 1A | Yes
ABC100 | 443 | 2A | Yes
EFG200 | 105 | 1A | No
EFG200 | 105 | 1B | No
HIJ300 | 790 | 3A | No
Spreadsheet: 91698d1291372504-vlookup-sum-book1
Sheet: Sheet1

Date | Customer | Amount |  | Row Labels | Sum of Amount
2009-01-05 00:00:00 | Ram | 1000 |  | Ram | 1000
2009-01-05 00:00:00 | [NAME] | 200 |  | [NAME] | 700
2009-01-06 00:00:00 | Ram | 210 |  | [NAME] | 60
2009-01-06 00:00:00 | [NAME] | 20 |  | Micheal | 50
2009-01-08 00:00:00 | Ram | 100 |  | Ram | 310
2009-01-08 00:00:00 | [NAME] | 500 |  | Grand Total | 2120
2009-01-09 00:00:00 | Micheal | 50
2009-01-09 00:00:00 | [NAME] | 40
Customer
Ram
[NAME]
[NAME]
Micheal
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Teeb

Contract Terms (*)
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | Tier 1 - 24,001 to 34,000 | 0.05
 |  | Tier 1 - 34,001 to 44,000 | 0.075
 |  | [NAME] to 54,000 | 0.1
 |  | [NAME] 64,000 | 0.125
 |  | [NAME] to 74,000 | 0.15
 |  | Tier 5 - 74,001 & Above | 0.175
 |  | 2- Incentive on Implant Procedure | 0.3
Doctor Calculation
 |  | Gross Revenue | 83489
 |  | Doctor Revenue Dental Procedure | 59750
 |  | Clinic Fees 5%
 |  | Dental Lab | 11399
 |  | OR
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Doctor Revenue Implant Procedure | 23740
 |  | Clinic Fees 5%
 |  | Consumables | 6500
 |  | Net Revenue
 |  | Amount to be Paid
 |  | * Implant Cost : SAR 650
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
 |  |  |  |  |  |  |  |  |  | Operations Report on February - 2021
 |  |  |  |  |  |  |  |  |  | # | Day/Date | Time In | Time Out | Total Time | Patient Name and file number |  | [NAME] | Surgeon | Anesthesia | Amount
 |  |  |  |  |  |  |  |  |  | 1 | Saturday 13-02-2021 | 09:40:00 | 12:54:00 | 03:14:00 | [NAME] A latebi 10035632 |  | Dental Treatment | Dr Teeb | GA
Spreadsheet: 58578d1258818700-transfer-data-from-journal-to-ledger-example-for-ritch2
Sheet: journal2

 |  |  | COMPANY NAME
 |  |  |  | Total of Filtered rows |  |  | Sub Ledger | (All)
[NAME] | DATE | NO. | البيــــــــــــــــــان | Sub Ledger | Total |  | Sum of Total | DATE
 | 2008-01-01 00:00:00 | 1 | خـــطأ | CARS | -240000 |  | NO. | 2008-01-01 00:00:00 | 2008-01-09 00:00:00 | 2008-01-12 00:00:00 | Grand Total
 | 2008-01-01 00:00:00 | 1 |  | A/R | 48000 |  | 1 | -321000 |  |  | -321000
 | 2008-01-01 00:00:00 | 1 |  | A/P | -110000 |  | 2 |  | 0 |  | 0
 | 2008-01-01 00:00:00 | 1 |  | CASH | 11000 |  | 3 |  |  | 0 | 0
 | 2008-01-01 00:00:00 | 1 |  | BANK | -30000 |  | Grand Total | -321000 | 0 | 0 | -321000
 | 2008-01-09 00:00:00 | 2 |  | A/P | 31000
 | 2008-01-09 00:00:00 | 2 |  | CASH | -1000
 | 2008-01-09 00:00:00 | 2 |  | BANK | -30000
 | 2008-01-12 00:00:00 | 3 |  | A/R | 1500.5
 | 2008-01-12 00:00:00 | 3 |  | A/P | 2500.75
 | 2008-01-12 00:00:00 | 3 |  | CASH | -3456
 | 2008-01-12 00:00:00 | 3 |  | CARS | 12987
 | 2008-01-12 00:00:00 | 3 |  | CARS | -13532.25
 | 2008-01-14 00:00:00
 | 2008-01-15 00:00:00
 | 2008-01-20 00:00:00
 | 2008-01-20 00:00:00
 | 2008-01-20 00:00:00
 | 2008-01-23 00:00:00
 | 2008-01-23 00:00:00
 | 2008-01-23 00:00:00
 | 2008-01-24 00:00:00
 | 2008-01-30 00:00:00
 | 2008-01-30 00:00:00
 | 2008-01-31 00:00:00
 | 2008-01-31 00:00:00
 | 2008-01-31 00:00:00
 | 2008-01-02 00:00:00
 | 2008-01-29 00:00:00
 | 2008-01-30 00:00:00
 | 2008-01-31 00:00:00
 | 2008-02-01 00:00:00
 | 2008-02-02 00:00:00
 | 2008-02-03 00:00:00
 | 2008-02-04 00:00:00
 | 2008-02-05 00:00:00
 | 2008-02-06 00:00:00
 | 2008-02-07 00:00:00
 | 2008-02-08 00:00:00
 | 2008-02-09 00:00:00
 | 2008-02-10 00:00:00
 | 2008-02-11 00:00:00
 | 2008-02-12 00:00:00
 | 2008-02-13 00:00:00
 | 2008-02-14 00:00:00
 | 2008-02-15 00:00:00
 | 2008-02-16 00:00:00
 | 2008-02-17 00:00:00
 | 2008-02-18 00:00:00
 | 2008-02-19 00:00:00
 | 2008-02-20 00:00:00
 | 2008-02-21 00:00:00
 | 2008-02-22 00:00:00
 | 2008-02-23 00:00:00
 | 2008-02-24 00:00:00
 | 2008-02-25 00:00:00
 | 2008-02-26 00:00:00
 | 2008-02-27 00:00:00
 | 2008-02-28 00:00:00
 | 2008-02-29 00:00:00
 | 2008-03-01 00:00:00
 | 2008-03-02 00:00:00
 | 2008-03-03 00:00:00
 | 2008-03-04 00:00:00
 | 2008-03-05 00:00:00
 | 2008-03-06 00:00:00
Spreadsheet: 82b07764-7d7f-4216-b370-896334c1386c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Hybridization | PBL Specific | HF Specific | PBL and HF2 | Total Interindiv. Variation | No Interindiv. Variation3
A | 59 | 249 | 47 | 355 | 8632
B | 256 | 272 | 42 | 570 | 7344
C | 52 | 241 | 53 | 346 | 9492
D | 89 | 263 | 48 | 400 | 8421
1. Hits not filtered for SmaI/XmaI SNPs or CNVs.
2. Interindividual differences in same direction in both tissues, otherwise counted as tissue specific.
3. Intervals with detectable signal (average signal [NAME] 500), and ratio between 0.83 and 1.2 in both tissues.
Spreadsheet: 485038d1476664823-merge-data-from-two-files-into-one-based-on-two-criteria-vlookup-with-helpers-for-beth
Sheet: Sheet1

 | DATA SET 1 |  |  |  |  |  |  |  |  | DATA SET 2
year | school | state | unemp | chgdp | Helper | Female |  | Helper | year | school | female
1987 | 100636 | 1 | 0.076 |  |  |  |  |  | 1987 | 100636 | 0.213
1987 | 100654 | 4 | 0.076 |  |  |  |  |  | 1987 | 100654 | 0.3
1987 | 100663 | 9 | 0.076 |  |  |  |  |  | 1987 | 100663 | 0.44
1987 | 100672 | 41 | 0.076 |  |  |  |  |  | 1987 | 100690 | 0.62
1987 | 100681 | 22 | 0.076 |  |  |  |  |  | 1987 | 100681 | 0.258
1987 | 100690 | 36 | 0.076 |  |  |  |  |  | 1987 | 100715 | 0.21
1987 | 100706 | 1 | 0.076 |  |  |  |  |  | 1987 | 100733 | 0.87
1987 | 100715 | 6 | 0.076 |  |  |  |  |  | 1987 | 100800 | 0.235
1987 | 100724 | 25 | 0.076 |  |  |  |  |  | 1987 | 100822 | 0.65
1987 | 100733 | 18 | 0.076 |  |  |  |  |  | 1987 | 101222 | 0.14
1988 | 100636 | 1 | 0.069 | 4.67 |  |  |  |  | 1988 | 10654 | 0.32
1988 | 100654 | 4 | 0.069 | 4.67 |  |  |  |  | 1988 | 100663 | 0.21
1988 | 100663 | 9 | 0.069 | 4.67 |  |  |  |  | 1988 | 100690 | 0.58
1988 | 100672 | 41 | 0.069 | 4.67 |  |  |  |  | 1988 | 100800 | 0.27
1988 | 100681 | 22 | 0.069 | 4.67 |  |  |  |  | 1988 | 100822 | 0.662
1988 | 100690 | 36 | 0.069 | 4.67 |  |  |  |  | 1988 | 101222 | 0.336
1988 | 100706 | 1 | 0.069 | 4.67 |  |  |  |  | 1989 | 100636 | 0.254
1988 | 100715 | 6 | 0.069 | 4.67 |  |  |  |  | 1989 | 100654 | 0.147
1989 | 100636 | 1 | 0.066 | -0.28 |  |  |  |  | 1989 | 100663 | 0.325
1989 | 100654 | 4 | 0.066 | -0.28 |  |  |  |  | 1989 | 100672 | 0.68
1989 | 100663 | 9 | 0.066 | -0.28 |  |  |  |  | 1989 | 100681 | 0.84
1989 | 100672 | 41 | 0.066 | -0.28 |  |  |  |  | 1989 | 100690 | 0.25
1989 | 100681 | 22 | 0.066 | -0.28 |  |  |  |  | 1989 | 100706 | 0.21
1989 | 100690 | 36 | 0.066 | -0.28 |  |  |  |  | 1989 | 100715 | 0.36
1989 | 100706 | 1 | 0.066 | -0.28 |  |  |  |  | 1989 | 100724 | 0.21
1989 | 100715 | 6 | 0.066 | -0.28 |  |  |  |  | 1989 | 100733 | 0.47
1989 | 100724 | 25 | 0.066 | -0.28 |  |  |  |  | 1989 | 101222 | 0.36
1989 | 100733 | 18 | 0.066 | -0.28 |  |  |  |  | 1989 | 102411 | 0.35
 |  |  |  |  |  |  |  |  | 1989 | 106254 | 0.44
Spreadsheet: 227750d1365801213-extracting-top-10-customers-from-huge-amount-of-data-susan
Sheet: Cust 110050

Customer Number | Customer | Date | unk2 | unk3 | unk4 | unk5 | charges
110050.0 | 110050 | 2013-01-28 00:00:00 | 1 |  | 1 |  | 27.56
110050.0 | 110050 | 2013-02-27 00:00:00 | 1 |  | 1 |  | 27.56
110050.0 | 110050 | 2013-03-28 00:00:00 | 1 |  | 1 |  | 27.56
Spreadsheet: 674313d1587751555-frequency-formula-with-criteria-when-filtered-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | QTY
 |  |  | 8150043938 | CPG StandardDelivery [PHONE] | 26.02.20 | 217590.04 |  |  | 2367070 | 132.5 | 22260 | 107.08 | 25.42 | 168 | price |  | 4270.56
 |  |  | 8150042810 | CPG StandardDelivery [PHONE] | 30.01.20 | 439579.28 | 01.02.20 |  | 2344156 | 136.48 | 21836.8 | 136.47 | 0.01 | 160 | price | 21836.752 | 1.6
 |  |  |  |  |  |  |  |  | 2205492 | 58.82 | 8587.72 | 33.84 | 24.98 | 146 | price | 4941.51 | 3647.08
 |  |  |  |  |  |  |  |  | 2240250 | 53.44 | 8016 | 29.93 | 23.51 | 150 | price | 4489.59 | 3526.5
 |  |  | 8150042793 | CPG Credit Returns [PHONE] | 695.46 | 30.01.20 |  | done
 |  |  | 8150041421 | CPG Credit Returns [PHONE] | 63367.2 | 8002890637 | 02.01.20 | done
 |  |  | 8150043322 | CPG Credit Returns [PHONE] | 18622.08 | 8002935400 | 15.02.20 | done
 |  |  | 8150043732 | CPG Credit Returns [PHONE] | 7283.4 | 8002942284 | 22.02.20 | done