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)
DrumsOne
(1472)
$0.00
133.500
1
3
0
1)
DrumsOne
(1472)
$2.92
27.00
1.44
0.00
Description words
Group Summery
Drums29 earns $8.68 at $29.00 St=0
DrumsCymbolsBrass39 earns $5.71 at $39.00 St=0
Drums39 earns $4.67 at $39.00 St=0
DrumsOne earns $2.92 at $39.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....
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 12:35
.
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?
at
on
Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
9:11
(1) 1
NameOne
$15
(1) 1
NameOne
$15
''
8:53
(2) 1
DragonCopper29
$29
''
8:34
(3) 1
AirplanePropeller49
$49
''
8:34
(4) 1
DrumsOne
$39
''
8:34
(5) 1
HorseCopper
$29
''
8:15
(6) 1
FlamingoRg
$29
''
8:15
(7) 1
LionFace
$29
''
8:05
(8) 1
TurtleCopper19
$19
''
7:53
(9) 1
NameOne
$12
(2) 1
NameOne
$12
''
7:49
(10) 1
PigFlyCopper34
$34
''
7:34
(11) 1
Phrase
$10
(3) 1
Phrase
$10
''
7:19
(12) 1
Phrase
$13
(4) 1
Phrase
$13
''
7:19
(13) 1
CatPortrait
$35
''
7:19
(14) 1
FigureHuman
$20
(5) 1
FigureHuman
$20
$0.01 = $375 / 50339.9833 min
6:50
(1) 1
ILoveYouMoreTrippleLevel
$29
6:49
(1) 1
ILoveYouMoreCopper
$29
6:49
(2) 1
PianoCopper
$29
6:49
(3) 1
ILoveYouMomFour
$29
6:10
(6) 1
ILoveYouMomFour
$29
5:47
(7) 1
ILoveYouMoreTrippleLevel
$29
5:27
(8) 1
PianoCopper
$29
07/16/2022 20:34
.
Today I Earned
$362.00
Total I produced $157.00 worth of sculptures, in 127:50 min, $70.00 of sales were custom orders, It Takes 207.0 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?
2) 1
DrumsOne(s)
moved from On_Display too Public there were
"other sales", average is 134,
were displayed, at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
9:53
(1)
$0
9:50
(1) 1
DragonCopper29
$29
9:49
(2)
$0
9:48
(1) 1
DogSketch
$10
''
9:47
(2) 1
BoxerPortrait
$35
''
9:47
(3) 1
OwlOne
$29
$0 = $76 / 50339.9833 min
9:46
(3) 1
DachHappy
$29
''
9:27
(4) 1
DachHappy
$29
(2) 1
DachHappy
$29
''
9:19
(5) 1
DachHappy
$29
$0 = $136 / 50339.9833 min
8:34
(4)
$0
8:28
(5)
$0
8:25
(1) 1
ILoveYouTrippleLevels
$29
(3) 1
ILoveYouTrippleLevels
$29
8:09
(6) 2
PineappleBrass
$29
8:09
(7)
$0
''
8:07
(6) 1
FrenchiePortrait
$35
''
8:07
(7) 1
BulldogPortrait
$35
''
8:03
(8) 1
ILoveYouMom
$29
$0 = $238 / 50339.9833 min
7:55
(2) 1
ILoveYouFour19
$19
(4) 1
ILoveYouFour19
$19
7:51
(3) 1
ILoveYouFourRose
$24
(5) 1
ILoveYouFourRose
$24
''
7:00
(9) 3
NameOne
$11
(6) 3
NameOne
$11
''
7:00
(10) 1
Shark
$10
(7) 1
Shark
$10
$0.01 = $263.33 / 50339.9833 min
6:57
(4) 1
DrumsOne
$39
6:57
(5) 1
CatPortrait
$35
6:56
(8) 1
CatPortrait
$35
6:56
(6) 1
PianoCopper
$29
6:56
(7) 1
PelicanCopper
$29
6:56
(8) 1
ToMoonGold
$29
6:56
(9) 1
FishingPoleCopper
$29
5:33
(8)
$0
5:04
(9) 1
DrumsOne
$39
3:51
(10) 1
PelicanCopper
$29
3:16
(11) 1
PianoCopper
$29
1:52
(10) 1
PineappleGoldGilt
$29
1:51
(9) 1
PineappleBrass
$29
1:51
(12) 1
PineappleGoldGilt
$29
1:50
(13) 1
ToMoonGold
$29
1:04
(14) 1
FishingPoleCopper
$29
06/15/2022 17:04
.
Today I Earned
$274.99
Total I produced $392.99 worth of sculptures, in 116:33 min, $72.99 of sales were custom orders, It Takes 72.2 Minutes to replace those sold
Produced $0.00 since last sale, plus 3 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?
3) 1
DrumsOne(s)
moved from Inventory too On_Display
at
on
Venue
Update
Undo?
Void?
4) 1
DrumsOne(s)
moved from WorkShop too Inventory
Make Time Was
average is :27 at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
9:11
(1) 1
PalmGold
$29
''
9:11
(2) 1
MerPwMaidPinwheel
$49
''
9:10
(3) 1
ILoveYouRg
$24
$0 = $104 / 50339.9833 min
8:58
(1) 1
PianoCopper
$29
''
8:56
(4) 1
RedFishTwo
$36
(1) 1
RedFishTwo
$36
''
8:34
(5) 1
DrumsOne
$29
''
8:34
(6) 1
PianoCopper
$29
''
8:34
(7) 1
CartoonCharacter
$29
(2) 1
CartoonCharacter
$29
$0 = $231 / 50339.9833 min
8:28
(1)
$0
8:27
(2) 1
PalmCopper
$29
''
8:11
(8) 1
NawNameWithPalm
$75
(3) 1
NawNameWithPalm
$75
''
7:22
(9) 1
BassFiddle
$29
(4) 1
BassFiddle
$29
$0.01 = $337 / 50339.9833 min
7:03
(3) 2
MarPwMarlinPinwheel
$49
7:02
(4) 1
ChickenCopper29
$29
7:02
(5) 1
HorseCopper
$29
7:02
(6) 1
DogSketch
$10
6:59
(7) 1
PalmGold
$29
6:58
(8) 1
LabradorPortrait
$35
4:59
(5) 1
HorseCopper
$29
4:40
(6) 1
PalmGold
$29
4:16
(7) 2
MarPwMarlinPinwheel
$49
2:02
(8) 1
DogSketch
$10
1:50
(9) 1
LabradorPortrait
$35
06/12/2022 20:34
.
Today I Earned
$329.00
Total I produced $370.00 worth of sculptures, in 130:67 min, $169.00 of sales were custom orders, It Takes 125.0 Minutes to replace those sold
Produced $0.00 since last sale, plus 3 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
DrumsOne(s)
moved from On_Display too Public there were
"other sales", average is 134,
were displayed, at
on
Priced at $
each Venue
Summery
Of
Day
...
....Sale....
....Stock....
....Made....
....Other....
....Rate....
9:41
(1) 1
ILoveYouMom
$29
9:14
(2) 1
ILoveYouMoreRose
$29
9:14
(1) 1
PalmBrass
$29
$0 = $29 / 50339.9833 min
8:56
(1) 1
DrumsOne
$29
(3) 1
DrumsOne
$29
''
8:31
(2) 1
ILoveYouMom
$29
$0 = $59 / 50339.9833 min
7:31
(4) 1
PianoCopper
$29
6:55
(2) 1
ToMoonGold
$29
6:55
(3) 1
PalmGold
$29
6:55
(4) 1
ILoveYouMom
$29
6:55
(5) 1
UnicornCopper
$29
6:54
(6) 1
DogSketch
$18
6:54
(1)
$0
6:54
(7) 1
FishingPoleBass
$29
(5) 1
FishingPoleBass
$29
6:53
(8) 1
SignLanguageLoveCopper
$29
6:52
(9) 1
PalmBrass
$29
6:44
(6) 2
FishingPoleCopper
$29
12:38
(7) 1
ToMoonGold
$29
12:15
(8) 1
DogSketch
$15
11:12
(9) 1
ToMoonG
$29
10:35
(10) 1
UnicornCopper
$29
06/08/2022 20:56
.
Today I Earned
$58.00
Total I produced $305.00 worth of sculptures, in 120:00 min, $0.00 of sales were custom orders, It Takes 22.5 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?
6) 1
DrumsOne(s)
moved from WorkShop too On_Display
Make Time Was
average is :27 at
on
Priced at $
each Venue
Update
Undo?
Void?
7) 1
DrumsOne(s)
moved from WorkShop too Public
were displayed, Make Time Was
average is :27 at
on
Priced at $
each Venue
Custom order took 6:41