tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813211d1673615523-if-value-in-column-then-replace-with-new-cell-value-but-no-action-if-cell-empty-tip-calculations-test-2
Sheet: TIPS SPLIT

 |  | DATE
# |  | 1st
 | STAFF TIPS TOTAL |  | number is from sheet 1
 | STAFF WORKING |  | amount of staff working on that day from sheet 1
 | AMOUNT to be paid |  | amount to be paid to each staff member
11 | STAFF 1
12 | STAFF 2
13 | STAFF 3 |  | Would like 1 replace with value in C5
14 | STAFF 4
15 | STAFF 5
16 | STAFF 6
17 | STAFF 7
18 | STAFF 8
19 | STAFF 9
20 | STAFF 10
 | SHEET 2
Spreadsheet: 735961d1623279180-help-on-calculating-deposit-amounts-based-on-percentages-and-adding-totals-for-each-month-example-summary-sheet-calculation
Sheet: SUPERSEDED WIPAA

 | Enter Your Tax Rate Here
 | Job Name | Starting Margin | Revised Contract | Budget To Build | Claimed To Date | Actual Invoices | % Complete | Related Purchase Invoices | WIP Calculation | Gross Profit | Gross Margin
 |  | % | (Inc Tax) | (Inc Tax) | (Inc Tax) | (Inc Tax) |  | (Inc Tax) | (Ex-Tax) | (Ex-Tax)
 | Revised Contract Price |  |  | Workflow (Ex-Tax)
 | Budget To Build |  |  | Margin
 | Claimed To Date
 | Actual Invoices Processed
 | % Complete
 | Related Purchase Invoices
 | WIP Calculation
 | Create 2 New Nominal Codes
 | 1 in the Balance Sheet 'WIP Bal'
 | 1 in the Profit & Loss 'WIP P&L'
 | Last Day Of Month Relating To Calculation | 2020-01-31 00:00:00
 | Journal Entries | Date | Account | Type | Amount
 |  |  | WIP (Bal)
 |  |  | WIP (P&L)
 |  |  | WIP (Bal)
 |  |  | WIP (P&L)
Spreadsheet: 794950d1662430508-formula-to-search-value-across-multiple-sheets-example
Sheet: Session 5

Attended |  | Awaiting Arrival | Cancelled | No Show
Course: [Course Name] |  |  |  | Course Status: | Tentative
Date: | Monday 21st November |  | Time: [Time]
Department: [Department] |  |  | Facilitator: [Facilitator]
Location: [Location]
 | Name | Role | Leader | Notes
1 | [NAME]
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Select hyperlink to return to schedule → |  | Schedule
Spreadsheet: 117039d1312404218-sum-values-in-table-if-criteria-exists-in-another-table-conditionalsumwithlookup
Sheet: Remaining Work over Time

Task ID | 7/18/2011 | 7/19/2011 | 7/20/2011 | 7/21/2011 | 7/22/2011 | 7/23/2011 | 7/24/2011 | 7/25/2011 | 7/26/2011 | 7/27/2011 | 7/28/2011 | 7/29/2011
25144 | 6 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0
24967 | 9 | 6 | 6 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 0 | 0
24969 | 6 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0
25183 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 0 | 0 | 0 | 0
25184 | 6 | 6 | 6 | 6 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0
25007 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0
25008 | 6 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25034 | 10 | 10 | 10 | 6 | 6 | 6 | 6 | 1 | 0 | 0 | 0 | 0
25035 | 4 | 4 | 4 | 2 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
25162 |  |  |  |  |  |  |  |  |  |  | 10 | 10
25261 |  |  |  |  |  |  |  |  |  |  | 7 | 7
25055 |  | 18 | 18 | 10 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0
25004 |  |  |  |  |  |  |  |  | 8 | 4 | 1 | 1
25005 |  | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 17 | 14 | 11 | 11
25056 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25057 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
25058 |  | 16 | 10 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24891 | 8 | 8 | 8 | 6 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 0
24893 |  |  |  |  |  |  |  | 16 | 16 | 16 | 16 | 16
24894 |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8
24895 |  |  |  |  |  |  |  | 12 | 12 | 12 | 12 | 12
24905 |  |  |  |  |  |  |  |  | 10 | 10 | 10 | 10
Spreadsheet: 834568d1687907438-find-average-value-and-rank-based-on-multiple-criteria-within-same-columns-book1
Sheet: Sheet1

Year | Store | District | Sales | Avg_District_Sales | Store_District_Rank
2022 | 101 | 1 | 459 | 592.6 | 3
2022 | 102 | 2 | 828 | 450.6 | 1
2022 | 103 | 2 | 449 | 450.6 | 2
2022 | 104 | 3 | 91 | 160.5 | 2
2022 | 105 | 1 | 779 | 592.6 | 1
2022 | 106 | 1 | 540 | 592.6 | 2
2022 | 107 | 2 | 75 | 450.6 | 3
2022 | 108 | 3 | 230 | 160.5 | 1
2023 | 101 | 2 | 722 | 843 | 2
2023 | 102 | 3 | 541 | 588.6 | 2
2023 | 103 | 1 | 675 | 759.3 | 3
2023 | 104 | 3 | 481 | 588.6 | 3
2023 | 105 | 1 | 906 | 759.3 | 1
2023 | 106 | 2 | 964 | 843 | 1
2023 | 107 | 1 | 697 | 759.3 | 2
2023 | 108 | 3 | 744 | 588.6 | 1
Spreadsheet: 274173d1383041263-complex-autofill-patterns-id-contract-file-tracker-sample-2
Sheet: CF00 JT

 |  |  |  | Contract Work Summary
 |  |  |  | Contract File Reference | CF-JT | Gross Total Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J-Job
 |  |  |  | Date Created |  | Total Labour |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S- Snag
 |  |  |  | Created by |  | Total Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V- Variation
 |  |  |  | Client | Various | Total Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M - Management
 |  |  |  | Site Location | Various | Margin %
Contract Work Tracker |  |  |  |  |  |  |  |  |  | Material Expendature tracker |  |  |  |  |  |  |  | Monthly Contract Overview
Date | Address | Type | Job Reference | Description of works | Labour | Labour Value | Job value | Difference |  | Date |  | Supplier | Order Number | Invoice Reference | Value | Net Value |  | Month | Revenue | Job | Snags | CVI | Management | Total Labour | Materials | Profit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-04-01 00:00:00
Spreadsheet: 133566d1324481393-offsetting-a-formula-example
Sheet: Daily

 | Days
 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00
data | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 488984d1478957302-excel-help-vlook-up-index-small-formula-help-reporting-sheet-help-excel-help
Sheet: Stock Sheet

Auto Sums. Do Not Adjust |  |  |  | 09.10.2016-06.10.2016 |  |  | Auto Sums. Do Not Adjust
TYPE | ITEM | Supplier | Cost Each | OPENING COUNT | PURCHASED | Column1 | THEORY TOTAL | PHYSICAL COUNT | [NAME] | [NAME] | VALUE OF STOCK | Write Off/ Miscounts | Write Off ££ | Breakage | Breakage ££
 |  |  |  |  |  |  |  | 616 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 72 |  |  |  | 72
 |  |  |  | 346 |  |  |  | 251 |  |  |  |  |  | 2
 |  |  |  |  | 216 |  |  | 359 |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 105 |  |  |  | 93 |  |  |  |  |  | 3
 |  |  |  |  | 216 |  |  | 349 |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 21
 |  |  |  | 7 |  |  |  | 6
 |  |  |  | 9 |  |  |  | 9
 |  |  |  |  | 72 |  |  | 125 |  |  |  |  |  | 5
 |  |  |  | 61 |  |  |  | 61
 |  |  |  |  | 48 |  |  | 100 |  |  |  |  |  | 1
 |  |  |  | 13 | 48 |  |  | 12
 |  |  |  | 11 |  |  |  | 10
 |  |  |  | 12 |  |  |  | 12
 |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 4
 |  |  |  | 1 |  |  |  | 1
 |  |  |  |  | 120 |  |  |  |  |  |  |  |  | 3
 |  |  |  | 20 |  |  |  | 19
 |  |  |  | 1 |  |  |  | 1
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 | 120 |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  | 9
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 3 |  |  |  | 3
 |  |  |  | 1 |  |  |  | 1
 |  |  |  | 5 | 48 |  |  | 4
 |  |  |  | 14 |  |  |  | 12 |  |  |  |  |  | 1
 |  |  |  | 5 |  |  |  | 4
 |  |  |  | 46 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 166
 |  |  |  |  | 48
Category | Total Value of Stock | [NAME] cost | [NAME] |  |  |  |  | TOTALS:
Glassware
Silverware |  |  |  |  |  |  |  | After Write Offs:
Crockery
Misc
P&L Write Off Codes:
[NAME] | 67120
China | 67130
Silver | 67140
Spreadsheet: 861827d1709654087-help-having-trouble-with-formulas-mock-22-1-ans
Sheet: Sheet1

Currency |  |  |  |  |  |  |  | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
USD | 1.2 |  |  |  |  |  | Days of month
EURO | 1.15 |  | DAILY COST | OFFHIRE REF | OFFHIRE DATE |  |  | Monthly projected costs
RAND | 19 | unit 1 | 6.7 |  | 2024-02-28 00:00:00 | USD
AUD | 1.7 | Unit 2 | 6.7 |  | 2024-03-03 00:00:00 | USD
NZD | 1.9 | Unit 3 | 6.7 |  | 2024-01-29 00:00:00 | USD
SK | 12 | Unit 4 | 6.7 |  | 2025-01-05 00:00:00 | USD
NOK | 11.7 | Unit 5 | 6.7 |  |  | USD
GBP | 1 | Unit 6 | 6.7 |  |  | USD
 |  | Unit 7 | 6.7 |  |  | USD
 |  | Unit 8 | 6.7 |  |  | USD
 |  | Unit 9 | 6.7 |  |  | USD
 |  | Unit 10 | 6.7 |  |  | USD
 |  | Unit 11 | 6.7 |  |  | USD
 |  | Unit 12 | 6.7 |  | 2024-06-06 00:00:00 | GBP
 |  | Unit 13 | 6.7 |  | 2024-05-15 00:00:00 | USD
 |  | Unit 14 | 6.7 |  |  | USD
Spreadsheet: 82181d1282204456-problem-with-offset-count-formula-query
Sheet: Athletes

Athlete Num | Athlete Name | Club | Age Category
1 | AA | A | Master Men M1-M3
2 | BB | B | Master Men M4+
3 | CC | C | Senior Women
4 | DD | D | Senior Men
5 | EE | E | Senior Women
6 | FF | F | Senior Women
7 | GG | G | Master Men M1-M3
8 | HH | H | Senior Women
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 694052d1599317674-how-to-apply-filter-formula-for-multiple-conditions-copy-of-processing-efficiency-akshay6s-
Sheet: Sheet2

 | 2020-06-19 00:00:00 | SINGHANIA FINISHERS |  | 2020-07-02 00:00:00 | 2020-07-09 00:00:00
 | PROCESS | [NAME] | KGS SENT | MTR RECEIVED | KGS RECEIVED
 | TOTAL
Spreadsheet: 691136d1597505046-count-formula-on-multiple-matches-testing
Sheet: Sheet1

[NAME] | Gred2 | Gred3 |  | A | B | C | D | E | F
B | F | B
F | D | F
A | E | A
F | F | F
F | A | B
F | F | F
C | F | F
F | F | F
B | C | F
C | A | F
Spreadsheet: 114044d1309911519-adding-percentages-template
Sheet: Pricing Sheet

SAR SEB QUOTED REPAIRS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATA
PROJECT  NAME |  |  |  |  |  |  |  |  | CRM |  |  |  |  |  |  |  |  |  |  |  |  |  | names
[NAME] |  |  |  |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  |  |  | 2011-07-06 00:00:00 |  | 0 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
POSTAL ADDRESS |  |  |  |  |  |  |  | ESTIMATOR |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
SUBURB |  |  |  | STATE |  | P/C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME]
CONTACT NAME
TITLE
 | MATERIAL |  |  |  |  | LABOUR |  |  |  |  | SELL PRICE
[NAME] | Qty | Price | Material Cost | %Mat MARGIN | TOTAL MAT | No. Men | [NAME] | LABOUR COST | LABOUR MARGIN | TOTAL LAB
 | 1 | 25 | 25 | 0.4 |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  | 0 |  |  |  |  | 0 |  |  | 0
Hourly Rate Cost | 62 |  | Material Cost | 25 | Material Marg/Rev |  | 0.4 | 0.8 | [NAME] | Material Sell | 45
Hourly Rate Sell | 124 |  | Labour Cost | 0 | [NAME] |  | 0.4 | 0.8 | [NAME] | [NAME] | 0
 |  |  | Job Cost | 25 | Job Marg/Rev |  | 0.4 | 0.8 | [NAME] | Job Sell | 45
 |  |  | Job Total Hours | 0 |  |  |  |  |  | Forcast Margin | 20
 |  |  |  |  |  |  |  |  |  | GST | 4.5
Sell Price Excluding G.S.T | 45 |  |  | Sell Price Including G.S.T |  |  | 49.50000000000001
Spreadsheet: 727268d1617810683-data-rearrange-help-needed-data-setup-problem
Sheet: Sheet1

Current structure |  |  |  | Desired structure
Student ID | Subject | Marks |  | Student ID | Subject 1 | Marks | Subject 2 | Marks | Subject 3 | Marks
1 | English | 80 |  | 1 | English | 80 | Math | 78 | Science | 70
1 | Math | 78 |  | 2 | Math | 89 | English | 80
1 | Science | 70 |  | 3 | Math | 90
2 | Math | 89 |  | 4 | Science | 70 | English | 60 | Math | 85
2 | English | 80 |  | 5 | Math | 80 | Science | 85
3 | Math | 90
4 | Science | 70
4 | English | 60
4 | Math | 85
5 | Math | 80
5 | Science | 85
Spreadsheet: john_griffith__16154__1_25_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 52 | 120 | 220 | 31.9 | 58.5 | 1.48 | 2002-01-25 11:52:00
 | [NAME] | 52 | 550 | 650 | 45.6 | 54 | 1.63 | 2002-01-25 11:52:00
 | HO J2 | 52 | 780 | 880 | 47.1 | 53.2 | 1.64 | 2002-01-25 11:52:00
 | HO K2 | 53 | 920 | 1020 | 44.3 | 49.2 | 1.56 | 2002-01-25 11:52:00
 | HO M2 | 53 | 1030 | 1130 | 42.6 | 46.8 | 1.49 | 2002-01-25 11:52:00
 | HO N2 | 53 | 1100 | 1200 | 41.2 | 45 | 1.44 | 2002-01-25 11:52:00
 | HO Q2 | 54 | 1180 | 1280 | 39.7 | 43.1 | 1.41 | 2002-01-25 11:52:00
 | HO U2 | 56 | 1250 | 1375 | 37.6 | 41.4 | 1.39 | 2002-01-25 11:52:00
 | [NAME] | 57 | 1275 | 1325 | 35.4 | 36.8 | 1.29 | 2002-01-25 11:52:00
 | HO X2 | 57 | 1350 | 1500 | 35.4 | 39.4 | 1.34 | 2002-01-25 11:52:00
 | [NAME] | 58 | 1400 | 1550 | 34.5 | 38.2 | 1.33 | 2002-01-25 11:52:00
 | HO F3 | 59 | 1425 | 1625 | 33.1 | 37.8 | 1.31 | 2002-01-25 11:52:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: craig_dean__4355__11-1act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: ae795867-c89f-4e80-8ada-a6c76a320140
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PCAB | Test | PCAB | Parietal Cell Antibodies, IgG, Serum | Parietal Cell Ab, IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.45 mL | Hemolysis	Mild OK; Gross reject Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Heat-treated specimen | Negative: < or =20.0 Units Equivocal: 20.1-24.9 Units Positive: > or =25.0 Units  Reference values apply to all ages. | Monday, Wednesday, Friday; 3 p.m. | 1 day | 4 days | 1 | 83516 |  |  |  |  | Rochester
PCAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
PCAB | Result | PCAB | Parietal Cell Ab, IgG, S | Parietal Cell Ab, IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 40960-7 | Parietal cell [NAME].IgG:ACnc:Pt:Ser:Qn:
Spreadsheet: 809874d1671398194-discount-rates-formula-and-npv-investment-model_help
Sheet: IRR of diff

 |  |  |  |  |  | 2022-12-01 00:00:00
 | Rental Revenue Discount Rate |  |  | 0.0686
 | Residual Value Discount Rate |  |  | 0.08
 | Cash Flow
 | Rental Revenue |  |  |  |  | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86
 | Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17952165
 | Unlevered Cash Flow, PV
 | Residual, PV
 | Unlevered Present Value
 | Unlevered Cash Flow
 | Interest Expense |  |  |  |  | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667
 | [NAME]
 | Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Debt Payoff |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -15307908.73
 | Net Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Proof of Concept (IRR of debt CF)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diff | NPV | Same?
 | [NAME], PV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest Expense
 | Net Residual, PV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt Payoff
 | Levered Present Value
 |  |  |  | NPV Difference |  |  |  |  |  | exact NPV |  |  |  |  |  |  |  |  |  |  | NPV of debt CF
 |  |  |  |  | IRR CF
 |  |  |  |  | IRR |  |  |  |  | exact IRR |  |  |  |  |  |  |  |  |  |  | IRR of debt CF
 |  |  |  | Proof of Concept (IRR of difference between unlevered and levered CFs)
 |  |  |  | Unlevered CF PV
 |  |  |  | Residual CF PV
 |  |  |  | Unlevered NPV
 |  |  |  | [NAME]
 |  |  |  | Net Residual PV
 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Difference
 |  |  |  | NPV Difference |  |  |  |  |  | exact NPV
 |  |  |  | Difference CF NPV |  |  |  |  |  | exact NPV
Spreadsheet: 66465d1267111018-formula-returns-value-error-dwsample
Sheet: Sheet1

Title | % Complete
Test1 | N/A
Test2 | N/A
Test3 | N/A
Test4 | N/A
Test5 | N/A
Test6 | N/A
[NAME] | N/A
Test8 | N/A
Test9 | N/A
Test10 | N/A
Spreadsheet: 886070d1736052306-sum-or-filter-question-testfile
Sheet: Single Job Lookup

Search by Job #: |  | 3
Date | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME]
 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL
 | Agent Total Chgs | Carrier | Ocean Freight (Collect) | VGM/Solas (weighing)Handling Fee | FOB | Liability | Warehouse Charge | AMS Security Fee | ISF 10+2 | THC/ Handling @ Origin | Pick-up/ Trucking Charge | [NAME]
AGT-2 | 1016.48 | ZIM | 285.13 | 37.32 | 136.44 | 6.93 | 12.06 | 100.65 | 85.52 | 154.4 | 188.6 | 9.43
 | Co-Loader Total Chgs: | THC/ Origin HC | Stripping | [NAME] | I.T. Prep | Chassis Usage/ Suchg (CUC) | Equip Schg | Low Sulfur or [NAME] | CFS/Port Sec I.S.P.S. Fee
CoLoad-1 | 294.84 | 61.45 | 30.73 | 55 | 35 | 15 | 17.66 | 35 | 45
 | Total CFS Charges: | CFS Charge
[NAME] | 293.09 | 293.09
 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | AGT-2 | 1016.48 | ZIM | 285.13 | 37.32 | 136.44 | 6.93 | 12.06 | 100.65 | 85.52 | 154.4 | 188.6 | 9.43
Spreadsheet: 593879d1539363801-add-sum-2-columns-book3
Sheet: Sheet1

[NAME] | A2 |  | B2 |  | F6 |  |  | [NAME] | IT1 | IT2 | IT3 | IT4 | IT5 | IT6
 | min | [NAME] | min | [NAME] | min | [NAME]
1 | 270 |  | 34 |  | 284 |  |  | 1 | 270 | 100 | 34 | 500 | 284 | 124
2 | 324 |  | 67 |  | 321 |  |  | 2 | 324 | 200 | 67 | 654 | 321 | 234
3 | 562 |  | 78 |  | 532 |  |  | 3 | 562 | 300 | 78 | 567 | 532 | 345
4 | 358 |  | 92 |  | 290 |  |  | 4 | 358 | 400 | 92 | 890 | 290 | 567
I want to MATCH A2 with IT2 so I can have : A2 max = A2 min + IT2
Same, B2 with IT2 or F6 with IT6
A2 [NAME] | 270+100
A2 [NAME] | 324+200
A2 [NAME] | 562+300
A2 [NAME] | 358+400
Spreadsheet: 080a4563-deda-4d3b-815c-2c8b8303ac6c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5901 | 41470 | Gerda | Brault | CAN | 2505 | 00:18:57 | 00:04:57 | 00:41:27 | 00:04:39 | 00:33:24 | 1 | 01:43:24
5901 | 29259 | Pattie | Townsend | USA | 2508 | 00:19:54 | 00:05:28 | 00:43:17 | 00:06:00 | [NAME] | 2 | 01:54:29
5901 | 43608 | [NAME] | Kelly | USA | 2507 | 00:29:18 | 00:07:52 | 00:53:06 | 00:08:23 | [NAME] | 3 | 02:27:30
5901 | 21314 | [NAME] | [NAME] | USA | 2506 | [NAME] | 00:08:03 | 00:50:36 | 00:07:29 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 853268d1703155738-non-contiguous-cells-and-linest-function-file-of-how-i-would-like-it-to-be
Sheet: Øvrige

 | Measurement 1
 |  | Abs | Norm | In(Norm) |  |  |  |  |  |  | A1 | Batch xxxxxx |  |  |  |  | B1 | Batch xxxxxx
 |  | 287.3 |  |  |  |  | Hours
 | ID |  |  |  |  |  |  |  |  |  | a |  |  |  |  |  | a | xxxx
 | A1 | 0.5326 |  |  |  |  | 0 |  |  |  | b |  |  |  |  |  | b | xxxx
 | B1 |  |  |  |  |  |  |  |  |  | R^2 |  |  |  |  |  | R^2 | xxxx
 | A2
 | B2 |  |  |  |  |  |  |  |  |  | A2 | Batch xxxxxx |  |  |  |  | B2 | Batch xxxxxx
 | Measurement 2 |  |  |  |  |  |  |  |  |  | a | xxxx |  |  |  |  | a | xxxx
 |  | Abs | Norm | In(Norm) |  |  |  |  |  |  | b | xxxx |  |  |  |  | b | xxxx
 |  | 287.3 |  |  |  |  | Hours |  |  |  | R^2 | xxxx |  |  |  |  | R^2 | xxxx
 | ID
 | A1 | 0.2814 |  |  |  |  | 24
 | B1
 | A2
 | B2
 | Measurement 3
 |  | Abs | Norm | In(Norm)
 |  |  |  |  |  |  | Hours
 | ID
 | A1 | 0.2531 |  |  |  |  | 27
 | B1
 | A2
 | B2
 | Measurement 4
 |  | Abs | Norm | In(Norm)
 |  |  |  |  |  |  | Hours
 | ID
 | A1 | 0.1556 |  |  |  |  | 45
 | B1
 | A2
 | B2