tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 536263d1504337733-vba-code-to-auto-copy-and-paste-special-as-value-from-target-column-trial
Sheet: Trial

Holiday Form |  |  |  | Name: WR |  |  |  |  |  | Sheet No: |  | Back to Summary Sheet
Month (19th-18th) | Hours  from Scansafe |  | Holiday DAYS earned | Contract basis | Entitlement | DAYS
 |  |  |  | Permanent, Core Staff Full Time Monthly Fixed Hours Paid monthly / salary | 28 | Any earned & unpaid days Brought forward from 2016 | Total Days earned | Holiday Days taken & paid | Balance
 |  |  |  |  |  | 2 |  | 0 | 2
Jan | 191.4 |  | 2.333333333333333 |  |  |  | 4.333333333333334 | 0 | 4.333333333333334
Feb | 201.36 |  | 2.333333333333333 |  |  |  | 6.666666666666668 | 0 | 6.666666666666668
March | 187.1 |  | 2.333333333333333 |  |  |  | 9.000000000000002 | 0 | 9.000000000000002
Apr | 179.43 |  | 2.333333333333333 |  |  |  | 11.33333333333334 | 10 | 1.333333333333336
May | 191.56 |  | 2.333333333333333 |  |  |  | 13.66666666666667 | 0 | 3.666666666666669
Jun | 138.4 |  | 2.333333333333333 |  |  |  | 16 | 0 | 6.000000000000003
Jul | 201.43 |  | 2.333333333333333 | NEED VBA CODE TO AUTO COPY INPUTS MADE IN COLUMN C TO VALUES IN COLUMN B.  REASON INPUT IN C21 WILL GO TO 0 ONCE SEPT MOVES TO OCT. |  |  | 18.33333333333334 | 0 | 8.333333333333336
Aug | 175.37 |  | 2.333333333333333 |  |  |  | 20.66666666666667 | 5 | 5.66666666666667
Sep | 45 | 45 | 2.333333333333333 |  |  |  | 23 | 3 | 5.000000000000004
Oct | 0 | 0 | 0 |  |  |  | 23 | 0 | 5.000000000000004
Nov | 0 | 0 | 0 |  |  |  | 23 | 0 | 5.000000000000004
Dec | 0 | 0 | 0 |  |  |  | 23 | 0 | 5.000000000000004
 |  |  |  |  |  |  |  |  |  | PULLS VALUE
Tot Days earned this year |  |  | 21 |  |  |  |  | CELL H19
 |  |  | PUSHES VALUE |  |  |  | Latest booked | 23 | CELL H19 COPIES ANY INPUT FROM THE ACTUAL CURRENT MONTH WHETHER JAN-DEC
 |  | CELL C21 |  |  |  |  |  | Any earned & unpaid Days Carried forward to 2018 | THE VALUE IS THEN LINKED TO THE SUMMARY PAGE AS THE RECORD OF HOURS TO BE PAID FOR THE ACTUAL CURRENT MONTH THAT WILL GO TO PAYROLL
 |  | 45 | CELL C21 VALUE IS PUSHED TO CURRENT MONTH NEXT TO JAN-DEC.
 |  |  | C21 WILL BE INPUTTED ON SUMMARY PAGE FROM SCANSAFE REPORT
 | SOMETHING LIKE THIS MIGHT WORK  CODE FOUND ON A WEB SITE AND COPIED INTO E23 |  |  | Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Range("B:B") If Not Intersect(rng, Target) Is Nothing Then     If Target.Value > 0 Then Target.Offset(0, 1) = Now End If  End Sub
Spreadsheet: 149433d1333965592-excel-2007-excel-survey-data-stats-prosjekt
Sheet: Ark5

Pain scale 0-10 | Pain scale 0-10
0 | 7 | Variansanalyse: en-faktor
1 | 7
1 | 4 | SAMMENDRAG
3 | 6 | Grupper | Antall | Sum | Gjennomsnitt | Varians
4 | 2 | Pain scale 0-10 | 98 | 398 | 4.061224489795919 | 9.088996423311594
7 | 9 | Pain scale 0-10 | 16 | 78 | 4.875 | 4.916666666666667
0 | 3
2 | 3
6 | 6 | Variansanalyse
2 | 3 | Variasjonskilde | SK | fg | GK | F | P-verdi | F-krit
4 |  | Mellom grupper | 9.10857500895122 | 1 | 9.10857500895122 | 1.067802935016407 | 0.303668386885517 | 3.925834021391601
0 | 7 | Innenfor grupper | 955.3826530612242 | 112 | 8.530202259475216
10 | 6
7 | 3 | Totalt | 964.4912280701755 | 113
5
2 | 7
0 | 2
0 | 3
3
5
2
7
6
5
6
5
0
1
6
3
8
5
0
7
3
7
3
7
6
0
6
4
0
2
10
5
7
5
3
6
1
6
9
6
0
1
9
7
2
8
0
8
1
6
9
5
9
0
1
8
0
6
8
0
7
10
0
2
0
5
4
3
4
6
4
4
3
8
3
0
9
3
0
3
5
6
2
0
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 23

CONSOLIDATED STATEMENT OF CASH FLOWS |  |  |  | 1Q11 | 1Q10
3
R$ million
Cash Flows from Operating Activities
 | Profit |  |  | 2106.04 | 1650.893999999999
 |  | Depreciation, amortization and impairment |  | 344.658 | 375.656
 |  | Impairment losses on receivables and inventories |  | 17.001 | 27.677
 |  | Additions/(reversals) in provisions and employee benefits |  | 23.974 | 61.911
 |  | Net finance cost |  | 45.489 | 186.636
 |  | Other non-cash items included in the profit |  | -39.173 | 16.936
 |  | Loss/(gain) on sale of property, plant and equipment and intangible assets |  | -2.229 | 1.564
 |  | Loss/(gain) on assets held for sale |  | 0.162 | 0
 |  | Equity-settled share-based payment expense |  | 29.321 | 24.495
 |  | Income tax expense |  | 601.866 | 561.592
 |  | Share of result of associates |  | -0.086 | -0.013
 | Cash flow from operating activities before changes in working capital and use of provisions |  |  | 3127.023 | 2907.347999999999
 |  | Decrease/(increase) in trade and other receivables |  | 324.904 | 424.505
 |  | Decrease/(increase) in inventories |  | -361.097 | -91.944
 |  | Increase/(decrease) in trade and other payables |  | -1106.925 | -824.248
 | Cash generated from operations |  |  | 1983.905 | 2415.660999999999
 |  | Interest paid |  | -228.239 | -122.877
 |  | Interest received |  | 85.786 | 34.001
 |  | Income tax paid |  | -605.886 | -442.638
 | Cash flow from operating activities |  |  | 1235.566 | 1884.146999999999
 |  | Proceeds from sale of property, plant and equipment |  | 7.635 | 9.726
 |  | Repayments of loans granted |  | 0.295 | 0.282
 |  | Purchase of non-controlling interest |  | 0 | -2.569
 |  | Acquisition of property, plant and equipment |  | -573.373 | -218.645
 |  | Acquisition of intangible assets |  | -7.387 | -0.448
 |  | Investment in short term debt securities |  | 0 | 0
 |  | Net proceeds/(acquisition) of debt securities |  | -1.632 | -15.63
 |  | Net proceeds/(acquisition) of other assets |  | 1.19 | 0
 | Cash flow used in investing activities |  |  | -573.272 | -227.284
 |  | Capital increase |  | 0.21 | 0
 |  | Capital increase of non-controlling interests |  | 0 | 41.755
 |  | Proceeds from borrowings |  | 78.832 | 111.275
 |  | Proceeds/repurchase of treasury shares |  | -0.062 | 0.657
 |  | Repayment of borrowings |  | -145.22 | -230.785
 |  | Cash net finance costs other than interests |  | -13.726 | -33.367
 |  | Payment of finance lease liabilities |  | -0.871 | -0.662
 |  | Dividends (paid)/received |  | -1809.066 | -31.059
 | Cash flow used in financing activities |  |  | -1889.903 | -142.186
 | Net  increase/(decrease) in cash and cash equivalents |  |  | -1227.609 | 1514.677
 | Cash and cash equivalents less bank overdrafts at beginning of period |  |  | 5908.299 | 4024.314
 | Effect of exchange rate fluctuations |  |  | -52.027 | 8.714
 | Cash and cash equivalents less bank overdrafts at end of period |  |  | 4628.663 | 5547.705
Spreadsheet: 813497d1673821002-pls-help-average-with-if-conditions-need-average-of-each-product-specified-by-year-and-market-entry-date-for-blank
Sheet: Product Price & Average

Data |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  | 2018 |  |  | 2019 |  |  | 2020 |  |  | 2021 |  |  | 2022 |  |  | 2023 |  |  | 2024 |  |  | 4700
Product ID | Product Name | Amount | Effective Date | Expiration Date | Start Year | End Year |  | Product ID | Product Name | Market Entry Date | Market Entry Year | Average Amt for 2017 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2018 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2019 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2020 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2021 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2022 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2023 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2024 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 4700 | % Increased based on previous year | Amount Increased Based on Previous Year
1003 | Candy A | 8754.9 | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 |  |  |  | 1003 | Candy A
1003 | Candy A | 9297.7 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 |  |  |  | 1004 | Candy B
1003 | Candy A | 9985.73 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 |  |  |  | 1005 | Candy C
1003 | Candy A | 10604.85 | 2021-01-01 00:00:00 | 2022-01-13 00:00:00 |  |  |  | 1006 | Candy D
1003 | Candy A | 11124.49 | 2022-01-14 00:00:00 | 2023-01-02 00:00:00
1003 | Candy A | 11680.71 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00
1004 | Candy B | 370.29 | 2018-12-27 00:00:00 | 2019-06-30 00:00:00
1004 | Candy B | 388.44 | 2019-07-01 00:00:00 | 2020-12-30 00:00:00
1004 | Candy B | 415.24 | 2020-12-31 00:00:00 | 2021-12-22 00:00:00
1004 | Candy B | 443.89 | 2021-12-23 00:00:00 | 2022-12-25 00:00:00
1004 | Candy B | 465.64 | 2022-12-26 00:00:00 | 2023-12-21 00:00:00
1004 | Candy B | 497.77 | 2023-12-22 00:00:00 | 4700-12-31 00:00:00
1005 | Candy C | 3225.88 | 2022-09-13 00:00:00 | 2023-01-02 00:00:00
1005 | Candy C | 3451.69 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00
1006 | Candy D | 18272.79 | 2022-12-15 00:00:00 | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1st Condition |  | if product ID in I Column matches Product ID Data Table
1006 | Candy D | 19734.61 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2nd Condition |  | if start year and end year matches year in S2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd Condition |  | then give me the average of Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(AVERAGEIFS(TableData[Amount],TableData[Start Year],Q$2,TableData[End Year],Q$2,TableData[Product ID],$I4),"")
 | [NAME]
Spreadsheet: 198556d1354814651-how-to-select-non_fill-rows-book-how-many-hits2
Sheet: Sheet2

A |  | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE
 |  |  |  |  |  | 0-0 | 0-1 | 0-2 | 1-0 | 1-1 | 1-2 | 2-0 | 2-1 | 2-2 | 3-0 | 3-1 | 3-2 | 4-0 | 4-1 | 4-2 | 5-0 | 5-1 | 5-2 | 6-0 | 6-1 | 6-2 | 7-0 | 7-1 | 7-2
 |  | 2 | 1
 |  | 6 | 0
 |  | 1 | 0 |  |  | 2 | 1 | 4 | 2 | 3 | 1 | 0 | 2 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 4 | 1 | 2 | 1 | 2 | 1
 |  | 7 | 2
 |  | 1 | 0
 |  | 5 | 2
 |  | 1 | 0
 |  | 2 | 2
 |  | 3 | 0
 |  | 5 | 1
 |  | 2 | 0
 |  | 5 | 1
 |  | 1 | 0
 |  | 1 | 1
 |  | 2 | 2
 |  | 1 | 2
 |  | 0 | 0
 |  | 3 | 0
 |  | 0 | 1
 |  | 4 | 1
 |  | 1 | 2
 |  | 3 | 2
 |  | 6 | 1
 |  | 3 | 1
 |  | 2 | 2
 |  | 7 | 1
 |  | 6 | 2
 |  | 5 | 0
 |  | 4 | 2
 |  | 7 | 0
 |  | 7 | 2
 |  | 0 | 1
 |  | 3 | 1
 |  | 4 | 1
 |  | 2 | 0
 |  | 2 | 2
 |  | 3 | 1
 |  | 0 | 2
 |  | 5 | 1
Spreadsheet: 492732d1481227337-populate-cells-with-values-from-another-table-based-on-3-matching-conditions-before-after
Sheet: After

Table1 |  |  |  |  |  | Table2
Item | Size | Color | Description |  |  | Item | Size | Color | Description
1 | 14 | Black |  |  |  | 1 | 16 | Black | I need 2 items
1 | 14 | White |  |  |  | 2 | 14 | Red | Call Richard to take an order
1 | 16 | Black | I need 2 items |  |  | 2 | 16 | White | 12/15 Due Date
2 | 14 | Black |  |  |  | 3 | 18 | Black | [NAME] is out, call [NAME] about this
2 | 14 | White |  |  |  | 5 | 16 | White | Customer is returning
2 | 14 | Red | Call Richard to take an order
2 | 16 | Black
2 | 16 | White | 12/15 Due Date
3 | 16 | Black
3 | 16 | White
3 | 18 | Black | [NAME] is out, call [NAME] about this
3 | 18 | White
4 | 14 | Black
4 | 14 | White
5 | 14 | Black
5 | 16 | Black
5 | 16 | White | Customer is returning
Spreadsheet: 65764d1266432663-copying-storing-entered-information-to-another-worksheet-staff-skills-audit4
Sheet: Summary

 |  | Average Score per section
 |  | WP | SS | PR | UV | IW | UI | EM | LP | TD | UG | CM | CH | US
Teacher Name | Total Score | Word Processing | Spredsheets | Presentations | Using VLE | Interactive White Boards | Using Internet | E-Mail | [NAME] | Teaching & Delivering ICT | Using Graphics Software | Computer Management | Computer Hardware | Using SIMs |  |  |  |  |  |  | Section Summaries - NB the %s are only accurate when data is sorted by question
Teacher 1
Teacher 2 |  |  |  | The Blue cells would be an average of their answers from each section, if you look at the questions they have codes which correspond to each section. As different staff open and complete the audit then their results would add to the list below the previous person or in an allocated space! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WP | SS | PR | UV | IW | UI | EM | LP | TD | UG | CM | CH | US
Teacher 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reply scale: 5 = strongest | Word Processing | Spredsheets | Presentations | Using VLE | Interactive White Boards | Using Internet | E-Mail | [NAME] | Teaching & Delivering ICT | Using Graphics Software | Computer Management | Computer Hardware | Using SIMs
Teacher 4
Teacher 5
Teacher 6
Teacher 7
Teacher 8
Teacher 9
Teacher 10
This could go down to 100+ staff |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 803954d1667820868-formula-for-9-box-grid-9-box-grid
Sheet: Sheet1

EMPLOYEE ID | NAME | DEPARTMENT | POSITION | YEARS OF EXPERIENCE | JOB LEVEL | AGE | PERFORMANCE | POTENTIAL | 9 BOX CATEGORIZATION |  | Potential
1 |  |  |  |  |  |  | 3 | 1 | [NAME] |  |  | 3
2 |  |  |  |  |  |  | 3 | 3 | Star |  |  | 2
3 |  |  |  |  |  |  | 1 | 3 | Potential Gem |  |  | 1
4 |  |  |  |  |  |  | 1 | 2 | Inconsistent player |  |  |  | 1 | 2 | 3
5 |  |  |  |  |  |  | 3 | 2 | High performance |  | Perfromacne
6 |  |  |  |  |  |  | 2 | 2 | Core Player
7 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
8 |  |  |  |  |  |  | 2 | 3 | High potential
9 |  |  |  |  |  |  | 3 | 1 | [NAME]
10 |  |  |  |  |  |  | 2 | 1 | Average performer
11 |  |  |  |  |  |  | 2 | 2 | Core Player
12 |  |  |  |  |  |  | 2 | 3 | High potential
13 |  |  |  |  |  |  | 3 | 1 | [NAME]
14 |  |  |  |  |  |  | 2 | 1 | Average performer
15 |  |  |  |  |  |  | 1 | 3 | Potential Gem
16 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
17 |  |  |  |  |  |  | 2 | 3 | High potential
18 |  |  |  |  |  |  | 1 | 1 | Risk
19 |  |  |  |  |  |  | 2 | 1 | Average performer
20 |  |  |  |  |  |  | 1 | 3 | Potential Gem
Spreadsheet: sally_beck__35761__MgmtSum-Q1-0320
Sheet: Headcount

PLAN2000 | ENRON NORTH AMERICA
TOT_COM_HC | 1ST QUARTER 2000 HEADCOUNT
TOT_NC_HC
2000-03-01 00:00:00
2000-02-01 00:00:00
M.QTD |  |  | Actuals - February Team Report |  |  |  | Plan - February |  |  |  | Variance to Plan
ENA | Business Team |  | Commercial | Other | Total |  | Commercial | Other | Total |  | Commercial | Other | Total
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
[NAME] | Financial Trading
CANADA | Canada
COAL | Coal
WEATHER | Weather
SO2 | Emissions
INSURANCE | Insurance Group
EXEC_TRD | Executive Trading
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
PAPER | Industrial Downstream - Paper
CHEMICALS | Industrial Downstream - Chemicals
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico
EXEC_ORIG | Executive Origination
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments
ASST_ORIG | Gas Assets
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing
PROD_FIN | Energy Investments
ENVR_ENGY | Investment Management
RESTRUCTURING | Restructuring
FIN | Canada - Investing
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
 | Total Commercial
GROUP | Group
GROUP
ACTUAL | Total
Spreadsheet: 160058d1338948306-excel-2007-problems-with-cse-functions-albums-new-5-10
Sheet: Year List

Rank | Year | Album1 | Album2 | Album3 | Album4 | Album5 | Album6 | Album7 | Album8
 | 1957
 | 1958
 | 1959
 | 1960
 | 1961
 | 1962
 | 1963
 | 1964
 | 1965
 | 1966
 | 1967
 | 1968
 | 1969
 | 1970
 | 1971
 | 1972
 | 1973
 | 1974
 | 1975
 | 1976
 | 1977
 | 1978
 | 1979
 | 1980
 | 1981
 | 1982
 | 1983
 | 1984
 | 1985
 | 1986
 | 1987
 | 1988
 | 1989
 | 1990
 | 1991
 | 1992
 | 1993
 | 1994
 | 1995
 | 1996
 | 1997
 | 1998
 | 1999
 | 2000
 | 2001
 | 2002
 | 2003
 | 2004
 | 2005
 | 2006
 | 2007
 | 2008
 | 2009
 | 2010
 | 2011
 | 2012
350
Spreadsheet: 43853d1242488416-solved-changing-contents-of-list-via-validation-example1b
Sheet: Sheet2

CATEGORIES LIST | NAMED List
Class 1 Radioactive
Class 2 Radioactive |  |  | Choose Category |  | Category List
Class 3 Radioactive |  |  | Class 1 Radioactive | 3 | Carbalaneksis*
 |  |  |  |  | Omnihawo*
 |  |  |  |  | Eforoete*
Class 1 Radioactive | 3
Carbalaneksis*
Omnihawo*
Eforoete*
Class 2 Radioactive | 3
[NAME]*
Omnifofiba*
Tokiw*
Class 3 Radioactive | 4
Ecoaw*
Oratiine*
Pruton*
Scoskeu*
EXCEL 2003
Spreadsheet: 148014d1333090660-how-to-copy-data-as-per-particular-name-and-send-it-to-him-via-mail-test
Sheet: Sheet1

Telecaller name | [NAME] | Customer id | Customer Name | City name
Smith | Smith@xyz | 63
Smith | Smith@xyz | 16
Jones | Jones@xyz | 55
Jones | Jones@xyz | 44
Jones | Jones@xyz | 34
Adams | [NAME] | 21
West | [NAME] | 31
West | [NAME] | 66
West | [NAME] | 12
West | [NAME] | 20
Spreadsheet: 106970d1304103223-conditionally-extending-range-of-rolling-average-rolling_averages_daily_data_01
Sheet: Basic_Data

Date | Data | 5Day_Rolling_Avg | LookBack_ToDate
20110401 | 141
20110402 | 166
20110403 | 231
20110404 | 159
20110405 | 159
20440406 | 231
20110407 | 159
20110408
20110409 | 122
20110410 | 131
20110411 | 107
20110412 | 124
20110413 | 114
20110414 | 124
20110415 | 178
20110416 | 62
20110417
20110418
20110419 | 272
20110420
20110421 | 191
20110422 | 251
20110423 | 185
20110424 | 188
20110425 | 173
20110426 | 288
20110427 | 255
20110428 | 180
20110429 | 228
20110430 | 244
Spreadsheet: 287418d1388780969-converting-a-spreadsheet-into-a-heirarchical-display-of-the-data-fruit
Sheet: Category Details

Event Categories and Sub-Categories
Main Category | Sub-Cat 1 | Sub-Cat 2 | Sub-Cat 3 | Sub-Cat 4 | Form sub-section  (for NextDocs)
Fruit | Apples | Red |  |  | 2
Fruit | Apples | Green |  |  | 2
Fruit | Pineapples |  |  |  | 2
Fruit | Oranges | Tangerine |  |  | 2
Fruit | Oranges | Naval |  |  | 2
Fruit | Oranges | Orange |  |  | 2
Fruit | Pears | Green |  |  | 2
Fruit | Pears | [NAME] |  |  | 2
Fruit | Pears | Yellow |  |  | 2
Fruit | Blueberries | Big |  |  | 2
Fruit | Blueberries | Small |  |  | 2
Fruit | Blueberries | Blue |  |  | 2
Fruit | Blueberries | Sweet |  |  | 2
Fruit | Blueberries | Sour |  |  | 2
Spreadsheet: 792681d1661075098-splitting-numbers-from-texts-split-numbers-from-texts
Sheet: PQ

 | Desired Result
Copied Data | + | - |  | type | + | -
01/07 CMS - CR PYMT MARS 1,164.63+ 289,724.35 |  |  |  | 01/07 CMS - CR PYMT MARS | 1164.63
01/07 CHEQUE PROCESSING FEE .50- 289,723.85 |  |  |  | 01/07 CHEQUE PROCESSING FEE |  | 0.5
01/07 INTER-BANK PAYMENT INTO A/C 906.30+ 290,630.15 |  |  |  | 01/07 INTER-BANK PAYMENT INTO A/C | 906.3
01/07 INTER-BANK PAYMENT INTO A/C 115.76+ 290,745.91 |  |  |  | 01/07 INTER-BANK PAYMENT INTO A/C | 115.76
02/07 CMS - CR PYMT MARS 838.44+ 291,584.35 |  |  |  | 02/07 CMS - CR PYMT MARS | 838.44
02/07 TRANSFER TO A/C 166.10+ 291,750.45 |  |  |  | 02/07 TRANSFER TO A/C | 166.1
02/07 TRANSFER TO A/C 237.05+ 292,384.45 |  |  |  | 02/07 TRANSFER TO A/C | 237.05
02/07 TRANSFER FR A/C 300.00- 292,084.45 |  |  |  | 02/07 TRANSFER FR A/C |  | 300
Spreadsheet: 839694d1692168604-countifs-formula-for-filtered-list-to-find-unique-values-ignore-hidden-rows-test
Sheet: Sheet1

Type | Name | Amount | Manager
Normal | Audi | 6 | [NAME]
Normal | Audi | 5 | [NAME]
Normal | Mercedes | 15 | [NAME]
Normal | Mercedes | 9 | [NAME]
Special | BMW | 4 | [NAME]
Special | BMW | 3 | [NAME]
Special | Audi | 2 | [NAME]
Special | Honda | 10 | [NAME]
Special | Honda | 10 | [NAME]
Unique Count |  |  |  | B12=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(OFFSET(B1,1,0):B11,ROW(OFFSET(B1,1,0):B11)-ROW(OFFSET(B1,1,0)),,1)), IF(OFFSET(B1,1,0):B11>"",MATCH("~"&OFFSET(B1,1,0):B11,OFFSET(B1,1,0):B11&"",0))),ROW(OFFSET(B1,1,0):B11)-ROW(OFFSET(B1,1,0))+1),1))
Normal | 1
Special | 2
Normal & Special | 1
Spreadsheet: richard_shapiro__32386__Worksheet Shapiro 100072
Sheet: Instructions

 | 2002 Operating & Strategic Plan
 | 1.  Fill in the following information: |  |  | Company Number |  | 0011 |  |  |  |  | Personnel
 |  |  |  | Cost Center Number |  | 100072 |  |  |  |  | Ryall
 |  |  |  | Cost Center Name |  | St Govt Aff TX/OK |  |  |  |  | [NAME]
 |  |  |  | Cost Center Owner |  | [NAME]
 | 2.  [NAME] the 'Salary' sheet.   [NAME] information will populate the 'Detail Expense' sheet.
 | 3.  Complete the 'Detail Expense' sheet.
 |  | A.  The Payroll Taxes & Benefits will calculate automatically from '[NAME]' sheet.
 |  | B.  Enter Analyst & Associate fee information on the 'Analyst & Associate Allocations' line.  Including it in your
 |  | regular salaries will calculate benefits/taxes already included in the flat fee.
 |  |  | (Associate $10400/mo, 3rd Yr Analyst $7400/mo, Analyst $6400/mo, Tax Analyst $2400/mo,
 |  |  | Summer Analyst $3300/mo, Summer Associate $6000/mo)
 |  | [NAME] out the expense information by account.  Do not forget to include the provided EPSC charges.
 |  | D.  Enter plan amount for EIS Long Distance charges (This should cover charges for Market data, WAN links, Long distance,
 |  | and Communications churns).  All other EIS charges will be calculated based on headcount.
 | 4.  [NAME] the 'Detail Capital' sheet.   Please do not capitalize more than planned expenses.
 | 5.  Complete the 'Allocations' sheet.  These are the charges you will be sending to each business unit via the
 |  | Corporate Assessment process.  Please do not add lines to this sheet without contacting Corporate Financial Planning first.
 | 6.  The 'Executive Summary' sheet is populated automatically and will be ready for your reference after Steps 1 - 5 are completed.
 | 7.  Return completed file to Corporate Financial Planning by August 13th.
Spreadsheet: 800472d1665678161-sales-conversion-accumulative-percentage-algo-im-stuck-forecast-share
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year End Targets
 |  |  | 11 |  | 10 |  | 9 |  | 8 |  | 7 |  | 6 |  | 5 |  | 4 |  | 3 |  | 2 |  | 1
Locations/Traffic | Locations Carried Over | Traffic Carried Over | Month 1 End | Month 1 Traffic | Month 2 End | Month 2 Traffic | Month 3 End | Month 3 Traffic | Month 4 End | Month 4 Traffic | Month 5 End | Month 5 Traffic | Month 6 End | Month 6 Traffic | Month 7 End | Month 7 Traffic | Month 8 End | Month 8 Traffic | Month 9 End | Month 9 Traffic | Month 10 End | Month 10 Traffic | Month 11 End | Month 11 Traffic |  | Month 12 Locations | Month 12 Traffic | Active Months |  |  | Traffic Totals
English National League Football | 0 | 0 |  | 0 |  | 12066 |  | 18098 |  | 30164 |  | 36197 |  | 48262 |  | 54295 |  | 66361 |  | 72393 |  | 84459 |  | 90492 |  | 18 | 102557 | 12
Totals
 |  |  | 11 |  | 10 |  | 9 |  | 8 |  | 7 |  | 6 |  | 5 |  | 4 |  | 3 |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year End Targets
Target/Caught | Target Carried Over | Caught Carried Over | Month 1 Target | Month 1 Caught | Month 2 Target | Month 2 Caught | Month 3 Target | Month 3 Caught | Month 4 Target | Month 4 Caught | Month 5 Target | Month 5 Caught | Month 6 Target | Month 6 Caught | Month 7 Target | Month 7 Caught | Month 8 Target | Month 8 Caught | Month 9 Target | Month 9 Caught | Month 10 Target | Month 10 Caught | Month 11 Target | Month 11 Caught |  | Month 12 Target | Month 12 Caught | Active Monthly Increase | [NAME] |  | Total Caught
English National League Football | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.75