tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 767870d1644685112-time-between-steps-while-referencing-part-work-order-got-it-aligw
Sheet: Sheet2

Part_Work_Order | Date_Created | Current Cell | Current Step | Previous Step | Step_Complete_Date_Time | Route_Step_Num | Cell | Time differnce From last set
51128FC1 | 2022-01-25 10:21:46 | FINALINSP | 5 | 4 | 2022-01-27 17:35:16 | 2 | COREDRILL
51128FC1 | 2022-01-25 10:21:46 | FINALINSP | 5 | 4 |  | 5 | FINALINSP
51128FC1 | 2022-01-25 10:21:46 | FINALINSP | 5 | 4 | 2022-01-25 10:21:50 | 1 | LAYOUT
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-25 10:13:44 | 2 | ULELO
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-26 06:49:01 | 3 | MIRROR
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-31 07:16:42 | 4 | LAYOUT
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-31 07:16:48 | 6 | LAYOUT
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:07 | 8 | TILESAW
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:11 | 9 | 120
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:15 | 11 | 320
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:19 | 12 | TILESAW
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 |  | 13 | LAYOUT
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 |  | 14 | LAYOUT
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 09:50:11 | 1 | FINSAWS
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 22:41:36 | 3 | 120
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 23:10:30 | 4 | 320
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 23:10:33 | 5 | 120
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-31 23:25:56 | 6 | HUFFMAN
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 |  | 7 | FINALINSP
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-03 01:18:53 | 2 | FIN5AWJ
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-03 06:48:39 | 4 | ACID1
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-07 19:36:07 | 5 | BIREFRINGE
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-07 19:55:24 | 6 | BIREFRINGE
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-08 08:10:13 | 7 | LAYOUT_BR
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 8 | 120
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 9 | 320
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-01-25 08:52:34 | 1 | LAYOUT
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 10 | ACID1
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 11 | H2_LOAD
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 12 | LOREVIEW_C
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 13 | HUFFMAN
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 15 | RAMAN
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 16 | IP_FI
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 17 | [NAME]
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 18 | FINALINSP
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 20 | SETASMBLY
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 21 | SETASMBLY
Spreadsheet: 138471d1327677609-need-assistance-with-a-count-function-testexcel
Sheet: Sheet1

 | What I care about - | Need correctly working count function here!
 | Critical Variable | Count Column
 | 50
 | 50
 | 50
 | 50
 | 50
 | 0
 | 50
 | 50
 | 50
 | 50
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 50
 | 50
 | 50
 | 50
 | 50
 | 0
 | 50
 | 0
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 50
 | 0
 | 0
 | 0
 | 0
 | 50
 | 50
 | 50
 | 50
Spreadsheet: 63249d1264166950-another-nascar-pool-with-pts-and-rankings-nascar-pool
Sheet: pts per race

 |  | DRIVER PTS / RACE
DRIVER # | TOTAL PTS | RACE 1 | RACE 2 | RACE 3 | RACE 4 | RACE 5
1 | 16 | 6 | 10
2 | 9 | 2 | 7
3 | 9 | 5 | 4
4 | 2 | 0 | 2
5 | 13 | 10 | 3
6 | 7 | 1 | 6
7 | 10 | 9 | 1
8 | 8 | 8 | 0
9 | 9 | 0 | 9
10 | 12 | 7 | 5
FINISH POS | PTS AWARDED / RACE
1 | 10
2 | 9
3 | 8
4 | 7
5 | 6
6 | 5
7 | 4
8 | 3
9 | 2
10 | 1
Spreadsheet: c6d31b27-9794-4d4e-ac2e-6e039385655d
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 12/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
Sep | 29.205 | 27.17166666666667 | 31.03 | 28.81833333333333 | 24.21999999999998 | 21.03999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Oct | 28.555 | 26.47 | 30.385 | 28.1 | 23.04999999999998 | 18.54999999999998 | 34.85 | 35.35 | 23.3765 | 25.875
Nov | 28.34 | 26.22 | 30.17 | 27.95 | 22.23999999999998 | 15.63999999999998 | 35.35 | 34.1 | 23.375 | 24.375
Dec | 28.01 | 26.215 | 29.84 | 27.845 | 22.26999999999998 |  | 35.1 | 32.85 | 23.375 | 22.875
Jan | 27.93166666666667 |  | 29.76166666666667 |  | 22.77999999999998 |  | 35.35 |  | 25.875
Feb | 27.6325 |  | 29.4625 |  | 22.26999999999998 |  | 35.35 |  | 25.875
Mar | 27.79 |  | 29.61375 |  | 22.80999999999998 |  | 35.35 |  | 25.875
Apr | 27.1875 |  | 29.0675 |  | 23.07999999999998 |  | 35.35 |  | 25.875
May | 27.935 |  | 29.765 |  | 21.96999999999998 |  | 35.35 |  | 25.875
Jun | 28.345 |  | 30.175 |  | 22.71999999999998 |  | 35.35 |  | 25.875
Jul | 29.08 |  | 30.91 |  | 23.37999999999998 |  | 35.35 |  | 25.875
Aug | 28.065 |  | 29.795 |  | 23.07999999999998 |  | 35.35 |  | 25.875
Mkt year 2/ | 28.17305555555555 |  | 29.99795138888889 |  | 22.82249999999998 |  | 35.24583333333334 |  | 25.04179166666666
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 12/12/2013
Spreadsheet: 4e713173-f47b-45d8-8653-cc87175b14ca
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43609690 | 2014-10-16 22:08:37 | AXIS | 1 | 6 | 5 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43610077 | 2014-10-16 22:29:02 | ALLIES | 1 | 6 | 3 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43666931 | 2014-10-20 22:10:00 | AXIS | 1 | 10 | 7 | 766400 | Shellshock58 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43695350 | 2014-10-22 22:24:11 | AXIS | 1 | 6 | 5 | 358314 | gaita | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
43695808 | 2014-10-22 22:52:16 | ALLIES | 1 | 6 | 2 | 358314 | gaita | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
Spreadsheet: 384980d1427163361-find-closest-values-and-return-adjacent-values-new-store-planner
Sheet: Sheet2

Store Name |  | FY15 Sales |  | Transactions |  | Traffic
Store 201 |  | 1061300 |  | 32250 |  | 170000
Store 325 |  | 4188000 |  | 143300 |  | 700000
Store 310 |  | 3790000 |  | 130500 |  | 600000
Store 745 |  | 2552000 |  | 130400 |  | 400000
Store 240 |  | 2465000 |  | 58500 |  | 300000
 |  | 2500000
Spreadsheet: 680973d1591281933-summarise-data-using-formulas-example
Sheet: Result

Temporary difference
Non temporary difference
Temporary difference
Non temporary difference
Total
Spreadsheet: 782866d1654355914-formula-with-data-segmentation-help-a-brazilian-2022-06-03-oeldere2-pjuliocesar-seller-with-date-base
Sheet: Pivot Table

Rijlabels | Sum TOTAL | Count TOTAL
JULIO | 44 | 2
Grandes Lagos | 27 | 1
Matinho | 17 | 1
MURILO | 80 | 3
Curitiba | 24 | 1
Forteleza | 56 | 2
Eindtotaal | 124 | 5
Spreadsheet: 728435d1618463535-retrive-result-on-alternate-input-query
Sheet: Date

Date |  |  |  |  |  | Result |  |  | [NAME]
Series | ID | Qty |  |  |  | Series/ID | Qty
A1 | 1 | 50 |  |  |  | A1 |  |  | =INDEX(A:C,MATCH(G3,A:A,0),3)
A2 | 2 | 25 |  |  |  | 1 |  |  | =INDEX(A:C,MATCH(G4,B:B,0),3)
A3 | 3 | 15
B1 | 4 | 30
B2 | 5 | 60
B3 | 6 | 75
Spreadsheet: 838918d1691515767-how-to-create-a-dynamic-date-dynamic-date
Sheet: Sheet1

 | The date is automatically update based on the Data in "Table B"
 |  | Table A |  |  |  | Table B
 |  |  |  |  |  | The data in this  table will be copied manually
 |  | Date | Sales |  |  | Date | Receipt | Product | Sales
 |  | 2023-01-01 00:00:00 |  |  |  | 2023-01-01 00:00:00 | 1 | iPhone | 980
 |  |  |  |  |  | 2023-01-01 00:00:00 | 1 | Apple Watch | 320
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2 | MacBook | 2200
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | iPad | 950
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Earpod | 40
 | The date is automatically update based on the date in "Table B"
 |  | Table A |  |  |  | Table B
 |  |  |  |  |  | Now update the sale data in 2-Jan-2023
 |  | Date | Sales |  |  | Date | Receipt | Product | Sales
 |  | 2023-01-01 00:00:00 |  |  |  | 2023-01-01 00:00:00 | 1 | iPhone | 980
 |  | 2023-01-02 00:00:00 |  |  |  | 2023-01-01 00:00:00 | 1 | Apple Watch | 320
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2 | MacBook | 2200
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | iPad | 950
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Earpod | 40
 |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Nokia | 150
 | The date in "2-Jan-2023" is automatically updated base on the Table B |  |  |  |  | 2023-01-02 00:00:00 | 4 | Earpod | 30
 |  |  |  |  |  | 2023-01-02 00:00:00 | 5 | iPhone | 850
 |  |  |  |  |  | 2023-01-02 00:00:00 | 6 | iPad | 750
Spreadsheet: jeffrey_a_shankman__14007__Worksheet Kaufman 100085
Sheet: Headcount

2001-2003 OPERATING & STRATEGIC PLAN
Headcount Summary
 |  | Co.
 |  | CC No. |  |  |  | Estimated |  | Year End Plan
 |  |  |  |  |  | 12/31/00 |  | 2001 |  | 2002 |  | 2003
Domestic Employees
 | Full Time |  |  |  |  | 10 |  | 11 |  | 11 |  | 11
 | Part Time |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
International Employees
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
Total Domestic & International
 | Full Time |  |  |  |  |  |  |  |  | 11 |  | 11
 | Part Time |  |  |  |  |  |  |  |  | 1 |  | 1
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees (1)
 | 3rd Party Contract (2)
 | Total  *
Location of Total Employees (1)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Other |  |  |  | 11 |  | 12 |  | 12 |  | 12
 | Expatriates
 | International
 | Total
Location of 3rd Party Contractors (2)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Other
 | Expatriates
 | International
 | Total
Total Employees by Location *
 | * Totals should tie.
Spreadsheet: 215838d1361506660-help-creating-conditional-formatting-symbols-using-a-formula-example
Sheet: Sheet1

 | dec | jan | difference
campaign 1 | 14603 | 20058
campaign 2 | 187 | 186
campaign 3 | 2510 | 4945
campaign 4 | 927 | 1271
campaign 5 | 6 | 12
campaign 6 | 2577 | 2971
campaign 7 | 13174 | 23846
Spreadsheet: 438413d1451982624-another-simple-question-re-index-match-sample1
Sheet: BTT_HEALTH

PANTAWID PAMILYANG PILIPINO PROGRAM
Compliance Verification System
BENEFICIARY TRACKING TEMPLATE FOR CV FORM 3
(HEALTH)
City/Municipality |  | : ANGELES CITY
Province |  | : PAMPANGA
Region |  | : III
NO. | BARANGAY | FACILITY NAME | FACILITY ID | HOUSEHOLD ID | HOUSEHOLD MEMBER ID | NAME OF NON-COMPLIANT BENEFICIARY |  | AGE | 0-5 / PREGNANT | NON COMPLIANT  DUE TO | REASONS FOR NON-COMPLIANCE | CODE | ACTIONS TAKEN | STATUS
 |  |  |  |  |  | LAST NAME | FIRST NAME
1 |  |  |  |  | 1353096
2 |  |  |  |  | 1359612
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
 | Prepared by: |  |  | Reviewed by: |  |  |  |  |  |  | Noted by:
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | SWA |  |  | CL/Municipal link |  |  |  |  |  |  | Compliance Verification Officer II
Spreadsheet: joe_parks__14555__quotesheet
Sheet: 11-28 - 9 am

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
11/29 - 8:50 | Jan '02 | Prebon | Permian | Jan '02 - Mar '02 | 10,000/d | [NAME]
11/29 - 8:50 | Jan '02 | APB | Permian | Jan '02 - Mar '02 | 10,000/d | -.165 @
11/29 - 8:50 | Jan '02 | Amerex | Permian | Jan '02 - Mar '02 | 10,000/d | -.17 @ -.15
11/29 - 9:00 | Jan '02 | Natsource | Permian | Jan '02 - Mar '02 | 10,000/d | -.1625 @ -.15
11/29 - 8:50 | Jan '02 | APB | HSC | Jan '02 - Mar '02 | 10,000/d | -.0275 @ -.0225
11/29 - 8:55 | Jan '02 | Amerex | HSC | Jan '02 - Mar '02 | 10,000/d | -.0325 @
11/29 - 9:05 | Jan '02 | Natsource | HSC | Jan '02 - Mar '02 | 10,000/d | -.0325 @ -.0275
11/29 - 9:00 | Jan '02 | Prebon | Waha | Jan '02 - Mar '02 | 10,000/d | -.14 @ -.13
11/29 - 9:05 | Jan '02 | Amerex | Waha | Jan '02 - Mar '02 | 10,000/d | -.155 @
11/29 - 9:15 | Jan '02 | APB | Waha | Jan '02 - Mar '02 | 10,000/d | -.15 @ -.135
11/29 - 9:30 | Jan '02 | Natsource | Waha | Jan '02 - Mar '02 | 10,000/d | -.145 @
Spreadsheet: 91480d1291213922-colour-code-rows-in-excel-post-packs
Sheet: Post Chasing Data

In / Out | Date Posted | Contact /   No Contact | Chaser Name | Notes | Follow Up Call Notes
 | 15th Nov
 | 26153
 | 21929
 | 27795
 | 25699
 | 25745
 | 27799
 | 25305
 | 27807
 | 27812
 | 22148
 | 27820
 | 27830
 | 18121
 | 16th Nov
 | 27399
 | 26979
 | 27846
 | 27802
 | 27807
 | 22959
 | 26725
 | 27822
 | 26110
 | 27847
 | 27849
 | 17th Nov
 | 27878
 | 27879
 | 2568
 | 27874
 | 27872
 | 27875
 | 27892
 | 27093
 | 27886
 | 21678
 | 27558
 | BT18 1JX
 | 18th Nov
 | 27860
 | 17610
 | 27839
 | 27843
 | 27487
 | 27850
 | 27859
 | 27862
 | 27871
 | 27911
 | 27912
 | 27918
 | 21661
 | 21678
 | 27912
 | 27918
 | 21917
 | 27911
 | 27871
 | 27883
 | 26494
 | 27915
 | 27912
 | 27903
 | 27886
 | 17482
 | 26739
 | 21661
 | 27888
 | 26178
 | 27891
 | 27892
 | 27198
 | 27197
 | 27924
 | 27921
 | 27937
 | 27944
 | 27951
 | 19th Nov
 | 27924
 | 27937
 | 27944
 | 27951
 | 21678
 | 22nd Nov
 | 20250
 | 27987
 | 18063
 | 27971
 | 27758
 | 27991
 | 27980
 | 27968
 | 253962
 | 27974
 | 27965
 | 23rd Nov
 | 21814
 | 27846
 | 25896
 | 20146
 | 26686
 | 14580
 | 27047
 | 25954
 | 28025
 | 21020
 | 26147
 | 28027
 | 23650
 | 28036
 | 26686
 | 27994
 | 21855
 | 28022
 | 28016
 | 28014
 | 24th Nov
 | 28005
 | 28068
 | 28042
 | 28041
 | 28002
 | 15314
 | 28093
 | 28095
 | 25th Nov
 | 27331
 | 27849
 | 16262
 | 28141
 | 23390
 | 28097
 | 28142
 | 26th Nov
 | 26436
 | 27910
 | 26206
 | 27331
 | 27849
 | 16262
 | 2841
 | 23390
 | 28097
 | 28142
Spreadsheet: 222818d1363956106-bank-statements-formatting-cell-formatting-wont-change-statements-example
Sheet: Sorted

 | Date | Type | Description | Paid out
 | 2013-11-05 00:00:00 | VIS | STARBUCKS | 6.10
 | 2013-11-05 00:00:00 | VIS | STARBUCKS | 2.70
 | 2013-11-29 00:00:00 | VIS | STARBUCKS | 11.60
 | 2013-10-05 00:00:00 | VIS | STARBUCKS | 6.65
 | 2013-10-08 00:00:00 | VIS | STARBUCKS | 5.35
 | 2013-10-10 00:00:00 | VIS | STARBUCKS | 4.25
 | 2013-09-13 00:00:00 | VIS | STARBUCKS | 8.85
 | 2013-09-13 00:00:00 | VIS | STARBUCKS | 2.70
 | 2013-09-14 00:00:00 | VIS | STARBUCKS | 7.25
 | 2013-09-17 00:00:00 | VIS | STARBUCKS | 4.25
Spreadsheet: 010f2f11-3a47-4525-9222-cd4e9140da33
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
PROCUREMENT CARD CARDHOLDER TRANSACTION LOG
[NAME]: |  |  |  | Default Account Number:
Department: |  |  |  | Org. Code: |  | Statement Date:
Date | Vendor | Item Description | Purpose | Amount | Requestor | Control Agent Review | Date | Acct. No.
 |  |  | TOTAL | 0
Spreadsheet: 1be386a7-c183-4208-92ac-664425071f5a
Sheet: Group Vertices

Group | Vertex | Vertex ID
[NAME] | Iran
[NAME] | Emirate
[NAME] | Taiwan
[NAME] | Spain
[NAME] | [NAME]
[NAME] | Saudi Arabia
[NAME] | Newsland
[NAME] | Greece
[NAME] | Chili
[NAME] | Sweden
[NAME] | Scotland
[NAME] | Italy
[NAME] | Belgium
[NAME] | Austria
[NAME] | wales
[NAME] | Denmark
[NAME] | Malaysia
[NAME] | Switzerland
[NAME] | South Korea
[NAME] | Australia
[NAME] | France
[NAME] | Germany
[NAME] | England
[NAME] | Jordan
[NAME] | Singapor
[NAME] | China
[NAME] | Canada
[NAME] | Ireland
[NAME] | India
[NAME] | Japan
[NAME] | USA
Spreadsheet: 472582d1469642555-getpivotdata-formula-with-two-variables-month-and-country-getpivotdemo
Sheet: PivotTable

CurrentDate
July
 |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/1149378-getpivotdata-formula-with-two-variables-month-and-country.html
Country | MonthName | Sum of Traffic
Australia | January | 20
 | February | 20
 | March | 20
 | April | 20
 | May | 20
 | June | 20 |  |  |  |  | Month | Australia | France | US
 | July | 100 |  |  |  |  | January
France | January | 10 |  |  |  |  | February
 | February | 10 |  |  |  |  | March
 | March | 10 |  |  |  |  | April
 | April | 10 |  |  |  |  | May
 | May | 10 |  |  |  |  | June
 | June | 10 |  |  |  |  | July
 | July | 300
US | January | 50
 | February | 50
 | March | 50
 | April | 50
 | May | 50
 | June | 50
 | July | 200
Grand Total |  | 1080
Spreadsheet: 843139d1695087569-sumif-multiple-criteria-into-months-or-use-pivot-table-dataset-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Method 1 - Manual sum |  |  |  |  |  |  | Method 2 - sumifs add together |  |  |  |  |  |  | Method 3 - one formula approach?
Dept | Dept Name | Customer SKU | Description | UPC | Model# | Measure | 2023-09-11 00:00:00 | 2023-09-18 00:00:00 | 2023-09-25 00:00:00 | 2023-10-02 00:00:00 | 2023-10-09 00:00:00 | 2023-10-16 00:00:00 | 2023-10-23 00:00:00 | 2023-10-30 00:00:00 | 2023-11-06 00:00:00 | 2023-11-13 00:00:00 | 2023-11-20 00:00:00 | 2023-11-27 00:00:00 | 2023-12-04 00:00:00 | 2023-12-11 00:00:00 | 2023-12-18 00:00:00 | 2023-12-25 00:00:00 |  | Customer SKU | Measure | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  | Customer SKU | Measure | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  | sumproduct + index match combo function?
2 | PC&Mac Input/Output | 50497228 | Description 1 | 1 |  | On Order Qty | 0 | 130 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 50497228 | On Order Qty |  |  |  |  |  | 50497228 | On Order Qty |  |  |  |  |  | Pivot table to automate?
2 | PC&Mac Input/Output | 50497228 | Description 1 | 1 |  | Plan Receipt | 0 | 130 | 0 | 50 | 10 | 30 | 50 | 80 | 80 | 60 | 70 | 120 | 130 | 60 | 50 | 50 |  | 50497228 | Plan Receipt |  |  |  |  |  | 50497228 | Plan Receipt
2 | PC&Mac Input/Output | 43552159 | Description 2 | 2 |  | On Order Qty | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 43552159 | On Order Qty |  |  |  |  |  | 43552159 | On Order Qty
2 | PC&Mac Input/Output | 43552159 | Description 2 | 2 |  | Plan Receipt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 10 | 0 | 20 | 10 | 20 | 0 | 0 |  | 43552159 | Plan Receipt |  |  |  |  |  | 43552159 | Plan Receipt
2 | PC&Mac Input/Output | 23613552 | Description 3 | 3 |  | On Order Qty | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 23613552 | On Order Qty |  |  |  |  |  | 23613552 | On Order Qty
2 | PC&Mac Input/Output | 23613552 | Description 3 | 3 |  | Plan Receipt | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 12 | 12 | 30 | 24 | 12 | 12 | 12 | 6 | 12 |  | 23613552 | Plan Receipt |  |  |  |  |  | 23613552 | Plan Receipt
5 | PC & Mac Accessories | 34824773 | Description 4 | 4 |  | On Order Qty | 0 | 0 | 0 | 360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 34824773 | On Order Qty |  |  |  |  |  | 34824773 | On Order Qty
5 | PC & Mac Accessories | 34824773 | Description 4 | 4 |  | Plan Receipt | 0 | 0 | 0 | 360 | 0 | 0 | 30 | 60 | 30 | 60 | 60 | 60 | 60 | 30 | 90 | 60 |  | 34824773 | Plan Receipt |  |  |  |  |  | 34824773 | Plan Receipt
2 | PC&Mac Input/Output | 44916798 | Description 5 | 5 |  | On Order Qty | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 44916798 | On Order Qty |  |  |  |  |  | 44916798 | On Order Qty
2 | PC&Mac Input/Output | 44916798 | Description 5 | 5 |  | Plan Receipt | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 5 | 10 | 5 | 10 | 10 | 0 | 5 | 0 |  | 44916798 | Plan Receipt |  |  |  |  |  | 44916798 | Plan Receipt
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Sal Spinosa

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
It seems like a matter of contractual obligation.  Also benefits like this can help attract high quality teachers.
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
This is an approach that should yield positive results.
Teaching Profession: Simplifying Professional Relicensing
Disagree
Explain your relicensing position, if you choose
From my understanding of it, re-licencing isn't particularly burdensome.  Teachers need to do their share to maintain licencsing and in the process the quality of their work.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | [NAME] 1496 Waitsfield, VT  05673 | [NAME], Washington House District 7 | No |  | Washington
Spreadsheet: 746376d1630669095-get-best-match-for-a-description-where-is-doesnt-exactly-match-best-match
Sheet: Sheet1

List A |  | List B Code |  | List B
Code | Description |  |  | Description
ITM001 | Copper Tube Terminal 10mm M10 |  |  | CT6M8 Crimp-Pak Copper Tube Terminal
ITM002 | Copper Tube Terminal 10mm M12 |  |  | CT10M6 Crimp-Pak Copper Tube Terminal
ITM003 | Copper Tube Terminal 10mm M5 |  |  | CT10M8 Crimp-Pak Copper Tube Terminal
ITM004 | Copper Tube Terminal 10mm M6 |  |  | CT10M10 Crimp-Pak Copper Tube Terminal
ITM005 | Copper Tube Terminal 10mm M8 |  |  | CT16M6 Crimp-Pak Copper Tube Terminal
ITM006 | Copper Tube Terminal 16mm M10 |  |  | CT16M8 Crimp-Pak Copper Tube Terminal
ITM007 | Copper Tube Terminal 16mm M12 |  |  | CT16M10 Crimp-Pak Copper Tube Terminal
ITM008 | Copper Tube Terminal 16mm M14 |  |  | CT25M6 Crimp-Pak Copper Tube Terminal
ITM009 | Copper Tube Terminal 16mm M16 |  |  | CT25M8 Crimp-Pak Copper Tube Terminal
ITM010 | Copper Tube Terminal 16mm M20 |  |  | [NAME]
ITM011 | Copper Tube Terminal 16mm M8 |  |  | CT25M12 Crimp-Pak Copper Tube Terminal
 |  |  |  | CT35M6 Crimp-Pak Copper Tube Terminal
 |  |  |  | CT35M8 Crimp-Pak Copper Tube Terminal
 |  |  |  | CT35M10 Crimp-Pak Copper Tube Terminal
Spreadsheet: 86962d1286900735-return-results-based-on-rows-and-columns-sumrange-1-
Sheet: Total

Year | Month | Total
09-10 | JUL | 55.18348934611016
Drop-Down List
06-07 | JUL
07-08 | AUG
08-09 | SEP
09-10 | OCT
10-11 | NOV
11-12 | DEC
12-13
13-14
14-15