tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139589d1328319089-excel-2008-running-total-of-different-accounts-checkbook-register-for-show
Sheet: Sheet1

0 | Stall Fees And Membership
10586
1 | Office Supplies
1155.62
2 | Meeting Spaces
60
3 | Advertising
2960.14
4 | Permits
100
5 | Market Manager Discretionary
522.74
6 | Market Manager [NAME]
3130
7 | Wednesday Refunds
140
8 | Winter Market Hall Rental
240
9 | Winter Market Stall Fee Receipts
330
10 | Garden Show
25
11 | Sec/Treas & President [NAME]
800
Total Income
10916
Total Spending
9133.5
Starting Balance
1065.62
Ending Balance
2848.119999999999
Spreadsheet: mary_fischer__25824__31sapportionpayroll
Sheet: Sheet1

Payroll in cities in Ohio:
City |  | Gross Wages |  | Tax Withheld
Pickering |  | 24981.93 |  | 249.81
Columbus |  |  |  | 62961.81
Worthington |  |  |  | 1711.19
Groveport |  |  |  | 115.96
Obetz |  |  |  | 27.51
Alternate Columbus |  |  |  | 1222.46
Alternate Worthington |  |  |  | 2.24
Alternate Obetz |  |  |  | 20.28
Chilicothe |  |  |  | 1363.52
Delaware |  | 456375.35 |  | 6389.1
Lancaster |  | 5190.16 |  | 83.05
Zanesville |  | 31917.08 |  | 542.6
Dublin |  | 1090.67 |  | 21.82
Westerville |  | 96974.49 |  | 1212.39
Whitehall |  | 2523.45 |  | 15.08
Marion |  | 175186.27 |  | 2702.69
The following cities had payroll in 1999 need to confirm no payroll in 2000:
[NAME]
Gahanna
Reynoldsburg
Circleville
Hilliard
Spreadsheet: louise_kitchen__23955__SepYTD Orig w notes sf
Sheet: Canada

Canada
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Davies |  | Power |  | Canada |  | 77249000
Le Dain |  | Gas |  | Canada |  | 6608441
[NAME] |  | Gas |  | Canada |  | 3007965.401451572
Biever* |  | Power |  | Canada |  | 2283200
[NAME] |  | Power |  | Canada |  | 2127333
Oh |  | Gas |  | Canada |  | 2079755.77699323
[NAME] |  | Gas |  | Canada |  | 1217736.952512983
Devries |  | Power |  | Canada |  | 500000
De Stefano |  | Gas |  | Canada |  | 334057
Burnham |  | Gas |  | Canada |  | 298111.0669492223
[NAME] |  | Gas |  | Canada |  | 272578.7369761885
Law |  | Power |  | Canada |  | 138233
Hrap |  | Gas |  | Canada |  | 101076
[NAME] |  | Gas |  | Canada |  | 36584.31118693019
Laporte |  | Gas |  | Canada |  | 4021
[NAME] |  | Gas |  | Canada |  | 3273
Cowan |  | Gas |  | Canada |  | 2863.164572278276
Tycholiz |  | Gas |  | Canada |  | 917
Total
*Enron Retail Number
Spreadsheet: 56129d1256234110-excel-2007-conditional-formatting-summary-based-on-due-completion-dates-projectstatus
Sheet: Playbook

Strategies (and Projects): | Owner | Team | Due | Completed
G.1 Partnerships:
G.1a |  |  | 2009-08-30 00:00:00 | 2009-07-28 00:00:00
G.1b |  |  | 2009-09-30 00:00:00 | 2009-10-05 00:00:00
 |  |  | 2010-03-31 00:00:00
G.1c |  |  | 2009-09-30 00:00:00 | 2009-10-02 00:00:00
G.1d |  |  | 2009-10-15 00:00:00 | 2009-09-28 00:00:00
G.2 Expansion:
[NAME] |  |  | 2009-10-30 00:00:00 | 2009-10-21 00:00:00
G.2b |  |  | 2009-07-31 00:00:00 | 2009-07-30 00:00:00
G.2c |  |  | 2009-07-31 00:00:00 | 2009-07-30 00:00:00
G.2d |  |  | 11/31/09
G.2e |  |  | 2009-08-31 00:00:00 | 2009-08-27 00:00:00
 |  | Total
 |  | Late
 |  | Overdue
Spreadsheet: 95427d1295017990-duplicate-checking-of-two-big-tables-example
Sheet: Sheet2

Campaign | number 1 | number 2 | number 3
Oceania
Clearwater
Victoria & Albert
Hoesch
[NAME]
VitaBath
The Allstone Group
Americh
[NAME] and Boch
[NAME]
[NAME]
[NAME]
French Reflection
Hitchcock-Butterfield
Suneli
MB Quart
Black Country Heritage
Eago
Adagio
Aqua Health
[NAME]
Brondell
Palmer Industries
Thermique
hansgrohe
ProSun
[NAME]
Independent Home
Main Campaign
AstraCast
[NAME]
Decotec
become_Bathroom
Remcraft
Bathroom_pg
Lasco Bathware
Livex Lighting
[NAME] toilets
Bathroom_hgtv
[NAME] giveaway
Studio Italia Design
Fairmont???
Kitchen_pg
Strasser????
[NAME]
Kitchen_smarter
Fairmontë‚ý
Kitchen_become
become_Kitchen
Colonial Bronze
[NAME]
Bathroom_nextag
Blanco SKUs
Quality??
[NAME]??
Atlas‰ÁÞý
Lighting_pg
MB??
Sierra??
Elite Bath
Neo-Metro
[NAME]
WET
Forms and Fixtures
Hydro Systems
Neptune
[NAME]
Dornbracht
MTI
Century
Kindred
Baci By Remcraft
[NAME]
Danze
Maax
Kalco Lighting
St. Thomas
Altmans
[NAME]
Hamat
ELK Lighting
Insinkerator
First Impressions
[NAME]
[NAME]
Ambella Home
Zucchetti
Italbrass
[NAME]
Aquatic
World Imports
Hastings
High Point
Barber Wilsons
Alcove
Flos
WS Bath Collection
Sierra Copper
Linkasink
Fairmont Designs
Amerec
DVontz
Jacuzzi
Duravit
Indocraft
Native Trails
Runtal Radiators
Norwell Lighting
Scarabeo
Wilshire
Santec
Deca
Wave
Empire
Bissonnet
[NAME]
Mitrani
GS North America
Vola
Xylem
Julien
Wesaunard
Elkay
Thompson Traders
Terra Acqua
Watermark
Arteriors
Artistic Lighting
Horus
[NAME]
Moda
Vigo
ShowHouse by Moen
Afina
Windisch
Rubinet
Quality Bath
[NAME]
Westbrass
Richelieu
[NAME]
Barclay
[NAME]
Vibia
Sonoma Forge
Lighting_hgtv
Toto
Aquabrass
Rachiele
Aviana
Cropusa
Newport Brass
[NAME]
Cole & Co.
[NAME]
Sonia
[NAME]
JVJ Hardware
California Faucets
[NAME]
Classic Hardware
[NAME]
Dainolite
Triarch International
Robern
DreamLine
Valsan
Herbeau
Jaclo
Sigma
[NAME]
Graff
(not set)
Webert
Mr Steam
Lenova
Bates
Oceana
Latoscana
Artos
Linnea
Anne At Home
Grohe
Bathroom_become
Hansgrohe
[NAME]
Satinjet
Blanco
Rohl
Cool Lines
Steamist
Nameeks
Cantrio
Schaub & Company
AF Lighting
Whitehaus
[NAME]
Jado
[NAME]
American Standard
Saniflo
Mountain Plumbing
froogle_Bathroom
Cascade
Ginger
[NAME]
Kimball & Young
Bathroom_smarter
Golden Lighting
MGS Designs
Fluid
Emenee
[NAME]
Vipp
Roma
Trend
Cifial
ThermaSol
Amba
KWC
Alno
Waterstone
[NAME]
Smedbo
[NAME]
blanco
[NAME]????
StrasserŠz(K
American???
AmericanÖuÝ
Laurey
Kitchen_cashback
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Linden Terr

 |  |  |  |  |  | 2013 Linden Terrace F.E. + CSFP
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | 2nd Tuesday + CSFP.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 96840d1296117944-formula-to-sort-rows-automatically-sales-data
Sheet: Renewal Customers

Company | Cusomter | Stage | Base | Worked | [NAME] | Sold | Date | Order No. | H | A | PM | Deposit | Direct Debits | Discount | Increase | ROB |  | 1 | Contacted
Company Name 1 | [NAME] | Contacted | 88888 |  |  | 0 |  | 10100001 | 10 | 10 | 5 |  | 8 | 0.025 |  |  |  | 2 | Appointed
Company Name 2 | [NAME] | Appointed | 1200 |  |  | 0 |  | 10100002 | 9 | 8 | 5 |  | 7 | 0.05 |  |  |  | 3 | Renewed
Company Name 3 | [NAME] | Renewed | 1200 |  |  | 1100 | 2011-01-01 00:00:00 | 10100003 | 8 | 7 | 5 |  | 6 | 0.075 |  |  |  | 4 | [NAME]
Company Name 4 | [NAME] | [NAME] | 1200 |  |  | 0 |  | 10100004 | 7 | 6 | 5 |  | 5 | 0.1 |  |  |  | 5
Company Name 5 | [NAME] | Contacted | 1200 |  |  | 0 |  | 10100005 | 6 | 5 | 5 |  | 4 | 0.125 |  |  |  | 6
Company Name 6 | [NAME] | Appointed | 1200 |  |  | 0 |  | 10100006 | 5 | 4 | 5 |  | 3 | 0.15 |  |  |  | 7
Company Name 7 | [NAME] | Renewed | 1200 |  |  | 1800 | 2011-01-07 00:00:00 | 10100007 | 4 | 3 | 5 |  | 4 | 0.175 |  |  |  | 8
Company Name 8 | [NAME] | [NAME] | 1200 |  |  | 0 |  | 10100008 | 3 | 2 | 5 |  | 5 | 0.2
Company Name 9 | [NAME] | Contacted | 1200 |  |  | 0 |  | 10100009 | 2 | 1 | 5 |  | 6 | 0.225
Company Name 10 | [NAME] | Appointed | 1200 |  |  | 0 |  | 10100010 | 1 | 2 | 5 |  | 7 | 0.25
Company Name 11 | [NAME] | Renewed | 1200 |  |  | 2345 | 2011-01-03 00:00:00 | 10100011 | 2 | 3 | 5 |  | 8 | 0.275
Company Name 12 | [NAME] | [NAME] | 1200 |  |  | 0 |  | 10100012 | 3 | 4 | 5 |  | 9 | 0.3
Company Name 13 | [NAME] | Contacted | 1200 |  |  | 0 |  | 10100013 | 4 | 5 | 5 |  | 10 | 0.325
Company Name 14 | [NAME] | Appointed | 1200 |  |  | 0 |  | 10100014 | 5 | 6 | 5 |  | 8 | 0.35
Company Name 15 | [NAME] | Renewed | 1200 |  |  | 234 | 2011-01-08 00:00:00 | 10100015 | 6 | 7 | 5 |  | 7 | 0.375
Company Name 16 | [NAME] | [NAME] | 1200 |  |  | 0 |  | 10100016 | 7 | 8 | 5 |  | 6 | 0.4
Company Name 17 | [NAME] | Contacted | 1200 |  |  | 0 |  | 10100017 | 8 | 9 | 5 |  | 5 | 0.425
Company Name 18 | [NAME] | Appointed | 1201 |  |  | 0 |  | 10100018 | 9 | 10 | 5 |  | 4 | 0.45
Spreadsheet: 152426d1335377693-how-to-track-multiple-purchases-book1
Sheet: Sheet2

 |  |  | Total |  | TOTAL | UNIT
DATE | Item | QTY | PRICE | Shipping | COST | COST
 | 2LB Monofilament | 2
 | 2.3mm Crimps
 | 4 Ounce Weights
 | 6 Ounce Weights
 | Plastic Bags
Spreadsheet: 66a8ee3c-3d72-431f-9cc8-e8817b8ca77e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Concept Cost Estimate Form
 | Instructions
 | Verify all print settings before printing for QC documentation. Do not print entire workbook otherwise Item List tab will print. Highlight the tabs you wish to print and print active sheets.
 | [NAME]
 | The first tab is the summary of the results of the estimate. Verify all formulas.
 | As a general rule, green cells need to be customized for your project. Fill in all project information and percentages for PE, CE, etc.
 | The proposed commission request should be the total cost.
 | [NAME]
 | This tab is for construction item inflation. The green cells can be customized to meet individual project needs.
 | A separate value can be entered for each year. The inflation factor is used to calculate the inflated cost from the present year to the assumed construction year.
 | Construction Item Tabs
 | These tabs are broken into the major items of work. Under each tab list the appropriate items that make up that major item of work. Fill in quantity, unit cost, and method of measurement.
 | Use, add, or delete items from the master list, using the correct item numbers and units. Enter appropriate unit prices. (PDBS and bid abstracts are price resources).
 | Make sure formulas in the cost column are correct.
 | [NAME]
 | This tab is to help document calculations and assumptions. Modify as needed for unit weights, application rates, and dimensions used for computing quantities. Verify all formulas.
 | The pavements chart can be used for full depth or partial depth work. Enter assumed length, top width, side slopes, and depth of each layer. Quantities are given in volume and weight.
 | The earthwork chart simply requires the length, width, and depth assumptions for the items. The water and oil charts just reference information from the other charts.
 | The totals for these items are referenced into the master item list on the first tab.
 | You must select to pay for UTBC, GB, Borrow, and [NAME] by the TON or YD^3. Just delete the row on the PI-Roadway-Drainage tab that you do not want.
 | The pavement marking table is used to calculate gallons of paint needed. This table is to be used to sufficiently quantify paint which is typically a very small percentage of the project cost.
 | Additional tables are included to help document calculations for future understanding and revising.
 | Incentive Calculator [NAME]
 | This tab is used to calculate the contractor incentives. They are calculated in this tab, but the costs are reported on the Util-RW-Inc tab under Incentives.
 | Verify and adjust as needed.
 | Item List Summary
 | This tab is to be used as a reference to UDOT's standard items. It is used to quickly identify standard item descriptions, item numbers, and units.
 | You may update the list as needed.
 | UDOT Estimate Support can be reached at (801) 965-4708.
Spreadsheet: 99191d1297904320-weekly-and-monthly-reporting-test
Sheet: GROUP2

DATE | NAME | INVESTMENT | RETURN | ROI | +/- | TOTAL
2011-01-01 00:00:00 | A | 20 | 30 | 0.5 | 10 | 10
2011-01-14 00:00:00 | B | 40 | 50 | 0.25 | 10 | 20
2011-01-15 00:00:00 | C | 70 | 25 | -0.6428571428571429 | -45 | -25
2011-02-01 00:00:00 | D | 80 | 60 | -0.25 | -20 | -45
2011-02-10 00:00:00 | E | 30 | 150 | 4 | 120 | 75
Spreadsheet: 707228d1607106148-calculating-meal-penalties-formula-lunch-break-time-sheet-cabryka96-
Sheet: Sheet1

NAME: | POSITION: | CALL: | OUT: | IN: | OUT: | IN: | WRAP: | RERATE: | AM MP: | PM MP:
[NAME] | DP | 06:00:00 | 14:00:00 | 13:30:00 |  |  | 20:30:00 |  |  | 0
[NAME] | "A" Operator
[NAME] | "B" Operator
[NAME] | "A" 1st AC
[NAME] | "A" 2nd AC
[NAME] | "B" 1st AC
[NAME] | "B" 2nd AC
[NAME] | DIT
[NAME] | Loader
[NAME] | Camera PA
Spreadsheet: 30782d1226455515-sorting-data-query-array-3-sheets
Sheet: Sheet1

items | factory
2345 | a
2346 | b
2347 | c
2348 | a
2349 | a
2350 | a
2351 | b
2352 | b
2353 | b
2354 | c
2355 | b
2356 | b
2357 | c
2358 | a
2359 | c
2360 | b
2361 | b
2362 | c
2363 | a
2364 | b
Spreadsheet: kevin_presto__20238__EIA411 Reporting Forms Revised 01 30 02
Sheet: Data Input - NERC Forms

NERC Form 5
Transmission Lines
[NAME]
Region: | SERC |  | Report data in WHOLE number miles
Subregion: |  |  | Include lines that are under construction, committed to, or are in various stages of planning.
Reporting Party:
Reporting Party (EIA-Code):
 | Transmission Line Data (Circuit Miles)
 | AC Voltage |  |  |  |  | +/- DC Voltage |  |  |  |  | AC & DC
 | 230 | 345 | 500 | 765 | Total AC | 250-300 | 400 | 450 | 500 | Total DC | Total
Existing 12/31/2001 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Planned First Five Years (3) | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Planned Second Five Years | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Total 12/31/2010
Spreadsheet: 45492d1244219731-how-to-check-for-a-particular-letter-in-a-column-example
Sheet: Example

Item | Stock | HD | CG
ITEM 1 | 47 | 1.4 | J
ITEM 2 | 15000 | 1.4 | C
ITEM 3 | 14952 | 1.4 | C
ITEM 4 | 1461 | 1.4 | C
ITEM 5 | 27900 | 1.4 | C
ITEM 6 | 9280 | 1.4 | C
ITEM 7 | 51580 | 1.4 | C
ITEM 8 | 1508 | 1.4 | C
ITEM 9 | 1600 | 1.4 | C
ITEM 10 | 5500 | 1.4 | B
ITEM 11 | 4500 | 1.4 | D
ITEM 12 | 2500 | 1.4 | C
ITEM 13 | 5000 | 1.4 | C
ITEM 14 | 1000 | 1.4 | C
Spreadsheet: 65232d1265920464-sumproduct-using-multiple-conditions-book1
Sheet: Sheet1

 | 21st January | Cheque Deposit |  |  |  |  | 3206.97 | Yes
 | 21st January | Service Fee |  |  |  | 33 |  | Yes
 | 22nd January | [NAME]:Maestr-E (enter date) |  |  | 18th January |  | 606.58
 | 22nd January | [NAME]:Duality-E (enter date) |  |  | 19th January |  | 3425.51 |  | 3919.15
 | 25th January | [NAME]:Maestr-E (enter date) |  |  | 19th January |  | 493.64
 | 25th January | [NAME]:Duality-E (enter date) |  |  | 20th January |  | 5701.8
 | 25th January | Cheque Deposit |  |  |  |  | 4275.19 | Yes
 | 26th January | [NAME]:Duality-E (enter date) |  |  | 21st January |  | 2690.09 |  | 3686.79
 | 26th January | [NAME]:Maestr-E (enter date) |  |  | 20th January |  | 158.48
 | 26th January | Transfer to Account 54132587 |  |  |  | 3000
 | 27th January | [NAME]:Maestr-E (enter date) |  |  | 21st January |  | 996.7
Spreadsheet: 694503d1599652426-how-to-create-a-grouping-from-multiple-rows-and-assign-rankings-rankingsample
Sheet: Detail

[NAME]
 | Supplier | Product | Status | Status Rank | Status2
 | C-Tech | [NAME] | Planning
 | R-Cal | [NAME] | Design
 | Dragon | [NAME] | Ready
 | Dragon | Flux Capacitor | Referred
 | Halo Design | Flux Capacitor | Planning
 | TMZ | Gullwing doors
 | Doc Brown Inc | Gullwing doors | Referred
 | R-Cal | Digital Readout
 | C-Tech | Digital Readout
 | Doc Brown Inc | Digital Readout
 | TMZ | Opposable hinge | Ready
 | Dragon | Opposable hinge | Not Needed
Spreadsheet: 49071d1248347832-auto-count-then-auto-sum-book2
Sheet: Sheet2

 | 0 | -1 |  |  | For example
 | 1 | -1 |  |  |  | 0 | -1 |  | total | 0
 | 2 | -1 |  |  |  | 5 | -1
 | 3 | -1 |  |  |  | 8 | 0
 | 4 | -1 |  |  |  | 9 | 1
 | 5 | -1 |  |  |  | 10 | 1
 | 6 | -1
 | 7 | 0
 | 8 | 0
 | 9 | 1
 | 10 | 1
Spreadsheet: 3349f88b-3918-48cf-a4aa-ac0626ca7f57
Sheet: Tables

Rates
MFP B&W | 0.0207
MFP Color | 0.087
Printer B&W | 0.0262
Printer Color | 0.118
 |  |  | Devices | Type
 |  |  | AF MP301SP | MFP
 |  |  | AF MP4002 | MFP
 |  |  | AF MP6001 | MFP
 |  |  | AF MPC2051 | MFP
 |  |  | AF MPC3502 | MFP
 |  |  | AF MPC4502 | MFP
 |  |  | AF MPC6501 | MFP
 |  |  | AF SP4310N | PTR
 |  |  | AF SPC242DN | PTR
[NAME] on: | 2012-12-31 00:00:00
Spreadsheet: 0575371d-72dd-4a76-8149-43edc48a473d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 2. HOUSING AND PERSONAL FINANCE COMMITMENTS By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Housing Finance - Banks ; |  |  | Original | A2437051V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Housing Finance - Permanent building societies ; |  |  | Original | A2437052W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Housing Finance - Wholesale lenders n.e.c. ; |  |  | Original | A2437053X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Housing Finance - Other lenders ; |  |  | Original | A2437054A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Housing Finance - Total ; |  |  | Original | A2437055C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Personal Finance - Banks ; |  |  | Original | A2437046A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Personal Finance - Credit co-operatives ; |  |  | Original | A2437047C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Personal Finance - Finance companies ; |  |  | Original | A2437048F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Personal Finance - Other lenders ; |  |  | Original | A2437049J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2437050T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 169875d1343080429-index-and-match-help-lifting-lug-spreadsheet-help-oeldere-
Sheet: Horizontal Vessel

N: | 8 | Number of lugs |  |  |  | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
W(lbs): | 26800 | Total weight of vessel |  |  |  | 0.3125 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 3350 | Load per lug |  |  |  | 0.375 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
P(lbs): | 6700 | Allowable load per lug(Safety factor of 2x) used to calculate tb |  |  |  | 0.4375 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Sa(lb/in2): | 13700 | ASME code- Allowable stress in tension for a material |  |  |  | 0.5
tb(in): | 0.3470451473371182 | Thickness of plate type lifting lugs |  |  |  | 0.625
 | 0.375 | Use this thickness for lug plate |  |  |  | 0.75
Rl(in): | 3 | Outer radius of plate type lifting lug |  |  |  | 0.875
Rh(in): | 0.75 | Radius of hole in plate type lifting lug |  |  |  | 1
l(in): | 9.5 | Length of plate type lifting lug |  |  |  | 1.25
d(in): |  | Distance from outside of shell or head to centerline
P1: | 6700.000000000001
P2:
Spreadsheet: 93077d1292578513-fiter-for-same-data-after-entering-a-duplicate-name-example
Sheet: Sheet1

Name | Count
[NAME] | 1
Dara2 | 1
Dara3 | 1
Dara4 | 2
Dara5 | 1
Dara6 | 2
Dara7 | 1
Dara8 | 1
Dara9 | 1
Dara10 | 1
Dara11 | 1
[NAME] | 1
Dara13 | 1
Dara14 | 1
Dara15 | 1
Dara16 | 1
[NAME] | 1
Dara18 | 1
Dara19 | 1
Dara20 | 1
Dara21 | 1
Dara22 | 1
Dara23 | 1
Dara24 | 1
Dara25 | 1
Dara4 | 2
Dara6 | 2
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 152249d1335302867-excel-2007-listing-values-over-multiple-sheets-index-exaplme
Sheet: HoodRiver

DATE:
BAY | ROUTE | [NAME] | CASES | [NAME] |  | ADJ | STOPS | CASE PICKER | Total | Start | Stop | Adj | T-TIME | BOTTLE PICKER | [NAME] | START | STOP | ADJ | T-TIME | CASE PICKER PRECENT |  |  |  | BOTTLE PICKER PERCENT
 |  |  |  |  |  |  |  | [NAME] | 40
 |  |  |  |  |  |  |  | Jon | 500
 |  |  |  |  |  |  |  | [NAME] | 60
 |  |  |  |  |  |  |  | [NAME] | 50
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 42477d1241034261-countif-and-a-range-of-dates-book1-5
Sheet: Sheet1

Project 1 | 2009-01-10 00:00:00
Project 2 | 2009-02-19 00:00:00
Project 3 | 2008-09-26 00:00:00
Project 4 | 2008-10-07 00:00:00
Project 5
Project 6 | 2009-03-27 00:00:00
Project 7 | 2009-04-20 00:00:00
Project 8
Project 9 | 2009-02-05 00:00:00
Project 10 | 2009-03-02 00:00:00
 |  | # [NAME] This Month | # [NAME] Last Month | # [NAME] Last Quarter | # [NAME] YTD
 |  | 1 | 2 | 5 | 6 |  | Manual Calculations
Spreadsheet: 146649d1332279987-solved-help-with-the-if-function-to-calculate-my-ordinary-hours-for-a-timesheet-part-b-task-1-produce-spreadsheets
Sheet: Spreadsheet Template

Bob's Building Services
Weekly Time Sheet
Employee Name:
Payroll Period Commencing: |  |  |  | 2012-12-12 00:00:00
Payroll Period Ending:
Day | Date | Start Time: | Lunch Break: | Finish Time: | Total Hours | Ordinary Hours | Over Time | T1/2 | DT
Monday |  |  | 00:30:00
Tuesday |  |  | 00:30:00
Wednesday |  |  | 00:30:00
Thursday |  |  | 00:30:00
Friday |  |  | 00:30:00
Saturday |  |  | 00:30:00
Sunday |  |  | 00:30:00
Total
On weekdays, the first 2 overtime hours are paid at time and a half and remaining overtime hours are paid at double time rates.
Hours worked on Saturday are considered overtime, with the first 2 hours worked at time and a half rates and remaining overtime hours are paid at double time rates.
Using an IF statement in [NAME], calculate the ordinary hours component of total hours
Using a nested IF statement in H8, calculate the overtime hours.
Using a nested IF statement in I8, calculate the time and a half (T ½) overtime hours
Using a nested IF statement in J8, calculate the double time hours.