tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 740261d1626258237-profit-and-loss-account-using-filter-formula-profit-and-loss-using-filter-formula
Sheet: Sheet1

I'm kindly asking for help on [NAME] formula is not producing desired results when the profit amount is negative (Loss).
Proofit  and loss |  |  |  | Current formula: Filter |  |  | Desired outcome
Revenue | 1 |  |  |  | 1 |  | Revenue | 1
Sales | 4371125 |  |  | Sales | 4371125 |  | Sales | 4371125
Opening Inventory | 0 |  |  | Gross Profit | 4371125 |  | Gross Profit | 4371125
Puchases | 0 |  |  | Other Income | 1 |  | Other Income | 1
Closing Inventory | 0 |  |  | Bus Fares | 129536.03 |  | Bus Fares | 129536.03
Cost of Sales | 0 |  |  | Donations | 179720 |  | Donations | 179720
Gross Profit | 4371125 |  |  | Total Other Income | 309256.03 |  | Total Other Income | 309256.03
Other Income | 1 |  |  | Total Revenue | 4680381.03 |  | Total Revenue | 4680381.03
Bus Fares | 129536.03 |  |  | Expenditure | 1 |  | Expenditure | 1
Swimmnig | 0 |  |  | Accounting Fees | 25500 |  | Accounting Fees | 25500
Donations | 179720 |  |  | Cleaning | 6569.95 |  | Cleaning | 6569.95
Total Other Income | 309256.03 |  |  | Knight frank | 116699.48 |  | Knight frank | 116699.48
Total Revenue | 4680381.03 |  |  | Electricity | 59589.27 |  | Electricity | 59589.27
Expenditure | 1 |  |  | Fuel & Oils | 2336807.38 |  | Fuel & Oils | 2336807.38
Accounting Fees | 25500 |  |  | Insurance & Licence | 46772.55 |  | Insurance & Licence | 46772.55
Advertising & Marketing | 0 |  |  | Miscellaneous | 7557.96 |  | Miscellaneous | 7557.96
Cleaning | 6569.95 |  |  | Printing & Stationery | 28019 |  | Printing & Stationery | 28019
Knight frank | 116699.48 |  |  | Salaries & Wages | 1611603.64 |  | Salaries & Wages | 1611603.64
Berlina Payroll | 0 |  |  | Property Maintenance | 164954.85 |  | Property Maintenance | 164954.85
Electricity | 59589.27 |  |  | Feeding Programme | 9769.03 |  | Feeding Programme | 9769.03
Fuel & Oils | 2336807.38 |  |  | Telephone & Internet | 85791.17 |  | Telephone & Internet | 85791.17
Insurance & Licence | 46772.55 |  |  | Water & Rates | 136545.91 |  | Water & Rates | 136545.91
Miscellaneous | 7557.96 |  |  | Board Members Allowance | 790.84 |  | Board Members Allowance | 790.84
Printing & Stationery | 28019 |  |  | Subscriptions | 73410 |  | Subscriptions | 73410
Salaries & Wages | 1611603.64 |  |  | Total Operating Expenditure | 4710381.03 |  | Total Operating Expenditure | 4710381.03
Security - Fawcett | 0 |  |  |  |  |  | Net Operating Surplus or (deficit)
Property Maintenance | 164954.85
Feeding Programme | 9769.03
Telephone & Internet | 85791.17
Water & Rates | 136545.91
Board Members Allowance | 790.84
Subscriptions | 73410
Workshops & Conferances | 0
Audit | 0
Total Operating Expenditure
 | 0
Net Operating Surplus or (deficit)
Spreadsheet: 271062d1381800887-search-cell-text-and-output-different-values-based-on-result-in-another-cell-sample
Sheet: Sheet1

[NAME] | price
1741-4FT X 4FT-VINYL | 10.99
1741-4FT X 4FT-POLYPAPER | 10.99
1741-4FT X 4FT-CANVAS | 10.99
1741-5FT X 5FT-VINYL | 10.99
1741-5FT X 5FT-POLYPAPER | 10.99
1741-5FT X 5FT-CANVAS | 10.99
1741-3FT X 3FT-VINYL | 10.99
1741-3FT X 3FT-POLYPAPER | 10.99
1741-3FT X 3FT-CANVAS | 67.99
1741-2FT X 2FT-VINYL | 10.99
1741-2FT X 2FT-POLYPAPER | 10.99
1741-2FT X 2FT-CANVAS | 44.99
Spreadsheet: 127090d1320161444-link-updates-weekly-1
Sheet: Report

Enforcer Daily First Pass Quality Inspection Report : Liquids |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Line 1 | Line 2 | Line 3 | Line 4 | Line 5 | Line 6 | Line7
 | Weekending  Date
 | Liquids 1st Shift
 |  | Total Audits | Passed Audits | % Conformance |  |  | Mon | Tue | Wed | Thurs | Fri | Sat
 | Line 1 |  |  |  |  | Line 1
 | Line 2 |  |  |  |  | Line 2
 | Line 3 |  |  |  |  | Line 3
 | Line 4 |  |  |  |  | Line 4
 | Line 5 |  |  |  |  | Line 5
 | Line 6 |  |  |  |  | Line 6
 | Line 7 |  |  |  |  | Line 7
 | Line 10 |  |  |  |  | Line 10
 | Total
 | Liquids 2nd Shift
 |  | Total Audits | Passed Audits | % Conformance |  |  | Mon | Tue | Wed | Thurs | Fri | Sat
 | Line 1 |  |  |  |  | Line 1
 | Line 2 |  |  |  |  | Line 2
 | Line 3 |  |  |  |  | Line 3
 | Line 4 |  |  |  |  | Line 4
 | Line 5 |  |  |  |  | Line 5
 | Line 6 |  |  |  |  | Line 6
 | Line 7 |  |  |  |  | Line 7
 | Line 10 |  |  |  |  | Line 10
 | Total
 |  |  |  |  | L I N E       N U M B E R
 | LIQUIDS |  |  |  | Line 1 |  | Line 2 |  | Line 3 |  | Line 4 |  | Line 5 |  | Line 6 |  | Line 7 |  | Line 10
 |  |  |  | # of Non Conformances | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd
 | [NAME] | Correct BC
 |  | Readable BC
 |  | BC Present
 | Bottle | Correct/present/Color
 |  | Facing Proper Direction (mp only)
 |  | [NAME] (inmold only)
 | Boxes | Correct Revision
 |  | Print Clear
 |  | I2O5 Scannable
 | Caps | Correct caps
 |  | High Torques
 |  | Low Torques
 |  | Straight Caps
 |  | Proper Heat Seal
 | [NAME] | Correct/Present
 |  | Centered
 |  | Wrinkle Free
 |  | [NAME]
 | Weights | High Weights
 |  | Low Weights
 | Residue | No Residue
 | Leaks | No Leaks
 | Tray | Correct/Present
 | Divider | Correct/Present
 | Header | Correct/Present
 | Pad | Correct/Present
 | Shroud | Correct/Present
 | [NAME] | Correct/Present
 | Misc | Correct/Present
 |  |  | Total
Spreadsheet: 702892d1604593325-cell-to-generate-the-sum-of-the-quantity-of-items-from-multiple-cells-that-have-formulas-order-form1
Sheet: Order1

Operators | Date | Branch | Move # | Total | Materials | Quantity | Price | Materials | Quantity | Price | Materials | Quantity | Price | Materials | Quantity | Price | Materials | Quantity | Price | Materials | Quantity | Price
[NAME] |  | HYM |  |  | Lamp cartons | 55 |  | Newsprint sheets 25 lb/bundle | 2 |  | Lamp cartons | 3
 |  |  |  |  | Lamp cartons | 2 |  | 4.5 large cartons | 3 |  | 5.2 dishpack cartons | 2
Spreadsheet: richard_shapiro__32170__shapiro-1
Sheet: kingerski

COST CENTER |  | OUTSIDE SERVICES DISCRETIONARY | PRIORITY | REQUESTED | APPROVED | COMMENTS
[NAME] (xxx) |  | regulatory hedges - CA and IL | B | 400000 | RCR | split is $50,000 for CA and $350,000 for IL
 |  | develop and identify distributed general opportunities - CA, CT, IL | C | 65000 | RCR
 |  | support industry wide standards board to advance commodity market standardization | B | 75000 | RCR
 |  | obtain physical delivery capabilities and environmental needs awareness | D | 50000 | RCR
Kingerski Total |  | Kingerski Total
COST CENTER |  | OTHER BUSINESS EXPENSE |  | REQUESTED | APPROVED
[NAME] (xxx) |  | conferences training for 8 to 9 employees | A | 36000 | 36000
 | A | memberships/dues - bar assoc dues for attorneys in group | A | 7000 | 7000
Kingerski Total |  | Kingerski Total
Budget - Outside Services |  |  |  | 9000000 | 9000000
Outside Discretionary
[NAME]
Budget - Outside Services |  |  |  | 9000000 | 9000000
Outside Fixed |  |  |  | 0 | 0
[NAME]
Budget - Other Business Expense |  |  |  | 1200000 | 1200000
Other Business Expense
[NAME]
Spreadsheet: 105267d1302690349-array-or-pivot-make-a-sum-if-the-value-of-one-cell-falls-within-a-date-range-sumifvaluewithindate-del-solved
Sheet: Sheet2

 |  | Project Name | Value | First Step Complete Date | Second Step Complete Date | Third Step Complete Date | Value at end 2012
 |  | Project 1 | 5 | 2011-03-29 08:00:00 | 2011-07-18 17:00:00 | 2012-02-23 17:00:00
 |  | Project 2 | 6 | 2011-04-05 17:00:00 | 2011-07-26 17:00:00 | 2012-02-23 17:00:00
 |  | Project 3 | 7 | 2011-04-06 17:00:00 | 2011-07-27 17:00:00 | 2012-02-23 17:00:00
 |  | Project 4 | 8 | 2011-04-25 17:00:00 | 2011-11-03 17:00:00 | 2012-02-23 17:00:00
 |  | Project 5 | 9 | 2011-04-25 17:00:00 | 2011-12-14 17:00:00 | 2012-03-27 17:00:00
 |  | Project 6 | 10 | 2011-05-02 17:00:00 | 2011-12-21 17:00:00 | 2012-04-03 17:00:00
 |  | Project 7 | 1 | 2011-05-02 17:00:00 | 2011-12-21 17:00:00 | 2012-04-03 17:00:00
 |  | Project 8 | 2 | 2011-05-16 17:00:00 | 2011-12-21 17:00:00 | 2012-04-11 17:00:00
 |  | Project 9 | 3 | 2011-06-13 17:00:00 | 2013-02-01 17:00:00 | 2014-04-01 00:00:00
 |  | Project 10 | 4 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00
 |  | Project 11 | 5 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00
 |  | Project 12 | 6 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00
 |  | Project 13 | 7 | 2011-07-04 17:00:00 | 2012-02-22 17:00:00 | 2013-06-05 17:00:00
 |  | Project 14 | 8 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 15 | 11 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 16 | 12 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2012-06-13 17:00:00
 |  | Project 17 | 13 | 2011-08-29 17:00:00 | 2011-12-19 17:00:00 | 2013-06-13 17:00:00
 |  | Project 18 | 14 | 2011-08-29 17:00:00 | 2011-12-19 17:00:00 | 2013-06-13 17:00:00
 |  | Project 19 | 15 | 2011-08-29 17:00:00 | 2012-04-18 17:00:00 | 2013-07-31 17:00:00
 |  | Project 20 | 15 | 2011-09-12 17:00:00 | 2012-05-02 17:00:00 | 2013-08-14 17:00:00
 |  | Q1 2011 | Q2 2011 | Q3 2011 | Q4 2012
 |  | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00
 |  | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00
 |  | Q1 2012 | Q2 2012 | Q3 2012 | Q4 2013
 |  | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00
 |  | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00
Spreadsheet: 819631d1677605279-how-can-i-count-vacant-days-per-month-with-blank-move-in-dates-hotel-vacancy
Sheet: January total vacancy

January
2022-01-01 00:00:00
2022-01-02 00:00:00
2022-01-03 00:00:00
2022-01-04 00:00:00
2022-01-05 00:00:00
2022-01-06 00:00:00
2022-01-07 00:00:00
2022-01-08 00:00:00
2022-01-09 00:00:00
2022-01-10 00:00:00
2022-01-11 00:00:00
2022-01-12 00:00:00
2022-01-13 00:00:00
2022-01-14 00:00:00
2022-01-15 00:00:00
2022-01-16 00:00:00
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00
2022-01-20 00:00:00
2022-01-21 00:00:00
2022-01-22 00:00:00
2022-01-23 00:00:00
2022-01-24 00:00:00
2022-01-25 00:00:00
2022-01-26 00:00:00
2022-01-27 00:00:00
2022-01-28 00:00:00
2022-01-29 00:00:00
2022-01-30 00:00:00
2022-01-31 00:00:00
Spreadsheet: 126213d1319568304-sorting-across-cells-sort-block
Sheet: Sheet1

51 | 84 | 41 | 50 | 72 | 91 | 34 | 70 | 72 | 50 |  | Data
98 | 68 | 4 | 44 | 80 | 59 | 71 | 79 | 18 | 35
39 | 25 | 57 | 15 | 31 | 94 | 78 | 92 | 52 | 51
23 | 12 | 33 | 98 | 71 | 54 | 34 | 58 | 85 | 19
22 | 60 | 26 | 8 | 3 | 7 | 50 | 74 | 82 | 67
36 | 62 | 25 | 25 | 45 | 32 | 86 | 65 | 64 | 45
53 | 31 | 6 | 64 | 81 | 67 | 87 | 96 | 86 | 93
10 | 53 | 37 | 98 | 29 | 100 | 6 | 37 | 79 | 65
27 | 96 | 47 | 63 | 54 | 74 | 73 | 24 | 69 | 85
60 | 29 | 77 | 50 | 3 | 43 | 14 | 3 | 73 | 11
 |  |  |  |  |  |  |  |  |  |  | Sorted data
Spreadsheet: mark_taylor__24706__US counterparties and reference entities216
Sheet: CounterParties

 | Counter Parties
1 | [NAME] | Energy
 | Cinergy Marketing & Trading, LLC | Energy
 | Duke Energy Trading and Marketing, LLC | Energy
 | [NAME] | Energy
 | El Paso Energy Corporation | Energy
 | Koch Industries Inc. | Energy
 | PG&E Energy Trading-Gas Corporation | Energy
 | Southern Company Energy Marketing, LP | Energy
 | Morgan Guarantee Trust Company of New York | Bank
11 | Bank of Montreal | Bank
12 | Bankers Trust Company | Bank
13 | J. Aron & Company | Energy
 | Coral Energy | Energy
 | Donaldson Lufkin & Jenrette Inc. | Bank
 | Entergy Power Marketing Corp | Energy
 | KN Energy (Kinder Morgan) | Energy
 | Christiania Bank Og Kreditkasse ASA | Bank
 | Morgan Stanley Capital Group Inc. | Bank
 | Sempra Energy Trading Corp | Energy
 | Reliant Energy | Energy
 | Texas Utilities Energy | Energy
 | Trectebel Energy Marketing | Energy
 | Williams Companies Inc. | Energy
25 | The Toronto-Dominion Bank | Bank
26 | AEP Energy Service | Energy
27 | IDA Corp Energy Solutions | Energy
28 | Merrill Lynch Capital Markets | Bank
Spreadsheet: f6b04965-85a9-4024-9dc3-2f6f18b91784
Sheet: Sheet1

[NAME] / โครงการ ปี 52-56 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
สถาบันพระบรมราชชนก  สำนักงานปลัดกระทรวงสาธารณสุข
แผนงาน / โครงการ | รวม |  | 52 |  | 53 |  | 54 |  | 55 |  | 56
 | เป้า | งบ | เป้า | งบ | เป้า | งบ | เป้า | งบ | เป้า | งบ | เป้า | งบ
 | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ
แผนงานพัฒนาระบบงานสารสนเทศเพื่อการบริหาร สถาบันพระบรมราชชนก
1. [NAME] สถาบันพระบรมราชชนก | 1 ศูนย์ | 500000 | พัฒนา | 500000
1.1 โครงการพัฒนาระบบบุคลากร | 1 ระบบ | 1200000 | ปรับปรุง 1 ระบบ | 300000 | MT 1 ระบบ | 200000 | ปรับปรุง 1 ระบบ | 300000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000
และเงินเดือน
1.2 โครงการพัฒนาระบบยุทศาสตร์ | 1 ระบบ | 1200000 |  | 0 | พัฒนา 1 ระบบ | 500000 | ปรับปรุง 1 ระบบ | 300000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000
และประเมินผล
1.3 โครงการพัฒนาระบบงาน | 1 ระบบ | 1200000 | ปรับปรุง 1 ระบบ | 300000 | MT 1 ระบบ | 200000 | ปรับปรุง 1 ระบบ | 300000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000
สารบรรณ
1.4 โครงการพัฒนาระบบ DSS | 1 ระบบ | 1500000 | - | - | - | - | พัฒนา 1 ระบบ | 1000000 | MT 1 ระบบ | 225000 | ปรับปรุง 1 ระบบ | 500000
1.5 โครงการพัฒนางบประมาณ | 1 ระบบ | 1800000 | - | 0 | พัฒนา 1 ระบบ | 800000 | ปรับปรุง 1 ระบบ | 400000 | MT 1 ระบบ | 300000 | MT 1 ระบบ | 300000
การเงิน บัญชี และระบบกำกับ
งบประมาณ
1.6 ระบบห้องสมุดอิเลคทรอนิกส์ | 1 ระบบ | 600000 | ปรับปรุง 1 ระบบ | 200000 | MT 1 ระบบ | 100000 | MT 1 ระบบ | 100000 | MT 1 ระบบ | 100000 | MT 1 ระบบ | 100000
1.7 พัฒนาระบบพัสดุครุภัณฑ์ | 1 ระบบ | 1000000 | - | 0 | พัฒนา 1 ระบบ | 400000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000
1.8 พัฒนาระบบทะเบียนและ | 1 ระบบ | 1400000 | ปรับปรุง 1 ระบบ | 600000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000 | MT 1 ระบบ | 200000
ประเมินผลการศึกษา
หมายเหตุ MT = การบำรุงรักษา
รวม | 8 ระบบ | 9900000 | - | 1400000 | - | 2400000 | - | 2800000 | - | 1625000 | - | 1900000
แผนงาน / โครงการ | รวม |  | 52 |  | 53 |  | 54 |  | 55 |  | 56
 | เป้า | งบ | เป้า | งบ | เป้า | งบ | เป้า | งบ | เป้า | งบ | เป้า | งบ
 | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ | หมาย | ประมาณ
แผนงานพัฒนาการเชื่อมโยงเครือข่ายสารสนเทศ ของสถาบันพระบรมราชชนก
1. โครงการเชื่อมโยงเครือข่ายสารสนเทศ ระหว่างสถาบันพระบรมราชชนก กับวิทยาลัยในสังกัด | 1 เครือข่าย | 25000000 | 1 เครือข่าย | 5000000 | 1 เครือข่าย | 5000000 | 1 เครือข่าย | 5000000 | 1 เครือข่าย | 5000000 | 1 เครือข่าย | 5000000
รวม | 1 เครือข่าย | 25000000 | - | 5000000 | - | 5000000 | - | 5000000 | - | 5000000 | - | 5000000
Spreadsheet: tracy_geaccone__40367__EMNNG02PL
Sheet: IntDeduct

PRINT: PRINT
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
DIRECT INTEREST EXPENSE
Carrying Charges - Reverse Auction 1 | Linked
- Reverse Auction 2 | Linked
- Reverse Auction 3 | Linked
- GSR R.A. | Linked
- Stranded 858 | Linked
- Rate Case | Linked
Carlton Resolution | Linked
Discount Issue |  | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
AFUDC - Debt (SAP Change 7/00 Forward) | Link D.T.
[NAME] (ASCC) Fees |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Misc. Item 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL DIRECT INTEREST
INTERCOMPANY INTEREST EXPENSE / (INCOME)
Intercompany Interest Expense / (Income) |  | -1000 | -1000 | -1100 | -1100 | -1200 | -1100 | -1100 | -1100 | -1000 | -1000 | -900 | -900
Long Term Debt (Pre 1/1/98) - Interest Expense |  |  |  |  | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031
- Debt Expense Amortization |  | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 28
Long Term Debt (Post 1/1/98) - Interest Expense |  | 844 | 844 | 844 | 843 | 844 | 844 | 844 | 843 | 844 | 844 | 844 | 843
- Debt Expense Amortization |  | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 10 | 11 | 11
- Interest Expense Differential |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL INTERCOMPANY INTEREST EXPENSE/(INCOME)
AFUDC
AFUDC - Equity | Link D.T.
AFUDC - Debt (Reclass from Direct Interest Expense ???) |  | -10 | -4 | -12 | -28 | -50 | -68 | -2 | -26 | -48 | -69 | -53 | -51
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL AFUDC
OTHER DEDUCTIONS
Reacquired Debt - Amortized Loss | Link D.T.
- Amortized (Gain) | Link D.T.
Donations
Reserve Issues - Cooper (Parts Sale) Deferred Gain | Link D.T.
- Miscellaneous 1 | Link D.T.
- Miscellaneous 2 | Link D.T.
Other Deductions (Misc. Item 1)
Litigation Settlements - Misc. Item 1    "Commercial Function"
- Misc. Item 2                                "Commercial Function"
- Misc. Item 3                                "Commercial Function"
Other                                                 "Commercial Function"
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OTHER DEDUCTIONS
TOTAL INTEREST & OTHER DEDUCTIONS
Spreadsheet: 733492d1621600449-automatically-add-newly-created-column-headers-to-new-row-in-another-table-best-practice-for-total-points
Sheet: Example Gradebook 102

Class | Seat Number | Name | Overall Grade | Assignment A /3 | Assignment X /4 | Assignment Y /2 | <<<this class, 102, is only here to show that sometimes Assignments will overlap, and sometimes they will be differ per class. I have to keep that in mind while calculating totals
102 | 1 | Zebra
102 | 2 | X
102 | 3 | Wilson
102 | 4 | Vader
102 | 5 | Umbrella
102 | 6 | [NAME]
102 | 7 | [NAME]
102 | 8 | [NAME]
102 | 9 | Quagmire
102 | 10 | Pony
Total
Spreadsheet: 972603df-cd57-4e52-af94-7d31b1c25577
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Facilities | 1 | Improve Safety | 1.1 | Improve District Office Lobby Safety | 1 | None | -- Pick One --
Facilities | 1 | Improve Safety | 1.2 | Furniture & Equipment Safety for Earthquake Preparedness | 1 | None | -- Pick One --
Facilities | 1 | Efficiently communicate Facilities processes and procedures | 2.1 | Improve set-up procedures | 1 | None | -- Pick One --
Facilities | 1 | Improve responsiveness to M&O needs | 3.1 | Evaluate pooling District-wide M&O resources | 5 | None | -- Pick One --
Spreadsheet: 197129d1354217797-emailing-an-attached-spreadsheet-car-log-12
Sheet: Decontamination Certificate

Equipment Decontamination Certificate
[NAME] |  |  |  | End User Company Name
TYPE OF EQUIPMENT |  |  | MANUFACTURER |  | MODEL No. |  | SERIAL No
IMPORTANT
It is the responsibility of the user to ensure that equipment to be relocated/disposed/returned is of, so far as is reasonably practicable, in a clean and ‘safe’ condition, i.e. free from Microbiological, Chemical and Radiological contamination.
Please complete the appropriate section below.
1 | The equipment described above has not been exposed to micro-organisms, clinical material, radioisotopes or hazardous chemicals.
Signed: ………………………………………… (User) |  |  |  |  | Date:……………………………..
2 | The equipment described above has been exposed to micro-organisms / clinical material / radioisotopes / hazardous chemicals* and appropriate decontamination procedures have been carried out.
Signed: ………………………………………… (User) |  |  |  |  | Date:……………………………..
3 | Complete decontamination of the equipment described above cannot be achieved.
Nature of residual contamination
Suggested precautions to be observed when handling
Signed: ………………………………………… (User) |  |  |  |  | Date:……………………………..
(Any queries regarding the content of this certificate to be made to this person)
Laboratory Manager Authorisation
Signature: |  |  |  | Name:
Date:
*Please delete as appropriate
Spreadsheet: 141445d1329265119-sumif-unique_sum
Sheet: Sheet1

Header1 | Header2
A | 1
B | 2
C | 3
D | 4
E | 5
A | 6
A | 7
A | 8
A | 9
A | 10
B | 11
B | 12
B
C
D
E
F
G | 18
A | 19
A | 20
A
A
D | 23
F | 24
G | 25
H | 26
U | 27
K | 28
L | 29
Spreadsheet: 709823d1608569778-im-trying-to-compile-data-using-vlookup-but-i-need-to-pull-multiple-strings-of-text-pt-tooling-by-features
Sheet: Sheet2

Existing PTT | Compatible Fitting(s) | Fitting Features Used by PTT to Seal or Fasten per Review of Fitting Drawing(s) - Populate What's Applicable |  |  |  |  |  |  |  | Comments | Reviewed Actual PTT?
 |  | PWA 79333 [NAME] ? | Straight Bore ID Used by [NAME] ? | Male O-ring Gland Dims Used by [NAME] ? |  |  | Flange Holes ?  (EQ SP UOS) --->
 |  |  |  | Pilot OD | Gland OD | Groove L | Qty | [NAME] | [NAME]
FEMALE 1 HOLE # 1 |  | CE-06
FEMALE 1 HOLE # 2 |  | CE-07
FEMALE 1 HOLE # 3
FEMALE 1 HOLE # 4 |  | CE-10
FEMALE 1 HOLE # 5
FEMALE 1 HOLE # 6
FEMALE 1 HOLE # 7
FEMALE 1 HOLE # 8
FEMALE 1 HOLE # 9
FEMALE 1 HOLE # 10
FEMALE 1 HOLE # 11 |  | [NAME] |  |  |  |  |  |  |  | Has O-ring Snout
FEMALE 1 HOLE # 12
FEMALE 1 HOLE # 13
FEMALE 1 HOLE # 14 |  | [NAME] |  |  |  |  |  |  |  | Has Lock Ramp
FEMALE 1 HOLE # 15 |  | [NAME] |  |  |  |  |  |  |  | Has Lock Ramp
FEMALE 1 HOLE # 16
FEMALE 1 HOLE # 17 |  | [NAME]
Spreadsheet: 681251d1591429047-merge-data-from-range-to-range-without-blank-cells-zz
Sheet: sheet1

 | NAME | CODE |  |  |  |  |  | NAME | CODE
 | ALI | 100
 | AHMED | 200 |  |  |  |  | RESULT
 | OMAR | 300
 | KHALID | 400
 | MUSTAPHA | 500
 | NAME | CODE
 | [NAME] | 20
 | TOM | 50
 | SARA | 10
Spreadsheet: 716920d1612424058-count-the-ordered-frequency-sequence-of-0-and-1-test-3-
Sheet: Tabelle1

 |  |  |  |  |  | January | Februari | Mars | April | Maj | Juni | [NAME] | Augusti | September | Oktober | November | December |  | Preffered Output
 |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0
 |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  |  | 6 | 5
 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |  |  | 5 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5
 |  |  |  |  |  | 1 | 0 | 1 | 0
Spreadsheet: 722662d1615365407-inventory-stock-formula-book1
Sheet: INVENTORY

 | Item Name | Current Stock |  |  |  |  | Total Stock
 |  | Karratha | Port Hedland | Brisbane | Perth | Christmas Creek
 | Womens T Shirt
 | [NAME]
 | Pants
 | Jeans
 | Boots
Spreadsheet: 78806d1279117721-average-calculation-based-on-criteria-percentage-complete-spreadsheet
Sheet: Percentages

Class | Class Percentage To Date | Headcount | July Yes | July No | July | Aug Yes | Aug No | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
1 | 0.5221238938053098 | 8 | 7 | 0 | 1 | 3 | 4 | 0.4285714285714285
2 | 0 | 10 | 2 | 5 | 0.2857142857142857 | 4 | 5 | 0.4444444444444444
3 | 0 | 9 | 1 | 5 | 0.1666666666666667 | 4 | 5 | 0.4444444444444444
4 | 0 | 9 | 4 | 4 | 0.5 | 5 | 4 | 0.5555555555555556
5 | 0 | 11 | 8 | 8 | 0.5 | 3 | 8 | 0.2727272727272727
6 | 0 | 10 | 1 | 2 | 0.3333333333333333 | 8 | 2 | 0.8
7 | 0 | 8 | 4 | 2 | 0.6666666666666666 | 6 | 2 | 0.75
8 | 0 | 11 | 6 | 5 | 0.5454545454545454 | 6 | 5 | 0.5454545454545454
9 | 0 | 9 | 1 | 1 | 0.5 | 7 | 1 | 0.875
10 | 0 | 9 | 9 | 6 | 0.6 | 3 | 6 | 0.3333333333333333
[NAME] | 0 | 5 | 0 | 0 |  | 0 | 0
PSAM2 | 0 | 8 | 0 | 0 |  | 0 | 0
PSPM1 | 0 | 4 | 0 | 0 |  | 0 | 0
PSPM2 | 0 | 4 | 0 | 0 |  | 0 | 0
 |  | 115