Welcome Guest
Log In | Register )
You last visited January 20, 2017, 5:13 pm
All times shown are
Eastern Time (GMT-5:00)

MS Excel, pasting tables into Lotterypost threads.

Topic closed. 14 replies. Last post 4 years ago by LottoBoner.

Page 1 of 1
11
PrintE-mailLink
SergeM's avatar - slow icon.png
Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
Posted: December 9, 2012, 12:00 pm - IP Logged

Select at range in Excel and paste it into the message box. You loose the layout/format.

123456789101112right
6891012131416171921249, 4, 5, 6
89101213141718192021229, 6, 5, 5
458910121314151719217, 6, 7, 5
6891013141517181920248, 4, 5, 7
5891013141516171821248, 4, 5, 6
1456891013141517246, 5, 6, 6
568910121315161718199, 6, 7, 6
68910131617182021222410, 4, 4, 6
6891012131415161820218, 3, 6, 6

In order to keep some layout, use the conditional format in MS Excel.

123456789101112right
6891012131416171921249, 4, 5, 6
89101213141718192021229, 6, 5, 5
458910121314151719217, 6, 7, 5
6891013141517181920248, 4, 5, 7
5891013141516171821248, 4, 5, 6
1456891013141517246, 5, 6, 6
568910121315161718199, 6, 7, 6
68910131617182021222410, 4, 4, 6
6891012131415161820218, 3, 6, 6

To center the content, you need to select the cell values with the cursor/mouse inside of the table and click on the center-button, under the message box. This way you don't loose the format.

123456789101112right
6891012131416171921249, 4, 5, 6
89101213141718192021229, 6, 5, 5
458910121314151719217, 6, 7, 5
6891013141517181920248, 4, 5, 7
5891013141516171821248, 4, 5, 6
1456891013141517246, 5, 6, 6
568910121315161718199, 6, 7, 6
68910131617182021222410, 4, 4, 6
6891012131415161820218, 3, 6, 6

I hope that this contribution was a help to all members who are posting tables or intend to do this.

Other tips:

  • Empty spaces can be filled with non breaking spaces to prevent cells from disappearing.
    Another option would be to use the conditional format again. For this you can put a "-" and give the font the background-color.
  • Use the -button to check the spelling.
  • Condition conditional format for formulas: =TRUE.
    JADELottery's avatar - YingYangYong 01.PNG
    The Quantum Master
    West Concord, MN
    United States
    Member #21
    December 7, 2001
    3684 Posts
    Offline
    Posted: December 9, 2012, 12:26 pm - IP Logged

    Direct paste and modification in LP.

    IndexRegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8Wave 9Wave 10Wave 11Wave 12RemainderData
    12.3134585390.3843129560.173438840.0974553850.064609119-0.037528994-0.0014122140.002706310.0010515890.0004590510.0003352740.0002868920.0002369650.0005902873
    22.3148315250.3847801750.1729443470.0950066460.070851513-0.037237567-0.009274671-0.00188638-0.001968518-0.002023172-0.00172318-0.001316116-0.000960673-0.0020239292.98
    32.3162053260.3852535440.1724100920.092034620.07988103-0.028774646-0.0073345460.0058209050.0071771550.0056968120.0039783180.0026414480.00174670.0032632433.04
    42.3175799410.3857330890.1718372040.0885526530.090483816-0.017115377-0.033341147-0.020759723-0.01225532-0.007447255-0.004665318-0.002976101-0.0019473-0.0036791622.95
    52.3189553730.386218840.1712268910.0845773260.1010915840.0258749280.0031361580.0023762820.0033722650.003371940.0028089660.0021255240.0015489650.0033149593.11
    62.3203316210.3867108230.170580430.0801288540.1092528570.0649029460.0246749350.005008233-0.000982635-0.002388756-0.00228701-0.001794403-0.001319125-0.002818773.15
    72.3217086860.3872090670.1698991630.0752315860.1128539310.0847266790.0437685990.0200064840.0102710440.0056581540.0032744030.0019638410.001227310.0022010543.24
    82.3230865680.3877136010.1691844880.0699142780.1106475270.0657464830.007331487-0.003841851-0.003564164-0.002335082-0.001435347-0.000877605-0.000552106-0.0010182783.12
    92.3244652670.3882244550.1684378560.0642102720.1028987430.042243792-0.014759842-0.012937437-0.006692054-0.003201133-0.001514952-0.000720748-0.00034976-0.000304463.05
    102.3258447850.3887416570.1676607630.058157350.0905034290.033001105-0.0024443320.0004185530.0022428930.0020553050.0014408710.0009201830.0005746890.0008827483.07
    112.3272251220.3892652370.166854740.0517974170.0743941890.0250472980.0033386290.0024192150.0011757130.00016872-0.000272331-0.000365223-0.000323699-0.0007250283.04

     

    Passing through our old Microsoft FrontPage program.

    IndexRegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8Wave 9Wave 10Wave 11Wave 12RemainderData
    12.3134585390.3843129560.173438840.0974553850.064609119-0.037528994-0.0014122140.002706310.0010515890.0004590510.0003352740.0002868920.0002369650.0005902873
    22.3148315250.3847801750.1729443470.0950066460.070851513-0.037237567-0.009274671-0.00188638-0.001968518-0.002023172-0.00172318-0.001316116-0.000960673-0.0020239292.98
    32.3162053260.3852535440.1724100920.092034620.07988103-0.028774646-0.0073345460.0058209050.0071771550.0056968120.0039783180.0026414480.00174670.0032632433.04
    42.3175799410.3857330890.1718372040.0885526530.090483816-0.017115377-0.033341147-0.020759723-0.01225532-0.007447255-0.004665318-0.002976101-0.0019473-0.0036791622.95
    52.3189553730.386218840.1712268910.0845773260.1010915840.0258749280.0031361580.0023762820.0033722650.003371940.0028089660.0021255240.0015489650.0033149593.11
    62.3203316210.3867108230.170580430.0801288540.1092528570.0649029460.0246749350.005008233-0.000982635-0.002388756-0.00228701-0.001794403-0.001319125-0.002818773.15
    72.3217086860.3872090670.1698991630.0752315860.1128539310.0847266790.0437685990.0200064840.0102710440.0056581540.0032744030.0019638410.001227310.0022010543.24
    82.3230865680.3877136010.1691844880.0699142780.1106475270.0657464830.007331487-0.003841851-0.003564164-0.002335082-0.001435347-0.000877605-0.000552106-0.0010182783.12
    92.3244652670.3882244550.1684378560.0642102720.1028987430.042243792-0.014759842-0.012937437-0.006692054-0.003201133-0.001514952-0.000720748-0.00034976-0.000304463.05
    102.3258447850.3887416570.1676607630.058157350.0905034290.033001105-0.0024443320.0004185530.0022428930.0020553050.0014408710.0009201830.0005746890.0008827483.07
    112.3272251220.3892652370.166854740.0517974170.0743941890.0250472980.0033386290.0024192150.0011757130.00016872-0.000272331-0.000365223-0.000323699-0.0007250283.04

     

    Passing through Microsoft Word

    Index

    Regression

    Wave 1

    Wave 2

    Wave 3

    Wave 4

    Wave 5

    Wave 6

    Wave 7

    Wave 8

    Wave 9

    Wave 10

    Wave 11

    Wave 12

    Remainder

    Data

    1

    2.313458539

    0.384312956

    0.17343884

    0.097455385

    0.064609119

    -0.037528994

    -0.001412214

    0.00270631

    0.001051589

    0.000459051

    0.000335274

    0.000286892

    0.000236965

    0.000590287

    3

    2

    2.314831525

    0.384780175

    0.172944347

    0.095006646

    0.070851513

    -0.037237567

    -0.009274671

    -0.00188638

    -0.001968518

    -0.002023172

    -0.00172318

    -0.001316116

    -0.000960673

    -0.002023929

    2.98

    3

    2.316205326

    0.385253544

    0.172410092

    0.09203462

    0.07988103

    -0.028774646

    -0.007334546

    0.005820905

    0.007177155

    0.005696812

    0.003978318

    0.002641448

    0.0017467

    0.003263243

    3.04

    4

    2.317579941

    0.385733089

    0.171837204

    0.088552653

    0.090483816

    -0.017115377

    -0.033341147

    -0.020759723

    -0.01225532

    -0.007447255

    -0.004665318

    -0.002976101

    -0.0019473

    -0.003679162

    2.95

    5

    2.318955373

    0.38621884

    0.171226891

    0.084577326

    0.101091584

    0.025874928

    0.003136158

    0.002376282

    0.003372265

    0.00337194

    0.002808966

    0.002125524

    0.001548965

    0.003314959

    3.11

    6

    2.320331621

    0.386710823

    0.17058043

    0.080128854

    0.109252857

    0.064902946

    0.024674935

    0.005008233

    -0.000982635

    -0.002388756

    -0.00228701

    -0.001794403

    -0.001319125

    -0.00281877

    3.15

    7

    2.321708686

    0.387209067

    0.169899163

    0.075231586

    0.112853931

    0.084726679

    0.043768599

    0.020006484

    0.010271044

    0.005658154

    0.003274403

    0.001963841

    0.00122731

    0.002201054

    3.24

    8

    2.323086568

    0.387713601

    0.169184488

    0.069914278

    0.110647527

    0.065746483

    0.007331487

    -0.003841851

    -0.003564164

    -0.002335082

    -0.001435347

    -0.000877605

    -0.000552106

    -0.001018278

    3.12

    9

    2.324465267

    0.388224455

    0.168437856

    0.064210272

    0.102898743

    0.042243792

    -0.014759842

    -0.012937437

    -0.006692054

    -0.003201133

    -0.001514952

    -0.000720748

    -0.00034976

    -0.00030446

    3.05

    10

    2.325844785

    0.388741657

    0.167660763

    0.05815735

    0.090503429

    0.033001105

    -0.002444332

    0.000418553

    0.002242893

    0.002055305

    0.001440871

    0.000920183

    0.000574689

    0.000882748

    3.07

    11

    2.327225122

    0.389265237

    0.16685474

    0.051797417

    0.074394189

    0.025047298

    0.003338629

    0.002419215

    0.001175713

    0.00016872

    -0.000272331

    -0.000365223

    -0.000323699

    -0.000725028

    3.04

     

    Passing through Microsoft Expression Web

    IndexRegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8Wave 9Wave 10Wave 11Wave 12RemainderData
    12.3134585390.3843129560.173438840.0974553850.064609119-0.037528994-0.0014122140.002706310.0010515890.0004590510.0003352740.0002868920.0002369650.0005902873
    22.3148315250.3847801750.1729443470.0950066460.070851513-0.037237567-0.009274671-0.00188638-0.001968518-0.002023172-0.00172318-0.001316116-0.000960673-0.0020239292.98
    32.3162053260.3852535440.1724100920.092034620.07988103-0.028774646-0.0073345460.0058209050.0071771550.0056968120.0039783180.0026414480.00174670.0032632433.04
    42.3175799410.3857330890.1718372040.0885526530.090483816-0.017115377-0.033341147-0.020759723-0.01225532-0.007447255-0.004665318-0.002976101-0.0019473-0.0036791622.95
    52.3189553730.386218840.1712268910.0845773260.1010915840.0258749280.0031361580.0023762820.0033722650.003371940.0028089660.0021255240.0015489650.0033149593.11
    62.3203316210.3867108230.170580430.0801288540.1092528570.0649029460.0246749350.005008233-0.000982635-0.002388756-0.00228701-0.001794403-0.001319125-0.002818773.15
    72.3217086860.3872090670.1698991630.0752315860.1128539310.0847266790.0437685990.0200064840.0102710440.0056581540.0032744030.0019638410.001227310.0022010543.24
    82.3230865680.3877136010.1691844880.0699142780.1106475270.0657464830.007331487-0.003841851-0.003564164-0.002335082-0.001435347-0.000877605-0.000552106-0.0010182783.12
    92.3244652670.3882244550.1684378560.0642102720.1028987430.042243792-0.014759842-0.012937437-0.006692054-0.003201133-0.001514952-0.000720748-0.00034976-0.000304463.05
    102.3258447850.3887416570.1676607630.058157350.0905034290.033001105-0.0024443320.0004185530.0022428930.0020553050.0014408710.0009201830.0005746890.0008827483.07
    112.3272251220.3892652370.166854740.0517974170.0743941890.0250472980.0033386290.0024192150.0011757130.00016872-0.000272331-0.000365223-0.000323699-0.0007250283.04

    Presented 'AS IS' and for Entertainment Purposes Only.
    Any gain or loss is your responsibility.
    Use at your own risk.

    Order is a Subset of Chaos
    Knowledge is Beyond Belief
    Wisdom is Not Censored
    Douglas Paul Smallish
    Jehocifer

      JKING's avatar - Kaleidoscope 3.gif

      United States
      Member #5599
      July 13, 2004
      1192 Posts
      Offline
      Posted: December 13, 2012, 11:23 am - IP Logged

      Select at range in Excel and paste it into the message box. You loose the layout/format.

      123456789101112right
      6891012131416171921249, 4, 5, 6
      89101213141718192021229, 6, 5, 5
      458910121314151719217, 6, 7, 5
      6891013141517181920248, 4, 5, 7
      5891013141516171821248, 4, 5, 6
      1456891013141517246, 5, 6, 6
      568910121315161718199, 6, 7, 6
      68910131617182021222410, 4, 4, 6
      6891012131415161820218, 3, 6, 6

      In order to keep some layout, use the conditional format in MS Excel.

      123456789101112right
      6891012131416171921249, 4, 5, 6
      89101213141718192021229, 6, 5, 5
      458910121314151719217, 6, 7, 5
      6891013141517181920248, 4, 5, 7
      5891013141516171821248, 4, 5, 6
      1456891013141517246, 5, 6, 6
      568910121315161718199, 6, 7, 6
      68910131617182021222410, 4, 4, 6
      6891012131415161820218, 3, 6, 6

      To center the content, you need to select the cell values with the cursor/mouse inside of the table and click on the center-button, under the message box. This way you don't loose the format.

      123456789101112right
      6891012131416171921249, 4, 5, 6
      89101213141718192021229, 6, 5, 5
      458910121314151719217, 6, 7, 5
      6891013141517181920248, 4, 5, 7
      5891013141516171821248, 4, 5, 6
      1456891013141517246, 5, 6, 6
      568910121315161718199, 6, 7, 6
      68910131617182021222410, 4, 4, 6
      6891012131415161820218, 3, 6, 6

      I hope that this contribution was a help to all members who are posting tables or intend to do this.

      Other tips:

      • Empty spaces can be filled with non breaking spaces to prevent cells from disappearing.
        Another option would be to use the conditional format again. For this you can put a "-" and give the font the background-color.
      • Use the -button to check the spelling.
      • Condition conditional format for formulas: =TRUE.

      I failed the class. *L*

      "conditional format"...

      Where is that in excel?

      Is there a step by step for us dumbos?

        SergeM's avatar - slow icon.png
        Economy class
        Belgium
        Member #123700
        February 27, 2012
        4035 Posts
        Offline
        Posted: December 13, 2012, 2:11 pm - IP Logged
          Avatar
          Florida
          United States
          Member #66575
          October 30, 2008
          3549 Posts
          Offline
          Posted: December 13, 2012, 2:13 pm - IP Logged

          Great Tip Serge

           

           

          Thanks

           

          Carlig

            SergeM's avatar - slow icon.png
            Economy class
            Belgium
            Member #123700
            February 27, 2012
            4035 Posts
            Offline
            Posted: December 13, 2012, 2:17 pm - IP Logged

            Like JADElottery showed, you can also copy the range and paste it in another program, then copy it again to paste it here.
            With copy paste special you can paste as image. You might also paste to MS Paint.

              JKING's avatar - Kaleidoscope 3.gif

              United States
              Member #5599
              July 13, 2004
              1192 Posts
              Offline
              Posted: December 15, 2012, 4:48 pm - IP Logged

               

               

               

                        FILL   IN RATE FOR 56 NUMBERS %           
                                             
               123456789101112131415161718192021222324252627282930
              0000000000000000000000000000000
              1000000000000000000000000000000
              2000000000000000000000000000000
              3000000000000000000000000000000
              4000000000000000000000000000000
              510000000000000000000000000000000
              6000000000000000000000000000000
              7000000000000000000000000000000
              8020000000000000000000000000000
              90300000000000000000000000000000
              100670000000000000000000000000000
              11000000000000000000000000000000
              12007000000000000000000000000000
              130024000000000000000000000000000
              140043000000000000000000000000000
              150026400000000000000000000000000
              16000700000000000000000000000000
              170003610000000000000000000000000
              180002840000000000000000000000000
              190002151000000000000000000000000
              200004210000000000000000000000000
              210000264000000000000000000000000
              220000258100000000000000000000000
              2300001420200000000000000000000000
              240000322400000000000000000000000
              2500000181210000000000000000000000
              2600000201750000000000000000000000
              270000041771000000000000000000000
              280000032391000000000000000000000
              2900000013214000000000000000000000
              3000000092612300000000000000000000
              3100000001616300000000000000000000
              3200000011018410000000000000000000
              3300000003242350000000000000000000
              34000000021418124000000000000000000
              3500000000727127100000000000000000
              3600000000211258510000000000000000
              3700000000052116920000000000000000
              38000000000217291391000000000000000
              39000000000121415124000000000000000
              400000000001213271116410000000000000
              410000000000271524141110000000000000
              42000000000002921111241000000000000
              430000000000005143022208000000000000
              440000000000000513222014910000000000
              4500000000000001922292817102000000000
              4600000000000000141420231815400000000
              4700000000000000039232822141194321000
              4800000000000000000315343027137211100
              4900000000000000002248243029201154320
              500000000000000000001410183340291610554
              5100000000000000000122131020354534271712
              52000000000000000000013558152439393832
              530000000000000000000000124710223343
              54000000000000000000000000001248
              55000000000000000000000000000001
              56000000000000000000000000000000

               Got it, thanks. TinyMCE really should accommodated excel better.


                United States
                Member #124493
                March 14, 2012
                7023 Posts
                Offline
                Posted: January 5, 2013, 2:35 pm - IP Logged

                If I copy paste directly into excel the following happens.

                69242534214082O/3E

                 oh, nothing happened,

                the webpage and excel happend to freeze for about a minute, but it seems the formatting remained.

                That was not always the case from my prior experience.


                  United States
                  Member #124493
                  March 14, 2012
                  7023 Posts
                  Offline
                  Posted: January 5, 2013, 2:37 pm - IP Logged

                  If I copy paste directly into excel the following happens.

                  69242534214082O/3E

                   oh, nothing happened,

                  the webpage and excel happend to freeze for about a minute, but it seems the formatting remained.

                  That was not always the case from my prior experience.

                  Oh sorry!!! Forgot you dont like pink!Razz

                    SergeM's avatar - slow icon.png
                    Economy class
                    Belgium
                    Member #123700
                    February 27, 2012
                    4035 Posts
                    Offline
                    Posted: January 5, 2013, 4:30 pm - IP Logged

                    Oh sorry!!! Forgot you dont like pink!Razz

                    Maybe you should show your functions for 2O/3E instead.


                      United States
                      Member #124493
                      March 14, 2012
                      7023 Posts
                      Offline
                      Posted: January 6, 2013, 7:35 am - IP Logged

                      Maybe you should show your functions for 2O/3E instead.

                      Well I started with this and then I got stuck.

                      =IF(DJ1488=2,"3O/2E",0)


                        United States
                        Member #124493
                        March 14, 2012
                        7023 Posts
                        Offline
                        Posted: January 6, 2013, 7:42 am - IP Logged

                        1

                        15

                        1

                        10

                        3

                        a1

                        1

                        2

                        0

                        2

                        1

                        17

                        19

                        30

                        34

                        101

                        33

                        29

                        17

                        1

                        2

                        2

                        3

                        1

                        3

                        2

                        4

                        2

                        7

                        6

                        5

                        5

                        4

                        1

                        0

                         

                        4

                        10

                        3

                        5

                        0

                        22

                        0

                        2

                        6

                        0

                        b1

                        0

                        0

                        3

                        2

                        22

                        23

                        26

                        33

                        34

                        138

                        12

                        11

                        11

                         

                         

                         

                        0

                        3

                        2

                        0

                        3

                        2

                        3

                        2

                        5

                        2

                        8

                        7

                        7

                        4

                        2

                        0

                         

                        16

                        1

                        5

                        4

                        0

                        11

                        2

                        0

                        2

                        14

                        c1

                        0

                        4

                        0

                        1

                        11

                        14

                        15

                        18

                        33

                        91

                        22

                        7

                        19

                                                                                         

                        1

                        3

                        1

                        4

                        0

                        1

                        4

                        5

                        1

                        9

                        6

                        9

                        4

                        7

                        2

                        0

                         

                        5

                        5

                        2

                        12

                        4

                        14

                        0

                        3

                        3

                        10

                        d1

                        0

                        3

                        1

                        1

                        14

                        15

                        19

                        23

                        34

                        105

                        20

                        9

                        19

                        0

                        4

                        1

                        3

                        1

                        1

                        4

                        4

                        2

                        6

                        9

                        5

                        8

                        4

                        1

                        0

                         

                        5

                        2

                        3

                        1

                        0

                        1

                        5

                        7

                        3

                        3

                        e1

                        2

                        2

                        1

                        0

                        1

                        7

                        15

                        19

                        23

                        65

                        22

                        18

                        16

                        2

                        3

                        0

                        4

                        3

                        2

                        3

                        2

                        1

                        7

                        7

                        9

                        5

                        8

                        1

                        0

                         

                        4

                        8

                        2

                        3

                        1

                          SergeM's avatar - slow icon.png
                          Economy class
                          Belgium
                          Member #123700
                          February 27, 2012
                          4035 Posts
                          Offline
                          Posted: January 6, 2013, 12:57 pm - IP Logged

                          Well I started with this and then I got stuck.

                          =IF(DJ1488=2,"3O/2E",0)

                          =IF(DJ1488=2,"3O/2E",0)+IF(DJ1488=3,"3O/1E",0) &'(?)"

                          Can that not help?


                            United States
                            Member #124493
                            March 14, 2012
                            7023 Posts
                            Offline
                            Posted: January 6, 2013, 2:59 pm - IP Logged

                            =IF(DJ1488=2,"3O/2E",0)+IF(DJ1488=3,"3O/1E",0) &'(?)"

                            Can that not help?

                            I will test that in the cell and see if that helps.

                            Thanks.


                              United States
                              Member #124493
                              March 14, 2012
                              7023 Posts
                              Offline
                              Posted: January 6, 2013, 3:06 pm - IP Logged

                              =IF(DJ1488=2,"3O/2E",0)+IF(DJ1488=3,"3O/1E",0) &'(?)"

                              Can that not help?

                              =IF(DJ1489=2,"3O/2E",0)+IF(DJ1489=3,"2O/3E",0)&'(?)"

                              Sorry, not working.

                              Good try though serge.