tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878430d1725514546-unique-text-join-and-transpose-by-formula-as-well-as-by-code-text-join-and-transpose
Sheet: Expected Result

Date | Particulars |  |  |  |  | Text Join
2024-06-16 00:00:00 | [NAME],Greenland
 | Pistachio Glues
2024-06-16 00:00:00 | Wold Never Goes Wrong
 | [NAME]
2024-06-16 00:00:00 | Google Inc
 | Rusted Pure Base
2024-06-17 00:00:00 | Amazon Coporation
 | Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
 | Pistachio Glues
2024-06-17 00:00:00 | [NAME] LLC
 | Fever
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | Wold Vision Pvt Ltd
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | New Kalakriti
 | Pills & Lassi
2024-06-20 00:00:00 | [NAME]
 | Addons
 | Harder
2024-06-20 00:00:00 | Hindustan Lever Ltd
 | Fever
 | Pola Ship
2024-06-21 00:00:00 | Overseas Market
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-06-23 00:00:00 | Hindustan Lever Ltd
 | Pills & Lassi
 | Pills & Lassi
2024-06-30 00:00:00 | Reliance Telecom
 | Pure Base
 | Pola Ship
2024-06-30 00:00:00 | Hindustan Lever Ltd
 | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-03 00:00:00 | Alzazira Corporation Ltd
 | Pills & Lassi
 | Rusted Pure Base
2024-07-03 00:00:00 | [NAME]
 | Rusted Pure Base
 | Rusted Pure Base
 | Rusted Pola Ship
 | Rusted Pola Ship
 | Rusted Pola Ship
2024-07-03 00:00:00 | Botanical Garden
 | Fever
 | Pola Ship
 | Pola Ship
2024-07-07 00:00:00 | Plast Product
 | BONE Sheet
 | Rusted BONE Sheet
2024-07-08 00:00:00 | Alzazira Corporation Ltd
 | Rusted Lock Film
 | Pills & Lassi
2024-07-10 00:00:00 | Alzazira Corporation Ltd
 | Pure Base
 | Pills & Lassi
 | Rusted Pure Base
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown
 | Rusted Pola Ship
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles
 | Pola Ship
2024-07-28 00:00:00 | The Kingdom of Plant of Apes
 | Pills & Lassi
 | Pills & Lassi
Spreadsheet: 218162-search-between-2-values-range-notice
Sheet: Sheet2

 | days
notice | 21 | [NAME]
notice | 28 | [NAME]
reminder | 31 | maria
notice | 30 | [NAME]
notice | 37 | greg
reminder | 32 | [NAME]
notice | 31 | rianna
notice | 47 | [NAME]
reminder | 58 | martin
notice | 56 | [NAME]
notice | 89 | violet
reminder | 31 | vishu
notice | 12 | [NAME]
notice | 10 | tubo
reminder | 17 | kreyz
notice | 45 | ritz
reminder | 23 | [NAME]
notice | 56 | betty
reminder | 45 | [NAME]
Spreadsheet: 779201d1651623017-help-needed-for-sum-up-time-totals-workingpaytemplate-northernwarrior-
Sheet: Help Needed Sheet

Sunday |  | Platform |  | Pays
Daily HOS | Overall Hours | Platform | Non Platform | Overtime | Call-Up
Run # | Start Time | End Time | Extend | Duration | Task | Platform | Non Platform
 | 0700 | 1000 |  |  | Platform
 | 1030 | 1200 |  |  | Platform
 | 1230 | 1700 |  |  | Platform
 | 0700 |  | 1000 |  | Platform
 | 1030 |  | 1200 |  | Platform
 | 0700 | 1000 |  |  | Platform
Call Up ? | No | 9:30 Booking | No | Additional HOS Minutes | 0
 |  |  | Totals
 |  |  | Non Platform
Hidden | Hidden | Hidden | Platform
 |  |  | Plat Reg Pay
 |  |  | Plat OT
 |  |  | Stand-By
 |  |  | OT / Scrounge
 |  |  | DAY
Spreadsheet: 264804d1378987917-search-help-with-textbox-asda-obs
Sheet: Sheet4

Frontend | Frozen | H & L | Grocery | Fresh | George | Counters | Services
sep | sep | sep | sep | sep | sep | sep | sep
march | march | march | march | march | march | march | march
april | april | april | april | v | march | march | march
Spreadsheet: kate_symes__18704__New Notification Report 0101
Sheet: Mar 2001

 |  |  |  | Notes: | All Dates Are in mm/dd/yy format
MARCH 2001 |  |  |  |  | N/C = No Change
 |  |  |  |  | See "Changes"  Worksheet for short list of new changes
 |  | Former Counterparty Data |  |  |  |  | Updated Counterparty Data |  |  |  |  | GCP Updated On |  |  |  | [NAME] Use Only
Change Type | Legal Eff. Date | Name | BA ID | CP ID | Short Name | Inactivation Date | Name | BA ID | CP ID | Short Name | Comments | Name | Shortname | Inactivation |  | Notification Date
Name Overlay | 2000-12-01 00:00:00 | ECR Energy, LLC | 74072 | 74172 | ECRENELLC | N/A | Northland Energy Trading, LLC | N/C | N/C | NORTHLANENETRA | Have recorded LLC Certificate of Amendment in hand. | 2001-02-22 00:00:00 | 2001-02-23 00:00:00 | N/A |  | 2001-02-22 00:00:00
Name Overlay | 2001-02-05 00:00:00 | Unicom Energy Inc. | 80575 | 80575 | UNICOMENE | N/A | Exelon Energy Company | N/C | N/C | EXELONENECO | Have recorded Certificate of Amendment and SOS Certificate in hand. | 2001-02-23 00:00:00 | 2001-02-23 00:00:00 | N/A |  | 2001-02-23 00:00:00
Spreadsheet: 929766be-4fa7-47ab-83e4-54e722e290a2
Sheet: Monocytes

 |  |  |  | Allele1/Allele1 |  | Allele1/Allele2 |  | Allele2/Allele2
Gene | SNP | Allele1/Allele2 | Study | Sample Size | WBC, [NAME] (SD), x 1000 Cells per mm3 | Sample Size | WBC, [NAME] (SD), x 1000 Cells per mm3 | Sample Size | WBC, [NAME] (SD), x 1000 Cells per mm3
DARC | rs2814778 | C/T | WHI | NA | NA | NA | NA | NA | NA
 |  |  | ARIC | 1816 | 0.327 (0.198) | 693 | 0.378 (0.187) | 109 | 0.390 (0.217)
 |  |  | CARDIA | 573 | 0.282 (0.149) | 266 | 0.380 (0.196) | 37 | 0.371 (0.185)
 |  |  | JHS | 1287 | 0.361 (0.132) | 474 | 0.452 (0.151) | 59 | 0.433 (0.134)
 |  |  | HABC | 139 | 0.350 (0.120) | 62 | 0.400 (0.150) | 5 | 0.400 (0.120)
 |  |  | GeneSTAR | 540 | 0.327 (0.146) | 225 | 0.280 (0.112) | 41 | 0.314 (0.154)
 |  |  | HANDLS | NA | NA | NA | NA | NA | NA
Spreadsheet: 15292bc6-2367-4aa8-8f66-ba1610116419
Sheet: Sheet1

Table 6--Cottonseed oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | Million pounds
2012/131 | 100 | 800 | 19.9174 | 919.9174 |  | 599.2454 | 220.672 | 819.9174 | 100
2013/142 | 100 | 630 | 20 | 750 |  | 475 | 175 | 650 | 100
2014/152 | 100 | 705 | 20 | 825 |  | 520 | 205 | 725 | 100
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2014-06-13 08:19:43.500000
Spreadsheet: 810345d1671710343-sum-constant-52-previous-cells-in-one-column-ignoring-clear-cells-book1
Sheet: (4)

ssp | (Sick)
B | (Basic)
t
9.2 | Rate
 |  |  |  |  | (1) | (2) | (3) | (4)
Week No | Basic Hr | W/E Hr | Total Hours inc Hol Hrs | Days worked W & W/E | Code | Total Money  [NAME] | Other Paymts | [NAME] | SSP | Total Money | Total Pay 52 W | Total Hours 52w | Rate for Holiday Pay
1  2021 | 20 |  |  | 6 | b |  |  | 9.2 |  |  |  |  |  | Example
1  20_21 | 39 | 48 |  |  | b | 1046.1
2 | 39 | 18 |  |  | b | 621.9
3 | 39 | 26.5 |  |  | b | 742.09
4 | 39 | 37 |  |  | b | 890.56
5 | 39 | 56 |  |  | b | 1159.22
6 | 39 | 18.5 |  |  | b | 628.97
7 | 39 | 11.25 |  |  | b | 526.46
8 | 39 | 3.5 |  |  | b | 416.87
9 | 39 | 6.5 |  |  | b | 459.29
10 | 39 | 0 |  |  | b | 367.38
11 | 39 | 4 |  |  | b | 423.94
12 | 39 | 0 |  |  | b | 367.38
13 | 39 | 8.5 |  |  | b | 487.57
14 | 39 | 2.75 |  |  | b | 406.27
15 | 39 | 5.5 |  |  | b | 445.15
16 | 39 | 3 |  |  | b | 409.8
17 | 39 | 15.5 |  |  | b | 586.55
18 | 39 | 19 |  |  | b | 636.04
19 | 39 | 45.5 |  |  | b | 1010.75
20 | 39 | 49 |  |  | b | 1060.24
21 | 39 | 0 |  |  | b | 367.38
22 | 39 | 50 |  |  | b | 1074.38
23 | 39 | 13.5 |  |  | b | 558.27
24 | 39 | 49.25 |  |  | b | 1063.78
25 | 39 | 56.5 |  |  | b | 1166.29
26 | 39 | 39.5 |  |  | b | 925.91
27 | 39 | 47 |  |  | b | 1042.81
28 | 39 | 19.5 |  |  | b | 643.11
29 | 39 | 56.5 |  |  | b | 1166.29
30 | 39 | 23 |  |  | b | 705.4
31 | 39 | 2 |  |  | b | 329.72
32 | 39 | 2 |  |  | b | 406.44
33 | 39 | 10 |  |  | b | 519.63
34 | 39 | 8 |  |  | b | 491.42
35 | 39 | 5.75 |  |  | b | 525.62
36 | 39 | 0 |  |  | b | 380.18
37 | 39 | 1.5 |  |  | b | 401.39
38 | 39 | 0 |  |  | b | 392.98
39 | 39 | 1.5 |  |  | b | 414.35
40 | 39 | 0 |  |  | b | 406.02
41 | 39 | 0 |  |  | b | 378.72
42 | 39 | 0 |  |  | b | 378.79
43 | 39 | 0.5 |  |  | b | 385.65
44 | 39 | 1.5 |  |  | b | 398.74
45 | 39 | 1.5 |  |  | b | 399.65
46 | 39 | 4 |  |  | b | 435
47 | 39 | 2 |  |  | b | 397.23
48 | 39 | 3 |  |  | b | 420.79
49 | 39 | 4 |  |  | b | 423.94
50 | 39 | 7 |  |  | ssp | 466.36
51 | 29.5 | 0 |  |  | ssp | 297.06
52 | 39 | 34 |  |  | b | 848.14
1 21_22 | 39 | 19 |  |  | b | 636.04
2 | 39 | 14.5 |  |  | b | 572.41
3 | 39 | 17.25 |  |  | b | 668.81
4 | 39 | 20.5 |  |  | b | 657.25
5 | 39 | 28 |  |  | b | 763.3
6 | 39 | 55 |  |  | b | 1145.08
7 | 39 | 10.25 |  |  | b | 512.32
8 | 39 | 20.5 |  |  | b | 798.65
9 | 39 | 35.25 |  |  | b | 865.82
10 | 39 | 34.5 |  |  | b | 965.18 |  |  |  |  |  |  |  |  |  |  | needs add 2 weeks adding
11 | 39 | 3 |  |  | b | 409.8 |  |  |  |  |  |  |  |  |  |  | so there are 52 weeks of figures | 416.87
12 | 39 | 11.5 |  |  | b | 529.99 |  |  |  |  |  |  |  |  |  |  |  | 459.29
13 | 39 | 15.5 |  |  | b | 586.55
Spreadsheet: 4804b48e-6fe3-490c-83d0-c65fa0b81911
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260515 | 52932 | Nick | Ruane | NZL | 156 | [NAME] | 00:03:05 | 00:41:12 | 00:01:55 | 00:25:39 | 1 | 01:39:36
Spreadsheet: 117712d1312978407-autofill-template-book1
Sheet: Sheet1

Some text
Some text
Some text
Mokinys | Specialybė | [NAME] | Math | English | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc. | etc.
[NAME]
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
What I need:
I need programe which autofill green table
Look Sheet2
Spreadsheet: 455256d1460193067-running-total-of-production-by-product-id-master-batch-production-code-register
Sheet: Volume by Recipe

Total Products Produced
Code | Recipe | Volume (kg)
1 | [NAME]
2 | Smoked Sausage
3 | [NAME]
4 | Kaiser Bacon
5 | Bacon
6 | Smoked Belly Pork
7 | [NAME]
8 | Pork Cheeks
9 | Smoked Pork Ribs
10 | [NAME]
11 | Romanian Meat Rolls
12 | Fresh Sausage
13 | Smoked Pork Loin
14 | Smoked Pork Collar
15 | Smoked Chicken Breast
16 | Pork Fat
17
18
19
20
21
22
23
24
25
Spreadsheet: 818428d1676826913-sumproduct-month-not-working-with-cells-containing-if-and-cell-cell-test
Sheet: Variable Expenses

Rental #1 Name: |  |  |  |  |  | Advertising
Rental #2 Name: |  |  |  |  |  | Auto and Travel
Rental #3 Name: |  |  |  |  |  | Cleaning & Maintenance
Rental #4 Name: |  |  |  |  |  | Commissions
Overall Expenses: |  |  |  |  |  | Insurance
 |  |  |  |  |  | Legal & other professional fees
 |  |  |  |  |  | Management Fees
Rental Property | Expense Description | Expense Category | Month / Date | Amount |  | Mortage Payments
 | Supplies | Cleaning & Maintenance | January |  |  | Repairs
 | Cleaning | Cleaning & Maintenance | January |  |  | Supplies
 |  |  |  |  |  | Taxes
 | Supplies | Cleaning & Maintenance | February |  |  | Utilities
 | Cleaning | Cleaning & Maintenance | February |  |  | Depreciations Expense or Depletion
 |  |  |  |  |  | Other
 | Supplies | Cleaning & Maintenance | March
 | Cleaning | Cleaning & Maintenance | March
 | Supplies | Cleaning & Maintenance | April
 | Cleaning | Cleaning & Maintenance | April
 | Supplies | Cleaning & Maintenance | May
 | Cleaning | Cleaning & Maintenance | May
 | Supplies | Cleaning & Maintenance | June
 | Cleaning | Cleaning & Maintenance | June
 | Supplies | Cleaning & Maintenance | July
 | Cleaning | Cleaning & Maintenance | July
 | Supplies | Cleaning & Maintenance | August
 | Cleaning | Cleaning & Maintenance | August
 | Supplies | Cleaning & Maintenance | September
 | Cleaning | Cleaning & Maintenance | September
 | Supplies | Cleaning & Maintenance | October
 | Cleaning | Cleaning & Maintenance | October
 | Supplies | Cleaning & Maintenance | November
 | Cleaning | Cleaning & Maintenance | November
 | Supplies | Cleaning & Maintenance | December
 | Cleaning | Cleaning & Maintenance | December
Spreadsheet: 81991d1282071065-only-one-entry-per-month-in-pivot-table-performance-revised
Sheet: Z

Incident | Date | ID | Cause | Delay Code | Manager | Comm | Incident Location | Cost | Delays
182987 | 2010-07-27 00:00:00 | 5X78 | STOOD FOUL WILLESDEN | C | OQAZ | Z | HARROW & WEALDSTONE | 944.16 | 28
Spreadsheet: mary_fischer__25625__1290
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1290 |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME  PBM Fair Value Co.
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | completed
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | completed
E-6 * | TOT_PPE | Property, Plant & Equipment | completed
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | completed
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 |  | Equity/Invmt Sub | completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 712971d1610503653-need-to-use-a-2nd-set-of-data-to-break-a-rank-tie-daily-wheel-new-2
Sheet: Titans IH Marketing

In-House Marketing Desk
[NAME] |  |  |  |  |  | Owners: |  |  |  | Goal: |  |  |  |  |  |  |  | P1s: |  |  |  | Goal: |  |  |  | Guests: |  |  |  | Goal:
Kaitlyn | 8:00 | - | 4:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
[NAME] | 8:00 | - | 4:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
Savannah | 11:00 | - | 7:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
Kimberly | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
[NAME] | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
Tonya | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
JJ | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
Rhea | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
Savannah | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
Lauren | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
[NAME] | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
[NAME] | 2:00 | - | 10:30
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
Spreadsheet: louise_kitchen__22772__NETCO1
Sheet: West Power

[NAME] | Jake | Orig
McDonald | [NAME] | Orig
Shields | [NAME] | Orig
Etringer | [NAME] | Orig
Choi | [NAME] | Orig
Rosman | [NAME] | Orig
Buerkle | [NAME] | Orig
Lackey | [NAME] | Orig
Malowney | [NAME] | Orig
Woodland | [NAME] | Orig
[NAME] | [NAME] | Orig
[NAME] | [NAME] | Orig
[NAME] | [NAME] | Orig
Wente | [NAME] | Orig
Thome | [NAME] | Orig
[NAME] | Todd | Structuring
[NAME] | [NAME] | Structuring
Elafandi | Mo | Structuring
[NAME] | [NAME] | Structuring
Mumm | [NAME] | Structuring
[NAME] | [NAME] | Structuring
Axford | Kathy | [NAME]
[NAME] | Jessica | [NAME]
Butler | Emily | [NAME]
Chatterton | [NAME] | [NAME]
Gustafson | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Hall | Erin | [NAME]
Sheppard | Kathy | [NAME]
Villeggiante | Theresa | [NAME]
Connes | [NAME] | Reg Affairs
[NAME] | [NAME] | Reg Affairs
Postelthwaite | [NAME] | Risk
Law | Samantha | Risk
[NAME] | Fran | Risk
Dunton | Heather | Risk
Warner | [NAME] | Risk
Rance | [NAME] | Credit
[NAME] | Scott | Volume Mgmt
Blair | Kit | Volume Mgmt
Cavanaugh | [NAME] | Volume Mgmt
[NAME] | Caroline | Volume Mgmt
[NAME] | [NAME] | Volume Mgmt
Purcell | [NAME] | Volume Mgmt
Reyes | [NAME] | Volume Mgmt
[NAME] | [NAME] | Volume Mgmt
Thompson | Virginia | Volume Mgmt
Badeer | [NAME] | Trading
Motley | [NAME] | Trading
Driscoll | [NAME] | Trading
Swerzbin | [NAME] | Trading
Belden | [NAME] | Trading
Scholtes | [NAME] | Trading
Mallory | [NAME] | Trading
Fishcer | Mark | Trading
Salisbury | Holden | Trading
[NAME] | [NAME] | Trading
Richter | [NAME] | Trading
Semperger | Cara | Scheduling
Runswick | Stacy | Scheduling
Cutsforth | [NAME] | Scheduling
[NAME] | [NAME] | Scheduling
Platter | [NAME] | Scheduling
Bishop | Serena | Scheduling
Alport | Kysa | Scheduling
Wilson | [NAME] | Scheduling
Gang | [NAME] | Services
Rawson | Les | Services
Cocke | [NAME] | Services
[NAME] | [NAME] | Services
Heizenrader | [NAME] | Fundies
[NAME] | [NAME] | Fundies
[NAME] | Kourtney | Fundies
[NAME] | Julie | Fundies
Van Houten | Maria | Fundies
Swain | [NAME] | Fundies
[NAME] | [NAME] | Fundies
Steiner | [NAME] | Infrastructure
Cox | Chip | Infrastructure
Bulbes | Victor | Infrastructure
Tully | [NAME] | Infrastructure
Stokley | [NAME] | Keepers
O'Neil |  | Keepers
Furrow | Dale | Keepers
[NAME] | [NAME] | Real Time
[NAME] | [NAME] | Real Time
Harasin | Leaf | Real Time
Merriss | [NAME] | Real Time
Slinger | [NAME] | Real Time
Symes | [NAME] | Real Time
[NAME] | [NAME] | Real Time
Guzman | Mark | Real Time
Linder | [NAME] | Real Time
Meyers | [NAME] | Real Time
Presto | Darin | Real Time
[NAME] | Geir | Real Time
Estate
[NAME] | [NAME]
When | [NAME]
Broadbeck
[NAME] | [NAME]
Fillinger | Mark
Russel | [NAME]
Slaughter | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Page | [NAME]
Guillaume | [NAME]
Codena | [NAME]
[NAME] | [NAME]
Mays | Wayne
[NAME] | [NAME]
[NAME] | Jodi
Spreadsheet: 51343d1250911786-automatically-testing-values-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6473
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Increment[AU2] from 0->83520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y | z | aa | ab | ac | ad | ae | af | ag | ah | ai | aj | ak | al | am | an | ao
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red |  |  | 5 | 8 | 1 | 1 | 2 | 0 | 2 | 2 | 0.5 | 0.5 | 1 | 1 | 0.5 | 2 | 0.5 | 2 | 1 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blue |  |  | 5 | 8 | 0.5 | 1 | 1 | 0.5 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green |  |  | 5 | 8 | 1 | 2 | 1 | 1 | 0.25 | 1 | 0.25 | 0.5 | 1 | 2 | 2 | 0.5 | 2 | 1 | 1 | 1 | 1
Spreadsheet: 536564d1504575583-excel-template-for-monthly-work-recording-pay-by-day-v1
Sheet: Calculations

 |  | Date from | Date to |  |  |  |  |  |  | Staff | Role | Daily rate
 |  | 2017-08-01 00:00:00 | 2017-08-06 00:00:00 | =Selectable Date range |  |  |  |  |  | [NAME] | Driver | 500
Staff | Role | Days worked | Payment due |  |  |  |  |  |  | [NAME] | Driver | 500
[NAME] | Driver | 16 | 8000 |  |  |  |  |  |  | [NAME] | Helper | 400
 |  | =number of days [NAME] worked within date range | =number of days * Driver daily rate |  |  |  |  |  |  | [NAME] | Helper | 400
[NAME] | Driver
[NAME] | Driver
[NAME] | Helper
[NAME] | Helper
Spreadsheet: 850864d1701183070-shading-weekend-cloumns-meeting-rooms-aligw
Sheet: April 2024

 | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-13 00:00:00 | 2024-04-14 00:00:00 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | 2024-04-19 00:00:00 | 2024-04-20 00:00:00 | 2024-04-21 00:00:00 | 2024-04-22 00:00:00 | 2024-04-23 00:00:00 | 2024-04-24 00:00:00 | 2024-04-25 00:00:00 | 2024-04-26 00:00:00 | 2024-04-27 00:00:00 | 2024-04-28 00:00:00 | 2024-04-29 00:00:00 | 2024-04-30 00:00:00
 | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-13 00:00:00 | 2024-04-14 00:00:00 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | 2024-04-19 00:00:00 | 2024-04-20 00:00:00 | 2024-04-21 00:00:00 | 2024-04-22 00:00:00 | 2024-04-23 00:00:00 | 2024-04-24 00:00:00 | 2024-04-25 00:00:00 | 2024-04-26 00:00:00 | 2024-04-27 00:00:00 | 2024-04-28 00:00:00 | 2024-04-29 00:00:00 | 2024-04-30 00:00:00
BIG BOARDROOM: 0800-0900
BIG BOARDROOM: 0900-1000
BIG BOARDROOM: 1000-1100
BIG BOARDROOM: 1100-1200
BIG BOARDROOM: 1200-1300
BIG BOARDROOM: 1300-1400
BIG BOARDROOM: 1400-1500
BIG BOARDROOM: 1500-1600
BIG BOARDROOM: 1600-1700
SMALL BOARDROOM: 0800-0900
SMALL BOARDROOM: 0900-1000
SMALL BOARDROOM: 1000-1100
SMALL BOARDROOM: 1100-1200
SMALL BOARDROOM: 1200-1300
SMALL BOARDROOM: 1300-1400
SMALL BOARDROOM: 1400-1500
SMALL BOARDROOM: 1500-1600
SMALL BOARDROOM: 1600-1700
Spreadsheet: 47566d1246611854-fixing-cells-steve-macro-test
Sheet: Weekly_Archieve_All_Data2

This Month Progress so Far
Date | Total Open to Date | Raised This Month | Closed This Month
2009-06-25 00:00:00 | 82 | 7 | 4
2009-06-27 00:00:00 | 83 | 9 | 4
2009-06-27 00:00:00 | 84 | 2 | 3
2009-07-01 00:00:00 | 86 | 2 | 1
2009-07-03 00:00:00 | 80 | 1 | 3
Spreadsheet: 41943d1240489259-sustaining-information-engineering-projects-1-jan-2009
Sheet: Delivery Chart

 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
Total Projects | 256 | 233 | 217 | 236 | 222 | 239 | 248 | 273 | 282 | 306 | 298 | 293 | 318
Completed On-Time | 50 | 24 | 27 | 46 | 20 | 28 | 40 | 27 | 32 | 42 | 45 | 48 | 40
Completed Late | 13 | 8 | 3 | 3 | 2 | 2 | 3 | 2 | 1 | 5 | 4 | 3 | 2
Total Completed | 63 | 32 | 30 | 49 | 22 | 30 | 43 | 29 | 33 | 47 | 49 | 51 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% On-Time | 0.7936507936507936 | 0.75 | 0.9 | 0.9387755102040817 | 0.9090909090909091 | 0.9333333333333333 | 0.9302325581395349 | 0.9310344827586207 | 0.9696969696969697 | 0.8936170212765957 | 0.9183673469387755 | 0.9411764705882353 | 0.9523809523809523
[NAME] | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95
 |  |  | 0.9523809523809523 | Complete On-Time |  |  |  | 0.04761904761904767 | Completed Overdue