tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 717472d1612686937-return-a-value-in-a-range-with-multiple-criteria-date-range-and-name-criteria-lookup-example-ans
Sheet: Sheet1

Data Set - Schedule |  |  |  |  | Desired Report - Able to make a view by months within a year as below as well as an annual view over the years
Evening Coverage | Holiday Coverage | Employee |  |  |  | Jan/Feb | Mar/Apr | May/Jun | July/Aug
2021-01-01 00:00:00 | New Years | Smith |  |  | Abels
2021-01-08 00:00:00 |  | Jones |  |  | Jones
2021-01-18 00:00:00 | MLK | [NAME] |  |  | Smith
2021-01-29 00:00:00 |  | Abels |  |  | Wilson
2021-02-05 00:00:00 |  | Jones |  |  | [NAME]
2021-02-12 00:00:00 |  | [NAME]
2021-02-19 00:00:00 |  | Abels
2021-02-26 00:00:00 |  | Jones
2021-03-05 00:00:00 |  | Wilson
2021-03-12 00:00:00 |  | [NAME] |  |  |  | Jan/Feb | Mar/Apr | May/Jun | July/Aug
2021-03-19 00:00:00 |  | Abels |  |  | Abels |  |  |  | July 4th
2021-03-26 00:00:00 |  | Jones |  |  | Jones
2021-04-02 00:00:00 |  | Smith |  |  | Smith | New Years
2021-04-09 00:00:00 |  | Wilson |  |  | Wilson |  |  | Memorial Day
2021-04-16 00:00:00 |  | Abels |  |  | [NAME] | MLK
2021-04-23 00:00:00 |  | Jones
2021-04-30 00:00:00 |  | [NAME]
2021-05-07 00:00:00 |  | Wilson
2021-05-14 00:00:00 |  | Jones
2021-05-21 00:00:00 |  | Abels
2021-05-28 00:00:00 | Memorial Day | Wilson
2021-06-04 00:00:00 |  | [NAME]
2021-06-11 00:00:00 |  | Abels
2021-06-18 00:00:00 |  | Wilson
2021-06-25 00:00:00 |  | Jones
2021-07-02 00:00:00 | July 4th | Abels
2021-07-09 00:00:00 |  | [NAME]
2021-07-16 00:00:00 |  | Smith
2021-07-23 00:00:00 |  | Jones
2021-07-30 00:00:00 |  | Wilson
Spreadsheet: 76271d1276793375-formula-not-picking-up-date-as-date-but-number-sheet-for-excel-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | ITT |  | USD |  | 2010-05-03 00:00:00 | 0 | 0 | 0 | 0 |  |  | 2010-05-03 00:00:00 | 10:53:00 | 758 | Funds Transfer | SAME DAY CR TRANSFER |  | DISBURSEMENT FUNDING DUE | 650006000000 |  | 377 |  | DISBURSEMENT FUNDING DUE:40301 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30621414 | [NAME] | FINANCIAL RESOURCE CENTER | 2881 EASY BAYARD STREET | [NAME] 13148 |  | 39027606 | CITIBANK DEL CUST. TRANS. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-03 00:00:00 | 2010-05-03 00:00:00 |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  | No |  |  |  |  |  |  | 377 |  |  |  |  |  |  |  | 2010-05-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17531779.57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38740813 | [NAME] | FINANCIAL RESOURCE CENTER | 2881 EAST BAYARD STREET | [NAME] 13148 |  |  |  |  |  |  |  |  |  |  | 1 | 17531779.57 | 0 | 0 | 0 | 0 | 17531779.57
Spreadsheet: 134395d1325265532-formula-to-pull-cell-info-from-workbook-auto-filter301211
Sheet: 6451

[NAME] Record |  |  | RO NUMBER | 6433
 | TOTAL PARTS/SERVICE | 307.76 | VEHICLE MAKE: | Scion
 | TOTAL RECIVABLE | 0 | MODEL: | Xa | OWNER NAME:
 | DEDUCTABLE | 250 | YEAR: | 2005 | VIN NO:
 | CUSTOMER PAY | 0 | LICENSE NO: |  | INSURANCE:
 | BALANCE DUE | -250
 | [NAME] | CLOSED |  | IN | OUT | DATE
 |  | OPEN | MILEAGE |  |  | DROPPED OFF | PICKED UP
 |  | CLOSED |  |  |  | 2011-11-20 00:00:00 | 2011-12-28 00:00:00
DATE | INVOICE No. | SUPPLIER | PART DESCRIPTION | USED/NEW/SVC | CHECK NO. | AMOUNT PAID | CUST PAY | DEDUCT | PYMNT RCVD
2011-11-23 00:00:00 | 994966 | import auto glass | ati door glass | a/m new |  | 47.39
2011-11-23 00:00:00 | 103943-1 | cabe scion | fr door glass | new | 21661 | 68.26
2011-11-23 00:00:00 | 103943 | cabe scion | mirror assy, fr door glass | new | 21661 | 135.06
2011-11-23 00:00:00 | 21673 | cabe scion | outer mirror coverm weatherstrip blackout tape | new | 21673 | 57.05
2011-12-28 00:00:00 |  |  | deductable |  |  |  |  | 250
2011-12-28 00:00:00 |  |  | vehicle pu
 |  |  |  |  |  | 307.76 | 0 | 250 | 0
Spreadsheet: 739181d1625569115-div-0-i-dont-want-it-to-show-up-in-my-cells-test-1-
Sheet: Sheet1

Week Ending
2021-07-02 00:00:00 | Monday |  |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  |  |  | Thursday |  |  |  |  |  |  |  |  | Friday |  |  |  |  |  |  |  |  | Saturday |  |  |  |  |  |  |  |  | Weekly Totals & Efficiencies
 | Hours | Weld | Hours | Saw 1 | Hours | Angle | Hours | Saw |  | Hours | Weld | Hours | Saw 1 | Hours | Angle | Hours | Saw |  | Hours | Weld | Hours | Saw 1 | Hours | Angle | Hours | Saw |  | Hours | Weld | Hours | Saw 1 | Hours | Angle | Hours | Saw |  | Hours | Weld | Hours | Saw 1 | Hours | Angle | Hours | Saw |  | Hours | Weld | Hours | Saw 1 | Hours | Angle | Hours | Saw |  | Hours | Weld | Hours | Saw 1 | Hours | Angle | Hours | Saw | Total Tons & Pieces
1st & 3rd Total Tons
1st & 3rd Total Pieces
1st Shift
Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 6640 |  |  |  |  |  |  |  | 8 | 3320
Pieces |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  | 12
Person 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 6400
Pieces |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Person 3
Pieces
Person 4
Pieces
Person 5
Pieces
Person 6
Pieces
Person 7
Pieces
Extra Help
Pieces
1st Shift Total Tons
1st Shift Total Pieces
3rd Shift
Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3320
Pieces |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Person 2
Pieces
Person 3
Pieces
Person 4
Pieces
Person 5
Pieces
Person 6
Pieces
Person 7
Pieces
Extra Help
Pieces
3rd Shift Total Tons
3rd Shift Total Pieces
Efficiencies |  | Tons Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  |  | Tons Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  |  | Tons Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  |  | Tons Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  |  | Tons Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  |  | Tons Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  |  | Tons Per Hour |  | Pieces Per Hour |  | Pieces Per Hour |  | Pieces Per Hour
1st Shift
3rd Shift
Combinded
Spreadsheet: 689130d1596135587-formula-help-to-average-cells-based-on-set-number-of-entries-2020-07-14-oeldere4-marcellab-686590d1594703072-formula-to-average-and-count-excel-help-1-_r
Sheet: Oeldere3

 |  |  |  |  |  |  |  |  |  | criteria 6
Criteria => | 2020-12-01 00:00:00 |  | 12 | yes |  |  | 24 | 5
 |  |  |  |  |  |  |  |  |  | 12 month
Project | Booking Date | SM | 12 month | 24 month | 5 criteria | 6 criteria | combined |  |  | 24 month
Project H | 2017-05-26 00:00:00 |  |  |  |  |  | ;
Project H | 2018-02-21 00:00:00
Project H | 2018-02-21 00:00:00
Project H | 2018-12-31 00:00:00
Project H | 2019-01-16 00:00:00
Project H | 2019-01-16 00:00:00
Project H | 2019-01-16 00:00:00
Project A | 2019-06-01 00:00:00 | 0.9
Project B | 2019-07-01 00:00:00 | 0.4
Project C | 2019-08-01 00:00:00 | 0.541
Project D | 2019-08-01 00:00:00 | 0.579
Project E | 2019-11-01 00:00:00 | 0.695
Project F | 2019-11-01 00:00:00 | 0.723
Project C | 2019-11-01 00:00:00 | 5
Project D | 2019-12-01 00:00:00 | 6
Project E | 2019-12-01 00:00:00 | 7
Project G | 2019-12-01 00:00:00 | 8
Project H | 2020-06-01 00:00:00 | 9
Project I
Project J
Spreadsheet: 100476d1298847191-rows-to-columns-customer-database-test
Sheet: PRINT

CUSTOMER ID | 10001
COMPANY NAME | C Name
SITE ADDRESS | Add1
SITE ADDRESS | Add2
SITE TOWN | Add Town
SITE POSTCODE | Add PC
MONTH | Mth
FIRST SERVICE | ??
LAST SERVICE | ??
CONTACT NAME | ??
PHONE NUMBER | ??
MOBILE NUMBER | ??
E-MAIL | ??
INVOICE ADDRESS | Add1
INVOICE ADDRESS | Add2
INVOICE TOWN | Add Town
INVOICE POSTCODE | Add PC
INVOICE PHONE NUMBER | ??
CONTRACT TYPE | ??
NOTES | ??
UNITS ON SITE
WATER | 0
FOAM | 0
CO2 | 0
POWDER | 0
WET CHEM | 0
[NAME] | 0
HOSE REELS | 0
TOTAL | 0
SERVICE AGREEMENT (Y/N) | 0
SERVICE AGREEMENT DETAILS | 0
SITE INSPECTION £ | 0
SERVICE PRICE £ | 0
9L W £ | 0
6L F £ | 0
9L F £ | 0
2 CO2 £ | 0
5 CO2 £ | 0
2 PD £ | 0
6 PD £ | 0
9 PD £ | 0
BLANKET £ | 0
FIT £ | 0
FOAM REFILL £ | 0
INVOICE No 2011 | 10001
CERT No 2011 | 1001
Spreadsheet: 699777d1602760068-looking-for-one-value-in-two-columns-problem2
Sheet: Desired

Criteria |  | List 1 | List 2 |  | RESULT
A |  | X | V |  | NO
B |  | Z | C |  | YES
C |  | U | D |  | YES
D |  | A | F |  | YES
E |  | B | D |  | YES
F |  | Y | B |  | YES
Spreadsheet: sally_beck__34326__Cashflow Forecast 12-18r
Sheet: Lic-Maint Breakout

License & Maintenance Renewal Per GSS
($ Millions)
 |  |  | 2002
Perlman | Dec '01 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov
Oracle | 1.5
Solarc |  |  | 0.3
Quest |  |  | 0.5
Netegrity |  |  |  |  |  |  |  |  |  |  | 0.1
Interwoven |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
Rub
Network Ice | 0.1
Net IQ | 0.2
Legato |  |  | 1
Microsoft |  |  |  |  | 0.8
IPC |  |  |  |  | 0.3
Sun Microsystems |  |  |  |  |  |  | 0.8
Citrix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
Dayao
Gensym
Total
Spreadsheet: 135119d1325834877-excel-2007-excel-7-attendance-template-attendance
Sheet: Jan -12

Jan -2012 -Staff Attendance ( MGPS -Rewari)
S/No | Name | Deptt/Designation |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Leave % | Ratio% | Total L/Bal
 |  |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
 |  |  | 9am to 5:30pm | 9am to 5:30pm | 9am to 5:30pm
1 | A | F&B |  | P | P
2 | B | ORW | P | P | P
3 | C | Counsellor | P | P | P
4 | D | ORW | P | P | P
5 | E | TBC | P | P | P
6 | F | ORW | P | P | P
7 | H | Mngr -Admin & Fin | P | P | P
8 | I | M & E Officer | P | P | P
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Butyl Di Glycol

Raw Material |  | Butyl Di Glycol
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 36
Total
Spreadsheet: 31b95aeb-f282-48a0-b277-144b1f812ef5
Sheet: Sheet1

Release: Debt to Gross Domestic Product Ratios | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=263
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-24 8:55 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Debt to Gross Domestic Product Ratios | 2012-10-26 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2012-10-26 00:00:00 | Current
The White House: Office of Management and Budget | 2013-03-20 00:00:00 | Current
Notes:
These series are constructed using debt, deficit, and nominal GDP | 2012-10-26 00:00:00 | Current
series.
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:
2012-10-26 00:00:00
2012-11-29 00:00:00
2012-12-06 00:00:00
2012-12-20 00:00:00
2013-01-30 00:00:00
2013-02-28 00:00:00
2013-03-11 00:00:00
2013-03-20 00:00:00
2013-03-28 00:00:00
2013-04-10 00:00:00
2013-04-26 00:00:00
2013-05-30 00:00:00
2013-06-06 00:00:00
2013-06-26 00:00:00
2013-07-31 00:00:00
2013-08-29 00:00:00
2013-09-26 00:00:00
2013-09-27 00:00:00
2013-11-07 00:00:00
2013-12-05 00:00:00
2013-12-20 00:00:00
2014-01-30 00:00:00
2014-02-28 00:00:00
2014-03-14 00:00:00
2014-03-25 00:00:00
2014-03-27 00:00:00
2014-04-30 00:00:00
2014-05-29 00:00:00
2014-06-25 00:00:00
2014-07-30 00:00:00
2014-08-28 00:00:00
2014-09-26 00:00:00
Spreadsheet: 726377d1617201309-automatically-shift-data-in-cells-according-to-date-change-sliding-dates-referencing-input-table-manishman-
Sheet: Sheet1

Date | Agent 1 | Agent 2
2021-03-07 00:00:00 |  | 3
2021-03-08 00:00:00 |  | 6
2021-03-09 00:00:00 |  | 6
2021-03-10 00:00:00
2021-03-11 00:00:00 |  | 3
2021-03-12 00:00:00
2021-03-13 00:00:00
2021-03-14 00:00:00 |  | 3.5
2021-03-15 00:00:00 |  | 6
2021-03-16 00:00:00
2021-03-17 00:00:00
2021-03-18 00:00:00
2021-03-19 00:00:00 |  | 3
2021-03-20 00:00:00 | 2
2021-03-21 00:00:00
2021-03-22 00:00:00
2021-03-23 00:00:00 | 3
2021-03-24 00:00:00
2021-03-25 00:00:00
2021-03-26 00:00:00 | 3
2021-03-27 00:00:00 |  | 2
2021-03-28 00:00:00
2021-03-29 00:00:00 | 3
2021-03-30 00:00:00 |  | 2
2021-03-31 00:00:00
2021-04-01 00:00:00 | 3
2021-04-02 00:00:00 |  | 2
2021-04-03 00:00:00
2021-04-04 00:00:00 | 3
2021-04-05 00:00:00 |  | 2
2021-04-06 00:00:00 | 1 | 1
2021-04-06 00:00:00 | 2 | 1
2021-04-07 00:00:00 |  | 2
Spreadsheet: 71add27a-2cc1-4a60-83fc-0cd98f6e8c68
Sheet: enter data

FAS - Accumulated Grain Export Sales
[NAME]
Crop Year-Wheat=6/01-5/31;  Corn & Soybeans=9/01-8/31;
 | HRW |  | SRW |  | HRS |  | SWW |  | DUR |  | All |  | Corn |  | Soybean
 | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum
2013-04-04 00:00:00 | 1810 | 7891 | 1021 | 4112 | 1026 | 4825 | 572 | 3971 | 68 | 390 | 4497 | 21189 | 4211 | 11494 | 2796 | 33502
2014-04-03 00:00:00 | 1594 | 9868 | 764 | 6696 | 1367 | 5141 | 908 | 3442 | 130 | 385 | 4762 | 25532 | 17951 | 24015 | 3395 | 41195
enter the data on this sheet, then copy these two lines to the end to the copy data sheet
Spreadsheet: stacey_white__38769__0709  Alcoa Model
Sheet: Summary

Alcoa -Energy Certificate Purchase
 |  |  |  |  |  |  |  | Contract | Mid |  | MTM
 |  |  |  |  | Mwh | Mwh |  | Price | Price |  | Purchase | Gross Margin | Taxes (3) | Total |  | Total ($USD) |  |  |  | Total ($USD)
Delivery Period |  |  |  |  | (Notional) (1a) | (PV) |  |  | (Average) |  | (PV'd) | (PV'd) | (PV'd) | (PV'd)
 | Total Deal Value
 | Total Liquidations |  |  |  | 0 |  |  |  |  |  | 0
Forward Start: |  | From | To
 |  |  |  | Check
2000 |  | Jul | Dec | -1
 |  | May | Nov
 |  | May | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIOR DAY | 6179571 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rho/Drift | 6184730 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Deal | 3756733 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IGPM | 3756733 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Int Rate | 3756733 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FX Rate | 3756733 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 823262d1679859861-how-to-track-inventory-when-clearing-worksheet-excel-tracker
Sheet: Inventory List

 |  |  |  | Highlight items to reorder? |  |  | Yes
Flagged items to reorder | Inventory ID | Name | Description | Unit Price | Quantity in Stock | Live Count | Inventory Value | Reorder Level | Reorder Time in Days | Quantity in Reorder | Discontinued?
 | IN0001 | Tri-Built Self adhering Ice & Water (2 sq) | Tri-Built Self adhering Ice & Water (2 sq) | 66.77 | 200 |  |  | 100 | 7 | 75
 | IN0002 | Tri-Built Galvanized steel roll valley - (20''x50') | 12 pack cases of blackjack roofing sealant | 93.2 | 30 |  |  | 20 | 4 | 25
 | IN0003 | Tri-Built Lo-Omni roll ridge vent - Nailable (30') | Tubs of roofing nails 1 1/4'' | 81.78 | 24 |  |  | 100 | 11 | 25
 | IN0004 | Tri-Built Starter | Tubs of roofing nails 1 5/8'' | 39.93 | 36 |  |  | 35 | 6 | 25
 | IN0005 | Tri-Built Synthetic roofing underlayment (10 sq) | Rolls of window flashing tape | 65.89 | 114 |  |  | 75 | 12 | 75
 | IN0006 | Tri-Built Coil nails - 1 1/4'' (7200) | 12 pack cases of cans of spray foam | 50 | 50 |  |  | 20 | 8 | 25
Spreadsheet: 692183d1598155330-extracting-data-from-a-column-into-another-but-sorted-and-with-2-related-cells-next-to-it-book4-reply
Sheet: Sheet1

MY Index | Serial Number | Supplier | Sales | Revenue
23 | B52XN2 | AccuBuddy | 21 | 17274.05
11 | B07379JP | The Inspired Home | 170 | 3568.3
14 | 6HQF8PJ | Arswintech | 222 | 2323.45
13 | B07LKK8 | SKCTech | 429 | 7288.71
1 | fgdgfd | gr | 11 | 543543
54 | grt | btrbrt | 55 | 65454
Spreadsheet: 216570d1361813780-still-sumif-question-book2-hb-start-over-14-daily-reconciliation-6
Sheet: Campsite Sales Cash Out

Page 1 |  |  |  |  |  |  |  |  | CASH OUT # |  | 456789
 |  |  | CAMPSITE SALES CASH OUT
Prepared By: |  | [NAME] |  |  |  |  | DEPT: |  | 802 |  |  |  |  | Work Sheet Page 1
Opening Date: |  | 2013-02-15 00:00:00 |  |  |  |  | Closing Date: |  | 2013-02-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number
 | Permit #/ |  | NRRS | GA |  |  |  |  |  |  |  |  |  |  | Permit #/ |  | Site |  |  | Camping | Utility | Number |  | Actual $ | CK |  |  |  | Extra |  | Actual | CK |  |  |  | Total | Total | Total
 | Envelopes |  |  |  | Cash | Check | Credit | Cash | Check | Credit | TOTALS |  |  |  | Envelopes | Date | Number | NRRS | GA | Fee/Day | Fee/Day | Of Days | $$$$$$$$ | Paid | C | Ccash | Ccheck | Ccredit | Vehicles | $$$$$$$$ | Paid | C | EVCash | EVCheck | EVCredit | Cash | Check | Credit | TOTALS
1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CK
2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CK
3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 2013-02-17 00:00:00 | 74 |  |  | 19 |  | 11 |  |  | CK |  |  |  | 0 |  |  | CK
7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 2013-02-20 00:00:00 | 4 |  |  | 19 |  | 2 |  |  | C |  |  |  | 1 |  |  | CK
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 2013-02-21 00:00:00 | 1 |  |  | 9.5 |  | 1 |  |  | C |  |  |  | 1 |  |  | CK
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 2013-02-22 00:00:00 | 36 |  |  | 21 |  | 2 |  |  | C |  |  |  | 2 |  |  | CK
10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 2013-02-23 00:00:00 | 1 |  |  | 38 |  | 2 |  |  | CK |  |  |  | 1 |  |  | C
Totals This Page
 | Page2
 | Page 3
 | Page 4
 | Page 5
GRAND TOTALS
Net Cash Camping
Net Extra Vehicle
Sales Tax
Transient Tax
 |  |  |  |  |  |  |  | TOTAL ACCOUNTABILITY
Beginning Permit #: |  |  |  |  |  |  |  | Beginning Envelope #:
Ending Permit #: |  |  |  |  |  |  |  | Ending Envelope #:
Employee Signature: |  |  |  |  |  |  |  | Date: |  |  | 2013-02-15 00:00:00
Spreadsheet: 87538d1287424065-conditional-formatting-question-example
Sheet: Sheet1

Item | Qty Remaining | [NAME] | PO# | Accepted | Expected On Dock Date | Material Arrived | Qty Received | Vendor | Notes
42538 Disposable Specimen Container |  | 1cs of 50 | 21016317 | 2010-10-06 00:00:00 | 2010-10-20 00:00:00 | 2010-10-12 00:00:00 | 1 | Consolidated Plastics
[NAME] |  | 440 | 21015927 | 2010-10-06 00:00:00 | 2010-10-19 00:00:00
 |  |  |  |  |  |  | I want F2 to change to the same color as
 |  |  |  |  |  |  | G2 but keep the date the same
Spreadsheet: 680191d1590851140-have-data-automatically-build-new-list-based-on-criteria-from-a-specific-column-budget-example
Sheet: February

2021
2021-02-01 00:00:00
 |  |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Input | Description | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 775
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0168

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-09-P-0168 |  |  | 1P
W912LP-09-P-0168 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 477670d1472460962-please-help-conditional-formatting-and-counting-based-on-cell-color-excel-exercise
Sheet: Condition

DATA
Color explanation |  | Sold |  |  | Deposit |  |  | Agency |  |  | Empty |  |  | Not Available
Apartment number | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 |  | Statistics
1st floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Sold
2nd floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Deposit
3rd floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Agency
4th floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
5th floor | 5.01 | 5.02 | 5.03 | 5.04 | 5.05 | 5.06 | 5.07 | 5.08 | 5.09 | 5.1 | 5.11 | 5.12 |  | Total
6th floor | 6.01 | 6.02 | 6.03 | 6.04 | 6.05 | 6.06 | 6.07 | 6.08 | 6.09 | 6.1 | 6.11 | 6.12
Spreadsheet: 779859d1652152050-multiple-xlookup-index-match-functions-to-return-one-value-excelforum-sample
Sheet: Sheet4

Time I ate | Food I ate | Where | Price of the food | How good is it? | How good was it last time?
07:00:00 | Granola Bar | Supermarket | 2.5 | 6
12:00:00 | Fried Noodles | [NAME] | 9 | 8
19:45:00 | [NAME] | Morganfield | 25 | 6