tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 847276d1698286197-how-to-calculate-penalty-time-if-work-finishes-after-midnight-late-early-penalty-calculator_hans-formula
Sheet: Notes

ISSUE TO BE ADDRESSED | STATUS
When the time finishes after midnight use:
Normal shift work hours is considered as 8hrs 15mins
then 1.5 for 1st. 3 hrs then 2.0 after that
Ot or in excess of 38 hrs in 1 week
Check shift build up time
check 34.4
If you have a day off on a Saturday, are you paid time and a half?
How many hours is the default hours paid
NOTE TO PENALTY RATE CALCULATOR Cells G19, M19,G25, M25 | completed
Penalty rate of 15% is paid for the whole shift if you sign on after 5:00pm and finish before 7:00am excluding Saturdays, Sundays and Public Holidays | To be changed-in progress
Converesly if you sign on before 5.00pm and finish after 8:00pm your are paid the 15% penalty rate for the whole shift. For example if you start work at 1:50pm and finish at 8:05pm you are paid the 15% rate for the whole shift.
However if you start work before 7:00am and finish after 7:00am you are only paid the 15% penalty rate for those hours worked before 7:00am. For example if you start at 2:18am and finish at 8:30am the 15% rate only applies to 4 hours and 42 mins and rounded to the nearest 15 minutes.
In cells G19, M19,G25, M25 *0 inserted in the formula as Sunday, Saturday and Public Holidays not subjected to 15% penalty rate
Check hours build-up and how is it calculated | In progress
Is there such a thing as a broken shift penalty of 1.5 and 2.0? | In progress
ADO CANCELLATION IS PAID AT 1.5 FOR THE 1ST 3 HOURS AND 2.O AFTER THAT | In progress
See if i can get a copy of the State Transit Payroll Reference Manual
NOTE TO DAY OFF - Is it paid at the rate of 8 or 7.6 hrs
hrs
CHECK ALL THE HOURS ENTERED INTO CALCULATOR PARAMATERS
if you work longer than 8hr 15mins on a public holiday is the rate increased to double time
HOW TO CONVERT MINUTES TO A FRACTION OF HOUR
=A1*24
Make sure that the Pre-start entry madeispicked up by all cells related to it
in column AU it conflicts with time and a half in overtime .. Time and a half This should be captued in column AU only
Spreadsheet: 74278d1274823875-excel-2007-best-method-for-combinatorial-concatenation-template-threesheetpermutations
Sheet: Sheet4

G:2:xx
G:2:yy
G:4:xx
G:4:yy
G:6:xx
G:6:yy
G:8:xx
G:8:yy
G:10:xx
G:10:yy
G:12:xx
G:12:yy
H:2:xx
H:2:yy
H:4:xx
H:4:yy
H:6:xx
H:6:yy
H:8:xx
H:8:yy
H:10:xx
H:10:yy
H:12:xx
H:12:yy
I:2:xx
I:2:yy
I:4:xx
I:4:yy
I:6:xx
I:6:yy
I:8:xx
I:8:yy
[NAME]:xx
[NAME]:yy
I:12:xx
I:12:yy
J:2:xx
J:2:yy
J:4:xx
J:4:yy
J:6:xx
J:6:yy
[NAME]:xx
[NAME]:yy
J:10:xx
J:10:yy
J:12:xx
J:12:yy
Spreadsheet: 133229d1324300746-data-referencing-across-tabs-survey-input-example-forum-version-2
Sheet: Inman Summary

CENTRAL | DIV
INMAN | [NAME]
Pharmacy | Survey #'s | Survey #'s
DENMAN PHARM SERV | 57
HOME PHARM SERV | 24
[NAME] | 0
INTERLOCK COLUMBIA | 18
INTERLOCK FLORISSANT | 80
MANAGED HEALTHCARE | 36
MEDICATE FARMINGTON | 17
[NAME] | 20
[NAME] | 26
OCR MINNESOTA | 109
OCR NEBRASKA | 2
OCR PHARMACY MIDWEST | 34
OCR S DAKOTA | 38
OCR URBANDALE | 29
PHARMACY CARE ASSOC | 4
SEQUOIA OKLAHOMA | 67
[NAME] | 58
REGION TOTAL | 619
 | DENMAN PHARM SERV | HOME PHARM SERV | [NAME] | INTERLOCK COLUMBIA | INTERLOCK FLORISSANT | MANAGED HEALTHCARE | MEDICATE FARMINGTON | [NAME] | [NAME] | OCR MINNESOTA | OCR NEBRASKA | OCR PHARMACY MIDWEST | OCR S DAKOTA | OCR URBANDALE | PHARMACY CARE ASSOC | SEQUOIA OKLAHOMA | [NAME] | REGION AVE.
Pharmacy Average
Ease of ordering (e.g. fax, phone) process
Medication accuracy (i.e. Right Drug/Right Patient)
Routine scheduled deliveries are on time
Stats are delivered within an appropriate timeframe
Medical Records are accurate
Medical Records are received by the agreed upon date
Pharmacy billing statements are accurate
Overall rating of the pharmacy's ability to meet your needs
Expertise of infusion (IV) services personnel
Expertise of consultant pharmacist
Expertise of other pharmacy services (ie: nursing, QA tech, customer service)
Staff education
Drug information provided by Pharmacists is useful
Assistance in resolving facility or patient concerns
Timely response to facility or patient concerns
Understanding of facility or patient concerns
Courtesy of pharmacy staff
Clear explanation and timely communication about medications that are not available for your order
Overall rating of the pharmacy's ability to meet your expectations
Recommendation "Yes"
Recommendation  "No"
Recommendation "na"
Total
Spreadsheet: 1b1d87a2-2974-4110-8f78-69b34863191f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 79. Value of Building Approved, Chain Volume Measures, Original - New South Wales
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total houses ;  New ; |  |  | Original | A590477A | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total other residential building ;  New ; |  |  | Original | A590478C | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  New ; |  |  | Original | A590479F | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590480R | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590481T | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590482V | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590483W | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 214061d1360786088-count-if-the-data-mathces-copy-of-advise
Sheet: template

Building 1.1.2
 |  |  |  | Black | [NAME] | Magenta | Yellow | Printer Model
 |  |  |  |  |  |  | yes | MF8330
 |  |  |  |  |  | yes |  | x543
 |  |  |  |  |  |  |  | x940
 |  |  |  |  |  | yes | yes | x544
 |  |  |  | yes |  |  |  | c5045
 |  |  |  |  |  |  |  | Total
 | Total Send to female IT
 | Total Received from female IT
 |  | DAY SUMMARY
 |  | TOTAL TONERS BEING SENT
 |  | MF8330 |  | x543 |  | c5045 |  | x940
 | Black
 | [NAME]
 | Magenta
 | Yellow
Spreadsheet: 860882d1708897522-adding-a-name-word-to-a-range-of-cells-without-deleting-the-data-already-in-each-cell-add-names
Sheet: WORK SCHEDULE 2023

2024-02-26 00:00:00 |  |  | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-10 00:00:00 | 2024-02-11 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-24 00:00:00 | 2024-02-25 00:00:00 | 2024-02-26 00:00:00 | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00 | 2024-03-01 00:00:00 | 2024-03-02 00:00:00 | 2024-03-03 00:00:00 | 2024-03-04 00:00:00 | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00 | 2024-03-11 00:00:00 | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00 | 2024-03-18 00:00:00 | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2025-01-11 00:00:00 | 2025-01-12 00:00:00 | 2025-01-13 00:00:00 | 2025-01-14 00:00:00 | 2025-01-15 00:00:00 | 2025-01-16 00:00:00 | 2025-01-17 00:00:00 | 2025-01-18 00:00:00 | 2025-01-19 00:00:00 | 2025-01-20 00:00:00 | 2025-01-21 00:00:00 | 2025-01-22 00:00:00 | 2025-01-23 00:00:00 | 2025-01-24 00:00:00 | 2025-01-25 00:00:00 | 2025-01-26 00:00:00 | 2025-01-27 00:00:00 | 2025-01-28 00:00:00 | 2025-01-29 00:00:00 | 2025-01-30 00:00:00 | 2025-01-31 00:00:00
 |  |  | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri
Annual Leave RDO / Leave  Leave Aproved |  |  | Hayden | Hayden ShaunA | [NAME] | ShaunA |  |  |  | Hayden | [NAME] SteveC | ShaunA | ShaunA | [NAME] |  |  |  |  |  |  | Scott | Scott | Scott | Scott | [NAME] ShaunA SteveP | [NAME] ShaunA | [NAME] ShaunA | [NAME] | [NAME] | Hayden Nathan Scott | Hayden [NAME] | Hayden Margaret Scott Simon |  |  | DaveH [NAME] | DaveH [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 224f2475-c732-46c6-9712-75a7a202778f
Sheet: Sheet1

 | Year to Year Fuel Cost Comparison
 | Developed by [NAME], University of Nebraska-Lincoln Exension Educator
 |  |  |  |  |  |  |  |  |  | Revised 2/14/2013
 |  | Fuel use estimates are from Machinery Cost Estimates by [NAME], University of Minnesota.
 |  | Only  the fuel prices for 2013 and 2014 (in blue font ) can be changed by the user
 |  | Note:  When adding fuel prices for 2013 and 2014, change the price in Table 1 on row 11 and in Table 2 on row 39.
 | Prices for non-tax #2 diesel are taken from Futures-Based Price Forcasts for Non-taxable Diesel Fuel by [NAME], Kansas State University.
 | Table 1. Diesel cost per hour for various power units
 |  |  |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
 |  |  | Estimated | 1.886 | 2.165 | 2.348 | 3.68 | 1.96 | 2.45 | 3.41 | 3.43 | 0 | 0
 |  |  | Fuel use
 |  |  | Gal/hour | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr
 | Tractors
 |  | 40 HP | 1.8
 |  | 60 HP | 2.6
 |  | 75 HP | 3.3
 |  | 105 HP | 4.6
 |  | 130 HP | 5.7
 |  | 160 HP | 7
 |  | 200 HP | 8.8
 |  | 225 HP | 9.9
 |  | 260 HP | 11.4
 |  | 310 HP | 13.6
 |  | 360 HP | 15.8
 |  | 425 HP | 18.7
 | Combines
 |  | 190 HP | 8.4
 |  | 220 HP | 9.7
 |  | 275 HP | 12.1
 | Table 2.   Diesel fuel cost per acre for field operations
 |  |  |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
 |  |  | #2 diesel $/gal | 1.886 | 2.165 | 2.348 | 3.68 | 1.96 | 2.45 | 3.41 | 3.43 | 0 | 0
 |  |  | Est. Fuel Use  Gal/acre
 | Tillage
 | Field Cultivator |  | 0.33
 | [NAME] |  | 0.47
 | [NAME] (HD) |  | 0.76
 | Planting
 | Row Crop Planter |  | 0.34
 | Minimum Till Planter |  | 0.53
 | [NAME] |  | 0.49
 | [NAME] |  | 0.63
 | No-Till Drill |  | 0.81
 | [NAME]
 | Cultivator |  | 0.46
 | Rotary Hoe |  | 0.18
 | Boom Sprayer |  | 0.11
 | Anhydrous Applicator |  | 0.55
 | Stalk Shreader |  | 0.74
 | Harvesting
 | [NAME] |  | 0.4
 | [NAME] |  | 0.35
 | Hay Baler PTO (twine) |  | 0.4
 | Round Baler (1500 lb) |  | 0.77
 | Combine (various heads) |  | 2
 | For information on how to use this data, see UNL's CropWatch.unl.edu or the UNL Extension Lancaster County Acreage, Farm & Ranch website at http://lancaster.unl.edu/ag/.
Spreadsheet: 092f41ad-d22e-481a-a542-99ad8f5414bb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
INDUSTRIAL SAFETY & TRAINING SERVICES | 9000
GLOBAL RESILIENCY CONSULTING | 17000
DISASTER RESISTANT COMMUNITIES GROUP | 19350
PATRIOT SERVICES CORP. & HAGERTY CONSULTING | 19905
PRE-EMERGENCY PLANNING, LLC | 19995
ARMADA, LTD | 24000
CEMA | 26975
LIGHTHOUSE READINESS GROUP, INC | 29180
THE OLSON GROUP, LTD | 37500
AMEC | 48000
MTSS IT SOLUTIONS, INC | 51137.2
WITT/O'BRIEN'S | 67850
Spreadsheet: 472307d1469538174-validate-month-consistent-oeldere-472302d1469536446-validate-month-consistent-book1
Sheet: Sheet1

ENTITY_ID | ACTIVITY_DATE |  |  | Consistency
80001872 | 05-JAN-11 |  |  | 0
80001872 | 14-FEB-11 |  |  | 0 |  | There is a consistent between previous month to this month therefore this is counted as "1"
80001872 | 2011-03-11 00:00:00 |  |  | 0
80001872 | 13-APR-11 |  |  | 0
80001872 | 01-JUN-11 |  |  | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 12-JUL-11 |  |  | 0
80001872 | 19-AUG-11 |  |  | 0
80001872 | 20-SEP-11 |  |  | 0
80001872 | 2011-10-25 00:00:00 |  |  | 0
80001872 | 09-DEC-11 |  |  | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 20-JAN-12 |  |  | 0
80001872 | 2012-03-15 00:00:00 |  |  | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 17-APR-12 |  |  | 0
80001872 | 2012-05-16 00:00:00 |  |  | 0
80001872 | 02-JUN-12 |  |  | 0
80001872 | 28-JUN-12 |  |  | 0
80001872 | 2012-08-09 00:00:00 |  |  | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 11-SEP-12
80001872 | 2012-10-11 00:00:00
80001872 | 11-NOV-12
80001872 | 04-DEC-12
80001872 | 01-JAN-13
80001872 | 31-JAN-13
80001872 | 02-APR-13
80001872 | 2013-05-01 00:00:00
80001872 | 2013-05-31 00:00:00
80001872 | 04-JUL-13
80001872 | 30-JUL-13
80001872 | 23-AUG-13
80001872 | 26-SEP-13
80001872 | 20-NOV-13
80001872 | 08-JAN-14
80001872 | 07-FEB-14
80001872 | 09-APR-14
80001872 | 2014-05-07 00:00:00
80001872 | 03-JUN-14
80001872 | 03-JUL-14
80001872 | 08-AUG-14
80001872 | 05-SEP-14
80001872 | 2014-10-02 00:00:00
80001872 | 2014-11-05 00:00:00
80001872 | 04-DEC-14
80001872 | 06-JAN-15
80001872 | 06-FEB-15
80001872 | 2015-03-05 00:00:00
80001872 | 04-APR-15
80001872 | 29-APR-15
80001872 | 2015-05-29 00:00:00
80001872 | 26-JUN-15
80001872 | 25-JUL-15
80001872 | 26-AUG-15
80001872 | 22-SEP-15
80001872 | 2015-10-30 00:00:00
80001872 | 28-NOV-15
80001872 | 31-DEC-15
80001872 | 28-JAN-16
80001872 | 27-FEB-16
80001872 | 2016-05-31 00:00:00
Spreadsheet: andy_zipper__340__Proforma
Sheet: Sheet1

POWER |  |  |  | Revenues/Gross Margin |  | Expense |  | VAR
East Power
 | Northeast trading
 | Midwest trading
 | Southeast trading
 | Ercot trading
 | Options
 | Fundamentals
 | Total
West Power
 | Trading
 | Fundamentals
 | Total
NATURAL GAS
 | East trading
 | Central trading
 | West trading
 | Financial trading
 | Texas trading
 | Fundamentals
 | Total
CANADA
 | Natural Gas
 | Alberta Power
 | Ontario Power
 | Total
 | Grand Total
Spreadsheet: 4a379d36-2171-4df4-9ad9-f8d1dfc7caa1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5769 | 40700 | Javier | Merida | ESP | 13 | 00:15:54 | 00:09:41 | 00:48:04 | [NAME] | 00:58:21 | 1 | 02:18:47
Spreadsheet: 90323d1290071627-2-columns-contains-data-like-1-2-and-2-3-now-i-want-output-as-1-3-in-new-sheet-sample
Sheet: Sheet1

Input Data
EmployeeID | Manager ID
435676 | 433854
433854 | 433636
433636 | 350335
350335 | 300054
Output Data
EmployeeID | Highest Manager ID
435676 | 300054
433854 | 300054
433636 | 300054
350335 | 300054
Spreadsheet: 1411aefb-134c-4774-9d4f-2cfeffb64692
Sheet: Sheet1

Flux_Name | FBA_Wildtype | FBA_Mutant | MOMA_Mutant
OF14ae_Retli | 0.166 | 0.3213 | 0.1657
EX_ala-L_e | 0 | 0 | 0.1435
EX_co2_e | 1.98 | 2.0258 | 1.794
EX_glu-L_e | -0.506 | -1.082 | -0.5358
EX_h_e | -2.276 | -1.7694 | -1.5515
EX_h2o_e | 0.842 | 0.4986 | 0.6151
EX_n2_e | -0.162 | -0.2622 | -0.2181
EX_o2_e | -1 | -1 | -0.9864
EX_succ_e | -0.802 | -0.1831 | -0.425
sink_inost | -0.01 | -0.01 | 0
ACACT1r | 0.166 | 0 | 0
ACONTa | 0 | 0 | 0.1544
ACONTb | 0 | 0 | 0.1544
AKGDH | 0 | 0 | 0.0196
ALAD_R | -0.166 | -0.3213 | -0.3092
ALAt2r | -0.166 | -0.3213 | -0.3092
ASADi | 0.166 | 0.3213 | 0.1657
ASDH | 0 | 0 | 0.0558
ASPKi | 0.166 | 0.3213 | 0.1657
[NAME] | 0.0325 | -0.7607 | 0.0211
ASPT_rev | -0.3645 | 0.1182 | -0.2967
ASPt2r | -0.166 | -0.3213 | -0.1657
ATPS2 | 3.238 | 3.7553 | 3.5419
CO2t | -1.98 | -2.0258 | -1.794
CS | 0 | 0 | 0.1544
CYSTL | 0 | 0 | 0.0108
CYSTS | 0 | 0 | 0.0081
CYTOX | 1 | 1 | 0.9298
[NAME] | 0 | 0 | 0.0566
DAPDC | 0.166 | 0.3213 | 0.1657
DAPE | 0.166 | 0.3213 | 0.1657
DHDPRx | 0.166 | 0.3213 | 0.11
DHDPRy | 0 | 0 | 0.0557
DHDPS | 0.166 | 0.3213 | 0.1657
EDA | 0 | 0 | 0.1162
EDD | 0 | 0 | 0.1162
ENO | -0.322 | 0.01 | -0.1459
FBA | -0.166 | 0 | -0.1162
FBP | 0.166 | 0 | 0.1162
FRNDPRR | 0.02 | 0.2855 | -0.1102
FUM | 0.9435 | 1.3833 | 0.8185
G5SADr | -0.3725 | 0 | -0.3614
G5SD | 0 | 0 | 0
G6PDH2 | 0 | 0 | 0.1162
GAPD | -0.322 | 0.01 | -0.1162
GLCS1 | 0.166 | 0 | 0
[NAME] | 0.166 | 0 | 0
GLUt2r | 0.506 | 1.082 | 0.5358
H2Ot | -0.842 | -0.4986 | -0.6151
HCO3E | 0 | 0 | 0.0219
ICDHx | 0 | -0.01 | 0.0281
ICL | 0 | 0.01 | 0.1263
INS2D | 0.01 | 0.01 | 0
INSCR | 0.01 | 0.01 | 0
MALS | 0 | 1000 | 0.0632
MALS_rhizobia | 0 | 900 | 0.0632
MDH | 0.9435 | 1.3933 | 0.9448
MMSAD3 | 0.01 | 0.01 | 0
[NAME] | 0.162 | 0.2622 | 0.2181
NADH_Rhizobium | 0.692 | 0.7349 | 0.8577
NADTRHD | 0 | 0 | 0.1117
NH3c | -0.166 | -0.3213 | -0.1657
NH3e | -0.166 | -0.3213 | -0.1657
NH3t | -0.166 | -0.3213 | -0.1657
NIT | 0.162 | 0.2622 | 0.2181
O2t | 1 | 1 | 0.9864
OORr | 0.506 | 1.072 | 0.5442
ORNCD | 0.3725 | 0 | 0.3614
ORNTAr | -0.3725 | 0 | -0.3614
PC | 0 | 0 | 0.0219
PDH | 0.322 | 0 | 0.2807
PGCDr | 0 | 0 | 0.0297
PGI | -0.166 | 0 | -0.1162
PGK | 0.322 | -0.01 | 0.1162
PGL | 0 | 0 | 0.1162
PGM | 0.322 | -0.01 | 0.1459
PGMT | -0.166 | 0 | 0
PHBS | 0.166 | 0 | 0
PHPB | 0.166 | 0 | 0
PPA | 0.166 | 0 | 0
PPCK | 0.976 | 0.6325 | 0.7775
PRO1x | 0.3725 | 0 | 0.3614
PSERTr | 0 | 0 | 0.0297
PSP_L | 0 | 0 | 0.0297
PYK | 0.654 | 0.6425 | 0.6316
SDPDS | 0.166 | 0.3213 | 0.1657
SDPTA | -0.166 | -0.3213 | -0.1657
SERD_Lr | 0 | 0 | 0.0189
SHSL1 | 0 | 0 | 0.0027
[NAME] | 0 | 0 | -0.0027
SSHy_Rhizobium | 0 | 0 | 0.0027
SUCCt2_2 | 0.802 | 0.1831 | 0.425
SUCD1 | 1.308 | 1.2651 | 1.1152
SUCD3 | 1.308 | 1.2651 | 1.1152
SUCOAS | -0.34 | -0.7507 | -0.3981
THD2 | 0.312 | 0.0358 | 0.3271
[NAME] | 0.166 | 0.3213 | 0.1657
TPI | -0.156 | 0.01 | -0.1162
Spreadsheet: 235063d1368312785-please-help-with-multiple-dependant-drop-down-lists-kartoshka-20130511
Sheet: Machines (2)

Machine type |  | Case inspector |  | Container dispersing unit |  | Container unmatching |  | Conveyor control |  | Conveyor regulation |  | Empty bottle sorting |  | Empty container inspector |  | Empty mould inspection |  | Foreign object detection |  | Full container inspection |  | Hardware interface and small control unit |  | IT product |  | Label check |  | Labelling machine |  | Leakage check |  | Residual liquid check |  | Ultrasonic fobbing |  | Miscellaneous |  | type | Machine model
Case inspector |  | HEUFT SPECTRUM GX |  | HEUFT relax |  | HEUFT streamer |  | HEUFT synchron |  | HEUFT speedy |  | HEUFT SPECTRUM SX |  | HEUFT InLine IR |  | HEUFT moCheck |  | HEUFT eXaminer XT |  | HEUFT SPECTRUM VX |  | HEUFT xio |  | HEUFT GATEWAY |  | HEUFT FinalView FO |  | HEUFT TORNADO D |  | HEUFT pakCheck |  | HEUFT fluid |  | HEUFT exciter |  | Upgrades |  | Conveyor regulation
Container dispersing unit |  | HEUFT SPECTRUM LX |  |  |  |  |  | HEUFT synchron BS |  |  |  |  |  | HEUFT InLine IS |  |  |  | HEUFT eXaminer XA |  | HEUFT basic |  |  |  | HEUFT STRATEGY GATE |  |  |  | HEUFT TORNADO flex |  | HEUFT squeezer QA |  |  |  |  |  | Rejectors
Container unmatching |  | HEUFT logic |  |  |  |  |  | HEUFT synchron DP |  |  |  |  |  | HEUFT InLine IX |  |  |  | HEUFT eXaminer XAC |  | HEUFT prime |  |  |  | HEUFT PROFILER TX |  |  |  | HEUFT TORNADO R |  | HEUFT squeezer QL |  |  |  |  |  | 2nd hand machines
Conveyor control |  |  |  |  |  |  |  | HEUFT synchron MC |  |  |  |  |  | HEUFT InLine IXS |  |  |  | HEUFT eXaminer XB |  | HEUFT spotter SF |  |  |  | HEUFT STRATEGY |  |  |  | HEUFT TORNADO R flex |  | HEUFT squeezer QS
Conveyor regulation |  |  |  |  |  |  |  | HEUFT synchron TX |  |  |  |  |  | HEUFT canLine |  |  |  | HEUFT eXaminer XO |  | HEUFT spotter PH |  |  |  |  |  |  |  | HEUFT TORNADO S |  | HEUFT squeezer QD
Empty bottle sorting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HEUFT s-vio |  |  |  |  |  |  |  | HEUFT TORNADO S flex
Empty container inspector |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HEUFT VX ATEX |  |  |  |  |  |  |  | HEUFT TORNADO W
Empty mould inspection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HEUFT TORNADO W flex
Foreign object detection
Full container inspection
Hardware interface and small control unit
IT product
Label check
Labelling machine
Leakage check
Residual liquid check
Ultrasonic fobbing
Miscellaneous
Spreadsheet: 781368d1653286661-change-in-lookup-to-different-sheet-not-working-northfields-review-test
Sheet: Value Output

Job Data |  |  |  |  |  |  |  |  | main rate | Main rate variable | Main rate variable | Main rate variable | Main rate variable | TMA extra cost | Wash out hydrant | fire hydrant | sluice valves | air valves | non return valve | Pressure reducing valve (install only) | mains branch | Add metres of main/service/comm pipe
 |  |  |  |  |  |  |  |  | rate | rate | rate | rate | rate | Lookup | rate | rate | rate | rate | rate | rate | rate | m
Unique Id | SAP order no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error | Audit | A1 | A2 | A3 | A4 | A5 | TM | V1 (a-d) | V2 (a-d) | V3 (a-d) | V4 (a-d) | V5 (a-d) | V6 (a-d) | V7 (a-d) | X1 (a-d)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TM
Spreadsheet: jonathan_mckay__17203__Tariffs New Update
Sheet: PGT$

PG&E Gas Transmission
Stanfield Deliveries
Firm Mileage Reservation |  | $US/MMBTU
Firm non-mileage Reservation | 0.884028 | $US/MMBTU
Commodity Charge |  | $US/MMBTU
IT |  | $US/MMBTU
ACA | 0.0022 | $US/MMBTU
GRI* | 0.007 | $US/MMBTU
* Payable if delivery is not to another interstate pipeline
IT Rates are maximum quoted rates
[NAME]
Firm Mileage Reservation |  | $US/MMBTU
Firm non-mileage Reservation | 0.884028 | $US/MMBTU
Commodity Charge |  | $US/MMBTU
IT Commodity |  | $US/MMBTU
ACA | 0.0022 | $US/MMBTU
GRI* | 0.007 | $US/MMBTU
Stanfield to Malin
Firm Mileage Reservation |  | $US/MMBTU
Firm non-mileage Reservation | 0.884028 | $US/MMBTU
Commodity Charge |  | $US/MMBTU
IT Commodity |  | $US/MMBTU
ACA | 0.0022 | $US/MMBTU
GRI* | 0.007 | $US/MMBTU
Spreadsheet: 733085d1621380203-return-a-when-a-given-row-matches-a-comparison-row-of-a-set-of-numbers-stock-short-term-comparison-4
Sheet: Sheet1

1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | comparison value
-2 | 2 | 0 | 0 | 3 | 0 | 0 | -2
-2 | -2 | 0 | -1 | 3 | -2 | 1 | 0 | -1 | 2
-2 | -2 | 1 | 0 | 1 | 2 | -2 | 0
-2 | -1 | -1 | 1 | 1 | 1 | -2 | 0 |  |  |  |  | A
-2 | 0 | -3 | 0 | 0 | 2 | -1 | -1
-1 | 1 | -2 | -1 | 2 | -1 | 3 | -1 | -2 | -1
-2 | 0 |  |  |  |  |  |  |  |  |  |  |  | comparison value
-2 | -2 | 0 | -1 | 3 | -2 | 1 | 0 | -1
-2 | -2 | 1 | 0 | 1 | 2 | -2 | 0 |  |  |  |  | A
-2 | -1 | -1 | 1 | 1 | 1 | -2 | 0 |  |  |  |  | A
-2 | 0 | -3 | 0 | 0 | 2 | -1 | -1 |  |  |  |  | A
Spreadsheet: 761291d1640802805-index-match-return-maximum-value-index-match-return-maximum-value
Sheet: Sheet1

Participant | Course | Score |  |  |  | A
annelies | A | 0.8 |  |  | annelies
francois | A | 0.7
jean | A | 0.7
geert | A | 0.9
sostene | A | 0.9
prince | A | 0.7
prince | A | 0.85
annelies | A | 0.85
esther | A | 1
[NAME] | B | 0.9
[NAME] | B | 0.71
rachel | B | 0.86
jiska | B | 0.86
telesphore | B | 1
[NAME] | C | 0.71
roreen | C | 0.86
jennifer | C | 0.86
[NAME] | C | 0.71
[NAME] | C | 0.86