tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270494d1381502323-using-lookup-to-return-an-answer-from-a-table-ftlookup
Sheet: Transport Rate Card

PDS Logistics - Pallet Rate Card
Post Code | Plts---> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 - 14 | 15 +
B |  | 54.4 | 86.58 | 111.56 | 135.42 | 155.41 | 176.49 | 194.26 | 208.69 | 219.79 | 227.56 | 227.56 | 299.43
BS |  | 67.71 | 111.01 | 146.52 | 182.05 | 210.91 | 233.11 | 256.42 | 275.29 | 299.71 | 313.03 | 313.03 | 421.25
EH |  | 75.49 | 128.77 | 163.17 | 204.25 | 238.66 | 266.41 | 287.5 | 319.69 | 339.68 | 355.21 | 355.21 | 515.74
LS |  | 54.4 | 86.58 | 111.56 | 135.42 | 155.41 | 176.49 | 194.26 | 208.69 | 219.79 | 227.56 | 227.56 | 275.52
M |  | 41.07 | 64.38 | 79.93 | 97.68 | 105.46 | 119.89 | 132.09 | 133.2 | 139.86 | 142.08 | 142.08 | 172.5
Post Code
Pallets | B | BS | EH | LS | M
1 | 54.4 | 67.71 | 75.49 | 54.4 | 41.07
2 | 86.58 | 111.01 | 128.77 | 86.58 | 64.38
3 | 111.56 | 146.52 | 163.17 | 111.56 | 79.93
4 | 135.42 | 182.05 | 204.25 | 135.42 | 97.68
5 | 155.41 | 210.91 | 238.66 | 155.41 | 105.46
6 | 176.49 | 233.11 | 266.41 | 176.49 | 119.89
7 | 194.26 | 256.42 | 287.5 | 194.26 | 132.09
8 | 208.69 | 275.29 | 319.69 | 208.69 | 133.2
9 | 219.79 | 299.71 | 339.68 | 219.79 | 139.86
10 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
11 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
12 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
13 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
14 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
15 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
16 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
17 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
18 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
19 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
20 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
21 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
22 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
23 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
24 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
25 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
26 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 | #N/A
Spreadsheet: 123563d1317736280-formula-for-small-theatre-seating-plan-member-list-sample
Sheet: Sheet1

2010/11 | Hon/Patron | 2009/10 | 2008/09 | 2007/08 | 2006/07 | 2005/06 | 2004/05 | 2003/04 | 2002/03 | 2001/02 | 2000/01 | TITLE/STYLE | NAME
 |  |  |  |  | 926 |  |  |  |  |  |  | [NAME] | A'Bear
99 |  | 255 | 112 | 763 | 518 | 233 | 105 | 161 | 387 | 500 | 212 | [NAME] | Adams
756 |  | 498 | 485 | 525 | 193 | 647 | 642 | 751 | 322 |  |  | [NAME] | Adams
729 |  | 931 |  |  |  |  |  |  |  |  |  | [NAME] | Adams
299 |  | 102 | 296 | 99 | 533 | 375 | 603 | 902 | 290 | 848 |  | Mr E. | Adlington
 |  |  |  |  |  | 520 |  |  |  |  |  | [NAME] | Agar
 |  | 628 | 735 | 865 | 487 | 334 | 614 | 639 | 526 | 711 |  | [NAME] | Akers
 |  |  | 730 | 274 | 739 | 847 |  |  |  |  |  | Mr R. | Aldred
 |  |  | 731 | 275 | 740 | 846 |  |  |  |  |  | Mrs R | Aldred
 |  |  | 226 |  |  |  |  |  |  |  |  | [NAME] | [NAME]
186 |  | 555 | 273 | 734 | 516 | 594 | 280 | 352 | 583 | 775 | 397 | Mr W. | [NAME]
187 |  | 556 | 274 | 735 | 517 | 595 | 281 | 353 | 584 | 776 | 398 | [NAME] | [NAME]
 |  |  | N/J | 377 | 690 | 538 | 473 | 629 | 740 | 475 | 913 | Mr D. | [NAME]
 |  |  | N/J | 378 | 691 | 539 | 472 | 630 | 741 | 476 | 914 | [NAME] | [NAME]
 |  |  |  |  |  |  | 816 | 293 | 123 |  | 242 | Mr E. | [NAME]
 |  |  |  |  |  |  | 817 | 294 | 124 |  | 243 | [NAME] | [NAME]
Spreadsheet: 881837d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills-jot
Sheet: September

Monthly Bills Jot
From [NAME] | mortgage | 397.5
 | bills | 273.48
 | pot | 500
 | receipts | 266.74
 | owed | 0
Back to jack | credit | 0
Mine | To Bills | 0 |  |  |  |  |  | screw |  | 8.76 |  | 33 from saver
 | Credit Card ex |  |  |  |  |  |  | ability |  | 2.79
 | Receipts | 0 |  |  |  |  |  | pan from saving |  | 12 |  | paypal | 50
 | To Pot | 0 |  |  |  |  |  | bedding |  | 24
 | Pay credits |  |  |  |  |  |  | wood |  | 120
 | Santander |  |  |  |  |  |  |  |  | 71.45
 |  |  |  |  |  |  |  | bell |  | 35
 |  |  |  |  |  |  |  | decal |  | 19
 |  |  |  |  |  |  |  | button |  | 24.8
 |  |  |  |  |  |  |  | door knock tid |  | 60.3
 |  |  |  |  |  |  |  | wickes |  | 16
 |  |  |  |  |  |  |  | ability |  | 9.99
 |  |  |  |  |  |  |  | paint |  | 71.52
add | + | 0 |  |  |  |  |  | lead |  | 235.72
minus |  | 0
 |  | 0
Spreadsheet: 720029d1613986890-shift-diff-timecard-untitled-spreadsheet
Sheet: SETTINGS

SETTINGS
 | 1. ENTER EMPLOYEE INFO |  |  |  | 3. SELECT WEEKENDS |  |  |  |  |  |  |  | 5. HOLIDAYS |  | 6. OVERTIME TIERS & LIMITS
 | Employee Name | Indzara |  |  | SUN | MON | TUE | WED | THU | FRI | SAT |  | DATE |  | Tiers | Rate | Daily Limit (Hrs) | Weekly Limit (Hrs)
 | Employee Title | Excel Solutions Manager |  |  |  |  |  |  |  |  |  |  | 2018-07-03 00:00:00 |  | REGULAR | 10 | 8 | 40
 | Manager [NAME] | Indzara Manager |  |  |  |  |  |  |  |  |  |  | 2018-07-25 00:00:00 |  | OVERTIME | 15 | 12
 | Start Date | 2018-06-25 00:00:00 |  |  | 4. WEEK BEGINS ON |  |  |  |  |  |  |  |  |  | DOUBLE OVERTIME | 20
 | Custom Field | Printed on Sep 3, 2018 |  |  | MON
 | 2. ENTER COMPANY INFO
 | Company Name | Indzara.com |  |  |  |  |  |  |  |  |  |  |  |  | 7. POLICY FOR WEEKENDS & HOLIDAYS
 | Company Tagline | Simple & Effective Excel Solutions |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME
 | Address | 123, ABC Street, DEF City, GH - 12345
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Policy Text
 | Custom Field | Leader in Employee care
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8. POLICY FOR SEVENTH CONSECUTIVE WORK DAY IN WEEK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No | First | 8 | Hours | OVERTIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | After that | DOUBLE OVERTIME
Spreadsheet: rick_buy__32670__m001213a
Sheet: Sheet1

Payments
 |  |  | Collections | Collections | Collections | Collections | Collections | Dillution
 |  | Revenues  Billed | in 0 to 30 | in 31 to 60 | in 61 to 90 | in 91 to 120 | in 121 days | (Chargebacks & |  | Gross
Month | Year | in Current Month | Days | Days | Days | Days | or more | Adjustments) | Uncollected | Provisions | Writeoffs
January | 2000 | 10000000 | 5000000 | 3500000 | 400000 | 100000 | 200000 | 0
February | 2000 | 10000000 |  |  |  |  |  | 0
March | 2000 | 10000000 |  |  |  |  |  | 0
April | 2000 | 10000000 |  |  |  |  |  | 0
May | 2000 | 10000000 |  |  |  |  |  | 0
June | 2000 | 10000000 |  |  |  |  |  | 0
July | 2000 | 10000000 |  |  |  |  |  | 0
August | 2000 | 10000000 |  |  |  |  |  | 0
September | 2000 | 10000000
October | 2000 | 10000000
November | 2000 | 10000000
December | 2000 | 10000000
Payment rates
 |  |  | Collections | Collections | Collections | Collections | Collections | Dillution
 |  | Revenues  Billed | in 0 to 30 | in 31 to 60 | in 61 to 90 | in 91 to 120 | in 121 days | (Chargebacks & |  | Gross
Month | Year | in Current Month | Days | Days | Days | Days | or more | Adjustments) | Uncollected | Provisions | Writeoffs
January | 2000
February | 2000
March | 2000
April | 2000
May | 2000
June | 2000
July | 2000
August | 2000
September | 2000
October | 2000
November | 2000
December | 2000
Spreadsheet: 866862d1713788010-identify-common-cell-values-and-highlighting-with-colore-book1
Sheet: Sheet1

 |  | Customer | [NAME] @ 500Fils promotion | Incremental Sales with aggressive promotion
 |  | [NAME] | 450 | 400
 |  | [NAME] | 1000 | 500
 |  | [NAME] | 400 | 250
 |  | [NAME] | 125 | 125
 |  | H.M Tubli | 40
 |  | H.M - Gudaibiya | 30
 |  | Route 1
 |  | PSS | 800 | 400
 |  | BDF | 200
 |  | [NAME] | 50
 |  | [NAME] | 30
 |  | [NAME] | 50
 |  | Hidd-Coop | 25
 |  | Route 2
 |  | C4 | 750 | 3000
 |  | Megamart | 750 | 1200
 |  | Macromart | 120 | 400
 |  | Route 3
 |  | Ramez | 1800 | 700
 |  | Sultan Center | 100 | 100
 |  | [NAME] | 20
 |  | Route 15
 |  | [NAME] | 1200 | 2000
 |  | BPC | 1000 | 250
 |  | Zainal Mart | 20
 |  | Sanabis | 20
 |  | Deraity | 15
 |  | Eurasia | 15
 |  | Route 16
 |  | Total MT
Spreadsheet: 86830d1286804709-sorting-a-row-which-contais-data-repeted-atleast-once-exelprob-1-_swathyp
Sheet: Sheet1

NAME | DETAILS |  | Begins With > | 10A |  | Ends With > | FG |  |  | Combined |  |  | One Step Solution
[NAME] | 10A,BG |  |  | [NAME] | 10A,BG |  |  |  |  | [NAME] | 10A,BG |  | [NAME] | 10A,BG
swathy | 15C,FG |  |  |  |  |  | swathy | 15C,FG |  | swathy | 15C,FG |  | swathy | 15C,FG
paru | 10A,PC |  |  | paru | 10A,PC |  |  |  |  | paru | 10A,PC |  | paru | 10A,PC
nandhu | 16N,MC
binu | 17D,LD
jinish | 15D,FG |  |  |  |  |  | jinish | 15D,FG |  | jinish | 15D,FG |  | jinish | 15D,FG
amal | 10B,BG
vinod | 18J,LM
mahesh | 10A,BG |  |  | mahesh | 10A,BG |  |  |  |  | mahesh | 10A,BG |  | mahesh | 10A,BG
Required o/p |  |  |  |  |  |  |  |  |  |  |  |  | Copy the above, paste special > values to your destination
NAME | DETAILS |  |  |  |  |  |  |  |  |  |  |  | Then sort on Details, the result is below
[NAME] | 10A,BG
mahesh | 10A,BG |  |  |  |  |  |  |  |  |  |  |  | NAME | DETAILS
paru | 10A,PC |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10A,BG
swathy | 15C,FG |  |  |  |  |  |  |  |  |  |  |  | mahesh | 10A,BG
jinish | 15D,FG |  |  |  |  |  |  |  |  |  |  |  | paru | 10A,PC
 |  |  |  |  |  |  |  |  |  |  |  |  | swathy | 15C,FG
 |  |  |  |  |  |  |  |  |  |  |  |  | jinish | 15D,FG
Spreadsheet: 0d9b62ff-7ea7-4f8c-9fde-dbb76d86aca2
Sheet: Student-ST

Temporary Help Student Appointment - ST Positions |  |  |  |  |  | Start Over
PCN# | Suffix | Employee Class | Title | Account Code
**9950 | 06, 16, 26… | ST | TH-Clerical/Tutors | E4135
**9951 | 06, 16, 26… | ST | TH-Instructor/Coach | E4135
**9952 | 06, 16, 26… | ST | TH-Laborer | E4135
**9953 | 06, 16, 26… | ST | TH-Childcare Provider | E4135
**9954 | 06, 16, 26… | ST | TH-Logging | E4135
**9955 | 06, 16, 26… | ST | TH-Dairy | E4135
**9956 | 06, 16, 26… | ST | TH-Farming | E4135
**9957 | 06, 16, 26… | ST | TH-Cattle/Sheep | E4135
**9958 | 06, 16, 26… | ST | TH-Drivers | E4135
**9959 | 06, 16, 26… | ST | TH-Research-Lab | E4135
**9960 | 06, 16, 26… | ST | TH-Research-Non-Lab | E4135
Spreadsheet: c149a662-0ccf-4ab5-9e72-2c5084ee063e
Sheet: MV Caltrain

Site ID | Priority Ranking1 | Readiness | Street Name | Side of Street | Nearest Cross-street | Closest Property | Station Length2 | Sidewalk | Parking Lane | Private Property | Historical Site | Environmental Issues | Construction Needed | Comments (If applicable, explain construction/ environmental issues)
CMV001 | 1 | 1 | Transit Center | N | east of W Evelyn Ave | Caltrain Station | 18 docks | N | N | N | N | N | Y | no upgrades required (if solar utilized); pavement cut and repair ( for electrical)
CMV002 | 2 | 1 | Transit Center | N | east of W Evelyn Ave(just east of MV001 location) | Caltrain Station | 9 docks | N | N | N | N | N | Y | no upgrades required (if solar utilized); pavement cut and repair ( for electrical)
CMV003 | 2 | 1 | Transit Center | N | east of W Evelyn Ave(just south of MV002 location) | Caltrain Station | 14 docks | N | N | N | N | N | Y | no upgrades required (if solar utilized); pavement cut and repair ( for electrical)
CMV004 | 3 | 1 | Transit Center | S | east of W Evelyn Ave | Caltrain Station | 15 docks | N | N | N | N | N | Y | no upgrades required (if solar utilized); pavement cut and repair ( for electrical)
CMV005 | 3 | 1 | Transit Center | S | east of W Evelyn Ave(just east of MV004 location) | Caltrain Station | 7 docks | N | N | N | N | N | Y | no upgrades required (if solar utilized); pavement cut and repair ( for electrical) Need to relocate bike racks
1. Only priority ranking 1 sites are being considered for the pilot program.
2. Assumes a kiosk at the station
Spreadsheet: 882843d1731326624-stock-file-stoch
Sheet: Stock

2024-04-01 00:00:00 | 2024-07-15 00:00:00
Item Code | Product Name | Opening | Purchase | Sales | Closing
A. Junior 1 | J1 A Reg | 6
A. Junior 1 | J1 B Reg | 6
B. Junior 2 Reg | J2 A Reg | 13
B. Junior 2 Reg | [NAME] | 13
C. Junior 2 | J2 A Book | 2
C. Junior 2 | J2 B Book | 2
D. Junior 3 | J3 A Book | 3
D. Junior 3 | J3 B Book | 3
E. Junior 4 | [NAME] Book | 2
E. Junior 4 | [NAME] | 2
F. Foundation 1 | F1 A Book | 9
F. Foundation 1 | F1 B Book | 9
F. Foundation 1 | F1 C Book | 9
F. Foundation 1 | F1 D Book | 9
G. Foundation 2 | F2 A Book | 3
G. Foundation 2 | F2 B Book | 3
G. Foundation 2 | F2 C Book | 3
H. Foundation 3 | F3 A Book | 0
H. Foundation 3 | F3 B Book | 0
H. Foundation 3 | F3 C Book | 0
I. Foundation 4 | F4 A Book | 2
I. Foundation 4 | F4 B Book | 2
I. Foundation 4 | F4 C Book | 2
[NAME] | A1 A Book | 2
[NAME] | A1 B Book | 2
[NAME] | A1 C Book | 2
[NAME] | A2 A Book | 2
[NAME] | A2 B Book | 2
[NAME] | A2 C Book | 2
[NAME] 3 | A3 A Book | 2
[NAME] 3 | A3 B Book | 2
[NAME] 3 | A3 C Book | 2
[NAME] 4 | A4 A Book | 0
[NAME] 4 | A4 B Book | 0
[NAME] 4 | A4 C Book | 0
N.GMA | GMA A Book | 1
N.GMA | GMA B Book | 1
N.GMA | GMA C Book | 1
N.GMA | GMA D Book | 1
O.GMB | GMB A Book | 0
O.GMB | GMB B Book | 0
O.GMB | GMB C Book | 0
O.GMB | GMB D Book | 0
P.GMC | GMC A Book | 1
P.GMC | GMC B Book | 1
P.GMC | GMC C Book | 1
P.GMC | GMC D Book | 1
Q.Bag | Bag | 28
R.Abacus | Abacus | 28
S.Pouch | Pouch | 28
[NAME] | Tshirt | 28
U.Dic Green | Dictation Green | 22
Spreadsheet: 070662e0-ccad-46c5-bf67-1fcc10d9dc1d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Life Support Education | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
American Heart Association
 |  | Heartsaver CPR with AED
Course Evaluation
Course Date:
Please rate to what extent you achieved each of the following objectives during this course:
Upon completion of this course the participant will be able to: | Excellent | Good | Fair | Poor | Comments
AED - Recovery Position
Demonstrate and Verbalize indications for use of the AED for adult and pediatric victims.
Demonstrate and discuss the importance of the recovery (side lying) position for unconscious victims following arrest.
Adult:
Demonstrate the proper rates and technique for one rescuer CPR.
Demonstrate the techniques for relief of choking (FBAO) in the conscious and unconscious victims.
Child:
Demonstrate proper rates and techniques for one  rescuer CPR.
Demonstrate the techniques for relief of choking (FBAO) in the conscious and unconscious victims.
Infant:
Demonstrate proper rates and techniques for one rescuer CPR.
Demonstrate the techniques for relief of choking (FBAO) in the conscious and unconscious victims.
Rate the Instructor’s Overall Presentation: | Excellent | Good | Fair | Poor | Comments
How would you rate the instructor’s knowledge of the material?
Is there any additional instructional information you would like to see added to the course?
Thank you for your interest in improving our courses.
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 04 - Data

[NAME]
Focus Area 04 - Chronic Kidney Disease - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
04-01 | End-Stage Renal Disease Incidence  (age-sex-race adjusted per 1,000,000 population) | 344 (2003) | 374 (2007) | 217 | Moved away from target
04-05 | Dialysis Patients (under age 70) Registered on Kidney Transplant List (percentage) | 18 (2001) | 24 (2005) | 25 | Moved toward target
04-07 | End-Stage Renal Disease Incidence among [NAME] (age-sex-race adjusted per 1,000,000 population) | 150 (2003) | 160 (2007) | 78 | Moved away from target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.
Spreadsheet: 857077d1706155873-calculating-data-from-multiple-sheets-manually-calculated-example
Sheet: Returns 3

 | Pro Forma Summary
 |  |  |  |  | Pro Forma
 |  |  |  |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  | TTM | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma
 | Revenue |  |  |  | 3195000 | 3290850 | 3521209.5 | 3767694.165 | 4031432.75655 | 4313633.0495085 | 4529314.701983925 | 4755780.437083121 | 4898453.850195616 | 5045407.465701484 | 5196769.689672529
 | [NAME] |  |  |  | 1980900 | 2065088.25 | 2127040.8975 | 2190852.124425 | 2256577.68815775 | 2324275.018802483 | 2394003.269366557 | 2465823.367447554 | 2539798.068470981 | 2615992.010525111 | 2694471.770840864
 | Gross Profit |  |  |  | 1214100 | 1225761.75 | 1394168.6025 | 1576842.040575 | 1774855.06839225 | 1989358.030706017 | 2135311.432617368 | 2289957.069635567 | 2358655.781724635 | 2429415.455176373 | 2502297.918831665
 | Operating Expenses |  |  |  | 314100 | 327449.25 | 337272.7275 | 347390.9093250001 | 357812.6366047501 | 368547.0157028926 | 379603.4261739794 | 390991.5289591987 | 402721.2748279747 | 414802.913072814 | 427247.0004649984
 | NOI |  |  |  | 900000 | 898312.5 | 1056895.875 | 1229451.13125 | 1417042.4317875 | 1620811.015003125 | 1755708.006443388 | 1898965.540676368 | 1955934.50689666 | 2014612.542103559 | 2075050.918366666
 | Management Fee Allocation |  | 0.05 |  | 60705 | 61288.0875 | 69708.430125 | 78842.10202875 | 88742.75341961249 | 99467.90153530087 | 106765.5716308684 | 114497.8534817784 | 117932.7890862317 | 121470.7727588187 | 125114.8959415832
 | EBITDA |  |  |  | 839295 | 837024.4125 | 987187.444875 | 1150609.02922125 | 1328299.678367887 | 1521343.113467824 | 1648942.43481252 | 1784467.68719459 | 1838001.717810428 | 1893141.769344741 | 1949936.022425083
 | [NAME] |  | 0.015 |  | 0 | 49362.75 | 52818.14249999999 | 56515.412475 | 60471.49134825 | 64704.4957426275 | 67939.72052975887 | 71336.70655624682 | 73476.80775293423 | 75681.11198552226 | 77951.54534508793
 | DCF (Unlevered) |  |  |  | 839295 | 787661.6625 | 934369.3023750001 | 1094093.61674625 | 1267828.187019637 | 1456638.617725197 | 1581002.714282761 | 1713130.980638343 | 1764524.910057494 | 1817460.657359218 | 1871984.477079995
Spreadsheet: 835753d1688793341-identify-max-trip-number-per-month-found-max-number-based-on-date-month-and-years-aligw
Sheet: Sheet1

 |  |  | this is the data
Received Date | Trip |  |  | RESULT I WANT | [NAME]
2022-01-03 00:00:00 | 1 |  |  | 2022-01-31 00:00:00
2022-01-03 00:00:00 | 2
2022-01-05 00:00:00 | 1
2022-01-05 00:00:00 | 2
2022-01-20 00:00:00 | 1
2022-01-20 00:00:00 | 2 |  |  | 2023-01-31 00:00:00
2022-02-01 00:00:00 | 1
2022-02-01 00:00:00 | 2
2022-02-15 00:00:00 | 1
2022-02-20 00:00:00 | 1
2022-03-04 00:00:00 | 1
2022-03-04 00:00:00 | 2
2022-03-04 00:00:00 | 3
2022-04-05 00:00:00 | 1
2022-04-06 00:00:00 | 1
2022-04-07 00:00:00 | 1
2022-05-05 00:00:00 | 1
2022-05-05 00:00:00 | 2
2022-05-05 00:00:00 | 3
2022-05-05 00:00:00 | 4
2023-01-03 00:00:00 | 1
2023-01-03 00:00:00 | 2
2023-01-05 00:00:00 | 1
2023-01-05 00:00:00 | 2
2023-01-05 00:00:00 | 3
2023-01-20 00:00:00 | 1
2023-02-01 00:00:00 | 1
2023-02-01 00:00:00 | 2
2023-02-15 00:00:00 | 1
2023-02-20 00:00:00 | 1
2023-03-05 00:00:00 | 1
2023-03-05 00:00:00 | 2
2023-03-05 00:00:00 | 3
2023-04-05 00:00:00 | 1
2023-04-05 00:00:00 | 2
2023-04-05 00:00:00 | 3
2023-05-05 00:00:00 | 1
2023-05-06 00:00:00 | 1
2023-05-07 00:00:00 | 1
2023-05-07 00:00:00 | 2
Spreadsheet: 677167d1589223869-using-countifs-in-data-validation-countifs-validation
Sheet: Sheet1

 | Skill | Item |  |  |  |  | Valid Activity | Activity | Item List | Available
 | ARMOUR |  |  |  |  |  | ARMOUR | ARMOUR | BUCKLER | 0
 |  |  |  |  |  |  | WEAPONS | ARMOUR | CHAIN
 |  |  |  |  |  |  |  | ARMOUR | CUIRASS
 |  |  |  |  |  |  |  | ARMOUR | FULL PLATE
 |  |  |  |  |  |  |  | ARMOUR | GREAVES
 |  |  |  |  |  |  |  | ARMOUR | HAUBE
 |  |  |  |  |  |  |  | ARMOUR | HAUBERK
 |  |  |  |  |  |  |  | ARMOUR | HELM
 |  |  |  |  |  |  |  | ARMOUR | SHIELD | 0
 |  |  |  |  |  |  |  | WEAPONS | AXE
 |  |  |  |  |  |  |  | WEAPONS | BOW
 |  |  |  |  |  |  |  | WEAPONS | FALCHION
 |  |  |  |  |  |  |  | WEAPONS | MACE
 |  |  |  |  |  |  |  | WEAPONS | SLING | 0
 |  |  |  |  |  |  |  | WEAPONS | SPEAR | 0
 |  |  |  |  |  |  |  | WEAPONS | SWORD
Spreadsheet: larry_may__21650__Balance Sheet0721
Sheet: REGIONS

CONSUMING REGION EAST
 |  |  | AGA |  | EIA | AGA | STATE
Illinois |  |  | east |  | LAKES | east | Illinois
Indiana |  |  | east |  | LAKES | east | Indiana
Iowa |  |  | east |  | LAKES | east | Iowa
Michigan |  |  | east |  | LAKES | east | Michigan
Minnesota |  |  | west |  | LAKES | west | Minnesota
Nebraska |  |  | east |  | LAKES | east | Nebraska
North Dakota |  |  | west |  | LAKES | west | North Dakota
Ohio |  |  | east |  | LAKES | east | Ohio
South Dakota |  |  | west |  | LAKES | west | South Dakota
Wisconsin |  |  | east |  | LAKES | east | Wisconsin
Connecticut |  |  | east |  | NORTHEAST | east | Connecticut
D.C. |  |  | east |  | NORTHEAST | east | D.C.
Delaware |  |  | east |  | NORTHEAST | east | Delaware
Maine |  |  | east |  | NORTHEAST | east | Maine
Maryland |  |  | east |  | NORTHEAST | east | Maryland
Massachusetts |  |  | east |  | NORTHEAST | east | Massachusetts
New Hampshire |  |  | east |  | NORTHEAST | east | New Hampshire
New Jersy |  |  | east |  | NORTHEAST | east | New Jersy
New York |  |  | east |  | NORTHEAST | east | New York
Pennsylvania |  |  | east |  | NORTHEAST | east | Pennsylvania
Rhode Island |  |  | east |  | NORTHEAST | east | Rhode Island
Vermont |  |  | east |  | NORTHEAST | east | Vermont
West Virginia |  |  | east |  | NORTHEAST | east | West Virginia
Louisiana |  |  | producing |  | GULF COAST | producing | Louisiana
Texas |  |  | producing |  | GULF COAST | producing | Texas
Alabama |  |  | producing |  | SOUTHEAST | producing | Alabama
Florida |  |  | east |  | SOUTHEAST | east | Florida
Georgia |  |  | east |  | SOUTHEAST | east | Georgia
Kentucky |  |  | east |  | SOUTHEAST | east | Kentucky
Mississippi |  |  | producing |  | SOUTHEAST | producing | Mississippi
North Carolina |  |  | east |  | SOUTHEAST | east | North Carolina
South Carolina |  |  | east |  | SOUTHEAST | east | South Carolina
Tennessee |  |  | east |  | SOUTHEAST | east | Tennessee
Virginia |  |  | east |  | SOUTHEAST | east | Virginia
Arizona |  |  | west |  | MOUNTAIN | west | Arizona
Colorado |  |  | west |  | MOUNTAIN | west | Colorado
Idaho |  |  | west |  | MOUNTAIN | west | Idaho |  | west
Montana |  |  | west |  | MOUNTAIN | west | Montana
Nevada |  |  | west |  | MOUNTAIN | west | Nevada
New Mexico |  |  | producing |  | MOUNTAIN | producing | New Mexico |  | producing
Utah |  |  | west |  | MOUNTAIN | west | Utah
Wyoming |  |  | west |  | MOUNTAIN | west | Wyoming |  | west
Oregon |  |  | west |  | PACIFIC-NW | west | Oregon
Washington |  |  | west |  | PACIFIC-NW | west | Washington
Arkansas |  |  | producing |  | SOUTH-CENTRAL | producing | Arkansas
Kansas |  |  | producing |  | SOUTH-CENTRAL | producing | Kansas
Missouri |  |  | east |  | SOUTH-CENTRAL | east | Missouri
Oklahoma |  |  | producing |  | SOUTH-CENTRAL | producing | Oklahoma
California |  |  | west |  | CALIFORNIA | west | California