tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 12-28 Night

 | CR1 | Priority | Headcount
1 | Alinity RV | 18 | 0.25
2 | Alinity RV | 17 | 0.25
3 | Alinity RV | 16 | 0.25
4 | Alinity RV | 15 | 0.25
5 | Alinity RV | 14 | 0.25 |  |  |  |  |  |  |  |  |  | Balinda
12 |  |  |  |  |  |  |  |  |  |  |  |  | Ray
13 | [NAME] | 20 | 0.25 |  |  |  |  |  |  |  |  |  | Niki
9 | Architect RV | 13 | 0.25 |  |  |  |  |  |  |  |  |  | 1 CR1 & 2 CR2
15 | Architect SC | 12 | 0.25 |  |  |  |  |  |  |  |  |  | Metrology help measurements
17 | Architect RV | 11 | 0.25
50 | Baxter SIV Assy | 19 | 3 |  |  |  |  |  |  |  |  |  | Xavier
31 | Architect RV | 10 | 0.25 |  |  |  |  |  |  |  |  |  | Dezree
8 | Architect RV | 9 | 0.25 |  |  |  |  |  |  |  |  |  | Noemy
10 | Architect RV | 8 | 0.25 |  |  |  |  |  |  |  |  |  | Dinah
11 | [NAME] | 21 | 0.25 |  |  |  |  |  |  |  |  |  | Reyes
18 | Architect RV | 7 | 0.25 |  |  |  |  |  |  |  |  |  | [NAME]
19 | Architect RV | 6 | 0.25
20 | [NAME]
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | 6ul | 4 | 0.25
74 | Side Cassette | 3 | 0.25
78 | PP1 | 2 | 0.25
79 | E/O Piston | 1 | 0.25
77 | PP4 | 5 | 0.25
87 | [NAME] | 6 | 0.25
53 | Architect RV | 7 | 0.25
61 | [NAME] | 8 | 0.5
66 | [NAME] | 9 | 0.5
83 | Ceph OM#1
84 | Ceph MB#1 | 12 | 0.25
86 | [NAME] | 10 | 0.25
62 | NP227 | 13 | 0.25
63
64
67 | [NAME] | 14 | 0.25
69
88 | E/O Barrel | 11 | 0.25
106 | Key 3 white assembly | 15 | 2
107
108
109
Total
Spreadsheet: 700320d1603128789-count-consecutive-cells-in-reverse-above-value-test2
Sheet: general

Last First M | ID | Grade | Local ID | Instructional Setting | Ethnic Code | Year Entered | Program | PC | 8/31 | 9/7 | 9/14 | 9/21 | 9/28 | 10/5 | 10/12 | 10/19 | 10/26 | TOT
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 |  |  |  |  |  |  |  |  | 0.7 | 0 | 0 | 0
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | -14809
2001-08-04 00:00:00
CBS Volume
 |  |  | -20765
Spreadsheet: 221771d1363664217-time-adherence-sheet-for-excel-adherence-tracking
Sheet: Sheet1

02:00:00 | Start | End | ACW minutes used per call | Total ACW minutes used | Alloted Time Remaining | Adherence %
ACW | 08:30:00 | 08:35:00
ACW | 08:40:00 | 08:43:00
ACW | 09:01:00 | 09:15:00
ACW | 09:30:00 | 09:45:00
ACW | 10:00:00 | 10:30:00
ACW | 01:00:00 | 01:15:00
ACW
ACW
ACW
ACW
ACW |  |  |  |  |  |  |  | In A1,    I just colored the font white White letters on a white background.
ACW
ACW
ACW |  |  |  |  |  |  |  | The argument,what goes in-between (), for an IF statement has three parts IF(test,what to do if test is true,what to do if test is false).  The commas separate test from true and true from false.
ACW
ACW
ACW
ACW
ACW
ACW |  |  |  |  |  |  |  | Your if has two =IF(F8>0,1-F8/8)   Test and true.
ACW
ACW |  |  |  |  |  |  |  | But in this case IFERROR works better
ACW |  |  |  |  |  |  |  | Syntax of IFERROR:   IFERROR(calculation,what to do if the calculation is an ERROR).  If it is not an ERROR it will do the calculation.    Sooo    =IFERROR(1-F2/8,"") will do the calculation but when it can't and errors with #[NAME] it puts nothing "" in the cell.
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
Spreadsheet: 2ed6f882-97b7-45b3-a660-07cb7c2ae8bf
Sheet: Table 7.3

Monthly Statistical Bulletin
7.3 Overseas arrivals—visitors and settlers
Month | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Visitors (a) (b) – '000
July
August
September
October
November
December
January
February
March
April
May
June
Annual
Settlers (c) – '000
July
August
September
October
November
December
January
February
March
April
May
June
Annual |  | 158.9 | 158.9 | 158.9 | 158.9
(a) Monthly figures are seasonally adjusted.
(b) Visitors are overseas visitors whose intended stay in Australia is less than 12 months.
(c) Settlers are travellers who hold migrant visas, New Zealand citizens who indicate an intention to settle, and those who are otherwise eligible to settle. |  |  |  |  |  |  |  | Update
Source: ABS, Overseas arrivals and departures, Cat. no. 3401.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=&
Spreadsheet: 0ca8c7e3-196d-4f0d-90ec-51820b06f31e
Sheet: Indentifiable School Admin

FY 2015 Integration Revenue Budget Worksheet
District Number: |  |  | District Name:
10% Admin/Indirect Costs
On this worksheet, please list all Administrative/Indirect proposed expenditures for the district's racially identifiable school(s). No more than 10 percent of the RIS budget may be spent on Administrative/Indirect costs. See FY15 Budget Guide for details.
Line Item Description | UFARS Code Required |  |  |  | Budgeted Amount | Actual Expenditures | Budget Narrative
Provide a short description of the expenditure. | ORG | PROG | FIN | OBJ | List the total amount budgeted for this line item. | Resubmit form with actual FY15 expenditures by 12/1/15. | Provide a brief description of how these funds will be used to support achievement or integration strategies listed in your plan. List the [NAME] and Activity numbers from your plan in the colum to the right. | Plan Goal & Activity
TOTAL
Notes or Comments:
Spreadsheet: 82789d1282818170-how-to-define-auto-color-rows-two-week-programme
Sheet: Sheet1

SAUDI BINLADIN GROUP |  |  |  | Two Week Look Ahead Schedule |  |  |  |  |  |  | Client : EMAAR
(Public Building and Airport Division) |  |  |  |  |  |  |  |  |  |  | Project Management : TURNER ARABIA
 |  |  |  |  |  |  |  |  |  |  | Consultant: [NAME]
Activity  ID | Activity Description |  |  |  | Org    Dur | Actual %Comp | Early       Start | Early    Finish | Late   Start | Late Finish | 2010
 |  |  |  |  |  |  |  |  |  |  | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
Beach Access & Penisula Road
[NAME] and [NAME] (Phase-1)
Phase-1
Electrical Substation 1
Sewage Water Pumping Station
Start Date |  |  | 11FEB08
Finish Date |  |  | 15SEP09 |  |  |  |  |  |  |  | Date | Revision |  |  |  | Checked | Approved
Date Date |  |  | 08AUG09 |  |  |  |  |  |  |  | 01JUL09 | [NAME] Rev-4 |  |  |  | [NAME] | [NAME] | [NAME]
Run Date |  |  | 09AUG09 14:47
© Primavera Systems, Inc.
Spreadsheet: 274201d1383049681-create-a-range-that-moves-while-you-scroll-plannerhelp
Sheet: Planner

Journey [NAME]
 |  | u Options |  |  |  |  |  | Notes:
 |  |  |  |  |  |  |  | - | Start Date: Will be the fist Monday of your 4 week planner (You will only need to update this every 4 weeks, check last dates in Row 102)
 |  | Start Date | 2013-10-28 00:00:00 |  | Start Time | 08:00:00 |  | - | Start Time: This will run on a 12hr hour period from your selected time
 |  |  |  |  |  |  |  | - | Time Format: This is purely for user preference, select the format to whatever you prefer (It will show the times in Column B
 |  | Show :30 Minutes? | Yes |  | Time Format | h:[NAME] |  | - | Show 30 mins & Shade Weekends: These will show a 30min interval in Column B and Shade the columns which fall on a Weekend
 |  |  |  |  |  |  |  | - | This sheet has print ranges set to print 1 Week per printed page (to change see Excel Page Setup or set view to Page Break Preview).
 |  | [NAME]? | Yes |  |  |  |  | - | This Sheet has headers locked as you scroll (Freeze Panes).  To turn off refer to [NAME]…
 | Week 1
 |  |  |  |  |  |  |  |  |  | Current selected list
 |  |  |  |  |  |  |  |  |  | [NAME] | Head2 | Head3 | Head4 | Head5 | Head6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 |  |  |  |  |  |  |  |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
 | Week 2
 | Week 3
 | Week 4
Spreadsheet: 787492d1657817527-return-date-column-header-when-value-is-expected-to-hit-target-number-planning-sheet
Sheet: Sheet1

ItemNumber | Min | Date to min | NewPartsOnHand | SubOH | 2022-07-17 00:00:00 | 2022-07-24 00:00:00 | 2022-07-31 00:00:00 | 2022-08-07 00:00:00 | 2022-08-14 00:00:00 | 2022-08-21 00:00:00 | 2022-08-28 00:00:00 | 2022-09-04 00:00:00 | 2022-09-11 00:00:00 | 2022-09-18 00:00:00 | 2022-09-25 00:00:00 | 2022-10-02 00:00:00 | 2022-10-09 00:00:00 | 2022-10-16 00:00:00 | 2022-10-23 00:00:00 | 2022-10-30 00:00:00 | 2022-11-06 00:00:00 | 2022-11-13 00:00:00 | 2022-11-20 00:00:00 | 2022-11-27 00:00:00 | 2022-12-04 00:00:00 | 2022-12-11 00:00:00 | 2022-12-18 00:00:00
abcd | 25 | 2022-09-04 00:00:00 | 100 | 20 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 0
1234 | 100 | 2022-10-16 00:00:00 | 1000 |  | 50 | 50 | 50 | 75 | 75 | 50 | 150 | 50 | 50 | 75 | 100 | 50 | 50 | 50 | 75 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Spreadsheet: 127187d1320224574-excel-2007-if-and-or-suggestions-excel-forum-help2
Sheet: Sheet1

 | 2011-08-01 00:00:00 | 2011-12-31 00:00:00 | 2012-01-01 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | 31/06/2012 | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 | Date Completed | Within forecast? | Forecasted dates |  | Before or After Forcast?
Project 1 |  |  | Yes |  |  |  |  |  | 2012-08-28 00:00:00
Project 2 | Yes |  |  |  |  |  |  |  | 2010-08-20 00:00:00
Project 3 |  |  |  |  | Yes |  |  |  | 2012-04-03 00:00:00
Spreadsheet: 02465666-1275-4ab9-a4cf-6167dee3ddb0
Sheet: Setting codes

n/a | SFY 2014 STATE CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk | n/a
n/a | n/a
EDRS Setting Codes | n/a
Setting Codes Required for Personnel Type Codes 01 and 07 on EDRS | n/a
Ages 6 to 21 and Birth thru 2 | n/a
Setting code | [NAME]
A | Regular Class
B | Resource Room
C | Separate Class
D | Public Separate Day School
F | Public Residential
G | Private Residental
H | Home Based/Homebound/Hospital (use with FSC c Birth-2)
I | Lead teacher Provides No Direct Service
n/a | n/a
Ages 3 Through 5 | n/a
Setting code | [NAME]
Y | Early Childhood 3-5
end of worksheet
Spreadsheet: 873760d1720324264-next-5-row-number-what-formula-should-i-put-so-that-i-get-the-next-row-in-column-c-as-the-next-5-row-number
Sheet: Sheet1

24232.75 |  |  | =A1 |  | 1 | 1
24232.75 |  |  | =A5 |  | 2 | 5
24232.75 |  |  | =A10 |  | 3 | 10
24234.05 |  |  | =A15 etc |  | 4 | 15
24233.45 |  |  | =A20 formula |  | 5 | 20
24234.95 |  |  | What formula should I put so that I get the next row in column C as the next 5 row number of column A |  | 6 | 25
24235.6
24232.85
24221.35
24222.7
24219.15
24218.9
24215.2
24220.65
24228.95
24232
24230.25
24233.4
24232.9
24229.3
24228.1
24221.7
24224.65
24223.6
24220.95
24221.05
24221.15
24220.6
24222.7
24226.95
24227.15
24227.4
24229.9
24234.45
24232.65
24231.4
24231.35
24231.35
24230.55
24232.05
24233
24232.4
24231.25
24233.5
24232.9
24233.45
24234.25
24233.4
24235.95
24232.9
24232.25
24230.9
24229.45
24228.65
24229
24230.1
24233.15
24233.7
24235.05
24233.25
24234.85
24237.25
24237.25
24234.7
24236.6
24235.9
24237
24237.5
24239.05
24236.25
24236.7
24236.8
24235.8
24237.5
24238.5
24238.15
24238.85
24240.35
24243.2
24240.75
24242.4
24240.9
24238.65
24233
24228.95
24228.2
24225.3
24227.8
24225.6
24226.95
24225.5
24229.5
24228.85
24231
24233.8
24229.65
24230.1
24228
24228.5
24229.3
24230.65
24231.15
24232.4
24232.95
24228.1
24228.55
24227.4
24224.95
24225.7
24221.8
24223.5
24225.25
24224.9
24228.55
24228.15
24228.4
24226.7
24228.1
24226.8
24226.85
24224.45
24223
24224.5
24225.4
24222.25
24218
24215.45
24217.7
24216.8
24216.4
24217.35
24216.5
24215.25
24213.9
24217.15
24215.4
24212.75
24213.3
24212.5
24211.4
24212.2
24211.35
24213.95
24210.6
24211.25
24210.4
24209.05
24212.3
24210.65
24209.65
24209.55
24211.3
24210.35
24207.4
24204.2
24207.8
24210.75
24211.05
24214.4
24216.85
24220.25
24219.4
24218.85
24216.4
24211.75
24213.3
24212.6
24214.15
24217.3
24217.95
24216.2
24215
24210.75
24216.9
24226
24230.8
24245.2
24243.7
24249.2
24252.1
24259.2
24263
24265.6
24268.2
24270.8
24272.1
24273.3
24274.35
24278.8
24277.5
24283.4
24290.95
24296.65
24296.65
24292.65
24302.35
24303.2
24298.1
24296.25
24290.95
24288.9
24289.6
24291.8
24289.35
24288.1
24285
24288.6
24290.6
24297.15
24298.3
24304.7
24309.45
24312.8
24314.75
24315.5
24319.9
24324.75
24329.25
24326.2
24317.25
24320.95
24321.45
24321
24319.15
24319.85
24319.9
24322.55
24329.55
24331.75
24335.4
24334.5
24333.25
24335.9
24336.7
24336.9
24339.9
24343.55
24344.45
24341.9
24338.7
24338.25
24336
24338.65
24346.65
24345.55
24347
24346.6
24348.1
24349.1
24353.25
24348.55
24343.55
24341.95
24339.75
24339.85
24341.55
24340.05
24337.7
24334.35
24337.1
24344.25
24344
24346.6
24349.25
24352.7
24352.4
24351.3
24353.1
24357
24357.85
24361.3
24360.75
24361.45
24356.85
24352.5
24352.1
24347.85
24345.1
24345.9
24345.25
24343.65
24341.75
24340.55
24342.65
24341.7
Spreadsheet: 871580d1718027689-previous-month-closing-balance-previous-month-balance
Sheet: Monthly Bank Statement

 | The formula on H8 works when the transactions start on the first day of the month, when the transactions start on the second or fourth day of the month the formula does not work
 | The formula on H8 extract the closing balance of the previous month. Please kindly help with formula that extract the closing balance regardless of which day the transactions
 | starts
 |  |  |  |  | May
 | Date | Description | Account | Reference | Debit | Credit | Balance |  |  |  |  | April
 | Balance B/d |  |  |  |  |  |  |  |  |  |  | May
 |  | May | Bank Charges | Mayb1 | 0 | 120
 | 2024-05-02 00:00:00 | May | Bank Charges | Mayb2 | 0 | 16
 | 2024-05-06 00:00:00 | May | Fees | 15863 | 2133.34 | 0
 | 2024-05-06 00:00:00 | May | Fees | 15863A | 2133.33 | 0
 | 2024-05-06 00:00:00 | May | Fees | 15863B | 2133.33 | 0
 | 2024-05-06 00:00:00 | May | Fees | 15864 | 1485 | 0
 | 2024-05-09 00:00:00 | May | PAYE | Mayb3 | 0 | 15.01
 | 2024-05-10 00:00:00 | May | Electricity | 2274 | 0 | 400
 | 2024-05-10 00:00:00 | May | Electricity | 2275 | 0 | 270
 | 2024-05-10 00:00:00 | May | Bank Charges | Mayb4 | 0 | 13.4
 | 2024-05-10 00:00:00 | May | Bank Charges | [NAME] | 0 | 6.7
 | 2024-05-16 00:00:00 | May | Fees | 15865 | 1356 | 0
 | 2024-05-21 00:00:00 | May | Electricity | 2293 | 0 | 668.4999999999999
 | 2024-05-21 00:00:00 | May | Electricity | 2294 | 0 | 401.1
 | 2024-05-21 00:00:00 | May | Water | 2288 | 0 | 700
 | 2024-05-21 00:00:00 | May | Water | 2289 | 0 | 700
 | 2024-05-21 00:00:00 | May | Telephone & Internet | 2290 | 0 | 483
 | 2024-05-21 00:00:00 | May | Telephone & Internet | 2291 | 0 | 262
 | 2024-05-21 00:00:00 | May | Sundry Expenses | 2292 | 0 | 140
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb6 | 0 | 67.09
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb7 | 0 | 10.7
 | 2024-05-21 00:00:00 | May | Bank Charges | [NAME] | 0 | 2.4
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb9 | 0 | 7
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb10 | 0 | 7
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb11 | 0 | 7.45
 | 2024-05-24 00:00:00 | May | Cleaning | 2301 | 0 | 126
 | 2024-05-24 00:00:00 | May | Bank Charges | Mayb12 | 0 | 2.52
 | 2024-05-24 00:00:00 | May | Bank Charges | Mayb13 | 0 | 2.4
 | 2024-05-28 00:00:00 | May | Electricity | 2305 | 0 | 260
 | 2024-05-28 00:00:00 | May | Bank Charges | Mayb14 | 0 | 5.2
 | 2024-05-28 00:00:00 | May | Bank Charges | Mayb15 | 0 | 2.6
 | 2024-05-30 00:00:00 | May | Fees | 15866 | 1485 | 0
 | 2024-05-30 00:00:00 | May | PAYE | 2312B | 0 | 3000
 | 2024-05-30 00:00:00 | May | Bank Charges | Mayb16 | 0 | 40
 | 2024-05-31 00:00:00 | May | Fees | 15867 | 2475 | 0
 | 2024-05-31 00:00:00 | May | Fees | 15868 | 2475 | 0
 | 2024-05-31 00:00:00 | May | Fees | 15869 | 2475 | 0
 | 2024-05-31 00:00:00 | May | Bank Charges | Mayb17 | 0 | 192
 | 2024-05-31 00:00:00 | May | Bank Charges | Mayb18 | 0 | 9.6
Spreadsheet: 355995d1414907978-auto-filter-test-marks
Sheet: Passed

Name | Marks Science | Maths | English | Physics | History | GK | Remarks
Spreadsheet: 775226d1648913106-day-fixed-fetch-current-month-fetch-current-year-formula-help-expenses-home
Sheet: 2022-04

Home Budget - April 2022
 |  |  |  |  |  |  |  |  |  |  | Amount | Merchant | Date
 |  |  |  |  |  |  |  |  |  |  | -6.5 | Amazon Store Card
 |  |  |  |  |  |  |  |  |  |  | 100 | Discover
 |  |  |  |  |  |  |  |  |  |  | 125 | [NAME]'s
 |  |  |  |  |  |  |  |  |  |  |  | eBay MC
 |  |  |  |  |  |  |  |  |  |  |  | Ollocard MC
 |  |  |  |  |  |  |  |  |  |  |  | Mercury MC
 |  |  |  |  |  |  |  |  |  |  |  | PenFed VISA
 |  |  |  |  |  |  |  |  |  |  | 600 | Shell MC
 |  |  |  |  |  |  |  |  |  |  |  | TD Bank VISA
 |  |  |  |  |  |  |  |  |  |  |  | Wawa
 |  |  |  |  |  |  |  |  |  |  | 25 | Wells Fargo VISA
Total |  |  |  |  |  | Total |  |  | Total |  |  | Total
Spreadsheet: 189534d1351210740-excel-macro-or-function-to-break-apart-address-propertyexample
Sheet: Sheet1

Property Address | [NAME]
5918   ROCKY POINT CT    ARLINGTON TX 76018 | 76018
1105   TWIN PINE CT    ARLINGTON TX 76018 | 76018
5311   PAMPAS CT    ARLINGTON TX 76018 | 76018
611   MISSION HILLS DR    ARLINGTON TX 76018 | 76018
401   VALLEY MILLS DR    ARLINGTON TX 76018 | 76018
117   HARDIN DR    ARLINGTON TX 76018 | 76018
2101   MERRITT WAY    ARLINGTON TX 76018 | 76018
6007   FLAT WOOD LN    ARLINGTON TX 76018 | 76018
2430   SUTTON DR    ARLINGTON TX 76018 | 76018
Spreadsheet: 682048d1591886805-looking-for-a-way-to-calculate-the-end-value-of-payments-total-paid
Sheet: Total Paid

 |  | Rate increase/year | 0.03 | 0.05 | 0.1 | 0.5 | 1
 |  | Starting value | 200 | 200 | 200 | 200 | 200
 |  | Rate increase/year - $ Value | 6 | 10 | 20 | 100 | 200
 |  | Year 1 Payout | 206 | 210 | 220 | 300 | 400
 |  | Rate increase/year - $ Value | 6.18 | 10.5 | 22 | 150 | 400
 |  | Year 2 Payout | 212.18 | 220.5 | 242 | 450 | 800
 |  | Rate increase/year - $ Value | 6.3654 | 11.025 | 24.2 | 225 | 800
 |  | Year 3 Payout | 218.5454 | 231.525 | 266.2 | 675 | 1600
 |  | Rate increase/year - $ Value | 6.556362 | 11.57625 | 26.62 | 337.5 | 1600
 |  | Year 4 Payout | 225.101762 | 243.10125 | 292.82 | 1012.5 | 3200
 |  | Rate increase/year - $ Value | 6.75305286 | 12.1550625 | 29.282 | 506.25 | 3200
 |  | Year 5 Payout | 231.85481486 | 255.2563125 | 322.102 | 1518.75 | 6400
 |  | Payout over 5 years | 1093.68197686 | 1160.3825625 | 1343.122 | 3956.25 | 12400
Spreadsheet: 707684d1607422309-excel-2016-vlookup-issue-with-dropdown-raid-log
Sheet: Risks & Issues

2
RISKS
No. | Date Identified | Description | Catagory | Type | Probability | Impact | [NAME] |  | Target  Date | Status | Mitigarions | Owner | Actions by | Notes
1 |  |  |  |  | likely | minor |  |  |  | Open
2 |  |  |  |  | almost certain | severe |  |  |  | Open
3 |  |  |  |  | unlikely | minor |  |  |  | Open
4 |  |  |  |  | possible | insignificant |  |  |  | Open
5 |  |  |  |  | unlikely | severe |  |  |  | Open
6 |  |  |  |  | likely | minor |  |  |  | Open
7 |  |  |  |  | likely | minor
8 |  |  |  |  | likely | minor
9 |  |  |  |  | likely | minor
10 |  |  |  |  | likely | minor
11 |  |  |  |  | likely | minor
12 |  |  |  |  | likely | minor
13 |  |  |  |  | likely | minor
14 |  |  |  |  | likely | minor
15 |  |  |  |  | likely | minor
16 |  |  |  |  | likely | minor
17 |  |  |  |  | likely | minor
18 |  |  |  |  | likely | minor
19 |  |  |  |  | likely | minor
20 |  |  |  |  | likely | minor
21 |  |  |  |  | likely | minor
22 |  |  |  |  | likely | minor
23 |  |  |  |  | likely | minor
24 |  |  |  |  | likely | minor
25 |  |  |  |  | likely | minor
26 |  |  |  |  | likely | minor
27 |  |  |  |  | likely | minor
28 |  |  |  |  | likely | minor
Spreadsheet: 43804d1242402815-two-criteria-min-function-and-criteria
Sheet: Sheet1

 | Weighting
 | Cost | 0.9
 | Time | 0.1
 | Product | Vendor | Cost ($) | TurnTime (days) | Valid quote | MinCost | MinTurnTime | CostIndex | TimeIndex |  | Score
 | A | X | 500 | 10 | No | 0 | 1 | 0 | 0.1 |  | 0.01
 | A | Y | 501 | 10 | Yes | 500 | 1 | 0.998003992015968 | 0.1 |  | 0.9082035928143712
 | A | Z | 510 | 1 | Yes | 500 | 1 | 0.9803921568627451 | 1 |  | 0.9823529411764705
 | B | X | 10000 | 5 | Yes | 10000 | 5 | 1 | 1 |  | 1
 | B | Y | 10500 | 5 | Yes | 10000 | 5 | 0.9523809523809523 | 1 |  | 0.9571428571428571
 | B | Z | 15000 | 5 | Yes | 10000 | 5 | 0.6666666666666666 | 1 |  | 0.7
 | C | X | 40000 | 1 | Yes | 40000 | 1 | 1 | 1 |  | 1
 | C | Y | 45000 | 1 | No | 40000 | 1 | 0.8888888888888888 | 1 |  | 0.8999999999999999
 | C | Z | 50000 | 1 | Yes | 40000 | 1 | 0.8 | 1 |  | 0.8200000000000001
Spreadsheet: 587973d1535415526-formula-that-skips-rows-when-copy-pasted-review-sheet
Sheet: Stats

First Name | Department | Supervisor | Productivity | Prod. comments | Quality | Qual. comments | Attendance | [NAME]. comments | Attitude | Att. comments
Employee One | Department | Supervisor | 1.5 | Comment 1 | 1 | Comment 2 | 2 | Comment 3 | 2 | Comment 4
Employee Two | Department | Supervisor | 2 | Comment 11 | 2 | Comment 22 | 3 | Comment 33 | 2 | Comment 44