tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7c56822a-6e21-4a33-b8ea-21a43ce96e74
Sheet: SMA K

JADWAL PELAKSANAAN PENDIDIKAN [NAME] PROFESI GURU(PLPG) TAHAP VIII
RAYON 12 UNIVERSITAS NEGERI SEMARANG TAHUN 2011
GUGUS PATEMON
BIDANG STUDI MATEMATIKA SMA
TANGGAL 7-16 SEPTEMBER 2011
BLOK
Waktu | [NAME],      7 Sept | Kamis,      8 Sep | Waktu | Jum'at,    9 Sept | Waktu | Sabtu, 10 Sep | Minggu, 11 Sep | Senin,   12 Sept | Selasa, 13 Sept |  |  | [NAME], 14 Sept |  |  | Kamis, 15 Sept |  |  | Jum'at, 16 Sept
 |  |  |  |  |  |  |  |  | A | B | C | A | B | C | A | B | C
07.30-08.20 | CHEK IN | B1.2.   16 | 07.00-07,50 | B3.21 | 07.30-08.20 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10 | E.0
08.20-09.10 |  | B1.2.   16 | 07.50-08.40 | B3.21 | 08.20-09.10 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10 | E.0
09.10-10.00 |  | B1.3.   18 | 08.40-09.30 | C1.19.21 | 09.10-10.00 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10 | E.0
10.00-10.20 |  |  | 09.30-09.50 |  | 10.00-10.20 | Istirahat |  |  |  |  |  |  |  |  |  |  |  | E.0
10.20-11.10 |  | B1.3.   18 | 09.50-10.40 | C1.19.21 | 10.20-11.10 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10
11.10-12.00 | A1.0 | B2.1.   25 | 10.40-11.30 | C1.19.21 | 11.10-12.00 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10
12.00-13.00 | Ishoma |  | 11.30-13.00 |  | 12.00-13.00 | Ishoma
13.00-13.50 | A2.1 | B2.1.   25 | 13.00-13.50 | C1.19.21 | 13.00-13.50 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10
13.50-14.40 | A2.1 | B2.2.   25 | 13.50-14.40 | C1.19.21 | 13.50-14.40 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10
14.40-15.30 | A2.1 | B2.2.   25 | 14.40-15.30 | C1.19.21 | 14.40-15.30 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10
15.30-16.00 | Istirahat |  | 15.30-16.00 |  | 15.30-16.00 | Istirahat
16.00-16.50 | B1.1.   10 | B2.3.  23 | 16.00-16.50 | C2.4.7 | 16.00-16.50 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10
16.50-17.40 | B1.1.   10 | B2.3.  23 | 16.50-17.40 | C2.4.7 | 16.50-17.40 | C2.4.7 | C2.8.17 | C2.20.27 | D.29 | D.6 | D.9 | D.30 | D.28 | D.10 | D.29.30 | D.6.28 | D.9.10
Spreadsheet: 546943d1510256543-mortgage-paydown-projection-table-mortgage-paydown-projection-table-rental-valuation-breakdown
Sheet: Sheet1

[NAME]
ASKING |  |  | 203000
RV |  |  | 203000
DISCOUNT
PURCHASE AMOUNT |  |  | 160000
20% DISCOUNT IS
CASH FROM ME |  | 0.2
LOAN AMOUNT
BANK INTEREST RATE |  |  | 0.0439
LOAN TERM (YEARS) |  |  | 30
Weekly Rent |  |  | 280 | 0.8% RENT ON ASKING
GROSS INCOME |  |  |  | 0.8% RENT ON PURCHASE
Rates |  |  | 2107
Insurance |  |  | 0
Body Corp |  |  | 2424
Vacancy | 2 | Weeks
Maintenance | 3 | Weeks
Property Manager | 0
Interest on loan
Total Expenses
NET INCOME (AFTER INTEREST NO TAX) |  |  |  | NOI
(MONTHLY)
(WEEKLY)
 |  |  |  | REMAINING AFTER MORTGAGE PAYMENTS (WEEKLY)
 |  |  |  | REMAINING AFTER MORTGAGE PAYMENTS(YEARLY)
NET YIELD ON DEPOSIT |  |  |  | CAP
Tax on profit
PROFIT AFTER TAX
Spreadsheet: 229690d1366513637-how-to-get-the-content-of-the-row-as-the-content-of-a-column-how-to-get-thecontent
Sheet: Sheet1

subject |  |  |  | subject | MATHS
MATHS |  |  |  | subject | BIOLOGY
subject |  |  |  | subject | PHYSICS
BIOLOGY |  |  |  | subject | CHEMISTRY
subject |  |  |  | subject | ENGLISH
PHYSICS
subject
CHEMISTRY
subject
ENGLISH
Spreadsheet: 75063d1275585295-pivottables-showing-percent-instead-of-values-showing-percentage
Sheet: Revenue

 | Revenue & Segmenter pr. agent |  |  |  | Revenue & Segmenter pr. agent
 | [NAME]: Januay - Mars 2010 |  |  |  | [NAME]: Januay - Mars 2010
 | Country | (All) |  |  | Country | (All)
 | Agent Chain | (All) |  |  | Agent Chain | (All)
 |  | Values |  |  |  | Values
 | Row Labels | Sum of Revenue Actual |  |  | Row Labels | Sum of Revenue Actual
 | London |  |  |  | London
 | Firm AA | 2000 |  |  | Firm AA | 1
 | Contracted Volume | 1000 |  |  | Contracted Volume | 0.5
 | Non Contracted Volume | 1000 |  |  | Non Contracted Volume | 0.5
 | Firm BB | 2000 |  |  | Firm BB | 1
 | Contracted Volume | 1500 |  |  | Contracted Volume | 0.67
 | Non Contracted Volume | 500 |  |  | Non Contracted Volume | 0.33
 | Firm CC | 4000 |  |  | Firm CC | 1
 | Contracted Volume | 1000 |  |  | Contracted Volume | 0.25
 | Non Contracted Volume | 3000 |  |  | Non Contracted Volume | 0.75
 | [NAME] | 5000 |  |  | [NAME] | 1
 | Contracted Volume | 2500 |  |  | Contracted Volume | 0.5
 | Non Contracted Volume | 2500 |  |  | Non Contracted Volume | 0.5
 | London Total | 12000 |  |  | London Total
Spreadsheet: 029f9d57-81e1-4fbe-893c-bc530d293023
Sheet: Sheet1

Rev. 1/28/11 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Center for School Options and Finance
Office of Finance Program Services
SF-14 Per Diem Certification
School Age Form
Report to Certify the Per Diem Rate for Nonhandicapped School-Age Pupils
Who Were Provided Instructional Services and any Related Services
To Be Filed by the Educating District pursuant to 3313.64(C)(4)
For School Year ________________________________
Section I:  Identifying Information
A.
 | IRN |  | Educating District - City, Exempted Village, Local |  |  |  |  |  |  | County
B. | July through December
 | January through June
C. | Is the required contract for educational services between the educating district and the residential facility attached in accordance
 | with Section 3313.64(C)(4) |  | Yes |  | No |  | (If marked No, be sure to read instructions before continuing)
D. | Enter contract per diem amount plus service fee
 | (Be sure to read this line of instructions before continuing)
Section II:  Salaries and Benefits
E. | Instructional Salaries and Benefits
Section III:  General Student Costs
F. | Instructional Supplies and Materials
G. | Instructional Equipment
H. | Administrative Costs
I. | Staff Support Costs
J. | Pupil Support Costs
K. | Operations Support Costs
Section IV:  Per Diem Calculation
L. | Total Line E through K |  |  | 0 |  |  | ÷ |  |  | =
 |  |  |  |  |  |  |  | Aggregate Days |  |  | Daily Per Diem Rate
Superintendent Signature - City, Exempted Village, Local |  |  |  |  |  |  |  | Treasurer
Spreadsheet: 117283d1312620281-excel-2007-sum-a-date-range-sum-date-range
Sheet: Sheet8

 | Due Date | Amount |  |  | StartDate | End Date | Sum
 |  |  |  |  | 2011-08-07 00:00:00 | 2011-08-20 00:00:00 | 10500 |  | it's an array formula so you have to use ctrl+shift+enter
 | 2011-08-07 00:00:00 | 1000
 | 2011-08-09 00:00:00 | 2000
 | 2011-08-13 00:00:00 | 3000
 | 2011-08-24 00:00:00 | 1000
 | 2011-08-24 00:00:00 | 3000
 | 2011-08-24 00:00:00 | 2000
 | 2011-08-13 00:00:00 | 1500
 | 2011-08-15 00:00:00 | 3000
 | 2011-08-22 00:00:00 | 2000
Spreadsheet: 124399d1318371839-adding-on-call-hours-for-different-days-shift-schedule-version-2
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  |  | Shift Diff | Hours | On Call
[NAME] | E | E | E-C | RTO | RTO | RTO | RTO | RTO | RTO | D | E | E | E | E | RTO | RTO
Eaton | RTO | D | D | E | E | E | RTO | RTO | RTO | RTO | D | D | E | E | E | RTO
Dodge | RTO | RTO | D | D | E | E | E | RTO | RTO | RTO | RTO | D | D | E | E | E
Neufeld | RTO | RTO | RTO | RTO | DC
MacLean
[NAME]
Girma
Long
[NAME]
Employees
Employees
 | Shift |  |  |  | Employees |  |  | Shifts
 | D=0800-1800 |  |  |  | Eaton |  |  | D
 | E=1800-0400 |  |  |  | [NAME] |  |  | E
 |  |  |  |  | Neufeld |  |  | E1
 |  |  |  |  | Dodge |  |  | RTO
 |  |  |  |  | MacLean |  |  | D-C
 |  |  |  |  | [NAME] |  |  | E-C
 |  |  |  |  | [NAME]
 |  |  |  |  | Girma
 |  |  |  |  | Long
Spreadsheet: 882875d1731350104-split-value-across-years-test1
Sheet: Sheet1

start date | end date | amount | 2017 | 2018
2017-04-10 00:00:00 | 2018-04-09 00:00:00 | 6000
 |  |  | number of days | total days
Start date 2017/2018 | 2017-04-10 00:00:00 | 2017-07-31 00:00:00
End date 2018/2019 | 2017-08-01 00:00:00 | 2018-04-09 00:00:00 |  | 263
Spreadsheet: 762105d1641398128-need-formula-that-satisfies-3-criteria-for-text-in-a-cell-forum-sample
Sheet: Sheet1

 |  |  | DESIRED RESULT
1PR | BWGG | INSERT FORMULA | G |  |  | CRITERIA
NR | OWGR | INSERT FORMULA |  |  |  | 1. Col A must contain  "1PR"
NR | BPWO | INSERT FORMULA |  |  |  | 2. Col B must contain any of the same Letters twice any any order
1PR | PWWG | INSERT FORMULA | W |  |  | 3. Which ever letter appears twice in the cell in Col A, that letter must be displayed in Col C, where the formula is inserted
1PR | YPWW | INSERT FORMULA | W
1PR | PROP | INSERT FORMULA | P
1PR | RPBB | INSERT FORMULA | B
1PR | OROW | INSERT FORMULA | O
ALL | RRRR | INSERT FORMULA
1PR | YOWO | INSERT FORMULA | O
2PR | GRGR | INSERT FORMULA
NR | BYWO | INSERT FORMULA
Spreadsheet: paul_lucci__28370__Sinclair Recon
Sheet: Sheet1

Sinclair  Reconciliation
Deal # | Term | Volume | Price
VC3518 | June 01 (Only) | 4000 | 2.645
VA4410 | June 01 - Feb 02 | 2000 | 3.67 | BOOKED TO PRICE DESK (DUTCH) AND [NAME]
VC3558 | July 01 - Feb 02 | 1000 | 3.5225
VK9218 | Aug 01 - Feb 02 | 1000 | 2.96
Y46204 | October 01 (Only) | 2000 | 1.57
Y46285.1 | 11/01-02/02 | 1000 | 2.425
Spreadsheet: 115164d1310754211-excel-2007-calendar-reminder-questions
Sheet: Calendar

 |  |  | 2011-07-16 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  |  |  |  |  |  |  |  | This date should have another message aside from number "1" because in VL tab there's a match date for this box same on July 20.
 |  |  |  |  |  |  |  |  |  | if today is the day, it will highlight this as red. I know it should be on conditional formatting but i'm having a hard time doing it.
 |  |  |  |  | not(iserror(match(c9,mydates,0))
Spreadsheet: 113700d1309530214-excel-2007-i-need-a-macro-that-calculates-the-time-spent-on-an-activity-time-tracker-vba
Sheet: Sheet1

Activity | Start Time | End Time | Time Taken
Training | 2011-07-01 07:01:22 | 2011-07-01 07:20:04 | 00:29:58
Meeting | 2011-07-01 03:41:28 | 2011-07-01 07:20:04 | 01:59:32
Production | 2011-07-01 04:52:49 | 2011-07-01 07:20:04 | 02:27:15
Break | 2011-07-01 03:51:21 | 2011-07-01 07:20:04 | 03:28:43
 |  | Change one of the EndTime values and Time Taken will Change
 |  | No formulas in Time Taken now - it is done using VBA
 |  | Look Behind Sheet 1 for code.
Spreadsheet: 799783d1665288959-additional-charge-on-incremental-year-additional-charge-on-incremental-year-hd
Sheet: Sheet1

 | Additional Charge on Incremental Year
 |  |  |  |  | <---------------------------------------------------------Results [NAME] ---------------------------------------------------------> |  |  |  |  |  |  |  |  |  |  | <--------------------------------------------------------- Expected Results --------------------------------------------------------->
 | Normal Inspection | Start Year | Annual Charge | No. of Units | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Type A Machinery | 1 | 100 | 1200 |  |  |  |  |  |  |  |  |  |  |  | 138000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000
 | Type B Machinery | 3 | 200 | 1800 |  |  |  |  |  |  |  |  |  |  |  |  |  | 360000 | 378000 | 378000 | 378000 | 378000 | 378000 | 378000 | 378000
 | Type C Machinery | 5 | 300 | 2100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 661500 | 682500 | 682500 | 682500 | 682500 | 682500
 | Additional Inspection | Increment Year* | Annual Charge |  | Type B Machinery | Type C Machinery
 | Special inspection #1 | 0 | 150 | 0.1 | 0 | 0.1
 | Special inspection #2 | 1 | 200 | 0.05 | 0.05 | 0.05
 | * incremental year from start year of respective machinery => for Type A Machinery, Normal Inspection starts on Year 1 while Special Inspection #2 starts on Year 2 (1+1)
 | 3 different types of machinery (Type A, B and C) and 3 different sets of inspections (Normal Inspection and 2 additional inspections: Special Inspection #1 and Special Inspection #2).
 | Special inspections start based on the incremental year from start year of respective machinery.
Spreadsheet: 204695d1357611243-product-comparison-sample-sheet
Sheet: Sheet1

Manufacturer | Model # | Feature 1 | Feature 2 | Feature 3 | Feature 4 | Feature 5 | Feature 6 | Feature 7 | Feature 8
Manufacturer #1 | Model #1 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #1 | Model #2 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #1 | Model #3 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #1 | Model #4 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #1 | Model #5 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #2 | Model #6 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #2 | Model #7 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #2 | Model #8 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #2 | Model #9 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #2 | Model #10 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #3 | Model #11 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #3 | Model #12 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #3 | Model #13 | Data | Data | Data | Data | Data | Data | Data | Data
Manufacturer #3 | Model #14 | Data | Data | Data | Data | Data | Data | Data | Data
Spreadsheet: 2563042e-fb02-4618-9769-dbb17f17ac79
Sheet: Sheet1

INSURED: | Unnamed: 1 | Unnamed: 2 | STANDARD DEDUCTIBLE: | Unnamed: 4 | Unnamed: 5 | 1000 | YOUR DED.: | Unnamed: 8 | Unnamed: 9
Private |  |  | STANDARD COINSURANCE: |  |  | Agreed Amount Basis
Year Built |  | # of stories
Sq. Footage |  | (Clubhouse) |  | Per Sq. Ft.
[NAME]. Class
Building | Building | Contents | Equipment | Construction | Sprinklered? | [NAME]? | Central Station | Central Station | Distance from
Description | Value | Value | Value |  | Yes/No | Yes/No | Smoke/Heat Alarm? | Burglar Alarm? | Clubhouse
Clubhouse
[NAME]
Maintenance
Totals | 0 | 0 | 0
Bus. Inc./EE
EDP
VP
AR
FINE ARTS
BAILEES | 100000 | Members Property
If buildings are 10+ years old, date last upgraded for:
 | Electrical |  | Heating |  | Plumbing |  | Roof
Spreadsheet: 125972d1319452194-which-function-to-copy-data-from-many-sheets-to-a-sheet-in-same-file-monthly-report
Sheet: 01-09

2
Report
STT | Type | Product Name |  |  | Amount | Price | % DISCOUNT |  |  |  | Total | Remarks
 |  | Code | Color Code | Size |  |  | PROMOTION |  | VIP CARD
 |  |  |  |  |  |  | % | Total | % | Total
 |  |  |  |  | (1) | (2) | (3) | (4)=(2)-(3) | (5) | (6)=(2)*(1)-(4)-(5) | (7)=(2)*(1)-(4)-(6)
 | DAY LUNG | RC1071 | 00 | 110 | 1 | 2897000 |  | 0 |  | 0 | 2897000
 | GIAYSS10 | 1585 | 120 | 7.5 | 1 | 1423000 |  | 0 |  | 0 | 1423000
 | GIAYSS10 | 2873 | 125 | 4 | 1 | 1690000 |  | 500000 |  | 0 | 1190000
 | NAM | CH472810 | MKV | 42 | 1 | 2505000 |  | 0 |  | 0 | 2505000
 | NAM | DH354110 | KSN | 4 | 1 | 2141000 |  | 0 |  | 0 | 2141000
 | NAM | L126410 | DRZ | 6 | 1 | 2443000 |  | 0 |  | 0 | 2443000
 | NAM | PH198110 | Q2X | 3 | 1 | 2081000 |  | 0 |  | 0 | 2081000
 | NAM | PH615110 | [NAME] | 5 | 1 | 2287000 |  | 0 | 50 | 1143500 | 1143500
 | NAM | PH820110 | QỤ5 | 5 | 1 | 2069000 |  | 0 |  | 0 | 2069000
 |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  | 9 |  |  | 500000 |  | 1143500 | 17892500
Spreadsheet: 34656d1231967382-lookup-or-index-dealer-selection
Sheet: Sales Mix

 | DEALER | STYLE | BOX COUNT | DOLLARS
 | TOP SHELF CABINETS INC | RUTLAND II | 3 | 287.4
 | COLONIAL KITCHEN AND BATH | PORTRAIT MAPLE | 1 | 296.81
 | KITCHEN DESIGNS INC | PORTRAIT MAPLE | 1 | 305.28
 | PANEL HAUS | SUTTON CLIFF HICKORY | 1 | 307.94
 | CAL-SUN CONSTRUCTION INC | SENECA RIDGE OAK | 1 | 313.9
 | ST [NAME] | WHITEBAY II or ASHLYNN CREEK | 3 | 317.44
 | ANDERSONVILLE KITCHEN & BATH | NORTHPORT | 4 | 317.919999999999
 | THE ADVANCE DESIGN STUDIO | MOUNTAIN MIST | 2 | 318.99
 | GALACTIC TECH INC | SPRING VALLEY CHERRY | 2 | 323.48
 | ASPEN CABINET DISTRIBUTION | NORTHPORT | 4 | 323.62
 | LEE LUMBER PERSHING | SPRING VALLEY MAPLE | 3 | 334.97
 | MAVERICK DBA THE DESIGN CTR FOR KIT&BATH | [NAME] | 1 | 335
 | ANDERSONVILLE KITCHEN & BATH | MOUNTAIN MIST | 2 | 344.72
 | PREMIER KITCHENS & BUILDING PRODUCTS INC | SPRING VALLEY OAK | 2 | 345.59
 | CACCIA & ASSOCIATES INC | SUTTON CLIFF MAPLE | 1 | 348.07
 | 84 LUMBER STORE#0806 | SPRING VALLEY CHERRY | 2 | 350.85
 | ANDERSONVILLE KITCHEN & BATH | SOMERTON HILL CHERRY | 2 | 352.64
 | 84 LUMBER STORE 0826 | SUTTON CLIFF CHERRY | 2 | 353.3
 | CONCEPT KITCHEN DESIGN | PORTRAIT MAPLE | 3 | 354.77
 | CONCEPT KITCHEN DESIGN | SUTTON CLIFF MAPLE | 1 | 356.11
 | 84 LUMBER STORE#0811 | RUTLAND II | 4 | 356.44
 | PREMIER STONE WORKS DBA PREMIER CABINET | WHITEBAY II or ASHLYNN CREEK | 3 | 356.71
 | CAL-SUN CONSTRUCTION INC | PORTRAIT CHERRY | 2 | 356.91
 | TOP SHELF CABINETS INC | FUSION MAPLE | 1 | 357.18
 | CACCIA & ASSOCIATES INC | NORTHPORT | 3 | 358.52
 | MIDWEST KITCHEN AND BATH CABINETRY | SPRING VALLEY HICKORY | 3 | 367.36
 | PEARL DESIGN GROUP LLC | Masterpiece LAMINATE/VINYL | 1 | 368.7
 | 84 LUMBER STORE#0806 | WHITEBAY II or ASHLYNN CREEK | 3 | 369.3
 | PREMIER STONE WORKS DBA PREMIER CABINET | PORTRAIT MAPLE | 2 | 370.78
 | 84 LUMBER STORE#0811 | SENECA RIDGE CHERRY | 2 | 376.66
 | 84 LUMBER STORE#0810 | SUTTON CLIFF MAPLE | 1 | 376.94
 | MAVERICK DBA THE DESIGN CTR FOR KIT&BATH | RUTLAND II | 4 | 381.69
 | MAVERICK DBA THE DESIGN CTR FOR KIT&BATH | Masterpiece OAK | 2 | 384.5
 | HOMEMAKERS SUPPLY INC | LARIAT MAPLE | 2 | 386.7
 | ANDERSONVILLE KITCHEN & BATH | SUTTON CLIFF CHERRY | 2 | 390.8
 | LA MAISON | ARBOR FALLS II WHITE or BISQUE | 4 | 392.29
 | 84 LUMBER STORE#0811 | SUTTON CLIFF MAPLE | 2 | 397.19
 | CRAWFORD SUPPLY COMPANY | SUTTON CLIFF MAPLE | 2 | 397.84
 | ANDERSONVILLE KITCHEN & BATH | WHITEBAY II or ASHLYNN CREEK | 3 | 407.76
 | LANDMARK HOMES DBA EXPERT RENOVATIONS | SILHOUETTE MAPLE | 2 | 412.12
 | TOP SHELF CABINETS INC | PORTRAIT CHERRY | 1 | 415.27
 | HOMEMAKERS SUPPLY INC | SILHOUETTE MAPLE | 1 | 416.81
 | BEYOND CARPENTRY DBA BEST CABINET SUPPLY | SPRING VALLEY CHERRY | 3 | 419.5
 | ORCHARD HILL CABINETRY DBA BUILDERS CABI | [NAME] | 3 | 420.83
 | 84 LUMBER STORE#0811 | ENFIELD | 3 | 421.54
 | 84 LUMBER STORE#0806 | LARIAT MAPLE | 2 | 421.9
 | PANEL HAUS | SILHOUETTE CHERRY | 1 | 423.24
 | ST [NAME] | SUTTON CLIFF OAK | 3 | 423.27
 | COLONIAL KITCHEN AND BATH | NORTHPORT | 4 | 427.74
 | LA MAISON | SENECA RIDGE MAPLE | 2 | 428.13
Spreadsheet: 555145d1515456696-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 5

 |  |  | Tournament 5
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  |  |  | 55
 |  |  |  | 38
 |  |  |  | 29
 |  |  |  | 31
 |  |  |  | 40
 |  |  |  | 66
 |  |  |  | 59
 |  |  |  | 60
 |  |  |  | 55
 |  |  |  | 62
 |  |  |  | 57
 |  |  |  | 57
 |  |  |  | 76
 |  |  |  | 72
 |  |  |  | 68
 |  |  |  | 49
 |  |  |  | 76
 |  |  |  | 41
 |  |  |  | 57
 |  |  |  | 64
 |  |  |  | 59
 |  |  |  | 48
 |  |  |  | 60
 |  |  |  | 49
 |  |  |  | 47
 |  |  |  | 31
 |  |  |  | 36
 |  |  |  | 42
 |  |  |  | 59
 |  |  |  | 50
 |  |  |  | 36
 |  |  |  | 47
 |  |  |  | 57
 |  |  |  | 41
 |  |  |  | 49
 |  |  |  | 71
 |  |  |  | 55
 |  |  |  | 60
 |  |  |  | 30
 |  |  |  | 44
 |  |  |  | 38
 |  |  |  | 32
 |  |  |  | 69
 |  |  |  | 52
 |  |  |  | 52
 |  |  |  | 32
 |  |  |  | 69
 |  |  |  | 70
 |  |  |  | 62
 |  |  |  | 74
 |  | x | x | x
Spreadsheet: 732201d1620822714-sumproduct-with-multiple-criteria-and-using-sign-function-sumproduct-with-multiple-criteria
Sheet: Sheet1

Release date | Category | JOB No. | Total |  |  |  | 1 | 2
2021-01-04 00:00:00 | Sheeting | HY-05840.01.25 | 0.172 |  |  | Job No. | Jan | Feb
2021-01-04 00:00:00 | Built-up | HY-05840.01.23 | 131.609 |  |  | HY-05840 | 224.823 | 103.079
2021-01-04 00:00:00 | Cold Form | HY-05840.01.24 | 86.56 |  |  | HY-05799 |  | 45.603
2021-01-04 00:00:00 | Others | HY-05840.01.25 | 91.65 |  |  |  | Need formula for the cells Highlighted in Yellow
2021-01-04 00:00:00 | Miscellaneous | HY-05840.01.23 | 0.011 |  |  |  | From the Table (A1:D23) the formula to sum "TOTAL" column by taking only month number from "Release Date" column and 8 characters from left of "JOB No." and only {Built-up, Cold Form & Sheeting} from "Category". Note: The data is in the Table form.
2021-01-05 00:00:00 | Built-up | HY-05840.01.24 | 0.725
2021-01-05 00:00:00 | Sheeting | HY-05840.01.25 | 0.17
2021-01-05 00:00:00 | Sheeting | HY-05840.01.23 | 5.587
2021-02-08 00:00:00 | Built-up | HY-05799.01.24 | 5.857
2021-02-08 00:00:00 | Cold Form | HY-05799.01.25 | 33.891
2021-02-08 00:00:00 | Others | HY-05799.01.23 | 0.603
2021-02-08 00:00:00 | Miscellaneous | HY-05799.01.24 | 11.327
2021-02-08 00:00:00 | Built-up | HY-05799.01.25 | 5.855
2021-02-08 00:00:00 | Sheeting | HY-05840.01.24 | 28.738
2021-02-08 00:00:00 | Miscellaneous | HY-05840.01.25 | 27.699
2021-02-08 00:00:00 | Built-up | HY-05840.01.24 | 5.857
2021-02-08 00:00:00 | Cold Form | HY-05840.01.25 | 33.891
2021-02-08 00:00:00 | Others | HY-05840.01.23 | 0.603
2021-02-08 00:00:00 | Miscellaneous | HY-05840.01.24 | 11.327
2021-02-08 00:00:00 | Built-up | HY-05840.01.25 | 5.855
2021-02-08 00:00:00 | Sheeting | HY-05840.01.24 | 28.738
2021-02-08 00:00:00 | Miscellaneous | HY-05840.01.25 | 27.699
Spreadsheet: 272494d1382404915-variable-column-average-max-and-min-variable-column-average
Sheet: Settings

The [NAME], Min and Average values need to be of the PasteData table with respect to each defined column.
Data | PasteData Column | Column # | [NAME] | Min | Average |  | PasteData Column Headings to provide for data validation dropdown list for the table to the left.
Price per SF | Price Per SF
Price per Unit | Price Per Unit
Sale Date | Sale Date
Sale Price | Sale Price
Actual [NAME] rate | Actual [NAME]
GRM | GRM
Spreadsheet: 124824d1318624890-sorting-blank-data-out-of-a-list-classeur1-1-
Sheet: Feuil1

Declared Components (as entered) | Declared Components (no blanks)
 |  |  | CE021
 |  |  | The range of the formula in the drop-downlist is long as the green cells.