tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 674647d1587976503-dynamic-array-cumulative-sum-cumulative-sum-using-dynamic-arrays-problem
Sheet: Setup

Setup
 |  | Description | Units | Range Name | Value | Notes
 | General [NAME]
 |  | File header | Text | sFileHeader | Subscriptions Model
 |  | Number of periods in model | Months | sModelTerm | 6
 |  | Model start date | dd/mm/yyyy | sStartDate | 2020-03-31 00:00:00
 |  | Annual price change | % | sPriceChange | 0
 |  | Member retention rate | % | sRetRate | 0.82
 |  | Member acquisition rate | % | SAquRate | 0.01 | Not in use
 |  | New members aquired per month | Members | sMemAquired | 39 | Equivalent to 31 (66  x 47%) after rounding
 | Membership Product
 | tblMemProd
 | Membership Product | Price inc GST | Price exc GST | Manual Annual price change % | Annual price change % | Manual Retention Rate | [NAME] | Acquisition of New Member [NAME]
 | Category A | 0 |  |  |  |  |  | 0
 | Category B | 0 |  |  |  |  |  | 0.0001744591765526867
 | Category C | 0 |  |  |  |  |  | 0.008025122121423587
 | Category D | 750 |  |  |  |  |  | 0.01953942777390091
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Gas - Fund

 | Natural Gas Fundamentals
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 7
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 4
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 2
 |  |  |  |  |  |  |  | Director | 143000 | 1
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 730815d1619965928-help-with-building-a-revenue-cost-spreadheet-fdg-test-file
Sheet: Financial Summary

Fortnight Date | Payroll
2021-07-01 00:00:00
2021-07-15 00:00:00
2021-07-29 00:00:00
2021-08-12 00:00:00
2021-08-26 00:00:00
2021-09-09 00:00:00
2021-09-22 00:00:00
2021-10-06 00:00:00
2021-10-20 00:00:00
2021-11-03 00:00:00
2021-11-17 00:00:00
2021-12-01 00:00:00
2021-12-15 00:00:00
2021-12-29 00:00:00
2022-01-12 00:00:00
2022-01-26 00:00:00
2022-02-09 00:00:00
2022-02-23 00:00:00
2022-03-09 00:00:00
2022-03-23 00:00:00
2022-04-06 00:00:00
2022-04-20 00:00:00
2022-05-04 00:00:00
2022-05-18 00:00:00
2022-06-01 00:00:00
2022-06-15 00:00:00
2022-06-29 00:00:00
2022-07-13 00:00:00
2022-07-27 00:00:00
2022-08-10 00:00:00
2022-08-24 00:00:00
2022-09-07 00:00:00
2022-09-21 00:00:00
2022-10-05 00:00:00
2022-10-19 00:00:00
2022-11-02 00:00:00
2022-11-16 00:00:00
2022-11-30 00:00:00
2022-12-14 00:00:00
Spreadsheet: 03ce9ba4-081f-4409-a18a-e51e68e5996b
Sheet: Form

 | Division of School Finance |  | SCHOOL TAX ABATEMENT |  |  |  | ED-02124-21
 | 1500 Highway 36 West |  | SIX-MONTH SUPPLEMENTAL REPORT |  |  |  | n/a
 | Roseville, MN  55113-4266 |  | n/a | n/a | n/a | n/a | DUE:  07/15/2014
GENERAL INFORMATION AND INSTRUCTIONS: Please read the INSTRUCTIONS FOR COMPLETION on the Instructions tab before completing this report. |  |  |  |  |  | THIS REPORT APPLIES TO: January 1, 2014 - June 30, 2014
NOTE OR COMMENTS BY PREPARER:
I D E N T I F I C A T I O N   A N D   G E N E R A L   I N F O R M A T I O N
District Number and Name: |  | County Name: | County Auditor's Office Contact Person: |  | Telephone Number: |  | Date:
P A R T   A :   N E T   T A X   C A P A C I T Y
 |  | (1) | (2) | (3) | (4) | (5) | (6)
COUNTY | COUNTY | NET TAX CAPACITY ABATED | SCHOOL TAXES ABATED | NET TAX CAPACITY ADDED | SCHOOL TAXES ADDED | NET CHANGE IN NET TAX CAPACITY | NET CHANGES IN SCHOOL TAXES
NAME | NUMBER | (Dollars Only) | (Dollars and Cents) | (Dollars Only) | (Dollars and Cents) | (Columns 1 plus 3) | (Columns 2 plus 4)
 |  | Enter Negative Amount | Enter Negative Amount
P A R T   B :   R E F E R E N D U M   M A R K E T   V A L U E
n/a | n/a | (1) | (2) | (3) | (4) | (5) | (6)
COUNTY | COUNTY | REF MKT VALUE ABATED | SCHOOL TAXES ABATED | REF MKT VALUE ADDED | SCHOOL TAXES ADDED | NET CHANGE IN REF MKT VALUE | NET CHANGES IN SCHOOL TAXES
NAME | NUMBER | (Dollars Only) | (Dollars and Cents) | (Dollars Only) | (Dollars and Cents) | (Columns 1 plus 3) | (Columns 2 plus 4)
n/a | n/a | Enter Negative Amount | Enter Negative Amount | n/a | n/a | n/a | n/a
TOTAL ALL COUNTIES (Part A and B) |  |  |  | n/a |  | n/a
End of worksheet
Spreadsheet: 61130d1261842010-pivot-table-calculation-in-excel-2007-book1-2-
Sheet: Sheet1

 |  |  | Agent ID | Agent Name | E-form Type | E-form Reference
 |  |  | 2134 | Ex1 | fr | 345
 |  |  | 2135 | Ex2 | fr | 346
 |  |  | 2136 | Ex3 | fr | 347
 |  |  | 2137 | Ex4 | fr | 348
 |  |  | 2138 | Ex5 | fr | 349
 |  |  | 2139 | Ex6 | fr | 350
 |  |  | 2140 | Ex7 | fr | 351
 |  |  | 2141 | Ex8 | fr | 352
 |  |  | 2142 | Ex9 | fr | 353
Spreadsheet: 86037d1286005804-using-a-date-format-in-a-cell-instead-of-a-text-format-to-support-a-formula-cash-deposits-and-orders-sample-3-
Sheet: 09-01-10

CASH ORDER
Denomination |  | 2010-09-01 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 3240500 |  | 1817700
20 |  | 2170860 |  | 712020
10 |  | 122360 | 22880 | 0
5 |  | 472800 |  | 414400
1 |  | 152703 |  | 48503
0.25 |  | 18559 | 11458 | 0 |  |  | 5000
0.05 |  | 7163 | 1442 | 0 |  |  | 1000
0.01 |  | 934 | 437 | 0
Total
Spreadsheet: joe_parks__14622__POSTIONTRAX_NOV
Sheet: PERM_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 13.5 | 2.08 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  | 7.5 | 1.6 |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: af268578-d7fe-4ccd-864b-839a0b87ead4
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TRIGC | Test | TRIGC | Triglycerides, CDC, S | Triglycerides, CDC, S | Only orderable as part of profile ECRMP/84208 Novel Cardiovascular Risk Panel. |  |  |  | 1 | mL | Only orderable as part of ECRMP/84208 Novel Cardiovascular Risk Panel. | 0.25 mL |  |  |  |  |  |  |  |  |  |  |  | Rochester
TRIGC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TRIGC | Result | TRIGC | Triglycerides, CDC, S | Triglycerides, CDC, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2571-8 | Triglyceride:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 35000d1232475245-conditional-i-think-if-statment-maybe-more-do-ranka
Sheet: Gate info

Galaxy Gate Rewards
Alpha | # | Exp | Honour | Credits | Uri | Prometium | Terbium | Endurium | Prometid | Duranium | Promerium | Total Cargo
Streuners | 40 | 16000 | 80 | 16000 | 40 | 400 | 0 | 400 | 0 | 0 | 0 | 800
Lordakians | 40 | 32000 | 160 | 32000 | 80 | 800 | 800 | 800 | 0 | 0 | 0 | 2400
Mordons | 40 | 128000 | 640 | 256000 | 320 | 3200 | 3200 | 3200 | 320 | 320 | 40 | 10280
Saimons | 80 | 128000 | 640 | 128000 | 320 | 3200 | 3200 | 3200 | 160 | 160 | 0 | 9920
Devolarium | 20 | 128000 | 640 | 1024000 | 320 | 800 | 800 | 800 | 40 | 40 | 0 | 2480
Sks | 80 | 512000 | 2560 | 1024000 | 1280 | 8000 | 8000 | 8000 | 1280 | 1280 | 80 | 26640
Sibelons | 20 | 256000 | 1280 | 2048000 | 640 | 4000 | 4000 | 4000 | 4000 | 640 | 80 | 16720
Sibelonits | 80 | 256000 | 1280 | 1024000 | 960 | 8000 | 8000 | 8000 | 640 | 640 | 80 | 25360
Bks | 16 | 819200 | 4096 | 6553600 | 2048 | 4800 | 4800 | 4800 | 2048 | 2048 | 256 | 18752
Protegits | 30 | 192000 | 960 | 384000 | 480 | 3000 | 3000 | 3000 | 480 | 480 | 60 | 10020
Total | 446 | 2467200 | 12336 | 12489600 | 6488
 |  | Exp | Honour | Uri | Cargo |  | Prometid | Duranium | Promerium
Rewards | Alpha | 4000000 | 200000 | 20000 | 123372
 | Betta | 8000000 | 400000 | 40000 | 245144
 | Yamma | 12000000 | 600000 | 60000 | 360516
Total Reward | Alpha | 6467200 | 212336 | 26488
 | Beta | 12934400 | 424672 | 52976
 | Yamma | 19401600 | 637008 | 79464
Spreadsheet: 71382d1272043087-index-and-match-formulas-fantasy-nascar-help
Sheet: Racers

# | Driver |  | Weekly Points | Place
0 | [NAME] |  | 50 | 1
1 | [NAME] |  | 42 | 2 |  |  | 1 | 10 |  |  | 12
2 | [NAME] |  | 41 | 3 |  |  | 2 | 11
5 | [NAME] |  | 40 | 4 |  |  | 3 | 12 |  |  | 10
6 | [NAME] |  | 39 | 5 |  |  | 4 | 13
7 | [NAME] |  | 38 | 6 |  |  | 5 | 14
9 | Aric Almirola |  | 37 | 7 |  |  | 6 | 15
9 | [NAME] |  | 36 | 8 |  |  | 7 | 16
9 | [NAME] |  | 35 | 9 |  |  | 8 | 17
11 | [NAME] |  | 34 | 10 |  |  | 9 | 18
12 | [NAME] |  | 33 | 11 |  |  | 10 | 19
13 | [NAME] |  | 32 | 12
14 | [NAME] |  | 31 | 13
16 | [NAME] |  | 30 | 14
17 | [NAME] |  | 29 | 15
18 | [NAME] |  | 28 | 16
19 | [NAME] |  | 27 | 17
20 | [NAME] |  | 26 | 18
21 | [NAME] |  | 25 | 19
24 | [NAME] |  | 24 | 20
26 | [NAME] |  | 23 | 21
26 | [NAME] |  | 22 | 22
29 | [NAME] |  | 21 | 23
31 | [NAME] |  | 20 | 24
33 | [NAME] |  | 19 | 25
34 | [NAME] |  | 18 | 26
34 | [NAME] |  | 17 | 27
36 | [NAME] |  | 16 | 28
37 | [NAME] |  | 15 | 29
38 | [NAME] |  | 14 | 30
38 | [NAME] |  | 13 | 31
39 | [NAME] |  | 12 | 32
42 | [NAME] |  | 11 | 33
43 | AJ Allmendinger |  | 10 | 34
46 | [NAME] |  | 9 | 35
47 | [NAME] |  | 8 | 36
48 | [NAME] |  | 7 | 37
55 | [NAME] |  | 6 | 38
55 | [NAME] |  | 5 | 39
56 | [NAME] |  | 4 | 40
66 | [NAME] |  | 3 | 41
71 | [NAME] |  | 2 | 42
77 | [NAME] |  | 1 | 43
78 | [NAME]
82 | [NAME]
82 | [NAME]
83 | [NAME]
87 | [NAME]
88 | [NAME]
98 | [NAME]
99 | [NAME]
102 | [NAME]
127 | [NAME]
127 | [NAME]
132 | [NAME]
157 | Norm Benning
175 | Derrike Cope
190 | [NAME]
190 | [NAME]
192 | [NAME]
197 | [NAME]
Spreadsheet: f32e1081-2897-4599-ae20-1bb99d4de774
Sheet: Sheet1

 |  |  |  | 2011 Haltom JV Basketball Tournament
 |  |  |  |  | NorthSide
 |  |  |  |  | [NAME]
 |  |  |  | Azle | Game 9
 |  |  |  |  | Game 9
 |  |  |  | Thu 3:30 Gym 1
 |  |  |  | Game 1
 |  |  | Fri 3:30 | Saginaw |  | Fri 3:30
 |  |  | Gym 2 |  |  | Gym 1
 |  |  | Game 16 | Central |  | Game 15
 |  |  |  | Thu 3:30 Gym 2
 |  |  |  | Game 2 |  |  | Sat 12:00
 |  | Sat 12:00 |  | W Hills | Haltom |  | Gym 1 |  | Loser 15
 |  | Gym 2 |  |  | [NAME] |  | Game 27 |  | Sat 9:00
 |  | Gym 1
 |  | Game 28 |  | [NAME] | Game 10 |  |  |  | Gym 1
 |  |  |  | [NAME] |  |  |  |  | Game 23
 |  |  |  | Game 3 |  |  |  |  | Loser 17
 |  |  | Fri 5:00 | [NAME] |  | Fri 5:00
 |  |  | Gym 2 |  |  | Gym 1
 |  |  | Game 18 | Arl. Heights |  | Game 17
 |  |  |  | [NAME]
 |  |  |  | Game 4
 | Consolation |  |  | Richland | South Hills |  | Third Place |  | Championship
 | Sat 4:30 |  |  |  | [NAME] |  | Sat 4:30 |  | Sat 6:00
 | Gym 2 |  |  | Carroll | Game 11 |  | Gym 1 |  | Gym 1
 | Game 34 |  |  | Thu 6:30 Gym 1 |  |  | Game 33 |  | Game 35
 |  |  |  | Game 5
 |  |  | Fri 12:30 | LD Bell |  | Fri 6:30
 |  |  | Gym 2 |  |  | Gym 1
 |  |  | Game 12 | Grapevine |  | Game 19 |  |  | Loser 19
 |  |  |  | Thu 6:30 Gym 2 |  |  |  |  | Sat 10:30
 |  |  |  | Game 6 |  |  | Sat. 1:30 |  | Gym 1
 |  | Sat 1:30 |  | Summit | Richardson |  | Gym 1 |  | Game 25
 |  | Gym 2 |  |  | Fri 2:00 Gym 1 |  | Game 29 |  | Loser 21
 |  | Game 30 |  | Heritage | Game 13
 |  |  |  | Thu 8:00 Gym 1
 |  |  |  |  |  |  |  |  | Loser 21
 |  |  |  | Game 7
 |  |  | Fri 2:00 | [NAME] |  | Fri 8:00
 | Loser 16 |  | Gym 2 |  |  | Gym 1
 | Sat 9 Gym 1 |  | Game 14 | Birdville |  | Game 21 |  | Loser 9
 | Game 24 |  |  | Thu 8:00 Gym 2 |  |  |  | [NAME]
 | Loser 18 |  |  | Game 8 |  |  | Sat 3:00 | Game 20 | Sat 3:00
 |  |  |  | Centennial |  |  | Gym 2 | Loser 10 | Gym 1
 | Loser 12 |  |  |  |  |  | Game 32 | Loser 11 | Game 31
 | Sat 9 Gym 2 |  |  | Top Team Home |  |  |  | [NAME]
 | Game 26 |  |  | [NAME] |  |  |  | Game 22
 | Loser 14 |  |  | Bring [NAME] |  |  |  | Loser 13
Spreadsheet: 546146d1509894516-having-issue-with-drop-down-that-can-retreive-data-data-validation-punch-in-punch-out
Sheet: whats desired

drop down to choose date | 2017-10-23 00:00:00 |  | drop down to choose emplpyee | [NAME]
date | Name | Duration | Punch in | Punch out
Spreadsheet: 97040d1296240367-reference-within-another-worksheet-reference-team-stats-sheet
Sheet: FTR

 | FTR
 | Name |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week
 | First | Surname | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | A | Doe
 | B | Doe
 | C | Doe
 | D | Doe
 | E | Doe
 | F | Doe
 | G | Doe
 | H | Doe
 | I | Doe
 | J | Doe
 | K | Doe
 | L | Doe
 | M | Doe
 | N | Doe
 | O | Doe
 | P | Doe
 | Q | Doe
 | R | Doe
 | S | Doe
 | Target | 0.78
Spreadsheet: 48436d1247655869-multiple_lookup-multiple_lookup
Sheet: Report

 | [NAME] | Forecast
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast
Campaign |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROMI
EUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget
GSI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KPIs
BA
BI
WWP
BMO
EDU
[NAME]
Collab
Spreadsheet: 835233d1688432897-ongoing-sheet-when-data-changes-test-database-v1
Sheet: Main

Pumps
SAID | Pump No. | Available | Signed Out | Returned On | Patient Name | UR No. | Page | Location | Comments
 | 1 |  | 2023-06-25 00:00:00 | 2023-06-28 00:00:00 | sdfgsdfgsdfsd |  | 152
 | 2 |  | 2023-04-21 00:00:00 | 2023-06-28 00:00:00 | ytsrtysdfg |  | 154
 | 3 |  | 2023-06-28 00:00:00 | 2023-06-19 00:00:00 | sdhsdfhsdfh |  | 128
 | 4 |  | 2023-04-30 00:00:00 | 2023-04-20 00:00:00 | ghdgdgfh |  | 153
 | 5 |  | 2021-01-14 00:00:00 |  | cgjggkfgh
 | 6 |  |  | 2023-06-28 00:00:00 | ffghfhj
 | 7 |  | 2020-03-03 00:00:00 |  | dfhhfh
 | 8 |  |  | 2023-05-09 00:00:00 | dfhdfgh |  | 154
 | 9 |  |  |  | fghjfhjfh |  | 153
 | 10 |  | 2023-02-01 00:00:00 |  | fghfgh
 | 11 |  | 2018-06-18 00:00:00 |  | fghfgh |  | 152
 | 12 |  | 2023-06-21 00:00:00 | 2023-06-28 00:00:00 | cbcvnb
 | 13 |  | 2023-06-11 00:00:00 | 2023-06-28 00:00:00 | [NAME]
 | 14 |  | 2023-06-25 00:00:00 | 2023-06-22 00:00:00 | cvbncvbncvbn
 | 15 |  | 2019-10-23 00:00:00 |  |  |  | 153
 | 16 |  |  | 2023-06-28 00:00:00
 | 17 |  | 2023-06-23 00:00:00 | 2023-01-24 00:00:00 |  |  | 209
 | 18
Spreadsheet: albert_meyers__1__1-25act
Sheet: EPEData

 | 37377.89791666667
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 35  , 70  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,130  ,215  , 86  ,214  , 86  ,1
 | NEWMAN   ,, 202 ,  385,  155, 400 , 126 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,604  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 52  , 52  , 52  ,104  ,  0  ,1
 | LAMBDA, 19.79,  691,  690,  174,    1,    0, 9946,0
 | APS     ,FIRM    ,FC,  ,  25,  25
 | IID     ,FIRM    ,PV,  ,  84,  84
 | PGT     ,LOSS    ,LC,  ,  -1,  -2
 | PNM     ,LOSS    ,WM,  ,   3,   3
 | SPS     ,FIRM    ,ED,  ,-100,-100
 | SRP     ,FIRM    ,PV,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | CISO    ,FIRM    ,PV,  ,  78,   0
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
 | 37300.62986111111
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 39  , 75  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,174  ,215  , 86  ,214  , 41  ,1
 | NEWMAN   ,, 251 ,  390,  155, 400 ,  81 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 51  , 51  , 51  ,104  ,  0  ,1
 | LAMBDA, 23.51,  798,  796,   80,   -3,    0,11060,21
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Case Assignemnt

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Caseload Management
Activity Name | Case Assignment
Activity Description / Purpose | The process of assigning a case
 |  |  | 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
Assign Case
Spreadsheet: 220601d1363201375-need-formula-to-figure-out-federal-tax-on-worksheet-john-h-7
Sheet: Payroll Register Sheet

Name | [NAME]. | [NAME] | No. of W/H Allow. | Regular Earnings |  |  | Overime Earnings |  |  | Total Earnings | Previous Y-T-D Earnings | New           Y-T-D Earnings | Deductions |  |  |  |  | Deductions |  |  |  | Net Paid |  | Employer Contributions |  |  |  | Labor Cost Distribution
 |  |  |  | Hrs. | Rate Per Hour | Amount | Hrs. | 1.5 Rate Per Hour | Amount |  |  |  | Account Numbers |  |  |  |  |  |  |  |  |  |  | Taxable Earnings
 |  |  |  |  |  |  |  |  |  |  |  |  | 20.1 | 20.2 | 24 | 25 | 25.1 | 26 | 27 | 28 | 29 |  |  | Limit | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106500 | Limit | Limit | Limit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group | Union | SIMPLE | Ck. | Net |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | OASDI | HI | FIT | SIT | SUTA | CIT | Ins. | Dues | IRA | No. | Pay | OASDI | HI | FUTA | SUTA | Admin. | Office | Sales | Plant
Spreadsheet: 67521d1268139785-extracting-records-2004-2005-samples
Sheet: Brand name

Code | Product | Rep 1 | Rep 2 | Rep 3
Product 1 Code | Product 1 | 1 | 1 | 1
Product 2 Code | Product 2 |  | 1
Product 3 Code | Product 3 | 1 |  | 1
Product 4 Code | Product 4 |  | 1 | 1
Spreadsheet: 722991d1615472468-advanced-sumifs-to-compile-data-from-multiple-tables-example
Sheet: Dataset

Sector A
Revenue |  | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | income | 1 | 1 | 1 | 1 | 1 | 1
Expenses |  | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | [NAME] | 2 | 2 | 2 | 2 | 2 | 2
 | expense2 | 3 | 3 | 3 | 3 | 3 | 3
 | expense3 | 4 | 4 | 4 | 4 | 4 | 4
Sector B
Revenue |  | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | income | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2
Expenses |  | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | [NAME] | 2 | 2 | 2 | 2 | 2 | 2
 | expense2 | 3 | 3 | 3 | 3 | 3 | 3
 | expense3 | 4 | 4 | 4 | 4 | 4 | 4
Sector C
Revenue |  | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | income | 3 | 3 | 3 | 3 | 3 | 3
 | income2 | 4 | 4 | 4 | 4 | 4 | 4
Expenses |  | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | [NAME] | 2 | 2 | 2 | 2 | 2 | 2
 | expense2 | 3 | 3 | 3 | 3 | 3 | 3
 | expense3 | 4 | 4 | 4 | 4 | 4 | 4
Spreadsheet: 801144d1666100647-add-word-or-between-the-two-words-adding-word-or-between-the-two-words-ans
Sheet: Sheet1

1 | T9626263 | OR
2 | P2437263
3 | P7499729 |  | T9626263 OR P2437263 OR P7499729 OR T0227709 OR Z3090777 OR S4962293 OR P4392209 OR T7026263 OR [NAME] OR S6022997 OR S6622409 OR Z9067042 OR [NAME] OR P0243624 OR S6707226 OR P7329060 OR T9326999 OR Z9393470 OR P0766034 OR P9493666
4 | T0227709 |  | Answer in D1
5 | Z3090777
6 | S4962293
7 | P4392209
8 | T7026263
9 | [NAME]
10 | S6022997
11 | S6622409
12 | Z9067042
13 | Z2623706
14 | P0243624
15 | S6707226
16 | P7329060
17 | T9326999
18 | Z9393470
19 | P0766034
20 | P9493666
Spreadsheet: 48654d1247865500-managing-contacts-checkins
Sheet: Page 1

Current guests
Room number | PAX | Name of guest |  | [NAME] | Departure
1000 | 1 | A |  | 2009-07-10 00:00:00 | 2009-07-11 00:00:00
1001 | 4 | B |  | 2009-07-10 00:00:00 | 2009-07-22 00:00:00
1002 | 2 | C |  | 2009-07-12 00:00:00 | 2009-07-13 00:00:00
1003 | 5 | D |  | 2009-07-13 00:00:00 | 2009-07-24 00:00:00
1004 | 4 | E |  | 2009-07-14 00:00:00 | 2009-07-15 00:00:00
1005 | 3 | F |  | 2009-07-15 00:00:00 | 2009-07-16 00:00:00
1006 | 2 | G |  | 2009-07-16 00:00:00 | 2009-07-22 00:00:00
1007 | 5 | H |  | 2009-07-17 00:00:00 | 2009-07-18 00:00:00
1008 | 4 | I |  | 2009-07-18 00:00:00 | 2009-07-19 00:00:00
1009 | 2 | J |  | 2009-07-19 00:00:00 | 2009-07-20 00:00:00
1010 | 3 | K |  | 2009-07-20 00:00:00 | 2009-07-21 00:00:00
1011 | 4 | L |  | 2009-07-21 00:00:00 | 2009-07-22 00:00:00