tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 762133d1641404029-countif-help-for-totaling-multiple-criteria-recruiting-stats-2022
Sheet: LMV BG Tracker

Employee Name | Tour Date | Date Submitted to Validity | Days Pending Validity | Work Type | Shift | Status | Date sent to LMV for review | Days in Review | [NAME] | Education Test Status | NOTES
[NAME] |  |  |  | FT | PROD 3-A | Ready to Start |  |  | CLEARED | PASSED | Sched 1/6/22 ORI
[NAME] |  |  |  | FT | PROD 2-A | Ready to Start |  |  | APPROVED BY LMV | PASSED | Sched 1/6/22 ORI
[NAME] |  |  |  |  |  | Not Hiring |  |  | DENIED BY LMV | FAILED
[NAME] |  |  |  | FT | PROD 2-A | Ready to Start |  |  | CLEARED |  | Sched 1/7/22 ORI
[NAME] |  |  |  |  | LOG 3-A | Not Hiring |  |  | FLAGGED |  | DNP
[NAME] |  |  |  | FT | PROD 1-A | Ready to Start |  |  | CLEARED | PASSED | Sched 1/6/22 ORI
[NAME] |  |  |  | FT | LOG 1-A |  |  |  | CLEARED | PASSED
[NAME] |  |  |  | FT | PROD 3-A |  |  |  | CLEARED |  | Sched 1/6/22 ORI
[NAME] |  |  |  |  |  | Not Hiring |  |  | DENIED BY LMV |  | Never heard back from to complete NHP 12/30/2021- MS
Neville Batchiambila |  |  |  |  |  | Not Hiring |  |  | DENIED BY LMV |  | Never heard back from to complete NHP 12/30/2021- MS
[NAME] |  |  |  | FT | PROD 2-A | Ready to Start |  |  | CLEARED |  | Sched 1/6/22 ORI
[NAME] |  |  |  |  |  | Not Hiring |  |  | DENIED BY LMV
[NAME] |  |  |  | FT |  |  |  |  | CLEARED |  | Needs I-9 docs- 12/18/2021- MS
[NAME] |  |  |  | FT | PROD 3-A | Ready to Start |  |  | CLEARED |  | Need to check on FL test and cannot start/ tour until after 1/3/2022
[NAME] |  |  |  | FT | PROD 1-A |  |  |  | PENDING VALIDITY
[NAME] |  |  |  | FT | LOG 3-A |  |  |  | CLEARED | PASSED | Sched 1/7/22 ORI
Mariah Berry |  |  |  | FT | PROD 2-A |  |  |  | CLEARED | PASSED | Needs 2nd ID
[NAME] |  |  |  | FT | PROD 1-A |  |  |  | PENDING VALIDITY
[NAME] |  |  |  | FT | LOG 2-A | Pre-Hire |  |  | PENDING VALIDITY
Sierra Roustic |  |  |  | FT | LOG 2-A | Pre-Hire |  |  | CLEARED | PASSED
[NAME] |  |  |  | FT | LOG 2-A | Pre-Hire |  |  | PENDING LMV APPROVAL | PASSED
Payton Jauhola |  |  |  | FT | PROD 1-A | Ready to Start |  |  | CLEARED | PASSED
[NAME] |  |  |  | FT | PROD 1-A | Pre-Hire |  |  | PENDING VALIDITY
[NAME] |  |  |  | FT | LOG 1-A | Pre-Hire |  |  | PENDING VALIDITY
[NAME] |  |  |  | FT | PROD 2-A | Pre-Hire |  |  | PENDING VALIDITY
[NAME] |  |  |  | FT | LOG 3-A | Pre-Hire |  |  | PENDING VALIDITY
[NAME] |  |  |  | FT | PROD 3-A | Pre-Hire |  |  | PENDING VALIDITY
[NAME] |  |  |  | FT | PROD 1-A | Pre-Hire |  |  | PENDING VALIDITY
[NAME] |  |  |  | PT | PROD 2-A | Ready to Start |  |  | CLEARED |  | Sched 1/7/22 ORI
[NAME] |  |  |  | PT | PROD 1-A | Pre-Hire |  |  | CLEARED |  | Does not want FT hours
[NAME] |  |  |  | PT | PROD 2-A | Ready to Start |  |  | CLEARED
[NAME] |  |  |  | FT | PROD 1-A | Pre-Hire
Spreadsheet: 874127d1720698831-sumproduct-two-columns-of-criteria-not-exact-match-basketball-audience-excel-help-forum-btray90-
Sheet: AUDIENCE

NETWORK | DUR | Program Name | AWAY | HOME | AUDIENCE
ESPN2 | 133 | WNBA BASKETBALL         L | INDIANA | CONNECTICUT | 2116741
ESPN2 | 135 | WNBA BASKETBALL         L | PHOENIX | LAS VEGAS | 464171
ION | 138 | WNBA FRI PM SPOTLIGHT G1 | WASHINGTON | CONNECTICUT | 289709
ION | 159 | WNBA FRI PM SPOTLIGHT G2 | SEATTLE | MINNESOTA | 265693
ABC | 126 | WNBA ON ABC 1-5/18 | INDIANA | NEW YORK | 1714491
ABC | 130 | WNBA ON ABC 2-5/18 | LOS ANGELES | LAS VEGAS | 1343434
CBS | 133 | WNBA REGULAR SEASON L | ATLANTA | PHOENIX | 107982
NBC | 131 | WNBA REGULAR SEASON L | CHICAGO | DALLAS | 101449
ESPN | 135 | WNBA  BASKETBALL        L | CONNECTICUT | INDIANA | 1556113
ION | 131 | WNBA FRI PM SPOTLIGHT G1 | INDIANA | LOS ANGELES | 724208
ABC | 125 | WNBA REGULAR SEASON L | INDIANA | LAS VEGAS | 333193
CBS | 124 | WNBA ON CBS | NEW YORK | MINNESOTA | 704308
ABC | 140 | WNBA REGULAR SEASON L | LOS ANGELES | INDIANA HOOPS | 356237
NBC | 117 | WNBA REGULAR SEASON L | LAS VEGAS | MINNESOTA | 134094
ION | 137 | WNBA FRI PM SPOTLIGHT G1 | VARIOUS TEAMS AND TIMES |  | 388960
ION | 105 | WNBA FRI PM SPOTLIGHT G2 | PHOENIX | MINNESOTA | 367780
ESPN | 125 | WNBA  BASKETBALL        L | CHICAGO | INDIANA | 1532623
ABC | 118 | WNBA REGULAR SEASON L | INDIANA | NEW YORK | 429619
ESPN | 129 | WNBA REGULAR SEASON L | NEW YORK | CHICAGO | 239107
ESPN2 | 127 | WNBA REGULAR SEASON L | LAS VEGAS | DALLAS | 174440
ION | 127 | WNBA FRI PM SPOTLIGHT G1 | INDIANA HOOPS | WASHINGTON LEGENDS | 1023428
ION | 128 | WNBA FRI PM SPOTLIGHT G2 |  | VARIOUS TEAMS AND TIMES | 527578
ABC | 127 | WNBA [NAME] | NEW YORK | CONNECTICUT | 961821
ION | 127 | WNBA REGULAR SEASON L | ATLANTA | CHICAGO | 174579
ABC | 123 | WNBA REGULAR SEASON L | INDIANA | CONNECTICUT | 424040
ABC | 132 | WNBA REGULAR SEASON L | MINNESOTA | LAS VEGAS | 155545
ESPN | 124 | WNBA  BASKETBALL        L | SEATTLE | DALLAS | 419693
ION | 125 | WNBA FRI PM SPOTLIGHT G1 | VARIOUS TEAMS AND TIMES |  | 330460
CBS | 132 | WNBA ON CBS | CONNECTICUT | DALLAS | 670833
ABC | 122 | WNBA ON ABC-6/15 | NEW YORK | LAS VEGAS | 995803
CBS | 129 | WNBA ON CBS-SUN | CHICAGO | INDIANA | 2252331
ESPN | 124 | WNBA REGULAR SEASON L | LOS ANGELES | CONNECTICUT | 123036
ESPN2 | 122 | WNBA REGULAR SEASON L | WASHINGTON | INDIANA | 460396
ESPN | 127 | WNBA REGULAR SEASON L | SEATTLE | LAS VEGAS | 179443
ABC | 132 | WNBA FRI PM SPOTLIGHT G1 | INDIANA HOOPS | ATLANTA | 1179157
ION | 120 | WNBA FRI PM SPOTLIGHT G2 | CONNECTICUT | LAS VEGAS STARS | 691227
ESPN | 125 | WNBA  BASKETBALL        L | LOS ANGELES | NEW YORK | 463746
NBC | 122 | WNBA REGULAR SEASON L | PHOENIX | MINNESOTA | 147497
ESPN | 136 | WNBA  BASKETBALL        L | INDIANA | CHICAGO | 2301547
 | DURATION SUM
TOTAL AVERAGE
ABC |  |  | # of games
INDIANA GAMES
INDIANA GAMES ON ABC
Spreadsheet: 122914d1317237680-copying-multiple-cells-based-on-drop-down-employee-ranking
Sheet: BP Input WK4

Location | Employee # | Employee | Apps | Approval | AS+ | Preapprov | [NAME] | ITA | ITA% | Existing | Existing %
Store 479 | 241087 | Roark, [NAME] | 67 | 0.4179 | 14 | 0 | 0 | 14 | 0 | 0 | 0
Store 479 | 10594 | [NAME], Stephen | 50 | 60 | 1 | 8 | 12.5 | 10 | 0 | 0 | 0
Spreadsheet: mary_fischer__25635__31R
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031R
COMPANY NAME    Limbach Company Holding Company
ANALYSIS OF OTHER DEFERRED CREDITS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 790960d1660078256-look-up-tool-calc-x
Sheet: Consultant Calculator

 |  |  |  |  |  |  | Billings
Basic | Title | Days Per Week | Runners | Days Average | Margin Average | Per Week | Per 4 Week Average | Per Year
25000 | Trainee | 5 |  | 25 | 50
28000 | Junior | 5 |  | 50 | 50
32500 | Consultant | 5 |  | 100 | 50
35000 | Consultant 2 | 5 |  | 150 | 50
40000 | Consultant 3 | 5 |  | 200 | 50
45000 | Consultant 3 | 5 |  | 250 | 50
50000 | Principal | 5 |  | 300 | 50
65000 | Partner | 5 |  | 500 | 50
 |  |  | Average Days |  |  |  | (4 weeks)
Basic |  |  | Runners | Days | Margin | GP Week | GP Month | GP Year
28000 |  | 5 |  | 100 | 50
 |  |  |  | *Input | *Input
Commision
OTE | Per Month
Rate | Range | Rate Diff | Amount
0.1 | 0 | 0.1
0.15 | 1500
0.2 | 19999
See …
http://www.mcgimpsey.com/excel/variablerate.html
Spreadsheet: 270727d1381610287-counting-based-on-3-values-spare-count1_reply
Sheet: Sheet1

Name | Week | Date |  |  |  |  |  |  | WEEK | WEEK | WEEK
[NAME] | 19 | 2013-11-02 00:00:00 |  |  |  |  |  |  | 19 | 20 | 21
[NAME] | 19 | 2013-11-03 00:00:00 |  |  |  |  |  | [NAME]
[NAME] | 19 | 2013-11-04 00:00:00 |  |  |  |  |  | MARK
[NAME] | 19 | 2013-11-05 00:00:00
[NAME] | 19 | 2013-11-06 00:00:00 | Spare
[NAME] | 19 | 2013-11-07 00:00:00
[NAME] | 19 | 2013-11-08 00:00:00
[NAME] | 20 | 2013-11-09 00:00:00 | Spare
[NAME] | 20 | 2013-11-10 00:00:00 |  |  |  |  |  | What the outcome should be:
[NAME] | 20 | 2013-11-11 00:00:00 |  |  |  |  |  |  | WEEK | WEEK | WEEK
[NAME] | 20 | 2013-11-12 00:00:00 |  |  |  |  |  |  | 19 | 20 | 21
[NAME] | 20 | 2013-11-13 00:00:00 |  |  |  |  |  | [NAME] | 1 | 1 | 3
[NAME] | 20 | 2013-11-14 00:00:00 |  |  |  |  |  | MARK | 2 | 3 | 0
[NAME] | 20 | 2013-11-15 00:00:00
[NAME] | 21 | 2013-11-16 00:00:00
[NAME] | 21 | 2013-11-17 00:00:00
[NAME] | 21 | 2013-11-18 00:00:00 | Spare
[NAME] | 21 | 2013-11-19 00:00:00 | Spare
[NAME] | 21 | 2013-11-20 00:00:00 | Spare
[NAME] | 21 | 2013-11-21 00:00:00
[NAME] | 21 | 2013-11-22 00:00:00
MARK | 19 | 2013-11-02 00:00:00
MARK | 19 | 2013-11-03 00:00:00 | Spare
MARK | 19 | 2013-11-04 00:00:00
MARK | 19 | 2013-11-05 00:00:00
MARK | 19 | 2013-11-06 00:00:00 | Spare
MARK | 19 | 2013-11-07 00:00:00
MARK | 19 | 2013-11-08 00:00:00
MARK | 20 | 2013-11-09 00:00:00
MARK | 20 | 2013-11-10 00:00:00
MARK | 20 | 2013-11-11 00:00:00
MARK | 20 | 2013-11-12 00:00:00
MARK | 20 | 2013-11-13 00:00:00 | Spare
MARK | 20 | 2013-11-14 00:00:00 | Spare
MARK | 20 | 2013-11-15 00:00:00 | Spare
MARK | 21 | 2013-11-16 00:00:00
MARK | 21 | 2013-11-17 00:00:00
MARK | 21 | 2013-11-18 00:00:00
MARK | 21 | 2013-11-19 00:00:00
MARK | 21 | 2013-11-20 00:00:00
MARK | 21 | 2013-11-21 00:00:00
MARK | 21 | 2013-11-22 00:00:00 | Spare
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: Next Catalogue

Next Catalogue
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009 | 50
April | 2009 | 50
May | 2009 | 50
June | 2009 | 50
July | 2009 | 50
August | 2009 | 50
September | 2009 | 50
October | 2009 | 50
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 305236d1395154979-how-to-stop-a-count-of-days-when-a-date-is-entered-on-a-specific-cell-excel-sample
Sheet: Inventory Control

Date Received | Order Type | Order Number | ORDER NAME | Sales Rep | Artist | Due Date | Completed | RFI Out | RFI In | Dates of RFI | Days In Artroom | Days Remaining | Today's Date | Internal Feedback Notes
2014-01-07 00:00:00 | OR | 1453 | JOB ONE | [NAME] | [NAME] | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
2014-03-11 00:00:00 | OR | 1932 | JOB TWO | [NAME] | [NAME] | 2014-03-14 00:00:00 | 2014-03-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-08-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-25 00:00:00
Spreadsheet: 866800d1713719349-trying-to-return-a-value-using-xlookup-and-match-from-a-price-table-mtm-customer-order-form-with-prices-ef
Sheet: Sheet2

Product | [NAME] | Height | Frame colour | Mesh type | Reinforced pull bar | Brackets | Fixing holes | Quantity | Column1
Window Screen |  |  | White | Standard | Yes | None | None |  | Guides
Single Door Screen |  |  | [NAME] | Tough | No | Face fix | Face Fix |  | 30[NAME]
Double Door Screen |  |  | Black | Midge |  | Top fix | [NAME] |  | 40mm
Blackout Screen |  |  | [NAME]
 |  |  | [NAME] RAL
Spreadsheet: 781824d1653572656-need-help-with-pulling-data-from-one-sheet-to-another-using-index-requiredtraining2022-test-1-aligw
Sheet: Dashboard

Select Supervisor Below | SupervisorList |  | Employee Name | Class1 | Class2 |  | Monday1End | Monday2End | Tuesday1End | Tuesday2End | Wednesday1End | Wednesday2End | Thursday1End | Thursday2End | [NAME] | Friday2End
Supervisor, [NAME] | Supervisor, [NAME]
 | Supervisor, [NAME]
Spreadsheet: d5cd0405-d2f6-449d-87c8-1f63af0bd6c7
Sheet: Sheet1

Release: S&P/Case-Shiller Home Price Indices | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=199
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-19 10:52 PM CST
 | Real-Time | Period
Name: | Start | End
S&P/Case-Shiller Home Price Indices | 2010-10-26 00:00:00 | Current
Link:
http://www.standardandpoors.com/indices/sp-case-shiller-home-price-indices/en/us/?indexId=spusa-cashpidff--p-us---- | 2010-10-26 00:00:00 | Current
Source:
Standard and Poor's | 2010-10-26 00:00:00 | 2012-07-01 00:00:00
S&P Dow Jones Indices LLC | 2012-07-02 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:
2010-10-26 00:00:00
2010-11-30 00:00:00
2010-12-28 00:00:00
2011-01-25 00:00:00
2011-02-22 00:00:00
2011-03-29 00:00:00
2011-04-26 00:00:00
2011-05-31 00:00:00
2011-06-28 00:00:00
2011-07-26 00:00:00
2011-08-30 00:00:00
2011-09-27 00:00:00
2011-10-25 00:00:00
2011-11-29 00:00:00
2011-12-27 00:00:00
2012-01-31 00:00:00
2012-02-28 00:00:00
2012-03-27 00:00:00
2012-04-24 00:00:00
2012-05-29 00:00:00
2012-06-26 00:00:00
2012-07-31 00:00:00
2012-08-28 00:00:00
2012-09-25 00:00:00
2012-10-30 00:00:00
2012-11-27 00:00:00
2012-12-26 00:00:00
2013-01-29 00:00:00
2013-02-26 00:00:00
2013-03-26 00:00:00
2013-04-30 00:00:00
2013-05-28 00:00:00
2013-06-25 00:00:00
2013-07-30 00:00:00
2013-08-27 00:00:00
2013-09-24 00:00:00
2013-10-29 00:00:00
2013-11-26 00:00:00
2013-12-31 00:00:00
2014-01-28 00:00:00
2014-02-25 00:00:00
2014-03-25 00:00:00
2014-04-29 00:00:00
2014-05-27 00:00:00
2014-06-24 00:00:00
2014-07-29 00:00:00
2014-08-26 00:00:00
2014-09-30 00:00:00
2014-10-28 00:00:00
2014-11-25 00:00:00
Spreadsheet: a401270f-3a75-41e8-b422-5bdfefcb1a11
Sheet: State by State Breakdown

 | Row Labels | Landfills  (Unlined) | Landfills (Lined) | Landfills (Unknown) | Total Landfills | Ponds (Unlined) | Ponds (Lined) | Ponds (Unknown) | Total Ponds | Grand Total  (Ponds & Landfills)
 | AL | 1 | 2 |  | 3 | 19 | 5 | 4 | 28 | 31
 | AR |  | 3 | 0 | 3 | 2 |  | 2 | 4 | 7
 | AZ | 3 | 1 | 0 | 4 | 21 | 37 | 0 | 58 | 62
 | CO | 7 |  | 0 | 7 | 6 | 13 | 0 | 19 | 26
 | DE | 1 | 2 | 0 | 3 |  |  | 0 |  | 3
 | FL | 6 | 7 | 0 | 13 | 12 | 27 | 0 | 39 | 52
 | GA | 2 | 6 | 0 | 8 | 31 | 9 | 0 | 40 | 48
 | IA | 8 | 6 | 0 | 14 | 19 | 4 | 0 | 23 | 37
 | IL | 3 | 7 | 0 | 10 | 37 | 34 | 13 | 84 | 94
 | IN | 4 | 14 | 0 | 18 | 52 | 26 | 0 | 78 | 96
 | KS | 6 | 3 | 0 | 9 | 6 | 8 | 0 | 14 | 23
 | KY | 4 | 6 | 0 | 10 | 39 | 9 | 0 | 48 | 58
 | LA |  | 4 | 0 | 4 |  | 13 | 0 | 13 | 17
 | MA |  | 5 | 0 | 5 | 2 | 8 | 0 | 10 | 15
 | MD |  | 3 | 0 | 3 | 2 | 3 | 0 | 5 | 8
 | MI | 2 | 3 | 10 | 15 | 4 | 10 | 24 | 38 | 53
 | MN |  | 10 | 0 | 10 | 5 | 13 | 0 | 18 | 28
 | MO | 3 | 9 | 0 | 12 | 13 | 19 | 6 | 38 | 50
 | MS |  | 7 | 2 | 9 | 2 | 9 | 0 | 11 | 20
 | MT |  |  | 0 |  |  | 9 | 0 | 9 | 9
 | NC | 2 | 5 | 0 | 7 | 29 | 4 | 0 | 33 | 40
 | ND | 6 | 12 | 0 | 18 | 4 | 14 | 0 | 18 | 36
 | NE | 4 | 8 | 0 | 12 | 4 | 4 | 0 | 8 | 20
 | NH | 1 | 1 | 0 | 2 | 3 |  | 0 | 3 | 5
 | NJ | 2 |  | 0 | 2 | 4 |  | 0 | 4 | 6
 | NM | 1 | 1 | 1 | 3 | 3 | 19 | 6 | 28 | 31
 | NV | 2 |  | 0 | 2 |  | 12 | 0 | 12 | 14
 | NY |  | 7 | 0 | 7 | 3 | 3 | 0 | 6 | 13
 | OH | 1 | 11 | 1 | 13 | 39 | 21 | 0 | 60 | 73
 | OK |  | 3 | 0 | 3 | 3 | 10 | 0 | 13 | 16
 | OR |  | 1 | 0 | 1 | 2 | 1 | 0 | 3 | 4
 | PA | 13 | 14 | 1 | 28 | 21 | 45 | 0 | 66 | 94
 | SC | 3 | 4 | 0 | 7 | 13 | 5 | 0 | 18 | 25
 | SD | 1 |  | 0 | 1 | 2 |  | 0 | 2 | 3
 | TN |  | 5 | 0 | 5 | 8 | 2 | 1 | 11 | 16
 | TX | 9 | 24 | 2 | 35 | 4 | 65 | 0 | 69 | 104
 | UT | 6 |  | 0 | 6 | 6 | 7 | 0 | 13 | 19
 | VA |  | 8 | 1 | 9 | 14 | 11 | 0 | 25 | 34
 | WA |  | 1 | 0 | 1 |  | 2 | 0 | 2 | 3
 | WI | 7 | 5 | 4 | 16 | 9 | 12 | 0 | 21 | 37
 | WV | 4 | 10 | 0 | 14 | 17 | 18 | 0 | 35 | 49
 | WY | 3 |  | 0 | 3 | 10 | 10 | 0 | 20 | 23
 | Grand Total | 115 | 218 | 22 | 355 | 470 | 521 | 56 | 1047 | 1402
Spreadsheet: 526291d1499243317-comparing-address-and-produce-out-of-exact-address-lookup-of-address
Sheet: Sheet1

Before |  |  |  | After |  | Solved Formula
Address 1 | Comparing Address2 |  |  | Address 1-Output |  | Address 1-Output
1ST FLOOR, MAKER TOWER, BESIDE GOPALPURA PULIA, TONK ROAD JAIPUR¿ PIN: 302017 GOPALPURA | 1ST FLOOR, MAKER TOWER,,BESIDE GOPALPURA PULIA, TONK ROAD,,04,Jaipur, Rajasthan, 302001, IN |  |  | 1ST FLOOR, MAKER TOWER, BESIDE GOPALPURA PULIA, TONK ROAD JAIPUR¿ PIN: 302017 GOPALPURA
NEAR NH-14, SHOP NO. 24-25, JHORA MAGARA HOTEL, GOYALI CHORAHA, SIROHI-307001 SIROHI | NEAR NH-14, SHOP NO. 24-25,,JHORA MAGARA HOTEL,GOYALI CHORAHA, SIROHI-307001,04,SIROHI, Rajasthan, 307001, IN |  |  | NEAR NH-14, SHOP NO. 24-25, JHORA MAGARA HOTEL, GOYALI CHORAHA, SIROHI-307001 SIROHI
309. Gravity Complex, Opp. Amba Ashram, Anand Nadiad Road,Above Havmour Restaurent, | 309. GRAVITY COMPLEX,OPP. AMBA ASHRAM,COLLEGE ROAD,ABOVE HAVMOUR RESTAURENT,NADIAD387001,NADIAD,,04,NADIAD, Gujarat, 387001, IN |  |  | 309. Gravity Complex, Opp. Amba Ashram, Anand Nadiad Road,Above Havmour Restaurent,
BLOCK NO SF/1BHIMPURE COMPLEX 2ND FLORE OFFICE NO. 3 , 114 MODI IN FRONT OF BIG BAJAR SAAT RASTA  SOLAPUR 413001 SOLAPUR | BLOCK NO SF/1 BHIMPURE COMPLEX ASTA,2ND FLORE OFFICE NO. 3 , 114 MODI IN FRONT OF BIG BAJAR [NAME], Maharashtra, 413001, IN |  |  | BLOCK NO SF/1BHIMPURE COMPLEX 2ND FLORE OFFICE NO. 3 , 114 MODI IN FRONT OF BIG BAJAR SAAT RASTA  SOLAPUR 413001 SOLAPUR
Spreadsheet: 68488d1269015246-data-validation-checkout-holiday-tracker-2010-2011
Sheet: Book New Holiday

Back Home
Book new holiday
Step One |  |  |  | 2010-03-21 00:00:00 | 2010-03-21 00:00:00
Check that the week is still open by selecting it in the white box to the right. |  |  |  | 2010-03-28 00:00:00
 |  |  |  | 2010-04-04 00:00:00
 |  |  |  | 2010-04-11 00:00:00
Step Two |  |  |  | 2010-04-18 00:00:00 | This week is...
The computer will show you if the week is still open or has been closed. |  |  |  | 2010-04-25 00:00:00
 |  |  |  | 2010-05-02 00:00:00
 |  |  |  | 2010-05-09 00:00:00
 |  |  |  | 2010-05-16 00:00:00
 |  |  |  | 2010-05-23 00:00:00
 |  |  |  | 2010-05-30 00:00:00
 |  |  |  | 2010-06-06 00:00:00
 |  |  |  | 2010-06-13 00:00:00
 |  |  |  | 2010-06-20 00:00:00
 |  |  |  | 2010-06-27 00:00:00
 |  |  |  | 2010-07-04 00:00:00
 |  |  |  | 2010-07-11 00:00:00
 |  |  |  | 2010-07-18 00:00:00
 |  |  |  | 2010-07-25 00:00:00
 |  |  |  | 2010-08-01 00:00:00
 |  |  |  | 2010-08-08 00:00:00
 |  |  |  | 2010-08-15 00:00:00
 |  |  |  | 2010-08-22 00:00:00
 |  |  |  | 2010-08-29 00:00:00
 |  |  |  | 2010-09-05 00:00:00
 |  |  |  | 2010-09-12 00:00:00
 |  |  |  | 2010-09-19 00:00:00
 |  |  |  | 2010-09-26 00:00:00
 |  |  |  | 2010-10-03 00:00:00
 |  |  |  | 2010-10-10 00:00:00
 |  |  |  | 2010-10-17 00:00:00
 |  |  |  | 2010-10-24 00:00:00
 |  |  |  | 2010-10-31 00:00:00
 |  |  |  | 2010-11-07 00:00:00
 |  |  |  | 2010-11-14 00:00:00
 |  |  |  | 2010-11-21 00:00:00
 |  |  |  | 2010-11-28 00:00:00
 |  |  |  | 2010-12-05 00:00:00
 |  |  |  | 2010-12-12 00:00:00
 |  |  |  | 2010-12-19 00:00:00
 |  |  |  | 2010-12-26 00:00:00
 |  |  |  | 2011-01-02 00:00:00
 |  |  |  | 2011-01-09 00:00:00
 |  |  |  | 2011-01-16 00:00:00
 |  |  |  | 2011-01-23 00:00:00
 |  |  |  | 2011-01-30 00:00:00
 |  |  |  | 2011-02-06 00:00:00
 |  |  |  | 2011-02-13 00:00:00
 |  |  |  | 2011-02-20 00:00:00
 |  |  |  | 2011-02-27 00:00:00
 |  |  |  | 2011-03-06 00:00:00
 |  |  |  | 2011-03-13 00:00:00
Spreadsheet: 274048d1382993144-sumifs-with-column-concatenate-for-criteria-sumproduct-concatenation-for-carley
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Report Criteria
 | Tag_1 | Tag_2 | FY | FY_Month | Value | Column1 |  |  | FY | FY Month
 | A | X | 2012 | 10 | 100 |  |  |  | 2012 | 10
 | A | Y | 2012 | 11 | 110 |  |  |  | 2013 | 2
 | A | Z | 2012 | 12 | 200 |  |  |  |  |  | With Date Coercion |  |  |  | Without Date Coercion
 | B | X | 2013 | 1 | 250
 | A | Y | 2013 | 2 | 244
 | B | Z | 2013 | 3 | 75
 | C | Z | 2013 | 4 | 80
 | =SUMIFS(data[Value],data[Tag_1],"A",data[FY]&data[FY_Month],J4&K4)
 | =SUMIFS(data[Value],data[Tag_1],"A",data[FY]&data[FY_Month],">="&J4&K4,data[FY]&data[FY_Month],"<="&J5&K5)
Spreadsheet: 726838d1617532358-data-selection-in-a-row-can-variable-as-per-data-availability-book22
Sheet: Sheet1

 |  |  |  | a | b | c | d | e | f | g | h | i | j | k | l
 |  |  |  |  | a | k | b | j | c | i | d | h | e | g | f
 |  |  |  |  | a | k | b | j | c | i | d | h | e | g | f
Spreadsheet: 17472e09-8832-4dad-a720-6c7ef92c1d1e
Sheet: $$ Resources Per FTE

[NAME] vs. [NAME]
Total Library Resources Expenditures Per Enrolled Student FTE
 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | % Change
Peer Average
Peer Median
University of Rhode Island | 267.3 | 609.68 | 504.48 | 345.08 | 378.24041
[NAME] University | 318.4 | 369.63 | 314.94 | 348.11 | 361.37058
Montana State University - Bozeman | 408.35 | 495.22 | 695.16 | 469.84 | 441.27
North Dakota State University - Main Campus | 234.74 | U/A | 423.31 | U/A | U/A | U/A
University of Maine | 506.75 | 890.39 | 1034.7 | 1129.6 | 1290.29259
University of New Hampshire - Main Campus | 403.04 | 577.25 | 791.61 | 786.16 | 771.9237
University of Vermont and State Ag. Coll. | 532.49 | U/A | 1095.57 | 1050.51 | 1151.37419
University of Wyoming | 380.66 | 1033.24 | 1102.46 | 815.99 | 1248.15537
Source: ACRLMetrics
Revised: May 30, 2012, ajr
Spreadsheet: 67888d1268401811-min-function-with-multiple-criteria-testhenry
Sheet: Sheet1

Employee No | Start Time | Day | Event |  |  |  | Employee No | Day | Start Time | Event Code
233 | 07:00:34 | Monday | 765777 |  |  |  | 233 | Monday | 07:00:34 | 765777
233 | 10:51:58 | Monday | 555838
233 | 13:08:08 | Monday | 666534 |  |  |  | Your Input
233 | 16:10:46 | Monday | 200003
233 | 17:11:37 | Monday | 578342
233 | 17:15:10 | Monday | 489894
233 | 07:53:16 | Tuesday | 223983
233 | 08:08:46 | Tuesday | 983928
233 | 12:19:03 | Tuesday | 759969
112 | 07:31:51 | Monday | 136986
112 | 13:25:13 | Monday | 155403
112 | 16:47:45 | Monday | 180120
112 | 17:22:02 | Monday | 204837
112 | 06:46:05 | Tuesday | 229554
112 | 08:44:36 | Tuesday | 254271
112 | 12:45:14 | Tuesday | 278988
675 | 07:44:28 | Monday | 303105
675 | 10:30:05 | Monday | 328122
675 | 12:29:43 | Monday | 353139
675 | 16:44:05 | Monday | 377156
675 | 17:24:59 | Monday | 402173
675 | 07:29:36 | Tuesday | 427190
675 | 17:04:57 | Tuesday | 707765
So for example I would like to obtain the event code for the earliest time of employee 233 on the Monday