tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 018e528e-2e2b-49ff-bc95-086fa8916182
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: |  |  | 2011-07-19 09:19:28.750000
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.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.217 | 101.092 | 100.967 | 100.592
4.625 | 100.346 | 100.221 | 100.096 | 99.721 |  | Note: | Refer To Price [NAME]
4.5 | 99.869 | 99.744 | 99.619 | 99.244 |  |  | For all Price Adjs
4.375 | 99.246 | 99.121 | 98.996
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.529 | 101.404 | 101.279 | 100.904
4 | 101.209 | 101.084 | 100.959 | 100.584
3.875 | 100.808 | 100.683 | 100.558 | 100.183
3.75 | 100.21 | 100.085 | 99.96 | 99.585
3.625 | 99.222 | 99.097 | 98.972
 |  |  |  |  |  | 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 | 2011-08-02 09:19:28.750000
30 DAY | 2011-08-17 09:19:28.750000
45 DAY | 2011-09-01 09:19:28.750000
60 DAY | 2011-09-16 09:19:28.750000
90 DAY | 2011-10-16 09:19:28.750000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 217942d1362259788-make-a-unique-list-from-data-table-copy-of-unique-list_from_data_table
Sheet: Sheet1

 |  |  |  |  | ID |  |  | ID
 |  |  |  |  | 160 |  | <----ID comes from Data Validation | 153
 | DATA TABLE |  |  |  | SUM TABLE |  |  | 158
 | ID | Name | Helper |  | Name |  |  | 160
 | 158 | n1 |  |  |  |  | [NAME] will place from here to bottom | 161
 | 158 | n2 |  |  |  |  |  | 178
 | 160 | n1 |  |  |  |  |  | 188
 | 153 | n2 |  |  |  |  |  | 190
 | 158 | n3
 | 161 | n2
 | 178 | n5
 | 158 | n4
 | 158 | n3
 | 160 | n6
 | 158 | n1
 | 158 | n4
 | 160 | n3 |  |  |  |  | Names
 | 178 | n2 |  |  |  |  | will come only I2 cell refferenced names
 | 160 | n3 |  |  |  |  | example: if I2 = 158
 | 188 | n2 |  |  |  |  | in SUM TABLE "n1" "n2" "n3" "n4"  will be listed
 | 190 | n1 |  |  |  |  | as a unique list ( one time to be placed)
 | 158 | n4 |  |  |  |  | NOT n5 and n6
 | 153 | n3 |  |  |  |  | From H5 to H24  a FORMULA needed
 | 160 | n3 |  |  |  |  | to replace the Names from Data Table to SUM table
Spreadsheet: 152546d1335433581-need-help-in-solving-excel-task-assignment3
Sheet: TVTB

Code | Course | CP | Category
ITX0025 | Introduction to Information Technology | 4 | G
TIX2135 | Organization of Studies | 1 | G
TIX2515 | Qualitative Research Methods | 4 | G
TIX3730 | History of Philosophy | 3 | G
TSK0025 | English for Special Purposes I | 3 | G
HLE2200 | [NAME] and Culture | 3 | GO
TIX2070 | Working Environment and Ergonomics | 6 | GO
TIX2310 | Sociology | 6 | GO
TSK0020 | English I | 3 | GO
IDK2081 | Information Technology | 6 | B
TIX2520 | Mathematics | 6 | B
TIX2565 | Quantitative Methods | 4 | B
TIX2530 | Economics I | 6 | B
TIX2540 | Economics II | 6 | B
TIX2575 | Money and banking | 4 | B
[NAME] | Marketing | 6 | B
TSK0026 | Business English I | 6 | B
TIX0020 | Research paper II | 3 | B
TIX0050 | Research paper I | 3 | B
TIX2550 | Basic Finance | 6 | C
[NAME] | Financial Management | 6 | C
TIX2810 | Principles of Financial Accounting | 6 | C
TIX2830 | Management Accounting | 6 | C
TIX2010 | International Marketing | 6 | C
TIX2141 | Logistics | 4 | C
TIX2150 | Business Communication | 6 | C
TIX2120 | Operations Management | 6 | C
TIX2200 | Organizational Behavior | 6 | C
TIX2735 | Management | 6 | C
TIX2220 | Entrepreneurship | 6 | C
TIX2320 | Legal Environment of Business | 6 | C
TIX2165 | Project Management | 4 | S
TIX2335 | [NAME] | 4 | S
HLI2122 | Business English II | 4 | SO
TIX2025 | Real Estate Economics | 4 | SO
TIX2175 | Marketing Research and Marketing Planning | 4 | SO
TIX2685 | E-Marketing | 4 | SO
TIX2825 | Introduction to Financial Analysis | 4 | SO
Spreadsheet: 749898d1633087137-formula-to-calculate-nssa-deductions-on-due-date-nssa-due-dates
Sheet: Sheet1

Kindly asking for a formula to calculate NSSA deductions on due date.
How to calculate NSSA deductions
If any employee earn less the ceiling, multiply basic salary by 4.5%
If any employee earn more than the ceiling, multiply ceiling by 4.5%
Period | January | February | March | April | May | June | July | August | September | October | November | December
NSSA RATES | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045
Ceiling | 5000 | 6000 | 8000 | 8000 | 8500 | 9000 | 9500 | 10000 | 10500 | 11000 | 11500 | 11500
Pay due date | 2021-01-25 00:00:00 | 2021-02-25 00:00:00 | 2021-03-25 00:00:00 | 2021-04-25 00:00:00 | 2021-05-25 00:00:00 | 2021-06-25 00:00:00 | 2021-07-25 00:00:00 | 2021-08-25 00:00:00 | 2021-09-25 00:00:00 | 2021-10-25 00:00:00 | 2021-11-25 00:00:00 | 2021-12-25 00:00:00
Desired Outcome
NSSA Deductions
Name | Date | Period | Basic Salary | Amount Paid | Deductions
[NAME] | 2021-08-15 00:00:00 | August | 20000 | 10000
[NAME] | 2021-08-15 00:00:00 | August | 9000 | 4000
[NAME] | 2021-08-25 00:00:00 | August | 8000 | 8000
[NAME] | 2021-08-25 00:00:00 | August | 11000 | 11000
[NAME] | 2021-08-25 00:00:00 | August | 20000 | 10000
[NAME] | 2021-08-25 00:00:00 | August | 9000 | 5000
[NAME] | 2021-08-25 00:00:00 | August | 16000 | 9000
[NAME] | 2021-09-10 00:00:00 | August | 16000 | 7000
Note: [NAME] and [NAME] were partly paid in advance and on due date. [NAME] was partly paid on due date and in arrears on 10/9/21
Spreadsheet: 90061a11-3c10-434f-b110-15235a5fdeee
Sheet: Sheet1

UL Short Circuit Rating of Open Components for use in Industrial Control Panels | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Product Group | Component Type |  | Description |  |  | Partial Catalog Number(s) |  | Maximum Ampere Rating |  | Standard Fault Short Circuit Rating
Freedom C306 | Interchangeable Class 10 & 20 Heater packs |  | Used with C306TB1 stand alone base, 3 pole, amb. compensated. |  |  | [NAME] |  | 32 |  | 5kA
 |  |  | Used with C306TB2B stand alone base, 3 pole, amb. compensated.  . |  |  | C306GT3B |  | 75 |  | 5kA
 | Interchangeable Class 20 [NAME] packs |  | Includes intergal stand alone base, 3 pole, amb. compensated. |  |  | C306KN3 |  | 105 |  | 10kA
 |  |  | Includes intergal stand alone base, 3 pole, amb. compensated. |  |  | C306NN3 |  | 144 |  | 10kA
Type B Thermal | Interchangeable Class 20 Heater Elements |  | Panel Mounted, Ambient Compensated, 1 pole. |  |  | BA11JP |  | 26.2 |  | 5kA
 |  |  |  |  |  | [NAME] |  | 45
 | Interchangeable Class 20 Heater Elements |  | [NAME], Non-ambient Compensated, 1 pole. |  |  | BN11JP |  | 26.2
 |  |  |  |  |  | BN21JP |  | 45
 | Interchangeable Class 20 Heater Elements |  | Panel Mounted, Ambient Compensated, 3 pole. |  |  | BA13JP |  | 26.2 |  | 5kA
 |  |  |  |  |  | BA23JP |  | 45
 |  |  |  |  |  | BA33P |  | 90
 |  |  |  |  |  | BA43P |  | 135 |  | 10kA
 | Interchangeable Class 20 Heater Elements |  | [NAME], Non-ambient Compensated, 3 pole. |  |  | BN13JP |  | 26.2 |  | 5kA
 |  |  |  |  |  | BN23JP |  | 45
 |  |  |  |  |  | BN33P |  | 90
 |  |  |  |  |  | BN43P |  | 135 |  | 10kA
Type A Thermal | Interchangeable Class 20 Heater Elements |  | Panel Mounted, Ambient Compensated, 1 pole |  |  | AA11P |  | 26.2 |  | 5kA
 |  |  |  |  |  | AA21P |  | 45
 |  |  |  |  |  | AA31P |  | 90
 |  |  |  |  |  | AA41P |  | 135 |  | 10kA
 | Interchangeable Class 20 Heater Elements |  | [NAME], Non-ambient Compensated, 1 pole |  |  | AN11P |  | 26.2 |  | 5kA
 |  |  |  |  |  | AN21P |  | 45
 |  |  |  |  |  | AN31P |  | 90
 |  |  |  |  |  | AN41P |  | 135 |  | 10kA
Type A Thermal | Interchangeable Class 20 Heater Elements |  | Panel Mounted, Ambient Compensated, 3 pole |  |  | AA13P |  | 26.2 |  | 5kA
 |  |  |  |  |  | AA23P |  | 45
 |  |  |  |  |  | AA33P |  | 90
 |  |  |  |  |  | AA43P |  | 135 |  | 10kA
 | Interchangeable Class 20 Heater Elements |  | [NAME], Non-ambient Compensated, 3 pole |  |  | AN13P |  | 26.2 |  | 5kA
 |  |  |  |  |  | AN23P |  | 45
 |  |  |  |  |  | AN33P |  | 90
 |  |  |  |  |  | AN43P |  | 135 |  | 10kA
Freedom C316F | Fixed [NAME] 10 - Ambient Compensated. |  | Used with C306TB1 stand alone base, 3 pole. |  |  | C316FNA3* |  | 32 |  | 5kA
 |  |  | Used with C316TB1 stand alone base, 3 pole |  |  | C316KN3* |  | 80 |  | 5kA
 |  |  | Used with C316PCL1, -PK1,or -PK2 Adaptor kits for mounting to Freedom Series 90mm & 180mm Contactors. |  |  | C316PNA* |  | 200 |  | 10kA
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-06-30 00:00:00 |  | 966312.73
2001-07-03 00:00:00
60874 | 337
500235
500248
500251
500254 | 275
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-06-30 00:00:00 |  | 275313.72
2001-06-30 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-06-30 00:00:00 |  | 698975.46
2001-06-30 00:00:00
500241
500391
500392
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: 882839d1731323971-schedule-formula-sample
Sheet: Blad1

 | Monday | Tuesday | Wensday | Thursday | Friday | Saturday | Sunday
Week 1
Week 2
Week 3
Week 4 |  |  |  |  |  |  |  |  |  |  | Schedule Code | Start | End | Total arbetstid | Lunch | Working hours
Week 5 |  |  |  |  |  |  |  |  |  |  | A1 | 06:45:00 | 15:30:00 |  | 00:45:00
Week 6 |  |  |  |  |  |  |  |  |  |  | A2 | 07:00:00 | 12:00:00 |  | 00:00:00
Week 7 |  |  |  |  |  |  |  |  |  |  | A3 | 07:00:00 | 14:45:00 |  | 00:45:00
Week 8 |  |  |  |  |  |  |  |  |  |  | A4 | 07:00:00 | 14:15:00 |  | 00:45:00
Week 9 |  |  |  |  |  |  |  |  |  |  | AT | 07:00:00 | 15:45:00 |  | 00:45:00
Week 10 |  |  |  |  |  |  |  |  |  |  | AS | 07:00:00 | 15:45:00 |  | 00:45:00
Week 11 |  |  |  |  |  |  |  |  |  |  | BT | 11:15:00 | 20:00:00 |  | 00:45:00
Week 12 |  |  |  |  |  |  |  |  |  |  | BS | 11:15:00 | 20:00:00 |  | 00:45:00
 |  |  |  |  |  |  |  |  |  |  | F | 12:15:00 | 21:00:00 |  | 00:45:00
Spreadsheet: 835143d1688344391-need-help-with-excel-file-and-slicer-calculation-issue-dvg_inventory_tracker_reports-mehdi_154-
Sheet: Products

INVENTORY AND SALES MANAGER |  |  |  |  | Orders and Inventory |  | Report | Terms
 |  |  |  |  |  | Need help with Excel file and slicer calculation issue (excelforum.com)
INSTRUCTIONS
1. Enter Products below
2. Enter Order details in the Orders and Inventory worksheet
3. View the report in the Report worksheet.
ENTER PRODUCTS
Product Name | Product Description | Product Category | Re-Order Point
Butterscotch FLV Sauce | Butterscotch FLV Sauce | Sauce | 20
Caramel FLV Sauce | Caramel FLV Sauce | Sauce | 20
Chocolate FLV Sauce | Chocolate FLV Sauce | Sauce | 20
White Chocolate FLV Sauce | White Chocolate FLV Sauce | Sauce | 20
Cheese Cake FLV Sauce | Cheese Cake FLV Sauce | Sauce | 20
Caramel FLV Syrup | Caramel FLV Syrup | Syrup | 20
[NAME] FLV Syrup | [NAME] FLV Syrup | Syrup | 20
Vanilla FLV Syrup | Vanilla FLV Syrup | Syrup | 20
Blue Ocean FLV Syrup | Blue Ocean FLV Syrup | Syrup | 20
European Strawberry FLV Syrup | European Strawberry FLV Syrup | Syrup | 20
Fragnant Lychee FLV Syrup | Fragnant Lychee FLV Syrup | Syrup | 20
Green Apple Campagna FLV Syrup | Green Apple Campagna FLV Syrup | Syrup | 20 |  |  | DATA VALIDATION
Lemon FLV Syrup | Lemon FLV Syrup | Syrup | 20
Majestic Mango FLV Syrup | Majestic Mango FLV Syrup | Syrup | 20
Menta CUBANO FLV Syrup | Menta CUBANO FLV Syrup | Syrup | 20
Peach Garden FLV Syrup | Peach Garden FLV Syrup | Syrup | 20
ITALIAN Dolce FLV Syrup | ITALIAN Dolce FLV Syrup | Syrup | 20
Lemonade FLV Syrup | Lemonade FLV Syrup | Syrup | 20
[NAME] BEV Mix | [NAME] BEV Mix | [NAME] | 20
White Peach Fruit BEV Mix | White Peach Fruit BEV Mix | [NAME] | 20
Mango Fruit BEV Mix | Mango Fruit BEV Mix | [NAME] | 20
Passionfruit FRUIT BEV Mix | Passionfruit FRUIT BEV Mix | [NAME] | 20
Strawberry Fruit BEV Mix | Strawberry Fruit BEV Mix | [NAME] | 20
[NAME] BEV Mix | [NAME] BEV Mix | [NAME] | 20
[NAME] FLV Syrup | [NAME] FLV Syrup | Syrup | 20
Tropical Passionfruit FLV Syrup | Tropical Passionfruit FLV Syrup | Syrup | 20
End of 2000 Products
Spreadsheet: 766859d1644114307-sumproductif-iec_03
Sheet: IC

1 | RU-AA11_x001C_
2 | RU-AA12_x001C_
3 | [NAME]_
4 | RU-AA22_x001C_
5 | RU-AA31_x001C_
6 | [NAME]_
7 | RU-AB11_x001C_
8 | [NAME]_
9 | RU-AB21_x001C_
10 | RU-AB22_x001C_
11 | RU-AB31_x001C_
12 | RU-AB32_x001C_
13 | RU-AC11_x001C_
14 | RU-AC12_x001C_
15 | RU-AC21_x001C_
16 | [NAME]_
17 | RU-AC31_x001C_
18 | RU-AC32_x001C_
19 | RU-ADM11_x001C_
20 | RU-ADM12_x001C_
21 | RU-ADM21_x001C_
22 | RU-ADM22_x001C_
23 | RU-ADM31_x001C_
24 | RU-ADM32_x001C_
25 | RU-ADM41_x001C_
26 | RU-ADM42_x001C_
27 | RU-AUD11_x001C_
28 | [NAME]_
29 | RU-AUD31_x001C_
30 | RU-CAF11_x001C_
31 | RU-T11_x001C_
32 | RU-T12_x001C_
33 | RU-T21_x001C_
34 | RU-T22_x001C_
35 | RU-T31_x001C_
36 | RU-T32_x001C_
37 | RU-T33_x001C_
38 | RU-T34_x001C_
39 | RU-T35_x001C_
40 | RU-T36_x001C_
41 | RU-T37_x001C_
Spreadsheet: 226039-continuing-number-sequences-with-lines-20130406-navdatawithrequiredresult-v2
Sheet: navdata

check | formula | REQUIRED RESULT | OLD DATA
 |  | 5 | 1 | [NAME] |  | Z999 | H |  | AUS | 47.400011 | 10.479875 |  | 5
 |  | 4 | 2 | BEMKI |  | Z999 | H |  | AUS | 47.5595 | 10.3055 |  | 5
 |  | 3 | 3 | KPT |  | Z999 | H |  | AUS | 47.745775 | 10.349833 |  | 3
 |  | 19 | 1 | LUB |  | Z998 | H |  | AUS | 53.940742 | 10.667786 |  | 3
 |  | 18 | 2 | RAMAR |  | Z998 | H |  | AUS | 53.710833 | 10.938834 |  | 5
 |  | 17 | 3 | NUSGU |  | Z998 | H |  | AUS | 53.266667 | 11.388667 |  | 5
 |  | 16 | 4 | [NAME] |  | Z998 | H |  | AUS | 53.148667 | 11.569667 |  | 5
 |  | 15 | 5 | PITEN |  | Z998 | H |  | AUS | 52.99 | 11.811333 |  | 5
 |  | 14 | 6 | BIRMO |  | Z998 | H |  | AUS | 52.872167 | 12.068667 |  | 5
 |  | 13 | 7 | RATMO |  | Z998 | H |  | AUS | 52.705333 | 12.429667 |  | 5
 |  | 12 | 8 | NISGA |  | Z998 | H |  | AUS | 52.2495 | 12.876167 |  | 5
 |  | 11 | 9 | GODUR |  | Z998 | H |  | AUS | 51.8305 | 13.279667 |  | 5
 |  | 10 | 10 | OSKAN |  | Z998 | H |  | AUS | 51.460833 | 13.627833 |  | 5
 |  | 3 | 1 | RATMO |  | Z997 | H |  | AUS | 52.705333 | 12.429667 |  | 5
 |  | 2 | 2 | SUI |  | Z997 | H |  | AUS | 52.379856 | 14.585603 |  | 3
 |  | 11 | 1 | NOBTO |  | Z994 | H |  | AUS | 23.923611 | 55.311111 |  | 5
 |  | 10 | 2 | [NAME] |  | Z994 | H |  | AUS | 24.316667 | 54.733333 |  | 5
 |  | 9 | 3 | TOXIG |  | Z994 | H |  | AUS | 24.533333 | 53.917222 |  | 5
 |  | 8 | 4 | DASLA |  | Z994 | H |  | AUS | 24.629722 | 53.546667 |  | 5
 |  | 7 | 5 | VEBAT |  | Z994 | H |  | AUS | 24.808333 | 52.85 |  | 5
 |  | 6 | 6 | BUNDU |  | Z994 | H |  | AUS | 25.006667 | 52.49 |  | 5
 |  | 13 | 1 | HLZ |  | Z990 | H |  | AUS | 52.363395 | 10.79522 |  | 3
 |  | 12 | 2 | DIRBO |  | Z990 | H |  | AUS | 52.832167 | 10.844167 |  | 5
 |  | 11 | 3 | IRKIS |  | Z990 | H |  | AUS | 53.248833 | 10.888667 |  | 5
 |  | 10 | 4 | ABMAL |  | Z990 | H |  | AUS | 53.442 | 10.912 |  | 5
 |  | 9 | 5 | RAMAR |  | Z990 | H |  | AUS | 53.710833 | 10.938834 |  | 5
 |  | 8 | 6 | [NAME] |  | Z990 | H |  | AUS | 54.113889 | 10.983611 |  | 5
 |  | 7 | 7 | MIC |  | Z990 | H |  | AUS | 54.305461 | 11.005186 |  | 3
 |  | 3 | 1 | RIMKI |  | [NAME] | H |  | AUS | 49.748833 | 9.363833 |  | 5
 |  | 2 | 2 | LOHRE |  | [NAME] | H |  | AUS | 50.067 | 9.486333 |  | 5
 |  | 9 | 1 | FER |  | Z982 | H |  | AUS | 44.8145 | 11.616333 |  | 3
 |  | 8 | 2 | GIPUK |  | Z982 | H |  | AUS | 44.588611 | 11.966667 |  | 5
 |  | 7 | 3 | RIBKI |  | Z982 | H |  | AUS | 44.514722 | 12.080833 |  | 5
 |  | 6 | 4 | DITUM |  | Z982 | H |  | AUS | 44.405833 | 12.247222 |  | 5
 |  | 5 | 5 | BAKEP |  | Z982 | H |  | AUS | 44.176944 | 12.594722 |  | 5
Spreadsheet: 100064d1298539047-3d-cell-referencing-help-bracknell-start
Sheet: targets

 | Bracknell |  |  |  |  | Wokingham
 | [NAME] | 200000 |  |  |  | Name#1 | 200000
 | [NAME] | 300000 |  |  |  | Name#2 | 300000
 | Campbell | 200000 |  |  |  | [NAME] | 200000
 | [NAME] | 300000 |  |  |  | Name#4 | 300000
 | Finch | 200000 |  |  |  | Name#5 | 200000
 | Martin | 300000 |  |  |  | Name#6 | 300000
 | [NAME] | 200000 |  |  |  | Name#7 | 200000
 | [NAME] | 200000 |  |  |  | Name#8 | 200000
 | Wilson | 300000 |  |  |  | Name#9 | 300000
Spreadsheet: 110323d1307028953-make-a-chart-excel-evaluation-results_060211
Sheet: Excel Evaluation Result

 | Number scores in Basic |  |  | Number scores in Advance |  | Advance Total Result | Overall Total
Name | Objective | Practical | Basic Total Result | Objective | Practical
Derek | 8 | 3 | 11 | 6 | 7 | 13 | 24
Kittu | 8 | 2 | 10 | 0 | 3 | 3 | 13
Saul | 2 | 1 | 3 | 2 | 0 | 2 | 5
Alvin | 5 | 2 | 7 | 1 | 0 | 1 | 8
[NAME] | 9 | 9 | 18 | 4 | 6 | 10 | 28
[NAME] | 7 | 0 | 7 | 0 | 0 | 0 | 7
[NAME] | 7 | 2 | 9 | 0 | 2 | 2 | 11
Stella | 7 | 7 | 14 | 3 | 2 | 5 | 19
Mark | 7 | 4 | 11 | 5 | 2 | 7 | 18
[NAME] | 4 | 3.5 | 7.5 | 8 | 0 | 8 | 15.5
Alfred | 8 | 6 | 14 | 5 | 0 | 5 | 19
[NAME] | 7 | 4.5 | 11.5 | 5 | 2 | 7 | 18.5
Sawer | 6 | 5 | 11 | 3 | 0 | 3 | 14
[NAME] | 9 | 0 | 9 | 3 | 0 | 3 | 12
[NAME] | 6 | 4.5 | 10.5 | 6 | 3 | 9 | 19.5
Dillon | 0 | 2.5 | 2.5 | 3 | 0 | 3 | 5.5
[NAME] | 5 | 3 | 8 | 4 | 0 | 4 | 12
[NAME] | Not Apperared | Not Apperared | Not Apperared | 0 | Not Apperared | 0 | 0
[NAME] | Not Apperared | Not Apperared | Not Apperared | 3 | Not Apperared | 3 | 3
Spreadsheet: 31450d1227283016-multiple-sort-a-group-of-cells-on-same-worksheet-racing-team-fixed-
Sheet: SM 

[NAME]
Category | Slip - 1 | Pts | [NAME] | Pts | Slip - 3 | Pts
Dial In | 10.5 |  | 9.44 |  | 8.501
ET | 10.501 |  | 9.54 |  | 8.501
Difference | 0.0009999999999994458 |  | 0.09999999999999964 |  | 0
RT
60FT
Attendance | 1 | 1 | 1 | 1 | 1 | 1
> 3/10 | 0 | 0 | 0 | 0 | 0 | 0
2/10 - 3/10 | 0 | 0 | 0 | 0 | 0 | 0
1/10 - 2/10 | 0 | 0 | 0 | 0 | 0 | 0
1/100 - 1/10 | 1 | 30 | 1 | 30 | 0 | 0
New ET Best 1 |  | 0 |  | 0 |  | 0
New ET Best 2 |  | 0 |  | 0 |  | 0
New ET Best 3 |  | 0 |  | 0 |  | 0
New 60ft Best 1 |  | 0 |  | 0 |  | 0
New 60ft Best 2 |  | 0 |  | 0 |  | 0
New 60ft Best 3 |  | 0 |  | 0 |  | 0
Light 1 |  | 0 |  | 0 |  | 0
Light 2 |  | 0 |  | 0 |  | 0
Light 3 |  | 0 |  | 0 |  | 0
Index |  | 0 |  | 0 |  | 0
Exact Dial | 0 | 0 | 0 | 0 | 1 | 40
Sub-Total | 2 | 31 | 2 | 31 | 2 | 41 | 109
Ashley Force
Category | Slip - 1 | Pts | [NAME] | Pts | Slip - 3 | Pts
Dial In | 12.41 |  | 12.41 |  | 12.41
ET | 12.42 |  | 12.522 |  | 12.499
Difference | 0.009999999999999787 |  | 0.1120000000000001 |  | 0.08900000000000041
RT
60FT
Attendance | 1 | 1 | 1 | 1 | 1 | 1
> 3/10 | 0 | 0 | 0 | 0 | 0 | 0
2/10 - 3/10 | 0 | 0 | 0 | 0 | 0 | 0
1/10 - 2/10 | 0 | 0 | 1 | 15 | 0 | 0
1/100 - 1/10 | 1 | 30 | 0 | 0 | 1 | 30
New ET Best 1 | 1 | 10 |  | 0 |  | 0
New ET Best 2 |  | 0 | 1 | 10 |  | 0
New ET Best 3 |  | 0 |  | 0 | 1 | 10
New 60ft Best 1 | 1 | 10 |  | 0 |  | 0
New 60ft Best 2 |  | 0 | 1 | 10 |  | 0
New 60ft Best 3 |  | 0 |  | 0 | 1 | 10
Light 1 |  | 0 |  | 0 |  | 0
Light 2 |  | 0 |  | 0 |  | 0
Light 3 |  | 0 |  | 0 |  | 0
Index |  | 0 |  | 0 |  | 0
Exact Dial | 0 | 0 | 0 | 0 | 0 | 0
Sub-Total | 4 | 51 | 4 | 36 | 4 | 51 | 150
[NAME]
Category | Slip - 1 | Pts | [NAME] | Pts | Slip - 3 | Pts
Dial In | 12.41 |  | 12.41 |  | 12.41
ET | 12.42 |  | 12.522 |  | 12.499
Difference | 0.009999999999999787 |  | 0.1120000000000001 |  | 0.08900000000000041
RT
60FT
Attendance | 1 | 1 | 1 | 1 | 1 | 1
> 3/10 | 0 | 0 | 0 | 0 | 0 | 0
2/10 - 3/10 | 0 | 0 | 0 | 0 | 0 | 0
1/10 - 2/10 | 0 | 0 | 1 | 15 | 0 | 0
1/100 - 1/10 | 1 | 30 | 0 | 0 | 1 | 30
New ET Best 1 |  | 0 |  | 0 |  | 0
New ET Best 2 |  | 0 |  | 0 |  | 0
New ET Best 3 |  | 0 |  | 0 |  | 0
New 60ft Best 1 |  | 0 |  | 0 |  | 0
New 60ft Best 2 |  | 0 |  | 0 |  | 0
New 60ft Best 3 |  | 0 |  | 0 |  | 0
Light 1 | 1 | 5 |  | 0 |  | 0
Light 2 |  | 0 | 1 | 5 |  | 0
Light 3 |  | 0 |  | 0 | 1 | 5
Index | 1 | 5 |  | 0 |  | 0
Exact Dial | 0 | 0 | 0 | 0 | 0 | 0
Sub-Total | 4 | 41 | 3 | 21 | 3 | 36 | 108
Spreadsheet: 143463d1330434075-excel-2007-collecting-information-0169
Sheet: Sheet1

 |  | converted data
 |  | name | login | Logout
 |  | A | 14:00:00 | 23:00:00 | 14:00:00 | 23:00:00
 |  | B | 07:49:00 | 17:00:00 | 07:49:00 | 17:00:00
 |  | C | 09:01:00 | 17:30:00 | 09:01:00 | 09:01:00
 |  | D | 07:58:00 | 17:00:00 | 07:58:00 | 17:00:00
 |  | E | 16:58:00 | 04:59:00 | 16:58:00 | 04:59:00
 |  | F | 09:31:00 | 18:36:00 | 09:31:00 | 18:36:00
 |  | G | 07:29:00 | 16:08:00 | 07:29:00 | 16:08:00
 |  | H | 06:59:00 | 16:16:00 | 06:59:00 | 16:16:00
 |  | I | 09:01:00 | 09:01:00 | 09:01:00 | 09:01:00
 |  | J | 09:01:00 | 09:01:00 | 09:01:00 | 10:01:00
 |  | K | 05:51:00 | 15:02:00 | 05:51:00 | 15:02:00
 |  | X |  |  | #N/A | 15:02:00
Spreadsheet: 30237aa0-36dc-44eb-b085-0e357c9b01e4
Sheet: Sheet1

When we visit | L'holders | Total L'holders | % need
Require Home Visit | 17 | 12903 | 0.001317523056653491
Contact Via 3rd Party | 40 | 12903 | 0.003100054250949392
At Visit Give Plenty Of Time At The Door | 196 | 12903 | 0.01519026582965202
Knock Loudly | 141 | 12903 | 0.01092769123459661
Communication needs | L'holders | Total L'holders | % need
Communication Support Needed | 11 | 12902 | 0.0008525809951945434
Literacy | <10 | 12903 | <0.08%
Speech (British Sign Language) | <10 | 12903 | <0.08%
Speech (Other) | <10 | 12903 | <0.08%
Written Communication Format Needed | 113 | 12903 | 0.008757653258932031
[NAME] | <10 | 12903 | <0.08%
Braille | <10 | 12903 | <0.08%
CD | <10 | 12903 | <0.08%
Large Print Standard | 93 | 12903 | 0.007207626133457335
Others | <10 | 12903 | <0.08%
Language Needed Spoken | 328 | 12903 | 0.02542044485778501
Bengali | 311 | 12903 | 0.02410292180113152
Others | 15 | 12903 | 0.001162520344106022
Somali | <10 | 12903 | <0.08%
Cantonese | <10 | 12903 | <0.08%
Language Needed Written | 298 | 12903 | 0.02309540416957297
Bengali | 277 | 12903 | 0.02146787568782454
Others | 17 | 12903 | 0.001317523056653491
Somali | <10 | 12903 | <0.08%
Cantonese | <10 | 12903 | <0.08%