tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 21569d1209211825-pivot-table-cow-question
Sheet: Sheet1

One approach to the Data
Cow # | 1st Baby Born Date | 1st Baby Sold Date | 1st Baby Born Sold Price | 2nd Baby Born Date | 2nd Baby Born Sold Date | 2nd Baby Born Price | 3rd Baby Born Date | 3rd Baby Born Sold date | 3rd Baby Born Price Sold
500 | 2008-01-01 00:00:00 | 2008-09-27 00:00:00 | 500 | 2009-01-01 00:00:00 | 2009-09-28 00:00:00 | 500 | 2010-01-01 00:00:00 | 2010-09-28 00:00:00 | 500
525 | 2008-06-06 00:00:00 | 2009-03-03 00:00:00 | 500 | 2008-06-06 00:00:00 | 2009-03-03 00:00:00 | 500 | 2008-06-06 00:00:00 | 2009-03-03 00:00:00 | 500
575 | 2008-10-10 00:00:00 | 2009-07-07 00:00:00 | 500 | 2008-10-10 00:00:00 | 2009-07-07 00:00:00 | 1901-05-14 00:00:00 | 2008-10-10 00:00:00 | 2009-07-07 00:00:00 | 500
Pivot Table Result which is incorrect - the month column is all weird
 | Data | 1st Baby Sold Date | 2nd Baby Born Sold Date | 3rd Baby Born Sold date
 | Sum of 1st Baby Born Sold Price |  |  |  |  |  | Sum of 2nd Baby Born Price |  |  |  |  |  | Sum of 3rd Baby Born Price Sold |  |  |  |  |  | Total Sum of 1st Baby Born Sold Price | Total Sum of 2nd Baby Born Price | Total Sum of 3rd Baby Born Price Sold
 | 2008-09-27 00:00:00 |  | 2009-03-03 00:00:00 |  | 2009-07-07 00:00:00 |  | 2008-09-27 00:00:00 |  | 2009-03-03 00:00:00 |  | 2009-07-07 00:00:00 |  | 2008-09-27 00:00:00 |  | 2009-03-03 00:00:00 |  | 2009-07-07 00:00:00
 | 2009-09-28 00:00:00 | Sep-09 Total | 2009-03-03 00:00:00 | [NAME] | 2009-07-07 00:00:00 | Jul-09 Total | 2009-09-28 00:00:00 | Sep-09 Total | 2009-03-03 00:00:00 | [NAME] | 2009-07-07 00:00:00 | Jul-09 Total | 2009-09-28 00:00:00 | Sep-09 Total | 2009-03-03 00:00:00 | [NAME] | 2009-07-07 00:00:00 | Jul-09 Total
Cow # | 2010-09-28 00:00:00 |  | 2009-03-03 00:00:00 |  | 2009-07-07 00:00:00 |  | 2010-09-28 00:00:00 |  | 2009-03-03 00:00:00 |  | 2009-07-07 00:00:00 |  | 2010-09-28 00:00:00 |  | 2009-03-03 00:00:00 |  | 2009-07-07 00:00:00
500 | 500 | 500 |  |  |  |  | 500 | 500 |  |  |  |  | 500 | 500 |  |  |  |  | 500 | 500 | 500
525 |  |  | 500 | 500 |  |  |  |  | 500 | 500 |  |  |  |  | 500 | 500 |  |  | 500 | 500 | 500
575 |  |  |  |  | 500 | 500 |  |  |  |  | 500 | 500 |  |  |  |  | 500 | 500 | 500 | 500 | 500
Grand Total | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 1500 | 1500 | 1500
Pivot Table Look Desired
 | Month Sold
Cow # | 2008-09-01 00:00:00 | 2009-03-01 00:00:00 | 2008-07-01 00:00:00 | 2009-09-01 00:00:00 | 2009-03-01 00:00:00 | 2009-07-01 00:00:00 | 2010-09-01 00:00:00 | 2009-03-01 00:00:00 | 2009-07-01 00:00:00 | Total
500 | 500 |  |  | 500 |  |  | 500 |  |  | 1500
525 |  | 500 |  |  | 500 |  |  | 500 |  | 1500
575 |  |  | 500 |  |  | 500 |  |  | 500 | 1500
Total | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 4500
Spreadsheet: 33001d1229204817-excel-as-a-data-base-disk-content
Sheet: Lookup

 | Disk Title | Data0001
 |  | Movies
 | Item 1 | Balls Of Fury
 | Item 2 | [NAME] It Something I said
 | Item 3 | Bridget Jones 2 - The Edge Of Reason
 | Item 4 | Click
 | Item 5 | Daddy Day Camp
 | Item 6 | 0
 | Item 7 | 0
 | Item 8 | 0
 | Item 9 | 0
 | Item 10 | 0
 | Item 11 | 0
 | Item 12 | 0
 | Item 13 | 0
 | Item 14 | 0
 | Item 15 | 0
 | Item 16 | 0
 | Item 17 | 0
 | Item 18 | 0
 | Disk Title | Data0002
 |  | Movies
 | Item 1 | [NAME]
 | Item 2 | I Now [NAME] and [NAME]
 | Item 3 | Knocked Up
 | Item 4 | Rush Hour 3
 | Item 5 | SuperBad
 | Item 6 | 0
 | Item 7 | 0
 | Item 8 | 0
 | Item 9 | 0
 | Item 10 | 0
 | Item 11 | 0
 | Item 12 | 0
 | Item 13 | 0
 | Item 14 | 0
 | Item 15 | 0
 | Item 16 | 0
 | Item 17 | 0
 | Item 18 | 0
Spreadsheet: 162784d1340060664-copy-of-managers-clients-info-from-master-list-database-example
Sheet: Database

Name | SSN | CAT | VASH | Refer Date | [NAME] | Exit Date | Recert Date | Exit Date | Recert Date | Exit Date | Case Mgr | Referral Source | M/F | OIF/ OEF | Spouse | # M Dep | # F Dep | Total # Dep | Total # M | Total # F | Total Household | Spouse Disabled | Child >18 Disabled | <30% AMI | Chronically Homeless | Comments | Moving Costs | Rent/Fee | Security Deposit | Utility Deposit | Utility/Fee | Emergency Supplies | Transportation | Total
Smith, C. | 4950 | 2 | Y |  |  |  |  |  |  |  | [NAME] | VASH | M | N | Y | 0 | 0 |  |  |  |  |  |  | N |  | Not yet enrolled
Smith, E. | 6531 | 1 | N |  | 2012-04-16 00:00:00 |  |  |  |  |  | [NAME] | VA SC | M | N | N | 4 | 0 |  |  |  |  |  |  | Y
Smith, J. | 7300 | 2 | Y |  | 2012-01-03 00:00:00 | 2012-03-12 00:00:00 |  |  |  |  | [NAME] | VASH | M | N | N | 0 | 0 |  |  |  |  |  |  | Y
Smith, K. | 4742 | 3 | Y |  | 2012-05-02 00:00:00 |  |  |  |  |  | [NAME] | HUD | M | N | N | 0 | 0 |  |  |  |  |  |  | N |  | Pending Sec. 8 Inspection
Smith, R. | 5364 | 2 | Y |  | 2012-03-08 00:00:00 |  |  |  |  |  | [NAME] | VASH | M | Y | N | 0 | 0 |  |  |  |  |  |  | Y
Smith, R. | 6010 | 1 | N |  | 2012-04-19 00:00:00 |  |  |  |  |  | [NAME] | US Vets | M | N | N | 0 | 0 |  |  |  |  |  |  | Y |  | name spelled Balancier
Thornton, M. | 3475 | 2 | Y |  | 2011-09-27 00:00:00 | 2011-12-08 00:00:00 |  |  |  |  | [NAME] | VASH | M | N | N | 0 | 1 |  |  |  |  |  |  | Y
Walls, B. | 9306 | 3 | Y |  | 2011-11-14 00:00:00 | 2012-03-23 00:00:00 |  |  |  |  | [NAME] | VASH | M | N | N | 0 | 0 |  |  |  |  |  |  | Y
Walls, P. | 1516 | 1 | Y |  | 2012-04-02 00:00:00 | 2012-05-08 00:00:00 |  |  |  |  | [NAME] | VASH | M | N | Y | 0 | 0 |  |  |  |  |  |  | Y
Walls, S. | 3475 | 3 | N |  | 2012-04-20 00:00:00 | 2012-05-14 00:00:00 |  |  |  |  | [NAME] | Haven SV | M | N | Y | 0 | 0 |  |  |  |  |  |  | Y
 | Do not write below this line. Copy a row of an existing client and insert in Alphabetical order to maintain all formulas in database
Spreadsheet: 273494d1382726386-need-to-reference-3-columns-to-1-column-and-return-a-value-book1
Sheet: reporting Data

Campus ID | School Name | [NAME]
BAG-109 | [NAME]
BHC-103 | Block House Creek Elementary
BUSH-111 | [NAME]
COX-110 | Cox Elementary
CPHS-002 | Cedar Park High School
CPMS-041 | Cedar Park Middle School
CRMS-045 | Canyon Ridge Middle School
CYP-104 | Cypress Elementary
DRCK-113 | Deer Creek Elementary
FAU-102 | Faubion Elementary
FPMS-047 | Four Points Middle School
FSMS-048 | [NAME]
GID-106 | [NAME]
[NAME] | [NAME]
HMS-044 | Henry Middle School
KNOW-112 | [NAME]
LEO-199 | LEO
LHS-001 | Leander High School
LMS-042 | Leander Middle School
MAS-105 | Mason Elementary
NAU-108 | Naumann [NAME]
NHHS-011 | New Hope High School
PARK-120 | Parkside Elementary
PLH-114 | Pleasant Hill Elementary
PLN-116 | Plain Elementary
RBMS-043 | Running Brushy Middle School
RGN-122 | [NAME] Elementary
RHS-004 | Rouse High School
[NAME] | River Place Elementary
RRDG-123 | River Ridge Elementary
RUT-115 | Rutledge Elementary
STR-107 | Steiner Ranch Elementary
VHS-005 | Vandegrift High School
VRHS-003 | Vista Ridge High School
WEST-121 | Westside Elementary
WHIT-101 | Whitestone Elementary
WINK-117 | [NAME]
WMS-046 | Wiley Middle School
Spreadsheet: 158862d1338411558-results-summarizing-across-multiple-sheets-guest-comments-card
Sheet: Aquarius Summary

Aquarius Lunch | Very Satisfied | Satisfied | Dissatisfied | Does not Apply |  | Aquarius Lunch | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling |  |  |  |  |  | Table reservation handling | 2
Table service |  |  |  |  |  | Table service |  | 2
Variety of food and beverage menu |  |  |  |  |  | Variety of food and beverage menu |  | 1 | 1
Server's knowledge of menu selection |  |  |  |  |  | Server's knowledge of menu selection |  |  | 2
Quality and presentation of food |  |  |  |  |  | Quality and presentation of food | 1 | 1
Portion size of food |  |  |  |  |  | Portion size of food | 1 |  | 1
Quality and presentation of beverage |  |  |  |  |  | Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere |  |  |  |  |  | Restaurant atmosphere | 1 | 1
[NAME] handling |  |  |  |  |  | [NAME] handling |  |  | 2
Aquarius Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply |  | Aquarius Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling |  |  |  |  |  | Table reservation handling | 1 |  |  | 1
Table service |  |  |  |  |  | Table service |  | 1 | 1
Variety of food and beverage menu |  |  |  |  |  | Variety of food and beverage menu | 1 |  | 1
Server's knowledge of menu selection |  |  |  |  |  | Server's knowledge of menu selection |  | 2
Quality and presentation of food |  |  |  |  |  | Quality and presentation of food | 1 | 1
Portion size of food |  |  |  |  |  | Portion size of food | 1 |  | 1
Quality and presentation of beverage |  |  |  |  |  | Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere |  |  |  |  |  | Restaurant atmosphere |  | 1 | 1
[NAME] handling |  |  |  |  |  | [NAME] handling | 2
Spreadsheet: 798356d1664443119-create-summary-sheet-on-multiple-values-and-criteria-29092022-sample-file-for-excel-forum
Sheet: Branch 3

 | Opening | Dep | closing
furniture | 1500 | 300
Computer | 2000 | 200
furniture
Computer
Computer
furniture
Computer
Computer
furniture
furniture
furniture
Computer
Spreadsheet: 726491d1617272725-conditional-formatting-icon-color-change-or-a-work-around-test
Sheet: Sheet1

 | 2026-03-01 00:00:00 | 2027-03-01 00:00:00 | 2028-03-01 00:00:00 | 2029-03-01 00:00:00 | 1930-03-01 00:00:00 | 1931-03-01 00:00:00 | 2001-04-01 00:00:00 | Average
0-3 days | 2138 | 2195 | 1944 | 1836 | 1836 | 2357 | 2578
4-7 days | 1019 | 974 | 992 | 1117 | 1288 | 1323 | 1137
8-15 days | 700 | 682 | 697 | 737 | 857 | 833 | 866
16-21 days | 157 | 139 | 151 | 154 | 154 | 169 | 178
22-30 days | 82 | 76 | 85 | 88 | 99 | 97 | 86
1 months+ | 60 | 60 | 63 | 62 | 68 | 66 | 53
Grand total
Spreadsheet: 12f66b1e-f751-4667-8420-d42a5a0fa659
Sheet: Sheet1

Mortar Analysis Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Sample #
Sample Location
Name
Date
Sieve | With Sand | Without Sand | Sand | Particle sizes | % of total
4 | 0 | 0 | 0 | >4.75mm |  | gravel
8 | 0 | 0 | 0 | <4.75 mm |  | very coarse sand
16 | 0 | 0 | 0 | <2.36 mm |  | coarse sand
30 | 0 | 0 | 0 | <1.18 mm |  | medium coarse sand
50 | 0 | 0 | 0 | <.60 [NAME] |  | medium fine sand
100 | 0 | 0 | 0 | <.3 [NAME] |  | fine sand
200 | 0 | 0 | 0 | <.15 [NAME] |  | very fine sand
Pan | 0 | 0 | 0 | <.075 mm |  | silt
Total |  |  | 0
Weight of sample |  |  |  | % dissolved
Wt filter paper for fines |  |  |  | Wt filter paper for sand
Wt fines & paper |  |  |  | Wt sand & paper
Wt fines |  | 0 |  | Wt sand |  | 0
% fines |  |  |  | % sand
Spreadsheet: sally_beck__34345__bookentrytemplate
Sheet: Book Data Fields

Color = required field | Note that all fields have a fixed text size |  |  |  |  |  |  |  |  |  |  |  |  |  | AUS POWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD GAS
[NAME] 20 | Size 1 | Size 1 | Size 1 | [NAME] 15 | [NAME] 30, Dropdown | [NAME] 15 | Size 10 | [NAME] | Size 1 | [NAME] 15 | [NAME] 15 | Size 10 | [NAME] 128
BOOK ID | Portfolio Type Code | Book Code | Book Type Code | Region Code | Trading Location | Database ID | Administrator | Commodity Code | Book Purpose | Group ID | Benchmark ID | Portfolio Code | Book Comments |  | CAD POWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTINENTAL PWR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EURO STEEL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAPAN GLOBAL PRODUCTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PORTLAND GENERAL ELECTRIC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA GAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA POWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SING GLOBAL PROD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK COAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK EBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK GAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK GLOBAL PROD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK PAPER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK POWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNKNOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US BRIDGELINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US COAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US EBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US EES GAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US EES POWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US EMISSIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US FINANCIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US FREIGHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US GAS CENTRAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US GAS CLEBURNE
Spreadsheet: 726292d1617146868-automatically-shift-data-in-cells-according-to-date-change-sliding-dates-referencing-input-table-manishman-
Sheet: Sheet3

 |  |  |  | DAYS:
 |  |  |  | Agent 1
 |  |  |  | Agent 2
 |  |  |  | Sun-Sat
 |  |  |  | Mon-Sun
 |  |  |  | Tue-Mon
 |  |  |  | Wed-Tue
 |  |  |  | [NAME]
 |  |  |  | Fri-Thu
 |  |  |  | Sat-Fri
 |  |  |  | Sun-Sat
Spreadsheet: 295833d1391809974-sorting-data-in-excel-excel-example-with-some-responses-which-are-correct-being-blank-1-
Sheet: Sheet1

participant | when t2 | t2 correct |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
607 | 1 | 1 |  | participant | t2_correct_lag_1 | t2_correct_lag_2 | t2_correct_lag_3 | [NAME] | t2_correct_lag_5 | t2_correct_lag_6 | t2_correct_lag_7 | t2_correct_lag_8 |  | 607 | 1 | 0 | 209 | 1 | 0
607 | 2 | 1 |  | 607-0 |  |  |  |  |  |  |  |  |  | 607 | 3 | 0 | 209 | 5 | 0
607 | 3 | 1 |  | 607-1 |  |  |  |  |  |  |  |  |  | 607 | 4 | 0 | 209 | 6 | 0
607 | 4 | 1 |  | 209-0 |  |  |  |  |  |  |  |  |  | 607 | 5 | 0 | 209 | 7 | 0
607 | 5 | 0 |  | 209-1 |  |  |  |  |  |  |  |  |  | 607 | 7 | 0 | 209 | 8 | 0
607 | 6 | 1 |  |  |  |  |  |  |  |  |  |  |  | 607 | 1 | 1 | 209 | 1 | 1
607 | 7 | 0 |  |  |  |  |  |  |  |  |  |  |  | 607 | 2 | 1 | 209 | 2 | 1
607 | 8 | 1 |  |  |  |  |  |  |  |  |  |  |  | 607 | 2 | 1 | 209 | 2 | 1
607 | 7 | 1 |  |  |  |  |  |  |  |  |  |  |  | 607 | 3 | 1 | 209 | 3 | 1
607 | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  | 607 | 4 | 1 | 209 | 3 | 1
607 | 5 | 1 |  |  |  |  |  |  |  |  |  |  |  | 607 | 5 | 1 | 209 | 4 | 1
607 | 8 | 1 |  |  |  |  |  |  |  |  |  |  |  | 607 | 6 | 1 | 209 | 4 | 1
607 | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  | 607 | 6 | 1 | 209 | 5 | 1
607 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  | 607 | 7 | 1 | 209 | 6 | 1
607 | 6 | 1 |  |  |  |  |  |  |  |  |  |  |  | 607 | 8 | 1 | 209 | 7 | 1
607 | 3 | 0 |  |  |  |  |  |  |  |  |  |  |  | 607 | 8 | 1 | 209 | 8 | 1
209 | 1 | 1
209 | 2 | 1
209 | 3 | 1
209 | 4 | 1
209 | 5 | 0 | cells G5-I5 display blanks (with the exception of H5 which I have just tested by changing the response to a 0 in C32) are displaying blanks despite the fact that they should be showing 1's.
209 | 6 | 0
209 | 7 | 0
209 | 8 | 1
209 | 7 | 1
209 | 4 | 1
209 | 5 | 1
209 | 8 | 0
209 | 2 | 1
209 | 1 | 0
209 | 3 | 1
209 | 6 | 1
Spreadsheet: 680356d1590977989-using-isnumber-for-ifs-function-over-a-range-im_not_ben_wyatt-apartment-items-expenses
Sheet: Sheet1

 |  | Apartment Items - Expenses
 |  | Item |  | Location | Control | Price |  | A's Expenses
 |  | Door Draft Stopper |  | Living | Both | 9.99
 |  | Room Divider |  | Bed | A | 47.99 |  | D's Expenses
 |  | [NAME] |  | Bed | A | 30.95
 |  | Coat Hanger |  | Living | Both | 19.97 |  | Total Expenses
 |  | Coffee Maker |  | Kitchen | A | 24.99
 |  | TV LED Strip |  | Living | Both | 13.99
 |  | Coasters |  | Living | Both | 16.99
 |  | Canvas Art |  | Living | Both | 29.9
 |  | Pillow Cover |  | Bed | A | 13.99
 |  | [NAME] |  | Bath | A | 20.99
Spreadsheet: 471545d1469074160-add-new-row-in-another-excel-sheet-add-new-row-in-another-excel-sheet
Sheet: 06 Electronic

06 Electronic
Asset |  |  |  | Quantity | Date | Price per Unit | Total Price in Purchased Date | Depreciation Percentage | Depreciation Expense | Total Price
Asset | Brand | Gen. | Code
Spreadsheet: 828900d1683789475-formula-to-read-multiple-points-rounds-formulae
Sheet: Rounds (2)

 | Player | X totals | Round 1 | Round 2 | Round 4
 |  |  |  |  |  |  | Original data input in this Sheet
 | Player 01 |  | 1 | 1
 | Player 02 |  | 1 | 1
 | Player 03 |  |  | 1 | 1
 | Player 04 |  | 1 |  |  |  | Working on matrix to calculate points for rounds of playing cards.
 | Player 05 |  | 1 | 2
 | Player 06 |  | 1 |  |  |  | If a player scores 1 point, then calculation in Rounds (2) tab is correct in Column C and cells at the  same time  converted to Yes in separate Results Tab/
 | Player 07 |  | 2 | 1 | 1
 | Player 08 |  | 1 |  |  |  | If a player scores more than 1 point in the Rounds (2) tab, then calculation presents OK in the Rounds (2) tab Column C, but not correct in the Results tab Column C.
 | Player 09 |  | 1 | 1
 | Player 10 |  | 1 | 2 | 2 |  | Would appreciate the correct formulae please.
 | Totals
Spreadsheet: 290628d1389921920-how-to-find-out-the-desired-values-from-a-table-test-pattern17114
Sheet: test pattern

 |  |  | 603 | 1212 |  |  |  |  | 1712 | 608 |  | 1612
 |  |  | 652 |  |  | 1236 | 605 |  |  | 656
 |  |  | 602 |  |  |  | 654 |  |  | 607 |  | 1245 | 658
 |  |  | 651 | 1287 |  |  | 604 |  | 1512 | 655 |  |  | 609
 |  |  | 601 |  |  | 1210 | 653 |  |  | 606 |  | 1412 | 657
 |  |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2
 |  |  | ROW-1 |  |  | ROW-2 |  |  | ROW-3 |  |  | ROW-4
Spreadsheet: 677730d1589487743-preventing-excel-from-splitting-groups-of-words-with-parathenses-around-them-spoondatasample
Sheet: Sheet2

What I'm getting: |  |  |  |  |  |  |  |  | Desired:
(Wooden | Spoon | Data) | 1.2 | 4.5 | 11 | Ackron | WA |  | (Wooden Spoon Data) | 1.2 | 4.5 | 11 | Ackron | WA
(Metal | Spoon | Data) | 2.3 | 4.4 | - | - | - |  | (Metal Spoon Data) | 2.3 | 4.4 | - | - | -
(Plastic | Spoon | Data) | 1.1 | 2.2 | 4.9 | - | - |  | (Plastic Spoon Data) | 1.1 | 2.2 | 4.9 | - | -
Spreadsheet: 205965d1357955938-determine-wages-based-on-working-hours-pay-tap-example-copy-2
Sheet: Sheet1

 | PAY TAP
 | Name: [NAME] |  |  | Total Wages | 375
 | Position: Commentator / Rate: $175.00/8hrs / $200.00 over 8hrs
 | Address:
 | [NAME]:
 | Date | Time in | Time out | Hrs. | Wages
 | 2013-02-09 00:00:00 | 06:00:00 | 16:00:00 | 10:00:00 | 175 |  | Should Return $200 because is over 8:00hrs
 | 2013-02-10 00:00:00 | 06:00:00 | 16:00:00 | 10 | 200 |  | Here give me the right result when I type 10
 | 2013-02-11 00:00:00
 | 2013-02-12 00:00:00
 | 2013-02-13 00:00:00
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Case Closure

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Closure
Activity Name | Case Closure
Activity Description / Purpose | Due to a change causing the client to become ineligible, the case record will be closed and end the client’s benefits.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Receive documentation/decision/report
Determine case needs to be closed
Determine eligibility for transitional benefits
Enter information into system
Send client notice of action
Update case folder
Route to "Close files"
Determine if referral is needed
Cancel closing
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 775882d1649360387-rolling-month-sum-trouble-shoot-book-1-for-testing
Sheet: Sheet1

Date |  | Occurence |  | Rolling month sum
2000-01-01 00:00:00 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
Spreadsheet: cara_semperger__1470__EPMI NOV
Sheet: LLH

Contract |  | MW |  |  | $$ | Start | End | Path
10642 | EPMI | 50 | LLH | Purch |  | 2001-10-01 00:00:00 | 2006-09-30 00:00:00 | epmi bpa epmi(10123) | bo
22576 | EPMI | 36 | LLH | Purch | 29.15 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | epmi bpa epmi(10123) | bo
22576 | EPMI | 14 | LLH | Purch | 29.15 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00
24461 | EPMI | 25 | LLH | Purch | 21.4 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | epmi bpa epmi(23420) | bo
42022 | EPMI | 16 | LLH | Purch | 47.5 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | epmi bpa epmi(10123) | bo
x | x | x | x | x | x | x | x | x
10123 | EPMI | 50 | LLH | Sale | 68 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | epmi(10642) bpa epmi | bo
10123 | EPMI | 16 | LLH |  | 68 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | epmi(42022) bpa epmi | bo
10123 | EPMI | 36 | LLH |  | 68 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | epmi(22576) bpa epmi | bo
23420 | EPMI | -25 | LLH | Sale | 26.45 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | epmi(24461) bpa epmi | bo
23610 | EPMI | -25 | LLH | Sale | 44.25 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00
23617 | EPMI | -50 | LLH | Sale | 44.9 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00
23622 | EPMI | -25 | LLH | Sale | 45 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00
23763 | EPMI | -25 | LLH | Sale | 69.5 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00
24449 | EPMI | -25 | LLH | Sale | 22.75 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24451 | EPMI | -25 | LLH | Sale | 22.5 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24486 | EPMI | -100 | LLH | Sale | 24 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24488 | EPMI | -25 | LLH | Sale | 24.75 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24489 | EPMI | -25 | LLH | Sale | 24.5 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
Spreadsheet: 818381d1676789676-automatically-copy-multiple-sheets-into-one-sheet-s666-pq-automatically-copy-multiple-sheets-into-one-sheet
Sheet: Team 1

Department | Sub Dept | Area Owner | Supervisor | Reportees | Month | Completion Date | Completion Status
Department 1 | Sub 1 | Area Owner 1 | Supervisor 1 | Reportee 1 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 1 | Reportee 2 | 2023-02-01 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 1 | Reportee 3 | 2023-02-01 00:00:00 | 2023-02-20 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 1 | Reportee 4 | 2023-02-01 00:00:00 | 2023-02-12 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 1 | Reportee 5 | 2023-02-01 00:00:00 | 2023-02-12 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 1 | Reportee 6 | 2023-02-01 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 2 | Reportee 7 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 2 | Reportee 8 | 2023-02-01 00:00:00 | 2023-02-11 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 2 | Reportee 9 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 2 | Reportee 10 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 2 | Reportee 11 | 2023-02-01 00:00:00 | 2023-02-05 00:00:00
Department 1 | Sub 1 | Area Owner 1 | Supervisor 2 | Reportee 12 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00