Posts Tagged excel database custom

Custom MS Excel Formula

I need a custom formula created for MS Excel, compatible with 2007 and newer. This formula will determine total material usage based on the following:

1. Material units are 10 sticks. The returned value will be in number of units.
2. The material is used to build a frame: minimum dimensions is 4 x 4, with no maximum size, using 2 increments.
3. The formula will optimize material usage and use waste as applicable.
4. The formula will factor is waste due to 45 degree cuts at the corners.
5. A joint cannot fall within 4 of the frame corner.

Please let me know of any questions or clarifications.

Thank you

Tags: , , , , , , , , , , , , , , , ,

Code Igniter Custom Database Class

I need a Coder familiar with Code Igniter custom classes.
What I require is a custom database class written (or code Igniters database class modified) to accept 2 databases at the same time.

I know it can accept 1 database from the 2 groups as active, but that way it queries any 1 database only.

What I require is the ability to pass query like,
"SELECT DB1.Table1.Fld1, DB2.Table2.Fld2 FROM DB1.Table1, DB2.Table2"

And also all the JOIN functions etc should work as normal with Code Igniter.

Tags: , , , , , , , , , , , , , , , ,

Custom Database To Printout

I would like some software developed which allows me to manage a small database. The database entries would consist of an object ID, an image, and several strings, all except the ID being optional. The software GUI would allow input of new records to the database, with manual entry of strings, and selection of a image. The software would also allow viewing/printing of any entry in the database. The viewing would be via a selectable template. The template describes the position of the image and text strings on the output page, and also specifies the page size. Specifically, I want to print database entries to envelopes of various sizes. I would like to specify a list of records and have them viewed/printed successively (i.e., type 1-10 and have records 1-10 displayed, or 1,3,5,10-20,144 to show those). The software may run on Linux or WIndows, using any language. I would prefer use of a Postgres database, Java, Python or C/C++ and Linux but am open to alternative approaches.

So I see the tasks being:
1) database tables
2) template(s) — can be text-based files for simplicity of implementation (this is an infrequent task)
3) GUI for data entry (picture/strings)
4) GUI for data display (using selected template)
5) Printout capability

There may already be existing software to do this sort of thing. All source code required as a deliverable.

Tags: , , , , , , , , , , , , , , , ,

DataBase / Excel Help

I have about 32000 records in an excel file. Each record has about 15 columns.

About 12000 records are duplicate and a few records even appears 3 times. I can remove the duplicates by sorting the records by "name feild" and then find duplicates by formulas.

But, the problem is that in the duplicate records, the other 15 feilds are not same for all duplicates.

For eg.

Cell number A1 and A2 are duplicate, But Cell A1, A2…and B1, B2 are not same. Some data is in row A and some data is in Row B.

I need help in merging those records. For eg. if Row A1 is blank and B1 has the data, then I need the B1 data merged into A1. If both feilds have data, then I need data combined from both feilds.

This should be very easy who know the excel and database things.

Once this is done, I may also need you to do a cleanup with the database and convert to mysql format. But, this will be another project.

Let me know if you dont understand anything. Easy $30 for someone who is capable.

Tags: , , , , , , , , , , , , , , , ,