15 de abril de 2013

How to Create a Commercial Invoice

A commercial invoice is a form used to provide specific information required by customs officials when shipping or receiving products across international borders. There is no standard format for a commercial invoice. However, customs agencies typically require that certain information be documented on foreign imports. This article provides instructions on how to create a commercial invoice for imported goods using any spreadsheet software program.



Edit Steps



Sample Invoices








Creating Your Own Invoice



  1. Format the title and text. Select cells A1 through K1 and click the "merge cells" button, the "word wrap" button, the "center justify" button and the "bold" button.

    • Type "COMMERCIAL INVOICE" and set the font size at 14. Click the "fill bucket" and select black. Click the "font color" button and select white. The title is formatted.



  2. Enter and format the shipper information field. Select cells A2 through G7, press the "merge cells" button, the "word wrap" button, and the "align text left" button on the formatting toolbar.

    • Type "SENDER," and enter the name, address, phone, fax and tax ID information for the shipper. The shipper information field is complete.



  3. Enter the text and format the receiver information field. Select cells H2 through K7, press the "merge cells" button, the "word wrap" button, and the "align text left" button on the formatting toolbar.

    • Type "RECIPIENT," and enter the name, address, phone, fax and tax ID information for the purchaser. The recipient information field is complete.



  4. Enter and format the tracking, reference and date information fields. Type "Invoice date" in cell A8, "Invoice #," in cell H8 and "Tracking #" in cell A9. Type "Reference #" in cell H9, "Shipper" in cell A10 and Recipient" in cell H10.

    • Select cells A8 through G8. Press and hold the control button and select cells H8 to K8. Press the "merge cells" button, the "wrap text" button, and the "left justify" button. With all cells still selected, position the mouse pointer in the lower-right corner of cell K8 and use the fill handle (+) to drag the formatting down 3 rows to cell K10. Tracking, reference and date information fields are complete.



  5. Enter and format the product information. Type "Quantity" in cell A11, "Origin" in C11, "Description" in E11 and "HTC Code" in G11. Then type "Weight" in I11, "Value" in J11 and "Subtotal" in K11.

    • Select cells A11 and B11. Position the mouse pointer in the lower-right corner of cell B11 and use the fill handle (+) to drag the formatting vertically through to column H. The product information has been formatted.



  6. Enter and format the product information. Type "Total Weight" in cell A14. Skip over cells C and D, and type "Declared Value" in cell E14. Type "Total Shipment" in cell A15 and "Taxes and Fees" in cell E15.

    • Type "Currency Code" in cell A17, "Total Amount" in cell E17, "Reason for Export/Import" in cell A18 and "Certification Statement" in cell A19.

    • Select cells A12 through B13 and click the merge cells button on the toolbar. Position the mouse pointer in the lower-right corner of cell B13 and use the fill handle (+) to drag the formatting vertically through to column I.

    • Skip row 14, and select cells A15 through B16. Press the "merge cells" button. Use the fill handle to drag the formatting through to cell H16. Select cells I15 through K16 and press the "merge cells" button on the toolbar.

    • Select cells A18 to C18 and press the "merge cells" button, the "wrap text" button, and the "left justify" button. Select cells D18 to K18, and select the "merge cells" button.

    • Select cells A19 through K19 and press the "merge cells" button. Select cells A20 through K24 and press the "merge cells" button.

    • Add borders to the invoice. Select cells A1 through K24, click the "borders" menu and select the "All Borders" option from the formatting toolbar. The commercial invoice is complete.







Edit Related wikiHows




Edit Sources and Citations




Article Tools








via Jonathan's starred items in Google Reader

How to Make Homemade Crushed Red Pepper Flakes

Whether you aren’t sure what to do with an overly zealous pepper plant in the backyard or you're trying to think of a creative gift, making homemade red pepper flakes are both fun and truly delicious.



EditSteps



Picking Your Peppers



  1. Determine which type of pepper will be right for making your crushed red pepper flakes. With a whole family of peppers you can pick, base your decision on how hot of a pepper you can handle. Pepper hotness is measured by Scoville units--the higher the Scoville unit, the hotter the pepper. For example, a sweet bell pepper has zero Scoville units whereas the mighty Habanero pepper ranges from 100,000 to 350,000. The hottest pepper on the scale is the Trinidad Scorpion Butch at 1,463,700.[1]





    • Assess your overall needs. If you're creating the crushed pepper for home use and you like them hot, go for the hottest pepper you can find. However, if you're giving the flakes to friends, you may want to go with something a little tamer.





    • Test the pepper before you make the crushed flake batch. What may be considered to be hot to some may not be to others. Or, you may not like the taste of certain peppers.







  2. Consider how big of a batch you want to make. In general, 71 Serrano peppers can make one cup of crushed red pepper flakes.







Baking the Peppers



  1. Heat the oven to 170ºF/75ºC or a low setting. Although the easiest way is to dry the peppers in the oven, you could also sun dry them, especially if you live in an arid climate.





  2. Using a knife, carefully cut off the pepper stems. Then, slice the peppers by simply splitting them in half. Don't remove the seeds.





  3. Line non-greased cookie sheets with peppers. Line the peppers side by side and avoid clumping them together; otherwise, they won’t dry properly.





  4. Bake in the oven for approximately six hours. To be sure they get enough time to dry, set a timer. Once six hours have passed by, turn off the oven and allow the dried peppers to remain in the oven overnight, so they will continue to dry and dehydrate.







Making the Pepper Flakes



  1. Crush into flakes. The next day, place the dried peppers in a food processor or crush them by hand. Only crush peppers by hand if you're wearing gloves and you're crushing the peppers while they're inside a plastic bag. Otherwise, stick with the food processor.





  2. Once the dried peppers have been thoroughly crushed, carefully pour them into an airtight container for storage. Serve the crushed peppers in a food shaker such as a pepper shaker.[2]









Edit Video



Edit Tips



  • Add a label to the bottle to identify the peppers and the date they were created. All spices decrease in strength and become stale when kept too long, so be sure to use within a few months for optimal taste.

  • Open windows or try to increase ventilation as the peppers cook; keep more sensitive people out of the way.



EditWarnings



  • Never touch your face or eyes when working with peppers, as residual pepper juice can cause extreme pain upon contact.

  • Some people are very sensitive to the chemicals in heated peppers; you may like to ask them to step outside until you're finished. Keep small children and pets well away from the cooking zone.



EditThings You'll Need



  • Red peppers

  • Cookie sheet(s)

  • A coarse grinder such as a food processor, blender or spice grinder; the more finely you grind the peppers, the hotter/more powerful the flavor



Edit Related wikiHows




EditSources and Citations



Article Tools








via Jonathan's starred items in Google Reader

14 de abril de 2013

Crea en minutos un banner para divulgar tu app

download


Lo que veis en la imagen superior es el aspecto de www.appmarketingtool.com, una sencilla herramienta que puede ser útil para los que no tienen posibilidad de contratar o crear un banner personalizado divulgando su aplicación y quieren usar un Wizard que haga el trabajo por ellos.


Solo tenemos que informar la url de nuestra aplicación, el nombre, el texto, el estilo, el formato y el código promocional en caso de existir. La herramienta creará un banner que responda directamente a las configuraciones especificadas, siendo posible divulgarlo en cualquier web para que los lectores puedan hacer el download correspondiente.


Aunque nos lo han presentado como un generador de banners para diovulagr apps de Windows 8, puede ser útil para cualquier uso, siempre que requiera bajarse para instalarla en el ordenador.


Práctico y sencillo, como a mí me gusta.




Texto escrito en wwwhatsnew.com



Patrocinan WWWhatsnew: Vuelos Baratos

Hospedado en RedCoruna












via Jonathan's starred items in Google Reader

Dos eventos que no podéis perder en España (III): Sobre Comercio electrónico y Fotografía móvil

Y seguimos divulgando eventos relacionados con el mundo digital en España, indicando ahora dos oportunidades que nos envían por email desde Zaragoza y Barcelona.


El primero de ellos es ideal para quien trabaja con comercio electrónico y marketing. El segundo tiene como objetivo atraer a interesados en el mundo de la fotografía móvil.


JornadasMarketingOnline.com


marketing online

El primero se celebrará el viernes 26 de abril, un evento descrito como las I JornadasMarketingOnline.com, donde se trataran tems relacionados con comercio electrónico y marketing en Internet.


Dirigido a profesionales del sector, empresarios y directivos de las principales tiendas online de Aragón y España, contará con la presencia de varios expertos para impartir las conferencias: Ricardo Lop de Aceros de Hispania, Ricardo Alcalde de Zaquia.es, Jesús Barón de Semmantica.com, Javier Ferraz de Masterd.com, Héctor Mainar de Soloporteros.com, Luis Serrano de Tienda-Medieval.com, Alex Ruiz de Conunpocodeazucar.com y Carlos Larraz de Funidelia.es


Logística en Ecommerce, Captación de tráfico de calidad para tu tienda online y Casos de éxito y su evolución en la relación con la plataforma de comercio electrónico opensource Prestashop son los temas de las mesas redondas que allí se celebrarán.


Más información: jornadasmarketingonline.com


D-IVE Mobile Photo Festival


dive


El D-IVE Mobile Photo Festival es un festival de fotografía móvil que se llevará a cabo los días 19, 20 y 21 de abril en Barcelona. En el festival se pueden encontrar conferencias, Master Classes, talleres, mesas redondas, photo walks, etc en torno a la fotografía móvil: desde conceptos puramente técnicos hasta la relación con el social media (Instagram) y el marketing.


D-IVE es organizado por Ex-Labs en colaboración con Disseny Hub Barcelona, ICUB, el Ayuntamiento de Barcelona, Mobile World Centre, Moritz y Movistar. Han creado también #diveuniverse, un concurso cuyos ganadores, entre otros premios,

verán expuestas sus fotografías en la exposición permanente que tendrá lugar durante D-IVE 2013.


Más información: d-ive.com




Texto escrito en wwwhatsnew.com



Sigue las noticias por twitter.com/wwwhatsnew, Facebook.com/wwwhatsnew o Google Plus.









via Jonathan's starred items in Google Reader

Friends+Me, lleva tus publicaciones en Google+ a Twitter, Facebook, y LinkedIn

Friends+Me


En nuestro muro de Google+ podemos publicar aquellos comentarios que queramos compartir con algunos de nuestros círculos, así como enlaces a sitios web que nos parecen interesantes, nuestras mejores imágenes fotográficas, e incluso vídeos que más nos hayan llamado la atención. Pero además de nuestros círculos, tenemos contactos en Twitter, Facebook y LinkedIn, de manera que tenemos que ver la forma de poder llevar a ellos nuestras publicaciones


Una vía nos la ofrece Friends+Me, donde básicamente vincularemos nuestra cuenta de Google+ con el servicio para posteriormente vincular Twitter, Facebook y LinkedIn, o algunas de ellas. Friends+Me ofrece tres planes de tarificación, siendo el primero de ellos gratuito, disponiendo de un intervalo de hasta 100 minutos para la búsqueda de nuevos contenidos, limitado a 40 republicaciones mensuales en las redes vinculadas, y sin soporte para páginas en Google+.


Disponemos para ello de nuestro panel donde configuraremos tanto las redes vinculadas así como el acortador de URLs usado, ofreciéndonos además un historial de las últimas republicaciones realizadas. Un detalle a tener en cuenta es que podemos permitir la republicación de cualquier contenido o sólo mediante hashtag.


Enlace: Friends+Me












via Jonathan's starred items in Google Reader