File size: 3,619 Bytes
02dad28
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
#OpenAI Variables
gpt_api_key = "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"
gpt_model = "gpt-3.5-turbo"

#Google Variables
project_id = "advance-river-381411"
project_location = "us"
processor_id = "31bc9a6106cb3cac"

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

#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, Replace Slashes with the number 1>
        ARP No.:  <Numerical Value Only, Replace Slashes with the number 1>
        TD No.:  <Numerical Value Only, Replace Slashes with the number 1>
        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, Replace Slashes with the number 1>
        Owner: <Person's Name>
        Address: -||-
        Tel No.: -||-
        Administrator/Beneficial User: -||-
        Address: -||-
        Tel No.: -||-
        PIN: <Numerical Value Only, Replace Slashes with the number 1>
        TIN_1: <Numerical Value Only, Replace Slashes with the number 1>
        TIN_2: <Numerical Value Only, Replace Slashes with the number 1>
        '''
# RPFAAP1 = '''
#         Desired Format: 
#         ARP No.: <Numerical Value Only, Replace Slashes with the number 1>
#         Owner: <Person's Name>
#         Address: -||-
#         Tel No.: -||-
#         Administrator/Beneficial User: -||-
#         Address: -||-
#         Tel No.: -||-
#         PIN: <Numerical Value Only, Replace Slashes with the number 1>
#         TIN_1: <Numerical Value Only, Replace Slashes with the number 1>
#         TIN_2: <Numerical Value Only, Replace Slashes with the number 1>
#         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, Replace Slashes with the number 1>
#         Area: <Area in SQ.M.>
#         Kind of Bldg.: -||-
#         Structural Type: -||-
#         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.>
#         '''