tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 858868d1707379659-iferror-if-and-lookup-automated-v9-copy
Sheet: Sheet1

Name & Surname:
 |  | Credits | Status | Remark
CHEM181 | Chemistry for Engineers 1A | 8
ENCH1TC | Technical Communication for Engineers | 8
ENME1DR | Engineering Drawing | 8
MATH131 | Mathematics 1A (Eng) | 16 |  |  |  | Why is this returning Fail?
MATH132 | Applied Mathematics 1A (Eng) | 16
PHYS151 | Engineering Physics 1A | 16 |  |  |  | Student failed, repeated and didn't pass yet. So this is fine
ENCV1WP | Engineering Workshop | DP |  |  |  | Student has not studied this module; So this is fine)
Spreadsheet: 460184d1462978717-filter-not-group-nop-cham-2015-ver-16
Sheet: Bb

 |  |  |  |  | Mẫu số : 01/BB
CỤC THUẾ TỈNH BÀ RỊA - VŨNG TÀU |  |  |  |  | CỘNG HÒA XÃ HỘI CHỦ NGHĨA VIỆT NAM
CHI CỤC THUẾ HUYỆN LONG ĐIỀN |  |  |  |  | Độc lập- Tự do- Hạnh phúc
 |  |  |  |  | Long Điền, ngày      tháng      năm 2016
BIÊN BẢN VI PHẠM HÀNH CHÍNH VỀ THUẾ
( đối với NNT nộp HSKT qua giao dịch điện tử )
 | 1. Bà [NAME], [NAME] trưởng [NAME] [NAME] thuế & tin học.
 | 2. Bà [NAME], [NAME] tra viên [NAME] thuế - Đội Kê [NAME] thuế & tin học.
 |  |  |  |  |  |  |  |  |  |  |  |  | 2016-03-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
 | Đã có các hành vi vi phạm hành chính về thuế: Chậm nộp hồ sơ khai thuế.
Stt | Loại hồ sơ |  | Ký hiệu [NAME] sơ khai thuế |  |  | Kỳ tính thuế | Hạn nộp | Ngày nộp | Số ngày quá hạn |  |  |  |  | GTGT | Kỳ |  |  |  |  | Thời hạn
x
Căn cứ Thông tư 156/2013/TT-BTC ngày 06/11/2013 của Bộ Tài chính hướng dẫn thi [NAME] điều của [NAME] thuế; [NAME] sửa đổi bổ sung [NAME] điều của [NAME] thuế và Nghị định số 83/2013/NĐ-CP ngày 22/7/2013 của Chính phủ
"Điều 10. [NAME] [NAME] thuế
 | 3. Thời hạn nộp hồ sơ khai thuế
 | ….."
Căn cứ Nghị định 129/2013/NĐ-CP ngày 16/10/2013 của Chính phủ [NAME] về xử phạt vi phạm hành chính vể thuế và cưỡng chế thi hành quyết định hành chính thuế
"Điều 7. Xử phạt đối với hành vi chậm nộp hồ sơ khai thuế so với thời hạn quy định
 | …….….."
Căn cứ Thông tư 166/2013/TT-BTC ngày 15/11/2013 của [NAME] [NAME] thuế
 | -Tại điểm d Khoản 5 Điều 2 [NAME]:
 | "Điều 2. Nguyên tắc xử phạt vi phạm hành chính về thuế
 | 5. Một hành vi vi phạm hành chính về thuế chỉ bị xử [NAME] lần, cụ thể:
d) Một người thực hiện nhiều hành vi vi phạm hành chính về thuế hoặc vi phạm hành chính về thuế nhiều lần thì bị xử phạt về từng hành vi vi phạm.
Trường hợp trong cùng [NAME] điểm người nộp thuế chậm nộp nhiều hồ sơ khai thuế của nhiều loại thuế [NAME] thì người nộp thuế bị xử phạt về từng hành vi chậm nộp hồ sơ khai thuế đối với từng sắc thuế.
Trường hợp, cùng [NAME] điểm người nộp thuế chậm nộp nhiều hồ sơ khai thuế của nhiều kỳ tính thuế nhưng cùng một sắc thuế thì: hành vi chậm nộp hồ sơ khai thuế [NAME] xử phạt về thủ tục thuế chỉ bị xử phạt về [NAME] thuế với tình tiết tăng nặng vi phạm nhiều lần; [NAME] có hồ sơ khai thuế chậm nộp quá 90 ngày thuộc [NAME] hành vi trốn thuế thì bị xử phạt về hành vi trốn thuế [NAME] tại Điều 13 Thông tư này"
Tài liệu kèm theo dữ liệu tra cứu trên trang thông tin điện tử http://nhantokhai.tct.vn;
NGƯỜI ĐẠI [NAME] |  |  |  |  | ĐẠI DIỆN CƠ QUAN THUẾ
TỔ CHỨC VI PHẠM |  |  |  | NGƯỜI LẬP |  |  | ĐỘI TRƯỞNG
([NAME], đóng [NAME] ghi rõ họ tên) |  |  |  | [NAME] |  |  | [NAME]
NNT nộp HSKT qua giao
dịch điện tử
Spreadsheet: 876801d1723527048-show-duplicates-across-multiple-worksheets-and-include-other-selected-data-duplicates
Sheet: serial

Serial numbers | data 1 | data 2 | data 3
1234
123
92098
92069
99800
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: JigBoring

Detail No. | Quantity | Set up Datum Clocking | [NAME] | Milling | Drilling | Reaming | Boring | Set up Equipment | Inspection | Loading | Subplate Removal/Refit | Clean Down | Other | Total Time (hours) | NOTES
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
. |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0
Setting
Rotary Table
Angle Plate
Sine Table
Vice
[NAME]
Handling
Tooling
Spreadsheet: 85337d1285350562-counting-increases-and-decreases-across-rows-ex1
Sheet: Sheet1

ela2009 | ela2010 |  | math2009 | [NAME] |  |  | scored "5" in ela2009 and stayed the same in ela from '09 to '10: | scored "5" in ela2009 and decreased in ela from '09 to '10: |  |  | scored "5" in math2009 and stayed the same in math from '09 to '10: | scored "5" in math2009 and decreased in math from '09 to '10:
1 | 3 |  | 2 | 1
1 |  |  |  | 1 |  | scored "4" in ela2009 and increased in ela from '09 to '10: | scored "4" in ela2009 and stayed the same in ela from '09 to '10: | scored "4" in ela2009 and decreased in ela from '09 to '10: |  | scored "4" in math2009 and increased in math from '09 to '10: | scored "4" in math2009 and stayed the same in math from '09 to '10: | scored "4" in math2009 and decreased in math from '09 to '10:
1 |  |  |  | 1
2 | 2 |  | 1 | 1
2 | 2 |  | 1 | 2
2 | 3 |  |  | 4
2 |  |  |  | 1 |  | scored "3" in ela2009 and increased in ela from '09 to '10: | scored "3" in ela2009 and stayed the same in ela from '09 to '10: | scored "3" in ela2009 and decreased in ela from '09 to '10: |  | scored "3" in math2009 and increased in ela from '09 to '10: | scored "3" in math2009 and stayed the same in math from '09 to '10: | scored "3" in math2009 and decreased in math from '09 to '10:
2 |  |  |  | 1
2 |  |  |  | 2
3 | 1 |  | 2 | 4
3 | 2 |  | 1 | 3
3 | 2 |  | 2 | 1 |  | scored "2" in ela2009 and increased in ela from '09 to '10: | scored "2" in ela2009 and stayed the same in ela from '09 to '10: | scored "2" in ela2009 and decreased in ela from '09 to '10: | scored "2" in ela2009 and increased at least 2 points in ela from '09 to '10 | scored "2" in math2009 and increased in math from '09 to '10: | scored "2" in math2009 and stayed the same in math from '09 to '10: | scored "2" in math2009 and decreased in math from '09 to '10: | scored "2" in math2009 and increased at least 2 points in math from '09 to '10
3 | 2 |  | 2 | 1
3 | 2 |  | 2 | 2
3 | 2 |  | 2 | 2
3 | 2 |  | 2 | 3
3 | 2 |  | 4 | 4
3 | 3 |  | 2 | 3
3 | 3 |  | 2 | 3
3 | 3 |  | 3 | 1
3 | 3 |  | 3 | 2
3 | 3 |  | 3 | 3
3 | 3 |  | 3 | 3
3 | 3 |  | 3 | 3
3 | 3 |  | 3 | 4
3 | 3 |  | 4 | 2
3 | 3 |  | 4 | 2
3 | 3 |  |  | 2
3 | 3 |  |  | 4
3 | 3
3 | 4 |  | 2 | 3
3 |  |  |  | 2
3 |  |  |  | 2
3 |  |  |  | 2
3 |  |  |  | 2
3 |  |  |  | 2
3 |  |  |  | 2
4 | 2 |  | 1 | 2
4 | 2 |  | 4 | 2
4 | 3 |  | 1 | 3
4 | 3 |  | 3 | 3
4 | 3 |  | 3 | 3
4 | 3 |  | 3 | 3
4 | 3 |  | 3 | 3
4 | 3 |  | 3 | 3
4 | 3 |  | 3 | 3
4 | 3 |  | 3 | 4
4 | 4 |  | 2 | 1
4 | 4 |  | 2 | 2
4 | 4 |  | 2 | 3
4 | 4 |  | 3 | 3
4 | 4 |  | 3 | 4
4 | 4 |  | 4 | 2
4 | 4 |  | 4 | 2
4 | 4 |  | 4 | 3
4 | 4 |  |  | 2
4 | 5 |  | 5 | 4
4 |  |  |  | 2
4 |  |  |  | 2
4 |  |  |  | 3
4 |  |  |  | 3
4 |  |  |  | 4
4 |  |  |  | 4
4 |  |  |  | 4
5 | 5 |  | 3 | 3
5 | 5 |  | 4 | 3
5 | 5 |  | 4 | 4
5 | 5 |  | 4 | 4
5 | 5 |  | 4 | 4
5 | 5 |  | 4 | 4
5 | 5 |  | 5 | 5
5 |  |  |  | 4
5 |  |  |  | 4
5 |  |  |  | 5
5
 | 3 |  | 2
 | 3 |  | 2
 | 5 |  | 4
 | 5 |  | 5
Spreadsheet: 752552d1634825149-copy-data-based-on-value-to-each-sheet-pay
Sheet: Data

Local | Name | SSN | ST | OT
7 | [NAME] | 123-45-6789 | 40 | 38
7 | [NAME] | 234-56-7890 | 48 | 20
8 | [NAME] | 345-67-8901 | 40 | 21
10 | [NAME] | 456-78-9012 | 16 | 8
7 | [NAME] | 567-89-0123 | 32 | 28
8 | [NAME] | 678-90-1234 | 40 | 10
Spreadsheet: 07daab98-fd55-4613-b306-14a4e719ba2b
Sheet: Sheet1

Murder and Nonnegligent Manslaughter and Aggravated Assault | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Offense Type
by Circumstance, 20111
Circumstance | Total Victims | Offense Type
 |  | Murder and Nonnegligent  Manslaughter | Aggravated Assault
Argument | 99526 | 801 | 98725
Assault on Law Enforcement Officer | 5116 | 27 | 5089
Drug Dealing | 1091 | 108 | 983
Gangland Killing (Organized Crime) | 1193 | 31 | 1162
[NAME] (Street Gang) | 584 | 1 | 583
Lovers' Quarrel | 10687 | 128 | 10559
Mercy Killing2 | 4 | 4
Other Felony Involved | 2355 | 125 | 2230
Other Circumstances | 40492 | 655 | 39837
Unknown Circumstances | 40460 | 1642 | 38818
1This table does not include a total row because in the row a victim can be counted more than once since he/she can be connected to up to ten offense types per incident and up to two circumstances describing the Murder and Nonnegligent Manslaughter or Aggravated Assault.
2The circumstance of Mercy Killing is not applicable to Aggravated Assault.
Spreadsheet: 206920d1358311201-help-with-retrieving-data-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | RESULTS
 | 2012-07-31 00:00:00 |  |  | 2012-08-31 00:00:00 |  |  | 2012-09-30 00:00:00 |  |  |  |  | Type | Bought
 | Z0010752 | Bought |  | T0187593 |  |  | W7852755 |  |  |  | 1
 | Z0010753 |  |  | T0187594 | Bought |  | W7852756 |  |  |  | 2
 | Z0010754 | Bought |  | T0187595 |  |  | W7852757 |  |  |  | 3
 | [NAME] |  |  | T0187596 |  |  | W7852758 | Bought |  |  | 4
 | Z0010756 |  |  | T0187597 | Bought |  | W7852759 |  |  |  | 5
 | Z0010757 |  |  | T0187598 |  |  | W7852760 | Bought |  |  | 6
 | Z0010758 | Bought |  | T0187599 |  |  | W7852761 |  |  |  | 7
 | Z0010759 |  |  | T0187600 | Bought |  | W7852762 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 9
Spreadsheet: 823448d1679966871-excel-calendar-perpetual-events-monthly-calendar-sample
Sheet: JUNE

JUNE 2023
SUNDAY |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 | 28 | 29 | 30 | 31 | 1 | 2 | 3
 |  | Memorial Day |  |  |  | [NAME] born 6/2/1882 - 1963 @81 ([NAME])
 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  | Juneteenth
 | 25 | 26 | 27 | 28 | 29 | 30 | 1
 |  |  |  |  | [NAME] [NAME] born  6/29/1861 - 8/18/1951 @ 89 [NAME] mom
Notes: |  |  |  |  |  |  | © www.calendarlabs.com
Spreadsheet: 808666d1670577334-need-2-formulas-where-they-lookup-values-from-a-different-spreadsheet-book2
Sheet: Sheet1

Car Payments
Amount | Amount | TX ID
2022-01-01 00:00:00
2022-02-01 00:00:00
2022-03-01 00:00:00
2022-04-01 00:00:00
2022-05-01 00:00:00
2022-06-01 00:00:00
2022-07-01 00:00:00
2022-08-01 00:00:00
2022-09-01 00:00:00
2022-10-01 00:00:00
2022-11-01 00:00:00
2022-12-01 00:00:00
Spreadsheet: 883641d1732282833-need-to-combine-formulas-into-1-cell-test-sheet
Sheet: Salaries

Person | Date of Birth | Age | Amount | Hourly Rate Jan 25 | Above National Minimum Wage for 18-20 (April 24) | Above National Minimum Wage for 21+ (April 24) | Above National Minimum Wage for 18-20 (April 25) | Above National Minimum Wage for 21+ (April 25) | Pay Rise Required | 2024-04-01 00:00:00 | 2025-04-01 00:00:00 |  |  |  |  | Year | Apprentice & Under 18 | Min Wage 18-20 | Min Wage Over 21
Employee 1 | 1993-11-30 00:00:00 |  | 27500 |  |  |  |  |  |  |  |  |  |  |  |  | Age | 0 | 18 | 21
Employee 2 | 1991-12-05 00:00:00 |  | 21300 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-01 00:00:00 | 6.4 | 8.6 | 11.44
Employee 3 | 1997-07-28 00:00:00 |  | 40500 |  |  |  |  |  |  |  |  |  |  |  |  | 2025-04-01 00:00:00 | 7.55 | 10 | 12.21
Employee 4 | 1988-02-09 00:00:00 |  | 43000
Employee 5 | 1971-10-07 00:00:00 |  | 21000
Employee 6 | 1985-05-26 00:00:00 |  | 38000
Employee 7 | 1961-01-13 00:00:00 |  | 35000
Employee 8 | 1977-04-07 00:00:00 |  | 42500
Employee 9 | 1979-01-08 00:00:00 |  | 35200
Employee 10 | 1984-02-09 00:00:00 |  | 55000
Employee 11 | 1999-04-28 00:00:00
Employee 12 | 2003-05-23 00:00:00 |  | 27500
Employee 13 | 1982-09-27 00:00:00 |  | 39500
Employee 14 | 1955-02-21 00:00:00
Employee 15 | 1981-04-23 00:00:00
Employee 16 | 1972-08-25 00:00:00
Employee 17 | 1979-12-03 00:00:00
Employee 18 | 1971-02-07 00:00:00
Employee 19 | 1980-10-27 00:00:00
Employee 20 | 1972-07-20 00:00:00
Employee 21 | 1981-05-09 00:00:00
Employee 22 | 1963-05-14 00:00:00
Employee 23 | 1963-10-16 00:00:00
Employee 24 | 1985-05-02 00:00:00 |  | 75000
Employee 25 | 1985-09-27 00:00:00 |  | 30000
Employee 26 | 2003-12-23 00:00:00 |  | 23795.2
Employee 27 | 2004-07-10 00:00:00 |  | 23795.2
Employee 28 | 2005-02-02 00:00:00 |  | 19500
Employee 29 | 2005-07-04 00:00:00 |  | 19500
Employee 30 | 2005-06-01 00:00:00 |  | 17888
Employee 31 | 2004-02-21 00:00:00 |  | 23795.2
Employee 32 | 1974-07-27 00:00:00
Employee 33 | 1989-04-12 00:00:00 |  | 40000
Employee 34 | 1993-04-17 00:00:00 |  | 48000
Employee 35 | 1978-06-30 00:00:00 |  | 55000
Employee 36 | 1993-06-23 00:00:00
Employee 37 | 2003-08-10 00:00:00
Spreadsheet: 726898d1617580610-if-function-to-include-multiple-cells-in-order-to-gain-result-parachutist-weights
Sheet: PD

 | Valkyrie
 | Canopy [NAME] | [NAME] |  | Make | Canopy [NAME] | [NAME]
 | 67 | 188 |  | Valkyrie | 67 | 188
 | 71 | 199 |  | Valkyrie | 71 | 199
 | 75 | 210 |  | Valkyrie | 75 | 210
 | 79 | 221 |  | Valkyrie | 79 | 221
 | 84 | 235 |  | Valkyrie | 84 | 235
 | 90 | 252 |  | Valkyrie | 90 | 252
 | 96 | 269 |  | Valkyrie | 96 | 269
 | 103 | 288 |  | Valkyrie | 103 | 288
 |  |  |  | PD OP | 99 | 220
 |  |  |  | PD OP | 106 | 220
 | PD OP |  |  | PD OP | 113 | 254
 | Canopy [NAME] | [NAME] |  | PD OP | 126 | 254
 | 99 | 220 |  | PD OP | 143 | 254
 | 106 | 220 |  | PD OP | 160 | 265
 | 113 | 254 |  | PD OP | 176 | 270
 | 126 | 254 |  | PD OP | 193 | 275
 | 143 | 254 |  | PD OP | 218 | 280
 | 160 | 265 |  | PD OP | 235 | 285
 | 176 | 270 |  | PD OP | 253 | 290
 | 193 | 275
 | 218 | 280
 | 235 | 285
 | 253 | 290
Spreadsheet: 678263d1589801972-replace-id-with-name-in-column-name-change
Sheet: owssvr

Title | Status of Project | Programme | Project Manager | [NAME] | Approved Baseline End Date | Initiate Baseline Start Date | Initiate Baseline End Date | Define & Design Baseline Start Date | Define & Design Baseline End Date | Build & Deliver Baseline Start Date | Build & Deliver Baseline End Date | Closure Baseline Start Date | Closure Baseline End Date | Item Type | Path
Contract Management Platform | Live | CONTRACT MANAGEMENT PLATFORM | A123
Spreadsheet: 47013d1245929375-how-do-you-get-stacked-column-100-to-bunch-together-689101
Sheet: Sheet1

 | x | y | z
a | 1 | 2 | 3
b | 2 | 2 | 2
c | 3 | 1 | 1
d | 4 | 2 | 2
 | x | y | z
<SPACE> | 0 | 0 | 0
a | 1 | 2 | 3
b | 2 | 2 | 2
<SPACE> | 0 | 0 | 0
<SPACE> | 0 | 0 | 0
c | 3 | 1 | 1
d | 4 | 2 | 2
<SPACE> | 0 | 0 | 0
Spreadsheet: feaff0ca-cf64-44f6-8abb-b9890b57e13f
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
OCC2 | Test | OCC2 | Occupational Panel # 2 | Occupational Panel # 2 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
OCC2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
OCC2 | Result | OCC2 | Occupational Panel # 2 | Occupational Panel # 2 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 600837d1543987934-help-with-tax-band-calculation-stacked-ifs-income-tax-calc
Sheet: Sheet1

Combined Salaries
50000 |  | Example Salary 1 |  | 100000 |  | Example Salary 2
 | 0.03 | Pension contrib |  |  | 0.09 | Pension contrib |  |  |  | Taken from pay before tax
 | 0.03 | [NAME] |  |  | 0.09 | [NAME] |  |  |  | Employer contributed / sits outside income
 |  | Net Pay for tax |  |  |  | Net Pay for tax |  |  |  | Net pay for tax calc
 |  |  |  |  |  |  |  |  |  | Taxation Rules / Band ranges | Notes
 |  |  |  |  |  |  |  | 14000 | 0.105 | Income up to $14000, taxed at 10.5%
 |  |  |  |  |  |  |  | 48000 | 0.175 | Income over $14000 and up to $48000, taxed at 17.5%
 |  |  |  |  |  |  |  | 70000 | 0.3 | Income over $48000 and up to $70000, taxed at 30% | Not calculated correctly. Should show $600
 |  |  |  |  |  |  |  | 70000+ | 0.33 | Remaining income over $70000, taxed at 33%
Tax |  |  |  | Tax
Net |  |  |  | Net
Annual Kiwisaver
Pay / Wk |  |  |  | Pay / Wk
Pay / Month |  |  |  | Pay / Month
Actuals Week |  | 1939.1
 |  |  | Hr |  |  |  | Hr
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: West Wing

Hour
Ending
Pacific | West Wing | APS(T) | APS(T) | WALC(t) | SRP(t) | PNM | PAC | WALC | WALC | Balance
Standard | phys. pos. | PV/WW | 4C/WW | From Mead | From PV | Sale | Sale | (T) to [NAME] | (T) to Mead |  |  | Hour | Total | Total
(PST) |  |  |  |  | 100 MW |  |  |  |  |  |  | Ending | To PX | From PX
100 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 100 |  |  | -1
200 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 200 |  |  | -1
300 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 300 |  |  | -1
400 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 400 |  |  | -1
500 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 500 |  |  | -1
600 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 600 |  |  | -1
700 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 700 |  |  | -1
800 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 800 |  |  | -1
900 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 900 |  |  | -1
1000 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1000 |  |  | -1
1100 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1100 |  |  | -1
1200 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1200 |  |  | -1
1300 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1300 |  |  | -1
1400 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1400 |  |  | -1
1500 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1500 |  |  | -1
1600 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1600 |  |  | -1
1700 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1700 |  |  | -1
1800 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1800 |  |  | -1
1900 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 1900 |  |  | -1
2000 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 2000 |  |  | -1
2100 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 2100 |  |  | -1
2200 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 2200 |  |  | -1
2300 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 2300 |  |  | -1
2400 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 2400 |  |  | -1
 |  |  |  |  |  |  |  |  | . |  |  | Totals
 | daily deals
 | 0
 | daily deals
 | 0
Spreadsheet: 264366d1378857877-how-to-use-conditional-formatting-if-360-cells-automatically-changing-colour-red-conditional
Sheet: Sheet1

12.5
30
30
8.583333333333332
0
0
11.58333333333333
30
30
30
30
30
30
0
25
30
30
7.583333333333333 |  | 360 is in cells A18. Change colour cells to red
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 186508d1350059276-rank-formula-cannot-rank-duplicates-rankduplicates
Sheet: Sheet1

 |  |  | Year-To-Date
 |  |  | Adjusted FYC
 |  |  | Rank | Sales Rep | Sales |  | [NAME] I used in the RANK column :
 |  |  |  | [NAME] | 523 |  | =IF(OR(E4="",E4=0),"",RANK(F4,$F$4:$F$27))
 |  |  |  | [NAME] | 4567.41
 |  |  |  | [NAME] | 89461.42
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | [NAME] | 42856
 |  |  |  | [NAME] | 74263
 |  |  |  | [NAME] | 12341.21
These are ranked "11th" due to their zero sales. How do we rank them (e.g. 11th, 12th, 13th) base on alphabetical order too? Like a secondary ranking if the first value is 'tied' at the same amount? |  |  |  | [NAME] | 1563.163
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  | → |  | Clarke | 0
 |  | → |  | [NAME] | 0
 |  |  |  | 0
 |  |  |  | 0
 |  | → |  | Kimberly | 0
 |  |  |  | [NAME] | 23.15
 |  |  |  | 0
 |  |  |  | [NAME] | 45683.85
 |  |  |  | Javier | 95631.23
Spreadsheet: 328355d1403877703-sumproduct-with-different-sized-arrays-sumproductexample
Sheet: Sheet1

Code | Rank |  | Conditional Sum (Rank) |  |  | Enter your code here |  |  | Conditional Code (Code)
1003 | 1 |  | 1018 |  |  | 5 |  |  | 46688
1004 | 2 |  | 1012 |  |  |  |  |  | 99892
1005 | 3 |  | 0 |  |  |  |  |  | 0
1007 | 4 |  | 0 |  |  |  |  |  | 0
1012 | 5 |  | 0 |  |  |  |  |  | 0
1014 | 1 |  | 0 |  |  |  |  |  | 0
1015 | 2 |  | 0 |  |  |  |  |  | 0
1016 | 3 |  | 0 |  |  |  |  |  | 0
1017 | 4 |  | 0 |  |  |  |  |  | 0
1018 | 5 |  | 0 |  |  |  |  |  | 0
1019 | 1 |  | 0 |  |  |  |  |  | 0
if you need exlanation then contact me at [EMAIL]
I have use array formula
no use of [NAME]
Spreadsheet: barry_tycholiz__890__Customer List-info needed
Sheet: IPP

 | Customer | CP ID | [NAME]? Alternates? | CP ID | Who's Customer
53 | AES | see list | AES Corporation, The
 |  |  | AES Drax Power Limited
 |  |  | AES Electric, Ltd.
 |  |  | AES Indian Queens Power, Ltd.
 |  |  | AES NewEnergy, Inc.
 |  |  | AES Power, Inc.
 |  |  | AES Shady Point, Inc.
 |  |  | AES Somerset, LLC
 |  |  | Northern AES Energy
 |  |  | AES Ironwood, Inc.
54 | Duke | see list | Duke Energy
 |  |  | Duke Energy Corporation
 |  |  | Duke Energy Field Services Marketing, LLC
 |  |  | Duke Energy Field Services, LLC
 |  |  | Duke Energy Field Services, LP
 |  |  | Duke [NAME], LP
 |  |  | Duke Energy Gathering & Processing LP
 |  |  | Duke Energy Intrastate Network, LLC
 |  |  | Duke Energy Marketing Limited Partnership
 |  |  | Duke Energy Merchants LLC
 |  |  | Duke Energy Pipeline Company
 |  |  | Duke Energy Power Services, Inc.
 |  |  | Duke Energy Power Services, LLC
 |  |  | Duke Energy Trading & Marketing, LLC
 |  |  | Duke Energy Transport & Trading Company
 |  |  | Duke Power Company
 |  |  | Duke Solutions
56 | El Paso Electric Co. | see list | El Paso Electric Company |  | Ward
 |  |  | El Paso CGP Electric Services Company
 |  |  | El Paso Electric Company Ancillary Services Exercised
 |  |  | El Paso Electric Company Supp.
57 | El Paso Energy | see list | El Paso Energy Corporation
 |  |  | El Paso Energy Intrastate Company
 |  |  | El Paso Energy Marketing Canada Inc.
 |  |  | El Paso Industrial Energy
 |  |  | El Paso Merchant Energy, L.P.
 |  |  | El Paso Merchant Energy Canada Inc.
58 | Tosco Refining Company | see list | Tosco Refining and Marketing Company
 |  |  | Tosco Refining Company
 |  |  | Tosco Refining Company Supp.
 |  |  | Tosco Refining, L.P.
 |  |  | Tosco Corporation
52 | [NAME](AES Generation) | [NAME]
55 | El Dorado (50% Reliant, 50% Sempra) | [NAME] | El Dorado Energy, Inc.?
59 | Chevron Products Co. | [NAME] | Chevron Products Company? | 65255
 |  |  | Chevron Products Company, a division of Chevron USA, Inc.? | 58956
60 | Corona Energy Partners, Ltd. | [NAME] | Corona Energy Partners? | 35977
61 | FPB Cogeneration See Newark Paperboard- | [NAME] | FPB Cogeneration Partners? | 30557
62 | Friendly Power | [NAME] | Friendly Power Co. LLC? | 56967
63 | Nordic Power of South Point | [NAME] | Nordic Power? | 72189
64 | Salt River Project | [NAME] | Salt River Project Agricultural Improvement and Power District? | 2765
65 | Texaco Refining & Marketing Co. | [NAME] | Texaco Refining & Marketing Inc.? | 9637