tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 694206d1599436506-count-unique-values-count_exact_now_unique_updated
Sheet: Sheet2

 | Head-0 | [NAME] | Head2 | Head3 | Head4 | Head5 | Head6 | [NAME] | Head8 | Head9 | Head10 | Head11 | Head12 | Head13 | Total
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: December

 |  |  |  |  |  |  |  |  | DEC
 |  |  |  | Office and Operations Closed
 | NOTES
Spreadsheet: 66526d1267155157-top-10-list-example
Sheet: Sheet1

Top 10 |  |  | Name | Time
 |  |  | Name 1 | 1.25
 |  |  | Name 2 | 2.15
 |  |  | Name 3 | 2.05
 |  |  | Name 4 | 2.1
 |  |  | Name 5 | 1.55
 |  |  | Name 6 | 1.57
 |  |  | Name 7 | 1.42
 |  |  | Name 8 | 2.11
 |  |  | Name 9 | 2.07
 |  |  | Name 10 | 1.27
 |  |  | Name 11 | 1.37
 |  |  | Name 12 | 2.26
 |  |  | Name 13 | 1.15
 |  |  | Name 14 | 1.45
 |  |  | Name 15 | 1.55
 |  |  | Name 16 | 1.43
 |  |  | Name 17 | 1.27
 |  |  | Name 18 | 2.01
 |  |  | Name 19 | 2.17
 |  |  | Name 20 | 1.35
 |  |  | Name 21 | 1.26
 |  |  | Name 22 | 2.18
 |  |  | Name 23 | 1.59
 |  |  | Name 24 | 2.01
 |  |  | Name 25 | 1.36
 |  |  | Name 26 | 1.47
 |  |  | Name 27 | 1.54
 |  |  | Name 28 | 1.22
 |  |  | Name 29 | 2.47
 |  |  | Name 30 | 1.41
Spreadsheet: 600657d1543894984-tiered-buyers-fee-with-a-twist-test-sheet
Sheet: Ritchie

Bid Price |  | Buyers Fee |  | should |  | Total USD |  | Transaction Fees
USD |  | Varies USD |  | be |  | Subtotal |  | 0 | 5000 | 0.1
 |  |  |  |  |  |  |  | 5000.01 | 33500 | 0.0385
5000 |  |  |  | 500 |  |  |  | 33500.01 |  | 1290
6000 |  |  |  | 500
7000 |  |  |  | 500 |  |  |  | Fees
8000 |  |  |  | 500
9000 |  |  |  | 500 |  |  | 1) | 10% on all [NAME] selling for USD $5,000 or less
10000 |  |  |  | 500 |  |  | 2) | 3.85% on all [NAME] selling for over USD $5,000 up to USD $33,500, with a minimum fee of USD $500 per Lot or
11000 |  |  |  | 500 |  |  | 3) | USD $1,290 on all [NAME] selling for over USD $33,500
12000 |  |  |  | 500
13000 |  |  |  |  |  |  |  | Right
14000 |  |  |  |  |  |  |  | Wrong
15000
16000 |  |  |  |  |  |  |  | [NAME]:
17000 |  |  |  |  |  |  |  | =IF(AND($a4*LOOKUP($a4,$I$2:$I$4,$K$2:$K$4)>500,500),IF(AND($a4*LOOKUP($a4,$I$2:$I$4,$K$2:$K$4)<33500),$a4*LOOKUP($a4,$I$2:$I$4,$K$2:$K$4),1290))
18000
19000
20000
21000
22000
23000
24000
25000
26000
27000
28000
29000
30000
31000
32000
33000
34000
35000
36000
37000
38000
39000
40000
41000
42000
43000
44000
45000
46000
47000
48000
49000
50000
Spreadsheet: 564f0100-7bb1-41bb-8f45-7280d4e39b62
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44301128 | 2014-12-04 15:37:59 | AXIS | 0 | 2 | 5 | 280430 | [NAME] | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
Spreadsheet: 230663d1366830277-limiting-a-certain-number-of-rows-with-advanced-filter-products
Sheet: Master

Product | Region | Customer Type | Agent ID
Desktop | Mid-west | Individual | Agent Bond
Laptop | West | SME | Agent [NAME]
[NAME]. | North | Large Corporate | Agent [NAME]
Monitor | East | Non-profit | Agent [NAME]
Software | South |  | Agent [NAME]
Accessories |  |  | Agent [NAME]
Spreadsheet: 101903d1299956582-template-sheets-setting-formulas-cashflow-copia
Sheet: cashflowtemplate

 | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec
Grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales
Total Cash Inflow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payments
Wages
Advertising
Rent
Other overhead costs
Total Cash Outflow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net cash flow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Opening Balance
Closing Balance
Spreadsheet: 695213d1600099345-count-number-of-cells-between-2-repeating-values-eg
Sheet: Sheet1

 | DATE | ASSET CHECKED | DAYS SINCE LAST ASSET CHECK
 | 2020-01-01 00:00:00 | 1 |  | EXPECTED RESULTS
 | 2020-01-02 00:00:00 | 2
 | 2020-01-03 00:00:00 | 3
 | 2020-01-04 00:00:00 | 4
 | 2020-01-05 00:00:00 | 5
 | 2020-01-06 00:00:00 | 2 | 4
 | 2020-01-07 00:00:00 | 1 | 6
 | 2020-01-08 00:00:00 | 3 | 5
 | 2020-01-09 00:00:00 | 4 | 5
 | 2020-01-10 00:00:00 | 5 | 5
 | 2020-01-11 00:00:00 | 1 | 5
 | 2020-01-12 00:00:00 | 2 | 5
 | 2020-01-13 00:00:00 | 3 | 5
 | 2020-01-14 00:00:00 | 4 | 5
 | 2020-01-15 00:00:00 | 5 | 5
Spreadsheet: 887917d1738239997-combining-vlookups-on-multiple-sheets-book2-bytemarks-
Sheet: Sheet1

ABC-one
ABC-two
ABC-three
ABC-four
ABC-five
ABC-six
ABC-seven
ABC-eight
ABC-nine
ABC-ten
Spreadsheet: 850830d1701177935-formulas-not-calculating-debt-payoff
Sheet: Velar

 | Velar Info
 | Current Balance | 26894
 | Interest Rate | 0.0456
 | Interest-Only Payment | 102.1972
 | A. Calculate Months to Payoff |  |  | Months | Payment | Interest
 | Monthly Payment | 862.83 |  | 12 | 2296.908391553094 | 668.9006986371242
 | (Needs to be greater than the interest-only payment) |  |  | 18 | 1548.628102596479 | 981.3058467366282
 |  |  |  | 24 | 1174.584815470623 | 1296.035571294957
 | Months to Payoff | 33.23851100883068 | (2.77 years) | 30 | 950.2363009968365 | 1613.089029905095
 | Total Interest | 1785.184453749382 |  | 36 | 800.7351427779511 | 1932.465140006239
 |  |  |  | 42 | 694.0038709353279 | 2254.162579283769
 | B. Calculate Monthly Payment |  |  | 54 | 551.8243511177294 | 2904.514960357388
 | Payoff Goal (Months) | 12 | (1 years) | 60 | 502.1194343931348 | 3233.166063588087
 | Monthly Payment | 2296.908391553094
 | Total Interest | 668.9006986371242
Spreadsheet: 1a756e2a-607b-4d81-ad92-f1716d062d44
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 18. COMMERCIAL FINANCE COMMITMENTS, Revolving Credit By Industry: Australia, Original ($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
Agriculture, forestry and fishing ; |  |  | Original | A2414246T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414247V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414248W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414249X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414250J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414252L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414254T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414255V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414256W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414257X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414258A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL REVOLVING CREDIT ; |  |  | Original | A2414259C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 763259d1642086559-lookup-to-return-first-non-error-match-in-a-lookup-matrix-sr-matching
Sheet: Staff Deets

Name | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Column1 | Column2 | Column3 | Column4
Units | Concord: Allergy | Concord: Primary Care | Manchester - 100 Hitchcock Way: Urgent Appointments | Manchester - 100 Hitchcock Way: Antioagulation Clinic | Notre Dame Pavilion - Catholic Medical Center (NDP): NCCC - Norris Cotton Cancer Center | Manchester - 100 Hitchcock Way: Family Practice | Manchester - 100 Hitchcock Way: Urgent Appointments | Concord: OBGYN
 | Concord: Endocrinology | Concord: Endocrinology |  | [NAME]: Family Practice | Concord: General [NAME] | Manchester - 100 Hitchcock Way: Pediatrics | [NAME]: Urgent Appointments
 | Concord: Dermatology | Concord: Dermatology |  | [NAME]: General Internal Medicine | [NAME]: Allergy and Infusion
 | Concord: Pediatrics | Concord: Pediatrics |  | [NAME]: Orthopaedics, Podiatry, Spine | [NAME]: NCCC - Norris Cotton Cancer Center
 | Concord: General [NAME] | Concord: General [NAME] |  | [NAME]: Hudson Family Medicine | [NAME]: Urgent Appointments
 | Concord: Primary Care | Concord: Orthopedics |  | [NAME]: Merrimack Family Medicine
 | Manchester - 100 Hitchcock Way: Dermatology & Mohs | Concord: Cardiology |  | [NAME]: Milford Family Medicine
 | Manchester - 100 Hitchcock Way: Family Practice | Concord: Vascular
 | Manchester - 100 Hitchcock Way: Complex Primary Care | Concord: OBGYN
 | Manchester - 100 Hitchcock Way: Pediatrics | Manchester - 100 Hitchcock Way: General Surgery
 | Notre Dame Pavilion - Catholic Medical Center (NDP): Pediatric Neurology | Manchester - 100 Hitchcock Way: Rheumatology
 | [NAME] (BF): Family Medicine | Manchester - 100 Hitchcock Way: Cardiology
 | [NAME] (BF): Internal Medicine | Manchester - 100 Hitchcock Way: Family Practice
 | [NAME] (BF): Pediatrics | Manchester - 100 Hitchcock Way: Internal Med
 | [NAME] (BSC): Allergy and Immunology | Manchester - 100 Hitchcock Way: Pediatrics
 |  | Manchester - 100 Hitchcock Way: Urology
 |  | Notre Dame Pavilion - Catholic Medical Center (NDP): NCCC - Norris Cotton Cancer Center
 |  | [NAME] (BF): Family Medicine
 |  | [NAME] (BF): Internal Medicine
 |  | [NAME] (BF): Pediatrics
 |  | [NAME]: Dermatology
 |  | [NAME]: NCCC - Norris Cotton Cancer Center
 |  | [NAME]: Infectious Disease
Spreadsheet: 453891d1459507605-rank-kopia-ranking
Sheet: Sheet1

Name | marks |  | TOP 10 |  |  | Bottom 10
[NAME] | 10 |  | Name | Marks |  | Name | Marks
Silva | 4
Rubi | 51
trumo | 5
gane | 24
fred | 84
[NAME] | 42
sere | 12
kala | 47
[NAME] | 45
[NAME] | 6
ckse | 35
aswi | 45
oale | 62
;aksje | 5
jkelr | 91
jease | 45
koeaa | 75
lkeaa | 22
keea | 21
Spreadsheet: 790192d1659590409-10-day-rolling-values-on-chart-10-day-rolling-values-on-chart
Sheet: Sheet1

2022-01-01 00:00:00 | 45 |  | Enter date |  |  |  | 10 day rolling values on chart
 | 66 |  | Last ? Days | 5 |  |  | https://www.excelforum.com/excel-formulas-and-functions/1384334-10-day-rolling-values-on-chart.html
 | 36
 | 27 |  |  |  |  |  | Date = INDEX($A$1:$A$35,MATCH($E$1-$E$2+1,$A$1:$A$35,0)):INDEX($A$1:$A$35,MATCH($E$1,$A$1:$A$35,0))
 | 11 |  |  |  |  |  | Value = INDEX($B$1:$B$35,MATCH($E$1-$E$2+1,$A$1:$A$35,0)):INDEX($B$1:$B$35,MATCH($E$1,$A$1:$A$35,0))
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
Spreadsheet: 793536d1661525102-return-row-value-with-reference-to-separate-worksheets-column-value-show-value-of-row-with-ref-to-column-value-exclude-hidden-rows
Sheet: Result

ID# | Value1 | Value2 | Value3 | Report1 | Report2 | Report3 | Issue= | Don't show the value of hidden rows of Source in Results
 | 22.908 | 31.681 | 22.94
2326575 | 22.85 | 33.359 | 22.978
2326580 | 22.486 | 30.422 | 23.642
2326585 | 23.865 | 31.538 | 23.754
2326597 | 24.811 | 33.289 | 24.345
2326608 | 23.046 | 32.11 | 23.293
Spreadsheet: 216978d1361953546-percentage-change-between-a-range-of-numbers-please-help-projecting-profits-test
Sheet: Monthly 3

 | January | February | March | April | May | June | July | August | September | October | November | December
Year 1 | -0.009962562460937381 |  |  |  |  |  |  |  |  |  |  |  | 2.443753414112213 | Total (%)
Year 2 |  |  |  |  |  |  |  |  |  |  |  |  | 1.452521701460486 | Total (%)
Year 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (%)
Year 1 |  |  |  |  |  |  |  |  |  | Profit (£) | Gain (%)
 |  |  |  |  |  |  |  | Account Balance |  | 135197.5558052388 | 21.53292596753981
 |  |  |  |  |  |  |  | Peak Drawdown
 |  |  |  |  |  |  |  | Losing Streak
 |  |  |  |  |  |  |  | Winning Streak
Spreadsheet: 124285d1318298425-trying-to-search-table-to-return-value-book1
Sheet: Data Sheet

TABLE A |  |  |  |  | TABLE B
Start Date | End Date | Trainer 1 |  |  | Week Beginning | [NAME] | [NAME] | Anna | Emma
2012-04-23 00:00:00 | 2012-04-27 23:59:00 | [NAME] |  |  | 2012-04-23 00:00:00 | 1 | 1 | 0 | 0
2012-04-23 00:00:00 | 2012-04-27 23:59:00 | [NAME] |  |  | 2012-05-07 00:00:00 | 1 | 1 | 1 | 0
2012-05-07 00:00:00 | 2012-05-11 23:59:00 | [NAME] |  |  | 2012-05-18 00:00:00 | 0 | 0 | 0 | 1
2012-05-07 00:00:00 | 2012-05-11 23:59:00 | Anna |  |  | 2012-06-04 00:00:00 | 1 | 1 | 0 | 0
2012-05-07 00:00:00 | 2012-05-11 23:59:00 | [NAME] |  |  | 2012-06-11 00:00:00 | 1 | 0 | 0 | 0
2012-05-14 00:00:00 | 2012-05-18 23:59:00 | Emma |  |  | 2012-08-09 00:00:00 | 0 | 0 | 0 | 1
2012-06-04 00:00:00 | 2012-06-08 23:59:00 | [NAME]
2012-06-04 00:00:00 | 2012-06-08 23:59:00 | [NAME]
2012-06-11 00:00:00 | 2012-06-15 23:59:00 | [NAME]
2012-08-09 00:00:00 | 2012-08-17 23:59:00 | Emma
Spreadsheet: 110335d1307030920-probability-question-talent-competition-ef778018-probability
Sheet: Sheet1

 |  | Act 1 | Act 2 | Act 3 | Act 4 | Act 5 | Act 6 | Act 7
 |  | 0.1 | 0.6 | 0.3 | 0.01 | 0.05 | 0.1 | 0.4
 | Outcome |  |  |  |  |  |  |  |  | Count | Prob |  | Count | Prob
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
Spreadsheet: 821024d1678399752-help-with-xlookup-to-search-particular-row-example-spreadsheet
Sheet: Sheet1

Unit | 2020-01-01 00:00:00
A1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
A2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
A3 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
B1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
B2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
B3 | [NAME] | [NAME] | Ric Flair | Ric Flair | Ric Flair | [NAME] | [NAME]
Unit | Tenancy Name | Start | End
A1 | [NAME]
A1 | [NAME]
A2 | [NAME]
A3 | [NAME] | 2020-01-01 00:00:00 | 2020-03-01 00:00:00
A3 | [NAME]
A3 | [NAME]
B1 | [NAME]
B1 | [NAME]
B2 | [NAME]
B2 | [NAME] | 2020-02-01 00:00:00 | 2020-07-01 00:00:00
B3 | [NAME]
B3 | Ric Flair
B3 | [NAME]
Spreadsheet: 05410cf6-153d-477c-bc4a-1a8714921b43
Sheet: Sheet1

Municipal Judge - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/24/2013 10:37:10 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | write-in | TOTALS
Precinct 91 | 483 | 3 | 486
Precinct 92 | 542 | 4 | 546
Precinct 93 | 463 | 11 | 474
Precinct 94 | 383 | 3 | 386
Precinct 95 | 478 | 4 | 482
Precinct 96 | 340 | 3 | 343
TOTAL | 2689 | 28 | 2717
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 67c24ba0-79d1-4abc-95b2-55e7f5b7d3e9
Sheet: EPMO Matrix

[NAME]
Project Management Deliverables | Project Scaling
 | Level One | Level Two | Level Three *
PRE-INITIATION
Project Request Form **
Project Scaling Worksheet | Required | Required | Required
INITIATING
Project Charter | Required | Required | Required
Project Scope | Required | Required | Optional
Requirements Document | Required | Required | Required
PLANNING
Scope Management Plan | Required | Optional | Optional
Change Management Plan | Required | Required | Required
Time Management Plan | Required | Required | Optional
Cost Management Plan | Required | Required | Optional
Quality  Management Plan | Required | Required | Optional
Resource  Management Plan | Required | Required | Optional
Communications Management Plan | Required | Required | Required
Risk Management Plan | Required | Required | Optional
Procurement Management Plan *** | Required | Optional | Optional
Requirements Management Plan | Required | Required | Optional
Issues Management Plan | Required | Required | Required
Document Management Plan | Required | Required | Optional
EXECUTING
Meetings (Agenda, Minutes) | Required | Required | Required
Status Reports | Required | Required | Required
Manage Deliverables (SDLC or Other)
Product Deliverables | Required | Required | Required
MONITORING & CONTROLLING
Project Log**** | Required | Required | Required
Report Performance Metrics | Required | Required | Optional
CLOSING
Project Closeout CheckList | Required | Required | Optional
* A Project Workbook is available that contains all necessary deliverables in a single file
** Refer to ITB-EPM006 for projects that require a Project Request Form to be approved
*** When applicable
**** For Level 1 projects a project log that consists of all the required project management deliverables are contained in a single file.
Spreadsheet: 755244d1636731781-spreading-contract-amount-across-months-by-start-end-date-revenuerecoghelp
Sheet: RevForecast-High Prob

 | SUMMARY
 | RevType1 |  |  | (I will hide these columns for the final workbook)
 | RevType2
 | RevType3
 | TOTAL
 | TOTAL VS BUDGET CHECK - SHOULD BE $0
 | Customer: Name | Item: Name | Amount | Number of months | Monthly Amount | Start Date | End Date | Revenue Type | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | Full Range | DIFFERENCE
 | Customer 1 | Product 1 | 85000 |  |  | 2022-02-01 00:00:00 | 2022-07-31 00:00:00 | RevType1
 | Customer 2 | Product 2 | 325000 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 | RevType2
 | Customer 3 | Product 3 | 152000 |  |  | 2022-06-01 00:00:00 | 2022-12-31 00:00:00 | RevType3
 | Customer 4 | Product 1 | 500000 |  |  | 2022-06-15 00:00:00 | 2023-06-14 00:00:00 | RevType1
 |  |  |  |  |  |  | Totals
Spreadsheet: 851468d1701703580-how-to-index-if-corresponding-lookup-table-has-ph1-and-not-ph11-how-to-index-multiple-entires-in-a-table-of-data
Sheet: Sheet1

 |  |  | PH1 - Manual Handling | Z001 - Environmental Conditions
 |  |  |  | Z002 - Loud or continuous noise emitted by the equipment.
 |  |  |  | Z003 - Damaged Batteries | PH1 - Manual Handling
 |  |  |  | Z004 - Damaged equipment
 |  |  |  | Z005 - Incorrect battery disposal. | PH11
 |  |  |  | Z006 - Hazardous Materials
 |  |  |  | Z007 - Incorrect Operation Practices | PH1 - Manual Handling PH5 - Moving parts
 |  |  | PH1 - Manual Handling | Z001 - Environmental Conditions
 |  |  |  | Z002 - Loud or continuous noise emitted by the equipment.
 |  |  |  | Z003 - Damaged Batteries | PH1
 |  |  |  | Z004 - Damaged equipment
 |  |  |  | Z005 - Incorrect battery disposal. | PH11
 |  |  |  | Z006 - Hazardous Materials
 |  |  |  | Z007 - Incorrect Operation Practices | PH1, PH5
Spreadsheet: 873927d1720529527-inventory-consolidation-binning-example-data-tireguy91-
Sheet: Sheet1

Product | Location | Quantity On Hand | ReverseLot Code | Units Per Pallet | Week | Year | Sunday of Wk | Separation (Wks) | 26 | 52 | 78 |  | Example outcome showing locations gained by consolidation
185941_111 | 04F076 | 16 | 1924 | 16
185941_111 | 04F077 | 16 | 5122 | 16
185941_111 | 04F078 | 16 | 1923 | 16 |  |  |  |  |  |  |  |  | Product | Current Locations | New Locations - 6MO | New Locations - 12MO | New Locations - 18MO
185941_114 | 04F079 | 16 | 5323 | 16 |  |  |  |  |  |  |  |  | 185941_111
086988_101 | 04F080 | 25 | 923 | 25 |  |  |  |  |  |  |  |  | 185941_114
564595_102 | 04F081 | 20 | 4322 | 20 |  |  |  |  |  |  |  |  | 086988_101
027316_101 | 04F082 | 25 | 1924 | 25 |  |  |  |  |  |  |  |  | 564595_102
027316_101 | 04F083 | 25 | 1724 | 25 |  |  |  |  |  |  |  |  | 027316_101
027316_101 | 04F084 | 20 | 1124 | 25 |  |  |  |  |  |  |  |  | 159398_101
159398_101 | 04F105 | 30 | 623 | 25 |  |  |  |  |  |  |  |  | 300837_101
300837_101 | 04F106 | 16 | 724 | 16 |  |  |  |  |  |  |  |  | 993257_101
300837_101 | 04F107 | 16 | 723 | 16 |  |  |  |  |  |  |  |  | 502833_101
300837_101 | 04F108 | 16 | 724 | 16
993257_101 | 04F109 | 30 | 924 | 30
993257_101 | 04F110 | 30 | 1524 | 30
993257_101 | 04F111 | 29 | 1924 | 30
993257_101 | 04F112 | 30 | 1924 | 30
502833_101 | 04F113 | 18 | 1724 | 20
502833_101 | 04F114 | 20 | 1523 | 20
Spreadsheet: 146198d1331970886-calculation-of-betas-of-a-multiple-regression-rolling-window-multiple-regression
Sheet: Single regression

Date | Return | X1
1975-11-30 00:00:00 | 0.04338637277991565 | 0.0179
1975-12-31 00:00:00 | -0.02149655326173015 | 0.0189
1976-01-31 00:00:00 | 0.03204243742928258 | 0.0175
1976-02-29 00:00:00 | -0.03307168081731783 | 0.0188
1976-03-31 00:00:00 | 0.02298002207667653 | 0.0179
1976-04-30 00:00:00 | -0.004038614255871554 | 0.0179
1976-05-31 00:00:00 | -0.01641156749238457 | 0.0186
1976-06-30 00:00:00 | -0.02282373449704601 | 0.0195
1976-07-31 00:00:00 | 0.01823886922194974 | 0.0186
1976-08-31 00:00:00 | 0.01693893871062664 | 0.0232 |  | intercept | b(1)
1976-09-30 00:00:00 | 0.03903725759230302 | 0.0212
1976-10-31 00:00:00 | -0.005051318594596297 | 0.0214
1976-11-30 00:00:00 | 0.001215431540637672 | 0.0213
1976-12-31 00:00:00 | 0.005216336297357372 | 0.0211
1977-01-31 00:00:00 | -0.04272602050373696 | 0.0231
1977-02-28 00:00:00 | -0.01321837730307184 | 0.0235
1977-03-31 00:00:00 | -0.02056279694093769 | 0.0246
1977-04-30 00:00:00 | 0.007373314044300716 | 0.0306
1977-05-31 00:00:00 | -0.005855282426457731 | 0.0308
1977-06-30 00:00:00 | 0.01738680385012852 | 0.0296
1977-07-31 00:00:00 | 0.01209499623551703 | 0.0287
1977-08-31 00:00:00 | 0.0269834896855935 | 0.0269
Spreadsheet: 71029d1271778567-quotation-populate-date-from-price-list-sample-quote
Sheet: DATA

Price List
QTY | PART NO | [NAME] | PRICE | EXTENDED PRICE
0 | 125458 | Application Software  F/1 | 500 | 0
1 | 125459 | Application Software  F/2 | 800 | 800
0 | 125460 | Application Software  F/3 | 1100 | 0
1 | 125461 | Server Core2Due | 1200 | 1200
0 | 125462 | Harddisk 34 | 400 | 0
1 | 125463 | Raid controller | 200 | 200
 |  | Total |  | 2200