tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: Jan2013

 |  |  |  |  |  |  |  |  |  |  |  | 0.27
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
248 | Customer E | 500044 | Insulight(TM) | 2 | 2.18 | 0 | 0 | 45.72 | 60.1578947368421 | 0 | 60.1578947368421 | 5.886000000000001
248 | Customer E | 500066 | Insulight(TM) | 54 | 30.9 | 2008.5 | 65 | 716.74 | 943.078947368421 | 0 | 943.078947368421 | 83.43
248 | Customer E | 99999999 | Energy Surcharge | 0 | 0 | 248.99 | 0 | 0 | 0 | 0 | 0 | 0
3152 | Customer C | 101404 | 4mm Oriel Collection Brocade | 2 | 5.64 | 386.84 | 68.59 | 143.31 | 188.5657894736842 | 0 | 188.5657894736842 | 15.228
3152 | Customer C | 500044 | Insulight(TM) | 267 | 167.37 | 3062.08 | 18.3 | 753.82 | 991.8684210526317 | 0 | 991.8684210526317 | 451.8990000000001
3152 | Customer C | 500045 | Insulight(TM) | 24 | 10.52 | 289.58 | 27.53 | 68.83 | 90.5657894736842 | 0 | 90.5657894736842 | 28.404
3152 | Customer C | 500049 | Insulight(TM) | 1 | 0.38 | 16.16 | 42.53 | 3.73 | 4.907894736842105 | 0 | 4.907894736842105 | 1.026
3152 | Customer C | 500144 | Insulight(TM) Protect | 105 | 36.87 | 1006.41 | 27.3 | 183.59 | 241.5657894736842 | 0 | 241.5657894736842 | 99.549
3152 | Customer C | 500145 | Insulight(TM) Protect | 16 | 6.09 | 220.58 | 36.22 | 41.81 | 55.01315789473684 | 0 | 55.01315789473684 | 16.443
3152 | Customer C | 500149 | Insulight(TM) | 2 | 0.77 | 34.65 | 45 | 7.48 | 9.842105263157896 | 0 | 9.842105263157896 | 2.079
3152 | Customer C | 500166 | Insulight(TM) Protect | 1 | 1.52 | 54.72 | 36 | 8.02 | 10.55263157894737 | 0 | 10.55263157894737 | 4.104
3152 | Customer C | 500262 | Insulight(TM) Protect | 2 | 0.67 | 44.45 | 66.34 | 1.39 | 1.828947368421052 | 0 | 1.828947368421052 | 1.809
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 47 | 107.24 | 13726.53 | 128 | 62.89 | 82.75 | 41753.41 | 41836.16 | 289.548
3152 | Customer C | 500280 | Insulight(TM) Protect | 3 | 0.98 | 34.34 | 35.04 | 3.53 | 4.644736842105263 | 0 | 4.644736842105263 | 2.646
3152 | Customer C | 500281 | Insulight(TM) Protect | 1 | 0.3 | 15.47 | 51.57 | 1.55 | 2.039473684210527 | 0 | 2.039473684210527 | 0.81
3152 | Customer C | 500285 | Insulight(TM) [NAME] | 1 | 0.32 | 14.72 | 46 | 5.18 | 6.81578947368421 | 0 | 6.81578947368421 | 0.8640000000000001
3152 | Customer C | 512047 | energiKare(TM) | 7 | 4.72 | 107.93 | 22.87 | 32.12 | 42.26315789473684 | 0 | 42.26315789473684 | 12.744
3152 | Customer C | 512247 | energiKare(TM) | 7 | 4.28 | 150.67 | 35.2 | 20.29 | 26.69736842105263 | 0 | 26.69736842105263 | 11.556
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 2587.2 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 92061d1291736105-how-do-i-copy-a-value-to-from-one-sheet-to-another-by-looking-up-values-in-3-columns-registration-workbook
Sheet: Manufacturers

For all new rows, copy the formulas from the row above.  To hide blanks, choose the Registration_Num filter, and de-select Blanks. |  | Choose from Drop-Down List |  | Enter Date in Format MM/DD/YYYY |  | Choose from Drop-Down List | Choose Yes or No from Drop-Down List | For Phone Number: Enter area code and 7 digit phone number without spaces or dashes |  | For all new rows, copy the formulas from the row above | Enter Date in Format MM/DD/YYYY | Enter any relevant notes (include date and your initials).
 |  |  | Collective Waste Program Information |  |  |  | Part VII | Public Education Program Information
Registration_Num | Registrant_Name | WasteAcc_Prog_Type | Collective_Name | Date_Joined | Collective_Reg_Num | RoHS_Status | Conv_Acc_Methods | Educ_Phone | Educ_Web | EDocument_Link | Date_of_Last_Update | Notes
 |  | Individual |  |  |  | Complies | Yes | 5185559999 | www.awesomewebsite.com |  | 2010-12-06 00:00:00
 |  |  |  |  |  | Complies | Yes | 5185557777 | www.mywebsite.com |  | 2010-12-06 00:00:00
 |  |  |  |  |  | Complies with Exemptions | No | 5185551234 | www.superfacility.com |  | 2010-12-03 00:00:00
 |  |  |  |  |  | Does Not Comply | No | 5185555678 | www.maufacturerBwebsite.com |  | 2010-12-03 00:00:00
Spreadsheet: 697594d1601426657-count-the-number-of-times-a-letter-appears-next-to-a-word-test-tracker
Sheet: Proforma

 |  |  | 2020-10-01 00:00:00
POTENTIAL CLIENT NAME | DATE LEAD RECEIVED | [NAME] By | HOW DID THEY HEAR ABOUT US? | Details Captured on Database         Y / N | Star Rating       (1-5) | QUALIFY CALL Y/N | SITE VISIT Y/N | [NAME] | [NAME]. | QUOTED BY | QUOTE PRICE | NEXT FOLLOW UP DATE | SUPPLY & INSTAL $ | SUPPLY ONLY $ | OTHER INCOME $ | #  SALES THIS MONTH          W/L/CF | NOTES
Company ABC |  |  | Cold Call | Y | 1 | Y | Y | Y | 1234 | [NAME] | 1000 | 2020-10-31 00:00:00 | 1000 |  |  | W
Company XYZ |  |  | Business Relationship | Y | 1 | Y | Y | Y | 5678 | [NAME] | 1100 | 2020-11-01 00:00:00 | 1100 |  |  | W
Total Leads |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No  jobs won this month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No jobs lost this month
Total Excluding New Business |  |  |  |  |  |  | Total sales #
 |  |  |  |  |  |  |  | Targetted sales |  |  |  |  |  | 2100
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | No jobs carried forward
CONVERSION RATE % = (Lead to Qualify call)
CONVERSION RATE % = (Qualify call to site visit)
CONVERSION RATE % = (Quote to sale) |  | 0 | 1 | 0
OVERALL CONVERSION RATE % = (Lead to Sale)
% $ [NAME] TO $ [NAME]
AVE $ SALE SUPPLY & INSTAL
AVE $ [NAME] SUPPLY ONLY
AVE $ [NAME] OTHER
AVERAGE $ INITIAL SALE PER NEW CLIENT (Overall)
LEAD SOURCE | LEAD NO. | SALE NO. | CONVERSION %
Business Relationship
Cold Call
New Business
Phone
[NAME]
Existing Customer
Family or Friend
Google
Tender
Trade Show
Website
Facebook
Word Of Mouth
Gumtree
Walk in
Other
TOTAL
Spreadsheet: 151641d1335032951-locked-freeze-borders-on-specific-cells-projectplan_test
Sheet: Sheet1

Title
 | Week1 |  |  |  |  | Week2 |  |  |  |  | Week3 |  |  |  |  | Week4 |  |  |  |  | Week5
Tasks | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F
Task1
[NAME]
Task3
Milestone1
Task4
Task5
Milestone2
Spreadsheet: 158673d1338338827-time-sheet-difference-issue-help-tks-adjustment
Sheet: Sheet1

DATE | DAY | DURATION 1 | DURATION 2 | TOTAL DURATION | EXCESS
2012-05-27 00:00:00 |  | 2:23:14 | 5:03:01
Spreadsheet: 16e52800-a4c5-41e6-a53a-201a4dfcca50
Sheet: Sheet1

UTAH STATE OFFICE OF EDUCATION | Unnamed: 1 | At the bottom of your screen you will find the names of each section of this application.  To OPEN or PRINT, CLICK on each one.
STANDARD APPLICATION FOR FINANCIAL ASSISTANCE
Special Education Services Unit Fiscal Year 2010
1.  AGENCY NAME and ADDRESS (zip code)
 | Department / Division
 | Area Code and Telephone Number
2.  DATE APPLICATION SUBMITTED
3.  EXPENDITURE PERIOD
Beginning Date of Project:
Ending Date of Project:
4.  PROJECT DIRECTOR
Name of Person Responsible for Supervising This Project:
E-Mail Address:
Phone Number:  (include area code)
Fax Number:       (include area code)
5.  IMMEDIATE SUPERVISOR
Name of Person To Whom The Project Director Reports
6. NAME OF PROGRAM: | Descriptive Title of Project
[NAME]
7.  AMOUNT REQUESTED FOR FUNDING   (for continued financial support for subsequent years, USOE reserves the right to renew pending successful performance and availability of funding)
The agency certifies to the best of its knowledge and belief, the data in this application is true and correct.  The agency will agree to meet all of the requirements, including the project's objectives outlined within the narrative section of this application.  The agency will also agree to comply with all other applicable State Finance Regulations as well as applicable Federal EDGAR Administrative Regulations.
______________________________________________________________
Signature of Superintendent or Financial Officer
Return Application To: | FOR USOE USE ONLY
[NAME], Director of Special Education | Date Application Received:
Special Education Services Unit
Utah State Office of Education | Program Content Reviewed By/Date:
[NAME]144200
Salt Lake City, UT  84114-4200 | Budget Reviewed By/Date:
Phone:  (801) 538-7757       Fax:  (801) 538-7991
Select "tabs" below for the additional parts of the application.
Spreadsheet: 733724d1621763148-auto-date-and-value-rotation-auto-date-and-value-rotation
Sheet: Sheet1

CHAPTER ALLOCATION LIST
DATE: 23rd May, 2021
ROLL NO | CHAPTER NO
1 | 1 , 2_x000D_
2 | 3, 4_x000D_
3 | 5, 6
4 | 7, 8
5 | 9, 10
6 | 11, 12
7 | 13, 14
8 | 15, 16-17
9 | 18-19, 20
10 | 21, 22
11 | 23, 24
12 | 25, 26
13 | 27, 28
14 | 29, 30
15 | 31, 32
16 | 33, 34
17 | 35, 36
18 | 37, 38
19 | 39, 40
20 | 41, 42
21 | 43- 44, 45_x000D_
22 | 46, 47_x000D_
23 | 48, 49_x000D_
24 | 50, 51(Epilogue)
Spreadsheet: 93336d1292940457-var-difference-on-pivot-table-book1
Sheet: Sheet4

Pivot table
 |  | Month
Report Date | Data | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | Grand Total
15/12/2011 | Sum of Sold | 9542 | 4870 | 8870 | 13177 | 3915 | 3131 | 3575 | 2354 | 1370 | 474 | 51278
 | Sum of Capacity | 15903 | 14016 | 30180 | 36966 | 17292 | 16866 | 17223 | 17280 | 17223 | 17643 | 200592
 | Sum of % Sold | 0.600012576243476 | 0.3474600456621005 | 0.2939032471835653 | 0.3564626954498729 | 0.2264052741151978 | 0.1856397486066643 | 0.2075712709748592 | 0.1362268518518518 | 0.07954479475120478 | 0.02686617922122088 | 0.2556333253569434
15/12/2010 | Sum of Sold | 9843 | 5005 | 4555 | 6719 | 4009 | 3207 | 3734 | 2403 | 1463 | 940 | 41878
 | Sum of Capacity | 15903 | 14016 | 15090 | 18483 | 17292 | 16866 | 17793 | 17280 | 17223 | 17643 | 167589
 | Sum of % Sold | 0.6189398226749669 | 0.3570918949771689 | 0.3018555334658715 | 0.3635232375696586 | 0.2318413139023826 | 0.1901458555674137 | 0.209857809250829 | 0.1390625 | 0.08494455089125007 | 0.05327892081845491 | 0.2498851356592617
Total Sum of Sold |  | 19385 | 9875 | 13425 | 19896 | 7924 | 6338 | 7309 | 4757 | 2833 | 1414 | 93156
Total Sum of Capacity |  | 31806 | 28032 | 45270 | 55449 | 34584 | 33732 | 35016 | 34560 | 34446 | 35286 | 368181
Total Sum of % Sold |  | 0.6094761994592215 | 0.3522759703196347 | 0.2965540092776673 | 0.3588162094898014 | 0.2291232940087902 | 0.187892802087039 | 0.2087331505597441 | 0.1376446759259259 | 0.08224467282122742 | 0.04007255001983789 | 0.253016858555982
Table 2
 |  | Month
Report Date | Data | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | Grand Total
15/12/2011 | Sum of Sold | 9542 | 4870 | 8870 | 13177 | 3915 | 3131 | 3575 | 2354 | 1370 | 474 | 51278
 | Sum of Capacity | 15903 | 14016 | 30180 | 36966 | 17292 | 16866 | 17223 | 17280 | 17223 | 17643 | 200592
 | Sum of % Sold | 0.600012576243476 | 0.3474600456621005 | 0.2939032471835653 | 0.3564626954498729 | 0.2264052741151978 | 0.1856397486066643 | 0.2075712709748592 | 0.1362268518518518 | 0.07954479475120478 | 0.02686617922122088 | 0.2556333253569434
15/12/2010 | Sum of Sold | 9843 | 5005 | 4555 | 6719 | 4009 | 3207 | 3734 | 2403 | 1463 | 940 | 41878
 | Sum of Capacity | 15903 | 14016 | 15090 | 18483 | 17292 | 16866 | 17793 | 17280 | 17223 | 17643 | 167589
 | Sum of % Sold | 0.6189398226749669 | 0.3570918949771689 | 0.3018555334658715 | 0.3635232375696586 | 0.2318413139023826 | 0.1901458555674137 | 0.209857809250829 | 0.1390625 | 0.08494455089125007 | 0.05327892081845491 | 0.2498851356592617
Total Sum of Sold |  | 301 | 135 | -4315 | -6458 | 94 | 76 | 159 | 49 | 93 | 466 | -9400
Total Sum of Capacity |  | 0 | 0 | -15090 | -18483 | 0 | 0 | 570 | 0 | 0 | 0 | -33003
Total Sum of % Sold |  | 0.01892724643149091 | 0.009631849315068441 | 0.007952286282306209 | 0.00706054211978574 | 0.005436039787184821 | 0.004506106960749434 | 0.002286538275969779 | 0.002835648148148157 | 0.005399756140045286 | 0.02641274159723403 | -0.005748189697681788
Spreadsheet: 869892d1716447717-find-the-time-period-a-customer-returns-find-the-time-period-a-customer-returns
Sheet: Sheet1 (2)

 |  |  |  | Customer |  | Date |  | Lapsed Month |  | Period | # Returns
 |  |  |  | 6 |  | 2024-03-20 00:00:00 |  |  |  | 0 - 1 month
 |  |  |  | 11 |  | 2024-01-01 00:00:00 |  |  |  | 1- 3 month
 |  |  |  | 11 |  | 2024-01-09 00:00:00 |  |  |  | 3 - 6 month
 |  |  |  | 11 |  | 2024-01-23 00:00:00 |  |  |  | 6 - 12 month
 |  |  |  | 11 |  | 2024-02-02 00:00:00 |  |  |  | 12 - 24 month
 |  |  |  | 11 |  | 2024-04-03 00:00:00 |  |  |  | 24+
 |  |  |  | 11 |  | 2024-04-22 00:00:00
 |  |  |  | 22 |  | 2024-03-03 00:00:00
 |  |  |  | 22 |  | 2024-05-11 00:00:00
 |  |  |  | 33 |  | 2024-06-22 00:00:00
 |  |  |  | 44 |  | 2024-02-12 00:00:00
 |  |  |  | 55 |  | 2024-02-22 00:00:00
 |  |  |  | 55 |  | 2024-03-03 00:00:00
 |  |  |  | 55 |  | 2024-10-09 00:00:00
Spreadsheet: 164503d1340800194-need-to-find-week-number-in-a-month-lookup-1-master
Sheet: Sheet1

Date | Week | Month | Year
2011-01-01 00:00:00 | 52 | Jan | 2011
2011-02-01 00:00:00 | 5 | Feb | 2011
2011-03-01 00:00:00 | 9 | Mar | 2011
2011-04-01 00:00:00 | 13 | Apr | 2011
2011-05-01 00:00:00 | 17 | May | 2011
2011-06-01 00:00:00 | 22 | Jun | 2011
2011-07-01 00:00:00 | 26 | Jul | 2011
2011-08-01 00:00:00 | 31 | Aug | 2011
2011-09-01 00:00:00 | 35 | Sep | 2011
2011-10-01 00:00:00 | 39 | Oct | 2011
2011-11-01 00:00:00 | 44 | Nov | 2011
2011-12-01 00:00:00 | 48 | Dec | 2011
2012-01-01 00:00:00 | 52 | Jan | 2012
2012-02-01 00:00:00 | 5 | Feb | 2012
2012-03-01 00:00:00 | 9 | Mar | 2012
2012-04-01 00:00:00 | 13 | Apr | 2012
2012-05-01 00:00:00 | 18 | May | 2012
2012-06-01 00:00:00 | 22 | Jun | 2012
2012-07-01 00:00:00 | 26 | Jul | 2012
2012-08-01 00:00:00 | 31 | Aug | 2012
2012-09-01 00:00:00 | 35 | Sep | 2012
2012-10-01 00:00:00 | 40 | Oct | 2012
2012-11-01 00:00:00 | 44 | Nov | 2012
2012-12-01 00:00:00 | 48 | Dec | 2012
Spreadsheet: e65530ca-b6cc-46f9-8973-a3918aeb1967
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Občina Vrhnika
 | Izračun V5.1
 | [NAME] stroški posameznih vrst komunalne opreme
 | Izračun V5.1
 |  |  | Cpi | Cti
 |  |  | parcela | tloris
 | Vodovod | Cxv | 4.718890371458611 | 10.38901434063021
 |  | Cxv(Dpi) | 1.887556148583445 | 6.233408604378124
 | Kanalizacija | Cxk | 6.031546662769258 | 11.26542684900158
 |  | Cxk(Dpi) | 2.412618665107703 | 6.759256109400946
 | [NAME] ceste (v UN) | Cxc | 5.78536379966515 | 11.07320447115601
 | [NAME] ceste (LZ) in lokalne krajevne ceste (LK) | Cxc(Dpi) | 2.31414551986606 | 6.643922682693604
 | Lokalne ceste in javne poti - čez celotno občino | Cxc | 10.83054088216387 | 24.89237667672653
 | lokalne ceste (LC) in javne poti (JP) | Cxc(Dpi) | 4.332216352865548 | 14.93542600603592
 | Testni izračun v €
 | [NAME] (površina parcele) | 0
 | Atlorisna (neto tlorisna površina) | 0
 | Kdejavnosti (faktor dejavnosti) | 0 |  | med 0,7 do 1,3
 |  | [NAME] parcele Dp | [NAME] površine objekta Dt
 | Razmerje med deležem parcele (Dp) in deležem neto tlorisne površine objekta (Dt) | 0.4 | 0.6 | [NAME] 1
 |  | Upoštevamo (DA=1, NE=0) | Strošek parcele | Strošek neto tlorisne površine | [NAME]
 | Voda | 0 | 0 | 0 | 0
 | Kanal eno območje | 0 | 0 | 0 | 0
 | [NAME] ceste (LZ in LK) - v UN | 0 | 0 | 0 | 0
 | Lokalne ceste in javne poti (LC in JP) - čez celotno občino | 0 | 0 | 0 | 0
 |  | [NAME]: |  |  | 0
 | Faktor dejavnosti (Kdejavnosti)
 | opis | CC-SI | faktor
 | Enostanovanjske stavbe | 111 | 0.7
 | Dvostanovanjske stavbe | 1121 | 1
 | Večstanovanjske stavbe | 1122 | 1.3
 | Gostinske stavbe | 121 | 1.3
 | Stavbe javne uprave | 12201 | 1
 | Stavbe bank, pošt, zavarovalnic | 12202 | 1.3
 | Druge upravne in pisarniške stavbe | 12203 | 1.3
 | Trgovske in druge stavbe za storitvene dejavnosti | 123 | 1.3
 | Stavbe za promet in stavbe za izvajanje elektronskih komunikacij | 124 | 1.3
 | Industrijske stavbe in skladišča | 125 | 1
 | Stavbe splošnega družbenega pomena | 126 | 0.7
 | Druge nestanovanjske stavbe | 127 | 0.7
 | Za vse ostale vrste objektov se določi faktor dejavnosti (Kdejavnosti) 1,0
Spreadsheet: 778414d1651055498-sumifs-formula-taking-into-account-2-criteria-plus-todays-date-sum-if-multiple-criteria
Sheet: Sheet1

Date | Type | Account | Balance |  |  |  |  | Type | Account | Balance Today
2022-04-25 00:00:00 | Account A | [NAME] | -10 |  |  |  |  | Account A | [NAME] | 30
2022-04-25 00:00:00 | Account B | [NAME] | 10 |  |  |  |  | Account B | [NAME] | 50
2022-04-27 00:00:00 | Account A | [NAME] | 30
2022-04-27 00:00:00 | Account B | [NAME] | 50
 |  |  |  |  |  |  |  | Im wanting a formula so that in Cells J2 and J3, the result shown is what the balance is in the different accounts TODAY, so taking into account the date.
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 03 Feb 20 - 08 Feb 20 

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-02-03 00:00:00 | 2020-02-04 00:00:00 | 2020-02-05 00:00:00 | 2020-02-06 00:00:00 | 2020-02-07 00:00:00 | 2020-02-08 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 03/02/2020 - 08/02/2020
Dameon | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | Dameon | ❌
[NAME] | ❌ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | [NAME] | ✓
[NAME] | AWAY | ✓ | ✓ | AWAY | AWAY |  |  |  |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | AWAY | AWAY | AWAY |  |  |  |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | Harley | ✓
[NAME] | ❌ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | [NAME] | ❌
Nathan | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | Nathan | ❌
[NAME] | ✓ | ✓ | AWAY | AWAY | AWAY |  |  |  |  | [NAME] | N/A
[NAME] | ✓ | ✓ | AWAY | AWAY | AWAY |  |  |  |  | [NAME] | ❌
Tyson | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | Will | ✓
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | [NAME] | ✓ | ✓ | AWAY | AWAY |  |  |  |  |  | ❌
 | ✓ | AWAY | ✓ | AWAY | AWAY |  |  |  |  |  | ❌
 | ✓ | ✓ | ❌ | AWAY | AWAY |  |  |  |  |  | ❌
Edge Protection [NAME] |  |  | 03/02/2020 - 08/02/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 03/02/2020 - 08/02/2020
Komatsu |  |  | ❌ |  |  |  |  |  |  | Dameon | ✓
Bascik |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
CLS |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
Lilburn |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Blum |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ❌
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | ✓
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
Spreadsheet: 84069d1284060399-removing-duplicates-while-leaving-the-most-recently-updated-sample-for-excel-forum
Sheet: Sheet1

Time Card | Candidate ID | ASSignment | First Name | Last Name | Company | EMPL_TYPE | CONSUMER | Job Title | Week Ending Date | [NAME] | EXPORT_STAT | PAY_HRS | Pay Grand Total | BILL_HRS | [NAME] Total | Comments
1 | 13123 | 2490699 | My | D | BP | [NAME] | [NAME] | SLP | 2010-08-20 00:00:00 | Approved | Exported | 2.5 | 197.5 | 2.5 | 306.25
2 | 13123 | 2490699 | My | D | BP | [NAME] | [NAME] | SLP | 2010-08-13 00:00:00 | Approved | Exported | 0.5 | 39.5 | 0.5 | 61.25
3 | 13123 | 2490699 | My | D | BP | [NAME] | [NAME] | SLP | 2010-08-06 00:00:00 | Approved | Exported | 0.5 | 39.5 | 0.5 | 61.25
4 | 13123 | 2490699 | My | D | BP | [NAME] | [NAME] | SLP | 2010-07-30 00:00:00 | Approved | Exported | 0.5 | 39.5 | 0.5 | 61.25
5 | 20105 | 2513792 | Ty | G | BP | 1099 | [NAME] | OT | 2010-09-03 00:00:00 | Approved | Exported | 1 | 80 | 1 | 100
6 | 20172 | 2501224 | Ma | S | BP | Supplier | [NAME] | OT | 2010-07-30 00:00:00 | Approved | Exported | 0.75 | 67.5 | 0.75 | 67.5
7 | 20172 | 2501224 | Ma | S | BP | Supplier | [NAME] | OT | 2010-07-16 00:00:00 | Approved | Exported | 1 | 90 | 1 | 90
8 | 20158 | 2509831 | Ag | Ve | BP | Supplier | [NAME] | SLP | 2010-07-30 00:00:00 | Approved | Exported | 0.5 | 37.5 | 0.5 | 37.5
9 | 20158 | 2509831 | Ag | Ve | BP | Supplier | [NAME] | SLP | 2010-07-23 00:00:00 | Approved | Exported | 0.5 | 37.5 | 0.5 | 37.5
10 | 20158 | 2509831 | Ag | Ve | BP | Supplier | [NAME] | SLP | 2010-07-16 00:00:00 | Approved | Exported | 0.5 | 37.5 | 0.5 | 37.5
11 | 19988 | 2488131 | Rl | Le | BP | Supplier | [NAME] | SLP | 2010-07-23 00:00:00 | Approved | Exported | 0.5 | 42.5 | 0.5 | 42.5
12 | 19988 | 2488131 | Rl | Le | BP | Supplier | [NAME] | SLP | 2010-07-16 00:00:00 | Approved | Exported | 0.5 | 42.5 | 0.5 | 42.5
Spreadsheet: 701339d1603714070-specific-substraction-from-multiple-cells-columns-book1
Sheet: Sheet1

22:30:00
23:00:00 | 36 | 6 |  |  |  |  | 9 |  |  |  |  |  | 14 | 5 | 1 |  |  |  | 6 | 2 | 0.4 |  |  |  | 26 | 4 | 1 | 19 | 4 | 0.3 |  |  |  | 7 | 10 | 6 |  |  |  | 11 | 7
1900-01-01 00:00:00 | 52 | 11 |  |  |  |  | 13 |  |  |  |  |  | 22 | 9 | 3 |  |  |  | 7 | 2 | 0.4 |  |  |  | 46 | 13 | 1 | 22 | 5 | 0.7 |  |  |  | 12 | 10 | 7 |  |  |  | 16 | 9
01:00:00 | 74 | 12 |  | 37 |  |  | 15 |  |  |  |  |  | 94 | 16 | 7 | 16 | 11 | 1 |  |  |  |  |  |  | 72 | 19 | 1 | 39 | 19 | 1 |  |  |  | 15 | 11 | 13 |  |  |  | 19 | 15
02:00:00 | 104 | 21 | 2 | 88 |  |  | 17 |  |  |  |  |  | 215 | 25 | 11 | 62 | 40 | 23 |  |  |  |  |  |  | 111 | 26 | 5 | 53 | 26 | 4 |  |  |  | 19 | 13 | 14 |  |  |  | 24 | 17
03:00:00 | 147 | 49 | 2 | 114 |  |  |  |  |  |  |  |  | 262 | 28 | 17 | 111 | 81 | 43 | 25 | 11 | 6 |  |  |  | 126 | 31 | 6 | 57 | 26 | 4 |  |  |  | 23 | 21 | 15 |  |  |  | 26 | 18
04:00:00 | 157 | 61 |  | 117 |  |  |  |  |  |  |  |  | 281 | 33 | 21 | 117 | 132 | 44 | 29 | 11 | 6 |  |  |  | 132 | 34 | 7 | 58 | 26 | 4 |  |  |  | 35 | 23 | 17 |  |  |  | 34 | 22
05:00:00 | 174 | 63 |  | 129 |  |  |  |  |  |  |  |  | 303 | 51 | 23 | 123 | 133 | 48 | 32 | 11 | 6 |  |  |  | 140 | 35 | 12 | 63 | 26 | 4 |  |  |  | 45 | 24 | 24 |  |  |  | 35 | 22
06:00:00 | 193 | 66 |  | 135 |  |  |  |  |  |  |  |  | 323 | 53 | 24 | 127 | 135 | 49 | 37 | 12 | 6 |  |  |  | 147 | 44 | 13 | 63 | 26 | 4 |  |  |  | 62 | 27 | 24 |  |  |  | 38 | 24
07:00:00 | 224 | 115 | 4 | 141 |  |  |  |  |  |  |  |  | 346 | 59 | 24 | 142 | 172 | 57 | 41 |  | 6 |  |  |  | 155 | 50 | 17 | 63 | 26 | 4 |  |  |  | 66 | 31 | 25 |  |  |  | 44 | 27
08:00:00 | 283 | 249 | 43 | 160 |  |  | 55 | 51 |  |  |  |  | 377 | 75 | 28 | 210 | 313 | 90 | 51 |  | 6 |  |  |  | 191 | 95 | 21 | 67 |  | 5 |  |  |  | 107 | 84 | 50 |  |  |  | 63
09:00:00 | 515 | 490 | 114 | 275 |  |  | 146 | 76 |  |  |  |  | 400 | 81 | 30 | 256 | 396 | 121 | 78 | 70 | 10 |  |  |  | 222 | 146 | 27 |  |  |  |  |  |  | 192 | 158 | 68 |  |  |  | 76
10:00:00 | 669 | 673 | 171 | 346 |  |  | 197 | 154 |  | 109 |  |  | 438 | 108 | 35 | 274 | 450 | 132 | 100 | 85 | 15 |  |  |  | 266 | 160 | 28 |  |  |  |  |  |  | 278 | 285 | 79
11:00:00 | 741 | 797 | 199 | 393 |  |  | 230 | 177 |  | 139 |  |  | 456 | 117 | 38 | 290 | 456 | 136 | 114 | 89 | 15 |  |  |  | 293 | 180 | 29 |  |  |  |  |  |  | 345 | 354 | 94
12:00:00
13:00:00
14:00:00