tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d64f6ec8-68cc-41e1-821a-eb20b6ef08b9
Sheet: Software

Software Pricing
BIS | 0.1
EMC | Lowest Price [NAME] or better
Kofax | Lowest Price [NAME] or better
Rightfax | 0.11
[NAME] | 0.07
Formatta/Formsoft | 0.1
IBML | 0.05
Rimage | 0.1
[NAME] | 0.25
See example of GSA Pricing on some EMC products PDF attachment.  Other product discounts on EMC products may be less.
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: M3

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/24/2001 07:33 am | 5000 | 4.5025
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/24/2001 09:04 am | 5000 | 4.5025
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/24/2001 11:14 am | 5000 | 4.4925
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/25/2001 12:30 pm | 213 | 4.33
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/29/2001 01:27 pm | 1000 | 4.155
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/29/2001 02:51 pm | 5000 | 4.105
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/29/2001 03:22 pm | 5000 | 4.105
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/29/2001 03:24 pm | 5000 | 4.105
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/29/2001 03:43 pm | 5000 | 4.11
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/29/2001 03:43 pm | 5000 | 4.1125
US Gas Phy       TETCO M3                Jun01           USD/MM | 05/29/2001 11:03 am | 5000 | 4.24
 | TOTAL VOLUME
Weighted Average Price
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Fredericton

Fredericton To: | [NAME]
Amherst, NS | 149
Atholville, NB | 236
Bathurst, NB | 164
Centreville, NB | 86
Chatham, NB | 119
Dartmouth, NS | 267
Doaktown, NB | 66
Edmundston, NB | 168
Florenceville, NB | 86
[NAME], NB | 129
Hartland, NB | 77
Harvey, NB | 29
Kedgwick, NB | 190
Kentville, NS | 322
Longs Creek, NB | 18
Mcadam, NB | 49
Minto, NB | 36
[NAME], NB | 107
Nackawic, NB | 39
New Glasgow, NS | 249
[NAME], NB | 17
[NAME], NB | 72
Scoudouc, NB | 123
[NAME], NB | 82
[NAME], NB | 90
[NAME], NB | 142
[NAME], NB | 179
[NAME], NB | 179
[NAME], NB | 76
Sussex, NB | 78
Truro, NS | 217
[NAME], PE | 213
Woodstock, NB | 63
Spreadsheet: 857017d1706116497-vlookup-and-indirect-maybe-cant-har_test_chopped_down
Sheet: PICK_IT

 | What Hull |  |  | What HAR |  |  |  | HAR Data
 | CVN-78 |  |  | [NAME]
 |  |  |  |  |  | HAZARD STATUS
 | Tired and frustrated at my inability when I thought I had an understanding of these two functions (VLOOKUP & INDIRECT)  Maybe tring to overlap two funtions that cannot be?  What works, Whatever is selected in E7 is what the VLOOKUP used to fill in the fields in Column G and display the risk values to the right (setup up with conditional formatting)  The "Go" button works to go to an "Other data" tab and a "go Back" button returns you to the "Pick It" tab.  The funtiallity I'm trying to add is using field B7 as a pick list, to place only the HARs for that hull, avalible in the field in E7.  (cascading) I do undersatnd that "INDIRECT" is the funtion I most like want to use, and am sucsessfully using on the database tab in Columnus M thru P.   I have a vbasic grasp on how to use VLOOKUP and INDIRECT, but maybe i'm trying to combine somethings that can't ?
 |  |  |  |  |  | SYSTEM
 |  |  |  |  |  |  |  | Risk Matrix (7 X) | Initial Risk | Current Risk | Target Risk
 |  |  |  |  |  | Sub-System
 |  |  |  |  |  | Casual Factor
 |  |  |  |  |  | Mishap
 |  |  |  |  |  | Effects
 |  |  |  | Legacy Hars
 |  |  |  |  |  | Event
 |  |  |  |  |  | Phase
Spreadsheet: 470736d1468610264-fill-dates-and-days-calls
Sheet: Sheet1

2 | Monday
3 | Tuesday
4 | Wednesday
5 | Thursday
6 | Friday
7 | Saturday
1 | Sunday
2016-01-01 00:00:00 |  | Alarm
2016-01-01 00:00:00 |  | Abandoned
2016-01-01 00:00:00 |  | 911
2016-01-01 00:00:00 |  | N.E.
2016-01-01 00:00:00 |  | Outgoing
Spreadsheet: 770277d1645975134-trim-text-some-from-sentence-score-card-by-trim
Sheet: Sheet1

In round 1 Wellington Jighere, (replying) played Ebomah Peter and lost 383 - 446, a difference of -63. Wellington Jighere is ranked 11th with 0 points and a cumulative spread of -63
In round [NAME], (starting) played [NAME] and won 510 - 335, a difference of 175. Wellington Jighere is ranked 3rd with 1 points and a cumulative spread of 112
In round 3 Wellington Jighere, (replying) played [NAME] and won 497 - 356, a difference of 141. Wellington Jighere is ranked 2nd with 2 points and a cumulative spread of 253
In round 4 Wellington Jighere, (starting) played Idahosa Bright and won 519 - 379, a difference of 140. Wellington Jighere is ranked 1st with 3 points and a cumulative spread of 393
In round 5 Wellington Jighere, (replying) played Olaribigbe Hakeem and won 496 - 389, a difference of 107. Wellington Jighere is ranked 1st with 4 points and a cumulative spread of 500
In round 6 Wellington Jighere, (starting) played Ogbonyomi Friday and won 502 - 323, a difference of 179. Wellington Jighere is ranked 1st with 5 points and a cumulative spread of 679
In round 7 Wellington Jighere, (replying) played [NAME] and lost 447 - 478, a difference of -31. Wellington Jighere is ranked 1st with 5 points and a cumulative spread of 648
In round 8 Wellington Jighere, (starting) played [NAME] and won 447 - 411, a difference of 36. Wellington Jighere is ranked 1st with 6 points and a cumulative spread of 684
In round 9 Wellington Jighere, (starting) played [NAME] and lost 373 - 457, a difference of -84. Wellington Jighere is ranked 1st with 6 points and a cumulative spread of 600
In round 10 Wellington Jighere, (replying) played Eta Karo and lost 404 - 405, a difference of -1. Wellington Jighere is ranked 4th with 6 points and a cumulative spread of 599
In round 11 Wellington Jighere, (starting) played [NAME] and won 447 - 374, a difference of 73. Wellington Jighere is ranked 2nd with 7 points and a cumulative spread of 672
In round 12 Wellington Jighere, (replying) played [NAME] and lost 370 - 433, a difference of -63. Wellington Jighere is ranked 5th with 7 points and a cumulative spread of 609
In round 13 Wellington Jighere, (starting) played Olaribigbe Hakeem and won 581 - 319, a difference of 262. Wellington Jighere is ranked 4th with 8 points and a cumulative spread of 871
In round 14 Wellington Jighere, (replying) played [NAME] and won 512 - 347, a difference of 165. Wellington Jighere is ranked 2nd with 9 points and a cumulative spread of 1036
 | Ebomah | 383 | 446
 | Ehibudu | 510 | 335
Spreadsheet: 750696d1633598069-poining-to-empty-rows-with-formula-and-copying-formula-with-increments-november-2021
Sheet: Sheet1

 | Level (m)
 | Tank 1 | Tank 2 | Tank 3
2021-11-01 00:00:00
2021-11-02 00:00:00
2021-11-03 00:00:00
2021-11-04 00:00:00
2021-11-05 00:00:00
2021-11-06 00:00:00
2021-11-07 00:00:00
2021-11-08 00:00:00
2021-11-09 00:00:00
2021-11-10 00:00:00
2021-11-11 00:00:00
2021-11-12 00:00:00
2021-11-13 00:00:00
2021-11-14 00:00:00
2021-11-15 00:00:00
2021-11-16 00:00:00
2021-11-17 00:00:00
2021-11-18 00:00:00
2021-11-19 00:00:00
2021-11-20 00:00:00
2021-11-21 00:00:00
2021-11-22 00:00:00
2021-11-23 00:00:00
2021-11-24 00:00:00
2021-11-25 00:00:00
2021-11-26 00:00:00
2021-11-27 00:00:00
2021-11-28 00:00:00
2021-11-29 00:00:00
2021-11-30 00:00:00
Spreadsheet: 195621d1353584491-cannot-get-indirect-function-to-work-with-sumifs-ef272_inv-summary-test
Sheet: Summary

 |  |  |  |  |  |  |  | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
Sheet 1 | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total |  | Sheet 1 |  |  |  |  |  |  |  |  |  |  | Copy this row of formulae down when you have the other sheets in place
2004 |  |  |  |  |  |  | Sheet 2
2005 |  |  |  |  |  |  | Sheet 3
2006 |  |  |  |  |  |  | Sheet 4
2007 |  |  |  |  |  |  | Sheet 5
2008 |  |  |  |  |  |  | Sheet 6
2009 |  |  |  |  |  |  | Sheet 7
2010 |  |  |  |  |  |  | Sheet 8
2011 |  |  |  |  |  |  | Sheet 9
2012
Sheet 2 | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total
2004 |  |  |  |  |  |  | Copy highlighted block to form a new sub-table below
2005 |  |  |  |  |  |  | Formulae picks up sheetname from top corner of sub-table
2006 |  |  |  |  |  |  | and year from column A
2007
2008
2009
2010
2011
2012
Sheet 3 | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total
2004
2005
2006
2007
2008
2009
2010
2011
2012
Spreadsheet: 708361d1607759807-how-can-i-add-alternate-cells-in-a-row-if-the-adjacent-column-meets-a-certain-criteria-testbook
Sheet: Sheet1

Wallet Balance
Date | Wallet | Grocery | Mode of Payment | Meds/Opd | Mode of Payment | Dine out | Mode pf Payment | Misc | Mode pf Payment | Total Cash Expenditure | Grand Total
2020-12-01 00:00:00 | 10000 | 200 | Card | 500 | Cash | 1000 | Card | 100 | Cash
2020-12-02 00:00:00 |  | 500 | Cash | 400 | PhonePe | 200 | Cash | 500 | PhonePe
2020-12-03 00:00:00
2020-12-04 00:00:00
2020-12-05 00:00:00
2020-12-06 00:00:00
2020-12-07 00:00:00
2020-12-08 00:00:00
2020-12-09 00:00:00
2020-12-10 00:00:00
2020-12-11 00:00:00
2020-12-12 00:00:00
2020-12-13 00:00:00
2020-12-14 00:00:00
2020-12-15 00:00:00
2020-12-16 00:00:00
2020-12-17 00:00:00
2020-12-18 00:00:00
2020-12-19 00:00:00
2020-12-20 00:00:00
2020-12-21 00:00:00
2020-12-22 00:00:00
2020-12-23 00:00:00
2020-12-24 00:00:00
2020-12-25 00:00:00
2020-12-26 00:00:00
2020-12-27 00:00:00
2020-12-28 00:00:00
2020-12-29 00:00:00
2020-12-30 00:00:00
Spreadsheet: john_griffith__15635__05_08_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 430 | 38 | 42
N01-P/C | 435 | 64 | 68
Q01-P/C | 445 | 84 | 88
U01-P/C | 445 | 102 | 105
V01-P/C | 450 | 117 | 121
X01-P/C | 470 | 134 | 138
[NAME]-P/C | 490 | 154 | 158
F02-P/C | 495 | 170 | 175
G02-P/C | 480 | 174 | 180
H02-P/C | 460 | 155 | 161
J02-P/C | 435 | 117 | 124
K02-P/C | 425 | 108 | 118
Spreadsheet: 217358d1362052631-help-with-excel-sheet-to-get-output-sales-3-feb-9-feb-2013
Sheet: Sheet3

color | style no | qty | 100
Blue | DP214 | 1
Orange | GP124 | 1
Multicolour | [NAME] | 1
Red | DP244 | 1
Black/Multi | [NAME] | 1
Black/Multi | [NAME] | 1
Multicolour | [NAME] | 1
Purple/Multi | DP180 | 1
[NAME] | DP116 | 1
[NAME] | DP116 | 1
Black | KP148 | 1
Ivory | TP187 | 1
Black | JP070 | 1
Red | DP326 | 1
Ivory | TP061 | 1
Cream/Multi | HP040 | 1
Pewter | DP158 | 1
Black | PP100 | 1
Pewter | SP094 | 1
Teal | TP082 | 1
Blue/Multi | KP179 | 1
Black | KP178 | 1
Black/Multi | TP166 | 1
Black | JP009 | 1
Ivory | TP093 | 1
Black | TP204 | 1
Teal | TP082 | 1
Brown/Multi | PP004 | 1
Purple/Multi | [NAME] | 1
Cream/Multi | KP207 | 1
Yellow | SP036 | 1
Teal | DP152 | 1
Black | PP079 | 1
Black | JP070 | 1
Blue | DP333 | 1
Pink/Multi | DP159 | 1
Black & White | TP064 | 1
Black | [NAME] | 1
Purple | DP229 | 1
Khaki | JP025 | 1
[NAME] | GP032 | 1
[NAME] | GP031 | 1
Black & White | KP179 | 1
Black | DP177 | 1
Ivory | TP093 | 1
Black | [NAME] | 1
Pewter | DP158 | 1
Black | FP038 | 1
Black & White | [NAME] | 1
Black | JP050 | 1
Black | DP168 | 1
Black & White | SP029 | 1
Black | DP308 | 1
Red/Multi | DP123 | 1
Cream/Multi | DP083 | 1
Stone | KP238 | 1
Black | PP057 | 1
Neutral | CP036 | 1
Black | PP084 | 1
Teal | KP101 | 1
[NAME] | KP232 | 1
Taupe | CP039 | 1
Pale Blue | TP005 | 1
Orange | WP001 | 1
Taupe | CP039 | 1
Red/Multi | DP123 | 0
Red/Multi | DP123 | 0
Pewter | SP094 | 1
Pewter | HP041 | 1
Pale Blue | PP088 | 1
Silver | FP168 | 1
Black/Multi | FP185 | 1
Black | FP107 | 1
Purple/Multi | DP180 | 1
Blue | [NAME] | 1
Champagne | DP228 | 1
Red/Multi | DP058 | 1
Khaki | CP035 | 1
Ivory | TP093 | 1
Pale Blue | PP088 | 1
Orange | GP214 | 1
Orange | CP032 | 1
Black & White | [NAME] | 1
Black & White | DP213 | 1
Cream/Multi | HP040 | 1
Black | KP161 | 1
Black & White | SP061 | 1
Black & White | HP046 | 1
Black/Multi | JP017 | 1
Neutral | [NAME] | 1
Taupe | CP039 | 1
Black/Multi | HP018 | 1
Black/Multi | KP199 | 1
Stone | KP061 | 1
Black/Multi | [NAME] | 1
Red/Multi | [NAME] | 1
Red | DP156 | 1
Black/Multi | KP255 | 1
Black & White | [NAME] | 1
Black/Multi | [NAME] | 1
Spreadsheet: 85289d1285322894-timeline-formula-expectedresults
Sheet: Sheet1

Name | Site | Start1 | End1
 |  |  |  | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00
Humpty dumpty | Wait | 08:01:00 | 08:03:00 | L | L | 00:02:00 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
Humpty dumpty | Call | 08:03:00 | 08:09:00 | L | L | 00:06:00 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
Humpty dumpty | Call | 07:30:00 | 08:13:00 | 00:15:00 | 00:15:00 | 00:13:00 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
Humpty dumpty | Wait | 08:13:00 | 08:21:00 | L | L | 00:02:00 | 00:06:00 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
Spreadsheet: daren_farmer__5489__2000 Winter Plan
Sheet: March

March
1999 | 2000 |  |  |  |  |  |  |  | 2001-03-01 00:00:00 |  |  |  |  |  | Booked Volume
 | Actual | Norm |  |  |  |  |  |  | Number of Days = | 31 | Entex Desc. |  | Sitara
110 | 76.5 | 248 |  |  |  |  |  |  |  |  |  |  |  |  | Daily | Monthly
75 | 72 | 68
53 | 54 | 46 |  |  |  |  |  |  | Residential
64 | 63 | 57 |  |  |  |  |  |  | 012-41991-301 | 91% Domestic | HPL 76 |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 016-41991-301 | Transactions 3,5,7 | ECT Trans # 1 |  | 70201 |  | 10500
 |  | Booked |  |  |  |  |  |  | 016-41991-313 | Existing (expired) | NGMS 308 |  | 72063 |  | 0
66 | 124.6 | 139.804 |  |  |  |  |  |  | 016-41991-306 | Silsbee | K 306, Trans 3 |  | 78418 |  | 250
8.078 | 7.2 | 7.55 |  |  |  |  |  |  | 016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll |  | 70549 |  | 5000
 |  |  |  |  |  |  |  |  |  |  | Subtotal |  |  |  | 15750
57 | 53.6 | 45.3
 |  |  |  |  |  |  |  |  | 016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1 |  | 292249
MARCH ENTEX |  |  |  |  |  |  |  |  | Total Residential
 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 |  | Industrial
[NAME] (IAH) |  |  |  |  |  |  |  |  | 012-41991-301 | 9% Industrial | HPL 76 |  |  |  | 0
 |  |  |  |  |  |  |  |  | 016-41991-311 |  | CNG |  | 70114 |  | 250
 |  |  |  |  |  |  |  |  | 016-41991-306 | Trans 6 - Entex (Tier 1) | Tier 1 |  | 70495 |  | 20000
HDD | 161 | 141 | 158.5 | 265 | 82.5 | 217 | 110 |  | 016-91000-303 | Trans 5 - Unit (Tier 1) | Tier 1 |  | 70499 |  | 10000
CDD | 39.5 | 70 | 94 | 50 | 90.5 | 63 | 70.5 |  |  |  | [NAME]
Avg. [NAME] | 71.5 | 73.8 | 71.4 | 69.8 | 75 | 70.9 | 74.5 |  | 016-41991-306 | VA Hospital (expired) | VA Hosp |  | 78417 |  | 0
[NAME]. Min Temp | 50.6 | 51.6 | 54.4 | 46.3 | 55.5 | 49.2 | 52.9
[NAME] | 61.1 | 62.7 | 62.9 | 58.1 | 65.3 | 60 | 63.7 |  |  | Total Industrial at meter 2000 |  |  |  |  | 30250
[NAME] (Day) | 84 (25) | 83 (23) | 88 (22) | 87 (30) | 86 (28) | 84 (29) | 85 (6)
Min Temp (Day) | 29 (14) | 32 (10) | 32 (8) | 28 (10) | 40 (3) | 30 (11) | 32 (15) |  | 016-91000-301 | North Star Steel | Vidor |  | 60952 |  | 4000
 |  |  |  |  |  |  |  |  | 016-41991-306 | [NAME]. (trans #7) | Lufkin Diboll |  | 70550 |  | 8000
[NAME] |  |  |  |  |  |  |  |  | 016-41991-312 | [NAME]. | Temple Inland |  | 70119 |  | 2800
Total Residential |  |  | 177 | 258 | 120 | 212 | 66
Total H/W/C |  |  | 8 | 8 | 5 | 10 | 8 |  |  | Total Industrial not at meter 2000 |  |  |  |  | 14800
NET |  |  |  |  |  |  |  |  | Total Industrial
Total Industrial |  |  | 56 | 59 | 54 | 64 | 57 |  | H/W/C
 |  |  |  |  |  |  |  |  | 016-41991-301 | Huntsville | Transaction 6 |  | 70211 |  | 1875
TOTAL |  |  |  |  |  |  |  |  | 016-41991-301 | Woodlands | Transaction 9 |  | 70235 |  | 3000
 |  |  |  |  |  |  |  |  | 016-41991-301 | Conroe | Transaction 8 |  | 70222 |  | 2750
Midcon Volumes |  |  | 54 | 86 | 31 | 62 | 0
 |  |  |  |  |  |  |  |  | Total H/W/C
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | T1-T10
Spreadsheet: 271553d1381973132-need-formula-to-this-logic-a-column-number-b-column-blank-then-c-column-desired-name-compare-words
Sheet: Sheet1

REMARKS | AUDIT DONE STATUS | AUDIT NOT DONE STATUS
 | AUDIT DONE
 | AUDIT DONE
CUG NOT GIVEN |  | NOT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
CUG NOT GIVEN |  | NOT DONE
CUG NOT GIVEN     V2O@30P(BR50p)@Rs.30 |  | NOT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
CUG NOT GIVEN LOC+STD @Rs 25    PRICE GROUP WRONG |  | NOT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
CUG NOT GIVEN |  | NOT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
 | AUDIT DONE
Spreadsheet: 840740d1692949576-formula-needed-for-different-price-when-brought-at-different-qty-book2
Sheet: Sheet1

No of apple | Price | Average Price |  |  |  |  |  |  | Manual Trial & Error |  | [NAME] | Apple Left
1 | 6 |  |  |  |  |  |  | No of apple | Multiple | Amount
3 | 17 |  |  |  | No of Apples | 87 |  | 13 | 6
5 | 25 |  |  |  | Price |  |  |  | 1
12 | 55 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 | Breakdown |  | 12 |  |  |  |  |  | Total Price
 |  | 0 | 5
 |  | 1 | 3
 |  | 0 | 1 |  |  |  |  | Is it possible to compute in a single formula?
Check
2
3
4
5
6
7
8
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
Spreadsheet: 878103d1725070550-hyperlink-help-hyperlink-lookup
Sheet: Course List

 | Course Name | Course Code | Web Address
0 | - | - | -
1 | Certificate II in ESI - Powerline Vegetation Control | UET20321 | www.microsoft.com
2 | Certificate III in Arboriculture | AHC30824 | www.google.com
3 | High Risk Work Licence - Boom-type Elevating Work Platform (WP) | - | www.america.com
4 | Apply work health and safety requirements for powerline vegetation control | UETDRVC001 | -
5 | Comply with environmental requirements | UETDREL002 | -
6 | Monitor vegetation control work in the vicinity of live electrical apparatus | UETDRVC009 | -
7 | Operate and maintain chainsaws | AHCMOM213 | -
8 | Working safely near live electrical apparatus as a non-electrical worker | UETDREL006 | -
Spreadsheet: 708027d1607591411-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: AUSTRALIA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 844333d1696057993-please-help-error-formula-fill-in-map-error-aligw
Sheet: Sheet1

 |  |  |  |  | target no need help column (only one column)
 |  |  |  | Data | need help to fix |  | help column | Target Result
 |  |  |  | Text 1
 |  |  |  |  | Text 1 |  | 0 | Text 1
 |  |  |  |  | Text 1 |  | 0 | Text 1
 |  |  |  | Text 2 | Text 2 |  | Text 2 | Text 2
 |  |  |  |  | Text 2 |  | 0 | Text 2
 |  |  |  |  | Text 2 |  | 0 | Text 2
 |  |  |  | Text 3 | Text 3 |  | Text 3 | Text 3
 |  |  |  |  | Text 3 |  | 0 | Text 3
 |  |  |  | subt | Text 3 |  | 0 | Text 3
 |  |  |  |  | Text 3 |  | 0 | Text 3
 |  |  |  | Text 4 | Text 4 |  | Text 4 | Text 4
 |  |  |  |  | Text 4 |  | 0 | Text 4
 |  |  |  | subt | Text 4 |  | 0 | Text 4
 |  |  |  |  | Text 4 |  | 0 | Text 4
 |  |  |  |  | Text 4 |  | 0 | Text 4
 |  |  |  | Text 5 | Text 5 |  | Text 5 | Text 5
 |  |  |  |  | Text 5 |  | 0 | Text 5
 |  |  |  |  | Text 5 |  | 0 | Text 5
 |  |  |  |  | Text 5 |  | 0 | Text 5
 |  |  |  |  | Text 5 |  | 0 | Text 5
 |  |  |  |  | Text 5 |  | 0 | Text 5
Spreadsheet: efc50558-d19f-4e23-8b40-8885d22ee749
Sheet: Sheet1

2015-2016 Class Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected. | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
Political Science
Winter 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 887346d1737579094-conditional-formatting-borders-and-lines
Sheet: Border

Number | Name | Address |  |  |  |  |  |  |  |  | Number | name | Address
 |  |  | Conditional Formating for formula automatic borders
 |  |  | Conditional Formating for formula automatic numbers