DBVars.php
Summery
Transactions
Table
Old
Short
48 On Table $1902.00 in Stock...
Click for usage Notes
... To add a transaction, type "(#)-Name(recorded price)-From-To-(this price)-(notes)"
... The shortcuts are "W B I D P"
... To add a new product type "Name-a-a-Price (group)"
... To start timing a sculpture type "start"
... Multiple Transactions can be seperated by an *
... Typing just "($) Name(Price)" becomes Sale from Display at full price
... Description Words Can be used instead. They Are typed without spaces each character is checked
Show/Hide Table options
Show retired?
Base this table on data from:
too
Use only data from this Venue :
dates should be formatted like : 2009-10-04 24:59:59
Name
Price
Material
Cost
Display
Count
Invent.
Count
Backup
Count
Name
Stock
Value
Other
Sales
Out
of Blue
Sale
Count
View
Fail
Name
$/10
sales
Make
Time
$.per
Min
Earnings
Ready 4
MaxStock?
MinDisplay?
Group
Name
1)
PineappleRose
(1502)
$0.00
44.250
0
4
0
1)
PineappleRose
(1502)
$6.55
12.00
2.42
0.00
Description words
Group Summery
PineappleBouncing earns $3.98 at $29.00 St=0
PineappleGroup earns $0.00 at $1.00 St=0
Click Here For Transaction settings
...List only transactions involving:
...List Transactions happening Before:
...List Only Transaction From This Venue:
Only List Timed Transactions:
dates should be formatted like : 2009-10-04 24:59:59
Number of Transactions to print:
Current Venue:
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
7:12
(1) 1
MotorcycleOne
$39
(1) 1
MotorcycleOne
$39
''
7:12
(2) 1
PineappleRose
$29
$0 = $69 / 50339.9833 min
4:59
(2) 1
KwFancyPalm39
$39
3:26
(3) 1
DogStick
$29
10/10/2022 19:12
.
Today I Earned
$68.00
Total I produced $107.00 worth of sculptures, in 38:67 min, $39.00 of sales were custom orders, It Takes 26.7 Minutes to replace those sold
Produced $0.00 since last sale, Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
1) 1
PineappleRose(s)
moved from On_Display too Public there were
"other sales", average is 44,
were displayed, at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
11:45
(1) 1
CatWithBall
$29
9:50
(1) 1
DogSketch
$19
$0 = $19 / 50339.9833 min
9:45
(1) 1
PalmBrass
$29
(2) 1
PalmBrass
$29
9:06
(2) 1
MechanicalFish
$49
(3) 1
MechanicalFish
$49
9:06
(3) 1
AligatorMechanical
$29
(4) 1
AligatorMechanical
$29
9:05
(1)
$0
9:04
(4) 1
OwlWings
$29
9:03
(2)
$0
''
9:02
(2) 1
CatWithBall
$29
$0 = $49 / 50339.9833 min
9:02
(3)
$0
9:02
(5) 1
GufCopperFenderGuitar
$34
''
8:34
(3) 1
FishWheeled
$24
$0 = $74 / 50339.9833 min
8:31
(6) 1
DragonCopper34
$34
''
7:44
(4) 1
AngelPropeller
$49
''
7:44
(5) 1
BalletCopper
$29
''
7:44
(6) 1
DragonCopper34
$34
''
7:44
(7) 1
FishingPoleCopper
$29
''
7:44
(8) 1
GufCopperFenderGuitar
$34
''
7:44
(9) 1
MermaidPropeller49
$49
$0.01 = $304 / 50339.9833 min
7:21
(7) 1
TurtleBrass19
$19
(5) 1
TurtleBrass19
$19
7:21
(6) 1
TurtleBrass19
$19
''
6:47
(10) 1
DogPortrait
$35
(7) 1
DogPortrait
$35
$0.01 = $340 / 50339.9833 min
6:35
(8) 1
DogStick
$29
(8) 1
DogStick
$29
6:00
(4) 1
TurtleBrass19
$19
6:00
(5) 1
DachshundCopper
$29
5:59
(9) 1
PineappleRose
$29
5:59
(10) 1
TurtleCopper19
$19
5:58
(11) 1
ILoveYouMoreTrippleLevel
$29
5:55
(12) 1
PalmCopperTwo
$29
10/07/2022 17:59
.
Today I Earned
$331.00
Total I produced $189.00 worth of sculptures, in 711:67 min, $35.00 of sales were custom orders, It Takes 71.9 Minutes to replace those sold
Produced $0.00 since last sale, plus 4 items with unknown make times Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
2) 1
PineappleRose(s)
moved from Inventory too On_Display
at
on
Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
8:12
(1) 1
HorseOne
$29
8:12
(1) 1
PineappleRose
$29
''
8:12
(2) 1
PalmBrass
$29
(1) 1
PalmBrass
$29
''
7:58
(3) 1
OwlOne
$29
(2) 1
OwlOne
$29
''
7:53
(4) 1
BalletCopper
$29
(3) 1
BalletCopper
$29
''
7:24
(5) 1
DogPortrait
$35
(4) 1
DogPortrait
$35
''
7:24
(6) 1
PalmBrass
$29
''
7:24
(7) 1
NawNameWithPalm
$75
(5) 1
NawNameWithPalm
$75
$0.01 = $261 / 50339.9833 min
6:57
(1)
$0
6:17
(2) 1
DogSketch
$19
10/05/2022 20:12
.
Today I Earned
$255.00
Total I produced $197.00 worth of sculptures, in 97:42 min, $197.00 of sales were custom orders, It Takes 122.4 Minutes to replace those sold
Produced $0.00 since last sale, Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
3) 1
PineappleRose(s)
moved from On_Display too Public there were
"other sales", average is 44,
were displayed, at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
8:50
(1) 1
TurtleCopper19
$19
8:45
(1) 1
TurtleCopper19
$19
''
8:20
(2) 1
MermaidPropeller49
$49
$0 = $69 / 50339.9833 min
7:59
(1) 1
DachshundCopper
$29
''
7:58
(3) 1
DachshundCopper
$29
''
7:40
(4) 1
MarlinPropeller
$49
''
7:32
(5) 1
DogPortrait
$49
(1) 1
DogPortrait
$49
$0 = $199 / 50339.9833 min
6:35
(2) 1
PineappleCopper
$29
6:35
(3) 1
FlamingoOne
$29
6:34
(4) 1
Drums29
$29
6:34
(5) 1
PalmBrass
$29
6:33
(6) 1
SunFaceG
$34
''
4:41
(6) 1
DogPortrait
$35
(2) 1
DogPortrait
$35
$0 = $235 / 50339.9833 min
3:24
(3) 1
SunFaceG
$34
2:05
(4) 1
DragonCopper34
$34
1:15
(5) 1
PineappleRose
$29
12:50
(6) 1
PineappleCopper
$29
12:38
(7) 1
Drums29
$29
12:35
(2)
$0
12:54
(8) 1
FlamingoOne
$29
12:16
(9) 1
PalmBrass
$29
09/03/2022 13:15
.
Today I Earned
$230.00
Total I produced $297.00 worth of sculptures, in 118:67 min, $84.00 of sales were custom orders, It Takes 82.1 Minutes to replace those sold
Produced $0.00 since last sale, Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
4) 1
PineappleRose(s)
moved from WorkShop too Inventory
Make Time Was
average is :12 at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
9:21
(1) 1
BoatSimple
$60
(1) 1
BoatSimple
$60
''
9:21
(2) 1
DogPortrait
$40
(2) 1
DogPortrait
$40
''
9:21
(3) 1
FigureHuman
$29
(3) 1
FigureHuman
$29
''
7:34
(4) 1
NhnRosegold
$0
(4) 1
NhnRosegold
$0
$0 = $132 / 50339.9833 min
7:33
(1) 1
ShihtzuPortrait49
$49
7:33
(2) 1
DragonCopper34
$34
7:33
(3) 1
FishingPoleCopper
$29
7:33
(4) 1
GufCopperFenderGuitar
$34
7:33
(5) 1
ToMoonGold
$29
7:33
(6) 1
PineappleRose
$29
7:33
(7) 1
ChickenCopper34
$34
7:33
(8) 1
PalmCopper
$29
7:33
(9) 1
KwPalmCopper
$29
''
6:50
(5) 1
PineappleGoldGilt
$29
''
6:50
(6) 1
DolphinOne
$34
(5) 1
DolphinOne
$34
$0 = $197 / 50339.9833 min
5:45
(6) 1
DragonCopper34
$34
4:48
(7) 1
PineappleRose
$29
1:29
(8) 1
ToMoonGold
$29
08/29/2022 16:48
.
Today I Earned
$192.00
Total I produced $255.00 worth of sculptures, in 44:67 min, $163.00 of sales were custom orders, It Takes 25.0 Minutes to replace those sold
Produced $0.00 since last sale, plus 4 items with unknown make times Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
5) 1
PineappleRose(s)
moved from Inventory too On_Display
at
on
Venue
Update
Undo?
Void?
6) 1
PineappleRose(s)
moved from WorkShop too Inventory
Make Time Was
average is :12 at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
9:27
(1) 1
CactusOne
$29
(1) 1
CactusOne
$29
''
9:08
(2) 1
MarPwMarlinPinwheel
$49
''
9:08
(3) 2
MerPwMaidPinwheel
$49
''
8:49
(4) 1
OwlOne
$29
''
8:49
(5) 1
PianoCopper
$29
''
8:43
(6) 1
PineappleRose
$29
''
8:43
(7) 1
PalmCopper
$29
''
8:13
(8) 2
ShihtzuPortrait
$35
(2) 2
ShihtzuPortrait
$35
''
7:44
(9) 1
ChickenCopper29
$29
''
7:21
(10) 1
Phrase
$27
(3) 1
Phrase
$27
''
7:21
(11) 1
LogoBusiness
$29
(4) 1
LogoBusiness
$29
$0.01 = $375 / 50339.9833 min
7:20
(1) 1
MerPwMaidPinwheel
$49
7:19
(2) 1
MerPwMaidPinwheel
$49
6:56
(3) 1
PalmCopper
$29
6:56
(4) 1
ToMoonGold
$29
6:56
(5) 1
BoxerPortrait
$35
6:55
(6) 1
FrenchiePortrait
$35
6:55
(7) 1
LabradorPortrait
$35
6:55
(8) 1
PugPortrait
$35
6:21
(5) 2
MerPwMaidPinwheel
$49
4:56
(6) 1
ToMoonGold
$29
4:02
(7) 1
PalmCopper
$29
3:43
(8) 1
NameOne
$13
2:46
(9) 1
PelicanCopper
$29
2:08
(10) 1
FrenchiePortrait
$35
12:30
(11) 1
LabradorPortrait
$35
12:01
(1)
$0
1:12
(12) 1
BoxerPortrait
$35
1:12
(13) 1
PugPortrait
$35
12:07
(14) 1
PigFlyCopper29
$29
07/09/2022 20:43
.
Today I Earned
$447.00
Total I produced $522.00 worth of sculptures, in 248:50 min, $155.00 of sales were custom orders, It Takes 194.8 Minutes to replace those sold
Produced $0.00 since last sale, plus 2 items with unknown make times Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
7) 1
PineappleRose(s)
moved from On_Display too Public there were
"other sales", average is 44,
were displayed, at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
8:39
(1) 1
PineappleRose
$29
8:37
(1) 1
PalmCopper
$29
''
8:04
(2) 1
signLanguageName
$33
(1) 1
signLanguageName
$33
''
8:03
(3) 1
ToMoonGold
$29
$0 = $93 / 50339.9833 min
7:53
(2) 1
PineappleRose
$29
7:14
(2) 1
DragonCopper29
$29
7:14
(3) 1
FlamingoRg
$29
7:14
(4) 1
ILoveYouMomTrippleLevels
$29
7:14
(5) 1
ChickenCopper29
$29
6:06
(3) 1
DragonCopper29
$29
6:05
(4) 1
ChickenCopper29
$29
5:43
(5) 1
FlamingoRg
$29
07/08/2022 19:53
.
Today I Earned
$91.00
Total I produced $149.00 worth of sculptures, in 40:00 min, $33.00 of sales were custom orders, It Takes 33.7 Minutes to replace those sold
Produced $0.00 since last sale, plus 1 items with unknown make times Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
8) 1
PineappleRose(s)
moved from Inventory too On_Display
at
on
Venue
Update
Undo?
Void?
9) 1
PineappleRose(s)
moved from WorkShop too Inventory
Make Time Was
average is :12 at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
9:31
(1) 1
LoveFourHandsCopper
$29
''
9:15
(2) 1
BoxerPortrait
$35
(1) 1
BoxerPortrait
$35
''
9:14
(3) 1
Misc
$0
(2) 1
Misc
$0
''
8:53
(4) 1
BalletCopper
$29
''
8:53
(5) 1
LionFace
$29
''
8:52
(6) 1
PineappleRose
$29
''
8:45
(7) 1
MotorcycleOne
$29
(3) 1
MotorcycleOne
$29
''
8:38
(8) 1
BoxerPortrait
$35
(4) 1
BoxerPortrait
$35
$0 = $222 / 50339.9833 min
8:38
(1)
$0
''
8:29
(9) 1
OwlOne
$29
''
8:19
(10) 1
TurtleBrass19
$19
$0.01 = $272 / 50339.9833 min
8:09
(2) 1
PalmCopper
$29
8:06
(1) 1
ILoveYouMoreTrippleLevel
$29
''
8:06
(11) 1
ILoveYouMoreCopper
$29
$0.01 = $302 / 50339.9833 min
07/01/2022 20:52
.
Today I Earned
$292.00
Total I produced $99.00 worth of sculptures, in 38:67 min, $99.00 of sales were custom orders, It Takes 103.6 Minutes to replace those sold
Produced $0.00 since last sale, plus 2 items with unknown make times Mallory production is $
Click for Day info
Pitch Location:
....Key Drawn:
....Weather:
Pat? (0=N 1=Y):
.... Boat Left
minutes before Sunset :
Comments:
Update
Undo?
Void?
10) 1
PineappleRose(s)
moved from On_Display too Public there were
"other sales", average is 44,
were displayed, at
on
Priced at $
each Venue
Update
Undo?
Void?
11) 1
PineappleRose(s)
moved from Inventory too On_Display
at
on
Venue
Update
Undo?
Void?
12) 1
PineappleRose(s)
moved from WorkShop too Inventory
Make Time Was
average is :12 at
on
Priced at $
each Venue