tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40552d1238897697-if-vlookup-or-database-problem-mcl_test
Sheet: 02

SERIAL # | ACCOUNT # | DATE CHECKED OUT | DATE INSTALLED | DATE RETURNED
12445 | 876543 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00
12446 | 876544 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00
12447 | 876545 | 2009-04-01 00:00:00 |  | 2009-04-02 00:00:00
12448 | 876546 | 2009-04-01 00:00:00 |  | 2009-04-02 00:00:00
12449 | 876547 | 2009-04-02 00:00:00 | 2009-04-02 00:00:00
12450 | 876548 | 2009-04-02 00:00:00 | 2009-04-02 00:00:00
12451 | 876549 | 2009-04-02 00:00:00 | 2009-04-03 00:00:00
12452 | 876550 | 2009-04-03 00:00:00 | 2009-04-03 00:00:00
12453 | 876551 | 2009-04-03 00:00:00 |  | 2009-04-04 00:00:00
12454 | 876552 | 2009-04-04 00:00:00 | 2009-04-04 00:00:00
Spreadsheet: 853628d1703551466-trying-to-get-data-from-a-spreadsheet-and-break-it-down-per-customer-and-per-tech-raw-data
Sheet: timeentrysearch (43)

Member | Company | Hours
[NAME] | Acme | 0.07 |  | [NAME] | 20 |  |  |  | 77.6
[NAME] | US Gov | 1.35 |  | [NAME] | 30 |  |  | [NAME] | 2.49 | 49.8
[NAME] | Acme | 1.82 |  | Mark | 40 |  |  | Mark | 0.47 | 18.8
[NAME] | ACME | 0.6 |  |  |  |  |  | [NAME] | 0.3 | 9
[NAME] | US Gov | 0.03
[NAME] | US Gov | 0.02
[NAME] | US Gov | 0.48 |  |  |  |  |  | US Gov | 86.8
Mark | Acme | 0.22 |  |  |  |  |  | [NAME] | 2.88 | 86.39999999999999
[NAME] | US Gov | 0.02 |  |  |  |  |  | [NAME] | 0.02 | 0.4
[NAME] | Acme | 0.3
Mark | Acme | 0.25
[NAME] | US Gov | 1
Spreadsheet: 843808d1695653211-if-formula-with-multiple-conditions-test-to-check-if-migrated
Sheet: Sheet1

Status (formula to get outcome in column H) | Subject | Has subject? | Has English bundle? | Has MFL bundle | Has maths bundle? | Has newer version? | Outcome should be
 | English | True | False | False | False | True | Migrated
 | English | True | True | False | False | False | Migrated
 | French | True | False | False | False | False | Partially migrated
 | German | False | False | False | False | False | Not migrated
 | Maths | True | False | False | True | False | Migrated
 | Maths | True | True | False | False | False | Partially migrated
Spreadsheet: 107051d1304208645-if-cell-b-x-show-cell-a-example
Sheet: Destination Sheet

 | 2001 | 2002 | 2003 | 2004 | 2005
(1-1) | name | name | name | name | name
(1-2) | name | name | name | name | name
(1-3) | name | name | name | name | name
(1-4) | name | name | name | name | name
(1-5) | name | name | name | name | name
column 'A' goes all the way down to 12-31 (365 total rows)
Spreadsheet: 108439d1305531227-frequency-count-if-problems-book1
Sheet: Sheet1

a | b | c | d | e | f | g | h | i | j | k | l | date | new
RMA001659 |  | Closed | ABE008 | JS8681CH |  | -1 |  | EUR002 |  | 02 | 38 | 2010-08-10 00:00:00 | 0
RMA001840 |  | Closed | ACH001 | JS6542AD |  | -1 |  | PRE006 |  | 02 | 32 | 2010-08-24 00:00:00 | 1
RMA001889 |  | Closed | ACH001 | JS0148RD |  | -1 |  | DUA001 |  | 04 | 32 | 2010-08-27 00:00:00 | 1
[NAME] |  | Closed | AK-001 | JU352 |  | -48 |  | STV001 |  | 04 | 31 | 2010-08-25 00:00:00 | 1
RMA001742 |  | Closed | ALA001 | JE503WH |  | -2 |  | COU003 |  | 04 | 41 | 2010-08-17 00:00:00 | 1
RMA001614 |  | Closed | ALB003 | JD039HC |  | -10 |  | CRO001 |  | 04 | 48 | 2010-08-05 00:00:00 | 1
RMA001614 |  | Closed | ALB003 | [NAME] |  | -10 |  | BRI005 |  | 04 | 48 | 2010-08-05 00:00:00 | 0
RMA001614 |  | Closed | ALB003 | JDK051D |  | -1.9 |  | DEN001 |  | 04 | 48 | 2010-08-05 00:00:00 | 0
RMA001614 |  | Closed | ALB003 | JS3747 |  | -2 |  | MOR001 |  | 04 | 48 | 2010-08-05 00:00:00 | 0
RMA001614 |  | Closed | ALB003 | JT0095B |  | -5 |  | QUA002 |  | 04 | 48 | 2010-08-05 00:00:00 | 0
RMA001614 |  | Closed | ALB003 | JT0341 |  | -1 |  | QUA002 |  | 04 | 48 | 2010-08-05 00:00:00 | 0
RMA001614 |  | Closed | ALB003 | JDK051D |  | -0.1 |  | DEN001 |  |  | 48 | 2010-08-05 00:00:00 | 0
Spreadsheet: 742237d1627612464-table-to-sort-and-display-the-last-30-results-trades
Sheet: CALCS

TIME
 |  | (Total Time in range) | (entries in range)
START | END | SUMIFS | COUNTIFS | AVERAGE
08:00:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 14:59:00
15:00:00 | 16:00:00
 | Total:
PRICE
 |  | (total price) | (entries) | (ave price) | (total G/L) | (ave G/L)
LOW | HIGH | SUMIFS | COUNTIFS | AVERAGE | SUMIFS | AVERAGE
0.01 | 3
3.01 | 5
5.01 | 7
7.01 | 10
10.01 | 15
15.01 | 20
20.01 | 25
25.01 | 30
30.01 | 300
TRADE TYPE | Trades | G/L $
BO | 20
Momo | 20
Reversal | 20
Scalp | 20
SETUP | Trades | G/L $
Pivot | 20
PMH | 20
PM Consolidation | 20
HOD | 20
Consolidation | 20
Spreadsheet: 865627d1712669334-choosecols-and-filter-test2_abs
Sheet: Ram

 |  | 616658945 | [NAME] (616658945) | 0 | 430281.17 | 391185 | 39096.17 |  |  | 39096.17
 |  | Bimal Chiya Packaging Udhyog | Simal Kiya Packaging Udhyog(2Ledger1PKS-302501791) | 307875.76 | 161375.88 | 0 | 469251.64 |  |  | 469251.64
 |  | 301501891 | Dimal Food Product,ahari (301501891) | 593120.65 | 330857.11 | 593121 | 330856.76 |  |  | 593120.65
 |  | 302263185 | Food Packaging Udhyog,[NAME] (302263185) | 0 | 267296.2 | 310871 | -43574.8 | 8 |  | 0
 |  | Mainik [NAME] | Mainik [NAME] | 54 | 0 | 100000 | -100000 | 26 |  | 0
 |  | Dakshesh Agro Pvt Ltd | Dakshesh Agro Pvt Ltd | 0 | 0 | 327000 | -327000 | 5 |  | 0
 |  | 608620093 | Elanta Health Care And Hyginene Products (608620093) | 2173.68 | 0 | 0 | -82173.68 |  |  | -82173.68
 |  |  | [NAME]. Ltd. | -12 | 0 |  | 256 |  |  | -12
Spreadsheet: 83908d1283947039-best-yield-from-table-yield
Sheet: Sheet1

 |  | PRODUCT |  |  | TABLE |  |  | RESULT
 |  | LENGTH | WIDTH |  | LENGTH | WIDTH |  | LENGTH | WIDTH
 |  | 600 | 300 |  | 500 | 230
 |  |  |  |  | 1250 | 350
 |  |  |  |  | 2100 | 350
 |  |  |  |  | 1050 | 550
 |  | EXPERIMENTS
 |  | 1050 | This returns the smallest number in the table that is greater than the product length but doesn't take into consideration multiples
 |  | 0.08333333333333348 | THIS FOLMULA RETURNS THE BEST YIELDS WASTE (on the length) [NAME] = 2.08333 minus the integer (2) = 0.0833333
 |  |  | but I can't seem to convert it back to the table figure (1250)
Spreadsheet: 767872d1644685281-distribute-a-number-from-a-cell-across-others-based-on-the-percentage-of-another-cell-distribute-based-on-individual-percentage-of-available-tachyonstiggy-
Sheet: Fruit Available

FRUIT | TEAM
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 2
APPLES | TEAM 2
Spreadsheet: 54216d1254240299-help-setting-up-a-functional-sheet-another-attempt
Sheet: test1 

TYPE | EMPL # | NAME | BOAT | reg | OT | HOL | PREM | Type | OTHER | Type
20LVHS | 200 7100 | sample 1 | 1
20LVHS | 200 7112 | sample 2 | 1
20LVHS | 200 7113 | sample 3 | 1
20LVHS | 200 7088 | sample 4 | 1
20LVHS | 200 8103 | sample 5 | 1
20LVHS | 200 8177 | sample 6 | 1
20LVHS | 200 7100 | sample 7 | 1
20LVHS | 200 7098 | sample 8 | 1
20LVHS | 200 8142 | sample 9 | 1
20LVHS | 204 0790 | sample 10 | 1
20LVHS | 206 6631 | sample 11 | 1
20LVHS | 206 4835 | sample 12 | 1
20LVHS | 200 7088 | sample 13 | 1
20LVHH | 200 7438 | sample 14 | 2
20LVHH | 200 7422 | sample 15 | 2
20LVHH | 207 0281 | sample 16 | 2
20LVHH | 200 8178 | sample 17 | 2
20LVHH | 200 7428 | sample 18 | 2
20LVHH | 200 7421 | sample 19 | 2
20LVHH | 200 8143 | sample 20 | 2
20LVHH | 200 8161 | sample 21 | 2
20LVHH | 200 8186 | sample 22 | 2
20LVHH | 200 8184 | sample 23 | 2
20LVHH | 200 8123 | sample 24 | 3
20LVHH | 207 0418 | sample 25 | 3
20LVHH | 200 7421 | sample 26 | 3
20LVHH | 200 7422 | sample 27 | 3
20LVHH | 200 7438 | sample 28 | 3
20LVHH | 207 0639 | sample 29 | 3
20LVHH | 206 9255 | sample 32 | 3
20LVHH | 207 0566 | sample 33 | 3
20LVHH | 207 0417 | sample 34 | 3
20LVHH | 207 0639 | sample 35 | 3
20LVHH | 207 0638 | sample 36 | 3
20LVHH | 207 0418 | sample 37 | 3
Spreadsheet: 165199d1341084898-if-sat-subtract-one-day-if-sunday-subtract-tow-days-lastfridayifweekend
Sheet: Sheet1

Date | LastWorkDay
 |  | <<Look at this formula
Spreadsheet: 71296d1271964257-excel-2007-creating-rows-from-data-that-is-spread-across-multiple-columns-creating-rows-from-data-that-is-spread-across-multiple-columns-excelworkerneedshelp-sdg10
Sheet: Sheet1

Title 1 | Item 1 | Item 2 | Item 3 | Counter |  |  |  |  |  |  | Today, 02:34 PM
A | Z | X |  | 2 |  |  |  |  |  |  | Creating rows from data that is spread across multiple columns - ExcelWorkerNeedsHelp - SDG10.xls
B | Z |  |  | 1 |  |  |  |  |  |  | Registered User   Join Date: 22 Apr 2010
C | Z | X | Y | 3 |  |  |  |  |  |  | Location: Toronto, Canada
 |  |  |  |  |  |  |  |  |  |  | MS Office Version:Excel 2003
 |  |  |  |  |  |  |  |  |  |  | Posts: 2
 |  |  |  |  |  |  |  |  |  |  | Creating rows from data that is spread across multiple columns.
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | I have data in the following format.
 |  |  |  |  |  |  |  |  |  |  | Title 1 Item 1 Item 2 Item 3 Counter
 |  |  |  |  |  |  |  |  |  |  | A Z X 2
 |  |  |  |  |  |  |  |  |  |  | B Z 1
 |  |  |  |  |  |  |  |  |  |  | C Z X Y 3
 |  |  |  |  |  |  |  |  |  |  | I would like to convert this data to a format that shows the
 |  |  |  |  |  |  |  |  |  |  | Title 1 repeated on [Counter] number of rows with each "Item" listed beside it. Such that the end product is as follows:
 |  |  |  |  |  |  |  |  |  |  | Title 1 Item
 |  |  |  |  |  |  |  |  |  |  | A Z
 |  |  |  |  |  |  |  |  |  |  | A X
 |  |  |  |  |  |  |  |  |  |  | B Z
 |  |  |  |  |  |  |  |  |  |  | C Z
 |  |  |  |  |  |  |  |  |  |  | C X
 |  |  |  |  |  |  |  |  |  |  | C Y
 |  |  |  |  |  |  |  |  |  |  | Does anyone have a solution to this? Please let me know if you need more information.
 |  |  |  |  |  |  |  |  |  |  | Thanks.
Spreadsheet: 773435d1647865232-maintain-a-history-of-a-cells-changes-history
Sheet: Data

A1 | B1 | Rank | Name
1 | 2 |  | A
3 | 4 |  | B
1 | 9 |  | C
5 | 7 |  | D
9 | 5 |  | E
3 | 6 |  | F
2 | 6 |  | G
6 | 9 |  | H
9 | 9 |  | I
Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 7-4

ES3/C&S WHOLESALE LOAD TRACKING
STOP 1 WILL ALWAYS BE ORIGIN - LEAVE SECTION BLANK FOR ANY NON-APPLICALBE STOP, ON ANY GIVE LOAD
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
Spreadsheet: 125315d1318964140-if-then-time-timetoshift
Sheet: Sheet1

Time
Spreadsheet: 878898d1726221261-help-with-a-formula-report-example
Sheet: x Report

Start Date | 2024-04-01 00:00:00 |  |  | Start Date | 2024-05-01 00:00:00 |  |  | Start Date | 2024-06-01 00:00:00 |  |  | Start Date | 2024-07-01 00:00:00
Apr |  |  |  | May |  |  |  | June |  |  |  | July
Open 1st of Month | Open Last of Month | Closed within Month | % Completed within 30 Days | Open 1st of Month | Open Last of Month | Closed within Month | % Completed within 30 Days | Open 1st of Month | Open Last of Month | Closed within Month | % Completed within 30 Days | Open 1st of Month | Open Last of Month | Closed within Month | % Completed within 30 Days
Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Fin Stats and Ratios

Financing Assumptions & Critical Ratios
Assets Purchased |  |  |  | US $
Sources |  |  |  | US$ |  | Uses |  |  |  | US$
Equity |  |  |  |  |  | Acquire Equity
Debt |  |  |  |  |  | Other Fees and Expenses |  |  |  | 0
Total
[NAME] |  |  |  | % of Total Capitalization | Term | Interest Rate | Early Pre-Payment | Amortization Method ** | % Amortized*
 |  |  | SeniorTranche A (US$) | 0.5 | 10 |  | 1 | 2 | 1
 |  |  | Senior Tranche B (US$) | 0 | 8 |  | 1 | 2 | 0.2
 |  |  | Junior Debt ($US) |  | 7 |  | 0 | 1 | 0
 |  |  | Revolver | N/A | N/A | 0.095 | 1 | N/A | N/A
 |  |  | Debt Cash Sweep | 0.5
 |  |  | Dividend Pay-out Ratio | 0.5 | **METHOD - 1=No Amortization, 2=Partial  Amortization, 3=Mortgage
Revolver Stats
Relvolver limit ($[NAME]) - 50% of WC
Liquidity Discount |  |  |  | 0
FCF toggle
% of TV included in the equity portion of purchase price:
Debt Assumptions |  |  |  |  |  |  | Valuation Multiples |  |  |  | US$
Senior Debt/EBITDA (2000) |  |  |  |  | 2.6 |  | Firm Value per 2001 tonne
Min. EBITDA/Interest |  |  |  |  | 3 |  | Firm Value to 2000 EBITDA
Actual EBITDA/Interest |  |  |  |  |  |  | Firm Value to 2001 EBITDA
Default |  |  |  |  |  |  | Firm Value to 5-Yr Ave EBITDA (historical)
[NAME]. Total Debt/Total Capitalization |  |  |  |  |  |  | Firm Value to 5-Yr Ave EBITDA (projected)
Actual Total Debt/Total Capitalization |  |  |  |  |  |  | 2001 P/E
Total Debt/EBITDA (2000) |  |  |  |  |  |  | 2002 P/E
Min. (EBITDA-CapEx)/Cash Charges
2001 (EBITDA-CapEx)/Cash Charges
Spreadsheet: 180617f2-5564-4d92-97f1-cbb152cc344f
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
FSIS Est. No. | Company Name | City | State | Type of Facility | Product Name | Product Code | Description | Bone-in/ Boneless | Canada | Colombia | Dominican Republic | Ecuador | Japan | Korea | Lebanon | Malaysia | Peru | Russia | Singapore | St. Lucia | Taiwan | Thailand | Ukraine | Vietnam
Spreadsheet: 386063d1427568823-filtering-but-ignoring-numbers-example-5-
Sheet: Sheet1

1 Letsby ave |  | Name
2 Letsby ave
3 [NAME] ave
4 Letsby ave
5 [NAME] ave
5 [NAME] ave
5 [NAME] ave
5 [NAME] ave
7 Letsby Ave
2 Round Rd
3 Round Rd
4 Round Rd
5 Round Rd
5 Round Rd
5 Round Rd
5 Round Rd
5 Round Rd
1 Red Rd
1 Red Rd
1 Red Rd
1 Red Rd
2 Red Rd
Spreadsheet: 2b929b04-c437-4231-afdd-a566533a1d1b
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Human Resources | 1 | HR [NAME] at the two campuses | None | -- Pick One --
Human Resources | 1 | Improve communication media to employees | None | -- Pick One --
Human Resources | 1 | Reduce the number of worker's compensation claims files | None | -- Pick One --
Human Resources | 2 | Develop a Health and Wellness Program | None | -- Pick One --
Human Resources | 1 | Efficient Recruitment and Hiring | None | -- Pick One -- | 3.1.r1 | Human Resources Information System (HRIS) | OneTime | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Human Resources | 1 | Develop a Mentoring Program for New Hires | None | -- Pick One --
Human Resources | 1 | Board Policies and Administrative Procedures | None | -- Pick One --
Human Resources | 2 | Human Resources Standard Operating Procedures Manual | None | -- Pick One -- | 5.2.r1 | Procedures Manual and Employee Handbook | OnGoing | 5000 | 0 | 1500 | 3500 | 750 | 4250 | 0 | 0
Human Resources | 3 | Develop Employee Handbook | None | -- Pick One --
Human Resources | 1 | Conduct a Training Needs Assessment | None | -- Pick One --
Human Resources | 1 | Develop a training program for managers and classified employees. | None | -- Pick One --
Human Resources | 1 | Develop an training evaluation tool. | None | -- Pick One --
Spreadsheet: 0ce2335f-ac62-43e6-838c-c41267f2d1da
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 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $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
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 857762d1706686142-how-to-remove-names-text-if-repeated-in-another-cell-schedule-aligw
Sheet: Jan-24

 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2023-01-29 00:00:00 | 2023-01-30 00:00:00 | 2023-01-31 00:00:00 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00
Location 1 |  | [NAME] | [NAME] | [NAME]
Location 2 |  | [NAME] | [NAME]
Location 3 |  |  |  |  | Alicia | Alicia
Location 4 |  | [NAME] | [NAME] | [NAME] | Ally | [NAME]
Location 5
Location 6
Location 7
Location 8
Location 9
Location 10
Location 11 |  |  |  | [NAME] | [NAME] | [NAME]
Task1 |  | Gail / Lori | Sami / Glenn | Krystal / Krysta | Tracy/ [NAME] | Allison / Lori
[NAME] |  | Alicia | Ally | [NAME] | [NAME] | [NAME]
Office
WFH |  | Sami | [NAME], [NAME], [NAME] | [NAME]
Meetings |  | Krystal
Meetings
Vacation/TOIL |  |  | [NAME] |  | Krystal | Krystal
Other |  | Krystal Appt @ 12:55 |  |  |  | [NAME] 11:00
Other
I have 7 field staff that I need to keep an eye on their schedule (names are in the 'Table' worksheet), and they show up in row 16.  As those staff members are allocated locations/tasks, their names are automatically removed from the line (16).  Perfect!
Well, it all works perfectly apart from one thing! I have one non-field staff member whose name does not need to be in line 16, but at times may show up in lines 17-22.  The problem is that because the name is so close to another it is
The reason…One of the field staff has the name "[NAME]" and the other is "Krystal"
So, if I enter "Krystal" into the any of the cells (C17:G22), "Krysta" disappears from line 16 (See C21, F20, and F21)
Is there a way changing this?
Spreadsheet: 108557d1305607721-excel-2007-solver-help-return
Sheet: corralartion 

 | AMP | BHP | QBE | CSL | FGL | NCM | WOW | WPL | WBC | ANZ
AMP | 1
BHP | 0.4246768870190017 | 1
QBE | 0.3286695663816844 | 0.2245599617272228 | 1
CSL | 0.1616898274704886 | 0.156954306833682 | 0.10636221122707 | 1
FGL | 0.2484604275243842 | 0.2015314723364642 | 0.1421438212646651 | 0.1277038558108671 | 1
NCM | 0.05422962951204739 | 0.09697996735717962 | 0.01333388917281169 | 0.01585797175432514 | 0.001602525684716701 | 1
WOW | 0.4180418579444978 | 0.3579681603905298 | 0.2639145725748087 | 0.235548635099162 | 0.3244620335939979 | 0.01747339638241635 | 1
WPL | -0.3410000936438826 | -0.6013016977766785 | -0.1283735559329935 | -0.1501060230412112 | -0.1443706425086009 | -0.09105197272602805 | -0.2810530677472944 | 1
WBC | -0.1409308697653216 | -0.05806002138801485 | -0.05772286873285429 | -0.07226773017185559 | -0.07858711720867499 | -0.01505135306745191 | -0.1583363617955528 | 0.06727845431977948 | 1
ANZ | -0.155842203466563 | -0.07796093439487689 | -0.005667689831078597 | -0.07542259793584626 | -0.08862367275922595 | -0.01510829030401374 | -0.1831401811598439 | 0.07689043922636787 | 0.3552267774120364 | 1