Using Excel as editor?

Collapse

Recommended Videos

Collapse
X
Collapse
 
  • Page of 5
  • Time
  • Show
Clear All
new posts
Previous 1 2 3 4 5 template Next
  • LhasaCM
    Rookie
    • Apr 2003
    • 9
    #31
    Re: Using Excel as editor?

    Whoops...

    Actually...I was a bit simplistic in the post. The formula would have to be more complicated than =1.1*X2 because that would create decimal values and also values greater than 99.

    Really, what I would do is:

    =if(X2>90,99,round(1.1*x2))

    This means that if the current value is greater than 90, make it 99...otherwise, add 10% and round to the nearest integer.

      Comment

      • snepp
        We'll waste him too.
        • Apr 2003
        • 10007
        #32
        Re: Using Excel as editor?

        Very cool, thanks. I think I've forgotten more about Excel than I ever learned in the first place.

        Will definately have to look into using this.
        Member of The OS Baseball Rocket Scientists Association

          Comment

          • snepp
            We'll waste him too.
            • Apr 2003
            • 10007
            #33
            Re: Using Excel as editor?

            Very cool, thanks. I think I've forgotten more about Excel than I ever learned in the first place.

            Will definately have to look into using this.
            Member of The OS Baseball Rocket Scientists Association

              Comment

              • snepp
                We'll waste him too.
                • Apr 2003
                • 10007
                #34
                Re: Using Excel as editor?

                </font><blockquote><font class="small">Quote:</font><hr />
                Whoops...

                Actually...I was a bit simplistic in the post. The formula would have to be more complicated than =1.1*X2 because that would create decimal values and also values greater than 99.

                Really, what I would do is:

                =if(X2&gt;90,99,round(1.1*x2))

                This means that if the current value is greater than 90, make it 99...otherwise, add 10% and round to the nearest integer.


                <hr /></blockquote><font class="post">

                btw, You are now officially my hero for the rest of the weekend....

                I don't suppose you can get the quirks out of my Access database too?
                Member of The OS Baseball Rocket Scientists Association

                  Comment

                  • snepp
                    We'll waste him too.
                    • Apr 2003
                    • 10007
                    #35
                    Re: Using Excel as editor?

                    </font><blockquote><font class="small">Quote:</font><hr />
                    Whoops...

                    Actually...I was a bit simplistic in the post. The formula would have to be more complicated than =1.1*X2 because that would create decimal values and also values greater than 99.

                    Really, what I would do is:

                    =if(X2&gt;90,99,round(1.1*x2))

                    This means that if the current value is greater than 90, make it 99...otherwise, add 10% and round to the nearest integer.


                    <hr /></blockquote><font class="post">

                    btw, You are now officially my hero for the rest of the weekend....

                    I don't suppose you can get the quirks out of my Access database too?
                    Member of The OS Baseball Rocket Scientists Association

                      Comment

                      • LhasaCM
                        Rookie
                        • Apr 2003
                        • 9
                        #36
                        Re: Using Excel as editor?

                        And what quirks would those be? I haven't even tried opening anything into Access yet so don't know what you're facing...

                          Comment

                          • LhasaCM
                            Rookie
                            • Apr 2003
                            • 9
                            #37
                            Re: Using Excel as editor?

                            And what quirks would those be? I haven't even tried opening anything into Access yet so don't know what you're facing...

                              Comment

                              • snepp
                                We'll waste him too.
                                • Apr 2003
                                • 10007
                                #38
                                Re: Using Excel as editor?

                                The quirks. Well, linking tables and being able to make changes that replicate primarily. Getting the proper relationships setup between the roster file and the attribute files. Things like that.
                                Member of The OS Baseball Rocket Scientists Association

                                  Comment

                                  • snepp
                                    We'll waste him too.
                                    • Apr 2003
                                    • 10007
                                    #39
                                    Re: Using Excel as editor?

                                    The quirks. Well, linking tables and being able to make changes that replicate primarily. Getting the proper relationships setup between the roster file and the attribute files. Things like that.
                                    Member of The OS Baseball Rocket Scientists Association

                                      Comment

                                      • LhasaCM
                                        Rookie
                                        • Apr 2003
                                        • 9
                                        #40
                                        Re: Using Excel as editor?

                                        So...basically, trying to set up Access as an editor?

                                        I'll take a look tonight and play around a bit and see what I see...

                                          Comment

                                          • LhasaCM
                                            Rookie
                                            • Apr 2003
                                            • 9
                                            #41
                                            Re: Using Excel as editor?

                                            So...basically, trying to set up Access as an editor?

                                            I'll take a look tonight and play around a bit and see what I see...

                                              Comment

                                              • snepp
                                                We'll waste him too.
                                                • Apr 2003
                                                • 10007
                                                #42
                                                Re: Using Excel as editor?

                                                </font><blockquote><font class="small">Quote:</font><hr />
                                                So...basically, trying to set up Access as an editor?


                                                <hr /></blockquote><font class="post">

                                                Basically to try using Access as a full editor. Why I don't know, but it does have its uses....
                                                Member of The OS Baseball Rocket Scientists Association

                                                  Comment

                                                  • snepp
                                                    We'll waste him too.
                                                    • Apr 2003
                                                    • 10007
                                                    #43
                                                    Re: Using Excel as editor?

                                                    </font><blockquote><font class="small">Quote:</font><hr />
                                                    So...basically, trying to set up Access as an editor?


                                                    <hr /></blockquote><font class="post">

                                                    Basically to try using Access as a full editor. Why I don't know, but it does have its uses....
                                                    Member of The OS Baseball Rocket Scientists Association

                                                      Comment

                                                      • LhasaCM
                                                        Rookie
                                                        • Apr 2003
                                                        • 9
                                                        #44
                                                        Re: Using Excel as editor?

                                                        Yeah...I agree...in theory it should be a beautiful way to get at everything...

                                                        In practice, getting it set up will be a royal pain, but doable

                                                          Comment

                                                          • LhasaCM
                                                            Rookie
                                                            • Apr 2003
                                                            • 9
                                                            #45
                                                            Re: Using Excel as editor?

                                                            Yeah...I agree...in theory it should be a beautiful way to get at everything...

                                                            In practice, getting it set up will be a royal pain, but doable

                                                              Comment

                                                              Previous 1 2 3 4 5 template Next
                                                              Working...