tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 191004d1351873875-merge-multiple-sheets-into-one-sheet-advfilterrep
Sheet: Sheet1

Date | Region | Rep | Item | Units | Cost | Total
2012-01-02 00:00:00 | Ontario | [NAME] | Clipboards | 20 | 4.99 | 99.80000000000001
2012-01-02 00:00:00 | Ontario | [NAME] | Binders | 8 | 19.99 | 159.92
2012-01-02 00:00:00 | Ontario | [NAME] | Pens | 71 | 1.29 | 91.59
2012-01-02 00:00:00 | Ontario | [NAME] | Binders | 77 | 19.99 | 1539.23
2012-01-02 00:00:00 | Quebec | Jones | Clipboards | 47 | 4.99 | 234.53
2012-01-02 00:00:00 | Alberta | Jones | Pens | 40 | 1.99 | 79.6
2012-01-02 00:00:00 | Quebec | Jones | Pen Sets | 5 | 1.29 | 6.45
2012-01-02 00:00:00 | Alberta | Jones | Pen Sets | 30 | 4.99 | 149.7
2012-01-02 00:00:00 | Ontario | Kivell | Pen Sets | 59 | 4.99 | 294.41
2012-01-02 00:00:00 | Quebec | Thompson | Binders | 36 | 8.99 | 323.64
2012-01-02 00:00:00 | Ontario | Smith | Binders | 30 | 15 | 450
2012-01-15 00:00:00 | Quebec | [NAME] | Clipboards | 28 | 4.99 | 139.72
2012-01-15 00:00:00 | Quebec | [NAME] | Pens | 41 | 1.29 | 52.89
2012-01-15 00:00:00 | Quebec | Jones | Binders | 30 | 8.99 | 269.7
2012-01-15 00:00:00 | Quebec | Jones | Clipboards | 10 | 4.99 | 49.90000000000001
2012-01-15 00:00:00 | Alberta | Smith | Pen Sets | 26 | 4.99 | 129.74
2012-01-15 00:00:00 | Ontario | Kivell | Binders | 80 | 19.99 | 1599.2
2012-01-15 00:00:00 | Ontario | Kivell | Pen Sets | 71 | 4.99 | 354.29
2012-01-15 00:00:00 | Ontario | Morgan | Pens | 16 | 1.99 | 31.84
2012-01-15 00:00:00 | Ontario | Morgan | Pen Sets | 65 | 1.99 | 129.35
2012-01-15 00:00:00 | Alberta | Sorvino | Binders | 2 | 19.99 | 39.98
2012-01-15 00:00:00 | Alberta | Sorvino | Pens | 28 | 1.99 | 55.72
2012-01-29 00:00:00 | Ontario | [NAME] | Clipboards | 100 | 4.99 | 499
2012-01-29 00:00:00 | Ontario | [NAME] | Clipboards | 68 | 4.99 | 339.32
2012-01-29 00:00:00 | Ontario | [NAME] | Pen Sets | 91 | 4.99 | 454.09
2012-01-29 00:00:00 | Ontario | [NAME] | Pen Sets | 70 | 4.99 | 349.3
2012-01-29 00:00:00 | Alberta | Smith | Binders | 53 | 8.99 | 476.47
2012-01-29 00:00:00 | Quebec | Thompson | Pen Sets | 99 | 1.29 | 127.71
2012-01-29 00:00:00 | Alberta | Thompson | Binders | 11 | 19.99 | 219.89
2012-01-29 00:00:00 | Alberta | Thompson | Pens | 16 | 1.99 | 31.84
2012-02-20 00:00:00 | Ontario | [NAME] | Pens | 29 | 1.99 | 57.71
2012-02-20 00:00:00 | Ontario | [NAME] | Pens | 30 | 1.99 | 59.7
2012-02-20 00:00:00 | Ontario | [NAME] | Pens | 10 | 1.29 | 12.9
2012-02-20 00:00:00 | Ontario | [NAME] | Binders | 53 | 8.99 | 476.47
2012-02-20 00:00:00 | Ontario | [NAME] | Binders | 58 | 8.99 | 521.42
2012-02-20 00:00:00 | Alberta | Sorvino | Binders | 28 | 19.99 | 559.7199999999999
2012-02-20 00:00:00 | Alberta | Sorvino | Binders | 5 | 19.99 | 99.94999999999999
2012-02-28 00:00:00 | Ontario | [NAME] | Pens | 10 | 1.29 | 12.9
2012-02-28 00:00:00 | Quebec | [NAME] | Clipboards | 95 | 4.99 | 474.05
2012-02-28 00:00:00 | Quebec | [NAME] | Clipboards | 98 | 4.99 | 489.02
2012-02-28 00:00:00 | Ontario | Kivell | Pen Sets | 56 | 4.99 | 279.44
2012-02-28 00:00:00 | Ontario | Kivell | Pen Sets | 56 | 4.99 | 279.44
Spreadsheet: 54005d1253956280-excel-2007-index-match-vlookup-book1
Sheet: Sheet1

 | BF | SS | BDR | QTY | Seat | Back |  |  | Seat | Back | Product
Feather & Down (10%) | 12 | 12 | 2 | 1 |  |  |  |  | 1.5 | 1.1 | Feather & Down (10%)
 |  |  |  |  |  |  |  |  | 2 | 1.6 | Feather & Down (15%)
 |  |  |  |  |  |  |  |  | 2.85 | 2.1 | Feather & Down (20%)
 |  |  |  |  |  |  |  |  | 3.75 | 3.2 | Feather & Down (30%)
 |  |  |  |  |  |  |  |  | 6 | 4.8 | Feather & Down (55%)
 |  |  |  |  |  |  |  |  | 7.5 | 7 | Down & Feather (80%)
 |  |  |  |  |  |  |  |  | 9 | 7.25 | [NAME] (100%)
Spreadsheet: sally_beck__33707__Metrics 0616
Sheet: East

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | East Midstream
Results based on Activity through June 16, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 11
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 1 | 20 | 5 | 1 | 0 | 0 | 5 | 0 | 1 | 0 | 9
- Exits |  | 0 | 1 | 2 | 0 | 2 | 1 | 2 | 3 | 0 | 0 | 3
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 4 | 3.1 |  | 1 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | -0.3 |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 3 | 3 |  |  | 21 | 120.25 |  | 3 | 7 |  |  |  |  | 0 | 0
Identified Margin
Budget |  | 14.2
$ Coverage
$ millions
Spreadsheet: benjamin_rogers__1110__Bidding Summary
Sheet: LV Cogen

Round I Bidding Summary and Round II Bidders
[NAME] (I & II)
Bidder | Bid
Southern Energy | 106
El Paso | 65
Calpine Corp | 40
Allegheny Energy | 35
Pinnacle West | 29
AES Pacific | 28
Dynegy | 19
Intergen | 7
PECO Energy
NRG Energy
AEP
9 bidders
Spreadsheet: 783860d1655210676-nested-if-statements-returning-true-rather-than-a-value-help_forums
Sheet: Cooling Calculation (WIP)

Pipe Diameter (in.) | 1/2" STEEL-STD |  | Pipe Diameter (in.) | 'Cooling Calculation (WIP)'!E9
Inlet Temperature (F°) | 'Cooling Calculation (WIP)'!B11 |  | Outer Diameter (in.) | 'Cooling Calculation (WIP)'!E11
Inlet Pressure (PSIG) | 500 |  | Inside Diameter (in.) | 'Cooling Calculation (WIP)'!E13
Outlet Pressure (PSIG) | 80 |  | Wall Thickness (in.) | 'Cooling Calculation (WIP)'!E15
Q (ft3/hr) | 21000 |  | ṁ (lbm/hr) | 'Cooling Calculation (WIP)'!E17
Length (ft) | 16 |  | Rate of Cooling (btu/hr) | 'Cooling Calculation (WIP)'!E19 | Not sure about this #
 |  |  |  |  | Using Q = M*CP*DT
Effeciency Factor | 0.75 |  |  |  | Assuming DT = 0
ρ (lbm/ft3) | 0.044
Cp (btu/lbm*R) | 0.58
Spreadsheet: 733293d1621494567-split-breakdown-time-between-shifts-przestoje-na-zmiane
Sheet: Breakdown assigned to shift

Sum of Czas przestoju | Column Labels
Row Labels | A | B | C
CW1 | 112.63 | 23.35 | 47.09999999999999
CW2 | 444.6799999999999 | 145.77 | 206.3600000000001
CW3 | 320.5900000000001 | 45.09999999999999 | 112.64
CW4 | 186.93 | 92.04 | 126.04
CW5 | 167.52 | 205.7 | 147.74
CW6 | 211.34 | 102.3 | 366.9799999999998
CW7 | 251.21 | 230.5300000000001 | 127.8200000000001
CW8 | 189.9899999999999 | 207.65 | 94.72000000000001
CW9 | 160.8 | 59.5 | 90.01
CW10 | 153.82 | 267.33 | 72.35999999999999
CW11 | 248.8 | 92.54 | 128.38
CW12 | 199.2200000000001 | 64.05 | 76.82
CW13 | 101.12 | 231.09 | 41.43
CW14 | 126.54 | 75.56000000000002 | 114.31
CW15 | 81.44999999999999 | 37.76 | 147.29
CW16 | 168.05 | 178.4799999999999 | 135.19
CW17 | 138.62 | 50.26999999999999 | 51.35
CW18 | 74.3 | 221.06 | 138.59
CW19 | 45.22 | 52 | 98.63999999999999
CW20 | 16.32 | 18.93 | 11
Spreadsheet: 5a9ffc6c-3668-465e-9cc0-9a40ec7c639e
Sheet: Reported Claims

Auto Collision Insurer
Exhibit I (Sheet 5) p.219
Reported Claims
PART 1 - Data Triangle
AY | 6
2003-2 | 14235000 | 14960000 | 14921000 | 14911000 | 14926000 | 14864000 | 14860000 | 14854000 | 14850000 | 14847000
2004-1 | 14548000 | 14674000 | 14643000 | 14626000 | 14621000 | 14610000 | 14610000 | 14611000 | 14617000
2004-2 | 12129000 | 12576000 | 12541000 | 12531000 | 12523000 | 12523000 | 12510000 | 12502000
2005-1 | 11980000 | 11921000 | 11882000 | 11862000 | 11854000 | 11844000 | 11841000
2005-2 | 11283000 | 11843000 | 11805000 | 11789000 | 11772000 | 11770000
2006-1 | 11947000 | 11856000 | 11820000 | 11772000 | 11760000
2006-2 | 12503000 | 12762000 | 12706000 | 12697000
2007-1 | 11662000 | 11523000 | 11492000
2007-2 | 12647000 | 12854000
2008-1 | 14071000
AY | 6-12 | 12-18 | 18-24 | 24-30 | 30-36 | 36-42 | 42-48 | 48-54 | 54-60 | 60-Ult
2003-2
2004-1
2004-2
2005-1
2005-2
2006-1
2006-2
2007-1
2007-2
Simple
L5
L3
L2
Medial
L5x1
Vol Wtd
L5
L3
Geo
[NAME]
Prior
Sel |  |  |  |  |  |  |  |  |  | 1
CDF to Ult
% Paid
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-18

Tuesday
Deal #s | 777344 |  | 777349 | 777356 | 777363 | 777370
2001-09-18 00:00:00 |  |  | NP | SP | SP | 4 Corners
Delivery Pt. | EPMI CA Pool |  | Sale | Sale | Buy | STSW
Counterparty | NP | SP | EES | EES | EES | EPMI_CISO_7000
Totals | -936 | 936 | -7408 | -1080 | 4400 | 432
1 | -163 | 163 | -352 | -135 | 0 | 0
2 | -163 | 163 | -352 | -135 | 0 | 0
3 | -163 | 163 | -352 | -135 | 0 | 0
4 | -163 | 163 | -352 | -135 | 0 | 0
5 | -163 | 163 | -352 | -135 | 0 | 0
6 | -163 | 163 | -352 | -135 | 0 | 0
7 | 23 | -23 | -287 | 0 | 275 | 27
8 | 23 | -23 | -287 | 0 | 275 | 27
9 | 23 | -23 | -287 | 0 | 275 | 27
10 | 23 | -23 | -287 | 0 | 275 | 27
11 | 23 | -23 | -287 | 0 | 275 | 27
12 | 23 | -23 | -287 | 0 | 275 | 27
13 | 23 | -23 | -287 | 0 | 275 | 27
14 | 23 | -23 | -287 | 0 | 275 | 27
15 | 23 | -23 | -287 | 0 | 275 | 27
16 | 23 | -23 | -287 | 0 | 275 | 27
17 | 23 | -23 | -287 | 0 | 275 | 27
18 | 23 | -23 | -287 | 0 | 275 | 27
19 | 23 | -23 | -287 | 0 | 275 | 27
20 | 23 | -23 | -287 | 0 | 275 | 27
21 | 23 | -23 | -287 | 0 | 275 | 27
22 | 23 | -23 | -287 | 0 | 275 | 27
23 | -163 | 163 | -352 | -135 | 0 | 0
24 | -163 | 163 | -352 | -135 | 0 | 0
TIE POINTS
Spreadsheet: 834672d1687978541-vlookup-formula-lookup-r1p1-etaf
Sheet: Sheet1

r1 | p1 | Pname |  |  |  |  | R1 | P1 | Pname
171 | 18 |  |  |  |  |  | 156 | 10 | Arial
 |  |  |  |  |  |  | 1551 | 12 | Violin
 |  |  |  |  |  |  | 171 | 18 | Brigade
 |  |  |  |  |  |  | 171 | 10 | Will
 |  |  |  |  |  |  | 1711 | 11 | Van
Spreadsheet: 2e3d13cc-f2b1-4038-a0d3-891599a8bd51
Sheet: SD_LRPRELIMDTL

Load Response Preliminary Settlement Detail Report
SD_LRPRELIMDTL_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  | Asset Information |  |  | Location Information |  | Day Ahead |  | Real Time |  |  |  | Demand Resource Baseline Information
Trading Date | Trading Interval | Asset ID | Asset Name | Program Name | Location ID | Location Name | Day Ahead Cleared MW | Day Ahead Locational Marginal Price | Real Time Interruption Event (Y/N) | Real Time Amount Interrupted | LR Deviation | Real Time Locational Marginal Price | Preadjusted Baseline MW | Baseline MW | Actual MW | Maximum 5 Minute Interruption
Date | Hour End | Number | String | String | Number | String | MWh | $/MWh | Flag | MWh | MWh | $/MWh | MWh | MWh | MWh | MWh
Spreadsheet: 875309d1721905213-dynamic-pmt-formula-book2
Sheet: Sheet1

 |  |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
 |  |  | Investment | 16206272.10378467 | 19196982.20504332 | 15495606.64659536 | 8442253.578736648 | 8084500 | 12500000 | 15000000 | 13750000 | 14500000 | 15000000 | 14500000 | 14250000 | 13750000 | 15000000 | 15500000 | 15500000 | 14500000 | 12500000 | 13750000 | 15000000 | 16250000
10 | 0.046 | 0.4 | Component | [NAME] empty
 |  |  |  |  |  |  |  |  | =IFERROR(IF(J$1<2029;J$12;IF(J$1>2028;IF(COUNTIFS($E$1:J$1;">"&2028)>10;PMT($B13/12;$A$13*12;-J$12*$C13;0)*12;PMT($B13/12;$A$13*12;-J$12;J$12*$C13)*12);IF(J$1>2028;IF(COUNTIFS($E$1:J$1;">"&2028)>10;PMT($B13/12;$A$13*12;-J$12*$C13;0)*12;PMT($B13/12;$A$13*12;-J$12;J$12*$C13)*12);IF(J$1>2028;I13;J$12))));"")
 |  |  |  |  |  |  |  | Valem, mis ka töötab: | =IFERROR(IF(J$1<($J$1+ROWS($J$4:$J4)-1)+$A$4;PMT($B$4/12;$A$4*12;-INDEX($J$3:[NAME]:[NAME]:[NAME]:J$1;0))*$C$4)*12;PMT($B$4/12;$A$4*12;-INDEX($J$3:[NAME]:[NAME]);"")
 |  |  |  |  |  |  |  | Sama valem [NAME] | =IFERROR(IF(J$1<($J$1+ROWS($J$4:$J4)-1)+$A$4;PMT($B$4/12; $A$4*12;-XLOOKUP($J$1+ROWS($J$4:$J4)-1;$J$1:J$1;$J$3:J$3);XLOOKUP($J$1+ROWS($J$4:$J4)-1;$J$1:J$1;$J$3:J$3)*$C$4)*12;PMT($B$4 / 12;$A$4*12;-XLOOKUP($J$1+ROWS($J$4:$J4)-1;$J$1:J$1;$J$3:J$3)*$C$4;0)*12);"")
Spreadsheet: 673813d1587552129-find-minimum-value-and-corresponding-value-from-multiple-tables-index-match-maybe-excel-table-lookup-problem-2-2-
Sheet: Sheet1

 |  |  | smallest value: |  |  |  | Cell ref. | column | row |  |  | Return Corresponding Value of Heading D for the Minimum Value of Heading B
Table 1
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | The above example searches for the minimum value of Heading B from Table 1. It then returns the value from Heading D from the same Column as the minimum value.
Heading B | 47 | 52 | 63 | 12 | 48 | 59 | 62 | 62 | 67 | 54
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 2 |  |  |  |  |  |  |  |  |  |  |  | Step 1
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Search the row's highlighted with red border for the minimum value
Heading B | 46 | 51 | 62 | 50 | 47 | 58 | 61 | 63 | 66 | 53
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Step 2
 |  |  |  |  |  |  |  |  |  |  |  | Use the minimum value from all tables to select the column in that table.
Table 3
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 45 | 50 | 61 | 49 | 46 | 57 | 60 | 62 | 65 | 52
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Step 3
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847 |  | Return the data from a cell that intersects with that column when i specify a row
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 4
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 52 | 57 | 68 | 56 | 53 | 64 | 67 | 69 | 72 | 59
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 5
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 50 | 55 | 66 | 54 | 51 | 62 | 65 | 67 | 70 | 57
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15496 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Table 6
Heading A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Heading B | 47 | 52 | 63 | 51 | 48 | 59 | 38 | 64 | 67 | 54
Heading C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heading D | 72513 | 32165 | 32517 | 15448 | 15665 | 74654 | 15750 | 18545 | 34564 | 56847
Heading E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 69062d1269561713-pull-out-duplicate-values-email-lists_john
Sheet: Sheet1

key | List 1 | List 2 |  |  | Key | List 3
1 | [EMAIL] | [EMAIL] |  |  | 15 | [EMAIL]
2 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
3 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
4 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
5 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
5 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
5 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
5 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
5 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
5 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
6 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
7 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
8 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
9 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
10 | [EMAIL] | [EMAIL] |  |  |  | [EMAIL]
11 | [EMAIL]
12 | [EMAIL]
13 | [EMAIL]
14 | [EMAIL]
15 | [EMAIL]
15 | [EMAIL]
15 | [EMAIL]
15 | [EMAIL]
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: DU60 KZT

 |  |  |  |  | DU60 KZT
Registration number : | DU60 KZT |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2010-10-01 00:00:00 | 12 Months | 2011-10-01 00:00:00 | 1200
Specification : | 6 x 2 A (3 Axle) |  | 2011-09-30 00:00:00 | 12 Months | 2012-10-01 00:00:00 | 1200
Type : | FTG XF105.460
1st Registered : | 01.10.10
Engine : | MX340 12.9 LITRE
[NAME] : | 44,000kg
Back To Index
Spreadsheet: 80726d1280934954-finding-lowest-cost-from-supplier-list-lowest-price-excluding-shenzhen
Sheet: Raw data

Part Code | Supplier | Supplier Location | $FOB
AAA1 | ALP | Xiamen | 5.5
AAA1 | DSB | Xiamen | 5.3
AAA1 | STA | Shenzhen | 5.4
AAA1 | AOS | Shanghai | 4.1
BBB1 | ALP | Xiamen | 9.8
BBB1 | DSB | Xiamen | 10.5
BBB1 | AOS | Shanghai | 10.2
BBB1 | STA | Shenzhen | 7.5
CCC1 | ALP | Xiamen | 4.5
CCC1 | DSB | Xiamen | 6.4
CCC1 | AOS | Shanghai | 3.55
CCC1 | STA | Shenzhen | 5.33
CCC1 | LUC | Guangdong | 3.44
Spreadsheet: 808981d1670831569-finding-average-for-last-5-10-games-closing-line-76ers
Sheet: Sheet1 (2)

Team = 76ers
Looking for formula to see when the 76ers are favorite or Underdog in the last 5 and 10 games, what the average closing line is
Favourite or Underdog | Closing Line
d | 2.5
d | 5
f | -13.5
f | -12.5
d | 1
d | 2.5
f | -2.5
f | -2.5
f | -5.5
f | -1
d | 1.5
d | 1
f | -2.5
f | -3.5
d | 1
d | 3.5
d | 7.5
d | 4
d | 1.5
f | -1
f | -2.5
d | 4
d | 4.5
f | -7.5
f | -5
 |  |  | average | fav or underd | last n games |  | average
Average Line Last 5 games 76ers were Favorites |  | <<<looking for formula |  | f | 5
Average Line Last 5 games 76ers were Underdogs |  | <<<looking for formula |  | d | 5
Average Line Last 5 games 76ers were Favorites |  | <<<looking for formula |  | f | 10
Average Line Last 5 games 76ers were Underdogs |  | <<<looking for formula |  | d | 10
Spreadsheet: 49960d1249387002-regarding-pivot-table-sorting-problem-pivot-sort
Sheet: Pivot table

 |  | Data
[NAME] | Name | Sum of count | Sum of Person
variance1 | Agarwal var1 | 28 | 4
 | [NAME] var1 | 73 | 4
 | Bunt var1 | 12 | 6
 | [NAME] | 12 | 6
 | Havyaka var1 | 22 | 4
 | Kayastha var1 | 58 | 7
 | Leva patil var1 | 36 | 7
 | Madhwa var1 | 28 | 5
 | Namboodiri var1 | 36 | 4
 | Rajput var1 | 140 | 6
variance1 Total |  | 445 | 53
variance2 | Agarwal var1s | 36 | 7
 | [NAME] var1s | 140 | 5
 | Caste no bar var1s | 12 | 5
 | Garhwali var1s | 58 | 4
 | Havyaka var1s | 22 | 4
 | [NAME] | 110 | 4
 | Kayastha var1s | 58 | 4
 | Kshatriya var1s | 36 | 4
 | Leva patil var1s | 36 | 6
 | Madhwa var1s | 91 | 8
 | Rajput var1s | 58 | 6
 | Roman Catholic var1s | 12 | 4
 | Saraswat var1s | 22 | 6
variance2 Total |  | 691 | 67
Grand Total |  | 1136 | 120
Spreadsheet: 721839d1614886068-lookup-function-to-look-at-every-other-column-excel-help
Sheet: Sheet1

 |  |  | 2020 |  | Jan, 2021 |  | Feb, 2021 |  | Mar, 2021 |  | Apr, 2021 |  | May, 2021 |  | Jun, 2021 |  | Jul, 2021 |  | Aug, 2021 |  | Sep, 2021 |  | Oct, 2021 |  | Nov, 2021 |  | Dec, 2021
Name | Metric | Task Details | Plan | Actual | Plan2 | Actual2 | Plan3 | Actual3 | Plan4 | Actual4 | Plan5 | Actual5 | Plan6 | Actual6 | Plan7 | Actual7 | Plan8 | Actual8 | Plan9 | Actual9 | Plan10 | Actual10 | Plan11 | Actual11 | Plan12 | Actual12 | [NAME] | Actual13 | Current Plan | To Date Actual | Comments
Name | Metric | Task Details | 5 | 10 | 10 | 15 | 15 | 20 | 25 | 25 | 35 | 38 | 50 | 51 | 55 | 57 | 65 | 62 | 65 | 65 | 75 | 78 | 80 | 81 | 90 | 95 | 100 |  |  |  | Comment
Spreadsheet: 732764d1621229450-how-do-i-return-a-formula-using-vlookup-rather-than-a-value-named-formula-test-bvj-
Sheet: Sheet1

Manually Entered |  |  |  |  |  |  |  |  |  | Table
 |  | Beginning |  | 300 |  |  |  |  |  |  |  | 2021-05-20 00:00:00
F |  |  | 100 |  |  |  |  |  |  |  | A |  | Building Rent | -150
E |  |  | -20 |  |  |  |  |  |  |  | B |  | Building Utilities | -75
G |  |  | -50 |  |  |  |  |  |  |  | C |  | Vehicle Maintenance | -100
F |  |  | 200 |  |  |  |  |  |  |  | D |  | Alarm System | -80
A |  |  | -150 |  |  |  |  |  |  |  | E |  | Bank Payment | -20
B |  |  | -75 |  |  |  |  |  |  |  | F |  | Incoming Payments | 200
F |  |  | 300 |  |  |  |  |  |  |  | G |  | Fuel | -50
C |  |  | -100
D |  |  | -80
VLOOKUP
 |  | Beginning |  | 300
F
E
G
F
A
B
F
C
D
Spreadsheet: 708562d1607930387-array-index-problems-need-assistance-or-any-advice-to-help-to-create-formula-to-enable-to-book1
Sheet: AFTER Sheet

Family ID | No of Children | Student ID
2022 | 2 | 1000
2022 | 2 | 1001
2023 | 2 | 1002
2023 | 2 | 1003
2841 | 2 | 1004
2841 | 2 | 1005
2405 | 3 | 1006
2026 | 2 | 1007
2378 | 3 | 1008
2377 | 1 | 1009
2378 | 3 | 1010
2028 | 3 | 1011
2691 | 2 | 1012
2331 | 1 | 1013
Spreadsheet: 783974d1655318510-conditional-formatting-for-dates-and-other-column-data-cond-format
Sheet: Sheet1

 |  |  | [NAME] Here | Conditional format to be applied here |  | Requirement (Sample)
JOB | Balance | Required dt. (RD) |  | Expected completion dt. (ED) |  | After formula is applied | Expected completion dt.
HY-05856 | 5 | 2022-05-10 00:00:00 |  | 2022-06-15 00:00:00 |  | Out | 2022-06-15 00:00:00 | If ED is greater than RD, [NAME]: Red Font
HY-05861 | 2 |  |  |  |  |  |  | If ED and RD is blank, no format to be applied
HY-05959 | 12 | 2022-06-23 00:00:00 |  | 2022-06-22 00:00:00 |  | Next week | 2022-06-22 00:00:00 | If [NAME] is less than RD and RD is in next week (Monday-Sunday), format: Fill Green
HY-05950 | 1 | 2022-06-20 00:00:00 |  | 2022-06-16 00:00:00 |  | Week | 2022-06-16 00:00:00 | If [NAME] is less than RD and RD is in this week (Monday-Sunday) and difference is more than 2 days, format: Fill Orange
[NAME] | 10 | 2022-06-20 00:00:00 |  | 2022-06-18 00:00:00 |  | Immediate | 2022-06-18 00:00:00 | If ED is 0-2 days less than RD, it is critical and format Fill Red.
HY-06250 |  |  |  |  |  |  |  | If Balance is blank, then no matter whatever the dates are, no format to be applied
HY-06202 | 4 | 2022-06-22 00:00:00 |  |  |  |  |  | If ED is blank, no format to be applied
HY-06207 | 15 |  |  | 2022-06-20 00:00:00 |  |  | 2022-06-20 00:00:00 | If RD is blank, no format to be applied
Spreadsheet: 203701d1357227366-link-data-in-worksheets-add-deduct-formulas-as-criteria-are-arent-met-attendance-template-excel
Sheet: Employees

Position | Employee Name
LVN/FT | ADKINS PAM
RN/FT | ALINCASTRE RAFAEL
LVN/PRN | ALLISON GWEN
RN/FT | AMASON CHARLOTTE
LVN/FT | AMMEAN MAURIBETH
CNA/FT | ARMSTRONG KATHERINE
RN/FT | [NAME]
RN/PRN | ARSEMENT NATASHA
CNA/PRN | BATISTE PRINCELLA
RN/FT | BELANGER MICHEAL
WC/PRN | BERGERON LAVERNE
 | [NAME]
WC/FT | BLACK TERRIE
EMT/PRN | BOLENBAUCHER [NAME]
RN/PRN | BROOKS MARISSA
RN/PRN | BROWN SHAUN
CNA/FT | BYRD SHEKEITHA
RN/FT | CAYETANO [NAME]
 | CHESSON SHANA
PARAMEDIC/PRN | CLOYD DIANNA
CNA/FT | COOPER [NAME]
RN/FT | CRAIGEN TRACIE
RN/PRN | DANIELS REBECCA
EMT-P/FT | DUFFEE TRINA
LVN/FT | DUFFY CHRYSTAL
 | DUMESNIL BROOKE
RN/FT | DURISSEAU GWEN
LVN/PRN | FLOWERS MISSY
RN/FT | FOREMAN CHANDA
RN/PRN | FOREMAN VYANN
CNA/FT | GARLOW LAKESHA
LVN/FT | GILBERT [NAME]
 | GILLENTINE JAMIE
RN/PRN | GUILLORY TIFFANY
RN/PRN | HEFLEY MICHELLE
RN/PRN | HELVESTON DEWONA
RN/PRN | HILLIARD SHANOAH
CNA/FT | [NAME]
RN/PRN | JUDGE TRAMEKA
RN/FT | KELLER MATTIE
RN/PRN | [NAME]
CNA/PRN | LANDRY COLBY
LVN/FT | LANDRY KENNETH
WOUNDCARE/FT | LEGER BRANDI
RN/FT | [NAME]
RN/FT | [NAME]
DIETICIAN | MAXWELL GWEN
LVN/FT | MITCHELL EBONY
RN/FT | MURDOCK AMY
LVN/FT | MYERS KATIE
 | ONEALL KRISTIN
RN/PRN | PEVETO [NAME]
RN/PRN | POSEY MARY
RN/PRN | RACY JENNIFER
CNA/PRN | [NAME]
 | [NAME]
LVN/FT | ROBINSON CHRISTOPHER
RN/PRN | ROSAS AARAN
RN/PRN | ROY QUERISTAN
RN/PRN | SANGIL GIGI
LVN/FT | SIMON JESSICA
RN/PRN | SMITH BETHANY
RN/PRN | SMITH ERIC
RN/PRN | STACRUZ EVANGELINE
WC/PRN | STANLEY CINDY
EMT-P/FT | STANLEY STACEY
 | TOUPS MELISSA
CNA/FT | [NAME]
CNA/FT | VALLAIR SHARONDA
EMT/FT | VASSAR ROBBIE
LVN/FT | WATKINS CHRISTINA
RN/FT | [NAME]
RN/PRN | WOODS (PEVETO) HAILEY
RN/PRN | YAP CHRISTINE
 | ZOCH BEVERLY