tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116444d1311844172-how-to-autopopulate-cells-based-on-values-from-other-cells-training-compilation2-1-1-
Sheet: Final Form

Department | Competency | Competency Definition | Type of Training | Training | Objective | Provider
LQA | Quality Improvement | Ability to maintain and improve the plant's quality management system  through internal quality audit, deviation management and change control to comply with GMP and meet regulatory requirements | External | Strategic Systems Thinking: Creating Competetive Advantage
 |  |  |  | Business Process Management (Re-engineering vs. Re-designing) | Note: Array formula is used and should be confirmed through Ctrl+Shift+Enter
 |  |  |  | A Journey Towards Sustainability Management Thru ISO 9004:2009
 |  |  |  | Process Management Excellence Improvement Techniques
 |  |  |  | Driving Growth through Innovation
 |  |  |  | Startegic Thinking and [NAME]
 |  |  |  | Managing Continual Improvement
 |  |  |  | Change Management
 |  |  |  | Management of Planned Change
 |  |  |  | Six Thinking Hats
 |  |  |  | Combined Quality Control and Quality Assurance Course
 |  |  |  | Introduction to Innovative  and Creative Circles
 |  |  |  | IMS Risk Management
 |  |  |  | Effective Skills for Audit Reporting
 |  |  |  | Quality Management System
 |  |  |  | Advanced QMS Auditor Training
 |  |  |  | IMS Internal Audit (Based on PAS 99)
 |  |  |  | Internal Quality Audit
 |  |  |  | Quality Management Systems Auditor / Lead Auditor Training Course
 |  |  |  | Quality Excellence Thru Layered Process Audits (LPA)
Spreadsheet: 94385d1294228903-formula-for-interest-rates-cashflow-trialv2
Sheet: Sheet1

Cashflow
 |  | Interest Rate |  | 0.5471339348775004 |  |  | [NAME] |  | Sep | 9
 |  | Starting Balance |  | 700 |  |  | Loan Amount |  | 1000
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Income
Expenditure
Bank Balance | 700 | 731.9161462011875 | 765.2874929571402 | 800.180389401655 | 836.6642098237498 | 874.8114915980867 | 914.6980794042631 | 956.4032760217087 | 0.009999999999536158 | 0.01045594494524626 | 0.01093267847030919 | 0.01143114841949342
 | I want to try and work out what the lowest interest rate is in order for the bank balance to remain positive after it pays the loan
 | I have just used trial and error until the line is above zero
 | Is there anyway in which the interest rate is calculated in order to prevent negative bank balance
 | Without causing a circular reference
 | i.e. If I change any of the other cells that have a border it will calculate the interest rate needed to make the bank balance as close to negative as possible without going negative after the loan is paid off
 | Beyond me! I cant work it out. Thanks for looking at this, it is much appreciated.
 | Please bear in mind that the spreadsheet I am doing this on contains many more rows which adds to the complication!!!!!
 | Thanks!!!!!!!!
Spreadsheet: 763328d1642103698-build-a-continuous-column-val-sku-store-lists
Sheet: Sheet1

Input |  |  |  |  | Ideal Output
Stores |  | Items |  |  | Stores | Item
1 |  | A |  |  | 1 | A
2 |  | B |  |  | 1 | B
3 |  | C |  |  | 1 | C
4 |  |  |  |  | 2 | A
 |  |  |  |  | 2 | B
 |  |  |  |  | 2 | C
 |  |  |  |  | 3 | A
 |  |  |  |  | 3 | B
 |  |  |  |  | 3 | C
 |  |  |  |  | 4 | A
 |  |  |  |  | 4 | B
 |  |  |  |  | 4 | C
Spreadsheet: 781031d1652951070-convert-exchange-rate-formula-on-old-spreadsheet-to-work-on-new-old-front-cover
Sheet: Costings

Invoice Nr: |  |  |  |  |  |  |  |  |  |  |  |  | EXCHANGE RATES FOR COSTS
 |  |  |  |  |  |  |  |  |  |  |  |  | From/To | EUR | GBP | USD
Invoice status: |  |  |  |  |  |  |  |  |  |  |  |  | EUR | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | GBP | 1.XX | 1 | 1.XX
COSTS |  |  |  |  |  |  |  |  |  |  |  |  | USD |  |  | 1
Agents Charges:
 | Item |  |  | Quantity | Currency | Rate | Total | Invoice Currency | Converted Rate | Converted Total | GBP Total
 | Costs 25 Jan / 1 Feb |  |  | 1 | GBP | 164.36 |  | GBP
 | TOTAL INVOICED
Analysis Charges:
 | Item |  |  | Quantity | Currency | Rate | Total | Invoice Currency | Converted Rate | Converted Total | GBP Total
 | [NAME] 1 |  |  | 2 | GBP | 19 |  | GBP
 | TOTAL INVOICED
Other Charges:
 | Item |  |  | Quantity | Currency | Rate | Total | Invoice Currency | Converted Rate | Converted Total | GBP Total
 | TOTAL INVOICED
TOTAL COSTS
CHARGES
Supervision Charges:
 | Item |  |  | Quantity (mt) | Currency | Rate | Total | Invoice Currency | Converted Rate | Converted Total | GBP Total |  | EXCHANGE RATES FOR CHARGES
 |  |  |  |  |  |  |  |  |  |  |  |  | From/To | EUR | GBP | USD
 |  |  |  |  |  |  |  |  |  |  |  |  | EUR | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | GBP | 1.XX | 1 | 1.XX
 |  |  |  |  |  |  |  |  |  |  |  |  | USD |  |  | 1
 | TOTAL FOR INVOICE
Analysis Charges:
 | Item |  |  | Quantity | Currency | Rate | Total | Invoice Currency | Converted Rate | Converted Total | GBP Total
 | TOTAL INVOICED
Other Charges:
 | Item |  |  | Quantity | Currency | Rate | Total | Invoice Currency | Converted Rate | Converted Total | GBP Total
 | TOTAL INVOICED
TOTAL CHARGES
Spreadsheet: 768444d1644964618-minimum-average-percentage-needed-to-meet-month-end-expectation-with-range-constraints-example
Sheet: Sheet1

Agent: | Donner
Report Period: | 01/01/2022-01/31/2022
MTD QA Average
# of Calls pulled
QA Scores |  |  | Average needed to pass
#1 |  |  | ?
#2
#3
#4
#5
#6
#7
#8
#9
#10
Spreadsheet: 8c31be87-1033-44d0-9169-1cf0a31171eb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | LỊCH CÔNG TÁC KHOA | Unnamed: 4 | Unnamed: 5
 |  |  | TUẦN 13 (28/11 -04/12/2011)
Thứ, ngày | Giờ | Nội dung công việc | Cán bộ  chủ trì | Cán bộ cùng thực hiện/ cùng tham dự | [NAME] điểm
Thứ Hai 28/11 | 7h00 | Dẫn sv đi tham quan thực tế | [NAME] |  | [NAME]
 | 8h00 | Họp giao ban [NAME] | T. Hưng | CB - GV - NV Khoa | VPK
 | 9h30 | Họp Chi bộ 2 | [NAME] | [NAME] viên [NAME] bộ 2 | PH1
[NAME] 29/11
Thứ Tư 30/11 | 9h30 | Làm việc với Lãnh đạo Nhà trường về công tác Quản lý Đào tạo ĐH, CĐ năm học 2011 - 2012 | [NAME] | T. Hưng, T. Nam, [NAME] | VPK
[NAME]
Thứ Sáu 02/12
Thứ Bảy 03/12
 | 15h00 | Hướng dẫn sinh viên khóa 09, 10 ngành môi trường đăng [NAME] phần [NAME] 2 | T. Nam | T. Sơn | HT1 L6
[NAME]
Ghi chú: |  |  |  | TP. HCM, ngày 26 tháng 11 năm 2011
 |  |  |  | [NAME]
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 10

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-10 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1546 |  | 1461 |  | 67694 |  |  |  |  |  |  | 18 | 1 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 2 | 24
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 13939 |  | 12158 |  | 67694 |  |  |  |  |  |  | 19 | 3 | 23
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 20 | 4 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 5 | 25
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 3782 |  | 3290 |  | 67694 |  |  |  |  |  |  | 21 | 6 | 23
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 19 | 7 | 23
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 24 | 8 | 26
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 24 | 9 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 15 | 30
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 25407 |  | 22882 |  | 67694 |  |  |  |  |  |  | 23 | 35 | 25
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 20 | 39 | 23
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 3006 |  | 2621 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 2367 |  | 2137 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 20788 |  | 19597 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4669 |  | 4458 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4555 |  | 4327 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 6157 |  | 5876 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1762 |  | 1610 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 49 |  | 46 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20606 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20500 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 122540d1316933643-rank-by-certain-criteria-book1
Sheet: Sheet1

Name | Value | Territory | Rank
Person 1 | 200 | 201
Person 2 | 350 | 202
Person 3 | 100 | 202
Person 4 | 20 | 201
Person 5 | 504 | 201
Person 6 | 200 | 203
Person 7 | 188 | 203
Person 8 | 940 | 204
Person 9 | 220 | 202
Person 10 | 300 | 202
Person 11 | 150 | 204
Person 12 | 180 | 203
Person 13 | 95 | 201
Person 14 | 760 | 205
Person 15 | 430 | 205
Spreadsheet: 116049d1311535383-matching-one-or-more-combinations-of-strings-and-returning-row-data-sample
Sheet: Sheet1

Assignees | Task | Deadline
[NAME], [NAME], [NAME] | Task 1 | 2012-01-05 00:00:00
[NAME], [NAME], [NAME] | Task 2 | 2011-10-04 00:00:00
[NAME], [NAME] | Task 3 | 2011-08-18 00:00:00
[NAME], [NAME], [NAME] | Task 4 | 2011-07-17 00:00:00
[NAME], [NAME] | Task 5 | 2011-09-24 00:00:00
[NAME], [NAME], [NAME] | Task 6 | 2012-03-03 00:00:00
[NAME], [NAME] | Task 7 | 2012-01-05 00:00:00
[NAME], [NAME], [NAME] | Task 8 | 2011-10-04 00:00:00
[NAME], [NAME] | Task 9 | 2011-08-18 00:00:00
[NAME], [NAME] | Task 10 | 2011-07-17 00:00:00
Spreadsheet: 705862d1606337821-if-formula-with-limiting-choices-ef1417_gv-south-phase-1-worksheet
Sheet: Models

Models # | [NAME] | Base $ |  |  |  |  |  |  | Models
 |  |  |  |  |  |  |  |  | Country Meadow Villa 2 bed | B1L65 | B1L66 | B1l69 | B1L70
A1 | Country Meadow Villa 2 bed | 272500 |  | Finish |  |  |  |  | Urban Modern 2 bed | [NAME] | B3L9 | [NAME] | B4L15
A2-2 | Urban Modern 2 bed | 298500 |  | Yes | 32000 |  |  |  | Urban Modern 3 bed | [NAME] | B3L9 | [NAME] | B4L15
A2-3 | Urban Modern 3 bed | 311900 |  | No | 0 |  |  |  | Farmington - 2 bed | B1L65 | B1L66 | B1l69 | B1L70 | B3L9 | [NAME] | B4L15
A3-2 | Farmington - 2 bed | 289000 |  |  |  |  |  |  | Farmington - 3 bed | B1L65 | B1L66 | B1l69 | B1L70 | B3L9 | [NAME] | B4L15
A3-3 | Farmington - 3 bed | 314900 |  | 3rd Stall |  |  |  |  | Garden Beauty - 3 bed | B3L6 | B3L7 | [NAME] | B3L9 | B4L1 | [NAME] | B4L15 | B4L64 | B4L67 | B4L68
A6 | Garden Beauty - 3 bed | 314900 |  | Yes | 24000 |  |  |  | City Scape Ranch - 2 bed | B3L6 | B3L7 | [NAME] | B3L9 | B4L1 | [NAME] | B4L15 | B4L64 | B4L67 | B4L68
A7 | City Scape Ranch - 2 bed | 314900 |  | No | 0 |  |  |  | Live Well Ranch - 2 bed | B3L6 | B3L7 | B4L1 | B4L64 | B4L67 | B4L68
A8 | Live Well Ranch - 2 bed | 388000 |  |  |  |  | 0
 |  |  |  | Fireplace |  |  | 1
 | Basement |  |  | Yes |  |  | 2
 | Yes | 19000 |  | No |  |  | 3
 | No | 0 |  |  |  |  | 4
Lots |  |  |  | Fireplace Type |  |  | 5
 | Phase 1 Lots |  |  | None | 0 |  | 6
Flat | B3L7 | 0 |  | Gas W/Wood Mantle/Tile | 12860 |  | 7
Flat | [NAME] | 0 |  | Add for Stone Surround | 2680 |  | 8
Flat | [NAME] | 0 |  | Add for Stone Hearth | 2680 |  | 9
Flat | B4L15 | 0 |  | Electric Fireplace W/Tile | 6460 |  | 10
Flat | [NAME] | 0
Daylight | B3L6 | 9500 |  | Add Wood Steps to Deck
Daylight | B3L9 | 9500 |  | Yes | 2380
Daylight | B4L1 | 9500 |  | No
Daylight | B1L67 | 16000 |  | Add Cable or Phone
Daylight | [NAME] | 12500 |  | Yes | 55
Daylight | B1L69 | 12500 |  | No
Daylight | B1L70 | 12500
Walkout | B1L64 | 27000 |  | Additional Disc Lights | 68
Walkout | B1L65 | 24000 |  | Additional 110V Outlets | 65
Walkout | B1L66 | 20000
 |  |  |  | None | 0
 |  |  |  | Smart Home Bronze | 1968
 |  |  |  | Smart Home Silver | 3340
 |  |  |  | Smart Home Gold | 4930
Spreadsheet: 125752d1319209396-listing-by-status-list-down-by-status
Sheet: Sheet1

Name | Age | Status | Date Hired
[NAME] | 24 | Probationary | 2010-09-24 00:00:00 |  |  | Probationary
[NAME] | 25 | Regular | 2009-08-26 00:00:00 |  |  | Regular
[NAME] | 26 | Regular | 2008-09-17 00:00:00
[NAME] | 23 | Probationary | 2010-10-27 00:00:00
[NAME] | 25 | Regular | 2008-07-20 00:00:00
 |  |  |  |  |  | Probationary Employee | Date Hired | Regularization Date
 |  |  |  |  |  | [NAME] | 2010-09-24 00:00:00
 |  |  |  |  |  | [NAME] | 2010-10-27 00:00:00
 |  |  |  |  |  | * A formula that can list down the names of the employees with Probationary status on the 1st column of this table | * I think VLOOKUP would work for this column once the name is displayed on the 1st column but if there's a better formula please tell me. | *this column would be manually entered
 |  |  | Select Status |  |  | Probationary Employee | Date Hired | Regularization Date
 |  |  | Probationary |  |  | [NAME] | 2010-09-24 00:00:00
 |  |  |  |  |  | [NAME] | 2010-10-27 00:00:00
Spreadsheet: 160822d1339223817-highlight-blank-cells-using-conditional-formatting-1
Sheet: Sheet1

 | X |  |  |  | = | continuous blanks for more than 7 times
 |  | X
 |  | X
X
 |  | X
 |  | X
X
X
X
X
X
 |  | X
 |  | X
 |  | X
 |  | X
X
 | X
 | X
 | X
 | X
 |  | X
 |  | X
 | X
X
 |  | X
 | X
Spreadsheet: 9964f045-90bf-4d55-b6f2-f92a496c3264
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Telefast AS | [NAME] | 3239 | Sandefjord | 33 48 22 60 | 33 48 22 61
Telenordic AS | [NAME] | 3239 | Sandefjord
Guard Systems AS | [NAME] | 3241 | Sandefjord | 33 48 28 00 | 33 48 28 01
Cablecom AS | [NAME] | 3241 | Sandefjord
Timetech | Agnes Vei 8 | 3244 | Sandefjord
[NAME] | Aagaards Plass 2 | 3211 | Sandefjord | 33 48 46 46 | 33 48 46 40
Bakke Kristian Elektronikk As | Vesterøyveien 2 | 3235 | Sandefjord | 33 48 33 60 | 33 48 33 70
Sandefjord Bredbånd KF | [NAME] 12 | 3217 | Sandefjord | 33 41 69 50 | 33 41 69 51
Viking Finance AS | [NAME] | 3241 | Sandefjord
Gsm Telecom Products AS | Østerliveien 4A | 3219 | Sandefjord
[NAME] | Hansåsen 9 | 3230 | Sandefjord
[NAME] | Strandg 4 | 3210 | Sandefjord | 33 46 14 40
Media Import R Liverød | Dåpaløkka 52 | 3231 | Sandefjord
Viking Finance AS Konkursbo | [NAME] | 3241 | Sandefjord
Tel-It Telekommunikasjon It Service [NAME] | Bøskogen 20 | 3242 | Sandefjord | 33 48 19 40 | 33 48 19 43
[NAME] | Sjøstrand 6 | 3209 | Sandefjord
Quizzee Norge Espen Jørgensen | Myggveien 9 | 3218 | Sandefjord
Royal Satellitt System ANS | Dølabakken 20 | 3215 | Sandefjord
Kval Consultancy Services Ltd | Myreskauen 10 | 3218 | Sandefjord
Sentor AS | [NAME] 16 | 3209 | Sandefjord
Telefonbutikken Invest AS | [NAME] 16 | 3208 | Sandefjord | 33 48 19 92 | 33 48 19 93
Sign Communication Norway AS | Bekkeveien 9 | 3226 | Sandefjord | 33 42 17 00 | 33 42 17 01
Bestmobile AS | [NAME] | 3217 | Sandefjord | 918 69 715
[NAME] | Kilgata 16 | 3217 | Sandefjord
[NAME] | Torget 7 | 3210 | Sandefjord | 480 00 200 | 947 65 379
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 0fefc500-61e2-4cea-8299-f4eb25554394
Sheet: Sheet1

Federal Elected Officials | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
US House of Representatives
NAME | Leg. [NAME]) | Dist. Address | Capitol Address | City | Zip | Phone
Dr. [NAME] |  |  | 419 Cannon HOB | Washington, DC | 20515 | (202) 225-6356
 | [NAME] | PO Box 1728 |  | Kingsport | 37662 | (423) 247-8161
 | [NAME]
US Senate
NAME | Leg. [NAME]) | Dist. Address | Capitol Address | City | Zip | Phone
[NAME] |  |  | 55 Dirksen Senate Office Building | Washington, DC | 20510 | (202) 224-4944
 | [NAME] | Terminal Building, #101 |  | Blountville | 37617 | (423) 325-6240
 |  | Tri-Cities Regional Airport
 |  | 2525 Highway 75
 |  | [NAME]
[NAME] |  |  | [NAME], SD-185 | Washington, DC | 20510 | (202) 224-3344
 | [NAME] | Tri-Cities Regional Airport |  | Blountville | 37617 | (423)323-1252
 |  | 2525 Hwy. 75, Ste. 126
Spreadsheet: 456450d1460871445-sumproduct-with-range-increment-sample-17042016
Sheet: Sheet1

 |  | Feb'16
 |  | Our | IND | % SoW
 | 1 | 0.005 | 0.018 | 0.2777777777777777
 | 2 | 0.151 | 1.51 | 0.09999999999999999
 | 3 | 0 | 0.343 | 0
 | 4 | 0 | 0 | 0
 | 5 | 0 | 7.71 | 0
 | Cell No. | [NAME] used for our column
 | C5 | SUMPRODUCT(('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$L$4:$L$3334)*('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$A$4:$A$3334=$A$1))/100
 | C6 | SUMPRODUCT(('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$O$4:$O$3334)*('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$A$4:$A$3334=$A$1))/100
 | C7 | SUMPRODUCT(('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$R$4:$R$3334)*('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$A$4:$A$3334=$A$1))/100
 |  | [NAME] used for Ind column
 | D5 | SUMPRODUCT(('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$M$4:$M$3334)*('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$A$4:$A$3334=$A$1))/100
 | D6 | SUMPRODUCT(('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$P$4:$P$3334)*('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$A$4:$A$3334=$A$1))/100
 | D7 | SUMPRODUCT(('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$S$4:$S$3334)*('[Distributor Data-February 2016-RoMG.xls]GS Feb 16'!$A$4:$A$3334=$A$1))/100
 |  | Query
 | 1 | Whether there is any way to [NAME] formula in only Cell No. C5 ($L$4:$L$3334) ( i.e. [NAME] used for our column indicated at sr.no. 1 above)
 |  | and
 | 2 | Cell D 5 to have a formula with range incremental by one column i.e. in this case $M$4:$M$3334
 | 3 | Cell C 6 - Formula to have range by skipping (N), i.e. Range $[NAME]
 | 4 | Cell D 6 - Formula to have range $P$4:$p$3334
 |  | and so on
Spreadsheet: 201523d1356019570-autofill-every-3rd-cell-in-a-column-sample2
Sheet: Sheet1

 | Dimensional Inspection Report
 | Part Number:
 | Date:
 | Feature Description:
 | Target Dimension: | 0.123
 | Tolerance Minimum: | 0.122
 | Tolerance Maximum: | 0.124
 | Check Interval:
Gauge Block: | 0.0000" | 0.1250" | 0.2500"
Calibrated: | -0.0001 | 0.1249 | 0.2501
 | Point 1 | Point 2 | Point 3 |  | Range |  | 3pc Average
Part 1 | 0.1239 | 0.1264 | 0.1292 |  | 0.0053
Part 2 | 0.1256 | 0.1239 | 0.1245 |  | 0.0017
Part 3 | 0.1246 | 0.1246 | 0.1246 |  | 0
Part 4 | 0.124 | 0.1239 | 0.1239 |  | 0.0001
Part 5 | 0.1242 | 0.1246 | 0.1256 |  | 0.0014
Part 6 | 0.1268 | 0.1263 | 0.1245 |  | 0.0023
Part 7 | 0.1249 | 0.1255 | 0.1252 |  | 0.0006
Part 8 | 0.1238 | 0.1238 | 0.1238 |  | 0
Part 9 | 0.1238 | 0.1241 | 0.1242 |  | 0.0004
Part 10 | 0.1251 | 0.1244 | 0.1244 |  | 0.0007
Part 11 | 0.1245 | 0.1251 | 0.1244 |  | 0.0007
Part 12 | 0.1245 | 0.1239 | 0.1239 |  | 0.0006
Part 13 | 0.1239 | 0.1239 | 0.1242 |  | 0.0003
Part 14 | 0.1244 | 0.1255 | 0.1256 |  | 0.0012
Part 15 | 0.1278 | 0.1274 | 0.1264 |  | 0.0014
Part 16 | 0.1249 | 0.124 | 0.1239 |  | 0.001
Part 17 | 0.1239 | 0.1239 | 0.1239 |  | 0
Part 18 | 0.1239 | 0.1239 | 0.1239 |  | 0
Spreadsheet: tracy_geaccone__40453__Carryover from 2000
Sheet: Carry Over

2000 Year End Items Carried Into 2001
Items not included in Plan
(In Millions)
NNG
Deferral of Gain on Cooper Inventory Sale |  |  |  |  |  | ? | Up to 4.5
Prepayment of Mobil |  |  |  |  |  | 1.5
Reserse SAP Reserve |  |  |  |  |  | 1.1
Reverse DOT User Fees paid in December |  |  |  |  |  | 1.3
Reverse Property Tax Accrual Adjustment |  |  |  |  |  | 0.3
W/O of Base Gas Arrangement Fees in 2000 |  |  |  |  |  | 0.2
Quarterly Capitalization of Specialized Overheads |  |  |  |  |  | 0.7
 | Total |  |  |  |  |  | +  Cooper Gain Deferral up to 4.5
TW
Reverse SAP Reserve |  |  |  |  |  | 0.3
Reverse DOT User Fees |  |  |  |  |  | 0.2
Reverse Property Tax Accrual Adjustment |  |  |  |  |  | 0.1
Quarterly Capitalization of Specialized Overheads |  |  |  |  |  | 0.1
 | Total
Spreadsheet: kate_symes__18216__Deal Correction 3-14
Sheet:  Current Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2001-03-14 00:00:00 | 2001-03-14 00:00:00 | 2001-03-09 00:00:00 | STNW | DS | Houston | N/A | Added missing prices |  | 542602 | PGE System | 3/11-3/12 | RTC | Shaped | 265 | Pacificorp
 |  |  | Grand Count
Spreadsheet: 722806d1615412729-formula-to-calculate-pricing-with-graduated-cumulative-tier-pricing-cumulative-tier-pricing-sample
Sheet: Sheet1

Formed AI Tiers
Band | Upper Limit | Annual Cost | Quantity | Total Price for the tier
1-50 | 50 | 100 | 25
51-250 | 250 | 50 | 75
251+ |  | 25 | 100
Total Users | Calculator
250
Manually Calculated Fields
 |  | Total Annual Cost
100 Users
250 Users
330 Users
Spreadsheet: 760354d1640170737-attendance-and-duty-time-tracker-example-duty-time
Sheet: Attendance

Attendance - Updated 12/21/21
Name | Emp # | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
[NAME] | ****** | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 4 | 1st Verbal
[NAME] | ****** | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 1 |  |  |  | 5 | 2nd Verbal
Todd | ****** | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 2 |  |  |  | 6 | Written Advisory
[NAME] | ****** | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  | 7 | Final Advisory
[NAME] | ****** | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  |  | 8 | Termination