tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14043__COS & Rates Workpapers for GA II 12-20-2000 Proposal
Sheet: CAPex Summary

Gas Accord II Capital Spending Projections
 | 2000 - 2007 |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007
BASE CAPEX |  |  | 64.54929999999999 | 72.988786843 | 72.73388806199999 | 96.14076947400001 | 182.46488842 | 217.144861753 | 93.833310391 | 62.85627783999999
Backbone Transmission | 212.480197672 |  | 15.229 | 15.922861885 | 25.276582975 | 16.74674629700001 | 47.12864968800001 | 75.17750397 | 9.369572195 | 7.629280661999999
NOx-300 (Environmental) | 86.755 |  | 15.8475 | 26.835 | 5.05 | 0 | 0 | 19.2093 | 19.8132 | 0
NOx-400/401 (Environmental) | 67.8534 |  | 0 | 0.075 | 3.2043 | 31.9552 | 32.6189 | 0 | 0 | 0
Gas Gathering | 13.231299868 |  | 2.2209 | 2.312389407 | 2.015367686 | 1.509287881 | 1.24539094 | 1.237187321 | 1.327560986 | 1.363215647
Local Transmission | 292.566826776 |  | 24.6335 | 20.174755714 | 26.277812098 | 35.260976373 | 34.04676195 | 51.76687919 | 54.861043984 | 45.545097467
Storage | 189.825358467 |  | 6.6184 | 7.668779837 | 10.909825303 | 10.668558923 | 67.425185842 | 69.753991272 | 8.461933226 | 8.318684064
Total Base Capital Expenditures | 596.7239518524526 |  | 64.5493 | 72.988786843 | 72.46688806200001 | 96.14076947400001 | 64.75975748945262 | 106.371261753 | 75.693110391 | 43.75407784
Additional Projects for Enhanced Reliability
Line 401 Capacity (Loops) | 30.4095063324794 |  |  |  |  | 30.4095063324794
Line 400/401 Pipeline Expansion | 0 |  |  |  |  |  |  | 0
Central Backbone Expansion | 64.62 |  |  |  |  |  | 31.48 | 33.14
LT Reliability Improvement | 78.16492509415681 |  |  |  |  |  | 5.663106186109471 | 23.05384339227602 | 24.14442092342546 | 25.30355459234587
Line 57C | 45.67293055229216 |  |  |  | 0.267 | 45.40593055229216
Storage Expansion (Incremental) (1) | 0 |  |  |  |  |  | 0 | 0
Total Capital Spending by Year | 701.2595472219285 |  | 64.5493 | 72.988786843 | 72.733888062 | 171.9562063587716 | 101.9028636755621 | 162.565105145276 | 99.83753131442546 | 69.05763243234587
Footnotes:
(1) Excludes $72.4 million for the McDonald Island storage expansion project in 2004/2005.
This project is being treated as an incremental capital investment in the GA II rate design.
(2) EXCLUDES Common and General plant and M&S Scalar of 4.1% on new capital additions.
Spreadsheet: 224197d1364483439-sorting-project-task-list-with-merged-cells-sample-excelforums-2
Sheet: Sheet1

Stage | Program Components | Sub Task | Assigned Resource | Dates | Status | Communication Manager(M)/ Participant (P) | Location (Delivery Method) | Comments
Stage 1 | Task #1 | Subtask #1 | [NAME], [NAME] | 2013-02-19 00:00:00 | Complete
Stage 1 | Task #1 | Subtask #2 | [NAME], [NAME] | 2013-02-20 00:00:00 | Complete
Stage 1 | Task #1 | Subtask #3 | [NAME], [NAME] | 2013-02-21 00:00:00 | Complete
Stage 1 | Task #1 | Subtask #4 | [NAME], [NAME] | 2013-02-22 00:00:00 | Complete
Stage 1 | Task #2 | Subtask #1 | [NAME], [NAME] | 2013-02-19 00:00:00 | Complete
Stage 1 | Task #2 | Subtask #2 | [NAME], [NAME] | 2013-02-20 00:00:00 | Complete
Stage 1 | Task #2 | Subtask #3 | [NAME], [NAME] | 2013-02-21 00:00:00 | Complete
Stage 1 | Task #3 | Subtask #1 | [NAME] | 2013-02-19 00:00:00 | Complete
Stage 1 | Task #4 | Subtask #1 | [NAME] | 2013-02-19 00:00:00 | Complete
 |  |  |  |  |  |  | Delivered to Home
 |  |  |  |  |  |  | Delivered to Home
 |  |  |  |  |  |  | Mailed to home
 |  |  |  |  |  |  | Delivered to Home
Spreadsheet: david_delainey__8062__Sweetwater_129 MW_13June00_Breakeven
Sheet: Draw

 |  |  | 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
 |  | Drawdown Schedule
 |  | Drawdown  - Project Completion Inputs
 |  | Months from project initiation >>>>>>> |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | Total
 |  | No. of Completed Trubines |  |  |  | 10 | 10 | 10 | 10 | 0 | 0
 |  | No. Of Turbines Coming Online |  |  |  |  | 10 | 10 | 10 | 10 | 0 | 0 | 0 | 0
 |  | Turbine Rated Capacity
 |  | Wind Adjustment Factor
 |  | Project Completion %
 |  |  |  | 0 | 0.05 | 0.1 | 0.1 | 0.2 | 0.2 | 0.2 | 0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0.2 | 0.2 | 0.2 | 0.3 | 0.1
 |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2
 |  |  |  |  |  | 0.2 | 0.2 | 0.4 | 0.2
 |  |  |  | 0 | 0.4 | 0.4 | 0.2 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0.5
 |  |  |  | 0 | 0.4 | 0.4 | 0.2 | 0 | 0
 |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0
 |  |  |  | 0.33 | 0.33 | 0.34 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0.25 | 0.25 | 0.25 | 0.25
 |  |  |  | 0 | 0 |  |  | 0 | 0.33 | 0.33 | 0.34
 |  |  |  | 0 | 0 | 0 | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0.2 | 0.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0 | 1
 |  |  |  | 0 |  |  |  |  |  |  | 1
 |  |  |  | 1 | 0 | 0 | 0 |  |  | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  | 0
 |  |  |  | 1 |  |  |  |  |  | 0
 |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0 |  |  |  |  | 0.5 |  |  |  | 0.5
 |  |  |  |  |  |  |  |  | 0.5 | 0.5
 |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25
 |  |  |  |  |  |  | 0.5 |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
 |  | Drawdown Schedule
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be Zero
 |  | Months >>> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | Total
 |  | Uses of Funds
 |  | TOTAL
 |  | Sources of Funds
 |  | ECM Construction Loan  - Monthly
 |  | - Cumulative
 |  | Revenue During Construction
 |  | No. of Turbines Online /month
 |  | Total Turbines Online
 |  | Turbine Rated Capacity
 |  | Monthly Energy Generated (kWh -/ month pro rata)
 |  | Rate ($)
 |  | Gross Monthly Revenue ($000)
 |  | Operating Expenses
 |  | Maintenance
 |  | Land Payments
 |  | Insurance
 |  | Total Operating Expenses
 |  | Net Revenue after Expenses
 |  | Net Funds Req'd During Constrn.
 |  | Cumulative
Spreadsheet: louise_kitchen__24066__NETCO4122pm
Sheet: Accounting

Accounting
1 | [NAME], [NAME]
2 | Day, Misti
3 | Hardy, [NAME]
4 | Hardy, Stacy
5 | Hodges, [NAME]
6 | [NAME], [NAME]
7 | [NAME], [NAME]
8 | [NAME], [NAME]
9 | [NAME], [NAME]
10 | [NAME], [NAME]
11 | [NAME], [NAME]
12 | Vargas, [NAME] (Hope)
13 | Warwick, Todd
14 | Whiting, Gregory
15 | Wolfe, Stephen
16 | [NAME], [NAME]
17 | Eastwood, Anne
18 | Green, [NAME]
19 | Gruesen, [NAME]
20 | Guilliams, [NAME]
21 | Harris, Kimberly
22 | [NAME], [NAME]
23 | Hernandez, Anamaria
24 | Kacal, [NAME]
25 | [NAME], [NAME]
26 | Mayeux, [NAME]
27 | [NAME], Shannon
28 | Schultz, Amanda
29 | Simper, [NAME]
30 | Smith, [NAME]
31 | [NAME], [NAME]
32 | Ellis, [NAME]
33 | Fellers, [NAME]
34 | Guerra, Ricardo
35 | Hospeti, Savithri
36 | Ingram, [NAME]
37 | [NAME], [NAME]
38 | Leschber, [NAME]
39 | Lewchuk, [NAME]
40 | [NAME], [NAME]
41 | [NAME], [NAME]
42 | Moore, [NAME]
43 | [NAME], [NAME]
44 | Price, [NAME] ([NAME])
45 | Tijerina, [NAME]
46 | [NAME], Angeles
Spreadsheet: 97127d1296343343-how-to-remove-a-space-in-the-front-book2
Sheet: Sheet1

CRQ 10-1045 3Si Risk Strategies 2010 09 17.pdf
DCT Bear Creek Security Purchase Order 2.pdf
DCT Bear Creek Security Purchase Order.docx
DCT City Hall Security Lower Main Floor B1.docx
DCT Guildford Security Upgrade Cabling Purchase Requisition.docx
DCT Guildford Security Upgrade PR Increase.pdf
DCT Guildford Security Upgrade Purchase Order.pdf
DCT Guildford Security Upgrade Purchase Requisition.docx
DCT Guildford Security Upgrade Quote.pdf
02-10 Addendum No 2 - completed.doc
DCT Guildford Contractor Pre-Qualification A and [NAME]
DCT Guildford Contractor Pre-Qualification Bank of Nova Scotia SC1.doc
DCT Guildford Contractor Pre-Qualification Bird Construction 1.xls
DCT Guildford Contractor Pre-Qualification Bird Construction.xls
DCT Guildford Contractor Pre-Qualification Contractor 1.xls
DCT Guildford Contractor Pre-Qualification Country West Construction 1.xls
DCT Guildford Contractor Pre-Qualification D and T1 2000 02 02.xls
DCT Guildford Contractor Pre-Qualification DGS 1 2000 02 02.xls
DCT Guildford Contractor Pre-Qualification Danwood Transmittal Form 2.doc
DCT Guildford Contractor Pre-Qualification Darwin 1.xls
DCT Guildford Contractor Pre-Qualification Darwin 2.doc
DCT Guildford Contractor Pre-Qualification Darwin 3.xls
Spreadsheet: 879193d1726647859-ranking-and-sorting-sample-sales-data
Sheet: Sheet1

 | Customer Name | [NAME] | 2024 Sales | 2024 Target | 2023 Sales
 | Company ABC | TV Model 1 | 1234 | 1000 | 800
 | Company ABC | TV Model 2 | 2345 | 2000 | 900
 | Company ABC | TV Model 3 | 6789 | 3000 | 1000
 | Company ABC | TV Model 4 | 7890 |  | 1200
 | Company ABC | TV Model 5 | 8901 |  | 1300
 | Company ABC | TV Model 2 | 2345 | 2000 | 900
 | Company ABC | TV Model 1 | 1234 | 1000 | 800
 | Company ABC | TV Model 1 | 1234 | 1000 | 800
 | Company EFG | TV Model 1 |  | 1000 | 800
 | Company EFG | TV Model 2 | 2345 | 2000 | 900
 | Company EFG | TV Model 3 | 6789 | 3000 | 1000
 | Company EFG | TV Model 4 | 7890 |  | 1200
 | Company EFG | TV Model 5 | 8901 |  | 1300
 | Company EFG | TV Model 2 | 2345 | 2000 | 900
 | Company EFG | TV Model 1 |  | 1000 | 800
 | Company EFG | TV Model 1 |  | 1000 | 800
Spreadsheet: david_delainey__8062__Sweetwater_129 MW_13June00_Breakeven
Sheet: Srcs_Uses

 | Sources & Uses Statement
 | SOURCES OF FUNDS |  |  | $[NAME] (000) | % TOTAL | $ PER KW | PER WTG |  | Total Required Cash Equity
 | OUTSIDE EQUITY
 | EWC EQUITY
 | SENIOR BANK DEBT
 | JUNIOR DEBT
 | CASH SUB-TOTAL
 | BLANK
 | CASH & NON-CASH TOTAL
 | USES OF FUNDS
 | CONSTRUCTION INSURANCE
 | CONSTRUCTION INTEREST
 | TOTAL
Spreadsheet: 484215d1476176278-find-random-4-columns-of-scores-5-each-from-the-total-20-random-numbers-to-a-total-value
Sheet: Sheet1

No | Name | Clean | Taste | Time | Look | Total |  | Minimum Value | 0
 |  | 5 | 5 | 5 | 5 | 20 |  | Maximum value | 5
1 | Chloe |  |  |  |  | 14 |  | Number of scores | 4
2 | Emily |  |  |  |  | 9
3 | Aaliyah |  |  |  |  | 20
4 | Emma |  |  |  |  | 16
5 | [NAME] |  |  |  |  | 19
6 | Olivia |  |  |  |  | 15
7 | [NAME] |  |  |  |  | 14
8 | Grace |  |  |  |  | 19
9 | Charlotte |  |  |  |  | 15
10 | [NAME] |  |  |  |  | 14
11 | Lauren |  |  |  |  | 19
12 | [NAME] |  |  |  |  | 15
13 | Rebecca |  |  |  |  | 14
14 | Samantha |  |  |  |  | 19
15 | [NAME] |  |  |  |  | 15
16 | [NAME] |  |  |  |  | 14
17 | [NAME] |  |  |  |  | 19
18 | [NAME] |  |  |  |  | 15
19 | Amber |  |  |  |  | 14
20 | [NAME] |  |  |  |  | 19
Spreadsheet: 27833d1221520202-insert-paste-row-have-a-b-c-insert-row-as-well-with-their-data-excelforum
Sheet: Sheet1

Example 1 |  |  |  |  |  | Example 2
Subject | Grade | Teacher | Student Name |  |  | Subject | Grade | Teacher | Student Name
algebra | 7th | Mrs. [NAME] | Name1 |  |  | algebra | 7th | Mrs. [NAME] | Name1
 |  |  | [NAME] |  |  | algebra | 7th | Mrs. [NAME] | [NAME]
 |  |  | Name3 |  |  | algebra | 7th | Mrs. [NAME] | Name3
 |  |  | Name4 |  |  | algebra | 7th | Mrs. [NAME] | Name4
 |  |  | Name5 |  |  | algebra | 7th | Mrs. [NAME] | Name5
 |  |  | Name6 |  |  | algebra | 7th | Mrs. [NAME] | Name6
 |  |  | Name7 |  |  | algebra | 7th | Mrs. [NAME] | Name7
 |  |  | Name8 |  |  | algebra | 7th | Mrs. [NAME] | Name8
 |  |  | Name9 |  |  | algebra | 7th | Mrs. [NAME] | Name9
 |  |  | Name10 |  |  | algebra | 8th | Mrs. [NAME] | Name10
Let's say I have a clipboard of the data below: |  |  |  |  |  | How can I paste the clipboard data like Example 1 and also have Column A, B n C automatically
Name1 |  |  |  |  |  | insert data based on the row that's being pasted?
[NAME]
Name3
Name4 |  |  |  |  |  | I can select algebra, 7th and Mrs. [NAME] and drag it down to the
Name5 |  |  |  |  |  | last pasted clipboard but the data is very long so it would be
Name6 |  |  |  |  |  | tedious to add the entire county of students.
Name7
Name8 |  |  |  |  |  | This is why I need to find another solution that would make it
Name9 |  |  |  |  |  | easier to input data
Name10
I paste the clipboard on [NAME] and I get Example 1.
Spreadsheet: 88936d1288741127-excel-2007-excel-changes-numbers-decimals-to-fractions-7-30-jacketed-unfired
Sheet: Sheet1

Bullet | Pwdr | [NAME] | [NAME] | Sizd | OAL | Pg | Box | Row | #[NAME]
120hdy | 4198 | 20 | 9.5 | mix | 7 |  | grn | 1,4 | 20
120hdy | 2015 | 23 | 9.5 | flr | 7 | 5 | grn | 5,7 | 15
Spreadsheet: 714752d1611341663-assisted-needed-with-matching-multiple-fields-excel-match-help4-rawonly
Sheet: Sheet1

RAW - IP Address: | RAW - System Name:
2.10.9.3 | Computer 2i
2.10.9.2 | Computer 9i
2.10.9.1 | Computer 16d
2.10.10.0 | Computer 5i
2.10.10.1 | Computer 17e
2.10.10.2 | Computer 15i
2.10.10.3 | Computer 19d
2.10.10.4 | Computer 18e
2.10.10.5 | Computer 3i
2.10.10.7 | Computer 13i
2.10.10.8 | Computer 20a
2.10.10.9 | Computer 25d
2.10.10.6 | Computer 6i
2.10.10.11 | Computer 21a
2.10.10.12 | Computer 7i
2.10.10.13 | Computer 26d
2.10.10.14 | Computer 27d
1.10.11.6 | Computer 6
2.10.10.16 | Computer 4i
2.10.10.17 | Computer 22a
2.10.10.18 | Computer 28d
2.10.10.19 | Computer 29a
2.10.10.20 | Computer 23b
1.10.11.7 | Computer 7
2.10.10.15 | Computer 8i
2.10.10.23 | Computer 30a
2.10.10.24 | Computer 24c
2.10.10.25 | Computer 12i
1.10.11.1 | Computer 1
1.10.11.5 | Computer 5
1.10.11.8 | Computer 8
1.10.11.11 | Computer 11
1.10.11.12 | Computer 12
2.10.10.10 | Computer 1i
1.10.11.14 | Computer 14
1.10.11.15 | Computer 15
1.10.11.4 | Computer 4
1.10.11.9 | Computer 9
1.10.11.10 | Computer 10
1.10.11.2 | Computer 2
1.10.11.3 | Computer 3
2.10.10.26 | Computer 11i
1.10.11.13 | Computer 13
2.10.10.21 | Computer 14i
2.10.10.22 | Computer 10i
Spreadsheet: 73bfdc4e-28c0-46c5-ac9e-c4436746e76f
Sheet: Sheet1

Constitutional Measure No. 2  Relates to the elec... (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 6/20/2013 6:34:02 AM
Precincts Reporting: 693/693 - Total Ballots Cast: 94306
2000 Primary Election - OFFICIAL RESULTS
Precinct | Yes | No | TOTALS
Combined Precinct | 1669 | 907 | 2576
TOTAL | 1669 | 907 | 2576
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 773758d1648036785-duplicate-and-look-up-workbook
Sheet: Sheet2

source data - multi site projects  (sheet 2)
ID | Project | Site | Longditude | Latitude
P6 | Project 6 | Site A | 50.1 | -0.7695
P6 | Project 6 | Site C | 50.205 | -0.8463
P6 | Project 6 | Site D | 51.1023 | -0.5689
P10 | Project 10 | Site C | 50.205 | -0.8463
P10 | Project 10 | Site D | 51.1023 | -0.5689
Spreadsheet: 753149d1635267722-sum-of-variable-ranges-sum
Sheet: Foglio1

 |  |  |  | Output
 | Column1 | Column2 |  |  | Addition
 | A | YES |  |  | 172
 | B | NO
 | C | YES
 | D | NO
 | E | YES
 | DATI
 | Column1 | Column2
 | A | 10
 | B | 25
 | C | 30
 | D | 44
 | E | 88
 | E | 44
 | D | 12
 | B | 36
Spreadsheet: 741641d1627225375-need-help-with-inventory-of-raw-material-items-example-sheet-mod1
Sheet: Sheet1

Purchase Date | Raw Material | [NAME] | Quantity/kg | Cumulative/Kg | RM Qnty Used | RM Remain | Exceed
2021-04-10 00:00:00 | Sugar | S1208U | 200 |  | 180.5
2021-06-17 00:00:00 | Sugar | S1276U | 50 |  | 54
2021-07-02 00:00:00 | Sugar | S1291U | 50 |  | 49
2021-07-12 00:00:00 | Sugar | S1301U | 100 |  | 95
Spreadsheet: 220859d1363283243-lookup-problem-test-doc
Sheet: NAME AND CLASS INFO

Num | NAME | CLASS | [NAME] | Professor
1 | Doe, [NAME] | Psych 120 | [NAME] 210A | Psych Jones | Mon 8:00 a.m. ---> 8:45
2 | [NAME], [NAME] | Eng 212 | [NAME] 178B | English Smith | Mon 9:00 a.m. ---> 9:45
3 | Barnes, [NAME] | Psych 120 | [NAME] 210A | Psych Jones | Mon 8:00 a.m. ---> 8:45
4 | Jones, Mary | Sci 470 | Newton - Room 120 | [NAME] | Mon 8:00 a.m. ---> 8:45
5 | Jones, [NAME] | Hist 101 | [NAME] | His [NAME] | Mon 9:00 a.m. ---> 9:45
6 | Walters, [NAME] | Eng 212 | [NAME] 178B | English Smith | Mon 8:00 a.m. ---> 8:45
7 | Jones, [NAME] | Trig 230 | [NAME] | [NAME] | Tues 9:00 a.m. ---> 9:45
8 | Doe, [NAME] | Hist 101 | [NAME] | His [NAME] | Mon 9:00 a.m. ---> 9:45
9 | Ally, Rabecca | Alg 215 | [NAME] | [NAME] | [NAME] 8:00 a.m. ---> 8:45
10 | Jones, [NAME] | Eng 212 | [NAME] 178B | English Smith | Mon 9:00 a.m. ---> 9:45
11 | [NAME], Winston | Alg 215 | [NAME] | [NAME] | [NAME] 8:00 a.m. ---> 8:45
12 | Walters, [NAME] | Trig 230 | [NAME] | [NAME] | Tues 9:00 a.m. ---> 9:45
Spreadsheet: 179862d1347389559-formula-not-working-with-duplicate-information-12-13-student-test
Sheet: Student Worker Limits

Name | Hours | Days | Ability to  Work
Spreadsheet: 777931d1650678859-merging-list-information-from-multiple-sheets-that-may-have-added-rows-full-outer-merge-using-power-query-hacohen15-
Sheet: Q1

 |  |  |  | YTD |  | YTD |  |  |  |  | Name | Hire Date | [NAME] to 6/30/2022 | [NAME] to 3/31/2022 | [NAME]
 |  | Hire |  | Info to |  | Info to |  | Quarterly |  |  | Abbott, [NAME] | 1995-12-02 00:00:00 | 1500
NAME |  | Date |  | 2022-03-31 00:00:00 |  | 2022-03-31 00:00:00 |  | Wages |  |  | [NAME], [NAME] | 2020-08-10 00:00:00 | 2000
(these are made up names and info) |  |  |  |  |  |  |  |  |  |  | Cabott, Fred | 2007-08-01 00:00:00 | 4000
 |  |  |  |  |  |  |  |  |  |  | Dabott, [NAME] | 2002-05-15 00:00:00 | 8000
Abbott, [NAME] |  | 1995-12-02 00:00:00 |  | 1500
[NAME], [NAME] |  | 2020-08-10 00:00:00 |  | 2000
Cabott, Fred |  | 2007-08-01 00:00:00 |  | 4000
Dabott, [NAME] |  | 2002-05-15 00:00:00 |  | 8000
Spreadsheet: 86228d1286246812-multiple-if-arguments-in-single-cell-collections-schedule
Sheet: Sheet1

 |  | Due Date | Amount | Date | Amount
 |  | 2010-10-01 00:00:00 | 110 | 2010-10-01 00:00:00
 |  | 2010-10-11 00:00:00 | 50 | 2010-10-02 00:00:00
 |  | 2010-10-03 00:00:00 | 83.69 | 2010-10-03 00:00:00
 |  | 2010-11-01 00:00:00 | 850 | 2010-10-04 00:00:00
 |  | 2010-10-16 00:00:00 | 20 | 2010-10-05 00:00:00
 |  | 2010-10-21 00:00:00 | 20 | 2010-10-06 00:00:00
 |  | 2010-10-27 00:00:00 | 40 | 2010-10-07 00:00:00
 |  | 2010-10-23 00:00:00 | 19.99 | 2010-10-08 00:00:00
 |  | 2010-10-20 00:00:00 | 35 | 2010-10-09 00:00:00
 |  | 2010-10-14 00:00:00 | 26.29 | 2010-10-10 00:00:00
 |  |  |  | 2010-10-11 00:00:00
 |  |  |  | 2010-10-12 00:00:00
 |  |  |  | 2010-10-13 00:00:00
 |  |  |  | 2010-10-14 00:00:00
 |  |  |  | 2010-10-15 00:00:00
 |  |  |  | 2010-10-16 00:00:00
 |  |  |  | 2010-10-17 00:00:00
 |  |  |  | 2010-10-18 00:00:00
 |  |  |  | 2010-10-19 00:00:00
 |  |  |  | 2010-10-20 00:00:00
 |  |  |  | 2010-10-21 00:00:00
 |  |  |  | 2010-10-22 00:00:00
 |  |  |  | 2010-10-23 00:00:00
 |  |  |  | 2010-10-24 00:00:00
 |  |  |  | 2010-10-25 00:00:00
 |  |  |  | 2010-10-26 00:00:00
 |  |  |  | 2010-10-27 00:00:00
 |  |  |  | 2010-10-28 00:00:00
 |  |  |  | 2010-10-29 00:00:00
Spreadsheet: 118931d1314102990-excel-2007-chart-names-series-issue-book1
Sheet: Sheet2

x | a | b | c | d
1 | 1 | 2 | 3 | 4
2 | 1 | 2 | 3 | 4
3 | 1 | 2 | 3 | 4
4 | 1 | 2 | 3 | 4
Spreadsheet: 455934d1460567416-auto-populate-data-across-worksheets-test
Sheet: Master List

Player # | Name | [NAME] | ADT Score | Phone | Phone | [NAME] | To Maintain
1245 | [NAME] | Black | 250 | [PHONE]
222 | [NAME] | Platinum | <450 | [PHONE] |  | [EMAIL]
4785 | Kris Cross | Classic | 450-700 | [PHONE] | [PHONE] |  | 4/11 BB
8896 | Blake Rolly | Platinum | 200-500 | [PHONE]
121214 | [NAME] | Classic | 100 | [PHONE]
14257 | [NAME] | Black | 250 | 245-666-777 | [PHONE] | [EMAIL]
4511 | Santa Clause | Black | <450 | [PHONE]
1214 | Oingo Boingo | Classic | 450-700 | [PHONE] |  |  | 4/11 BB, 4/13 BCTS
3356 | Rolling Stone | Classic | 200-500 | [PHONE] |  | [EMAIL]
7412 | [NAME] | Platinum | 100 | [PHONE] | [PHONE]
1234 | [NAME] | Platinum | 250 | [PHONE]
4324 | GI Joe | Gold | <450 | [PHONE] |  |  | 4/11 BCTS,
2626 | Pot Sticker | Plaatinum | 450-700 | [PHONE] |  | [EMAIL]
7524 | Jelly Bean | Black | 200-500 | [PHONE]
2112 | [NAME] | Black | 100 | [PHONE] | [PHONE] |  | 4/11 BB, 4/12 [NAME], 4/13 Hotel
Spreadsheet: 748325d1632074188-time-vs-hours-too-many-hours-and-formula-wont-work-timereport
Sheet: TimeReport

 | Jan - Aug 21 |  |  |  | YEAR TO DATE
 |  |  |  |  |  | Jan - Aug 21 |  |  | double check
100/FABRIC | 1,503:11
200/METAL | 17 days, 15:30:00 |  |  |  | 100/FABRIC | 1,503:11 | seconds dropped
210/METAL-B | 5 days, 21:27:00 |  |  |  | 200/METAL | 17 days, 15:30:00 |  |  | 423
230/METAL-Br | 11 days, 18:50:00 |  |  |  | 210/METAL-B | 5 days, 21:27:00 |  |  | 141
300/F&W | 1,229:58 |  |  |  | 230/METAL-Br | 11 days, 18:50:00 |  |  | 282
309/REWORK | 8:00:00 |  |  |  | 300/F&W | 1,229:58
399/BC & WAR | 4 days, 6:24:00 |  |  |  | 309/REWORK | 8:00:00 |  |  | 8
400/S&P | 9 days, 16:07:00 |  |  |  | 399/BC & WAR | 4 days, 6:24:00 |  |  | 102
500/Assembly | 12 days, 21:13:00 |  |  |  | 400/S&P | 9 days, 16:07:00 |  |  | 232
509/REWORK | 1:15:00 |  |  |  | 500/Assembly | 12 days, 21:13:00 |  |  | 309
600/Shipping | 4 days, 16:12:00 |  |  |  | 509/REWORK | 1:15:00 |  |  | 1
700/Field Work | 8:00:00 |  |  |  | 600/Shipping | 4 days, 16:12:00 |  |  | 112
800/OH | 11 days, 0:08:00 |  |  |  | 700/Field Work | 8:00:00 |  |  | 8
820/Break | 5 days, 12:11:00 |  |  |  | 800/OH | 11 days, 0:08:00 |  |  | 264
830/Holiday | 2 days, 16:00:00 |  |  |  | 820/Break | 5 days, 12:11:00 |  |  | 132
TOTAL | 4,814:26 |  |  |  | 830/Holiday | 2 days, 16:00:00 |  |  | 64
 |  |  |  |  |  |  | WRONG HOURS
CSV Export - no formulas |  |  |  |  | Excel Export
shows correct total
for reference only - I won't use csv |  |  |  |  |  | need this total to work!
Spreadsheet: 231518d1367105606-is-there-a-simplified-method-for-sorting-extracted-data-sample-sort-2
Sheet: MASTER

[NAME] | FRIDAY
 | 2013-04-05 00:00:00 |  |  |  |  |  | The help columns F & H thru M are hidden.
STAFF | avail | IN | OUT | Position | Hours
Name 2 | ANY | 09:00:00 | 16:00:00 | B |  |  | I am just assuming what those "help" columns are for
Name 11 | ANY | 10:00:00 | 16:00:00 | C |  |  | so I titled them by what they seem to do.
Name 1 | ANY | 08:00:00 | 14:00:00 | B
Name 5 | ANY | 18:00:00 | 01:00:00 | B |  |  | The "Extract Criteria" is based off "Position"(B,C,D,U), "AM or PM"(A or P) and sorted
Name 29 | ANY | 19:00:00 | 01:00:00 | U |  |  | by "IN" time from earliest to latest with the help of the "ROW VALUES" and "SORTING COLUMN"
Name 4 | ANY | 17:00:00 | 01:00:00 | B |  |  | Which is then extracted and sorted to its corresponding cells on the "FRIDAY" worksheet.
Name 9 | ANY | 09:00:00 | 15:00:00 | C
Name 24 | ANY | 11:00:00 | 19:00:00 | U |  |  | You will also notice that none of the data is in any order on this sheet. But when it is
Name 8 | ANY | 08:00:00 | 14:00:00 | C |  |  | extracted to the "FRIDAY" worksheet ,each position (AM BOX, PM BOX,ect…) is first sorted from
Name 12 | ANY | 14:00:00 | 21:00:00 | C |  |  | earliest to latest and is matched with the Staff name scheduled for that shift.
Name 17 | ANY | 09:00:00 | 16:00:00 | D
Name 7 | ANY | 07:00:00 | 12:00:00 | C
Name 14 | ANY | 17:00:00 | 01:00:00 | C |  |  | My question is: Is there a simplified method to accomplishing this without the use
Name 16 | ANY | 18:00:00 | 01:00:00 | C |  |  | of any or as many help columns (F,H thru M)
Name 19 | ANY | 16:30:00 | 01:00:00 | D
Name 15 | ANY | 17:00:00 | 01:00:00 | C
Name 23 | ANY | 10:00:00 | 18:00:00 | U
Name 13 | ANY | 16:00:00 | 01:00:00 | C
Name 20 | ANY | 17:00:00 | 01:00:00 | D
Name 18 | ANY | 09:30:00 | 16:00:00 | D
Name 22 | ANY | 09:00:00 | 16:00:00 | U
Name 28 | ANY | 18:00:00 | 01:00:00 | U
Name 10 | ANY | 09:00:00 | 16:00:00 | C
Name 3 | ANY | 10:00:00 | 17:00:00 | B
Name 21 | ANY | 08:00:00 | 16:00:00 | U
Name 6 | ANY | 18:30:00 | 01:00:00 | B
Name 27 | ANY | 17:00:00 | 01:00:00 | U
Name 25 | ANY | 11:30:00 | 18:30:00 | U
Name 26 | ANY | 16:00:00 | 22:00:00 | U
Name 30 | ANY | 19:30:00 | 01:00:00 | U
Spreadsheet: 748782d1632340165-adding-a-name-based-on-city-book1-1-
Sheet: Sheet1

Department | City | Days | Shift | FTE | Status
Outpatient | Boise | Sat-Sun | 0600-1430 | 0.4
Outpatient | Boise | Sat-Sun | 0900-1730 | 0.4 | Open Shift
Outpatient | New York | Mon-Fri | 0500-1330 | 1