tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870334d1716879837-requesting-help-modifying-an-excel-formula-if-formula-surname-suffix-aligw
Sheet: Sheet4

FULL NAME | FIRST NAME | MIDDLE NAME | LAST NAMES
[NAME] |  |  |  | << This cell gave an error because it only has two words; [NAME] and Surname. But must extract the surname
[NAME] |  |  |  | << This cell should not must extract part of the [NAME] and Middle Name. Just Surnames
[NAME] |  |  |  | << This cell should not must extract Middle Name. Just Surnames
Yeisa Amanda [NAME] |  |  |  | << This cell is OK because som lantin names has two Surnames
Scarville  [NAME] |  |  |  | <<  This is the one I got manualy with -8 value to have Surname and Suffix.
[NAME] |  |  |  | << This cell should not must extract part of the Name. Just Surnames. But is counting 8 characters length
In this formula, I increased -8 to take 8 spaces more and get the surname. But only it's right for cell D8. How can this work for different surname lengths? And how I can intagrate this two functions?
IF(ISNUMBER(FIND(" "; A7)); MID(A7; FIND("@"; SUBSTITUTE(A7; " "; "@"; LEN(A7) - LEN(SUBSTITUTE(A7; " "; ""))))-8; LEN(A7)); "")
IF(ISNUMBER(FIND(" "; A7)); MID(A7; FIND("@"; SUBSTITUTE(A7; " "; "@"; LEN(A7) - LEN(SUBSTITUTE(A7; " "; "")))); LEN(A7)); "")
FULL NAME | FIRST NAME | MIDDLE NAME | LAST NAMES
[NAME]
[NAME]
[NAME]
Yeisa Amanda [NAME]
Scarville  [NAME]
[NAME]
 |  |  |  | Thaks in advance for your valuable help!
Spreadsheet: 742144d1627558738-trying-to-undersgtand-why-i-am-getting-an-na-error-compare-2-sets-of-data
Sheet: Compare

U = Unique to MASTER List S = Shared with COMPARE List | MASTER List (Longest list) | COMPARE List | U = Unique to COMPARE List S = Shared with Master List
 | a | z
 | b | b
 | c | c
 | d | c
 | e | d
 | f | e
 | g | f
 | h | g
Spreadsheet: 844670d1696409428-assembly-part-calculation-finished-result
Sheet: Sheet1

Assembly | Quantity of assembly | Parts name | Parts quantity in one assembly | The assembly to which the parts belong | Total quantity |  | Part name | Total quantity for all
B-PL-S-1_DP | 10 | B-PL-S-1 | 1 | B-PL-S-1_DP |  |  | B-PL-S-1 | 20
B-PL-S-2_DP | 10 | B-PL-STD-1 | 1 | B-PL-S-1_DP |  |  | B-PL-STD-1 | 20
 |  | B-PL-STD-2 | 2 | B-PL-S-1_DP |  |  | B-PL-STD-2 | 40
 |  | Varztas HDG M12x140 ISO4017 8.8 | 2 | B-PL-S-1_DP |  |  | Medsraigtis [NAME] 12x100 DIN571 | 80
 |  | Poveržlė HDG M12 8.8 klasė | 2 | B-PL-S-1_DP |  |  | Poveržlė HDG M12 8.8 klasė | 40
 |  | Medsraigtis [NAME] 12x100 DIN571 | 4 | B-PL-S-1_DP |  |  | Varztas HDG M12x140 ISO4017 8.8 | 40
 |  | Vinys_HILTI_X-U_16MX | 8 | B-PL-S-1_DP |  |  | Vinys_HILTI_X-U_16MX | 160
 |  | B-PL-S-1 | 1 | B-PL-S-2_DP |  |  | Grand Total | 400
 |  | B-PL-STD-1 | 1 | B-PL-S-2_DP
 |  | B-PL-STD-2 | 2 | B-PL-S-2_DP
 |  | Varztas HDG M12x140 ISO4017 8.8 | 2 | B-PL-S-2_DP
 |  | Poveržlė HDG M12 8.8 klasė | 2 | B-PL-S-2_DP
 |  | Medsraigtis [NAME] 12x100 DIN571 | 4 | B-PL-S-2_DP
 |  | Vinys_HILTI_X-U_16MX | 8 | B-PL-S-2_DP
Spreadsheet: gerald_nemec__11446__Day 7
Sheet: Day7 

 | Date | 2000-08-29 00:00:00
 | Well | San Arroyo #1 |  |  |  |  | TD | 5030
 | County/St. | Grand/Utah |  |  |  |  | Formation Completing |  | Entrada
 | Well Service Co, |  |  |  |  |  | Perfs | upper 4851-4923 4923-93 Lower 5009-15
 | Daily Cost |  |  |  |  | Daily Cost
 | Supervision |  |  | 450
 | Workover |  |  | 1500
 | Weathford BOP |  |  | 145
 | Packer |  |  | 1170
 |  |  |  |  |  |  |  | total
 |  |  |  |  |  |  |  | Cumulative cost
 | Details | FCP 5 psi on a 2" valve
 |  | Pumped 10 bbls of fluid
 |  | Picked up 7" big bore test packer
 |  | TIH Tag up bottom at 5007 Picked up 8' to 4999 ( bottom perf from 5009-15)
 |  | Set packer with 15pt of tension NU wellhead
 |  | Shut in 1 hour sitp 80 psi sicp 150
 |  | Open up well kick off flowed for 10 mins died.
 |  | Left tubing open to frac tank
 |  | 45mins to frac tank well kicked off flowed for 10mins
 |  | Shut for a 30min build up sitp 0 sicp270
 |  | Open to frac tank left open fro 1 hour well kicked of flowed for 15mins.
 |  | Caught sample Load water KCl
 |  | 5pm RU swab unit sicp 370
 |  | 6pm SICP 450 tubing lite blow. Well kicked off flowed for 15 mins died
 |  | First fluild level at 3500'  sicp 470
 |  | Started out of hole with swab got hung up at 3000 ft.
 |  | Working swab won't come free
 |  | SCIP 500 psi
 |  | Total fluid recovered today 5 bbls of load water
 |  | Pull tension on swab and left open to frac tank.
 |  | Caught gas sample N2 22% CO2 22% did not flow enough to get a good sample
 |  | Jts  2 3/8 | Tbg    FT |  |  | Packer Model |  | Arrow | Set at: | 4805
 |  | Rods | Ft |  |  | Tubing Anchor Model |  |  | Set at:
 |  |  |  |  |  | [NAME]
 | Present Operation
 | Rig Operator |  | Red |  |  | Consultant | [NAME]
 | Co. Supervisor |  | [NAME]
Spreadsheet: 216022d1361560588-change-cell-format-to-make-sum-function-possible-sum-of-numbers
Sheet: Sheet1

373395284 | 22-02-2013 | 680 | 20 000 € | 18 | [NAME]
373989819 | 22-02-2013 | 610 | 15 000 € | 18 | redelijk
374235170 | 22-02-2013 | 550 | 16 000 € | 18 | redelijk
374133876 | 22-02-2013 | 790 | 10 000 € | 18 | redelijk
361673568 | 22-02-2013 | 1 420 | 25 000 € | 18 | redelijk
374225478 | 22-02-2013 | 1 480 | 51 000 € | 18 | redelijk
365369793 | 22-02-2013 | 1 140 | 5 000 € | 18 | [NAME]
373822317 | 21-02-2013 | 990 | 1 000 € | 18 | redelijk
374119541 | 21-02-2013 | 1 180 | 1 000 € | 18 | redelijk
367179737 | 21-02-2013 | 1 640 | 51 000 € | 18 | [NAME]
Spreadsheet: 150967d1334748896-excel-2007-aging-formula-dates-and-figures
Sheet: Sheet1

 |  | 0-30 | 31-60 | 61-90 | 90+ |  |  | day betwen | sum >=30 | sum>=60 | sum>=90 | sum90+ |  |  | just here to show you the calcs work (can be deleted)
2012-04-18 00:00:00
2012-04-17 00:00:00
2012-04-15 00:00:00 |  |  |  |  |  |  |  |  |  | sum60-30 | sum90-60
2012-04-13 00:00:00
2012-04-11 00:00:00
2012-04-09 00:00:00
2012-04-07 00:00:00
2012-04-05 00:00:00
2012-04-03 00:00:00
2012-04-01 00:00:00
2012-03-30 00:00:00
2012-03-28 00:00:00
2012-03-26 00:00:00
2012-03-24 00:00:00
2012-03-22 00:00:00
2012-03-20 00:00:00
2012-03-18 00:00:00
2012-03-16 00:00:00
2012-03-14 00:00:00
2012-03-12 00:00:00
2012-03-10 00:00:00
2012-03-08 00:00:00
2012-03-06 00:00:00
2012-03-04 00:00:00
2012-03-02 00:00:00
2012-02-29 00:00:00
2012-02-27 00:00:00
2012-02-25 00:00:00
2012-02-23 00:00:00
2012-02-21 00:00:00
2012-02-19 00:00:00
2012-02-17 00:00:00
2012-02-15 00:00:00
2012-02-13 00:00:00
2012-02-11 00:00:00
2012-02-09 00:00:00
2012-02-07 00:00:00
2012-02-05 00:00:00
2012-02-03 00:00:00
2012-02-01 00:00:00
2012-01-30 00:00:00
2012-01-28 00:00:00
2012-01-26 00:00:00
2012-01-24 00:00:00
2012-01-22 00:00:00
2012-01-20 00:00:00
2012-01-18 00:00:00
2012-01-16 00:00:00
2012-01-14 00:00:00
2012-01-12 00:00:00
2012-01-10 00:00:00
2012-01-08 00:00:00
2012-01-06 00:00:00
2012-01-04 00:00:00
2012-01-02 00:00:00
2011-12-31 00:00:00
2011-12-29 00:00:00
Spreadsheet: louise_kitchen__23878__TRS
Sheet: Cornhusker

Project Cornhusker
Valuation Summary
Total Return SWAP |  |  | Realized (Income)/Loss | Equity
18831352 |  | Intitial fair value @ 6/30/00 |  | 4600000 | Initial funding (6/21/00)
1508468 |  | 9/30 fair value adjustment |  | -475000 | Distribution (6/30/00)
-6286168.2 |  | 9/30/00 floating payment from PonderosaPine |  | 384648 | 6/30/00 FV
3840790.64 |  | 9/30/00 fixed payment to KBC |  |  | Value at 6/30/00
 |  | Balance @ 10/1/00 |  | 21352 | 9/30 fair value adjustment
-4100000 |  | 12/5/00 principal repayment from PonderosaPine |  |  | Balance @ 10/1/00
1000000 |  | 12/28/00 principal repayment to KBC |  | -500000 | Distribution 12/1/00
-47514 |  | 12/29/00 principal refund from KBC |  | -250000 | Distribution
7687558 |  | 12/31/00 fair value adjustment |  | -229000 | 12/31/00 fair value adjustment
0 |  | Floating not received in 2000 |  |  | Balance @ 1/1/01
3867785.04 |  | 12/31/00 fixed payment to KBC
 |  | Balance @ 1/1/01
330000 |  | Principal repayment 1/3/01
-6441618.37 |  | 12/31/01 floating payment received 1/5/2001
 |  | Balance @ 1/5/01
Spreadsheet: 122050d1316586952-vlookup-from-conditional-indirect-data-validation-list-test2
Sheet: Vera

Vera |  | VeraColors
Meteor | 141 | [NAME] | 100
Muck | 142 | BB [NAME] | 101
My Space | 143 | [NAME] | 102
Nudje | 144 | [NAME] | 103
Off The Wall | 145 | MAAQ Mahogany / Aqua | 104
Old Chap | 146 | MS Mahogony Silk | 105
Oleg | 147 | RW Redwood | 106
P.Y.T. | 148 | VR  Vintage Red | 107
 |  | RDM Redwood Matte | 108
 |  | Zucchin/Sandcream | 109
 |  | AUCI Aubergine / Citron | 110
 |  | GTDB Granite & Dark Blue | 111
Spreadsheet: 52453d1252176548-look-up-on-multiple-sheets-help
Sheet: LY Min-Traffic

Store | Return this value
1509 | 0
189 | 0
751 | 0
880 | 1
1020 | 0
1314 | 1
1490 | 0
1593 | 1
631 | 0
79 | 1
210 | 1
334 | 1
953 | 0
1084 | 1
1096 | 1
1381 | 1
1595 | 1
1897 | 1
1008 | 0
336 | 0
490 | 1
701 | 1
875 | 1
925 | 0
1516 | 0
2111 | 1
135 | 1
139 | 1
155 | 0
42 | 0
568 | 0
934 | 1
1181 | 0
1427 | 0
1600 | 1
777 | 0
1117 | 0
1328 | 0
1399 | 0
1439 | 0
1830 | 0
1840 | 0
297 | 0
628 | 0
780 | 0
865 | 0
905 | 0
1266 | 0
1588 | 0
2151 | 1
Spreadsheet: louise_kitchen__22842__Hot List Update 06-18-01
Sheet: Offshore -50

Deal Description Sheet - 6/18/01
Production Offshore
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Bridge | Callon Petroleum | Deferred Volumetric Production payment on Medusa and other deepwater reserves. | 500000 | 2001-05-21 00:00:00 | 0 | 2001-08-01 00:00:00 | Working with Enron Energy Capital Resources on joint bridge financing proposal for Callon.  Callon Sr. Management presentation to Enron on May 22, 2001.  [NAME] spoke with Callon yesterday and their management is not interested in ECR's financing proposal.
[NAME] | [NAME] | Volumetric Production payment on McMoRan Offshore Reserves. | 500000 | 2001-06-03 00:00:00 | 0.1 | 2001-08-01 00:00:00 | Working with Enron Energy Capital Resources on a VPP proposal.  Waiting on additional reserve information.
Shallow-Water | VanKirk & Riles | Shallow-water used platform and gathering line sale & lease/financing business with small to mid-sized E&P independents. | 500000 | 2001-05-21 00:00:00 | 0.1 | 2001-09-01 00:00:00 | Target client list being updated; potential deals w/McMoran, ATP, [NAME].  Joint marketing to begin in late May.  Working on proposal for [NAME].  Working on HI52 proposal for Gryphon.  [NAME] is upbeat on the HI52 reserves.  [NAME] and [NAME] to structure and price.
Spreadsheet: 58310d1258577656-returning-value-based-on-ranges-overdue_sample
Sheet: Answer

Due Date | Weeks Overdue |  |  | 2009-11-17 00:00:00 | Lookup | Weeks Overdue | Days Overdue
2009-01-01 00:00:00 | 27-52 |  |  |  | 100 | >52 | 365+
2009-03-05 00:00:00 | 27-52 |  |  |  | 52 | 27-52 | 183-364
2009-06-08 00:00:00 | 13-26 |  |  |  | 26 | 13-26 | 85-182
2008-06-08 00:00:00 | >52 |  |  |  | 12 | 5-12 | 29-84
2009-11-01 00:00:00 | 2-4 |  |  |  | 2 | 2-4 | 14-28
2009-10-01 00:00:00 | 5-12 |  |  |  | 1 | <2 | <14
2009-09-26 00:00:00 | 5-12
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 6 - Table 1

Ambev results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 4Q10 | Scope |  |  | 4Q11 | Reported | Organic
Volume ('000 hl) | 48038.70816253767 | -310.264 | 0 | 417.0422355413762 | 48145.48639807903 | 0.002222754100299262 | 0.008737813328277628
Net revenue | 7455.344000000002 | -24.096 | 88.30869626091489 | 858.8843037390849 | 8378.441 | 0.1238168218663014 | 0.115577397462591
Net revenue/hl | 155.1945146979192 | 0.5040028295562422 | 1.834205091018425 | 16.49067244547822 | 174.0233950639721 | 0.1213243934729438 | 0.1059141262701374
[NAME] | -2452.421 | 76.31400000000001 | -31.6351299647112 | -129.6118700352888 | -2537.354 | 0.034632308237452 | 0.05296699144199187
[NAME]/hl | -51.05093566842596 | 1.267058534106546 | -0.6570736393261034 | -2.260853483154726 | -52.70180425680025 | 0.03233767543648214 | 0.0441053761260038
Gross profit | 5002.923000000003 | 52.218 | 56.67356629620369 | 729.2724337037961 | 5841.087 | 0.1675348591213572 | 0.1463163489277846
Gross margin | 0.6710519326807725 |  |  |  | 0.6971567860894408 | 260 | 180
SG&A excl. deprec.&amort. | -1743.738 | -0.9590000000000015 | -30.86406947405573 | -124.8439305259446 | -1900.405 | 0.08984549284353527 | 0.07155622467737642
SG&A deprec.&amort. | -187.373 | 41.69899999999999 | -3.021798761308178 | -3.115201238691813 | -151.811 | -0.189792552822445 | 0.01846460974140437
SG&A total | -1931.111 | 40.73999999999998 | -33.88586823536362 | -127.9591317646359 | -2052.216 | 0.06271260429876868 | 0.06687495029271621
Other operating income | 253.199 | -125.966 | 0.1846647028722985 | 193.1183352971278 | 320.5360000000001 | 0.2659449681870787 | 1.517832129220625
Normalized EBIT | 3325.011000000002 | -33.00800000000001 | 22.97236276371237 | 794.4316372362881 | 4109.407000000001 | 0.2359077909817435 | 0.248411961333919
Normalized EBIT margin | 0.4459902856259887 |  |  |  | 0.4904739437802332 | 440 | 510
Normalized EBITDA | 3822.003 | -136.617 | 32.31120694599498 | 788.4447930540043 | 4506.141999999999 | 0.1790001211406687 | 0.2139381853227869
Normalized EBITDA margin | 0.512652803143624 |  |  |  | 0.5378258317985408 | 250 | 440
Spreadsheet: 755582d1636973383-formulas-with-multiple-range-criteria-not-returning-result-sample1
Sheet: Sheet1

sales [NAME] | Int Date | Debit Amount | Cleaing Date | Remark | Days Calculation | 0.1 | 0.13 | 0.16
2021-07-04 00:00:00 |  | 10000 | 2021-06-30 00:00:00 | Advance Payment |  | Nil
2021-07-04 00:00:00 |  | 10000 | 2021-07-15 00:00:00 | Payment received after int date |  |  |  |  |  | Less than 15
2021-07-04 00:00:00 |  | 10000 | 2021-07-25 00:00:00 | Payment received after int date |  |  |  |  |  | > 15 <60
2021-07-04 00:00:00 |  | 10000 | 2021-09-25 00:00:00 | Payment received after int date |  |  |  |  |  | >61
Spreadsheet: 686400d1594589506-index-indirect-function-need-help-inventory
Sheet: InventoryAudit 

Category | Massage
Category | Item | Projection | Actual
1 |  |  |  |  |  |  |  |  |  | =[NAME]))
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Categories | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun
 | Massage
 | Golf
 | Food
 | Novelty
 | Reading
 | Clothing
 | Item | Beginning inventory | Total out | Total in | Ending | Actual | [NAME] | [NAME] | Turnover | Description
 | A1 | 35 |  |  |  |  | 25
 | A2 | 33 |  |  |  |  | 20
 | A3 | 48 |  |  |  |  | 15
 | A4 | 10 |  |  |  |  | 10
 | A5 | 52 |  |  |  |  | 30
 | A6 | 10 |  |  |  |  | 30
 | A7 | 22 |  |  |  |  | 30
 | A8 | 15 |  |  |  |  | 30
 | A9 | 20 |  |  |  |  | 30
 | A10 | 30 |  |  |  |  | 30
 | A11 | 22 |  |  |  |  | 30
 | A12 | 10 |  |  |  |  | 30
 | A13 | 23 |  |  |  |  | 30
 | A14 | 25 |  |  |  |  | 30
 | A15 | 12 |  |  |  |  | 30
 | A16 | 14 |  |  |  |  | 30
 | A17 | 16 |  |  |  |  | 30
 | A18 | 33 |  |  |  |  | 30
 | A19 | 27 |  |  |  |  | 30
 | A20 | 15 |  |  |  |  | 30
Spreadsheet: kate_symes__18439__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-09 00:00:00 |  | 127.81 | 1024 | 77.19 | 912
 | 2001-01-08 00:00:00 |  | 132.55 | 1024 | 76.1 | 912 | 127.42 | 1330 | 71.95 | 583
 | 2001-01-07 00:00:00 |  | 115 | 0 | 62.5 | 0 | 63.78 | 2249 | 57.2 | 1278
 | 2001-01-06 00:00:00 |  | 124.17 | 384 | 93.8 | 432 | 102.76 | 521 | 66.24 | 647
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528 | 129.45 | 1527 | 123.46 | 455
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
 | 2000-12-12 00:00:00 |  | 342.11 | 1328 | 239.28 | 1064 | 334.23 | 1940 | 165.94 | 1277
 | 2000-12-11 00:00:00 |  | 447.65 | 544 | 245.19 | 832 | 244.01 | 1470 | 147.46 | 1240
 | 2000-12-10 00:00:00 |  | 297.1 | 992 | 244.42 | 1504 | 200.84 | 712 | 127.41 | 600
Spreadsheet: 747373d1631442920-pls-help-me-find-the-right-formula-for-this-complicated-worksheet-book2
Sheet: Sheet1

LOOKUP TABLE 1 |  |  |  |  | RESULT TABLE
ID | RANK | REPORT TO: |  |  | ID | AMT | 1ST | 2ND | 3RD
A00007 | AA | A00011 |  |  | A00007 | 10000
A00011 | BB | A00009 |  |  | A00009 | 15000
A00009 | CC | A00004 |  |  | A00004 | 25000
A00004 | DD |  |  |  | A00011 | 50000
LOOKUP TABLE 2
BB | 0.1
CC | 0.15
DD | 0.2
Spreadsheet: 8a000d94-cc81-44f1-ac75-ba3b164cff19
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Telekommunikasjon
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Arech Are Christoffer Jenssen | Verftsgata 8 | 9008 | Tromsø | 77 67 50 12
[NAME] | [NAME] | 9046 | Oteren | 902 51 044
Bredbåndsfylket Troms AS | Terminalg. 68 | 9019 | Tromsø | 77 78 87 00
Broadnet AS | Fiolvegen 10 | 9016 | Tromsø | 08150
Bynett | Evjenvegen 46 | 9024 | Tomasjord | 77 21 07 00
ComPartner AS | Tore Hunds g 5 | 9404 | Harstad | 77 01 31 00
Kongsberg Satellite Services AS | Prestvannvegen 38 | 9011 | Tromsø | 77 60 02 50
Mobicom AS | Kvaløyvegen 156 | 9013 | Tromsø | 400 00 600
Mobil-Systemer DA | Ringveien 99 | 9018 | Tromsø | 400 06 299
[NAME] | [NAME] | 9350 | Sjøvegan | 480 46 796
[NAME], Troms Telenor Maritim Radio | [NAME] gate 22 | 9008 | Tromsø | 917 52 003
SnapTV AS | Skippergata 47 | 9008 | Tromsø | 473 97 482
[NAME] | Skolegata 4A | 9300 | Finnsnes | 952 71 699
[NAME] | [NAME] gate 22 | 9008 | Tromsø | 77 67 27 13
Telenor Norge AS avd Bardu | Fogd Holmboes gate 45 | 9360 | Bardu | 810 77 000
[NAME] avd Finnsnes | [NAME] vei 6 | 9300 | Finnsnes | 810 77 000
[NAME] avd Tromsø | Sykehusveien 23 | 9019 | Tromsø | 810 77 000
Telering Bedrift Finnsnes | Sjøgata 32 | 9300 | Finnsnes | 924 02 360
Telering Bedrift Tromsø | Stakkevollvegen 96 | 9010 | Tromsø | 464 52 000
Telesentrum AS | 301 | 9253 | Tromsø | 77 61 10 00
Tranøy Telecom AS | Vangsvik | 9304 | Vangsvik | 948 72 722
Troms Kraft Fiber AS | Evjenvegen 34 |  |  | 04925
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 101344d1299506786-replicating-chart-taken-from-word-doc-766998b
Sheet: Sheet1

 |  |  |  |  |  |  |  | A | B | C | D | E | F | G |  | [NAME] |  | Best | Cheapest
 |  |  |  |  |  |  | Price Score | 105 | 110 | 120 | 115 | 116 | 108 | 119 |  | 80 |  | 130
 |  |  |  |  |  |  | Non Price Score | 80.5 | 89 | 82 | 85 | 82 | 85 | 82.5 |  | 20 |  | 100
Spreadsheet: 685788d1594198978-split-5-parameters-separated-by-and-into-series-of-columns-pq-5-parameter-test-aligw
Sheet: Input

Product | 1 | 2 | 3 | 4 | 5 | 6
101 | 0219A&1&January&PC&4 | 0219B&3&February&PC&2 | 0219C&2&March&PM&2 | 0219C&2&March&PM&2 | 0219C&2&March&PM&2 | 0219A&1&January&PC&4
102 | 0220A&1&January&PC&4 | 0220B&3&February&PC&2 | 0220C&2&March&PM&2 | 0220C&2&March&PM&2 | 0220C&2&March&PM&2 | 0220A&1&January&PC&4
103 | 0221A&1&January&PC&4 | 0221B&3&February&PC&2 | 0221C&2&March&PM&2 | 0221C&2&March&PM&2 | 0221C&2&March&PM&2 | 0221A&1&January&PC&4
Spreadsheet: 76848d1277323325-removing-text-from-time-timequestion
Sheet: Data

Agent Name | Extn |  | [NAME] |  | Logout Time | Logout Date | [NAME] | Skill 1 | Skill 2 | Skill 3 | Skill 4
Smith, Jill | 7651 |  | 5:01PM |  | 6:05PM | 2010-06-01 00:00:00 | 0 | 11 | 2 | 3 | 1
Smith, Jill | 7650 |  | 6:06PM |  | 8:40PM | 2010-06-01 00:00:00 | 0 | 11 | 2 | 3 | 1
Smith, Jill | 7650 |  | 8:40PM |  | [NAME] | 2010-06-01 00:00:00 | 0 | 11 | 2 | 3 | 1
Smith, Jill | 7650 |  | 9:37PM |  | 10:06PM | 2010-06-01 00:00:00 | 0 | 11 | 2 | 3 | 1
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Moss

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 879009d1726427475-auto-number-generate-with-conditions-tps_srno_1509-tpsdas-
Sheet: Data_Entry

Data Entry Area
 |  |  |  |  |  |  |  |  |  | Calculated Value |  |  |  |  |  |  |  |  | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(R6="","",AGGREGATE(15,6,tbl_Data_1[Rank]/(tbl_Data_1[Attribute]="Return Dt")/(tbl_Data_1[Deno]=A6),1))
Deno | Colour | Column12 | Column13 | Column14 | Column5 | Column4 | Column3 | [NAME] | Column1 | [NAME] | Column9 | Column10 | Column11 | Column8 | Column6 | Column2 | Return Dt | Column7 | Return SrNo |  | Actual Return SrNo
111 | A |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(R6="","",AGGREGATE(15,6,tbl_Data_1[Rank]/(tbl_Data_1[Attribute]="Return Dt")/(tbl_Data_1[Value]=R6),1))
222 | B |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | 4 | Since, A7 is changed even though R6 & R7 is same
111 | C |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 6
444 | C |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 7
444 | D |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 7
555 | A |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 8 | Since, A11 is changed even though R8,R9, R10,R11 is same DATE
 |  |  |  |  |  |  |  |  |  | This is OK |  |  |  |  |  |  |  |  | This is Not OK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Can I cange the numbering pattern from a particular point , say start no is from 15 onwaards