Spreadsheet: 713162d1610572148-pivot-summarize-services-for-client-and-net-profits-calculation-example
Sheet: Timesheet

Resource Name | Work Date | WIP Hours | Original WIP Value EC | Original Accrual Posted EC | Discount % | Gross Revenue | Eng. Currency | Net WIP EC | Client | Services
Employee A | 2020-09-09 00:00:00 | -0.5 | -121 | 0 | 60 | -302.5 | CHF | -121 | Customer A | Tax Return
Employee A | 2020-09-10 00:00:00 | 0.5 | 121 | 0 | 60 | 302.5 | CHF | 121 | Customer A | Tax Return
Employee A | 2020-09-10 00:00:00 | 1.73 | 418.66 | 0 | 60 | 1046.65 | CHF | 418.66 | Customer A | Tax Return
Employee A | 2020-09-10 00:00:00 | 1.25 | 122.5 | 0 | 60 | 306.25 | CHF | 122.5 | Customer A | Tax Return
Employee A | 2020-09-10 00:00:00 | 0.17 | 16.66 | 0 | 60 | 41.65 | CHF | 16.66 | Customer A | [NAME] (PoA/Ablagen/Mails/etc)
Employee A | 2020-07-20 00:00:00 | 0.17 | 16.66 | 0 | 60 | 41.65 | CHF | 16.66 | Customer A | [NAME] (PoA/Ablagen/Mails/etc)
Employee B | 2020-09-14 00:00:00 | 0.47 | 46.06 | 0 | 60 | 115.15 | CHF | 46.06 | Customer A | Amended Tax Return
Employee B | 2020-06-25 00:00:00 | 0.47 | 86.48 | 0 | 60 | 216.2 | CHF | 86.48 | Customer A | Amended Tax Return
Employee B | 2020-07-13 00:00:00 | 0.3 | 39.6 | 0 | 60 | 99 | CHF | 39.6 | Customer A | Tax Assessment
Employee B | 2020-07-30 00:00:00 | 1.75 | 171.5 | 0 | 60 | 428.75 | CHF | 171.5 | Customer A | Tax Return
Employee B | 2020-09-15 00:00:00 | 0.26 | 62.92 | 0 | 60 | 157.3 | CHF | 62.92 | Customer A | Tax Return
Employee A | 2020-10-01 00:00:00 | 0.64 | 154.88 | 0 | 60 | 387.2 | CHF | 154.88 | Customer B | Tax Return
Employee A | 2020-07-31 00:00:00 | 0.19 | 18.62 | 0 | 60 | 46.55 | CHF | 18.62 | Customer B | Tax Return
Employee A | 2020-09-15 00:00:00 | 0.3 | 72.6 | 0 | 60 | 181.5 | CHF | 72.6 | Customer B | Tax Return
Employee B | 2020-09-30 00:00:00 | 0.5 | 244 | 0 | 60 | 610 | CHF | 244 | Customer B | Tax Return
Employee B | 2020-07-30 00:00:00 | 2.87 | 281.26 | 0 | 60 | 703.15 | CHF | 281.26 | Customer B | Tax Return
Employee B | 2020-07-31 00:00:00 | 0.32 | 31.36 | 0 | 60 | 78.4 | CHF | 31.36 | Customer B | Tax Return
Employee B | 2020-07-27 00:00:00 | 0.75 | 73.5 | 0 | 60 | 183.75 | CHF | 73.5 | Customer B | [NAME] / cannot be allocated
Employee B | 2020-07-29 00:00:00 | 0.16 | 78.08 | 0 | 60 | 195.2 | CHF | 78.08 | Customer B | Tax Assessment
Employee A | 2020-11-11 00:00:00 | 0.19 | 92.72 | 0 | 60 | 231.8 | CHF | 92.72 | Customer C | Tax Return
Employee B | 2020-05-25 00:00:00 | 0.12 | 58.56 | 0 | 60 | 146.4 | CHF | 0 | Customer C | OOSC
Employee B | 2020-11-17 00:00:00 | 0.06 | 29.28 | 0 | 60 | 73.2 | CHF | 29.28 | Customer C | OOSC
Employee B | 2020-12-21 00:00:00 | 0.05 | 12.1 | 0 | 60 | 30.25 | CHF | 12.1 | Customer C | Tax Meeting
Employee A | 2020-09-17 00:00:00 | 0.24 | 58.08 | 0 | 60 | 145.2 | CHF | 58.08 | Customer C | Tax Meeting
Employee A | 2020-12-04 00:00:00 | 0.23 | 55.66 | 0 | 60 | 139.15 | CHF | 55.66 | Customer C | Tax Meeting
Employee A | 2020-12-17 00:00:00 | 0.75 | 181.5 | 0 | 60 | 453.75 | CHF | 181.5 | Customer C | Tax Meeting
Employee A | 2020-05-19 00:00:00 | 0.3 | 55.2 | 0 | 60 | 138 | CHF | 0 | Customer D | Tax Return
Employee B | 2020-08-19 00:00:00 | 0.2 | 26.4 | 0 | 60 | 66 | CHF | 26.4 | Customer D | [NAME] (PoA/Ablagen/Mails/etc)
Employee B | 2020-08-20 00:00:00 | 0.31 | 57.04 | 0 | 60 | 142.6 | CHF | 57.04 | Customer D | OOSC
Employee B | 2020-09-03 00:00:00 | 0.57 | 137.94 | 0 | 60 | 344.85 | CHF | 137.94 | Customer D | [NAME] / cannot be allocated
Employee B | 2020-10-23 00:00:00 | 1 | 98 | 0 | 60 | 245 | CHF | 98 | Customer D | Tax Assessment
Employee A | 2020-10-07 00:00:00 | 0.64 | 62.72 | 0 | 60 | 156.8 | CHF | 62.72 | Customer D | Tax Assessment
Employee A | 2020-10-12 00:00:00 | 0.2 | 36.8 | 0 | 60 | 92 | CHF | 36.8 | Customer D | Tax Assessment