ABC, Inc.
Refresh when you first open Inventory ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Stock Unit
Name
Date
35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
nc.
Refresh when you first open the file and Save before exit. 2009/Q1 Current Qt. Transaction Qt. (negative if out) Final Qt. Safety Stock Level
C2
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
Date Inventory ID <= <= <= <= <= <= <= <= <= <= <= <= <= <= <= <= <= 0 Date Inventory ID Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <=
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID
<= <= <= <= <= <= <= <=
0 Date Inventory ID
Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <=
0 0 0 0 0 0 0 0
0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID
SKU LIST
#
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Inventory ID
Name
Initial Stock
Stock Unit
Safety Stock Level
FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
Follow the steps to enable your online Inventory Tracker.
1) 2) 3) 4) 5) >> Type the name of your company and period: Company: ABC, Inc. Period:
Yes
2009/Q1
No
Type the number of SKUs? (this template can be used for a number of SKUs up to 100) Do you want to add Safety Stock Level control? > > > Enter the short warning to be displayed when net inventory is under Safety Stock Level: You may leave unused lines blank. You may leave unused lines blank.
On the right you can see a list of sample stock units. You can make the necessary changes on the list. Provide the necessary information on the "Data" sheet. Your Inventory Tracker is ready to use. Only the white cells are to be filled. Further steps are for online use. Note that "Current Qt" and "Final Qt" columns are dynamic. Each time a transaction is entered, the latest inventory positions are displayed. Dynamic inventory positions are calculated according to the transaction date.
6)
Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information.
7) 8)
Click "Add Web Application" to upload this file. Check the "Single Record Application" line. Your online file will be created automatically. You can simply use the file from that link or place it on your website. Your online Inventory Tracker will look like: http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=53867f96-6473-4182-a428-65a0f0cfa4e2 Sample data in the above application contains Inventory Ids from 1001 to 1010, you can try these values to see the results.
>>
In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm
Copyright (c) 2009 Pagos, Inc., http://www.pagos.com/
20 1 Place order. Stock Units Units Meters Rolls Packs TRUE
s entered, the latest inventory positions
line. Your online file will be created automatically.
d=53867f96-6473-4182-a428-65a0f0cfa4e2
an try these values to see the results.