tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875096d1721667519-9-box-help-9-box-talent-assessment-corporate
Sheet: Assessment

Talent Profile
Team Member Name | [NAME] | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10
Current Location | Home Office - STL
Current Role
Time In Role | 3-5 years
Possible Next Role
Readiness for Next Role | Now
Geographic Mobility | Remote Corp Role
Risk of Leaving | High
Impact of Loss | Low
Possible Successor | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name
Evaluation of Performance
Most Recent Performance Rating | Exceeds
Performance
Evaluation of Potential
Achievement Oriented - invested in the success of the themselves, others, and the business
Shows resilience when overcoming challenges and roadblocks | Always
Sets high standards for self and others | Always
Keeps business priorities and success top of mind | Always
Team Oriented - Invested in the growth and development of others
Provides engaging and empowering development opportunities and feedback | Always
Shares business knowledge and best practices to support the team's success | Always
Invests their time and energy into the growth and development of others | Always
Self-Oriented - Invested in the growth and development of themselves
Seeks feedback and input from others and takes action to improve | Always
Uses challenges and risk taking as learning opportunities for improving work strategies | Rarely
Demonstrates career ambition by seeking learning opportunities and developmental moves | Sometimes
Influencing Others - natural ability to inspire and motivate others toward action
Is unafraid to communicate and address issues openly and honestly | Often
Communicates and drives vision by creating a shared mindset | Often
Builds commitment around vision and inspires and energizes the team around it | Always
Agility - acts quickly when solving problems and adapts easily in the moment
Demonstrates flexibility when dealing with complex challenges or new problems | Sometimes
Solves problems quickly using business knowledge and past experiences | Never
Quickly corrects course and recognizes best path forward, even under pressure | Sometimes
Potential
Overall Comments
Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: Nov 2023

Job Number | Customer | Ship To State | Sell Price | Contract (Due) Date | Ready to Ship Date | [NAME] to Ship On Time | Invoice Request Date | LABOR BUDGET $ | TOTAL LABOR $ | LABOR VARIANCE | MATERIAL BUDGET $ | TOTAL MATERIAL $ | MATERIAL [NAME] | TOTAL COST BUDGET | TOTAL ACTUAL COST | [NAME] | ON BUDGET | "As Sold" Budget Margin % | "As Completed" Margin | Difference between Budget / Completed | FREIGHT REIM | Net Profit  (+Gain / -Loss
23-4018 | AEP Comanche Station |  | 58800 | 2023-10-02 00:00:00 | 2023-10-31 00:00:00 |  | 2023-11-06 00:00:00 | 7150 | 10282.25 |  | 27233.56
23-4031 | [NAME] |  | 15990 | 2023-10-05 00:00:00 | 2023-11-02 00:00:00 |  | 2023-11-06 00:00:00 | 6693.5 | 10607.65 |  | 4171
23-4051 | [NAME] |  | 11348 | 2023-11-09 00:00:00 | 2023-11-06 00:00:00 |  | 2023-11-07 00:00:00 | 5676 | 6078.42 |  | 2026
23-4048 | Robinson Service |  | 27250 | 2023-11-07 00:00:00 | 2023-11-06 00:00:00 |  | 2023-11-08 00:00:00 | 4620 | 4075.49 |  | 10011.5
23-4069 | Bachmann - Louisiana |  | 3870 | 2023-11-03 00:00:00 | 2023-11-06 00:00:00 |  | 2023-11-06 00:00:00 | 660 | 300.68 |  | 1196.16 | 2100
23-4062 | [NAME] |  | 2412 | 2023-11-21 00:00:00 | 2023-11-16 00:00:00 |  | 2023-11-16 00:00:00 | 1232 | 1293.42 |  | 322 | 305.49
23-4072 | VOGT POWER |  | 6387 | 2023-11-10 00:00:00 | 2023-11-13 00:00:00 |  | 2023-11-14 00:00:00 | 671 | 528 |  | 2204.8
23-4066 | Element Resources |  | 2365 | 2023-11-17 00:00:00 | 2023-11-16 00:00:00 |  | 2023-11-20 00:00:00 | 412.5 | 548.17 |  | 964 | 885.24
23-4080 | Bachmann - Kissimmee |  | 2350 | 2023-11-20 00:00:00 | 2023-11-20 00:00:00 |  | 2023-11-22 00:00:00 | 440 | 119.17 |  | 716 | 716.8
23-4078 | Bachmann - Washers for KUA |  | 1633.5 | 2023-11-20 00:00:00 | 2023-11-20 00:00:00 |  | 2023-11-22 00:00:00 | 0 |  |  | 907.5 | 726
23-4025 | Bachmann - Al Anbar |  | 114820 | 2023-10-20 00:00:00 | 2023-11-19 00:00:00 |  | 2023-11-22 00:00:00 | 22660 | 25956.35 |  | 52136.76 | 52450.45
23-4061 | Technos |  | 4285 | 2023-11-24 00:00:00 | 2023-11-28 00:00:00 |  | 2023-11-28 00:00:00 | 770 | 625.16 |  | 1713 | 1277.76
23-4042 | Finch Paper LLC |  | 17100 | 2023-12-01 00:00:00 | 2023-11-27 00:00:00 |  | 2023-11-29 00:00:00 | 0 |  |  | 9370 | 9370
23-4082 | VOGT POWER |  | 95400 | 2023-11-27 00:00:00 | 2023-11-29 00:00:00 |  | 2023-11-30 00:00:00 | 0 |  |  | 31800 | 31800
23-4074 | [NAME] |  | 2715 | 2023-12-04 00:00:00 | 2023-11-28 00:00:00 |  | 2023-11-30 00:00:00 | 330 | 134.75 |  | 1169.97
 |  |  |  |  |  | On Time | Shipments | Late |  |  |  |  |  |  | As Sold Margin | As Completed Margin | On Budget
Spreadsheet: 789471d1659107610-multiple-cell-references-if-two-equal-zero-excel-sample-sheet-mb-data
Sheet: 25

 |  |  |  |  |  |  | Date
Dept 1
Ingredient | Volume | Fat | [NAME] | TS
Sweet Cream
Dept 2
Ingredient | Volume | Fat | [NAME] | TS
Sweet Cream
 | 0
 | 0
 | 0 | 0 | 0 | 0
Spreadsheet: 83395d1283373044-scheduling-help-using-the-if-then-function-excel-schedule-template
Sheet: Sheet1

 |  |  |  |  | Today’s Rotation Schedule
 |  |  |  | 2010-09-01 14:29:02
 |  |  |  |  | CRS ON DUTY:  NAME x5129
 | Hour | S-6pm | T-7pm | U-8pm | V-9pm | W-10pm | [NAME] | A-12am | B-1am
 | Show
 | LEX | 8100 | 8200 | 8300 | 9100 | 9200 | 9300 | 6100 | 6200
 | Host
 | Producer
 | Studio
 | LSD
 | Cameras
 | GFX
 | Audio
 | SM
 | [NAME]
 | AD
 | AB Cams
 | CREW | S-6pm | T-7pm | U-8pm | V-9pm | W-10pm | [NAME] | A-12am | B-1am
 | Staff 1
 | Staff 2
 | Staff 3
 | Staff 4
 | Staff 5
 | Staff 6
 | Staff 7
 | Staff 8
 | Staff 9
 | Staff 10
 | Staff 11
 | Staff 12
 | Staff 13
 | Staff 14
 | Staff 15
 | Staff 16
 | Staff 17
 | Staff 18
 | Staff 19
 | Staff 20
 | INFO
Spreadsheet: 64895d1265726318-generating-a-2nd-list-based-off-a-1st-list-help
Sheet: Associate Graph

 | Please select the associate name from list below: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Manager:
 | Associate: |  | Doe, Jane 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Associate ID: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Jan 09 | Feb 09 | Mar 09 | Apr 09 | May 09 | Jun 09 | Jul 09 | Aug 09 | Sep 09 | Oct 09 | Nov 09 | Dec 09 | Average YTD: |  |  | [NAME]
 | P-Score: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Q-Score: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Productive Hours: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Occurrence: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Eligible: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 167448d1342001097-excel-2007-how-2-create-an-array-picking-up-values-from-another-one-and-limiting-their-repeatability-rating
Sheet: Sheet3

 |  |  |  |  | Loc0 | W | P | Rav | ΔLoc | [NAME] | Perf
 |  | 1. | [NAME] | tak | 1200 | 1 | 4 | 1200 |  |  |  |  |  |  | tak
 |  | 2. | [NAME] | tak | 1200 | 3 | 4 | 1200 |  |  |  |  |  |  | nie
 |  | 3. | [NAME] | tak | 1200 | 0 | 3 | 1200
 |  | 4. | [NAME] | tak | 1200 | 4 | 4 | 1200
 |  | 5. | Wiktor Harezlak | tak | 1200 | 0 | 3 | 1200
 |  | 6. | [NAME] | tak | 1200 | 1 | 3 | 1200
 |  | 7. | [NAME] | tak | 1200 | 3 | 4 | 1200
 |  | 8. | [NAME] | tak | 1200 | 2 | 4 | 1200
 |  | 9. | [NAME] | tak | 1200 | 2 | 3 | 1200
 |  | 1. | [NAME] | tak | 1250 | 3 | 4 | 1206
 |  | 2. | [NAME] | tak | 1225 | 4 | 4 | 1213
 |  | 3. | [NAME] | tak | 1225 | 1 | 4 | 1191
 |  | 4. | [NAME] | tak | 1200 | 2 | 4 | 1209
 |  | 5. | [NAME] | tak | 1200 | 1 | 3 | 1196
 |  | 6. | [NAME] | tak | 1200 | 0 | 3 | 1217
 |  | 7. | Dzeki | tak | 1200 | 2 | 4 | 1206
 |  | 8. | Ampher | tak | 1200 | 3 | 4 | 1216
 |  | 9. | [NAME] | tak | 1187 | 2 | 4 | 1206
 |  | 10. | [NAME] | tak | 1175 | 1 | 4 | 1206
Spreadsheet: 142960d1330103727-excel-2007-how-to-apply-multiple-calculations-depending-on-text-from-drop-down-list-work-expense-report
Sheet: Sheet1

Work Expense Report
Date | Description | State | Mileage | Meals | Hotel | State Tax | Federal Tax | Total
2012-02-22 00:00:00 | Applebees | ND |  | 55.03
 | [NAME]' Donuts | MN |  | 10.07
2012-02-24 00:00:00 | TGI Friday's | SD |  | 65
Spreadsheet: 53361d1253240726-calendar-and-buttons-3m-brookings
Sheet: A-3488

Barsol A-3488
332 Lbs./Drum
[NAME]
Lot # | CB042809
PO | USMMMFR443
Rel. | 13 | 2009-06-01 00:00:00
Barsol A-3488
332 Lbs./Drum
[NAME]
Lot # | CB042809
PO | USMMMFR443
Rel. | 13 | 2009-06-01 00:00:00
Spreadsheet: 859262d1707722042-how-to-populate-daily-sales-dynamically-based-on-the-week-ending-dates-and-daily-breakdo-daily-splits
Sheet: Sheet1

 | 2024-08-10 00:00:00 | 2024-08-17 00:00:00 | 2024-08-24 00:00:00 | 2024-08-31 00:00:00 | 2024-09-07 00:00:00 | 2024-09-14 00:00:00 | 2024-09-21 00:00:00
Sales Volume | 7000 | 5000 | 9000 | 10000 | 5000 | 4000 | 2000
Days | 5 | 5 | 5 | 5 | 6 | 6 | 6
Days | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
5 | 0.214 | 0.204 | 0.194 | 0.194 | 0.194 | 0 | 0 | 1
6 | 0.1833333333333333 | 0.1733333333333333 | 0.1633333333333334 | 0.1633333333333334 | 0.1633333333333334 | 0.1533333333333333 | 0 | 1
Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Date | 2024-08-04 00:00:00 | 2024-08-05 00:00:00 | 2024-08-06 00:00:00 | 2024-08-07 00:00:00 | 2024-08-08 00:00:00 | 2024-08-09 00:00:00 | 2024-08-10 00:00:00 | 2024-08-11 00:00:00 | 2024-08-12 00:00:00 | 2024-08-13 00:00:00 | 2024-08-14 00:00:00 | 2024-08-15 00:00:00 | 2024-08-16 00:00:00 | 2024-08-17 00:00:00 | 2024-08-18 00:00:00 | 2024-08-19 00:00:00 | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 | 2024-08-24 00:00:00 | 2024-08-25 00:00:00 | 2024-08-26 00:00:00 | 2024-08-27 00:00:00 | 2024-08-28 00:00:00 | 2024-08-29 00:00:00 | 2024-08-30 00:00:00 | 2024-08-31 00:00:00
Volume
Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Date | 2024-09-01 00:00:00 | 2024-09-02 00:00:00 | 2024-09-03 00:00:00 | 2024-09-04 00:00:00 | 2024-09-05 00:00:00 | 2024-09-06 00:00:00 | 2024-09-07 00:00:00 | 2024-09-08 00:00:00 | 2024-09-09 00:00:00 | 2024-09-10 00:00:00 | 2024-09-11 00:00:00 | 2024-09-12 00:00:00 | 2024-09-13 00:00:00 | 2024-09-14 00:00:00 | 2024-09-15 00:00:00 | 2024-09-16 00:00:00 | 2024-09-17 00:00:00 | 2024-09-18 00:00:00 | 2024-09-19 00:00:00 | 2024-09-20 00:00:00 | 2024-09-21 00:00:00
Volume
Spreadsheet: 271692d1382022660-drawing-information-from-multiple-worksheets-to-generate-a-summary-report-sample-data
Sheet: Name1

Name: | Name1
Rec | Input Date | Workstream | Projects | Internal Requests | External Requests | CPCMEC Tasking | Management | Tasks | Priority | Comments | Task Progress (%) | Upcoming DD | Concluded
1 | 2013-10-01 00:00:00 | Projects | Project1 |  |  |  |  | Review Paper | Low |  | 100 | 2013-10-31 00:00:00 | 2013-10-10 00:00:00
2 | 2013-10-02 00:00:00 | Internal Request |  | Stats |  |  |  | Generate spreadsheet | Medium |  | 50 | 2013-10-31 00:00:00
3 | 2013-10-10 00:00:00 | Projects | Project3 |  |  |  |  | Review Paper | Low |  | 100 | 2013-10-31 00:00:00 | 2013-10-11 00:00:00
Spreadsheet: 91581d1291285678-finding-the-nearest-day-example
Sheet: Sheet1

 |  | Date | % | USD |  |  |  | In case if I guess the date
 |  | 2004-12-31 00:00:00 | 0 | 10000 |  |  |  | Date | 2005-01-21 00:00:00
 |  | 2005-01-11 00:00:00 | -0.1907643495443923 | 9980.92 |  |  |  | Match Found
 |  | 2005-01-12 00:00:00 | -0.2163070775248022 | 9959.33
 |  | 2005-01-13 00:00:00 | -0.05759741221834647 | 9953.59 |  |  |  | In case if didn't guess the date
 |  | 2005-01-14 00:00:00 | -0.6845402127886535 | 9885.45 |  |  |  | Date | 2005-01-22 00:00:00
 |  | 2005-01-17 00:00:00 | 0.02327628648244318 | 9887.75 |  |  |  | Match Found
 |  | 2005-01-18 00:00:00 | 0 | 9887.75
 |  | 2005-01-19 00:00:00 | 0 | 9887.75
 |  | 2005-01-20 00:00:00 | 0 | 9887.75
22.01.05 was a day off, so I skipped it |  | 2005-01-21 00:00:00 | 0.0173021973314702 | 9889.46
 |  | 2005-01-24 00:00:00 | 0.5717189404734979 | 9946
 |  | 2005-01-25 00:00:00 | 0.5093427465617362 | 9996.66
 |  | 2005-01-26 00:00:00 | -0.6080900220961527 | 9935.87
 |  | 2005-01-27 00:00:00 | 0.3925125017307796 | 9974.87
 |  | 2005-01-28 00:00:00 | 2.022920487842272 | 10176.65
 |  | 2005-01-31 00:00:00 | 0.3792361033282399 | 10215.24
 |  | 2005-02-01 00:00:00 | 0.6445022136941869 | 10281.08
 |  | 2005-02-02 00:00:00 | 0.3232177901414168 | 10314.31
 |  | 2005-02-03 00:00:00 | -0.01683922427868634 | 10312.57
 |  | 2005-02-04 00:00:00 | -0.1248347548266304 | 10299.7
 |  | 2005-02-07 00:00:00 | -0.1537037470325298 | 10283.87
 |  | 2005-02-08 00:00:00 | 0.1197716583593023 | 10296.19
 |  | 2005-02-09 00:00:00 | -0.305182393387804 | 10264.77
 |  | 2005-02-10 00:00:00 | 0.01257757522679093 | 10266.06
 |  | 2005-02-11 00:00:00 | 0.2226176422860382 | 10288.91
 |  | 2005-02-14 00:00:00 | 0.3273854782097629 | 10322.59
 |  | 2005-02-15 00:00:00 | -0.1025001360954625 | 10312.01
 |  | 2005-02-16 00:00:00 | -0.2603362714268087 | 10285.16
 |  | 2005-02-17 00:00:00 | 0.4439857764125588 | 10330.82
 |  | 2005-02-18 00:00:00 | -0.1733627819360595 | 10312.91
 |  | 2005-02-21 00:00:00 | 0.751607713375213 | 10390.42
 |  | 2005-02-22 00:00:00 | -0.2308877365319484 | 10366.43
 |  | 2005-02-24 00:00:00 | 2.831007372904448 | 10659.9
 |  | 2005-02-25 00:00:00 | 0.6302815667938777 | 10727.09
 |  | 2005-02-28 00:00:00 | 2.062215521454047 | 10948.31
Spreadsheet: 33fa835c-f134-43bc-acb6-59e391f41d6d
Sheet: Sheet1

Table 10--Acreage, yield, and production estimates, 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 380 |  | 378 |  | 952 |  | 750
Florida | 108 |  | 107 |  | 897 |  | 200
Georgia | 1290 |  | 1285 |  | 1027 |  | 2750
North Carolina | 585 |  | 580 |  | 993 |  | 1200
South Carolina | 299 |  | 298 |  | 918 |  | 570
Virginia | 86 |  | 85 |  | 1129 |  | 200
Southeast | 2748 |  | 2733 |  | 996 |  | 5670
Arkansas | 595 |  | 585 |  | 1083 |  | 1320
Louisiana | 230 |  | 225 |  | 1003 |  | 470
Mississippi | 475 |  | 470 |  | 970 |  | 950
Missouri | 350 |  | 330 |  | 1033 |  | 710
Tennessee | 380 |  | 375 |  | 934 |  | 730
Delta | 2030 |  | 1985 |  | 1011 |  | 4180
Kansas | 56 |  | 54 |  | 578 |  | 65
Oklahoma | 305 |  | 140 |  | 480 |  | 140
Texas | 6550 |  | 3900 |  | 615 |  | 5000
Southwest | 6911 |  | 4094 |  | 610 |  | 5205
Arizona | 200 |  | 197 |  | 1511 |  | 620
California | 142 |  | 141 |  | 1651 |  | 485
New Mexico | 46 |  | 40 |  | 1080 |  | 90
West | 388 |  | 378 |  | 1517 |  | 1195
Total Upland | 12077 |  | 9190 |  | 849 |  | 16250
Pima:
Arizona | 3 |  | 3 |  | 1152 |  | 7
California | 225 |  | 224 |  | 1575 |  | 735
New Mexico | 2 |  | 2 |  | 981 |  | 5
Texas | 8 |  | 8 |  | 832 |  | 13
Total Pima | 238 |  | 237 |  | 1540 |  | 760
Total all | 12315 |  | 9427 |  | 866 |  | 17010
Source:  USDA, January 2013 Crop Production report.
Last update: 03/12/13.
Spreadsheet: 166156d1341489327-what-is-best-way-to-extract-this-data-book1
Sheet: Sheet1

 | 77 | 12:05:16 | 12:05:00
 | 15 | 12:05:17 | 12:05:00
 | 53 | 12:05:17 | 12:05:00
 | 53 | 12:05:17 | 12:05:00
 | 58 | 12:05:18 | 12:05:00
 | 56 | 12:05:18 | 12:05:00
 | 54 | 12:05:19 | 12:05:00
 | 45 | 12:05:19 | 12:05:00
 | 41 | 12:06:00 | 12:06:00
 | 14 | 12:06:20 | 12:06:00
 | 43 | 12:07:22 | 12:07:00
 | 46 | 12:07:24 | 12:07:00
 | 46 | 12:07:27 | 12:07:00
 | 49 | 12:07:52 | 12:07:00
 | 44 | 12:07:52 | 12:07:00
 | 44 | 12:07:55 | 12:07:00
 | 39 | 12:08:01 | 12:08:00
 | 36 | 12:08:01 | 12:08:00
 | 39 | 12:08:06 | 12:08:00
 | 41 | 12:08:22 | 12:08:00
 | 14 | 12:08:24 | 12:08:00
 | 37 | 12:08:54 | 12:08:00
 | 37 | 12:08:55 | 12:08:00
 | 14 | 12:08:59 | 12:08:00
 | 43 | 12:09:01 | 12:09:00
 | 15 | 12:09:11 | 12:09:00
 | 46 | 12:09:13 | 12:09:00
 | 46 | 12:09:15 | 12:09:00
 | 43 | 12:09:17 | 12:09:00
 | 44 | 12:09:22 | 12:09:00
 | 51 | 12:09:22 | 12:09:00
 | 54 | 12:09:22 | 12:09:00
 | 57 | 12:09:25 | 12:09:00
 | 63 | 12:09:26 | 12:09:00
 | 61 | 12:09:37 | 12:09:00
 | 53 | 12:09:37 | 12:09:00
 | 15 | 12:09:40 | 12:09:00
 | 55 | 12:09:41 | 12:09:00
 | 55 | 12:09:41 | 12:09:00
 | 57 | 12:09:52 | 12:09:00
 | 61 | 12:09:55 | 12:09:00
 | 66 | 12:09:56 | 12:09:00
 |  |  | 12:10:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
 |  |  | 00:01:00
Spreadsheet: 692353d1598288908-powerquery-or-formulas-test-data-tables
Sheet: Sheet1

Current Data set
Account Name | Product Code | Product Description | Quantity | Order Ship Date | Source | Month |  | Delta
Autoglass | AI10170 | Product 1 | 6 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10180 | Product 3 | 1 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10152 | Product 4 | 1 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10116 | Product 2 | 6 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10180 | Product 3 | 3 | 2020-08-18 00:00:00 | Order/Invoiced
Autoglass | AI10152 | Product 4 | 4 | 2020-08-18 00:00:00 | Order/Invoiced
Autoglass | AI10170 | Product 1 | 1 | 2020-08-18 00:00:00 | Order/Invoiced
Autoglass | AI10116 | Product 2 | 2 | 2020-08-18 00:00:00 | Order/Invoiced
What I think I need to do in order to achieve the delta column
Solution I Require
Account Name | Product Code | Product Description | Forecast | Order/Invoiced | Month | Delta
Autoglass | AI10170 | Product 1 | 6 | 1 | Aug-20
Autoglass | AI10180 | Product 3 | 1 | 2 | Aug-20
Autoglass | AI10152 | Product 4 | 1 | 3 | Aug-20
Autoglass | AI10116 | Product 2 | 6 | 4 | Aug-20
Account Name | Product Code | Product Description | Forecast | Order/Invoiced | Month | Delta
Autoglass | AI10170 | Product 1 | 6 | 1 | Aug-20 | -5
Autoglass | AI10116 | Product 2 | 6 | 2 | Aug-20 | -4
Autoglass | AI10180 | Product 3 | 1 | 3 | Aug-20 | 2
Autoglass | AI10152 | Product 4 | 1 | 4 | Aug-20 | 3
Spreadsheet: 739015d1625443505-count-distinct-multiple-criteria-count-distinct-mulitple
Sheet: Sheet1

Student ID | Subject | Year Level |  |  | OUTPUT | 7 | 8 | 9
704 | Math | 7 |  |  | Math
701 | Math | 7 |  |  | Humanities
705 | Math | 7 |  |  | Health |  |  |  | Crosstab contains the distinct count of Student ID
805 | Math | 8 |  |  | Languages
710 | Math | 7 |  |  | Literacy
803 | Math | 8
701 | Math | 7
807 | Math | 8
704 | Math | 7
807 | Math | 8
810 | Math | 8
801 | Math | 8
908 | Math | 9
902 | Math | 9
705 | Math | 7
801 | Math | 8
809 | Math | 8
901 | Math | 9
902 | Math | 9
710 | Humanities | 7
702 | Humanities | 7
809 | Humanities | 8
808 | Humanities | 8
808 | Humanities | 8
904 | Humanities | 9
709 | Humanities | 7
701 | Humanities | 7
808 | Health | 8
806 | Health | 8
807 | Health | 8
909 | Health | 9
706 | Health | 7
801 | Health | 8
810 | Health | 8
808 | Health | 8
904 | Health | 9
704 | Languages | 7
810 | Languages | 8
804 | Languages | 8
809 | Languages | 8
905 | Languages | 9
707 | Languages | 7
804 | Languages | 8
810 | Languages | 8
807 | Languages | 8
908 | Literacy | 9
707 | Literacy | 7
805 | Literacy | 8
808 | Literacy | 8
806 | Literacy | 8
903 | Literacy | 9
702 | Literacy | 7
810 | Literacy | 8
807 | Literacy | 8
804 | Literacy | 8
908 | Literacy | 9
807 | Humanities | 8
909 | Humanities | 9
706 | Humanities | 7
708 | Humanities | 7
806 | Health | 8
804 | Health | 8
803 | Health | 8
907 | Health | 9
704 | Health | 7
806 | Health | 8
802 | Health | 8
806 | Health | 8
904 | Health | 9
703 | Languages | 7
804 | Languages | 8
809 | Languages | 8
802 | Languages | 8
905 | Languages | 9
703 | Languages | 7
802 | Languages | 8
809 | Languages | 8
807 | Languages | 8
903 | Literacy | 9
705 | Literacy | 7
809 | Literacy | 8
805 | Literacy | 8
Spreadsheet: 117002d1312386375-conditional-formatting-cf_example
Sheet: 1

METAL CONTROL DATA SHEET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non Conformance Comments
CRITICAL CONTROL FEATURES
Part No |  | 09.5254.00 |  |  |  |  |  |  | Date |  |  |  |  | [NAME]
Customer |  |  |  |  |  |  |  |  | Other
Grade |  |  |  |  |  |  | CEL |  |  | Temp |  |  |  |  | Core Date
AM No. |  |  |  |  |  |  | Cup Level |  |  | Gross Weight |  |  |  |  | Inoculation
Analysis |  |  |  |  |  |  |  |  |  | [NAME].
Moulding Rate if Moly Job (from TDS 19) |  |  |  |  |  |  |  |  | Visual Dump Probe Check
All above control features to be taken from Ops Card screen other than moulding rate |  |  |  |  |  |  |  |  | Start of Shift |  |  |  |  | End of Shift
 |  |  |  |  | MSI Rate | Wire Rate | MSI+Wire Rate |  |  |  |  | Ti | Sn | Si | Ni
 |  |  |  |  |  |  |  |  |  |  | Ladle Alloy Additions
Time | ACEL | Pour Temp |  |  | Wedge | [NAME] | Pour Time | MSI Rate | Coin Ref | T | Cu | Cr | Mo | Ni | Gra |  |  | [NAME] |  | Coin No | Time | ACEL | C | Si | Mn | P | S | Cr | Ni | Mo | Cu | Al | Ti | Pb | V | As | Sn | Zr | Bi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ladle/Autopour Additions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coin No | Innoculation/Alloy |  |  |  |  |  |  | Coin No |  |  | Innoculation/Alloy
 |  |  |  |  |  |  |  | Totals
1) '[NAME] column data to be taken from [NAME]/c screen every 15 minutes.
2) Metal testers to sign for Dump Probe Setting checks at start and end of each shift in spaces provided at top of columns.
FORM F78 SIDE 1 OF 2 ISSUE 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORM F78 SIDE 2 OF 2 ISSUE 7