How do I remove my email from open office. I am getting over 100 emails a day. Arghhhh In a message dated 1/28/2009 12:42:04 A.M. Central America Standard , [email protected] writes:
I am copying and pasting price lists from my main supplier into a calc worksheet and then increasing their wholesale price by my retail margin, prior to posting the list onto my own Web site. Here is what I am actually doing (you may need to widen your e-mail client screen to make sense of the data - ie get the lines right): 1. I copy the price list from the supplier Web page and then copy it into M$ Notepad (to remove any formatting other than the tab delimiter) and get something like this in Notepad: EDSXP7300V Small Office Home Office - economy E7300 C2D PC +MS Vista Home Premium (VHP) 790 EDSXP7300P Small Office Home Office - economy E7300 C2D PC +MS XP Professional (XPP) 830 EDSXP7300VM1 Small Office Home Office - economy E7300 C2D PC +MS VHP +19IN M/M WS LCD 950 EDSXP7300VM2 Small Office Home Office - economy E7300 C2D PC +MS VHP +22IN WS LCD 990 EDSXP7300PM1 Small Office Home Office - economy E7300 C2D PC +MS XPP +19IN M/M WS LCD 990 EDSXP7300PM2 Small Office Home Office - economy E7300 C2D PC +MS XPP +22IN WS LCD 1030 2. I then copy Notepad into a new, blank spreadsheet and optimise the column widths. The last couple of columns look like this: column C Col D E7300 C2D PC +MS Vista Home Premium 790 E7300 C2D PC +MS XP Professional 830 E7300 C2D PC +MS VHP +19IN M/M WS LCD 950 E7300 C2D PC +MS VHP +22IN WS LCD 990 E7300 C2D PC +MS XPP +19IN M/M WS LCD 990 E7300 C2D PC +MS XPP +22IN WS LCD 1030 3. I then us a formula to calculate the retail price where: wholesale price in cell D1 = $790 mark-up is $200 Retail price is recorded in cell E1 = D1+200 4. One would expect the retail price to be 790 + 200 = 990 but according to Calc it is $200 ???? 5. if I use the formula E1=D1 I get 790. if I then edit that formula so it reads E1=D1+200 I get 200 ? If anyone can throw some light on this I would be very much obliged. Kind regards, James --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] **************A Good Credit Score is 700 or Above. See yours in just 2 easy steps! (http://pr.atwola.com/promoclk/100000075x1215855013x1201028747/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072%26hmpgID=62%26bcd=De cemailfooterNO62)
