tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_sanders__32083__attachments
Sheet: Portfolio 2 - NW Longs

[NAME]: | [NAME] of Four Portfolio Bid that Was Ultimately Scheduled at Silver Peak
 | Initial Bid
 | Price | Quantity | Price | Quantity | Price | Quantity | Price | Quantity | Unconstrained
Time | 0700 | 0700 | 0700 | 0700 |  |  |  |  | MCP
0100 | 0 | 0 | 2500 | 0 |  |  |  |  | 20.6554 | 0
0200 | 0 | 0 | 2500 | 0 |  |  |  |  | 18.3717 | 0
0300 | 0 | 0 | 2500 | 0 |  |  |  |  | 17.504 | 0
0400 | 0 | 0 | 2500 | 0 |  |  |  |  | 14.0569 | 0
0500 | 0 | 0 | 2500 | 0 |  |  |  |  | 18.9964 | 0
0600 | 0 | 0 | 2500 | 0 |  |  |  |  | 24.4967 | 0
0700 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 19.9428 | 725
0800 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 25.8947 | 725
0900 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 26.9196 | 725
1000 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 27.5973 | 725
1100 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 28.3814 | 725
1200 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 28.1807 | 725
1300 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 27.999 | 725
1400 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 28.7672 | 725
1500 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 28.9763 | 725
1600 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 28.1041 | 725
1700 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 28.1997 | 725
1800 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 27.0583 | 725
1900 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 26.5752 | 725
2000 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 25.6897 | 725
2100 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 29.2826 | 725
2200 | 0 | 0 | 18.97 | 0 | 18.98 | 725 | 2500 | 725 | 26.4872 | 725
2300 | 0 | 0 | 2500 | 0 |  |  |  |  | 25.9942 | 0
2400 | 0 | 0 | 2500 | 0 |  |  |  |  | 24.4942 | 0
Spreadsheet: 857880d1706738985-help-with-sumifs-kansas-scheduler-v2-01312024
Sheet: Calculations

HS | Boards | SQFT | HS Formula →
No Smoothing | 90 | 2880
Light Smoothing | 60 | 1920
Heavy Smoothing | 40 | 1280
[NAME] | 30 | 960
[NAME] | 20 | 640
[NAME] | 15 | 480
[NAME] |  |  | [NAME] →
2 Pass |  | 2880
3 Pass |  | 1920
4 Pass |  | 1280
Backlit |  | 960
DS |  | 960
FU or [NAME] |  | 200
DS White |  | 480
8 Pass |  | 180
8 Pass + White |  | 150
5 Layer |  | 240
 |  | 640
3Rs | SQFT |  | 3R/HP Formula →
2 Pass | 1784
3 Pass | 1254
5-Pass | 704
Backlit | 241
2-Sided | 330
GS | Boards | SQFT | GS Formula →
Light Smoothing | 25 | 800
Heavy Smoothing | 15 | 480
[NAME] | 10 | 320
[NAME] | 10 | 320
[NAME] | 6 | 192
Spreadsheet: 526134d1499156870-top-10-table-with-criteria-s666-top10
Sheet: Feuil1

I.D | Project | Score | Cost | Action | Date |  |  |  | Project | Cat
1 | Cat | 25 | 15061 | Fix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top 10 Table
2 | Dog | 15 | 2156 | Fix |  |  |  |  | Score | I.D | Cost
3 | Whale | 5 | 561596 | Fix |  |  |  |  | 25 | 1 | 15061 |  |  |  |  |  |  |  |  |  |  |  | Project: | Cat
4 | Beetle | 10 | 56 | Fix |  |  |  |  | 25 | 19 | 561
5 | Cat | 10 | 16 | Fix |  |  |  |  | 15 | 14 | 5 |  |  |  |  |  |  |  |  |  | Position | I.D | Score | Cost
6 | Beetle | 10 | 560 | Fix |  |  |  |  | 15 | 29 | 159 |  |  |  |  |  |  |  |  |  | 1 | ????? | ????? | ?????
7 | Bird | 15 | 156 | Fix |  |  |  |  | 10 | 5 | 16 |  |  |  |  |  |  |  |  |  | 2 | ????? | ????? | ????? | The leaderboard is ordered by score relating to whatever project is chosen from the cell above and the other headings taken from the table relating to that score.
8 | Whale | 25 | 156 | Fix |  |  |  |  | 5 | 18 | 51 |  |  |  |  |  |  |  |  |  | 3 | ????? | ????? | ?????
9 | Dog | 25 | 10 | Fix |  |  |  |  | 5 | 22 | 515 |  |  |  |  |  |  |  |  |  | 4 | ????? | ????? | ?????
10 | Dog | 25 | 560156 | Fix |  |  |  |  | 5 | 23 | 159 |  |  |  |  |  |  |  |  |  | 5 | ????? | ????? | ?????
11 | Bird | 5 | 1569 | Fix |  |  |  |  | 5 | 24 | 1891 |  |  |  |  |  |  |  |  |  | 6 | ????? | ????? | ?????
12 | Fish | 5 | 1560 | Fix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | ????? | ????? | ?????
13 | Fish | 10 | 1591 | Fix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | ????? | ????? | ?????
14 | Cat | 15 | 5 | Fix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | ????? | ????? | ?????
15 | Beetle | 5 | 105 | Fix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | ????? | ????? | ?????
16 | Beetle | 10 | 156 | Fix
17 | Beetle | 10 | 5961 | Fix
18 | Cat | 5 | 51 | Fix
19 | Cat | 25 | 561 | Fix
20 | Whale | 5 | 526 | Fix
21 | Bird | 5 | 105189 | Fix
22 | Cat | 5 | 515 | Fix
23 | Cat | 5 | 159 | Fix
24 | Cat | 5 | 1891 | Fix
25 | Whale | 10 | 891 | Fix
26 | Fish | 15 | 561 | Fix
27 | Dog | 5 | 56 | Fix
28 | Fish | 5 | 123 | Fix
29 | Cat | 15 | 159 | Fix
30 | Bird | 5 | 156 | Fix
31 | Bird | 5 | 1561 | Fix
32 | Fish | 15 | 5156 | Fix
33 | Fish | 5 | 4789 | Fix
34 | Beetle | 10 | 51 | Fix
35 | Whale | 15 | 56 | Fix
36 | Dog | 5 | 648 | Fix
Spreadsheet: 60623d1261128230-countif-over-different-fields-book1
Sheet: Sheet1

ABSENCE SUMMARY
Surname | Forename | Location | Dept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Days | 2009-11-01 00:00:00 | CUM TOT
 |  |  | Team 1 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5
 |  |  | Team 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
 |  |  | Team 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Headacount for team 1 | 7 | 6
 |  |  | Team 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 |  |  | Team 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 |  |  | Team 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | Team 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
jane |  |  | Team 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Team 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 |  |  | Team 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 105905d1303168122-displaying-values-based-on-calculated-date-educational-hours2
Sheet: Sheet1

Hours/Educator by Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
User 1 | 20.75 | 16.3 | 20 | 12.8 | 6.049999999999999 | 17.95 | 12.85 | 20.25 | 0 | 0 | 0 | 0
User 2 | 20.1 | 74.3 | 60.2 | 18.15 | 6.95 | 13.6 | 16.35 | 13.35 | 16.6 | 6.3 | 0 | 0
User 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 6 | 20.1 | 74.3 | 60.2 | 18.15 | 6.95 | 13.6 | 16.35 | 13.35 | 16.6 | 6.3 | 0 | 0
User 7 | 21.5 | 16 | 16 | 16 | 16 | 7 | 14 | 0 | 0 | 0 | 0 | 0
User 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 10 | 0 | 0 | 0 | 0 | 65 | 16.25 | 87.75 | 0 | 0 | 0 | 0 | 0
User 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 82.45 | 180.9 | 156.4 | 65.10000000000001 | 100.95 | 68.4 | 147.3 | 46.95 | 33.2 | 12.6 | 0 | 0
Spreadsheet: 760157d1640025027-randomizing-pairs-from-odd-or-even-list-rand_pairings
Sheet: Sheet1

 | Event date | 2021-12-21 00:00:00
 | Participants | Randomiser |  |  | Pairings
1 | Fred |  |  | 1
2 | Barney |  |  | 2
3 | George |  |  | 3
4 | Elroy |  |  | 4
5 | [NAME]
6 | Linus
7 | Schroeder
8 | [NAME]
Spreadsheet: 727933d1618221702-index-match-formula-for-current-liabilities-and-current-assets-current-liabilities-and-current-assets
Sheet: Financial Position

I'm kindly asking for a formula which if current assets are negative they direct go to the current liabilities in [NAME] and the same to the negative current liabilities go to the Current Assets.
 |  |  |  |  | DESIRED OUTCOME
STATEMENT OF FINANCIAL POSITION:  2021 |  |  |  |  | STATEMENT OF FINANCIAL POSITION:  2021
ZWL |  | ZWL |  |  |  |  | ZWL
ASSETS |  |  |  |  | ASSETS
Property, Plant and Equipment |  |  |  |  | Property, Plant and Equipment
Intangible Assets |  |  |  |  | Intangible Assets
Total Fixed Assets |  |  |  |  | Total Fixed Assets
CURRENT ASSETS |  |  |  |  | CURRENT ASSETS
Inventories |  |  |  |  | Inventories
Trade and Other Receivables |  |  |  |  | Trade and Other Receivables
Cash and Cash Equivalents |  |  |  |  | Cash and Cash Equivalents |  | 5300
Total Current Assets |  |  |  |  | Total Current Assets
TOTAL ASSETS |  |  |  |  | TOTAL ASSETS
EQUITY AND LIABILITIES |  |  |  |  | EQUITY AND LIABILITIES
Share Capital |  |  |  |  | Share Capital
[NAME] |  |  |  |  | [NAME]
Revaluation Reserves |  |  |  |  | Revaluation Reserves
Total Equity |  |  |  |  | Total Equity
LIABILITIES |  |  |  |  | LIABILITIES
NON - CURRENT LIABILITIES |  |  |  |  | NON - CURRENT LIABILITIES
Loan |  |  |  |  | Loan
CURRENT LIABILITIES |  |  |  |  | CURRENT LIABILITIES
Trade and Other payables |  |  |  |  | Trade and Other payables |  | 165135.46
Current Tax payable |  |  |  |  | Current Tax payable
Total Current Liabilities |  |  |  |  | Total Current Liabilities
TOTAL EQUITY AND LIABILITIES |  |  |  |  | TOTAL EQUITY AND LIABILITIES
Spreadsheet: 701515d1603798752-use-count-if-formula-in-a-table-to-fetch-different-values-from-pivot-table-testing-excel
Sheet: Sheet  

 | Count | Type | ROOM | category
 | 1 | CP | ROOM 1 | Plumber |  |  |  | Count of Count | Column Labels |  |  |  |  |  |  | DESIRED
 | 2 | CP | ROOM 1 | Plumber |  |  |  | Row Labels | [NAME] | Doctor | Plumber | Grand Total |  |  |  |  | Plumber | Doctober | Carptenter
 | 3 | FO | ROOM 1 | Plumber |  |  |  | ROOM 1 | 2 | 1 | 3 | 6 |  |  |  | ROOM 1 CP | 2 | 1 | 2
 | 4 | CP | ROOM 1 | [NAME] |  |  |  | CP | 2 | 1 | 2 | 5 |  |  |  | ROOM 1 FO
 | 5 | CP | ROOM 1 | Doctor |  |  |  | FO |  |  | 1 | 1 |  |  |  | ROOM 2 CP
 | 6 | FO | ROOM 2 | [NAME] |  |  |  | ROOM 2 | 1 |  |  | 1 |  |  |  | ROOM 2 FO
 | 7 | FO | ROOM 3 | Doctor |  |  |  | FO | 1 |  |  | 1
 | 8 | FO | ROOM 4 | Plumber |  |  |  | ROOM 3 |  | 1 |  | 1
 | 9 | CP | ROOM 4 | Plumber |  |  |  | FO |  | 1 |  | 1
 | 10 | CP | ROOM 1 | [NAME] |  |  |  | ROOM 4 |  |  | 2 | 2
 |  |  |  |  |  |  |  | CP |  |  | 1 | 1
 |  |  |  |  |  |  |  | FO |  |  | 1 | 1
 |  |  |  |  |  |  |  | Grand Total | 3 | 2 | 5 | 10
Spreadsheet: 773666d1647984816-calculate-ownership-in-companies-using-a-table-and-formulas-automatically-ownership-structure
Sheet: Ownership

 | Cliente | My client
Company / Individual | [NAME] | Level | Empresa abaixo | % (level before) |  |  | Unique | Unique Individual | Level
Company | DEF LLC | 1 | My client | 1
Company | GHI | 2 | DEF LLC | 0.15 |  |  |  | [NAME] | 2
Company | JKL | 2 | DEF LLC | 0.35 |  |  | GHI | [NAME] | 3
Company | MNO | 2 | DEF LLC | 0.5 |  |  | JKL |  | 0
Individual | [NAME] | 3 | GHI | 1 |  |  | MNO
Individual | [NAME] | 3 | JKL | 0.2 |  |  | [NAME]
Individual | [NAME] | 3 | JKL | 0.8 |  |  | [NAME]
Individual | [NAME] | 3 | MNO | 0.7 |  |  | [NAME]
Individual | [NAME] | 3 | MNO | 0.3 |  |  | 0
 |  |  |  |  |  |  | 0.7 | MNO
 |  |  | [NAME]*35*100
 |  |  | [NAME]*50*100
 |  |  |  |  |  |  | 0.2 | JKL
[NAME] owns 80% of JKL |  | [NAME] owns 70% of MNO
JKL owns 35% of DEF LLC |  | MNO owns 50% of DEF LLC
DEF LLC owns 100% of my client |  | DEF LLC owns 100% of my client
Spreadsheet: 135426d1326047411-apply-2-formulas-to-same-cell-result-and-quick-button-to-link-data-from-2-workbooks-forum-example-calculations
Sheet: Sheet1

issue #1
ITEM | UNIT | COST PER | QUANITY | AMOUNT (inches) |  | TOTALS
HAMMER | each | 12 | 2
NAILS | box | 2 | 4
BROOM | each | 15 | 3
rope | foot | 1 | 1 | 22
issue #2
ITEM | UNIT | COST PER
HAMMER | each | 12
NAILS | box | 2
BROOM | each | 15
rope | foot | 1
Spreadsheet: 68140d1268687257-duplicate-counting-adjacent-cells-example3
Sheet: Example

 |  | Bank 1 | Bank 2
Blue | 66127 | Yes
Black | 66089
Gold | 66376
Purple | 66177
Pink | 66343
Blue | 66127 | Yes | Yes
Black | 66089
Gold | 66376
Purple | 66177
Pink | 66343
Blue | 66128 |  | Yes
Spreadsheet: 724688d1616321300-excel-formula-to-match-variable-contributions-variable-contributions
Sheet: Sheet1

VARIABLE  DEDUCTIONS
 |  |  | PERIOD
Code | Name | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
CA1 | MARGARET MADEGA | Funeral | 52 | 55 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA2 | OLIVIA CHINAKA | Funeral | 61 | 61 | 63 | 65 | 65 | 68 | 68 | 70 | 75 | 75 | 76 | 80
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA3 | BEAUTY GAVHURE | Funeral | 55 | 56 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA4 | JULIUS RWAFA | Funeral | 59 | 61 | 63 | 65 | 65 | 68 | 68 | 70 | 75 | 75 | 76 | 80
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA5 | ENITA MATAMBO | Funeral | 51 | 53 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
I am kindly asking for excel formula to match column F, G & H using the above data. The desired outcome is in column E29 to E38
Date | Period | Code | Employee Name | Funeral | Medical AID | Trade Union | Others
2021-01-28 00:00:00 | 1 | CA3 | BEAUTY GAVHURE
2021-01-28 00:00:00 | 1 | CA5 | ENITA MATAMBO
2021-01-28 00:00:00 | 1 | CA4 | JULIUS RWAFA
2021-01-28 00:00:00 | 1 | CA1 | MARGARET MADEGA
2021-01-28 00:00:00 | 1 | CA2 | OLIVIA CHINAKA
2021-02-28 00:00:00 | 2 | CA3 | BEAUTY GAVHURE
2021-02-28 00:00:00 | 2 | CA5 | ENITA MATAMBO
2021-02-28 00:00:00 | 2 | CA4 | JULIUS RWAFA
2021-02-28 00:00:00 | 2 | CA1 | MARGARET MADEGA
2021-02-28 00:00:00 | 2 | CA2 | OLIVIA CHINAKA
2021-03-28 00:00:00 | 3 | CA3 | BEAUTY GAVHURE
2021-03-28 00:00:00 | 3 | CA5 | ENITA MATAMBO
2021-03-28 00:00:00 | 3 | CA4 | JULIUS RWAFA
2021-03-28 00:00:00 | 3 | CA1 | MARGARET MADEGA
2021-03-28 00:00:00 | 3 | CA2 | OLIVIA CHINAKA
Spreadsheet: 17472e09-8832-4dad-a720-6c7ef92c1d1e
Sheet: $$ Materials Per FTE

[NAME] vs. [NAME]
Total Library Materials Expenditures Per Enrolled Student FTE
 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | % Change
Peer Average
Peer Median
University of Rhode Island | 224.2 | 335.98 | 257.87 | 185.22 | 199.43291
[NAME] University | 185.49 | 193.85 | 215.83 | 349.17 | 199.76781
Montana State University - Bozeman | 334.4 | 469.1 | 389.42 | 459.47 | 430.64927
North Dakota State University - Main Campus | 184.31 | U/A | 229.53 | U/A | U/A | U/A
University of Maine | 481.37 | 596.06 | 597.22 | 605.65 | 608.1916
University of New Hampshire - Main Campus | 374.87 | 409.92 | 399.76 | 423.89 | 412.87402
University of Vermont and State Ag. Coll. | 548.54 | U/A | 635.4 | 578.68 | 605.73722
University of Wyoming | 338.86 | 644.59 | 779.09 | 413.87 | 728.45746
Source: ACRLMetrics
Revised: May 30, 2012, ajr
Spreadsheet: 130184d1322115561-how-to-use-if-formula-for-change-price-copy-of-december
Sheet: 15

 |  |  |  | 2011-12-15 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 865582d1712647032-to-pull-a-data-from-the-excel-data-2-jt
Sheet: Sheet1

LIC-1168 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00 |  | LIC-1331
LIC-1169 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00 |  | [NAME]
LIC-1170 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00 |  | LIC-1349
LIC-1172 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00 |  | LIC-1350 | FOR INSTANCES
LIC-1352 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00 |  | LIC-1352 | I WANT OUTPUT EXCLUDING THESE DATA FROM TABLE 2
LIC-1354 | 2024-02-20 00:00:00 | 2024-04-30 00:00:00 |  | LIC-1354
 | TABLE1 |  |  | [NAME]
 |  |  | OUT PUT
 |  |  | LIC-1168 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
 |  |  | LIC-1169 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
 |  |  | LIC-1170 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
 |  |  | LIC-1172 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
 |  |  |  | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
 |  |  | LIC-1169 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
 |  |  | LIC-1170 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
 |  |  | LIC-1172 | 2024-01-22 00:00:00 | 2024-04-30 00:00:00
Spreadsheet: 803280d1667370824-find-date-time-difference-from-exported-excel-s666-pq-example-date-time
Sheet: Archer Search Report

Incident ID | Date Created | Date/Time Assigned | Subtraction
INC-1943487 | 10/24/2022 9:13 AM | 10/24/2022 10:09 AM | 00:56:00
INC-1943488 | 10/24/2022 9:13 AM | 10/24/2022 10:26 AM | 01:13:00
INC-1943489 | 10/24/2022 9:13 AM | 10/24/2022 9:51 AM | 00:38:00
INC-1943490 | 10/24/2022 9:13 AM | 10/24/2022 10:02 AM | 00:49:00
Spreadsheet: 89967d1289728581-combination-sum-template-set-match-not-linear-error
Sheet: Sheet1

 | Amounts | Match? |  | Target | 110160 |  |  |  | 0
 | 10870.2 | 0 |  |  |  |  |  |  | 16
 | 11404.8 | 0 |  | Current Match | 110160.0000006151 |  |  |  | 1 |  |  |  |  |  |  |  | 110160
 | 11850.3 | 0 |  | Difference | -6.151385605335236e-07 |  |  |  | 100
 | 12563.1 | 0
 | 43920 | 0
 | 46080 | 0 |  | The author of the template is [NAME].  He can be reached at |  |  |  |  |  | www.tushar-mehta.com
 | 47880 | 0.1804511278323965 |  |  |  |  |  |  |  |  |  | 8640.000000615144
 | 50760 | 1 |  | Warning |  |  |  |  |  |  |  | 50760
 | 43920 | 0 |  | This worksheet is unprotected -- it must be for Solver to work correctly. |  |  |  |  |  |  |  | 0
 | 46080 | 0 |  | Consequently, failure to exactly follow the directions below can lead to data |  |  |  |  |  |  |  | 0
 | 47880 | 0 |  | corruption and incorrect results. |  |  |  |  |  |  |  | 0
 | 50760 | 1 |  | The template is made available as-is.  Use it at your own discretion and risk |  |  |  |  |  |  |  | 50760 | 110160.0000006151
 | 10980 | 0 |  | Solver has certain limitations.  So, it may or may not work for your problem |  |  |  |  |  |  |  | 0
 | 11520 | 0 |  | Check here to indicate your acceptance.  Otherwise the template will not work |  |  |  |  |  |  |  | 0
 | 11970 | 0 |  | 1
 | 12690 | 0 |  | Directions
 |  |  |  | (indicates you have read, understood, and accepted the warning)
 |  |  |  | (2) Paste the amounts (values only, no formulas) to be matched into column B starting with B2
 |  |  |  | (3) Enter the target amount in F1
 |  |  |  | (4) Clear all existing values in column C starting with C2
 |  |  |  | (5) Start Solver (Tools | Solver…)
 |  |  |  | (6) In the Solver Parameters dialog box, click the Options button
 |  |  |  | (7) In the resulting Solver Options dialog box, click [NAME]… button
 |  |  |  | (8) In the Load Model dialog box, specify the range J1:J4
 |  |  |  | (9) If Solver asks about 'Reset previous Solver cell selections' click OK
 |  |  |  | (10) Back in the Solver Options dialog box, click OK
 |  |  |  | (11) Back in the Solver Parameters dialog box, click Solve
 |  |  |  | (12) If any of the values in column C are very close to zero (1E-8 or even smaller),
 |  |  |  | change them to zero, or open the Solver Parameters (Tools | Solver...) dialog
 |  |  |  | box and click the Solve button one more time
Spreadsheet: 220039d1363038663-counting-days-formula-formulas
Sheet: Formula 1 RESULT

Date 1 | 2012-07-27 00:00:00
2012-06-17 00:00:00
2012-06-18 00:00:00
2012-06-19 00:00:00
2012-06-20 00:00:00
2012-06-21 00:00:00 | not applicable
2012-06-22 00:00:00 | not applicable
2012-07-08 00:00:00 | not applicable
2012-07-09 00:00:00 | not applicable
2012-07-10 00:00:00 | not applicable
2012-07-11 00:00:00 | not applicable
Spreadsheet: 287034d1388588518-using-drop-downs-to-act-as-switches-switches
Sheet: Table 1

S | R | Y1 | Y2 | Y3 | Y4 | Y5
A | 1 | 5 | 5 | 5 | 5 | 4
B | 2 | 4 | 4 | 4 | 4 | 3
C | 2 | 3 | 3 | 3 | 3 | 2
A | 4 | 2 | 2 | 2 | 2 | 1
B | 4 | 1 | 1 | 1 | 1 | 1
C | 3 | 1 | 1 | 1 | 1 | 1
Spreadsheet: kate_symes__18099__Deal Correction 12-14
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
 | 2000-12-12 00:00:00 | 2000-12-12 00:00:00 | 2000-12-11 00:00:00 | LTCA | BB | Houston | Natsource | Price: from 165.05 to 164.95 |  | 478198 | NP-15 | Q1-01 | On [NAME] | 25 | 164.95 | Duke Energy
 |  |  |  | BB Count
 | 2000-12-12 00:00:00 | 2000-12-12 00:00:00 | 2000-12-08 00:00:00 | LTNW | MS | Houston | TFS | Term: from Cal-01 to Q3-01 |  | 477087 | Palo Verde | Q3-01 | [NAME] | 25 | 100 | Pinnacle West
 |  |  |  | MS Count
 | 2000-12-14 00:00:00 | 2000-12-14 00:00:00 | 2000-12-14 00:00:00 | LTCA | BB | Houston | Prebon | Price: from 85.00 to 85.05 |  | 480061 | Palo Verde | Q2-01 | On peak | 25 | 85.05 | EES
 |  |  |  | BB Count
 | 2000-12-13 00:00:00 | 2000-12-14 00:00:00 | 2000-12-05 00:00:00 | STWH | HS | Houston | N/A | CTPY: from Pinnacle to APS | Transmission deals still done with APS | 474708 | Mead-230KV | 2000-12-05 00:00:00 | HE10-24 | 25 | 1.25 | APS
 | 2000-12-13 00:00:00 | 2000-12-14 00:00:00 | 2000-12-06 00:00:00 | STWH | HS | Houston | N/A | CTPY: from Pinnacle to APS | Same | 475740 | Mead-230KV | 2000-12-06 00:00:00 | HE 15 | 20 | 1.25 | APS
 |  |  |  | HS Count
 | 2000-12-13 00:00:00 | 2000-12-14 00:00:00 | 2000-12-07 00:00:00 | STWH | RS | Houston | N/A | CTPY: from Transalta Corp. to Transalta US |  | 476642 | Pacificorp | 2000-12-07 00:00:00 | HE 14-18 | 35 | 775 | Transalta
 |  |  |  | RS Count
 |  |  |  | Grand Count