Spreadsheet: 876944d1723651833-let-vstack-formula-what-am-i-doing-wrong-example111
Sheet: ActualDays

 | Period
 | 2024-07-01 00:00:00
 | 2024-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2177 | 0
ID | Employee | Prov. Type | Status | Contractual days worked | Actual days worked | No. of workdays | Daily Rate? | State | On-call | Non-Elig. IN Prov? | Start Date | Term Date | Method | Threshold | Jul | Amount
BABA9EE2-B847-4E25-890D-08DCA4F5FD5B | Bogdanowicz, [NAME] | PA | Active | 2 | 1 | 23 | Yes |  | No |  |  |  | ActualDays | 27.17391304347826 | 1 | 0
[PHONE]-4B31-3529-08DC6F92579C | Cooke, [NAME] | NP | Active | 2 | 1 | 23 | Yes |  | No |  |  |  | ActualDays | 27.17391304347826 | 9 | 0
E5A656A9-714C-4951-8E05-08DC558239EA | Cortes, Frances | NP | Active | 2 | 5 | 23 | Yes |  | No |  |  |  | ActualDays | 135.8695652173913 | 34 | 0
CE25E851-AC04-4C39-7843-08DC318861FD | Gallaway, Rebecca | NP | Active | 2 | 8 | 23 | Yes |  | No |  |  |  | ActualDays | 217.3913043478261 | 29 | 0
68739497-15FA-42CB-EC9D-08DC37B12A18 | [NAME], Grayce | NP | Active | 2 | 9 | 23 | Yes |  | No |  |  |  | ActualDays | 244.5652173913044 | 73 | 0
1EFA5313-5520-46E5-F1D2-08DC279EE45B | Ivy, Mellissa | NP | Active | 1 | 4 | 23 | Yes |  | No |  |  |  | ActualDays | 108.695652173913 | 30 | 0
F8E427D3-0E49-4423-1E79-08DC279E5735 | Jelks, [NAME] | NP | Active | 2 | 9 | 23 | Yes |  | No |  |  |  | ActualDays | 244.5652173913044 | 135 | 0
59A0089B-DDF8-4820-D2F9-08DC80DDDFA0 | [NAME], [NAME] | NP | Active | 2 | 11 | 23 | Yes |  | No |  |  |  | ActualDays | 298.9130434782609 | 142 | 0
2948E933-64F5-433D-0460-08DB828FC75B | [NAME], Gibril | NP | Active | 3 | 13 | 23 | Yes |  | No |  |  |  | ActualDays | 353.2608695652174 | 239 | 0
0A06D423-568C-4B4B-CBF1-08DC37AE9859 | Kaur, Ramandeep | NP | Active | 3 | 13 | 23 | Yes |  | No |  |  |  | ActualDays | 353.2608695652174 | 160 | 0
AE84FBD2-4153-4BBC-8E99-08DC6DF52C47 | Kaur, Sarabjit | NP | Active | 2 | 6 | 23 | Yes |  | No |  |  |  | ActualDays | 163.0434782608696 | 61 | 0
F5FD400C-1000-48DE-9AA6-08DB8EADBFCE | Keya, Dominic | NP | Active | 3 | 10 | 23 | Yes |  | No |  |  |  | ActualDays | 271.7391304347826 | 109 | 0
4B9C6837-781E-4FD8-C56C-08DC48EA20BD | Kwon, [NAME] | NP | Active | 3 | 12 | 23 | Yes |  | No |  |  |  | ActualDays | 326.0869565217391 | 44 | 0
[NAME] | McKenzie, [NAME] | NP | Active | 2 | 8 | 23 | Yes |  | No |  |  |  | ActualDays | 217.3913043478261 | 95 | 0
428205d3-536d-4e13-f4a1-08dc1bd678bf | Medina, [NAME] | NP | Active | 0 | 19 | 23 | Yes |  | Yes |  |  |  | ActualDays | 516.304347826087 | 122 | 0
8AE1A863-011E-4C99-4115-08DC6540E574 | [NAME], [NAME] | NP | Active | 3 | 14 | 23 | Yes |  | No |  |  |  | ActualDays | 380.4347826086957 | 131 | 0
97B3BE83-3DD6-4202-B021-08DCA4FB1C1E | Niyati, Saeed | NP | Active | 5 | 3 | 23 | Yes |  | No |  |  |  | ActualDays | 81.52173913043478 | 15 | 0
119B59BA-81AD-4B5F-C5D8-08DC86614007 | Njunge, [NAME] | NP | Active | 0 | 2 | 23 | Yes |  | Yes |  |  |  | ActualDays | 54.34782608695652 | 5 | 0
EFD0C50E-CAC8-4CB6-E1B3-08DB65FEAB89 | Oliveira, Adrienne | NP | Active | 3 | 14 | 23 | Yes |  | No |  |  |  | ActualDays | 380.4347826086957 | 291 | 0
3951E4D2-D2C7-4E39-2B3A-08DC790CC46A | Saint-Amand, Beverly | NP | Active | 2 | 3 | 23 | Yes |  | No |  |  |  | ActualDays | 81.52173913043478 | 44 | 0
6C7E59F9-F235-403E-5987-08DC62FB7BB1 | Sanders, Heather | NP | Active | 0 | 15 | 23 | Yes |  | Yes |  |  |  | ActualDays | 407.6086956521739 | 92 | 0
DFD80BC0-0FAD-4DF9-2910-08DC43765A90 | Trino, [NAME] | NP | Active | 0 | 3 | 23 | Yes |  | Yes |  |  |  | ActualDays | 81.52173913043478 | 20 | 0
BE6BF265-D81B-410F-4E37-08DC27A0011D | [NAME], Donis | NP | Active | 3 | 12 | 23 | Yes |  | No |  |  |  | ActualDays | 326.0869565217391 | 237 | 0
7BEA1892-D8F3-45EA-77BB-08DC62FD78F4 | Wamukoya, [NAME] | NP | Active | 2 | 8 | 23 | Yes |  | No |  |  |  | ActualDays | 217.3913043478261 | 45 | 0
D8A15EF2-7659-44DF-59F9-08DC802166B3 | Youngs, Valrie | NP | Active | 1 | 5 | 23 | Yes |  | No |  |  |  | ActualDays | 135.8695652173913 | 14 | 0