File size: 3,754 Bytes
02dad28
 
 
 
3dd785b
02dad28
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
3dd785b
 
 
02dad28
 
 
 
 
 
6fc7f47
02dad28
 
3dd785b
 
02dad28
 
 
 
 
3dd785b
 
 
6fc7f47
 
 
 
 
 
 
 
 
3dd785b
6fc7f47
 
3dd785b
6fc7f47
 
 
 
 
 
 
 
 
 
 
 
 
 
3dd785b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
6fc7f47
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
#OpenAI Variables
gpt_model = "gpt-3.5-turbo"

#Company Specfic Variables
char_remove = ["N/A", "(Use additional sheet if necessary)", "(not provided)", "Not specified", "-||-", "0 sq.m.", "(not provided in text)"]

#Company Documents
RPFAAP2 = '''
        Desired Format:         
        Additional Items: -||-
        Unit Construction Cost (P):  <Monetary Value>
        Sub-Total (P):  <Monetary Value>
        Depreciation Rate:  -||-
        Depreciation Cost (P):  <Monetary Value>
        Cost of Additional Items:  -||-
        Total Construction Cost:  -||-
        Total Percentage Depreciation:  -||-
        Market Value (P):  <Monetary Value>
        Actual Use:  -||-
        Market Value (P):  <Monetary Value>
        Assessment Level:  -||-
        Assessed Value (P):  <Monetary Value>
        Effectivity of Assessment/Reassessment:  -||-
        Memoranda:  -||-
        Date of Entry in the Record of Assessment:  -||-
        Name:  -||-
        PIN:  <Numerical Value Only>
        ARP No.:  <Numerical Value Only>
        TD No.:  <Numerical Value Only>
        Total Assessed Value:  -||-
        Previous Owner:  <Person's Name>
        Effectivity of Assessment:  -||-
        Record Person:  <Person's Name>
        Date:  -||-
        '''

RPFAAP1 = '''
        Desired Format: 
        ARP No.: <Numerical Value Only>
        OWNER: <Person's Name>
        Address: -||-
        Tel No.: -||-
        Administrator/Beneficial User: -||-
        Address: -||-
        Tel No.: -||-
        PIN: <Numerical Value Only>
        TIN_1: <Numerical Value Only>
        TIN_2: <Numerical Value Only>
        No. / Street: -||-
        Brgy/District: -||-
        Municipality: -||-
        Province/city: -||-
        Owner: <Person's Name>
        OCT/TCT/CLOA No.: -||-
        Lot No.: -||-
        Survey No.: -||-
        Blk No.: -||-
        TD/ARP No.: <Numerical Value Only>
        Area: <Area in SQ.M.>
        Kind of Bldg.: -||-
        Structural Type: <Roman Numerals Only>
        Bldg. Permit No.: -||-
        Date Issued: -||-
        Condominium Certificate of Title(CCT): -||-
        Certificate of Completion Issued on: -||-
        Certificate of Occupancy Issued on: -||-
        Date Constructed/Completed: -||-
        Date Occupied: -||-
        Bldg. Age: -||-
        No. of Storeys: -||-
        Area of 1st Flr: <Numerical Value in SQ.M.>
        Area of 2nd Flr: <Numerical Value in SQ.M.>
        Area of 3rd Flr: <Numerical Value in SQ.M.>
        Area of 4th Flr: <Numerical Value in SQ.M.>
        Total Floor Area: <Numerical Value in SQ.M.>
        '''

TDRP = '''
        Desired Format: 
        TD No.: -||-
        Property Identification No.: -||-
        Owner: -||-
        TIN_1: -||-
        Address_1: -||-
        Telephone No._1: -||-
        Administrator/Beneficial User: -||-
        TIN_2: -||-
        Address_2: -||-
        Telephone No._2: -||-
        Number and Street: -||-
        Barangay/District: -||-
        Municipality & Province/City: -||-
        OCT/TCT/CLOA No.: -||-
        Survey No.: -||-
        CCT: -||-
        Lot No.: -||-
        Dated: -||-
        Blk No.: -||-
        North: -||-
        South: -||-
        East: -||-
        West: -||-
        Land: -||-
        Building: -||-
        No. of Storeys: -||-
        Brief Description_1: -||-
        Machinery: -||-
        Brief Description_2: -||-
        Others: -||-
        Specify: -||-
        Total Assessed Value: -||-
        Taxable: -||-
        QTR: -||-
        Year: -||-
        This declaration cancels TD No.: -||-
        Owner: -||-
        Previous A.V. Php: -||-
        Memoranda: -||-
        '''

TDRP_COORDS = '''
        North: (193, 580), (600, 640)
        '''