tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846218d1697495292-combine-3-data-sets-with-different-number-of-items-test
Sheet: Ark1

Set 1 |  |  | Set 2 |  |  | Set 3 |  |  | Combined
Item | Value |  | Item | Value |  | Item | Value |  | Item | Set 1 | Set 2 | Set 3
A | 2 |  | B | 43 |  | B | 66 |  | A | 2 | 1 | 8
B | 4 |  | A | 1 |  | A | 8 |  | B | 4 | 43 | 66
C | 23 |  | D | 23 |  | C | 77 |  | C | 23 | 0 | 77
D | 13 |  | E | 4 |  | D | 11 |  | D | 13 | 23 | 11
E | 4 |  | F | 23 |  | P | 5 |  | E | 4 | 4 | 0
 |  |  | G | 3 |  |  |  |  | F | 0 | 23 | 0
 |  |  |  |  |  |  |  |  | G | 0 | 3 | 0
 |  |  |  |  |  |  |  |  | P | 0 | 0 | 5
Spreadsheet: 745563d1629999668-if-function-multiple-conditions-excell-forum
Sheet: Sheet1

Emp ID | Category | Annual Salary | Length of Service | Base Annual Leave
5554 | Hourly | 43680 | 3 |  |  | condition
5337 | Salary | 72100.08 | 7 |  |  | Length of Service | Base Annual Leave
4066 | Hourly | 49400 | 7 |  |  | 0 – 1 year | 40 Hours*
2625 | Salary | 98308.08 | 16 |  |  | More than 1 year | 80 Hours*
5410 | Hourly | 53788.8 | 5 |  |  | More than 2 year | 120 Hours*
5519 | Hourly | 57824 | 4 |  |  | More than 5 year | 160 Hours*
7089 | Hourly | 76544 | 24 |  |  | More than 10 year | 200 Hours*
1463 | Hourly | 68224 | 32
5755 | Salary | 75000 | 1
5669 | Hourly | 46280 | 2
Spreadsheet: 128169d1320836090-excel-2007-total-number-of-people-on-break-sushil-excel
Sheet: Sheet1

 |  |  |  |  | Total Number on Break =
 |  |  |  | Who is on Break? | Name | out time | in time | Total | out time | in time | Total | Break Total
 |  |  |  |  | A | 10:00:00
 |  |  |  |  | B | 10:00:00 | 10:20:00 |  | 11:00:00
 |  |  |  |  | C | 10:00:00 | 10:25:00 |  | 11:00:00 | 12:10:00
 |  |  |  |  | D
 |  |  |  |  | E | 10:00:00
Spreadsheet: 856094d1705480630-sumproduct-formula-giving-error-my-workbook-copy
Sheet: Testing 123

Date | STD | DLX | BVL | WVL
2023-01-01 00:00:00 | 695 | 776 | 996 | 1163
2023-01-02 00:00:00 | 695 | 776 | 996 | 1163
2023-01-03 00:00:00 | 695 | 776 | 996 | 1163
2023-01-04 00:00:00 | 513 | 590 | 800 | 959 |  | Room category | BVL
2023-01-05 00:00:00 | 513 | 590 | 800 | 959 |  | checking Date | 2023-01-06 00:00:00
2023-01-06 00:00:00 | 1317 | 1543 | 1611 | 1677 |  | Check out Date | 2023-01-08 00:00:00
2023-01-07 00:00:00 | 1317 | 1543 | 1611 | 1677
2023-01-08 00:00:00 | 1317 | 1543 | 1611 | 1677 |  | Total Rate
2023-01-09 00:00:00 | 1105 | 1322 | 1385 | 1449
2023-01-10 00:00:00 | 1105 | 1322 | 1385 | 1449
Spreadsheet: 198783d1354895114-need-help-with-a-sum-receivable
Sheet: RECEIVABLE

 | RECEIVABLE
 | TOTAL RECEIVABLE:
 |  |  |  | TOTAL TODAY:
 |  |  |  | TOTAL THIS WEEK:
 | INV # | INV DATE | Payment Due | CUSTOMER NAME | AMOUNT DUE | Late Fee | Total Paid | INSTALL DATE | COMMENTS
 | 1234 | 2012-12-01 00:00:00 |  | ABC | 1000 |  |  | 2012-12-01 00:00:00
 | 1235 | 2012-12-02 00:00:00 |  | DEF | 2000 |  |  | 2012-12-07 00:00:00
 | 1236 | 2012-12-03 00:00:00 |  | GHI | 3000 |  |  | 2012-12-07 00:00:00
 | 1237 | 2012-12-04 00:00:00 |  | JKL | 4000 |  |  | 2012-12-17 00:00:00
 | 1238 | 2012-12-05 00:00:00 |  | MNO | 5000 |  |  | 2012-12-18 00:00:00
 | 1239 | 2012-12-06 00:00:00 |  | PQR | 6000 |  |  | 2012-12-18 00:00:00
Spreadsheet: e23d24cb-c625-4e69-9e2f-43ac9b93b743
Sheet: Capital fiscal

CAPITAL PROJECT
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title
 | Swope Park Industrial Area Flood Damage Reduction Project MOA
 |  |  |  | X | Not applicable since this is for design
Is this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 |  |  |  |  |  |  |  | FY 11
 | If no, please detail the reasons why this project was not included and need for present funding request.
Please identify source of funds below.
 | Non-City source and amount.
 | Source of Funds:
 | Fiscal Year Funded
 | Amount of Non-City Funds: |  |  | $
 | City source and amount.
 | Acct #: |  |  |  | 3090-808055- B
 | Name of Fund: |  |  |  | PIAC
 | Fiscal Year Funded |  |  |  | FY 11
 | Amount of City Funds: |  |  | $ | 800000
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | NA
 | Estimated lifespan of project in years |  |  | $ | NA
 | Estimated annual operating and maintenance costs |  |  | $ | NA
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | NA
Reference Numbers: (Previously approved legislation): |  |  |  |  | 030886 |  |  | 081208
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 723576d1615796238-creating-a-roster-making-sure-all-staff-rostered-on-are-available-work-test-roster-1-ans
Sheet: Sheet1 (2)

Work Roster
Date | Day |  | Staff1 | Staff2 | Staff3 | Staff4 | Staff5 |  | Project | Sites | Site name | No. Samples | Notes | Vehicle |  | Not Available1 | Not Available2 | Not Available3 | Not Available4 | Not Available5 |  | In Office1 | In Office2 | In Office3 | In Office4 | In Office5
2021-03-23 00:00:00 | [NAME] |  | AB | CD | EF | GH | IJ |  | Project 1 | Site1 | [NAME] | 4 | SDFSFSDFSDF | ABC123 |  | KL | MN | OP | QR | ST |  | UV | WX | YZ
2021-03-24 00:00:00 | Wed |  | GH | IJ | EF |  |  |  | Project 2 | Site2 | JEUWEUEWU | 2 | SDFSFSDFSDF | DEF456 |  | CD | EF | OP | AB |  |  | CD | QR | ST | UV
2021-03-25 00:00:00 | Thurs |  | MN | KL | IJ | QR |  |  | Project 3 | Site3 | ERTIERT8PO | 3 | SDFSFSDFSDF | [NAME] |  | KL | MN |  |  |  |  | UV | WX | YZ | QR | AB
 |  |  | =COUNTIF($Q3:$AA3,D3)=0
Problem
Can someone in the forum please help me create an ongoing roster (blue zone) for staff to go out to sites each day. I would like to add up to five staff for any particular day (Blue zone) but I would like Excel to check if they are not available (yellow zone) or in the office but unable to go out (orange zone).  The number of staff required/available/in office may vary for each day so blanks need to be accounted for.  Generally staff will enter their availability before the roster is made up. It would be great if a message (eg 'Not available' or 'In office') can come up when initials are added to the roster and initials go red to indicate something is wrong if not immediatly fixed.  I have entered dummy data and initials for this example. I am a bit out of practice and would love and appreciate your help.   Thanking you, [NAME]
Summary
Staff in blue zone D3 to H3 appear ok to go to site 1 on 23/3/2021 as no conflicts from Q3 to U3 ('not available grou'p in yellow zone)  and W3 to Z3 ('In Office Group' in orange zone)
Staff in D4 to H4: Here only 3 staff are required to go out on 24/03/2021 but 'EF' in cell F4 conflicts with 'EF' in cell [NAME]
Staff in D5 to H5: Here only 4 staff are required to go out on Thursday 25/03/2021 but 'MN' in cell D5 conflicts with 'MN' in cell R5 and 'QR' in blue cell G5 conflicts with'QR'  orange cell Z5
Spreadsheet: 69085d1269595641-find-weekly-average-based-on-dynamic-date-vlookup-weekly_averages_2
Sheet: Sheet2

 | Registration
 | Visits | Revenue | Transactions | Average Value | Ecommerce Conversion Rate | Per Visit Value
2010-03-09 00:00:00 | 9775 | 386.6 | 10 | 38.66 | 0.00102301790281329 | 0.0395498721227621
2010-03-10 00:00:00 | 11108 | 418.63 | 11 | 38.0572727272727 | 0.000990277277637738 | 0.0376872524306805
2010-03-11 00:00:00 | 11952 | 386.73 | 13 | 29.7484615384615 | 0.00108768406961178 | 0.0323569277108433
2010-03-12 00:00:00 | 12137 | 418.63 | 12 | 34.8858333333333 | 0.00098871220235643 | 0.0344920491060393
2010-03-13 00:00:00 | 13672 | 766.22 | 21 | 36.4866666666666 | 0.00153598595669982 | 0.0560430076067875
2010-03-14 00:00:00 | 12562 | 598.52 | 20 | 29.926 | 0.0015921031682853 | 0.047645279414106
2010-03-15 00:00:00 | 12350 | 508.49 | 15 | 33.8993333333333 | 0.00121457489878542 | 0.0411732793522267
2010-03-16 00:00:00 | 11333 | 328.65 | 9 | 36.5166666666666 | 0.00079414100414718 | 0.0289993823347745
2010-03-17 00:00:00 | 10857 | 485.49 | 15 | 32.366 | 0.00138159712627797 | 0.044716772589113
2010-03-18 00:00:00 | 10802 | 548.5 | 19 | 28.8684210526315 | 0.00175893353082762 | 0.0507776337715237
2010-03-19 00:00:00 | 5498 | 559.49 | 16 | 34.968125 | 0.00291014914514368 | 0.101762459076027
2010-03-20 00:00:00 | 10843 | 337.64 | 11 | 30.6945454545454 | 0.00101447938762335 | 0.0311389836761044
2010-03-21 00:00:00 | 10590 | 377.57 | 8 | 47.19625 | 0.000755429650613786 | 0.0356534466477809
2010-03-22 00:00:00 | 10885 | 507.51 | 17 | 29.8535294117647 | 0.00156178226917776 | 0.0466247129076711
2010-03-23 00:00:00 | 10243 | 88.9 | 5 | 17.78 | 0.00048813824074978 | 0.00867909792053109
2010-03-24 00:00:00 | 10285 | 259.84 | 6 | 43.3066666666666 | 0.000583373845405931 | 0.0252639766650461
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 6

 | January 3 | January 10 | January 17 | January 24 | January 31
Total Interest Rate* | 2208982 | 9612173 | 7743663 | 5801634 | 4555652.6993
SDs and MSPs** | 1367029 | 6801686 | 4974818 | 3630278 | 2674239.9618
Other | 841953 | 2810487 | 2768845 | 2171356 | 1881412.7375
Total Cross-Currency | 69885 | 344390 | 640461 | 238511 | 89119.77724699999
SDs and MSPs | 42920 | 279016 | 586805 | 164386 | 57870.192097
Other | 26965 | 65374 | 53656 | 74125 | 31249.58515
Total Credit | 293395 | 703944 | 650841 | 609430 | 861286.9736599999
SDs and MSPs | 174674 | 411706 | 401095 | 362566 | 520369.54175
Other | 118721 | 292238 | 249745 | 246864 | 340917.43191
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 2572262 | 10660507 | 9034965 | 6649575 | 5506059.450207001
Weekly total, swap dollar volumes by asset class and participant type (value of all trades in millions of USD), all products and tenors, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Dollar Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: daren_farmer__6652__Gas Assets Ops 03-00 Prelim O&M
Sheet: 2933 - Tx Trans & Rate Mgmt

2933 |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSOCHC | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALYSTHC | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
 |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Analysts and Associates
TOT_EMP_EXP | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Technology
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: 165046d1340996369-vlookup-forumula-that-has-more-than-on-set-search-value-sample-ensmith-oeldere-
Sheet: Rep

Rep | Current Performance | Current Points | Revised Points
A | 0.3426 | 15 | 15 | 15
B | 0.2424 | 11 |  | 10
C | 0.3333 | 13 |  | 15
D | 0.32 | 15 |  | 15 | [NAME] will return a value in Column D (Revised Points)
E | 0.3367 | 15 |  | 15
F | 0.2315 | 5 |  |  | When a percentage input is made in [NAME] B3:F3 on [NAME] tab
G | 0.3694 | 15 |  | 15
H | 0.2891 | 10 |  | 12 | The returned value in Column D (Revised Points) will be based on the Metric table on the Metric tab
I | 0.0154 | 8
J | 0.2887 | 12 |  | 12
K | 0.1818 | 10
L | 0.0833 | 2
M | 0.5784 | 15 |  | 15
N | 0.0952 | 5
O | 0 | 0
P | 0.1379 | 0
Q | 0.2815 | 12 |  | 12
R | 0 | 0
S | 0.1667 | 2
T | 0 | 15
U | 0.2 | 0
V | 0.3382 | 15 |  | 15
W | 0.3819 | 14 |  | 15
X | 0.3246 | 15 |  | 15
Y | 0.0865 | 0
Z | 0.4861 | 15 |  | 15
Spreadsheet: 35902d1233618660-formula-assistance-with-lists-and-dates-pml-fy2009
Sheet: Feb 09

File # | Priority | Type | Name | Date Rec'd | Date Due | Date Comp | Prod Time | Overtime | E-Files | Prints | Sharp | ML 500 | Sony C14 | Sony R710 | Reprints | Studio | Location | Alerts Day | Alerts Night | Photographer | Laminate | [NAME] | Certificate | Pamphlet
1 | 1 | IRCI | [NAME] | 2009-02-01 00:00:00 | 2009-02-15 00:00:00 | 2009-02-02 00:00:00 | 2.25 | 1.75 |  | 4 |  |  |  | 1 |  |  |  |  | 1 | [NAME]
2 | 4 | Installation Support | Winkler | 2009-01-29 00:00:00 | 2009-01-30 00:00:00 | 2009-02-02 00:00:00 | 1.5 |  | 21 | 21 |  |  | 21 |  |  |  | 1 |  |  | [NAME]
3 | 4 | Installation Support | Haskett | 2009-01-29 00:00:00 | 2009-01-30 00:00:00 | 2009-02-02 00:00:00 | 1.5 |  | 16 | 16 |  |  | 16 |  |  |  | 1 |  |  | [NAME]
4 | 4 | Installation Support | [NAME] | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-02 00:00:00 | 1.25 |  |  | 20 |  |  |  | 21 |  |  | 1 |  |  | [NAME]
5 | 4 | Public Information | [NAME] | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-02 00:00:00 | 0.5 |  | 1 | 1 |  |  |  | 1 |  | 1 |  |  |  | [NAME]
6 | 4 | Public Information | Dwyer | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-02 00:00:00 | 0.5 |  |  | 3 |  | 3 |  |  |  | 1 |  |  |  | [NAME]
7 | 4 | Installation Support | Spath | 2009-01-29 00:00:00 | 2009-01-30 00:00:00 | 2009-02-02 00:00:00 | 1.5 |  | 42 | 21 |  |  | 21 |  |  |  | 1 |  |  | Berni
8 | 4 | Installation Support | Haderlie | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-02 00:00:00 | 0.5 |  |  | 8 |  | 2 |  |  |  | 1 |  |  |  | [NAME]
9 | 4 | Public Information | Ahonen | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-02 00:00:00 | 0.5 |  |  | 1 |  | 2 |  |  |  | 1 |  |  |  | [NAME]
10 | 4 | Public Information | Sheppard | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-02 00:00:00 | 0.75 |  | 2 | 12 |  | 20 |  |  |  | 1 |  |  |  | [NAME]
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
 |  | Training | 0 |  |  |  | 10.75 | 1.75 | 82 | 107 | 0 | 27 | 58 | 23 | 0 | 5 | 4 | 0 | 1 | 10 |  | 0 |  | 0
 |  | Recruiting | 0 |  |  |  | Prod Time | Overtime | E-Files | Prints | Sharp | ML 500 | Sony C14 | Sony R710 | Reprints | Studio | Location | Alerts Day | Alerts Night | Photographer | Laminate | [NAME] | Certificate | Pamphlet
 |  | Public Information | 4
 |  | Combat Readiness | 0
 |  | Medical & Dental | 0
 |  | Installation Support | 5
 |  | RDTE | 0
 |  | IRCI | 1
 |  | Other | 0
Spreadsheet: 55557d1255666998-calculation-on-last-inputs-into-a-list-example
Sheet: Sheet1

Quantity (in Lbs) | Cost | Cost /Lb |  |  | Current
100 | 505 | 5.05 |  |  | Inventory (in Lbs)
120 | 606 | 5.05
90 | 472.5 | 5.25
75 | 401.25 | 5.35
135 | 678.375 | 5.025
80 | 428 | 5.35
200 | 1000 | 5
145 | 728.625 | 5.025
945 | 4819.75
 |  |  |  |  | 400
 |  |  |  |  | 500
400 | 2022.875 | 5.0571875
500 | 2533.5 | 5.067
Spreadsheet: 797140d1663739559-powerquery-date-and-time-extraction-s666-pq-power-query-help
Sheet: Sheet1

Resolved |  | Resolved Date (Expected) | Resolved Time (Expected) |  | Date | Time
01.10.2020 08:42:59 |  | 2020-10-01 00:00:00 | 8:42:59 |  | 2020-10-01 00:00:00 | 08:42:59
01.10.2020 09:14:36 |  | 2020-10-01 00:00:00 | 9:14:36 |  | 2020-10-01 00:00:00 | 09:14:36
01.10.2020 09:15:00 |  | 2020-10-01 00:00:00 | 9:15:00 |  | 2020-10-01 00:00:00 | 09:15:00
01.10.2020 10:34:16 |  | 2020-10-01 00:00:00 | 10:34:16 |  | 2020-10-01 00:00:00 | 10:34:16
01.10.2020 14:35:33 |  | 2020-10-01 00:00:00 | 14:35:33 |  | 2020-10-01 00:00:00 | 14:35:33
01.10.2020 14:50:20 |  | 2020-10-01 00:00:00 | 14:50:20 |  | 2020-10-01 00:00:00 | 14:50:20
01.10.2020 15:11:55 |  | 2020-10-01 00:00:00 | 15:11:55 |  | 2020-10-01 00:00:00 | 15:11:55
01.10.2020 16:01:07 |  | 2020-10-01 00:00:00 | 16:01:07 |  | 2020-10-01 00:00:00 | 16:01:07
01.10.2020 17:05:12 |  | 2020-10-01 00:00:00 | 17:05:12 |  | 2020-10-01 00:00:00 | 17:05:12
02.10.2020 08:49:34 |  | 2020-10-02 00:00:00 | 8:49:34 |  | 2020-10-02 00:00:00 | 08:49:34
02.10.2020 09:04:27 |  | 2020-10-02 00:00:00 | 9:04:27 |  | 2020-10-02 00:00:00 | 09:04:27
02.10.2020 09:44:36 |  | 2020-10-02 00:00:00 | 9:44:36 |  | 2020-10-02 00:00:00 | 09:44:36
02.10.2020 09:45:00 |  | 2020-10-02 00:00:00 | 9:45:00 |  | 2020-10-02 00:00:00 | 09:45:00
02.10.2020 10:44:34 |  | 2020-10-02 00:00:00 | 10:44:34 |  | 2020-10-02 00:00:00 | 10:44:34
02.10.2020 11:03:16 |  | 2020-10-02 00:00:00 | 11:03:16 |  | 2020-10-02 00:00:00 | 11:03:16
02.10.2020 11:07:01 |  | 2020-10-02 00:00:00 | 11:07:01 |  | 2020-10-02 00:00:00 | 11:07:01
02.10.2020 11:36:23 |  | 2020-10-02 00:00:00 | 11:36:23 |  | 2020-10-02 00:00:00 | 11:36:23
02.10.2020 11:56:35 |  | 2020-10-02 00:00:00 | 11:56:35 |  | 2020-10-02 00:00:00 | 11:56:35
02.10.2020 12:00:47 |  | 2020-10-02 00:00:00 | 12:00:47 |  | 2020-10-02 00:00:00 | 12:00:47
02.10.2020 12:14:22 |  | 2020-10-02 00:00:00 | 12:14:22 |  | 2020-10-02 00:00:00 | 12:14:22
02.10.2020 12:34:58 |  | 2020-10-02 00:00:00 | 12:34:58 |  | 2020-10-02 00:00:00 | 12:34:58
02.10.2020 12:49:54 |  | 2020-10-02 00:00:00 | 12:49:54 |  | 2020-10-02 00:00:00 | 12:49:54
02.10.2020 12:56:28 |  | 2020-10-02 00:00:00 | 12:56:28 |  | 2020-10-02 00:00:00 | 12:56:28
Spreadsheet: 774946d1648734550-help-with-sorting-alphabetically-by-row-and-keeping-data-on-other-tabs-saddle-creek-daily-attendance
Sheet: Data

Selections | Position | Supervisor
X | Warehouse Associate | [NAME]
OFF | Material Handler | [NAME]
Excused | QA | [NAME]
Late | Lead
Late 121
Early Out
Early Out 121
Call Out
Sick
NCNS
New Start
Pre-Hire
Spreadsheet: 711724d1609864295-daily-sales-spreadsheet-month-target
Sheet: Sheet1

2021-01-01 00:00:00 |  |  |  |  |  |  | Monthly Target | 62500
 |  |  |  |  |  |  | Holidays
Day | DATE | Daily Target | Daily Sales | Month To Date | Undated Target |  | 2021-01-01 00:00:00
 |  |  | 2491
 |  |  | 2274
TOTAL
Spreadsheet: 877066d1723735288-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Delivery

MarkNo. | DO Qty | [NAME]. | Drawing wt, MT | ReceivedDate | Assembly Name |  | COLUMN C |  |  | Column D
QLGF-C2001 | 1 |  |  | 2024-06-14 00:00:00 |  | ok
QLGF-C2002 | 1 |  |  | 2024-06-14 00:00:00
QLGF-C2002 | 1 |  |  | 2024-06-14 00:00:00
QLGF-C2003 | 1 |  |  | 2024-06-14 00:00:00
QLGF-BM2003 | 1 |  |  | 2024-06-15 00:00:00
QLGF-BM2004 | 1 |  |  | 2024-06-15 00:00:00
QLGF-HB2005 | 1 |  |  | 2024-06-17 00:00:00
QLGF-HB2009 | 1 |  |  | 2024-06-17 00:00:00
QL-1-VB2001 | 1 |  |  | 2024-06-17 00:00:00
QL-1-VB2002 | 1 |  |  | 2024-06-17 00:00:00
QL-1-BM2002 | 1 |  |  | 2024-06-17 00:00:00
QL-1-BM2003 | 1 |  |  | 2024-06-17 00:00:00
QL-1-BM2004 | 1 |  |  | 2024-06-17 00:00:00
QT1-CL1002 | 1 |  |  | 2024-06-17 00:00:00 | Not in Sheet1
QT1-CL1007 | 1 |  |  | 2024-06-17 00:00:00 | Not in Sheet1
 |  |  |  |  |  |  | my work/test area
Spreadsheet: 85922d1285917252-text-into-a-cell-2010-09-28-vendas-de-animais-janeiro-2010
Sheet: F62

CLIENTE |  |  |  |  |  | Nº CONTRIBUINTE |  |  |  |  | DATA
MORADA |  |  |  |  |  |  |  |  |  |  | PRAZO PAGAMENTO |  |  | DIAS
CIDADE |  |  |  |  |  | TIPO PAGAMENTO |  |  |  |  | VENCIMENTO
 |  |  |  |  | DATA RECEPÇÃO |  |  |  |  | Nº FACTURA
REF. | DESCRIÇÃO |  |  |  | QUANTIDADE |  | PREÇO TON. |  |  |  | VALORES SEM IVA
 |  |  |  |  | Unidade | Kgs. | BGL |  | EUROS |  | BGL |  | EUROS
pabt |  |  |  |  | 150 | 26589 | 25
rabt |  |  |  |  | 10 | 12345 | 2.6
 |  |  |  | TOTAIS
 |  |  |  |  |  |  |  |  | IVA |  | 0.2
 |  |  |  |  |  |  |  |  | VALOR IVA
 |  |  |  |  |  |  |  |  | VALOR COM IVA
Spreadsheet: 710337d1608851861-help-pulling-data-from-a-range-attendance-template
Sheet: September

Employee Absence Schedule
September | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 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 |  | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]