tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 682202d1591961486-how-to-count-how-many-rails-we-need-for-a-solar-panel-system-example-of-rails
Sheet: Sheet1

Module width | module height | spacing between modules
39.37 | 66 | 0.37
EXAMPLE 1 | This is for portrait layout (no landscape boxes are checked, so no array is in landscape)
 |  |  |  | count
 | Total amount of panels
insert amount: | 54 |  | Landscape | Arrays | total rail length |  |  | total rail needed
 |  | check mark if the array is landscape |  | 21 |  |  |  | 204" | 12
 |  |  |  | 15 |  |  |  | 168" | 12
204" = 5 panels in portrait |  |  |  | 9 |  |  |  | 204" | 0
168" = 4 panels in portrait |  |  |  | 5
132" = 3 panels in portrait |  |  |  | 4
 |  |  |  |  |  |  | All rail is doubled for the top of the array and the bottom of the array
 |  |  |  |  |  |  | Explination
 |  |  |  |  |  |  | 21 | 2 rail of 204" and 8 rails of 168"
 |  |  |  |  |  |  | 15 | 6 rais of 204"
 |  |  |  |  |  |  | 9 | 2 rail of 204" and 2 rail of 168"
 |  |  |  |  |  |  | 5 | 2 rail of 204"
 |  |  |  |  |  |  | 4 | 2 rail of 168"
Module width | module height | spacing between modules
39.37 | 66 | 0.37
EXAMPLE 2 | This is for portrait layout (no landscape boxes are checked, so no array is in landscape)
 |  |  |  | count
 | Total amount of panels
insert amount: | 32 |  | Landscape | Arrays | total rail length |  |  | total rail needed
 |  | check mark if the array is landscape |  | 8 |  |  |  | 204" | 2
 |  |  |  | 8 |  |  |  | 168" | 12
 |  |  |  | 7 |  |  |  | 132" | 2
 |  |  |  | 5
204" = 5 panels in portrait |  |  |  | 3
168" = 4 panels in portrait |  |  |  | 1
132" = 3 panels in portrait
 |  |  |  |  |  |  | All rail is doubled for the top of the array and the bottom of the array
 |  |  |  |  |  |  | Explination
 |  |  |  |  |  |  | 8 | 4 rails of 168"
 |  |  |  |  |  |  | 8 | 4 rails of 168"
 |  |  |  |  |  |  | 7 | 2 rails of 168" and 2 rails of 132"
 |  |  |  |  |  |  | 5 | 2 rails of 204"
 |  |  |  |  |  |  | 3 | 2 rails of 168"
 |  |  |  |  |  |  | 1 | This array is combined with the one above, the rail is just cut and used for this array as well to use less rail.
Module width | module height | spacing between modules
39.37 | 66 | 0.37
EXAMPLE 3 | This is for landscape layout
 |  |  |  | count
 | Total amount of panels
insert amount: | 19 |  | Landscape | Arrays | total rail length |  |  | total rail needed
 |  | check mark if the array is landscape |  | 10 |  |  |  | 204"
 |  |  |  | 7 |  |  |  | 168"
 |  |  |  | 2 |  |  |  | 132"
204" = 5 panels in portrait
168" = 4 panels in portrait
132" = 3 panels in portrait
 |  |  |  |  |  |  | All rail is doubled for the top of the array and the bottom of the array
 |  |  |  |  |  |  | Explination
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 2 |  | Still trying to figure this out. The parameters are, the least amount of rail wasted. And the smallest length of rail that can be used is 36"
 |  |  |  |  |  |  |  | rails | total rails | rail length
 |  |  |  |  |  |  |  | 204 | 3
 |  |  |  |  |  |  |  | 168 | 0
 |  |  |  |  |  |  |  | 132 | 5 |  |  | total rail length |  | difference
Spreadsheet: 778940d1651478248-formula-to-calculate-change-percentage-change-aligw
Sheet: Sheet1

Line item | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | % Change
8400/000 STD BANK 270466274 | 0 | 0
8410/000 Petty Cash | 0 | 0
TOTAL OPENING BANK BALANCE | 0 | 381750.5
Receipts from Customers | 1262299.59 | 1493487.59
Rebates Received | 19841.16 | 5762.17
Rental Office Equipment | 10043.75 | 7975.25
Standard Bank COVID 19 Loan | 0 | 51680.02
STANDARD BANK LOAN ACCOUNT | 0 | 0
Sundry Customers | 0 | 0
Sundry Income | 0 | 0
STD BANK 270466274 | 0 | 100000
Petty Cash | 0 | 200000
Standard Bank - Savings Acc -  374575568 | 0 | 200000
Deferred - Standard Bank - Tata | 0 | 0
Sars - Income Tax | 0 | 1499249.76
TOTAL RECEIPTS | 2153096.14 | 1499249.76
Payments to Suppliers | 868684.2 | 1305769.94
Accounting Fees | 10250 | 11850
Bank Charges | 1992.49 | 2013.41
Cleaning | 801 | 840
Computer Expenses | 4957.5 | 0
Consulting Fees | 0 | 1650
Courier & Postage | 0 | 0
CELL PHONE EXPENSES | 0 | 0
Donations | 17000 | 0
Directors Fees / Members Remuneration | 17000 | 0
Entertainment Expenses | 0 | 0
General Expenses | 6000 | 6000
General Expenses      - Gifts | 0 | 6000
General Expenses - Fines | 0 | 0
Interest Paid - Bank | 10370.69 | 0
Insurance | 10370.69 | 9639.2
Leasing Charges | 892.4 | 972.72
Motor Vehicle Expenses | 800 | 0
Motor Vehicle Expenses  - Parking | 0 | 0
Motor Vehicle - Petrol & Oil | 0 | 600
Motor Vehicle - Repairs & Maint. | 1377.7 | 487
Printing & Stationery | 1377.7 | 1378.46
Repairs & Maintenance | 1154.7 | 142
Repairs and Maintenance - Office | 0 | 142
Salaries & Wages | 0 | 1747.72
Salaries & Wages - Casual Wages | 458.99 | 1747.72
Security Costs | 458.99 | 504.89
Staff [NAME] | 0 | 5184.88
Staff Training | 0 | 2629
Staff Welfare | 87.94 | 2629
Subscriptions | 161 | 2195.61
Staff Loans | 2584.52 | 0
Telephone & Fax | 2584.52 | 4691.48
Standard Bank - Mini Countryman | 0 | 6615.05
STANDARD BANK- KIA2020-CAA127242 | 0 | 3929.94
STANDARD BANK-KIA 2020-CAA127248 | 0 | 3929.94
STANDARD BANK-FORD RANGER-CAA82115 | 0 | 5849.89
Computer Software | 0 | 0
Loan Account - I Wilcox | 0 | 0
Standard Bank Credit Card Acc | 40460.96 | 96597.05
Standard Bank - Salaries account | 200000 | 150000
Salary & Wages Control | 31379.93 | 0
Sundry Creditors | 0 | 0
Vat / Tax Control Account | 0 | 0
TOTAL PAYMENTS | 1209457.77 | 2039265.09
NET CASH MOVEMENT | 943638.37 | -540015.33
JOURNAL ENTRIES PROCESSED | 789964.95 | 100000
TOTAL CLOSING BANK BALANCE | 0 | -58264.83
Spreadsheet: 781148d1653028089-how-to-use-multiple-formula-at-one-cell-example-book-aligw
Sheet: Shipment Detail

Date Create | Shipment ID | Product Name | [NAME] | SHIP QTY | Total Quantity | Total Pallet | Total weight of product | Total Weight of shipment | Shipping cost | Shipping unit cost
2022-01-06 00:00:00 | 20000 | AAA | 5 | 147 |  | 6
2022-01-06 00:00:00 | 20000 | BBB | 1 | 464 |  | 0
2022-01-06 00:00:00 | 20000 | CCC | 0.5 | 210 |  | 0
2022-01-06 00:00:00 | 20000 | DDD | 0.5 | 140 |  | 0
2022-01-06 00:00:00 | 20000 | EEE | 1 | 120 |  | 0
2022-01-06 00:00:00 | 20000 | FFF | 1 | 240 |  | 0
2022-01-06 00:00:00 | 20000 | GGG | 1 | 120 |  | 0
2022-01-06 00:00:00 | 20000 | III | 1 | 276 |  | 0
2022-01-06 00:00:00 | 20000 | JJJ | 2 | 200 |  | 0
2022-01-06 00:00:00 | 20000 | KKK | 3 | 196 |  | 0
2022-01-06 00:00:00 | 20000 | LLL | 5 | 168 |  | 0
2022-01-06 00:00:00 | 20000 | MMM | 1 | 560 |  | 0
2022-01-07 00:00:00 | 30000 | AAA | 3 | 210 |  | 1
2022-01-07 00:00:00 | 30000 | CCC | 1 | 210 |  | 0
2022-01-07 00:00:00 | 30000 | DDD | 1 | 240 |  | 0
2022-01-10 00:00:00 | 40000 | EEE | 2 | 250 |  | 9
2022-01-10 00:00:00 | 40000 | JJJ | 2 | 392 |  | 0
2022-01-10 00:00:00 | 40000 | KKK | 3 | 196 |  | 0
2022-01-10 00:00:00 | 40000 | LLL | 2 | 490 |  | 0
2022-01-10 00:00:00 | 40000 | MMM | 1 | 480 |  | 0
2022-01-10 00:00:00 | 40000 | BBB | 2 | 1470 |  | 0
2022-01-13 00:00:00 | 50000 | FFF | 2 | 100 |  | 1
2022-01-14 00:00:00 | 60000 | GGG | 2 | 250 |  | 10
2022-01-14 00:00:00 | 60000 | HHH | 2 | 441 |  | 0
2022-01-14 00:00:00 | 60000 | JJJ | 1 | 588 |  | 0
2022-01-14 00:00:00 | 60000 | KKK | 1 | 150 |  | 0
2022-01-14 00:00:00 | 60000 | MMM | 0.5 | 108 |  | 0
2022-01-14 00:00:00 | 60000 | LLL | 2 | 240 |  | 0
2022-01-14 00:00:00 | 60000 | AAA | 2 | 784 |  | 0
2022-01-14 00:00:00 | 60000 | BBB | 3 | 256 |  | 0
2022-01-14 00:00:00 | 60000 | CCC | 0.5 | 150 |  | 0
2022-01-14 00:00:00 | 60000 | DDD | 1 | 512 |  | 0
2022-01-14 00:00:00 | 60000 | EEE | 2 | 530 |  | 0
2022-01-14 00:00:00 | 60000 | FFF | 1 | 500 |  | 0
Total
Spreadsheet: 790771d1659984540-totalling-columns-dependent-upon-text-day-team-flexi-sheet
Sheet: April 2023

'[NAME] |  |  |  |  |  |  |  |  | Name
FLEXIBLE WORKING HOURS RECORD |  |  |  |  |  |  |  |  | Month | April | 2023
 |  |  |  |  |  | Hours brought forward
 | MORNING |  | AFTERNOON |  | Credit | Debit | Excess | Excess |  | Totals
 | Start | Finish | Start | Finish | Hours | Hours | or [NAME] | > 10 hrs | Comments | Daily | Toil
2023-04-03 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-04 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-05 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-06 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-07 00:00:00 |  |  |  |  | 07:00:00 | 0:00:00 |  |  | Good Friday
2023-04-10 00:00:00 |  |  |  |  | 07:00:00 | 0:00:00 |  |  | Public Holiday
2023-04-11 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-12 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-13 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-14 00:00:00 |  |  |  |  |  | 0:00:00
2022-04-17 00:00:00 |  |  |  |  |  | 0:00:00
2022-04-18 00:00:00 |  |  |  |  |  | 0:00:00
2022-04-19 00:00:00 |  |  |  |  |  | 0:00:00
2022-04-20 00:00:00 |  |  |  |  |  | 0:00:00
2022-04-21 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-24 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-25 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-26 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-27 00:00:00 |  |  |  |  |  | 0:00:00
2023-04-28 00:00:00 |  |  |  |  |  | 0:00:00
Signed |  |  |  |  |  | Date |  |  | Net Hours Worked this period
Approved |  |  |  |  |  | Date |  |  | Flexitime credit/debit carried forward
 |  |  |  |  |  |  |  |  | Toil this month
 |  | Annual Leave remaining from previous month |  |  |  |  |  |  | Toil from previous month
 |  | Annual Leave taken this month |  |  |  |  |  |  | Toil taken |  | 00:00:00
 |  | Total Annual Leave remaining |  |  |  |  |  |  | Total toil
Spreadsheet: 130967d1322673086-calculating-streaks-with-more-than-2-variables-formulas1a
Sheet: Sheet1

Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Jordan | W | L1 | L1 | 0 | L2 | L1 | L1 | L1 | L1 | W | L1 | W | W | L2 | L1 | W | 0 | 0 | 0 | W | W
W = Winning Team
L1 = 2nd Place Team
L2 = 3rd Place Team
0 = [NAME]
 |  |  |  |  | Desired Result
Most Consecutive Appearances |  |  |  |  | 12 | (Appearances include W,L1 & L2 but exclude 0)
Most Consecutive Wins (W) |  |  |  |  | 3
Most Consecutive Losses (L1 or L2) |  |  |  |  | 5
Current Consecutive Appearance |  |  |  |  | 2 | (Appearances include W,L1 & L2 but exclude 0)
Spreadsheet: andy_zipper__188__DYNEGY-ICE VOL May21
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], G | NG Fin BS, LD1 for IF | MMBtus | 4 | 4920000 |  | Fischer, M | Firm-LD Peak | MWhs | 4 | 8800
 | NG [NAME], ID, NGI | MMBtus | 2 | 1830000 |  | Richter, J | Firm-LD Off-Peak | MWhs | 1 | 200
 | NG Fin Sw Swap, NGI for GDD | MMBtus | 1 | 150000 |  | Stalford, R | Firm-LD Peak | MWhs | 5 | 4000
Pimenov, V | NG [NAME], ID, GDD | MMBtus | 1 | 10000 |  | Dorland, C | Firm-LD Peak | MWhs | 1 | 16800
 | NG [NAME], FP | MMBtus | 1 | 5000 |  | Carson, M | Firm-LD Peak | MWhs | 3 | 16800
Grand Total |  |  | 9 | 6915000 |  | Grand Total |  |  | 14 | 46600
Spreadsheet: 349293d1412269163-lookup-based-on-multiple-dropdown-selections-cars_inventory
Sheet: Sheet1

Car Maker Table | Model | Trim | Model Year |  | Lookup Table
Honda | [NAME] | DX | 2014
Hyundai | [NAME] | LX | 2015
Mazda | [NAME] | EX
 | Veloster | Touring
 | [NAME] | Si
 | Elantra Sedan | EX-L NAVI
 | Santa Fe Sport | Sport
 | Mazda2 | EX-L
 | Mazda3 | EX-L V6
 | Mazda3 Sport | Touring V6
 | Mazda6 | Base
 | Mazda5 | SE
 | CX-5 | Tech
 | CX-9 | Regular
 | MX-5 | Matte Paint
 |  | L
 |  | GL
 |  | GLS
 |  | Limited
 |  | 2.4L FWD
 |  | 2.4L Premium FWD
 |  | 2.4L Premium AWD
 |  | 2.4L Luxury
 |  | 2.0T Premium AWD
 |  | 2.0T SE
 |  | 2.0T Limited
 |  | 2.0T Limited w/ Saddle Leather
 |  | GX
 |  | GS
 |  | GT
Spreadsheet: 0d8e8977-3e4b-4ed2-a1a3-4f4e47bdf569
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
 | 5671.0 Lending Finance, Australia
 | TABLE 6. COMMERCIAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($000)
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
Construction finance ; |  |  | Original | A2413488R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Purchase of real property ; |  |  | Original | A2413489T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Wholesale finance ; |  |  | Original | A2413490A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Purchase of plant and equipment ; |  |  | Original | A2413491C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413492F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413493J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413494K | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Commitments not drawn at end of month ; |  |  | Original | A2413495L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 773452d1647871209-conditional-formatting-field-changes-color-based-on-current-date-292-revenue-calculator-copy
Sheet: 292 Calculators

 | Inbound |  |  |  | Outbound |  |  |  |  |  | Inbound |  |  |  |  |  | Inbound
 | Units | Containers | Rate | Revenue | Units | Containers | Rate | Revenue |  |  | Units | Containers | Rate | Revenue |  |  | Units | Containers | Rate | Revenue
Handling |  |  |  |  |  |  |  |  |  | Handling | N/A |  | 270 |  |  | Handling | N/A |  | 270
 |  |  |  |  |  |  |  |  |  | Pallet |  | N/A | 1 |  |  | Pallet |  | N/A | 1
 |  |  |  |  |  |  |  |  |  | Storage (1-15) |  | N/A | 1.98 |  |  | Storage (1-15) |  | N/A | 1.98
 |  |  |  |  |  |  |  |  |  | Storage (16-E) |  | N/A | 0.99 |  |  | Storage (16-E) |  | N/A | 0.99
 |  |  |  |  |  |  |  |  |  |  | Outbound |  |  |  |  |  | Outbound
 |  |  |  |  |  |  |  |  |  |  | Units |  | Rate | Revenue |  |  | Units | Containers | Rate | Revenue
 |  |  |  |  |  |  |  |  |  | Handling |  |  | 2.65 |  |  | Handling |  | N/A | 2.65
 |  |  |  |  |  |  |  |  |  | Total Handling |  |  |  |  |  | Total Handling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CBM 40 = 66    CBM 20 = 33 | Inbound
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CBM | Rate | Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handling |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outbound
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Units |  | Rate | Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pallet |  |  | 13.5
Totals
Grand Total:
Spreadsheet: 722094d1615037998-count-text-column-based-on-two-grouping-columns-group-a-etaf
Sheet: Sheet1

ID# | WEEK | CODE | A
1 | Week1 | A | 1
1 | Week1 | D | 1
1 | Week2 | A | 2
1 | Week2 | A | 2
1 | Week2 | S | 2
2 | Week1 | A | 2
2 | Week1 | A | 2
2 | Week2 | A | 3
2 | Week2 | A | 3
2 | Week2 | D | 3
2 | Week2 | A | 3
Spreadsheet: 66ab9d10-bd0e-49a1-af2f-a991bdc79c89
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6947 | 21844 | [NAME] | Blackett | NZL | 27 | 00:40:14 | 00:00:00 | 01:17:18 | 00:00:00 | [NAME] | 1 | [NAME]
Spreadsheet: 119435d1314385333-match-or-lookup-cant-make-it-work-question-3
Sheet: Sheet1

 | Maximum allowed revenue | 6000
 | Current revenue | 5850
 | Shortfall | -150
 | Revenues
 | Total revenue | 5850
 | Sales price | 100
 | Number of sales | 15 |  |  |  | Alternatives for overtime hours | (The Number of Hours x The Hourly Rate) + Revenue from Sales
 | Revenue from sales | 1500 |  |  |  | 15 | 3750
 |  |  |  |  |  | 17 | 4050
 | Other revenue |  |  |  |  | 19 | 4350
 | Revenue per hour | 150 |  |  |  | 21 | 4650
 | Overtime hours | 29 | <------- | [NAME] |  | 23 | 4950
 | Total revenue from hours | 4350 |  |  |  | 25 | 5250
 |  |  |  |  |  | 27 | 5550
 |  |  |  |  |  | 29 | 5850
 |  |  |  |  |  | 31 | 6150
 |  |  |  |  |  | 33 | 6450
 |  |  |  |  |  | 35 | 6750
Spreadsheet: 834859d1688124072-combine-3-tables-in-one-sheet-into-one-table-in-a-new-sheet-data-archive-test
Sheet: Summary

 |  | Total No. Boxes | No. Of Boxes Checked | No. Of Boxes Already Collected | No. Boxes To Be Collected
 | Total
Box Number | Contents | Number of Boxes | [NAME] | Box               Collected |  | Date Box Collected | Review Date | Destruction Date |  | Box Number | Contents | Number of Boxes | [NAME] | Box               Collected |  | Date Box Collected | Review Date | Destruction Date |  | Box Number | Contents | Number of Boxes | [NAME] | Box               Collected |  | Date Box Collected | Review Date | Destruction Date
 |  | Number of Boxes | [NAME] | Boxes Already Collected | Boxes to be Collected |  |  |  |  |  |  | Number of Boxes | [NAME] | Boxes Already Collected | Boxes to be Collected |  |  |  |  |  |  | Number of Boxes | [NAME] | Boxes Already Collected | Boxes to be Collected
Spreadsheet: 97770d1296853940-sumif-help-with-multiple-tabs-payroll-cards-formula-test
Sheet: BSS-CSP

 |  |  | Hourly | Therapy
 | Hrly Rate | Hrs | Wages | Wages | Salary | OnCall | Total
Noni |  |  |  |  | 500
[NAME] |  |  |  |  | 1200
[NAME] |  |  |  | 550
[NAME] |  |  |  | 600
[NAME] | 11.5 | 42
[NAME] |  |  |  |  | 1500 | 20
Michelle
Bettina | 11.5 | 80
[NAME] |  |  |  |  | 200
Jessica
[NAME] |  |  |  |  | 1275
[NAME] | 13 | 120
Spreadsheet: 61451afe-38b2-4907-bcb3-35f90731f565
Sheet: Ex 26 - Unit Affordability

Exhibit 26: Unit [NAME] and Affordability Worksheet (Rental)
[Project Name]
2014-15 Housing Development NOFA
Enter one type of unit per row; add rows if necessary.
1.  Rental:  Affordable Units
Indicate percentage of AMI used to calculate rents (e.g., 30% of 50% of AMI) | # of Units | Unit Type                (#BR / #Bath) | [NAME] | Maximum Tenant Income* | Per Unit Monthly Rent (Estimated Tenant Contribution) | Name of subsidy that is applied to the unit (If any) | Per Unit Amount of Subsidy Applied To The Unit (If Any) | Per Unit Rent Received** | Total Monthly Rent for Unit Type** | Per Unit Monthly Utility Allowances* | Total Gross Monthly Payment Per Unit (Incl. Utilities) | Accessible Unit? ([NAME], Visual/Hearing, etc)
Total # [NAME] |  |  |  |  |  |  |  | Total Monthly Rental Income |  |  | ↑
2.  Managers' Units***
Indicate percentage of AMI used to calculate rents (e.g., 30% of 50% of AMI) | # of Units | Unit Type                (#BR / #Bath) | [NAME] |  |  |  |  | Proposed Monthly Rent | Total Monthly Rents |  | Rents in this column may not exceed Maximum Rents Per [NAME], Income, Rent & Housing Payment Limits
Total # [NAME] |  |  |  |  |  |  |  | Total Monthly Rental Income
3.  Market Rate Units
 | # of Units | Unit Type                (#BR / #Bath) | [NAME] |  |  |  |  | Proposed Monthly Rent | Total Monthly Rents
Total # [NAME] |  |  |  |  |  |  |  | Total Monthly Rental Income
4.  Affordability Summary/City Restrictions |  |  |  |  |  |  |  |  |  |  | 5.  Annual Rental Revenue
This summary reflects the rent restrictions according to the City's requirements only and won't necessarily match the actual rent structure detailed in table 1 above. |  |  |  |  |  |  |  |  |  |  | Total Monthly Rents for ALL units
 | Total Project Units |  |  | % of Units
 |  |  | % units with annual rents ≤ 30% of 30% AMI |  |  |  |  |  |  |  |  | x12
 |  |  | % units with annual rents ≤ 30% of 60% AMI
 |  |  |  |  |  |  |  |  |  |  | Total Annual Rents for ALL Units
6.  [NAME] Utility Breakdown |  |  |  |  | 7. Unit [NAME]
Indicate which utilites will be paid by tenant (T) and which utilities will be paid by [NAME] (L).
 | Gas | Electric |  |  | Unit Type | # of Units | # of Special Needs Units | # of Homeless Units
Space Heating |  |  |  |  | SRO
Lighting |  |  |  |  | Studio
Cooking |  |  |  |  | 1 bedroom
Hot Water |  |  |  |  | 2 bedroom
Water |  |  |  |  | 3 bedroom
Garbage |  |  |  |  | 4 bedroom
* See [NAME]: "Income, Rent, Utility Allowance, Housing Payments Limits" for current utility allowances and rents.
** Including project-based rental assistance from Section 8, Public Housing ACC, HOPWA, Shelter Plus Care or similar project-based assistance.
*** Rent for manager's unit(s) should be listed as income here and an expense on the operating budget.
Spreadsheet: darrell_schoolcraft__7882__SUNFLOWER - NNG1
Sheet: JUL

NORTHERN NATURAL GAS NOMINATION FORM
FOR SUNFLOWER ELECTRIC (S4 & S5)
ON BEHALF OF WEST PLAINS ENERGY
FOR MONTH OF: |  |  | August
TO: | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FROM: | [NAME]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FAX: | [PHONE]
 | [NAME] |  | [PHONE]
FAX: | [PHONE]
 |  |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL
 | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME
GAS | 1ST |  |  | CON | GAS | 2ND |  |  | CON | GAS | 3RD |  |  | CON | GAS | 4TH |  |  | CON | GAS
DAY | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Spreadsheet: 587413d1535010271-financial-model-scenario-results-based-on-a-switch-to-an-executive-summary-sample
Sheet: Input

Assumptions
 | Year 1 | Year 2 | Year 3
Selling price per unit
Units Sold
Gross Profit Margin
Sales
Gross Profit
Selling Price: Best Case | 35 | 42 | 42
Selling Price: Expected Case | 30 | 30 | 30
Selling Price: Worst Case | 28 | 29 | 30
Units Sold: Best Case | 120 | 130 | 140
Units Sold: Expected Case | 100 | 110 | 120
Units Sold: Worst Case | 75 | 95 | 110
Gross Margin: Best Case | 0.11 | 0.11 | 0.11
Gross Margin: Expected Case | 0.1 | 0.1 | 0.1
Gross Margin: Worst Case | 0.09 | 0.09 | 0.09
Spreadsheet: 187697d1350560321-matching-columns-based-on-another-column-example-formulash
Sheet: Ark1

 | Number | Count |  |  | Number | Count
 | 1 |  |  |  | 2 | 7.9
 | 2 |  |  |  | 3
 | 4 |  |  |  | 1 | 12.8
 | 5 |  |  |  | 7 | 2.3
 | 6 |  |  |  | 5 | 3.2
 | 8 |  |  |  | 4 | 25.4
 |  |  |  |  | 6 | 4.9
 |  | I want an formula that automatically puts the numbers from the right Count-column in the correct left Count-column based on the Number-column.
 |  | Example: Cell G2 to [NAME] (because F2 is 2 and B3 is 2)
 |  | I can't to this with sorting since there sometimes s numbers in one column that is not in the other one.
Spreadsheet: 121331d1316000390-customlookup-function-2-example
Sheet: Sheet1

 |  |  |  | A | B | C | D | E
 |  |  | 1 | 1050 | 1503 | 1521 | 1871 | 1813 |  |  |  | 1 | A
 |  |  | 2 | 1383 | 1268 | 1132 | 1757 | 1333 |  |  |  | 2 | B
 |  |  | 3 | 1857 | 1324 | 1915 | 1297 | 1970 |  |  |  | 3 | C
 |  |  | 4 | 1208 | 1575 | 1332 | 1382 | 1157 |  |  |  | 4 | D
Row Index | 3 |  | 5 | 1581 | 1237 | 1817 | 1900 | 1217 |  |  |  | 5 | E
Col Index | A
Result | 1857
Spreadsheet: 699799d1602772024-totals-from-two-different-tabs-into-a-third-tab-of-the-same-workbook-ledger-example
Sheet: Annual Ledger

Activity | Ref # | Jan Total | Feb Total
Mortgage | 1 |  |  | Need the total for each ref # for both the Checking Account and the Credit Card tabs  to enter in the Annual ledger spreadsheet as shown in the example for Jan Total
Electric | 2
Gas | 3
Phone | 4
Cable | 5
Dining Out | 6
Groceries | 7
[NAME] | 8