tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 231772d1367223286-how-to-sort-information-based-on-date-in-a-header-row-excel-schedule
Sheet: Apr

 |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2
 | 2013-01-01 00:00:00 |  | A | p | r | i | l
No. | Activity | Start Date | 2013-04-01 00:00:00 | 2013-04-02 00:00:00 | 2013-04-03 00:00:00 | 2013-04-04 00:00:00 | 2013-04-05 00:00:00 | 2013-04-06 00:00:00 | 2013-04-07 00:00:00 | 2013-04-08 00:00:00 | 2013-04-09 00:00:00 | 2013-04-10 00:00:00 | 2013-04-11 00:00:00 | 2013-04-12 00:00:00 | 2013-04-13 00:00:00 | 2013-04-14 00:00:00 | 2013-04-15 00:00:00 | 2013-04-16 00:00:00 | 2013-04-17 00:00:00 | 2013-04-18 00:00:00 | 2013-04-19 00:00:00 | 2013-04-20 00:00:00 | 2013-04-21 00:00:00 | 2013-04-22 00:00:00 | 2013-04-23 00:00:00 | 2013-04-24 00:00:00 | 2013-04-25 00:00:00 | 2013-04-26 00:00:00 | 2013-04-27 00:00:00 | 2013-04-28 00:00:00 | 2013-04-29 00:00:00 | 2013-04-30 00:00:00
 |  | [NAME] | 2013-04-01 00:00:00 | 2013-04-02 00:00:00 | 2013-04-03 00:00:00 | 2013-04-04 00:00:00 | 2013-04-05 00:00:00 | 2013-04-06 00:00:00 | 2013-04-07 00:00:00 | 2013-04-08 00:00:00 | 2013-04-09 00:00:00 | 2013-04-10 00:00:00 | 2013-04-11 00:00:00 | 2013-04-12 00:00:00 | 2013-04-13 00:00:00 | 2013-04-14 00:00:00 | 2013-04-15 00:00:00 | 2013-04-16 00:00:00 | 2013-04-17 00:00:00 | 2013-04-18 00:00:00 | 2013-04-19 00:00:00 | 2013-04-20 00:00:00 | 2013-04-21 00:00:00 | 2013-04-22 00:00:00 | 2013-04-23 00:00:00 | 2013-04-24 00:00:00 | 2013-04-25 00:00:00 | 2013-04-26 00:00:00 | 2013-04-27 00:00:00 | 2013-04-28 00:00:00 | 2013-04-29 00:00:00 | 2013-04-30 00:00:00
1 | DEMOLISH OLD BUILDINGS | CHAMIC
2 | SANDSTONE FINISHES TO EXTENSION BUILDING | ISG
2.1 | REPLACE DOOR STEELWORK | ISG
2.2 | SOUTH SIDE BLOCKWORK | ISG
2.3 | FIREPROOFING | ISG
2.4 | SRWV BUND INSTALLATION | ISG
2.5 | CUT & INSTALL TRENCH FOR MCC | ISG
3 | PIPEWORK INSTALLATION BUILDING EXTENSION | ABERCROMBIES
3.1 | PIPEWORK INSTALLATION OLD STILL HOUSE | ABERCROMBIES
3.2 | PIPEWORK INSTALLATION COOLING TOWERS | ABERCROMBIES
4 | CABLE ROUTE INSTALLATION EXTENSION BUILDING | GRANTS
4.1 | CABLE ROUTE INSTALLATION COOLING TOWERS | GRANTS
4.2 | INSTALL BOILERHOUSE STEELWORK | PATERSONS
4.3 | INSTALL BOILER DUCTWORK | PATERSONS
5 | CLEAN TRENCH IN BOILERHOUSE | MSIS
5.1 | INSTALL BOILER FAN IN BOILERHOUSE | MITCHELLS
5.2 | REMOVE TRENCH CABLES | GRANTS
5.3 | INSTALL COOLING TOWER STAIRS | MITCHELLS
6 | REMOVE WASHBACK SCAFFOLDS | SPEYSIDE SCAFFOLDING
6.1
6.2
6.3
6.4
7
7.1
7.2
7.3
7.4
7.5
8
8.1
8.2
8.3
8.4
8.5
8.6
Spreadsheet: 22847d1212003642-help-with-calculating-a-chart-excel_help
Sheet: works

 |  |  |  |  |  |  |  | Hours allowed
 |  |  |  |  | Sales: | 2750 |  | 89.745
Labor Chart
2000 |  | 70.445
2100 |  | 71.41 |  |  | number rounded: | 2800
2200 |  | 73.8225
2300 |  | 77.2
2400 |  | 80.095
2500 |  | 82.5075
2600 |  | 85.4025
2700 |  | 88.2975 |  | This will work but it's not exact.
2800 |  | 89.745
2900 |  | 92.1575
3000 |  | 94.0875
3100 |  | 95.535
3200 |  | 97.9475
3300 |  | 100.8425
3400 |  | 103.7375
Sales |  | Hours allowed
Spreadsheet: 721037d1614438822-excel-index-match-retrieving-multiple-columns-of-data-example
Sheet: Total

 | Total |  |  |  |  |  | Nike | sort based off company
 | Investor | Company | Year | Amount |  |  | Investor | Company | Year | Amount
 | [NAME] | nike | 2020 | 100 |  |  | [NAME] | nike | 2020 | 100
 | ron | adidas | 2018 | 200 |  |  | grant | nike | 2019 | 100
 | grant | nike | 2019 | 100 |  |  | [NAME] | nike | 2020 | 100
 | drew | reebox | 2019 | 300 |  |  | [NAME] | nike | 2020 | 300
 | billy | adidas | 2018 | 100 |  |  | justin | nike | 2019 | 300
 | will | reebok | 2020 | 400 |  |  | [NAME] | nike | 2020 | 200
 | [NAME] | nike | 2020 | 100 |  |  | ryan | nike | 2018 | 400
 | [NAME] | adidas | 2019 | 200 |  |  | [NAME] | nike | 2018 | 300
 | [NAME] | nike | 2020 | 300
 | al | adidas | 2018 | 400
 | [NAME] | reebok | 2019 | 600 |  |  | 2020 | sort based off year
 | justin | nike | 2019 | 300
 | [NAME] | nike | 2020 | 200 |  |  | Investor | Company | Year | Amount
 | [NAME] | reebok | 2019 | 500 |  |  | [NAME] | nike | 2020 | 100
 | ryan | nike | 2018 | 400 |  |  | will | reebok | 2020 | 400
 | nathan | adidas | 2019 | 100 |  |  | [NAME] | nike | 2020 | 100
 | [NAME] | adidas | 2019 | 100 |  |  | [NAME] | nike | 2020 | 300
 | [NAME] | nike | 2018 | 300 |  |  | [NAME] | nike | 2020 | 200
 |  |  |  |  |  |  | Nike | 2020 | sort based off year and company
 |  |  |  |  |  |  | Investor | Company | Year | Amount
 |  |  |  |  |  |  | [NAME] | nike | 2020 | 100
 |  |  |  |  |  |  | [NAME] | nike | 2020 | 100
 |  |  |  |  |  |  | [NAME] | nike | 2020 | 300
 |  |  |  |  |  |  | [NAME] | nike | 2020 | 200
Spreadsheet: lisa_gang__22243__EPE_MARCH_2002
Sheet: MARCH(30)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-30 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | PALO VERDE |  | FOUR CORNERS
Pacific | Mountain | SALE | SALE |  | PURCHASE
Standard | Standard | EPMI | PNM |  | PNM
Time | Time | 22.25
 |  | CARRY OVER FROM 3/29 | CARRY OVER FROM 3/29 |  | CARRY OVER FROM 3/29
 |  | 3/1/02-3/31/02 | 2002-03-27 00:00:00 |  | 2002-03-27 00:00:00
 |  | EPMI TAG#41735 | IPC TAG#P979E00 |  | EPMI TAG#41742 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL |  | DIRECT BILL
2400 | 0100 | 25 | 50 |  | -50
0100 | 0200 | 0 | 0 |  | 0
0200 | 0300 | 0 | 0 |  | 0
0300 | 0400 | 0 | 0 |  | 0
0400 | 0500 | 0 | 0 |  | 0
0500 | 0600 | 0 | 0 |  | 0
0600 | 0700 | 0 | 0 |  | 0
0700 | 0800 | 0 | 0 |  | 0
0800 | 0900 | 0 | 0 |  | 0
0900 | 1000 | 0 | 0 |  | 0
1000 | 1100 | 0 | 0 |  | 0
1100 | 1200 | 0 | 0 |  | 0
1200 | 1300 | 0 | 0 |  | 0
1300 | 1400 | 0 | 0 |  | 0
1400 | 1500 | 0 | 0 |  | 0
1500 | 1600 | 0 | 0 |  | 0
1600 | 1700 | 0 | 0 |  | 0
1700 | 1800 | 0 | 0 |  | 0
1800 | 1900 | 0 | 0 |  | 0
1900 | 2000 | 0 | 0 |  | 0
2000 | 2100 | 0 | 0 |  | 0
2100 | 2200 | 0 | 0 |  | 0
2200 | 2300 | 0 | 0 |  | 0
2300 | 2400 | 0 | 0 |  | 0
2400 | 0100 | 0 | 0 |  | 0
 | MST Total |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  | TOTAL SALES |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)PV |  | PNM(G)4C345
 |  | EPMI | PNM |  | EPMI
 |  | AZPS(T)FC3/PPD2 | EPMI |  | EPE
 |  | WALC(T)PPD2/COOLIDGE | NEVP |  | EPE(T4C345/4C345
 |  | CRSP(L)COOLIDGE | PAC |  | EPE(L)4C345
 |  |  | IPC
 |  |  | ISO(T)PVD/SP15
 |  |  | IPC(L)SP15
Spreadsheet: 218022d1362304354-referencing-cells-from-a-master-sheet-master-schedule-test-nhopkins-oeldere-
Sheet: SummaryWk1

 | Employee
 |  | Hours |  | Cost |  | Hours |  | Cost |  | Hours |  | Cost |  | Hours |  | Cost |  | Hours |  | Cost |  | Hours |  | Cost |  | Hours |  | Cost
 |  | Scheduled | Worked | Projected | Actual | Scheduled | Worked | Projected | Actual | Scheduled | Worked | Projected | Actual | Scheduled | Worked | Projected | Actual | Scheduled | Worked | Projected | Actual | Scheduled | Worked | Projected | Actual | Scheduled | Worked | Projected | Actual
 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
SUMMARY REPORT
 |  | Weekly projected | Weekly Actual | Hr/Wk Projected | Hr/Wk Actual
Total Projected
Total Actual
Spreadsheet: 94878d1294653390-figure-index-match-help
Sheet: Sheet1

 | PN | Family | EAQ | OpCo | BU | Number of bids | BOB 1 | Lowest Bid Company Name | BOB 2 | Second Lowest Bid Company 2 | BOB 3 | Supplier 1 | Supplier 2 | Supplier 3 | Test
 | 035-2727Heil Environmental | Hoses | 72300 | ESG | Heil Environmental | 3 | 2.25 | Supplier 1 | 2.65 | Supplier 3 | 10.6 | 2.25 | 10.6 | 2.65
 | 035-2774Heil Environmental | Hoses | 3000 | ESG | Heil Environmental | 3 | 2.5 | Supplier 1 | 2.6 | Supplier 3 | 10.75 | 2.5 | 10.75 | 2.6
 | 054-2988-006Heil Environmental | Fittings | 8300 | ESG | Heil Environmental | 3 | 4 | Supplier 1 | 4.5 | Supplier 3 | 12 | 4 | 12 | 4.5
 | 054-2988-008Heil Environmental | Fittings | 2200 | ESG | Heil Environmental | 3 | 5 | Supplier 1 | 5 | Supplier 1 | 12.5 | 5 | 12.5 | 5
 | 054-2988-010Heil Environmental | Fittings | 7557 | ESG | Heil Environmental | 3 | 4.75 | Supplier 3 | 6 | Supplier 1 | 12.7 | 6 | 12.7 | 4.75
 | 22516Bradco | Fittings | 9999 | Paladin | Bradco | 1 | 55 | Test |  | Supplier 1 |  |  |  |  | 55
Spreadsheet: tracy_geaccone__40206__Infrastructure Allocation BU's 10_22_01
Sheet: ENA

ENA 2002 Plan
Support Department Infrastructure Allocation
 |  |  | Infrastructure |  | Total |  | By Location
Commercial Team | Headcount |  | Allocation |  | ENA |  | Houston |  | Portland |  | NY |  | Canada |  | Mexico
East Power | 220 |  |  |  |  |  | 220
West Power | 129 |  |  |  |  |  |  |  | 129
Natural Gas | 186 |  |  |  |  |  | 184 |  |  |  | 2
Canada | 85 |  |  |  |  |  |  |  |  |  |  |  | 85
Upstream Products | 12 |  |  |  |  |  | 12
HPL | 0 |  |  |  |  |  | 0
Mexico | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Energy Capital Services | 30 |  |  |  |  |  | 30
Asset Marketing | 8 |  |  |  |  |  | 8
LT Fundamentals | 6 |  |  |  |  |  | 6
Office of the Chairman | 4 |  |  |  |  |  | 4
Total Commercial Teams
 |  |  | (000's)
Support Departments | Total HC |  | Infrastructure $ |  | ENA HC | ENA $ | EIM HC | EIM $ | EGM HC | EGM $ | ENW HC | ENW $ | EBS HC | EBS $ | EES EWS HC | EES EWS $ | [NAME] | EES Retail $ | Enron Corp HC | Enron Corp $ | EPI HC | EPI $ | EWS HC | EWS $ | Europe HC | Europe $ | EEOS HC | EEOS $ | ESA HC | ESA $ | RAC HC | RAC $ | ETS HC | ETS $ | EGAS HC | EGAS $ | EGF HC | EGF $
Enron Assurance Services | 6 |  |  |  | 4 |  |  |  |  |  |  |  | 1 |  | 1
Canada Support | 75 |  |  |  | 75
Competitive Analysis & Business Controls | 18 |  |  |  | 7 |  | 1 |  | 4 |  |  |  |  |  | 0 |  | 1 |  |  |  |  |  | 5
eSource | 6 |  |  |  | 2 |  | 1 |  | 1 |  |  |  | 1 |  |  |  |  |  | 1
Financial Operations | 138 |  |  |  | 69 |  | 2 |  | 2 |  | 1 |  | 19 |  | 25 |  |  |  |  |  | 9 |  | 5 |  | 1 |  | 1 |  | 4
Human Resources | 178 |  |  |  | 46 |  | 8 |  | 9 |  |  |  | 10 |  | 1 |  | 43 |  | 15 |  | 1 |  |  |  | 1 |  | 7 |  |  |  |  |  | 2
Legal (a) | 127 |  |  |  | 66 |  | 10 |  | 17 |  | 5 |  | 15 |  | 1 |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  | 1 |  |  |  | 5 |  | 3
Public Relations | 10 |  |  |  | 4 |  | 2 |  | 2 |  | 2
Research | 50 |  |  |  | 15 |  | 3 |  | 10 |  |  |  | 1 |  | 3 |  | 6 |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 9 |  | 2
Tax | 22 |  |  |  | 10 |  | 4 |  | 5 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Technical Services | 14 |  |  |  | 14
Transaction Support | 14 |  |  |  | 4 |  | 2 |  | 5 |  | 1 |  | 1 |  |  |  |  |  |  |  | 1
Treasury | 20 |  |  |  | 20
Total Support Departments
Total
Total ENA
(a) FTE Calculation for Legal is based on % of Internal Legal Costs applied to total HC.
Spreadsheet: 160144d1338986183-how-to-create-a-graph-in-the-chart-ticket_report_eswar
Sheet: Sheet8

Ticket Type | User Story
 | Column Labels
 | No of Stories |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual/estimated effort |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total No of Stories | Total Actual/estimated effort
Row Labels | Project Backlog | Sprint 0 | Sprint 1 | Sprint 10 | Sprint 11 | Sprint 12 | Sprint 13 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | Sprint 6 | Sprint 7 | Sprint 8 | Sprint 9 | Project Backlog | Sprint 0 | Sprint 1 | Sprint 10 | Sprint 11 | Sprint 12 | Sprint 13 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | Sprint 6 | Sprint 7 | Sprint 8 | Sprint 9
Completed | 11 | 22 | 8 |  |  |  |  | 9 | 11 | 41 | 21 | 16 | 1 |  |  | 80 | 2 | 42 |  |  |  |  | 22 | 92 | 174 | 239 | 160 | 16 |  |  | 140 | 827
In Progress |  |  |  |  |  |  |  |  |  | 1 |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  | 16 |  |  | 260 | 16 |  | 15 | 292
Not Started | 103 |  |  | 34 | 46 | 27 | 4 |  |  |  |  |  | 16 | 35 | 36 | 913 |  |  | 486 | 396 | 280 | 116 |  |  |  |  |  | 206 | 406 | 348 | 301 | 3151
Ready To Test |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 46 |  |  | 9 | 82
Ready To Verify |  |  |  |  |  |  |  |  |  |  | 1 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 67 |  |  | 6 | 83
Grand Total | 114 | 22 | 8 | 34 | 46 | 27 | 4 | 9 | 11 | 42 | 22 | 20 | 40 | 36 | 36 | 993 | 2 | 42 | 486 | 396 | 280 | 116 | 22 | 92 | 190 | 255 | 196 | 595 | 422 | 348 | 471 | 4435
Status | Project Backlog | Sprint 0 | Sprint 1 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | Sprint 6 | Sprint 7 | Sprint 8 | Sprint 9 | Sprint 10 | Sprint 11 | Sprint 12 | Sprint 13 | Project Backlog | Sprint 0 | Sprint 1 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | Sprint 6 | Sprint 7 | Sprint 8 | Sprint 9 | Sprint 10 | Sprint 11 | Sprint 12 | Sprint 13
Completed
In Progress
Not Started
Ready To Test
Ready To Verify
Status | Project Backlog | Sprint 0 | Sprint 1 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | Sprint 6 | Sprint 7 | Sprint 8 | Sprint 9 | Sprint 10 | Sprint 11 | Sprint 12 | Sprint 13 | Project Backlog | Sprint 0 | Sprint 1 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | Sprint 6 | Sprint 7 | Sprint 8 | Sprint 9 | Sprint 10 | Sprint 11 | Sprint 12 | Sprint 13
Completed
Not Started
Planned
Spreadsheet: 875332d1721917334-how-to-automatically-filter-multiple-arrays-of-data-by-their-relevant-headings-lookup-sheet-test
Sheet: ReferenceAccidentData

AccidentReferenceID | [NAME] | AccidentID
563263 | 358047 | 353208
563285 | 358058 | 353208
563299 | 358063 | 353212
563298 | 358064 | 353212
563333 | 358065 | 353212
563344 | 358066 | 353212
563300 | 358064 | 353215
563302 | 358063 | 353216
563301 | 358064 | 353216
563334 | 358065 | 353216
563345 | 358066 | 353216
563304 | 358063 | 353218
563303 | 358064 | 353218
563335 | 358065 | 353218
563346 | 358066 | 353218
563267 | 358051 | 353220
563306 | 358063 | 353221
563305 | 358064 | 353221
563336 | 358065 | 353221
563347 | 358066 | 353221
563307 | 358064 | 353222
563332 | 358065 | 353223
563308 | 358064 | 353225
563309 | 358064 | 353227
563286 | 358060 | 353228
563268 | 358051 | 353229
563310 | 358064 | 353230
563269 | 358051 | 353232
563311 | 358064 | 353233
563313 | 358063 | 353234
563312 | 358064 | 353234
563337 | 358065 | 353234
563348 | 358066 | 353234
563270 | 358051 | 353242
563315 | 358063 | 353243
563314 | 358064 | 353243
563338 | 358065 | 353243
563349 | 358066 | 353243
563316 | 358064 | 353247
563339 | 358065 | 353247
563317 | 358064 | 353248
563318 | 358064 | 353249
563276 | 358056 | 353250
563287 | 358058 | 353250
563277 | 358056 | 353251
563288 | 358058 | 353251
563278 | 358056 | 353252
563289 | 358058 | 353252
563319 | 358064 | 353254
563320 | 358064 | 353255
563321 | 358064 | 353256
563340 | 358065 | 353256
563279 | 358056 | 353259
563290 | 358058 | 353259
563322 | 358064 | 353261
563341 | 358065 | 353261
563324 | 358063 | 353262
563323 | 358064 | 353262
563342 | 358065 | 353262
563350 | 358066 | 353262
563325 | 358064 | 353263
563271 | 358051 | 353264
563326 | 358064 | 353265
563272 | 358051 | 353266
563297 | 358063 | 353272
563331 | 358065 | 353272
563327 | 358064 | 353273
563291 | 358058 | 353274
563328 | 358064 | 353275
563264 | 358047 | 353330
563265 | 358048 | 353330
563266 | 358049 | 353330
563273 | 358050 | 353330
563274 | 358051 | 353330
563275 | 358052 | 353330
563281 | 358053 | 353330
563282 | 358054 | 353330
563280 | 358055 | 353330
563283 | 358056 | 353330
563284 | 358057 | 353330
563294 | 358058 | 353330
563295 | 358059 | 353330
563292 | 358060 | 353330
563293 | 358061 | 353330
563296 | 358062 | 353330
563330 | 358063 | 353330
563329 | 358064 | 353330
563343 | 358065 | 353330
563351 | 358066 | 353330
Spreadsheet: 186762d1350205239-creating-a-formula-to-populate-data-in-particular-cells-based-on-conditions-in-other-cells-media-tracking-sheet
Sheet: Data

Store Rating Tables (Avg)
Medium
 | TV | Radio
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Station
 | Seven Network | Nine Network | Network Ten | Prime7 | NBN | SCA | WIN
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Radio Station
 | ATN | 97.3 | Triple M | Beat 105 | Nova | Sea FM | Gold FM | Hot Tomato | 2DAY | Mix | WSFM | FOX FM | 92.9 | 96FM | NXFM | KOFM | SAFM | 104.7
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Store Sales Rating Tables
Spreadsheet: 752235d1634659752-vlookup-stops-working-after-several-rows-po-workbook
Sheet: 7th CO - # __ 

13-005 NFCU AUDITORIUM EXPANSION
Owner Direct Purchase Summary Log
PO # | VENDOR | CONTRACTOR | PREVIOUSLY TAXED (NET AMT) | 2016-04-01 00:00:00 | CURRENT SUBTOTAL | nontx | nontx | nontx | NON TAXABLE | TAXABLE | TOTAL TAXES | TOTAL CO
 |  | subtotals
 |  | Total Previously Invoiced |  |  |  |  |  |  | TOTAL CHANGE ORDER AMOUNT
Spreadsheet: 81529d1281660866-sorting-placing-data-by-three-variables-tournament-software-template
Sheet: Day 2 - Tee Sheet (C1)

[NAME] 2 - C1
Starting Time/Tee | Player 1 | Player 2 | Player 3 | Player 4
07:00:00
1st Tee
10th Tee
07:10:00
1st Tee
10th Tee
07:20:00
1st Tee
10th Tee
07:30:00
1st Tee
10th Tee
07:40:00
1st Tee
10th Tee
07:50:00
1st Tee
10th Tee
08:00:00
1st Tee
10th Tee
08:10:00
1st Tee
10th Tee
08:20:00
1st Tee
10th Tee
08:30:00
1st Tee
10th Tee
08:40:00
1st Tee
10th Tee
08:50:00
1st Tee
10th Tee
09:00:00
1st Tee
10th Tee
12:30:00
1st Tee
10th Tee
12:40:00
1st Tee
10th Tee
12:50:00
1st Tee
10th Tee
13:00:00
1st Tee
10th Tee
13:10:00
1st Tee
10th Tee
13:20:00
1st Tee
10th Tee
13:30:00
1st Tee
10th Tee
13:40:00
1st Tee
10th Tee
13:50:00
1st Tee
10th Tee
14:00:00
1st Tee
10th Tee
14:10:00
1st Tee
10th Tee
14:20:00
1st Tee
10th Tee
14:30:00
1st Tee
10th Tee
Spreadsheet: 839730d1692189182-removing-first-string-of-text-alpha-numeric-from-a-longer-text-string-sample-3_split
Sheet: Sheet1

 |  |  | Required Result
 | Full Description |  | Full Description.2
 | AWT55 Product Specification 500 x 500 |  | Product Specification 500 x 500
 | AWT55 Product Specification 500 x 501 |  | Product Specification 500 x 501
 | AWT55 Product Specification 500 x 502 |  | Product Specification 500 x 502
 | AWT55 Product Specification 500 x 503 |  | Product Specification 500 x 503
 | AWT55 Product Specification 500 x 504 |  | Product Specification 500 x 504
 | AWT55 Product Specification 500 x 505 |  | Product Specification 500 x 505
 | AWT55 Product Specification 500 x 506 |  | Product Specification 500 x 506
 | AWT55 Product Specification 500 x 507 |  | Product Specification 500 x 507
 | AWT55 Product Specification 500 x 508 |  | Product Specification 500 x 508
 | AWT55 Product Specification 500 x 509 |  | Product Specification 500 x 509
 | AWT55 Product Specification 500 x 510 |  | Product Specification 500 x 510
 | AWT55 Product Specification 500 x 511 |  | Product Specification 500 x 511
Spreadsheet: 698985d1602314036-formula-to-only-work-on-todays-date-test
Sheet: Sheet1

 |  |  |  | 2020-10-01 00:00:00 | 2020-10-02 00:00:00 | 2020-10-03 00:00:00 | 2020-10-04 00:00:00 | 2020-10-05 00:00:00 | 2020-10-06 00:00:00 | 2020-10-07 00:00:00 | 2020-10-08 00:00:00 | 2020-10-09 00:00:00 | 2020-10-10 00:00:00 | 2020-10-11 00:00:00 | 2020-10-12 00:00:00 | 2020-10-13 00:00:00 | 2020-10-14 00:00:00 | 2020-10-15 00:00:00 | 2020-10-16 00:00:00 | 2020-10-17 00:00:00 | 2020-10-18 00:00:00 | 2020-10-19 00:00:00 | 2020-10-20 00:00:00 | 2020-10-21 00:00:00 | 2020-10-22 00:00:00 | 2020-10-23 00:00:00 | 2020-10-24 00:00:00 | 2020-10-25 00:00:00 | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00
 |  | units available
 |  | traillers available
Spreadsheet: 759775d1639727957-error-trapping-if-and-multiple-cells-must-all-have-error-sample-12-1-1-
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  | Expected Result
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
5 | 5 | 5 | 5 | 5 |  | 5 | 5
 |  |  |  |  | asdf | 5
asdf | asdf | asdf | asdf | asdf | asdf | asdf | asdf
asdf | asdf | asdf | af | adf | 0 | asdf | asdf
0 | 0 | 0 | 0 | 0 | 0 | asdf
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 27900d1221619428-how-to-change-a-calculated-cell-to-a-value-customers
Sheet: Data

Month: | Customers
January | 1435
February | 1502
March | 1517
April | 1499
May | 1458
June | 1432
July | 1402
August | 1373
September | 1343
October | 1314
November | 1284
December | 1255
Spreadsheet: 879303d1726776934-pulling-info-from-several-sheets-in-a-workbook-to-show-on-a-separate-sheet-in-one-list-example-workbook-for-excel-forum
Sheet: Sheet1

MASTER REFERENCE SHEET
This needs to show information from the other sheets that staff update. The information below should not be typed in, but pulled from the other sheets as data is added to them
SCHOOL | ACTIVITY | YEAR GROUP | DURATION
Apple School | Careers Event | 11 | 2 hours
Apple School | Form Group Work | 11 | 1 hour
Orange School | Parents Evening | 10 | 3 hours
Lemon School | Form Activity | 11 | 1 hour
Lemon School | Assembly | 11 | 1 hour
Spreadsheet: 673210d1587252740-help-creating-a-function-with-indirect-ref-bill-032120
Sheet: bbb

Date | Asset | Amount | Cost | Color | Place
2020-02-01 00:00:00 | bb | 9 | 2 | r | x
2020-02-03 00:00:00 | bf | 8 | 4 | b | y
2020-02-04 00:00:00 | bc | 6 | 3 | g | z
2020-02-03 00:00:00 | be | 4 | 1 | v | p
Spreadsheet: 85501d1285611000-using-weekly-data-to-convert-to-monthly-quote-analyser
Sheet: Weekly Com. Totals

Week Commencing | Total # of Jobs Quoted | Total Jobs Quoted Value | Average Value/Job | Sector | # of Jobs Quoted | Jobs Quoted Value | # of Jobs Attained | Jobs Attained Value | Average Value/Job | # of Jobs Success Rate | Job Value Success Rate
2010-06-28 00:00:00 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
 |  |  |  | Building
 |  |  |  | Landscaping
Spreadsheet: 172944d1344377558-automatically-display-filtered-data-on-other-sheets-based-on-the-first-sheet-fruits
Sheet: Data

First Name | Surname | Age | State | Fruit
[NAME] | Smith | 18 | ACT | Apples
[NAME] | Evans | 25 | NSW | Pears
[NAME] | Clifford | 43 | QLD | Oranges
[NAME] | Lean | 24 | QLD | Lemons
Kylie | [NAME] | 56 | SA | Grapes
[NAME] | Kennet | 12 | VIC | Bananas
[NAME] | [NAME] | 34 | WA | Apples
[NAME] | [NAME] | 52 | WA | Pears
[NAME] | [NAME] | 27 | NT | Oranges
Julie | [NAME] | 65 | NT | Apples
Jeremy | [NAME] | 41 | WA | Pears
Spreadsheet: 147555d1332855111-excel-2007-value-to-change-book1
Sheet: Sheet1

A01 | B01 | NA | [NAME] | B06
A02 | B02 | NA | A25 | B07
A03 | B03 | NA | A18 | B08
A04 | B04 | NA | A02 | B09
A05 | B05 | NA | A20 | B10
A06 | B06 | NA | A17 | B11
A07 | B07 | NA | A01 | A04
A08 | B08 | NA | A24 | A05
A09 | B09 | NA | A51 | B12
A10 | B10 | NA | A52 | B13
A11 | B11 | NA | A53 | B14
 | B12 | NA | [NAME] | B15
 | B13 | NA | A03 | B19
 | B14 | NA | A04 | [NAME]
 | B15 | NA | A91 | B21
 | B16 | NA | A05 | A01
 | B17 | NA | A10 | A02
 | B18 | NA | A09 | A03
 | B19 | NA | A11 | A04
 | [NAME] | NA | A210 | A05
 | B21 | NA | A07 | B22
 | B22 | NA | A06 | B23
 | B23 | NA | A12 | B24
 | B24 | NA | A17 | B25
 | B25 | NA | [NAME] | A11