tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0f92affa-ea4c-4b88-9294-c33c78e5b60c
Sheet: Families

Tract Number | All Families(1) | Average Family Size | Married Couples w/ Own Children(2) | Single Parent [NAME] w/ Own Children(2) | Married Couples -  w/o [NAME]) | All Other Families | All Non-Family HHs(3) | HHs w/ Children as % All HHs(4)
3521 | 545 | 2.56 | 92 | 36 | 301 | 116 | 1014 | 0.082
3522 | 388 | 2.81 | 91 | 46 | 178 | 73 | 703 | 0.126
3523 | 458 | 2.88 | 113 | 62 | 212 | 71 | 579 | 0.169
3524 | 459 | 3.27 | 111 | 191 | 70 | 87 | 251 | 0.425
3525 | 622 | 3.28 | 155 | 177 | 163 | 127 | 662 | 0.259
3526 | 584 | 3.09 | 161 | 112 | 223 | 88 | 484 | 0.256
3527 | 517 | 3.03 | 130 | 125 | 168 | 94 | 538 | 0.242
3528 | 497 | 3.13 | 128 | 86 | 186 | 97 | 457 | 0.224
3529 | 480 | 2.73 | 146 | 43 | 242 | 49 | 833 | 0.144
3530 | 568 | 2.76 | 137 | 99 | 245 | 87 | 1273 | 0.128
3531 | 689 | 2.72 | 198 | 82 | 336 | 73 | 836 | 0.184
3532 | 579 | 2.84 | 163 | 96 | 229 | 91 | 879 | 0.178
3533 | 689 | 2.78 | 206 | 109 | 281 | 93 | 1048 | 0.181
3534 | 540 | 3.01 | 141 | 138 | 151 | 110 | 488 | 0.271
3535 | 499 | 2.81 | 123 | 111 | 175 | 90 | 783 | 0.183
3536 | 606 | 2.6 | 174 | 65 | 305 | 62 | 1082 | 0.142
3537 | 494 | 2.56 | 112 | 43 | 270 | 69 | 1344 | 0.084
3538 | 759 | 2.43 | 164 | 61 | 450 | 84 | 2006 | 0.081
3539 | 396 | 2.61 | 130 | 37 | 195 | 34 | 861 | 0.133
3540 | 549 | 2.46 | 130 | 28 | 350 | 41 | 1493 | 0.077
3541 | 525 | 2.39 | 99 | 33 | 339 | 54 | 1052 | 0.084
3542 | 776 | 2.72 | 246 | 45 | 429 | 56 | 621 | 0.208
3543 | 767 | 2.89 | 231 | 115 | 317 | 104 | 710 | 0.234
3544 | 400 | 2.78 | 131 | 53 | 154 | 62 | 410 | 0.227
3545 | 501 | 2.59 | 149 | 32 | 288 | 32 | 781 | 0.141
3546 | 1003 | 2.99 | 307 | 176 | 367 | 153 | 1000 | 0.241
3547 | 501 | 2.71 | 153 | 64 | 221 | 63 | 684 | 0.183
3548 | 378 | 2.88 | 133 | 36 | 161 | 48 | 597 | 0.173
3549 | 1289 | 3.17 | 427 | 313 | 323 | 226 | 775 | 0.359
3550 | 537 | 2.86 | 154 | 54 | 244 | 85 | 776 | 0.158
Citywide | 17595 | 2.83 | 4835 | 2668 | 7573 | 2519 | 25020 | 0.176
Spreadsheet: 23501d1213036710-sorting-a-block-of-data-sortarray
Sheet: Data

254 | 108 | 183 | 78 | 130 | 302 | 250 | 454 | 434 | 237
464 | 261 | 184 | 413 | 469 | 477 | 278 | 170 | 193 | 186
352 | 497 | 32 | 118 | 377 | 266 | 278 | 343 | 49 | 385
233 | 379 | 481 | 322 | 499 | 152 | 300 | 297 | 128 | 222
93 | 185 | 360 | 219 | 410 | 439 | 188 | 474 | 30 | 165
168 | 394 | 312 | 336 | 212 | 61 | 162 | 336 | 450 | 75
489 | 240 | 55 | 146 | 213 | 261 | 350 | 245 | 338 | 63
215 | 323 | 342 | 323 | 276 | 228 | 494 | 23 | 431 | 142
62 | 284 | 157 | 111 | 426 | 312 | 20 | 319 | 76 | 240
239 | 218 | 199 | 288 | 242 | 247 | 217 | 311 | 356 | 159
460 | 305 | 60 | 51 | 477 | 288 | 177 | 209 | 176 | 4
323 | 71 | 87 | 212 | 164 | 24 | 407 | 338 | 206 | 398
420 | 411 | 490 | 173 | 202 | 22 | 399 | 358 | 295 | 116
71 | 164 | 287 | 75 | 166 | 179 | 313 | 88 | 375 | 28
72 | 52 | 214 | 46 | 156 | 3 | 25 | 287 | 438 | 15
43 | 392 | 387 | 29 | 383 | 431 | 206 | 394 | 476 | 437
397 | 60 | 189 | 176 | 219 | 58 | 82 | 176 | 307 | 497
214 | 182 | 434 | 290 | 440 | 116 | 72 | 44 | 474 | 278
196 | 77 | 221 | 197 | 441 | 354 | 259 | 338 | 471 | 376
153 | 422 | 437 | 110 | 319 | 328 | 278 | 396 | 339 | 373
Spreadsheet: 733391d1621542721-second-screen-projections-issue-example-book
Sheet: Points Table

 | Name |  |  | Points Total |  |  | Weeks Played
Spreadsheet: 61577d1262489374-changing-horizontal-to-vertical-references-workbook
Sheet: 5

Day: |  |  | Date: |  |  |  |  |  | ENGINEER:
 |  |  |  |  |  |  |  | Description | Piling | Concrete | Structural steel | Pre Cast Concrete | Foundation, Excavation and Backfill | Metal Work | Glazing | Finishes | Roofing and [NAME]
 |  |  |  |  |  |  |  | Cost Code | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240 | 260
LABOUR | Start |  | Finish |  | Hours |  | Rate
TOTAL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAY LABOUR
TOTAL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PLANT
5t Excavator
[NAME]
Water Cart 1
12G Grader
Roller
Backhoe
Bobcat
Crane
Concrete Pump
TOTAL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SUB-CONTRACTOR
TOTAL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HIRE EQUIPMENT
2inch pump
TOTAL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERIES
Steel Reinforcement |  |  |  |  |  |  |  |  | 5
Formwork
Concrete
TOTAL |  |  |  |  |  |  |  |  | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY TOTAL $ |  |  |  |  |  |  |  |  | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PRODUCTION
Steel Reo FIxed (T)
[NAME] (m2)
Concrete Poured (m3)
TOTAL
DAILY RATE ($/m^3) |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 101815d1299860101-excel-2007-matching-a-value-in-a-different-workbook-from-2-rows-and-copy-a-value-from-that-column-original
Sheet: IN

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | ID | PRODUCT ID | SITE | CUSTOMER REFERENCE | LINE CIRCUIT ID | ORDER STATUS | ORDER STATUS Additional infos  reason hold-reject-sna
 | SITE INFO |  |  |  | LINE & PLANNING INFO
 | 0 | IL | 1 |  | ABCD
 | HQ | [PHONE] | 2 |  | A
 | HQ | [PHONE] | 3 |  | B
 | HQ | [PHONE] | 4 |  | C | REQUEST_DONE
 | HQ | [PHONE] | 5 |  | D | REQUEST_DONE
 | 1 | [PHONE] | 6 |  | E | REQUEST_DONE
 | 2 | [PHONE] | 7 |  | F | REQUEST_DONE
 | 3 | [PHONE] | 8 |  | G | REQUEST_DONE
 | 4 | [PHONE] | 9 | 1157 | H | REQUEST_DONE
 | 5 | [PHONE] | 10 | 1151 | I | REQUEST_DONE
Spreadsheet: 9dc010a2-0528-48e6-bced-54821f0b5b3a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Instructions for Exporting QuickBooks data
Where did my worksheet go?
 | When you export data to a new workbook, your new worksheet containing exported data goes to Sheet 1. When you export to an existing workbook,
 | the new worksheet is placed in front of the last active sheet where it will be named "SheetX" using the next available number in the series.
How do I make sure this tips sheet isn't exported with the QuickBooks report in the final workbook?
 | Before exporting, on the Export Report Basic tab, deselect the option to include the instruction worksheet.
How can I customize and update my worksheet?
 | You can set up Excel links between 2 or more worksheets.  (See Microsoft Excel Help for details about linking in Excel.) You can use this
 | feature to setup links between a QuickBooks summary report and your customized sheet.
 |  | >> Choose one sheet as your source worksheet into which you'll export QuickBooks data. Then create another worksheet where you can
 |  | customize your data and link the data between that sheet and the source worksheet.
 |  | >> Export your source data to an existing worksheet and overwrite the current data so that the new data is used by any Excel links and formulas.
 |  | >> Create Excel links between a QuickBooks data worksheet and another worksheet in the workbook.
Troubleshooting: Why don't my links work correctly after exporting data?
 | Be aware that any difference in the structure of the current report from the report that you used when setting up links, can cause mismatch
 | in the links between worksheets. If you are seeing wrong data in your customized worksheet, then you may have:
 |  | >> Moved or deleted elements, or changed the structure of the report in some way?  For example:
 |  |  | You might have moved or deleted items from item list which gets used in a report like Inventory Valuation report.
 |  |  | You might have moved or deleted accounts from accounts list which gets used in a report like Profit and Loss standard report.
 |  | >> You are using a report related to accounts and have account(s) with no activity associated and did not choose to display "All rows".
 |  |  | TIP: Choose display All rows (available for most of the reports), [NAME] report->Display->Advanced->Display Rows->All rows
 |  | >> Deleted exported data sheet which serves as data source.
Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: BudgetedResourceCostSumm

 | [NAME]? | Rate |  |  |  | 2011 |  |  |  |  |  |  |  |  | 2012 |  |  | Y1 | 2012 |  |  |  |  |  |  |  |  | 2013 |  |  | Y2 | 2013 |  |  |  |  |  |  |  |  | 2014 |  |  | Y3
 |  |  |  |  |  | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL |  | TOTAL
ACTIVITIES & TIMELINE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COST |  |  |  |  |  |  |  |  |  |  |  |  | COST |  |  |  |  |  |  |  |  |  |  |  |  | COST |  | COST
Totals
Total Implementation Cost
Spreadsheet: 700674d1603286121-select-specific-n-of-rows-which-meet-condition-to-send
Sheet: Ian

Ian | US | GB
country | QS Login | Status | [NAME] | associate_task | associate_queue | associate | metric_wk_no | associate_action | correct associate action
Spreadsheet: chris_germany__2321__2001new02
Sheet: CGAS

 |  | 20500
 | Citygate | Pool |  | 456379 |  |  |  |  |  | Deal 597193 less Storage |  |  |  |  |  |  | IF On |  |  |  | 563831 / 563837 |  |  | Deal 549411
 | Deal | Deal |  | Storage | Storage |  | CES | ENA |  | Actuals |  |  |  |  | Adjusted |  | Deal |  | [NAME] |  | Undertakes |  |  | Citygate
 | 597193 | 597332 |  | Gross | Net |  | Transport | Transport |  | From ENA |  | FOM | 3rd Party | Spot Deals | FOM |  |  |  | [NAME] SALES |  | [NAME] |  | Gas Daily | Price
1 | 72496 | 21066 |  | 51899 |  |  | 140099 |  |  |  |  | 25038 |  |  |  |  |  |  |  |  |  |  | 6.095
 | 104663 |  |  | 84751 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.13
 | 83817 |  |  | 63472 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.885
 | 59870 |  |  | 38991 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.885
 | 67399 |  |  | 46688 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.885
 | 76710 |  |  | 56207 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.1
 | 64907 |  |  | 44141 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.855
 | 22588 |  |  | 1127 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.93
 | 34003 |  |  | 12797 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5
 | 102194 |  |  | 82010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.37
 | 98105 |  |  | 77830 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.37
 | 64558 |  |  | 43783 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.37
 | 51937 |  |  | 30880 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.925
 | 50850 |  |  | 29770 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.89
 | 70352 |  |  | 49709 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.155
 | 78837 |  |  | 58381 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.67
 | 101388 |  |  | 81434 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.76
 | 99085 |  |  | 79080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.76
 | 51845 |  |  | 30788 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.76
 | 60502 |  |  | 39637 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.76
 | 101068 |  |  | 81109 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.43
 | 94730 |  |  | 74628 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.48
 | 85710 |  |  | 65407 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.33
 | 40340 |  |  | 19024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.305
 | 47822 |  |  | 26673 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.305
 | 71539 |  |  | 50922 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.305
 | 79906 |  |  | 59476 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.305
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.34
 |  |  |  | 1448997
Spreadsheet: 723223d1615563537-count-duplicate-values-in-the-same-cell-and-in-a-range-example-1-2-1-
Sheet: Sheet1

 | INVOICE DATE | SITE | INVOICE AMOUNT | CHARGABLE | PLOT(S)
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 123, 124, 125, 126
 | 2021-03-04 00:00:00 | Gipping [NAME] | 20 | YES | 108, 110
 | 2021-03-05 00:00:00 | Gipping [NAME] | 20 | NO | 108, 987
 | 2021-03-02 00:00:00 | Gipping [NAME] | 20 | NO | 108
 | 2021-02-03 00:00:00 | Gipping [NAME] | 20 | YES | 109
 | 2021-02-01 00:00:00 | Gipping [NAME] | 20 | NO | 123, 124
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 82, 83
 | 2021-02-25 00:00:00 | Colne Meadows | 20 | NO | 2
 | 2021-02-24 00:00:00 | Colne Meadows | 20 | NO | 1
 | 2021-02-20 00:00:00 | Colne Meadows | 20 | NO | 1, 2
 | 2021-02-19 00:00:00 | Colne Meadows | 20 | NO | 3
 | 2021-02-18 00:00:00 | Colne Meadows | 20 | NO | 3, 4
 | 2021-02-17 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-15 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-16 00:00:00 | Gipping [NAME] | 20 | YES | 127
Spreadsheet: 845869d1697193970-auto-generate-group-number-and-reference-back-to-previous-grouping-number-book1
Sheet: Sheet1

 |  |  |  | [NAME] | Grouping
 |  |  |  | BPR59715 | Group 1
 |  |  |  | BPR31607 | Group 2
 |  |  |  | BPR32267 | Group 3
 |  |  |  | BPR82594 | Group 4
 |  |  |  | BPR64995 | Group 5
 |  |  |  | BPR95261 | Group 6
 |  |  |  | BPR55820 | Group 7
 |  |  |  | [NAME] | Group 8
 |  |  |  | BPR40132 | Group 9
 |  |  |  | BPR40975 | Group 10
 |  |  |  | BPR56524 | Group 11
 |  |  |  | BPR32267 | Group 3
 |  |  |  | BPR82594 | Group 4 |  |  | If Countif =1, then Group +1, else refer back to previous
 |  |  |  | BPR40975 | Group 10
 |  |  |  | BPR11111 | Group 12
 |  |  |  | BPR11112 | Group 13
 |  |  |  | BPR11113 | Group 14
 |  |  |  | BPR11114 | Group 15
 |  |  |  | BPR11115 | Group 16
 |  |  |  | BPR11111 | Group 12
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Scores

Week # | Cajun Coonasses | Capo Crimini | [NAME] | Deadbirds | Gator Dawgs | King of Queens | Muckdogs | Mudcats | Pics Hitmen | Sharks | Thundermutts | Wet Farts
1 | 347 | 404 | 380 | 278 | 339.5 | 356.5 | 366.5 | 236.5 | 441.5 | 461.5 | 364 | 372.5
2 | 333 | 278 | 277.5 | 317.5 | 225.5 | 222 | 259 | 231 | 294 | 237 | 303.5 | 165
3 | 239.5 | 188 | 197 | 275 | 222.5 | 291.5 | 258 | 264.5 | 325.5 | 190 | 271.5 | 233
4 | 284 | 244.5 | 291 | 276.5 | 311.5 | 213.5 | 341.5 | 274.5 | 310 | 274 | 221.5 | 279.5
5 | 245.5 | 180.5 | 242.5 | 277 | 208.5 | 354 | 302 | 255 | 304 | 209 | 286.5 | 245.5
6 | 246 | 255.5 | 248.5 | 325.5 | 316.5 | 271.5 | 225 | 210 | 278.5 | 299.5 | 259 | 283.5
7 | 252 | 292.5 | 285.5 | 205 | 353 | 286.5 | 255.5 | 308 | 296 | 242.5 | 157.5 | 416
8 | 298 | 312 | 265.5 | 200 | 257 | 310 | 233 | 193 | 291.5 | 250 | 125 | 192
9 | 235.5 | 253 | 252 | 227 | 198 | 257.5 | 299 | 221.5 | 339.5 | 322.5 | 272 | 213
10 | 271 | 186 | 295.5 | 216 | 233.5 | 249 | 213 | 242.5 | 281 | 291.5 | 275 | 256
11 | 303 | 319 | 298.5 | 279.5 | 260 | 337.5 | 210.5 | 313.5 | 269.5 | 279 | 218 | 321
12 | 258.5 | 239 | 317 | 355 | 275 | 287 | 341.5 | 228.5 | 263 | 247.5 | 259 | 192.5
13 | 300.5 | 165 | 344.5 | 330.5 | 224.5 | 260 | 306 | 247 | 231 | 224.5 | 241.5 | 293.5
14 | 201 | 268.5 | 319.5 | 204.5 | 266.5 | 246 | 275.5 | 196 | 310 | 274.5 | 183 | 292.5
15 | 319 | 432.5 | 407.5 | 395.5 | 416 | 332 | 333.5 | 428.5 | 441.5 | 370 | 229.5 | 393.5
16 | 296.5 | 266.5 | 333.5 | 214 | 304.5 | 205 | 279.5 | 248.5 | 213.5 | 263 | 247.5 | 201.5
17 | 205 | 196 | 224.5 | 260.5 | 212.5 | 324.5 | 248.5 | 240 | 290 | 285.5 | 215.5 | 278.5
18 | 273.5 | 212 | 252 | 258.5 | 235 | 254.5 | 212 | 256 | 222.5 | 279.5 | 188 | 199
19 | 315 | 155 | 291.5 | 296.5 | 241.5 | 277.5 | 344.5 | 212 | 312 | 316.5 | 232.5 | 181
20 | 261.5 | 258 | 241 | 196.5 | 180 | 205.5 | 329 | 206 | 249.5 | 267 | 221.5 | 264.5
21 | 183.5 | 188.5 | 318 | 154.5 | 222 | 215 | 351.5 | 266.5 | 333.5 | 325.5 | 197.5 | 203
22 | 274 | 200 | 330.5 | 309 | 187 | 253.5 | 289.5 | 301 | 353.5 | 357 | 257.5 | 240.5
TOTAL
Spreadsheet: 293789d1391093302-csv-format-problem-book1
Sheet: Sheet1

TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST
TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST
TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST
TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST
Spreadsheet: 839223d1691759222-sumifs-results-in-value-error-simple-sample-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Projected Time | Projected Time
 | Summary Line --> |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gru |  |  |  | Party Overview
 |  |  |  | Gather Ingredients |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Gru |  |  |  | Assigned To | Projected Hours
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Gru
 |  |  |  |  | Water |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Gru |  |  |  | [NAME]
 |  |  |  |  | Batter |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Gru |  |  |  | Minion 1
 |  |  |  |  | Icing |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | Gru |  |  |  | Minion 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Summary Line --> |  | Get Supplies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Minion 1
 |  |  |  | Drive to Store |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Minion 1
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | Minion 2
 |  |  |  |  | Table cloth |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | [NAME]
 |  |  |  |  | Plasticware |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Minion 1
Spreadsheet: 848199d1698967911-formula-to-determine-if-a-text-ar-to-be-added-sample
Sheet: Sheet1

 |  |  | S/No | Date | CAR Number | Result |  |  |  |  |  | S/No | Imp Date | CAR Number
 |  |  | 1 | 2023-10-01 00:00:00 | 7 | 07 |  |  |  |  |  | 1 | 2023-11-03 00:00:00 | 9
 |  |  | 2 | 2023-10-02 00:00:00 | T7 | 07 |  |  |  |  |  | 2 | 2023-11-03 00:00:00 | 7
 |  |  | 3 | 2023-10-15 00:00:00 | 7 | 07 |  |  |  |  |  | 2 | 2023-11-03 00:00:00 | T7
 |  |  | 4 | 2023-11-03 00:00:00 | 7 | 07 AR
 |  |  | 5 | 2023-11-03 00:00:00 | T7 | 07 AR
 |  |  | 6 | 2023-10-07 00:00:00 | 9 | 09
 |  |  | 7 | 2023-10-04 00:00:00 | T9 | 09
 |  |  | 8 | 2023-11-05 00:00:00 | T10 | 10 AR
Spreadsheet: 887430d1737661059-checking-names-in-2-columns-when-some-slightly-differ-example-2-
Sheet: Sheet2

[NAME] | ARAYA BLEN
[NAME] | DEPREZ ROBIN
Binet Olivia lili Sifa | BOELPAEP LEA
[NAME] | BINET OLIVIA
Canivell Lightowler [NAME] | BOGAERTS LOISE
Pierard Noah | CANIVELL LIGHTOWLER CARLOS
Pierard [NAME] | PIERARD CHARLIE
Pierard Milo | PIERARD MILO
 | PIERARD NOAH
Spreadsheet: 116835d1312214549-if-function-between-sheets-with-text-and-numbers-load-board
Sheet: LAH

Driver # | Book Date | Company | Load # | [NAME] | Fuel | [NAME] | Shared | PU Date | PU Time | City, State | Drop Date | Drop Time | City, State | Truck | Trailer #(s) | Percentage | BOLs | Location? | Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Received? | CH or ME or DM
LAH001 | 2011-07-30 00:00:00 | CH [NAME] | 94950354 | 750 | 321 |  |  | 2011-08-01 00:00:00 | Anytime | Fargo, ND | 2011-08-02 00:00:00 | 6:00 - 14:00 | Albertville, MN | 12 | 120684
LAH002 | 2011-08-02 00:00:00 | CH [NAME] | 94950354 | 750 | 365 |  |  | 2011-08-02 00:00:00 | Apt | Alsip, IL | 2011-08-03 00:00:00 | 6:00 - 14:00 | Kansas City, MO | 5 | 843530
Spreadsheet: 84100d1284099419-transfer-raw-data-to-table-workbook1
Sheet: Sheet1

TIME | GROUP | VALUE
Time 1 | Group A | 1
Time 1 | Group B | 2 |  |  |  |  | GROUP A
Time 1 | Group C | 1 |  |  |  |  | Time 1 | Time 2
Time 1 | Group D | 4 |  |  |  |  | 1 | 1
Time 1 | Group E | 3
Time 1 | Group F | 1
Time 1 | Group G | 2 |  |  |  |  | Time 1 | Time 2
Time 1 | Group H | 4
Time 2 | Group A | 1
Time 2 | Group B | 4
Time 2 | Group C | 5
Time 2 | Group D | 2
Time 2 | Group E | 1
Time 2 | Group F | 4
Time 2 | Group G | 3
Time 2 | Group H | 2
Time 3 | Group A | 4
Time 3 | Group B | 1
Time 3 | Group C | 3
Time 3 | Group D | 3
Time 3 | Group E | 4
Time 3 | Group F | 2
Time 3 | Group G | 3
Time 3 | Group H | 1
GROUP A
Time 1 | Time 2 | Time 3
1 | 1 | 4
GROUP B
Time 1 | Time 2 | Time 3
2 | 4 | 1
GROUP C
Time 1 | Time 2 | Time 3
1 | 5 | 3
..etc same for group D, E, F, G, H
Spreadsheet: 838433d1691005468-artificial-grand-total-above-pivot-that-still-aligns-with-unit-after-slicers-used-sample-data
Sheet: Data

Fiscal Year | Facility | Supplier | Unit | Paid | UnitID | PO# | PO Amount | Unit Description
FY19 | Store 1 | A-Plus | ABC | 400 | 111 | P1 | 5000 | Apple
FY17 | Store 2 | A-Plus | ABC | 300 | 111 | P2 | 7000 | Apple
FY16 | Store 3 | B Street Food Company | DEF | 200 | 112 | P3 | 9000 | [NAME]
FY20 | Store 1 | A-Plus | ABC | 100 | 111 | P4 | 20000 | Apple
FY16 | Store 1 | C Group Incorporated | OPS | 2000 | 113 | P7 | 10000 | Apple
FY17 | Store 2 | A-Plus | ABC | 100 | 111 | P60 | 9000 | Apple
FY18 | Store 3 | A-Plus | ABC | 300 | 111 | P90 | 8000 | Apple
FY19 | Store 3 | B Street Food Company | DEF | 2000 | 112 | P21 | 60000 | [NAME]
FY20 | Store 3 | C Group Incorporated | OPS | 1200 | 113 | [NAME] | 12000 | Strawberries
Spreadsheet: 856649d1705854706-concatenate-with-indirect-function-21012024-sample-file-for-xlforum
Sheet: Xls1

BrCd | PrdCd | AcctId
2 | 601 | 14026
2 | 601 | 14029
11 | 751 | 14030
6 | 601 | 14034
9 | 601 | 14036
24 | 755 | 17
2 | 601 | 18
23 | 753 | 1
2 | 805 | 3
4 | 414 | 4
2 | 601 | 1
6 | 712 | 53
2 | 601 | 14048
Spreadsheet: 642803d1569414054-vlookup-functions-to-generate-report-example-az
Sheet: Sheet1

Name | Job Assigned | Hours Worked |  | Results
[NAME] | Data Entry | 3
[NAME] | Documentation | 2
[NAME] | Scanning | 3
[NAME] | Reception | 1
[NAME] | Sales | 4
[NAME] | Data Entry | 2
[NAME] | Marketing | 5
[NAME] | Back Office | 3
[NAME] | Data Entry | 3
[NAME] | Documentation | 6
[NAME] | Sales | 3
[NAME] | Data Entry | 2
[NAME] | Reception | 2
[NAME] | Scanning | 2
[NAME] | Sales | 2
[NAME] | Back Office | 1