tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106477d1303760706-sumif-product-and-vlookup-sumproduct-and-vlookup
Sheet: Sheet1

 | Zero | 0
 | Poor | 1
 | Fair | 2
 | Good | 3
 | Excellent | 5
 | Supplier 1 | Supplier 2 | Supplier 3
Criteria 1 | Zero | Poor | Poor
Criteria 1 | Poor | Zero | Fair
Criteria 1 | Fair | Poor | Good
Criteria 1 | Good | Fair | Excellent
Criteria 1 | Excellent | Good | Zero
[NAME] | Zero | Excellent | Poor
[NAME] | Poor | Zero | Fair
[NAME] | Excellent | Poor | Excellent
[NAME] | Good | Fair | Good
[NAME] | Excellent | Good | Excellent
Criteria 3 | Zero | Excellent | Zero
Criteria 3 | Poor | Zero | Poor
[NAME] | Fair | Poor | Excellent
[NAME] | Good | Fair | Good
[NAME] | Excellent | Good | Excellent
Criteria 1
[NAME]
Criteria 3
[NAME]
Spreadsheet: 246a612d-6f2a-4c3b-b67b-ba82c423890c
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Everts | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Ballard | Dr. [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Becton | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Martin | Harold | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Saunders-White | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Woodson | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Ponder | Anne | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Folt | Carol | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Dubois | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | Bierman | M. | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Belcher | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Reaves | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | [NAME] | J. | [EMAIL] | [PHONE] | [PHONE] | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 135286d1325896788-match-values-in-2-columns-and-return-the-sum-im-data
Sheet: Productivity Table

 |  | YTD | [NAME] | SI Clarity Projects |  | EU Projects | VE Projects | Co-Leading & Scoping
CIS Billing & Clarity | Customer Satisfaction & Niku | FY12 TEAM TARGET  (All counted from From 1/10/11) | > 88.5% | SI Clarity Projects | >25 New Complex Projects | > 7 % Effort to be Noted | > 7 % Effort to be Noted | Ongoing | FY12
adam b | b, adam | adam b | #N/A | #N/A | #N/A | 2 | 0 | 3
 |  | Effort % |  |  |  |  |  |  | 8.5
[NAME] | s, [NAME] | [NAME] | #N/A | #N/A | #N/A | 2 | 2
 |  | Effort % |  |  |  |  |  |  | 2
[NAME] | M, [NAME] | [NAME] | #N/A | #N/A | #N/A | 1 | 2
 |  | Effort % |  |  |  |  |  |  | 0
Spreadsheet: ccd9dc99-376a-42f2-a1e6-17736dd27b41
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
9886 | Test | 9886 | [NAME] with Periodic Acid-Schiff Stain | [NAME],ST | Includes pathology consultation charged separately. | H & E Slide: HE |  |  |  | Varies | Container/Tube: Sterile container with 10% neutral buffered formalin or tissue embedded in paraffin  [NAME]: Tissue Collection Instructions: Include 1 hematoxylin-and-eosin slide. Note: A pathology/diagnostic report and a brief history are required. |  | Specimens other than	Paraffin-embedded tissue block or tissue in formalin Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88313 |  |  |  |  | Rochester
9886 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9886 | Result | 9886 | [NAME],ST | [NAME],ST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10768-0
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 94079 | 94300
2 | 93999 | 93800
3 | 94001 | 93800
4 | 78477 | 78052
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
2002-02-28 00:00:00 |  |  | 21543
2002-03-04 00:00:00
CBS Volume
 |  |  | -45540
Spreadsheet: 00153a45-28df-4caf-a3f0-5baf87861f2f
Sheet: Sheet1

Crystal Screen (HR2-110) - Scoring Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Sample: |  | 1 [NAME] |  | 6 Needles 1D
Buffer: |  | 2 Phase Separation |  | 7 Plates 2D
Reservoir Volume: |  | 3 Regular Granular Precipitate |  | 8 Xtal <0.2 mm
[NAME]: |  | 4 Birefringent Precipitate |  | 9 Xtal >0.2 mm
Temperature: |  | 5 Spherulites
[NAME]:
Temperature: |  | Date | Date | Date
1.   30% MPD, 0.1 M Na Acetate pH 4.6, 0.02 M Calcium Chloride
2.   0.4 M K, Na Tartrate
3.   0.4 M Ammonium  Phosphate
4.   2.0 M Ammonium Sulfate, 0.1 M Tris HCl pH 8.5
5.   30% MPD, 0.1 M Na Hepes pH 7.5, 0.2 M Sodium Citrate
6.   30% PEG 4000, 0.1 M Tris HCl pH  8.5, 0.2 M Magnesium Chloride
7.   1.4 M Sodium Acetate, 0.1 M Na Cacodylate pH 6.5
8.   30% iso-Propanol, 0.1 M Na Cacodylate pH 6.5, 0.2 M Sodium Citrate
9.   30% PEG 4000, 0.1 M Na Citrate pH 5.6, 0.2 M Ammonium Acetate
10. 30% PEG 4000, 0.1 M Na Acetate pH 4.6, 0.2 M Ammonium Acetate
11. 1.0 M Ammonium Phosphate, 0.1 M Na Citrate pH 5.6
12. 30% iso-Propanol, 0.1 M Na Hepes pH 7.5, 0.2 M Magnesium Chloride
13. 30% PEG 400, 0.1 M Tris HCl pH 8.5, 0.2 M Sodium Citrate
14. 28% PEG 400, 0.1 M Na Hepes pH 7.5, 0.2 M Calcium Chloride
15. 30% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Ammonium Sulfate
16. 1.5 M Lithium Sulfate, 0.1 M Na Hepes pH 7.5
17. 30% PEG 4000, 0.1 M Tris HCl pH 8.5, 0.2 M Lithium Sulfate
18. 20% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Magnesium Acetate
19. 30% iso-Propanol, 0.1 M Tris HCl pH 8.5, 0.2 M Ammonium Acetate
20. 25% PEG 4000, 0.1 M Na Acetate pH 4.6, 0.2 M Ammonium Sulfate
21. 30% MPD, 0.1 M Na Cacodylate pH 6.5, 0.2 M Magnesium Acetate
22. 30% PEG 4000, 0.1 M Tris HCl pH 8.5, 0.2 M Sodium Acetate
23. 30% PEG 400, 0.1 M Na Hepes pH 7.5, 0.2 M Magnesium Chloride
24. 20% iso-Propanol, 0.1 M Na Acetate  pH 4.6, 0.2 M Calcium Chloride
25. 1.0 M Sodium Acetate, 0.1 M Imidazole pH 6.5
26. 30% MPD, 0.1 M Na Citrate pH 5.6, 0.2 M Ammonium Acetate
27. 20% iso-Propanol, 0.1 M Na Hepes pH 7.5, 0.2 M Sodium Citrate
28. 30% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Sodium Acetate
29. 0.8 M K, Na Tartrate, 0.1 M Na Hepes pH 7.5
30. 30% PEG 8000, 0.2 M Ammonium Sulfate
31. 30% PEG 4000, 0.2 M Ammonium Sulfate
32. 2.0 M Ammonium Sulfate
33. 4.0 M Sodium Formate
34. 2.0 M Sodium Formate, 0.1 M Na Acetate pH 4.6
35. 1.6 M Na, K Phosphate, 0.1 M Na Hepes pH 7.5
36. 8% PEG 8000, 0.1 M Tris HCl pH 8.5
37. 8% PEG 4000, 0.1 M Na Acetate pH 4.6
38. 1.4 M Sodium Citrate, 0.1 M Na Hepes pH 7.5
39. 2% PEG 400, 0.1 M Na Hepes pH 7.5, 2.0 M Ammonium Sulfate
40  20% iso-Propanol, 0.1 M Na Citrate pH 5.6, 20% PEG 4000
41. 10% iso-Propanol, 0.1 M Na Hepes pH 7.5, 20% PEG 4000
42. 20% PEG 8000, 0.05 M Potassium Phosphate
43. 30% PEG 1500
44. 0.2 M Magnesium Formate
45. 18% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Zinc Acetate
46. 18% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Calcium Acetate
47. 2.0 M Ammonium Sulfate, 0.1 M Sodium Acetate pH 4.6
48. 2.0 M Ammonium Phosphate, 0.1 M Tris HCl pH 8.5
49. 2% PEG 8000, 1.0 M Lithium Sulfate
50. 15% PEG 8000, 0.5 M Lithium Sulfate
Spreadsheet: 853973d1703930171-calculating-annual-totals-of-various-cells-columns-annualtotals
Sheet: Annual Summary

 | YEAR | 2023 |  | Manually Calculated Results for 2023
 | [NAME] |  |  | 12405.48
 | Delays |  |  | 644
 | Moves |  |  | 512
 |  | Number of instances by year | [NAME]
 | EMU
 | DL
 | DLR
 | DMU
 | EL
 | EDL
 | MON
 | Misc
 | SL
 | Tram
 | Tube
 | TOC | Number of Instances by year | [NAME] | Delays
Spreadsheet: 130100d1322064681-converting-euro-number-format-using-substitute-command-again-forum-query-euro-number-format
Sheet: Forum Query

[NAME]: 1
bis Profitcenter: 7
 |  | [NAME] |  |  | [NAME] |  | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 |  | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00
Suchname B ezeichnung | Menge | Wert | DB % | Menge | Wert | DB %
 | qty | sal val | va % | qty | sal val |  | QTY | SAL VAL | VA % | VA AMOUNT |  | QTY | SAL VAL | VA % | VA AMOUNT
10834 PPG Österreich | 10.12 | 33.255 | 29,55 | 16.095 | 45.032 | 21,34
10894 Heiche | 0 | 0 | 0,00 | 130 | 1.787 | 54,67
10904 Klil (See) | 11.26 | 46.383 | 42,11 | 10.958 | 45.305 | 49,06
10906 TK Bilstein | 2.25 | 8.588 | 59,55 | 2.25 | 8.423 | 64,63
10917 Soditek (Kuhn) | 552 | 4.358 | 81,99 | 0 | 0 | 0,00
10952 Krauss Maffei Technologien Munchen | 242 | 0 | 0,00 | 0 | 0 | 0,00
10970 Keim | 0 | 0 | 0,00 | 135 | 1.865 | 79,24
11000 Abgesetzter Bereich; Ummendorf | 28 | 132 | 43,19 | 0 | 0 | 0,00
11006 Liebherr, Ehingen | 180 | 0 | 0,00 | 0 | 0 | 0,00
11007 Greif CZ | 6.613 | 19.005 | 29,27 | 5.534 | 19.729 | 34,31
 |  |  |  | should be 10120 |  | should be 11260
 |  |  |  |  |  | should be 2250
 |  |  |  |  |  |  | ok
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 112130 | 111797
2 | 173829 | 170842
3 | 182826 | 181995
4 | 182617 | 196995
5 | 184803 | 187906
6 | 178524 | 190070
7 | 184367 | 184695
8 | 53 | 3200
9
10 | 141417 | 146003
11 | 145363 | 145036
12 | 149390 | 148895
13 | 133334 | 144781
14 | 148615 | 148357
15 | 164087 | 163895
16 | 163221 | 163495
17 | 141196 | 140873
18 | 182896 | 183420
19 | 166800 | 177643
20 | 162943 | 161098
21 | 167844 | 168884
22 | 205435 | 218491
23 | 175183 | 179085
24 | 185872 | 185799
25 | 185757 | 186495
26 | 172041 | 171495
27 | 172017 | 171620
28 | 167743 | 167807
29 | 171612 | 171620
30 | 180555 | 183355
31 | 173770 | 186444
2001-04-30 00:00:00 |  |  | 0
2001-05-31 00:00:00
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Patrick Brown

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Not only to make sufficiently attractive but also to make teaching in Vermont competitive with teaching in other
States. This will greatly help not only with recruiting but with retention.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
I agree because, simplifying [NAME] is different from licensing where the bar should not be lowered.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | P.O. Box 5608 Burlington, Vermont 05402 | State Senate | No |  | Chittenden
Spreadsheet: 735422d1622979597-index-match-formula-to-conditionally-compile-missing-data-index-match-formula-to-pull-missing-data-example
Sheet: FCST

Concat | Revenue Type | Product | Customer
 | Issue Fee | Product A | Customer D
 | Saleable Item | Product B | Customer F
 | Saleable Item | Product C | Customer A
 | Issue Fee | Product A | Customer B
 | Saleable Item | Product A | Customer Y
 | Saleable Item | Product A | Customer X
 | Issue Fee | Product A | Customer G
 | Issue Fee | Product A | Customer H
 | Issue Fee | Product A | Customer I
 | Saleable Item | Product A | Customer K
 | Issue Fee | Product A | Customer A
Spreadsheet: 118834d1314037127-editing-collapsed-rows-examplexls
Sheet: Sheet2

UNIQUE |  | FD_NAME | MUNICIPALITY | COUNTY | IN_DATE | IN_LOSSTOTAL | IN_NONFATALFS | IN_FATALFS | IN_NONFATALOTHER | IN_FATALOTHER
1 |  | Fire dept 1 | Cityville | County 1 | 2007-01-07 00:00:00 | 0 | 0 | 0 | 0 | 0
1248 |  | Fire dept 2 | Cityville | County 1 | 2009-05-24 00:00:00 | 0 | 0 | 0 | 0 | 0
9145 |  | Fire dept 3 | Towntown | County 2 | 2010-04-08 00:00:00 | 0 | 0 | 0 | 0 | 0
15659 |  | Fire dept 4 | Towntown | County 2 | 2008-03-11 00:00:00 | 0 | 0 | 0 | 0 | 0
20478 |  | Fire dept 5 | Imaginary City | County 2 | 2007-08-21 00:00:00 | 0 | 0 | 0 | 0 | 0
21207 |  | Fire dept 6 | Faketown | County 3 | 2009-12-23 00:00:00 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 847379d1698333427-formula-to-fetch-data-but-also-check-for-duplicate-keys-and-act-based-on-outcome-mergedoc_example-sheet
Sheet: Results

MeldingKey | MeldingMachineKey | Merged tekst | Example how it should like in C | Chars
626203 | 267035 | < [NAME] here > | InterneMemo - 15/10/2021 [NAME] is [NAME]   WerkVerricht - 15/10/2021 Deze zou je dan moeten verwachten als tweede  Opdrachtomschrijving - 15/10/2021 En dit is de laatste | -
628000 | 310575
628002 | 143498
628389 | 302985
628576 | 302985
632171 | 302985
634298 | 302985
635125 | 91562
659942 | 6948
660376 | 305807 |  | InterneMemo - 07/04/2022 svp retourdoos sturen naar bovenstaand adres  WerkVerricht - 07/04/2022 Succesvol ingepakt en teruggestuurd  Opdrachtomschrijving - 07/04/2022 Nalopen van randapparatuur  InterneMemo - 12/04/2022 Dit keer zonder incident opgelost  WerkVerricht - 12/04/2022 Installatie voltooid, geen bijzonderheden  Opdrachtomschrijving - 12/04/2022 [NAME]
660377 | 305807 |  | InterneMemo - 12/04/2022 Dit keer zonder incident opgelost  WerkVerricht - 12/04/2022 Installatie voltooid, geen bijzonderheden  Opdrachtomschrijving - 12/04/2022 [NAME]  InterneMemo - 07/04/2022 svp retourdoos sturen naar bovenstaand adres  WerkVerricht - 07/04/2022 Succesvol ingepakt en teruggestuurd  Opdrachtomschrijving - 07/04/2022 Nalopen van randapparatuur
660379 | 7409
660702 | 1636
660729 | 318992
660739 | 247760
661009 | 301825
661094 | 316374
661377 | 320086
661417 | 144832
663060 | 125694 |  | InterneMemo - 22/04/2022 Testing again  Opdrachtomschrijving - 22/04/2022 svp retourdoos sturen naar: Mw. [NAME]
663120 | 307943
663166 | 307943
etc.
Spreadsheet: jonathan_mckay__16924__Sierras West - Buy
Sheet: Enron Direct Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Sierras West Condominium s |  |  |  |  | Deal Date: |  |  |  |  |  |  | 3 | March
Originator: |  |  |  |  |  | Deal ID #: |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: |  |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  | 6 | June
Deal End Date: |  |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Sell |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total
 | January |  | 1945
 | February |  | 1406
 | March |  | 1442
 | April |  | 1139
 | May |  | 809
 | June |  | 711
 | July |  | 574
 | August |  | 418
 | September |  | 758
 | October |  | 1213
 | November |  | 1673
 | December |  | 1926
 | TOTAL:
Spreadsheet: 232799d1367523662-calculating-overtime-over-several-jobs-time-sheet-and-job-costing
Sheet: Master Job Sheet

Job Name/Number | Regular Hours | OT Hours | Total Hours
Spreadsheet: 56343d1256542620-if-statement-expiry-date
Sheet: Sheet2

Item Code | Item Description | UOM | [NAME] | [NAME]
050-00008 | NIDO MILK POWDER 2.5KG | Tin | 2010-01-10 00:00:00 | we have less than 90 days!!!
050-00009 | SUGAR (1 PKTX 2KGS),1X2KGS | Pack | 2011-01-11 00:00:00 | we have more than 90 days
050-00010 | COFFEE MATE 16 OZ (400GRAMS) ,CARNATION | Bottle | 2009-12-12 00:00:00 | we have less than 90 days!!!
050-00006 | NESCAFE COFFEE (RED MUG) BOTTLE (200Grams) | Bottle | 2009-10-13 00:00:00 | we have less than 90 days!!!
050-00012 | NESCAFE GOLD BLEND COFFEE 200GRAM,GOLD BLEND  200GM | Bottle | 2009-11-14 00:00:00 | we have less than 90 days!!!
050-00004 | BROOKBOND TEA,LOOSE TEA | Pack | 2009-09-15 00:00:00 | we have less than 90 days!!!
050-00005 | TEA BAGS (1PKTX100NOS ),LIPTON TEA | Pack | 2010-01-16 00:00:00 | we have less than 90 days!!!
050-00014 | TWINNINGS BLACK CURRANT TEA BAGS,BLACK CURRANT FOR I.T DEPT | Pack | 2010-01-17 00:00:00 | we have less than 90 days!!!
050-00015 | TWINNINGS CAMMOMILE TEA BAGS,CAMMOMILE FOR I.T DEPT | Pack | 2010-01-18 00:00:00 | we have less than 90 days!!!
050-00016 | TWINNINGS DARJEELING TEA BAGS,DARJEELING FOR I.T DEPT | Pack | 2010-01-19 00:00:00 | we have less than 90 days!!!
050-00017 | TWINNINGS LEMON & GINGER TEA BAGS,LEMON & GINGER FOR I.T DEPT | Pack | 2010-01-01 00:00:00 | we have less than 90 days!!!
050-00018 | TWINNINGS GREEN MINT TEA BAGS,GREEN MINT | Pack | 2010-01-01 00:00:00 | we have less than 90 days!!!
050-00019 | TWINNING PURE PEPPERMINT TEA BAGS,PEPPERMINT FOR I.T DEPT | Pack | 2010-01-22 00:00:00 | we have less than 90 days!!!
050-00002 | SAFFRON  TAJ MAHAL 1X4GMS,1X4GRAMS | Pack | 2010-01-23 00:00:00 | we have less than 90 days!!!
050-00007 | RAINBOW MILK 160ML,1X160ML | Tin | 2010-01-24 00:00:00 | we have less than 90 days!!!
Spreadsheet: 186441d1350043243-how-to-get-text-below-in-a-new-colmn-eks-excel
Sheet: Ark1

Date | Text
10122012 | I`m walking | and talking | and singing
 | and talking
 | and singing
10222012 | I`m walking
 | and fishing
10312012 | I`m flying | and singing | and hoping | for peace
 | and singing
 | and hoping
 | for peace
I also want this
Date | Text | Result
10122012 | I`m walking | I`m walking and talking and singing
 | and talking
 | and singing
10222012 | I`m walking | I`m walking and fishing
 | and fishing
10312012 | I`m flying | I`m flying and singing and hoping for peace
 | and singing
 | and hoping
 | for peace
Spreadsheet: 542074d1507706459-return-total-amount-values-based-on-multiple-criteria-reporting
Sheet: FORECAST- CONSTR.

 |  |  | Type of Claim | Base | Frame | [NAME] | Fix | PCI | Total
 |  |  | Forecasted Percentage of Return | 0.15 | 0.25 | 0.3 | 0.15 | 0.1
 |  |  | Forecasted Days of Return | 28 | 21 | 49 | 28 | 56
Job Number | Client Name | Total Claim | Start Date | Base | Frame | [NAME] | Fix | PCI | 2017-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-09-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
24163 | B | 696252
24169 | C | 358927
24188 | D | 485170
24191 | E | 504204
24200 | F | 448000
24201 | G | 334000
24203 | H | 645601
24205 | I | 557671
24206 | J | 848123
24210 | K | 525434
24213 | L | 700769
24218 | M | 508167.18
24219 | N | 465649
24221 | O | 634908
24222 | P | 641321
24223 | Q | 412575
24225 | R | 489615
24226 | S | 417310
24228 | T | 540652
24233 | U | 474915
24234 | V | 463928
24235 | W | 835198
24239 | X | 498279
24240 | Y | 426051
24242 | Z | 587991
24243 | AA | 560651
24247 | BB | 540329
24248 | CC | 502112
24249 | DD | 501327
24250 | EE | 509100
24251 | FF | 662899
24253 | GG | 563417
24254 | HH | 484797
24256 | II | 452923
24258 | JJ | 750182
24260 | KK | 458232
24263 | LL | 578932
24268 | MM | 362138
24273 | NN | 569231
24275 | OO | 489013
24277 | PP | 456576
24281 | QQ | 1142285
24283 | RR | 550678
24285 | SS | 661425
24287 | TT | 280255
24288 | UU | 456765
24289 | VV | 641016
24292 | WW | 420479
24297 | XX | 692233
24298 | YY | 593172
24304 | ZZ | 694689
24305 | AAA | 553986
TOTALS
Spreadsheet: 98355d1297284313-i-have-a-drop-down-list-that-i-want-to-use-to-lookup-text-values-in-another-sheet-copy-of-example-2
Sheet: Sheet 1

Group leader | NB - Neelima Bhaduri | M.O057C.01.A.0008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WBS |  | Oppdragsledere
Oppdatert |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.01.A.0008 |  | AJO - Are Johan Olsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.01.A.0008.B |  | AK - Anders Kjøling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.7M.A.0029 |  | FD - Faisal Dahman
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GD - Geir Dahle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GSL - Grethe Sem Larsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HB - Hallstein Bringsvor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JA - Jone Alsvik
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JL - Jørgen Lea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JS - Jadhav Suryabhan
 | jan | feb | [NAME] | apr | mai | jun | jul | aug | sep | okt | Nov | Des |  |  |  |  |  |  |  |  |  |  |  |  |  | JSV - Jan Sverre Vea
Estiminert cost, periodic | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KN - Kjetil Nådland
Accumulated, actual cost | 64095.9 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KR - [NAME]
Accumulated, actual profit | 110634 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KRF - Kjell Rune Framvik
[NAME] omsetning, akkum | 630325.5 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MA - Morten Andreassen
EBITDA mål | 69335.80500000001 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MH - Mike Hooker
EBITDA faktisk | 56729.295 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MM - Mansi Mantri
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB - Neelima Bhaduri
EBITDA margin mål % | 0.11 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | RHA - [NAME]
EBITDA margin faktisk % | 0.09 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | SH - Stein Haugland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAK - [NAME] Kleveland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WS - [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA - Anita Albriktsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ÅS - Åge Sjøveian