tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 29860d1225070862-gridlines-have-disappeared-frb2
Sheet: frb

 | 1 | 2 | 7 | 3 | 6 | 5 | 4 | 9 | 8 | 10 | 11 | 12
 | New York | Atlanta | Boston | Cleveland | Chicago | San Fran | Richmond | Philly | Dallas | St Louis | Kansas City | Minneapolis
 | B | F | A | D | G | L | E | C | K | H | J | I
2005-10-17 00:00:00 | 54 | 39 | 28 | 36 | 32 | 35 | 35 | 16 | 21 | 12 | 9 | 9 | 326
2005-11-18 00:00:00 | 82 | 57 | 49 | 57 | 45 | 46 | 44 | 30 | 28 | 18 | 11 | 12 | 479
2005-11-29 00:00:00 | 87 | 61 | 51 | 67 | 50 | 52 | 45 | 36 | 29 | 21 | 12 | 12 | 523
2005-12-02 00:00:00 | 91 | 62 | 52 | 71 | 57 | 54 | 47 | 37 | 30 | 22 | 12 | 12 | 547
2005-12-16 00:00:00 | 101 | 68 | 60 | 81 | 62 | 62 | 51 | 49 | 36 | 27 | 13 | 12 | 622
2006-01-02 00:00:00 | 122 | 86 | 82 | 98 | 73 | 73 | 62 | 64 | 43 | 33 | 13 | 13 | 762
2006-01-15 00:00:00 | 135 | 99 | 93 | 108 | 77 | 78 | 68 | 70 | 45 | 40 | 17 | 14 | 844
2006-01-29 00:00:00 | 142 | 111 | 101 | 114 | 84 | 83 | 77 | 73 | 47 | 43 | 19 | 14 | 908
2006-02-16 00:00:00 | 158 | 123 | 113 | 122 | 100 | 84 | 81 | 78 | 51 | 48 | 19 | 14 | 991
2006-02-26 00:00:00 | 168 | 128 | 124 | 128 | 104 | 86 | 83 | 80 | 56 | 50 | 19 | 14 | 1040
2006-03-14 00:00:00 | 174 | 137 | 135 | 131 | 109 | 90 | 90 | 86 | 59 | 53 | 21 | 15 | 1100
2006-03-29 00:00:00 | 189 | 145 | 143 | 135 | 119 | 99 | 93 | 90 | 62 | 54 | 21 | 15 | 1165
2006-04-03 00:00:00 | 192 | 149 | 147 | 145 | 124 | 100 | 93 | 91 | 65 | 55 | 21 | 15 | 1197
2006-04-19 00:00:00 | 209 | 161 | 165 | 152 | 132 | 108 | 100 | 95 | 68 | 56 | 22 | 17 | 1285
2006-05-01 00:00:00 | 219 | 167 | 173 | 163 | 137 | 113 | 109 | 101 | 70 | 58 | 22 | 17 | 1349
2006-05-24 00:00:00 | 233 | 183 | 176 | 170 | 145 | 118 | 115 | 112 | 74 | 61 | 23 | 17 | 1427
2006-05-30 00:00:00 | 237 | 190 | 182 | 172 | 148 | 122 | 118 | 113 | 76 | 63 | 25 | 18 | 1464
2006-06-05 00:00:00 | 244 | 195 | 183 | 174 | 150 | 122 | 123 | 116 | 77 | 65 | 25 | 18 | 1492
2006-06-19 00:00:00 | 253 | 203 | 198 | 179 | 157 | 126 | 128 | 123 | 79 | 68 | 31 | 20 | 1565
2006-07-05 00:00:00 | 262 | 211 | 212 | 195 | 164 | 136 | 134 | 129 | 81 | 71 | 31 | 23 | 1649
2006-07-24 00:00:00 | 276 | 220 | 219 | 209 | 172 | 142 | 134 | 135 | 83 | 73 | 33 | 24 | 1720
2006-08-18 00:00:00 | 294 | 249 | 226 | 217 | 187 | 150 | 142 | 139 | 91 | 79 | 35 | 26 | 1835
2006-09-05 00:00:00 | 299 | 262 | 237 | 230 | 193 | 159 | 147 | 144 | 95 | 79 | 36 | 27 | 1908
2006-10-05 00:00:00 | 315 | 276 | 245 | 244 | 201 | 173 | 156 | 154 | 99 | 86 | 38 | 29 | 2016
 | 261 | 237 | 217 | 208 | 169 | 138 | 121 | 138 | 78 | 74 | 29 | 20 | 1690
 | 0.1544378698224852 | 0.1402366863905326 | 0.1284023668639053 | 0.1230769230769231 | 0.1 | 0.08165680473372781 | 0.07159763313609467 | 0.08165680473372781 | 0.04615384615384616 | 0.04378698224852071 | 0.01715976331360947 | 0.01183431952662722 | 1
Spreadsheet: 456931d1461134513-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-test-b
Sheet: TUE - VOLUNTEER

YOGH | [NAME] |  |  | SOUP | FISH | LAMB |  |  | vegies | VEGIES & GRAVY |  |  |  | vegies | Vegies & Gravy |  |  |  |  |  |  |  | BEEF | QUICHE
BOTTOM |  |  |  |  |  |  |  |  | MIDDLE |  |  |  |  |  |  |  |  | TOP
NAME | ADDRESS | JUICE | DESSERT | SOUP | BAKED FISH | ROAST LAMB | SPECIAL ITEM |  | NAME | ADDRESS | JUICE |  |  |  |  | SPECIAL ITEM |  | NAME | ADDRESS | JUICE |  |  |  |  | SPECIAL ITEM
PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS
 |  | OJ
 |  |  |  |  |  |  |  |  |  |  | OJ |  |  |  |  |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE
 |  | NO JUICE |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  | NO JUICE
 |  | NO JUICE |  |  |  |  |  |  |  |  | OJ
 |  | NO JUICE |  |  |  |  |  |  |  |  | NO JUICE
 |  | AJ |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  |  |  |  | NO JUICE
 |  | AJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJ
 |  | NO JUICE |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  | NO JUICE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE
 |  | AJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  |  |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  |  |  |  | AJ | [NAME]
 |  |  |  |  |  |  |  |  |  |  | AJ
PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET
PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM
Spreadsheet: 477462d1472304242-program-for-stitching-unit-sample-excel
Sheet: LABOR CHARGE

NAME | DATE | SIZE |  |  |  |  | TOTAL |  | NAME | DATE | SIZE |  |  |  |  | TOTAL |  | NAME | DATE | SIZE |  |  |  |  | TOTAL
 |  |  |  |  |  | 303 |  |  |  |  |  |  |  |  | 219 |  |  |  |  |  |  |  |  | 324
 |  | 202 | 55 | 36 | 70 | 110 |  |  |  |  | 146 | 62 | 126 | 213 | 124 |  |  |  |  | 216 | 234 | 170 | 190 | 468
LAB 1 |  | SMALL | MEDIUM | LARGE | X LARGE | 90 |  |  | LAB 2 |  | SMALL | MEDIUM | LARGE | X LARGE | 315 |  |  | LAB 3 |  | SMALL | MEDIUM | LARGE | X LARGE | 425
 | date |  |  |  |  | 210 |  |  |  | date |  |  |  |  | 639 |  |  |  | date |  |  |  |  | 570
 | 20-8-2016 | 20 |  |  |  |  | 713 |  |  | 20-8-2016 | 34 |  |  |  |  | 1297 |  |  | 20-8-2016 | 34 | 67 | 89 | 10 |  | 1787
 | 21-8-2016 | 35 |  |  |  |  |  |  |  | 21-8-2016 | 65 |  |  |  |  |  |  |  | 21-8-2016 | 35 |  |  | 67
 | 22-8-2016 | 65 |  |  |  |  |  |  |  | 22-8-2016 | 35 | 23 |  |  |  |  |  |  | 22-8-2016 | 65 | 67 | 45 | 43
 | 23-8-2016 | 70 |  |  |  |  |  |  |  | 23-8-2016 |  | 24 |  |  |  |  |  |  | 23-8-2016 | 70 | 45
 | 24-8-2016 |  | 10 | 2 | 7 |  |  |  |  | 24-8-2016 |  | 5 | 2 | 78 |  |  |  |  | 24-8-2016 |  | 10 | 2 | 7
 | 26-08-2016 |  | 45 |  | 7 |  |  |  |  | 26-08-2016 |  | 10 | 90 | 23 |  |  |  |  | 26-08-2016 |  | 45 |  | 7
 | 26-08-2016 |  |  | 34 |  |  |  |  |  | 26-08-2016 |  |  | 34 | 56 |  |  |  |  | 26-08-2016 |  |  | 34
 | 27-08-2016 | 12 |  |  | 56 |  |  |  |  | 27-08-2016 | 12 |  |  | 56 |  |  |  |  | 27-08-2016 | 12 |  |  | 56
Spreadsheet: 704460d1605563725-countifs-same-array-criteria-please-help-test-count
Sheet: Sheet1

 | Okarito Brown Kiwi | Kōkako | Rifleman | Black-billed Gull | [NAME]
 | Fantail | [NAME] Owl | Black-billed Gull | [NAME] | Shore Plover
 | Fiordland Crested Penguin | Great Spotted Kiwi | Black-billed Gull | [NAME] | Yellowhead |  |  |  |  | Rifleman |  | <-- This should say 5, but has only counted the entries at C5 and B6
 | [NAME] | Rifleman | [NAME] | Black-billed Gull | Hutton's Shearwater
 | Rifleman | Little Penguin | Takahē | Okarito Brown Kiwi | Shore Plover |  |  |  | ELIMINATED:
 | [NAME] | Kākāpō | [NAME] | Yellow-eyed penguin | Yellowhead |  |  |  |  | Royal Spoonbill
 | North Island Brown Kiwi | Antipodean Albatross | Southern Brown Kiwi | New Zealand Falcon | Australasian Crested Grebe |  |  |  |  | Variable Oystercatcher
 | New Zealand Dotterel | Royal Spoonbill | Variable Oystercatcher | Rifleman | Black Stilt |  |  |  |  | Black Stilt
 | [NAME] | [NAME] | Okarito Brown Kiwi | Kōkako | Rifleman |  |  |  |  | [NAME]
 | Antipodean Albatross | Black Petrel | Blue Duck | Brown Teal | Black Stilt |  |  |  |  | [NAME]
 | Antipodean Albatross | Orange-fronted Parakeet | New Zealand Dotterel | South Island Kōkako | Southern Brown Kiwi |  |  |  |  | Okarito Brown Kiwi
 |  |  |  |  |  |  |  |  |  | Kōkako
Spreadsheet: 24056d1214060395-filter-pour-forum
Sheet: Feuil1

 | cookie | 1 | t | 18 June | 7
 | cake | 1 | r | 18 June | 6
 | Vodka | 0 | t | 18 June | 5
 | rhum | 0 | r | 18 June | 5
 | rhum | 0 | t | 18 June | 6
 | rhum | 0 | r | 18 June | 5
 | cookie | 1 | t | 18 June | 6
 | cookie | 0 | r | 18 June | 5
 | vodka | 1 | t | 18 June | 6
 | cake | 0 | t | 18 June | 5
 | cake | 0 | r | 18 June | 6
 | rhum | 1 | r | 18 June | 6
 | rhum | 1 | t | 18 June | 6
 | cake | 1 | t | 18 June | 6
 | cake | 1 | r | 18 June | 5
 | cookie | 1 | t | 18 June | 7
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 1-26 thru 2-1

 |  |  |  |  |  | System:
 |  |  | 2009-01-26 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-01-26 00:00:00 |  |  |  |  |  |  | Total
1 |  |  |  |  |  | 65
2 |  |  |  |  |  |  | 66.46
3 |  | 54 |  |  |  |  |  | 54
4 |  |  |  | 35.16 |  |  | 39.63
5 |  |  |  | 33.5
6 |  | 38.22 |  |  | 38.35
7 |  |  |  |  | 35.75
8 |  | 34.13
9 |  |  |  | 34.69
10 |  |  |  |  | 35.75
11
12 |  | 33.18 |  |  | 34.77
13 |  | 35.5 |  |  | 39.65
14 |  | 36 |  |  |  | 38
15
16 |  | 27.5 |  | 25.92 |  |  |  | 37.27
17 |  |  | 34.29 |  | 34.09
18 |  | 32.25 |  |  |  |  | 33.42
19 |  |  |  | 32.75 |  | 30.4
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 80161d1280366048-excel-2007-grouping-and-collapsing-data-book1
Sheet: Sheet1

1.0
 | 1.1
 |  | 1.1.1
 |  | 1.1.2
 |  | 1.1.3
 |  |  | sss
 |  |  | ddd
 |  |  | [NAME]
2.0
 | 2.1
 |  | 2.1.1
 |  |  | aaa
 |  |  | bbb
 |  |  | [NAME]
 |  | 2.1.2
 |  |  | aaa
 |  |  | sss
 | 2.2
 |  | 2.2.1
 |  | 2.2.2
3.0
 | 3.1
 | 3.2
Spreadsheet: 587664d1535147849-sum-that-updates-when-rows-deleted-excel-help-forum
Sheet: Sheet1

 |  |  | PAY
WEEK 1 | SUNDAY | 2018-08-26 00:00:00
 | MONDAY | 2018-08-27 00:00:00 | 100
 | TUESDAY | 2018-08-28 00:00:00 | 100
 | WEDNESDAY | 2018-08-29 00:00:00 | 100
 | THURSDAY | 2018-08-30 00:00:00 | 100
 | FRIDAY | 2018-08-31 00:00:00 | 100
 | SATURDAY | 2018-09-01 00:00:00
WEEK 2 | SUNDAY | 2018-08-26 00:00:00
 | MONDAY | 2018-08-27 00:00:00 | 100
 | TUESDAY | 2018-08-28 00:00:00 | 100
 | WEDNESDAY | 2018-08-29 00:00:00 | 100
 | THURSDAY | 2018-08-30 00:00:00 | 100
 | FRIDAY | 2018-08-31 00:00:00 | 100
 | SATURDAY | 2018-09-01 00:00:00
WEEK 3 | SUNDAY | 2018-08-26 00:00:00
 | MONDAY | 2018-08-27 00:00:00 | 100
 | TUESDAY | 2018-08-28 00:00:00 | 100
 | WEDNESDAY | 2018-08-29 00:00:00 | 100
 | THURSDAY | 2018-08-30 00:00:00 | 100
 | FRIDAY | 2018-08-31 00:00:00 | 100
 | SATURDAY | 2018-09-01 00:00:00
WEEK 4 | SUNDAY | 2018-08-26 00:00:00
 | MONDAY | 2018-08-27 00:00:00 | 100
 | TUESDAY | 2018-08-28 00:00:00 | 100
 | WEDNESDAY | 2018-08-29 00:00:00 | 100
 | THURSDAY | 2018-08-30 00:00:00 | 100
 | FRIDAY | 2018-08-31 00:00:00 | 100
 | SATURDAY | 2018-09-01 00:00:00
WEEK 5 | SUNDAY | 2018-08-26 00:00:00
 | MONDAY | 2018-08-27 00:00:00 | 100
 | TUESDAY | 2018-08-28 00:00:00 | 100
 | WEDNESDAY | 2018-08-29 00:00:00 | 500
 | THURSDAY | 2018-08-30 00:00:00 | 200
 | FRIDAY | 2018-08-31 00:00:00 | 100
 | SATURDAY | 2018-09-01 00:00:00
Spreadsheet: 59129d1259596737-loan-balance-2010
Sheet: Budget i banken

2010 | January | February | March | April | May | June | July | August | September | October | November | December
TDC | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
DR licens
TRYG1
[NAME] | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
TRYG | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Durslands Bank | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Loan | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  |  |  | Tilbage af lån
Gebyr budget
Livsforsikring | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Husleje | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Surftown | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
[NAME]
Norddjurs kommune: [NAME] | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Træ industri byg
Skat indbetaling AM bidrag | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
GodCares | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
[NAME] og Israel | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Udgifter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Udgifter i gennemsnit
Indtægter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indtægter i gennemsnit
Tilbage hver månede |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tilbage gennemsnit
Kapitalpension | 7894 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 813808d1674002954-sequential-number-incrementing-for-table-not-working-form-sequence
Sheet: Form1 (3)

ID | Start time | Completion time | [NAME] | Name | Title | Today's Date | Document Group | DCN
1 | 2023-01-17 14:48:50 | 2023-01-17 14:48:56 | [EMAIL] | [NAME] | 123 | 2023-01-17 00:00:00 | Contracts
2 | 2023-01-17 14:48:59 | 2023-01-17 15:00:19 | [EMAIL] | [NAME] | 234 | 2023-01-17 00:00:00 | Engineering
3 | 2023-01-17 15:02:36 | 2023-01-17 15:02:42 | [EMAIL] | [NAME] | 345 | 2023-01-18 00:00:00 | Contracts
4 | 2023-01-17 15:02:47 | 2023-01-17 15:09:44 | [EMAIL] | [NAME] | 456 | 2023-01-19 00:00:00 | Engineering
5 | 2023-01-17 15:11:47 | 2023-01-17 15:11:57 | [EMAIL] | [NAME] | 567 | 2023-01-22 00:00:00 | Proposal
6 | 2023-01-17 15:14:57 | 2023-01-17 15:15:09 | [EMAIL] | [NAME] | 678 | 2023-01-23 00:00:00 | Contracts
7 | 2023-01-17 15:15:19 | 2023-01-17 15:15:29 | [EMAIL] | [NAME] | 789 | 2023-01-24 00:00:00 | Engineering
8 | 2023-01-17 15:21:35 | 2023-01-17 15:21:51 | [EMAIL] | [NAME] | 8910 | 2023-01-25 00:00:00 | Proposal
9 | 2023-01-17 15:24:12 | 2023-01-17 15:24:19 | [EMAIL] | [NAME] | 1112 | 2023-01-26 00:00:00 | Engineering
10 | 2023-01-17 15:37:34 | 2023-01-17 15:37:43 | [EMAIL] | [NAME] | 1213 | 2023-01-27 00:00:00 | Engineering
11 | 2023-01-17 16:10:14 | 2023-01-17 16:10:37 | [EMAIL] | [NAME] | 1314 | 2023-01-27 00:00:00 | Finance
 |  |  |  | d
 |  |  |  | d
 |  |  |  | d
 |  |  |  | d
 |  |  |  | d
Spreadsheet: 752235d1634659752-vlookup-stops-working-after-several-rows-po-workbook
Sheet: 3rd CO - 

Owner Direct Purchase Summary Log
PO # | VENDOR | CONTRACTOR | PREVIOUSLY TAXED (NET AMT) | 2016-12-26 00:00:00 |  | CURRENT SUBTOTAL | nontx | nontx | nontx | NON TAXABLE | TAXABLE | TOTAL TAXES | TOTAL CO
 |  | subtotals
 |  | Total Previously Invoiced |  |  |  |  |  |  |  | TOTAL CHANGE ORDER AMOUNT
Spreadsheet: 741387d1627017801-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-copy-of-extract-values-into-desired-columns-ans1_1
Sheet: EXPECTED OUTPUT

 |  |  |  | Section I |  |  | Section II |  |  | Section III
S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | NOTE
 |  |  |  |  |  |  |  |  |  |  |  |  | Further sections can be extended without change of formula
Spreadsheet: 0f4231c9-fd40-4f5a-b099-ce1d78addc5e
Sheet: Sheet1

OneRotary allows Rotary clubs and districts the option of linking their databases directly to the main membership database maintained at RI World Headquarters. This integration eliminates duplicate data entry efforts and leads to more accurate information, such as on semiannual reports. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
RI Database Integration Options |  |  | Participating Vendors
 | ClubRunner | DaCdb | Norsk Rotary Forum (SEDMA) | Svensk Rotary Service (SEMDA) | Finlands Rotary Service (SEMDA) | Swiss CVS (SEMDA) | Danish Rotary Multidistrict Admin (SEMDA) | ClubExpress
Update Member
First name | X | X | X | X | X | X | X | X
Middle name | X | X | X | X |  |  |  | X
Last name | X | X | X | X | X | X | X | X
Call name (Nickname)
Name, Prefix | X | X |  |  |  |  |  | X
Name, Suffix | X | X
Gender | X | X | X | X | X | X | X
Update Member Contact Information
Home address | X | X | X | X | X | X | X | X
Business address | X | X | X * | X * | X * | X * | X * | X
Home phone number | X | X | X | X | X | X | X | X
Business phone | X | X | X | X | X | X | X | X
Fax number | X | X | X | X | X | X | X | X
E-mail address | X | X | X | X | X | X | X | X
Website
Update Club Information
Club permanent mailing address |  | X
Club meeting place | X | X | X | X | X | X | X
Club meeting address | X | X | X | X | X | X | X
Club meeting day | X | X | X | X | X | X | X
Club meeting time | X | X | X | X | X | X | X
Club website | X | X | X | X | X | X | X
Club phone number |  | X
Club fax number |  | X
Club e-mail address |  |  | X | X | X | X | X
Membership Updates
Terminating active and honorary members | X | X | X | X | X | X | X
Adding new members
Club Officer Term Updates
Adding new club officers | X |  | X | X | X | X | X
Updating existing officer terms | X |  | X | X | X | X | X
* Only one address in system could be home or business
Spreadsheet: 716092d1612018203-how-can-i-find-max-value-of-per-consecutive-data-pan
Sheet: Sheet4

PCode | Sales Number |  | PCode | Sales Number
A4 | 728
A4 | 197
A4 | 604
A4 | 328
A10 | 81
A4 | 89
A10 | 534
A10 | 270
A4 | 70
Spreadsheet: 686315d1594493188-salary-increase-per-team-across-year-salcalc
Sheet: Sheet1

Department | Start Date | End Date | Name | Monthly Salary | Starting Salary | Currently Employed | Increase Number | Current Salary | Increase 1 | Increase Date From | Increase Date To | Increase 2 | Increase Date From | Increase Date To | Increase 3 | Increase Date From | Increase Date To | Increase 4 | Increase Date From | Increase Date To | Increase 5 | Increase Date From | Increase Date To | Increase 6 | Increase Date From | Increase Date To | Increase 7 | Increase Date From | Increase Date To | Increase 8 | Increase Date From | Increase Date To | Increase 9 | Increase Date From | Increase Date To | Increase 10 | Increase Date From | Increase Date To
Team 1 | 2019-01-27 00:00:00 |  | [NAME] |  | 21000
Team 3 | 2018-11-10 00:00:00 |  | [NAME] |  | 18000 |  |  |  | 21000 | 2019-05-04 00:00:00
Team 1 | 2018-03-20 00:00:00 |  | Nick |  | 30000
Team 5 | 2020-01-27 00:00:00 |  | [NAME] |  | 35000
Team 5 | 2019-11-25 00:00:00 | 2020-05-28 00:00:00 | Abbey |  | 28000 |  |  |  | 29000 | 2020-05-28 00:00:00
Team 4 | 2020-02-24 00:00:00 | 2020-06-30 00:00:00 | [NAME] |  | 25000
Team 5 | 2019-07-02 00:00:00 | 2020-02-28 00:00:00 | [NAME] |  | 21500
Team 1 | 2015-02-03 00:00:00 | 2020-06-30 00:00:00 | [NAME] |  | 45000 |  |  |  | 48000 | 2019-02-02 00:00:00
Team 4 | 2014-02-10 00:00:00 |  | Fred |  | 35000
 | Range Start | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
 | Range End
Department | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January
Team 1
Team 2
Team 3
Team 4
Team 5
Spreadsheet: 861593d1709483849-formula-help-to-reflect-value-in-table-1-from-table-2-in-same-row-matching-criteria-demo-030324-aligw
Sheet: Statement

 |  | Table 1 |  |  | Table 2
 |  | Fruits | Month |  | Fruits | MONTHS
 |  | Income | 2023-04-30 00:00:00 | <----Criteria | Income | 2023-04-30 00:00:00 |  | 2023-06-30 00:00:00
 | Criteria---> | Water melon |  | <----Corrsponding value of same row from table 2 ( Cell G6) | Water melon | 550.739308999999 | 553.4624294999909 | 642.3954794000001 | Target value G6
 |  | Apple |  | <----Corrsponding value of same row from table 2 ( Cell G7) | Apple | 544.7793536999989 | 620.4713416000011 | 614.8303793000002 | Target value G7
 |  | Orange |  | <----Corrsponding value of same row from table 2 ( Cell G8) | Orange | 141.816426999999 | 148.993615 | 149.979060000001 | Target value G8
 |  | Mango |  |  | Mango | 1 | 1 | 1
 |  | Blackberry |  |  | Blackberry | 2.5 | 0.08499999999999996 | 17.835
 |  | Expenses |  |  | Expenses
 |  | Water melon |  |  | Water melon | 375.739308999999 | 378.4624294999909 | 467.3954794000001
 |  | Apple |  |  | Apple | 369.7793536999989 | 445.4713416000011 | 439.8303793000002
 |  | Orange |  |  | Orange | 33.183573000001 | 26.006385 | 25.020939999999
 |  | Mango |  |  | Mango | 174 | 174 | 174
 |  | Blackberry |  |  | Blackberry | 172.5 | 174.915 | 157.165
 |  | Need your help on to reflect the cell value of same row matching with month as criteria in first table in cell no. D5 against table 2. In give data set if I select month Apr 23 in table 1 ( D5), corresponding data in table 2 of April23 (column G)  should capture in D column against each fruit in same line. Hope I could explain my query.
Spreadsheet: 53550d1253516834-vlookup-issues-sample
Sheet: Data

Part | Stock | [NAME] | Cut | Stock Required | [NAME] | # Of Batches | Job Run Time
1400 | 1001 | 10 | 137 |  | 138
1401 | 1002 | 20 | 137 |  | 138
1402 | 1003 | 30 | 137 |  | 138
1403 | 1004 | 40 | 80 |  | 138
1404 | 1005 | 50 | 72 |  | 138
1405 | 1006 | 60 | 55 |  | 138
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 4.3

Cuadro 4.3
[NAME]
Divorcios registrados, según provincia y [NAME], 2010
[NAME] |  | Divorcios
 | Total País | 17674
Distrito Nacional |  | 4026
Azua |  | 242
 | Azua | 192
 | [NAME] | 1
 | [NAME] | 4
 | Padre las Casas | 16
 | Peralta | 4
 | [NAME] | 18
 | Guayabal | 3
 | Estebanía | 4
Baoruco |  | 62
 | Neiba | 18
 | Galván | 1
 | [NAME] | 13
 | Villa Jaragua | 9
 | Los Ríos | 21
Barahona |  | 251
 | Barahona | 190
 | Cabral | 3
 | Enriquillo | 11
 | Paraíso | 6
 | [NAME] | 36
 | [NAME] | 1
 | Polo | 4
Dajabón |  | 66
 | Dajabón | 56
 | Loma de Cabrera | 4
 | Partido | 5
 | [NAME] | 1
Duarte |  | 784
 | San Francisco de Macorís | 731
 | Arenoso | 17
 | Castillo | 6
 | Pimentel | 18
 | Villa Rivas | 8
 | [NAME] | 4
[NAME] |  | 20
 | [NAME] | 18
 | Bánica | 1
 | [NAME] | 1
El Seibo |  | 94
 | El Seibo | 77
 | Miches | 17
Espaillat |  | 444
 | Moca | 388
 | [NAME] | 15
 | [NAME] | 34
 | [NAME] | 7
[NAME] |  | 34
 | Jimaní | 1
 | Duvergé | 6
 | [NAME] | 22
 | [NAME] | 5
[NAME] |  | 200
 | Higüey | 196
 | San Rafael del Yuma | 4
[NAME] |  | 325
 | [NAME] | 320
 | Guaymate | 5
[NAME] |  | 1244
 | [NAME] | 991
 | Constanza | 66
 | Jarabacoa | 169
 | [NAME] | 18
María [NAME] |  | 244
 | Nagua | 144
 | Cabrera | 26
 | El Factor | 74
Montecristi |  | 139
 | Montecristi | 55
 | Castañuelas | 9
 | Guayubín | 17
 | [NAME] Santa Cruz | 22
 | [NAME] | 10
 | Villa Vázquez | 26
Pedernales |  | 9
 | Pedernales | 8
 | Oviedo | 1
Peravia |  | 193
 | Baní | 183
 | Nizao | 10
Puerto Plata |  | 446
 | Puerto Plata | 319
 | Altamira | 3
 | Guananico | 2
 | [NAME] | 37
 | Los Hidalgos | 3
 | Luperón | 14
 | Sosúa | 55
 | Villa Isabela | 13
[NAME] |  | 312
 | Salcedo | 165
 | Tenares | 91
 | Villa Tapia | 56
Samaná |  | 89
 | Samaná | 53
 | Sánchez | 25
 | [NAME] | 11
San Cristóbal |  | 284
 | San Cristóbal | 134
 | [NAME] | 35
 | [NAME] | 12
 | [NAME] | 85
 | Yaguate | 16
 | San Gregorio de Nigua | 1
 | Los Cacaos | 1
San Juan |  | 112
 | San Juan | 86
 | El Cercado | 5
 | [NAME] | 4
 | [NAME] | 13
 | [NAME] | 4
[NAME] |  | 369
 | [NAME] | 368
 | [NAME] | 1
[NAME] |  | 208
 | [NAME] | 170
 | Cevicos | 11
 | Fantino | 27
Santiago |  | 3180
 | Santiago | 2882
 | Bisonó | 67
 | Jánico | 16
 | [NAME] | 24
 | [NAME] las Matas | 36
 | Tamboril | 100
 | [NAME] | 55
Santiago Rodríguez |  | 159
 | San Ignacio de Sabaneta | 130
 | Villa los Almácigos | 16
 | Monción | 13
[NAME] |  | 310
 | [NAME] | 185
 | Esperanza | 81
 | Laguna Salada | 44
[NAME] |  | 804
 | Bonao | 775
 | Maimón | 18
 | Piedra Blanca | 11
[NAME] |  | 121
 | [NAME] | 33
 | Bayaguana | 39
 | Sabana Grande de Boyá | 20
 | Yamasá | 29
Hato Mayor |  | 172
 | Hato Mayor del [NAME] | 148
 | Sabana de la Mar | 21
 | El Valle | 3
[NAME] |  | 503
 | [NAME] | 503
Santo [NAME] |  | 2228
 | Santo Domingo Este | 613
 | Santo [NAME] | 667
 | Santo [NAME] | 910
 | Boca Chica | 27
 | San Antonio de Guerra | 10
 | [NAME] | 1