tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 111873d1308138222-excel-2007-link-a-list-box-to-a-table-dashboard-business-activity-in-eurozone
Sheet: Dashboard

 | Business Activity In EuroZone |  |  |  |  | Based on data from EuroStats
 | Annual growth rates by Country for Index (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 2004 | 2005 | 2006 | 2007 | 2008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | EU-27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Euro area |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | Belgium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | Bulgaria |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | Czech Republic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | Denmark |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | Germany |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | Estonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 | Ireland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 | Greece |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | Spain |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | France |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 | Italy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 | Cyprus |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 | Latvia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | Lithuania |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 | Luxembourg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | Hungary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 | Malta |  |  |  |  |  |  |  | Value added (EUR billion) |  |  |  |  | Number of persons employed (1000) |  |  | Average personnel costs (EUR 1 000 per employee) |  |  |  | 24
 | Netherlands |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 | Austria |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 | Poland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 | Portugal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 | Romania |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 | Slovenia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 | Slovakia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 | Finland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 | Sweden
 | United Kingdom
 | Croatia
 | Turkey
 | Norway
Spreadsheet: 875799d1722432805-return-corresponding-values-from-another-table-sample-daily-record-week-commencing-29-07-2024
Sheet: Mon 29.07.2024

 | RESIDENT ENGINEER - DAILY RECORD OF ON-SITE LABOUR/PLANT RESOURCES AND NOTABLE EVENTS
 | RE Staff: |  |  |  |  | Date:   31/07/2024 |  |  |  |  |  |  |  | Temperature:  8 degrees |  |  |  |  |  |  |  |  |  | Works Section:  Section 1
 | Start Time:  8:00 |  | Finish Time:  6:00 |  |  | Weather: |  |  | A.M: Cloudy |  |  |  |  | P.M: Cloudy |  |  |  |  |  |  |  |  |  |  |  | Chainage
 |  | Labour -  Company/Trade/Name |  | Location | Total Hours | Activity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Activity | Details of Activity | Location | From | To
 |  |  |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P |  | A |  | A
 |  | ABC Hire - pipe layer - [NAME] |  |  |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Hire BC - General Operative - A N Other |  | Cofferdam 1h, [NAME] hill 1h |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | B |  | B
 |  | Hire BC - General Operative - A N Other |  | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | Task E | Cofferdam
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | Task F | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | Parked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notable Events/Comments
 |  | Plant Type | Company | Location | Plant Hours | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P
 |  | 35T 360 excavator |  | Clonhaston |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 10
 |  | Volvo L60E wheel loader/shovel |  | Clonhaston |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | Twaites 9T dumper |  | Clonhaston |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | Case CX75C SR 7T 360 excavator |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Forde

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 41498d1239974663-graphing-gains-and-losses-of-personnel-gainsandlosses2
Sheet: Sheet1

Name | Gain | other data | other data | other data | other data | other data | Lost | other data | other data
Fred | 2009-01-01 00:00:00 |  |  |  |  |  | 2009-01-29 00:00:00
Johny | 2009-01-15 00:00:00 |  |  |  |  |  | 2009-02-10 00:00:00
[NAME] | 2009-02-17 00:00:00 |  |  |  |  |  | 2009-03-22 00:00:00
Betty | 2009-03-02 00:00:00 |  |  |  |  |  | 2009-04-01 00:00:00
Scobby | 2009-03-18 00:00:00 |  |  |  |  |  | 2009-05-26 00:00:00
Spreadsheet: 6f392d37-74e6-4c35-b2bb-42085b8cb452
Sheet: Sheet1

3.4.2.1 - Evolución de los accesos a servicios de comunicaciones fijas por tipo de soporte. [NAME] instalados. 1990-2010 | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Cableados |  |  |  |  |  |  |  |  |  |  |  |  |  | 23277881 | 23694030 | 24122061 | 24469289 | 24928192 | 25188280 | 25671388 | 26692966
FTTx (1) |  |  |  |  |  |  |  |  |  |  |  |  |  | 4143 | 191047 | 252110 | 353580 | 436783 | 585567 | 1024559 | 1193094
Solo par de cobre |  |  |  |  |  |  |  |  |  |  |  |  |  | 17670695 | 17018374 | 16838793 | 16513031 | 16224184 | 15984399 | 15865857 | 15996403
Solo HFC |  |  |  |  |  |  |  |  |  |  |  |  |  | 1048986 | 1164101 | 884890 | 1133536 | 1352490 | 1441580 | 1507566 | 1620201
HFC y Par de Cobre (2) |  |  |  |  |  |  |  |  |  |  |  |  |  | 4552290 | 5316762 | 6143939 | 6466544 | 6912947 | 7174977 | 7271667 | 7881918
Red Eléctrica (PLC) |  |  |  |  |  |  |  |  |  |  |  |  |  | 1767 | 3746 | 2329 | 2598 | 1788 | 1757 | 1739 | 1350
Vía radio |  |  |  |  |  |  |  |  |  |  |  |  |  | 454953 | 416358 | 408953 | 465617 | 507713 | 644565 | 737762 | 742349
Radio |  |  |  |  |  |  |  |  |  |  |  |  |  | 453852 | 413258 | 404478 | 457559 | 500897 | 632313 | 724270 | 731059
Satélite |  |  |  |  |  |  |  |  |  |  |  |  |  | 1101 | 3100 | 4475 | 8058 | 6816 | 12252 | 13492 | 11290
Otros |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76062 | 94872 | 6690 | 10118 | 7387
Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 23732834 | 24110388 | 24531014 | 25010968 | 25530777 | 25839535 | 26419268 | 27442702
Nota: Un acceso instalado equivale a un acceso comercializable que se puede activar en un plazo razonable y corto de tiempo (48 horas). No se incluyen los pares vacantes. (1) No se dispone de datos de Telefónica de España [NAME] año 2003. (2) Se incluyen accesos basados en soluciones [NAME] fibra y cable coaxial y en paralelo se instala un par de cobre.
Fuente: Elaboración [NAME] a partir [NAME] del Mercado de las Telecomunicaciones, Informe anual, varios años.
Spreadsheet: 746009d1630432093-sumifs-multiple-criterias-sumifs
Sheet: Sheet1

 | 2021 | 2020
Sales | 20 | 25
Cost | 15 | 10
Cost | 30 | 25
Expenses | 40 | 35
Discount | 50 | 55
Sales | 35 | 10
Expected result but need to include the Year as one of the criteria:
 | 2021 | 2020
Cost
Spreadsheet: 697951d1601640270-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we40
Sheet: Public Holidays

2020 South Africa Holidays and Festive Days
Date | Day Category | Holiday and Notable Festive Days
2020-01-01 00:00:00 | South Africa & Common | New Year's Day
2020-03-21 00:00:00 | South Africa & Common | Human Rights Day
2020-04-10 00:00:00 | Christian / Catholic | Good Friday
2020-04-13 00:00:00 | South Africa & Common | Family Day
2020-04-27 00:00:00 | South Africa & Common | Freedom Day
2020-05-01 00:00:00 | South Africa & Common | Worker's Day
2020-06-16 00:00:00 | South Africa & Common | Youth's Day
2020-08-09 00:00:00 | South Africa & Common | National Women's Day
2020-09-24 00:00:00 | South Africa & Common | Heritage Day
2020-12-16 00:00:00 | South Africa & Common | Day of Reconciliation
2020-12-25 00:00:00 | Christian / Catholic | Christmas
2020-12-26 00:00:00 | South Africa & Common | Day of Goodwill
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 8 - Table 2

Ambev Brazil results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 113725.5735464012 | 0 | 0 | 234.8796023964096 | 113960.4531487976 | 0.002065319128072618 | 0.0020653191280726
Net revenue | 17146.522 | 0 | 0 | 1470.415000000001 | 18616.937 | 0.08575587515648952 | 0.08575587515648951
Net revenue/hl | 150.7710312228415 | 0 | 0 | 12.59210472127387 | 163.3631359441153 | 0.08351806457211652 | 0.08351806457211652
[NAME] | -5420.946 | -8.981 | 0 | -250.229000000001 | -5680.156000000001 | 0.04781637743670597 | 0.04608330830230332
[NAME]/hl | -47.66690403006146 | -0.07897080419062519 | 0 | -2.097345713348318 | -49.84322054760041 | 0.04565676252366724 | 0.04392726535285343
Gross profit | 11725.576 | -8.981 | 0 | 1220.186 | 12936.781 | 0.103295991599901 | 0.1041416896291115
Gross margin | 0.6838457385118685 | 0 | 0 | 0 | 0.6948930965389204 | 110 | 120
SG&A excl. deprec.&amort. | -4397.724 | 0 | 0 | -207.9369999999999 | -4605.661 | 0.04728286722859365 | 0.04728286722859368
SG&A deprec.&amort. | -468.189 | 18.767 | 0 | 49.00699999999995 | -400.415 | -0.1447577794437716 | -0.1090445060544432
SG&A total | -4865.913 | 18.767 | 0 | -158.9299999999986 | -5006.075999999999 | 0.02880507727943327 | 0.03278836659758105
Other operating income | 634.208 | -125.996 | 0 | 268.1380000000001 | 776.3500000000001 | 0.2241252081336094 | 0.5276105247416436
Normalized EBIT | 7493.871 | -116.21 | 0 | 1329.394000000001 | 8707.055000000002 | 0.1618901633081222 | 0.1801917979153558
Normalized EBIT margin | 0.4370490411991423 | 0 | 0 | 0 | 0.4676953571900684 | 310 | 370
Normalized EBITDA | 8490.633 | -125.996 | 0 | 1286.228 | 9650.865 | 0.1366484689657415 | 0.1537697332233305
Normalized EBITDA margin | 0.4951810635416325 | 0 | 0 | 0 | 0.5183916666850191 | 230 | 310
Spreadsheet: 822549d1679413312-match-person-based-on-date-postcode-to-a-location-date-postcode-copy-of-v-matchmaker-1-
Sheet: Raw data

Date | Location | Locum | Postcode | [NAME] | l1
2023-01-01 00:00:00 | Ashborn |  | DE
2023-01-01 00:00:00 |  | [NAME] | NG
2023-01-02 00:00:00 | Thorn |  | CF
2023-01-02 00:00:00 |  | Georgia | CF
2023-01-02 00:00:00 | Weymouth |  | DT
2023-01-02 00:00:00 |  | [NAME] | DT
2023-01-21 00:00:00 | [NAME] |  | NR
2023-01-21 00:00:00 |  | Ellie | NR
2023-01-23 00:00:00 |  | [NAME] | B
2023-01-23 00:00:00 | Swansea |  | SA
2023-01-24 00:00:00 |  | [NAME] | B
2023-01-24 00:00:00 | Cardigan |  | SA
2023-01-28 00:00:00 | [NAME] |  | NR
2023-01-28 00:00:00 |  | Ellie | NR
2023-02-06 00:00:00 | Plymouth |  | PL
2023-02-06 00:00:00 |  | Freddie | PL
2023-02-07 00:00:00 | Plymouth |  | PL
2023-02-07 00:00:00 |  | Freddie | PL
2023-02-08 00:00:00 | Plymouth |  | PL
2023-02-08 00:00:00 |  | Freddie | PL
2023-02-09 00:00:00 | Plymouth |  | PL
2023-02-09 00:00:00 |  | Freddie | PL
2023-02-10 00:00:00 | Plymouth |  | PL
2023-02-10 00:00:00 |  | Freddie | PL
2023-02-13 00:00:00 | Plymouth |  | PL
2023-02-13 00:00:00 |  | Freddie | PL
2023-02-14 00:00:00 | Plymouth |  | PL
2023-02-14 00:00:00 |  | Freddie | PL
2023-02-15 00:00:00 | Plymouth |  | PL
2023-02-15 00:00:00 |  | Freddie | PL
2023-02-16 00:00:00 | Plymouth |  | PL
2023-02-17 00:00:00 | Plymouth |  | PL
2023-03-17 00:00:00 | [NAME] |  | DD
2023-03-17 00:00:00 | [NAME] |  | DE
2023-03-17 00:00:00 | newport |  | NP
2023-03-17 00:00:00 | Dereham |  | NR
2023-03-17 00:00:00 | [NAME] |  | NR
2023-03-17 00:00:00 | Peterborough |  | PE
2023-03-17 00:00:00 | Devonport |  | PL
2023-03-17 00:00:00 | Torpoint |  | PL
2023-03-17 00:00:00 | Portsmouth |  | PO
2023-03-17 00:00:00 | Goring |  | RG
2023-03-17 00:00:00 | Pang |  | RG
2023-03-17 00:00:00 | Hayward |  | RH
2023-03-18 00:00:00 | Dundee |  | DD
2023-03-18 00:00:00 | BoNess |  | EH
2023-03-18 00:00:00 | Currie |  | EH
2023-03-18 00:00:00 | Dunbar |  | EH
2023-03-18 00:00:00 | Tranent |  | EH
2023-03-18 00:00:00 | Alloa |  | FK
2023-03-18 00:00:00 | Flkirk |  | FK
2023-03-18 00:00:00 | Kirkcaldy A |  | KY
2023-03-18 00:00:00 | Kirkcaldy B |  | KY
2023-03-18 00:00:00 | GlasgowPA |  | PA
2023-03-18 00:00:00 | York st |  | PH
2023-03-18 00:00:00 | York st |  | PH
2023-03-25 00:00:00 | Arbroath |  | DD
2023-03-25 00:00:00 |  | [NAME] | DD
2023-04-01 00:00:00 | Arbroath |  | DD
2023-04-06 00:00:00 | Auchterarder |  | PH
2023-04-07 00:00:00 | Auchterarder |  | PH
2023-04-08 00:00:00 | Arbroath |  | DD
2023-04-11 00:00:00 | Arbroath |  | DD
2023-04-13 00:00:00 | Arbroath |  | DD
2023-04-14 00:00:00 | Arbroath |  | DD
2023-04-15 00:00:00 | Arbroath |  | DD
2023-04-22 00:00:00 | Arbroath |  | DD
2023-04-29 00:00:00 | Arbroath |  | DD
2023-05-02 00:00:00 | Arbroath |  | DD
2023-05-03 00:00:00 | Arbroath |  | DD
2023-05-04 00:00:00 | Arbroath |  | DD
2023-05-05 00:00:00 | Arbroath |  | DD
Spreadsheet: 52493d1252282360-adding-up-currencies-if-adjacent-row-is-not-blank-currency-test
Sheet: Sheet1

 |  |  |  |  | Currency | Value |  |  | Refund ID
 |  |  |  |  | CAD | 1000 |  |  | #1001
 |  |  |  |  | CAD | 1000 |  |  | 1
 |  |  |  |  | CAD | 1000 |  |  | 2
 |  |  |  |  | CAD | 1000
 |  |  |  |  | CAD | 1000
 |  |  |  |  | USD | 1000
 |  |  |  |  | USD | 1000
 |  |  |  |  | USD | 1000
 |  |  |  |  | USD | 1000
 |  |  |  |  | USD | 1000
 |  |  |  |  | GBP | 1000
 |  |  |  |  | GBP | 1000
 |  |  |  |  | GBP | 1000
 |  |  |  |  | GBP | 1000
 |  |  |  |  | GBP | 1000
 | Canadian Dollars | CAD | 5000
 | US Dollars | USD | 5000
 | GBP | GBP | 5000
 |  | CAD | 3000
 |  | USD | 3000
 |  | GBP | 3000
Spreadsheet: 865325d1712348946-cant-find-the-top-5-least-frequent-numbers-in-a-list-roulette-game-night-tracker
Sheet: Sheet2

 |  |  |  | 1 | 1 | 2 | 3 | 4 | 5
Num | [NAME] | MF Rank | LF Rank | Most [NAME] | [NAME]
10
10
10
10
1
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659
500046 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134
500528
500529
500619
INDEX
2002-01-31 00:00:00 |  |  | -550339.19
2002-01-31 00:00:00
CBS Volume
 |  |  | -42903
Spreadsheet: 115447d1311066349-budget-calc-help-2011budget
Sheet: June

2011 Budget
Payday |  |  |  |  | Amount
1st |  |  |  |  | 0
15th
Total Monthly
Expenses |  | Product |  |  | Amount |  | Paid? | Remainder
1st |  | Ring |  |  | 100 |  | False
 |  | Easynews |  |  | 15 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Verizon |  |  | 100 |  | False
 |  | Bi-Weekly Remainder
15th |  | Chase |  |  | 54 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Insurance |  |  | 120 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Bi-Weekly Remainder
Total Monthly
Total Remainder
Spreadsheet: 118642d1313821119-shorten-formula-to-avoid-maxing-of-cpu-master-budget
Sheet: Cashflow Forecast

Stage | Start date | Finish date | % | Total cost per stage | Payments | Running balance for project | Margin | Running Account Balance
Deposit | 2011-08-02 00:00:00 | 2011-08-04 00:00:00 | 0.075
Base |  | 2011-08-30 00:00:00 | 0.15
Frame |  | 2011-10-05 00:00:00 | 0.15
Enclosed |  | 2011-11-07 00:00:00 | 0.35
Fixing |  | 2012-02-01 00:00:00 | 0.2
Practical Completion |  | 2012-03-06 00:00:00
Calculations
Running account balance is calculated by 'Running Account Balance' of previous month PLUS 'Payment' Plus last stages 'Margin'
Minus 'Total cost for Stage'  minus 'Finance costs at 6%'
This modeling is based on having to pay for full stage expense on first day and not recouping cost until last day and incurring interest the whole time
Spreadsheet: 847103d1698181938-multiple-conditional-formatting-rules-applied-to-same-cell-anonymous-2-geotech-major-project-schedule-2
Sheet: Schedule

 |  |  |  | UnavailableStaff |  | UnavailableStaff |  | UnavailableStaff |  | UnavailableStaff |  | UnavailableStaff |  | UnavailableStaff |  | UnavailableStaff
 |  |  |  |  | Client/Location                        +                      Equipment |  | Client/Location                                           +                      Equipment |  | Client/Location                        +                      Equipment |  | Client/Location                        +                      Equipment |  | Client/Location                        +                      Equipment |  | Client/Location                        +                      Equipment
 |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  | 2023-09-03 00:00:00 |  | 2023-09-04 00:00:00 |  | 2023-09-05 00:00:00 |  | 2023-09-06 00:00:00 |  | 2023-09-07 00:00:00 |  | 2023-09-08 00:00:00 |  | 2023-09-09 00:00:00
 | Auger (Truck)
 | R-38
 |  |  | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PT50
 | R-42
 |  |  | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT | est. | NIGHT SHIFT
 | Dual Rotary
 | R-54
 |  |  |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT
 | R-68
 |  |  |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT |  | NIGHT SHIFT
Spreadsheet: kate_symes__18809__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 |  |  |  |  |  | ..
Spreadsheet: 155464d1336859254-two-related-tables-billing-resources-help-1-for-gerainta
Sheet: Projects

Select Project: | Project A
 |  | 2012-06-04 00:00:00 | 2012-06-11 00:00:00 | 2012-06-18 00:00:00 | 2012-06-25 00:00:00 | 2012-07-02 00:00:00 | 2012-07-09 00:00:00 | 2012-07-16 00:00:00 | 2012-07-23 00:00:00 | 2012-07-30 00:00:00 | 2012-08-06 00:00:00 | 2012-08-13 00:00:00 | 2012-08-20 00:00:00 | 2012-08-27 00:00:00
 | Adam | 1
 | [NAME] | 2
 | Clive | 3
 | [NAME] | 4
 | [NAME] | 5