tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160827d1339232515-formula-question-regarding-moving-data-from-one-sheet-to-another-example-sheets
Sheet: Sheet1

 | Title 1 | Compared to | Title 2
Attribute 1
Attribute 2
Attribute 3
Attribute 4
Attribute 5
Attribute 6
Attribute 7
Attribute 8 |  |  |  |  |  |  |  | Please see SHEET 2 for the data source. By selecting cells B1 and D1 in this sheet, you can change the 'title', which refers to columns B-Y in Sheet2. I would like selecting whichever Title to also bring over all the relevant data from the chosen column...
Attribute 9
Attribute 10
Attribute 11
Attribute 12
Attribute 13
Attribute 14
Attribute 15
Attribute 16
Attribute 17
Attribute 18
Attribute 19
Attribute 20
Attribute 21
Attribute 22
Attribute 23
Attribute 24
Attribute 25
Attribute 26
Attribute 27
Attribute 28
Attribute 29
Attribute 30
Attribute 31
Spreadsheet: 818734d1677019584-if-statement-calculating-a-total-and-then-giving-a-different-result-otcto-calc
Sheet: Sheet1

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Hours Worked | 8 | 8 | 12 | 8 | 16 | 8 | 8
# Regular |  |  |  |  | 4
# OT/CTO
Spreadsheet: jeff_dasovich__14091__Scores99
Sheet: Week #4

 |  |  |  |  |  |  | = | 1st place
 |  |  |  |  |  |  | = | 2nd place |  |  |  | = | winning points for |  |  |  | WEEK 4
 |  |  |  |  |  |  | = | 3rd place
 |  | Prior Rank | New Rank | Prior Total | New Total | Weekly Total | NE | Cle | Jac | Pitt | AZ | Dal | Phi | NYG | TB | Minn | Balt | Atl | NO | [NAME] | St L | Cin | Car | Was | NYJ | Den | KC | SD | Ten | SF | Oak | Sea | [NAME] | [NAME]
3 | [NAME]* | 1 |  | 251
 | Helmet* | 2 |  | 243
 | JAM | T 3 |  | 236
4 | Prentice | T 3 |  | 236
 | Narvco* | 5 |  | 235
 | [NAME]* | 6 |  | 233
 | [NAME] | T 7 |  | 231
 | Barrie | T 7 |  | 231
 | [NAME]* | 9 |  | 229
 | [NAME]* | 10 |  | 227
 | [NAME] | 11 |  | 226
2 | Eldon | 12 |  | 225
 | [NAME]* | 13 |  | 224
 | Carlton* | 14 |  | 221
 | WAM | 15 |  | 218
 | Mike&Lisa | 16 |  | 217
1 | Cameron | 17 |  | 213
 | [NAME] | 18 |  | 209
 | Growney | 19 |  | 208
 | [NAME] | 20 |  | 204
 | TOTAL
 | AVERAGE
 | * = still a member of the "Last Person Standing" Pool (have not lost their 15 point game)
 | No Name |  | 98 | 98 |  |  | 15 |  |  | 12 |  | 10 | 9 |  | 13 |  | 5 |  |  | 8 |  | 6 | 4 |  |  | 11 | 2 |  |  | 3 |  | 7 | 14
 | Edge |  | 144 | 144
Spreadsheet: 772617d1647407644-enter-text-every-7th-date-book1
Sheet: Sheet5

2022-09-30 00:00:00
Spreadsheet: 819038d1677185422-looking-exact-criteria-from-other-sheet-parts
Sheet: Sheet1

Part | Qty Required | Intended result
52755 | 10 | none
56160 | 14 | ALLAIIPL
56173 | 5 | ALLAIIPL
5639 | 145 | [NAME]
56798 | 140
57760 | 9
58541 | 6
70017 | 2
70057 | 6
7076 | 150
72404 | 50
Spreadsheet: 43915d1242573403-auto-populating-a-template-tops-raw-data-16-may-09-v1-
Sheet: TOPs raw data - 16 may 09

Client First Name | SURNAME | [NAME] | GENDER | START_DATE | BOT DATE | BOT STAGE
A | c | 1967-02-02 00:00:00 | Male | 2008-12-02 00:00:00 | 2008-12-11 00:00:00 | BOT Review
A | R | 1980-01-31 00:00:00 | Male | 2009-02-17 00:00:00
A H | P | 1980-01-21 00:00:00 | Male | 2009-02-10 00:00:00 | 2009-04-17 00:00:00 | BOT Review
A H | P | 1980-01-21 00:00:00 | Male | 2009-02-10 00:00:00 | 2009-02-24 00:00:00 | BOT start
A H | P | 1980-01-21 00:00:00 | Male | 2009-02-10 00:00:00 | 2009-05-01 00:00:00 | BOT Review
A | Z | 2022-01-01 00:00:00 | Male | 2008-11-01 00:00:00 | 2009-04-27 00:00:00 | BOT Review
A | Z | 2022-01-01 00:00:00 | Male | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | BOT Start
A | Z | 2022-01-01 00:00:00 | Male | 2008-11-01 00:00:00 | 2009-02-13 00:00:00 | BOT Review
A | X | 1976-01-23 00:00:00 | Female | 2008-11-05 00:00:00 | 2009-04-29 00:00:00 | BOT Review
A | X | 1976-01-24 00:00:00 | Female | 2008-11-05 00:00:00 | 2009-02-17 00:00:00 | BOT Review
A | X | 1976-01-25 00:00:00 | Female | 2008-11-05 00:00:00 | 2008-11-11 00:00:00 | BOT Start
Z | M | 1997-01-01 00:00:00 | Female | 2008-11-01 00:00:00 | 2009-04-01 00:00:00 | BOT Review
Z | M | 1997-01-02 00:00:00 | Female | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | BOT Start
Z | M | 1997-01-03 00:00:00 | Female | 2008-11-01 00:00:00 | 2009-02-17 00:00:00 | BOT Review
zx | zx | 1961-01-14 00:00:00 | Female | 2009-02-05 00:00:00 | 2009-02-23 00:00:00 | BOT Start
zx | zx | 1961-01-14 00:00:00 | Female | 2009-02-05 00:00:00 | 2009-04-17 00:00:00 | BOT Review
SA | ZA | 1961-07-17 00:00:00 | Male | 2008-11-01 00:00:00 | 2009-04-20 00:00:00 | BOT Review
SA | ZA | 1961-07-17 00:00:00 | Male | 2008-11-01 00:00:00 | 2009-02-16 00:00:00 | BOT Review
SA | ZA | 1961-07-17 00:00:00 | Male | 2008-11-01 00:00:00 | 2008-11-03 00:00:00 | BOT Start
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 10c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, November 23 weekly snapshot, by product type and major currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 877133d1723808929-need-a-formula-to-get-count-rajsoft-second-test-365-aligw
Sheet: LOOKUP

Roles | Employees |  | Code details |  |  | Code Type
 |  |  | CC01 | Project
Functional | EMP 2 |  | CC02 | Project |  | Project
 | EMP 3 |  | [NAME] | Bench
 | EMP 4
 | EMP 5
 | EMP 6
 | EMP 7
Spreadsheet: 758591d1638963772-copy-data-when-criteria-match-book1-1-
Sheet: Raw

Model | TITLE2 | Code | TITLE4 | TITLE5 | TITLE6 | TITLE7 | TITLE8 | TITLE9 | TITLE10 | TITLE11 | TITLE12 | TITLE13 | TITLE14 | TITLE15
ABC |  | 123 |  |  | 2021-12-08 00:00:00 |  |  | BETTY |  |  |  | 2021-12-07 00:00:00
ABC |  | 456 |  |  | 2021-12-08 00:00:00 |  |  | [NAME]
ABC |  | 789 |  |  | 2021-12-07 00:00:00 |  |  | [NAME] |  |  |  | 2021-11-15 00:00:00
DEF |  | 3399 |  |  | 2021-12-01 00:00:00 |  |  | [NAME]
ABC |  | 1122 |  |  | 2021-12-01 00:00:00 |  |  | BETTY
 |  |  | MAIN SOURCE (IN A WORKBOOK)
Spreadsheet: 679910d1590681903-get-subtotal-from-pivot-with-sumifs-with-out-repeat-all-demo
Sheet: Sheet1

 | Sl No | Name | Spend |  |  |  |  | Sum of Spend
 | 1 | A | 100 |  |  |  |  | Name | Sl No | Total | As of now | Output requested (SUBTOAL OF COLUMN I)
 | 2 | B | 200 |  |  |  |  | A | 1 | 100 |  | 800
 | 3 | C | 300 |  |  |  |  |  | 7 | 700 |  | 800
 | 4 | D | 400 |  |  |  |  | B | 2 | 200 |  | 1000
 | 5 | E | 500 |  |  |  |  |  | 8 | 800 |  | 1000
 | 6 | F | 600 |  |  |  |  | C | 3 | 300 |  | 1200
 | 7 | A | 700 |  |  |  |  |  | 9 | 900 |  | 1200
 | 8 | B | 800 |  |  |  |  | D | 4 | 400 |  | 1400
 | 9 | C | 900 |  |  |  |  |  | 10 | 1000 |  | 1400
 | 10 | D | 1000 |  |  |  |  | E | 5 | 500 |  | 1600
 | 11 | E | 1100 |  |  |  |  |  | 11 | 1100 |  | 1600
 | 12 | F | 1200 |  |  |  |  | F | 6 | 600 |  | 1800
 |  |  |  |  |  |  |  |  | 12 | 1200 |  | 1800
 |  |  |  |  |  |  |  | Grand Total |  | 7800
Spreadsheet: 100842d1299075914-changing-labelling-on-y-axis-comparisons
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Whole class nominations | 3 | 3 | 4 | 1 | 3 | 3 | 3 | 3 | 3 | 1 | 3 | 3 | 5 | 3 | 3 | 5 | 3 | 5 | 5 | 4
Same gender nominations | 3 | 1 | 5 | 1 | 4 | 3 | 3 | 3 | 5 | 1 | 1 | 4 | 3 | 5 | 1 | 5 | 5 | 5 | 5 | 5
Spreadsheet: 831750d1685864975-create-a-descending-number-series-daf-reverse-sequence-aligw
Sheet: Sheet1

 |  | Amount | 1500
 |  | Rows | 23
 |  | Start | 110 |  | 110
 |  |  |  |  | 105.93 |  | 105.93
 |  |  |  |  | 101.86 |  | 101.86
 |  |  |  |  | 97.79000000000002 |  | 97.79000000000002
 |  |  |  |  | 93.72000000000003 |  | 93.72000000000003
 |  |  |  |  | 89.65000000000003 |  | 89.65000000000003
 |  |  |  |  | 85.58000000000004 |  | 85.58000000000004
 |  |  |  |  | 81.51000000000005 |  | 81.51000000000005
 |  |  |  |  | 77.44 |  | 77.44000000000005
 |  |  |  |  | 73.37 |  | 73.37000000000006
 |  |  |  |  | 69.3 |  | 69.30000000000007
 |  |  |  |  | 65.23 |  | 65.23000000000008
 |  |  |  |  | 61.16 |  | 61.16000000000007
 |  |  |  |  | 57.09 |  | 57.09000000000007
 |  |  |  |  | 53.02 |  | 53.02000000000007
 |  |  |  |  | 48.95 |  | 48.95000000000007
 |  |  |  |  | 44.88 |  | 44.88000000000007
 |  |  |  |  | 40.81 |  | 40.81000000000007
 |  |  |  |  | 36.74 |  | 36.74000000000007
 |  |  |  |  | 32.67 |  | 32.67000000000007
 |  |  |  |  | 28.6 |  | 28.60000000000007
 |  |  |  |  | 24.53 |  | 24.53000000000007
 |  |  |  |  | 20.46 |  | 20.46000000000007
 |  |  |  | Sum |  |  | 1500.290000000001
Spreadsheet: 356752d1415201850-countif-to-visible-cells-only-countif-test-ndm
Sheet: Sheet1

XXXX | XXXX | NSCC # | COMPANY NAME: | [NAME] | POLICY NO | ACCOUNT NO | COMM PCT | Countif
 |  | [NAME] | Star | xxxxx | 123456789 | 99999999 | 50
 |  | [NAME] | Star | xxxxx | 123456789 | 99999999 | 50
 |  | [NAME] | ABC | xxxxx | 2222222 | 99999999 | 20
 |  | [NAME] | ABC12 | xxxxx | 2222222 | 99999999 | 30
 |  | [NAME] | ABC12 | xxxxx | 2222222 | 99999999 | 50
 |  | [NAME] | Something | xxxxx | 333333333 | 99999999 | 10
 |  | [NAME] | Something | xxxxx | 333333333 | 99999999 | 20
 |  | [NAME] | Something | xxxxx | 333333333 | 99999999 | 20
 |  | [NAME] | Something4 | xxxxx | 333333333 | 99999999 | 20
 |  | [NAME] | Something5 | xxxxx | 333333333 | 99999999 | 10
 |  | [NAME] | Something6 | xxxxx | 333333333 | 99999999 | 20
 |  | [NAME] | xxxxx | xxxxx | 44444444 | 99999999 | 50
 |  | [NAME] | xxxxx1 | xxxxx | 44444444 | 99999999 | 50
 |  | [NAME] | Two for one | xxxxx | 55555555 | 99999999 | 50
 |  | [NAME] | Two for one | xxxxx | 55555555 | 99999999 | 50
 |  | [NAME] | Two for | xxxxx | 666666 | 99999999 | 50
 |  | [NAME] | Two for one | xxxxx | 666666 | 99999999 | 50
Spreadsheet: 63614f96-85f2-4161-8ec9-65e5740ac9cf
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 16. PERIOD AVERAGE EXCHANGE RATES, Units of Foreign Currency per Australian Dollar
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Euro ; |  |  | Original | A2716728L | 1978-07-01 00:00:00 | 2012-03-01 00:00:00 | 405 | $ | INDEX | Month | 1
[NAME] ; |  |  | Original | A2716729R | 1978-07-01 00:00:00 | 2012-03-01 00:00:00 | 405 | $ | INDEX | Month | 1
United States Dollar ; |  |  | Original | A2716726J | 1978-07-01 00:00:00 | 2012-03-01 00:00:00 | 405 | $ | INDEX | Month | 1
United Kingdom Pound ; |  |  | Original | A2716727K | 1978-07-01 00:00:00 | 2012-03-01 00:00:00 | 405 | $ | INDEX | Month | 1
Special Drawing Right ; |  |  | Original | A2716730X | 1978-07-01 00:00:00 | 2012-03-01 00:00:00 | 405 | $ | INDEX | Month | 1
Trade Weighted Index ; |  |  | Original | A2716731A | 1978-07-01 00:00:00 | 2012-03-01 00:00:00 | 405 | Index Numbers | INDEX | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 84273d1284320976-create-a-list-from-a-table-ryder-cup
Sheet: Look-Up

 |  | Year | 1979
 |  | Course | The [NAME], Old White Course
 |  | Location | White Sulphur Springs
 |  |  | West Virginia
 |  |  | United States
 |  |  |  | Points |  |  |  | Points
 |  | Winnjng Team | United States | 17 |  | Loosing Team | Europe | 11
 |  | Captain | [NAME] |  |  | Captain | [NAME]
 |  | Team |  |  |  | Team
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 778158d1650896530-get-number-of-seconds-between-two-dates-in-excel-excluding-part-of-weekend-and-holidays-time-between-hours-1-
Sheet: Full Day Holidays

Holidays | Weekday
 |  | The pupose of this list is strictly for whole-day Holidays, not for part days or days that are not from midnight to midnight.
 |  | Examples: Chrismas Day is all of the 25/12
 |  | It is not from 5am one day to 5am the next day
 |  | and it is not just from 8 am to 8 pm.
Spreadsheet: 867133d1714025394-need-help-with-iteration-or-recursion-example
Sheet: Sheet1

B | OV | RTP | K
B1 | OV1 | RTP1 | K1
B2 | OV2 | RTP2 | K2
O1 | O2 | O3
P1 | P2 | P3
0.1609 | 0.2594 | 0.5969
NO1 | NO2 | NO3
NP1 | NP2 | NP3
NNO1 | NNO2 | NNO3
NNP1 | NNP2 | NNP3
Spreadsheet: 132855d1323980878-would-like-to-automatically-fill-out-a-job-ticket-using-excel-data-paint-20example-1-
Sheet: PARTS LIST

PARTNO | COLOR | QTY | [NAME] | P.O #
EL01.210 | BEIGE | 40 | SENSOR/REFLECTOR BRACKET | 123456
EL01.268 | BEIGE | 1 | PHOTO SENSOR MOUNT, PC04 CONVEYOR | 123456
GD12.2002 | BEIGE | 4 | IC16 INFEED CROSSMEMBER, 4" x 37" | 123456
IC07.206 | BEIGE | 2 | DRIVE CROSSMEMBER | 123456
IC07.211 | BEIGE | 1 | TURNER BOX | 123456
EL01.247 | YELLOW | 20 | SPROCKET SENSOR MOUNT | 123456
EL01.256 | YELLOW | 20 | PHOTOELECTRIC SWITCH BRACKET, LC09 | 123456
EL01.257 | YELLOW | 20 | REFLECTOR MOUNT, 2" | 123456
LC02.207 | YELLOW | 10 | END STOP | 123456
PC21.2136P | CUSTOM | 15 | GUARD SUPPORT | 123456
PC21.2137P | CUSTOM | 7 | GUARD SUPPORT | 123456
PD10.2067P | CUSTOM | 5 | UPPER IGUS BRACKET | 123456
PD10.2137P | CUSTOM | 10 | REFLECTOR BRACKET | 123456
PD10.2155P | CUSTOM | 10 | SPLICE PLATE | 123456
RH15.2046P | CUSTOM | 1 | CHAIN GUARD BLOCK SPACER | 123456
Spreadsheet: 232138d1367340223-if-cell-contains-certain-text-add-value-from-another-cell-in-same-row-baseball-teams
Sheet: Sheet1

 | team | risk amount | winning amount |  |  |  | 2=win 1=loss | end result
 | Pittsburgh Pirates | 1 | 1.75 |  |  |  | 1
 | Kansas City Royals | 1.16 |  |  |  |  | 2
 | San Diego Padres | 1.03 |  |  |  |  | 2
 | Baltimore Orioles | 1 | 1.09 |  |  |  | 2
 | Atlanta Braves | 1 | 1.27 |  |  |  | 1
 | Toronto Blue Jays | 1 | 1.29 |  |  |  | 1
 | UNITS WON/LOST | WINS | LOSSES
New York Yankees
Philadelphia Phillies
Boston Red Sox |  |  |  | IF(ISNUMBER(SEARCH("tigers",B:B)),I:I,"")
Los Angeles Angels
Detroit Tigers
Texas Rangers
[NAME]
San Francisco Giants
[NAME]
Chicago White Sox
Los Angeles Dodgers
Minnesota Twins
New York Mets
[NAME]
Atlanta Braves
Cincinnati Reds
Seattle Mariners
Baltimore Orioles
Washington Nationals
Cleveland Indians
Colorado Rockies
Toronto Blue Jays
[NAME]
Tampa Bay Rays
Pittsburgh Pirates
Kansas City Royals
Houston Astros
Oakland Athletics
San Diego Padres
Spreadsheet: 127743d1320518288-vlookup-query-vlookup-answer
Sheet: Results

GROUP | POS | SCORE
C | 1 |  | <<[NAME] |  |  | <<Index [NAME]
C | 2
C | 3
1 | 1
1 | 2
1 | 3
2 | 1
2 | 2
2 | 3
3 | 1
3 | 2
3 | 3
Spreadsheet: 90767d1290519395-sorting-dates-that-are-referenced-from-other-sheets-forum-reference-example
Sheet: Wickes

Customer | WICKES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Count YTD
Bid Number | 2704G511
Version | 15
Status | EMEA approved
Validation date | 08/10/2010
Start date | 28/09/2010
End date | 31/03/2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage Increase: | 0
[NAME]
Description | Quantity | Bid price | Part number | 2009 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Total Units | Total Revenue | Bid £ | BDP | % Discount | New Price? | New Discount? | New Price £ Estimate | Current £ Year Estimate
Spreadsheet: 0a3f4c63-b1db-42f3-8585-695e1868f4bb
Sheet: Notes

Expenditure per Equivalent Pupil trend is based on FY2010 Fiscal Benchmark Report calculations applied backwards to previous fiscal years. This allows for comparison across years but does not reflect the historical changes in the ADM weights or funding formula as they occurred during this time period. Care should be taken to distinguish between the results of this calculation and the actual funding formulas used during each fiscal year.
Methodology
Economically Disadvantaged Weight |  |  |  |  |  |  |  | LEP Weight
1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 8 | 9 | 10
Number EFM ADM reported as eligible for free or reduced price lunch | Total ADM | Percent Economically Disadvantaged in the District | Divide by state average (varies by year) | Weighting value (Column 4 *0.1) | ADM of Economically Disadvantaged students who are not also in Disability categories 3-6 | Additional weight added to ADM (weighted value* Column 6) |  | Students identified as English language learners | Category 1 weight | Additional weight added to ADM for LEP students (Column 8*Column 9)
Disability Category Weights
11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
Disability Category 1 ADM | Additional weight added to ADM using category 1 weight (0.2906) | Disability Category 2 | Additional weight added to ADM using category 2 weight (0.7374) | Disability Category 3 | Additional weight added to ADM using category 3 weight (1.7716) | Disability Category 4 | Additional weight added to ADM using category 4 weight (2.3646) | Disability Category 5 | Additional weight added to ADM using category 5 weight (3.2022) | Disability Category 6 | Additional weight added to ADM using category 6 weight (4.7205)
Spreadsheet: 728056d1618281754-index-match-formula-for-current-liabilities-and-current-assets-current-liabilities-and-current-assets2-1-
Sheet: Trial Balance

Category | Debit
Propert. Plant and Equipment | 476104.88
Intangible Assets | 0
Current Assets
Inventory | 347
Trade and Other Receivables | 3230
Cash & Cash Equivalent | -165135.46
Total
Category | Credit
Share Capital | 300916.42
[NAME] | 18930
Revaluation Reserve | 0
Long Term Loan | 0
Current Liabities
Trade and Other Payables | -5300
Taxation | 0
short term loan | 0
Spreadsheet: 718622d1613239388-formula-for-automatic-breakdown-sample-data
Sheet: Sheet3

 |  |  |  |  | what formula for this breakdown
 |  | code | qty
 |  | ABC45 | 10 |  | ABC45 |  | <=== sample ABC45 will be breakdown like this. Must be the same xx2001 & yy3001
 |  | xx2001 | 5 |  | ABC45
 |  | yy3001 | 20 |  | ABC45
 |  |  |  |  | ABC45
 |  |  |  |  | ABC45
 |  |  |  |  | ABC45
 |  |  |  |  | ABC45
 |  |  |  |  | ABC45
 |  |  |  |  | ABC45
 |  |  |  |  | ABC45
Spreadsheet: 814532d1674473152-copy-project-data-to-respective-tabs-ef1601_extract_to_sheets
Sheet: B

Project | Data field 1 | Data field 2 | Data field 3 | Data field 4 | Data field 5 |  | B
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12353 | 11113 | -1
2 | 12672 | 11039
3 | 12650 | 11039 | -1
4 | 12883 | 11039 | -2
5 | 13361 | 11039 | -455
6 | 13826 | 11039 | -611
7 | 13833 | 11039 | -497
8 | 13757 | 11039 | -514
9 | 13435 | 10537 | -601
10 | 13437 | 10537 | -639
11 | 13194 | 11039 | -566
12 | 13363 | 11039 | -513
13 | 13204 | 11039 | -595
14 | 13011 | 11039 | -551
15 | 13252 | 10949 | -594
16 | 13058 | 10058 | -614
17 | 13144 | 10235 | -600
18 | 13162 | 10852 | -623
19 | 11453 | 11113 | -651
20 | 11609 | 11113 | -690
21 | 11620 | 11037 | -707
22 | 12640 | 11113 | -225
23 | 12718 | 10700 | -202
24 | 12618 | 10592 | -143
25 | 12317 | 11113 | -669
26 | 12004 | 11113 | -6
27 | 12135 | 10945
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  | 691849.47
2001-06-27 00:00:00
Spreadsheet: 841763d1693927546-help-with-formula-weight-gain-or-loss
Sheet: Weight gain or loss

Name | Room No. | Starting Body Weight  in   [NAME] | July Weight | [NAME]LOST OR GAINED | AUG Weight | [NAME]LOST OR GAINED | SEP Weight | [NAME]LOST OR GAINED | OCT Weight | [NAME]LOST OR GAINED | NOV Weight | [NAME]LOST OR GAINED | DEC Weight | [NAME]LOST OR GAINED
 |  | 120 | 115 |  | 126
 |  | 110
 |  | 115
 |  | 125
Spreadsheet: 124610d1318508959-if-statement-with-absolutes-manipulationa
Sheet: Sheet1

 | Time as dec | Time Rounded | Dist | Count time | Count as dec | If dec are = disp | IF E>0 | If are = only disp one | Subtraction of sec. | [NAME] | AVG Dist/Sec | Dist/Sec
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 198.5 | 1900-01-01 00:00:00 | 0 | 198.5 | 198.5 | 0 | 4 | 10.90000000000001 | 2.725000000000001 | 198.5
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 | 00:00:01 | 1 |  |  |  |  |  |  | 195.775
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 | 00:00:02 | 2 |  |  |  |  |  |  | 193.05
00:00:03.5 | 4 | 00:00:04 | 187.6 | 00:00:03 | 3 |  | 187.6 | 4 | 1 | 2.300000000000011 | 2.300000000000011 | 190.325
00:00:03.585 | 4 | 00:00:04 | 0 | 00:00:04 | 4 | 0 |  |  |  |  |  | 187.6
00:00:03.5 | 4 | 00:00:04 | 0 | 00:00:05 | 5
00:00:04.587 | 5 | 00:00:05 | 189.9 | 00:00:06 | 6 |  | 189.9 | 5 | 1
00:00:04.5 | 5 | 00:00:05 | 0 | 00:00:07 | 7
00:00:04.5 | 5 | 00:00:05 |  | 00:00:08 | 8
00:00:06 | 6 | 00:00:06 |  | 00:00:09 | 9 |  |  | 6 | -6
00:00:06 | 6 | 00:00:06 |  | 00:00:10 | 10
00:00:06 | 6 | 00:00:06 |  | 00:00:11 | 11
 |  |  |  | 00:00:12 |  |  |  | 0
 |  |  |  | 00:00:13
 |  |  |  | 00:00:14
 |  |  |  | 00:00:15
 |  |  |  | 00:00:16
 |  |  |  | 00:00:17
 |  |  |  | 00:00:18
 |  |  |  | 00:00:19
Spreadsheet: 03928b0c-5c77-41f1-a4ed-22bbc69a8f70
Sheet: Agri

Agriculture - Lesson Planning
 | Fall 2011 | Sp 2012 | Fall 2012 | Sp 2013 | Fall 2013 | Sp 2014
Curriculum and Standards | 5 | N/A | 4.5 | N/A | 4.7
Objectives should define what students will know and be able to do.) | 5 | N/A | 4.5 | N/A | 4.8
Introductory activities set the stage for learning by providing background information about the topic to help orient investigations | 5 | N/A | 4.7 | N/A | 4.7
All activities are aligned with the objective(s), build upon each other, are appropriately paced, and developmentally appropriate. | 5 | N/A | 4.8 | N/A | 4.8
The course of instruction responds to student needs and interests, and students can make key decisions regarding their learning | 5 | N/A | 4.7 | N/A | 4.7
Collaborative learning allows all students opportunities to develop teamwork, communication, problem-solving skills, and reflection | 5 | N/A | 4.6 | N/A | 4.6
Concluding activities re-examine the important points of the lesson | 5 | N/A | 4.6 | N/A | 4.7
A variety of technology is integrated appropriately throughout the lesson in a manner that enhances the effectiveness of the lesson and the learning of the student. | 5 | N/A | 4.6 | N/A | 4.8
Emphasis on the technology standards and performance indicators are clearly seen through the major components of the lesson plan | 5 | N/A | 4.7 | N/A | 4.7
Assessment opportunities are ongoing and inform students | 5 | N/A | 4.8 | N/A | 4.8
Methods should include both formal and informal tools | 5 | N/A | 4.5 | N/A | 4.7
Materials and resources—exclusive of technology tool—that are needed by the student or the teacher to execute the lesson.) | 5 | N/A | 4.4 | N/A | 4.8
Accommodations do not change lesson or criteria. | 5 | N/A | 4.6 | N/A | 4.7
Modifications change lesson and criteria | 5 | N/A | 4.7 | N/A | 4.6
Explorations identify further study activities; extensions identify bridge activities | 5 | N/A | 4.8 | N/A | 4.7
Resources used by the teacher to create this lesson, i.e. books, journals, magazines, web sites, school/public library resources, outside experts, etc.) | 5 | N/A | 4.5 | N/A | 4.8
 |  |  |  |  |  | Sp 2014
Professional Writing |  |  |  |  |  | 3.8
Essential Question |  |  |  |  |  | 3.5
Standards and Benchmarks |  |  |  |  |  | 3.7
Student Outcomes |  |  |  |  |  | 3.8
Materials/Technology |  |  |  |  |  | 3.9
Procedures |  |  |  |  |  | 3.5
[NAME] “Hook” |  |  |  |  |  | 3.6
Pre-planned (seed) Questions |  |  |  |  |  | 3.8
Modeling, guided, collaborative and independent practice |  |  |  |  |  | 3.7
Formative/Summative |  |  |  |  |  | 3.8
Assessment |  |  |  |  |  | 3.9
Closure |  |  |  |  |  | 3.8
Differentiation |  |  |  |  |  | 3.7
Post-Lesson Reflection/Analysis |  |  |  |  |  | 3.6