tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Competitive Ana

 | 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
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 1
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 2
 |  |  |  |  |  |  |  | Managers | 90000 | 1
 | Headcount |  |  | 28 |  |  |  | Directors | 120000 | 1
 |  |  |  |  |  |  |  | General Counsel Asst | 178800 | 0
 | Analysts & Associate Headcount |  |  | 0 | 0 |  |  | Vice President | 216000 | 0
 |  |  |  |  |  |  |  | [NAME] | 312000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 | Outside Services | 1140923 |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: aa2874f1-f9ff-4e31-9e24-b9652e37468c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-09-10 09:30:28.460000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.722 | 101.597 | 101.472 | 101.097
3.75 | 101.425 | 101.3 | 101.175 | 100.8 |  | Note: | Refer To Price [NAME]
3.625 | 101.025 | 100.9 | 100.775 | 100.4 |  |  | For all Price Adjs
3.5 | 100.4 | 100.275 | 100.15 | 99.525
3.375 | 99.582 | 99.457 | 99.332 | 98.707
3.25 | 98.666 | 98.541 | 98.416 | 97.791
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.902 | 101.777 | 101.652 | 101.277
3.25 | 101.535 | 101.41 | 101.285 | 100.91
3.125 | 101.235 | 101.11 | 100.985 | 100.61
3 | 100.885 | 100.76 | 100.635 | 100.26
2.875 | 100.264 | 100.139 | 100.014 | 99.389
2.75 | 99.605 | 99.48 | 99.355 | 98.73
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-09-24 09:30:28.460000
30 DAY | 2012-10-09 09:30:28.460000
45 DAY | 2012-10-24 09:30:28.460000
60 DAY | 2012-11-08 09:30:28.460000
90 DAY | 2012-12-08 09:30:28.460000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 190708d1351769215-need-an-updated-stock-level-beta-test
Sheet: Sheet1

item | Designated amount |  | Item | stock used | stock to date |  | workings
box a | 20 |  | box a | 10
[NAME] | 20 |  | box a | 2
box c | 30 |  | box a | 6
Spreadsheet: 37960d1236075148-random-input-random2
Sheet: wednesday

 | chore 1 | chore 2 | chore 3
child 1 | task 11 | task 26 | task 30
child 2 | task 14 | task 10 | task 9
child 3 | task 25 | task 3 | task 24
child 4 | task 6 | task 17 | task 1
child 5 | task 2 | task 22 | task 8
child 6 | task 5 | task 7 | task 29
child 7 | task 27 | task 28 | task 23
child 8 | task 19 | task 8 | task 16
child 9 | task 15 | task 16 | task 12
child 10 | task 4 | task 23 | task 21
child 11 | task 21 | task 29 | task 4
child 12 | task 12 | task 20 | task 15
child 13 | task 13 | task 1 | task 19
child 14 | task 18 | task 24 | task 27
child 15 | task 26 | task 9 | task 5
child 16 | task 10 | task 30 | task 2
child 17 | task 3 | task 11 | task 6
child 18 | task 17 | task 14 | task 25
Spreadsheet: 98cf2ffe-af1e-45a2-afd6-7bf540c2703f
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
PLACE | DOSSARD | NOM | PRENOM | CLUB
1ère CATEGORIE
1 | 42 | [NAME] | CEDRIC | ST SATURNIN AVIGNON
2 | 41 | GERVASIO | ROCKI | U C SORGUES
3 | 22 | BERNARDI | STEPHANE | [NAME]
4 | 44 | SERES | LIONEL | AS PTT AIX
5 | 48 | FALINI | [NAME] | ESCL ROGNES
6 | 18 | BIENAIME | LUDOVIC | [NAME]
7 | 29 | [NAME] | BENJAMIN | RO BRIGNOLES
8 | 28 | FARAMA | BENOIT | STVS TULLE
9 | 8 | MERANDI | DAVIC | OCC DRAGUIGNAN
10 | 33 | VIEUX | DANIEL | CC BERRE
2ème CATEGORIE
1 | 56 | LEPORATTI | MATHIEU | ASPTT AIX
2 | 36 | LAJARA | FABRICE | VC VIDAUBAN
3 | 9 | SAUMET | ANDRE | UC SORGUES
4 | 46 | FIGUERA | [NAME] | VC MIRAMAS
5 | 48 | AUDON | STEPHANE | [NAME]
6 | 4 | CZARNEKI | LOIC | [NAME]
7 | 27 | MAURRIC | GERARD | CS LA CIOTAT
8 | 60 | HERNANDEZ | GILLES | VC PORT DE BOUC
9 | 57 | [NAME] | LAURENT | ES CAVAILLON
10 | 35 | O,BRIEN | FRANCK | RO BRIGNOLES
3ème CATEGORIE
1 | 31 | MERANDI | FABIEN | OCC ANTIBE
2 | 15 | MENSA | PIERRE | MJC PLAN DE CUQUES
3 | 16 | VILLENEUVE | MICHEL | MJC PLAN DE CUQUES
4 | 44 | SANNIER | ALBERT | ST TULLE
5 | 50 | RANQUET | [NAME] | AC ORANGEOIS
6 | 61 | DANSET | THOMAS | ASPTT AIX
7 | 34 | CASTELLANO | MARC | UC VAISON
8 | 43 | [NAME] | BERTRAND | VC VALREAS
9 | 78 | GAUDION | THOMAS | [NAME]
10 | 58 | OLLIER | [NAME] | UC AVIGNON
GS
1 | 49 | BONNY | [NAME] | ASPTT AIX
2 | 28 | CHIRI | MARC | ASPTT AIX
3 | 32 | CONVERT | SERGE | [NAME]
4 | 7 | SIDOLLE | MICHEL | ISTRE SPORT
5 | 26 | DE CESARE | CHRISTIAN | UC CARQUEIRANE
6 | 4 | JULIA | GUY | OCC ANTIBES
7 | 51 | CORDES | SYLVIE | CS CAVAILLON
8 | 16 | CABROL | JEANJACQUE | VELO PLUS
9 | 42 | FOUQUES | ARMAND | ASPTT AIX
10 | 52 | BAILLOEUIL | LAURENT | [NAME]
Spreadsheet: 142241d1329749238-daily-average-min-and-max-for-certain-number-book1
Sheet: Sheet1

Find average of column d for certain # in column c for today's date in column e
Find minimum of column d for certain # in column c for today's date in column e
Find maximum of column d for certain # in column c for today's date in column e
2141325 | D96047R | 120 | 77 | 2012-02-01 13:58:18
2139031 | D97035 | 110 | 67.3 | 2012-02-07 22:36:47
2139039 | D97035 | 110 | 67.1 | 2012-02-08 22:36:47
2141324 | D96047R | 120 | 77 | 2012-02-09 13:55:18
2139049 | D97035 | 110 | 68.1 | 2012-02-09 22:36:47
2141334 | D96047R | 120 | 77 | 2012-02-09 23:12:20
2139057 | D97035 | 110 | 68.2 | 2012-02-10 22:36:47
2139092 | D97035 | 110 | 68.3 | 2012-02-14 22:36:47
2141345 | D96047R | 120 | 77 | 2012-02-17 23:17:58
2141326 | D96047R | 120 | 77 | 2012-02-20 13:59:41
2141347 | D96047R | 120 | 70.89 | 2012-02-20 23:19:09
2141350 | D96047R | 120 | 76.01 | 2012-02-20 23:20:24
Spreadsheet: 775523d1649164165-unique-count-and-output-total-count-for-ids-that-meet-condition-test15v2
Sheet: Sheet2

ID | No. Of Tokens
568154112108
568154112108
568154112108
568154112108
561448899106
561448899106
559371321100
578954125102
578954125102
578954125102
578923232107
578871123104
579497650100
578899478102
560567694101
560567694101
560567694101
560567694101
560567694101
560567694101
560567694101
561874035104
558862935103
578721906104
578721906104
560738520104
Spreadsheet: 146680d1332306518-drop-down-list-help-dropdownlist
Sheet: Sheet1

State | HaiPhong
Product | Product and Code |  |  |  |  |  |  |  |  |  |  | HCM
Car | HaiPhongC02 |  |  |  |  |  |  |  |  |  |  | HaNoi
 |  |  |  |  |  |  |  |  |  |  |  | HaiPhong
 |  |  |  |  |  |  |  |  |  |  |  | Bike
 |  |  |  |  |  |  |  |  |  |  |  | Car
 |  |  |  |  |  |  |  |  |  |  |  | House
Spreadsheet: 851721d1701879000-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: HP's

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 |  |  | For production quote- [NAME]
 | 242695 | 1 | SupplyLogic | 47 | 42 | 42 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-01 00:00:00 |  | HP
 | 242683 | 1 | Ad Trends Advertising | 5 | 16 | 94 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-01 00:00:00 |  | HP
Spreadsheet: 761668d1641144578-dynamic-dropdown-in-excel-dnamic-dropdown
Sheet: Acct

YEAR | MONTH | PARTNAME | SRCKEY | TARGKEY
2021 | Oct | IF1222_FM | 640003-LF00E30100303 | AC_531 |  |  | 640003-LF00E30100303 | 600515000-11112 | XXX581000-W0059
2021 | Oct | IF1222_FM | 600515000-11112 | AC_505
2021 | Oct | IF1222_FM | XXX581000-W0059 | AC_504
2021 | Oct | MC_SAP_FM | 654021-LF00E33100801 | AC_502
2021 | Oct | MC_SAP_FM | [PHONE] | AC_131
2021 | Oct | [NAME] | [PHONE] | AC_221
2021 | Oct | [NAME] | [PHONE] | AC_521
2021 | Oct | [NAME] | [PHONE] | AC_506
2021 | Oct | [NAME] | [PHONE] | AC_113
2021 | Oct | [NAME] | [PHONE] | [NAME]
Spreadsheet: 4cf6992b-fce1-4933-84ac-e8db44750551
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 1 Semiconductors 1.6 Logic circuits 1.6.2 TTL circuits
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME] | Germany | Rechberghausen | 73098 | A3.125
2 | Micrel Inc. | USA | San Jose | CA 95131 | A4.125
3 | RS Components GmbH | Germany | Mörfelden-Walldorf | 64546 | A4.117
Spreadsheet: ea9c1c72-3f77-4b23-bd28-8e2fd1811de7
Sheet: Sheet1

Unnamed: 0 | Grupos de fuentes | [NAME] anual (g EQT/a) | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Grupo |  | Aire | Agua | [NAME] | Producto | Residuo
1 | Incineración de desechos | 0 | 0 | 0 | 0 | 0
2 | Producción de Metales Ferrosos y No Ferrosos | 0 | 0 | 0 | 0 | 0
3 | Generación de Energía y Calor | 0 | 0 | 0 | 0 | 0
4 | Producción [NAME] | 0 | 0 | 0 | 0 | 0
5 | Transporte | 0 | 0 | 0 | 0 | 0
6 | [NAME] a cielo abierto | 0 | 0 | 0 | 0 | 0
7 | Producción Productos químicos y Bienes de consumo | 0 | 0 | 0 | 0 | 0
8 | Misceláneos | 0 | 0 | 0 | 0 | 0
9 | Disposición / Relleno Sanitario | 0 | 0 | 0 | 0 | 0
10 | Identificación de Potenciales Puntos Calientes |  |  |  | 0 | 0
1-10 | Total | 0 | 0 | 0 | 0 | 0
 | Gran Total | 0
Revisado el archivo de Excel a partir de diciembre de 2012.
Las revisiones, cambios y nueva información se destacan con texto rojo.
Spreadsheet: b005f065-af04-48af-abaf-42f3224190dc
Sheet: Table 1.1

Monthly Statistical Bulletin
1.1 Employment
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Number employed (a) – '000
July | 10800.0855256 | 11021.2508597 | 11217.3825337 | 11352.030225 | 11472.7050031
August | 10781.8834393 | 11056.5671294 | 11219.5547204 | 11354.6814293 | 11465.6801111
September | 10806.6109656 | 11082.2052125 | 11243.0538827 | 11373.7860519 | 11470.2767518
October | 10827.0195144 | 11109.3295875 | 11253.7063182 | 11381.8989499 | 11475.2692608
November | 10851.9538036 | 11165.8776889 | 11259.4428636 | 11392.9933923 | 11491.0869452
December | 10883.807609 | 11170.0379718 | 11237.2982753 | 11406.4706107 | 11467.5350315
January | 10925.7613485 | 11150.5511383 | 11284.0359392 | 11438.5566226 | 11488.2948766
February | 10920.587888 | 11177.6608358 | 11270.576813 | 11465.5427383 | 11536.3504034
March | 10934.754682 | 11224.9139574 | 11338.2826892 | 11436.164263 | 11558.1027579
April | 10942.6209733 | 11185.703678 | 11319.8731138 | 11467.3940438 | 11567.3531238
May | 10941.1624142 | 11172.377061 | 11360.280598 | 11463.0859033 | 11562.2801055
June | 11000.4953251 | 11212.3491922 | 11337.4029059 | 11477.9553303 | 11578.2145516
Annual average | 10884.85672308333 | 11146.91448858333 | 11278.67881266667 | 11417.63598275 | 11511.51525705833
Annual change (a) – per cent
July | 0.4550426005342403 | 2.047810950901829 | 1.779577259394121 | 1.200348574148052 | 1.063023756175733
August | -0.02739560294803031 | 2.54764106518512 | 1.47412473593731 | 1.204385666521208 | 0.9775587495882979
September | 0.2774420822081987 | 2.5502375145851 | 1.451413929951181 | 1.162781665586089 | 0.8483604268596268
October | 0.3005779020746704 | 2.607458799945132 | 1.299598950259336 | 1.139114777614917 | 0.8203403606989514
November | 0.6566732756988315 | 2.89278678274377 | 0.8379562924373819 | 1.186120222091532 | 0.8609989448979825
December | 0.9045437726868085 | 2.629873414551285 | 0.6021492824805553 | 1.505453813323151 | 0.5353489513462393
January | 1.257460546717414 | 2.057429067227984 | 1.197113929566272 | 1.369374257868192 | 0.4348298097482873
February | 1.088076160734655 | 2.354021142785563 | 0.8312649539553698 | 1.729866434831607 | 0.6175692395569744
March | 1.451167789771041 | 2.653550846253904 | 1.009974172009231 | 0.863283942401929 | 1.066253440364733
April | 1.318723682372324 | 2.221430362004881 | 1.199472466483127 | 1.303203035201504 | 0.8716808685408602
May | 1.512522716212549 | 2.113254863120549 | 1.681858175516872 | 0.9049539262093528 | 0.8653359403984244
June | 2.20187252911488 | 1.925857525857118 | 1.115321254773229 | 1.239723290832817 | 0.8734937400856765
Annual average | 0.9487373746218708 | 2.407544464450837 | 1.182069928124818 | 1.834872227276293 | 1.83212047642823
(a) Monthly figures are seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-08-07 00:00:00
Spreadsheet: 49472d1248822122-vb-script-sorting-and-conditional-formatting-inventory-example
Sheet: Inventory

Choose a Warehous # |  | 2600 |  |  |  |  |  | Total Onhand Inv. | Total Used Inv.
ITEM | Vendor # | Desc 1 | Desc 2 | Cost | Onhand | Used | % Used | 48 | 1339 | Warehouses
1452 |  |  |  | 1 | -4 | 0 | None on Hand |  |  | 2600
1453 |  |  |  | 1 | 8 | 0 | 0 |  |  | 2601
1458 |  |  |  | 2 | -4 | 18 | None on Hand |  | 36 | TOT.
1470 |  |  |  | 3 | 6 | 10 | 1.666666666666667 | 18 | 30
1475 |  |  |  | 4 | -5 | 18 | None on Hand
1492 |  |  |  | 5 | -164 | 233 | None on Hand |  | 1165
2817 |  |  |  | 6 | 5 | 18 | 3.6 | 30 | 108
3377 |  |  |  | 1 | 0 | 0 | Out of Stock
3406 |  |  |  | 1 | 0 | 0 | Out of Stock
3456 |  |  |  | 1 | 0 | 0 | Out of Stock
6446 |  |  |  | 1 | 16 | 0 | 0
6447 |  |  |  | 1 | 0 | 0 | Out of Stock
Spreadsheet: 266bb69d-1116-4474-9bce-cb5afac945df
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTRA | Test | FFTRA | [NAME] (Ultram), Qualitative, [NAME] | [NAME] (Ultram) Urinary | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | [NAME]: Urine |  |  | 10 | mL | 10 mL of urine from a random or spot urine in a plastic 10-mL urine tube (Supply T068). Send specimen refrigerated. | 1.2 mL Note:  Submission of the | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Test Performed By:  Medtox Laboratories, Inc.                                          402 W. County Road D                                          St. Paul, MN  55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82541 |  |  |  |  | Medtox Laboratories, Inc
FFTRA | Result | Z1213 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 781277d1653127985-obtain-the-numbers-of-a-list-depending-the-name-distribui-o-de-pe-as
Sheet: JOSÉ

 |  |  | JOSÉ
 |  |  | Nª PEÇA | DESCRIÇÃO | VALOR
Spreadsheet: 149369d1333886469-complex-if-statement-betting-results
Sheet: Sheet4

GOAL LINE BET | GOALS IN GAME | RESULT |  | -0.5 | LOST
2.25 | 5 |  |  | -0.25 | 1/2 LOST, 1/2 PUSH
3 | 3 |  |  | 0 | PUSH
3.25 | 3 |  |  | 0.25 | 1/2 WIN, 1/2 PUSH
 |  |  |  | 0.5 | WIN
Spreadsheet: 598605d1542625259-formula-used-in-weekly-reduction-of-work-hours-test-workbook-tms-v2
Sheet: Date Examples

"Date" | Comment |  |  |  |  |  | Use [NAME] | Name Manager to view the Named Ranges
Mar - 01st | Text - not an actual date
42795 | An unformatted date … a number representing the number of days from 1 January 1900 |  |  |  |  |  | Named Ranges
 | The date in cell [NAME] formatted as a Short Date |  |  |  |  | 419 | Weekday Constant
 | The date in cell [NAME] formatted as a Long Date |  |  |  |  | 48 | Weekend Constant
 | The date in cell A3 formatted with [NAME]: mmm - dd
 | The date in cell A3 formatted with [NAME]: ddd
 | The date in cell A3 formatted with [NAME]: dddd
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
 | Because dates are numbers relative to a known starting point, | 2017-03-01 00:00:00 | 2017-03-05 00:00:00 | 2017-03-12 00:00:00 | 2017-03-19 00:00:00 | 2017-03-26 00:00:00 | Formulae for column G
 | you can do arithmetic on them | 2017-03-04 00:00:00 | 2017-03-11 00:00:00 | 2017-03-18 00:00:00 | 2017-03-25 00:00:00 | 2017-03-31 00:00:00
 | Number of days in period |  |  |  |  |  | =G13-G12+1
 | Weekend Days |  |  |  |  |  | =(WEEKDAY(G12,11)>=6)*1+(WEEKDAY(G13,11)>=6)*1
 | Weekdays |  |  |  |  |  | =G14-G16
 | Start day |  |  |  |  |  | =G12
 | End Day |  |  |  |  |  | =G13
 | Calculation |  |  |  |  |  | =Weekday_Constant*G15+Weekend_Constant*G14
 |  |  |  |  |  |  | =Weekday_Constant * Weekdays + Weekend_Constant * Weekend_Days
Spreadsheet: 164520d1340803133-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test
Sheet: Friday Night Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  | X | 1 | If required, has the site specific training been completed?
 |  |  | X | 2 | If permits are required, do you have the proper papers?
 |  |  | X | 3 | Is Scaffolding correct and safe?
 |  |  | X | 4 | If lockout is required, has the proper procedure been followed?
 |  |  | X | 5 | Do you know the emergency signals?
 |  |  | X | 6 | Do you know the escape routes and assembley points?
 |  |  | X | 7 | Are safety glasses required?
 |  | X |  | 8 | Is a face sheild required?
 |  |  | X | 9 | Is a hard hat required?
 |  | X |  | 10 | Are flame resistant clothes required?
 |  |  | X | 11 | Is hearing protection required?
 |  |  | X | 12 | Are safety toed shoes required?
 |  | X |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  | X | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 863112d1710673864-extracting-unique-data-from-repeating-parameters-in-excel-dynamic-approach-needed-extracting-unique-data-ans-2-
Sheet: Sheet1

a1 | b1 | 10
a1 | b1 | 15 |  |  |  |  |  | AVERAGE | Median | SD
a1 | b2 | 20 |  | b1 | 10 | 15 | 0 | 12.5 | 12.5 | 3.535533905932738
a2 | b1 | 25 | a1 | b2 | 20 | 0 | 0 | 20 | 20 | 0
a2 | b1 | 30 | a2 | b1 | 25 | 30 | 35 | 30 | 30 | 5
a2 | b1 | 35 | a2 | b2 | 40 | 45 | 0 | 42.5 | 42.5 | 3.535533905932738
a2 | b2 | 40 | a2 | b3 | 50 | 55 | 60 | 55 | 55 | 5
a2 | b2 | 45
a2 | b3 | 50
a2 | b3 | 55
a2 | b3 | 60
Spreadsheet: cfa88e27-4f83-4bfe-a83e-163f33bdd000
Sheet: 13 Labor Management (A)

 |  |  | City of Ankeny
LABOR- MANAGEMENT RELATIONS
Iowa: | As of March 2013
Is the State Right to Work | Yes
Percent of Private Workforce Organized | 0.055
Organized in Private Manufacturing Sector | 0.152
Ankeny: Union Elections - Companies w/ 50 or more Employees, Last 5 Years | Number | Percent Won by Union
Number and Percent Won by Unions in Manufacturing | 0 | N/A
Number and Percent Won by Unions in BioScience, [NAME]. Tech./Business Services | 0 | N/A
Number and Percent Won by Unions in All Sectors | 0 | N/A
Union Elections - Companies w/50 or more Employees, Last 5 Years | Union | SIC Code | Date
Company Name | N/A
Union Involved | N/A
Industry SIC Code | N/A
Number of Votes for Union | N/A
Number of Votes Against Union | N/A
Strikes & Work Stoppages | Last Five Years
Number | 0
Average Duration | N/A
Strikes by Company | Last Five Years Including 50 or More Employees
Company Name | N/A
Union Involved | N/A
Number of Striking Workers | 0
Duration of Strike | N/A
Strike Called by National or Local Union | N/A
Ankeny is a community in the Des Moines Metropolitan area.  Access metrowide Labor Management information.
Sources:
Iowa Workforce Development
www.unionstats.com
Spreadsheet: 216122d1361599203-help-with-match-and-offset-funcitions-together-example1
Sheet: List all

City | Name 1 | Age | $
City 1 | Name 1 | 25 | 100
City 3 | Name 2 | 30 | 50
City 3 | Name 3 | 22 | 200
City 2 | Name 4 | 19 | 300
City 5 | Name 5 | 24 | 500
City 1 | Name 6 | 41 | 101
City 7 | Name 7 | 90 | 51
City 2 | Name 8 | 26 | 201
City 9 | Name 9 | 31 | 301
City 5 | Name 10 | 23 | 501
City 11 | Name 11 | 20 | 102
City 12 | Name 12 | 25 | 52
City 6 | Name 13 | 42 | 202
City 14 | Name 14 | 91 | 302
City 1 | Name 15 | 27 | 502
City 6 | Name 16 | 32 | 103
City 17 | Name 17 | 24 | 53
City 18 | Name 18 | 21 | 203
City 10 | Name 19 | 26 | 303
Spreadsheet: 41909d1240451916-working-with-large-list-of-company-names-need-a-bar-chart-perhaps
Sheet: Sheet2

unique names | total
alpha medium group | 3
Alpha Square LLC | 3
Alpine | 3
AlpineSoft | 3
Alsdorf | 3
Altera | 3
altibase | 3
AMD | 3
AMD India | 3
AMD Japan | 3
amf | 3
AMI | 3
AMnesty | 3
Amphora | 3
amsah | 3
AMST | 3
Anatomical Travelogue | 3
Anita Grant Ltd | 3
anonym | 3
Anonymous | 3
Ansys Fluent India Pvt Ltd | 3
Applanix | 3
apple | 2
Apple Inc. | 3
Applied Acoustics Systems DVM Inc. | 3
Applied Materials | 4
Apprender | 4
apstudio | 4
 | 0
 | 0
 | 0
Spreadsheet: 107537d1304680295-excel-2007-need-a-udf-for-the-following-conditions-book1_kailashramu
Sheet: Sheet1

Name | Maths | Physics | Chemistry | Total |  | Total Ranking | Maths | Eliminator Rank | Physics | Eliminator Rank | Chemistry | Eliminator Rank
Sugan | 196 | 174 | 199 | 569 |  | 1 | 196 | 1 | 174 | 1 | 199 | 1
Raghu | 196 | 175 | 156 | 527 |  | 5
Ashok | 168 | 165 | 192 | 525 |  | 6
Karthik | 196 | 186 | 185 | 567 |  | 2
Kailash | 195 | 197 | 175 | 567 |  | 2
Chitraa | 196 | 188 | 183 | 567 |  | 2