tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 04da9706-f116-4859-ad04-b7a858981e52
Sheet: Contact Info & Definitions

CONTACT:
PA Department of Education
Division of Data Quality
333 Market Street
Harrisburg, PA  17126-0333
[NAME]:  [EMAIL]
Phone:  (717) 787-2644
Fax:  (717) 787-3148
Text Telephone TTY:  (717) 783-8445
PROFESSIONAL STAFF SUMMARY
This workbook contains 2011-12 full- and part-time professional staff counts for all public schools
in Pennsylvania as reported by school districts, area vocational-technical schools, charter schools,
intermediate units and state juvenile correctional institutes.
Average Salaries, Years of Service and Education Level are calculated from full-time staff only.
COUNTY AND STATEWIDE TOTAL NOTES
LEVEL TOTALS ARE DISTINCT WITHIN THE LEVEL:
Local Education Agency (LEA) Level: An individual is only counted once per LEA, regardless of the number of schools or buildings where she or he is employed.
County Level: An individual is only counted once per county, regardless of the number of LEAs where she or he is employed.
State Level: An individual is only counted once per state, regardless of the number of LEAs or counties where she or he is employed.
LEA TYPE CODES
CS - Charter School
CTC - Career Technical Center (AVTS)
IU - Intermediate Unit
SD - School District
SJCI - State Juvenile Correctional Institute
EDUCATION LEVEL CODES
1 - Less than high school graduate
2 - High school graduate
3 - Some college, less than bachelor's degree
4 - Bachelor's degree (includes master's equivalency)
5 - Master's degree
6 - Doctor's degree
SALARY CONTRACT YEAR
All salary data are based on the contract year noted in the LEA Averages worksheet. [NAME] names without footnotes in the LEA Averages worksheet reported salaries based on current contracts.
The contract exceptions footnoted in the LEA Averages worksheet apply to other sheets even though the LEA name is not footnoted.
\1 Salaries are based on a contract that expired during the 2010-11 school year.
\2 Salaries are based on a contract that expired during the 2009-10 school year.
\3 Salaries are based on a contract that expired during the 2008-09 school year.
\4 Salaries are based on a contract that expired during the 2005-06 school year.
Data Source: Pennsylvania Information Management System (PIMS)
2011-12 Professional Staff Collection
2012-07-17 00:00:00
Spreadsheet: sally_beck__33830__AS400 Workplan
Sheet: Sheet1

 | AS400 6-week Rolling Workplan |  |  | w/e 20th Oct | w/e 27th Oct | w/e 3rd Nov | w/e 10th Nov | w/e 17th Nov | w/e 24th Nov
 |  |  |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6
 |  | [NAME] |  | [NAME] | VACATION | EOL Bridge | SAP | SAP | SAP
 |  |  |  | EOL Bridge
 |  | [NAME] |  | VACATION | CRR Report | SAP | VACATION | SAP | SAP
 |  | [NAME] |  | [NAME] | VACATION | EOL Bridge | SAP | SAP | SAP
 |  |  |  | EOL Bridge
 |  | [NAME] |  | GCP/SAP | SAP | VACATION | SAP | SAP | SAP
 |  | [NAME] |  | SAP | SAP | SAP | SAP | SAP | SAP
 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  | General support tasks excluded from detail above
 | Key:
 | Work In Progress |  |  | Status
 | SAP |  |  | [NAME] co-ordinating SAP and AS400 development effort
 | [NAME] |  |  | [NAME] defining requirements and co-ordinating implementation
 | EOL Bridge |  |  | UAT and Implemenetation scheduled November
 | Commission new AS400 box |  |  | Currently behind schedule
 | Planned Work |  |  | Sponsors
 | Settlements/Cash Management Process Improvements |  |  | [NAME] compiling list
 | Daily P&L Analytical Tools |  |  | [NAME] compiling list of requirements
 | New York Invoicing Functionality |  |  | [NAME] has passed specification to [NAME]
 | Inventory Management Tools |  |  | [NAME] performing feasibility study of Global Markets newly implemented system and identifying tactical improvements
 | Deal Capture Process Improvements/Automation |  |  | Kevin Rhodes & [NAME] preparing planning document
Spreadsheet: 271982d1382123265-logical-formulas-for-schedule-creation-master-schedule-template
Sheet: Master Schedule

 | WEDNESDAY, MARCH 26 |  |  |  |  |  |  |  |  |  |  |  |  | THURSDAY, MARCH 27 |  |  |  |  |  |  |  |  |  |  |  |  | FRIDAY, MARCH 28 |  |  |  |  |  |  |  |  |  |  |  |  | SATURDAY, MARCH 29 |  |  |  |  |  |  |  |  |  |  |  |  | SUNDAY, MARCH 30
 | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p
Guest Artist 1
Guest Artist 2
Guest Artist 3
Guest Artist 4
Guest Artist 5
Guest Artist 6
Guest Artist 7
Guest Artist 8
Guest Artist 9
Guest Artist 10
Guest Artist 11
Guest Artist 12
Guest Artist 13
Guest Artist 14
Guest Artist 15
Guest Artist 16
Guest Artist 17
Guest Artist 18
Guest Artist 19
Guest Artist 20
Guest Artist 21
Guest Artist 22
Guest Artist 23
Guest Artist 24
Guest Artist 25
Guest Artist 26
Guest Artist 27
Guest Artist 28
Guest Artist 29
Guest Artist 30
Spreadsheet: 43004d1241617748-how-sort-by-largest-to-smallest-column-by-formula-q
Sheet: Sheet1

Name | Number | Key | Sort by Largest
Emily | 10 | 5 | Havit
Joliet | 20 | 4 | [NAME]
[NAME] | 30 | 2 | [NAME]
[NAME] | 30 | 3 | Joliet
Havit | 40 | 1 | Emily
Thanks Answer My Question's, BUT !! ; if column "Number" not ascending order
and what should I do Now ?
For Example
Name | Number | Key | Sort by Largest
Emily | 6 | 8 | [NAME]
Joliet | 16 | 2 | Joliet |  |  | Exact same formulas, just replaced the ranges with the new ranges
[NAME] | 2 | 10 | Havit |  |  | you have to insert the "key" column, it's a formula, too.
[NAME] | 18 | 1 | Havit
Havit | 15 | 4 | [NAME]
[NAME] | 14 | 5 | Emily
Kite | 6 | 8 | Emily
[NAME] | 5 | 9 | Emily
Kely | 6 | 8 | [NAME]
Wilson | 15 | 4 | [NAME]
Spreadsheet: 834056d1687421853-pulling-out-properties-of-a-hierarchy-defined-within-a-data-set-lookups-something-else-excel-problem
Sheet: Sheet1

 |  | Heirachy
Description | Key Point | Tier 1 | [NAME] | Tier 3 | [NAME] | Tier of Parent Key Point
Data 1 | Yes | Data 1 | 0 | 0 | 0 | ???
Data 2 | No | Data 1 | Data 2 | 0 | 0
Data 3 | Yes | Data 1 | Data 2 | Data 3 | 0
Data 4 | No | Data 1 | Data 2 | Data 3 | Data 4
Data 5 | No | Data 1 | Data 2 | Data 5 | 0
Data 6 | No | Data 1 | Data 2 | Data 6 | 0
Data 7 | No | Data 1 | Data 7 | 0 | 0
Data 8 | No | Data 1 | Data 7 | Data 8 | 0
Data 9 | Yes | Data 1 | Data 7 | Data 9 | 0
Data 10 | Yes | Data 10 | 0 | 0 | 0
Data 11 | No | Data 10 | Data 11 | 0 | 0
Data 12 | No | Data 10 | Data 11 | Data 12 | 0
Data 13 | No | Data 10 | Data 11 | Data 13 | 0
Data 14 | No | Data 10 | Data 11 | Data 13 | Data 14
Data 15 | Yes | Data 10 | Data 15 | 0 | 0
Data 16 | No | Data 10 | Data 15 | Data 16 | 0
Data 17 | No | Data 10 | Data 15 | Data 17 | 0
Data 18 | No | Data 10 | Data 15 | Data 18 | 0
Data 19 | No | Data 10 | Data 19 | 0 | 0
Data 20 | Yes | Data 10 | Data 19 | Data 20 | 0
Data 21 | No | Data 10 | Data 19 | Data 20 | Data 21
Data 22 | No | Data 22 | 0 | 0 | 0
Data 23 | Yes | Data 23 | 0 | 0 | 0
Data 24 | No | Data 24 | 0 | 0 | 0
Data 25 | Yes | Data 24 | Data 25 | 0 | 0
Spreadsheet: 781434d1653321639-help-with-possible-nested-if-statement-test
Sheet: Sheet1

Year Start | 2024
Current yr and Quarter | FY22 1ST Q
Proj dollar amount | 100 |  |  |  |  |  |  |  | Alpha | [NAME] | 0.11
project type | beta |  |  |  |  |  |  |  |  | Delta | 0.14
design type | [NAME] |  |  |  |  |  |  |  | Beta | [NAME] | 0.1
 |  |  |  |  |  |  |  |  |  | delta | 0.12
Alpha funds avail
beta funds avail
 |  | FY22 1st Q | FY22 2nd Q | FY22 3rd Q | FY 22 4th Q |  | FY 24 1st Q | FY 24 2nd Q | FY 24 3rd Q | FY 24 4th Q
 |  | FY 23 1st Q | FY 23 2nd Q | FY 23 3rd Q | FY 23 4th Q |  | FY 25 1st Q | FY 25 2nd Q | FY 25 3rd Q | FY 25 4th Q
Spreadsheet: 843729d1695549546-conditional-formula-conditional-formula-required-
Sheet: Sheet1

 |  | premium | intrinsic | balance
 |  | 463.8 | 435.6500000000015
 |  | 418.15 | 385.6500000000015
 |  | 366.6 | 335.6500000000015 |  |  | if Column C greater than Column D then C-D and if Column D price is Zero then answer should be zero.
 |  | 320.5 | 285.6500000000015 |  |  | Please provide [NAME].
 |  | 277.5 | 235.6500000000015
 |  | 237 | 185.6500000000015
 |  | 196.2 | 135.6500000000015
 |  | 161.4 | 85.65000000000146
 |  | 127.6 | 35.65000000000146
 |  | 97 | 0 | 0
 |  | 73.65 | 0 | 0
 |  | 53 | 0 | 0
 |  | 38.5 | 0 | 0
 |  | 27 | 0 | 0
 |  | 18.85 | 0 | 0
 |  | 13.05 | 0 | 0
 |  | 9.15 | 0 | 0
 |  | 6.55 | 0 | 0
 |  | 5.1 | 0 | 0
Spreadsheet: 773233d1647717603-conditional-format-cells-based-upon-matching-cells-and-date-range-from-today-cycle_count_sample_generator_sample
Sheet: Stock Movement Cycle Count

Item No. | Description | Date | Warehouse | Qty | Average Unit Cost | Reason | Transaction Type | Time | Issue to ID | Charge To | Charged-to ID | Ext Cost | Charge-to Site | Serial No. | Equipment No. | To Account Code | To Cost Center | ABC Class | Item Type | Service Code | Current
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL | 2/21/2022 | MCF-MRO | 1 | 5.24 | Physical Inventory | PI | 11:44:52 AM |  |  |  | 5.24 |  | 130271 |  | 101900 | 661200 |  | Stock
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL | 2/21/2022 | MCF-MRO | 0 | 5.24 | Physical Inventory | PI | 9:57:41 AM |  |  |  | 0 |  | 130240 |  |  | 661200 |  | Stock
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL | 2/21/2022 | MCF-MRO | -1 | 5.24 | Physical Inventory | PI | 7:53:43 AM |  |  |  | -5.24 |  | 130181 |  |  | 661200 |  | Stock
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL | 2/21/2022 | MCF-MRO | 1 | 5.24 | Physical Inventory | PI | 7:51:57 AM |  |  |  | 5.24 |  | 130179 |  | 101900 | 661200 |  | Stock
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL | 2/21/2022 | MCF-MRO | 0 | 5.24 | Physical Inventory | PI | 7:51:57 AM |  |  |  | 0 |  | 130180 |  |  | 661200 |  | Stock
998552 | CHAIN , COUPLING CHAIN SPRIAL ELEV N411 | 2/21/2022 | MCF-MRO | -3 | 51.55 | Physical Inventory | PI | 7:46:50 AM |  |  |  | -154.65 |  | 130178 |  |  |  |  | Stock
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL | 2/17/2022 | MCF-MRO | -11 | 5.24 | Physical Inventory | PI | 7:50:11 AM |  |  |  | -57.64 |  | 129761 |  |  | 661200 |  | Stock
994101 | ELEC, ALLEN BRADLEY SLC 5/04 PROCESSOR (1747L541) | 1/14/2022 | MCF-MRO | 0 | 4645 | Physical Inventory | PI | 10:52:33 AM | 2760 |  |  | 0 |  | 124466 |  |  | 661200 |  | Stock
994101 | ELEC, ALLEN BRADLEY SLC 5/04 PROCESSOR (1747L541) | 2021-11-14 00:00:00 | MCF-MRO | 0 | 4645 | Physical Inventory | PI | 10:52:33 AM | 2760 |  |  | 0 |  | 124466 |  |  | 661200 |  | Stock
Spreadsheet: 853630d1703555674-trying-to-get-data-from-a-spreadsheet-and-break-it-down-per-customer-and-per-tech-raw-data
Sheet: timeentrysearch (43)

Member | Company | Hours
[NAME] | Acme | 0.07 |  | [NAME] | 20 |  |  |  | 58.8
[NAME] | US Gov | 1.35 |  | [NAME] | 30 |  |  | [NAME] | 2.49 | 49.8
[NAME] | Acme | 1.82 |  |  |  |  |  | Mark | 0.47 | Unknown
[NAME] | ACME | 0.6 |  |  |  |  |  | [NAME] | 0.3 | 9
[NAME] | US Gov | 0.03
[NAME] | US Gov | 0.02
[NAME] | US Gov | 0.48 |  |  |  |  |  | US Gov | 86.8
Mark | Acme | 0.22 |  |  |  |  |  | [NAME] | 2.88 | 86.39999999999999
[NAME] | US Gov | 0.02 |  |  |  |  |  | [NAME] | 0.02 | 0.4
[NAME] | Acme | 0.3
Mark | Acme | 0.25
[NAME] | US Gov | 1
Spreadsheet: mary_fischer__25628__1473-2001
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF GOODWILL
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: benjamin_rogers__1309__site_visit_schedule for Ross & Fred
Sheet: Schedule

As of…
E2 Site Visit Schedule
 |  |  | [NAME] ([NAME]) | Lincoln (Fred/Ross) | Wheatland (Jeff/Chris) | [NAME] | Pastoria
Week 1 | 2000-10-12 00:00:00 | Thur
 | 2000-10-13 00:00:00 | Fri
Week 2 | 2000-10-16 00:00:00 | Mon
 | 2000-10-17 00:00:00 | Tue
 | 2000-10-18 00:00:00 | Wed |  | Duke (morning)
 |  |  |  | confirm sent
 | 2000-10-19 00:00:00 | Thur |  | NRG (morning)
 |  |  |  | [NAME]
 | 2000-10-20 00:00:00 | Fri |  | Allegheny (morning)
 |  |  |  | confirm sent
Week 3 | 2000-10-23 00:00:00 | Mon
 | 2000-10-24 00:00:00 | Tue
 | 2000-10-25 00:00:00 | Wed |  | Calpine (morning)
 |  |  |  | confirm sent
 | 2000-10-26 00:00:00 | Thur |  | Peco
 |  |  |  | [NAME]
 | 2000-10-27 00:00:00 | Fri
Spreadsheet: 775564d1649181125-formula-for-auto-adjusting-inventory-vs-parts-used-returned-on-two-separate-sheets-sample-inventory-and-parts-used-or-returned-1-
Sheet: Inventory

Part number | Description | quantity begging of the month | quantity taken | quantity returned | quantity at months end
abc1234 | part 1 | 5
abc1113 | part 2 | 30 |  |  |  | This should auto change to 18(30-15+3=18)
abc1211 | part 3 | 2 |  |  |  | this should auto change to 0 (2-2+0=0)
abc1223 | part 4 | 4
abc3111 | part 5 | 11
[NAME] | part 6 | 3 |  |  |  | this should auto change to 2(3-2+1=2)
Spreadsheet: 733185d1621432845-looking-up-an-exact-value-by-using-multiple-inputs-including-a-range-example1
Sheet: Sheet1

Name | Address | Season | Range Low | Range  High | Result |  |  | Inputs
[NAME] | LA | Summer | 0 | 1 | 0.2 |  | Name | [NAME]
[NAME] | LA | Summer | 1.1 | 2 | 0.09 |  | Address | LA
[NAME] | LA | Summer | 2.1 | 3 | 0.16 |  | Season | Winter
[NAME] | LA | Summer | 3.1 | 4 | 0.11 |  | Number | 3.5
[NAME] | LA | Winter | 0 | 2 | 0.23 |  | Result
[NAME] | LA | Winter | 2.1 | 3 | 0.25
[NAME] | LA | Winter | 3.1 | 4 | 0.28
[NAME] | LA | Winter | 4.1 | 5 | 0.4
[NAME] | NY | Summer | 0 | 5 | 0.07
[NAME] | NY | Summer | 5.1 | 10 | 0.5
[NAME] | NY | Summer | 10.1 | 15 | 0.1
[NAME] | NY | Summer | 15.1 | 30 | 0.27
[NAME] | NY | Winter | 0 | 1 | 0.15
[NAME] | NY | Winter | 1.1 | 2 | 0.08
[NAME] | NY | Winter | 2.1 | 3 | 0.02
[NAME] | NY | Winter | 3.1 | 4 | 0.88
George | CA | Summer | 0 | 1 | 1
George | CA | Summer | 1.1 | 2 | 0.99
George | CA | Summer | 2.1 | 3 | 0.03
George | CA | Summer | 3.1 | 4 | 0.02
George | CA | Winter | 0 | 1 | 0.75
George | CA | Winter | 1.1 | 2 | 0.77
George | CA | Winter | 2.1 | 3 | 0.14
George | CA | Winter | 3.1 | 4 | 0.47
Spreadsheet: 776950d1650016271-look-up-formula-lg-enhancement-team-tracking-sheet
Sheet: Candace Bid Details

JOB # | EXCEPTION FORM DATE | SO # | BRANCH NAME | BRANCH | MARKET | CONTRACTOR | TYPE | PROPERTY NAME | JOBS | PROPERTY ADDRESS | BID BY | BID DUE DATE | BID SENT DATE | AWARDED DATE | REVISED DATE | Bid $ | Sold $ | Date of install | DAYS TO CLOSE | HRS | NOTES | DATE OF INSTALL NOTES
D1 |  |  |  |  |  |  |  |  |  |  | CD
Spreadsheet: 672681d1586960455-count-distinct-from-multiple-columns-using-a-single-criterion-book1
Sheet: Sheet3

 | Cities | Restaurant 1 | Unrelated information | Restaurant 3 | Unrelated Information |  | City | Total Restaurants | Distinct Restaurants
 | Boston | McDonalds | Main | Popeyes | Down |  | Boston | 4 | 3
 | Boston | Burger King | Elm | McDonalds | Up |  | Los Angeles | 5 | 3
 | Los Angeles | Wendys | North | Pizza Hut | West
 | Los Angeles | McDonalds | South | Wendys
 | Los Angeles | Pizza Hut | Oak
Spreadsheet: 183088d1348691206-list-of-data-based-on-name-example
Sheet: list

[NAME]
IC |  | Contact
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Project Matrix

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Project Matrix
 | Current Status / Baseline & Problem to be Addressed | Change to Baseline | Type of Impacts | Population Affected by Impacts | Economic Benefit | Summary of Results | Page Reference in BCA
 | [NAME] is a sunken expressway that requires significant repair and maintenance, and encourages travel at higher speeds, increasing probability that accidents result in injury | Removal of eastern portion of [NAME] and replacement with modern at-grade urban boulevard | (1) Lifecycle maintenance and repair savings  (2) Improved safety due to lower travel speeds | (1) City of Rochester (210,855 residents, 2011) and New York State (19.47 million residents, 2011), which pay for maintenance (2) 40 annual auto accident victims who benefit from fewer injuries | (1) Monetized value of lifecycle cost savings (2) Monetized value of prevented injuries | (1) $34,481,937 in undiscounted benefits.  (2) $13,467,310 in undiscounted benefits | pp. 8, 14-15
 | As a multi-lane sunken expressway, the Inner Loop acts as a barrier that frustrates intra-city connections and is a disamenity to surrounding neighborhoods | Creation of four connections across new urban boulevard on eastern portion of [NAME] and improved neighborhood aesthetics | (1) Increased productivity of land due to improved aesthetics and connections (2) Reduced emissions and better health due to mode shifts to walking and bicycling (3) Enhanced productivity by improving access to Downtown employment center | (1) Owners of 911 parcels expected to increase in value (2) 30,293 residents in Greater Center City area (3) Businesses in Downtown Rochester and 7,400 employees who have better access to work | (1) Monetized value of land values increases (2) Not quantified benefit of better health and environment (3) Not quantified benefit of enhanced productivity | (1) $16,741,870 in undiscounted benefits | pp. 12, 15
 | The underutilized Inner Loop prevents development of valuable Downtown parcels occupied by infrastructure | Creation of 8.9 acres of developable land due to removal of infrastructure. | Increased productivity of land | City of Rochester (210,855 residents in 2011) which owns land | Monetized value of land for mixed-use development project | $8,037,000 in undiscounted benefits | pp. 11-12
Spreadsheet: 727737d1618065371-updating-index-function-mealplan
Sheet: Shopping List

 |  | Shopping List | Recipe Index |  | Your shopping list is generated by the recipes selected on the Meal Planner worksheet. The amounts for repeated ingredients are aggregated in the amounts column of the table. The list is sorted for your convenience but filter buttons on the table headings help you search for specific entries. Mark the items you need to buy in the Need to Buy? column.
 | Item | Amount | Need to Buy? | Your shopping list is generated by the recipes selected on the Meal Planner worksheet. The amounts for repeated ingredients are aggregated in the amounts column of the table. The list is sorted for your convenience but filter buttons on the table headings help you search for specific entries. Mark the items you need to buy in the Need to Buy? column | Your shopping list is generated by the recipes selected on the Meal Planner worksheet. The amounts for repeated ingredients are aggregated in the amounts column of the table. The list is sorted for your convenience but filter buttons on the table headings help you search for specific entries. Mark the items you need to buy in the Need to Buy? column.
 |  |  | Yes
Spreadsheet: 684659d1593489436-solved-attempting-to-track-late-times-by-referencing-start-times-in-another-tab-example-2-for-excel-help
Sheet: Report

Agent Name | [NAME] | [NAME] | Late #2
[NAME] | 2020-06-01 00:00:00 | 07:54:00
[NAME] | 2020-06-02 00:00:00 | 08:08:00
[NAME] | 2020-06-03 00:00:00 | 08:06:00
[NAME] | 2020-06-03 00:00:00 | 12:54:56
[NAME] | 2020-06-03 00:00:00 | 13:07:00
[NAME] | 2020-06-01 00:00:00 | 06:06:11
[NAME] | 2020-06-02 00:00:00 | 05:58:39
[NAME] | 2020-06-04 00:00:00 | 06:02:59
[NAME] | 2020-06-05 00:00:00 | 05:50:07
[NAME] | 2020-06-01 00:00:00 | 05:49:56
[NAME] | 2020-06-01 00:00:00 | 12:13:20
[NAME] | 2020-06-02 00:00:00 | 06:06:16
[NAME] | 2020-06-02 00:00:00 | 08:08:07
[NAME] | 2020-06-01 00:00:00 | 05:59:24
[NAME] | 2020-06-02 00:00:00 | 05:58:18
[NAME] | 2020-06-03 00:00:00 | 05:58:22
[NAME] | 2020-06-05 00:00:00 | 05:59:42
[NAME] | 2020-06-08 00:00:00 | 05:59:24
[NAME] | 2020-06-26 00:00:00 | 11:13:15
[NAME] | 2020-06-01 00:00:00 | 08:29:19
[NAME] | 2020-06-01 00:00:00 | 09:41:12
[NAME] | 2020-06-02 00:00:00 | 09:15:35
[NAME] | 2020-06-03 00:00:00 | 08:29:44
[NAME] | 2020-06-03 00:00:00 | 05:57:04
[NAME] | 2020-06-01 00:00:00 | 04:08:00
[NAME] | 2020-06-01 00:00:00 | 06:08:00
[NAME] | 2020-06-02 00:00:00 | 04:09:00
[NAME] | 2020-06-03 00:00:00 | 04:10:00
[NAME] | 2020-06-03 00:00:00 | 04:05:00
Spreadsheet: 799120d1664939758-linking-sheets-with-indirect-not-working-audit-schedule-iatf-2022
Sheet: Sheet2

1) Sales / Marketing
a) Sales (OEM & Exp.) | a
b) [NAME]. (Repl.)
2) Mfg. Process design & Dev. | a
3) Production Planning
4) Manufacturing
a)  Production | a
b)  H.T. |  | a
5)  Insp. & Q.C.
a)   Insp. & Q.C. |  | a
b)   Met. & Chem. Lab. | a
6) Packing |  | a
7) Tooling & Cutting Tool Mgt.
a)  Tool Room
b)  Cutting Tool Division (CTD)
8)  Maintenance
9) Purchasing
a) Purchase (Gen.) | a
b)  [NAME] (R.M.) &   [NAME]. |  | a
10) Stores (Main)
11) Industrial Engineering Deptt.
12) Personnel & Training |  | a
13) Management
a)     Mgt. Review, Int. Audit, [NAME]. Improvement
b) Top management
Prepared by :
Spreadsheet: 81008d1281291646-matrix-forum
Sheet: Names

 |  | Option | Status
 | Name 1 | Option 2 | Start
 | Name 2 | Option 2 | Middle
 | Name 3 | Option 3 | End
 | Name 4 | Option 2 | Middle
 | Name 5 | Option 4 | Start
 | Name 6 | Option 1 | Middle
 | Name 7 | Option 5 | End
 | Name 8 | Option 3 | Middle
 | Name 9 | Option 1 | Start
 | Name 10 | Option 1 | Middle
 | Name 11 | Option 3 | End
 | Name 12 | Option 1 | Start
 | Name 13 | Option 2 | Middle
 | Name 14 | Option 3 | End
 | Name 15 | Option 2 | Middle
 | Name 16 | Option 4 | Middle
 | Name 17 | Option 1 | Start
 | Name 18 | Option 5 | Middle
 | Name 19 | Option 1 | End
 | Name 20 | Option 3 | Middle
 | Name 21 | Option 1 | Middle
 | Name 22 | Option 1 | Middle
 | Name 23 | Option 2 | Start
 | Name 24 | Option 3 | Middle
 | Name 25 | Option 2 | End
 | Name 26 | Option 4 | Middle
 | Name 27 | Option 1 | Middle
 | Name 28 | Option 5 | Start
 | Name 29 | Option 2 | Middle
 | Name 30 | Option 3 | End
Spreadsheet: 642426d1569141884-generic-formula-to-sort-multivalues-in-specific-order-sort-multiple-in-correct-order
Sheet: Sheet1

Specific | All |  | 4 | 1 | 3 | 2
red | blue§green§red§yellow
yellow | yellow
green | red§blue§green
Spreadsheet: 744819d1629465548-trial-balance-using-pivot-table-trial-balance-zwl
Sheet: TB

Group | Account | Financial Category | Sum of Dr/(Cr)
BS | 100 | Land and Buildings | 550487.77
 | 103 | Furniture & Fittings | 2045.5
 | 105 | Cash | 24400
 | 107 | Prepaid Expenses | 600
 | 109 | Purchases Returns | 800
 | 110 | Inventory | 1200
 | 200 | Accounts Payable | -528718.77
 |  | Accruals - Salaries | -1000
 |  | Loan | -26607
 | 300 | Share Capital | -4000
 | 301 | [NAME] | -17807.5
 |  | [NAME] | -7110
BS Total |  |  | -5710
PL | 401 | Advertising & Marketing | 350
 | 402 | Bank Charges | 70
 | 405 | Donations | 100
 | 406 | Electricity | 70
 | 407 | Fuel & Oils | 379
 | 408 | Insurance & Licence | 240
 | 410 | Printing & Stationery | 301
 | 418 | [NAME] | 500
 | 419 | Purchases | 8000
 | 500 | Sales | -2900
PL Total |  |  | 7110
Grand Total |  |  | 1400
Spreadsheet: 869242d1715860303-formula-to-show-saving-up-to-a-cut-off-point-sample-2
Sheet: Sheet1

CTE | 10 | 10 | 10 | 10 | 10 | 10 | 10
Singles | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Budget prod | 100 | 100 | 100 | 100 | 100 | 100 | 100
Cost
Acheived prod | 105 | 106 | 107 | 108 | 109 | 110 | 111
Actual cost
Total Saving
Prod % change
Declared saving (max 8%)