tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3637b436-f57e-4f7b-bbc3-5a877786e53f
Sheet: Sheet1

Response Summary Document
Bid Request Number | RFB0612005032 Addendum 1 |  |  |  | Organization | Iowa Procurement Services Division
Title | Formalin for Iowa Fish Hatcheries |  |  |  | Bid Creator | Suzy Trotter Purchasing Agent 3
Description |  |  |  |  | [NAME] | [EMAIL]
Bid Type | RFB |  |  |  | Phone | (515) 281-3089
Open Date | 1/24/2012 12:11:45 PM Central |  |  |  | Fax | (515) 725-0145
Close Date | 2/9/2012 2:00:00 PM Central
Response Line Detail
Line 1 |  | Formalin - 37% (by weight) formaldehyde with order quantity equal to or less than 23 drums.
Name |  | QTY | UOM | Unit Price | Extended | Note to [NAME]
[NAME], INC. |  | 1 | 55 Gallon drum | 322.01 |  | 8 drum minimum order
Western Chemical Inc |  | 1 | 55 Gallon drum | 359
Line 2 |  | Formalin - 37% (by weight) formaldehyde with order quantity equal to 6 pallets / 24 drums for half truck load pricing.
Name |  | QTY | UOM | Unit Price | Extended | Note to [NAME]
[NAME], INC. |  | 1 | 55 Gallon drum | 304.9
Western Chemical Inc |  | 1 | 55 Gallon drum | 314
Line 3 |  | Formalin - 37% (by weight) formaldehyde with order quantity equal to 10 pallets / 40 drums for full truckload pricing.
Name |  | QTY | UOM | Unit Price | Extended | Note to [NAME]
Western Chemical Inc |  | 1 | 55 Gallon drum | 298
[NAME], INC. |  | 1 | 55 Gallon drum | 299.7
Line 4 |  | Heated shipping fee
Name |  | QTY | UOM | Unit Price | Extended | Note to [NAME]
Western Chemical Inc |  | 1 | EA | 1000 | 1000
[NAME], INC. |  | 1 | EA | 0 | 0 | We will be able to get a good rate on heated shipping when the time calls for it. Heated shipping fee varies depending on the amount of product ordered and the lanes they travel and the carrier. Carriers do not have a set fee for heated shipping.
Spreadsheet: 226158d1365261466-population-model-can-you-find-the-problem-here-population_model-upload_to_forum
Sheet: Model

 | Population Growth Model
 | Assumptions:
 | Annual % of Females Reproducing: | 1
 | Must be set between 0% - 100%
 | Starting Size of Population: | 1000
 | Odds of [NAME]: | 0.5
 | Set to 50% for gender equilibrium
 | Odds of Male Birth:
 | Survival rate: | 1
 | Mortality Rate:
 | Time in Years: | 0
 | Total Males
 | Total Fertile/Reproducing Females
 | New Stop Females | 0
 | Running Stop Females
 | New Male Offspring | 0
 | New Female Offspring | 0
 | Population After Births:
 | Total Male Population
 | Total Female Population
 | Grand Total Population:
 | Population Annual Growth Rate:
 | CAGR of Population:
 | Cum. Population Increase:
 | Balance of Genders
..
Spreadsheet: 682937d1592401743-reference-problem-test2
Sheet: Assumptions

 |  |  | 0.4 | 0.3 | 0.3 | 0.27 | 0.4 | 0.4 | 0.27
 | # | Prcs | ΧΑΑ | [NAME] | ΠΑΡΑΓΩΓΑ | [NAME] | ΚΥΠΡΟΣ | Αμ. ΔΙΑΧ | Ομόλογα  πρωτογενή  αγορα
 | 1 | ΔΗΛΟ
 |  | ΟΕΤΕ
 |  | ΤΑΜ.
 |  | 2330
 |  | 2350
 |  | 2400
 |  | 2420
 |  | ΙΝΕΤ
 |  | 3120
 |  | 3940
 |  | ΚΟΙΝΟ
 |  | [NAME]
 |  | 2402
 |  | 2422
 |  | ΔΡRΒ
 |  | ΚΟΙΝΟ2
 |  | 4300
 |  | VΙRΤUΟUS
 |  | 139Α
 |  | [NAME]
 |  | [NAME]
 |  | ΙΟLCΕΣ1
 |  | FΕLLΑSG
 |  | GΜΤRΑDΕ
 |  | GΜΤRΑDΕ2
 |  | JΚΤRΑDΕ
 |  | ΖΒΤRΑDΕ
 |  | ΡΕCUΝΙΑS
 |  | ΧΑRΑΧ
 |  | ΧΑRΑΧ2
 |  | 2331
 |  | 2401
 |  | 2421
 |  | 3121
 |  | 3941
 |  | ΚΟΙΝΟ1
 |  | ΕΧ1
 |  | ΕΠΡΑ
 |  | ΕΝDCLΙΕΝΤS
 |  | 101Ξ
 |  | [NAME]
 |  | ΣΕΛΑ
 |  | ΚΟΡΠ
 |  | ΟΤΕ SΟΡ
 |  | 2332
 |  | 2352
 |  | 4100
 |  | ΕFSW
 |  | GΑΜΜ
 |  | GΜΤRΑDΕ1
 |  | SΚGΤRΑDΕ
 |  | ΧΑRΑΧ1
 |  | ΧΑRΑΧ3
 |  | 2351
 |  | 9991
Spreadsheet: stacey_white__38978__10262001WestPosition
Sheet: Daily Peak and Off Peak

West Daily Peak and [NAME]
Daily Peak Change
Daily Off Peak Change
Spreadsheet: 843959d1695770352-lookup-if-an-value-repeats-and-mark-as-paid-test-lookup-paid-items-01
Sheet: Sheet1

DATE | PATRON | DOC # | ISSUES | PAID | OUTSTANDING
2023-01-01 00:00:00 | 12345 | 1111 | 500 |  | NO
2023-01-10 00:00:00 | 23456 | 2222 | 350 |  | YES |  | Column F will to see if a document (Column C) has been paid (Column E), if it has not bee paid, [NAME] will show No, if i has been paid it will show a Yes.
2023-01-20 00:00:00 | 98765 | 3333 | 800 |  | NO
2023-01-30 00:00:00 | 43210 | 4444 | 200 |  | YES |  | Items in Column E are always paid in full, no parital payments.
2023-02-10 00:00:00 | 12345 | 1111 |  | 500 | NO
2023-02-20 00:00:00 | 98765 | 3333 |  | 800 | NO
Spreadsheet: 705293d1605992468-is-if-formula-wrong-here-or-what-am-i-doing-wrong-handleliste
Sheet: Wraps med kylling

 |  | Slik gjør du det
Antall porsjoner | 3 |  |  | Handleliste |  |  | Ingredienser
 |  |  |  |  |  |  | 4 stk | Fullkornswrap
 | 1 | La kyllingfileten hvile i romtemperatur i rundt 30 minutter før steking slik at den ikke er kald når den skal i stekepannen. Da blir den jevnere stekt og mer saftig. |  |  |  |  | 2 stk | Kyllingfilet
 | 2 | [NAME] for fuktighet med tørkepapir som ikke loer og krydre med salt og pepper. |  |  |  |  | 2 ss | [NAME]
 | 3 | Ha olje som [NAME] høy temperatur i en stekepanne og [NAME] først på sterk varme slik at den får stekeskorpe. |  |  |  |  | 6 ss | [NAME]
 |  | Skru ned temperaturen på stekepannen og la [NAME] inntil den er gjennomstekt. Når kjernetemperaturen er ved 68 grader er den ferdig. |  |  |  |  | 80 g | Spinatblader
 |  | La hvile 5 minutter før du deler kyllingfileten i skiver. |  |  |  |  | 8 stk | Cherrytomater
 | 4 | [NAME]: [NAME] pesto og majones. |  |  |  |  | 1 klype | Salt
 | 5 | Smør et lag med pestomajones langs midten på hver tortillalefse. |  |  |  |  | 1 klype | Pepper
 | Tips | Ha på spinatblader og tomat eller andre grønnsaker [NAME], som for eksempel avokado, [NAME], agurk, ruccola eller annet. |  |  |  |  | 2 ss | Solsikkeolje
Spreadsheet: 67193d1267786862-sheet-name-appear-on-the-top-book1
Sheet: CNS

CNS
 | Part Code | Part name | Unit | Qty | Rate | Amount
 | 1100661 | OIL ENGINE 10 W 30 - SJ GRADE | L | 0.9 | 65.84 | 59.26
 | 12301-GB6-9000 | COVER CYLINDER HEAD | PC | 1 | 13.98 | 13.98
 | 12331-GB0-9100 | COVER R CYLINDER HEAD SIDE | PC | 1 | 19.69 | 19.69
 | 12341-GB6-9100 | COVER L CYLINDER HEAD SIDE | PC | 1 | 17.03 | 17.03
 | [PHONE] | HOLE CAP TAPPET ADJUSTING | PC | 2 | 5.47 | 10.94
Spreadsheet: 083e5bb6-ad87-469a-a3c6-237a0214431c
Sheet: 360 Link Referring Source

Referring Source ID: | Num of Requests | %Total(Num of Requests)
google | 1607 | 0.1557472378367901
36520 (EBSCOhost) | 1570 | 0.1521612715642566
ProQ | 1364 | 0.1321961620469083
www.isinet.com:WoK:WOS | 1317 | 0.1276410157007172
[NAME]:PubMed | 1185 | 0.1148478387284357
CAS:CAPLUS | 1013 | 0.09817794146152355
sersolReport | 594 | 0.05756929637526653
firstsearch.oclc.org:MEDLINE | 452 | 0.04380693932932739
www.isinet.com:WoK:UA | 225 | 0.02180655165729792
sersol:uniqueIDQuery | 129 | 0.01250242295018414
Elsevier:SD | 125 | 0.01211475092072107
sersol:RefinerQuery | 104 | 0.01007947276603993
IEEE.org:XPLORE | 75 | 0.007268850552432642
www.isinet.com:WoK:BIOSIS | 59 | 0.005718162434580345
AMS:MathSciNet | 48 | 0.004652064353556891
CAS:MEDLINE | 38 | 0.003682884279899205
firstsearch.oclc.org:[NAME] | 37 | 0.003585966272533437
Refworks: | 33 | 0.003198294243070362
[NAME]:Journals@Ovid Full Text | 31 | 0.003004458228338825
libx | 31 | 0.003004458228338825
EI:Compendex | 29 | 0.002810622213607288
jstor:jstor | 28 | 0.002713704206241519
wiley.com:OnlineLibrary | 27 | 0.002616786198875751
firstsearch.oclc.org:ArticleFirst | 23 | 0.002229114169412677
riu.worldcat.org:worldcat | 21 | 0.00203527815468114
[NAME]:[NAME] | 16 | 0.001550688117852297
aip.org:scitation | 15 | 0.001453770110486528
ProQ: | 15 | 0.001453770110486528
achs | 13 | 0.001259934095754991
firstsearch.oclc.org:ECO | 12 | 0.001163016088389223
mendeley.com/mendeley | 10 | 0.0009691800736576856
informa | 7 | 0.0006784260515603799
www.sciencemag.org | 7 | 0.0006784260515603799
[NAME]:pubget | 5 | 0.0004845900368288428
firstsearch.oclc.org:WorldCat | 5 | 0.0004845900368288428
muse.jhu.edu:muse | 4 | 0.0003876720294630742
nar.oxfordjournals.org | 4 | 0.0003876720294630742
guidetoptpractice.apta.org | 4 | 0.0003876720294630742
mal | 4 | 0.0003876720294630742
gerontologist.oxfordjournals.org | 3 | 0.0002907540220973057
BMC | 2 | 0.0001938360147315371
ingentaconnect.com | 2 | 0.0001938360147315371
jxb.oxfordjournals.org | 2 | 0.0001938360147315371
rsif.royalsocietypublishing.org | 2 | 0.0001938360147315371
mend.endojournals.org | 2 | 0.0001938360147315371
plankt.oxfordjournals.org | 2 | 0.0001938360147315371
Refworks:University of Rhode Islan | 1 | 9.691800736576855e-05
circ.ahajournals.org | 1 | 9.691800736576855e-05
bloodjournal.hematologylibrary.org | 1 | 9.691800736576855e-05
rstb.royalsocietypublishing.org | 1 | 9.691800736576855e-05
sageke.sciencemag.org | 1 | 9.691800736576855e-05
biomedgerontology.oxfordjournals.org | 1 | 9.691800736576855e-05
ncp.sagepub.com | 1 | 9.691800736576855e-05
ar | 1 | 9.691800736576855e-05
toxsci.oxfordjournals.org | 1 | 9.691800736576855e-05
physrev.physiology.org | 1 | 9.691800736576855e-05
www.isinet.com:RS:EndNoteWeb | 1 | 9.691800736576855e-05
isq.sagepub.com | 1 | 9.691800736576855e-05
aob.oxfordjournals.org | 1 | 9.691800736576855e-05
cisti.nrc.gc.ca:NRC-CISTI | 1 | 9.691800736576855e-05
www.itergateway.org:iter | 1 | 9.691800736576855e-05
www.plantphysiol.org | 1 | 9.691800736576855e-05
jcem.endojournals.org | 1 | 9.691800736576855e-05
Grand total: | 10318 | 0
Spreadsheet: 186190d1349955936-help-how-to-remove-rows-of-zeros-to-shrink-the-data-to-an-organized-list-removezeros
Sheet: Sheet1

Product Code Number | Customer Name | Customer Membership ID |  |  |  | Product Code Number | Customer Name | Customer Membership ID
0 | 0 | 0 |  |  |  | C45605 | [NAME] | D4431223
C45605 | [NAME] | D4431223 |  |  |  | H23094 | [NAME] | [NAME]
0 | 0 | 0 |  |  |  | A87896 | [NAME] | D4311239
0 | 0 | 0 |  |  |  | R23193 | [NAME] | D3412022
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
H23094 | [NAME] | [NAME]
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0 |  | How do we remove all the rows that contains zeros and shrink the whole table for simple viewing?
0 | 0 | 0
A87896 | [NAME] | D4311239
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
R23193 | [NAME] | D3412022
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | 500168 | Westar Ward
 | Scheduled | Measured
1 | 41027 | 41272
2 | 45258 | 44915
3 | 46312 | 46328
4 | 61758 | 60404
5 | 85857 | 84606
6 | 63270 | 62581
7 | 45500 | 43699
8 | 35500 | 34169
9 | 35500 | 35835
10 | 35500 | 35962
11 | 20500 | 23884
12 | 49007 | 48263
13 | 41552 | 41466
14 | 40500 | 40429
15 | 40500 | 39475
16 | 50500 | 50444
17 | 50500 | 50422
18 | 19910 | 24369
19 | 6537 | 8251
20 | 26335 | 30776
21 | 35486 | 40798
22 | 59622 | 57832
23 | 55873 | 58513
24 | 66165 | 67606
25 | 46454 | 47161
26 | 26336 | 25310
27 | 26248 | 25385
28 | 25456 | 25994
29 | 46552 | 46861
30 | 46552 | 45940
31 | 45142 | 48027
index
2000-11-30 00:00:00 |  |  | 191557.42
2000-12-31 00:00:00
Spreadsheet: 0c3764d7-1aa0-4de6-b462-18b70815d27d
Sheet: Sheet1

Deleted Gene | NCBI Identifier of associated protein | Alternate Gene | NCBI identifier of associated protein | Forward BLAST e-value | BLAST score
aspC | NP_415448 | tyrB | NP_418478 | 4e-94 | 338
ispU | NP_414716 | yaeS | AAY89717 | 3e-93 | 330
[NAME] | NP_415434 | mdlA | NP_414982 | 4e-68 | 252
ilvD | YP_026248 | edd | NP_416365 | 4e-48 | 186
fabG | [NAME] | idnO | NP_418687 | 1e-39 | 156
ispA | P22939 | ispB | NP_417654 | 1e-20 | 94
glmS | NP_418185 | purF | NP_416815 | 1e-13 | 71.6
purF | NP_416815 | glmS | NP_418185 | 1e-13 | 71.6
gmk | NP_418105 | phnN | NP_418518 | 5e-07 | 48.1
asd | NP_417891 | usg | NP_416822 | 1e-05 | 44.7
ubiA | NP_418464 | cyoE | NP_414962 | 3e-05 | 42.7
murF | [NAME] | - | NP_414630 | 0.0003 | -
pyrD | P0A7E1 | yeiA | AP_002744 | 0.0004 | 39.3
dfp | NP_418096 | yfiE | AP_003163 | 0.0008 | 38.5
mraY | NP_414629 | - | NP_418231 | 0.003 | 36.6
purB | NP_415649 | fumC | [NAME] | 0.003 | 37
[NAME] | YP_026260 | flgJ | NP_415599 | 0.053 | 32.3
thiG | NP_418418 | lsrF | NP_416034 | 0.057 | 31.6
coaD | NP_418091 | nadD | NP_415172 | 0.062 | 30.4
pyrE | NP_418099 | gntX | AP_004377 | 0.073 | 30.8
purD | NP_418433 | ddlB | NP_414634 | 0.08 | 32
gpsA | NP_418065 | yajR | AP_001077 | 0.096 | 31.6
kdtA | AAC76657 | gudX | NP_417268 | 0.22 | 30.8
ispD | NP_417227 | glmU | AAZ80079 | 0.5 | 28.5
cdsA | NP_414717 | yhdY | AP_003810 | 0.78 | 28.1
argA | NP_417295 | uxuA | NP_418742 | 0.84 | 28.9
dxr | NP_414715 | der | AP_003097 | 0.89 | 28.5
lpxK | NP_415435 | - | AP_003436 | 0.96 | 28.1
folD | NP_415062 | - | BAA04680 | 1.3 | 27.3
ribE | [NAME] | [NAME] | YP_026256 | 1.4 | 26.2
folK | P26281 | ydeP | NP_416018 | 1.6 | 25.8
psd | NP_418584 | yiiM | AP_003898 | 2.9 | 26.6
luxS | P45578 | yehI | [NAME] | 3 | 25
murG | NP_414632 | bglX | NP_416636 | 3.4 | 26.6
fabD | - | - | - | - | -
purB | NP_415649 | fumC | [NAME] | 0.003 | 37
gpsA | NP_418065 | yajR | AP_001077 | 0.096 | 31.6
folD | NP_415062 | - | BAA04680 | 8.7 | 24.6
Spreadsheet: 220153d1363085336-complex-vlookup-from-range-sample_vinodh
Sheet: Sayfa1

 |  | MON | TUE | WED
 |  |  | [NAME] |  |  |  |  | [NAME] | MON | TUE | WED | WED | TUE | TUE | MON | TUE |  | What I want to achieve is :
 |  | Vinodh |  |  |  |  |  | Vinodh | MON | TUE | WED | WED | TUE | TUE | MON | MON |  | for j2
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] name at I2….in this case [NAME]
 |  |  | Vinodh | Vinodh |  |  |  |  |  |  |  |  |  |  |  |  |  | find the FIRST occurence of [NAME] at c2:e18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | which is D2
 |  | [NAME] |  | Vinodh |  |  |  |  |  |  |  |  |  |  |  |  |  | lookup column header… TUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | type in j2…TUE
 |  |  | Vinodh | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for k2
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] name at I2….in this case [NAME]
 |  |  | Vinodh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | find the SECOND occurence of [NAME] at c2:e18
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | which is C4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lookup column header.. MON
 |  | Vinodh |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | type in K2.. MON
 |  | Vinodh |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and as we go on we have to be able to line up the header values horizontally
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | omitting the spaces.
Spreadsheet: 599837d1543331456-control-data-entry-formats-control-data-entry_mask
Sheet: Folha1

ID
1 | OK |  |  |  | Control data entry formats with input masks, is possible?
2 | OK
50 | OK |  |  |  | It is only allow to insert ID digits from 1 to 99, or the word "Out"
90 | OK |  |  |  | If the ID correspond to a period, the first digit and the last need to be separate with a "-"
99 | OK |  |  |  | example: 1-20, 92-99 (the maximum digit of the first or last period is also 99)
1-20 | OK
50-90 | OK
92-99 | OK
Out | OK
100 | Error
1to20 | Error
Outrange | Error
Spreadsheet: 839602d1692108711-add-new-column-to-a-sheet-if-criteria-report
Sheet: All data

 |  | Date: |  | 2023-08-05 00:00:00 | 2023-08-04 00:00:00 | 2023-08-03 00:00:00 | 2023-08-02 00:00:00 | 2023-08-01 00:00:00
 |  | Product |  | Quantity | Quantity | Quantity | Quantity | Quantity
 |  | Gloves: |  | 5 | 4 | 3 | 2 | 1
 |  | Shoes: |  | 6 | 5 | 4 | 3 | 2
 |  | Shocks: |  | 7 | 6 | 5 | 4 | 3
 |  | Sum:
Spreadsheet: jonathan_mckay__16942__LGA_Temps1
Sheet: Monthy av DD

 | Average | [NAME] | Min
November | 516 | 657 | 396
December | 836 | 1205 | 652
January | 991 | 1250 | 741
February | 844 | 1178 | 678
March | 705 | 920 | 557
Spreadsheet: 158152d1338008866-excel-2007-array-formula-sample-workbook
Sheet: Sheet1

# Days: | 20 | Correlation | AAXJ | ACWI | AGG
 | iShares MSCI All Country Asia ex Japan Index Fund | AAXJ |  |  | -0.3633881453178159
 | iShares MSCI ACWI Index Fund | ACWI |  |  | -0.4030752253890559
 | iShares Lehman Aggregate Bond (ETF) | AGG |  |  | 0.9999999999999998
Spreadsheet: 105970d1303228283-extract-data-between-two-dates-copy-of-dates
Sheet: Sheet1

Date | Value | Remark
2001-04-01 00:00:00 | 50 | abc | 1 | 3
2001-04-02 00:00:00 | 30 | bbb | 2
2001-08-03 00:00:00 | 25 | ddd
2002-05-04 00:00:00 | 10 | ggg
2002-12-08 00:00:00 | 15 | ttt
2001-04-07 00:00:00 | 39 | iii | 3 |  | This should form in sheet 2
2003-11-09 00:00:00 | 40 | uuu |  |  | or in this sheet (is easier)
Spreadsheet: 100148d1298573847-coping-matching-info-from-cell-to-cell-forums-help-file
Sheet: Sheet1

User | Total Scores | # of Scores | [NAME]. |  | Manager | Total
Adam | 200 | 2 | 100 |  | [NAME]
[NAME] | 160 | 2 | 80 |  | Andres
Alejandro | 175 | 2 | 87.5 |  | [NAME]
[NAME] | 190 | 2 | 95 |  | [NAME]
Andres | 200 | 2 | 100 |  | [NAME]
[NAME] | 170 | 2 | 85 |  | Angelina
[NAME] | 130 | 2 | 65 |  | [NAME]
[NAME] | 190 | 2 | 95 |  | [NAME]
Angelina | 190 | 2 | 95 |  | Alejandro
[NAME] | 180 | 2 | 90
[NAME] | 175 | 2 | 87.5
[NAME] | 85 | 1 | 85
Branden | 200 | 2 | 100
Spreadsheet: 713188d1610583154-filter-range-based-on-unique-values-in-a-column-sample
Sheet: Sheet1

Name | Service | Number | Department
George | Cable | 10 | AC
George | Phone | 10 | AC
[NAME] | Phone | 9 | DP
[NAME] | Internet | 9 | DP
Result:
Name | Service | Number
George | Cable | 10
[NAME] | Phone | 9
Spreadsheet: 679447d1590424121-sorting-or-formula-to-club-the-transaction-sort-or-clubing-assistance
Sheet: Sheet1

Data |  |  |  |  |  |  |  |  | Extpectation
Event | Transactions | Descriptiion | Dr | Cr | for sorting purport |  |  |  | Event | Transactions | Descriptiion | Dr | Cr | expected sorting purport
invoice | 2018-12-01 00:00:00 | xyz | 100 |  |  |  |  |  | invoice | 2018-12-01 00:00:00 | xyz | 100
Payment | 55567 | abc |  | 105 |  |  |  |  | invoice | 2018-12-01 00:00:00 | vat | 5
invoice | D001 | xyz | 200 |  |  |  |  |  | Payment | 55567 | abc |  | 105
invoice | D001 | vat | 10 |  |  |  |  |  | invoice | 2018-12-01 00:00:00 | xyz | 100
Payment | 55568 | abc |  | 210 |  |  |  |  | invoice | 2018-12-01 00:00:00 | vat | 5 |  |  | invoice no will be dubplicate
invoice | F9ur48 | xyz | 300 |  |  |  |  |  | Payment | 55570 | abc |  | 105
invoice | F9ur48 | vat | 15 |  |  |  |  |  | invoice | TG7777/4 | xyz | 100
Payment | 55569 | abc |  | 315 |  |  |  |  | invoice | TG7777/4 | vat | 5
invoice | 2018-12-01 00:00:00 | xyz | 100 |  |  |  |  |  | Payment | 66675 | abc |  | 105
invoice | 2018-12-01 00:00:00 | vat | 5 |  |  |  |  |  | invoice | D001 | xyz | 200
Payment | 55570 | abc |  | 105 |  |  |  |  | invoice | D001 | vat | 10
invoice | TG7777/4 | xyz | 100 |  |  |  |  |  | Payment | 55568 | abc |  | 210
invoice | TG7777/4 | vat | 5 |  |  |  |  |  | invoice | F9ur48 | xyz | 300
Payment | 66675 | abc |  | 105 |  |  |  |  | invoice | F9ur48 | vat | 15
Payment | 55570 | abc |  | 130000 |  |  |  |  | Payment | 55569 | abc |  | 315
invoice | TG7777/4 | xyz | 50000 |  |  |  |  |  | invoice | TG7777/4 | xyz | 50000
Payment | 66675 | abc |  | 50000 |  |  |  |  | Payment | 66675 | abc |  | 50000
invoice | 2018-12-01 00:00:00 | vat | 5 |  |  |  |  |  | invoice | TG7777 | xyz | 130000
invoice | TG7777 | xyz | 130000 |  |  |  |  |  | Payment | 55570 | abc |  | 130000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pls note - payment is full - invoice and vat are in seprate line. No assciation details with invoice and payment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for validation purpose I need to idendtify the debit vs credit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Either by sorting or by formula, I want to club these transaction
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | any other suggestion also will be helpful
Spreadsheet: 69506d1270037167-drop-down-list-returns-variable-number-of-values-without-blanks-hallyworkbook
Sheet: Sheet1

[NAME]'s [NAME]
Department: | Engineering
Cost Centre Codes
Spreadsheet: 1e1cb85f-7aba-4b44-83bb-43c80274d3bb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3834 | 26254 | Geoff | Thorsen | AUS | 0 | 00:43:19 | 00:00:54 | 01:24:32 | 00:01:37 | 00:24:57 | 1 | 02:35:22
3834 | 19931 | Clive | Glover | AUS | 0 | 00:49:26 | 00:01:13 | 01:39:57 | 00:01:23 | 00:28:55 | 2 | 03:00:57
3834 | 19966 | [NAME] | [NAME] | AUS | 0 | 00:54:11 | [NAME] | 01:41:23 | 00:02:01 | 00:31:33 | 3 | 03:10:57
3834 | 26253 | Volker | Ecke | AUS | 0 | 00:44:59 | 00:00:56 | 01:39:25 | 00:01:39 | 00:56:31 | 4 | 03:23:34
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 212471424 | 89903264 | 18499906 | 45006360
FRA | 91448660 | 7879259 | 8775333 | 3838977
OIS | 46810661 | 9499673 | 6596358 | 3631018
OTHER* | 10164354 | 63589919 | 1035416 | 19818761
TOTAL | 360895099 | 170872115 | 34907013 | 72295116
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 124711d1318559535-find-nth-largest-value-in-a-row-and-return-value-from-a-different-row-in-the-column-excelhelp1
Sheet: Sheet1

 | Name | [NAME] | [NAME] | [NAME] | Sue | [NAME] | [NAME] |  | Date:
 | City | DesMoines | Denver | Duluth | DesMoines | Denver | Duluth |  | Rank | Name | City
 | 2011-01-01 00:00:00 | 20 | 15 | 10 | 5 | 25 | 30 |  | 1
 | 2011-01-02 00:00:00 | 22 | 33 | 14 | 17 | 18 | 22 |  | 2
 | 2011-01-03 00:00:00 | 29 | 13 | 32 | 24 | 13 | 31 |  | 3
 | 2011-01-04 00:00:00 | 44 | 53 | 23 | 43 | 23 | 12 |  | 4
 | 2011-01-05 00:00:00 | 16 | 36 | 27 | 29 | 58 | 34 |  | 5
 |  |  |  |  |  |  |  |  | 6
Spreadsheet: 548241d1510943868-calendar-creation-using-existing-data-academic-calendar-any-year-_updated
Sheet: Weekly

 |  |  |  | Date: | 2018-02-02 00:00:00
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | 0
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
20:45:00
21:00:00
Spreadsheet: 237608d1369259133-selecting-names-based-on-associated-value-size-excel1
Sheet: Sheet1

 |  |  |  |  | Global Priorities for EOL Options
 | # | Component | Material | Weight (g) | Reuse | Remanufacture | Recycle | Incinerate | Landfill | Special handling |  | 1st Preference | 2nd Preference | 3rd Preference
 | 1 |  |  |  | 5 | 4 | 3 | 7 | 9 | 1 |  | Landfill | Incinerate | Reuse | <-- Proposed Result
 | 2 |  |  |  | 6 | 5 | 7 | 3 | 1 | 2 |  | Recycle | Reuse | Remanufacture
 | 3 |  |  |  | 5 | 3 | 4 | 2 | 3 | 7 |  | Special Handling | Reuse | Recycle
 | 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