P
pietlinden
Think I just bit off more than I can chew, but anyway, here's the
problem.
I am trying to convert an Excel spreadsheet into and Access database.
It's supposed to do Purchase Orders, Invoices, and Quotes. The
spreadsheet does, sort of.
the spreadsheet is about 70+ columns wide. This in and of itself is
not an issue. What's screwy is this looks like an "accretion
spreadsheet" that has been gathering layers of complexity over the
years. Its basic purpose is to determine a sale price for a given
item, by summing various fees or whatever that add to the cost of
buying and shipping the items. (They're being imported, so he's doing
stuff like spreading the cost of the shipping container over the
number of items in the container and stuff like that.)
Okay, the problem... Since storing calculated values in Access is bad
form, I'm trying to break out the formulas so I can reproduce them in
Access. Before everybody says "oh, but you can't", the calculations
are little more than basic math: multiplication, division, addition,
subtraction, grouping. No fun things like lookups or Excel
functions. The math in this thing is really simple, it's tracing the
meaning of all the different bits that's driving me nuts.
Oh, and to make things even more fun, there appear to be sort of
nested tables in some of the sections of the spreadsheet (all one big
ugly one). Any pointers on untangling this Gordian knot (well, short
of cutting it in half!!!)? I was working through the Dependencies
stuff, and that sort of helped. I did rename all the columns so at
least the math is in English now instead of cell-speak. Is there
anything else I can do besides sitting down with the guy who wrote it
and asking him to explain this mess?
I understand the vast majority of it, but untangling it is a bit of a
task...
Thanks
Pieter
problem.
I am trying to convert an Excel spreadsheet into and Access database.
It's supposed to do Purchase Orders, Invoices, and Quotes. The
spreadsheet does, sort of.
the spreadsheet is about 70+ columns wide. This in and of itself is
not an issue. What's screwy is this looks like an "accretion
spreadsheet" that has been gathering layers of complexity over the
years. Its basic purpose is to determine a sale price for a given
item, by summing various fees or whatever that add to the cost of
buying and shipping the items. (They're being imported, so he's doing
stuff like spreading the cost of the shipping container over the
number of items in the container and stuff like that.)
Okay, the problem... Since storing calculated values in Access is bad
form, I'm trying to break out the formulas so I can reproduce them in
Access. Before everybody says "oh, but you can't", the calculations
are little more than basic math: multiplication, division, addition,
subtraction, grouping. No fun things like lookups or Excel
functions. The math in this thing is really simple, it's tracing the
meaning of all the different bits that's driving me nuts.
Oh, and to make things even more fun, there appear to be sort of
nested tables in some of the sections of the spreadsheet (all one big
ugly one). Any pointers on untangling this Gordian knot (well, short
of cutting it in half!!!)? I was working through the Dependencies
stuff, and that sort of helped. I did rename all the columns so at
least the math is in English now instead of cell-speak. Is there
anything else I can do besides sitting down with the guy who wrote it
and asking him to explain this mess?
I understand the vast majority of it, but untangling it is a bit of a
task...
Thanks
Pieter