tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__15673__05_11_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 425 | 34.5 | 35
N01-P/C | 435 | 64.5 | 65.5
Q01-P/C | 440 | 83 | 85.5
U01-P/C | 445 | 100 | 102
V01-P/C | 445 | 116 | 118
X01-P/C | 465 | 134 | 136
[NAME]-P/C | 480 | 153 | 154.5
F02-P/C | 485 | 168 | 172
G02-P/C | 475 | 172 | 177
H02-P/C | 455 | 158 | 163
J02-P/C | 425 | 117 | 126
K02-P/C | 415 | 110 | 120
M02-P/C | 420 | 113 | 123
U02-P/C | 425
Spreadsheet: 23187d1212593118-sorting-issue-646103
Sheet: Sheet1

Term | Year | Season
Spring | 2002 | 2 |  |  |  |  |  |  |  | Summer | 1
Summer | 2002 | 1 |  |  |  |  |  |  |  | Spring | 2
Summer | 2002 | 1 |  |  | Sort By Term and then Season |  |  |  |  | Fall | 3
Summer | 2002 | 1
Summer | 2003 | 1
Summer | 2003 | 1
Summer | 2004 | 1
Summer | 2004 | 1
Summer | 2004 | 1
Summer | 2004 | 1
Summer | 2004 | 1
Summer | 2004 | 1
Fall | 2005 | 3
Summer | 2005 | 1
Summer | 2005 | 1
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 14

1113
Name | Amount
Name 2 | 181
Name 2 | 179
Name 1 | 178
Name 2 | 104
Name 2 | 109
Name 2 | 139
Name 3 | 115
Name 1 | 118
Name 2 | 105
Name 1 | 178
Name 1 | 103
Name 2 | 190
Name 2 | 126
Name 2 | 121
Name 2 | 173
Name 3 | 150
Name 1 | 191
Name 1 | 170
Name 2 | 152
Name 2 | 132
Name 3 | 147
Name 2 | 176
Name 2 | 146
Name 3 | 200
Name 1 | 175
Spreadsheet: 217863d1362234983-if-and-functions-identifying-text-dmc180409
Sheet: Sheet1

[NAME] | Size | Small | Colour | Blue | 1
[NAME] | Size | Small | Colour | Blue | 1
[NAME] | Size | Small | Colour | Maroon | 2
[NAME] | Size | Small | Colour | Indigo | 3
[NAME] | Size | Small | Colour | Indigo | 3
AA002-Bottoms | Size | Small | Colour | Blue | 1
AA002-Bottoms | Size | Small | Colour | Red | 2
AA002-Bottoms | Size | Small | Colour | Violet | 3
AA002-Bottoms | Size | Small | Colour | Orange | 4
Spreadsheet: 1aa81685-cbf3-4127-978a-a03af5a296ef
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | STUDENT EMPLOYMENT TIMESHEET
 |  | Name |  |  |  | FHSU
 |  |  | Student Name |  |  | ID # | 8-digit ID
 |  | Department Name
 |  | & Number |  | Dept. name |  |  | Acct. no.
State of Kansas |  | Earnings type: |  |  | Pay
Time and Leave Document |  | Workstudy | Regular |  | Period | 2013-12-22 00:00:00 | to | 2014-01-04 00:00:00
WEEK ONE | SUN | MON | TUE | WED | THU | FRI | SAT
MONTH/DAY | 2013-12-22 00:00:00 | 2013-12-23 00:00:00 | 2013-12-24 00:00:00 | 2013-12-25 00:00:00 | 2013-12-26 00:00:00 | 2013-12-27 00:00:00 | 2013-12-28 00:00:00
IN/OUT TIME
IN
OUT
IN
OUT
IN
OUT |  |  |  |  |  |  |  | TOTAL
IN |  |  |  |  |  |  |  | HOURS
OUT |  |  |  |  |  |  |  | Week 1
TOTALS
WEEK TWO | SUN | MON | TUE | WED | THU | FRI | SAT
MONTH/DAY | 2013-12-29 00:00:00 | 2013-12-30 00:00:00 | 2013-12-31 00:00:00 | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00
IN/OUT TIME
IN
OUT
IN
OUT
IN
OUT |  |  |  |  |  |  |  | TOTAL
IN |  |  |  |  |  |  |  | HOURS
OUT |  |  |  |  |  |  |  | Week 2
TOTALS
 |  |  |  |  | Total hours worked for
 |  |  |  |  | two week pay period
Employee's Signature |  |  |  |  |  | Date
I certify that I have worked the hours as recorded above.
[NAME]'s Signature |  |  |  |  |  | Date
I certify that the above named student has worked the hours as shown above.
Departments must retain student timesheets for five years.
Spreadsheet: john_griffith__16172__1_28_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 57 | 30 | 120 | 36.3 | 53.3 | 1.61 | 2002-01-25 15:08:00
 | [NAME] | 59 | 620 | 720 | 47.7 | 55.4 | 1.91 | 2002-01-28 14:58:00
 | [NAME] | 66 | 940 | 1020 | 45.9 | 49.8 | 1.99 | 2002-01-28 14:58:00
 | [NAME] | 66 | 1150 | 1250 | 45.2 | 49.2 | 1.96 | 2002-01-28 14:58:00
 | [NAME] | 66 | 1280 | 1380 | 43 | 46.4 | 1.85 | 2002-01-28 14:58:00
 | HU N2 | 66 | 1390 | 1450 | 42.2 | 44.1 | 1.79 | 2002-01-28 14:58:00
 | [NAME] | 65 | 1400 | 1475 | 39.4 | 41.6 | 1.66 | 2002-01-28 14:58:00
 | HU U2 | 63 | 1375 | 1500 | 37 | 40.4 | 1.53 | 2002-01-28 14:58:00
 | [NAME] | 60 | 1400 | 1525 | 37.2 | 40.6 | 1.47 | 2002-01-28 14:58:00
 | [NAME] | 59 | 1400 | 1550 | 35.7 | 39.5 | 1.39 | 2002-01-28 14:58:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 1772ea6e-1294-4f2f-b612-83ff298e6b25
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Semester: __________________ | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Year: __________ | Unnamed: 9 | Unnamed: 10 | Course: ____________________ | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
Undergraduate o  Graduate o | Articulation |  | Fluency |  | Voice/Resn |  | Swallowing |  | Language |  | Audiology |  | Cogn Aspcts |  | Soc Aspcts |  | [NAME]. |  | TOTAL
 | Adult | Child | Adult | Child | Adult | Child | Adult | Child | Adult | Child | Adult | Child | Adult | Child | Adult | Child | Adult | Child
EVALUATION
Screening and Prevention |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Case History and Integration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Appropriate Evaluation Procedures |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Adapt Evaluation Procedures |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
*Interpret, Integrate & Synthesize |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
*Complete Administration& Reporting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
*Refer Clients and Patients |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
INTERVENTION |  |  |  |  |  |  |  |  |  |  | Aural Rehab
*Develop Setting-Appropriate Plans |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Implement Intervention Plans |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Select, Develop & Use Appropriate Materials & Instruments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Measure & Evaluate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Modify Plans, Strategies, Materials & Instruments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
*Complete Administration& Reporting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
*Identify & Refer Clients/Patients |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DIRECT CLIENT CONT. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]'s Full Name ______________________________________________   [NAME]'s Signature ________________________________________________________
Practicum Site ______________________________________     Practicum Completion Date _____________________  [NAME]'s [NAME]. No __________________________
Student's Name (Printed) ___________________________________________________________    Student's Signature: ____________________________________________________
Department Chair/Designee ____________________________________________________________________________________     Date _____________________________
Spreadsheet: 056d1f47-b8a2-4341-abcf-cd20459a4c68
Sheet: Sheet1

Contract No. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | FORCE ACCOUNT RECAP, | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | SHEET  1 of 1
[NAME]:
ITEM No. |  |  |  | CHANGE ORDER AMOUNT : |  |  |  |  | A.E.B. No.
REPORT No. | DATE | LABOR | EQUIP | MATERIALS | DAILY TOTAL | ACCUM   TOTAL | AMT. PAID PER EST | PAID EST.       NO & DATE | REMARKS
FINAL TOTALS |  | 0 | 0 | 0
Spreadsheet: 270180d1381410278-trying-to-get-an-if-formula-to-show-more-than-one-answer-help
Sheet: Sheet1

Project Code | Class | Order Value | Recognised | To Recognise
PM08H | SA | 8500 | 8500 | 0
PM38H | A | 8500 | 0 | 8500
PM41H | C | 1170 | 0 | 1170
PM40H | C | 150 | 150 | 0
PM39H | C | 850 | 850 | 0
PM35H | C | 3750 | 3750 | 0
PM37H | C | 6375 | 6375 | 0
PM36H | C | 475 | 475 | 0
PM33H | C | 475 | 0 | 475
PM34H | C | 150 | 150 | 0
PM32H | C | 1700 | 0 | 1700
PM31H | C | 850 | 850 | 0
PM30H | B | 11250 | 5625 | 5625
PM27H | SA | 8500 | 8500 | 0
PM28H | C | 850 | 850 | 0
PM24H | B | 15750 | 15750 | 0
PM20H | SA | 21250 | 0 | 21250
PM19H | SA | 21240.44 | 21240.44 | 0
PM18H | SA | 21240.44 | 21240.44 | 0
PM17H | SA | 21240.44 | 21240.44 | 0
PM22H | C | 480 | 0 | 480
PM23H | C | 4250 | 4250 | 0
PM15H | C | 1049.7 | 1049.7 | 0
PM13H | B | 21250 | 21250 | 0
PM10H | C | 850 | 0 | 850
PM89G | SA | 4666.5 | 0 | 4666.5
PM67G | B | 22672 | 22672 | 0
PM92G | A | 49016 | 49016 | 0
PM74G | A | 85000 | 85000 | 0
PM90G | B | 19823 | 0 | 19823
PM87G | A | 113250 | 113250 | 0
PM96F-2 | A | 14662.5 | 14662.5 | 0
PM78G | B | 0 | 0 | 0
PM04G | A | 52763 | 36985.98 | 15777.02
[NAME] | A | 51421.43 | 39835.57 | 11585.86
PM44G | A | 126225 | 82876 | 43349
PM99F | A | 273700 | 267750 | 5950
PM96F-1 | A | 14662.5 | 14662.5 | 0
PM71F | B | 16150 | 16150 | 0
PM99E | B | 8500 | 8500 | 0
PM43E | B | 23075 | 6922 | 16153
Spreadsheet: 185807d1349846796-need-a-macro-to-append-data-from-one-worksheet-to-another-in-the-same-workbook-master-copy
Sheet: Sheet1

 |  |  |  |  | Client
 | [NAME] | Dr |  |  | No. | Holdings | Remark
87 | J3 | 5I | 13128UK | 2 | 13128 | 7125 | USD
82 | J3 | WF | 102531UK | 2 | 102531 | 5035 | USD
81 | J3 | RW | 185072UK | 2 | 185072 | 45000 | USD
65 | J3 | 5I | 13050UK | 2 | 13050 | 57143 | USD
64 | J3 | MJ | 371058UK | 2 | 371058 | 936 | USD
61 | J3 | 5I | 13421UK | 2 | 13421 | 18000 | USD
53 | J3 | TA | 176629UK | 2 | 176629 | 325 | USD
45 | J3 | JL | 241015UK | 2 | 241015 | 17816 | USD
21 | J3 | TA | 297366UK | 2 | 297366 | 2376 | USD
13 | J3 | TA | 682049UK | 2 | 682049 | 38875 | USD
2 | J3 | 1B | 29831UK | 2 | 29831 | 178373 | USD
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 837563d1690259350-if-formula-for-part-of-cell-entry-meeting-multiple-criteria-countifs_not-equal-after-x-characters-dustin6-
Sheet: Sheet1

Paye Group | Comments | Date Value | OWN PAYE |  | External |  | Total Number of Characters
OWN PAYE | 03/07/2023 CSH khkhkhkhkhkhkh |  |  | Correct |  | Correct |  | Should not be counted
External | 2023-07-03 00:00:00 | 2023-07-03 00:00:00
OWN PAYE | 05/07/2023 CSH | 2023-07-05 00:00:00 |  |  |  |  |  | No characters after this number should be counted
Spreadsheet: 776234d1649620354-sum-of-top-5-and-averages-test-1-
Sheet: Sheet2

Team | [NAME] | [NAME] Average1 | Salary Average2
ARI
ATL
CIN
CLE
HOU
KC
LAA
NYM
PIT
SD
STL
WAS
Spreadsheet: 856258d1705574428-how-to-join-2-excel-sheets-with-a-common-column-sample-data
Sheet: Sheet1

 | Source File1 |  |  |  | Source File 2 |  |  |  | Destination File (Desired)
 | User | Role |  |  | Role | Privilege |  |  | User | Role | Privilege
 | A | AA |  |  | AA | 123 |  |  | A | AA | 123
 | A | BB |  |  | AA | 345 |  |  | A | AA | 345
 | B | AA |  |  | BB | 456 |  |  | A | BB | 456
 | C | BB |  |  | BB | 678 |  |  | A | BB | 678
 | D | ZZ |  |  | CC | 910 |  |  | B | AA | 123
 |  |  |  |  |  |  |  |  | B | AA | 345
 |  |  |  |  |  |  |  |  | C | BB | 456
 |  |  |  |  |  |  |  |  | C | BB | 678
Spreadsheet: 697613d1601447381-using-index-and-match-but-omitting-some-results-report-help
Sheet: Report

For: | [NAME]
Network | Contact | Sign Stat | [NAME] stat | Path stat | Address | Sign | PATH | DROP
Spreadsheet: 743362d1628442602-copying-rows-on-one-sheet-to-another-sheet-based-on-criteria-from-one-column-testjackpot
Sheet: SHORT GO

Team # | INC Team | Header | Heeler | Total on 2
Spreadsheet: 164278d1340718745-transposing-across-multiple-worksheets-startend
Sheet: END

3000000
4000000
5000000
6000000
7000000
8000000
9000000
10000000
11000000
12000000
13000000
14000000
15000000
16000000
17000000
18000000
19000000
20000000
21000000
22000000
Spreadsheet: 759549d1639590233-error-trapping-if-and-multiple-cells-must-all-have-error-sample
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | CHECK | CHECK | CHECK | CHECK | CHECK | CHECK | CHECK | CHECK
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
5 | 5 | 5 | 5 | 5 | NO | 5 | 5 |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
Spreadsheet: kate_symes__18142__Deal Correction 2-9
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-02-09 00:00:00 | 2001-02-09 00:00:00 | 2001-02-08 00:00:00 | LTSW | KS | Houston | TFS | Delivery Point: from SP to Palo |  | 517599 | Palo | Q3-02 | On [NAME] | 25 | 210 | SPP
 | 2001-02-09 00:00:00 | 2001-02-09 00:00:00 | 2000-12-06 00:00:00 | LTSW | MM | Houston | Natsource | Broker fee: from 0 to .0075 |  | 475170 | SP-15 | Q3-01 | On [NAME] | 25 | 200 | EES
 |  |  |  | Grand Count
Spreadsheet: db1565ef-f0e1-4e85-abc7-1880a0a6e878
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF DECEMBER 9, 2013 THROUGH DECEMBER 13, 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, December 9, 2013
09:30:00 | CA#3940-VCN | Vice Chancellor [NAME] | Trial | In re Nine Systems Corporation | Dover
10:00:00 | CA#8667-VCG | Vice Chancellor Glasscock | Trial | [NAME] | [NAME]
Tuesday, December 10, 2013
09:30:00 | CA#3940-VCN | Vice Chancellor [NAME] | Trial | In re Nine Systems Corporation | Dover
10:00:00 | CA#6907-VCP | Vice Chancellor Parsons | Settlement Hearing | In re Harleysville | [NAME]
01:30:00 | CA#8499-MA | Master [NAME] | RTSC Hearing | [NAME] v. [NAME] et al. | Georgetown
02:30:00 | CA#8476-VCG | Vice Chancellor Glasscock | PI Hearing | [NAME] | Georgetown
Wednesday, December 11, 2013
08:30:00 | CA#9105-VCN | Vice Chancellor [NAME] | PI Hearing | [NAME] v. Mindspeed Technologies, Inc. | Dover
09:30:00 | CA#3940-VCN | Vice Chancellor [NAME] | Trial | In re Nine Systems Corporation | Dover
10:00:00 | CA#7786-VCP | Vice Chancellor Parsons | Oral Argument | IMX v. MultiPlan | [NAME]
02:00:00 | CA#7016-VCP | Vice Chancellor Parsons | Oral Argument | MPEG v. Dell | [NAME]
02:00:00 | CA#8432-ML | Master [NAME] | Oral Argument | [NAME] et [NAME] et [NAME]. | [NAME]
Thursday, December 12, 2013
09:30:00 |  | Master [NAME] | NCC Petitions |  | [NAME]
09:30:00 | CA#3940-VCN | Vice Chancellor [NAME] | Trial | In re Nine Systems Corporation | Dover
10:00:00 | CA#8855-CS | Chancellor [NAME] | Oral Argument | Nielson v Carlson & Cheap Trick | [NAME]
01:30:00 | CA#9021-VCG | Vice Chancellor Glasscock | Oral Argument | Castlepoint Insurance Co. v. Avon Road Partners | [NAME]
Friday, December 13, 2013
09:30:00 |  | Master [NAME] | SC Petitions |  | Georgetown
09:30:00 | CA#3940-VCN | Vice Chancellor [NAME] | Trial | In re Nine Systems Corporation | Dover
10:00:00 | CA#8942-VCP | Vice Chancellor Parsons | Oral Argument | [NAME] | [NAME]
11:30:00 | CA#6336-VCG | Vice Chancellor Glasscock | RTSC Hearing | In re Fourtune Partners, LLC. | Georgetown
01:30:00 |  | Master [NAME] | Guardianship Hearing |  | Georgetown
Spreadsheet: 115113d1310734906-excel-2007-vertical-error-bars-under-stacked-bar-chart-data-784329
Sheet: Sheet1

 | Start | [NAME] | GridlineValue | Yvalue |  | Grinline Position
a | 1 | 5 |  | 0 |  | 1
b | 2 | 4 |  | 0 |  | 2.5
c | 3 | 3 |  | 0 |  | 4
d | 4 | 4 |  | 0 |  | 6.2 |  |  |  | 1902-09-26 00:00:00
e | 5 | 3 |  | 0 |  | 7.8
Spreadsheet: 124354d1318346725-vlookup-problem-sample
Sheet: Sheet2

 | Select Name
 | Franklin
1986 |  |  |  |  |  |  |  | 2
1987 |  |  |  |  |  |  |  | 3
1988 |  |  |  |  |  |  |  | 4
1989 |  |  |  |  |  |  |  | 5
1990 |  |  |  |  |  |  |  | 6
1991 |  |  |  |  |  |  |  | 7
1992 |  |  |  |  |  |  |  | 8
1993 |  |  |  |  |  |  |  | 9
1994 |  |  |  |  |  |  |  | 10
1995 |  |  |  |  |  |  |  | 11
1996 |  |  |  |  |  |  |  | 12
1997 |  |  |  |  |  |  |  | 13
1998 |  |  |  |  |  |  |  | 14
1999 |  |  |  |  |  |  |  | 15
2000 |  |  |  |  |  |  |  | 16
2001 |  |  |  |  |  |  |  | 17
2002 |  |  |  |  |  |  |  | 18
2003 |  |  |  |  |  |  |  | 19
2004 |  |  |  |  |  |  |  | 20
2005 |  |  |  |  |  |  |  | 21
2006 |  |  |  |  |  |  |  | 22
2007 |  |  |  |  |  |  |  | 23
2008 |  |  |  |  |  |  |  | 24
2009 |  |  |  |  |  |  |  | 25
2010 |  |  |  |  |  |  |  | 26
Spreadsheet: 849629d1700057372-i-forgot-how-to-rearrange-cells-book2_corti
Sheet: Sheet1

WHAT I HAVE
ID | identifier | GPBW | SOOP | TIV | X | FOTE | CIB | KP | KT
10 | C.acrifolius |  |  |  |  | FOTE 712
11 | C.acutispissipes |  |  |  |  |  | CIBI4 15-17, 161,162
12 | C.acutispissipes |  |  |  |  |  |  |  | KT 106
13 | C.acutispissipes |  | SOOP 64
14 | C.acutorum | GPBW5 196
15 | C.acutostriaculus |  |  | TIV 63
16 | C.acutovelatus | GPBW5 196
17 | C.acutovelatus |  | SOOP 101
WHAT I WANT TO HAVE
ID | identifier | GPBW | SOOP | TIV | X | FOTE | CIB | KP | KT
10 | C.acrifolius |  |  |  |  | FOTE 712
13 | C.acutispissipes |  | SOOP 64 |  |  |  | CIBI4 15-17, 161,162 |  | KT 106
14 | C.acutorum | GPBW5 196
15 | C.acutostriaculus |  |  | TIV 63
16 | C.acutovelatus | GPBW5 196 | SOOP 101
Spreadsheet: 840465d1692757639-would-like-to-list-several-cells-from-a-lookup-incl-other-data-vstack-hstack-mosom-4-1-
Sheet: Sheet2

Manager: | Manager 3
Roles: |  |  |  |  |  |  |  |  |  |  | Role 3 | Role 5
 | Role 3 |  | Topic 1 | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 5
 | Role 5 |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 |  | y
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | y |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 1 |  | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n
 |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n
Spreadsheet: 861339d1709223867-irr-true-ups-for-minimum-return-thresholds-irr-true-ups
Sheet: JT

 |  |  |  |  | The investor needs to make 12%, no matter the cash flows or timing. We need to tell the customer at any given point in time how much the payoff amount would be to make the IRR 12% based on a set of projections
 |  |  |  |  | How do I automatically find the payoff in each period to make the IRR equal to a target value instead of goal seeking every value highlighted in yellow?
 |  |  |  |  | Target IRR |  | 0.06
 |  |  |  |  | Example 1 |  |  |  |  |  |  | Discounted | Discount | Discounted
Period | Date | Cash Flow | Spot IRR |  | Period | Date | Cash Flow | Payoff |  | Net Cash Flow | Target IRR | Net Cash Flow | Factor | Net Cash Flow | Payoff
0 |  | -100 |  |  | 0 |  | -100 | 0
 |  | 5
 |  | 5
 |  | 5 |  |  |  |  |  |  | x
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
Spreadsheet: 538254d1505485573-need-a-formula-or-code-to-replace-dates-inventory-accuracy-template
Sheet: DC's

Cycle Count Period Ending August 31, 2017 - FY 18 - US Distribution Centers
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | US TOTAL
Cycle Count By Location - Period Ending August 31, 2017 - FY 18 - Canadian Distribution Centers
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | CAN TOTAL