tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 207820-using-the-values-in-last-column-to-return-the-values-in-the-first-column-basic-materials
Sheet: Aluminum

Stock Quotes Provided by MSN Money
Click here to visit MSN Money
 |  |  | Last | Previous Close | High | Low | Volume | Change | % Change | 52 Wk High | 52 Wk Low | Market [NAME] | EPS | P/E Ratio | # [NAME] Out
Alcoa Inc | Chart | News | 9 | 8.94 | 9.02 | 8.91 | 22225088 | 0.06 | 0.0067 | 10.92 | 7.97 | 9604818000 | 0.16 | 57 | 1067202000
Aluminum Corporation of China ADR Rep 25 Ord Shs Class H | Chart | News | 12.77 | 12.67 | 12.82 | 12.69 | 79779 | 0.1 | 0.0079 | 13.88 | 9.22 | 6908308463 | -1.51 |  | 540979500
Alumina ADR Reptg 4 Ord Shs | Chart | News | 4.57 | 4.52 | 4.57 | 4.51 | 201824 | 0.05 | 0.0111 | 5.94 | 2.65 | 2787924492 | 0.07 | 62.2 | 610049100
Century Aluminum Co | Chart | News | 8.84 | 8.95 | 8.98 | 8.7 | 559918 | -0.11 | -0.0123 | 11.3 | 5.52 | 782220232 | -0.64 |  | 88486450
Kaiser Aluminum Corp | Chart | News | 62.64 | 63 | 63 | 62.11 | 124756 | -0.36 | -0.0057 | 65.17 | 45.65 | 1209780715 | 4.25 | 14.8 | 19313230
Noranda Aluminum Holding Corp | Chart | News | 6.59 | 6.63 | 6.7 | 6.53 | 192640 | -0.04 | -0.006 | 13.18 | 5.38 | 446223804 | 1.01 | 6.6 | 67712260
Symbol Lookup |  | MSN Money Home |  |  |  | Microsoft Office Tools on the Web
Find stocks, mutual funds, options, indices, and currencies. |  | Discover MSN Money's tools, columns, and more! |  |  |  | Get the latest from Microsoft Office
Terms of Use. © 2013 Microsoft Corporation and/or its suppliers. All rights reserved. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA
DATA PROVIDERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AWC
Copyright © 2013 Microsoft. All rights reserved. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CENX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Quotes are real-time for NASDAQ, NYSE and AMEX. See delay times for other exchanges. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOR
Fundamental company data and historical chart data provided by Thomson Reuters (click for restrictions). Real-time quotes provided by BATS Exchange. Real-time index quotes and delayed quotes supplied by Interactive Data Real-Time Services. Fund summary, fund performance and dividend data provided by Morningstar Inc. Analyst recommendations provided by Zacks Investment Research. StockScouter data provided by Verus Analytics. IPO data provided by Hoover's Inc. Index membership data provided by SIX Telekurs.
Japanese stock price data provided by Nomura Research Institute Ltd.; quotes delayed 20 minutes. Canadian fund data provided by CANNEX Financial Exchanges Ltd.
AA
ACH
AWC
CENX
[NAME]
NOR
Spreadsheet: 274680d1383180892-funding-allocation-of-monthly-spend-based-rank-of-different-fund-sources-funding-allocation
Sheet: Sheet1

 |  |  |  |  |  | G | H | I | J | K | L | M
 |  |  |  | Unallocated
 |  |  |  | Total Project spend |  | 2012 | January2013 | February2013 | March2013 | April2013 | May2013 | [NAME]
 | PRO XX | PROJECT 1 | Fund 1 | 100000000 | 1
 | <<Enter project decsription here>> |  | Fund 2 | 3000000 | 2
 |  |  | Fund 3 | 0 | 6
 |  |  | Fund 4 | 200000 | 3
 |  |  | Fund 5 | 200000000 | 4
 |  |  | Fund 6 | 81800000 | 5
 |  | PROJECT 1 Total | TOTAL CAPITAL SPEND | 385000000 | Ranking | 129437717.66 | 15000000 | 100000000 | 80000000 | 20000000 | 20346894.79090909 | 15838886.96363636
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
Spreadsheet: 456864d1461092015-lookup-data-in-multiple-columns-to-sum-values-in-corresponding-cells-excel-froum-help-example-data-1-
Sheet: Result

Order Number | Line Number | Qty | Price | Total |  |  |  | Order Number | Line Number | Qty | Price | Total
 |  |  |  |  |  |  |  | 100123 | SS-123 | 70 | 5
 |  |  |  |  |  |  |  | 100123 | SS-124 | 70 | 10
 |  |  |  |  |  |  |  | 100124 | SS-125 | 50 | 15
 |  |  |  |  |  |  |  | 100124 | SS-126 | 50 | 5
Spreadsheet: e50960d1-8832-43a3-b7c9-1a1e3479a5f0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42246011 | 2014-07-10 21:28:48 | AXIS | 1 | 5 | 2 | 799634 | lucky91 | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42246314 | 2014-07-10 22:03:17 | ALLIES | 1 | 5 | 4 | 799634 | lucky91 | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42435167 | 2014-07-24 14:18:48 | AXIS | 1 | 6 | 1 | 694159 | dugoutdoug | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42435295 | 2014-07-24 14:44:03 | ALLIES | 1 | 6 | 4 | 694159 | dugoutdoug | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 852928d1702912224-solved-validate-month-based-on-contract-dates-and-calculate-correct-number-of-weeks-on-date-issue-new
Sheet: Sheet1

Name | Start contract | End contract | Contract weeks | Hours a week |  | begin month | end month | Months |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | Mrt/24 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
Piet | 2024-01-01 00:00:00 | 2024-04-15 00:00:00 |  | 30
Kees | 2024-01-15 00:00:00 | 2024-03-04 00:00:00 |  | 20
Jan | 2024-10-08 00:00:00 | 2024-12-31 00:00:00 |  | 25
 |  |  |  |  | SUMIFS($H$3:$H$10,$C$3:$C$10,">=1/1/2010",$C$3:$C$10,"<=12/31/2012")
Spreadsheet: 171314d1343681381-counting-and-summing-the-total-number-of-overlapping-days-in-two-periods-working-hours
Sheet: Sheet1

Week From | Week To | No. of Workers | Hrs/Day | Total Hours Available | Total Hours Available (less holidays)
2012-08-06 00:00:00 | 2012-08-12 00:00:00 | 3 | 7 |  | ?
2012-08-13 00:00:00 | 2012-08-19 00:00:00 | 3 | 7 |  | ?
Worker | Holiday From | Holiday To
[NAME] | 2012-08-08 00:00:00 | 2012-08-14 00:00:00
Kylie | 2012-08-06 00:00:00 | 2012-08-10 00:00:00
Spreadsheet: 677995d1589647378-data-validation-excel-dependant-list-doesnt-work-example1702
Sheet: Dependant List

Ear Training | AEU | Guitar | Intellectual | Keyboard | Songwriting
[NAME] | Playing [NAME] | Guitar Open Chords | Theory | [NAME] | Melody & Chord Research
Melodic Repetition | Theory AEU | Guitar Open Inversion Chords | [NAME] | [NAME] | Innovation & Theory Applications
[NAME] (Large Intervals) | [NAME] | Guitar Movable Chords | Theory Chord Spellings | [NAME]
[NAME] (Descending) |  | Guitar Movable Inversion Chords |  | [NAME]
[NAME] (Large Intervals Descending) |  | [NAME] |  | Playing Keyboard
 |  | Guitar Intervals |  | [NAME]
 |  | Guitar Harmonics
 |  | Guitar Songs
 |  | Playing Guitar
 |  | Guitar Scales
Spreadsheet: 94531d1294326650-excel-2007-whole-and-not-whole-number-in-if-statement-questionxls
Sheet: Sheet1

 |  | Time Started | Time Ended
 |  | 08:05:00 | 14:25:00 | << THIS IS THE ONLY DATA THAT I NEED TO COMPLETE
 | Minutes available on the hour |  |  | BASIS 1 | BASIS 2 | BASIS 3 |  |  | MY FORMULA
 | 60 | 08:00:00 | 09:00:00 | 54.99999999999996 | 54.99999999999996 | -5.000000000000036 |  |  | 54.99999999999996
 | 45 | 09:00:00 | 10:00:00 | 45.00000000000002 | 60.00000000000003 | 15.00000000000003 |  |  | 45.00000000000002
 | 30 | 10:00:00 | 11:00:00 | 29.99999999999973 | 59.99999999999947 | 29.99999999999947 |  |  | 29.99999999999973
 | 30 | 11:00:00 | 12:00:00 | 30.00000000000025 | 60.0000000000005 | 30.0000000000005 |  |  | 30.00000000000025
 | 60 | 12:00:00 | 13:00:00 | 59.99999999999994 | 59.99999999999994 | -5.684341886080801e-14 |  |  | 59.99999999999994
 | 60 | 13:00:00 | 14:00:00 | 60.00000000000011 | 60.00000000000011 | 1.06581410364015e-13 |  |  | 60.00000000000011
 | 45 | 14:00:00 | 15:00:00 | 18.74999999999993 | 24.99999999999991 | -20.00000000000009 |  |  | 18.74999999999993 | <<<<--- CAN SOMEONE TELL ME WHY THIS IS "E12" INSTEAD OF "F12"
 | 60 | 15:00:00 | 16:00:00 | 0 | 0 | -60 |  |  | 0
 | 60 | 16:00:00 | 17:00:00 | 0 | 0 | -60 |  |  | 0
Spreadsheet: 57128d1257283999-dynamic-list-textmatch
Sheet: Sheet1

 |  | Type text here
 | Contains | r
 | Matches
 | Name |  | Key |  | List
 | [NAME]
 | [NAME]
 | Isla
 | Marjorie
 | Marjorie
 | [NAME]
 | Bryant
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent
 | Zach
 | [NAME]
 | Jon
 | Caleb
 | Greg
 | [NAME]
 | Doug
 | [NAME]
 | [NAME]
Spreadsheet: 478112d1472643299-survey-gizmon-help-survey-gizmo
Sheet: Result

S/n | CEA Name | Centre | Customer Feedback Post Reservation |  |  |  |  | Total
 |  |  | Excellent  5 | Good 4 | Neutral 3 | Fair  2 | Poor  1
 |  |  | 1 | 0.75 | 0.5 | -0.25 | -0.5
1 | A |  | 2 | 1 | 1
2 | B |  | 1
3 | C |  | 2
S/n | CEA Name | Centre | Post Reservation Survey Scores | After Holiday Survey Scores | Internal Appreciation Scores | Final Scores | Total Feedbacks Received Overall
1 | Abdou | KL
2 | Aissat | KL
3 | [NAME] | KL
4 | Aydin | KL
5 | [NAME] | KL
6 | [NAME] | KL
8 | Ibrahim | India
10 | Keerraan | KL
11 | Lionel | India
12 | [NAME] | KL
14 | Myrat | KL
15 | Naziya | KL
17 | Raikhan | KL
18 | Roseline | India
19 | [NAME] | India
20 | Saranya | India
24 | Tarek | KL
24 | [NAME] | India
25 | Mounir | KL
26 | Ahmed | India
 | Tarig | India
Spreadsheet: 774785d1648654420-date-difference-if-cell-not-blank-date-difference
Sheet: Sheet1

2022-03-30 08:52:00
2022-03-30 05:00:55
2022-03-29 23:16:18 |  |  | Should show 1
2022-03-30 04:10:04
2022-03-30 05:34:10
2022-03-29 11:16:22
2022-03-30 08:58:34
2022-03-29 16:04:10
2022-03-29 16:30:15
2022-03-29 17:00:46
2022-03-30 04:08:14
2022-03-29 14:10:42
2022-03-28 11:20:55 |  |  | Should show 2
2022-03-28 18:46:53
2022-03-29 14:35:21
2022-03-30 04:13:55
2022-03-30 05:04:14
2022-03-28 14:24:28
2022-03-28 15:47:32
2022-03-29 09:56:04
2022-03-29 13:18:57
2022-03-29 20:52:59
2022-03-30 04:11:46
 |  |  | Should be blank
Spreadsheet: 167705d1342072324-is-there-a-formula-for-column-must-contain-challenge
Sheet: Sheet1

SCHEDULE
MONTH | MAY |  |  |  |  | 2012 |  |  |  |  |  |  | STAFF MEETING:
 |  |  |  |  |  |  |  |  |  |  |  |  | TIME: MAY 16TH 5PM
DATE POSTED:
 | APRIL/MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 9 | D | 1
DAY | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | N | 2
KIMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OP | 3
CAROLE
CLAUDIA
DAWN
SHERRI
KIMBERLY
MARY | 1
SUSIE | 3
[NAME] | 4
BOB
[NAME].
PAGER [PHONE] |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
HOSPITAL [PHONE] |  |  |  | EXT | 6467 |  |  |  |  |  | Office:  7110 |  |  |  |  | EXT | 2233
 |  |  |  | Cell:[PHONE] |  |  |  |  |  |  | Home: 574-4522 |  |  |  |  | Home | [PHONE]
 |  |  |  | Home: |  |  |  |  |  |  | Cell:  992-2979 |  |  |  |  | Cell | [PHONE]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | EXT | 7512
 |  |  |  |  |  |  |  |  |  |  | Cell: [PHONE]
Spreadsheet: 118403d1313662888-creating-more-rows-dependant-on-how-many-months-are-in-a-defined-time-period-example-new-work
Sheet: Pivot Table Data

Job Product Code | Job Product Total | Frequency In Weeks | Construction Start Date | Construction End Date
HS1 | 697.0319634703196 | 4 | 2009-04-01 00:00:00 | 2009-12-31 00:00:00
HS1 | 420 | 4 | 2009-04-01 00:00:00 | 2009-12-31 00:00:00
HS8 | 295 | 4 | 2009-04-01 00:00:00 | 2009-12-31 00:00:00
HS15 | 9420.75 | 4
HS14 | 10 | 4 | 2009-04-01 00:00:00 | 2010-12-31 00:00:00
HS14 | 81 | 2 | 2009-04-15 00:00:00 | 2010-09-15 00:00:00
HS1 | 825 | 4 | 2009-06-15 00:00:00 | 2010-03-22 00:00:00
HS14 | 110 | 2 | 2009-06-15 00:00:00 | 2010-03-22 00:00:00
Spreadsheet: 172901d1344365262-calculation-time-too-high-calculation-time
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Your formula |  | Helper | [NAME] using helper |  |  | [NAME] without helper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9587
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22547
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17640
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43569
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14571
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28207
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33936
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45971
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29781
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24034
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35963
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3599
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33207
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19035
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40686
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41995
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44055
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19954
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41312
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25452
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24910
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31204
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14458
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9092
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10188
Spreadsheet: 692217d1598186608-count-and-sum-negative-numbers-on-filtered-lines-conta_somma
Sheet: Foglio1

 | B | R |  | Count | Sum
 | cc | 1
 | dd | 2
 | ee | 3
 | ff | 4
 | gg | -1
 | hh | -1
 | iii | -1
 | ll | -1
 | [NAME] | -1
 | nn | -2
 | oo | -3
 | pp | 8
 | qq | -1
 | rr | 6
 | ss | -1
 | tt | -1
 | uu | 10
========================================================ù
 | B | R |  | Count | Sum
 | cc | 1 | A
 | dd | 2 | B
 | ee | 3 | C
 | ff | 4 | D
 | gg | -1 | E
l | hh | -1 | F
 | iii | -1 | G
 | ll | -1 | H
o | [NAME] | -1 | I
 | nn | -2 | J
 | oo | -3 | K
 | pp | 8 | L
 | qq | -1 | M
 | rr | 6 | N
 | ss | -1 | O
 | tt | -1 | P
 | uu | 10 | Q
Spreadsheet: 711756d1609879964-daily-sales-spreadsheet-month-target-2-
Sheet: Sheet1

Monthly Target | 2021-01-01 00:00:00 |  |  |  |  |  | HIDE ME |  | 2021-02-01 00:00:00 |  |  |  |  |  |  | 2021-03-01 00:00:00
62500 |  |  |  |  |  |  | Holidays
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | 2021-01-01 00:00:00 | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  | 2491 |  |  |  |  |  |  |  | 2491 |  |  |  |  |  |  | 2491
 |  |  | 2553 |  |  |  |  |  |  |  | 2553 |  |  |  |  |  |  | 2553
TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Spreadsheet: 100709d1298990203-extracting-date-specific-data-formula-sample-1
Sheet: MOVEMENTS LOG

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S |  | AT |  | POS |  | C |  | PVT |  | MIL |  |  | S61 |  | BN2P |  |  | SB |  |  | [NAME] |  |  | SB |  |  | AT |  | PVT |  | MIL |  | V |  | BN2P |  | [NAME] |  | S61 |  | AT |  | PVT |  | MIL
Date |  | [NAME] | Type | Opr. | Flt. No. | ATA | FROM | RWY | Rules | CAT | PAX | Flt. No. | ATD | TO | RWY | Rules | CAT | PAX | T&G | T/L | V | REMARKS |  |  |  | T/Arr | T/Dep | T/T&G |  | Arr | Dep | Arr | Dep | Arr | Dep | Arr | Dep | Arr | Dep | Arr | Dep |  | S | S | S | C | POS | S | C | POS | S | C | POS | S | C | POS |  |  |  |  |  |  | 1
2011-03-01 00:00:00 |  | GSSKY |  |  |  | 0900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In | Out | Inbound |  |  | Outbound |  |  | Inbound |  |  | Outbound |  |  | In | Out | In | Out | In | Out | Total |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
2011-03-01 00:00:00 |  | GBFFJ |  |  | 0850 | 0905
2011-03-02 00:00:00 |  | GBFFJ |  |  | 0735 | 0800
Spreadsheet: 852336d1702399147-fiscal-year-look-up-fy-formula-help-_etaf
Sheet: Sheet1

 | Start | End |  | Date | FY Output | [NAME]
FY22 | 2022-07-01 00:00:00 | 2023-06-30 00:00:00 |  | 2022-08-02 00:00:00 | FY22
FY23 |  | 2024-06-30 00:00:00 |  | 2024-04-15 00:00:00 | FY23
FY24 |  | 2025-06-30 00:00:00 |  | 2025-11-24 00:00:00 | FY25
FY25 |  | 2026-06-30 00:00:00 |  | 2025-05-01 00:00:00 | FY24
Spreadsheet: 102649d1300626675-automated-worksheet-for-accounting-filter-problem-automated-worksheets
Sheet: Track General

 |  |  | Completed By :
SUPPLIER NAME | INVOICE # | ACCOUNT # | AMOUNT | DATE | NameInvoice
Acme (Clean. Supl.) | 12305 | 62750.276 | 1 | 2011-01-01 00:00:00 | Acme_40544^12305
Acme (Laundry Supl.) | 12305 | 62750.278 | 2 | 2011-01-01 00:00:00 | Acme_40544^12305
Acme (Paper Supl.) | 12305 | 62750.277 | 3 | 2011-01-01 00:00:00 | Acme_40544^12305
Albrite Lighting | 22817 | 68700.565 | 4 | 2011-01-02 00:00:00 | Albrite Lighting_40545^22817
Albrite Lighting (567) | 22817 | 68700.567 | 5 | 2011-01-02 00:00:00 | Albrite Lighting)_40545^22817
Cintas (Food Serv. Unifrm.) | A-20811 | 60850 | 6 | 2011-01-03 00:00:00 | Cintas_40546^A-20811
Cintas (Uniforms Hskp.) | A-20811 | 62850 | 7 | 2011-01-03 00:00:00 | Cintas_40546^A-20811
Cintas (Uniforms W&V) | A-20811 | 64972 | 8 | 2011-01-03 00:00:00 | Cintas_40546^A-20811
[NAME] ([NAME].) | 6563300 | 79045 | 9 | 2011-01-04 00:00:00 | E. Madill_40547^6563300
[NAME] (WV) | 6563300 | 64975 | 10 | 2011-01-04 00:00:00 | E. Madill_40547^6563300
 |  |  | 55
Entered in Expense Tracking By:______________
APPROVED: |  | DATED:
(Manager)
Spreadsheet: 58008d1258318402-duplicating-text-into-columns-in-extra-sheets-pub-schedule
Sheet: John

 | 2001-01-01 00:00:00
 | T                   2
 | 3
1 | 4
 | 5
 | 6
 | 7
 | 8 | pub2
 | 9
 | 10
 | 11
2 | 12
 | 13
 | 14 | pub1
 | 15
 | 16
 | 17
 | 18
3 | 19
 | 20
 | 21
 | 22 | pub 3
 | 23
 | 24
 | 25
4 | 26
 | 27
 | 28
 | 29 | pub 3
 | 30
 | 31
Spreadsheet: 0209c337-9479-42e7-919a-12615ce38373
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Searches | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Month: | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Grand total:
SearchGroups: | SearchType:
Total Browse Searches | Browse by Alphabet | 2324 | 2046 | 5088 | 6095 | 5813 | 3170 | 3292 | 6575 | 5505 | 5490 | 3155 | 3055 | 51608
 | Browse by Subject | 687 | 499 | 1952 | 2783 | 2797 | 1199 | 704 | 2408 | 2095 | 2397 | 898 | 781 | 19200
 | Total Browse Searches total: | 3011 | 2545 | 7040 | 8878 | 8610 | 4369 | 3996 | 8983 | 7600 | 7887 | 4053 | 3836 | 70808
Total [NAME] | Title Begins With | 2227 | 1966 | 4193 | 6264 | 6112 | 3449 | 3140 | 6681 | 6640 | 7207 | 3904 | 4255 | 56038
 | Title Contains | 198 | 175 | 594 | 1190 | 1109 | 455 | 266 | 844 | 863 | 1104 | 378 | 502 | 7678
 | Title Equals | 56 | 51 | 174 | 295 | 277 | 101 | 76 | 281 | 224 | 298 | 91 | 73 | 1997
 | Total Titles Searches total: | 2481 | 2192 | 4961 | 7749 | 7498 | 4005 | 3482 | 7806 | 7727 | 8609 | 4373 | 4830 | 65713
Other Searches | ISSN Equals | 44 | 36 | 98 | 135 | 139 | 42 | 48 | 199 | 203 | 181 | 112 | 110 | 1347
 | MARC | 2253 | 1730 | 3976 | 6574 | 5666 | 2689 | 2546 | 5638 | 5250 | 5029 | 2056 | 2363 | 45770
 | OpenURL | 9261 | 6152 | 15958 | 31765 | 32219 | 15314 | 10414 | 27322 | 23329 | 27617 | 8599 | 8836 | 216786
 | Other Searches total: | 11558 | 7918 | 20032 | 38474 | 38024 | 18045 | 13008 | 33159 | 28782 | 32827 | 10767 | 11309 | 263903
Grand total: |  | 17050 | 12655 | 32033 | 55101 | 54132 | 26419 | 20486 | 49948 | 44109 | 49323 | 19193 | 19975 | 400424
Spreadsheet: 462599d1464111710-autofill-cell-based-upon-two-different-cells-example-work-book-1-
Sheet: Sheet1

 | Chart |  |  |  |  |  | Data
 | Select Location |  | Pull down for location
 |  |  |  |  |  |  | Locations |  | Parts loc 1 | Par tNo Loc 1 |  | Parts loc 2 | Par tNo Loc 2 |  | Parts loc 3 | Par tNo Loc 3
 | Parts List | Part No |  |  |  |  | Plant 1 |  | screw A | Part [NAME] |  | screw D | Part [NAME] |  | screw G | Part [NAME]
1 |  |  |  |  |  |  | Plant 2 |  | screw B | Part [NAME] |  | screw E | Part [NAME] |  | screw H | Part [NAME]
2 |  |  |  |  |  |  | Plant 3 |  | screw C | Part [NAME] |  | screw F | Part [NAME] |  | screw I | Part Screw I
3
4
 | Pull down for parts list | Self fill part no
 | Example below of desired output
 | Chart
 | Select Location | Plant 1
 | Parts List | Part No
1 | [NAME] | Part [NAME]
2 | [NAME] | Part [NAME]
3 | [NAME] | Part [NAME]
4
 | Chart
 | Select Location | Plant 3
 | Parts List | Part No
1 | [NAME] I | Part Screw I
2 | [NAME] | Part [NAME]
3 | [NAME] | Part [NAME]
4
Spreadsheet: 4826a00b-c28e-4ee7-977b-69d2f2c614d5
Sheet: Segments

Johnson & Johnson and Subsidiaries
Supplementary Sales Data
([NAME]; Dollars in Millions) |  |  |  |  | FIRST QUARTER
 |  |  |  |  |  |  |  |  |  |  | Percent Change
 |  |  | Pulls fm Rpt | Adj | 2010 |  | 2009 |  | Change $ |  | Total |  | Operations $ |  | Operations |  | Currency $ |  | Currency
Sales to customers by
segment of business
Consumer
U.S. |  | Great | 1560 |  | 1560 |  | 1726 |  | -166 |  | -9.6 | % | -166 |  | -9.6 |  | 0 |  | 0
International |  | Great | 2206 |  | 2206 |  | 1985 |  | 221 |  | 11.1 |  | 28 |  | 1.4 |  | 193 |  | 9.7
 |  | Great |  |  | 3766 |  | 3711 |  | 55 |  | 1.5 |  | -138 |  | -3.7 |  | 193 |  | 5.2
Pharmaceutical
U.S. |  | Great | 3206 |  | 3206 |  | 3674 |  | -468 |  | -12.7 |  | -468 |  | -12.7 |  | 0 |  | 0
International |  | -1 | 2433 |  | 2432 |  | 2106 |  | 326 |  | 15.5 |  | 138 |  | 6.6 |  | 188 |  | 8.9
 |  | Great |  |  | 5638 |  | 5780 |  | -142 |  | -2.5 |  | -330 |  | -5.699999999999999 |  | 188 |  | 3.2
Med Devices & Diagnostics
U.S. |  | 1 | 2885 |  | 2886 |  | 2652 |  | 234 |  | 8.8 |  | 234 |  | 8.8 |  | 0 |  | 0
International |  | Great | 3341 |  | 3341 |  | 2883 |  | 458 |  | 15.9 |  | 215 |  | 7.5 |  | 243 |  | 8.4
 |  | Great |  |  | 6227 |  | 5535 |  | 692 |  | 12.5 |  | 449 |  | 8.1 |  | 243 |  | 4.4
U.S. |  | Great | 7652 |  | 7652 |  | 8052 |  | -400 |  | -5 |  | -400 |  | -5 |  | 0 |  | 0
International |  | Great | 7979 |  | 7979 |  | 6974 |  | 1005 |  | 14.4 |  | 381 |  | 5.5 |  | 624 |  | 8.9
Worldwide |  | Great |  |  | 15631 |  | 15026 |  | 605 |  | 4 | % | -19 |  | -0.1000000000000005 |  | 624 |  | 4.100000000000001
Spreadsheet: 482572d1475113560-importing-from-another-worksheet-problems-revenuechecker
Sheet: Checker

CT | PS | Checker | Missing Checks | Value-NUM | Value of Missing Checks | CT Date Checker
 |  |  |  |  |  | 9/20/2016
 |  |  |  |  |  | PS Date Checker