tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34924d1232380077-date-functions-enter-a-formulae-that-will-calculate-the-current-month-book2
Sheet: Sheet1

January 2009 v January 2008 | 1 | January
 | 2 | February
 | 3 | March
 | 4 | April
 | 5 | May
 | 6 | June
 | 7 | July
 | 8 | August
 | 9 | September
 | 10 | October
 | 11 | November
 | 12 | December
Spreadsheet: 36fd3a8c-6559-4960-b139-ac6aaac577bd
Sheet: Sheet1

Unnamed: 0 | COUNTY SUMMARY/BALLOTS CAST | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Republican |  |  | Democratic
 | Regular | Absentee | Total | Regular | Absentee | Total
Belknap | 4105 | 99 | 4204 | 1063 | 26 | 1089
Carroll | 5039 | 168 | 5207 | 1022 | 23 | 1045
Cheshire | 3943 | 93 | 4036 | 2334 | 46 | 2380
Coos | 1781 | 55 | 1836 | 1065 | 54 | 1119
[NAME] | 6825 | 168 | 6993 | 2378 | 69 | 2447
Hillsborough | 20683 | 594 | 21277 | 10767 | 378 | 11145
Merrimack | 10376 | 206 | 10582 | 3857 | 71 | 3928
Rockingham | 16536 | 549 | 17085 | 5465 | 179 | 5644
[NAME] | 3595 | 107 | 3702 | 2955 | 107 | 3062
[NAME] | 3007 | 73 | 3080 | 1473 | 23 | 1496
Totals | 75890 | 2112 | 78002 | 32379 | 976 | 33355
 | COUNTY SUMMARY/NAMES ON CHECKLIST
 | Republican | Democratic | Undeclared | Total
Belknap | 15227 | 7687 | 11497 | 34411
Carroll | 14107 | 5160 | 12132 | 31399
Cheshire | 14657 | 13399 | 16140 | 44196
Coos | 7180 | 6296 | 6856 | 20332
[NAME] | 19425 | 11938 | 18981 | 50344
Hillsborough | 80030 | 62181 | 62662 | 204873
Merrimack | 31959 | 21053 | 27021 | 80033
Rockingham | 65558 | 46216 | 65147 | 176921
[NAME] | 20124 | 21107 | 22500 | 63731
[NAME] | 8954 | 7021 | 8021 | 23996
Totals | 277221 | 202058 | 250957 | 730236
Spreadsheet: 2500918f-5dbc-46c9-8999-448540b2e88a
Sheet: Sheet1

Release: Housing Units Authorized By Building Permits (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=246
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-17 8:25 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Housing Units Authorized By Building Permits (Seasonally Adjusted) | 2011-12-23 00:00:00 | Current
Link:
http://www.census.gov/construction/bps/ | 2011-12-23 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2011-12-23 00:00:00 | Current
Notes:
Census data seasonally adjusted by the Federal Reserve Bank of Saint | 2011-12-23 00:00:00 | Current
Louis.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
2013-05-24 00:00:00
2013-06-26 00:00:00
2013-07-25 00:00:00
2013-08-26 00:00:00
2013-09-26 00:00:00
2013-11-27 00:00:00
2013-12-24 00:00:00
2014-01-28 00:00:00
2014-02-27 00:00:00
2014-03-26 00:00:00
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: PETRA

 |  |  |  |  |  |  | 2013 PETRA
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Pre-determined Tuesdays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 28883d1223455842-conditional-formatting-by-referencing-a-different-cell-test
Sheet: Sheet1

 | Test Level 1 | Test Level 2 |  | Test 1 Points | Test 2 Points | Progress
[NAME] | 2a | 2a |  | 17 | 17 | 0
[NAME] | 3b | 3a |  | 21 | 23 | 2
[NAME] | 2c | 3a |  | 13 | 23 | 10
[NAME] | 4b | 4a |  | 27 | 29 | 2 |  | 1c | 7
 |  |  |  |  |  |  |  | 1b | 9
 |  |  |  |  |  |  |  | 1a | 11
 |  |  |  |  |  |  |  | 2c | 13
 |  |  |  |  |  |  |  | 2b | 15
 |  |  |  |  |  |  |  | 2a | 17
 |  |  |  |  |  |  |  | 3c | 19
 |  |  |  |  |  |  |  | 3b | 21
 |  |  | Thease would not be seen |  |  |  |  | 3a | 23
 |  |  |  |  |  |  |  | 4c | 25
 |  |  |  |  |  |  |  | 4b | 27
 |  |  |  |  |  |  |  | 4a | 29
Spreadsheet: 693402d1598958547-count-office-and-non-office-hour-between-dates-excel-example_bo_ry
Sheet: Sheet1

 | Engineer Onsite Date | Engineer Onsite Time | Engineer Offsite Date | Engineer Offsite Time | No of Office Hours * | No of Non-Office Hours * |  | Office Hour Definition | In | out
Example 1 - Sep 5 is Weekend (SAT) | 2020-09-04 00:00:00 | 17:30:00 | 2020-09-05 00:00:00 | 01:30:00 |  |  |  | Monday to Friday, 09:00 - 18:00 | 09:00:00 | 18:00:00
Example 2 - Oct 1 is Public Holiday | 2020-10-01 00:00:00 | 16:00:00 | 2020-10-01 00:00:00 | 17:30:00
 |  |  |  |  |  |  |  | Non Office Hour Definition
 |  |  |  |  | * less than 1 hour will count as 1 hour |  |  | Monday to Friday, other than above working hours
 |  |  |  |  |  |  |  | Anytime in Saturday and Sunday
 |  |  |  |  |  |  |  | Public Holiday as below:
 |  |  |  |  |  |  |  | Jan 1, 2020 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  | Jan 25, 2020 | 2020-01-25 00:00:00
 |  |  |  |  |  |  |  | Jan 26, 2020 | 2020-01-26 00:00:00
 |  |  |  |  |  |  |  | Jan 27, 2020 | 2020-01-27 00:00:00
 |  |  |  |  |  |  |  | Jan 28, 2020 | 2020-01-28 00:00:00
 |  |  |  |  |  |  |  | Apr 4, 2020 | 2020-04-04 00:00:00
 |  |  |  |  |  |  |  | Apr 10, 2020 | 2020-04-10 00:00:00
 |  |  |  |  |  |  |  | Apr 11, 2020 | 2020-04-11 00:00:00
 |  |  |  |  |  |  |  | Apr 13, 2020 | 2020-04-13 00:00:00
 |  |  |  |  |  |  |  | Apr 30, 2020 | 2020-04-30 00:00:00
 |  |  |  |  |  |  |  | May 1, 2020 | 2020-05-01 00:00:00
 |  |  |  |  |  |  |  | Jun 25, 2020 | 2020-06-25 00:00:00
 |  |  |  |  |  |  |  | Jul 1, 2020 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  | Oct 1, 2020 | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  | Oct 2, 2020 | 2020-10-02 00:00:00
 |  |  |  |  |  |  |  | Oct 26, 2020 | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Dec 25, 2020 | 2020-12-25 00:00:00
 |  |  |  |  |  |  |  | Dec 26, 2020 | 2020-12-26 00:00:00
Spreadsheet: 0cbabf90-a850-4dca-9970-16c19ac6a2d2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  | STATE OF NEVADA |  |  |  |  |  |  |  |  |  |  |  | Sheet |  |  |  |  | of
DEPARTMENT OF TRANSPORTATION
RECORD OF AUTHORIZATION TO PROCEED WITH MAJOR CONTRACT REVISION
CONTRACT NO.: |  |  |  |  |  |  |  |  |  | PROJECT NO(S).:
[NAME] OF WORK:
CHANGE ORDER NO.: |  |  |  |  |  |  |  |  | CHANGE REQUESTED BY:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (NAME, TITLE, COMPANY/DIVISION) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE
[NAME] AND REASON FOR PROPOSED REVISION
AUTHORITY LEVEL
 |  | RESIDENT ENGINEER'S -   Up to $25,000 on Contracts ≤ $5,000,000 but not to exceed $50,000 on Contracts > $5,000,000
 |  | DISTRICT ENGINEER'S -     Up to $50,000 on Contracts ≤ $5,000,000 but not to exceed $100,000 on Contracts > $5,000,000
ESTIMATED INCREASE / DECREASE: |  |  |  |  |  |  |  |  |  | 54321 |  |  |  |  |  |  |  |  |  | WORKING DAYS: |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INCREASE / DECREASE / NO CHANGE
METHOD OF PAYMENT
 | UNIT BID PRICE(S) |  |  |  |  |  |  |  | FORCE ACCOUNT |  |  |  |  |  |  |  | NEGOTIATED PRICE |  |  |  |  |  |  |  |  | OTHER
RESIDENT ENGINEER:
 |  |  |  |  |  | PRINT NAME & TITLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIGNATURE |  |  |  |  |  |  |  |  |  | DATE
DISTRICT ENGINEER:
 |  |  |  |  |  | PRINT NAME & TITLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIGNATURE |  |  |  |  |  |  |  |  |  | DATE
CONSTRUCTION ENGINEER:
 |  |  |  |  |  | PRINT NAME & TITLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIGNATURE |  |  |  |  |  |  |  |  |  | DATE
Increases more than $100,000 must be approved by the Director.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]'S SIGNATURE |  |  |  |  |  |  |  |  |  | DATE
Spreadsheet: 79961d1280222175-matching-columns-and-filling-blanks-sorting-and-filling-blanks
Sheet: test2.csv

FROM THIS:
 | INITITAL | MATCHED | ID
 | AB002341 | AB002341 | 4897
 | AB002341 | AB002447
 | AB002447 | AB007884 | 23229
 | AB002447
 | AB002447
 | AB007884
 | AB007884
 | AB007884
 | AB007884
To THIS:
 | INITITAL | MATCHED | ID
 | AB002341 | AB002341 | 4897
 | AB002341 | AB002341 | 4897
 | AB002447 | AB002447
 | AB002447 | AB002447
 | AB002447 | AB002447
 | AB007884 | AB007884 | 23229
 | AB007884 | AB007884 | 23229
 | AB007884 | AB007884 | 23229
 | AB007884 | AB007884 | 23229
Spreadsheet: 179587d1347305959-comparing-2-spreadsheets-and-looking-for-the-extra-rows-duplicates
Sheet: Sheet1

 | Check for differences between the two sheets
 | #N/A in column F means it's not in the upload sheet |  |  |  |  |  |  | Check for duplicates in the download sheet
 | Upload Sheet |  |  | Download Sheet |  |  |  | Download Sheet
 | Item | Count |  | Item | Count |  |  | Item | Count | COUNT OF TIMES ITEM SHOWS UP
 | Caskets | 1 |  | Apples | 2 |  |  | Apples | 2 | 2
 | Phones | 4 |  | Bananas | 5 |  |  | Bananas | 5 | 1
 | Radars | 8 |  | Oranges | #N/A |  |  | Oranges | 4 | 1
 | Buttons | 13 |  | Caskets | 1 |  |  | Caskets | 1 | 1
 | Pens | 17 |  | Phones | 4 |  |  | Phones | 4 | 1
 | Apples | 2 |  | Radars | 8 |  |  | Radars | 8 | 2
 | Bananas | 5 |  | Buttons | 13 |  |  | Buttons | 13 | 1
 |  |  |  | Pens | 17 |  |  | Pens | 17 | 2
 |  |  |  | Knobs | #N/A |  |  | Knobs | 12 | 1
 |  |  |  | Pens | 17 |  |  | Pens | 17 | 2
 |  |  |  | Radars | 8 |  |  | Radars | 8 | 2
 |  |  |  | Apples | 2 |  |  | Apples | 2 | 2
Spreadsheet: 216041d1361565875-vlookup-will-not-update-from-dropdown-list-quarterly-data-tracking-example
Sheet: Client

 | Client Name | DOB |  |  | Client Name | DOB
 | 1 | 1964-06-16 00:00:00 |  |  | 1 | 1964-06-16 00:00:00
 | 2 | 1999-11-29 00:00:00 |  |  | 2 | 1999-11-29 00:00:00
 | 3 | 2007-03-13 00:00:00 |  |  | 3 | 2007-03-13 00:00:00
 | 4 | 2007-01-09 00:00:00 |  |  | 4 | 2007-01-09 00:00:00
 | 5 | 1958-12-26 00:00:00 |  |  | 5 | 1958-12-26 00:00:00
 | 6 | 2005-04-28 00:00:00 |  |  | 6 | 2005-04-28 00:00:00
 | 7 | 1965-11-23 00:00:00 |  |  | 7 | 1965-11-23 00:00:00
 | 8 | 1984-09-06 00:00:00 |  |  | 8 | 1984-09-06 00:00:00
 | 9 | 1994-04-29 00:00:00 |  |  | 9 | 1994-04-29 00:00:00
 | 10 | 1986-10-19 00:00:00 |  |  | 10 | 1986-10-19 00:00:00
 | 11 | 2006-05-30 00:00:00 |  |  | 11 | 2006-05-30 00:00:00
Spreadsheet: 80283d1280450637-counting-unique-entries-in-a-column-correlated-by-date-example-final
Sheet: Sheet1

Billing month | Service number
2005-10 | xxxx4496 |  |  | Month: | 2005-11
2005-10 | [NAME] |  |  | Total #'s
2005-10 | xxxx0823
2005-10 | xxxx0823
2005-10 | xxxx4020
2005-10 | xxxx4020
2005-10 | xxxx4027
2005-10 | xxxx4027
2005-10 | xxxx9399
2005-10 | xxxx3994
2005-10 | xxxx3994
2005-10 | xxxx4496
2005-10 | xxxx4496
2005-10 | xxxx9399
2005-10 | xxxx3994
2005-10 | xxxx4027
2005-10 | [NAME]
2005-10 | xxxx4027
2005-10 | [NAME]
2005-10 | xxxx4027
2005-11 | xxxx4027
2005-11 | xxxx3994
2005-11 | xxxx9399
2005-11 | xxxx9399
2005-11 | xxxx4020
2005-11 | xxxx4020
2005-11 | xxxx3994
2005-11 | xxxx4020
2005-11 | xxxx4020
2005-11 | xxxx9399
2005-11 | xxxx3994
2005-11 | xxxx4020
2005-11 | xxxx9399
2005-11 | xxxx4496
2005-11 | xxxx4496
2005-11 | xxxx0823
2005-11 | xxxx9399
2005-11 | xxxx0823
2005-11 | xxxx3994
2005-11 | xxxx4020
2005-12 | xxxx0823
2005-12 | xxxx0823
2005-12 | xxxx3994
2005-12 | xxxx0823
2005-12 | xxxx0823
2005-12 | xxxx0823
2005-12 | xxxx9399
2005-12 | xxxx4020
2005-12 | xxxx9399
2005-12 | xxxx4020
2005-12 | xxxx9399
2005-12 | xxxx4020
2005-12 | xxxx3994
2005-12 | xxxx9399
2005-12 | xxxx9399
2005-12 | xxxx9399
2005-12 | xxxx9399
2005-12 | xxxx3994
2005-12 | xxxx9399
2005-12 | xxxx9399
Spreadsheet: 806136d1669123408-loop-function-to-stack-selective-data-excel_loop
Sheet: Original

Identiifer | Acc | NAMW | AWM | YPR | REG | RMT | NLP | SRB | Technique
24143 | 1.23 |  |  | 56h |  | rt |  |  | T9091
15255 | 1a34 |  | gr |  | drg |  | 8ik |  | S5312
263623 |  |  |  |  |  |  |  |  | S1951
376 |  | dfdd |  | rht |  | 65 |  |  | [NAME]
25636 |  |  | tyuit |  |  |  | 4gh |  | S5305
3764 | r32r |  |  | 5h5t |  |  |  |  | [NAME]
4874 |  | fg |  | h5 | dffd |  |  |  | S0001
2534647 | etr |  |  |  |  |  |  |  | S5314
27474 |  | srt |  |  |  |  | 7uj |  | T9297
236456 | dvdrg |  | 567 |  |  | db |  | gfhyr | S5318
4568696 |  |  |  | fbd |  |  |  |  | T9091
37446 |  | ser |  |  |  |  |  |  | S5312
2345675 |  |  |  |  |  |  | 6kl |  | S1951
2645745 | erge |  | e4 |  |  |  |  |  | [NAME]
236234576 |  | sg |  | dfdf |  |  |  | ht | S5305
45686 |  |  |  |  | dfg |  |  |  | [NAME]
478956 |  |  |  |  |  |  | 7jk |  | S0001
497 |  | st |  | df |  | rtrg |  |  | S5314
48756 | erge |  |  |  |  |  |  |  | T9297
67896 | e8io |  | ery |  | frgcd |  | 9ol |  | S5318
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr. Nouf Al Saud

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation | 0.5
 |  | Refferal | 0.1
 |  | Procedure in the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.4
 |  | OR in the Clinics (From Gross & After Revenue 200,000 50%) | 0.4
 |  | OR outside the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.6
Doctor Calculation
 |  | Gross Revenue | 0
 |  | Doctors Revenue | 0
 |  | Doctor Consultation Revenue | 0
 |  | OHE (5%)
 |  | Net Consultation Revenue | 0
 |  | Amount to be paid | 0
 |  | Refferal Revenue | 0
 |  | Amount to be paid
 |  | Procedure Revenue | 0
 |  | Consumables | 0
 |  | OHE (5%)
 |  | Net Consultation Revenue
 |  | Amount to be Paid
 |  | OR in the Clinic Doctor Revenue | 0
 |  | Less: Implant Consumables | 0
 |  | Less: J Plasma | 0
 |  | Net OR in the Clinic Doctor Revenue
 |  | Amount to be Paid
 |  | OR in the Clinic Doctor Revenue >200000 | 0
 |  | Less: J Plasma | 0
 |  | Net OR in the Clinic Doctor Revenue
 |  | Amount to be Paid
 |  | Net Amount to be Paid
 |  | OR outside the Clinics Revenue | 0
 |  | Hospital Fees
 |  | OHE 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Less: Consumables ( Dr. [NAME] ) | 0
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 4c72d6df-e5d2-4a8c-9031-c95e27545e39
Sheet: Sheet1

TRACK LOADERS
ASV RC30
ASV RC50
ASV RC60
ASV SR80
Attachments
Harley Rake
[NAME]
Forks
EXCAVATING EQUIPMENT
KX41
KX71
[NAME]
KX121
KX161
Attachments
[NAME]
UTILITY LOADERS
Dingo 323
Attachments
Trencher
TRACTOR BACKHOES
B26
TRACTOR LOADERS
B26
L3540HST
Attachments
Aeriator - Aerway
Cutter Rotary 5'
Harley Rake 6'
Landscape Rake 5'
PHD - GreenLine
PHD - Bush Hog
Rear Blade
Seeder - Over (Slit)
Seeder - Primary
Tiller - 48"
Tiller - 64"
Tiller - 70"
TRAILERS
Dual Axel, 12000# +
Dual Axel, 10000#
Dual Axel, 7000#
Single Axel, Utility
Dump Trailer
Attachments
Chains & Binders
Drop & Plug
COMPACTION
Plate Compactor - LG
LIFTS
Telehandler
LAWN & LANDSCAPE
Aeriator Walk Behind
Chipper, Towable
Edger, Bed
Mower, [NAME]
Mower, [NAME]
PHD - One Man
PHD - Towable
Power Broom
Seeder, Hydro
Tiller - Rear Tine
[NAME]
Electric Hammer 60#
Cut Off Saw - Hand
Cut Off Saw - Walk Behind
[NAME]
[NAME]
[NAME]
Spreadsheet: 840536d1692805096-adding-cells-and-columns-with-criteria-of-other-columns-formula-question
Sheet: Sheet1

 |  |  | 5 |  | debit
 | 15 |  | 7 |  | credit
 | 30 |  | 3 |  | Credit
 | 25 |  | 6 |  | Debit
 | 96 |  | 9 |  | Debit
 | 83 |  | 1 |  | Debit
 | 12 |  | 18 |  | Credit
 |  |  | 5 |  | Credit
 |  |  | 6 |  | Debit
 |  |  | 7 |  | Credit
 |  |  | 6 |  | Credit
 |  |  | 8 |  | Debit
 |  |  |  | debit
 |  |  |  | credit
Spreadsheet: 852393d1702459772-how-do-i-seperate-negatives-from-positives-book2
Sheet: Sheet1

 |  |  |  | WHAT I HAVE
 |  | 2023-10-14 00:00:00 |  | Mountain Warehouse Clothing | -145
 |  | 2023-10-14 00:00:00 |  | Happy Dog Pet Insurance | -40
 |  | 2023-10-14 00:00:00 |  | [NAME] (wages) | 325
 |  | 2023-10-18 00:00:00 |  | Waterstones refund | 19.99
 |  | 2023-10-18 00:00:00 |  | AAA Taxi Service | -35
 |  | 2023-10-24 00:00:00 |  | L Smith (handyman job) | 65
 |  |  |  | WHAT I WANT
 |  | 2023-10-14 00:00:00 |  | Mountain Warehouse Clothing | -145
 |  | 2023-10-14 00:00:00 |  | Happy Dog Pet Insurance | -40
 |  | 2023-10-14 00:00:00 |  | [NAME] (wages) |  | 325
 |  | 2023-10-18 00:00:00 |  | Waterstones refund |  | 19.99
 |  | 2023-10-18 00:00:00 |  | AAA Taxi Service | -35
 |  | 2023-10-24 00:00:00 |  | L Smith (handyman job) |  | 65
Spreadsheet: 43744d1242355499-sorting-rows-of-data-by-column-example
Sheet: Sheet1

system: | microsoft |  |  | system: | [NAME]: | [NAME]: | group: | list
policy1 | week |  |  | microsoft | week | long | bcv | prd1
[NAME] | long |  |  |  |  |  |  | prd1
group: | bcv |  |  |  |  |  |  | prd7
list | prd1 |  |  |  |  |  |  | prd4
 | prd1 |  |  |  |  |  |  | prd20
 | prd7 |  |  | microsoft | month | long | cfg | [NAME]
 | prd4 |  |  |  |  |  |  | dev2
 | prd20 |  |  | microsoft | month | long | abc | dev10
 |  |  |  |  |  |  |  | dev2
system: | microsoft |  |  |  |  |  |  | dev9
policy1 | month
[NAME] | long
group: | cfg
list | [NAME]
 | dev2
system: | microsoft
policy1 | month
[NAME] | long
group: | abc
list | dev10
 | dev2
 | dev9
Spreadsheet: 788049d1658240100-working-back-mathematical-calculation-book1
Sheet: INFO

 | CURRENT SETUP
 | ITEM | Current Cost | In how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 5 | 6
 | Pears | 12 | 4 | 0
 | Bananas | 14 | 2 | 2
 | Apricots | 16 | 6 | 0
 | WORK BACK CALCULATION (ONLY IF COST IS ONCE OFF)
 | TOTALS
 | IDEAL OUTCOME (MANUALLY CALCULATED AMOUNTS)
 | ITEM | Current Cost | In how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 5 | 6
 | Pears | 12 | 4 | 0
 | Bananas | 14 | 2 | 2
 | Apricots | 16 | 6 | 0
 | WORKING BACK CALCULATION IF E=0 (TAKE THE AMOUNT IN YEAR NUMBER AS PER COLUMN D AND FIND THE AMOUNT LISTED IN THAT YEAR AND DEVIDE EQUALLY SO THAT IT ADDS UP TO THE SAME
 | TOTALS
Spreadsheet: 82397d1282437208-data-concatenate-if-vlookup-data-concatenate-if-vlookup
Sheet: Solution by me (SunOffice)

LN No. | MR No. | KP No. |  |  |  |  | 'Final No. |  | 'Final No.
 | 12344321 | 12321
56 | 65432109 | 12021
52 | 23456780 | 654321
50 | 1234567 | 4321
50 | 123456 | 321
50 | 12345 | 21
50 | 1234 | 1
 | 123 | 50
 | 12 | 465
 | 1 | 487
 |  | 24
50 | 54321 | 5623
50 | 654321 | 2410
50 | 7654321 | 665544
 | 201000ACM002011
 | 201005ACM122011
 | 201003ACM452011 | 78
 | 201005ACM802011 | 123456
 | 201046ACM1232011
 | 2010123ACM3212011
 | 2010876ACM042011 | 225
50 | 551364 | 1
50 | 24153 | 12
51 | 12345678 | 123
52 | 23456789 | 123
53 | 34567890 | 1234
54 | 45678901 | 12345
55 | 56789012 | 123456
56 | 67890123 | 18
50 | 3214123 | 121
 |  |  |  |  |  |  |  |  |  |  |  | Match No. | Ln_number
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 50
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 51
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 52
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 53
 |  |  |  |  |  |  |  |  |  |  |  | 4 | 54
 |  |  |  |  |  |  |  |  |  |  |  | 5 | 55
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 56
Spreadsheet: 4d20e0c9-9531-46fd-8721-c076470cf9cb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261669 | 30439 | Joleen | Hakker | NED | 44 | 00:23:21 | 00:01:23 | 00:38:57 | 00:01:37 | 00:10:55 | 1 | 1:16:11
Spreadsheet: 588189d1535536430-formula-for-vlookup-for-next-n-days-mikehk-bsb-
Sheet: Sheet1

example 1
Input Date |  |  | Desired results in cell D8
2018-01-04 00:00:00
example 2
 |  |  | Desired results in cell D17
2018-01-09 00:00:00
Spreadsheet: 66835c15-e41b-43cb-89b8-5fa630d2934d
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | WORKFORCE
 |  |  |  |  |  |  | BRANCH: PORT [NAME]
 |  |  |  |  |  |  | TIMESHEET: send approved timesheets to [EMAIL]
 |  |  |  |  |  |  | or FAX to: 1300 301 994 before 10am Wednesday
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email: [EMAIL]
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
 |  |  | Total Hours or Days
Chandler Macleod Payroll, 200 Greenhill Road, EASTWOOD SA 5063
August 2010