tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814395d1674339693-incorporating-cash-receipts-in-a-sales-spreadsheet-s666-pq-sumifs-question_revised
Sheet: TEST

Date | Invoice # | Project | Customer | Amt Inv | Payor | Ch # | Check amount | AR | Balance |  | Customer | Project | Invoice # | Sum of Amt Inv | Sum of Check amount | Sum of Balance
2022-01-24 00:00:00 | 12345 | Garden | BA | 1500 | ABC | 8766000 | 200 | 1450 | 50 |  | BA | Backyard | 12348 | 526 | 263 | 228
2022-01-25 00:00:00 | 12346 | Driveway | CD | 250 | DEF | 73886 | 150 | 150 | 100 |  |  | Garden | 12345 | 4500 | 1450 | 1050
2022-01-26 00:00:00 | 12347 | Porch | EF | 550 | KLM | [NAME] | 550 | 550 | 0 |  | CD | Driveway | 12346 | 500 | 250 | 100
2022-01-28 00:00:00 | 12348 | Backyard | BA | 263 | ABC | 626262 | 35 | 35 | 228 |  |  | Sidewalk | 12851 | 2000 |  | 2000
2022-02-03 00:00:00 | 12346 | Driveway | CD | 250 | QCD | 23232 | 100 | 250 | 0 |  | EF | Lawn | 12354 | 1500 | 175 | 1300
2022-03-04 00:00:00 | 12348 | Backyard | BA | 263 | STL | 987 | 228 | 263 | 0 |  |  | Porch | 12347 | 550 | 550 | 0
2022-03-04 00:00:00 | 12345 | Garden | BA | 1500 | NYU | 2323 | 350 | 550 | 950 |  | Grand Total |  |  | 9576 | 2688 | 4678
2022-03-08 00:00:00 | 12354 | Lawn | EF | 750 | ABC | 9876 | 25 | 25 | 725
2022-04-10 00:00:00 | 12354 | Lawn | EF | 750 | NYU | 72727 | 150 | 175 | 575
2022-05-15 00:00:00 | 12851 | Sidewalk | CD | 2000 |  |  |  | 0 | 2000
2022-06-06 00:00:00 | 12345 | Garden | BA | 1500 | CQR | 12121 | 900 | 1450 | 50
Spreadsheet: 703091d1604750025-calculate-cumulative-sums-and-obtain-highest-value-based-on-it-example1935
Sheet: Sheet1

Concatenate | Month | Agent | Data1 | Data2 |  | 2020 | JUL
 | 2020 JUL | [NAME] | 9 | 481
 | 2020 JUL | [NAME] | 5 | 344 |  | Year and Month |  |  | Month Only |  |  | No criteria
 | 2020 JUL | [NAME] | 20 | 971 |  | Agent Name | Data 1 Value |  | Agent Name | Data 1 Value |  | Agent Name | Data 1 Value
 | 2020 JUL | Reeve | 8 | 85
 | 2020 JUL | [NAME] | 2 | 182
 | 2020 JUL | Clementine | 13 | 542
 | 2020 JUL | Brett | 10 | 211
 | 2020 JUL | Chase | 11 | 766
 | 2020 JUL | Sean | 12 | 1828
 | 2020 JUL | Olive | 13 | 324
 | 2020 JUL | [NAME] | 8 | 716
 | 2020 JUL | [NAME] | 26 | 440
 | 2020 JUL | TOTAL | 137 | 6890
 | 2019 AUG | [NAME] | 10 | 218
 | 2019 AUG | [NAME] | 3 | 227
 | 2019 AUG | [NAME] | 16 | 929
 | 2019 AUG | Reeve | 3 | 50
 | 2019 AUG | [NAME] | 3 | 132
 | 2019 AUG | Clementine | 6 | 347
 | 2019 AUG | Brett | 15 | 188
 | 2019 AUG | Chase | 8 | 827 |  |  | 1. get CUMULATIVE SUMS of each agent's Data1 value (except TOTAL), if "Month" column includes both the separate cell values H1 and J1
 | 2019 AUG | Sean | 6 | 1276 |  |  | 2. based on above, find the highest Data1 value of all agents, AND which agent achieved that
 | 2019 AUG | Olive | 6 | 357
 | 2019 AUG | [NAME] | 5 | 423 |  |  | The second requirement, is a slightly simpler version of the first, without the condition to match [NAME]
 | 2019 AUG | [NAME] | 15 | 392
 | 2019 AUG | TOTAL | 96 | 5366 |  |  | The third requirement, is a slightly simpler version of the first, without the condition to match both H1 or J1
 | 2018 JUL | [NAME] | 9 | 354
 | 2018 JUL | [NAME] | 3 | 320
 | 2018 JUL | [NAME] | 21 | 943
 | 2018 JUL | Reeve | 20 | 227 |  |  | It is preferred if no additional helper columns are used. The concatenate column already exists in the original table, and can be used if needed.
 | 2018 JUL | [NAME] | 1 | 320
 | 2018 JUL | Clementine | 9 | 454
 | 2018 JUL | Brett | 20 | 234
 | 2018 JUL | Chase | 22 | 857
 | 2018 JUL | Sean | 12 | 1758
 | 2018 JUL | Olive | 5 | 355
 | 2018 JUL | [NAME] | 5 | 436
 | 2018 JUL | [NAME] | 13 | 163
 | 2018 JUL | TOTAL | 140 | 6421
Spreadsheet: 698085d1601730666-to-detect-levels-accumulating-decreasing-in-range-of-0-5-range
Sheet: Sheet1

 |  | overflow can be from upper reservoir or some other reason |  |  |  |  | needed to display |  |  |  | when we know that above feeder is overflowing, we preemptively keep our level to UF-underflow |  |  |  |  |  |  |  | needed to display
 |  |  | 107.2 | 108.7 |  |  |  |  |  |  |  |  |  |  | 269.05 | 267
 |  |  | 107.5 | 115.9 |  |  | ORA |  |  |  |  |  |  |  | 267.3 | 259.5
 |  |  | 112.6 | 115.7 |  |  |  | Overflow buildup cant be considered only if >=3 & <=6 days |  |  |  |  |  |  | 264.65 | 257.65
 |  |  | 112.9 | 115.5 |  |  |  | range+ve can go 0.5% on both sides(upper&lower) |  |  |  |  |  |  | 266.35 | 264.5 |  |  | UF1 | Underflow buildup cant be considered only if >=3 & <=6 days
 |  |  | 112.1 | 116.1 |  |  | OB3 | Negative can go upto 1% |  |  |  |  |  |  | 266.35 | 264.4 |  |  | UF2 | range+ve can go 0.5% on both sides(upper&lower)
 |  |  | 112.75 | 115.15 |  |  | OB4 | difference can be considered on start date-eg of OB3. means 3 days |  |  |  |  |  |  | 266.35 | 265 |  |  | UF3 | Negative can go upto 1%
 |  |  | 113.15 | 114.55 |  |  | OB5 | has passed, so calculation should be done on data that is 3 days before |  |  |  |  |  |  | 264 | 276.8 |  |  | ORA | difference can be considered on start date-eg of OB3. means 3 days
 |  |  | 113.3 | 106.2 |  |  | OR | Overflow released | OR | is counted when closing level is <6 |  |  |  |  | 267.7 | 262.25 |  |  |  | has passed, so calculation should be done on data that is 3 days before
 |  |  | 108 | 109.75 |  |  |  |  |  |  |  |  |  |  | 268.95 | 261.75 |  |  |  | UF3-Overflow from above has increased the level
 |  |  | 109.55 | 109.95 |  |  |  |  |  |  |  |  |  |  | 265.7 | 253.05
 |  |  | 109.1 | 110.55 |  |  | This will not counted as 3 readings are outside the range |  |  |  |  |  |  |  | 260.75 | 252.5
 |  |  | 106.95 | 107.4 |  |  |  |  |  |  |  |  |  |  | 262.5 | 255.4
 |  |  | 112.05 | 112.6 |  |  |  |  |  |  |  |  |  |  | 274.2 | 262.3
 |  |  | 109.2 | 112.75 |  |  |  |  |  |  |  |  |  |  | 277.15 | 272.2
 |  |  | 108.8 | 108.8 |  |  |  |  |  |  |  |  |  |  | 280.75 | 260
 |  |  | 107.1 | 109.5 |  |  |  |  |  |  |  |  |  |  | 264.9 | 263.4
 |  |  | 105.25 | 105.6 |  |  |  |  |  |  |  |  |  |  | 266.55 | 261
 |  |  | 106.05 | 110.05 |  |  | OB3 |  |  |  |  |  |  |  | 264.1 | 260.8 |  |  | UF1
 |  |  | 107.6 | 108.4 |  |  | OB4 |  |  |  |  |  |  |  | 265 | 262.6 |  |  | UF2
 |  |  | 106.05 | 104.95 |  |  | OB5 |  |  |  |  |  |  |  | 265.35 | 263.2 |  |  | UF3
 |  |  | 107.5 | 110.05 |  |  | OR6 |  |  |  |  |  |  |  | 264.2 | 260.8 |  |  | UF4
 |  |  | 108.15 | 101.6 |  |  | OR |  |  |  |  |  |  |  | 262.25 | 271.4 |  |  | ORA
 |  |  | 107.5 | 115.95 |  |  | ORA | Overflow released from above
Spreadsheet: 599091d1542852122-sumifs-formulea-results-0-00-not-working
Sheet: Michael

[NAME]
Referrer | Client Name | Loan Amount | Settled | NPW | in Progress
Pedram | Jones | 211000 | Yes | No | No
Justin | Black | 581000 | Yes | No | No
Total
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: POLIT

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.A. Degree Political Science | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | POLIT 100 | 1 | X | 1 | X | 1 | 5 | 1 | 3 | 1
5 | POLIT 102 | 1 | X | 1
4 | POLIT 104 | 1 | X | 1
5 | POLIT 106 | 1 | X | 1
5 | POLIT 110 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 1648fd7b-8f52-4a4d-b02a-1c7c35d95ca1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2557 | 13768 | Greg | [NAME] | USA | 86 | [NAME] | 00:07:01 | 05:31:26 | 00:05:22 | 04:44:27 | 1 | [NAME]
Spreadsheet: 732653d1621102798-matching-month-amounts-match-months-amounts
Sheet: BANK

I'm kindly asking for a formula for cell F8. I want that if cell C5 is January 2021, then cell F8 matches the amount on cell i2 in the "DATABANK SHEET",
and then if cell C5 is February 2021 then the cell F8 matches the amount on the cell i3 and so on.
LEDGER BANK ACCOUNT : 210627154 (Local Church Funds)
Fiscal Month |  | 2021-01-01 00:00:00 | drop down list
 |  |  |  |  |  |  |  | Desired outcome
Date | Description | Reference | Revenue | Expense | Balance |  |  | Date | Description | Reference | Revenue | Expense | Balance
Balance Brought Forward |  |  |  |  |  |  |  | Balance Brought Forward
44202 | 0 | 1 | 3000 |  | 3000 |  |  | 44202 | 0 | 1 | 3000 |  | 3000
44219 | 0 | 2 | 2000 |  | 8000 |  |  | 44219 | 0 | 2 | 2000 |  | 8000
44219 | 0 | 3 | 40000 |  | 53000 |  |  | 44219 | 0 | 3 | 40000 |  | 53000
44219 | 0 | 4 | 3800 |  | 101800 |  |  | 44219 | 0 | 4 | 3800 |  | 101800
Spreadsheet: 61295d1262119509-contents-of-a-cell-s-from-one-worksheet-into-a-cell-in-another-worksheet-lookup1
Sheet: Sheet1

Test Case ID | Requirement ID
47 | 1000
33 | 1001
41 | 1002
39 | 1003
34 | 1005
32 | 1008
48 | 1009
38 | 1010
49 | 1011
Spreadsheet: 861778d1709623737-formula-for-different-data-format-in-mmddyyyy-covert-date-format
Sheet: Sheet1

1. Product EOS Date Status
30112025
20122022
3042026
3182025
112099
1462024
3062024
3062020
31122027
111900
762024
1012025
31122024
3062025
3182012
1562022
812030
1272022
942024
14102025
1312032
2332027
4102026
10112022
882023
3112023
1342027
1472026
1112033
30112023
1042029
12102021
Spreadsheet: 150222d1334336909-protect-sheet-but-allow-updates-template_dashboard_080811
Sheet: Lookup

 | Instructions: Lookup information, do not edit this spreadsheet directly, all values are automatically derived from the two WebDataSegments pages 1) Change column names of Succes Event 1 through Success Event 3 to your liking
Control Limits | New Visitors | Returning Visitors | Net Production (MWh) | Revenue ($1000) | Site Availability | Single Page Visits | WTG Availability | Page Views | Page Views/Visits | Customers | Orders | Items | Items/Order | Revenues | Average [NAME] | eCommerce Conversion | Success Event 1 | Success Event 2 | Success Event 3 | Success Rate
Lower Limit
Average
Upper Limit
Month Offset | New Visitors | Returning Visitors | Net Production (MWh) | Revenue ($1000) | Site Availability | Single Page Visits | WTG Availability | Page Views | Page Views/Visits | Customers | Orders | Items | Items/Order | Revenues | Average [NAME] | eCommerce Conversion | Success Event 1 | Success Event 2 | Success Event 3 | Success Rate
-12
-11
-10
-9
-8
-7
-6
-5
-4
-3
-2
-1
0
Spreadsheet: 864977d1712089910-help-extracting-values-from-cell-timeline-request-template-v3
Sheet: Fabric

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Links
 | Sq Ft |  |  |  | Total Print TIme |  | hrs |  | Upload of Art | 2024-05-14 00:00:00 |  |  |  | Large Job Gant Chart for KS.xlsx
 | [NAME] |  |  |  | Total Cutting Time |  | hrs |  | Proof Approvals | 2024-05-17 00:00:00 |  |  |  | PACE JOBS FOR MS.xlsx | MS List for Nathan
 |  |  |  |  | Sewing Time |  | hrs |  | Released to Production | 2024-05-20 00:00:00 |  |  |  | Timeline Requests.xlsx | Timeline Sheet
 |  |  |  |  | Total Pieces |  | pcs |  | Ship Date | 2024-06-11 00:00:00 |  |  |  | https://www.weprint.com/number-out-calculator.asp | ←#Up Calculator
 |  |  |  |  | Stores |  |  |  |  |  |  |  |  | Scheduling Kansas.xlsx | ←Old Timelines
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
Spreadsheet: vkaminski__40727__Storage Model - Intrinsic
Sheet: LRC - Homesville

ENRON CAPITAL & TRADE RESOURCES
Storage Analysis
Koch FSS Bistineau |  |  |  |  |  | [NAME] to Holmesville
 |  | [NAME] |  |  |  |  | Index |  |  | Libor | Net Cash | Cost of | Discounted
Month |  | Daily | Monthly | Cumulative | Nymex | Basis | Price |  | Dollars | Curve | Flow | Money | Net Cash Flow
2000-01-01 00:00:00 | 31 | 0 |  |  | 0 | 0
2000-02-01 00:00:00 | 29 | 0 |  |  | 0 | 0
2000-03-01 00:00:00 | 31 | 0 |  |  | 0 | 0 | 0
2000-04-01 00:00:00 | 30
2000-05-01 00:00:00 | 31
2000-06-01 00:00:00 | 30
2000-07-01 00:00:00 | 31
2000-08-01 00:00:00 | 31
2000-09-01 00:00:00 | 30
2000-10-01 00:00:00 | 31 | 0
2000-11-01 00:00:00 | 30 | 0
2000-12-01 00:00:00 | 31
2001-01-01 00:00:00 | 31
2001-02-01 00:00:00 | 28
2001-03-01 00:00:00 | 31 | 0
2001-04-01 00:00:00 | 30 | 0 |  |  | 0 | 0
2001-05-01 00:00:00 | 31 | 0 |  |  | 0 | 0
2001-06-01 00:00:00 | 30 | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | Spread before inj/wd fees, fuel, & cost of $) |  |  |  | Net Storage Fee
Variables |  | Storage Fuel |  | 0.016
 |  | Injection Fee |  |  | 0.005
 |  | Withdrawal Fee |  |  | 0.005
 |  |  |  |  |  | 0.1152
 |  |  |  |  |  | 0.1474
 |  |  |  |  |  | 0.1555
 |  |  |  |  |  | 0.1305
 |  |  |  |  |  | 0.1336
 |  |  |  |  |  | 0.1388
 |  |  |  |  |  | 0.1468
Spreadsheet: 876351d1723038549-if-function-returning-information-from-cell-with-formula-stock-ex
Sheet: Stock 2

Part Number | Immediate Stock | Secondary Stock | Due Date |  |  | Superseded | Superseded By | Superseded Date | Discontinued
ALOY0001 | 0 | 0 |  |  |  | False |  |  | False
ALOY0001-95K | 0 | 0 |  |  |  | False |  |  | False
ALOY0001K | 0 | 0 |  |  |  | False |  |  | False
ALOY0001K-ED | 0 | 0 |  |  |  | False |  |  | True
ALOY0001-LHK | 0 | 0 |  |  |  | False |  |  | False
ALOY0001-RHK | 0 | 0 |  |  |  | False |  |  | False
ALOY0002K | 1 | 0 |  |  |  | False |  |  | False
ALOY0003K | 1 | 0 |  |  |  | False |  |  | False
ALOY0004K | 0 | 0 |  |  |  | False |  |  | False
ALOY0008K | 0 | 0 |  |  |  | False |  |  | False
ALOY0009K | 0 | 0 |  |  |  | False |  |  | False
[NAME] | 2 | 0 |  |  |  | False |  |  | False
ALOY0010K-ED | 1 | 0 |  |  |  | False |  |  | False
ALOY0011K | 0 | 0 |  |  |  | False |  |  | False
ALOY0012K | 0 | 0 |  |  |  | False |  |  | False
ALOY0014K | 0 | 0 |  |  |  | False |  |  | False
ALOY0015K | 0 | 0 |  |  |  | False |  |  | False
[NAME] | 0 | 0 |  |  |  | False |  |  | False
ALOY0017K | 0 | 0 |  |  |  | False |  |  | False
ALOY0018K | 0 | 0 |  |  |  | False |  |  | False
[NAME] | 0 | 0 |  |  |  | False |  |  | False
ALOY0046K | 0 | 0 |  |  |  | False |  |  | False
ALOY0046XK | 0 | 0 |  |  |  | False |  |  | False
ALOY0090CL | 0 | 0 |  |  |  | False |  |  | False
ALOY0090CR | 0 | 0 |  |  |  | False |  |  | False
ALOY0090K | 0 | 0 |  |  |  | False |  |  | False
ALOY1388-90AK | 0 | 0 |  |  |  | False |  |  | False
ALOY1388AK | 2 | 0 |  |  |  | False |  |  | False
ALOY3273-80K | 0 | 0 |  |  |  | False |  |  | False
ALOY3273-90K | 0 | 0 |  |  |  | False |  |  | False
ALOY4285-95K | 0 | 0 |  |  |  | False |  |  | False
ALOY4343K | 0 | 0 |  |  |  | False |  |  | False
Spreadsheet: 706932d1606962354-index-and-match-multiple-matches-index_match_multiple_criteria
Sheet: Graphs

 | Name | Target | Penny | Ms. [NAME] | Jacy | [NAME] | [NAME] | Mr. [NAME] | [NAME] |  |  | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Target
 | Jan | 12000 | 9500 | 5321 | 8411 | 1065 | 2804 | 8890 | 3836 |  |  | Penny | 9500 | 3967 | 9000 | 7597 | 5275 | 2500 | 8307 |  |  |  |  |  | 12000
 | Feb | 12000 | 3967 | 8250 | 3245 | 1363 | 5127 | 2358 | 6923 |  |  | Ms. [NAME] | 5321 | 8250 | 1599 | 8670 | 9241 | 4795 | 9918 |  |  |  |  |  | 12000
 | Mar | 12000 | 9000 | 1599 | 9317 | 2971 | 4914 | 2229 | 4381 |  |  | Jacy | 8411 | 3245 | 9317 | 2327 | 8957 | 9198 | 1514 |  |  |  |  |  | 12000
 | Apr | 12000 | 7597 | 8670 | 2327 | 4919 | 6447 | 6932 | 4442 |  |  | [NAME] | 1065 | 1363 | 2971 | 4919 | 8512 | 7394 | 1036 |  |  |  |  |  | 12000
 | May | 12000 | 5275 | 9241 | 8957 | 8512 | 5205 | 6600 | 8728 |  |  | [NAME] | 2804 | 5127 | 4914 | 6447 | 5205 | 3861 | 8399 |  |  |  |  |  | 12000
 | Jun | 12000 | 2500 | 4795 | 9198 | 7394 | 3861 | 9848 | 3568 |  |  | Mr. [NAME] | 8890 | 2358 | 2229 | 6932 | 6600 | 9848 | 3094 |  |  |  |  |  | 12000
 | Jul | 12000 | 8307 | 9918 | 1514 | 1036 | 8399 | 3094 | 9204 |  |  | [NAME] | 3836 | 6923 | 4381 | 4442 | 8728 | 3568 | 9204 |  |  |  |  |  | 12000
 | Aug | 12000
 | Sep | 12000
 | Oct | 12000
 | Nov | 12000
 | Dec | 12000 |  | hello Marketing
Spreadsheet: 860413d1708517592-splitting-names-in-a-cell-and-take-corresponding-values-testbook-1-
Sheet: dashboard

Site | Red |  |  |  |  | Upon selection of B1 only, when B2 and B3 are empty it should show total stories of the site selected in B1, for all the years and quarters
Year |  |  |  |  |  | If B1 and B2 are selected, and B3 is empty, then it should show total stories of the site and year selected only
Quarter |  |  |  |  |  | If B1, B2, B3 all are selected, then it should show total stories of the site, year and quarter selected
 |  |  |  |  |  | B1, B2, B3 have dropdowns
 |  |  |  |  |  | But here's the thing, When above selections are made it should show the data in this format here so I can make a graph:
 | If only B1 is selected |  |  |  |  | If B1and B2 are selected: |  |  |  |  |  | If B1 and B2 and B3 are selected (show the selected quarter)
 | 2020 | 2021 | 2022 | 2023 |  |  | 2020 | 2021 | 2022 | 2023 |  | 2020 | 2021 | 2022 | 2023
 | sum of 2020 | sum of 2021 | sum of 2022 | sum of 2023 |  | Q1 |  |  |  |  | Q1 (selected quarter)
 |  |  |  |  |  | Q2
 |  |  |  |  |  | Q3
 |  |  |  |  |  | Q4
 | But all of this should happen in the same table, rather than having three separate tables.
 | One table should show data according to the selections, so the graph shows relevant data too.
 |  | 2023
 | 50029 | 39553
Spreadsheet: 136704d1326797229-sum-across-predetermined-sheet-range-sum-solution
Sheet: Sheet1

 | Product Group | Spacer Type | TGH / ANN | Textured ? | Georgian ? | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | FY13
IGUToughened | EnergiKare | Aluminium | Toughened | No Textured | No Georgian |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 6c026048-9845-44eb-a05a-76473f5e5e2b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Page 1
ABSTRACT OF ASSESSMENT FOR 2008
ALL VALUES REPORTED ARE TO BE AFTER BOARD OF REVIEW ACTION
 | DALLAS COUNTY |  | City/County
AGRICULTURAL REALTY
(Do Not Include Dwellings)
Column 1 | Column 2 | Column 3 | Column 4 | Column 5
Townships | Number of | Actual Value | Actual Value of | Total Actual Value
and Unincorporated | Agricultural | of Land Only | Structures (Do not | of Land and Structures
Areas | Acres |  | include dwellings) | (Col. 3 Plus Col. 4)
BOONE | 8399.66 | 3052100 | 615140 | 3667240
[NAME] | 19513.64 | 9009630 | 3067670 | 12077300
ADAMS | 20707.32 | 8929250 | 2065330 | 10994580
UNION | 19530.83 | 8223900 | 1726840 | 9950740
WALNUT | 11277.1 | 8760410 | 1164070 | 9924480
ADEL | 15987.19 | 10539890 | 1546730 | 12086620
COLFAX | 21915.35 | 14197480 | 2208120 | 16405600
LINN | 21068.31 | 12066440 | 2521830 | 14588270
GRANT | 19696.65 | 13244130 | 2516910 | 15761040
SUGAR GROVE | 20660.48 | 16261330 | 1570380 | 17831710
WASHINGTON | 21806.32 | 15896600 | 5255030 | 21151630
LINCOLN | 22679.72 | 17782910 | 3044320 | 20827230
DES MOINES | 16958.86 | 10908850 | 1012310 | 11921160
BEAVER | 21412.5 | 14312180 | 1916370 | 16228550
SPRING VALLEY | 18030.9 | 11713370 | 1341090 | 13054460
DALLAS | 21751.58 | 16360110 | 2654080 | 19014190
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Townships Totals | 301396.41 | 191258580 | 34226220 | 225484800
Cities
[NAME] | 352.58 | 117100 | 24130 | 141230
DE SOTO | 567.59 | 248950 | 27050 | 276000
DEXTER | 1105.3 | 589350 | 143600 | 732950
REDFIELD | 212.8 | 109770 |  | 109770
WAUKEE | 4636.93 | 3242170 | 299810 | 3541980
LINDEN | 360.29 | 289560 | 7940 | 297500
ADEL | 796.55 | 442140 | 71850 | 513990
DALLAS CENTER | 2477.21 | 1974720 | 4436680 | 6411400
GRANGER | 377.09 | 269650 | 9820 | 279470
MINBURN | 29.25 | 25400 | 9710 | 35110
WOODWARD | 304.68 | 230620 | 4850 | 235470
BOUTON | 4.48 | 3890 | 358500 | 362390
DAWSON | 210.25 | 132020 | 19030 | 151050
PERRY | 570.71 | 467320 | 403820 | 871140
WEST DES MOINES | 2574.47 | 1469100 | 127360 | 1596460
CLIVE | 401.25 | 212790 | 22440 | 235230
URBANDALE | 2607.85 | 1360300 | 173820 | 1534120
GRIMES | 904.05 | 721610 | 50980 | 772590
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Cities Totals | 18493.33 | 11906460 | 6191390 | 18097850
County Totals | 319889.74 | 203165040 | 40417610 | 243582650
Spreadsheet: 808401d1670439916-formula-to-look-in-a-number-column-and-find-a-certain-type-of-number-sample
Sheet: Sheet1

360 Appraisal Group | 14
AAA-AMC | 18
Accurate Group | 1789
Act Appraisal, Inc | 12431
Allstate Appraisal, LP | 3036
AMC Settlement Services | 236
American Valuation Corp | 996
AMSA | 285
[NAME] Services | 82
Appraisal House USA | 667
[NAME] | 6
Appraisal Management Solutions | 169
Appraisal MC | 34
Appraisal Nation | 3980
Appraisal Unlimited Management Group | 972
Appraisals 2U | 1308
AppraisalTek | 493
AppraiserVendor.com LLC | 2053
[NAME] | 721
[NAME] | 9
AssetVal Valuation Solutions | 112
Assurant Valuations | 4346
Spreadsheet: 101561d1299674842-valadation-list-text-font-choose-card-from-combobox
Sheet: Sheet1

3S
AS
2S
3S
4S
5S
6S
7S
8S
9S
JS
QS
KS
AS
2H
3H
4H
5H
6H
7H
8H
9H
JH
QH
KH
AC
2C
3C
4C
5C
6C
7C
8C
9C
[NAME]
QC
KC
AD
2D
3D
4D
5D
6D
7D
8D
9D
[NAME]
QD
KD
Spreadsheet: 777774d1650612839-match-if-vlookup-to-populate-a-list-of-data-and-corresponding-values-based-on-a-data-soa-sample
Sheet: Sample SOA

STATEMENT OF ACCOUNTS
 |  | Customer  Name : | Customer A
Customer A P.O.BOX: 39588, Abu Dhabi UAE TRN : 000000 |  |  |  | Dated: |  | 31.03.2022
Attn : ACCOUNTS PAYABLE
Invoice No | PO NUMBER | Department | Invoice Date | Amount in Euros | Amount in Aed | Due Date | REMARKS
FZE 5232 | 91/2021/A99 | African-Sales | 2021-10-11 00:00:00 | 14265.39 |  | 2022-01-11 00:00:00
FZE 5241 | 94/2021/A82 | Freight Charges | 2021-10-16 00:00:00 | 480 |  | 2022-02-16 00:00:00
FZE 5251 | 102/2021/ A100 | African-Sales | 2021-10-11 00:00:00 | 2736 |  | 2022-02-11 00:00:00
FZE 5253 | 116/2021/A108 | African-Sales | 2021-10-11 00:00:00 | 656.64 |  | 2022-02-11 00:00:00
FZE 5258 | 100/2021/ A101 | African-Sales | 2021-10-11 00:00:00 | 1545.84 |  | 2022-02-11 00:00:00
FZE 5264 | 94/2021/A82 | African-Sales | 2021-10-16 00:00:00 | 9508.97 |  | 2022-02-16 00:00:00
FZE 5265 | 93/2021/A98 | African-Sales | 2021-10-16 00:00:00 | 4084.62 |  | 2022-02-16 00:00:00
FZE 5266 | 124/2021/ A111 | African-Sales | 2021-10-16 00:00:00 | 2975.4 |  | 2022-02-16 00:00:00
FZE 5267 | 84/2021/A124 | African-Sales | 2021-10-16 00:00:00 | 595.08 |  | 2022-02-16 00:00:00
FZE 5307 | 114/2021/A117 | African-Sales | 2021-10-27 00:00:00 | 34035.27 |  | 2022-02-27 00:00:00
FZE 5308 | 121/2021/A119 rev. | African-Sales | 2021-10-27 00:00:00 | 5897.22 |  | 2022-02-27 00:00:00
FZE 5321 | 126/2021/P115 | African -Spares | 2021-10-30 00:00:00 | 374.49 |  | 30/02/2022
FZE 5322 | 112/ 2021/134rev | African -Spares | 2021-10-30 00:00:00 | 1688.75 |  | 30/02/2022
FZE 5329 | 118/2021/ A110 | African-Sales | 2021-10-30 00:00:00 | 3692.46 |  | 30/02/2022
FZE 5330 | 126/2021/A116 | African-Sales | 2021-10-30 00:00:00 | 2768.49 |  | 30/02/2022
FZE 5331 | 119/2021/A118 rev. | African-Sales | 2021-10-30 00:00:00 | 1597.14 |  | 30/02/2022
FZE 5332 | 139/2021/A126 | African-Sales | 2021-10-30 00:00:00 | 1134.87 |  | 30/02/2022
 |  |  | Total Amt
 |  |  | Overdue Amt
Bank Details: XXXX, A/C. No. 0000 000 000 000 AED, IBAN: AE0000000000, SWIFT: XXXXXX
Accounts Dept.
ABCD
Spreadsheet: 767828d1644665619-creating-multiple-dependent-dropdown-lists-from-the-same-target-cell-example
Sheet: Sheet2

 |  |  | Model
 |  |  | [NAME]
 |  |  | iPhone_SE
 |  |  | iPhone_13
 |  |  |  | [NAME]
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 64GB | Black
 |  |  |  | 128GB | White
 |  |  |  | iPhone_SE
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 64GB | Black
 |  |  |  | 128GB | White
 |  |  |  |  | Red
 |  |  |  | iPhone_13
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 128GB | Starlight
 |  |  |  | 256GB | Midnight
 |  |  |  | 512GB | Red
 |  |  |  |  | Pink