tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b8b4bbee-1b86-4bd0-b90d-f4f30a0a3d03
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CEA | Test | CEA | Carcinoembryonic Antigen (CEA), Serum | Carcinoembryonic Ag (CEA), S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Nonsmokers: < or =3.0 ng/mL Some smokers may have elevated CEA, usually <5.0 ng/mL. Serum markers are not specific for malignancy, and values may vary by method. | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 82378 |  |  |  |  | Rochester
CEA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CEA | Result | CEA | Carcinoembryonic Ag (CEA), S | Carcinoembryonic Ag (CEA), S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2039-6 | Carcinoembryonic Ag:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 757983d1638551564-return-different-values-based-on-column-contents-array-excel-problem-aligw
Sheet: Sheet1

[NAME]
Heavenly Milk Pistachio | YES | YES | NO
Evaporated Milk | NO | NO | NO
Condensed Milk | NO | NO | NO
Cream | NO | NO* | NO
[NAME] | NO | NO | NO*
[NAME] | YES | YES | NO
Spreadsheet: 171801d1343864472-how-to-convert-duplicated-rows-into-single-rows-extracting-some-data-from-deleted-rows-sample-input-output
Sheet: Sheet1

What I have |  |  |  |  |  |  |  |  | What I would like to have
[NAME] | Panidha | 1 | EC102 |  |  |  |  | [NAME] | Panidha | 1 | EC102 | EC400
[NAME] | Panidha | 1 | EC400 |  |  |  |  | [NAME] | Alia | 4 | EC102 | EC201
[NAME] | Panidha | 1 | EC201
[NAME] | Alia | 4 | EC102
[NAME] | Alia | 4 | EC201
Spreadsheet: 268990d1380908472-average-of-data-excluding-gaps-formula-test
Sheet: Sheet1

Date | Time | Data | Flag | Average
01 01 2013 | 00:00:00 | 10
01 01 2013 | 01:00:00 | 8
01 01 2013 | 02:00:00 | 8
01 01 2013 | 03:00:00 | 9
01 01 2013 | 04:00:00 | 5
01 01 2013 | 05:00:00 | 10
01 01 2013 | 06:00:00 | 13
01 01 2013 | 07:00:00 | 14
01 01 2013 | 08:00:00 | 12
01 01 2013 | 09:00:00 | 15
01 01 2013 | 10:00:00 | 18
01 01 2013 | 11:00:00 | 21
01 01 2013 | 12:00:00 | 16
01 01 2013 | 13:00:00 | 22
01 01 2013 | 14:00:00 | 25
01 01 2013 | 15:00:00 | 17
01 01 2013 | 16:00:00 | 14
01 01 2013 | 17:00:00 | 13
01 01 2013 | 18:00:00 | 10
01 01 2013 | 19:00:00 | 7
01 01 2013 | 20:00:00 | 8
01 01 2013 | 21:00:00 | 7
01 01 2013 | 22:00:00 | 10
01 01 2013 | 23:00:00 | 12
01 02 2013 | 00:00:00 | 13
01 02 2013 | 01:00:00 | 14
Spreadsheet: 698199d1601852173-how-to-take-monthly-average-based-on-dates-electric
Sheet: Sheet6

Utility | Utility | Month | LMP(BGE) | LMP(PECO) | Onpeak BGE | Offpeak BGE
BGE |  | 2016-01-01 00:00:00
PECO
Spreadsheet: 687547d1595270680-budgeting-spreadsheet-example-4
Sheet: Sheet1

Paycheck | Amount | Date Paid
Paycheck #1 | 1000 | 15th
Paycheck #2 | 500 | 26th
Paycheck #3 | 1000 | 31st
 |  |  |  |  |  |  | $1000 - 15 | $500 -26 | $1000 - 31
 |  |  |  |  | Bills | Due Date | Paycheck #1 | Paycheck #2 | Paycheck #3
 |  |  |  |  | Mortgage | 1 | 500 |  | 500
 |  |  |  |  | Insurance | 4 |  | 75
 |  |  |  |  | Car Payment | 12 | 250 |  | 250
Bills | Due Date | Amount |  |  | Electric | 13 |  | 60
Mortgage | 1st | 1000 |  |  | Gas | 27 |  | 40
Car Payment | 10th | 500 |  |  | Credit Card | 18 |  | 75
Electric | 12th | 60 |  |  | Water | 27 |  | 40 | 100
Gas | 13th | 50 |  |  | Totals
Water | 27th | 40
Insurance | 4th | 75
Credit Card | 18th | 100
Step 1
In B2 through B4 person will enter amount of paycheck
Step 2
In C2 through C5 person will enter date paid
Step 3
In A10 through A16 person will enter bills and in the following columns they will enter due dates and the amount due.  I would like the formula to only place the amount due in that box if it falls before or after the date paid they selected. (Example, I do not want to have it list the "Water" bill in the Column for Paycheck #1 or Paycheck #3.  Make sense?
Step 4
In the boxes H7 through K13 I would like a formula that will put the amount due based on paycheck date and due date of the bills, and I would also like to split the payments up as to not consume the entire paychecks (Ex. Mortgage is $1000.00 and would like that split up between at least two paychecks.
Ultimate goal is to have this calculate how much money from each check should be set aside to cover the bills for the entire month.  Which means that the totals in columns H, I, and J, cannot exceed the amounts of each paycheck.  Is that even possible? SEE my note for checking this. If it happens you must manually correct so it is not a problem
Spreadsheet: 703277d1604926847-sales-reoport-sums-raw-data-teh-looks-at-start-price-and-expire-price-sales-test
Sheet: Price

List | [NAME] | Item Number | UM | Start | Expire | T | Min Qty | Amount
20001100 | EUR | 13015201 | EA | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 12.5
20001100 | EUR | 13015401 | EA | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 23
20001000 | EUR | 14258501 | EA | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 5.81
20001000 | EUR | 14469401 | EA | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 3.383
20001000 | EUR | 14258101 | EA | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 3.383
20001100 | EUR | 14258301 | EA | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 23
20001100 | EUR | 14469501 | EA | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 23
20001100 | EUR | 14538301 |  | 2020-01-01 00:00:00 | 2020-05-31 00:00:00 | P | 0 | 12.5
20001100 | EUR | 14538401 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 14258401 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 13015701 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 14818301 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 14818201 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 14818401 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 14818501 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 14469301 | EA | 2020-01-01 00:00:00 |  | P | 0 | 30.34
20001100 | EUR | 13015101 | EA | 2020-01-01 00:00:00 |  | P | 0 | 12.5
20001100 | eur | 13015501 | EA | 2020-01-01 00:00:00 |  | P | 0 | 12.5
20001100 | EUR | 13015301 | EA | 2020-01-01 00:00:00 |  | p | 0 | 12.5
20001100 | eur | 14469701 | ea | 2020-01-01 00:00:00 |  | p | 0 | 12.5
20001100 | eur | 14258701 | ea | 2020-01-01 00:00:00 |  | p | 0 | 12.5
20001100 | eur | 68931923 | ea | 2020-01-01 00:00:00 |  | p | 0 | 12.5
20001100 | EUR | 68931922 | EA | 2020-01-01 00:00:00 |  | P | 0 | 23
20001100 | EUR | 68931921 | EA | 2020-01-01 00:00:00 |  | P | 0 | 12.5
20001100 | EUR | 68931920 | EA | 2020-01-01 00:00:00 |  | p | 0 | 12.5
20001100 | EUR | 13015201 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
20001100 | EUR | 13015401 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
20001000 | EUR | 14258501 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
20001000 | EUR | 14469401 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
20001000 | EUR | 14258101 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
20001100 | EUR | 14258301 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
20001100 | EUR | 14469501 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
20001100 | EUR | 14538301 |  | 2020-05-31 00:00:00 |  | P | 0 | 10
20001100 | EUR | 14538401 | EA | 2020-05-31 00:00:00 |  | P | 0 | 10
Spreadsheet: 189548d1351223766-current-streak-of-0s-in-a-list-example
Sheet: Kings Stats

# | PLAYER NAME | BY | P | GP | G | A | PTS | P/G | PP | SH | GW | PIM
22 | [NAME] | '94 | F | 12 | 2 | 9 | 11 | 0.9 | 1 | 0 | 0 | 17
15 | [NAME] | '94 | F | 17 | 7 | 3 | 10 | 0.6 | 4 | 0 | 1 | 8
7 | [NAME] | '94 | F | 17 | 4 | 5 | 9 | 0.5 | 1 | 0 | 1 | 17
27 | [NAME] | '95 | D | 16 | 2 | 7 | 9 | 0.6 | 1 | 0 | 0 | 16
10 | [NAME] | '92 | D | 17 | 0 | 9 | 9 | 0.5 | 0 | 0 | 0 | 14
14 | [NAME] | '94 | F | 14 | 5 | 3 | 8 | 0.6 | 1 | 0 | 2 | 10
13 | [NAME] | '92 | F | 17 | 4 | 4 | 8 | 0.5 | 1 | 0 | 1 | 8
25 | [NAME] | '95 | F | 17 | 3 | 4 | 7 | 0.4 | 0 | 0 | 1 | 8
8 | [NAME] | '92 | F | 15 | 1 | 6 | 7 | 0.5 | 0 | 0 | 0 | 12
11 | [NAME] | '93 | F | 7 | 3 | 3 | 6 | 0.9 | 2 | 0 | 0 | 7
9 | [NAME] | '94 | F | 17 | 4 | 1 | 5 | 0.3 | 0 | 0 | 0 | 0
20 | [NAME] | '94 | D | 15 | 2 | 3 | 5 | 0.3 | 1 | 0 | 0 | 24
24 | [NAME] | '94 | D | 17 | 1 | 4 | 5 | 0.3 | 0 | 1 | 0 | 19
18 | JJ Coleshaw | '94 | F | 8 | 1 | 3 | 4 | 0.5 | 0 | 0 | 0 | 2
12 | [NAME] | '93 | F | 16 | 2 | 1 | 3 | 0.2 | 0 | 0 | 0 | 8
17 | [NAME] | '93 | F | 17 | 1 | 2 | 3 | 0.2 | 0 | 0 | 0 | 28
44 | Brayden Low | '94 | F | 10 | 1 | 2 | 3 | 0.3 | 0 | 0 | 0 | 6
3 | [NAME] | '94 | D | 11 | 0 | 3 | 3 | 0.3 | 0 | 0 | 0 | 10
- | [NAME] | '93 | FW | 4 | 0 | 3 | 3 | 0.8 | 0 | 0 | 0 | 2
16 | [NAME] | '93 | D | 12 | 0 | 2 | 2 | 0.2 | 0 | 0 | 0 | 0
2 | [NAME] | '92 | D | 6 | 0 | 2 | 2 | 0.3 | 0 | 0 | 0 | 2
4 | [NAME] | '93 | D | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14
 | TEAM TOTALS |  |  |  | 43 | 79 | 122 | - | 12 | 1 | - | 232
# | GOALIE | BY | GP | W | L | T | G | A | PIM | SO | MP | GA | GAA | SH | SA | SV%
33 | [NAME] | '94 | 14 | 7 | 7 | 0 | 0 | 0 | 0 | 1 | 823 | 32 | 2.33 | 360 | 328 | 0.911
35 | Braeden Ostepchuk Rookie | '93 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 198 | 9 | 2.73 | 121 | 112 | 0.926
Spreadsheet: 861431d1709290383-formule-to-show-multiples-of-1-cel-only-order-form-multiples-aligw
Sheet: Blad1

Product | Min. order quantity | order quanity |  | These columns to be hidden!
Item A | 24 | 48 |  |  | 48 | 72 | 96 | 120 | 144 | 168 | 192 | 216 | 240
Item B | 56 | 392 |  |  | 112 | 168 | 224 | 280 | 336 | 392 | 448 | 504 | 560
Spreadsheet: 101997d1300065185-multiple-function-not-performing-wkbk-for-post
Sheet: Adjusting Balances

Owner Name of Record  LAST NAME | FIRST NAME | Prop Id | Site Address | Blk | Lot | City | St | Zip | Balance  Due Dec 2010 | 2011 Fees | 2011 Balance Due | Last Pmt Amt | Last Pmt Date | 2011 Balance Aftr 2011 Pmts | NOTES | Owner/Mailing Address | City | St | Zip
Acosta | Mark | 0 | 1515 Charles | 4 | 42 | Anytown | Tx | 22222 | 80 | 120 |  |  | 2010-03-17 00:00:00
[NAME] | Jan | 4 | 2399 Haden | 7 | 4 | Anytown | Tx | 22222 | 450 | 120 |  | 10 | 2011-04-15 00:00:00
[NAME] | Sue | 7 | 14356 Winden | 9 | 3 | Anytown | Tx | 22222 | -10 | 120 |  |  | 2010-12-23 00:00:00
Spreadsheet: 37b8adc0-79ba-4103-be26-d6b499865ede
Sheet: Sheet1

النموذج ألف - سين |  |  |  |  |  |  |  |  |  | FORM A-S
[NAME]
نموذج الابلاغ عن النقل الجوي
الحركة - الناقلون الجويون التجاريون
[NAME]: |  |  | الدولة:
المنظمة:
الهاتف:
[NAME]:
البريد الالكتروني: |  |  | السنة:
 |  |  | إجمالي جميع الخدمات
 |  |  | (الركاب والبريد والشحن |  |  |  |  | خدمات الشحن الصِرف فقط
 |  |  | [NAME] في ذلك طائرات الشحن الصِرف) |  |  |  |  | (مشمولة في بيانات العمودين (أ) و(د))
رمز | الوصف | الوحدة |  | [NAME] حسب [NAME] |  |  |  | [NAME] حسب [NAME]
الايكاو |  |  | دولي |  | مجلي |  | دولي |  | محلي
 | (أ) | (ب) | (ج) |  | (د) |  | (ﻫ) |  | (و)
 | الرحلات المنتظمة الايرادية
1010 | 1.   كيلومترات الطائرة | 000
1020 | 2.   مغادرات الطائرة | number
1030 | 3.   ساعات الطائرة | number
1040 | 4.   الركاب المنقولون | number
1050 | 5.   [NAME] الشحن المنقولة | number
1060 | 6.   الركاب الكيلومتريون المنقولون | 000
1070 | 7.   [NAME] المتاحة | 000
1080 | 8.   عامل حمولة الركاب | %
1091 | 9.   [NAME] المنقولة                                       .               أ) [NAME] ([NAME] في ذلك الأمتعة) | 000
1092 | (ب) الشحن (بما في [NAME]) | 000
1093 | (ج) البريد | 000
1094 | (د) إجمالي 9أ إلى 9ج) | 000
1100 | 10.  [NAME] المتاحة | 000
1110 | 11.  عامل حمولة الوزن | %
2010 | الرحلات غير المنتظمة الايرادية                                              12.   كيلومترات الطائرة | 000
2020 | 13.   مغادرات الطائرة | number
2030 | 14.   ساعات الطائرة | number
2040 | 15.   الركاب المنقولون | number
2050 | 16.   [NAME] المنقولة | number
2060 | 17.   الركاب الكيلومتريون المنقولون | 000
2070 | 18.   [NAME] المتاحة | 000
2091 | 19.   [NAME] المنقولة                                       .              (أ) [NAME] ([NAME] في ذلك الأمتعة) | 000
2092 | (ب) الشحن (بما في [NAME]) | 000
2093 | (ج) البريد | 000
2094 | (د) إجمالي 9أ إلى 9ج) | 000
2100 | 20.   [NAME] المتاحة | 000
3020 | رحلات التاكسي الجوي الايرادية                                           21.   مغادرات الطائرة | number
3030 | 22.   ساعات الطائرة | number
2330 | الرحلات غير الايرادية 23.   ساعات الطائرة | number
الملاحظات (بما في [NAME] أي حيود لا يمكن تفاديه عن تعليمات الابلاغ):
Spreadsheet: 65689d1266368463-searching-multiple-variables-template-test
Sheet: Sheet1

TransDate | [NAME] | Product | TransType | Amount
2008-12-10 00:00:00 | 3 | 4 | 19 | 9000
2008-12-10 00:00:00 | 2 | 3 | 19 | 5000
2008-12-10 00:00:00 | 3 | 6 | 19 | 9000
2008-12-10 00:00:00 | 2 | 4 | 19 | 5000
2008-12-11 00:00:00 | 6 | 3 | 19 | 1000
2008-12-11 00:00:00 | 3 | 3 | 19 | 7000
2008-12-12 00:00:00 | 3 | 2 | 19 | 5500
2008-12-12 00:00:00 | 2 | 1 | 19 | 9000
2008-12-12 00:00:00 | 6 | 4 | 19 | 6000
Spreadsheet: c215de7e-1c7e-4d82-bcef-05a59d58040e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TLRU | Test | TLRU | Thallium, Random, [NAME] | Thallium, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 1 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 1 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-1 mcg/L Reference values apply to all ages. | Tuesday, Thursday; 3 p.m. | 1 day | 5 days | 1 | 83789 |  |  |  |  | Rochester
TLRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
TLRU | Result | 60324 | Thallium, Random, U | Thallium, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5745-5
Spreadsheet: 011bde9b-ea3a-4bd0-9e94-2d590e0d1a03
Sheet: October

Year End: | October
Year:
Monthly CACFP Reimbursement:
Monthly Food Program Expenses:
Amount Needed from Other Funding Source:
Date | Check Number | Name (Payee on Check) | Total Amount of Check | Administrative Salaries and Benefits | Travel Expenses (include monitoring staff) | Printing, Office Supplies, Communications | Staff Training | Food Service Salaries and Benefits | Food (include delivery charges) | Purchased Vended Meals | Food Service Equipment | Allowable Nonfood Supplies | Occupancy/ Utilities | [NAME]. | Specify Misc.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Monthly CACFP Expenses:
End of worksheet
Spreadsheet: 85663d1285734057-if-formula-helphere
Sheet: Sheet1

Sale(Book) | %
250 & above | 1
226 - 249 | (Book/ 500) -4
225 | 0.5
224 &  below | 0
Sales - how to set formula at column c with link paremeter upper.
Name | Sale | %
[NAME] | 258 | 0.17634996582365 | <<<[NAME] has Relative and Absolute range
Angeline | 230 | 0.1572112098427888
[NAME] | 240 | 0.1640464798359535
[NAME] | 210 | 0.1435406698564593
[NAME] | 225 | 0.1537935748462064
[NAME] | 300 | 0.2050580997949419
 | 1463 | <<<Total
Another guess.
Sales - how to set formula at column c with link paremeter upper.
Name | Sale
[NAME] | 258 | 1 | <<< Try this one also….
Angeline | 230 | 0.42 | <<< I think this is what you want
[NAME] | 240 | 0.44
[NAME] | 210 | 0
[NAME] | 225 | 0.5
[NAME] | 300 | 1
Spreadsheet: 719413d1613658835-sumifs-formula-not-valid-value-hh_job_-template_2021
Sheet: Bonus WK 1

 | Week 1 - Bonus Hours
 | Begin Date:
 | End Date:
 | Employee | Bonus Hours
Spreadsheet: 101655d1299745913-data-lookup-and-insertion-sample
Sheet: A

Product ID | Quantity | Price
1 | 7 | 56
2 | 2 | 23
3 | 8 | 52
4 | 1 | 11
5 | 0 | 14
6 | 10 | 89
7 | 9 | 27
8 | 3 | 7
Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: Fri-Sat-Sun After Midnight 

DATE | DAY |  | PRE-START OVERTIME |  |  |  |  | 1st. HALF |  |  | UNPAID BREAK | 2nd. HALF |  |  |  | TOTAL HOURS WORKED |  | BUILD-UP TIME DEDUCTED (Mins) |  | BALANCE OF TIME DUE FOR PAYMENT | TOTAL SPREAD |  | [NAME] (VOT) PLUS ALL ROSTERED WORK THAT EXCEEDS 8.25hrs                                                                                                                                           That is any work that is rostered or voluntarily accepted in a shift that exceeds 8.25 hrs |  |  |  |  |  |  |  |  |  | EARLY-LATE PENALTY
 |  |  | START | END | [NAME]:mins | [NAME] |  | START | END | HOURS WORKED |  | START | END | HOURS WORKED |  | Hrs:mins | [NAME] | Hrs:mins | [NAME] |  |  |  | START | END | [NAME]:mins | [NAME] |  | TOTAL HOURS WORKED | DEFAULT HOURS PAID | 0.5 | 1 |  | HOURS
WEEK 1
 | Friday |  | 00:00:00 | 00:00:00 |  |  |  | 05:32:00 | 10:11:00 |  |  | 13:43:00 | 17:24:00 |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
 | Saturday |  | 00:00:00 | 00:00:00 |  |  |  | 07:18:00 | 11:25:00 |  |  | 12:15:00 | 16:48:00 |  |  |  |  |  |  |  |  |  | 16:45:00 | 17:45:00 |  |  |  |  |  |  | 0
 | Sunday
WEEK 2
 | Friday |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
 | Saturday |  | 00:00:00 | 00:00:00 |  |  |  | 05:39:00 | 09:50:00 |  |  | 10:40:00 | 14:44:00 |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
 | Sunday
Spreadsheet: 683982d1593091134-problems-with-vlookup-infromation-slight-different-does-not-match-book1
Sheet: Sheet1

 | CLAIMANT NAME (copy the name excatly as  on the build) | IS CUSTOMER STILL  ON YOUR  CASELOAD (remove if NO) |  |  | SELECT OR TYPE | Method of contact - Phone/Journal | YES OR NO | YES OR NO
has han extra space | RAJ BAINS |  |  |  | Administration | PHONE | YES | YES-CANNOT WORK
 | RAJ BAINS |  |  |  | Childcare
writen surname 1st | BAINS RAJ |  |  |  | Civil Service
 |  |  |  |  | Construction
 |  |  |  |  | Delivery
 |  |  |  |  | Driving
 |  |  |  |  | Education
 |  |  |  |  | Facilities Management/Cleaning
 |  |  |  |  | Hospitality/Entertainment
 |  |  |  |  | IT
 |  |  |  |  | Retail
 |  |  |  |  | Security
 |  |  |  |  | Warehousing/Logistics
 |  |  |  |  | Working from Home
Spreadsheet: 878625d1725801060-calculate-earliest-start-date-and-time-based-on-deadline-date-and-time-and-duration-calculate-earliest-start-date-and-time-based-on-deadline-date-and-time-and-duration
Sheet: Sheet1 (3)

Calculate earliest start date and time based on deadline date and time and duration
[NAME]
Deadline | Duration (hrs) | Start Date | Duration (hrs) |  | Operational Days/Hours
 |  |  |  |  | Mon | Fri | Total Hrs
 |  |  |  |  | 09:00:00 | 17:00:00
Random date/time
Adjusted for Sat/Sun
Hours in deadline date/time
Remaining hours
No. of working days
Remaining hours
Estimated start date
Estimated start date/time
Combined formula
Workings:
Date
2024-01-01 00:00:00
Spreadsheet: 0d925d71-1569-4c53-b364-6005ba1a193b
Sheet: Sheet1

Table S8: Rescue experiments with hyx-wt-HA and hyx-A2P-HA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
yw, [NAME]; A2P-HA/CyO; FRT83, hyx2/TM6B x CM01 (yw,hsFLP; Sp/CyO; P9y+,hyx1/TM6B) |  |  |  |  |  |  | expectation: of 8 genotypes that survive 2 are rescued.
Genotype/Rescue Temperature |  |  |  |  |  |  |  | 1/4th are rescued flies
18°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 234
hyx1/hyx2 | 54 | 72 | 4.5 | P=0.033894854
Total | 288 |  |  | 0.034
25°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 873
hyx1/hyx2 | 256 | 282.25 | 2.441319751992914 | P=0.118
Total | 1129 |  |  | 0.12
29°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 329
hyx1/hyx2 | 51 | 95 | 20.37894736842105 | P=[PHONE]
Total | 380 |  |  | 6.3521e-06
yw, [NAME]; WT-HA/CyO; FRT82, hyx2/TM6B x CM01 (yw,hsFLP; Sp/CyO; P9y+,hyx1/TM6B)
18°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 862
hyx1/hyx2 | 333 | 298.75 | 3.926569037656904 | P=0.0475288
Total | 1195 |  |  | 0.0379
25°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 1209
hyx1/hyx2 | 471 | 420 | 6.192857142857143 | P=0.012826
Total | 1680 |  |  | 0.012826
29°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 389
hyx1/hyx2 | 98 | 121.75 | 4.632956878850103 | P=0.0313634
Total | 487 |  |  | 0.0314
yw, [NAME]; FRT82, hyx2/TM6B x CM01 (yw,hsFLP; Sp/CyO; P9y+,hyx1/TM6B) |  | Control
25°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 949
hyx1/hyx2 | 0 | 0
Total | 949
29°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 632
hyx1/hyx2 | 0 | 0
Total | 632
18°C | observed | expected | Chi_2 | P-Value
TM6B/hyx | 474
hyx1/hyx2 | 0 | 0
Total | 474
Spreadsheet: 727336d1617847165-calculating-a-future-date-based-on-months-sample-data
Sheet: Sheet1

Date of Last Inspection | Inspection Frequency (Mths) | Inspection Due
2020-03-24 00:00:00 | 12
2019-07-23 00:00:00 | 6
2019-09-03 00:00:00 | 3
2019-07-15 00:00:00 | 12
2019-11-18 00:00:00 | 6
2019-07-29 00:00:00 | 3
2020-03-17 00:00:00 | 12
2020-03-23 00:00:00 | 6
2020-03-23 00:00:00 | 3
2020-03-23 00:00:00 | 12
2019-06-17 00:00:00 | 6
2019-07-17 00:00:00 | 3
Mths | Days
12 | 365
6 | 183
3 | 91
Spreadsheet: 112548d1308665662-graphing-ranges-range-graphing-dilemma
Sheet: Green Marks

 | 2 | 2 |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Store X | Threshold - 50th | Benchmk 95th | Green Start | Base- Line | Current Perf |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Measure #1 | 66.02 | 82.52 | 64 | 66.07060981201244 | 66 | 64 | 66.315 | 68.63 | 70.945 | 73.25999999999999 | 75.575 | 77.89 | 80.205 | 82.52
Measure #2 | 75 | 84.7 | 71.84777947990081 | 70.3977794799008 | 72 | 71.84777947990081 | 73.45430704491321 | 75.0608346099256 | 76.667362174938 | 78.2738897399504 | 79.8804173049628 | 81.4869448699752 | 83.0934724349876 | 84.7
Measure #3 | 79.42 | 89 | 82.0066155814025 | 81.2166155814025 | 85 | 82.0066155814025 | 82.88078863372719 | 83.75496168605187 | 84.62913473837656 | 85.50330779070126 | 86.37748084302594 | 87.25165389535063 | 88.12582694767531 | 89
Measure #4 | 59.28 | \ | 57 | 56.2515821606725 | 58.5 | 57 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Measure #5 | 61.82 | 77.69 | 63.57888305204094 | 62 | 60 | 63.57888305204094 | 65.34277267053582 | 67.10666228903071 | 68.87055190752558 | 70.63444152602047 | 72.39833114451535 | 74.16222076301023 | 75.92611038150511 | 77.69