tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841519d1693699718-using-dynamic-filter-for-top-x-values-and-sort-by-month-dynamic-array
Sheet: Sheet1

Raw Data:
Expense Category | January | February | March | April | May | June | July | August | September | October | November | December | Total
Academic | 0 | 71.93 | 52.3 | 28.21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 152.44
Automobile | 0 | 0 | 36.51 | 69.15 | 132.02 | 0 | 178.14 | 86.75 | 0 | 0 | 0 | 0 | 502.57
Cellphone | 0 | 0 | 0 | 0 | 79.55 | 0 | 0 | 40.87 | 0 | 0 | 0 | 0 | 120.42
Clothing | 0 | 0 | 0 | 86.89000000000001 | 70.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 157.04
Fitness | 32.77 | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 | 32.77 | 11.3 | 0 | 0 | 0 | 0 | 133.34
Groceries | 135.01 | 31.56 | 28.22 | 51.48 | 32.36 | 0 | 0 | 8.48 | 0 | 0 | 0 | 0 | 287.11
Health and dental | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28
Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Miscellaneous | 0 | 5.64 | 37.83 | 33.75 | 67.72 | 18.48 | 83.5 | 210.12 | 0 | 0 | 0 | 0 | 457.04
Personal care | 47.23 | 30 | 30 | 33.9 | 0 | 62 | 0 | 65 | 0 | 0 | 0 | 0 | 268.13
Public transit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Restaurant | 102.35 | 100.98 | 109.13 | 261.93 | 248.36 | 165.41 | 529.28 | 289.92 | 0 | 0 | 0 | 0 | 1807.36
Technology | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travel | 466.2799999999999 | 60 | 44.98 | 0 | 0 | 2993.090000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 3564.35
Total | 783.6399999999999 | 339.41 | 350.27 | 576.61 | 641.46 | 3250.280000000001 | 823.6899999999999 | 712.4399999999999 | 0 | 0 | 0 | 0 | 7477.800000000001
Month
August
Desired Result:
Expense Category |  |  | Expense Category
 |  |  | Restaurant | 289.92
 |  |  | Miscellaneous | 210.12
 |  |  | Automobile | 86.75
Spreadsheet: 844678d1696411790-how-to-fetch-data-from-other-sheets-in-one-sheet-based-on-quarters-attendance
Sheet: Dashboard

[NAME]
Quarter | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q4
Associate Name | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance%
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
Spreadsheet: 0b0d7d38-36d0-462c-a611-af2d95ec2710
Sheet: Removed 11-12

Details on differences between July 2011 and July 2012
Listings that were active in 2011 but are not included in 2012 data (i.e, CLOSED or non-respondents):
MemberID | dbo_REIT_Members_Name | City
1083 | 212 Motel | Olivia
4760 | Beyer [NAME] and Breakfast | New Ulm
599 | Blue Moon Resort & Motel | Hill City
7441 | Border Lakes Outfitting | [NAME]
1165 | Bradmor Motel | [NAME]
930 | [NAME] | Worthington
1499 | Clear Vue Resort | Bemidji
1476 | [NAME] | Montgomery
376 | [NAME] | Harmony
4261 | Crystal Dreams B & B at the Wynne Inne | [NAME]
445 | Eagle Lake Resort | Frazee
277 | Eagles on the River B & B | Wabasha
608 | Edelbrock House B&B | [NAME]
1589 | Elk Motel & Suites | Elk River
93 | [NAME] on Lake Vermilion | Tower
3387 | Gateway Lodge & Suites | Orr
793 | Golden Gate Motel | Cloquet
4430 | Grand Cottages | New London
187 | Green Valley Resort | Glenwood
1358 | Harbor Inn Motel & Restaurant | [NAME]
1004 | Hwy 12 Motel | [NAME]
3650 | LakesideRetreat.biz | Merrifield
495 | [NAME]'s Resort | Longville
754 | Loghouse & Homestead On Spirit Lake | Vergas
87 | Lyndale Motel | Faribault
1559 | [NAME] | Park Rapids
7577 | Northwoods Getaway | [NAME]
1411 | [NAME]'s Big Pine Get-A-Way | New York Mills
779 | Pines Motel | Taylors Falls
1054 | Rambler Motel | [NAME]
1674 | [NAME] | [NAME]
5045 | South Fork Bed and Golf | [NAME]
170 | Sunset View Cabins | [NAME]
5744 | Sunset View Inn | Mound
3662 | Super 8 Motel - Melrose | Melrose
37 | Superior Overlook B & B | [NAME]
4209 | The Victorian House of Lanesboro | Lanesboro
593 | Tower Motel | Canby
646 | [NAME] with Tearoom | [NAME]
581 | Wigwam Motel | Emily
Spreadsheet: darrell_schoolcraft__7619__SUNFLOWER - NNG - HOURLY - 20021
Sheet: 9

Jan 2002 HOURLY ESTIMATES - NNG - SUNFLOWER S4 & S5
WEEKENDS & AFTER 17:00 -
EMERGENCY CONTACTS: |  | [NAME] (PAGER) |  |  |  | Wednesday, 01/09/02
 | [NAME] | S5 | HOLCOLM | [NAME] | S5 | S4 & S5 | TOTAL
HOUR | MWH | MWH | MMBTU | MMBTU | MMBTU | MMBTU SUBTOTAL | MMBTU
09:00:00 | 0 | 0 | 6.75
10:00:00 | 0 | 0 | 6.75 | 750
11:00:00 | 0 | 0 | 6.75 | 750
12:00:00 | 0 | 0 | 6.75
13:00:00 | 0 | 0 | 6.75
14:00:00 | 0 | 0 | 6.75
15:00:00 | 0 | 0 | 6.75
16:00:00 | 0 | 0 | 6.75
17:00:00 | 0 | 0 | 6.75
18:00:00 | 0 | 0 | 6.75
19:00:00 | 0 | 0 | 6.75
20:00:00 | 0 | 0 | 6.75
21:00:00 | 0 | 0 | 6.75
22:00:00 | 0 | 0 | 6.75
23:00:00 | 0 | 0 | 6.75
1900-01-01 00:00:00 | 0 | 0 | 6.75
1900-01-01 01:00:00 | 0 | 0 | 6.75
1900-01-01 02:00:00 | 0 | 0 | 6.75
1900-01-01 03:00:00 | 0 | 0 | 6.75
1900-01-01 04:00:00 | 0 | 0 | 6.75
1900-01-01 05:00:00 | 0 | 0 | 6.75
1900-01-01 06:00:00 | 0 | 0 | 6.75
1900-01-01 07:00:00 | 0 | 0 | 6.75
1900-01-01 08:00:00 | 0 | 0 | 6.75
DAILY
TOTAL
Spreadsheet: kate_symes__18651__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-26 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-25 00:00:00 |  | 264 | 18800 | 197.99 | 8440
 | 2001-01-24 00:00:00 |  | 272.42 | 7920 | 181.28 | 4440
 | 2001-01-23 00:00:00 |  | 281.71 | 13600 | 186.9 | 3680
 | 2001-01-22 00:00:00 |  | 320.08 | 14960 | 201.71 | 5240
 | 2001-01-21 00:00:00 |  |  |  |  |  | 235 | 29400
 | 2001-01-20 00:00:00 |  | 506.48 | 4320 | 236.31 | 8400
 | 2001-01-19 00:00:00 |  | 505.66 | 4384 | 247.42 | 5032
 | 2001-01-18 00:00:00 |  | 429.29 | 7920 | 278.82 | 6440
 | 2001-01-17 00:00:00 |  | 252.4 | 8000 | 204.13 | 4600
 | 2001-01-16 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
Spreadsheet: 888092d1738476419-filter-data-based-on-criteria-filtered-data-rajeshn_in-
Sheet: Sheet1

Company Name | Bank Name |  |  |  |  | Company Name | Bank Name
MKL | AXIS
MKHL | HDFC
MKL | HDFC
MKHL | HDFC
MAPL | SBI
MKL | SBI
MAPL | HDFC
MKHL | SBI
MKL | HDFC
MKHL | SBI
MKL | AXIS
Spreadsheet: 880375d1728043140-counta-to-exclude-blank-cells-upload
Sheet: Guidelines

SNO | AHT Data
1 | We need separate sheet for each contract, BU, Division.
 | AFBP will fill separately for each contract
 | RTR will fill separately for each contract
 | BU lead to finalize and sign off the complete template
 | Recs - AFBP to include time of review and approvals
 | Recs - RTR to include time of preparation of template, back-up workings and upload  - Please select correct process category
 | Journals - AFBP to include time of back-up workings (if they do), review and approvals - Please select correct process category
 | Journals - RTR to include time of back-up workings (if they do), preparation of JE template and Upload - Please select correct process catageory
 | [NAME] to be included for no. of recs done for each category
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Stratland

 | Stratland Exploration
 | POI 60211 - Jones Trust
Day | Measured | Scheduled
1 | 3030 | 2752
2 | 2679 | 2752
3 | 3983 | 2752
4 | 2882 | 2752
5 | 2914 | 2752
6 | 2992 | 2752
7 | 2937 | 2752
8 | 2963 | 2752
9 | 3271 | 2752
10 | 3165 | 2752
11 | 3089 | 2752
12 | 3168 | 2752
13 | 2550 | 2752
14 | 3143 | 2752
15 | 2911 | 2752
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 43180.07
2002-01-15 00:00:00
CBS Volume
 |  |  | 14850
Spreadsheet: louise_kitchen__24171__EnronOnlineToNetco
Sheet: Sheet1

EnronOnline
ALTHAUS, [NAME] R | MANAGER IT
AMAN, AMANULLAH | CONSULTANT TECH
BAEHR, KEVIN P | STAFF IT
BATRAK, HENNADIY | SPECIALIST SR. IT
BELMONT, [NAME] | MANAGER IT
BOWLING, WILLIAM C | DIRECTOR IT
BURRA, RAGHU R | SPECIALIST IT
CHILLAKURU, SIREESHA | SPECIALIST SR. IT
CUMMINS, DOUGLAS | DIRECTOR IT
DHANSINGHANI, AJIT G | SPECIALIST IT
DINH, THUY-TIEN T | MANAGER IT
DUA, JATINDER | SPECIALIST IT
[NAME], LISA | SPECIALIST IT
FISHER, [NAME] | MANAGER IT
GADHAVI, VIJAYANAND | SPECIALIST IT
GONZALES, FRANCIS M | MANAGER IT
GUADARRAMA, [NAME] | DIRECTOR SR IT
HARRELL, DAN E | SPECIALIST SR. IT
HAWTHORN, ANDREW B | SPECIALIST SR. IT
HILLIER, BOB B | DIRECTOR SR IT
JENSON, JAROD M | DIRECTOR IT
KANDAVELU, SHIVSHANKAR | SPECIALIST SR. IT
KINKEAD, MARK O | SPECIALIST SR. IT
LIM, [NAME] | SPECIALIST IT
MONTAGNE, KEVIN A | DIRECTOR SR IT
MOTUZKO, PYLYP G | [NAME] IT
NEWKIRK, SCOTT T | SPECIALIST IT
NGUYEN, TUYET-MAI | MANAGER IT
PADAVALA, [NAME] | SPECIALIST IT
PETERSON, DWAYNE | SPECIALIST SR. IT
RAMSAY, STACEY C | DIRECTOR IT
SEK, JULIE | STAFF IT
SHAW, EDDIE L | SPECIALIST IT
SINDWANI, AJAY | SPECIALIST IT
SINHA, SUVINAY K | SPECIALIST IT
SMITH, TERESA J | DIRECTOR IT
SORKINA, VICTORIA | SPECIALIST IT
STEPHENS, [NAME] | SPECIALIST IT
THOMAS, TONY C | DIR TECHNICAL IT
VARGHESE, RENNU G | SPECIALIST SR. IT
WEATHERSTONE, [NAME] | COORD ADMIN
WEBB, [NAME] | VICE PRESIDENT
WU, BARBARA | ADMINISTRATIVE ASST I
ZHANG, WENXIA | SPECIALIST SR. IT
Spreadsheet: 836523d1689444175-merging-formulas-that-reference-sheets-indirect-formulas-test-file-3-
Sheet: Sheet2

 |  | Cells | Cells | Cells | Cells
 | Solution: | H222 | I222 | M222 | Q222 |  | what part of the formula do I manipulate so that I can build upon it to get other totals (total 2-4) | I am trying to figure out a way to combine both formulas (column B and C) so that I can avoid dragging the formula in column C down and having a bunch of references
 | ZONE | TOTAL1 | TOTAL2 | [NAME] | TOTAL4 |  |  | my first attempt at this was with the formula in column E (I replaced B5 with the formula in column B) but I am having no luck.
 |  |  |  |  |  |  |  |  | INDIRECT("'"&B5&"'!"&TEXT(SUBSTITUTE(ADDRESS(1,COLUMN('ALPHA-01'!$H$222),4),"1","")&ROW('ALPHA-01'!$H$222),0))
 |  |  |  |  |  |  |  |  |  | ^
 |  |  |  |  |  |  |  |  |  | IF(SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found")))="","",SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found"))))
 |  |  |  |  |  |  |  |  |  | some test formulas below
 |  |  |  |  |  |  |  |  | Formula 1
 |  |  |  |  |  |  |  |  |  | 'alpha-02'!
 |  |  |  |  |  |  |  |  |  | 'alpha-03'!
Total overall |  |  |  |  |  |  |  |  |  | 'alpha-04'!
 |  |  |  |  |  |  |  |  |  | 'alpha-05'!
 |  |  |  |  |  |  |  |  |  | 'alpha-06'!
 |  |  |  |  |  |  |  |  |  | 'alpha-07'!
 |  |  |  |  |  |  |  |  |  | 'alpha-08'!
 |  | Cells | Cells | Cells | Cells |  | and also, is there a way to sum at the end of the spill? This way if my data had 100+ alpha's, the sum function would adjust to the end, avoiding the #spill error? |  |  | 'alpha-09'!
 | Solution: | H222 | I222 | M222 | Q222
 | ZONE | TOTAL1 | TOTAL2 | [NAME] | TOTAL4
 |  |  |  |  |  |  |  |  | Formula 2
 |  |  |  |  |  |  |  |  | Formula 1+2
 |  |  |  |  |  |  |  |  |  | 'alpha-02'!H222
Total overall |  |  |  |  |  |  |  |  |  | 'alpha-03'!H222
 |  |  |  |  |  |  |  |  |  | 'alpha-04'!H222
 |  |  |  |  |  |  |  |  |  | 'alpha-05'!H222
 |  |  |  |  |  |  |  |  |  | 'alpha-06'!H222
 |  |  |  |  |  |  |  |  |  | 'alpha-07'!H222
 |  |  |  |  |  |  |  |  |  | 'alpha-08'!H222
 |  |  |  |  |  |  |  |  |  | 'alpha-09'!H222
Spreadsheet: 48055d1247235596-worksheet-referencing-and-position-recognition-mockup_book-1-2-
Sheet: Foreign Only

Security | Holding | Foreign Currency | Total Value in Foreign Currency | Exchange Rate | Price Per Share in Pence
UNILEVER PLC ORD GBP0.031111 (3) | 1500 | CAD | 1313.5*exchange rate*holding | 1.9645 | 1313.5
F&C FUND MANAGEMENT LTD GLOBAL GROWTH SC 1 ACC  (1) | 4500 | EUR€ | 84.79*exchange rate*holding | 1.41575 | 84.79
JUPITER UNIT TRUST MANAGERS INCOME TRUST(2) | 14000 | US$ | 349.64*exchange rate*holding | 1.61575 | 349.64
DR PEPPER SNAPPLE GROUP INC COM STK USD0.01  (2) | 2000 | US$ | 1368.952685*exchange rate*holding | 1.61575 | 1368.95268474216
SCHRODERS VTG SHS GBP1 (4) | 2200 | #N/A | 851.25*exchange rate*holding | 1.1314 | 851.25
PRUDENTIAL ORD GBP0.05 (5) | 6233 | #N/A | 425.875*exchange rate*holding | 1.5048 | 425.875
Spreadsheet: 79779d1279991046-if-or-cells-contain-specific-text-display-results-in-multiple-areas-testsheet1
Sheet: Sheet1

 | Raw Data |  |  | Input Field |  |  | Output
 | Code | Name |  | 1st Job Code |  |  | Name | Current Jobs | First Job | Second Job | Third Job
 | B14 | [NAME] |  | 2nd Job Code |  |  | [NAME]
 | B15 | [NAME] |  | 3rd Job Code |  |  | [NAME]
 | B16 | [NAME] |  |  |  |  | [NAME]
 | B14 | [NAME]
 | B17 | [NAME]
 | B18 | [NAME]
 | B14 | [NAME]
 | B16 | [NAME]
 | [NAME] | [NAME]
Spreadsheet: 725092d1616524596-index-if-match-in-any-of-these-columns-freds-windows
Sheet: Sheet1

Acc Ref | Short Name | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 |  | Lookup Value | Acc Ref
1 | FREDWI | [NAME] | [NAME] | [NAME] | [NAME] | F Windows |  | asd
2
3
NT7686 | asd | asded | ert | asd | asd | rfg
4
Spreadsheet: 286611d1388402484-how-can-i-get-column-a-to-identify-the-item-number-by-the-first-6-characters-vlookup-master-data
Sheet: Sheet1

Fruit | Item Number
 | GW30BF0000001
 | GW37VS0000002
 | GW14SO0000003
 | GW20SM0000004
 | GW30AA0000005
 | GW65XM0000006
 | GW30BF0000007
 | GW37VS0000008
 | GW14SO0000009
 | GW20SM0000010
 | GW30AA0000011
 | GW65XM0000012
Spreadsheet: 493788d1481886230-counting-of-dates-test-01-
Sheet: Sheet1

Region | Market | Approved | SR_T60_PCAND_APPV_AC | RFDS | TASK_325_PERMITS_APPROVED_AC | TASK_327_CLLI_SUBMIT_DATE_AC | TASK_329_CLLI_COMPLETE_DATE_AC | CIQ | TASK_398_AZP_COMPLETE_AC | [NAME] | TASK_500_3G_CNSTRCTN_CMPLT_AC | TASK_619_2500MHZ_OA_COM_SVC_AC | TASK_627_4G_800_ON_AIR_AC
Central | Central Illinois
Central | Central Iowa
Central | Chicago
Central | Cincinnati
Central | Cleveland
Central | Columbus
Central | Dakotas
Central | East Iowa
Central | East Kentucky
Central | East Michigan
Central | Ft. Wayne / South Bend
Central | Indianapolis
Central | Kansas
Central | Milwaukee
Central | Minnesota
Central | Missouri
Central | North Wisconsin
Central | Pittsburgh
Central | Toledo
Central | West Iowa / Nebraska
Central | West Kentucky
Central | West Michigan
Central | Western Pennsylvania
Central | West Virginia
Spreadsheet: 287145d1388668721-dail-and-weekly-multi-shifts-sales-tab-book1
Sheet: Sheet1

 | DISHES | UNIT FOOD COSTS | UNIT SELLING PRICE | UNIT GROSS MARGIN | % GROSS MARGIN | UNITS SOLD | % UNITS / TOTAL BILLS | UNITS SALES REVENUE / 100 BILLS | UNIT GROSS MARGIN / 100 BILLS | % TOTAL SALES | % TOTAL GROSS MARGIN | TOTAL SALES | TOTAL GROSS MARGIN $
 | 1 | 14 | 70 | 56 | 0.8 |  | 6.912442396313365 | 483.8709677419355 | 387.0967741935484 | 0.06399317406143347 | 0.06399317406143346 | 1050 | 840
 | 2 | 14 | 70 | 56 | 0.8 |  | 6.451612903225806 | 451.6129032258064 | 361.2903225806451 | 0.05972696245733788 | 0.05972696245733788 | 980 | 784
 | 3 | 14 | 70 | 56 | 0.8 |  | 6.451612903225806 | 451.6129032258064 | 361.2903225806451 | 0.05972696245733788 | 0.05972696245733788 | 980 | 784
 | 4 | 14 | 70 | 56 | 0.8 |  | 6.451612903225806 | 451.6129032258064 | 361.2903225806451 | 0.05972696245733788 | 0.05972696245733788 | 980 | 784
 | 5 | 14 | 70 | 56 | 0.8 |  | 6.451612903225806 | 451.6129032258064 | 361.2903225806451 | 0.05972696245733788 | 0.05972696245733788 | 980 | 784
 | 6 | 14 | 70 | 56 | 0.8 |  | 6.451612903225806 | 451.6129032258064 | 361.2903225806451 | 0.05972696245733788 | 0.05972696245733788 | 980 | 784
 | TOTAL (AVERAGE) | 14 | 70 | 55.99999999999999 | 0.7999999999999998 | 85 | 39.1705069124424 | 2741.935483870967 | 2193.548387096774 | 0.3626279863481229 | 0.3626279863481228 | 5950 | 4760
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5200

5200 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
 | Cost | Service Life | HMR at Change
Lube | 5000 | 1000 | 2000
Tire
Engine | 50000 | 1000 | 8000
Spreadsheet: 821652d1678826638-automate-timing-assumptions-automate-custom-timing
Sheet: Custom_Timing_Assumptions

 |  |  |  | Timing Assumptions      (DO NOT USE DECIMALS WITH %!!!)
Row | Combine | Category | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | Sum | Finance Notes | BP | Adjusted to | [NAME]
 |  | Shell | Generic |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.18 | 0.2 | 0.25 | 0.12 | 0.08 | 0.07
 |  | Equipment | Generic |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.4 | 0.35 | 0.05 | 0.03 | 0.02 | 0
1 |  | Shell | A |  |  |  |  |  | 0.1 | 0.18 | 0.2 | 0.25 | 0.12 | 0.08 | 0.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-01 00:00:00 | 2025-05-01 00:00:00
 |  | Equipment | A |  |  |  |  |  | 0.15 | 0.4 | 0.35 | 0.05 | 0.03 | 0.02 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-01 00:00:00 | 2025-05-01 00:00:00
 |  | Shell | B |  |  |  |  |  |  |  | 0.1 | 0.18 | 0.2 | 0.25 | 0.12 | 0.08 | 0.07 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-10-01 00:00:00 | 2025-05-01 00:00:00
 |  | Equipment | B |  |  |  |  |  |  |  | 0.15 | 0.4 | 0.35 | 0.05 | 0.03 | 0.02 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-10-01 00:00:00 | 2025-05-01 00:00:00
 |  | Shell | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.18 | 0.2 | 0.25 | 0.12 | 0.08 | 0.07 |  |  |  |  |  |  | 2025-10-01 00:00:00 | 2025-12-01 00:00:00
 |  | Equipment | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.4 | 0.35 | 0.05 | 0.03 | 0.02 | 0 |  |  |  |  |  |  | 2025-10-01 00:00:00 | 2025-12-01 00:00:00
Spreadsheet: 60891d1261476361-calculator-needed-711508-calculator-needed
Sheet: Sheet1

Component1 | Cost | Qty Req'd | Block Price | Component2 | £ per 1000mm | Qty Req'd | Shaft price | Total
BLOCK A | 10 | 1 | 10 | SHAFT A | 100 | 600 | 60 | 610
BLOCK B | 20 | 2 | 40 | SHAFT B | 200 | 1100 | 220 | 1120
BLOCK C | 30 | 1 | 30 | SHAFT C | 300 | 1000 | 300 | 1030
BLOCK D | 40 | 4 | 160 | SHAFT D | 400 | 1050 | 420 | 1090
BLOCK E | 50 | 3 | 150 | SHAFT E | 500 | 2000 | 1000 | 2050
 | What I would want is to to enter a component1 part# in a cell along with a qty then component2 part# in another cell along with a quantity and the total be shown at the end. As you can see the value of component2 is variable as is component1. This is just a small sample of the components, there are over 50 of each.
Block # | Qty | Shaft # | Qty | Total
BLOCK A | 1 | SHAFT C | 1400 | 430
BLOCK B | 1 | SHAFT C | 1200 | 380
Spreadsheet: 107027d1304180046-im-trying-to-build-a-hand-to-mouth-type-of-budget-feel-like-offering-some-advice-handtomouthbudget
Sheet: Template

 | 2011 | May
 |  |  | 1st Pay Date | 2nd Pay Date
 |  | Income
 |  | One Time Income
 |  | Unallocated
 |  | Expenses |  |  |  |  |  |  |  |  | First Due Date | Second Due Date | Third Due Date
 | One Time Expenses
 |  | Total Expenses
Spreadsheet: 125368d1318992314-reverse-data-in-cell-name_rearrange
Sheet: West

West   Period Name : 'SEP-12' , Period Year : '2012'    18-OCT-11   05.04.30 PM
Cost Centre Code | Cost Centre Name | Annual Budget | Current Month Budget | Current Month Actual | Current Month Variance | YTD Budget | YTD Actual | YTD Variance
874400 |  | 314649 | 26074 | 25540.04 | -533.96 | 154714 | 148041.18 | -6672.82
874401 |  | 130228 | 10733 | 11273.48 | 540.48 | 64404 | 68393.72 | 3989.72
874402 |  | 886206 | 78531 | 54723.07 | -23807.93 | 471694 | 344891.93 | -126802.07
874408 |  | 0 | 0 | 0 | 0 | -1 | 0 | 1
874409 |  | 0 | 0 | 24456.06 | 24456.06 | 0 | 28168.19 | 28168.19
GRAND TOTAL |  | 1331083 | 115338 | 115992.65 | 654.65 | 690811 | 589495.02 | -101315.98
Spreadsheet: 730062d1619530737-function-to-coverts-all-specific-numbers-in-a-cell-to-1-and-2-numeric-values-test
Sheet: Sheet1

 | Raw Data | Result |  | Function to convert column B data to results in column C
 | 1241335 | 1221111
 | 3344445 | 1122221
 | 1234555 | 1212111
 | 4443555 | 2221111
 | 3513245 | 1111221
 | Total 7 digits in a cell
 | in given cell function to convert:
 | 1 | remains as 1
 | 2 | remain as 2
 | 3 | converts to1
 | 4 | converts to2
 | 5 | converts to1
 | currently I use Control +  F; replace 3 to replace with  1
 | currently I use Control + F ;replace 4 to replace with 2
 | currently I use Control + F;replace 5 to replace with  1
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner6

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner6
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-05 00:00:00 | MGT61102 | Tutor 1 | Video recording uploaded onto blackboard |  |  | PS to link
2023-10-30 00:00:00 | MGT61104 | Tutor 4 | (tutor to complete) |  |  | PS to complete
 |  |  |  |  |  | tutor to complete
Spreadsheet: 214930d1361198840-sumif-problem-staff-requirements
Sheet: Machine 3

 | Staff [NAME] by Job
Machine: | 3 - RV53
Start Date:
End Date:
Tool | Staff Required | Start Date | End Date