tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167503d1342014388-how-to-link-a-drop-down-list-with-a-hyperlink-sizes_reply
Sheet: Sheet3

Size |  | [NAME] |  | Hyperlink |  |  |  |  | Size | Description |  | < [NAME] into Columns.
12X155/80 |  | 13X165/65 |  | 13X165/65 |  |  |  |  | 12X155/80 | FEDERAL SS657 77T
13X155/70 |  |  |  |  |  |  |  |  | 12X155/80 | FS F900 77T |  | <Sizes Must be sorted together.
13X155/80 |  |  |  |  |  |  |  |  | 13X155/70 | BARUM BRILLANTIS 2 75T
13X165/65 |  |  |  |  |  |  |  |  | 13X155/70 | KUMHO KH17 75T
13X165/80 |  |  |  |  |  |  |  |  | 13X155/80 | BARUM BRILLANTIS 2 79T
13X175/70 |  |  |  |  |  |  |  |  | 13X155/80 | CONTI ECOCONTACT 3 79T
13X185/60 |  |  |  |  |  |  |  |  | 13X155/80 | FS DAYTON 82T
14X155/65 |  |  |  |  |  |  |  |  | 13X155/80 | FS MULTIHAWK 79T
14X165/70 |  |  |  |  |  |  |  |  | 13X155/80 | MATADOR 16 STELLA 2 72T
14X175/65 |  |  |  |  |  |  |  |  | 13X165/65 | FEDERAL 77H SS657
14X175/80 |  |  |  |  |  |  |  |  | 13X165/65 | FS S211T
14X185 |  |  |  |  |  |  |  |  | 13X165/65 | KUMHO L758 77T
14X185/60 |  |  |  |  |  |  |  |  | 13X165/80 | BARUM BRILLANTIS 2 83T
14X185/65 |  |  |  |  |  |  |  |  | 13X165/80 | CONTI ECOCONTACT 3 83T
14X185/70 |  |  |  |  |  |  |  |  | 13X165/80 | FS DAYTON 82T
14X195 |  |  |  |  |  |  |  |  | 13X165/80 | FS EUROPA 83T
14X195/60 |  |  |  |  |  |  |  |  | 13X165/80 | FS MULTIHAWK 83T
14X195/70 |  |  |  |  |  |  |  |  | 13X165/80 | MATADOR 16 STELLA 2 83T
15X175/65 |  |  |  |  |  |  |  |  | 13X165/80 | TRACMAX 83T
15X185/60 |  |  |  |  |  |  |  |  | 13X175/70 | BARUM BRILLANTIS 2 82T
15X185/60 |  |  |  |  |  |  |  |  | 13X175/70 | FS MULTIHAWK 82T
15X185/65 |  |  |  |  |  |  |  |  | 13X175/70 | INF 030 82T
15X185/65 |  |  |  |  |  |  |  |  | 13X175/70 | MATADOR 16 STELLA 2 82T
15X185/65
15X185/65
15X185/65
15X185/65
15X195
15X195
15X195
15X195
15X195
15X195
15X195/45
15X195/50
15X195/50
15X195/50
15X195/50
15X195/50
15X195/55
15X195/55
15X195/55
15X195/60
15X195/60
15X195/60
15X195/60
15X195/60
15X195/65
15X195/65
15X195/65
15X195/65
15X195/70
15X195/70
15X205/60
15X205/60
15X205/60
15X205/65
15X205/65
15X205/70
15X205/70
15X215
15X215
15X215
15X215
15X215/80
15X245/75
15X245/75
15X245/75
15X255/70
15X30/9.5
16X07.50
16X07.50
16X07.50
16X07.50
16X08.25
16X195/75
16X195/75
16X195/75
16X205
16X205
16X205
16X205/45
16X205/50
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/55
16X205/60
16X205/60
16X205/60
16X205/60
16X205/60
16X205/65
16X205/65
16X205/65
16X205/75
16X205/75
16X205/75
16X215/55
16X215/70
16X215/70
16X215/70
16X225/65
16X225/65
16X235/65
16X235/65
16X235/85
16X235/85
16X245/70
16X245/70
16X245/70
16X245/70
16X245/70
16X245/70
16X245/70
16X245/70
16X265/70
16X265/70
16X265/70
16X265/70
17X205/40
17X205/40
17X205/45
17X205/45
17X205/50
17X205/50
17X205/50
17X215/45
17X225/45
17X225/45
17X225/45
17X225/45
17X225/65
17X235/65
17X245/40
17X255/65
17X255/65
17X255/65
17X265/65
17X265/65
18X225/40
18X225/40
18X225/40
18X255/45
18X255/45
18X255/45
18X255/45
19X225/35
19X255/50
19X255/50
20X09.00
20X09.00
22.50X11
22.50X11
Spreadsheet: 54428d1254405439-conditional-formatting-with-standard-deviations-deviation
Sheet: Sheet1

Standard value | actual value | deviation in % |  |  |  |  | 1. 80% greater or less than the standard value (RED)
100 | 110 | 0.1 |  |  |  |  | 2. 50% greater or less than the standard value (ORANGE)
200 | 182 | 0.09 |  |  |  |  | 3. If else then they are ok (GREEN).
100 | 51 | 0.49 |  |  |  |  | in addition it would be nice to have those boxes which display 0 in blue.
100 | 0 | 1
100 | 130 | 0.3 |  |  |  |  | column C: can be deleted, is only there to double-check the results of Cond.Formatting
50 | 75 | 0.5
100 | 180 | 0.8
300 | 58 | 0.8066666666666666
100 | 45 | 0.55
Spreadsheet: 91244d1291017839-moving-rows-to-anoter-worksheet-based-on-certain-criteria-placed-and-unplaced
Sheet: MASTER SHEET

NAME | ROLL | SECTION | PLACED | COMPANY
TOM | 1 | A | YES | A
RAM | 2 | B | NO | B
SHYAM | 3 | C | YES | C
I WANT EXCEL TO CUT AND PASTE THE PLACED  STUDENT NAME i.e. PLACED = YES  IN THE PLACED SHEET AND NON PLACED STUDENT I.e   PLACED = NO TO CUT AND PASTE IN UNPLACED SHEET
PLEASE HELP
Spreadsheet: 328947d1404145343-extension-of-iferror-vlookup-formula-help-needed-publisher-control-sheet-may
Sheet: Rev by ad source by LR

Reporting data as of: June 02 2014 11:59:59 GMT
Coull UK / 20476
DateTime Range: [May 1].[2014].[00:00] to [May 31].[2014].[23:59]
Time Zone: UTC
Filters: none
Ad source connection | Impressions | Revenue | Revenue eCPM
AA_DFP_TEST_MEDIUM | 20 | 0.0002 | 0.01
Adknowledge $10 | 63696 | 636.95 | 10
Adknowledge $3 | 367799 | 1103.376 | 3
Adknowledge $4 | 195644 | 782.512 | 4
Adknowledge $5 | 449562 | 2209.622 | 4.92
Adknowledge $6 | 110612 | 663.63 | 6
Adknowledge $7 | 100495 | 703.395 | 7
Adknowledge $8 | 156159 | 1249.232 | 8
Adknowledge $9 | 39113 | 352.008 | 9
Adknowledge DM $10 | 21620 | 216.2 | 10
Adknowledge DM $7 | 1552 | 10.864 | 7
Adknowledge DM $8 | 2779 | 22.232 | 8
AdMedia_SpotXchange | 11984 | 73.7355 | 6.15
Altitude_SpotXchange | 431904 | 3999.8808 | 9.26
Anyclip_ADK - $5 | 818554 | 4092.545 | 5
Anyclip_SpotXchange | 959835 | 6970.8134 | 7.26
Blue Water CAN  - $4 | 25377 | 101.508 | 4
Blue Water UK - $4 | 504 | 2.016 | 4
Blue Water US - $4 | 58891 | 235.552 | 4
Coull Transcoder test - Do not use | 250 | 0.0025 | 0.01
Crazy4Media New | 36179 | 209.8208 | 5.8
Czarina_Blue_Water - $2 | 223983 | 447.948 | 2
Czarina_SpotXchange | 221895 | 1626.7681 | 7.33
Dailymotion_ADK $9.50 | 386278 | 3669.113 | 9.5
Dailymotion_SpotXchange | 1001683 | 10328.9455 | 10.31
JW Player - AdX SDK Adaptor - SBM | 5 | 0.0001 | 0.01
JW Player - IMA 3 connection - SBM | 15 | 0.0002 | 0.01
Kitara_SpotXchange | 10320 | 114.0644 | 11.05
[NAME] | 5143 | 50.5335 | 9.83
LiveRail Central | 21275099 | 184299.9182 | 8.66
Matomy - SpotXchange | 3742 | 28.7294 | 7.68
QA Smaato Prod | 49 | 0.049 | 1
QA Smaato Stage | 58 | 0.058 | 1
Sidereel_ADK - $5 | 15360 | 76.8 | 5
Sidereel_SpotXchange | 26858 | 275.4615 | 10.26
Smaato - Mobile - Generic | 1253612 | 1253.609 | 1
Smaato - Tablet - Generic | 331485 | 331.485 | 1
Stickyads_SpotXchange | 22 | 0.0426 | 1.93
Uvidi_SpotXchange | 467323 | 4012.4861 | 8.59
Videomize_ADK - $4 | 81654 | 326.608 | 4
Videomize_SpotXchange | 601779 | 3345.7668 | 5.56
VideoNatives_SpotXchange | 37220 | 175.1611 | 4.71
Viewster - SpotXchange | 134513 | 1592.6511 | 11.84
Web3_SpotXchange | 13 | 0.0173 | 1.33
Google | 0 | 0 | 0
Smaato
SpotXchange
Spreadsheet: 842522d1694578947-extract-position-1st-last-of-number-non-number-and-aso-extract-number-non-number-formula-to-extract
Sheet: Sheet1

 | ABC 123 DEF 789 |  | *Formula to extract Position of 1st Number
 | ABC 123 DEF 789 |  | *Formula to extract Position of Last  Number
 | ABC 123 DEF 789 |  | *Formula to extract only Number
 | ABC 123 DEF 789 |  | * Formula to extract Position of 1st Non Number
 | ABC 123 DEF 789 |  | * Formula to extract Position of Last Non Number
 | ABC 123 DEF 789 |  | *Formula to extract only Non-Number
 |  | What I wish to extract
 | CLASSIC MUSIC BOX JPMUSICBOX37 | CLASSIC MUSIC BOX | JPMUSICBOX | 37
 | CRYSTAL TOWER CRYSTAL251 | CRYSTAL TOWER | CRYSTAL | 251
 | MR&MRS UGLY HAIR Root Lifting Conditioner - 300ml x1 MR06 | MR&MRS UGLY HAIR | [NAME] | 300ml x1 MR06
Spreadsheet: 679366d1590351820-help-with-filter-subtotal-and-getting-nonadjacent-cell-data-book1
Sheet: Sheet4

SYMBOL | date | OPEN | HIGH | LOW | CLOSE | volume | con | TIMESTAMP |  |  | volume | con
DDD | 2020-05-28 00:00:00 | 17390 | 18026.95 | 17351.7 | 17836.65 | 1269360 | -105500 | 2020-05-20 00:00:00 |  | total
BBB | 2020-06-25 00:00:00 | 17429 | 18011.7 | 17355.85 | 17853.55 | 138220 | 1680 | 2020-05-20 00:00:00
AAA | 2020-07-30 00:00:00 | 17385.55 | 18047.15 | 17385.55 | 17862.7 | 16450 | 0 | 2020-05-20 00:00:00 |  | [NAME]
DDD | 2020-05-28 00:00:00 | 8903.15 | 9097.7 | 8879 | 9066.65 | 7764150 | -125025 | 2020-05-20 00:00:00
CCC | 2020-06-25 00:00:00 | 8898.25 | 9092.2 | 8879 | 9069.6 | 1845600 | 369075 | 2020-05-20 00:00:00 |  | HIGH
BBB | 2020-07-30 00:00:00 | 8972.65 | 9091 | 8880.2 | 9064.85 | 280350 | 33300 | 2020-05-20 00:00:00
DDD | 2020-05-28 00:00:00 | 13360 | 13421 | 13360 | 13385 | 1250 | 150 | 2020-05-20 00:00:00
BBB | 2020-06-25 00:00:00 | 13424 | 13424 | 13360 | 13360 | 100 | 0 | 2020-05-20 00:00:00
DDD | 2020-05-28 00:00:00 | 1136.6 | 1173 | 1128.35 | 1168.7 | 1563600 | -102400 | 2020-05-20 00:00:00
Spreadsheet: 52105d1251811486-calculating-overall-estimate-book1
Sheet: Sheet1

 |  |  |  | Estimated | Sum | Wk1 | Wk2 | Wk3 | Wkn
Planned | 3.954802259887006 |  | Planned | 0.4 | 20 | 10 | 10
Actual | 3.684210526315789 |  | Actual | 1 | 10 | 10 | 0
 |  |  | Planned | 0.19 | 30 | 5 | 25
 |  |  | Actual | 1 | 5 | 5 | 0
 |  |  | Planned | 0.2 | 20 | 4 | 16
 |  |  | Actual | 1 | 4 | 4 | 0
 |  |  | Planned | 1 | 0
 |  |  | Actual | 1 | 0
 |  |  | Planned | 1 | 0
 |  |  | Actual | 1 | 0
Spreadsheet: 139539d1328287721-ranking-formula-used-in-conjunction-with-a-selection-box-test-example-ranks
Sheet: Jan Mon Actuals

 |  | office  A | Office b | office c | office d | office e | office f | office g | office h | office I | office j | office k | office l
Mission AA
 | Program 1 | 1 |  |  |  |  |  |  | 5
 | Program 2 | 5
 | Program 3 | 6 |  |  |  |  |  |  |  |  | 5
 | Program 4 |  | 6
Mission BB
 | Program 5 |  |  |  |  |  |  |  |  |  | 5
 | Program 6 |  |  | 546 |  |  |  |  |  | 9
 | Program 7 |  | 78 |  |  |  |  |  |  | 8
 | Program 8 |  | 57 |  |  |  |  |  |  |  | 5
 | Program 9 |  |  |  |  |  |  |  |  |  |  | 5
 | Program 10 | 785 |  |  | 76 |  |  | 6 | 6
 | Program 11 |  |  |  |  |  |  | 9 | 3 |  |  |  | 54
 | Program 12 |  |  |  | 768 |  |  |  | 3
Mission CC
 | Program 13 |  |  |  |  | 456
 | Program 14 |  |  |  |  |  |  | 9
 | Program 15 |  |  |  |  |  | 4
 | Program 16 |  |  |  |  |  |  |  |  |  | 5 | 3
 | Program 17 |  |  |  |  |  |  |  |  |  | 2 | 2
 | Program 18 |  |  |  |  |  |  |  |  |  |  | 3
 | Program 19 |  |  |  |  |  |  |  |  |  |  | 3
Mission DD
 | Program 20 |  |  |  |  |  |  |  |  | 2
 | Program 21 |  |  |  |  |  |  | 8
 | Program 22 |  | 54
 | Program 23 |  |  |  |  |  |  |  | 1
Mission EE
 | Program 24 |  |  | 87 |  |  | 1
 | Program 25 |  |  | 7 |  | 897
 | Program 26 |  | 5
Spreadsheet: 41738d1240265043-subtotal-sumif-on-autofilter-visible-cells-only-dummysheets
Sheet: Invoice Report

 |  |  |  |  |  |  |  | Truck # | 0
 |  |  |  |  |  |  |  | Driver: | 0
 | DATE | 1900-01-01 00:00:00 |  |  |  |  |  | Page: | 0
[NAME] | Customer |  |  | Field Location |  | County | Product |  | Gallons | Time
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
0 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0
COMMENTS: | 0
0
 |  |  |  |  |  |  | Daily Product Total:
 |  |  |  |  |  |  | Methanol: | 0 |  | EG 80/20: | 0
 |  |  |  |  |  |  | TEG: | 0 |  | DEA 85% | 0
 |  |  |  |  |  |  | TEG 90/10: | 0 |  | System Cleaner: | 0
 |  |  |  |  |  |  | AT P50: | 0 |  | [NAME]: | 0
 |  |  |  |  |  |  | AT E-50: | 0 |  |  | 0
 |  |  |  |  |  |  | JCE105N: | 0 |  | NACAP INHIB: | 0
 |  |  |  |  |  |  | XYSOL: | 0 |  | [NAME]: | 0
 |  |  |  |  |  |  | ADPAC-N | 0 |  | 1015 INHIBITOR | 0
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | (FilterCriteria(B9:D27,SUMIF(H9:H27,"METHANOL",J9:J27)&LEFT(SUBTOTAL(9,J9:[NAME])))
 |  |  |  |  |  |  |  | 0
Spreadsheet: 86d83a46-3d19-444b-85d2-1f7f455fe734
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ST2S | Test | ST2S | ST2, Serum | ST2, S | Enzyme-Linked Immunosorbent Assay (ELISA) |  |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top  Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL | 0.2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Males: <18 years: not established > or =18 years: < or =52.0 ng/mL  Females:  <18 years: not established > or =18 years: < or =38.7 ng/mL | Monday, Wednesday, Friday; 9 a.m | 1 day | 3 days | 1 | 83520 |  |  |  |  | Rochester
ST2S | [NAME] | SRED | Serum Red |  |  |  | Frozen | 90 days
ST2S | Result | 61723 | ST2, S | ST2, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 734983d1622636501-summary-data-from-other-worksheet-test_column
Sheet: PO

Expenses report
Item No | PO Date | PO No | Type | ShopA | [NAME] | ShopC
Nil | Nil | Nil | Pen | 40 | 0 | 0
Nil | Nil | Nil | Ruler | 40 | 0 | 0
Nil | Nil | Nil | eraser | 60 | 0 | 0
Nil | Nil | Nil | Pencil | 60 | 0 | 0
Nil | Nil | Nil | Paper | 90 | 0 | 0
Nil | Nil | Nil | Paper | 0 | 0 | 100
Nil | Nil | Nil | Paper | 0 | 70 | 0
Nil | Nil | Nil | Paper | 0 | 0 | 30
Nil | Nil | Nil | Pen | 0 | 0 | 0
Nil | Nil | Nil | Pen | 0 | 0 | 0
Nil | Nil | Nil | Pen | 0 | 0 | 0
Nil | Nil | Nil | Pen | 0 | 0 | 0
Nil | Nil | Nil | Pencil | 0 | 50 | 0
Nil | Nil | Nil | Pencil | 0 | 0 | 0
Nil | Nil | Nil | Pencil | 0 | 0 | 0
Nil | Nil | Nil | Ruler | 0 | 20 | 0
Nil | Nil | Nil | Ruler | 0 | 0 | 0
Nil | Nil | Nil | Ruler | 0 | 100 | 0
Nil | Nil | Nil | Ruler | 0 | 0 | 0
Nil | Nil | Nil | Paper | 80 | 0 | 0
Nil | Nil | Nil | Pencil | 0 | 0 | 20
Nil | Nil | Nil | eraser | 0 | 200 | 0
Spreadsheet: kevin_presto__20238__EIA411 Reporting Forms Revised 01 30 02
Sheet: Report - Schedule 2B

U. S. Department of Energy Energy Information Administration Form EIA-411 (2001) |  |  | Coordinated Bulk Power Supply Program Report |  |  |  |  |  | Form Approved OMB No. 1905-0129 Approval Expires 11/30/04
Reporting Period: As of January 1, 2002
Council: |  | SERC
Reporting Party:
Reporting Party EIA Code:
SCHEDULE 2. PART B. HISTORICAL AND PROJECTED DEMAND AND CAPACITY - WINTER
Line Number |  | YEAR
 |  | 2001/02 | 2002/03 | 2003/04 | 2004/05 | 2005/06 | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12
DEMAND (IN MEGAWATTS)
01 | Internal Demand
02 | Standby Demand
03 | Total Internal Demand (Sum of Lines 1 and 2)
04 | Direct Control Load Management
05 | Interruptible Demand
06 | Net Internal Demand (Line 3, Less Line 4, Less Line 5)
NET CAPACITY (IN MEGAWATTS)
07 | Committed Resources
08 | Distributed Generator Capacity, 1 megawatt or greater
09 | Other Capacity, 1 megawatt or greater
10 | Distributed Generator Capacity, less than 1 megawatt
11 | Other Capacity, less than 1 megawatt
12 | Uncommitted Planned Resources
13 | Total Capacity (sum of Lines 7 and 12)
13.1 | Nuclear
13.2 | Hydro
13.3 | Pumped Storage
13.4 | Geothermal
13.5 | Steam
13.5.1 | Coal
13.5.2 | Oil
13.5.3 | Gas
13.5.4 | Dual Fuel
13.6 | Combustion Turbine
13.6.1 | Oil
13.6.2 | Gas
13.6.3 | Dual Fuel
13.7 | Combined Cycle
13.7.1 | Oil
13.7.2 | Gas
13.7.3 | Dual Fuel
13.8 | Other
14 | Inoperable Capacity
15 | Net Operable Capacity (Line 13 Less Line 14)
16a | Total Capacity Purchases - I
16b | Total Capacity Purchases - III
16c | Total Capacity Purchases - III
16d | Total Capacity Purchases - IV
17 | Full Responsibility Purchases
18a | Total Capacity Sales - I
18b | Total Capacity Sales - III
18c | Total Capacity Sales - III
18d | Total Capacity Sales - IV
19 | Full Responsibility Sales
20 | Adjustment for Remotely Located (totally owned or shared) Generating Unit(s)
21 | Planned Capacity Resources (sum Lines 15, 16, and 20, Less Line 18)
Spreadsheet: 781401d1653302901-combining-multiple-tables-table-merge-example
Sheet: Example Merge

[NAME] | Service 1 | Service 2 | Service 3 | Service 3 2FA Active
User1 | 1
User2 | 1
User3 | 1
User4 | 1 | 1 | 1 | 1
[NAME] | 1 | 1 | 1
[NAME] | 1 | 1
User7 | 1 | 1
User8 |  | 1
[NAME] |  | 1 | 1
User10 |  | 1 | 1 | 1
Spreadsheet: 883322d1731934529-how-to-calculate-projected-stock-days-with-daily-sales-in-excel-stock-exercise-
Sheet: Stock Projection

 | Date
 | ITEM 1
 | Projected Stock | 3000
 | Months of Inventory
 | ITEM 2
 | Projected Stock | 15073
 | Months of Inventory
Spreadsheet: 546376d1510014899-rmd-required-minimum-deduction-scratch
Sheet: Sheet1

Age |  |  | 75 |  |  | 76 |  |  | 77 |  |  | 78
Dist Pd |  |  | 22.9 |  |  | 22 |  |  | 21.2 |  |  | 20.3
 |  | Tax Year 2016 |  |  | Tax Year 2017 |  |  | Tax Year 2018 |  |  | Tax Year 2019
 |  | Interest | Balance |  | Interest | Balance |  | Interest | Balance |  | Interest | Balance
Opening Balance |  |  | 99500
Jan |  | 0 |  |  | 0.0034 |  |  | 0.0017 |  |  | 0.0011
Feb |  | 0 |  |  | 0.0013 |  |  | 0.0023 |  |  | 0.0023
Mar |  | 0 |  |  | 0.0032 |  |  | 0.0017 |  |  | 0.0033
Apr |  | 0 |  |  | 0.0034 |  |  | 0.0037 |  |  | 0.001
May |  | 0 |  |  | 0.001 |  |  | 0.002 |  |  | 0.0027
Jun |  | 0 |  |  | 0.004099999999999999 |  |  | 0.0018 |  |  | 0.0039
Jul |  | 0 |  |  | 0.0039 |  |  | 0.0049 |  |  | 0.0024
Aug |  | 0 |  |  | 0.0026 |  |  | 0.0039 |  |  | 0.0042
Sep |  | 0 |  |  | 0.0025 |  |  | 0.0022 |  |  | 0.0015
Oct |  | 0 |  |  | 0.0027 |  |  | 0.004699999999999999 |  |  | 0.0027
Nov |  | 0.005 |  |  | 0.0042 |  |  | 0.0019 |  |  | 0.0026
Dec |  | 0.005 |  |  | 0.0042 |  |  | 0.0034 |  |  | 0.0027
RMD
Closing Balance
YoY
Spreadsheet: 164534d1340806015-top-bottom-ten-in-a-formula-example
Sheet: Data

BRANCH_NAME | CY Sales | PY Sales | Sales  Variance
Atl | -11874.63 | 1026.84 | -12901.47
Atl | 1184.08 | 1318.94 | -134.86
Atl | 0 | 0 | 0
Atl | 0 | 2985.66 | -2985.66
Atl | 2363.42 | 316.83 | 2046.59
Atl | 1974.51 | 10910.75 | -8936.24
Atl | 0 | 0 | 0
Atl | 0 | 0 | 0
Atl | 0 | 1146.46 | -1146.46
Atl | 0 | 0 | 0
Atl | 162.13 | 0 | 162.13
Atl | 6092.02 | 4962.98 | 1129.04
Atl | 3744.96 | 587.65 | 3157.31
Atl | 0 | 0 | 0
Atl | 0 | 0 | 0
Atl | 27.17 | 239 | -211.83
Atl | 0 | 0 | 0
Atl | 48.49 | 12.45 | 36.04
Atl | 0 | 0 | 0
Atl | 0 | 118.48 | -118.48
Atl | 0 | 0 | 0
Atl | 0 | 324.37 | -324.37
Atl | 220.58 | 0 | 220.58
Atl | 943.05 | 0 | 943.05
Atl | 4.68 | 0 | 4.68
Atl | 44107.4 | 43408.8 | 698.6
Que | -4255 | -1498.08 | -2756.92
Que | 3518.4 | 2993.68 | 524.72
Que | 0 | 102.5 | -102.5
Que | 0 | 0 | 0
Que | 1733.7 | 649.51 | 1084.19
Que | 0 | 58 | -58
Que | 0 | 0 | 0
Que | 0 | 6760 | -6760
Que | 0 | 0 | 0
Que | 0 | 979.8 | -979.8
Que | 462 | 0 | 462
Que | 0 | 0 | 0
Que | 195.84 | 141.44 | 54.4
Que | 0 | 0 | 0
Que | 0 | 1086 | -1086
Que | 5336 | 2200 | 3136
Que | 7190.53 | 9782.62 | -2592.09
Que | 7895 | 0 | 7895
Que | 0 | 0 | 0
Que | 76.1 | 79.75 | -3.65
Que | 0 | 1600 | -1600
Que | 60.28 | 298.1 | -237.82
Que | 0 | 0 | 0
Que | 0 | 0 | 0
Que | 191.94 | 75 | 116.94
Que | 0 | 1963 | -1963
Que | 0 | 5370 | -5370
Que | 0 | 959 | -959
Que | 388 | 0 | 388
Que | 9.78 | 55.16 | -45.38
[NAME] | 0 | 20414 | -20414
[NAME] | 40368.11 | 1141.65 | 39226.46
[NAME] | 8281.85 | -300.55 | 8582.4
[NAME] | 1811 | 2500 | -689
[NAME] | 939.38 | 0 | 939.38
[NAME] | 0 | 399 | -399
[NAME] | 0 | 15128.68 | -15128.68
[NAME] | 880 | 13114 | -12234
[NAME] | 6199.06 | 5697.2 | 501.86
[NAME] | 0 | 0 | 0
[NAME] | 0 | 108 | -108
[NAME] | 4158.94 | 17522.6 | -13363.66
[NAME] | 0 | 6671 | -6671
[NAME] | 0 | 1373.33 | -1373.33
[NAME] | 3869.26 | 703.09 | 3166.17
[NAME] | 482.79 | 738.76 | -255.97
[NAME] | 9697.39 | 10754.04 | -1056.65
[NAME] | 712.32 | 182.56 | 529.76
[NAME] | 323.68 | 819.93 | -496.25
[NAME] | 37.9 | 106.54 | -68.64
[NAME] | 96217 | 0 | 96217
[NAME] | -62.46 | 6239.45 | -6301.91
[NAME] | 1207.55 | 106421.91 | -105214.36
[NAME] | 0 | 0 | 0
[NAME] | 420 | 0 | 420
[NAME] | 0 | 0 | 0
[NAME] | 0 | 1080 | -1080
[NAME] | 1177.48 | 1199.14 | -21.66
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
alb | 0 | 0 | 0
alb | 0 | 0 | 0
alb | 4271 | 1198.63 | 3072.37
alb | 80 | 0 | 80
alb | 2074.37 | 2348.41 | -274.04
alb | 0 | 0 | 0
alb | 0 | 108.75 | -108.75
alb | 12969.34 | 8961.67 | 4007.67
alb | 0 | 698.58 | -698.58
alb | 3967.51 | 981.86 | 2985.65
alb | 891 | 0 | 891
alb | 993 | 554.3 | 438.7
alb | 45653.87 | 66083.6 | -20429.73
alb | 0 | 0 | 0
alb | 7921.42 | 3567.3 | 4354.12
alb | 3.12 | 2.93 | 0.19
alb | 2411.03 | 604.01 | 1807.02
alb | 16835.8 | 10970.2 | 5865.6
alb | 0 | 75.6 | -75.6
alb | 35270.65 | 21941.59 | 13329.06
alb | 43928.3 | 46075.72 | -2147.42
alb | 29040.27 | 26091.36 | 2948.91
alb | 33218.02 | 31837.81 | 1380.21
alb | 65.28 | 96 | -30.72
alb | 0 | 85.44 | -85.44
alb | 0 | 0 | 0
alb | 1096 | 508.53 | 587.47
alb | 642.46 | 3619.08 | -2976.62
alb | 0 | 0 | 0
alb | 0 | 0 | 0
Spreadsheet: 76397d1276892811-data-query-question
Sheet: Sheet1

Company | Product | Amount |  |  |  | Company A |  |  |  | Company B |  |  |  | Company C
A | A | 2 |  |  |  | Product |  | Amount |  | Product |  | Amount |  | Product |  | Amount
B | B | 5
B | C | 4
A | D | 2
A | E | 1
B | F | 7
C | G | 8
C | H | 9
C | I | 7
 |  |  |  |  |  | This is how I want it to look
 |  |  |  |  |  | Company A |  |  |  | Company B |  |  |  | Company C
 |  |  |  |  |  | Product |  | Amount |  | Product |  | Amount |  | Product |  | Amount
 |  |  |  |  |  | A |  | 2 |  | B |  | 5 |  | G |  | 8
 |  |  |  |  |  | D |  | 2 |  | C |  | 4 |  | H |  | 9
 |  |  |  |  |  | E |  | 1 |  | F |  | 7 |  | I |  | 7
Spreadsheet: 117263d1312588148-using-and-to-check-2-conditions-conditionals
Sheet: report

location | species | date | live count
[NAME] | electric |  | =INDEX(data!$A$1:$A$100,IF(data!$E$1:$E$100=$B$2,IF(data!$C$1:$C$100=$A$2,IF(data!$A$1:$A$100=$C2),ROW(data!$F$1:$F$100)))),ROWS($B$1:B1))))
[NAME] | diesel
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: EOL Support

 | EOL Support
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  |  | Per HC | New HC | Adj Comp | 2002
 |  | YTD Actual |  | Forecast |  | Forecast |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0 |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  | 25500 |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  | 340000
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Admins | 48000 | 2
ENATECH | Technology |  |  |  |  |  |  |  |  | Staff | 49200 | 7
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Analysts | 57600 | 3
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  |  | Specialist | 62400 | 8
ENATAXES | Taxes Other than Income |  |  |  |  | 0 |  |  |  | Sr Specialist | 74400 | 7
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Managers | 96000 | 8
 |  |  |  |  |  |  |  |  |  | Directors | 120000 | 3
 | Headcount |  |  | 114 |  |  |  |  |  | Sr Director | 156000 | 0
 |  |  |  |  |  |  |  |  |  | Vice President | 204000 | 1
 | A&A Headcount |  |  | 4 |  |  |  |  |  | [NAME] | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  |  |  | Based on information from ENW accounting.