tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1bfba48d-e7c4-4574-9a1c-2cc74af52a48
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
State Representatives - CARROLL County - Democratic
District No. 1 (1) | [NAME], d | [NAME], r | [NAME]
[NAME] | 194 | 2
Hart's Location | 9 |  | 2
[NAME] | 106 | 6 | 5
Totals | 309 | 8 | 7
District No. 2 (3) | Bridgham, d | Buco, d | Pollock, d | White, d | Umberger, r | [NAME], r | McClure, r | Steiner, r | [NAME]
Chatham | 9 | 19 | 8 | 14
Conway | 252 | 399 | 339 | 345 | 6 | 6 | 2 | 3 | 3
Eaton | 60 | 26 | 40 | 12
Hale's Location | 3 | 4 | 5 | 3 |  |  | 3
Totals | 324 | 448 | 392 | 374 | 6 | 6 | 5 | 3 | 3
District No. 3 (2) | Ticehurst, d | Thomson, r | McConkey, r | [NAME]
Albany | 42 |  |  | 2
Freedom | 109 | 1 |  | 1
[NAME] | 167
Tamworth | 227 |  |  | 9
Totals | 545 | 1 |  | 12
District No. 4 (2) | Albee, d | Lyon, r | Askew, r | [NAME], r | Crawford, r | [NAME]
Moultonborough | 226 |  |  |  | 11
Sandwich | 190 |  |  |  |  | 2
Tuftonboro | 140 |  |  |  |  | 5
Totals | 556 |  |  |  | 11 | 7
District No. 5 (3) | Lavender, d | Merrow, r | [NAME], r | Olimpio, r | [NAME]
[NAME] | 52 |  |  |  | 6
[NAME] | 73 | 2 |  |  | 2
Ossipee | 137 | 6 | 1 |  | 4
Wakefield | 181 | 2 |  |  | 1
Totals | 443 | 10 | 1 |  | 13
District No. 6 (2) | White, d | Woods, d | Ahlgren, r | [NAME], r | [NAME]
Wolfeboro | 339 | 409
District No. 7 (1) F | Butler, d | Callis, r | Tregenza, r | [NAME]
Albany | 47
[NAME] | 236 | 1
Chatham | 15
Conway | 529 | 4 |  | 6
Eaton | 57 | 1 |  | 1
Freedom | 108
Hale's Location | 4
Hart's Location | 14
[NAME] | 148 |  |  | 1
[NAME] | 176
Tamworth | 221 |  | 1
Totals | 1555 | 6 | 1 | 8
District No. 8 (1) F | Wiley, d | [NAME], r | [NAME]
[NAME] | 53
[NAME] | 79
Moultonborough | 236
Ossipee | 158 |  | 1
Sandwich | 208 |  | 1
Tuftonboro | 132
Wakefield | 182
Totals | 1048 |  | 2
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -41815 | -41797
2 | -36544 | -36093
3 | -35547 | -35000
4 | -50308 | -49522
5 | -40937 | -42451
6 | -37277 | -37076
7 | -46378 | -45798
8 | -39077 | -41888
9 | -40231 | -45000
10 | -35607 | -37607
11 | -40133 | -39474
12 | -41999 | -41904
13 | -41383 | -40511
14 | -51938 | -49873
15 | -35328 | -34932
16 | -31944 | -31192
17 | -38883 | -37933
18 | -35984 | -35687
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 133095
2001-07-18 00:00:00
Spreadsheet: 160733d1339177448-excel-2007-look-up-question-lookup-from-multiple-tabs
Sheet: 110

Attendance Rules: 5 – 5.75   NoCorrective Action 6 – 7.00  No Corrective Action taken; Notice of Attendance Record 7.25 – 7.75   Verbal Warning 8 – 8.75  Written Warning 9 – 9.75  Final Written Warning with 120-day probation Next Point (10) - Review for Termination |  | Occurrence Rules: **Occurrences stay on the record for a rolling one year. **Occurrences stay on until an Approved FMLA letter is issued from UNUM. A doctors excuse does not remove an Occurrence. 8-15 minutes tardy, early departure or shift interruption~.25 16 or more minutes tardy, early departure or shift interruption ~ .50 3 hours or more absent when scheduled to work ~ 1 2 consecutive work days absent (10 hours for part-time)~2 3 or more consecutive days absent (15 hours for part-time)~2.25 Call-off or no-show for scheduled & communicated overtime~1 |  |  |  |  |  |  |  | 0 | n/a
 |  |  |  |  |  |  |  |  |  | 1 | Applied for
 |  |  |  |  |  |  |  |  |  | 0.25 | Approved
 |  |  |  |  |  |  |  |  |  |  | Denied
Tech Name | [NAME] Doe #4 | Total Occurrences
Tech Number | 110 | Corrective Action Step
Date | Occurrence Issued | FMLA   Applied for/ Approved/Denied | Comments
Spreadsheet: 108855d1305810026-vlookup-my-appologies-sampledata
Sheet: Sheet3

#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_cluster_update" "@ix_sys_error" "adInteger" "adParamOutput" "4" "0"
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_cluster_update" "@ix_sys_error" "adInteger" "adParamOutput" "4" "0"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_dummy_product_update"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_event_schedule_update" "@ix_sys_error" "adInteger" "adParamOutput" " 4" "0"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_event_based_planogram_creation"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_product_validation_dummy_creation"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Range_Event_Type"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Planning_Grp_Event"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Range_Event"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Display_Grp_in_Event"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_RngCls_Disp_Grp_Clstr"
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Spreadsheet: 865105d1712167144-complex-index-match-to-calculate-weight-progression-from-a-data-table-with-two-variables-rpe-chart-and-example-etaf
Sheet: Ark1

 |  |  |  |  |  |  |  |  |  | RPE range 1-10
 |  |  |  |  |  |  |  |  |  | [NAME] range = 1-12
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  | 10 | 1 | 0.955 | 0.922 | 0.892 | 0.863 | 0.837 | 0.811 | 0.786 | 0.762 | 0.739 | 0.707 | 0.68
 |  |  |  |  |  |  | 9.5 | 0.978 | 0.939 | 0.907 | 0.878 | 0.85 | 0.824 | 0.799 | 0.774 | 0.751 | 0.723 | 0.694 | 0.667
 |  |  |  |  |  |  | 9 | 0.955 | 0.922 | 0.892 | 0.863 | 0.837 | 0.811 | 0.786 | 0.762 | 0.739 | 0.707 | 0.68 | 0.653
 |  |  |  |  |  |  | 8.5 | 0.939 | 0.907 | 0.878 | 0.85 | 0.824 | 0.799 | 0.774 | 0.751 | 0.723 | 0.694 | 0.667 | 0.64
 |  |  |  |  |  |  | 8 | 0.922 | 0.892 | 0.863 | 0.837 | 0.811 | 0.786 | 0.762 | 0.739 | 0.707 | 0.68 | 0.653 | 0.626
 |  |  |  |  |  |  | 7.5 | 0.907 | 0.878 | 0.85 | 0.824 | 0.799 | 0.774 | 0.751 | 0.723 | 0.694 | 0.667 | 0.64 | 0.613
 |  |  |  |  |  |  | 7 | 0.892 | 0.863 | 0.837 | 0.811 | 0.786 | 0.762 | 0.739 | 0.707 | 0.68 | 0.653 | 0.626 | 0.599
 |  |  |  |  |  |  | 6.5 | 0.878 | 0.85 | 0.824 | 0.799 | 0.774 | 0.751 | 0.723 | 0.694 | 0.667 | 0.64 | 0.613 | 0.586
 |  |  |  |  |  |  | 6 | 0.863 | 0.833142857142857 | 0.808571428571429 | 0.784464285714286 | 0.760678571428571 | 0.7375 | 0.712785714285714 | 0.682642857142857 | 0.652642857142857 | 0.624821428571429 | 0.599357142857143 | 0.572357142857143
 |  |  |  |  |  |  | 5.5 | 0.842166666666667 | 0.818119047619047 | 0.794559523809524 | 0.771178571428571 | 0.747940476190476 | 0.725166666666667 | 0.700488095238095 | 0.669452380952381 | 0.63870238095238 | 0.610809523809524 | 0.585880952380953 | 0.558880952380953
 |  |  |  |  |  |  | 5 | 0.825166666666667 | 0.803119047619047 | 0.781559523809524 | 0.758178571428571 | 0.735940476190476 | 0.713166666666667 | 0.688488095238095 | 0.656452380952381 | 0.62570238095238 | 0.597809523809524 | 0.572880952380953 | 0.545880952380953
 | Example
 |  | Weight | [NAME] | RPE | Corresponding percentage | E1RM
 | Week 1 | 200 | 5 | 7
 | Week 2 |  | 5 | 8
Spreadsheet: 677715d1589480914-need-formula-to-extract-values-from-the-data-sample
Sheet: Dash

INDEX | YEAR | MONTH |  |  |  | INDEX
1 | 1 | 1
 |  |  | Dates | MN | HR | RH |  |  |  |  | I need the kind of formula so that the values can be taken from the DATA sheet and can be changed if I change the INDEX or YEAR or MONTH. I have got a huge data for the 53 years.. Please help me. Thanks
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
 |  |  | 31
Spreadsheet: 806915d1669666756-solved-not-reading-sumif-formula-sales-report-all-brands-2023-sample-
Sheet: Total Sales by State

 |  |  |  | SALES SUMMARY - ALL BRANDS
 |  |  |  | 2023 vs 2022
 |  | [NAME] | 2023 | VS | 2022 |  | Increase/
 |  |  |  |  |  |  | decrease
 |  | AZ |  |  | 0
 |  | AR |  |  | 0
 |  | CA |  |  | 0
 |  | CO |  |  | 0
 |  | CT |  |  | 0
 |  | FL |  |  | 0
 |  | GA |  |  | 0
 |  | HI |  |  | 0
 |  | ID |  |  | 0
 |  | IL |  |  | 0
 |  | IN |  |  | 0
 |  | IA |  |  | 0
 |  | KS |  |  | 0
 |  | KY |  |  | 0
 |  | LA |  |  | 0
 |  | MD |  |  | 0
 |  | MA |  |  | 0
 |  | MI |  |  | 0
 |  | MN |  |  | 0
 |  | MS |  |  | 0
 |  | MO |  |  | 0
 |  | MT |  |  | 0
 |  | NV |  |  | 0
 |  | NJ |  |  | 0
 |  | NM |  |  | 0
 |  | NY |  |  | 0
 |  | NC |  |  | 0
 |  | OK |  |  | 0
 |  | OR |  |  | 0
 |  | PA |  |  | 0
 |  | RI |  |  | 0
 |  | TN |  |  | 0
 |  | TX |  |  | 0
 |  | UT |  |  | 0
 |  | VA |  |  | 0
 |  | VT |  |  | 0
 |  | WA |  |  | 0
 |  | WI |  |  | 0
 |  | WY |  |  | 0
 |  | TOTAL
Spreadsheet: 14ea4223-bb98-45dd-bfe5-3edd81f7114a
Sheet: Sheet1

Sex Offense Victims | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Forcible Rape
Sex and Race
by Age, 2011
Age | Total Victims | Sex |  |  | Race
 |  | Male | Female | Unknown | White | Black | American Indian/ Alaskan Native | Asian/Pacific Islander | Unknown
Total | 27023 | 527 | 26496 | 0 | 20192 | 5368 | 283 | 178 | 1002
15 and under | 8772 | 302 | 8470 | 0 | 6430 | 1810 | 70 | 46 | 416
16 – 20 | 6430 | 99 | 6331 | 0 | 4796 | 1326 | 82 | 44 | 182
21 – 25 | 3692 | 26 | 3666 | 0 | 2790 | 764 | 39 | 28 | 71
26 – 30 | 2339 | 26 | 2313 | 0 | 1837 | 418 | 22 | 18 | 44
31 – 35 | 1621 | 23 | 1598 | 0 | 1246 | 305 | 25 | 13 | 32
36 – 40 | 1197 | 13 | 1184 | 0 | 941 | 205 | 20 | 8 | 23
41 – 45 | 968 | 11 | 957 | 0 | 758 | 181 | 4 | 11 | 14
46 – 50 | 701 | 9 | 692 | 0 | 545 | 130 | 9 | 5 | 12
51 – 55 | 422 | 7 | 415 | 0 | 319 | 87 | 6 | 1 | 9
56 – 60 | 200 | 3 | 197 | 0 | 149 | 42 | 3 | 3 | 3
61 – 65 | 117 | 2 | 115 | 0 | 88 | 23 | 2 | 1 | 3
66 and over | 194 | 1 | 193 | 0 | 150 | 38 | 0 | 0 | 6
Unknown Age | 370 | 5 | 365 | 0 | 143 | 39 | 1 | 0 | 187
Spreadsheet: 879508d1727087470-better-formula-please-monthly-timesheet-sep-2024
Sheet: 2

 | Company Name |  |  |  |  |  |  |  |  |  | Helper Columns |  |  |  | Dayshift |  |  |  | 08:00 - 17:00 | 8
 | Monthly Time Sheet |  |  | 2024-09-11 00:00:00 |  |  |  |  |  |  | Saturday
 | Employee Name |  |  | N | Surname |  | Helper Columns |  |  |  | Sunday |  |  |  | Rate per Hr |  |  |  | 47
 | Site Working |  |  | Site A |  |  |  |  |  |  |  |  |  |  | Allowance |  |  |  | 0
 | Date | Day | Shift |  | Hours |  |  |  |  |  |  |  | Comments |  | Hours worked and Night Shift Allowance
 |  |  | Day | Night | Start Time | End Time | Time | Hrs at Work | Min Lunch | Actual Hrs |  | OT |  |  | Normal Hrs | [NAME] | OverTime | [NAME] | PPH | Allowance
 | 2024-09-01 00:00:00 |  | False | False | 8:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 | 17:00:00
 | 2024-09-02 00:00:00 |  | False | False | 6:00:00 | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 17:00:00
 | 2024-09-03 00:00:00 |  | False | False | 8:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 18:00:00
 | 2024-09-04 00:00:00 |  | False | False | 6:00:00 | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 | 16:00:00
PPH | 2024-09-05 00:00:00 |  | False | False | 7:00:00 | 17:00:00
 | 2024-09-06 00:00:00 |  | False | False
 | 2024-09-07 00:00:00 |  | False | False | 8:00:00 | 18:00:00
 | 2024-09-08 00:00:00 |  | False | False | 8:00:00 | 17:00:00
 | 2024-09-09 00:00:00 |  | False | False
 | 2024-09-10 00:00:00 |  | False | False
 | 2024-09-11 00:00:00 |  | False | False
 | 2024-09-12 00:00:00 |  | False | False
 | 2024-09-13 00:00:00 |  | False | False
 | 2024-09-14 00:00:00 |  | False | False
 | 2024-09-15 00:00:00 |  | False | False
 | 2024-09-16 00:00:00 |  | False | False
 | 2024-09-17 00:00:00 |  | False | False
 | 2024-09-18 00:00:00 |  | False | False
 | 2024-09-19 00:00:00 |  | False | False
 | 2024-09-20 00:00:00 |  | False | False
 | 2024-09-21 00:00:00 |  | False | False
 | 2024-09-22 00:00:00 |  | False | False
 | 2024-09-23 00:00:00 |  | False | False
 | 2024-09-24 00:00:00 |  | False | False | 8:00:00 | 17:00:00
 | 2024-09-25 00:00:00 |  | False | False
 | 2024-09-26 00:00:00 |  | False | False
 | 2024-09-27 00:00:00 |  | False | False
 | 2024-09-28 00:00:00 |  | False | False
 | 2024-09-29 00:00:00 |  | False | False
 | 2024-09-30 00:00:00 |  | False | False
 |  |  | False | False
 | Starting Date:
Spreadsheet: 860310d1708449079-how-to-add-a-number-simultaneously-to-a-series-of-numbers-on-excel-without-manual-editing-excel-sheet-sample-data
Sheet: Sheet1

Week of: | Description | Amount | Office 1 | Office 2 | Office 3 | Office 4 | Office 5 | CAPEX | TOTAL | CHECK
2024-01-01 00:00:00 | Making of chairs
 | Making of tables
 | Making of computer desk
 | Making of seating sofa
 | Making of filing cabinet
 | Making of photocopy stand
Spreadsheet: 880799d1728649747-advanced-filter-advancedfilter-1-
Sheet: Advanced Filter

Month | Year | Cost |  |  |  | Cost | Cost | Cost
January | 2015 | 1050 |  |  |  | >=1300 | <=1700 | <>1500
May | 2015 | 1050
June | 2015 | 1050
June | 2015 | 1050
August | 2015 | 1050
January | 2015 | 1105
May | 2015 | 1105
June | 2015 | 1105
June | 2015 | 1105
August | 2015 | 1105
January | 2015 | 1200
February | 2015 | 1200
March | 2015 | 1200
April | 2015 | 1200
May | 2015 | 1200
June | 2015 | 1200
June | 2015 | 1200
July | 2015 | 1200
August | 2015 | 1200
November | 2015 | 1200
November | 2015 | 1211
February | 2015 | 1350
March | 2015 | 1350
April | 2015 | 1350
July | 2015 | 1350
November | 2015 | 1350
February | 2015 | 1435
March | 2015 | 1435
April | 2015 | 1435
July | 2015 | 1435
November | 2015 | 1435
February | 2015 | 1500
March | 2015 | 1672
April | 2015 | 1672
July | 2015 | 1672
January | 2015 | 1690
May | 2015 | 1690
June | 2015 | 1690
June | 2015 | 1690
August | 2015 | 1690
Spreadsheet: 741628d1627217296-dynamically-referenced-rows-across-two-worksheets-sample
Sheet: System Data Sheet

XYZ0AA00AB
XYZ0AAC0C0
XYZ3AA00AB
XYZ3AAC015
[NAME]
XYZ0AA001F
Revenue
XYZ0AAABAB
XYZ3AAAB1F
XYZ3AAAB17
XYZ0AAAB1F
XYZ0AAABCC
S Revenue
XYZ0AA40AB
XYZ0AA401C
XYZ0AA4013
XYZ0AA30AB
XYZ0AA30AA
XYZ0AAC015
XYZAA140AB
XYZ0AA401F
XYZAAAB0C0
[NAME]
C Revenue
XYZ0AA0014
RC Deductions
Spreadsheet: joe_parks__14748__ITM Phy 02 Positions
Sheet: Financial Book Position

TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT
To: | Order |  |  |  |  |  | Index
In-the-money Live Physical 2002
Physical | NG-Price Exotics |  | NGEXOTIC | P |  |  | 0
Index | 2 |  | NGHEDGE | P | 0
Gas Daily |  |  |  |  | 0
Gas Daily Index |  |  |  |  |  |  | 0
Basis - Notional | 3 |  | NGLTX | P | 0
Basis - Equivalent | 4 |  | NGFPL | P | 0
Price | 5 |  | NGFPL | D | 0
TOTAL:
Basis Roll-off
Spreadsheet: 755252d1636734498-articles-by-client-ef1557_products
Sheet: Folha2

 |  |  |  | CLIENT | 5
 |  |  |  | NAME
 |  |  |  | Nº ARTICLE | NAME ARTICLE | PRICE | DISCOUNT | FINAL PRICE
Spreadsheet: 2f23fdef-4ade-43b2-b8f7-4284494045ac
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8922 | 56326 | Martin | Hikanik | SVK | 207 | 00:14:52 | 00:00:35 | 00:27:22 | [NAME] | 00:16:31 | 1 | 01:00:12
8922 | 68714 | Pavel | Norkin | RUS | 208 | [NAME] | 00:00:34 | [NAME] | 00:01:40 | 00:21:27 | 2 | 01:26:25
Spreadsheet: 77641d1278072303-merging-multiple-rows-into-a-single-row-example-1-
Sheet: Sheet2

Currently
Reference | Order numbers
224668 | 100019
224668 | 100025
224668 | 100076
551244 | 100011
551244 | 100012
551244 | 100015
Require
Reference | Order numbers
551244 | 100011 | 100012 | 100015
224668 | 100019 | 100025 | 100076
Spreadsheet: 126137d1319544710-pivot-filter-based-on-custom-values-not-working-sample
Sheet: Sheet4

 |  | Data | Period
 |  | Sum of USD |  | Absolute Difference |  | % Difference
Account | Opco | 005.2011 | 004.2011 | 005.2011 | 004.2011 | 005.2011 | 004.2011
3rd Party Creditors | 1219 | -76369679 | -85589863 |  | -9220184 |  | 0.1207309513504699
 | 1227 | -6620957 | -8929502 |  | -2308545 |  | 0.3486724049106496
 | 1269 | -6319649 | -6278604 |  | 41045 |  | -0.006494822734617065
 | 1281 | -5309422 | -5467854 |  | -158432 |  | 0.02983978293682438
 | 1330 | -4031535 | -2335656 |  | 1695879 |  | -0.4206534235719149
 | 1909 | -1936818 | -2229519 |  | -292701 |  | 0.1511246797582426
 | 1919 | -4617658 | -4701647 |  | -83989 |  | 0.01818865754025092
 | 2254 | -394000 | -627000 |  | -233000 |  | 0.5913705583756346
 | 4356 | -6550411 | -6264131 |  | 286280 |  | -0.04370412787838809
 | 4357 | -25712170 | -11189860 |  | 14522310 |  | -0.5648029707333142
3rd Party Creditors Total |  | -137862299 | -133613636 |  | 4248663 |  | -0.03081816443522388
3rd Party Debtors | 1031 | 4870883 | 2909115 |  | -1961768 |  | -0.4027540797017707
 | 1063 | 529535 | 536979 |  | 7444 |  | 0.01405761658813865
 | 1155 | 2349000 | 2036000 |  | -313000 |  | -0.1332481907194551
 | 1219 | 122131785 | 139837231 |  | 17705446 |  | 0.1449700092404283
 | 1226 | 2922735 | 5224716 |  | 2301981 |  | 0.7876119456604858
 | 1227 | 6901726 | 7806110 |  | 904384 |  | 0.1310373665949648
 | 1269 | 15118856 | 18268142 |  | 3149286 |  | 0.208301871517263
 | 1281 | 71118110 | 73430823 |  | 2312713 |  | 0.03251932594946632
 | 1330 | 7782807 | 6413347 |  | -1369460 |  | -0.1759596505476752
 | 1379 | 10897727 | 11916049 |  | 1018322 |  | 0.09344352267220495
 | 1646 | 8032395 | 10090939 |  | 2058544 |  | 0.2562802252628263
 | 1909 | 44128887 | 40983009 |  | -3145878 |  | -0.07128840571030037
 | 1919 | 7993241 | 8350947 |  | 357706 |  | 0.04475105905101573
 | 1941 | 572085 | 3000482 |  | 2428397 |  | 4.244818514731203
 | 4356 | 2857935 | 2544801 |  | -313134 |  | -0.1095665226815865
 | 4357 | -25553151 | -25424417 |  | 128734 |  | -0.005037891413078567
 | 4741 | 2802486 | 2632068 |  | -170418 |  | -0.06080958120754216
3rd Party Debtors Total |  | 285457042 | 310556341 |  | 25099299 |  | 0.08792671157854988
Grand Total |  | 147594743 | 176942705 |  | 29347962 |  | 0.1988415129392515
Spreadsheet: 732362d1620911407-pivot-tables-show-report-filter-pages-greyed-out-pivottables-show-filters
Sheet: Summary

Customer Name | (All)
Product Description | Sum of Sales Value
Men crop top black | 4600
Men dress shirt black | 1050
Men dress shirt grey | 496
Men Shorts | 1272
Men shorts black | 1500
Men shorts grey | 1172
Men type T simple black | 10652
Men type T simple white | 8304
Men's tank top white | 156
Smartphone case diamond | 13628
Smartphone case simple | 2744
Travel bag black | 11024
Travel bag red | 12496
Grand Total | 69094
Spreadsheet: darrell_schoolcraft__7809__imbalsumm0108
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 53256 | 50455
2 | 35225 | 42864
3 | 9749 | 31925
4 | 13680 | 13148
5 | 39257 | 39446
6 | 39309 | 39455
7 | 17078 | 21455
8 | 38021 | 38122
9 | 50313 | 34788
10 | 41422 | 41455 | -663
11 | 41404 | 41455 | -302
12 | 51512 | 46739
13 | 46816 | 46871
14 | 44923 | 44937
15 | 49883 | 44937
16 | 51915 | 46937
17 | 54916 | 49937
18 | 63907 | 58936
19 | 63938 | 58937
20 | 58756 | 58727
21 | 49619 | 49630
22 | 62677 | 62726
23 | 25217 | 24938
24 | 47555 | 47771
25 | 61590 | 59450
26
27
28
29
30
31
2001-07-31 00:00:00
2001-08-25 00:00:00
CBS Dollars
Spreadsheet: 764074d1642565698-consolidate-multiple-tabs-with-different-headers-not-using-power-query-copy-of-sample-book-1
Sheet: Tab 4

User ID | Building | Stage
5069 | North | Won
5400 | North | Won
5600 | South | Won
5401 | East | Won
5402 | Soth | Won
5403 | South | Won
5404 | North | Won
5405 | East | Won
Spreadsheet: 851238d1701453269-count-staff-attendance-and-provide-date-attended-training-dates-2023-sweettalkinwoman-
Sheet: COURSE 1

Training Schedule
Date | Event | Time | Venue | Status | Attendee | Attended
 | COURSE 1 |  | Seminar Room |  |  | Yes
 |  |  |  |  |  | Forgot
Spreadsheet: 100402d1298777591-sumifs-alternative-for-excel-2003-sumproduct-not-working-sumif-example
Sheet: Monday

Weekly [NAME]
Hour | T/C | TTTL | TTL
0600 - 0700 | 6 | 56 | 9.333333333333334 |  |  |  | #N/A
0700 - 0800 | 12 | 82 | 6.833333333333333
0800 - 0900 | 41 | 717 | 17.48780487804878
0900 - 1000 | 20 | 394 | 19.7
1000 - 1100 | 26 | 699 | 26.88461538461538
Spreadsheet: 824941d1680968443-search-multiple-columns-and-output-into-another-column-testsheet
Sheet: Before 

ID | Start time | Completion time | [NAME] | Name | Customer | Make | Model | [NAME] | BMW Model | [NAME] | [NAME] | Mercedes Model | Nissan Model | Volkswagen Model | New Model | Registration No | Mileage | VIN No | JOB NO
6 | 2023-04-05 22:21:20 | 2023-04-05 22:21:48 | [EMAIL] | Leaf Heap | AGL | Mercedes |  |  |  |  |  | A-Class |  |  |  | RDHH | 4553 | RDHGERHEBHR | 4535
7 | 2023-04-05 22:22:45 | 2023-04-05 22:23:11 | [EMAIL] | Leaf Heap | DLG | Citroen |  |  |  | C1 |  |  |  |  |  | BXFGHBDRH | ET4TE4 | DRHXTJHTJFTXJTFXJ | 5EY5EY
8 | 2023-04-05 22:24:33 | 2023-04-05 22:25:16 | [EMAIL] | Leaf Heap | KC | Nissan |  |  |  |  |  |  | Juke |  |  | GDZSH | 43443 | ESTGHZERHDHXH | 45E454
9 | 2023-04-05 22:26:22 | 2023-04-05 22:26:56 | [EMAIL] | Leaf Heap | [NAME] | Ford |  |  |  |  | Puma |  |  |  |  | [NAME] | 5345 | TDSRGSERHZT | 4744
Spreadsheet: 803505d1667495820-xlookup-with-wildcards-book2
Sheet: Sheet1

Employee ID | First name | Last name | Location | Temp | Location Code |  | Location Code | Location ID
11111111 | [NAME] | [NAME] | 3862 At-Home Texas TXC2 | N |  |  | AZA1 | 3822
22222222 | [NAME] | Jones | MNC1 - 3850 At-Home | Y |  |  | BCP1 | 3895
33333333 | Mark | Smith | 3845 - Louisiana | N |  |  | [NAME] | 3827
 |  |  |  |  |  |  | HIA1 | 3831
 |  |  |  |  |  |  | [NAME] | 3836
 |  |  |  |  |  |  | INC1 | 3840
 |  |  |  |  |  |  | KYC1 | 3843
 |  |  |  |  |  |  | [NAME] | 3845
 |  |  |  |  |  |  | LEX1 | 3889
 |  |  |  |  |  |  | MBC1 | 3816
 |  |  |  |  |  |  | MNC1 | 3850
 |  |  |  |  |  |  | NVP1 | 3855
 |  |  |  |  |  |  | ORP1 | 3866
 |  |  |  |  |  |  | TXC2 | 3862
 |  |  |  |  |  |  | TXM1 | 3875
 |  |  |  |  |  |  | UTM1 | 3877
 |  |  |  |  |  |  | WYM1 | 3882