CSV
#ReserveSample
Sample <- read.csv("ReserveSample.csv", header = TRUE, stringsAsFactors = FALSE)
kable(head(Sample, 20))
|
|
|
|
$4,479,861.00 |
$4,015,950.00 |
$193,086.61 |
|
|
$165,000.00 |
85.45% |
|
|
|
Requirement for 10 Day Supply |
|
|
|
|
|
15 Usage |
16 Usage |
2 Mos |
|
|
|
|
|
|
|
|
|
|
Item # |
Description |
Pack |
August |
Sept |
Daily Avg |
|
|
Proj Daily |
10/28/2016 |
Inventory |
Held for |
Days on Order |
|
|
|
|
|
Qty |
23 |
21 |
44 |
safety |
Part |
Usage |
Inv On Hand |
On Order |
Reserve |
or on Hand |
|
ORDER |
| B |
SS02CLR7284 |
3/32 CLEAR 72 X 84 |
110 |
1255 |
1146 |
54.6 |
1.2 |
A |
56 |
78 |
761 |
|
15 |
0 |
|
| 2 |
SS02LOE7284 |
3/32 ENEG ADV LOW-E 72 x 84 |
110 |
262 |
261 |
11.9 |
1.2 |
B |
Reorder at 110 sheets |
41 |
106 |
|
#VALUE! |
#VALUE! |
|
| 2.5 |
SS02LE37284 |
3/32 COMFORT E-PS LOWE 72x84 |
110 |
|
102 |
2.3 |
1.2 |
B |
2.4 |
|
|
|
0 |
24 |
|
| 3 |
SS02LOE7284 |
3/32 ENEG ADV LOW-E 72 x 84 |
|
|
102 |
2.3 |
1.2 |
B |
2.4 |
|
|
|
0 |
24 |
|
| 3.2 |
SS0LCLR4884 |
2.7MM CLEAR 48X84 |
105 |
|
|
|
1 |
B |
Reorder at 105 sheets |
86 |
|
|
#VALUE! |
#VALUE! |
|
| 3.3 |
SS0LCLR4896 |
2.7MM CLEAR 48X96 |
92 |
|
2 |
|
1 |
B |
Reorder at 184 sheets |
220 |
|
|
#VALUE! |
#VALUE! |
|
| 3.5 |
SS0LCLR7284 |
2.7MM CLEAR 72X84 |
55 |
98 |
66 |
3.7 |
1 |
B |
Reorder at 110 sheets |
162 |
|
|
#VALUE! |
#VALUE! |
|
| 4 |
SS03ACC7284 |
1/8 ACCLIMATE 72X84 |
90 |
24 |
9 |
0.8 |
1.2 |
C |
0.8 |
40 |
|
|
-6.5 |
13 |
|
| 5 |
SS03BRN4884 |
1/8 BRONZE 48X84 |
|
|
|
0 |
1 |
|
0 |
|
|
|
#DIV/0! |
#DIV/0! |
|
| 6 |
SS03BRN7284 |
1/8 BRONZE 96 X 130 |
30 |
21 |
29 |
1.1 |
1 |
B |
1 |
33 |
28 |
|
62.8 |
|
|
| 7 |
SS03BRN7284 |
1/8 BRONZE 72X84 |
|
|
|
0 |
1 |
|
0 |
|
|
|
#DIV/0! |
#DIV/0! |
|
| 8 |
SS03CLR7284 |
1/8 CLEAR 72X84 |
90 |
|
1150 |
26.1 |
1.2 |
A |
26.8 |
|
|
19 |
-0.7 |
287 |
|
| 8.5 |
SS03CLR96130 |
1/8 CLEAR 96X130 |
30 |
1107 |
1030 |
48.6 |
1.2 |
A |
49.8 |
383 |
270 |
|
13.1 |
|
|
| 9 |
SS03DHT7284 |
1/8 ACCLIMATE HT 72X84 |
90 |
139 |
141 |
6.4 |
1.2 |
B |
Reorder at 130 sheets |
34 |
108 |
|
#VALUE! |
#VALUE! |
|
| 10 |
SS03FRS6596 |
1/8 ACID ETCH 65X96 |
80 |
21 |
17 |
0.9 |
1 |
C |
0.7 |
63 |
|
|
24.4 |
|
|
| 11 |
SS03LE27284 |
1/8 COMFORT E2 LOWE 72X84 |
90 |
|
|
NA |
1 |
|
#VALUE! |
|
|
|
#VALUE! |
NA |
|
str(Sample)
## 'data.frame': 144 obs. of 16 variables:
## $ X : chr "" "" "" "" ...
## $ X.1 : chr "" "" "Item #" "" ...
## $ X.2 : chr "" "" "Description" "" ...
## $ X.3 : chr "" "" "Pack" "Qty" ...
## $ Invoiced.FG.SH : chr "$4,479,861.00 " " 15 Usage" "August" "23" ...
## $ Invoiced.FG.SH.1 : chr "$4,015,950.00 " " 16 Usage" "Sept" "21" ...
## $ X2.mos.Daily.Avg : chr "$193,086.61 " "2 Mos" "Daily Avg" "44" ...
## $ X.4 : chr "" "" "" "safety" ...
## $ X.5 : chr "" "" "" "Part" ...
## $ Projected.Daily.Avg: chr "$165,000.00 " "" "Proj Daily " "Usage" ...
## $ Daily...Change : chr "85.45%" "" "10/28/2016" "Inv On Hand" ...
## $ X.6 : chr "" "" "Inventory" "On Order" ...
## $ X.7 : chr "" "" "Held for " "Reserve" ...
## $ X.8 : chr "" "" "Days on Order" "or on Hand" ...
## $ X.9 : chr "Requirement for 10 Day Supply" "" "" "" ...
## $ X.10 : chr "" "" "" "ORDER" ...
Excel
library(readxl)
Jan <- read_excel("ReserveSampleJan.xls")
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 06 3b 00 00 00 00 8c 00 00 00 0f 00
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 07 3b 00 00 03 00 04 00 00 00 ff 00
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 06 3b 00 00 00 00 8c 00 00 00 0f 00
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 07 3b 00 00 03 00 04 00 00 00 ff 00
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 06 3b 00 00 00 00 8c 00 00 00 0f 00
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 07 3b 00 00 03 00 04 00 00 00 ff 00
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 06 3b 00 00 00 00 8c 00 00 00 0f 00
## DEFINEDNAME: 20 00 00 01 0b 00 00 00 01 00 00 00 00 00 00 07 3b 00 00 03 00 04 00 00 00 ff 00
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
## Unknown type: 517
kable(head(Jan, 20))
| NA |
NA |
NA |
NA |
3431111.000000 |
3172456.000000 |
161062.609756 |
NA |
NA |
105000.000000 |
0.651920 |
NA |
NA |
NA |
Requirement for 10 Day Supply |
NA |
| NA |
NA |
NA |
NA |
15 Usage |
15 Usage |
2 Mos |
NA |
NA |
NA |
NA |
NA |
NA |
NA |
NA |
NA |
| NA |
Item # |
Description |
Pack |
Dec |
Nov |
Daily Avg |
NA |
NA |
Proj Daily |
42384.000000 |
Inventory |
Held for |
Days on Order |
NA |
NA |
| NA |
NA |
NA |
Qty |
22.000000 |
19.000000 |
41.000000 |
safety |
Part |
Usage |
Inv On Hand |
On Order |
Reserve |
or on Hand |
NA |
ORDER |
| 1.0 |
SS02CLR7284 |
3/32 CLEAR 72 X 84 |
110.000000 |
699.000000 |
904.000000 |
39.097561 |
1.200000 |
A |
30.586197 |
375.000000 |
NA |
NA |
12.260432 |
0.000000 |
NA |
| 2.0 |
SS02LOE7284 |
3/32 ENEG ADV LOW-E 72 x 84 |
110.000000 |
134.000000 |
208.000000 |
8.341463 |
1.200000 |
B |
6.525564 |
86.000000 |
NA |
NA |
13.178937 |
|
NA |
| 2.5 |
SS02LE37284 |
3/32 COMFORT E-PS LOWE 72x84 |
110.000000 |
NA |
NA |
0.000000 |
1.000000 |
NA |
0.000000 |
NA |
NA |
NA |
error |
error |
NA |
| 3.0 |
SS02LOE7284 |
3/32 ENEG ADV LOW-E 72 x 84 |
NA |
NA |
NA |
0.000000 |
1.000000 |
NA |
0.000000 |
NA |
NA |
NA |
error |
error |
NA |
| 4.0 |
SS03ACC7284 |
1/8 ACCLIMATE 72X84 |
90.000000 |
10.000000 |
14.000000 |
0.585366 |
1.200000 |
C |
0.457934 |
141.000000 |
NA |
NA |
209.637048 |
|
NA |
| 5.0 |
SS03BRN4884 |
1/8 BRONZE 48X84 |
NA |
NA |
NA |
0.000000 |
1.000000 |
NA |
0.000000 |
NA |
NA |
NA |
error |
error |
NA |
| 6.0 |
SS03BRN7284 |
1/8 BRONZE 72 X 84 |
70.000000 |
62.000000 |
46.000000 |
2.634146 |
1.000000 |
B |
1.717254 |
99.000000 |
NA |
NA |
57.650188 |
|
NA |
| 7.0 |
SS03BRN7284 |
1/8 BRONZE 72X84 |
NA |
NA |
NA |
0.000000 |
1.000000 |
NA |
0.000000 |
NA |
NA |
NA |
error |
error |
NA |
| 8.0 |
SS03CLR7284 |
1/8 CLEAR 72X84 |
90.000000 |
1370.000000 |
1731.000000 |
75.634146 |
1.200000 |
A |
59.168931 |
585.000000 |
NA |
NA |
9.886946 |
6.689310 |
NA |
| 9.0 |
SS03DHT7284 |
1/8 ACCLIMATE HT 72X84 |
90.000000 |
22.000000 |
152.000000 |
4.243902 |
1.200000 |
B |
3.320024 |
75.000000 |
NA |
NA |
9.036080 |
3.200239 |
NA |
| 10.0 |
SS03FRS6596 |
1/8 ACID ETCH 65X96 |
80.000000 |
11.000000 |
10.000000 |
0.512195 |
1.000000 |
C |
0.333910 |
37.000000 |
NA |
NA |
-23.958520 |
11.339104 |
NA |
| 11.0 |
SS03LE27284 |
1/8 COMFORT E2 LOWE 72X84 |
90.000000 |
NA |
NA |
NA |
1.000000 |
NA |
error |
NA |
NA |
NA |
error |
NA |
NA |
| 12.0 |
SS03GLC4860 |
1/8 GLUE CHIP 48X84 |
84.000000 |
NA |
NA |
0.000000 |
1.000000 |
NA |
0.000000 |
NA |
NA |
NA |
error |
error |
NA |
| 12.5 |
SS03GLC4860 |
1/8 GLUE CHIP 48X60 |
122.000000 |
NA |
NA |
0.000000 |
1.000000 |
NA |
0.000000 |
NA |
NA |
NA |
error |
error |
NA |
| 12.7 |
SS03GLC6084 |
1/8 GLUE CHIP 60X84 |
76.000000 |
1.000000 |
4.000000 |
0.121951 |
1.000000 |
C |
0.079502 |
0.000000 |
NA |
NA |
0.000000 |
0.795025 |
NA |
| 13.0 |
SS03GRY4884 |
1/8 GREY 48X84 |
85.000000 |
NA |
NA |
0.000000 |
1.000000 |
NA |
0.000000 |
NA |
NA |
NA |
error |
error |
NA |
str(Jan)
## Classes 'tbl_df', 'tbl' and 'data.frame': 742 obs. of 16 variables:
## $ : num NA NA NA NA 1 2 2.5 3 4 5 ...
## $ : chr NA NA "Item #" NA ...
## $ : chr NA NA "Description" NA ...
## $ : chr NA NA "Pack" "Qty" ...
## $ Invoiced FG+SH : chr "3431111.000000" " 15 Usage" "Dec" "22.000000" ...
## $ Invoiced FG+SH : chr "3172456.000000" " 15 Usage" "Nov" "19.000000" ...
## $ 2 mos Daily Avg : chr "161062.609756" "2 Mos" "Daily Avg" "41.000000" ...
## $ : chr NA NA NA "safety" ...
## $ : chr NA NA NA "Part" ...
## $ Projected Daily Avg: chr "105000.000000" NA "Proj Daily " "Usage" ...
## $ Daily % Change : chr "0.651920" NA "42384.000000" "Inv On Hand" ...
## $ : chr NA NA "Inventory" "On Order" ...
## $ : chr NA NA "Held for " "Reserve" ...
## $ : chr NA NA "Days on Order" "or on Hand" ...
## $ : chr "Requirement for 10 Day Supply" NA NA NA ...
## $ NA : chr NA NA NA "ORDER" ...