Re: Using Excel as editor?

[LhasaCM]

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.

[snepp]

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.

[snepp]

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.

[snepp]

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?

[snepp]

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?

[LhasaCM]

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...

[LhasaCM]

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...

[snepp]

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.

[snepp]

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.

[LhasaCM]

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...

[LhasaCM]

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...

[snepp]

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....

[snepp]

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....

[LhasaCM]

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

[LhasaCM]

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