tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2f6a27ce-a867-4b45-b1bc-1c8cd4cdaf23
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 | ($ millions) |  | Q110 | Q210 | Q310 | Q410 |  | Q111 | Q211 | Q311 | Q411 |  | Q112 | Q212 | Q312 | Q412 |  | 2010 | 2011 | 2012
 | Revenue
 | Completion and Production |  | 1964 | 2393 | 2655 | 2985 |  | 3172 | 3618 | 4025 | 4328 |  | 4290 | 0 | 0 | 0 |  | 9997 | 15143 | 4290
 | Drilling and Evaluation |  | 1797 | 1994 | 2010 | 2175 |  | 2110 | 2317 | 2523 | 2736 |  | 2578 | 0 | 0 | 0 |  | 7976 | 9686 | 2578
 | Total |  | 3761 | 4387 | 4665 | 5160 |  | 5282 | 5935 | 6548 | 7064 |  | 6868 | 0 | 0 | 0 |  | 17973 | 24829 | 6868
 | Operating Income
 | Completion and Production |  | 238 | 497 | 609 | 688 |  | 660 | 918 | 1068 | 1087 |  | 1036 | 0 | 0 | 0 |  | 2032 | 3733 | 1036
 | Drilling and Evaluation |  | 270 | 318 | 271 | 354 |  | 230 | 324 | 369 | 480 |  | 368 | 0 | 0 | 0 |  | 1213 | 1403 | 368
 | Corporate and Other |  | -59 | -53 | -62 | -62 |  | -76 | -81 | -105 | -137 |  | -381 | 0 | 0 | 0 |  | -236 | -399 | -381
 | Total |  | 449 | 762 | 818 | 980 |  | 814 | 1161 | 1332 | 1430 |  | 1023 | 0 | 0 | 0 |  | 3009 | 4737 | 1023
 | CAPEX |  | 404 | 451 | 557 | 657 |  | 704 | 719 | 741 | 789 |  | 782 | 0 | 0 | 0 |  | 2069 | 2953 | 782
 | DDA |  | 261 | 272 | 284 | 302 |  | 320 | 331 | 340 | 368 |  | 385 | 0 | 0 | 0 |  | 1119 | 1359 | 385
Spreadsheet: 872974d1719421654-combination-of-two-cell-if-repeats-the-six-cell-should-change-it-color-combination-of-two-cell-if-repeats-the-six-cell-should-change-it-color
Sheet: Sheet1

 | Data look like this |  |  |  |  |  | Want like this
 |  |  | D | E |  |  |  |  | D | E
 | Sr | Task Description | HH nos | Street |  |  | Sr | Task Description | HH nos | Street
 | 1 | Excavation | hh1 | St 1 |  |  | 1 | Excavation | hh1 | St 1
 | 2 | [NAME] | hh1 | St 1 |  |  | 2 | [NAME] | hh1 | St 1
 | 3 | [NAME] (Plaster) | hh1 | St 1 |  |  | 3 | [NAME] (Plaster) | hh1 | St 1
 | 4 | Steel Shattering | hh1 | St 1 |  |  | 4 | Steel Shattering | hh1 | St 1
 | 5 | RCC Slab | hh1 | St 1 |  |  | 5 | RCC Slab | hh1 | St 1
 | 6 | Excavation | hh1 | St 1 |  |  | 6 | Excavation | hh1 | St 1 |  | This is repeated after 5 rows, I want this
 | 7 | [NAME] | hh1 | St 1 |  |  | 7 | [NAME] | hh1 | St 1
 | 8 | [NAME] (Plaster) | hh1 | St 1 |  |  | 8 | [NAME] (Plaster) | hh1 | St 1
 | 9 | Steel Shattering | hh1 | St 1 |  |  | 9 | Steel Shattering | hh1 | St 1
 | 10 | RCC Slab | hh1 | St 1 |  |  | 10 | RCC Slab | hh1 | St 1
 | 11 | Excavation | hh3 | St 1 |  |  | 11 | Excavation | hh3 | St 1
 | 12 | [NAME] | hh3 | St 1 |  |  | 12 | [NAME] | hh3 | St 1
 | 13 | [NAME] (Plaster) | hh3 | St 1 |  |  | 13 | [NAME] (Plaster) | hh3 | St 1
 | 14 | Steel Shattering | hh3 | St 1 |  |  | 14 | Steel Shattering | hh3 | St 1
 | 15 | RCC Slab | hh3 | St 1 |  |  | 15 | RCC Slab | hh3 | St 1
 | 16 | Excavation | hh4 | St 1 |  |  | 16 | Excavation | hh4 | St 1
 | 17 | [NAME] | hh4 | St 1 |  |  | 17 | [NAME] | hh4 | St 1
 | 18 | [NAME] (Plaster) | hh4 | St 1 |  |  | 18 | [NAME] (Plaster) | hh4 | St 1
 | 19 | Steel Shattering | hh4 | St 1 |  |  | 19 | Steel Shattering | hh4 | St 1
 | 20 | RCC Slab | hh4 | St 1 |  |  | 20 | RCC Slab | hh4 | St 1
 | 21 | Excavation | hh5 | St 1 |  |  | 21 | Excavation | hh5 | St 1
 | 22 | [NAME] | hh5 | St 1 |  |  | 22 | [NAME] | hh5 | St 1
 | 23 | [NAME] (Plaster) | hh5 | St 1 |  |  | 23 | [NAME] (Plaster) | hh5 | St 1
 | 24 | Steel Shattering | hh5 | St 1 |  |  | 24 | Steel Shattering | hh5 | St 1
 | 25 | RCC Slab | hh5 | St 1 |  |  | 25 | RCC Slab | hh5 | St 1
 | 26 | Excavation | hh6 | St 1 |  |  | 26 | Excavation | hh6 | St 1
 | 27 | [NAME] | hh6 | St 1 |  |  | 27 | [NAME] | hh6 | St 1
 | 28 | [NAME] (Plaster) | hh6 | St 1 |  |  | 28 | [NAME] (Plaster) | hh6 | St 1
 | 29 | Steel Shattering | hh6 | St 1 |  |  | 29 | Steel Shattering | hh6 | St 1
 | 30 | RCC Slab | hh6 | St 1 |  |  | 30 | RCC Slab | hh6 | St 1
Spreadsheet: 356146d1415008215-data-validation-lists-and-lookup-problem-personal
Sheet: Sheet1

 |  |  |  | Part | Number | Manufacturer
 |  |  |  | Windshield |  |  |  | Part | Number | Manufacturer
 |  |  |  | Gearbox |  |  |  | Wheel | 8898JK | Ford
 |  |  |  | Windshield |  |  |  | Axis | 5565DF | Ford
 |  |  |  | Gearbox |  |  |  | Tire | 8659TY | Michelin
 |  |  |  | Wheel |  |  |  | Gearshift | 2152ER | General Motors
 |  |  |  | Turbo kit |  |  |  | Windshield | 6569ED | Some company
 |  |  |  | Turbo kit |  |  |  | Gearbox | 5555SC | General Motors
 |  |  |  | Booster kit |  |  |  | Turbo kit | 6653VB | General Motors
 |  |  |  | Gearshift |  |  |  | Nitros kit | 2165SD | NOS
 |  |  |  | Wheel |  |  |  | Differential | 1956HB | General Motors
 |  |  |  | Fuel injection kit |  |  |  | Spoiler | 1525AS | Ford
 |  |  |  | Booster kit |  |  |  | Decal 1 | 5698SD | Some company
 |  |  |  | Decal 3 |  |  |  | Decal 2 | 1121AS | Some company
 |  |  |  | Decal 2 |  |  |  | Decal 3 | 6554SW | Some company
 |  |  |  |  |  |  |  | Booster kit | 9865GH | Ford
 |  |  |  |  |  |  |  | Fuel injection kit | 1326IK | Ford
Spreadsheet: 825212d1681177939-add-not-to-exceed-to-the-sum-formula-add-not-to-exceed-to-the-sum-formula
Sheet: Excel Help

Applicant | Relevant Experience 1 | RE 1 | Relevant Experience 2 | RE 2 | Relevant Experience 3 | RE 3 | Total Rel Exp Points [NAME] pts: 40 | Specific Technical Expertise 1 ([NAME]) | STE 1 | Specific Technical Expertise 2 (Guidance/Policy (Industry/Government)) | STE 2 | Specific Technical Expertise 3 (Problem Solving, Trouble Shooting, Analytical Skills, etc) | STE 3 | Specific Technical Expertise 4 (Computer Skills) | STE 4 | Total Spec Tech Exp Points [NAME] pts: 30 | TOTAL Relevant Expert & Specific Technical Expertise [NAME] pts: 70 | Diversity of Experience  1 | DE 1 | Diversity of Experience  2 | DE 2 | Diversity of Experience  3 | DE 3 | TOTAL Diversity of Experience [NAME] pts: 15 | Total Score | Selecting Official Comments (Optional)
Cand 1 | Non-Federal/Government Inventory Management- 6+ yrs= 40 pts |  | Non-Federal/Government Inventory Management- <2yrs= 10 pts |  | Non-Federal/Government Supervisor/Management Experience- 6+ yrs= 40 pts |  |  | References 9 or more different areas of activity and/or terms = 10 pts |  | References 4 or more different areas of activity and/or terms = 8 pts |  | References 4 or more different areas of activity and/or terms = 8 pts |  | References 4 or more different areas of activity and/or terms = 4 pts
Cand 2 | Non-Federal/Government Inventory Management- 2-3.99 yrs= 20 pts |  | Non-Federal/Government Inventory Management- 2-3.99 yrs= 20 pts |  | FWS Experience (List Series)- 4-5.99 yrs= 30 pts |  |  | References 9 or more different areas of activity and/or terms = 10 pts |  | References 4 or more different areas of activity and/or terms = 8 pts |  | References 4 or more different areas of activity and/or terms = 8 pts |  | References 4 or more different areas of activity and/or terms = 4 pts
Cand 3
Cand 4
Cand 5
Cand 6
Cand 7
Cand 8
Cand 9
Cand 10
Cand 11
Cand 12
Cand 13
Cand 14
Cand 15
Cand 16
Cand 17
Cand 18
Cand 19
Spreadsheet: 873117d1719540541-formula-referencing-2-different-sheets-book1-1-
Sheet: Summary

Totals |  |  | Fly State |  | Winds
Enteries |  |  | [NAME] |  | [NAME]
Total Flight Time |  |  | Manual Takeoff |  | Moderate
Tips |  |  | PANO
Warnings |  |  | P-GPS
Avg GPS |  |  | [NAME]
Min GPS |  |  | Starting Motors
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Min Battery Live
Spreadsheet: 552796d1513780377-logging-and-creating-a-string-for-a-data-set-sample-w-examples
Sheet: Sheet1

[NAME] | location | staff# | Date/Time | Day |  |  | EXAMPLE
DRV0148675 | LOCN006538 | 06221 | 2017-05-10 07:39:00 | Wednesday |  |  | DRV0148675 | 06221 | 06615 | 07646 | 07395 | 08478 | 06099 | 08429
DRV0148675 | LOCN006538 | 06615 | 2017-05-10 07:39:00 | Wednesday
DRV0148675 | LOCN006538 | 07646 | 2017-05-10 07:39:00 | Wednesday
DRV0148675 | LOCN006538 | 07395 | 2017-05-10 07:39:00 | Wednesday |  |  | OR
DRV0148675 | LOCN006538 | 08478 | 2017-05-10 07:39:00 | Wednesday |  |  | EXAMPLE 2
DRV0148675 | LOCN006538 | 06099 | 2017-05-10 07:39:00 | Wednesday |  |  | DRV0148675 | 06221, 06615, 07646,07395,08478,06099,08429
DRV0148675 | LOCN006538 | 08429 | 2017-05-10 07:39:00 | Wednesday
DRV0148679 | LOCN005830 | 07829 | 2017-05-15 12:55:00 | Monday
DRV0148679 | LOCN005830 | 07038 | 2017-05-15 12:55:00 | Monday
DRV0148679 | LOCN005830 | 04107 | 2017-05-15 12:55:00 | Monday
DRV0148679 | LOCN005830 | 07211 | 2017-05-15 12:55:00 | Monday
DRV0148679 | LOCN005830 | 08525 | 2017-05-15 12:55:00 | Monday
DRV0148681 | LOCN000562 | 06876 | 2017-06-13 11:46:00 | Tuesday
DRV0148681 | LOCN000562 | 08513 | 2017-06-13 11:46:00 | Tuesday
DRV0148681 | LOCN000562 | 08322 | 2017-06-13 11:46:00 | Tuesday
DRV0148682 | LOCN001667 | 06615 | 2017-06-24 07:06:00 | Saturday
DRV0148682 | LOCN001667 | 08196 | 2017-06-24 07:06:00 | Saturday
DRV0148682 | LOCN001667 | 08384 | 2017-06-24 07:06:00 | Saturday
DRV0148684 | LOCN006700 | 08211 | 2017-06-30 05:26:00 | Friday
DRV0148684 | LOCN006700 | 06876 | 2017-06-30 05:26:00 | Friday
DRV0148685 | LOCN005655 | 06482 | 2017-01-06 06:43:00 | Friday
DRV0148685 | LOCN005655 | 06099 | 2017-01-06 06:43:00 | Friday
DRV0148685 | LOCN005655 | 08211 | 2017-01-06 06:43:00 | Friday
DRV0148685 | LOCN005655 | 07826 | 2017-01-06 06:43:00 | Friday
DRV0148685 | LOCN005655 | 05704 | 2017-01-06 06:43:00 | Friday
DRV0148685 | LOCN005655 | 05414 | 2017-01-06 06:43:00 | Friday
Spreadsheet: 61539d1262435073-totaling-down-time-of-phone-by-use-of-agent-log-in-off-timings-book2
Sheet: Sheet1

Phone 1 | Logged On | 07:09:00 | 19:09:00 | 07:06:00 | 19:09:00 | 07:08:00 | 19:12:00 | 07:16:00 | 18:59:00 | 07:05:00 | 19:08:00 | 07:02:00 | 19:06:00 | 06:59:00
 | Logged Off | 19:00:00 | 07:03:00 | 19:01:00 | 07:00:00 | 19:02:00 | 07:06:00 | 18:50:00 | 07:02:00 | 18:49:00 | 06:51:00 | 12:50:00 | 06:46:00 | 18:57:00
Phone 2 | Logged On | 07:27:00 | 20:07:00 | 07:08:00 | 19:10:00 | 07:37:00 | 19:05:00 | 07:05:00 | 19:10:00 | 07:23:00 | 19:08:00 | 07:09:00 | 19:01:00 | 06:57:00
 | Logged Off | 18:53:00 | 07:04:00 | 19:01:00 | 07:01:00 | 18:57:00 | 07:00:00 | 18:53:00 | 06:55:00 | 18:46:00 | 07:00:00 | 18:57:00 | 06:53:00 | 18:50:00
Spreadsheet: 681005d1591294997-complicated-formula-needed-to-find-value-in-a-range-with-multiple-variables-2020-06-04-oeldere-tml2424-ot-680985d1591287048-complicated-formula-needed-to-find-value-in-
Sheet: What I want results to be

 |  |  |  |  |  | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  | Event Guests | 10 | 15 | 15 | 10 | 45 | 45 | 45
 |  |  |  |  | Total Guests | 80 | 86 | 85 | 86 | 86 | 86 | 86
 |  |  |  |  | Occupied rooms | 80 | 80 | 80 | 80 | 80 | 80 | 80
Business name 1
Department | Status | Unit of Measure | Shift | Code | Position | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
 | Active | n/a | n/a | 10a | Night Auditor
 | Active | Event Guests | Shift 1 | 12b | Planner | 8 | 16 | 16 | 8 | 24 | 24 | 24
 | Active | Event Guests | Shift 2 | 12b | Planner | 8 | 16 | 16 | 8 | 24 | 24 | 24
 | Active | Event Guests | Shift 3 | 12b | Planner | 8 | 8 | 8 | 8 | 16 | 16 | 16
 | Inactive | n/a | n/a | 61a | Manager
 | Active | Total Guests | Shift 1 | 51a | Receptionist | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | Active | Total Guests | Shift 2 | 51a | Receptionist | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | Active | Total Guests | Shift 3 | 51a | Receptionist | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | Inactive | n/a | n/a | 31a | Engineer
 | Active | Occupied rooms | n/a | 40a | [NAME] | 24 | 24 | 24 | 24 | 24 | 24 | 24
 | Active | Occupied rooms | n/a | 40b | Server | 34.29 | 34.29 | 34.29 | 34.29 | 34.29 | 34.29 | 34.29
 |  |  |  |  |  | 48
Som van Hours per Shift
Department | Status | Unit of Measure | Shift | Job Code | Position | Totaal
Dept Name | Active | Event Guests | Shift 1 | 12b | Planner | 32
Dept Name | Active | Event Guests | Shift 2 | 12b | Planner | 32
Dept Name | Active | Event Guests | Shift 3 | 12b | Planner | 24
Dept Name | Active | n/a | n/a | 10a | Night Auditor
Dept Name | Active | Occupied rooms | n/a | 40a | [NAME] | 48
Dept Name | Active | Occupied rooms | n/a | 40b | Server | 48
Dept Name | Active | Total Guests | Shift 1 | 51a | Receptionist | 16
Dept Name | Active | Total Guests | Shift 2 | 51a | Receptionist | 16
Dept Name | Active | Total Guests | Shift 3 | 51a | Receptionist | 16
Dept Name | Inactive | n/a | n/a | 31a | Engineer
Dept Name | Inactive | n/a | n/a | 61a | Manager
Eindtotaal |  |  |  |  |  | 232
Spreadsheet: 43236d1241802265-vlookup-background-colour-change-of-10-results-allpostcodedata1
Sheet: FP Advisors MAP FINAL

 |  |  |  |  | MAP
 |  |  |  |  |  |  |  | [NAME] [NAME]
 |  |  |  |  |  | [NAME] [NAME]
 |  |  |  |  |  | [NAME] [NAME] | [NAME] [NAME]
 |  |  |  |  |  | [NAME] [NAME] | [NAME] [NAME]
 |  |  |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  |  |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 | [NAME] [NAME] |  |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  |  | [NAME] [NAME] |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  |  |  |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  |  |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME]
 |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] | [NAME] [NAME] | [NAME] | [NAME]
 | [NAME] [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] | [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] | [NAME]
 |  | [NAME] [NAME] | [NAME] [NAME] | [NAME] | [NAME] | [NAME] [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] [NAME] | [NAME] [NAME] | [NAME] | [NAME] | [NAME]
 |  | [NAME] [NAME] | [NAME] | [NAME] | [NAME] | LONDON
 |  | [NAME] [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] [NAME] | [NAME] [NAME] |  |  |  | [NAME] | [NAME]
 | [NAME] [NAME]
 |  |  | [NAME] [NAME] |  | [NAME] [NAME]
 | LONDON
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 702491d1604386438-index-match-using-multiple-worksheets-where-index-is-aplhanumeric-index-match-multi-worksheet-problem
Sheet: Employees & Contractors

Index | Employee ID Number | Employee Surname | Employee Given Name | Employment Status | ABN or TFN | Tax Threshold | Hourly Pay Rate | Tax Table
1 | AF1000 | Able | [NAME] | Adult - Part-time | 111111111 | Yes | 18.24
2 | AP1000 | Bravo | Indigo | Adult - Part-time | 222222222 | No | 21.16
3 | J1000 | Tango | Victor | Junior | 333333333 | Yes | 14.22
4 | C1000 | Lima | [NAME] | Contractor |  | No | 35
 | Index value to find which data related to th ID number flows to the Wages & Salaries worksheet
 | Data related to ID number that flows to the relative row in Wages & Salaries worksheet
Spreadsheet: 202363d1356528913-moving-data-from-single-to-multiple-columns-and-merging-final
Sheet: Final

ID | Date | FileName | [NAME]
1 | 2012-01-01 00:00:00 | one.txt | This is one
 |  |  | This is also one
6 | 2012-02-15 00:00:00 | test.txt | This is six
3 | 2012-01-08 00:00:00 | random.rtf | This is three
4 | 2012-12-12 00:00:00 |  | This is four
 |  |  | This is also four
 |  |  | And this is four as well
2 | 2012-12-13 00:00:00 | two.txt | This is two
8 | 2011-10-10 00:00:00 |  | This is eight
5 | 2010-01-01 00:00:00 | three.txt | This is five
Spreadsheet: 820360d1678060116-how-to-tweak-formula-to-change-calendar-to-include-date-range-book_251717-4
Sheet: Get Date Event List

Event Date List | Event Name | Event Date List Code
2023-09-28 00:00:00 | Event 1 ya | 45197
2023-09-29 00:00:00 | Event 1 ya | 45198
2023-09-30 00:00:00 | Event 1 ya | 45199
2023-10-01 00:00:00 | Event 1 ya | 45200
2023-10-02 00:00:00 | Event 1 ya | 45201
2023-09-30 00:00:00 | Event 2 tootle | 45199
2023-10-01 00:00:00 | Event 2 tootle | 45200
2023-01-10 00:00:00 | Event 3 babi | 44936
2023-10-02 00:00:00 | Event 4 yernow | 45201
2023-10-03 00:00:00 | Event 4 yernow | 45202
2023-10-04 00:00:00 | Event 4 yernow | 45203
2023-10-02 00:00:00 | Event 5 something | 45201
2023-09-28 00:00:00 | Event 6 now | 45197
Spreadsheet: 06da8013-ac8a-4f2b-a8c2-305c57c02de4
Sheet: Sheet1

UNC-General Administration | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Fixed Asset Record Adjustment Form
Request for adjustment of Fixed Asset Inventory
All description fields on the form will word wrap.  If necessary, resize the row by placing the cursor on the number line at the left of the row and click, hold and drag down.
A.  Change in location of fixed asset:
Fixed Asset Number | Description | From |  | To |  | Effective Date
 |  | Building | Room | Building | Room
B.  Change in description of fixed asset:
Fixed Asset Number | Existing Description | Revised Description |  |  |  | Effective Date
[NAME] of fixed asset from the inventory record due to:
1=Surplus Property, 2=Cannibalization, 3=Missing or [NAME] (Attach justification), 4=No Longer Required or Obsolete, 5=Trade-In, 6=Other: (Specify)
Fixed Asset Number | Description | Location |  |  |  | Reason (From Above)
Certifications
Approved by
 | (Signature of Division Head Releasing Control of the Asset)
Approved by
 | (Signature of Division Head Gaining Control of the Asset)
Approved by
 | (Fixed Asset Officer Signature)
Spreadsheet: 883067d1731556754-return-specific-text-based-on-text-found-in-a-cell-searchpartialtext
Sheet: 工作表1

 | Orange | Apple | [NAME] | Mango |  |  | Item | Value |  |  |  |  | Orange | 1
2024-11-01 00:00:00 |  | 2 | 3 | 4 |  | 2024-11-01 00:00:00 | Orange | 1 |  |  |  | 45598 | Orange | 5
2024-11-02 00:00:00 | 5 | 6 | 7 | 8 |  | 2024-11-01 00:00:00 | Apple | 2 |  |  |  | 45599 | Orange | 9
2024-11-03 00:00:00 | 9 | 10 | 11 | 12 |  | 2024-11-01 00:00:00 | [NAME] | 3 |  |  |  | 45600 | Orange | 13
2024-11-04 00:00:00 | 13 | 14 | 15 | 16 |  | 2024-11-01 00:00:00 | Mango | 4 |  |  |  | 45597 | Apple | 2
 |  |  |  |  |  | 2024-11-02 00:00:00 | Orange | 5 |  |  |  | 45598 | Apple | 6
 |  |  |  |  |  | 2024-11-02 00:00:00 | Apple | 6 |  |  |  | 45599 | Apple | 10
 |  |  |  |  |  | 2024-11-02 00:00:00 | [NAME] | 7 |  |  |  | 45600 | Apple | 14
 |  |  |  |  |  | 2024-11-02 00:00:00 | Mango | 8 |  |  |  | 45597 | [NAME] | 3
 |  |  |  |  |  | 2024-11-03 00:00:00 | Orange | 9 |  |  |  | 45598 | [NAME] | 7
 |  |  |  |  |  | 2024-11-03 00:00:00 | Apple | 10 |  |  |  | 45599 | [NAME] | 11
 |  |  |  |  |  | 2024-11-03 00:00:00 | [NAME] | 11 |  |  |  | 45600 | [NAME] | 15
 |  |  |  |  |  | 2024-11-03 00:00:00 | Mango | 12 |  |  |  | 45597 | Mango | 4
 |  |  |  |  |  | 2024-11-04 00:00:00 | Orange | 13 |  |  |  | 45598 | Mango | 8
 |  |  |  |  |  | 2024-11-04 00:00:00 | Apple | 14 |  |  |  | 45599 | Mango | 12
 |  |  |  |  |  | 2024-11-04 00:00:00 | [NAME] | 15 |  |  |  | 45600 | Mango | 16
 |  |  |  |  |  | 2024-11-04 00:00:00 | Mango | 16
Spreadsheet: 137690d1327325764-can-i-use-if-function-to-seperate-2-sets-of-numbers-in-to-corresponding-cells-splitting-discrepancies-between-con-and-opex-stock
Sheet: Data & Stock Check

Complete Running Stock (Including Capex and Con Stock) | Complete Running Opex (Bought and Con Stock) | Opex Bought Running Stock | Opex Consignment Running Stock | Capex Running Stock | Bought / Con Opening Stock Check | Opex Stock In | Opex Stock Out | Opex Closing Stock Check | [NAME]. | Opening Capex Stock | Incoming Capex Stock | Issued Capex Stock | Closing Capex Stock Check | [NAME]. | (To Update) Max Stock Level | Con / Bought Stock | Opex Discrepancies | Consignment Discrepancies | Capex Discrepancies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indicator 1 - Stock Order Sheet - Supplier | Key 1 - Stock Order Sheet - Supplier | Indicator [NAME] Sheet | Key 2 - Stock Order Sheet -Area
26 | 26 | 3 | 23 | 0 | 22 | 5 | -1 | 0 | -26 | 0 | 0 | 0 | 0 | 0 | 23 | Consignment |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
 | I need R2 and S2 to display any discrepancies, if there are none then a 0, if the stock has Consignment in Q2 then the maximum Con stock holding cannot be higher than the [NAME] stock level, in this case 23.  In the above display the opex discrepancy is -26, therefore -23 would need to be put in S3, and -3 would need to be put into R3.
Complete Running Stock (Including Capex and Con Stock) | Complete Running Opex (Bought and Con Stock) | Opex Bought Running Stock | Opex Consignment Running Stock | Capex Running Stock | Bought / Con Opening Stock Check | Opex Stock In | Opex Stock Out | Opex Closing Stock Check | [NAME]. | Opening Capex Stock | Incoming Capex Stock | Issued Capex Stock | Closing Capex Stock Check | [NAME]. | (To Update) Max Stock Level | Con / Bought Stock | Opex Discrepancies | Consignment Discrepancies | Capex Discrepancies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indicator 1 - Stock Order Sheet - Supplier | Key 1 - Stock Order Sheet - Supplier | Indicator [NAME] Sheet | Key 2 - Stock Order Sheet -Area
17 | 17 | 0 | 17 | 0 | 22 | 5 | -10 | 22 | 5 | 0 | 0 | 0 | 0 | 0 | 23 | Consignment |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
 | I need R2 and S2 to display any discrepancies, if there are none then a 0, if the stock has Consignment in Q2 then the maximum Con stock holding cannot be higher than the [NAME] stock level, in this case 23.  In the above display the opex discrepancy is 5, therefore because the closing stock is 22, then 1 discrepancy would need to be put into S3 making a total stock of 23 consignment stock ([NAME] level), and 4 would need to be put into R3 as positive opex stock.
 |  |  |  |  |  | x234 | y324
Spreadsheet: 1c1eeba4-0c62-4ec4-aefd-dd88b40207a6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
Time (sec) | Temp
0 | 89.73
12.5 | 88.56
25 | 87.84
37.5 | 87.13
50 | 86.38
62.5 | 86.04
75 | 85.37
87.5 | 85.03
100 | 84.64
112.5 | 84.32
125 | 83.67
137.5 | 83.36
150 | 82.73
162.5 | 82.42
175 | 82.12
187.5 | 81.82
200 | 81.45
212.5 | 81.15
225 | 80.86
237.5 | 80.57
250 | 79.98
262.5 | 79.7
275 | 79.42
287.5 | 78.79
300 | 78.58
312.5 | 78.3
325 | 77.96
337.5 | 77.69
350 | 77.42
362.5 | 77.16
375 | 76.89
387.5 | 76.37
400 | 76.11
412.5 | 75.85
425 | 75.34
437.5 | 75.09
450 | 74.77
462.5 | 74.52
475 | 74.27
487.5 | 73.78
500 | 73.54
512.5 | 73.3
525 | 73.06
537.5 | 72.82
550 | 72.58
562.5 | 72.35
575 | 72.05
587.5 | 71.82
600 | 71.58
612.5 | 71.36
625 | 71.13
637.5 | 70.67
650 | 70.45
662.5 | 70.23
675 | 70.01
687.5 | 69.79
700 | 69.35
712.5 | 69.35
725 | 68.85
737.5 | 68.7
750 | 68.42
762.5 | 68.21
775 | 68
787.5 | 67.79
800 | 67.58
812.5 | 67.37
825 | 67.17
837.5 | 66.96
850 | 66.76
862.5 | 66.55
875 | 66.15
887.5 | 65.95
900 | 65.75
912.5 | 65.48
925 | 65.28
937.5 | 65.09
950 | 65.09
962.5 | 64.7
975 | 64.5
987.5 | 64.31
1000 | 64.12
1012.5 | 63.93
1025 | 63.74
1037.5 | 63.55
1050 | 63.36
1062.5 | 63.17
1075 | 62.98
1087.5 | 62.8
1100 | 62.61
1112.5 | 62.36
1125 | 62.25
1137.5 | 61.99
1150 | 61.81
1162.5 | 61.81
1175 | 61.63
1187.5 | 61.45
1200 | 61.27
1212.5 | 60.91
1225 | 60.73