tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg16

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Drip Zone 3 (S) |  | Field Name: |  | Drip Zone 4 (S) |  | Field Name: |  | Drip Zone 5 (S) |  | Field Name: |  | Drip Zone 6 (S)
 |  |  |  |  |  | Area (acres): |  | 33.79 |  | Area (acres): |  | 5.88 |  | Area (acres): |  | 0.84 |  | Area (acres): |  | 10.19
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 73.9 |  | Annual Rate (in): |  | 65.4 |  | Annual Rate (in): |  | 78.2 |  | Annual Rate (in): |  | 65.8
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 716405d1612197081-sum-values-with-criteria-sample
Sheet: PAYDAY 29th Sep

Week: | Hours: | Pay: | Notes: |  |  | Break Down: |  |  |  |  |  |  | WEEKLY PAY: | DAILY PAY: | HOURLY:
BASIC: |  | 2000
ADDITION: |  |  |  |  |  | Natwest:
OTHER BONUS: |  |  |  |  |  | Entertainment:
 |  |  |  |  |  | Car:
[NAME]: |  | 0 |  |  |  | Loan:
 |  |  |  |  |  | Phone:
Est Tax: |  |  |  |  |  | Credit Improver:
Est NI: |  |  |  |  |  | Rent:
Total: |  |  |  |  |  | Credit Card:
 |  |  |  |  |  | Total:
Total Est Pay Before Tax:
Total Est Pay After Tax: |  |  |  |  |  | Monzo:
Actual Pay: |  |  |  |  |  | Predicted: |  |  | Actual:
 |  |  |  |  |  | Amount L/O |  |  | Amount L/O
Deductions: |  |  |  |  |  | Days till next pay | 28 |  | Days till next pay | 28
Rent |  | 120 |  |  |  | Budget |  |  | Budget
Fuel |  | 120
Car Insurance
Phone |  | 15
Loan |  | 130.08
ISA
Credit Improver |  | 12
Credit Card
PetPlan |  | 9.99
Holly - ONE OFF |  | 156.41
Other
 |  |  |  |  |  | NI Calculator:
Budget:
 |  |  |  |  |  | PA: | 793.03
Total: |  |  |  |  |  | BT - PA:
Total Est Left On 29th Sep: |  |  |  |  |  | Total:
Total Acc Left On 29th Sep:
 |  |  |  |  |  | Tax Calculator:
 |  |  |  |  |  | PA: | 954.18
 |  |  |  |  |  | BT - PA:
 |  |  |  |  |  | Est Tax:
Spreadsheet: 50649d1250120329-returning-last-value-loop-book35
Sheet: Sheet1

music | 0
!!! | 0
2007 - myth takes | 10 |  | return value here--> | 10 | 1
2009-08-07 15:06:00 | 1 | [NAME] | mp3
2009-08-07 15:06:00 | 2 | all my heroes are weirdos.mp3 | mp3
2009-08-07 15:07:00 | 3 | must be the moon.mp3 | mp3
2009-08-07 15:07:00 | 4 | a new name.mp3 | mp3
2009-08-07 15:07:00 | 5 | heart of hearts.mp3 | mp3
2009-08-07 15:07:00 | 6 | sweet life.mp3 | mp3
2009-08-07 15:07:00 | 7 | yadnus.mp3 | mp3
2009-08-07 15:07:00 | 8 | bend over beethoven.mp3 | mp3
2009-08-07 15:07:00 | 9 | break in case of anything.mp3 | mp3
2009-08-07 15:07:00 | 10 | infinifold.mp3 | mp3
1973 - 10cc | 10 |  | return value here--> | 10 | 1
2009-03-25 16:46:00 | 1 | [NAME] dont do it.mp3 | mp3
2009-03-25 16:46:00 | 2 | sand in my face.mp3 | mp3
2009-03-25 16:46:00 | 3 | donna.mp3 | mp3
2009-03-25 16:46:00 | 4 | the dean and i.mp3 | mp3
2009-03-25 16:46:00 | 5 | headline hustler.mp3 | mp3
2009-03-25 16:46:00 | 6 | speed kills.mp3 | mp3
2009-03-25 16:46:00 | 7 | rubber bullets.mp3 | mp3
2009-03-25 16:46:00 | 8 | the hospital song.mp3 | mp3
2009-03-25 16:46:00 | 9 | ships dont disappear.mp3 | mp3
2009-03-25 16:46:00 | 10 | fresh air for my mama.mp3 | mp3
1974 - sheet music | 10 |  | return value here--> | 8 | 0
2009-03-25 16:46:00 | 1 | the wall street shuffle.mp3 | mp3
2009-03-25 16:46:00 | 2 | the worst band in the world.mp3 | mp3
2009-03-25 16:46:00 | 3 | hotel.mp3 | mp3
2009-03-25 16:46:00 | 4 | old wild men.mp3 | mp3
2009-03-25 16:46:00 | 5 | clockwork creep.mp3 | mp3
2009-03-25 16:46:00 | 6 | silly love.mp3 | mp3
2009-03-25 16:46:00 | 7 | somewhere in hollywood.mp3 | mp3
2009-03-25 16:46:00 | 8 | baron [NAME] | mp3
1975 - the original soundtrack | 10 |  | return value here--> | 11 | 0
2009-03-25 16:46:00 | 1 | une nuit a paris (part i)the same night in paris(part 2)later the same night in paris(part 3).mp3 | mp3
2009-03-25 16:46:00 | 2 | i'm not in love.mp3 | mp3
2009-03-25 16:46:00 | 3 | blackmail.mp3 | mp3
2009-03-25 16:46:00 | 4 | the second sitting for the last supper.mp3 | mp3
2009-03-25 16:46:00 | 5 | brand new day.mp3 | mp3
2009-03-25 16:46:00 | 6 | flying junk.mp3 | mp3
2009-03-25 16:46:00 | 7 | life is a minestrone.mp3 | mp3
2009-03-25 16:46:00 | 8 | the film of my love.mp3 | mp3
2009-03-25 16:46:00 | 9 | channel swimmer.mp3 | mp3
2009-03-25 16:46:00 | 10 | good news.mp3 | mp3
2009-03-25 16:46:00 | 11 | good news.mp3 | mp3
Spreadsheet: 37331d1235313788-change-cell-colour-when-value-changes-book2
Sheet: Sheet1

Model A | Model B | Model C | Model D | Part Name | Part Number | Stock Level | Re-order Level
Ineo+200 |  |  |  | Black Toner TN214K |  | 2 | 1
Ineo+200 |  |  |  | [NAME] TN214Y |  | 2 | 1
Ineo+200 |  |  |  | Magenta Toner TN214M |  | 2 | 1
Ineo+200 |  |  |  | [NAME] TN214C |  | 2 | 1
Ineo+203 | Ineo+253 |  |  | Black Toner TN213K | A0D71D2 | 4 | 2
Ineo+203 | Ineo+253 |  |  | [NAME] TN213Y | A0D72D2 | 4 | 2
Ineo+203 | Ineo+253 |  |  | Magenta Toner TN213M | A0D73D2 | 4 | 2
Ineo+203 | Ineo+253 |  |  | [NAME] TN213C | A0D73D2 | 3 | 2
Ineo+203 | Ineo+253 |  |  | Black Imaging Unit [NAME] | A0DE12H | 1 | 1
Ineo+203 | Ineo+253 |  |  | Yellow Imaging Unit IU211Y | [NAME] | 1 | 1
Ineo+203 | Ineo+253 |  |  | Magenta Imaging Unit [NAME] | A0DE1CH | 1 | 1
Ineo+203 | Ineo+253 |  |  | Cyan Imaging Unit IU211C | A0DE1HH | 1 | 2
Ineo+250 | Ineo+251 |  |  | Black Toner TN210K | 8938517 | 7 | 2
Ineo+250 | Ineo+251 |  |  | [NAME] TN210Y | 8938518 | 4 | 2
Ineo+250 | Ineo+251 |  |  | Magenta Toner TN210M | 8938519 | 3 | 2
Ineo+250 | Ineo+251 |  |  | [NAME] TN210C | 8938520 | 3 | 2
Ineo+250 | Ineo+251 |  |  | Black Imaging Unit [NAME] | 4062-205 | 2 | 1
Ineo+250 | Ineo+251 |  |  | Yellow Imaging Unit IU210Y | 4062-305 | 0 | 1
Ineo+250 | Ineo+251 |  |  | Magenta Imaging Unit IU210M | 4062-405 | 1 | 1
Ineo+250 | Ineo+251 |  |  | Cyan Imaging Unit IU210C | 4062-505 | 1 | 1
Ineo+250 | Ineo+251 | Ineo+351 |  | Waste Toner Bottle | 4065-611 | 3 | 1
Ineo+250 | Ineo+251 |  |  | [NAME] | 4038R74300 | 1 | 0
Ineo+250 | Ineo+251 |  |  | Fusing Unit | 4038R78211 | 0 | 0
Ineo+350 | Ineo+450 | Ineo+450P | [NAME] | Black Toner TN310K | 4053-405 | 2 | 2
Ineo+350 | Ineo+450 | Ineo+450P | [NAME] | [NAME] TN310Y | 4053-505 | 3 | 2
Ineo+350 | Ineo+450 | Ineo+450P | [NAME] | Magenta Toner TN310M | 4053-605 | 5 | 2
Ineo+350 | Ineo+450 | Ineo+450P | [NAME] | [NAME] TN310C | 4053-705 | 3 | 2
[NAME] |  |  |  | Ozone Filter | 1483075700 | 2 | 0
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: IT Infra

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  |  | 2002 |  |  | Per HC | New HC | Adj Comp |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  |  | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  | 2000000 |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 |  | [NAME] | 49200 | 0
ENARENT | Rent |  |  |  |  |  | 1936000 |  | [NAME] | 57600 | 1
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 2
ENATRANS | Transportation |  |  |  |  |  | 0 |  | Specialist | 78000 | 9
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 25
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Analyst | 0 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | IT Consultants | 192000 | 0
 |  |  |  |  |  |  |  |  | Manager | 144000 | 15
 | Headcount |  |  | 111 | 40 |  |  |  | Director | 168000 | 2
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 4
 | A&A Headcount |  |  |  |  |  | 1 |  | VP | 222000 | 1
 |  |  |  |  |  |  |  |  | MD | 300000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  | 0 |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  |  | Consultants | 192000 | 8
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure |  |  | 0
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 0 |  |  |  | Based on information from ENW accounting.
 | Infrastructure costs include amounts for desktop support, e-mail administration, security,
 | communications (long distance, trading turrets, phones, cables), licenses (Microsoft, etc),
 | market data feeds, T1 lines, internet access, WAN, LAN, etc.
Spreadsheet: 109447d1306302552-dynamic-range-and-series-in-xy-scatter-pillar-design-start
Sheet: Calc

Pillar Geometry
Starting H (m) | Maximum H (m) | Incremental H (m) | h (m) | Starting CC/T (m) | Maximum CC/T (m) | Incremental CC/T (m) | b (m) | Angle C/T to heading (degrees) | Chead (m) | Weff | Effective w/h Ratio
160 | 240 | 10 | 3.4 | 40 | 100 | 10 | 5 | 90 | 40
 |  | Longwall Geometry |  |  |  | Design Proability of Failure
Loading Condition |  | W1 (m) | [NAME] (m) | Goaf Cave Angle (B) |  | Probability | FoS
Wide Panel |  | 125 |  | 70 |  | 1 in 10,000,000
Spreadsheet: 3d2a79d7-3edb-4705-902b-d9f32681890f
Sheet: Sheet1

Release: Annual Estimates of the Population for the U.S. and States, and for Puerto Rico | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=118
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-22 5:28 PM CDT
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population for the U.S. and States, and for | 2004-12-22 00:00:00 | Current
Puerto Rico
Link:
http://www.census.gov/popest/ | 2004-12-22 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2004-12-22 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:
2004-12-22 00:00:00
2005-12-22 00:00:00
2006-12-22 00:00:00
2007-12-27 00:00:00
2008-12-19 00:00:00
2009-12-22 00:00:00
2011-02-02 00:00:00
2011-12-21 00:00:00
2012-12-20 00:00:00
2014-02-26 00:00:00
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: JT Outpatient 2003500

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Hydrolyte Honey Water | 0.32
Hydrolyte Honey tea | 0.37
Hydrolyte Nectar Water | 0.32
Hydrolyte Nectar Tea | 0.35
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
SF Crackers | 0.05
[NAME] | 0.28
[NAME] | 1.13
Pudding-Vanilla | 0.27
Diet Vanilla Pudding | 0.28
Applesauce Ind. | 0.32
Juice Orange | 0.23
Juice Cranberry | 0.23
Juice Apple | 0.23
Honey | 0.07
Jam/Jelly ea | 0.06
[NAME] | 0.02
Mayo | 0.06
Mustard | 0.02
[NAME] | 0.16
Salt/Pepper | 0.02
[NAME] | 0.11
[NAME] | 0.11
Milk- Skim | 0.25
2% Milk | 0.25
Coffee Decaf instant- Prepack cs. | 37.84
Coffee, [NAME]. cs. | 95.11
Tea Bags | 0.03
Small cups | 0.03
[NAME] | 1.47
Creamer, non dairy box | 0.03
Sugar | 0.02
Sweetner-Equal | 26.73
Sweetner-Sweet N Low | 17.58
Sweetner-Splenda | 30.44
Plastic Ware (fork,spoon knife) | 0.03
Glucerna | 0.4
Jevity | 0.35
Nepro | 1.03
[NAME] | 15.6
Osmolite | 0.25
Perative | 1.39
Promote | 0.23
Pulmocare | 0.44
Refrigerator Thermometer (reg.)
Broth, [NAME] pkt. | 0.1
[NAME]-pkts. | 2.4
[NAME] | 1.75
Cereal-Cheerios | 0.39
Ice Cream-Vanilla | 0.41
Ice Cream- Diet-Vanilla | 0.43
Diet Popsicles | 0.25
Popcicles | 0.2
Monthly Total
Spreadsheet: 97979d1297094320-count-if-on-multiple-cells-forum-test
Sheet: Case Product Detail Report

Case No | Case Product No | Priority | Case Product Status | Case Product Type | Warranty Coverage | Category | General Defect Code | Actual Defect Code | Error Code | Engineer Required | Creation Date |  | CSR Total Hours | Warehouse Activity Datetime | Order Ready Datetime | Despatch Datetime |  | Warehouse Total Hours | Allocated Datetime |  | Engineer Actual  Start Datetime | Completed Date | Engineer Response Hours | Installation Date | Month
HJHT45269 | HJHT45269 |  | Case Solved | Parts Orders | Warranty | OTHER | FAQ's |  |  |  | 01 Jun 2010 00:00:00 |  |  |  |  | 24 Nov 2010 08:30:41 |  |  |  |  |  |  |  |  | 6
[NAME] | [NAME] |  | Case Solved | Parts Orders | Warranty | OTHER | FAQ's |  |  |  | 27 Jul 2010 00:00:00 |  |  |  |  | 24 Nov 2010 08:32:33 |  |  |  |  |  |  |  |  | 7
HJHT47393 | HJHT47393 | 300 | Case Solved | Parts Orders | Warranty | OTHER | FAQ's |  |  |  | 05 Aug 2010 00:00:00 |  |  |  |  | 24 Nov 2010 08:32:39 |  |  |  |  |  |  |  |  | 8
HJHT50070 | HJHT50070 | 300 | Case Solved | Parts Orders | Chargeable | OTHER | FAQ's |  |  | False | 25 Oct 2010 00:00:00 |  | 1428.266666 | 14 Jan 2011 12:16:49 | 19 Jan 2011 09:35:16 | 20 Jan 2011 06:09:49 |  | 69.316666 |  |  |  |  |  |  | 10
CAS110200584 | [NAME] | 300 | Picking List | Parts Orders | Van Stock Transfer | OTHER | Parts Order |  |  | False | 04 Feb 2011 09:33:48 |  | 0.483333 | 04 Feb 2011 10:02:55 |  |  |  |  |  |  |  |  |  | 01 Jan 2000 00:00:00 | 2
CAS110200394 | JUK110200429 | 200 | Despatch | Parts Orders | Van Stock Transfer | OTHER | Parts Order |  |  | False | 04 Feb 2011 09:02:05 |  | 0.083333 | 04 Feb 2011 09:07:40 | 04 Feb 2011 14:24:08 | 04 Feb 2011 17:01:36 |  | 5.283333 |  |  |  |  |  | 20 Apr 2010 00:00:00 | 2
HJHT46802 | HJHT46802 |  | Case Solved | Parts Orders | Chargeable | OTHER | FAQ's |  |  |  | 19 Jul 2010 00:00:00 |  |  |  |  | 24 Nov 2010 08:32:30 |  |  |  |  |  |  |  |  | 7
HJHT46953 | HJHT46953 |  | Case Solved | Parts Orders | Chargeable | OTHER | FAQ's |  |  |  | 22 Jul 2010 00:00:00 |  |  |  |  | 24 Nov 2010 08:30:34 |  |  |  |  |  |  |  |  | 7
HJHT47377 | HJHT47377 | 300 | Case Solved | Parts Orders | Chargeable | OTHER | FAQ's |  |  |  | 05 Aug 2010 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 107030d1304183498-generation-of-data-in-sheet-2-test-mahju
Sheet: Sheet1

 | Task No. | Name |  |  |  |  |  |  |  |  | A
A-1 | 1213 | A |  |  |  |  |  |  |  |  | B
B-1 | 1214 | B |  |  |  |  |  |  |  |  | C
A-2 | 1215 | A |  |  |  |  |  |  |  |  | D
D-1 | 1216 | D |  |  |  |  |  |  |  |  | E
D-2 | 1217 | D |  |  |  |  |  |  |  |  | F
C-1 | 1218 | C
E-1 | 1219 | E
E-2 | 1220 | E
E-3 | 1221 | E
A-3 | 1225 | A
B-2 | 1226 | B
C-2 | 1227 | C
F-1 | 1230 | F
A-4 | 1235 | A
B-3 | 1201 | B
C-3 | 1240 | C
F-2 | 1250 | F
F-3 | 1255 | F
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: RAH - CS-SPD GOR CART

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD GOR CART
FACILITY: | ROYAL ALEXANDRA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X |  |  | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
20-WRAPPER 18" |  |  |  | BP0002 |  | 1
20-WRAPPER 24" |  |  |  | BP0003 |  | 36
20-WRAPPER 30" |  |  |  | BP0004 |  | 4
20-WRAPPER 36" |  |  |  | BP0005 |  | 12
20-HUCK TOWELS |  |  |  | BP0009 |  | 11
3-HALF SHEETS |  |  |  | BP0032 |  | 2
5-SM FEN DRAPES |  |  |  | BP0012 |  | 1
20-SURGICAL TWL |  |  |  | BP0027 |  | 3
UPDATED:
June 17th 2009
Spreadsheet: 872838d1719287315-put-together-uneven-data-from-various-sheet-tabs-book9
Sheet: JAN

 | Year & Month | Total Number of Available Rooms* | Total Number of Sold Rooms** | Total Room Revenue | Currency | Total Revenue
 | 2022-01-01 00:00:00 | 128 | 114 | 348707.4299999999 | Usd | 404716.8499999999
 | 2022-01-02 00:00:00 | 128 | 95 | 250258 | Usd | 295457.9399999999
 | 2022-01-03 00:00:00 | 128 | 96 | 196276.85 | Usd | 233482.73
 | 2022-01-04 00:00:00 | 128 | 75 | 149181.37 | Usd | 176194.89
 | 2022-01-05 00:00:00 | 128 | 78 | 150174.29 | Usd | 184033.99
 | 2022-01-06 00:00:00 | 128 | 105 | 192605 | Usd | 227660.56
Spreadsheet: 754047d1635901215-formatting-data-of-an-auto-populating-calendar-workbook-ef1554_calendar_date_range
Sheet: Calendar

 |  |  | Calendar of events
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 10 |  | <== Enter MONTH - 1 to 12
2 |  |  |  |  |  |  |  |  | Year | 2021 |  | <== Enter YEAR - 2018 to 2030
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 188383d1350861460-multiplying-and-sum-2-data-sets-example
Sheet: Sheet1

Total Gross
Australia | Upfront | 1000
 | Arrears | 500
UK | Upfront | 800
 | Arrears | 500
Ireland | Upfront | 300
 | Arrears | 100
Conversion %
Australia |  | 0.73
UK |  | 0.7
Ireland |  | 0.67
Total Net
 | Upfront
 | Arrears
Spreadsheet: 888840d1739447675-how-to-combine-duplicate-rows-into-one-cell-combine-duplicate-rows-into-one-cell
Sheet: Plan1

Contract | [NAME] | State | Helper Col. | Contract | [NAME] |  |  | How to combine duplicate rows into one cell
007052/23 | 4309 | BA
006879/23 | 4310 | BA
007168/24 | 4311 | BA
007178/24 | 4312 | BA
007197/24 | 4313 | BA
007199/24 | 4314 | BA
007026/23 | 4315 | BA
007244/24 | 4316 | BA
007166/24 | 4317 | BA
006963/23 | 4318 | BA
006845/22 | 4319 | BA
006891/23 | 4320 | BA
006766/22 | 4321 | BA
006799/22 | 4322 | BA
007250/24 | 4323 | BA
007234/24 | 4324 | BA
006987/23 | 4325 | BA
007013/23 | 4338 | BA
006947/23 | 4327 | BA
007034/23 | 4328 | BA
007017/23 | 4329 | BA
007047/23 | 4330 | BA
007048/23 | 4331 | BA
007106/24 | 4332 | BA
007108/24 | 4333 | BA
007091/24 | 4334 | BA
007130/24 | 4335 | BA |  |  |  | Should be : 4335/4336
007130/24 | 4336 | BA
006953/23 | 4337 | BA
Spreadsheet: 669180d1585236502-move-rows-to-separate-sheets-astro_kt
Sheet: Sheet2

Acct Code | 2100217340
Vendor | Item | P.O.# | Amount | Sum of Amount
(blank) | Reimbursement for Fingerprinting | 8301900075 | 85.75 | 85.75
 | Safety Net Consulting | 8301900074 | 350 | 350
 |  | 8301900085 | 525 | 525
 |  | 8301900099 | 1250 | 1250
 |  | 8301900107 | 1450 | 1450
 | SPED Programs Targeted Review | 8301900027 | 4500 | 4500
Grand Total |  |  |  | 8160.75
Spreadsheet: 179411d1347246810-extract-the-top-item-excel-question-1-
Sheet: Sheet1

City | cost | count | vendor | Name | I need a way to extract the top (?)items in the cost column |  |  |  |  |  |  |  | [NAME]
Portland | 82.23 | 1 | 8383 | [NAME] | (?) is the variable in count column |  |  |  |  |  |  |  | LA
[NAME] | 83.66 | 1 | 883 | [NAME] |  |  |  |  |  |  |  |  | NY
Seattle | 88.95333333333333 | 5 | 379 | [NAME] | In this example the top 5 items in City Seattle, 9 items in city LA |  |  |  |  |  |  |  | Portland
Seattle | 89.31199999999998 |  | 1781 | [NAME] | and 4 items in city of NY are highlighted |  |  |  |  |  |  |  | Seattle
Seattle | 89.37333333333333 |  | 6842 | [NAME]
Seattle | 87.64 |  | 6837 | [NAME]
Seattle | 89.44333333333333 |  | 6483 | [NAME] | LA
Seattle | 89.55333333333333 |  | 450 | [NAME]
Seattle | 87.64 |  | 446 | [NAME] | City | cost | count | vendor
Seattle | 87.71333333333332 |  | 7483 | [NAME]
Seattle | 87.846 |  | 198 | [NAME]
Seattle | 88.075 |  | 6881 | [NAME]
LA | 90.04499999999999 | 9 | 5926 | [NAME]
LA | 90.4125 |  | 1109 | [NAME]
LA | 90.46666666666665 |  | 285 | [NAME]
LA | 88.7825 |  | 124 | [NAME]
LA | 88.95333333333333 |  | 1863 | [NAME]
LA | 89.31199999999998 |  | 6648 | [NAME]
LA | 89.3733333333333 |  | 1592 | [NAME]
LA | 89.39666666666666 |  | 1471 | [NAME]
LA | 89.44333333333333 |  | 6377 | [NAME]
LA | 89.55333333333333 |  | 1209 | [NAME]
LA | 89.875 |  | 858 | [NAME]
LA | 89.89750000000001 |  | 397 | [NAME]
NY | 89.9375 | 4 | 7399 | [NAME]
NY | 90.04499999999999 |  | 266 | [NAME]
NY | 90.4125 |  | 639 | [NAME]
NY | 89.39666666666666 |  | 1780 | [NAME]
NY | 89.44333333333333 |  | 591 | [NAME]
NY | 91.13 |  | 999 | [NAME]
Spreadsheet: 229617d1366472059-drop-box-multiple-column-sinisaj-example
Sheet: Setup

Name | Points | Description | Name | Points | Description
Critical | 5 | Choose this if have more than XX faults | Annually | 5 | Last check more then year ago
Serious | 3 | Choose this if have between 3 and 5 faults | Moderate | 3 | Last check between half and year ago
Moderate | 1 | Choose this if have below faults | Shortly | 1 | Last check less then half year ago
Spreadsheet: 709039d1608138563-how-to-use-countifs-to-check-partial-contents-of-a-cell-and-also-multiple-criteria-in-range-testbook-1-
Sheet: Sheet1

Name | Task | ID# | Location
[NAME] | A | 4 | Top
[NAME] | A | 2 | Top |  | Total # of Task A for Top & Bottom:
[NAME] | B | 12 | Bottom
[NAME] | B | 14 | Top |  | Total # of Task B for Side:
[NAME] | A | 7 | Front
[NAME] | B | 99 | Side |  | Total # of Tasks A & C for Front
[NAME] | B | 71 | Front
[NAME] | A | 41 | Bottom |  | Total # of Tasks A & B for Side & Top:
[NAME] | B | 22 | Front |  |  |  |  |  | Semicolon |  | Comma
Sandy | C | 20 | Bottom
[NAME] | C | 19 | Top
[NAME] | A | 51 | Side
George | C | 0 | Front
[NAME] | A | 6 | Bottom
[NAME] | B | 44 | Side
[NAME] | C | 65 | Top
[NAME] | A | 25 | Bottom
[NAME] | B | 60 | Front
[NAME] | A | 33 | Side
[NAME] | C | 8 | Top