tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 689525d1596478926-offset-troubles-cash-forecast-sample
Sheet: Cons Daily F'Cast

GBP | Period
 | Day | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday
 | Date | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-31 00:00:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-07 00:00:00 | 2020-09-08 00:00:00 | 2020-09-09 00:00:00 | 2020-09-10 00:00:00 | 2020-09-11 00:00:00 | 2020-09-14 00:00:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | 2020-09-17 00:00:00 | 2020-09-18 00:00:00 | 2020-09-21 00:00:00 | 2020-09-22 00:00:00 | 2020-09-23 00:00:00 | 2020-09-24 00:00:00 | 2020-09-25 00:00:00 | 2020-09-28 00:00:00 | 2020-09-29 00:00:00 | 2020-09-30 00:00:00 | 2020-10-01 00:00:00 | 2020-10-02 00:00:00 | 2020-10-05 00:00:00 | 2020-10-06 00:00:00 | 2020-10-07 00:00:00 | 2020-10-08 00:00:00 | 2020-10-09 00:00:00 | 2020-10-12 00:00:00 | 2020-10-13 00:00:00 | 2020-10-14 00:00:00 | 2020-10-15 00:00:00 | 2020-10-16 00:00:00 | 2020-10-19 00:00:00 | 2020-10-20 00:00:00 | 2020-10-21 00:00:00 | 2020-10-22 00:00:00 | 2020-10-23 00:00:00 | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00 | 2020-11-02 00:00:00 | 2020-11-03 00:00:00 | 2020-11-04 00:00:00 | 2020-11-05 00:00:00 | 2020-11-06 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-23 00:00:00 | 2020-11-24 00:00:00 | 2020-11-25 00:00:00 | 2020-11-26 00:00:00 | 2020-11-27 00:00:00 | 2020-11-30 00:00:00
 | year.month
 | year.week
 | AR
 | [NAME]
 | APT
 | APNT Vendor
 | APNT Expenses
 | [NAME]
 | [NAME]
 | [NAME]
 | IP Net Pay
 | IP Tax
 | IP Social
 | IP Other
 | Tax VAT
 | Tax CT
 | Tax Other
 | CoSec/Legal
 | [NAME]
 | Other
Spreadsheet: 871151d1717573518-filtering-data-if-condition-is-met-in-at-least-1-column-book1
Sheet: Sheet1

Name | [NAME] | Area2 | GrowsApples | GrowsOranges | Tags
[NAME] | True | False | True | False | Area1,GrowsApples
[NAME] | True | True | True | False | Area1,Area2,GrowsApples
[NAME] | True | True | True | True | Area1,Area2,GrowsApples,GrowsOranges
[NAME] | False | False | False | False
[NAME]
[NAME]
Spreadsheet: 84962d1285060847-convert-numbers-to-date-in-text-string-convert-number-to-date
Sheet: Sheet2

 | 1 | April | WD | Apollo Days
 | 1 | April | 23 | 19.36 | 2010-04-05 00:00:00 | 2010-05-07 00:00:00
 | 2 | May | 19 | 15.36 | 2010-05-10 00:00:00 | 2010-06-04 00:00:00
 | 3 | June | 20 | 16.36 | 2010-06-07 00:00:00 | 2010-07-02 00:00:00
 | 4 | July | 25 | 21.36 | 2010-07-05 00:00:00 | 2010-08-06 00:00:00
 | 5 | August | 19 | 15.36 | 2010-08-09 00:00:00 | 2010-09-03 00:00:00
 | 6 | September | 25 | 21.36 | 2010-09-06 00:00:00 | 2010-10-08 00:00:00
 | 7 | October | 20 | 16.36 | 2010-10-11 00:00:00 | 2010-11-05 00:00:00
 | 8 | November | 20 | 16.36 | 2010-11-08 00:00:00 | 2010-12-03 00:00:00
 | 9 | December | 21 | 17.36 | 2010-12-06 00:00:00 | 2011-01-07 00:00:00
 | 10 | January | 20 | 16.36 | 2011-01-10 00:00:00 | 2011-02-04 00:00:00
 | 11 | February | 20 | 16.36 | 2011-02-07 00:00:00 | 2011-03-04 00:00:00
 | 12 | March | 25 | 21.36 | 2011-03-07 00:00:00 | 2011-04-08 00:00:00
Spreadsheet: 389842d1429297337-formula-to-list-of-product-groups-that-have-the-most-products-with-zero-sales-example-book
Sheet: Sheet1

 | Worst Product Groups |  |  |  |  |  |  | Product Group | Product | Sales
1 | PG3 |  | The formulas would go  <-- here.  And they would be pulling data from the query to the right.                                   ---> |  |  |  |  | PG1 | P1 | 2
2 | PG9 |  |  |  |  |  |  | PG1 | P2 | 0
3 | PG10 |  |  |  |  |  |  | PG1 | P3 | 3
4 | PG1 |  |  |  |  |  |  | PG1 | P4 | 3
5 | PG2 |  |  |  |  |  |  | PG1 | P5 | 1
 |  |  |  |  |  |  |  | PG2 | P1 | 1
 |  |  |  |  |  |  |  | PG2 | P2 | 0
 |  |  |  |  |  |  |  | PG2 | P3 | 3
 |  |  |  |  |  |  |  | PG2 | P4 | 1
 |  |  |  |  |  |  |  | PG2 | P5 | 1
 |  |  |  |  |  |  |  | PG3 | P1 | 0
 |  |  |  |  |  |  |  | PG3 | P2 | 3
 |  |  |  |  |  |  |  | PG3 | P3 | 3
 |  |  |  |  |  |  |  | PG3 | P4 | 0
 |  |  |  |  |  |  |  | PG3 | P5 | 0
 |  |  |  |  |  |  |  | PG4 | P1 | 1
 |  |  |  |  |  |  |  | PG4 | P2 | 2
 |  |  |  |  |  |  |  | PG4 | P3 | 2
 |  |  |  |  |  |  |  | PG4 | P4 | 2
 |  |  |  |  |  |  |  | PG4 | P5 | 1
 |  |  |  |  |  |  |  | PG5 | P1 | 2
 |  |  |  |  |  |  |  | PG5 | P2 | 3
 |  |  |  |  |  |  |  | PG5 | P3 | 3
 |  |  |  |  |  |  |  | PG5 | P4 | 2
 |  |  |  |  |  |  |  | PG5 | P5 | 1
 |  |  |  |  |  |  |  | PG6 | P1 | 0
 |  |  |  |  |  |  |  | PG6 | P2 | 3
 |  |  |  |  |  |  |  | PG6 | P3 | 1
 |  |  |  |  |  |  |  | PG6 | P4 | 3
 |  |  |  |  |  |  |  | PG6 | P5 | 2
 |  |  |  |  |  |  |  | PG7 | P1 | 3
 |  |  |  |  |  |  |  | PG7 | P2 | 3
 |  |  |  |  |  |  |  | PG7 | P3 | 2
 |  |  |  |  |  |  |  | PG7 | P4 | 1
 |  |  |  |  |  |  |  | PG7 | P5 | 0
 |  |  |  |  |  |  |  | PG8 | P1 | 2
 |  |  |  |  |  |  |  | PG8 | P2 | 1
 |  |  |  |  |  |  |  | PG8 | P3 | 1
 |  |  |  |  |  |  |  | PG8 | P4 | 0
 |  |  |  |  |  |  |  | PG8 | P5 | 1
 |  |  |  |  |  |  |  | PG9 | P1 | 1
 |  |  |  |  |  |  |  | PG9 | P2 | 0
 |  |  |  |  |  |  |  | PG9 | P3 | 1
 |  |  |  |  |  |  |  | PG9 | P4 | 1
 |  |  |  |  |  |  |  | PG9 | P5 | 0
 |  |  |  |  |  |  |  | PG10 | P1 | 3
 |  |  |  |  |  |  |  | PG10 | P2 | 2
 |  |  |  |  |  |  |  | PG10 | P3 | 0
 |  |  |  |  |  |  |  | PG10 | P4 | 0
 |  |  |  |  |  |  |  | PG10 | P5 | 3
Spreadsheet: kenneth_lay__19470__1122_Notification
Sheet: Sheet1

 |  |  | To: |  | [NAME], [NAME] |  |  |  |  | Risk Policy Notification Requirements
 |  |  | Copy to: |  | Distribution |  |  |  |  |  |  |  | Skilling |  | Lay |  |  | Finance Committe Chairman
 |  |  |  |  |  |  |  |  |  | Daily Loss |  |  | 50% of VaR |  | 75% of VaR |  |  | Aggregate Loss > 100% Aggregate VaR Limit
 |  |  | From: |  | Global Risk Management Operations |  |  |  |  | Cumulative 5-day Loss |  |  | 75% of VaR |  | 100% of VaR
 |  |  |  |  |  |  |  |  |  | NOP, M/G, VaR |  |  | 105% of VaR |  | 110% of VaR |  |  | Aggregate VaR > 100% Aggregate VaR Limit
 |  |  | Date: |  | 2000-11-22 00:00:00
 |  |  | Re: |  | Limit Notifications
 |  |  |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  |  |  | Violation/
 | Occurrence |  |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Date |  | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  |  |  | ($MMs) |  |  | ($MMs) |  |  | ($MMs) |  | ($MMs)
Lay Level Notifications
1 | 2000-11-22 00:00:00 |  | Enron Energy Services |  | Gas & Power Trading |  | 7 | n/a | Daily Loss | -7.2 | 15 |  | 47.411 |  | 315.553 |  |  | West power prices increased on short-term and long-term short positions
Skilling Level Notifications
1 | 2000-11-22 00:00:00 |  | Enron North America |  | Gas Trading |  | 60 | n/a | Daily Loss | -33 | 9 |  | 147.95714634 |  | 859.5705433599999 |  |  | Prompt winter Nymex prices rising on a prompt winter short Nymex position and a softening of California basis
2 | 2000-11-22 00:00:00 |  | Enron |  | Total Trading |  | 85 | n/a | Aggregate Daily Loss | -47.6 | 8 |  | 300.8 |  | 2388.8 |  |  | Due to: ENA Gas loss of $33 Million, ENA Power loss of $10 Million, and EES loss of $7 Million
RAC COMMENTS:
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 725788d1616859471-index-aggregate-multiple-criteria-and-columns-to-search-problem1-1-
Sheet: Sheet1

Product | Component | Quantity |  | Product | Component | Country | Qty In | Qty Out | Value | Item | Box |  |  | Label |  |  | Bag
Beverage | [Item] Tea |  |  | Beverage | [Item] Tea | - | 50 | - | - | Beverage | Box A | 1 | 11 | [NAME] | 2 | 11 | Bag S | 8 | 11
Beverage | [Item] Juice |  |  | Beverage | [Item] Juice | - | 50 | - | - | Flower | [NAME] | 2 | 12 | [NAME] | 1 | 12 | Bag M | 5 | 12
Beverage | Box A |  |  | Flower | [Item] Tulip | - | 100 | - | - | Furniture | Box C | 3 | 24 | [NAME] | 10 | 24 | Bag L | 6 | 24
Beverage | [NAME] |  |  | Furniture | [Item] Tea | - | 75 | - | - | Food | Box D | 4 | 36 | [NAME] | 8 | 36 | Bag XL | 11 | 36
Beverage | Bag S |  |  | Furniture | [Item] Chair | - | 150 | - | - | Pets | Box A | 5 | 12 | [NAME] | 4 | 12 | Bag M | 3 | 12
Food | [Item] Bacon |  |  | Furniture | [Item] Couch | - | 76 | - | -
Food | [Item] Egg |  |  | Food | [Item] Bacon | - | 188 | - | -
Food | Box D |  |  | Food | [Item] Egg | - | 125 | - | -
Food | [NAME] |  |  | Pets | [Item] Cat | - | 304 | - | -
Food | Bag XL
Flower | [Item] Tulip
Flower | [NAME]
Flower | [NAME]
Flower | Bag M
Furniture | [Item] Tea
Furniture | [Item] Chair
Furniture | [Item] Couch
Funiture | Box C
Funiture | [NAME]
Funiture | Bag L
Spreadsheet: 219183d1362679061-issue-using-array-formulas-tigeravatar-example-for-apiekar42
Sheet: Tab 1

[NAME] | Value | Rank
ABC | 10 | 4
DEF | 15 | 3
GHI | 10 | 4
JKL | 5 | 6
MNO | 20 | 1
PQR | 20 | 1
Spreadsheet: tracy_geaccone__40213__EGA fcst
Sheet: Aug 15 - EGAS without Azurix

Enron Global Assets - Without Azurix
(Millions of Dollars)
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Revised |  | Prior |  | From Prior
 |  |  |  |  |  | Forecast |  | Forecast |  | Forecast |  | Plan
Income Before Int. Expense & Income Taxes * |  |  |  |  |  | -12.6
Interest Expense
 | 3rd Party interest expense |  |  |  |  | 9.4
 | Intercompany capital charge expense (income)
 | Other intercompany interest expense (income)
 | Other - including capitalized interest |  |  |  |  | 0 |  | 0
Minority Interest |  |  |  |  |  | 1.4
Pre-tax income
Income Tax |  |  |  |  |  | -14.4
Net Income before Financing Costs
[NAME] (items greater than $1.0) |  |  |  |  |  |  |  |  |  | Interest |  |  |  | Net
 |  |  |  |  |  |  |  | IBIT |  | Expense |  | Taxes |  | Income
Prior Forecast
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Other |  |  |  |  |  |  | 0 |  | 0 |  | 0
Current Forecast
*    INCOME BEFORE INTEREST EXPENSE AND INCOME TAXES INCLUDES OUTSIDE (NOT INTERCOMPANY)
INTEREST INCOME.
Spreadsheet: 217832d1362214364-leave-planner-data-validation-and-windows-nt-based-permissions-for-cell-leave-test
Sheet: Sheet1

 |  | 2013-03-01 00:00:00
Name | Role | 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
 |  | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 | 2013-03-10 00:00:00 | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00 | 2013-03-16 00:00:00 | 2013-03-17 00:00:00 | 2013-03-18 00:00:00 | 2013-03-19 00:00:00 | 2013-03-20 00:00:00 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | 2013-03-23 00:00:00 | 2013-03-24 00:00:00 | 2013-03-25 00:00:00 | 2013-03-26 00:00:00 | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | 2013-03-29 00:00:00 | 2013-03-30 00:00:00 | 2013-03-31 00:00:00
Suzi Jaeger | Manager | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P
Lily Holness | Design | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P
[NAME] | Testing | L |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P
Regan Berlin | Development | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P
[NAME] | Sales | P |  |  | L | L | L | L | L |  |  | L | L | L | L | L |  |  | P | P | P | P | P |  |  | P | P | P | P | P
Adolfo [NAME] | Customer care | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | L |  |  | P | P | P | P | P
[NAME] | Design | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P
[NAME] | Testing | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | L |  |  | L | L | P | P | P
Kirstin Siemers | Development | P |  |  | P | P | P | P | P |  |  | P | P | P | P | L |  |  | L | L | L | L | P |  |  | P | P | P | P | P
[NAME] | Sales | P |  |  | P | P | P | P | P |  |  | P | P | P | P | LO |  |  | P | P | P | P | P |  |  | P | P | P | P | P
[NAME] | Customer care | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P
[NAME] | Development | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legend | Leave | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Working | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leave Override | LO | Requires manager approval
Spreadsheet: 77705d1278126649-excel-2007-vlookup-not-working-vlookup
Sheet: NWOS 2008

Fee Conversion
CODE | MOD |  |  | CODE | MOD | [NAME]
AA |  |  | AA.03 | AA |  | ANESTHESIA, 15 MIN UNIT
10021 |  |  | 10021.03 | 10021 | 0 | Fine Needle Aspiration
10022 |  |  | 10022.03 | 10022 |  | Fine Needle Aspiration
10040 |  |  | 10040.03 | 10040 |  | [NAME]
10140 |  |  | 10140.03 | 10140 |  | Drainage Of Hematoma/Fluid
10160 |  |  | 10160.03 | 10160 |  | Puncture Drainage Of Lesion
10180 |  |  | 10180.03 | 10180 |  | Complex Drainage, Wound
11000 |  |  | 11000.03 | 11000 |  | Surgical Cleansing Of Skin
11001 |  |  | 11001.03 | 11001 |  | Additional Cleansing Of Skin
11010 |  |  | 11010.03 | 11010 |  | Debride Skin, Fx
11057 |  |  | 11057.03 | 11057 |  | Trim Over 4 Skin Lesions
11100 |  |  | 11100.03 | 11100 |  | Biopsy Of Skin Lesion
11101 |  |  | 11101.03 | 11101 |  | Biopsy, Each Added Lesion
11200 |  |  | 11200.03 | 11200 |  | Removal Of Skin Tags
11201 |  |  | 11201.03 | 11201 |  | Removal Of Added Skin Tags
11310 |  |  | 11310.03 | 11310 |  | Shave Skin Lesion
11311 |  |  | 11311.03 | 11311 |  | Shave Skin Lesion
11312 |  |  | 11312.03 | 11312 |  | Shave Skin Lesion
11313 |  |  | 11313.03 | 11313 |  | Shave Skin Lesion
11423 |  |  | 11423.03 | 11423 |  | Removal Of Skin Lesion
11424 |  |  | 11424.03 | 11424 |  | Removal Of Skin Lesion
11426 |  |  | 11426.03 | 11426 |  | Removal Of Skin Lesion
11440 |  |  | 11440.03 | 11440 |  | Removal Of Skin Lesion
11441 |  |  | 11441.03 | 11441 |  | Removal Of Skin Lesion
11442 |  |  | 11442.03 | 11442 |  | Removal Of Skin Lesion
11443 |  |  | 11443.03 | 11443 |  | Removal Of Skin Lesion
11444 |  |  | 11444.03 | 11444 |  | Removal Of Skin Lesion
11446 |  |  | 11446.03 | 11446 |  | Removal Of Skin Lesion
11450 |  |  | 11450.03 | 11450 |  | Removal, Sweat Gland Lesion
Spreadsheet: 687590d1595300370-populate-a-spread-sheet-based-on-data-that-is-structured-differently-example-workbook-updated-1-
Sheet: Data Collection 

Rejections
Assessment Date | Assessed By | Product: | Type/Variety | Class: | Packed On: | Receival Temp: | Qty Received | Quantity Rejected | Unit Of Measurement | Defect | Major Defect | Minor Defect | No Of Products With Defect Major | No Of Products With Defect Minor | Total Units Assessed | Total % Out Of Spec Major | Total Units Out of spec Minor | No. Ctns Used For Assessment | Qty Rejected | Supplier | Response
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BEEGEE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rose
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Verra
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.26.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-26 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 11 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 20 | 2 | 4 | 0 | 3 | 1 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 5 | 1 | 2 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 23 | 0 | 6 | 1 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 2 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-26 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 3 | 1 | 1 | 0 | 1 | 2 | 0
 | 5TH FL | 34 | 20 | 23 | 0 | 4 | 0 | 2 | 0 | 0 | 2.5 | 0
 | ABC | 27 | 18 | 24 | 0 | 6 | 1 | 2 | 0 | 1 | 3 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 2 | 0 | 1 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: 2-EH Acid

Raw Material |  | 2-EH Acid
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 297
Total
Spreadsheet: 6ccda76c-fe42-41d6-bc86-e95b79061628
Sheet: FullDayKOverride

School District |  |  | District Code |  |  | * Round to Nearest Dollar *
Fund 24 : Full-Day [NAME]
 |  |  | Prior Year Actual - Audited FY11-12 | Current Fiscal Year - Budgeted FY12-13 | Current Fiscal Year - Projected FY12-13 | Original Ensuing Fiscal Year - Budget FY13-14 | Adjustments Ensuing Fiscal Year - Budget FY13-14 | Revised Ensuing Fiscal Year - Budget FY13-14
 |  |  |  |  |  |  | Record Inceases to revenue are positive amounts and Decreases as negatives | Figures (Totals) which will appear on Budget Form to Submit to CDE
Codes: | BEGINNING FUND BALANCE |  | 0 | 0 | 0 | 0 | 0
Source |  | REVENUE AND OTHER SOURCES
1110 | 1. | Current Property Taxes | 0 | 0 | 0 | 0 | 0
1120 | 2. | Specific Ownership Taxes | 0 | 0 | 0 | 0 | 0
1140 | 3. | Delinquent Taxes and Penalties | 0 | 0 | 0 | 0 | 0
1410-1411 | 4. | Transportation Fees From Individuals | 0 | 0 | 0 | 0 | 0
1420-1430 | 5. | Transportation Fees From Other School Districts or BOCES | 0 | 0 | 0 | 0 | 0
1440 | 6. | Transportation Fees form Other Sources | 0 | 0 | 0 | 0 | 0
1490 | 7. | Other Transportation Fees | 0 | 0 | 0 | 0 | 0
1500 | 8. | Earnings on Investments | 0 | 0 | 0 | 0 | 0
3160 | 9. | State Transportation Revenues | 0 | 0 | 0 | 0 | 0
52XX | 10. | Transfer From________________Fund(s) (Net to zero across all funds)* | 0 | 0 | 0 | 0 | 0
 | 11. | Other Revenues | 0 | 0 | 0 | 0 | 0
 | 12. | TOTAL REVENUE (Sum of lines 1-11)
TOTAL REVENUE INCLUDING BEGINNING FUND BALANCE (Sum of line 12 and BFB)
Object |  | EXPENDITURES AND OTHER USES
0100 | 13. | Salaries - from staff details tab | 0 | 0 | 0 |  | 0
0100-0199 | 13. | Salaries - additional items | 0 | 0 | 0 | 0 | 0
0200 | 14. | Employee Benefits - from staff details tab | 0 | 0 | 0 |  | 0
0200-0299 | 14. | Employee Benefits - addl items | 0 | 0 | 0 | 0 | 0
0300-0399 | 15. | Purchased Professional and Technical Services | 0 | 0 | 0 | 0 | 0
0400-0499 | 16. | Purchased Property Services | 0 | 0 | 0 | 0 | 0
0500-0599 | 17. | Other Purchased Services | 0 | 0 | 0 | 0 | 0
0600-0699 | 18. | Supplies | 0 | 0 | 0 | 0 | 0
0700-0739 | 19. | Property/Equipment | 0 | 0 | 0 | 0 | 0
0732 | 20. | Vehicles | 0 | 0 | 0 | 0 | 0
0740 | 21. | Depreciation | 0 | 0 | 0 | 0 | 0
0800-0999 | 22. | Other Expenditures | 0 | 0 | 0 | 0 | 0
 | 23. | TOTAL EXPENDITURES AND OTHER USES (Sum of lines 13-22)
Program |  | APPROPRIATED RESERVES
9100 | 24. | Operating Reserve | 0 | 0 | 0 | 0 | 0
9310 | 25. | TABOR Emergency Reserve | 0 | 0 | 0 | 0 | 0
9320 | 26. | Reserve for Multi-Year Obligations | 0 | 0 | 0 | 0 | 0
932X | 27. | Other Restricted Reserves | 0 | 0 | 0 | 0 | 0
9900 | 28. | Other Reserves | 0 | 0 | 0 | 0 | 0
 | 29. | TOTAL APPROPRIATED RESERVES (Sum of lines 24-28)
TOTAL TRANSPORTATION FUND EXPENDITURES AND APPROPRIATED RESERVES (Sum of lines 23 & 29)
 |  | ---MUST EQUAL AMOUNT ON APPROPRIATION RESOLUTION PAGE---
 |  | TOTAL NET REVENUE
 |  | DIFFERENCE MUST EQUAL 0
*State Statute prohibits the transfer of funds out of the Full Day [NAME]
Spreadsheet: 862021d1709820843-sick-pay-entitlement-based-on-length-of-service-dummy-sickpay-
Sheet: Sheet1

 |  |  |  |  | Startdate | Year service
 |  |  |  |  | 2020-09-07 00:00:00
Name:
Number of working hours | 10
Normal Working days | 5
 |  |  |  |  |  |  | Number of weeks Full Pay | Number of weeks half Pay
End Date of last sickness |  | 2024-03-08 00:00:00 |  |  |  | Less Than 6 months service | SSP | SSP
No of Sick Days in  12 month Period |  |  |  |  |  | Less than 1 year servcie | 1 | 1
Number of sick [NAME] |  |  |  |  |  | One to two years' service: | 2 | 2
 |  |  |  |  |  | Two to three years’ service: | 4 | 4
 |  |  |  |  |  | Three years service and above | 6 | 6
First Day of Absence | Last Day of Absence | Number of Days off | Reason for Absence | Days of Week off
2022-06-22 00:00:00 | 2022-06-27 00:00:00 |  |  |  |  | Total Days Entitelment
2022-08-10 00:00:00 | 2022-08-11 00:00:00
2022-11-14 00:00:00 | 2022-11-25 00:00:00
2022-12-28 00:00:00 | 2022-12-30 00:00:00
2023-02-28 00:00:00 | 2023-03-02 00:00:00 |  |  |  |  | Days Entitlement used
2023-05-09 00:00:00 | 2023-05-11 00:00:00
2024-02-27 00:00:00 | 2024-03-01 00:00:00 |  | Fall at home
2024-03-06 00:00:00 | 2024-03-08 00:00:00 |  | swollen/painful foot
Spreadsheet: 35a6892f-d226-4676-8fe9-8b7357562ce8
Sheet: Sheet1

FY 2013 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-DEC | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | DEC | REMAINING
1 | [NAME] 1 | 12252023 | 1225203 | 4900812 | 7351211
5 | PRAIRIE LAKES AEA 8 | 12262873 | 1226292 | 4905168 | 7357705
7 | AEA 267 | 25621579 | 2562162 | 10248648 | 15372931
9 | MISSISSIPPI BEND AEA 9 | 18256425 | 1825645 | 7302580 | 10953845
10 | GRANT WOOD AEA 10 | 25694279 | 2569428 | 10277712 | 15416567
11 | HEARTLAND AEA 11 | 47311975 | 4731203 | 18924812 | 28387163
12 | NORTHWEST AEA | 15237716 | 1523774 | 6095096 | 9142620
13 | GREEN HILLS AEA 13 | 14922450 | 1492246 | 5968984 | 8953466
15 | GREAT PRAIRIE AEA 15 | 13628215 | 1362826 | 5451304 | 8176911
 |  | 185187535 | 18518779 | 74075116 | 111112419