tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86066d1286065355-conditional-formats-using-symbols-milestone-20listing-20rev-202-1-
Sheet: Sheet1

 | [NAME] GTL Project - Key Milestones |  |  |  |  |  | 2010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011
 |  |  |  |  |  | 2010-08-27 00:00:00 | 2010-09-03 00:00:00 |  |  |  | 2010-10-01 00:00:00 |  |  |  |  | 2010-11-05 00:00:00 |  |  |  | 2010-12-03 00:00:00 |  |  |  |  | 2011-01-07 00:00:00 |  |  |  | 2011-02-04 00:00:00 |  |  |  | 2011-03-04 00:00:00 |  |  |  | 2011-04-01 00:00:00 |  |  |  |  | 2011-05-06 00:00:00 |  |  |  | 2011-06-03 00:00:00
 | Milestone | Start Date | August PRAP | Current Forecast | Actual Date | 2010-08-27 00:00:00 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | 2010-09-17 00:00:00 | 2010-09-24 00:00:00 | 2010-10-01 00:00:00 | 2010-10-08 00:00:00 | 2010-10-15 00:00:00 | 2010-10-22 00:00:00 | 2010-10-29 00:00:00 | 2010-11-05 00:00:00 | 2010-11-12 00:00:00 | 2010-11-19 00:00:00 | 2010-11-26 00:00:00 | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-17 00:00:00 | 2010-12-24 00:00:00 | 2010-12-31 00:00:00 | 2011-01-07 00:00:00 | 2011-01-14 00:00:00 | 2011-01-21 00:00:00 | 2011-01-28 00:00:00 | 2011-02-04 00:00:00 | 2011-02-11 00:00:00 | 2011-02-18 00:00:00 | 2011-02-25 00:00:00 | 2011-03-04 00:00:00 | 2011-03-11 00:00:00 | 2011-03-18 00:00:00 | 2011-03-25 00:00:00 | 2011-04-01 00:00:00 | 2011-04-08 00:00:00 | 2011-04-15 00:00:00 | 2011-04-22 00:00:00 | 2011-04-29 00:00:00 | 2011-05-06 00:00:00 | 2011-05-13 00:00:00 | 2011-05-20 00:00:00 | 2011-05-27 00:00:00 | 2011-06-03 00:00:00 | 2011-06-10 00:00:00 | 2011-06-17 00:00:00 | 2011-06-24 00:00:00
 | Complete Project | 2010-08-27 00:00:00 | 2011-06-30 00:00:00 |  |  | 1
 | C2 ASU
 | ASU #4
 | IP Steam Turbine Quality | 2010-11-08 00:00:00 | 2010-11-08 00:00:00 | 2010-12-25 00:00:00 | 2011-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | ▼ |  |  |  |  |  |  | ◊ | ▲
 | 1st, 2nd & 3rd GTG for Steam Supply | 2010-11-22 00:00:00 | 2010-11-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▼ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | &(IF(AND($C7>J$3,$D7<=K$3),"`","")))
 | Solo Run Steam Turbine | 2010-12-06 00:00:00 | 2010-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▼
 | MAC / BAC Surge Testing | 2010-12-20 00:00:00 | 2010-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▼
 | Dry Cold Box | 2011-01-03 00:00:00 | 2011-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▼
 | Test Run Expanders & Booster Turbines | 2011-01-17 00:00:00 | 2011-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▼
 | Cool Down Cold Box | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▼
 | ASU #4 Start Up | 2011-02-05 00:00:00 | 2011-02-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▼
 |  | ▼ | ▲
 |  | If I delete values in E7 & F7 I loose the Symbols.
 |  | I wish to show all the 3 Symbols when Colums E & F are blank
Spreadsheet: 34787d1232130590-values-formula-copy-of-new-order-entry-in-progress-2-
Sheet: LISTS

 | postDIA | postSCH | postLENGTH |  |  |  |  |  |  |  | 3" | 3 1/2" | 4"
Beams | JP DIA. | SCH | LENGTH | COUNTY | TAX RATE | MATL | STEEL $ | PRIMER | QTY |  | COST | COST | COST
 |  |  |  |  |  |  |  |  |  | 6'-0 to 6'-4" | 18.85 | 20.68 | 22.61
[NAME] | 3" | 11 GA | 7'-3" to 7'-7" | Defiance | 0.065 | Stock | 0.43 | YES | 1 | 6'-3" to 6'-7" | 19.24 | 21.15 | 23.14
[NAME] | 3 1/2" | SCH 40 | 8'-0" to 8'-4" | Delaware | 0.0675 | Purchase | 0.47 | NO | 2 | 6'-6" to 6'-10" | 19.64 | 21.62 | 23.68
[NAME] 15 | 4" | SCH 80 | 8'-3" to 8'-7" | Erie | 0.065 |  |  |  | 3 | 6'-9" to 7'-1" | 20.04 | 22.08 | 24.21
[NAME] |  |  | 9'-0" to 9'-4" | Fayette | 0.065 |  |  |  | 4 | 7'-0" to 7'-4" | 20.44 | 22.55 | 24.75
W6 X 20 |  |  | Other | Fulton | 0.065 |  |  |  | 5 | 7'-3" to 7'-7" | 20.83 | 23.02 | 25.28
[NAME] |  |  |  | Hancock | 0.06 |  |  |  | 6 | 7'-6" to 7'-10" | 21.23 | 23.49 | 25.81
W8 X 10 |  |  |  | Hardin | 0.07 |  |  |  | 7 | 7'-9" to 8'-1" | 21.63 | 23.95 | 26.35
W8 X 13 |  |  |  | [NAME] | 0.07 |  |  |  | 8 | 8'-0" to 8'-4" | 22.03 | 24.42 | 26.88
W8 X 15 |  |  |  | Huron | 0.07 |  |  |  | 9 | 8'-3" to 8'-7" | 22.43 | 24.89 | 27.42
W8 X 18 |  |  |  | Lake | 0.0625 |  |  |  | 10 | 8'-6" to 8'-10" | 22.82 | 25.35 | 27.95
W8 X 21 |  |  |  | Lucas | 0.0675 |  |  |  | 11 | 8'-9" to 9'-1" | 23.22 | 25.82 | 28.49
W8 X 24 |  |  |  | [NAME] | 0.0675 |  |  |  | 12 | 9'-0" to 9'-4" | 23.62 | 26.29 | 29.02
W8 X 28 |  |  |  | Monroe | 0.07 |  |  |  | 13 | 9'-3" to 9'-7" | 24.02 | 26.75 | 29.55
W8 X 31 |  |  |  | Ottawa | 0.065 |  |  |  | 14 | 9'-6" to 9'-10" | 24.41 | 27.22 | 30.09
W8 X 35 |  |  |  | Paulding | 0.07 |  |  |  |  | 9'-9" to 10'-1" | 24.81 | 27.69 | 30.62
W8 X 40 |  |  |  | Sandusky | 0.0675 |  |  |  |  | 10'-0" to 10'-4" | 25.21 | 28.15 | 31.16
W8 X 48 |  |  |  | Seneca | 0.07 |  |  |  |  | 10'-3" to 10'-7" | 25.61 | 28.62 | 31.69
W8 X 58 |  |  |  | Van Wert | 0.07 |  |  |  |  | 10'-6" to 10'-10" | 26.01 | 29.09 | 32.23
W8 X 67 |  |  |  | [NAME] | 0.065 |  |  |  |  | 10'-9" to 11'-1" | 26.4 | 29.55 | 32.76
W10 X 12 |  |  |  | Wood | 0.065 |  |  |  |  | 11'-0" to 11'-4" | 26.8 | 30.02 | 33.29
W10 X 15 |  |  |  | [NAME]. |  |  |  |  |  | 11'-3" to 11'-7" | 27.2 | 30.49 | 33.83
W10 X 17 |  |  |  | [NAME]. |  |  |  |  |  | 11'-6" to 11'-10" | 27.6 | 30.95 | 34.36
W10 X 19 |  |  |  |  |  |  |  |  |  | 11'-9" to 12'-1" | 28 | 31.42 | 34.9
W10 X 22 |  |  |  |  |  |  |  |  |  | 12'-0" to 12'-4" | 28.39 | 31.89 | 35.43
W10 X 26
W10 X 30
W10 X 33
W10 X 39
W10 X 45
W10 X 49
W10 X 54
W10 X 60
W10 X 68
W10 X 100
W10 X 112
W12 X 14
W12 X 16
W12 X 19
W12 X 22
W12 X 26
W12 X 30
W12 X 35
W12 X 40
W12 X 45
W12 X 50
W12 X 53
W12 X 58
W12 X 65
W12 X 72
W12 X 79
W12 X 87
W12 X 96
W12 X 106
W12 X 120
W14 X 22
W14 X 26
W14 X 30
W14 X 34
W14 X 38
W14 X 43
W14 X 48
W14 X 53
W14 X 61
W14 X 68
W14 X 74
W14 X 82
W14 X 90
W14 X 99
Spreadsheet: 268526d1380665419-desired-multiple-data-into-single-cell-09-13
Sheet: DEPT

ON DEPUTATION DUTIES FOR OTHER  DEPARTMENTS OF NIRMAL DIVISION FOR THE MONTH OF SEPTEMBER - 2013
Sl. No. | [NAME]. | Name | Place of Working | Total HGs
1 | 823 | Azar [NAME] | [NAME], Nirmal | 3
2 | 833 | D.Prakash [NAME] | [NAME], Nirmal
3 | 354 | [NAME] | [NAME], Nirmal
4 | 817 | SK. JAFFAR | Telephone Exchange, Narsapur | 1
5 | 826 | K.Narender | APSRTC, Nirmal | 2
6 | 368 | Suresh | APSRTC, Nirmal wef 28.08.2013
7 | 1018 | S Kiran Kumar | Sub Jail, Nirmal | 1
8 | 31 | [NAME] | R T O Nirmal | 3
9 | 992 | [NAME] | R T O Nirmal
10 | 1007 | M.Muthyam | R T O Bhainsa
11 | 336 | N Rajeshwar | Central Ware House, Nirmal | 3
12 | 344 | D Laxman | Central Ware House, Nirmal
13 | 1015 | [NAME] | Central Ware House, Nirmal
 |  |  | Total | 13
Spreadsheet: 56385d1256584097-excel-2007-sumif-formula-that-averages-weekly-data-monthly-report
Sheet: Monthly Review

 |  |  | Monthly  Percentages
 | Technician |  |  |  | Work Comp % | QC Pass % | Activation Server % | VOD %
 | 1 | [NAME]
 | 2 | [NAME]
 | 3 | [NAME]
 | 4 | [NAME]
 | 5 | [NAME]
 | 6 | [NAME]
 | 7 | [NAME]
 | 8 | [NAME]
 | 9 | [NAME]
 | 10 | [NAME]
 | 11 | [NAME]
 | 12 | [NAME]
 | 13 | [NAME]
 | 14 | [NAME]
 | 15 | [NAME]
 | 16 | [NAME]
 | 17 | [NAME]
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 6a5f790f-ee45-4161-ba71-5148d3ed9637
Sheet: Sheet1

Travel Expense Reconciliation Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Please enter data, print, obtain proper signatures, attach receipts, and submit to the Business Office within 10 days of travel completion
Name |  |  |  | Date(s)
Department/Program |  |  |  | Purpose
Account Number
Categories | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Totals
Airline |  |  |  |  |  |  |  | 0
Hotel |  |  |  |  |  |  |  | 0
Parking, Taxi, Tolls |  |  |  |  |  |  |  | 0
Telephone |  |  |  |  |  |  |  | 0
Gratuities |  |  |  |  |  |  |  | 0
Other |  |  |  |  |  |  |  | 0
Rental Car |  |  |  |  |  |  |  | 0
-AND-
Gas for rental |  |  |  |  |  |  |  | 0
-OR-
Personal Auto (www.gsa.gov) |  |  |  |  |  |  |  | 0
Total Auto Exp. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Actual Food:
Breakfast |  |  |  |  |  |  |  | 0
Lunch |  |  |  |  |  |  |  | 0
Dinner |  |  |  |  |  |  |  | 0
-OR-
Daily Estimated Food ($25/day) |  |  |  |  |  |  |  | 0
Total Food Exp. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Entertainment Detail: |  |  |  |  |  |  |  | 0
Person(s) |  |  |  |  |  |  |  | 0
Company |  |  |  |  |  |  |  | 0
Position/Title |  |  |  |  |  |  |  | 0
Time |  |  |  |  |  |  |  | 0
Purpose |  |  |  |  |  |  |  | 0
Amount |  |  |  |  |  |  |  | 0
Report Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less: Travel Advance (attach copy of travel advance request and check stub)
Total Reimbursement |  |  |  |  |  |  |  | 0
Originator ___________________________________ |  |  | Authorization _______________________________ |  |  | Restricted Auth. ____________________________
 |  | Date |  |  | Date |  |  | Date
Business Office Verification _____________________________________________________________________________   Date _________________
Spreadsheet: 43046d1241638655-using-a-lookup-then-skip-rows-sample-1-
Sheet: Data

 |  | Name | Country
 |  | a | us
 |  | b | japan
 |  | c | russia
 |  | d | us
 |  | e | japan
 |  | f | russia
 |  | g | us
 |  | h | japan
 |  | i | russia
 |  | j | us
 |  | k | japan
 |  | l | russia
 |  | m | us
 |  | p | japan
 |  | o | russia
Spreadsheet: 705814d1606317020-else-if-function-not-working-tableau_dpa
Sheet: Variables

Langue | [NAME] | Facteur de Référence | Ligne du Tableau A | [NAME] du facteur de référence | Gabarit DPA
Français | 8 | 0.5 | 1 |  | T776
Anglais | 10 |  | 2 |  | T777
 | 10.1 |  | 3 |  | T2125
 | 12 | 0 | 4
 | 13 |  | 5
 | 14 |  | 6
 | 15 |  | 7
 | 43.1 |  | 8
 | 54
 | 43.2 | 1
 | 53
 | 55 | 1.5
Spreadsheet: 755231d1636728906-transpose-horizontal-to-vertical-test
Sheet: Sheet1

Names | Area 1 | Area 2 | Area 3 | Area 4 | Area 5 | Area 6 | Area 7 |  | Area | Name
Adis | 1 | 2 | 3
Joé | 10 | 11 | 12 | 13 | 14 | 15 | 16
[NAME] | 20 | 21 | 22 | 23
[NAME] | 30 | 31 | 32 | 33 | 34 | 35
[NAME] | 40 | 41 | 42 | 43 | 44
Grégory | 50 | 51
Henri | 60 | 61 | 62 | 63 | 64 | 65
[NAME] | 70
Fabio | 80 | 81 | 82 | 83 | 84 | 85 | 86
Spreadsheet: 72617d1273314357-how-to-sort-league-tables-automatically-based-on-changing-forecasts-world-cup-forecaster
Sheet: Sheet1

 |  | Forecast
 |  | Here
 | Group A |  |  |  |  |  | Pts | Pts |  |  |  | Team | Pts
 | South Africa | W | V | Mexico |  |  |  |  |  |  |  | France
 | Uruguay | L | V | France |  |  |  |  |  |  |  | South Africa
 | France | W | V | South Africa |  |  |  |  |  |  |  | Mexico
 | Mexico | D | V | Uruguay |  |  |  |  |  |  |  | Uruguay
 | Mexico | D | V | France
 | Uruguay | L | V | South Africa
 | Group B
 | South Korea | D | V | Greece |  |  |  |  |  |  |  | South Korea
 | Argentina | W | V | Nigeria |  |  |  |  |  |  |  | Greece
 | Argentina | W | V | South Korea |  |  |  |  |  |  |  | Argentina
 | Greece | L | V | Nigeria |  |  |  |  |  |  |  | Nigeria
 | Argentina | W | V | Greece
 | South Korea | L | V | Nigeria
 | Group C
 | England | W | V | USA |  |  |  |  |  |  |  | England
 | Algeria | D | V | Slovenia |  |  |  |  |  |  |  | USA
 | England | W | V | Algeria |  |  |  |  |  |  |  | Slovenia
 | USA | W | V | Slovenia |  |  |  |  |  |  |  | Algeria
 | England | W | V | Slovenia
 | USA | W | V | Algeria
 | Group D
 | Serbia | D | V | Ghana |  |  |  |  |  |  |  | Serbia
 | Germany | W | V | Australia |  |  |  |  |  |  |  | Ghana
 | Germany | W | V | Serbia |  |  |  |  |  |  |  | Australia
 | Ghana | D | V | Australia |  |  |  |  |  |  |  | Germany
 | Australia | D | V | Serbia
 | Germany | W | V | Ghana
 | Group E
 | Holland | W | V | Denmark |  |  |  |  |  |  |  | Holland
 | Japan | D | V | Cameroon |  |  |  |  |  |  |  | Denmark
 | Holland | W | V | Cameroon |  |  |  |  |  |  |  | Japan
 | Japan | D | V | Denmark |  |  |  |  |  |  |  | Cameroon
 | Cameroon | L | V | Denmark
 | Japan | L | V | Holland
 | Group F
 | Italy | W | V | Paraguay |  |  |  |  |  |  |  | Italy
 | New Zealand | L | V | Slovakia |  |  |  |  |  |  |  | New Zealand
 | Slovakia | D | V | Paraguay |  |  |  |  |  |  |  | Slovakia
 | New Zealand | L | V | Italy |  |  |  |  |  |  |  | Paraguay
 | Paraguay | W | V | New Zealand
 | Slovakia | L | V | Italy
 | Group G
 | Ivory Coast | W | V | Portugal |  |  |  |  |  |  |  | Ivory Coast
 | Brazil | W | V | North Korea |  |  |  |  |  |  |  | Brazil
 | Brazil | W | V | Ivory Coast |  |  |  |  |  |  |  | North Korea
 | Portugal | W | V | North Korea |  |  |  |  |  |  |  | Portugal
 | North Korea | L | V | Ivory Coast
 | Brazil | D | V | Portugal
 | Group H
 | Honduras | L | V | Chile |  |  |  |  |  |  |  | Honduras
 | Spain | W | V | Switzerland |  |  |  |  |  |  |  | Spain
 | Chile | D | V | Switzerland |  |  |  |  |  |  |  | Chile
 | Spain | W | V | Honduras |  |  |  |  |  |  |  | Switzerland
 | Chile | L | V | Spain
 | Switzerland | W | V | Honduras
Spreadsheet: 52777d1252595484-linking-pivot-tables-to-one-another-example
Sheet: Sheet4

Sum of DATA3 | DATA2 |  |  |  |  |  | Sum of DATA3 | DATA2
[NAME] | 4 | 7 | 8 | 11 | Grand Total |  | [NAME] | 4 | 7 | 8 | 11 | Grand Total
3 | 5 |  |  |  | 5 |  | 3 | 5 |  |  |  | 5
4 |  | 10 |  |  | 10 |  | 4 |  | 10 |  |  | 10
6 |  |  | 10 |  | 10 |  | 6 |  |  | 10 |  | 10
7 |  |  |  | 15 | 15 |  | 7 |  |  |  | 15 | 15
Grand Total | 5 | 10 | 10 | 15 | 40 |  | Grand Total | 5 | 10 | 10 | 15 | 40
Spreadsheet: c48a7bdd-413f-48b2-9e06-68bf56aaaad5
Sheet: Operating

OPERATING/PROGRAMMATIC |  |  |  |  |  |  | 120598
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Deconstruction and demolition of abandoned houses in the Green Impact Zone
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2012-13 |  |  | FY 2013-14
 | General Fund |  |  |  | 150000 |  |  | 0
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | The funds are earmarked for serving homeless and/or near homeless.
 | Revenue |  | 1000-100000-486060
 | Expenditure |  | 1000-108027-B
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | x | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2012-13 |  |  | FY 2013-14
 | General Fund |  |  |  | 150000 |  |  | 0
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 91529d1291231487-format-as-percentage-example6
Sheet: Sheet1

0.9520000000000001 | 95.2 | 100
0.6679999999999999 | 66.8 | 100
0.6970000000000001 | 69.7 | 100
0.6940000000000001 | 69.4 | 100
0.995 | 99.5 | 100
0.662 | 66.2 | 100
0.228 | 22.8 | 100
Spreadsheet: 468758d1467514737-what-is-the-best-formula-for-a-lottery-worksheet-bingo-lottery-sample
Sheet: Numbers

Paid                 up to |  | Lottery Numbers | The New Inn IRISH Lottery Bingo (21)
 |  | 2016-07-02 00:00:00 |  |  |  |  |  |  |  |  | Week |  | [NAME]
 | 1 | [NAME] | 2 | 8 | 11 | 20 | 25 | 29 |  | Week 1 | 2016-03-05 00:00:00 | 2 | 11 | 6 | 20 | 25 | 12
 | 2 | Clair | 3 | 7 | 12 | 19 | 28 | 29 |  | Week 2 | 2016-03-12 00:00:00 | 2 | 4 | 5 | 6 | 7 | 8
 | 3 | [NAME] | 1 | 13 | 19 | 24 | 30 | 49 |  | Week 3 | 2016-03-19 00:00:00
 | 4 | Connor | 1 | 3 | 5 | 7 | 9 | 15 |  | Week 4 | 2016-03-26 00:00:00
 | 5 | Dale | 3 | 22 | 25 | 35 | 45 | 46 |  | Week 5 | 2016-04-02 00:00:00
 | 6 | [NAME] | 1 | 4 | 5 | 17 | 20 | 31 |  | Week 6 | 2016-04-09 00:00:00
 | 7 | Elsie  ([NAME]) | 3 | 7 | 21 | 31 | 40 | 45 |  | Week 7 | 2016-04-16 00:00:00
 | 8 | Enisha                ~ | 3 | 8 | 12 | 29 | 37 | 44 |  | Week 8 | 2016-04-23 00:00:00
 | 9 | Fred | 3 | 12 | 24 | 30 | 31 | 45 |  | Week 9 | 2016-04-30 00:00:00
 | 10 | Gally | 5 | 14 | 26 | 31 | 35 | 42 |  | Week 10 | 2016-05-07 00:00:00
 | 11 | [NAME]     * | 12 | 16 | 21 | 43 | 48 | 49
 | 12 | Ged                    ~ | 1 | 3 | 9 | 16 | 22 | 47
 | 13 | Gee | 2 | 3 | 10 | 15 | 27 | 48
 | 14 | [NAME] | 3 | 11 | 22 | 32 | 33 | 44
 | 15 | [NAME] | 4 | 7 | 8 | 12 | 32 | 38
 | 16 | [NAME] | 7 | 11 | 23 | 26 | 35 | 42
 | 17 | [NAME] | 4 | 11 | 12 | 19 | 36 | 40
 | 18 | June                   ~ | 3 | 8 | 14 | 19 | 22 | 29
 | 19 | Karan & Paul     * | 2 | 7 | 9 | 16 | 25 | 29
 | 20 | [NAME] | 3 | 17 | 21 | 28 | 32 | 45
 | 21 | [NAME] | 2 | 10 | 21 | 31 | 32 | 43
 | 22 | Kev C | 4 | 7 | 11 | 18 | 19 | 22
 | 23 | [NAME] | 3 | 11 | 22 | 46 | 47 | 48
 | 24 | [NAME] | 39 | 40 | 41 | 42 | 43 | 49
 | 25 | [NAME] | 7 | 13 | 16 | 17 | 21 | 44
 | 26 | Lynda | 8 | 14 | 25 | 31 | 43 | 47
 | 27 | [NAME]~ | 4 | 14 | 31 | 37 | 44 | 47
 | 28 | [NAME] | 12 | 15 | 16 | 22 | 31 | 37
 | 29 | [NAME] | 3 | 18 | 25 | 32 | 41 | 47
 | 30 | [NAME] | 7 | 14 | 17 | 21 | 36 | 41
 | 31 | [NAME] | 1 | 6 | 7 | 13 | 17 | 27
 | 32 | Paddy               * | 7 | 14 | 19 | 27 | 37 | 38
 | 33 | [NAME] | 9 | 13 | 21 | 23 | 42 | 43
 | 34 | [NAME] * | 2 | 11 | 23 | 28 | 30 | 45
 | 35 | [NAME] | 23 | 25 | 31 | 33 | 38 | 43
 | 36 | [NAME] | 7 | 9 | 21 | 22 | 31 | 32
 | 37 | [NAME] | 3 | 8 | 14 | 17 | 31 | 41
 | 38 | [NAME] | 1 | 5 | 10 | 19 | 22 | 29
 | 39 | [NAME] & [NAME] | 1 | 10 | 14 | 15 | 17 | 49
 | 40 | [NAME] | 3 | 11 | 15 | 17 | 21 | 22
 | 41 | Sid | 4 | 13 | 16 | 22 | 29 | 44
 | 42 | [NAME] | 6 | 11 | 14 | 17 | 26 | 31
 | 43 | [NAME] | 2 | 6 | 5 | 13 | 23 | 49
 | 44 | Sue                  ** | 13 | 17 | 19 | 31 | 33 | 43
 | 45 | [NAME] | 8 | 10 | 11 | 14 | 20 | 23
 | 46 | Trevor | 4 | 11 | 17 | 21 | 38 | 46
 | 47 | [NAME] | 3 | 7 | 15 | 30 | 33 | 42
 | If you have NOT paid before the draw your numbers WONT count for that week |  |  |  |  |  |  |  | People who owe
 |  |  |  |  |  |  |  |  | [NAME] 3
 |  |  |  |  |  |  |  |  | Fred x 1
Spreadsheet: 804526d1668123901-excel-formula-for-mapping-to-a-common-index-range-health-index-table-example
Sheet: Sheet1

 |  |  |  |  | Excel formula: =MIN(MAX(80*(PI-Base)/(Target-Base);-20;100). Will need to figure out how to make it work.
 |  |  |  |  | calc | we assign | calc
Performance indicator | Unit | Base | Target | Actual | Index points | Weight | Weighted points
Days to clear backlog (the less the better) | Days | 5 | 3 | 2 |  | 0.1
Time to resolve [NAME] (by prioirty) (the less the better) | Days | 14 | 10 | 10 |  | 0.15
Time to resolve P75 (by priority) (the less the better) | Days | 12 | 8 | 8 |  | 0.15
CSAT (max 5) | 1 to 5 | 4.4 | 4.5 | 5 |  | 0.2
Var to required capacity (negative bad, positive good) | % | -0.1 | -0.05 | -0.05 |  | 0.2
IR Met % (max 100%) | % | 0.9 | 0.95 | 1 |  | 0.2
 |  |  |  |  |  |  |  | anything 80 and above will be green
 |  |  |  |  |  | Must sum up to 100%
Spreadsheet: 828314d1683383328-conditional-formatting-colour-code-a-cell-that-is-1-minus-another-cell-example-etaf
Sheet: Sheet1

 |  | Assessment 1
Name | Target Grade | Raw Score | Grade
 | 5 |  | 4
 | 5 |  | 5
 | 4 |  | 3
 | 6 |  | 6
 | 5 |  | 6
 | 5 |  | 4
 | 3 |  | 4
 | 4 |  | 4
 | 4 |  | 3
 | 5 |  | 3
 | 5 |  | 4
Spreadsheet: kay_mann__19201__ABB - New Option Allocation
Sheet: Austin

ABB Transformers - Austin
As of |  | Contract Price | 562300
2000-12-05 00:00:00 |  | Quantity | 2
 |  | Total Price
 |  | Funding Request | Drawdown | Drawdown
 |  | Date | Percent | Amount | Balance
Payments | Option Premium
Made | Milestone Payment #1 | 2000-09-14 00:00:00 | 0.1
To Date | Milestone Payment #2 |  | 0.25
 | Milestone Payment #3 |  | 0.65
 | Sale of Transformers | 2000-10-27 00:00:00
 |  |  |  | Balance Due as of 12/05/00 | 0
Spreadsheet: 0a1f9297-9acb-437c-bcce-8a591acf94b4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 50. PERSONAL FINANCE COMMITMENTS, Summary: Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Fixed loans ; |  |  | Original | A2414192W | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414193X | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414194A | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414189J | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414190T | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414191V | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414186A | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414187C | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414188F | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 776491d1649759768-based-on-adjacent-cell-value-extract-specific-cells-to-other-sheet-extract-only-seleted-stocks-copy
Sheet: Extracted

3P -SR / 3P-S / 3P-R / VDP | Industry | Main Sector | Del BO | Del% BO
 |  |  |  |  |  | In "A COLUMN"- I want only those stocks from sheet 2 where 3P-SR, 3P-S, 3P-R, VDP is mentioned in column H
 |  |  |  |  |  | extracted stocks should be auto rearranged, for example - all "3P-S" stocks first then all "3P-R" stocks and then all "3P-SR" and then all "VDP" stocks rearrannegement will be required.
Spreadsheet: 98516d1297374279-create-table-of-reading-problem-when-i-have-only-half-values-half-solved-copy-of-example-1
Sheet: example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | if i insert a date year it will change others cells, but only should do this if i write the reading in cells n14 to n16
 |  |  |  |  |  |  |  |  |  |  | and also if i only write i have a reading and a date it will affect the others
Alarm1 | Alarm2 | Alarm3 | Remaining AL1 (days) | [NAME] (days) | Remaining AL3 (days) | date last reading | Worst case (by year) | Short average lost (by year) | Long average lost (by year) | 2008-01-01 00:00:00 | 2009-12-31 00:00:00 | 2010-06-01 00:00:00
4.5 | 3.8 | 3 | 1470.000000000001 | 2499.000000000001 | 3675.000000000002 | 2010-06-01 00:00:00 | 0.248299319727891 | -0.2401315789473676 | 0.248299319727891 | 6.1 | 5.4 | 5.5
4.5 | 3.8 | 3 | 65.14285714285708 | 217.1428571428571 | 390.8571428571427 | 2010-06-01 00:00:00 | 1.680921052631579 | 1.680921052631579 | 0.6621315192743766 | 6.4 | 5.5 | 4.8
4.5 | 3.8 | 3 | 67.55555555555566 | 185.777777777778 | 320.8888888888891 | 2010-06-01 00:00:00 | 2.161184210526315 | 2.161184210526315 | 0.4552154195011336 | 6 | 5.8 | 4.9