Do you keep backups to see your progress?

DarkSmile

Board Regular
Joined
Feb 22, 2021
Messages
90
Office Version
  1. 365
Platform
  1. Windows
Hello,

I was wondering if anyone else does this, for my job I created a file to do some stuff. This file is always a work in progress, so it changes constantly, of course to not lose/break it all I keep backups before doing anything.
But instead of overwriting the previous backup I make a new one, the file has been in progress since +1y now, and I'm pretty proud to see how I'm evolving in Excel.

Anyone else doing this?

How it started:
calcul food facturation.xlsx
ABCD
1Naam Auditor
2Datum Audit
3Offer nummer
4
5Audit :0
6Certificatie kosten Norm 1 - Prijzen 2019 :
7Verplaatsing-déplacement :Totaal audit uur
8nazicht actieplan -verif plan action :Totaal raportage tijd
9registratie kosten Norm 1 - frais d'enregistrement :Totaal preparation tijd
10extra certificaten :
11aantal hierboven x prijs per uur
12totaal :0
13
14
15
16
17
18
19Verplaatsing-déplacement (XX* aantal dagen)
20nazicht actieplan -verif plan action (altijd XX€)
Sheet1
Cell Formulas
RangeFormula
B5B5=D11
B12B12=SUM(B5:B10)


How it's now + vba code + buttons that aren't showing beneath

Calcul Facturatie -.xlsm
ABCDEFGHIJKLMNOPQRSTUV
1Naam AuditorMeerdere sites? standardAantal (zelfde norm)Preparation (hours)Reporting (hours)certification feeregistration feeTRUEPreparation (hours)Reporting (hours)Cell right is for clear functionNaam Auditor 
2Datum Audit<- Aantal sitesCell right is for Bepork searchTRUEDatum Audit00/01/1900
3Offer nummer<- Aantal verplaatsingenACS114€0/FALSEFALSEFALSENederlandsOffer nummer 
4vanaf 2de1/2€0/FALSEFALSEFALSENorm 1 audit uitgevoerd door bij op 30-12-1899 volgens offerte Klanten naam 
5Export China/Selecteer rapportage€0/FALSEFALSEFALSE
6Export Zuid-Korea/Selecteer rapportage€0/FALSEFALSEFALSEPO / Ref. :
7BVI/1€0/FALSEFALSEFALSE
8Febev+ rund/0€0€0FALSEFALSEFALSEAudit :0.00 EUR
9Febev+ varken/0€0/FALSEFALSEFALSECertificatiekosten Norm 1 - Prijzen 2021 :#N/A
10Bepork/Selecteer rapportage€0€0FALSEFALSEVerplaatsing :0.00 EUR
11Belplume /0€0€0FALSEFALSEFALSENazicht actieplan :0.00 EUR
12Totaal audit uurBRC28€0€0FALSEFALSEFALSERegistratiekosten Norm 1 :#N/A
13Totaal raportage tijd0ASDA/2€0€0FALSEFALSEFALSEExtra certificaten :0.00 EUR
14Totaal preparation tijd0Meat module/2€0€0FALSEFALSEFALSE
15FSMA/2€0€0FALSEFALSEFALSETotaal :#N/A
16Totaal hierboven0Gluten free/2€0€0FALSEFALSEFALSE
17BRC Packaging26€0€0FALSEFALSEFALSEFrans
18Aantal hierboven x prijs per uur0BRC S&D24€0€0FALSEFALSEFALSENorm 1 audit effectués par chez le 30-12-1899 suivant l'offre signée
19BRC Broker24€0€0FALSEFALSEFALSE
20COLRUYT/2€0/FALSEFALSEFALSEPO / Ref. :
21ISO 22000/4€0/FALSEFALSEFALSE
22surveillance/repeat/3//FALSEFALSEFALSEAudit :0.00 EUR
23FSSC2200025€0€0FALSEFALSEFALSEFrais de certification Norm 1 - Prix 2021 :#N/A
24surveillance/repeat24//FALSEFALSEFALSEDéplacement :0.00 EUR
25Head office/2//FALSEFALSEFALSEVerif plan action :0.00 EUR
26IFS25€0€0FALSEFALSEFALSEEnregistrement Norm 1 :#N/A
27IFS Broker24€0€0FALSEFALSEFALSECertificats supplémentaires :0.00 EUR
28IFS Whole Sale24€0€0FALSEFALSEFALSE
29IFS Logistics24€0€0FALSEFALSEFALSETotal :#N/A
30IFS C&C24€0€0FALSEFALSEFALSE
31IFS Global Markets13€0€0FALSEFALSEFALSEEngels
32GRMS/8€0€0FALSEFALSEFALSENorm 1 audit performed by at on 30-12-1899 according to quotation
33MSC/2€0/FALSEFALSEFALSE
34* IFS + BRC combi *212//FALSEFALSEFALSEPO / Ref. :
35
36Audit :0.00 EUR
37Export audit duurBerekeningRapportage tijdUitleg formules: Certification fee Norm 1 - Price 2021 :#N/A
38Export 3de landen30%0Kijkt welke grootste is in kolom O0Travel cost :0.00 EUR
39Telt alles in kolom P0Review action plan :0.00 EUR
40Alles word gecleared tot vak B39Kijkt of ISO surveillance is aangekliktFALSERegistration fee Norm 1 :#N/A
41Kosten 2021Kijkt of FSSC surveillance is aangekliktFALSESupplementary certificates :0.00 EUR
42Actieplan166Telt 30% van het export 3de audit duur0
43Verplaatsing binnenland per dag0Kijkt of Export 3de is aangekliktFALSETotal :#N/A
44Uur tarief166Kijkt of export is aangelikt indien ja toont hij het aantalFALSE
45Rond het export 3de landen getal af 0
46Uknown iets met ISOFALSE
47Uknown iets met FSSCFALSE
48Telt alle rapportages samen0
49Kijkt of er meerdere sites zijnFALSE
50Telt het aantal sites x prepFALSE
51Telt het aantal sites x actieplanFALSE
52Telt het aantal auditdagen0
53
54Export China lijst: Rapportage:True/FalseOutput:
55Selecteer rapportage0TRUE0
56Slachthuis (A)4FALSEFALSE
57Uitsnijderij (B)4FALSEFALSE
58Koel/Vrieshuis (C)2FALSEFALSE
59Slachthuis + Uitsnijderij (A+B)4FALSEFALSE
60Slachthuis + Uitsnijderij + Koel/Vrieshuis (A+B+C)4FALSEFALSE
61Uitsnijderij + Koel/Vrieshuis (B+C)4FALSEFALSE
62Slachthuis + Koel/Vrieshuis (A+C)4FALSEFALSE
63
64Export Zuid-Korea lijst: Rapportage:True/FalseOutput:
65Selecteer rapportage0TRUE0
66Slachthuis (A)3FALSEFALSE
67Uitsnijderij (B)3FALSEFALSE
68Koel/Vrieshuis (C)2FALSEFALSE
69Slachthuis + Uitsnijderij (A+B)4FALSEFALSE
70Slachthuis + Uitsnijderij + Koel/Vrieshuis (A+B+C)5FALSEFALSE
71Uitsnijderij + Koel/Vrieshuis (B+C)4FALSEFALSE
72Slachthuis + Koel/Vrieshuis (A+C)4FALSEFALSE
73Bereiding (D)2FALSEFALSE
74Uitsnijderij + Bereiding (B+D)4FALSEFALSE
75
76Bepork lijst: CertificationFeeRegistrationFeeAll in priceTrue/FalseOutput CertificationFee:Output RegistrationFee:Output All in price:
77Selecteer rapportage€0€0€0TRUE000
78BePork Slachthuis - Combi€0€113€0FALSEFALSEFALSEFALSE
79BePork Uitsnijderij - Combi€140€0€0FALSEFALSEFALSEFALSE
80BePork Slachthuis - Single€0€0€300FALSEFALSEFALSEFALSE
81BePork Uitsnijderij - Single€0€0€260FALSEFALSEFALSEFALSE
82
83Kosten 2021
84Actieplan0
85Verplaatsing binnenland per dag0
86Uur tarief0
87Verplaatsing Bepork Single0
88Actieplan Bepork Single0
Automatic Calculation 2021
Cell Formulas
RangeFormula
R4R4=VenA(R8:R13,$V$1:$V$4)
V1V1=$C$1 & ""
V2V2=$C$2
V3V3=$C$3 & ""
V4V4=$A$2 & ""
P3:P4,P7:P9,P11:P34P3=IF(N3,K3*I3)
P5P5=LOOKUP(1000,SEARCH($P$55:$P$62,N5),$Q$55:$Q$62)
P6P6=LOOKUP(1000,SEARCH($P$65:$P$74,N6),$Q$65:$Q$74)
O3:O34O3=IF(N3,J3)
S8,S36,S22S8=IF($R$80,$U$80,IF($R$81,$U$81,$D$18))
S9,S37,S23S9=LOOKUP(1000,SEARCH($H$3:$H$33,R9),$L$3:$L$33)
S10,S38,S24S10=IF($R$80,$T$80,$O$52)
S11,S39,S25S11=IF($R$80,$O$88,IF($R$81,$O$88,IF($O$49,$O$51,$O$84)))
S12,S40,S26S12=LOOKUP(1000,SEARCH($H$3:$H$33,R12),$M$3:$M$33)
D13D13=O48
D14D14=IF(O50,O50,O38)
S15,S43,S29S15=SUM(S8:S13)
D16D16=SUM(D12:D14)
D18D18=D16*L44
R18R18=VenAFR(R22:R27,$V$1:$V$4)
R32R32=VenAEN(R36:R41,$V$1:$V$4)
K38K38=O$45
O38O38=MAX(O$3:O$34)
O39O39=SUM(P$3:P$34)
O40O40=IF(P$22<P$21,P$22)
O41O41=IF(P$24<P$23,P$24)
O42O42=I$38/100*30
L43L43=IF($R$80,$O$87,IF($R$81,$O$87,$O$85))
O44O44=IF(O$43,O$42)
O45O45=IF(O$44<1,1,INT(O$44+0.5))
O46O46=IF(O$40,4)
O47O47=IF(O$41,5)
O48O48=O$39+O$45-O$46-O$47
O50O50=IF(O49,O38*E2)
O51O51=IF($O$49,$L$42*$E$2)
O52O52=$E$3*$L$43
P55:P62P55=IF($K$5=N55,TRUE,FALSE)
Q55:Q62Q55=IF(P55,O55*$I$5)
P65:P74P65=IF($K$6=N65,TRUE,FALSE)
Q65:Q74Q65=IF(P65,O65*$I$6)
R77:R81R77=IF($K$10=N77,TRUE,FALSE)
S77:S81S77=IF(R77,O77)
T77:T81T77=IF(R77,P77)
U77:U81U77=IF(R77,Q77)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
S36Cell Valuebeginning with "0"textNO
S37,S40Cellcontains an errortextNO
S38Cell Value=0textNO
S22Cell Valuebeginning with "0"textNO
S23,S26Cellcontains an errortextNO
S24Cell Value=0textNO
S43Cellcontains an errortextNO
S29Cellcontains an errortextNO
S15Cellcontains an errortextNO
S8Cell Valuebeginning with "0"textNO
S9,S12Cellcontains an errortextNO
S10Cell Value=0textNO
H40Cell Valuecontains "FALSE"textNO
H40Cell Valuecontains "TRUE"textNO
I41Other TypeColor scaleNO
Cells with Data Validation
CellAllowCriteria
K5List=$N$55:$N$62
K6List=$N$65:$N$74
K10List=$N$77:$N$81
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
When i was working , i used to do this all the time, with excel and presentations PPT often
using the Date Backwards as a reference
so today would be
20210309
This ensured if i ordered the files by name , they would be in date order, which did not always align with the creation or modified date
Some times even added the time, as the directors often changed their minds and frequently enough i had to revert to a previous version which was time dependant

I still keep a budget spreadsheet which is updated monthly and again I save with a new date 20210301 for 1st of month , as i update
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,305
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top