Seek for Help: How to print out 695 pieces of Attendance Report in batch into PDF file?

New Contributor

Seek for Help: How to print out 695 pieces of attendance report in batch into PDF files?

 

I need to print out 5 pieces of monthly report January-May 2021 for each and every employee.

 

I had developed an attendance reporting spreadsheet but cannot print out 695 pieces of attendance report in batch into PDF files. I need help. 

 

Basic Information:

For your information, following is a simple calculation concerning my need. 

Total Number of Employee = xxx Persons

Total Report for Printing = xxx Persons * 5 Monthly Reports = 695 Monthly Reports (This is the reason why I need to print out 695 Monthly Reports.)


Seek for Help: What do I need? 

Please teach me how to generate 695 pieces of attendance report in batch into PDF files by:

  1. Auto-filling in Month (January, February, March, April, May)
  2. Auto-filling in Division (D1, D2, D3, D4, D5)
  3. Auto-filling in Section (D1S1, D1S2, D1S3, D1S4, D2S1, D2S2, D3S1, D3S2, D3S3….); Remarks: The number of section are not all the same in various division.
  4. Auto-filling in Employee’s Name (D1S1N1, D1S1N2,D1S2N1, D1S2N2, D1S3N1, D1S3N2, D1S4N1, D1S4N2, D2S1N1, D2S1N2, D2S2N1, D2S2N2, D3S1N1, D3S1N2, D3S2N1, D3S2N2, D3S3N1, D3S3N2….); Remarks: The number of employee are not all the same in various section.

 

What I had done? What I am having now?
1. I had developed a frontpage in one of the spreadsheets. I had created several Dynamic Dependent Drop-down Lists in the frontpage. User can select Month, Division, Section and Name in the Frontpage. 

2. I had also developed a Report Page for user to view staff attendance monthly report by selecting Month, Division, Section and Name in the Frontpage. All the necessary formulae are developed, such as:

2.1 =VLOOKUP(C6,staff!B1:D140,2,FALSE)

2.2 =VLOOKUP(C6,staff!B1:D140,3,FALSE)

2.3 =min(FILTER(hadir!$E$2:$E$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Masuk")*(hadir!$C$2:$C$9531=A11)))

2.4 =max(FILTER(hadir!$E$2:$E$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

2.5 =D11-C11-TIME(1,0,0)

2.6 =UNIQUE(FILTER(hadir!$G$2:$G$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Masuk")*(hadir!$C$2:$C$9531=A11)))

2.7 =UNIQUE(FILTER(hadir!$G$2:$G$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

2.8 =UNIQUE(FILTER(hadir!$G$2:$G$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

2.9 =UNIQUE(FILTER(hadir!$L$2:$L$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Masuk")*(hadir!$C$2:$C$9531=A11)))

2.10 =UNIQUE(FILTER(hadir!$L$2:$L$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

3. All necessary data and formulae are in place. 

Screenshot 1: Frontpage in Spreadsheet

raymondngu_0-1624029660885.png

 

Screenshot 2: Report Page in Spreadsheet

raymondngu_1-1624029737195.png

 

SharePoint Online

Developer

OneDrive

Files

 

0 Replies